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_PVT

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 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 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 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 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 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 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 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 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: --