40: -- conversion date for the most recent date on which a rate is defined.
41: --2. If it is a negative number, the function will look backward without any
42: -- date limit to find the most recent date on which a rate is defined.
43: --3. If it is zero,the funtion doesn't look backward. This is the default value
44: -- The above definition follows rules defined in GL_CURRENCY_API.
45:
46: -- End of Comments
47:
48:
73: return(-1); --raise INVALID_DAILY_CONVERSION_TYPE;
74: END IF;
75:
76:
77: -- Call GL_CURRENCY_API to do conversion
78: l_converted_amount :=
79: gl_currency_api.convert_closest_amount_sql(p_from_currency,
80: p_to_currency,p_conversion_date,l_conversion_type,0,p_amount,
81: p_max_roll_days);
75:
76:
77: -- Call GL_CURRENCY_API to do conversion
78: l_converted_amount :=
79: gl_currency_api.convert_closest_amount_sql(p_from_currency,
80: p_to_currency,p_conversion_date,l_conversion_type,0,p_amount,
81: p_max_roll_days);
82:
83:
95: fnd_message.set_token('FROM_CURR', p_from_currency);
96: fnd_message.set_token('TO_CURR', p_to_currency);
97: FND_MSG_PUB.Add;
98: END IF;
99: return(-1); --raise gl_currency_api.INVALID_CURRENCY;
100: END IF;
101:
102: return(l_converted_amount);
103: