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 873: l_orig_value := WSH_WMS_LPN_GRP.g_call_group_api;

869: WSH_DEBUG_SV.logmsg(l_module_name, 'IN CREATE_CONT_INSTANCE_MULTI ' );
870: END IF;
871: --
872:
873: l_orig_value := WSH_WMS_LPN_GRP.g_call_group_api;
874: l_orig_update_cont_value := WSH_WMS_LPN_GRP.g_update_to_container;
875: l_inventory_item_id := p_cont_item_id;
876:
877: IF p_organization_id IS NULL AND p_lpn_id IS NULL THEN

Line 874: l_orig_update_cont_value := WSH_WMS_LPN_GRP.g_update_to_container;

870: END IF;
871: --
872:
873: l_orig_value := WSH_WMS_LPN_GRP.g_call_group_api;
874: l_orig_update_cont_value := WSH_WMS_LPN_GRP.g_update_to_container;
875: l_inventory_item_id := p_cont_item_id;
876:
877: IF p_organization_id IS NULL AND p_lpn_id IS NULL THEN
878: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_ORG_NULL');

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

888:
889: --lpn conv
890: IF p_lpn_id IS NULL THEN --{
891:
892: WSH_WMS_LPN_GRP.g_call_group_api := 'N';
893: WSH_WMS_LPN_GRP.g_update_to_container := 'N';
894:
895: IF c_wms_code_present = 'Y' THEN --{
896:

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

889: --lpn conv
890: IF p_lpn_id IS NULL THEN --{
891:
892: WSH_WMS_LPN_GRP.g_call_group_api := 'N';
893: WSH_WMS_LPN_GRP.g_update_to_container := 'N';
894:
895: IF c_wms_code_present = 'Y' THEN --{
896:
897: IF l_debug_on THEN

Line 928: WSH_WMS_LPN_GRP.g_call_group_api := l_orig_value;

924: x_num_warnings => l_num_warnings,
925: x_num_errors => l_num_errors,
926: p_msg_data => l_msg_data
927: );
928: WSH_WMS_LPN_GRP.g_call_group_api := l_orig_value;
929: WSH_WMS_LPN_GRP.g_update_to_container := l_orig_update_cont_value;
930:
931: j := 1;
932: i := l_lpn_tbl.first;

Line 929: WSH_WMS_LPN_GRP.g_update_to_container := l_orig_update_cont_value;

925: x_num_errors => l_num_errors,
926: p_msg_data => l_msg_data
927: );
928: WSH_WMS_LPN_GRP.g_call_group_api := l_orig_value;
929: WSH_WMS_LPN_GRP.g_update_to_container := l_orig_update_cont_value;
930:
931: j := 1;
932: i := l_lpn_tbl.first;
933: WHILE i IS NOT NULL LOOP

Line 1216: WSH_WMS_LPN_GRP.g_call_group_api := l_orig_value;

1212: END IF;
1213: --
1214: EXCEPTION
1215: WHEN FND_API.G_EXC_ERROR THEN
1216: WSH_WMS_LPN_GRP.g_call_group_api := l_orig_value;
1217: WSH_WMS_LPN_GRP.g_update_to_container := l_orig_update_cont_value;
1218: IF c_get_lpn_info%ISOPEN THEN
1219: CLOSE c_get_lpn_info;
1220: END IF;

Line 1217: WSH_WMS_LPN_GRP.g_update_to_container := l_orig_update_cont_value;

1213: --
1214: EXCEPTION
1215: WHEN FND_API.G_EXC_ERROR THEN
1216: WSH_WMS_LPN_GRP.g_call_group_api := l_orig_value;
1217: WSH_WMS_LPN_GRP.g_update_to_container := l_orig_update_cont_value;
1218: IF c_get_lpn_info%ISOPEN THEN
1219: CLOSE c_get_lpn_info;
1220: END IF;
1221: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 1229: WSH_WMS_LPN_GRP.g_call_group_api := l_orig_value;

1225: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1226: END IF;
1227:
1228: WHEN Others THEN
1229: WSH_WMS_LPN_GRP.g_call_group_api := l_orig_value;
1230: WSH_WMS_LPN_GRP.g_update_to_container := l_orig_update_cont_value;
1231: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Create_Cont_Instance_Multi',l_module_name);
1232: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1233:

Line 1230: WSH_WMS_LPN_GRP.g_update_to_container := l_orig_update_cont_value;

1226: END IF;
1227:
1228: WHEN Others THEN
1229: WSH_WMS_LPN_GRP.g_call_group_api := l_orig_value;
1230: WSH_WMS_LPN_GRP.g_update_to_container := l_orig_update_cont_value;
1231: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Create_Cont_Instance_Multi',l_module_name);
1232: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1233:
1234: --

Line 2524: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

2520:
2521:
2522: --
2523: -- K LPN CONV. rv
2524: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
2525: AND l_cont_line_dir_tab(i) IN ('O','IO')
2526: AND
2527: (
2528: (WSH_WMS_LPN_GRP.GK_WMS_UPD_GRP and l_wms_org = 'Y')

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

2524: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
2525: AND l_cont_line_dir_tab(i) IN ('O','IO')
2526: AND
2527: (
2528: (WSH_WMS_LPN_GRP.GK_WMS_UPD_GRP and l_wms_org = 'Y')
2529: OR
2530: (WSH_WMS_LPN_GRP.GK_INV_UPD_GRP and l_wms_org = 'N')
2531: )
2532: THEN

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

2526: AND
2527: (
2528: (WSH_WMS_LPN_GRP.GK_WMS_UPD_GRP and l_wms_org = 'Y')
2529: OR
2530: (WSH_WMS_LPN_GRP.GK_INV_UPD_GRP and l_wms_org = 'N')
2531: )
2532: THEN
2533: --{
2534: l_sync_tmp_rec.delivery_detail_id := l_cont_tab(i);

Line 2760: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

2756:
2757: IF (nvl(l_last_line_flag,'N') = 'Y') AND (nvl(l_attr_flag,'N') = 'Y') AND (nvl(l_delivery_id,-99) = -99) THEN --{
2758: --
2759: -- K LPN CONV. rv
2760: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
2761: AND l_cont_line_dir_tab(i) IN ('O','IO')
2762: AND
2763: (
2764: (WSH_WMS_LPN_GRP.GK_WMS_UPD_GRP and l_wms_org = 'Y')

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

2760: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
2761: AND l_cont_line_dir_tab(i) IN ('O','IO')
2762: AND
2763: (
2764: (WSH_WMS_LPN_GRP.GK_WMS_UPD_GRP and l_wms_org = 'Y')
2765: OR
2766: (WSH_WMS_LPN_GRP.GK_INV_UPD_GRP and l_wms_org = 'N')
2767: )
2768: THEN

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

2762: AND
2763: (
2764: (WSH_WMS_LPN_GRP.GK_WMS_UPD_GRP and l_wms_org = 'Y')
2765: OR
2766: (WSH_WMS_LPN_GRP.GK_INV_UPD_GRP and l_wms_org = 'N')
2767: )
2768: THEN
2769: --{
2770: l_sync_tmp_rec.delivery_detail_id := l_del_detail_rec(i);

Line 2861: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

2857: -- unassigned with the serial number of the current top most
2858: -- container..
2859: --
2860: -- K LPN CONV. rv
2861: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
2862: AND l_cont_line_dir_tab(i) IN ('O','IO')
2863: AND
2864: (
2865: (WSH_WMS_LPN_GRP.GK_WMS_UPD_MISC and l_wms_org = 'Y')

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

2861: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
2862: AND l_cont_line_dir_tab(i) IN ('O','IO')
2863: AND
2864: (
2865: (WSH_WMS_LPN_GRP.GK_WMS_UPD_MISC and l_wms_org = 'Y')
2866: OR
2867: (WSH_WMS_LPN_GRP.GK_INV_UPD_MISC and l_wms_org = 'N')
2868: )
2869: THEN

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

2863: AND
2864: (
2865: (WSH_WMS_LPN_GRP.GK_WMS_UPD_MISC and l_wms_org = 'Y')
2866: OR
2867: (WSH_WMS_LPN_GRP.GK_INV_UPD_MISC and l_wms_org = 'N')
2868: )
2869: THEN
2870: --{
2871: l_sync_tmp_rec.delivery_detail_id := l_del_detail_rec(i);

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

3002: close l_get_cnt_org_csr;
3003:
3004: -- LPN CONV. rv
3005: IF NOT(
3006: l_wms_org = 'Y' AND nvl(wsh_wms_lpn_grp.g_caller,'WSH') like 'WMS%'
3007: )
3008: THEN
3009: --{
3010: WSH_WV_UTILS.Check_Fill_Pc (

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

6933: l_ddlist(cnt) := g_assign_detail_tab(cnt).delivery_detail_id;
6934: l_dellist(cnt) := g_assign_detail_tab(cnt).delivery_id;
6935: l_wms_org := 'N';
6936: -- K LPN CONV. rv
6937: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y' THEN
6938: --{
6939: l_wms_org := wsh_util_validate.check_wms_org(g_assign_detail_tab(cnt).organization_id);
6940: IF (l_wms_org = 'Y') THEN
6941: l_sync_tmp_wms_ddlist.delivery_detail_id_tbl(l_wms_ddtlist_cnt) := g_assign_detail_tab(cnt).delivery_detail_id;

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

6997:
6998: l_contlist(cnt) :=
6999: g_new_contid_tab(g_assign_detail_tab(cnt).container_index).cont_instance_id;
7000: -- K LPN CONV. rv
7001: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y' THEN
7002: --{
7003: l_wms_org := 'N';
7004: l_wms_org := wsh_util_validate.check_wms_org(g_new_contid_tab(g_assign_detail_tab(cnt).container_index).organization_id);
7005: IF (l_wms_org = 'Y') THEN

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

7047: l_cont_Vollist(m) :=
7048: g_new_contid_tab(g_assign_detail_tab(cnt).container_index).unit_volume;
7049: --l_dellist1(m) := g_assign_detail_tab(cnt).delivery_id; Commented by adagur for bug 16397445
7050: -- K LPN CONV. rv
7051: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y' THEN
7052: --{
7053: IF (l_wms_org = 'Y') THEN
7054: l_sync_tmp_wms_contlist1.delivery_detail_id_tbl(l_wms_contlist1_cnt) := l_contlist1(m);
7055: l_sync_tmp_wms_contlist1.delivery_id_tbl(l_wms_contlist1_cnt) := NULL;

Line 7207: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

7203:
7204: -- changes to add l_dellist1 and add new messages
7205: --
7206: -- K LPN CONV. rv
7207: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
7208: THEN
7209: --{
7210: IF (WSH_WMS_LPN_GRP.GK_WMS_PACK and l_sync_tmp_wms_ddlist.delivery_detail_id_tbl.count > 0)
7211: THEN

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

7206: -- K LPN CONV. rv
7207: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
7208: THEN
7209: --{
7210: IF (WSH_WMS_LPN_GRP.GK_WMS_PACK and l_sync_tmp_wms_ddlist.delivery_detail_id_tbl.count > 0)
7211: THEN
7212: --{
7213: WSH_WMS_SYNC_TMP_PKG.MERGE_BULK
7214: (

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

7234: x_return_status := C_WARNING_STATUS;
7235: END IF;
7236: END IF;
7237: --}
7238: ELSIF (WSH_WMS_LPN_GRP.GK_INV_PACK and l_sync_tmp_inv_ddlist.delivery_detail_id_tbl.count > 0)
7239: THEN
7240: --{
7241: WSH_WMS_SYNC_TMP_PKG.MERGE_BULK
7242: (

Line 7360: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

7356: END LOOP;
7357:
7358: --
7359: -- K LPN CONV. rv
7360: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
7361: THEN
7362: --{
7363: IF (WSH_WMS_LPN_GRP.GK_WMS_UPD_GRP and l_sync_tmp_wms_contlist.delivery_detail_id_tbl.count > 0)
7364: THEN

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

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

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

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

Line 7489: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

7485: -- then if the delivery detail has a delivery assigned, update the container records
7486: -- in WDA to indicate delivery id
7487: --
7488: -- K LPN CONV. rv
7489: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
7490: THEN
7491: --{
7492: IF (WSH_WMS_LPN_GRP.GK_WMS_ASSIGN_DLVY and l_sync_tmp_wms_contlist1.delivery_detail_id_tbl.count > 0)
7493: THEN

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

7488: -- K LPN CONV. rv
7489: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
7490: THEN
7491: --{
7492: IF (WSH_WMS_LPN_GRP.GK_WMS_ASSIGN_DLVY and l_sync_tmp_wms_contlist1.delivery_detail_id_tbl.count > 0)
7493: THEN
7494: --{
7495: WSH_WMS_SYNC_TMP_PKG.MERGE_BULK
7496: (

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

7516: x_return_status := C_WARNING_STATUS;
7517: END IF;
7518: END IF;
7519: --}
7520: ELSIF (WSH_WMS_LPN_GRP.GK_INV_ASSIGN_DLVY and l_sync_tmp_inv_contlist1.delivery_detail_id_tbl.count > 0)
7521: THEN
7522: --{
7523: WSH_WMS_SYNC_TMP_PKG.MERGE_BULK
7524: (

Line 8229: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

8225: END IF;
8226:
8227: -- LPN CONV. rv
8228: --
8229: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
8230: THEN
8231: --{
8232:
8233: IF l_debug_on THEN

Line 8295: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

8291: EXCEPTION
8292: -- LPN CONV. rv
8293: WHEN e_return_excp THEN
8294: --
8295: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
8296: THEN
8297: --{
8298: --
8299: IF l_debug_on THEN

Line 8338: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

8334: IF l_debug_on THEN
8335: 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);
8336: END IF;
8337: --
8338: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
8339: THEN
8340: --{
8341: --
8342: IF l_debug_on THEN

Line 9904: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

9900:
9901:
9902: -- LPN CONV. rv
9903: --
9904: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
9905: THEN
9906: --{
9907:
9908: IF l_debug_on THEN

Line 10022: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

10018: IF l_debug_on THEN
10019: 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);
10020: END IF;
10021: --
10022: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
10023: THEN
10024: --{
10025: --
10026: IF l_debug_on THEN

Line 10067: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

10063: IF l_debug_on THEN
10064: 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);
10065: END IF;
10066: --
10067: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
10068: THEN
10069: --{
10070: --
10071: IF l_debug_on THEN

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

11472: END IF;
11473:
11474: --
11475: -- K LPN CONV. rv
11476: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y' THEN
11477: --{
11478: open c_get_detail(l_cont_instance_id);
11479: fetch c_get_detail into l_cnt_ignore_plan_flag, l_cnt_orgn_id, l_cnt_line_dir;
11480: close c_get_detail;

Line 11496: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

11492: WSH_DEBUG_SV.log(l_module_name,'ignore_for_planning',cur.ignore_for_planning);
11493: END IF;
11494: --
11495: -- K LPN CONV. rv
11496: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
11497: AND l_cnt_line_dir IN ('O','IO')
11498: AND
11499: (
11500: (WSH_WMS_LPN_GRP.GK_WMS_UPD_GRP and l_wms_org = 'Y')

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

11496: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
11497: AND l_cnt_line_dir IN ('O','IO')
11498: AND
11499: (
11500: (WSH_WMS_LPN_GRP.GK_WMS_UPD_GRP and l_wms_org = 'Y')
11501: OR
11502: (WSH_WMS_LPN_GRP.GK_INV_UPD_GRP and l_wms_org = 'N')
11503: )
11504: THEN

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

11498: AND
11499: (
11500: (WSH_WMS_LPN_GRP.GK_WMS_UPD_GRP and l_wms_org = 'Y')
11501: OR
11502: (WSH_WMS_LPN_GRP.GK_INV_UPD_GRP and l_wms_org = 'N')
11503: )
11504: THEN
11505: --{
11506: l_sync_tmp_rec.delivery_detail_id := l_cont_instance_id;

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

11842:
11843: --dbms_output.put_line('calling update with customer id ' || l_cust_id || ' and ship to ' || l_ship_to_loc_id);
11844:
11845: -- K LPN CONV. rv
11846: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y' THEN
11847: FOR cnt_inst_rec in Get_Detail_Attr(p_container_instance_id) LOOP
11848: l_wms_org := wsh_util_validate.check_wms_org(cnt_inst_rec.organization_id);
11849: l_cnt_line_dir := cnt_inst_rec.line_direction;
11850: END LOOP;

Line 11853: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

11849: l_cnt_line_dir := cnt_inst_rec.line_direction;
11850: END LOOP;
11851: END IF;
11852: --
11853: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
11854: AND l_cnt_line_dir IN ('O','IO')
11855: AND
11856: (
11857: (WSH_WMS_LPN_GRP.GK_WMS_UPD_GRP and l_wms_org = 'Y')

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

11853: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
11854: AND l_cnt_line_dir IN ('O','IO')
11855: AND
11856: (
11857: (WSH_WMS_LPN_GRP.GK_WMS_UPD_GRP and l_wms_org = 'Y')
11858: OR
11859: (WSH_WMS_LPN_GRP.GK_INV_UPD_GRP and l_wms_org = 'N')
11860: )
11861: THEN

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

11855: AND
11856: (
11857: (WSH_WMS_LPN_GRP.GK_WMS_UPD_GRP and l_wms_org = 'Y')
11858: OR
11859: (WSH_WMS_LPN_GRP.GK_INV_UPD_GRP and l_wms_org = 'N')
11860: )
11861: THEN
11862: --{
11863: l_sync_tmp_rec.delivery_detail_id := p_container_instance_id;