DBA Data[Home] [Help]

APPS.WSH_LPN_SYNC_COMM_PKG dependencies on WSH_WMS_LPN_GRP

Line 169: WSH_DEBUG_SV.log(l_module_name,'wsh_wms_lpn_grp.g_hw_time_stamp', wsh_wms_lpn_grp.g_hw_time_stamp);

165: -- Setting the return status in the begining
166: x_return_status := wsh_util_core.g_ret_sts_success;
167: --
168: IF l_debug_on THEN
169: WSH_DEBUG_SV.log(l_module_name,'wsh_wms_lpn_grp.g_hw_time_stamp', wsh_wms_lpn_grp.g_hw_time_stamp);
170: END IF;
171: --
172: IF ( wsh_wms_lpn_grp.g_hw_time_stamp is null ) THEN
173: wsh_wms_lpn_grp.g_hw_time_stamp := sysdate;

Line 172: IF ( wsh_wms_lpn_grp.g_hw_time_stamp is null ) THEN

168: IF l_debug_on THEN
169: WSH_DEBUG_SV.log(l_module_name,'wsh_wms_lpn_grp.g_hw_time_stamp', wsh_wms_lpn_grp.g_hw_time_stamp);
170: END IF;
171: --
172: IF ( wsh_wms_lpn_grp.g_hw_time_stamp is null ) THEN
173: wsh_wms_lpn_grp.g_hw_time_stamp := sysdate;
174: END IF;
175: --
176: l_current_hw_time_stamp := wsh_wms_lpn_grp.g_hw_time_stamp;

Line 173: wsh_wms_lpn_grp.g_hw_time_stamp := sysdate;

169: WSH_DEBUG_SV.log(l_module_name,'wsh_wms_lpn_grp.g_hw_time_stamp', wsh_wms_lpn_grp.g_hw_time_stamp);
170: END IF;
171: --
172: IF ( wsh_wms_lpn_grp.g_hw_time_stamp is null ) THEN
173: wsh_wms_lpn_grp.g_hw_time_stamp := sysdate;
174: END IF;
175: --
176: l_current_hw_time_stamp := wsh_wms_lpn_grp.g_hw_time_stamp;
177: l_original_call_grp_api := wsh_wms_lpn_grp.g_call_group_api;

Line 176: l_current_hw_time_stamp := wsh_wms_lpn_grp.g_hw_time_stamp;

172: IF ( wsh_wms_lpn_grp.g_hw_time_stamp is null ) THEN
173: wsh_wms_lpn_grp.g_hw_time_stamp := sysdate;
174: END IF;
175: --
176: l_current_hw_time_stamp := wsh_wms_lpn_grp.g_hw_time_stamp;
177: l_original_call_grp_api := wsh_wms_lpn_grp.g_call_group_api;
178:
179: -- This is not required any more as g_hw_time_stamp will always be initialized
180: --IF (l_current_hw_time_stamp IS NULL) THEN

Line 177: l_original_call_grp_api := wsh_wms_lpn_grp.g_call_group_api;

173: wsh_wms_lpn_grp.g_hw_time_stamp := sysdate;
174: END IF;
175: --
176: l_current_hw_time_stamp := wsh_wms_lpn_grp.g_hw_time_stamp;
177: l_original_call_grp_api := wsh_wms_lpn_grp.g_call_group_api;
178:
179: -- This is not required any more as g_hw_time_stamp will always be initialized
180: --IF (l_current_hw_time_stamp IS NULL) THEN
181: --{

Line 240: -- need to set the WSH_WMS_LPN_GRP.g_call_group_api := 'N';

236: END IF;
237: -- This infrastructure is built for future so that when
238: -- WMS is interested in getting this information, we
239: -- need to make a call at this point
240: -- need to set the WSH_WMS_LPN_GRP.g_call_group_api := 'N';
241: -- before calling WMS
242: l_unpack_lpn_id_tbl.delete;
243: i := 1;
244: --

Line 284: -- need to set the WSH_WMS_LPN_GRP.g_call_group_api := 'N';

280: END IF;
281: -- This infrastructure is built for future so that when
282: -- WMS is interested in getting this information, we
283: -- need to make a call at this point
284: -- need to set the WSH_WMS_LPN_GRP.g_call_group_api := 'N';
285: -- before calling WMS
286: l_pack_lpn_id_tbl.delete;
287: i := 1;
288: --

Line 327: -- need to set the WSH_WMS_LPN_GRP.g_call_group_api := 'N';

323: END IF;
324: -- This infrastructure is built for future so that when
325: -- WMS is interested in getting this information, we
326: -- need to make a call at this point
327: -- need to set the WSH_WMS_LPN_GRP.g_call_group_api := 'N';
328: -- before calling WMS
329: l_unasgn_lpn_id_tbl.delete;
330: i := 1;
331: --

Line 371: -- need to set the WSH_WMS_LPN_GRP.g_call_group_api := 'N';

367: END IF;
368: -- This infrastructure is built for future so that when
369: -- WMS is interested in getting this information, we
370: -- need to make a call at this point
371: -- need to set the WSH_WMS_LPN_GRP.g_call_group_api := 'N';
372: -- before calling WMS
373: l_asgn_lpn_id_tbl.delete;
374: i := 1;
375: --

Line 429: WSH_WMS_LPN_GRP.g_call_group_api := 'N';

425: --
426: IF ( l_wms_lpn_tbl.count > 0 ) THEN
427: --{
428: -- setting the globals appropriately before calling WMS.
429: WSH_WMS_LPN_GRP.g_call_group_api := 'N';
430:
431: IF l_debug_on THEN
432: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WMS_CONTAINER_GRP.MODIFY_LPNS',WSH_DEBUG_SV.C_PROC_LEVEL);
433: END IF;

Line 446: WSH_WMS_LPN_GRP.g_call_group_api := l_original_call_grp_api;

442: p_caller => 'WSH_WMS_SYNC_TMP_PKG',
443: p_lpn_table => l_wms_lpn_tbl
444: );
445: -- resetting the values back to the original values
446: WSH_WMS_LPN_GRP.g_call_group_api := l_original_call_grp_api;
447:
448: IF (nvl(wsh_wms_lpn_grp.g_update_to_containers,'N') = 'Y') THEN
449: wsh_wms_lpn_grp.g_update_to_containers := 'N';
450: END IF;

Line 448: IF (nvl(wsh_wms_lpn_grp.g_update_to_containers,'N') = 'Y') THEN

444: );
445: -- resetting the values back to the original values
446: WSH_WMS_LPN_GRP.g_call_group_api := l_original_call_grp_api;
447:
448: IF (nvl(wsh_wms_lpn_grp.g_update_to_containers,'N') = 'Y') THEN
449: wsh_wms_lpn_grp.g_update_to_containers := 'N';
450: END IF;
451:
452: --

Line 449: wsh_wms_lpn_grp.g_update_to_containers := 'N';

445: -- resetting the values back to the original values
446: WSH_WMS_LPN_GRP.g_call_group_api := l_original_call_grp_api;
447:
448: IF (nvl(wsh_wms_lpn_grp.g_update_to_containers,'N') = 'Y') THEN
449: wsh_wms_lpn_grp.g_update_to_containers := 'N';
450: END IF;
451:
452: --
453: -- Debug Statements

Line 469: wsh_wms_lpn_grp.g_hw_time_stamp := wsh_wms_lpn_grp.g_hw_time_stamp + 1/86400;

465:
466: --}
467: END IF;
468:
469: wsh_wms_lpn_grp.g_hw_time_stamp := wsh_wms_lpn_grp.g_hw_time_stamp + 1/86400;
470:
471: IF l_num_errors > 0 THEN
472: RAISE FND_API.G_EXC_ERROR;
473: ELSIF l_num_warnings > 0 THEN

Line 489: WSH_WMS_LPN_GRP.g_call_group_api := l_original_call_grp_api;

485: EXCEPTION
486: --{
487: WHEN FND_API.G_EXC_ERROR THEN
488: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
489: WSH_WMS_LPN_GRP.g_call_group_api := l_original_call_grp_api;
490: IF (nvl(wsh_wms_lpn_grp.g_update_to_containers,'N') = 'Y') THEN
491: wsh_wms_lpn_grp.g_update_to_containers := 'N';
492: END IF;
493: --

Line 490: IF (nvl(wsh_wms_lpn_grp.g_update_to_containers,'N') = 'Y') THEN

486: --{
487: WHEN FND_API.G_EXC_ERROR THEN
488: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
489: WSH_WMS_LPN_GRP.g_call_group_api := l_original_call_grp_api;
490: IF (nvl(wsh_wms_lpn_grp.g_update_to_containers,'N') = 'Y') THEN
491: wsh_wms_lpn_grp.g_update_to_containers := 'N';
492: END IF;
493: --
494: --

Line 491: wsh_wms_lpn_grp.g_update_to_containers := 'N';

487: WHEN FND_API.G_EXC_ERROR THEN
488: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
489: WSH_WMS_LPN_GRP.g_call_group_api := l_original_call_grp_api;
490: IF (nvl(wsh_wms_lpn_grp.g_update_to_containers,'N') = 'Y') THEN
491: wsh_wms_lpn_grp.g_update_to_containers := 'N';
492: END IF;
493: --
494: --
495: --

Line 505: WSH_WMS_LPN_GRP.g_call_group_api := l_original_call_grp_api;

501: END IF;
502: --
503: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
504: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
505: WSH_WMS_LPN_GRP.g_call_group_api := l_original_call_grp_api;
506: IF (nvl(wsh_wms_lpn_grp.g_update_to_containers,'N') = 'Y') THEN
507: wsh_wms_lpn_grp.g_update_to_containers := 'N';
508: END IF;
509: --

Line 506: IF (nvl(wsh_wms_lpn_grp.g_update_to_containers,'N') = 'Y') THEN

502: --
503: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
504: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
505: WSH_WMS_LPN_GRP.g_call_group_api := l_original_call_grp_api;
506: IF (nvl(wsh_wms_lpn_grp.g_update_to_containers,'N') = 'Y') THEN
507: wsh_wms_lpn_grp.g_update_to_containers := 'N';
508: END IF;
509: --
510: --

Line 507: wsh_wms_lpn_grp.g_update_to_containers := 'N';

503: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
504: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
505: WSH_WMS_LPN_GRP.g_call_group_api := l_original_call_grp_api;
506: IF (nvl(wsh_wms_lpn_grp.g_update_to_containers,'N') = 'Y') THEN
507: wsh_wms_lpn_grp.g_update_to_containers := 'N';
508: END IF;
509: --
510: --
511: --

Line 522: WSH_WMS_LPN_GRP.g_call_group_api := l_original_call_grp_api;

518: --
519: WHEN OTHERS THEN
520: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
521: wsh_util_core.default_handler('WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_module_name);
522: WSH_WMS_LPN_GRP.g_call_group_api := l_original_call_grp_api;
523: IF (nvl(wsh_wms_lpn_grp.g_update_to_containers,'N') = 'Y') THEN
524: wsh_wms_lpn_grp.g_update_to_containers := 'N';
525: END IF;
526: --

Line 523: IF (nvl(wsh_wms_lpn_grp.g_update_to_containers,'N') = 'Y') THEN

519: WHEN OTHERS THEN
520: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
521: wsh_util_core.default_handler('WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_module_name);
522: WSH_WMS_LPN_GRP.g_call_group_api := l_original_call_grp_api;
523: IF (nvl(wsh_wms_lpn_grp.g_update_to_containers,'N') = 'Y') THEN
524: wsh_wms_lpn_grp.g_update_to_containers := 'N';
525: END IF;
526: --
527: -- Debug Statements

Line 524: wsh_wms_lpn_grp.g_update_to_containers := 'N';

520: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
521: wsh_util_core.default_handler('WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_module_name);
522: WSH_WMS_LPN_GRP.g_call_group_api := l_original_call_grp_api;
523: IF (nvl(wsh_wms_lpn_grp.g_update_to_containers,'N') = 'Y') THEN
524: wsh_wms_lpn_grp.g_update_to_containers := 'N';
525: END IF;
526: --
527: -- Debug Statements
528: --

Line 610: IF ( wsh_wms_lpn_grp.g_hw_time_stamp is null ) THEN

606: --
607: -- Setting the return status in the begining
608: x_return_status := wsh_util_core.g_ret_sts_success;
609: --
610: IF ( wsh_wms_lpn_grp.g_hw_time_stamp is null ) THEN
611: wsh_wms_lpn_grp.g_hw_time_stamp := sysdate;
612: END IF;
613:
614: l_current_hw_time_stamp := wsh_wms_lpn_grp.g_hw_time_stamp;

Line 611: wsh_wms_lpn_grp.g_hw_time_stamp := sysdate;

607: -- Setting the return status in the begining
608: x_return_status := wsh_util_core.g_ret_sts_success;
609: --
610: IF ( wsh_wms_lpn_grp.g_hw_time_stamp is null ) THEN
611: wsh_wms_lpn_grp.g_hw_time_stamp := sysdate;
612: END IF;
613:
614: l_current_hw_time_stamp := wsh_wms_lpn_grp.g_hw_time_stamp;
615: l_original_call_grp_api := wsh_wms_lpn_grp.g_call_group_api;

Line 614: l_current_hw_time_stamp := wsh_wms_lpn_grp.g_hw_time_stamp;

610: IF ( wsh_wms_lpn_grp.g_hw_time_stamp is null ) THEN
611: wsh_wms_lpn_grp.g_hw_time_stamp := sysdate;
612: END IF;
613:
614: l_current_hw_time_stamp := wsh_wms_lpn_grp.g_hw_time_stamp;
615: l_original_call_grp_api := wsh_wms_lpn_grp.g_call_group_api;
616:
617: IF l_debug_on THEN
618: WSH_DEBUG_SV.log(l_module_name,'wsh_wms_lpn_grp.g_hw_time_stamp', wsh_wms_lpn_grp.g_hw_time_stamp);

Line 615: l_original_call_grp_api := wsh_wms_lpn_grp.g_call_group_api;

611: wsh_wms_lpn_grp.g_hw_time_stamp := sysdate;
612: END IF;
613:
614: l_current_hw_time_stamp := wsh_wms_lpn_grp.g_hw_time_stamp;
615: l_original_call_grp_api := wsh_wms_lpn_grp.g_call_group_api;
616:
617: IF l_debug_on THEN
618: WSH_DEBUG_SV.log(l_module_name,'wsh_wms_lpn_grp.g_hw_time_stamp', wsh_wms_lpn_grp.g_hw_time_stamp);
619: WSH_DEBUG_SV.log(l_module_name,'l_original_call_grp_api', l_original_call_grp_api);

Line 618: WSH_DEBUG_SV.log(l_module_name,'wsh_wms_lpn_grp.g_hw_time_stamp', wsh_wms_lpn_grp.g_hw_time_stamp);

614: l_current_hw_time_stamp := wsh_wms_lpn_grp.g_hw_time_stamp;
615: l_original_call_grp_api := wsh_wms_lpn_grp.g_call_group_api;
616:
617: IF l_debug_on THEN
618: WSH_DEBUG_SV.log(l_module_name,'wsh_wms_lpn_grp.g_hw_time_stamp', wsh_wms_lpn_grp.g_hw_time_stamp);
619: WSH_DEBUG_SV.log(l_module_name,'l_original_call_grp_api', l_original_call_grp_api);
620: END IF;
621: --
622: i := 1;

Line 641: WSH_WMS_LPN_GRP.g_call_group_api := 'N';

637: IF ( l_wms_lpn_tbl.count > 0
638: AND l_loopCounter > 1 AND l_call_level <> l_prev_call_level) THEN
639: --{
640: -- setting the globals appropriately before calling WMS.
641: WSH_WMS_LPN_GRP.g_call_group_api := 'N';
642:
643: IF l_debug_on THEN
644: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WMS_CONTAINER_GRP.MODIFY_LPNS',WSH_DEBUG_SV.C_PROC_LEVEL);
645: END IF;

Line 658: WSH_WMS_LPN_GRP.g_call_group_api := l_original_call_grp_api;

654: p_caller => 'WSH_WMS_SYNC_TMP_PKG',
655: p_lpn_table => l_wms_lpn_tbl
656: );
657: -- resetting the values back to the original values
658: WSH_WMS_LPN_GRP.g_call_group_api := l_original_call_grp_api;
659:
660: IF (nvl(wsh_wms_lpn_grp.g_update_to_containers,'N') = 'Y') THEN
661: wsh_wms_lpn_grp.g_update_to_containers := 'N';
662: END IF;

Line 660: IF (nvl(wsh_wms_lpn_grp.g_update_to_containers,'N') = 'Y') THEN

656: );
657: -- resetting the values back to the original values
658: WSH_WMS_LPN_GRP.g_call_group_api := l_original_call_grp_api;
659:
660: IF (nvl(wsh_wms_lpn_grp.g_update_to_containers,'N') = 'Y') THEN
661: wsh_wms_lpn_grp.g_update_to_containers := 'N';
662: END IF;
663:
664: --

Line 661: wsh_wms_lpn_grp.g_update_to_containers := 'N';

657: -- resetting the values back to the original values
658: WSH_WMS_LPN_GRP.g_call_group_api := l_original_call_grp_api;
659:
660: IF (nvl(wsh_wms_lpn_grp.g_update_to_containers,'N') = 'Y') THEN
661: wsh_wms_lpn_grp.g_update_to_containers := 'N';
662: END IF;
663:
664: --
665: -- Debug Statements

Line 719: WSH_WMS_LPN_GRP.g_call_group_api := 'N';

715: --
716: IF ( l_wms_lpn_tbl.count > 0 ) THEN
717: --{
718: -- setting the globals appropriately before calling WMS.
719: WSH_WMS_LPN_GRP.g_call_group_api := 'N';
720:
721: IF l_debug_on THEN
722: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WMS_CONTAINER_GRP.MODIFY_LPNS',WSH_DEBUG_SV.C_PROC_LEVEL);
723: END IF;

Line 736: WSH_WMS_LPN_GRP.g_call_group_api := l_original_call_grp_api;

732: p_caller => 'WSH_WMS_SYNC_TMP_PKG',
733: p_lpn_table => l_wms_lpn_tbl
734: );
735: -- resetting the values back to the original values
736: WSH_WMS_LPN_GRP.g_call_group_api := l_original_call_grp_api;
737:
738: IF (nvl(wsh_wms_lpn_grp.g_update_to_containers,'N') = 'Y') THEN
739: wsh_wms_lpn_grp.g_update_to_containers := 'N';
740: END IF;

Line 738: IF (nvl(wsh_wms_lpn_grp.g_update_to_containers,'N') = 'Y') THEN

734: );
735: -- resetting the values back to the original values
736: WSH_WMS_LPN_GRP.g_call_group_api := l_original_call_grp_api;
737:
738: IF (nvl(wsh_wms_lpn_grp.g_update_to_containers,'N') = 'Y') THEN
739: wsh_wms_lpn_grp.g_update_to_containers := 'N';
740: END IF;
741:
742: --

Line 739: wsh_wms_lpn_grp.g_update_to_containers := 'N';

735: -- resetting the values back to the original values
736: WSH_WMS_LPN_GRP.g_call_group_api := l_original_call_grp_api;
737:
738: IF (nvl(wsh_wms_lpn_grp.g_update_to_containers,'N') = 'Y') THEN
739: wsh_wms_lpn_grp.g_update_to_containers := 'N';
740: END IF;
741:
742: --
743: -- Debug Statements

Line 759: wsh_wms_lpn_grp.g_hw_time_stamp := wsh_wms_lpn_grp.g_hw_time_stamp + 1/86400;

755: --}
756: END IF;
757:
758:
759: wsh_wms_lpn_grp.g_hw_time_stamp := wsh_wms_lpn_grp.g_hw_time_stamp + 1/86400;
760:
761: IF l_num_errors > 0 THEN
762: RAISE FND_API.G_EXC_ERROR;
763: ELSIF l_num_warnings > 0 THEN

Line 779: WSH_WMS_LPN_GRP.g_call_group_api := l_original_call_grp_api;

775: EXCEPTION
776: --{
777: WHEN FND_API.G_EXC_ERROR THEN
778: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
779: WSH_WMS_LPN_GRP.g_call_group_api := l_original_call_grp_api;
780: IF (nvl(wsh_wms_lpn_grp.g_update_to_containers,'N') = 'Y') THEN
781: wsh_wms_lpn_grp.g_update_to_containers := 'N';
782: END IF;
783: --

Line 780: IF (nvl(wsh_wms_lpn_grp.g_update_to_containers,'N') = 'Y') THEN

776: --{
777: WHEN FND_API.G_EXC_ERROR THEN
778: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
779: WSH_WMS_LPN_GRP.g_call_group_api := l_original_call_grp_api;
780: IF (nvl(wsh_wms_lpn_grp.g_update_to_containers,'N') = 'Y') THEN
781: wsh_wms_lpn_grp.g_update_to_containers := 'N';
782: END IF;
783: --
784: --

Line 781: wsh_wms_lpn_grp.g_update_to_containers := 'N';

777: WHEN FND_API.G_EXC_ERROR THEN
778: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
779: WSH_WMS_LPN_GRP.g_call_group_api := l_original_call_grp_api;
780: IF (nvl(wsh_wms_lpn_grp.g_update_to_containers,'N') = 'Y') THEN
781: wsh_wms_lpn_grp.g_update_to_containers := 'N';
782: END IF;
783: --
784: --
785: --

Line 795: WSH_WMS_LPN_GRP.g_call_group_api := l_original_call_grp_api;

791: END IF;
792: --
793: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
794: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
795: WSH_WMS_LPN_GRP.g_call_group_api := l_original_call_grp_api;
796: IF (nvl(wsh_wms_lpn_grp.g_update_to_containers,'N') = 'Y') THEN
797: wsh_wms_lpn_grp.g_update_to_containers := 'N';
798: END IF;
799: --

Line 796: IF (nvl(wsh_wms_lpn_grp.g_update_to_containers,'N') = 'Y') THEN

792: --
793: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
794: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
795: WSH_WMS_LPN_GRP.g_call_group_api := l_original_call_grp_api;
796: IF (nvl(wsh_wms_lpn_grp.g_update_to_containers,'N') = 'Y') THEN
797: wsh_wms_lpn_grp.g_update_to_containers := 'N';
798: END IF;
799: --
800: --

Line 797: wsh_wms_lpn_grp.g_update_to_containers := 'N';

793: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
794: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
795: WSH_WMS_LPN_GRP.g_call_group_api := l_original_call_grp_api;
796: IF (nvl(wsh_wms_lpn_grp.g_update_to_containers,'N') = 'Y') THEN
797: wsh_wms_lpn_grp.g_update_to_containers := 'N';
798: END IF;
799: --
800: --
801: --

Line 812: WSH_WMS_LPN_GRP.g_call_group_api := l_original_call_grp_api;

808: --
809: WHEN OTHERS THEN
810: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
811: wsh_util_core.default_handler('WSH_LPN_SYNC_COMM_PKG.SYNC_PRORATED_LPNS_TO_WMS',l_module_name);
812: WSH_WMS_LPN_GRP.g_call_group_api := l_original_call_grp_api;
813: IF (nvl(wsh_wms_lpn_grp.g_update_to_containers,'N') = 'Y') THEN
814: wsh_wms_lpn_grp.g_update_to_containers := 'N';
815: END IF;
816: --

Line 813: IF (nvl(wsh_wms_lpn_grp.g_update_to_containers,'N') = 'Y') THEN

809: WHEN OTHERS THEN
810: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
811: wsh_util_core.default_handler('WSH_LPN_SYNC_COMM_PKG.SYNC_PRORATED_LPNS_TO_WMS',l_module_name);
812: WSH_WMS_LPN_GRP.g_call_group_api := l_original_call_grp_api;
813: IF (nvl(wsh_wms_lpn_grp.g_update_to_containers,'N') = 'Y') THEN
814: wsh_wms_lpn_grp.g_update_to_containers := 'N';
815: END IF;
816: --
817: -- Debug Statements

Line 814: wsh_wms_lpn_grp.g_update_to_containers := 'N';

810: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
811: wsh_util_core.default_handler('WSH_LPN_SYNC_COMM_PKG.SYNC_PRORATED_LPNS_TO_WMS',l_module_name);
812: WSH_WMS_LPN_GRP.g_call_group_api := l_original_call_grp_api;
813: IF (nvl(wsh_wms_lpn_grp.g_update_to_containers,'N') = 'Y') THEN
814: wsh_wms_lpn_grp.g_update_to_containers := 'N';
815: END IF;
816: --
817: -- Debug Statements
818: --