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

Line 68: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

64:
65: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
66: IF l_debug_on IS NULL
67: THEN
68: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
69: END IF;
70:
71: SAVEPOINT S_CREATE_UPDATE_DETAILS_BULK;
72:

Line 78: wsh_debug_sv.push (l_module_name);

74: FND_MSG_PUB.initialize;
75: END IF;
76: --
77: IF l_debug_on THEN
78: wsh_debug_sv.push (l_module_name);
79: wsh_debug_sv.log (l_module_name,'p_api_version_number',p_api_version_number);
80: wsh_debug_sv.log (l_module_name,'p_init_msg_list',p_init_msg_list);
81: wsh_debug_sv.log (l_module_name,'p_commit',p_commit);
82: wsh_debug_sv.log (l_module_name,'Caller',p_action_prms.Caller);

Line 79: wsh_debug_sv.log (l_module_name,'p_api_version_number',p_api_version_number);

75: END IF;
76: --
77: IF l_debug_on THEN
78: wsh_debug_sv.push (l_module_name);
79: wsh_debug_sv.log (l_module_name,'p_api_version_number',p_api_version_number);
80: wsh_debug_sv.log (l_module_name,'p_init_msg_list',p_init_msg_list);
81: wsh_debug_sv.log (l_module_name,'p_commit',p_commit);
82: wsh_debug_sv.log (l_module_name,'Caller',p_action_prms.Caller);
83: wsh_debug_sv.log (l_module_name,'action_code',p_action_prms.action_code);

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

76: --
77: IF l_debug_on THEN
78: wsh_debug_sv.push (l_module_name);
79: wsh_debug_sv.log (l_module_name,'p_api_version_number',p_api_version_number);
80: wsh_debug_sv.log (l_module_name,'p_init_msg_list',p_init_msg_list);
81: wsh_debug_sv.log (l_module_name,'p_commit',p_commit);
82: wsh_debug_sv.log (l_module_name,'Caller',p_action_prms.Caller);
83: wsh_debug_sv.log (l_module_name,'action_code',p_action_prms.action_code);
84: wsh_debug_sv.log (l_module_name,'Org_id',p_action_prms.Org_id);

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

77: IF l_debug_on THEN
78: wsh_debug_sv.push (l_module_name);
79: wsh_debug_sv.log (l_module_name,'p_api_version_number',p_api_version_number);
80: wsh_debug_sv.log (l_module_name,'p_init_msg_list',p_init_msg_list);
81: wsh_debug_sv.log (l_module_name,'p_commit',p_commit);
82: wsh_debug_sv.log (l_module_name,'Caller',p_action_prms.Caller);
83: wsh_debug_sv.log (l_module_name,'action_code',p_action_prms.action_code);
84: wsh_debug_sv.log (l_module_name,'Org_id',p_action_prms.Org_id);
85: END IF;

Line 82: wsh_debug_sv.log (l_module_name,'Caller',p_action_prms.Caller);

78: wsh_debug_sv.push (l_module_name);
79: wsh_debug_sv.log (l_module_name,'p_api_version_number',p_api_version_number);
80: wsh_debug_sv.log (l_module_name,'p_init_msg_list',p_init_msg_list);
81: wsh_debug_sv.log (l_module_name,'p_commit',p_commit);
82: wsh_debug_sv.log (l_module_name,'Caller',p_action_prms.Caller);
83: wsh_debug_sv.log (l_module_name,'action_code',p_action_prms.action_code);
84: wsh_debug_sv.log (l_module_name,'Org_id',p_action_prms.Org_id);
85: END IF;
86:

Line 83: wsh_debug_sv.log (l_module_name,'action_code',p_action_prms.action_code);

79: wsh_debug_sv.log (l_module_name,'p_api_version_number',p_api_version_number);
80: wsh_debug_sv.log (l_module_name,'p_init_msg_list',p_init_msg_list);
81: wsh_debug_sv.log (l_module_name,'p_commit',p_commit);
82: wsh_debug_sv.log (l_module_name,'Caller',p_action_prms.Caller);
83: wsh_debug_sv.log (l_module_name,'action_code',p_action_prms.action_code);
84: wsh_debug_sv.log (l_module_name,'Org_id',p_action_prms.Org_id);
85: END IF;
86:
87: IF NOT FND_API.Compatible_API_Call

Line 84: wsh_debug_sv.log (l_module_name,'Org_id',p_action_prms.Org_id);

80: wsh_debug_sv.log (l_module_name,'p_init_msg_list',p_init_msg_list);
81: wsh_debug_sv.log (l_module_name,'p_commit',p_commit);
82: wsh_debug_sv.log (l_module_name,'Caller',p_action_prms.Caller);
83: wsh_debug_sv.log (l_module_name,'action_code',p_action_prms.action_code);
84: wsh_debug_sv.log (l_module_name,'Org_id',p_action_prms.Org_id);
85: END IF;
86:
87: IF NOT FND_API.Compatible_API_Call
88: ( l_api_version_number,

Line 114: wsh_debug_sv.log (l_module_name,'bad caller',p_action_prms.Caller);

110:
111: -- IF caller is neither 'OM' or 'PO', raise an exception.
112: IF p_action_prms.caller NOT IN ('OM','PO') THEN
113: IF l_debug_on THEN
114: wsh_debug_sv.log (l_module_name,'bad caller',p_action_prms.Caller);
115: END IF;
116: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
117: END IF;
118:

Line 187: wsh_debug_sv.log (l_module_name,'return status from create_delivery_details',l_return_status);

183:
184: END IF;
185:
186: IF l_debug_on THEN
187: wsh_debug_sv.log (l_module_name,'return status from create_delivery_details',l_return_status);
188: END IF;
189:
190: wsh_util_core.api_post_call(
191: p_return_status => l_return_status,

Line 195: wsh_debug_sv.log (l_module_name,'after api_post_call');

191: p_return_status => l_return_status,
192: x_num_warnings => l_num_warnings,
193: x_num_errors => l_num_errors);
194: IF l_debug_on THEN
195: wsh_debug_sv.log (l_module_name,'after api_post_call');
196: END IF;
197:
198: IF (l_num_errors > 0 ) THEN
199: RAISE FND_API.G_EXC_ERROR;

Line 214: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);

210:
211: l_reset_flags := FALSE;
212:
213: IF l_debug_on THEN
214: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
215: END IF;
216:
217: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => l_reset_flags,
218: x_return_status => l_return_status);

Line 221: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);

217: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => l_reset_flags,
218: x_return_status => l_return_status);
219:
220: IF l_debug_on THEN
221: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
222: END IF;
223:
224: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
225: RAISE FND_API.G_EXC_ERROR;

Line 247: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);

243: --{
244:
245: IF FND_API.To_Boolean( p_commit ) THEN
246: IF l_debug_on THEN
247: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
248: END IF;
249:
250: WSH_UTIL_CORE.reset_stops_for_load_tender(p_reset_flags => TRUE,
251: x_return_status => l_return_status);

Line 256: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);

252:
253: ELSE
254:
255: IF l_debug_on THEN
256: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
257: END IF;
258:
259: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => TRUE,
260: x_return_status => l_return_status);

Line 264: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);

260: x_return_status => l_return_status);
261: END IF;
262:
263: IF l_debug_on THEN
264: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
265: END IF;
266:
267: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
268: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR,

Line 287: wsh_debug_sv.log (l_module_name,'getting the messages');

283:
284: --bug 4070732
285: --
286: IF l_debug_on THEN
287: wsh_debug_sv.log (l_module_name,'getting the messages');
288: END IF;
289: FND_MSG_PUB.Count_And_Get
290: (
291: p_count => x_msg_count,

Line 297: WSH_DEBUG_SV.pop(l_module_name);

293: p_encoded => FND_API.G_FALSE
294: );
295: --
296: IF l_debug_on THEN
297: WSH_DEBUG_SV.pop(l_module_name);
298: END IF;
299: --
300: EXCEPTION
301: WHEN e_success THEN

Line 316: WSH_DEBUG_SV.pop(l_module_name,'e_success');

312: p_encoded => FND_API.G_FALSE
313: );
314: */
315: IF l_debug_on THEN
316: WSH_DEBUG_SV.pop(l_module_name,'e_success');
317: END IF;
318:
319: WHEN FND_API.G_EXC_ERROR THEN
320: --ROLLBACK TO S_CREATE_UPDATE_DETAILS; bms

Line 331: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);

327: --{
328: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
329: --{
330: IF l_debug_on THEN
331: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
332: END IF;
333:
334: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
335: x_return_status => l_return_status);

Line 339: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);

335: x_return_status => l_return_status);
336:
337:
338: IF l_debug_on THEN
339: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
340: END IF;
341:
342: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
343: x_return_status := l_return_status;

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

355: p_data => x_msg_data,
356: p_encoded => FND_API.G_FALSE
357: );
358: IF l_debug_on THEN
359: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has '
360: || 'occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
361: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
362: END IF;
363:

Line 360: || 'occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

356: p_encoded => FND_API.G_FALSE
357: );
358: IF l_debug_on THEN
359: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has '
360: || 'occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
361: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
362: END IF;
363:
364:

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

357: );
358: IF l_debug_on THEN
359: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has '
360: || 'occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
361: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
362: END IF;
363:
364:
365: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 377: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);

373: --{
374: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
375: --{
376: IF l_debug_on THEN
377: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
378: END IF;
379:
380: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
381: x_return_status => l_return_status);

Line 385: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);

381: x_return_status => l_return_status);
382:
383:
384: IF l_debug_on THEN
385: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
386: END IF;
387:
388: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
389: x_return_status := l_return_status;

Line 405: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. ' ||

401: p_data => x_msg_data,
402: p_encoded => FND_API.G_FALSE
403: );
404: IF l_debug_on THEN
405: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. ' ||
406: 'Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
407: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
408: END IF;
409:

Line 406: 'Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

402: p_encoded => FND_API.G_FALSE
403: );
404: IF l_debug_on THEN
405: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. ' ||
406: 'Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
407: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
408: END IF;
409:
410: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

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

403: );
404: IF l_debug_on THEN
405: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. ' ||
406: 'Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
407: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
408: END IF;
409:
410: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
411: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 421: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);

417: --{
418: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
419: --{
420: IF l_debug_on THEN
421: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
422: END IF;
423:
424: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => TRUE,
425: x_return_status => l_return_status);

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

425: x_return_status => l_return_status);
426:
427:
428: IF l_debug_on THEN
429: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
430: END IF;
431:
432: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
433: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR,

Line 455: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING '||

451: p_data => x_msg_data,
452: p_encoded => FND_API.G_FALSE
453: );
454: IF l_debug_on THEN
455: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING '||
456: 'exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
457: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
458: END IF;
459: --

Line 456: 'exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

452: p_encoded => FND_API.G_FALSE
453: );
454: IF l_debug_on THEN
455: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING '||
456: 'exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
457: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
458: END IF;
459: --
460:

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

453: );
454: IF l_debug_on THEN
455: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING '||
456: 'exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
457: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
458: END IF;
459: --
460:
461: WHEN OTHERS THEN

Line 474: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);

470: --{
471: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
472: --{
473: IF l_debug_on THEN
474: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
475: END IF;
476:
477: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
478: x_return_status => l_return_status);

Line 482: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);

478: x_return_status => l_return_status);
479:
480:
481: IF l_debug_on THEN
482: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
483: END IF;
484:
485: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
486: x_return_status := l_return_status;

Line 502: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. '||

498: p_data => x_msg_data,
499: p_encoded => FND_API.G_FALSE
500: );
501: IF l_debug_on THEN
502: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. '||
503: 'Oracle error message is '||
504: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
505: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
506: END IF;

Line 504: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

500: );
501: IF l_debug_on THEN
502: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. '||
503: 'Oracle error message is '||
504: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
505: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
506: END IF;
507:
508: END Create_update_delivery_details;

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

501: IF l_debug_on THEN
502: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. '||
503: 'Oracle error message is '||
504: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
505: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
506: END IF;
507:
508: END Create_update_delivery_details;
509: