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

Line 69: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

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

Line 74: WSH_DEBUG_SV.push(l_module_name);

70: END IF;
71: --
72: IF l_debug_on THEN
73: --
74: WSH_DEBUG_SV.push(l_module_name);
75: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
76: --
77: END IF;
78: --

Line 75: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);

71: --
72: IF l_debug_on THEN
73: --
74: WSH_DEBUG_SV.push(l_module_name);
75: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
76: --
77: END IF;
78: --
79: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 101: WSH_DEBUG_SV.logmsg(l_module_name, 'Trip does not have a valid Freight Code, so MBOL cannot be Created.');

97: IF l_freight_code IS NULL THEN
98: --
99: IF l_debug_on THEN
100: --
101: WSH_DEBUG_SV.logmsg(l_module_name, 'Trip does not have a valid Freight Code, so MBOL cannot be Created.');
102: --
103: END IF;
104:
105: FND_MESSAGE.SET_NAME('WSH','WSH_MBOL_NULL_FREIGHT_CODE');

Line 126: WSH_DEBUG_SV.logmsg(l_module_name, 'ORG_ID not found, so MBOL cannot be Created.');

122: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR OR
123: l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
124: --
125: IF l_debug_on THEN
126: WSH_DEBUG_SV.logmsg(l_module_name, 'ORG_ID not found, so MBOL cannot be Created.');
127: END IF;
128: RAISE wsh_create_document_error;
129: END IF;
130:

Line 156: WSH_DEBUG_SV.logmsg(l_module_name, 'Ledger ID not found, so MBOL cannot be Created.');

152: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR OR
153: l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
154: --
155: IF l_debug_on THEN
156: WSH_DEBUG_SV.logmsg(l_module_name, 'Ledger ID not found, so MBOL cannot be Created.');
157: END IF;
158: RAISE wsh_create_document_error;
159: END IF;
160:

Line 165: WSH_DEBUG_SV.log(l_module_name, 'l_freight_code', l_freight_code);

161: --
162: -- Debug Statements
163: --
164: IF l_debug_on THEN
165: WSH_DEBUG_SV.log(l_module_name, 'l_freight_code', l_freight_code);
166: WSH_DEBUG_SV.log(l_module_name, 'l_trip_name', l_trip_name);
167: WSH_DEBUG_SV.log(l_module_name, 'l_ledger_id', l_ledger_id);
168: END IF;
169: --

Line 166: WSH_DEBUG_SV.log(l_module_name, 'l_trip_name', l_trip_name);

162: -- Debug Statements
163: --
164: IF l_debug_on THEN
165: WSH_DEBUG_SV.log(l_module_name, 'l_freight_code', l_freight_code);
166: WSH_DEBUG_SV.log(l_module_name, 'l_trip_name', l_trip_name);
167: WSH_DEBUG_SV.log(l_module_name, 'l_ledger_id', l_ledger_id);
168: END IF;
169: --
170: --

Line 167: WSH_DEBUG_SV.log(l_module_name, 'l_ledger_id', l_ledger_id);

163: --
164: IF l_debug_on THEN
165: WSH_DEBUG_SV.log(l_module_name, 'l_freight_code', l_freight_code);
166: WSH_DEBUG_SV.log(l_module_name, 'l_trip_name', l_trip_name);
167: WSH_DEBUG_SV.log(l_module_name, 'l_ledger_id', l_ledger_id);
168: END IF;
169: --
170: --
171: IF l_debug_on THEN

Line 172: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DOCUMENT_PVT.CREATE_DOCUMENT',WSH_DEBUG_SV.C_PROC_LEVEL);

168: END IF;
169: --
170: --
171: IF l_debug_on THEN
172: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DOCUMENT_PVT.CREATE_DOCUMENT',WSH_DEBUG_SV.C_PROC_LEVEL);
173: END IF;
174: --
175:
176: WSH_Document_PVT.Create_Document

Line 212: WSH_DEBUG_SV.pop(l_module_name);

208: --
209: -- Debug Statements
210: --
211: IF l_debug_on THEN
212: WSH_DEBUG_SV.pop(l_module_name);
213: END IF;
214: --
215: EXCEPTION
216: WHEN wsh_create_document_error THEN

Line 223: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_CREATE_DOCUMENT_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

219: --
220: -- Debug Statements
221: --
222: IF l_debug_on THEN
223: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_CREATE_DOCUMENT_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
224: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_CREATE_DOCUMENT_ERROR');
225: END IF;
226: --
227: WHEN OTHERS THEN

Line 224: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_CREATE_DOCUMENT_ERROR');

220: -- Debug Statements
221: --
222: IF l_debug_on THEN
223: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_CREATE_DOCUMENT_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
224: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_CREATE_DOCUMENT_ERROR');
225: END IF;
226: --
227: WHEN OTHERS THEN
228: wsh_util_core.default_handler('WSH_MBOLS_PVT.Generate_MBOL',l_module_name);

Line 231: WSH_DEBUG_SV.pop(l_module_name,'When Others');

227: WHEN OTHERS THEN
228: wsh_util_core.default_handler('WSH_MBOLS_PVT.Generate_MBOL',l_module_name);
229: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
230: IF l_debug_on THEN
231: WSH_DEBUG_SV.pop(l_module_name,'When Others');
232: END IF;
233:
234: END Generate_MBOL;
235:

Line 299: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

295: --
296: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
297: --
298: IF l_debug_on IS NULL THEN
299: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
300: END IF;
301: --
302: IF l_debug_on THEN
303: --

Line 304: WSH_DEBUG_SV.push(l_module_name);

300: END IF;
301: --
302: IF l_debug_on THEN
303: --
304: WSH_DEBUG_SV.push(l_module_name);
305: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
306: --
307: END IF;
308: --

Line 305: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);

301: --
302: IF l_debug_on THEN
303: --
304: WSH_DEBUG_SV.push(l_module_name);
305: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
306: --
307: END IF;
308: --
309: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 386: WSH_DEBUG_SV.pop(l_module_name);

382: --
383: -- Debug Statements
384: --
385: IF l_debug_on THEN
386: WSH_DEBUG_SV.pop(l_module_name);
387: END IF;
388: --
389: EXCEPTION
390: WHEN wsh_create_document_error THEN

Line 396: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_CREATE_DOCUMENT_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

392: --
393: -- Debug Statements
394: --
395: IF l_debug_on THEN
396: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_CREATE_DOCUMENT_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
397: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_CREATE_DOCUMENT_ERROR');
398: END IF;
399: --
400: WHEN OTHERS THEN

Line 397: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_CREATE_DOCUMENT_ERROR');

393: -- Debug Statements
394: --
395: IF l_debug_on THEN
396: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_CREATE_DOCUMENT_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
397: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_CREATE_DOCUMENT_ERROR');
398: END IF;
399: --
400: WHEN OTHERS THEN
401: wsh_util_core.default_handler('WSH_MBOLS_PVT.Generate_BOLs',l_module_name);

Line 404: WSH_DEBUG_SV.pop(l_module_name,'When Others');

400: WHEN OTHERS THEN
401: wsh_util_core.default_handler('WSH_MBOLS_PVT.Generate_BOLs',l_module_name);
402: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
403: IF l_debug_on THEN
404: WSH_DEBUG_SV.pop(l_module_name,'When Others');
405: END IF;
406:
407: END Generate_BOLs;
408:

Line 467: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

463: --
464: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
465: --
466: IF l_debug_on IS NULL THEN
467: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
468: END IF;
469: --
470: IF l_debug_on THEN
471: --

Line 472: WSH_DEBUG_SV.push(l_module_name);

468: END IF;
469: --
470: IF l_debug_on THEN
471: --
472: WSH_DEBUG_SV.push(l_module_name);
473: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
474: --
475: END IF;
476: --

Line 473: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);

469: --
470: IF l_debug_on THEN
471: --
472: WSH_DEBUG_SV.push(l_module_name);
473: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
474: --
475: END IF;
476: --
477: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 512: wsh_debug_sv.log(l_module_name, 'x_printer', l_printer_name);

508: x_api_status => l_return_status,
509: x_error_message => l_error_message);
510:
511: IF l_debug_on THEN
512: wsh_debug_sv.log(l_module_name, 'x_printer', l_printer_name);
513: wsh_debug_sv.log(l_module_name, 'x_api_status', l_return_status);
514: IF l_error_message IS NOT NULL THEN
515: WSH_DEBUG_SV.logmsg(l_module_name, 'GET_PRINTER: ' || l_error_message);
516: END IF;

Line 513: wsh_debug_sv.log(l_module_name, 'x_api_status', l_return_status);

509: x_error_message => l_error_message);
510:
511: IF l_debug_on THEN
512: wsh_debug_sv.log(l_module_name, 'x_printer', l_printer_name);
513: wsh_debug_sv.log(l_module_name, 'x_api_status', l_return_status);
514: IF l_error_message IS NOT NULL THEN
515: WSH_DEBUG_SV.logmsg(l_module_name, 'GET_PRINTER: ' || l_error_message);
516: END IF;
517: END IF;

Line 515: WSH_DEBUG_SV.logmsg(l_module_name, 'GET_PRINTER: ' || l_error_message);

511: IF l_debug_on THEN
512: wsh_debug_sv.log(l_module_name, 'x_printer', l_printer_name);
513: wsh_debug_sv.log(l_module_name, 'x_api_status', l_return_status);
514: IF l_error_message IS NOT NULL THEN
515: WSH_DEBUG_SV.logmsg(l_module_name, 'GET_PRINTER: ' || l_error_message);
516: END IF;
517: END IF;
518:
519: -- Set Print Options

Line 523: wsh_debug_sv.log(l_module_name, 'l_copies', l_copies);

519: -- Set Print Options
520: l_copies := to_number(NVL(FND_PROFILE.VALUE('CONC_COPIES'),'0')) ; --Bug 9733286
521:
522: IF l_debug_on THEN
523: wsh_debug_sv.log(l_module_name, 'l_copies', l_copies);
524: wsh_debug_sv.log(l_module_name, 'l_print_style', l_print_style);
525: wsh_debug_sv.log(l_module_name, 'l_save_output_flag', l_save_output_flag);
526: END IF;
527:

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

520: l_copies := to_number(NVL(FND_PROFILE.VALUE('CONC_COPIES'),'0')) ; --Bug 9733286
521:
522: IF l_debug_on THEN
523: wsh_debug_sv.log(l_module_name, 'l_copies', l_copies);
524: wsh_debug_sv.log(l_module_name, 'l_print_style', l_print_style);
525: wsh_debug_sv.log(l_module_name, 'l_save_output_flag', l_save_output_flag);
526: END IF;
527:
528: IF l_printer_name IS NULL OR l_printer_name = 'No Printer' THEN

Line 525: wsh_debug_sv.log(l_module_name, 'l_save_output_flag', l_save_output_flag);

521:
522: IF l_debug_on THEN
523: wsh_debug_sv.log(l_module_name, 'l_copies', l_copies);
524: wsh_debug_sv.log(l_module_name, 'l_print_style', l_print_style);
525: wsh_debug_sv.log(l_module_name, 'l_save_output_flag', l_save_output_flag);
526: END IF;
527:
528: IF l_printer_name IS NULL OR l_printer_name = 'No Printer' THEN
529:

Line 533: WSH_DEBUG_SV.logmsg(l_module_name, 'PRINTER NAME IS NULL AND THE DEFAULT PRINTER IS '||L_PRINTER_NAME );

529:
530: l_printer_name := l_cp_printer_name;
531:
532: IF l_debug_on THEN
533: WSH_DEBUG_SV.logmsg(l_module_name, 'PRINTER NAME IS NULL AND THE DEFAULT PRINTER IS '||L_PRINTER_NAME );
534: END IF;
535: END IF;
536:
537: IF l_save_output_flag = 'Y' THEN

Line 551: wsh_debug_sv.log(l_module_name, 'Set_Print_Options', l_printer_setup);

547: l_save_output,
548: 'N');
549:
550: IF l_debug_on THEN
551: wsh_debug_sv.log(l_module_name, 'Set_Print_Options', l_printer_setup);
552: END IF;
553: END IF; -- if print_flag = Y
554:
555: -- Call Submit Request

Line 583: wsh_debug_sv.log(l_module_name, 'l_request_id', l_request_id);

579: , '', '', '', '', '', '', '', '', '', ''
580: , '', '', '', '', '', '', '', '', '', '');
581:
582: IF l_debug_on THEN
583: wsh_debug_sv.log(l_module_name, 'l_request_id', l_request_id);
584: END IF;
585:
586: IF (l_request_id = 0) THEN
587: raise err_mbol_submission;

Line 598: WSH_DEBUG_SV.pop(l_module_name);

594: --
595: -- Debug Statements
596: --
597: IF l_debug_on THEN
598: WSH_DEBUG_SV.pop(l_module_name);
599: END IF;
600: --
601:
602: EXCEPTION

Line 608: WSH_DEBUG_SV.logmsg(l_module_name,'err_mbol_submission exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

604: x_return_status := wsh_util_core.g_ret_sts_error;
605: fnd_message.set_name('WSH', 'WSH_MBOL_FAILED');
606: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
607: IF l_debug_on THEN
608: WSH_DEBUG_SV.logmsg(l_module_name,'err_mbol_submission exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
609: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:err_mbol_submission');
610: END IF;
611: --
612: WHEN OTHERS THEN

Line 609: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:err_mbol_submission');

605: fnd_message.set_name('WSH', 'WSH_MBOL_FAILED');
606: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
607: IF l_debug_on THEN
608: WSH_DEBUG_SV.logmsg(l_module_name,'err_mbol_submission exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
609: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:err_mbol_submission');
610: END IF;
611: --
612: WHEN OTHERS THEN
613: wsh_util_core.default_handler('WSH_MBOLS_PVT.Print_MBOL',l_module_name);

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

612: WHEN OTHERS THEN
613: wsh_util_core.default_handler('WSH_MBOLS_PVT.Print_MBOL',l_module_name);
614: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
615: IF l_debug_on THEN
616: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
617: END IF;
618:
619: END Print_MBOL;
620:

Line 683: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

679: --
680: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
681: --
682: IF l_debug_on IS NULL THEN
683: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
684: END IF;
685: --
686: IF l_debug_on THEN
687: --

Line 688: WSH_DEBUG_SV.push(l_module_name);

684: END IF;
685: --
686: IF l_debug_on THEN
687: --
688: WSH_DEBUG_SV.push(l_module_name);
689: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
690: wsh_debug_sv.log(l_module_name, 'p_conc_request_id', p_conc_request_id );
691: --
692: END IF;

Line 689: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);

685: --
686: IF l_debug_on THEN
687: --
688: WSH_DEBUG_SV.push(l_module_name);
689: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
690: wsh_debug_sv.log(l_module_name, 'p_conc_request_id', p_conc_request_id );
691: --
692: END IF;
693: --

Line 690: wsh_debug_sv.log(l_module_name, 'p_conc_request_id', p_conc_request_id );

686: IF l_debug_on THEN
687: --
688: WSH_DEBUG_SV.push(l_module_name);
689: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
690: wsh_debug_sv.log(l_module_name, 'p_conc_request_id', p_conc_request_id );
691: --
692: END IF;
693: --
694: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 726: wsh_debug_sv.log(l_module_name, 'x_printer', l_printer_name);

722: x_api_status => l_return_status,
723: x_error_message => l_error_message);
724:
725: IF l_debug_on THEN
726: wsh_debug_sv.log(l_module_name, 'x_printer', l_printer_name);
727: wsh_debug_sv.log(l_module_name, 'x_api_status', l_return_status);
728: IF l_error_message IS NOT NULL THEN
729: WSH_DEBUG_SV.logmsg(l_module_name, 'GET_PRINTER: ' || l_error_message);
730: END IF;

Line 727: wsh_debug_sv.log(l_module_name, 'x_api_status', l_return_status);

723: x_error_message => l_error_message);
724:
725: IF l_debug_on THEN
726: wsh_debug_sv.log(l_module_name, 'x_printer', l_printer_name);
727: wsh_debug_sv.log(l_module_name, 'x_api_status', l_return_status);
728: IF l_error_message IS NOT NULL THEN
729: WSH_DEBUG_SV.logmsg(l_module_name, 'GET_PRINTER: ' || l_error_message);
730: END IF;
731: END IF;

Line 729: WSH_DEBUG_SV.logmsg(l_module_name, 'GET_PRINTER: ' || l_error_message);

725: IF l_debug_on THEN
726: wsh_debug_sv.log(l_module_name, 'x_printer', l_printer_name);
727: wsh_debug_sv.log(l_module_name, 'x_api_status', l_return_status);
728: IF l_error_message IS NOT NULL THEN
729: WSH_DEBUG_SV.logmsg(l_module_name, 'GET_PRINTER: ' || l_error_message);
730: END IF;
731: END IF;
732:
733: -- Set Print Options

Line 737: wsh_debug_sv.log(l_module_name, 'l_copies', l_copies);

733: -- Set Print Options
734: l_copies := to_number(NVL(FND_PROFILE.VALUE('CONC_COPIES'),'0')) ; --Bug 9733286
735:
736: IF l_debug_on THEN
737: wsh_debug_sv.log(l_module_name, 'l_copies', l_copies);
738: wsh_debug_sv.log(l_module_name, 'l_print_style', l_print_style);
739: wsh_debug_sv.log(l_module_name, 'l_save_output_flag', l_save_output_flag);
740: END IF;
741:

Line 738: wsh_debug_sv.log(l_module_name, 'l_print_style', l_print_style);

734: l_copies := to_number(NVL(FND_PROFILE.VALUE('CONC_COPIES'),'0')) ; --Bug 9733286
735:
736: IF l_debug_on THEN
737: wsh_debug_sv.log(l_module_name, 'l_copies', l_copies);
738: wsh_debug_sv.log(l_module_name, 'l_print_style', l_print_style);
739: wsh_debug_sv.log(l_module_name, 'l_save_output_flag', l_save_output_flag);
740: END IF;
741:
742: IF l_printer_name IS NULL OR l_printer_name = 'No Printer' THEN

Line 739: wsh_debug_sv.log(l_module_name, 'l_save_output_flag', l_save_output_flag);

735:
736: IF l_debug_on THEN
737: wsh_debug_sv.log(l_module_name, 'l_copies', l_copies);
738: wsh_debug_sv.log(l_module_name, 'l_print_style', l_print_style);
739: wsh_debug_sv.log(l_module_name, 'l_save_output_flag', l_save_output_flag);
740: END IF;
741:
742: IF l_printer_name IS NULL OR l_printer_name = 'No Printer' THEN
743:

Line 747: WSH_DEBUG_SV.logmsg(l_module_name, 'PRINTER NAME IS NULL AND THE DEFAULT PRINTER IS '||L_PRINTER_NAME );

743:
744: l_printer_name := l_cp_printer_name;
745:
746: IF l_debug_on THEN
747: WSH_DEBUG_SV.logmsg(l_module_name, 'PRINTER NAME IS NULL AND THE DEFAULT PRINTER IS '||L_PRINTER_NAME );
748: END IF;
749: END IF;
750:
751: IF l_save_output_flag = 'Y' THEN

Line 765: wsh_debug_sv.log(l_module_name, 'Set_Print_Options', l_printer_setup);

761: l_save_output,
762: 'N');
763:
764: IF l_debug_on THEN
765: wsh_debug_sv.log(l_module_name, 'Set_Print_Options', l_printer_setup);
766: END IF;
767: END IF; -- if print_flag = Y
768:
769: -- Call Submit Request

Line 797: wsh_debug_sv.log(l_module_name, 'l_request_id', l_request_id);

793: , '', '', '', '', '', '', '', '', '', ''
794: , '', '', '', '', '', '', '', '', '', '');
795:
796: IF l_debug_on THEN
797: wsh_debug_sv.log(l_module_name, 'l_request_id', l_request_id);
798: END IF;
799:
800: IF (l_request_id = 0) THEN
801: raise err_bol_submission;

Line 810: WSH_DEBUG_SV.pop(l_module_name);

806: --
807: -- Debug Statements
808: --
809: IF l_debug_on THEN
810: WSH_DEBUG_SV.pop(l_module_name);
811: END IF;
812: --
813: EXCEPTION
814: WHEN err_bol_submission THEN

Line 818: WSH_DEBUG_SV.logmsg(l_module_name,'err_bol_submission exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

814: WHEN err_bol_submission THEN
815: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
816: WSH_UTIL_CORE.PrintMsg('ERROR: Failed to submit Bill of Lading concurrent request');
817: IF l_debug_on THEN
818: WSH_DEBUG_SV.logmsg(l_module_name,'err_bol_submission exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
819: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:err_bol_submission');
820: END IF;
821: --
822: WHEN OTHERS THEN

Line 819: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:err_bol_submission');

815: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
816: WSH_UTIL_CORE.PrintMsg('ERROR: Failed to submit Bill of Lading concurrent request');
817: IF l_debug_on THEN
818: WSH_DEBUG_SV.logmsg(l_module_name,'err_bol_submission exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
819: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:err_bol_submission');
820: END IF;
821: --
822: WHEN OTHERS THEN
823: wsh_util_core.default_handler('WSH_MBOLS_PVT.Print_MBOL',l_module_name);

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

822: WHEN OTHERS THEN
823: wsh_util_core.default_handler('WSH_MBOLS_PVT.Print_MBOL',l_module_name);
824: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
825: IF l_debug_on THEN
826: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
827: END IF;
828: END Print_BOLs;
829:
830: --========================================================================

Line 881: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

877: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
878: --
879: IF l_debug_on IS NULL
880: THEN
881: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
882: END IF;
883: --
884: IF l_debug_on THEN
885: WSH_DEBUG_SV.push(l_module_name);

Line 885: WSH_DEBUG_SV.push(l_module_name);

881: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
882: END IF;
883: --
884: IF l_debug_on THEN
885: WSH_DEBUG_SV.push(l_module_name);
886: --
887: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
888: END IF;
889: --

Line 887: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);

883: --
884: IF l_debug_on THEN
885: WSH_DEBUG_SV.push(l_module_name);
886: --
887: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
888: END IF;
889: --
890: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
891:

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

936:
937: IF l_return_status is not null then
938: x_return_status := l_return_status;
939: IF l_debug_on THEN
940: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
941: END IF;
942: ELSE
943: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
944: END IF;

Line 947: WSH_DEBUG_SV.pop(l_module_name);

943: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
944: END IF;
945:
946: IF l_debug_on THEN
947: WSH_DEBUG_SV.pop(l_module_name);
948: END IF;
949: --
950: EXCEPTION
951: WHEN wsh_cancel_mbol_error THEN

Line 956: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_CANCEL_MBOL_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

952: ROLLBACK TO cancel_mbol1;
953: x_return_status := wsh_util_core.g_ret_sts_error;
954: --
955: IF l_debug_on THEN
956: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_CANCEL_MBOL_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
957: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_CANCEL_MBOL_ERROR');
958: END IF;
959: --
960: WHEN record_locked THEN

Line 957: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_CANCEL_MBOL_ERROR');

953: x_return_status := wsh_util_core.g_ret_sts_error;
954: --
955: IF l_debug_on THEN
956: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_CANCEL_MBOL_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
957: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_CANCEL_MBOL_ERROR');
958: END IF;
959: --
960: WHEN record_locked THEN
961: x_return_status := wsh_util_core.g_ret_sts_error;

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

962: FND_MESSAGE.Set_Name('WSH', 'WSH_NO_LOCK');
963: WSH_UTIL_CORE.add_message (x_return_status, l_module_name);
964: --
965: IF l_debug_on THEN
966: WSH_DEBUG_SV.logmsg(l_module_name,'RECORD_LOCKED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
967: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:RECORD_LOCKED');
968: END IF;
969: --
970: WHEN OTHERS THEN

Line 967: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:RECORD_LOCKED');

963: WSH_UTIL_CORE.add_message (x_return_status, l_module_name);
964: --
965: IF l_debug_on THEN
966: WSH_DEBUG_SV.logmsg(l_module_name,'RECORD_LOCKED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
967: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:RECORD_LOCKED');
968: END IF;
969: --
970: WHEN OTHERS THEN
971: ROLLBACK TO cancel_mbol1;

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

972: wsh_util_core.default_handler('WSH_MBOLS_PVT.cancel_mbol',l_module_name);
973: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
974: --
975: IF l_debug_on THEN
976: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
977: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
978: END IF;
979: --
980: END cancel_mbol;

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

973: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
974: --
975: IF l_debug_on THEN
976: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
977: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
978: END IF;
979: --
980: END cancel_mbol;
981:

Line 1029: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1025: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1026: --
1027: IF l_debug_on IS NULL
1028: THEN
1029: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1030: END IF;
1031: --
1032: IF l_debug_on THEN
1033: WSH_DEBUG_SV.push(l_module_name);

Line 1033: WSH_DEBUG_SV.push(l_module_name);

1029: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1030: END IF;
1031: --
1032: IF l_debug_on THEN
1033: WSH_DEBUG_SV.push(l_module_name);
1034: --
1035: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
1036: END IF;
1037: --

Line 1035: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);

1031: --
1032: IF l_debug_on THEN
1033: WSH_DEBUG_SV.push(l_module_name);
1034: --
1035: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
1036: END IF;
1037: --
1038: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1039:

Line 1044: WSH_DEBUG_SV.log(l_module_name,'l_shipments_type_flag',l_shipments_type_flag);

1040: open get_shipments_type_flag;
1041: fetch get_shipments_type_flag into l_shipments_type_flag;
1042: close get_shipments_type_flag;
1043: IF l_debug_on THEN
1044: WSH_DEBUG_SV.log(l_module_name,'l_shipments_type_flag',l_shipments_type_flag);
1045: END IF;
1046: open locations_csr;
1047: LOOP
1048: fetch locations_csr into l_location_id;

Line 1050: WSH_DEBUG_SV.log(l_module_name,'l_location_id', l_location_id);

1046: open locations_csr;
1047: LOOP
1048: fetch locations_csr into l_location_id;
1049: IF l_debug_on THEN
1050: WSH_DEBUG_SV.log(l_module_name,'l_location_id', l_location_id);
1051: END IF;
1052: if ( l_shipments_type_flag = 'I') then
1053: exit;
1054: end if;

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

1058: fetch organizations_csr into l_organization_id;
1059: close organizations_csr;
1060:
1061: IF l_debug_on THEN
1062: WSH_DEBUG_SV.log(l_module_name,'l_organization_id', l_organization_id);
1063: END IF;
1064:
1065: If l_organization_id is null then
1066: --{

Line 1073: WSH_DEBUG_SV.log(l_module_name,'l_first_delivery_id', l_first_delivery_id);

1069: from wsh_trip_stops wts, wsh_delivery_legs wdl
1070: where wts.trip_id = p_trip_id
1071: and wts.stop_id = wdl.pick_up_stop_id;
1072: IF l_debug_on THEN
1073: WSH_DEBUG_SV.log(l_module_name,'l_first_delivery_id', l_first_delivery_id);
1074: END IF;
1075:
1076: select organization_id
1077: into l_organization_id

Line 1081: WSH_DEBUG_SV.log(l_module_name,'l_organization_id', l_organization_id);

1077: into l_organization_id
1078: from wsh_new_deliveries
1079: where delivery_id = l_first_delivery_id;
1080: IF l_debug_on THEN
1081: WSH_DEBUG_SV.log(l_module_name,'l_organization_id', l_organization_id);
1082: END IF;
1083: --}
1084: end if;
1085: x_organization_id := l_organization_id;

Line 1088: WSH_DEBUG_SV.pop(l_module_name);

1084: end if;
1085: x_organization_id := l_organization_id;
1086:
1087: IF l_debug_on THEN
1088: WSH_DEBUG_SV.pop(l_module_name);
1089: END IF;
1090:
1091: EXCEPTION
1092: WHEN OTHERS THEN

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

1094: wsh_util_core.default_handler('WSH_MBOLS_PVT.Get_Organization_of_MBOL',l_module_name);
1095: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
1096: --
1097: IF l_debug_on THEN
1098: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1099: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1100: END IF;
1101:
1102: END Get_Organization_of_MBOL;

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

1095: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
1096: --
1097: IF l_debug_on THEN
1098: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1099: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1100: END IF;
1101:
1102: END Get_Organization_of_MBOL;
1103: