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_RW_ICR_PKG dependencies on ARP_RW_ICR_PKG

Line 1: PACKAGE BODY ARP_RW_ICR_PKG AS

1: PACKAGE BODY ARP_RW_ICR_PKG AS
2: /* $Header: ARERICRB.pls 120.7.12010000.2 2008/08/22 09:55:05 rvelidi ship $ */
3: --
4: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
5:

Line 202: arp_util.debug( 'arp_rw_icr_pkg.update_row()+' );

198: --
199: l_icr_rec ar_interim_cash_receipts%ROWTYPE;
200: BEGIN
201: IF PG_DEBUG in ('Y', 'C') THEN
202: arp_util.debug( 'arp_rw_icr_pkg.update_row()+' );
203: arp_util.debug( 'Special Type : '||p_special_type );
204: arp_util.debug( 'Receipt Id : '||p_cr_id );
205: arp_util.debug( 'Row Id : '||p_row_id );
206: arp_util.debug( 'Receipt Number : '||p_receipt_number );

Line 301: arp_rw_icr_pkg.check_unique_receipt( p_row_id, l_icr_rec.cash_receipt_id,

297: END IF;
298: --
299: -- Call Check Unique Batch Name procedure
300: --
301: arp_rw_icr_pkg.check_unique_receipt( p_row_id, l_icr_rec.cash_receipt_id,
302: l_icr_rec.special_type,
303: l_icr_rec.receipt_number,
304: l_icr_rec.pay_from_customer,
305: l_icr_rec.amount,

Line 320: arp_util.debug( 'arp_rw_icr_pkg.update_row()-' );

316: arp_rw_batches_check_pkg.update_batch_status( p_batch_id );
317: END IF;
318:
319: IF PG_DEBUG in ('Y', 'C') THEN
320: arp_util.debug( 'arp_rw_icr_pkg.update_row()-' );
321: END IF;
322: --
323: EXCEPTION
324: WHEN OTHERS THEN

Line 326: arp_util.debug( 'EXCEPTION: arp_rw_icr_pkg.update_row' );

322: --
323: EXCEPTION
324: WHEN OTHERS THEN
325: IF PG_DEBUG in ('Y', 'C') THEN
326: arp_util.debug( 'EXCEPTION: arp_rw_icr_pkg.update_row' );
327: END IF;
328: RAISE;
329: END update_row;
330: --

Line 377: arp_util.debug( 'arp_rw_icr_pkg.validate_args_update_row()+' );

373: p_remittance_bank_account_id IN
374: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE ) IS
375: BEGIN
376: IF PG_DEBUG in ('Y', 'C') THEN
377: arp_util.debug( 'arp_rw_icr_pkg.validate_args_update_row()+' );
378: END IF;
379: --
380: IF ( p_row_id IS NULL OR p_cr_id IS NULL OR
381: p_receipt_number IS NULL OR p_receipt_amount IS NULL OR

Line 393: arp_util.debug( 'arp_rw_icr_pkg.validate_args_update_row()-' );

389: p_site_use_id, p_customer_trx_id,
390: p_payment_schedule_id );
391: --
392: IF PG_DEBUG in ('Y', 'C') THEN
393: arp_util.debug( 'arp_rw_icr_pkg.validate_args_update_row()-' );
394: END IF;
395: --
396: EXCEPTION
397: WHEN OTHERS THEN

Line 400: 'EXCEPTION: arp_rw_icr_pkg.validate_args_update_row' );

396: EXCEPTION
397: WHEN OTHERS THEN
398: IF PG_DEBUG in ('Y', 'C') THEN
399: arp_util.debug(
400: 'EXCEPTION: arp_rw_icr_pkg.validate_args_update_row' );
401: END IF;
402: RAISE;
403: END validate_args_update_row;
404: --

Line 525: arp_util.debug( 'arp_rw_icr_pkg.insert_row()+' );

521: l_icr_rec ar_interim_cash_receipts%ROWTYPE;
522: --
523: BEGIN
524: IF PG_DEBUG in ('Y', 'C') THEN
525: arp_util.debug( 'arp_rw_icr_pkg.insert_row()+' );
526: arp_util.debug( 'Special Type : '||p_special_type );
527: arp_util.debug( 'Receipt Number : '||p_receipt_number );
528: arp_util.debug( 'Receipt Date : '||TO_CHAR( p_receipt_date ) );
529: arp_util.debug( 'GL Date : '||TO_CHAR( p_gl_date ) );

Line 627: arp_rw_icr_pkg.check_unique_receipt( l_row_id, l_cr_id,

623: --
624: --
625: -- Call Check Unique Batch Name procedure
626: --
627: arp_rw_icr_pkg.check_unique_receipt( l_row_id, l_cr_id,
628: l_icr_rec.special_type,
629: l_icr_rec.receipt_number,
630: l_icr_rec.pay_from_customer,
631: l_icr_rec.amount,

Line 661: arp_util.debug( 'arp_rw_icr_pkg.insert_row()-' );

657:
658:
659: --
660: IF PG_DEBUG in ('Y', 'C') THEN
661: arp_util.debug( 'arp_rw_icr_pkg.insert_row()-' );
662: END IF;
663: --
664: EXCEPTION
665: WHEN OTHERS THEN

Line 667: arp_util.debug( 'EXCEPTION: arp_rw_icr_pkg.insert_row' );

663: --
664: EXCEPTION
665: WHEN OTHERS THEN
666: IF PG_DEBUG in ('Y', 'C') THEN
667: arp_util.debug( 'EXCEPTION: arp_rw_icr_pkg.insert_row' );
668: END IF;
669: RAISE;
670: END insert_row;
671: --

Line 721: arp_util.debug( 'arp_rw_icr_pkg.validate_args_insert_row()+' );

717: p_remittance_bank_account_id IN
718: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE ) IS
719: BEGIN
720: IF PG_DEBUG in ('Y', 'C') THEN
721: arp_util.debug( 'arp_rw_icr_pkg.validate_args_insert_row()+' );
722: END IF;
723: --
724: IF ( p_row_id IS NOT NULL OR p_cr_id IS NOT NULL ) THEN
725: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );

Line 743: arp_util.debug( 'arp_rw_icr_pkg.validate_args_insert_row()-' );

739: p_site_use_id, p_customer_trx_id,
740: p_payment_schedule_id );
741: --
742: IF PG_DEBUG in ('Y', 'C') THEN
743: arp_util.debug( 'arp_rw_icr_pkg.validate_args_insert_row()-' );
744: END IF;
745: --
746: EXCEPTION
747: WHEN OTHERS THEN

Line 750: 'EXCEPTION: arp_rw_icr_pkg.validate_args_insert_row' );

746: EXCEPTION
747: WHEN OTHERS THEN
748: IF PG_DEBUG in ('Y', 'C') THEN
749: arp_util.debug(
750: 'EXCEPTION: arp_rw_icr_pkg.validate_args_insert_row' );
751: END IF;
752: RAISE;
753: END validate_args_insert_row;
754: --

Line 861: arp_util.debug( 'arp_rw_icr_pkg.get_applied_amount_total()+' );

857: p_module_name IN VARCHAR2,
858: p_module_version IN VARCHAR2 ) IS
859: BEGIN
860: IF PG_DEBUG in ('Y', 'C') THEN
861: arp_util.debug( 'arp_rw_icr_pkg.get_applied_amount_total()+' );
862: arp_util.debug('get_applied_amount_total: ' || 'Icr Id : '||p_cr_id );
863: END IF;
864: --
865: -- Validate args.

Line 878: arp_util.debug( 'arp_rw_icr_pkg.get_applied_amount_total()-' );

874: FROM ar_interim_cash_receipt_lines
875: WHERE cash_receipt_id = p_cr_id;
876: --
877: IF PG_DEBUG in ('Y', 'C') THEN
878: arp_util.debug( 'arp_rw_icr_pkg.get_applied_amount_total()-' );
879: END IF;
880: --
881: EXCEPTION
882: WHEN OTHERS THEN

Line 885: 'EXCEPTION: arp_rw_icr_pkg.get_applied_amount_total' );

881: EXCEPTION
882: WHEN OTHERS THEN
883: IF PG_DEBUG in ('Y', 'C') THEN
884: arp_util.debug('get_applied_amount_total: ' ||
885: 'EXCEPTION: arp_rw_icr_pkg.get_applied_amount_total' );
886: END IF;
887: RAISE;
888: END get_applied_amount_total;
889: --

Line 917: arp_util.debug( 'arp_rw_icr_pkg.val_args_applied_amount_total()+' );

913: PROCEDURE val_args_applied_amount_total(
914: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE ) IS
915: BEGIN
916: IF PG_DEBUG in ('Y', 'C') THEN
917: arp_util.debug( 'arp_rw_icr_pkg.val_args_applied_amount_total()+' );
918: END IF;
919: --
920: IF ( p_cr_id is NULL ) THEN
921: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );

Line 926: arp_util.debug( 'arp_rw_icr_pkg.val_args_applied_amount_total()-' );

922: APP_EXCEPTION.raise_exception;
923: END IF;
924: --
925: IF PG_DEBUG in ('Y', 'C') THEN
926: arp_util.debug( 'arp_rw_icr_pkg.val_args_applied_amount_total()-' );
927: END IF;
928: --
929: EXCEPTION
930: WHEN OTHERS THEN

Line 933: 'EXCEPTION: arp_rw_icr_pkg.val_args_applied_amount_total' );

