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.16.12000000.4 2007/10/18 08:58:15 ankausha ship $*/
3: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
4:
5: --

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

70: arp_standard.debug('p_trx_date :'||p_trx_date);
71: arp_standard.debug('p_gl_date :'||p_gl_date);
72: arp_standard.debug('p_actual_value_date :'||p_actual_value_date);
73:
74: arp_util.debug( '>>>>>>> arp_cashbook.clear' );
75: END IF;
76:
77: --Setting the Org Context Bug5212892
78: ar_mo_global_cache.populate;

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

326: l_crh_rec_new.prv_stat_cash_receipt_hist_id := l_crh_rec_old.prv_stat_cash_receipt_hist_id;
327: ELSE
328: l_crh_rec_new.prv_stat_cash_receipt_hist_id := l_crh_rec_old.cash_receipt_history_id;
329: END IF;
330: l_crh_rec_new.created_from := substrb(p_module_name||'ARP_CASHBOOK.CLEAR',1,30);
331: l_crh_rec_new.reversal_created_from := NULL;
332: arp_cr_history_pkg.insert_p( l_crh_rec_new, l_crh_rec_new.cash_receipt_history_id );
333:
334: -- Update the old history record

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

335: l_crh_rec_old.current_record_flag := NULL;
336: l_crh_rec_old.reversal_gl_date := p_gl_date;
337: l_crh_rec_old.reversal_cash_receipt_hist_id := l_crh_rec_new.cash_receipt_history_id;
338: l_crh_rec_old.reversal_posting_control_id := -3;
339: l_crh_rec_old.reversal_created_from := substrb(p_module_name||'ARP_CASHBOOK.CLEAR',1,30);
340: arp_cr_history_pkg.update_p( l_crh_rec_old );
341:
342: --Bug#2750340
343: --{BUG#5051143 - the cash book call is document based not request based

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

734: l_radj_rec.old_exchange_rate := l_crh_rec_old.exchange_rate;
735: l_radj_rec.old_exchange_rate_type:= l_crh_rec_old.exchange_rate_type;
736: l_radj_rec.gl_posted_date := NULL;
737: l_radj_rec.posting_control_id := -3;
738: l_radj_rec.created_from := substrb(p_module_name||'ARP_CASHBOOK.CLEAR',1,30);
739: arp_rate_adjustments_pkg.insert_p( l_radj_rec,l_radj_rec.rate_adjustment_id );
740:
741: arp_rate_adj.main(
742: p_cr_id,

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

765:
766: -- Populate OUT NOCOPY parameters
767: p_crh_id := l_crh_rec_new.cash_receipt_history_id;
768: IF PG_DEBUG in ('Y', 'C') THEN
769: arp_util.debug( '<<<<<<< arp_cashbook.clear' );
770: END IF;
771:
772: EXCEPTION
773: WHEN OTHERS THEN

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

771:
772: EXCEPTION
773: WHEN OTHERS THEN
774: IF PG_DEBUG in ('Y', 'C') THEN
775: arp_util.debug( 'EXCEPTION: ARP_CASHBOOK.clear' );
776: END IF;
777: RAISE;
778:
779: END clear;

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

802:
803: BEGIN
804:
805: IF PG_DEBUG in ('Y', 'C') THEN
806: arp_util.debug( '>>>>>>> arp_cashbook.unclear' );
807: END IF;
808:
809:
810: --Setting the Org Context Bug5212892

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

932: l_crh_rec_new.reversal_posting_control_id := NULL;
933: l_crh_rec_new.gl_posted_date := NULL;
934: l_crh_rec_new.reversal_gl_posted_date := NULL;
935: l_crh_rec_new.prv_stat_cash_receipt_hist_id := l_crh_rec_prv_stat.prv_stat_cash_receipt_hist_id;
936: l_crh_rec_new.created_from := substrb(p_module_name||'ARP_CASHBOOK.UNCLEAR',1,30);
937: l_crh_rec_new.reversal_created_from := NULL;
938: arp_cr_history_pkg.insert_p( l_crh_rec_new, l_crh_rec_new.cash_receipt_history_id );
939:
940: -- Update the old history record

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

941: l_crh_rec_old.current_record_flag := NULL;
942: l_crh_rec_old.reversal_gl_date := p_gl_date;
943: l_crh_rec_old.reversal_cash_receipt_hist_id := l_crh_rec_new.cash_receipt_history_id;
944: l_crh_rec_old.reversal_posting_control_id := -3;
945: l_crh_rec_old.reversal_created_from := substrb(p_module_name||'ARP_CASHBOOK.UNCLEAR',1,30);
946: arp_cr_history_pkg.update_p( l_crh_rec_old );
947:
948: --BUG#5569338
949: l_xla_ev_rec.xla_from_doc_id := p_cr_id;

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

1111: l_radj_rec.old_exchange_rate := l_crh_rec_new.exchange_rate;
1112: l_radj_rec.old_exchange_rate_type:= l_crh_rec_new.exchange_rate_type;
1113: l_radj_rec.gl_posted_date := NULL;
1114: l_radj_rec.posting_control_id := -3;
1115: l_radj_rec.created_from := substrb(p_module_name||'ARP_CASHBOOK.UNCLEAR',1,30);
1116: arp_rate_adjustments_pkg.insert_p( l_radj_rec,l_radj_rec.rate_adjustment_id );
1117:
1118: arp_rate_adj.main(
1119: p_cr_id,

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

1147: p_crh_id := NULL;
1148: END IF;
1149:
1150: IF PG_DEBUG in ('Y', 'C') THEN
1151: arp_util.debug( '<<<<<<<< arp_cashbook.unclear' );
1152: END IF;
1153:
1154: EXCEPTION
1155: WHEN OTHERS THEN

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

1153:
1154: EXCEPTION
1155: WHEN OTHERS THEN
1156: IF PG_DEBUG in ('Y', 'C') THEN
1157: arp_util.debug( 'EXCEPTION: ARP_CASHBOOK.unclear' );
1158: END IF;
1159: RAISE;
1160:
1161: END unclear;

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

1178: l_risk_event_rec arp_xla_events.xla_events_type;
1179: BEGIN
1180:
1181: IF PG_DEBUG in ('Y', 'C') THEN
1182: arp_util.debug( '>>>>>>> arp_cashbook.risk_eliminate' );
1183: END IF;
1184:
1185: -- Assume this receipt has already been locked
1186:

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

1242: l_crh_rec_new.reversal_posting_control_id := NULL;
1243: l_crh_rec_new.gl_posted_date := NULL;
1244: l_crh_rec_new.reversal_gl_posted_date := NULL;
1245: l_crh_rec_new.prv_stat_cash_receipt_hist_id := l_crh_rec_old.cash_receipt_history_id;
1246: l_crh_rec_new.created_from := substrb(p_module_name||'ARP_CASHBOOK.RISK_ELIMINATE',1,30);
1247: l_crh_rec_new.reversal_created_from := NULL;
1248: arp_cr_history_pkg.insert_p( l_crh_rec_new, l_crh_rec_new.cash_receipt_history_id );
1249:
1250: -- Update the old history record

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

1251: l_crh_rec_old.current_record_flag := NULL;
1252: l_crh_rec_old.reversal_gl_date := p_gl_date;
1253: l_crh_rec_old.reversal_cash_receipt_hist_id := l_crh_rec_new.cash_receipt_history_id;
1254: l_crh_rec_old.reversal_posting_control_id := -3;
1255: l_crh_rec_old.reversal_created_from := substrb(p_module_name||'ARP_CASHBOOK.RISK_ELIMINATE',1,30);
1256: arp_cr_history_pkg.update_p( l_crh_rec_old );
1257:
1258: /* Bug 6494186 */
1259: l_risk_event_rec.xla_from_doc_id := p_cr_id;

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

1363:
1364: -- Populate OUT NOCOPY parameters
1365: p_crh_id := l_crh_rec_new.cash_receipt_history_id;
1366: IF PG_DEBUG in ('Y', 'C') THEN
1367: arp_util.debug( '<<<<<<<< arp_cashbook.risk_eliminate' );
1368: END IF;
1369:
1370: EXCEPTION
1371: WHEN OTHERS THEN

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

1369:
1370: EXCEPTION
1371: WHEN OTHERS THEN
1372: IF PG_DEBUG in ('Y', 'C') THEN
1373: arp_util.debug( 'EXCEPTION: ARP_CASHBOOK.risk_eliminate' );
1374: END IF;
1375: RAISE;
1376:
1377: END risk_eliminate;

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

1393: l_cr_rec ar_cash_receipts%ROWTYPE;
1394: BEGIN
1395:
1396: IF PG_DEBUG in ('Y', 'C') THEN
1397: arp_util.debug( '>>>>>>> arp_cashbook.undo_risk_eliminate' );
1398: END IF;
1399:
1400: -- Assume this receipt has already been locked
1401:

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

1458: l_crh_rec_new.reversal_posting_control_id := NULL;
1459: l_crh_rec_new.gl_posted_date := NULL;
1460: l_crh_rec_new.reversal_gl_posted_date := NULL;
1461: l_crh_rec_new.prv_stat_cash_receipt_hist_id := l_crh_rec_old.cash_receipt_history_id;
1462: l_crh_rec_new.created_from := substrb(p_module_name||'ARP_CASHBOOK.UNDO_RISK_ELIMINATE',1,30);
1463: l_crh_rec_new.reversal_created_from := NULL;
1464: arp_cr_history_pkg.insert_p( l_crh_rec_new, l_crh_rec_new.cash_receipt_history_id );
1465:
1466: -- Update the old history record

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

1467: l_crh_rec_old.current_record_flag := NULL;
1468: l_crh_rec_old.reversal_gl_date := p_gl_date;
1469: l_crh_rec_old.reversal_cash_receipt_hist_id := l_crh_rec_new.cash_receipt_history_id;
1470: l_crh_rec_old.reversal_posting_control_id := -3;
1471: l_crh_rec_old.reversal_created_from := substrb(p_module_name||'ARP_CASHBOOK.UNDO_RISK_ELIMINATE',1,30);
1472: arp_cr_history_pkg.update_p( l_crh_rec_old );
1473:
1474: -- Insert the short_term_debt account ar_distributions record
1475: /* skoukunt: comment to Fix bug 1198295

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

1572:
1573: -- Populate OUT NOCOPY parameters
1574: p_crh_id := l_crh_rec_new.cash_receipt_history_id;
1575: IF PG_DEBUG in ('Y', 'C') THEN
1576: arp_util.debug( '<<<<<<<< arp_cashbook.undo_risk_eliminate' );
1577: END IF;
1578:
1579: EXCEPTION
1580: WHEN OTHERS THEN

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

1578:
1579: EXCEPTION
1580: WHEN OTHERS THEN
1581: IF PG_DEBUG in ('Y', 'C') THEN
1582: arp_util.debug( 'EXCEPTION: ARP_CASHBOOK.undo_risk_eliminate' );
1583: END IF;
1584: RAISE;
1585:
1586: END undo_risk_eliminate;

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

1666: l_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
1667: BEGIN
1668:
1669: IF PG_DEBUG in ('Y', 'C') THEN
1670: arp_util.debug( '>>>>>>> arp_cashbook.ins_misc_txn' );
1671: END IF;
1672:
1673: SELECT default_acctg_distribution_set
1674: INTO l_dis_set_id

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

1774:
1775: -- Populate OUT NOCOPY parameters
1776: p_cr_id := l_cr_id;
1777: IF PG_DEBUG in ('Y', 'C') THEN
1778: arp_util.debug( '<<<<<<<< arp_cashbook.ins_misc_txn' );
1779: END IF;
1780:
1781: EXCEPTION
1782: WHEN OTHERS THEN

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

1780:
1781: EXCEPTION
1782: WHEN OTHERS THEN
1783: IF PG_DEBUG in ('Y', 'C') THEN
1784: arp_util.debug( 'EXCEPTION: arp_cashbook.ins_misc_txn' );
1785: END IF;
1786: RAISE;
1787:
1788: END ins_misc_txn;

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

1818:
1819: BEGIN
1820:
1821: IF PG_DEBUG in ('Y', 'C') THEN
1822: arp_util.debug( '>>>>>>> arp_cashbook.reverse' );
1823: END IF;
1824:
1825: -- if reversal category and reversal reason code are not
1826: -- passed in by CE, use 'NSF' as a default.

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

1938: +----------------------------------*/
1939: EXCEPTION
1940: WHEN API_exception THEN
1941: IF PG_DEBUG in ('Y', 'C') THEN
1942: arp_util.debug('API Exception: arp_cashbook.reverse '||SQLERRM);
1943: END IF;
1944: FND_MSG_PUB.Get (FND_MSG_PUB.G_FIRST, FND_API.G_TRUE, l_msg_data, l_msg_index);
1945: FND_MESSAGE.Set_Encoded (l_msg_data);
1946: app_exception.raise_exception;

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

1946: app_exception.raise_exception;
1947:
1948: WHEN OTHERS THEN
1949: IF PG_DEBUG in ('Y', 'C') THEN
1950: arp_util.debug('Exception: arp_cashbook.reverse '||SQLERRM);
1951: END IF;
1952: fnd_message.set_name('AR', 'AR_BR_CANNOT_REVERSE_REC');
1953: app_exception.raise_exception;
1954:

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

1966:
1967: p_crh_id := current_crh_rec.cash_receipt_history_id;
1968:
1969: IF PG_DEBUG in ('Y', 'C') THEN
1970: arp_util.debug( '<<<<<<<< arp_cashbook.reverse' );
1971: END IF;
1972:
1973: EXCEPTION
1974: WHEN OTHERS THEN

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

1972:
1973: EXCEPTION
1974: WHEN OTHERS THEN
1975: IF PG_DEBUG in ('Y', 'C') THEN
1976: arp_util.debug( 'EXCEPTION: ARP_CASHBOOK.reverse' );
1977: END IF;
1978: RAISE;
1979:
1980: END reverse;

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

2023:
2024: BEGIN
2025:
2026: IF PG_DEBUG in ('Y', 'C') THEN
2027: arp_util.debug('>>>>>>>>>>>>> arp_cashbook.debit_memo_reversal ');
2028: END IF;
2029:
2030: OPEN applied_to_std_cur;
2031: FETCH applied_to_std_cur INTO applied_to_std_rec;

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

2080:
2081: EXCEPTION
2082: WHEN OTHERS THEN
2083: IF PG_DEBUG in ('Y', 'C') THEN
2084: arp_util.debug('EXCEPTION: ARP_CASHBOOK.debit_memo_reversal');
2085: END IF;
2086: RAISE;
2087: END debit_memo_reversal;
2088:

Line 2363: END ARP_CASHBOOK;

2359: RETURN '$Revision: 120.16.12000000.4 $';
2360:
2361: END revision;
2362:
2363: END ARP_CASHBOOK;