eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBY_EXT_WRAP_PUB dependencies on IBY_FD_EXTRACT_EXT_PUB

Line 39: l_ins_ext_agg:= IBY_FD_EXTRACT_EXT_PUB.Get_Ins_Ext_Agg(p_payment_instruction_id);

35: l_ins_ext_agg XMLTYPE;
36: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.Get_Ins_Ext_Agg';
37:
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',

Line 43: print_debuginfo('Custom Code IBY_FD_EXTRACT_EXT_PUB.Get_Ins_Ext_Agg() returned a NULL value',

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;
47:

Line 53: print_debuginfo('Exception Occurred while invoking the CUSTOM Code - IBY_FD_EXTRACT_EXT_PUB.Get_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);
57: END IF;

Line 72: l_pmt_ext_agg:= IBY_FD_EXTRACT_EXT_PUB.Get_Pmt_Ext_Agg(p_payment_id);

68: l_pmt_ext_agg XMLTYPE;
69: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.Get_Pmt_Ext_Agg';
70:
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'

Line 76: print_debuginfo('Custom Code IBY_FD_EXTRACT_EXT_PUB.Get_Pmt_Ext_Agg() returned a NULL value'

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;
80: RETURN l_pmt_ext_agg;

Line 85: print_debuginfo('Exception Occurred in the CUSTOM Code - IBY_FD_EXTRACT_EXT_PUB.Get_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);
89: END IF;

Line 104: l_doc_ext_agg:= IBY_FD_EXTRACT_EXT_PUB.Get_Doc_Ext_Agg(p_document_payable_id);

100: l_doc_ext_agg XMLTYPE:=NULL;
101: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.Get_Doc_Ext_Agg';
102:
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'

Line 108: print_debuginfo('Custom Code IBY_FD_EXTRACT_EXT_PUB.Get_Doc_Ext_Agg() returned a NULL value'

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;
112:

Line 117: print_debuginfo('Exception Occurred in the CUSTOM Code - IBY_FD_EXTRACT_EXT_PUB.Get_Doc_Ext_Agg()',

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);
121: END IF;

Line 136: l_docline_ext_agg:= IBY_FD_EXTRACT_EXT_PUB.Get_Docline_Ext_Agg(p_document_payable_id,p_line_number);

132: l_docline_ext_agg XMLTYPE;
133: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.Get_Docline_Ext_Agg';
134:
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'

Line 140: print_debuginfo('Custom Code IBY_FD_EXTRACT_EXT_PUB.Get_Docline_Ext_Agg() returned a NULL value'

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;
144:

Line 150: print_debuginfo('Exception Occurred in the CUSTOM Code - IBY_FD_EXTRACT_EXT_PUB.Get_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);
154: END IF;

Line 168: l_ppr_ext_agg:= IBY_FD_EXTRACT_EXT_PUB.Get_Ppr_Ext_Agg(p_payment_service_request_id);

164: l_ppr_ext_agg XMLTYPE;
165: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.Get_Ppr_Ext_Agg';
166:
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,

Line 173: 'Custom Code IBY_FD_EXTRACT_EXT_PUB.Get_Ppr_Ext_Agg() returned a NULL value',

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;
176: END IF;
177:

Line 182: print_debuginfo('Exception Occurred in the CUSTOM Code - IBY_FD_EXTRACT_EXT_PUB.Get_Ppr_Ext_Agg()',

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);
186: END IF;