DBA Data[Home] [Help]

APPS.WSH_FC_INTERFACE_PKG dependencies on GL_CURRENCY_API

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

2545: --
2546: -- Debug Statements
2547: --
2548: IF l_debug_on THEN
2549: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit GL_CURRENCY_API.IS_FIXED_RATE',WSH_DEBUG_SV.C_PROC_LEVEL);
2550: END IF;
2551: --
2552: IF (GL_CURRENCY_API.Is_Fixed_Rate(p_prorated_freight_cost(i).currency_code, l_line_currency_code, l_conversion_date) = 'Y') THEN
2553: --

Line 2552: IF (GL_CURRENCY_API.Is_Fixed_Rate(p_prorated_freight_cost(i).currency_code, l_line_currency_code, l_conversion_date) = 'Y') THEN

2548: IF l_debug_on THEN
2549: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit GL_CURRENCY_API.IS_FIXED_RATE',WSH_DEBUG_SV.C_PROC_LEVEL);
2550: END IF;
2551: --
2552: IF (GL_CURRENCY_API.Is_Fixed_Rate(p_prorated_freight_cost(i).currency_code, l_line_currency_code, l_conversion_date) = 'Y') THEN
2553: --
2554: -- Debug Statements
2555: --
2556: IF l_debug_on THEN

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

2560: --
2561: -- Debug Statements
2562: --
2563: IF l_debug_on THEN
2564: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit GL_CURRENCY_API.CONVERT_AMOUNT',WSH_DEBUG_SV.C_PROC_LEVEL);
2565: END IF;
2566: --
2567: x_Final_Cost(j).amount := x_Final_Cost(j).amount + GL_CURRENCY_API.convert_amount(
2568: p_prorated_freight_cost(i).currency_code, l_line_currency_code, l_conversion_date, NVL(p_prorated_freight_cost(i).conversion_type_code,l_conversion_type), p_prorated_freight_cost(i).amount);

Line 2567: x_Final_Cost(j).amount := x_Final_Cost(j).amount + GL_CURRENCY_API.convert_amount(

2563: IF l_debug_on THEN
2564: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit GL_CURRENCY_API.CONVERT_AMOUNT',WSH_DEBUG_SV.C_PROC_LEVEL);
2565: END IF;
2566: --
2567: x_Final_Cost(j).amount := x_Final_Cost(j).amount + GL_CURRENCY_API.convert_amount(
2568: p_prorated_freight_cost(i).currency_code, l_line_currency_code, l_conversion_date, NVL(p_prorated_freight_cost(i).conversion_type_code,l_conversion_type), p_prorated_freight_cost(i).amount);
2569: -- bug 3455978 use the conversion_type_code from wsh_freight_costs
2570: ELSIF (p_prorated_freight_cost(i).conversion_type_code = 'User') THEN
2571: IF (p_prorated_freight_cost(i).conversion_rate IS NOT NULL) THEN

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

2613: --
2614: -- Debug Statements
2615: --
2616: IF l_debug_on THEN
2617: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit GL_CURRENCY_API.RATE_EXISTS',WSH_DEBUG_SV.C_PROC_LEVEL);
2618: END IF;
2619: --
2620: l_rate_exists := GL_CURRENCY_API.Rate_Exists(
2621: x_from_currency => p_prorated_freight_cost(i).currency_code,

Line 2620: l_rate_exists := GL_CURRENCY_API.Rate_Exists(

2616: IF l_debug_on THEN
2617: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit GL_CURRENCY_API.RATE_EXISTS',WSH_DEBUG_SV.C_PROC_LEVEL);
2618: END IF;
2619: --
2620: l_rate_exists := GL_CURRENCY_API.Rate_Exists(
2621: x_from_currency => p_prorated_freight_cost(i).currency_code,
2622: x_to_currency => l_line_currency_code,
2623: x_conversion_date => l_conversion_date,
2624: x_conversion_type => NVL(p_prorated_freight_cost(i).conversion_type_code,l_conversion_type)

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

2634: --
2635: -- Debug Statements
2636: --
2637: IF l_debug_on THEN
2638: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit GL_CURRENCY_API.CONVERT_AMOUNT',WSH_DEBUG_SV.C_PROC_LEVEL);
2639: END IF;
2640: --
2641: -- bug 4135443
2642: x_Final_Cost(j).amount := x_Final_Cost(j).amount +

Line 2643: GL_CURRENCY_API.convert_amount(p_prorated_freight_cost(i).currency_code,

2639: END IF;
2640: --
2641: -- bug 4135443
2642: x_Final_Cost(j).amount := x_Final_Cost(j).amount +
2643: GL_CURRENCY_API.convert_amount(p_prorated_freight_cost(i).currency_code,
2644: l_line_currency_code,
2645: l_conversion_date,
2646: NVL(p_prorated_freight_cost(i).conversion_type_code,l_conversion_type),
2647: p_prorated_freight_cost(i).amount);

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

2656: --
2657: -- Debug Statements
2658: --
2659: IF l_debug_on THEN
2660: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit GL_CURRENCY_API.CONVERT_CLOSEST_AMOUNT',WSH_DEBUG_SV.C_PROC_LEVEL);
2661: END IF;
2662: --
2663: GL_CURRENCY_API.convert_closest_amount(
2664: x_from_currency => p_prorated_freight_cost(i).currency_code,

Line 2663: GL_CURRENCY_API.convert_closest_amount(

2659: IF l_debug_on THEN
2660: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit GL_CURRENCY_API.CONVERT_CLOSEST_AMOUNT',WSH_DEBUG_SV.C_PROC_LEVEL);
2661: END IF;
2662: --
2663: GL_CURRENCY_API.convert_closest_amount(
2664: x_from_currency => p_prorated_freight_cost(i).currency_code,
2665: x_to_currency => l_line_currency_code,
2666: x_conversion_date => l_conversion_date,
2667: x_conversion_type => NVL(p_prorated_freight_cost(i).conversion_type_code,l_conversion_type),

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

2685: --
2686: -- Debug Statements
2687: --
2688: IF l_debug_on THEN
2689: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit GL_CURRENCY_API.IS_FIXED_RATE',WSH_DEBUG_SV.C_PROC_LEVEL);
2690: END IF;
2691: --
2692: IF (GL_CURRENCY_API.Is_Fixed_Rate(p_prorated_freight_cost(i).currency_code, l_line_currency_code, l_conversion_date) = 'Y') THEN
2693: --

Line 2692: IF (GL_CURRENCY_API.Is_Fixed_Rate(p_prorated_freight_cost(i).currency_code, l_line_currency_code, l_conversion_date) = 'Y') THEN

2688: IF l_debug_on THEN
2689: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit GL_CURRENCY_API.IS_FIXED_RATE',WSH_DEBUG_SV.C_PROC_LEVEL);
2690: END IF;
2691: --
2692: IF (GL_CURRENCY_API.Is_Fixed_Rate(p_prorated_freight_cost(i).currency_code, l_line_currency_code, l_conversion_date) = 'Y') THEN
2693: --
2694: -- Debug Statements
2695: --
2696: IF l_debug_on THEN

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

2700: --
2701: -- Debug Statements
2702: --
2703: IF l_debug_on THEN
2704: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit GL_CURRENCY_API.CONVERT_AMOUNT',WSH_DEBUG_SV.C_PROC_LEVEL);
2705: END IF;
2706: --
2707: x_Final_Cost(l_next_tab_id).amount :=
2708: GL_CURRENCY_API.convert_amount(

Line 2708: GL_CURRENCY_API.convert_amount(

2704: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit GL_CURRENCY_API.CONVERT_AMOUNT',WSH_DEBUG_SV.C_PROC_LEVEL);
2705: END IF;
2706: --
2707: x_Final_Cost(l_next_tab_id).amount :=
2708: GL_CURRENCY_API.convert_amount(
2709: p_prorated_freight_cost(i).currency_code,
2710: l_line_currency_code,
2711: l_conversion_date,
2712: NVL(p_prorated_freight_cost(i).conversion_type_code,l_conversion_type),

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

2756: --
2757: -- Debug Statements
2758: --
2759: IF l_debug_on THEN
2760: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit GL_CURRENCY_API.RATE_EXISTS',WSH_DEBUG_SV.C_PROC_LEVEL);
2761: END IF;
2762: --
2763: l_rate_exists := GL_CURRENCY_API.Rate_Exists(
2764: x_from_currency => p_prorated_freight_cost(i).currency_code,

Line 2763: l_rate_exists := GL_CURRENCY_API.Rate_Exists(

2759: IF l_debug_on THEN
2760: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit GL_CURRENCY_API.RATE_EXISTS',WSH_DEBUG_SV.C_PROC_LEVEL);
2761: END IF;
2762: --
2763: l_rate_exists := GL_CURRENCY_API.Rate_Exists(
2764: x_from_currency => p_prorated_freight_cost(i).currency_code,
2765: x_to_currency => l_line_currency_code,
2766: x_conversion_date => l_conversion_date,
2767: x_conversion_type => NVL(p_prorated_freight_cost(i).conversion_type_code,l_conversion_type)

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

2771: -- Debug Statements
2772: --
2773: IF l_debug_on THEN
2774: WSH_DEBUG_SV.logmsg(l_module_name, 'SET P_PRORATED_FREIGHT_COST ( '|| I ||' ) TO X_FINAL_COST ( '||L_NEXT_TAB_ID||' ) USING FLOATING RATE DECIDED BY CONVERSION DATE:' || TO_CHAR ( L_CONVERSION_DATE, 'DD-MON-YY HH24:MI:SS' ) );
2775: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit GL_CURRENCY_API.CONVERT_AMOUNT',WSH_DEBUG_SV.C_PROC_LEVEL);
2776: END IF;
2777: --
2778: -- bug 4135443
2779: x_Final_Cost(l_next_tab_id).amount := GL_CURRENCY_API.convert_amount (

Line 2779: x_Final_Cost(l_next_tab_id).amount := GL_CURRENCY_API.convert_amount (

2775: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit GL_CURRENCY_API.CONVERT_AMOUNT',WSH_DEBUG_SV.C_PROC_LEVEL);
2776: END IF;
2777: --
2778: -- bug 4135443
2779: x_Final_Cost(l_next_tab_id).amount := GL_CURRENCY_API.convert_amount (
2780: p_prorated_freight_cost(i).currency_code, l_line_currency_code,
2781: l_conversion_date,
2782: NVL(p_prorated_freight_cost(i).conversion_type_code,l_conversion_type),
2783: p_prorated_freight_cost(i).amount);

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

2787: --
2788: IF l_debug_on THEN
2789: WSH_DEBUG_SV.logmsg(l_module_name, 'SET P_PRORATED_FREIGHT_COST ( ' || I ||' ) TO X_FINAL_COST ( '||L_NEXT_TAB_ID||' ) , NO RATE EXISTS , CONVERT TO CLOSEST AMOUNT , CONVERSION DATE:'||
2790: TO_CHAR ( L_CONVERSION_DATE , 'DD-MON-YY HH24:MI:SS') );
2791: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit GL_CURRENCY_API.CONVERT_CLOSEST_AMOUNT',WSH_DEBUG_SV.C_PROC_LEVEL);
2792: END IF;
2793: --
2794: --
2795: GL_CURRENCY_API.convert_closest_amount(

Line 2795: GL_CURRENCY_API.convert_closest_amount(

2791: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit GL_CURRENCY_API.CONVERT_CLOSEST_AMOUNT',WSH_DEBUG_SV.C_PROC_LEVEL);
2792: END IF;
2793: --
2794: --
2795: GL_CURRENCY_API.convert_closest_amount(
2796: x_from_currency => p_prorated_freight_cost(i).currency_code,
2797: x_to_currency => l_line_currency_code,
2798: x_conversion_date => l_conversion_date,
2799: x_conversion_type => NVL(p_prorated_freight_cost(i).conversion_type_code,l_conversion_type),

Line 2872: WHEN GL_CURRENCY_API.No_Rate THEN

2868: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_NO_ACTUALL_DEPARTURE_DATE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2869: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_NO_ACTUALL_DEPARTURE_DATE');
2870: END IF;
2871: --
2872: WHEN GL_CURRENCY_API.No_Rate THEN
2873: --
2874: -- Debug Statements
2875: --
2876: IF l_debug_on THEN

Line 2885: WSH_DEBUG_SV.logmsg(l_module_name,'GL_CURRENCY_API.NO_RATE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

2881: --
2882: -- Debug Statements
2883: --
2884: IF l_debug_on THEN
2885: WSH_DEBUG_SV.logmsg(l_module_name,'GL_CURRENCY_API.NO_RATE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2886: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:GL_CURRENCY_API.NO_RATE');
2887: END IF;
2888: --
2889: WHEN GL_CURRENCY_API.Invalid_Currency THEN

Line 2886: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:GL_CURRENCY_API.NO_RATE');

2882: -- Debug Statements
2883: --
2884: IF l_debug_on THEN
2885: WSH_DEBUG_SV.logmsg(l_module_name,'GL_CURRENCY_API.NO_RATE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2886: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:GL_CURRENCY_API.NO_RATE');
2887: END IF;
2888: --
2889: WHEN GL_CURRENCY_API.Invalid_Currency THEN
2890: --

Line 2889: WHEN GL_CURRENCY_API.Invalid_Currency THEN

2885: WSH_DEBUG_SV.logmsg(l_module_name,'GL_CURRENCY_API.NO_RATE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2886: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:GL_CURRENCY_API.NO_RATE');
2887: END IF;
2888: --
2889: WHEN GL_CURRENCY_API.Invalid_Currency THEN
2890: --
2891: -- Debug Statements
2892: --
2893: IF l_debug_on THEN

Line 2902: WSH_DEBUG_SV.logmsg(l_module_name,'GL_CURRENCY_API.INVALID_CURRENCY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

2898: --
2899: -- Debug Statements
2900: --
2901: IF l_debug_on THEN
2902: WSH_DEBUG_SV.logmsg(l_module_name,'GL_CURRENCY_API.INVALID_CURRENCY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2903: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:GL_CURRENCY_API.INVALID_CURRENCY');
2904: END IF;
2905: --
2906: WHEN Oe_currency_Not_Exist THEN

Line 2903: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:GL_CURRENCY_API.INVALID_CURRENCY');

2899: -- Debug Statements
2900: --
2901: IF l_debug_on THEN
2902: WSH_DEBUG_SV.logmsg(l_module_name,'GL_CURRENCY_API.INVALID_CURRENCY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2903: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:GL_CURRENCY_API.INVALID_CURRENCY');
2904: END IF;
2905: --
2906: WHEN Oe_currency_Not_Exist THEN
2907: --