USP_BBWORKFLOW_ADD_LOG_MESSAGE

Creates a row in the dbo.BBWORKFLOWLOG table with the given message.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@CHANGEAGENTID	uniqueidentifier	IN
@BBWORKFLOWINSTANCEINFOID	uniqueidentifier	IN
@LOGTYPECODE	tinyint	IN
@LOGMESSAGE	nvarchar(3000)	IN
@SOURCECODE	tinyint	IN

Definition

Copy



CREATE procedure [dbo].[USP_BBWORKFLOW_ADD_LOG_MESSAGE]

-- Creates a row in the dbo.BBWORKFLOWLOG table with the given message.


  @ID uniqueidentifier = null output,
  @CHANGEAGENTID uniqueidentifier = null,
  @BBWORKFLOWINSTANCEINFOID uniqueidentifier = null,
  @LOGTYPECODE tinyint = 0,
  @LOGMESSAGE nvarchar(3000) = '',
  @SOURCECODE tinyint = 0

as

set nocount on;

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

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

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


    insert into dbo.BBWORKFLOWLOG
        (ID,  BBWORKFLOWINSTANCEINFOID, LOGTYPECODE, LOGMESSAGE, ADDEDBYID, DATEADDED, SOURCECODE )
    values
        (@ID, @BBWORKFLOWINSTANCEINFOID, @LOGTYPECODE, @LOGMESSAGE, @CHANGEAGENTID, @CURRENTDATE, @SOURCECODE );