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: ----------------------------------------------------------------------
459: G_UNHANDLED_EXCEPTION EXCEPTION;
460: l_target_entity_sql VARCHAR2(5000);
461: l_excluded_ag_list VARCHAR2(1000);
462: l_gtinval_ret_code VARCHAR2(1);
463: l_user_id NUMBER := FND_GLOBAL.USER_ID;
464: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
465: l_privilege_predicate_api_name VARCHAR2(1000);
466: l_item_sup_dl_id NUMBER;
467: l_item_sup_site_dl_id NUMBER;
460: l_target_entity_sql VARCHAR2(5000);
461: l_excluded_ag_list VARCHAR2(1000);
462: l_gtinval_ret_code VARCHAR2(1);
463: l_user_id NUMBER := FND_GLOBAL.USER_ID;
464: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
465: l_privilege_predicate_api_name VARCHAR2(1000);
466: l_item_sup_dl_id NUMBER;
467: l_item_sup_site_dl_id NUMBER;
468: l_item_sup_site_org_dl_id NUMBER;
4359: ,PROG_INT_NUM2 = NULL
4360: ,PROG_INT_NUM3 = NULL
4361: ,PROG_INT_CHAR1 = 'N'
4362: ,PROG_INT_CHAR2 = 'N'
4363: ,REQUEST_ID = FND_GLOBAL.CONC_REQUEST_ID
4364: ,PROGRAM_APPLICATION_ID = FND_GLOBAL.PROG_APPL_ID
4365: ,PROGRAM_ID = FND_GLOBAL.CONC_PROGRAM_ID
4366: ,PROGRAM_UPDATE_DATE = SYSDATE
4367: WHERE PROCESS_STATUS = p_dest_process_status
4360: ,PROG_INT_NUM3 = NULL
4361: ,PROG_INT_CHAR1 = 'N'
4362: ,PROG_INT_CHAR2 = 'N'
4363: ,REQUEST_ID = FND_GLOBAL.CONC_REQUEST_ID
4364: ,PROGRAM_APPLICATION_ID = FND_GLOBAL.PROG_APPL_ID
4365: ,PROGRAM_ID = FND_GLOBAL.CONC_PROGRAM_ID
4366: ,PROGRAM_UPDATE_DATE = SYSDATE
4367: WHERE PROCESS_STATUS = p_dest_process_status
4368: AND DATA_SET_ID = p_dest_data_set_id
4361: ,PROG_INT_CHAR1 = 'N'
4362: ,PROG_INT_CHAR2 = 'N'
4363: ,REQUEST_ID = FND_GLOBAL.CONC_REQUEST_ID
4364: ,PROGRAM_APPLICATION_ID = FND_GLOBAL.PROG_APPL_ID
4365: ,PROGRAM_ID = FND_GLOBAL.CONC_PROGRAM_ID
4366: ,PROGRAM_UPDATE_DATE = SYSDATE
4367: WHERE PROCESS_STATUS = p_dest_process_status
4368: AND DATA_SET_ID = p_dest_data_set_id
4369: AND TRANSACTION_TYPE = p_dest_transaction_type