eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_DETAILS_VALIDATIONS dependencies on WSH_DELIVERY_DETAILS

Line 8: G_SUBINVENTORY WSH_DELIVERY_DETAILS.Subinventory%TYPE;

4:
5: --
6: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_DETAILS_VALIDATIONS';
7: -- Global Variable added for bug 4399278, 4418754
8: G_SUBINVENTORY WSH_DELIVERY_DETAILS.Subinventory%TYPE;
9: --
10:
11: --public api changes
12: PROCEDURE user_non_updatable_columns

Line 773: wsh_delivery_Details dd

769: cursor check_unassign (detail_id IN NUMBER) is
770: select da.parent_delivery_detail_id , da.delivery_id ,
771: dd.container_name , dd.container_flag
772: from wsh_delivery_assignments da,
773: wsh_delivery_Details dd
774: where da.delivery_detail_id = detail_id
775: and nvl(da.type,'S') in ('S', 'C')
776: and da.parent_Delivery_Detail_id = dd.delivery_Detail_id (+);
777:

Line 1093: FROM wsh_delivery_details

1089: -- BUG#:1549665 hwahdani retrieve ship_from_location_id,order_number,line number
1090: CURSOR get_source_info IS
1091: SELECT source_header_id, source_line_id,ship_from_location_id,
1092: source_header_number, source_line_number, org_id, container_flag
1093: FROM wsh_delivery_details
1094: WHERE delivery_detail_id = p_detail_id;
1095:
1096: -- BUG#:1549665 hwahdani get order information
1097: --Bug 1697471: added source_line_id in the where clause

Line 1100: FROM wsh_delivery_details

1096: -- BUG#:1549665 hwahdani get order information
1097: --Bug 1697471: added source_line_id in the where clause
1098: CURSOR get_order_info IS
1099: SELECT ship_from_location_id,source_header_number, source_line_number, org_id, container_flag
1100: FROM wsh_delivery_details
1101: WHERE source_header_id = p_source_header_id
1102: AND source_code = p_source_code
1103: AND source_line_id = p_source_line_id;
1104:

Line 1689: FROM wsh_delivery_details

1685: ship_tolerance_below, -- 2181132 added following fields
1686: source_header_id,
1687: source_line_set_id,
1688: source_code
1689: FROM wsh_delivery_details
1690: WHERE source_line_id = x_source_line_id
1691: AND source_code = 'OE' -- pick confirm supports only OE lines
1692: AND container_flag = 'N'
1693: AND released_status <> 'D'

Line 1710: FROM wsh_delivery_details

1706: ), 0) net_staged_qty,
1707: --NVL(SUM(NVL(picked_quantity, requested_quantity)), 0) net_staged_qty,
1708: NVL(SUM(NVL(requested_quantity2,0)), 0) net_requested_qty2,
1709: NVL(SUM(NVL(picked_quantity2, requested_quantity2)), 0) net_staged_qty2
1710: FROM wsh_delivery_details
1711: WHERE source_line_id = x_source_line_id
1712: AND source_code = 'OE'
1713: AND container_flag = 'N'
1714: AND released_status IN ('X', 'Y', 'C');

Line 1762: l_quantity_uom WSH_DELIVERY_DETAILS.requested_quantity_uom%TYPE;

1758: -- 2181132
1759: l_minmaxinrectype MinMaxInRecType;
1760: l_minmaxinoutrectype MinMaxInOutRecType;
1761: l_minmaxoutrectype MinMaxOutRecType;
1762: l_quantity_uom WSH_DELIVERY_DETAILS.requested_quantity_uom%TYPE;
1763: l_quantity_uom2 WSH_DELIVERY_DETAILS.requested_quantity_uom2%TYPE;
1764:
1765: --
1766: l_debug_on BOOLEAN;

Line 1763: l_quantity_uom2 WSH_DELIVERY_DETAILS.requested_quantity_uom2%TYPE;

1759: l_minmaxinrectype MinMaxInRecType;
1760: l_minmaxinoutrectype MinMaxInOutRecType;
1761: l_minmaxoutrectype MinMaxOutRecType;
1762: l_quantity_uom WSH_DELIVERY_DETAILS.requested_quantity_uom%TYPE;
1763: l_quantity_uom2 WSH_DELIVERY_DETAILS.requested_quantity_uom2%TYPE;
1764:
1765: --
1766: l_debug_on BOOLEAN;
1767: --

Line 2120: from wsh_delivery_details wdd, wsh_delivery_assignments_v wda

2116: x_return_status OUT NOCOPY VARCHAR2) IS
2117:
2118: CURSOR c_check_qty_inside_del (del_id IN NUMBER) IS
2119: select sum(wdd.requested_quantity), wdd.source_code, wdd.source_line_id
2120: from wsh_delivery_details wdd, wsh_delivery_assignments_v wda
2121: where wdd.delivery_detail_id = wda.delivery_detail_id
2122: and wda.delivery_id is not null
2123: and wda.delivery_id = del_id
2124: and wdd.released_status <> 'D'

Line 2131: from wsh_delivery_details wdd, wsh_delivery_assignments_v wda

2127:
2128:
2129: CURSOR c_source_info IS
2130: select distinct wdd.source_line_id, wdd.source_code
2131: from wsh_delivery_details wdd, wsh_delivery_assignments_v wda
2132: where wdd.delivery_detail_id = wda.delivery_detail_id
2133: and wdd.released_status <> 'D'
2134: and wda.delivery_id is not null
2135: and wda.delivery_id = p_delivery_id;

Line 2181: from wsh_delivery_details wdd, wsh_delivery_assignments_v wda, wsh_new_deliveries wnd

2177: FOR source_rec IN c_source_info LOOP
2178: BEGIN
2179: select sum(wdd.requested_quantity)
2180: into l_req_qty
2181: from wsh_delivery_details wdd, wsh_delivery_assignments_v wda, wsh_new_deliveries wnd
2182: where wdd.delivery_detail_id = wda.delivery_detail_id
2183: and wnd.delivery_id(+) = wda.delivery_id
2184: and (wda.delivery_id <> p_delivery_id or wda.delivery_id is NULL)
2185: and wdd.released_status not in ('C', 'D')

Line 2289: FROM wsh_delivery_details

2285: subinventory,
2286: source_code,
2287: inventory_item_id,
2288: nvl(line_direction,'O') line_direction -- J-IB-NPARIKH
2289: FROM wsh_delivery_details
2290: WHERE delivery_detail_id = p_delivery_detail_id;
2291:
2292: -- end of OPM 09/11/00
2293:

Line 2313: l_inv_controls WSH_DELIVERY_DETAILS_INV.inv_control_flag_rec;

2309: l_item_id NUMBER;
2310: l_pickable_flag VARCHAR2(1);
2311: l_subinventory VARCHAR2(30);
2312: l_line_direction VARCHAR2(30);
2313: l_inv_controls WSH_DELIVERY_DETAILS_INV.inv_control_flag_rec;
2314:
2315: -- BUG FIX 2887330
2316: l_inventory_item_id NUMBER;
2317: l_reservable_flag VARCHAR2(1);

Line 2418: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.GET_RESERVABLE_FLAG',WSH_DEBUG_SV.C_PROC_LEVEL);

