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_DEBUG_SV

Line 34: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

30: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
31: --
32: IF l_debug_on IS NULL
33: THEN
34: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
35: END IF;
36: --
37: IF l_debug_on THEN
38: WSH_DEBUG_SV.push(l_module_name);

Line 38: WSH_DEBUG_SV.push(l_module_name);

34: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
35: END IF;
36: --
37: IF l_debug_on THEN
38: WSH_DEBUG_SV.push(l_module_name);
39: WSH_DEBUG_SV.log(l_module_name,'role_privilege_id',
40: p_role_privilege_record.role_privilege_id);
41: END IF;
42: --

Line 39: WSH_DEBUG_SV.log(l_module_name,'role_privilege_id',

35: END IF;
36: --
37: IF l_debug_on THEN
38: WSH_DEBUG_SV.push(l_module_name);
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;

Line 52: WSH_DEBUG_SV.log(l_module_name,'l_role_privilege_id',l_role_privilege_id)

48: OPEN c_new_role_privilege_id;
49: FETCH c_new_role_privilege_id INTO l_role_privilege_id;
50: CLOSE c_new_role_privilege_id;
51: IF l_debug_on THEN
52: WSH_DEBUG_SV.log(l_module_name,'l_role_privilege_id',l_role_privilege_id)
53: ;
54: END IF;
55: END IF;
56:

Line 89: WSH_DEBUG_SV.pop(l_module_name);

85: x_rowid := l_rowid;
86: x_role_privilege_id := l_role_privilege_id;
87: --
88: IF l_debug_on THEN
89: WSH_DEBUG_SV.pop(l_module_name);
90: END IF;
91: --
92: EXCEPTION
93: WHEN others THEN

Line 98: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

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');
100: END IF;
101: --
102: END Insert_Row;

Line 99: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

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');
100: END IF;
101: --
102: END Insert_Row;
103:

Line 128: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

124: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
125: --
126: IF l_debug_on IS NULL
127: THEN
128: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
129: END IF;
130: --
131: IF l_debug_on THEN
132: WSH_DEBUG_SV.push(l_module_name);

Line 132: WSH_DEBUG_SV.push(l_module_name);

128: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
129: END IF;
130: --
131: IF l_debug_on THEN
132: WSH_DEBUG_SV.push(l_module_name);
133: --
134: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
135: END IF;
136: --

Line 134: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);

130: --
131: IF l_debug_on THEN
132: WSH_DEBUG_SV.push(l_module_name);
133: --
134: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
135: END IF;
136: --
137: OPEN c_lock_role_privilege;
138: FETCH c_lock_role_privilege INTO l_db_rec;

Line 143: WSH_DEBUG_SV.log(l_module_name,'FORM_RECORD_DELETED');

139: IF c_lock_role_privilege%NOTFOUND THEN
140: CLOSE c_lock_role_privilege;
141: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
142: IF l_debug_on THEN
143: WSH_DEBUG_SV.log(l_module_name,'FORM_RECORD_DELETED');
144: END IF;
145: app_exception.raise_exception;
146: END IF;
147: CLOSE c_lock_role_privilege;

Line 161: WSH_DEBUG_SV.pop(l_module_name,'Noting Changed');

157: AND p_role_privilege_record.LAST_UPDATE_LOGIN IS NULL))
158: THEN
159: --
160: IF l_debug_on THEN
161: WSH_DEBUG_SV.pop(l_module_name,'Noting Changed');
162: END IF;
163: --
164: RETURN;
165: ELSE

Line 168: WSH_DEBUG_SV.log(l_module_name,'FORM_RECORD_CHANGED');

164: RETURN;
165: ELSE
166: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
167: IF l_debug_on THEN
168: WSH_DEBUG_SV.log(l_module_name,'FORM_RECORD_CHANGED');
169: END IF;
170: app_exception.raise_exception;
171: END IF;
172: --

Line 174: WSH_DEBUG_SV.pop(l_module_name);

170: app_exception.raise_exception;
171: END IF;
172: --
173: IF l_debug_on THEN
174: WSH_DEBUG_SV.pop(l_module_name);
175: END IF;
176: --
177: EXCEPTION
178: WHEN app_exception.application_exception

Line 186: WSH_DEBUG_SV.logmsg(l_module_name,'APP_EXCEPTION.APPLICATION_EXCEPTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

182: close c_lock_role_privilege;
183: end if;
184: --
185: IF l_debug_on THEN
186: WSH_DEBUG_SV.logmsg(l_module_name,'APP_EXCEPTION.APPLICATION_EXCEPTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
187: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:APP_EXCEPTION.APPLICATION_EXCEPTION');
188: END IF;
189: --
190: RAISE;

Line 187: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:APP_EXCEPTION.APPLICATION_EXCEPTION');

183: end if;
184: --
185: IF l_debug_on THEN
186: WSH_DEBUG_SV.logmsg(l_module_name,'APP_EXCEPTION.APPLICATION_EXCEPTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
187: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:APP_EXCEPTION.APPLICATION_EXCEPTION');
188: END IF;
189: --
190: RAISE;
191:

Line 204: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

200: FND_MESSAGE.Set_Token('ORA_ERROR',sqlcode);
201: FND_MESSAGE.Set_Token('ORA_TEXT',sqlerrm);
202: --
203: IF l_debug_on THEN
204: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
205: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
206: END IF;
207: --
208: RAISE;

Line 205: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

201: FND_MESSAGE.Set_Token('ORA_TEXT',sqlerrm);
202: --
203: IF l_debug_on THEN
204: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
205: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
206: END IF;
207: --
208: RAISE;
209: END Lock_Row;

Line 228: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

224: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
225: --
226: IF l_debug_on IS NULL
227: THEN
228: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
229: END IF;
230: --
231: IF l_debug_on THEN
232: WSH_DEBUG_SV.push(l_module_name);

Line 232: WSH_DEBUG_SV.push(l_module_name);

228: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
229: END IF;
230: --
231: IF l_debug_on THEN
232: WSH_DEBUG_SV.push(l_module_name);
233: --
234: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
235: END IF;
236: --

Line 234: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);

230: --
231: IF l_debug_on THEN
232: WSH_DEBUG_SV.push(l_module_name);
233: --
234: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
235: END IF;
236: --
237: UPDATE WSH_ROLE_PRIVILEGES
238: SET

Line 249: WSH_DEBUG_SV.log(l_module_name,'Rows Updated',SQL%ROWCOUNT);

245: LAST_UPDATE_LOGIN = p_role_privilege_record.LAST_UPDATE_LOGIN
246: WHERE rowid = p_rowid;
247:
248: IF l_debug_on THEN
249: WSH_DEBUG_SV.log(l_module_name,'Rows Updated',SQL%ROWCOUNT);
250: END IF;
251: IF (SQL%NOTFOUND) THEN
252: RAISE NO_DATA_FOUND;
253: ELSE

Line 258: WSH_DEBUG_SV.pop(l_module_name);

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);
259: END IF;
260: --
261: EXCEPTION
262: WHEN others THEN

Line 267: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

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');
269: END IF;
270: --
271: END Update_Row;

Line 268: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

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');
269: END IF;
270: --
271: END Update_Row;
272:

Line 289: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

285: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
286: --
287: IF l_debug_on IS NULL
288: THEN
289: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
290: END IF;
291: --
292: IF l_debug_on THEN
293: WSH_DEBUG_SV.push(l_module_name);

Line 293: WSH_DEBUG_SV.push(l_module_name);

289: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
290: END IF;
291: --
292: IF l_debug_on THEN
293: WSH_DEBUG_SV.push(l_module_name);
294: --
295: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
296: END IF;
297: --

Line 295: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);

291: --
292: IF l_debug_on THEN
293: WSH_DEBUG_SV.push(l_module_name);
294: --
295: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
296: END IF;
297: --
298: DELETE FROM WSH_ROLE_PRIVILEGES
299: WHERE rowid = p_rowid;

Line 306: WSH_DEBUG_SV.log(l_module_name,'Rows Deleted',SQL%ROWCOUNT);

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

Line 307: WSH_DEBUG_SV.pop(l_module_name);

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);
308: END IF;
309: --
310: EXCEPTION
311: WHEN others THEN

Line 316: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

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');
318: END IF;
319: --
320: END Delete_Row;

Line 317: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

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');
318: END IF;
319: --
320: END Delete_Row;
321:

Line 347: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

343: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
344: --
345: IF l_debug_on IS NULL
346: THEN
347: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
348: END IF;
349: --
350: IF l_debug_on THEN
351: WSH_DEBUG_SV.push(l_module_name);

Line 351: WSH_DEBUG_SV.push(l_module_name);

347: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
348: END IF;
349: --
350: IF l_debug_on THEN
351: WSH_DEBUG_SV.push(l_module_name);
352: --
353: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_ID',P_ROLE_ID);
354: END IF;
355: --

Line 353: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_ID',P_ROLE_ID);

349: --
350: IF l_debug_on THEN
351: WSH_DEBUG_SV.push(l_module_name);
352: --
353: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_ID',P_ROLE_ID);
354: END IF;
355: --
356: DELETE FROM WSH_ROLE_PRIVILEGES
357: WHERE role_id = p_role_id

Line 370: WSH_DEBUG_SV.log(l_module_name,'Rows Deleted',SQL%ROWCOUNT);

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

Line 371: WSH_DEBUG_SV.pop(l_module_name);

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);
372: END IF;
373: --
374: EXCEPTION
375: WHEN others THEN

Line 380: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM, WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

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');
382: END IF;
383: --
384: END Delete_Role_Privileges;

Line 381: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

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');
382: END IF;
383: --
384: END Delete_Role_Privileges;
385: