17: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
18: --
19: IF l_debug_on IS NULL
20: THEN
21: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
22: END IF;
23: --
24: IF l_debug_on THEN
25: WSH_DEBUG_SV.push(l_module_name);
21: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
22: END IF;
23: --
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:
22: END IF;
23: --
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;
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);
203: END IF;
204:
205: EXCEPTION
206: WHEN OTHERS THEN
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;
213:
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;
213:
214: END set_validation_level_on;
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;
213:
214: END set_validation_level_on;
215:
227: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
228: --
229: IF l_debug_on IS NULL
230: THEN
231: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
232: END IF;
233: --
234: IF l_debug_on THEN
235: WSH_DEBUG_SV.push(l_module_name);
231: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
232: END IF;
233: --
234: IF l_debug_on THEN
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;
232: END IF;
233: --
234: IF l_debug_on THEN
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:
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);
408: END IF;
409:
410: EXCEPTION
411: WHEN OTHERS THEN
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;
418:
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;
418:
419: END set_validation_level_off;
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;
418:
419: END set_validation_level_off;
420:
436: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
437: --
438: IF l_debug_on IS NULL
439: THEN
440: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
441: END IF;
442: --
443: IF l_debug_on THEN
444: WSH_DEBUG_SV.push(l_module_name);
440: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
441: END IF;
442: --
443: IF l_debug_on THEN
444: WSH_DEBUG_SV.push(l_module_name);
445: --
446: WSH_DEBUG_SV.log(l_module_name,'p_entity',p_entity);
447: WSH_DEBUG_SV.log(l_module_name,'p_caller',p_caller);
448: WSH_DEBUG_SV.log(l_module_name,'p_phase',p_phase);
442: --
443: IF l_debug_on THEN
444: WSH_DEBUG_SV.push(l_module_name);
445: --
446: WSH_DEBUG_SV.log(l_module_name,'p_entity',p_entity);
447: WSH_DEBUG_SV.log(l_module_name,'p_caller',p_caller);
448: WSH_DEBUG_SV.log(l_module_name,'p_phase',p_phase);
449: WSH_DEBUG_SV.log(l_module_name,'p_action',p_action);
450: END IF;
443: IF l_debug_on THEN
444: WSH_DEBUG_SV.push(l_module_name);
445: --
446: WSH_DEBUG_SV.log(l_module_name,'p_entity',p_entity);
447: WSH_DEBUG_SV.log(l_module_name,'p_caller',p_caller);
448: WSH_DEBUG_SV.log(l_module_name,'p_phase',p_phase);
449: WSH_DEBUG_SV.log(l_module_name,'p_action',p_action);
450: END IF;
451:
444: WSH_DEBUG_SV.push(l_module_name);
445: --
446: WSH_DEBUG_SV.log(l_module_name,'p_entity',p_entity);
447: WSH_DEBUG_SV.log(l_module_name,'p_caller',p_caller);
448: WSH_DEBUG_SV.log(l_module_name,'p_phase',p_phase);
449: WSH_DEBUG_SV.log(l_module_name,'p_action',p_action);
450: END IF;
451:
452: l_phase := nvl(p_phase,1);
445: --
446: WSH_DEBUG_SV.log(l_module_name,'p_entity',p_entity);
447: WSH_DEBUG_SV.log(l_module_name,'p_caller',p_caller);
448: WSH_DEBUG_SV.log(l_module_name,'p_phase',p_phase);
449: WSH_DEBUG_SV.log(l_module_name,'p_action',p_action);
450: END IF;
451:
452: l_phase := nvl(p_phase,1);
453:
452: l_phase := nvl(p_phase,1);
453:
454: set_validation_level_off(p_entity,x_return_status);
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;
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);
927: END IF;
928:
929: EXCEPTION
930: WHEN error_in_validation_level_off THEN
928:
929: EXCEPTION
930: WHEN error_in_validation_level_off THEN
931: IF l_debug_on THEN
932: WSH_DEBUG_SV.logmsg(l_module_name,'error_in_set_validation_level_off exception has occured.',
933: WSH_DEBUG_SV.C_EXCEP_LEVEL);
934: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:error_in_set_validation_level_off');
935: END IF;
936:
929: EXCEPTION
930: WHEN error_in_validation_level_off THEN
931: IF l_debug_on THEN
932: WSH_DEBUG_SV.logmsg(l_module_name,'error_in_set_validation_level_off exception has occured.',
933: WSH_DEBUG_SV.C_EXCEP_LEVEL);
934: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:error_in_set_validation_level_off');
935: END IF;
936:
937: WHEN OTHERS THEN
930: WHEN error_in_validation_level_off THEN
931: IF l_debug_on THEN
932: WSH_DEBUG_SV.logmsg(l_module_name,'error_in_set_validation_level_off exception has occured.',
933: WSH_DEBUG_SV.C_EXCEP_LEVEL);
934: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:error_in_set_validation_level_off');
935: END IF;
936:
937: WHEN OTHERS THEN
938: IF l_debug_on THEN
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;
944: END set_validation_level;
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;
944: END set_validation_level;
945:
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;
944: END set_validation_level;
945:
946: