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 1170: l_exchange_rate := gl_currency_api.get_rate(

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

Line 1191: WHEN gl_currency_api.NO_RATE THEN

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

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

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

Line 1198: WHEN gl_currency_api.INVALID_CURRENCY THEN

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

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

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

Line 1593: gl_currency_api.get_relation(

1589: euro_code VARCHAR2(15);
1590: l_cross_rate NUMBER;
1591: BEGIN
1592:
1593: gl_currency_api.get_relation(
1594: p_from_currency,
1595: p_to_currency,
1596: trunc(p_exchange_rate_date),
1597: l_fixed_rate,

Line 1599: euro_code := gl_currency_api.get_euro_code;

1595: p_to_currency,
1596: trunc(p_exchange_rate_date),
1597: l_fixed_rate,
1598: l_relationship);
1599: euro_code := gl_currency_api.get_euro_code;
1600:
1601: IF (l_relationship = 'EMU-OTHER') THEN
1602: l_euro_to_emu_rate :=
1603: gl_currency_api.get_rate(

Line 1603: gl_currency_api.get_rate(

1599: euro_code := gl_currency_api.get_euro_code;
1600:
1601: IF (l_relationship = 'EMU-OTHER') THEN
1602: l_euro_to_emu_rate :=
1603: gl_currency_api.get_rate(
1604: euro_code,
1605: p_from_currency,
1606: trunc(p_exchange_rate_date),
1607: NULL);

Line 1610: gl_currency_api.get_rate(

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

Line 2411: (gl_currency_api.is_fixed_rate(

2407:
2408: --get the default only if p_trans_to_receipt_rate has not been entered by
2409: --user
2410: IF p_trans_to_receipt_rate IS NULL AND
2411: (gl_currency_api.is_fixed_rate(
2412: p_cr_currency_code,
2413: p_trx_currency_code,
2414: p_cr_date
2415: ) <> 'Y') THEN

Line 2428: l_temp_rate := gl_currency_api.get_rate(

2424: --and the default CROSS_CURRENCY_RATE_TYPE exists
2425: --try to get the rate from gl
2426:
2427: BEGIN
2428: l_temp_rate := gl_currency_api.get_rate(
2429: p_trx_currency_code,
2430: p_cr_currency_code,
2431: p_cr_date,
2432: l_exchange_rate_type);

Line 2434: WHEN gl_currency_api.NO_RATE THEN

2430: p_cr_currency_code,
2431: p_cr_date,
2432: l_exchange_rate_type);
2433: EXCEPTION
2434: WHEN gl_currency_api.NO_RATE THEN
2435: --rate does not exist set appropriate message.
2436: --p_return_status := FND_API.G_RET_STS_ERROR ;
2437: l_temp_rate := NULL;
2438: IF PG_DEBUG in ('Y', 'C') THEN

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

2435: --rate does not exist set appropriate message.
2436: --p_return_status := FND_API.G_RET_STS_ERROR ;
2437: l_temp_rate := NULL;
2438: IF PG_DEBUG in ('Y', 'C') THEN
2439: arp_util.debug('Default_trans_to_receipt_rate: ' || 'Exception : gl_currency_api.NO_RATE ');
2440: END IF;
2441: WHEN gl_currency_api.INVALID_CURRENCY THEN
2442: -- invalid currency set appropriate message.
2443: --p_return_status := FND_API.G_RET_STS_ERROR ;

Line 2441: WHEN gl_currency_api.INVALID_CURRENCY THEN

2437: l_temp_rate := NULL;
2438: IF PG_DEBUG in ('Y', 'C') THEN
2439: arp_util.debug('Default_trans_to_receipt_rate: ' || 'Exception : gl_currency_api.NO_RATE ');
2440: END IF;
2441: WHEN gl_currency_api.INVALID_CURRENCY THEN
2442: -- invalid currency 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.INVALID_CURRENCY ');

2442: -- invalid currency 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.INVALID_CURRENCY ');
2447: END IF;
2448: END;
2449: END IF ;
2450:

Line 2451: ELSIF gl_currency_api.is_fixed_rate(

2447: END IF;
2448: END;
2449: END IF ;
2450:
2451: ELSIF gl_currency_api.is_fixed_rate(
2452: p_cr_currency_code,
2453: p_trx_currency_code,
2454: p_cr_date
2455: ) = 'Y' THEN

Line 2459: l_temp_rate := gl_currency_api.get_rate(

2455: ) = 'Y' THEN
2456: --In case of fixed relationship get the fixed rate and return it.
2457:
2458: BEGIN
2459: l_temp_rate := gl_currency_api.get_rate(
2460: p_trx_currency_code,
2461: p_cr_currency_code,
2462: p_cr_date,
2463: l_exchange_rate_type

Line 2466: WHEN gl_currency_api.NO_RATE THEN

2462: p_cr_date,
2463: l_exchange_rate_type
2464: );
2465: EXCEPTION
2466: WHEN gl_currency_api.NO_RATE THEN
2467: --rate does not exist set appropriate message.
2468: --p_return_status := FND_API.G_RET_STS_ERROR ;
2469: l_temp_rate := NULL;
2470: IF PG_DEBUG in ('Y', 'C') THEN

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

2467: --rate does not exist set appropriate message.
2468: --p_return_status := FND_API.G_RET_STS_ERROR ;
2469: l_temp_rate := NULL;
2470: IF PG_DEBUG in ('Y', 'C') THEN
2471: arp_util.debug('Default_trans_to_receipt_rate: ' || 'Exception : gl_currency_api.NO_RATE ');
2472: END IF;
2473: WHEN gl_currency_api.INVALID_CURRENCY THEN
2474: -- invalid currency set appropriate message.
2475: --p_return_status := FND_API.G_RET_STS_ERROR ;

Line 2473: WHEN gl_currency_api.INVALID_CURRENCY THEN

2469: l_temp_rate := NULL;
2470: IF PG_DEBUG in ('Y', 'C') THEN
2471: arp_util.debug('Default_trans_to_receipt_rate: ' || 'Exception : gl_currency_api.NO_RATE ');
2472: END IF;
2473: WHEN gl_currency_api.INVALID_CURRENCY THEN
2474: -- invalid currency 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.INVALID_CURRENCY ');

2474: -- invalid currency 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.INVALID_CURRENCY ');
2479: END IF;
2480: END;
2481:
2482: IF p_trans_to_receipt_rate IS NOT NULL THEN

Line 3071: IF ( (gl_currency_api.is_fixed_rate(

3067: l_exchange_rate_type := pg_profile_cc_rate_type;
3068: IF PG_DEBUG in ('Y', 'C') THEN
3069: arp_util.debug('Default_disc_and_amt_applied: ' || 'default cross currency exchange rate type :'||l_exchange_rate_type);
3070: END IF;
3071: IF ( (gl_currency_api.is_fixed_rate(
3072: p_cr_currency_code,
3073: p_trx_currency_code,
3074: p_cr_date
3075: ) = 'Y' ) OR

Line 3097: l_convert_amount_inv := gl_currency_api.convert_amount(

3093: b) receipt amount in transaction currency
3094: and assign the appropriate converted amount to l_applied_in_amount below */
3095:
3096: -- invoice amount in receipt currency
3097: l_convert_amount_inv := gl_currency_api.convert_amount(
3098: p_trx_currency_code,
3099: p_cr_currency_code,
3100: p_cr_date,
3101: l_exchange_rate_type,

Line 3105: l_convert_amount_cr := gl_currency_api.convert_amount(

3101: l_exchange_rate_type,
3102: p_amount_due_remaining);
3103:
3104: -- receipt amount in invoice currency
3105: l_convert_amount_cr := gl_currency_api.convert_amount(
3106: p_cr_currency_code,
3107: p_trx_currency_code,
3108: p_cr_date,
3109: l_exchange_rate_type,

Line 3119: WHEN gl_currency_api.NO_RATE THEN

3115: END IF;
3116:
3117:
3118: EXCEPTION
3119: WHEN gl_currency_api.NO_RATE THEN
3120: l_convert_amount_inv := NULL;
3121: l_convert_amount_cr := NULL;
3122: IF PG_DEBUG in ('Y', 'C') THEN
3123: arp_util.debug('Default_disc_and_amt_applied: ' || 'No rate exists in the GL for the cross currency conversion ');

Line 3125: WHEN gl_currency_api.INVALID_CURRENCY THEN

3121: l_convert_amount_cr := NULL;
3122: IF PG_DEBUG in ('Y', 'C') THEN
3123: arp_util.debug('Default_disc_and_amt_applied: ' || 'No rate exists in the GL for the cross currency conversion ');
3124: END IF;
3125: WHEN gl_currency_api.INVALID_CURRENCY THEN
3126: IF PG_DEBUG in ('Y', 'C') THEN
3127: arp_util.debug('Default_disc_and_amt_applied: ' || 'The Receipt/Invoice currency is Invalid ');
3128: END IF;
3129: raise;