DBA Data[Home] [Help]

APPS.WSH_DELIVERY_AUTOCREATE dependencies on WSH_WMS_LPN_GRP

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

2542: END IF;
2543:
2544: -- LPN CONV. rv
2545: --
2546: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y' THEN
2547: --{
2548:
2549: IF l_debug_on THEN
2550: 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 2598: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y' THEN

2594: --
2595: FND_MESSAGE.SET_NAME('WSH','WSH_AUTOCREATE_DEL_ERROR');
2596: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2597: wsh_util_core.add_message(x_return_status);
2598: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y' THEN
2599: --{
2600: --
2601: IF l_debug_on THEN
2602: 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 2640: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y' THEN

2636: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2637: wsh_util_core.add_message(x_return_status);
2638: --
2639: -- LPN CONV. rv
2640: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y' THEN
2641: --{
2642: IF l_debug_on THEN
2643: 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);
2644: END IF;

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

2693:
2694: l_error_code := SQLCODE;
2695: l_error_text := SQLERRM;
2696: --
2697: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y' THEN
2698: --{
2699: IF l_debug_on THEN
2700: 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);
2701: END IF;

Line 3337: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

3333: WSH_DEBUG_SV.logmsg(l_module_name, 'UPDATED '||SQL%ROWCOUNT||' RECORDS IN WSH_DELIVERY_DETAILS' );
3334: END IF;
3335: --
3336: -- LPN CONV. rv
3337: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
3338: AND l_del_det_id_tbl.count > 0
3339: THEN
3340: --{
3341: --

Line 3388: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

3384: wsh_debug_sv.LOG(l_module_name, 'Count of l_sync_tmp_inv_recTbl', l_sync_tmp_inv_recTbl.delivery_detail_id_tbl.count);
3385: END IF;
3386: --
3387: --
3388: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
3389: THEN
3390: --{
3391: --
3392: l_operation_type := 'UPDATE';

Line 3394: IF ( WSH_WMS_LPN_GRP.GK_WMS_UPD_GRP

3390: --{
3391: --
3392: l_operation_type := 'UPDATE';
3393: --
3394: IF ( WSH_WMS_LPN_GRP.GK_WMS_UPD_GRP
3395: OR WSH_WMS_LPN_GRP.GK_WMS_UPD_WV
3396: OR WSH_WMS_LPN_GRP.GK_WMS_UPD_FILL
3397: )
3398: AND l_sync_tmp_wms_recTbl.delivery_detail_id_tbl.count > 0

Line 3395: OR WSH_WMS_LPN_GRP.GK_WMS_UPD_WV

3391: --
3392: l_operation_type := 'UPDATE';
3393: --
3394: IF ( WSH_WMS_LPN_GRP.GK_WMS_UPD_GRP
3395: OR WSH_WMS_LPN_GRP.GK_WMS_UPD_WV
3396: OR WSH_WMS_LPN_GRP.GK_WMS_UPD_FILL
3397: )
3398: AND l_sync_tmp_wms_recTbl.delivery_detail_id_tbl.count > 0
3399: THEN

Line 3396: OR WSH_WMS_LPN_GRP.GK_WMS_UPD_FILL

3392: l_operation_type := 'UPDATE';
3393: --
3394: IF ( WSH_WMS_LPN_GRP.GK_WMS_UPD_GRP
3395: OR WSH_WMS_LPN_GRP.GK_WMS_UPD_WV
3396: OR WSH_WMS_LPN_GRP.GK_WMS_UPD_FILL
3397: )
3398: AND l_sync_tmp_wms_recTbl.delivery_detail_id_tbl.count > 0
3399: THEN
3400: --{

Line 3424: ELSIF ( WSH_WMS_LPN_GRP.GK_INV_UPD_GRP

3420: x_num_warnings => l_num_warnings,
3421: x_num_errors => l_num_errors
3422: );
3423: --}
3424: ELSIF ( WSH_WMS_LPN_GRP.GK_INV_UPD_GRP
3425: OR WSH_WMS_LPN_GRP.GK_INV_UPD_WV
3426: OR WSH_WMS_LPN_GRP.GK_INV_UPD_FILL
3427: )
3428: AND l_sync_tmp_inv_recTbl.delivery_detail_id_tbl.count > 0

Line 3425: OR WSH_WMS_LPN_GRP.GK_INV_UPD_WV

3421: x_num_errors => l_num_errors
3422: );
3423: --}
3424: ELSIF ( WSH_WMS_LPN_GRP.GK_INV_UPD_GRP
3425: OR WSH_WMS_LPN_GRP.GK_INV_UPD_WV
3426: OR WSH_WMS_LPN_GRP.GK_INV_UPD_FILL
3427: )
3428: AND l_sync_tmp_inv_recTbl.delivery_detail_id_tbl.count > 0
3429: THEN

Line 3426: OR WSH_WMS_LPN_GRP.GK_INV_UPD_FILL

3422: );
3423: --}
3424: ELSIF ( WSH_WMS_LPN_GRP.GK_INV_UPD_GRP
3425: OR WSH_WMS_LPN_GRP.GK_INV_UPD_WV
3426: OR WSH_WMS_LPN_GRP.GK_INV_UPD_FILL
3427: )
3428: AND l_sync_tmp_inv_recTbl.delivery_detail_id_tbl.count > 0
3429: THEN
3430: --{

Line 3462: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

3458: --
3459: -- Now, we need to again call the merge APIs for 'PRIOR' for the same
3460: -- set of delivery detail ids
3461: --
3462: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
3463: THEN
3464: --{
3465: --
3466: l_operation_type := 'PRIOR';

Line 3469: IF ( WSH_WMS_LPN_GRP.GK_WMS_UNPACK

3465: --
3466: l_operation_type := 'PRIOR';
3467: l_sync_tmp_inv_recTbl.operation_type_tbl(1) := 'PRIOR';
3468: --
3469: IF ( WSH_WMS_LPN_GRP.GK_WMS_UNPACK
3470: OR WSH_WMS_LPN_GRP.GK_WMS_UNASSIGN_DLVY
3471: )
3472: AND l_sync_tmp_wms_recTbl.delivery_detail_id_tbl.count > 0
3473: THEN

Line 3470: OR WSH_WMS_LPN_GRP.GK_WMS_UNASSIGN_DLVY

3466: l_operation_type := 'PRIOR';
3467: l_sync_tmp_inv_recTbl.operation_type_tbl(1) := 'PRIOR';
3468: --
3469: IF ( WSH_WMS_LPN_GRP.GK_WMS_UNPACK
3470: OR WSH_WMS_LPN_GRP.GK_WMS_UNASSIGN_DLVY
3471: )
3472: AND l_sync_tmp_wms_recTbl.delivery_detail_id_tbl.count > 0
3473: THEN
3474: --{

Line 3498: ELSIF ( WSH_WMS_LPN_GRP.GK_INV_UNPACK

3494: x_num_warnings => l_num_warnings,
3495: x_num_errors => l_num_errors
3496: );
3497: --}
3498: ELSIF ( WSH_WMS_LPN_GRP.GK_INV_UNPACK
3499: OR WSH_WMS_LPN_GRP.GK_INV_UNASSIGN_DLVY
3500: )
3501: AND l_sync_tmp_inv_recTbl.delivery_detail_id_tbl.count > 0
3502: THEN

Line 3499: OR WSH_WMS_LPN_GRP.GK_INV_UNASSIGN_DLVY

3495: x_num_errors => l_num_errors
3496: );
3497: --}
3498: ELSIF ( WSH_WMS_LPN_GRP.GK_INV_UNPACK
3499: OR WSH_WMS_LPN_GRP.GK_INV_UNASSIGN_DLVY
3500: )
3501: AND l_sync_tmp_inv_recTbl.delivery_detail_id_tbl.count > 0
3502: THEN
3503: --{

Line 3621: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

3617: END IF;
3618:
3619: -- LPN CONV. rv
3620: --
3621: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
3622: THEN
3623: --{
3624:
3625: IF l_debug_on THEN

Line 3686: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

3682: IF l_debug_on THEN
3683: 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);
3684: END IF;
3685: --
3686: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
3687: THEN
3688: --{
3689: IF l_debug_on THEN
3690: 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 3724: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

3720: IF l_debug_on THEN
3721: 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);
3722: END IF;
3723: --
3724: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
3725: THEN
3726: --{
3727:
3728: IF l_debug_on THEN

Line 3762: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

3758: IF l_debug_on THEN
3759: 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);
3760: END IF;
3761: --
3762: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
3763: THEN
3764: --{
3765: IF l_debug_on THEN
3766: 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);