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_FD_POST_PICP_PROGS_PVT dependencies on FND_LOG

Line 77: debug_level => FND_LOG.LEVEL_PROCEDURE,

73: -- initialize api return status to success
74: x_return_status := fnd_api.g_ret_sts_success;
75:
76: iby_debug_pub.add(debug_msg => 'Enter: ' || l_Debug_Module,
77: debug_level => FND_LOG.LEVEL_PROCEDURE,
78: module => l_Debug_Module);
79:
80: iby_debug_pub.add(debug_msg => 'Input parameters: ',
81: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 81: debug_level => FND_LOG.LEVEL_STATEMENT,

77: debug_level => FND_LOG.LEVEL_PROCEDURE,
78: module => l_Debug_Module);
79:
80: iby_debug_pub.add(debug_msg => 'Input parameters: ',
81: debug_level => FND_LOG.LEVEL_STATEMENT,
82: module => l_Debug_Module);
83:
84: iby_debug_pub.add(debug_msg => '============================================',
85: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 85: debug_level => FND_LOG.LEVEL_STATEMENT,

81: debug_level => FND_LOG.LEVEL_STATEMENT,
82: module => l_Debug_Module);
83:
84: iby_debug_pub.add(debug_msg => '============================================',
85: debug_level => FND_LOG.LEVEL_STATEMENT,
86: module => l_Debug_Module);
87:
88: iby_debug_pub.add(debug_msg => 'p_payment_instruction_id: ' || p_payment_instruction_id,
89: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 89: debug_level => FND_LOG.LEVEL_STATEMENT,

85: debug_level => FND_LOG.LEVEL_STATEMENT,
86: module => l_Debug_Module);
87:
88: iby_debug_pub.add(debug_msg => 'p_payment_instruction_id: ' || p_payment_instruction_id,
89: debug_level => FND_LOG.LEVEL_STATEMENT,
90: module => l_Debug_Module);
91:
92: iby_debug_pub.add(debug_msg => 'p_summary_format_code: ' || p_summary_format_code,
93: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 93: debug_level => FND_LOG.LEVEL_STATEMENT,

89: debug_level => FND_LOG.LEVEL_STATEMENT,
90: module => l_Debug_Module);
91:
92: iby_debug_pub.add(debug_msg => 'p_summary_format_code: ' || p_summary_format_code,
93: debug_level => FND_LOG.LEVEL_STATEMENT,
94: module => l_Debug_Module);
95:
96: iby_debug_pub.add(debug_msg => 'p_ecs_dos_seq_num: ' || p_ecs_dos_seq_num,
97: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 97: debug_level => FND_LOG.LEVEL_STATEMENT,

93: debug_level => FND_LOG.LEVEL_STATEMENT,
94: module => l_Debug_Module);
95:
96: iby_debug_pub.add(debug_msg => 'p_ecs_dos_seq_num: ' || p_ecs_dos_seq_num,
97: debug_level => FND_LOG.LEVEL_STATEMENT,
98: module => l_Debug_Module);
99:
100: iby_debug_pub.add(debug_msg => '============================================',
101: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 101: debug_level => FND_LOG.LEVEL_STATEMENT,

97: debug_level => FND_LOG.LEVEL_STATEMENT,
98: module => l_Debug_Module);
99:
100: iby_debug_pub.add(debug_msg => '============================================',
101: debug_level => FND_LOG.LEVEL_STATEMENT,
102: module => l_Debug_Module);
103:
104: iby_debug_pub.add(debug_msg => 'Before Calling FND_REQUEST.SUBMIT_REQUEST().',
105: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 105: debug_level => FND_LOG.LEVEL_STATEMENT,

101: debug_level => FND_LOG.LEVEL_STATEMENT,
102: module => l_Debug_Module);
103:
104: iby_debug_pub.add(debug_msg => 'Before Calling FND_REQUEST.SUBMIT_REQUEST().',
105: debug_level => FND_LOG.LEVEL_STATEMENT,
106: module => l_Debug_Module);
107:
108: --Bug 6411356
109: --below code added to set the current nls character setting

Line 142: debug_level => FND_LOG.LEVEL_STATEMENT,

138: '', '', ''
139: );
140:
141: iby_debug_pub.add(debug_msg => 'After Calling FND_REQUEST.SUBMIT_REQUEST().',
142: debug_level => FND_LOG.LEVEL_STATEMENT,
143: module => l_Debug_Module);
144:
145: iby_debug_pub.add(debug_msg => 'Request id: ' || x_request_id,
146: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 146: debug_level => FND_LOG.LEVEL_STATEMENT,

142: debug_level => FND_LOG.LEVEL_STATEMENT,
143: module => l_Debug_Module);
144:
145: iby_debug_pub.add(debug_msg => 'Request id: ' || x_request_id,
146: debug_level => FND_LOG.LEVEL_STATEMENT,
147: module => l_Debug_Module);
148:
149: --
150: -- end of api body.

Line 232: debug_level => FND_LOG.LEVEL_PROCEDURE,

228:
229: BEGIN
230:
231: iby_debug_pub.add(debug_msg => 'Enter: ' || l_Debug_Module,
232: debug_level => FND_LOG.LEVEL_PROCEDURE,
233: module => l_Debug_Module);
234:
235: iby_debug_pub.add(debug_msg => 'Input payment instruction ID: ' || p_payment_instruction_id,
236: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 236: debug_level => FND_LOG.LEVEL_STATEMENT,

232: debug_level => FND_LOG.LEVEL_PROCEDURE,
233: module => l_Debug_Module);
234:
235: iby_debug_pub.add(debug_msg => 'Input payment instruction ID: ' || p_payment_instruction_id,
236: debug_level => FND_LOG.LEVEL_STATEMENT,
237: module => l_Debug_Module);
238:
239: OPEN l_ins_csr(p_payment_instruction_id);
240: FETCH l_ins_csr INTO l_printer_name, l_instr_status, l_transmit_immed_flag,

Line 256: iby_debug_pub.add(debug_msg => 'Completion point of the payment instruction :' || l_completion_point,debug_level => FND_LOG.LEVEL_STATEMENT, module => l_Debug_Module);

252: RAISE FND_API.G_EXC_ERROR;
253: END IF;
254:
255: /*Bug 8760084 - Start*/
256: iby_debug_pub.add(debug_msg => 'Completion point of the payment instruction :' || l_completion_point,debug_level => FND_LOG.LEVEL_STATEMENT, module => l_Debug_Module);
257:
258: IF l_completion_point IN ('CREATED') THEN
259: iby_debug_pub.add(debug_msg => 'Avoided format payments program trigger',debug_level => FND_LOG.LEVEL_STATEMENT, module => l_Debug_Module);
260:

Line 259: iby_debug_pub.add(debug_msg => 'Avoided format payments program trigger',debug_level => FND_LOG.LEVEL_STATEMENT, module => l_Debug_Module);

255: /*Bug 8760084 - Start*/
256: iby_debug_pub.add(debug_msg => 'Completion point of the payment instruction :' || l_completion_point,debug_level => FND_LOG.LEVEL_STATEMENT, module => l_Debug_Module);
257:
258: IF l_completion_point IN ('CREATED') THEN
259: iby_debug_pub.add(debug_msg => 'Avoided format payments program trigger',debug_level => FND_LOG.LEVEL_STATEMENT, module => l_Debug_Module);
260:
261: iby_debug_pub.add(debug_msg => 'Marking payments complete',debug_level => FND_LOG.LEVEL_STATEMENT, module => l_Debug_Module);
262:
263: IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete (

Line 261: iby_debug_pub.add(debug_msg => 'Marking payments complete',debug_level => FND_LOG.LEVEL_STATEMENT, module => l_Debug_Module);

257:
258: IF l_completion_point IN ('CREATED') THEN
259: iby_debug_pub.add(debug_msg => 'Avoided format payments program trigger',debug_level => FND_LOG.LEVEL_STATEMENT, module => l_Debug_Module);
260:
261: iby_debug_pub.add(debug_msg => 'Marking payments complete',debug_level => FND_LOG.LEVEL_STATEMENT, module => l_Debug_Module);
262:
263: IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete (
264: p_instr_id => p_payment_instruction_id,
265: x_return_status => l_mark_complete_status

Line 273: iby_debug_pub.add(debug_msg => 'Marking payment instruction as completed - failed',debug_level => FND_LOG.LEVEL_STATEMENT, module => l_Debug_Module);

269: -- set error for invalid data
270: fnd_message.set_name('IBY', 'IBY_FD_ERR_MARK_COMPLETE');
271: fnd_message.set_token('PARAM', p_payment_instruction_id);
272: fnd_msg_pub.add;
273: iby_debug_pub.add(debug_msg => 'Marking payment instruction as completed - failed',debug_level => FND_LOG.LEVEL_STATEMENT, module => l_Debug_Module);
274: RAISE FND_API.G_EXC_ERROR;
275: END IF;
276:
277: iby_debug_pub.add(debug_msg => 'Marked payment instruction as complete',debug_level => FND_LOG.LEVEL_STATEMENT, module => l_Debug_Module);

Line 277: iby_debug_pub.add(debug_msg => 'Marked payment instruction as complete',debug_level => FND_LOG.LEVEL_STATEMENT, module => l_Debug_Module);

273: iby_debug_pub.add(debug_msg => 'Marking payment instruction as completed - failed',debug_level => FND_LOG.LEVEL_STATEMENT, module => l_Debug_Module);
274: RAISE FND_API.G_EXC_ERROR;
275: END IF;
276:
277: iby_debug_pub.add(debug_msg => 'Marked payment instruction as complete',debug_level => FND_LOG.LEVEL_STATEMENT, module => l_Debug_Module);
278: RETURN;
279:
280: END IF;
281: /*Bug 8760084 - End*/

Line 307: debug_level => FND_LOG.LEVEL_STATEMENT,

303: l_set_opt_ok := FND_REQUEST.SET_OPTIONS;
304:
305: IF l_set_opt_ok THEN
306: iby_debug_pub.add(debug_msg => 'Set request implicit to NO ',
307: debug_level => FND_LOG.LEVEL_STATEMENT,
308: module => l_Debug_Module);
309: ELSE
310: iby_debug_pub.add(debug_msg => 'Warning: unable to set request options ',
311: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 311: debug_level => FND_LOG.LEVEL_STATEMENT,

307: debug_level => FND_LOG.LEVEL_STATEMENT,
308: module => l_Debug_Module);
309: ELSE
310: iby_debug_pub.add(debug_msg => 'Warning: unable to set request options ',
311: debug_level => FND_LOG.LEVEL_STATEMENT,
312: module => l_Debug_Module);
313: END IF;
314:
315:

Line 324: debug_level => FND_LOG.LEVEL_STATEMENT,

320: END IF;
321:
322: IF l_run_print THEN
323: iby_debug_pub.add(debug_msg => 'The payment instruction format output is to be printed.',
324: debug_level => FND_LOG.LEVEL_STATEMENT,
325: module => l_Debug_Module);
326:
327: SELECT nvl(pp.disallow_save_print_flag,'N') into l_save_no_output
328: FROM iby_pay_instructions_all ins,

Line 355: debug_level => FND_LOG.LEVEL_STATEMENT,

351:
352:
353: IF l_set_print_opt_ok THEN
354: iby_debug_pub.add(debug_msg => 'The printer is to: ' || l_printer_name,
355: debug_level => FND_LOG.LEVEL_STATEMENT,
356: module => l_Debug_Module);
357: ELSE
358: iby_debug_pub.add(debug_msg => 'Warning: unable to set printer',
359: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 359: debug_level => FND_LOG.LEVEL_STATEMENT,

355: debug_level => FND_LOG.LEVEL_STATEMENT,
356: module => l_Debug_Module);
357: ELSE
358: iby_debug_pub.add(debug_msg => 'Warning: unable to set printer',
359: debug_level => FND_LOG.LEVEL_STATEMENT,
360: module => l_Debug_Module);
361: END IF;
362:
363: iby_debug_pub.add(debug_msg => 'Before Calling FND_REQUEST.SUBMIT_REQUEST().',

Line 364: debug_level => FND_LOG.LEVEL_STATEMENT,

360: module => l_Debug_Module);
361: END IF;
362:
363: iby_debug_pub.add(debug_msg => 'Before Calling FND_REQUEST.SUBMIT_REQUEST().',
364: debug_level => FND_LOG.LEVEL_STATEMENT,
365: module => l_Debug_Module);
366:
367: --Bug 6411356
368: --below code added to set the current nls character setting

Line 443: debug_level => FND_LOG.LEVEL_STATEMENT,

439: '', '', ''
440: );
441:
442: iby_debug_pub.add(debug_msg => 'Submitting request for format payment program for PDF output',
443: debug_level => FND_LOG.LEVEL_STATEMENT,
444: module => l_Debug_Module);
445:
446: ELSE
447:

Line 473: debug_level => FND_LOG.LEVEL_STATEMENT,

469: '', '', ''
470: );
471:
472: iby_debug_pub.add(debug_msg => 'Submitting request for format payment program for text/xml output',
473: debug_level => FND_LOG.LEVEL_STATEMENT,
474: module => l_Debug_Module);
475:
476: END IF;
477:

Line 479: debug_level => FND_LOG.LEVEL_STATEMENT,

475:
476: END IF;
477:
478: iby_debug_pub.add(debug_msg => 'After Calling FND_REQUEST.SUBMIT_REQUEST().',
479: debug_level => FND_LOG.LEVEL_STATEMENT,
480: module => l_Debug_Module);
481: iby_debug_pub.add(debug_msg => 'Request id: ' || l_request_id,
482: debug_level => FND_LOG.LEVEL_STATEMENT,
483: module => l_Debug_Module);

Line 482: debug_level => FND_LOG.LEVEL_STATEMENT,

478: iby_debug_pub.add(debug_msg => 'After Calling FND_REQUEST.SUBMIT_REQUEST().',
479: debug_level => FND_LOG.LEVEL_STATEMENT,
480: module => l_Debug_Module);
481: iby_debug_pub.add(debug_msg => 'Request id: ' || l_request_id,
482: debug_level => FND_LOG.LEVEL_STATEMENT,
483: module => l_Debug_Module);
484:
485: IF l_request_id = 0 THEN
486: RAISE FND_API.G_EXC_ERROR;

Line 493: debug_level => FND_LOG.LEVEL_STATEMENT,

489: ELSE
490:
491: iby_debug_pub.add(debug_msg => 'Calling the lock_pmt_entity() API to lock instruction: ' || p_payment_instruction_id
492: || ' for the extract/formatting/printing/delivery program',
493: debug_level => FND_LOG.LEVEL_STATEMENT,
494: module => l_Debug_Module);
495:
496: IBY_DISBURSE_UI_API_PUB_PKG.lock_pmt_entity(
497: p_object_id => p_payment_instruction_id,

Line 507: debug_level => FND_LOG.LEVEL_STATEMENT,

503: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
504: RAISE FND_API.G_EXC_ERROR;
505: ELSE
506: iby_debug_pub.add(debug_msg => 'lock_pmt_entity() API returned success',
507: debug_level => FND_LOG.LEVEL_STATEMENT,
508: module => l_Debug_Module);
509: END IF;
510:
511: END IF;

Line 514: debug_level => FND_LOG.LEVEL_PROCEDURE,

510:
511: END IF;
512:
513: iby_debug_pub.add(debug_msg => 'Exit: ' || l_Debug_Module,
514: debug_level => FND_LOG.LEVEL_PROCEDURE,
515: module => l_Debug_Module);
516:
517: END Run_Post_PI_Programs;
518:

Line 561: debug_level => FND_LOG.LEVEL_PROCEDURE,

557: -- AND payment_status in ('READY_TO_REPRINT', 'VOID_BY_SETUP_REPRINT', 'VOID_BY_OVERFLOW_REPRINT');
558:
559: BEGIN
560: iby_debug_pub.log(debug_msg => 'Enter Post Results:Start:Timestamp:' || systimestamp,
561: debug_level => FND_LOG.LEVEL_PROCEDURE,
562: module => l_Debug_Module);
563: iby_debug_pub.add(debug_msg => 'Enter: ' || l_Debug_Module,
564: debug_level => FND_LOG.LEVEL_PROCEDURE,
565: module => l_Debug_Module);

Line 564: debug_level => FND_LOG.LEVEL_PROCEDURE,

560: iby_debug_pub.log(debug_msg => 'Enter Post Results:Start:Timestamp:' || systimestamp,
561: debug_level => FND_LOG.LEVEL_PROCEDURE,
562: module => l_Debug_Module);
563: iby_debug_pub.add(debug_msg => 'Enter: ' || l_Debug_Module,
564: debug_level => FND_LOG.LEVEL_PROCEDURE,
565: module => l_Debug_Module);
566:
567: iby_debug_pub.add(debug_msg => 'Input payment instruction ID: ' || p_payment_instruction_id,
568: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 568: debug_level => FND_LOG.LEVEL_STATEMENT,

564: debug_level => FND_LOG.LEVEL_PROCEDURE,
565: module => l_Debug_Module);
566:
567: iby_debug_pub.add(debug_msg => 'Input payment instruction ID: ' || p_payment_instruction_id,
568: debug_level => FND_LOG.LEVEL_STATEMENT,
569: module => l_Debug_Module);
570:
571: iby_debug_pub.add(debug_msg => 'Input instruction status: ' || p_newStatus,
572: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 572: debug_level => FND_LOG.LEVEL_STATEMENT,

568: debug_level => FND_LOG.LEVEL_STATEMENT,
569: module => l_Debug_Module);
570:
571: iby_debug_pub.add(debug_msg => 'Input instruction status: ' || p_newStatus,
572: debug_level => FND_LOG.LEVEL_STATEMENT,
573: module => l_Debug_Module);
574:
575: iby_debug_pub.add(debug_msg => 'Input is_reprint_flag: ' || p_is_reprint_flag,
576: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 576: debug_level => FND_LOG.LEVEL_STATEMENT,

572: debug_level => FND_LOG.LEVEL_STATEMENT,
573: module => l_Debug_Module);
574:
575: iby_debug_pub.add(debug_msg => 'Input is_reprint_flag: ' || p_is_reprint_flag,
576: debug_level => FND_LOG.LEVEL_STATEMENT,
577: module => l_Debug_Module);
578:
579: x_return_status := FND_API.G_RET_STS_SUCCESS;
580:

Line 587: debug_level => FND_LOG.LEVEL_STATEMENT,

583: l_mark_complete_event, l_format_code, l_pp_prt_immed, l_process_type;
584: CLOSE l_instruction_ovn_csr;
585:
586: iby_debug_pub.add(debug_msg => 'Current instruction status is: ' || l_instr_status,
587: debug_level => FND_LOG.LEVEL_STATEMENT,
588: module => l_Debug_Module);
589:
590: iby_debug_pub.add(debug_msg => 'Setting instruction to the input status: ' || p_newStatus,
591: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 591: debug_level => FND_LOG.LEVEL_STATEMENT,

587: debug_level => FND_LOG.LEVEL_STATEMENT,
588: module => l_Debug_Module);
589:
590: iby_debug_pub.add(debug_msg => 'Setting instruction to the input status: ' || p_newStatus,
591: debug_level => FND_LOG.LEVEL_STATEMENT,
592: module => l_Debug_Module);
593:
594: -- bug 5121763: single payments handling. PICP would mark complete and set
595: -- the complete statuses in its process - i.e., before the post-PICP CP

Line 618: debug_level => FND_LOG.LEVEL_STATEMENT,

614:
615: IF nvl(p_is_reprint_flag, 'N') = 'N' THEN
616:
617: iby_debug_pub.add(debug_msg => ' New status is SUBMITTED_FOR_PRINTING and reprint flag is N ',
618: debug_level => FND_LOG.LEVEL_STATEMENT,
619: module => l_Debug_Module);
620:
621:
622: -- FOR l_payment IN l_pmt_csr(p_payment_instruction_id) LOOP

Line 628: -- debug_level => FND_LOG.LEVEL_STATEMENT,

624: -- IF l_payment.payment_status IN ('FORMATTED', 'INSTRUCTION_CREATED') THEN
625: --
626: -- iby_debug_pub.add(debug_msg => 'Payment ' || l_payment.payment_id || ' is in ' || l_payment.payment_status ||
627: -- ' status. Setting it to SUBMITTED_FOR_PRINTING',
628: -- debug_level => FND_LOG.LEVEL_STATEMENT,
629: -- module => l_Debug_Module);
630:
631: iby_debug_pub.add(debug_msg => 'Setting status for Payments with ' ||
632: ' payment_instruction_id as ' || p_payment_instruction_id ||

Line 635: debug_level => FND_LOG.LEVEL_STATEMENT,

631: iby_debug_pub.add(debug_msg => 'Setting status for Payments with ' ||
632: ' payment_instruction_id as ' || p_payment_instruction_id ||
633: ' payment_status as FORMATTED,INSTRUCTION_CREATED' ||
634: ' to SUBMITTED_FOR_PRINTING',
635: debug_level => FND_LOG.LEVEL_STATEMENT,
636: module => l_Debug_Module);
637:
638: UPDATE
639: iby_payments_all

Line 659: debug_level => FND_LOG.LEVEL_STATEMENT,

655: ELSE -- reprint (individual or range)
656:
657:
658: iby_debug_pub.add(debug_msg => ' New status is SUBMITTED_FOR_PRINTING and reprint flag is Y ',
659: debug_level => FND_LOG.LEVEL_STATEMENT,
660: module => l_Debug_Module);
661:
662: -- FOR l_payment IN l_pmt_reprt_csr(p_payment_instruction_id) LOOP
663: --

Line 668: -- debug_level => FND_LOG.LEVEL_STATEMENT,

664: -- IF l_payment.payment_status = 'READY_TO_REPRINT' THEN
665: --
666: -- iby_debug_pub.add(debug_msg => 'Payment ' || l_payment.payment_id || ' is in ' || l_payment.payment_status ||
667: -- ' status. Setting it to SUBMITTED_FOR_PRINTING',
668: -- debug_level => FND_LOG.LEVEL_STATEMENT,
669: -- module => l_Debug_Module);
670:
671:
672: iby_debug_pub.add(debug_msg => 'Setting status for Payments with ' ||

Line 676: debug_level => FND_LOG.LEVEL_STATEMENT,

672: iby_debug_pub.add(debug_msg => 'Setting status for Payments with ' ||
673: ' payment_instruction_id as ' || p_payment_instruction_id ||
674: ' payment_status as READY_TO_REPRINT' ||
675: ' to SUBMITTED_FOR_PRINTING',
676: debug_level => FND_LOG.LEVEL_STATEMENT,
677: module => l_Debug_Module);
678:
679:
680: UPDATE

Line 699: -- debug_level => FND_LOG.LEVEL_STATEMENT,

695: -- ELSIF l_payment.payment_status = 'VOID_BY_SETUP_REPRINT' THEN
696: --
697: -- iby_debug_pub.add(debug_msg => 'Payment ' || l_payment.payment_id || ' is in ' || l_payment.payment_status ||
698: -- ' status. Setting it to VOID_BY_SETUP',
699: -- debug_level => FND_LOG.LEVEL_STATEMENT,
700: -- module => l_Debug_Module);
701:
702: iby_debug_pub.add(debug_msg => 'Setting status for Payments with ' ||
703: ' payment_instruction_id as ' || p_payment_instruction_id ||

Line 706: debug_level => FND_LOG.LEVEL_STATEMENT,

702: iby_debug_pub.add(debug_msg => 'Setting status for Payments with ' ||
703: ' payment_instruction_id as ' || p_payment_instruction_id ||
704: ' payment_status as VOID_BY_SETUP_REPRINT' ||
705: ' to VOID_BY_SETUP',
706: debug_level => FND_LOG.LEVEL_STATEMENT,
707: module => l_Debug_Module);
708:
709:
710: -- UPDATE

Line 726: -- debug_level => FND_LOG.LEVEL_STATEMENT,

722: -- ELSIF l_payment.payment_status = 'VOID_BY_OVERFLOW_REPRINT' THEN
723: --
724: -- iby_debug_pub.add(debug_msg => 'Payment ' || l_payment.payment_id || ' is in ' || l_payment.payment_status ||
725: -- ' status. Setting it to VOID_BY_OVERFLOW',
726: -- debug_level => FND_LOG.LEVEL_STATEMENT,
727: -- module => l_Debug_Module);
728:
729: iby_debug_pub.add(debug_msg => 'Setting status for Payments with ' ||
730: ' payment_instruction_id as ' || p_payment_instruction_id ||

Line 733: debug_level => FND_LOG.LEVEL_STATEMENT,

729: iby_debug_pub.add(debug_msg => 'Setting status for Payments with ' ||
730: ' payment_instruction_id as ' || p_payment_instruction_id ||
731: ' payment_status as VOID_BY_OVERFLOW_REPRINT' ||
732: ' to VOID_BY_OVERFLOW',
733: debug_level => FND_LOG.LEVEL_STATEMENT,
734: module => l_Debug_Module);
735:
736:
737: -- UPDATE

Line 760: debug_level => FND_LOG.LEVEL_STATEMENT,

756: ELSIF p_newStatus = 'FORMATTED' AND l_proc_type = 'PRINTED' THEN
757:
758:
759: iby_debug_pub.add(debug_msg => ' New status is FORMATTED and processing type is PRINTED ',
760: debug_level => FND_LOG.LEVEL_STATEMENT,
761: module => l_Debug_Module);
762:
763:
764: -- FOR l_payment IN l_pmt_csr(p_payment_instruction_id) LOOP

Line 770: -- debug_level => FND_LOG.LEVEL_STATEMENT,

766: -- IF l_payment.payment_status = 'INSTRUCTION_CREATED' THEN
767: --
768: -- iby_debug_pub.add(debug_msg => 'Payment ' || l_payment.payment_id || ' is in ' || l_payment.payment_status ||
769: -- ' status. Setting it to FORMATTED',
770: -- debug_level => FND_LOG.LEVEL_STATEMENT,
771: -- module => l_Debug_Module);
772:
773: iby_debug_pub.add(debug_msg => 'Setting status for Payments with ' ||
774: ' payment_instruction_id as ' || p_payment_instruction_id ||

Line 777: debug_level => FND_LOG.LEVEL_STATEMENT,

773: iby_debug_pub.add(debug_msg => 'Setting status for Payments with ' ||
774: ' payment_instruction_id as ' || p_payment_instruction_id ||
775: ' payment_status as INSTRUCTION_CREATED' ||
776: ' to FORMATTED',
777: debug_level => FND_LOG.LEVEL_STATEMENT,
778: module => l_Debug_Module);
779:
780: UPDATE
781: iby_payments_all

Line 802: debug_level => FND_LOG.LEVEL_STATEMENT,

798: ELSIF p_newStatus = 'FORMATTED_ELECTRONIC' AND l_proc_type = 'ELECTRONIC' THEN
799:
800:
801: iby_debug_pub.add(debug_msg => ' New status is FORMATTED_ELECTRONIC and processing type is ELECTRONIC ',
802: debug_level => FND_LOG.LEVEL_STATEMENT,
803: module => l_Debug_Module);
804:
805:
806: -- FOR l_payment IN l_pmt_csr(p_payment_instruction_id) LOOP

Line 812: -- debug_level => FND_LOG.LEVEL_STATEMENT,

808: -- IF l_payment.payment_status = 'INSTRUCTION_CREATED' THEN
809: --
810: -- iby_debug_pub.add(debug_msg => 'Payment ' || l_payment.payment_id || ' is in ' || l_payment.payment_status ||
811: -- ' status. Setting it to FORMATTED',
812: -- debug_level => FND_LOG.LEVEL_STATEMENT,
813: -- module => l_Debug_Module);
814:
815: iby_debug_pub.add(debug_msg => 'Setting status for Payments with ' ||
816: ' payment_instruction_id as ' || p_payment_instruction_id ||

Line 819: debug_level => FND_LOG.LEVEL_STATEMENT,

815: iby_debug_pub.add(debug_msg => 'Setting status for Payments with ' ||
816: ' payment_instruction_id as ' || p_payment_instruction_id ||
817: ' payment_status as INSTRUCTION_CREATED' ||
818: ' to FORMATTED',
819: debug_level => FND_LOG.LEVEL_STATEMENT,
820: module => l_Debug_Module);
821:
822: UPDATE
823: iby_payments_all

Line 841: debug_level => FND_LOG.LEVEL_STATEMENT,

837:
838: IF l_mark_complete_event = 'FORMATTED' THEN
839:
840: iby_debug_pub.add(debug_msg => 'Before Calling IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete().',
841: debug_level => FND_LOG.LEVEL_STATEMENT,
842: module => l_Debug_Module);
843:
844: -- the payment completion point must be set as FORMATTED in the PPP
845: -- call the mark complete API

Line 847: debug_level => FND_LOG.LEVEL_PROCEDURE,

843:
844: -- the payment completion point must be set as FORMATTED in the PPP
845: -- call the mark complete API
846: iby_debug_pub.log(debug_msg => 'Enter Mark Pmts Complete: Timestamp:' || systimestamp,
847: debug_level => FND_LOG.LEVEL_PROCEDURE,
848: module => l_Debug_Module);
849: IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete (
850: p_instr_id => p_payment_instruction_id,
851: x_return_status => l_mark_complete_status

Line 854: debug_level => FND_LOG.LEVEL_PROCEDURE,

850: p_instr_id => p_payment_instruction_id,
851: x_return_status => l_mark_complete_status
852: );
853: iby_debug_pub.log(debug_msg => 'Exit Mark Pmts Complete: Timestamp:' || systimestamp,
854: debug_level => FND_LOG.LEVEL_PROCEDURE,
855: module => l_Debug_Module);
856: iby_debug_pub.add(debug_msg => 'After Calling IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete().',
857: debug_level => FND_LOG.LEVEL_STATEMENT,
858: module => l_Debug_Module);

Line 857: debug_level => FND_LOG.LEVEL_STATEMENT,

853: iby_debug_pub.log(debug_msg => 'Exit Mark Pmts Complete: Timestamp:' || systimestamp,
854: debug_level => FND_LOG.LEVEL_PROCEDURE,
855: module => l_Debug_Module);
856: iby_debug_pub.add(debug_msg => 'After Calling IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete().',
857: debug_level => FND_LOG.LEVEL_STATEMENT,
858: module => l_Debug_Module);
859:
860: IF l_mark_complete_status <> FND_API.G_RET_STS_SUCCESS THEN
861: -- set error for invalid data

Line 876: debug_level => FND_LOG.LEVEL_STATEMENT,

872: ELSIF p_newStatus = 'FORMATTED_READY_FOR_PRINTING' THEN
873:
874:
875: iby_debug_pub.add(debug_msg => ' New status is FORMATTED_READY_FOR_PRINTING ',
876: debug_level => FND_LOG.LEVEL_STATEMENT,
877: module => l_Debug_Module);
878:
879:
880: -- FOR l_payment IN l_pmt_csr(p_payment_instruction_id) LOOP

Line 886: -- debug_level => FND_LOG.LEVEL_STATEMENT,

882: -- IF l_payment.payment_status = 'INSTRUCTION_CREATED' THEN
883: --
884: -- iby_debug_pub.add(debug_msg => 'Payment ' || l_payment.payment_id || ' is in ' || l_payment.payment_status ||
885: -- ' status. Setting it to FORMATTED',
886: -- debug_level => FND_LOG.LEVEL_STATEMENT,
887: -- module => l_Debug_Module);
888:
889: iby_debug_pub.add(debug_msg => 'Setting status for Payments with ' ||
890: ' payment_instruction_id as ' || p_payment_instruction_id ||

Line 893: debug_level => FND_LOG.LEVEL_STATEMENT,

889: iby_debug_pub.add(debug_msg => 'Setting status for Payments with ' ||
890: ' payment_instruction_id as ' || p_payment_instruction_id ||
891: ' payment_status as INSTRUCTION_CREATED' ||
892: ' to FORMATTED',
893: debug_level => FND_LOG.LEVEL_STATEMENT,
894: module => l_Debug_Module);
895:
896: UPDATE
897: iby_payments_all

Line 925: debug_level => FND_LOG.LEVEL_STATEMENT,

921: ELSIF p_newStatus = 'FORMATTED_READY_TO_TRANSMIT' THEN
922:
923:
924: iby_debug_pub.add(debug_msg => ' New status is FORMATTED_READY_TO_TRANSMIT ',
925: debug_level => FND_LOG.LEVEL_STATEMENT,
926: module => l_Debug_Module);
927:
928:
929: -- FOR l_payment IN l_pmt_csr(p_payment_instruction_id) LOOP

Line 935: -- debug_level => FND_LOG.LEVEL_STATEMENT,

931: -- IF l_payment.payment_status = 'INSTRUCTION_CREATED' THEN
932: --
933: -- iby_debug_pub.add(debug_msg => 'Payment ' || l_payment.payment_id || ' is in ' || l_payment.payment_status ||
934: -- ' status. Setting it to FORMATTED',
935: -- debug_level => FND_LOG.LEVEL_STATEMENT,
936: -- module => l_Debug_Module);
937:
938: iby_debug_pub.add(debug_msg => 'Setting status for Payments with ' ||
939: ' payment_instruction_id as ' || p_payment_instruction_id ||

Line 942: debug_level => FND_LOG.LEVEL_STATEMENT,

938: iby_debug_pub.add(debug_msg => 'Setting status for Payments with ' ||
939: ' payment_instruction_id as ' || p_payment_instruction_id ||
940: ' payment_status as INSTRUCTION_CREATED' ||
941: ' to FORMATTED',
942: debug_level => FND_LOG.LEVEL_STATEMENT,
943: module => l_Debug_Module);
944:
945:
946: UPDATE

Line 965: debug_level => FND_LOG.LEVEL_STATEMENT,

961:
962: IF l_mark_complete_event = 'FORMATTED' THEN
963:
964: iby_debug_pub.add(debug_msg => 'Before Calling IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete().',
965: debug_level => FND_LOG.LEVEL_STATEMENT,
966: module => l_Debug_Module);
967:
968: -- call the mark complete API
969: iby_debug_pub.log(debug_msg => 'Enter Mark Pmts Complete: Formatted:Timestamp:' || systimestamp,

Line 970: debug_level => FND_LOG.LEVEL_PROCEDURE,

966: module => l_Debug_Module);
967:
968: -- call the mark complete API
969: iby_debug_pub.log(debug_msg => 'Enter Mark Pmts Complete: Formatted:Timestamp:' || systimestamp,
970: debug_level => FND_LOG.LEVEL_PROCEDURE,
971: module => l_Debug_Module);
972: IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete (
973: p_instr_id => p_payment_instruction_id,
974: x_return_status => l_mark_complete_status

Line 977: debug_level => FND_LOG.LEVEL_PROCEDURE,

973: p_instr_id => p_payment_instruction_id,
974: x_return_status => l_mark_complete_status
975: );
976: iby_debug_pub.log(debug_msg => 'Exit Mark Pmts Complete: Formatted:Timestamp:' || systimestamp,
977: debug_level => FND_LOG.LEVEL_PROCEDURE,
978: module => l_Debug_Module);
979:
980: iby_debug_pub.add(debug_msg => 'After Calling IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete().',
981: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 981: debug_level => FND_LOG.LEVEL_STATEMENT,

977: debug_level => FND_LOG.LEVEL_PROCEDURE,
978: module => l_Debug_Module);
979:
980: iby_debug_pub.add(debug_msg => 'After Calling IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete().',
981: debug_level => FND_LOG.LEVEL_STATEMENT,
982: module => l_Debug_Module);
983:
984: IF l_mark_complete_status <> FND_API.G_RET_STS_SUCCESS THEN
985: -- set error for invalid data

Line 1000: debug_level => FND_LOG.LEVEL_STATEMENT,

996: ELSIF p_newStatus = 'TRANSMITTED' THEN
997:
998:
999: iby_debug_pub.add(debug_msg => ' New status is TRANSMITTED ',
1000: debug_level => FND_LOG.LEVEL_STATEMENT,
1001: module => l_Debug_Module);
1002:
1003:
1004: -- FOR l_payment IN l_pmt_csr(p_payment_instruction_id) LOOP

Line 1010: -- debug_level => FND_LOG.LEVEL_STATEMENT,

1006: -- IF l_payment.payment_status IN ('FORMATTED', 'INSTRUCTION_CREATED') THEN
1007: --
1008: -- iby_debug_pub.add(debug_msg => 'Payment ' || l_payment.payment_id || ' is in ' || l_payment.payment_status ||
1009: -- ' status. Setting it to TRANSMITTED',
1010: -- debug_level => FND_LOG.LEVEL_STATEMENT,
1011: -- module => l_Debug_Module);
1012:
1013: iby_debug_pub.add(debug_msg => 'Setting status for Payments with ' ||
1014: ' payment_instruction_id as ' || p_payment_instruction_id ||

Line 1017: debug_level => FND_LOG.LEVEL_STATEMENT,

1013: iby_debug_pub.add(debug_msg => 'Setting status for Payments with ' ||
1014: ' payment_instruction_id as ' || p_payment_instruction_id ||
1015: ' payment_status as FORMATTED,INSTRUCTION_CREATED' ||
1016: ' to TRANSMITTED',
1017: debug_level => FND_LOG.LEVEL_STATEMENT,
1018: module => l_Debug_Module);
1019:
1020:
1021: UPDATE

Line 1045: debug_level => FND_LOG.LEVEL_STATEMENT,

1041: */
1042: IF l_mark_complete_event in ('FORMATTED', 'TRANSMITTED') THEN
1043:
1044: iby_debug_pub.add(debug_msg => 'Before Calling IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete().',
1045: debug_level => FND_LOG.LEVEL_STATEMENT,
1046: module => l_Debug_Module);
1047:
1048: -- call the mark complete API
1049: iby_debug_pub.log(debug_msg => 'Enter Mark Pmts Complete:Transmitted:Timestamp' || systimestamp,

Line 1050: debug_level => FND_LOG.LEVEL_PROCEDURE,

1046: module => l_Debug_Module);
1047:
1048: -- call the mark complete API
1049: iby_debug_pub.log(debug_msg => 'Enter Mark Pmts Complete:Transmitted:Timestamp' || systimestamp,
1050: debug_level => FND_LOG.LEVEL_PROCEDURE,
1051: module => l_Debug_Module);
1052:
1053: IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete (
1054: p_instr_id => p_payment_instruction_id,

Line 1059: debug_level => FND_LOG.LEVEL_PROCEDURE,

1055: x_return_status => l_mark_complete_status
1056: );
1057:
1058: iby_debug_pub.log(debug_msg => 'Exit Mark Pmts Complete:Transmitted:Timestamp:' || systimestamp,
1059: debug_level => FND_LOG.LEVEL_PROCEDURE,
1060: module => l_Debug_Module);
1061: iby_debug_pub.add(debug_msg => 'After Calling IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete().',
1062: debug_level => FND_LOG.LEVEL_STATEMENT,
1063: module => l_Debug_Module);

Line 1062: debug_level => FND_LOG.LEVEL_STATEMENT,

1058: iby_debug_pub.log(debug_msg => 'Exit Mark Pmts Complete:Transmitted:Timestamp:' || systimestamp,
1059: debug_level => FND_LOG.LEVEL_PROCEDURE,
1060: module => l_Debug_Module);
1061: iby_debug_pub.add(debug_msg => 'After Calling IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete().',
1062: debug_level => FND_LOG.LEVEL_STATEMENT,
1063: module => l_Debug_Module);
1064:
1065: IF l_mark_complete_status <> FND_API.G_RET_STS_SUCCESS THEN
1066:

Line 1084: debug_level => FND_LOG.LEVEL_STATEMENT,

1080: ELSIF p_newStatus = 'TRANSMISSION_FAILED' THEN
1081:
1082:
1083: iby_debug_pub.add(debug_msg => ' New status is TRANSMISSION_FAILED ',
1084: debug_level => FND_LOG.LEVEL_STATEMENT,
1085: module => l_Debug_Module);
1086:
1087:
1088: -- bug 5630411 for transmission right after formatting

Line 1098: -- debug_level => FND_LOG.LEVEL_STATEMENT,

1094: -- IF l_payment.payment_status IN ('INSTRUCTION_CREATED') THEN
1095: --
1096: -- iby_debug_pub.add(debug_msg => 'Payment ' || l_payment.payment_id || ' is in ' || l_payment.payment_status ||
1097: -- ' status. Setting it to FORMATTED',
1098: -- debug_level => FND_LOG.LEVEL_STATEMENT,
1099: -- module => l_Debug_Module);
1100:
1101: iby_debug_pub.add(debug_msg => 'Setting status for Payments with ' ||
1102: ' payment_instruction_id as ' || p_payment_instruction_id ||

Line 1105: debug_level => FND_LOG.LEVEL_STATEMENT,

1101: iby_debug_pub.add(debug_msg => 'Setting status for Payments with ' ||
1102: ' payment_instruction_id as ' || p_payment_instruction_id ||
1103: ' payment_status as INSTRUCTION_CREATED' ||
1104: ' to FORMATTED',
1105: debug_level => FND_LOG.LEVEL_STATEMENT,
1106: module => l_Debug_Module);
1107:
1108: UPDATE
1109: iby_payments_all

Line 1127: debug_level => FND_LOG.LEVEL_STATEMENT,

1123:
1124: IF l_mark_complete_event = 'FORMATTED' THEN
1125:
1126: iby_debug_pub.add(debug_msg => 'Before Calling IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete().',
1127: debug_level => FND_LOG.LEVEL_STATEMENT,
1128: module => l_Debug_Module);
1129: iby_debug_pub.log(debug_msg => 'Enter Mark Pmts Complete: Formatted2:Timestamp:' || systimestamp,
1130: debug_level => FND_LOG.LEVEL_PROCEDURE,
1131: module => l_Debug_Module);

Line 1130: debug_level => FND_LOG.LEVEL_PROCEDURE,

1126: iby_debug_pub.add(debug_msg => 'Before Calling IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete().',
1127: debug_level => FND_LOG.LEVEL_STATEMENT,
1128: module => l_Debug_Module);
1129: iby_debug_pub.log(debug_msg => 'Enter Mark Pmts Complete: Formatted2:Timestamp:' || systimestamp,
1130: debug_level => FND_LOG.LEVEL_PROCEDURE,
1131: module => l_Debug_Module);
1132: -- call the mark complete API
1133: IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete (
1134: p_instr_id => p_payment_instruction_id,

Line 1138: debug_level => FND_LOG.LEVEL_PROCEDURE,

1134: p_instr_id => p_payment_instruction_id,
1135: x_return_status => l_mark_complete_status
1136: );
1137: iby_debug_pub.log(debug_msg => 'Exit Mark Pmts Complete: Formatted2:Timestamp:' || systimestamp,
1138: debug_level => FND_LOG.LEVEL_PROCEDURE,
1139: module => l_Debug_Module);
1140:
1141: iby_debug_pub.add(debug_msg => 'After Calling IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete().',
1142: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 1142: debug_level => FND_LOG.LEVEL_STATEMENT,

1138: debug_level => FND_LOG.LEVEL_PROCEDURE,
1139: module => l_Debug_Module);
1140:
1141: iby_debug_pub.add(debug_msg => 'After Calling IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete().',
1142: debug_level => FND_LOG.LEVEL_STATEMENT,
1143: module => l_Debug_Module);
1144:
1145: IF l_mark_complete_status <> FND_API.G_RET_STS_SUCCESS THEN
1146: -- set error for invalid data

Line 1165: debug_level => FND_LOG.LEVEL_PROCEDURE,

1161: -- if its a Federal format
1162: Submit_FV_TS_Report(p_payment_instruction_id, l_format_code, l_Debug_Module);
1163:
1164: iby_debug_pub.log(debug_msg => 'Exit: ' || l_Debug_Module||'Timestamp::'||systimestamp,
1165: debug_level => FND_LOG.LEVEL_PROCEDURE,
1166: module => l_Debug_Module);
1167:
1168: EXCEPTION
1169:

Line 1179: debug_level => FND_LOG.LEVEL_STATEMENT,

1175: IF l_msg_data IS NULL THEN
1176: EXIT;
1177: ELSE
1178: iby_debug_pub.add(debug_msg => l_msg_data,
1179: debug_level => FND_LOG.LEVEL_STATEMENT,
1180: module => l_Debug_Module);
1181: END IF;
1182: END LOOP;
1183:

Line 1194: debug_level => FND_LOG.LEVEL_STATEMENT,

1190: IF l_msg_data IS NULL THEN
1191: EXIT;
1192: ELSE
1193: iby_debug_pub.add(debug_msg => l_msg_data,
1194: debug_level => FND_LOG.LEVEL_STATEMENT,
1195: module => l_Debug_Module);
1196: END IF;
1197: END LOOP;
1198:

Line 1209: debug_level => FND_LOG.LEVEL_STATEMENT,

1205: IF l_msg_data IS NULL THEN
1206: EXIT;
1207: ELSE
1208: iby_debug_pub.add(debug_msg => l_msg_data,
1209: debug_level => FND_LOG.LEVEL_STATEMENT,
1210: module => l_Debug_Module);
1211: END IF;
1212: END LOOP;
1213:

Line 1243: debug_level => FND_LOG.LEVEL_STATEMENT,

1239: );
1240:
1241: IF l_fv_ts_req_status = FND_API.G_RET_STS_SUCCESS THEN
1242: iby_debug_pub.add(debug_msg => 'Federal submit_pay_instr_ts_report() returns success.',
1243: debug_level => FND_LOG.LEVEL_STATEMENT,
1244: module => l_Debug_Module);
1245: iby_debug_pub.add(debug_msg => 'Payment Instruction Treasury Symbol Listing Report request id: ' || l_fv_ts_req_id,
1246: debug_level => FND_LOG.LEVEL_STATEMENT,
1247: module => l_Debug_Module);

Line 1246: debug_level => FND_LOG.LEVEL_STATEMENT,

1242: iby_debug_pub.add(debug_msg => 'Federal submit_pay_instr_ts_report() returns success.',
1243: debug_level => FND_LOG.LEVEL_STATEMENT,
1244: module => l_Debug_Module);
1245: iby_debug_pub.add(debug_msg => 'Payment Instruction Treasury Symbol Listing Report request id: ' || l_fv_ts_req_id,
1246: debug_level => FND_LOG.LEVEL_STATEMENT,
1247: module => l_Debug_Module);
1248: ELSE
1249: iby_debug_pub.add(debug_msg => 'Federal submit_pay_instr_ts_report() returns error.',
1250: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 1250: debug_level => FND_LOG.LEVEL_STATEMENT,

1246: debug_level => FND_LOG.LEVEL_STATEMENT,
1247: module => l_Debug_Module);
1248: ELSE
1249: iby_debug_pub.add(debug_msg => 'Federal submit_pay_instr_ts_report() returns error.',
1250: debug_level => FND_LOG.LEVEL_STATEMENT,
1251: module => l_Debug_Module);
1252: END IF;
1253:
1254: END IF;

Line 1272: debug_level => FND_LOG.LEVEL_PROCEDURE,

1268:
1269: BEGIN
1270:
1271: iby_debug_pub.add(debug_msg => 'Enter: ' || l_Debug_Module,
1272: debug_level => FND_LOG.LEVEL_PROCEDURE,
1273: module => l_Debug_Module);
1274:
1275: iby_debug_pub.add(debug_msg => 'Input payment instruction ID: ' || p_payment_instruction_id,
1276: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 1276: debug_level => FND_LOG.LEVEL_STATEMENT,

1272: debug_level => FND_LOG.LEVEL_PROCEDURE,
1273: module => l_Debug_Module);
1274:
1275: iby_debug_pub.add(debug_msg => 'Input payment instruction ID: ' || p_payment_instruction_id,
1276: debug_level => FND_LOG.LEVEL_STATEMENT,
1277: module => l_Debug_Module);
1278:
1279: iby_debug_pub.add(debug_msg => 'Error code: ' || p_error_code,
1280: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 1280: debug_level => FND_LOG.LEVEL_STATEMENT,

1276: debug_level => FND_LOG.LEVEL_STATEMENT,
1277: module => l_Debug_Module);
1278:
1279: iby_debug_pub.add(debug_msg => 'Error code: ' || p_error_code,
1280: debug_level => FND_LOG.LEVEL_STATEMENT,
1281: module => l_Debug_Module);
1282:
1283: iby_debug_pub.add(debug_msg => 'Error message: ' || p_error_msg,
1284: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 1284: debug_level => FND_LOG.LEVEL_STATEMENT,

1280: debug_level => FND_LOG.LEVEL_STATEMENT,
1281: module => l_Debug_Module);
1282:
1283: iby_debug_pub.add(debug_msg => 'Error message: ' || p_error_msg,
1284: debug_level => FND_LOG.LEVEL_STATEMENT,
1285: module => l_Debug_Module);
1286:
1287: select IBY_TRANSACTION_ERRORS_S.nextval into l_transaction_error_id from dual;
1288:

Line 1304: debug_level => FND_LOG.LEVEL_PROCEDURE,

1300: 1, 'Y',
1301: 'N', 'BANK', p_error_msg);
1302:
1303: iby_debug_pub.add(debug_msg => 'Exit: ' || l_Debug_Module,
1304: debug_level => FND_LOG.LEVEL_PROCEDURE,
1305: module => l_Debug_Module);
1306:
1307: END Insert_Transmission_Error;
1308:

Line 1330: debug_level => FND_LOG.LEVEL_PROCEDURE,

1326: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Turn_off_STP_Flag';
1327: BEGIN
1328:
1329: iby_debug_pub.add(debug_msg => 'Enter: ' || l_Debug_Module,
1330: debug_level => FND_LOG.LEVEL_PROCEDURE,
1331: module => l_Debug_Module);
1332:
1333: iby_debug_pub.add(debug_msg => 'Input payment instruction ID: ' || p_payment_instruction_id,
1334: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 1334: debug_level => FND_LOG.LEVEL_STATEMENT,

1330: debug_level => FND_LOG.LEVEL_PROCEDURE,
1331: module => l_Debug_Module);
1332:
1333: iby_debug_pub.add(debug_msg => 'Input payment instruction ID: ' || p_payment_instruction_id,
1334: debug_level => FND_LOG.LEVEL_STATEMENT,
1335: module => l_Debug_Module);
1336:
1337: FOR l_doc IN l_doc_csr(p_payment_instruction_id) LOOP
1338:

Line 1353: debug_level => FND_LOG.LEVEL_PROCEDURE,

1349:
1350: END LOOP;
1351:
1352: iby_debug_pub.add(debug_msg => 'Exit: ' || l_Debug_Module,
1353: debug_level => FND_LOG.LEVEL_PROCEDURE,
1354: module => l_Debug_Module);
1355:
1356: END Turn_off_STP_Flag;
1357:

Line 1395: debug_level => FND_LOG.LEVEL_PROCEDURE,

1391:
1392: BEGIN
1393:
1394: iby_debug_pub.add(debug_msg => 'Enter: ' || l_Debug_Module,
1395: debug_level => FND_LOG.LEVEL_PROCEDURE,
1396: module => l_Debug_Module);
1397:
1398: iby_debug_pub.add(debug_msg => 'Input payment instruction ID: ' || p_payment_instruction_id,
1399: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 1399: debug_level => FND_LOG.LEVEL_STATEMENT,

1395: debug_level => FND_LOG.LEVEL_PROCEDURE,
1396: module => l_Debug_Module);
1397:
1398: iby_debug_pub.add(debug_msg => 'Input payment instruction ID: ' || p_payment_instruction_id,
1399: debug_level => FND_LOG.LEVEL_STATEMENT,
1400: module => l_Debug_Module);
1401:
1402: iby_debug_pub.add(debug_msg => 'p_seq_name1: ' || p_seq_name1,
1403: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 1403: debug_level => FND_LOG.LEVEL_STATEMENT,

1399: debug_level => FND_LOG.LEVEL_STATEMENT,
1400: module => l_Debug_Module);
1401:
1402: iby_debug_pub.add(debug_msg => 'p_seq_name1: ' || p_seq_name1,
1403: debug_level => FND_LOG.LEVEL_STATEMENT,
1404: module => l_Debug_Module);
1405:
1406: iby_debug_pub.add(debug_msg => 'p_last_val1: ' || p_last_val1,
1407: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 1407: debug_level => FND_LOG.LEVEL_STATEMENT,

1403: debug_level => FND_LOG.LEVEL_STATEMENT,
1404: module => l_Debug_Module);
1405:
1406: iby_debug_pub.add(debug_msg => 'p_last_val1: ' || p_last_val1,
1407: debug_level => FND_LOG.LEVEL_STATEMENT,
1408: module => l_Debug_Module);
1409:
1410: iby_debug_pub.add(debug_msg => 'p_seq_name2: ' || p_seq_name1,
1411: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 1411: debug_level => FND_LOG.LEVEL_STATEMENT,

1407: debug_level => FND_LOG.LEVEL_STATEMENT,
1408: module => l_Debug_Module);
1409:
1410: iby_debug_pub.add(debug_msg => 'p_seq_name2: ' || p_seq_name1,
1411: debug_level => FND_LOG.LEVEL_STATEMENT,
1412: module => l_Debug_Module);
1413:
1414: iby_debug_pub.add(debug_msg => 'p_last_val2: ' || p_last_val1,
1415: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 1415: debug_level => FND_LOG.LEVEL_STATEMENT,

1411: debug_level => FND_LOG.LEVEL_STATEMENT,
1412: module => l_Debug_Module);
1413:
1414: iby_debug_pub.add(debug_msg => 'p_last_val2: ' || p_last_val1,
1415: debug_level => FND_LOG.LEVEL_STATEMENT,
1416: module => l_Debug_Module);
1417:
1418: iby_debug_pub.add(debug_msg => 'p_seq_name3: ' || p_seq_name1,
1419: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 1419: debug_level => FND_LOG.LEVEL_STATEMENT,

1415: debug_level => FND_LOG.LEVEL_STATEMENT,
1416: module => l_Debug_Module);
1417:
1418: iby_debug_pub.add(debug_msg => 'p_seq_name3: ' || p_seq_name1,
1419: debug_level => FND_LOG.LEVEL_STATEMENT,
1420: module => l_Debug_Module);
1421:
1422: iby_debug_pub.add(debug_msg => 'p_last_val3: ' || p_last_val1,
1423: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 1423: debug_level => FND_LOG.LEVEL_STATEMENT,

1419: debug_level => FND_LOG.LEVEL_STATEMENT,
1420: module => l_Debug_Module);
1421:
1422: iby_debug_pub.add(debug_msg => 'p_last_val3: ' || p_last_val1,
1423: debug_level => FND_LOG.LEVEL_STATEMENT,
1424: module => l_Debug_Module);
1425:
1426: OPEN l_seq_csr (p_payment_instruction_id);
1427: FETCH l_seq_csr INTO l_payment_profile_id, l_seq_name1, l_seq_name2, l_seq_name3,

Line 1553: debug_level => FND_LOG.LEVEL_PROCEDURE,

1549:
1550: END IF;
1551:
1552: iby_debug_pub.add(debug_msg => 'Exit: ' || l_Debug_Module,
1553: debug_level => FND_LOG.LEVEL_PROCEDURE,
1554: module => l_Debug_Module);
1555:
1556: END save_last_periodic_seq_nums;
1557:

Line 1794: debug_level => FND_LOG.LEVEL_STATEMENT,

1790: MO_GLOBAL.init(l_appl_name);
1791: END IF;
1792:
1793: iby_debug_pub.add(debug_msg => 'Checking accessible orgs',
1794: debug_level => FND_LOG.LEVEL_STATEMENT,
1795: module => l_Debug_Module);
1796:
1797: FOR l_ce_spgt IN l_ce_spgt_csr LOOP
1798:

Line 1802: debug_level => FND_LOG.LEVEL_STATEMENT,

1798:
1799: iby_debug_pub.add(debug_msg => 'Org type: ' || l_ce_spgt.organization_type ||
1800: ' Org id: ' || l_ce_spgt.organization_id ||
1801: ' Org name: ' || l_ce_spgt.name,
1802: debug_level => FND_LOG.LEVEL_STATEMENT,
1803: module => l_Debug_Module);
1804:
1805: END LOOP;
1806:

Line 1808: debug_level => FND_LOG.LEVEL_STATEMENT,

1804:
1805: END LOOP;
1806:
1807: iby_debug_pub.add(debug_msg => 'Done checking accessible orgs',
1808: debug_level => FND_LOG.LEVEL_STATEMENT,
1809: module => l_Debug_Module);
1810:
1811: ce_sp_access_C := ce_sp_access_C + 1;
1812:

Line 1844: debug_level => FND_LOG.LEVEL_STATEMENT,

1840:
1841: BEGIN
1842:
1843: iby_debug_pub.add(debug_msg => 'In validate_instruction_accessible(), before Init_Security',
1844: debug_level => FND_LOG.LEVEL_STATEMENT,
1845: module => l_Debug_Module);
1846:
1847: Init_Security;
1848:

Line 1850: debug_level => FND_LOG.LEVEL_STATEMENT,

1846:
1847: Init_Security;
1848:
1849: iby_debug_pub.add(debug_msg => 'In validate_instruction_accessible(), after Init_Security',
1850: debug_level => FND_LOG.LEVEL_STATEMENT,
1851: module => l_Debug_Module);
1852:
1853: FOR l_ins_org IN l_ins_org_csr(p_payment_instruction_id) LOOP
1854:

Line 1862: debug_level => FND_LOG.LEVEL_STATEMENT,

1858: IF l_validate_org_accessible_csr%NOTFOUND THEN
1859:
1860: iby_debug_pub.add(debug_msg => 'Org type: ' || l_ins_org.org_type || ' Org id: ' || l_ins_org.org_id ||
1861: ' is not accessible for user',
1862: debug_level => FND_LOG.LEVEL_STATEMENT,
1863: module => l_Debug_Module);
1864:
1865: CLOSE l_validate_org_accessible_csr;
1866: return 'N';

Line 1900: debug_level => FND_LOG.LEVEL_STATEMENT,

1896:
1897: Init_Security;
1898:
1899: iby_debug_pub.add(debug_msg => 'p_payment_instruction_id: ' || p_payment_instruction_id,
1900: debug_level => FND_LOG.LEVEL_STATEMENT,
1901: module => l_Debug_Module);
1902:
1903: OPEN l_accessible_orgs_csr (p_payment_instruction_id);
1904: FETCH l_accessible_orgs_csr INTO l_num_accessible_orgs;

Line 1908: debug_level => FND_LOG.LEVEL_STATEMENT,

1904: FETCH l_accessible_orgs_csr INTO l_num_accessible_orgs;
1905: CLOSE l_accessible_orgs_csr;
1906:
1907: iby_debug_pub.add(debug_msg => 'Number of orgs accessible for the user: ' || l_num_accessible_orgs,
1908: debug_level => FND_LOG.LEVEL_STATEMENT,
1909: module => l_Debug_Module);
1910:
1911: IF l_num_accessible_orgs >= 1 THEN
1912:

Line 1934: debug_level => FND_LOG.LEVEL_STATEMENT,

1930:
1931: Init_Security;
1932:
1933: iby_debug_pub.add(debug_msg => 'p_payment_service_request_id: ' || p_payment_service_request_id,
1934: debug_level => FND_LOG.LEVEL_STATEMENT,
1935: module => l_Debug_Module);
1936:
1937: l_num_accessible_orgs := get_accessible_ppr_org_count(p_payment_service_request_id);
1938:

Line 1940: debug_level => FND_LOG.LEVEL_STATEMENT,

1936:
1937: l_num_accessible_orgs := get_accessible_ppr_org_count(p_payment_service_request_id);
1938:
1939: iby_debug_pub.add(debug_msg => 'Number of orgs accessible for the user: ' || l_num_accessible_orgs,
1940: debug_level => FND_LOG.LEVEL_STATEMENT,
1941: module => l_Debug_Module);
1942:
1943: IF l_num_accessible_orgs >= 1 THEN
1944:

Line 2084: debug_level => FND_LOG.LEVEL_PROCEDURE,

2080:
2081: BEGIN
2082:
2083: iby_debug_pub.add(debug_msg => 'Enter: ' || l_Debug_Module,
2084: debug_level => FND_LOG.LEVEL_PROCEDURE,
2085: module => l_Debug_Module);
2086:
2087: iby_debug_pub.add(debug_msg => 'Input parameters: ',
2088: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 2088: debug_level => FND_LOG.LEVEL_STATEMENT,

2084: debug_level => FND_LOG.LEVEL_PROCEDURE,
2085: module => l_Debug_Module);
2086:
2087: iby_debug_pub.add(debug_msg => 'Input parameters: ',
2088: debug_level => FND_LOG.LEVEL_STATEMENT,
2089: module => l_Debug_Module);
2090:
2091: iby_debug_pub.add(debug_msg => '============================================',
2092: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 2092: debug_level => FND_LOG.LEVEL_STATEMENT,

2088: debug_level => FND_LOG.LEVEL_STATEMENT,
2089: module => l_Debug_Module);
2090:
2091: iby_debug_pub.add(debug_msg => '============================================',
2092: debug_level => FND_LOG.LEVEL_STATEMENT,
2093: module => l_Debug_Module);
2094:
2095: iby_debug_pub.add(debug_msg => 'p_payment_profile_id: ' || p_payment_profile_id,
2096: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 2096: debug_level => FND_LOG.LEVEL_STATEMENT,

2092: debug_level => FND_LOG.LEVEL_STATEMENT,
2093: module => l_Debug_Module);
2094:
2095: iby_debug_pub.add(debug_msg => 'p_payment_profile_id: ' || p_payment_profile_id,
2096: debug_level => FND_LOG.LEVEL_STATEMENT,
2097: module => l_Debug_Module);
2098:
2099: iby_debug_pub.add(debug_msg => 'p_sequence_number: ' || p_sequence_number,
2100: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 2100: debug_level => FND_LOG.LEVEL_STATEMENT,

2096: debug_level => FND_LOG.LEVEL_STATEMENT,
2097: module => l_Debug_Module);
2098:
2099: iby_debug_pub.add(debug_msg => 'p_sequence_number: ' || p_sequence_number,
2100: debug_level => FND_LOG.LEVEL_STATEMENT,
2101: module => l_Debug_Module);
2102:
2103: iby_debug_pub.add(debug_msg => 'p_reset_value: ' || p_reset_value,
2104: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 2104: debug_level => FND_LOG.LEVEL_STATEMENT,

2100: debug_level => FND_LOG.LEVEL_STATEMENT,
2101: module => l_Debug_Module);
2102:
2103: iby_debug_pub.add(debug_msg => 'p_reset_value: ' || p_reset_value,
2104: debug_level => FND_LOG.LEVEL_STATEMENT,
2105: module => l_Debug_Module);
2106:
2107: iby_debug_pub.add(debug_msg => '============================================',
2108: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 2108: debug_level => FND_LOG.LEVEL_STATEMENT,

2104: debug_level => FND_LOG.LEVEL_STATEMENT,
2105: module => l_Debug_Module);
2106:
2107: iby_debug_pub.add(debug_msg => '============================================',
2108: debug_level => FND_LOG.LEVEL_STATEMENT,
2109: module => l_Debug_Module);
2110:
2111:
2112: OPEN l_val_seq_csr;

Line 2170: debug_level => FND_LOG.LEVEL_PROCEDURE,

2166:
2167: END IF;
2168:
2169: iby_debug_pub.add(debug_msg => 'Exit: ' || l_Debug_Module,
2170: debug_level => FND_LOG.LEVEL_PROCEDURE,
2171: module => l_Debug_Module);
2172:
2173: END Reset_Periodic_Sequence_Value;
2174:

Line 2192: debug_level => FND_LOG.LEVEL_PROCEDURE,

2188:
2189: BEGIN
2190:
2191: iby_debug_pub.add(debug_msg => 'Enter: ' || l_Debug_Module,
2192: debug_level => FND_LOG.LEVEL_PROCEDURE,
2193: module => l_Debug_Module);
2194:
2195: iby_debug_pub.add(debug_msg => 'p_payment_profile_id: ' || p_payment_profile_id,
2196: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 2196: debug_level => FND_LOG.LEVEL_STATEMENT,

2192: debug_level => FND_LOG.LEVEL_PROCEDURE,
2193: module => l_Debug_Module);
2194:
2195: iby_debug_pub.add(debug_msg => 'p_payment_profile_id: ' || p_payment_profile_id,
2196: debug_level => FND_LOG.LEVEL_STATEMENT,
2197: module => l_Debug_Module);
2198:
2199: iby_debug_pub.add(debug_msg => 'p_sequence_number: ' || p_sequence_number,
2200: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 2200: debug_level => FND_LOG.LEVEL_STATEMENT,

2196: debug_level => FND_LOG.LEVEL_STATEMENT,
2197: module => l_Debug_Module);
2198:
2199: iby_debug_pub.add(debug_msg => 'p_sequence_number: ' || p_sequence_number,
2200: debug_level => FND_LOG.LEVEL_STATEMENT,
2201: module => l_Debug_Module);
2202:
2203: iby_debug_pub.add(debug_msg => 'p_reset_value: ' || p_reset_value,
2204: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 2204: debug_level => FND_LOG.LEVEL_STATEMENT,

2200: debug_level => FND_LOG.LEVEL_STATEMENT,
2201: module => l_Debug_Module);
2202:
2203: iby_debug_pub.add(debug_msg => 'p_reset_value: ' || p_reset_value,
2204: debug_level => FND_LOG.LEVEL_STATEMENT,
2205: module => l_Debug_Module);
2206:
2207: iby_debug_pub.add(debug_msg => 'Setting request to deferred',
2208: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 2208: debug_level => FND_LOG.LEVEL_STATEMENT,

2204: debug_level => FND_LOG.LEVEL_STATEMENT,
2205: module => l_Debug_Module);
2206:
2207: iby_debug_pub.add(debug_msg => 'Setting request to deferred',
2208: debug_level => FND_LOG.LEVEL_STATEMENT,
2209: module => l_Debug_Module);
2210:
2211: l_def_sts := fnd_request.set_deferred();
2212:

Line 2215: debug_level => FND_LOG.LEVEL_STATEMENT,

2211: l_def_sts := fnd_request.set_deferred();
2212:
2213: IF l_def_sts = FALSE THEN
2214: iby_debug_pub.add(debug_msg => 'Warning: failed to set request as deferred',
2215: debug_level => FND_LOG.LEVEL_STATEMENT,
2216: module => l_Debug_Module);
2217:
2218: END IF;
2219:

Line 2221: debug_level => FND_LOG.LEVEL_STATEMENT,

2217:
2218: END IF;
2219:
2220: iby_debug_pub.add(debug_msg => 'Before Calling FND_REQUEST.SUBMIT_REQUEST()',
2221: debug_level => FND_LOG.LEVEL_STATEMENT,
2222: module => l_Debug_Module);
2223:
2224:
2225: --Bug 6411356

Line 2259: debug_level => FND_LOG.LEVEL_STATEMENT,

2255: '', '', ''
2256: );
2257:
2258: iby_debug_pub.add(debug_msg => 'After Calling FND_REQUEST.SUBMIT_REQUEST()',
2259: debug_level => FND_LOG.LEVEL_STATEMENT,
2260: module => l_Debug_Module);
2261: iby_debug_pub.add(debug_msg => 'Request id: ' || l_request_id,
2262: debug_level => FND_LOG.LEVEL_STATEMENT,
2263: module => l_Debug_Module);

Line 2262: debug_level => FND_LOG.LEVEL_STATEMENT,

2258: iby_debug_pub.add(debug_msg => 'After Calling FND_REQUEST.SUBMIT_REQUEST()',
2259: debug_level => FND_LOG.LEVEL_STATEMENT,
2260: module => l_Debug_Module);
2261: iby_debug_pub.add(debug_msg => 'Request id: ' || l_request_id,
2262: debug_level => FND_LOG.LEVEL_STATEMENT,
2263: module => l_Debug_Module);
2264:
2265: iby_debug_pub.add(debug_msg => 'Exit: ' || l_Debug_Module,
2266: debug_level => FND_LOG.LEVEL_PROCEDURE,

Line 2266: debug_level => FND_LOG.LEVEL_PROCEDURE,

2262: debug_level => FND_LOG.LEVEL_STATEMENT,
2263: module => l_Debug_Module);
2264:
2265: iby_debug_pub.add(debug_msg => 'Exit: ' || l_Debug_Module,
2266: debug_level => FND_LOG.LEVEL_PROCEDURE,
2267: module => l_Debug_Module);
2268:
2269: RETURN l_request_id;
2270:

Line 2295: debug_level => FND_LOG.LEVEL_PROCEDURE,

2291:
2292: BEGIN
2293:
2294: iby_debug_pub.add(debug_msg => 'Enter: ' || l_Debug_Module,
2295: debug_level => FND_LOG.LEVEL_PROCEDURE,
2296: module => l_Debug_Module);
2297:
2298: iby_debug_pub.add(debug_msg => 'Input payment instruction ID: ' || p_payment_instruction_id,
2299: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 2299: debug_level => FND_LOG.LEVEL_STATEMENT,

2295: debug_level => FND_LOG.LEVEL_PROCEDURE,
2296: module => l_Debug_Module);
2297:
2298: iby_debug_pub.add(debug_msg => 'Input payment instruction ID: ' || p_payment_instruction_id,
2299: debug_level => FND_LOG.LEVEL_STATEMENT,
2300: module => l_Debug_Module);
2301:
2302: OPEN l_acp_ltr_fmt_csr;
2303: FETCH l_acp_ltr_fmt_csr INTO l_acp_ltr_fmt_code;

Line 2310: debug_level => FND_LOG.LEVEL_STATEMENT,

2306:
2307: IF l_fmt_notfound THEN
2308: iby_debug_pub.add(debug_msg => 'The payment process profile for the instruction does not have an ' ||
2309: 'accompany letter format. So no action is required. ',
2310: debug_level => FND_LOG.LEVEL_STATEMENT,
2311: module => l_Debug_Module);
2312: RETURN;
2313: END IF;
2314:

Line 2317: debug_level => FND_LOG.LEVEL_STATEMENT,

2313: END IF;
2314:
2315:
2316: iby_debug_pub.add(debug_msg => 'Before Calling FND_REQUEST.SUBMIT_REQUEST()',
2317: debug_level => FND_LOG.LEVEL_STATEMENT,
2318: module => l_Debug_Module);
2319:
2320:
2321: --Bug 6411356

Line 2354: debug_level => FND_LOG.LEVEL_STATEMENT,

2350: '', '', ''
2351: );
2352:
2353: iby_debug_pub.add(debug_msg => 'After Calling FND_REQUEST.SUBMIT_REQUEST()',
2354: debug_level => FND_LOG.LEVEL_STATEMENT,
2355: module => l_Debug_Module);
2356: iby_debug_pub.add(debug_msg => 'Request id: ' || l_request_id,
2357: debug_level => FND_LOG.LEVEL_STATEMENT,
2358: module => l_Debug_Module);

Line 2357: debug_level => FND_LOG.LEVEL_STATEMENT,

2353: iby_debug_pub.add(debug_msg => 'After Calling FND_REQUEST.SUBMIT_REQUEST()',
2354: debug_level => FND_LOG.LEVEL_STATEMENT,
2355: module => l_Debug_Module);
2356: iby_debug_pub.add(debug_msg => 'Request id: ' || l_request_id,
2357: debug_level => FND_LOG.LEVEL_STATEMENT,
2358: module => l_Debug_Module);
2359:
2360: iby_debug_pub.add(debug_msg => 'Exit: ' || l_Debug_Module,
2361: debug_level => FND_LOG.LEVEL_PROCEDURE,

Line 2361: debug_level => FND_LOG.LEVEL_PROCEDURE,

2357: debug_level => FND_LOG.LEVEL_STATEMENT,
2358: module => l_Debug_Module);
2359:
2360: iby_debug_pub.add(debug_msg => 'Exit: ' || l_Debug_Module,
2361: debug_level => FND_LOG.LEVEL_PROCEDURE,
2362: module => l_Debug_Module);
2363:
2364: COMMIT;
2365:

Line 2382: debug_level => FND_LOG.LEVEL_PROCEDURE,

2378: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Run_ECE_Formatting';
2379:
2380: BEGIN
2381: iby_debug_pub.log(debug_msg => 'Enter: Timestamp:' || systimestamp,
2382: debug_level => FND_LOG.LEVEL_PROCEDURE,
2383: module => l_Debug_Module);
2384: iby_debug_pub.add(debug_msg => 'Enter: ' || l_Debug_Module,
2385: debug_level => FND_LOG.LEVEL_PROCEDURE,
2386: module => l_Debug_Module);

Line 2385: debug_level => FND_LOG.LEVEL_PROCEDURE,

2381: iby_debug_pub.log(debug_msg => 'Enter: Timestamp:' || systimestamp,
2382: debug_level => FND_LOG.LEVEL_PROCEDURE,
2383: module => l_Debug_Module);
2384: iby_debug_pub.add(debug_msg => 'Enter: ' || l_Debug_Module,
2385: debug_level => FND_LOG.LEVEL_PROCEDURE,
2386: module => l_Debug_Module);
2387:
2388: iby_debug_pub.add(debug_msg => 'Input payment instruction ID: ' || p_payment_instruction_id,
2389: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 2389: debug_level => FND_LOG.LEVEL_STATEMENT,

2385: debug_level => FND_LOG.LEVEL_PROCEDURE,
2386: module => l_Debug_Module);
2387:
2388: iby_debug_pub.add(debug_msg => 'Input payment instruction ID: ' || p_payment_instruction_id,
2389: debug_level => FND_LOG.LEVEL_STATEMENT,
2390: module => l_Debug_Module);
2391:
2392: iby_debug_pub.add(debug_msg => 'Calling IBY_PYO_TRANSACTION.Extract_PYO_Outbound() API... ' || l_ece_status,
2393: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 2393: debug_level => FND_LOG.LEVEL_STATEMENT,

2389: debug_level => FND_LOG.LEVEL_STATEMENT,
2390: module => l_Debug_Module);
2391:
2392: iby_debug_pub.add(debug_msg => 'Calling IBY_PYO_TRANSACTION.Extract_PYO_Outbound() API... ' || l_ece_status,
2393: debug_level => FND_LOG.LEVEL_STATEMENT,
2394: module => l_Debug_Module);
2395:
2396:
2397: IBY_PYO_TRANSACTION.Extract_PYO_Outbound ( p_api_version => 1.0,

Line 2405: debug_level => FND_LOG.LEVEL_PROCEDURE,

2401: x_msg_count => l_msg_count,
2402: x_msg_data => l_msg_data,
2403: p_payment_instruction_id => p_payment_instruction_id);
2404: iby_debug_pub.log(debug_msg => 'Exit IBY_PYO_TRANSACTION: Timestamp:' || systimestamp,
2405: debug_level => FND_LOG.LEVEL_PROCEDURE,
2406: module => l_Debug_Module);
2407:
2408: iby_debug_pub.add(debug_msg => 'After calling IBY_PYO_TRANSACTION.Extract_PYO_Outbound() API, return status: ' || l_ece_status,
2409: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 2409: debug_level => FND_LOG.LEVEL_STATEMENT,

2405: debug_level => FND_LOG.LEVEL_PROCEDURE,
2406: module => l_Debug_Module);
2407:
2408: iby_debug_pub.add(debug_msg => 'After calling IBY_PYO_TRANSACTION.Extract_PYO_Outbound() API, return status: ' || l_ece_status,
2409: debug_level => FND_LOG.LEVEL_STATEMENT,
2410: module => l_Debug_Module);
2411:
2412: IF l_ece_status = FND_API.G_RET_STS_SUCCESS THEN
2413:

Line 2415: debug_level => FND_LOG.LEVEL_STATEMENT,

2411:
2412: IF l_ece_status = FND_API.G_RET_STS_SUCCESS THEN
2413:
2414: iby_debug_pub.add(debug_msg => 'Calling Post_Results()',
2415: debug_level => FND_LOG.LEVEL_STATEMENT,
2416: module => l_Debug_Module);
2417: iby_debug_pub.log(debug_msg => 'Enter: Post Results::Timestamp:' || systimestamp,
2418: debug_level => FND_LOG.LEVEL_PROCEDURE,
2419: module => l_Debug_Module);

Line 2418: debug_level => FND_LOG.LEVEL_PROCEDURE,

2414: iby_debug_pub.add(debug_msg => 'Calling Post_Results()',
2415: debug_level => FND_LOG.LEVEL_STATEMENT,
2416: module => l_Debug_Module);
2417: iby_debug_pub.log(debug_msg => 'Enter: Post Results::Timestamp:' || systimestamp,
2418: debug_level => FND_LOG.LEVEL_PROCEDURE,
2419: module => l_Debug_Module);
2420: IBY_FD_POST_PICP_PROGS_PVT.Post_Results
2421: (
2422: p_payment_instruction_id => p_payment_instruction_id,

Line 2428: debug_level => FND_LOG.LEVEL_PROCEDURE,

2424: p_is_reprint_flag => 'N',
2425: x_return_status => l_post_status
2426: );
2427: iby_debug_pub.log(debug_msg => 'Exit: Post Results::Timestamp:' || systimestamp,
2428: debug_level => FND_LOG.LEVEL_PROCEDURE,
2429: module => l_Debug_Module);
2430:
2431: iby_debug_pub.add(debug_msg => 'After calling Post_Results(), return status: ' || l_post_status,
2432: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 2432: debug_level => FND_LOG.LEVEL_STATEMENT,

2428: debug_level => FND_LOG.LEVEL_PROCEDURE,
2429: module => l_Debug_Module);
2430:
2431: iby_debug_pub.add(debug_msg => 'After calling Post_Results(), return status: ' || l_post_status,
2432: debug_level => FND_LOG.LEVEL_STATEMENT,
2433: module => l_Debug_Module);
2434:
2435: IF l_post_status <> FND_API.G_RET_STS_SUCCESS THEN
2436: RAISE FND_API.G_EXC_ERROR;

Line 2444: debug_level => FND_LOG.LEVEL_PROCEDURE,

2440: RAISE FND_API.G_EXC_ERROR;
2441: END IF;
2442:
2443: iby_debug_pub.add(debug_msg => 'Exit: ' || l_Debug_Module,
2444: debug_level => FND_LOG.LEVEL_PROCEDURE,
2445: module => l_Debug_Module);
2446:
2447: END Run_ECE_Formatting;
2448:

Line 2465: debug_level => FND_LOG.LEVEL_PROCEDURE,

2461:
2462: BEGIN
2463:
2464: iby_debug_pub.add(debug_msg => 'Enter: ' || l_Debug_Module,
2465: debug_level => FND_LOG.LEVEL_PROCEDURE,
2466: module => l_Debug_Module);
2467:
2468: iby_debug_pub.add(debug_msg => 'Input payment instruction ID: ' || p_payment_instruction_id,
2469: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 2469: debug_level => FND_LOG.LEVEL_STATEMENT,

2465: debug_level => FND_LOG.LEVEL_PROCEDURE,
2466: module => l_Debug_Module);
2467:
2468: iby_debug_pub.add(debug_msg => 'Input payment instruction ID: ' || p_payment_instruction_id,
2469: debug_level => FND_LOG.LEVEL_STATEMENT,
2470: module => l_Debug_Module);
2471:
2472:
2473: iby_debug_pub.add(debug_msg => 'Before Calling FND_REQUEST.SUBMIT_REQUEST()',

Line 2474: debug_level => FND_LOG.LEVEL_STATEMENT,

2470: module => l_Debug_Module);
2471:
2472:
2473: iby_debug_pub.add(debug_msg => 'Before Calling FND_REQUEST.SUBMIT_REQUEST()',
2474: debug_level => FND_LOG.LEVEL_STATEMENT,
2475: module => l_Debug_Module);
2476:
2477:
2478: --Bug 6411356

Line 2509: debug_level => FND_LOG.LEVEL_STATEMENT,

2505: '', '', ''
2506: );
2507:
2508: iby_debug_pub.add(debug_msg => 'After Calling FND_REQUEST.SUBMIT_REQUEST()',
2509: debug_level => FND_LOG.LEVEL_STATEMENT,
2510: module => l_Debug_Module);
2511: iby_debug_pub.add(debug_msg => 'Request id: ' || l_request_id,
2512: debug_level => FND_LOG.LEVEL_STATEMENT,
2513: module => l_Debug_Module);

Line 2512: debug_level => FND_LOG.LEVEL_STATEMENT,

2508: iby_debug_pub.add(debug_msg => 'After Calling FND_REQUEST.SUBMIT_REQUEST()',
2509: debug_level => FND_LOG.LEVEL_STATEMENT,
2510: module => l_Debug_Module);
2511: iby_debug_pub.add(debug_msg => 'Request id: ' || l_request_id,
2512: debug_level => FND_LOG.LEVEL_STATEMENT,
2513: module => l_Debug_Module);
2514:
2515: IF l_request_id = 0 THEN
2516: RAISE FND_API.G_EXC_ERROR;

Line 2520: debug_level => FND_LOG.LEVEL_PROCEDURE,

2516: RAISE FND_API.G_EXC_ERROR;
2517: END IF;
2518:
2519: iby_debug_pub.add(debug_msg => 'Exit: ' || l_Debug_Module,
2520: debug_level => FND_LOG.LEVEL_PROCEDURE,
2521: module => l_Debug_Module);
2522:
2523: END Test_CP;
2524:

Line 2546: debug_level => FND_LOG.LEVEL_PROCEDURE,

2542:
2543: BEGIN
2544:
2545: iby_debug_pub.add(debug_msg => 'Enter IBY_FD_POST_PICP_PROGS_PVT.Run_Post_Transmit_Programs' || systimestamp,
2546: debug_level => FND_LOG.LEVEL_PROCEDURE,
2547: module => l_Debug_Module);
2548: iby_debug_pub.add(debug_msg => 'Before Calling IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete().',
2549: debug_level => FND_LOG.LEVEL_STATEMENT,
2550: module => l_Debug_Module);

Line 2549: debug_level => FND_LOG.LEVEL_STATEMENT,

2545: iby_debug_pub.add(debug_msg => 'Enter IBY_FD_POST_PICP_PROGS_PVT.Run_Post_Transmit_Programs' || systimestamp,
2546: debug_level => FND_LOG.LEVEL_PROCEDURE,
2547: module => l_Debug_Module);
2548: iby_debug_pub.add(debug_msg => 'Before Calling IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete().',
2549: debug_level => FND_LOG.LEVEL_STATEMENT,
2550: module => l_Debug_Module);
2551:
2552: IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete (
2553: p_instr_id => p_payment_instruction_id,

Line 2558: debug_level => FND_LOG.LEVEL_STATEMENT,

2554: x_return_status => l_mark_complete_status
2555: );
2556:
2557: iby_debug_pub.add(debug_msg => 'After Calling IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete().',
2558: debug_level => FND_LOG.LEVEL_STATEMENT,
2559: module => l_Debug_Module);
2560:
2561:
2562: IF l_mark_complete_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 2587: debug_level => FND_LOG.LEVEL_STATEMENT,

2583: IF l_msg_data IS NULL THEN
2584: EXIT;
2585: ELSE
2586: iby_debug_pub.add(debug_msg => l_msg_data,
2587: debug_level => FND_LOG.LEVEL_STATEMENT,
2588: module => l_Debug_Module);
2589: END IF;
2590: END LOOP;
2591: RAISE FND_API.G_EXC_ERROR;

Line 2602: debug_level => FND_LOG.LEVEL_STATEMENT,

2598: IF l_msg_data IS NULL THEN
2599: EXIT;
2600: ELSE
2601: iby_debug_pub.add(debug_msg => l_msg_data,
2602: debug_level => FND_LOG.LEVEL_STATEMENT,
2603: module => l_Debug_Module);
2604: END IF;
2605: END LOOP;
2606: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2617: debug_level => FND_LOG.LEVEL_STATEMENT,

2613: IF l_msg_data IS NULL THEN
2614: EXIT;
2615: ELSE
2616: iby_debug_pub.add(debug_msg => l_msg_data,
2617: debug_level => FND_LOG.LEVEL_STATEMENT,
2618: module => l_Debug_Module);
2619: END IF;
2620: END LOOP;
2621: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;