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.ARP_CONFIRMATION dependencies on ARP_CONFIRMATION

Line 1: PACKAGE BODY ARP_CONFIRMATION AS

1: PACKAGE BODY ARP_CONFIRMATION AS
2: /* $Header: ARRECNFB.pls 120.16 2010/10/28 13:45:15 nemani ship $ */
3:
4: /* =======================================================================
5: | Global Data Types

Line 79: arp_standard.debug('arp_confirmation.confirm()+');

75:
76: BEGIN
77:
78: IF PG_DEBUG in ('Y', 'C') THEN
79: arp_standard.debug('arp_confirmation.confirm()+');
80: arp_standard.debug('confirm: ' || '-- p_cr_id : ' || to_char(p_cr_id));
81: arp_standard.debug('-- p_confirm_gl_date: ' || to_char(p_confirm_gl_date));
82: arp_standard.debug('-- p_confirm_date : ' || to_char(p_confirm_date));
83: END IF;

Line 185: arp_standard.debug('arp_confirmation.confirm()-');

181: arp_xla_events.Create_Events( l_xla_ev_rec );
182:
183:
184: IF PG_DEBUG in ('Y', 'C') THEN
185: arp_standard.debug('arp_confirmation.confirm()-');
186: END IF;
187:
188: EXCEPTION
189: WHEN OTHERS THEN

Line 191: arp_util.debug('EXCEPTION: arp_confirmation.confirm()');

187:
188: EXCEPTION
189: WHEN OTHERS THEN
190: IF PG_DEBUG in ('Y', 'C') THEN
191: arp_util.debug('EXCEPTION: arp_confirmation.confirm()');
192: END IF;
193: RAISE;
194:
195: END; -- confirm()

Line 257: arp_standard.debug('arp_confirmation.unconfirm()+');

253:
254: BEGIN
255:
256: IF PG_DEBUG in ('Y', 'C') THEN
257: arp_standard.debug('arp_confirmation.unconfirm()+');
258: arp_standard.debug('confirm: ' || to_char(p_cr_id));
259: END IF;
260:
261: -- validate IN parameters:

Line 330: arp_standard.debug('arp_confirmation.unconfirm()-');

326: l_acctd_amount,
327: l_batch_id);
328:
329: IF PG_DEBUG in ('Y', 'C') THEN
330: arp_standard.debug('arp_confirmation.unconfirm()-');
331: END IF;
332:
333: EXCEPTION
334: WHEN OTHERS THEN

Line 336: arp_util.debug('EXCEPTION: arp_confirmation.unconfirm()');

332:
333: EXCEPTION
334: WHEN OTHERS THEN
335: IF PG_DEBUG in ('Y', 'C') THEN
336: arp_util.debug('EXCEPTION: arp_confirmation.unconfirm()');
337: END IF;
338: RAISE;
339:
340: END; -- unconfirm()

Line 406: arp_standard.debug('arp_confirmation.confirm_batch()+');

402: l_cash_receipt_rec confirmCursor%ROWTYPE;
403:
404: BEGIN
405: IF PG_DEBUG in ('Y', 'C') THEN
406: arp_standard.debug('arp_confirmation.confirm_batch()+');
407: END IF;
408:
409: FOR l_cash_receipt_rec IN confirmCursor(p_batch_id) LOOP
410: BEGIN

Line 418: arp_confirmation.confirm(

414: UPDATE AR_CASH_RECEIPTS
415: SET confirmed_flag = 'Y'
416: WHERE cash_receipt_id = l_cash_receipt_rec.cash_receipt_id;
417:
418: arp_confirmation.confirm(
419: l_cash_receipt_rec.cash_receipt_id,
420: p_confirm_gl_date,
421: p_confirm_date,
422: 'ARXRWMAI',

Line 430: arp_standard.debug('Exception in arp_confirmation.confirm_batch');

426:
427: EXCEPTION
428: WHEN OTHERS THEN
429: IF PG_DEBUG in ('Y', 'C') THEN
430: arp_standard.debug('Exception in arp_confirmation.confirm_batch');
431: END IF;
432: ROLLBACK TO ar_confirm_batch_sp;
433: l_num_rec_error := l_num_rec_error + 1;
434: END;

Line 442: arp_standard.debug('arp_confirmation.confirm_batch()-');

438: p_num_rec_confirmed := l_num_rec_confirmed;
439: p_num_rec_error := l_num_rec_error;
440:
441: IF PG_DEBUG in ('Y', 'C') THEN
442: arp_standard.debug('arp_confirmation.confirm_batch()-');
443: END IF;
444:
445: END confirm_batch;
446:

Line 485: arp_standard.debug('arp_confirmation.confirm_receipt()+');

481: l_status VARCHAR2(30);
482: l_confirmed_flag VARCHAR2(2);
483: BEGIN
484: IF PG_DEBUG in ('Y', 'C') THEN
485: arp_standard.debug('arp_confirmation.confirm_receipt()+');
486: arp_standard.debug('****** Begin Confirm Receipt ****** ');
487: arp_standard.debug('confirm: ' || '-- p_cr_id : ' || to_char(p_cr_id));
488: arp_standard.debug('-- p_confirm_gl_date: ' || to_char(p_confirm_gl_date));
489: arp_standard.debug('-- p_confirm_date : ' || to_char(p_confirm_date));

Line 506: arp_confirmation.confirm(

502: UPDATE AR_CASH_RECEIPTS
503: SET confirmed_flag = 'Y'
504: WHERE cash_receipt_id = p_cr_id;
505:
506: arp_confirmation.confirm(
507: p_cr_id,
508: p_confirm_gl_date,
509: p_confirm_date,
510: 'ARXRWMAI',

Line 518: arp_standard.debug('arp_confirmation.confirm_receipt: Invalid GL DATE ' || to_char(p_confirm_gl_date));

514: END IF;
515:
516: END IF;
517: IF PG_DEBUG in ('Y', 'C') THEN
518: arp_standard.debug('arp_confirmation.confirm_receipt: Invalid GL DATE ' || to_char(p_confirm_gl_date));
519: END IF;
520: END IF;
521: IF PG_DEBUG in ('Y', 'C') THEN
522: arp_standard.debug('arp_confirmation.confirm_receipt()-');

Line 522: arp_standard.debug('arp_confirmation.confirm_receipt()-');

518: arp_standard.debug('arp_confirmation.confirm_receipt: Invalid GL DATE ' || to_char(p_confirm_gl_date));
519: END IF;
520: END IF;
521: IF PG_DEBUG in ('Y', 'C') THEN
522: arp_standard.debug('arp_confirmation.confirm_receipt()-');
523: END IF;
524:
525: EXCEPTION
526: WHEN OTHERS THEN

Line 528: arp_standard.debug('EXCEPTION: arp_confirmation.confirm_receipt');

524:
525: EXCEPTION
526: WHEN OTHERS THEN
527: IF PG_DEBUG in ('Y', 'C') THEN
528: arp_standard.debug('EXCEPTION: arp_confirmation.confirm_receipt');
529: END IF;
530: RAISE;
531: END confirm_receipt; -- confirm_receipt()
532: /* End Bug fix 872506 */

Line 652: arp_standard.debug('arp_confirmation.do_confirm()+');

648: AND reversal_gl_date IS NULL;
649:
650: BEGIN
651:
652: arp_standard.debug('arp_confirmation.do_confirm()+');
653:
654: -- initialize l_max_dates:
655:
656: l_max_dates.max_trx_date := p_confirm_date;

Line 910: arp_standard.debug('arp_confirmation.do_confirm()-');

906: -- as UNAPP records are paired with their APP records
907:
908: create_matching_unapp_records(p_cr_rec.cash_receipt_id, l_app_id);
909:
910: arp_standard.debug('arp_confirmation.do_confirm()-');
911:
912: EXCEPTION
913: WHEN NO_DATA_FOUND THEN
914: arp_util.debug('EXCEPTION: NO DATA FOUND, arp_confirmation.do_confirm()');

Line 914: arp_util.debug('EXCEPTION: NO DATA FOUND, arp_confirmation.do_confirm()');

910: arp_standard.debug('arp_confirmation.do_confirm()-');
911:
912: EXCEPTION
913: WHEN NO_DATA_FOUND THEN
914: arp_util.debug('EXCEPTION: NO DATA FOUND, arp_confirmation.do_confirm()');
915: RAISE;
916:
917: WHEN OTHERS THEN
918: arp_util.debug('EXCEPTION: arp_confirmation.do_confirm()');

Line 918: arp_util.debug('EXCEPTION: arp_confirmation.do_confirm()');

914: arp_util.debug('EXCEPTION: NO DATA FOUND, arp_confirmation.do_confirm()');
915: RAISE;
916:
917: WHEN OTHERS THEN
918: arp_util.debug('EXCEPTION: arp_confirmation.do_confirm()');
919: RAISE;
920:
921: END; -- do_confirm()
922:

Line 1017: arp_util.debug('EXCEPTION: arp_confirmation.do_unconfirm()');

1013: p_confirm_date);
1014:
1015: EXCEPTION
1016: WHEN OTHERS THEN
1017: arp_util.debug('EXCEPTION: arp_confirmation.do_unconfirm()');
1018: RAISE;
1019:
1020: END; -- do_unconfirm()
1021:

Line 1078: arp_standard.debug('arp_confirmation.update_cr_history_confirm()+');

1074:
1075: --
1076: BEGIN
1077:
1078: arp_standard.debug('arp_confirmation.update_cr_history_confirm()+');
1079:
1080: -- fetch current record from ar_cash_receipt_history
1081:
1082: arp_cr_history_pkg.fetch_f_crid(p_cr_rec.cash_receipt_id, l_crh_rec_old);

Line 1244: arp_standard.debug('arp_confirmation.confirm_update_ps_rec()+');

1240: l_dummy NUMBER;
1241:
1242: BEGIN
1243:
1244: arp_standard.debug('arp_confirmation.confirm_update_ps_rec()+');
1245: -- Fetch receipt's payment schedule record:
1246:
1247: SELECT *
1248: INTO l_receipt_ps_rec

Line 1270: arp_standard.debug('arp_confirmation.confirm_update_ps_rec()-');

1266: p_closed_gl_date,
1267: l_dummy,
1268: l_receipt_ps_rec);
1269:
1270: arp_standard.debug('arp_confirmation.confirm_update_ps_rec()-');
1271:
1272: EXCEPTION
1273: WHEN OTHERS THEN
1274: arp_util.debug('EXCEPTION: arp_confirmation.confirm_update_ps_rec()');

Line 1274: arp_util.debug('EXCEPTION: arp_confirmation.confirm_update_ps_rec()');

1270: arp_standard.debug('arp_confirmation.confirm_update_ps_rec()-');
1271:
1272: EXCEPTION
1273: WHEN OTHERS THEN
1274: arp_util.debug('EXCEPTION: arp_confirmation.confirm_update_ps_rec()');
1275: RAISE;
1276:
1277: END; -- confirm_update_ps_rec()
1278:

Line 1343: arp_standard.debug('arp_confirmation.modify_update_ra_rec()+');

1339: AND app.application_rule IN ('97.0', '40.0');
1340:
1341: -- update record
1342:
1343: arp_standard.debug('arp_confirmation.modify_update_ra_rec()+');
1344:
1345: UPDATE ar_receivable_applications
1346: SET gl_date = p_confirm_gl_date,
1347: apply_date = p_confirm_date,

Line 1375: arp_standard.debug('arp_confirmation.modify_update_ra_rec()+');

1371: l_ae_doc_rec.other_flag := '';
1372: arp_acct_main.Create_Acct_Entry(l_ae_doc_rec);
1373:
1374:
1375: arp_standard.debug('arp_confirmation.modify_update_ra_rec()+');
1376:
1377: EXCEPTION
1378: WHEN NO_DATA_FOUND THEN
1379: arp_util.debug('EXCEPTION: NO DATA FOUND, arp_confirmation.modify_update_ra_rec()');

Line 1379: arp_util.debug('EXCEPTION: NO DATA FOUND, arp_confirmation.modify_update_ra_rec()');

1375: arp_standard.debug('arp_confirmation.modify_update_ra_rec()+');
1376:
1377: EXCEPTION
1378: WHEN NO_DATA_FOUND THEN
1379: arp_util.debug('EXCEPTION: NO DATA FOUND, arp_confirmation.modify_update_ra_rec()');
1380: RAISE;
1381:
1382: WHEN OTHERS THEN
1383: arp_util.debug('EXCEPTION: arp_confirmation.modify_update_ra_rec()');

Line 1383: arp_util.debug('EXCEPTION: arp_confirmation.modify_update_ra_rec()');

1379: arp_util.debug('EXCEPTION: NO DATA FOUND, arp_confirmation.modify_update_ra_rec()');
1380: RAISE;
1381:
1382: WHEN OTHERS THEN
1383: arp_util.debug('EXCEPTION: arp_confirmation.modify_update_ra_rec()');
1384: RAISE;
1385:
1386: END; -- modify_update_ra_rec()
1387:

Line 1468: arp_standard.debug('arp_confirmation.create_matching_unapp_records()+');

1464: AND unapp.status||'' = 'UNAPP';
1465:
1466: BEGIN
1467:
1468: arp_standard.debug('arp_confirmation.create_matching_unapp_records()+');
1469:
1470:
1471: FOR l_unapp_rec in get_rec_records LOOP
1472:

Line 1642: arp_standard.debug('arp_confirmation.create_matching_unapp_records()-');

1638: arp_acct_main.Create_Acct_Entry(l_ae_doc_rec);
1639:
1640: END LOOP;
1641:
1642: arp_standard.debug('arp_confirmation.create_matching_unapp_records()-');
1643:
1644: EXCEPTION
1645: WHEN NO_DATA_FOUND THEN
1646: arp_util.debug('EXCEPTION: NO DATA FOUND arp_confirmation.create_matching_unapp_records()');

Line 1646: arp_util.debug('EXCEPTION: NO DATA FOUND arp_confirmation.create_matching_unapp_records()');

1642: arp_standard.debug('arp_confirmation.create_matching_unapp_records()-');
1643:
1644: EXCEPTION
1645: WHEN NO_DATA_FOUND THEN
1646: arp_util.debug('EXCEPTION: NO DATA FOUND arp_confirmation.create_matching_unapp_records()');
1647: RAISE;
1648:
1649: WHEN OTHERS THEN
1650: arp_util.debug('EXCEPTION: arp_confirmation.create_matching_unapp_records()');

Line 1650: arp_util.debug('EXCEPTION: arp_confirmation.create_matching_unapp_records()');

1646: arp_util.debug('EXCEPTION: NO DATA FOUND arp_confirmation.create_matching_unapp_records()');
1647: RAISE;
1648:
1649: WHEN OTHERS THEN
1650: arp_util.debug('EXCEPTION: arp_confirmation.create_matching_unapp_records()');
1651: RAISE;
1652:
1653: END; -- create_matching_unapp_records()
1654:

Line 1692: arp_standard.debug('arp_confirmation.get_receipt_clearing_ccid()+');

1688: ) IS
1689:
1690: BEGIN
1691:
1692: arp_standard.debug('arp_confirmation.get_receipt_clearing_ccid()+');
1693:
1694: SELECT rma.receipt_clearing_ccid
1695: INTO p_receipt_clearing_ccid
1696: FROM ar_receipt_method_accounts rma

Line 1700: arp_standard.debug('arp_confirmation.get_receipt_clearing_ccid()-');

1696: FROM ar_receipt_method_accounts rma
1697: WHERE rma.remit_bank_acct_use_id = p_cr_rec.remit_bank_acct_use_id
1698: AND rma.receipt_method_id = p_cr_rec.receipt_method_id;
1699:
1700: arp_standard.debug('arp_confirmation.get_receipt_clearing_ccid()-');
1701:
1702: EXCEPTION
1703: WHEN OTHERS THEN
1704: arp_util.debug('EXCEPTION: arp_confirmation.get_receipt_clearing_ccid');

Line 1704: arp_util.debug('EXCEPTION: arp_confirmation.get_receipt_clearing_ccid');

1700: arp_standard.debug('arp_confirmation.get_receipt_clearing_ccid()-');
1701:
1702: EXCEPTION
1703: WHEN OTHERS THEN
1704: arp_util.debug('EXCEPTION: arp_confirmation.get_receipt_clearing_ccid');
1705: RAISE;
1706:
1707: END; -- get_receipt_clearing_ccid()
1708:

Line 1770: arp_standard.debug('arp_confirmation.update_cr_history_unconfirm()+');

1766: l_crh_id_new ar_cash_receipt_history.cash_receipt_history_id%TYPE;
1767:
1768: BEGIN
1769:
1770: arp_standard.debug('arp_confirmation.update_cr_history_unconfirm()+');
1771:
1772: -- fetch current record from ar_cash_receipt_history
1773:
1774: arp_cr_history_pkg.fetch_f_crid(p_cr_rec.cash_receipt_id, l_crh_rec_old);

Line 1887: arp_standard.debug('arp_confirmation.update_cr_history_unconfirm()-');

