[Home] [Help]
81: l_container_name := p_delivery_details_info.container_name;
82: IF l_debug_on THEN
83: WSH_DEBUG_SV.logmsg(l_module_name, 'CHECK TO SEE IF CONTAINER_NAME ALREADY EXISTS');
84: END IF;
85: OPEN Get_Exist_Cont(l_container_name,WSH_UTIL_VALIDATE.check_wms_org(p_delivery_details_info.organization_id));
86: FETCH Get_Exist_Cont INTO l_cont_cnt;
87: CLOSE Get_Exist_Cont;
88: IF l_cont_cnt = 1 THEN
89: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
428: -- IF (nvl(l_wh_type, FND_API.G_MISS_CHAR) IN ('TPW','CMS')) THEN --{
429: IF (nvl(l_wh_type, FND_API.G_MISS_CHAR) IN ('TPW','CMS','TW2')) THEN --{
430: l_delivery_details_info.ignore_for_planning:='Y';
431: ELSIF (l_gc3_is_installed = 'Y') THEN
432: WSH_UTIL_VALIDATE.CALC_IGNORE_FOR_PLANNING(
433: p_organization_id => l_delivery_details_info.organization_id
434: ,p_carrier_id => NULL
435: ,p_ship_method_code => NULL
436: ,p_tp_installed => NULL
439: ,x_return_status => l_return_status
440: ,p_otm_installed => 'Y'
441: ,p_client_id => l_delivery_details_info.client_id); -- LSP PROJECT : Added client_id
442: IF l_debug_on THEN
443: WSH_DEBUG_SV.log(l_module_name,'After call to WSH_UTIL_VALIDATE.CA'
444: ||'LC_IGNORE_FOR_PLANNING l_return_status',l_return_status);
445: WSH_DEBUG_SV.log(l_module_name,'l_ignore_for_planning ',
446: l_ignore_for_planning );
447: END IF;
1559: IF l_debug_on THEN
1560: wsh_debug_sv.Logmsg(l_module_name, 'ORG ID - '|| p_organization_id);
1561: END IF;
1562:
1563: l_wms_installed := wsh_util_validate.Check_wms_org(p_organization_id);
1564:
1565: IF l_wms_installed = 'Y' THEN
1566: IF l_debug_on THEN
1567: wsh_debug_sv.Logmsg(l_module_name,'Check if Wave line Already exist for delivery detail - '||p_delivery_detail_id);
3530:
3531: --lpn conv
3532: IF l_container_flag IN ('Y', 'C') THEN --{
3533: l_wms_installed :=
3534: wsh_util_validate.Check_Wms_Org(p_delivery_details_info.organization_id);
3535:
3536: IF l_wms_installed = 'Y' THEN --{
3537: l_org_type := 'WMS';
3538: l_frozen_flag := 'N';