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_REVERSE_RECEIPT dependencies on ARP_REVERSE_RECEIPT

Line 1: PACKAGE BODY ARP_REVERSE_RECEIPT AS

1: PACKAGE BODY ARP_REVERSE_RECEIPT AS
2: /* $Header: ARREREVB.pls 120.23.12010000.3 2008/09/11 15:15:33 mpsingh ship $*/
3:
4: /* =======================================================================
5: | Global Data Types

Line 251: arp_standard.debug('validate_args: ' || 'arp_reverse_receipt.reverse() +');

247: where receipt_method_id = p_receipt_method_id;
248:
249: BEGIN
250: IF PG_DEBUG in ('Y', 'C') THEN
251: arp_standard.debug('validate_args: ' || 'arp_reverse_receipt.reverse() +');
252: arp_standard.debug('validate_args: ' || 'cr_id = '||to_char( p_cr_id ) );
253: END IF;
254: -- Validate input arguments
255: IF ( p_module_name IS NOT NULL and p_module_version IS NOT NULL ) THEN

Line 502: arp_standard.debug('validate_args: ' || 'EXCEPTION: arp_reverse_receipt.reverse' );

498: CLOSE ar_rc_rec;
499: END IF;
500: --
501: IF PG_DEBUG in ('Y', 'C') THEN
502: arp_standard.debug('validate_args: ' || 'EXCEPTION: arp_reverse_receipt.reverse' );
503: END IF;
504: RAISE;
505: END;
506: end if; --(l_cr_rec.amount < 0 and v_credit_card)

Line 607: arp_standard.debug('validate_args: ' || 'arp_reverse_receipt.reverse() -');

603: modify_update_bat_rec( l_batch_id, l_cr_rec.amount, p_reversal_category );
604: END IF;
605: --
606: IF PG_DEBUG in ('Y', 'C') THEN
607: arp_standard.debug('validate_args: ' || 'arp_reverse_receipt.reverse() -');
608: END IF;
609: --
610: EXCEPTION
611: WHEN unapply_netting_err THEN

Line 617: arp_standard.debug('validate_args: ' || 'EXCEPTION: arp_reverse_receipt.reverse - error calling ar_receipt_api_pub.unapply_open_receipt' );

613: CLOSE ar_ra_C;
614: END IF;
615: --
616: IF PG_DEBUG in ('Y', 'C') THEN
617: arp_standard.debug('validate_args: ' || 'EXCEPTION: arp_reverse_receipt.reverse - error calling ar_receipt_api_pub.unapply_open_receipt' );
618: END IF;
619: RAISE;
620: WHEN cancel_refund_err THEN
621: IF ar_ra_C%ISOPEN THEN

Line 626: arp_standard.debug('EXCEPTION: arp_reverse_receipt.reverse - error calling ar_refunds_pvt.cancel_refund' );

622: CLOSE ar_ra_C;
623: END IF;
624: --
625: IF PG_DEBUG in ('Y', 'C') THEN
626: arp_standard.debug('EXCEPTION: arp_reverse_receipt.reverse - error calling ar_refunds_pvt.cancel_refund' );
627: END IF;
628: RAISE;
629: WHEN OTHERS THEN
630: IF ar_mcd_C%ISOPEN THEN

Line 635: arp_standard.debug('validate_args: ' || 'EXCEPTION: arp_reverse_receipt.reverse' );

631: CLOSE ar_mcd_C;
632: END IF;
633: --
634: IF PG_DEBUG in ('Y', 'C') THEN
635: arp_standard.debug('validate_args: ' || 'EXCEPTION: arp_reverse_receipt.reverse' );
636: END IF;
637: RAISE;
638: --
639: END reverse;

Line 674: arp_standard.debug( 'arp_reverse_receipt.validate_args() +');

670: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,
671: p_reversal_reason_code IN VARCHAR2 ) IS
672: BEGIN
673: IF PG_DEBUG in ('Y', 'C') THEN
674: arp_standard.debug( 'arp_reverse_receipt.validate_args() +');
675: END IF;
676: --
677: IF ( p_cr_id is NULL OR p_reversal_category is NULL OR
678: p_reversal_gl_date is NULL OR p_reversal_date is NULL OR

Line 695: arp_standard.debug( 'arp_reverse_receipt.validate_args() -');

691: APP_EXCEPTION.raise_exception;
692: END IF;
693: --
694: IF PG_DEBUG in ('Y', 'C') THEN
695: arp_standard.debug( 'arp_reverse_receipt.validate_args() -');
696: END IF;
697: EXCEPTION
698: WHEN OTHERS THEN
699: IF PG_DEBUG in ('Y', 'C') THEN

Line 701: 'EXCEPTION: arp_reverse_receipt.validate_args' );

697: EXCEPTION
698: WHEN OTHERS THEN
699: IF PG_DEBUG in ('Y', 'C') THEN
700: arp_standard.debug('validate_args: ' ||
701: 'EXCEPTION: arp_reverse_receipt.validate_args' );
702: END IF;
703: RAISE;
704: --
705: END validate_args;

Line 771: arp_standard.debug( 'arp_reverse_receipt.insert_reversal_dist_rec() +');

767:
768: BEGIN
769:
770: IF PG_DEBUG in ('Y', 'C') THEN
771: arp_standard.debug( 'arp_reverse_receipt.insert_reversal_dist_rec() +');
772: arp_standard.debug('insert_reversal_dist_rec: ' || '-- cr_id = '||to_char( p_cr_id ) );
773: arp_standard.debug('insert_reversal_dist_rec: ' || '-- crh_id = '||to_char( p_crh_id ) );
774: arp_standard.debug('insert_reversal_dist_rec: ' || '-- Fetching the cash receipt record -- ');
775: END IF;

Line 844: arp_standard.debug( 'arp_reverse_receipt.insert_reversal_dist_rec() -');

840: ARP_XLA_EVENTS.create_events(p_xla_ev_rec => l_xla_ev_rec);
841:
842:
843: IF PG_DEBUG in ('Y', 'C') THEN
844: arp_standard.debug( 'arp_reverse_receipt.insert_reversal_dist_rec() -');
845: END IF;
846: EXCEPTION
847: --
848: WHEN OTHERS THEN

Line 851: 'EXCEPTION: arp_reverse_receipt.insert_reversal_dist_rec' );

847: --
848: WHEN OTHERS THEN
849: IF PG_DEBUG in ('Y', 'C') THEN
850: arp_standard.debug('insert_reversal_dist_rec: ' ||
851: 'EXCEPTION: arp_reverse_receipt.insert_reversal_dist_rec' );
852: END IF;
853: RAISE;
854: --
855: END insert_reversal_dist_rec;

Line 903: arp_standard.debug( 'arp_reverse_receipt.insert_reversal_crh_record() +');

899: l_xla_ev_rec arp_xla_events.xla_events_type;
900:
901: BEGIN
902: IF PG_DEBUG in ('Y', 'C') THEN
903: arp_standard.debug( 'arp_reverse_receipt.insert_reversal_crh_record() +');
904: END IF;
905: --
906: -- The amount columns are not updated to 0. This was done in Rel 10.5
907: -- For more info on this look at /appldev/ar/7.1/upgrade/sql/ar760u15.sql

Line 949: p_crh_rec.created_from := 'ARP_REVERSE_RECEIPT.REVERSE';

945: p_crh_rec.status := 'REVERSED';
946: p_crh_rec.gl_posted_date := NULL;
947: p_crh_rec.posting_control_id := -3;
948: --
949: p_crh_rec.created_from := 'ARP_REVERSE_RECEIPT.REVERSE';
950: --
951: p_crh_rec.prv_stat_cash_receipt_hist_id :=
952: p_crh_rec.cash_receipt_history_id;
953: --

Line 969: arp_standard.debug( 'arp_reverse_receipt.insert_reversal_crh_record() -');

965: l_xla_ev_rec.xla_call := 'B';
966: ARP_XLA_EVENTS.create_events(p_xla_ev_rec => l_xla_ev_rec);
967:
968: IF PG_DEBUG in ('Y', 'C') THEN
969: arp_standard.debug( 'arp_reverse_receipt.insert_reversal_crh_record() -');
970: END IF;
971: EXCEPTION
972: WHEN OTHERS THEN
973: IF PG_DEBUG in ('Y', 'C') THEN

Line 975: 'EXCEPTION: arp_reverse_receipt.insert_reversal_crh_record' );

971: EXCEPTION
972: WHEN OTHERS THEN
973: IF PG_DEBUG in ('Y', 'C') THEN
974: arp_standard.debug('insert_reversal_crh_record: ' ||
975: 'EXCEPTION: arp_reverse_receipt.insert_reversal_crh_record' );
976: END IF;
977: RAISE;
978: END insert_reversal_crh_record;
979: --

Line 1019: arp_standard.debug( 'arp_reverse_receipt.update_current_crh_record() +');

1015: l_xla_ev_rec arp_xla_events.xla_events_type;
1016:
1017: BEGIN
1018: IF PG_DEBUG in ('Y', 'C') THEN
1019: arp_standard.debug( 'arp_reverse_receipt.update_current_crh_record() +');
1020: arp_standard.debug('update_current_crh_record: ' || 'crh_id_new = '||to_char( p_crh_id_new ) );
1021: END IF;
1022:
1023: p_crh_rec.current_record_flag := NULL;

Line 1028: p_crh_rec.reversal_created_from := 'ARP_REVERSE_RECEIPT.REVERSE';

1024: p_crh_rec.reversal_gl_date := p_reversal_gl_date;
1025: p_crh_rec.reversal_posting_control_id := -3;
1026: p_crh_rec.reversal_cash_receipt_hist_id :=
1027: p_crh_id_new;
1028: p_crh_rec.reversal_created_from := 'ARP_REVERSE_RECEIPT.REVERSE';
1029: --
1030: -- For each row selected Insert a new cash receipt history record with
1031: -- status 'REVERSED'.
1032: --

Line 1044: arp_standard.debug( 'arp_reverse_receipt.update_current_crh_record() -');

1040: l_xla_ev_rec.xla_call := 'B';
1041: ARP_XLA_EVENTS.create_events(p_xla_ev_rec => l_xla_ev_rec);
1042:
1043: IF PG_DEBUG in ('Y', 'C') THEN
1044: arp_standard.debug( 'arp_reverse_receipt.update_current_crh_record() -');
1045: END IF;
1046: EXCEPTION
1047: WHEN OTHERS THEN
1048: IF PG_DEBUG in ('Y', 'C') THEN

Line 1050: 'EXCEPTION: arp_reverse_receipt.update_current_crh_record' );

1046: EXCEPTION
1047: WHEN OTHERS THEN
1048: IF PG_DEBUG in ('Y', 'C') THEN
1049: arp_standard.debug('update_current_crh_record: ' ||
1050: 'EXCEPTION: arp_reverse_receipt.update_current_crh_record' );
1051: END IF;
1052: RAISE;
1053: --
1054: END update_current_crh_record;

Line 1095: arp_standard.debug( 'arp_reverse_receipt.insert_reversal_mcd_record() +');

1091: l_ae_doc_rec ae_doc_rec_type;
1092:
1093: BEGIN
1094: IF PG_DEBUG in ('Y', 'C') THEN
1095: arp_standard.debug( 'arp_reverse_receipt.insert_reversal_mcd_record() +');
1096: END IF;
1097: --
1098: p_mcd_rec.gl_date := p_reversal_gl_date;
1099: p_mcd_rec.apply_date := p_reversal_date;

Line 1103: p_mcd_rec.created_from := 'ARP_REVERSE_RECEIPT.REVERSE';

1099: p_mcd_rec.apply_date := p_reversal_date;
1100: p_mcd_rec.amount := -p_mcd_rec.amount;
1101: p_mcd_rec.acctd_amount := -p_mcd_rec.acctd_amount;
1102: p_mcd_rec.posting_control_id := -3;
1103: p_mcd_rec.created_from := 'ARP_REVERSE_RECEIPT.REVERSE';
1104: P_mcd_rec.gl_posted_date := NULL;
1105: --
1106: -- For insertion use cash_receipt_id and reversal_gl_date=NULL
1107: --

Line 1124: arp_standard.debug( 'arp_reverse_receipt.insert_reversal_mcd_record() -');

1120: l_ae_doc_rec.other_flag := 'REVERSE';
1121: arp_acct_main.Create_Acct_Entry(l_ae_doc_rec);
1122:
1123: IF PG_DEBUG in ('Y', 'C') THEN
1124: arp_standard.debug( 'arp_reverse_receipt.insert_reversal_mcd_record() -');
1125: END IF;
1126: EXCEPTION
1127: WHEN OTHERS THEN
1128: IF PG_DEBUG in ('Y', 'C') THEN

Line 1130: 'EXCEPTION: arp_reverse_receipt.insert_reversal_mcd_record' );

1126: EXCEPTION
1127: WHEN OTHERS THEN
1128: IF PG_DEBUG in ('Y', 'C') THEN
1129: arp_standard.debug('insert_reversal_mcd_record: ' ||
1130: 'EXCEPTION: arp_reverse_receipt.insert_reversal_mcd_record' );
1131: END IF;
1132: RAISE;
1133: --
1134: END insert_reversal_mcd_record;

Line 1168: arp_standard.debug( 'arp_reverse_receipt.check_cb() +');

1164: RETURN BOOLEAN IS
1165: l_count NUMBER DEFAULT 0;
1166: BEGIN
1167: IF PG_DEBUG in ('Y', 'C') THEN
1168: arp_standard.debug( 'arp_reverse_receipt.check_cb() +');
1169: arp_standard.debug('check_cb: ' || 'cr_id = '||to_char( p_cr_id ) );
1170: END IF;
1171: --
1172: SELECT COUNT(*)

Line 1195: arp_standard.debug( 'arp_reverse_receipt.check_cb() -');

1191: RETURN TRUE;
1192: END IF;
1193: --
1194: IF PG_DEBUG in ('Y', 'C') THEN
1195: arp_standard.debug( 'arp_reverse_receipt.check_cb() -');
1196: END IF;
1197: EXCEPTION
1198: WHEN OTHERS THEN
1199: IF PG_DEBUG in ('Y', 'C') THEN

Line 1200: arp_standard.debug( 'EXCEPTION: arp_reverse_receipt.check_cb' );

1196: END IF;
1197: EXCEPTION
1198: WHEN OTHERS THEN
1199: IF PG_DEBUG in ('Y', 'C') THEN
1200: arp_standard.debug( 'EXCEPTION: arp_reverse_receipt.check_cb' );
1201: END IF;
1202: RAISE;
1203: END check_cb;
1204: --

Line 1243: arp_standard.debug( 'arp_reverse_receipt.modify_update_ps_rec() +' );

1239: l_actual_date_closed DATE;
1240: l_ps_rec ar_payment_schedules%ROWTYPE;
1241: BEGIN
1242: IF PG_DEBUG in ('Y', 'C') THEN
1243: arp_standard.debug( 'arp_reverse_receipt.modify_update_ps_rec() +' );
1244: arp_standard.debug('modify_update_ps_rec: ' || to_char( p_cr_id ) );
1245: arp_standard.debug('modify_update_ps_rec: ' || 'cr_id = '||to_char( p_cr_id ) );
1246: END IF;
1247: --

Line 1265: arp_standard.debug( 'arp_reverse_receipt.modify_update_ps_rec() +' );

1261: --
1262: arp_ps_pkg.update_p( l_ps_rec );
1263: --
1264: IF PG_DEBUG in ('Y', 'C') THEN
1265: arp_standard.debug( 'arp_reverse_receipt.modify_update_ps_rec() +' );
1266: END IF;
1267: EXCEPTION
1268: WHEN OTHERS THEN
1269: IF PG_DEBUG in ('Y', 'C') THEN

Line 1271: 'EXCEPTION: arp_reverse_receipt.modify_update_ps_rec' );

1267: EXCEPTION
1268: WHEN OTHERS THEN
1269: IF PG_DEBUG in ('Y', 'C') THEN
1270: arp_standard.debug('modify_update_ps_rec: ' ||
1271: 'EXCEPTION: arp_reverse_receipt.modify_update_ps_rec' );
1272: END IF;
1273: RAISE;
1274: --
1275: END modify_update_ps_rec;

Line 1331: arp_standard.debug( 'arp_reverse_receipt.update_current_cr_rec() +' );

1327: p_attribute14 IN ar_cash_receipts.attribute14%TYPE,
1328: p_attribute15 IN ar_cash_receipts.attribute15%TYPE ) IS
1329: BEGIN
1330: IF PG_DEBUG in ('Y', 'C') THEN
1331: arp_standard.debug( 'arp_reverse_receipt.update_current_cr_rec() +' );
1332: END IF;
1333: --
1334: p_cr_rec.selected_remittance_batch_id := NULL;
1335: p_cr_rec.reversal_category := p_reversal_category;

Line 1361: arp_standard.debug( 'arp_reverse_receipt.update_current_cr_rec() -');

1357: ---
1358: arp_cash_receipts_pkg.update_p( p_cr_rec );
1359: ---
1360: IF PG_DEBUG in ('Y', 'C') THEN
1361: arp_standard.debug( 'arp_reverse_receipt.update_current_cr_rec() -');
1362: END IF;
1363: EXCEPTION
1364: WHEN OTHERS THEN
1365: IF PG_DEBUG in ('Y', 'C') THEN

Line 1367: 'EXCEPTION: arp_reverse_receipt.update_current_cr_rec' );

1363: EXCEPTION
1364: WHEN OTHERS THEN
1365: IF PG_DEBUG in ('Y', 'C') THEN
1366: arp_standard.debug('update_current_cr_rec: ' ||
1367: 'EXCEPTION: arp_reverse_receipt.update_current_cr_rec' );
1368: END IF;
1369: RAISE;
1370: --
1371: END update_current_cr_rec;

Line 1412: arp_standard.debug( 'arp_reverse_receipt.modify_update_bat_rec() +');

1408: l_status ar_batches.status%TYPE;
1409: BEGIN
1410: --
1411: IF PG_DEBUG in ('Y', 'C') THEN
1412: arp_standard.debug( 'arp_reverse_receipt.modify_update_bat_rec() +');
1413: arp_standard.debug('modify_update_bat_rec: ' || 'cr_count = '||to_char( p_cr_amount ) );
1414: arp_standard.debug('modify_update_bat_rec: ' || 'cr_amount = '||to_char( l_bat_rec.control_amount ) );
1415: END IF;
1416: --

Line 1434: 'EXCEPTION: arp_reverse_receipt.modify_update_bat_rec' );

1430: RETURN;
1431: WHEN OTHERS THEN
1432: IF PG_DEBUG in ('Y', 'C') THEN
1433: arp_standard.debug('modify_update_bat_rec: ' ||
1434: 'EXCEPTION: arp_reverse_receipt.modify_update_bat_rec' );
1435: END IF;
1436: END;
1437: --
1438: -- determine if the batch has any unposted quick cash receipt

Line 1480: arp_standard.debug( 'arp_reverse_receipt.modify_update_bat_rec() -');

1476: --
1477: arp_cr_batches_pkg.update_p( l_bat_rec );
1478: --
1479: IF PG_DEBUG in ('Y', 'C') THEN
1480: arp_standard.debug( 'arp_reverse_receipt.modify_update_bat_rec() -');
1481: END IF;
1482: EXCEPTION
1483: WHEN OTHERS THEN
1484: IF PG_DEBUG in ('Y', 'C') THEN

Line 1486: 'EXCEPTION: arp_reverse_receipt.modify_update_bat_rec' );

1482: EXCEPTION
1483: WHEN OTHERS THEN
1484: IF PG_DEBUG in ('Y', 'C') THEN
1485: arp_standard.debug('modify_update_bat_rec: ' ||
1486: 'EXCEPTION: arp_reverse_receipt.modify_update_bat_rec' );
1487: END IF;
1488: RAISE;
1489:
1490: END modify_update_bat_rec;

Line 1686: arp_standard.debug( 'arp_reverse_receipt.debit_memo_reversal() +');

1682: BEGIN
1683: --
1684: -- arp_standard.enable_debug;
1685: IF PG_DEBUG in ('Y', 'C') THEN
1686: arp_standard.debug( 'arp_reverse_receipt.debit_memo_reversal() +');
1687: arp_standard.debug('debit_memo_reversal: ' || 'Parameters:');
1688: arp_standard.debug('debit_memo_reversal: ' || 'p_cr_id = ' || p_cr_rec.cash_receipt_id);
1689: arp_standard.debug('debit_memo_reversal: ' || 'p_cc_id = ' || p_cc_id);
1690: arp_standard.debug('debit_memo_reversal: ' || 'p_cust_trx_type_id = ' || p_cust_trx_type_id);

Line 2117: arp_standard.debug( 'arp_reverse_receipt.debit_memo_reversal() -');

2113: p_attribute14, p_attribute15 );
2114:
2115:
2116: IF PG_DEBUG in ('Y', 'C') THEN
2117: arp_standard.debug( 'arp_reverse_receipt.debit_memo_reversal() -');
2118: END IF;
2119:
2120: EXCEPTION
2121: WHEN OTHERS THEN

Line 2124: 'EXCEPTION: arp_reverse_receipt.debit_memo_reversal' );

2120: EXCEPTION
2121: WHEN OTHERS THEN
2122: IF PG_DEBUG in ('Y', 'C') THEN
2123: arp_standard.debug('debit_memo_reversal: ' ||
2124: 'EXCEPTION: arp_reverse_receipt.debit_memo_reversal' );
2125: END IF;
2126: RAISE;
2127: END debit_memo_reversal;
2128: --

Line 2166: arp_standard.debug( 'arp_reverse_receipt.validate_dm_reversal_args() +');

2162: ar_cash_receipts.reversal_date%TYPE,
2163: p_reversal_reason_code IN VARCHAR2) IS
2164: BEGIN
2165: IF PG_DEBUG in ('Y', 'C') THEN
2166: arp_standard.debug( 'arp_reverse_receipt.validate_dm_reversal_args() +');
2167: END IF;
2168: --
2169: IF ( p_cr_id IS NULL OR p_cc_id IS NULL OR
2170: p_cust_trx_type_id IS NULL OR p_reversal_gl_date IS NULL OR

Line 2177: arp_standard.debug( 'arp_reverse_receipt.validate_dm_reversal_args() -');

2173: APP_EXCEPTION.raise_exception;
2174: END IF;
2175: --
2176: IF PG_DEBUG in ('Y', 'C') THEN
2177: arp_standard.debug( 'arp_reverse_receipt.validate_dm_reversal_args() -');
2178: END IF;
2179: EXCEPTION
2180: WHEN OTHERS THEN
2181: IF PG_DEBUG in ('Y', 'C') THEN

Line 2183: 'EXCEPTION: arp_reverse_receipt.validate_dm_reversal_args' );

2179: EXCEPTION
2180: WHEN OTHERS THEN
2181: IF PG_DEBUG in ('Y', 'C') THEN
2182: arp_standard.debug('validate_dm_reversal_args: ' ||
2183: 'EXCEPTION: arp_reverse_receipt.validate_dm_reversal_args' );
2184: END IF;
2185: RAISE;
2186: --
2187: END validate_dm_reversal_args;

Line 2242: arp_standard.debug( 'arp_reverse_receipt.receipt_has_non_cancel_claims() +');

2238:
2239: BEGIN
2240:
2241: IF PG_DEBUG in ('Y', 'C') THEN
2242: arp_standard.debug( 'arp_reverse_receipt.receipt_has_non_cancel_claims() +');
2243: END IF;
2244:
2245: OPEN c_claim_count;
2246: FETCH c_claim_count INTO l_claim_count;

Line 2262: arp_standard.debug( 'arp_reverse_receipt.receipt_has_non_cancel_claims() -');

2258: END LOOP;
2259: RETURN FALSE;
2260:
2261: IF PG_DEBUG in ('Y', 'C') THEN
2262: arp_standard.debug( 'arp_reverse_receipt.receipt_has_non_cancel_claims() -');
2263: END IF;
2264:
2265: END receipt_has_non_cancel_claims;
2266: --

Line 2327: arp_standard.debug( 'arp_reverse_receipt.cancel_claims() +');

2323: AND application_ref_type = 'CLAIM';
2324:
2325: BEGIN
2326: IF PG_DEBUG in ('Y', 'C') THEN
2327: arp_standard.debug( 'arp_reverse_receipt.cancel_claims() +');
2328: END IF;
2329: FOR c1 in c_claims LOOP
2330: IF OZF_Claim_GRP.Check_Cancell_Deduction(
2331: p_claim_id => c1.secondary_application_ref_id)

Line 2372: arp_standard.debug( 'arp_reverse_receipt.cancel_claims() -');

2368: END IF;
2369: END IF;
2370: END LOOP;
2371: IF PG_DEBUG in ('Y', 'C') THEN
2372: arp_standard.debug( 'arp_reverse_receipt.cancel_claims() -');
2373: END IF;
2374: END cancel_claims;
2375: --
2376: /*===========================================================================+

Line 2415: arp_standard.debug( 'arp_reverse_receipt.receipt_has_claims() +');

2411:
2412: BEGIN
2413:
2414: IF PG_DEBUG in ('Y', 'C') THEN
2415: arp_standard.debug( 'arp_reverse_receipt.receipt_has_claims() +');
2416: END IF;
2417:
2418: OPEN c_claim_count;
2419: FETCH c_claim_count INTO l_claim_count;

Line 2429: arp_standard.debug( 'arp_reverse_receipt.receipt_has_claims() -');

2425: RETURN TRUE;
2426: END IF;
2427:
2428: IF PG_DEBUG in ('Y', 'C') THEN
2429: arp_standard.debug( 'arp_reverse_receipt.receipt_has_claims() -');
2430: END IF;
2431:
2432: END receipt_has_claims;
2433: --

Line 2478: arp_util.debug('arp_reverse_receipt.check_netted_receipts()+');

2474: l_return_status VARCHAR(1);
2475:
2476: BEGIN
2477: IF PG_DEBUG in ('Y', 'C') THEN
2478: arp_util.debug('arp_reverse_receipt.check_netted_receipts()+');
2479: END IF;
2480:
2481: x_return_status := 'S';
2482: FOR c1 in c_netted_receipts LOOP

Line 2496: arp_util.debug('arp_reverse_receipt.check_netted_receipts()-');

2492: END IF;
2493: END LOOP;
2494:
2495: IF PG_DEBUG in ('Y', 'C') THEN
2496: arp_util.debug('arp_reverse_receipt.check_netted_receipts()-');
2497: END IF;
2498:
2499: EXCEPTION
2500: WHEN others THEN

Line 2551: arp_standard.debug( 'arp_reverse_receipt.receipt_has_processed_refunds() +');

2547:
2548: BEGIN
2549:
2550: IF PG_DEBUG in ('Y', 'C') THEN
2551: arp_standard.debug( 'arp_reverse_receipt.receipt_has_processed_refunds() +');
2552: END IF;
2553:
2554: FOR c1 in c_refunds LOOP
2555: BEGIN

Line 2573: arp_standard.debug( 'arp_reverse_receipt.receipt_has_processed_refunds() -');

2569: END LOOP;
2570: RETURN FALSE;
2571:
2572: IF PG_DEBUG in ('Y', 'C') THEN
2573: arp_standard.debug( 'arp_reverse_receipt.receipt_has_processed_refunds() -');
2574: END IF;
2575: END receipt_has_processed_refunds;
2576: --
2577:

Line 2579: END ARP_REVERSE_RECEIPT;

2575: END receipt_has_processed_refunds;
2576: --
2577:
2578:
2579: END ARP_REVERSE_RECEIPT;