DBA Data[Home] [Help]

APPS.OKC_CURRENCY_API dependencies on OKC_API

Line 10: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;

6: -- Returns Currency code
7: -- Parameters - If Org_ID IS NULL, then determines the functional currency
8: -- for the operating unit, using FND_Profile Org_ID.
9:
10: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
11:
12: FUNCTION GET_OU_CURRENCY ( p_ORG_ID IN NUMBER )
13: RETURN VARCHAR2
14: IS

Line 275: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

271: l_rate number;
272: l_euro_rate number;
273: l_fixed_rate boolean;
274: l_relation varchar2(15);
275: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
276:
277: BEGIN
278: l_rate := get_rate(p_from_currency, p_to_currency, p_conversion_date, p_conversion_type,x_conversion_rate);
279:

Line 281: l_return_status := OKC_API.G_RET_STS_ERROR; -- 'user' conversion type is not allowed

277: BEGIN
278: l_rate := get_rate(p_from_currency, p_to_currency, p_conversion_date, p_conversion_type,x_conversion_rate);
279:
280: IF l_rate = -1 then
281: l_return_status := OKC_API.G_RET_STS_ERROR; -- 'user' conversion type is not allowed
282: OKC_API.SET_MESSAGE(G_APP_NAME,'OKC_NO_USER_CONVERSION');
283: ELSE
284: gl_currency_api.get_relation(p_from_currency, p_to_currency, p_conversion_date, l_fixed_rate, l_relation);
285: IF l_relation in ('OTHER-EMU','EMU-EMU','EURO-EMU') then

Line 282: OKC_API.SET_MESSAGE(G_APP_NAME,'OKC_NO_USER_CONVERSION');

278: l_rate := get_rate(p_from_currency, p_to_currency, p_conversion_date, p_conversion_type,x_conversion_rate);
279:
280: IF l_rate = -1 then
281: l_return_status := OKC_API.G_RET_STS_ERROR; -- 'user' conversion type is not allowed
282: OKC_API.SET_MESSAGE(G_APP_NAME,'OKC_NO_USER_CONVERSION');
283: ELSE
284: gl_currency_api.get_relation(p_from_currency, p_to_currency, p_conversion_date, l_fixed_rate, l_relation);
285: IF l_relation in ('OTHER-EMU','EMU-EMU','EURO-EMU') then
286: IF p_conversion_type = 'User' then

Line 300: x_return_status := OKC_API.G_RET_STS_ERROR;

296: x_return_status := l_return_status;
297:
298: EXCEPTION
299: WHEN gl_currency_api.no_rate THEN
300: x_return_status := OKC_API.G_RET_STS_ERROR;
301: OKC_API.SET_MESSAGE(G_APP_NAME,'OKC_NO_CONVERSION_RATE');
302: --RAISE no_rate;
303: WHEN gl_currency_api.invalid_currency THEN
304: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 301: OKC_API.SET_MESSAGE(G_APP_NAME,'OKC_NO_CONVERSION_RATE');

297:
298: EXCEPTION
299: WHEN gl_currency_api.no_rate THEN
300: x_return_status := OKC_API.G_RET_STS_ERROR;
301: OKC_API.SET_MESSAGE(G_APP_NAME,'OKC_NO_CONVERSION_RATE');
302: --RAISE no_rate;
303: WHEN gl_currency_api.invalid_currency THEN
304: x_return_status := OKC_API.G_RET_STS_ERROR;
305: OKC_API.SET_MESSAGE(G_APP_NAME,'OKC_INVALID_CURRENCY');

Line 304: x_return_status := OKC_API.G_RET_STS_ERROR;

300: x_return_status := OKC_API.G_RET_STS_ERROR;
301: OKC_API.SET_MESSAGE(G_APP_NAME,'OKC_NO_CONVERSION_RATE');
302: --RAISE no_rate;
303: WHEN gl_currency_api.invalid_currency THEN
304: x_return_status := OKC_API.G_RET_STS_ERROR;
305: OKC_API.SET_MESSAGE(G_APP_NAME,'OKC_INVALID_CURRENCY');
306: -- RAISE invalid_currency;
307: WHEN OTHERS THEN
308: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

Line 305: OKC_API.SET_MESSAGE(G_APP_NAME,'OKC_INVALID_CURRENCY');

301: OKC_API.SET_MESSAGE(G_APP_NAME,'OKC_NO_CONVERSION_RATE');
302: --RAISE no_rate;
303: WHEN gl_currency_api.invalid_currency THEN
304: x_return_status := OKC_API.G_RET_STS_ERROR;
305: OKC_API.SET_MESSAGE(G_APP_NAME,'OKC_INVALID_CURRENCY');
306: -- RAISE invalid_currency;
307: WHEN OTHERS THEN
308: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
309: END GET_RATE;

Line 308: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

304: x_return_status := OKC_API.G_RET_STS_ERROR;
305: OKC_API.SET_MESSAGE(G_APP_NAME,'OKC_INVALID_CURRENCY');
306: -- RAISE invalid_currency;
307: WHEN OTHERS THEN
308: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
309: END GET_RATE;
310:
311: -- Procedure Validate_Conversion_Attribs ( From_Currency, To_Currency,
312: -- Conversion_date, Conversion_type,

Line 517: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

513:
514: EXCEPTION
515: /* Bugfix 2256060 - Added the exception from GL to give a proper message */
516: WHEN GL_CURRENCY_API.INVALID_CURRENCY THEN
517: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
518: p_msg_name => 'OKC_NO_EURO_CURR'); /* Bugfix 2256060 - added new message */
519: raise;
520: WHEN OTHERS THEN
521: raise;