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

Line 58: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

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

Line 62: WSH_DEBUG_SV.push(l_module_name);

58: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
59: END IF;
60: --
61: IF l_debug_on THEN
62: WSH_DEBUG_SV.push(l_module_name);
63: --
64: WSH_DEBUG_SV.log(l_module_name,'P_APPLICATION_ID',P_APPLICATION_ID);
65: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_SHORT_NAME',P_ENTITY_SHORT_NAME);
66: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_ENTITY_SHORT_NAME',P_VALIDATION_ENTITY_SHORT_NAME);

Line 64: WSH_DEBUG_SV.log(l_module_name,'P_APPLICATION_ID',P_APPLICATION_ID);

60: --
61: IF l_debug_on THEN
62: WSH_DEBUG_SV.push(l_module_name);
63: --
64: WSH_DEBUG_SV.log(l_module_name,'P_APPLICATION_ID',P_APPLICATION_ID);
65: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_SHORT_NAME',P_ENTITY_SHORT_NAME);
66: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_ENTITY_SHORT_NAME',P_VALIDATION_ENTITY_SHORT_NAME);
67: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_TMPLT_SHORT_NAME',P_VALIDATION_TMPLT_SHORT_NAME);
68: WSH_DEBUG_SV.log(l_module_name,'P_RECORD_SET_SHORT_NAME',P_RECORD_SET_SHORT_NAME);

Line 65: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_SHORT_NAME',P_ENTITY_SHORT_NAME);

61: IF l_debug_on THEN
62: WSH_DEBUG_SV.push(l_module_name);
63: --
64: WSH_DEBUG_SV.log(l_module_name,'P_APPLICATION_ID',P_APPLICATION_ID);
65: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_SHORT_NAME',P_ENTITY_SHORT_NAME);
66: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_ENTITY_SHORT_NAME',P_VALIDATION_ENTITY_SHORT_NAME);
67: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_TMPLT_SHORT_NAME',P_VALIDATION_TMPLT_SHORT_NAME);
68: WSH_DEBUG_SV.log(l_module_name,'P_RECORD_SET_SHORT_NAME',P_RECORD_SET_SHORT_NAME);
69: WSH_DEBUG_SV.log(l_module_name,'P_SCOPE',P_SCOPE);

Line 66: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_ENTITY_SHORT_NAME',P_VALIDATION_ENTITY_SHORT_NAME);

62: WSH_DEBUG_SV.push(l_module_name);
63: --
64: WSH_DEBUG_SV.log(l_module_name,'P_APPLICATION_ID',P_APPLICATION_ID);
65: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_SHORT_NAME',P_ENTITY_SHORT_NAME);
66: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_ENTITY_SHORT_NAME',P_VALIDATION_ENTITY_SHORT_NAME);
67: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_TMPLT_SHORT_NAME',P_VALIDATION_TMPLT_SHORT_NAME);
68: WSH_DEBUG_SV.log(l_module_name,'P_RECORD_SET_SHORT_NAME',P_RECORD_SET_SHORT_NAME);
69: WSH_DEBUG_SV.log(l_module_name,'P_SCOPE',P_SCOPE);
70: END IF;

Line 67: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_TMPLT_SHORT_NAME',P_VALIDATION_TMPLT_SHORT_NAME);

63: --
64: WSH_DEBUG_SV.log(l_module_name,'P_APPLICATION_ID',P_APPLICATION_ID);
65: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_SHORT_NAME',P_ENTITY_SHORT_NAME);
66: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_ENTITY_SHORT_NAME',P_VALIDATION_ENTITY_SHORT_NAME);
67: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_TMPLT_SHORT_NAME',P_VALIDATION_TMPLT_SHORT_NAME);
68: WSH_DEBUG_SV.log(l_module_name,'P_RECORD_SET_SHORT_NAME',P_RECORD_SET_SHORT_NAME);
69: WSH_DEBUG_SV.log(l_module_name,'P_SCOPE',P_SCOPE);
70: END IF;
71: --

Line 68: WSH_DEBUG_SV.log(l_module_name,'P_RECORD_SET_SHORT_NAME',P_RECORD_SET_SHORT_NAME);

64: WSH_DEBUG_SV.log(l_module_name,'P_APPLICATION_ID',P_APPLICATION_ID);
65: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_SHORT_NAME',P_ENTITY_SHORT_NAME);
66: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_ENTITY_SHORT_NAME',P_VALIDATION_ENTITY_SHORT_NAME);
67: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_TMPLT_SHORT_NAME',P_VALIDATION_TMPLT_SHORT_NAME);
68: WSH_DEBUG_SV.log(l_module_name,'P_RECORD_SET_SHORT_NAME',P_RECORD_SET_SHORT_NAME);
69: WSH_DEBUG_SV.log(l_module_name,'P_SCOPE',P_SCOPE);
70: END IF;
71: --
72: fnd_profile.get('ONT_ACTIVATE_CMS', l_cms_profile);

Line 69: WSH_DEBUG_SV.log(l_module_name,'P_SCOPE',P_SCOPE);

65: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_SHORT_NAME',P_ENTITY_SHORT_NAME);
66: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_ENTITY_SHORT_NAME',P_VALIDATION_ENTITY_SHORT_NAME);
67: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_TMPLT_SHORT_NAME',P_VALIDATION_TMPLT_SHORT_NAME);
68: WSH_DEBUG_SV.log(l_module_name,'P_RECORD_SET_SHORT_NAME',P_RECORD_SET_SHORT_NAME);
69: WSH_DEBUG_SV.log(l_module_name,'P_SCOPE',P_SCOPE);
70: END IF;
71: --
72: fnd_profile.get('ONT_ACTIVATE_CMS', l_cms_profile);
73: IF l_cms_profile = 'Y' THEN

Line 79: WSH_DEBUG_SV.log(l_module_name,'X_RESULT_OUT',x_result_out);

75: --
76: -- Debug Statements
77: --
78: IF l_debug_on THEN
79: WSH_DEBUG_SV.log(l_module_name,'X_RESULT_OUT',x_result_out);
80: WSH_DEBUG_SV.pop(l_module_name);
81: END IF;
82: --
83: RETURN;

Line 80: WSH_DEBUG_SV.pop(l_module_name);

76: -- Debug Statements
77: --
78: IF l_debug_on THEN
79: WSH_DEBUG_SV.log(l_module_name,'X_RESULT_OUT',x_result_out);
80: WSH_DEBUG_SV.pop(l_module_name);
81: END IF;
82: --
83: RETURN;
84: END IF;

Line 95: WSH_DEBUG_SV.log(l_module_name,'X_RESULT_OUT',x_result_out);

91: --
92: -- Debug Statements
93: --
94: IF l_debug_on THEN
95: WSH_DEBUG_SV.log(l_module_name,'X_RESULT_OUT',x_result_out);
96: WSH_DEBUG_SV.pop(l_module_name);
97: END IF;
98: --
99: RETURN;

Line 96: WSH_DEBUG_SV.pop(l_module_name);

92: -- Debug Statements
93: --
94: IF l_debug_on THEN
95: WSH_DEBUG_SV.log(l_module_name,'X_RESULT_OUT',x_result_out);
96: WSH_DEBUG_SV.pop(l_module_name);
97: END IF;
98: --
99: RETURN;
100: END IF;

Line 115: WSH_DEBUG_SV.log(l_module_name,'X_RESULT_OUT',x_result_out);

111: --
112: -- Debug Statements
113: --
114: IF l_debug_on THEN
115: WSH_DEBUG_SV.log(l_module_name,'X_RESULT_OUT',x_result_out);
116: WSH_DEBUG_SV.pop(l_module_name);
117: END IF;
118: --
119: RETURN;

Line 116: WSH_DEBUG_SV.pop(l_module_name);

112: -- Debug Statements
113: --
114: IF l_debug_on THEN
115: WSH_DEBUG_SV.log(l_module_name,'X_RESULT_OUT',x_result_out);
116: WSH_DEBUG_SV.pop(l_module_name);
117: END IF;
118: --
119: RETURN;
120: END IF;

Line 149: WSH_DEBUG_SV.log(l_module_name,'X_RESULT_OUT',x_result_out);

145: --
146: -- Debug Statements
147: --
148: IF l_debug_on THEN
149: WSH_DEBUG_SV.log(l_module_name,'X_RESULT_OUT',x_result_out);
150: WSH_DEBUG_SV.pop(l_module_name);
151: END IF;
152: --
153: EXCEPTION

Line 150: WSH_DEBUG_SV.pop(l_module_name);

146: -- Debug Statements
147: --
148: IF l_debug_on THEN
149: WSH_DEBUG_SV.log(l_module_name,'X_RESULT_OUT',x_result_out);
150: WSH_DEBUG_SV.pop(l_module_name);
151: END IF;
152: --
153: EXCEPTION
154: WHEN OTHERS THEN

Line 159: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit OE_MSG_PUB.CHECK_MSG_LEVEL',WSH_DEBUG_SV.C_PROC_LEVEL);

155: --
156: -- Debug Statements
157: --
158: IF l_debug_on THEN
159: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit OE_MSG_PUB.CHECK_MSG_LEVEL',WSH_DEBUG_SV.C_PROC_LEVEL);
160: END IF;
161: --
162: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
163: THEN

Line 168: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit OE_MSG_PUB.ADD_EXC_MSG',WSH_DEBUG_SV.C_PROC_LEVEL);

164: --
165: -- Debug Statements
166: --
167: IF l_debug_on THEN
168: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit OE_MSG_PUB.ADD_EXC_MSG',WSH_DEBUG_SV.C_PROC_LEVEL);
169: END IF;
170: --
171: OE_MSG_PUB.Add_Exc_Msg
172: ( G_PKG_NAME

Line 180: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR MESSAGE : '||SUBSTR ( SQLERRM , 1 , 100 ) );

176: --
177: -- Debug Statements
178: --
179: IF l_debug_on THEN
180: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR MESSAGE : '||SUBSTR ( SQLERRM , 1 , 100 ) );
181: END IF;
182: --
183: IF c_details%ISOPEN THEN
184: CLOSE c_details;

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

190: --
191: -- Debug Statements
192: --
193: IF l_debug_on THEN
194: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
195: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
196: END IF;
197: --
198: END Validate_Reservations;

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

191: -- Debug Statements
192: --
193: IF l_debug_on THEN
194: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
195: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
196: END IF;
197: --
198: END Validate_Reservations;
199:

Line 245: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

241: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
242: --
243: IF l_debug_on IS NULL
244: THEN
245: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
246: END IF;
247: --
248: IF l_debug_on THEN
249: WSH_DEBUG_SV.push(l_module_name);

Line 249: WSH_DEBUG_SV.push(l_module_name);

245: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
246: END IF;
247: --
248: IF l_debug_on THEN
249: WSH_DEBUG_SV.push(l_module_name);
250: --
251: WSH_DEBUG_SV.log(l_module_name,'P_APPLICATION_ID',P_APPLICATION_ID);
252: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_SHORT_NAME',P_ENTITY_SHORT_NAME);
253: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_ENTITY_SHORT_NAME',P_VALIDATION_ENTITY_SHORT_NAME);

Line 251: WSH_DEBUG_SV.log(l_module_name,'P_APPLICATION_ID',P_APPLICATION_ID);

247: --
248: IF l_debug_on THEN
249: WSH_DEBUG_SV.push(l_module_name);
250: --
251: WSH_DEBUG_SV.log(l_module_name,'P_APPLICATION_ID',P_APPLICATION_ID);
252: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_SHORT_NAME',P_ENTITY_SHORT_NAME);
253: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_ENTITY_SHORT_NAME',P_VALIDATION_ENTITY_SHORT_NAME);
254: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_TMPLT_SHORT_NAME',P_VALIDATION_TMPLT_SHORT_NAME);
255: WSH_DEBUG_SV.log(l_module_name,'P_RECORD_SET_SHORT_NAME',P_RECORD_SET_SHORT_NAME);

Line 252: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_SHORT_NAME',P_ENTITY_SHORT_NAME);

248: IF l_debug_on THEN
249: WSH_DEBUG_SV.push(l_module_name);
250: --
251: WSH_DEBUG_SV.log(l_module_name,'P_APPLICATION_ID',P_APPLICATION_ID);
252: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_SHORT_NAME',P_ENTITY_SHORT_NAME);
253: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_ENTITY_SHORT_NAME',P_VALIDATION_ENTITY_SHORT_NAME);
254: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_TMPLT_SHORT_NAME',P_VALIDATION_TMPLT_SHORT_NAME);
255: WSH_DEBUG_SV.log(l_module_name,'P_RECORD_SET_SHORT_NAME',P_RECORD_SET_SHORT_NAME);
256: WSH_DEBUG_SV.log(l_module_name,'P_SCOPE',P_SCOPE);

Line 253: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_ENTITY_SHORT_NAME',P_VALIDATION_ENTITY_SHORT_NAME);

249: WSH_DEBUG_SV.push(l_module_name);
250: --
251: WSH_DEBUG_SV.log(l_module_name,'P_APPLICATION_ID',P_APPLICATION_ID);
252: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_SHORT_NAME',P_ENTITY_SHORT_NAME);
253: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_ENTITY_SHORT_NAME',P_VALIDATION_ENTITY_SHORT_NAME);
254: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_TMPLT_SHORT_NAME',P_VALIDATION_TMPLT_SHORT_NAME);
255: WSH_DEBUG_SV.log(l_module_name,'P_RECORD_SET_SHORT_NAME',P_RECORD_SET_SHORT_NAME);
256: WSH_DEBUG_SV.log(l_module_name,'P_SCOPE',P_SCOPE);
257: END IF;

Line 254: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_TMPLT_SHORT_NAME',P_VALIDATION_TMPLT_SHORT_NAME);

250: --
251: WSH_DEBUG_SV.log(l_module_name,'P_APPLICATION_ID',P_APPLICATION_ID);
252: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_SHORT_NAME',P_ENTITY_SHORT_NAME);
253: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_ENTITY_SHORT_NAME',P_VALIDATION_ENTITY_SHORT_NAME);
254: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_TMPLT_SHORT_NAME',P_VALIDATION_TMPLT_SHORT_NAME);
255: WSH_DEBUG_SV.log(l_module_name,'P_RECORD_SET_SHORT_NAME',P_RECORD_SET_SHORT_NAME);
256: WSH_DEBUG_SV.log(l_module_name,'P_SCOPE',P_SCOPE);
257: END IF;
258: --

Line 255: WSH_DEBUG_SV.log(l_module_name,'P_RECORD_SET_SHORT_NAME',P_RECORD_SET_SHORT_NAME);

251: WSH_DEBUG_SV.log(l_module_name,'P_APPLICATION_ID',P_APPLICATION_ID);
252: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_SHORT_NAME',P_ENTITY_SHORT_NAME);
253: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_ENTITY_SHORT_NAME',P_VALIDATION_ENTITY_SHORT_NAME);
254: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_TMPLT_SHORT_NAME',P_VALIDATION_TMPLT_SHORT_NAME);
255: WSH_DEBUG_SV.log(l_module_name,'P_RECORD_SET_SHORT_NAME',P_RECORD_SET_SHORT_NAME);
256: WSH_DEBUG_SV.log(l_module_name,'P_SCOPE',P_SCOPE);
257: END IF;
258: --
259: x_result_out := lc_disallowed;

Line 256: WSH_DEBUG_SV.log(l_module_name,'P_SCOPE',P_SCOPE);

252: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_SHORT_NAME',P_ENTITY_SHORT_NAME);
253: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_ENTITY_SHORT_NAME',P_VALIDATION_ENTITY_SHORT_NAME);
254: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_TMPLT_SHORT_NAME',P_VALIDATION_TMPLT_SHORT_NAME);
255: WSH_DEBUG_SV.log(l_module_name,'P_RECORD_SET_SHORT_NAME',P_RECORD_SET_SHORT_NAME);
256: WSH_DEBUG_SV.log(l_module_name,'P_SCOPE',P_SCOPE);
257: END IF;
258: --
259: x_result_out := lc_disallowed;
260:

Line 269: WSH_DEBUG_SV.log(l_module_name,'X_RESULT_OUT',x_result_out);

265: --
266: -- Debug Statements
267: --
268: IF l_debug_on THEN
269: WSH_DEBUG_SV.log(l_module_name,'X_RESULT_OUT',x_result_out);
270: WSH_DEBUG_SV.pop(l_module_name);
271: END IF;
272: --
273: RETURN;

Line 270: WSH_DEBUG_SV.pop(l_module_name);

266: -- Debug Statements
267: --
268: IF l_debug_on THEN
269: WSH_DEBUG_SV.log(l_module_name,'X_RESULT_OUT',x_result_out);
270: WSH_DEBUG_SV.pop(l_module_name);
271: END IF;
272: --
273: RETURN;
274: END IF;

Line 288: WSH_DEBUG_SV.log(l_module_name,'X_RESULT_OUT',x_result_out);

284: --
285: -- Debug Statements
286: --
287: IF l_debug_on THEN
288: WSH_DEBUG_SV.log(l_module_name,'X_RESULT_OUT',x_result_out);
289: WSH_DEBUG_SV.pop(l_module_name);
290: END IF;
291: --
292: RETURN;

Line 289: WSH_DEBUG_SV.pop(l_module_name);

285: -- Debug Statements
286: --
287: IF l_debug_on THEN
288: WSH_DEBUG_SV.log(l_module_name,'X_RESULT_OUT',x_result_out);
289: WSH_DEBUG_SV.pop(l_module_name);
290: END IF;
291: --
292: RETURN;
293: END IF;

Line 302: WSH_DEBUG_SV.log(l_module_name,'X_RESULT_OUT',x_result_out);

298: --
299: -- Debug Statements
300: --
301: IF l_debug_on THEN
302: WSH_DEBUG_SV.log(l_module_name,'X_RESULT_OUT',x_result_out);
303: WSH_DEBUG_SV.pop(l_module_name);
304: END IF;
305: --
306: EXCEPTION

Line 303: WSH_DEBUG_SV.pop(l_module_name);

299: -- Debug Statements
300: --
301: IF l_debug_on THEN
302: WSH_DEBUG_SV.log(l_module_name,'X_RESULT_OUT',x_result_out);
303: WSH_DEBUG_SV.pop(l_module_name);
304: END IF;
305: --
306: EXCEPTION
307: WHEN OTHERS THEN

Line 312: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit OE_MSG_PUB.CHECK_MSG_LEVEL',WSH_DEBUG_SV.C_PROC_LEVEL);

308: --
309: -- Debug Statements
310: --
311: IF l_debug_on THEN
312: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit OE_MSG_PUB.CHECK_MSG_LEVEL',WSH_DEBUG_SV.C_PROC_LEVEL);
313: END IF;
314: --
315: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
316: THEN

Line 321: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit OE_MSG_PUB.ADD_EXC_MSG',WSH_DEBUG_SV.C_PROC_LEVEL);

317: --
318: -- Debug Statements
319: --
320: IF l_debug_on THEN
321: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit OE_MSG_PUB.ADD_EXC_MSG',WSH_DEBUG_SV.C_PROC_LEVEL);
322: END IF;
323: --
324: OE_MSG_PUB.Add_Exc_Msg
325: ( G_PKG_NAME

Line 333: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR MESSAGE : '||SUBSTR ( SQLERRM , 1 , 100 ) );

329: --
330: -- Debug Statements
331: --
332: IF l_debug_on THEN
333: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR MESSAGE : '||SUBSTR ( SQLERRM , 1 , 100 ) );
334: END IF;
335: --
336:
337: IF c_details%ISOPEN THEN

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

342: --
343: -- Debug Statements
344: --
345: IF l_debug_on THEN
346: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
347: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
348: END IF;
349: --
350: END Validate_Sub_Change;

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

343: -- Debug Statements
344: --
345: IF l_debug_on THEN
346: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
347: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
348: END IF;
349: --
350: END Validate_Sub_Change;
351: