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.AR_RECEIPT_LIB_PVT dependencies on GL_CURRENCY_API

Line 1174: l_exchange_rate := gl_currency_api.get_rate(

1170: END LOOP;
1171:
1172: --the rate is not in the cache so get it from the database.
1173: */
1174: l_exchange_rate := gl_currency_api.get_rate(
1175: l_set_of_books_id,
1176: p_currency_code,
1177: p_exchange_rate_date,
1178: p_exchange_rate_type

Line 1195: WHEN gl_currency_api.NO_RATE THEN

1191: IF PG_DEBUG in ('Y', 'C') THEN
1192: arp_util.debug('Find_Cached_Exchange_Rate ()-');
1193: END IF;
1194: EXCEPTION
1195: WHEN gl_currency_api.NO_RATE THEN
1196: --rate does not exist set appropriate message.
1197: --p_return_status := FND_API.G_RET_STS_ERROR ;
1198: return(null);
1199: IF PG_DEBUG in ('Y', 'C') THEN

Line 1200: arp_util.debug('Find_Cached_Exchange_Rate: ' || 'Exception : gl_currency_api.NO_RATE ');

1196: --rate does not exist set appropriate message.
1197: --p_return_status := FND_API.G_RET_STS_ERROR ;
1198: return(null);
1199: IF PG_DEBUG in ('Y', 'C') THEN
1200: arp_util.debug('Find_Cached_Exchange_Rate: ' || 'Exception : gl_currency_api.NO_RATE ');
1201: END IF;
1202: WHEN gl_currency_api.INVALID_CURRENCY THEN
1203: -- invalid currency set appropriate message.
1204: --p_return_status := FND_API.G_RET_STS_ERROR ;

Line 1202: WHEN gl_currency_api.INVALID_CURRENCY THEN

1198: return(null);
1199: IF PG_DEBUG in ('Y', 'C') THEN
1200: arp_util.debug('Find_Cached_Exchange_Rate: ' || 'Exception : gl_currency_api.NO_RATE ');
1201: END IF;
1202: WHEN gl_currency_api.INVALID_CURRENCY THEN
1203: -- invalid currency set appropriate message.
1204: --p_return_status := FND_API.G_RET_STS_ERROR ;
1205: return(null);
1206: IF PG_DEBUG in ('Y', 'C') THEN

Line 1207: arp_util.debug('Find_Cached_Exchange_Rate: ' || 'Exception: gl_currency_api.INVALID_CURRENCY ');

1203: -- invalid currency set appropriate message.
1204: --p_return_status := FND_API.G_RET_STS_ERROR ;
1205: return(null);
1206: IF PG_DEBUG in ('Y', 'C') THEN
1207: arp_util.debug('Find_Cached_Exchange_Rate: ' || 'Exception: gl_currency_api.INVALID_CURRENCY ');
1208: END IF;
1209: WHEN others THEN
1210: IF PG_DEBUG in ('Y', 'C') THEN
1211: arp_util.debug('EXCEPTION: Find_Cached_Exchange_Rate() ');

Line 1600: gl_currency_api.get_relation(

1596: euro_code VARCHAR2(15);
1597: l_cross_rate NUMBER;
1598: BEGIN
1599:
1600: gl_currency_api.get_relation(
1601: p_from_currency,
1602: p_to_currency,
1603: trunc(p_exchange_rate_date),
1604: l_fixed_rate,

Line 1606: euro_code := gl_currency_api.get_euro_code;

1602: p_to_currency,
1603: trunc(p_exchange_rate_date),
1604: l_fixed_rate,
1605: l_relationship);
1606: euro_code := gl_currency_api.get_euro_code;
1607:
1608: IF (l_relationship = 'EMU-OTHER') THEN
1609: l_euro_to_emu_rate :=
1610: gl_currency_api.get_rate(

Line 1610: gl_currency_api.get_rate(

1606: euro_code := gl_currency_api.get_euro_code;
1607:
1608: IF (l_relationship = 'EMU-OTHER') THEN
1609: l_euro_to_emu_rate :=
1610: gl_currency_api.get_rate(
1611: euro_code,
1612: p_from_currency,
1613: trunc(p_exchange_rate_date),
1614: NULL);

Line 1617: gl_currency_api.get_rate(

1613: trunc(p_exchange_rate_date),
1614: NULL);
1615: ELSIF (l_relationship = 'OTHER-EMU') THEN
1616: l_euro_to_emu_rate :=
1617: gl_currency_api.get_rate(
1618: euro_code,
1619: p_to_currency,
1620: trunc(p_exchange_rate_date),
1621: NULL);

Line 2418: (gl_currency_api.is_fixed_rate(

2414:
2415: --get the default only if p_trans_to_receipt_rate has not been entered by
2416: --user
2417: IF p_trans_to_receipt_rate IS NULL AND
2418: (gl_currency_api.is_fixed_rate(
2419: p_cr_currency_code,
2420: p_trx_currency_code,
2421: p_cr_date
2422: ) <> 'Y') THEN

Line 2435: l_temp_rate := gl_currency_api.get_rate(

2431: --and the default CROSS_CURRENCY_RATE_TYPE exists
2432: --try to get the rate from gl
2433:
2434: BEGIN
2435: l_temp_rate := gl_currency_api.get_rate(
2436: p_trx_currency_code,
2437: p_cr_currency_code,
2438: p_cr_date,
2439: l_exchange_rate_type);

Line 2441: WHEN gl_currency_api.NO_RATE THEN

2437: p_cr_currency_code,
2438: p_cr_date,
2439: l_exchange_rate_type);
2440: EXCEPTION
2441: WHEN gl_currency_api.NO_RATE THEN
2442: --rate does not exist set appropriate message.
2443: --p_return_status := FND_API.G_RET_STS_ERROR ;
2444: l_temp_rate := NULL;
2445: IF PG_DEBUG in ('Y', 'C') THEN

Line 2446: arp_util.debug('Default_trans_to_receipt_rate: ' || 'Exception : gl_currency_api.NO_RATE ');

2442: --rate does not exist set appropriate message.
2443: --p_return_status := FND_API.G_RET_STS_ERROR ;
2444: l_temp_rate := NULL;
2445: IF PG_DEBUG in ('Y', 'C') THEN
2446: arp_util.debug('Default_trans_to_receipt_rate: ' || 'Exception : gl_currency_api.NO_RATE ');
2447: END IF;
2448: WHEN gl_currency_api.INVALID_CURRENCY THEN
2449: -- invalid currency set appropriate message.
2450: --p_return_status := FND_API.G_RET_STS_ERROR ;

Line 2448: WHEN gl_currency_api.INVALID_CURRENCY THEN

2444: l_temp_rate := NULL;
2445: IF PG_DEBUG in ('Y', 'C') THEN
2446: arp_util.debug('Default_trans_to_receipt_rate: ' || 'Exception : gl_currency_api.NO_RATE ');
2447: END IF;
2448: WHEN gl_currency_api.INVALID_CURRENCY THEN
2449: -- invalid currency set appropriate message.
2450: --p_return_status := FND_API.G_RET_STS_ERROR ;
2451: l_temp_rate := NULL;
2452: IF PG_DEBUG in ('Y', 'C') THEN

Line 2453: arp_util.debug('Default_trans_to_receipt_rate: ' || 'Exception: gl_currency_api.INVALID_CURRENCY ');

2449: -- invalid currency set appropriate message.
2450: --p_return_status := FND_API.G_RET_STS_ERROR ;
2451: l_temp_rate := NULL;
2452: IF PG_DEBUG in ('Y', 'C') THEN
2453: arp_util.debug('Default_trans_to_receipt_rate: ' || 'Exception: gl_currency_api.INVALID_CURRENCY ');
2454: END IF;
2455: END;
2456: END IF ;
2457:

Line 2458: ELSIF gl_currency_api.is_fixed_rate(

2454: END IF;
2455: END;
2456: END IF ;
2457:
2458: ELSIF gl_currency_api.is_fixed_rate(
2459: p_cr_currency_code,
2460: p_trx_currency_code,
2461: p_cr_date
2462: ) = 'Y' THEN

Line 2466: l_temp_rate := gl_currency_api.get_rate(

2462: ) = 'Y' THEN
2463: --In case of fixed relationship get the fixed rate and return it.
2464:
2465: BEGIN
2466: l_temp_rate := gl_currency_api.get_rate(
2467: p_trx_currency_code,
2468: p_cr_currency_code,
2469: p_cr_date,
2470: l_exchange_rate_type

Line 2473: WHEN gl_currency_api.NO_RATE THEN

2469: p_cr_date,
2470: l_exchange_rate_type
2471: );
2472: EXCEPTION
2473: WHEN gl_currency_api.NO_RATE THEN
2474: --rate does not exist set appropriate message.
2475: --p_return_status := FND_API.G_RET_STS_ERROR ;
2476: l_temp_rate := NULL;
2477: IF PG_DEBUG in ('Y', 'C') THEN

Line 2478: arp_util.debug('Default_trans_to_receipt_rate: ' || 'Exception : gl_currency_api.NO_RATE ');

2474: --rate does not exist set appropriate message.
2475: --p_return_status := FND_API.G_RET_STS_ERROR ;
2476: l_temp_rate := NULL;
2477: IF PG_DEBUG in ('Y', 'C') THEN
2478: arp_util.debug('Default_trans_to_receipt_rate: ' || 'Exception : gl_currency_api.NO_RATE ');
2479: END IF;
2480: WHEN gl_currency_api.INVALID_CURRENCY THEN
2481: -- invalid currency set appropriate message.
2482: --p_return_status := FND_API.G_RET_STS_ERROR ;

Line 2480: WHEN gl_currency_api.INVALID_CURRENCY THEN

2476: l_temp_rate := NULL;
2477: IF PG_DEBUG in ('Y', 'C') THEN
2478: arp_util.debug('Default_trans_to_receipt_rate: ' || 'Exception : gl_currency_api.NO_RATE ');
2479: END IF;
2480: WHEN gl_currency_api.INVALID_CURRENCY THEN
2481: -- invalid currency set appropriate message.
2482: --p_return_status := FND_API.G_RET_STS_ERROR ;
2483: l_temp_rate := NULL;
2484: IF PG_DEBUG in ('Y', 'C') THEN

Line 2485: arp_util.debug('Default_trans_to_receipt_rate: ' || 'Exception: gl_currency_api.INVALID_CURRENCY ');

2481: -- invalid currency set appropriate message.
2482: --p_return_status := FND_API.G_RET_STS_ERROR ;
2483: l_temp_rate := NULL;
2484: IF PG_DEBUG in ('Y', 'C') THEN
2485: arp_util.debug('Default_trans_to_receipt_rate: ' || 'Exception: gl_currency_api.INVALID_CURRENCY ');
2486: END IF;
2487: END;
2488:
2489: IF p_trans_to_receipt_rate IS NOT NULL THEN

Line 3253: IF ( (gl_currency_api.is_fixed_rate(

3249: l_exchange_rate_type := pg_profile_cc_rate_type;
3250: IF PG_DEBUG in ('Y', 'C') THEN
3251: arp_util.debug('Default_disc_and_amt_applied: ' || 'default cross currency exchange rate type :'||l_exchange_rate_type);
3252: END IF;
3253: IF ( (gl_currency_api.is_fixed_rate(
3254: p_cr_currency_code,
3255: p_trx_currency_code,
3256: p_cr_date
3257: ) = 'Y' ) OR

Line 3279: l_convert_amount_inv := gl_currency_api.convert_amount(

3275: b) receipt amount in transaction currency
3276: and assign the appropriate converted amount to l_applied_in_amount below */
3277:
3278: -- invoice amount in receipt currency
3279: l_convert_amount_inv := gl_currency_api.convert_amount(
3280: p_trx_currency_code,
3281: p_cr_currency_code,
3282: p_cr_date,
3283: l_exchange_rate_type,

Line 3287: l_convert_amount_cr := gl_currency_api.convert_amount(

3283: l_exchange_rate_type,
3284: p_amount_due_remaining);
3285:
3286: -- receipt amount in invoice currency
3287: l_convert_amount_cr := gl_currency_api.convert_amount(
3288: p_cr_currency_code,
3289: p_trx_currency_code,
3290: p_cr_date,
3291: l_exchange_rate_type,

Line 3301: WHEN gl_currency_api.NO_RATE THEN

3297: END IF;
3298:
3299:
3300: EXCEPTION
3301: WHEN gl_currency_api.NO_RATE THEN
3302: l_convert_amount_inv := NULL;
3303: l_convert_amount_cr := NULL;
3304: IF PG_DEBUG in ('Y', 'C') THEN
3305: arp_util.debug('Default_disc_and_amt_applied: ' || 'No rate exists in the GL for the cross currency conversion ');

Line 3307: WHEN gl_currency_api.INVALID_CURRENCY THEN

3303: l_convert_amount_cr := NULL;
3304: IF PG_DEBUG in ('Y', 'C') THEN
3305: arp_util.debug('Default_disc_and_amt_applied: ' || 'No rate exists in the GL for the cross currency conversion ');
3306: END IF;
3307: WHEN gl_currency_api.INVALID_CURRENCY THEN
3308: IF PG_DEBUG in ('Y', 'C') THEN
3309: arp_util.debug('Default_disc_and_amt_applied: ' || 'The Receipt/Invoice currency is Invalid ');
3310: END IF;
3311: raise;