eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_RU_ROLE_PRIVILEGES_PVT dependencies on WSH_UTIL_CORE

Line 43: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

39: WSH_DEBUG_SV.log(l_module_name,'role_privilege_id',
40: p_role_privilege_record.role_privilege_id);
41: END IF;
42: --
43: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
44:
45: l_role_privilege_id := p_role_privilege_record.role_privilege_id;
46:
47: IF l_role_privilege_id IS NULL THEN

Line 94: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

90: END IF;
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);

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 254: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

250: END IF;
251: IF (SQL%NOTFOUND) THEN
252: RAISE NO_DATA_FOUND;
253: ELSE
254: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
255: END IF;
256: --
257: IF l_debug_on THEN
258: WSH_DEBUG_SV.pop(l_module_name);

Line 263: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

259: END IF;
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);

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 303: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

299: WHERE rowid = p_rowid;
300: IF SQL%NOTFOUND THEN
301: RAISE NO_DATA_FOUND;
302: END IF;
303: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
304: --
305: IF l_debug_on THEN
306: WSH_DEBUG_SV.log(l_module_name,'Rows Deleted',SQL%ROWCOUNT);
307: WSH_DEBUG_SV.pop(l_module_name);

Line 312: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

308: END IF;
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);

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 367: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

363: 'GENR_VIEW','GENR_EDIT'); -- Added AND condition for R12
364: IF SQL%NOTFOUND THEN
365: RAISE NO_DATA_FOUND;
366: END IF;
367: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
368: --
369: IF l_debug_on THEN
370: WSH_DEBUG_SV.log(l_module_name,'Rows Deleted',SQL%ROWCOUNT);
371: WSH_DEBUG_SV.pop(l_module_name);

Line 376: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

372: END IF;
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);

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');