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

Line 100: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

96: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
97: --
98: IF l_debug_on IS NULL
99: THEN
100: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
101: END IF;
102: --
103: IF l_debug_on THEN
104: WSH_DEBUG_SV.push(l_module_name);

Line 104: WSH_DEBUG_SV.push(l_module_name);

100: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
101: END IF;
102: --
103: IF l_debug_on THEN
104: WSH_DEBUG_SV.push(l_module_name);
105: --
106: WSH_DEBUG_SV.log(l_module_name,'P_DETAIL_TAB.COUNT',P_DETAIL_TAB.COUNT);
107: WSH_DEBUG_SV.log(l_module_name,'P_PARENT_DETAIL_ID',P_PARENT_DETAIL_ID);
108: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);

Line 106: WSH_DEBUG_SV.log(l_module_name,'P_DETAIL_TAB.COUNT',P_DETAIL_TAB.COUNT);

102: --
103: IF l_debug_on THEN
104: WSH_DEBUG_SV.push(l_module_name);
105: --
106: WSH_DEBUG_SV.log(l_module_name,'P_DETAIL_TAB.COUNT',P_DETAIL_TAB.COUNT);
107: WSH_DEBUG_SV.log(l_module_name,'P_PARENT_DETAIL_ID',P_PARENT_DETAIL_ID);
108: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
109: WSH_DEBUG_SV.log(l_module_name,'P_GROUP_API_FLAG',P_GROUP_API_FLAG);
110: END IF;

Line 107: WSH_DEBUG_SV.log(l_module_name,'P_PARENT_DETAIL_ID',P_PARENT_DETAIL_ID);

103: IF l_debug_on THEN
104: WSH_DEBUG_SV.push(l_module_name);
105: --
106: WSH_DEBUG_SV.log(l_module_name,'P_DETAIL_TAB.COUNT',P_DETAIL_TAB.COUNT);
107: WSH_DEBUG_SV.log(l_module_name,'P_PARENT_DETAIL_ID',P_PARENT_DETAIL_ID);
108: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
109: WSH_DEBUG_SV.log(l_module_name,'P_GROUP_API_FLAG',P_GROUP_API_FLAG);
110: END IF;
111: --

Line 108: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);

104: WSH_DEBUG_SV.push(l_module_name);
105: --
106: WSH_DEBUG_SV.log(l_module_name,'P_DETAIL_TAB.COUNT',P_DETAIL_TAB.COUNT);
107: WSH_DEBUG_SV.log(l_module_name,'P_PARENT_DETAIL_ID',P_PARENT_DETAIL_ID);
108: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
109: WSH_DEBUG_SV.log(l_module_name,'P_GROUP_API_FLAG',P_GROUP_API_FLAG);
110: END IF;
111: --
112: IF (p_parent_detail_id IS NOT NULL) AND (NVL(p_group_api_flag, 'N') = 'N') THEN

Line 109: WSH_DEBUG_SV.log(l_module_name,'P_GROUP_API_FLAG',P_GROUP_API_FLAG);

105: --
106: WSH_DEBUG_SV.log(l_module_name,'P_DETAIL_TAB.COUNT',P_DETAIL_TAB.COUNT);
107: WSH_DEBUG_SV.log(l_module_name,'P_PARENT_DETAIL_ID',P_PARENT_DETAIL_ID);
108: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
109: WSH_DEBUG_SV.log(l_module_name,'P_GROUP_API_FLAG',P_GROUP_API_FLAG);
110: END IF;
111: --
112: IF (p_parent_detail_id IS NOT NULL) AND (NVL(p_group_api_flag, 'N') = 'N') THEN
113: l_wms_filter_flag := 'Y';

Line 128: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DLVB_COMMON_ACTIONS.SEPARATE_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);

124: --
125: -- Debug Statements
126: --
127: IF l_debug_on THEN
128: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DLVB_COMMON_ACTIONS.SEPARATE_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
129: END IF;
130: --
131: WSH_DLVB_COMMON_ACTIONS.Separate_Details (
132: p_input_tab =>p_detail_tab,

Line 149: --WSH_DEBUG_SV.pop(l_module_name);

145: --
146: -- Debug Statements
147: --
148: --IF l_debug_on THEN
149: --WSH_DEBUG_SV.pop(l_module_name);
150: --END IF;
151: --
152: --return; LPN CONV. rv
153: raise e_return_excp; -- LPN CONV. rv

Line 167: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.ASSIGN_DETAIL',WSH_DEBUG_SV.C_PROC_LEVEL);

163: --
164: -- Debug Statements
165: --
166: IF l_debug_on THEN
167: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.ASSIGN_DETAIL',WSH_DEBUG_SV.C_PROC_LEVEL);
168: END IF;
169: --
170: WSH_CONTAINER_ACTIONS.Assign_Detail (
171: p_container_instance_id =>p_parent_detail_id,

Line 184: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

180: --
181: -- Debug Statements
182: --
183: IF l_debug_on THEN
184: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
185: END IF;
186: --
187: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_parent_detail_id);
188: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_DET_ASSG_ERROR');

Line 195: --WSH_DEBUG_SV.pop(l_module_name);

191: --
192: -- Debug Statements
193: --
194: --IF l_debug_on THEN
195: --WSH_DEBUG_SV.pop(l_module_name);
196: --END IF;
197: --
198: --return;
199: raise e_return_excp; -- LPN CONV. rv

Line 213: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

209:
210: IF l_fill_status = 'O' THEN
211:
212: IF l_debug_on THEN
213: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
214: END IF;
215: --
216: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_parent_detail_id);
217: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_OVERPACKED');

Line 225: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

221: x_pack_status := 'Overpacked';
222:
223: ELSIF l_fill_status = 'U' THEN
224: IF l_debug_on THEN
225: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
226: END IF;
227: --
228: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_parent_detail_id);
229: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_UNDERPACKED');

Line 250: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.ASSIGN_MULTIPLE_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);

246: --
247: -- Debug Statements
248: --
249: IF l_debug_on THEN
250: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.ASSIGN_MULTIPLE_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
251: END IF;
252: --
253: WSH_DELIVERY_DETAILS_ACTIONS.Assign_Multiple_Details (
254: p_rec_of_detail_ids =>l_det_rec,

Line 270: --WSH_DEBUG_SV.pop(l_module_name);

266: --
267: -- Debug Statements
268: --
269: --IF l_debug_on THEN
270: --WSH_DEBUG_SV.pop(l_module_name);
271: --END IF;
272: --
273: --return;
274: raise e_return_excp; -- LPN CONV. rv

Line 304: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.ASSIGN_TO_CONTAINER',WSH_DEBUG_SV.C_PROC_LEVEL);

300: --
301: -- Debug Statements
302: --
303: IF l_debug_on THEN
304: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.ASSIGN_TO_CONTAINER',WSH_DEBUG_SV.C_PROC_LEVEL);
305: END IF;
306: --
307: WSH_CONTAINER_ACTIONS.Assign_To_Container (
308: p_det_cont_inst_id =>l_cont_tab(i),

Line 323: --WSH_DEBUG_SV.pop(l_module_name);

319: --
320: -- Debug Statements
321: --
322: --IF l_debug_on THEN
323: --WSH_DEBUG_SV.pop(l_module_name);
324: --END IF;
325: --
326: --return;
327: raise e_return_excp; -- LPN CONV. rv

Line 372: --WSH_DEBUG_SV.pop(l_module_name);

368: --
369: -- Debug Statements
370: --
371: --IF l_debug_on THEN
372: --WSH_DEBUG_SV.pop(l_module_name);
373: --END IF;
374: --
375: --return;
376: raise e_return_excp; -- LPN CONV. rv

Line 399: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);

395: --
396: -- Debug Statements
397: --
398: IF l_debug_on THEN
399: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);
400: END IF;
401: --
402: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(
403: p_entity_type => 'DELIVERY_DETAIL',

Line 419: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);

415: --
416: -- Debug Statements
417: --
418: IF l_debug_on THEN
419: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);
420: END IF;
421: --
422: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(
423: p_entity_type => 'DELIVERY',

Line 439: --WSH_DEBUG_SV.pop(l_module_name);

435: --
436: -- Debug Statements
437: --
438: --IF l_debug_on THEN
439: --WSH_DEBUG_SV.pop(l_module_name);
440: --END IF;
441: --
442: --return;
443: raise e_return_excp; -- LPN CONV. rv

Line 456: WSH_DEBUG_SV.log(l_module_name,'Return Status',x_return_status);

452: --
453: -- Debug Statements
454: --
455: IF l_debug_on THEN
456: WSH_DEBUG_SV.log(l_module_name,'Return Status',x_return_status);
457: --WSH_DEBUG_SV.pop(l_module_name);
458: END IF;
459: --
460: --return;

Line 457: --WSH_DEBUG_SV.pop(l_module_name);

453: -- Debug Statements
454: --
455: IF l_debug_on THEN
456: WSH_DEBUG_SV.log(l_module_name,'Return Status',x_return_status);
457: --WSH_DEBUG_SV.pop(l_module_name);
458: END IF;
459: --
460: --return;
461: END IF;

Line 472: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',WSH_DEBUG_SV.C_PROC_LEVEL);

468: --{
469:
470: --
471: IF l_debug_on THEN
472: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',WSH_DEBUG_SV.C_PROC_LEVEL);
473: END IF;
474: --
475: WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS
476: (

Line 484: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);

480: );
481: --
482: --
483: IF l_debug_on THEN
484: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
485: END IF;
486: --}
487: END IF;
488: --

Line 497: WSH_DEBUG_SV.pop(l_module_name);

493: --
494: -- Debug Statements
495: --
496: IF l_debug_on THEN
497: WSH_DEBUG_SV.pop(l_module_name);
498: END IF;
499: --
500: return;
501: ELSE

Line 514: WSH_DEBUG_SV.log(l_module_name,'Return Status',x_return_status);

510: --
511: -- Debug Statements
512: --
513: IF l_debug_on THEN
514: WSH_DEBUG_SV.log(l_module_name,'Return Status',x_return_status);
515: WSH_DEBUG_SV.pop(l_module_name);
516: END IF;
517: --
518: return;

Line 515: WSH_DEBUG_SV.pop(l_module_name);

511: -- Debug Statements
512: --
513: IF l_debug_on THEN
514: WSH_DEBUG_SV.log(l_module_name,'Return Status',x_return_status);
515: WSH_DEBUG_SV.pop(l_module_name);
516: END IF;
517: --
518: return;
519: --

Line 531: WSH_DEBUG_SV.pop(l_module_name);

527: --
528: -- Debug Statements
529: --
530: IF l_debug_on THEN
531: WSH_DEBUG_SV.pop(l_module_name);
532: END IF;
533: --
534: EXCEPTION
535:

Line 544: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',WSH_DEBUG_SV.C_PROC_LEVEL);

540: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
541: THEN
542: --{
543: IF l_debug_on THEN
544: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',WSH_DEBUG_SV.C_PROC_LEVEL);
545: END IF;
546:
547: WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS
548: (

Line 556: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);

552: );
553: --
554: --
555: IF l_debug_on THEN
556: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
557: END IF;
558: --
559: --
560: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR,WSH_UTIL_CORE.G_RET_STS_ERROR) and x_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

Line 570: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:E_RETURN_EXCP');

566: --
567: -- K LPN CONV. rv
568: --
569: IF l_debug_on THEN
570: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:E_RETURN_EXCP');
571: END IF;
572: --
573: WHEN Others THEN
574: WSH_UTIL_CORE.Default_Handler('WSH_DLVB_COMMON_ACTIONS.Assign_Details');

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

573: WHEN Others THEN
574: WSH_UTIL_CORE.Default_Handler('WSH_DLVB_COMMON_ACTIONS.Assign_Details');
575: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
576: IF l_debug_on THEN
577: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
578: END IF;
579: --
580: -- K LPN CONV. rv
581: --

Line 586: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',WSH_DEBUG_SV.C_PROC_LEVEL);

582: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
583: THEN
584: --{
585: IF l_debug_on THEN
586: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',WSH_DEBUG_SV.C_PROC_LEVEL);
587: END IF;
588:
589: WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS
590: (

Line 598: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);

594: );
595: --
596: --
597: IF l_debug_on THEN
598: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
599: END IF;
600: --
601: --
602: --}

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

607: --
608: -- Debug Statements
609: --
610: IF l_debug_on THEN
611: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
612: END IF;
613: --
614: END Assign_Details;
615:

Line 700: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

696: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
697: --
698: IF l_debug_on IS NULL
699: THEN
700: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
701: END IF;
702: --
703: IF l_debug_on THEN
704: WSH_DEBUG_SV.push(l_module_name);

Line 704: WSH_DEBUG_SV.push(l_module_name);

700: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
701: END IF;
702: --
703: IF l_debug_on THEN
704: WSH_DEBUG_SV.push(l_module_name);
705: --
706: WSH_DEBUG_SV.log(l_module_name,'P_DETAIL_TAB.COUNT',p_detail_tab.count);
707: WSH_DEBUG_SV.log(l_module_name,'P_PARENT_DETAIL_FLAG',P_PARENT_DETAIL_FLAG);
708: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_FLAG',P_DELIVERY_FLAG);

Line 706: WSH_DEBUG_SV.log(l_module_name,'P_DETAIL_TAB.COUNT',p_detail_tab.count);

702: --
703: IF l_debug_on THEN
704: WSH_DEBUG_SV.push(l_module_name);
705: --
706: WSH_DEBUG_SV.log(l_module_name,'P_DETAIL_TAB.COUNT',p_detail_tab.count);
707: WSH_DEBUG_SV.log(l_module_name,'P_PARENT_DETAIL_FLAG',P_PARENT_DETAIL_FLAG);
708: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_FLAG',P_DELIVERY_FLAG);
709: WSH_DEBUG_SV.log(l_module_name,'P_GROUP_API_FLAG',P_GROUP_API_FLAG);
710: END IF;

Line 707: WSH_DEBUG_SV.log(l_module_name,'P_PARENT_DETAIL_FLAG',P_PARENT_DETAIL_FLAG);

703: IF l_debug_on THEN
704: WSH_DEBUG_SV.push(l_module_name);
705: --
706: WSH_DEBUG_SV.log(l_module_name,'P_DETAIL_TAB.COUNT',p_detail_tab.count);
707: WSH_DEBUG_SV.log(l_module_name,'P_PARENT_DETAIL_FLAG',P_PARENT_DETAIL_FLAG);
708: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_FLAG',P_DELIVERY_FLAG);
709: WSH_DEBUG_SV.log(l_module_name,'P_GROUP_API_FLAG',P_GROUP_API_FLAG);
710: END IF;
711: --

Line 708: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_FLAG',P_DELIVERY_FLAG);

704: WSH_DEBUG_SV.push(l_module_name);
705: --
706: WSH_DEBUG_SV.log(l_module_name,'P_DETAIL_TAB.COUNT',p_detail_tab.count);
707: WSH_DEBUG_SV.log(l_module_name,'P_PARENT_DETAIL_FLAG',P_PARENT_DETAIL_FLAG);
708: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_FLAG',P_DELIVERY_FLAG);
709: WSH_DEBUG_SV.log(l_module_name,'P_GROUP_API_FLAG',P_GROUP_API_FLAG);
710: END IF;
711: --
712: IF (p_parent_detail_flag = 'Y') AND (NVL(p_group_api_flag, 'N') = 'N') THEN

Line 709: WSH_DEBUG_SV.log(l_module_name,'P_GROUP_API_FLAG',P_GROUP_API_FLAG);

705: --
706: WSH_DEBUG_SV.log(l_module_name,'P_DETAIL_TAB.COUNT',p_detail_tab.count);
707: WSH_DEBUG_SV.log(l_module_name,'P_PARENT_DETAIL_FLAG',P_PARENT_DETAIL_FLAG);
708: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_FLAG',P_DELIVERY_FLAG);
709: WSH_DEBUG_SV.log(l_module_name,'P_GROUP_API_FLAG',P_GROUP_API_FLAG);
710: END IF;
711: --
712: IF (p_parent_detail_flag = 'Y') AND (NVL(p_group_api_flag, 'N') = 'N') THEN
713: l_wms_filter_flag := 'Y';

Line 722: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DLVB_COMMON_ACTIONS.SEPARATE_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);

718: --
719: -- Debug Statements
720: --
721: IF l_debug_on THEN
722: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DLVB_COMMON_ACTIONS.SEPARATE_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
723: END IF;
724: --
725: WSH_DLVB_COMMON_ACTIONS.Separate_Details (
726: p_detail_tab,

Line 742: --WSH_DEBUG_SV.pop(l_module_name);

738: --
739: -- Debug Statements
740: --
741: --IF l_debug_on THEN
742: --WSH_DEBUG_SV.pop(l_module_name);
743: --END IF;
744: --
745: --return;
746: raise e_return_excp; -- LPN CONV. rv

Line 757: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.UNASSIGN_DETAIL',WSH_DEBUG_SV.C_PROC_LEVEL);

753: --
754: -- Debug Statements
755: --
756: IF l_debug_on THEN
757: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.UNASSIGN_DETAIL',WSH_DEBUG_SV.C_PROC_LEVEL);
758: END IF;
759: --
760: WSH_CONTAINER_ACTIONS.Unassign_Detail (
761: NULL,

Line 795: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.UNASSIGN_DETAIL',WSH_DEBUG_SV.C_PROC_LEVEL);

791: --
792: -- Debug Statements
793: --
794: IF l_debug_on THEN
795: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.UNASSIGN_DETAIL',WSH_DEBUG_SV.C_PROC_LEVEL);
796: END IF;
797: --
798: WSH_CONTAINER_ACTIONS.Unassign_Detail (
799: NULL,

Line 831: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',WSH_DEBUG_SV.C_PROC_LEVEL);

827: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
828: THEN
829: --{
830: IF l_debug_on THEN
831: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',WSH_DEBUG_SV.C_PROC_LEVEL);
832: END IF;
833:
834: WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS
835: (

Line 843: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',x_return_status);

839: );
840: --
841: --
842: IF l_debug_on THEN
843: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',x_return_status);
844: END IF;
845: --
846: --
847: IF ((x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND

Line 884: WSH_DEBUG_SV.log(l_module_name,'Return Status',x_return_status);

880: --
881: -- Debug Statements
882: --
883: IF l_debug_on THEN
884: WSH_DEBUG_SV.log(l_module_name,'Return Status',x_return_status);
885: WSH_DEBUG_SV.pop(l_module_name);
886: END IF;
887: --
888: EXCEPTION

Line 885: WSH_DEBUG_SV.pop(l_module_name);

881: -- Debug Statements
882: --
883: IF l_debug_on THEN
884: WSH_DEBUG_SV.log(l_module_name,'Return Status',x_return_status);
885: WSH_DEBUG_SV.pop(l_module_name);
886: END IF;
887: --
888: EXCEPTION
889: WHEN e_return_excp THEN

Line 898: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',WSH_DEBUG_SV.C_PROC_LEVEL);

894: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
895: THEN
896: --{
897: IF l_debug_on THEN
898: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',WSH_DEBUG_SV.C_PROC_LEVEL);
899: END IF;
900:
901: WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS
902: (

Line 910: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);

906: );
907: --
908: --
909: IF l_debug_on THEN
910: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
911: END IF;
912: --
913: --
914: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR,WSH_UTIL_CORE.G_RET_STS_ERROR) and x_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

Line 922: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:e_return_excp');

918: --}
919: END IF;
920: --
921: IF l_debug_on THEN
922: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:e_return_excp');
923: END IF;
924: --
925: -- K LPN CONV. rv
926: --

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

927: WHEN Others THEN
928: WSH_UTIL_CORE.Default_Handler('WSH_DLVB_COMMON_ACTIONS.Unassign_Details');
929: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
930: IF l_debug_on THEN
931: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
932: END IF;
933: --
934: -- K LPN CONV. rv
935: --

Line 940: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',WSH_DEBUG_SV.C_PROC_LEVEL);

936: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
937: THEN
938: --{
939: IF l_debug_on THEN
940: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',WSH_DEBUG_SV.C_PROC_LEVEL);
941: END IF;
942:
943: WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS
944: (

Line 952: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);

948: );
949: --
950: --
951: IF l_debug_on THEN
952: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
953: END IF;
954: --
955: --
956: --}

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

963: --
964: -- Debug Statements
965: --
966: IF l_debug_on THEN
967: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
968: END IF;
969: --
970: END Unassign_Details;
971:

Line 1006: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1002: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1003: --
1004: IF l_debug_on IS NULL
1005: THEN
1006: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1007: END IF;
1008: --
1009: IF l_debug_on THEN
1010: WSH_DEBUG_SV.push(l_module_name);

Line 1010: WSH_DEBUG_SV.push(l_module_name);

1006: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1007: END IF;
1008: --
1009: IF l_debug_on THEN
1010: WSH_DEBUG_SV.push(l_module_name);
1011: --
1012: WSH_DEBUG_SV.log(l_module_name,'P_DETAIL_TAB.COUNT',p_detail_tab.count);
1013: WSH_DEBUG_SV.log(l_module_name,'P_PARENT_DETAIL_FLAG',P_PARENT_DETAIL_FLAG);
1014: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_FLAG',P_DELIVERY_FLAG);

Line 1012: WSH_DEBUG_SV.log(l_module_name,'P_DETAIL_TAB.COUNT',p_detail_tab.count);

1008: --
1009: IF l_debug_on THEN
1010: WSH_DEBUG_SV.push(l_module_name);
1011: --
1012: WSH_DEBUG_SV.log(l_module_name,'P_DETAIL_TAB.COUNT',p_detail_tab.count);
1013: WSH_DEBUG_SV.log(l_module_name,'P_PARENT_DETAIL_FLAG',P_PARENT_DETAIL_FLAG);
1014: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_FLAG',P_DELIVERY_FLAG);
1015: WSH_DEBUG_SV.log(l_module_name,'P_GROUP_API_FLAG',P_GROUP_API_FLAG);
1016: END IF;

Line 1013: WSH_DEBUG_SV.log(l_module_name,'P_PARENT_DETAIL_FLAG',P_PARENT_DETAIL_FLAG);

1009: IF l_debug_on THEN
1010: WSH_DEBUG_SV.push(l_module_name);
1011: --
1012: WSH_DEBUG_SV.log(l_module_name,'P_DETAIL_TAB.COUNT',p_detail_tab.count);
1013: WSH_DEBUG_SV.log(l_module_name,'P_PARENT_DETAIL_FLAG',P_PARENT_DETAIL_FLAG);
1014: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_FLAG',P_DELIVERY_FLAG);
1015: WSH_DEBUG_SV.log(l_module_name,'P_GROUP_API_FLAG',P_GROUP_API_FLAG);
1016: END IF;
1017: --

Line 1014: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_FLAG',P_DELIVERY_FLAG);

1010: WSH_DEBUG_SV.push(l_module_name);
1011: --
1012: WSH_DEBUG_SV.log(l_module_name,'P_DETAIL_TAB.COUNT',p_detail_tab.count);
1013: WSH_DEBUG_SV.log(l_module_name,'P_PARENT_DETAIL_FLAG',P_PARENT_DETAIL_FLAG);
1014: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_FLAG',P_DELIVERY_FLAG);
1015: WSH_DEBUG_SV.log(l_module_name,'P_GROUP_API_FLAG',P_GROUP_API_FLAG);
1016: END IF;
1017: --
1018: --

Line 1015: WSH_DEBUG_SV.log(l_module_name,'P_GROUP_API_FLAG',P_GROUP_API_FLAG);

1011: --
1012: WSH_DEBUG_SV.log(l_module_name,'P_DETAIL_TAB.COUNT',p_detail_tab.count);
1013: WSH_DEBUG_SV.log(l_module_name,'P_PARENT_DETAIL_FLAG',P_PARENT_DETAIL_FLAG);
1014: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_FLAG',P_DELIVERY_FLAG);
1015: WSH_DEBUG_SV.log(l_module_name,'P_GROUP_API_FLAG',P_GROUP_API_FLAG);
1016: END IF;
1017: --
1018: --
1019: -- Debug Statements

Line 1022: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DLVB_COMMON_ACTIONS.UNASSIGN_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);

1018: --
1019: -- Debug Statements
1020: --
1021: IF l_debug_on THEN
1022: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DLVB_COMMON_ACTIONS.UNASSIGN_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
1023: END IF;
1024: --
1025: Unassign_Details (
1026: p_detail_tab,

Line 1036: WSH_DEBUG_SV.pop(l_module_name);

1032: --
1033: -- Debug Statements
1034: --
1035: IF l_debug_on THEN
1036: WSH_DEBUG_SV.pop(l_module_name);
1037: END IF;
1038: --
1039: EXCEPTION
1040:

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

1044: --
1045: -- Debug Statements
1046: --
1047: IF l_debug_on THEN
1048: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1049: END IF;
1050: --
1051: END Unassign_Details;
1052:

Line 1124: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1120: --
1121: BEGIN
1122: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1123: IF l_debug_on IS NULL THEN
1124: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1125: END IF;
1126: --
1127: IF l_debug_on THEN
1128: WSH_DEBUG_SV.push(l_module_name);

Line 1128: WSH_DEBUG_SV.push(l_module_name);

1124: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1125: END IF;
1126: --
1127: IF l_debug_on THEN
1128: WSH_DEBUG_SV.push(l_module_name);
1129: WSH_DEBUG_SV.log(l_module_name,'P_GROUP_ID_TAB.COUNT',P_GROUP_ID_TAB.COUNT);
1130: WSH_DEBUG_SV.log(l_module_name,'P_DETAIL_TAB.COUNT',P_DETAIL_TAB.COUNT);
1131: WSH_DEBUG_SV.log(l_module_name,'P_PACK_CONT_FLAG',P_PACK_CONT_FLAG);
1132: WSH_DEBUG_SV.log(l_module_name,'P_GROUP_API_FLAG',P_GROUP_API_FLAG);

Line 1129: WSH_DEBUG_SV.log(l_module_name,'P_GROUP_ID_TAB.COUNT',P_GROUP_ID_TAB.COUNT);

1125: END IF;
1126: --
1127: IF l_debug_on THEN
1128: WSH_DEBUG_SV.push(l_module_name);
1129: WSH_DEBUG_SV.log(l_module_name,'P_GROUP_ID_TAB.COUNT',P_GROUP_ID_TAB.COUNT);
1130: WSH_DEBUG_SV.log(l_module_name,'P_DETAIL_TAB.COUNT',P_DETAIL_TAB.COUNT);
1131: WSH_DEBUG_SV.log(l_module_name,'P_PACK_CONT_FLAG',P_PACK_CONT_FLAG);
1132: WSH_DEBUG_SV.log(l_module_name,'P_GROUP_API_FLAG',P_GROUP_API_FLAG);
1133: END IF;

Line 1130: WSH_DEBUG_SV.log(l_module_name,'P_DETAIL_TAB.COUNT',P_DETAIL_TAB.COUNT);

1126: --
1127: IF l_debug_on THEN
1128: WSH_DEBUG_SV.push(l_module_name);
1129: WSH_DEBUG_SV.log(l_module_name,'P_GROUP_ID_TAB.COUNT',P_GROUP_ID_TAB.COUNT);
1130: WSH_DEBUG_SV.log(l_module_name,'P_DETAIL_TAB.COUNT',P_DETAIL_TAB.COUNT);
1131: WSH_DEBUG_SV.log(l_module_name,'P_PACK_CONT_FLAG',P_PACK_CONT_FLAG);
1132: WSH_DEBUG_SV.log(l_module_name,'P_GROUP_API_FLAG',P_GROUP_API_FLAG);
1133: END IF;
1134:

Line 1131: WSH_DEBUG_SV.log(l_module_name,'P_PACK_CONT_FLAG',P_PACK_CONT_FLAG);

1127: IF l_debug_on THEN
1128: WSH_DEBUG_SV.push(l_module_name);
1129: WSH_DEBUG_SV.log(l_module_name,'P_GROUP_ID_TAB.COUNT',P_GROUP_ID_TAB.COUNT);
1130: WSH_DEBUG_SV.log(l_module_name,'P_DETAIL_TAB.COUNT',P_DETAIL_TAB.COUNT);
1131: WSH_DEBUG_SV.log(l_module_name,'P_PACK_CONT_FLAG',P_PACK_CONT_FLAG);
1132: WSH_DEBUG_SV.log(l_module_name,'P_GROUP_API_FLAG',P_GROUP_API_FLAG);
1133: END IF;
1134:
1135: l_entity_ids.delete;

Line 1132: WSH_DEBUG_SV.log(l_module_name,'P_GROUP_API_FLAG',P_GROUP_API_FLAG);

1128: WSH_DEBUG_SV.push(l_module_name);
1129: WSH_DEBUG_SV.log(l_module_name,'P_GROUP_ID_TAB.COUNT',P_GROUP_ID_TAB.COUNT);
1130: WSH_DEBUG_SV.log(l_module_name,'P_DETAIL_TAB.COUNT',P_DETAIL_TAB.COUNT);
1131: WSH_DEBUG_SV.log(l_module_name,'P_PACK_CONT_FLAG',P_PACK_CONT_FLAG);
1132: WSH_DEBUG_SV.log(l_module_name,'P_GROUP_API_FLAG',P_GROUP_API_FLAG);
1133: END IF;
1134:
1135: l_entity_ids.delete;
1136: -- bug 1678527: disallow auto-packing in WMS orgs

Line 1144: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DLVB_COMMON_ACTIONS.SEPARATE_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);

1140:
1141: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1142:
1143: IF l_debug_on THEN
1144: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DLVB_COMMON_ACTIONS.SEPARATE_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
1145: END IF;
1146: --
1147: WSH_DLVB_COMMON_ACTIONS.Separate_Details (
1148: p_detail_tab,

Line 1162: --WSH_DEBUG_SV.pop(l_module_name);

1158: FND_MESSAGE.SET_NAME('WSH','WSH_SEPARATE_DET_ERROR');
1159: WSH_UTIL_CORE.Add_Message(x_return_status);
1160: END IF;
1161: --IF l_debug_on THEN
1162: --WSH_DEBUG_SV.pop(l_module_name);
1163: --END IF;
1164: --return;
1165: raise e_return_excp; -- LPN CONV. rv
1166: END IF;

Line 1178: --WSH_DEBUG_SV.pop(l_module_name);

1174: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1175: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_DET_ASSG_NULL');
1176: WSH_UTIL_CORE.Add_Message(x_return_status);
1177: --IF l_debug_on THEN
1178: --WSH_DEBUG_SV.pop(l_module_name);
1179: --END IF;
1180: --return;
1181: raise e_return_excp; -- LPN CONV. rv
1182: END IF;

Line 1187: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.AUTO_PACK_LINES',WSH_DEBUG_SV.C_PROC_LEVEL);

1183:
1184: IF l_detail_tab.count > 0 THEN
1185:
1186: IF l_debug_on THEN
1187: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.AUTO_PACK_LINES',WSH_DEBUG_SV.C_PROC_LEVEL);
1188: END IF;
1189:
1190: WSH_CONTAINER_ACTIONS.Auto_Pack_Lines (
1191: p_group_id_tab,

Line 1198: WSH_DEBUG_SV.logmsg(l_module_name,'RETURN_STATUS'||x_return_status);

1194: l_cont_inst_tab,
1195: x_return_status);
1196:
1197: IF l_debug_on THEN
1198: WSH_DEBUG_SV.logmsg(l_module_name,'RETURN_STATUS'||x_return_status);
1199: END IF;
1200: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1201: -- Bug 2847515
1202: l_ret_sts := x_return_status;

Line 1207: WSH_DEBUG_SV.logmsg(l_module_name,'After Detail Tab');

1203: END IF;
1204: END IF;
1205:
1206: IF l_debug_on THEN
1207: WSH_DEBUG_SV.logmsg(l_module_name,'After Detail Tab');
1208: WSH_DEBUG_SV.logmsg(l_module_name,'X_RETURN_STATUS'||x_return_status);
1209: WSH_DEBUG_SV.logmsg(l_module_name,'L_RETURN_STATUS'||l_ret_sts);
1210: END IF;
1211:

Line 1208: WSH_DEBUG_SV.logmsg(l_module_name,'X_RETURN_STATUS'||x_return_status);

1204: END IF;
1205:
1206: IF l_debug_on THEN
1207: WSH_DEBUG_SV.logmsg(l_module_name,'After Detail Tab');
1208: WSH_DEBUG_SV.logmsg(l_module_name,'X_RETURN_STATUS'||x_return_status);
1209: WSH_DEBUG_SV.logmsg(l_module_name,'L_RETURN_STATUS'||l_ret_sts);
1210: END IF;
1211:
1212: FOR i IN 1..l_cont_inst_tab.count LOOP

Line 1209: WSH_DEBUG_SV.logmsg(l_module_name,'L_RETURN_STATUS'||l_ret_sts);

1205:
1206: IF l_debug_on THEN
1207: WSH_DEBUG_SV.logmsg(l_module_name,'After Detail Tab');
1208: WSH_DEBUG_SV.logmsg(l_module_name,'X_RETURN_STATUS'||x_return_status);
1209: WSH_DEBUG_SV.logmsg(l_module_name,'L_RETURN_STATUS'||l_ret_sts);
1210: END IF;
1211:
1212: FOR i IN 1..l_cont_inst_tab.count LOOP
1213: x_cont_inst_tab(i) := l_cont_inst_tab(i);

Line 1225: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.AUTO_PACK_CONTS',WSH_DEBUG_SV.C_PROC_LEVEL);

1221:
1222: IF l_cont_tab.count > 0 THEN
1223:
1224: IF l_debug_on THEN
1225: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.AUTO_PACK_CONTS',WSH_DEBUG_SV.C_PROC_LEVEL);
1226: END IF;
1227: --
1228: WSH_CONTAINER_ACTIONS.Auto_Pack_Conts (
1229: p_group_id_tab,

Line 1257: WSH_DEBUG_SV.logmsg(l_module_name,'After Container Tab');

1253: l_entity_ids(m) := l_cont_inst_tab(i);
1254: END LOOP;
1255:
1256: IF l_debug_on THEN
1257: WSH_DEBUG_SV.logmsg(l_module_name,'After Container Tab');
1258: WSH_DEBUG_SV.logmsg(l_module_name,'X_RETURN_STATUS'||x_return_status);
1259: WSH_DEBUG_SV.logmsg(l_module_name,'L_RETURN_STATUS'||l_ret_sts);
1260: END IF;
1261:

Line 1258: WSH_DEBUG_SV.logmsg(l_module_name,'X_RETURN_STATUS'||x_return_status);

1254: END LOOP;
1255:
1256: IF l_debug_on THEN
1257: WSH_DEBUG_SV.logmsg(l_module_name,'After Container Tab');
1258: WSH_DEBUG_SV.logmsg(l_module_name,'X_RETURN_STATUS'||x_return_status);
1259: WSH_DEBUG_SV.logmsg(l_module_name,'L_RETURN_STATUS'||l_ret_sts);
1260: END IF;
1261:
1262: IF (l_ret_sts <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

Line 1259: WSH_DEBUG_SV.logmsg(l_module_name,'L_RETURN_STATUS'||l_ret_sts);

1255:
1256: IF l_debug_on THEN
1257: WSH_DEBUG_SV.logmsg(l_module_name,'After Container Tab');
1258: WSH_DEBUG_SV.logmsg(l_module_name,'X_RETURN_STATUS'||x_return_status);
1259: WSH_DEBUG_SV.logmsg(l_module_name,'L_RETURN_STATUS'||l_ret_sts);
1260: END IF;
1261:
1262: IF (l_ret_sts <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1263: -- Bug 2847515

Line 1269: --WSH_DEBUG_SV.pop(l_module_name);

1265: FND_MESSAGE.SET_NAME('WSH','WSH_SUM_AUTOPACK_ERROR');
1266: WSH_UTIL_CORE.Add_Message(x_return_status);
1267: IF (l_ret_sts = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN --Bug 3562797 jckwok
1268: --IF l_debug_on THEN
1269: --WSH_DEBUG_SV.pop(l_module_name);
1270: --END IF;
1271: --return;
1272: raise e_return_excp; -- LPN CONV. rv
1273: END IF;

Line 1278: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);

1274: END IF;
1275: /* H projecst : pricing integration csun */
1276: IF l_entity_ids.count > 0 THEN
1277: IF l_debug_on THEN
1278: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);
1279: END IF;
1280: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(
1281: p_entity_type => 'DELIVERY_DETAIL',
1282: p_entity_ids => l_entity_ids,

Line 1285: WSH_DEBUG_SV.logmsg(l_module_name,'After Mark_Reprice_Required L_RETURN_STATUS:'||l_ret_sts);

1281: p_entity_type => 'DELIVERY_DETAIL',
1282: p_entity_ids => l_entity_ids,
1283: x_return_status => l_ret_sts);
1284: IF l_debug_on THEN
1285: WSH_DEBUG_SV.logmsg(l_module_name,'After Mark_Reprice_Required L_RETURN_STATUS:'||l_ret_sts);
1286: END IF;
1287: IF l_ret_sts <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1288: raise mark_reprice_error;
1289: END IF;

Line 1301: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',WSH_DEBUG_SV.C_PROC_LEVEL);

1297: THEN
1298: --{
1299:
1300: IF l_debug_on THEN
1301: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',WSH_DEBUG_SV.C_PROC_LEVEL);
1302: END IF;
1303: --
1304: WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS
1305: (

Line 1313: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);

1309: );
1310: --
1311: --
1312: IF l_debug_on THEN
1313: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
1314: END IF;
1315: --
1316: --
1317: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

Line 1322: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_WMS_SYNC_TMP_PKG.MERGE completed with an error');

1318: --
1319: x_return_status := l_return_status;
1320: --
1321: IF l_debug_on THEN
1322: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_WMS_SYNC_TMP_PKG.MERGE completed with an error');
1323: WSH_DEBUG_SV.pop(l_module_name);
1324: END IF;
1325: --
1326: RETURN;

Line 1323: WSH_DEBUG_SV.pop(l_module_name);

1319: x_return_status := l_return_status;
1320: --
1321: IF l_debug_on THEN
1322: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_WMS_SYNC_TMP_PKG.MERGE completed with an error');
1323: WSH_DEBUG_SV.pop(l_module_name);
1324: END IF;
1325: --
1326: RETURN;
1327: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

Line 1344: WSH_DEBUG_SV.logmsg(l_module_name,'X_RETURN_STATUS:'||x_return_status);

1340: --
1341: END IF;
1342:
1343: IF l_debug_on THEN
1344: WSH_DEBUG_SV.logmsg(l_module_name,'X_RETURN_STATUS:'||x_return_status);
1345: WSH_DEBUG_SV.log(l_module_name,'X_CONT_INST_TAB.COUNT',X_CONT_INST_TAB.COUNT);
1346: WSH_DEBUG_SV.pop(l_module_name);
1347: END IF;
1348:

Line 1345: WSH_DEBUG_SV.log(l_module_name,'X_CONT_INST_TAB.COUNT',X_CONT_INST_TAB.COUNT);

1341: END IF;
1342:
1343: IF l_debug_on THEN
1344: WSH_DEBUG_SV.logmsg(l_module_name,'X_RETURN_STATUS:'||x_return_status);
1345: WSH_DEBUG_SV.log(l_module_name,'X_CONT_INST_TAB.COUNT',X_CONT_INST_TAB.COUNT);
1346: WSH_DEBUG_SV.pop(l_module_name);
1347: END IF;
1348:
1349: EXCEPTION

Line 1346: WSH_DEBUG_SV.pop(l_module_name);

1342:
1343: IF l_debug_on THEN
1344: WSH_DEBUG_SV.logmsg(l_module_name,'X_RETURN_STATUS:'||x_return_status);
1345: WSH_DEBUG_SV.log(l_module_name,'X_CONT_INST_TAB.COUNT',X_CONT_INST_TAB.COUNT);
1346: WSH_DEBUG_SV.pop(l_module_name);
1347: END IF;
1348:
1349: EXCEPTION
1350:

Line 1359: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',WSH_DEBUG_SV.C_PROC_LEVEL);

1355: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
1356: THEN
1357: --{
1358: IF l_debug_on THEN
1359: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',WSH_DEBUG_SV.C_PROC_LEVEL);
1360: END IF;
1361:
1362: WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS
1363: (

Line 1371: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);

1367: );
1368: --
1369: --
1370: IF l_debug_on THEN
1371: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
1372: END IF;
1373: --
1374: --
1375: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR,WSH_UTIL_CORE.G_RET_STS_ERROR) and x_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

Line 1388: WSH_DEBUG_SV.logmsg(l_module_name,'E_RETURN_EXCP exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1384: --
1385: -- Debug Statements
1386: --
1387: IF l_debug_on THEN
1388: WSH_DEBUG_SV.logmsg(l_module_name,'E_RETURN_EXCP exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1389: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:E_RETURN_EXCP');
1390: END IF;
1391: --
1392: --

Line 1389: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:E_RETURN_EXCP');

1385: -- Debug Statements
1386: --
1387: IF l_debug_on THEN
1388: WSH_DEBUG_SV.logmsg(l_module_name,'E_RETURN_EXCP exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1389: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:E_RETURN_EXCP');
1390: END IF;
1391: --
1392: --
1393: WHEN mark_reprice_error THEN

Line 1405: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',WSH_DEBUG_SV.C_PROC_LEVEL);

1401: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
1402: THEN
1403: --{
1404: IF l_debug_on THEN
1405: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',WSH_DEBUG_SV.C_PROC_LEVEL);
1406: END IF;
1407:
1408: WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS
1409: (

Line 1417: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);

1413: );
1414: --
1415: --
1416: IF l_debug_on THEN
1417: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
1418: END IF;
1419: --
1420: --
1421: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

Line 1434: WSH_DEBUG_SV.logmsg(l_module_name,'MARK_REPRICE_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1430: --
1431: -- Debug Statements
1432: --
1433: IF l_debug_on THEN
1434: WSH_DEBUG_SV.logmsg(l_module_name,'MARK_REPRICE_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1435: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:MARK_REPRICE_ERROR');
1436: END IF;
1437: --
1438: WHEN Others THEN

Line 1435: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:MARK_REPRICE_ERROR');

1431: -- Debug Statements
1432: --
1433: IF l_debug_on THEN
1434: WSH_DEBUG_SV.logmsg(l_module_name,'MARK_REPRICE_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1435: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:MARK_REPRICE_ERROR');
1436: END IF;
1437: --
1438: WHEN Others THEN
1439: WSH_UTIL_CORE.Default_Handler('WSH_DLVB_COMMON_ACTIONS.Auto_Pack_Lines');

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

1438: WHEN Others THEN
1439: WSH_UTIL_CORE.Default_Handler('WSH_DLVB_COMMON_ACTIONS.Auto_Pack_Lines');
1440: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1441: IF l_debug_on THEN
1442: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1443: END IF;
1444: --
1445: -- K LPN CONV. rv
1446: --

Line 1451: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',WSH_DEBUG_SV.C_PROC_LEVEL);

1447: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
1448: THEN
1449: --{
1450: IF l_debug_on THEN
1451: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',WSH_DEBUG_SV.C_PROC_LEVEL);
1452: END IF;
1453:
1454: WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS
1455: (

Line 1463: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);

1459: );
1460: --
1461: --
1462: IF l_debug_on THEN
1463: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
1464: END IF;
1465: --
1466: --
1467: --}

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

1474: --
1475: -- Debug Statements
1476: --
1477: IF l_debug_on THEN
1478: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1479: END IF;
1480: --
1481: END Auto_Pack_Lines;
1482:

Line 1551: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1547: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1548: --
1549: IF l_debug_on IS NULL
1550: THEN
1551: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1552: END IF;
1553: --
1554: IF l_debug_on THEN
1555: WSH_DEBUG_SV.push(l_module_name);

Line 1555: WSH_DEBUG_SV.push(l_module_name);

1551: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1552: END IF;
1553: --
1554: IF l_debug_on THEN
1555: WSH_DEBUG_SV.push(l_module_name);
1556: --
1557: WSH_DEBUG_SV.log(l_module_name,'P_INPUT_TAB.COUNT',P_INPUT_TAB.COUNT);
1558: WSH_DEBUG_SV.log(l_module_name,'P_WMS_FILTER_FLAG',P_WMS_FILTER_FLAG);
1559: END IF;

Line 1557: WSH_DEBUG_SV.log(l_module_name,'P_INPUT_TAB.COUNT',P_INPUT_TAB.COUNT);

1553: --
1554: IF l_debug_on THEN
1555: WSH_DEBUG_SV.push(l_module_name);
1556: --
1557: WSH_DEBUG_SV.log(l_module_name,'P_INPUT_TAB.COUNT',P_INPUT_TAB.COUNT);
1558: WSH_DEBUG_SV.log(l_module_name,'P_WMS_FILTER_FLAG',P_WMS_FILTER_FLAG);
1559: END IF;
1560: --
1561: IF p_input_tab.count <> 0 THEN

Line 1558: WSH_DEBUG_SV.log(l_module_name,'P_WMS_FILTER_FLAG',P_WMS_FILTER_FLAG);

1554: IF l_debug_on THEN
1555: WSH_DEBUG_SV.push(l_module_name);
1556: --
1557: WSH_DEBUG_SV.log(l_module_name,'P_INPUT_TAB.COUNT',P_INPUT_TAB.COUNT);
1558: WSH_DEBUG_SV.log(l_module_name,'P_WMS_FILTER_FLAG',P_WMS_FILTER_FLAG);
1559: END IF;
1560: --
1561: IF p_input_tab.count <> 0 THEN
1562:

Line 1627: WSH_DEBUG_SV.log(l_module_name,'X_DETAIL_TAB.COUNT',X_DETAIL_TAB.COUNT);

1623: --
1624: -- Debug Statements
1625: --
1626: IF l_debug_on THEN
1627: WSH_DEBUG_SV.log(l_module_name,'X_DETAIL_TAB.COUNT',X_DETAIL_TAB.COUNT);
1628: WSH_DEBUG_SV.log(l_module_name,'X_CONT_INST_TAB.COUNT',X_CONT_INST_TAB.COUNT);
1629: WSH_DEBUG_SV.pop(l_module_name);
1630: END IF;
1631: --

Line 1628: WSH_DEBUG_SV.log(l_module_name,'X_CONT_INST_TAB.COUNT',X_CONT_INST_TAB.COUNT);

1624: -- Debug Statements
1625: --
1626: IF l_debug_on THEN
1627: WSH_DEBUG_SV.log(l_module_name,'X_DETAIL_TAB.COUNT',X_DETAIL_TAB.COUNT);
1628: WSH_DEBUG_SV.log(l_module_name,'X_CONT_INST_TAB.COUNT',X_CONT_INST_TAB.COUNT);
1629: WSH_DEBUG_SV.pop(l_module_name);
1630: END IF;
1631: --
1632: EXCEPTION

Line 1629: WSH_DEBUG_SV.pop(l_module_name);

1625: --
1626: IF l_debug_on THEN
1627: WSH_DEBUG_SV.log(l_module_name,'X_DETAIL_TAB.COUNT',X_DETAIL_TAB.COUNT);
1628: WSH_DEBUG_SV.log(l_module_name,'X_CONT_INST_TAB.COUNT',X_CONT_INST_TAB.COUNT);
1629: WSH_DEBUG_SV.pop(l_module_name);
1630: END IF;
1631: --
1632: EXCEPTION
1633:

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

1638: --
1639: -- Debug Statements
1640: --
1641: IF l_debug_on THEN
1642: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1643: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1644: END IF;
1645: --
1646: END Separate_Details;

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

1639: -- Debug Statements
1640: --
1641: IF l_debug_on THEN
1642: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1643: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1644: END IF;
1645: --
1646: END Separate_Details;
1647:

Line 1724: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1720: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1721: --
1722: IF l_debug_on IS NULL
1723: THEN
1724: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1725: END IF;
1726: --
1727: IF l_debug_on THEN
1728: WSH_DEBUG_SV.push(l_module_name);

Line 1728: WSH_DEBUG_SV.push(l_module_name);

1724: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1725: END IF;
1726: --
1727: IF l_debug_on THEN
1728: WSH_DEBUG_SV.push(l_module_name);
1729: --
1730: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_INSTANCE_ID',P_CONTAINER_INSTANCE_ID);
1731: END IF;
1732: --

Line 1730: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_INSTANCE_ID',P_CONTAINER_INSTANCE_ID);

1726: --
1727: IF l_debug_on THEN
1728: WSH_DEBUG_SV.push(l_module_name);
1729: --
1730: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_INSTANCE_ID',P_CONTAINER_INSTANCE_ID);
1731: END IF;
1732: --
1733: OPEN Get_Cont_Info;
1734:

Line 1752: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

1748: --
1749: -- Debug Statements
1750: --
1751: IF l_debug_on THEN
1752: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1753: END IF;
1754: --
1755: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_container_instance_id);
1756: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');

Line 1764: WSH_DEBUG_SV.pop(l_module_name);

1760: --
1761: -- Debug Statements
1762: --
1763: IF l_debug_on THEN
1764: WSH_DEBUG_SV.pop(l_module_name);
1765: END IF;
1766: --
1767: return;
1768: END IF;

Line 1779: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

1775: --
1776: -- Debug Statements
1777: --
1778: IF l_debug_on THEN
1779: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1780: END IF;
1781: --
1782: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_container_instance_id);
1783: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_WV_UOM_NULL');

Line 1791: WSH_DEBUG_SV.pop(l_module_name);

1787: --
1788: -- Debug Statements
1789: --
1790: IF l_debug_on THEN
1791: WSH_DEBUG_SV.pop(l_module_name);
1792: END IF;
1793: --
1794: return;
1795: END IF;

Line 1805: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TPA_CONTAINER_PKG.CONTAINER_WEIGHT_VOLUME',WSH_DEBUG_SV.C_PROC_LEVEL);

1801: --
1802: -- Debug Statements
1803: --
1804: IF l_debug_on THEN
1805: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TPA_CONTAINER_PKG.CONTAINER_WEIGHT_VOLUME',WSH_DEBUG_SV.C_PROC_LEVEL);
1806: END IF;
1807:
1808: --Bug 3630085:OMFST:J:R2:WRONG VALUE OF WEIGHT AND VOLUME IN PACKING WORKBENCH WINDOW
1809: --x_volume in case of a container represent the total volume of the container

Line 1827: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

1823: --
1824: -- Debug Statements
1825: --
1826: IF l_debug_on THEN
1827: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1828: END IF;
1829: --
1830: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_container_instance_id);
1831: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_WT_VOL_FAILED');

Line 1848: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TPA_CONTAINER_PKG.CONTAINER_TARE_WEIGHT_SELF',WSH_DEBUG_SV.C_PROC_LEVEL);

1844: --
1845: -- Debug Statements
1846: --
1847: IF l_debug_on THEN
1848: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TPA_CONTAINER_PKG.CONTAINER_TARE_WEIGHT_SELF',WSH_DEBUG_SV.C_PROC_LEVEL);
1849: END IF;
1850: --
1851: WSH_TPA_CONTAINER_PKG.Container_Tare_Weight_Self (
1852: p_container_instance_id,

Line 1864: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

1860: --
1861: -- Debug Statements
1862: --
1863: IF l_debug_on THEN
1864: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1865: END IF;
1866: --
1867: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_container_instance_id);
1868: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_TARE_SELF_FAIL');

Line 1879: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.GET_DEFAULT_UOMS',WSH_DEBUG_SV.C_PROC_LEVEL);

1875: --
1876: -- Debug Statements
1877: --
1878: IF l_debug_on THEN
1879: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.GET_DEFAULT_UOMS',WSH_DEBUG_SV.C_PROC_LEVEL);
1880: END IF;
1881: --
1882: WSH_WV_UTILS.Get_Default_Uoms (
1883: cont_org_id,

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

1889: --
1890: -- Debug Statements
1891: --
1892: IF l_debug_on THEN
1893: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_ORG_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1894: END IF;
1895: --
1896: l_org_name := WSH_UTIL_CORE.Get_Org_Name(cont_org_id);
1897: FND_MESSAGE.SET_NAME('WSH','WSH_DEFAULT_UOM_ERROR');

Line 1913: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);

1909: --
1910: -- Debug Statements
1911: --
1912: IF l_debug_on THEN
1913: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
1914: END IF;
1915: --
1916: gr_wt := WSH_WV_UTILS.Convert_Uom (
1917: wt_uom,

Line 1926: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);

1922: --
1923: -- Debug Statements
1924: --
1925: IF l_debug_on THEN
1926: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
1927: END IF;
1928: --
1929: net_wt := WSH_WV_UTILS.Convert_Uom (
1930: wt_uom,

Line 1939: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);

1935: --
1936: -- Debug Statements
1937: --
1938: IF l_debug_on THEN
1939: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
1940: END IF;
1941: --
1942: max_load_wt := WSH_WV_UTILS.Convert_Uom (
1943: wt_uom,

Line 1953: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);

1949: --
1950: -- Debug Statements
1951: --
1952: IF l_debug_on THEN
1953: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
1954: END IF;
1955: --
1956: fill_vol := WSH_WV_UTILS.Convert_Uom (
1957: vol_uom,

Line 1967: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);

1963: --
1964: -- Debug Statements
1965: --
1966: IF l_debug_on THEN
1967: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
1968: END IF;
1969: --
1970: max_vol := WSH_WV_UTILS.Convert_Uom (
1971: vol_uom,

Line 1981: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);

1977: --
1978: -- Debug Statements
1979: --
1980: IF l_debug_on THEN
1981: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
1982: END IF;
1983: --
1984: tare_wt := WSH_WV_UTILS.Convert_Uom (
1985: wt_uom,

Line 2008: WSH_DEBUG_SV.log(l_module_name,'X_AVAIL_WT',x_avail_wt);

2004: --
2005: -- Debug Statements
2006: --
2007: IF l_debug_on THEN
2008: WSH_DEBUG_SV.log(l_module_name,'X_AVAIL_WT',x_avail_wt);
2009: WSH_DEBUG_SV.log(l_module_name,'X_AVAIL_VOL',x_avail_vol);
2010: WSH_DEBUG_SV.pop(l_module_name);
2011: END IF;
2012: --

Line 2009: WSH_DEBUG_SV.log(l_module_name,'X_AVAIL_VOL',x_avail_vol);

2005: -- Debug Statements
2006: --
2007: IF l_debug_on THEN
2008: WSH_DEBUG_SV.log(l_module_name,'X_AVAIL_WT',x_avail_wt);
2009: WSH_DEBUG_SV.log(l_module_name,'X_AVAIL_VOL',x_avail_vol);
2010: WSH_DEBUG_SV.pop(l_module_name);
2011: END IF;
2012: --
2013: EXCEPTION

Line 2010: WSH_DEBUG_SV.pop(l_module_name);

2006: --
2007: IF l_debug_on THEN
2008: WSH_DEBUG_SV.log(l_module_name,'X_AVAIL_WT',x_avail_wt);
2009: WSH_DEBUG_SV.log(l_module_name,'X_AVAIL_VOL',x_avail_vol);
2010: WSH_DEBUG_SV.pop(l_module_name);
2011: END IF;
2012: --
2013: EXCEPTION
2014:

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

2019: --
2020: -- Debug Statements
2021: --
2022: IF l_debug_on THEN
2023: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2024: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2025: END IF;
2026: --
2027: END Calc_Cont_Avail;

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

2020: -- Debug Statements
2021: --
2022: IF l_debug_on THEN
2023: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2024: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2025: END IF;
2026: --
2027: END Calc_Cont_Avail;
2028:

Line 2092: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

2088: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2089: --
2090: IF l_debug_on IS NULL
2091: THEN
2092: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2093: END IF;
2094: --
2095: IF l_debug_on THEN
2096: WSH_DEBUG_SV.push(l_module_name);

Line 2096: WSH_DEBUG_SV.push(l_module_name);

2092: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2093: END IF;
2094: --
2095: IF l_debug_on THEN
2096: WSH_DEBUG_SV.push(l_module_name);
2097: --
2098: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_DETAIL_ID',P_DELIVERY_DETAIL_ID);
2099: END IF;
2100: --

Line 2098: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_DETAIL_ID',P_DELIVERY_DETAIL_ID);

2094: --
2095: IF l_debug_on THEN
2096: WSH_DEBUG_SV.push(l_module_name);
2097: --
2098: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_DETAIL_ID',P_DELIVERY_DETAIL_ID);
2099: END IF;
2100: --
2101: OPEN Get_Detail_Info;
2102:

Line 2121: WSH_DEBUG_SV.pop(l_module_name);

2117: --
2118: -- Debug Statements
2119: --
2120: IF l_debug_on THEN
2121: WSH_DEBUG_SV.pop(l_module_name);
2122: END IF;
2123: --
2124: return;
2125: END IF;

Line 2140: WSH_DEBUG_SV.pop(l_module_name);

2136: --
2137: -- Debug Statements
2138: --
2139: IF l_debug_on THEN
2140: WSH_DEBUG_SV.pop(l_module_name);
2141: END IF;
2142: --
2143: return;
2144: END IF;

Line 2152: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DETAIL_WEIGHT_VOLUME',WSH_DEBUG_SV.C_PROC_LEVEL);

2148: --
2149: -- Debug Statements
2150: --
2151: IF l_debug_on THEN
2152: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DETAIL_WEIGHT_VOLUME',WSH_DEBUG_SV.C_PROC_LEVEL);
2153: END IF;
2154: --
2155: WSH_WV_UTILS.Detail_Weight_Volume (
2156: p_delivery_detail_id => p_delivery_detail_id,

Line 2174: WSH_DEBUG_SV.pop(l_module_name);

2170: --
2171: -- Debug Statements
2172: --
2173: IF l_debug_on THEN
2174: WSH_DEBUG_SV.pop(l_module_name);
2175: END IF;
2176: --
2177: return;
2178: END IF;

Line 2186: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.GET_DEFAULT_UOMS',WSH_DEBUG_SV.C_PROC_LEVEL);

2182: --
2183: -- Debug Statements
2184: --
2185: IF l_debug_on THEN
2186: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.GET_DEFAULT_UOMS',WSH_DEBUG_SV.C_PROC_LEVEL);
2187: END IF;
2188: --
2189: WSH_WV_UTILS.Get_Default_Uoms (
2190: det_org_id,

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

2196: --
2197: -- Debug Statements
2198: --
2199: IF l_debug_on THEN
2200: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_ORG_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2201: END IF;
2202: --
2203: l_org_name := WSH_UTIL_CORE.Get_Org_Name(det_org_id);
2204: FND_MESSAGE.SET_NAME('WSH','WSH_DEFAULT_UOM_ERROR');

Line 2221: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);

2217: --
2218: -- Debug Statements
2219: --
2220: IF l_debug_on THEN
2221: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
2222: END IF;
2223: --
2224: net_wt := WSH_WV_UTILS.Convert_Uom (
2225: wt_uom,

Line 2234: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);

2230: --
2231: -- Debug Statements
2232: --
2233: IF l_debug_on THEN
2234: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
2235: END IF;
2236: --
2237: vol := WSH_WV_UTILS.Convert_Uom (
2238: vol_uom,

Line 2254: WSH_DEBUG_SV.log(l_module_name,'x_item_wt',x_item_wt);

2250: --
2251: -- Debug Statements
2252: --
2253: IF l_debug_on THEN
2254: WSH_DEBUG_SV.log(l_module_name,'x_item_wt',x_item_wt);
2255: WSH_DEBUG_SV.log(l_module_name,'x_item_vol',x_item_vol);
2256: WSH_DEBUG_SV.pop(l_module_name);
2257: END IF;
2258: --

Line 2255: WSH_DEBUG_SV.log(l_module_name,'x_item_vol',x_item_vol);

2251: -- Debug Statements
2252: --
2253: IF l_debug_on THEN
2254: WSH_DEBUG_SV.log(l_module_name,'x_item_wt',x_item_wt);
2255: WSH_DEBUG_SV.log(l_module_name,'x_item_vol',x_item_vol);
2256: WSH_DEBUG_SV.pop(l_module_name);
2257: END IF;
2258: --
2259: EXCEPTION

Line 2256: WSH_DEBUG_SV.pop(l_module_name);

2252: --
2253: IF l_debug_on THEN
2254: WSH_DEBUG_SV.log(l_module_name,'x_item_wt',x_item_wt);
2255: WSH_DEBUG_SV.log(l_module_name,'x_item_vol',x_item_vol);
2256: WSH_DEBUG_SV.pop(l_module_name);
2257: END IF;
2258: --
2259: EXCEPTION
2260:

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

2265: --
2266: -- Debug Statements
2267: --
2268: IF l_debug_on THEN
2269: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2270: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2271: END IF;
2272: --
2273: END Calc_Item_Total;

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

2266: -- Debug Statements
2267: --
2268: IF l_debug_on THEN
2269: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2270: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2271: END IF;
2272: --
2273: END Calc_Item_Total;
2274:

Line 2354: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

2350: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2351: --
2352: IF l_debug_on IS NULL
2353: THEN
2354: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2355: END IF;
2356: --
2357: IF l_debug_on THEN
2358: WSH_DEBUG_SV.push(l_module_name);

Line 2358: WSH_DEBUG_SV.push(l_module_name);

2354: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2355: END IF;
2356: --
2357: IF l_debug_on THEN
2358: WSH_DEBUG_SV.push(l_module_name);
2359: WSH_DEBUG_SV.log(l_module_name,'P_DETAIL_INPUT_TAB.COUNT',p_detail_input_tab.count);
2360: END IF;
2361: --
2362: IF p_detail_input_tab.count <= 0 THEN

Line 2359: WSH_DEBUG_SV.log(l_module_name,'P_DETAIL_INPUT_TAB.COUNT',p_detail_input_tab.count);

2355: END IF;
2356: --
2357: IF l_debug_on THEN
2358: WSH_DEBUG_SV.push(l_module_name);
2359: WSH_DEBUG_SV.log(l_module_name,'P_DETAIL_INPUT_TAB.COUNT',p_detail_input_tab.count);
2360: END IF;
2361: --
2362: IF p_detail_input_tab.count <= 0 THEN
2363: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 2370: --WSH_DEBUG_SV.pop(l_module_name);

2366: --
2367: -- Debug Statements
2368: --
2369: --IF l_debug_on THEN
2370: --WSH_DEBUG_SV.pop(l_module_name);
2371: --END IF;
2372: --
2373: --return;
2374: raise e_return_excp; -- LPN CONV. rv

Line 2381: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DLVB_COMMON_ACTIONS.SEPARATE_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);

2377: --
2378: -- Debug Statements
2379: --
2380: IF l_debug_on THEN
2381: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DLVB_COMMON_ACTIONS.SEPARATE_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
2382: END IF;
2383: --
2384: WSH_DLVB_COMMON_ACTIONS.Separate_Details (
2385: p_detail_input_tab,

Line 2400: --WSH_DEBUG_SV.pop(l_module_name);

2396: --
2397: -- Debug Statements
2398: --
2399: --IF l_debug_on THEN
2400: --WSH_DEBUG_SV.pop(l_module_name);
2401: --END IF;
2402: --
2403: --return;
2404: raise e_return_excp; -- LPN CONV. rv

Line 2414: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DLVB_COMMON_ACTIONS.CALC_CONT_AVAIL',WSH_DEBUG_SV.C_PROC_LEVEL);

2410: --
2411: -- Debug Statements
2412: --
2413: IF l_debug_on THEN
2414: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DLVB_COMMON_ACTIONS.CALC_CONT_AVAIL',WSH_DEBUG_SV.C_PROC_LEVEL);
2415: END IF;
2416: --
2417: WSH_DLVB_COMMON_ACTIONS.Calc_Cont_Avail (
2418: l_cont_tab(i),

Line 2445: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DLVB_COMMON_ACTIONS.CALC_ITEM_TOTAL',WSH_DEBUG_SV.C_PROC_LEVEL);

2441: --
2442: -- Debug Statements
2443: --
2444: IF l_debug_on THEN
2445: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DLVB_COMMON_ACTIONS.CALC_ITEM_TOTAL',WSH_DEBUG_SV.C_PROC_LEVEL);
2446: END IF;
2447: --
2448: WSH_DLVB_COMMON_ACTIONS.Calc_Item_Total (
2449: l_detail_tab(i),

Line 2473: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',WSH_DEBUG_SV.C_PROC_LEVEL);

2469: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
2470: THEN
2471: --{
2472: IF l_debug_on THEN
2473: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',WSH_DEBUG_SV.C_PROC_LEVEL);
2474: END IF;
2475:
2476: WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS
2477: (

Line 2485: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);

2481: );
2482: --
2483: --
2484: IF l_debug_on THEN
2485: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
2486: END IF;
2487: --
2488: --
2489: IF l_return_status NOT IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS,WSH_UTIL_CORE.G_RET_STS_WARNING)

Line 2516: WSH_DEBUG_SV.log(l_module_name,'x_item_wt_total',x_item_wt_total);

2512: --
2513: -- Debug Statements
2514: --
2515: IF l_debug_on THEN
2516: WSH_DEBUG_SV.log(l_module_name,'x_item_wt_total',x_item_wt_total);
2517: WSH_DEBUG_SV.log(l_module_name,'x_item_vol_total',x_item_vol_total);
2518: WSH_DEBUG_SV.pop(l_module_name);
2519: END IF;
2520: --

Line 2517: WSH_DEBUG_SV.log(l_module_name,'x_item_vol_total',x_item_vol_total);

2513: -- Debug Statements
2514: --
2515: IF l_debug_on THEN
2516: WSH_DEBUG_SV.log(l_module_name,'x_item_wt_total',x_item_wt_total);
2517: WSH_DEBUG_SV.log(l_module_name,'x_item_vol_total',x_item_vol_total);
2518: WSH_DEBUG_SV.pop(l_module_name);
2519: END IF;
2520: --
2521: EXCEPTION

Line 2518: WSH_DEBUG_SV.pop(l_module_name);

2514: --
2515: IF l_debug_on THEN
2516: WSH_DEBUG_SV.log(l_module_name,'x_item_wt_total',x_item_wt_total);
2517: WSH_DEBUG_SV.log(l_module_name,'x_item_vol_total',x_item_vol_total);
2518: WSH_DEBUG_SV.pop(l_module_name);
2519: END IF;
2520: --
2521: EXCEPTION
2522: --

Line 2531: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',WSH_DEBUG_SV.C_PROC_LEVEL);

2527: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
2528: THEN
2529: --{
2530: IF l_debug_on THEN
2531: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',WSH_DEBUG_SV.C_PROC_LEVEL);
2532: END IF;
2533:
2534: WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS
2535: (

Line 2543: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);

2539: );
2540: --
2541: --
2542: IF l_debug_on THEN
2543: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
2544: END IF;
2545: --
2546: --
2547: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR,WSH_UTIL_CORE.G_RET_STS_ERROR) and x_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

Line 2557: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:E_RETURN_EXCP');

2553: --
2554: -- K LPN CONV. rv
2555: --
2556: IF l_debug_on THEN
2557: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:E_RETURN_EXCP');
2558: END IF;
2559: --
2560: WHEN Others THEN
2561: WSH_UTIL_CORE.Default_Handler('WSH_DLVB_COMMON_ACTIONS.Calculate_Total_Capacities');

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

2560: WHEN Others THEN
2561: WSH_UTIL_CORE.Default_Handler('WSH_DLVB_COMMON_ACTIONS.Calculate_Total_Capacities');
2562: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2563: IF l_debug_on THEN
2564: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2565: END IF;
2566: --
2567: -- K LPN CONV. rv
2568: --

Line 2573: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',WSH_DEBUG_SV.C_PROC_LEVEL);

2569: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
2570: THEN
2571: --{
2572: IF l_debug_on THEN
2573: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',WSH_DEBUG_SV.C_PROC_LEVEL);
2574: END IF;
2575:
2576: WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS
2577: (

Line 2585: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);

2581: );
2582: --
2583: --
2584: IF l_debug_on THEN
2585: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
2586: END IF;
2587: --
2588: --
2589: --}

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

2595: --
2596: -- Debug Statements
2597: --
2598: IF l_debug_on THEN
2599: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2600: END IF;
2601: --
2602: END Calculate_Total_Capacities;
2603: