DBA Data[Home] [Help]

APPS.WSH_USA_INV_PVT dependencies on WSH_WV_UTILS

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

181: p_org_info_tbl(p_backorder_rec_tbl(i).organization_id).wms_org = 'Y' AND
182: p_backorder_rec_tbl(i).container_id is NOT NULL)
183: ) THEN --{
184: IF l_debug_on THEN
185: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DD_WV_Post_Process', WSH_DEBUG_SV.C_PROC_LEVEL);
186: END IF;
187:
188: WSH_WV_UTILS.DD_WV_Post_Process(
189: p_delivery_detail_id => p_backorder_rec_tbl(i).delivery_detail_id,

Line 188: WSH_WV_UTILS.DD_WV_Post_Process(

184: IF l_debug_on THEN
185: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DD_WV_Post_Process', WSH_DEBUG_SV.C_PROC_LEVEL);
186: END IF;
187:
188: WSH_WV_UTILS.DD_WV_Post_Process(
189: p_delivery_detail_id => p_backorder_rec_tbl(i).delivery_detail_id,
190: p_diff_gross_wt => -1 * p_backorder_rec_tbl(i).gross_weight,
191: p_diff_net_wt => -1 * p_backorder_rec_tbl(i).net_weight,
192: p_diff_volume => -1 * p_backorder_rec_tbl(i).volume,

Line 200: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_WV_UTILS.DD_WV_Post_Process ');

196:
197: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
198: WSH_UTIL_CORE.Add_Message(l_return_status);
199: IF l_debug_on THEN
200: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_WV_UTILS.DD_WV_Post_Process ');
201: END IF;
202: ROLLBACK TO unassign_backorder_details;
203: l_num_errors := l_num_errors + 1;
204: GOTO next_record;

Line 471: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DD_WV_Post_Process'

467: IF p_org_info_tbl(p_backorder_rec_tbl(i).organization_id).wms_org = 'Y'
468: AND p_backorder_rec_tbl(i).planned_flag = 'Y' AND p_backorder_rec_tbl(i).delivery_id is NOT NULL
469: AND p_backorder_rec_tbl(i).container_id is NOT NULL THEN --{
470: IF l_debug_on THEN
471: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DD_WV_Post_Process'
472: ,WSH_DEBUG_SV.C_PROC_LEVEL);
473: END IF;
474:
475: WSH_WV_UTILS.DD_WV_Post_Process(

Line 475: WSH_WV_UTILS.DD_WV_Post_Process(

471: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DD_WV_Post_Process'
472: ,WSH_DEBUG_SV.C_PROC_LEVEL);
473: END IF;
474:
475: WSH_WV_UTILS.DD_WV_Post_Process(
476: p_delivery_detail_id => p_backorder_rec_tbl(i).delivery_detail_id,
477: p_diff_gross_wt => p_backorder_rec_tbl(i).gross_weight,
478: p_diff_net_wt => p_backorder_rec_tbl(i).net_weight,
479: p_diff_volume => p_backorder_rec_tbl(i).volume,

Line 486: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_WV_UTILS.DD_WV_Post_Process ');

482:
483: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
484: WSH_UTIL_CORE.Add_Message(l_return_status);
485: IF l_debug_on THEN
486: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_WV_UTILS.DD_WV_Post_Process ');
487: END IF;
488: ROLLBACK TO unassign_backorder_details;
489: l_num_errors := l_num_errors + 1;
490: GOTO next_record;

Line 2495: l_cancellation_quantity2 := WSH_WV_UTILS.convert_uom(

2491: -- otherwise we may be mixing item level and lot specific level calculations
2492: IF l_rsv_array(l_counter).secondary_uom_code <> FND_API.G_MISS_CHAR THEN
2493: -- For dual tracked items compute the secondary cancellation qty in
2494: -- accordance with any lot specific calculation in play
2495: l_cancellation_quantity2 := WSH_WV_UTILS.convert_uom(
2496: item_id => l_rsv_array(l_counter).inventory_item_id
2497: , lot_number => l_rsv_array(l_counter).lot_number
2498: , org_id => l_rsv_array(l_counter).organization_id
2499: , p_max_decimal_digits => NULL -- use default precision

Line 2640: l_cancellation_quantity := WSH_WV_UTILS.convert_uom(

2636: -- lot specific calculation in play for the reservation line
2637: -- otherwise we may be mixing item level and lot specific level calculations
2638: -- For dual tracked items compute the primary cancellation qty in
2639: -- accordance with any lot specific calculation in play
2640: l_cancellation_quantity := WSH_WV_UTILS.convert_uom(
2641: item_id => l_rsv_array(l_counter).inventory_item_id
2642: , lot_number => l_rsv_array(l_counter).lot_number
2643: , org_id => l_rsv_array(l_counter).organization_id
2644: , p_max_decimal_digits => NULL -- use default precision

Line 2863: l_quantity2_to_split := WSH_WV_UTILS.convert_uom(

2859:
2860: IF l_debug_on THEN
2861: WSH_DEBUG_SV.log(l_module_name,'DUAL tracked item so convert for lot ',p_rsv.lot_number);
2862: END IF;
2863: l_quantity2_to_split := WSH_WV_UTILS.convert_uom(
2864: item_id => p_rsv.inventory_item_id
2865: , lot_number => p_rsv.lot_number
2866: , org_id => p_rsv.organization_id
2867: , p_max_decimal_digits => NULL -- use default precision

Line 2917: l_quantity_to_split := WSH_WV_UTILS.convert_uom(

2913: IF p_rsv.lot_number is not null THEN
2914: IF l_debug_on THEN
2915: WSH_DEBUG_SV.log(l_module_name,'DUAL tracked item so convert for lot ',p_rsv.lot_number);
2916: END IF;
2917: l_quantity_to_split := WSH_WV_UTILS.convert_uom(
2918: item_id => p_rsv.inventory_item_id
2919: , lot_number => p_rsv.lot_number
2920: , org_id => p_rsv.organization_id
2921: , p_max_decimal_digits => NULL -- use default precision

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

4803: picked_quantity2 = decode(l_split_quantity2, 0, picked_quantity2, NULL)
4804: WHERE delivery_detail_id = l_dummy_detail_id;
4805: -- bug 4416863
4806: IF l_debug_on THEN
4807: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.Detail_Weight_Volume',WSH_DEBUG_SV.C_PROC_LEVEL);
4808: END IF;
4809:
4810: WSH_WV_UTILS.Detail_Weight_Volume
4811: (p_delivery_detail_id => l_dummy_detail_id,

Line 4810: WSH_WV_UTILS.Detail_Weight_Volume

4806: IF l_debug_on THEN
4807: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.Detail_Weight_Volume',WSH_DEBUG_SV.C_PROC_LEVEL);
4808: END IF;
4809:
4810: WSH_WV_UTILS.Detail_Weight_Volume
4811: (p_delivery_detail_id => l_dummy_detail_id,
4812: p_update_flag => 'Y',
4813: p_post_process_flag => 'Y',
4814: p_calc_wv_if_frozen => 'N',

Line 6556: l_split_quantity := WSH_WV_UTILS.convert_uom(

6552: l_split_quantity := p_Changed_Attributes(l_counter).picked_quantity;
6553: elsif (l_fulfillment_base = 'S' ) then
6554: if (p_Changed_Attributes(l_counter).picked_quantity2 < old_Delivery_detail_rec.requested_quantity2) then
6555: l_split_quantity2 := p_Changed_attributes(l_Counter).picked_quantity2;
6556: l_split_quantity := WSH_WV_UTILS.convert_uom(
6557: item_id => old_Delivery_detail_rec.inventory_item_id
6558: , lot_number => NULL
6559: , org_id => old_Delivery_detail_rec.organization_id
6560: , p_max_decimal_digits => NULL -- use default precision

Line 6613: l_Cons_Source_Line_Rec_Tab(1).bo_qty2 := WSH_WV_UTILS.convert_uom(

6609: --and SO pad computes the sec qty from the order qty.
6610: IF l_fulfillment_base = 'P' THEN
6611: l_Cons_Source_Line_Rec_Tab(1).bo_qty:= old_Delivery_detail_rec.requested_quantity - l_split_quantity;
6612: IF l_Cons_Source_Line_Rec_Tab(1).bo_qty <> 0 AND old_Delivery_detail_rec.requested_quantity_uom2 IS NOT NULL THEN
6613: l_Cons_Source_Line_Rec_Tab(1).bo_qty2 := WSH_WV_UTILS.convert_uom(
6614: item_id => old_Delivery_detail_rec.inventory_item_id
6615: , lot_number => NULL
6616: , org_id => old_Delivery_detail_rec.organization_id
6617: , p_max_decimal_digits => NULL -- use default precision

Line 6626: l_Cons_Source_Line_Rec_Tab(1).bo_qty := WSH_WV_UTILS.convert_uom(

6622: END IF;
6623: ELSE
6624: l_Cons_Source_Line_Rec_Tab(1).bo_qty2:= old_Delivery_detail_rec.requested_quantity2 - l_split_quantity2;
6625: IF l_Cons_Source_Line_Rec_Tab(1).bo_qty2 <> 0 THEN
6626: l_Cons_Source_Line_Rec_Tab(1).bo_qty := WSH_WV_UTILS.convert_uom(
6627: item_id => old_Delivery_detail_rec.inventory_item_id
6628: , lot_number => NULL
6629: , org_id => old_Delivery_detail_rec.organization_id
6630: , p_max_decimal_digits => NULL -- use default precision

Line 6724: l_requested_quantity2 := WSH_WV_UTILS.convert_uom(

6720: IF ( nvl(l_fulfillment_base, 'P') = 'P' and
6721: old_Delivery_detail_rec.requested_quantity - p_changed_attributes(l_Counter).picked_quantity <> 0) THEN
6722: IF old_Delivery_detail_rec.requested_quantity_uom2 IS NOT NULL THEN
6723:
6724: l_requested_quantity2 := WSH_WV_UTILS.convert_uom(
6725: item_id => old_Delivery_detail_rec.inventory_item_id
6726: , lot_number => NULL
6727: , org_id => old_Delivery_detail_rec.organization_id
6728: , p_max_decimal_digits => NULL -- use default precision

Line 6760: l_new_requested_quantity := WSH_WV_UTILS.convert_uom(

6756: IF ( l_fulfillment_base = 'S' and
6757: old_Delivery_detail_rec.requested_quantity2 - p_changed_attributes(l_Counter).picked_quantity2 <> 0 )
6758: THEN
6759: -- need to Convert the Qty. to Primarry
6760: l_new_requested_quantity := WSH_WV_UTILS.convert_uom(
6761: item_id => old_Delivery_detail_rec.inventory_item_id
6762: , lot_number => NULL
6763: , org_id => old_Delivery_detail_rec.organization_id
6764: , p_max_decimal_digits => NULL -- use default precision

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

6913: IF ( l_under_pick_post_process_flag = 'Y' AND l_cont_instance_id IS NOT NULL AND l_wms_enabled_flag = 'Y'
6914: AND p_changed_attributes(l_Counter).transfer_lpn_id IS NOT NULL) THEN
6915: --{
6916: IF l_debug_on THEN
6917: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONTAINER_WEIGHT_VOLUME',WSH_DEBUG_SV.C_PROC_LEVEL);
6918: END IF;
6919: --
6920: WSH_WV_UTILS.Container_Weight_Volume (
6921: p_container_instance_id => l_cont_instance_id,

Line 6920: WSH_WV_UTILS.Container_Weight_Volume (

6916: IF l_debug_on THEN
6917: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONTAINER_WEIGHT_VOLUME',WSH_DEBUG_SV.C_PROC_LEVEL);
6918: END IF;
6919: --
6920: WSH_WV_UTILS.Container_Weight_Volume (
6921: p_container_instance_id => l_cont_instance_id,
6922: p_override_flag => 'Y',
6923: p_fill_pc_flag => 'Y',
6924: p_post_process_flag => 'Y',

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

6948: END IF;
6949: --
6950: IF l_debug_on THEN
6951: WSH_DEBUG_SV.log(l_module_name,'l_post_process_flag',l_post_process_flag);
6952: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.Detail_Weight_Volume',WSH_DEBUG_SV.C_PROC_LEVEL);
6953: END IF;
6954:
6955: WSH_WV_UTILS.Detail_Weight_Volume
6956: (p_delivery_detail_id =>l_dummy_detail_id,

Line 6955: WSH_WV_UTILS.Detail_Weight_Volume

6951: WSH_DEBUG_SV.log(l_module_name,'l_post_process_flag',l_post_process_flag);
6952: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.Detail_Weight_Volume',WSH_DEBUG_SV.C_PROC_LEVEL);
6953: END IF;
6954:
6955: WSH_WV_UTILS.Detail_Weight_Volume
6956: (p_delivery_detail_id =>l_dummy_detail_id,
6957: p_update_flag => 'Y',
6958: p_post_process_flag => l_post_process_flag,--Bug7307755
6959: p_calc_wv_if_frozen => 'N',