DBA Data[Home] [Help]

APPS.WSH_WV_UTILS dependencies on WSH_UTIL_VALIDATE

Line 490: l_wms_org := wsh_util_validate.check_wms_org(l_organization_id);

486: CLOSE get_detail_wv;
487:
488: --lpn conv
489: IF l_container_flag IN ('Y', 'C') THEN
490: l_wms_org := wsh_util_validate.check_wms_org(l_organization_id);
491: IF l_wms_org = 'Y' THEN
492: l_wv_frozen_flag := 'N';
493: END IF;
494: END IF;

Line 1372: l_wms_org := wsh_util_validate.check_wms_org(l_organization_id);

1368: END;
1369:
1370: --lpn conv
1371: IF l_container_flag IN ('Y', 'C') THEN
1372: l_wms_org := wsh_util_validate.check_wms_org(l_organization_id);
1373: IF l_wms_org = 'Y' THEN
1374: l_frozen_flag := 'N';
1375: END IF;
1376: END IF;

Line 1778: l_update_wms_org := wsh_util_validate.Check_Wms_Org(l_organization_id);

1774: END IF;
1775:
1776: --lpn conv
1777: IF l_container_flag IN ('Y', 'C') AND l_line_direction IN ('O', 'IO') THEN
1778: l_update_wms_org := wsh_util_validate.Check_Wms_Org(l_organization_id);
1779: END IF;
1780:
1781: OPEN c_get_item_id(l_parent_container_id);
1782: FETCH c_get_item_id INTO l_item_id;

Line 2685: l_wms_org := wsh_util_validate.check_wms_org(l_organization_id);

2681: WSH_DEBUG_SV.log(l_module_name,'line direction', l_line_direction);
2682: WSH_DEBUG_SV.log(l_module_name,'Organization Id', l_organization_id);
2683: END IF;
2684: --
2685: l_wms_org := wsh_util_validate.check_wms_org(l_organization_id);
2686: --
2687: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
2688: AND l_line_direction IN ('O','IO')
2689: AND l_container_flag IN ('Y', 'C')

Line 3086: wsh_util_validate.check_wms_org(childInfo_rec.organization_id);

3082: --lpn conv
3083: IF childInfo_rec.container_flag IN ('Y', 'C')
3084: AND NVL(childInfo_rec.wv_frozen_flag,'Y') = 'Y' THEN
3085: l_wms_org :=
3086: wsh_util_validate.check_wms_org(childInfo_rec.organization_id);
3087: IF l_wms_org = 'Y' THEN
3088: childInfo_rec.wv_frozen_flag := 'N';
3089: END IF;
3090: END IF;

Line 3748: wsh_util_validate.check_wms_org(l_organization_id);

3744:
3745: --lpn conv
3746: IF NVL(l_frozen_flag,'Y') = 'Y' THEN
3747: l_wms_org :=
3748: wsh_util_validate.check_wms_org(l_organization_id);
3749: IF l_wms_org = 'Y' THEN
3750: l_frozen_flag := 'N';
3751: END IF;
3752: END IF;

Line 4462: l_wms_org := wsh_util_validate.check_wms_org(l_organization_id);

4458: WSH_DEBUG_SV.log(l_module_name,'line direction', l_line_direction);
4459: WSH_DEBUG_SV.log(l_module_name,'Organization Id', l_organization_id);
4460: END IF;
4461: --
4462: l_wms_org := wsh_util_validate.check_wms_org(l_organization_id);
4463: --
4464: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
4465: AND l_line_direction IN ('O','IO')
4466: AND l_cont_flag = 'Y'

Line 6779: l_wms_org := wsh_util_validate.check_wms_org(l_detail_rec_tab(i).organization_id);

6775: --{
6776: --
6777: -- need to check the wms org value for each record because the parent LPN
6778: -- can be a consol. LPN.
6779: l_wms_org := wsh_util_validate.check_wms_org(l_detail_rec_tab(i).organization_id);
6780: --
6781: IF l_debug_on THEN
6782: WSH_DEBUG_SV.log(l_module_name,'l_wms_org value is', l_wms_org);
6783: END IF;