DECLARE @Err int 
    DECLARE @ErrorMessage NVARCHAR(4000);
    DECLARE @ErrorSeverity INT;
    DECLARE @ErrorState INT;

	SET @Err = 0
	BEGIN TRY
	   INSERT vw_Billing....
	   VALUES.....
	END TRY 
	BEGIN CATCH
		SET @Err = @@ERROR
		SELECT @ErrorMessage = ERROR_MESSAGE(),
			   @ErrorSeverity = ERROR_SEVERITY(),
			   @ErrorState = ERROR_STATE();

	END CATCH
        IF @Err = 2627 RETURN 0

	RAISERROR (@ErrorMessage,
		   @ErrorSeverity,
		   @ErrorState );

quote:

---

Msg 4457, Level 16, State 1, Procedure casp_InsertLaRbLevel1, Line 38
The attempted insert or update of the partitioned view failed because the value of the partitioning column does not belong to any of the partitions.

---

quote:

---

Msg 50000, Level 16, State 1, Procedure casp_InsertLaRbLevel1, Line 64
The attempted insert or update of the partitioned view failed because the value of the partitioning column does not belong to any of the partitions.

---