395:
396: --
397: IF l_debug_on THEN
398: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
399: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
400: END IF;
401: --
402: RETURN g_unexp_char;
403:
534:
535: FND_MSG_PUB.Count_And_Get (
536: p_count => x_msg_count,
537: p_data => x_msg_data,
538: p_encoded => FND_API.G_FALSE);
539:
540: EXCEPTION
541: WHEN invalid_loc_src_code THEN
542: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
543:
544: FND_MSG_PUB.Count_And_Get (
545: p_count => x_msg_count,
546: p_data => x_msg_data,
547: p_encoded => FND_API.G_FALSE);
548:
549: --
550: IF l_debug_on THEN
551: WSH_DEBUG_SV.log(l_module_name,'Error : Invalid Location Source Code : ', p_source_location_code);
548:
549: --
550: IF l_debug_on THEN
551: WSH_DEBUG_SV.log(l_module_name,'Error : Invalid Location Source Code : ', p_source_location_code);
552: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
553: END IF;
554: WHEN OTHERS THEN
555: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
556:
556:
557: FND_MSG_PUB.Count_And_Get (
558: p_count => x_msg_count,
559: p_data => x_msg_data,
560: p_encoded => FND_API.G_FALSE);
561:
562: --
563: IF l_debug_on THEN
564: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
561:
562: --
563: IF l_debug_on THEN
564: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
565: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
566: END IF;
567: --
568: END get_facility_display;
569: