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_RATE_ADJ dependencies on ARP_STANDARD

Line 362: arp_standard.debug( '>> ARBRAD MAIN' );

358: g_ae_sys_rec arp_acct_main.ae_sys_rec_type;
359: BEGIN
360: --
361: IF PG_DEBUG in ('Y', 'C') THEN
362: arp_standard.debug( '>> ARBRAD MAIN' );
363: arp_standard.debug( 'new_crid :'||new_crid);
364: arp_standard.debug( 'new_ed :'||new_ed);
365: arp_standard.debug( 'new_er :'||new_er);
366: arp_standard.debug( 'new_ert :'||new_ert);

Line 363: arp_standard.debug( 'new_crid :'||new_crid);

359: BEGIN
360: --
361: IF PG_DEBUG in ('Y', 'C') THEN
362: arp_standard.debug( '>> ARBRAD MAIN' );
363: arp_standard.debug( 'new_crid :'||new_crid);
364: arp_standard.debug( 'new_ed :'||new_ed);
365: arp_standard.debug( 'new_er :'||new_er);
366: arp_standard.debug( 'new_ert :'||new_ert);
367: arp_standard.debug( 'new_gd :'||new_gd);

Line 364: arp_standard.debug( 'new_ed :'||new_ed);

360: --
361: IF PG_DEBUG in ('Y', 'C') THEN
362: arp_standard.debug( '>> ARBRAD MAIN' );
363: arp_standard.debug( 'new_crid :'||new_crid);
364: arp_standard.debug( 'new_ed :'||new_ed);
365: arp_standard.debug( 'new_er :'||new_er);
366: arp_standard.debug( 'new_ert :'||new_ert);
367: arp_standard.debug( 'new_gd :'||new_gd);
368: arp_standard.debug( 'new_cb :'||new_cb);

Line 365: arp_standard.debug( 'new_er :'||new_er);

361: IF PG_DEBUG in ('Y', 'C') THEN
362: arp_standard.debug( '>> ARBRAD MAIN' );
363: arp_standard.debug( 'new_crid :'||new_crid);
364: arp_standard.debug( 'new_ed :'||new_ed);
365: arp_standard.debug( 'new_er :'||new_er);
366: arp_standard.debug( 'new_ert :'||new_ert);
367: arp_standard.debug( 'new_gd :'||new_gd);
368: arp_standard.debug( 'new_cb :'||new_cb);
369: arp_standard.debug( 'new_cd :'||new_cd);

Line 366: arp_standard.debug( 'new_ert :'||new_ert);

362: arp_standard.debug( '>> ARBRAD MAIN' );
363: arp_standard.debug( 'new_crid :'||new_crid);
364: arp_standard.debug( 'new_ed :'||new_ed);
365: arp_standard.debug( 'new_er :'||new_er);
366: arp_standard.debug( 'new_ert :'||new_ert);
367: arp_standard.debug( 'new_gd :'||new_gd);
368: arp_standard.debug( 'new_cb :'||new_cb);
369: arp_standard.debug( 'new_cd :'||new_cd);
370: arp_standard.debug( 'new_lub :'||new_lub);

Line 367: arp_standard.debug( 'new_gd :'||new_gd);

363: arp_standard.debug( 'new_crid :'||new_crid);
364: arp_standard.debug( 'new_ed :'||new_ed);
365: arp_standard.debug( 'new_er :'||new_er);
366: arp_standard.debug( 'new_ert :'||new_ert);
367: arp_standard.debug( 'new_gd :'||new_gd);
368: arp_standard.debug( 'new_cb :'||new_cb);
369: arp_standard.debug( 'new_cd :'||new_cd);
370: arp_standard.debug( 'new_lub :'||new_lub);
371: arp_standard.debug( 'new_lud :'||new_lud);

Line 368: arp_standard.debug( 'new_cb :'||new_cb);

364: arp_standard.debug( 'new_ed :'||new_ed);
365: arp_standard.debug( 'new_er :'||new_er);
366: arp_standard.debug( 'new_ert :'||new_ert);
367: arp_standard.debug( 'new_gd :'||new_gd);
368: arp_standard.debug( 'new_cb :'||new_cb);
369: arp_standard.debug( 'new_cd :'||new_cd);
370: arp_standard.debug( 'new_lub :'||new_lub);
371: arp_standard.debug( 'new_lud :'||new_lud);
372: arp_standard.debug( 'new_lul :'||new_lul);

Line 369: arp_standard.debug( 'new_cd :'||new_cd);

365: arp_standard.debug( 'new_er :'||new_er);
366: arp_standard.debug( 'new_ert :'||new_ert);
367: arp_standard.debug( 'new_gd :'||new_gd);
368: arp_standard.debug( 'new_cb :'||new_cb);
369: arp_standard.debug( 'new_cd :'||new_cd);
370: arp_standard.debug( 'new_lub :'||new_lub);
371: arp_standard.debug( 'new_lud :'||new_lud);
372: arp_standard.debug( 'new_lul :'||new_lul);
373: -- arp_standard.debug( 'p_rate_adjustment_id :'||p_rate_adjustment_id);

Line 370: arp_standard.debug( 'new_lub :'||new_lub);

366: arp_standard.debug( 'new_ert :'||new_ert);
367: arp_standard.debug( 'new_gd :'||new_gd);
368: arp_standard.debug( 'new_cb :'||new_cb);
369: arp_standard.debug( 'new_cd :'||new_cd);
370: arp_standard.debug( 'new_lub :'||new_lub);
371: arp_standard.debug( 'new_lud :'||new_lud);
372: arp_standard.debug( 'new_lul :'||new_lul);
373: -- arp_standard.debug( 'p_rate_adjustment_id :'||p_rate_adjustment_id);
374: IF touch_hist_and_dist THEN

Line 371: arp_standard.debug( 'new_lud :'||new_lud);

367: arp_standard.debug( 'new_gd :'||new_gd);
368: arp_standard.debug( 'new_cb :'||new_cb);
369: arp_standard.debug( 'new_cd :'||new_cd);
370: arp_standard.debug( 'new_lub :'||new_lub);
371: arp_standard.debug( 'new_lud :'||new_lud);
372: arp_standard.debug( 'new_lul :'||new_lul);
373: -- arp_standard.debug( 'p_rate_adjustment_id :'||p_rate_adjustment_id);
374: IF touch_hist_and_dist THEN
375: arp_standard.debug( 'touch_hist_and_dist : TRUE');

Line 372: arp_standard.debug( 'new_lul :'||new_lul);

368: arp_standard.debug( 'new_cb :'||new_cb);
369: arp_standard.debug( 'new_cd :'||new_cd);
370: arp_standard.debug( 'new_lub :'||new_lub);
371: arp_standard.debug( 'new_lud :'||new_lud);
372: arp_standard.debug( 'new_lul :'||new_lul);
373: -- arp_standard.debug( 'p_rate_adjustment_id :'||p_rate_adjustment_id);
374: IF touch_hist_and_dist THEN
375: arp_standard.debug( 'touch_hist_and_dist : TRUE');
376: ELSE

Line 373: -- arp_standard.debug( 'p_rate_adjustment_id :'||p_rate_adjustment_id);

369: arp_standard.debug( 'new_cd :'||new_cd);
370: arp_standard.debug( 'new_lub :'||new_lub);
371: arp_standard.debug( 'new_lud :'||new_lud);
372: arp_standard.debug( 'new_lul :'||new_lul);
373: -- arp_standard.debug( 'p_rate_adjustment_id :'||p_rate_adjustment_id);
374: IF touch_hist_and_dist THEN
375: arp_standard.debug( 'touch_hist_and_dist : TRUE');
376: ELSE
377: arp_standard.debug( 'touch_hist_and_dist : FALSE');

Line 375: arp_standard.debug( 'touch_hist_and_dist : TRUE');

371: arp_standard.debug( 'new_lud :'||new_lud);
372: arp_standard.debug( 'new_lul :'||new_lul);
373: -- arp_standard.debug( 'p_rate_adjustment_id :'||p_rate_adjustment_id);
374: IF touch_hist_and_dist THEN
375: arp_standard.debug( 'touch_hist_and_dist : TRUE');
376: ELSE
377: arp_standard.debug( 'touch_hist_and_dist : FALSE');
378: END IF;
379: END IF;

Line 377: arp_standard.debug( 'touch_hist_and_dist : FALSE');

373: -- arp_standard.debug( 'p_rate_adjustment_id :'||p_rate_adjustment_id);
374: IF touch_hist_and_dist THEN
375: arp_standard.debug( 'touch_hist_and_dist : TRUE');
376: ELSE
377: arp_standard.debug( 'touch_hist_and_dist : FALSE');
378: END IF;
379: END IF;
380:
381: l_mesg := '';

Line 421: arp_standard.debug('Receipt has uncancellable claims - ARP_RATE_ADJ.MAIN' );

417: p_claim_id => clrec.secondary_application_ref_id)
418: THEN
419: FND_MESSAGE.SET_NAME('AR', 'AR_RW_APP_NO_NEW_RATE_IF_CLAIM');
420: IF PG_DEBUG in ('Y', 'C') THEN
421: arp_standard.debug('Receipt has uncancellable claims - ARP_RATE_ADJ.MAIN' );
422: END IF;
423: app_exception.raise_exception;
424: END IF;
425: END LOOP;

Line 466: old_crh.acctd_amount := arp_standard.functional_amount(old_crh.amount,

462:
463:
464: -- Accounted amount for the CRH record for BANK_CHARGES
465: new_crh.factor_discount_amount := old_crh.factor_discount_amount;
466: old_crh.acctd_amount := arp_standard.functional_amount(old_crh.amount,
467: cr.functional_currency,
468: new_adj.new_exchange_rate,
469: NULL,
470: NULL);

Line 487: arp_standard.functional_amount(old_crh.amount +

483: old_crh.acctd_factor_discount_amount := NULL;
484: new_crh.acctd_factor_discount_amount := old_crh.acctd_factor_discount_amount;
485: ELSE
486: old_crh.acctd_factor_discount_amount :=
487: arp_standard.functional_amount(old_crh.amount +
488: old_crh.factor_discount_amount,
489: cr.functional_currency,
490: new_adj.new_exchange_rate,
491: NULL,

Line 518: arp_standard.debug('Insert the new cash_receipt_history record');

514: old_crh.last_update_date := new_adj.last_update_date;
515: old_crh.last_update_login := new_adj.last_update_login;
516: old_crh.created_from := 'RATE ADJUSTMENT TRIGGER';
517:
518: arp_standard.debug('Insert the new cash_receipt_history record');
519: --HYU use the new for rate_adj
520: new_crh_id := arp_cash_receipt_history.InsertRecord
521: (amount => old_crh.amount,
522: acctd_amount => old_crh.acctd_amount,

Line 559: arp_standard.debug('crh_id_out:'||crh_id_out);

555: created_from => old_crh.created_from,
556: reversal_created_from => old_crh.reversal_created_from);
557:
558: crh_id_out := new_crh_id;
559: arp_standard.debug('crh_id_out:'||crh_id_out);
560:
561: /*------------------------------------------------*
562: | Close out NOCOPY current Cash Receipts History Record |
563: *------------------------------------------------*/

Line 564: arp_standard.debug('Update the rate_adjustments info on the old cash_receipt_history record');

560:
561: /*------------------------------------------------*
562: | Close out NOCOPY current Cash Receipts History Record |
563: *------------------------------------------------*/
564: arp_standard.debug('Update the rate_adjustments info on the old cash_receipt_history record');
565: --HYU rate adjustment OLD
566: arp_cash_receipt_history.Reverse(new_crh_id,
567: old_crh.gl_date,
568: old_crh_id,

Line 586: arp_standard.debug('Update Cash Receipts record with New exchange rate Information');

582:
583: /*----------------------------------------------------------------*
584: | Update Cash Receipts record with New exchange rate Information |
585: *----------------------------------------------------------------*/
586: arp_standard.debug('Update Cash Receipts record with New exchange rate Information');
587: arp_cash_rec.upd_cash_receipts(new_adj.new_exchange_date,
588: new_adj.new_exchange_rate,
589: new_adj.new_exchange_rate_type,
590: new_adj.cash_receipt_id,

Line 714: arp_standard.debug('Create distributions for the new CRH reord');

710:
711:
712: --HYU distribution for the new cash receipt history record with the new exchange rate info
713:
714: arp_standard.debug('Create distributions for the new CRH reord');
715: OPEN c_distrib(old_crh.cash_receipt_history_id,'CRH',old_crh.status);
716: LOOP
717: FETCH c_distrib INTO l_distrib_rec;
718: EXIT WHEN c_distrib%NOTFOUND;

Line 816: arp_standard.debug(' Receipt Amount is zero.');

812: distribution amount separately */
813: /*
814: IF old_crh.amount = 0 AND old_crh.status <> 'APPROVED' THEN
815: IF PG_DEBUG in ('Y', 'C') THEN
816: arp_standard.debug(' Receipt Amount is zero.');
817: arp_standard.debug('old_crh_id = '||to_char(old_crh_id));
818: arp_standard.debug('new_crh_id = '||to_char(new_crh_id));
819: END IF;
820: SELECT decode( old_crh.status,

Line 817: arp_standard.debug('old_crh_id = '||to_char(old_crh_id));

813: /*
814: IF old_crh.amount = 0 AND old_crh.status <> 'APPROVED' THEN
815: IF PG_DEBUG in ('Y', 'C') THEN
816: arp_standard.debug(' Receipt Amount is zero.');
817: arp_standard.debug('old_crh_id = '||to_char(old_crh_id));
818: arp_standard.debug('new_crh_id = '||to_char(new_crh_id));
819: END IF;
820: SELECT decode( old_crh.status,
821: 'CONFIRMED','CONFIRMATION',

Line 818: arp_standard.debug('new_crh_id = '||to_char(new_crh_id));

814: IF old_crh.amount = 0 AND old_crh.status <> 'APPROVED' THEN
815: IF PG_DEBUG in ('Y', 'C') THEN
816: arp_standard.debug(' Receipt Amount is zero.');
817: arp_standard.debug('old_crh_id = '||to_char(old_crh_id));
818: arp_standard.debug('new_crh_id = '||to_char(new_crh_id));
819: END IF;
820: SELECT decode( old_crh.status,
821: 'CONFIRMED','CONFIRMATION',
822: 'REMITTED', 'REMITTANCE',

Line 841: arp_standard.debug('line_id = ' ||to_char(l_dummy));

837: l_dist_rec.created_by := new_cb;
838:
839: arp_distributions_pkg.insert_p(l_dist_rec, l_dummy);
840: IF PG_DEBUG in ('Y', 'C') THEN
841: arp_standard.debug('line_id = ' ||to_char(l_dummy));
842: END IF;
843:
844: l_dist_rec.line_id := l_dummy;
845: END IF;

Line 850: arp_standard.debug('Create the CRH record for reversing the CRH before rate adjustment');

846: */
847:
848:
849:
850: arp_standard.debug('Create the CRH record for reversing the CRH before rate adjustment');
851:
852: old_crh_reverse_rec := old_old_crh;
853:
854: old_crh_reverse_rec.amount := -old_crh_reverse_rec.amount;

Line 918: arp_standard.debug('Creating the offset distributions');

914: created_from => old_crh_reverse_rec.created_from,
915: reversal_created_from => old_crh_reverse_rec.reversal_created_from);
916:
917:
918: arp_standard.debug('Creating the offset distributions');
919: OPEN c_distrib(old_old_crh.cash_receipt_history_id,'CRH',old_old_crh.status);
920: LOOP
921: FETCH c_distrib INTO l_distrib_rec;
922: EXIT WHEN c_distrib%NOTFOUND;

Line 1052: new_acctd_amount := arp_standard.functional_amount(amt_due_remaining,

1048: | Calculate New ACCTD_AMOUNT |
1049: *-----------------------------*/
1050: amt_due_remaining := amt_due_remaining - old_misc.amount;
1051:
1052: new_acctd_amount := arp_standard.functional_amount(amt_due_remaining,
1053: cr.functional_currency,
1054: new_adj.new_exchange_rate,
1055: NULL,
1056: NULL);

Line 1125: arp_standard.debug('main: ' || 'new_adj gl_date ' || new_adj.gl_date);

1121: FETCH ar_rc_rec into l_rc_app;
1122: /* call the receipt api to unapply the cCR on the cash receipt - pkt */
1123: BEGIN
1124: IF PG_DEBUG in ('Y', 'C') THEN
1125: arp_standard.debug('main: ' || 'new_adj gl_date ' || new_adj.gl_date);
1126: arp_standard.debug('main: ' || 'old_misc gl_date ' ||old_misc.gl_date);
1127: arp_standard.debug('bal due remain ' ||l_bal_due_remaining);
1128: END IF;
1129:

Line 1126: arp_standard.debug('main: ' || 'old_misc gl_date ' ||old_misc.gl_date);

1122: /* call the receipt api to unapply the cCR on the cash receipt - pkt */
1123: BEGIN
1124: IF PG_DEBUG in ('Y', 'C') THEN
1125: arp_standard.debug('main: ' || 'new_adj gl_date ' || new_adj.gl_date);
1126: arp_standard.debug('main: ' || 'old_misc gl_date ' ||old_misc.gl_date);
1127: arp_standard.debug('bal due remain ' ||l_bal_due_remaining);
1128: END IF;
1129:
1130: arp_process_application.reverse(

Line 1127: arp_standard.debug('bal due remain ' ||l_bal_due_remaining);

1123: BEGIN
1124: IF PG_DEBUG in ('Y', 'C') THEN
1125: arp_standard.debug('main: ' || 'new_adj gl_date ' || new_adj.gl_date);
1126: arp_standard.debug('main: ' || 'old_misc gl_date ' ||old_misc.gl_date);
1127: arp_standard.debug('bal due remain ' ||l_bal_due_remaining);
1128: END IF;
1129:
1130: arp_process_application.reverse(
1131: l_rc_app.receivable_application_id,

Line 1142: arp_standard.debug('main: ' || 'EXCEPTION in unapplying the

1138:
1139: EXCEPTION
1140: WHEN others THEN
1141: IF PG_DEBUG in ('Y', 'C') THEN
1142: arp_standard.debug('main: ' || 'EXCEPTION in unapplying the
1143: CCR for the MISC recipt in ARP_RATE_ADJ.MAIN');
1144: arp_standard.debug('main: ' || SQLERRM(SQLCODE));
1145: END IF;
1146: raise;

Line 1144: arp_standard.debug('main: ' || SQLERRM(SQLCODE));

1140: WHEN others THEN
1141: IF PG_DEBUG in ('Y', 'C') THEN
1142: arp_standard.debug('main: ' || 'EXCEPTION in unapplying the
1143: CCR for the MISC recipt in ARP_RATE_ADJ.MAIN');
1144: arp_standard.debug('main: ' || SQLERRM(SQLCODE));
1145: END IF;
1146: raise;
1147: close ar_rc_rec;
1148: END;

Line 1213: arp_standard.debug('main: ' || 'EXCEPTION in applying the

1209:
1210: EXCEPTION
1211: WHEN others THEN
1212: IF PG_DEBUG in ('Y', 'C') THEN
1213: arp_standard.debug('main: ' || 'EXCEPTION in applying the
1214: CCR for the MISC recipt in ARP_RATE_ADJ.MAIN');
1215: arp_standard.debug('main: ' || SQLERRM(SQLCODE));
1216: END IF;
1217: raise;

Line 1215: arp_standard.debug('main: ' || SQLERRM(SQLCODE));

1211: WHEN others THEN
1212: IF PG_DEBUG in ('Y', 'C') THEN
1213: arp_standard.debug('main: ' || 'EXCEPTION in applying the
1214: CCR for the MISC recipt in ARP_RATE_ADJ.MAIN');
1215: arp_standard.debug('main: ' || SQLERRM(SQLCODE));
1216: END IF;
1217: raise;
1218: close ar_rc_rec;
1219: END;

Line 1231: cr_acctd_amount := arp_standard.functional_amount(cr.amount,

1227: /*-----------------------------------------------------------------*
1228: | Update Payment Schedules Record, resetting amount_due_remaining |
1229: | and change exchange rate information |
1230: *-----------------------------------------------------------------*/
1231: cr_acctd_amount := arp_standard.functional_amount(cr.amount,
1232: cr.functional_currency,
1233: new_adj.new_exchange_rate,
1234: NULL,
1235: NULL);

Line 1592: new_ps_acctd_amount := arp_standard.functional_amount

1588: ps_remaining.amount_due_remaining :=
1589: ps_remaining.amount_due_remaining +
1590: nvl(old_rec_app.amount_applied_from, old_rec_app.amount_applied);
1591:
1592: new_ps_acctd_amount := arp_standard.functional_amount
1593: (ps_remaining.amount_due_remaining,
1594: cr.functional_currency,
1595: new_adj.new_exchange_rate,
1596: NULL,

Line 1648: app_acctd_amount := arp_standard.functional_amount

1644:
1645: END IF;
1646: ELSE
1647:
1648: app_acctd_amount := arp_standard.functional_amount
1649: (old_rec_app.amount_applied,
1650: cr.functional_currency,
1651: new_adj.new_exchange_rate,
1652: NULL,

Line 2305: --arp_standard.debug('HYU-5');

2301: l_ae_doc_rec.other_flag := '';
2302: arp_acct_main.Create_Acct_Entry(l_ae_doc_rec);
2303:
2304: END IF;
2305: --arp_standard.debug('HYU-5');
2306:
2307: /* Bug No. 3825830
2308: Update the gl_date_closed of reciept in the payment schedules if the status is closed and
2309: the current gl_date closed is less than gl_date of the rate adjustment */

Line 2324: arp_standard.debug( '<< ARBRAD MAIN' );

2320: END IF;
2321: END IF;
2322: --
2323: IF PG_DEBUG in ('Y', 'C') THEN
2324: arp_standard.debug( '<< ARBRAD MAIN' );
2325: END IF;
2326: EXCEPTION
2327: WHEN claim_create_api_error THEN
2328: IF PG_DEBUG in ('Y', 'C') THEN

Line 2329: arp_standard.debug('claim_create_api_error - ARP_RATE_ADJ.MAIN' );

2325: END IF;
2326: EXCEPTION
2327: WHEN claim_create_api_error THEN
2328: IF PG_DEBUG in ('Y', 'C') THEN
2329: arp_standard.debug('claim_create_api_error - ARP_RATE_ADJ.MAIN' );
2330: END IF;
2331: RAISE;
2332:
2333: WHEN claim_cancel_api_error THEN

Line 2335: arp_standard.debug('claim_cancel_api_error - ARP_RATE_ADJ.MAIN' );

2331: RAISE;
2332:
2333: WHEN claim_cancel_api_error THEN
2334: IF PG_DEBUG in ('Y', 'C') THEN
2335: arp_standard.debug('claim_cancel_api_error - ARP_RATE_ADJ.MAIN' );
2336: END IF;
2337: RAISE;
2338:
2339: WHEN OTHERS THEN

Line 2341: arp_standard.debug('EXCEPTION: ARP_RATE_ADJ.MAIN');

2337: RAISE;
2338:
2339: WHEN OTHERS THEN
2340: IF PG_DEBUG in ('Y', 'C') THEN
2341: arp_standard.debug('EXCEPTION: ARP_RATE_ADJ.MAIN');
2342: arp_standard.debug('EXCEPTION OTHERS: '||SQLERRM);
2343:
2344: END IF;
2345: RAISE;

Line 2342: arp_standard.debug('EXCEPTION OTHERS: '||SQLERRM);

2338:
2339: WHEN OTHERS THEN
2340: IF PG_DEBUG in ('Y', 'C') THEN
2341: arp_standard.debug('EXCEPTION: ARP_RATE_ADJ.MAIN');
2342: arp_standard.debug('EXCEPTION OTHERS: '||SQLERRM);
2343:
2344: END IF;
2345: RAISE;
2346: --