USP_AWARDMANAGEMENTINTEGRATIONERROR_ADD

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@BUSINESSPROCESSPARAMETERSETID	uniqueidentifier	IN
@BUSINESSPROCESSSTATUSID	uniqueidentifier	IN
@AWARDMANAGEMENTID	int	IN
@CONSTITUENTNAME	nvarchar(154)	IN
@CONSTITUENTEMAILADDRESS	nvarchar(100)	IN
@FUNDNAME	nvarchar(100)	IN
@DISBURSEMENTAMOUNT	decimal(18, 2)	IN
@AWARDACCEPTED	bit	IN
@ERRORMESSAGE	nvarchar(4000)	IN
@ERRORTIMESTAMP	datetime	IN

Definition

Copy



            create procedure dbo.USP_AWARDMANAGEMENTINTEGRATIONERROR_ADD
            (
                @ID uniqueidentifier = null output,
                @BUSINESSPROCESSPARAMETERSETID uniqueidentifier,
                @BUSINESSPROCESSSTATUSID uniqueidentifier,
                @AWARDMANAGEMENTID int,
                @CONSTITUENTNAME nvarchar(154),
                @CONSTITUENTEMAILADDRESS nvarchar(100),
                @FUNDNAME nvarchar(100),
                @DISBURSEMENTAMOUNT decimal(18, 2),
                @AWARDACCEPTED bit,
                @ERRORMESSAGE nvarchar(4000),
                @ERRORTIMESTAMP datetime
            )
            as
                set nocount on;

        begin try
            if @ID is null
                set @ID = newid();

            declare @CURRENTDATE datetime;
            set @CURRENTDATE = getdate();

            declare @CHANGEAGENTID uniqueidentifier
            exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

            insert into dbo.AWARDMANAGEMENTINTEGRATIONERROR 
            (
                ID,
                BUSINESSPROCESSPARAMETERSETID,
                BUSINESSPROCESSSTATUSID,
                AWARDMANAGEMENTID,
                CONSTITUENTNAME,
                CONSTITUENTEMAILADDRESS,
                FUNDNAME,
                DISBURSEMENTAMOUNT,
                AWARDACCEPTED,
                ERRORMESSAGE,
                ERRORTIMESTAMP,
                CHANGEDBYID,
                ADDEDBYID,
                DATECHANGED,
                DATEADDED
            )
            values 
            (
                @ID,
                @BUSINESSPROCESSPARAMETERSETID, 
                @BUSINESSPROCESSSTATUSID, 
                @AWARDMANAGEMENTID, 
                @CONSTITUENTNAME, 
                @CONSTITUENTEMAILADDRESS, 
                @FUNDNAME, 
                @DISBURSEMENTAMOUNT, 
                @AWARDACCEPTED, 
                isnull(@ERRORMESSAGE, ''), 
                @ERRORTIMESTAMP,
                @CHANGEAGENTID,
                @CHANGEAGENTID,
                @CURRENTDATE,
                @CURRENTDATE
            );

        end try
        begin catch
            exec dbo.USP_RAISE_ERROR;
            return 1;
        end catch

        return 0;