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

Line 91: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

87: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
88: --
89: IF l_debug_on IS NULL
90: THEN
91: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
92: END IF;
93: --
94: IF l_debug_on THEN
95: wsh_debug_sv.push (l_module_name);

Line 95: wsh_debug_sv.push (l_module_name);

91: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
92: END IF;
93: --
94: IF l_debug_on THEN
95: wsh_debug_sv.push (l_module_name);
96: wsh_debug_sv.log (l_module_name,'p_api_version_number',
97: p_api_version_number);
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_commit', p_commit);

Line 96: wsh_debug_sv.log (l_module_name,'p_api_version_number',

92: END IF;
93: --
94: IF l_debug_on THEN
95: wsh_debug_sv.push (l_module_name);
96: wsh_debug_sv.log (l_module_name,'p_api_version_number',
97: p_api_version_number);
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_commit', p_commit);
100: wsh_debug_sv.log (l_module_name,'p_action_code', p_action_code);

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: wsh_debug_sv.log (l_module_name,'p_api_version_number',
97: p_api_version_number);
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_commit', p_commit);
100: wsh_debug_sv.log (l_module_name,'p_action_code', p_action_code);
101: wsh_debug_sv.log (l_module_name,'p_stop_id', p_stop_id);
102: wsh_debug_sv.log (l_module_name,'p_trip_id', p_trip_id);

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

95: wsh_debug_sv.push (l_module_name);
96: wsh_debug_sv.log (l_module_name,'p_api_version_number',
97: p_api_version_number);
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_commit', p_commit);
100: wsh_debug_sv.log (l_module_name,'p_action_code', p_action_code);
101: wsh_debug_sv.log (l_module_name,'p_stop_id', p_stop_id);
102: wsh_debug_sv.log (l_module_name,'p_trip_id', p_trip_id);
103: wsh_debug_sv.log (l_module_name,'p_trip_name', p_trip_name);

Line 100: wsh_debug_sv.log (l_module_name,'p_action_code', p_action_code);

96: wsh_debug_sv.log (l_module_name,'p_api_version_number',
97: p_api_version_number);
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_commit', p_commit);
100: wsh_debug_sv.log (l_module_name,'p_action_code', p_action_code);
101: wsh_debug_sv.log (l_module_name,'p_stop_id', p_stop_id);
102: wsh_debug_sv.log (l_module_name,'p_trip_id', p_trip_id);
103: wsh_debug_sv.log (l_module_name,'p_trip_name', p_trip_name);
104: wsh_debug_sv.log (l_module_name,'p_stop_location_id',

Line 101: wsh_debug_sv.log (l_module_name,'p_stop_id', p_stop_id);

97: p_api_version_number);
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_commit', p_commit);
100: wsh_debug_sv.log (l_module_name,'p_action_code', p_action_code);
101: wsh_debug_sv.log (l_module_name,'p_stop_id', p_stop_id);
102: wsh_debug_sv.log (l_module_name,'p_trip_id', p_trip_id);
103: wsh_debug_sv.log (l_module_name,'p_trip_name', p_trip_name);
104: wsh_debug_sv.log (l_module_name,'p_stop_location_id',
105: p_stop_location_id);

Line 102: wsh_debug_sv.log (l_module_name,'p_trip_id', p_trip_id);

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_commit', p_commit);
100: wsh_debug_sv.log (l_module_name,'p_action_code', p_action_code);
101: wsh_debug_sv.log (l_module_name,'p_stop_id', p_stop_id);
102: wsh_debug_sv.log (l_module_name,'p_trip_id', p_trip_id);
103: wsh_debug_sv.log (l_module_name,'p_trip_name', p_trip_name);
104: wsh_debug_sv.log (l_module_name,'p_stop_location_id',
105: p_stop_location_id);
106: wsh_debug_sv.log (l_module_name,'p_stop_location_code',

Line 103: wsh_debug_sv.log (l_module_name,'p_trip_name', p_trip_name);

99: wsh_debug_sv.log (l_module_name,'p_commit', p_commit);
100: wsh_debug_sv.log (l_module_name,'p_action_code', p_action_code);
101: wsh_debug_sv.log (l_module_name,'p_stop_id', p_stop_id);
102: wsh_debug_sv.log (l_module_name,'p_trip_id', p_trip_id);
103: wsh_debug_sv.log (l_module_name,'p_trip_name', p_trip_name);
104: wsh_debug_sv.log (l_module_name,'p_stop_location_id',
105: p_stop_location_id);
106: wsh_debug_sv.log (l_module_name,'p_stop_location_code',
107: p_stop_location_code);

Line 104: wsh_debug_sv.log (l_module_name,'p_stop_location_id',

100: wsh_debug_sv.log (l_module_name,'p_action_code', p_action_code);
101: wsh_debug_sv.log (l_module_name,'p_stop_id', p_stop_id);
102: wsh_debug_sv.log (l_module_name,'p_trip_id', p_trip_id);
103: wsh_debug_sv.log (l_module_name,'p_trip_name', p_trip_name);
104: wsh_debug_sv.log (l_module_name,'p_stop_location_id',
105: p_stop_location_id);
106: wsh_debug_sv.log (l_module_name,'p_stop_location_code',
107: p_stop_location_code);
108: wsh_debug_sv.log (l_module_name,'p_planned_dep_date',

Line 106: wsh_debug_sv.log (l_module_name,'p_stop_location_code',

102: wsh_debug_sv.log (l_module_name,'p_trip_id', p_trip_id);
103: wsh_debug_sv.log (l_module_name,'p_trip_name', p_trip_name);
104: wsh_debug_sv.log (l_module_name,'p_stop_location_id',
105: p_stop_location_id);
106: wsh_debug_sv.log (l_module_name,'p_stop_location_code',
107: p_stop_location_code);
108: wsh_debug_sv.log (l_module_name,'p_planned_dep_date',
109: p_planned_dep_date);
110: wsh_debug_sv.log (l_module_name,'p_actual_date', p_actual_date);

Line 108: wsh_debug_sv.log (l_module_name,'p_planned_dep_date',

104: wsh_debug_sv.log (l_module_name,'p_stop_location_id',
105: p_stop_location_id);
106: wsh_debug_sv.log (l_module_name,'p_stop_location_code',
107: p_stop_location_code);
108: wsh_debug_sv.log (l_module_name,'p_planned_dep_date',
109: p_planned_dep_date);
110: wsh_debug_sv.log (l_module_name,'p_actual_date', p_actual_date);
111: wsh_debug_sv.log (l_module_name,'p_defer_interface_flag',
112: p_defer_interface_flag);

Line 110: wsh_debug_sv.log (l_module_name,'p_actual_date', p_actual_date);

106: wsh_debug_sv.log (l_module_name,'p_stop_location_code',
107: p_stop_location_code);
108: wsh_debug_sv.log (l_module_name,'p_planned_dep_date',
109: p_planned_dep_date);
110: wsh_debug_sv.log (l_module_name,'p_actual_date', p_actual_date);
111: wsh_debug_sv.log (l_module_name,'p_defer_interface_flag',
112: p_defer_interface_flag);
113: END IF;
114:

Line 111: wsh_debug_sv.log (l_module_name,'p_defer_interface_flag',

107: p_stop_location_code);
108: wsh_debug_sv.log (l_module_name,'p_planned_dep_date',
109: p_planned_dep_date);
110: wsh_debug_sv.log (l_module_name,'p_actual_date', p_actual_date);
111: wsh_debug_sv.log (l_module_name,'p_defer_interface_flag',
112: p_defer_interface_flag);
113: END IF;
114:
115: -- Standard call to check for call compatibility

Line 194: wsh_debug_sv.log (l_module_name,'Committing Transaction');

190: IF FND_API.TO_BOOLEAN(p_commit)
191: THEN
192: IF l_debug_on
193: THEN
194: wsh_debug_sv.log (l_module_name,'Committing Transaction');
195: END IF;
196: COMMIT;
197: END IF;
198:

Line 206: WSH_DEBUG_SV.pop(l_module_name);

202: , p_encoded => FND_API.G_FALSE
203: );
204:
205: IF l_debug_on THEN
206: WSH_DEBUG_SV.pop(l_module_name);
207: END IF;
208:
209: EXCEPTION
210:

Line 219: wsh_debug_sv.log (l_module_name,'EXCEPTION:G_EXC_ERROR');

215: FND_MESSAGE.SET_TOKEN('ACTION', wsh_util_core.get_action_meaning('STOP',p_action_code));
216: wsh_util_core.add_message(x_return_status,l_module_name);
217:
218: IF l_debug_on THEN
219: wsh_debug_sv.log (l_module_name,'EXCEPTION:G_EXC_ERROR');
220: WSH_DEBUG_SV.pop(l_module_name);
221: END IF;
222:
223:

Line 220: WSH_DEBUG_SV.pop(l_module_name);

216: wsh_util_core.add_message(x_return_status,l_module_name);
217:
218: IF l_debug_on THEN
219: wsh_debug_sv.log (l_module_name,'EXCEPTION:G_EXC_ERROR');
220: WSH_DEBUG_SV.pop(l_module_name);
221: END IF;
222:
223:
224: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 237: wsh_debug_sv.log (l_module_name,'EXCEPTION:G_EXC_UNEXPECTED_ERROR');

233: , p_data => x_msg_data
234: , p_encoded => FND_API.G_FALSE
235: );
236: IF l_debug_on THEN
237: wsh_debug_sv.log (l_module_name,'EXCEPTION:G_EXC_UNEXPECTED_ERROR');
238: WSH_DEBUG_SV.pop(l_module_name);
239: END IF;
240:
241: WHEN OTHERS THEN

Line 238: WSH_DEBUG_SV.pop(l_module_name);

234: , p_encoded => FND_API.G_FALSE
235: );
236: IF l_debug_on THEN
237: wsh_debug_sv.log (l_module_name,'EXCEPTION:G_EXC_UNEXPECTED_ERROR');
238: WSH_DEBUG_SV.pop(l_module_name);
239: END IF;
240:
241: WHEN OTHERS THEN
242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 258: wsh_debug_sv.log (l_module_name,'Error',substr(sqlerrm,1,200));

254: , p_encoded => FND_API.G_FALSE
255: );
256:
257: IF l_debug_on THEN
258: wsh_debug_sv.log (l_module_name,'Error',substr(sqlerrm,1,200));
259: WSH_DEBUG_SV.pop(l_module_name);
260: END IF;
261: END Stop_Action;
262:

Line 259: WSH_DEBUG_SV.pop(l_module_name);

255: );
256:
257: IF l_debug_on THEN
258: wsh_debug_sv.log (l_module_name,'Error',substr(sqlerrm,1,200));
259: WSH_DEBUG_SV.pop(l_module_name);
260: END IF;
261: END Stop_Action;
262:
263: --Harmonizing Project **heali

Line 277: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

273: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
274: --
275: IF l_debug_on IS NULL
276: THEN
277: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
278: END IF;
279: --
280: IF l_debug_on THEN
281: WSH_DEBUG_SV.push(l_module_name);

Line 281: WSH_DEBUG_SV.push(l_module_name);

277: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
278: END IF;
279: --
280: IF l_debug_on THEN
281: WSH_DEBUG_SV.push(l_module_name);
282: WSH_DEBUG_SV.log(l_module_name,'p_pub_stop_rec.STOP_ID',p_pub_stop_rec.STOP_ID);
283: WSH_DEBUG_SV.log(l_module_name,'p_pub_stop_rec.TRIP_ID',p_pub_stop_rec.TRIP_ID);
284: WSH_DEBUG_SV.log(l_module_name,'p_pub_stop_rec.TRIP_NAME',p_pub_stop_rec.TRIP_NAME);
285: END IF;

Line 282: WSH_DEBUG_SV.log(l_module_name,'p_pub_stop_rec.STOP_ID',p_pub_stop_rec.STOP_ID);

278: END IF;
279: --
280: IF l_debug_on THEN
281: WSH_DEBUG_SV.push(l_module_name);
282: WSH_DEBUG_SV.log(l_module_name,'p_pub_stop_rec.STOP_ID',p_pub_stop_rec.STOP_ID);
283: WSH_DEBUG_SV.log(l_module_name,'p_pub_stop_rec.TRIP_ID',p_pub_stop_rec.TRIP_ID);
284: WSH_DEBUG_SV.log(l_module_name,'p_pub_stop_rec.TRIP_NAME',p_pub_stop_rec.TRIP_NAME);
285: END IF;
286:

Line 283: WSH_DEBUG_SV.log(l_module_name,'p_pub_stop_rec.TRIP_ID',p_pub_stop_rec.TRIP_ID);

279: --
280: IF l_debug_on THEN
281: WSH_DEBUG_SV.push(l_module_name);
282: WSH_DEBUG_SV.log(l_module_name,'p_pub_stop_rec.STOP_ID',p_pub_stop_rec.STOP_ID);
283: WSH_DEBUG_SV.log(l_module_name,'p_pub_stop_rec.TRIP_ID',p_pub_stop_rec.TRIP_ID);
284: WSH_DEBUG_SV.log(l_module_name,'p_pub_stop_rec.TRIP_NAME',p_pub_stop_rec.TRIP_NAME);
285: END IF;
286:
287: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 284: WSH_DEBUG_SV.log(l_module_name,'p_pub_stop_rec.TRIP_NAME',p_pub_stop_rec.TRIP_NAME);

280: IF l_debug_on THEN
281: WSH_DEBUG_SV.push(l_module_name);
282: WSH_DEBUG_SV.log(l_module_name,'p_pub_stop_rec.STOP_ID',p_pub_stop_rec.STOP_ID);
283: WSH_DEBUG_SV.log(l_module_name,'p_pub_stop_rec.TRIP_ID',p_pub_stop_rec.TRIP_ID);
284: WSH_DEBUG_SV.log(l_module_name,'p_pub_stop_rec.TRIP_NAME',p_pub_stop_rec.TRIP_NAME);
285: END IF;
286:
287: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
288:

Line 370: WSH_DEBUG_SV.pop(l_module_name);

366: x_pvt_stop_rec.PHYSICAL_STOP_ID := p_pub_stop_rec.PHYSICAL_STOP_ID;
367: x_pvt_stop_rec.PHYSICAL_LOCATION_ID := p_pub_stop_rec.PHYSICAL_LOCATION_ID;
368:
369: IF l_debug_on THEN
370: WSH_DEBUG_SV.pop(l_module_name);
371: END IF;
372: EXCEPTION
373: WHEN OTHERS THEN
374: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_FTE_INTEGRATION.map_stoppub_to_grp',l_module_name);

Line 378: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||

374: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_FTE_INTEGRATION.map_stoppub_to_grp',l_module_name);
375: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
376: --
377: IF l_debug_on THEN
378: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
379: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
380: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
381: END IF;
382: --

Line 379: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

375: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
376: --
377: IF l_debug_on THEN
378: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
379: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
380: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
381: END IF;
382: --
383: END;

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

376: --
377: IF l_debug_on THEN
378: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
379: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
380: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
381: END IF;
382: --
383: END;
384:

Line 442: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

438: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
439: --
440: IF l_debug_on IS NULL
441: THEN
442: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
443: END IF;
444: --
445: IF l_debug_on THEN
446: wsh_debug_sv.push (l_module_name, 'Create_Update_Stop');

Line 446: wsh_debug_sv.push (l_module_name, 'Create_Update_Stop');

442: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
443: END IF;
444: --
445: IF l_debug_on THEN
446: wsh_debug_sv.push (l_module_name, 'Create_Update_Stop');
447: END IF;
448:
449: IF NOT FND_API.Compatible_API_Call (l_api_version_number,p_api_version_number ,l_api_name ,G_PKG_NAME) THEN
450: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

458: p_pub_stop_rec => p_stop_info,
459: x_pvt_stop_rec => l_pvt_stop_rec,
460: x_return_status => x_return_status);
461: IF l_debug_on THEN
462: wsh_debug_sv.log (l_module_name, 'map_stoppub_to_pvt x_return_status',x_return_status);
463: END IF;
464: IF ( x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
465: raise FND_API.G_EXC_ERROR;
466: END IF;

Line 519: WSH_DEBUG_SV.log(l_module_name,'WSH_INTERFACE_GRP.CREATE_UPDATE_STOP x_return_status',x_return_status);

515: x_msg_count => x_msg_count,
516: x_msg_data => x_msg_data);
517:
518: IF l_debug_on THEN
519: WSH_DEBUG_SV.log(l_module_name,'WSH_INTERFACE_GRP.CREATE_UPDATE_STOP x_return_status',x_return_status);
520: END IF;
521:
522: IF ( x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS AND l_stop_out_tab.count > 0) THEN
523: x_stop_id := l_stop_out_tab(l_stop_out_tab.FIRST).stop_id;

Line 532: WSH_DEBUG_SV.pop(l_module_name);

528: p_count => x_msg_count,
529: p_data => x_msg_data);
530:
531: IF l_debug_on THEN
532: WSH_DEBUG_SV.pop(l_module_name);
533: END IF;
534:
535: EXCEPTION
536: WHEN FND_API.G_EXC_ERROR THEN

Line 543: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',

539: p_count => x_msg_count,
540: p_data => x_msg_data,
541: p_encoded => FND_API.G_FALSE);
542: IF l_debug_on THEN
543: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',
544: WSH_DEBUG_SV.C_EXCEP_LEVEL);
545: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
546: END IF;
547:

Line 544: WSH_DEBUG_SV.C_EXCEP_LEVEL);

540: p_data => x_msg_data,
541: p_encoded => FND_API.G_FALSE);
542: IF l_debug_on THEN
543: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',
544: WSH_DEBUG_SV.C_EXCEP_LEVEL);
545: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
546: END IF;
547:
548: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 545: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

541: p_encoded => FND_API.G_FALSE);
542: IF l_debug_on THEN
543: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',
544: WSH_DEBUG_SV.C_EXCEP_LEVEL);
545: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
546: END IF;
547:
548: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
549: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 555: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',

551: p_count => x_msg_count,
552: p_data => x_msg_data,
553: p_encoded => FND_API.G_FALSE);
554: IF l_debug_on THEN
555: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',
556: WSH_DEBUG_SV.C_EXCEP_LEVEL);
557: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
558: END IF;
559:

Line 556: WSH_DEBUG_SV.C_EXCEP_LEVEL);

552: p_data => x_msg_data,
553: p_encoded => FND_API.G_FALSE);
554: IF l_debug_on THEN
555: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',
556: WSH_DEBUG_SV.C_EXCEP_LEVEL);
557: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
558: END IF;
559:
560: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

Line 557: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

553: p_encoded => FND_API.G_FALSE);
554: IF l_debug_on THEN
555: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',
556: WSH_DEBUG_SV.C_EXCEP_LEVEL);
557: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
558: END IF;
559:
560: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
561: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 567: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',

563: p_count => x_msg_count,
564: p_data => x_msg_data,
565: p_encoded => FND_API.G_FALSE);
566: IF l_debug_on THEN
567: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',
568: WSH_DEBUG_SV.C_EXCEP_LEVEL);
569: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
570: END IF;
571:

Line 568: WSH_DEBUG_SV.C_EXCEP_LEVEL);

564: p_data => x_msg_data,
565: p_encoded => FND_API.G_FALSE);
566: IF l_debug_on THEN
567: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',
568: WSH_DEBUG_SV.C_EXCEP_LEVEL);
569: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
570: END IF;
571:
572: WHEN OTHERS THEN

Line 569: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');

565: p_encoded => FND_API.G_FALSE);
566: IF l_debug_on THEN
567: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',
568: WSH_DEBUG_SV.C_EXCEP_LEVEL);
569: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
570: END IF;
571:
572: WHEN OTHERS THEN
573: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 580: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||

576: p_count => x_msg_count,
577: p_data => x_msg_data,
578: p_encoded => FND_API.G_FALSE);
579: IF l_debug_on THEN
580: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
581: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
582: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
583: END IF;
584:

Line 581: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

577: p_data => x_msg_data,
578: p_encoded => FND_API.G_FALSE);
579: IF l_debug_on THEN
580: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
581: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
582: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
583: END IF;
584:
585: END Create_Update_Stop;

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

578: p_encoded => FND_API.G_FALSE);
579: IF l_debug_on THEN
580: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
581: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
582: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
583: END IF;
584:
585: END Create_Update_Stop;
586: