3:
4: /*Global Variables - Start*/
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IGC_UPGRADE_DATA_R12';
7: g_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
8: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
9: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
10: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
11: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
4: /*Global Variables - Start*/
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IGC_UPGRADE_DATA_R12';
7: g_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
8: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
9: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
10: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
11: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
12: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IGC_UPGRADE_DATA_R12';
7: g_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
8: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
9: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
10: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
11: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
12: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
13: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IGC_UPGRADE_DATA_R12';
7: g_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
8: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
9: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
10: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
11: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
12: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
13: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;
14: g_path VARCHAR2(255) := 'IGC.PLSQL.IGCUPGDB.IGC_UPGRADE_DATA_R12.';
7: g_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
8: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
9: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
10: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
11: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
12: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
13: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;
14: g_path VARCHAR2(255) := 'IGC.PLSQL.IGCUPGDB.IGC_UPGRADE_DATA_R12.';
15: g_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
8: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
9: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
10: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
11: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
12: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
13: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;
14: g_path VARCHAR2(255) := 'IGC.PLSQL.IGCUPGDB.IGC_UPGRADE_DATA_R12.';
15: g_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
16: g_sob_id NUMBER := 0;
9: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
10: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
11: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
12: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
13: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;
14: g_path VARCHAR2(255) := 'IGC.PLSQL.IGCUPGDB.IGC_UPGRADE_DATA_R12.';
15: g_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
16: g_sob_id NUMBER := 0;
17: g_sob_name VARCHAR2(50) := NULL;
2226: p_debug_msg IN VARCHAR2
2227: ) IS
2228: BEGIN
2229: IF(g_state_level >= g_debug_level) THEN
2230: FND_LOG.STRING(g_state_level, p_path, p_debug_msg);
2231: END IF;
2232: RETURN;
2233: EXCEPTION
2234: WHEN OTHERS THEN