DBA Data[Home] [Help]

APPS.WSH_WV_UTILS dependencies on WSH_WMS_LPN_GRP

Line 571: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

567: END IF;
568: -- LPN CONV. rv
569: --
570: --
571: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
572: AND l_line_direction IN ('O','IO')
573: AND l_container_flag IN ('Y','C')
574: AND
575: (

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

572: AND l_line_direction IN ('O','IO')
573: AND l_container_flag IN ('Y','C')
574: AND
575: (
576: ((WSH_WMS_LPN_GRP.GK_WMS_UPD_WV or WSH_WMS_LPN_GRP.GK_WMS_UPD_ITEM) and l_wms_org = 'Y')
577: OR
578: ((WSH_WMS_LPN_GRP.GK_INV_UPD_WV or WSH_WMS_LPN_GRP.GK_INV_UPD_ITEM) and l_wms_org = 'N')
579: )
580: THEN

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

574: AND
575: (
576: ((WSH_WMS_LPN_GRP.GK_WMS_UPD_WV or WSH_WMS_LPN_GRP.GK_WMS_UPD_ITEM) and l_wms_org = 'Y')
577: OR
578: ((WSH_WMS_LPN_GRP.GK_INV_UPD_WV or WSH_WMS_LPN_GRP.GK_INV_UPD_ITEM) and l_wms_org = 'N')
579: )
580: THEN
581: --{
582: l_sync_tmp_rec.delivery_detail_id := p_delivery_detail_id;

Line 1475: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

1471: WSH_DEBUG_SV.log(l_module_name,'l_wms_org',l_wms_org);
1472: END IF;
1473: IF l_wms_org = 'Y' THEN --{
1474:
1475: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
1476: AND l_line_direction IN ('O', 'IO') THEN
1477:
1478: IF ( WSH_WMS_LPN_GRP.GK_WMS_UPD_WV) THEN --{
1479: WSH_WMS_LPN_GRP.g_update_to_containers := 'Y';

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

1474:
1475: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
1476: AND l_line_direction IN ('O', 'IO') THEN
1477:
1478: IF ( WSH_WMS_LPN_GRP.GK_WMS_UPD_WV) THEN --{
1479: WSH_WMS_LPN_GRP.g_update_to_containers := 'Y';
1480: END IF; --}
1481: END IF;
1482:

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

1475: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
1476: AND l_line_direction IN ('O', 'IO') THEN
1477:
1478: IF ( WSH_WMS_LPN_GRP.GK_WMS_UPD_WV) THEN --{
1479: WSH_WMS_LPN_GRP.g_update_to_containers := 'Y';
1480: END IF; --}
1481: END IF;
1482:
1483: ELSE --}{

Line 2700: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

2696: END IF;
2697: --
2698: l_wms_org := wsh_util_validate.check_wms_org(l_organization_id);
2699: --
2700: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
2701: AND l_line_direction IN ('O','IO')
2702: AND l_container_flag IN ('Y', 'C')
2703: AND
2704: (

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

2701: AND l_line_direction IN ('O','IO')
2702: AND l_container_flag IN ('Y', 'C')
2703: AND
2704: (
2705: ((WSH_WMS_LPN_GRP.GK_WMS_UPD_WV or WSH_WMS_LPN_GRP.GK_WMS_UPD_ITEM) and l_wms_org = 'Y')
2706: OR
2707: ((WSH_WMS_LPN_GRP.GK_INV_UPD_WV or WSH_WMS_LPN_GRP.GK_INV_UPD_ITEM) and l_wms_org = 'N')
2708: )
2709: THEN

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

2703: AND
2704: (
2705: ((WSH_WMS_LPN_GRP.GK_WMS_UPD_WV or WSH_WMS_LPN_GRP.GK_WMS_UPD_ITEM) and l_wms_org = 'Y')
2706: OR
2707: ((WSH_WMS_LPN_GRP.GK_INV_UPD_WV or WSH_WMS_LPN_GRP.GK_INV_UPD_ITEM) and l_wms_org = 'N')
2708: )
2709: THEN
2710: --{
2711: l_sync_tmp_rec.delivery_detail_id := p_container_instance_id;

Line 4477: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

4473: END IF;
4474: --
4475: l_wms_org := wsh_util_validate.check_wms_org(l_organization_id);
4476: --
4477: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
4478: AND l_line_direction IN ('O','IO')
4479: AND l_cont_flag = 'Y'
4480: AND
4481: (

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

4478: AND l_line_direction IN ('O','IO')
4479: AND l_cont_flag = 'Y'
4480: AND
4481: (
4482: (WSH_WMS_LPN_GRP.GK_WMS_UPD_FILL and l_wms_org = 'Y')
4483: OR
4484: (WSH_WMS_LPN_GRP.GK_INV_UPD_FILL and l_wms_org = 'N')
4485: )
4486: THEN

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

4480: AND
4481: (
4482: (WSH_WMS_LPN_GRP.GK_WMS_UPD_FILL and l_wms_org = 'Y')
4483: OR
4484: (WSH_WMS_LPN_GRP.GK_INV_UPD_FILL and l_wms_org = 'N')
4485: )
4486: THEN
4487: --{
4488: l_sync_tmp_rec.delivery_detail_id := p_container_instance_id;

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

6556: l_num_errors NUMBER := 0;
6557: l_num_warnings NUMBER := 0;
6558: l_debug_on BOOLEAN;
6559:
6560: l_update_to_containers VARCHAR2(2) := WSH_WMS_LPN_GRP.g_update_to_containers;
6561: l_call_group_api VARCHAR2(2) := WSH_WMS_LPN_GRP.g_call_group_api;
6562: l_lpn_in_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_in_rec_type;
6563: l_lpn_out_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_out_rec_type;
6564: l_call_level NUMBER;

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

6557: l_num_warnings NUMBER := 0;
6558: l_debug_on BOOLEAN;
6559:
6560: l_update_to_containers VARCHAR2(2) := WSH_WMS_LPN_GRP.g_update_to_containers;
6561: l_call_group_api VARCHAR2(2) := WSH_WMS_LPN_GRP.g_call_group_api;
6562: l_lpn_in_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_in_rec_type;
6563: l_lpn_out_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_out_rec_type;
6564: l_call_level NUMBER;
6565:

Line 6805: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

6801: l_lpn_tab(l_lpn_count).new_gross_weight := l_new_gross_wt;
6802: l_lpn_tab(l_lpn_count).new_net_weight := l_new_net_wt;
6803:
6804: -- LPN CONV. rv
6805: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
6806: THEN
6807: --{
6808: --
6809: -- need to check the wms org value for each record because the parent LPN

Line 6856: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

6852: wsh_debug_sv.LOG(l_module_name, 'Count of l_sync_tmp_inv_recTbl', l_sync_tmp_inv_recTbl.delivery_detail_id_tbl.count);
6853: END IF;
6854: --
6855: --
6856: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
6857: THEN
6858: --{
6859: IF WSH_WMS_LPN_GRP.GK_WMS_UPD_WV
6860: AND l_sync_tmp_wms_recTbl.delivery_detail_id_tbl.count > 0

Line 6859: IF WSH_WMS_LPN_GRP.GK_WMS_UPD_WV

6855: --
6856: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
6857: THEN
6858: --{
6859: IF WSH_WMS_LPN_GRP.GK_WMS_UPD_WV
6860: AND l_sync_tmp_wms_recTbl.delivery_detail_id_tbl.count > 0
6861: THEN
6862: --{
6863: --

Line 6887: ELSIF WSH_WMS_LPN_GRP.GK_INV_UPD_WV

6883: x_num_warnings => l_num_warnings,
6884: x_num_errors => l_num_errors
6885: );
6886: --}
6887: ELSIF WSH_WMS_LPN_GRP.GK_INV_UPD_WV
6888: AND l_sync_tmp_inv_recTbl.delivery_detail_id_tbl.count > 0
6889: THEN
6890: --{
6891: --

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

6976: --}
6977: END IF;
6978:
6979: IF (p_call_level IS NULL)
6980: AND (WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y')
6981: AND (l_wms_org = 'Y')
6982: THEN --{
6983:
6984: WSH_WMS_LPN_GRP.g_update_to_containers := 'N';

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

6980: AND (WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y')
6981: AND (l_wms_org = 'Y')
6982: THEN --{
6983:
6984: WSH_WMS_LPN_GRP.g_update_to_containers := 'N';
6985: WSH_WMS_LPN_GRP.g_call_group_api := 'N' ;
6986: --call the new API
6987: IF l_debug_on THEN
6988: 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 6985: WSH_WMS_LPN_GRP.g_call_group_api := 'N' ;

6981: AND (l_wms_org = 'Y')
6982: THEN --{
6983:
6984: WSH_WMS_LPN_GRP.g_update_to_containers := 'N';
6985: WSH_WMS_LPN_GRP.g_call_group_api := 'N' ;
6986: --call the new API
6987: IF l_debug_on THEN
6988: 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);
6989: END IF;

Line 7007: WSH_WMS_LPN_GRP.g_call_group_api := l_call_group_api;

7003: p_return_status => l_return_status,
7004: x_num_warnings => l_num_warnings,
7005: x_num_errors => l_num_errors
7006: );
7007: WSH_WMS_LPN_GRP.g_call_group_api := l_call_group_api;
7008: WSH_WMS_LPN_GRP.g_update_to_containers := l_update_to_containers;
7009:
7010: END IF; --}
7011:

Line 7008: WSH_WMS_LPN_GRP.g_update_to_containers := l_update_to_containers;

7004: x_num_warnings => l_num_warnings,
7005: x_num_errors => l_num_errors
7006: );
7007: WSH_WMS_LPN_GRP.g_call_group_api := l_call_group_api;
7008: WSH_WMS_LPN_GRP.g_update_to_containers := l_update_to_containers;
7009:
7010: END IF; --}
7011:
7012: IF l_num_errors > 0

Line 7032: WSH_WMS_LPN_GRP.g_call_group_api := l_call_group_api;

7028: --
7029: EXCEPTION
7030: WHEN OTHERS THEN
7031: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7032: WSH_WMS_LPN_GRP.g_call_group_api := l_call_group_api;
7033: WSH_WMS_LPN_GRP.g_update_to_containers := l_update_to_containers;
7034:
7035: IF immediate_details_del%ISOPEN THEN
7036: CLOSE immediate_details_del;

Line 7033: WSH_WMS_LPN_GRP.g_update_to_containers := l_update_to_containers;

7029: EXCEPTION
7030: WHEN OTHERS THEN
7031: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7032: WSH_WMS_LPN_GRP.g_call_group_api := l_call_group_api;
7033: WSH_WMS_LPN_GRP.g_update_to_containers := l_update_to_containers;
7034:
7035: IF immediate_details_del%ISOPEN THEN
7036: CLOSE immediate_details_del;
7037: END IF;