DBA Data[Home] [Help]

APPS.WSH_CONTAINER_ACTIONS dependencies on WSH_WV_UTILS

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

435: WSH_DEBUG_SV.log(l_module_name, 'l_wt_uom',l_wt_uom );
436: END IF;
437: IF l_vol_uom IS NULL OR l_wt_uom IS NULL THEN --{
438: IF l_debug_on THEN
439: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.GET_DEFAULT_UOMS',WSH_DEBUG_SV.C_PROC_LEVEL);
440: END IF;
441: --
442: WSH_WV_UTILS.Get_Default_Uoms (
443: P_container_rec.organization_id,

Line 442: WSH_WV_UTILS.Get_Default_Uoms (

438: IF l_debug_on THEN
439: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.GET_DEFAULT_UOMS',WSH_DEBUG_SV.C_PROC_LEVEL);
440: END IF;
441: --
442: WSH_WV_UTILS.Get_Default_Uoms (
443: P_container_rec.organization_id,
444: -- bug 761576
445: --l_wt_uom,
446: --l_vol_uom,

Line 510: WSH_WV_UTILS.Convert_Uom_core (

506: l_additional_cont_attr.filled_volume_uom_code := NVL(l_additional_cont_attr.filled_volume_uom_code, l_vol_uom);
507:
508: IF p_container_rec.volume_uom_code <> l_vol_uom THEN
509: p_container_rec.volume :=
510: WSH_WV_UTILS.Convert_Uom_core (
511: from_uom => p_container_rec.volume_uom_code,
512: to_uom => l_vol_uom,
513: quantity => p_container_rec.volume,
514: item_id => P_container_rec.inventory_item_id,

Line 529: WSH_WV_UTILS.Convert_Uom_core (

525: p_container_rec.volume_uom_code := l_vol_uom;
526:
527: IF l_additional_cont_attr.filled_volume_uom_code <> l_vol_uom THEN
528: p_container_rec.filled_volume :=
529: WSH_WV_UTILS.Convert_Uom_core (
530: from_uom =>l_additional_cont_attr.filled_volume_uom_code,
531: to_uom =>l_vol_uom,
532: quantity =>p_container_rec.filled_volume,
533: item_id =>P_container_rec.inventory_item_id,

Line 548: WSH_WV_UTILS.Convert_Uom_core (

544:
545: p_container_rec.weight_uom_code := NVL(p_container_rec.weight_uom_code,l_wt_uom);
546: IF p_container_rec.weight_uom_code <> l_wt_uom THEN
547: p_container_rec.gross_weight :=
548: WSH_WV_UTILS.Convert_Uom_core (
549: from_uom => p_container_rec.weight_uom_code,
550: to_uom => l_wt_uom,
551: quantity => p_container_rec.gross_weight,
552: item_id => P_container_rec.inventory_item_id,

Line 563: WSH_WV_UTILS.Convert_Uom_core (

559: x_num_errors => l_num_errors
560: );
561: IF p_container_rec.net_weight is not NULL THEN
562: p_container_rec.net_weight :=
563: WSH_WV_UTILS.Convert_Uom_core (
564: from_uom => p_container_rec.weight_uom_code,
565: to_uom => l_wt_uom,
566: quantity => p_container_rec.net_weight,
567: item_id =>P_container_rec.inventory_item_id,

Line 581: WSH_WV_UTILS.Convert_Uom_core (

577: p_container_rec.weight_uom_code := l_wt_uom;
578:
579: IF l_additional_cont_attr.tare_weight_uom_code <> l_wt_uom THEN
580: l_additional_cont_attr.tare_weight :=
581: WSH_WV_UTILS.Convert_Uom_core (
582: from_uom=>l_additional_cont_attr.tare_weight_uom_code,
583: to_uom => l_wt_uom,
584: quantity => l_additional_cont_attr.tare_weight,
585: item_id => P_container_rec.inventory_item_id,

Line 1052: - WSH_WV_UTILS.Convert_Uom (l_tare_wt_uom,

1048: AND (l_container_rec.weight_uom_code IS NOT NULL)
1049: AND (l_container_rec.gross_weight IS NOT NULL)
1050: THEN
1051: l_net_weight := l_container_rec.gross_weight
1052: - WSH_WV_UTILS.Convert_Uom (l_tare_wt_uom,
1053: l_container_rec.weight_uom_code,
1054: l_tare_wt,
1055: l_inventory_item_id);
1056: END IF;

Line 3010: WSH_WV_UTILS.Check_Fill_Pc (

3006: l_wms_org = 'Y' AND nvl(wsh_wms_lpn_grp.g_caller,'WSH') like 'WMS%'
3007: )
3008: THEN
3009: --{
3010: WSH_WV_UTILS.Check_Fill_Pc (
3011: p_container_instance_id => p_container_instance_id,
3012: x_fill_status => l_fill_status,
3013: x_return_status => l_return_status);
3014:

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

5891: --
5892: IF rec.wv_frozen_flag = 'N' THEN
5893:
5894: IF l_debug_on THEN
5895: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DETAIL_WEIGHT_VOLUME',WSH_DEBUG_SV.C_PROC_LEVEL);
5896: END IF;
5897: --
5898: WSH_WV_UTILS.Detail_Weight_Volume(
5899: p_delivery_detail_id => rec.delivery_detail_id,

Line 5898: WSH_WV_UTILS.Detail_Weight_Volume(

5894: IF l_debug_on THEN
5895: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DETAIL_WEIGHT_VOLUME',WSH_DEBUG_SV.C_PROC_LEVEL);
5896: END IF;
5897: --
5898: WSH_WV_UTILS.Detail_Weight_Volume(
5899: p_delivery_detail_id => rec.delivery_detail_id,
5900: -- J: W/V Changes
5901: p_update_flag => 'Y',
5902: p_post_process_flag => 'Y',

Line 5912: --dbms_output.put_line('WSH_WV_UTILS.Detail_Weight_Volume did not return success');

5908: WSH_DEBUG_SV.log(l_module_name,'return status -',l_return_status);
5909: END IF;
5910:
5911: IF (l_return_status <> C_SUCCESS_STATUS) THEN
5912: --dbms_output.put_line('WSH_WV_UTILS.Detail_Weight_Volume did not return success');
5913: FND_MESSAGE.SET_NAME('WSH','WSH_DET_WT_VOL_FAILED');
5914: FND_MESSAGE.SET_TOKEN('DETAIL_ID',rec.delivery_detail_id);
5915: WSH_UTIL_CORE.Add_Message(l_return_status,l_module_name);
5916: error_cnt := error_cnt + 1;

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

5978:
5979: IF (l_mtl_wt_uom <> rec.weight_uom_code) THEN
5980: --
5981: IF l_debug_on THEN
5982: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
5983: END IF;
5984: --
5985: l_dd_gross_wt := WSH_WV_UTILS.Convert_Uom (
5986: from_uom => rec.weight_uom_code,

Line 5985: l_dd_gross_wt := WSH_WV_UTILS.Convert_Uom (

5981: IF l_debug_on THEN
5982: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
5983: END IF;
5984: --
5985: l_dd_gross_wt := WSH_WV_UTILS.Convert_Uom (
5986: from_uom => rec.weight_uom_code,
5987: to_uom => l_mtl_wt_uom,
5988: quantity => rec.gross_weight,
5989: item_id => rec.inventory_item_id);

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

5993:
5994: IF (l_mtl_vol_uom <> rec.volume_uom_code) THEN
5995: --
5996: IF l_debug_on THEN
5997: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
5998: END IF;
5999: --
6000: l_dd_volume := WSH_WV_UTILS.Convert_Uom (
6001: from_uom => rec.volume_uom_code,

Line 6000: l_dd_volume := WSH_WV_UTILS.Convert_Uom (

5996: IF l_debug_on THEN
5997: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
5998: END IF;
5999: --
6000: l_dd_volume := WSH_WV_UTILS.Convert_Uom (
6001: from_uom => rec.volume_uom_code,
6002: to_uom => l_mtl_vol_uom,
6003: quantity => rec.volume,
6004: item_id => rec.inventory_item_id);

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

6067: --
6068: IF rec.wv_frozen_flag = 'N' THEN
6069:
6070: IF l_debug_on THEN
6071: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DETAIL_WEIGHT_VOLUME',WSH_DEBUG_SV.C_PROC_LEVEL);
6072: END IF;
6073: --
6074: WSH_WV_UTILS.Detail_Weight_Volume(
6075: p_delivery_detail_id => rec.delivery_detail_id,

Line 6074: WSH_WV_UTILS.Detail_Weight_Volume(

6070: IF l_debug_on THEN
6071: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DETAIL_WEIGHT_VOLUME',WSH_DEBUG_SV.C_PROC_LEVEL);
6072: END IF;
6073: --
6074: WSH_WV_UTILS.Detail_Weight_Volume(
6075: p_delivery_detail_id => rec.delivery_detail_id,
6076: -- J: W/V Changes
6077: p_update_flag => 'Y',
6078: p_post_process_flag => 'Y',

Line 6089: --dbms_output.put_line('WSH_WV_UTILS.Detail_Weight_Volume did not return success');

6085: WSH_DEBUG_SV.log(l_module_name,'return status -,wt,vol',l_return_status||l_dd_net_wt||','||l_dd_volume);
6086: END IF;
6087:
6088: IF (l_return_status <> C_SUCCESS_STATUS) THEN
6089: --dbms_output.put_line('WSH_WV_UTILS.Detail_Weight_Volume did not return success');
6090: FND_MESSAGE.SET_NAME('WSH','WSH_DET_WT_VOL_FAILED');
6091: FND_MESSAGE.SET_TOKEN('DETAIL_ID',rec.delivery_detail_id);
6092: WSH_UTIL_CORE.Add_Message(C_ERROR_STATUS,l_module_name);
6093: error_cnt := error_cnt + 1;

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

6159:
6160: IF (l_mtl_wt_uom <> rec.weight_uom_code) THEN
6161: --
6162: IF l_debug_on THEN
6163: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
6164: END IF;
6165: --
6166: l_dd_gross_wt := WSH_WV_UTILS.Convert_Uom (
6167: from_uom => rec.weight_uom_code,

Line 6166: l_dd_gross_wt := WSH_WV_UTILS.Convert_Uom (

6162: IF l_debug_on THEN
6163: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
6164: END IF;
6165: --
6166: l_dd_gross_wt := WSH_WV_UTILS.Convert_Uom (
6167: from_uom => rec.weight_uom_code,
6168: to_uom => l_mtl_wt_uom,
6169: quantity => rec.gross_weight,
6170: item_id => rec.inventory_item_id);

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

6183:
6184: IF (l_mtl_vol_uom <> rec.volume_uom_code) THEN
6185: --
6186: IF l_debug_on THEN
6187: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
6188: END IF;
6189: --
6190: l_dd_volume := WSH_WV_UTILS.Convert_Uom (
6191: from_uom => rec.volume_uom_code,

Line 6190: l_dd_volume := WSH_WV_UTILS.Convert_Uom (

6186: IF l_debug_on THEN
6187: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
6188: END IF;
6189: --
6190: l_dd_volume := WSH_WV_UTILS.Convert_Uom (
6191: from_uom => rec.volume_uom_code,
6192: to_uom => l_mtl_vol_uom,
6193: quantity => rec.volume,
6194: item_id => rec.inventory_item_id);

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

7174:
7175: -- J: W/V Changes
7176: FOR i in 1..l_tmp_dd1list.COUNT LOOP
7177: IF l_debug_on THEN
7178: WSH_DEBUG_SV.logmsg(l_module_name,'Del1:Calling program unit WSH_WV_UTILS.DD_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);
7179: END IF;
7180:
7181: WSH_WV_UTILS.DD_WV_Post_Process(
7182: p_delivery_detail_id => l_tmp_dd1list(i).dd_id,

Line 7181: WSH_WV_UTILS.DD_WV_Post_Process(

7177: IF l_debug_on THEN
7178: WSH_DEBUG_SV.logmsg(l_module_name,'Del1:Calling program unit WSH_WV_UTILS.DD_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);
7179: END IF;
7180:
7181: WSH_WV_UTILS.DD_WV_Post_Process(
7182: p_delivery_detail_id => l_tmp_dd1list(i).dd_id,
7183: p_diff_gross_wt => l_tmp_dd1list(i).gross_wt,
7184: p_diff_net_wt => NULL,
7185: p_diff_volume => l_tmp_dd1list(i).vol,

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

7302: WSH_DEBUG_SV.log(l_module_name,'before W/V adjustment 2 '||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));
7303: END IF;
7304: FOR i in 1..l_tmp_dd2list.COUNT LOOP
7305: IF l_debug_on THEN
7306: WSH_DEBUG_SV.logmsg(l_module_name,'Del2:Calling program unit WSH_WV_UTILS.DD_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);
7307: END IF;
7308:
7309: WSH_WV_UTILS.DD_WV_Post_Process(
7310: p_delivery_detail_id => l_tmp_dd2list(i).dd_id,

Line 7309: WSH_WV_UTILS.DD_WV_Post_Process(

7305: IF l_debug_on THEN
7306: WSH_DEBUG_SV.logmsg(l_module_name,'Del2:Calling program unit WSH_WV_UTILS.DD_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);
7307: END IF;
7308:
7309: WSH_WV_UTILS.DD_WV_Post_Process(
7310: p_delivery_detail_id => l_tmp_dd2list(i).dd_id,
7311: p_diff_gross_wt => l_tmp_dd2list(i).gross_wt,
7312: p_diff_net_wt => l_tmp_dd2list(i).net_wt,
7313: p_diff_volume => l_tmp_dd2list(i).vol,

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

7741: WSH_DEBUG_SV.log(l_module_name,'before W/V adjustment 3 '||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));
7742: END IF;
7743: FOR i in 1..l_contlist1.COUNT LOOP
7744: IF l_debug_on THEN
7745: WSH_DEBUG_SV.logmsg(l_module_name,'Cont:Calling program unit WSH_WV_UTILS.DD_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);
7746: END IF;
7747:
7748: WSH_WV_UTILS.DD_WV_Post_Process(
7749: p_delivery_detail_id => l_contlist1(i),

Line 7748: WSH_WV_UTILS.DD_WV_Post_Process(

7744: IF l_debug_on THEN
7745: WSH_DEBUG_SV.logmsg(l_module_name,'Cont:Calling program unit WSH_WV_UTILS.DD_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);
7746: END IF;
7747:
7748: WSH_WV_UTILS.DD_WV_Post_Process(
7749: p_delivery_detail_id => l_contlist1(i),
7750: p_diff_gross_wt => l_cont_Wtlist(i),
7751: p_diff_net_wt => NULL,
7752: p_diff_volume => l_cont_Vollist(i),

Line 8921: -- WSH_WV_UTILS.Container_Weight_Volume (

8917:
8918: --dbms_output.put_line('processing container ' || i || ' id is ' || l_cont_tab(i).container_instance_id);
8919:
8920: /*
8921: -- WSH_WV_UTILS.Container_Weight_Volume (
8922: -- replacing with TPA enabled API..
8923:
8924: --
8925: IF l_debug_on THEN

Line 9046: WSH_WV_UTILS.Check_Fill_Pc (

9042: ELSIF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
9043: l_det_tab(j).pack_status := 'Packed';
9044: l_det_pack_sts := 'Packed';
9045: -- J: W/V Changes
9046: WSH_WV_UTILS.Check_Fill_Pc (
9047: p_container_instance_id => l_cont_tab(i).container_instance_id,
9048: x_fill_status => l_fill_status,
9049: x_return_status => l_return_status);
9050:

Line 9235: WSH_WV_UTILS.Check_Fill_Pc (

9231: l_det_tab(l_tmp_det_count).pack_status := 'Packed';
9232: l_cont_tab(i).pack_status := 'Packed';
9233: -- J: W/V Changes
9234:
9235: WSH_WV_UTILS.Check_Fill_Pc (
9236: p_container_instance_id => l_cont_tab(i).container_instance_id,
9237: x_fill_status => l_fill_status,
9238: x_return_status => l_return_status);
9239:

Line 9569: WSH_WV_UTILS.Check_Fill_Pc (

9565: l_det_tab(l_tmp_det_count).pack_status := 'Packed';
9566: l_cont_tab(i).pack_status := 'Packed';
9567:
9568: -- J: W/V Changes
9569: WSH_WV_UTILS.Check_Fill_Pc (
9570: p_container_instance_id => l_cont_tab(i).container_instance_id,
9571: x_fill_status => l_fill_status,
9572: x_return_status => l_return_status);
9573:

Line 10788: WSH_WV_UTILS.Container_Weight_Volume(

10784: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TPA_CONTAINER_PKG.CONTAINER_WEIGHT_VOLUME',WSH_DEBUG_SV.C_PROC_LEVEL);
10785: END IF;
10786: --
10787: -- J: W/V Changes
10788: WSH_WV_UTILS.Container_Weight_Volume(
10789: p_container_instance_id => line_cont_rec.delivery_detail_id,
10790: p_override_flag => 'Y',
10791: p_post_process_flag => 'Y',
10792: p_calc_wv_if_frozen => 'N',

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

10858:
10859: IF (l_mtl_wt_uom <> line_cont_rec.weight_uom) THEN
10860: --
10861: IF l_debug_on THEN
10862: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
10863: END IF;
10864: --
10865: l_dd_gross_wt := WSH_WV_UTILS.Convert_Uom (
10866: from_uom => line_cont_rec.weight_uom,

Line 10865: l_dd_gross_wt := WSH_WV_UTILS.Convert_Uom (

10861: IF l_debug_on THEN
10862: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
10863: END IF;
10864: --
10865: l_dd_gross_wt := WSH_WV_UTILS.Convert_Uom (
10866: from_uom => line_cont_rec.weight_uom,
10867: to_uom => l_mtl_wt_uom,
10868: quantity => line_cont_rec.gross_weight,
10869: item_id => line_cont_rec.inventory_item_id);

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

10873:
10874: IF (l_mtl_vol_uom <> line_cont_rec.volume_uom) THEN
10875: --
10876: IF l_debug_on THEN
10877: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
10878: END IF;
10879: --
10880: l_dd_volume := WSH_WV_UTILS.Convert_Uom (
10881: from_uom => line_cont_rec.volume_uom,

Line 10880: l_dd_volume := WSH_WV_UTILS.Convert_Uom (

10876: IF l_debug_on THEN
10877: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
10878: END IF;
10879: --
10880: l_dd_volume := WSH_WV_UTILS.Convert_Uom (
10881: from_uom => line_cont_rec.volume_uom,
10882: to_uom => l_mtl_vol_uom,
10883: quantity => line_cont_rec.volume,
10884: item_id => line_cont_rec.inventory_item_id);

Line 10924: WSH_WV_UTILS.Container_Weight_Volume(

10920: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TPA_CONTAINER_PKG.CONTAINER_WEIGHT_VOLUME',WSH_DEBUG_SV.C_PROC_LEVEL);
10921: END IF;
10922: --
10923: -- J: W/V Changes
10924: WSH_WV_UTILS.Container_Weight_Volume(
10925: p_container_instance_id => line_cont_rec.delivery_detail_id,
10926: p_override_flag => 'Y',
10927: p_post_process_flag => 'Y',
10928: p_calc_wv_if_frozen => 'N',

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

11018:
11019: IF (l_mtl_wt_uom <> line_cont_rec.weight_uom) THEN
11020: --
11021: IF l_debug_on THEN
11022: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
11023: END IF;
11024: --
11025: l_dd_net_wt := WSH_WV_UTILS.Convert_Uom (
11026: from_uom => line_cont_rec.weight_uom,

Line 11025: l_dd_net_wt := WSH_WV_UTILS.Convert_Uom (

11021: IF l_debug_on THEN
11022: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
11023: END IF;
11024: --
11025: l_dd_net_wt := WSH_WV_UTILS.Convert_Uom (
11026: from_uom => line_cont_rec.weight_uom,
11027: to_uom => l_mtl_wt_uom,
11028: quantity => line_cont_rec.gross_weight,
11029: item_id => line_cont_rec.inventory_item_id);

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

11044:
11045: IF (l_mtl_vol_uom <> line_cont_rec.volume_uom) THEN
11046: --
11047: IF l_debug_on THEN
11048: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
11049: END IF;
11050: --
11051: l_dd_volume := WSH_WV_UTILS.Convert_Uom (
11052: from_uom => line_cont_rec.volume_uom,

Line 11051: l_dd_volume := WSH_WV_UTILS.Convert_Uom (

11047: IF l_debug_on THEN
11048: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
11049: END IF;
11050: --
11051: l_dd_volume := WSH_WV_UTILS.Convert_Uom (
11052: from_uom => line_cont_rec.volume_uom,
11053: to_uom => l_mtl_vol_uom,
11054: quantity => line_cont_rec.volume,
11055: item_id => line_cont_rec.inventory_item_id);

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

14032:
14033: -- Handle wt/vol for consol deliveries/LPNs.
14034: /***
14035: IF l_debug_on THEN
14036: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.Container_Weight_Volume',WSH_DEBUG_SV.C_PROC_LEVEL);
14037: END IF;
14038: WSH_WV_UTILS.Container_Weight_Volume (
14039: p_container_instance_id => p_parent_container_id,
14040: p_override_flag => 'Y',

Line 14038: WSH_WV_UTILS.Container_Weight_Volume (

14034: /***
14035: IF l_debug_on THEN
14036: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.Container_Weight_Volume',WSH_DEBUG_SV.C_PROC_LEVEL);
14037: END IF;
14038: WSH_WV_UTILS.Container_Weight_Volume (
14039: p_container_instance_id => p_parent_container_id,
14040: p_override_flag => 'Y',
14041: p_fill_pc_flag => 'Y',
14042: p_post_process_flag => 'N',

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

14086: END IF;
14087: /*
14088:
14089: IF l_debug_on THEN
14090: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.Delivery_Weight_Volume',WSH_DEBUG_SV.C_PROC_LEVEL);
14091: END IF;
14092:
14093: WSH_WV_UTILS.Delivery_Weight_Volume
14094: ( p_delivery_id => l_new_parent_delivery_id,

Line 14093: WSH_WV_UTILS.Delivery_Weight_Volume

14089: IF l_debug_on THEN
14090: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.Delivery_Weight_Volume',WSH_DEBUG_SV.C_PROC_LEVEL);
14091: END IF;
14092:
14093: WSH_WV_UTILS.Delivery_Weight_Volume
14094: ( p_delivery_id => l_new_parent_delivery_id,
14095: p_update_flag => 'Y',
14096: p_calc_wv_if_frozen => 'N',
14097: x_gross_weight => l_gross_wt,

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

14401: IF NVL(l_cont_gross_weight, 0) = 0 THEN
14402: l_child_gross_weight := 0;
14403: ELSE
14404: IF l_debug_on THEN
14405: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.convert_uom',WSH_DEBUG_SV.C_PROC_LEVEL);
14406: WSH_DEBUG_SV.log(l_module_name,'l_cont_gross_weight',l_cont_gross_weight);
14407: END IF;
14408: l_child_gross_weight :=
14409: WSH_WV_UTILS.convert_uom(l_child_weight_UOM, l_parent_weight_UOM, l_cont_gross_weight, l_child_inv_item_id);

Line 14409: WSH_WV_UTILS.convert_uom(l_child_weight_UOM, l_parent_weight_UOM, l_cont_gross_weight, l_child_inv_item_id);

14405: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.convert_uom',WSH_DEBUG_SV.C_PROC_LEVEL);
14406: WSH_DEBUG_SV.log(l_module_name,'l_cont_gross_weight',l_cont_gross_weight);
14407: END IF;
14408: l_child_gross_weight :=
14409: WSH_WV_UTILS.convert_uom(l_child_weight_UOM, l_parent_weight_UOM, l_cont_gross_weight, l_child_inv_item_id);
14410: END IF;
14411: IF NVL(l_cont_net_weight, 0) = 0 THEN
14412: l_child_net_weight := 0;
14413: ELSE

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

14411: IF NVL(l_cont_net_weight, 0) = 0 THEN
14412: l_child_net_weight := 0;
14413: ELSE
14414: IF l_debug_on THEN
14415: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.convert_uom',WSH_DEBUG_SV.C_PROC_LEVEL);
14416: WSH_DEBUG_SV.log(l_module_name,'l_cont_net_weight',l_cont_net_weight);
14417: END IF;
14418: l_child_net_weight :=
14419: WSH_WV_UTILS.convert_uom(l_child_weight_UOM, l_parent_weight_UOM, l_cont_net_weight, l_child_inv_item_id);

Line 14419: WSH_WV_UTILS.convert_uom(l_child_weight_UOM, l_parent_weight_UOM, l_cont_net_weight, l_child_inv_item_id);

14415: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.convert_uom',WSH_DEBUG_SV.C_PROC_LEVEL);
14416: WSH_DEBUG_SV.log(l_module_name,'l_cont_net_weight',l_cont_net_weight);
14417: END IF;
14418: l_child_net_weight :=
14419: WSH_WV_UTILS.convert_uom(l_child_weight_UOM, l_parent_weight_UOM, l_cont_net_weight, l_child_inv_item_id);
14420: END IF;
14421:
14422: END IF;
14423: IF l_child_volume_UOM = l_parent_volume_UOM THEN

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

14427: IF NVL(l_cont_volume, 0) = 0 THEN
14428: l_child_volume := 0;
14429: ELSE
14430: IF l_debug_on THEN
14431: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.convert_uom',WSH_DEBUG_SV.C_PROC_LEVEL);
14432: WSH_DEBUG_SV.log(l_module_name,'l_cont_volume',l_cont_volume);
14433: END IF;
14434: l_child_volume :=
14435: WSH_WV_UTILS.convert_uom(l_child_volume_UOM, l_parent_volume_UOM, l_cont_volume, l_child_inv_item_id);

Line 14435: WSH_WV_UTILS.convert_uom(l_child_volume_UOM, l_parent_volume_UOM, l_cont_volume, l_child_inv_item_id);

14431: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.convert_uom',WSH_DEBUG_SV.C_PROC_LEVEL);
14432: WSH_DEBUG_SV.log(l_module_name,'l_cont_volume',l_cont_volume);
14433: END IF;
14434: l_child_volume :=
14435: WSH_WV_UTILS.convert_uom(l_child_volume_UOM, l_parent_volume_UOM, l_cont_volume, l_child_inv_item_id);
14436: END IF;
14437:
14438: END IF;
14439:

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

14437:
14438: END IF;
14439:
14440: IF l_debug_on THEN
14441: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DD_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);
14442: END IF;
14443:
14444: WSH_WV_UTILS.DD_WV_Post_Process(
14445: p_delivery_detail_id => l_parent_dd_id,

Line 14444: WSH_WV_UTILS.DD_WV_Post_Process(

14440: IF l_debug_on THEN
14441: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DD_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);
14442: END IF;
14443:
14444: WSH_WV_UTILS.DD_WV_Post_Process(
14445: p_delivery_detail_id => l_parent_dd_id,
14446: p_diff_gross_wt => l_child_gross_weight,
14447: p_diff_net_wt => l_child_net_weight,
14448: p_diff_volume => l_child_volume,