384: p_organization_id IN NUMBER,
385: x_wms_flag OUT NOCOPY VARCHAR2,
386: x_return_status OUT NOCOPY VARCHAR2) IS
387:
388: l_wms_installed BOOLEAN;
389: l_return_status VARCHAR2(1);
390: l_msg_count NUMBER;
391: l_msg_data VARCHAR2(4000);
392: others EXCEPTION;
429:
430: g_cache_wms_org_id := p_organization_id;
431: g_cache_wms_flag := 'N';
432:
433: l_wms_installed := WMS_INSTALL.CHECK_INSTALL(
434: x_return_status => l_return_status,
435: x_msg_count => l_msg_count,
436: x_msg_data => l_msg_data,
437: p_organization_id => p_organization_id);
444: --
445: raise others;
446: END IF;
447:
448: IF l_wms_installed THEN
449: x_wms_flag := 'Y';
450: g_cache_wms_flag := 'Y';
451: END IF;
452:
451: END IF;
452:
453: --
454: IF l_debug_on THEN
455: WSH_DEBUG_SV.log(l_module_name,'l_wms_installed',l_wms_installed);
456: WSH_DEBUG_SV.log(l_module_name,'x_wms_flag',x_wms_flag);
457: WSH_DEBUG_SV.pop(l_module_name);
458: END IF;
459: --