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 STANDARD

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

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

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

363: BEGIN
364: --
365: IF PG_DEBUG in ('Y', 'C') THEN
366: arp_standard.debug( '>> ARBRAD MAIN' );
367: arp_standard.debug( 'new_crid :'||new_crid);
368: arp_standard.debug( 'new_ed :'||new_ed);
369: arp_standard.debug( 'new_er :'||new_er);
370: arp_standard.debug( 'new_ert :'||new_ert);
371: arp_standard.debug( 'new_gd :'||new_gd);

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

364: --
365: IF PG_DEBUG in ('Y', 'C') THEN
366: arp_standard.debug( '>> ARBRAD MAIN' );
367: arp_standard.debug( 'new_crid :'||new_crid);
368: arp_standard.debug( 'new_ed :'||new_ed);
369: arp_standard.debug( 'new_er :'||new_er);
370: arp_standard.debug( 'new_ert :'||new_ert);
371: arp_standard.debug( 'new_gd :'||new_gd);
372: arp_standard.debug( 'new_cb :'||new_cb);

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

365: IF PG_DEBUG in ('Y', 'C') THEN
366: arp_standard.debug( '>> ARBRAD MAIN' );
367: arp_standard.debug( 'new_crid :'||new_crid);
368: arp_standard.debug( 'new_ed :'||new_ed);
369: arp_standard.debug( 'new_er :'||new_er);
370: arp_standard.debug( 'new_ert :'||new_ert);
371: arp_standard.debug( 'new_gd :'||new_gd);
372: arp_standard.debug( 'new_cb :'||new_cb);
373: arp_standard.debug( 'new_cd :'||new_cd);

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

366: arp_standard.debug( '>> ARBRAD MAIN' );
367: arp_standard.debug( 'new_crid :'||new_crid);
368: arp_standard.debug( 'new_ed :'||new_ed);
369: arp_standard.debug( 'new_er :'||new_er);
370: arp_standard.debug( 'new_ert :'||new_ert);
371: arp_standard.debug( 'new_gd :'||new_gd);
372: arp_standard.debug( 'new_cb :'||new_cb);
373: arp_standard.debug( 'new_cd :'||new_cd);
374: arp_standard.debug( 'new_lub :'||new_lub);

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

367: arp_standard.debug( 'new_crid :'||new_crid);
368: arp_standard.debug( 'new_ed :'||new_ed);
369: arp_standard.debug( 'new_er :'||new_er);
370: arp_standard.debug( 'new_ert :'||new_ert);
371: arp_standard.debug( 'new_gd :'||new_gd);
372: arp_standard.debug( 'new_cb :'||new_cb);
373: arp_standard.debug( 'new_cd :'||new_cd);
374: arp_standard.debug( 'new_lub :'||new_lub);
375: arp_standard.debug( 'new_lud :'||new_lud);

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

368: arp_standard.debug( 'new_ed :'||new_ed);
369: arp_standard.debug( 'new_er :'||new_er);
370: arp_standard.debug( 'new_ert :'||new_ert);
371: arp_standard.debug( 'new_gd :'||new_gd);
372: arp_standard.debug( 'new_cb :'||new_cb);
373: arp_standard.debug( 'new_cd :'||new_cd);
374: arp_standard.debug( 'new_lub :'||new_lub);
375: arp_standard.debug( 'new_lud :'||new_lud);
376: arp_standard.debug( 'new_lul :'||new_lul);

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

369: arp_standard.debug( 'new_er :'||new_er);
370: arp_standard.debug( 'new_ert :'||new_ert);
371: arp_standard.debug( 'new_gd :'||new_gd);
372: arp_standard.debug( 'new_cb :'||new_cb);
373: arp_standard.debug( 'new_cd :'||new_cd);
374: arp_standard.debug( 'new_lub :'||new_lub);
375: arp_standard.debug( 'new_lud :'||new_lud);
376: arp_standard.debug( 'new_lul :'||new_lul);
377: -- arp_standard.debug( 'p_rate_adjustment_id :'||p_rate_adjustment_id);

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

370: arp_standard.debug( 'new_ert :'||new_ert);
371: arp_standard.debug( 'new_gd :'||new_gd);
372: arp_standard.debug( 'new_cb :'||new_cb);
373: arp_standard.debug( 'new_cd :'||new_cd);
374: arp_standard.debug( 'new_lub :'||new_lub);
375: arp_standard.debug( 'new_lud :'||new_lud);
376: arp_standard.debug( 'new_lul :'||new_lul);
377: -- arp_standard.debug( 'p_rate_adjustment_id :'||p_rate_adjustment_id);
378: IF touch_hist_and_dist THEN

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

