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 229: debug_level => FND_LOG.LEVEL_PROCEDURE,

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,
233: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 233: debug_level => FND_LOG.LEVEL_STATEMENT,

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);
237: FETCH l_ins_csr INTO l_printer_name, l_instr_status, l_transmit_immed_flag,

Line 275: debug_level => FND_LOG.LEVEL_STATEMENT,

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 ',
279: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 279: debug_level => FND_LOG.LEVEL_STATEMENT,

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:
283:

Line 292: debug_level => FND_LOG.LEVEL_STATEMENT,

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
296: FROM iby_pay_instructions_all ins,

Line 318: debug_level => FND_LOG.LEVEL_STATEMENT,

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',
322: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 322: debug_level => FND_LOG.LEVEL_STATEMENT,

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:
326: iby_debug_pub.add(debug_msg => 'Before Calling FND_REQUEST.SUBMIT_REQUEST().',

Line 327: 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
331: --below code added to set the current nls character setting

Line 405: debug_level => FND_LOG.LEVEL_STATEMENT,

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
409:

Line 435: debug_level => FND_LOG.LEVEL_STATEMENT,

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

Line 441: debug_level => FND_LOG.LEVEL_STATEMENT,

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,
445: module => l_Debug_Module);

Line 444: debug_level => FND_LOG.LEVEL_STATEMENT,

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
448: RAISE FND_API.G_EXC_ERROR;