1883:
1884: p_batch_id := l_batch_id;
1885: p_crh_id_rev := l_crh_id_rev;
1886:
1887: arp_standard.debug('arp_confirmation.update_cr_history_unconfirm()-');
1888:
1889:
1890: EXCEPTION
1891: WHEN OTHERS THEN

Line 1892: arp_util.debug('EXCEPTION: arp_confirmation.update_cr_history_unconfirm()');

1888:
1889:
1890: EXCEPTION
1891: WHEN OTHERS THEN
1892: arp_util.debug('EXCEPTION: arp_confirmation.update_cr_history_unconfirm()');
1893: RAISE;
1894:
1895: END; -- update_cr_history_unconfirm()
1896:

Line 1940: arp_standard.debug('arp_confirmation.reverse_application_to_ps()+');

1936: l_ar_ps_key_value_list gl_ca_utility_pkg.r_key_value_arr;
1937:
1938: BEGIN
1939:
1940: arp_standard.debug('arp_confirmation.reverse_application_to_ps()+');
1941:
1942: UPDATE
1943: ar_payment_schedules ps
1944: SET (

Line 2046: arp_standard.debug('arp_confirmation.reverse_application_to_ps()-');

2042: p_table_name => 'AR_PAYMENT_SCHEDULES',
2043: p_mode => 'BATCH',
2044: p_key_value_list => l_ar_ps_key_value_list);
2045:
2046: arp_standard.debug('arp_confirmation.reverse_application_to_ps()-');
2047:
2048: EXCEPTION
2049: WHEN OTHERS THEN
2050: arp_util.debug('EXCEPTION: arp_confirmation.reverse_application_to_ps()');

Line 2050: arp_util.debug('EXCEPTION: arp_confirmation.reverse_application_to_ps()');

2046: arp_standard.debug('arp_confirmation.reverse_application_to_ps()-');
2047:
2048: EXCEPTION
2049: WHEN OTHERS THEN
2050: arp_util.debug('EXCEPTION: arp_confirmation.reverse_application_to_ps()');
2051: RAISE;
2052:
2053: END; -- reverse_application_to_ps()
2054:

Line 2109: arp_standard.debug('arp_confirmation.reverse_ra_recs()+');

2105: n_new_con_data new_con_data; /* to store values retrieved from bulk collect */
2106:
2107: BEGIN
2108:
2109: arp_standard.debug('arp_confirmation.reverse_ra_recs()+');
2110:
2111: FOR l_app_rec IN get_app LOOP
2112:
2113: --retrieve sequence

Line 2619: arp_standard.debug('arp_confirmation.reverse_ra_recs()-');

2615: WHERE cash_receipt_id = p_cr_rec.cash_receipt_id
2616: AND nvl(confirmed_flag,'Y') = 'Y'
2617: AND reversal_gl_date IS NULL;
2618:
2619: arp_standard.debug('arp_confirmation.reverse_ra_recs()-');
2620:
2621: EXCEPTION
2622: WHEN NO_DATA_FOUND THEN
2623: arp_util.debug('EXCEPTION: NO DATA FOUND, arp_confirmation.do_confirm()');

Line 2623: arp_util.debug('EXCEPTION: NO DATA FOUND, arp_confirmation.do_confirm()');

2619: arp_standard.debug('arp_confirmation.reverse_ra_recs()-');
2620:
2621: EXCEPTION
2622: WHEN NO_DATA_FOUND THEN
2623: arp_util.debug('EXCEPTION: NO DATA FOUND, arp_confirmation.do_confirm()');
2624: RAISE;
2625:
2626: WHEN OTHERS THEN
2627: arp_util.debug('EXCEPTION: arp_confirmation.do_confirm()');

Line 2627: arp_util.debug('EXCEPTION: arp_confirmation.do_confirm()');

2623: arp_util.debug('EXCEPTION: NO DATA FOUND, arp_confirmation.do_confirm()');
2624: RAISE;
2625:
2626: WHEN OTHERS THEN
2627: arp_util.debug('EXCEPTION: arp_confirmation.do_confirm()');
2628: RAISE;
2629:
2630: END; -- reverse_ra_recs()
2631:

Line 2677: arp_standard.debug('arp_confirmation.unconfirm_update_ps_rec()+');

2673: l_dummy NUMBER;
2674:
2675: BEGIN
2676:
2677: arp_standard.debug('arp_confirmation.unconfirm_update_ps_rec()+');
2678: -- Fetch receipt's payment schedule record:
2679:
2680: SELECT *
2681: INTO l_receipt_ps_rec

Line 2701: arp_standard.debug('arp_confirmation.unconfirm_update_ps_rec()-');

2697: p_closed_gl_date,
2698: l_dummy,
2699: l_receipt_ps_rec);
2700:
2701: arp_standard.debug('arp_confirmation.unconfirm_update_ps_rec()-');
2702:
2703: EXCEPTION
2704: WHEN NO_DATA_FOUND THEN
2705: arp_util.debug('EXCEPTION: NO DATA FOUND, arp_confirmation.unconfirm_update_ps_rec()');

Line 2705: arp_util.debug('EXCEPTION: NO DATA FOUND, arp_confirmation.unconfirm_update_ps_rec()');

2701: arp_standard.debug('arp_confirmation.unconfirm_update_ps_rec()-');
2702:
2703: EXCEPTION
2704: WHEN NO_DATA_FOUND THEN
2705: arp_util.debug('EXCEPTION: NO DATA FOUND, arp_confirmation.unconfirm_update_ps_rec()');
2706: RAISE;
2707:
2708: WHEN OTHERS THEN
2709: arp_util.debug('EXCEPTION: arp_confirmation.unconfirm_update_ps_rec()');

Line 2709: arp_util.debug('EXCEPTION: arp_confirmation.unconfirm_update_ps_rec()');

2705: arp_util.debug('EXCEPTION: NO DATA FOUND, arp_confirmation.unconfirm_update_ps_rec()');
2706: RAISE;
2707:
2708: WHEN OTHERS THEN
2709: arp_util.debug('EXCEPTION: arp_confirmation.unconfirm_update_ps_rec()');
2710: RAISE;
2711:
2712: END; -- unconfirm_update_ps_rec()
2713:

Line 2756: arp_standard.debug('arp_confirmation.validate_in_parameters()+');

2752: ) IS
2753:
2754: BEGIN
2755:
2756: arp_standard.debug('arp_confirmation.validate_in_parameters()+');
2757:
2758: -- make sure none of the arguments is NULL:
2759:
2760: IF (p_cr_id IS NULL) THEN

Line 2780: arp_standard.debug('arp_confirmation.validate_in_parameters()-');

2776: END IF;
2777:
2778: -- ???? validate dates any further ????
2779:
2780: arp_standard.debug('arp_confirmation.validate_in_parameters()-');
2781:
2782: EXCEPTION
2783: WHEN OTHERS THEN
2784: arp_standard.debug('EXCEPTION: arp_confirmation.validate_in_parameters');

Line 2784: arp_standard.debug('EXCEPTION: arp_confirmation.validate_in_parameters');

2780: arp_standard.debug('arp_confirmation.validate_in_parameters()-');
2781:
2782: EXCEPTION
2783: WHEN OTHERS THEN
2784: arp_standard.debug('EXCEPTION: arp_confirmation.validate_in_parameters');
2785: RAISE;
2786:
2787: END; -- validate_in_parameters()
2788:

Line 2840: arp_util.debug('EXCEPTION: NO DATA FOUND, arp_confirmation.get_application_flags()');

2836: WHERE cust_trx_type_id = p_cust_trx_type_id;
2837:
2838: EXCEPTION
2839: WHEN NO_DATA_FOUND THEN
2840: arp_util.debug('EXCEPTION: NO DATA FOUND, arp_confirmation.get_application_flags()');
2841: RAISE;
2842:
2843: WHEN OTHERS THEN
2844: arp_util.debug('EXCEPTION: arp_confirmation.get_application_flags()');

Line 2844: arp_util.debug('EXCEPTION: arp_confirmation.get_application_flags()');

2840: arp_util.debug('EXCEPTION: NO DATA FOUND, arp_confirmation.get_application_flags()');
2841: RAISE;
2842:
2843: WHEN OTHERS THEN
2844: arp_util.debug('EXCEPTION: arp_confirmation.get_application_flags()');
2845: RAISE;
2846:
2847: END; -- get_application_flags()
2848:

Line 2901: END ARP_CONFIRMATION;

2897: p_max_dates.max_trx_date := GREATEST(p_max_dates.max_trx_date,
2898: p_apply_date);
2899: END; -- handle_max_dates()
2900:
2901: END ARP_CONFIRMATION;