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_ACTIONS dependencies on WSH_DEBUG_SV

Line 36: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

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

Line 40: WSH_DEBUG_SV.push(l_module_name);

36: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
37: END IF;
38: --
39: IF l_debug_on THEN
40: WSH_DEBUG_SV.push(l_module_name);
41: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.ROLE_ID',p_role_def_record.ROLE_ID);
42: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.NAME',p_role_def_record.NAME);
43: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.DESCRIPTION',p_role_def_record.DESCRIPTION);
44: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.CREATED_BY',p_role_def_record.CREATED_BY);

Line 41: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.ROLE_ID',p_role_def_record.ROLE_ID);

37: END IF;
38: --
39: IF l_debug_on THEN
40: WSH_DEBUG_SV.push(l_module_name);
41: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.ROLE_ID',p_role_def_record.ROLE_ID);
42: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.NAME',p_role_def_record.NAME);
43: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.DESCRIPTION',p_role_def_record.DESCRIPTION);
44: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.CREATED_BY',p_role_def_record.CREATED_BY);
45: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.CREATION_DATE',p_role_def_record.CREATION_DATE);

Line 42: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.NAME',p_role_def_record.NAME);

38: --
39: IF l_debug_on THEN
40: WSH_DEBUG_SV.push(l_module_name);
41: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.ROLE_ID',p_role_def_record.ROLE_ID);
42: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.NAME',p_role_def_record.NAME);
43: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.DESCRIPTION',p_role_def_record.DESCRIPTION);
44: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.CREATED_BY',p_role_def_record.CREATED_BY);
45: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.CREATION_DATE',p_role_def_record.CREATION_DATE);
46: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.LAST_UPDATED_BY',p_role_def_record.LAST_UPDATED_BY);

Line 43: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.DESCRIPTION',p_role_def_record.DESCRIPTION);

39: IF l_debug_on THEN
40: WSH_DEBUG_SV.push(l_module_name);
41: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.ROLE_ID',p_role_def_record.ROLE_ID);
42: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.NAME',p_role_def_record.NAME);
43: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.DESCRIPTION',p_role_def_record.DESCRIPTION);
44: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.CREATED_BY',p_role_def_record.CREATED_BY);
45: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.CREATION_DATE',p_role_def_record.CREATION_DATE);
46: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.LAST_UPDATED_BY',p_role_def_record.LAST_UPDATED_BY);
47: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.LAST_UPDATE_DATE',p_role_def_record.LAST_UPDATE_DATE);

Line 44: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.CREATED_BY',p_role_def_record.CREATED_BY);

40: WSH_DEBUG_SV.push(l_module_name);
41: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.ROLE_ID',p_role_def_record.ROLE_ID);
42: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.NAME',p_role_def_record.NAME);
43: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.DESCRIPTION',p_role_def_record.DESCRIPTION);
44: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.CREATED_BY',p_role_def_record.CREATED_BY);
45: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.CREATION_DATE',p_role_def_record.CREATION_DATE);
46: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.LAST_UPDATED_BY',p_role_def_record.LAST_UPDATED_BY);
47: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.LAST_UPDATE_DATE',p_role_def_record.LAST_UPDATE_DATE);
48: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.LAST_UPDATE_LOGIN',p_role_def_record.LAST_UPDATE_LOGIN);

Line 45: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.CREATION_DATE',p_role_def_record.CREATION_DATE);

41: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.ROLE_ID',p_role_def_record.ROLE_ID);
42: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.NAME',p_role_def_record.NAME);
43: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.DESCRIPTION',p_role_def_record.DESCRIPTION);
44: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.CREATED_BY',p_role_def_record.CREATED_BY);
45: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.CREATION_DATE',p_role_def_record.CREATION_DATE);
46: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.LAST_UPDATED_BY',p_role_def_record.LAST_UPDATED_BY);
47: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.LAST_UPDATE_DATE',p_role_def_record.LAST_UPDATE_DATE);
48: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.LAST_UPDATE_LOGIN',p_role_def_record.LAST_UPDATE_LOGIN);
49: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.PRIVILEGES_COUNT',p_role_def_record.PRIVILEGES.COUNT);

Line 46: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.LAST_UPDATED_BY',p_role_def_record.LAST_UPDATED_BY);

42: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.NAME',p_role_def_record.NAME);
43: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.DESCRIPTION',p_role_def_record.DESCRIPTION);
44: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.CREATED_BY',p_role_def_record.CREATED_BY);
45: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.CREATION_DATE',p_role_def_record.CREATION_DATE);
46: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.LAST_UPDATED_BY',p_role_def_record.LAST_UPDATED_BY);
47: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.LAST_UPDATE_DATE',p_role_def_record.LAST_UPDATE_DATE);
48: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.LAST_UPDATE_LOGIN',p_role_def_record.LAST_UPDATE_LOGIN);
49: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.PRIVILEGES_COUNT',p_role_def_record.PRIVILEGES.COUNT);
50: END IF;

Line 47: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.LAST_UPDATE_DATE',p_role_def_record.LAST_UPDATE_DATE);

43: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.DESCRIPTION',p_role_def_record.DESCRIPTION);
44: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.CREATED_BY',p_role_def_record.CREATED_BY);
45: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.CREATION_DATE',p_role_def_record.CREATION_DATE);
46: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.LAST_UPDATED_BY',p_role_def_record.LAST_UPDATED_BY);
47: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.LAST_UPDATE_DATE',p_role_def_record.LAST_UPDATE_DATE);
48: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.LAST_UPDATE_LOGIN',p_role_def_record.LAST_UPDATE_LOGIN);
49: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.PRIVILEGES_COUNT',p_role_def_record.PRIVILEGES.COUNT);
50: END IF;
51: --

Line 48: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.LAST_UPDATE_LOGIN',p_role_def_record.LAST_UPDATE_LOGIN);

44: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.CREATED_BY',p_role_def_record.CREATED_BY);
45: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.CREATION_DATE',p_role_def_record.CREATION_DATE);
46: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.LAST_UPDATED_BY',p_role_def_record.LAST_UPDATED_BY);
47: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.LAST_UPDATE_DATE',p_role_def_record.LAST_UPDATE_DATE);
48: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.LAST_UPDATE_LOGIN',p_role_def_record.LAST_UPDATE_LOGIN);
49: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.PRIVILEGES_COUNT',p_role_def_record.PRIVILEGES.COUNT);
50: END IF;
51: --
52: savepoint before_role_definition;

Line 49: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.PRIVILEGES_COUNT',p_role_def_record.PRIVILEGES.COUNT);

45: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.CREATION_DATE',p_role_def_record.CREATION_DATE);
46: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.LAST_UPDATED_BY',p_role_def_record.LAST_UPDATED_BY);
47: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.LAST_UPDATE_DATE',p_role_def_record.LAST_UPDATE_DATE);
48: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.LAST_UPDATE_LOGIN',p_role_def_record.LAST_UPDATE_LOGIN);
49: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.PRIVILEGES_COUNT',p_role_def_record.PRIVILEGES.COUNT);
50: END IF;
51: --
52: savepoint before_role_definition;
53:

Line 67: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_RU_ROLES_PVT.INSERT_ROW',WSH_DEBUG_SV.C_PROC_LEVEL);

63: --
64: -- Debug Statements
65: --
66: IF l_debug_on THEN
67: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_RU_ROLES_PVT.INSERT_ROW',WSH_DEBUG_SV.C_PROC_LEVEL);
68: END IF;
69: --
70: WSH_RU_ROLES_PVT.Insert_Row(
71: p_role_record => l_role,

Line 83: WSH_DEBUG_SV.pop(l_module_name);

79: --
80: -- Debug Statements
81: --
82: IF l_debug_on THEN
83: WSH_DEBUG_SV.pop(l_module_name);
84: END IF;
85: --
86: return;
87: END IF;

Line 93: WSH_DEBUG_SV.log(l_module_name,'X_ROLE_ID',x_role_id);

89: x_role_id := l_role_id;
90: -- Debug Statements
91: --
92: IF l_debug_on THEN
93: WSH_DEBUG_SV.log(l_module_name,'X_ROLE_ID',x_role_id);
94: END IF;
95: --
96:
97: l_privilege.ROLE_PRIVILEGE_ID := NULL;

Line 114: WSH_DEBUG_SV.log(l_module_name,'PRIVILEGE_CODE',l_privilege.PRIVILEGE_CODE);

110: --
111: -- Debug Statements
112: --
113: IF l_debug_on THEN
114: WSH_DEBUG_SV.log(l_module_name,'PRIVILEGE_CODE',l_privilege.PRIVILEGE_CODE);
115: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_RU_ROLE_PRIVILEGES_PVT.INSERT_ROW',WSH_DEBUG_SV.C_PROC_LEVEL);
116: END IF;
117: --
118: WSH_RU_ROLE_PRIVILEGES_PVT.Insert_Row(

Line 115: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_RU_ROLE_PRIVILEGES_PVT.INSERT_ROW',WSH_DEBUG_SV.C_PROC_LEVEL);

111: -- Debug Statements
112: --
113: IF l_debug_on THEN
114: WSH_DEBUG_SV.log(l_module_name,'PRIVILEGE_CODE',l_privilege.PRIVILEGE_CODE);
115: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_RU_ROLE_PRIVILEGES_PVT.INSERT_ROW',WSH_DEBUG_SV.C_PROC_LEVEL);
116: END IF;
117: --
118: WSH_RU_ROLE_PRIVILEGES_PVT.Insert_Row(
119: p_role_privilege_record => l_privilege,

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: return;
135: END IF;

Line 145: WSH_DEBUG_SV.pop(l_module_name);

141: --
142: -- Debug Statements
143: --
144: IF l_debug_on THEN
145: WSH_DEBUG_SV.pop(l_module_name);
146: END IF;
147: --
148: END Create_Role_Definition;
149:

Line 169: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

165: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
166: --
167: IF l_debug_on IS NULL
168: THEN
169: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
170: END IF;
171: --
172: IF l_debug_on THEN
173: WSH_DEBUG_SV.push(l_module_name);

Line 173: WSH_DEBUG_SV.push(l_module_name);

169: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
170: END IF;
171: --
172: IF l_debug_on THEN
173: WSH_DEBUG_SV.push(l_module_name);
174: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.ROLE_ID',p_role_def_record.ROLE_ID);
175: END IF;
176:
177: l_role.ROLE_ID := p_role_def_record.ROLE_ID;

Line 174: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.ROLE_ID',p_role_def_record.ROLE_ID);

170: END IF;
171: --
172: IF l_debug_on THEN
173: WSH_DEBUG_SV.push(l_module_name);
174: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.ROLE_ID',p_role_def_record.ROLE_ID);
175: END IF;
176:
177: l_role.ROLE_ID := p_role_def_record.ROLE_ID;
178: l_role.NAME := p_role_def_record.NAME;

Line 196: WSH_DEBUG_SV.pop(l_module_name);

192: --
193: -- Debug Statements
194: --
195: IF l_debug_on THEN
196: WSH_DEBUG_SV.pop(l_module_name);
197: END IF;
198: --
199: END Lock_Role_Definition;
200:

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: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.ROLE_ID',p_role_def_record.ROLE_ID);
234: END IF;
235:
236: savepoint before_role_definition;

Line 233: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.ROLE_ID',p_role_def_record.ROLE_ID);

229: END IF;
230: --
231: IF l_debug_on THEN
232: WSH_DEBUG_SV.push(l_module_name);
233: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.ROLE_ID',p_role_def_record.ROLE_ID);
234: END IF;
235:
236: savepoint before_role_definition;
237:

Line 251: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_RU_ROLES_PVT.INSERT_ROW',WSH_DEBUG_SV.C_PROC_LEVEL);

247: --
248: -- Debug Statements
249: --
250: IF l_debug_on THEN
251: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_RU_ROLES_PVT.INSERT_ROW',WSH_DEBUG_SV.C_PROC_LEVEL);
252: END IF;
253: --
254: WSH_RU_ROLES_PVT.Update_Row(
255: p_role_record => l_role,

Line 266: WSH_DEBUG_SV.pop(l_module_name);

262: --
263: -- Debug Statements
264: --
265: IF l_debug_on THEN
266: WSH_DEBUG_SV.pop(l_module_name);
267: END IF;
268: --
269: return;
270: END IF;

Line 283: WSH_DEBUG_SV.pop(l_module_name);

279: --
280: -- Debug Statements
281: --
282: IF l_debug_on THEN
283: WSH_DEBUG_SV.pop(l_module_name);
284: END IF;
285: --
286: return;
287: END IF;

Line 306: WSH_DEBUG_SV.log(l_module_name,'PRIVILEGE_CODE',l_privilege.PRIVILEGE_CODE);

302: --
303: -- Debug Statements
304: --
305: IF l_debug_on THEN
306: WSH_DEBUG_SV.log(l_module_name,'PRIVILEGE_CODE',l_privilege.PRIVILEGE_CODE);
307: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_RU_ROLE_PRIVILEGES_PVT.INSERT_ROW',WSH_DEBUG_SV.C_PROC_LEVEL);
308: END IF;
309: --
310: WSH_RU_ROLE_PRIVILEGES_PVT.Insert_Row(

Line 307: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_RU_ROLE_PRIVILEGES_PVT.INSERT_ROW',WSH_DEBUG_SV.C_PROC_LEVEL);

303: -- Debug Statements
304: --
305: IF l_debug_on THEN
306: WSH_DEBUG_SV.log(l_module_name,'PRIVILEGE_CODE',l_privilege.PRIVILEGE_CODE);
307: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_RU_ROLE_PRIVILEGES_PVT.INSERT_ROW',WSH_DEBUG_SV.C_PROC_LEVEL);
308: END IF;
309: --
310: WSH_RU_ROLE_PRIVILEGES_PVT.Insert_Row(
311: p_role_privilege_record => l_privilege,

Line 323: WSH_DEBUG_SV.pop(l_module_name);

319: --
320: -- Debug Statements
321: --
322: IF l_debug_on THEN
323: WSH_DEBUG_SV.pop(l_module_name);
324: END IF;
325: --
326: return;
327: END IF;

Line 336: WSH_DEBUG_SV.pop(l_module_name);

332: --
333: p_role_def_record.LAST_UPDATE_DATE := l_role.LAST_UPDATE_DATE;
334:
335: IF l_debug_on THEN
336: WSH_DEBUG_SV.pop(l_module_name);
337: END IF;
338: --
339: END Update_Role_Definition;
340:

Line 359: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

355: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
356: --
357: IF l_debug_on IS NULL
358: THEN
359: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
360: END IF;
361: --
362: IF l_debug_on THEN
363: WSH_DEBUG_SV.push(l_module_name);

Line 363: WSH_DEBUG_SV.push(l_module_name);

359: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
360: END IF;
361: --
362: IF l_debug_on THEN
363: WSH_DEBUG_SV.push(l_module_name);
364: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.ROLE_ID',p_role_def_record.ROLE_ID);
365: END IF;
366: --
367: FND_MESSAGE.SET_NAME('WSH', 'NOT_IMPLEMENTED');

Line 364: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.ROLE_ID',p_role_def_record.ROLE_ID);

360: END IF;
361: --
362: IF l_debug_on THEN
363: WSH_DEBUG_SV.push(l_module_name);
364: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.ROLE_ID',p_role_def_record.ROLE_ID);
365: END IF;
366: --
367: FND_MESSAGE.SET_NAME('WSH', 'NOT_IMPLEMENTED');
368: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 373: WSH_DEBUG_SV.pop(l_module_name);

369: --
370: -- Debug Statements
371: --
372: IF l_debug_on THEN
373: WSH_DEBUG_SV.pop(l_module_name);
374: END IF;
375: --
376: END Delete_Role_Definition;
377:

Line 411: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

407: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
408: --
409: IF l_debug_on IS NULL
410: THEN
411: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
412: END IF;
413: --
414: IF l_debug_on THEN
415: WSH_DEBUG_SV.push(l_module_name);

Line 415: WSH_DEBUG_SV.push(l_module_name);

411: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
412: END IF;
413: --
414: IF l_debug_on THEN
415: WSH_DEBUG_SV.push(l_module_name);
416: --
417: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
418: END IF;
419: --

Line 417: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);

413: --
414: IF l_debug_on THEN
415: WSH_DEBUG_SV.push(l_module_name);
416: --
417: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
418: END IF;
419: --
420: FOR p IN c_privileges(p_organization_id, fnd_profile.value('USER_ID')) LOOP
421: i:=i+1; x_privileges(i) := p.privilege_code;

Line 429: WSH_DEBUG_SV.log(l_module_name,'X_PRIVILEGES.COUNT',X_PRIVILEGES.COUNT);

425: --
426: -- Debug Statements
427: --
428: IF l_debug_on THEN
429: WSH_DEBUG_SV.log(l_module_name,'X_PRIVILEGES.COUNT',X_PRIVILEGES.COUNT);
430: WSH_DEBUG_SV.pop(l_module_name);
431: END IF;
432: --
433: EXCEPTION

Line 430: WSH_DEBUG_SV.pop(l_module_name);

426: -- Debug Statements
427: --
428: IF l_debug_on THEN
429: WSH_DEBUG_SV.log(l_module_name,'X_PRIVILEGES.COUNT',X_PRIVILEGES.COUNT);
430: WSH_DEBUG_SV.pop(l_module_name);
431: END IF;
432: --
433: EXCEPTION
434: WHEN others THEN

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

438: --
439: -- Debug Statements
440: --
441: IF l_debug_on THEN
442: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
443: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
444: END IF;
445: --
446: END Get_Organization_Privileges;

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

439: -- Debug Statements
440: --
441: IF l_debug_on THEN
442: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
443: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
444: END IF;
445: --
446: END Get_Organization_Privileges;
447:

Line 488: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

484: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
485: --
486: IF l_debug_on IS NULL
487: THEN
488: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
489: END IF;
490: --
491: IF l_debug_on THEN
492: WSH_DEBUG_SV.push(l_module_name);

Line 492: WSH_DEBUG_SV.push(l_module_name);

488: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
489: END IF;
490: --
491: IF l_debug_on THEN
492: WSH_DEBUG_SV.push(l_module_name);
493: --
494: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_TYPE',P_ENTITY_TYPE);
495: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
496: END IF;

Line 494: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_TYPE',P_ENTITY_TYPE);

490: --
491: IF l_debug_on THEN
492: WSH_DEBUG_SV.push(l_module_name);
493: --
494: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_TYPE',P_ENTITY_TYPE);
495: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
496: END IF;
497: --
498: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 495: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);

491: IF l_debug_on THEN
492: WSH_DEBUG_SV.push(l_module_name);
493: --
494: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_TYPE',P_ENTITY_TYPE);
495: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
496: END IF;
497: --
498: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
499:

Line 535: WSH_DEBUG_SV.log(l_module_name,'X_ACCESS_TYPE',X_ACCESS_TYPE);

531: --
532: -- Debug Statements
533: --
534: IF l_debug_on THEN
535: WSH_DEBUG_SV.log(l_module_name,'X_ACCESS_TYPE',X_ACCESS_TYPE);
536: WSH_DEBUG_SV.pop(l_module_name);
537: END IF;
538: --
539: return;

Line 536: WSH_DEBUG_SV.pop(l_module_name);

532: -- Debug Statements
533: --
534: IF l_debug_on THEN
535: WSH_DEBUG_SV.log(l_module_name,'X_ACCESS_TYPE',X_ACCESS_TYPE);
536: WSH_DEBUG_SV.pop(l_module_name);
537: END IF;
538: --
539: return;
540: END IF;

Line 555: WSH_DEBUG_SV.log(l_module_name,'X_ACCESS_TYPE',X_ACCESS_TYPE);

551: --
552: -- Debug Statements
553: --
554: IF l_debug_on THEN
555: WSH_DEBUG_SV.log(l_module_name,'X_ACCESS_TYPE',X_ACCESS_TYPE);
556: WSH_DEBUG_SV.pop(l_module_name);
557: END IF;
558: --
559: return;

Line 556: WSH_DEBUG_SV.pop(l_module_name);

552: -- Debug Statements
553: --
554: IF l_debug_on THEN
555: WSH_DEBUG_SV.log(l_module_name,'X_ACCESS_TYPE',X_ACCESS_TYPE);
556: WSH_DEBUG_SV.pop(l_module_name);
557: END IF;
558: --
559: return;
560: END IF;

Line 568: WSH_DEBUG_SV.log(l_module_name,'X_ACCESS_TYPE',X_ACCESS_TYPE);

564: --
565: -- Debug Statements
566: --
567: IF l_debug_on THEN
568: WSH_DEBUG_SV.log(l_module_name,'X_ACCESS_TYPE',X_ACCESS_TYPE);
569: WSH_DEBUG_SV.pop(l_module_name);
570: END IF;
571: --
572: EXCEPTION

Line 569: WSH_DEBUG_SV.pop(l_module_name);

565: -- Debug Statements
566: --
567: IF l_debug_on THEN
568: WSH_DEBUG_SV.log(l_module_name,'X_ACCESS_TYPE',X_ACCESS_TYPE);
569: WSH_DEBUG_SV.pop(l_module_name);
570: END IF;
571: --
572: EXCEPTION
573: WHEN others THEN

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

578: --
579: -- Debug Statements
580: --
581: IF l_debug_on THEN
582: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
583: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
584: END IF;
585: --
586: END Entity_Access_In_Organization;

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

579: -- Debug Statements
580: --
581: IF l_debug_on THEN
582: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
583: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
584: END IF;
585: --
586: END Entity_Access_In_Organization;
587:

Line 612: l_debug_on := wsh_debug_sv.is_debug_enabled;

608: Begin
609:
610: l_debug_on := wsh_debug_interface.g_debug;
611: IF l_debug_on IS NULL THEN
612: l_debug_on := wsh_debug_sv.is_debug_enabled;
613: END IF;
614:
615:
616: IF l_debug_on THEN

Line 617: wsh_debug_sv.push(l_module_name);

613: END IF;
614:
615:
616: IF l_debug_on THEN
617: wsh_debug_sv.push(l_module_name);
618: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.customized_activity_mesg_id',p_custom_message_rec.customized_activity_mesg_id);
619: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.role_id',p_custom_message_rec.role_id);
620: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.activity_code',p_custom_message_rec.activity_code);
621: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.validation_code',p_custom_message_rec.validation_code);

Line 618: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.customized_activity_mesg_id',p_custom_message_rec.customized_activity_mesg_id);

614:
615:
616: IF l_debug_on THEN
617: wsh_debug_sv.push(l_module_name);
618: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.customized_activity_mesg_id',p_custom_message_rec.customized_activity_mesg_id);
619: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.role_id',p_custom_message_rec.role_id);
620: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.activity_code',p_custom_message_rec.activity_code);
621: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.validation_code',p_custom_message_rec.validation_code);
622: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.return_status',p_custom_message_rec.return_status);

Line 619: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.role_id',p_custom_message_rec.role_id);

615:
616: IF l_debug_on THEN
617: wsh_debug_sv.push(l_module_name);
618: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.customized_activity_mesg_id',p_custom_message_rec.customized_activity_mesg_id);
619: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.role_id',p_custom_message_rec.role_id);
620: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.activity_code',p_custom_message_rec.activity_code);
621: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.validation_code',p_custom_message_rec.validation_code);
622: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.return_status',p_custom_message_rec.return_status);
623: wsh_debug_sv.log(l_module_name,'l_id',l_id);

Line 620: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.activity_code',p_custom_message_rec.activity_code);

616: IF l_debug_on THEN
617: wsh_debug_sv.push(l_module_name);
618: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.customized_activity_mesg_id',p_custom_message_rec.customized_activity_mesg_id);
619: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.role_id',p_custom_message_rec.role_id);
620: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.activity_code',p_custom_message_rec.activity_code);
621: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.validation_code',p_custom_message_rec.validation_code);
622: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.return_status',p_custom_message_rec.return_status);
623: wsh_debug_sv.log(l_module_name,'l_id',l_id);
624: wsh_debug_sv.log(l_module_name,'l_user_id',l_user_id);

Line 621: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.validation_code',p_custom_message_rec.validation_code);

617: wsh_debug_sv.push(l_module_name);
618: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.customized_activity_mesg_id',p_custom_message_rec.customized_activity_mesg_id);
619: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.role_id',p_custom_message_rec.role_id);
620: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.activity_code',p_custom_message_rec.activity_code);
621: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.validation_code',p_custom_message_rec.validation_code);
622: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.return_status',p_custom_message_rec.return_status);
623: wsh_debug_sv.log(l_module_name,'l_id',l_id);
624: wsh_debug_sv.log(l_module_name,'l_user_id',l_user_id);
625: wsh_debug_sv.log(l_module_name,'l_login_id',l_login_id);

Line 622: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.return_status',p_custom_message_rec.return_status);

618: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.customized_activity_mesg_id',p_custom_message_rec.customized_activity_mesg_id);
619: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.role_id',p_custom_message_rec.role_id);
620: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.activity_code',p_custom_message_rec.activity_code);
621: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.validation_code',p_custom_message_rec.validation_code);
622: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.return_status',p_custom_message_rec.return_status);
623: wsh_debug_sv.log(l_module_name,'l_id',l_id);
624: wsh_debug_sv.log(l_module_name,'l_user_id',l_user_id);
625: wsh_debug_sv.log(l_module_name,'l_login_id',l_login_id);
626: wsh_debug_sv.log(l_module_name,'l_sysdate',l_sysdate);

Line 623: wsh_debug_sv.log(l_module_name,'l_id',l_id);

619: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.role_id',p_custom_message_rec.role_id);
620: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.activity_code',p_custom_message_rec.activity_code);
621: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.validation_code',p_custom_message_rec.validation_code);
622: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.return_status',p_custom_message_rec.return_status);
623: wsh_debug_sv.log(l_module_name,'l_id',l_id);
624: wsh_debug_sv.log(l_module_name,'l_user_id',l_user_id);
625: wsh_debug_sv.log(l_module_name,'l_login_id',l_login_id);
626: wsh_debug_sv.log(l_module_name,'l_sysdate',l_sysdate);
627: END IF;

Line 624: wsh_debug_sv.log(l_module_name,'l_user_id',l_user_id);

620: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.activity_code',p_custom_message_rec.activity_code);
621: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.validation_code',p_custom_message_rec.validation_code);
622: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.return_status',p_custom_message_rec.return_status);
623: wsh_debug_sv.log(l_module_name,'l_id',l_id);
624: wsh_debug_sv.log(l_module_name,'l_user_id',l_user_id);
625: wsh_debug_sv.log(l_module_name,'l_login_id',l_login_id);
626: wsh_debug_sv.log(l_module_name,'l_sysdate',l_sysdate);
627: END IF;
628:

Line 625: wsh_debug_sv.log(l_module_name,'l_login_id',l_login_id);

621: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.validation_code',p_custom_message_rec.validation_code);
622: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.return_status',p_custom_message_rec.return_status);
623: wsh_debug_sv.log(l_module_name,'l_id',l_id);
624: wsh_debug_sv.log(l_module_name,'l_user_id',l_user_id);
625: wsh_debug_sv.log(l_module_name,'l_login_id',l_login_id);
626: wsh_debug_sv.log(l_module_name,'l_sysdate',l_sysdate);
627: END IF;
628:
629: x_return_status := wsh_util_core.g_ret_sts_success;

Line 626: wsh_debug_sv.log(l_module_name,'l_sysdate',l_sysdate);

622: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.return_status',p_custom_message_rec.return_status);
623: wsh_debug_sv.log(l_module_name,'l_id',l_id);
624: wsh_debug_sv.log(l_module_name,'l_user_id',l_user_id);
625: wsh_debug_sv.log(l_module_name,'l_login_id',l_login_id);
626: wsh_debug_sv.log(l_module_name,'l_sysdate',l_sysdate);
627: END IF;
628:
629: x_return_status := wsh_util_core.g_ret_sts_success;
630:

Line 659: wsh_debug_sv.log(l_module_name,'x_return_status',x_return_status);

655: p_custom_message_rec.customized_activity_mesg_id := l_id;
656: --p_custom_message_rec.last_update_date := l_sysdate;
657:
658: IF l_debug_on THEN
659: wsh_debug_sv.log(l_module_name,'x_return_status',x_return_status);
660: wsh_debug_sv.pop(l_module_name);
661: END IF;
662:
663: Exception

Line 660: wsh_debug_sv.pop(l_module_name);

656: --p_custom_message_rec.last_update_date := l_sysdate;
657:
658: IF l_debug_on THEN
659: wsh_debug_sv.log(l_module_name,'x_return_status',x_return_status);
660: wsh_debug_sv.pop(l_module_name);
661: END IF;
662:
663: Exception
664: When others then

Line 668: wsh_debug_sv.log(l_module_name,'x_return_status',x_return_status);

664: When others then
665: x_error_message := SQLERRM;
666: x_return_status := wsh_util_core.g_ret_sts_error;
667: IF l_debug_on THEN
668: wsh_debug_sv.log(l_module_name,'x_return_status',x_return_status);
669: wsh_debug_sv.pop(l_module_name);
670: END IF;
671:
672: End insert_customized_msgs ;

Line 669: wsh_debug_sv.pop(l_module_name);

665: x_error_message := SQLERRM;
666: x_return_status := wsh_util_core.g_ret_sts_error;
667: IF l_debug_on THEN
668: wsh_debug_sv.log(l_module_name,'x_return_status',x_return_status);
669: wsh_debug_sv.pop(l_module_name);
670: END IF;
671:
672: End insert_customized_msgs ;
673:

Line 694: l_debug_on := wsh_debug_sv.is_debug_enabled;

690: Begin
691:
692: l_debug_on := wsh_debug_interface.g_debug;
693: IF l_debug_on IS NULL THEN
694: l_debug_on := wsh_debug_sv.is_debug_enabled;
695: END IF;
696:
697: IF l_debug_on THEN
698: wsh_debug_sv.push(l_module_name);

Line 698: wsh_debug_sv.push(l_module_name);

694: l_debug_on := wsh_debug_sv.is_debug_enabled;
695: END IF;
696:
697: IF l_debug_on THEN
698: wsh_debug_sv.push(l_module_name);
699: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.customized_activity_mesg_id',p_custom_message_rec.customized_activity_mesg_id);
700: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.role_id',p_custom_message_rec.role_id);
701: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.activity_code',p_custom_message_rec.activity_code);
702: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.validation_code',p_custom_message_rec.validation_code);

Line 699: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.customized_activity_mesg_id',p_custom_message_rec.customized_activity_mesg_id);

695: END IF;
696:
697: IF l_debug_on THEN
698: wsh_debug_sv.push(l_module_name);
699: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.customized_activity_mesg_id',p_custom_message_rec.customized_activity_mesg_id);
700: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.role_id',p_custom_message_rec.role_id);
701: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.activity_code',p_custom_message_rec.activity_code);
702: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.validation_code',p_custom_message_rec.validation_code);
703: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.return_status',p_custom_message_rec.return_status);

Line 700: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.role_id',p_custom_message_rec.role_id);

696:
697: IF l_debug_on THEN
698: wsh_debug_sv.push(l_module_name);
699: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.customized_activity_mesg_id',p_custom_message_rec.customized_activity_mesg_id);
700: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.role_id',p_custom_message_rec.role_id);
701: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.activity_code',p_custom_message_rec.activity_code);
702: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.validation_code',p_custom_message_rec.validation_code);
703: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.return_status',p_custom_message_rec.return_status);
704: wsh_debug_sv.log(l_module_name,'l_user_id',l_user_id);

Line 701: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.activity_code',p_custom_message_rec.activity_code);

697: IF l_debug_on THEN
698: wsh_debug_sv.push(l_module_name);
699: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.customized_activity_mesg_id',p_custom_message_rec.customized_activity_mesg_id);
700: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.role_id',p_custom_message_rec.role_id);
701: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.activity_code',p_custom_message_rec.activity_code);
702: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.validation_code',p_custom_message_rec.validation_code);
703: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.return_status',p_custom_message_rec.return_status);
704: wsh_debug_sv.log(l_module_name,'l_user_id',l_user_id);
705: wsh_debug_sv.log(l_module_name,'l_login_id',l_login_id);

Line 702: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.validation_code',p_custom_message_rec.validation_code);

698: wsh_debug_sv.push(l_module_name);
699: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.customized_activity_mesg_id',p_custom_message_rec.customized_activity_mesg_id);
700: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.role_id',p_custom_message_rec.role_id);
701: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.activity_code',p_custom_message_rec.activity_code);
702: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.validation_code',p_custom_message_rec.validation_code);
703: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.return_status',p_custom_message_rec.return_status);
704: wsh_debug_sv.log(l_module_name,'l_user_id',l_user_id);
705: wsh_debug_sv.log(l_module_name,'l_login_id',l_login_id);
706: wsh_debug_sv.log(l_module_name,'l_sysdate',l_sysdate);

Line 703: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.return_status',p_custom_message_rec.return_status);

699: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.customized_activity_mesg_id',p_custom_message_rec.customized_activity_mesg_id);
700: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.role_id',p_custom_message_rec.role_id);
701: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.activity_code',p_custom_message_rec.activity_code);
702: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.validation_code',p_custom_message_rec.validation_code);
703: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.return_status',p_custom_message_rec.return_status);
704: wsh_debug_sv.log(l_module_name,'l_user_id',l_user_id);
705: wsh_debug_sv.log(l_module_name,'l_login_id',l_login_id);
706: wsh_debug_sv.log(l_module_name,'l_sysdate',l_sysdate);
707: END IF;

Line 704: wsh_debug_sv.log(l_module_name,'l_user_id',l_user_id);

700: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.role_id',p_custom_message_rec.role_id);
701: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.activity_code',p_custom_message_rec.activity_code);
702: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.validation_code',p_custom_message_rec.validation_code);
703: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.return_status',p_custom_message_rec.return_status);
704: wsh_debug_sv.log(l_module_name,'l_user_id',l_user_id);
705: wsh_debug_sv.log(l_module_name,'l_login_id',l_login_id);
706: wsh_debug_sv.log(l_module_name,'l_sysdate',l_sysdate);
707: END IF;
708:

Line 705: wsh_debug_sv.log(l_module_name,'l_login_id',l_login_id);

701: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.activity_code',p_custom_message_rec.activity_code);
702: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.validation_code',p_custom_message_rec.validation_code);
703: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.return_status',p_custom_message_rec.return_status);
704: wsh_debug_sv.log(l_module_name,'l_user_id',l_user_id);
705: wsh_debug_sv.log(l_module_name,'l_login_id',l_login_id);
706: wsh_debug_sv.log(l_module_name,'l_sysdate',l_sysdate);
707: END IF;
708:
709: x_return_status := wsh_util_core.g_ret_sts_success;

Line 706: wsh_debug_sv.log(l_module_name,'l_sysdate',l_sysdate);

702: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.validation_code',p_custom_message_rec.validation_code);
703: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.return_status',p_custom_message_rec.return_status);
704: wsh_debug_sv.log(l_module_name,'l_user_id',l_user_id);
705: wsh_debug_sv.log(l_module_name,'l_login_id',l_login_id);
706: wsh_debug_sv.log(l_module_name,'l_sysdate',l_sysdate);
707: END IF;
708:
709: x_return_status := wsh_util_core.g_ret_sts_success;
710:

Line 726: wsh_debug_sv.log(l_module_name,'x_return_status',x_return_status);

722:
723: --p_custom_message_rec.last_update_date := l_sysdate;
724:
725: IF l_debug_on THEN
726: wsh_debug_sv.log(l_module_name,'x_return_status',x_return_status);
727: wsh_debug_sv.pop(l_module_name);
728: END IF;
729:
730: Exception

Line 727: wsh_debug_sv.pop(l_module_name);

723: --p_custom_message_rec.last_update_date := l_sysdate;
724:
725: IF l_debug_on THEN
726: wsh_debug_sv.log(l_module_name,'x_return_status',x_return_status);
727: wsh_debug_sv.pop(l_module_name);
728: END IF;
729:
730: Exception
731: When others then

Line 735: wsh_debug_sv.log(l_module_name,'x_return_status',x_return_status);

731: When others then
732: x_error_message := SQLERRM;
733: x_return_status := wsh_util_core.g_ret_sts_error;
734: IF l_debug_on THEN
735: wsh_debug_sv.log(l_module_name,'x_return_status',x_return_status);
736: wsh_debug_sv.pop(l_module_name);
737: END IF;
738:
739: End update_customized_msgs ;

Line 736: wsh_debug_sv.pop(l_module_name);

732: x_error_message := SQLERRM;
733: x_return_status := wsh_util_core.g_ret_sts_error;
734: IF l_debug_on THEN
735: wsh_debug_sv.log(l_module_name,'x_return_status',x_return_status);
736: wsh_debug_sv.pop(l_module_name);
737: END IF;
738:
739: End update_customized_msgs ;
740:

Line 758: l_debug_on := wsh_debug_sv.is_debug_enabled;

754: Begin
755:
756: l_debug_on := wsh_debug_interface.g_debug;
757: IF l_debug_on IS NULL THEN
758: l_debug_on := wsh_debug_sv.is_debug_enabled;
759: END IF;
760:
761: IF l_debug_on THEN
762: wsh_debug_sv.push(l_module_name);

Line 762: wsh_debug_sv.push(l_module_name);

758: l_debug_on := wsh_debug_sv.is_debug_enabled;
759: END IF;
760:
761: IF l_debug_on THEN
762: wsh_debug_sv.push(l_module_name);
763: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.customized_activity_mesg_id',p_custom_message_rec.customized_activity_mesg_id);
764: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.role_id',p_custom_message_rec.role_id);
765: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.activity_code',p_custom_message_rec.activity_code);
766: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.validation_code',p_custom_message_rec.validation_code);

Line 763: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.customized_activity_mesg_id',p_custom_message_rec.customized_activity_mesg_id);

759: END IF;
760:
761: IF l_debug_on THEN
762: wsh_debug_sv.push(l_module_name);
763: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.customized_activity_mesg_id',p_custom_message_rec.customized_activity_mesg_id);
764: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.role_id',p_custom_message_rec.role_id);
765: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.activity_code',p_custom_message_rec.activity_code);
766: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.validation_code',p_custom_message_rec.validation_code);
767: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.return_status',p_custom_message_rec.return_status);

Line 764: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.role_id',p_custom_message_rec.role_id);

760:
761: IF l_debug_on THEN
762: wsh_debug_sv.push(l_module_name);
763: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.customized_activity_mesg_id',p_custom_message_rec.customized_activity_mesg_id);
764: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.role_id',p_custom_message_rec.role_id);
765: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.activity_code',p_custom_message_rec.activity_code);
766: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.validation_code',p_custom_message_rec.validation_code);
767: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.return_status',p_custom_message_rec.return_status);
768: END IF;

Line 765: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.activity_code',p_custom_message_rec.activity_code);

761: IF l_debug_on THEN
762: wsh_debug_sv.push(l_module_name);
763: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.customized_activity_mesg_id',p_custom_message_rec.customized_activity_mesg_id);
764: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.role_id',p_custom_message_rec.role_id);
765: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.activity_code',p_custom_message_rec.activity_code);
766: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.validation_code',p_custom_message_rec.validation_code);
767: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.return_status',p_custom_message_rec.return_status);
768: END IF;
769:

Line 766: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.validation_code',p_custom_message_rec.validation_code);

762: wsh_debug_sv.push(l_module_name);
763: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.customized_activity_mesg_id',p_custom_message_rec.customized_activity_mesg_id);
764: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.role_id',p_custom_message_rec.role_id);
765: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.activity_code',p_custom_message_rec.activity_code);
766: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.validation_code',p_custom_message_rec.validation_code);
767: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.return_status',p_custom_message_rec.return_status);
768: END IF;
769:
770: x_return_status := wsh_util_core.g_ret_sts_success;

Line 767: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.return_status',p_custom_message_rec.return_status);

763: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.customized_activity_mesg_id',p_custom_message_rec.customized_activity_mesg_id);
764: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.role_id',p_custom_message_rec.role_id);
765: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.activity_code',p_custom_message_rec.activity_code);
766: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.validation_code',p_custom_message_rec.validation_code);
767: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.return_status',p_custom_message_rec.return_status);
768: END IF;
769:
770: x_return_status := wsh_util_core.g_ret_sts_success;
771:

Line 776: wsh_debug_sv.log(l_module_name,'l_return_status',x_return_status);

772: delete from wsh_customized_activity_msgs
773: where customized_activity_mesg_id = p_custom_message_rec.customized_activity_mesg_id;
774:
775: IF l_debug_on THEN
776: wsh_debug_sv.log(l_module_name,'l_return_status',x_return_status);
777: wsh_debug_sv.pop(l_module_name);
778: END IF;
779:
780:

Line 777: wsh_debug_sv.pop(l_module_name);

773: where customized_activity_mesg_id = p_custom_message_rec.customized_activity_mesg_id;
774:
775: IF l_debug_on THEN
776: wsh_debug_sv.log(l_module_name,'l_return_status',x_return_status);
777: wsh_debug_sv.pop(l_module_name);
778: END IF;
779:
780:
781: Exception

Line 786: wsh_debug_sv.log(l_module_name,'l_return_status',x_return_status);

782: When others then
783: x_error_message := SQLERRM;
784: x_return_status := wsh_util_core.g_ret_sts_error;
785: IF l_debug_on THEN
786: wsh_debug_sv.log(l_module_name,'l_return_status',x_return_status);
787: wsh_debug_sv.pop(l_module_name);
788: END IF;
789: End delete_customized_msgs ;
790:

Line 787: wsh_debug_sv.pop(l_module_name);

783: x_error_message := SQLERRM;
784: x_return_status := wsh_util_core.g_ret_sts_error;
785: IF l_debug_on THEN
786: wsh_debug_sv.log(l_module_name,'l_return_status',x_return_status);
787: wsh_debug_sv.pop(l_module_name);
788: END IF;
789: End delete_customized_msgs ;
790:
791: Function get_message_severity (

Line 830: l_debug_on := wsh_debug_sv.is_debug_enabled;

826: Begin
827:
828: l_debug_on := wsh_debug_interface.g_debug;
829: IF l_debug_on IS NULL THEN
830: l_debug_on := wsh_debug_sv.is_debug_enabled;
831: END IF;
832:
833: IF l_debug_on THEN
834: wsh_debug_sv.push(l_module_name);

Line 834: wsh_debug_sv.push(l_module_name);

830: l_debug_on := wsh_debug_sv.is_debug_enabled;
831: END IF;
832:
833: IF l_debug_on THEN
834: wsh_debug_sv.push(l_module_name);
835: wsh_debug_sv.log(l_module_name,'l_user_id',l_user_id);
836: wsh_debug_sv.log(l_module_name,'p_activity_code',p_activity_code);
837: wsh_debug_sv.log(l_module_name,'p_validation_code',p_validation_code);
838: wsh_debug_sv.log(l_module_name,'g_custom_message_tbl.count',g_custom_message_tbl.count);

Line 835: wsh_debug_sv.log(l_module_name,'l_user_id',l_user_id);

831: END IF;
832:
833: IF l_debug_on THEN
834: wsh_debug_sv.push(l_module_name);
835: wsh_debug_sv.log(l_module_name,'l_user_id',l_user_id);
836: wsh_debug_sv.log(l_module_name,'p_activity_code',p_activity_code);
837: wsh_debug_sv.log(l_module_name,'p_validation_code',p_validation_code);
838: wsh_debug_sv.log(l_module_name,'g_custom_message_tbl.count',g_custom_message_tbl.count);
839: End If;

Line 836: wsh_debug_sv.log(l_module_name,'p_activity_code',p_activity_code);

832:
833: IF l_debug_on THEN
834: wsh_debug_sv.push(l_module_name);
835: wsh_debug_sv.log(l_module_name,'l_user_id',l_user_id);
836: wsh_debug_sv.log(l_module_name,'p_activity_code',p_activity_code);
837: wsh_debug_sv.log(l_module_name,'p_validation_code',p_validation_code);
838: wsh_debug_sv.log(l_module_name,'g_custom_message_tbl.count',g_custom_message_tbl.count);
839: End If;
840:

Line 837: wsh_debug_sv.log(l_module_name,'p_validation_code',p_validation_code);

833: IF l_debug_on THEN
834: wsh_debug_sv.push(l_module_name);
835: wsh_debug_sv.log(l_module_name,'l_user_id',l_user_id);
836: wsh_debug_sv.log(l_module_name,'p_activity_code',p_activity_code);
837: wsh_debug_sv.log(l_module_name,'p_validation_code',p_validation_code);
838: wsh_debug_sv.log(l_module_name,'g_custom_message_tbl.count',g_custom_message_tbl.count);
839: End If;
840:
841: If g_custom_message_tbl.count > 0 then

Line 838: wsh_debug_sv.log(l_module_name,'g_custom_message_tbl.count',g_custom_message_tbl.count);

834: wsh_debug_sv.push(l_module_name);
835: wsh_debug_sv.log(l_module_name,'l_user_id',l_user_id);
836: wsh_debug_sv.log(l_module_name,'p_activity_code',p_activity_code);
837: wsh_debug_sv.log(l_module_name,'p_validation_code',p_validation_code);
838: wsh_debug_sv.log(l_module_name,'g_custom_message_tbl.count',g_custom_message_tbl.count);
839: End If;
840:
841: If g_custom_message_tbl.count > 0 then
842: For i in g_custom_message_tbl.first..g_custom_message_tbl.last

Line 845: wsh_debug_sv.log(l_module_name,'g_custom_message_tbl('||i||').user_id',g_custom_message_tbl(i).user_id);

841: If g_custom_message_tbl.count > 0 then
842: For i in g_custom_message_tbl.first..g_custom_message_tbl.last
843: Loop
844: IF l_debug_on THEN
845: wsh_debug_sv.log(l_module_name,'g_custom_message_tbl('||i||').user_id',g_custom_message_tbl(i).user_id);
846: wsh_debug_sv.log(l_module_name,'g_custom_message_tbl('||i||').activity_code',g_custom_message_tbl(i).activity_code);
847: wsh_debug_sv.log(l_module_name,'g_custom_message_tbl('||i||').validation_code',g_custom_message_tbl(i).validation_code);
848: End If;
849: If g_custom_message_tbl(i).user_id = l_user_id And

Line 846: wsh_debug_sv.log(l_module_name,'g_custom_message_tbl('||i||').activity_code',g_custom_message_tbl(i).activity_code);

842: For i in g_custom_message_tbl.first..g_custom_message_tbl.last
843: Loop
844: IF l_debug_on THEN
845: wsh_debug_sv.log(l_module_name,'g_custom_message_tbl('||i||').user_id',g_custom_message_tbl(i).user_id);
846: wsh_debug_sv.log(l_module_name,'g_custom_message_tbl('||i||').activity_code',g_custom_message_tbl(i).activity_code);
847: wsh_debug_sv.log(l_module_name,'g_custom_message_tbl('||i||').validation_code',g_custom_message_tbl(i).validation_code);
848: End If;
849: If g_custom_message_tbl(i).user_id = l_user_id And
850: g_custom_message_tbl(i).activity_code = p_activity_code And

Line 847: wsh_debug_sv.log(l_module_name,'g_custom_message_tbl('||i||').validation_code',g_custom_message_tbl(i).validation_code);

843: Loop
844: IF l_debug_on THEN
845: wsh_debug_sv.log(l_module_name,'g_custom_message_tbl('||i||').user_id',g_custom_message_tbl(i).user_id);
846: wsh_debug_sv.log(l_module_name,'g_custom_message_tbl('||i||').activity_code',g_custom_message_tbl(i).activity_code);
847: wsh_debug_sv.log(l_module_name,'g_custom_message_tbl('||i||').validation_code',g_custom_message_tbl(i).validation_code);
848: End If;
849: If g_custom_message_tbl(i).user_id = l_user_id And
850: g_custom_message_tbl(i).activity_code = p_activity_code And
851: g_custom_message_tbl(i).validation_code = p_validation_code Then

Line 853: wsh_debug_sv.log(l_module_name,'Message Severity from cache ', g_custom_message_tbl(i).return_status);

849: If g_custom_message_tbl(i).user_id = l_user_id And
850: g_custom_message_tbl(i).activity_code = p_activity_code And
851: g_custom_message_tbl(i).validation_code = p_validation_code Then
852: IF l_debug_on THEN
853: wsh_debug_sv.log(l_module_name,'Message Severity from cache ', g_custom_message_tbl(i).return_status);
854: wsh_debug_sv.pop(l_module_name);
855: End If;
856: return(g_custom_message_tbl(i).return_status);
857: End If;

Line 854: wsh_debug_sv.pop(l_module_name);

850: g_custom_message_tbl(i).activity_code = p_activity_code And
851: g_custom_message_tbl(i).validation_code = p_validation_code Then
852: IF l_debug_on THEN
853: wsh_debug_sv.log(l_module_name,'Message Severity from cache ', g_custom_message_tbl(i).return_status);
854: wsh_debug_sv.pop(l_module_name);
855: End If;
856: return(g_custom_message_tbl(i).return_status);
857: End If;
858: End Loop;

Line 867: wsh_debug_sv.log(l_module_name,'l_get_message_severity_rec.return_status:',l_get_message_severity_rec.return_status);

863: , p_validation_code
864: , l_lookup_type );
865: Fetch l_get_message_severity_csr into l_get_message_severity_rec;
866: IF l_debug_on THEN
867: wsh_debug_sv.log(l_module_name,'l_get_message_severity_rec.return_status:',l_get_message_severity_rec.return_status);
868: End If;
869: Close l_get_message_severity_csr;
870:
871: l_index := g_custom_message_tbl.count + 1 ;

Line 878: wsh_debug_sv.log(l_module_name,'Message Severity ',nvl(l_get_message_severity_rec.return_status, 'W'));

874: g_custom_message_tbl(l_index).validation_code := p_validation_code;
875: g_custom_message_tbl(l_index).return_status := nvl(l_get_message_severity_rec.return_status,'W');
876:
877: IF l_debug_on THEN
878: wsh_debug_sv.log(l_module_name,'Message Severity ',nvl(l_get_message_severity_rec.return_status, 'W'));
879: wsh_debug_sv.pop(l_module_name);
880: End If;
881: Return(nvl(l_get_message_severity_rec.return_status,'W'));
882: Exception

Line 879: wsh_debug_sv.pop(l_module_name);

875: g_custom_message_tbl(l_index).return_status := nvl(l_get_message_severity_rec.return_status,'W');
876:
877: IF l_debug_on THEN
878: wsh_debug_sv.log(l_module_name,'Message Severity ',nvl(l_get_message_severity_rec.return_status, 'W'));
879: wsh_debug_sv.pop(l_module_name);
880: End If;
881: Return(nvl(l_get_message_severity_rec.return_status,'W'));
882: Exception
883: When others then

Line 885: wsh_debug_sv.log(l_module_name,'IN EXCEPTION ',SQLERRM);

881: Return(nvl(l_get_message_severity_rec.return_status,'W'));
882: Exception
883: When others then
884: IF l_debug_on THEN
885: wsh_debug_sv.log(l_module_name,'IN EXCEPTION ',SQLERRM);
886: wsh_debug_sv.pop(l_module_name);
887: End If;
888: Raise;
889:

Line 886: wsh_debug_sv.pop(l_module_name);

882: Exception
883: When others then
884: IF l_debug_on THEN
885: wsh_debug_sv.log(l_module_name,'IN EXCEPTION ',SQLERRM);
886: wsh_debug_sv.pop(l_module_name);
887: End If;
888: Raise;
889:
890: End get_message_severity;