371: arp_standard.debug( 'new_gd :'||new_gd);
372: arp_standard.debug( 'new_cb :'||new_cb);
373: arp_standard.debug( 'new_cd :'||new_cd);
374: arp_standard.debug( 'new_lub :'||new_lub);
375: arp_standard.debug( 'new_lud :'||new_lud);
376: arp_standard.debug( 'new_lul :'||new_lul);
377: -- arp_standard.debug( 'p_rate_adjustment_id :'||p_rate_adjustment_id);
378: IF touch_hist_and_dist THEN
379: arp_standard.debug( 'touch_hist_and_dist : TRUE');

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

372: arp_standard.debug( 'new_cb :'||new_cb);
373: arp_standard.debug( 'new_cd :'||new_cd);
374: arp_standard.debug( 'new_lub :'||new_lub);
375: arp_standard.debug( 'new_lud :'||new_lud);
376: arp_standard.debug( 'new_lul :'||new_lul);
377: -- arp_standard.debug( 'p_rate_adjustment_id :'||p_rate_adjustment_id);
378: IF touch_hist_and_dist THEN
379: arp_standard.debug( 'touch_hist_and_dist : TRUE');
380: ELSE

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

373: arp_standard.debug( 'new_cd :'||new_cd);
374: arp_standard.debug( 'new_lub :'||new_lub);
375: arp_standard.debug( 'new_lud :'||new_lud);
376: arp_standard.debug( 'new_lul :'||new_lul);
377: -- arp_standard.debug( 'p_rate_adjustment_id :'||p_rate_adjustment_id);
378: IF touch_hist_and_dist THEN
379: arp_standard.debug( 'touch_hist_and_dist : TRUE');
380: ELSE
381: arp_standard.debug( 'touch_hist_and_dist : FALSE');

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

375: arp_standard.debug( 'new_lud :'||new_lud);
376: arp_standard.debug( 'new_lul :'||new_lul);
377: -- arp_standard.debug( 'p_rate_adjustment_id :'||p_rate_adjustment_id);
378: IF touch_hist_and_dist THEN
379: arp_standard.debug( 'touch_hist_and_dist : TRUE');
380: ELSE
381: arp_standard.debug( 'touch_hist_and_dist : FALSE');
382: END IF;
383: END IF;

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

377: -- arp_standard.debug( 'p_rate_adjustment_id :'||p_rate_adjustment_id);
378: IF touch_hist_and_dist THEN
379: arp_standard.debug( 'touch_hist_and_dist : TRUE');
380: ELSE
381: arp_standard.debug( 'touch_hist_and_dist : FALSE');
382: END IF;
383: END IF;
384:
385: l_mesg := '';

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

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

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

466:
467:
468: -- Accounted amount for the CRH record for BANK_CHARGES
469: new_crh.factor_discount_amount := old_crh.factor_discount_amount;
470: old_crh.acctd_amount := arp_standard.functional_amount(old_crh.amount,
471: cr.functional_currency,
472: new_adj.new_exchange_rate,
473: NULL,
474: NULL);

Line 491: arp_standard.functional_amount(old_crh.amount +

487: old_crh.acctd_factor_discount_amount := NULL;
488: new_crh.acctd_factor_discount_amount := old_crh.acctd_factor_discount_amount;
489: ELSE
490: old_crh.acctd_factor_discount_amount :=
491: arp_standard.functional_amount(old_crh.amount +
492: old_crh.factor_discount_amount,
493: cr.functional_currency,
494: new_adj.new_exchange_rate,
495: NULL,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

841: l_dist_rec.created_by := new_cb;
842:
843: arp_distributions_pkg.insert_p(l_dist_rec, l_dummy);
844: IF PG_DEBUG in ('Y', 'C') THEN
845: arp_standard.debug('line_id = ' ||to_char(l_dummy));
846: END IF;
847:
848: l_dist_rec.line_id := l_dummy;
849: END IF;

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

850: */
851:
852:
853:
854: arp_standard.debug('Create the CRH record for reversing the CRH before rate adjustment');
855:
856: old_crh_reverse_rec := old_old_crh;
857:
858: old_crh_reverse_rec.amount := -old_crh_reverse_rec.amount;

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

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

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

1061: | Calculate New ACCTD_AMOUNT |
1062: *-----------------------------*/
1063: amt_due_remaining := amt_due_remaining - old_misc.amount;
1064:
1065: new_acctd_amount := arp_standard.functional_amount(amt_due_remaining,
1066: cr.functional_currency,
1067: new_adj.new_exchange_rate,
1068: NULL,
1069: NULL);

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

1142: FETCH ar_rc_rec into l_rc_app;
1143: /* call the receipt api to unapply the cCR on the cash receipt - pkt */
1144: BEGIN
1145: IF PG_DEBUG in ('Y', 'C') THEN
1146: arp_standard.debug('main: ' || 'new_adj gl_date ' || new_adj.gl_date);
1147: arp_standard.debug('main: ' || 'old_misc gl_date ' ||old_misc.gl_date);
1148: arp_standard.debug('bal due remain ' ||l_bal_due_remaining);
1149: END IF;
1150:

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

1143: /* call the receipt api to unapply the cCR on the cash receipt - pkt */
1144: BEGIN
1145: IF PG_DEBUG in ('Y', 'C') THEN
1146: arp_standard.debug('main: ' || 'new_adj gl_date ' || new_adj.gl_date);
1147: arp_standard.debug('main: ' || 'old_misc gl_date ' ||old_misc.gl_date);
1148: arp_standard.debug('bal due remain ' ||l_bal_due_remaining);
1149: END IF;
1150:
1151: arp_process_application.reverse(

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

1144: BEGIN
1145: IF PG_DEBUG in ('Y', 'C') THEN
1146: arp_standard.debug('main: ' || 'new_adj gl_date ' || new_adj.gl_date);
1147: arp_standard.debug('main: ' || 'old_misc gl_date ' ||old_misc.gl_date);
1148: arp_standard.debug('bal due remain ' ||l_bal_due_remaining);
1149: END IF;
1150:
1151: arp_process_application.reverse(
1152: l_rc_app.receivable_application_id,

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

1159:
1160: EXCEPTION
1161: WHEN others THEN
1162: IF PG_DEBUG in ('Y', 'C') THEN
1163: arp_standard.debug('main: ' || 'EXCEPTION in unapplying the
1164: CCR for the MISC recipt in ARP_RATE_ADJ.MAIN');
1165: arp_standard.debug('main: ' || SQLERRM(SQLCODE));
1166: END IF;
1167: raise;

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

1161: WHEN others THEN
1162: IF PG_DEBUG in ('Y', 'C') THEN
1163: arp_standard.debug('main: ' || 'EXCEPTION in unapplying the
1164: CCR for the MISC recipt in ARP_RATE_ADJ.MAIN');
1165: arp_standard.debug('main: ' || SQLERRM(SQLCODE));
1166: END IF;
1167: raise;
1168: close ar_rc_rec;
1169: END;

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

1230:
1231: EXCEPTION
1232: WHEN others THEN
1233: IF PG_DEBUG in ('Y', 'C') THEN
1234: arp_standard.debug('main: ' || 'EXCEPTION in applying the
1235: CCR for the MISC recipt in ARP_RATE_ADJ.MAIN');
1236: arp_standard.debug('main: ' || SQLERRM(SQLCODE));
1237: END IF;
1238: raise;

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

1232: WHEN others THEN
1233: IF PG_DEBUG in ('Y', 'C') THEN
1234: arp_standard.debug('main: ' || 'EXCEPTION in applying the
1235: CCR for the MISC recipt in ARP_RATE_ADJ.MAIN');
1236: arp_standard.debug('main: ' || SQLERRM(SQLCODE));
1237: END IF;
1238: raise;
1239: close ar_rc_rec;
1240: END;

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

1248: /*-----------------------------------------------------------------*
1249: | Update Payment Schedules Record, resetting amount_due_remaining |
1250: | and change exchange rate information |
1251: *-----------------------------------------------------------------*/
1252: cr_acctd_amount := arp_standard.functional_amount(cr.amount,
1253: cr.functional_currency,
1254: new_adj.new_exchange_rate,
1255: NULL,
1256: NULL);

Line 1312: arp_standard.debug('l_status ' || l_status);

1308: THEN
1309: l_status := 'xxx';
1310: END;
1311:
1312: arp_standard.debug('l_status ' || l_status);
1313: select count(*) into l_count from AR_RECEIVABLE_APPLICATIONS
1314: WHERE CASH_RECEIPT_ID = cr.cash_receipt_id
1315: AND nvl(applied_payment_schedule_id,-2) <> -2;
1316:

Line 1317: arp_standard.debug('l_count ' || l_count);

1313: select count(*) into l_count from AR_RECEIVABLE_APPLICATIONS
1314: WHERE CASH_RECEIPT_ID = cr.cash_receipt_id
1315: AND nvl(applied_payment_schedule_id,-2) <> -2;
1316:
1317: arp_standard.debug('l_count ' || l_count);
1318:
1319: IF l_status ='REMITTED' and l_count = 0
1320: THEN l_br_remit_flag :='Y';
1321: ELSE

Line 1326: arp_standard.debug('l_br_remit ' || l_br_remit_flag);

1322: l_br_remit_flag :='N';
1323: END IF;
1324:
1325:
1326: arp_standard.debug('l_br_remit ' || l_br_remit_flag);
1327:
1328: FOR old_rec_app IN rec_app_info(cr.cash_receipt_id) LOOP
1329: /*------------------------------*
1330: | Create reversing Application |

Line 1651: new_ps_acctd_amount := arp_standard.functional_amount

1647: ps_remaining.amount_due_remaining :=
1648: ps_remaining.amount_due_remaining +
1649: nvl(old_rec_app.amount_applied_from, old_rec_app.amount_applied);
1650:
1651: new_ps_acctd_amount := arp_standard.functional_amount
1652: (ps_remaining.amount_due_remaining,
1653: cr.functional_currency,
1654: new_adj.new_exchange_rate,
1655: NULL,

Line 1707: app_acctd_amount := arp_standard.functional_amount

1703:
1704: END IF;
1705: ELSE
1706:
1707: app_acctd_amount := arp_standard.functional_amount
1708: (old_rec_app.amount_applied,
1709: cr.functional_currency,
1710: new_adj.new_exchange_rate,
1711: NULL,

Line 1744: arp_standard.debug('l_br_remit_flag for activity' || l_br_remit_flag);

1740: l_br_remit_flag := 'Y';
1741: ELSE
1742: l_br_remit_flag := 'N';
1743: END IF;
1744: arp_standard.debug('l_br_remit_flag for activity' || l_br_remit_flag);
1745:
1746: IF ((old_rec_app.status = 'ACTIVITY')
1747: AND (old_rec_app.applied_payment_schedule_id = -3)
1748: AND (NVL(app_acctd_amount,0) > l_max_wrt_off_amount))

Line 1944: arp_standard.debug('complement unapp-' || l_br_remit_flag);

1940: ins_ra_rec.gl_posted_date := NULL;
1941: ins_ra_rec.last_update_login := new_adj.last_update_login;
1942: ins_ra_rec.line_applied := NULL;
1943: ins_ra_rec.on_account_customer := old_rec_app.on_account_customer;
1944: arp_standard.debug('complement unapp-' || l_br_remit_flag);
1945: IF l_br_remit_flag = 'Y' THEN
1946: ins_ra_rec.postable := 'N';
1947: ELSE
1948: ins_ra_rec.postable := old_rec_app.postable;

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

2381: l_ae_doc_rec.other_flag := '';
2382: arp_acct_main.Create_Acct_Entry(l_ae_doc_rec);
2383:
2384: END IF;
2385: --arp_standard.debug('HYU-5');
2386:
2387: /* Bug No. 3825830
2388: Update the gl_date_closed of reciept in the payment schedules if the status is closed and
2389: the current gl_date closed is less than gl_date of the rate adjustment */

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

2400: END IF;
2401: END IF;
2402: --
2403: IF PG_DEBUG in ('Y', 'C') THEN
2404: arp_standard.debug( '<< ARBRAD MAIN' );
2405: END IF;
2406: EXCEPTION
2407: WHEN claim_create_api_error THEN
2408: IF PG_DEBUG in ('Y', 'C') THEN

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

2405: END IF;
2406: EXCEPTION
2407: WHEN claim_create_api_error THEN
2408: IF PG_DEBUG in ('Y', 'C') THEN
2409: arp_standard.debug('claim_create_api_error - ARP_RATE_ADJ.MAIN' );
2410: END IF;
2411: RAISE;
2412:
2413: WHEN claim_cancel_api_error THEN

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

2411: RAISE;
2412:
2413: WHEN claim_cancel_api_error THEN
2414: IF PG_DEBUG in ('Y', 'C') THEN
2415: arp_standard.debug('claim_cancel_api_error - ARP_RATE_ADJ.MAIN' );
2416: END IF;
2417: RAISE;
2418:
2419: WHEN OTHERS THEN

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

2417: RAISE;
2418:
2419: WHEN OTHERS THEN
2420: IF PG_DEBUG in ('Y', 'C') THEN
2421: arp_standard.debug('EXCEPTION: ARP_RATE_ADJ.MAIN');
2422: arp_standard.debug('EXCEPTION OTHERS: '||SQLERRM);
2423:
2424: END IF;
2425: RAISE;

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

2418:
2419: WHEN OTHERS THEN
2420: IF PG_DEBUG in ('Y', 'C') THEN
2421: arp_standard.debug('EXCEPTION: ARP_RATE_ADJ.MAIN');
2422: arp_standard.debug('EXCEPTION OTHERS: '||SQLERRM);
2423:
2424: END IF;
2425: RAISE;
2426: --