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_DEBUG

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 97: arp_debug.debug( ' p_app_rec.trx_type = ' || p_app_rec.trx_type );

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: --
101: -- Update payment schedule table

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 256: arp_debug.debug(

252: END IF;
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;

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 301: arp_debug.debug(

297: END IF;
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;

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 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 386: arp_debug.debug( 'PS ID : '||p_ps_id );

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 ) );
390: arp_debug.debug( 'Maturity Date : '||TO_CHAR( p_maturity_date));

Line 387: arp_debug.debug( 'Amount Applied : '||p_amount_applied );

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 ) );
390: arp_debug.debug( 'Maturity Date : '||TO_CHAR( p_maturity_date));
391: END IF;

Line 388: arp_debug.debug( 'Apply Date : '||TO_CHAR( p_apply_date ) );

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 ) );
390: arp_debug.debug( 'Maturity Date : '||TO_CHAR( p_maturity_date));
391: END IF;
392:

Line 389: arp_debug.debug( 'GL Date : '||TO_CHAR( p_gl_date ) );

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 ) );
390: arp_debug.debug( 'Maturity Date : '||TO_CHAR( p_maturity_date));
391: END IF;
392:
393: IF ( p_ps_rec.payment_schedule_id is NOT NULL ) THEN

Line 390: arp_debug.debug( 'Maturity Date : '||TO_CHAR( p_maturity_date));

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 ) );
390: arp_debug.debug( 'Maturity Date : '||TO_CHAR( p_maturity_date));
391: END IF;
392:
393: IF ( p_ps_rec.payment_schedule_id is NOT NULL ) THEN
394: l_ps_rec := p_ps_rec;

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 572: arp_debug.debug(

568: END IF;
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: --

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 620: arp_debug.debug('validate_args_upd_rel_cols: ' ||

616: END IF;
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;

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 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 940: arp_debug.debug( 'PS ID : '||p_ps_id );

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 );
941: arp_debug.debug( 'Amount Applied : '||p_amount_applied );
942: arp_debug.debug( 'Earned Disc. Taken : '||p_discount_taken_earned );
943: arp_debug.debug( 'Unearned Disc. Taken : '||p_discount_taken_unearned );
944: arp_debug.debug( 'Apply Date : '||TO_CHAR( p_apply_date ) );

Line 941: arp_debug.debug( 'Amount Applied : '||p_amount_applied );

937: END IF;
938: --
939: IF PG_DEBUG in ('Y', 'C') THEN
940: arp_debug.debug( 'PS ID : '||p_ps_id );
941: arp_debug.debug( 'Amount Applied : '||p_amount_applied );
942: arp_debug.debug( 'Earned Disc. Taken : '||p_discount_taken_earned );
943: arp_debug.debug( 'Unearned Disc. Taken : '||p_discount_taken_unearned );
944: arp_debug.debug( 'Apply Date : '||TO_CHAR( p_apply_date ) );
945: arp_debug.debug( 'GL Date : '||TO_CHAR( p_gl_date ) );

Line 942: arp_debug.debug( 'Earned Disc. Taken : '||p_discount_taken_earned );

938: --
939: IF PG_DEBUG in ('Y', 'C') THEN
940: arp_debug.debug( 'PS ID : '||p_ps_id );
941: arp_debug.debug( 'Amount Applied : '||p_amount_applied );
942: arp_debug.debug( 'Earned Disc. Taken : '||p_discount_taken_earned );
943: arp_debug.debug( 'Unearned Disc. Taken : '||p_discount_taken_unearned );
944: arp_debug.debug( 'Apply Date : '||TO_CHAR( p_apply_date ) );
945: arp_debug.debug( 'GL Date : '||TO_CHAR( p_gl_date ) );
946: END IF;

Line 943: arp_debug.debug( 'Unearned Disc. Taken : '||p_discount_taken_unearned );

939: IF PG_DEBUG in ('Y', 'C') THEN
940: arp_debug.debug( 'PS ID : '||p_ps_id );
941: arp_debug.debug( 'Amount Applied : '||p_amount_applied );
942: arp_debug.debug( 'Earned Disc. Taken : '||p_discount_taken_earned );
943: arp_debug.debug( 'Unearned Disc. Taken : '||p_discount_taken_unearned );
944: arp_debug.debug( 'Apply Date : '||TO_CHAR( p_apply_date ) );
945: arp_debug.debug( 'GL Date : '||TO_CHAR( p_gl_date ) );
946: END IF;
947: --

Line 944: arp_debug.debug( 'Apply Date : '||TO_CHAR( p_apply_date ) );

940: arp_debug.debug( 'PS ID : '||p_ps_id );
941: arp_debug.debug( 'Amount Applied : '||p_amount_applied );
942: arp_debug.debug( 'Earned Disc. Taken : '||p_discount_taken_earned );
943: arp_debug.debug( 'Unearned Disc. Taken : '||p_discount_taken_unearned );
944: arp_debug.debug( 'Apply Date : '||TO_CHAR( p_apply_date ) );
945: arp_debug.debug( 'GL Date : '||TO_CHAR( p_gl_date ) );
946: END IF;
947: --
948: IF ( p_ps_rec.payment_schedule_id is NOT NULL ) THEN

Line 945: arp_debug.debug( 'GL Date : '||TO_CHAR( p_gl_date ) );

941: arp_debug.debug( 'Amount Applied : '||p_amount_applied );
942: arp_debug.debug( 'Earned Disc. Taken : '||p_discount_taken_earned );
943: arp_debug.debug( 'Unearned Disc. Taken : '||p_discount_taken_unearned );
944: arp_debug.debug( 'Apply Date : '||TO_CHAR( p_apply_date ) );
945: arp_debug.debug( 'GL Date : '||TO_CHAR( p_gl_date ) );
946: END IF;
947: --
948: IF ( p_ps_rec.payment_schedule_id is NOT NULL ) THEN
949: l_ps_rec := p_ps_rec;

Line 978: arp_debug.debug('No data Found while checking overapplication flag.');

974: AND ps.payment_schedule_id = p_ps_id;
975: EXCEPTION
976: WHEN NO_DATA_FOUND THEN
977: IF PG_DEBUG in ('Y', 'C') THEN
978: arp_debug.debug('No data Found while checking overapplication flag.');
979: END IF;
980: WHEN OTHERS THEN
981: IF PG_DEBUG in ('Y', 'C') THEN
982: arp_debug.debug('Error occurred while checking overapplication flag.');

Line 982: arp_debug.debug('Error occurred while checking overapplication flag.');

978: arp_debug.debug('No data Found while checking overapplication flag.');
979: END IF;
980: WHEN OTHERS THEN
981: IF PG_DEBUG in ('Y', 'C') THEN
982: arp_debug.debug('Error occurred while checking overapplication flag.');
983: END IF;
984: END;
985: --
986: -- Init. temp. variables

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 1361: arp_debug.debug(

1357: --
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;

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 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 1424: arp_debug.debug('validate_args_upd_inv_rel_cols: ' ||

1420: END IF;
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;

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 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 1518: arp_debug.debug( 'PS ID : '||p_ps_id );

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 );
1519: arp_debug.debug( 'Amount Applied : '||p_amount_applied );
1520: arp_debug.debug( 'Apply Date : '||TO_CHAR( p_apply_date ) );
1521: arp_debug.debug( 'GL Date : '||TO_CHAR( p_gl_date ) );
1522: END IF;

Line 1519: arp_debug.debug( 'Amount Applied : '||p_amount_applied );

1515: END IF;
1516: --
1517: IF PG_DEBUG in ('Y', 'C') THEN
1518: arp_debug.debug( 'PS ID : '||p_ps_id );
1519: arp_debug.debug( 'Amount Applied : '||p_amount_applied );
1520: arp_debug.debug( 'Apply Date : '||TO_CHAR( p_apply_date ) );
1521: arp_debug.debug( 'GL Date : '||TO_CHAR( p_gl_date ) );
1522: END IF;
1523: --

Line 1520: arp_debug.debug( 'Apply Date : '||TO_CHAR( p_apply_date ) );

1516: --
1517: IF PG_DEBUG in ('Y', 'C') THEN
1518: arp_debug.debug( 'PS ID : '||p_ps_id );
1519: arp_debug.debug( 'Amount Applied : '||p_amount_applied );
1520: arp_debug.debug( 'Apply Date : '||TO_CHAR( p_apply_date ) );
1521: arp_debug.debug( 'GL Date : '||TO_CHAR( p_gl_date ) );
1522: END IF;
1523: --
1524: IF ( p_ps_rec.payment_schedule_id is NOT NULL ) THEN

Line 1521: arp_debug.debug( 'GL Date : '||TO_CHAR( p_gl_date ) );

1517: IF PG_DEBUG in ('Y', 'C') THEN
1518: arp_debug.debug( 'PS ID : '||p_ps_id );
1519: arp_debug.debug( 'Amount Applied : '||p_amount_applied );
1520: arp_debug.debug( 'Apply Date : '||TO_CHAR( p_apply_date ) );
1521: arp_debug.debug( 'GL Date : '||TO_CHAR( p_gl_date ) );
1522: END IF;
1523: --
1524: IF ( p_ps_rec.payment_schedule_id is NOT NULL ) THEN
1525: l_ps_rec := p_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 1612: arp_debug.debug(

1608: --
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;

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 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 1726: arp_debug.debug( 'PS ID : '||p_ps_id );

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 );
1727: arp_debug.debug( 'PS REC ID : '||to_char(p_ps_rec.payment_schedule_id));
1728: arp_debug.debug( 'Type : '||p_type );
1729: arp_debug.debug( 'Amount adjusted : '||p_amount_adjusted );
1730: arp_debug.debug( 'Amount Adjusted Pend : '||p_amount_adjusted_pending );

Line 1727: arp_debug.debug( 'PS REC ID : '||to_char(p_ps_rec.payment_schedule_id));

1723: END IF;
1724: --
1725: IF PG_DEBUG in ('Y', 'C') THEN
1726: arp_debug.debug( 'PS ID : '||p_ps_id );
1727: arp_debug.debug( 'PS REC ID : '||to_char(p_ps_rec.payment_schedule_id));
1728: arp_debug.debug( 'Type : '||p_type );
1729: arp_debug.debug( 'Amount adjusted : '||p_amount_adjusted );
1730: arp_debug.debug( 'Amount Adjusted Pend : '||p_amount_adjusted_pending );
1731: arp_debug.debug( 'Line Adjusted : '||p_line_adjusted);

Line 1728: arp_debug.debug( 'Type : '||p_type );

1724: --
1725: IF PG_DEBUG in ('Y', 'C') THEN
1726: arp_debug.debug( 'PS ID : '||p_ps_id );
1727: arp_debug.debug( 'PS REC ID : '||to_char(p_ps_rec.payment_schedule_id));
1728: arp_debug.debug( 'Type : '||p_type );
1729: arp_debug.debug( 'Amount adjusted : '||p_amount_adjusted );
1730: arp_debug.debug( 'Amount Adjusted Pend : '||p_amount_adjusted_pending );
1731: arp_debug.debug( 'Line Adjusted : '||p_line_adjusted);
1732: arp_debug.debug( 'Tax Adjusted : '||p_tax_adjusted);

Line 1729: arp_debug.debug( 'Amount adjusted : '||p_amount_adjusted );

1725: IF PG_DEBUG in ('Y', 'C') THEN
1726: arp_debug.debug( 'PS ID : '||p_ps_id );
1727: arp_debug.debug( 'PS REC ID : '||to_char(p_ps_rec.payment_schedule_id));
1728: arp_debug.debug( 'Type : '||p_type );
1729: arp_debug.debug( 'Amount adjusted : '||p_amount_adjusted );
1730: arp_debug.debug( 'Amount Adjusted Pend : '||p_amount_adjusted_pending );
1731: arp_debug.debug( 'Line Adjusted : '||p_line_adjusted);
1732: arp_debug.debug( 'Tax Adjusted : '||p_tax_adjusted);
1733: arp_debug.debug( 'Freight Adjusted : '||p_freight_adjusted);

Line 1730: arp_debug.debug( 'Amount Adjusted Pend : '||p_amount_adjusted_pending );

1726: arp_debug.debug( 'PS ID : '||p_ps_id );
1727: arp_debug.debug( 'PS REC ID : '||to_char(p_ps_rec.payment_schedule_id));
1728: arp_debug.debug( 'Type : '||p_type );
1729: arp_debug.debug( 'Amount adjusted : '||p_amount_adjusted );
1730: arp_debug.debug( 'Amount Adjusted Pend : '||p_amount_adjusted_pending );
1731: arp_debug.debug( 'Line Adjusted : '||p_line_adjusted);
1732: arp_debug.debug( 'Tax Adjusted : '||p_tax_adjusted);
1733: arp_debug.debug( 'Freight Adjusted : '||p_freight_adjusted);
1734: arp_debug.debug( 'Charges Adjusted : '||p_charges_adjusted);

Line 1731: arp_debug.debug( 'Line Adjusted : '||p_line_adjusted);

1727: arp_debug.debug( 'PS REC ID : '||to_char(p_ps_rec.payment_schedule_id));
1728: arp_debug.debug( 'Type : '||p_type );
1729: arp_debug.debug( 'Amount adjusted : '||p_amount_adjusted );
1730: arp_debug.debug( 'Amount Adjusted Pend : '||p_amount_adjusted_pending );
1731: arp_debug.debug( 'Line Adjusted : '||p_line_adjusted);
1732: arp_debug.debug( 'Tax Adjusted : '||p_tax_adjusted);
1733: arp_debug.debug( 'Freight Adjusted : '||p_freight_adjusted);
1734: arp_debug.debug( 'Charges Adjusted : '||p_charges_adjusted);
1735: arp_debug.debug( 'Apply Date : '||TO_CHAR( p_apply_date ) );

Line 1732: arp_debug.debug( 'Tax Adjusted : '||p_tax_adjusted);

1728: arp_debug.debug( 'Type : '||p_type );
1729: arp_debug.debug( 'Amount adjusted : '||p_amount_adjusted );
1730: arp_debug.debug( 'Amount Adjusted Pend : '||p_amount_adjusted_pending );
1731: arp_debug.debug( 'Line Adjusted : '||p_line_adjusted);
1732: arp_debug.debug( 'Tax Adjusted : '||p_tax_adjusted);
1733: arp_debug.debug( 'Freight Adjusted : '||p_freight_adjusted);
1734: arp_debug.debug( 'Charges Adjusted : '||p_charges_adjusted);
1735: arp_debug.debug( 'Apply Date : '||TO_CHAR( p_apply_date ) );
1736: arp_debug.debug( 'GL Date : '||TO_CHAR( p_gl_date ) );

Line 1733: arp_debug.debug( 'Freight Adjusted : '||p_freight_adjusted);

1729: arp_debug.debug( 'Amount adjusted : '||p_amount_adjusted );
1730: arp_debug.debug( 'Amount Adjusted Pend : '||p_amount_adjusted_pending );
1731: arp_debug.debug( 'Line Adjusted : '||p_line_adjusted);
1732: arp_debug.debug( 'Tax Adjusted : '||p_tax_adjusted);
1733: arp_debug.debug( 'Freight Adjusted : '||p_freight_adjusted);
1734: arp_debug.debug( 'Charges Adjusted : '||p_charges_adjusted);
1735: arp_debug.debug( 'Apply Date : '||TO_CHAR( p_apply_date ) );
1736: arp_debug.debug( 'GL Date : '||TO_CHAR( p_gl_date ) );
1737: END IF;

Line 1734: arp_debug.debug( 'Charges Adjusted : '||p_charges_adjusted);

1730: arp_debug.debug( 'Amount Adjusted Pend : '||p_amount_adjusted_pending );
1731: arp_debug.debug( 'Line Adjusted : '||p_line_adjusted);
1732: arp_debug.debug( 'Tax Adjusted : '||p_tax_adjusted);
1733: arp_debug.debug( 'Freight Adjusted : '||p_freight_adjusted);
1734: arp_debug.debug( 'Charges Adjusted : '||p_charges_adjusted);
1735: arp_debug.debug( 'Apply Date : '||TO_CHAR( p_apply_date ) );
1736: arp_debug.debug( 'GL Date : '||TO_CHAR( p_gl_date ) );
1737: END IF;
1738: --

Line 1735: arp_debug.debug( 'Apply Date : '||TO_CHAR( p_apply_date ) );

1731: arp_debug.debug( 'Line Adjusted : '||p_line_adjusted);
1732: arp_debug.debug( 'Tax Adjusted : '||p_tax_adjusted);
1733: arp_debug.debug( 'Freight Adjusted : '||p_freight_adjusted);
1734: arp_debug.debug( 'Charges Adjusted : '||p_charges_adjusted);
1735: arp_debug.debug( 'Apply Date : '||TO_CHAR( p_apply_date ) );
1736: arp_debug.debug( 'GL Date : '||TO_CHAR( p_gl_date ) );
1737: END IF;
1738: --
1739: IF ( p_ps_rec.payment_schedule_id is NOT NULL ) THEN

Line 1736: arp_debug.debug( 'GL Date : '||TO_CHAR( p_gl_date ) );

1732: arp_debug.debug( 'Tax Adjusted : '||p_tax_adjusted);
1733: arp_debug.debug( 'Freight Adjusted : '||p_freight_adjusted);
1734: arp_debug.debug( 'Charges Adjusted : '||p_charges_adjusted);
1735: arp_debug.debug( 'Apply Date : '||TO_CHAR( p_apply_date ) );
1736: arp_debug.debug( 'GL Date : '||TO_CHAR( p_gl_date ) );
1737: END IF;
1738: --
1739: IF ( p_ps_rec.payment_schedule_id is NOT NULL ) THEN
1740: l_ps_rec := p_ps_rec;

Line 1958: arp_debug.debug( 'Line Adjusted : '||p_line_adjusted );

1954: END IF;
1955: --
1956:
1957: IF PG_DEBUG in ('Y', 'C') THEN
1958: arp_debug.debug( 'Line Adjusted : '||p_line_adjusted );
1959: arp_debug.debug( 'TAx Adjusted : '||p_tax_adjusted );
1960: arp_debug.debug( 'Freight Adjusted : '||p_freight_adjusted );
1961: arp_debug.debug( 'Charges Adjusted : '||p_charges_adjusted );
1962: END IF;

Line 1959: arp_debug.debug( 'TAx Adjusted : '||p_tax_adjusted );

1955: --
1956:
1957: IF PG_DEBUG in ('Y', 'C') THEN
1958: arp_debug.debug( 'Line Adjusted : '||p_line_adjusted );
1959: arp_debug.debug( 'TAx Adjusted : '||p_tax_adjusted );
1960: arp_debug.debug( 'Freight Adjusted : '||p_freight_adjusted );
1961: arp_debug.debug( 'Charges Adjusted : '||p_charges_adjusted );
1962: END IF;
1963:

Line 1960: arp_debug.debug( 'Freight Adjusted : '||p_freight_adjusted );

1956:
1957: IF PG_DEBUG in ('Y', 'C') THEN
1958: arp_debug.debug( 'Line Adjusted : '||p_line_adjusted );
1959: arp_debug.debug( 'TAx Adjusted : '||p_tax_adjusted );
1960: arp_debug.debug( 'Freight Adjusted : '||p_freight_adjusted );
1961: arp_debug.debug( 'Charges Adjusted : '||p_charges_adjusted );
1962: END IF;
1963:
1964: update_adj_related_columns(

Line 1961: arp_debug.debug( 'Charges Adjusted : '||p_charges_adjusted );

1957: IF PG_DEBUG in ('Y', 'C') THEN
1958: arp_debug.debug( 'Line Adjusted : '||p_line_adjusted );
1959: arp_debug.debug( 'TAx Adjusted : '||p_tax_adjusted );
1960: arp_debug.debug( 'Freight Adjusted : '||p_freight_adjusted );
1961: arp_debug.debug( 'Charges Adjusted : '||p_charges_adjusted );
1962: END IF;
1963:
1964: update_adj_related_columns(
1965: l_ps_rec.payment_schedule_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 1987: arp_debug.debug(

1983: --
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;

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 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 2033: arp_debug.debug(

2029: END IF;
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;

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 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 2114: arp_debug.debug( 'PS ID : '||p_ps_id );

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 );
2115: arp_debug.debug( 'Line Adjusted : '||p_line_adjusted );
2116: arp_debug.debug( 'TAx Adjusted : '||p_tax_adjusted );
2117: arp_debug.debug( 'Freight Adjusted : '||p_freight_adjusted );
2118: arp_debug.debug( 'Charges Adjusted : '||p_charges_adjusted );

Line 2115: arp_debug.debug( 'Line Adjusted : '||p_line_adjusted );

2111: END IF;
2112: --
2113: IF PG_DEBUG in ('Y', 'C') THEN
2114: arp_debug.debug( 'PS ID : '||p_ps_id );
2115: arp_debug.debug( 'Line Adjusted : '||p_line_adjusted );
2116: arp_debug.debug( 'TAx Adjusted : '||p_tax_adjusted );
2117: arp_debug.debug( 'Freight Adjusted : '||p_freight_adjusted );
2118: arp_debug.debug( 'Charges Adjusted : '||p_charges_adjusted );
2119: arp_debug.debug( 'Amount Adjusted Pend : '||p_amount_adjusted_pending );

Line 2116: arp_debug.debug( 'TAx Adjusted : '||p_tax_adjusted );

2112: --
2113: IF PG_DEBUG in ('Y', 'C') THEN
2114: arp_debug.debug( 'PS ID : '||p_ps_id );
2115: arp_debug.debug( 'Line Adjusted : '||p_line_adjusted );
2116: arp_debug.debug( 'TAx Adjusted : '||p_tax_adjusted );
2117: arp_debug.debug( 'Freight Adjusted : '||p_freight_adjusted );
2118: arp_debug.debug( 'Charges Adjusted : '||p_charges_adjusted );
2119: arp_debug.debug( 'Amount Adjusted Pend : '||p_amount_adjusted_pending );
2120: arp_debug.debug( 'Apply Date : '||TO_CHAR( p_apply_date ) );

Line 2117: arp_debug.debug( 'Freight Adjusted : '||p_freight_adjusted );

2113: IF PG_DEBUG in ('Y', 'C') THEN
2114: arp_debug.debug( 'PS ID : '||p_ps_id );
2115: arp_debug.debug( 'Line Adjusted : '||p_line_adjusted );
2116: arp_debug.debug( 'TAx Adjusted : '||p_tax_adjusted );
2117: arp_debug.debug( 'Freight Adjusted : '||p_freight_adjusted );
2118: arp_debug.debug( 'Charges Adjusted : '||p_charges_adjusted );
2119: arp_debug.debug( 'Amount Adjusted Pend : '||p_amount_adjusted_pending );
2120: arp_debug.debug( 'Apply Date : '||TO_CHAR( p_apply_date ) );
2121: arp_debug.debug( 'GL Date : '||TO_CHAR( p_gl_date ) );

Line 2118: arp_debug.debug( 'Charges Adjusted : '||p_charges_adjusted );

2114: arp_debug.debug( 'PS ID : '||p_ps_id );
2115: arp_debug.debug( 'Line Adjusted : '||p_line_adjusted );
2116: arp_debug.debug( 'TAx Adjusted : '||p_tax_adjusted );
2117: arp_debug.debug( 'Freight Adjusted : '||p_freight_adjusted );
2118: arp_debug.debug( 'Charges Adjusted : '||p_charges_adjusted );
2119: arp_debug.debug( 'Amount Adjusted Pend : '||p_amount_adjusted_pending );
2120: arp_debug.debug( 'Apply Date : '||TO_CHAR( p_apply_date ) );
2121: arp_debug.debug( 'GL Date : '||TO_CHAR( p_gl_date ) );
2122: END IF;

Line 2119: arp_debug.debug( 'Amount Adjusted Pend : '||p_amount_adjusted_pending );

2115: arp_debug.debug( 'Line Adjusted : '||p_line_adjusted );
2116: arp_debug.debug( 'TAx Adjusted : '||p_tax_adjusted );
2117: arp_debug.debug( 'Freight Adjusted : '||p_freight_adjusted );
2118: arp_debug.debug( 'Charges Adjusted : '||p_charges_adjusted );
2119: arp_debug.debug( 'Amount Adjusted Pend : '||p_amount_adjusted_pending );
2120: arp_debug.debug( 'Apply Date : '||TO_CHAR( p_apply_date ) );
2121: arp_debug.debug( 'GL Date : '||TO_CHAR( p_gl_date ) );
2122: END IF;
2123:

Line 2120: arp_debug.debug( 'Apply Date : '||TO_CHAR( p_apply_date ) );

2116: arp_debug.debug( 'TAx Adjusted : '||p_tax_adjusted );
2117: arp_debug.debug( 'Freight Adjusted : '||p_freight_adjusted );
2118: arp_debug.debug( 'Charges Adjusted : '||p_charges_adjusted );
2119: arp_debug.debug( 'Amount Adjusted Pend : '||p_amount_adjusted_pending );
2120: arp_debug.debug( 'Apply Date : '||TO_CHAR( p_apply_date ) );
2121: arp_debug.debug( 'GL Date : '||TO_CHAR( p_gl_date ) );
2122: END IF;
2123:
2124: IF ( p_ps_rec.payment_schedule_id is NOT NULL ) THEN

Line 2121: arp_debug.debug( 'GL Date : '||TO_CHAR( p_gl_date ) );

2117: arp_debug.debug( 'Freight Adjusted : '||p_freight_adjusted );
2118: arp_debug.debug( 'Charges Adjusted : '||p_charges_adjusted );
2119: arp_debug.debug( 'Amount Adjusted Pend : '||p_amount_adjusted_pending );
2120: arp_debug.debug( 'Apply Date : '||TO_CHAR( p_apply_date ) );
2121: arp_debug.debug( 'GL Date : '||TO_CHAR( p_gl_date ) );
2122: END IF;
2123:
2124: IF ( p_ps_rec.payment_schedule_id is NOT NULL ) THEN
2125: l_ps_rec := p_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 2224: arp_debug.debug(

2220: --
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;

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 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 2298: arp_debug.debug('validate_args_upd_adj_rel_cols: ' ||

2294: END IF;
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;

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 2382: arp_debug.debug('populate_closed_dates: ' ||

2378: END IF;
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;

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 2460: arp_debug.debug('get_closed_dates: ' || '>>>P_PS_ID: ' || p_ps_id );

2456: -- Get max dates from ar_receivable_applications
2457: --
2458:
2459: IF PG_DEBUG in ('Y', 'C') THEN
2460: arp_debug.debug('get_closed_dates: ' || '>>>P_PS_ID: ' || p_ps_id );
2461: END IF;
2462:
2463: IF p_ps_id > 0 THEN /* Bug 3382570 */
2464:

Line 2479: arp_debug.debug('get_closed_dates: ' || ' after select appln' );

2475: -- applied.
2476: AND nvl( confirmed_flag, 'Y' ) = 'Y';
2477: --
2478: IF PG_DEBUG in ('Y', 'C') THEN
2479: arp_debug.debug('get_closed_dates: ' || ' after select appln' );
2480: END IF;
2481: --
2482: -- Get max dates from ar_adjustments
2483: --

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: --