DBA Data[Home] [Help]

APPS.WSH_REGIONS_SEARCH_PKG dependencies on FND_API

Line 96: l_return_status := FND_API.G_RET_STS_SUCCESS;

92: THEN
93: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
94: END IF;
95:
96: l_return_status := FND_API.G_RET_STS_SUCCESS;
97: --
98: --
99: -- Debug Statements
100: --

Line 141: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

137: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
138: --
139: IF l_debug_on THEN
140: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
141: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
142: END IF;
143: END get_key;
144:
145: PROCEDURE Get_Region_Info (

Line 1983: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

1979: WSH_UTIL_CORE.default_handler('WSH_REGIONS_SEARCH_PKG.Get_Child_Requests_Status');
1980: --
1981: IF l_debug_on THEN
1982: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1983: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1984: END IF;
1985:
1986: END Get_Child_Requests_Status;
1987:

Line 2060: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

2056: WSH_UTIL_CORE.default_handler('WSH_REGIONS_SEARCH_PKG.Process_All_Locations');
2057: --
2058: IF l_debug_on THEN
2059: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2060: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2061: END IF;
2062:
2063: END Process_All_Locations;
2064:

Line 2366: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

2362: WSH_UTIL_CORE.default_handler('WSH_REGIONS_SEARCH_PKG.Process_All_Locations');
2363: --
2364: IF l_debug_on THEN
2365: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2366: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2367: END IF;
2368:
2369: END Process_All_Locations;
2370:

Line 2426: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

2422: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2423: --
2424: IF l_debug_on THEN
2425: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2426: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2427: END IF;
2428: --
2429: END refresh_cache;
2430:

Line 3093: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

3089: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3090: --
3091: IF l_debug_on THEN
3092: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3093: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3094: --Bug 4775798
3095: ELSE
3096: WSH_UTIL_CORE.printmsg('Unexpected error has occured in Get_All_RegionId_Matches');
3097: WSH_UTIL_CORE.printmsg('Oracle error message is '|| SQLERRM);

Line 3207: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

3203: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3204: --
3205: IF l_debug_on THEN
3206: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3207: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3208: END IF;
3209: --
3210: END Get_All_Zone_Matches;
3211:

Line 3460: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3456: ----}
3457:
3458: EXCEPTION
3459:
3460: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3461: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3462: --
3463: IF l_debug_on THEN
3464: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 3465: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

3461: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3462: --
3463: IF l_debug_on THEN
3464: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3465: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3466: END IF;
3467:
3468: WHEN OTHERS THEN
3469: IF c_get_all_regions_loc%ISOPEN THEN

Line 3480: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

3476: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3477: --
3478: IF l_debug_on THEN
3479: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3480: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3481: END IF;
3482:
3483: END get_all_region_deconsols;
3484: