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

Line 88: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

84: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
85: --
86: IF l_debug_on IS NULL
87: THEN
88: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
89: END IF;
90: --
91: --
92: -- Debug Statements

Line 95: WSH_DEBUG_SV.push(l_module_name);

91: --
92: -- Debug Statements
93: --
94: IF l_debug_on THEN
95: WSH_DEBUG_SV.push(l_module_name);
96: --
97: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
98: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
99: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY_NAME',P_LOGGING_ENTITY_NAME);

Line 97: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);

93: --
94: IF l_debug_on THEN
95: WSH_DEBUG_SV.push(l_module_name);
96: --
97: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
98: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
99: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY_NAME',P_LOGGING_ENTITY_NAME);
100: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY_ID',P_LOGGING_ENTITY_ID);
101: END IF;

Line 98: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);

94: IF l_debug_on THEN
95: WSH_DEBUG_SV.push(l_module_name);
96: --
97: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
98: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
99: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY_NAME',P_LOGGING_ENTITY_NAME);
100: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY_ID',P_LOGGING_ENTITY_ID);
101: END IF;
102:

Line 99: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY_NAME',P_LOGGING_ENTITY_NAME);

95: WSH_DEBUG_SV.push(l_module_name);
96: --
97: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
98: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
99: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY_NAME',P_LOGGING_ENTITY_NAME);
100: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY_ID',P_LOGGING_ENTITY_ID);
101: END IF;
102:
103: IF NOT FND_API.compatible_api_call (

Line 100: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY_ID',P_LOGGING_ENTITY_ID);

96: --
97: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
98: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
99: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY_NAME',P_LOGGING_ENTITY_NAME);
100: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY_ID',P_LOGGING_ENTITY_ID);
101: END IF;
102:
103: IF NOT FND_API.compatible_api_call (
104: l_api_version,

Line 152: WSH_DEBUG_SV.pop(l_module_name);

148: --
149: -- Debug Statements
150: --
151: IF l_debug_on THEN
152: WSH_DEBUG_SV.pop(l_module_name);
153: END IF;
154: --
155:
156: EXCEPTION

Line 171: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_EXCEPTION_NAME exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

167: --
168: -- Debug Statements
169: --
170: IF l_debug_on THEN
171: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_EXCEPTION_NAME exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
172: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_EXCEPTION_NAME');
173: END IF;
174: --
175:

Line 172: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_EXCEPTION_NAME');

168: -- Debug Statements
169: --
170: IF l_debug_on THEN
171: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_EXCEPTION_NAME exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
172: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_EXCEPTION_NAME');
173: END IF;
174: --
175:
176: WHEN others THEN

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

196: --
197: -- Debug Statements
198: --
199: IF l_debug_on THEN
200: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
201: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
202: END IF;
203: --
204:

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

197: -- Debug Statements
198: --
199: IF l_debug_on THEN
200: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
201: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
202: END IF;
203: --
204:
205: END Get_Exceptions;

Line 276: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

272: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
273: --
274: IF l_debug_on IS NULL
275: THEN
276: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
277: END IF;
278: --
279: --
280: -- Debug Statements

Line 283: WSH_DEBUG_SV.push(l_module_name);

279: --
280: -- Debug Statements
281: --
282: IF l_debug_on THEN
283: WSH_DEBUG_SV.push(l_module_name);
284: --
285: WSH_DEBUG_SV.log(l_module_name,'p_api_version',p_api_version);
286: WSH_DEBUG_SV.log(l_module_name,'p_init_msg_list',p_init_msg_list);
287: WSH_DEBUG_SV.log(l_module_name,'p_commit',p_commit);

Line 285: WSH_DEBUG_SV.log(l_module_name,'p_api_version',p_api_version);

281: --
282: IF l_debug_on THEN
283: WSH_DEBUG_SV.push(l_module_name);
284: --
285: WSH_DEBUG_SV.log(l_module_name,'p_api_version',p_api_version);
286: WSH_DEBUG_SV.log(l_module_name,'p_init_msg_list',p_init_msg_list);
287: WSH_DEBUG_SV.log(l_module_name,'p_commit',p_commit);
288: WSH_DEBUG_SV.log(l_module_name,'p_validation_level',p_validation_level);
289: WSH_DEBUG_SV.log(l_module_name,'p_logging_entity_id',p_logging_entity_id);

Line 286: WSH_DEBUG_SV.log(l_module_name,'p_init_msg_list',p_init_msg_list);

282: IF l_debug_on THEN
283: WSH_DEBUG_SV.push(l_module_name);
284: --
285: WSH_DEBUG_SV.log(l_module_name,'p_api_version',p_api_version);
286: WSH_DEBUG_SV.log(l_module_name,'p_init_msg_list',p_init_msg_list);
287: WSH_DEBUG_SV.log(l_module_name,'p_commit',p_commit);
288: WSH_DEBUG_SV.log(l_module_name,'p_validation_level',p_validation_level);
289: WSH_DEBUG_SV.log(l_module_name,'p_logging_entity_id',p_logging_entity_id);
290: WSH_DEBUG_SV.log(l_module_name,'p_logging_entity_name',p_logging_entity_name);

Line 287: WSH_DEBUG_SV.log(l_module_name,'p_commit',p_commit);

283: WSH_DEBUG_SV.push(l_module_name);
284: --
285: WSH_DEBUG_SV.log(l_module_name,'p_api_version',p_api_version);
286: WSH_DEBUG_SV.log(l_module_name,'p_init_msg_list',p_init_msg_list);
287: WSH_DEBUG_SV.log(l_module_name,'p_commit',p_commit);
288: WSH_DEBUG_SV.log(l_module_name,'p_validation_level',p_validation_level);
289: WSH_DEBUG_SV.log(l_module_name,'p_logging_entity_id',p_logging_entity_id);
290: WSH_DEBUG_SV.log(l_module_name,'p_logging_entity_name',p_logging_entity_name);
291: WSH_DEBUG_SV.log(l_module_name,'p_exception_name',p_exception_name);

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

284: --
285: WSH_DEBUG_SV.log(l_module_name,'p_api_version',p_api_version);
286: WSH_DEBUG_SV.log(l_module_name,'p_init_msg_list',p_init_msg_list);
287: WSH_DEBUG_SV.log(l_module_name,'p_commit',p_commit);
288: WSH_DEBUG_SV.log(l_module_name,'p_validation_level',p_validation_level);
289: WSH_DEBUG_SV.log(l_module_name,'p_logging_entity_id',p_logging_entity_id);
290: WSH_DEBUG_SV.log(l_module_name,'p_logging_entity_name',p_logging_entity_name);
291: WSH_DEBUG_SV.log(l_module_name,'p_exception_name',p_exception_name);
292: WSH_DEBUG_SV.log(l_module_name,'p_exception_id',p_exception_id);

Line 289: WSH_DEBUG_SV.log(l_module_name,'p_logging_entity_id',p_logging_entity_id);

285: WSH_DEBUG_SV.log(l_module_name,'p_api_version',p_api_version);
286: WSH_DEBUG_SV.log(l_module_name,'p_init_msg_list',p_init_msg_list);
287: WSH_DEBUG_SV.log(l_module_name,'p_commit',p_commit);
288: WSH_DEBUG_SV.log(l_module_name,'p_validation_level',p_validation_level);
289: WSH_DEBUG_SV.log(l_module_name,'p_logging_entity_id',p_logging_entity_id);
290: WSH_DEBUG_SV.log(l_module_name,'p_logging_entity_name',p_logging_entity_name);
291: WSH_DEBUG_SV.log(l_module_name,'p_exception_name',p_exception_name);
292: WSH_DEBUG_SV.log(l_module_name,'p_exception_id',p_exception_id);
293: WSH_DEBUG_SV.log(l_module_name,'p_new_status',p_new_status);

Line 290: WSH_DEBUG_SV.log(l_module_name,'p_logging_entity_name',p_logging_entity_name);

286: WSH_DEBUG_SV.log(l_module_name,'p_init_msg_list',p_init_msg_list);
287: WSH_DEBUG_SV.log(l_module_name,'p_commit',p_commit);
288: WSH_DEBUG_SV.log(l_module_name,'p_validation_level',p_validation_level);
289: WSH_DEBUG_SV.log(l_module_name,'p_logging_entity_id',p_logging_entity_id);
290: WSH_DEBUG_SV.log(l_module_name,'p_logging_entity_name',p_logging_entity_name);
291: WSH_DEBUG_SV.log(l_module_name,'p_exception_name',p_exception_name);
292: WSH_DEBUG_SV.log(l_module_name,'p_exception_id',p_exception_id);
293: WSH_DEBUG_SV.log(l_module_name,'p_new_status',p_new_status);
294: END IF;

Line 291: WSH_DEBUG_SV.log(l_module_name,'p_exception_name',p_exception_name);

287: WSH_DEBUG_SV.log(l_module_name,'p_commit',p_commit);
288: WSH_DEBUG_SV.log(l_module_name,'p_validation_level',p_validation_level);
289: WSH_DEBUG_SV.log(l_module_name,'p_logging_entity_id',p_logging_entity_id);
290: WSH_DEBUG_SV.log(l_module_name,'p_logging_entity_name',p_logging_entity_name);
291: WSH_DEBUG_SV.log(l_module_name,'p_exception_name',p_exception_name);
292: WSH_DEBUG_SV.log(l_module_name,'p_exception_id',p_exception_id);
293: WSH_DEBUG_SV.log(l_module_name,'p_new_status',p_new_status);
294: END IF;
295:

Line 292: WSH_DEBUG_SV.log(l_module_name,'p_exception_id',p_exception_id);

288: WSH_DEBUG_SV.log(l_module_name,'p_validation_level',p_validation_level);
289: WSH_DEBUG_SV.log(l_module_name,'p_logging_entity_id',p_logging_entity_id);
290: WSH_DEBUG_SV.log(l_module_name,'p_logging_entity_name',p_logging_entity_name);
291: WSH_DEBUG_SV.log(l_module_name,'p_exception_name',p_exception_name);
292: WSH_DEBUG_SV.log(l_module_name,'p_exception_id',p_exception_id);
293: WSH_DEBUG_SV.log(l_module_name,'p_new_status',p_new_status);
294: END IF;
295:
296: IF NOT FND_API.compatible_api_call (

Line 293: WSH_DEBUG_SV.log(l_module_name,'p_new_status',p_new_status);

289: WSH_DEBUG_SV.log(l_module_name,'p_logging_entity_id',p_logging_entity_id);
290: WSH_DEBUG_SV.log(l_module_name,'p_logging_entity_name',p_logging_entity_name);
291: WSH_DEBUG_SV.log(l_module_name,'p_exception_name',p_exception_name);
292: WSH_DEBUG_SV.log(l_module_name,'p_exception_id',p_exception_id);
293: WSH_DEBUG_SV.log(l_module_name,'p_new_status',p_new_status);
294: END IF;
295:
296: IF NOT FND_API.compatible_api_call (
297: l_api_version,

Line 325: WSH_DEBUG_SV.pop(l_module_name);

321: --
322: -- Debug Statements
323: --
324: IF l_debug_on THEN
325: WSH_DEBUG_SV.pop(l_module_name);
326: END IF;
327: --
328: RETURN;
329: END IF;

Line 337: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_EXCEPTIONS_GRP.GET_EXCEPTIONS',WSH_DEBUG_SV.C_PROC_LEVEL);

333: --
334: -- Debug Statements
335: --
336: IF l_debug_on THEN
337: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_EXCEPTIONS_GRP.GET_EXCEPTIONS',WSH_DEBUG_SV.C_PROC_LEVEL);
338: END IF;
339: --
340: WSH_EXCEPTIONS_GRP.Get_Exceptions (p_api_version => p_api_version,
341: p_init_msg_list => p_init_msg_list,

Line 355: WSH_DEBUG_SV.pop(l_module_name);

351: --
352: -- Debug Statements
353: --
354: IF l_debug_on THEN
355: WSH_DEBUG_SV.pop(l_module_name);
356: END IF;
357: --
358: RETURN;
359: END IF;

Line 385: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.CHANGE_STATUS',WSH_DEBUG_SV.C_PROC_LEVEL);

381: --
382: -- Debug Statements
383: --
384: IF l_debug_on THEN
385: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.CHANGE_STATUS',WSH_DEBUG_SV.C_PROC_LEVEL);
386: END IF;
387: --
388: WSH_XC_UTIL.change_status (p_api_version => p_api_version,
389: p_init_msg_list => p_init_msg_list,

Line 425: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.CHANGE_STATUS',WSH_DEBUG_SV.C_PROC_LEVEL);

421: --
422: -- Debug Statements
423: --
424: IF l_debug_on THEN
425: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.CHANGE_STATUS',WSH_DEBUG_SV.C_PROC_LEVEL);
426: END IF;
427: --
428: WSH_XC_UTIL.change_status (
429: p_api_version => p_api_version,

Line 480: WSH_DEBUG_SV.pop(l_module_name);

476: --
477: -- Debug Statements
478: --
479: IF l_debug_on THEN
480: WSH_DEBUG_SV.pop(l_module_name);
481: END IF;
482: --
483:
484: EXCEPTION

Line 498: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_EXCEPTION_ID exception has occured',WSH_DEBUG_SV.C_EXCEP_LEVEL);

494: --
495: -- Debug Statements
496: --
497: IF l_debug_on THEN
498: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_EXCEPTION_ID exception has occured',WSH_DEBUG_SV.C_EXCEP_LEVEL);
499: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_EXCEPTION_ID');
500: END IF;
501: --
502:

Line 499: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_EXCEPTION_ID');

495: -- Debug Statements
496: --
497: IF l_debug_on THEN
498: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_EXCEPTION_ID exception has occured',WSH_DEBUG_SV.C_EXCEP_LEVEL);
499: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_EXCEPTION_ID');
500: END IF;
501: --
502:
503: WHEN others THEN

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

520: --
521: -- Debug Statements
522: --
523: IF l_debug_on THEN
524: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
525: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
526: END IF;
527: --
528:

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

521: -- Debug Statements
522: --
523: IF l_debug_on THEN
524: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
525: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
526: END IF;
527: --
528:
529: END Change_Status;

Line 636: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

632: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
633: --
634: IF l_debug_on IS NULL
635: THEN
636: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
637: END IF;
638: --
639: --
640: -- Debug Statements

Line 643: WSH_DEBUG_SV.push(l_module_name);

639: --
640: -- Debug Statements
641: --
642: IF l_debug_on THEN
643: WSH_DEBUG_SV.push(l_module_name);
644: --
645: wsh_debug_sv.log(l_module_name,'p_api_version',p_api_version);
646: wsh_debug_sv.log(l_module_name,'p_init_msg_list',p_init_msg_list);
647: wsh_debug_sv.log(l_module_name,'p_validation_level',p_validation_level);

Line 645: wsh_debug_sv.log(l_module_name,'p_api_version',p_api_version);

641: --
642: IF l_debug_on THEN
643: WSH_DEBUG_SV.push(l_module_name);
644: --
645: wsh_debug_sv.log(l_module_name,'p_api_version',p_api_version);
646: wsh_debug_sv.log(l_module_name,'p_init_msg_list',p_init_msg_list);
647: wsh_debug_sv.log(l_module_name,'p_validation_level',p_validation_level);
648: wsh_debug_sv.log(l_module_name,'p_commit',p_commit);
649: wsh_debug_sv.log (l_module_name,'request_id', p_exception_rec.request_id);

Line 646: wsh_debug_sv.log(l_module_name,'p_init_msg_list',p_init_msg_list);

642: IF l_debug_on THEN
643: WSH_DEBUG_SV.push(l_module_name);
644: --
645: wsh_debug_sv.log(l_module_name,'p_api_version',p_api_version);
646: wsh_debug_sv.log(l_module_name,'p_init_msg_list',p_init_msg_list);
647: wsh_debug_sv.log(l_module_name,'p_validation_level',p_validation_level);
648: wsh_debug_sv.log(l_module_name,'p_commit',p_commit);
649: wsh_debug_sv.log (l_module_name,'request_id', p_exception_rec.request_id);
650: wsh_debug_sv.log (l_module_name,'exception_name',

Line 647: wsh_debug_sv.log(l_module_name,'p_validation_level',p_validation_level);

643: WSH_DEBUG_SV.push(l_module_name);
644: --
645: wsh_debug_sv.log(l_module_name,'p_api_version',p_api_version);
646: wsh_debug_sv.log(l_module_name,'p_init_msg_list',p_init_msg_list);
647: wsh_debug_sv.log(l_module_name,'p_validation_level',p_validation_level);
648: wsh_debug_sv.log(l_module_name,'p_commit',p_commit);
649: wsh_debug_sv.log (l_module_name,'request_id', p_exception_rec.request_id);
650: wsh_debug_sv.log (l_module_name,'exception_name',
651: p_exception_rec.exception_name);

Line 648: wsh_debug_sv.log(l_module_name,'p_commit',p_commit);

644: --
645: wsh_debug_sv.log(l_module_name,'p_api_version',p_api_version);
646: wsh_debug_sv.log(l_module_name,'p_init_msg_list',p_init_msg_list);
647: wsh_debug_sv.log(l_module_name,'p_validation_level',p_validation_level);
648: wsh_debug_sv.log(l_module_name,'p_commit',p_commit);
649: wsh_debug_sv.log (l_module_name,'request_id', p_exception_rec.request_id);
650: wsh_debug_sv.log (l_module_name,'exception_name',
651: p_exception_rec.exception_name);
652: wsh_debug_sv.log (l_module_name,'status', p_exception_rec.status);

Line 649: wsh_debug_sv.log (l_module_name,'request_id', p_exception_rec.request_id);

645: wsh_debug_sv.log(l_module_name,'p_api_version',p_api_version);
646: wsh_debug_sv.log(l_module_name,'p_init_msg_list',p_init_msg_list);
647: wsh_debug_sv.log(l_module_name,'p_validation_level',p_validation_level);
648: wsh_debug_sv.log(l_module_name,'p_commit',p_commit);
649: wsh_debug_sv.log (l_module_name,'request_id', p_exception_rec.request_id);
650: wsh_debug_sv.log (l_module_name,'exception_name',
651: p_exception_rec.exception_name);
652: wsh_debug_sv.log (l_module_name,'status', p_exception_rec.status);
653: wsh_debug_sv.log (l_module_name,'logging_entity',

Line 650: wsh_debug_sv.log (l_module_name,'exception_name',

646: wsh_debug_sv.log(l_module_name,'p_init_msg_list',p_init_msg_list);
647: wsh_debug_sv.log(l_module_name,'p_validation_level',p_validation_level);
648: wsh_debug_sv.log(l_module_name,'p_commit',p_commit);
649: wsh_debug_sv.log (l_module_name,'request_id', p_exception_rec.request_id);
650: wsh_debug_sv.log (l_module_name,'exception_name',
651: p_exception_rec.exception_name);
652: wsh_debug_sv.log (l_module_name,'status', p_exception_rec.status);
653: wsh_debug_sv.log (l_module_name,'logging_entity',
654: p_exception_rec.logging_entity);

Line 652: wsh_debug_sv.log (l_module_name,'status', p_exception_rec.status);

648: wsh_debug_sv.log(l_module_name,'p_commit',p_commit);
649: wsh_debug_sv.log (l_module_name,'request_id', p_exception_rec.request_id);
650: wsh_debug_sv.log (l_module_name,'exception_name',
651: p_exception_rec.exception_name);
652: wsh_debug_sv.log (l_module_name,'status', p_exception_rec.status);
653: wsh_debug_sv.log (l_module_name,'logging_entity',
654: p_exception_rec.logging_entity);
655: wsh_debug_sv.log (l_module_name,'logging_entity_id',
656: p_exception_rec.logging_entity_id);

Line 653: wsh_debug_sv.log (l_module_name,'logging_entity',

649: wsh_debug_sv.log (l_module_name,'request_id', p_exception_rec.request_id);
650: wsh_debug_sv.log (l_module_name,'exception_name',
651: p_exception_rec.exception_name);
652: wsh_debug_sv.log (l_module_name,'status', p_exception_rec.status);
653: wsh_debug_sv.log (l_module_name,'logging_entity',
654: p_exception_rec.logging_entity);
655: wsh_debug_sv.log (l_module_name,'logging_entity_id',
656: p_exception_rec.logging_entity_id);
657: wsh_debug_sv.log (l_module_name,'logged_at_location_code',

Line 655: wsh_debug_sv.log (l_module_name,'logging_entity_id',

651: p_exception_rec.exception_name);
652: wsh_debug_sv.log (l_module_name,'status', p_exception_rec.status);
653: wsh_debug_sv.log (l_module_name,'logging_entity',
654: p_exception_rec.logging_entity);
655: wsh_debug_sv.log (l_module_name,'logging_entity_id',
656: p_exception_rec.logging_entity_id);
657: wsh_debug_sv.log (l_module_name,'logged_at_location_code',
658: p_exception_rec.logged_at_location_code);
659: wsh_debug_sv.log (l_module_name,'exception_location_code',

Line 657: wsh_debug_sv.log (l_module_name,'logged_at_location_code',

653: wsh_debug_sv.log (l_module_name,'logging_entity',
654: p_exception_rec.logging_entity);
655: wsh_debug_sv.log (l_module_name,'logging_entity_id',
656: p_exception_rec.logging_entity_id);
657: wsh_debug_sv.log (l_module_name,'logged_at_location_code',
658: p_exception_rec.logged_at_location_code);
659: wsh_debug_sv.log (l_module_name,'exception_location_code',
660: p_exception_rec.exception_location_code);
661: wsh_debug_sv.log (l_module_name,'severity', p_exception_rec.severity);

Line 659: wsh_debug_sv.log (l_module_name,'exception_location_code',

655: wsh_debug_sv.log (l_module_name,'logging_entity_id',
656: p_exception_rec.logging_entity_id);
657: wsh_debug_sv.log (l_module_name,'logged_at_location_code',
658: p_exception_rec.logged_at_location_code);
659: wsh_debug_sv.log (l_module_name,'exception_location_code',
660: p_exception_rec.exception_location_code);
661: wsh_debug_sv.log (l_module_name,'severity', p_exception_rec.severity);
662: wsh_debug_sv.log (l_module_name,'delivery_name', p_exception_rec.delivery_name);
663: wsh_debug_sv.log (l_module_name,'trip_name', p_exception_rec.trip_name);

Line 661: wsh_debug_sv.log (l_module_name,'severity', p_exception_rec.severity);

657: wsh_debug_sv.log (l_module_name,'logged_at_location_code',
658: p_exception_rec.logged_at_location_code);
659: wsh_debug_sv.log (l_module_name,'exception_location_code',
660: p_exception_rec.exception_location_code);
661: wsh_debug_sv.log (l_module_name,'severity', p_exception_rec.severity);
662: wsh_debug_sv.log (l_module_name,'delivery_name', p_exception_rec.delivery_name);
663: wsh_debug_sv.log (l_module_name,'trip_name', p_exception_rec.trip_name);
664: wsh_debug_sv.log (l_module_name,'stop_location_id', p_exception_rec.stop_location_id);
665: wsh_debug_sv.log (l_module_name,'delivery_detail_id', p_exception_rec.delivery_detail_id);

Line 662: wsh_debug_sv.log (l_module_name,'delivery_name', p_exception_rec.delivery_name);

658: p_exception_rec.logged_at_location_code);
659: wsh_debug_sv.log (l_module_name,'exception_location_code',
660: p_exception_rec.exception_location_code);
661: wsh_debug_sv.log (l_module_name,'severity', p_exception_rec.severity);
662: wsh_debug_sv.log (l_module_name,'delivery_name', p_exception_rec.delivery_name);
663: wsh_debug_sv.log (l_module_name,'trip_name', p_exception_rec.trip_name);
664: wsh_debug_sv.log (l_module_name,'stop_location_id', p_exception_rec.stop_location_id);
665: wsh_debug_sv.log (l_module_name,'delivery_detail_id', p_exception_rec.delivery_detail_id);
666: END IF;

Line 663: wsh_debug_sv.log (l_module_name,'trip_name', p_exception_rec.trip_name);

659: wsh_debug_sv.log (l_module_name,'exception_location_code',
660: p_exception_rec.exception_location_code);
661: wsh_debug_sv.log (l_module_name,'severity', p_exception_rec.severity);
662: wsh_debug_sv.log (l_module_name,'delivery_name', p_exception_rec.delivery_name);
663: wsh_debug_sv.log (l_module_name,'trip_name', p_exception_rec.trip_name);
664: wsh_debug_sv.log (l_module_name,'stop_location_id', p_exception_rec.stop_location_id);
665: wsh_debug_sv.log (l_module_name,'delivery_detail_id', p_exception_rec.delivery_detail_id);
666: END IF;
667:

Line 664: wsh_debug_sv.log (l_module_name,'stop_location_id', p_exception_rec.stop_location_id);

660: p_exception_rec.exception_location_code);
661: wsh_debug_sv.log (l_module_name,'severity', p_exception_rec.severity);
662: wsh_debug_sv.log (l_module_name,'delivery_name', p_exception_rec.delivery_name);
663: wsh_debug_sv.log (l_module_name,'trip_name', p_exception_rec.trip_name);
664: wsh_debug_sv.log (l_module_name,'stop_location_id', p_exception_rec.stop_location_id);
665: wsh_debug_sv.log (l_module_name,'delivery_detail_id', p_exception_rec.delivery_detail_id);
666: END IF;
667:
668: IF NOT FND_API.compatible_api_call(

Line 665: wsh_debug_sv.log (l_module_name,'delivery_detail_id', p_exception_rec.delivery_detail_id);

661: wsh_debug_sv.log (l_module_name,'severity', p_exception_rec.severity);
662: wsh_debug_sv.log (l_module_name,'delivery_name', p_exception_rec.delivery_name);
663: wsh_debug_sv.log (l_module_name,'trip_name', p_exception_rec.trip_name);
664: wsh_debug_sv.log (l_module_name,'stop_location_id', p_exception_rec.stop_location_id);
665: wsh_debug_sv.log (l_module_name,'delivery_detail_id', p_exception_rec.delivery_detail_id);
666: END IF;
667:
668: IF NOT FND_API.compatible_api_call(
669: l_api_version,

Line 697: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_LOOKUP to Validate the logging entity',WSH_DEBUG_SV.C_PROC_LEVEL);

693: --
694: -- Debug Statements
695: --
696: IF l_debug_on THEN
697: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_LOOKUP to Validate the logging entity',WSH_DEBUG_SV.C_PROC_LEVEL);
698: END IF;
699: --
700: WSH_UTIL_VALIDATE.Validate_Lookup('LOGGING_ENTITY',l_logging_entity,
701: p_exception_rec.logging_entity,l_return_status);

Line 717: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_LOCATION to Validate the Logged at Location',WSH_DEBUG_SV.C_PROC_LEVEL);

713: --
714: -- Debug Statements
715: --
716: IF l_debug_on THEN
717: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_LOCATION to Validate the Logged at Location',WSH_DEBUG_SV.C_PROC_LEVEL);
718: END IF;
719: --
720: WSH_UTIL_VALIDATE.Validate_Location(
721: p_location_id => l_logged_at_location_id,

Line 739: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_LOCATION to Validate the Exception Location',WSH_DEBUG_SV.C_PROC_LEVEL);

735: --
736: -- Debug Statements
737: --
738: IF l_debug_on THEN
739: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_LOCATION to Validate the Exception Location',WSH_DEBUG_SV.C_PROC_LEVEL);
740: END IF;
741: --
742: WSH_UTIL_VALIDATE.Validate_Location (
743: p_location_id => l_exception_location_id,

Line 761: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_TRIP_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

757: --
758: -- Debug Statements
759: --
760: IF l_debug_on THEN
761: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_TRIP_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
762: END IF;
763: --
764: WSH_UTIL_VALIDATE.Validate_Trip_Name(
765: p_trip_id => l_trip_id,

Line 793: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_DELIVERY_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

789: --
790: -- Debug Statements
791: --
792: IF l_debug_on THEN
793: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_DELIVERY_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
794: END IF;
795: --
796: WSH_UTIL_VALIDATE.Validate_Delivery_Name(
797: p_delivery_id => l_delivery_id,

Line 858: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.VALIDATE_SERIAL',WSH_DEBUG_SV.C_PROC_LEVEL);

854: --
855: -- Debug Statements
856: --
857: IF l_debug_on THEN
858: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.VALIDATE_SERIAL',WSH_DEBUG_SV.C_PROC_LEVEL);
859: END IF;
860: --
861: WSH_DELIVERY_DETAILS_INV.Validate_Serial(
862: p_serial_number => p_exception_rec.serial_number,

Line 885: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.LOG_EXCEPTION',WSH_DEBUG_SV.C_PROC_LEVEL);

881: --
882: -- Debug Statements
883: --
884: IF l_debug_on THEN
885: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.LOG_EXCEPTION',WSH_DEBUG_SV.C_PROC_LEVEL);
886: END IF;
887: --
888: WSH_XC_UTIL.log_exception(
889: p_api_version => p_api_version,

Line 960: WSH_DEBUG_SV.pop(l_module_name);

956: --
957: -- Debug Statements
958: --
959: IF l_debug_on THEN
960: WSH_DEBUG_SV.pop(l_module_name);
961: END IF;
962: --
963:
964: EXCEPTION

Line 981: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_MULTIPLE_CONTAINERS exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

977: p_encoded => FND_API.G_FALSE
978: );
979: --debug messages
980: IF l_debug_on THEN
981: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_MULTIPLE_CONTAINERS exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
982: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_MULTIPLE_CONTAINERS');
983: END IF;
984: --
985: WHEN WSH_XC_INVALID_OPERATION THEN

Line 982: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_MULTIPLE_CONTAINERS');

978: );
979: --debug messages
980: IF l_debug_on THEN
981: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_MULTIPLE_CONTAINERS exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
982: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_MULTIPLE_CONTAINERS');
983: END IF;
984: --
985: WHEN WSH_XC_INVALID_OPERATION THEN
986: FND_MESSAGE.SET_NAME('WSH', 'WSH_XC_INVALID_OPERATION');

Line 999: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_INVALID_OPERATION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

995: --
996: -- Debug Statements
997: --
998: IF l_debug_on THEN
999: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_INVALID_OPERATION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1000: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_INVALID_OPERATION');
1001: END IF;
1002: --
1003:

Line 1000: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_INVALID_OPERATION');

996: -- Debug Statements
997: --
998: IF l_debug_on THEN
999: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_INVALID_OPERATION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1000: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_INVALID_OPERATION');
1001: END IF;
1002: --
1003:
1004: WHEN WSH_XC_LOOKUP_LOG THEN

Line 1018: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_LOOKUP_LOG exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1014: --
1015: -- Debug Statements
1016: --
1017: IF l_debug_on THEN
1018: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_LOOKUP_LOG exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1019: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_LOOKUP_LOG');
1020: END IF;
1021: --
1022:

Line 1019: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_LOOKUP_LOG');

1015: -- Debug Statements
1016: --
1017: IF l_debug_on THEN
1018: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_LOOKUP_LOG exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1019: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_LOOKUP_LOG');
1020: END IF;
1021: --
1022:
1023: WHEN WSH_XC_LOOKUP_SEVERITY THEN

Line 1037: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_LOOKUP_SEVERITY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1033: --
1034: -- Debug Statements
1035: --
1036: IF l_debug_on THEN
1037: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_LOOKUP_SEVERITY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1038: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_LOOKUP_SEVERITY');
1039: END IF;
1040: --
1041:

Line 1038: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_LOOKUP_SEVERITY');

1034: -- Debug Statements
1035: --
1036: IF l_debug_on THEN
1037: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_LOOKUP_SEVERITY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1038: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_LOOKUP_SEVERITY');
1039: END IF;
1040: --
1041:
1042: WHEN WSH_INVALID_TRIPNAME THEN

Line 1056: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_TRIPNAME exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1052: --
1053: -- Debug Statements
1054: --
1055: IF l_debug_on THEN
1056: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_TRIPNAME exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1057: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_TRIPNAME');
1058: END IF;
1059: --
1060:

Line 1057: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_TRIPNAME');

1053: -- Debug Statements
1054: --
1055: IF l_debug_on THEN
1056: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_TRIPNAME exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1057: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_TRIPNAME');
1058: END IF;
1059: --
1060:
1061: WHEN WSH_INVALID_DELIVERY THEN

Line 1075: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_DELIVERY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1071: --
1072: -- Debug Statements
1073: --
1074: IF l_debug_on THEN
1075: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_DELIVERY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1076: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_DELIVERY');
1077: END IF;
1078: --
1079: WHEN WSH_INVALID_CONSOL_DELIVERY THEN

Line 1076: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_DELIVERY');

1072: -- Debug Statements
1073: --
1074: IF l_debug_on THEN
1075: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_DELIVERY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1076: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_DELIVERY');
1077: END IF;
1078: --
1079: WHEN WSH_INVALID_CONSOL_DELIVERY THEN
1080: FND_MESSAGE.SET_NAME('WSH', 'WSH_PUB_CONSOL_DEL_EXP');

Line 1093: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_CONSOL_DELIVERY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1089: --
1090: -- Debug Statements
1091: --
1092: IF l_debug_on THEN
1093: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_CONSOL_DELIVERY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1094: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_CONSOL_DELIVERY');
1095: END IF;
1096: --
1097:

Line 1094: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_CONSOL_DELIVERY');

1090: -- Debug Statements
1091: --
1092: IF l_debug_on THEN
1093: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_CONSOL_DELIVERY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1094: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_CONSOL_DELIVERY');
1095: END IF;
1096: --
1097:
1098: WHEN WSH_INVALID_LOGGED_AT_LOCATION THEN

Line 1111: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_LOGGED_AT_LOCATION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1107: --
1108: -- Debug Statements
1109: --
1110: IF l_debug_on THEN
1111: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_LOGGED_AT_LOCATION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1112: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_LOGGED_AT_LOCATION');
1113: END IF;
1114: --
1115:

Line 1112: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_LOGGED_AT_LOCATION');

1108: -- Debug Statements
1109: --
1110: IF l_debug_on THEN
1111: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_LOGGED_AT_LOCATION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1112: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_LOGGED_AT_LOCATION');
1113: END IF;
1114: --
1115:
1116: WHEN WSH_INVALID_EXCEPTION_LOCATION THEN

Line 1129: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_EXCEPTION_LOCATION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1125: --
1126: -- Debug Statements
1127: --
1128: IF l_debug_on THEN
1129: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_EXCEPTION_LOCATION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1130: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_EXCEPTION_LOCATION');
1131: END IF;
1132: --
1133:

Line 1130: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_EXCEPTION_LOCATION');

1126: -- Debug Statements
1127: --
1128: IF l_debug_on THEN
1129: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_EXCEPTION_LOCATION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1130: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_EXCEPTION_LOCATION');
1131: END IF;
1132: --
1133:
1134: WHEN WSH_XC_INVALID_LOCATION THEN

Line 1150: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_INVALID_LOCATION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1146: --
1147: -- Debug Statements
1148: --
1149: IF l_debug_on THEN
1150: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_INVALID_LOCATION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1151: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_INVALID_LOCATION');
1152: END IF;
1153: --
1154:

Line 1151: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_INVALID_LOCATION');

1147: -- Debug Statements
1148: --
1149: IF l_debug_on THEN
1150: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_INVALID_LOCATION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1151: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_INVALID_LOCATION');
1152: END IF;
1153: --
1154:
1155: WHEN WSH_INVALID_DELIVERY_DETAIL THEN

Line 1172: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_DELIVERY_DETAIL exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1168: --
1169: -- Debug Statements
1170: --
1171: IF l_debug_on THEN
1172: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_DELIVERY_DETAIL exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1173: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_DELIVERY_DETAIL');
1174: END IF;
1175: --
1176:

Line 1173: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_DELIVERY_DETAIL');

1169: -- Debug Statements
1170: --
1171: IF l_debug_on THEN
1172: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_DELIVERY_DETAIL exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1173: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_DELIVERY_DETAIL');
1174: END IF;
1175: --
1176:
1177: WHEN WSH_INVALID_CONTAINER_NAME THEN

Line 1194: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_CONTAINER_NAME exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1190: --
1191: -- Debug Statements
1192: --
1193: IF l_debug_on THEN
1194: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_CONTAINER_NAME exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1195: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_CONTAINER_NAME');
1196: END IF;
1197: --
1198:

Line 1195: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_CONTAINER_NAME');

1191: -- Debug Statements
1192: --
1193: IF l_debug_on THEN
1194: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_CONTAINER_NAME exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1195: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_CONTAINER_NAME');
1196: END IF;
1197: --
1198:
1199: WHEN WSH_INVALID_INVENTORY_CONTROL THEN

Line 1205: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_INVENTORY_CONTROL exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1201: --
1202: -- Debug Statements
1203: --
1204: IF l_debug_on THEN
1205: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_INVENTORY_CONTROL exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1206: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_INVENTORY_CONTROL');
1207: END IF;
1208: --
1209:

Line 1206: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_INVENTORY_CONTROL');

1202: -- Debug Statements
1203: --
1204: IF l_debug_on THEN
1205: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_INVENTORY_CONTROL exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1206: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_INVENTORY_CONTROL');
1207: END IF;
1208: --
1209:
1210: WHEN WSH_XC_INVALID_DATE THEN

Line 1223: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_INVALID_DATE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1219: --
1220: -- Debug Statements
1221: --
1222: IF l_debug_on THEN
1223: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_INVALID_DATE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1224: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_INVALID_DATE');
1225: END IF;
1226: --
1227:

Line 1224: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_INVALID_DATE');

1220: -- Debug Statements
1221: --
1222: IF l_debug_on THEN
1223: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_INVALID_DATE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1224: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_INVALID_DATE');
1225: END IF;
1226: --
1227:
1228: WHEN OTHERS THEN

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

1245: --
1246: -- Debug Statements
1247: --
1248: IF l_debug_on THEN
1249: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1250: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1251: END IF;
1252: --
1253:

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

1246: -- Debug Statements
1247: --
1248: IF l_debug_on THEN
1249: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1250: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1251: END IF;
1252: --
1253:
1254: END Log_Exception;

Line 1345: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1341: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1342: --
1343: IF l_debug_on IS NULL
1344: THEN
1345: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1346: END IF;
1347: --
1348: --
1349: -- Debug Statements

Line 1352: wsh_debug_sv.push(l_module_name);

1348: --
1349: -- Debug Statements
1350: --
1351: IF l_debug_on THEN
1352: wsh_debug_sv.push(l_module_name);
1353: --
1354: wsh_debug_sv.log(l_module_name,'p_api_version',p_api_version);
1355: wsh_debug_sv.log(l_module_name,'p_init_msg_list',p_init_msg_list);
1356: wsh_debug_sv.log(l_module_name,'p_validation_level',p_validation_level);

Line 1354: wsh_debug_sv.log(l_module_name,'p_api_version',p_api_version);

1350: --
1351: IF l_debug_on THEN
1352: wsh_debug_sv.push(l_module_name);
1353: --
1354: wsh_debug_sv.log(l_module_name,'p_api_version',p_api_version);
1355: wsh_debug_sv.log(l_module_name,'p_init_msg_list',p_init_msg_list);
1356: wsh_debug_sv.log(l_module_name,'p_validation_level',p_validation_level);
1357: wsh_debug_sv.log(l_module_name,'p_commit',p_commit);
1358: wsh_debug_sv.log(l_module_name,'p_action',p_action);

Line 1355: wsh_debug_sv.log(l_module_name,'p_init_msg_list',p_init_msg_list);

1351: IF l_debug_on THEN
1352: wsh_debug_sv.push(l_module_name);
1353: --
1354: wsh_debug_sv.log(l_module_name,'p_api_version',p_api_version);
1355: wsh_debug_sv.log(l_module_name,'p_init_msg_list',p_init_msg_list);
1356: wsh_debug_sv.log(l_module_name,'p_validation_level',p_validation_level);
1357: wsh_debug_sv.log(l_module_name,'p_commit',p_commit);
1358: wsh_debug_sv.log(l_module_name,'p_action',p_action);
1359: wsh_debug_sv.log (l_module_name,'request_id', p_exception_rec.request_id);

Line 1356: wsh_debug_sv.log(l_module_name,'p_validation_level',p_validation_level);

1352: wsh_debug_sv.push(l_module_name);
1353: --
1354: wsh_debug_sv.log(l_module_name,'p_api_version',p_api_version);
1355: wsh_debug_sv.log(l_module_name,'p_init_msg_list',p_init_msg_list);
1356: wsh_debug_sv.log(l_module_name,'p_validation_level',p_validation_level);
1357: wsh_debug_sv.log(l_module_name,'p_commit',p_commit);
1358: wsh_debug_sv.log(l_module_name,'p_action',p_action);
1359: wsh_debug_sv.log (l_module_name,'request_id', p_exception_rec.request_id);
1360: wsh_debug_sv.log (l_module_name,'exception_id',

Line 1357: wsh_debug_sv.log(l_module_name,'p_commit',p_commit);

1353: --
1354: wsh_debug_sv.log(l_module_name,'p_api_version',p_api_version);
1355: wsh_debug_sv.log(l_module_name,'p_init_msg_list',p_init_msg_list);
1356: wsh_debug_sv.log(l_module_name,'p_validation_level',p_validation_level);
1357: wsh_debug_sv.log(l_module_name,'p_commit',p_commit);
1358: wsh_debug_sv.log(l_module_name,'p_action',p_action);
1359: wsh_debug_sv.log (l_module_name,'request_id', p_exception_rec.request_id);
1360: wsh_debug_sv.log (l_module_name,'exception_id',
1361: p_exception_rec.exception_id);

Line 1358: wsh_debug_sv.log(l_module_name,'p_action',p_action);

1354: wsh_debug_sv.log(l_module_name,'p_api_version',p_api_version);
1355: wsh_debug_sv.log(l_module_name,'p_init_msg_list',p_init_msg_list);
1356: wsh_debug_sv.log(l_module_name,'p_validation_level',p_validation_level);
1357: wsh_debug_sv.log(l_module_name,'p_commit',p_commit);
1358: wsh_debug_sv.log(l_module_name,'p_action',p_action);
1359: wsh_debug_sv.log (l_module_name,'request_id', p_exception_rec.request_id);
1360: wsh_debug_sv.log (l_module_name,'exception_id',
1361: p_exception_rec.exception_id);
1362: wsh_debug_sv.log (l_module_name,'exception_name',

Line 1359: wsh_debug_sv.log (l_module_name,'request_id', p_exception_rec.request_id);

1355: wsh_debug_sv.log(l_module_name,'p_init_msg_list',p_init_msg_list);
1356: wsh_debug_sv.log(l_module_name,'p_validation_level',p_validation_level);
1357: wsh_debug_sv.log(l_module_name,'p_commit',p_commit);
1358: wsh_debug_sv.log(l_module_name,'p_action',p_action);
1359: wsh_debug_sv.log (l_module_name,'request_id', p_exception_rec.request_id);
1360: wsh_debug_sv.log (l_module_name,'exception_id',
1361: p_exception_rec.exception_id);
1362: wsh_debug_sv.log (l_module_name,'exception_name',
1363: p_exception_rec.exception_name);

Line 1360: wsh_debug_sv.log (l_module_name,'exception_id',

1356: wsh_debug_sv.log(l_module_name,'p_validation_level',p_validation_level);
1357: wsh_debug_sv.log(l_module_name,'p_commit',p_commit);
1358: wsh_debug_sv.log(l_module_name,'p_action',p_action);
1359: wsh_debug_sv.log (l_module_name,'request_id', p_exception_rec.request_id);
1360: wsh_debug_sv.log (l_module_name,'exception_id',
1361: p_exception_rec.exception_id);
1362: wsh_debug_sv.log (l_module_name,'exception_name',
1363: p_exception_rec.exception_name);
1364: wsh_debug_sv.log (l_module_name,'status', p_exception_rec.status);

Line 1362: wsh_debug_sv.log (l_module_name,'exception_name',

1358: wsh_debug_sv.log(l_module_name,'p_action',p_action);
1359: wsh_debug_sv.log (l_module_name,'request_id', p_exception_rec.request_id);
1360: wsh_debug_sv.log (l_module_name,'exception_id',
1361: p_exception_rec.exception_id);
1362: wsh_debug_sv.log (l_module_name,'exception_name',
1363: p_exception_rec.exception_name);
1364: wsh_debug_sv.log (l_module_name,'status', p_exception_rec.status);
1365: wsh_debug_sv.log (l_module_name,'logging_entity',
1366: p_exception_rec.logging_entity);

Line 1364: wsh_debug_sv.log (l_module_name,'status', p_exception_rec.status);

1360: wsh_debug_sv.log (l_module_name,'exception_id',
1361: p_exception_rec.exception_id);
1362: wsh_debug_sv.log (l_module_name,'exception_name',
1363: p_exception_rec.exception_name);
1364: wsh_debug_sv.log (l_module_name,'status', p_exception_rec.status);
1365: wsh_debug_sv.log (l_module_name,'logging_entity',
1366: p_exception_rec.logging_entity);
1367: wsh_debug_sv.log (l_module_name,'logged_at_location_code',
1368: p_exception_rec.logged_at_location_code);

Line 1365: wsh_debug_sv.log (l_module_name,'logging_entity',

1361: p_exception_rec.exception_id);
1362: wsh_debug_sv.log (l_module_name,'exception_name',
1363: p_exception_rec.exception_name);
1364: wsh_debug_sv.log (l_module_name,'status', p_exception_rec.status);
1365: wsh_debug_sv.log (l_module_name,'logging_entity',
1366: p_exception_rec.logging_entity);
1367: wsh_debug_sv.log (l_module_name,'logged_at_location_code',
1368: p_exception_rec.logged_at_location_code);
1369: wsh_debug_sv.log (l_module_name,'exception_location_code',

Line 1367: wsh_debug_sv.log (l_module_name,'logged_at_location_code',

1363: p_exception_rec.exception_name);
1364: wsh_debug_sv.log (l_module_name,'status', p_exception_rec.status);
1365: wsh_debug_sv.log (l_module_name,'logging_entity',
1366: p_exception_rec.logging_entity);
1367: wsh_debug_sv.log (l_module_name,'logged_at_location_code',
1368: p_exception_rec.logged_at_location_code);
1369: wsh_debug_sv.log (l_module_name,'exception_location_code',
1370: p_exception_rec.exception_location_code);
1371: wsh_debug_sv.log (l_module_name,'severity', p_exception_rec.severity);

Line 1369: wsh_debug_sv.log (l_module_name,'exception_location_code',

1365: wsh_debug_sv.log (l_module_name,'logging_entity',
1366: p_exception_rec.logging_entity);
1367: wsh_debug_sv.log (l_module_name,'logged_at_location_code',
1368: p_exception_rec.logged_at_location_code);
1369: wsh_debug_sv.log (l_module_name,'exception_location_code',
1370: p_exception_rec.exception_location_code);
1371: wsh_debug_sv.log (l_module_name,'severity', p_exception_rec.severity);
1372: wsh_debug_sv.log (l_module_name,'delivery_name', p_exception_rec.delivery_name);
1373: wsh_debug_sv.log (l_module_name,'data_older_no_of_days', p_exception_rec.data_older_no_of_days);

Line 1371: wsh_debug_sv.log (l_module_name,'severity', p_exception_rec.severity);

1367: wsh_debug_sv.log (l_module_name,'logged_at_location_code',
1368: p_exception_rec.logged_at_location_code);
1369: wsh_debug_sv.log (l_module_name,'exception_location_code',
1370: p_exception_rec.exception_location_code);
1371: wsh_debug_sv.log (l_module_name,'severity', p_exception_rec.severity);
1372: wsh_debug_sv.log (l_module_name,'delivery_name', p_exception_rec.delivery_name);
1373: wsh_debug_sv.log (l_module_name,'data_older_no_of_days', p_exception_rec.data_older_no_of_days);
1374: END IF;
1375:

Line 1372: wsh_debug_sv.log (l_module_name,'delivery_name', p_exception_rec.delivery_name);

1368: p_exception_rec.logged_at_location_code);
1369: wsh_debug_sv.log (l_module_name,'exception_location_code',
1370: p_exception_rec.exception_location_code);
1371: wsh_debug_sv.log (l_module_name,'severity', p_exception_rec.severity);
1372: wsh_debug_sv.log (l_module_name,'delivery_name', p_exception_rec.delivery_name);
1373: wsh_debug_sv.log (l_module_name,'data_older_no_of_days', p_exception_rec.data_older_no_of_days);
1374: END IF;
1375:
1376: IF NOT FND_API.compatible_api_call (

Line 1373: wsh_debug_sv.log (l_module_name,'data_older_no_of_days', p_exception_rec.data_older_no_of_days);

1369: wsh_debug_sv.log (l_module_name,'exception_location_code',
1370: p_exception_rec.exception_location_code);
1371: wsh_debug_sv.log (l_module_name,'severity', p_exception_rec.severity);
1372: wsh_debug_sv.log (l_module_name,'delivery_name', p_exception_rec.delivery_name);
1373: wsh_debug_sv.log (l_module_name,'data_older_no_of_days', p_exception_rec.data_older_no_of_days);
1374: END IF;
1375:
1376: IF NOT FND_API.compatible_api_call (
1377: l_api_version,

Line 1438: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_LOOKUP to Validate the loggint entity',WSH_DEBUG_SV.C_PROC_LEVEL);

1434: --
1435: -- Debug Statements
1436: --
1437: IF l_debug_on THEN
1438: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_LOOKUP to Validate the loggint entity',WSH_DEBUG_SV.C_PROC_LEVEL);
1439: END IF;
1440: --
1441: WSH_UTIL_VALIDATE.Validate_Lookup('LOGGING_ENTITY',l_logging_entity,
1442: p_exception_rec.logging_entity,l_return_status);

Line 1458: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_LOOKUPto Validate the Exception Type',WSH_DEBUG_SV.C_PROC_LEVEL);

1454: --
1455: -- Debug Statements
1456: --
1457: IF l_debug_on THEN
1458: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_LOOKUPto Validate the Exception Type',WSH_DEBUG_SV.C_PROC_LEVEL);
1459: END IF;
1460: --
1461: WSH_UTIL_VALIDATE.Validate_Lookup('EXCEPTION_TYPE',l_exception_type,
1462: p_exception_rec.exception_type,l_return_status);

Line 1478: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_LOOKUPto Validate the Severity',WSH_DEBUG_SV.C_PROC_LEVEL);

1474: --
1475: -- Debug Statements
1476: --
1477: IF l_debug_on THEN
1478: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_LOOKUPto Validate the Severity',WSH_DEBUG_SV.C_PROC_LEVEL);
1479: END IF;
1480: --
1481: WSH_UTIL_VALIDATE.Validate_Lookup('EXCEPTION_BEHAVIOR',l_severity,
1482: p_exception_rec.severity,l_return_status);

Line 1498: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_LOCATION to Validate the Logged at Location',WSH_DEBUG_SV.C_PROC_LEVEL);

1494: --
1495: -- Debug Statements
1496: --
1497: IF l_debug_on THEN
1498: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_LOCATION to Validate the Logged at Location',WSH_DEBUG_SV.C_PROC_LEVEL);
1499: END IF;
1500: --
1501: WSH_UTIL_VALIDATE.Validate_Location(l_logged_at_location_id,
1502: p_exception_rec.logged_at_location_code,l_return_status);

Line 1518: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_LOCATION to Validate Exception Location',WSH_DEBUG_SV.C_PROC_LEVEL);

1514: --
1515: -- Debug Statements
1516: --
1517: IF l_debug_on THEN
1518: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_LOCATION to Validate Exception Location',WSH_DEBUG_SV.C_PROC_LEVEL);
1519: END IF;
1520: --
1521: WSH_UTIL_VALIDATE.Validate_Location(l_exception_location_id,
1522: p_exception_rec.exception_location_code,l_return_status);

Line 1538: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_DELIVERY_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

1534: --
1535: -- Debug Statements
1536: --
1537: IF l_debug_on THEN
1538: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_DELIVERY_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1539: END IF;
1540: --
1541: WSH_UTIL_VALIDATE.Validate_Delivery_Name(l_delivery_id,
1542: p_exception_rec.delivery_name,l_return_status);

Line 1564: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.PURGE',WSH_DEBUG_SV.C_PROC_LEVEL);

1560: --
1561: -- Debug Statements
1562: --
1563: IF l_debug_on THEN
1564: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.PURGE',WSH_DEBUG_SV.C_PROC_LEVEL);
1565: END IF;
1566: --
1567: WSH_XC_UTIL.Purge(
1568: p_api_version => p_api_version,

Line 1615: WSH_DEBUG_SV.pop(l_module_name);

1611: --
1612: -- Debug Statements
1613: --
1614: IF l_debug_on THEN
1615: WSH_DEBUG_SV.pop(l_module_name);
1616: END IF;
1617: --
1618:
1619: EXCEPTION

Line 1636: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_NOT_FOUND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1632: --
1633: -- Debug Statements
1634: --
1635: IF l_debug_on THEN
1636: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_NOT_FOUND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1637: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_NOT_FOUND');
1638: END IF;
1639: --
1640:

Line 1637: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_NOT_FOUND');

1633: -- Debug Statements
1634: --
1635: IF l_debug_on THEN
1636: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_NOT_FOUND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1637: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_NOT_FOUND');
1638: END IF;
1639: --
1640:
1641: WHEN WSH_XC_INVALID_STATUS THEN

Line 1654: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_INVALID_STATUS exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1650: --
1651: -- Debug Statements
1652: --
1653: IF l_debug_on THEN
1654: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_INVALID_STATUS exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1655: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_INVALID_STATUS');
1656: END IF;
1657: --
1658:

Line 1655: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_INVALID_STATUS');

1651: -- Debug Statements
1652: --
1653: IF l_debug_on THEN
1654: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_INVALID_STATUS exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1655: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_INVALID_STATUS');
1656: END IF;
1657: --
1658:
1659: WHEN WSH_PURGE_NOT_ALLOWED THEN

Line 1672: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_PURGE_NOT_ALLOWED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1668: --
1669: -- Debug Statements
1670: --
1671: IF l_debug_on THEN
1672: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_PURGE_NOT_ALLOWED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1673: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_PURGE_NOT_ALLOWED');
1674: END IF;
1675: --
1676:

Line 1673: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_PURGE_NOT_ALLOWED');

1669: -- Debug Statements
1670: --
1671: IF l_debug_on THEN
1672: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_PURGE_NOT_ALLOWED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1673: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_PURGE_NOT_ALLOWED');
1674: END IF;
1675: --
1676:
1677: WHEN WSH_XC_INVALID_DATE_RANGE THEN

Line 1690: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_INVALID_DATE_RANGE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1686: --
1687: -- Debug Statements
1688: --
1689: IF l_debug_on THEN
1690: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_INVALID_DATE_RANGE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1691: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_INVALID_DATE_RANGE');
1692: END IF;
1693: --
1694:

Line 1691: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_INVALID_DATE_RANGE');

1687: -- Debug Statements
1688: --
1689: IF l_debug_on THEN
1690: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_INVALID_DATE_RANGE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1691: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_INVALID_DATE_RANGE');
1692: END IF;
1693: --
1694:
1695: WHEN WSH_XC_INVALID_OPERATION THEN

Line 1709: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_INVALID_OPERATION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1705: --
1706: -- Debug Statements
1707: --
1708: IF l_debug_on THEN
1709: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_INVALID_OPERATION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1710: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_INVALID_OPERATION');
1711: END IF;
1712: --
1713:

Line 1710: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_INVALID_OPERATION');

1706: -- Debug Statements
1707: --
1708: IF l_debug_on THEN
1709: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_INVALID_OPERATION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1710: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_INVALID_OPERATION');
1711: END IF;
1712: --
1713:
1714: WHEN WSH_XC_LOOKUP_LOG THEN

Line 1728: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_LOOKUP_LOG exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1724: --
1725: -- Debug Statements
1726: --
1727: IF l_debug_on THEN
1728: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_LOOKUP_LOG exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1729: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_LOOKUP_LOG');
1730: END IF;
1731: --
1732:

Line 1729: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_LOOKUP_LOG');

1725: -- Debug Statements
1726: --
1727: IF l_debug_on THEN
1728: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_LOOKUP_LOG exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1729: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_LOOKUP_LOG');
1730: END IF;
1731: --
1732:
1733: WHEN WSH_XC_LOOKUP_EXCEPTION THEN

Line 1747: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_LOOKUP_EXCEPTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1743: --
1744: -- Debug Statements
1745: --
1746: IF l_debug_on THEN
1747: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_LOOKUP_EXCEPTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1748: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_LOOKUP_EXCEPTION');
1749: END IF;
1750: --
1751:

Line 1748: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_LOOKUP_EXCEPTION');

1744: -- Debug Statements
1745: --
1746: IF l_debug_on THEN
1747: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_LOOKUP_EXCEPTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1748: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_LOOKUP_EXCEPTION');
1749: END IF;
1750: --
1751:
1752: WHEN WSH_XC_LOOKUP_SEVERITY THEN

Line 1766: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_LOOKUP_SEVERITY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1762: --
1763: -- Debug Statements
1764: --
1765: IF l_debug_on THEN
1766: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_LOOKUP_SEVERITY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1767: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_LOOKUP_SEVERITY');
1768: END IF;
1769: --
1770:

Line 1767: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_LOOKUP_SEVERITY');

1763: -- Debug Statements
1764: --
1765: IF l_debug_on THEN
1766: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_LOOKUP_SEVERITY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1767: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_LOOKUP_SEVERITY');
1768: END IF;
1769: --
1770:
1771: WHEN WSH_INVALID_LOGGED_AT_LOCATION THEN

Line 1784: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_LOGGED_AT_LOCATION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1780: --
1781: -- Debug Statements
1782: --
1783: IF l_debug_on THEN
1784: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_LOGGED_AT_LOCATION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1785: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_LOGGED_AT_LOCATION');
1786: END IF;
1787: --
1788:

Line 1785: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_LOGGED_AT_LOCATION');

1781: -- Debug Statements
1782: --
1783: IF l_debug_on THEN
1784: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_LOGGED_AT_LOCATION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1785: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_LOGGED_AT_LOCATION');
1786: END IF;
1787: --
1788:
1789: WHEN WSH_INVALID_EXCEPTION_LOCATION THEN

Line 1802: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_EXCEPTION_LOCATION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1798: --
1799: -- Debug Statements
1800: --
1801: IF l_debug_on THEN
1802: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_EXCEPTION_LOCATION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1803: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_EXCEPTION_LOCATION');
1804: END IF;
1805: --
1806:

Line 1803: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_EXCEPTION_LOCATION');

1799: -- Debug Statements
1800: --
1801: IF l_debug_on THEN
1802: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_EXCEPTION_LOCATION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1803: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_EXCEPTION_LOCATION');
1804: END IF;
1805: --
1806:
1807: WHEN WSH_XC_INVALID_DELIVERY THEN

Line 1820: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_INVALID_DELIVERY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1816: --
1817: -- Debug Statements
1818: --
1819: IF l_debug_on THEN
1820: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_INVALID_DELIVERY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1821: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_INVALID_DELIVERY');
1822: END IF;
1823: --
1824:

Line 1821: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_INVALID_DELIVERY');

1817: -- Debug Statements
1818: --
1819: IF l_debug_on THEN
1820: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_INVALID_DELIVERY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1821: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_INVALID_DELIVERY');
1822: END IF;
1823: --
1824:
1825: WHEN OTHERS THEN

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

1841: --
1842: -- Debug Statements
1843: --
1844: IF l_debug_on THEN
1845: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1846: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1847: END IF;
1848: --
1849:

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

1842: -- Debug Statements
1843: --
1844: IF l_debug_on THEN
1845: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1846: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1847: END IF;
1848: --
1849:
1850: END Purge_Exception;

Line 1901: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1897: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1898: --
1899: IF l_debug_on IS NULL
1900: THEN
1901: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1902: END IF;
1903: --
1904: --
1905: -- Debug Statements

Line 1908: WSH_DEBUG_SV.push(l_module_name);

1904: --
1905: -- Debug Statements
1906: --
1907: IF l_debug_on THEN
1908: WSH_DEBUG_SV.push(l_module_name);
1909: --
1910: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
1911: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1912: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);

Line 1910: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);

1906: --
1907: IF l_debug_on THEN
1908: WSH_DEBUG_SV.push(l_module_name);
1909: --
1910: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
1911: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1912: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
1913: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1914: WSH_DEBUG_SV.log(l_module_name,'P_ACTION',P_ACTION);

Line 1911: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);

1907: IF l_debug_on THEN
1908: WSH_DEBUG_SV.push(l_module_name);
1909: --
1910: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
1911: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1912: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
1913: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1914: WSH_DEBUG_SV.log(l_module_name,'P_ACTION',P_ACTION);
1915: END IF;

Line 1912: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);

1908: WSH_DEBUG_SV.push(l_module_name);
1909: --
1910: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
1911: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1912: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
1913: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1914: WSH_DEBUG_SV.log(l_module_name,'P_ACTION',P_ACTION);
1915: END IF;
1916:

Line 1913: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);

1909: --
1910: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
1911: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1912: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
1913: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1914: WSH_DEBUG_SV.log(l_module_name,'P_ACTION',P_ACTION);
1915: END IF;
1916:
1917: IF NOT FND_API.compatible_api_call(

Line 1914: WSH_DEBUG_SV.log(l_module_name,'P_ACTION',P_ACTION);

1910: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
1911: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1912: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
1913: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1914: WSH_DEBUG_SV.log(l_module_name,'P_ACTION',P_ACTION);
1915: END IF;
1916:
1917: IF NOT FND_API.compatible_api_call(
1918: l_api_version,

Line 1976: WSH_DEBUG_SV.logmsg(l_module_name,'Calling Purge API to CLOSE exception ',WSH_DEBUG_SV.C_STMT_LEVEL);

1972:
1973: --9612571 - Calling Purge API to CLOSE the exceptions if logging entity and logging entity id is NULL
1974: IF ( nvl (p_exception_rec.logging_entity_id, -1) = -1 AND nvl (p_exception_rec.logging_entity,'None') ='None') THEN
1975:
1976: WSH_DEBUG_SV.logmsg(l_module_name,'Calling Purge API to CLOSE exception ',WSH_DEBUG_SV.C_STMT_LEVEL);
1977:
1978: WSH_XC_UTIL.purge (
1979: p_api_version => p_api_version,
1980: p_init_msg_list => p_init_msg_list,

Line 2041: WSH_DEBUG_SV.pop(l_module_name);

2037: --
2038: -- Debug Statements
2039: --
2040: IF l_debug_on THEN
2041: WSH_DEBUG_SV.pop(l_module_name);
2042: END IF;
2043: --
2044:
2045: EXCEPTION

Line 2060: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_ACTION_CODE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

2056: --
2057: -- Debug Statements
2058: --
2059: IF l_debug_on THEN
2060: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_ACTION_CODE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2061: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_ACTION_CODE');
2062: END IF;
2063: --
2064:

Line 2061: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_ACTION_CODE');

2057: -- Debug Statements
2058: --
2059: IF l_debug_on THEN
2060: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_ACTION_CODE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2061: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_ACTION_CODE');
2062: END IF;
2063: --
2064:
2065: WHEN OTHERS THEN

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

2081: --
2082: -- Debug Statements
2083: --
2084: IF l_debug_on THEN
2085: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2086: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2087: END IF;
2088: --
2089:

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

2082: -- Debug Statements
2083: --
2084: IF l_debug_on THEN
2085: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2086: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2087: END IF;
2088: --
2089:
2090: END Exception_Action;