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_DEBUG_SV

Line 60: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

56: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
57: --
58: IF l_debug_on IS NULL
59: THEN
60: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
61: END IF;
62: --
63: IF l_debug_on THEN
64: WSH_DEBUG_SV.push(l_module_name);

Line 64: WSH_DEBUG_SV.push(l_module_name);

60: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
61: END IF;
62: --
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:

Line 131: WSH_DEBUG_SV.pop(l_module_name);

127: --
128: -- Debug Statements
129: --
130: IF l_debug_on THEN
131: WSH_DEBUG_SV.pop(l_module_name);
132: END IF;
133: --
134: EXCEPTION
135: WHEN wsh_grant_overlap THEN

Line 144: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_GRANT_OVERLAP exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

140: --
141: -- Debug Statements
142: --
143: IF l_debug_on THEN
144: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_GRANT_OVERLAP exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
145: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_GRANT_OVERLAP');
146: END IF;
147: --
148: WHEN others THEN

Line 145: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_GRANT_OVERLAP');

141: -- Debug Statements
142: --
143: IF l_debug_on THEN
144: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_GRANT_OVERLAP exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
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;

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

152: --
153: -- Debug Statements
154: --
155: IF l_debug_on THEN
156: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
157: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
158: END IF;
159: --
160: END Insert_Row;

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

153: -- Debug Statements
154: --
155: IF l_debug_on THEN
156: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
157: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
158: END IF;
159: --
160: END Insert_Row;
161:

Line 189: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

185: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
186: --
187: IF l_debug_on IS NULL
188: THEN
189: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
190: END IF;
191: --
192: IF l_debug_on THEN
193: WSH_DEBUG_SV.push(l_module_name);

Line 193: WSH_DEBUG_SV.push(l_module_name);

189: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
190: END IF;
191: --
192: IF l_debug_on THEN
193: WSH_DEBUG_SV.push(l_module_name);
194: --
195: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
196: END IF;
197: --

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

191: --
192: IF l_debug_on THEN
193: WSH_DEBUG_SV.push(l_module_name);
194: --
195: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
196: END IF;
197: --
198: OPEN c_lock_grant;
199: FETCH c_lock_grant INTO l_db_rec;

Line 228: WSH_DEBUG_SV.pop(l_module_name);

224: --
225: -- Debug Statements
226: --
227: IF l_debug_on THEN
228: WSH_DEBUG_SV.pop(l_module_name);
229: END IF;
230: --
231: RETURN;
232: ELSE

Line 241: WSH_DEBUG_SV.pop(l_module_name);

237: --
238: -- Debug Statements
239: --
240: IF l_debug_on THEN
241: WSH_DEBUG_SV.pop(l_module_name);
242: END IF;
243: --
244: EXCEPTION
245: WHEN app_exception.application_exception

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

252: --
253: -- Debug Statements
254: --
255: IF l_debug_on THEN
256: WSH_DEBUG_SV.logmsg(l_module_name,'APP_EXCEPTION.APPLICATION_EXCEPTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
257: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:APP_EXCEPTION.APPLICATION_EXCEPTION');
258: END IF;
259: --
260: RAISE;

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

253: -- Debug Statements
254: --
255: IF l_debug_on THEN
256: WSH_DEBUG_SV.logmsg(l_module_name,'APP_EXCEPTION.APPLICATION_EXCEPTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
257: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:APP_EXCEPTION.APPLICATION_EXCEPTION');
258: END IF;
259: --
260: RAISE;
261:

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

273: --
274: -- Debug Statements
275: --
276: IF l_debug_on THEN
277: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
278: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
279: END IF;
280: --
281: RAISE;

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

274: -- Debug Statements
275: --
276: IF l_debug_on THEN
277: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
278: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
279: END IF;
280: --
281: RAISE;
282:

Line 287: WSH_DEBUG_SV.pop(l_module_name);

283: --
284: -- Debug Statements
285: --
286: IF l_debug_on THEN
287: WSH_DEBUG_SV.pop(l_module_name);
288: END IF;
289: --
290: END Lock_Row;
291:

Line 351: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

347: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
348: --
349: IF l_debug_on IS NULL
350: THEN
351: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
352: END IF;
353: --
354: IF l_debug_on THEN
355: WSH_DEBUG_SV.push(l_module_name);

Line 355: WSH_DEBUG_SV.push(l_module_name);

351: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
352: END IF;
353: --
354: IF l_debug_on THEN
355: WSH_DEBUG_SV.push(l_module_name);
356: --
357: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
358: END IF;
359: --

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

353: --
354: IF l_debug_on THEN
355: WSH_DEBUG_SV.push(l_module_name);
356: --
357: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
358: END IF;
359: --
360: UPDATE WSH_GRANTS
361: SET

Line 384: WSH_DEBUG_SV.pop(l_module_name);

380: --
381: -- Debug Statements
382: --
383: IF l_debug_on THEN
384: WSH_DEBUG_SV.pop(l_module_name);
385: END IF;
386: --
387: EXCEPTION
388: WHEN wsh_grant_overlap THEN

Line 397: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_GRANT_OVERLAP exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

393: --
394: -- Debug Statements
395: --
396: IF l_debug_on THEN
397: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_GRANT_OVERLAP exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
398: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_GRANT_OVERLAP');
399: END IF;
400: --
401: WHEN others THEN

Line 398: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_GRANT_OVERLAP');

394: -- Debug Statements
395: --
396: IF l_debug_on THEN
397: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_GRANT_OVERLAP exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
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;

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

405: --
406: -- Debug Statements
407: --
408: IF l_debug_on THEN
409: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
410: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
411: END IF;
412: --
413: END Update_Row;

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

406: -- Debug Statements
407: --
408: IF l_debug_on THEN
409: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
410: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
411: END IF;
412: --
413: END Update_Row;
414:

Line 434: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

430: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
431: --
432: IF l_debug_on IS NULL
433: THEN
434: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
435: END IF;
436: --
437: IF l_debug_on THEN
438: WSH_DEBUG_SV.push(l_module_name);

Line 438: WSH_DEBUG_SV.push(l_module_name);

434: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
435: END IF;
436: --
437: IF l_debug_on THEN
438: WSH_DEBUG_SV.push(l_module_name);
439: --
440: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
441: END IF;
442: --

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

436: --
437: IF l_debug_on THEN
438: WSH_DEBUG_SV.push(l_module_name);
439: --
440: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
441: END IF;
442: --
443: DELETE FROM WSH_GRANTS
444: WHERE rowid = p_rowid;

Line 454: WSH_DEBUG_SV.pop(l_module_name);

450: --
451: -- Debug Statements
452: --
453: IF l_debug_on THEN
454: WSH_DEBUG_SV.pop(l_module_name);
455: END IF;
456: --
457: EXCEPTION
458: WHEN others THEN

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

462: --
463: -- Debug Statements
464: --
465: IF l_debug_on THEN
466: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
467: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
468: END IF;
469: --
470: END Delete_Row;

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

463: -- Debug Statements
464: --
465: IF l_debug_on THEN
466: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
467: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
468: END IF;
469: --
470: END Delete_Row;
471: