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 1713: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

1709: WSH_UTIL_CORE.default_handler('WSH_REGIONS_SEARCH_PKG.Get_Child_Requests_Status');
1710: --
1711: IF l_debug_on THEN
1712: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1713: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1714: END IF;
1715:
1716: END Get_Child_Requests_Status;
1717:

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

1786: WSH_UTIL_CORE.default_handler('WSH_REGIONS_SEARCH_PKG.Process_All_Locations');
1787: --
1788: IF l_debug_on THEN
1789: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1790: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1791: END IF;
1792:
1793: END Process_All_Locations;
1794:

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

2092: WSH_UTIL_CORE.default_handler('WSH_REGIONS_SEARCH_PKG.Process_All_Locations');
2093: --
2094: IF l_debug_on THEN
2095: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2096: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2097: END IF;
2098:
2099: END Process_All_Locations;
2100:

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

2152: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2153: --
2154: IF l_debug_on THEN
2155: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2156: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2157: END IF;
2158: --
2159: END refresh_cache;
2160:

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

2818: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2819: --
2820: IF l_debug_on THEN
2821: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2822: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2823: --Bug 4775798
2824: ELSE
2825: WSH_UTIL_CORE.printmsg('Unexpected error has occured in Get_All_RegionId_Matches');
2826: WSH_UTIL_CORE.printmsg('Oracle error message is '|| SQLERRM);

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

2932: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2933: --
2934: IF l_debug_on THEN
2935: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2936: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2937: END IF;
2938: --
2939: END Get_All_Zone_Matches;
2940:

Line 3189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3185: ----}
3186:
3187: EXCEPTION
3188:
3189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3190: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3191: --
3192: IF l_debug_on THEN
3193: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

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

3190: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3191: --
3192: IF l_debug_on THEN
3193: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3194: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3195: END IF;
3196:
3197: WHEN OTHERS THEN
3198: IF c_get_all_regions_loc%ISOPEN THEN

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

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