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_UTIL

Line 335: | arp_util.calc_acctd_amount and arp_debug.debug |

331: | OUT NOCOPY : p_acctd_amount_applied_out - Accounted amount applied used to|
332: | populate acctd_amount_applied_from in AR_RA table |
333: | |
334: | EXTERNAL PROCEDURES/FUNCTION |
335: | arp_util.calc_acctd_amount and arp_debug.debug |
336: | arp_ps_pkg.fetch_p and arp_ps_pkg.update_p |
337: | |
338: | NOTES - Also Calls populate_closed_dates. This procedure is in this file. |
339: | |

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 450: arp_util.debug( 'Base ADR : '||base_amt_due_rem );

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;
449:
450: arp_util.debug( 'Base ADR : '||base_amt_due_rem );
451: arp_util.debug( 'Base AADR : '||Base_acctd_amt_due_rem );
452:
453: arp_util.debug( 'Current amt app : '||current_amt_app );
454: arp_util.debug( 'Current Acct amt app : '||current_acctd_amt_app);

Line 451: arp_util.debug( 'Base AADR : '||Base_acctd_amt_due_rem );

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;
449:
450: arp_util.debug( 'Base ADR : '||base_amt_due_rem );
451: arp_util.debug( 'Base AADR : '||Base_acctd_amt_due_rem );
452:
453: arp_util.debug( 'Current amt app : '||current_amt_app );
454: arp_util.debug( 'Current Acct amt app : '||current_acctd_amt_app);
455:

Line 453: arp_util.debug( 'Current amt app : '||current_amt_app );

449:
450: arp_util.debug( 'Base ADR : '||base_amt_due_rem );
451: arp_util.debug( 'Base AADR : '||Base_acctd_amt_due_rem );
452:
453: arp_util.debug( 'Current amt app : '||current_amt_app );
454: arp_util.debug( 'Current Acct amt app : '||current_acctd_amt_app);
455:
456: --6924942 as in point 3 above
457: arp_util.calc_acctd_amount(NULL,NULL,NULL,

Line 454: arp_util.debug( 'Current Acct amt app : '||current_acctd_amt_app);

450: arp_util.debug( 'Base ADR : '||base_amt_due_rem );
451: arp_util.debug( 'Base AADR : '||Base_acctd_amt_due_rem );
452:
453: arp_util.debug( 'Current amt app : '||current_amt_app );
454: arp_util.debug( 'Current Acct amt app : '||current_acctd_amt_app);
455:
456: --6924942 as in point 3 above
457: arp_util.calc_acctd_amount(NULL,NULL,NULL,
458: l_ps_rec.exchange_rate,

Line 457: arp_util.calc_acctd_amount(NULL,NULL,NULL,

453: arp_util.debug( 'Current amt app : '||current_amt_app );
454: arp_util.debug( 'Current Acct amt app : '||current_acctd_amt_app);
455:
456: --6924942 as in point 3 above
457: arp_util.calc_acctd_amount(NULL,NULL,NULL,
458: l_ps_rec.exchange_rate,
459: '-', /** ADR must be reduced by amount_applied */
460: Base_amt_due_rem, /* Current ADR */
461: Base_acctd_amt_due_rem, /* Current Acctd. ADR */

Line 465: arp_util.debug( 'New adr : '||l_new_adr );

461: Base_acctd_amt_due_rem, /* Current Acctd. ADR */
462: (Current_amt_app-p_amount_applied), /* Receipt Amount */
463: l_new_adr,l_new_aadr,l_new_aapf);
464:
465: arp_util.debug( 'New adr : '||l_new_adr );
466: arp_util.debug( 'New aadr : '||l_new_aadr );
467: arp_util.debug( 'New aapf : '||l_new_aapf );
468:
469: --6924942 as in point 4 above

Line 466: arp_util.debug( 'New aadr : '||l_new_aadr );

462: (Current_amt_app-p_amount_applied), /* Receipt Amount */
463: l_new_adr,l_new_aadr,l_new_aapf);
464:
465: arp_util.debug( 'New adr : '||l_new_adr );
466: arp_util.debug( 'New aadr : '||l_new_aadr );
467: arp_util.debug( 'New aapf : '||l_new_aapf );
468:
469: --6924942 as in point 4 above
470: l_ps_rec.amount_due_remaining := l_new_adr;

Line 467: arp_util.debug( 'New aapf : '||l_new_aapf );

463: l_new_adr,l_new_aadr,l_new_aapf);
464:
465: arp_util.debug( 'New adr : '||l_new_adr );
466: arp_util.debug( 'New aadr : '||l_new_aadr );
467: arp_util.debug( 'New aapf : '||l_new_aapf );
468:
469: --6924942 as in point 4 above
470: l_ps_rec.amount_due_remaining := l_new_adr;
471: l_ps_rec.acctd_amount_due_remaining := l_new_aadr;

Line 476: l_acctd_amt_app_from := arp_util.functional_amount(l_amt_app_from,

472: l_acctd_amount_applied := l_new_aapf-current_acctd_amt_app;
473: else
474: --6924942 case of first application
475: l_amt_app_from := -p_amount_applied;
476: l_acctd_amt_app_from := arp_util.functional_amount(l_amt_app_from,
477: arpcurr.FunctionalCurrency,
478: l_ps_rec.exchange_rate,
479: NULL,
480: NULL);

Line 481: arp_util.debug( 'AAPF : '||l_amt_app_from );

477: arpcurr.FunctionalCurrency,
478: l_ps_rec.exchange_rate,
479: NULL,
480: NULL);
481: arp_util.debug( 'AAPF : '||l_amt_app_from );
482: arp_util.debug( 'ACCTD_AAPF : '||l_acctd_amt_app_from );
483:
484: arp_util.debug( 'Amt App : '||p_amount_applied );
485: l_ps_rec.amount_due_remaining := l_ps_rec.amount_due_remaining - l_amt_app_from;

Line 482: arp_util.debug( 'ACCTD_AAPF : '||l_acctd_amt_app_from );

478: l_ps_rec.exchange_rate,
479: NULL,
480: NULL);
481: arp_util.debug( 'AAPF : '||l_amt_app_from );
482: arp_util.debug( 'ACCTD_AAPF : '||l_acctd_amt_app_from );
483:
484: arp_util.debug( 'Amt App : '||p_amount_applied );
485: l_ps_rec.amount_due_remaining := l_ps_rec.amount_due_remaining - l_amt_app_from;
486: l_ps_rec.acctd_amount_due_remaining := l_ps_rec.acctd_amount_due_remaining - l_acctd_amt_app_from;

Line 484: arp_util.debug( 'Amt App : '||p_amount_applied );

480: NULL);
481: arp_util.debug( 'AAPF : '||l_amt_app_from );
482: arp_util.debug( 'ACCTD_AAPF : '||l_acctd_amt_app_from );
483:
484: arp_util.debug( 'Amt App : '||p_amount_applied );
485: l_ps_rec.amount_due_remaining := l_ps_rec.amount_due_remaining - l_amt_app_from;
486: l_ps_rec.acctd_amount_due_remaining := l_ps_rec.acctd_amount_due_remaining - l_acctd_amt_app_from;
487: l_acctd_amount_applied := l_acctd_amt_app_from;
488:

Line 497: arp_util.calc_acctd_amount( NULL, NULL, NULL,

493: --6924942 same way calculation apart from Invoice
494: l_nocopy_amt_due_remain := l_ps_rec.amount_due_remaining;
495: l_nocopy_acctd_amt_due_remain := l_ps_rec.acctd_amount_due_remaining;
496:
497: arp_util.calc_acctd_amount( NULL, NULL, NULL,
498: l_ps_rec.exchange_rate,
499: '-', /** ADR must be reduced by amount_applied */
500: l_nocopy_amt_due_remain, /* Current ADR */
501: l_nocopy_acctd_amt_due_remain, /* Current Acctd. ADR */

Line 684: | arp_util.calc_acctd_amount and arp_debug.debug |

680: | p_charges_applied - Part of the applied amount applied to|
681: | receivable charges |
682: | |
683: | EXTERNAL PROCEDURES/FUNCTION |
684: | arp_util.calc_acctd_amount and arp_debug.debug |
685: | arp_ps_pkg.fetch_p and arp_ps_pkg.update_p |
686: | |
687: | NOTES - Also Calls populate_closed_dates. This procedure is in this file. |
688: | |

Line 826: | arp_util.calc_acctd_amount and arp_debug.debug |

822: | p_charges_applied - Part of the applied amount applied to|
823: | receivable charges |
824: | |
825: | EXTERNAL PROCEDURES/FUNCTION |
826: | arp_util.calc_acctd_amount and arp_debug.debug |
827: | arp_ps_pkg.fetch_p and arp_ps_pkg.update_p |
828: | |
829: | NOTES - Also Calls populate_closed_dates. This procedure is in this file. |
830: | |

Line 967: INTO arp_util.PG_OVERAPP_ALLOW_FLAG

963:
964: -- Bug 13543605. Extracting the value of overapplication flag of the transaction.
965: BEGIN
966: SELECT ctt.allow_overapplication_flag
967: INTO arp_util.PG_OVERAPP_ALLOW_FLAG
968: FROM RA_CUST_TRX_TYPES ctt,
969: AR_PAYMENT_SCHEDULES ps,
970: RA_CUSTOMER_TRX ct
971: WHERE ps.customer_trx_id = ct.customer_trx_id

Line 1174: arp_util.calc_acctd_amount( NULL, NULL, NULL,

1170: --
1171: l_nocopy_amt_due_remain := l_ps_rec.amount_due_remaining;
1172: l_nocopy_acctd_amt_due_remain := l_ps_rec.acctd_amount_due_remaining;
1173:
1174: arp_util.calc_acctd_amount( NULL, NULL, NULL,
1175: l_ps_rec.exchange_rate,
1176: '-', /** ADR must be reduced by amount_applied */
1177: l_nocopy_amt_due_remain, /* Current ADR */
1178: l_nocopy_acctd_amt_due_remain, /* Current Acctd. ADR */

Line 1209: arp_util.calc_acctd_amount( NULL, NULL, NULL,

1205: --
1206: l_nocopy_amt_due_remain := l_ps_rec.amount_due_remaining;
1207: l_nocopy_acctd_amt_due_remain := l_ps_rec.acctd_amount_due_remaining;
1208:
1209: arp_util.calc_acctd_amount( NULL, NULL, NULL,
1210: l_ps_rec.exchange_rate,
1211: '-', /** ADR must be reduced by amount_applied */
1212: l_nocopy_amt_due_remain, /* Current ADR */
1213: l_nocopy_acctd_amt_due_remain, /* Current Acctd. ADR */

Line 1244: arp_util.calc_acctd_amount( NULL, NULL, NULL,

1240: --
1241: l_nocopy_amt_due_remain := l_ps_rec.amount_due_remaining;
1242: l_nocopy_acctd_amt_due_remain := l_ps_rec.acctd_amount_due_remaining;
1243:
1244: arp_util.calc_acctd_amount( NULL, NULL, NULL,
1245: l_ps_rec.exchange_rate,
1246: '-', /** ADR must be reduced by amount_applied */
1247: l_nocopy_amt_due_remain, /* Current ADR */
1248: l_nocopy_acctd_amt_due_remain, /* Current Acctd. ADR */

Line 1352: -- Bug 13543605, Re-setting the value of arp_util.PG_OVERAPP_ALLOW_FLAG.

1348: p_ra_app_id := l_ebt_ra_app_id;
1349: p_gt_id := l_ebt_gt_id;
1350:
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;

Line 1353: arp_util.PG_OVERAPP_ALLOW_FLAG := NULL;

1349: p_gt_id := l_ebt_gt_id;
1350:
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: --

Line 1364: arp_util.PG_OVERAPP_ALLOW_FLAG := NULL;

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;
1367:
1368: --

Line 1419: arp_debug.debug( 'arp_util.validate_args_upd_inv_rel_cols()-' );

1415: APP_EXCEPTION.raise_exception;
1416: END IF;
1417: --
1418: IF PG_DEBUG in ('Y', 'C') THEN
1419: arp_debug.debug( 'arp_util.validate_args_upd_inv_rel_cols()-' );
1420: END IF;
1421: EXCEPTION
1422: WHEN OTHERS THEN
1423: IF PG_DEBUG in ('Y', 'C') THEN

Line 1473: | arp_util.calc_acctd_amount and arp_debug.debug |

1469: | populate CHARGES_REMAINING in RA |
1470: | table |
1471: | |
1472: | EXTERNAL PROCEDURES/FUNCTION |
1473: | arp_util.calc_acctd_amount and arp_debug.debug |
1474: | arp_ps_pkg.fetch_p and arp_ps_pkg.update_p |
1475: | |
1476: | NOTES - Also Calls populate_closed_dates. This procedure is in this file. |
1477: | |

Line 1546: arp_util.calc_acctd_amount( NULL, NULL, NULL,

1542: --
1543: l_nocopy_amt_due_remain := l_ps_rec.amount_due_remaining;
1544: l_nocopy_acctd_amt_due_remain := l_ps_rec.acctd_amount_due_remaining;
1545:
1546: arp_util.calc_acctd_amount( NULL, NULL, NULL,
1547: l_ps_rec.exchange_rate,
1548: '+', /** amount_applied must be added to ADR */
1549: l_nocopy_amt_due_remain, /* Current ADR */
1550: l_nocopy_acctd_amt_due_remain, /* Current Acctd. ADR */

Line 1651: | arp_util.calc_acctd_amount and arp_debug.debug |

1647: | p_charges_adjusted - charges adjusted - In case of INVOICE adj.|
1648: | p_freight_adjusted - freight adjusted - In case of INVOICE adj.|
1649: | |
1650: | EXTERNAL PROCEDURES/FUNCTION |
1651: | arp_util.calc_acctd_amount and arp_debug.debug |
1652: | arp_ps_pkg.fetch_p and arp_ps_pkg.update_p |
1653: | |
1654: | NOTES - Also Calls populate_closed_dates. This procedure is in this file. |
1655: | At present this is an overloaded procedure |

Line 2028: arp_debug.debug( 'arp_util.validate_args_upd_adj_rel_cols()-' );

2024: APP_EXCEPTION.raise_exception;
2025: END IF;
2026: --
2027: IF PG_DEBUG in ('Y', 'C') THEN
2028: arp_debug.debug( 'arp_util.validate_args_upd_adj_rel_cols()-' );
2029: END IF;
2030: EXCEPTION
2031: WHEN OTHERS THEN
2032: IF PG_DEBUG in ('Y', 'C') THEN

Line 2067: | arp_util.calc_acctd_amount and arp_debug.debug |

2063: | to receivable charges |
2064: | p_amount_adjusted_pending - Amount adjsuted pending if any. |
2065: | |
2066: | EXTERNAL PROCEDURES/FUNCTION |
2067: | arp_util.calc_acctd_amount and arp_debug.debug |
2068: | arp_ps_pkg.fetch_p and arp_ps_pkg.update_p |
2069: | |
2070: | NOTES - Also Calls populate_closed_dates. This procedure is in this file. |
2071: | |

Line 2157: arp_util.calc_acctd_amount( NULL, NULL, NULL,

2153: --
2154: l_nocopy_amt_due_remain := l_ps_rec.amount_due_remaining;
2155: l_nocopy_acctd_amt_due_remain := l_ps_rec.acctd_amount_due_remaining;
2156:
2157: arp_util.calc_acctd_amount( NULL, NULL, NULL,
2158: l_ps_rec.exchange_rate,
2159: '+', /* amount_applied must be added to ADR */
2160: l_nocopy_amt_due_remain, /* Current ADR */
2161: l_nocopy_acctd_amt_due_remain, /* Current Acctd. ADR */

Line 2293: arp_debug.debug( 'arp_util.validate_args_upd_adj_rel_cols()-' );

2289: APP_EXCEPTION.raise_exception;
2290: END IF;
2291: --
2292: IF PG_DEBUG in ('Y', 'C') THEN
2293: arp_debug.debug( 'arp_util.validate_args_upd_adj_rel_cols()-' );
2294: END IF;
2295: EXCEPTION
2296: WHEN OTHERS THEN
2297: IF PG_DEBUG in ('Y', 'C') THEN

Line 2342: arp_debug.debug( 'arp_util.populate_closed_dates()+' );

2338: l_actual_date_closed ar_payment_schedules.gl_date%TYPE;
2339: --
2340: BEGIN
2341: IF PG_DEBUG in ('Y', 'C') THEN
2342: arp_debug.debug( 'arp_util.populate_closed_dates()+' );
2343: END IF;
2344: --
2345: IF( p_ps_rec.payment_schedule_id IS NULL ) THEN
2346: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );

Line 2377: arp_debug.debug( 'arp_util.populate_closed_dates()-' );

2373: p_ps_rec.actual_date_closed := ARP_GLOBAL.G_MAX_DATE;
2374: END IF;
2375: --
2376: IF PG_DEBUG in ('Y', 'C') THEN
2377: arp_debug.debug( 'arp_util.populate_closed_dates()-' );
2378: END IF;
2379: EXCEPTION
2380: WHEN OTHERS THEN
2381: IF PG_DEBUG in ('Y', 'C') THEN

Line 2453: arp_debug.debug( '>>>>>>> arp_util.get_closed_dates' );

2449: l_max_actual_date DATE;
2450: BEGIN
2451: --
2452: IF PG_DEBUG in ('Y', 'C') THEN
2453: arp_debug.debug( '>>>>>>> arp_util.get_closed_dates' );
2454: END IF;
2455: --
2456: -- Get max dates from ar_receivable_applications
2457: --

Line 2522: arp_debug.debug( '<<<<<<< arp_util.get_closed_dates' );

2518: );
2519: END IF;
2520: --
2521: IF PG_DEBUG in ('Y', 'C') THEN
2522: arp_debug.debug( '<<<<<<< arp_util.get_closed_dates' );
2523: END IF;
2524: --
2525: EXCEPTION
2526: WHEN OTHERS THEN

Line 2528: arp_debug.debug( 'EXCEPTION: arp_util.get_closed_dates' );

2524: --
2525: EXCEPTION
2526: WHEN OTHERS THEN
2527: IF PG_DEBUG in ('Y', 'C') THEN
2528: arp_debug.debug( 'EXCEPTION: arp_util.get_closed_dates' );
2529: END IF;
2530: RAISE;
2531: END get_closed_dates;
2532: --