1: PACKAGE BODY igidosl AS
2: -- $Header: igidoslb.pls 120.26.12000000.5 2007/07/02 05:00:40 pshivara ship $
3: --
4:
5: /* ============== FND LOG VARIABLES ================== */
6: l_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL ;
7: l_state_level number := FND_LOG.LEVEL_STATEMENT ;
8: l_proc_level number := FND_LOG.LEVEL_PROCEDURE ;
9: l_event_level number := FND_LOG.LEVEL_EVENT ;
2: -- $Header: igidoslb.pls 120.26.12000000.5 2007/07/02 05:00:40 pshivara ship $
3: --
4:
5: /* ============== FND LOG VARIABLES ================== */
6: l_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL ;
7: l_state_level number := FND_LOG.LEVEL_STATEMENT ;
8: l_proc_level number := FND_LOG.LEVEL_PROCEDURE ;
9: l_event_level number := FND_LOG.LEVEL_EVENT ;
10: l_excep_level number := FND_LOG.LEVEL_EXCEPTION ;
3: --
4:
5: /* ============== FND LOG VARIABLES ================== */
6: l_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL ;
7: l_state_level number := FND_LOG.LEVEL_STATEMENT ;
8: l_proc_level number := FND_LOG.LEVEL_PROCEDURE ;
9: l_event_level number := FND_LOG.LEVEL_EVENT ;
10: l_excep_level number := FND_LOG.LEVEL_EXCEPTION ;
11: l_error_level number := FND_LOG.LEVEL_ERROR ;
4:
5: /* ============== FND LOG VARIABLES ================== */
6: l_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL ;
7: l_state_level number := FND_LOG.LEVEL_STATEMENT ;
8: l_proc_level number := FND_LOG.LEVEL_PROCEDURE ;
9: l_event_level number := FND_LOG.LEVEL_EVENT ;
10: l_excep_level number := FND_LOG.LEVEL_EXCEPTION ;
11: l_error_level number := FND_LOG.LEVEL_ERROR ;
12: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED ;
5: /* ============== FND LOG VARIABLES ================== */
6: l_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL ;
7: l_state_level number := FND_LOG.LEVEL_STATEMENT ;
8: l_proc_level number := FND_LOG.LEVEL_PROCEDURE ;
9: l_event_level number := FND_LOG.LEVEL_EVENT ;
10: l_excep_level number := FND_LOG.LEVEL_EXCEPTION ;
11: l_error_level number := FND_LOG.LEVEL_ERROR ;
12: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED ;
13:
6: l_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL ;
7: l_state_level number := FND_LOG.LEVEL_STATEMENT ;
8: l_proc_level number := FND_LOG.LEVEL_PROCEDURE ;
9: l_event_level number := FND_LOG.LEVEL_EVENT ;
10: l_excep_level number := FND_LOG.LEVEL_EXCEPTION ;
11: l_error_level number := FND_LOG.LEVEL_ERROR ;
12: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED ;
13:
14: /* ============== WORKFLOW VARAIBLES =================
7: l_state_level number := FND_LOG.LEVEL_STATEMENT ;
8: l_proc_level number := FND_LOG.LEVEL_PROCEDURE ;
9: l_event_level number := FND_LOG.LEVEL_EVENT ;
10: l_excep_level number := FND_LOG.LEVEL_EXCEPTION ;
11: l_error_level number := FND_LOG.LEVEL_ERROR ;
12: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED ;
13:
14: /* ============== WORKFLOW VARAIBLES =================
15: ## Variables for framing and coloring the Table.
8: l_proc_level number := FND_LOG.LEVEL_PROCEDURE ;
9: l_event_level number := FND_LOG.LEVEL_EVENT ;
10: l_excep_level number := FND_LOG.LEVEL_EXCEPTION ;
11: l_error_level number := FND_LOG.LEVEL_ERROR ;
12: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED ;
13:
14: /* ============== WORKFLOW VARAIBLES =================
15: ## Variables for framing and coloring the Table.
16: ## copied FROM WF_NOTIFICATION package
69: IF (P_error_type = 'DEFAULT') THEN
70: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
71: FND_MESSAGE.SET_TOKEN('CODE',sqlcode);
72: FND_MESSAGE.SET_TOKEN('MSG',sqlerrm);
73: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igidosl.' || P_module ,TRUE);
74: ELSIF (P_error_type = 'USER') THEN
75: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igidosl.' || P_module ,TRUE);
76: END IF;
77:
71: FND_MESSAGE.SET_TOKEN('CODE',sqlcode);
72: FND_MESSAGE.SET_TOKEN('MSG',sqlerrm);
73: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igidosl.' || P_module ,TRUE);
74: ELSIF (P_error_type = 'USER') THEN
75: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igidosl.' || P_module ,TRUE);
76: END IF;
77:
78: END IF;
79:
88:
89: BEGIN
90:
91: IF (P_level >= l_debug_level) THEN
92: FND_LOG.STRING(P_level, 'igi.plsql.igidosl.' || P_module, P_message) ;
93: END IF;
94:
95: END Debug_log_string;
96: