DBA Data[Home] [Help]

APPS.ARP_CASHBOOK dependencies on ARP_UTIL

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 149: l_acctd_receipt_amt_new := arp_util.functional_amount(

145: -- (i.e. old rate type) use the new one for comparison
146: -- with 'User'!
147:
148: IF (p_exchange_rate_type = 'User') THEN
149: l_acctd_receipt_amt_new := arp_util.functional_amount(
150: l_cr_rec.amount,
151: ARP_GLOBAL.functional_currency,
152: nvl(p_exchange_rate,1),
153: NULL,NULL );

Line 176: l_crh_rec_new.acctd_amount := arp_util.functional_amount(

172: -- (i.e. old rate type) use the new one for comparison
173: -- with 'User'!
174:
175: IF (p_exchange_rate_type = 'User') THEN
176: l_crh_rec_new.acctd_amount := arp_util.functional_amount(
177: p_amount_cleared,
178: ARP_GLOBAL.functional_currency,
179: nvl(p_exchange_rate,1),
180: NULL,NULL );

Line 213: l_convert_receipt_amt := arp_util.functional_amount

209: -- (i.e. old rate type) use the new one for comparison
210: -- with 'User'!
211:
212: IF (p_exchange_rate_type = 'User') THEN
213: l_convert_receipt_amt := arp_util.functional_amount
214: (l_cr_rec.amount,
215: ARP_GLOBAL.functional_currency,
216: p_exchange_rate,null,null);
217: ELSE

Line 243: l_crh_rec_new.amount := arp_util.functional_amount(

239: -- (i.e. old rate type) use the new one for comparison
240: -- with 'User'!
241:
242: IF (p_exchange_rate_type = 'User') THEN
243: l_crh_rec_new.amount := arp_util.functional_amount(
244: p_amount_cleared,
245: l_cr_rec.currency_code,
246: 1/nvl(p_exchange_rate,1),
247: NULL,NULL );

Line 724: l_radj_rec.gain_loss := arp_util.functional_amount(

720: IF ( (l_crh_rec_old.acctd_amount + NVL(l_crh_rec_old.acctd_factor_discount_amount,0) )
721: <> (l_crh_rec_new.acctd_amount + NVL(l_crh_rec_new.acctd_factor_discount_amount,0)))
722: THEN
723: l_radj_rec.cash_receipt_id := p_cr_id;
724: l_radj_rec.gain_loss := arp_util.functional_amount(
725: l_cr_rec.amount,
726: ARP_GLOBAL.functional_currency,
727: (l_crh_rec_new.exchange_rate - l_crh_rec_old.exchange_rate),
728: NULL,NULL );

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 884: l_crh_rec_new.acctd_amount := arp_util.functional_amount(

880: -- with 'User', but then we're really going to use the earlier value from
881: -- l_crh_rec_prv_stat.exchange_rate_type.
882:
883: IF (l_crh_rec_prv_stat.exchange_rate_type = 'User') THEN
884: l_crh_rec_new.acctd_amount := arp_util.functional_amount(
885: l_crh_rec_prv_stat.amount,
886: ARP_GLOBAL.functional_currency,
887: nvl(l_crh_rec_prv_stat.exchange_rate,1),
888: NULL,NULL );

Line 1101: l_radj_rec.gain_loss := arp_util.functional_amount(

1097: IF ( (nvl(l_crh_rec_prv_stat.acctd_amount,1) + NVL(l_crh_rec_prv_stat.acctd_factor_discount_amount,0) )
1098: <> (nvl(l_crh_rec_new.acctd_amount,1) + NVL(l_crh_rec_new.acctd_factor_discount_amount,0)))
1099: THEN
1100: l_radj_rec.cash_receipt_id := p_cr_id;
1101: l_radj_rec.gain_loss := arp_util.functional_amount(
1102: l_cr_rec.amount,
1103: ARP_GLOBAL.functional_currency,
1104: (l_crh_rec_prv_stat.exchange_rate - l_crh_rec_new.exchange_rate),
1105: NULL,NULL );

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 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 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 1699: arp_util.debug('ins_misc_txn: ' || ' ====> Receipt_number ' || p_receipt_number);

1695: END IF;
1696: /* End Bug fix 2300268 */
1697:
1698: IF PG_DEBUG in ('Y', 'C') THEN
1699: arp_util.debug('ins_misc_txn: ' || ' ====> Receipt_number ' || p_receipt_number);
1700: arp_util.debug('ins_misc_txn: ' || ' ====> distribution_set_id ' || l_dis_set_id);
1701: END IF;
1702:
1703: -- Bugs 975560/962254: Added NULL for P_USSGL_TRANSACTION_CODE

Line 1700: arp_util.debug('ins_misc_txn: ' || ' ====> distribution_set_id ' || l_dis_set_id);

1696: /* End Bug fix 2300268 */
1697:
1698: IF PG_DEBUG in ('Y', 'C') THEN
1699: arp_util.debug('ins_misc_txn: ' || ' ====> Receipt_number ' || p_receipt_number);
1700: arp_util.debug('ins_misc_txn: ' || ' ====> distribution_set_id ' || l_dis_set_id);
1701: END IF;
1702:
1703: -- Bugs 975560/962254: Added NULL for P_USSGL_TRANSACTION_CODE
1704: -- parameter.

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 1883: arp_util.debug('reverse: ' || 'API error count '||to_char(NVL(l_msg_count,0)));

1879: /*------------------------------------------------+
1880: | Write API output to the concurrent program log |
1881: +------------------------------------------------*/
1882: IF PG_DEBUG in ('Y', 'C') THEN
1883: arp_util.debug('reverse: ' || 'API error count '||to_char(NVL(l_msg_count,0)));
1884: END IF;
1885:
1886: IF NVL(l_msg_count,0) > 0 Then
1887:

Line 1894: arp_util.debug('reverse: ' || l_msg_data);

1890: | There is one message returned by the API, so it|
1891: | has been sent out NOCOPY in the parameter x_msg_data |
1892: +------------------------------------------------*/
1893: IF PG_DEBUG in ('Y', 'C') THEN
1894: arp_util.debug('reverse: ' || l_msg_data);
1895: END IF;
1896:
1897: ELSIF l_msg_count > 1 Then
1898:

Line 1908: arp_util.debug('reverse: ' || to_char(l_count)||' : '||l_msg_data);

1904: FOR l_count IN 1..l_msg_count LOOP
1905:
1906: l_msg_data := FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,FND_API.G_FALSE);
1907: IF PG_DEBUG in ('Y', 'C') THEN
1908: arp_util.debug('reverse: ' || to_char(l_count)||' : '||l_msg_data);
1909: END IF;
1910:
1911: END LOOP;
1912:

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: