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

Line 3962: FROM wsh_new_deliveries dl, wsh_delivery_legs dg, wsh_trip_stops st

3958: -- This is the same cursor as in close_exceptions.
3959: CURSOR Get_Deliveries_Stop(v_stop_id NUMBER) IS
3960: -- pick up deliveries
3961: SELECT dg.delivery_id
3962: FROM wsh_new_deliveries dl, wsh_delivery_legs dg, wsh_trip_stops st
3963: WHERE dg.delivery_id = dl.delivery_id
3964: AND st.stop_location_id = dl.initial_pickup_location_id
3965: AND st.stop_id = dg.pick_up_stop_id
3966: AND st.stop_id = v_stop_id

Line 3970: FROM wsh_new_deliveries dl, wsh_delivery_legs dg, wsh_trip_stops st

3966: AND st.stop_id = v_stop_id
3967: UNION ALL
3968: -- drop off deliveries
3969: SELECT dg.delivery_id
3970: FROM wsh_new_deliveries dl, wsh_delivery_legs dg, wsh_trip_stops st
3971: WHERE dg.delivery_id = dl.delivery_id
3972: AND st.stop_location_id = dl.ultimate_dropoff_location_id
3973: AND st.stop_id = dg.drop_off_stop_id
3974: AND st.stop_id = v_stop_id;

Line 4437: FROM wsh_new_deliveries dl, wsh_delivery_legs dg, wsh_trip_stops st

4433: -- This is the same cursor as in check_exceptions.
4434: CURSOR Get_Deliveries_Stop(v_stop_id NUMBER) IS
4435: -- pick up deliveries
4436: SELECT dg.delivery_id
4437: FROM wsh_new_deliveries dl, wsh_delivery_legs dg, wsh_trip_stops st
4438: WHERE dg.delivery_id = dl.delivery_id
4439: AND st.stop_location_id = dl.initial_pickup_location_id
4440: AND st.stop_id = dg.pick_up_stop_id
4441: AND st.stop_id = v_stop_id

Line 4445: FROM wsh_new_deliveries dl, wsh_delivery_legs dg, wsh_trip_stops st

4441: AND st.stop_id = v_stop_id
4442: UNION ALL
4443: -- drop off deliveries
4444: SELECT dg.delivery_id
4445: FROM wsh_new_deliveries dl, wsh_delivery_legs dg, wsh_trip_stops st
4446: WHERE dg.delivery_id = dl.delivery_id
4447: AND st.stop_location_id = dl.ultimate_dropoff_location_id
4448: AND st.stop_id = dg.drop_off_stop_id
4449: AND st.stop_id = v_stop_id;

Line 4763: p_delivery_id IN WSH_NEW_DELIVERIES.DELIVERY_ID%TYPE,

4759: --
4760: ----------------------------------------------------------
4761:
4762: PROCEDURE CLOSE_OTM_EXCEPTION(
4763: p_delivery_id IN WSH_NEW_DELIVERIES.DELIVERY_ID%TYPE,
4764: p_exceptions_to_close_tab IN WSH_UTIL_CORE.COLUMN_TAB_TYPE,
4765: x_return_status OUT NOCOPY VARCHAR2) IS
4766:
4767: l_exception_name WSH_EXCEPTION_DEFINITIONS_TL.EXCEPTION_NAME%TYPE;

Line 4883: p_delivery_info_tab IN WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type,

4879: -- and new tms_interface_flag.
4880: ----------------------------------------------------------
4881:
4882: PROCEDURE LOG_OTM_EXCEPTION(
4883: p_delivery_info_tab IN WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type,
4884: p_new_interface_flag_tab IN WSH_UTIL_CORE.COLUMN_TAB_TYPE,
4885: x_return_status OUT NOCOPY VARCHAR2) IS
4886:
4887: l_msg_count NUMBER;

Line 4895: l_new_interface_flag WSH_NEW_DELIVERIES.TMS_INTERFACE_FLAG%TYPE;

4891: l_num_error NUMBER;
4892: l_num_warn NUMBER;
4893: l_return_status VARCHAR2(1);
4894:
4895: l_new_interface_flag WSH_NEW_DELIVERIES.TMS_INTERFACE_FLAG%TYPE;
4896: l_exception_name WSH_EXCEPTION_DEFINITIONS_TL.EXCEPTION_NAME%TYPE;
4897: l_exceptions_to_close_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
4898: i NUMBER;
4899: --

Line 4943: IF (p_delivery_info_tab(i).tms_interface_flag IN (WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,

4939: --this loop is used to figure out the new tms interface flag value depending on the old one
4940: --when the input tms interface flag was not specified
4941: IF (p_new_interface_flag_tab.COUNT = 0 OR p_new_interface_flag_tab(i) IS NULL) THEN
4942: --figure out the new status as if it's just an update on delivery
4943: IF (p_delivery_info_tab(i).tms_interface_flag IN (WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
4944: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED,
4945: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
4946: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
4947: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED)) THEN

Line 4944: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED,

4940: --when the input tms interface flag was not specified
4941: IF (p_new_interface_flag_tab.COUNT = 0 OR p_new_interface_flag_tab(i) IS NULL) THEN
4942: --figure out the new status as if it's just an update on delivery
4943: IF (p_delivery_info_tab(i).tms_interface_flag IN (WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
4944: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED,
4945: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
4946: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
4947: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED)) THEN
4948: l_new_interface_flag := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;

Line 4945: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,

4941: IF (p_new_interface_flag_tab.COUNT = 0 OR p_new_interface_flag_tab(i) IS NULL) THEN
4942: --figure out the new status as if it's just an update on delivery
4943: IF (p_delivery_info_tab(i).tms_interface_flag IN (WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
4944: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED,
4945: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
4946: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
4947: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED)) THEN
4948: l_new_interface_flag := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;
4949: ELSE

Line 4946: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,

4942: --figure out the new status as if it's just an update on delivery
4943: IF (p_delivery_info_tab(i).tms_interface_flag IN (WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
4944: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED,
4945: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
4946: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
4947: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED)) THEN
4948: l_new_interface_flag := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;
4949: ELSE
4950: l_new_interface_flag := p_delivery_info_tab(i).tms_interface_flag;

Line 4947: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED)) THEN

4943: IF (p_delivery_info_tab(i).tms_interface_flag IN (WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
4944: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED,
4945: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
4946: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
4947: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED)) THEN
4948: l_new_interface_flag := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;
4949: ELSE
4950: l_new_interface_flag := p_delivery_info_tab(i).tms_interface_flag;
4951: END IF;

Line 4948: l_new_interface_flag := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;

4944: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED,
4945: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
4946: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
4947: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED)) THEN
4948: l_new_interface_flag := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;
4949: ELSE
4950: l_new_interface_flag := p_delivery_info_tab(i).tms_interface_flag;
4951: END IF;
4952: ELSE

Line 4967: AND (l_new_interface_flag NOT IN (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,

4963: END IF;
4964:
4965: --log and close exceptions only if new status is different and not IN Process status
4966: IF ((l_new_interface_flag <> p_delivery_info_tab(i).tms_interface_flag)
4967: AND (l_new_interface_flag NOT IN (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
4968: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
4969: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS))) THEN
4970:
4971: l_exception_id := NULL;

Line 4968: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,

4964:
4965: --log and close exceptions only if new status is different and not IN Process status
4966: IF ((l_new_interface_flag <> p_delivery_info_tab(i).tms_interface_flag)
4967: AND (l_new_interface_flag NOT IN (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
4968: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
4969: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS))) THEN
4970:
4971: l_exception_id := NULL;
4972: l_exception_message := NULL;

Line 4969: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS))) THEN

4965: --log and close exceptions only if new status is different and not IN Process status
4966: IF ((l_new_interface_flag <> p_delivery_info_tab(i).tms_interface_flag)
4967: AND (l_new_interface_flag NOT IN (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
4968: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
4969: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS))) THEN
4970:
4971: l_exception_id := NULL;
4972: l_exception_message := NULL;
4973: l_exception_name := NULL;

Line 4979: IF p_delivery_info_tab(i).tms_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER THEN

4975: -- Start of Ship Confirm ECO
4976: -- Close the old exception(s) logged against this delivery, as we are going to
4977: -- log a new exception based on the l_new_interface_flag.
4978: --
4979: IF p_delivery_info_tab(i).tms_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER THEN
4980: l_exceptions_to_close_tab(1) := 'WSH_OTM_DEL_AWAIT_TRIP';
4981: ELSIF p_delivery_info_tab(i).tms_interface_flag IN (WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED,
4982: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS) THEN
4983: l_exceptions_to_close_tab(1) := 'WSH_OTM_DEL_UPDATE_REQ';

Line 4981: ELSIF p_delivery_info_tab(i).tms_interface_flag IN (WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED,

4977: -- log a new exception based on the l_new_interface_flag.
4978: --
4979: IF p_delivery_info_tab(i).tms_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER THEN
4980: l_exceptions_to_close_tab(1) := 'WSH_OTM_DEL_AWAIT_TRIP';
4981: ELSIF p_delivery_info_tab(i).tms_interface_flag IN (WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED,
4982: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS) THEN
4983: l_exceptions_to_close_tab(1) := 'WSH_OTM_DEL_UPDATE_REQ';
4984: ELSIF p_delivery_info_tab(i).tms_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED THEN
4985: l_exceptions_to_close_tab(1) := 'WSH_OTM_SHIPMENT_REC';

Line 4982: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS) THEN

