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 IBY_DEBUG_PUB

Line 76: iby_debug_pub.add(debug_msg => 'Enter: ' || l_Debug_Module,

72:
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: ',

Line 80: iby_debug_pub.add(debug_msg => 'Input parameters: ',

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,
82: module => l_Debug_Module);
83:
84: iby_debug_pub.add(debug_msg => '============================================',

Line 84: iby_debug_pub.add(debug_msg => '============================================',

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,
86: module => l_Debug_Module);
87:
88: iby_debug_pub.add(debug_msg => 'p_payment_instruction_id: ' || p_payment_instruction_id,

Line 88: iby_debug_pub.add(debug_msg => 'p_payment_instruction_id: ' || p_payment_instruction_id,

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,
90: module => l_Debug_Module);
91:
92: iby_debug_pub.add(debug_msg => 'p_summary_format_code: ' || p_summary_format_code,

Line 92: iby_debug_pub.add(debug_msg => 'p_summary_format_code: ' || p_summary_format_code,

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,
94: module => l_Debug_Module);
95:
96: iby_debug_pub.add(debug_msg => 'p_ecs_dos_seq_num: ' || p_ecs_dos_seq_num,

Line 96: iby_debug_pub.add(debug_msg => 'p_ecs_dos_seq_num: ' || p_ecs_dos_seq_num,

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,
98: module => l_Debug_Module);
99:
100: iby_debug_pub.add(debug_msg => '============================================',

Line 100: iby_debug_pub.add(debug_msg => '============================================',

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,
102: module => l_Debug_Module);
103:
104: iby_debug_pub.add(debug_msg => 'Before Calling FND_REQUEST.SUBMIT_REQUEST().',

Line 104: iby_debug_pub.add(debug_msg => 'Before Calling FND_REQUEST.SUBMIT_REQUEST().',

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,
106: module => l_Debug_Module);
107:
108: --Bug 6411356

Line 141: iby_debug_pub.add(debug_msg => 'After Calling FND_REQUEST.SUBMIT_REQUEST().',

137: '', '', '', '', '', '', '', '',
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,

Line 145: iby_debug_pub.add(debug_msg => 'Request id: ' || x_request_id,

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,
147: module => l_Debug_Module);
148:
149: --

Line 228: iby_debug_pub.add(debug_msg => 'Enter: ' || l_Debug_Module,

224: AND ins.payment_profile_id = pp.payment_profile_id;
225:
226: BEGIN
227:
228: iby_debug_pub.add(debug_msg => 'Enter: ' || l_Debug_Module,
229: debug_level => FND_LOG.LEVEL_PROCEDURE,
230: module => l_Debug_Module);
231:
232: iby_debug_pub.add(debug_msg => 'Input payment instruction ID: ' || p_payment_instruction_id,

Line 232: iby_debug_pub.add(debug_msg => 'Input payment instruction ID: ' || p_payment_instruction_id,

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

Line 274: iby_debug_pub.add(debug_msg => 'Set request implicit to NO ',

270: -- the CM will set the implicit to YES
271: l_set_opt_ok := FND_REQUEST.SET_OPTIONS;
272:
273: IF l_set_opt_ok THEN
274: iby_debug_pub.add(debug_msg => 'Set request implicit to NO ',
275: debug_level => FND_LOG.LEVEL_STATEMENT,
276: module => l_Debug_Module);
277: ELSE
278: iby_debug_pub.add(debug_msg => 'Warning: unable to set request options ',

Line 278: iby_debug_pub.add(debug_msg => 'Warning: unable to set request options ',

274: iby_debug_pub.add(debug_msg => 'Set request implicit to NO ',
275: debug_level => FND_LOG.LEVEL_STATEMENT,
276: module => l_Debug_Module);
277: ELSE
278: iby_debug_pub.add(debug_msg => 'Warning: unable to set request options ',
279: debug_level => FND_LOG.LEVEL_STATEMENT,
280: module => l_Debug_Module);
281: END IF;
282:

Line 291: iby_debug_pub.add(debug_msg => 'The payment instruction format output is to be printed.',

287: l_run_print := true;
288: END IF;
289:
290: IF l_run_print THEN
291: iby_debug_pub.add(debug_msg => 'The payment instruction format output is to be printed.',
292: debug_level => FND_LOG.LEVEL_STATEMENT,
293: module => l_Debug_Module);
294:
295: SELECT nvl(pp.disallow_save_print_flag,'N') into l_save_no_output

Line 317: iby_debug_pub.add(debug_msg => 'The printer is to: ' || l_printer_name,

313: END IF;
314:
315:
316: IF l_set_print_opt_ok THEN
317: iby_debug_pub.add(debug_msg => 'The printer is to: ' || l_printer_name,
318: debug_level => FND_LOG.LEVEL_STATEMENT,
319: module => l_Debug_Module);
320: ELSE
321: iby_debug_pub.add(debug_msg => 'Warning: unable to set printer',

Line 321: iby_debug_pub.add(debug_msg => 'Warning: unable to set printer',

317: iby_debug_pub.add(debug_msg => 'The printer is to: ' || l_printer_name,
318: debug_level => FND_LOG.LEVEL_STATEMENT,
319: module => l_Debug_Module);
320: ELSE
321: iby_debug_pub.add(debug_msg => 'Warning: unable to set printer',
322: debug_level => FND_LOG.LEVEL_STATEMENT,
323: module => l_Debug_Module);
324: END IF;
325:

Line 326: iby_debug_pub.add(debug_msg => 'Before Calling FND_REQUEST.SUBMIT_REQUEST().',

322: debug_level => FND_LOG.LEVEL_STATEMENT,
323: module => l_Debug_Module);
324: END IF;
325:
326: iby_debug_pub.add(debug_msg => 'Before Calling FND_REQUEST.SUBMIT_REQUEST().',
327: debug_level => FND_LOG.LEVEL_STATEMENT,
328: module => l_Debug_Module);
329:
330: --Bug 6411356

Line 404: iby_debug_pub.add(debug_msg => 'Submitting request for format payment program for PDF output',

400: '', '', '', '', '', '', '', '',
401: '', '', ''
402: );
403:
404: iby_debug_pub.add(debug_msg => 'Submitting request for format payment program for PDF output',
405: debug_level => FND_LOG.LEVEL_STATEMENT,
406: module => l_Debug_Module);
407:
408: ELSE

Line 434: iby_debug_pub.add(debug_msg => 'Submitting request for format payment program for text/xml output',

430: '', '', '', '', '', '', '', '',
431: '', '', ''
432: );
433:
434: iby_debug_pub.add(debug_msg => 'Submitting request for format payment program for text/xml output',
435: debug_level => FND_LOG.LEVEL_STATEMENT,
436: module => l_Debug_Module);
437:
438: END IF;

Line 440: iby_debug_pub.add(debug_msg => 'After Calling FND_REQUEST.SUBMIT_REQUEST().',

436: module => l_Debug_Module);
437:
438: END IF;
439:
440: iby_debug_pub.add(debug_msg => 'After Calling FND_REQUEST.SUBMIT_REQUEST().',
441: debug_level => FND_LOG.LEVEL_STATEMENT,
442: module => l_Debug_Module);
443: iby_debug_pub.add(debug_msg => 'Request id: ' || l_request_id,
444: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 443: iby_debug_pub.add(debug_msg => 'Request id: ' || l_request_id,

439:
440: iby_debug_pub.add(debug_msg => 'After Calling FND_REQUEST.SUBMIT_REQUEST().',
441: debug_level => FND_LOG.LEVEL_STATEMENT,
442: module => l_Debug_Module);
443: iby_debug_pub.add(debug_msg => 'Request id: ' || l_request_id,
444: debug_level => FND_LOG.LEVEL_STATEMENT,
445: module => l_Debug_Module);
446:
447: IF l_request_id = 0 THEN

Line 451: iby_debug_pub.add(debug_msg => 'Calling the lock_pmt_entity() API to lock instruction: ' || p_payment_instruction_id

447: IF l_request_id = 0 THEN
448: RAISE FND_API.G_EXC_ERROR;
449: ELSE
450:
451: iby_debug_pub.add(debug_msg => 'Calling the lock_pmt_entity() API to lock instruction: ' || p_payment_instruction_id
452: || ' for the extract/formatting/printing/delivery program',
453: debug_level => FND_LOG.LEVEL_STATEMENT,
454: module => l_Debug_Module);
455:

Line 466: iby_debug_pub.add(debug_msg => 'lock_pmt_entity() API returned success',

462:
463: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
464: RAISE FND_API.G_EXC_ERROR;
465: ELSE
466: iby_debug_pub.add(debug_msg => 'lock_pmt_entity() API returned success',
467: debug_level => FND_LOG.LEVEL_STATEMENT,
468: module => l_Debug_Module);
469: END IF;
470:

Line 473: iby_debug_pub.add(debug_msg => 'Exit: ' || l_Debug_Module,

469: END IF;
470:
471: END IF;
472:
473: iby_debug_pub.add(debug_msg => 'Exit: ' || l_Debug_Module,
474: debug_level => FND_LOG.LEVEL_PROCEDURE,
475: module => l_Debug_Module);
476:
477: END Run_Post_PI_Programs;

Line 521: iby_debug_pub.add(debug_msg => 'Enter: ' || l_Debug_Module,

517: AND payment_status in ('READY_TO_REPRINT', 'VOID_BY_SETUP_REPRINT', 'VOID_BY_OVERFLOW_REPRINT');
518:
519: BEGIN
520:
521: iby_debug_pub.add(debug_msg => 'Enter: ' || l_Debug_Module,
522: debug_level => FND_LOG.LEVEL_PROCEDURE,
523: module => l_Debug_Module);
524:
525: iby_debug_pub.add(debug_msg => 'Input payment instruction ID: ' || p_payment_instruction_id,

Line 525: iby_debug_pub.add(debug_msg => 'Input payment instruction ID: ' || p_payment_instruction_id,

521: iby_debug_pub.add(debug_msg => 'Enter: ' || l_Debug_Module,
522: debug_level => FND_LOG.LEVEL_PROCEDURE,
523: module => l_Debug_Module);
524:
525: iby_debug_pub.add(debug_msg => 'Input payment instruction ID: ' || p_payment_instruction_id,
526: debug_level => FND_LOG.LEVEL_STATEMENT,
527: module => l_Debug_Module);
528:
529: iby_debug_pub.add(debug_msg => 'Input instruction status: ' || p_newStatus,

Line 529: iby_debug_pub.add(debug_msg => 'Input instruction status: ' || p_newStatus,

525: iby_debug_pub.add(debug_msg => 'Input payment instruction ID: ' || p_payment_instruction_id,
526: debug_level => FND_LOG.LEVEL_STATEMENT,
527: module => l_Debug_Module);
528:
529: iby_debug_pub.add(debug_msg => 'Input instruction status: ' || p_newStatus,
530: debug_level => FND_LOG.LEVEL_STATEMENT,
531: module => l_Debug_Module);
532:
533: iby_debug_pub.add(debug_msg => 'Input is_reprint_flag: ' || p_is_reprint_flag,

Line 533: iby_debug_pub.add(debug_msg => 'Input is_reprint_flag: ' || p_is_reprint_flag,

529: iby_debug_pub.add(debug_msg => 'Input instruction status: ' || p_newStatus,
530: debug_level => FND_LOG.LEVEL_STATEMENT,
531: module => l_Debug_Module);
532:
533: iby_debug_pub.add(debug_msg => 'Input is_reprint_flag: ' || p_is_reprint_flag,
534: debug_level => FND_LOG.LEVEL_STATEMENT,
535: module => l_Debug_Module);
536:
537: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 544: iby_debug_pub.add(debug_msg => 'Current instruction status is: ' || l_instr_status,

540: FETCH l_instruction_ovn_csr INTO l_instruction_ovn, l_instr_status, l_proc_type,
541: l_mark_complete_event, l_format_code, l_pp_prt_immed, l_process_type;
542: CLOSE l_instruction_ovn_csr;
543:
544: iby_debug_pub.add(debug_msg => 'Current instruction status is: ' || l_instr_status,
545: debug_level => FND_LOG.LEVEL_STATEMENT,
546: module => l_Debug_Module);
547:
548: iby_debug_pub.add(debug_msg => 'Setting instruction to the input status: ' || p_newStatus,

Line 548: iby_debug_pub.add(debug_msg => 'Setting instruction to the input status: ' || p_newStatus,

544: iby_debug_pub.add(debug_msg => 'Current instruction status is: ' || l_instr_status,
545: debug_level => FND_LOG.LEVEL_STATEMENT,
546: module => l_Debug_Module);
547:
548: iby_debug_pub.add(debug_msg => 'Setting instruction to the input status: ' || p_newStatus,
549: debug_level => FND_LOG.LEVEL_STATEMENT,
550: module => l_Debug_Module);
551:
552: -- bug 5121763: single payments handling. PICP would mark complete and set

Line 579: iby_debug_pub.add(debug_msg => 'Payment ' || l_payment.payment_id || ' is in ' || l_payment.payment_status ||

575: FOR l_payment IN l_pmt_csr(p_payment_instruction_id) LOOP
576:
577: IF l_payment.payment_status IN ('FORMATTED', 'INSTRUCTION_CREATED') THEN
578:
579: iby_debug_pub.add(debug_msg => 'Payment ' || l_payment.payment_id || ' is in ' || l_payment.payment_status ||
580: ' status. Setting it to SUBMITTED_FOR_PRINTING',
581: debug_level => FND_LOG.LEVEL_STATEMENT,
582: module => l_Debug_Module);
583:

Line 603: iby_debug_pub.add(debug_msg => 'Payment ' || l_payment.payment_id || ' is in ' || l_payment.payment_status ||

599: FOR l_payment IN l_pmt_reprt_csr(p_payment_instruction_id) LOOP
600:
601: IF l_payment.payment_status = 'READY_TO_REPRINT' THEN
602:
603: iby_debug_pub.add(debug_msg => 'Payment ' || l_payment.payment_id || ' is in ' || l_payment.payment_status ||
604: ' status. Setting it to SUBMITTED_FOR_PRINTING',
605: debug_level => FND_LOG.LEVEL_STATEMENT,
606: module => l_Debug_Module);
607:

Line 621: iby_debug_pub.add(debug_msg => 'Payment ' || l_payment.payment_id || ' is in ' || l_payment.payment_status ||

617: payment_id = l_payment.payment_id;
618:
619: ELSIF l_payment.payment_status = 'VOID_BY_SETUP_REPRINT' THEN
620:
621: iby_debug_pub.add(debug_msg => 'Payment ' || l_payment.payment_id || ' is in ' || l_payment.payment_status ||
622: ' status. Setting it to VOID_BY_SETUP',
623: debug_level => FND_LOG.LEVEL_STATEMENT,
624: module => l_Debug_Module);
625:

Line 639: iby_debug_pub.add(debug_msg => 'Payment ' || l_payment.payment_id || ' is in ' || l_payment.payment_status ||

635: payment_id = l_payment.payment_id;
636:
637: ELSIF l_payment.payment_status = 'VOID_BY_OVERFLOW_REPRINT' THEN
638:
639: iby_debug_pub.add(debug_msg => 'Payment ' || l_payment.payment_id || ' is in ' || l_payment.payment_status ||
640: ' status. Setting it to VOID_BY_OVERFLOW',
641: debug_level => FND_LOG.LEVEL_STATEMENT,
642: module => l_Debug_Module);
643:

Line 668: iby_debug_pub.add(debug_msg => 'Payment ' || l_payment.payment_id || ' is in ' || l_payment.payment_status ||

664: FOR l_payment IN l_pmt_csr(p_payment_instruction_id) LOOP
665:
666: IF l_payment.payment_status = 'INSTRUCTION_CREATED' THEN
667:
668: iby_debug_pub.add(debug_msg => 'Payment ' || l_payment.payment_id || ' is in ' || l_payment.payment_status ||
669: ' status. Setting it to FORMATTED',
670: debug_level => FND_LOG.LEVEL_STATEMENT,
671: module => l_Debug_Module);
672:

Line 695: iby_debug_pub.add(debug_msg => 'Payment ' || l_payment.payment_id || ' is in ' || l_payment.payment_status ||

691: FOR l_payment IN l_pmt_csr(p_payment_instruction_id) LOOP
692:
693: IF l_payment.payment_status = 'INSTRUCTION_CREATED' THEN
694:
695: iby_debug_pub.add(debug_msg => 'Payment ' || l_payment.payment_id || ' is in ' || l_payment.payment_status ||
696: ' status. Setting it to FORMATTED',
697: debug_level => FND_LOG.LEVEL_STATEMENT,
698: module => l_Debug_Module);
699:

Line 716: iby_debug_pub.add(debug_msg => 'Before Calling IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete().',

712: END LOOP;
713:
714: IF l_mark_complete_event = 'FORMATTED' THEN
715:
716: iby_debug_pub.add(debug_msg => 'Before Calling IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete().',
717: debug_level => FND_LOG.LEVEL_STATEMENT,
718: module => l_Debug_Module);
719:
720: -- the payment completion point must be set as FORMATTED in the PPP

Line 727: iby_debug_pub.add(debug_msg => 'After Calling IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete().',

723: p_instr_id => p_payment_instruction_id,
724: x_return_status => l_mark_complete_status
725: );
726:
727: iby_debug_pub.add(debug_msg => 'After Calling IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete().',
728: debug_level => FND_LOG.LEVEL_STATEMENT,
729: module => l_Debug_Module);
730:
731: IF l_mark_complete_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 749: iby_debug_pub.add(debug_msg => 'Payment ' || l_payment.payment_id || ' is in ' || l_payment.payment_status ||

745: FOR l_payment IN l_pmt_csr(p_payment_instruction_id) LOOP
746:
747: IF l_payment.payment_status = 'INSTRUCTION_CREATED' THEN
748:
749: iby_debug_pub.add(debug_msg => 'Payment ' || l_payment.payment_id || ' is in ' || l_payment.payment_status ||
750: ' status. Setting it to FORMATTED',
751: debug_level => FND_LOG.LEVEL_STATEMENT,
752: module => l_Debug_Module);
753:

Line 783: iby_debug_pub.add(debug_msg => 'Payment ' || l_payment.payment_id || ' is in ' || l_payment.payment_status ||

779: FOR l_payment IN l_pmt_csr(p_payment_instruction_id) LOOP
780:
781: IF l_payment.payment_status = 'INSTRUCTION_CREATED' THEN
782:
783: iby_debug_pub.add(debug_msg => 'Payment ' || l_payment.payment_id || ' is in ' || l_payment.payment_status ||
784: ' status. Setting it to FORMATTED',
785: debug_level => FND_LOG.LEVEL_STATEMENT,
786: module => l_Debug_Module);
787:

Line 804: iby_debug_pub.add(debug_msg => 'Before Calling IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete().',

800: END LOOP;
801:
802: IF l_mark_complete_event = 'FORMATTED' THEN
803:
804: iby_debug_pub.add(debug_msg => 'Before Calling IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete().',
805: debug_level => FND_LOG.LEVEL_STATEMENT,
806: module => l_Debug_Module);
807:
808: -- call the mark complete API

Line 814: iby_debug_pub.add(debug_msg => 'After Calling IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete().',

810: p_instr_id => p_payment_instruction_id,
811: x_return_status => l_mark_complete_status
812: );
813:
814: iby_debug_pub.add(debug_msg => 'After Calling IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete().',
815: debug_level => FND_LOG.LEVEL_STATEMENT,
816: module => l_Debug_Module);
817:
818: IF l_mark_complete_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 836: iby_debug_pub.add(debug_msg => 'Payment ' || l_payment.payment_id || ' is in ' || l_payment.payment_status ||

832: FOR l_payment IN l_pmt_csr(p_payment_instruction_id) LOOP
833:
834: IF l_payment.payment_status IN ('FORMATTED', 'INSTRUCTION_CREATED') THEN
835:
836: iby_debug_pub.add(debug_msg => 'Payment ' || l_payment.payment_id || ' is in ' || l_payment.payment_status ||
837: ' status. Setting it to TRANSMITTED',
838: debug_level => FND_LOG.LEVEL_STATEMENT,
839: module => l_Debug_Module);
840:

Line 861: iby_debug_pub.add(debug_msg => 'Before Calling IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete().',

857: event status (i.e. 'FORMATTED', 'TRANSMITTED')
858: */
859: IF l_mark_complete_event in ('FORMATTED', 'TRANSMITTED') THEN
860:
861: iby_debug_pub.add(debug_msg => 'Before Calling IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete().',
862: debug_level => FND_LOG.LEVEL_STATEMENT,
863: module => l_Debug_Module);
864:
865: -- call the mark complete API

Line 871: iby_debug_pub.add(debug_msg => 'After Calling IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete().',

867: p_instr_id => p_payment_instruction_id,
868: x_return_status => l_mark_complete_status
869: );
870:
871: iby_debug_pub.add(debug_msg => 'After Calling IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete().',
872: debug_level => FND_LOG.LEVEL_STATEMENT,
873: module => l_Debug_Module);
874:
875: IF l_mark_complete_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 898: iby_debug_pub.add(debug_msg => 'Payment ' || l_payment.payment_id || ' is in ' || l_payment.payment_status ||

894: FOR l_payment IN l_pmt_csr(p_payment_instruction_id) LOOP
895:
896: IF l_payment.payment_status IN ('INSTRUCTION_CREATED') THEN
897:
898: iby_debug_pub.add(debug_msg => 'Payment ' || l_payment.payment_id || ' is in ' || l_payment.payment_status ||
899: ' status. Setting it to FORMATTED',
900: debug_level => FND_LOG.LEVEL_STATEMENT,
901: module => l_Debug_Module);
902:

Line 919: iby_debug_pub.add(debug_msg => 'Before Calling IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete().',

915: END LOOP;
916:
917: IF l_mark_complete_event = 'FORMATTED' THEN
918:
919: iby_debug_pub.add(debug_msg => 'Before Calling IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete().',
920: debug_level => FND_LOG.LEVEL_STATEMENT,
921: module => l_Debug_Module);
922:
923: -- call the mark complete API

Line 929: iby_debug_pub.add(debug_msg => 'After Calling IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete().',

925: p_instr_id => p_payment_instruction_id,
926: x_return_status => l_mark_complete_status
927: );
928:
929: iby_debug_pub.add(debug_msg => 'After Calling IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete().',
930: debug_level => FND_LOG.LEVEL_STATEMENT,
931: module => l_Debug_Module);
932:
933: IF l_mark_complete_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 952: iby_debug_pub.add(debug_msg => 'Exit: ' || l_Debug_Module,

948: -- finally kick off Federal "Payment Instruction Treasury Symbol Listing Report"
949: -- if its a Federal format
950: Submit_FV_TS_Report(p_payment_instruction_id, l_format_code, l_Debug_Module);
951:
952: iby_debug_pub.add(debug_msg => 'Exit: ' || l_Debug_Module,
953: debug_level => FND_LOG.LEVEL_PROCEDURE,
954: module => l_Debug_Module);
955:
956: EXCEPTION

Line 967: iby_debug_pub.add(debug_msg => l_msg_data,

963:
964: IF l_msg_data IS NULL THEN
965: EXIT;
966: ELSE
967: iby_debug_pub.add(debug_msg => l_msg_data,
968: debug_level => FND_LOG.LEVEL_STATEMENT,
969: module => l_Debug_Module);
970: END IF;
971: END LOOP;

Line 982: iby_debug_pub.add(debug_msg => l_msg_data,

978:
979: IF l_msg_data IS NULL THEN
980: EXIT;
981: ELSE
982: iby_debug_pub.add(debug_msg => l_msg_data,
983: debug_level => FND_LOG.LEVEL_STATEMENT,
984: module => l_Debug_Module);
985: END IF;
986: END LOOP;

Line 997: iby_debug_pub.add(debug_msg => l_msg_data,

993:
994: IF l_msg_data IS NULL THEN
995: EXIT;
996: ELSE
997: iby_debug_pub.add(debug_msg => l_msg_data,
998: debug_level => FND_LOG.LEVEL_STATEMENT,
999: module => l_Debug_Module);
1000: END IF;
1001: END LOOP;

Line 1033: iby_debug_pub.add(debug_msg => 'Federal submit_pay_instr_ts_report() returns success.',

1029: x_msg_data => l_fv_ts_req_msg_dt
1030: );
1031:
1032: IF l_fv_ts_req_status = FND_API.G_RET_STS_SUCCESS THEN
1033: iby_debug_pub.add(debug_msg => 'Federal submit_pay_instr_ts_report() returns success.',
1034: debug_level => FND_LOG.LEVEL_STATEMENT,
1035: module => l_Debug_Module);
1036: iby_debug_pub.add(debug_msg => 'Payment Instruction Treasury Symbol Listing Report request id: ' || l_fv_ts_req_id,
1037: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 1036: iby_debug_pub.add(debug_msg => 'Payment Instruction Treasury Symbol Listing Report request id: ' || l_fv_ts_req_id,

1032: IF l_fv_ts_req_status = FND_API.G_RET_STS_SUCCESS THEN
1033: iby_debug_pub.add(debug_msg => 'Federal submit_pay_instr_ts_report() returns success.',
1034: debug_level => FND_LOG.LEVEL_STATEMENT,
1035: module => l_Debug_Module);
1036: iby_debug_pub.add(debug_msg => 'Payment Instruction Treasury Symbol Listing Report request id: ' || l_fv_ts_req_id,
1037: debug_level => FND_LOG.LEVEL_STATEMENT,
1038: module => l_Debug_Module);
1039: ELSE
1040: iby_debug_pub.add(debug_msg => 'Federal submit_pay_instr_ts_report() returns error.',

Line 1040: iby_debug_pub.add(debug_msg => 'Federal submit_pay_instr_ts_report() returns error.',

1036: iby_debug_pub.add(debug_msg => 'Payment Instruction Treasury Symbol Listing Report request id: ' || l_fv_ts_req_id,
1037: debug_level => FND_LOG.LEVEL_STATEMENT,
1038: module => l_Debug_Module);
1039: ELSE
1040: iby_debug_pub.add(debug_msg => 'Federal submit_pay_instr_ts_report() returns error.',
1041: debug_level => FND_LOG.LEVEL_STATEMENT,
1042: module => l_Debug_Module);
1043: END IF;
1044:

Line 1062: iby_debug_pub.add(debug_msg => 'Enter: ' || l_Debug_Module,

1058: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Insert_Transmission_Error';
1059:
1060: BEGIN
1061:
1062: iby_debug_pub.add(debug_msg => 'Enter: ' || l_Debug_Module,
1063: debug_level => FND_LOG.LEVEL_PROCEDURE,
1064: module => l_Debug_Module);
1065:
1066: iby_debug_pub.add(debug_msg => 'Input payment instruction ID: ' || p_payment_instruction_id,

Line 1066: iby_debug_pub.add(debug_msg => 'Input payment instruction ID: ' || p_payment_instruction_id,

1062: iby_debug_pub.add(debug_msg => 'Enter: ' || l_Debug_Module,
1063: debug_level => FND_LOG.LEVEL_PROCEDURE,
1064: module => l_Debug_Module);
1065:
1066: iby_debug_pub.add(debug_msg => 'Input payment instruction ID: ' || p_payment_instruction_id,
1067: debug_level => FND_LOG.LEVEL_STATEMENT,
1068: module => l_Debug_Module);
1069:
1070: iby_debug_pub.add(debug_msg => 'Error code: ' || p_error_code,

Line 1070: iby_debug_pub.add(debug_msg => 'Error code: ' || p_error_code,

1066: iby_debug_pub.add(debug_msg => 'Input payment instruction ID: ' || p_payment_instruction_id,
1067: debug_level => FND_LOG.LEVEL_STATEMENT,
1068: module => l_Debug_Module);
1069:
1070: iby_debug_pub.add(debug_msg => 'Error code: ' || p_error_code,
1071: debug_level => FND_LOG.LEVEL_STATEMENT,
1072: module => l_Debug_Module);
1073:
1074: iby_debug_pub.add(debug_msg => 'Error message: ' || p_error_msg,

Line 1074: iby_debug_pub.add(debug_msg => 'Error message: ' || p_error_msg,

1070: iby_debug_pub.add(debug_msg => 'Error code: ' || p_error_code,
1071: debug_level => FND_LOG.LEVEL_STATEMENT,
1072: module => l_Debug_Module);
1073:
1074: iby_debug_pub.add(debug_msg => 'Error message: ' || p_error_msg,
1075: debug_level => FND_LOG.LEVEL_STATEMENT,
1076: module => l_Debug_Module);
1077:
1078: select IBY_TRANSACTION_ERRORS_S.nextval into l_transaction_error_id from dual;

Line 1094: iby_debug_pub.add(debug_msg => 'Exit: ' || l_Debug_Module,

1090: sysdate, fnd_global.user_id, sysdate,
1091: 1, 'Y',
1092: 'N', 'BANK', p_error_msg);
1093:
1094: iby_debug_pub.add(debug_msg => 'Exit: ' || l_Debug_Module,
1095: debug_level => FND_LOG.LEVEL_PROCEDURE,
1096: module => l_Debug_Module);
1097:
1098: END Insert_Transmission_Error;

Line 1120: iby_debug_pub.add(debug_msg => 'Enter: ' || l_Debug_Module,

1116:
1117: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Turn_off_STP_Flag';
1118: BEGIN
1119:
1120: iby_debug_pub.add(debug_msg => 'Enter: ' || l_Debug_Module,
1121: debug_level => FND_LOG.LEVEL_PROCEDURE,
1122: module => l_Debug_Module);
1123:
1124: iby_debug_pub.add(debug_msg => 'Input payment instruction ID: ' || p_payment_instruction_id,

Line 1124: iby_debug_pub.add(debug_msg => 'Input payment instruction ID: ' || p_payment_instruction_id,

1120: iby_debug_pub.add(debug_msg => 'Enter: ' || l_Debug_Module,
1121: debug_level => FND_LOG.LEVEL_PROCEDURE,
1122: module => l_Debug_Module);
1123:
1124: iby_debug_pub.add(debug_msg => 'Input payment instruction ID: ' || p_payment_instruction_id,
1125: debug_level => FND_LOG.LEVEL_STATEMENT,
1126: module => l_Debug_Module);
1127:
1128: FOR l_doc IN l_doc_csr(p_payment_instruction_id) LOOP

Line 1143: iby_debug_pub.add(debug_msg => 'Exit: ' || l_Debug_Module,

1139: document_payable_id = l_doc.document_payable_id;
1140:
1141: END LOOP;
1142:
1143: iby_debug_pub.add(debug_msg => 'Exit: ' || l_Debug_Module,
1144: debug_level => FND_LOG.LEVEL_PROCEDURE,
1145: module => l_Debug_Module);
1146:
1147: END Turn_off_STP_Flag;

Line 1185: iby_debug_pub.add(debug_msg => 'Enter: ' || l_Debug_Module,

1181: AND ins.payment_profile_id = pp.payment_profile_id;
1182:
1183: BEGIN
1184:
1185: iby_debug_pub.add(debug_msg => 'Enter: ' || l_Debug_Module,
1186: debug_level => FND_LOG.LEVEL_PROCEDURE,
1187: module => l_Debug_Module);
1188:
1189: iby_debug_pub.add(debug_msg => 'Input payment instruction ID: ' || p_payment_instruction_id,

Line 1189: iby_debug_pub.add(debug_msg => 'Input payment instruction ID: ' || p_payment_instruction_id,

1185: iby_debug_pub.add(debug_msg => 'Enter: ' || l_Debug_Module,
1186: debug_level => FND_LOG.LEVEL_PROCEDURE,
1187: module => l_Debug_Module);
1188:
1189: iby_debug_pub.add(debug_msg => 'Input payment instruction ID: ' || p_payment_instruction_id,
1190: debug_level => FND_LOG.LEVEL_STATEMENT,
1191: module => l_Debug_Module);
1192:
1193: iby_debug_pub.add(debug_msg => 'p_seq_name1: ' || p_seq_name1,

Line 1193: iby_debug_pub.add(debug_msg => 'p_seq_name1: ' || p_seq_name1,

1189: iby_debug_pub.add(debug_msg => 'Input payment instruction ID: ' || p_payment_instruction_id,
1190: debug_level => FND_LOG.LEVEL_STATEMENT,
1191: module => l_Debug_Module);
1192:
1193: iby_debug_pub.add(debug_msg => 'p_seq_name1: ' || p_seq_name1,
1194: debug_level => FND_LOG.LEVEL_STATEMENT,
1195: module => l_Debug_Module);
1196:
1197: iby_debug_pub.add(debug_msg => 'p_last_val1: ' || p_last_val1,

Line 1197: iby_debug_pub.add(debug_msg => 'p_last_val1: ' || p_last_val1,

1193: iby_debug_pub.add(debug_msg => 'p_seq_name1: ' || p_seq_name1,
1194: debug_level => FND_LOG.LEVEL_STATEMENT,
1195: module => l_Debug_Module);
1196:
1197: iby_debug_pub.add(debug_msg => 'p_last_val1: ' || p_last_val1,
1198: debug_level => FND_LOG.LEVEL_STATEMENT,
1199: module => l_Debug_Module);
1200:
1201: iby_debug_pub.add(debug_msg => 'p_seq_name2: ' || p_seq_name1,

Line 1201: iby_debug_pub.add(debug_msg => 'p_seq_name2: ' || p_seq_name1,

1197: iby_debug_pub.add(debug_msg => 'p_last_val1: ' || p_last_val1,
1198: debug_level => FND_LOG.LEVEL_STATEMENT,
1199: module => l_Debug_Module);
1200:
1201: iby_debug_pub.add(debug_msg => 'p_seq_name2: ' || p_seq_name1,
1202: debug_level => FND_LOG.LEVEL_STATEMENT,
1203: module => l_Debug_Module);
1204:
1205: iby_debug_pub.add(debug_msg => 'p_last_val2: ' || p_last_val1,

Line 1205: iby_debug_pub.add(debug_msg => 'p_last_val2: ' || p_last_val1,

1201: iby_debug_pub.add(debug_msg => 'p_seq_name2: ' || p_seq_name1,
1202: debug_level => FND_LOG.LEVEL_STATEMENT,
1203: module => l_Debug_Module);
1204:
1205: iby_debug_pub.add(debug_msg => 'p_last_val2: ' || p_last_val1,
1206: debug_level => FND_LOG.LEVEL_STATEMENT,
1207: module => l_Debug_Module);
1208:
1209: iby_debug_pub.add(debug_msg => 'p_seq_name3: ' || p_seq_name1,

Line 1209: iby_debug_pub.add(debug_msg => 'p_seq_name3: ' || p_seq_name1,

1205: iby_debug_pub.add(debug_msg => 'p_last_val2: ' || p_last_val1,
1206: debug_level => FND_LOG.LEVEL_STATEMENT,
1207: module => l_Debug_Module);
1208:
1209: iby_debug_pub.add(debug_msg => 'p_seq_name3: ' || p_seq_name1,
1210: debug_level => FND_LOG.LEVEL_STATEMENT,
1211: module => l_Debug_Module);
1212:
1213: iby_debug_pub.add(debug_msg => 'p_last_val3: ' || p_last_val1,

Line 1213: iby_debug_pub.add(debug_msg => 'p_last_val3: ' || p_last_val1,

1209: iby_debug_pub.add(debug_msg => 'p_seq_name3: ' || p_seq_name1,
1210: debug_level => FND_LOG.LEVEL_STATEMENT,
1211: module => l_Debug_Module);
1212:
1213: iby_debug_pub.add(debug_msg => 'p_last_val3: ' || p_last_val1,
1214: debug_level => FND_LOG.LEVEL_STATEMENT,
1215: module => l_Debug_Module);
1216:
1217: OPEN l_seq_csr (p_payment_instruction_id);

Line 1343: iby_debug_pub.add(debug_msg => 'Exit: ' || l_Debug_Module,

1339: payment_profile_id = l_payment_profile_id;
1340:
1341: END IF;
1342:
1343: iby_debug_pub.add(debug_msg => 'Exit: ' || l_Debug_Module,
1344: debug_level => FND_LOG.LEVEL_PROCEDURE,
1345: module => l_Debug_Module);
1346:
1347: END save_last_periodic_seq_nums;

Line 1584: iby_debug_pub.add(debug_msg => 'Checking accessible orgs',

1580: -- Set MOAC security
1581: MO_GLOBAL.init(l_appl_name);
1582: END IF;
1583:
1584: iby_debug_pub.add(debug_msg => 'Checking accessible orgs',
1585: debug_level => FND_LOG.LEVEL_STATEMENT,
1586: module => l_Debug_Module);
1587:
1588: FOR l_ce_spgt IN l_ce_spgt_csr LOOP

Line 1590: iby_debug_pub.add(debug_msg => 'Org type: ' || l_ce_spgt.organization_type ||

1586: module => l_Debug_Module);
1587:
1588: FOR l_ce_spgt IN l_ce_spgt_csr LOOP
1589:
1590: iby_debug_pub.add(debug_msg => 'Org type: ' || l_ce_spgt.organization_type ||
1591: ' Org id: ' || l_ce_spgt.organization_id ||
1592: ' Org name: ' || l_ce_spgt.name,
1593: debug_level => FND_LOG.LEVEL_STATEMENT,
1594: module => l_Debug_Module);

Line 1598: iby_debug_pub.add(debug_msg => 'Done checking accessible orgs',

1594: module => l_Debug_Module);
1595:
1596: END LOOP;
1597:
1598: iby_debug_pub.add(debug_msg => 'Done checking accessible orgs',
1599: debug_level => FND_LOG.LEVEL_STATEMENT,
1600: module => l_Debug_Module);
1601:
1602: ce_sp_access_C := ce_sp_access_C + 1;

Line 1634: iby_debug_pub.add(debug_msg => 'In validate_instruction_accessible(), before Init_Security',

1630: AND organization_id = p_org_id;
1631:
1632: BEGIN
1633:
1634: iby_debug_pub.add(debug_msg => 'In validate_instruction_accessible(), before Init_Security',
1635: debug_level => FND_LOG.LEVEL_STATEMENT,
1636: module => l_Debug_Module);
1637:
1638: Init_Security;

Line 1640: iby_debug_pub.add(debug_msg => 'In validate_instruction_accessible(), after Init_Security',

1636: module => l_Debug_Module);
1637:
1638: Init_Security;
1639:
1640: iby_debug_pub.add(debug_msg => 'In validate_instruction_accessible(), after Init_Security',
1641: debug_level => FND_LOG.LEVEL_STATEMENT,
1642: module => l_Debug_Module);
1643:
1644: FOR l_ins_org IN l_ins_org_csr(p_payment_instruction_id) LOOP

Line 1651: iby_debug_pub.add(debug_msg => 'Org type: ' || l_ins_org.org_type || ' Org id: ' || l_ins_org.org_id ||

1647: FETCH l_validate_org_accessible_csr INTO l_dummy;
1648:
1649: IF l_validate_org_accessible_csr%NOTFOUND THEN
1650:
1651: iby_debug_pub.add(debug_msg => 'Org type: ' || l_ins_org.org_type || ' Org id: ' || l_ins_org.org_id ||
1652: ' is not accessible for user',
1653: debug_level => FND_LOG.LEVEL_STATEMENT,
1654: module => l_Debug_Module);
1655:

Line 1690: iby_debug_pub.add(debug_msg => 'p_payment_instruction_id: ' || p_payment_instruction_id,

1686: BEGIN
1687:
1688: Init_Security;
1689:
1690: iby_debug_pub.add(debug_msg => 'p_payment_instruction_id: ' || p_payment_instruction_id,
1691: debug_level => FND_LOG.LEVEL_STATEMENT,
1692: module => l_Debug_Module);
1693:
1694: OPEN l_accessible_orgs_csr (p_payment_instruction_id);

Line 1698: iby_debug_pub.add(debug_msg => 'Number of orgs accessible for the user: ' || l_num_accessible_orgs,

1694: OPEN l_accessible_orgs_csr (p_payment_instruction_id);
1695: FETCH l_accessible_orgs_csr INTO l_num_accessible_orgs;
1696: CLOSE l_accessible_orgs_csr;
1697:
1698: iby_debug_pub.add(debug_msg => 'Number of orgs accessible for the user: ' || l_num_accessible_orgs,
1699: debug_level => FND_LOG.LEVEL_STATEMENT,
1700: module => l_Debug_Module);
1701:
1702: IF l_num_accessible_orgs >= 1 THEN

Line 1724: iby_debug_pub.add(debug_msg => 'p_payment_service_request_id: ' || p_payment_service_request_id,

1720: BEGIN
1721:
1722: Init_Security;
1723:
1724: iby_debug_pub.add(debug_msg => 'p_payment_service_request_id: ' || p_payment_service_request_id,
1725: debug_level => FND_LOG.LEVEL_STATEMENT,
1726: module => l_Debug_Module);
1727:
1728: l_num_accessible_orgs := get_accessible_ppr_org_count(p_payment_service_request_id);

Line 1730: iby_debug_pub.add(debug_msg => 'Number of orgs accessible for the user: ' || l_num_accessible_orgs,

1726: module => l_Debug_Module);
1727:
1728: l_num_accessible_orgs := get_accessible_ppr_org_count(p_payment_service_request_id);
1729:
1730: iby_debug_pub.add(debug_msg => 'Number of orgs accessible for the user: ' || l_num_accessible_orgs,
1731: debug_level => FND_LOG.LEVEL_STATEMENT,
1732: module => l_Debug_Module);
1733:
1734: IF l_num_accessible_orgs >= 1 THEN

Line 1874: iby_debug_pub.add(debug_msg => 'Enter: ' || l_Debug_Module,

1870: WHERE payment_profile_id = p_payment_profile_id;
1871:
1872: BEGIN
1873:
1874: iby_debug_pub.add(debug_msg => 'Enter: ' || l_Debug_Module,
1875: debug_level => FND_LOG.LEVEL_PROCEDURE,
1876: module => l_Debug_Module);
1877:
1878: iby_debug_pub.add(debug_msg => 'Input parameters: ',

Line 1878: iby_debug_pub.add(debug_msg => 'Input parameters: ',

1874: iby_debug_pub.add(debug_msg => 'Enter: ' || l_Debug_Module,
1875: debug_level => FND_LOG.LEVEL_PROCEDURE,
1876: module => l_Debug_Module);
1877:
1878: iby_debug_pub.add(debug_msg => 'Input parameters: ',
1879: debug_level => FND_LOG.LEVEL_STATEMENT,
1880: module => l_Debug_Module);
1881:
1882: iby_debug_pub.add(debug_msg => '============================================',

Line 1882: iby_debug_pub.add(debug_msg => '============================================',

1878: iby_debug_pub.add(debug_msg => 'Input parameters: ',
1879: debug_level => FND_LOG.LEVEL_STATEMENT,
1880: module => l_Debug_Module);
1881:
1882: iby_debug_pub.add(debug_msg => '============================================',
1883: debug_level => FND_LOG.LEVEL_STATEMENT,
1884: module => l_Debug_Module);
1885:
1886: iby_debug_pub.add(debug_msg => 'p_payment_profile_id: ' || p_payment_profile_id,

Line 1886: iby_debug_pub.add(debug_msg => 'p_payment_profile_id: ' || p_payment_profile_id,

1882: iby_debug_pub.add(debug_msg => '============================================',
1883: debug_level => FND_LOG.LEVEL_STATEMENT,
1884: module => l_Debug_Module);
1885:
1886: iby_debug_pub.add(debug_msg => 'p_payment_profile_id: ' || p_payment_profile_id,
1887: debug_level => FND_LOG.LEVEL_STATEMENT,
1888: module => l_Debug_Module);
1889:
1890: iby_debug_pub.add(debug_msg => 'p_sequence_number: ' || p_sequence_number,

Line 1890: iby_debug_pub.add(debug_msg => 'p_sequence_number: ' || p_sequence_number,

1886: iby_debug_pub.add(debug_msg => 'p_payment_profile_id: ' || p_payment_profile_id,
1887: debug_level => FND_LOG.LEVEL_STATEMENT,
1888: module => l_Debug_Module);
1889:
1890: iby_debug_pub.add(debug_msg => 'p_sequence_number: ' || p_sequence_number,
1891: debug_level => FND_LOG.LEVEL_STATEMENT,
1892: module => l_Debug_Module);
1893:
1894: iby_debug_pub.add(debug_msg => 'p_reset_value: ' || p_reset_value,

Line 1894: iby_debug_pub.add(debug_msg => 'p_reset_value: ' || p_reset_value,

1890: iby_debug_pub.add(debug_msg => 'p_sequence_number: ' || p_sequence_number,
1891: debug_level => FND_LOG.LEVEL_STATEMENT,
1892: module => l_Debug_Module);
1893:
1894: iby_debug_pub.add(debug_msg => 'p_reset_value: ' || p_reset_value,
1895: debug_level => FND_LOG.LEVEL_STATEMENT,
1896: module => l_Debug_Module);
1897:
1898: iby_debug_pub.add(debug_msg => '============================================',

Line 1898: iby_debug_pub.add(debug_msg => '============================================',

1894: iby_debug_pub.add(debug_msg => 'p_reset_value: ' || p_reset_value,
1895: debug_level => FND_LOG.LEVEL_STATEMENT,
1896: module => l_Debug_Module);
1897:
1898: iby_debug_pub.add(debug_msg => '============================================',
1899: debug_level => FND_LOG.LEVEL_STATEMENT,
1900: module => l_Debug_Module);
1901:
1902:

Line 1960: iby_debug_pub.add(debug_msg => 'Exit: ' || l_Debug_Module,

1956: payment_profile_id = p_payment_profile_id;
1957:
1958: END IF;
1959:
1960: iby_debug_pub.add(debug_msg => 'Exit: ' || l_Debug_Module,
1961: debug_level => FND_LOG.LEVEL_PROCEDURE,
1962: module => l_Debug_Module);
1963:
1964: END Reset_Periodic_Sequence_Value;

Line 1982: iby_debug_pub.add(debug_msg => 'Enter: ' || l_Debug_Module,

1978: l_bool_val boolean; -- Bug 6411356
1979:
1980: BEGIN
1981:
1982: iby_debug_pub.add(debug_msg => 'Enter: ' || l_Debug_Module,
1983: debug_level => FND_LOG.LEVEL_PROCEDURE,
1984: module => l_Debug_Module);
1985:
1986: iby_debug_pub.add(debug_msg => 'p_payment_profile_id: ' || p_payment_profile_id,

Line 1986: iby_debug_pub.add(debug_msg => 'p_payment_profile_id: ' || p_payment_profile_id,

1982: iby_debug_pub.add(debug_msg => 'Enter: ' || l_Debug_Module,
1983: debug_level => FND_LOG.LEVEL_PROCEDURE,
1984: module => l_Debug_Module);
1985:
1986: iby_debug_pub.add(debug_msg => 'p_payment_profile_id: ' || p_payment_profile_id,
1987: debug_level => FND_LOG.LEVEL_STATEMENT,
1988: module => l_Debug_Module);
1989:
1990: iby_debug_pub.add(debug_msg => 'p_sequence_number: ' || p_sequence_number,

Line 1990: iby_debug_pub.add(debug_msg => 'p_sequence_number: ' || p_sequence_number,

1986: iby_debug_pub.add(debug_msg => 'p_payment_profile_id: ' || p_payment_profile_id,
1987: debug_level => FND_LOG.LEVEL_STATEMENT,
1988: module => l_Debug_Module);
1989:
1990: iby_debug_pub.add(debug_msg => 'p_sequence_number: ' || p_sequence_number,
1991: debug_level => FND_LOG.LEVEL_STATEMENT,
1992: module => l_Debug_Module);
1993:
1994: iby_debug_pub.add(debug_msg => 'p_reset_value: ' || p_reset_value,

Line 1994: iby_debug_pub.add(debug_msg => 'p_reset_value: ' || p_reset_value,

1990: iby_debug_pub.add(debug_msg => 'p_sequence_number: ' || p_sequence_number,
1991: debug_level => FND_LOG.LEVEL_STATEMENT,
1992: module => l_Debug_Module);
1993:
1994: iby_debug_pub.add(debug_msg => 'p_reset_value: ' || p_reset_value,
1995: debug_level => FND_LOG.LEVEL_STATEMENT,
1996: module => l_Debug_Module);
1997:
1998: iby_debug_pub.add(debug_msg => 'Setting request to deferred',

Line 1998: iby_debug_pub.add(debug_msg => 'Setting request to deferred',

1994: iby_debug_pub.add(debug_msg => 'p_reset_value: ' || p_reset_value,
1995: debug_level => FND_LOG.LEVEL_STATEMENT,
1996: module => l_Debug_Module);
1997:
1998: iby_debug_pub.add(debug_msg => 'Setting request to deferred',
1999: debug_level => FND_LOG.LEVEL_STATEMENT,
2000: module => l_Debug_Module);
2001:
2002: l_def_sts := fnd_request.set_deferred();

Line 2005: iby_debug_pub.add(debug_msg => 'Warning: failed to set request as deferred',

2001:
2002: l_def_sts := fnd_request.set_deferred();
2003:
2004: IF l_def_sts = FALSE THEN
2005: iby_debug_pub.add(debug_msg => 'Warning: failed to set request as deferred',
2006: debug_level => FND_LOG.LEVEL_STATEMENT,
2007: module => l_Debug_Module);
2008:
2009: END IF;

Line 2011: iby_debug_pub.add(debug_msg => 'Before Calling FND_REQUEST.SUBMIT_REQUEST()',

2007: module => l_Debug_Module);
2008:
2009: END IF;
2010:
2011: iby_debug_pub.add(debug_msg => 'Before Calling FND_REQUEST.SUBMIT_REQUEST()',
2012: debug_level => FND_LOG.LEVEL_STATEMENT,
2013: module => l_Debug_Module);
2014:
2015:

Line 2049: iby_debug_pub.add(debug_msg => 'After Calling FND_REQUEST.SUBMIT_REQUEST()',

2045: '', '', '', '', '', '', '', '',
2046: '', '', ''
2047: );
2048:
2049: iby_debug_pub.add(debug_msg => 'After Calling FND_REQUEST.SUBMIT_REQUEST()',
2050: debug_level => FND_LOG.LEVEL_STATEMENT,
2051: module => l_Debug_Module);
2052: iby_debug_pub.add(debug_msg => 'Request id: ' || l_request_id,
2053: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 2052: iby_debug_pub.add(debug_msg => 'Request id: ' || l_request_id,

2048:
2049: iby_debug_pub.add(debug_msg => 'After Calling FND_REQUEST.SUBMIT_REQUEST()',
2050: debug_level => FND_LOG.LEVEL_STATEMENT,
2051: module => l_Debug_Module);
2052: iby_debug_pub.add(debug_msg => 'Request id: ' || l_request_id,
2053: debug_level => FND_LOG.LEVEL_STATEMENT,
2054: module => l_Debug_Module);
2055:
2056: iby_debug_pub.add(debug_msg => 'Exit: ' || l_Debug_Module,

Line 2056: iby_debug_pub.add(debug_msg => 'Exit: ' || l_Debug_Module,

2052: iby_debug_pub.add(debug_msg => 'Request id: ' || l_request_id,
2053: debug_level => FND_LOG.LEVEL_STATEMENT,
2054: module => l_Debug_Module);
2055:
2056: iby_debug_pub.add(debug_msg => 'Exit: ' || l_Debug_Module,
2057: debug_level => FND_LOG.LEVEL_PROCEDURE,
2058: module => l_Debug_Module);
2059:
2060: RETURN l_request_id;

Line 2085: iby_debug_pub.add(debug_msg => 'Enter: ' || l_Debug_Module,

2081: AND ins.payment_profile_id = pp.payment_profile_id;
2082:
2083: BEGIN
2084:
2085: iby_debug_pub.add(debug_msg => 'Enter: ' || l_Debug_Module,
2086: debug_level => FND_LOG.LEVEL_PROCEDURE,
2087: module => l_Debug_Module);
2088:
2089: iby_debug_pub.add(debug_msg => 'Input payment instruction ID: ' || p_payment_instruction_id,

Line 2089: iby_debug_pub.add(debug_msg => 'Input payment instruction ID: ' || p_payment_instruction_id,

2085: iby_debug_pub.add(debug_msg => 'Enter: ' || l_Debug_Module,
2086: debug_level => FND_LOG.LEVEL_PROCEDURE,
2087: module => l_Debug_Module);
2088:
2089: iby_debug_pub.add(debug_msg => 'Input payment instruction ID: ' || p_payment_instruction_id,
2090: debug_level => FND_LOG.LEVEL_STATEMENT,
2091: module => l_Debug_Module);
2092:
2093: OPEN l_acp_ltr_fmt_csr;

Line 2099: iby_debug_pub.add(debug_msg => 'The payment process profile for the instruction does not have an ' ||

2095: l_fmt_notfound := l_acp_ltr_fmt_csr%NOTFOUND;
2096: CLOSE l_acp_ltr_fmt_csr;
2097:
2098: IF l_fmt_notfound THEN
2099: iby_debug_pub.add(debug_msg => 'The payment process profile for the instruction does not have an ' ||
2100: 'accompany letter format. So no action is required. ',
2101: debug_level => FND_LOG.LEVEL_STATEMENT,
2102: module => l_Debug_Module);
2103: RETURN;

Line 2107: iby_debug_pub.add(debug_msg => 'Before Calling FND_REQUEST.SUBMIT_REQUEST()',

2103: RETURN;
2104: END IF;
2105:
2106:
2107: iby_debug_pub.add(debug_msg => 'Before Calling FND_REQUEST.SUBMIT_REQUEST()',
2108: debug_level => FND_LOG.LEVEL_STATEMENT,
2109: module => l_Debug_Module);
2110:
2111:

Line 2144: iby_debug_pub.add(debug_msg => 'After Calling FND_REQUEST.SUBMIT_REQUEST()',

2140: '', '', '', '', '', '', '', '',
2141: '', '', ''
2142: );
2143:
2144: iby_debug_pub.add(debug_msg => 'After Calling FND_REQUEST.SUBMIT_REQUEST()',
2145: debug_level => FND_LOG.LEVEL_STATEMENT,
2146: module => l_Debug_Module);
2147: iby_debug_pub.add(debug_msg => 'Request id: ' || l_request_id,
2148: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 2147: iby_debug_pub.add(debug_msg => 'Request id: ' || l_request_id,

2143:
2144: iby_debug_pub.add(debug_msg => 'After Calling FND_REQUEST.SUBMIT_REQUEST()',
2145: debug_level => FND_LOG.LEVEL_STATEMENT,
2146: module => l_Debug_Module);
2147: iby_debug_pub.add(debug_msg => 'Request id: ' || l_request_id,
2148: debug_level => FND_LOG.LEVEL_STATEMENT,
2149: module => l_Debug_Module);
2150:
2151: iby_debug_pub.add(debug_msg => 'Exit: ' || l_Debug_Module,

Line 2151: iby_debug_pub.add(debug_msg => 'Exit: ' || l_Debug_Module,

2147: iby_debug_pub.add(debug_msg => 'Request id: ' || l_request_id,
2148: debug_level => FND_LOG.LEVEL_STATEMENT,
2149: module => l_Debug_Module);
2150:
2151: iby_debug_pub.add(debug_msg => 'Exit: ' || l_Debug_Module,
2152: debug_level => FND_LOG.LEVEL_PROCEDURE,
2153: module => l_Debug_Module);
2154:
2155: COMMIT;

Line 2173: iby_debug_pub.add(debug_msg => 'Enter: ' || l_Debug_Module,

2169: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Run_ECE_Formatting';
2170:
2171: BEGIN
2172:
2173: iby_debug_pub.add(debug_msg => 'Enter: ' || l_Debug_Module,
2174: debug_level => FND_LOG.LEVEL_PROCEDURE,
2175: module => l_Debug_Module);
2176:
2177: iby_debug_pub.add(debug_msg => 'Input payment instruction ID: ' || p_payment_instruction_id,

Line 2177: iby_debug_pub.add(debug_msg => 'Input payment instruction ID: ' || p_payment_instruction_id,

2173: iby_debug_pub.add(debug_msg => 'Enter: ' || l_Debug_Module,
2174: debug_level => FND_LOG.LEVEL_PROCEDURE,
2175: module => l_Debug_Module);
2176:
2177: iby_debug_pub.add(debug_msg => 'Input payment instruction ID: ' || p_payment_instruction_id,
2178: debug_level => FND_LOG.LEVEL_STATEMENT,
2179: module => l_Debug_Module);
2180:
2181: iby_debug_pub.add(debug_msg => 'Calling ECE_AP_PAYMENT.Extract_PYO_Outbound() API... ' || l_ece_status,

Line 2181: iby_debug_pub.add(debug_msg => 'Calling ECE_AP_PAYMENT.Extract_PYO_Outbound() API... ' || l_ece_status,

2177: iby_debug_pub.add(debug_msg => 'Input payment instruction ID: ' || p_payment_instruction_id,
2178: debug_level => FND_LOG.LEVEL_STATEMENT,
2179: module => l_Debug_Module);
2180:
2181: iby_debug_pub.add(debug_msg => 'Calling ECE_AP_PAYMENT.Extract_PYO_Outbound() API... ' || l_ece_status,
2182: debug_level => FND_LOG.LEVEL_STATEMENT,
2183: module => l_Debug_Module);
2184:
2185: ECE_AP_PAYMENT.Extract_PYO_Outbound ( p_api_version => 1.0,

Line 2193: iby_debug_pub.add(debug_msg => 'After calling ECE_AP_PAYMENT.Extract_PYO_Outbound() API, return status: ' || l_ece_status,

2189: x_msg_count => l_msg_count,
2190: x_msg_data => l_msg_data,
2191: p_payment_instruction_id => p_payment_instruction_id);
2192:
2193: iby_debug_pub.add(debug_msg => 'After calling ECE_AP_PAYMENT.Extract_PYO_Outbound() API, return status: ' || l_ece_status,
2194: debug_level => FND_LOG.LEVEL_STATEMENT,
2195: module => l_Debug_Module);
2196:
2197: IF l_ece_status = FND_API.G_RET_STS_SUCCESS THEN

Line 2199: iby_debug_pub.add(debug_msg => 'Calling Post_Results()',

2195: module => l_Debug_Module);
2196:
2197: IF l_ece_status = FND_API.G_RET_STS_SUCCESS THEN
2198:
2199: iby_debug_pub.add(debug_msg => 'Calling Post_Results()',
2200: debug_level => FND_LOG.LEVEL_STATEMENT,
2201: module => l_Debug_Module);
2202:
2203: IBY_FD_POST_PICP_PROGS_PVT.Post_Results

Line 2211: iby_debug_pub.add(debug_msg => 'After calling Post_Results(), return status: ' || l_post_status,

2207: p_is_reprint_flag => 'N',
2208: x_return_status => l_post_status
2209: );
2210:
2211: iby_debug_pub.add(debug_msg => 'After calling Post_Results(), return status: ' || l_post_status,
2212: debug_level => FND_LOG.LEVEL_STATEMENT,
2213: module => l_Debug_Module);
2214:
2215: IF l_post_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 2223: iby_debug_pub.add(debug_msg => 'Exit: ' || l_Debug_Module,

2219: ELSE
2220: RAISE FND_API.G_EXC_ERROR;
2221: END IF;
2222:
2223: iby_debug_pub.add(debug_msg => 'Exit: ' || l_Debug_Module,
2224: debug_level => FND_LOG.LEVEL_PROCEDURE,
2225: module => l_Debug_Module);
2226:
2227: END Run_ECE_Formatting;

Line 2244: iby_debug_pub.add(debug_msg => 'Enter: ' || l_Debug_Module,

2240: l_bool_val boolean; -- Bug 6411356
2241:
2242: BEGIN
2243:
2244: iby_debug_pub.add(debug_msg => 'Enter: ' || l_Debug_Module,
2245: debug_level => FND_LOG.LEVEL_PROCEDURE,
2246: module => l_Debug_Module);
2247:
2248: iby_debug_pub.add(debug_msg => 'Input payment instruction ID: ' || p_payment_instruction_id,

Line 2248: iby_debug_pub.add(debug_msg => 'Input payment instruction ID: ' || p_payment_instruction_id,

2244: iby_debug_pub.add(debug_msg => 'Enter: ' || l_Debug_Module,
2245: debug_level => FND_LOG.LEVEL_PROCEDURE,
2246: module => l_Debug_Module);
2247:
2248: iby_debug_pub.add(debug_msg => 'Input payment instruction ID: ' || p_payment_instruction_id,
2249: debug_level => FND_LOG.LEVEL_STATEMENT,
2250: module => l_Debug_Module);
2251:
2252:

Line 2253: iby_debug_pub.add(debug_msg => 'Before Calling FND_REQUEST.SUBMIT_REQUEST()',

2249: debug_level => FND_LOG.LEVEL_STATEMENT,
2250: module => l_Debug_Module);
2251:
2252:
2253: iby_debug_pub.add(debug_msg => 'Before Calling FND_REQUEST.SUBMIT_REQUEST()',
2254: debug_level => FND_LOG.LEVEL_STATEMENT,
2255: module => l_Debug_Module);
2256:
2257:

Line 2288: iby_debug_pub.add(debug_msg => 'After Calling FND_REQUEST.SUBMIT_REQUEST()',

2284: '', '', '', '', '', '', '', '',
2285: '', '', ''
2286: );
2287:
2288: iby_debug_pub.add(debug_msg => 'After Calling FND_REQUEST.SUBMIT_REQUEST()',
2289: debug_level => FND_LOG.LEVEL_STATEMENT,
2290: module => l_Debug_Module);
2291: iby_debug_pub.add(debug_msg => 'Request id: ' || l_request_id,
2292: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 2291: iby_debug_pub.add(debug_msg => 'Request id: ' || l_request_id,

2287:
2288: iby_debug_pub.add(debug_msg => 'After Calling FND_REQUEST.SUBMIT_REQUEST()',
2289: debug_level => FND_LOG.LEVEL_STATEMENT,
2290: module => l_Debug_Module);
2291: iby_debug_pub.add(debug_msg => 'Request id: ' || l_request_id,
2292: debug_level => FND_LOG.LEVEL_STATEMENT,
2293: module => l_Debug_Module);
2294:
2295: IF l_request_id = 0 THEN

Line 2299: iby_debug_pub.add(debug_msg => 'Exit: ' || l_Debug_Module,

2295: IF l_request_id = 0 THEN
2296: RAISE FND_API.G_EXC_ERROR;
2297: END IF;
2298:
2299: iby_debug_pub.add(debug_msg => 'Exit: ' || l_Debug_Module,
2300: debug_level => FND_LOG.LEVEL_PROCEDURE,
2301: module => l_Debug_Module);
2302:
2303: END Test_CP;