APPS.PA_MULTI_CURRENCY dependencies on GL_CURRENCY_API

Line 77: l_fixed_rate := GL_CURRENCY_API.is_fixed_rate( P_from_currency ,

73:
74: BEGIN
75: /* Calling GL API which returns 'Y'if a fixed rate exists */
76:
77: l_fixed_rate := GL_CURRENCY_API.is_fixed_rate( P_from_currency ,
78: P_to_currency ,
79: P_conversion_date ) ;
80:
81: /* The above API raises an INVALID_CURRENCY which is not handled here.

Line 145: /* Added for Bug2419636 as sometimes the reurned amount from the GL_CURRENCY_API.convert_amount_sql call is actually

141: RETURN;
142:
143: END IF;
144:
145: /* Added for Bug2419636 as sometimes the reurned amount from the GL_CURRENCY_API.convert_amount_sql call is actually
146: -1 or -2 and it is being treated as an error so the fix involves first we always pass a positive amount to the call
147: and later convert back the changed amount into its proper sign, this allows us to assume that -1 and -2 are always
148: errors and not other wise. */
149:

Line 186: V_converted_amount := GL_CURRENCY_API.convert_amount_sql

182: END IF;
183:
184: ELSE
185: V_amount := p_amount * v_factor; -- Make amount positive Bug 2419636
186: V_converted_amount := GL_CURRENCY_API.convert_amount_sql
187: ( P_from_currency ,
188: P_to_currency ,
189: P_conversion_date ,
190: P_conversion_type ,

Line 198: V_converted_amount := GL_CURRENCY_API.convert_closest_amount_sql

194: /* Bug 6058074 code begins */
195:
196: IF pa_multi_currency_txn.G_calling_module = 'WORKPLAN' then
197:
198: V_converted_amount := GL_CURRENCY_API.convert_closest_amount_sql
199: ( x_from_currency => P_from_currency ,
200: x_to_currency => P_to_currency ,
201: x_conversion_date => P_conversion_date ,
202: x_conversion_type => P_conversion_type ,

Line 222: V_numerator := GL_CURRENCY_API.get_closest_rate_numerator_sql( P_from_currency,

218:
219: /* Bug 6058074 begin */
220: If l_call_closest_flag = 'T' then
221:
222: V_numerator := GL_CURRENCY_API.get_closest_rate_numerator_sql( P_from_currency,
223: P_to_currency,
224: P_conversion_date,
225: P_conversion_type ,
226: -1);

Line 230: V_numerator := GL_CURRENCY_API.get_rate_numerator_sql( P_from_currency,

226: -1);
227: /* Bug 6058074 end */
228:
229: else
230: V_numerator := GL_CURRENCY_API.get_rate_numerator_sql( P_from_currency,
231: P_to_currency,
232: P_conversion_date,
233: P_conversion_type );
234: end if;

Line 241: V_denominator := GL_CURRENCY_API.get_closest_rate_denom_sql( P_from_currency,

237:
238: If l_call_closest_flag = 'T' then
239:
240: /* Bug 6058074 begin */
241: V_denominator := GL_CURRENCY_API.get_closest_rate_denom_sql( P_from_currency,
242: P_to_currency,
243: P_conversion_date,
244: P_conversion_type,
245: -1 );

Line 249: V_denominator := GL_CURRENCY_API.get_rate_denominator_sql( P_from_currency,

245: -1 );
246: /* Bug 6058074 end */
247:
248: else
249: V_denominator := GL_CURRENCY_API.get_rate_denominator_sql( P_from_currency,
250: P_to_currency,
251: P_conversion_date,
252: P_conversion_type );
253: end if;

Line 423: pa_cc_utils.log_message('Before Calling GL_CURRENCY_API.convert_closest_amount');

419: END IF;
420:
421: ELSE
422: IF P_DEBUG_MODE THEN
423: pa_cc_utils.log_message('Before Calling GL_CURRENCY_API.convert_closest_amount');
424: END IF;
425: GL_CURRENCY_API.convert_closest_amount
426: ( P_from_currency ,
427: P_to_currency ,

Line 425: GL_CURRENCY_API.convert_closest_amount

421: ELSE
422: IF P_DEBUG_MODE THEN
423: pa_cc_utils.log_message('Before Calling GL_CURRENCY_API.convert_closest_amount');
424: END IF;
425: GL_CURRENCY_API.convert_closest_amount
426: ( P_from_currency ,
427: P_to_currency ,
428: P_conversion_date ,
429: P_conversion_type ,

Line 438: pa_cc_utils.log_message('After Calling GL_CURRENCY_API.convert_closest_amount');

434: P_denominator ,
435: P_numerator ,
436: P_rate ) ;
437: IF P_DEBUG_MODE THEN
438: pa_cc_utils.log_message('After Calling GL_CURRENCY_API.convert_closest_amount');
439: END IF;
440: P_converted_amount := PA_CURRENCY.round_trans_currency_amt
441: ( P_converted_amount, P_to_currency);
442: END IF ;

Line 450: WHEN gl_currency_api.no_rate THEN

446: pa_cc_utils.reset_curr_function ;
447:
448: EXCEPTION
449:
450: WHEN gl_currency_api.no_rate THEN
451: IF (P_handle_exception_flag = 'Y') THEN
452: X_status := 'PA_NO_EXCH_RATE_EXISTS';
453: ELSE
454: IF P_DEBUG_MODE THEN

Line 460: WHEN gl_currency_api.invalid_currency THEN

456: pa_cc_utils.log_message('convert_closest_amount: ' || SQLERRM);
457: END IF;
458: RAISE;
459: END IF;
460: WHEN gl_currency_api.invalid_currency THEN
461: IF (P_handle_exception_flag = 'Y') THEN
462: X_status := 'PA_CURR_NOT_VALID';
463: ELSE
464: IF P_DEBUG_MODE THEN