334: END IF;
335: --
336: --
337: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
338: RAISE FND_API.G_EXC_ERROR;
339: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
341: ELSE
342: IF NVL(x_return_status,wsh_util_core.g_ret_sts_success) =
336: --
337: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
338: RAISE FND_API.G_EXC_ERROR;
339: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
341: ELSE
342: IF NVL(x_return_status,wsh_util_core.g_ret_sts_success) =
343: wsh_util_core.g_ret_sts_success
344: THEN
373: END IF;
374:
375: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
376: WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
377: RAISE FND_API.G_EXC_ERROR;
378: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
379: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
380: END IF;
381: --}
375: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
376: WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
377: RAISE FND_API.G_EXC_ERROR;
378: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
379: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
380: END IF;
381: --}
382: END IF;
383: --
412: END IF;
413: --
414: --
415: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
416: RAISE FND_API.G_EXC_ERROR;
417: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
418: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
419: --ELSE
420: --x_return_status := l_return_status;
414: --
415: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
416: RAISE FND_API.G_EXC_ERROR;
417: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
418: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
419: --ELSE
420: --x_return_status := l_return_status;
421: END IF;
422: --
441: END IF;
442:
443: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
444: WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
445: RAISE FND_API.G_EXC_ERROR;
446: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
447: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
448: END IF;
449: --}
443: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
444: WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
445: RAISE FND_API.G_EXC_ERROR;
446: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
447: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
448: END IF;
449: --}
450: END IF;
451: --
509:
510: --wsh_debug_sv.stop_other_app_debug('OE', l_return_status);
511: wsh_debug_sv.stop_debug;
512: EXCEPTION
513: WHEN FND_API.G_EXC_ERROR THEN
514: x_return_status := FND_API.G_RET_STS_ERROR ;
515: --
516: -- K LPN CONV. rv
517: --
510: --wsh_debug_sv.stop_other_app_debug('OE', l_return_status);
511: wsh_debug_sv.stop_debug;
512: EXCEPTION
513: WHEN FND_API.G_EXC_ERROR THEN
514: x_return_status := FND_API.G_RET_STS_ERROR ;
515: --
516: -- K LPN CONV. rv
517: --
518: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
574: -- End of Code Bugfix 4070732
575: --
576:
577: IF l_debug_on THEN
578: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
579: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
580: END IF;
581: --
582: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
575: --
576:
577: IF l_debug_on THEN
578: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
579: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
580: END IF;
581: --
582: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
583: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
578: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
579: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
580: END IF;
581: --
582: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
583: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
584: --
585: -- K LPN CONV. rv
586: --
579: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
580: END IF;
581: --
582: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
583: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
584: --
585: -- K LPN CONV. rv
586: --
587: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
634: --
635: -- End of Code Bugfix 4070732
636: --
637: IF l_debug_on THEN
638: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
639: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
640: END IF;
641: --
642: WHEN invalid_doc_direction
635: -- End of Code Bugfix 4070732
636: --
637: IF l_debug_on THEN
638: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
639: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
640: END IF;
641: --
642: WHEN invalid_doc_direction
643: THEN
923: END IF;
924: wsh_debug_sv.stop_debug;
925: WHEN OTHERS
926: THEN
927: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
928: IF l_debug_on THEN
929: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
930: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
931: END IF;