MOBILE_API/DB/SPs/ws_int_proc_responseLog.sql

��USE [FastMoneyPro_Remit]
GO
/****** Object:  StoredProcedure [dbo].[ws_int_proc_responseLog]    Script Date: 9/27/2019 1:30:14 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE proc [dbo].[ws_int_proc_responseLog]
	 @flag			VARCHAR(10)		= NULL
	,@requestId		BIGINT			= NULL
	,@errorCode		VARCHAR(10)		= NULL
	,@errorMsg		VARCHAR(MAX)	= NULL

AS

SET NOCOUNT ON

/*
	s - Standard Send
	u - SMA USA Send
	o - Other Methods
	sp_helptext ws_int_proc_responseLog
*/

IF @flag = 's'
BEGIN
	UPDATE apiRequestLog SET
		 errorCode			= @errorCode
		,errorMsg			= @errorMsg
	WHERE rowId = @requestId
	
	RETURN
END

IF @flag = 'u'
BEGIN
	UPDATE apiRequestLogSMA SET
		 errorCode			= @errorCode
		,errorMsg			= @errorMsg
	WHERE rowId = @requestId
	
	RETURN
END

IF @flag = 'o'
BEGIN
	UPDATE requestApiLogOther SET
		 errorCode			= @errorCode
		,errorMsg			= @errorMsg
	WHERE rowId = @requestId
	
	RETURN
END


GO