eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_CONTAINER_ACTIONS dependencies on WSH_WMS_LPN_GRP

Line 846: l_orig_value := WSH_WMS_LPN_GRP.g_call_group_api;

842: WSH_DEBUG_SV.logmsg(l_module_name, 'IN CREATE_CONT_INSTANCE_MULTI ' );
843: END IF;
844: --
845:
846: l_orig_value := WSH_WMS_LPN_GRP.g_call_group_api;
847: l_orig_update_cont_value := WSH_WMS_LPN_GRP.g_update_to_container;
848: l_inventory_item_id := p_cont_item_id;
849:
850: IF p_organization_id IS NULL AND p_lpn_id IS NULL THEN

Line 847: l_orig_update_cont_value := WSH_WMS_LPN_GRP.g_update_to_container;

843: END IF;
844: --
845:
846: l_orig_value := WSH_WMS_LPN_GRP.g_call_group_api;
847: l_orig_update_cont_value := WSH_WMS_LPN_GRP.g_update_to_container;
848: l_inventory_item_id := p_cont_item_id;
849:
850: IF p_organization_id IS NULL AND p_lpn_id IS NULL THEN
851: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_ORG_NULL');

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

861:
862: --lpn conv
863: IF p_lpn_id IS NULL THEN --{
864:
865: WSH_WMS_LPN_GRP.g_call_group_api := 'N';
866: WSH_WMS_LPN_GRP.g_update_to_container := 'N';
867:
868: IF c_wms_code_present = 'Y' THEN --{
869:

Line 866: WSH_WMS_LPN_GRP.g_update_to_container := 'N';

862: --lpn conv
863: IF p_lpn_id IS NULL THEN --{
864:
865: WSH_WMS_LPN_GRP.g_call_group_api := 'N';
866: WSH_WMS_LPN_GRP.g_update_to_container := 'N';
867:
868: IF c_wms_code_present = 'Y' THEN --{
869:
870: IF l_debug_on THEN

Line 901: WSH_WMS_LPN_GRP.g_call_group_api := l_orig_value;

897: x_num_warnings => l_num_warnings,
898: x_num_errors => l_num_errors,
899: p_msg_data => l_msg_data
900: );
901: WSH_WMS_LPN_GRP.g_call_group_api := l_orig_value;
902: WSH_WMS_LPN_GRP.g_update_to_container := l_orig_update_cont_value;
903:
904: j := 1;
905: i := l_lpn_tbl.first;

Line 902: WSH_WMS_LPN_GRP.g_update_to_container := l_orig_update_cont_value;

898: x_num_errors => l_num_errors,
899: p_msg_data => l_msg_data
900: );
901: WSH_WMS_LPN_GRP.g_call_group_api := l_orig_value;
902: WSH_WMS_LPN_GRP.g_update_to_container := l_orig_update_cont_value;
903:
904: j := 1;
905: i := l_lpn_tbl.first;
906: WHILE i IS NOT NULL LOOP

Line 1189: WSH_WMS_LPN_GRP.g_call_group_api := l_orig_value;

1185: END IF;
1186: --
1187: EXCEPTION
1188: WHEN FND_API.G_EXC_ERROR THEN
1189: WSH_WMS_LPN_GRP.g_call_group_api := l_orig_value;
1190: WSH_WMS_LPN_GRP.g_update_to_container := l_orig_update_cont_value;
1191: IF c_get_lpn_info%ISOPEN THEN
1192: CLOSE c_get_lpn_info;
1193: END IF;

Line 1190: WSH_WMS_LPN_GRP.g_update_to_container := l_orig_update_cont_value;

1186: --
1187: EXCEPTION
1188: WHEN FND_API.G_EXC_ERROR THEN
1189: WSH_WMS_LPN_GRP.g_call_group_api := l_orig_value;
1190: WSH_WMS_LPN_GRP.g_update_to_container := l_orig_update_cont_value;
1191: IF c_get_lpn_info%ISOPEN THEN
1192: CLOSE c_get_lpn_info;
1193: END IF;
1194: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 1202: WSH_WMS_LPN_GRP.g_call_group_api := l_orig_value;

1198: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1199: END IF;
1200:
1201: WHEN Others THEN
1202: WSH_WMS_LPN_GRP.g_call_group_api := l_orig_value;
1203: WSH_WMS_LPN_GRP.g_update_to_container := l_orig_update_cont_value;
1204: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Create_Cont_Instance_Multi',l_module_name);
1205: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1206:

Line 1203: WSH_WMS_LPN_GRP.g_update_to_container := l_orig_update_cont_value;

1199: END IF;
1200:
1201: WHEN Others THEN
1202: WSH_WMS_LPN_GRP.g_call_group_api := l_orig_value;
1203: WSH_WMS_LPN_GRP.g_update_to_container := l_orig_update_cont_value;
1204: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Create_Cont_Instance_Multi',l_module_name);
1205: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1206:
1207: --

Line 2494: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

2490:
2491:
2492: --
2493: -- K LPN CONV. rv
2494: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
2495: AND l_cont_line_dir_tab(i) IN ('O','IO')
2496: AND
2497: (
2498: (WSH_WMS_LPN_GRP.GK_WMS_UPD_GRP and l_wms_org = 'Y')

Line 2498: (WSH_WMS_LPN_GRP.GK_WMS_UPD_GRP and l_wms_org = 'Y')

2494: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
2495: AND l_cont_line_dir_tab(i) IN ('O','IO')
2496: AND
2497: (
2498: (WSH_WMS_LPN_GRP.GK_WMS_UPD_GRP and l_wms_org = 'Y')
2499: OR
2500: (WSH_WMS_LPN_GRP.GK_INV_UPD_GRP and l_wms_org = 'N')
2501: )
2502: THEN

Line 2500: (WSH_WMS_LPN_GRP.GK_INV_UPD_GRP and l_wms_org = 'N')

2496: AND
2497: (
2498: (WSH_WMS_LPN_GRP.GK_WMS_UPD_GRP and l_wms_org = 'Y')
2499: OR
2500: (WSH_WMS_LPN_GRP.GK_INV_UPD_GRP and l_wms_org = 'N')
2501: )
2502: THEN
2503: --{
2504: l_sync_tmp_rec.delivery_detail_id := l_cont_tab(i);

Line 2727: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

2723:
2724: IF (nvl(l_last_line_flag,'N') = 'Y') AND (nvl(l_attr_flag,'N') = 'Y') AND (nvl(l_delivery_id,-99) = -99) THEN --{
2725: --
2726: -- K LPN CONV. rv
2727: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
2728: AND l_cont_line_dir_tab(i) IN ('O','IO')
2729: AND
2730: (
2731: (WSH_WMS_LPN_GRP.GK_WMS_UPD_GRP and l_wms_org = 'Y')

Line 2731: (WSH_WMS_LPN_GRP.GK_WMS_UPD_GRP and l_wms_org = 'Y')

2727: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
2728: AND l_cont_line_dir_tab(i) IN ('O','IO')
2729: AND
2730: (
2731: (WSH_WMS_LPN_GRP.GK_WMS_UPD_GRP and l_wms_org = 'Y')
2732: OR
2733: (WSH_WMS_LPN_GRP.GK_INV_UPD_GRP and l_wms_org = 'N')
2734: )
2735: THEN

Line 2733: (WSH_WMS_LPN_GRP.GK_INV_UPD_GRP and l_wms_org = 'N')

2729: AND
2730: (
2731: (WSH_WMS_LPN_GRP.GK_WMS_UPD_GRP and l_wms_org = 'Y')
2732: OR
2733: (WSH_WMS_LPN_GRP.GK_INV_UPD_GRP and l_wms_org = 'N')
2734: )
2735: THEN
2736: --{
2737: l_sync_tmp_rec.delivery_detail_id := l_del_detail_rec(i);

Line 2827: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

2823: -- unassigned with the serial number of the current top most
2824: -- container..
2825: --
2826: -- K LPN CONV. rv
2827: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
2828: AND l_cont_line_dir_tab(i) IN ('O','IO')
2829: AND
2830: (
2831: (WSH_WMS_LPN_GRP.GK_WMS_UPD_MISC and l_wms_org = 'Y')

Line 2831: (WSH_WMS_LPN_GRP.GK_WMS_UPD_MISC and l_wms_org = 'Y')

2827: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
2828: AND l_cont_line_dir_tab(i) IN ('O','IO')
2829: AND
2830: (
2831: (WSH_WMS_LPN_GRP.GK_WMS_UPD_MISC and l_wms_org = 'Y')
2832: OR
2833: (WSH_WMS_LPN_GRP.GK_INV_UPD_MISC and l_wms_org = 'N')
2834: )
2835: THEN

Line 2833: (WSH_WMS_LPN_GRP.GK_INV_UPD_MISC and l_wms_org = 'N')

2829: AND
2830: (
2831: (WSH_WMS_LPN_GRP.GK_WMS_UPD_MISC and l_wms_org = 'Y')
2832: OR
2833: (WSH_WMS_LPN_GRP.GK_INV_UPD_MISC and l_wms_org = 'N')
2834: )
2835: THEN
2836: --{
2837: l_sync_tmp_rec.delivery_detail_id := l_del_detail_rec(i);

Line 2972: l_wms_org = 'Y' AND nvl(wsh_wms_lpn_grp.g_caller,'WSH') like 'WMS%'

2968: close l_get_cnt_org_csr;
2969:
2970: -- LPN CONV. rv
2971: IF NOT(
2972: l_wms_org = 'Y' AND nvl(wsh_wms_lpn_grp.g_caller,'WSH') like 'WMS%'
2973: )
2974: THEN
2975: --{
2976: WSH_WV_UTILS.Check_Fill_Pc (

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

6847: l_ddlist(cnt) := g_assign_detail_tab(cnt).delivery_detail_id;
6848: l_dellist(cnt) := g_assign_detail_tab(cnt).delivery_id;
6849: l_wms_org := 'N';
6850: -- K LPN CONV. rv
6851: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y' THEN
6852: --{
6853: l_wms_org := wsh_util_validate.check_wms_org(g_assign_detail_tab(cnt).organization_id);
6854: IF (l_wms_org = 'Y') THEN
6855: l_sync_tmp_wms_ddlist.delivery_detail_id_tbl(l_wms_ddtlist_cnt) := g_assign_detail_tab(cnt).delivery_detail_id;

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

6911:
6912: l_contlist(cnt) :=
6913: g_new_contid_tab(g_assign_detail_tab(cnt).container_index).cont_instance_id;
6914: -- K LPN CONV. rv
6915: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y' THEN
6916: --{
6917: l_wms_org := 'N';
6918: l_wms_org := wsh_util_validate.check_wms_org(g_new_contid_tab(g_assign_detail_tab(cnt).container_index).organization_id);
6919: IF (l_wms_org = 'Y') THEN

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

6961: l_cont_Vollist(m) :=
6962: g_new_contid_tab(g_assign_detail_tab(cnt).container_index).unit_volume;
6963: l_dellist1(m) := g_assign_detail_tab(cnt).delivery_id;
6964: -- K LPN CONV. rv
6965: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y' THEN
6966: --{
6967: IF (l_wms_org = 'Y') THEN
6968: l_sync_tmp_wms_contlist1.delivery_detail_id_tbl(l_wms_contlist1_cnt) := l_contlist1(m);
6969: l_sync_tmp_wms_contlist1.delivery_id_tbl(l_wms_contlist1_cnt) := NULL;

Line 7121: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

7117:
7118: -- changes to add l_dellist1 and add new messages
7119: --
7120: -- K LPN CONV. rv
7121: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
7122: THEN
7123: --{
7124: IF (WSH_WMS_LPN_GRP.GK_WMS_PACK and l_sync_tmp_wms_ddlist.delivery_detail_id_tbl.count > 0)
7125: THEN

Line 7124: IF (WSH_WMS_LPN_GRP.GK_WMS_PACK and l_sync_tmp_wms_ddlist.delivery_detail_id_tbl.count > 0)

7120: -- K LPN CONV. rv
7121: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
7122: THEN
7123: --{
7124: IF (WSH_WMS_LPN_GRP.GK_WMS_PACK and l_sync_tmp_wms_ddlist.delivery_detail_id_tbl.count > 0)
7125: THEN
7126: --{
7127: WSH_WMS_SYNC_TMP_PKG.MERGE_BULK
7128: (

Line 7152: ELSIF (WSH_WMS_LPN_GRP.GK_INV_PACK and l_sync_tmp_inv_ddlist.delivery_detail_id_tbl.count > 0)

7148: x_return_status := C_WARNING_STATUS;
7149: END IF;
7150: END IF;
7151: --}
7152: ELSIF (WSH_WMS_LPN_GRP.GK_INV_PACK and l_sync_tmp_inv_ddlist.delivery_detail_id_tbl.count > 0)
7153: THEN
7154: --{
7155: WSH_WMS_SYNC_TMP_PKG.MERGE_BULK
7156: (

Line 7273: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

7269: END LOOP;
7270:
7271: --
7272: -- K LPN CONV. rv
7273: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
7274: THEN
7275: --{
7276: IF (WSH_WMS_LPN_GRP.GK_WMS_UPD_GRP and l_sync_tmp_wms_contlist.delivery_detail_id_tbl.count > 0)
7277: THEN

Line 7276: IF (WSH_WMS_LPN_GRP.GK_WMS_UPD_GRP and l_sync_tmp_wms_contlist.delivery_detail_id_tbl.count > 0)

7272: -- K LPN CONV. rv
7273: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
7274: THEN
7275: --{
7276: IF (WSH_WMS_LPN_GRP.GK_WMS_UPD_GRP and l_sync_tmp_wms_contlist.delivery_detail_id_tbl.count > 0)
7277: THEN
7278: --{
7279: WSH_WMS_SYNC_TMP_PKG.MERGE_BULK
7280: (

Line 7304: ELSIF (WSH_WMS_LPN_GRP.GK_INV_UPD_GRP and l_sync_tmp_inv_contlist.delivery_detail_id_tbl.count > 0)

7300: x_return_status := C_WARNING_STATUS;
7301: END IF;
7302: END IF;
7303: --}
7304: ELSIF (WSH_WMS_LPN_GRP.GK_INV_UPD_GRP and l_sync_tmp_inv_contlist.delivery_detail_id_tbl.count > 0)
7305: THEN
7306: --{
7307: WSH_WMS_SYNC_TMP_PKG.MERGE_BULK
7308: (

Line 7359: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

7355: -- then if the delivery detail has a delivery assigned, update the container records
7356: -- in WDA to indicate delivery id
7357: --
7358: -- K LPN CONV. rv
7359: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
7360: THEN
7361: --{
7362: IF (WSH_WMS_LPN_GRP.GK_WMS_ASSIGN_DLVY and l_sync_tmp_wms_contlist1.delivery_detail_id_tbl.count > 0)
7363: THEN

Line 7362: IF (WSH_WMS_LPN_GRP.GK_WMS_ASSIGN_DLVY and l_sync_tmp_wms_contlist1.delivery_detail_id_tbl.count > 0)

7358: -- K LPN CONV. rv
7359: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
7360: THEN
7361: --{
7362: IF (WSH_WMS_LPN_GRP.GK_WMS_ASSIGN_DLVY and l_sync_tmp_wms_contlist1.delivery_detail_id_tbl.count > 0)
7363: THEN
7364: --{
7365: WSH_WMS_SYNC_TMP_PKG.MERGE_BULK
7366: (

Line 7390: ELSIF (WSH_WMS_LPN_GRP.GK_INV_ASSIGN_DLVY and l_sync_tmp_inv_contlist1.delivery_detail_id_tbl.count > 0)

7386: x_return_status := C_WARNING_STATUS;
7387: END IF;
7388: END IF;
7389: --}
7390: ELSIF (WSH_WMS_LPN_GRP.GK_INV_ASSIGN_DLVY and l_sync_tmp_inv_contlist1.delivery_detail_id_tbl.count > 0)
7391: THEN
7392: --{
7393: WSH_WMS_SYNC_TMP_PKG.MERGE_BULK
7394: (

Line 8100: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

8096: END IF;
8097:
8098: -- LPN CONV. rv
8099: --
8100: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
8101: THEN
8102: --{
8103:
8104: IF l_debug_on THEN

Line 8166: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

8162: EXCEPTION
8163: -- LPN CONV. rv
8164: WHEN e_return_excp THEN
8165: --
8166: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
8167: THEN
8168: --{
8169: --
8170: IF l_debug_on THEN

Line 8209: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

8205: IF l_debug_on THEN
8206: 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);
8207: END IF;
8208: --
8209: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
8210: THEN
8211: --{
8212: --
8213: IF l_debug_on THEN

Line 9775: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

9771:
9772:
9773: -- LPN CONV. rv
9774: --
9775: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
9776: THEN
9777: --{
9778:
9779: IF l_debug_on THEN

Line 9893: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

9889: IF l_debug_on THEN
9890: 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);
9891: END IF;
9892: --
9893: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
9894: THEN
9895: --{
9896: --
9897: IF l_debug_on THEN

Line 9938: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

9934: IF l_debug_on THEN
9935: 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);
9936: END IF;
9937: --
9938: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
9939: THEN
9940: --{
9941: --
9942: IF l_debug_on THEN

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

11343: END IF;
11344:
11345: --
11346: -- K LPN CONV. rv
11347: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y' THEN
11348: --{
11349: open c_get_detail(l_cont_instance_id);
11350: fetch c_get_detail into l_cnt_ignore_plan_flag, l_cnt_orgn_id, l_cnt_line_dir;
11351: close c_get_detail;

Line 11367: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

11363: WSH_DEBUG_SV.log(l_module_name,'ignore_for_planning',cur.ignore_for_planning);
11364: END IF;
11365: --
11366: -- K LPN CONV. rv
11367: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
11368: AND l_cnt_line_dir IN ('O','IO')
11369: AND
11370: (
11371: (WSH_WMS_LPN_GRP.GK_WMS_UPD_GRP and l_wms_org = 'Y')

Line 11371: (WSH_WMS_LPN_GRP.GK_WMS_UPD_GRP and l_wms_org = 'Y')

11367: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
11368: AND l_cnt_line_dir IN ('O','IO')
11369: AND
11370: (
11371: (WSH_WMS_LPN_GRP.GK_WMS_UPD_GRP and l_wms_org = 'Y')
11372: OR
11373: (WSH_WMS_LPN_GRP.GK_INV_UPD_GRP and l_wms_org = 'N')
11374: )
11375: THEN

Line 11373: (WSH_WMS_LPN_GRP.GK_INV_UPD_GRP and l_wms_org = 'N')

11369: AND
11370: (
11371: (WSH_WMS_LPN_GRP.GK_WMS_UPD_GRP and l_wms_org = 'Y')
11372: OR
11373: (WSH_WMS_LPN_GRP.GK_INV_UPD_GRP and l_wms_org = 'N')
11374: )
11375: THEN
11376: --{
11377: l_sync_tmp_rec.delivery_detail_id := l_cont_instance_id;

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

11704:
11705: --dbms_output.put_line('calling update with customer id ' || l_cust_id || ' and ship to ' || l_ship_to_loc_id);
11706:
11707: -- K LPN CONV. rv
11708: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y' THEN
11709: FOR cnt_inst_rec in Get_Detail_Attr(p_container_instance_id) LOOP
11710: l_wms_org := wsh_util_validate.check_wms_org(cnt_inst_rec.organization_id);
11711: l_cnt_line_dir := cnt_inst_rec.line_direction;
11712: END LOOP;

Line 11715: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

11711: l_cnt_line_dir := cnt_inst_rec.line_direction;
11712: END LOOP;
11713: END IF;
11714: --
11715: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
11716: AND l_cnt_line_dir IN ('O','IO')
11717: AND
11718: (
11719: (WSH_WMS_LPN_GRP.GK_WMS_UPD_GRP and l_wms_org = 'Y')

Line 11719: (WSH_WMS_LPN_GRP.GK_WMS_UPD_GRP and l_wms_org = 'Y')

11715: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
11716: AND l_cnt_line_dir IN ('O','IO')
11717: AND
11718: (
11719: (WSH_WMS_LPN_GRP.GK_WMS_UPD_GRP and l_wms_org = 'Y')
11720: OR
11721: (WSH_WMS_LPN_GRP.GK_INV_UPD_GRP and l_wms_org = 'N')
11722: )
11723: THEN

Line 11721: (WSH_WMS_LPN_GRP.GK_INV_UPD_GRP and l_wms_org = 'N')

11717: AND
11718: (
11719: (WSH_WMS_LPN_GRP.GK_WMS_UPD_GRP and l_wms_org = 'Y')
11720: OR
11721: (WSH_WMS_LPN_GRP.GK_INV_UPD_GRP and l_wms_org = 'N')
11722: )
11723: THEN
11724: --{
11725: l_sync_tmp_rec.delivery_detail_id := p_container_instance_id;