[Home] [Help]
353: END IF;
354: --Added condition p_unreserve_mode = 'RETAIN_RSV' for bug 4721577
355: IF ( p_unreserve_mode = 'RETAIN_RSV' AND
356: l_line_rec.parent_delivery_detail_id IS NOT NULL AND
357: wsh_util_validate.Check_Wms_Org(l_line_rec.organization_id)='Y') THEN
358: OPEN c_lpn_id(l_line_rec.parent_delivery_detail_id);
359: FETCH c_lpn_id INTO l_lpn_id;
360: IF (c_lpn_id%FOUND) THEN
361: IF l_lpn_id is not null THEN
2236: FETCH c_del_id_for_cont_or_detail into l_del_id_for_detail;
2237: CLOSE c_del_id_for_cont_or_detail;
2238:
2239: -- K LPN CONV. rv
2240: l_wms_org := wsh_util_validate.check_wms_org(l_del_id_FOR_container.organization_id);
2241: -- K LPN CONV. rv
2242:
2243: -- J: W/V Changes
2244: -- Return if the dd is already assigned to the specified container
3627: WSH_DEBUG_SV.log(l_module_name,' parent cnt orgn id is', l_parent_cnt_orgn_id);
3628: WSH_DEBUG_SV.log(l_module_name,' parent cnt line dir is', l_parent_cnt_line_dir);
3629: END IF;
3630: --
3631: l_wms_org := wsh_util_validate.check_wms_org(l_parent_cnt_orgn_id);
3632: --
3633: -- LPN CONV. rv
3634: --
3635: END IF;
4367: */
4368: --
4369: -- K LPN CONV. rv
4370: --
4371: l_detail_wms_org := wsh_util_validate.check_wms_org(l_detail.organization_id);
4372: --
4373: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
4374: AND l_detail.line_direction IN ('O','IO')
4375: AND
4810:
4811:
4812: IF (l_detail.released_status = WSH_DELIVERY_DETAILS_PKG.C_RELEASED_TO_WAREHOUSE) THEN
4813: --{
4814: IF (wsh_util_validate.Check_Wms_Org(l_detail.organization_id)='Y') AND
4815: (l_detail.move_order_line_id IS NOT NULL AND
4816: (WSH_USA_INV_PVT.is_mo_type_putaway
4817: (p_move_order_line_id => l_detail.move_order_line_id) = 'N') -- X-dock
4818: ) THEN -- check if wms org
5353: CLOSE c_del_id_for_cont_or_detail;
5354:
5355: -- K LPN CONV. rv
5356: --
5357: l_wms_org := wsh_util_validate.check_wms_org(l_del_id_for_container2.organization_id);
5358: --
5359: -- K LPN CONV. rv
5360: IF l_debug_on THEN
5361: WSH_DEBUG_SV.log(l_module_name,'delivery_id 1',
6932: FOR j IN 0..(l_dd_id.COUNT-1) LOOP
6933: --
6934: -- K LPN CONV. rv
6935: --
6936: l_loop_wms_org := wsh_util_validate.check_wms_org(l_det_org_id_tbl(j));
6937: --
6938: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
6939: AND l_line_dir_tbl(j) IN ('O', 'IO')
6940: AND l_cnt_flag_tbl(j) = 'Y'
7161: CLOSE get_mo_line_id;
7162:
7163: IF l_mo_line_id IS NOT NULL AND
7164: (WSH_USA_INV_PVT.is_mo_type_putaway(p_move_order_line_id => l_mo_line_id)='N') AND --X-dock
7165: (WSH_UTIL_VALIDATE.Check_Wms_Org(l_det_org)='Y')
7166: THEN
7167:
7168: OPEN c_grouping_id;
7169: FETCH c_grouping_id into l_carton_grouping_id;
7286: WSH_DEBUG_SV.log(l_module_name,' parent cnt orgn id is', l_parent_cnt_orgn_id);
7287: WSH_DEBUG_SV.log(l_module_name,' parent cnt line dir is', l_parent_cnt_line_dir);
7288: END IF;
7289: --
7290: l_wms_org := wsh_util_validate.check_wms_org(l_parent_cnt_orgn_id);
7291: --
7292: -- K LPN CONV. rv
7293: --
7294: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
11747: -- need to be deleted at a later stage through Confirm_Delivery
11748: open l_get_cnt_org_csr(l_parent_container_id(1));
11749: fetch l_get_cnt_org_csr into l_orgn_id, l_line_dir;
11750: close l_get_cnt_org_csr;
11751: l_wms_org := wsh_util_validate.check_wms_org(l_orgn_id);
11752: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
11753: AND l_line_dir IN ('O', 'IO')
11754: AND l_wms_org = 'Y' THEN
11755: --{