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_ROLES_PVT dependencies on WSH_UTIL_CORE

Line 50: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

46: IF l_debug_on THEN
47: WSH_DEBUG_SV.push(l_module_name);
48: END IF;
49: --
50: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
51:
52: OPEN c_dup_role_name;
53: FETCH c_dup_role_name INTO l_dup_id;
54: IF c_dup_role_name%NOTFOUND THEN

Line 112: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

108: --
109: EXCEPTION
110: WHEN wsh_duplicate_name THEN
111: FND_MESSAGE.Set_Name('FND', 'FORM_DUPLICATE_KEY_IN_INDEX');
112: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
113: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
114:
115: --
116: -- Debug Statements

Line 113: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

109: EXCEPTION
110: WHEN wsh_duplicate_name THEN
111: FND_MESSAGE.Set_Name('FND', 'FORM_DUPLICATE_KEY_IN_INDEX');
112: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
113: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
114:
115: --
116: -- Debug Statements
117: --

Line 124: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

120: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_DUPLICATE_NAME');
121: END IF;
122: --
123: WHEN others THEN
124: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
125: wsh_util_core.default_handler('WSH_RU_ROLES_PVT.INSERT_ROW');
126:
127: --
128: -- Debug Statements

Line 125: wsh_util_core.default_handler('WSH_RU_ROLES_PVT.INSERT_ROW');

121: END IF;
122: --
123: WHEN others THEN
124: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
125: wsh_util_core.default_handler('WSH_RU_ROLES_PVT.INSERT_ROW');
126:
127: --
128: -- Debug Statements
129: --

Line 326: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

322:
323: IF (SQL%NOTFOUND) THEN
324: RAISE NO_DATA_FOUND;
325: ELSE
326: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
327: END IF;
328:
329: --
330: -- Debug Statements

Line 339: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

335: --
336: EXCEPTION
337: WHEN wsh_duplicate_name THEN
338: FND_MESSAGE.Set_Name('FND', 'FORM_DUPLICATE_KEY_IN_INDEX');
339: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
340: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
341:
342: --
343: -- Debug Statements

Line 340: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

336: EXCEPTION
337: WHEN wsh_duplicate_name THEN
338: FND_MESSAGE.Set_Name('FND', 'FORM_DUPLICATE_KEY_IN_INDEX');
339: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
340: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
341:
342: --
343: -- Debug Statements
344: --

Line 354: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

350: WHEN others THEN
351: IF c_dup_role_name%isopen THEN
352: CLOSE c_dup_role_name;
353: END IF;
354: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
355: wsh_util_core.default_handler('WSH_RU_ROLES_PVT.UPDATE_ROW');
356:
357: --
358: -- Debug Statements

Line 355: wsh_util_core.default_handler('WSH_RU_ROLES_PVT.UPDATE_ROW');

351: IF c_dup_role_name%isopen THEN
352: CLOSE c_dup_role_name;
353: END IF;
354: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
355: wsh_util_core.default_handler('WSH_RU_ROLES_PVT.UPDATE_ROW');
356:
357: --
358: -- Debug Statements
359: --

Line 400: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

396: WHERE rowid = p_rowid;
397: IF SQL%NOTFOUND THEN
398: RAISE NO_DATA_FOUND;
399: END IF;
400: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
401:
402: --
403: -- Debug Statements
404: --

Line 411: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

407: END IF;
408: --
409: EXCEPTION
410: WHEN others THEN
411: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
412: wsh_util_core.default_handler('WSH_RU_ROLES_PVT.DELETE_ROW');
413:
414: --
415: -- Debug Statements

Line 412: wsh_util_core.default_handler('WSH_RU_ROLES_PVT.DELETE_ROW');

408: --
409: EXCEPTION
410: WHEN others THEN
411: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
412: wsh_util_core.default_handler('WSH_RU_ROLES_PVT.DELETE_ROW');
413:
414: --
415: -- Debug Statements
416: --