2998: FROM wsh_exception_definitions_vl
2999: WHERE exception_name = c_exception_name
3000: AND enabled = 'Y';
3001:
3002: l_carrier_rec WSH_CARRIERS_GRP.Carrier_Service_InOut_Rec_Type;
3003: l_del_first_trip NUMBER;
3004:
3005: --bug 3314353
3006: l_pick_up_stop_sequence_num NUMBER;
5927:
5928: l_carrier_rec.ship_method_code := p_ship_method;
5929:
5930:
5931: WSH_CARRIERS_GRP.get_carrier_service_mode(
5932: p_carrier_service_inout_rec => l_carrier_rec,
5933: x_return_status => l_return_status);
5934:
5935: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
6104: IF p_ship_method IS NOT NULL THEN
6105:
6106: l_carrier_rec.ship_method_code := p_ship_method;
6107:
6108: WSH_CARRIERS_GRP.get_carrier_service_mode(
6109: p_carrier_service_inout_rec => l_carrier_rec,
6110: x_return_status => l_return_status);
6111:
6112: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN