69: ,p_message IN VARCHAR2
70: ) IS
71: BEGIN
72: IF (p_log_level >= G_CURRENT_DEBUG_LEVEL ) THEN
73: IF NVL(FND_GLOBAL.conc_request_id, -1) <> -1 THEN
74: FND_FILE.put_line(which => FND_FILE.LOG
75: ,buff => '['||G_PKG_NAME||' - '||p_module||'] - '||p_message);
76: ELSE
77: fnd_log.string(log_level => p_log_level
236: ----------------------------------------------------------------------
237:
238: PROCEDURE SetGlobals IS
239: BEGIN
240: G_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
241: G_PROGAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
242: G_PROGAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
243: G_USER_NAME := FND_GLOBAL.USER_NAME;
244: G_USER_ID := FND_GLOBAL.USER_ID;
237:
238: PROCEDURE SetGlobals IS
239: BEGIN
240: G_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
241: G_PROGAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
242: G_PROGAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
243: G_USER_NAME := FND_GLOBAL.USER_NAME;
244: G_USER_ID := FND_GLOBAL.USER_ID;
245: G_LOGIN_ID := FND_GLOBAL.LOGIN_ID;
238: PROCEDURE SetGlobals IS
239: BEGIN
240: G_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
241: G_PROGAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
242: G_PROGAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
243: G_USER_NAME := FND_GLOBAL.USER_NAME;
244: G_USER_ID := FND_GLOBAL.USER_ID;
245: G_LOGIN_ID := FND_GLOBAL.LOGIN_ID;
246: G_CURRENT_DEBUG_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
239: BEGIN
240: G_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
241: G_PROGAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
242: G_PROGAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
243: G_USER_NAME := FND_GLOBAL.USER_NAME;
244: G_USER_ID := FND_GLOBAL.USER_ID;
245: G_LOGIN_ID := FND_GLOBAL.LOGIN_ID;
246: G_CURRENT_DEBUG_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
247: END;
240: G_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
241: G_PROGAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
242: G_PROGAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
243: G_USER_NAME := FND_GLOBAL.USER_NAME;
244: G_USER_ID := FND_GLOBAL.USER_ID;
245: G_LOGIN_ID := FND_GLOBAL.LOGIN_ID;
246: G_CURRENT_DEBUG_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
247: END;
248:
241: G_PROGAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
242: G_PROGAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
243: G_USER_NAME := FND_GLOBAL.USER_NAME;
244: G_USER_ID := FND_GLOBAL.USER_ID;
245: G_LOGIN_ID := FND_GLOBAL.LOGIN_ID;
246: G_CURRENT_DEBUG_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
247: END;
248:
249: ----------------------------------------------------------------------
457: G_UNHANDLED_EXCEPTION EXCEPTION;
458: l_target_entity_sql VARCHAR2(5000);
459: l_excluded_ag_list VARCHAR2(1000);
460: l_gtinval_ret_code VARCHAR2(1);
461: l_user_id NUMBER := FND_GLOBAL.USER_ID;
462: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
463: l_privilege_predicate_api_name VARCHAR2(1000);
464: l_item_sup_dl_id NUMBER;
465: l_item_sup_site_dl_id NUMBER;
458: l_target_entity_sql VARCHAR2(5000);
459: l_excluded_ag_list VARCHAR2(1000);
460: l_gtinval_ret_code VARCHAR2(1);
461: l_user_id NUMBER := FND_GLOBAL.USER_ID;
462: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
463: l_privilege_predicate_api_name VARCHAR2(1000);
464: l_item_sup_dl_id NUMBER;
465: l_item_sup_site_dl_id NUMBER;
466: l_item_sup_site_org_dl_id NUMBER;
3592: ,PROG_INT_NUM2 = NULL
3593: ,PROG_INT_NUM3 = NULL
3594: ,PROG_INT_CHAR1 = 'N'
3595: ,PROG_INT_CHAR2 = 'N'
3596: ,REQUEST_ID = FND_GLOBAL.CONC_REQUEST_ID
3597: ,PROGRAM_APPLICATION_ID = FND_GLOBAL.PROG_APPL_ID
3598: ,PROGRAM_ID = FND_GLOBAL.CONC_PROGRAM_ID
3599: ,PROGRAM_UPDATE_DATE = SYSDATE
3600: WHERE PROCESS_STATUS = p_dest_process_status
3593: ,PROG_INT_NUM3 = NULL
3594: ,PROG_INT_CHAR1 = 'N'
3595: ,PROG_INT_CHAR2 = 'N'
3596: ,REQUEST_ID = FND_GLOBAL.CONC_REQUEST_ID
3597: ,PROGRAM_APPLICATION_ID = FND_GLOBAL.PROG_APPL_ID
3598: ,PROGRAM_ID = FND_GLOBAL.CONC_PROGRAM_ID
3599: ,PROGRAM_UPDATE_DATE = SYSDATE
3600: WHERE PROCESS_STATUS = p_dest_process_status
3601: AND DATA_SET_ID = p_dest_data_set_id
3594: ,PROG_INT_CHAR1 = 'N'
3595: ,PROG_INT_CHAR2 = 'N'
3596: ,REQUEST_ID = FND_GLOBAL.CONC_REQUEST_ID
3597: ,PROGRAM_APPLICATION_ID = FND_GLOBAL.PROG_APPL_ID
3598: ,PROGRAM_ID = FND_GLOBAL.CONC_PROGRAM_ID
3599: ,PROGRAM_UPDATE_DATE = SYSDATE
3600: WHERE PROCESS_STATUS = p_dest_process_status
3601: AND DATA_SET_ID = p_dest_data_set_id
3602: AND TRANSACTION_TYPE = p_dest_transaction_type