DBA Data[Home] [Help]

APPS.WSH_WV_UTILS dependencies on WSH_UTIL_VALIDATE

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

491: CLOSE get_detail_wv;
492:
493: --lpn conv
494: IF l_container_flag IN ('Y', 'C') THEN
495: l_wms_org := wsh_util_validate.check_wms_org(l_organization_id);
496: IF l_wms_org = 'Y' THEN
497: l_wv_frozen_flag := 'N';
498: END IF;
499: END IF;

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

1381: END;
1382:
1383: --lpn conv
1384: IF l_container_flag IN ('Y', 'C') THEN
1385: l_wms_org := wsh_util_validate.check_wms_org(l_organization_id);
1386: IF l_wms_org = 'Y' THEN
1387: l_frozen_flag := 'N';
1388: END IF;
1389: END IF;

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

1787: END IF;
1788:
1789: --lpn conv
1790: IF l_container_flag IN ('Y', 'C') AND l_line_direction IN ('O', 'IO') THEN
1791: l_update_wms_org := wsh_util_validate.Check_Wms_Org(l_organization_id);
1792: END IF;
1793:
1794: OPEN c_get_item_id(l_parent_container_id);
1795: FETCH c_get_item_id INTO l_item_id;

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

2694: WSH_DEBUG_SV.log(l_module_name,'line direction', l_line_direction);
2695: WSH_DEBUG_SV.log(l_module_name,'Organization Id', l_organization_id);
2696: END IF;
2697: --
2698: l_wms_org := wsh_util_validate.check_wms_org(l_organization_id);
2699: --
2700: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
2701: AND l_line_direction IN ('O','IO')
2702: AND l_container_flag IN ('Y', 'C')

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

3095: --lpn conv
3096: IF childInfo_rec.container_flag IN ('Y', 'C')
3097: AND NVL(childInfo_rec.wv_frozen_flag,'Y') = 'Y' THEN
3098: l_wms_org :=
3099: wsh_util_validate.check_wms_org(childInfo_rec.organization_id);
3100: IF l_wms_org = 'Y' THEN
3101: childInfo_rec.wv_frozen_flag := 'N';
3102: END IF;
3103: END IF;

Line 3761: wsh_util_validate.check_wms_org(l_organization_id);

3757:
3758: --lpn conv
3759: IF NVL(l_frozen_flag,'Y') = 'Y' THEN
3760: l_wms_org :=
3761: wsh_util_validate.check_wms_org(l_organization_id);
3762: IF l_wms_org = 'Y' THEN
3763: l_frozen_flag := 'N';
3764: END IF;
3765: END IF;

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

4471: WSH_DEBUG_SV.log(l_module_name,'line direction', l_line_direction);
4472: WSH_DEBUG_SV.log(l_module_name,'Organization Id', l_organization_id);
4473: END IF;
4474: --
4475: l_wms_org := wsh_util_validate.check_wms_org(l_organization_id);
4476: --
4477: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
4478: AND l_line_direction IN ('O','IO')
4479: AND l_cont_flag = 'Y'

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

6807: --{
6808: --
6809: -- need to check the wms org value for each record because the parent LPN
6810: -- can be a consol. LPN.
6811: l_wms_org := wsh_util_validate.check_wms_org(l_detail_rec_tab(i).organization_id);
6812: --
6813: IF l_debug_on THEN
6814: WSH_DEBUG_SV.log(l_module_name,'l_wms_org value is', l_wms_org);
6815: END IF;