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.FV_TREASURY_PAYMENTS_PKG dependencies on FND_LOG

Line 15: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

11: g_checkrun_name ap_checks_all.checkrun_name%TYPE;
12: x_err_code NUMBER;
13: x_err_stage VARCHAR2(2000);
14: g_dit_flag VARCHAR2(1);
15: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
16:
17:
18: PROCEDURE CREATE_TREASURY_PAYMENT_EVENT
19: (p_calling_sequence IN VARCHAR2

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

48: x_err_code := 0;
49: g_treasury_conf_id := TO_NUMBER(p_treas_conf_id);
50:
51:
52: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
53: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
54: 'Treasury Confirmation Id = '||g_treasury_conf_id);
55: END IF;
56:

Line 53: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

49: g_treasury_conf_id := TO_NUMBER(p_treas_conf_id);
50:
51:
52: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
53: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
54: 'Treasury Confirmation Id = '||g_treasury_conf_id);
55: END IF;
56:
57: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 57: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

53: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
54: 'Treasury Confirmation Id = '||g_treasury_conf_id);
55: END IF;
56:
57: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
58: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
59: 'Org Id = '|| g_org_id);
60: END IF;
61:

Line 58: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

54: 'Treasury Confirmation Id = '||g_treasury_conf_id);
55: END IF;
56:
57: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
58: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
59: 'Org Id = '|| g_org_id);
60: END IF;
61:
62:

Line 87: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

83: END IF;
84: commit;
85: x_retcode := 2;
86: x_errbuf := 'The Treasury Confirmation journal category has not been seeded';
87: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
88: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
89: 'p_button_name = '||p_button_name);
90: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
91: 'Treasury Confirmation Id = '||g_treasury_conf_id);

Line 88: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

84: commit;
85: x_retcode := 2;
86: x_errbuf := 'The Treasury Confirmation journal category has not been seeded';
87: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
88: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
89: 'p_button_name = '||p_button_name);
90: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
91: 'Treasury Confirmation Id = '||g_treasury_conf_id);
92: END IF;

Line 90: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

86: x_errbuf := 'The Treasury Confirmation journal category has not been seeded';
87: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
88: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
89: 'p_button_name = '||p_button_name);
90: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
91: 'Treasury Confirmation Id = '||g_treasury_conf_id);
92: END IF;
93: Return;
94: END IF;

Line 121: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

117: INTO l_dit_flag
118: FROM fv_operating_units
119: where org_id = g_org_id ;
120:
121: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
122: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
123: 'dit flag = '||l_dit_flag);
124: END IF;
125: g_dit_flag := l_dit_flag;

Line 122: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

118: FROM fv_operating_units
119: where org_id = g_org_id ;
120:
121: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
122: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
123: 'dit flag = '||l_dit_flag);
124: END IF;
125: g_dit_flag := l_dit_flag;
126:

Line 131: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

127: IF l_dit_flag <> 'Y' THEN
128: x_retcode := 0;
129: x_errbuf := 'Disbursement in transit checkbox is disabled in Define Federal Options form'||
130: '-no accounting created for Treasury Confirmation ';
131: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
132: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
133: 'No Accounting created for Treasury Confirmation -'||
134: 'disbursement in transit checkbox is disabled in Define Federal Options form');
135: END IF;

Line 132: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

128: x_retcode := 0;
129: x_errbuf := 'Disbursement in transit checkbox is disabled in Define Federal Options form'||
130: '-no accounting created for Treasury Confirmation ';
131: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
132: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
133: 'No Accounting created for Treasury Confirmation -'||
134: 'disbursement in transit checkbox is disabled in Define Federal Options form');
135: END IF;
136: END IF;

Line 141: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

137:
138:
139:
140:
141: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
142: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
143: 'g_payment_instr_id = '||g_payment_instr_id);
144: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
145: 'g_accounting_date = '||g_accounting_date);

Line 142: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

138:
139:
140:
141: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
142: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
143: 'g_payment_instr_id = '||g_payment_instr_id);
144: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
145: 'g_accounting_date = '||g_accounting_date);
146: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

Line 144: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

140:
141: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
142: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
143: 'g_payment_instr_id = '||g_payment_instr_id);
144: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
145: 'g_accounting_date = '||g_accounting_date);
146: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
147: 'g_ledger_id = '||g_ledger_id);
148: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

Line 146: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

142: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
143: 'g_payment_instr_id = '||g_payment_instr_id);
144: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
145: 'g_accounting_date = '||g_accounting_date);
146: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
147: 'g_ledger_id = '||g_ledger_id);
148: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
149: 'g_org_id = '||g_org_id);
150: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

Line 148: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

144: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
145: 'g_accounting_date = '||g_accounting_date);
146: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
147: 'g_ledger_id = '||g_ledger_id);
148: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
149: 'g_org_id = '||g_org_id);
150: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
151: 'g_checkrun_name = '||g_checkrun_name);
152: END IF;

Line 150: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

146: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
147: 'g_ledger_id = '||g_ledger_id);
148: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
149: 'g_org_id = '||g_org_id);
150: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
151: 'g_checkrun_name = '||g_checkrun_name);
152: END IF;
153: EXCEPTION
154: WHEN OTHERS THEN

Line 157: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

153: EXCEPTION
154: WHEN OTHERS THEN
155: x_retcode := 2;
156: x_errbuf := 'The Treasury Confirmation rows are not available';
157: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
158: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
159: 'p_button_name = '||p_button_name);
160: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
161: 'Treasury Confirmation Id = '||g_treasury_conf_id);

Line 158: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

154: WHEN OTHERS THEN
155: x_retcode := 2;
156: x_errbuf := 'The Treasury Confirmation rows are not available';
157: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
158: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
159: 'p_button_name = '||p_button_name);
160: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
161: 'Treasury Confirmation Id = '||g_treasury_conf_id);
162: END IF;

Line 160: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

156: x_errbuf := 'The Treasury Confirmation rows are not available';
157: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
158: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
159: 'p_button_name = '||p_button_name);
160: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
161: 'Treasury Confirmation Id = '||g_treasury_conf_id);
162: END IF;
163: END;
164:

Line 179: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

175: commit;
176: RETURN;
177: END IF;
178:
179: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
180: 'Button='||p_button_name);
181:
182: IF p_button_name = 'TREASURY_CONFIRMATION.CONFIRM' THEN
183: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 183: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

179: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
180: 'Button='||p_button_name);
181:
182: IF p_button_name = 'TREASURY_CONFIRMATION.CONFIRM' THEN
183: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
184: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
185: 'Confirmation Process begins');
186: END IF;
187: do_confirm_process(x_status_code,x_return_status);

Line 184: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

180: 'Button='||p_button_name);
181:
182: IF p_button_name = 'TREASURY_CONFIRMATION.CONFIRM' THEN
183: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
184: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
185: 'Confirmation Process begins');
186: END IF;
187: do_confirm_process(x_status_code,x_return_status);
188: x_retcode := x_status_code;

Line 195: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

191: UPDATE fv_treasury_confirmations
192: SET confirmation_status_flag = 'Y'
193: WHERE treasury_confirmation_id = g_treasury_conf_id;
194:
195: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
196: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
197: 'The Confirm Process is Successful');
198: END IF;
199: ELSE

Line 196: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

192: SET confirmation_status_flag = 'Y'
193: WHERE treasury_confirmation_id = g_treasury_conf_id;
194:
195: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
196: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
197: 'The Confirm Process is Successful');
198: END IF;
199: ELSE
200:

Line 209: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

205: UPDATE fv_treasury_confirmations
206: SET confirmation_status_flag = 'N'
207: WHERE treasury_confirmation_id = g_treasury_conf_id;
208:
209: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
210: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
211: 'The Confirm Process has failed.');
212: END IF;
213:

Line 210: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

206: SET confirmation_status_flag = 'N'
207: WHERE treasury_confirmation_id = g_treasury_conf_id;
208:
209: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
210: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
211: 'The Confirm Process has failed.');
212: END IF;
213:
214: END IF;

Line 217: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

213:
214: END IF;
215:
216: ELSIF p_button_name = 'TREASURY_CONFIRMATION.BACK_OUT' THEN
217: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
218: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
219: 'Backout Process begins');
220: END IF;
221: if g_dit_flag = 'Y' THEN

Line 218: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

214: END IF;
215:
216: ELSIF p_button_name = 'TREASURY_CONFIRMATION.BACK_OUT' THEN
217: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
218: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
219: 'Backout Process begins');
220: END IF;
221: if g_dit_flag = 'Y' THEN
222:

Line 236: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

