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 651: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(l_del_cur.delivery_id));

647: and l_det_cur.container_flag='N'
648: and l_gc3_is_installed = 'N' THEN -- OTM R12
649: --do not allow lines in thrid party instance to be set to include for planning
650: FND_MESSAGE.SET_NAME('WSH','WSH_IGNORE_PLAN_TPW_ERROR');
651: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(l_del_cur.delivery_id));
652: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
653: l_num_error:=l_num_error+1;
654: GOTO next_del;
655: ELSE

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

794: ROLLBACK to before_update;
795: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
796: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
797: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
798: FND_MESSAGE.SET_TOKEN('NAME',wsh_new_deliveries_pvt.get_name(p_in_ids(i)));
799: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
800: l_num_error:=l_num_error+1;
801: GOTO next_del;
802: END IF;

Line 863: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) =

859: WSH_DEBUG_SV.log(l_module_name,'Delivery Tms_interface_flag',l_delivery_info.tms_interface_flag);
860: END IF;
861:
862: IF (nvl(l_delivery_info.tms_interface_flag,
863: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) =
864: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT
865: AND l_is_delivery_empty = 'N') THEN--{
866: l_new_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED;
867: l_new_version_number_tab(1) :=

Line 864: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT

860: END IF;
861:
862: IF (nvl(l_delivery_info.tms_interface_flag,
863: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) =
864: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT
865: AND l_is_delivery_empty = 'N') THEN--{
866: l_new_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED;
867: l_new_version_number_tab(1) :=
868: nvl(l_delivery_info.tms_version_number, 1) + 1;

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

862: IF (nvl(l_delivery_info.tms_interface_flag,
863: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) =
864: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT
865: AND l_is_delivery_empty = 'N') THEN--{
866: l_new_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED;
867: l_new_version_number_tab(1) :=
868: nvl(l_delivery_info.tms_version_number, 1) + 1;
869: ELSIF
870: ((nvl(l_delivery_info.tms_interface_flag,

Line 871: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)

867: l_new_version_number_tab(1) :=
868: nvl(l_delivery_info.tms_version_number, 1) + 1;
869: ELSIF
870: ((nvl(l_delivery_info.tms_interface_flag,
871: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)
872: IN (WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
873: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS))
874: AND l_is_delivery_empty = 'N') THEN
875: l_new_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;

Line 872: IN (WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,

868: nvl(l_delivery_info.tms_version_number, 1) + 1;
869: ELSIF
870: ((nvl(l_delivery_info.tms_interface_flag,
871: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)
872: IN (WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
873: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS))
874: AND l_is_delivery_empty = 'N') THEN
875: l_new_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;
876: l_new_version_number_tab(1) :=

Line 873: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS))

869: ELSIF
870: ((nvl(l_delivery_info.tms_interface_flag,
871: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)
872: IN (WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
873: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS))
874: AND l_is_delivery_empty = 'N') THEN
875: l_new_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;
876: l_new_version_number_tab(1) :=
877: nvl(l_delivery_info.tms_version_number, 1) + 1;

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

871: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)
872: IN (WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
873: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS))
874: AND l_is_delivery_empty = 'N') THEN
875: l_new_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;
876: l_new_version_number_tab(1) :=
877: nvl(l_delivery_info.tms_version_number, 1) + 1;
878: ELSE
879: l_tms_update := 'N';

Line 884: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) IN

880: END IF;--}
881: ELSIF (l_ignoreplan = 'Y') THEN--} {
882:
883: IF (nvl(l_delivery_info.tms_interface_flag,
884: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) IN
885: (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
886: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED,
887: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
888: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,

Line 885: (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,

881: ELSIF (l_ignoreplan = 'Y') THEN--} {
882:
883: IF (nvl(l_delivery_info.tms_interface_flag,
884: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) IN
885: (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
886: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED,
887: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
888: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
889: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED)) THEN

Line 886: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED,

882:
883: IF (nvl(l_delivery_info.tms_interface_flag,
884: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) IN
885: (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
886: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED,
887: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
888: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
889: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED)) THEN
890: l_new_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED;

Line 887: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,

883: IF (nvl(l_delivery_info.tms_interface_flag,
884: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) IN
885: (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
886: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED,
887: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
888: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
889: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED)) THEN
890: l_new_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED;
891: l_new_version_number_tab(1) :=

Line 888: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,

884: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) IN
885: (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
886: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED,
887: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
888: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
889: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED)) THEN
890: l_new_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED;
891: l_new_version_number_tab(1) :=
892: nvl(l_delivery_info.tms_version_number, 1) + 1;

Line 889: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED)) THEN

885: (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
886: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED,
887: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
888: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
889: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED)) THEN
890: l_new_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED;
891: l_new_version_number_tab(1) :=
892: nvl(l_delivery_info.tms_version_number, 1) + 1;
893: ELSIF (nvl(l_delivery_info.tms_interface_flag,

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

886: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED,
887: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
888: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
889: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED)) THEN
890: l_new_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED;
891: l_new_version_number_tab(1) :=
892: nvl(l_delivery_info.tms_version_number, 1) + 1;
893: ELSIF (nvl(l_delivery_info.tms_interface_flag,
894: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) =

Line 894: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) =

890: l_new_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED;
891: l_new_version_number_tab(1) :=
892: nvl(l_delivery_info.tms_version_number, 1) + 1;
893: ELSIF (nvl(l_delivery_info.tms_interface_flag,
894: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) =
895: (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED)) THEN
896: l_new_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT;
897: l_new_version_number_tab(1) :=
898: nvl(l_delivery_info.tms_version_number, 1);

Line 895: (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED)) THEN

891: l_new_version_number_tab(1) :=
892: nvl(l_delivery_info.tms_version_number, 1) + 1;
893: ELSIF (nvl(l_delivery_info.tms_interface_flag,
894: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) =
895: (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED)) THEN
896: l_new_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT;
897: l_new_version_number_tab(1) :=
898: nvl(l_delivery_info.tms_version_number, 1);
899: ELSE

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

892: nvl(l_delivery_info.tms_version_number, 1) + 1;
893: ELSIF (nvl(l_delivery_info.tms_interface_flag,
894: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) =
895: (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED)) THEN
896: l_new_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT;
897: l_new_version_number_tab(1) :=
898: nvl(l_delivery_info.tms_version_number, 1);
899: ELSE
900: l_tms_update := 'N';

Line 967: UPDATE wsh_new_deliveries

963: END IF;--}
964: -- end of OTM R12, glog proj
965:
966: --update dels
967: UPDATE wsh_new_deliveries
968: SET ignore_for_planning = l_ignoreplan,
969: -- OTM R12, glog proj, based on the l_tms_update flag set above
970: tms_interface_flag = DECODE(l_tms_update,
971: 'Y', l_new_interface_flag_tab(1),

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

982: ROLLBACK to before_update;
983: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
984: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
985: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
986: FND_MESSAGE.SET_TOKEN('NAME',wsh_new_deliveries_pvt.get_name(p_in_ids(i)));
987: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
988: l_num_error:=l_num_error+1;
989: END IF;
990:

Line 1382: wsh_new_deliveries dl

1378: SELECT dg.delivery_id
1379: FROM wsh_trips t,
1380: wsh_trip_stops st,
1381: wsh_delivery_legs dg,
1382: wsh_new_deliveries dl
1383: WHERE t.trip_id = c_tripid AND
1384: st.trip_id = t.trip_id AND
1385: dg.pick_up_stop_id = st.stop_id AND
1386: dg.delivery_id=dl.delivery_id AND

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

1435: x_return_status => x_return_status);
1436: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) OR (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1437: rollback to before_firm;
1438: FND_MESSAGE.SET_NAME('WSH','WSH_DELIVERY_CANNOT_FIRM');
1439: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(del_cur.delivery_id));
1440: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1441: wsh_util_core.add_message(x_return_status);
1442: IF l_debug_on THEN
1443: WSH_DEBUG_SV.pop(l_module_name);

Line 1449: UPDATE wsh_new_deliveries

1445: RETURN;
1446: END IF;
1447:
1448: l_deliveries_exist:='Y';
1449: UPDATE wsh_new_deliveries
1450: SET planned_flag = c_routing_firm_flag,
1451: last_update_date = sysdate,
1452: last_updated_by = FND_GLOBAL.USER_ID
1453: WHERE delivery_id = del_cur.delivery_id;

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

1455: IF (SQL%NOTFOUND) THEN
1456: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');
1457: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
1458: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1459: FND_MESSAGE.SET_TOKEN('NAME',wsh_new_deliveries_pvt.get_name(del_cur.delivery_id));
1460: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1461: wsh_util_core.add_message(x_return_status);
1462: IF l_debug_on THEN
1463: WSH_DEBUG_SV.pop(l_module_name);

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

1591:
1592: --if l_plannedflag is null, no trip is associated => delivery can't be firmed
1593: IF l_plannedflag IS null THEN
1594: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_DELIVERY_ERROR');
1595: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_entity_id));
1596: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1597: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1598: IF l_debug_on THEN
1599: WSH_DEBUG_SV.pop(l_module_name);

Line 1604: UPDATE wsh_new_deliveries

1600: END IF;
1601: rollback to before_firm;
1602: RETURN;
1603: ELSE
1604: UPDATE wsh_new_deliveries
1605: SET planned_flag = c_routing_firm_flag,
1606: last_update_date = sysdate,
1607: last_updated_by = FND_GLOBAL.USER_ID
1608: WHERE delivery_id = p_entity_id;

Line 1665: wsh_new_deliveries nd

1661: CURSOR c_deliveries IS
1662: SELECT dg.delivery_id
1663: FROM wsh_trip_stops st,
1664: wsh_delivery_legs dg,
1665: wsh_new_deliveries nd
1666: WHERE st.trip_id = p_entity_id AND
1667: dg.pick_up_stop_id = st.stop_id AND
1668: nd.delivery_id=dg.delivery_id AND
1669: nd.planned_flag='F';

Line 1767: UPDATE wsh_new_deliveries

1763: FOR del_cur IN c_deliveries LOOP
1764: --set all deliveries as 'PLAN' irrespective of whether trip is being reduced to planned/unplanned
1765: --as unplanned trip may have planned deliveries, unless (bug 3294663) the trip is being set to RF
1766: --from RCF (l_action = 'Y') in which case the delivery will remain at RCF.
1767: UPDATE wsh_new_deliveries
1768: SET planned_flag = decode(l_action, 'Y', planned_flag, 'Y'),
1769: last_update_date = sysdate,
1770: last_updated_by = FND_GLOBAL.USER_ID
1771: WHERE delivery_id = del_cur.delivery_id;

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

1773: IF (SQL%NOTFOUND) THEN
1774: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');
1775: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
1776: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1777: FND_MESSAGE.SET_TOKEN('NAME',wsh_new_deliveries_pvt.get_name(del_cur.delivery_id));
1778: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1779: wsh_util_core.add_message(x_return_status);
1780: IF l_debug_on THEN
1781: WSH_DEBUG_SV.pop(l_module_name);

Line 1814: UPDATE wsh_new_deliveries

1810: END LOOP;
1811: END IF; --trip plan flag = F or (trip_plan=Y and del plan flag=F)
1812: ELSIF p_entity='DLVY' THEN
1813:
1814: UPDATE wsh_new_deliveries
1815: SET planned_flag = l_action,
1816: last_update_date = sysdate,
1817: last_updated_by = FND_GLOBAL.USER_ID
1818: WHERE delivery_id = p_entity_id;

Line 2604: FROM WSH_NEW_DELIVERIES

2600: latest_dropoff_date,
2601: initial_pickup_date,
2602: ultimate_dropoff_date,
2603: ignore_for_planning --OTM R12
2604: FROM WSH_NEW_DELIVERIES
2605: WHERE delivery_id = p_delivery_id
2606: FOR UPDATE NOWAIT;
2607:
2608: l_delivery_rec get_delivery_for_lock%rowtype;

Line 2641: FROM wsh_new_deliveries

2637: AND delivery_id =p_delivery_id;
2638:
2639: CURSOR is_inbound_dropshp(p_delivery_id IN NUMBER) IS
2640: SELECT shipment_direction
2641: FROM wsh_new_deliveries
2642: WHERE delivery_id =p_delivery_id
2643: AND shipment_direction IN ('I','D');
2644:
2645: l_global_param_rec_type WSH_SHIPPING_PARAMS_PVT.Global_Parameters_Rec_Typ;

Line 2648: l_delivery_info_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;

2644:
2645: l_global_param_rec_type WSH_SHIPPING_PARAMS_PVT.Global_Parameters_Rec_Typ;
2646:
2647: --OTM R12, glog proj
2648: l_delivery_info_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
2649: l_delivery_info WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
2650: l_new_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
2651: l_tms_update VARCHAR2(1);
2652: l_trip_not_found VARCHAR2(1);

Line 2649: l_delivery_info WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;

2645: l_global_param_rec_type WSH_SHIPPING_PARAMS_PVT.Global_Parameters_Rec_Typ;
2646:
2647: --OTM R12, glog proj
2648: l_delivery_info_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
2649: l_delivery_info WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
2650: l_new_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
2651: l_tms_update VARCHAR2(1);
2652: l_trip_not_found VARCHAR2(1);
2653: l_trip_info_rec WSH_DELIVERY_VALIDATIONS.trip_info_rec_type;

Line 2654: l_tms_version_number WSH_NEW_DELIVERIES.TMS_VERSION_NUMBER%TYPE;

2650: l_new_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
2651: l_tms_update VARCHAR2(1);
2652: l_trip_not_found VARCHAR2(1);
2653: l_trip_info_rec WSH_DELIVERY_VALIDATIONS.trip_info_rec_type;
2654: l_tms_version_number WSH_NEW_DELIVERIES.TMS_VERSION_NUMBER%TYPE;
2655: l_return_status VARCHAR2(1);
2656: l_gc3_is_installed VARCHAR2(1);
2657: --l_sysdate DATE;
2658: e_gc3_exception EXCEPTION;

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

2683: l_gc3_is_installed := WSH_UTIL_CORE.GC3_IS_INSTALLED;
2684: END IF;
2685: -- Initialize these as they are used in UPDATE statement and in cases where
2686: -- these are not actually populated
2687: l_new_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT;
2688: -- end of OTM R12, glog proj
2689:
2690: IF l_debug_on THEN
2691: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT. Get_Global_Parameters',WSH_DEBUG_SV.C_PROC_LEVEL);

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

2952: nvl(l_delivery_info.EARLIEST_DROPOFF_DATE, fnd_api.g_miss_date) <> nvl(l_earliest_mdropoff_date, fnd_api.g_miss_date) OR
2953: nvl(l_delivery_info.LATEST_DROPOFF_DATE, fnd_api.g_miss_date) <> nvl(l_latest_mdropoff_date, fnd_api.g_miss_date)
2954: ) THEN--{
2955:
2956: IF (NVL(l_delivery_info.tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) IN
2957: (WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT,
2958: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,
2959: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
2960: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,

Line 2957: (WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT,

2953: nvl(l_delivery_info.LATEST_DROPOFF_DATE, fnd_api.g_miss_date) <> nvl(l_latest_mdropoff_date, fnd_api.g_miss_date)
2954: ) THEN--{
2955:
2956: IF (NVL(l_delivery_info.tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) IN
2957: (WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT,
2958: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,
2959: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
2960: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
2961: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED)) THEN

Line 2958: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,

2954: ) THEN--{
2955:
2956: IF (NVL(l_delivery_info.tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) IN
2957: (WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT,
2958: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,
2959: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
2960: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
2961: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED)) THEN
2962: l_tms_update := 'N';

Line 2959: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,

2955:
2956: IF (NVL(l_delivery_info.tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) IN
2957: (WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT,
2958: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,
2959: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
2960: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
2961: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED)) THEN
2962: l_tms_update := 'N';
2963: ELSE

Line 2960: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,

2956: IF (NVL(l_delivery_info.tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) IN
2957: (WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT,
2958: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,
2959: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
2960: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
2961: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED)) THEN
2962: l_tms_update := 'N';
2963: ELSE
2964: l_tms_update := 'Y';

Line 2961: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED)) THEN

2957: (WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT,
2958: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,
2959: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
2960: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
2961: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED)) THEN
2962: l_tms_update := 'N';
2963: ELSE
2964: l_tms_update := 'Y';
2965: l_new_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;

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

2961: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED)) THEN
2962: l_tms_update := 'N';
2963: ELSE
2964: l_tms_update := 'Y';
2965: l_new_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;
2966: l_tms_version_number := NVL(l_delivery_info.tms_version_number, 1) + 1;
2967: END IF;
2968: ELSE
2969: l_tms_update := 'N';

Line 2979: UPDATE WSH_NEW_DELIVERIES

2975: WSH_DEBUG_SV.log(l_module_name,'l_tms_update flag', l_tms_update);
2976: END IF;
2977: --END OTM R12
2978:
2979: UPDATE WSH_NEW_DELIVERIES
2980: SET earliest_pickup_date = l_earliest_mpickup_date,
2981: earliest_dropoff_date = l_earliest_mdropoff_date,
2982: latest_pickup_date = l_latest_mpickup_date,
2983: latest_dropoff_date = l_latest_mdropoff_date,

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

2985: ultimate_dropoff_date = l_ultimate_mdropoff_date,
2986: --OTM R12, glog proj
2987: TMS_INTERFACE_FLAG = DECODE(l_tms_update,
2988: 'Y', l_new_interface_flag_tab(1),
2989: NVL(TMS_INTERFACE_FLAG, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)),
2990: TMS_VERSION_NUMBER = DECODE(l_tms_update,
2991: 'Y', l_tms_version_number,
2992: NVL(tms_version_number, 1)),
2993: --