USP_BBNC_ADDTRANSACTIONDOWNLOADEXCEPTION

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@CHANGEAGENTID	uniqueidentifier	IN
@CHANGEDATE	datetime	IN
@BBNCTRANID	int	IN
@TRANSACTIONFIELDS	xml	IN
@BATCHTEMPLATEID	uniqueidentifier	IN
@EXCEPTIONMESSAGE	nvarchar(1024)	IN
@WEBHEALTHINFORMATION	nvarchar(4000)	IN
@PROCESSORID	uniqueidentifier	IN

Definition

Copy



        CREATE procedure dbo.USP_BBNC_ADDTRANSACTIONDOWNLOADEXCEPTION
        (
          @ID uniqueidentifier = null output,
          @CHANGEAGENTID uniqueidentifier,
                  @CHANGEDATE datetime,
          @BBNCTRANID int = 0,
            @TRANSACTIONFIELDS xml = null,
          @BATCHTEMPLATEID uniqueidentifier = null,
            @EXCEPTIONMESSAGE nvarchar(1024) = '',
          @WEBHEALTHINFORMATION nvarchar(4000) = '',
          @PROCESSORID uniqueidentifier
        )
        as
        begin
          set nocount on

          if @ID is null
            set @ID = newid()

                  if @CHANGEAGENTID is null
                      exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

                  if @CHANGEDATE is null
                      set @CHANGEDATE = getdate()

          begin try
              insert into dbo.BBNCTRANSACTIONDOWNLOADEXCEPTION
                  (ID, BBNCTRANID, TRANSACTIONFIELDS, BATCHTEMPLATEID, EXCEPTIONMESSAGE, WEBHEALTHINFORMATION, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED, PROCESSORID)
            values
                  (@ID, @BBNCTRANID, @TRANSACTIONFIELDS, @BATCHTEMPLATEID, @EXCEPTIONMESSAGE, @WEBHEALTHINFORMATION, @CHANGEAGENTID, @CHANGEAGENTID, @CHANGEDATE, @CHANGEDATE, @PROCESSORID)
          end try

          begin catch
              exec dbo.USP_RAISE_ERROR
              return 1
          end catch
        end