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: -- muom
11: CURSOR C_DETAIL_INFO(p_detail_id IN number) IS
12: SELECT SOURCE_CODE,

Line 14: FROM WSH_DELIVERY_DETAILS

10: -- muom
11: CURSOR C_DETAIL_INFO(p_detail_id IN number) IS
12: SELECT SOURCE_CODE,
13: SOURCE_LINE_ID
14: FROM WSH_DELIVERY_DETAILS
15: WHERE DELIVERY_DETAIL_ID = p_detail_id;
16:
17: --public api changes
18: PROCEDURE user_non_updatable_columns

Line 813: wsh_delivery_Details dd

809: cursor check_unassign (detail_id IN NUMBER) is
810: select da.parent_delivery_detail_id , da.delivery_id ,
811: dd.container_name , dd.container_flag
812: from wsh_delivery_assignments da,
813: wsh_delivery_Details dd
814: where da.delivery_detail_id = detail_id
815: and nvl(da.type,'S') in ('S', 'C')
816: and da.parent_Delivery_Detail_id = dd.delivery_Detail_id (+);
817:

Line 1134: FROM wsh_delivery_details

1130: -- BUG#:1549665 hwahdani retrieve ship_from_location_id,order_number,line number
1131: CURSOR get_source_info IS
1132: SELECT source_header_id, source_line_id,ship_from_location_id,
1133: source_header_number, source_line_number, org_id, container_flag, source_code -- RTV Changes
1134: FROM wsh_delivery_details
1135: WHERE delivery_detail_id = p_detail_id;
1136:
1137: -- BUG#:1549665 hwahdani get order information
1138: --Bug 1697471: added source_line_id in the where clause

Line 1141: FROM wsh_delivery_details

1137: -- BUG#:1549665 hwahdani get order information
1138: --Bug 1697471: added source_line_id in the where clause
1139: CURSOR get_order_info IS
1140: SELECT ship_from_location_id,source_header_number, source_line_number, org_id, container_flag
1141: FROM wsh_delivery_details
1142: WHERE source_header_id = p_source_header_id
1143: AND source_code = p_source_code
1144: AND source_line_id = p_source_line_id;
1145:

Line 1758: FROM wsh_delivery_details

1754: ship_tolerance_below, -- 2181132 added following fields
1755: source_header_id,
1756: source_line_set_id,
1757: source_code
1758: FROM wsh_delivery_details
1759: WHERE source_line_id = x_source_line_id
1760: AND source_code = 'OE' -- pick confirm supports only OE lines
1761: AND container_flag = 'N'
1762: AND released_status <> 'D'

Line 1779: FROM wsh_delivery_details

1775: ), 0) net_staged_qty,
1776: --NVL(SUM(NVL(picked_quantity, requested_quantity)), 0) net_staged_qty,
1777: NVL(SUM(NVL(requested_quantity2,0)), 0) net_requested_qty2,
1778: NVL(SUM(NVL(picked_quantity2, requested_quantity2)), 0) net_staged_qty2
1779: FROM wsh_delivery_details
1780: WHERE source_line_id = x_source_line_id
1781: AND source_code = 'OE'
1782: AND container_flag = 'N'
1783: AND released_status IN ('X', 'Y', 'C');

Line 1831: l_quantity_uom WSH_DELIVERY_DETAILS.requested_quantity_uom%TYPE;

1827: -- 2181132
1828: l_minmaxinrectype MinMaxInRecType;
1829: l_minmaxinoutrectype MinMaxInOutRecType;
1830: l_minmaxoutrectype MinMaxOutRecType;
1831: l_quantity_uom WSH_DELIVERY_DETAILS.requested_quantity_uom%TYPE;
1832: l_quantity_uom2 WSH_DELIVERY_DETAILS.requested_quantity_uom2%TYPE;
1833:
1834: --
1835: l_debug_on BOOLEAN;

Line 1832: l_quantity_uom2 WSH_DELIVERY_DETAILS.requested_quantity_uom2%TYPE;

1828: l_minmaxinrectype MinMaxInRecType;
1829: l_minmaxinoutrectype MinMaxInOutRecType;
1830: l_minmaxoutrectype MinMaxOutRecType;
1831: l_quantity_uom WSH_DELIVERY_DETAILS.requested_quantity_uom%TYPE;
1832: l_quantity_uom2 WSH_DELIVERY_DETAILS.requested_quantity_uom2%TYPE;
1833:
1834: --
1835: l_debug_on BOOLEAN;
1836: --

Line 2192: from wsh_delivery_details wdd, wsh_delivery_assignments_v wda

2188: -- muom
2189: CURSOR c_check_qty_inside_del (del_id IN NUMBER) IS
2190: select sum(wdd.requested_quantity), wdd.source_code, wdd.source_line_id,
2191: decode(wdd.requested_quantity_uom2,null,'P',WSH_UTIL_CORE.Get_Line_Fulfillment_Base(wdd.source_code,wdd.source_line_id)) fulfill_base
2192: from wsh_delivery_details wdd, wsh_delivery_assignments_v wda
2193: where wdd.delivery_detail_id = wda.delivery_detail_id
2194: and wda.delivery_id is not null
2195: and wda.delivery_id = del_id
2196: and wdd.released_status <> 'D'

Line 2205: from wsh_delivery_details wdd, wsh_delivery_assignments_v wda

2201: CURSOR c_source_info IS
2202: -- muom
2203: select distinct wdd.source_line_id, wdd.source_code,
2204: decode(wdd.requested_quantity_uom2,null,'P',WSH_UTIL_CORE.Get_Line_Fulfillment_Base(wdd.source_code,wdd.source_line_id)) fulfill_base
2205: from wsh_delivery_details wdd, wsh_delivery_assignments_v wda
2206: where wdd.delivery_detail_id = wda.delivery_detail_id
2207: and wdd.released_status <> 'D'
2208: and wda.delivery_id is not null
2209: and wda.delivery_id = p_delivery_id;

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

2262: IF source_rec.fulfill_base = 'P' THEN
2263: BEGIN
2264: select sum(wdd.requested_quantity)
2265: into l_req_qty
2266: from wsh_delivery_details wdd, wsh_delivery_assignments_v wda, wsh_new_deliveries wnd
2267: where wdd.delivery_detail_id = wda.delivery_detail_id
2268: and wnd.delivery_id(+) = wda.delivery_id
2269: and (wda.delivery_id <> p_delivery_id or wda.delivery_id is NULL)
2270: and wdd.released_status not in ('C', 'D')

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

2286: ELSE
2287: BEGIN
2288: select sum(wdd.requested_quantity2)
2289: into l_req_qty
2290: from wsh_delivery_details wdd, wsh_delivery_assignments_v wda, wsh_new_deliveries wnd
2291: where wdd.delivery_detail_id = wda.delivery_detail_id
2292: and wnd.delivery_id(+) = wda.delivery_id
2293: and (wda.delivery_id <> p_delivery_id or wda.delivery_id is NULL)
2294: and wdd.released_status not in ('C', 'D')

Line 2399: FROM wsh_delivery_details

2395: subinventory,
2396: source_code,
2397: inventory_item_id,
2398: nvl(line_direction,'O') line_direction -- J-IB-NPARIKH
2399: FROM wsh_delivery_details
2400: WHERE delivery_detail_id = p_delivery_detail_id;
2401:
2402: -- end of OPM 09/11/00
2403:

Line 2423: l_inv_controls WSH_DELIVERY_DETAILS_INV.inv_control_flag_rec;

2419: l_item_id NUMBER;
2420: l_pickable_flag VARCHAR2(1);
2421: l_subinventory VARCHAR2(30);
2422: l_line_direction VARCHAR2(30);
2423: l_inv_controls WSH_DELIVERY_DETAILS_INV.inv_control_flag_rec;
2424: -- BUG FIX 2887330
2425: l_inventory_item_id NUMBER;
2426: l_reservable_flag VARCHAR2(1);
2427: l_source_code VARCHAR2(30);

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

2523: -- J-IB-NPARIKH-}
2524: --
2525:
2526: IF l_debug_on THEN
2527: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.GET_RESERVABLE_FLAG',WSH_DEBUG_SV.C_PROC_LEVEL);
2528: END IF;
2529:
2530: l_reservable_flag := WSH_DELIVERY_DETAILS_INV.get_reservable_flag(
2531: x_item_id => l_inventory_item_id,

Line 2530: l_reservable_flag := WSH_DELIVERY_DETAILS_INV.get_reservable_flag(

2526: IF l_debug_on THEN
2527: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.GET_RESERVABLE_FLAG',WSH_DEBUG_SV.C_PROC_LEVEL);
2528: END IF;
2529:
2530: l_reservable_flag := WSH_DELIVERY_DETAILS_INV.get_reservable_flag(
2531: x_item_id => l_inventory_item_id,
2532: x_organization_id => l_organization_id,
2533: x_pickable_flag => l_pickable_flag);
2534: if l_debug_on then

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

2818: i := x_disabled_list.COUNT;
2819:
2820: IF (l_released_status = 'Y') THEN
2821:
2822: IF (WSH_DELIVERY_DETAILS_INV.get_reservable_flag(x_item_id => l_item_id,
2823: x_organization_id => l_organization_id,
2824: x_pickable_flag => l_pickable_flag) = 'Y')
2825: THEN
2826:

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

2841: G_SUBINVENTORY := NULL;
2842: END IF;
2843:
2844:
2845: WSH_DELIVERY_DETAILS_INV.Fetch_Inv_Controls(p_delivery_detail_id => p_delivery_detail_id,
2846: p_inventory_item_id => l_item_id,
2847: p_organization_id => l_organization_id,
2848: p_subinventory => l_subinventory,
2849: x_inv_controls_rec => l_inv_controls,

Line 3027: FROM wsh_delivery_details

3023: -- HW added requested_quantity2
3024: CURSOR c_sum_ordered_qty(x_header_id IN NUMBER, x_line_set_id IN NUMBER) IS
3025: SELECT SUM(requested_quantity),
3026: SUM(NVL(requested_quantity2,0))
3027: FROM wsh_delivery_details
3028: WHERE source_line_set_id = x_line_set_id
3029: AND source_code = p_in_attributes.source_code
3030: AND container_flag = 'N'
3031: AND released_status <> 'D'

Line 3043: FROM wsh_delivery_details

3039: SELECT nvl(SUM(GREATEST(nvl(shipped_quantity,0),
3040: nvl(picked_quantity,requested_quantity))),0),
3041: nvl(SUM(GREATEST(nvl(shipped_quantity2,0),
3042: nvl(picked_quantity2,requested_quantity2))),0)
3043: FROM wsh_delivery_details
3044: WHERE source_line_set_id = x_line_set_id
3045: AND released_status <> 'D'
3046: AND source_line_id <> p_in_attributes.line_id
3047: AND source_code = p_in_attributes.source_code

Line 3060: FROM wsh_delivery_details

3056: -- to use this cursor) and therefore the source line is fulfilled.
3057: CURSOR c_sum_line_shp_qty IS
3058: SELECT NVL(SUM(shipped_quantity), 0),
3059: NVL(SUM(shipped_quantity2), 0) --Bug#9437761
3060: FROM wsh_delivery_details
3061: WHERE source_line_id = p_in_attributes.line_id
3062: AND released_status = 'C'
3063: AND source_code = p_in_attributes.source_code
3064: AND container_flag = 'N';

Line 3074: FROM wsh_delivery_details

3070: CURSOR c_sum_line_set_shp_qty(x_header_id IN NUMBER,
3071: x_line_set_id IN NUMBER) IS
3072: SELECT NVL(SUM(shipped_quantity), 0),
3073: NVL(SUM(shipped_quantity2), 0) --Bug#9437761
3074: FROM wsh_delivery_details
3075: WHERE source_code = p_in_attributes.source_code
3076: AND released_status = 'C'
3077: AND (
3078: source_line_id = p_in_attributes.line_id

Line 3094: FROM wsh_delivery_details

3090: CURSOR c_sum_line_set_shp_qty_ITS(x_header_id IN NUMBER,
3091: x_line_set_id IN NUMBER) IS
3092: SELECT NVL(SUM(shipped_quantity), 0),
3093: NVL(SUM(shipped_quantity2), 0) --Bug#9437761
3094: FROM wsh_delivery_details
3095: WHERE source_code = p_in_attributes.source_code
3096: AND released_status = 'C'
3097: AND container_flag = 'N'
3098: AND source_header_id = x_header_id

Line 3112: FROM wsh_delivery_details

3108: source_header_id,
3109: src_requested_quantity_uom,
3110: inventory_item_id,
3111: requested_quantity_uom
3112: FROM wsh_delivery_details
3113: WHERE source_line_id = p_in_attributes.line_id
3114: AND container_flag = 'N'
3115: AND released_status <> 'D'
3116: AND source_code = p_in_attributes.source_code

Line 3126: FROM wsh_delivery_details

3122:
3123: CURSOR c_sum_ordered_qty1(x_header_id number) IS
3124: SELECT SUM(requested_quantity),
3125: SUM(NVL(requested_quantity2,0))
3126: FROM wsh_delivery_details
3127: WHERE source_line_id =p_in_attributes.line_id
3128: AND source_code = p_in_attributes.source_code
3129: AND container_flag = 'N'
3130: AND released_status <> 'D'

Line 3137: FROM wsh_delivery_details

3133: -- Lock the Delivery Details within a line set
3134: CURSOR c_lock_delivery_det(x_header_id IN NUMBER,
3135: x_line_set_id IN NUMBER) IS
3136: SELECT delivery_detail_id
3137: FROM wsh_delivery_details
3138: WHERE source_line_set_id = x_line_set_id
3139: AND source_code = p_in_attributes.source_code
3140: AND source_header_id = x_header_id
3141: FOR UPDATE;

Line 3146: FROM wsh_delivery_details

3142:
3143: -- Lock the Delivery Details within a source line id
3144: CURSOR c_lock_delivery_det1 IS
3145: SELECT delivery_detail_id
3146: FROM wsh_delivery_details
3147: WHERE source_line_id = p_in_attributes.line_id
3148: FOR UPDATE;
3149:
3150: l_ship_tolerance_above NUMBER;

Line 3172: l_ordered_quantity_uom wsh_delivery_details.SRC_REQUESTED_QUANTITY_UOM%TYPE;

3168: l_tolerance_quantity_above NUMBER;
3169: l_tolerance_quantity_below2 NUMBER;
3170: l_tolerance_quantity_above2 NUMBER;
3171: -- csun max_tol chnage
3172: l_ordered_quantity_uom wsh_delivery_details.SRC_REQUESTED_QUANTITY_UOM%TYPE;
3173: l_requested_quantity_uom wsh_delivery_details.REQUESTED_QUANTITY_UOM%TYPE;
3174: l_requested_quantity_uom2 wsh_delivery_details.REQUESTED_QUANTITY_UOM2%TYPE;
3175: --
3176: l_debug_on BOOLEAN;

Line 3173: l_requested_quantity_uom wsh_delivery_details.REQUESTED_QUANTITY_UOM%TYPE;

3169: l_tolerance_quantity_below2 NUMBER;
3170: l_tolerance_quantity_above2 NUMBER;
3171: -- csun max_tol chnage
3172: l_ordered_quantity_uom wsh_delivery_details.SRC_REQUESTED_QUANTITY_UOM%TYPE;
3173: l_requested_quantity_uom wsh_delivery_details.REQUESTED_QUANTITY_UOM%TYPE;
3174: l_requested_quantity_uom2 wsh_delivery_details.REQUESTED_QUANTITY_UOM2%TYPE;
3175: --
3176: l_debug_on BOOLEAN;
3177: --

Line 3174: l_requested_quantity_uom2 wsh_delivery_details.REQUESTED_QUANTITY_UOM2%TYPE;

3170: l_tolerance_quantity_above2 NUMBER;
3171: -- csun max_tol chnage
3172: l_ordered_quantity_uom wsh_delivery_details.SRC_REQUESTED_QUANTITY_UOM%TYPE;
3173: l_requested_quantity_uom wsh_delivery_details.REQUESTED_QUANTITY_UOM%TYPE;
3174: l_requested_quantity_uom2 wsh_delivery_details.REQUESTED_QUANTITY_UOM2%TYPE;
3175: --
3176: l_debug_on BOOLEAN;
3177: --
3178: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'GET_MIN_MAX_TOLERANCE_QUANTITY';

Line 3549: FROM wsh_delivery_details wdd

3545: CURSOR c_staged_content( p_container_id IN NUMBER) IS
3546: SELECT 1 FROM DUAL
3547: WHERE EXISTS
3548: ( SELECT wdd.delivery_detail_id
3549: FROM wsh_delivery_details wdd
3550: WHERE wdd.delivery_detail_id IN
3551: (SELECT wda.delivery_detail_id
3552: FROM wsh_delivery_assignments_v wda
3553: START WITH parent_delivery_detail_id = p_container_id

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

3565: SELECT 'Y'
3566: FROM wsh_new_deliveries wnd
3567: WHERE wnd.delivery_id=p_deliveryid
3568: AND (nvl(wnd.ignore_for_planning, 'N') <>
3569: (select nvl(ignore_for_planning,'N') from wsh_delivery_details where delivery_detail_id=p_detid)
3570: );
3571:
3572: -- Added cursor for TPW - Distributed Organization Changes
3573: CURSOR c_del_details ( c_del_det_id IN NUMBER ) is

Line 3575: from wsh_delivery_details

3571:
3572: -- Added cursor for TPW - Distributed Organization Changes
3573: CURSOR c_del_details ( c_del_det_id IN NUMBER ) is
3574: select shipment_batch_id
3575: from wsh_delivery_details
3576: where delivery_detail_id = c_del_det_id;
3577:
3578: l_shipment_batch_id WSH_DELIVERY_DETAILS.Shipment_Batch_Id%TYPE;
3579: -- TPW - Distributed Organization Changes - End

Line 3578: l_shipment_batch_id WSH_DELIVERY_DETAILS.Shipment_Batch_Id%TYPE;

3574: select shipment_batch_id
3575: from wsh_delivery_details
3576: where delivery_detail_id = c_del_det_id;
3577:
3578: l_shipment_batch_id WSH_DELIVERY_DETAILS.Shipment_Batch_Id%TYPE;
3579: -- TPW - Distributed Organization Changes - End
3580:
3581: l_content_id NUMBER := NULL;
3582:

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

3737: -- and a) Move order line id is null(Planned X-dock line) OR
3738: -- b) Move order line id is not null and move_order_type = 'PUTAWAY' (Planned X-dock line progressed)
3739: -- c) Move order line id is not null and move_order_type = 'PICK_WAVE' (Priotize Inventory case)
3740: IF p_action = 'SPLIT-LINE' AND
3741: p_del_detail_rec_tab(j).released_status = WSH_DELIVERY_DETAILS_PKG.C_RELEASED_TO_WAREHOUSE THEN
3742:
3743: IF l_debug_on THEN
3744: wsh_debug_sv.log(l_module_name, 'Released_status', p_del_detail_rec_tab(j).released_status);
3745: wsh_debug_sv.log(l_module_name, 'Caller',p_caller );

Line 4869: FROM mtl_system_items msi,wsh_delivery_details wdd

4865: ) IS
4866: --Added as a part of fix for bug # 6082324 and bug 7165744 added msi.primary_uom_code to cursor
4867: cursor get_MSI_details (p_inventory_item_id NUMBER,p_delivery_detail_id NUMBER) IS
4868: SELECT msi.container_type_code,msi.maximum_load_weight,msi.primary_uom_code
4869: FROM mtl_system_items msi,wsh_delivery_details wdd
4870: WHERE msi.inventory_item_id (+) = p_inventory_item_id
4871: AND msi.organization_id (+) = wdd.organization_id
4872: AND wdd.container_flag = 'Y'
4873: AND wdd.delivery_detail_id = p_delivery_detail_id;

Line 5392: l_inv_controls WSH_DELIVERY_DETAILS_INV.inv_control_flag_rec;

5388: l_status_code VARCHAR2(3);
5389: l_released_status VARCHAR2(1);
5390: l_lpn_id NUMBER;
5391: l_all_disabled VARCHAR2(1):='N';
5392: l_inv_controls WSH_DELIVERY_DETAILS_INV.inv_control_flag_rec;
5393: l_inventory_item_id NUMBER;
5394: l_organization_id NUMBER;
5395: l_pickable_flag VARCHAR2(1);
5396: l_subinventory VARCHAR2(30);

Line 5631: FROM wsh_delivery_details

5627: ,reference_line_id
5628: -- TPW - Distributed Organization Changes - End
5629: ,client_id -- LSP PROJECT : Added just for compatibility (not used anywhere)
5630: ,consignee_flag --RTV changes
5631: FROM wsh_delivery_details
5632: WHERE delivery_detail_id = p_delivery_detail_rec.delivery_detail_id;
5633:
5634: e_dp_no_entity EXCEPTION;
5635: e_bad_field EXCEPTION;

Line 5832: WSH_DELIVERY_DETAILS_INV.get_reservable_flag (

5828: l_disabled_list(i) = 'LOCATOR_NAME' and
5829: l_db_col_rec.locator_id is not null and
5830: --Modified for bug 4560576, 4701803
5831: l_db_col_rec.released_status = 'Y' and
5832: WSH_DELIVERY_DETAILS_INV.get_reservable_flag (
5833: x_item_id => l_inventory_item_id,
5834: x_organization_id => l_organization_id,
5835: x_pickable_flag => l_pickable_flag ) = 'N' )
5836: THEN

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

5911: -- j:=j+1; l_disabled_list(j) := 'REQUESTED_QUANTITY_UOM2';
5912:
5913: -- X-dock changes
5914: -- Only for specific cases, let WMS update released_status and MOL
5915: ELSIF (l_released_status IN (WSH_DELIVERY_DETAILS_PKG.C_READY_TO_RELEASE,
5916: WSH_DELIVERY_DETAILS_PKG.C_BACKORDERED,
5917: WSH_DELIVERY_DETAILS_PKG.C_RELEASED_TO_WAREHOUSE)
5918: AND p_in_rec.caller like 'WMS_XDOCK%') THEN
5919: if l_debug_on then

Line 5916: WSH_DELIVERY_DETAILS_PKG.C_BACKORDERED,

5912:
5913: -- X-dock changes
5914: -- Only for specific cases, let WMS update released_status and MOL
5915: ELSIF (l_released_status IN (WSH_DELIVERY_DETAILS_PKG.C_READY_TO_RELEASE,
5916: WSH_DELIVERY_DETAILS_PKG.C_BACKORDERED,
5917: WSH_DELIVERY_DETAILS_PKG.C_RELEASED_TO_WAREHOUSE)
5918: AND p_in_rec.caller like 'WMS_XDOCK%') THEN
5919: if l_debug_on then
5920: wsh_debug_sv.log(l_module_name, 'WMS Caller to update Released status and MOL', p_in_rec.caller);

Line 5917: WSH_DELIVERY_DETAILS_PKG.C_RELEASED_TO_WAREHOUSE)

5913: -- X-dock changes
5914: -- Only for specific cases, let WMS update released_status and MOL
5915: ELSIF (l_released_status IN (WSH_DELIVERY_DETAILS_PKG.C_READY_TO_RELEASE,
5916: WSH_DELIVERY_DETAILS_PKG.C_BACKORDERED,
5917: WSH_DELIVERY_DETAILS_PKG.C_RELEASED_TO_WAREHOUSE)
5918: AND p_in_rec.caller like 'WMS_XDOCK%') THEN
5919: if l_debug_on then
5920: wsh_debug_sv.log(l_module_name, 'WMS Caller to update Released status and MOL', p_in_rec.caller);
5921: end if;

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

5925:
5926: -- end of X-dock changes
5927:
5928: --bug# 6689448 (replenishment project): let WMS update replenishment status for ready to release and backorder dds
5929: ELSIF (l_released_status IN (WSH_DELIVERY_DETAILS_PKG.C_READY_TO_RELEASE,
5930: WSH_DELIVERY_DETAILS_PKG.C_BACKORDERED) AND p_in_rec.caller like 'WMS_REP%') THEN
5931: j:=j+1;
5932: l_disabled_list(j) := 'REPLENISHMENT_STATUS';
5933: ELSIF p_delivery_detail_rec.lpn_id IS NULL AND l_lpn_id is NOT NULL THEN

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

5926: -- end of X-dock changes
5927:
5928: --bug# 6689448 (replenishment project): let WMS update replenishment status for ready to release and backorder dds
5929: ELSIF (l_released_status IN (WSH_DELIVERY_DETAILS_PKG.C_READY_TO_RELEASE,
5930: WSH_DELIVERY_DETAILS_PKG.C_BACKORDERED) AND p_in_rec.caller like 'WMS_REP%') THEN
5931: j:=j+1;
5932: l_disabled_list(j) := 'REPLENISHMENT_STATUS';
5933: ELSIF p_delivery_detail_rec.lpn_id IS NULL AND l_lpn_id is NOT NULL THEN
5934: -- LPN sync-up

Line 5985: WSH_DEBUG_SV.log(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.Fetch_Inv_Controls',WSH_DEBUG_SV.C_PROC_LEVEL);

5981: j:=j+1; l_disabled_list(j) := 'FULL';
5982: j:=j+1; l_disabled_list(j) := 'SUBINVENTORY';
5983: --Bugfix 6939348 start
5984: IF l_debug_on THEN
5985: WSH_DEBUG_SV.log(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.Fetch_Inv_Controls',WSH_DEBUG_SV.C_PROC_LEVEL);
5986: END IF;
5987:
5988: WSH_DELIVERY_DETAILS_INV.Fetch_Inv_Controls(p_delivery_detail_id => x_delivery_detail_rec.delivery_detail_id,
5989: p_inventory_item_id => x_delivery_detail_rec.inventory_item_id,

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

5984: IF l_debug_on THEN
5985: WSH_DEBUG_SV.log(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.Fetch_Inv_Controls',WSH_DEBUG_SV.C_PROC_LEVEL);
5986: END IF;
5987:
5988: WSH_DELIVERY_DETAILS_INV.Fetch_Inv_Controls(p_delivery_detail_id => x_delivery_detail_rec.delivery_detail_id,
5989: p_inventory_item_id => x_delivery_detail_rec.inventory_item_id,
5990: p_organization_id => x_delivery_detail_rec.organization_id,
5991: p_subinventory => nvl(x_delivery_detail_rec.subinventory,p_delivery_detail_rec.subinventory), -- bug 8303281
5992: x_inv_controls_rec => l_inv_controls,

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

6336: -- R12 X-dock project, Split will be allowed conditionally
6337: -- for released to warehouse line and caller = WMS_XDOCK%
6338: IF p_action = 'CYCLE-COUNT' THEN
6339: i := i+1;
6340: x_detail_actions_tab(i).released_status := WSH_DELIVERY_DETAILS_PKG.C_RELEASED_TO_WAREHOUSE;
6341: x_detail_actions_tab(i).action_not_allowed := p_action;
6342: i := i+1;
6343: x_detail_actions_tab(i).org_type := 'WMS';
6344: x_detail_actions_tab(i).action_not_allowed := p_action;

Line 6512: FROM WSH_DELIVERY_DETAILS

6508: --
6509: CURSOR C_DETAIL_INFO(p_detail_id IN number) IS
6510: SELECT SOURCE_CODE,
6511: SOURCE_LINE_ID
6512: FROM WSH_DELIVERY_DETAILS
6513: WHERE DELIVERY_DETAIL_ID = p_detail_id;
6514:
6515: l_debug_on BOOLEAN;
6516: --

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

6703:
6704: IF x_det_rec.serial_quantity > 0 AND x_det_rec.unmark_serial_server = 'Y' THEN
6705:
6706: IF l_debug_on THEN
6707: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.UNMARK_SERIAL_NUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);
6708: END IF;
6709: wsh_delivery_details_inv.unmark_serial_number(
6710: p_delivery_detail_id => x_det_rec.delivery_detail_id,
6711: p_serial_number_code => x_det_rec.inv_ser_control_code,

Line 6709: wsh_delivery_details_inv.unmark_serial_number(

6705:
6706: IF l_debug_on THEN
6707: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.UNMARK_SERIAL_NUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);
6708: END IF;
6709: wsh_delivery_details_inv.unmark_serial_number(
6710: p_delivery_detail_id => x_det_rec.delivery_detail_id,
6711: p_serial_number_code => x_det_rec.inv_ser_control_code,
6712: p_serial_number => x_det_rec.serial_number,
6713: p_transaction_temp_id => x_det_rec.transaction_temp_id,

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

6745: wsh_util_core.add_message(wsh_util_core.g_ret_sts_warning);
6746: l_number_of_warnings := l_number_of_warnings + 1;
6747:
6748: IF l_debug_on THEN
6749: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.UNMARK_SERIAL_NUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);
6750: END IF;
6751:
6752: IF x_det_rec.unmark_serial_server = 'Y' THEN
6753: wsh_delivery_details_inv.unmark_serial_number(

Line 6753: wsh_delivery_details_inv.unmark_serial_number(

6749: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.UNMARK_SERIAL_NUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);
6750: END IF;
6751:
6752: IF x_det_rec.unmark_serial_server = 'Y' THEN
6753: wsh_delivery_details_inv.unmark_serial_number(
6754: p_delivery_detail_id => x_det_rec.delivery_detail_id,
6755: p_serial_number_code => x_det_rec.inv_ser_control_code,
6756: p_serial_number => x_det_rec.serial_number,
6757: p_transaction_temp_id => x_det_rec.transaction_temp_id,

Line 7268: FROM wsh_delivery_details

7264: SELECT organization_id, inventory_item_id,
7265: lot_number, nvl(line_direction,'O') line_direction,
7266: requested_quantity_uom,
7267: requested_quantity_uom2
7268: FROM wsh_delivery_details
7269: WHERE delivery_detail_id = p_delivery_detail_id;
7270: --
7271: --
7272: l_line_rec line_csr%ROWTYPE;

Line 7304: l_item_info WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec;

7300: l_msg_data VARCHAR2(32767);
7301: l_return_status VARCHAR2(32767);
7302: --
7303: -- HW OPMCONV - New variables
7304: l_item_info WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec;
7305: INVALID_LOT EXCEPTION;
7306: e_end_of_api EXCEPTION;
7307: --}
7308: BEGIN

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

7396: -- HW OPMCONV - No need to call OPM APIS
7397:
7398: -- HW OPMCONV - Call API to get item info
7399: IF l_debug_on THEN
7400: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.Get_item_information',WSH_DEBUG_SV.C_PROC_LEVEL);
7401: END IF;
7402:
7403: WSH_DELIVERY_DETAILS_INV.Get_item_information
7404: (

Line 7403: WSH_DELIVERY_DETAILS_INV.Get_item_information

7399: IF l_debug_on THEN
7400: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.Get_item_information',WSH_DEBUG_SV.C_PROC_LEVEL);
7401: END IF;
7402:
7403: WSH_DELIVERY_DETAILS_INV.Get_item_information
7404: (
7405: p_organization_id => l_line_rec.organization_id
7406: , p_inventory_item_id => l_line_rec.inventory_item_id
7407: , x_mtl_system_items_rec => l_item_info

Line 8971: l_item_info WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec;

8967: p_released_status IN VARCHAR2)
8968: RETURN BOOLEAN
8969: IS
8970:
8971: l_item_info WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec;
8972: l_released_status VARCHAR2(1);
8973: l_debug_on BOOLEAN;
8974: l_return_status VARCHAR2(1);
8975: l_number_of_errors NUMBER ;

Line 8993: from wsh_delivery_details

8989:
8990:
8991: CURSOR get_line_id IS
8992: SELECT source_line_id
8993: from wsh_delivery_details
8994: WHERE delivery_detail_id = p_delivery_detail_id;
8995:
8996:
8997: BEGIN

Line 9019: WSH_DELIVERY_DETAILS_INV.Get_item_information

9015: wsh_debug_sv.LOG(l_module_name, 'p_inventory_item_id', p_inventory_item_id);
9016: END IF;
9017: --
9018:
9019: WSH_DELIVERY_DETAILS_INV.Get_item_information
9020: (
9021: p_organization_id => p_organization_id,
9022: p_inventory_item_id => p_inventory_item_id,
9023: x_mtl_system_items_rec => l_item_info,

Line 9121: l_item_info WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec;

9117: p_cycle_qty IN NUMBER)
9118: RETURN BOOLEAN
9119: IS
9120:
9121: l_item_info WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec;
9122: l_released_status VARCHAR2(1);
9123: l_debug_on BOOLEAN;
9124: l_return_status VARCHAR2(1);
9125: l_number_of_errors NUMBER ;

Line 9155: WSH_DELIVERY_DETAILS_INV.Get_item_information

9151: wsh_debug_sv.LOG(l_module_name, 'p_inventory_item_id', p_inventory_item_id);
9152: END IF;
9153: --
9154:
9155: WSH_DELIVERY_DETAILS_INV.Get_item_information
9156: (
9157: p_organization_id => p_organization_id,
9158: p_inventory_item_id => p_inventory_item_id,
9159: x_mtl_system_items_rec => l_item_info,