DBA Data[Home] [Help]

APPS.WSH_FC_INTERFACE_PKG dependencies on GL_CURRENCY_API

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

2538: --
2539: -- Debug Statements
2540: --
2541: IF l_debug_on THEN
2542: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit GL_CURRENCY_API.IS_FIXED_RATE',WSH_DEBUG_SV.C_PROC_LEVEL);
2543: END IF;
2544: --
2545: IF (GL_CURRENCY_API.Is_Fixed_Rate(p_prorated_freight_cost(i).currency_code, l_line_currency_code, l_conversion_date) = 'Y') THEN
2546: --

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

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

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

2553: --
2554: -- Debug Statements
2555: --
2556: IF l_debug_on THEN
2557: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit GL_CURRENCY_API.CONVERT_AMOUNT',WSH_DEBUG_SV.C_PROC_LEVEL);
2558: END IF;
2559: --
2560: x_Final_Cost(j).amount := x_Final_Cost(j).amount + GL_CURRENCY_API.convert_amount(
2561: 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 2560: x_Final_Cost(j).amount := x_Final_Cost(j).amount + GL_CURRENCY_API.convert_amount(

2556: IF l_debug_on THEN
2557: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit GL_CURRENCY_API.CONVERT_AMOUNT',WSH_DEBUG_SV.C_PROC_LEVEL);
2558: END IF;
2559: --
2560: x_Final_Cost(j).amount := x_Final_Cost(j).amount + GL_CURRENCY_API.convert_amount(
2561: 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);
2562: -- bug 3455978 use the conversion_type_code from wsh_freight_costs
2563: ELSIF (p_prorated_freight_cost(i).conversion_type_code = 'User') THEN
2564: IF (p_prorated_freight_cost(i).conversion_rate IS NOT NULL) THEN

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

2606: --
2607: -- Debug Statements
2608: --
2609: IF l_debug_on THEN
2610: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit GL_CURRENCY_API.RATE_EXISTS',WSH_DEBUG_SV.C_PROC_LEVEL);
2611: END IF;
2612: --
2613: l_rate_exists := GL_CURRENCY_API.Rate_Exists(
2614: x_from_currency => p_prorated_freight_cost(i).currency_code,

Line 2613: l_rate_exists := GL_CURRENCY_API.Rate_Exists(

2609: IF l_debug_on THEN
2610: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit GL_CURRENCY_API.RATE_EXISTS',WSH_DEBUG_SV.C_PROC_LEVEL);
2611: END IF;
2612: --
2613: l_rate_exists := GL_CURRENCY_API.Rate_Exists(
2614: x_from_currency => p_prorated_freight_cost(i).currency_code,
2615: x_to_currency => l_line_currency_code,
2616: x_conversion_date => l_conversion_date,
2617: x_conversion_type => NVL(p_prorated_freight_cost(i).conversion_type_code,l_conversion_type)

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

2627: --
2628: -- Debug Statements
2629: --
2630: IF l_debug_on THEN
2631: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit GL_CURRENCY_API.CONVERT_AMOUNT',WSH_DEBUG_SV.C_PROC_LEVEL);
2632: END IF;
2633: --
2634: -- bug 4135443
2635: x_Final_Cost(j).amount := x_Final_Cost(j).amount +

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

2632: END IF;
2633: --
2634: -- bug 4135443
2635: x_Final_Cost(j).amount := x_Final_Cost(j).amount +
2636: GL_CURRENCY_API.convert_amount(p_prorated_freight_cost(i).currency_code,
2637: l_line_currency_code,
2638: l_conversion_date,
2639: NVL(p_prorated_freight_cost(i).conversion_type_code,l_conversion_type),
2640: p_prorated_freight_cost(i).amount);

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

2649: --
2650: -- Debug Statements
2651: --
2652: IF l_debug_on THEN
2653: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit GL_CURRENCY_API.CONVERT_CLOSEST_AMOUNT',WSH_DEBUG_SV.C_PROC_LEVEL);
2654: END IF;
2655: --
2656: GL_CURRENCY_API.convert_closest_amount(
2657: x_from_currency => p_prorated_freight_cost(i).currency_code,

Line 2656: GL_CURRENCY_API.convert_closest_amount(

2652: IF l_debug_on THEN
2653: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit GL_CURRENCY_API.CONVERT_CLOSEST_AMOUNT',WSH_DEBUG_SV.C_PROC_LEVEL);
2654: END IF;
2655: --
2656: GL_CURRENCY_API.convert_closest_amount(
2657: x_from_currency => p_prorated_freight_cost(i).currency_code,
2658: x_to_currency => l_line_currency_code,
2659: x_conversion_date => l_conversion_date,
2660: x_conversion_type => NVL(p_prorated_freight_cost(i).conversion_type_code,l_conversion_type),

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

2678: --
2679: -- Debug Statements
2680: --
2681: IF l_debug_on THEN
2682: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit GL_CURRENCY_API.IS_FIXED_RATE',WSH_DEBUG_SV.C_PROC_LEVEL);
2683: END IF;
2684: --
2685: IF (GL_CURRENCY_API.Is_Fixed_Rate(p_prorated_freight_cost(i).currency_code, l_line_currency_code, l_conversion_date) = 'Y') THEN
2686: --

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

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

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

2693: --
2694: -- Debug Statements
2695: --
2696: IF l_debug_on THEN
2697: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit GL_CURRENCY_API.CONVERT_AMOUNT',WSH_DEBUG_SV.C_PROC_LEVEL);
2698: END IF;
2699: --
2700: x_Final_Cost(l_next_tab_id).amount :=
2701: GL_CURRENCY_API.convert_amount(

Line 2701: GL_CURRENCY_API.convert_amount(

2697: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit GL_CURRENCY_API.CONVERT_AMOUNT',WSH_DEBUG_SV.C_PROC_LEVEL);
2698: END IF;
2699: --
2700: x_Final_Cost(l_next_tab_id).amount :=
2701: GL_CURRENCY_API.convert_amount(
2702: p_prorated_freight_cost(i).currency_code,
2703: l_line_currency_code,
2704: l_conversion_date,
2705: NVL(p_prorated_freight_cost(i).conversion_type_code,l_conversion_type),

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

2749: --
2750: -- Debug Statements
2751: --
2752: IF l_debug_on THEN
2753: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit GL_CURRENCY_API.RATE_EXISTS',WSH_DEBUG_SV.C_PROC_LEVEL);
2754: END IF;
2755: --
2756: l_rate_exists := GL_CURRENCY_API.Rate_Exists(
2757: x_from_currency => p_prorated_freight_cost(i).currency_code,

Line 2756: l_rate_exists := GL_CURRENCY_API.Rate_Exists(

2752: IF l_debug_on THEN
2753: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit GL_CURRENCY_API.RATE_EXISTS',WSH_DEBUG_SV.C_PROC_LEVEL);
2754: END IF;
2755: --
2756: l_rate_exists := GL_CURRENCY_API.Rate_Exists(
2757: x_from_currency => p_prorated_freight_cost(i).currency_code,
2758: x_to_currency => l_line_currency_code,
2759: x_conversion_date => l_conversion_date,
2760: x_conversion_type => NVL(p_prorated_freight_cost(i).conversion_type_code,l_conversion_type)

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

2764: -- Debug Statements
2765: --
2766: IF l_debug_on THEN
2767: 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' ) );
2768: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit GL_CURRENCY_API.CONVERT_AMOUNT',WSH_DEBUG_SV.C_PROC_LEVEL);
2769: END IF;
2770: --
2771: -- bug 4135443
2772: x_Final_Cost(l_next_tab_id).amount := GL_CURRENCY_API.convert_amount (

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

2768: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit GL_CURRENCY_API.CONVERT_AMOUNT',WSH_DEBUG_SV.C_PROC_LEVEL);
2769: END IF;
2770: --
2771: -- bug 4135443
2772: x_Final_Cost(l_next_tab_id).amount := GL_CURRENCY_API.convert_amount (
2773: p_prorated_freight_cost(i).currency_code, l_line_currency_code,
2774: l_conversion_date,
2775: NVL(p_prorated_freight_cost(i).conversion_type_code,l_conversion_type),
2776: p_prorated_freight_cost(i).amount);

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

2780: --
2781: IF l_debug_on THEN
2782: 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:'||
2783: TO_CHAR ( L_CONVERSION_DATE , 'DD-MON-YY HH24:MI:SS') );
2784: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit GL_CURRENCY_API.CONVERT_CLOSEST_AMOUNT',WSH_DEBUG_SV.C_PROC_LEVEL);
2785: END IF;
2786: --
2787: --
2788: GL_CURRENCY_API.convert_closest_amount(

Line 2788: GL_CURRENCY_API.convert_closest_amount(

2784: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit GL_CURRENCY_API.CONVERT_CLOSEST_AMOUNT',WSH_DEBUG_SV.C_PROC_LEVEL);
2785: END IF;
2786: --
2787: --
2788: GL_CURRENCY_API.convert_closest_amount(
2789: x_from_currency => p_prorated_freight_cost(i).currency_code,
2790: x_to_currency => l_line_currency_code,
2791: x_conversion_date => l_conversion_date,
2792: x_conversion_type => NVL(p_prorated_freight_cost(i).conversion_type_code,l_conversion_type),

Line 2865: WHEN GL_CURRENCY_API.No_Rate THEN

2861: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_NO_ACTUALL_DEPARTURE_DATE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2862: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_NO_ACTUALL_DEPARTURE_DATE');
2863: END IF;
2864: --
2865: WHEN GL_CURRENCY_API.No_Rate THEN
2866: --
2867: -- Debug Statements
2868: --
2869: IF l_debug_on THEN

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

2874: --
2875: -- Debug Statements
2876: --
2877: IF l_debug_on THEN
2878: WSH_DEBUG_SV.logmsg(l_module_name,'GL_CURRENCY_API.NO_RATE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2879: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:GL_CURRENCY_API.NO_RATE');
2880: END IF;
2881: --
2882: WHEN GL_CURRENCY_API.Invalid_Currency THEN

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

2875: -- Debug Statements
2876: --
2877: IF l_debug_on THEN
2878: WSH_DEBUG_SV.logmsg(l_module_name,'GL_CURRENCY_API.NO_RATE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2879: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:GL_CURRENCY_API.NO_RATE');
2880: END IF;
2881: --
2882: WHEN GL_CURRENCY_API.Invalid_Currency THEN
2883: --

Line 2882: WHEN GL_CURRENCY_API.Invalid_Currency THEN

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

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

2891: --
2892: -- Debug Statements
2893: --
2894: IF l_debug_on THEN
2895: WSH_DEBUG_SV.logmsg(l_module_name,'GL_CURRENCY_API.INVALID_CURRENCY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2896: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:GL_CURRENCY_API.INVALID_CURRENCY');
2897: END IF;
2898: --
2899: WHEN Oe_currency_Not_Exist THEN

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

2892: -- Debug Statements
2893: --
2894: IF l_debug_on THEN
2895: WSH_DEBUG_SV.logmsg(l_module_name,'GL_CURRENCY_API.INVALID_CURRENCY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2896: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:GL_CURRENCY_API.INVALID_CURRENCY');
2897: END IF;
2898: --
2899: WHEN Oe_currency_Not_Exist THEN
2900: --