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_CASHBOOK dependencies on ARP_CASHBOOK

Line 1: PACKAGE BODY ARP_CASHBOOK AS

1: PACKAGE BODY ARP_CASHBOOK AS
2: /*$Header: ARRECBKB.pls 120.29.12020000.6 2013/02/20 18:25:35 rravikir ship $*/
3: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
4:
5: g_refresh_running VARCHAR2(1);

Line 93: arp_util.debug( '>>>>>>> arp_cashbook.clear' );

89: arp_standard.debug('p_trx_date :'||p_trx_date);
90: arp_standard.debug('p_gl_date :'||p_gl_date);
91: arp_standard.debug('p_actual_value_date :'||p_actual_value_date);
92:
93: arp_util.debug( '>>>>>>> arp_cashbook.clear' );
94: END IF;
95:
96: -- Bug 7443802
97:

Line 529: l_crh_rec_new.created_from := substrb(p_module_name||'ARP_CASHBOOK.CLEAR',1,30);

525: l_crh_rec_new.prv_stat_cash_receipt_hist_id := l_crh_rec_old.prv_stat_cash_receipt_hist_id;
526: ELSE
527: l_crh_rec_new.prv_stat_cash_receipt_hist_id := l_crh_rec_old.cash_receipt_history_id;
528: END IF;
529: l_crh_rec_new.created_from := substrb(p_module_name||'ARP_CASHBOOK.CLEAR',1,30);
530: l_crh_rec_new.reversal_created_from := NULL;
531: arp_cr_history_pkg.insert_p( l_crh_rec_new, l_crh_rec_new.cash_receipt_history_id );
532:
533: -- Update the old history record

Line 538: l_crh_rec_old.reversal_created_from := substrb(p_module_name||'ARP_CASHBOOK.CLEAR',1,30);

534: l_crh_rec_old.current_record_flag := NULL;
535: l_crh_rec_old.reversal_gl_date := p_gl_date;
536: l_crh_rec_old.reversal_cash_receipt_hist_id := l_crh_rec_new.cash_receipt_history_id;
537: l_crh_rec_old.reversal_posting_control_id := -3;
538: l_crh_rec_old.reversal_created_from := substrb(p_module_name||'ARP_CASHBOOK.CLEAR',1,30);
539: arp_cr_history_pkg.update_p( l_crh_rec_old );
540:
541: --Bug#2750340
542: --{BUG#5051143 - the cash book call is document based not request based

Line 937: l_radj_rec.created_from := substrb(p_module_name||'ARP_CASHBOOK.CLEAR',1,30);

933: l_radj_rec.old_exchange_rate := l_crh_rec_old.exchange_rate;
934: l_radj_rec.old_exchange_rate_type:= l_crh_rec_old.exchange_rate_type;
935: l_radj_rec.gl_posted_date := NULL;
936: l_radj_rec.posting_control_id := -3;
937: l_radj_rec.created_from := substrb(p_module_name||'ARP_CASHBOOK.CLEAR',1,30);
938: arp_rate_adjustments_pkg.insert_p( l_radj_rec,l_radj_rec.rate_adjustment_id );
939:
940: arp_rate_adj.main(
941: p_cr_id,

Line 1040: arp_util.debug( '<<<<<<< arp_cashbook.clear' );

1036: END IF;
1037:
1038: IF PG_DEBUG in ('Y', 'C') THEN
1039: arp_util.debug(' g_refresh_running = ' || g_refresh_running);
1040: arp_util.debug( '<<<<<<< arp_cashbook.clear' );
1041: END IF;
1042:
1043: EXCEPTION
1044: WHEN settlement_pending_raise then

Line 1048: arp_util.debug( 'EXCEPTION: ARP_CASHBOOK.clear' );

1044: WHEN settlement_pending_raise then
1045: APP_EXCEPTION.RAISE_EXCEPTION;
1046: WHEN OTHERS THEN
1047: IF PG_DEBUG in ('Y', 'C') THEN
1048: arp_util.debug( 'EXCEPTION: ARP_CASHBOOK.clear' );
1049: END IF;
1050: RAISE;
1051:
1052: END clear;

Line 1084: arp_util.debug( '>>>>>>> arp_cashbook.unclear' );

1080:
1081: BEGIN
1082:
1083: IF PG_DEBUG in ('Y', 'C') THEN
1084: arp_util.debug( '>>>>>>> arp_cashbook.unclear' );
1085: END IF;
1086:
1087:
1088: --Setting the Org Context Bug5212892

Line 1183: l_radj_rec.created_from := substrb(p_module_name||'ARP_CASHBOOK.UNCLEAR',1,30);

1179: l_radj_rec.old_exchange_rate := l_crh_rec_old.exchange_rate;
1180: l_radj_rec.old_exchange_rate_type:= l_crh_rec_old.exchange_rate_type;
1181: l_radj_rec.gl_posted_date := NULL;
1182: l_radj_rec.posting_control_id := -3;
1183: l_radj_rec.created_from := substrb(p_module_name||'ARP_CASHBOOK.UNCLEAR',1,30);
1184: arp_rate_adjustments_pkg.insert_p( l_radj_rec,l_radj_rec.rate_adjustment_id );
1185:
1186: arp_rate_adj.main(
1187: p_cr_id,

Line 1269: l_crh_rec_new.created_from := substrb(p_module_name||'ARP_CASHBOOK.UNCLEAR',1,30);

1265: l_crh_rec_new.reversal_posting_control_id := NULL;
1266: l_crh_rec_new.gl_posted_date := NULL;
1267: l_crh_rec_new.reversal_gl_posted_date := NULL;
1268: l_crh_rec_new.prv_stat_cash_receipt_hist_id := l_crh_rec_prv_stat.prv_stat_cash_receipt_hist_id;
1269: l_crh_rec_new.created_from := substrb(p_module_name||'ARP_CASHBOOK.UNCLEAR',1,30);
1270: l_crh_rec_new.reversal_created_from := NULL;
1271: arp_cr_history_pkg.insert_p( l_crh_rec_new, l_crh_rec_new.cash_receipt_history_id );
1272:
1273: /* Bug 9761480 : If rate adjustment is reversed, then update those CRH records also*/

Line 1280: l_crh_rec_old.reversal_created_from := substrb(p_module_name||'ARP_CASHBOOK.UNCLEAR',1,30);

1276: l_crh_rec_old.current_record_flag := NULL;
1277: l_crh_rec_old.reversal_gl_date := p_gl_date;
1278: l_crh_rec_old.reversal_cash_receipt_hist_id := l_new_crh_id_fr_radj;
1279: l_crh_rec_old.reversal_posting_control_id := -3;
1280: l_crh_rec_old.reversal_created_from := substrb(p_module_name||'ARP_CASHBOOK.UNCLEAR',1,30);
1281: arp_cr_history_pkg.update_p( l_crh_rec_old );
1282:
1283: /* Fetch newly created Rate Adjustment records */
1284: arp_cr_history_pkg.fetch_p( l_new_crh_id_fr_radj, l_crh_rec_fr_radj );

Line 1290: l_crh_rec_fr_radj.reversal_created_from := substrb(p_module_name||'ARP_CASHBOOK.UNCLEAR',1,30);

1286: l_crh_rec_fr_radj.current_record_flag := NULL;
1287: l_crh_rec_fr_radj.reversal_gl_date := p_gl_date;
1288: l_crh_rec_fr_radj.reversal_cash_receipt_hist_id := l_crh_rec_new.cash_receipt_history_id;
1289: l_crh_rec_fr_radj.reversal_posting_control_id := -3;
1290: l_crh_rec_fr_radj.reversal_created_from := substrb(p_module_name||'ARP_CASHBOOK.UNCLEAR',1,30);
1291: arp_cr_history_pkg.update_p( l_crh_rec_fr_radj );
1292:
1293: ELSE
1294: l_crh_rec_old.current_record_flag := NULL;

Line 1298: l_crh_rec_old.reversal_created_from := substrb(p_module_name||'ARP_CASHBOOK.UNCLEAR',1,30);

1294: l_crh_rec_old.current_record_flag := NULL;
1295: l_crh_rec_old.reversal_gl_date := p_gl_date;
1296: l_crh_rec_old.reversal_cash_receipt_hist_id := l_crh_rec_new.cash_receipt_history_id;
1297: l_crh_rec_old.reversal_posting_control_id := -3;
1298: l_crh_rec_old.reversal_created_from := substrb(p_module_name||'ARP_CASHBOOK.UNCLEAR',1,30);
1299: arp_cr_history_pkg.update_p( l_crh_rec_old );
1300:
1301: END IF;
1302:

Line 1498: arp_util.debug( '<<<<<<<< arp_cashbook.unclear' );

1494: p_crh_id := NULL;
1495: END IF;
1496:
1497: IF PG_DEBUG in ('Y', 'C') THEN
1498: arp_util.debug( '<<<<<<<< arp_cashbook.unclear' );
1499: END IF;
1500:
1501: EXCEPTION
1502: WHEN OTHERS THEN

Line 1504: arp_util.debug( 'EXCEPTION: ARP_CASHBOOK.unclear' );

1500:
1501: EXCEPTION
1502: WHEN OTHERS THEN
1503: IF PG_DEBUG in ('Y', 'C') THEN
1504: arp_util.debug( 'EXCEPTION: ARP_CASHBOOK.unclear' );
1505: END IF;
1506: RAISE;
1507:
1508: END unclear;

Line 1537: arp_util.debug( '>>>>>>> arp_cashbook.risk_eliminate' );

1533:
1534: BEGIN
1535:
1536: IF PG_DEBUG in ('Y', 'C') THEN
1537: arp_util.debug( '>>>>>>> arp_cashbook.risk_eliminate' );
1538: END IF;
1539:
1540: -- Assume this receipt has already been locked
1541:

Line 1601: l_crh_rec_new.created_from := substrb(p_module_name||'ARP_CASHBOOK.RISK_ELIMINATE',1,30);

1597: l_crh_rec_new.reversal_posting_control_id := NULL;
1598: l_crh_rec_new.gl_posted_date := NULL;
1599: l_crh_rec_new.reversal_gl_posted_date := NULL;
1600: l_crh_rec_new.prv_stat_cash_receipt_hist_id := l_crh_rec_old.cash_receipt_history_id;
1601: l_crh_rec_new.created_from := substrb(p_module_name||'ARP_CASHBOOK.RISK_ELIMINATE',1,30);
1602: l_crh_rec_new.reversal_created_from := NULL;
1603: arp_cr_history_pkg.insert_p( l_crh_rec_new, l_crh_rec_new.cash_receipt_history_id );
1604:
1605: -- Update the old history record

Line 1610: l_crh_rec_old.reversal_created_from := substrb(p_module_name||'ARP_CASHBOOK.RISK_ELIMINATE',1,30);

1606: l_crh_rec_old.current_record_flag := NULL;
1607: l_crh_rec_old.reversal_gl_date := p_gl_date;
1608: l_crh_rec_old.reversal_cash_receipt_hist_id := l_crh_rec_new.cash_receipt_history_id;
1609: l_crh_rec_old.reversal_posting_control_id := -3;
1610: l_crh_rec_old.reversal_created_from := substrb(p_module_name||'ARP_CASHBOOK.RISK_ELIMINATE',1,30);
1611: arp_cr_history_pkg.update_p( l_crh_rec_old );
1612:
1613: /* Bug 6494186 */
1614: l_risk_event_rec.xla_from_doc_id := p_cr_id;

Line 1776: arp_util.debug( '<<<<<<<< arp_cashbook.risk_eliminate' );

1772:
1773: -- Populate OUT NOCOPY parameters
1774: p_crh_id := l_crh_rec_new.cash_receipt_history_id;
1775: IF PG_DEBUG in ('Y', 'C') THEN
1776: arp_util.debug( '<<<<<<<< arp_cashbook.risk_eliminate' );
1777: END IF;
1778:
1779: EXCEPTION
1780: WHEN OTHERS THEN

Line 1782: arp_util.debug( 'EXCEPTION: ARP_CASHBOOK.risk_eliminate' );

1778:
1779: EXCEPTION
1780: WHEN OTHERS THEN
1781: IF PG_DEBUG in ('Y', 'C') THEN
1782: arp_util.debug( 'EXCEPTION: ARP_CASHBOOK.risk_eliminate' );
1783: END IF;
1784: RAISE;
1785:
1786: END risk_eliminate;

Line 1806: arp_util.debug( '>>>>>>> arp_cashbook.undo_risk_eliminate' );

1802: l_cr_rec ar_cash_receipts%ROWTYPE;
1803: BEGIN
1804:
1805: IF PG_DEBUG in ('Y', 'C') THEN
1806: arp_util.debug( '>>>>>>> arp_cashbook.undo_risk_eliminate' );
1807: END IF;
1808:
1809: -- Assume this receipt has already been locked
1810:

Line 1871: l_crh_rec_new.created_from := substrb(p_module_name||'ARP_CASHBOOK.UNDO_RISK_ELIMINATE',1,30);

1867: l_crh_rec_new.reversal_posting_control_id := NULL;
1868: l_crh_rec_new.gl_posted_date := NULL;
1869: l_crh_rec_new.reversal_gl_posted_date := NULL;
1870: l_crh_rec_new.prv_stat_cash_receipt_hist_id := l_crh_rec_old.cash_receipt_history_id;
1871: l_crh_rec_new.created_from := substrb(p_module_name||'ARP_CASHBOOK.UNDO_RISK_ELIMINATE',1,30);
1872: l_crh_rec_new.reversal_created_from := NULL;
1873: arp_cr_history_pkg.insert_p( l_crh_rec_new, l_crh_rec_new.cash_receipt_history_id );
1874:
1875: -- Update the old history record

Line 1880: l_crh_rec_old.reversal_created_from := substrb(p_module_name||'ARP_CASHBOOK.UNDO_RISK_ELIMINATE',1,30);

1876: l_crh_rec_old.current_record_flag := NULL;
1877: l_crh_rec_old.reversal_gl_date := p_gl_date;
1878: l_crh_rec_old.reversal_cash_receipt_hist_id := l_crh_rec_new.cash_receipt_history_id;
1879: l_crh_rec_old.reversal_posting_control_id := -3;
1880: l_crh_rec_old.reversal_created_from := substrb(p_module_name||'ARP_CASHBOOK.UNDO_RISK_ELIMINATE',1,30);
1881: arp_cr_history_pkg.update_p( l_crh_rec_old );
1882:
1883: -- Insert the short_term_debt account ar_distributions record
1884: /* skoukunt: comment to Fix bug 1198295

Line 1985: arp_util.debug( '<<<<<<<< arp_cashbook.undo_risk_eliminate' );

1981:
1982: -- Populate OUT NOCOPY parameters
1983: p_crh_id := l_crh_rec_new.cash_receipt_history_id;
1984: IF PG_DEBUG in ('Y', 'C') THEN
1985: arp_util.debug( '<<<<<<<< arp_cashbook.undo_risk_eliminate' );
1986: END IF;
1987:
1988: EXCEPTION
1989: WHEN OTHERS THEN

Line 1991: arp_util.debug( 'EXCEPTION: ARP_CASHBOOK.undo_risk_eliminate' );

1987:
1988: EXCEPTION
1989: WHEN OTHERS THEN
1990: IF PG_DEBUG in ('Y', 'C') THEN
1991: arp_util.debug( 'EXCEPTION: ARP_CASHBOOK.undo_risk_eliminate' );
1992: END IF;
1993: RAISE;
1994:
1995: END undo_risk_eliminate;

Line 2083: arp_util.debug( '>>>>>>> arp_cashbook.ins_misc_txn' );

2079: l_org_id NUMBER; --added by Jixun for bug#14726865
2080: BEGIN
2081:
2082: IF PG_DEBUG in ('Y', 'C') THEN
2083: arp_util.debug( '>>>>>>> arp_cashbook.ins_misc_txn' );
2084: END IF;
2085:
2086: --modified by Jixun for bug#14726865 begin
2087: /*SELECT default_acctg_distribution_set

Line 2211: arp_util.debug( '<<<<<<<< arp_cashbook.ins_misc_txn' );

2207:
2208: -- Populate OUT NOCOPY parameters
2209: p_cr_id := l_cr_id;
2210: IF PG_DEBUG in ('Y', 'C') THEN
2211: arp_util.debug( '<<<<<<<< arp_cashbook.ins_misc_txn' );
2212: END IF;
2213:
2214: EXCEPTION
2215: WHEN OTHERS THEN

Line 2217: arp_util.debug( 'EXCEPTION: arp_cashbook.ins_misc_txn' );

2213:
2214: EXCEPTION
2215: WHEN OTHERS THEN
2216: IF PG_DEBUG in ('Y', 'C') THEN
2217: arp_util.debug( 'EXCEPTION: arp_cashbook.ins_misc_txn' );
2218: END IF;
2219: RAISE;
2220:
2221: END ins_misc_txn;

Line 2255: arp_util.debug( '>>>>>>> arp_cashbook.reverse' );

2251:
2252: BEGIN
2253:
2254: IF PG_DEBUG in ('Y', 'C') THEN
2255: arp_util.debug( '>>>>>>> arp_cashbook.reverse' );
2256: END IF;
2257:
2258: -- if reversal category and reversal reason code are not
2259: -- passed in by CE, use 'NSF' as a default.

Line 2375: arp_util.debug('API Exception: arp_cashbook.reverse '||SQLERRM);

2371: +----------------------------------*/
2372: EXCEPTION
2373: WHEN API_exception THEN
2374: IF PG_DEBUG in ('Y', 'C') THEN
2375: arp_util.debug('API Exception: arp_cashbook.reverse '||SQLERRM);
2376: END IF;
2377: FND_MSG_PUB.Get (FND_MSG_PUB.G_FIRST, FND_API.G_TRUE, l_msg_data, l_msg_index);
2378: FND_MESSAGE.Set_Encoded (l_msg_data);
2379: app_exception.raise_exception;

Line 2383: arp_util.debug('Exception: arp_cashbook.reverse '||SQLERRM);

2379: app_exception.raise_exception;
2380:
2381: WHEN OTHERS THEN
2382: IF PG_DEBUG in ('Y', 'C') THEN
2383: arp_util.debug('Exception: arp_cashbook.reverse '||SQLERRM);
2384: END IF;
2385: fnd_message.set_name('AR', 'AR_BR_CANNOT_REVERSE_REC');
2386: app_exception.raise_exception;
2387:

Line 2403: arp_util.debug( '<<<<<<<< arp_cashbook.reverse' );

2399:
2400: p_crh_id := current_crh_rec.cash_receipt_history_id;
2401:
2402: IF PG_DEBUG in ('Y', 'C') THEN
2403: arp_util.debug( '<<<<<<<< arp_cashbook.reverse' );
2404: END IF;
2405:
2406: EXCEPTION
2407: WHEN OTHERS THEN

Line 2409: arp_util.debug( 'EXCEPTION: ARP_CASHBOOK.reverse' );

2405:
2406: EXCEPTION
2407: WHEN OTHERS THEN
2408: IF PG_DEBUG in ('Y', 'C') THEN
2409: arp_util.debug( 'EXCEPTION: ARP_CASHBOOK.reverse' );
2410: END IF;
2411: RAISE;
2412:
2413: END reverse;

Line 2460: arp_util.debug('>>>>>>>>>>>>> arp_cashbook.debit_memo_reversal ');

2456:
2457: BEGIN
2458:
2459: IF PG_DEBUG in ('Y', 'C') THEN
2460: arp_util.debug('>>>>>>>>>>>>> arp_cashbook.debit_memo_reversal ');
2461: END IF;
2462:
2463: OPEN applied_to_std_cur;
2464: FETCH applied_to_std_cur INTO applied_to_std_rec;

Line 2517: arp_util.debug('EXCEPTION: ARP_CASHBOOK.debit_memo_reversal');

2513:
2514: EXCEPTION
2515: WHEN OTHERS THEN
2516: IF PG_DEBUG in ('Y', 'C') THEN
2517: arp_util.debug('EXCEPTION: ARP_CASHBOOK.debit_memo_reversal');
2518: END IF;
2519: RAISE;
2520: END debit_memo_reversal;
2521:

Line 2796: ar_bus_event_sub_pvt.refresh_at_risk_value(ARP_CASHBOOK.g_customer_id_tab,

2792:
2793: -- Added for bug 16229574
2794: PROCEDURE refresh_risk_value IS
2795: BEGIN
2796: ar_bus_event_sub_pvt.refresh_at_risk_value(ARP_CASHBOOK.g_customer_id_tab,
2797: ARP_CASHBOOK.g_site_use_id_tab,
2798: ARP_CASHBOOK.g_currency_tab,
2799: ARP_CASHBOOK.g_org_id_tab);
2800:

Line 2797: ARP_CASHBOOK.g_site_use_id_tab,

2793: -- Added for bug 16229574
2794: PROCEDURE refresh_risk_value IS
2795: BEGIN
2796: ar_bus_event_sub_pvt.refresh_at_risk_value(ARP_CASHBOOK.g_customer_id_tab,
2797: ARP_CASHBOOK.g_site_use_id_tab,
2798: ARP_CASHBOOK.g_currency_tab,
2799: ARP_CASHBOOK.g_org_id_tab);
2800:
2801: ARP_CASHBOOK.g_customer_id_tab.delete;

Line 2798: ARP_CASHBOOK.g_currency_tab,

2794: PROCEDURE refresh_risk_value IS
2795: BEGIN
2796: ar_bus_event_sub_pvt.refresh_at_risk_value(ARP_CASHBOOK.g_customer_id_tab,
2797: ARP_CASHBOOK.g_site_use_id_tab,
2798: ARP_CASHBOOK.g_currency_tab,
2799: ARP_CASHBOOK.g_org_id_tab);
2800:
2801: ARP_CASHBOOK.g_customer_id_tab.delete;
2802: ARP_CASHBOOK.g_site_use_id_tab.delete;

Line 2799: ARP_CASHBOOK.g_org_id_tab);

2795: BEGIN
2796: ar_bus_event_sub_pvt.refresh_at_risk_value(ARP_CASHBOOK.g_customer_id_tab,
2797: ARP_CASHBOOK.g_site_use_id_tab,
2798: ARP_CASHBOOK.g_currency_tab,
2799: ARP_CASHBOOK.g_org_id_tab);
2800:
2801: ARP_CASHBOOK.g_customer_id_tab.delete;
2802: ARP_CASHBOOK.g_site_use_id_tab.delete;
2803: ARP_CASHBOOK.g_currency_tab.delete;

Line 2801: ARP_CASHBOOK.g_customer_id_tab.delete;

2797: ARP_CASHBOOK.g_site_use_id_tab,
2798: ARP_CASHBOOK.g_currency_tab,
2799: ARP_CASHBOOK.g_org_id_tab);
2800:
2801: ARP_CASHBOOK.g_customer_id_tab.delete;
2802: ARP_CASHBOOK.g_site_use_id_tab.delete;
2803: ARP_CASHBOOK.g_currency_tab.delete;
2804: ARP_CASHBOOK.g_org_id_tab.delete;
2805: ARP_CASHBOOK.g_unq_cust_site_cur_org_cmb.delete;

Line 2802: ARP_CASHBOOK.g_site_use_id_tab.delete;

2798: ARP_CASHBOOK.g_currency_tab,
2799: ARP_CASHBOOK.g_org_id_tab);
2800:
2801: ARP_CASHBOOK.g_customer_id_tab.delete;
2802: ARP_CASHBOOK.g_site_use_id_tab.delete;
2803: ARP_CASHBOOK.g_currency_tab.delete;
2804: ARP_CASHBOOK.g_org_id_tab.delete;
2805: ARP_CASHBOOK.g_unq_cust_site_cur_org_cmb.delete;
2806: EXCEPTION

Line 2803: ARP_CASHBOOK.g_currency_tab.delete;

2799: ARP_CASHBOOK.g_org_id_tab);
2800:
2801: ARP_CASHBOOK.g_customer_id_tab.delete;
2802: ARP_CASHBOOK.g_site_use_id_tab.delete;
2803: ARP_CASHBOOK.g_currency_tab.delete;
2804: ARP_CASHBOOK.g_org_id_tab.delete;
2805: ARP_CASHBOOK.g_unq_cust_site_cur_org_cmb.delete;
2806: EXCEPTION
2807: WHEN OTHERS THEN

Line 2804: ARP_CASHBOOK.g_org_id_tab.delete;

2800:
2801: ARP_CASHBOOK.g_customer_id_tab.delete;
2802: ARP_CASHBOOK.g_site_use_id_tab.delete;
2803: ARP_CASHBOOK.g_currency_tab.delete;
2804: ARP_CASHBOOK.g_org_id_tab.delete;
2805: ARP_CASHBOOK.g_unq_cust_site_cur_org_cmb.delete;
2806: EXCEPTION
2807: WHEN OTHERS THEN
2808: IF PG_DEBUG in ('Y', 'C') THEN

Line 2805: ARP_CASHBOOK.g_unq_cust_site_cur_org_cmb.delete;

2801: ARP_CASHBOOK.g_customer_id_tab.delete;
2802: ARP_CASHBOOK.g_site_use_id_tab.delete;
2803: ARP_CASHBOOK.g_currency_tab.delete;
2804: ARP_CASHBOOK.g_org_id_tab.delete;
2805: ARP_CASHBOOK.g_unq_cust_site_cur_org_cmb.delete;
2806: EXCEPTION
2807: WHEN OTHERS THEN
2808: IF PG_DEBUG in ('Y', 'C') THEN
2809: arp_util.debug('EXCEPTION: ARP_CASHBOOK.refresh_risk_value');

Line 2809: arp_util.debug('EXCEPTION: ARP_CASHBOOK.refresh_risk_value');

2805: ARP_CASHBOOK.g_unq_cust_site_cur_org_cmb.delete;
2806: EXCEPTION
2807: WHEN OTHERS THEN
2808: IF PG_DEBUG in ('Y', 'C') THEN
2809: arp_util.debug('EXCEPTION: ARP_CASHBOOK.refresh_risk_value');
2810: fnd_file.put_line(FND_FILE.LOG,'Error in setting refresh at risk value');
2811: END IF;
2812: RAISE;
2813: END;

Line 2822: END ARP_CASHBOOK;

2818: RETURN '$Revision: 120.29.12020000.6 $';
2819:
2820: END revision;
2821:
2822: END ARP_CASHBOOK;