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

Line 52: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

48: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
49: --
50: IF l_debug_on IS NULL
51: THEN
52: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
53: END IF;
54: --
55: IF l_debug_on THEN
56: wsh_debug_sv.push(l_module_name);

Line 56: wsh_debug_sv.push(l_module_name);

52: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
53: END IF;
54: --
55: IF l_debug_on THEN
56: wsh_debug_sv.push(l_module_name);
57: wsh_debug_sv.log(l_module_name, 'p_transaction_status', p_transaction_status);
58: wsh_debug_sv.log(l_module_name, 'p_from_document_number', p_from_document_number);
59: wsh_debug_sv.log(l_module_name, 'p_to_document_number', p_to_document_number);
60: wsh_debug_sv.log(l_module_name, 'p_from_creation_date', p_from_creation_date);

Line 57: wsh_debug_sv.log(l_module_name, 'p_transaction_status', p_transaction_status);

53: END IF;
54: --
55: IF l_debug_on THEN
56: wsh_debug_sv.push(l_module_name);
57: wsh_debug_sv.log(l_module_name, 'p_transaction_status', p_transaction_status);
58: wsh_debug_sv.log(l_module_name, 'p_from_document_number', p_from_document_number);
59: wsh_debug_sv.log(l_module_name, 'p_to_document_number', p_to_document_number);
60: wsh_debug_sv.log(l_module_name, 'p_from_creation_date', p_from_creation_date);
61: wsh_debug_sv.log(l_module_name, 'p_to_creation_date', p_to_creation_date);

Line 58: wsh_debug_sv.log(l_module_name, 'p_from_document_number', p_from_document_number);

54: --
55: IF l_debug_on THEN
56: wsh_debug_sv.push(l_module_name);
57: wsh_debug_sv.log(l_module_name, 'p_transaction_status', p_transaction_status);
58: wsh_debug_sv.log(l_module_name, 'p_from_document_number', p_from_document_number);
59: wsh_debug_sv.log(l_module_name, 'p_to_document_number', p_to_document_number);
60: wsh_debug_sv.log(l_module_name, 'p_from_creation_date', p_from_creation_date);
61: wsh_debug_sv.log(l_module_name, 'p_to_creation_date', p_to_creation_date);
62: wsh_debug_sv.log(l_module_name, 'p_transaction_id', p_transaction_id);

Line 59: wsh_debug_sv.log(l_module_name, 'p_to_document_number', p_to_document_number);

55: IF l_debug_on THEN
56: wsh_debug_sv.push(l_module_name);
57: wsh_debug_sv.log(l_module_name, 'p_transaction_status', p_transaction_status);
58: wsh_debug_sv.log(l_module_name, 'p_from_document_number', p_from_document_number);
59: wsh_debug_sv.log(l_module_name, 'p_to_document_number', p_to_document_number);
60: wsh_debug_sv.log(l_module_name, 'p_from_creation_date', p_from_creation_date);
61: wsh_debug_sv.log(l_module_name, 'p_to_creation_date', p_to_creation_date);
62: wsh_debug_sv.log(l_module_name, 'p_transaction_id', p_transaction_id);
63: wsh_debug_sv.log(l_module_name, 'p_log_level', p_log_level);

Line 60: wsh_debug_sv.log(l_module_name, 'p_from_creation_date', p_from_creation_date);

56: wsh_debug_sv.push(l_module_name);
57: wsh_debug_sv.log(l_module_name, 'p_transaction_status', p_transaction_status);
58: wsh_debug_sv.log(l_module_name, 'p_from_document_number', p_from_document_number);
59: wsh_debug_sv.log(l_module_name, 'p_to_document_number', p_to_document_number);
60: wsh_debug_sv.log(l_module_name, 'p_from_creation_date', p_from_creation_date);
61: wsh_debug_sv.log(l_module_name, 'p_to_creation_date', p_to_creation_date);
62: wsh_debug_sv.log(l_module_name, 'p_transaction_id', p_transaction_id);
63: wsh_debug_sv.log(l_module_name, 'p_log_level', p_log_level);
64: END IF;

Line 61: wsh_debug_sv.log(l_module_name, 'p_to_creation_date', p_to_creation_date);

57: wsh_debug_sv.log(l_module_name, 'p_transaction_status', p_transaction_status);
58: wsh_debug_sv.log(l_module_name, 'p_from_document_number', p_from_document_number);
59: wsh_debug_sv.log(l_module_name, 'p_to_document_number', p_to_document_number);
60: wsh_debug_sv.log(l_module_name, 'p_from_creation_date', p_from_creation_date);
61: wsh_debug_sv.log(l_module_name, 'p_to_creation_date', p_to_creation_date);
62: wsh_debug_sv.log(l_module_name, 'p_transaction_id', p_transaction_id);
63: wsh_debug_sv.log(l_module_name, 'p_log_level', p_log_level);
64: END IF;
65: --

Line 62: wsh_debug_sv.log(l_module_name, 'p_transaction_id', p_transaction_id);

58: wsh_debug_sv.log(l_module_name, 'p_from_document_number', p_from_document_number);
59: wsh_debug_sv.log(l_module_name, 'p_to_document_number', p_to_document_number);
60: wsh_debug_sv.log(l_module_name, 'p_from_creation_date', p_from_creation_date);
61: wsh_debug_sv.log(l_module_name, 'p_to_creation_date', p_to_creation_date);
62: wsh_debug_sv.log(l_module_name, 'p_transaction_id', p_transaction_id);
63: wsh_debug_sv.log(l_module_name, 'p_log_level', p_log_level);
64: END IF;
65: --
66:

Line 63: wsh_debug_sv.log(l_module_name, 'p_log_level', p_log_level);

59: wsh_debug_sv.log(l_module_name, 'p_to_document_number', p_to_document_number);
60: wsh_debug_sv.log(l_module_name, 'p_from_creation_date', p_from_creation_date);
61: wsh_debug_sv.log(l_module_name, 'p_to_creation_date', p_to_creation_date);
62: wsh_debug_sv.log(l_module_name, 'p_transaction_id', p_transaction_id);
63: wsh_debug_sv.log(l_module_name, 'p_log_level', p_log_level);
64: END IF;
65: --
66:
67: --

Line 69: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling Process_Shipment_Advice', WSH_DEBUG_SV.C_PROC_LEVEL);

65: --
66:
67: --
68: IF l_debug_on THEN
69: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling Process_Shipment_Advice', WSH_DEBUG_SV.C_PROC_LEVEL);
70: END IF;
71: --
72:
73: Process_Shipment_Advice(

Line 85: WSH_DEBUG_SV.log(l_module_name, 'Return Status of Process_Shipment_Advice', l_return_status);

81: x_return_status => l_return_status );
82:
83: --
84: IF l_debug_on THEN
85: WSH_DEBUG_SV.log(l_module_name, 'Return Status of Process_Shipment_Advice', l_return_status);
86: END IF;
87: --
88:
89:

Line 110: WSH_DEBUG_SV.log(l_module_name,'l_completion_status', l_completion_status);

106: END IF;
107:
108: --
109: IF l_debug_on THEN
110: WSH_DEBUG_SV.log(l_module_name,'l_completion_status', l_completion_status);
111: WSH_DEBUG_SV.log(l_module_name,'errbuf', errbuf);
112: WSH_DEBUG_SV.log(l_module_name,'retcode', retcode);
113: WSH_DEBUG_SV.pop(l_module_name);
114: END IF;

Line 111: WSH_DEBUG_SV.log(l_module_name,'errbuf', errbuf);

107:
108: --
109: IF l_debug_on THEN
110: WSH_DEBUG_SV.log(l_module_name,'l_completion_status', l_completion_status);
111: WSH_DEBUG_SV.log(l_module_name,'errbuf', errbuf);
112: WSH_DEBUG_SV.log(l_module_name,'retcode', retcode);
113: WSH_DEBUG_SV.pop(l_module_name);
114: END IF;
115: --

Line 112: WSH_DEBUG_SV.log(l_module_name,'retcode', retcode);

108: --
109: IF l_debug_on THEN
110: WSH_DEBUG_SV.log(l_module_name,'l_completion_status', l_completion_status);
111: WSH_DEBUG_SV.log(l_module_name,'errbuf', errbuf);
112: WSH_DEBUG_SV.log(l_module_name,'retcode', retcode);
113: WSH_DEBUG_SV.pop(l_module_name);
114: END IF;
115: --
116: EXCEPTION

Line 113: WSH_DEBUG_SV.pop(l_module_name);

109: IF l_debug_on THEN
110: WSH_DEBUG_SV.log(l_module_name,'l_completion_status', l_completion_status);
111: WSH_DEBUG_SV.log(l_module_name,'errbuf', errbuf);
112: WSH_DEBUG_SV.log(l_module_name,'retcode', retcode);
113: WSH_DEBUG_SV.pop(l_module_name);
114: END IF;
115: --
116: EXCEPTION
117: WHEN OTHERS THEN

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

119: errbuf := 'Process Shipment Advices Program is completed with unexpected error - ' || SQLCODE;
120: retcode := '2';
121: --
122: IF l_debug_on THEN
123: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
124: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
125: END IF;
126: --
127: END Shipment_Advice_Inbound;

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

120: retcode := '2';
121: --
122: IF l_debug_on THEN
123: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
124: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
125: END IF;
126: --
127: END Shipment_Advice_Inbound;
128: --

Line 232: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

228: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
229: --
230: IF l_debug_on IS NULL
231: THEN
232: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
233: END IF;
234: --
235: IF l_debug_on THEN
236: wsh_debug_sv.push(l_module_name);

Line 236: wsh_debug_sv.push(l_module_name);

232: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
233: END IF;
234: --
235: IF l_debug_on THEN
236: wsh_debug_sv.push(l_module_name);
237: wsh_debug_sv.log(l_module_name, 'p_commit_flag', p_commit_flag);
238: wsh_debug_sv.log(l_module_name, 'p_transaction_status', p_transaction_status);
239: wsh_debug_sv.log(l_module_name, 'p_from_document_number', p_from_document_number);
240: wsh_debug_sv.log(l_module_name, 'p_to_document_number', p_to_document_number);

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

233: END IF;
234: --
235: IF l_debug_on THEN
236: wsh_debug_sv.push(l_module_name);
237: wsh_debug_sv.log(l_module_name, 'p_commit_flag', p_commit_flag);
238: wsh_debug_sv.log(l_module_name, 'p_transaction_status', p_transaction_status);
239: wsh_debug_sv.log(l_module_name, 'p_from_document_number', p_from_document_number);
240: wsh_debug_sv.log(l_module_name, 'p_to_document_number', p_to_document_number);
241: wsh_debug_sv.log(l_module_name, 'p_from_creation_date', p_from_creation_date);

Line 238: wsh_debug_sv.log(l_module_name, 'p_transaction_status', p_transaction_status);

234: --
235: IF l_debug_on THEN
236: wsh_debug_sv.push(l_module_name);
237: wsh_debug_sv.log(l_module_name, 'p_commit_flag', p_commit_flag);
238: wsh_debug_sv.log(l_module_name, 'p_transaction_status', p_transaction_status);
239: wsh_debug_sv.log(l_module_name, 'p_from_document_number', p_from_document_number);
240: wsh_debug_sv.log(l_module_name, 'p_to_document_number', p_to_document_number);
241: wsh_debug_sv.log(l_module_name, 'p_from_creation_date', p_from_creation_date);
242: wsh_debug_sv.log(l_module_name, 'p_to_creation_date', p_to_creation_date);

Line 239: wsh_debug_sv.log(l_module_name, 'p_from_document_number', p_from_document_number);

235: IF l_debug_on THEN
236: wsh_debug_sv.push(l_module_name);
237: wsh_debug_sv.log(l_module_name, 'p_commit_flag', p_commit_flag);
238: wsh_debug_sv.log(l_module_name, 'p_transaction_status', p_transaction_status);
239: wsh_debug_sv.log(l_module_name, 'p_from_document_number', p_from_document_number);
240: wsh_debug_sv.log(l_module_name, 'p_to_document_number', p_to_document_number);
241: wsh_debug_sv.log(l_module_name, 'p_from_creation_date', p_from_creation_date);
242: wsh_debug_sv.log(l_module_name, 'p_to_creation_date', p_to_creation_date);
243: wsh_debug_sv.log(l_module_name, 'p_transaction_id', p_transaction_id);

Line 240: wsh_debug_sv.log(l_module_name, 'p_to_document_number', p_to_document_number);

236: wsh_debug_sv.push(l_module_name);
237: wsh_debug_sv.log(l_module_name, 'p_commit_flag', p_commit_flag);
238: wsh_debug_sv.log(l_module_name, 'p_transaction_status', p_transaction_status);
239: wsh_debug_sv.log(l_module_name, 'p_from_document_number', p_from_document_number);
240: wsh_debug_sv.log(l_module_name, 'p_to_document_number', p_to_document_number);
241: wsh_debug_sv.log(l_module_name, 'p_from_creation_date', p_from_creation_date);
242: wsh_debug_sv.log(l_module_name, 'p_to_creation_date', p_to_creation_date);
243: wsh_debug_sv.log(l_module_name, 'p_transaction_id', p_transaction_id);
244: END IF;

Line 241: wsh_debug_sv.log(l_module_name, 'p_from_creation_date', p_from_creation_date);

237: wsh_debug_sv.log(l_module_name, 'p_commit_flag', p_commit_flag);
238: wsh_debug_sv.log(l_module_name, 'p_transaction_status', p_transaction_status);
239: wsh_debug_sv.log(l_module_name, 'p_from_document_number', p_from_document_number);
240: wsh_debug_sv.log(l_module_name, 'p_to_document_number', p_to_document_number);
241: wsh_debug_sv.log(l_module_name, 'p_from_creation_date', p_from_creation_date);
242: wsh_debug_sv.log(l_module_name, 'p_to_creation_date', p_to_creation_date);
243: wsh_debug_sv.log(l_module_name, 'p_transaction_id', p_transaction_id);
244: END IF;
245: --

Line 242: wsh_debug_sv.log(l_module_name, 'p_to_creation_date', p_to_creation_date);

238: wsh_debug_sv.log(l_module_name, 'p_transaction_status', p_transaction_status);
239: wsh_debug_sv.log(l_module_name, 'p_from_document_number', p_from_document_number);
240: wsh_debug_sv.log(l_module_name, 'p_to_document_number', p_to_document_number);
241: wsh_debug_sv.log(l_module_name, 'p_from_creation_date', p_from_creation_date);
242: wsh_debug_sv.log(l_module_name, 'p_to_creation_date', p_to_creation_date);
243: wsh_debug_sv.log(l_module_name, 'p_transaction_id', p_transaction_id);
244: END IF;
245: --
246:

Line 243: wsh_debug_sv.log(l_module_name, 'p_transaction_id', p_transaction_id);

239: wsh_debug_sv.log(l_module_name, 'p_from_document_number', p_from_document_number);
240: wsh_debug_sv.log(l_module_name, 'p_to_document_number', p_to_document_number);
241: wsh_debug_sv.log(l_module_name, 'p_from_creation_date', p_from_creation_date);
242: wsh_debug_sv.log(l_module_name, 'p_to_creation_date', p_to_creation_date);
243: wsh_debug_sv.log(l_module_name, 'p_transaction_id', p_transaction_id);
244: END IF;
245: --
246:
247: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 252: WSH_DEBUG_SV.log(l_module_name,'Error: Profile option "WSH: Distributed Source Entity" value is not set to B(Batch)', l_tpw_install);

248: l_tpw_install := FND_PROFILE.Value('WSH_SR_SOURCE');
249: IF nvl(l_tpw_install, FND_API.G_MISS_CHAR) <> 'B' THEN
250: --
251: IF l_debug_on THEN
252: WSH_DEBUG_SV.log(l_module_name,'Error: Profile option "WSH: Distributed Source Entity" value is not set to B(Batch)', l_tpw_install);
253: RAISE FND_API.G_EXC_ERROR;
254: END IF;
255: --
256: END IF;

Line 263: WSH_DEBUG_SV.log(l_module_name,'l_from_creation_date',l_from_creation_date);

259: l_to_creation_date := to_date(p_to_creation_date,'YYYY/MM/DD HH24:MI:SS');
260:
261: --
262: IF l_debug_on THEN
263: WSH_DEBUG_SV.log(l_module_name,'l_from_creation_date',l_from_creation_date);
264: WSH_DEBUG_SV.log(l_module_name,'l_to_creation_date',l_to_creation_date);
265: END IF;
266: --
267:

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

260:
261: --
262: IF l_debug_on THEN
263: WSH_DEBUG_SV.log(l_module_name,'l_from_creation_date',l_from_creation_date);
264: WSH_DEBUG_SV.log(l_module_name,'l_to_creation_date',l_to_creation_date);
265: END IF;
266: --
267:
268: IF p_transaction_id is not null THEN

Line 347: WSH_DEBUG_SV.log(l_module_name, 'Transaction Query', l_transaction_query);

343: l_transaction_query := l_transaction_query || ' ORDER BY wth.transaction_id ';
344:
345: --
346: IF l_debug_on THEN
347: WSH_DEBUG_SV.log(l_module_name, 'Transaction Query', l_transaction_query);
348: END IF;
349: --
350:
351: v_cursorid := DBMS_SQL.Open_Cursor;

Line 354: WSH_DEBUG_SV.log(l_module_name, 'Opended cursor successfully', v_cursorid);

350:
351: v_cursorid := DBMS_SQL.Open_Cursor;
352: --
353: IF l_debug_on THEN
354: WSH_DEBUG_SV.log(l_module_name, 'Opended cursor successfully', v_cursorid);
355: END IF;
356: --
357: DBMS_SQL.Parse(v_cursorid, l_transaction_query, DBMS_SQL.v7 );
358:

Line 361: WSH_DEBUG_SV.logmsg(l_module_name, 'Parsed cursor successfully');

357: DBMS_SQL.Parse(v_cursorid, l_transaction_query, DBMS_SQL.v7 );
358:
359: --
360: IF l_debug_on THEN
361: WSH_DEBUG_SV.logmsg(l_module_name, 'Parsed cursor successfully');
362: END IF;
363: --
364: DBMS_SQL.Define_Column(v_cursorid, 1, l_transaction_rec.Transaction_ID);
365: DBMS_SQL.Define_Column(v_cursorid, 2, l_transaction_rec.Document_Type, 30);

Line 397: WSH_DEBUG_SV.logmsg(l_module_name, 'Defined Columns successfully');

393: DBMS_SQL.Define_Column(v_cursorid, 30, l_transaction_rec.Attribute14, 150);
394: DBMS_SQL.Define_Column(v_cursorid, 31, l_transaction_rec.Attribute15, 150);
395: --
396: IF l_debug_on THEN
397: WSH_DEBUG_SV.logmsg(l_module_name, 'Defined Columns successfully');
398: END IF;
399: --
400:
401: --Start assigning BIND values

Line 433: WSH_DEBUG_SV.logmsg(l_module_name, 'Bind values successfully');

429: END IF;
430: --End assigning BIND values
431: --
432: IF l_debug_on THEN
433: WSH_DEBUG_SV.logmsg(l_module_name, 'Bind values successfully');
434: END IF;
435: --
436:
437: v_ignore := DBMS_SQL.Execute(v_cursorid);

Line 440: WSH_DEBUG_SV.log(l_module_name, 'Cursor executed successfully', v_ignore);

436:
437: v_ignore := DBMS_SQL.Execute(v_cursorid);
438: --
439: IF l_debug_on THEN
440: WSH_DEBUG_SV.log(l_module_name, 'Cursor executed successfully', v_ignore);
441: END IF;
442: --
443: END IF;
444:

Line 453: WSH_DEBUG_SV.log(l_module_name, 'Fetched successfully', v_ignore);

449: ELSE
450: v_ignore := DBMS_SQL.Fetch_Rows(v_cursorid);
451: --
452: IF l_debug_on THEN
453: WSH_DEBUG_SV.log(l_module_name, 'Fetched successfully', v_ignore);
454: END IF;
455: --
456: IF v_ignore = 0 THEN
457: EXIT;

Line 493: WSH_DEBUG_SV.logmsg(l_module_name, 'Fetched from cursor successfully');

489: DBMS_SQL.Column_Value(v_cursorid, 30, l_transaction_rec.Attribute14);
490: DBMS_SQL.Column_Value(v_cursorid, 31, l_transaction_rec.Attribute15);
491: --
492: IF l_debug_on THEN
493: WSH_DEBUG_SV.logmsg(l_module_name, 'Fetched from cursor successfully');
494: END IF;
495: --
496: END IF;
497:

Line 510: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling wf_engine.handleError', WSH_DEBUG_SV.C_PROC_LEVEL);

506: l_transaction_rec.event_key is not null --{
507: THEN
508: --
509: IF l_debug_on THEN
510: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling wf_engine.handleError', WSH_DEBUG_SV.C_PROC_LEVEL);
511: END IF;
512: --
513: WF_ENGINE.handleError(
514: itemType => l_transaction_rec.item_type,

Line 524: wsh_debug_sv.log(l_module_name,'l_trx_status', l_trx_status);

520: FETCH c_get_status INTO l_trx_status;
521: CLOSE c_get_status;
522:
523: IF l_debug_on THEN
524: wsh_debug_sv.log(l_module_name,'l_trx_status', l_trx_status);
525: END IF;
526:
527: IF l_trx_status <> 'SC' THEN
528: l_tmp_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 534: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling WSH_PROCESS_INTERFACED_PKG.Process_Inbound', WSH_DEBUG_SV.C_PROC_LEVEL);

530:
531: ELSE
532: --
533: IF l_debug_on THEN
534: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling WSH_PROCESS_INTERFACED_PKG.Process_Inbound', WSH_DEBUG_SV.C_PROC_LEVEL);
535: END IF;
536: --
537: WSH_PROCESS_INTERFACED_PKG.Process_Inbound(
538: l_trns_history_rec => l_transaction_rec,

Line 543: wsh_debug_sv.log(l_module_name,'Return status from WSH_PROCESS_INTERFACED_PKG.Process_Inbound', l_tmp_status);

539: x_return_status => l_tmp_status );
540:
541: --
542: IF l_debug_on THEN
543: wsh_debug_sv.log(l_module_name,'Return status from WSH_PROCESS_INTERFACED_PKG.Process_Inbound', l_tmp_status);
544: END IF;
545: --
546: END IF; --Fulfillment Batch XML Project
547: -- API Process_Shipment_Advice will return WARNING if its not able to lock tables.

Line 557: wsh_debug_sv.log(l_module_name,'Unexpected error occurred in Process_Shipment_Advice', l_tmp_status);

553: ELSIF l_tmp_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
554: THEN
555: --
556: IF l_debug_on THEN
557: wsh_debug_sv.log(l_module_name,'Unexpected error occurred in Process_Shipment_Advice', l_tmp_status);
558: END IF;
559: --
560: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
561: END IF;

Line 572: WSH_DEBUG_SV.logmsg(l_module_name, 'Closing cursor');

568: ELSE
569: IF DBMS_SQL.Is_Open(v_cursorid) THEN
570: --
571: IF l_debug_on THEN
572: WSH_DEBUG_SV.logmsg(l_module_name, 'Closing cursor');
573: END IF;
574: --
575: DBMS_SQL.Close_Cursor(v_cursorid);
576: v_cursorid := null;

Line 590: WSH_DEBUG_SV.log(l_module_name, 'Return Status from Process_Shipment_Advice', x_return_status);

586: END IF;
587:
588: --
589: IF l_debug_on THEN
590: WSH_DEBUG_SV.log(l_module_name, 'Return Status from Process_Shipment_Advice', x_return_status);
591: WSH_DEBUG_SV.logmsg(l_module_name,'');
592: WSH_DEBUG_SV.logmsg(l_module_name,'Summary:-');
593: WSH_DEBUG_SV.logmsg(l_module_name,'===================================');
594: WSH_DEBUG_SV.log(l_module_name,'No. of Shipment Advices selected for processing ', l_total);

Line 591: WSH_DEBUG_SV.logmsg(l_module_name,'');

587:
588: --
589: IF l_debug_on THEN
590: WSH_DEBUG_SV.log(l_module_name, 'Return Status from Process_Shipment_Advice', x_return_status);
591: WSH_DEBUG_SV.logmsg(l_module_name,'');
592: WSH_DEBUG_SV.logmsg(l_module_name,'Summary:-');
593: WSH_DEBUG_SV.logmsg(l_module_name,'===================================');
594: WSH_DEBUG_SV.log(l_module_name,'No. of Shipment Advices selected for processing ', l_total);
595: WSH_DEBUG_SV.log(l_module_name,'No. of Shipment Advices processed successfully ', l_success);

Line 592: WSH_DEBUG_SV.logmsg(l_module_name,'Summary:-');

588: --
589: IF l_debug_on THEN
590: WSH_DEBUG_SV.log(l_module_name, 'Return Status from Process_Shipment_Advice', x_return_status);
591: WSH_DEBUG_SV.logmsg(l_module_name,'');
592: WSH_DEBUG_SV.logmsg(l_module_name,'Summary:-');
593: WSH_DEBUG_SV.logmsg(l_module_name,'===================================');
594: WSH_DEBUG_SV.log(l_module_name,'No. of Shipment Advices selected for processing ', l_total);
595: WSH_DEBUG_SV.log(l_module_name,'No. of Shipment Advices processed successfully ', l_success);
596: WSH_DEBUG_SV.log(l_module_name,'No. of Shipment Advices errored during processing', l_errors);

Line 593: WSH_DEBUG_SV.logmsg(l_module_name,'===================================');

589: IF l_debug_on THEN
590: WSH_DEBUG_SV.log(l_module_name, 'Return Status from Process_Shipment_Advice', x_return_status);
591: WSH_DEBUG_SV.logmsg(l_module_name,'');
592: WSH_DEBUG_SV.logmsg(l_module_name,'Summary:-');
593: WSH_DEBUG_SV.logmsg(l_module_name,'===================================');
594: WSH_DEBUG_SV.log(l_module_name,'No. of Shipment Advices selected for processing ', l_total);
595: WSH_DEBUG_SV.log(l_module_name,'No. of Shipment Advices processed successfully ', l_success);
596: WSH_DEBUG_SV.log(l_module_name,'No. of Shipment Advices errored during processing', l_errors);
597: WSH_DEBUG_SV.pop(l_module_name);

Line 594: WSH_DEBUG_SV.log(l_module_name,'No. of Shipment Advices selected for processing ', l_total);

590: WSH_DEBUG_SV.log(l_module_name, 'Return Status from Process_Shipment_Advice', x_return_status);
591: WSH_DEBUG_SV.logmsg(l_module_name,'');
592: WSH_DEBUG_SV.logmsg(l_module_name,'Summary:-');
593: WSH_DEBUG_SV.logmsg(l_module_name,'===================================');
594: WSH_DEBUG_SV.log(l_module_name,'No. of Shipment Advices selected for processing ', l_total);
595: WSH_DEBUG_SV.log(l_module_name,'No. of Shipment Advices processed successfully ', l_success);
596: WSH_DEBUG_SV.log(l_module_name,'No. of Shipment Advices errored during processing', l_errors);
597: WSH_DEBUG_SV.pop(l_module_name);
598: -- To Print in Concurrent Request Output File

Line 595: WSH_DEBUG_SV.log(l_module_name,'No. of Shipment Advices processed successfully ', l_success);

591: WSH_DEBUG_SV.logmsg(l_module_name,'');
592: WSH_DEBUG_SV.logmsg(l_module_name,'Summary:-');
593: WSH_DEBUG_SV.logmsg(l_module_name,'===================================');
594: WSH_DEBUG_SV.log(l_module_name,'No. of Shipment Advices selected for processing ', l_total);
595: WSH_DEBUG_SV.log(l_module_name,'No. of Shipment Advices processed successfully ', l_success);
596: WSH_DEBUG_SV.log(l_module_name,'No. of Shipment Advices errored during processing', l_errors);
597: WSH_DEBUG_SV.pop(l_module_name);
598: -- To Print in Concurrent Request Output File
599: ELSIF FND_GLOBAL.Conc_Request_Id > 0 THEN

Line 596: WSH_DEBUG_SV.log(l_module_name,'No. of Shipment Advices errored during processing', l_errors);

592: WSH_DEBUG_SV.logmsg(l_module_name,'Summary:-');
593: WSH_DEBUG_SV.logmsg(l_module_name,'===================================');
594: WSH_DEBUG_SV.log(l_module_name,'No. of Shipment Advices selected for processing ', l_total);
595: WSH_DEBUG_SV.log(l_module_name,'No. of Shipment Advices processed successfully ', l_success);
596: WSH_DEBUG_SV.log(l_module_name,'No. of Shipment Advices errored during processing', l_errors);
597: WSH_DEBUG_SV.pop(l_module_name);
598: -- To Print in Concurrent Request Output File
599: ELSIF FND_GLOBAL.Conc_Request_Id > 0 THEN
600: FND_FILE.put_line(FND_FILE.output, 'Summary:-');

Line 597: WSH_DEBUG_SV.pop(l_module_name);

593: WSH_DEBUG_SV.logmsg(l_module_name,'===================================');
594: WSH_DEBUG_SV.log(l_module_name,'No. of Shipment Advices selected for processing ', l_total);
595: WSH_DEBUG_SV.log(l_module_name,'No. of Shipment Advices processed successfully ', l_success);
596: WSH_DEBUG_SV.log(l_module_name,'No. of Shipment Advices errored during processing', l_errors);
597: WSH_DEBUG_SV.pop(l_module_name);
598: -- To Print in Concurrent Request Output File
599: ELSIF FND_GLOBAL.Conc_Request_Id > 0 THEN
600: FND_FILE.put_line(FND_FILE.output, 'Summary:-');
601: FND_FILE.put_line(FND_FILE.output,'===================================');

Line 622: wsh_debug_sv.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

618: END IF;
619: END IF;
620: --
621: IF l_debug_on THEN
622: wsh_debug_sv.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
623: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
624: END IF;
625: --
626:

Line 623: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');

619: END IF;
620: --
621: IF l_debug_on THEN
622: wsh_debug_sv.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
623: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
624: END IF;
625: --
626:
627: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 641: wsh_debug_sv.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

637: END IF;
638: END IF;
639: --
640: IF l_debug_on THEN
641: wsh_debug_sv.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
642: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
643: END IF;
644: --
645:

Line 642: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

638: END IF;
639: --
640: IF l_debug_on THEN
641: wsh_debug_sv.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
642: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
643: END IF;
644: --
645:
646: WHEN OTHERS THEN

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

656: END IF;
657: END IF;
658: --
659: IF l_debug_on THEN
660: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
661: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
662: END IF;
663: --
664: END Process_Shipment_Advice;

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

657: END IF;
658: --
659: IF l_debug_on THEN
660: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
661: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
662: END IF;
663: --
664: END Process_Shipment_Advice;
665: