115: -- calculate accounted cash receipt amount
116: -- Changes for triangulation: If exchange rate type is not user, call
117: -- GL API to calculate accounted amount
118: IF (l_cr_rec.exchange_rate_type = 'User') THEN
119: arp_util.calc_acctd_amount( NULL,
120: NULL,
121: NULL,
122: l_cr_rec.exchange_rate,
123: '+',
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()
274: -- calculate accounted cash receipt amount
275: -- Changes for triangulation: If exchange rate type is not user, call
276: -- GL API to calculate accounted amount
277: IF (l_cr_rec.exchange_rate_type = 'User') THEN
278: arp_util.calc_acctd_amount( NULL,
279: NULL,
280: NULL,
281: l_cr_rec.exchange_rate,
282: '+',
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()
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));
490: END IF;
491:
492: IF arp_util.is_gl_date_valid(p_confirm_gl_date) THEN
493:
494: SELECT crh.status, cr.confirmed_flag
495: INTO l_status, l_confirmed_flag
496: FROM AR_CASH_RECEIPTS cr,
765:
766:
767: -- calculate accounted amount for application (receipt side):
768:
769: arp_util.calc_acctd_amount( NULL,
770: NULL,
771: NULL,
772: p_cr_rec.exchange_rate,
773: '+',
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()');
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:
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:
1189: arp_standard.debug('update_cr_history_confirm()-');
1190:
1191: EXCEPTION
1192: WHEN OTHERS THEN
1193: arp_util.debug('EXCEPTION: update_cr_history_confirm()');
1194: RAISE;
1195:
1196: END; -- update_cr_history_confirm()
1197:
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:
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()');
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:
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()');
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:
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:
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:
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:
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()');
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:
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()');
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:
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()');
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: