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 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 97: arp_util.debug('val_update_rev_actions: ' || 'What is the type?' );

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

Line 98: arp_util.debug('val_update_rev_actions: ' || 'p_app_rec.trx_type = ' || p_app_rec.trx_type );

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

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 257: arp_util.debug('val_update_rev_actions: ' ||

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

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 302: arp_util.debug('val_update_rev_actions: ' ||

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

Line 335: | arp_util.calc_acctd_amount and arp_util.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_util.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 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 370: arp_util.debug( 'PS ID : '||p_ps_id );

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 ) );
373: arp_util.debug( 'GL Date : '||TO_CHAR( p_gl_date ) );
374: --

Line 371: arp_util.debug( 'Amount Applied : '||p_amount_applied );

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 ) );
373: arp_util.debug( 'GL Date : '||TO_CHAR( p_gl_date ) );
374: --
375: IF ( p_ps_rec.payment_schedule_id is NOT NULL ) THEN

Line 372: arp_util.debug( 'Apply Date : '||TO_CHAR( p_apply_date ) );

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 ) );
373: arp_util.debug( 'GL Date : '||TO_CHAR( p_gl_date ) );
374: --
375: IF ( p_ps_rec.payment_schedule_id is NOT NULL ) THEN
376: l_ps_rec := p_ps_rec;

Line 373: arp_util.debug( 'GL Date : '||TO_CHAR( p_gl_date ) );

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 ) );
373: arp_util.debug( 'GL Date : '||TO_CHAR( p_gl_date ) );
374: --
375: IF ( p_ps_rec.payment_schedule_id is NOT NULL ) THEN
376: l_ps_rec := p_ps_rec;
377: validate_args_upd_rel_cols( l_ps_rec.payment_schedule_id,

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

394: --
395: l_nocopy_amt_due_remain := l_ps_rec.amount_due_remaining;
396: l_nocopy_acctd_amt_due_remain := l_ps_rec.acctd_amount_due_remaining;
397:
398: arp_util.calc_acctd_amount( NULL, NULL, NULL,
399: l_ps_rec.exchange_rate,
400: '-', /** ADR must be reduced by amount_applied */
401: l_nocopy_amt_due_remain, /* Current ADR */
402: l_nocopy_acctd_amt_due_remain, /* Current Acctd. ADR */

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 467: arp_util.debug(

463: arp_util.debug( '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: --

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 515: arp_util.debug('validate_args_upd_rel_cols: ' ||

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

Line 579: | arp_util.calc_acctd_amount and arp_util.debug |

575: | p_charges_applied - Part of the applied amount applied to|
576: | receivable charges |
577: | |
578: | EXTERNAL PROCEDURES/FUNCTION |
579: | arp_util.calc_acctd_amount and arp_util.debug |
580: | arp_ps_pkg.fetch_p and arp_ps_pkg.update_p |
581: | |
582: | NOTES - Also Calls populate_closed_dates. This procedure is in this file. |
583: | |

Line 721: | arp_util.calc_acctd_amount and arp_util.debug |

717: | p_charges_applied - Part of the applied amount applied to|
718: | receivable charges |
719: | |
720: | EXTERNAL PROCEDURES/FUNCTION |
721: | arp_util.calc_acctd_amount and arp_util.debug |
722: | arp_ps_pkg.fetch_p and arp_ps_pkg.update_p |
723: | |
724: | NOTES - Also Calls populate_closed_dates. This procedure is in this file. |
725: | |

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

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 );
836: arp_util.debug( 'Amount Applied : '||p_amount_applied );
837: arp_util.debug( 'Earned Disc. Taken : '||p_discount_taken_earned );
838: arp_util.debug( 'Unearned Disc. Taken : '||p_discount_taken_unearned );
839: arp_util.debug( 'Apply Date : '||TO_CHAR( p_apply_date ) );

Line 836: arp_util.debug( 'Amount Applied : '||p_amount_applied );

832: END IF;
833: --
834: IF PG_DEBUG in ('Y', 'C') THEN
835: arp_util.debug( 'PS ID : '||p_ps_id );
836: arp_util.debug( 'Amount Applied : '||p_amount_applied );
837: arp_util.debug( 'Earned Disc. Taken : '||p_discount_taken_earned );
838: arp_util.debug( 'Unearned Disc. Taken : '||p_discount_taken_unearned );
839: arp_util.debug( 'Apply Date : '||TO_CHAR( p_apply_date ) );
840: arp_util.debug( 'GL Date : '||TO_CHAR( p_gl_date ) );

Line 837: arp_util.debug( 'Earned Disc. Taken : '||p_discount_taken_earned );

833: --
834: IF PG_DEBUG in ('Y', 'C') THEN
835: arp_util.debug( 'PS ID : '||p_ps_id );
836: arp_util.debug( 'Amount Applied : '||p_amount_applied );
837: arp_util.debug( 'Earned Disc. Taken : '||p_discount_taken_earned );
838: arp_util.debug( 'Unearned Disc. Taken : '||p_discount_taken_unearned );
839: arp_util.debug( 'Apply Date : '||TO_CHAR( p_apply_date ) );
840: arp_util.debug( 'GL Date : '||TO_CHAR( p_gl_date ) );
841: END IF;

Line 838: arp_util.debug( 'Unearned Disc. Taken : '||p_discount_taken_unearned );

834: IF PG_DEBUG in ('Y', 'C') THEN
835: arp_util.debug( 'PS ID : '||p_ps_id );
836: arp_util.debug( 'Amount Applied : '||p_amount_applied );
837: arp_util.debug( 'Earned Disc. Taken : '||p_discount_taken_earned );
838: arp_util.debug( 'Unearned Disc. Taken : '||p_discount_taken_unearned );
839: arp_util.debug( 'Apply Date : '||TO_CHAR( p_apply_date ) );
840: arp_util.debug( 'GL Date : '||TO_CHAR( p_gl_date ) );
841: END IF;
842: --

Line 839: arp_util.debug( 'Apply Date : '||TO_CHAR( p_apply_date ) );

835: arp_util.debug( 'PS ID : '||p_ps_id );
836: arp_util.debug( 'Amount Applied : '||p_amount_applied );
837: arp_util.debug( 'Earned Disc. Taken : '||p_discount_taken_earned );
838: arp_util.debug( 'Unearned Disc. Taken : '||p_discount_taken_unearned );
839: arp_util.debug( 'Apply Date : '||TO_CHAR( p_apply_date ) );
840: arp_util.debug( 'GL Date : '||TO_CHAR( p_gl_date ) );
841: END IF;
842: --
843: IF ( p_ps_rec.payment_schedule_id is NOT NULL ) THEN

Line 840: arp_util.debug( 'GL Date : '||TO_CHAR( p_gl_date ) );

836: arp_util.debug( 'Amount Applied : '||p_amount_applied );
837: arp_util.debug( 'Earned Disc. Taken : '||p_discount_taken_earned );
838: arp_util.debug( 'Unearned Disc. Taken : '||p_discount_taken_unearned );
839: arp_util.debug( 'Apply Date : '||TO_CHAR( p_apply_date ) );
840: arp_util.debug( 'GL Date : '||TO_CHAR( p_gl_date ) );
841: END IF;
842: --
843: IF ( p_ps_rec.payment_schedule_id is NOT NULL ) THEN
844: l_ps_rec := p_ps_rec;

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

1043: --
1044: l_nocopy_amt_due_remain := l_ps_rec.amount_due_remaining;
1045: l_nocopy_acctd_amt_due_remain := l_ps_rec.acctd_amount_due_remaining;
1046:
1047: arp_util.calc_acctd_amount( NULL, NULL, NULL,
1048: l_ps_rec.exchange_rate,
1049: '-', /** ADR must be reduced by amount_applied */
1050: l_nocopy_amt_due_remain, /* Current ADR */
1051: l_nocopy_acctd_amt_due_remain, /* Current Acctd. ADR */

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

1078: --
1079: l_nocopy_amt_due_remain := l_ps_rec.amount_due_remaining;
1080: l_nocopy_acctd_amt_due_remain := l_ps_rec.acctd_amount_due_remaining;
1081:
1082: arp_util.calc_acctd_amount( NULL, NULL, NULL,
1083: l_ps_rec.exchange_rate,
1084: '-', /** ADR must be reduced by amount_applied */
1085: l_nocopy_amt_due_remain, /* Current ADR */
1086: l_nocopy_acctd_amt_due_remain, /* Current Acctd. ADR */

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

1113: --
1114: l_nocopy_amt_due_remain := l_ps_rec.amount_due_remaining;
1115: l_nocopy_acctd_amt_due_remain := l_ps_rec.acctd_amount_due_remaining;
1116:
1117: arp_util.calc_acctd_amount( NULL, NULL, NULL,
1118: l_ps_rec.exchange_rate,
1119: '-', /** ADR must be reduced by amount_applied */
1120: l_nocopy_amt_due_remain, /* Current ADR */
1121: l_nocopy_acctd_amt_due_remain, /* Current Acctd. ADR */

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 1232: arp_util.debug(

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

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 1289: arp_util.debug( 'arp_util.validate_args_upd_inv_rel_cols()-' );

1285: APP_EXCEPTION.raise_exception;
1286: END IF;
1287: --
1288: IF PG_DEBUG in ('Y', 'C') THEN
1289: arp_util.debug( 'arp_util.validate_args_upd_inv_rel_cols()-' );
1290: END IF;
1291: EXCEPTION
1292: WHEN OTHERS THEN
1293: IF PG_DEBUG in ('Y', 'C') THEN

Line 1294: arp_util.debug('validate_args_upd_inv_rel_cols: ' ||

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

Line 1343: | arp_util.calc_acctd_amount and arp_util.debug |

1339: | populate CHARGES_REMAINING in RA |
1340: | table |
1341: | |
1342: | EXTERNAL PROCEDURES/FUNCTION |
1343: | arp_util.calc_acctd_amount and arp_util.debug |
1344: | arp_ps_pkg.fetch_p and arp_ps_pkg.update_p |
1345: | |
1346: | NOTES - Also Calls populate_closed_dates. This procedure is in this file. |
1347: | |

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 1388: arp_util.debug('update_cm_related_columns: ' || 'PS ID : '||p_ps_id );

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 );
1389: arp_util.debug('update_cm_related_columns: ' || 'Amount Applied : '||p_amount_applied );
1390: arp_util.debug('update_cm_related_columns: ' || 'Apply Date : '||TO_CHAR( p_apply_date ) );
1391: arp_util.debug('update_cm_related_columns: ' || 'GL Date : '||TO_CHAR( p_gl_date ) );
1392: END IF;

Line 1389: arp_util.debug('update_cm_related_columns: ' || 'Amount Applied : '||p_amount_applied );

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 );
1389: arp_util.debug('update_cm_related_columns: ' || 'Amount Applied : '||p_amount_applied );
1390: arp_util.debug('update_cm_related_columns: ' || 'Apply Date : '||TO_CHAR( p_apply_date ) );
1391: arp_util.debug('update_cm_related_columns: ' || 'GL Date : '||TO_CHAR( p_gl_date ) );
1392: END IF;
1393: --

Line 1390: arp_util.debug('update_cm_related_columns: ' || 'Apply Date : '||TO_CHAR( p_apply_date ) );

1386: --
1387: IF PG_DEBUG in ('Y', 'C') THEN
1388: arp_util.debug('update_cm_related_columns: ' || 'PS ID : '||p_ps_id );
1389: arp_util.debug('update_cm_related_columns: ' || 'Amount Applied : '||p_amount_applied );
1390: arp_util.debug('update_cm_related_columns: ' || 'Apply Date : '||TO_CHAR( p_apply_date ) );
1391: arp_util.debug('update_cm_related_columns: ' || 'GL Date : '||TO_CHAR( p_gl_date ) );
1392: END IF;
1393: --
1394: IF ( p_ps_rec.payment_schedule_id is NOT NULL ) THEN

Line 1391: arp_util.debug('update_cm_related_columns: ' || 'GL Date : '||TO_CHAR( p_gl_date ) );

1387: IF PG_DEBUG in ('Y', 'C') THEN
1388: arp_util.debug('update_cm_related_columns: ' || 'PS ID : '||p_ps_id );
1389: arp_util.debug('update_cm_related_columns: ' || 'Amount Applied : '||p_amount_applied );
1390: arp_util.debug('update_cm_related_columns: ' || 'Apply Date : '||TO_CHAR( p_apply_date ) );
1391: arp_util.debug('update_cm_related_columns: ' || 'GL Date : '||TO_CHAR( p_gl_date ) );
1392: END IF;
1393: --
1394: IF ( p_ps_rec.payment_schedule_id is NOT NULL ) THEN
1395: l_ps_rec := p_ps_rec;

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

1412: --
1413: l_nocopy_amt_due_remain := l_ps_rec.amount_due_remaining;
1414: l_nocopy_acctd_amt_due_remain := l_ps_rec.acctd_amount_due_remaining;
1415:
1416: arp_util.calc_acctd_amount( NULL, NULL, NULL,
1417: l_ps_rec.exchange_rate,
1418: '+', /** amount_applied must be added to ADR */
1419: l_nocopy_amt_due_remain, /* Current ADR */
1420: l_nocopy_acctd_amt_due_remain, /* Current Acctd. ADR */

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 1482: arp_util.debug('update_cm_related_columns: ' ||

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

Line 1521: | arp_util.calc_acctd_amount and arp_util.debug |

1517: | p_charges_adjusted - charges adjusted - In case of INVOICE adj.|
1518: | p_freight_adjusted - freight adjusted - In case of INVOICE adj.|
1519: | |
1520: | EXTERNAL PROCEDURES/FUNCTION |
1521: | arp_util.calc_acctd_amount and arp_util.debug |
1522: | arp_ps_pkg.fetch_p and arp_ps_pkg.update_p |
1523: | |
1524: | NOTES - Also Calls populate_closed_dates. This procedure is in this file. |
1525: | At present this is an overloaded procedure |

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 1596: arp_util.debug('update_adj_related_columns: ' || 'PS ID : '||p_ps_id );

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 );
1597: arp_util.debug('update_adj_related_columns: ' || 'PS REC ID : '||to_char(p_ps_rec.payment_schedule_id));
1598: arp_util.debug('update_adj_related_columns: ' || 'Type : '||p_type );
1599: arp_util.debug('update_adj_related_columns: ' || 'Amount adjusted : '||p_amount_adjusted );
1600: arp_util.debug('update_adj_related_columns: ' || 'Amount Adjusted Pend : '||p_amount_adjusted_pending );

Line 1597: arp_util.debug('update_adj_related_columns: ' || 'PS REC ID : '||to_char(p_ps_rec.payment_schedule_id));

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 );
1597: arp_util.debug('update_adj_related_columns: ' || 'PS REC ID : '||to_char(p_ps_rec.payment_schedule_id));
1598: arp_util.debug('update_adj_related_columns: ' || 'Type : '||p_type );
1599: arp_util.debug('update_adj_related_columns: ' || 'Amount adjusted : '||p_amount_adjusted );
1600: arp_util.debug('update_adj_related_columns: ' || 'Amount Adjusted Pend : '||p_amount_adjusted_pending );
1601: arp_util.debug('update_adj_related_columns: ' || 'Line Adjusted : '||p_line_adjusted);

Line 1598: arp_util.debug('update_adj_related_columns: ' || 'Type : '||p_type );

1594: --
1595: IF PG_DEBUG in ('Y', 'C') THEN
1596: arp_util.debug('update_adj_related_columns: ' || 'PS ID : '||p_ps_id );
1597: arp_util.debug('update_adj_related_columns: ' || 'PS REC ID : '||to_char(p_ps_rec.payment_schedule_id));
1598: arp_util.debug('update_adj_related_columns: ' || 'Type : '||p_type );
1599: arp_util.debug('update_adj_related_columns: ' || 'Amount adjusted : '||p_amount_adjusted );
1600: arp_util.debug('update_adj_related_columns: ' || 'Amount Adjusted Pend : '||p_amount_adjusted_pending );
1601: arp_util.debug('update_adj_related_columns: ' || 'Line Adjusted : '||p_line_adjusted);
1602: arp_util.debug('update_adj_related_columns: ' || 'Tax Adjusted : '||p_tax_adjusted);

Line 1599: arp_util.debug('update_adj_related_columns: ' || 'Amount adjusted : '||p_amount_adjusted );

1595: IF PG_DEBUG in ('Y', 'C') THEN
1596: arp_util.debug('update_adj_related_columns: ' || 'PS ID : '||p_ps_id );
1597: arp_util.debug('update_adj_related_columns: ' || 'PS REC ID : '||to_char(p_ps_rec.payment_schedule_id));
1598: arp_util.debug('update_adj_related_columns: ' || 'Type : '||p_type );
1599: arp_util.debug('update_adj_related_columns: ' || 'Amount adjusted : '||p_amount_adjusted );
1600: arp_util.debug('update_adj_related_columns: ' || 'Amount Adjusted Pend : '||p_amount_adjusted_pending );
1601: arp_util.debug('update_adj_related_columns: ' || 'Line Adjusted : '||p_line_adjusted);
1602: arp_util.debug('update_adj_related_columns: ' || 'Tax Adjusted : '||p_tax_adjusted);
1603: arp_util.debug('update_adj_related_columns: ' || 'Freight Adjusted : '||p_freight_adjusted);

Line 1600: arp_util.debug('update_adj_related_columns: ' || 'Amount Adjusted Pend : '||p_amount_adjusted_pending );

1596: arp_util.debug('update_adj_related_columns: ' || 'PS ID : '||p_ps_id );
1597: arp_util.debug('update_adj_related_columns: ' || 'PS REC ID : '||to_char(p_ps_rec.payment_schedule_id));
1598: arp_util.debug('update_adj_related_columns: ' || 'Type : '||p_type );
1599: arp_util.debug('update_adj_related_columns: ' || 'Amount adjusted : '||p_amount_adjusted );
1600: arp_util.debug('update_adj_related_columns: ' || 'Amount Adjusted Pend : '||p_amount_adjusted_pending );
1601: arp_util.debug('update_adj_related_columns: ' || 'Line Adjusted : '||p_line_adjusted);
1602: arp_util.debug('update_adj_related_columns: ' || 'Tax Adjusted : '||p_tax_adjusted);
1603: arp_util.debug('update_adj_related_columns: ' || 'Freight Adjusted : '||p_freight_adjusted);
1604: arp_util.debug('update_adj_related_columns: ' || 'Charges Adjusted : '||p_charges_adjusted);

Line 1601: arp_util.debug('update_adj_related_columns: ' || 'Line Adjusted : '||p_line_adjusted);

1597: arp_util.debug('update_adj_related_columns: ' || 'PS REC ID : '||to_char(p_ps_rec.payment_schedule_id));
1598: arp_util.debug('update_adj_related_columns: ' || 'Type : '||p_type );
1599: arp_util.debug('update_adj_related_columns: ' || 'Amount adjusted : '||p_amount_adjusted );
1600: arp_util.debug('update_adj_related_columns: ' || 'Amount Adjusted Pend : '||p_amount_adjusted_pending );
1601: arp_util.debug('update_adj_related_columns: ' || 'Line Adjusted : '||p_line_adjusted);
1602: arp_util.debug('update_adj_related_columns: ' || 'Tax Adjusted : '||p_tax_adjusted);
1603: arp_util.debug('update_adj_related_columns: ' || 'Freight Adjusted : '||p_freight_adjusted);
1604: arp_util.debug('update_adj_related_columns: ' || 'Charges Adjusted : '||p_charges_adjusted);
1605: arp_util.debug('update_adj_related_columns: ' || 'Apply Date : '||TO_CHAR( p_apply_date ) );

Line 1602: arp_util.debug('update_adj_related_columns: ' || 'Tax Adjusted : '||p_tax_adjusted);

1598: arp_util.debug('update_adj_related_columns: ' || 'Type : '||p_type );
1599: arp_util.debug('update_adj_related_columns: ' || 'Amount adjusted : '||p_amount_adjusted );
1600: arp_util.debug('update_adj_related_columns: ' || 'Amount Adjusted Pend : '||p_amount_adjusted_pending );
1601: arp_util.debug('update_adj_related_columns: ' || 'Line Adjusted : '||p_line_adjusted);
1602: arp_util.debug('update_adj_related_columns: ' || 'Tax Adjusted : '||p_tax_adjusted);
1603: arp_util.debug('update_adj_related_columns: ' || 'Freight Adjusted : '||p_freight_adjusted);
1604: arp_util.debug('update_adj_related_columns: ' || 'Charges Adjusted : '||p_charges_adjusted);
1605: arp_util.debug('update_adj_related_columns: ' || 'Apply Date : '||TO_CHAR( p_apply_date ) );
1606: arp_util.debug('update_adj_related_columns: ' || 'GL Date : '||TO_CHAR( p_gl_date ) );

Line 1603: arp_util.debug('update_adj_related_columns: ' || 'Freight Adjusted : '||p_freight_adjusted);

1599: arp_util.debug('update_adj_related_columns: ' || 'Amount adjusted : '||p_amount_adjusted );
1600: arp_util.debug('update_adj_related_columns: ' || 'Amount Adjusted Pend : '||p_amount_adjusted_pending );
1601: arp_util.debug('update_adj_related_columns: ' || 'Line Adjusted : '||p_line_adjusted);
1602: arp_util.debug('update_adj_related_columns: ' || 'Tax Adjusted : '||p_tax_adjusted);
1603: arp_util.debug('update_adj_related_columns: ' || 'Freight Adjusted : '||p_freight_adjusted);
1604: arp_util.debug('update_adj_related_columns: ' || 'Charges Adjusted : '||p_charges_adjusted);
1605: arp_util.debug('update_adj_related_columns: ' || 'Apply Date : '||TO_CHAR( p_apply_date ) );
1606: arp_util.debug('update_adj_related_columns: ' || 'GL Date : '||TO_CHAR( p_gl_date ) );
1607: END IF;

Line 1604: arp_util.debug('update_adj_related_columns: ' || 'Charges Adjusted : '||p_charges_adjusted);

1600: arp_util.debug('update_adj_related_columns: ' || 'Amount Adjusted Pend : '||p_amount_adjusted_pending );
1601: arp_util.debug('update_adj_related_columns: ' || 'Line Adjusted : '||p_line_adjusted);
1602: arp_util.debug('update_adj_related_columns: ' || 'Tax Adjusted : '||p_tax_adjusted);
1603: arp_util.debug('update_adj_related_columns: ' || 'Freight Adjusted : '||p_freight_adjusted);
1604: arp_util.debug('update_adj_related_columns: ' || 'Charges Adjusted : '||p_charges_adjusted);
1605: arp_util.debug('update_adj_related_columns: ' || 'Apply Date : '||TO_CHAR( p_apply_date ) );
1606: arp_util.debug('update_adj_related_columns: ' || 'GL Date : '||TO_CHAR( p_gl_date ) );
1607: END IF;
1608: --

Line 1605: arp_util.debug('update_adj_related_columns: ' || 'Apply Date : '||TO_CHAR( p_apply_date ) );

1601: arp_util.debug('update_adj_related_columns: ' || 'Line Adjusted : '||p_line_adjusted);
1602: arp_util.debug('update_adj_related_columns: ' || 'Tax Adjusted : '||p_tax_adjusted);
1603: arp_util.debug('update_adj_related_columns: ' || 'Freight Adjusted : '||p_freight_adjusted);
1604: arp_util.debug('update_adj_related_columns: ' || 'Charges Adjusted : '||p_charges_adjusted);
1605: arp_util.debug('update_adj_related_columns: ' || 'Apply Date : '||TO_CHAR( p_apply_date ) );
1606: arp_util.debug('update_adj_related_columns: ' || 'GL Date : '||TO_CHAR( p_gl_date ) );
1607: END IF;
1608: --
1609: IF ( p_ps_rec.payment_schedule_id is NOT NULL ) THEN

Line 1606: arp_util.debug('update_adj_related_columns: ' || 'GL Date : '||TO_CHAR( p_gl_date ) );

1602: arp_util.debug('update_adj_related_columns: ' || 'Tax Adjusted : '||p_tax_adjusted);
1603: arp_util.debug('update_adj_related_columns: ' || 'Freight Adjusted : '||p_freight_adjusted);
1604: arp_util.debug('update_adj_related_columns: ' || 'Charges Adjusted : '||p_charges_adjusted);
1605: arp_util.debug('update_adj_related_columns: ' || 'Apply Date : '||TO_CHAR( p_apply_date ) );
1606: arp_util.debug('update_adj_related_columns: ' || 'GL Date : '||TO_CHAR( p_gl_date ) );
1607: END IF;
1608: --
1609: IF ( p_ps_rec.payment_schedule_id is NOT NULL ) THEN
1610: l_ps_rec := p_ps_rec;

Line 1828: arp_util.debug('update_adj_related_columns: ' || 'Line Adjusted : '||p_line_adjusted );

1824: END IF;
1825: --
1826:
1827: IF PG_DEBUG in ('Y', 'C') THEN
1828: arp_util.debug('update_adj_related_columns: ' || 'Line Adjusted : '||p_line_adjusted );
1829: arp_util.debug('update_adj_related_columns: ' || 'TAx Adjusted : '||p_tax_adjusted );
1830: arp_util.debug('update_adj_related_columns: ' || 'Freight Adjusted : '||p_freight_adjusted );
1831: arp_util.debug('update_adj_related_columns: ' || 'Charges Adjusted : '||p_charges_adjusted );
1832: END IF;

Line 1829: arp_util.debug('update_adj_related_columns: ' || 'TAx Adjusted : '||p_tax_adjusted );

1825: --
1826:
1827: IF PG_DEBUG in ('Y', 'C') THEN
1828: arp_util.debug('update_adj_related_columns: ' || 'Line Adjusted : '||p_line_adjusted );
1829: arp_util.debug('update_adj_related_columns: ' || 'TAx Adjusted : '||p_tax_adjusted );
1830: arp_util.debug('update_adj_related_columns: ' || 'Freight Adjusted : '||p_freight_adjusted );
1831: arp_util.debug('update_adj_related_columns: ' || 'Charges Adjusted : '||p_charges_adjusted );
1832: END IF;
1833:

Line 1830: arp_util.debug('update_adj_related_columns: ' || 'Freight Adjusted : '||p_freight_adjusted );

1826:
1827: IF PG_DEBUG in ('Y', 'C') THEN
1828: arp_util.debug('update_adj_related_columns: ' || 'Line Adjusted : '||p_line_adjusted );
1829: arp_util.debug('update_adj_related_columns: ' || 'TAx Adjusted : '||p_tax_adjusted );
1830: arp_util.debug('update_adj_related_columns: ' || 'Freight Adjusted : '||p_freight_adjusted );
1831: arp_util.debug('update_adj_related_columns: ' || 'Charges Adjusted : '||p_charges_adjusted );
1832: END IF;
1833:
1834: update_adj_related_columns(

Line 1831: arp_util.debug('update_adj_related_columns: ' || 'Charges Adjusted : '||p_charges_adjusted );

1827: IF PG_DEBUG in ('Y', 'C') THEN
1828: arp_util.debug('update_adj_related_columns: ' || 'Line Adjusted : '||p_line_adjusted );
1829: arp_util.debug('update_adj_related_columns: ' || 'TAx Adjusted : '||p_tax_adjusted );
1830: arp_util.debug('update_adj_related_columns: ' || 'Freight Adjusted : '||p_freight_adjusted );
1831: arp_util.debug('update_adj_related_columns: ' || 'Charges Adjusted : '||p_charges_adjusted );
1832: END IF;
1833:
1834: update_adj_related_columns(
1835: l_ps_rec.payment_schedule_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 1857: arp_util.debug('update_adj_related_columns: ' ||

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

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 1898: arp_util.debug('update_adj_related_columns: ' || 'arp_util.validate_args_upd_adj_rel_cols()-' );

1894: APP_EXCEPTION.raise_exception;
1895: END IF;
1896: --
1897: IF PG_DEBUG in ('Y', 'C') THEN
1898: arp_util.debug('update_adj_related_columns: ' || 'arp_util.validate_args_upd_adj_rel_cols()-' );
1899: END IF;
1900: EXCEPTION
1901: WHEN OTHERS THEN
1902: IF PG_DEBUG in ('Y', 'C') THEN

Line 1903: arp_util.debug('update_adj_related_columns: ' ||

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

Line 1937: | arp_util.calc_acctd_amount and arp_util.debug |

1933: | to receivable charges |
1934: | p_amount_adjusted_pending - Amount adjsuted pending if any. |
1935: | |
1936: | EXTERNAL PROCEDURES/FUNCTION |
1937: | arp_util.calc_acctd_amount and arp_util.debug |
1938: | arp_ps_pkg.fetch_p and arp_ps_pkg.update_p |
1939: | |
1940: | NOTES - Also Calls populate_closed_dates. This procedure is in this file. |
1941: | |

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 1984: arp_util.debug('update_adj_related_columns: ' || 'PS ID : '||p_ps_id );

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 );
1985: arp_util.debug('update_adj_related_columns: ' || 'Line Adjusted : '||p_line_adjusted );
1986: arp_util.debug('update_adj_related_columns: ' || 'TAx Adjusted : '||p_tax_adjusted );
1987: arp_util.debug('update_adj_related_columns: ' || 'Freight Adjusted : '||p_freight_adjusted );
1988: arp_util.debug('update_adj_related_columns: ' || 'Charges Adjusted : '||p_charges_adjusted );

Line 1985: arp_util.debug('update_adj_related_columns: ' || 'Line Adjusted : '||p_line_adjusted );

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 );
1985: arp_util.debug('update_adj_related_columns: ' || 'Line Adjusted : '||p_line_adjusted );
1986: arp_util.debug('update_adj_related_columns: ' || 'TAx Adjusted : '||p_tax_adjusted );
1987: arp_util.debug('update_adj_related_columns: ' || 'Freight Adjusted : '||p_freight_adjusted );
1988: arp_util.debug('update_adj_related_columns: ' || 'Charges Adjusted : '||p_charges_adjusted );
1989: arp_util.debug('update_adj_related_columns: ' || 'Amount Adjusted Pend : '||p_amount_adjusted_pending );

Line 1986: arp_util.debug('update_adj_related_columns: ' || 'TAx Adjusted : '||p_tax_adjusted );

1982: --
1983: IF PG_DEBUG in ('Y', 'C') THEN
1984: arp_util.debug('update_adj_related_columns: ' || 'PS ID : '||p_ps_id );
1985: arp_util.debug('update_adj_related_columns: ' || 'Line Adjusted : '||p_line_adjusted );
1986: arp_util.debug('update_adj_related_columns: ' || 'TAx Adjusted : '||p_tax_adjusted );
1987: arp_util.debug('update_adj_related_columns: ' || 'Freight Adjusted : '||p_freight_adjusted );
1988: arp_util.debug('update_adj_related_columns: ' || 'Charges Adjusted : '||p_charges_adjusted );
1989: arp_util.debug('update_adj_related_columns: ' || 'Amount Adjusted Pend : '||p_amount_adjusted_pending );
1990: arp_util.debug('update_adj_related_columns: ' || 'Apply Date : '||TO_CHAR( p_apply_date ) );

Line 1987: arp_util.debug('update_adj_related_columns: ' || 'Freight Adjusted : '||p_freight_adjusted );

1983: IF PG_DEBUG in ('Y', 'C') THEN
1984: arp_util.debug('update_adj_related_columns: ' || 'PS ID : '||p_ps_id );
1985: arp_util.debug('update_adj_related_columns: ' || 'Line Adjusted : '||p_line_adjusted );
1986: arp_util.debug('update_adj_related_columns: ' || 'TAx Adjusted : '||p_tax_adjusted );
1987: arp_util.debug('update_adj_related_columns: ' || 'Freight Adjusted : '||p_freight_adjusted );
1988: arp_util.debug('update_adj_related_columns: ' || 'Charges Adjusted : '||p_charges_adjusted );
1989: arp_util.debug('update_adj_related_columns: ' || 'Amount Adjusted Pend : '||p_amount_adjusted_pending );
1990: arp_util.debug('update_adj_related_columns: ' || 'Apply Date : '||TO_CHAR( p_apply_date ) );
1991: arp_util.debug('update_adj_related_columns: ' || 'GL Date : '||TO_CHAR( p_gl_date ) );

Line 1988: arp_util.debug('update_adj_related_columns: ' || 'Charges Adjusted : '||p_charges_adjusted );

1984: arp_util.debug('update_adj_related_columns: ' || 'PS ID : '||p_ps_id );
1985: arp_util.debug('update_adj_related_columns: ' || 'Line Adjusted : '||p_line_adjusted );
1986: arp_util.debug('update_adj_related_columns: ' || 'TAx Adjusted : '||p_tax_adjusted );
1987: arp_util.debug('update_adj_related_columns: ' || 'Freight Adjusted : '||p_freight_adjusted );
1988: arp_util.debug('update_adj_related_columns: ' || 'Charges Adjusted : '||p_charges_adjusted );
1989: arp_util.debug('update_adj_related_columns: ' || 'Amount Adjusted Pend : '||p_amount_adjusted_pending );
1990: arp_util.debug('update_adj_related_columns: ' || 'Apply Date : '||TO_CHAR( p_apply_date ) );
1991: arp_util.debug('update_adj_related_columns: ' || 'GL Date : '||TO_CHAR( p_gl_date ) );
1992: END IF;

Line 1989: arp_util.debug('update_adj_related_columns: ' || 'Amount Adjusted Pend : '||p_amount_adjusted_pending );

1985: arp_util.debug('update_adj_related_columns: ' || 'Line Adjusted : '||p_line_adjusted );
1986: arp_util.debug('update_adj_related_columns: ' || 'TAx Adjusted : '||p_tax_adjusted );
1987: arp_util.debug('update_adj_related_columns: ' || 'Freight Adjusted : '||p_freight_adjusted );
1988: arp_util.debug('update_adj_related_columns: ' || 'Charges Adjusted : '||p_charges_adjusted );
1989: arp_util.debug('update_adj_related_columns: ' || 'Amount Adjusted Pend : '||p_amount_adjusted_pending );
1990: arp_util.debug('update_adj_related_columns: ' || 'Apply Date : '||TO_CHAR( p_apply_date ) );
1991: arp_util.debug('update_adj_related_columns: ' || 'GL Date : '||TO_CHAR( p_gl_date ) );
1992: END IF;
1993:

Line 1990: arp_util.debug('update_adj_related_columns: ' || 'Apply Date : '||TO_CHAR( p_apply_date ) );

1986: arp_util.debug('update_adj_related_columns: ' || 'TAx Adjusted : '||p_tax_adjusted );
1987: arp_util.debug('update_adj_related_columns: ' || 'Freight Adjusted : '||p_freight_adjusted );
1988: arp_util.debug('update_adj_related_columns: ' || 'Charges Adjusted : '||p_charges_adjusted );
1989: arp_util.debug('update_adj_related_columns: ' || 'Amount Adjusted Pend : '||p_amount_adjusted_pending );
1990: arp_util.debug('update_adj_related_columns: ' || 'Apply Date : '||TO_CHAR( p_apply_date ) );
1991: arp_util.debug('update_adj_related_columns: ' || 'GL Date : '||TO_CHAR( p_gl_date ) );
1992: END IF;
1993:
1994: IF ( p_ps_rec.payment_schedule_id is NOT NULL ) THEN

Line 1991: arp_util.debug('update_adj_related_columns: ' || 'GL Date : '||TO_CHAR( p_gl_date ) );

1987: arp_util.debug('update_adj_related_columns: ' || 'Freight Adjusted : '||p_freight_adjusted );
1988: arp_util.debug('update_adj_related_columns: ' || 'Charges Adjusted : '||p_charges_adjusted );
1989: arp_util.debug('update_adj_related_columns: ' || 'Amount Adjusted Pend : '||p_amount_adjusted_pending );
1990: arp_util.debug('update_adj_related_columns: ' || 'Apply Date : '||TO_CHAR( p_apply_date ) );
1991: arp_util.debug('update_adj_related_columns: ' || 'GL Date : '||TO_CHAR( p_gl_date ) );
1992: END IF;
1993:
1994: IF ( p_ps_rec.payment_schedule_id is NOT NULL ) THEN
1995: l_ps_rec := p_ps_rec;

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

2023: --
2024: l_nocopy_amt_due_remain := l_ps_rec.amount_due_remaining;
2025: l_nocopy_acctd_amt_due_remain := l_ps_rec.acctd_amount_due_remaining;
2026:
2027: arp_util.calc_acctd_amount( NULL, NULL, NULL,
2028: l_ps_rec.exchange_rate,
2029: '+', /* amount_applied must be added to ADR */
2030: l_nocopy_amt_due_remain, /* Current ADR */
2031: l_nocopy_acctd_amt_due_remain, /* Current Acctd. ADR */

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 2094: arp_util.debug('update_adj_related_columns: ' ||

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

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 2163: arp_util.debug( 'arp_util.validate_args_upd_adj_rel_cols()-' );

2159: APP_EXCEPTION.raise_exception;
2160: END IF;
2161: --
2162: IF PG_DEBUG in ('Y', 'C') THEN
2163: arp_util.debug( 'arp_util.validate_args_upd_adj_rel_cols()-' );
2164: END IF;
2165: EXCEPTION
2166: WHEN OTHERS THEN
2167: IF PG_DEBUG in ('Y', 'C') THEN

Line 2168: arp_util.debug('validate_args_upd_adj_rel_cols: ' ||

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

Line 2212: arp_util.debug( 'arp_util.populate_closed_dates()+' );

2208: l_actual_date_closed ar_payment_schedules.gl_date%TYPE;
2209: --
2210: BEGIN
2211: IF PG_DEBUG in ('Y', 'C') THEN
2212: arp_util.debug( 'arp_util.populate_closed_dates()+' );
2213: END IF;
2214: --
2215: IF( p_ps_rec.payment_schedule_id IS NULL ) THEN
2216: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );

Line 2247: arp_util.debug( 'arp_util.populate_closed_dates()-' );

2243: p_ps_rec.actual_date_closed := ARP_GLOBAL.G_MAX_DATE;
2244: END IF;
2245: --
2246: IF PG_DEBUG in ('Y', 'C') THEN
2247: arp_util.debug( 'arp_util.populate_closed_dates()-' );
2248: END IF;
2249: EXCEPTION
2250: WHEN OTHERS THEN
2251: IF PG_DEBUG in ('Y', 'C') THEN

Line 2252: arp_util.debug('populate_closed_dates: ' ||

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

Line 2323: arp_util.debug( '>>>>>>> arp_util.get_closed_dates' );

2319: l_max_actual_date DATE;
2320: BEGIN
2321: --
2322: IF PG_DEBUG in ('Y', 'C') THEN
2323: arp_util.debug( '>>>>>>> arp_util.get_closed_dates' );
2324: END IF;
2325: --
2326: -- Get max dates from ar_receivable_applications
2327: --

Line 2330: arp_util.debug('get_closed_dates: ' || '>>>P_PS_ID: ' || p_ps_id );

2326: -- Get max dates from ar_receivable_applications
2327: --
2328:
2329: IF PG_DEBUG in ('Y', 'C') THEN
2330: arp_util.debug('get_closed_dates: ' || '>>>P_PS_ID: ' || p_ps_id );
2331: END IF;
2332:
2333: IF p_ps_id > 0 THEN /* Bug 3382570 */
2334:

Line 2349: arp_util.debug('get_closed_dates: ' || ' after select appln' );

2345: -- applied.
2346: AND nvl( confirmed_flag, 'Y' ) = 'Y';
2347: --
2348: IF PG_DEBUG in ('Y', 'C') THEN
2349: arp_util.debug('get_closed_dates: ' || ' after select appln' );
2350: END IF;
2351: --
2352: -- Get max dates from ar_adjustments
2353: --

Line 2392: arp_util.debug( '<<<<<<< arp_util.get_closed_dates' );

2388: );
2389: END IF;
2390: --
2391: IF PG_DEBUG in ('Y', 'C') THEN
2392: arp_util.debug( '<<<<<<< arp_util.get_closed_dates' );
2393: END IF;
2394: --
2395: EXCEPTION
2396: WHEN OTHERS THEN

Line 2398: arp_util.debug( 'EXCEPTION: arp_util.get_closed_dates' );

2394: --
2395: EXCEPTION
2396: WHEN OTHERS THEN
2397: IF PG_DEBUG in ('Y', 'C') THEN
2398: arp_util.debug( 'EXCEPTION: arp_util.get_closed_dates' );
2399: END IF;
2400: RAISE;
2401: END get_closed_dates;
2402: --