Line 453: debug_level => FND_LOG.LEVEL_STATEMENT,

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:
456: IBY_DISBURSE_UI_API_PUB_PKG.lock_pmt_entity(
457: p_object_id => p_payment_instruction_id,

Line 467: debug_level => FND_LOG.LEVEL_STATEMENT,

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

Line 474: debug_level => FND_LOG.LEVEL_PROCEDURE,

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

Line 522: debug_level => FND_LOG.LEVEL_PROCEDURE,

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,
526: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 526: debug_level => FND_LOG.LEVEL_STATEMENT,

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,
530: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 530: debug_level => FND_LOG.LEVEL_STATEMENT,

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,
534: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 534: debug_level => FND_LOG.LEVEL_STATEMENT,

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

Line 545: debug_level => FND_LOG.LEVEL_STATEMENT,

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,
549: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 549: debug_level => FND_LOG.LEVEL_STATEMENT,

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
553: -- the complete statuses in its process - i.e., before the post-PICP CP

Line 581: debug_level => FND_LOG.LEVEL_STATEMENT,

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:
584: UPDATE
585: iby_payments_all

Line 605: debug_level => FND_LOG.LEVEL_STATEMENT,

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:
608: UPDATE
609: iby_payments_all

Line 623: debug_level => FND_LOG.LEVEL_STATEMENT,

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:
626: UPDATE
627: iby_payments_all

Line 641: debug_level => FND_LOG.LEVEL_STATEMENT,

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:
644: UPDATE
645: iby_payments_all

Line 670: debug_level => FND_LOG.LEVEL_STATEMENT,

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:
673: UPDATE
674: iby_payments_all

Line 697: debug_level => FND_LOG.LEVEL_STATEMENT,

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:
700: UPDATE
701: iby_payments_all

Line 717: debug_level => FND_LOG.LEVEL_STATEMENT,

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
721: -- call the mark complete API

Line 728: debug_level => FND_LOG.LEVEL_STATEMENT,

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
732: -- set error for invalid data

Line 751: debug_level => FND_LOG.LEVEL_STATEMENT,

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:
754: UPDATE
755: iby_payments_all

Line 785: debug_level => FND_LOG.LEVEL_STATEMENT,

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:
788: UPDATE
789: iby_payments_all

Line 805: debug_level => FND_LOG.LEVEL_STATEMENT,

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
809: IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete (

Line 815: debug_level => FND_LOG.LEVEL_STATEMENT,

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
819: -- set error for invalid data

Line 838: debug_level => FND_LOG.LEVEL_STATEMENT,

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:
841: UPDATE
842: iby_payments_all

Line 862: debug_level => FND_LOG.LEVEL_STATEMENT,

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
866: IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete (

Line 872: debug_level => FND_LOG.LEVEL_STATEMENT,

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
876: -- set error for invalid data

Line 900: debug_level => FND_LOG.LEVEL_STATEMENT,

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:
903: UPDATE
904: iby_payments_all

Line 920: debug_level => FND_LOG.LEVEL_STATEMENT,

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
924: IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete (

Line 930: debug_level => FND_LOG.LEVEL_STATEMENT,

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
934: -- set error for invalid data

Line 953: debug_level => FND_LOG.LEVEL_PROCEDURE,

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
957:

Line 968: debug_level => FND_LOG.LEVEL_STATEMENT,

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

Line 983: debug_level => FND_LOG.LEVEL_STATEMENT,

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

Line 998: debug_level => FND_LOG.LEVEL_STATEMENT,

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

Line 1034: debug_level => FND_LOG.LEVEL_STATEMENT,

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,
1038: module => l_Debug_Module);

Line 1037: debug_level => FND_LOG.LEVEL_STATEMENT,

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.',
1041: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 1041: debug_level => FND_LOG.LEVEL_STATEMENT,

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

Line 1063: debug_level => FND_LOG.LEVEL_PROCEDURE,

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,
1067: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 1067: debug_level => FND_LOG.LEVEL_STATEMENT,

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,
1071: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 1071: debug_level => FND_LOG.LEVEL_STATEMENT,

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,
1075: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 1075: debug_level => FND_LOG.LEVEL_STATEMENT,

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

Line 1095: debug_level => FND_LOG.LEVEL_PROCEDURE,

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

Line 1121: debug_level => FND_LOG.LEVEL_PROCEDURE,

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,
1125: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 1125: debug_level => FND_LOG.LEVEL_STATEMENT,

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
1129:

Line 1144: debug_level => FND_LOG.LEVEL_PROCEDURE,

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

Line 1186: debug_level => FND_LOG.LEVEL_PROCEDURE,

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,
1190: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 1190: debug_level => FND_LOG.LEVEL_STATEMENT,

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,
1194: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 1194: debug_level => FND_LOG.LEVEL_STATEMENT,

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,
1198: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 1198: debug_level => FND_LOG.LEVEL_STATEMENT,

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,
1202: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 1202: debug_level => FND_LOG.LEVEL_STATEMENT,

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,
1206: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 1206: debug_level => FND_LOG.LEVEL_STATEMENT,

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,
1210: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 1210: debug_level => FND_LOG.LEVEL_STATEMENT,

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,
1214: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 1214: debug_level => FND_LOG.LEVEL_STATEMENT,

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);
1218: FETCH l_seq_csr INTO l_payment_profile_id, l_seq_name1, l_seq_name2, l_seq_name3,

Line 1344: debug_level => FND_LOG.LEVEL_PROCEDURE,

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

Line 1585: debug_level => FND_LOG.LEVEL_STATEMENT,

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
1589:

Line 1593: debug_level => FND_LOG.LEVEL_STATEMENT,

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);
1595:
1596: END LOOP;
1597:

Line 1599: debug_level => FND_LOG.LEVEL_STATEMENT,

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

Line 1635: debug_level => FND_LOG.LEVEL_STATEMENT,

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

Line 1641: debug_level => FND_LOG.LEVEL_STATEMENT,

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
1645:

Line 1653: debug_level => FND_LOG.LEVEL_STATEMENT,

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:
1656: CLOSE l_validate_org_accessible_csr;
1657: return 'N';

Line 1691: debug_level => FND_LOG.LEVEL_STATEMENT,

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);
1695: FETCH l_accessible_orgs_csr INTO l_num_accessible_orgs;

Line 1699: debug_level => FND_LOG.LEVEL_STATEMENT,

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
1703:

Line 1725: debug_level => FND_LOG.LEVEL_STATEMENT,

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);
1729:

Line 1731: debug_level => FND_LOG.LEVEL_STATEMENT,

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
1735:

Line 1875: debug_level => FND_LOG.LEVEL_PROCEDURE,

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: ',
1879: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 1879: debug_level => FND_LOG.LEVEL_STATEMENT,

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 => '============================================',
1883: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 1883: debug_level => FND_LOG.LEVEL_STATEMENT,

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,
1887: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 1887: debug_level => FND_LOG.LEVEL_STATEMENT,

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,
1891: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 1891: debug_level => FND_LOG.LEVEL_STATEMENT,

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,
1895: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 1895: debug_level => FND_LOG.LEVEL_STATEMENT,

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 => '============================================',
1899: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 1899: debug_level => FND_LOG.LEVEL_STATEMENT,

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:
1903: OPEN l_val_seq_csr;

Line 1961: debug_level => FND_LOG.LEVEL_PROCEDURE,

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

Line 1983: debug_level => FND_LOG.LEVEL_PROCEDURE,

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,
1987: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 1987: debug_level => FND_LOG.LEVEL_STATEMENT,

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,
1991: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 1991: debug_level => FND_LOG.LEVEL_STATEMENT,

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,
1995: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 1995: debug_level => FND_LOG.LEVEL_STATEMENT,

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',
1999: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 1999: debug_level => FND_LOG.LEVEL_STATEMENT,

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();
2003:

Line 2006: debug_level => FND_LOG.LEVEL_STATEMENT,

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

Line 2012: debug_level => FND_LOG.LEVEL_STATEMENT,

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:
2016: --Bug 6411356

Line 2050: debug_level => FND_LOG.LEVEL_STATEMENT,

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,
2054: module => l_Debug_Module);

Line 2053: debug_level => FND_LOG.LEVEL_STATEMENT,

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,
2057: debug_level => FND_LOG.LEVEL_PROCEDURE,

Line 2057: debug_level => FND_LOG.LEVEL_PROCEDURE,

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

Line 2086: debug_level => FND_LOG.LEVEL_PROCEDURE,

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,
2090: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 2090: debug_level => FND_LOG.LEVEL_STATEMENT,

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;
2094: FETCH l_acp_ltr_fmt_csr INTO l_acp_ltr_fmt_code;

Line 2101: debug_level => FND_LOG.LEVEL_STATEMENT,

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;
2104: END IF;
2105:

Line 2108: debug_level => FND_LOG.LEVEL_STATEMENT,

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:
2112: --Bug 6411356

Line 2145: debug_level => FND_LOG.LEVEL_STATEMENT,

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,
2149: module => l_Debug_Module);

Line 2148: debug_level => FND_LOG.LEVEL_STATEMENT,

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,
2152: debug_level => FND_LOG.LEVEL_PROCEDURE,

Line 2152: debug_level => FND_LOG.LEVEL_PROCEDURE,

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

Line 2174: debug_level => FND_LOG.LEVEL_PROCEDURE,

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,
2178: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 2178: debug_level => FND_LOG.LEVEL_STATEMENT,

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,
2182: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 2182: debug_level => FND_LOG.LEVEL_STATEMENT,

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,
2186: p_init_msg_list => fnd_api.g_false,

Line 2194: debug_level => FND_LOG.LEVEL_STATEMENT,

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
2198:

Line 2200: debug_level => FND_LOG.LEVEL_STATEMENT,

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
2204: (

Line 2212: debug_level => FND_LOG.LEVEL_STATEMENT,

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
2216: RAISE FND_API.G_EXC_ERROR;

Line 2224: debug_level => FND_LOG.LEVEL_PROCEDURE,

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

Line 2245: debug_level => FND_LOG.LEVEL_PROCEDURE,

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,
2249: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 2249: debug_level => FND_LOG.LEVEL_STATEMENT,

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:
2253: iby_debug_pub.add(debug_msg => 'Before Calling FND_REQUEST.SUBMIT_REQUEST()',

Line 2254: 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:
2258: --Bug 6411356

Line 2289: debug_level => FND_LOG.LEVEL_STATEMENT,

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,
2293: module => l_Debug_Module);

Line 2292: debug_level => FND_LOG.LEVEL_STATEMENT,

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
2296: RAISE FND_API.G_EXC_ERROR;

Line 2300: debug_level => FND_LOG.LEVEL_PROCEDURE,

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