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

Line 36: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

32: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
33: --
34: IF l_debug_on IS NULL
35: THEN
36: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
37: END IF;
38: --
39: l_inputCount := x_inboundTxnHistory_recTbl.transaction_type.COUNT;
40: --

Line 44: WSH_DEBUG_SV.push(l_module_name);

40: --
41: -- Debug Statements
42: --
43: IF l_debug_on THEN
44: WSH_DEBUG_SV.push(l_module_name);
45: WSH_DEBUG_SV.log(l_module_name,'l_inputCount',l_inputCount);
46: END IF;
47: --
48: x_return_status := wsh_util_core.g_ret_sts_success;

Line 45: WSH_DEBUG_SV.log(l_module_name,'l_inputCount',l_inputCount);

41: -- Debug Statements
42: --
43: IF l_debug_on THEN
44: WSH_DEBUG_SV.push(l_module_name);
45: WSH_DEBUG_SV.log(l_module_name,'l_inputCount',l_inputCount);
46: END IF;
47: --
48: x_return_status := wsh_util_core.g_ret_sts_success;
49: --

Line 154: WSH_DEBUG_SV.log(l_module_name,'l_resultCount',l_resultCount);

150: THEN
151: --{
152: --
153: IF l_debug_on THEN
154: WSH_DEBUG_SV.log(l_module_name,'l_resultCount',l_resultCount);
155: END IF;
156: --
157: FND_MESSAGE.SET_NAME('WSH','WSH_IB_TXN_BULK_INSERT_ERROR');
158: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);

Line 167: WSH_DEBUG_SV.pop(l_module_name);

163: --
164: -- Debug Statements
165: --
166: IF l_debug_on THEN
167: WSH_DEBUG_SV.pop(l_module_name);
168: END IF;
169: --
170: EXCEPTION
171: --{

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

174: --
175: -- Debug Statements
176: --
177: IF l_debug_on THEN
178: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
179: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
180: END IF;
181: --
182: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

175: -- Debug Statements
176: --
177: IF l_debug_on THEN
178: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
179: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
180: END IF;
181: --
182: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
183: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

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

184: --
185: -- Debug Statements
186: --
187: IF l_debug_on THEN
188: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
189: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
190: END IF;
191: --
192: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

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

185: -- Debug Statements
186: --
187: IF l_debug_on THEN
188: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
189: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
190: END IF;
191: --
192: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
193: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 198: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

194: --
195: -- Debug Statements
196: --
197: IF l_debug_on THEN
198: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
199: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
200: END IF;
201: --
202: WHEN OTHERS THEN

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

195: -- Debug Statements
196: --
197: IF l_debug_on THEN
198: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
199: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
200: END IF;
201: --
202: WHEN OTHERS THEN
203: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

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

206: --
207: -- Debug Statements
208: --
209: IF l_debug_on THEN
210: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
211: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
212: END IF;
213: --
214: END create_txn_history_bulk;

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

207: -- Debug Statements
208: --
209: IF l_debug_on THEN
210: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
211: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
212: END IF;
213: --
214: END create_txn_history_bulk;
215:

Line 241: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

237: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
238: --
239: IF l_debug_on IS NULL
240: THEN
241: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
242: END IF;
243: --
244: --
245: -- Debug Statements

Line 248: WSH_DEBUG_SV.push(l_module_name);

244: --
245: -- Debug Statements
246: --
247: IF l_debug_on THEN
248: WSH_DEBUG_SV.push(l_module_name);
249: END IF;
250: --
251: x_return_status := wsh_util_core.g_ret_sts_success;
252: --

Line 255: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit create_txn_history_bulk',WSH_DEBUG_SV.C_PROC_LEVEL);

251: x_return_status := wsh_util_core.g_ret_sts_success;
252: --
253: --
254: IF l_debug_on THEN
255: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit create_txn_history_bulk',WSH_DEBUG_SV.C_PROC_LEVEL);
256: END IF;
257: --
258: create_txn_history_bulk
259: (

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

261: x_return_status => l_return_status
262: );
263: --
264: IF l_debug_on THEN
265: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
266: END IF;
267: --
268: wsh_util_core.api_post_call
269: (

Line 278: WSH_DEBUG_SV.logmsg(l_module_name,

274: --
275: COMMIT;
276: --
277: IF l_debug_on THEN
278: WSH_DEBUG_SV.logmsg(l_module_name,
279: 'Number of Errors='||l_num_errors||',Number of Warnings='||l_num_warnings);
280: END IF;
281: --
282: IF l_num_errors > 0

Line 294: WSH_DEBUG_SV.pop(l_module_name);

290: END IF;
291: --
292: --
293: IF l_debug_on THEN
294: WSH_DEBUG_SV.pop(l_module_name);
295: END IF;
296: --
297: --}
298: EXCEPTION

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

303: --
304: -- Debug Statements
305: --
306: IF l_debug_on THEN
307: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
308: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
309: END IF;
310: --
311: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

304: -- Debug Statements
305: --
306: IF l_debug_on THEN
307: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
308: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
309: END IF;
310: --
311: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
312: ROLLBACK;

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

314: --
315: -- Debug Statements
316: --
317: IF l_debug_on THEN
318: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
319: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
320: END IF;
321: --
322: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

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

315: -- Debug Statements
316: --
317: IF l_debug_on THEN
318: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
319: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
320: END IF;
321: --
322: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
323: COMMIT;

Line 329: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

325: --
326: -- Debug Statements
327: --
328: IF l_debug_on THEN
329: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
330: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
331: END IF;
332: --
333: WHEN OTHERS THEN

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

326: -- Debug Statements
327: --
328: IF l_debug_on THEN
329: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
330: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
331: END IF;
332: --
333: WHEN OTHERS THEN
334: ROLLBACK;

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

338: --
339: -- Debug Statements
340: --
341: IF l_debug_on THEN
342: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
343: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
344: END IF;
345: --
346: END autonomous_Create_bulk;

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

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

Line 392: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

388: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
389: --
390: IF l_debug_on IS NULL
391: THEN
392: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
393: END IF;
394: --
395: --
396: -- Debug Statements

Line 399: WSH_DEBUG_SV.push(l_module_name);

395: --
396: -- Debug Statements
397: --
398: IF l_debug_on THEN
399: WSH_DEBUG_SV.push(l_module_name);
400: END IF;
401: --
402: x_return_status := wsh_util_core.g_ret_sts_success;
403:

Line 495: WSH_DEBUG_SV.pop(l_module_name);

491: --
492: -- Debug Statements
493: --
494: IF l_debug_on THEN
495: WSH_DEBUG_SV.pop(l_module_name);
496: END IF;
497: --
498: EXCEPTION
499: --{

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

502: --
503: -- Debug Statements
504: --
505: IF l_debug_on THEN
506: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
507: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
508: END IF;
509: --
510: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

503: -- Debug Statements
504: --
505: IF l_debug_on THEN
506: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
507: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
508: END IF;
509: --
510: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
511: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

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

512: --
513: -- Debug Statements
514: --
515: IF l_debug_on THEN
516: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
517: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
518: END IF;
519: --
520: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

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

513: -- Debug Statements
514: --
515: IF l_debug_on THEN
516: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
517: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
518: END IF;
519: --
520: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
521: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 526: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

522: --
523: -- Debug Statements
524: --
525: IF l_debug_on THEN
526: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
527: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
528: END IF;
529: --
530: WHEN OTHERS THEN

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

523: -- Debug Statements
524: --
525: IF l_debug_on THEN
526: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
527: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
528: END IF;
529: --
530: WHEN OTHERS THEN
531: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

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

534: --
535: -- Debug Statements
536: --
537: IF l_debug_on THEN
538: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
539: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
540: END IF;
541: --
542: END create_txn_history;

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

535: -- Debug Statements
536: --
537: IF l_debug_on THEN
538: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
539: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
540: END IF;
541: --
542: END create_txn_history;
543:

Line 568: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

564: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
565: --
566: IF l_debug_on IS NULL
567: THEN
568: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
569: END IF;
570: --
571: --
572: -- Debug Statements

Line 575: WSH_DEBUG_SV.push(l_module_name);

571: --
572: -- Debug Statements
573: --
574: IF l_debug_on THEN
575: WSH_DEBUG_SV.push(l_module_name);
576: END IF;
577: --
578: x_return_status := wsh_util_core.g_ret_sts_success;
579: --

Line 582: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit create_txn_history',WSH_DEBUG_SV.C_PROC_LEVEL);

578: x_return_status := wsh_util_core.g_ret_sts_success;
579: --
580: --
581: IF l_debug_on THEN
582: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit create_txn_history',WSH_DEBUG_SV.C_PROC_LEVEL);
583: END IF;
584: --
585: create_txn_history
586: (

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

589: x_return_status => l_return_status
590: );
591: --
592: IF l_debug_on THEN
593: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
594: END IF;
595: --
596: wsh_util_core.api_post_call
597: (

Line 606: WSH_DEBUG_SV.logmsg(l_module_name,

602: --
603: COMMIT;
604: --
605: IF l_debug_on THEN
606: WSH_DEBUG_SV.logmsg(l_module_name,
607: 'Number of Errors='||l_num_errors||',Number of Warnings='||l_num_warnings);
608: END IF;
609: --
610: IF l_num_errors > 0

Line 622: WSH_DEBUG_SV.pop(l_module_name);

618: END IF;
619: --
620: --
621: IF l_debug_on THEN
622: WSH_DEBUG_SV.pop(l_module_name);
623: END IF;
624: --
625: --}
626: EXCEPTION

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

631: --
632: -- Debug Statements
633: --
634: IF l_debug_on THEN
635: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
636: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
637: END IF;
638: --
639: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

632: -- Debug Statements
633: --
634: IF l_debug_on THEN
635: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
636: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
637: END IF;
638: --
639: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
640: ROLLBACK;

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

642: --
643: -- Debug Statements
644: --
645: IF l_debug_on THEN
646: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
647: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
648: END IF;
649: --
650: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

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

643: -- Debug Statements
644: --
645: IF l_debug_on THEN
646: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
647: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
648: END IF;
649: --
650: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
651: COMMIT;

Line 657: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

653: --
654: -- Debug Statements
655: --
656: IF l_debug_on THEN
657: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
658: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
659: END IF;
660: --
661: WHEN OTHERS THEN

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

654: -- Debug Statements
655: --
656: IF l_debug_on THEN
657: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
658: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
659: END IF;
660: --
661: WHEN OTHERS THEN
662: ROLLBACK;

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

666: --
667: -- Debug Statements
668: --
669: IF l_debug_on THEN
670: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
671: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
672: END IF;
673: --
674: END autonomous_Create;

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

667: -- Debug Statements
668: --
669: IF l_debug_on THEN
670: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
671: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
672: END IF;
673: --
674: END autonomous_Create;
675:

Line 708: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

704: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
705: --
706: IF l_debug_on IS NULL
707: THEN
708: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
709: END IF;
710: --
711: --
712: -- Debug Statements

Line 715: WSH_DEBUG_SV.push(l_module_name);

711: --
712: -- Debug Statements
713: --
714: IF l_debug_on THEN
715: WSH_DEBUG_SV.push(l_module_name);
716: END IF;
717: --
718: x_return_status := wsh_util_core.g_ret_sts_success;
719: update wsh_inbound_txn_history

Line 834: WSH_DEBUG_SV.pop(l_module_name);

830: --
831: -- Debug Statements
832: --
833: IF l_debug_on THEN
834: WSH_DEBUG_SV.pop(l_module_name);
835: END IF;
836: --
837: EXCEPTION
838: --{

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

841: --
842: -- Debug Statements
843: --
844: IF l_debug_on THEN
845: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
846: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
847: END IF;
848: --
849: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

842: -- Debug Statements
843: --
844: IF l_debug_on THEN
845: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
846: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
847: END IF;
848: --
849: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
850: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

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

851: --
852: -- Debug Statements
853: --
854: IF l_debug_on THEN
855: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
856: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
857: END IF;
858: --
859: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

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

852: -- Debug Statements
853: --
854: IF l_debug_on THEN
855: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
856: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
857: END IF;
858: --
859: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
860: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 865: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

861: --
862: -- Debug Statements
863: --
864: IF l_debug_on THEN
865: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
866: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
867: END IF;
868: --
869: WHEN OTHERS THEN

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

862: -- Debug Statements
863: --
864: IF l_debug_on THEN
865: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
866: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
867: END IF;
868: --
869: WHEN OTHERS THEN
870: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

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

873: --
874: -- Debug Statements
875: --
876: IF l_debug_on THEN
877: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
878: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
879: END IF;
880: --
881: END update_txn_history;

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

874: -- Debug Statements
875: --
876: IF l_debug_on THEN
877: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
878: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
879: END IF;
880: --
881: END update_txn_history;
882:

Line 916: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

912: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
913: --
914: IF l_debug_on IS NULL
915: THEN
916: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
917: END IF;
918: --
919: --
920: -- Debug Statements

Line 923: WSH_DEBUG_SV.push(l_module_name);

919: --
920: -- Debug Statements
921: --
922: IF l_debug_on THEN
923: WSH_DEBUG_SV.push(l_module_name);
924: --
925: WSH_DEBUG_SV.log(l_module_name,'P_TRANSACTION_ID',P_TRANSACTION_ID);
926: END IF;
927: --

Line 925: WSH_DEBUG_SV.log(l_module_name,'P_TRANSACTION_ID',P_TRANSACTION_ID);

921: --
922: IF l_debug_on THEN
923: WSH_DEBUG_SV.push(l_module_name);
924: --
925: WSH_DEBUG_SV.log(l_module_name,'P_TRANSACTION_ID',P_TRANSACTION_ID);
926: END IF;
927: --
928: x_return_status := wsh_util_core.g_ret_sts_success;
929: delete from wsh_inbound_txn_history

Line 936: WSH_DEBUG_SV.pop(l_module_name);

932: --
933: -- Debug Statements
934: --
935: IF l_debug_on THEN
936: WSH_DEBUG_SV.pop(l_module_name);
937: END IF;
938: --
939: EXCEPTION
940: --{

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

943: --
944: -- Debug Statements
945: --
946: IF l_debug_on THEN
947: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
948: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
949: END IF;
950: --
951: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

944: -- Debug Statements
945: --
946: IF l_debug_on THEN
947: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
948: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
949: END IF;
950: --
951: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
952: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

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

953: --
954: -- Debug Statements
955: --
956: IF l_debug_on THEN
957: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
958: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
959: END IF;
960: --
961: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

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

954: -- Debug Statements
955: --
956: IF l_debug_on THEN
957: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
958: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
959: END IF;
960: --
961: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
962: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 967: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

963: --
964: -- Debug Statements
965: --
966: IF l_debug_on THEN
967: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
968: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
969: END IF;
970: --
971: WHEN OTHERS THEN

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

964: -- Debug Statements
965: --
966: IF l_debug_on THEN
967: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
968: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
969: END IF;
970: --
971: WHEN OTHERS THEN
972: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

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

975: --
976: -- Debug Statements
977: --
978: IF l_debug_on THEN
979: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
980: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
981: END IF;
982: --
983: END delete_txn_history;

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

976: -- Debug Statements
977: --
978: IF l_debug_on THEN
979: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
980: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
981: END IF;
982: --
983: END delete_txn_history;
984:

Line 1053: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1049: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1050: --
1051: IF l_debug_on IS NULL
1052: THEN
1053: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1054: END IF;
1055: --
1056: --
1057: -- Debug Statements

Line 1060: WSH_DEBUG_SV.push(l_module_name);

1056: --
1057: -- Debug Statements
1058: --
1059: IF l_debug_on THEN
1060: WSH_DEBUG_SV.push(l_module_name);
1061: --
1062: WSH_DEBUG_SV.log(l_module_name,'P_TRANSACTION_ID',P_TRANSACTION_ID);
1063: WSH_DEBUG_SV.log(l_module_name,'P_SHIPMENT_HEADER_ID',P_SHIPMENT_HEADER_ID);
1064: WSH_DEBUG_SV.log(l_module_name,'P_TRANSACTION_TYPE',P_TRANSACTION_TYPE);

Line 1062: WSH_DEBUG_SV.log(l_module_name,'P_TRANSACTION_ID',P_TRANSACTION_ID);

1058: --
1059: IF l_debug_on THEN
1060: WSH_DEBUG_SV.push(l_module_name);
1061: --
1062: WSH_DEBUG_SV.log(l_module_name,'P_TRANSACTION_ID',P_TRANSACTION_ID);
1063: WSH_DEBUG_SV.log(l_module_name,'P_SHIPMENT_HEADER_ID',P_SHIPMENT_HEADER_ID);
1064: WSH_DEBUG_SV.log(l_module_name,'P_TRANSACTION_TYPE',P_TRANSACTION_TYPE);
1065: END IF;
1066: --

Line 1063: WSH_DEBUG_SV.log(l_module_name,'P_SHIPMENT_HEADER_ID',P_SHIPMENT_HEADER_ID);

1059: IF l_debug_on THEN
1060: WSH_DEBUG_SV.push(l_module_name);
1061: --
1062: WSH_DEBUG_SV.log(l_module_name,'P_TRANSACTION_ID',P_TRANSACTION_ID);
1063: WSH_DEBUG_SV.log(l_module_name,'P_SHIPMENT_HEADER_ID',P_SHIPMENT_HEADER_ID);
1064: WSH_DEBUG_SV.log(l_module_name,'P_TRANSACTION_TYPE',P_TRANSACTION_TYPE);
1065: END IF;
1066: --
1067: x_return_status := wsh_util_core.g_ret_sts_success;

Line 1064: WSH_DEBUG_SV.log(l_module_name,'P_TRANSACTION_TYPE',P_TRANSACTION_TYPE);

1060: WSH_DEBUG_SV.push(l_module_name);
1061: --
1062: WSH_DEBUG_SV.log(l_module_name,'P_TRANSACTION_ID',P_TRANSACTION_ID);
1063: WSH_DEBUG_SV.log(l_module_name,'P_SHIPMENT_HEADER_ID',P_SHIPMENT_HEADER_ID);
1064: WSH_DEBUG_SV.log(l_module_name,'P_TRANSACTION_TYPE',P_TRANSACTION_TYPE);
1065: END IF;
1066: --
1067: x_return_status := wsh_util_core.g_ret_sts_success;
1068: IF (p_transaction_id IS NULL AND (p_shipment_header_id IS NULL or p_transaction_type is NULL) ) THEN

Line 1081: WSH_DEBUG_SV.pop(l_module_name);

1077: --
1078: -- Debug Statements
1079: --
1080: IF l_debug_on THEN
1081: WSH_DEBUG_SV.pop(l_module_name);
1082: END IF;
1083: --
1084: EXCEPTION
1085: --{

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

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

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

1089: -- Debug Statements
1090: --
1091: IF l_debug_on THEN
1092: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1093: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1094: END IF;
1095: --
1096: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1097: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

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

1098: --
1099: -- Debug Statements
1100: --
1101: IF l_debug_on THEN
1102: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1103: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1104: END IF;
1105: --
1106: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

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

1099: -- Debug Statements
1100: --
1101: IF l_debug_on THEN
1102: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1103: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1104: END IF;
1105: --
1106: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
1107: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 1112: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

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

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

1109: -- Debug Statements
1110: --
1111: IF l_debug_on THEN
1112: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1113: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
1114: END IF;
1115: --
1116: WHEN OTHERS THEN
1117: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

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

1120: --
1121: -- Debug Statements
1122: --
1123: IF l_debug_on THEN
1124: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1125: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1126: END IF;
1127: --
1128: END get_txn_history;

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

1121: -- Debug Statements
1122: --
1123: IF l_debug_on THEN
1124: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1125: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1126: END IF;
1127: --
1128: END get_txn_history;
1129: --

Line 1251: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1247: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1248: --
1249: IF l_debug_on IS NULL
1250: THEN
1251: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1252: END IF;
1253: --
1254: --
1255: -- Debug Statements

Line 1258: WSH_DEBUG_SV.push(l_module_name);

1254: --
1255: -- Debug Statements
1256: --
1257: IF l_debug_on THEN
1258: WSH_DEBUG_SV.push(l_module_name);
1259: --
1260: WSH_DEBUG_SV.log(l_module_name,'P_SHIPMENT_HEADER_ID',P_SHIPMENT_HEADER_ID);
1261: WSH_DEBUG_SV.log(l_module_name,'P_MAX_RCV_TXN_ID',P_MAX_RCV_TXN_ID);
1262: WSH_DEBUG_SV.log(l_module_name,'P_TXN_STATUS',P_TXN_STATUS);

Line 1260: WSH_DEBUG_SV.log(l_module_name,'P_SHIPMENT_HEADER_ID',P_SHIPMENT_HEADER_ID);

1256: --
1257: IF l_debug_on THEN
1258: WSH_DEBUG_SV.push(l_module_name);
1259: --
1260: WSH_DEBUG_SV.log(l_module_name,'P_SHIPMENT_HEADER_ID',P_SHIPMENT_HEADER_ID);
1261: WSH_DEBUG_SV.log(l_module_name,'P_MAX_RCV_TXN_ID',P_MAX_RCV_TXN_ID);
1262: WSH_DEBUG_SV.log(l_module_name,'P_TXN_STATUS',P_TXN_STATUS);
1263: WSH_DEBUG_SV.log(l_module_name,'P_TXN_TYPE',P_TXN_TYPE);
1264: END IF;

Line 1261: WSH_DEBUG_SV.log(l_module_name,'P_MAX_RCV_TXN_ID',P_MAX_RCV_TXN_ID);

1257: IF l_debug_on THEN
1258: WSH_DEBUG_SV.push(l_module_name);
1259: --
1260: WSH_DEBUG_SV.log(l_module_name,'P_SHIPMENT_HEADER_ID',P_SHIPMENT_HEADER_ID);
1261: WSH_DEBUG_SV.log(l_module_name,'P_MAX_RCV_TXN_ID',P_MAX_RCV_TXN_ID);
1262: WSH_DEBUG_SV.log(l_module_name,'P_TXN_STATUS',P_TXN_STATUS);
1263: WSH_DEBUG_SV.log(l_module_name,'P_TXN_TYPE',P_TXN_TYPE);
1264: END IF;
1265: --

Line 1262: WSH_DEBUG_SV.log(l_module_name,'P_TXN_STATUS',P_TXN_STATUS);

1258: WSH_DEBUG_SV.push(l_module_name);
1259: --
1260: WSH_DEBUG_SV.log(l_module_name,'P_SHIPMENT_HEADER_ID',P_SHIPMENT_HEADER_ID);
1261: WSH_DEBUG_SV.log(l_module_name,'P_MAX_RCV_TXN_ID',P_MAX_RCV_TXN_ID);
1262: WSH_DEBUG_SV.log(l_module_name,'P_TXN_STATUS',P_TXN_STATUS);
1263: WSH_DEBUG_SV.log(l_module_name,'P_TXN_TYPE',P_TXN_TYPE);
1264: END IF;
1265: --
1266: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 1263: WSH_DEBUG_SV.log(l_module_name,'P_TXN_TYPE',P_TXN_TYPE);

1259: --
1260: WSH_DEBUG_SV.log(l_module_name,'P_SHIPMENT_HEADER_ID',P_SHIPMENT_HEADER_ID);
1261: WSH_DEBUG_SV.log(l_module_name,'P_MAX_RCV_TXN_ID',P_MAX_RCV_TXN_ID);
1262: WSH_DEBUG_SV.log(l_module_name,'P_TXN_STATUS',P_TXN_STATUS);
1263: WSH_DEBUG_SV.log(l_module_name,'P_TXN_TYPE',P_TXN_TYPE);
1264: END IF;
1265: --
1266: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1267: --

Line 1271: WSH_DEBUG_SV.pop(l_module_name);

1267: --
1268: -- Debug Statements
1269: --
1270: IF l_debug_on THEN
1271: WSH_DEBUG_SV.pop(l_module_name);
1272: END IF;
1273: --
1274: EXCEPTION
1275: --{

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

1278: --
1279: -- Debug Statements
1280: --
1281: IF l_debug_on THEN
1282: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1283: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1284: END IF;
1285: --
1286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1279: -- Debug Statements
1280: --
1281: IF l_debug_on THEN
1282: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1283: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1284: END IF;
1285: --
1286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1287: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

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

1288: --
1289: -- Debug Statements
1290: --
1291: IF l_debug_on THEN
1292: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1293: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1294: END IF;
1295: --
1296: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

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

1289: -- Debug Statements
1290: --
1291: IF l_debug_on THEN
1292: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1293: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1294: END IF;
1295: --
1296: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
1297: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 1302: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1298: --
1299: -- Debug Statements
1300: --
1301: IF l_debug_on THEN
1302: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1303: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
1304: END IF;
1305: --
1306: WHEN OTHERS THEN

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

1299: -- Debug Statements
1300: --
1301: IF l_debug_on THEN
1302: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1303: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
1304: END IF;
1305: --
1306: WHEN OTHERS THEN
1307: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

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

1310: --
1311: -- Debug Statements
1312: --
1313: IF l_debug_on THEN
1314: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1315: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1316: END IF;
1317: --
1318: END post_process;

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

1311: -- Debug Statements
1312: --
1313: IF l_debug_on THEN
1314: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1315: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1316: END IF;
1317: --
1318: END post_process;
1319:

Line 1362: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1358: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1359: --
1360: IF l_debug_on IS NULL
1361: THEN
1362: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1363: END IF;
1364: --
1365: --
1366: -- Debug Statements

Line 1369: WSH_DEBUG_SV.push(l_module_name);

1365: --
1366: -- Debug Statements
1367: --
1368: IF l_debug_on THEN
1369: WSH_DEBUG_SV.push(l_module_name);
1370: --
1371: WSH_DEBUG_SV.log(l_module_name,'P_SHIPMENT_HEADER_ID',P_SHIPMENT_HEADER_ID);
1372: WSH_DEBUG_SV.log(l_module_name,'P_MAX_RCV_TXN_ID',P_MAX_RCV_TXN_ID);
1373: WSH_DEBUG_SV.log(l_module_name,'P_ACTION_CODE',P_ACTION_CODE);

Line 1371: WSH_DEBUG_SV.log(l_module_name,'P_SHIPMENT_HEADER_ID',P_SHIPMENT_HEADER_ID);

1367: --
1368: IF l_debug_on THEN
1369: WSH_DEBUG_SV.push(l_module_name);
1370: --
1371: WSH_DEBUG_SV.log(l_module_name,'P_SHIPMENT_HEADER_ID',P_SHIPMENT_HEADER_ID);
1372: WSH_DEBUG_SV.log(l_module_name,'P_MAX_RCV_TXN_ID',P_MAX_RCV_TXN_ID);
1373: WSH_DEBUG_SV.log(l_module_name,'P_ACTION_CODE',P_ACTION_CODE);
1374: WSH_DEBUG_SV.log(l_module_name,'P_TXN_TYPE',P_TXN_TYPE);
1375: WSH_DEBUG_SV.log(l_module_name,'P_OBJECT_VERSION_NUMBER',P_OBJECT_VERSION_NUMBER);

Line 1372: WSH_DEBUG_SV.log(l_module_name,'P_MAX_RCV_TXN_ID',P_MAX_RCV_TXN_ID);

1368: IF l_debug_on THEN
1369: WSH_DEBUG_SV.push(l_module_name);
1370: --
1371: WSH_DEBUG_SV.log(l_module_name,'P_SHIPMENT_HEADER_ID',P_SHIPMENT_HEADER_ID);
1372: WSH_DEBUG_SV.log(l_module_name,'P_MAX_RCV_TXN_ID',P_MAX_RCV_TXN_ID);
1373: WSH_DEBUG_SV.log(l_module_name,'P_ACTION_CODE',P_ACTION_CODE);
1374: WSH_DEBUG_SV.log(l_module_name,'P_TXN_TYPE',P_TXN_TYPE);
1375: WSH_DEBUG_SV.log(l_module_name,'P_OBJECT_VERSION_NUMBER',P_OBJECT_VERSION_NUMBER);
1376: END IF;

Line 1373: WSH_DEBUG_SV.log(l_module_name,'P_ACTION_CODE',P_ACTION_CODE);

1369: WSH_DEBUG_SV.push(l_module_name);
1370: --
1371: WSH_DEBUG_SV.log(l_module_name,'P_SHIPMENT_HEADER_ID',P_SHIPMENT_HEADER_ID);
1372: WSH_DEBUG_SV.log(l_module_name,'P_MAX_RCV_TXN_ID',P_MAX_RCV_TXN_ID);
1373: WSH_DEBUG_SV.log(l_module_name,'P_ACTION_CODE',P_ACTION_CODE);
1374: WSH_DEBUG_SV.log(l_module_name,'P_TXN_TYPE',P_TXN_TYPE);
1375: WSH_DEBUG_SV.log(l_module_name,'P_OBJECT_VERSION_NUMBER',P_OBJECT_VERSION_NUMBER);
1376: END IF;
1377: --

Line 1374: WSH_DEBUG_SV.log(l_module_name,'P_TXN_TYPE',P_TXN_TYPE);

1370: --
1371: WSH_DEBUG_SV.log(l_module_name,'P_SHIPMENT_HEADER_ID',P_SHIPMENT_HEADER_ID);
1372: WSH_DEBUG_SV.log(l_module_name,'P_MAX_RCV_TXN_ID',P_MAX_RCV_TXN_ID);
1373: WSH_DEBUG_SV.log(l_module_name,'P_ACTION_CODE',P_ACTION_CODE);
1374: WSH_DEBUG_SV.log(l_module_name,'P_TXN_TYPE',P_TXN_TYPE);
1375: WSH_DEBUG_SV.log(l_module_name,'P_OBJECT_VERSION_NUMBER',P_OBJECT_VERSION_NUMBER);
1376: END IF;
1377: --
1378: x_return_status := wsh_util_core.g_ret_sts_success;

Line 1375: WSH_DEBUG_SV.log(l_module_name,'P_OBJECT_VERSION_NUMBER',P_OBJECT_VERSION_NUMBER);

1371: WSH_DEBUG_SV.log(l_module_name,'P_SHIPMENT_HEADER_ID',P_SHIPMENT_HEADER_ID);
1372: WSH_DEBUG_SV.log(l_module_name,'P_MAX_RCV_TXN_ID',P_MAX_RCV_TXN_ID);
1373: WSH_DEBUG_SV.log(l_module_name,'P_ACTION_CODE',P_ACTION_CODE);
1374: WSH_DEBUG_SV.log(l_module_name,'P_TXN_TYPE',P_TXN_TYPE);
1375: WSH_DEBUG_SV.log(l_module_name,'P_OBJECT_VERSION_NUMBER',P_OBJECT_VERSION_NUMBER);
1376: END IF;
1377: --
1378: x_return_status := wsh_util_core.g_ret_sts_success;
1379: --

Line 1382: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit lock_asn_receipt_header',WSH_DEBUG_SV.C_PROC_LEVEL);

1378: x_return_status := wsh_util_core.g_ret_sts_success;
1379: --
1380: --
1381: IF l_debug_on THEN
1382: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit lock_asn_receipt_header',WSH_DEBUG_SV.C_PROC_LEVEL);
1383: END IF;
1384: --
1385: lock_asn_receipt_header
1386: (

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

1397: --
1398: -- Debug Statements
1399: --
1400: IF l_debug_on THEN
1401: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1402: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1403: END IF;
1404: --
1405: wsh_util_core.api_post_call

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

1398: -- Debug Statements
1399: --
1400: IF l_debug_on THEN
1401: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1402: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1403: END IF;
1404: --
1405: wsh_util_core.api_post_call
1406: (

Line 1418: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit lock_asn_receipt_header for receipt-asn',WSH_DEBUG_SV.C_PROC_LEVEL);

1414: AND p_action_code = 'REVERT'
1415: THEN
1416: --{
1417: IF l_debug_on THEN
1418: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit lock_asn_receipt_header for receipt-asn',WSH_DEBUG_SV.C_PROC_LEVEL);
1419: END IF;
1420: --
1421: lock_asn_receipt_header
1422: (

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

1433: --
1434: -- Debug Statements
1435: --
1436: IF l_debug_on THEN
1437: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1438: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1439: END IF;
1440: --
1441: wsh_util_core.api_post_call

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

1434: -- Debug Statements
1435: --
1436: IF l_debug_on THEN
1437: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1438: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1439: END IF;
1440: --
1441: wsh_util_core.api_post_call
1442: (

Line 1505: WSH_DEBUG_SV.log(l_module_name,'Number of Records deleted from transaction history',SQL%ROWCOUNT);

1501: AND shipment_header_id = p_shipment_header_id
1502: AND max_rcv_transaction_id <= l_txn_id;
1503: --
1504: IF l_debug_on THEN
1505: WSH_DEBUG_SV.log(l_module_name,'Number of Records deleted from transaction history',SQL%ROWCOUNT);
1506: END IF;
1507: --
1508: --}
1509: END IF;

Line 1543: WSH_DEBUG_SV.log(l_module_name,'l_txn_history_rec.status',l_txn_history_rec.status);

1539: END IF;
1540: --
1541: --
1542: IF l_debug_on THEN
1543: WSH_DEBUG_SV.log(l_module_name,'l_txn_history_rec.status',l_txn_history_rec.status);
1544: WSH_DEBUG_SV.log(l_module_name,'l_txn_history_rec.MATCH_REVERTED_BY',l_txn_history_rec.MATCH_REVERTED_BY);
1545: WSH_DEBUG_SV.log(l_module_name,'l_txn_history_rec.MATCHED_BY',l_txn_history_rec.MATCHED_BY);
1546: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit update_txn_history',WSH_DEBUG_SV.C_PROC_LEVEL);
1547: END IF;

Line 1544: WSH_DEBUG_SV.log(l_module_name,'l_txn_history_rec.MATCH_REVERTED_BY',l_txn_history_rec.MATCH_REVERTED_BY);

1540: --
1541: --
1542: IF l_debug_on THEN
1543: WSH_DEBUG_SV.log(l_module_name,'l_txn_history_rec.status',l_txn_history_rec.status);
1544: WSH_DEBUG_SV.log(l_module_name,'l_txn_history_rec.MATCH_REVERTED_BY',l_txn_history_rec.MATCH_REVERTED_BY);
1545: WSH_DEBUG_SV.log(l_module_name,'l_txn_history_rec.MATCHED_BY',l_txn_history_rec.MATCHED_BY);
1546: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit update_txn_history',WSH_DEBUG_SV.C_PROC_LEVEL);
1547: END IF;
1548: --

Line 1545: WSH_DEBUG_SV.log(l_module_name,'l_txn_history_rec.MATCHED_BY',l_txn_history_rec.MATCHED_BY);

1541: --
1542: IF l_debug_on THEN
1543: WSH_DEBUG_SV.log(l_module_name,'l_txn_history_rec.status',l_txn_history_rec.status);
1544: WSH_DEBUG_SV.log(l_module_name,'l_txn_history_rec.MATCH_REVERTED_BY',l_txn_history_rec.MATCH_REVERTED_BY);
1545: WSH_DEBUG_SV.log(l_module_name,'l_txn_history_rec.MATCHED_BY',l_txn_history_rec.MATCHED_BY);
1546: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit update_txn_history',WSH_DEBUG_SV.C_PROC_LEVEL);
1547: END IF;
1548: --
1549: update_txn_history

Line 1546: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit update_txn_history',WSH_DEBUG_SV.C_PROC_LEVEL);

1542: IF l_debug_on THEN
1543: WSH_DEBUG_SV.log(l_module_name,'l_txn_history_rec.status',l_txn_history_rec.status);
1544: WSH_DEBUG_SV.log(l_module_name,'l_txn_history_rec.MATCH_REVERTED_BY',l_txn_history_rec.MATCH_REVERTED_BY);
1545: WSH_DEBUG_SV.log(l_module_name,'l_txn_history_rec.MATCHED_BY',l_txn_history_rec.MATCHED_BY);
1546: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit update_txn_history',WSH_DEBUG_SV.C_PROC_LEVEL);
1547: END IF;
1548: --
1549: update_txn_history
1550: (

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

1556: --
1557: -- Debug Statements
1558: --
1559: IF l_debug_on THEN
1560: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1561: END IF;
1562: --
1563: wsh_util_core.api_post_call
1564: (

Line 1577: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit update_txn_history:receipt-asn',WSH_DEBUG_SV.C_PROC_LEVEL);

1573: AND l_Receipttxn_history_rec.transaction_id IS NOT NULL
1574: THEN
1575: --{
1576: IF l_debug_on THEN
1577: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit update_txn_history:receipt-asn',WSH_DEBUG_SV.C_PROC_LEVEL);
1578: END IF;
1579: --
1580: update_txn_history
1581: (

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

1587: --
1588: -- Debug Statements
1589: --
1590: IF l_debug_on THEN
1591: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1592: END IF;
1593: --
1594: wsh_util_core.api_post_call
1595: (

Line 1605: WSH_DEBUG_SV.logmsg(l_module_name,

1601: END IF;
1602: --
1603: --
1604: IF l_debug_on THEN
1605: WSH_DEBUG_SV.logmsg(l_module_name,
1606: 'Number of Errors='||l_num_errors||',Number of Warnings='||l_num_warnings);
1607: END IF;
1608: --
1609: IF l_num_errors > 0

Line 1620: WSH_DEBUG_SV.pop(l_module_name);

1616: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1617: END IF;
1618: --
1619: IF l_debug_on THEN
1620: WSH_DEBUG_SV.pop(l_module_name);
1621: END IF;
1622: --
1623: --}
1624: EXCEPTION

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

1628: --
1629: -- Debug Statements
1630: --
1631: IF l_debug_on THEN
1632: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1633: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1634: END IF;
1635: --
1636: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1629: -- Debug Statements
1630: --
1631: IF l_debug_on THEN
1632: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1633: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1634: END IF;
1635: --
1636: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1637: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

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

1638: --
1639: -- Debug Statements
1640: --
1641: IF l_debug_on THEN
1642: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1643: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1644: END IF;
1645: --
1646: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

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

1639: -- Debug Statements
1640: --
1641: IF l_debug_on THEN
1642: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1643: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1644: END IF;
1645: --
1646: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
1647: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 1652: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1648: --
1649: -- Debug Statements
1650: --
1651: IF l_debug_on THEN
1652: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1653: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
1654: END IF;
1655: --
1656: WHEN OTHERS THEN

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

1649: -- Debug Statements
1650: --
1651: IF l_debug_on THEN
1652: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1653: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
1654: END IF;
1655: --
1656: WHEN OTHERS THEN
1657: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

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

1659: --
1660: -- Debug Statements
1661: --
1662: IF l_debug_on THEN
1663: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1664: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1665: END IF;
1666: --
1667: --}

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

1660: -- Debug Statements
1661: --
1662: IF l_debug_on THEN
1663: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1664: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1665: END IF;
1666: --
1667: --}
1668: END post_process;

Line 1727: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1723: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1724: --
1725: IF l_debug_on IS NULL
1726: THEN
1727: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1728: END IF;
1729: --
1730: --
1731: -- Debug Statements

Line 1734: WSH_DEBUG_SV.push(l_module_name);

1730: --
1731: -- Debug Statements
1732: --
1733: IF l_debug_on THEN
1734: WSH_DEBUG_SV.push(l_module_name);
1735: --
1736: WSH_DEBUG_SV.log(l_module_name,'P_SHIPMENT_HEADER_ID',P_SHIPMENT_HEADER_ID);
1737: WSH_DEBUG_SV.log(l_module_name,'P_TRANSACTION_TYPE',P_TRANSACTION_TYPE);
1738: WSH_DEBUG_SV.log(l_module_name,'P_ON_ERROR',P_ON_ERROR);

Line 1736: WSH_DEBUG_SV.log(l_module_name,'P_SHIPMENT_HEADER_ID',P_SHIPMENT_HEADER_ID);

1732: --
1733: IF l_debug_on THEN
1734: WSH_DEBUG_SV.push(l_module_name);
1735: --
1736: WSH_DEBUG_SV.log(l_module_name,'P_SHIPMENT_HEADER_ID',P_SHIPMENT_HEADER_ID);
1737: WSH_DEBUG_SV.log(l_module_name,'P_TRANSACTION_TYPE',P_TRANSACTION_TYPE);
1738: WSH_DEBUG_SV.log(l_module_name,'P_ON_ERROR',P_ON_ERROR);
1739: WSH_DEBUG_SV.log(l_module_name,'p_on_noDataFound',p_on_noDataFound);
1740: END IF;

Line 1737: WSH_DEBUG_SV.log(l_module_name,'P_TRANSACTION_TYPE',P_TRANSACTION_TYPE);

1733: IF l_debug_on THEN
1734: WSH_DEBUG_SV.push(l_module_name);
1735: --
1736: WSH_DEBUG_SV.log(l_module_name,'P_SHIPMENT_HEADER_ID',P_SHIPMENT_HEADER_ID);
1737: WSH_DEBUG_SV.log(l_module_name,'P_TRANSACTION_TYPE',P_TRANSACTION_TYPE);
1738: WSH_DEBUG_SV.log(l_module_name,'P_ON_ERROR',P_ON_ERROR);
1739: WSH_DEBUG_SV.log(l_module_name,'p_on_noDataFound',p_on_noDataFound);
1740: END IF;
1741: --

Line 1738: WSH_DEBUG_SV.log(l_module_name,'P_ON_ERROR',P_ON_ERROR);

1734: WSH_DEBUG_SV.push(l_module_name);
1735: --
1736: WSH_DEBUG_SV.log(l_module_name,'P_SHIPMENT_HEADER_ID',P_SHIPMENT_HEADER_ID);
1737: WSH_DEBUG_SV.log(l_module_name,'P_TRANSACTION_TYPE',P_TRANSACTION_TYPE);
1738: WSH_DEBUG_SV.log(l_module_name,'P_ON_ERROR',P_ON_ERROR);
1739: WSH_DEBUG_SV.log(l_module_name,'p_on_noDataFound',p_on_noDataFound);
1740: END IF;
1741: --
1742: x_return_status := wsh_util_core.g_ret_sts_success;

Line 1739: WSH_DEBUG_SV.log(l_module_name,'p_on_noDataFound',p_on_noDataFound);

1735: --
1736: WSH_DEBUG_SV.log(l_module_name,'P_SHIPMENT_HEADER_ID',P_SHIPMENT_HEADER_ID);
1737: WSH_DEBUG_SV.log(l_module_name,'P_TRANSACTION_TYPE',P_TRANSACTION_TYPE);
1738: WSH_DEBUG_SV.log(l_module_name,'P_ON_ERROR',P_ON_ERROR);
1739: WSH_DEBUG_SV.log(l_module_name,'p_on_noDataFound',p_on_noDataFound);
1740: END IF;
1741: --
1742: x_return_status := wsh_util_core.g_ret_sts_success;
1743: x_locked := 'N';

Line 1840: WSH_DEBUG_SV.pop(l_module_name);

1836: --
1837: -- Debug Statements
1838: --
1839: IF l_debug_on THEN
1840: WSH_DEBUG_SV.pop(l_module_name);
1841: END IF;
1842: --
1843: --}
1844: EXCEPTION

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

1848: --
1849: -- Debug Statements
1850: --
1851: IF l_debug_on THEN
1852: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1853: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1854: END IF;
1855: --
1856: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1849: -- Debug Statements
1850: --
1851: IF l_debug_on THEN
1852: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1853: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1854: END IF;
1855: --
1856: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1857: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

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

1858: --
1859: -- Debug Statements
1860: --
1861: IF l_debug_on THEN
1862: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1863: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1864: END IF;
1865: --
1866: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

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

1859: -- Debug Statements
1860: --
1861: IF l_debug_on THEN
1862: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1863: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1864: END IF;
1865: --
1866: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
1867: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 1872: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1868: --
1869: -- Debug Statements
1870: --
1871: IF l_debug_on THEN
1872: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1873: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
1874: END IF;
1875: --
1876: WHEN OTHERS THEN

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

1869: -- Debug Statements
1870: --
1871: IF l_debug_on THEN
1872: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1873: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
1874: END IF;
1875: --
1876: WHEN OTHERS THEN
1877: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

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

1879: --
1880: -- Debug Statements
1881: --
1882: IF l_debug_on THEN
1883: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1884: END IF;
1885: --
1886: --}
1887: END lock_asn_receipt_header;

Line 1925: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1921: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1922: --
1923: IF l_debug_on IS NULL
1924: THEN
1925: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1926: END IF;
1927: --
1928: --
1929: -- Debug Statements

Line 1932: WSH_DEBUG_SV.push(l_module_name);

1928: --
1929: -- Debug Statements
1930: --
1931: IF l_debug_on THEN
1932: WSH_DEBUG_SV.push(l_module_name);
1933: --
1934: WSH_DEBUG_SV.log(l_module_name,'p_transaction_id',p_transaction_id);
1935: END IF;
1936: --

Line 1934: WSH_DEBUG_SV.log(l_module_name,'p_transaction_id',p_transaction_id);

1930: --
1931: IF l_debug_on THEN
1932: WSH_DEBUG_SV.push(l_module_name);
1933: --
1934: WSH_DEBUG_SV.log(l_module_name,'p_transaction_id',p_transaction_id);
1935: END IF;
1936: --
1937: x_return_status := wsh_util_core.g_ret_sts_success;
1938: x_locked := 'N';

Line 1976: WSH_DEBUG_SV.pop(l_module_name);

1972: --
1973: ROLLBACK TO SAVEPOINT lock_n_roll_sp;
1974: --
1975: IF l_debug_on THEN
1976: WSH_DEBUG_SV.pop(l_module_name);
1977: END IF;
1978: --
1979: --}
1980: EXCEPTION

Line 1985: WSH_DEBUG_SV.logmsg(l_module_name,'RECORD_LOCKED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1981: --{
1982: WHEN RECORD_LOCKED THEN
1983: ROLLBACK TO SAVEPOINT lock_n_roll_sp;
1984: IF l_debug_on THEN
1985: WSH_DEBUG_SV.logmsg(l_module_name,'RECORD_LOCKED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1986: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1987: END IF;
1988: --
1989: WHEN FND_API.G_EXC_ERROR THEN

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

1982: WHEN RECORD_LOCKED THEN
1983: ROLLBACK TO SAVEPOINT lock_n_roll_sp;
1984: IF l_debug_on THEN
1985: WSH_DEBUG_SV.logmsg(l_module_name,'RECORD_LOCKED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1986: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1987: END IF;
1988: --
1989: WHEN FND_API.G_EXC_ERROR THEN
1990: ROLLBACK TO SAVEPOINT lock_n_roll_sp;

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

1992: --
1993: -- Debug Statements
1994: --
1995: IF l_debug_on THEN
1996: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1997: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1998: END IF;
1999: --
2000: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1993: -- Debug Statements
1994: --
1995: IF l_debug_on THEN
1996: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1997: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1998: END IF;
1999: --
2000: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2001: ROLLBACK TO SAVEPOINT lock_n_roll_sp;

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

2003: --
2004: -- Debug Statements
2005: --
2006: IF l_debug_on THEN
2007: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2008: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2009: END IF;
2010: --
2011: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

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

2004: -- Debug Statements
2005: --
2006: IF l_debug_on THEN
2007: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2008: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2009: END IF;
2010: --
2011: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
2012: ROLLBACK TO SAVEPOINT lock_n_roll_sp;

Line 2018: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

2014: --
2015: -- Debug Statements
2016: --
2017: IF l_debug_on THEN
2018: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2019: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
2020: END IF;
2021: --
2022: WHEN OTHERS THEN

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

2015: -- Debug Statements
2016: --
2017: IF l_debug_on THEN
2018: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2019: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
2020: END IF;
2021: --
2022: WHEN OTHERS THEN
2023: ROLLBACK TO SAVEPOINT lock_n_roll_sp;

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

2026: --
2027: -- Debug Statements
2028: --
2029: IF l_debug_on THEN
2030: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2031: END IF;
2032: --
2033: --}
2034: END lock_n_roll;

Line 2066: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

2062: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2063: --
2064: IF l_debug_on IS NULL
2065: THEN
2066: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2067: END IF;
2068: --
2069: --
2070: IF l_debug_on THEN

Line 2071: WSH_DEBUG_SV.push(l_module_name);

2067: END IF;
2068: --
2069: --
2070: IF l_debug_on THEN
2071: WSH_DEBUG_SV.push(l_module_name);
2072: --
2073: WSH_DEBUG_SV.log(l_module_name,'p_transactionType',p_transactionType);
2074: END IF;
2075: --

Line 2073: WSH_DEBUG_SV.log(l_module_name,'p_transactionType',p_transactionType);

2069: --
2070: IF l_debug_on THEN
2071: WSH_DEBUG_SV.push(l_module_name);
2072: --
2073: WSH_DEBUG_SV.log(l_module_name,'p_transactionType',p_transactionType);
2074: END IF;
2075: --
2076: x_return_status := wsh_util_core.g_ret_sts_success;
2077: --

Line 2098: WSH_DEBUG_SV.pop(l_module_name);

2094: END IF;
2095: --
2096: --
2097: IF l_debug_on THEN
2098: WSH_DEBUG_SV.pop(l_module_name);
2099: END IF;
2100: --
2101: --}
2102: EXCEPTION

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

2106: --
2107: -- Debug Statements
2108: --
2109: IF l_debug_on THEN
2110: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2111: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2112: END IF;
2113: --
2114: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

2107: -- Debug Statements
2108: --
2109: IF l_debug_on THEN
2110: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2111: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2112: END IF;
2113: --
2114: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2115: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

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

2116: --
2117: -- Debug Statements
2118: --
2119: IF l_debug_on THEN
2120: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2121: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2122: END IF;
2123: --
2124: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

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

2117: -- Debug Statements
2118: --
2119: IF l_debug_on THEN
2120: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2121: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2122: END IF;
2123: --
2124: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
2125: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 2130: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

2126: --
2127: -- Debug Statements
2128: --
2129: IF l_debug_on THEN
2130: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2131: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
2132: END IF;
2133: --
2134: WHEN OTHERS THEN

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

2127: -- Debug Statements
2128: --
2129: IF l_debug_on THEN
2130: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2131: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
2132: END IF;
2133: --
2134: WHEN OTHERS THEN
2135: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

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

2137: --
2138: -- Debug Statements
2139: --
2140: IF l_debug_on THEN
2141: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2142: END IF;
2143: --
2144: --}
2145: END getTransactionTypeMeaning;