[Home] [Help]
362: --Added condition p_unreserve_mode = 'RETAIN_RSV' for bug 4721577
363: --Added condition p_unreserve_mode = 'UNRESERVE' for bug 11828449
364: IF (NVL(p_unreserve_mode, 'UNRESERVE') in ('UNRESERVE', 'RETAIN_RSV')) AND
365: l_line_rec.parent_delivery_detail_id IS NOT NULL AND
366: (wsh_util_validate.Check_Wms_Org(l_line_rec.organization_id)='Y') THEN
367: OPEN c_lpn_id(l_line_rec.parent_delivery_detail_id);
368: FETCH c_lpn_id INTO l_lpn_id;
369: --
370: IF (c_lpn_id%FOUND) THEN
2342: FETCH c_del_id_for_cont_or_detail into l_del_id_for_detail;
2343: CLOSE c_del_id_for_cont_or_detail;
2344:
2345: -- K LPN CONV. rv
2346: l_wms_org := wsh_util_validate.check_wms_org(l_del_id_FOR_container.organization_id);
2347: -- K LPN CONV. rv
2348:
2349: -- J: W/V Changes
2350: -- Return if the dd is already assigned to the specified container
3772: WSH_DEBUG_SV.log(l_module_name,' parent cnt orgn id is', l_parent_cnt_orgn_id);
3773: WSH_DEBUG_SV.log(l_module_name,' parent cnt line dir is', l_parent_cnt_line_dir);
3774: END IF;
3775: --
3776: l_wms_org := wsh_util_validate.check_wms_org(l_parent_cnt_orgn_id);
3777: --
3778: -- LPN CONV. rv
3779: --
3780: END IF;
4515: */
4516: --
4517: -- K LPN CONV. rv
4518: --
4519: l_detail_wms_org := wsh_util_validate.check_wms_org(l_detail.organization_id);
4520: --
4521: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
4522: AND l_detail.line_direction IN ('O','IO')
4523: AND
4963:
4964:
4965: IF (l_detail.released_status = WSH_DELIVERY_DETAILS_PKG.C_RELEASED_TO_WAREHOUSE) THEN
4966: --{
4967: IF (wsh_util_validate.Check_Wms_Org(l_detail.organization_id)='Y') AND
4968: (l_detail.move_order_line_id IS NOT NULL AND
4969: (WSH_USA_INV_PVT.is_mo_type_putaway
4970: (p_move_order_line_id => l_detail.move_order_line_id) = 'N') -- X-dock
4971: ) THEN -- check if wms org
5506: CLOSE c_del_id_for_cont_or_detail;
5507:
5508: -- K LPN CONV. rv
5509: --
5510: l_wms_org := wsh_util_validate.check_wms_org(l_del_id_for_container2.organization_id);
5511: --
5512: -- K LPN CONV. rv
5513: IF l_debug_on THEN
5514: WSH_DEBUG_SV.log(l_module_name,'delivery_id 1',
6945: -- even though deliveries are shipped/planned, so bypassing checks
6946: -- for those callers.
6947: --bugfix 13083282
6948: --
6949: l_chk_wms_org :=wsh_util_validate.check_wms_org(l_assign.organization_id);
6950: --
6951: IF l_container_flag = 'Y' THEN --{ --bug 5100229
6952: IF l_debug_on THEN
6953: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.Is_Empty',WSH_DEBUG_SV.C_PROC_LEVEL);
7101: FOR j IN 0..(l_dd_id.COUNT-1) LOOP
7102: --
7103: -- K LPN CONV. rv
7104: --
7105: l_loop_wms_org := wsh_util_validate.check_wms_org(l_det_org_id_tbl(j));
7106: --
7107: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
7108: AND l_line_dir_tbl(j) IN ('O', 'IO')
7109: AND l_cnt_flag_tbl(j) = 'Y'
7330: CLOSE get_mo_line_id;
7331:
7332: IF l_mo_line_id IS NOT NULL AND
7333: (WSH_USA_INV_PVT.is_mo_type_putaway(p_move_order_line_id => l_mo_line_id)='N') AND --X-dock
7334: (WSH_UTIL_VALIDATE.Check_Wms_Org(l_det_org)='Y')
7335: THEN
7336:
7337: OPEN c_grouping_id;
7338: FETCH c_grouping_id into l_carton_grouping_id;
7450: WSH_DEBUG_SV.log(l_module_name,' parent cnt orgn id is', l_parent_cnt_orgn_id);
7451: WSH_DEBUG_SV.log(l_module_name,' parent cnt line dir is', l_parent_cnt_line_dir);
7452: END IF;
7453: --
7454: l_wms_org := wsh_util_validate.check_wms_org(l_parent_cnt_orgn_id);
7455: --
7456: -- K LPN CONV. rv
7457: --
7458: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
12212: -- need to be deleted at a later stage through Confirm_Delivery
12213: open l_get_cnt_org_csr(l_parent_container_id(1));
12214: fetch l_get_cnt_org_csr into l_orgn_id, l_line_dir;
12215: close l_get_cnt_org_csr;
12216: l_wms_org := wsh_util_validate.check_wms_org(l_orgn_id);
12217: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
12218: AND l_line_dir IN ('O', 'IO')
12219: AND l_wms_org = 'Y' THEN
12220: --{