APPS.WSH_DETAILS_VALIDATIONS dependencies on WSH_WV_UTILS

Line 1721: SELECT WSH_WV_UTILS.CONVERT_UOM(order_quantity_uom,

1717:
1718: CURSOR c_ordered_quantity(x_source_line_id IN NUMBER,
1719: x_item_id IN NUMBER,
1720: x_primary_uom IN VARCHAR2) IS
1721: SELECT WSH_WV_UTILS.CONVERT_UOM(order_quantity_uom,
1722: x_primary_uom,
1723: ordered_quantity,
1724: x_item_id) quantity ,
1725: order_quantity_uom,

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

1929: --
1930: -- Debug Statements
1931: --
1932: IF l_debug_on THEN
1933: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
1934: END IF;
1935: --
1936: l_max_quantity := l_max_quantity
1937: - l_staged_info.net_staged_qty;

Line 3322: x_out_attributes.min_remaining_quantity := WSH_WV_UTILS.convert_uom(

3318: -- convert to order line UOM
3319: IF l_ordered_quantity_uom <> l_requested_quantity_uom THEN
3320:
3321: IF l_min_remaining_quantity > 0 THEN
3322: x_out_attributes.min_remaining_quantity := WSH_WV_UTILS.convert_uom(
3323: from_uom => l_requested_quantity_uom,
3324: to_uom => l_ordered_quantity_uom,
3325: quantity => l_min_remaining_quantity,
3326: item_id => l_inventory_item_id);

Line 3329: x_out_attributes.max_remaining_quantity := WSH_WV_UTILS.convert_uom(

3325: quantity => l_min_remaining_quantity,
3326: item_id => l_inventory_item_id);
3327: END IF;
3328: IF l_max_remaining_quantity > 0 THEN
3329: x_out_attributes.max_remaining_quantity := WSH_WV_UTILS.convert_uom(
3330: from_uom => l_requested_quantity_uom,
3331: to_uom => l_ordered_quantity_uom,
3332: quantity => l_max_remaining_quantity,
3333: item_id => l_inventory_item_id);

Line 6672: x_det_rec.cycle_count_quantity2 := WSH_WV_UTILS.convert_uom

6668: --1.b) if null, clear cycle count and secondary quantity
6669: IF(x_det_rec.shipped_quantity2 IS NOT NULL) THEN
6670: --x_det_rec.cycle_count_quantity2 := Greatest((x_det_rec.requested_quantity2 - x_det_rec.shipped_quantity2),0);
6671: -- bug 5391211, cycle_count_qty2 should be a value that is derived from qty1
6672: x_det_rec.cycle_count_quantity2 := WSH_WV_UTILS.convert_uom
6673: (
6674: from_uom => x_det_rec.requested_quantity_uom,
6675: to_uom => x_det_rec.requested_quantity_uom2,
6676: quantity => x_det_rec.cycle_count_quantity,

Line 7213: WSH_WV_UTILS.within_deviation', wsh_debug_sv.c_proc_level);

7209: --{
7210: --
7211: IF l_debug_on THEN
7212: wsh_debug_sv.logmsg(l_module_name, 'Calling program unit
7213: WSH_WV_UTILS.within_deviation', wsh_debug_sv.c_proc_level);
7214: END IF;
7215: --
7216: -- HW OPMCONV - Call new API to check deviation
7217: l_return := WSH_WV_UTILS.within_deviation

Line 7217: l_return := WSH_WV_UTILS.within_deviation

7213: WSH_WV_UTILS.within_deviation', wsh_debug_sv.c_proc_level);
7214: END IF;
7215: --
7216: -- HW OPMCONV - Call new API to check deviation
7217: l_return := WSH_WV_UTILS.within_deviation
7218: (
7219: p_organization_id => l_line_rec.organization_id,
7220: p_inventory_item_id => l_line_rec.inventory_item_id,
7221: p_lot_number => l_lot_num,

Line 7250: wsh_debug_sv.logmsg(l_module_name, 'Calling program unit WSH_WV_UTILS.convert_uom', wsh_debug_sv.c_proc_level);

7246: THEN
7247: --{
7248: --
7249: IF l_debug_on THEN
7250: wsh_debug_sv.logmsg(l_module_name, 'Calling program unit WSH_WV_UTILS.convert_uom', wsh_debug_sv.c_proc_level);
7251: END IF;
7252: --
7253: -- HW OPMCONV - Call UOM routine passing lot_num
7254: l_qty2 := WSH_WV_UTILS.convert_uom

Line 7254: l_qty2 := WSH_WV_UTILS.convert_uom

7250: wsh_debug_sv.logmsg(l_module_name, 'Calling program unit WSH_WV_UTILS.convert_uom', wsh_debug_sv.c_proc_level);
7251: END IF;
7252: --
7253: -- HW OPMCONV - Call UOM routine passing lot_num
7254: l_qty2 := WSH_WV_UTILS.convert_uom
7255: (
7256: item_id => l_line_rec.inventory_item_id,
7257: org_id => l_line_rec.organization_id,
7258: from_uom => l_line_rec.requested_quantity_uom,