2414: -- J-IB-NPARIKH-}
2415: --
2416:
2417: IF l_debug_on THEN
2418: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.GET_RESERVABLE_FLAG',WSH_DEBUG_SV.C_PROC_LEVEL);
2419: END IF;
2420:
2421: l_reservable_flag := WSH_DELIVERY_DETAILS_INV.get_reservable_flag(
2422: x_item_id => l_inventory_item_id,

Line 2421: l_reservable_flag := WSH_DELIVERY_DETAILS_INV.get_reservable_flag(

2417: IF l_debug_on THEN
2418: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.GET_RESERVABLE_FLAG',WSH_DEBUG_SV.C_PROC_LEVEL);
2419: END IF;
2420:
2421: l_reservable_flag := WSH_DELIVERY_DETAILS_INV.get_reservable_flag(
2422: x_item_id => l_inventory_item_id,
2423: x_organization_id => l_organization_id,
2424: x_pickable_flag => l_pickable_flag);
2425: if l_debug_on then

Line 2705: IF (WSH_DELIVERY_DETAILS_INV.get_reservable_flag(x_item_id => l_item_id,

2701: i := x_disabled_list.COUNT;
2702:
2703: IF (l_released_status = 'Y') THEN
2704:
2705: IF (WSH_DELIVERY_DETAILS_INV.get_reservable_flag(x_item_id => l_item_id,
2706: x_organization_id => l_organization_id,
2707: x_pickable_flag => l_pickable_flag) = 'Y')
2708: THEN
2709:

Line 2728: WSH_DELIVERY_DETAILS_INV.Fetch_Inv_Controls(p_delivery_detail_id => p_delivery_detail_id,

2724: G_SUBINVENTORY := NULL;
2725: END IF;
2726:
2727:
2728: WSH_DELIVERY_DETAILS_INV.Fetch_Inv_Controls(p_delivery_detail_id => p_delivery_detail_id,
2729: p_inventory_item_id => l_item_id,
2730: p_organization_id => l_organization_id,
2731: p_subinventory => l_subinventory,
2732: x_inv_controls_rec => l_inv_controls,

Line 2910: FROM wsh_delivery_details

2906: -- HW added requested_quantity2
2907: CURSOR c_sum_ordered_qty(x_header_id IN NUMBER, x_line_set_id IN NUMBER) IS
2908: SELECT SUM(requested_quantity),
2909: SUM(NVL(requested_quantity2,0))
2910: FROM wsh_delivery_details
2911: WHERE source_line_set_id = x_line_set_id
2912: AND source_code = p_in_attributes.source_code
2913: AND container_flag = 'N'
2914: AND released_status <> 'D'

Line 2926: FROM wsh_delivery_details

2922: SELECT nvl(SUM(GREATEST(nvl(shipped_quantity,0),
2923: nvl(picked_quantity,requested_quantity))),0),
2924: nvl(SUM(GREATEST(nvl(shipped_quantity2,0),
2925: nvl(picked_quantity2,requested_quantity2))),0)
2926: FROM wsh_delivery_details
2927: WHERE source_line_set_id = x_line_set_id
2928: AND released_status <> 'D'
2929: AND source_line_id <> p_in_attributes.line_id
2930: AND source_code = p_in_attributes.source_code

Line 2942: FROM wsh_delivery_details

2938: -- the line would not be split (since line_set_id has to be NULL
2939: -- to use this cursor) and therefore the source line is fulfilled.
2940: CURSOR c_sum_line_shp_qty IS
2941: SELECT NVL(SUM(shipped_quantity), 0)
2942: FROM wsh_delivery_details
2943: WHERE source_line_id = p_in_attributes.line_id
2944: AND released_status = 'C'
2945: AND source_code = p_in_attributes.source_code
2946: AND container_flag = 'N';

Line 2955: FROM wsh_delivery_details

2951: -- and those of only the interfaced lines in the set.
2952: CURSOR c_sum_line_set_shp_qty(x_header_id IN NUMBER,
2953: x_line_set_id IN NUMBER) IS
2954: SELECT NVL(SUM(shipped_quantity), 0)
2955: FROM wsh_delivery_details
2956: WHERE source_code = p_in_attributes.source_code
2957: AND released_status = 'C'
2958: AND (
2959: source_line_id = p_in_attributes.line_id

Line 2974: FROM wsh_delivery_details

2970: -- and modified to total all shipped details in the line set.
2971: CURSOR c_sum_line_set_shp_qty_ITS(x_header_id IN NUMBER,
2972: x_line_set_id IN NUMBER) IS
2973: SELECT NVL(SUM(shipped_quantity), 0)
2974: FROM wsh_delivery_details
2975: WHERE source_code = p_in_attributes.source_code
2976: AND released_status = 'C'
2977: AND container_flag = 'N'
2978: AND source_header_id = x_header_id

Line 2992: FROM wsh_delivery_details

2988: source_header_id,
2989: src_requested_quantity_uom,
2990: inventory_item_id,
2991: requested_quantity_uom
2992: FROM wsh_delivery_details
2993: WHERE source_line_id = p_in_attributes.line_id
2994: AND container_flag = 'N'
2995: AND released_status <> 'D'
2996: AND source_code = p_in_attributes.source_code

Line 3006: FROM wsh_delivery_details

3002:
3003: CURSOR c_sum_ordered_qty1(x_header_id number) IS
3004: SELECT SUM(requested_quantity),
3005: SUM(NVL(requested_quantity2,0))
3006: FROM wsh_delivery_details
3007: WHERE source_line_id =p_in_attributes.line_id
3008: AND source_code = p_in_attributes.source_code
3009: AND container_flag = 'N'
3010: AND released_status <> 'D'

Line 3017: FROM wsh_delivery_details

3013: -- Lock the Delivery Details within a line set
3014: CURSOR c_lock_delivery_det(x_header_id IN NUMBER,
3015: x_line_set_id IN NUMBER) IS
3016: SELECT delivery_detail_id
3017: FROM wsh_delivery_details
3018: WHERE source_line_set_id = x_line_set_id
3019: AND source_code = p_in_attributes.source_code
3020: AND source_header_id = x_header_id
3021: FOR UPDATE;

Line 3026: FROM wsh_delivery_details

3022:
3023: -- Lock the Delivery Details within a source line id
3024: CURSOR c_lock_delivery_det1 IS
3025: SELECT delivery_detail_id
3026: FROM wsh_delivery_details
3027: WHERE source_line_id = p_in_attributes.line_id
3028: FOR UPDATE;
3029:
3030: l_ship_tolerance_above NUMBER;

Line 3052: l_ordered_quantity_uom wsh_delivery_details.SRC_REQUESTED_QUANTITY_UOM%TYPE;

3048: l_tolerance_quantity_above NUMBER;
3049: l_tolerance_quantity_below2 NUMBER;
3050: l_tolerance_quantity_above2 NUMBER;
3051: -- csun max_tol chnage
3052: l_ordered_quantity_uom wsh_delivery_details.SRC_REQUESTED_QUANTITY_UOM%TYPE;
3053: l_requested_quantity_uom wsh_delivery_details.REQUESTED_QUANTITY_UOM%TYPE;
3054: l_requested_quantity_uom2 wsh_delivery_details.REQUESTED_QUANTITY_UOM2%TYPE;
3055: --
3056: l_debug_on BOOLEAN;

Line 3053: l_requested_quantity_uom wsh_delivery_details.REQUESTED_QUANTITY_UOM%TYPE;

3049: l_tolerance_quantity_below2 NUMBER;
3050: l_tolerance_quantity_above2 NUMBER;
3051: -- csun max_tol chnage
3052: l_ordered_quantity_uom wsh_delivery_details.SRC_REQUESTED_QUANTITY_UOM%TYPE;
3053: l_requested_quantity_uom wsh_delivery_details.REQUESTED_QUANTITY_UOM%TYPE;
3054: l_requested_quantity_uom2 wsh_delivery_details.REQUESTED_QUANTITY_UOM2%TYPE;
3055: --
3056: l_debug_on BOOLEAN;
3057: --

Line 3054: l_requested_quantity_uom2 wsh_delivery_details.REQUESTED_QUANTITY_UOM2%TYPE;

3050: l_tolerance_quantity_above2 NUMBER;
3051: -- csun max_tol chnage
3052: l_ordered_quantity_uom wsh_delivery_details.SRC_REQUESTED_QUANTITY_UOM%TYPE;
3053: l_requested_quantity_uom wsh_delivery_details.REQUESTED_QUANTITY_UOM%TYPE;
3054: l_requested_quantity_uom2 wsh_delivery_details.REQUESTED_QUANTITY_UOM2%TYPE;
3055: --
3056: l_debug_on BOOLEAN;
3057: --
3058: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'GET_MIN_MAX_TOLERANCE_QUANTITY';

Line 3426: FROM wsh_delivery_details wdd

3422: CURSOR c_staged_content( p_container_id IN NUMBER) IS
3423: SELECT 1 FROM DUAL
3424: WHERE EXISTS
3425: ( SELECT wdd.delivery_detail_id
3426: FROM wsh_delivery_details wdd
3427: WHERE wdd.delivery_detail_id IN
3428: (SELECT wda.delivery_detail_id
3429: FROM wsh_delivery_assignments_v wda
3430: START WITH parent_delivery_detail_id = p_container_id

Line 3446: (select nvl(ignore_for_planning,'N') from wsh_delivery_details where delivery_detail_id=p_detid)

3442: SELECT 'Y'
3443: FROM wsh_new_deliveries wnd
3444: WHERE wnd.delivery_id=p_deliveryid
3445: AND (nvl(wnd.ignore_for_planning, 'N') <>
3446: (select nvl(ignore_for_planning,'N') from wsh_delivery_details where delivery_detail_id=p_detid)
3447: );
3448:
3449: l_content_id NUMBER := NULL;
3450:

Line 3608: p_del_detail_rec_tab(j).released_status = WSH_DELIVERY_DETAILS_PKG.C_RELEASED_TO_WAREHOUSE THEN

3604: -- and a) Move order line id is null(Planned X-dock line) OR
3605: -- b) Move order line id is not null and move_order_type = 'PUTAWAY' (Planned X-dock line progressed)
3606: -- c) Move order line id is not null and move_order_type = 'PICK_WAVE' (Priotize Inventory case)
3607: IF p_action = 'SPLIT-LINE' AND
3608: p_del_detail_rec_tab(j).released_status = WSH_DELIVERY_DETAILS_PKG.C_RELEASED_TO_WAREHOUSE THEN
3609:
3610: IF l_debug_on THEN
3611: wsh_debug_sv.log(l_module_name, 'Released_status', p_del_detail_rec_tab(j).released_status);
3612: wsh_debug_sv.log(l_module_name, 'Caller',p_caller );

Line 4694: FROM mtl_system_items msi,wsh_delivery_details wdd

4690: ) IS
4691: --Added as a part of fix for bug # 6082324 and bug 7165744 added msi.primary_uom_code to cursor
4692: cursor get_MSI_details (p_inventory_item_id NUMBER,p_delivery_detail_id NUMBER) IS
4693: SELECT msi.container_type_code,msi.maximum_load_weight,msi.primary_uom_code
4694: FROM mtl_system_items msi,wsh_delivery_details wdd
4695: WHERE msi.inventory_item_id (+) = p_inventory_item_id
4696: AND msi.organization_id (+) = wdd.organization_id
4697: AND wdd.container_flag = 'Y'
4698: AND wdd.delivery_detail_id = p_delivery_detail_id;

Line 5205: l_inv_controls WSH_DELIVERY_DETAILS_INV.inv_control_flag_rec;

5201: l_status_code VARCHAR2(3);
5202: l_released_status VARCHAR2(1);
5203: l_lpn_id NUMBER;
5204: l_all_disabled VARCHAR2(1):='N';
5205: l_inv_controls WSH_DELIVERY_DETAILS_INV.inv_control_flag_rec;
5206: l_inventory_item_id NUMBER;
5207: l_organization_id NUMBER;
5208: l_pickable_flag VARCHAR2(1);
5209: l_subinventory VARCHAR2(30);

Line 5427: FROM wsh_delivery_details

5423: /*J IB: asutar*/
5424: ,po_revision_number
5425: ,release_revision_number
5426: ,replenishment_status --bug# 6689448 (replenishment project)
5427: FROM wsh_delivery_details
5428: WHERE delivery_detail_id = p_delivery_detail_rec.delivery_detail_id;
5429:
5430: e_dp_no_entity EXCEPTION;
5431: e_bad_field EXCEPTION;

Line 5628: WSH_DELIVERY_DETAILS_INV.get_reservable_flag (

5624: l_disabled_list(i) = 'LOCATOR_NAME' and
5625: l_db_col_rec.locator_id is not null and
5626: --Modified for bug 4560576, 4701803
5627: l_db_col_rec.released_status = 'Y' and
5628: WSH_DELIVERY_DETAILS_INV.get_reservable_flag (
5629: x_item_id => l_inventory_item_id,
5630: x_organization_id => l_organization_id,
5631: x_pickable_flag => l_pickable_flag ) = 'N' )
5632: THEN

Line 5699: ELSIF (l_released_status IN (WSH_DELIVERY_DETAILS_PKG.C_READY_TO_RELEASE,

5695: j:=j+1; l_disabled_list(j) := 'REQUESTED_QUANTITY_UOM2';
5696:
5697: -- X-dock changes
5698: -- Only for specific cases, let WMS update released_status and MOL
5699: ELSIF (l_released_status IN (WSH_DELIVERY_DETAILS_PKG.C_READY_TO_RELEASE,
5700: WSH_DELIVERY_DETAILS_PKG.C_BACKORDERED,
5701: WSH_DELIVERY_DETAILS_PKG.C_RELEASED_TO_WAREHOUSE)
5702: AND p_in_rec.caller like 'WMS_XDOCK%') THEN
5703: if l_debug_on then

Line 5700: WSH_DELIVERY_DETAILS_PKG.C_BACKORDERED,

5696:
5697: -- X-dock changes
5698: -- Only for specific cases, let WMS update released_status and MOL
5699: ELSIF (l_released_status IN (WSH_DELIVERY_DETAILS_PKG.C_READY_TO_RELEASE,
5700: WSH_DELIVERY_DETAILS_PKG.C_BACKORDERED,
5701: WSH_DELIVERY_DETAILS_PKG.C_RELEASED_TO_WAREHOUSE)
5702: AND p_in_rec.caller like 'WMS_XDOCK%') THEN
5703: if l_debug_on then
5704: wsh_debug_sv.log(l_module_name, 'WMS Caller to update Released status and MOL', p_in_rec.caller);

Line 5701: WSH_DELIVERY_DETAILS_PKG.C_RELEASED_TO_WAREHOUSE)

5697: -- X-dock changes
5698: -- Only for specific cases, let WMS update released_status and MOL
5699: ELSIF (l_released_status IN (WSH_DELIVERY_DETAILS_PKG.C_READY_TO_RELEASE,
5700: WSH_DELIVERY_DETAILS_PKG.C_BACKORDERED,
5701: WSH_DELIVERY_DETAILS_PKG.C_RELEASED_TO_WAREHOUSE)
5702: AND p_in_rec.caller like 'WMS_XDOCK%') THEN
5703: if l_debug_on then
5704: wsh_debug_sv.log(l_module_name, 'WMS Caller to update Released status and MOL', p_in_rec.caller);
5705: end if;

Line 5713: ELSIF (l_released_status IN (WSH_DELIVERY_DETAILS_PKG.C_READY_TO_RELEASE,

5709:
5710: -- end of X-dock changes
5711:
5712: --bug# 6689448 (replenishment project): let WMS update replenishment status for ready to release and backorder dds
5713: ELSIF (l_released_status IN (WSH_DELIVERY_DETAILS_PKG.C_READY_TO_RELEASE,
5714: WSH_DELIVERY_DETAILS_PKG.C_BACKORDERED) AND p_in_rec.caller like 'WMS_REP%') THEN
5715: j:=j+1;
5716: l_disabled_list(j) := 'REPLENISHMENT_STATUS';
5717: ELSIF p_delivery_detail_rec.lpn_id IS NULL AND l_lpn_id is NOT NULL THEN

Line 5714: WSH_DELIVERY_DETAILS_PKG.C_BACKORDERED) AND p_in_rec.caller like 'WMS_REP%') THEN

5710: -- end of X-dock changes
5711:
5712: --bug# 6689448 (replenishment project): let WMS update replenishment status for ready to release and backorder dds
5713: ELSIF (l_released_status IN (WSH_DELIVERY_DETAILS_PKG.C_READY_TO_RELEASE,
5714: WSH_DELIVERY_DETAILS_PKG.C_BACKORDERED) AND p_in_rec.caller like 'WMS_REP%') THEN
5715: j:=j+1;
5716: l_disabled_list(j) := 'REPLENISHMENT_STATUS';
5717: ELSIF p_delivery_detail_rec.lpn_id IS NULL AND l_lpn_id is NOT NULL THEN
5718: -- LPN sync-up

Line 5768: WSH_DELIVERY_DETAILS_INV.Fetch_Inv_Controls(p_delivery_detail_id => x_delivery_detail_rec.delivery_detail_id,

5764: -- Subinventory should be updateable during inbound processing
5765: j:=j+1; l_disabled_list(j) := 'FULL';
5766: j:=j+1; l_disabled_list(j) := 'SUBINVENTORY';
5767: --Bugfix 6939348 start
5768: WSH_DELIVERY_DETAILS_INV.Fetch_Inv_Controls(p_delivery_detail_id => x_delivery_detail_rec.delivery_detail_id,
5769: p_inventory_item_id => x_delivery_detail_rec.inventory_item_id,
5770: p_organization_id => x_delivery_detail_rec.organization_id,
5771: p_subinventory => x_delivery_detail_rec.subinventory,
5772: x_inv_controls_rec => l_inv_controls,

Line 6090: x_detail_actions_tab(i).released_status := WSH_DELIVERY_DETAILS_PKG.C_RELEASED_TO_WAREHOUSE;

6086: -- R12 X-dock project, Split will be allowed conditionally
6087: -- for released to warehouse line and caller = WMS_XDOCK%
6088: IF p_action = 'CYCLE-COUNT' THEN
6089: i := i+1;
6090: x_detail_actions_tab(i).released_status := WSH_DELIVERY_DETAILS_PKG.C_RELEASED_TO_WAREHOUSE;
6091: x_detail_actions_tab(i).action_not_allowed := p_action;
6092: i := i+1;
6093: x_detail_actions_tab(i).org_type := 'WMS';
6094: x_detail_actions_tab(i).action_not_allowed := p_action;

Line 6435: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.UNMARK_SERIAL_NUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);

6431:
6432: IF x_det_rec.serial_quantity > 0 AND x_det_rec.unmark_serial_server = 'Y' THEN
6433:
6434: IF l_debug_on THEN
6435: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.UNMARK_SERIAL_NUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);
6436: END IF;
6437: wsh_delivery_details_inv.unmark_serial_number(
6438: p_delivery_detail_id => x_det_rec.delivery_detail_id,
6439: p_serial_number_code => x_det_rec.inv_ser_control_code,

Line 6437: wsh_delivery_details_inv.unmark_serial_number(

6433:
6434: IF l_debug_on THEN
6435: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.UNMARK_SERIAL_NUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);
6436: END IF;
6437: wsh_delivery_details_inv.unmark_serial_number(
6438: p_delivery_detail_id => x_det_rec.delivery_detail_id,
6439: p_serial_number_code => x_det_rec.inv_ser_control_code,
6440: p_serial_number => x_det_rec.serial_number,
6441: p_transaction_temp_id => x_det_rec.transaction_temp_id,

Line 6477: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.UNMARK_SERIAL_NUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);

6473: wsh_util_core.add_message(wsh_util_core.g_ret_sts_warning);
6474: l_number_of_warnings := l_number_of_warnings + 1;
6475:
6476: IF l_debug_on THEN
6477: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.UNMARK_SERIAL_NUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);
6478: END IF;
6479:
6480: IF x_det_rec.unmark_serial_server = 'Y' THEN
6481: wsh_delivery_details_inv.unmark_serial_number(

Line 6481: wsh_delivery_details_inv.unmark_serial_number(

6477: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.UNMARK_SERIAL_NUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);
6478: END IF;
6479:
6480: IF x_det_rec.unmark_serial_server = 'Y' THEN
6481: wsh_delivery_details_inv.unmark_serial_number(
6482: p_delivery_detail_id => x_det_rec.delivery_detail_id,
6483: p_serial_number_code => x_det_rec.inv_ser_control_code,
6484: p_serial_number => x_det_rec.serial_number,
6485: p_transaction_temp_id => x_det_rec.transaction_temp_id,

Line 6978: FROM wsh_delivery_details

6974: SELECT organization_id, inventory_item_id,
6975: lot_number, nvl(line_direction,'O') line_direction,
6976: requested_quantity_uom,
6977: requested_quantity_uom2
6978: FROM wsh_delivery_details
6979: WHERE delivery_detail_id = p_delivery_detail_id;
6980: --
6981: --
6982: l_line_rec line_csr%ROWTYPE;

Line 7014: l_item_info WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec;

7010: l_msg_data VARCHAR2(32767);
7011: l_return_status VARCHAR2(32767);
7012: --
7013: -- HW OPMCONV - New variables
7014: l_item_info WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec;
7015: INVALID_LOT EXCEPTION;
7016: e_end_of_api EXCEPTION;
7017: --}
7018: BEGIN

Line 7110: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.Get_item_information',WSH_DEBUG_SV.C_PROC_LEVEL);

7106: -- HW OPMCONV - No need to call OPM APIS
7107:
7108: -- HW OPMCONV - Call API to get item info
7109: IF l_debug_on THEN
7110: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.Get_item_information',WSH_DEBUG_SV.C_PROC_LEVEL);
7111: END IF;
7112:
7113: WSH_DELIVERY_DETAILS_INV.Get_item_information
7114: (

Line 7113: WSH_DELIVERY_DETAILS_INV.Get_item_information

7109: IF l_debug_on THEN
7110: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.Get_item_information',WSH_DEBUG_SV.C_PROC_LEVEL);
7111: END IF;
7112:
7113: WSH_DELIVERY_DETAILS_INV.Get_item_information
7114: (
7115: p_organization_id => l_line_rec.organization_id
7116: , p_inventory_item_id => l_line_rec.inventory_item_id
7117: , x_mtl_system_items_rec => l_item_info

Line 8681: l_item_info WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec;

8677: p_released_status IN VARCHAR2)
8678: RETURN BOOLEAN
8679: IS
8680:
8681: l_item_info WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec;
8682: l_released_status VARCHAR2(1);
8683: l_debug_on BOOLEAN;
8684: l_return_status VARCHAR2(1);
8685: l_number_of_errors NUMBER ;

Line 8722: WSH_DELIVERY_DETAILS_INV.Get_item_information

8718: wsh_debug_sv.LOG(l_module_name, 'p_inventory_item_id', p_inventory_item_id);
8719: END IF;
8720: --
8721:
8722: WSH_DELIVERY_DETAILS_INV.Get_item_information
8723: (
8724: p_organization_id => p_organization_id,
8725: p_inventory_item_id => p_inventory_item_id,
8726: x_mtl_system_items_rec => l_item_info,

Line 8816: l_item_info WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec;

8812: p_cycle_qty IN NUMBER)
8813: RETURN BOOLEAN
8814: IS
8815:
8816: l_item_info WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec;
8817: l_released_status VARCHAR2(1);
8818: l_debug_on BOOLEAN;
8819: l_return_status VARCHAR2(1);
8820: l_number_of_errors NUMBER ;

Line 8850: WSH_DELIVERY_DETAILS_INV.Get_item_information

8846: wsh_debug_sv.LOG(l_module_name, 'p_inventory_item_id', p_inventory_item_id);
8847: END IF;
8848: --
8849:
8850: WSH_DELIVERY_DETAILS_INV.Get_item_information
8851: (
8852: p_organization_id => p_organization_id,
8853: p_inventory_item_id => p_inventory_item_id,
8854: x_mtl_system_items_rec => l_item_info,