232: UPDATE fv_treasury_confirmations
233: SET confirmation_status_flag = 'B'
234: WHERE treasury_confirmation_id = g_treasury_conf_id;
235:
236: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
237: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
238: 'The Backout Process is Successful');
239: END IF;
240: ELSE

Line 237: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

233: SET confirmation_status_flag = 'B'
234: WHERE treasury_confirmation_id = g_treasury_conf_id;
235:
236: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
237: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
238: 'The Backout Process is Successful');
239: END IF;
240: ELSE
241: ROLLBACK TO FV_TREAS;

Line 248: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

244: UPDATE fv_treasury_confirmations
245: SET confirmation_status_flag = 'Y'
246: WHERE treasury_confirmation_id = g_treasury_conf_id;
247:
248: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
249: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
250: 'The Backout Process has failed.');
251: END IF;
252:

Line 249: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

245: SET confirmation_status_flag = 'Y'
246: WHERE treasury_confirmation_id = g_treasury_conf_id;
247:
248: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
249: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
250: 'The Backout Process has failed.');
251: END IF;
252:
253: END IF;

Line 255: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

251: END IF;
252:
253: END IF;
254: ELSE
255: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
256: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
257: 'No Treasury Confirmation process');
258: END IF;
259: RETURN;

Line 256: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

252:
253: END IF;
254: ELSE
255: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
256: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
257: 'No Treasury Confirmation process');
258: END IF;
259: RETURN;
260: END IF;

Line 267: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,g_errmsg);

263:
264: EXCEPTION
265: WHEN OTHERS THEN
266: g_errmsg := SQLERRM;
267: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,g_errmsg);
268: RAISE;
269: END Main;
270:
271: PROCEDURE DO_CONFIRM_PROCESS (x_status_code OUT NOCOPY VARCHAR2

Line 343: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

339: FROM FV_TREASURY_CONFIRMATIONS_ALL
340: WHERE payment_instruction_id = g_payment_instr_id
341: AND org_id = g_org_id;
342:
343: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
344: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
345: 'l_checkrun_name = '||l_checkrun_name);
346: END IF;
347: EXCEPTION

Line 344: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

340: WHERE payment_instruction_id = g_payment_instr_id
341: AND org_id = g_org_id;
342:
343: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
344: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
345: 'l_checkrun_name = '||l_checkrun_name);
346: END IF;
347: EXCEPTION
348: WHEN OTHERS THEN

Line 349: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

345: 'l_checkrun_name = '||l_checkrun_name);
346: END IF;
347: EXCEPTION
348: WHEN OTHERS THEN
349: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
350: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
351: 'No Upgrade entries');
352: END IF;
353: l_checkrun_name := NULL;

Line 350: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

346: END IF;
347: EXCEPTION
348: WHEN OTHERS THEN
349: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
350: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
351: 'No Upgrade entries');
352: END IF;
353: l_checkrun_name := NULL;
354: END;

Line 424: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

420: END IF;
421:
422: l_diff := l_end_doc - l_begin_doc + 1;
423:
424: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
425: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
426: 'l_diff is ' || l_diff);
427: END IF;
428:

Line 425: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

421:
422: l_diff := l_end_doc - l_begin_doc + 1;
423:
424: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
425: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
426: 'l_diff is ' || l_diff);
427: END IF;
428:
429: FOR i IN 1.. l_diff

Line 431: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

427: END IF;
428:
429: FOR i IN 1.. l_diff
430: LOOP
431: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
432: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
433: 'l_row_num:'||l_row_num);
434: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
435: 'l_check_tbl(l_row_num).check_id:'||

Line 432: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

428:
429: FOR i IN 1.. l_diff
430: LOOP
431: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
432: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
433: 'l_row_num:'||l_row_num);
434: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
435: 'l_check_tbl(l_row_num).check_id:'||
436: l_check_tbl(l_row_num).check_id);

Line 434: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

430: LOOP
431: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
432: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
433: 'l_row_num:'||l_row_num);
434: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
435: 'l_check_tbl(l_row_num).check_id:'||
436: l_check_tbl(l_row_num).check_id);
437: END IF;
438:

Line 459: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

455: LOOP
456: FETCH cur_corr_treas_pay_num INTO l_corr_treas_pay_num, l_offset_check_id;
457: EXIT WHEN cur_corr_treas_pay_num%NOTFOUND;
458:
459: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
460: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
461: 'In corrected treasury pay number loop');
462: END IF;
463:

Line 460: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

456: FETCH cur_corr_treas_pay_num INTO l_corr_treas_pay_num, l_offset_check_id;
457: EXIT WHEN cur_corr_treas_pay_num%NOTFOUND;
458:
459: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
460: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
461: 'In corrected treasury pay number loop');
462: END IF;
463:
464: IF l_corr_treas_pay_num IS NOT NULL THEN

Line 484: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

480:
481:
482: IF x_status_code= 'SUCCESS' THEN
483:
484: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
485: 'Treasury Confirmation Successful. Checking for Voided Checks');
486:
487: SELECT COUNT(ac.check_id) INTO l_void_count
488: FROM ap_checks_all ac

Line 499: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

495:
496: IF l_void_count <> 0 THEN
497:
498:
499: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
500: 'Voided Checks = ' || l_void_count);
501:
502:
503: INSERT INTO fv_voided_checks

Line 547: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

543: WHERE treasury_confirmation_id = g_treasury_conf_id;
544:
545: commit;
546:
547: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
548: 'Calling Create treasury payment for Voided Checks');
549:
550: create_treasury_payment_event(l_calling_sequence,
551: 'TREASURY_VOID',

Line 557: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

553: x_status_code,
554: x_return_status);
555:
556:
557: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
558: 'After Create treasury payment for Voided Checks');
559:
560: BEGIN
561:

Line 565: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

561:
562: IF (x_status_code = 'SUCCESS') THEN
563:
564:
565: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
566: 'Create treasury payment for Voided Checks is Successful');
567:
568: UPDATE fv_voided_checks
569: SET processed_flag = 'P'

Line 586: fv_utility.log_mesg(fnd_log.level_exception,l_module_name||

582: END IF;
583:
584: EXCEPTION
585: WHEN OTHERS THEN
586: fv_utility.log_mesg(fnd_log.level_exception,l_module_name||
587: 'Error in Creating Void Accounting ',SQLERRM);
588: END;
589:
590:

Line 660: fv_utility.log_mesg(fnd_log.level_exception,l_module_name||

656: ORDER BY period_year,period_num ASC ;
657:
658: EXCEPTION
659: WHEN others THEN
660: fv_utility.log_mesg(fnd_log.level_exception,l_module_name||
661: 'Error in getting next Open Period',SQLERRM);
662: RETURN;
663:
664: END;

Line 741: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

737: BEGIN
738: l_calling_sequence := p_calling_sequence || ' -> FV_TREASURY_PAYMENTS_PKG.CREATE_TREASURY_PAYMENT_EVENT';
739: l_module_name := g_module_name||'Create_Treasury_Payment_Event';
740:
741: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
742: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
743: 'Calling Sequence: '||p_calling_sequence);
744: END IF;
745:

Line 742: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

738: l_calling_sequence := p_calling_sequence || ' -> FV_TREASURY_PAYMENTS_PKG.CREATE_TREASURY_PAYMENT_EVENT';
739: l_module_name := g_module_name||'Create_Treasury_Payment_Event';
740:
741: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
742: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
743: 'Calling Sequence: '||p_calling_sequence);
744: END IF;
745:
746: --Set the reference info value based on event type

Line 788: IF (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL ) THEN

784: ,p_event_number => NULL
785: ,p_valuation_method => NULL
786: ,p_security_context => l_security_context) THEN
787:
788: IF (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL ) THEN
789: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module_name,'Event exists! event_id =' || l_tc_event_id);
790: END IF;
791:
792: --- call the xla_events_pub_pkg.get_array_event_info

Line 789: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module_name,'Event exists! event_id =' || l_tc_event_id);

785: ,p_valuation_method => NULL
786: ,p_security_context => l_security_context) THEN
787:
788: IF (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL ) THEN
789: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module_name,'Event exists! event_id =' || l_tc_event_id);
790: END IF;
791:
792: --- call the xla_events_pub_pkg.get_array_event_info
793: /*XLA_EVENTS_PUB_PKG.DELETE_EVENT(

Line 799: IF (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL ) THEN

795: p_event_id => l_tc_event_id,
796: p_valuation_method => NULL,
797: p_security_context => l_security_context);
798:
799: IF (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL ) THEN
800: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module_name, 'After delete '||l_tc_event_id);
801: END IF;*/
802:
803: END IF;

