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_UTIL

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

274: -- (i.e. old rate type) use the new one for comparison
275: -- with 'User'!
276:
277: IF (p_exchange_rate_type IS NOT NULL) AND (p_exchange_rate_type = 'User') THEN
278: l_acctd_receipt_amt_new := arp_util.functional_amount(
279: l_cr_rec.amount,
280: ARP_GLOBAL.functional_currency,
281: nvl(p_exchange_rate,1),
282: NULL,NULL );

Line 287: l_acctd_receipt_amt_new := arp_util.functional_amount(

283:
284: l_exchange_rate := nvl(p_exchange_rate,1);
285:
286: ELSIF (p_exchange_rate_type IS NULL) AND (l_exchange_rate_type = 'User') THEN
287: l_acctd_receipt_amt_new := arp_util.functional_amount(
288: l_cr_rec.amount,
289: ARP_GLOBAL.functional_currency,
290: nvl(l_crh_rec_old.exchange_rate,1),
291: NULL,NULL );

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

318: -- (i.e. old rate type) use the new one for comparison
319: -- with 'User'!
320:
321: IF (p_exchange_rate_type IS NOT NULL) AND (p_exchange_rate_type = 'User') THEN
322: l_crh_rec_new.acctd_amount := arp_util.functional_amount(
323: p_amount_cleared,
324: ARP_GLOBAL.functional_currency,
325: nvl(p_exchange_rate,1),
326: NULL,NULL );

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

327:
328: l_exchange_rate := nvl(p_exchange_rate,1);
329:
330: ELSIF (p_exchange_rate_type IS NULL) AND (l_exchange_rate_type = 'User') THEN
331: l_crh_rec_new.acctd_amount := arp_util.functional_amount(
332: p_amount_cleared,
333: ARP_GLOBAL.functional_currency,
334: nvl(l_crh_rec_old.exchange_rate,1),
335: NULL,NULL );

Line 377: l_convert_receipt_amt := arp_util.functional_amount

373: -- (i.e. old rate type) use the new one for comparison
374: -- with 'User'!
375:
376: IF (p_exchange_rate_type IS NOT NULL) AND (p_exchange_rate_type = 'User') THEN
377: l_convert_receipt_amt := arp_util.functional_amount
378: (l_cr_rec.amount,
379: ARP_GLOBAL.functional_currency,
380: NVL(p_exchange_rate,1),null,null);
381:

Line 385: l_convert_receipt_amt := arp_util.functional_amount

381:
382: l_exchange_rate := nvl(p_exchange_rate,1);
383:
384: ELSIF (p_exchange_rate_type IS NULL) AND (l_exchange_rate_type = 'User') THEN
385: l_convert_receipt_amt := arp_util.functional_amount
386: (l_cr_rec.amount,
387: ARP_GLOBAL.functional_currency,
388: NVL(l_crh_rec_old.exchange_rate,1),null,null);
389:

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

420: -- (i.e. old rate type) use the new one for comparison
421: -- with 'User'!
422:
423: IF (p_exchange_rate_type IS NOT NULL) AND (p_exchange_rate_type = 'User') THEN
424: l_crh_rec_new.amount := arp_util.functional_amount(
425: p_amount_cleared,
426: l_cr_rec.currency_code,
427: 1/nvl(p_exchange_rate,1),
428: NULL,NULL );

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

429:
430: l_exchange_rate := 1/nvl(p_exchange_rate,1);
431:
432: ELSIF (p_exchange_rate_type IS NULL) AND (l_exchange_rate_type = 'User') THEN
433: l_crh_rec_new.amount := arp_util.functional_amount(
434: p_amount_cleared,
435: l_cr_rec.currency_code,
436: 1/nvl(l_crh_rec_old.exchange_rate,1),
437: NULL,NULL );

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

919: IF ( (l_crh_rec_old.acctd_amount + NVL(l_crh_rec_old.acctd_factor_discount_amount,0) )
920: <> (l_crh_rec_new.acctd_amount + NVL(l_crh_rec_new.acctd_factor_discount_amount,0)))
921: THEN
922: l_radj_rec.cash_receipt_id := p_cr_id;
923: l_radj_rec.gain_loss := arp_util.functional_amount(
924: l_cr_rec.amount,
925: ARP_GLOBAL.functional_currency,
926: (l_crh_rec_new.exchange_rate - l_crh_rec_old.exchange_rate),
927: NULL,NULL );

Line 1039: arp_util.debug(' g_refresh_running = ' || g_refresh_running);

1035: END IF;
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

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 1169: l_radj_rec.gain_loss := arp_util.functional_amount(

1165: IF ( (nvl(l_crh_rec_prv_stat.acctd_amount,1) + NVL(l_crh_rec_prv_stat.acctd_factor_discount_amount,0) )
1166: <> (nvl(l_crh_rec_old.acctd_amount,1) + NVL(l_crh_rec_old.acctd_factor_discount_amount,0)))
1167: THEN
1168: l_radj_rec.cash_receipt_id := p_cr_id;
1169: l_radj_rec.gain_loss := arp_util.functional_amount(
1170: l_cr_rec.amount,
1171: ARP_GLOBAL.functional_currency,
1172: (l_crh_rec_prv_stat.exchange_rate - l_crh_rec_old.exchange_rate),
1173: NULL,NULL );

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

1213: -- with 'User', but then we're really going to use the earlier value from
1214: -- l_crh_rec_prv_stat.exchange_rate_type.
1215:
1216: IF (l_crh_rec_prv_stat.exchange_rate_type = 'User') THEN
1217: l_crh_rec_new.acctd_amount := arp_util.functional_amount(
1218: l_crh_rec_prv_stat.amount,
1219: ARP_GLOBAL.functional_currency,
1220: nvl(l_crh_rec_prv_stat.exchange_rate,1),
1221: NULL,NULL );

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

2128: END IF;
2129: /* End Bug fix 2300268 */
2130:
2131: IF PG_DEBUG in ('Y', 'C') THEN
2132: arp_util.debug('ins_misc_txn: ' || ' ====> Receipt_number ' || p_receipt_number);
2133: arp_util.debug('ins_misc_txn: ' || ' ====> distribution_set_id ' || l_dis_set_id);
2134: END IF;
2135:
2136: -- Bugs 975560/962254: Added NULL for P_USSGL_TRANSACTION_CODE

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

2129: /* End Bug fix 2300268 */
2130:
2131: IF PG_DEBUG in ('Y', 'C') THEN
2132: arp_util.debug('ins_misc_txn: ' || ' ====> Receipt_number ' || p_receipt_number);
2133: arp_util.debug('ins_misc_txn: ' || ' ====> distribution_set_id ' || l_dis_set_id);
2134: END IF;
2135:
2136: -- Bugs 975560/962254: Added NULL for P_USSGL_TRANSACTION_CODE
2137: -- parameter.

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

2312: /*------------------------------------------------+
2313: | Write API output to the concurrent program log |
2314: +------------------------------------------------*/
2315: IF PG_DEBUG in ('Y', 'C') THEN
2316: arp_util.debug('reverse: ' || 'API error count '||to_char(NVL(l_msg_count,0)));
2317: END IF;
2318:
2319: IF NVL(l_msg_count,0) > 0 Then
2320:

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

2323: | There is one message returned by the API, so it|
2324: | has been sent out NOCOPY in the parameter x_msg_data |
2325: +------------------------------------------------*/
2326: IF PG_DEBUG in ('Y', 'C') THEN
2327: arp_util.debug('reverse: ' || l_msg_data);
2328: END IF;
2329:
2330: ELSIF l_msg_count > 1 Then
2331:

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

2337: FOR l_count IN 1..l_msg_count LOOP
2338:
2339: l_msg_data := FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,FND_API.G_FALSE);
2340: IF PG_DEBUG in ('Y', 'C') THEN
2341: arp_util.debug('reverse: ' || to_char(l_count)||' : '||l_msg_data);
2342: END IF;
2343:
2344: END LOOP;
2345:

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 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;