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.30.12020000.2 2012/07/28 00:45:15 dgaurab ship $*/
3: --
4: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
5:

Line 96: arp_debug.debug( '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_debug.debug( 'arp_ps_util.update_reverse_actions()+' );
97: arp_debug.debug( ' p_app_rec.trx_type = ' || p_app_rec.trx_type );
98: END IF;
99:
100: --

Line 251: arp_debug.debug( 'arp_ps_util.update_reverse_actions()-' );

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

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

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

Line 288: arp_debug.debug( 'arp_ps_util.val_update_rev_actions()+' );

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

Line 296: arp_debug.debug( 'arp_ps_util.val_update_rev_actions()-' );

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

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

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

Line 385: arp_debug.debug( 'arp_ps_util.update_receipt_related_columns()+' );

381:
382: BEGIN
383: IF PG_DEBUG IN ('Y','C')
384: THEN
385: arp_debug.debug( 'arp_ps_util.update_receipt_related_columns()+' );
386: arp_debug.debug( 'PS ID : '||p_ps_id );
387: arp_debug.debug( 'Amount Applied : '||p_amount_applied );
388: arp_debug.debug( 'Apply Date : '||TO_CHAR( p_apply_date ) );
389: arp_debug.debug( 'GL Date : '||TO_CHAR( p_gl_date ) );

Line 444: arp_util.debug( 'arp_ps_util.update_receipt_related_columns : Prev applications exists.' );

440: and ra.payment_schedule_id=p_ps_id
441: and ra.payment_schedule_id = ps.payment_schedule_id
442: and ps.class='PMT' and ra.application_rule <> '60.2';
443:
444: arp_util.debug( 'arp_ps_util.update_receipt_related_columns : Prev applications exists.' );
445: --6924942 :- As in point 1 above
446:
447: Base_amt_due_rem := l_ps_rec.amount_due_remaining + current_amt_app;
448: Base_acctd_amt_due_rem := l_ps_rec.acctd_amount_due_remaining + current_acctd_amt_app;

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

510: p_acctd_amount_applied := l_acctd_amount_applied;
511: --
512: -- Set the closed dates and status of PS record
513: --
514: arp_ps_util.populate_closed_dates( p_gl_date, p_apply_date, 'PMT', l_ps_rec );
515: --
516: -- Update other PS columns
517: -- Note: Amount applied added is negative of receipt amount
518: -- In reality p_amount_applied will never be NULL at this stage

Line 567: arp_debug.debug( 'arp_ps_util.update_receipt_related_columns()-' );

563: END IF ;
564:
565: IF PG_DEBUG in ('Y','C')
566: THEN
567: arp_debug.debug( 'arp_ps_util.update_receipt_related_columns()-' );
568: END IF;
569:
570: EXCEPTION
571: WHEN OTHERS THEN

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

569:
570: EXCEPTION
571: WHEN OTHERS THEN
572: arp_debug.debug(
573: 'EXCEPTION: arp_ps_util.update_receipt_related_columns' );
574: RAISE;
575: END;
576: --
577: /*===========================================================================+

Line 605: arp_debug.debug( 'arp_ps_util.validate_args_upd_rel_cols()+' );

601: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
602: p_gl_date IN ar_payment_schedules.gl_date%TYPE ) IS
603: BEGIN
604: IF PG_DEBUG in ('Y', 'C') THEN
605: arp_debug.debug( 'arp_ps_util.validate_args_upd_rel_cols()+' );
606: END IF;
607: --
608: IF ( p_amount_applied IS NULL OR p_ps_id IS NULL OR
609: p_apply_date IS NULL OR p_gl_date IS NULL ) THEN

Line 615: arp_debug.debug( 'arp_ps_util.validate_args_upd_rel_cols()-' );

611: APP_EXCEPTION.raise_exception;
612: END IF;
613: --
614: IF PG_DEBUG in ('Y', 'C') THEN
615: arp_debug.debug( 'arp_ps_util.validate_args_upd_rel_cols()-' );
616: END IF;
617: EXCEPTION
618: WHEN OTHERS THEN
619: IF PG_DEBUG in ('Y', 'C') THEN

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

617: EXCEPTION
618: WHEN OTHERS THEN
619: IF PG_DEBUG in ('Y', 'C') THEN
620: arp_debug.debug('validate_args_upd_rel_cols: ' ||
621: 'EXCEPTION: arp_ps_util.validate_args_upd_rel_cols' );
622: END IF;
623: RAISE;
624: END validate_args_upd_rel_cols;
625:

Line 936: arp_debug.debug( 'arp_ps_util.update_invoice_related_columns()+' );

932: l_ebt_ra_app_id NUMBER;
933:
934: BEGIN
935: IF PG_DEBUG in ('Y', 'C') THEN
936: arp_debug.debug( 'arp_ps_util.update_invoice_related_columns()+' );
937: END IF;
938: --
939: IF PG_DEBUG in ('Y', 'C') THEN
940: arp_debug.debug( 'PS ID : '||p_ps_id );

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

1306: -- Set the closed dates and status of PS record
1307: --
1308: /* 18-MAY-2000 J Rautiainen BR Implementation
1309: * Modified to pass the class instead of 'INV' since the class can be either 'BR' or 'INV' */
1310: arp_ps_util.populate_closed_dates( p_gl_date, p_apply_date, l_ps_rec.class, l_ps_rec );
1311: --
1312: -- Update PS record
1313: --
1314: /* Bug 5569488, do not update payment schedule if the receipt requires

Line 1355: arp_debug.debug( 'arp_ps_util.update_invoice_related_columns()-' );

1351: --
1352: -- Bug 13543605, Re-setting the value of arp_util.PG_OVERAPP_ALLOW_FLAG.
1353: arp_util.PG_OVERAPP_ALLOW_FLAG := NULL;
1354: IF PG_DEBUG in ('Y', 'C') THEN
1355: arp_debug.debug( 'arp_ps_util.update_invoice_related_columns()-' );
1356: END IF;
1357: --
1358: EXCEPTION
1359: WHEN OTHERS THEN

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

1358: EXCEPTION
1359: WHEN OTHERS THEN
1360: IF PG_DEBUG in ('Y', 'C') THEN
1361: arp_debug.debug(
1362: 'EXCEPTION: arp_ps_util.update_invoice_related_columns' );
1363: END IF;
1364: arp_util.PG_OVERAPP_ALLOW_FLAG := NULL;
1365: RAISE;
1366: END update_invoice_related_columns;

Line 1402: arp_debug.debug( 'arp_ps_util.validate_args_upd_inv_rel_cols()+' );

1398: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
1399: p_gl_date IN ar_payment_schedules.gl_date%TYPE ) IS
1400: BEGIN
1401: IF PG_DEBUG in ('Y', 'C') THEN
1402: arp_debug.debug( 'arp_ps_util.validate_args_upd_inv_rel_cols()+' );
1403: END IF;
1404: --
1405: IF ( p_ps_id IS NULL OR p_apply_date IS NULL OR p_gl_date IS NULL ) THEN
1406: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );

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

1421: EXCEPTION
1422: WHEN OTHERS THEN
1423: IF PG_DEBUG in ('Y', 'C') THEN
1424: arp_debug.debug('validate_args_upd_inv_rel_cols: ' ||
1425: 'EXCEPTION: arp_ps_util.validate_args_upd_inv_rel_cols' );
1426: END IF;
1427: RAISE;
1428: END validate_args_upd_inv_rel_cols;
1429: --

Line 1514: arp_debug.debug( 'arp_ps_util.update_cm_related_columns()+' );

1510: ar_payment_schedules.acctd_amount_due_remaining%TYPE;
1511:
1512: BEGIN
1513: IF PG_DEBUG in ('Y', 'C') THEN
1514: arp_debug.debug( 'arp_ps_util.update_cm_related_columns()+' );
1515: END IF;
1516: --
1517: IF PG_DEBUG in ('Y', 'C') THEN
1518: arp_debug.debug( 'PS ID : '||p_ps_id );

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

1595:
1596: --
1597: -- Set the closed dates and status of PS record
1598: --
1599: arp_ps_util.populate_closed_dates( p_gl_date, p_apply_date, 'CM', l_ps_rec );
1600: --
1601: -- Update PS record
1602: --
1603: arp_ps_pkg.update_p( l_ps_rec );

Line 1606: arp_debug.debug( 'arp_ps_util.update_cm_related_columns()-' );

1602: --
1603: arp_ps_pkg.update_p( l_ps_rec );
1604: --
1605: IF PG_DEBUG in ('Y', 'C') THEN
1606: arp_debug.debug( 'arp_ps_util.update_cm_related_columns()-' );
1607: END IF;
1608: --
1609: EXCEPTION
1610: WHEN OTHERS THEN

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

1609: EXCEPTION
1610: WHEN OTHERS THEN
1611: IF PG_DEBUG in ('Y', 'C') THEN
1612: arp_debug.debug(
1613: 'EXCEPTION: arp_ps_util.update_cm_related_columns' );
1614: END IF;
1615: RAISE;
1616: END update_cm_related_columns;
1617: --

Line 1722: arp_debug.debug( 'arp_ps_util.update_adj_related_columns()+' );

1718: rem_adj_amt NUMBER;
1719:
1720: BEGIN
1721: IF PG_DEBUG in ('Y', 'C') THEN
1722: arp_debug.debug( 'arp_ps_util.update_adj_related_columns()+' );
1723: END IF;
1724: --
1725: IF PG_DEBUG in ('Y', 'C') THEN
1726: arp_debug.debug( 'PS ID : '||p_ps_id );

Line 1981: arp_debug.debug( 'arp_ps_util.update_adj_related_columns()-' );

1977: --ajay assigning back the value to p_ps_rec as it has been made a IN OUT
1978: p_ps_rec := l_ps_rec;
1979: --
1980: IF PG_DEBUG in ('Y', 'C') THEN
1981: arp_debug.debug( 'arp_ps_util.update_adj_related_columns()-' );
1982: END IF;
1983: --
1984: EXCEPTION
1985: WHEN OTHERS THEN

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

1984: EXCEPTION
1985: WHEN OTHERS THEN
1986: IF PG_DEBUG in ('Y', 'C') THEN
1987: arp_debug.debug(
1988: 'EXCEPTION: arp_ps_util.update_adj_related_columns' );
1989: END IF;
1990: RAISE;
1991: END update_adj_related_columns;
1992: --

Line 2019: arp_debug.debug( 'arp_ps_util.validate_args_upd_adj_rel_cols()+' );

2015: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
2016: p_gl_date IN ar_payment_schedules.gl_date%TYPE ) IS
2017: BEGIN
2018: IF PG_DEBUG in ('Y', 'C') THEN
2019: arp_debug.debug( 'arp_ps_util.validate_args_upd_adj_rel_cols()+' );
2020: END IF;
2021: --
2022: IF ( p_ps_id IS NULL OR p_apply_date IS NULL OR p_gl_date IS NULL ) THEN
2023: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );

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

2030: EXCEPTION
2031: WHEN OTHERS THEN
2032: IF PG_DEBUG in ('Y', 'C') THEN
2033: arp_debug.debug(
2034: 'EXCEPTION: arp_ps_util.validate_args_upd_adj_rel_cols' );
2035: END IF;
2036: RAISE;
2037: END validate_args_upd_adj_rel_cols;
2038: --

Line 2110: arp_debug.debug( 'arp_ps_util.update_adj_related_columns()+' );

2106: ar_payment_schedules.acctd_amount_due_remaining%TYPE;
2107:
2108: BEGIN
2109: IF PG_DEBUG in ('Y', 'C') THEN
2110: arp_debug.debug( 'arp_ps_util.update_adj_related_columns()+' );
2111: END IF;
2112: --
2113: IF PG_DEBUG in ('Y', 'C') THEN
2114: arp_debug.debug( 'PS ID : '||p_ps_id );

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

2203: END IF;
2204: --
2205: -- Set the closed dates and status of PS record
2206: --
2207: arp_ps_util.populate_closed_dates( p_gl_date, p_apply_date, 'ADJ', l_ps_rec );
2208: --
2209: -- Update PS record
2210: --
2211: arp_ps_pkg.update_p( l_ps_rec );

Line 2218: arp_debug.debug( 'arp_ps_util.update_adj_related_columns()-' );

2214: --ajay assigning back the value to p_ps_rec as it has been made a IN OUT
2215: p_ps_rec := l_ps_rec;
2216:
2217: IF PG_DEBUG in ('Y', 'C') THEN
2218: arp_debug.debug( 'arp_ps_util.update_adj_related_columns()-' );
2219: END IF;
2220: --
2221: EXCEPTION
2222: WHEN OTHERS THEN

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

2221: EXCEPTION
2222: WHEN OTHERS THEN
2223: IF PG_DEBUG in ('Y', 'C') THEN
2224: arp_debug.debug(
2225: 'EXCEPTION: arp_ps_util.update_adj_related_columns' );
2226: END IF;
2227: RAISE;
2228: END update_adj_related_columns;
2229: --

Line 2275: arp_debug.debug( 'arp_ps_util.validate_args_upd_adj_rel_cols()+' );

2271: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
2272: p_gl_date IN ar_payment_schedules.gl_date%TYPE ) IS
2273: BEGIN
2274: IF PG_DEBUG in ('Y', 'C') THEN
2275: arp_debug.debug( 'arp_ps_util.validate_args_upd_adj_rel_cols()+' );
2276: END IF;
2277: --
2278: IF ( p_ps_id IS NULL OR p_apply_date IS NULL OR p_gl_date IS NULL ) THEN
2279: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );

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

2295: EXCEPTION
2296: WHEN OTHERS THEN
2297: IF PG_DEBUG in ('Y', 'C') THEN
2298: arp_debug.debug('validate_args_upd_adj_rel_cols: ' ||
2299: 'EXCEPTION: arp_ps_util.validate_args_upd_adj_rel_cols' );
2300: END IF;
2301: RAISE;
2302: END validate_args_upd_adj_rel_cols;
2303: --

Line 2354: arp_ps_util.get_closed_dates( p_ps_rec.payment_schedule_id,

2350: IF ( p_ps_rec.amount_due_remaining = 0 ) THEN
2351: --
2352: -- Get gl closing dates
2353: --
2354: arp_ps_util.get_closed_dates( p_ps_rec.payment_schedule_id,
2355: p_gl_date, p_apply_date,
2356: l_gl_date_closed, l_actual_date_closed,
2357: p_app_type );
2358: --

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

2379: EXCEPTION
2380: WHEN OTHERS THEN
2381: IF PG_DEBUG in ('Y', 'C') THEN
2382: arp_debug.debug('populate_closed_dates: ' ||
2383: 'EXCEPTION: arp_ps_util.populate_closed_dates' );
2384: END IF;
2385: RAISE;
2386: END populate_closed_dates;
2387:

Line 2533: END ARP_PS_UTIL;

2529: END IF;
2530: RAISE;
2531: END get_closed_dates;
2532: --
2533: END ARP_PS_UTIL;