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 226: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 474: 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);

470: --{
471:
472: --
473: IF l_debug_on THEN
474: 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);
475: END IF;
476: --
477: WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS
478: (

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

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

Line 499: WSH_DEBUG_SV.pop(l_module_name);

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

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

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

Line 517: WSH_DEBUG_SV.pop(l_module_name);

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

Line 533: WSH_DEBUG_SV.pop(l_module_name);

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

Line 546: 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);

542: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
543: THEN
544: --{
545: IF l_debug_on THEN
546: 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);
547: END IF;
548:
549: WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS
550: (

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

554: );
555: --
556: --
557: IF l_debug_on THEN
558: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
559: END IF;
560: --
561: --
562: 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 572: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:E_RETURN_EXCP');

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

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

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

Line 588: 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);

584: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
585: THEN
586: --{
587: IF l_debug_on THEN
588: 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);
589: END IF;
590:
591: WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS
592: (

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

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

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

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

Line 702: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

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

Line 706: WSH_DEBUG_SV.push(l_module_name);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 833: 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);

829: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
830: THEN
831: --{
832: IF l_debug_on THEN
833: 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);
834: END IF;
835:
836: WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS
837: (

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

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

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

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

Line 887: WSH_DEBUG_SV.pop(l_module_name);

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

Line 900: 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);

896: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
897: THEN
898: --{
899: IF l_debug_on THEN
900: 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);
901: END IF;
902:
903: WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS
904: (

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

908: );
909: --
910: --
911: IF l_debug_on THEN
912: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
913: END IF;
914: --
915: --
916: 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 924: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:e_return_excp');

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

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

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

Line 942: 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);

938: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
939: THEN
940: --{
941: IF l_debug_on THEN
942: 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);
943: END IF;
944:
945: WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS
946: (

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

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

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

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

Line 1008: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

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

Line 1012: WSH_DEBUG_SV.push(l_module_name);

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

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

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

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

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

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

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

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

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

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

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

Line 1038: WSH_DEBUG_SV.pop(l_module_name);

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

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

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

Line 1126: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

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

Line 1130: WSH_DEBUG_SV.push(l_module_name);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1303: 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);

1299: THEN
1300: --{
1301:
1302: IF l_debug_on THEN
1303: 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);
1304: END IF;
1305: --
1306: WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS
1307: (

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

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

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

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

Line 1325: WSH_DEBUG_SV.pop(l_module_name);

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

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

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

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

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

Line 1348: WSH_DEBUG_SV.pop(l_module_name);

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

Line 1361: 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);

1357: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
1358: THEN
1359: --{
1360: IF l_debug_on THEN
1361: 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);
1362: END IF;
1363:
1364: WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS
1365: (

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

1369: );
1370: --
1371: --
1372: IF l_debug_on THEN
1373: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
1374: END IF;
1375: --
1376: --
1377: 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 1390: WSH_DEBUG_SV.logmsg(l_module_name,'E_RETURN_EXCP exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

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

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

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

Line 1407: 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);

1403: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
1404: THEN
1405: --{
1406: IF l_debug_on THEN
1407: 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);
1408: END IF;
1409:
1410: WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS
1411: (

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

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

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

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

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

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

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

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

Line 1453: 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);

1449: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
1450: THEN
1451: --{
1452: IF l_debug_on THEN
1453: 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);
1454: END IF;
1455:
1456: WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS
1457: (

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

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

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

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

Line 1553: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

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

Line 1557: WSH_DEBUG_SV.push(l_module_name);

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

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

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

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

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

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

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

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

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

Line 1631: WSH_DEBUG_SV.pop(l_module_name);

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

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

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

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

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

Line 1726: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

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

Line 1730: WSH_DEBUG_SV.push(l_module_name);

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

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

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

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

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

Line 1766: WSH_DEBUG_SV.pop(l_module_name);

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

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

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

Line 1793: WSH_DEBUG_SV.pop(l_module_name);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 2012: WSH_DEBUG_SV.pop(l_module_name);

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

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

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

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

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

Line 2094: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

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

Line 2098: WSH_DEBUG_SV.push(l_module_name);

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

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

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

Line 2123: WSH_DEBUG_SV.pop(l_module_name);

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

Line 2142: WSH_DEBUG_SV.pop(l_module_name);

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

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

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

Line 2176: WSH_DEBUG_SV.pop(l_module_name);

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 2258: WSH_DEBUG_SV.pop(l_module_name);

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

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

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

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

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

Line 2356: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

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

Line 2360: WSH_DEBUG_SV.push(l_module_name);

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 2475: 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);

2471: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
2472: THEN
2473: --{
2474: IF l_debug_on THEN
2475: 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);
2476: END IF;
2477:
2478: WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS
2479: (

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

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

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

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

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

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

Line 2520: WSH_DEBUG_SV.pop(l_module_name);

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

Line 2533: 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);

2529: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
2530: THEN
2531: --{
2532: IF l_debug_on THEN
2533: 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);
2534: END IF;
2535:
2536: WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS
2537: (

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

2541: );
2542: --
2543: --
2544: IF l_debug_on THEN
2545: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
2546: END IF;
2547: --
2548: --
2549: 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 2559: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:E_RETURN_EXCP');

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

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

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

Line 2575: 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);

2571: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
2572: THEN
2573: --{
2574: IF l_debug_on THEN
2575: 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);
2576: END IF;
2577:
2578: WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS
2579: (

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

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

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

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