1: PACKAGE BODY WSH_EXCEPTIONS_GRP AS
2: /* $Header: WSHXCPGB.pls 120.4 2006/01/04 10:02:21 parkhj noship $ */
3:
4: --===================
5: -- CONSTANTS
3:
4: --===================
5: -- CONSTANTS
6: --===================
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WSH_EXCEPTIONS_GRP';
8: -- add your constants here if any
9:
10: --===================
11: -- PROCEDURES
189: IF Get_Container_Exceptions%ISOPEN THEN
190: CLOSE Get_Container_Exceptions;
191: END IF;
192:
193: wsh_util_core.default_handler('WSH_EXCEPTIONS_GRP.GET_EXCEPTIONS');
194: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
195:
196: --
197: -- Debug Statements
333: --
334: -- Debug Statements
335: --
336: IF l_debug_on THEN
337: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_EXCEPTIONS_GRP.GET_EXCEPTIONS',WSH_DEBUG_SV.C_PROC_LEVEL);
338: END IF;
339: --
340: WSH_EXCEPTIONS_GRP.Get_Exceptions (p_api_version => p_api_version,
341: p_init_msg_list => p_init_msg_list,
336: IF l_debug_on THEN
337: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_EXCEPTIONS_GRP.GET_EXCEPTIONS',WSH_DEBUG_SV.C_PROC_LEVEL);
338: END IF;
339: --
340: WSH_EXCEPTIONS_GRP.Get_Exceptions (p_api_version => p_api_version,
341: p_init_msg_list => p_init_msg_list,
342: x_return_status => x_return_status,
343: x_msg_count => x_msg_count,
344: x_msg_data => x_msg_data,
500: END IF;
501: --
502:
503: WHEN others THEN
504: wsh_util_core.default_handler('WSH_EXCEPTIONS_GRP.CHANGE_STATUS');
505: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
506: IF FND_MSG_PUB.Check_Msg_Level
507: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
508: THEN
1225: END IF;
1226: --
1227:
1228: WHEN OTHERS THEN
1229: wsh_util_core.default_handler('WSH_EXCEPTIONS_GRP.LOG_EXCEPTION');
1230: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1231: IF FND_MSG_PUB.Check_Msg_Level
1232: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1233: THEN
1822: END IF;
1823: --
1824:
1825: WHEN OTHERS THEN
1826: WSH_UTIL_CORE.default_handler('WSH_EXCEPTIONS_GRP.EXCEPTION_ACTION');
1827: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1828: IF FND_MSG_PUB.Check_Msg_Level
1829: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1830: THEN
2035: END IF;
2036: --
2037:
2038: WHEN OTHERS THEN
2039: WSH_UTIL_CORE.default_handler('WSH_EXCEPTIONS_GRP.EXCEPTION_ACTION');
2040: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2041: IF FND_MSG_PUB.Check_Msg_Level
2042: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2043: THEN
2062:
2063: END Exception_Action;
2064:
2065:
2066: END WSH_EXCEPTIONS_GRP;