DBA Data[Home] [Help]

APPS.IGI_EXP_APPROVAL_PKG dependencies on FND_LOG

Line 29: /* ============== FND LOG VARIABLES ================== */

25: td_fontcolor VARCHAR2(7) := '"black"';
26: td_fontface VARCHAR2(80) := '"Arial, Helvetica, Geneva, sans-serif"';
27: td_fontsize varchar2(2) := '2';
28:
29: /* ============== FND LOG VARIABLES ================== */
30: l_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL ;
31: l_state_level number := FND_LOG.LEVEL_STATEMENT ;
32: l_proc_level number := FND_LOG.LEVEL_PROCEDURE ;
33: l_event_level number := FND_LOG.LEVEL_EVENT ;

Line 30: l_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL ;

26: td_fontface VARCHAR2(80) := '"Arial, Helvetica, Geneva, sans-serif"';
27: td_fontsize varchar2(2) := '2';
28:
29: /* ============== FND LOG VARIABLES ================== */
30: l_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL ;
31: l_state_level number := FND_LOG.LEVEL_STATEMENT ;
32: l_proc_level number := FND_LOG.LEVEL_PROCEDURE ;
33: l_event_level number := FND_LOG.LEVEL_EVENT ;
34: l_excep_level number := FND_LOG.LEVEL_EXCEPTION ;

Line 31: l_state_level number := FND_LOG.LEVEL_STATEMENT ;

27: td_fontsize varchar2(2) := '2';
28:
29: /* ============== FND LOG VARIABLES ================== */
30: l_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL ;
31: l_state_level number := FND_LOG.LEVEL_STATEMENT ;
32: l_proc_level number := FND_LOG.LEVEL_PROCEDURE ;
33: l_event_level number := FND_LOG.LEVEL_EVENT ;
34: l_excep_level number := FND_LOG.LEVEL_EXCEPTION ;
35: l_error_level number := FND_LOG.LEVEL_ERROR ;

Line 32: l_proc_level number := FND_LOG.LEVEL_PROCEDURE ;

28:
29: /* ============== FND LOG VARIABLES ================== */
30: l_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL ;
31: l_state_level number := FND_LOG.LEVEL_STATEMENT ;
32: l_proc_level number := FND_LOG.LEVEL_PROCEDURE ;
33: l_event_level number := FND_LOG.LEVEL_EVENT ;
34: l_excep_level number := FND_LOG.LEVEL_EXCEPTION ;
35: l_error_level number := FND_LOG.LEVEL_ERROR ;
36: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED ;

Line 33: l_event_level number := FND_LOG.LEVEL_EVENT ;

29: /* ============== FND LOG VARIABLES ================== */
30: l_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL ;
31: l_state_level number := FND_LOG.LEVEL_STATEMENT ;
32: l_proc_level number := FND_LOG.LEVEL_PROCEDURE ;
33: l_event_level number := FND_LOG.LEVEL_EVENT ;
34: l_excep_level number := FND_LOG.LEVEL_EXCEPTION ;
35: l_error_level number := FND_LOG.LEVEL_ERROR ;
36: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED ;
37:

Line 34: l_excep_level number := FND_LOG.LEVEL_EXCEPTION ;

30: l_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL ;
31: l_state_level number := FND_LOG.LEVEL_STATEMENT ;
32: l_proc_level number := FND_LOG.LEVEL_PROCEDURE ;
33: l_event_level number := FND_LOG.LEVEL_EVENT ;
34: l_excep_level number := FND_LOG.LEVEL_EXCEPTION ;
35: l_error_level number := FND_LOG.LEVEL_ERROR ;
36: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED ;
37:
38: -- global variables for framing the table header.

Line 35: l_error_level number := FND_LOG.LEVEL_ERROR ;

31: l_state_level number := FND_LOG.LEVEL_STATEMENT ;
32: l_proc_level number := FND_LOG.LEVEL_PROCEDURE ;
33: l_event_level number := FND_LOG.LEVEL_EVENT ;
34: l_excep_level number := FND_LOG.LEVEL_EXCEPTION ;
35: l_error_level number := FND_LOG.LEVEL_ERROR ;
36: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED ;
37:
38: -- global variables for framing the table header.
39: l_table_head VARCHAR2(100);

Line 36: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED ;

32: l_proc_level number := FND_LOG.LEVEL_PROCEDURE ;
33: l_event_level number := FND_LOG.LEVEL_EVENT ;
34: l_excep_level number := FND_LOG.LEVEL_EXCEPTION ;
35: l_error_level number := FND_LOG.LEVEL_ERROR ;
36: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED ;
37:
38: -- global variables for framing the table header.
39: l_table_head VARCHAR2(100);
40: l_line_head VARCHAR2(100);

Line 63: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igiexab.igi_exp_approval_pkg.' || P_module ,TRUE);

59: IF (P_error_type = 'DEFAULT') THEN
60: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
61: FND_MESSAGE.SET_TOKEN('CODE',sqlcode);
62: FND_MESSAGE.SET_TOKEN('MSG',sqlerrm);
63: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igiexab.igi_exp_approval_pkg.' || P_module ,TRUE);
64: ELSIF (P_error_type = 'USER') THEN
65: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igiexab.igi_exp_approval_pkg.' || P_module ,TRUE);
66: END IF;
67:

Line 65: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igiexab.igi_exp_approval_pkg.' || P_module ,TRUE);

61: FND_MESSAGE.SET_TOKEN('CODE',sqlcode);
62: FND_MESSAGE.SET_TOKEN('MSG',sqlerrm);
63: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igiexab.igi_exp_approval_pkg.' || P_module ,TRUE);
64: ELSIF (P_error_type = 'USER') THEN
65: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igiexab.igi_exp_approval_pkg.' || P_module ,TRUE);
66: END IF;
67:
68: END IF;
69:

Line 71: 'Unexpected error occured. Please refer FND LOG for detailed ERROR message');

67:
68: END IF;
69:
70: wf_core.context ('IGI_EXP_APPROVAL_PKG','igi.plsql.igiexab.igi_exp_approval_pkg.'|| P_module,
71: 'Unexpected error occured. Please refer FND LOG for detailed ERROR message');
72:
73: EXCEPTION
74: WHEN OTHERS THEN
75: wf_core.context ('IGI_EXP_APPROVAL_PKG','Debug_log_unexp_error', 'ERROR IN FND LOGGING');

Line 75: wf_core.context ('IGI_EXP_APPROVAL_PKG','Debug_log_unexp_error', 'ERROR IN FND LOGGING');

71: 'Unexpected error occured. Please refer FND LOG for detailed ERROR message');
72:
73: EXCEPTION
74: WHEN OTHERS THEN
75: wf_core.context ('IGI_EXP_APPROVAL_PKG','Debug_log_unexp_error', 'ERROR IN FND LOGGING');
76: RAISE;
77:
78: END Debug_log_unexp_error;
79:

Line 90: FND_LOG.STRING(P_level, 'igi.plsql.igiexab.igi_exp_approval_pkg.' || P_module, P_message) ;

86:
87: BEGIN
88:
89: IF (P_level >= l_debug_level) THEN
90: FND_LOG.STRING(P_level, 'igi.plsql.igiexab.igi_exp_approval_pkg.' || P_module, P_message) ;
91: END IF;
92:
93: EXCEPTION
94: WHEN OTHERS THEN

Line 95: wf_core.context ('IGI_EXP_APPROVAL_PKG','Debug_log_string', 'ERROR IN FND LOGGING');

91: END IF;
92:
93: EXCEPTION
94: WHEN OTHERS THEN
95: wf_core.context ('IGI_EXP_APPROVAL_PKG','Debug_log_string', 'ERROR IN FND LOGGING');
96: RAISE;
97:
98: END Debug_log_string;
99: