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 231: iby_debug_pub.add(debug_msg => 'Enter: ' || l_Debug_Module,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

354: iby_debug_pub.add(debug_msg => 'The printer is to: ' || l_printer_name,
355: debug_level => FND_LOG.LEVEL_STATEMENT,
356: module => l_Debug_Module);
357: ELSE
358: iby_debug_pub.add(debug_msg => 'Warning: unable to set printer',
359: debug_level => FND_LOG.LEVEL_STATEMENT,
360: module => l_Debug_Module);
361: END IF;
362:

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

359: debug_level => FND_LOG.LEVEL_STATEMENT,
360: module => l_Debug_Module);
361: END IF;
362:
363: iby_debug_pub.add(debug_msg => 'Before Calling FND_REQUEST.SUBMIT_REQUEST().',
364: debug_level => FND_LOG.LEVEL_STATEMENT,
365: module => l_Debug_Module);
366:
367: --Bug 6411356

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

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

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

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

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

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

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

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

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

487: -- Bug:7259529 - CAll to the lock_pmt_entity has been moved to the java layer
488: -- Bug:9235888 - Reinstated instruction locking.
489: ELSE
490:
491: iby_debug_pub.add(debug_msg => 'Calling the lock_pmt_entity() API to lock instruction: ' || p_payment_instruction_id
492: || ' for the extract/formatting/printing/delivery program',
493: debug_level => FND_LOG.LEVEL_STATEMENT,
494: module => l_Debug_Module);
495:

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

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

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

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

Line 560: iby_debug_pub.log(debug_msg => 'Enter Post Results:Start:Timestamp:' || systimestamp,

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

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

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

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

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

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

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

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

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

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

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

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

586: iby_debug_pub.add(debug_msg => 'Current instruction status is: ' || l_instr_status,
587: debug_level => FND_LOG.LEVEL_STATEMENT,
588: module => l_Debug_Module);
589:
590: iby_debug_pub.add(debug_msg => 'Setting instruction to the input status: ' || p_newStatus,
591: debug_level => FND_LOG.LEVEL_STATEMENT,
592: module => l_Debug_Module);
593:
594: -- bug 5121763: single payments handling. PICP would mark complete and set

Line 617: iby_debug_pub.add(debug_msg => ' New status is SUBMITTED_FOR_PRINTING and reprint flag is N ',

613: IF p_newStatus = 'SUBMITTED_FOR_PRINTING' THEN
614:
615: IF nvl(p_is_reprint_flag, 'N') = 'N' THEN
616:
617: iby_debug_pub.add(debug_msg => ' New status is SUBMITTED_FOR_PRINTING and reprint flag is N ',
618: debug_level => FND_LOG.LEVEL_STATEMENT,
619: module => l_Debug_Module);
620:
621:

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

622: -- FOR l_payment IN l_pmt_csr(p_payment_instruction_id) LOOP
623: --
624: -- IF l_payment.payment_status IN ('FORMATTED', 'INSTRUCTION_CREATED') THEN
625: --
626: -- iby_debug_pub.add(debug_msg => 'Payment ' || l_payment.payment_id || ' is in ' || l_payment.payment_status ||
627: -- ' status. Setting it to SUBMITTED_FOR_PRINTING',
628: -- debug_level => FND_LOG.LEVEL_STATEMENT,
629: -- module => l_Debug_Module);
630:

Line 631: iby_debug_pub.add(debug_msg => 'Setting status for Payments with ' ||

627: -- ' status. Setting it to SUBMITTED_FOR_PRINTING',
628: -- debug_level => FND_LOG.LEVEL_STATEMENT,
629: -- module => l_Debug_Module);
630:
631: iby_debug_pub.add(debug_msg => 'Setting status for Payments with ' ||
632: ' payment_instruction_id as ' || p_payment_instruction_id ||
633: ' payment_status as FORMATTED,INSTRUCTION_CREATED' ||
634: ' to SUBMITTED_FOR_PRINTING',
635: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 658: iby_debug_pub.add(debug_msg => ' New status is SUBMITTED_FOR_PRINTING and reprint flag is Y ',

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

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

662: -- FOR l_payment IN l_pmt_reprt_csr(p_payment_instruction_id) LOOP
663: --
664: -- IF l_payment.payment_status = 'READY_TO_REPRINT' THEN
665: --
666: -- iby_debug_pub.add(debug_msg => 'Payment ' || l_payment.payment_id || ' is in ' || l_payment.payment_status ||
667: -- ' status. Setting it to SUBMITTED_FOR_PRINTING',
668: -- debug_level => FND_LOG.LEVEL_STATEMENT,
669: -- module => l_Debug_Module);
670:

Line 672: iby_debug_pub.add(debug_msg => 'Setting status for Payments with ' ||

668: -- debug_level => FND_LOG.LEVEL_STATEMENT,
669: -- module => l_Debug_Module);
670:
671:
672: iby_debug_pub.add(debug_msg => 'Setting status for Payments with ' ||
673: ' payment_instruction_id as ' || p_payment_instruction_id ||
674: ' payment_status as READY_TO_REPRINT' ||
675: ' to SUBMITTED_FOR_PRINTING',
676: debug_level => FND_LOG.LEVEL_STATEMENT,

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

693: AND payment_status IN ('READY_TO_REPRINT','VOID_BY_SETUP_REPRINT','VOID_BY_OVERFLOW_REPRINT');
694:
695: -- ELSIF l_payment.payment_status = 'VOID_BY_SETUP_REPRINT' THEN
696: --
697: -- iby_debug_pub.add(debug_msg => 'Payment ' || l_payment.payment_id || ' is in ' || l_payment.payment_status ||
698: -- ' status. Setting it to VOID_BY_SETUP',
699: -- debug_level => FND_LOG.LEVEL_STATEMENT,
700: -- module => l_Debug_Module);
701:

Line 702: iby_debug_pub.add(debug_msg => 'Setting status for Payments with ' ||

698: -- ' status. Setting it to VOID_BY_SETUP',
699: -- debug_level => FND_LOG.LEVEL_STATEMENT,
700: -- module => l_Debug_Module);
701:
702: iby_debug_pub.add(debug_msg => 'Setting status for Payments with ' ||
703: ' payment_instruction_id as ' || p_payment_instruction_id ||
704: ' payment_status as VOID_BY_SETUP_REPRINT' ||
705: ' to VOID_BY_SETUP',
706: debug_level => FND_LOG.LEVEL_STATEMENT,

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

720: -- AND payment_status = 'VOID_BY_SETUP_REPRINT';
721:
722: -- ELSIF l_payment.payment_status = 'VOID_BY_OVERFLOW_REPRINT' THEN
723: --
724: -- iby_debug_pub.add(debug_msg => 'Payment ' || l_payment.payment_id || ' is in ' || l_payment.payment_status ||
725: -- ' status. Setting it to VOID_BY_OVERFLOW',
726: -- debug_level => FND_LOG.LEVEL_STATEMENT,
727: -- module => l_Debug_Module);
728:

Line 729: iby_debug_pub.add(debug_msg => 'Setting status for Payments with ' ||

725: -- ' status. Setting it to VOID_BY_OVERFLOW',
726: -- debug_level => FND_LOG.LEVEL_STATEMENT,
727: -- module => l_Debug_Module);
728:
729: iby_debug_pub.add(debug_msg => 'Setting status for Payments with ' ||
730: ' payment_instruction_id as ' || p_payment_instruction_id ||
731: ' payment_status as VOID_BY_OVERFLOW_REPRINT' ||
732: ' to VOID_BY_OVERFLOW',
733: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 759: iby_debug_pub.add(debug_msg => ' New status is FORMATTED and processing type is PRINTED ',

755: -- for printing outside Oracle
756: ELSIF p_newStatus = 'FORMATTED' AND l_proc_type = 'PRINTED' THEN
757:
758:
759: iby_debug_pub.add(debug_msg => ' New status is FORMATTED and processing type is PRINTED ',
760: debug_level => FND_LOG.LEVEL_STATEMENT,
761: module => l_Debug_Module);
762:
763:

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

764: -- FOR l_payment IN l_pmt_csr(p_payment_instruction_id) LOOP
765: --
766: -- IF l_payment.payment_status = 'INSTRUCTION_CREATED' THEN
767: --
768: -- iby_debug_pub.add(debug_msg => 'Payment ' || l_payment.payment_id || ' is in ' || l_payment.payment_status ||
769: -- ' status. Setting it to FORMATTED',
770: -- debug_level => FND_LOG.LEVEL_STATEMENT,
771: -- module => l_Debug_Module);
772:

Line 773: iby_debug_pub.add(debug_msg => 'Setting status for Payments with ' ||

769: -- ' status. Setting it to FORMATTED',
770: -- debug_level => FND_LOG.LEVEL_STATEMENT,
771: -- module => l_Debug_Module);
772:
773: iby_debug_pub.add(debug_msg => 'Setting status for Payments with ' ||
774: ' payment_instruction_id as ' || p_payment_instruction_id ||
775: ' payment_status as INSTRUCTION_CREATED' ||
776: ' to FORMATTED',
777: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 801: iby_debug_pub.add(debug_msg => ' New status is FORMATTED_ELECTRONIC and processing type is ELECTRONIC ',

797: -- (electronic and no tranmit config)
798: ELSIF p_newStatus = 'FORMATTED_ELECTRONIC' AND l_proc_type = 'ELECTRONIC' THEN
799:
800:
801: iby_debug_pub.add(debug_msg => ' New status is FORMATTED_ELECTRONIC and processing type is ELECTRONIC ',
802: debug_level => FND_LOG.LEVEL_STATEMENT,
803: module => l_Debug_Module);
804:
805:

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

806: -- FOR l_payment IN l_pmt_csr(p_payment_instruction_id) LOOP
807: --
808: -- IF l_payment.payment_status = 'INSTRUCTION_CREATED' THEN
809: --
810: -- iby_debug_pub.add(debug_msg => 'Payment ' || l_payment.payment_id || ' is in ' || l_payment.payment_status ||
811: -- ' status. Setting it to FORMATTED',
812: -- debug_level => FND_LOG.LEVEL_STATEMENT,
813: -- module => l_Debug_Module);
814:

Line 815: iby_debug_pub.add(debug_msg => 'Setting status for Payments with ' ||

811: -- ' status. Setting it to FORMATTED',
812: -- debug_level => FND_LOG.LEVEL_STATEMENT,
813: -- module => l_Debug_Module);
814:
815: iby_debug_pub.add(debug_msg => 'Setting status for Payments with ' ||
816: ' payment_instruction_id as ' || p_payment_instruction_id ||
817: ' payment_status as INSTRUCTION_CREATED' ||
818: ' to FORMATTED',
819: debug_level => FND_LOG.LEVEL_STATEMENT,

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

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

Line 846: iby_debug_pub.log(debug_msg => 'Enter Mark Pmts Complete: Timestamp:' || systimestamp,

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

Line 853: iby_debug_pub.log(debug_msg => 'Exit Mark Pmts Complete: Timestamp:' || systimestamp,

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

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

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

Line 875: iby_debug_pub.add(debug_msg => ' New status is FORMATTED_READY_FOR_PRINTING ',

871: -- for deferred printing with Oracle
872: ELSIF p_newStatus = 'FORMATTED_READY_FOR_PRINTING' THEN
873:
874:
875: iby_debug_pub.add(debug_msg => ' New status is FORMATTED_READY_FOR_PRINTING ',
876: debug_level => FND_LOG.LEVEL_STATEMENT,
877: module => l_Debug_Module);
878:
879:

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

880: -- FOR l_payment IN l_pmt_csr(p_payment_instruction_id) LOOP
881: --
882: -- IF l_payment.payment_status = 'INSTRUCTION_CREATED' THEN
883: --
884: -- iby_debug_pub.add(debug_msg => 'Payment ' || l_payment.payment_id || ' is in ' || l_payment.payment_status ||
885: -- ' status. Setting it to FORMATTED',
886: -- debug_level => FND_LOG.LEVEL_STATEMENT,
887: -- module => l_Debug_Module);
888:

Line 889: iby_debug_pub.add(debug_msg => 'Setting status for Payments with ' ||

885: -- ' status. Setting it to FORMATTED',
886: -- debug_level => FND_LOG.LEVEL_STATEMENT,
887: -- module => l_Debug_Module);
888:
889: iby_debug_pub.add(debug_msg => 'Setting status for Payments with ' ||
890: ' payment_instruction_id as ' || p_payment_instruction_id ||
891: ' payment_status as INSTRUCTION_CREATED' ||
892: ' to FORMATTED',
893: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 924: iby_debug_pub.add(debug_msg => ' New status is FORMATTED_READY_TO_TRANSMIT ',

920: -- for deferred transmission with Oracle
921: ELSIF p_newStatus = 'FORMATTED_READY_TO_TRANSMIT' THEN
922:
923:
924: iby_debug_pub.add(debug_msg => ' New status is FORMATTED_READY_TO_TRANSMIT ',
925: debug_level => FND_LOG.LEVEL_STATEMENT,
926: module => l_Debug_Module);
927:
928:

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

929: -- FOR l_payment IN l_pmt_csr(p_payment_instruction_id) LOOP
930: --
931: -- IF l_payment.payment_status = 'INSTRUCTION_CREATED' THEN
932: --
933: -- iby_debug_pub.add(debug_msg => 'Payment ' || l_payment.payment_id || ' is in ' || l_payment.payment_status ||
934: -- ' status. Setting it to FORMATTED',
935: -- debug_level => FND_LOG.LEVEL_STATEMENT,
936: -- module => l_Debug_Module);
937:

Line 938: iby_debug_pub.add(debug_msg => 'Setting status for Payments with ' ||

934: -- ' status. Setting it to FORMATTED',
935: -- debug_level => FND_LOG.LEVEL_STATEMENT,
936: -- module => l_Debug_Module);
937:
938: iby_debug_pub.add(debug_msg => 'Setting status for Payments with ' ||
939: ' payment_instruction_id as ' || p_payment_instruction_id ||
940: ' payment_status as INSTRUCTION_CREATED' ||
941: ' to FORMATTED',
942: debug_level => FND_LOG.LEVEL_STATEMENT,

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

960: -- END LOOP;
961:
962: IF l_mark_complete_event = 'FORMATTED' THEN
963:
964: iby_debug_pub.add(debug_msg => 'Before Calling IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete().',
965: debug_level => FND_LOG.LEVEL_STATEMENT,
966: module => l_Debug_Module);
967:
968: -- call the mark complete API

Line 969: iby_debug_pub.log(debug_msg => 'Enter Mark Pmts Complete: Formatted:Timestamp:' || systimestamp,

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

Line 976: iby_debug_pub.log(debug_msg => 'Exit Mark Pmts Complete: Formatted:Timestamp:' || systimestamp,

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

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

976: iby_debug_pub.log(debug_msg => 'Exit Mark Pmts Complete: Formatted:Timestamp:' || systimestamp,
977: debug_level => FND_LOG.LEVEL_PROCEDURE,
978: module => l_Debug_Module);
979:
980: iby_debug_pub.add(debug_msg => 'After Calling IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete().',
981: debug_level => FND_LOG.LEVEL_STATEMENT,
982: module => l_Debug_Module);
983:
984: IF l_mark_complete_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 999: iby_debug_pub.add(debug_msg => ' New status is TRANSMITTED ',

995: -- transmission success
996: ELSIF p_newStatus = 'TRANSMITTED' THEN
997:
998:
999: iby_debug_pub.add(debug_msg => ' New status is TRANSMITTED ',
1000: debug_level => FND_LOG.LEVEL_STATEMENT,
1001: module => l_Debug_Module);
1002:
1003:

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

1004: -- FOR l_payment IN l_pmt_csr(p_payment_instruction_id) LOOP
1005: --
1006: -- IF l_payment.payment_status IN ('FORMATTED', 'INSTRUCTION_CREATED') THEN
1007: --
1008: -- iby_debug_pub.add(debug_msg => 'Payment ' || l_payment.payment_id || ' is in ' || l_payment.payment_status ||
1009: -- ' status. Setting it to TRANSMITTED',
1010: -- debug_level => FND_LOG.LEVEL_STATEMENT,
1011: -- module => l_Debug_Module);
1012:

Line 1013: iby_debug_pub.add(debug_msg => 'Setting status for Payments with ' ||

1009: -- ' status. Setting it to TRANSMITTED',
1010: -- debug_level => FND_LOG.LEVEL_STATEMENT,
1011: -- module => l_Debug_Module);
1012:
1013: iby_debug_pub.add(debug_msg => 'Setting status for Payments with ' ||
1014: ' payment_instruction_id as ' || p_payment_instruction_id ||
1015: ' payment_status as FORMATTED,INSTRUCTION_CREATED' ||
1016: ' to TRANSMITTED',
1017: debug_level => FND_LOG.LEVEL_STATEMENT,

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

1040: event status (i.e. 'FORMATTED', 'TRANSMITTED')
1041: */
1042: IF l_mark_complete_event in ('FORMATTED', 'TRANSMITTED') THEN
1043:
1044: iby_debug_pub.add(debug_msg => 'Before Calling IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete().',
1045: debug_level => FND_LOG.LEVEL_STATEMENT,
1046: module => l_Debug_Module);
1047:
1048: -- call the mark complete API

Line 1049: iby_debug_pub.log(debug_msg => 'Enter Mark Pmts Complete:Transmitted:Timestamp' || systimestamp,

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

Line 1058: iby_debug_pub.log(debug_msg => 'Exit Mark Pmts Complete:Transmitted:Timestamp:' || systimestamp,

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

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

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

Line 1083: iby_debug_pub.add(debug_msg => ' New status is TRANSMISSION_FAILED ',

1079: -- only update doc level straight through flag
1080: ELSIF p_newStatus = 'TRANSMISSION_FAILED' THEN
1081:
1082:
1083: iby_debug_pub.add(debug_msg => ' New status is TRANSMISSION_FAILED ',
1084: debug_level => FND_LOG.LEVEL_STATEMENT,
1085: module => l_Debug_Module);
1086:
1087:

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

1092: -- FOR l_payment IN l_pmt_csr(p_payment_instruction_id) LOOP
1093: --
1094: -- IF l_payment.payment_status IN ('INSTRUCTION_CREATED') THEN
1095: --
1096: -- iby_debug_pub.add(debug_msg => 'Payment ' || l_payment.payment_id || ' is in ' || l_payment.payment_status ||
1097: -- ' status. Setting it to FORMATTED',
1098: -- debug_level => FND_LOG.LEVEL_STATEMENT,
1099: -- module => l_Debug_Module);
1100:

Line 1101: iby_debug_pub.add(debug_msg => 'Setting status for Payments with ' ||

1097: -- ' status. Setting it to FORMATTED',
1098: -- debug_level => FND_LOG.LEVEL_STATEMENT,
1099: -- module => l_Debug_Module);
1100:
1101: iby_debug_pub.add(debug_msg => 'Setting status for Payments with ' ||
1102: ' payment_instruction_id as ' || p_payment_instruction_id ||
1103: ' payment_status as INSTRUCTION_CREATED' ||
1104: ' to FORMATTED',
1105: debug_level => FND_LOG.LEVEL_STATEMENT,

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

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

Line 1129: iby_debug_pub.log(debug_msg => 'Enter Mark Pmts Complete: Formatted2:Timestamp:' || systimestamp,

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

Line 1137: iby_debug_pub.log(debug_msg => 'Exit Mark Pmts Complete: Formatted2:Timestamp:' || systimestamp,

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

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

1137: iby_debug_pub.log(debug_msg => 'Exit Mark Pmts Complete: Formatted2:Timestamp:' || systimestamp,
1138: debug_level => FND_LOG.LEVEL_PROCEDURE,
1139: module => l_Debug_Module);
1140:
1141: iby_debug_pub.add(debug_msg => 'After Calling IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete().',
1142: debug_level => FND_LOG.LEVEL_STATEMENT,
1143: module => l_Debug_Module);
1144:
1145: IF l_mark_complete_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 1164: iby_debug_pub.log(debug_msg => 'Exit: ' || l_Debug_Module||'Timestamp::'||systimestamp,

1160: -- finally kick off Federal "Payment Instruction Treasury Symbol Listing Report"
1161: -- if its a Federal format
1162: Submit_FV_TS_Report(p_payment_instruction_id, l_format_code, l_Debug_Module);
1163:
1164: iby_debug_pub.log(debug_msg => 'Exit: ' || l_Debug_Module||'Timestamp::'||systimestamp,
1165: debug_level => FND_LOG.LEVEL_PROCEDURE,
1166: module => l_Debug_Module);
1167:
1168: EXCEPTION

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1418: iby_debug_pub.add(debug_msg => 'p_seq_name3: ' || p_seq_name1,
1419: debug_level => FND_LOG.LEVEL_STATEMENT,
1420: module => l_Debug_Module);
1421:
1422: iby_debug_pub.add(debug_msg => 'p_last_val3: ' || p_last_val1,
1423: debug_level => FND_LOG.LEVEL_STATEMENT,
1424: module => l_Debug_Module);
1425:
1426: OPEN l_seq_csr (p_payment_instruction_id);

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

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

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

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

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

1795: module => l_Debug_Module);
1796:
1797: FOR l_ce_spgt IN l_ce_spgt_csr LOOP
1798:
1799: iby_debug_pub.add(debug_msg => 'Org type: ' || l_ce_spgt.organization_type ||
1800: ' Org id: ' || l_ce_spgt.organization_id ||
1801: ' Org name: ' || l_ce_spgt.name,
1802: debug_level => FND_LOG.LEVEL_STATEMENT,
1803: module => l_Debug_Module);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

2187: l_bool_val boolean; -- Bug 6411356
2188:
2189: BEGIN
2190:
2191: iby_debug_pub.add(debug_msg => 'Enter: ' || l_Debug_Module,
2192: debug_level => FND_LOG.LEVEL_PROCEDURE,
2193: module => l_Debug_Module);
2194:
2195: iby_debug_pub.add(debug_msg => 'p_payment_profile_id: ' || p_payment_profile_id,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 2381: iby_debug_pub.log(debug_msg => 'Enter: Timestamp:' || systimestamp,

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

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

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

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

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

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

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

Line 2404: iby_debug_pub.log(debug_msg => 'Exit IBY_PYO_TRANSACTION: Timestamp:' || systimestamp,

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

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

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

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

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

Line 2417: iby_debug_pub.log(debug_msg => 'Enter: Post Results::Timestamp:' || systimestamp,

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

Line 2427: iby_debug_pub.log(debug_msg => 'Exit: Post Results::Timestamp:' || systimestamp,

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

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

2427: iby_debug_pub.log(debug_msg => 'Exit: Post Results::Timestamp:' || systimestamp,
2428: debug_level => FND_LOG.LEVEL_PROCEDURE,
2429: module => l_Debug_Module);
2430:
2431: iby_debug_pub.add(debug_msg => 'After calling Post_Results(), return status: ' || l_post_status,
2432: debug_level => FND_LOG.LEVEL_STATEMENT,
2433: module => l_Debug_Module);
2434:
2435: IF l_post_status <> FND_API.G_RET_STS_SUCCESS THEN

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 2545: iby_debug_pub.add(debug_msg => 'Enter IBY_FD_POST_PICP_PROGS_PVT.Run_Post_Transmit_Programs' || systimestamp,

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

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

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

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

2553: p_instr_id => p_payment_instruction_id,
2554: x_return_status => l_mark_complete_status
2555: );
2556:
2557: iby_debug_pub.add(debug_msg => 'After Calling IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete().',
2558: debug_level => FND_LOG.LEVEL_STATEMENT,
2559: module => l_Debug_Module);
2560:
2561:

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

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

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

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

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

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