APPS.WSH_ACTIONS_LEVELS dependencies on WSH_UTIL_CORE

Line 28: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

24: IF l_debug_on THEN
25: WSH_DEBUG_SV.push(l_module_name);
26: WSH_DEBUG_SV.log(l_module_name,'p_entity',p_entity);
27: END IF;
28: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
29:
30: g_validation_level_tab(C_VALIDATE_CONSTRAINTS_LVL) := 1;
31:
32: IF (p_entity = 'DLVB' ) THEN

Line 198: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

194: g_validation_level_tab(C_FREIGHT_CURR_CODE_LVL) :=1;
195: g_validation_level_tab(C_PARENT_ENTITY_LVL) :=1;
196: g_validation_level_tab(C_ACTION_ENABLED_LVL) :=1; -- J-IB-JCKWOK
197: ELSE
198: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
199: END IF;
200:
201: IF l_debug_on THEN
202: WSH_DEBUG_SV.pop(l_module_name);

Line 208: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

204:
205: EXCEPTION
206: WHEN OTHERS THEN
207: IF l_debug_on THEN
208: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
209: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
210: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
211: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
212: END IF;

Line 239: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

235: WSH_DEBUG_SV.push(l_module_name);
236: WSH_DEBUG_SV.log(l_module_name,'p_entity',p_entity);
237: END IF;
238:
239: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
240:
241: --Turning off the common validation levels first
242: g_validation_level_tab(C_ACTION_ENABLED_LVL):=0;
243: g_validation_level_tab(C_LOCK_RECORDS_LVL):=0;

Line 403: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

399: g_validation_level_tab(C_FREIGHT_CURR_CODE_LVL) :=0;
400: g_validation_level_tab(C_PARENT_ENTITY_LVL) :=0;
401: g_validation_level_tab(C_ACTION_ENABLED_LVL) :=0; -- J-IB-JCKWOK
402: ELSE
403: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
404: END IF;
405:
406: IF l_debug_on THEN
407: WSH_DEBUG_SV.pop(l_module_name);

Line 413: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

409:
410: EXCEPTION
411: WHEN OTHERS THEN
412: IF l_debug_on THEN
413: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
414: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
415: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
416: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
417: END IF;

Line 459: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN

455: IF l_debug_on THEN
456: WSH_DEBUG_SV.log(l_module_name,'set_validation_level_off x_return_status',x_return_status);
457: END IF;
458:
459: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
460: raise error_in_validation_level_off;
461: END IF;
462:
463: IF (p_entity = 'DLVB' ) THEN

Line 922: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

918: g_validation_level_tab(C_ACTION_ENABLED_LVL) :=1; -- J-IB-JCKWOK
919: END IF;
920:
921: ELSE
922: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
923: END IF;
924:
925: IF l_debug_on THEN
926: WSH_DEBUG_SV.pop(l_module_name);

Line 939: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

935: END IF;
936:
937: WHEN OTHERS THEN
938: IF l_debug_on THEN
939: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
940: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
941: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
942: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
943: END IF;