DBA Data[Home] [Help]

APPS.WSH_USA_QUANTITY_PVT dependencies on WSH_WV_UTILS

Line 559: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);

555: --
556: -- Debug Statements
557: --
558: IF l_debug_on THEN
559: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
560: END IF;
561: --
562: l_new_ordered_quantity := WSH_WV_UTILS.Convert_Uom(
563: p_changed_attribute.order_quantity_uom,

Line 562: l_new_ordered_quantity := WSH_WV_UTILS.Convert_Uom(

558: IF l_debug_on THEN
559: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
560: END IF;
561: --
562: l_new_ordered_quantity := WSH_WV_UTILS.Convert_Uom(
563: p_changed_attribute.order_quantity_uom,
564: l_requested_quantity_uom, -- Converting UOM using any detail
565: p_changed_attribute.ordered_quantity,
566: l_inventory_item_id);

Line 913: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM ' ,WSH_DEBUG_SV.C_PROC_LEVEL);

909: -- If the new requested quantity is <= 0, then derive requested from secondary
910: IF (old_delivery_detail_rec.requested_quantity + l_changed_detail_quantity <= 0) THEN
911: IF l_debug_on THEN
912: WSH_DEBUG_SV.logmsg(l_module_name,'l_update_qty is '||l_update_qty);
913: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM ' ,WSH_DEBUG_SV.C_PROC_LEVEL);
914: END IF;
915: l_update_qty := wsh_wv_utils.convert_uom(
916: from_uom => l_requested_quantity_uom2,
917: to_uom => l_requested_quantity_uom,

Line 915: l_update_qty := wsh_wv_utils.convert_uom(

911: IF l_debug_on THEN
912: WSH_DEBUG_SV.logmsg(l_module_name,'l_update_qty is '||l_update_qty);
913: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM ' ,WSH_DEBUG_SV.C_PROC_LEVEL);
914: END IF;
915: l_update_qty := wsh_wv_utils.convert_uom(
916: from_uom => l_requested_quantity_uom2,
917: to_uom => l_requested_quantity_uom,
918: quantity => old_delivery_detail_rec.requested_quantity2 + l_changed_line_quantity2,
919: item_id => old_delivery_detail_rec.inventory_item_id,

Line 977: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.Detail_Weight_Volume',WSH_DEBUG_SV.C_PROC_LEVEL);

973: --
974:
975: -- J: W/V Changes
976: IF l_debug_on THEN
977: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.Detail_Weight_Volume',WSH_DEBUG_SV.C_PROC_LEVEL);
978: END IF;
979: WSH_WV_UTILS.Detail_Weight_Volume(
980: p_delivery_detail_id => old_delivery_detail_rec.delivery_detail_id,
981: p_update_flag => 'Y',

Line 979: WSH_WV_UTILS.Detail_Weight_Volume(

975: -- J: W/V Changes
976: IF l_debug_on THEN
977: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.Detail_Weight_Volume',WSH_DEBUG_SV.C_PROC_LEVEL);
978: END IF;
979: WSH_WV_UTILS.Detail_Weight_Volume(
980: p_delivery_detail_id => old_delivery_detail_rec.delivery_detail_id,
981: p_update_flag => 'Y',
982: p_post_process_flag => 'Y',
983: p_calc_wv_if_frozen => 'N',

Line 1146: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM ' ,WSH_DEBUG_SV.C_PROC_LEVEL);

1142: l_delivery_detail_rec.requested_quantity2 := l_changed_line_quantity2;
1143: -- If the new requested quantity is <= 0, then derive requested from secondary
1144: IF (l_changed_detail_quantity <= 0) THEN
1145: IF l_debug_on THEN
1146: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM ' ,WSH_DEBUG_SV.C_PROC_LEVEL);
1147: END IF;
1148: l_changed_detail_quantity := wsh_wv_utils.convert_uom(
1149: from_uom => l_requested_quantity_uom2,
1150: to_uom => l_requested_quantity_uom,

Line 1148: l_changed_detail_quantity := wsh_wv_utils.convert_uom(

1144: IF (l_changed_detail_quantity <= 0) THEN
1145: IF l_debug_on THEN
1146: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM ' ,WSH_DEBUG_SV.C_PROC_LEVEL);
1147: END IF;
1148: l_changed_detail_quantity := wsh_wv_utils.convert_uom(
1149: from_uom => l_requested_quantity_uom2,
1150: to_uom => l_requested_quantity_uom,
1151: quantity => l_changed_line_quantity2,
1152: item_id => old_delivery_detail_rec.inventory_item_id,

Line 1265: WSH_WV_UTILS.Detail_Weight_Volume

1261: RAISE create_assignment_failure;
1262: END IF;
1263:
1264: -- Bug 2349276 recalculate wt/vol if qty. changes - ignore return_status
1265: WSH_WV_UTILS.Detail_Weight_Volume
1266: (p_delivery_detail_id => l_dummy_delivery_detail_id,
1267: p_update_flag => 'Y',
1268: x_net_weight => l_net_weight,
1269: x_volume => l_volume,

Line 2895: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM ' ,WSH_DEBUG_SV.C_PROC_LEVEL);

2891: -- If the new requested quantity is <= 0, then derive requested from secondary
2892: IF (l_update_qty <= 0) THEN
2893: IF l_debug_on THEN
2894: WSH_DEBUG_SV.logmsg(l_module_name,'l_update_qty '||l_update_qty);
2895: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM ' ,WSH_DEBUG_SV.C_PROC_LEVEL);
2896: END IF;
2897: l_update_qty := wsh_wv_utils.convert_uom(
2898: from_uom => p_requested_quantity2_uom,
2899: to_uom => p_requested_quantity_uom,

Line 2897: l_update_qty := wsh_wv_utils.convert_uom(

2893: IF l_debug_on THEN
2894: WSH_DEBUG_SV.logmsg(l_module_name,'l_update_qty '||l_update_qty);
2895: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM ' ,WSH_DEBUG_SV.C_PROC_LEVEL);
2896: END IF;
2897: l_update_qty := wsh_wv_utils.convert_uom(
2898: from_uom => p_requested_quantity2_uom,
2899: to_uom => p_requested_quantity_uom,
2900: quantity => p_requested_quantity2 - ABS(p_changed_detail_quantity2),
2901: item_id => p_inventory_item_id,

Line 3135: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.Detail_Weight_Volume',WSH_DEBUG_SV.C_PROC_LEVEL);

3131: -- muom
3132: IF (p_fulfillment_base = 'P') OR (p_fulfillment_base = 'S' and p_requested_quantity <> l_update_qty) THEN
3133: -- J: W/V Changes
3134: IF l_debug_on THEN
3135: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.Detail_Weight_Volume',WSH_DEBUG_SV.C_PROC_LEVEL);
3136: END IF;
3137: WSH_WV_UTILS.Detail_Weight_Volume(
3138: p_delivery_detail_id => p_delivery_detail_id,
3139: p_update_flag => 'Y',

Line 3137: WSH_WV_UTILS.Detail_Weight_Volume(

3133: -- J: W/V Changes
3134: IF l_debug_on THEN
3135: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.Detail_Weight_Volume',WSH_DEBUG_SV.C_PROC_LEVEL);
3136: END IF;
3137: WSH_WV_UTILS.Detail_Weight_Volume(
3138: p_delivery_detail_id => p_delivery_detail_id,
3139: p_update_flag => 'Y',
3140: p_post_process_flag => 'Y',
3141: p_calc_wv_if_frozen => 'N',

Line 3344: WSH_WV_UTILS.Detail_Weight_Volume(

3340: -- J: W/V Changes
3341: IF l_debug_on THEN
3342: WSH_DEBUG_SV.log(l_module_name,'Calling Detail_Weight_Volume to reset W/V for cancelled dd');
3343: END IF;
3344: WSH_WV_UTILS.Detail_Weight_Volume(
3345: p_delivery_detail_id => p_delivery_detail_id,
3346: p_update_flag => 'Y',
3347: p_post_process_flag => 'Y',
3348: x_net_weight => l_net,