DBA Data[Home] [Help]

APPS.WSH_FREIGHT_COSTS_PVT dependencies on GL_CURRENCY_API

Line 2401: IF (GL_CURRENCY_API.Is_Fixed_Rate(p_from_currency, p_to_currency, p_conversion_date) = 'Y') THEN

2397:
2398: ELSE
2399:
2400: --
2401: IF (GL_CURRENCY_API.Is_Fixed_Rate(p_from_currency, p_to_currency, p_conversion_date) = 'Y') THEN
2402: --
2403: -- Debug Statements
2404: --
2405: IF l_debug_on THEN

Line 2410: x_converted_amount := GL_CURRENCY_API.convert_amount(p_from_currency, p_to_currency, p_conversion_date, p_conversion_type, p_amount);

2406: WSH_DEBUG_SV.logmsg(l_module_name, 'Convert' ||p_from_currency||' to '||p_to_currency ||' using fixed rate' );
2407: END IF;
2408:
2409: BEGIN
2410: x_converted_amount := GL_CURRENCY_API.convert_amount(p_from_currency, p_to_currency, p_conversion_date, p_conversion_type, p_amount);
2411: EXCEPTION
2412: WHEN GL_CURRENCY_API.no_rate THEN
2413: IF l_debug_on THEN
2414: WSH_DEBUG_SV.logmsg(l_module_name,'Failed in GL_CURRENCY_API.Convert_Amount( ) no rate ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 2412: WHEN GL_CURRENCY_API.no_rate THEN

2408:
2409: BEGIN
2410: x_converted_amount := GL_CURRENCY_API.convert_amount(p_from_currency, p_to_currency, p_conversion_date, p_conversion_type, p_amount);
2411: EXCEPTION
2412: WHEN GL_CURRENCY_API.no_rate THEN
2413: IF l_debug_on THEN
2414: WSH_DEBUG_SV.logmsg(l_module_name,'Failed in GL_CURRENCY_API.Convert_Amount( ) no rate ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2415: END IF;
2416: RAISE WSH_NO_RATE;

Line 2414: WSH_DEBUG_SV.logmsg(l_module_name,'Failed in GL_CURRENCY_API.Convert_Amount( ) no rate ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

2410: x_converted_amount := GL_CURRENCY_API.convert_amount(p_from_currency, p_to_currency, p_conversion_date, p_conversion_type, p_amount);
2411: EXCEPTION
2412: WHEN GL_CURRENCY_API.no_rate THEN
2413: IF l_debug_on THEN
2414: WSH_DEBUG_SV.logmsg(l_module_name,'Failed in GL_CURRENCY_API.Convert_Amount( ) no rate ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2415: END IF;
2416: RAISE WSH_NO_RATE;
2417:
2418: WHEN GL_CURRENCY_API.invalid_currency THEN

Line 2418: WHEN GL_CURRENCY_API.invalid_currency THEN

2414: WSH_DEBUG_SV.logmsg(l_module_name,'Failed in GL_CURRENCY_API.Convert_Amount( ) no rate ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2415: END IF;
2416: RAISE WSH_NO_RATE;
2417:
2418: WHEN GL_CURRENCY_API.invalid_currency THEN
2419: IF l_debug_on THEN
2420: WSH_DEBUG_SV.logmsg(l_module_name,'Failed in GL_CURRENCY_API.Convert_Amount( ) invalid currency',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2421: END IF;
2422: RAISE WSH_INVALID_CURRENCY;

Line 2420: WSH_DEBUG_SV.logmsg(l_module_name,'Failed in GL_CURRENCY_API.Convert_Amount( ) invalid currency',WSH_DEBUG_SV.C_EXCEP_LEVEL);

2416: RAISE WSH_NO_RATE;
2417:
2418: WHEN GL_CURRENCY_API.invalid_currency THEN
2419: IF l_debug_on THEN
2420: WSH_DEBUG_SV.logmsg(l_module_name,'Failed in GL_CURRENCY_API.Convert_Amount( ) invalid currency',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2421: END IF;
2422: RAISE WSH_INVALID_CURRENCY;
2423:
2424: WHEN others THEN

Line 2426: WSH_DEBUG_SV.logmsg(l_module_name,'Failed in GL_CURRENCY_API.Convert_Amount( )',WSH_DEBUG_SV.C_EXCEP_LEVEL);

2422: RAISE WSH_INVALID_CURRENCY;
2423:
2424: WHEN others THEN
2425: IF l_debug_on THEN
2426: WSH_DEBUG_SV.logmsg(l_module_name,'Failed in GL_CURRENCY_API.Convert_Amount( )',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2427: END IF;
2428: RAISE WSH_CONVERT_ERROR;
2429: END;
2430:

Line 2464: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit GL_CURRENCY_API.RATE_EXISTS',WSH_DEBUG_SV.C_PROC_LEVEL);

2460: --
2461: -- Debug Statements
2462: --
2463: IF l_debug_on THEN
2464: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit GL_CURRENCY_API.RATE_EXISTS',WSH_DEBUG_SV.C_PROC_LEVEL);
2465: END IF;
2466: --
2467: l_rate_exists := GL_CURRENCY_API.Rate_Exists(
2468: x_from_currency => p_from_currency,

Line 2467: l_rate_exists := GL_CURRENCY_API.Rate_Exists(

2463: IF l_debug_on THEN
2464: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit GL_CURRENCY_API.RATE_EXISTS',WSH_DEBUG_SV.C_PROC_LEVEL);
2465: END IF;
2466: --
2467: l_rate_exists := GL_CURRENCY_API.Rate_Exists(
2468: x_from_currency => p_from_currency,
2469: x_to_currency => p_to_currency,
2470: x_conversion_date => p_conversion_date,
2471: x_conversion_type => p_conversion_type

Line 2481: x_converted_amount := GL_CURRENCY_API.convert_amount(p_from_currency, p_to_currency, p_conversion_date, p_conversion_type, p_amount);

2477: IF l_debug_on THEN
2478: WSH_DEBUG_SV.logmsg(l_module_name, 'Convert amount using floating rate decided by conversion date' || to_char( p_conversion_date) );
2479: END IF;
2480: BEGIN
2481: x_converted_amount := GL_CURRENCY_API.convert_amount(p_from_currency, p_to_currency, p_conversion_date, p_conversion_type, p_amount);
2482: EXCEPTION
2483: WHEN GL_CURRENCY_API.no_rate THEN
2484: IF l_debug_on THEN
2485: WSH_DEBUG_SV.logmsg(l_module_name,'Failed in GL_CURRENCY_API.Convert_Amount( ) no rate ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 2483: WHEN GL_CURRENCY_API.no_rate THEN

2479: END IF;
2480: BEGIN
2481: x_converted_amount := GL_CURRENCY_API.convert_amount(p_from_currency, p_to_currency, p_conversion_date, p_conversion_type, p_amount);
2482: EXCEPTION
2483: WHEN GL_CURRENCY_API.no_rate THEN
2484: IF l_debug_on THEN
2485: WSH_DEBUG_SV.logmsg(l_module_name,'Failed in GL_CURRENCY_API.Convert_Amount( ) no rate ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2486: END IF;
2487: RAISE WSH_NO_RATE;

Line 2485: WSH_DEBUG_SV.logmsg(l_module_name,'Failed in GL_CURRENCY_API.Convert_Amount( ) no rate ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

2481: x_converted_amount := GL_CURRENCY_API.convert_amount(p_from_currency, p_to_currency, p_conversion_date, p_conversion_type, p_amount);
2482: EXCEPTION
2483: WHEN GL_CURRENCY_API.no_rate THEN
2484: IF l_debug_on THEN
2485: WSH_DEBUG_SV.logmsg(l_module_name,'Failed in GL_CURRENCY_API.Convert_Amount( ) no rate ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2486: END IF;
2487: RAISE WSH_NO_RATE;
2488:
2489: WHEN GL_CURRENCY_API.invalid_currency THEN

Line 2489: WHEN GL_CURRENCY_API.invalid_currency THEN

2485: WSH_DEBUG_SV.logmsg(l_module_name,'Failed in GL_CURRENCY_API.Convert_Amount( ) no rate ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2486: END IF;
2487: RAISE WSH_NO_RATE;
2488:
2489: WHEN GL_CURRENCY_API.invalid_currency THEN
2490: IF l_debug_on THEN
2491: WSH_DEBUG_SV.logmsg(l_module_name,'Failed in GL_CURRENCY_API.Convert_Amount( ) invalid currency',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2492: END IF;
2493: RAISE WSH_INVALID_CURRENCY;

Line 2491: WSH_DEBUG_SV.logmsg(l_module_name,'Failed in GL_CURRENCY_API.Convert_Amount( ) invalid currency',WSH_DEBUG_SV.C_EXCEP_LEVEL);

2487: RAISE WSH_NO_RATE;
2488:
2489: WHEN GL_CURRENCY_API.invalid_currency THEN
2490: IF l_debug_on THEN
2491: WSH_DEBUG_SV.logmsg(l_module_name,'Failed in GL_CURRENCY_API.Convert_Amount( ) invalid currency',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2492: END IF;
2493: RAISE WSH_INVALID_CURRENCY;
2494:
2495: WHEN others THEN

Line 2497: WSH_DEBUG_SV.logmsg(l_module_name,'Failed in GL_CURRENCY_API.Convert_Amount( )',WSH_DEBUG_SV.C_EXCEP_LEVEL);

2493: RAISE WSH_INVALID_CURRENCY;
2494:
2495: WHEN others THEN
2496: IF l_debug_on THEN
2497: WSH_DEBUG_SV.logmsg(l_module_name,'Failed in GL_CURRENCY_API.Convert_Amount( )',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2498: END IF;
2499: RAISE WSH_CONVERT_ERROR;
2500: END;
2501: ELSE

Line 2507: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit GL_CURRENCY_API.CONVERT_CLOSEST_AMOUNT',WSH_DEBUG_SV.C_PROC_LEVEL);

2503: -- Debug Statements
2504: --
2505: IF l_debug_on THEN
2506: WSH_DEBUG_SV.logmsg(l_module_name, 'No rate exists , convert to closest amount , conversion date:'|| to_char ( p_conversion_date ) );
2507: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit GL_CURRENCY_API.CONVERT_CLOSEST_AMOUNT',WSH_DEBUG_SV.C_PROC_LEVEL);
2508: END IF;
2509: --
2510: BEGIN
2511: GL_CURRENCY_API.convert_closest_amount(

Line 2511: GL_CURRENCY_API.convert_closest_amount(

2507: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit GL_CURRENCY_API.CONVERT_CLOSEST_AMOUNT',WSH_DEBUG_SV.C_PROC_LEVEL);
2508: END IF;
2509: --
2510: BEGIN
2511: GL_CURRENCY_API.convert_closest_amount(
2512: x_from_currency => p_from_currency,
2513: x_to_currency => p_to_currency,
2514: x_conversion_date => p_conversion_date,
2515: x_conversion_type => p_conversion_type,

Line 2525: WSH_DEBUG_SV.logmsg(l_module_name,'Converted amount from GL_CURRENCY_API.CONVERT_CLOSEST_AMOUNT is: '|| to_char(x_converted_amount),WSH_DEBUG_SV.C_PROC_LEVEL);

2521: x_numerator => l_numerator,
2522: x_rate => l_rate);
2523:
2524: IF l_debug_on THEN
2525: WSH_DEBUG_SV.logmsg(l_module_name,'Converted amount from GL_CURRENCY_API.CONVERT_CLOSEST_AMOUNT is: '|| to_char(x_converted_amount),WSH_DEBUG_SV.C_PROC_LEVEL);
2526: END IF;
2527: EXCEPTION
2528: WHEN GL_CURRENCY_API.no_rate THEN
2529: IF l_debug_on THEN

Line 2528: WHEN GL_CURRENCY_API.no_rate THEN

2524: IF l_debug_on THEN
2525: WSH_DEBUG_SV.logmsg(l_module_name,'Converted amount from GL_CURRENCY_API.CONVERT_CLOSEST_AMOUNT is: '|| to_char(x_converted_amount),WSH_DEBUG_SV.C_PROC_LEVEL);
2526: END IF;
2527: EXCEPTION
2528: WHEN GL_CURRENCY_API.no_rate THEN
2529: IF l_debug_on THEN
2530: WSH_DEBUG_SV.logmsg(l_module_name,'Failed in GL_CURRENCY_API.Convert_Closest_Amount( ) no rate ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2531: END IF;
2532: RAISE WSH_NO_RATE;

Line 2530: WSH_DEBUG_SV.logmsg(l_module_name,'Failed in GL_CURRENCY_API.Convert_Closest_Amount( ) no rate ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

2526: END IF;
2527: EXCEPTION
2528: WHEN GL_CURRENCY_API.no_rate THEN
2529: IF l_debug_on THEN
2530: WSH_DEBUG_SV.logmsg(l_module_name,'Failed in GL_CURRENCY_API.Convert_Closest_Amount( ) no rate ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2531: END IF;
2532: RAISE WSH_NO_RATE;
2533:
2534: WHEN GL_CURRENCY_API.invalid_currency THEN

Line 2534: WHEN GL_CURRENCY_API.invalid_currency THEN

2530: WSH_DEBUG_SV.logmsg(l_module_name,'Failed in GL_CURRENCY_API.Convert_Closest_Amount( ) no rate ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2531: END IF;
2532: RAISE WSH_NO_RATE;
2533:
2534: WHEN GL_CURRENCY_API.invalid_currency THEN
2535: IF l_debug_on THEN
2536: WSH_DEBUG_SV.logmsg(l_module_name,'Failed in GL_CURRENCY_API.Convert_Closest_Amount( ) invalid currency',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2537: END IF;
2538: RAISE WSH_INVALID_CURRENCY;

Line 2536: WSH_DEBUG_SV.logmsg(l_module_name,'Failed in GL_CURRENCY_API.Convert_Closest_Amount( ) invalid currency',WSH_DEBUG_SV.C_EXCEP_LEVEL);

2532: RAISE WSH_NO_RATE;
2533:
2534: WHEN GL_CURRENCY_API.invalid_currency THEN
2535: IF l_debug_on THEN
2536: WSH_DEBUG_SV.logmsg(l_module_name,'Failed in GL_CURRENCY_API.Convert_Closest_Amount( ) invalid currency',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2537: END IF;
2538: RAISE WSH_INVALID_CURRENCY;
2539:
2540: WHEN others THEN

Line 2542: WSH_DEBUG_SV.logmsg(l_module_name,'Failed in GL_CURRENCY_API.Convert_Closest_Amount( )',WSH_DEBUG_SV.C_EXCEP_LEVEL);

2538: RAISE WSH_INVALID_CURRENCY;
2539:
2540: WHEN others THEN
2541: IF l_debug_on THEN
2542: WSH_DEBUG_SV.logmsg(l_module_name,'Failed in GL_CURRENCY_API.Convert_Closest_Amount( )',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2543: END IF;
2544: RAISE WSH_CONVERT_ERROR;
2545: END;
2546: END IF;