[Home] [Help]
63: IS
64:
65: CURSOR trip_cur(p_trip_id NUMBER) IS
66: SELECT SHIP_METHOD_CODE
67: FROM wsh_trips
68: WHERE trip_id = p_trip_id;
69:
70:
71: -- Bug 3346237 : Defer interface and enforce ship method to be taken from global parameters
129: SELECT distinct t.trip_id, t.ship_method_code, t.lane_id
130: FROM wsh_new_deliveries dl,
131: wsh_delivery_legs dg,
132: wsh_trip_stops st,
133: wsh_trips t
134: WHERE dl.delivery_id = c_delivery_id AND
135: dl.delivery_id = dg.delivery_id AND
136: (dg.pick_up_stop_id = st.stop_id
137: OR
145: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER interface_flag
146: FROM wsh_delivery_legs wdl,
147: wsh_trip_stops wts,
148: wsh_new_deliveries wnd,
149: wsh_trips wt
150: WHERE wt.trip_id = p_trip_id
151: AND wts.trip_id = wt.trip_id
152: AND wt.status_code = 'OP'
153: AND wdl.pick_up_stop_id = wts.stop_id
218: l_cc_trip_id_tab wsh_util_core.id_tab_type;
219: --dummy tables for calling validate_constraint_mainper
220: l_cc_del_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
221: l_cc_det_attr_tab wsh_glbl_var_strct_grp.Delivery_Details_Attr_Tbl_Type;
222: l_cc_trip_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
223: l_cc_stop_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
224: l_cc_in_ids wsh_util_core.id_tab_type;
225: l_cc_fail_ids wsh_util_core.id_tab_type;
226: --
289:
290: -- Bug 4100661 (FP: 4103129)
291: l_temp_trip_id NUMBER;
292: l_temp_lane_id NUMBER;
293: l_temp_ship_method_code WSH_TRIPS.SHIP_METHOD_CODE%TYPE;
294:
295: l_temp NUMBER;
296: l_is_del_assign_trip BOOLEAN;
297: --Bugfix 4070732
651: END IF;
652: --
653: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_CHECK_UNASSIGN_LVL) = 1 THEN
654: --
655: WSH_TRIPS_ACTIONS.check_unassign_trip (
656: p_del_rows => l_delivery_id_tab,
657: x_trip_rows => x_defaults_rec.trip_id_tab,
658: x_return_status => l_return_status);
659: --
1357: NVL(l_ship_method_code,l_temp_ship_method_code) <> l_temp_ship_method_code THEN
1358: CLOSE c_del_assign_to_trip;
1359: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1360: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEGMENT_CSM_CHANGE_ERROR');
1361: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_NAME', wsh_trips_pvt.get_name(l_temp_trip_id));
1362: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1363:
1364: wsh_util_core.api_post_call(
1365: p_return_status => l_return_status,
1636: END IF;
1637: --
1638: -- SSN change
1639: -- Validate stop_sequence_number if profile option is set to SSN
1640: IF (WSH_TRIPS_ACTIONS.GET_STOP_SEQ_MODE = WSH_INTERFACE_GRP.G_STOP_SEQ_MODE_SSN) AND
1641: (WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_SEQ_NUM_LVL) = 1) THEN
1642: --
1643: -- in context of creating new stops, their status is
1644: -- assumed to be NULL, so we need to pass 'OP'
1749: END LOOP;
1750: END IF;
1751: --END OTM R12
1752:
1753: WSH_TRIPS_ACTIONS.Assign_Trip (
1754: p_del_rows => l_delivery_id_tab,
1755: p_trip_id => l_trip_id,
1756: p_pickup_stop_id => p_action_prms.pickup_stop_id,
1757: p_pickup_stop_seq => p_action_prms.pickup_stop_seq,
1796: x_num_errors => l_num_errors);
1797: --
1798: END IF;
1799: --
1800: WSH_TRIPS_ACTIONS.Unassign_Trip (
1801: p_del_rows => l_delivery_id_tab,
1802: p_trip_id => l_trip_id,
1803: x_return_status => l_return_status);
1804: --
1932: wsh_debug_sv.log(l_module_name,'l_delivery_id_tab_temp count ',l_delivery_id_tab_temp.COUNT);
1933: END IF;
1934:
1935: /* J TP Release */
1936: WSH_TRIPS_ACTIONS.autocreate_trip_multi( p_del_rows => l_delivery_id_tab_temp,
1937: x_trip_ids => x_delivery_out_rec.result_id_tab,
1938: x_trip_names => l_trip_names,
1939: x_return_status => l_return_status);
1940:
1974: IF l_cc_upd_dlvy_ship_method='N' THEN
1975: FOR tripcurtemp in trip_cur(x_delivery_out_rec.result_id_tab(l_tripindex)) LOOP
1976: l_cc_dlvy_ship_method:=tripcurtemp.SHIP_METHOD_CODE;
1977: IF l_cc_upd_dlvy_ship_method='N' THEN
1978: update wsh_trips
1979: set SHIP_METHOD_CODE=null,
1980: CARRIER_ID = null,
1981: MODE_OF_TRANSPORT = null,
1982: SERVICE_LEVEL = null
2007: END IF;
2008:
2009: ELSE
2010: /* J TP Release */
2011: WSH_TRIPS_ACTIONS.autocreate_trip_multi( p_del_rows => l_delivery_id_tab,
2012: x_trip_ids => x_delivery_out_rec.result_id_tab,
2013: x_trip_names => l_trip_names,
2014: x_return_status => l_return_status);
2015:
2104: IF l_cc_upd_dlvy_ship_method='N' THEN
2105: FOR tripcurtemp in trip_cur(l_tripID) LOOP
2106: l_cc_dlvy_ship_method:=tripcurtemp.SHIP_METHOD_CODE;
2107: IF l_cc_upd_dlvy_ship_method='N' THEN
2108: update wsh_trips
2109: set SHIP_METHOD_CODE=null,
2110: CARRIER_ID = null,
2111: MODE_OF_TRANSPORT = null,
2112: SERVICE_LEVEL = null
2779:
2780: --l_num_errors := l_num_errors + l_loop_num_err;
2781: l_num_errors := l_num_errors + 1;
2782: FND_MESSAGE.SET_NAME('WSH','WSH_BOL_NULL_SHIP_METHOD_ERROR');
2783: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(dlvy_leg_rec.trip_id));
2784: l_return_status := wsh_util_core.g_ret_sts_error;
2785: wsh_util_core.add_message(l_return_status,l_module_name);
2786: IF l_debug_on THEN
2787: wsh_debug_sv.log (l_module_name,'No Ship Method for the trip'||dlvy_leg_rec.trip_id);
4442:
4443: --dummy tables for calling validate_constraint_mainper
4444: l_cc_del_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
4445: l_cc_det_attr_tab wsh_glbl_var_strct_grp.Delivery_Details_Attr_Tbl_Type;
4446: l_cc_trip_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
4447: l_cc_stop_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
4448: l_cc_in_ids wsh_util_core.id_tab_type;
4449: l_cc_fail_ids wsh_util_core.id_tab_type;
4450: l_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ;
6683: IF l_stop_seq = l_min_stop_seq
6684: OR l_stop_seq = l_max_stop_seq
6685: THEN
6686: -- {
6687: wsh_trips_pvt.lock_trip_no_compare(
6688: p_trip_id => l_trip_id
6689: );
6690: -- }
6691: END IF;