2089: --
2090: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
2091: THEN
2092: FND_MESSAGE.SET_NAME('WSH','WSH_PRICE_CNSLD_UNEXP_ERROR');
2093: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_in_rec1.trip_id));
2094: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR);
2095: RAISE FND_API.G_EXC_ERROR;
2096: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
2097: -- Bug 3278059, treat warning from rate_trip as success
2099: --{
2100: l_num_warnings := l_num_warnings + 1;
2101: --
2102: FND_MESSAGE.SET_NAME('WSH','WSH_PRICE_CNSLD_ERROR');
2103: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_in_rec1.trip_id));
2104: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING,l_module_name);
2105: --}
2106: END IF;
2107: --}
3012: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3013: l_locking_stops := 'N';
3014:
3015: -- lock trip p_trip_id;
3016: WSH_TRIPS_PVT.lock_trip_no_compare(p_stop_details_rec.trip_id);
3017:
3018: l_locking_stops := 'Y';
3019:
3020: open get_max_closed_seq( p_stop_details_rec.trip_id);