USP_IMPORTPROCESSEXCEPTION_ADD

Adds an import process exception to the database.

Parameters

Parameter	Parameter Type	Mode
@BUSINESSPROCESSSTATUSID	uniqueidentifier	IN
@MESSAGE	nvarchar(max)	IN
@CHANGEAGENTID	uniqueidentifier	IN
@ROWNUMBER	int	IN
@ROWDATA	nvarchar(max)	IN

Definition

Copy



CREATE procedure dbo.USP_IMPORTPROCESSEXCEPTION_ADD(@BUSINESSPROCESSSTATUSID uniqueidentifier,
    @MESSAGE nvarchar(max),
    @CHANGEAGENTID uniqueidentifier,
    @ROWNUMBER int = 0,
    @ROWDATA nvarchar(max) = '')
with execute as caller
as
    set nocount on;

    exec dbo.USP_GET_KEY_ACCESS;

    insert into dbo.IMPORTPROCESSEXCEPTION (BUSINESSPROCESSSTATUSID,
        ROWNUMBER,
        MESSAGE,
        ROWDATA,
        ROWDATAXML,
        ADDEDBYID,
        CHANGEDBYID,
        DATEADDED,
        DATECHANGED) 
    values (@BUSINESSPROCESSSTATUSID, 
        @ROWNUMBER,
        @MESSAGE,
        '',
        dbo.UFN_ENCRYPT_TEXTTOXML(@ROWDATA),
        @CHANGEAGENTID,
        @CHANGEAGENTID,
        getdate(),
        getdate());

        close symmetric key sym_BBInfinity;