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

Line 67: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

63: IF l_debug_on THEN
64: WSH_DEBUG_SV.push(l_module_name);
65: END IF;
66: --
67: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
68:
69: -- FGS does not care whether grants overlap. Simply take the
70: -- union of their organizations
71: -- OPEN c_grant_overlap;

Line 137: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

133: --
134: EXCEPTION
135: WHEN wsh_grant_overlap THEN
136: FND_MESSAGE.Set_Name('WSH', 'WSH_RU_GRANTS_OVERLAP');
137: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
138: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
139:
140: --
141: -- Debug Statements

Line 138: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

134: EXCEPTION
135: WHEN wsh_grant_overlap THEN
136: FND_MESSAGE.Set_Name('WSH', 'WSH_RU_GRANTS_OVERLAP');
137: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
138: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
139:
140: --
141: -- Debug Statements
142: --

Line 149: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

145: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_GRANT_OVERLAP');
146: END IF;
147: --
148: WHEN others THEN
149: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
150: wsh_util_core.default_handler('WSH_RU_GRANTS_PVT.INSERT_ROW');
151:
152: --
153: -- Debug Statements

Line 150: wsh_util_core.default_handler('WSH_RU_GRANTS_PVT.INSERT_ROW');

146: END IF;
147: --
148: WHEN others THEN
149: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
150: wsh_util_core.default_handler('WSH_RU_GRANTS_PVT.INSERT_ROW');
151:
152: --
153: -- Debug Statements
154: --

Line 377: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

373:
374: IF (SQL%NOTFOUND) THEN
375: RAISE NO_DATA_FOUND;
376: ELSE
377: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
378: END IF;
379:
380: --
381: -- Debug Statements

Line 390: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

386: --
387: EXCEPTION
388: WHEN wsh_grant_overlap THEN
389: FND_MESSAGE.Set_Name('WSH', 'WSH_RU_GRANTS_OVERLAP_UPDATE');
390: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
391: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
392:
393: --
394: -- Debug Statements

Line 391: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

387: EXCEPTION
388: WHEN wsh_grant_overlap THEN
389: FND_MESSAGE.Set_Name('WSH', 'WSH_RU_GRANTS_OVERLAP_UPDATE');
390: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
391: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
392:
393: --
394: -- Debug Statements
395: --

Line 402: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

398: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_GRANT_OVERLAP');
399: END IF;
400: --
401: WHEN others THEN
402: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
403: wsh_util_core.default_handler('WSH_RU_GRANTS_PVT.UPDATE_ROW');
404:
405: --
406: -- Debug Statements

Line 403: wsh_util_core.default_handler('WSH_RU_GRANTS_PVT.UPDATE_ROW');

399: END IF;
400: --
401: WHEN others THEN
402: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
403: wsh_util_core.default_handler('WSH_RU_GRANTS_PVT.UPDATE_ROW');
404:
405: --
406: -- Debug Statements
407: --

Line 448: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

444: WHERE rowid = p_rowid;
445: IF SQL%NOTFOUND THEN
446: RAISE NO_DATA_FOUND;
447: END IF;
448: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
449:
450: --
451: -- Debug Statements
452: --

Line 459: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

455: END IF;
456: --
457: EXCEPTION
458: WHEN others THEN
459: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
460: wsh_util_core.default_handler('WSH_RU_GRANTS_PVT.DELETE_ROW');
461:
462: --
463: -- Debug Statements

Line 460: wsh_util_core.default_handler('WSH_RU_GRANTS_PVT.DELETE_ROW');

456: --
457: EXCEPTION
458: WHEN others THEN
459: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
460: wsh_util_core.default_handler('WSH_RU_GRANTS_PVT.DELETE_ROW');
461:
462: --
463: -- Debug Statements
464: --