DBA Data[Home] [Help]

APPS.WSH_WV_UTILS dependencies on WSH_WMS_LPN_GRP

Line 566: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

562: END IF;
563: -- LPN CONV. rv
564: --
565: --
566: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
567: AND l_line_direction IN ('O','IO')
568: AND l_container_flag IN ('Y','C')
569: AND
570: (

Line 571: ((WSH_WMS_LPN_GRP.GK_WMS_UPD_WV or WSH_WMS_LPN_GRP.GK_WMS_UPD_ITEM) and l_wms_org = 'Y')

567: AND l_line_direction IN ('O','IO')
568: AND l_container_flag IN ('Y','C')
569: AND
570: (
571: ((WSH_WMS_LPN_GRP.GK_WMS_UPD_WV or WSH_WMS_LPN_GRP.GK_WMS_UPD_ITEM) and l_wms_org = 'Y')
572: OR
573: ((WSH_WMS_LPN_GRP.GK_INV_UPD_WV or WSH_WMS_LPN_GRP.GK_INV_UPD_ITEM) and l_wms_org = 'N')
574: )
575: THEN

Line 573: ((WSH_WMS_LPN_GRP.GK_INV_UPD_WV or WSH_WMS_LPN_GRP.GK_INV_UPD_ITEM) and l_wms_org = 'N')

569: AND
570: (
571: ((WSH_WMS_LPN_GRP.GK_WMS_UPD_WV or WSH_WMS_LPN_GRP.GK_WMS_UPD_ITEM) and l_wms_org = 'Y')
572: OR
573: ((WSH_WMS_LPN_GRP.GK_INV_UPD_WV or WSH_WMS_LPN_GRP.GK_INV_UPD_ITEM) and l_wms_org = 'N')
574: )
575: THEN
576: --{
577: l_sync_tmp_rec.delivery_detail_id := p_delivery_detail_id;

Line 1462: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

1458: WSH_DEBUG_SV.log(l_module_name,'l_wms_org',l_wms_org);
1459: END IF;
1460: IF l_wms_org = 'Y' THEN --{
1461:
1462: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
1463: AND l_line_direction IN ('O', 'IO') THEN
1464:
1465: IF ( WSH_WMS_LPN_GRP.GK_WMS_UPD_WV) THEN --{
1466: WSH_WMS_LPN_GRP.g_update_to_containers := 'Y';

Line 1465: IF ( WSH_WMS_LPN_GRP.GK_WMS_UPD_WV) THEN --{

1461:
1462: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
1463: AND l_line_direction IN ('O', 'IO') THEN
1464:
1465: IF ( WSH_WMS_LPN_GRP.GK_WMS_UPD_WV) THEN --{
1466: WSH_WMS_LPN_GRP.g_update_to_containers := 'Y';
1467: END IF; --}
1468: END IF;
1469:

Line 1466: WSH_WMS_LPN_GRP.g_update_to_containers := 'Y';

1462: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
1463: AND l_line_direction IN ('O', 'IO') THEN
1464:
1465: IF ( WSH_WMS_LPN_GRP.GK_WMS_UPD_WV) THEN --{
1466: WSH_WMS_LPN_GRP.g_update_to_containers := 'Y';
1467: END IF; --}
1468: END IF;
1469:
1470: ELSE --}{

Line 2687: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

2683: END IF;
2684: --
2685: l_wms_org := wsh_util_validate.check_wms_org(l_organization_id);
2686: --
2687: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
2688: AND l_line_direction IN ('O','IO')
2689: AND l_container_flag IN ('Y', 'C')
2690: AND
2691: (

Line 2692: ((WSH_WMS_LPN_GRP.GK_WMS_UPD_WV or WSH_WMS_LPN_GRP.GK_WMS_UPD_ITEM) and l_wms_org = 'Y')

2688: AND l_line_direction IN ('O','IO')
2689: AND l_container_flag IN ('Y', 'C')
2690: AND
2691: (
2692: ((WSH_WMS_LPN_GRP.GK_WMS_UPD_WV or WSH_WMS_LPN_GRP.GK_WMS_UPD_ITEM) and l_wms_org = 'Y')
2693: OR
2694: ((WSH_WMS_LPN_GRP.GK_INV_UPD_WV or WSH_WMS_LPN_GRP.GK_INV_UPD_ITEM) and l_wms_org = 'N')
2695: )
2696: THEN

Line 2694: ((WSH_WMS_LPN_GRP.GK_INV_UPD_WV or WSH_WMS_LPN_GRP.GK_INV_UPD_ITEM) and l_wms_org = 'N')

2690: AND
2691: (
2692: ((WSH_WMS_LPN_GRP.GK_WMS_UPD_WV or WSH_WMS_LPN_GRP.GK_WMS_UPD_ITEM) and l_wms_org = 'Y')
2693: OR
2694: ((WSH_WMS_LPN_GRP.GK_INV_UPD_WV or WSH_WMS_LPN_GRP.GK_INV_UPD_ITEM) and l_wms_org = 'N')
2695: )
2696: THEN
2697: --{
2698: l_sync_tmp_rec.delivery_detail_id := p_container_instance_id;

Line 4464: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

4460: END IF;
4461: --
4462: l_wms_org := wsh_util_validate.check_wms_org(l_organization_id);
4463: --
4464: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
4465: AND l_line_direction IN ('O','IO')
4466: AND l_cont_flag = 'Y'
4467: AND
4468: (

Line 4469: (WSH_WMS_LPN_GRP.GK_WMS_UPD_FILL and l_wms_org = 'Y')

4465: AND l_line_direction IN ('O','IO')
4466: AND l_cont_flag = 'Y'
4467: AND
4468: (
4469: (WSH_WMS_LPN_GRP.GK_WMS_UPD_FILL and l_wms_org = 'Y')
4470: OR
4471: (WSH_WMS_LPN_GRP.GK_INV_UPD_FILL and l_wms_org = 'N')
4472: )
4473: THEN

Line 4471: (WSH_WMS_LPN_GRP.GK_INV_UPD_FILL and l_wms_org = 'N')

4467: AND
4468: (
4469: (WSH_WMS_LPN_GRP.GK_WMS_UPD_FILL and l_wms_org = 'Y')
4470: OR
4471: (WSH_WMS_LPN_GRP.GK_INV_UPD_FILL and l_wms_org = 'N')
4472: )
4473: THEN
4474: --{
4475: l_sync_tmp_rec.delivery_detail_id := p_container_instance_id;

Line 6528: l_update_to_containers VARCHAR2(2) := WSH_WMS_LPN_GRP.g_update_to_containers;

6524: l_num_errors NUMBER := 0;
6525: l_num_warnings NUMBER := 0;
6526: l_debug_on BOOLEAN;
6527:
6528: l_update_to_containers VARCHAR2(2) := WSH_WMS_LPN_GRP.g_update_to_containers;
6529: l_call_group_api VARCHAR2(2) := WSH_WMS_LPN_GRP.g_call_group_api;
6530: l_lpn_in_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_in_rec_type;
6531: l_lpn_out_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_out_rec_type;
6532: l_call_level NUMBER;

Line 6529: l_call_group_api VARCHAR2(2) := WSH_WMS_LPN_GRP.g_call_group_api;

6525: l_num_warnings NUMBER := 0;
6526: l_debug_on BOOLEAN;
6527:
6528: l_update_to_containers VARCHAR2(2) := WSH_WMS_LPN_GRP.g_update_to_containers;
6529: l_call_group_api VARCHAR2(2) := WSH_WMS_LPN_GRP.g_call_group_api;
6530: l_lpn_in_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_in_rec_type;
6531: l_lpn_out_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_out_rec_type;
6532: l_call_level NUMBER;
6533:

Line 6773: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

6769: l_lpn_tab(l_lpn_count).new_gross_weight := l_new_gross_wt;
6770: l_lpn_tab(l_lpn_count).new_net_weight := l_new_net_wt;
6771:
6772: -- LPN CONV. rv
6773: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
6774: THEN
6775: --{
6776: --
6777: -- need to check the wms org value for each record because the parent LPN

Line 6824: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

6820: wsh_debug_sv.LOG(l_module_name, 'Count of l_sync_tmp_inv_recTbl', l_sync_tmp_inv_recTbl.delivery_detail_id_tbl.count);
6821: END IF;
6822: --
6823: --
6824: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
6825: THEN
6826: --{
6827: IF WSH_WMS_LPN_GRP.GK_WMS_UPD_WV
6828: AND l_sync_tmp_wms_recTbl.delivery_detail_id_tbl.count > 0

Line 6827: IF WSH_WMS_LPN_GRP.GK_WMS_UPD_WV

6823: --
6824: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
6825: THEN
6826: --{
6827: IF WSH_WMS_LPN_GRP.GK_WMS_UPD_WV
6828: AND l_sync_tmp_wms_recTbl.delivery_detail_id_tbl.count > 0
6829: THEN
6830: --{
6831: --

Line 6855: ELSIF WSH_WMS_LPN_GRP.GK_INV_UPD_WV

6851: x_num_warnings => l_num_warnings,
6852: x_num_errors => l_num_errors
6853: );
6854: --}
6855: ELSIF WSH_WMS_LPN_GRP.GK_INV_UPD_WV
6856: AND l_sync_tmp_inv_recTbl.delivery_detail_id_tbl.count > 0
6857: THEN
6858: --{
6859: --

Line 6948: AND (WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y')

6944: --}
6945: END IF;
6946:
6947: IF (p_call_level IS NULL)
6948: AND (WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y')
6949: AND (l_wms_org = 'Y')
6950: THEN --{
6951:
6952: WSH_WMS_LPN_GRP.g_update_to_containers := 'N';

Line 6952: WSH_WMS_LPN_GRP.g_update_to_containers := 'N';

6948: AND (WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y')
6949: AND (l_wms_org = 'Y')
6950: THEN --{
6951:
6952: WSH_WMS_LPN_GRP.g_update_to_containers := 'N';
6953: WSH_WMS_LPN_GRP.g_call_group_api := 'N' ;
6954: --call the new API
6955: IF l_debug_on THEN
6956: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_PRORATED_LPNS_TO_WMS',WSH_DEBUG_SV.C_PROC_LEVEL);

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

6949: AND (l_wms_org = 'Y')
6950: THEN --{
6951:
6952: WSH_WMS_LPN_GRP.g_update_to_containers := 'N';
6953: WSH_WMS_LPN_GRP.g_call_group_api := 'N' ;
6954: --call the new API
6955: IF l_debug_on THEN
6956: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_PRORATED_LPNS_TO_WMS',WSH_DEBUG_SV.C_PROC_LEVEL);
6957: END IF;

Line 6975: WSH_WMS_LPN_GRP.g_call_group_api := l_call_group_api;

6971: p_return_status => l_return_status,
6972: x_num_warnings => l_num_warnings,
6973: x_num_errors => l_num_errors
6974: );
6975: WSH_WMS_LPN_GRP.g_call_group_api := l_call_group_api;
6976: WSH_WMS_LPN_GRP.g_update_to_containers := l_update_to_containers;
6977:
6978: END IF; --}
6979:

Line 6976: WSH_WMS_LPN_GRP.g_update_to_containers := l_update_to_containers;

6972: x_num_warnings => l_num_warnings,
6973: x_num_errors => l_num_errors
6974: );
6975: WSH_WMS_LPN_GRP.g_call_group_api := l_call_group_api;
6976: WSH_WMS_LPN_GRP.g_update_to_containers := l_update_to_containers;
6977:
6978: END IF; --}
6979:
6980: IF l_num_errors > 0

Line 7000: WSH_WMS_LPN_GRP.g_call_group_api := l_call_group_api;

6996: --
6997: EXCEPTION
6998: WHEN OTHERS THEN
6999: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7000: WSH_WMS_LPN_GRP.g_call_group_api := l_call_group_api;
7001: WSH_WMS_LPN_GRP.g_update_to_containers := l_update_to_containers;
7002:
7003: IF immediate_details_del%ISOPEN THEN
7004: CLOSE immediate_details_del;

Line 7001: WSH_WMS_LPN_GRP.g_update_to_containers := l_update_to_containers;

6997: EXCEPTION
6998: WHEN OTHERS THEN
6999: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7000: WSH_WMS_LPN_GRP.g_call_group_api := l_call_group_api;
7001: WSH_WMS_LPN_GRP.g_update_to_containers := l_update_to_containers;
7002:
7003: IF immediate_details_del%ISOPEN THEN
7004: CLOSE immediate_details_del;
7005: END IF;