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.3 2009/02/02 16:46:38 mpsingh ship $ */
3: --
4: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
5:

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

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

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

303: END IF;
304: --
305: -- Call Check Unique Batch Name procedure
306: --
307: arp_rw_icr_pkg.check_unique_receipt( p_row_id, l_icr_rec.cash_receipt_id,
308: l_icr_rec.special_type,
309: l_icr_rec.receipt_number,
310: l_icr_rec.pay_from_customer,
311: l_icr_rec.amount,

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

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

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

328: --
329: EXCEPTION
330: WHEN OTHERS THEN
331: IF PG_DEBUG in ('Y', 'C') THEN
332: arp_util.debug( 'EXCEPTION: arp_rw_icr_pkg.update_row' );
333: END IF;
334: RAISE;
335: END update_row;
336: --

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

379: p_remittance_bank_account_id IN
380: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE ) IS
381: BEGIN
382: IF PG_DEBUG in ('Y', 'C') THEN
383: arp_util.debug( 'arp_rw_icr_pkg.validate_args_update_row()+' );
384: END IF;
385: --
386: IF ( p_row_id IS NULL OR p_cr_id IS NULL OR
387: p_receipt_number IS NULL OR p_receipt_amount IS NULL OR

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

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

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

402: EXCEPTION
403: WHEN OTHERS THEN
404: IF PG_DEBUG in ('Y', 'C') THEN
405: arp_util.debug(
406: 'EXCEPTION: arp_rw_icr_pkg.validate_args_update_row' );
407: END IF;
408: RAISE;
409: END validate_args_update_row;
410: --

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

529: l_icr_rec ar_interim_cash_receipts%ROWTYPE;
530: --
531: BEGIN
532: IF PG_DEBUG in ('Y', 'C') THEN
533: arp_util.debug( 'arp_rw_icr_pkg.insert_row()+' );
534: arp_util.debug( 'Special Type : '||p_special_type );
535: arp_util.debug( 'Receipt Number : '||p_receipt_number );
536: arp_util.debug( 'Receipt Date : '||TO_CHAR( p_receipt_date ) );
537: arp_util.debug( 'GL Date : '||TO_CHAR( p_gl_date ) );

Line 639: arp_rw_icr_pkg.check_unique_receipt( l_row_id, l_cr_id,

635: --
636: --
637: -- Call Check Unique Batch Name procedure
638: --
639: arp_rw_icr_pkg.check_unique_receipt( l_row_id, l_cr_id,
640: l_icr_rec.special_type,
641: l_icr_rec.receipt_number,
642: l_icr_rec.pay_from_customer,
643: l_icr_rec.amount,

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

669:
670:
671: --
672: IF PG_DEBUG in ('Y', 'C') THEN
673: arp_util.debug( 'arp_rw_icr_pkg.insert_row()-' );
674: END IF;
675: --
676: EXCEPTION
677: WHEN OTHERS THEN

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

675: --
676: EXCEPTION
677: WHEN OTHERS THEN
678: IF PG_DEBUG in ('Y', 'C') THEN
679: arp_util.debug( 'EXCEPTION: arp_rw_icr_pkg.insert_row' );
680: END IF;
681: RAISE;
682: END insert_row;
683: --

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

729: p_remittance_bank_account_id IN
730: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE ) IS
731: BEGIN
732: IF PG_DEBUG in ('Y', 'C') THEN
733: arp_util.debug( 'arp_rw_icr_pkg.validate_args_insert_row()+' );
734: END IF;
735: --
736: IF ( p_row_id IS NOT NULL OR p_cr_id IS NOT NULL ) THEN
737: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );

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

751: p_site_use_id, p_customer_trx_id,
752: p_payment_schedule_id );
753: --
754: IF PG_DEBUG in ('Y', 'C') THEN
755: arp_util.debug( 'arp_rw_icr_pkg.validate_args_insert_row()-' );
756: END IF;
757: --
758: EXCEPTION
759: WHEN OTHERS THEN

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

758: EXCEPTION
759: WHEN OTHERS THEN
760: IF PG_DEBUG in ('Y', 'C') THEN
761: arp_util.debug(
762: 'EXCEPTION: arp_rw_icr_pkg.validate_args_insert_row' );
763: END IF;
764: RAISE;
765: END validate_args_insert_row;
766: --

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

869: p_module_name IN VARCHAR2,
870: p_module_version IN VARCHAR2 ) IS
871: BEGIN
872: IF PG_DEBUG in ('Y', 'C') THEN
873: arp_util.debug( 'arp_rw_icr_pkg.get_applied_amount_total()+' );
874: arp_util.debug('get_applied_amount_total: ' || 'Icr Id : '||p_cr_id );
875: END IF;
876: --
877: -- Validate args.

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

886: FROM ar_interim_cash_receipt_lines
887: WHERE cash_receipt_id = p_cr_id;
888: --
889: IF PG_DEBUG in ('Y', 'C') THEN
890: arp_util.debug( 'arp_rw_icr_pkg.get_applied_amount_total()-' );
891: END IF;
892: --
893: EXCEPTION
894: WHEN OTHERS THEN

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

893: EXCEPTION
894: WHEN OTHERS THEN
895: IF PG_DEBUG in ('Y', 'C') THEN
896: arp_util.debug('get_applied_amount_total: ' ||
897: 'EXCEPTION: arp_rw_icr_pkg.get_applied_amount_total' );
898: END IF;
899: RAISE;
900: END get_applied_amount_total;
901: --

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

925: PROCEDURE val_args_applied_amount_total(
926: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE ) IS
927: BEGIN
928: IF PG_DEBUG in ('Y', 'C') THEN
929: arp_util.debug( 'arp_rw_icr_pkg.val_args_applied_amount_total()+' );
930: END IF;
931: --
932: IF ( p_cr_id is NULL ) THEN
933: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );

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

934: APP_EXCEPTION.raise_exception;
935: END IF;
936: --
937: IF PG_DEBUG in ('Y', 'C') THEN
938: arp_util.debug( 'arp_rw_icr_pkg.val_args_applied_amount_total()-' );
939: END IF;
940: --
941: EXCEPTION
942: WHEN OTHERS THEN

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

941: EXCEPTION
942: WHEN OTHERS THEN
943: IF PG_DEBUG in ('Y', 'C') THEN
944: arp_util.debug('val_args_applied_amount_total: ' ||
945: 'EXCEPTION: arp_rw_icr_pkg.val_args_applied_amount_total' );
946: END IF;
947: RAISE;
948: END val_args_applied_amount_total;
949: --

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

988: p_module_version IN VARCHAR2 ) IS
989: l_count NUMBER := 0;
990: BEGIN
991: IF PG_DEBUG in ('Y', 'C') THEN
992: arp_util.debug( 'arp_rw_icr_pkg.check_unique_receipt()+' );
993: arp_util.debug( 'Row Id : '||p_row_id );
994: arp_util.debug( 'Icr Id : '||p_cr_id );
995: arp_util.debug( 'Receipt Number : '||p_receipt_number );
996: arp_util.debug( 'Customer ID : '||p_customer_id );

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

1041: APP_EXCEPTION.raise_exception;
1042: END IF;
1043: --
1044: IF PG_DEBUG in ('Y', 'C') THEN
1045: arp_util.debug( 'arp_rw_icr_pkg.check_unique_receipt()-' );
1046: END IF;
1047: --
1048: EXCEPTION
1049: WHEN OTHERS THEN

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

1048: EXCEPTION
1049: WHEN OTHERS THEN
1050: IF PG_DEBUG in ('Y', 'C') THEN
1051: arp_util.debug(
1052: 'EXCEPTION: arp_rw_icr_pkg.check_unique_receipt' );
1053: END IF;
1054: RAISE;
1055: END check_unique_receipt;
1056: --

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

1085: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
1086: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE ) IS
1087: BEGIN
1088: IF PG_DEBUG in ('Y', 'C') THEN
1089: arp_util.debug( 'arp_rw_icr_pkg.val_args_check_unique_receipt()+' );
1090: END IF;
1091: --
1092: --
1093: -- Note: Special type can be NULL

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

1102: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );
1103: APP_EXCEPTION.raise_exception;
1104: END IF;
1105: IF PG_DEBUG in ('Y', 'C') THEN
1106: arp_util.debug( 'arp_rw_icr_pkg.val_args_check_unique_receipt()-' );
1107: END IF;
1108: --
1109: EXCEPTION
1110: WHEN OTHERS THEN

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

1109: EXCEPTION
1110: WHEN OTHERS THEN
1111: IF PG_DEBUG in ('Y', 'C') THEN
1112: arp_util.debug('val_args_check_unique_receipt: ' ||
1113: 'EXCEPTION: arp_rw_icr_pkg.val_args_check_unique_receipt' );
1114: END IF;
1115: RAISE;
1116: END val_args_check_unique_receipt;
1117: --

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

1148: l_count NUMBER;
1149: BEGIN
1150: --
1151: IF PG_DEBUG in ('Y', 'C') THEN
1152: arp_util.debug( 'arp_rw_icr_pkg.lines_exists()+' );
1153: END IF;
1154: --
1155: -- Do argument validation, Note: No separate procedure used
1156: --

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

1172: RETURN TRUE;
1173: END IF;
1174: --
1175: IF PG_DEBUG in ('Y', 'C') THEN
1176: arp_util.debug( 'arp_rw_icr_pkg.lines_exists()-' );
1177: END IF;
1178: --
1179: EXCEPTION
1180: WHEN OTHERS THEN

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

1179: EXCEPTION
1180: WHEN OTHERS THEN
1181: IF PG_DEBUG in ('Y', 'C') THEN
1182: arp_util.debug('lines_exists: ' ||
1183: 'EXCEPTION: arp_rw_icr_pkg.lines_exists' );
1184: END IF;
1185: RAISE;
1186: END lines_exists;
1187: --

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

1216: p_module_name IN VARCHAR2,
1217: p_module_version IN VARCHAR2 ) IS
1218: BEGIN
1219: IF PG_DEBUG in ('Y', 'C') THEN
1220: arp_util.debug( 'arp_rw_icr_pkg.check_no_lines_exists()-' );
1221: END IF;
1222: --
1223: -- Do argument validation, Note: No separate procedure used
1224: --

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

1228: APP_EXCEPTION.raise_exception;
1229: END IF;
1230: END IF;
1231: --
1232: IF ( arp_rw_icr_pkg.lines_exists( p_cr_id, NULL, NULL ) = TRUE ) THEN
1233: FND_MESSAGE.set_name( 'AR', 'AR_UPDNA_APP_TYPE' );
1234: APP_EXCEPTION.raise_exception;
1235: END IF;
1236: --

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

1234: APP_EXCEPTION.raise_exception;
1235: END IF;
1236: --
1237: IF PG_DEBUG in ('Y', 'C') THEN
1238: arp_util.debug( 'arp_rw_icr_pkg.check_no_lines_exists()-' );
1239: END IF;
1240: --
1241: EXCEPTION
1242: WHEN OTHERS THEN

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

1241: EXCEPTION
1242: WHEN OTHERS THEN
1243: IF PG_DEBUG in ('Y', 'C') THEN
1244: arp_util.debug('check_no_lines_exists: ' ||
1245: 'EXCEPTION: arp_rw_icr_pkg.check_no_lines_exists' );
1246: END IF;
1247: RAISE;
1248: END check_no_lines_exists;
1249: --

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

1274: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
1275: p_bank_account_id IN ar_batches.remit_bank_acct_use_id%TYPE ) IS
1276: BEGIN
1277: IF PG_DEBUG in ('Y', 'C') THEN
1278: arp_util.debug( 'arp_rw_icr_pkg.update_bank_account_uses()+' );
1279: arp_util.debug('update_bank_account_uses: ' || 'Customer ID : '||p_customer_id );
1280: arp_util.debug('update_bank_account_uses: ' || 'Bank Account Id : '||p_bank_account_id );
1281: END IF;
1282: --

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

1280: arp_util.debug('update_bank_account_uses: ' || 'Bank Account Id : '||p_bank_account_id );
1281: END IF;
1282: --
1283: IF PG_DEBUG in ('Y', 'C') THEN
1284: arp_util.debug( 'arp_rw_icr_pkg.update_bank_account_uses()-' );
1285: END IF;
1286: --
1287: END update_bank_account_uses;
1288: --

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

1321: p_module_name IN VARCHAR2,
1322: p_module_version IN VARCHAR2 ) IS
1323: BEGIN
1324: IF PG_DEBUG in ('Y', 'C') THEN
1325: arp_util.debug( 'arp_rw_icr_pkg.delete_row()+' );
1326: END IF;
1327: --
1328: IF ( p_module_name IS NOT NULL AND p_module_version IS NOT NULL ) THEN
1329: IF ( p_cr_id is NULL OR p_row_id IS NULL ) THEN

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

1337: arp_cr_icr_lines_pkg.delete_fk( p_cr_id );
1338: arp_cr_icr_pkg.delete_p( p_cr_id );
1339: --
1340: IF PG_DEBUG in ('Y', 'C') THEN
1341: arp_util.debug( 'arp_rw_icr_pkg.delete_row()-' );
1342: END IF;
1343: --
1344: EXCEPTION
1345: WHEN OTHERS THEN

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

1344: EXCEPTION
1345: WHEN OTHERS THEN
1346: IF PG_DEBUG in ('Y', 'C') THEN
1347: arp_util.debug('delete_row: ' ||
1348: 'EXCEPTION: arp_rw_icr_pkg.delete_row' );
1349: END IF;
1350: RAISE;
1351: END delete_row;
1352: --

Line 1577: END ARP_RW_ICR_PKG;

1573: APP_EXCEPTION.Raise_Exception;
1574: end if;
1575: END lock_row;
1576: --
1577: END ARP_RW_ICR_PKG;