Line 800: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module_name, 'After delete '||l_tc_event_id);

796: p_valuation_method => NULL,
797: p_security_context => l_security_context);
798:
799: IF (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL ) THEN
800: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module_name, 'After delete '||l_tc_event_id);
801: END IF;*/
802:
803: END IF;
804:

Line 820: IF FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL THEN

816: p_security_context => l_security_context
817: -- p_budgetary_control_flag => 'Y'
818: );
819:
820: IF FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL THEN
821: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Event ID: '||l_tc_event_id );
822: END IF;
823:
824: IF l_tc_event_id is NULL THEN

Line 821: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Event ID: '||l_tc_event_id );

817: -- p_budgetary_control_flag => 'Y'
818: );
819:
820: IF FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL THEN
821: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Event ID: '||l_tc_event_id );
822: END IF;
823:
824: IF l_tc_event_id is NULL THEN
825: IF FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL THEN

Line 825: IF FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL THEN

821: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Event ID: '||l_tc_event_id );
822: END IF;
823:
824: IF l_tc_event_id is NULL THEN
825: IF FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL THEN
826: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module_name,'Event creation failed for: Treasury confirmation ID: '
827: || to_char(l_event_source_info.transaction_number));
828: END IF;
829: RAISE FND_API.g_exc_error;

Line 826: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module_name,'Event creation failed for: Treasury confirmation ID: '

822: END IF;
823:
824: IF l_tc_event_id is NULL THEN
825: IF FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL THEN
826: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module_name,'Event creation failed for: Treasury confirmation ID: '
827: || to_char(l_event_source_info.transaction_number));
828: END IF;
829: RAISE FND_API.g_exc_error;
830: END IF;

Line 873: IF (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL ) THEN

869: ,p_event_number => NULL
870: ,p_valuation_method => NULL
871: ,p_security_context => l_security_context) THEN
872:
873: IF (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL ) THEN
874: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module_name,'Event exists! event_id =' || l_void_event_id);
875: END IF;
876:
877: XLA_EVENTS_PUB_PKG.DELETE_EVENT(

Line 874: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module_name,'Event exists! event_id =' || l_void_event_id);

870: ,p_valuation_method => NULL
871: ,p_security_context => l_security_context) THEN
872:
873: IF (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL ) THEN
874: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module_name,'Event exists! event_id =' || l_void_event_id);
875: END IF;
876:
877: XLA_EVENTS_PUB_PKG.DELETE_EVENT(
878: p_event_source_info => l_event_source_info,

Line 883: IF (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL ) THEN

879: p_event_id => l_void_event_id,
880: p_valuation_method => NULL,
881: p_security_context => l_security_context);
882:
883: IF (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL ) THEN
884: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module_name, 'After delete '||l_void_event_id);
885: END IF;
886: END IF; */
887: l_void_event_id := NULL;

Line 884: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module_name, 'After delete '||l_void_event_id);

880: p_valuation_method => NULL,
881: p_security_context => l_security_context);
882:
883: IF (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL ) THEN
884: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module_name, 'After delete '||l_void_event_id);
885: END IF;
886: END IF; */
887: l_void_event_id := NULL;
888:

Line 902: IF FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL THEN

898: p_security_context => l_security_context
899: -- p_budgetary_control_flag => 'Y'
900: );
901:
902: IF FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL THEN
903: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Event ID: '||l_void_event_id );
904: END IF;
905:
906: IF l_void_event_id is NULL THEN

Line 903: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Event ID: '||l_void_event_id );

899: -- p_budgetary_control_flag => 'Y'
900: );
901:
902: IF FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL THEN
903: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Event ID: '||l_void_event_id );
904: END IF;
905:
906: IF l_void_event_id is NULL THEN
907: IF FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL THEN

Line 907: IF FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL THEN

903: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Event ID: '||l_void_event_id );
904: END IF;
905:
906: IF l_void_event_id is NULL THEN
907: IF FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL THEN
908: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module_name,'Event creation failed for: Treasury confirmation ID: '
909: || to_char(l_event_source_info.transaction_number)||'Check ID: '||l_check_id);
910: END IF;
911: RAISE FND_API.g_exc_error;

Line 908: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module_name,'Event creation failed for: Treasury confirmation ID: '

904: END IF;
905:
906: IF l_void_event_id is NULL THEN
907: IF FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL THEN
908: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module_name,'Event creation failed for: Treasury confirmation ID: '
909: || to_char(l_event_source_info.transaction_number)||'Check ID: '||l_check_id);
910: END IF;
911: RAISE FND_API.g_exc_error;
912: END IF;

Line 943: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

939: );
940:
941: IF l_retcode <> 0 THEN
942: l_api_message := 'Error Accounting for Events in SLA';
943: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
944: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,l_module_name ,
945: l_api_message);
946: END IF;
947: x_status_code := 'FAILURE';

Line 944: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,l_module_name ,

940:
941: IF l_retcode <> 0 THEN
942: l_api_message := 'Error Accounting for Events in SLA';
943: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
944: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,l_module_name ,
945: l_api_message);
946: END IF;
947: x_status_code := 'FAILURE';
948: RAISE FND_API.g_exc_error;

Line 988: fv_utility.debug_mesg(fnd_log.level_statement,l_module_name,'Start Of Void');

984:
985: treas_conf_rec cur_treas_conf%ROWTYPE;
986:
987: BEGIN
988: fv_utility.debug_mesg(fnd_log.level_statement,l_module_name,'Start Of Void');
989:
990: l_module_name := g_module_name || 'Void';
991: l_calling_sequence := 'FV_TREASURY_PAYMENTS_PKG.Void_Payments';
992: l_reference1 := 'Void';

Line 999: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

995: g_org_id := MO_GLOBAL.get_current_org_id;
996: MO_UTILS.get_ledger_info(g_org_id, g_ledger_id, l_ledger_name);
997: END IF;
998:
999: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1000: fv_utility.debug_mesg(fnd_log.level_statement,l_module_name,'INSERT INTO fv_voided_checks');
1001: END IF;
1002:
1003: BEGIN

Line 1000: fv_utility.debug_mesg(fnd_log.level_statement,l_module_name,'INSERT INTO fv_voided_checks');

996: MO_UTILS.get_ledger_info(g_org_id, g_ledger_id, l_ledger_name);
997: END IF;
998:
999: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1000: fv_utility.debug_mesg(fnd_log.level_statement,l_module_name,'INSERT INTO fv_voided_checks');
1001: END IF;
1002:
1003: BEGIN
1004: INSERT INTO fv_voided_checks

Line 1044: fv_utility.log_mesg(fnd_log.level_exception,l_module_name||' insert fv_voided_checks1',l_err_stage);

1040: WHEN OTHERS THEN
1041: l_err_code := SQLCODE;
1042: l_err_stage := SQLERRM;
1043: X_retcode:=2;
1044: fv_utility.log_mesg(fnd_log.level_exception,l_module_name||' insert fv_voided_checks1',l_err_stage);
1045: END;
1046:
1047: l_status_code:='SUCCESS';
1048:

Line 1101: fv_utility.log_mesg(fnd_log.level_exception,l_module_name||

1097: EXCEPTION
1098: WHEN OTHERS THEN
1099: l_err_code := SQLCODE;
1100: l_err_stage := SQLERRM;
1101: fv_utility.log_mesg(fnd_log.level_exception,l_module_name||
1102: 'update fv_voided_checks1',l_err_stage);
1103: END;
1104: ELSE
1105: l_status_code:='SUCCESS';

Line 1128: fv_utility.log_mesg(fnd_log.level_exception,l_module_name||'update fv_voided_checks1',l_err_stage);

1124: EXCEPTION
1125: WHEN OTHERS THEN
1126: l_err_code := SQLCODE;
1127: l_err_stage := SQLERRM;
1128: fv_utility.log_mesg(fnd_log.level_exception,l_module_name||'update fv_voided_checks1',l_err_stage);
1129: END;
1130: */
1131:
1132: fv_utility.debug_mesg(fnd_log.level_statement,l_module_name,'End Of Void');

Line 1132: fv_utility.debug_mesg(fnd_log.level_statement,l_module_name,'End Of Void');

1128: fv_utility.log_mesg(fnd_log.level_exception,l_module_name||'update fv_voided_checks1',l_err_stage);
1129: END;
1130: */
1131:
1132: fv_utility.debug_mesg(fnd_log.level_statement,l_module_name,'End Of Void');
1133: X_retcode:=0;
1134: END Void;
1135:
1136: