[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
165: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER interface_flag
166: FROM wsh_delivery_legs wdl,
167: wsh_trip_stops wts,
168: wsh_new_deliveries wnd,
169: wsh_trips wt
170: WHERE wt.trip_id = p_trip_id
171: AND wts.trip_id = wt.trip_id
172: AND wt.status_code = 'OP'
173: AND wdl.pick_up_stop_id = wts.stop_id
248: l_cc_trip_id_tab wsh_util_core.id_tab_type;
249: --dummy tables for calling validate_constraint_mainper
250: l_cc_del_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
251: l_cc_det_attr_tab wsh_glbl_var_strct_grp.Delivery_Details_Attr_Tbl_Type;
252: l_cc_trip_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
253: l_cc_stop_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
254: l_cc_in_ids wsh_util_core.id_tab_type;
255: l_cc_fail_ids wsh_util_core.id_tab_type;
256: --
319:
320: -- Bug 4100661 (FP: 4103129)
321: l_temp_trip_id NUMBER;
322: l_temp_lane_id NUMBER;
323: l_temp_ship_method_code WSH_TRIPS.SHIP_METHOD_CODE%TYPE;
324:
325: l_temp NUMBER;
326: l_is_del_assign_trip BOOLEAN;
327: --Bugfix 4070732
691: END IF;
692: --
693: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_CHECK_UNASSIGN_LVL) = 1 THEN
694: --
695: WSH_TRIPS_ACTIONS.check_unassign_trip (
696: p_del_rows => l_delivery_id_tab,
697: x_trip_rows => x_defaults_rec.trip_id_tab,
698: x_return_status => l_return_status);
699: --
1412: NVL(l_ship_method_code,l_temp_ship_method_code) <> l_temp_ship_method_code THEN
1413: CLOSE c_del_assign_to_trip;
1414: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1415: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEGMENT_CSM_CHANGE_ERROR');
1416: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_NAME', wsh_trips_pvt.get_name(l_temp_trip_id));
1417: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1418:
1419: wsh_util_core.api_post_call(
1420: p_return_status => l_return_status,
1691: END IF;
1692: --
1693: -- SSN change
1694: -- Validate stop_sequence_number if profile option is set to SSN
1695: IF (WSH_TRIPS_ACTIONS.GET_STOP_SEQ_MODE = WSH_INTERFACE_GRP.G_STOP_SEQ_MODE_SSN) AND
1696: (WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_SEQ_NUM_LVL) = 1) THEN
1697: --
1698: -- in context of creating new stops, their status is
1699: -- assumed to be NULL, so we need to pass 'OP'
1804: END LOOP;
1805: END IF;
1806: --END OTM R12
1807:
1808: WSH_TRIPS_ACTIONS.Assign_Trip (
1809: p_del_rows => l_delivery_id_tab,
1810: p_trip_id => l_trip_id,
1811: p_pickup_stop_id => p_action_prms.pickup_stop_id,
1812: p_pickup_stop_seq => p_action_prms.pickup_stop_seq,
1851: x_num_errors => l_num_errors);
1852: --
1853: END IF;
1854: --
1855: WSH_TRIPS_ACTIONS.Unassign_Trip (
1856: p_del_rows => l_delivery_id_tab,
1857: p_trip_id => l_trip_id,
1858: x_return_status => l_return_status);
1859: --
1987: wsh_debug_sv.log(l_module_name,'l_delivery_id_tab_temp count ',l_delivery_id_tab_temp.COUNT);
1988: END IF;
1989:
1990: /* J TP Release */
1991: WSH_TRIPS_ACTIONS.autocreate_trip_multi( p_del_rows => l_delivery_id_tab_temp,
1992: x_trip_ids => x_delivery_out_rec.result_id_tab,
1993: x_trip_names => l_trip_names,
1994: x_return_status => l_return_status);
1995:
2029: IF l_cc_upd_dlvy_ship_method='N' THEN
2030: FOR tripcurtemp in trip_cur(x_delivery_out_rec.result_id_tab(l_tripindex)) LOOP
2031: l_cc_dlvy_ship_method:=tripcurtemp.SHIP_METHOD_CODE;
2032: IF l_cc_upd_dlvy_ship_method='N' THEN
2033: update wsh_trips
2034: set SHIP_METHOD_CODE=null,
2035: CARRIER_ID = null,
2036: MODE_OF_TRANSPORT = null,
2037: SERVICE_LEVEL = null
2062: END IF;
2063:
2064: ELSE
2065: /* J TP Release */
2066: WSH_TRIPS_ACTIONS.autocreate_trip_multi( p_del_rows => l_delivery_id_tab,
2067: x_trip_ids => x_delivery_out_rec.result_id_tab,
2068: x_trip_names => l_trip_names,
2069: x_return_status => l_return_status);
2070:
2159: IF l_cc_upd_dlvy_ship_method='N' THEN
2160: FOR tripcurtemp in trip_cur(l_tripID) LOOP
2161: l_cc_dlvy_ship_method:=tripcurtemp.SHIP_METHOD_CODE;
2162: IF l_cc_upd_dlvy_ship_method='N' THEN
2163: update wsh_trips
2164: set SHIP_METHOD_CODE=null,
2165: CARRIER_ID = null,
2166: MODE_OF_TRANSPORT = null,
2167: SERVICE_LEVEL = null
2867:
2868: --l_num_errors := l_num_errors + l_loop_num_err;
2869: l_num_errors := l_num_errors + 1;
2870: FND_MESSAGE.SET_NAME('WSH','WSH_BOL_NULL_SHIP_METHOD_ERROR');
2871: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(dlvy_leg_rec.trip_id));
2872: l_return_status := wsh_util_core.g_ret_sts_error;
2873: wsh_util_core.add_message(l_return_status,l_module_name);
2874: IF l_debug_on THEN
2875: wsh_debug_sv.log (l_module_name,'No Ship Method for the trip'||dlvy_leg_rec.trip_id);
4615:
4616: --dummy tables for calling validate_constraint_mainper
4617: l_cc_del_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
4618: l_cc_det_attr_tab wsh_glbl_var_strct_grp.Delivery_Details_Attr_Tbl_Type;
4619: l_cc_trip_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
4620: l_cc_stop_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
4621: l_cc_in_ids wsh_util_core.id_tab_type;
4622: l_cc_fail_ids wsh_util_core.id_tab_type;
4623: l_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ;
6863: IF l_stop_seq = l_min_stop_seq
6864: OR l_stop_seq = l_max_stop_seq
6865: THEN
6866: -- {
6867: wsh_trips_pvt.lock_trip_no_compare(
6868: p_trip_id => l_trip_id
6869: );
6870: -- }
6871: END IF;