DBA Data[Home] [Help]

APPS.IBY_EXT_WRAP_PUB dependencies on FND_LOG

Line 4: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1: PACKAGE BODY IBY_EXT_WRAP_PUB AS
2: /* $Header: ibyextwb.pls 120.2.12020000.2 2012/07/12 15:11:02 sgogula noship $ */
3:
4: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
6: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
7: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
8: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

Line 5: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

1: PACKAGE BODY IBY_EXT_WRAP_PUB AS
2: /* $Header: ibyextwb.pls 120.2.12020000.2 2012/07/12 15:11:02 sgogula noship $ */
3:
4: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
6: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
7: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
8: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
9: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

Line 6: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;

2: /* $Header: ibyextwb.pls 120.2.12020000.2 2012/07/12 15:11:02 sgogula noship $ */
3:
4: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
6: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
7: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
8: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
9: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
10: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

Line 7: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;

3:
4: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
6: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
7: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
8: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
9: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
10: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
11:

Line 8: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

4: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
6: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
7: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
8: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
9: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
10: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
11:
12:

Line 9: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

5: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
6: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
7: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
8: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
9: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
10: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
11:
12:
13: --Procedure to log messages to the concurrent log

Line 10: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

6: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
7: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
8: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
9: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
10: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
11:
12:
13: --Procedure to log messages to the concurrent log
14:

Line 16: p_debug_level IN VARCHAR2 DEFAULT FND_LOG.LEVEL_STATEMENT,

12:
13: --Procedure to log messages to the concurrent log
14:
15: PROCEDURE print_debuginfo(p_debug_text IN VARCHAR2,
16: p_debug_level IN VARCHAR2 DEFAULT FND_LOG.LEVEL_STATEMENT,
17: p_module IN VARCHAR2
18: )
19: IS
20: PRAGMA AUTONOMOUS_TRANSACTION;

Line 23: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

19: IS
20: PRAGMA AUTONOMOUS_TRANSACTION;
21:
22: BEGIN
23: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
24: IF (FND_GLOBAL.conc_request_id = -1) THEN
25: FND_LOG.STRING(G_LEVEL_STATEMENT,p_module, p_debug_text);
26: ELSE
27: FND_FILE.PUT_LINE(FND_FILE.LOG, p_module || ': ' || p_debug_text);

Line 25: FND_LOG.STRING(G_LEVEL_STATEMENT,p_module, p_debug_text);

21:
22: BEGIN
23: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
24: IF (FND_GLOBAL.conc_request_id = -1) THEN
25: FND_LOG.STRING(G_LEVEL_STATEMENT,p_module, p_debug_text);
26: ELSE
27: FND_FILE.PUT_LINE(FND_FILE.LOG, p_module || ': ' || p_debug_text);
28: END IF;
29: END IF;

Line 42: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

38: BEGIN
39: l_ins_ext_agg:= IBY_FD_EXTRACT_EXT_PUB.Get_Ins_Ext_Agg(p_payment_instruction_id);
40:
41: IF(l_ins_ext_agg IS NULL) THEN
42: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
43: print_debuginfo('Custom Code IBY_FD_EXTRACT_EXT_PUB.Get_Ins_Ext_Agg() returned a NULL value',
44: G_LEVEL_STATEMENT,l_dbg_mod);
45: END IF;
46: END IF;

Line 52: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

48: RETURN l_ins_ext_agg;
49:
50: EXCEPTION
51: WHEN OTHERS THEN
52: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
53: print_debuginfo('Exception Occurred while invoking the CUSTOM Code - IBY_FD_EXTRACT_EXT_PUB.Get_Ins_Ext_Agg():',
54: G_LEVEL_UNEXPECTED,l_dbg_mod);
55: print_debuginfo('Error Message:'||SQLERRM,G_LEVEL_UNEXPECTED,l_dbg_mod);
56: print_debuginfo('Error Code: '||sqlcode,G_LEVEL_UNEXPECTED,l_dbg_mod);

Line 75: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

71: BEGIN
72: l_pmt_ext_agg:= IBY_FD_EXTRACT_EXT_PUB.Get_Pmt_Ext_Agg(p_payment_id);
73:
74: IF(l_pmt_ext_agg IS NULL) THEN
75: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
76: print_debuginfo('Custom Code IBY_FD_EXTRACT_EXT_PUB.Get_Pmt_Ext_Agg() returned a NULL value'
77: ,G_LEVEL_PROCEDURE,l_dbg_mod);
78: END IF;
79: END IF;

Line 84: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

80: RETURN l_pmt_ext_agg;
81:
82: EXCEPTION
83: WHEN OTHERS THEN
84: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
85: print_debuginfo('Exception Occurred in the CUSTOM Code - IBY_FD_EXTRACT_EXT_PUB.Get_Pmt_Ext_Agg()',
86: G_LEVEL_UNEXPECTED,l_dbg_mod);
87: print_debuginfo('Error Message:'||SQLERRM,G_LEVEL_UNEXPECTED,l_dbg_mod);
88: print_debuginfo('Error Code: '||sqlcode,G_LEVEL_UNEXPECTED,l_dbg_mod);

Line 107: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

103: BEGIN
104: l_doc_ext_agg:= IBY_FD_EXTRACT_EXT_PUB.Get_Doc_Ext_Agg(p_document_payable_id);
105:
106: IF(l_doc_ext_agg IS NULL) THEN
107: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
108: print_debuginfo('Custom Code IBY_FD_EXTRACT_EXT_PUB.Get_Doc_Ext_Agg() returned a NULL value'
109: ,G_LEVEL_PROCEDURE,l_dbg_mod);
110: END IF;
111: END IF;

Line 116: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

112:
113: RETURN l_doc_ext_agg;
114: EXCEPTION
115: WHEN OTHERS THEN
116: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
117: print_debuginfo('Exception Occurred in the CUSTOM Code - IBY_FD_EXTRACT_EXT_PUB.Get_Doc_Ext_Agg()',
118: G_LEVEL_UNEXPECTED,l_dbg_mod);
119: print_debuginfo('Error Message:'||SQLERRM,G_LEVEL_UNEXPECTED,l_dbg_mod);
120: print_debuginfo('Error Code: '||sqlcode,G_LEVEL_UNEXPECTED,l_dbg_mod);

Line 139: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

135: BEGIN
136: l_docline_ext_agg:= IBY_FD_EXTRACT_EXT_PUB.Get_Docline_Ext_Agg(p_document_payable_id,p_line_number);
137:
138: IF(l_docline_ext_agg IS NULL) THEN
139: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
140: print_debuginfo('Custom Code IBY_FD_EXTRACT_EXT_PUB.Get_Docline_Ext_Agg() returned a NULL value'
141: ,G_LEVEL_PROCEDURE,l_dbg_mod);
142: END IF;
143: END IF;

Line 149: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

145: RETURN l_docline_ext_agg;
146:
147: EXCEPTION
148: WHEN OTHERS THEN
149: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
150: print_debuginfo('Exception Occurred in the CUSTOM Code - IBY_FD_EXTRACT_EXT_PUB.Get_Docline_Ext_Agg()',
151: G_LEVEL_UNEXPECTED,l_dbg_mod);
152: print_debuginfo('Error Message:'||SQLERRM,G_LEVEL_UNEXPECTED,l_dbg_mod);
153: print_debuginfo('Error Code: '||sqlcode,G_LEVEL_UNEXPECTED,l_dbg_mod);

Line 171: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

167: BEGIN
168: l_ppr_ext_agg:= IBY_FD_EXTRACT_EXT_PUB.Get_Ppr_Ext_Agg(p_payment_service_request_id);
169:
170: IF(l_ppr_ext_agg IS NULL) THEN
171: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
172: print_debuginfo(l_dbg_mod,
173: 'Custom Code IBY_FD_EXTRACT_EXT_PUB.Get_Ppr_Ext_Agg() returned a NULL value',
174: G_LEVEL_STATEMENT);
175: END IF;

Line 181: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

177:
178: RETURN l_ppr_ext_agg;
179: EXCEPTION
180: WHEN OTHERS THEN
181: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
182: print_debuginfo('Exception Occurred in the CUSTOM Code - IBY_FD_EXTRACT_EXT_PUB.Get_Ppr_Ext_Agg()',
183: G_LEVEL_UNEXPECTED,l_dbg_mod);
184: print_debuginfo('Error Code:' || sqlcode, G_LEVEL_UNEXPECTED, l_dbg_mod);
185: print_debuginfo('Error Message:' || SQLERRM, G_LEVEL_UNEXPECTED, l_dbg_mod);