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_TP_RELEASE dependencies on WSH_NEW_DELIVERIES

Line 50: FROM wsh_trips t, wsh_trip_stops st, wsh_delivery_legs dg, wsh_new_deliveries dl

46: CURSOR c_get_deliveries (p_tripid NUMBER) IS
47: SELECT dl.delivery_id, dl.planned_flag, dl.status_code, dl.ignore_for_planning, dl.name delivery_name,
48: dl.organization_id organization_id, -- LPN CONV. rv
49: nvl(dl.shipment_direction,'O') shipment_direction -- LPN CONV. rv
50: FROM wsh_trips t, wsh_trip_stops st, wsh_delivery_legs dg, wsh_new_deliveries dl
51: WHERE t.trip_id = p_tripid AND
52: st.trip_id = t.trip_id AND
53: dg.pick_up_stop_id = st.stop_id AND
54: dl.delivery_id = dg.delivery_id;

Line 58: FROM wsh_trips t, wsh_trip_stops st, wsh_delivery_legs dg, wsh_new_deliveries dl

54: dl.delivery_id = dg.delivery_id;
55:
56: CURSOR c_get_dels_diff_ignoreflag (p_delid NUMBER, p_tripid NUMBER, p_ignoreplan VARCHAR2) IS
57: SELECT dl.name delivery_name, t.name trip_name
58: FROM wsh_trips t, wsh_trip_stops st, wsh_delivery_legs dg, wsh_new_deliveries dl
59: WHERE t.trip_id <> p_tripid AND
60: st.trip_id = t.trip_id AND
61: dg.pick_up_stop_id = st.stop_id AND
62: dl.delivery_id = dg.delivery_id AND

Line 78: FROM wsh_trips t, wsh_trip_stops st, wsh_delivery_legs dg, wsh_new_deliveries dl

74: -- AND t.planned_flag <> 'F'; --change in design - firm check not needed
75:
76: CURSOR c_get_del_ignoreflag_difftrip (p_delid NUMBER, p_ignoreplan VARCHAR2) IS
77: SELECT dl.name delivery_name, t.name trip_name
78: FROM wsh_trips t, wsh_trip_stops st, wsh_delivery_legs dg, wsh_new_deliveries dl
79: WHERE st.trip_id = t.trip_id AND
80: dg.pick_up_stop_id = st.stop_id AND
81: dl.delivery_id = dg.delivery_id AND
82: dl.delivery_id=p_delid AND

Line 88: FROM wsh_delivery_assignments_v wda, wsh_new_deliveries wnd

84: -- OR t.planned_flag='F'); --change in design - firm check not needed
85:
86: CURSOR c_get_det_ignoreflag_diff_del (p_detailid NUMBER, p_ignoreplan VARCHAR2) IS
87: SELECT wnd.name delivery_name
88: FROM wsh_delivery_assignments_v wda, wsh_new_deliveries wnd
89: WHERE wda.delivery_id = wnd.delivery_id AND
90: wda.delivery_id IS NOT NULL AND
91: wda.delivery_detail_id=p_detailid AND
92: (nvl(wnd.ignore_for_planning, 'N')<>p_ignoreplan);

Line 111: from wsh_new_deliveries

107: where delivery_detail_id=p_detid;
108:
109: CURSOR c_get_del_org (p_delid NUMBER) IS
110: select organization_id, name delivery_name, delivery_type
111: from wsh_new_deliveries
112: where delivery_id=p_delid;
113:
114: CURSOR c_get_container (p_detailid NUMBER) IS
115: select container_flag, container_name,

Line 159: l_delivery_info_tab WSH_NEW_DELIVERIES_PVT.DELIVERY_ATTR_TBL_TYPE;

155: others EXCEPTION;
156: l_batch_size NUMBER:=10000;
157:
158: --OTM R12, glog proj
159: l_delivery_info_tab WSH_NEW_DELIVERIES_PVT.DELIVERY_ATTR_TBL_TYPE;
160: l_delivery_info WSH_NEW_DELIVERIES_PVT.DELIVERY_REC_TYPE;
161: l_new_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
162: l_new_version_number_tab WSH_UTIL_CORE.ID_TAB_TYPE;
163: l_temp NUMBER;

Line 160: l_delivery_info WSH_NEW_DELIVERIES_PVT.DELIVERY_REC_TYPE;

156: l_batch_size NUMBER:=10000;
157:
158: --OTM R12, glog proj
159: l_delivery_info_tab WSH_NEW_DELIVERIES_PVT.DELIVERY_ATTR_TBL_TYPE;
160: l_delivery_info WSH_NEW_DELIVERIES_PVT.DELIVERY_REC_TYPE;
161: l_new_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
162: l_new_version_number_tab WSH_UTIL_CORE.ID_TAB_TYPE;
163: l_temp NUMBER;
164: l_msg_count NUMBER;

Line 222: l_new_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT;

218: l_gc3_is_installed := WSH_UTIL_CORE.GC3_IS_INSTALLED;
219: END IF;
220: -- Initialize these as they are used in UPDATE statement and in cases where
221: -- these are not actually populated
222: l_new_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT;
223: l_new_version_number_tab(1) := 1;
224: -- end of OTM R12, glog proj
225:
226: IF ((WSH_UTIL_CORE.TP_IS_INSTALLED = 'Y' OR

Line 334: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(l_del_cur.delivery_id));

330: and l_det_cur.container_flag='N'
331: AND l_gc3_is_installed = 'N' THEN -- OTM R12
332: --do not allow lines in thrid party instance to be set to include for planning
333: FND_MESSAGE.SET_NAME('WSH','WSH_IGNORE_PLAN_TPW_ERROR');
334: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(l_del_cur.delivery_id));
335: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
336: l_num_error:=l_num_error+1;
337: GOTO next_trip;
338: ELSE

Line 501: UPDATE wsh_new_deliveries

497:
498: --update dels
499: IF l_tmp_del_ids is not null and l_tmp_del_ids.COUNT>0 THEN
500: FORALL i in l_tmp_del_ids.FIRST..l_tmp_del_ids.LAST
501: UPDATE wsh_new_deliveries
502: SET ignore_for_planning = l_ignoreplan,
503: last_update_date = sysdate,
504: last_updated_by = FND_GLOBAL.USER_ID
505: WHERE delivery_id=l_tmp_del_ids(i);

Line 521: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.TABLE_TO_RECORD',WSH_DEBUG_SV.C_PROC_LEVEL);

