[Home] [Help]
1173: THEN
1174: -- This section of code is commented out as the implementation of the
1175: -- of the caching mechanism has been deferred as of now
1176:
1177: l_exchange_rate := gl_currency_api.get_rate(
1178: l_set_of_books_id,
1179: p_currency_code,
1180: p_exchange_rate_date,
1181: p_exchange_rate_type
1184: END IF;
1185: RETURN( l_exchange_rate );
1186: arp_util.debug('ar_deposit_lib_pvt.Find_Exchange_Rate() -' );
1187: EXCEPTION
1188: WHEN gl_currency_api.NO_RATE THEN
1189: --rate does not exist set appropriate message.
1190: --p_return_status := FND_API.G_RET_STS_ERROR ;
1191: return(null);
1192: arp_util.debug('Exception : gl_currency_api.NO_RATE ');
1188: WHEN gl_currency_api.NO_RATE THEN
1189: --rate does not exist set appropriate message.
1190: --p_return_status := FND_API.G_RET_STS_ERROR ;
1191: return(null);
1192: arp_util.debug('Exception : gl_currency_api.NO_RATE ');
1193: WHEN gl_currency_api.INVALID_CURRENCY THEN
1194: -- invalid currency set appropriate message.
1195: --p_return_status := FND_API.G_RET_STS_ERROR ;
1196: return(null);
1189: --rate does not exist set appropriate message.
1190: --p_return_status := FND_API.G_RET_STS_ERROR ;
1191: return(null);
1192: arp_util.debug('Exception : gl_currency_api.NO_RATE ');
1193: WHEN gl_currency_api.INVALID_CURRENCY THEN
1194: -- invalid currency set appropriate message.
1195: --p_return_status := FND_API.G_RET_STS_ERROR ;
1196: return(null);
1197: arp_util.debug('Exception: gl_currency_api.INVALID_CURRENCY ');
1193: WHEN gl_currency_api.INVALID_CURRENCY THEN
1194: -- invalid currency set appropriate message.
1195: --p_return_status := FND_API.G_RET_STS_ERROR ;
1196: return(null);
1197: arp_util.debug('Exception: gl_currency_api.INVALID_CURRENCY ');
1198: WHEN others THEN
1199: arp_util.debug('EXCEPTION: Find_Exchange_Rate() ');
1200: raise;
1201: END Find_Exchange_Rate;
1215: euro_code VARCHAR2(15);
1216: l_cross_rate NUMBER;
1217: BEGIN
1218: arp_util.debug('ar_deposit_lib_pvt.Get_cross_rate() +' );
1219: gl_currency_api.get_relation(
1220: p_from_currency,
1221: p_to_currency,
1222: trunc(p_exchange_rate_date),
1223: l_fixed_rate,
1221: p_to_currency,
1222: trunc(p_exchange_rate_date),
1223: l_fixed_rate,
1224: l_relationship);
1225: euro_code := gl_currency_api.get_euro_code;
1226:
1227: IF (l_relationship = 'EMU-OTHER') THEN
1228: l_euro_to_emu_rate :=
1229: gl_currency_api.get_rate(
1225: euro_code := gl_currency_api.get_euro_code;
1226:
1227: IF (l_relationship = 'EMU-OTHER') THEN
1228: l_euro_to_emu_rate :=
1229: gl_currency_api.get_rate(
1230: euro_code,
1231: p_from_currency,
1232: trunc(p_exchange_rate_date),
1233: NULL);
1232: trunc(p_exchange_rate_date),
1233: NULL);
1234: ELSIF (l_relationship = 'OTHER-EMU') THEN
1235: l_euro_to_emu_rate :=
1236: gl_currency_api.get_rate(
1237: euro_code,
1238: p_to_currency,
1239: trunc(p_exchange_rate_date),
1240: NULL);