201: END IF;
202:
203: -- J: W/V Changes
204:
205: WSH_WV_UTILS.Check_Fill_Pc (
206: p_container_instance_id => p_parent_detail_id,
207: x_fill_status => l_fill_status,
208: x_return_status => l_return_status);
209:
1797: END IF;
1798:
1799: IF (tmp_gr_wt IS NULL) THEN
1800:
1801: -- WSH_WV_UTILS.Container_Weight_Volume (
1802: -- replacing with TPA enabled API..
1803: --
1804: -- Debug Statements
1805: --
1839: fill_pc := 0;
1840: END IF;
1841: END IF;
1842:
1843: -- WSH_WV_UTILS.Container_Tare_Weight_Self (
1844: -- replacing with TPA enabled API..
1845:
1846: --
1847: -- Debug Statements
1877: --
1878: -- Debug Statements
1879: --
1880: IF l_debug_on THEN
1881: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.GET_DEFAULT_UOMS',WSH_DEBUG_SV.C_PROC_LEVEL);
1882: END IF;
1883: --
1884: WSH_WV_UTILS.Get_Default_Uoms (
1885: cont_org_id,
1880: IF l_debug_on THEN
1881: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.GET_DEFAULT_UOMS',WSH_DEBUG_SV.C_PROC_LEVEL);
1882: END IF;
1883: --
1884: WSH_WV_UTILS.Get_Default_Uoms (
1885: cont_org_id,
1886: wsh_wt_uom,
1887: wsh_vol_uom,
1888: l_ret_sts);
1911: --
1912: -- Debug Statements
1913: --
1914: IF l_debug_on THEN
1915: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
1916: END IF;
1917: --
1918: gr_wt := WSH_WV_UTILS.Convert_Uom (
1919: wt_uom,
1914: IF l_debug_on THEN
1915: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
1916: END IF;
1917: --
1918: gr_wt := WSH_WV_UTILS.Convert_Uom (
1919: wt_uom,
1920: wsh_wt_uom,
1921: tmp_gr_wt,
1922: cont_item_id);
1924: --
1925: -- Debug Statements
1926: --
1927: IF l_debug_on THEN
1928: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
1929: END IF;
1930: --
1931: net_wt := WSH_WV_UTILS.Convert_Uom (
1932: wt_uom,
1927: IF l_debug_on THEN
1928: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
1929: END IF;
1930: --
1931: net_wt := WSH_WV_UTILS.Convert_Uom (
1932: wt_uom,
1933: wsh_wt_uom,
1934: tmp_net_wt,
1935: cont_item_id);
1937: --
1938: -- Debug Statements
1939: --
1940: IF l_debug_on THEN
1941: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
1942: END IF;
1943: --
1944: max_load_wt := WSH_WV_UTILS.Convert_Uom (
1945: wt_uom,
1940: IF l_debug_on THEN
1941: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
1942: END IF;
1943: --
1944: max_load_wt := WSH_WV_UTILS.Convert_Uom (
1945: wt_uom,
1946: wsh_wt_uom,
1947: tmp_max_load_wt,
1948: cont_item_id);
1951: --
1952: -- Debug Statements
1953: --
1954: IF l_debug_on THEN
1955: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
1956: END IF;
1957: --
1958: fill_vol := WSH_WV_UTILS.Convert_Uom (
1959: vol_uom,
1954: IF l_debug_on THEN
1955: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
1956: END IF;
1957: --
1958: fill_vol := WSH_WV_UTILS.Convert_Uom (
1959: vol_uom,
1960: wsh_vol_uom,
1961: tmp_fil_vol,
1962: cont_item_id);
1965: --
1966: -- Debug Statements
1967: --
1968: IF l_debug_on THEN
1969: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
1970: END IF;
1971: --
1972: max_vol := WSH_WV_UTILS.Convert_Uom (
1973: vol_uom,
1968: IF l_debug_on THEN
1969: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
1970: END IF;
1971: --
1972: max_vol := WSH_WV_UTILS.Convert_Uom (
1973: vol_uom,
1974: wsh_vol_uom,
1975: tmp_max_vol,
1976: cont_item_id);
1979: --
1980: -- Debug Statements
1981: --
1982: IF l_debug_on THEN
1983: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
1984: END IF;
1985: --
1986: tare_wt := WSH_WV_UTILS.Convert_Uom (
1987: wt_uom,
1982: IF l_debug_on THEN
1983: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
1984: END IF;
1985: --
1986: tare_wt := WSH_WV_UTILS.Convert_Uom (
1987: wt_uom,
1988: wsh_wt_uom,
1989: tmp_tare_wt,
1990: cont_item_id);
2150: --
2151: -- Debug Statements
2152: --
2153: IF l_debug_on THEN
2154: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DETAIL_WEIGHT_VOLUME',WSH_DEBUG_SV.C_PROC_LEVEL);
2155: END IF;
2156: --
2157: WSH_WV_UTILS.Detail_Weight_Volume (
2158: p_delivery_detail_id => p_delivery_detail_id,
2153: IF l_debug_on THEN
2154: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DETAIL_WEIGHT_VOLUME',WSH_DEBUG_SV.C_PROC_LEVEL);
2155: END IF;
2156: --
2157: WSH_WV_UTILS.Detail_Weight_Volume (
2158: p_delivery_detail_id => p_delivery_detail_id,
2159: p_update_flag => 'N',
2160: x_net_weight => tmp_net_wt,
2161: x_volume => tmp_vol,
2184: --
2185: -- Debug Statements
2186: --
2187: IF l_debug_on THEN
2188: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.GET_DEFAULT_UOMS',WSH_DEBUG_SV.C_PROC_LEVEL);
2189: END IF;
2190: --
2191: WSH_WV_UTILS.Get_Default_Uoms (
2192: det_org_id,
2187: IF l_debug_on THEN
2188: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.GET_DEFAULT_UOMS',WSH_DEBUG_SV.C_PROC_LEVEL);
2189: END IF;
2190: --
2191: WSH_WV_UTILS.Get_Default_Uoms (
2192: det_org_id,
2193: wsh_wt_uom,
2194: wsh_vol_uom,
2195: l_ret_sts);
2219: --
2220: -- Debug Statements
2221: --
2222: IF l_debug_on THEN
2223: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
2224: END IF;
2225: --
2226: net_wt := WSH_WV_UTILS.Convert_Uom (
2227: wt_uom,
2222: IF l_debug_on THEN
2223: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
2224: END IF;
2225: --
2226: net_wt := WSH_WV_UTILS.Convert_Uom (
2227: wt_uom,
2228: wsh_wt_uom,
2229: tmp_net_wt,
2230: det_item_id);
2232: --
2233: -- Debug Statements
2234: --
2235: IF l_debug_on THEN
2236: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
2237: END IF;
2238: --
2239: vol := WSH_WV_UTILS.Convert_Uom (
2240: vol_uom,
2235: IF l_debug_on THEN
2236: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
2237: END IF;
2238: --
2239: vol := WSH_WV_UTILS.Convert_Uom (
2240: vol_uom,
2241: wsh_vol_uom,
2242: tmp_vol,
2243: det_item_id);