929: EXCEPTION
930: WHEN OTHERS THEN
931: IF PG_DEBUG in ('Y', 'C') THEN
932: arp_util.debug('val_args_applied_amount_total: ' ||
933: 'EXCEPTION: arp_rw_icr_pkg.val_args_applied_amount_total' );
934: END IF;
935: RAISE;
936: END val_args_applied_amount_total;
937: --

Line 980: arp_util.debug( 'arp_rw_icr_pkg.check_unique_receipt()+' );

976: p_module_version IN VARCHAR2 ) IS
977: l_count NUMBER := 0;
978: BEGIN
979: IF PG_DEBUG in ('Y', 'C') THEN
980: arp_util.debug( 'arp_rw_icr_pkg.check_unique_receipt()+' );
981: arp_util.debug( 'Row Id : '||p_row_id );
982: arp_util.debug( 'Icr Id : '||p_cr_id );
983: arp_util.debug( 'Receipt Number : '||p_receipt_number );
984: arp_util.debug( 'Customer ID : '||p_customer_id );

Line 1033: arp_util.debug( 'arp_rw_icr_pkg.check_unique_receipt()-' );

1029: APP_EXCEPTION.raise_exception;
1030: END IF;
1031: --
1032: IF PG_DEBUG in ('Y', 'C') THEN
1033: arp_util.debug( 'arp_rw_icr_pkg.check_unique_receipt()-' );
1034: END IF;
1035: --
1036: EXCEPTION
1037: WHEN OTHERS THEN

Line 1040: 'EXCEPTION: arp_rw_icr_pkg.check_unique_receipt' );

1036: EXCEPTION
1037: WHEN OTHERS THEN
1038: IF PG_DEBUG in ('Y', 'C') THEN
1039: arp_util.debug(
1040: 'EXCEPTION: arp_rw_icr_pkg.check_unique_receipt' );
1041: END IF;
1042: RAISE;
1043: END check_unique_receipt;
1044: --

Line 1077: arp_util.debug( 'arp_rw_icr_pkg.val_args_check_unique_receipt()+' );

1073: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
1074: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE ) IS
1075: BEGIN
1076: IF PG_DEBUG in ('Y', 'C') THEN
1077: arp_util.debug( 'arp_rw_icr_pkg.val_args_check_unique_receipt()+' );
1078: END IF;
1079: --
1080: --
1081: -- Note: Special type can be NULL

Line 1094: arp_util.debug( 'arp_rw_icr_pkg.val_args_check_unique_receipt()-' );

1090: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );
1091: APP_EXCEPTION.raise_exception;
1092: END IF;
1093: IF PG_DEBUG in ('Y', 'C') THEN
1094: arp_util.debug( 'arp_rw_icr_pkg.val_args_check_unique_receipt()-' );
1095: END IF;
1096: --
1097: EXCEPTION
1098: WHEN OTHERS THEN

Line 1101: 'EXCEPTION: arp_rw_icr_pkg.val_args_check_unique_receipt' );

1097: EXCEPTION
1098: WHEN OTHERS THEN
1099: IF PG_DEBUG in ('Y', 'C') THEN
1100: arp_util.debug('val_args_check_unique_receipt: ' ||
1101: 'EXCEPTION: arp_rw_icr_pkg.val_args_check_unique_receipt' );
1102: END IF;
1103: RAISE;
1104: END val_args_check_unique_receipt;
1105: --

Line 1140: arp_util.debug( 'arp_rw_icr_pkg.lines_exists()+' );

1136: l_count NUMBER;
1137: BEGIN
1138: --
1139: IF PG_DEBUG in ('Y', 'C') THEN
1140: arp_util.debug( 'arp_rw_icr_pkg.lines_exists()+' );
1141: END IF;
1142: --
1143: -- Do argument validation, Note: No separate procedure used
1144: --

Line 1164: arp_util.debug( 'arp_rw_icr_pkg.lines_exists()-' );

1160: RETURN TRUE;
1161: END IF;
1162: --
1163: IF PG_DEBUG in ('Y', 'C') THEN
1164: arp_util.debug( 'arp_rw_icr_pkg.lines_exists()-' );
1165: END IF;
1166: --
1167: EXCEPTION
1168: WHEN OTHERS THEN

Line 1171: 'EXCEPTION: arp_rw_icr_pkg.lines_exists' );

1167: EXCEPTION
1168: WHEN OTHERS THEN
1169: IF PG_DEBUG in ('Y', 'C') THEN
1170: arp_util.debug('lines_exists: ' ||
1171: 'EXCEPTION: arp_rw_icr_pkg.lines_exists' );
1172: END IF;
1173: RAISE;
1174: END lines_exists;
1175: --

Line 1208: arp_util.debug( 'arp_rw_icr_pkg.check_no_lines_exists()-' );

1204: p_module_name IN VARCHAR2,
1205: p_module_version IN VARCHAR2 ) IS
1206: BEGIN
1207: IF PG_DEBUG in ('Y', 'C') THEN
1208: arp_util.debug( 'arp_rw_icr_pkg.check_no_lines_exists()-' );
1209: END IF;
1210: --
1211: -- Do argument validation, Note: No separate procedure used
1212: --

Line 1220: IF ( arp_rw_icr_pkg.lines_exists( p_cr_id, NULL, NULL ) = TRUE ) THEN

1216: APP_EXCEPTION.raise_exception;
1217: END IF;
1218: END IF;
1219: --
1220: IF ( arp_rw_icr_pkg.lines_exists( p_cr_id, NULL, NULL ) = TRUE ) THEN
1221: FND_MESSAGE.set_name( 'AR', 'AR_UPDNA_APP_TYPE' );
1222: APP_EXCEPTION.raise_exception;
1223: END IF;
1224: --

Line 1226: arp_util.debug( 'arp_rw_icr_pkg.check_no_lines_exists()-' );

1222: APP_EXCEPTION.raise_exception;
1223: END IF;
1224: --
1225: IF PG_DEBUG in ('Y', 'C') THEN
1226: arp_util.debug( 'arp_rw_icr_pkg.check_no_lines_exists()-' );
1227: END IF;
1228: --
1229: EXCEPTION
1230: WHEN OTHERS THEN

Line 1233: 'EXCEPTION: arp_rw_icr_pkg.check_no_lines_exists' );

1229: EXCEPTION
1230: WHEN OTHERS THEN
1231: IF PG_DEBUG in ('Y', 'C') THEN
1232: arp_util.debug('check_no_lines_exists: ' ||
1233: 'EXCEPTION: arp_rw_icr_pkg.check_no_lines_exists' );
1234: END IF;
1235: RAISE;
1236: END check_no_lines_exists;
1237: --

Line 1266: arp_util.debug( 'arp_rw_icr_pkg.update_bank_account_uses()+' );

1262: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
1263: p_bank_account_id IN ar_batches.remit_bank_acct_use_id%TYPE ) IS
1264: BEGIN
1265: IF PG_DEBUG in ('Y', 'C') THEN
1266: arp_util.debug( 'arp_rw_icr_pkg.update_bank_account_uses()+' );
1267: arp_util.debug('update_bank_account_uses: ' || 'Customer ID : '||p_customer_id );
1268: arp_util.debug('update_bank_account_uses: ' || 'Bank Account Id : '||p_bank_account_id );
1269: END IF;
1270: --

Line 1272: arp_util.debug( 'arp_rw_icr_pkg.update_bank_account_uses()-' );

1268: arp_util.debug('update_bank_account_uses: ' || 'Bank Account Id : '||p_bank_account_id );
1269: END IF;
1270: --
1271: IF PG_DEBUG in ('Y', 'C') THEN
1272: arp_util.debug( 'arp_rw_icr_pkg.update_bank_account_uses()-' );
1273: END IF;
1274: --
1275: END update_bank_account_uses;
1276: --

Line 1313: arp_util.debug( 'arp_rw_icr_pkg.delete_row()+' );

1309: p_module_name IN VARCHAR2,
1310: p_module_version IN VARCHAR2 ) IS
1311: BEGIN
1312: IF PG_DEBUG in ('Y', 'C') THEN
1313: arp_util.debug( 'arp_rw_icr_pkg.delete_row()+' );
1314: END IF;
1315: --
1316: IF ( p_module_name IS NOT NULL AND p_module_version IS NOT NULL ) THEN
1317: IF ( p_cr_id is NULL OR p_row_id IS NULL ) THEN

Line 1329: arp_util.debug( 'arp_rw_icr_pkg.delete_row()-' );

1325: arp_cr_icr_lines_pkg.delete_fk( p_cr_id );
1326: arp_cr_icr_pkg.delete_p( p_cr_id );
1327: --
1328: IF PG_DEBUG in ('Y', 'C') THEN
1329: arp_util.debug( 'arp_rw_icr_pkg.delete_row()-' );
1330: END IF;
1331: --
1332: EXCEPTION
1333: WHEN OTHERS THEN

Line 1336: 'EXCEPTION: arp_rw_icr_pkg.delete_row' );

1332: EXCEPTION
1333: WHEN OTHERS THEN
1334: IF PG_DEBUG in ('Y', 'C') THEN
1335: arp_util.debug('delete_row: ' ||
1336: 'EXCEPTION: arp_rw_icr_pkg.delete_row' );
1337: END IF;
1338: RAISE;
1339: END delete_row;
1340: --

Line 1565: END ARP_RW_ICR_PKG;

1561: APP_EXCEPTION.Raise_Exception;
1562: end if;
1563: END lock_row;
1564: --
1565: END ARP_RW_ICR_PKG;