1: PACKAGE BODY FTE_ACS_TRIP_PKG as
2: /* $Header: FTEACSTB.pls 120.4 2005/12/12 02:59:41 alksharm noship $ */
3:
4: --
5: G_PKG_NAME CONSTANT VARCHAR2(50) := 'FTE_ACS_TRIP_PKG';
1: PACKAGE BODY FTE_ACS_TRIP_PKG as
2: /* $Header: FTEACSTB.pls 120.4 2005/12/12 02:59:41 alksharm noship $ */
3:
4: --
5: G_PKG_NAME CONSTANT VARCHAR2(50) := 'FTE_ACS_TRIP_PKG';
6: --
7:
8: --
9: -- ----------------------------------------------------------------------
464: --}
465: EXCEPTION
466:
467: WHEN OTHERS THEN
468: wsh_util_core.default_handler('FTE_ACS_TRIP_PKG.CARRIER_SEL_CREATE_TRIP',l_module_name);
469:
470: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
471:
472: IF c_dlvy_attr_csr%ISOPEN THEN
585: END IF;
586:
587: WHEN others THEN
588:
589: WSH_UTIL_CORE.default_handler('FTE_ACS_TRIP_PKG.GET_RANKED_RESULTS');
590: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
591:
592: IF l_debug_on THEN
593: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
596: --
597:
598: END GET_RANKED_RESULTS;
599:
600: END FTE_ACS_TRIP_PKG;