DBA Data[Home] [Help]

APPS.WSH_DELIVERY_AUTOCREATE dependencies on WSH_WMS_LPN_GRP

Line 2796: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y' THEN

2792: END IF;
2793:
2794: -- LPN CONV. rv
2795: --
2796: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y' THEN
2797: --{
2798:
2799: IF l_debug_on THEN
2800: 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);

Line 2848: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y' THEN

2844: --
2845: FND_MESSAGE.SET_NAME('WSH','WSH_AUTOCREATE_DEL_ERROR');
2846: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2847: wsh_util_core.add_message(x_return_status);
2848: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y' THEN
2849: --{
2850: --
2851: IF l_debug_on THEN
2852: 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);

Line 2890: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y' THEN

2886: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2887: wsh_util_core.add_message(x_return_status);
2888: --
2889: -- LPN CONV. rv
2890: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y' THEN
2891: --{
2892: IF l_debug_on THEN
2893: 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);
2894: END IF;

Line 2947: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y' THEN

2943:
2944: l_error_code := SQLCODE;
2945: l_error_text := SQLERRM;
2946: --
2947: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y' THEN
2948: --{
2949: IF l_debug_on THEN
2950: 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);
2951: END IF;

Line 3596: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

3592: WSH_DEBUG_SV.logmsg(l_module_name, 'UPDATED '||SQL%ROWCOUNT||' RECORDS IN WSH_DELIVERY_DETAILS' );
3593: END IF;
3594: --
3595: -- LPN CONV. rv
3596: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
3597: AND l_del_det_id_tbl.count > 0
3598: THEN
3599: --{
3600: --

Line 3647: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

3643: wsh_debug_sv.LOG(l_module_name, 'Count of l_sync_tmp_inv_recTbl', l_sync_tmp_inv_recTbl.delivery_detail_id_tbl.count);
3644: END IF;
3645: --
3646: --
3647: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
3648: THEN
3649: --{
3650: --
3651: l_operation_type := 'UPDATE';

Line 3653: IF ( WSH_WMS_LPN_GRP.GK_WMS_UPD_GRP

3649: --{
3650: --
3651: l_operation_type := 'UPDATE';
3652: --
3653: IF ( WSH_WMS_LPN_GRP.GK_WMS_UPD_GRP
3654: OR WSH_WMS_LPN_GRP.GK_WMS_UPD_WV
3655: OR WSH_WMS_LPN_GRP.GK_WMS_UPD_FILL
3656: )
3657: AND l_sync_tmp_wms_recTbl.delivery_detail_id_tbl.count > 0

Line 3654: OR WSH_WMS_LPN_GRP.GK_WMS_UPD_WV

3650: --
3651: l_operation_type := 'UPDATE';
3652: --
3653: IF ( WSH_WMS_LPN_GRP.GK_WMS_UPD_GRP
3654: OR WSH_WMS_LPN_GRP.GK_WMS_UPD_WV
3655: OR WSH_WMS_LPN_GRP.GK_WMS_UPD_FILL
3656: )
3657: AND l_sync_tmp_wms_recTbl.delivery_detail_id_tbl.count > 0
3658: THEN

Line 3655: OR WSH_WMS_LPN_GRP.GK_WMS_UPD_FILL

3651: l_operation_type := 'UPDATE';
3652: --
3653: IF ( WSH_WMS_LPN_GRP.GK_WMS_UPD_GRP
3654: OR WSH_WMS_LPN_GRP.GK_WMS_UPD_WV
3655: OR WSH_WMS_LPN_GRP.GK_WMS_UPD_FILL
3656: )
3657: AND l_sync_tmp_wms_recTbl.delivery_detail_id_tbl.count > 0
3658: THEN
3659: --{

Line 3683: ELSIF ( WSH_WMS_LPN_GRP.GK_INV_UPD_GRP

3679: x_num_warnings => l_num_warnings,
3680: x_num_errors => l_num_errors
3681: );
3682: --}
3683: ELSIF ( WSH_WMS_LPN_GRP.GK_INV_UPD_GRP
3684: OR WSH_WMS_LPN_GRP.GK_INV_UPD_WV
3685: OR WSH_WMS_LPN_GRP.GK_INV_UPD_FILL
3686: )
3687: AND l_sync_tmp_inv_recTbl.delivery_detail_id_tbl.count > 0

Line 3684: OR WSH_WMS_LPN_GRP.GK_INV_UPD_WV

3680: x_num_errors => l_num_errors
3681: );
3682: --}
3683: ELSIF ( WSH_WMS_LPN_GRP.GK_INV_UPD_GRP
3684: OR WSH_WMS_LPN_GRP.GK_INV_UPD_WV
3685: OR WSH_WMS_LPN_GRP.GK_INV_UPD_FILL
3686: )
3687: AND l_sync_tmp_inv_recTbl.delivery_detail_id_tbl.count > 0
3688: THEN

Line 3685: OR WSH_WMS_LPN_GRP.GK_INV_UPD_FILL

3681: );
3682: --}
3683: ELSIF ( WSH_WMS_LPN_GRP.GK_INV_UPD_GRP
3684: OR WSH_WMS_LPN_GRP.GK_INV_UPD_WV
3685: OR WSH_WMS_LPN_GRP.GK_INV_UPD_FILL
3686: )
3687: AND l_sync_tmp_inv_recTbl.delivery_detail_id_tbl.count > 0
3688: THEN
3689: --{

Line 3721: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

3717: --
3718: -- Now, we need to again call the merge APIs for 'PRIOR' for the same
3719: -- set of delivery detail ids
3720: --
3721: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
3722: THEN
3723: --{
3724: --
3725: l_operation_type := 'PRIOR';

Line 3728: IF ( WSH_WMS_LPN_GRP.GK_WMS_UNPACK

3724: --
3725: l_operation_type := 'PRIOR';
3726: l_sync_tmp_inv_recTbl.operation_type_tbl(1) := 'PRIOR';
3727: --
3728: IF ( WSH_WMS_LPN_GRP.GK_WMS_UNPACK
3729: OR WSH_WMS_LPN_GRP.GK_WMS_UNASSIGN_DLVY
3730: )
3731: AND l_sync_tmp_wms_recTbl.delivery_detail_id_tbl.count > 0
3732: THEN

Line 3729: OR WSH_WMS_LPN_GRP.GK_WMS_UNASSIGN_DLVY

3725: l_operation_type := 'PRIOR';
3726: l_sync_tmp_inv_recTbl.operation_type_tbl(1) := 'PRIOR';
3727: --
3728: IF ( WSH_WMS_LPN_GRP.GK_WMS_UNPACK
3729: OR WSH_WMS_LPN_GRP.GK_WMS_UNASSIGN_DLVY
3730: )
3731: AND l_sync_tmp_wms_recTbl.delivery_detail_id_tbl.count > 0
3732: THEN
3733: --{

Line 3757: ELSIF ( WSH_WMS_LPN_GRP.GK_INV_UNPACK

3753: x_num_warnings => l_num_warnings,
3754: x_num_errors => l_num_errors
3755: );
3756: --}
3757: ELSIF ( WSH_WMS_LPN_GRP.GK_INV_UNPACK
3758: OR WSH_WMS_LPN_GRP.GK_INV_UNASSIGN_DLVY
3759: )
3760: AND l_sync_tmp_inv_recTbl.delivery_detail_id_tbl.count > 0
3761: THEN

Line 3758: OR WSH_WMS_LPN_GRP.GK_INV_UNASSIGN_DLVY

3754: x_num_errors => l_num_errors
3755: );
3756: --}
3757: ELSIF ( WSH_WMS_LPN_GRP.GK_INV_UNPACK
3758: OR WSH_WMS_LPN_GRP.GK_INV_UNASSIGN_DLVY
3759: )
3760: AND l_sync_tmp_inv_recTbl.delivery_detail_id_tbl.count > 0
3761: THEN
3762: --{

Line 3880: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

3876: END IF;
3877:
3878: -- LPN CONV. rv
3879: --
3880: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
3881: THEN
3882: --{
3883:
3884: IF l_debug_on THEN

Line 3945: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

3941: IF l_debug_on THEN
3942: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS FROM FND_API.G_EXC_ERROR',WSH_DEBUG_SV.C_PROC_LEVEL);
3943: END IF;
3944: --
3945: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
3946: THEN
3947: --{
3948: IF l_debug_on THEN
3949: 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);

Line 3983: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

3979: IF l_debug_on THEN
3980: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS FROM FND_API.G_EXC_UNEXPECTED_ERROR',WSH_DEBUG_SV.C_PROC_LEVEL);
3981: END IF;
3982: --
3983: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
3984: THEN
3985: --{
3986:
3987: IF l_debug_on THEN

Line 4021: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

4017: IF l_debug_on THEN
4018: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS FROM WHEN OTHERS',WSH_DEBUG_SV.C_PROC_LEVEL);
4019: END IF;
4020: --
4021: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
4022: THEN
4023: --{
4024: IF l_debug_on THEN
4025: 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);