4978: --
4979: IF p_delivery_info_tab(i).tms_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER THEN
4980: l_exceptions_to_close_tab(1) := 'WSH_OTM_DEL_AWAIT_TRIP';
4981: ELSIF p_delivery_info_tab(i).tms_interface_flag IN (WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED,
4982: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS) THEN
4983: l_exceptions_to_close_tab(1) := 'WSH_OTM_DEL_UPDATE_REQ';
4984: ELSIF p_delivery_info_tab(i).tms_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED THEN
4985: l_exceptions_to_close_tab(1) := 'WSH_OTM_SHIPMENT_REC';
4986: ELSIF p_delivery_info_tab(i).tms_interface_flag IN (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,

Line 4984: ELSIF p_delivery_info_tab(i).tms_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED THEN

4980: l_exceptions_to_close_tab(1) := 'WSH_OTM_DEL_AWAIT_TRIP';
4981: ELSIF p_delivery_info_tab(i).tms_interface_flag IN (WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED,
4982: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS) THEN
4983: l_exceptions_to_close_tab(1) := 'WSH_OTM_DEL_UPDATE_REQ';
4984: ELSIF p_delivery_info_tab(i).tms_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED THEN
4985: l_exceptions_to_close_tab(1) := 'WSH_OTM_SHIPMENT_REC';
4986: ELSIF p_delivery_info_tab(i).tms_interface_flag IN (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,
4987: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS) THEN
4988: l_exceptions_to_close_tab(1) := 'WSH_OTM_DEL_CREATE_REQ';

Line 4986: ELSIF p_delivery_info_tab(i).tms_interface_flag IN (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,

4982: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS) THEN
4983: l_exceptions_to_close_tab(1) := 'WSH_OTM_DEL_UPDATE_REQ';
4984: ELSIF p_delivery_info_tab(i).tms_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED THEN
4985: l_exceptions_to_close_tab(1) := 'WSH_OTM_SHIPMENT_REC';
4986: ELSIF p_delivery_info_tab(i).tms_interface_flag IN (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,
4987: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS) THEN
4988: l_exceptions_to_close_tab(1) := 'WSH_OTM_DEL_CREATE_REQ';
4989: ELSIF p_delivery_info_tab(i).tms_interface_flag IN (WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
4990: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS) THEN

Line 4987: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS) THEN

4983: l_exceptions_to_close_tab(1) := 'WSH_OTM_DEL_UPDATE_REQ';
4984: ELSIF p_delivery_info_tab(i).tms_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED THEN
4985: l_exceptions_to_close_tab(1) := 'WSH_OTM_SHIPMENT_REC';
4986: ELSIF p_delivery_info_tab(i).tms_interface_flag IN (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,
4987: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS) THEN
4988: l_exceptions_to_close_tab(1) := 'WSH_OTM_DEL_CREATE_REQ';
4989: ELSIF p_delivery_info_tab(i).tms_interface_flag IN (WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
4990: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS) THEN
4991: l_exceptions_to_close_tab(1) := 'WSH_OTM_DEL_DELETE_REQ';

Line 4989: ELSIF p_delivery_info_tab(i).tms_interface_flag IN (WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,

4985: l_exceptions_to_close_tab(1) := 'WSH_OTM_SHIPMENT_REC';
4986: ELSIF p_delivery_info_tab(i).tms_interface_flag IN (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,
4987: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS) THEN
4988: l_exceptions_to_close_tab(1) := 'WSH_OTM_DEL_CREATE_REQ';
4989: ELSIF p_delivery_info_tab(i).tms_interface_flag IN (WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
4990: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS) THEN
4991: l_exceptions_to_close_tab(1) := 'WSH_OTM_DEL_DELETE_REQ';
4992: END IF;
4993:

Line 4990: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS) THEN

4986: ELSIF p_delivery_info_tab(i).tms_interface_flag IN (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,
4987: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS) THEN
4988: l_exceptions_to_close_tab(1) := 'WSH_OTM_DEL_CREATE_REQ';
4989: ELSIF p_delivery_info_tab(i).tms_interface_flag IN (WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
4990: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS) THEN
4991: l_exceptions_to_close_tab(1) := 'WSH_OTM_DEL_DELETE_REQ';
4992: END IF;
4993:
4994: IF l_exceptions_to_close_tab.COUNT > 0 THEN

Line 5020: IF ((l_new_interface_flag IN (WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT,

5016: END IF;
5017:
5018: --log the deleted exception before the new CR exception is logged
5019:
5020: IF ((l_new_interface_flag IN (WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT,
5021: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,
5022: WSH_NEW_DELIVERIES_PVT.C_TMS_COMPLETED))
5023: AND (p_delivery_info_tab(i).tms_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS)) THEN
5024:

Line 5021: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,

5017:
5018: --log the deleted exception before the new CR exception is logged
5019:
5020: IF ((l_new_interface_flag IN (WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT,
5021: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,
5022: WSH_NEW_DELIVERIES_PVT.C_TMS_COMPLETED))
5023: AND (p_delivery_info_tab(i).tms_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS)) THEN
5024:
5025: --log deleted, only when set from DP to NS or CR or CMP

Line 5022: WSH_NEW_DELIVERIES_PVT.C_TMS_COMPLETED))

5018: --log the deleted exception before the new CR exception is logged
5019:
5020: IF ((l_new_interface_flag IN (WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT,
5021: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,
5022: WSH_NEW_DELIVERIES_PVT.C_TMS_COMPLETED))
5023: AND (p_delivery_info_tab(i).tms_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS)) THEN
5024:
5025: --log deleted, only when set from DP to NS or CR or CMP
5026:

Line 5023: AND (p_delivery_info_tab(i).tms_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS)) THEN

5019:
5020: IF ((l_new_interface_flag IN (WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT,
5021: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,
5022: WSH_NEW_DELIVERIES_PVT.C_TMS_COMPLETED))
5023: AND (p_delivery_info_tab(i).tms_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS)) THEN
5024:
5025: --log deleted, only when set from DP to NS or CR or CMP
5026:
5027: l_exception_name := 'WSH_OTM_DEL_DELETED';

Line 5067: IF (l_new_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED) THEN

5063:
5064: l_exception_name := NULL;
5065:
5066: --logging the new exception
5067: IF (l_new_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED) THEN
5068:
5069: l_exception_name := 'WSH_OTM_DEL_CREATE_REQ';
5070:
5071: ELSIF (l_new_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED) THEN

Line 5071: ELSIF (l_new_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED) THEN

5067: IF (l_new_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED) THEN
5068:
5069: l_exception_name := 'WSH_OTM_DEL_CREATE_REQ';
5070:
5071: ELSIF (l_new_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED) THEN
5072:
5073: l_exception_name := 'WSH_OTM_DEL_UPDATE_REQ';
5074:
5075: ELSIF (l_new_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED) THEN

Line 5075: ELSIF (l_new_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED) THEN

5071: ELSIF (l_new_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED) THEN
5072:
5073: l_exception_name := 'WSH_OTM_DEL_UPDATE_REQ';
5074:
5075: ELSIF (l_new_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED) THEN
5076:
5077: l_exception_name := 'WSH_OTM_DEL_DELETE_REQ';
5078:
5079: ELSIF (l_new_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER) THEN

Line 5079: ELSIF (l_new_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER) THEN

5075: ELSIF (l_new_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED) THEN
5076:
5077: l_exception_name := 'WSH_OTM_DEL_DELETE_REQ';
5078:
5079: ELSIF (l_new_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER) THEN
5080:
5081: l_exception_name := 'WSH_OTM_DEL_AWAIT_TRIP';
5082:
5083: ELSIF (l_new_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED) THEN

Line 5083: ELSIF (l_new_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED) THEN

5079: ELSIF (l_new_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER) THEN
5080:
5081: l_exception_name := 'WSH_OTM_DEL_AWAIT_TRIP';
5082:
5083: ELSIF (l_new_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED) THEN
5084:
5085: l_exception_name := 'WSH_OTM_SHIPMENT_REC';
5086:
5087: END IF;

Line 5092: IF (l_new_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED) THEN

5088:
5089: IF (l_exception_name IS NOT NULL) THEN
5090:
5091: --log the messages, message name is same as exception name
5092: IF (l_new_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED) THEN
5093:
5094: FND_MESSAGE.SET_NAME('WSH', 'WSH_OTM_DELIVERY_SUCCESS');
5095:
5096: ELSE

Line 5186: (p_delivery_id IN WSH_NEW_DELIVERIES.DELIVERY_ID%TYPE,

5182: --
5183: -- description: This procedure gets the delivery's OTM exception and severity
5184: ----------------------------------------------------------
5185: PROCEDURE GET_OTM_DELIVERY_EXCEPTION
5186: (p_delivery_id IN WSH_NEW_DELIVERIES.DELIVERY_ID%TYPE,
5187: x_exception_name OUT NOCOPY WSH_EXCEPTIONS.EXCEPTION_NAME%TYPE,
5188: x_severity OUT NOCOPY WSH_EXCEPTIONS.SEVERITY%TYPE,
5189: x_return_status OUT NOCOPY VARCHAR2) IS
5190: