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_PS_UTIL dependencies on ARP_PS_UTIL

Line 1: PACKAGE BODY ARP_PS_UTIL AS

1: PACKAGE BODY ARP_PS_UTIL AS
2: /* $Header: ARCUPSB.pls 120.27 2007/02/22 13:53:46 nemani ship $*/
3: --
4: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
5:

Line 96: arp_util.debug('val_update_rev_actions: ' || 'arp_ps_util.update_reverse_actions()+' );

92: l_ps_rec ar_payment_schedules%ROWTYPE;
93:
94: BEGIN
95: IF PG_DEBUG in ('Y', 'C') THEN
96: arp_util.debug('val_update_rev_actions: ' || 'arp_ps_util.update_reverse_actions()+' );
97: arp_util.debug('val_update_rev_actions: ' || 'What is the type?' );
98: arp_util.debug('val_update_rev_actions: ' || 'p_app_rec.trx_type = ' || p_app_rec.trx_type );
99: END IF;
100:

Line 252: arp_util.debug('val_update_rev_actions: ' || 'arp_ps_util.update_reverse_actions()-' );

248:
249: arp_ps_pkg.update_p( l_ps_rec );
250:
251: IF PG_DEBUG in ('Y', 'C') THEN
252: arp_util.debug('val_update_rev_actions: ' || 'arp_ps_util.update_reverse_actions()-' );
253: END IF;
254: EXCEPTION
255: WHEN OTHERS THEN
256: IF PG_DEBUG in ('Y', 'C') THEN

Line 258: 'EXCEPTION: arp_ps_util.update_reverse_actions' );

254: EXCEPTION
255: WHEN OTHERS THEN
256: IF PG_DEBUG in ('Y', 'C') THEN
257: arp_util.debug('val_update_rev_actions: ' ||
258: 'EXCEPTION: arp_ps_util.update_reverse_actions' );
259: END IF;
260: RAISE;
261: END update_reverse_actions;
262: --

Line 289: arp_util.debug( 'arp_ps_util.val_update_rev_actions()+' );

285: +===========================================================================*/
286: PROCEDURE val_update_rev_actions( p_ps_id IN NUMBER ) IS
287: BEGIN
288: IF PG_DEBUG in ('Y', 'C') THEN
289: arp_util.debug( 'arp_ps_util.val_update_rev_actions()+' );
290: END IF;
291: IF ( p_ps_id IS NULL ) THEN
292: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );
293: APP_EXCEPTION.raise_exception;

Line 297: arp_util.debug( 'arp_ps_util.val_update_rev_actions()-' );

293: APP_EXCEPTION.raise_exception;
294: END IF;
295: --
296: IF PG_DEBUG in ('Y', 'C') THEN
297: arp_util.debug( 'arp_ps_util.val_update_rev_actions()-' );
298: END IF;
299: EXCEPTION
300: WHEN OTHERS THEN
301: IF PG_DEBUG in ('Y', 'C') THEN

Line 303: 'EXCEPTION: arp_ps_util.val_update_rev_actions' );

299: EXCEPTION
300: WHEN OTHERS THEN
301: IF PG_DEBUG in ('Y', 'C') THEN
302: arp_util.debug('val_update_rev_actions: ' ||
303: 'EXCEPTION: arp_ps_util.val_update_rev_actions' );
304: END IF;
305: RAISE;
306: END val_update_rev_actions;
307: --

Line 368: arp_util.debug( 'arp_ps_util.update_receipt_related_columns()+' );

364: l_nocopy_acctd_amt_due_remain
365: ar_payment_schedules.acctd_amount_due_remaining%TYPE;
366:
367: BEGIN
368: arp_util.debug( 'arp_ps_util.update_receipt_related_columns()+' );
369: --
370: arp_util.debug( 'PS ID : '||p_ps_id );
371: arp_util.debug( 'Amount Applied : '||p_amount_applied );
372: arp_util.debug( 'Apply Date : '||TO_CHAR( p_apply_date ) );

Line 414: arp_ps_util.populate_closed_dates( p_gl_date, p_apply_date, 'PMT', l_ps_rec );

410: p_acctd_amount_applied := l_acctd_amount_applied;
411: --
412: -- Set the closed dates and status of PS record
413: --
414: arp_ps_util.populate_closed_dates( p_gl_date, p_apply_date, 'PMT', l_ps_rec );
415: --
416: -- Update other PS columns
417: -- Note: Amount applied added is negative of receipt amount
418: -- In reality p_amount_applied will never be NULL at this stage

Line 463: arp_util.debug( 'arp_ps_util.update_receipt_related_columns()-' );

