APPS.WSH_RU_ROLE_PRIVILEGES_PVT dependencies on WSH_RU_ROLE_PRIVILEGES_PVT

Line 1: PACKAGE BODY WSH_RU_ROLE_PRIVILEGES_PVT AS

1: PACKAGE BODY WSH_RU_ROLE_PRIVILEGES_PVT AS
2: /* $Header: WSHRPTHB.pls 120.0 2005/05/29 14:11:46 appldev noship $ */
3:
4: --
5: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_RU_ROLE_PRIVILEGES_PVT';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_RU_ROLE_PRIVILEGES_PVT';

1: PACKAGE BODY WSH_RU_ROLE_PRIVILEGES_PVT AS
2: /* $Header: WSHRPTHB.pls 120.0 2005/05/29 14:11:46 appldev noship $ */
3:
4: --
5: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_RU_ROLE_PRIVILEGES_PVT';
6: --
7: PROCEDURE Insert_Row(
8: p_role_privilege_record IN Role_Privilege_Type,
9: x_rowid OUT NOCOPY VARCHAR2,

Line 95: wsh_util_core.default_handler('WSH_RU_ROLE_PRIVILEGES_PVT.INSERT_ROW',l_module_name);

91: --
92: EXCEPTION
93: WHEN others THEN
94: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
95: wsh_util_core.default_handler('WSH_RU_ROLE_PRIVILEGES_PVT.INSERT_ROW',l_module_name);
96: --
97: IF l_debug_on THEN
98: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
99: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 199: FND_MESSAGE.Set_Token('PACKAGE', 'WSH_RU_ROLE_PRIVILEGES_PVT.LOCK_ROW');

195: close c_lock_role_privilege;
196: end if;
197:
198: FND_MESSAGE.SET_NAME('WSH','WSH_UNEXP_ERROR');
199: FND_MESSAGE.Set_Token('PACKAGE', 'WSH_RU_ROLE_PRIVILEGES_PVT.LOCK_ROW');
200: FND_MESSAGE.Set_Token('ORA_ERROR',sqlcode);
201: FND_MESSAGE.Set_Token('ORA_TEXT',sqlerrm);
202: --
203: IF l_debug_on THEN

Line 264: wsh_util_core.default_handler('WSH_RU_ROLE_PRIVILEGES_PVT.UPDATE_ROW',l_module_name);

260: --
261: EXCEPTION
262: WHEN others THEN
263: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
264: wsh_util_core.default_handler('WSH_RU_ROLE_PRIVILEGES_PVT.UPDATE_ROW',l_module_name);
265: --
266: IF l_debug_on THEN
267: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
268: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 313: wsh_util_core.default_handler('WSH_RU_ROLE_PRIVILEGES_PVT.DELETE_ROW',l_module_name);

309: --
310: EXCEPTION
311: WHEN others THEN
312: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
313: wsh_util_core.default_handler('WSH_RU_ROLE_PRIVILEGES_PVT.DELETE_ROW',l_module_name);
314: --
315: IF l_debug_on THEN
316: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
317: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 377: wsh_util_core.default_handler('WSH_RU_ROLE_PRIVILEGES_PVT.DELETE_ROLR',l_module_name);

373: --
374: EXCEPTION
375: WHEN others THEN
376: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
377: wsh_util_core.default_handler('WSH_RU_ROLE_PRIVILEGES_PVT.DELETE_ROLR',l_module_name);
378: --
379: IF l_debug_on THEN
380: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM, WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
381: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 388: END WSH_RU_ROLE_PRIVILEGES_PVT;

384: END Delete_Role_Privileges;
385:
386:
387:
388: END WSH_RU_ROLE_PRIVILEGES_PVT;