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 197: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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

Line 207: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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

Line 238: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

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

Line 401: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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

Line 411: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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

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

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

Line 913: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

909: g_validation_level_tab(C_ACTION_ENABLED_LVL) :=1; -- J-IB-JCKWOK
910: END IF;
911:
912: ELSE
913: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
914: END IF;
915:
916: IF l_debug_on THEN
917: WSH_DEBUG_SV.pop(l_module_name);

Line 930: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

926: END IF;
927:
928: WHEN OTHERS THEN
929: IF l_debug_on THEN
930: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
931: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
932: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
933: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
934: END IF;