14: g_new_cc_header_id NUMBER;
15:
16: -- g_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.VALUE('IGC_DEBUG_ENABLED'),'N');
17: g_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
18: --following variables added for bug 3199488: fnd logging changes: sdixit
19: g_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
20: g_state_level number := FND_LOG.LEVEL_STATEMENT;
21: g_proc_level number := FND_LOG.LEVEL_PROCEDURE;
22: g_event_level number := FND_LOG.LEVEL_EVENT;
15:
16: -- g_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.VALUE('IGC_DEBUG_ENABLED'),'N');
17: g_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
18: --following variables added for bug 3199488: fnd logging changes: sdixit
19: g_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
20: g_state_level number := FND_LOG.LEVEL_STATEMENT;
21: g_proc_level number := FND_LOG.LEVEL_PROCEDURE;
22: g_event_level number := FND_LOG.LEVEL_EVENT;
23: g_excep_level number := FND_LOG.LEVEL_EXCEPTION;
16: -- g_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.VALUE('IGC_DEBUG_ENABLED'),'N');
17: g_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
18: --following variables added for bug 3199488: fnd logging changes: sdixit
19: g_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
20: g_state_level number := FND_LOG.LEVEL_STATEMENT;
21: g_proc_level number := FND_LOG.LEVEL_PROCEDURE;
22: g_event_level number := FND_LOG.LEVEL_EVENT;
23: g_excep_level number := FND_LOG.LEVEL_EXCEPTION;
24: g_error_level number := FND_LOG.LEVEL_ERROR;
17: g_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
18: --following variables added for bug 3199488: fnd logging changes: sdixit
19: g_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
20: g_state_level number := FND_LOG.LEVEL_STATEMENT;
21: g_proc_level number := FND_LOG.LEVEL_PROCEDURE;
22: g_event_level number := FND_LOG.LEVEL_EVENT;
23: g_excep_level number := FND_LOG.LEVEL_EXCEPTION;
24: g_error_level number := FND_LOG.LEVEL_ERROR;
25: g_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
18: --following variables added for bug 3199488: fnd logging changes: sdixit
19: g_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
20: g_state_level number := FND_LOG.LEVEL_STATEMENT;
21: g_proc_level number := FND_LOG.LEVEL_PROCEDURE;
22: g_event_level number := FND_LOG.LEVEL_EVENT;
23: g_excep_level number := FND_LOG.LEVEL_EXCEPTION;
24: g_error_level number := FND_LOG.LEVEL_ERROR;
25: g_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
26: g_path varchar2(500) := 'igc.plsql.igcccpcb.igc_cc_copy_pkg.';
19: g_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
20: g_state_level number := FND_LOG.LEVEL_STATEMENT;
21: g_proc_level number := FND_LOG.LEVEL_PROCEDURE;
22: g_event_level number := FND_LOG.LEVEL_EVENT;
23: g_excep_level number := FND_LOG.LEVEL_EXCEPTION;
24: g_error_level number := FND_LOG.LEVEL_ERROR;
25: g_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
26: g_path varchar2(500) := 'igc.plsql.igcccpcb.igc_cc_copy_pkg.';
27:
20: g_state_level number := FND_LOG.LEVEL_STATEMENT;
21: g_proc_level number := FND_LOG.LEVEL_PROCEDURE;
22: g_event_level number := FND_LOG.LEVEL_EVENT;
23: g_excep_level number := FND_LOG.LEVEL_EXCEPTION;
24: g_error_level number := FND_LOG.LEVEL_ERROR;
25: g_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
26: g_path varchar2(500) := 'igc.plsql.igcccpcb.igc_cc_copy_pkg.';
27:
28:
21: g_proc_level number := FND_LOG.LEVEL_PROCEDURE;
22: g_event_level number := FND_LOG.LEVEL_EVENT;
23: g_excep_level number := FND_LOG.LEVEL_EXCEPTION;
24: g_error_level number := FND_LOG.LEVEL_ERROR;
25: g_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
26: g_path varchar2(500) := 'igc.plsql.igcccpcb.igc_cc_copy_pkg.';
27:
28:
29: -- ------------------------------------------------------------------------------
219: IF g_unexp_level >= g_debug_level THEN
220: fnd_message.set_name('IGC','IGC_LOGGING_UNEXP_ERROR');
221: fnd_message.set_token('CODE',SQLCODE);
222: fnd_message.set_token('MESG',SQLERRM);
223: fnd_log.message(g_unexp_level,l_full_path,TRUE);
224: END IF;
225: RETURN;
226:
227: END Acct_Line_Copy;
354: IF g_unexp_level >= g_debug_level THEN
355: fnd_message.set_name('IGC','IGC_LOGGING_UNEXP_ERROR');
356: fnd_message.set_token('CODE',SQLCODE);
357: fnd_message.set_token('MESG',SQLERRM);
358: fnd_log.message(g_unexp_level,l_full_path,TRUE);
359: END IF;
360: RETURN;
361:
362: END Det_Pf_Line_Copy;
443: IF g_unexp_level >= g_debug_level THEN
444: fnd_message.set_name('IGC','IGC_LOGGING_UNEXP_ERROR');
445: fnd_message.set_token('CODE',SQLCODE);
446: fnd_message.set_token('MESG',SQLERRM);
447: fnd_log.message(g_unexp_level,l_full_path,TRUE);
448: END IF;
449: RETURN;
450:
451: END Access_Copy;
884: RETURN;
885:
886: END Header_Copy;
887:
888: /*modifed for 3199488 - fnd logging changes*/
889: PROCEDURE Put_Debug_Msg (
890: p_path IN VARCHAR2,
891: p_debug_msg IN VARCHAR2,
892: p_sev_level IN VARCHAR2 := g_state_level
893: ) IS
894: BEGIN
895:
896: IF p_sev_level >= g_debug_level THEN
897: fnd_log.string(p_sev_level, p_path, p_debug_msg);
898: END IF;
899: END;
900: /*************
901: PROCEDURE Put_Debug_Msg (