APPS.M4R_7B1_WSM_IN dependencies on MTL_TRANSACTIONS_INTERFACE

Line 3008: g_exception_tracking_msg := 'Inserting values into MTL_TRANSACTIONS_INTERFACE';

3004: IF (g_debug_level <= 1) THEN
3005: cln_debug_pub.Add('transfer_to org_id : '|| l_org_id,1);
3006: END IF;
3007:
3008: g_exception_tracking_msg := 'Inserting values into MTL_TRANSACTIONS_INTERFACE';
3009:
3010: INSERT
3011: INTO MTL_TRANSACTIONS_INTERFACE ( SOURCE_CODE,
3012: SOURCE_LINE_ID,

Line 3011: INTO MTL_TRANSACTIONS_INTERFACE ( SOURCE_CODE,

3007:
3008: g_exception_tracking_msg := 'Inserting values into MTL_TRANSACTIONS_INTERFACE';
3009:
3010: INSERT
3011: INTO MTL_TRANSACTIONS_INTERFACE ( SOURCE_CODE,
3012: SOURCE_LINE_ID,
3013: SOURCE_HEADER_ID,
3014: PROCESS_FLAG,
3015: TRANSACTION_MODE,

Line 3081: cln_debug_pub.Add('-------- Values successfully inserted into MTL_TRANSACTIONS_INTERFACE --------',1);

3077: 2,
3078: 2);
3079:
3080: IF (g_debug_level <= 1) THEN
3081: cln_debug_pub.Add('-------- Values successfully inserted into MTL_TRANSACTIONS_INTERFACE --------',1);
3082: END IF;
3083:
3084: g_exception_tracking_msg := 'Inserting values into MTL_TRANSACTION_LOTS_INTERFACE';
3085:

Line 3863: g_exception_tracking_msg := 'Querying MTL_TRANSACTIONS_INTERFACE for Errors';

3859: END IF;
3860:
3861: BEGIN
3862:
3863: g_exception_tracking_msg := 'Querying MTL_TRANSACTIONS_INTERFACE for Errors';
3864:
3865: SELECT PROCESS_FLAG,ERROR_CODE,ERROR_EXPLANATION
3866: INTO l_interface_status,l_err_code,l_err_msg
3867: FROM MTL_TRANSACTIONS_INTERFACE

Line 3867: FROM MTL_TRANSACTIONS_INTERFACE

3863: g_exception_tracking_msg := 'Querying MTL_TRANSACTIONS_INTERFACE for Errors';
3864:
3865: SELECT PROCESS_FLAG,ERROR_CODE,ERROR_EXPLANATION
3866: INTO l_interface_status,l_err_code,l_err_msg
3867: FROM MTL_TRANSACTIONS_INTERFACE
3868: WHERE TRANSACTION_INTERFACE_ID = l_parent_id;
3869:
3870: IF (g_debug_level <= 1) THEN
3871: cln_debug_pub.Add('l_interface_status : ' || l_interface_status, 1);