459: NULL, l_ps_rec.program_update_date,SYSDATE)
460: where
461: payment_schedule_id = l_ps_rec.payment_schedule_id;
462: END IF ;
463: arp_util.debug( 'arp_ps_util.update_receipt_related_columns()-' );
464: --
465: EXCEPTION
466: WHEN OTHERS THEN
467: arp_util.debug(

Line 468: 'EXCEPTION: arp_ps_util.update_receipt_related_columns' );

464: --
465: EXCEPTION
466: WHEN OTHERS THEN
467: arp_util.debug(
468: 'EXCEPTION: arp_ps_util.update_receipt_related_columns' );
469: RAISE;
470: END;
471: --
472: /*===========================================================================+

Line 500: arp_util.debug( 'arp_ps_util.validate_args_upd_rel_cols()+' );

496: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
497: p_gl_date IN ar_payment_schedules.gl_date%TYPE ) IS
498: BEGIN
499: IF PG_DEBUG in ('Y', 'C') THEN
500: arp_util.debug( 'arp_ps_util.validate_args_upd_rel_cols()+' );
501: END IF;
502: --
503: IF ( p_amount_applied IS NULL OR p_ps_id IS NULL OR
504: p_apply_date IS NULL OR p_gl_date IS NULL ) THEN

Line 510: arp_util.debug( 'arp_ps_util.validate_args_upd_rel_cols()-' );

506: APP_EXCEPTION.raise_exception;
507: END IF;
508: --
509: IF PG_DEBUG in ('Y', 'C') THEN
510: arp_util.debug( 'arp_ps_util.validate_args_upd_rel_cols()-' );
511: END IF;
512: EXCEPTION
513: WHEN OTHERS THEN
514: IF PG_DEBUG in ('Y', 'C') THEN

Line 516: 'EXCEPTION: arp_ps_util.validate_args_upd_rel_cols' );

512: EXCEPTION
513: WHEN OTHERS THEN
514: IF PG_DEBUG in ('Y', 'C') THEN
515: arp_util.debug('validate_args_upd_rel_cols: ' ||
516: 'EXCEPTION: arp_ps_util.validate_args_upd_rel_cols' );
517: END IF;
518: RAISE;
519: END validate_args_upd_rel_cols;
520:

Line 831: arp_util.debug( 'arp_ps_util.update_invoice_related_columns()+' );

827: l_ebt_ra_app_id NUMBER;
828:
829: BEGIN
830: IF PG_DEBUG in ('Y', 'C') THEN
831: arp_util.debug( 'arp_ps_util.update_invoice_related_columns()+' );
832: END IF;
833: --
834: IF PG_DEBUG in ('Y', 'C') THEN
835: arp_util.debug( 'PS ID : '||p_ps_id );

Line 1183: arp_ps_util.populate_closed_dates( p_gl_date, p_apply_date, l_ps_rec.class, l_ps_rec );

1179: -- Set the closed dates and status of PS record
1180: --
1181: /* 18-MAY-2000 J Rautiainen BR Implementation
1182: * Modified to pass the class instead of 'INV' since the class can be either 'BR' or 'INV' */
1183: arp_ps_util.populate_closed_dates( p_gl_date, p_apply_date, l_ps_rec.class, l_ps_rec );
1184: --
1185: -- Update PS record
1186: --
1187: /* Bug 5569488, do not update payment schedule if the receipt requires

Line 1226: arp_util.debug( 'arp_ps_util.update_invoice_related_columns()-' );

1222: p_gt_id := l_ebt_gt_id;
1223:
1224: --
1225: IF PG_DEBUG in ('Y', 'C') THEN
1226: arp_util.debug( 'arp_ps_util.update_invoice_related_columns()-' );
1227: END IF;
1228: --
1229: EXCEPTION
1230: WHEN OTHERS THEN

Line 1233: 'EXCEPTION: arp_ps_util.update_invoice_related_columns' );

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

Line 1272: arp_util.debug( 'arp_ps_util.validate_args_upd_inv_rel_cols()+' );

1268: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
1269: p_gl_date IN ar_payment_schedules.gl_date%TYPE ) IS
1270: BEGIN
1271: IF PG_DEBUG in ('Y', 'C') THEN
1272: arp_util.debug( 'arp_ps_util.validate_args_upd_inv_rel_cols()+' );
1273: END IF;
1274: --
1275: IF ( p_ps_id IS NULL OR p_apply_date IS NULL OR p_gl_date IS NULL ) THEN
1276: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );

Line 1295: 'EXCEPTION: arp_ps_util.validate_args_upd_inv_rel_cols' );

1291: EXCEPTION
1292: WHEN OTHERS THEN
1293: IF PG_DEBUG in ('Y', 'C') THEN
1294: arp_util.debug('validate_args_upd_inv_rel_cols: ' ||
1295: 'EXCEPTION: arp_ps_util.validate_args_upd_inv_rel_cols' );
1296: END IF;
1297: RAISE;
1298: END validate_args_upd_inv_rel_cols;
1299: --

Line 1384: arp_util.debug( 'arp_ps_util.update_cm_related_columns()+' );

1380: ar_payment_schedules.acctd_amount_due_remaining%TYPE;
1381:
1382: BEGIN
1383: IF PG_DEBUG in ('Y', 'C') THEN
1384: arp_util.debug( 'arp_ps_util.update_cm_related_columns()+' );
1385: END IF;
1386: --
1387: IF PG_DEBUG in ('Y', 'C') THEN
1388: arp_util.debug('update_cm_related_columns: ' || 'PS ID : '||p_ps_id );

Line 1469: arp_ps_util.populate_closed_dates( p_gl_date, p_apply_date, 'CM', l_ps_rec );

1465:
1466: --
1467: -- Set the closed dates and status of PS record
1468: --
1469: arp_ps_util.populate_closed_dates( p_gl_date, p_apply_date, 'CM', l_ps_rec );
1470: --
1471: -- Update PS record
1472: --
1473: arp_ps_pkg.update_p( l_ps_rec );

Line 1476: arp_util.debug( 'arp_ps_util.update_cm_related_columns()-' );

1472: --
1473: arp_ps_pkg.update_p( l_ps_rec );
1474: --
1475: IF PG_DEBUG in ('Y', 'C') THEN
1476: arp_util.debug( 'arp_ps_util.update_cm_related_columns()-' );
1477: END IF;
1478: --
1479: EXCEPTION
1480: WHEN OTHERS THEN

Line 1483: 'EXCEPTION: arp_ps_util.update_cm_related_columns' );

1479: EXCEPTION
1480: WHEN OTHERS THEN
1481: IF PG_DEBUG in ('Y', 'C') THEN
1482: arp_util.debug('update_cm_related_columns: ' ||
1483: 'EXCEPTION: arp_ps_util.update_cm_related_columns' );
1484: END IF;
1485: RAISE;
1486: END update_cm_related_columns;
1487: --

Line 1592: arp_util.debug( 'arp_ps_util.update_adj_related_columns()+' );

1588: rem_adj_amt NUMBER;
1589:
1590: BEGIN
1591: IF PG_DEBUG in ('Y', 'C') THEN
1592: arp_util.debug( 'arp_ps_util.update_adj_related_columns()+' );
1593: END IF;
1594: --
1595: IF PG_DEBUG in ('Y', 'C') THEN
1596: arp_util.debug('update_adj_related_columns: ' || 'PS ID : '||p_ps_id );

Line 1851: arp_util.debug( 'arp_ps_util.update_adj_related_columns()-' );

1847: --ajay assigning back the value to p_ps_rec as it has been made a IN OUT
1848: p_ps_rec := l_ps_rec;
1849: --
1850: IF PG_DEBUG in ('Y', 'C') THEN
1851: arp_util.debug( 'arp_ps_util.update_adj_related_columns()-' );
1852: END IF;
1853: --
1854: EXCEPTION
1855: WHEN OTHERS THEN

Line 1858: 'EXCEPTION: arp_ps_util.update_adj_related_columns' );

1854: EXCEPTION
1855: WHEN OTHERS THEN
1856: IF PG_DEBUG in ('Y', 'C') THEN
1857: arp_util.debug('update_adj_related_columns: ' ||
1858: 'EXCEPTION: arp_ps_util.update_adj_related_columns' );
1859: END IF;
1860: RAISE;
1861: END update_adj_related_columns;
1862: --

Line 1889: arp_util.debug('update_adj_related_columns: ' || 'arp_ps_util.validate_args_upd_adj_rel_cols()+' );

1885: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
1886: p_gl_date IN ar_payment_schedules.gl_date%TYPE ) IS
1887: BEGIN
1888: IF PG_DEBUG in ('Y', 'C') THEN
1889: arp_util.debug('update_adj_related_columns: ' || 'arp_ps_util.validate_args_upd_adj_rel_cols()+' );
1890: END IF;
1891: --
1892: IF ( p_ps_id IS NULL OR p_apply_date IS NULL OR p_gl_date IS NULL ) THEN
1893: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );

Line 1904: 'EXCEPTION: arp_ps_util.validate_args_upd_adj_rel_cols' );

1900: EXCEPTION
1901: WHEN OTHERS THEN
1902: IF PG_DEBUG in ('Y', 'C') THEN
1903: arp_util.debug('update_adj_related_columns: ' ||
1904: 'EXCEPTION: arp_ps_util.validate_args_upd_adj_rel_cols' );
1905: END IF;
1906: RAISE;
1907: END validate_args_upd_adj_rel_cols;
1908: --

Line 1980: arp_util.debug( 'arp_ps_util.update_adj_related_columns()+' );

1976: ar_payment_schedules.acctd_amount_due_remaining%TYPE;
1977:
1978: BEGIN
1979: IF PG_DEBUG in ('Y', 'C') THEN
1980: arp_util.debug( 'arp_ps_util.update_adj_related_columns()+' );
1981: END IF;
1982: --
1983: IF PG_DEBUG in ('Y', 'C') THEN
1984: arp_util.debug('update_adj_related_columns: ' || 'PS ID : '||p_ps_id );

Line 2077: arp_ps_util.populate_closed_dates( p_gl_date, p_apply_date, 'ADJ', l_ps_rec );

2073: END IF;
2074: --
2075: -- Set the closed dates and status of PS record
2076: --
2077: arp_ps_util.populate_closed_dates( p_gl_date, p_apply_date, 'ADJ', l_ps_rec );
2078: --
2079: -- Update PS record
2080: --
2081: arp_ps_pkg.update_p( l_ps_rec );

Line 2088: arp_util.debug( 'arp_ps_util.update_adj_related_columns()-' );

2084: --ajay assigning back the value to p_ps_rec as it has been made a IN OUT
2085: p_ps_rec := l_ps_rec;
2086:
2087: IF PG_DEBUG in ('Y', 'C') THEN
2088: arp_util.debug( 'arp_ps_util.update_adj_related_columns()-' );
2089: END IF;
2090: --
2091: EXCEPTION
2092: WHEN OTHERS THEN

Line 2095: 'EXCEPTION: arp_ps_util.update_adj_related_columns' );

2091: EXCEPTION
2092: WHEN OTHERS THEN
2093: IF PG_DEBUG in ('Y', 'C') THEN
2094: arp_util.debug('update_adj_related_columns: ' ||
2095: 'EXCEPTION: arp_ps_util.update_adj_related_columns' );
2096: END IF;
2097: RAISE;
2098: END update_adj_related_columns;
2099: --

Line 2145: arp_util.debug( 'arp_ps_util.validate_args_upd_adj_rel_cols()+' );

2141: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
2142: p_gl_date IN ar_payment_schedules.gl_date%TYPE ) IS
2143: BEGIN
2144: IF PG_DEBUG in ('Y', 'C') THEN
2145: arp_util.debug( 'arp_ps_util.validate_args_upd_adj_rel_cols()+' );
2146: END IF;
2147: --
2148: IF ( p_ps_id IS NULL OR p_apply_date IS NULL OR p_gl_date IS NULL ) THEN
2149: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );

Line 2169: 'EXCEPTION: arp_ps_util.validate_args_upd_adj_rel_cols' );

2165: EXCEPTION
2166: WHEN OTHERS THEN
2167: IF PG_DEBUG in ('Y', 'C') THEN
2168: arp_util.debug('validate_args_upd_adj_rel_cols: ' ||
2169: 'EXCEPTION: arp_ps_util.validate_args_upd_adj_rel_cols' );
2170: END IF;
2171: RAISE;
2172: END validate_args_upd_adj_rel_cols;
2173: --

Line 2224: arp_ps_util.get_closed_dates( p_ps_rec.payment_schedule_id,

2220: IF ( p_ps_rec.amount_due_remaining = 0 ) THEN
2221: --
2222: -- Get gl closing dates
2223: --
2224: arp_ps_util.get_closed_dates( p_ps_rec.payment_schedule_id,
2225: p_gl_date, p_apply_date,
2226: l_gl_date_closed, l_actual_date_closed,
2227: p_app_type );
2228: --

Line 2253: 'EXCEPTION: arp_ps_util.populate_closed_dates' );

2249: EXCEPTION
2250: WHEN OTHERS THEN
2251: IF PG_DEBUG in ('Y', 'C') THEN
2252: arp_util.debug('populate_closed_dates: ' ||
2253: 'EXCEPTION: arp_ps_util.populate_closed_dates' );
2254: END IF;
2255: RAISE;
2256: END populate_closed_dates;
2257:

Line 2403: END ARP_PS_UTIL;

2399: END IF;
2400: RAISE;
2401: END get_closed_dates;
2402: --
2403: END ARP_PS_UTIL;