517: FOR i in l_tmp_del_ids.FIRST..l_tmp_del_ids.LAST LOOP
518: --{
519: --
520: IF l_debug_on THEN
521: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.TABLE_TO_RECORD',WSH_DEBUG_SV.C_PROC_LEVEL);
522: END IF;
523: --
524: WSH_NEW_DELIVERIES_PVT.TABLE_TO_RECORD(p_delivery_id => l_tmp_del_ids(i),
525: x_delivery_rec => l_delivery_info,

Line 524: WSH_NEW_DELIVERIES_PVT.TABLE_TO_RECORD(p_delivery_id => l_tmp_del_ids(i),

520: IF l_debug_on THEN
521: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.TABLE_TO_RECORD',WSH_DEBUG_SV.C_PROC_LEVEL);
522: END IF;
523: --
524: WSH_NEW_DELIVERIES_PVT.TABLE_TO_RECORD(p_delivery_id => l_tmp_del_ids(i),
525: x_delivery_rec => l_delivery_info,
526: x_return_status => l_return_status);
527: --
528: IF l_debug_on THEN

Line 566: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.UPDATE_DELIVERY',WSH_DEBUG_SV.C_PROC_LEVEL);

562: goto next_trip;
563: END IF;
564: --
565: IF l_debug_on THEN
566: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.UPDATE_DELIVERY',WSH_DEBUG_SV.C_PROC_LEVEL);
567: END IF;
568: --
569: WSH_NEW_DELIVERIES_PVT.UPDATE_DELIVERY( p_rowid => NULL,
570: p_delivery_info => l_delivery_info,

Line 569: WSH_NEW_DELIVERIES_PVT.UPDATE_DELIVERY( p_rowid => NULL,

565: IF l_debug_on THEN
566: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.UPDATE_DELIVERY',WSH_DEBUG_SV.C_PROC_LEVEL);
567: END IF;
568: --
569: WSH_NEW_DELIVERIES_PVT.UPDATE_DELIVERY( p_rowid => NULL,
570: p_delivery_info => l_delivery_info,
571: x_return_status => l_return_status);
572: --
573: IF l_debug_on THEN

Line 724: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(l_del_cur.delivery_id));

720: and l_det_cur.container_flag='N'
721: and l_gc3_is_installed = 'N' THEN -- OTM R12
722: --do not allow lines in thrid party instance to be set to include for planning
723: FND_MESSAGE.SET_NAME('WSH','WSH_IGNORE_PLAN_TPW_ERROR');
724: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(l_del_cur.delivery_id));
725: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
726: l_num_error:=l_num_error+1;
727: GOTO next_del;
728: ELSE

Line 871: FND_MESSAGE.SET_TOKEN('NAME',wsh_new_deliveries_pvt.get_name(p_in_ids(i)));

867: ROLLBACK to before_update;
868: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
869: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
870: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
871: FND_MESSAGE.SET_TOKEN('NAME',wsh_new_deliveries_pvt.get_name(p_in_ids(i)));
872: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
873: l_num_error:=l_num_error+1;
874: GOTO next_del;
875: END IF;

Line 936: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) =

932: WSH_DEBUG_SV.log(l_module_name,'Delivery Tms_interface_flag',l_delivery_info.tms_interface_flag);
933: END IF;
934:
935: IF (nvl(l_delivery_info.tms_interface_flag,
936: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) =
937: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT
938: AND l_is_delivery_empty = 'N') THEN--{
939: l_new_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED;
940: l_new_version_number_tab(1) :=

Line 937: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT

933: END IF;
934:
935: IF (nvl(l_delivery_info.tms_interface_flag,
936: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) =
937: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT
938: AND l_is_delivery_empty = 'N') THEN--{
939: l_new_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED;
940: l_new_version_number_tab(1) :=
941: nvl(l_delivery_info.tms_version_number, 1) + 1;

Line 939: l_new_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED;

935: IF (nvl(l_delivery_info.tms_interface_flag,
936: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) =
937: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT
938: AND l_is_delivery_empty = 'N') THEN--{
939: l_new_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED;
940: l_new_version_number_tab(1) :=
941: nvl(l_delivery_info.tms_version_number, 1) + 1;
942: ELSIF
943: ((nvl(l_delivery_info.tms_interface_flag,

Line 944: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)

940: l_new_version_number_tab(1) :=
941: nvl(l_delivery_info.tms_version_number, 1) + 1;
942: ELSIF
943: ((nvl(l_delivery_info.tms_interface_flag,
944: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)
945: IN (WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
946: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS))
947: AND l_is_delivery_empty = 'N') THEN
948: l_new_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;

Line 945: IN (WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,

941: nvl(l_delivery_info.tms_version_number, 1) + 1;
942: ELSIF
943: ((nvl(l_delivery_info.tms_interface_flag,
944: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)
945: IN (WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
946: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS))
947: AND l_is_delivery_empty = 'N') THEN
948: l_new_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;
949: l_new_version_number_tab(1) :=

Line 946: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS))

942: ELSIF
943: ((nvl(l_delivery_info.tms_interface_flag,
944: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)
945: IN (WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
946: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS))
947: AND l_is_delivery_empty = 'N') THEN
948: l_new_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;
949: l_new_version_number_tab(1) :=
950: nvl(l_delivery_info.tms_version_number, 1) + 1;

Line 948: l_new_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;

944: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)
945: IN (WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
946: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS))
947: AND l_is_delivery_empty = 'N') THEN
948: l_new_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;
949: l_new_version_number_tab(1) :=
950: nvl(l_delivery_info.tms_version_number, 1) + 1;
951: ELSE
952: l_tms_update := 'N';

Line 957: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) IN

953: END IF;--}
954: ELSIF (l_ignoreplan = 'Y') THEN--} {
955:
956: IF (nvl(l_delivery_info.tms_interface_flag,
957: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) IN
958: (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
959: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED,
960: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
961: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,

Line 958: (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,

954: ELSIF (l_ignoreplan = 'Y') THEN--} {
955:
956: IF (nvl(l_delivery_info.tms_interface_flag,
957: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) IN
958: (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
959: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED,
960: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
961: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
962: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED)) THEN

Line 959: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED,

955:
956: IF (nvl(l_delivery_info.tms_interface_flag,
957: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) IN
958: (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
959: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED,
960: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
961: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
962: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED)) THEN
963: l_new_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED;

Line 960: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,

956: IF (nvl(l_delivery_info.tms_interface_flag,
957: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) IN
958: (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
959: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED,
960: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
961: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
962: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED)) THEN
963: l_new_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED;
964: l_new_version_number_tab(1) :=

Line 961: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,

957: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) IN
958: (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
959: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED,
960: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
961: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
962: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED)) THEN
963: l_new_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED;
964: l_new_version_number_tab(1) :=
965: nvl(l_delivery_info.tms_version_number, 1) + 1;

Line 962: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED)) THEN

958: (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
959: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED,
960: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
961: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
962: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED)) THEN
963: l_new_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED;
964: l_new_version_number_tab(1) :=
965: nvl(l_delivery_info.tms_version_number, 1) + 1;
966: ELSIF (nvl(l_delivery_info.tms_interface_flag,

Line 963: l_new_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED;

959: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED,
960: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
961: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
962: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED)) THEN
963: l_new_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED;
964: l_new_version_number_tab(1) :=
965: nvl(l_delivery_info.tms_version_number, 1) + 1;
966: ELSIF (nvl(l_delivery_info.tms_interface_flag,
967: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) =

Line 967: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) =

963: l_new_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED;
964: l_new_version_number_tab(1) :=
965: nvl(l_delivery_info.tms_version_number, 1) + 1;
966: ELSIF (nvl(l_delivery_info.tms_interface_flag,
967: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) =
968: (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED)) THEN
969: l_new_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT;
970: l_new_version_number_tab(1) :=
971: nvl(l_delivery_info.tms_version_number, 1);

Line 968: (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED)) THEN

964: l_new_version_number_tab(1) :=
965: nvl(l_delivery_info.tms_version_number, 1) + 1;
966: ELSIF (nvl(l_delivery_info.tms_interface_flag,
967: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) =
968: (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED)) THEN
969: l_new_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT;
970: l_new_version_number_tab(1) :=
971: nvl(l_delivery_info.tms_version_number, 1);
972: ELSE

Line 969: l_new_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT;

965: nvl(l_delivery_info.tms_version_number, 1) + 1;
966: ELSIF (nvl(l_delivery_info.tms_interface_flag,
967: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) =
968: (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED)) THEN
969: l_new_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT;
970: l_new_version_number_tab(1) :=
971: nvl(l_delivery_info.tms_version_number, 1);
972: ELSE
973: l_tms_update := 'N';

Line 1040: UPDATE wsh_new_deliveries

1036: END IF;--}
1037: -- end of OTM R12, glog proj
1038:
1039: --update dels
1040: UPDATE wsh_new_deliveries
1041: SET ignore_for_planning = l_ignoreplan,
1042: -- OTM R12, glog proj, based on the l_tms_update flag set above
1043: tms_interface_flag = DECODE(l_tms_update,
1044: 'Y', l_new_interface_flag_tab(1),

Line 1059: FND_MESSAGE.SET_TOKEN('NAME',wsh_new_deliveries_pvt.get_name(p_in_ids(i)));

1055: ROLLBACK to before_update;
1056: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
1057: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
1058: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1059: FND_MESSAGE.SET_TOKEN('NAME',wsh_new_deliveries_pvt.get_name(p_in_ids(i)));
1060: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1061: l_num_error:=l_num_error+1;
1062: goto next_del;
1063: ELSE --Added for bug 7611042 .More than zero rows updated. So calling the API to update the hash string

Line 1067: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.TABLE_TO_RECORD',WSH_DEBUG_SV.C_PROC_LEVEL);

1063: ELSE --Added for bug 7611042 .More than zero rows updated. So calling the API to update the hash string
1064: --{
1065: --
1066: IF l_debug_on THEN
1067: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.TABLE_TO_RECORD',WSH_DEBUG_SV.C_PROC_LEVEL);
1068: END IF;
1069: --
1070: WSH_NEW_DELIVERIES_PVT.TABLE_TO_RECORD(p_delivery_id => p_in_ids(i),
1071: x_delivery_rec => l_delivery_info,

Line 1070: WSH_NEW_DELIVERIES_PVT.TABLE_TO_RECORD(p_delivery_id => p_in_ids(i),

1066: IF l_debug_on THEN
1067: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.TABLE_TO_RECORD',WSH_DEBUG_SV.C_PROC_LEVEL);
1068: END IF;
1069: --
1070: WSH_NEW_DELIVERIES_PVT.TABLE_TO_RECORD(p_delivery_id => p_in_ids(i),
1071: x_delivery_rec => l_delivery_info,
1072: x_return_status => l_return_status);
1073: --
1074: IF l_debug_on THEN

Line 1083: FND_MESSAGE.SET_TOKEN('NAME',wsh_new_deliveries_pvt.get_name(p_in_ids(i)));

1079: rollback to before_update;
1080: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
1081: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
1082: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1083: FND_MESSAGE.SET_TOKEN('NAME',wsh_new_deliveries_pvt.get_name(p_in_ids(i)));
1084: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1085: l_num_error:=l_num_error+1;
1086: goto next_del;
1087: END IF;

Line 1105: FND_MESSAGE.SET_TOKEN('NAME',wsh_new_deliveries_pvt.get_name(p_in_ids(i)));

1101: rollback to before_update;
1102: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
1103: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
1104: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1105: FND_MESSAGE.SET_TOKEN('NAME',wsh_new_deliveries_pvt.get_name(p_in_ids(i)));
1106: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1107: l_num_error:=l_num_error+1;
1108: goto next_del;
1109: END IF;

Line 1112: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.UPDATE_DELIVERY',WSH_DEBUG_SV.C_PROC_LEVEL);

1108: goto next_del;
1109: END IF;
1110: --
1111: IF l_debug_on THEN
1112: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.UPDATE_DELIVERY',WSH_DEBUG_SV.C_PROC_LEVEL);
1113: END IF;
1114: --
1115: WSH_NEW_DELIVERIES_PVT.UPDATE_DELIVERY( p_rowid => NULL,
1116: p_delivery_info => l_delivery_info,

Line 1115: WSH_NEW_DELIVERIES_PVT.UPDATE_DELIVERY( p_rowid => NULL,

1111: IF l_debug_on THEN
1112: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.UPDATE_DELIVERY',WSH_DEBUG_SV.C_PROC_LEVEL);
1113: END IF;
1114: --
1115: WSH_NEW_DELIVERIES_PVT.UPDATE_DELIVERY( p_rowid => NULL,
1116: p_delivery_info => l_delivery_info,
1117: x_return_status => l_return_status);
1118: --
1119: IF l_debug_on THEN

Line 1128: FND_MESSAGE.SET_TOKEN('NAME',wsh_new_deliveries_pvt.get_name(p_in_ids(i)));

1124: rollback to before_update;
1125: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
1126: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
1127: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1128: FND_MESSAGE.SET_TOKEN('NAME',wsh_new_deliveries_pvt.get_name(p_in_ids(i)));
1129: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1130: l_num_error:=l_num_error+1;
1131: goto next_del;
1132: END IF;

Line 1527: wsh_new_deliveries dl

1523: SELECT dg.delivery_id
1524: FROM wsh_trips t,
1525: wsh_trip_stops st,
1526: wsh_delivery_legs dg,
1527: wsh_new_deliveries dl
1528: WHERE t.trip_id = c_tripid AND
1529: st.trip_id = t.trip_id AND
1530: dg.pick_up_stop_id = st.stop_id AND
1531: dg.delivery_id=dl.delivery_id AND

Line 1584: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(del_cur.delivery_id));

1580: x_return_status => x_return_status);
1581: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) OR (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1582: rollback to before_firm;
1583: FND_MESSAGE.SET_NAME('WSH','WSH_DELIVERY_CANNOT_FIRM');
1584: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(del_cur.delivery_id));
1585: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1586: wsh_util_core.add_message(x_return_status);
1587: IF l_debug_on THEN
1588: WSH_DEBUG_SV.pop(l_module_name);

Line 1594: UPDATE wsh_new_deliveries

1590: RETURN;
1591: END IF;
1592:
1593: l_deliveries_exist:='Y';
1594: UPDATE wsh_new_deliveries
1595: SET planned_flag = c_routing_firm_flag,
1596: last_update_date = sysdate,
1597: last_updated_by = FND_GLOBAL.USER_ID
1598: WHERE delivery_id = del_cur.delivery_id;

Line 1604: FND_MESSAGE.SET_TOKEN('NAME',wsh_new_deliveries_pvt.get_name(del_cur.delivery_id));

1600: IF (SQL%NOTFOUND) THEN
1601: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');
1602: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
1603: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1604: FND_MESSAGE.SET_TOKEN('NAME',wsh_new_deliveries_pvt.get_name(del_cur.delivery_id));
1605: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1606: wsh_util_core.add_message(x_return_status);
1607: IF l_debug_on THEN
1608: WSH_DEBUG_SV.pop(l_module_name);

Line 1740: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_entity_id));

1736:
1737: --if l_plannedflag is null, no trip is associated => delivery can't be firmed
1738: IF l_plannedflag IS null THEN
1739: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_DELIVERY_ERROR');
1740: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_entity_id));
1741: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1742: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1743: IF l_debug_on THEN
1744: WSH_DEBUG_SV.pop(l_module_name);

Line 1749: UPDATE wsh_new_deliveries

1745: END IF;
1746: rollback to before_firm;
1747: RETURN;
1748: ELSE
1749: UPDATE wsh_new_deliveries
1750: SET planned_flag = c_routing_firm_flag,
1751: last_update_date = sysdate,
1752: last_updated_by = FND_GLOBAL.USER_ID
1753: WHERE delivery_id = p_entity_id;

Line 1810: wsh_new_deliveries nd

1806: CURSOR c_deliveries IS
1807: SELECT dg.delivery_id
1808: FROM wsh_trip_stops st,
1809: wsh_delivery_legs dg,
1810: wsh_new_deliveries nd
1811: WHERE st.trip_id = p_entity_id AND
1812: dg.pick_up_stop_id = st.stop_id AND
1813: nd.delivery_id=dg.delivery_id AND
1814: nd.planned_flag='F';

Line 1912: UPDATE wsh_new_deliveries

1908: FOR del_cur IN c_deliveries LOOP
1909: --set all deliveries as 'PLAN' irrespective of whether trip is being reduced to planned/unplanned
1910: --as unplanned trip may have planned deliveries, unless (bug 3294663) the trip is being set to RF
1911: --from RCF (l_action = 'Y') in which case the delivery will remain at RCF.
1912: UPDATE wsh_new_deliveries
1913: SET planned_flag = decode(l_action, 'Y', planned_flag, 'Y'),
1914: last_update_date = sysdate,
1915: last_updated_by = FND_GLOBAL.USER_ID
1916: WHERE delivery_id = del_cur.delivery_id;

Line 1922: FND_MESSAGE.SET_TOKEN('NAME',wsh_new_deliveries_pvt.get_name(del_cur.delivery_id));

1918: IF (SQL%NOTFOUND) THEN
1919: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');
1920: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
1921: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1922: FND_MESSAGE.SET_TOKEN('NAME',wsh_new_deliveries_pvt.get_name(del_cur.delivery_id));
1923: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1924: wsh_util_core.add_message(x_return_status);
1925: IF l_debug_on THEN
1926: WSH_DEBUG_SV.pop(l_module_name);

Line 1959: UPDATE wsh_new_deliveries

1955: END LOOP;
1956: END IF; --trip plan flag = F or (trip_plan=Y and del plan flag=F)
1957: ELSIF p_entity='DLVY' THEN
1958:
1959: UPDATE wsh_new_deliveries
1960: SET planned_flag = l_action,
1961: last_update_date = sysdate,
1962: last_updated_by = FND_GLOBAL.USER_ID
1963: WHERE delivery_id = p_entity_id;

Line 2751: FROM WSH_NEW_DELIVERIES

2747: latest_dropoff_date,
2748: initial_pickup_date,
2749: ultimate_dropoff_date,
2750: ignore_for_planning --OTM R12
2751: FROM WSH_NEW_DELIVERIES
2752: WHERE delivery_id = p_delivery_id
2753: FOR UPDATE NOWAIT;
2754:
2755: l_delivery_rec get_delivery_for_lock%rowtype;

Line 2788: FROM wsh_new_deliveries

2784: AND delivery_id =p_delivery_id;
2785:
2786: CURSOR is_inbound_dropshp(p_delivery_id IN NUMBER) IS
2787: SELECT shipment_direction
2788: FROM wsh_new_deliveries
2789: WHERE delivery_id =p_delivery_id
2790: AND shipment_direction IN ('I','D');
2791:
2792: l_global_param_rec_type WSH_SHIPPING_PARAMS_PVT.Global_Parameters_Rec_Typ;

Line 2795: l_delivery_info_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;

2791:
2792: l_global_param_rec_type WSH_SHIPPING_PARAMS_PVT.Global_Parameters_Rec_Typ;
2793:
2794: --OTM R12, glog proj
2795: l_delivery_info_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
2796: l_delivery_info WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
2797: l_new_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
2798: l_tms_update VARCHAR2(1);
2799: l_trip_not_found VARCHAR2(1);

Line 2796: l_delivery_info WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;

2792: l_global_param_rec_type WSH_SHIPPING_PARAMS_PVT.Global_Parameters_Rec_Typ;
2793:
2794: --OTM R12, glog proj
2795: l_delivery_info_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
2796: l_delivery_info WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
2797: l_new_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
2798: l_tms_update VARCHAR2(1);
2799: l_trip_not_found VARCHAR2(1);
2800: l_trip_info_rec WSH_DELIVERY_VALIDATIONS.trip_info_rec_type;

Line 2801: l_tms_version_number WSH_NEW_DELIVERIES.TMS_VERSION_NUMBER%TYPE;

2797: l_new_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
2798: l_tms_update VARCHAR2(1);
2799: l_trip_not_found VARCHAR2(1);
2800: l_trip_info_rec WSH_DELIVERY_VALIDATIONS.trip_info_rec_type;
2801: l_tms_version_number WSH_NEW_DELIVERIES.TMS_VERSION_NUMBER%TYPE;
2802: l_return_status VARCHAR2(1);
2803: l_gc3_is_installed VARCHAR2(1);
2804: --l_sysdate DATE;
2805: e_gc3_exception EXCEPTION;

Line 2834: l_new_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT;

2830: l_gc3_is_installed := WSH_UTIL_CORE.GC3_IS_INSTALLED;
2831: END IF;
2832: -- Initialize these as they are used in UPDATE statement and in cases where
2833: -- these are not actually populated
2834: l_new_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT;
2835: -- end of OTM R12, glog proj
2836:
2837: IF l_debug_on THEN
2838: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT. Get_Global_Parameters',WSH_DEBUG_SV.C_PROC_LEVEL);

Line 3103: IF (NVL(l_delivery_info.tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) IN

3099: nvl(l_delivery_info.EARLIEST_DROPOFF_DATE, fnd_api.g_miss_date) <> nvl(l_earliest_mdropoff_date, fnd_api.g_miss_date) OR
3100: nvl(l_delivery_info.LATEST_DROPOFF_DATE, fnd_api.g_miss_date) <> nvl(l_latest_mdropoff_date, fnd_api.g_miss_date)
3101: ) THEN--{
3102:
3103: IF (NVL(l_delivery_info.tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) IN
3104: (WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT,
3105: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,
3106: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
3107: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,

Line 3104: (WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT,

3100: nvl(l_delivery_info.LATEST_DROPOFF_DATE, fnd_api.g_miss_date) <> nvl(l_latest_mdropoff_date, fnd_api.g_miss_date)
3101: ) THEN--{
3102:
3103: IF (NVL(l_delivery_info.tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) IN
3104: (WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT,
3105: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,
3106: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
3107: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
3108: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED)) THEN

Line 3105: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,

3101: ) THEN--{
3102:
3103: IF (NVL(l_delivery_info.tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) IN
3104: (WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT,
3105: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,
3106: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
3107: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
3108: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED)) THEN
3109: l_tms_update := 'N';

Line 3106: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,

3102:
3103: IF (NVL(l_delivery_info.tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) IN
3104: (WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT,
3105: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,
3106: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
3107: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
3108: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED)) THEN
3109: l_tms_update := 'N';
3110: ELSE

Line 3107: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,

3103: IF (NVL(l_delivery_info.tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) IN
3104: (WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT,
3105: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,
3106: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
3107: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
3108: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED)) THEN
3109: l_tms_update := 'N';
3110: ELSE
3111: l_tms_update := 'Y';

Line 3108: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED)) THEN

3104: (WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT,
3105: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,
3106: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
3107: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
3108: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED)) THEN
3109: l_tms_update := 'N';
3110: ELSE
3111: l_tms_update := 'Y';
3112: l_new_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;

Line 3112: l_new_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;

3108: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED)) THEN
3109: l_tms_update := 'N';
3110: ELSE
3111: l_tms_update := 'Y';
3112: l_new_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;
3113: l_tms_version_number := NVL(l_delivery_info.tms_version_number, 1) + 1;
3114: END IF;
3115: ELSE
3116: l_tms_update := 'N';

Line 3126: UPDATE WSH_NEW_DELIVERIES

3122: WSH_DEBUG_SV.log(l_module_name,'l_tms_update flag', l_tms_update);
3123: END IF;
3124: --END OTM R12
3125:
3126: UPDATE WSH_NEW_DELIVERIES
3127: SET earliest_pickup_date = l_earliest_mpickup_date,
3128: earliest_dropoff_date = l_earliest_mdropoff_date,
3129: latest_pickup_date = l_latest_mpickup_date,
3130: latest_dropoff_date = l_latest_mdropoff_date,

Line 3136: NVL(TMS_INTERFACE_FLAG, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)),

3132: ultimate_dropoff_date = l_ultimate_mdropoff_date,
3133: --OTM R12, glog proj
3134: TMS_INTERFACE_FLAG = DECODE(l_tms_update,
3135: 'Y', l_new_interface_flag_tab(1),
3136: NVL(TMS_INTERFACE_FLAG, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)),
3137: TMS_VERSION_NUMBER = DECODE(l_tms_update,
3138: 'Y', l_tms_version_number,
3139: NVL(tms_version_number, 1)),
3140: --