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 3970: FROM wsh_new_deliveries dl, wsh_delivery_legs dg, wsh_trip_stops st

3966: -- This is the same cursor as in close_exceptions.
3967: CURSOR Get_Deliveries_Stop(v_stop_id NUMBER) IS
3968: -- pick up 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.initial_pickup_location_id
3973: AND st.stop_id = dg.pick_up_stop_id
3974: AND st.stop_id = v_stop_id

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

3974: AND st.stop_id = v_stop_id
3975: UNION ALL
3976: -- drop off deliveries
3977: SELECT dg.delivery_id
3978: FROM wsh_new_deliveries dl, wsh_delivery_legs dg, wsh_trip_stops st
3979: WHERE dg.delivery_id = dl.delivery_id
3980: AND st.stop_location_id = dl.ultimate_dropoff_location_id
3981: AND st.stop_id = dg.drop_off_stop_id
3982: AND st.stop_id = v_stop_id;

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

4441: -- This is the same cursor as in check_exceptions.
4442: CURSOR Get_Deliveries_Stop(v_stop_id NUMBER) IS
4443: -- pick up 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.initial_pickup_location_id
4448: AND st.stop_id = dg.pick_up_stop_id
4449: AND st.stop_id = v_stop_id

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

4449: AND st.stop_id = v_stop_id
4450: UNION ALL
4451: -- drop off deliveries
4452: SELECT dg.delivery_id
4453: FROM wsh_new_deliveries dl, wsh_delivery_legs dg, wsh_trip_stops st
4454: WHERE dg.delivery_id = dl.delivery_id
4455: AND st.stop_location_id = dl.ultimate_dropoff_location_id
4456: AND st.stop_id = dg.drop_off_stop_id
4457: AND st.stop_id = v_stop_id;

Line 4771: p_delivery_id IN WSH_NEW_DELIVERIES.DELIVERY_ID%TYPE,

4767: --
4768: ----------------------------------------------------------
4769:
4770: PROCEDURE CLOSE_OTM_EXCEPTION(
4771: p_delivery_id IN WSH_NEW_DELIVERIES.DELIVERY_ID%TYPE,
4772: p_exceptions_to_close_tab IN WSH_UTIL_CORE.COLUMN_TAB_TYPE,
4773: x_return_status OUT NOCOPY VARCHAR2) IS
4774:
4775: l_exception_name WSH_EXCEPTION_DEFINITIONS_TL.EXCEPTION_NAME%TYPE;

Line 4891: p_delivery_info_tab IN WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type,

4887: -- and new tms_interface_flag.
4888: ----------------------------------------------------------
4889:
4890: PROCEDURE LOG_OTM_EXCEPTION(
4891: p_delivery_info_tab IN WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type,
4892: p_new_interface_flag_tab IN WSH_UTIL_CORE.COLUMN_TAB_TYPE,
4893: x_return_status OUT NOCOPY VARCHAR2) IS
4894:
4895: l_msg_count NUMBER;

Line 4903: l_new_interface_flag WSH_NEW_DELIVERIES.TMS_INTERFACE_FLAG%TYPE;

4899: l_num_error NUMBER;
4900: l_num_warn NUMBER;
4901: l_return_status VARCHAR2(1);
4902:
4903: l_new_interface_flag WSH_NEW_DELIVERIES.TMS_INTERFACE_FLAG%TYPE;
4904: l_exception_name WSH_EXCEPTION_DEFINITIONS_TL.EXCEPTION_NAME%TYPE;
4905: l_exceptions_to_close_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
4906: i NUMBER;
4907: --

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

4947: --this loop is used to figure out the new tms interface flag value depending on the old one
4948: --when the input tms interface flag was not specified
4949: IF (p_new_interface_flag_tab.COUNT = 0 OR p_new_interface_flag_tab(i) IS NULL) THEN
4950: --figure out the new status as if it's just an update on delivery
4951: IF (p_delivery_info_tab(i).tms_interface_flag IN (WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
4952: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED,
4953: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
4954: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
4955: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED)) THEN

Line 4952: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED,

4948: --when the input tms interface flag was not specified
4949: IF (p_new_interface_flag_tab.COUNT = 0 OR p_new_interface_flag_tab(i) IS NULL) THEN
4950: --figure out the new status as if it's just an update on delivery
4951: IF (p_delivery_info_tab(i).tms_interface_flag IN (WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
4952: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED,
4953: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
4954: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
4955: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED)) THEN
4956: l_new_interface_flag := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;

Line 4953: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,

4949: IF (p_new_interface_flag_tab.COUNT = 0 OR p_new_interface_flag_tab(i) IS NULL) THEN
4950: --figure out the new status as if it's just an update on delivery
4951: IF (p_delivery_info_tab(i).tms_interface_flag IN (WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
4952: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED,
4953: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
4954: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
4955: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED)) THEN
4956: l_new_interface_flag := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;
4957: ELSE

Line 4954: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,

4950: --figure out the new status as if it's just an update on delivery
4951: IF (p_delivery_info_tab(i).tms_interface_flag IN (WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
4952: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED,
4953: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
4954: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
4955: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED)) THEN
4956: l_new_interface_flag := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;
4957: ELSE
4958: l_new_interface_flag := p_delivery_info_tab(i).tms_interface_flag;

Line 4955: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED)) THEN

4951: IF (p_delivery_info_tab(i).tms_interface_flag IN (WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
4952: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED,
4953: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
4954: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
4955: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED)) THEN
4956: l_new_interface_flag := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;
4957: ELSE
4958: l_new_interface_flag := p_delivery_info_tab(i).tms_interface_flag;
4959: END IF;

Line 4956: l_new_interface_flag := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;

4952: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED,
4953: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
4954: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
4955: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED)) THEN
4956: l_new_interface_flag := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;
4957: ELSE
4958: l_new_interface_flag := p_delivery_info_tab(i).tms_interface_flag;
4959: END IF;
4960: ELSE

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

4971: END IF;
4972:
4973: --log and close exceptions only if new status is different and not IN Process status
4974: IF ((l_new_interface_flag <> p_delivery_info_tab(i).tms_interface_flag)
4975: AND (l_new_interface_flag NOT IN (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
4976: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
4977: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS))) THEN
4978:
4979: l_exception_id := NULL;

Line 4976: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,

4972:
4973: --log and close exceptions only if new status is different and not IN Process status
4974: IF ((l_new_interface_flag <> p_delivery_info_tab(i).tms_interface_flag)
4975: AND (l_new_interface_flag NOT IN (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
4976: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
4977: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS))) THEN
4978:
4979: l_exception_id := NULL;
4980: l_exception_message := NULL;

Line 4977: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS))) THEN

4973: --log and close exceptions only if new status is different and not IN Process status
4974: IF ((l_new_interface_flag <> p_delivery_info_tab(i).tms_interface_flag)
4975: AND (l_new_interface_flag NOT IN (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
4976: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
4977: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS))) THEN
4978:
4979: l_exception_id := NULL;
4980: l_exception_message := NULL;
4981: l_exception_name := NULL;

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

4983: -- Start of Ship Confirm ECO
4984: -- Close the old exception(s) logged against this delivery, as we are going to
4985: -- log a new exception based on the l_new_interface_flag.
4986: --
4987: IF p_delivery_info_tab(i).tms_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER THEN
4988: l_exceptions_to_close_tab(1) := 'WSH_OTM_DEL_AWAIT_TRIP';
4989: ELSIF p_delivery_info_tab(i).tms_interface_flag IN (WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED,
4990: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS) THEN
4991: l_exceptions_to_close_tab(1) := 'WSH_OTM_DEL_UPDATE_REQ';

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

4985: -- log a new exception based on the l_new_interface_flag.
4986: --
4987: IF p_delivery_info_tab(i).tms_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER THEN
4988: l_exceptions_to_close_tab(1) := 'WSH_OTM_DEL_AWAIT_TRIP';
4989: ELSIF p_delivery_info_tab(i).tms_interface_flag IN (WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED,
4990: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS) THEN
4991: l_exceptions_to_close_tab(1) := 'WSH_OTM_DEL_UPDATE_REQ';
4992: ELSIF p_delivery_info_tab(i).tms_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED THEN
4993: l_exceptions_to_close_tab(1) := 'WSH_OTM_SHIPMENT_REC';

Line 4990: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS) THEN

4986: --
4987: IF p_delivery_info_tab(i).tms_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER THEN
4988: l_exceptions_to_close_tab(1) := 'WSH_OTM_DEL_AWAIT_TRIP';
4989: ELSIF p_delivery_info_tab(i).tms_interface_flag IN (WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED,
4990: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS) THEN
4991: l_exceptions_to_close_tab(1) := 'WSH_OTM_DEL_UPDATE_REQ';
4992: ELSIF p_delivery_info_tab(i).tms_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED THEN
4993: l_exceptions_to_close_tab(1) := 'WSH_OTM_SHIPMENT_REC';
4994: ELSIF p_delivery_info_tab(i).tms_interface_flag IN (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,

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

4988: l_exceptions_to_close_tab(1) := 'WSH_OTM_DEL_AWAIT_TRIP';
4989: ELSIF p_delivery_info_tab(i).tms_interface_flag IN (WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED,
4990: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS) THEN
4991: l_exceptions_to_close_tab(1) := 'WSH_OTM_DEL_UPDATE_REQ';
4992: ELSIF p_delivery_info_tab(i).tms_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED THEN
4993: l_exceptions_to_close_tab(1) := 'WSH_OTM_SHIPMENT_REC';
4994: ELSIF p_delivery_info_tab(i).tms_interface_flag IN (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,
4995: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS) THEN
4996: l_exceptions_to_close_tab(1) := 'WSH_OTM_DEL_CREATE_REQ';

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

4990: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS) THEN
4991: l_exceptions_to_close_tab(1) := 'WSH_OTM_DEL_UPDATE_REQ';
4992: ELSIF p_delivery_info_tab(i).tms_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED THEN
4993: l_exceptions_to_close_tab(1) := 'WSH_OTM_SHIPMENT_REC';
4994: ELSIF p_delivery_info_tab(i).tms_interface_flag IN (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,
4995: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS) THEN
4996: l_exceptions_to_close_tab(1) := 'WSH_OTM_DEL_CREATE_REQ';
4997: ELSIF p_delivery_info_tab(i).tms_interface_flag IN (WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
4998: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS) THEN

Line 4995: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS) THEN

4991: l_exceptions_to_close_tab(1) := 'WSH_OTM_DEL_UPDATE_REQ';
4992: ELSIF p_delivery_info_tab(i).tms_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED THEN
4993: l_exceptions_to_close_tab(1) := 'WSH_OTM_SHIPMENT_REC';
4994: ELSIF p_delivery_info_tab(i).tms_interface_flag IN (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,
4995: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS) THEN
4996: l_exceptions_to_close_tab(1) := 'WSH_OTM_DEL_CREATE_REQ';
4997: ELSIF p_delivery_info_tab(i).tms_interface_flag IN (WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
4998: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS) THEN
4999: l_exceptions_to_close_tab(1) := 'WSH_OTM_DEL_DELETE_REQ';

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

4993: l_exceptions_to_close_tab(1) := 'WSH_OTM_SHIPMENT_REC';
4994: ELSIF p_delivery_info_tab(i).tms_interface_flag IN (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,
4995: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS) THEN
4996: l_exceptions_to_close_tab(1) := 'WSH_OTM_DEL_CREATE_REQ';
4997: ELSIF p_delivery_info_tab(i).tms_interface_flag IN (WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
4998: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS) THEN
4999: l_exceptions_to_close_tab(1) := 'WSH_OTM_DEL_DELETE_REQ';
5000: END IF;
5001:

Line 4998: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS) THEN

4994: ELSIF p_delivery_info_tab(i).tms_interface_flag IN (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,
4995: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS) THEN
4996: l_exceptions_to_close_tab(1) := 'WSH_OTM_DEL_CREATE_REQ';
4997: ELSIF p_delivery_info_tab(i).tms_interface_flag IN (WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
4998: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS) THEN
4999: l_exceptions_to_close_tab(1) := 'WSH_OTM_DEL_DELETE_REQ';
5000: END IF;
5001:
5002: IF l_exceptions_to_close_tab.COUNT > 0 THEN

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

5024: END IF;
5025:
5026: --log the deleted exception before the new CR exception is logged
5027:
5028: IF ((l_new_interface_flag IN (WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT,
5029: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,
5030: WSH_NEW_DELIVERIES_PVT.C_TMS_COMPLETED))
5031: AND (p_delivery_info_tab(i).tms_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS)) THEN
5032:

Line 5029: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,

5025:
5026: --log the deleted exception before the new CR exception is logged
5027:
5028: IF ((l_new_interface_flag IN (WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT,
5029: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,
5030: WSH_NEW_DELIVERIES_PVT.C_TMS_COMPLETED))
5031: AND (p_delivery_info_tab(i).tms_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS)) THEN
5032:
5033: --log deleted, only when set from DP to NS or CR or CMP

Line 5030: WSH_NEW_DELIVERIES_PVT.C_TMS_COMPLETED))

5026: --log the deleted exception before the new CR exception is logged
5027:
5028: IF ((l_new_interface_flag IN (WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT,
5029: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,
5030: WSH_NEW_DELIVERIES_PVT.C_TMS_COMPLETED))
5031: AND (p_delivery_info_tab(i).tms_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS)) THEN
5032:
5033: --log deleted, only when set from DP to NS or CR or CMP
5034:

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

5027:
5028: IF ((l_new_interface_flag IN (WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT,
5029: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,
5030: WSH_NEW_DELIVERIES_PVT.C_TMS_COMPLETED))
5031: AND (p_delivery_info_tab(i).tms_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS)) THEN
5032:
5033: --log deleted, only when set from DP to NS or CR or CMP
5034:
5035: l_exception_name := 'WSH_OTM_DEL_DELETED';

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

5071:
5072: l_exception_name := NULL;
5073:
5074: --logging the new exception
5075: IF (l_new_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED) THEN
5076:
5077: l_exception_name := 'WSH_OTM_DEL_CREATE_REQ';
5078:
5079: ELSIF (l_new_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED) THEN

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

5075: IF (l_new_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED) THEN
5076:
5077: l_exception_name := 'WSH_OTM_DEL_CREATE_REQ';
5078:
5079: ELSIF (l_new_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED) THEN
5080:
5081: l_exception_name := 'WSH_OTM_DEL_UPDATE_REQ';
5082:
5083: ELSIF (l_new_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED) THEN

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

5079: ELSIF (l_new_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED) THEN
5080:
5081: l_exception_name := 'WSH_OTM_DEL_UPDATE_REQ';
5082:
5083: ELSIF (l_new_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED) THEN
5084:
5085: l_exception_name := 'WSH_OTM_DEL_DELETE_REQ';
5086:
5087: ELSIF (l_new_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER) THEN

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

5083: ELSIF (l_new_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED) THEN
5084:
5085: l_exception_name := 'WSH_OTM_DEL_DELETE_REQ';
5086:
5087: ELSIF (l_new_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER) THEN
5088:
5089: l_exception_name := 'WSH_OTM_DEL_AWAIT_TRIP';
5090:
5091: ELSIF (l_new_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED) THEN

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

5087: ELSIF (l_new_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER) THEN
5088:
5089: l_exception_name := 'WSH_OTM_DEL_AWAIT_TRIP';
5090:
5091: ELSIF (l_new_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED) THEN
5092:
5093: l_exception_name := 'WSH_OTM_SHIPMENT_REC';
5094:
5095: END IF;

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

5096:
5097: IF (l_exception_name IS NOT NULL) THEN
5098:
5099: --log the messages, message name is same as exception name
5100: IF (l_new_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED) THEN
5101:
5102: FND_MESSAGE.SET_NAME('WSH', 'WSH_OTM_DELIVERY_SUCCESS');
5103:
5104: ELSE

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

5190: --
5191: -- description: This procedure gets the delivery's OTM exception and severity
5192: ----------------------------------------------------------
5193: PROCEDURE GET_OTM_DELIVERY_EXCEPTION
5194: (p_delivery_id IN WSH_NEW_DELIVERIES.DELIVERY_ID%TYPE,
5195: x_exception_name OUT NOCOPY WSH_EXCEPTIONS.EXCEPTION_NAME%TYPE,
5196: x_severity OUT NOCOPY WSH_EXCEPTIONS.SEVERITY%TYPE,
5197: x_return_status OUT NOCOPY VARCHAR2) IS
5198: