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

Line 109: WSH_NEW_DELIVERIES_PVT.Get_Name(p_deliveryIdTab(i)));

105: IF l_Status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
106: FND_MESSAGE.SET_NAME('WSH', 'WSH_ROUTING_RESP_SUCCESS');
107: FND_MESSAGE.SET_TOKEN('RESP_NUM', l_RespNum);
108: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME',
109: WSH_NEW_DELIVERIES_PVT.Get_Name(p_deliveryIdTab(i)));
110: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_SUCCESS,
111: l_moduleName);
112: ELSE
113: FND_MESSAGE.SET_NAME('WSH', 'WSH_ROUTING_RESP_WARNING');

Line 116: WSH_NEW_DELIVERIES_PVT.Get_Name(p_deliveryIdTab(i)));

112: ELSE
113: FND_MESSAGE.SET_NAME('WSH', 'WSH_ROUTING_RESP_WARNING');
114: FND_MESSAGE.SET_TOKEN('RESP_NUM', l_RespNum);
115: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME',
116: WSH_NEW_DELIVERIES_PVT.Get_Name(p_deliveryIdTab(i)));
117: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_WARNING,
118: l_moduleName);
119: END IF;
120: --

Line 131: WSH_NEW_DELIVERIES_PVT.Get_Name(p_deliveryIdTab(i)));

127: END IF;
128: --
129: FND_MESSAGE.SET_NAME('WSH', 'WSH_ROUTING_RESP_FAILURE');
130: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME',
131: WSH_NEW_DELIVERIES_PVT.Get_Name(p_deliveryIdTab(i)));
132: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR,
133: l_moduleName);
134: --
135:

Line 431: FROM wsh_trip_stops wts, wsh_new_deliveries wnd, wsh_delivery_legs wdl, wsh_Trips wt

427: -- Get the pickup stop Id, trip Id
428: --
429: CURSOR c_GetPickupStopId(p_delId IN NUMBER) IS
430: SELECT wdl.pick_up_stop_id, wt.trip_id, wnd.name, wt.planned_flag, wnd.planned_flag
431: FROM wsh_trip_stops wts, wsh_new_deliveries wnd, wsh_delivery_legs wdl, wsh_Trips wt
432: WHERE wnd.delivery_id = p_delId
433: and wnd.delivery_id = wdl.delivery_id
434: and wdl.pick_up_stop_id = wts.stop_id
435: and wnd.initial_pickup_location_id = wts.stop_location_id

Line 442: FROM wsh_trip_stops wts, wsh_new_deliveries wnd, wsh_delivery_legs wdl

438: -- Get the drop off Stop Id
439: --
440: CURSOR c_GetDropoffStopId(p_delId IN NUMBER) IS
441: SELECT nvl(wts.physical_stop_id,drop_off_stop_id) drop_off_stop_id
442: FROM wsh_trip_stops wts, wsh_new_deliveries wnd, wsh_delivery_legs wdl
443: WHERE wnd.delivery_id = p_delId
444: and wnd.delivery_id = wdl.delivery_id
445: and wdl.drop_off_stop_id = wts.stop_id
446: and wnd.ultimate_dropoff_location_id = wts.stop_location_id;

Line 511: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME', WSH_NEW_DELIVERIES_PVT.Get_Name(l_deliveryId));

507: -- Delivery failed validation (or) the to Role is null.
508: -- Set the failure notification subject and message body
509: --
510: FND_MESSAGE.SET_NAME('FTE', 'FTE_RRESP_GEN_FAILED_SUBJ');
511: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME', WSH_NEW_DELIVERIES_PVT.Get_Name(l_deliveryId));
512: l_msgFailSubject := FND_MESSAGE.GET;
513: --
514: FND_MESSAGE.SET_NAME('FTE', 'FTE_RRESP_PRE_FAILURE_REASON');
515: l_failReason := FND_MESSAGE.GET;

Line 635: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME', WSH_NEW_DELIVERIES_PVT.Get_Name(l_deliveryId));

631: wsh_debug_sv.logmsg(l_moduleName, 'Error in Plan Delivery API');
632: END IF;
633: --
634: FND_MESSAGE.SET_NAME('FTE', 'FTE_RRESP_GEN_FAILED_SUBJ');
635: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME', WSH_NEW_DELIVERIES_PVT.Get_Name(l_deliveryId));
636: l_msgFailSubject := FND_MESSAGE.GET;
637: FND_MESSAGE.SET_NAME('FTE', 'FTE_RRESP_PRE_FAILURE_REASON');
638: l_failReason := FND_MESSAGE.GET;
639: --

Line 740: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME', WSH_NEW_DELIVERIES_PVT.Get_Name(l_deliveryId));

736: wsh_debug_sv.logmsg(l_moduleName, 'Delivery ' || l_deliveryId || ' not locked');
737: END IF;
738: --
739: FND_MESSAGE.SET_NAME('FTE', 'FTE_RRESP_GEN_FAILED_SUBJ');
740: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME', WSH_NEW_DELIVERIES_PVT.Get_Name(l_deliveryId));
741: l_msgFailSubject := FND_MESSAGE.GET;
742: --
743: FND_MESSAGE.SET_NAME('FTE', 'FTE_RRESP_PRE_DEL_LOCKED');
744: l_failReason := FND_MESSAGE.GET;

Line 804: -- update WSH_NEW_DELIVERIES and WSH_INBOUND_TXN_HISTORY

800: --
801: -- Purpose : This is the API that is called as part of the actual routing response WF.
802: -- Control would be transferred to this API after the actual notification
803: -- has been fired. This API in turn calls procedure UpdateTxnHistory to
804: -- update WSH_NEW_DELIVERIES and WSH_INBOUND_TXN_HISTORY
805: --
806: -- Version : 1.0
807: --
808: PROCEDURE PostNotification(itemtype IN VARCHAR2,

Line 868: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME', WSH_NEW_DELIVERIES_PVT.Get_Name(l_deliveryId));

864: resultout := 'T';
865: ELSE
866: --
867: FND_MESSAGE.SET_NAME('FTE', 'FTE_RRESP_POST_FAILED_SUBJ');
868: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME', WSH_NEW_DELIVERIES_PVT.Get_Name(l_deliveryId));
869: l_msgFailSubject := FND_MESSAGE.GET;
870: --
871: FND_MESSAGE.SET_NAME('FTE', 'FTE_RRESP_POST_FAILURE_REASON');
872: l_failReason := FND_MESSAGE.GET;

Line 1008: FROM wsh_new_deliveries

1004: FUNCTION GetToRole(p_delivId IN NUMBER) RETURN VARCHAR2 IS
1005: --
1006: CURSOR c_DelInfo IS
1007: SELECT initial_pickup_location_id, party_id, vendor_id, name -- IB-Phase-2
1008: FROM wsh_new_deliveries
1009: WHERE delivery_id = p_delivId;
1010: --
1011: CURSOR c_GetShipperPartyRelId(p_locId NUMBER, p_delpartyId NUMBER) IS
1012: SELECT hrel.party_id, contact_person.party_id, email_record.email_address, hrel.end_date

Line 1308: FROM wsh_new_deliveries

1304: l_moduleName CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'CreateTxnHistory';
1305: --
1306: CURSOR c_DelivData IS
1307: SELECT name, organization_id, vendor_id
1308: FROM wsh_new_deliveries
1309: WHERE delivery_id = p_delId;
1310: --
1311: CURSOR c_ResponseNum IS
1312: SELECT receipt_number

Line 1462: -- completed successfully. Also, an update to WSH_NEW_DELIVERIES

1458: -- x_Status - Return status of this API.
1459: --
1460: -- Purpose : This API is used to update the record in WSH_INBOUND_TXN_HISTORY
1461: -- for this delivery to indicate that the routing response WF
1462: -- completed successfully. Also, an update to WSH_NEW_DELIVERIES
1463: -- is performed to set the routing_response_id.
1464: --
1465: -- Version : 1.0
1466: --

Line 1497: -- Update WSH_NEW_DELIVERIES

1493: wsh_debug_sv.log(l_moduleName, 'Revision Number', p_RevNum);
1494: wsh_debug_sv.log(l_moduleName, 'l_Date', to_char(l_Date, 'DD/MM/YYYY HH24:MI:SS'));
1495: END IF;
1496: --
1497: -- Update WSH_NEW_DELIVERIES
1498: --
1499: UPDATE wsh_new_deliveries
1500: SET routing_response_id = p_TxnId,
1501: last_update_date = l_Date

Line 1499: UPDATE wsh_new_deliveries

1495: END IF;
1496: --
1497: -- Update WSH_NEW_DELIVERIES
1498: --
1499: UPDATE wsh_new_deliveries
1500: SET routing_response_id = p_TxnId,
1501: last_update_date = l_Date
1502: WHERE delivery_id = p_deliveryId;
1503: --

Line 1601: FROM wsh_new_deliveries wnd,

1597: x_return_status OUT NOCOPY VARCHAR2) IS
1598: --Cursor to find ,if first leg is created for a delivery.
1599: CURSOR validate_first_leg_csr(cp_delivery_id NUMBER) IS
1600: SELECT wts.trip_id,wnd.organization_id,wnd.shipping_control
1601: FROM wsh_new_deliveries wnd,
1602: wsh_delivery_legs wdl,
1603: wsh_trip_stops wts
1604: WHERE wnd.delivery_id = p_delivery_id
1605: AND wnd.delivery_id = wdl.delivery_id

Line 1725: FND_MESSAGE.SET_TOKEN('DEL_NAME', WSH_NEW_DELIVERIES_PVT.Get_Name(p_delivery_id));

1721:
1722: --If transportation is not arranged by Buyer than error.
1723: IF (nvl(l_shipping_control,'$$$') <> 'BUYER') THEN
1724: FND_MESSAGE.SET_NAME('WSH','WSH_RR_NO_BUYER_DEL');
1725: FND_MESSAGE.SET_TOKEN('DEL_NAME', WSH_NEW_DELIVERIES_PVT.Get_Name(p_delivery_id));
1726: fnd_msg_pub.add;
1727:
1728: raise FND_API.G_EXC_ERROR;
1729: END IF;

Line 1750: FND_MESSAGE.SET_TOKEN('DEL_NAME', WSH_NEW_DELIVERIES_PVT.Get_Name(p_delivery_id));

1746: --Error, if any one of carrier,mode of transport or service level is NULL.
1747: IF (l_carrier_id IS NULL OR l_mode_of_transport IS NULL OR l_service_level IS NULL) THEN
1748: --
1749: FND_MESSAGE.SET_NAME('WSH', 'WSH_RR_NO_CARRIER_SETUP');
1750: FND_MESSAGE.SET_TOKEN('DEL_NAME', WSH_NEW_DELIVERIES_PVT.Get_Name(p_delivery_id));
1751: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR, l_moduleName);
1752: RAISE fnd_api.g_exc_error;
1753: --
1754: END IF;

Line 1778: FND_MESSAGE.SET_TOKEN('DEL_NAME', WSH_NEW_DELIVERIES_PVT.Get_Name(p_delivery_id));

1774: CLOSE get_carrier_name;
1775:
1776: --Delivery DEL_NAME is not tendered for carrier CARRIER.
1777: FND_MESSAGE.SET_NAME('WSH', 'WSH_RR_NO_TENDER');
1778: FND_MESSAGE.SET_TOKEN('DEL_NAME', WSH_NEW_DELIVERIES_PVT.Get_Name(p_delivery_id));
1779: FND_MESSAGE.SET_TOKEN('CARRIER', l_carrier_name);
1780: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_WARNING, l_moduleName);
1781: END IF;
1782: --

Line 1798: FND_MESSAGE.SET_TOKEN('DEL_NAME', WSH_NEW_DELIVERIES_PVT.Get_Name(p_delivery_id));

1794: FETCH get_carrier_name INTO l_carrier_name;
1795: CLOSE get_carrier_name;
1796:
1797: FND_MESSAGE.SET_NAME('WSH', 'WSH_RR_NO_TENDER_ACCEPT');
1798: FND_MESSAGE.SET_TOKEN('DEL_NAME', WSH_NEW_DELIVERIES_PVT.Get_Name(p_delivery_id));
1799: FND_MESSAGE.SET_TOKEN('CARRIER', l_carrier_name);
1800: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_WARNING, l_moduleName);
1801: END IF;
1802: --

Line 1908: FND_MESSAGE.SET_TOKEN('DEL_NAME', WSH_NEW_DELIVERIES_PVT.Get_Name(p_delivery_id));

1904: --No detail lines assign to delivery,error out.
1905: IF (l_po_header_id.count < 1) THEN
1906: --
1907: FND_MESSAGE.SET_NAME('WSH', 'WSH_DEL_NO_DETAILS');
1908: FND_MESSAGE.SET_TOKEN('DEL_NAME', WSH_NEW_DELIVERIES_PVT.Get_Name(p_delivery_id));
1909: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR, l_moduleName);
1910: raise fnd_api.g_exc_error;
1911: --
1912: END IF;

Line 2051: FROM wsh_new_deliveries

2047: FUNCTION LockDelivery(p_deliveryId IN NUMBER) RETURN BOOLEAN IS
2048: --
2049: CURSOR c_Deliv IS
2050: SELECT *
2051: FROM wsh_new_deliveries
2052: WHERE delivery_id = p_deliveryId
2053: FOR UPDATE NOWAIT;
2054: --
2055: l_debugOn BOOLEAN;