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.FTE_ACS_TRIP_PKG dependencies on FND_API

Line 63: l_commit VARCHAR2(100) := FND_API.G_FALSE;

59: l_stop_wt_vol_out_tab WSH_TRIP_STOPS_GRP.Stop_Wt_Vol_tab_type;
60: l_action_prms WSH_DELIVERIES_GRP.action_parameters_rectype;
61: l_rec_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
62: K_CREATE CONSTANT VARCHAR2(30) := 'CREATE';
63: l_commit VARCHAR2(100) := FND_API.G_FALSE;
64: l_init_msg_list VARCHAR2(100) := FND_API.G_FALSE;
65: l_api_version_number NUMBER := 1.0;
66: --l_delivery_id_tab WSH_NEW_DELIVERY_ACTIONS.TableNumbers;
67: l_index NUMBER;

Line 64: l_init_msg_list VARCHAR2(100) := FND_API.G_FALSE;

60: l_action_prms WSH_DELIVERIES_GRP.action_parameters_rectype;
61: l_rec_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
62: K_CREATE CONSTANT VARCHAR2(30) := 'CREATE';
63: l_commit VARCHAR2(100) := FND_API.G_FALSE;
64: l_init_msg_list VARCHAR2(100) := FND_API.G_FALSE;
65: l_api_version_number NUMBER := 1.0;
66: --l_delivery_id_tab WSH_NEW_DELIVERY_ACTIONS.TableNumbers;
67: l_index NUMBER;
68: l_pickup_stop_seq NUMBER;

Line 180: l_trip_info_tab(1).NAME := FND_API.G_MISS_CHAR;

176: l_trip_in_rec.action_code := p_action_code;
177:
178: -- 01. Create Trip
179:
180: l_trip_info_tab(1).NAME := FND_API.G_MISS_CHAR;
181: l_trip_info_tab(1).PLANNED_FLAG := 'N';
182: l_trip_info_tab(1).ARRIVE_AFTER_TRIP_ID := FND_API.G_MISS_NUM;
183: l_trip_info_tab(1).STATUS_CODE := 'OP';
184: l_trip_info_tab(1).VEHICLE_ITEM_ID := FND_API.G_MISS_NUM;

Line 182: l_trip_info_tab(1).ARRIVE_AFTER_TRIP_ID := FND_API.G_MISS_NUM;

178: -- 01. Create Trip
179:
180: l_trip_info_tab(1).NAME := FND_API.G_MISS_CHAR;
181: l_trip_info_tab(1).PLANNED_FLAG := 'N';
182: l_trip_info_tab(1).ARRIVE_AFTER_TRIP_ID := FND_API.G_MISS_NUM;
183: l_trip_info_tab(1).STATUS_CODE := 'OP';
184: l_trip_info_tab(1).VEHICLE_ITEM_ID := FND_API.G_MISS_NUM;
185: l_trip_info_tab(1).VEHICLE_ORGANIZATION_ID := FND_API.G_MISS_NUM;
186: l_trip_info_tab(1).VEHICLE_NUMBER := FND_API.G_MISS_CHAR;

Line 184: l_trip_info_tab(1).VEHICLE_ITEM_ID := FND_API.G_MISS_NUM;

180: l_trip_info_tab(1).NAME := FND_API.G_MISS_CHAR;
181: l_trip_info_tab(1).PLANNED_FLAG := 'N';
182: l_trip_info_tab(1).ARRIVE_AFTER_TRIP_ID := FND_API.G_MISS_NUM;
183: l_trip_info_tab(1).STATUS_CODE := 'OP';
184: l_trip_info_tab(1).VEHICLE_ITEM_ID := FND_API.G_MISS_NUM;
185: l_trip_info_tab(1).VEHICLE_ORGANIZATION_ID := FND_API.G_MISS_NUM;
186: l_trip_info_tab(1).VEHICLE_NUMBER := FND_API.G_MISS_CHAR;
187: l_trip_info_tab(1).VEHICLE_NUM_PREFIX := FND_API.G_MISS_CHAR;
188:

Line 185: l_trip_info_tab(1).VEHICLE_ORGANIZATION_ID := FND_API.G_MISS_NUM;

181: l_trip_info_tab(1).PLANNED_FLAG := 'N';
182: l_trip_info_tab(1).ARRIVE_AFTER_TRIP_ID := FND_API.G_MISS_NUM;
183: l_trip_info_tab(1).STATUS_CODE := 'OP';
184: l_trip_info_tab(1).VEHICLE_ITEM_ID := FND_API.G_MISS_NUM;
185: l_trip_info_tab(1).VEHICLE_ORGANIZATION_ID := FND_API.G_MISS_NUM;
186: l_trip_info_tab(1).VEHICLE_NUMBER := FND_API.G_MISS_CHAR;
187: l_trip_info_tab(1).VEHICLE_NUM_PREFIX := FND_API.G_MISS_CHAR;
188:
189: IF (p_carrier_sel_result_rec.carrier_id is null) THEN

Line 186: l_trip_info_tab(1).VEHICLE_NUMBER := FND_API.G_MISS_CHAR;

182: l_trip_info_tab(1).ARRIVE_AFTER_TRIP_ID := FND_API.G_MISS_NUM;
183: l_trip_info_tab(1).STATUS_CODE := 'OP';
184: l_trip_info_tab(1).VEHICLE_ITEM_ID := FND_API.G_MISS_NUM;
185: l_trip_info_tab(1).VEHICLE_ORGANIZATION_ID := FND_API.G_MISS_NUM;
186: l_trip_info_tab(1).VEHICLE_NUMBER := FND_API.G_MISS_CHAR;
187: l_trip_info_tab(1).VEHICLE_NUM_PREFIX := FND_API.G_MISS_CHAR;
188:
189: IF (p_carrier_sel_result_rec.carrier_id is null) THEN
190: l_trip_info_tab(1).CARRIER_ID := FND_API.G_MISS_NUM;

Line 187: l_trip_info_tab(1).VEHICLE_NUM_PREFIX := FND_API.G_MISS_CHAR;

183: l_trip_info_tab(1).STATUS_CODE := 'OP';
184: l_trip_info_tab(1).VEHICLE_ITEM_ID := FND_API.G_MISS_NUM;
185: l_trip_info_tab(1).VEHICLE_ORGANIZATION_ID := FND_API.G_MISS_NUM;
186: l_trip_info_tab(1).VEHICLE_NUMBER := FND_API.G_MISS_CHAR;
187: l_trip_info_tab(1).VEHICLE_NUM_PREFIX := FND_API.G_MISS_CHAR;
188:
189: IF (p_carrier_sel_result_rec.carrier_id is null) THEN
190: l_trip_info_tab(1).CARRIER_ID := FND_API.G_MISS_NUM;
191: ELSE

Line 190: l_trip_info_tab(1).CARRIER_ID := FND_API.G_MISS_NUM;

186: l_trip_info_tab(1).VEHICLE_NUMBER := FND_API.G_MISS_CHAR;
187: l_trip_info_tab(1).VEHICLE_NUM_PREFIX := FND_API.G_MISS_CHAR;
188:
189: IF (p_carrier_sel_result_rec.carrier_id is null) THEN
190: l_trip_info_tab(1).CARRIER_ID := FND_API.G_MISS_NUM;
191: ELSE
192: l_trip_info_tab(1).CARRIER_ID := p_carrier_sel_result_rec.carrier_id;
193: END IF;
194:

Line 196: l_trip_info_tab(1).SHIP_METHOD_CODE := FND_API.G_MISS_CHAR;

192: l_trip_info_tab(1).CARRIER_ID := p_carrier_sel_result_rec.carrier_id;
193: END IF;
194:
195: IF (p_carrier_sel_result_rec.ship_method_code is null) THEN
196: l_trip_info_tab(1).SHIP_METHOD_CODE := FND_API.G_MISS_CHAR;
197: ELSE
198: l_trip_info_tab(1).SHIP_METHOD_CODE := p_carrier_sel_result_rec.ship_method_code;
199: END IF;
200:

Line 203: l_trip_info_tab(1).CONSIGNEE_CARRIER_AC_NO := FND_API.G_MISS_CHAR;

199: END IF;
200:
201:
202: IF (p_carrier_sel_result_rec.consignee_carrier_ac_no is null) THEN
203: l_trip_info_tab(1).CONSIGNEE_CARRIER_AC_NO := FND_API.G_MISS_CHAR;
204: ELSE
205: l_trip_info_tab(1).CONSIGNEE_CARRIER_AC_NO := p_carrier_sel_result_rec.consignee_carrier_ac_no;
206: END IF;
207:

Line 212: l_trip_info_tab(1).RANK_ID := FND_API.G_MISS_NUM;

208: -- AG
209: -- cs_result_tab.rank stores rank_sequence
210: -- It is not same as trip's rank_id which has already been updated by FTE
211: -- rank_list_action API
212: l_trip_info_tab(1).RANK_ID := FND_API.G_MISS_NUM;
213:
214: IF (p_carrier_sel_result_rec.append_flag is null) THEN
215: l_trip_info_tab(1).APPEND_FLAG := FND_API.G_MISS_CHAR;
216: ELSE

Line 215: l_trip_info_tab(1).APPEND_FLAG := FND_API.G_MISS_CHAR;

211: -- rank_list_action API
212: l_trip_info_tab(1).RANK_ID := FND_API.G_MISS_NUM;
213:
214: IF (p_carrier_sel_result_rec.append_flag is null) THEN
215: l_trip_info_tab(1).APPEND_FLAG := FND_API.G_MISS_CHAR;
216: ELSE
217: l_trip_info_tab(1).APPEND_FLAG := p_carrier_sel_result_rec.append_flag;
218: END IF;
219:

Line 223: l_trip_info_tab(1).ROUTING_RULE_ID := FND_API.G_MISS_NUM;

219:
220: -- AG Use rule_id from p_cs_result_tab and not routing_rule_id
221:
222: IF (p_carrier_sel_result_rec.rule_id is null) THEN
223: l_trip_info_tab(1).ROUTING_RULE_ID := FND_API.G_MISS_NUM;
224: ELSE
225: l_trip_info_tab(1).ROUTING_RULE_ID := p_carrier_sel_result_rec.rule_id ;
226: END IF;
227:

Line 228: l_trip_info_tab(1).ROUTE_ID := FND_API.G_MISS_NUM;

224: ELSE
225: l_trip_info_tab(1).ROUTING_RULE_ID := p_carrier_sel_result_rec.rule_id ;
226: END IF;
227:
228: l_trip_info_tab(1).ROUTE_ID := FND_API.G_MISS_NUM;
229: l_trip_info_tab(1).ROUTING_INSTRUCTIONS := FND_API.G_MISS_CHAR;
230: l_trip_info_tab(1).ATTRIBUTE_CATEGORY := FND_API.G_MISS_CHAR;
231: l_trip_info_tab(1).ATTRIBUTE1 := FND_API.G_MISS_CHAR;
232: l_trip_info_tab(1).ATTRIBUTE2 := FND_API.G_MISS_CHAR;

Line 229: l_trip_info_tab(1).ROUTING_INSTRUCTIONS := FND_API.G_MISS_CHAR;

225: l_trip_info_tab(1).ROUTING_RULE_ID := p_carrier_sel_result_rec.rule_id ;
226: END IF;
227:
228: l_trip_info_tab(1).ROUTE_ID := FND_API.G_MISS_NUM;
229: l_trip_info_tab(1).ROUTING_INSTRUCTIONS := FND_API.G_MISS_CHAR;
230: l_trip_info_tab(1).ATTRIBUTE_CATEGORY := FND_API.G_MISS_CHAR;
231: l_trip_info_tab(1).ATTRIBUTE1 := FND_API.G_MISS_CHAR;
232: l_trip_info_tab(1).ATTRIBUTE2 := FND_API.G_MISS_CHAR;
233: l_trip_info_tab(1).ATTRIBUTE3 := FND_API.G_MISS_CHAR;

Line 230: l_trip_info_tab(1).ATTRIBUTE_CATEGORY := FND_API.G_MISS_CHAR;

226: END IF;
227:
228: l_trip_info_tab(1).ROUTE_ID := FND_API.G_MISS_NUM;
229: l_trip_info_tab(1).ROUTING_INSTRUCTIONS := FND_API.G_MISS_CHAR;
230: l_trip_info_tab(1).ATTRIBUTE_CATEGORY := FND_API.G_MISS_CHAR;
231: l_trip_info_tab(1).ATTRIBUTE1 := FND_API.G_MISS_CHAR;
232: l_trip_info_tab(1).ATTRIBUTE2 := FND_API.G_MISS_CHAR;
233: l_trip_info_tab(1).ATTRIBUTE3 := FND_API.G_MISS_CHAR;
234: l_trip_info_tab(1).ATTRIBUTE4 := FND_API.G_MISS_CHAR;

Line 231: l_trip_info_tab(1).ATTRIBUTE1 := FND_API.G_MISS_CHAR;

227:
228: l_trip_info_tab(1).ROUTE_ID := FND_API.G_MISS_NUM;
229: l_trip_info_tab(1).ROUTING_INSTRUCTIONS := FND_API.G_MISS_CHAR;
230: l_trip_info_tab(1).ATTRIBUTE_CATEGORY := FND_API.G_MISS_CHAR;
231: l_trip_info_tab(1).ATTRIBUTE1 := FND_API.G_MISS_CHAR;
232: l_trip_info_tab(1).ATTRIBUTE2 := FND_API.G_MISS_CHAR;
233: l_trip_info_tab(1).ATTRIBUTE3 := FND_API.G_MISS_CHAR;
234: l_trip_info_tab(1).ATTRIBUTE4 := FND_API.G_MISS_CHAR;
235: l_trip_info_tab(1).ATTRIBUTE5 := FND_API.G_MISS_CHAR;

Line 232: l_trip_info_tab(1).ATTRIBUTE2 := FND_API.G_MISS_CHAR;

228: l_trip_info_tab(1).ROUTE_ID := FND_API.G_MISS_NUM;
229: l_trip_info_tab(1).ROUTING_INSTRUCTIONS := FND_API.G_MISS_CHAR;
230: l_trip_info_tab(1).ATTRIBUTE_CATEGORY := FND_API.G_MISS_CHAR;
231: l_trip_info_tab(1).ATTRIBUTE1 := FND_API.G_MISS_CHAR;
232: l_trip_info_tab(1).ATTRIBUTE2 := FND_API.G_MISS_CHAR;
233: l_trip_info_tab(1).ATTRIBUTE3 := FND_API.G_MISS_CHAR;
234: l_trip_info_tab(1).ATTRIBUTE4 := FND_API.G_MISS_CHAR;
235: l_trip_info_tab(1).ATTRIBUTE5 := FND_API.G_MISS_CHAR;
236: l_trip_info_tab(1).ATTRIBUTE6 := FND_API.G_MISS_CHAR;

Line 233: l_trip_info_tab(1).ATTRIBUTE3 := FND_API.G_MISS_CHAR;

229: l_trip_info_tab(1).ROUTING_INSTRUCTIONS := FND_API.G_MISS_CHAR;
230: l_trip_info_tab(1).ATTRIBUTE_CATEGORY := FND_API.G_MISS_CHAR;
231: l_trip_info_tab(1).ATTRIBUTE1 := FND_API.G_MISS_CHAR;
232: l_trip_info_tab(1).ATTRIBUTE2 := FND_API.G_MISS_CHAR;
233: l_trip_info_tab(1).ATTRIBUTE3 := FND_API.G_MISS_CHAR;
234: l_trip_info_tab(1).ATTRIBUTE4 := FND_API.G_MISS_CHAR;
235: l_trip_info_tab(1).ATTRIBUTE5 := FND_API.G_MISS_CHAR;
236: l_trip_info_tab(1).ATTRIBUTE6 := FND_API.G_MISS_CHAR;
237: l_trip_info_tab(1).ATTRIBUTE7 := FND_API.G_MISS_CHAR;

Line 234: l_trip_info_tab(1).ATTRIBUTE4 := FND_API.G_MISS_CHAR;

230: l_trip_info_tab(1).ATTRIBUTE_CATEGORY := FND_API.G_MISS_CHAR;
231: l_trip_info_tab(1).ATTRIBUTE1 := FND_API.G_MISS_CHAR;
232: l_trip_info_tab(1).ATTRIBUTE2 := FND_API.G_MISS_CHAR;
233: l_trip_info_tab(1).ATTRIBUTE3 := FND_API.G_MISS_CHAR;
234: l_trip_info_tab(1).ATTRIBUTE4 := FND_API.G_MISS_CHAR;
235: l_trip_info_tab(1).ATTRIBUTE5 := FND_API.G_MISS_CHAR;
236: l_trip_info_tab(1).ATTRIBUTE6 := FND_API.G_MISS_CHAR;
237: l_trip_info_tab(1).ATTRIBUTE7 := FND_API.G_MISS_CHAR;
238: l_trip_info_tab(1).ATTRIBUTE8 := FND_API.G_MISS_CHAR;

Line 235: l_trip_info_tab(1).ATTRIBUTE5 := FND_API.G_MISS_CHAR;

231: l_trip_info_tab(1).ATTRIBUTE1 := FND_API.G_MISS_CHAR;
232: l_trip_info_tab(1).ATTRIBUTE2 := FND_API.G_MISS_CHAR;
233: l_trip_info_tab(1).ATTRIBUTE3 := FND_API.G_MISS_CHAR;
234: l_trip_info_tab(1).ATTRIBUTE4 := FND_API.G_MISS_CHAR;
235: l_trip_info_tab(1).ATTRIBUTE5 := FND_API.G_MISS_CHAR;
236: l_trip_info_tab(1).ATTRIBUTE6 := FND_API.G_MISS_CHAR;
237: l_trip_info_tab(1).ATTRIBUTE7 := FND_API.G_MISS_CHAR;
238: l_trip_info_tab(1).ATTRIBUTE8 := FND_API.G_MISS_CHAR;
239: l_trip_info_tab(1).ATTRIBUTE9 := FND_API.G_MISS_CHAR;

Line 236: l_trip_info_tab(1).ATTRIBUTE6 := FND_API.G_MISS_CHAR;

232: l_trip_info_tab(1).ATTRIBUTE2 := FND_API.G_MISS_CHAR;
233: l_trip_info_tab(1).ATTRIBUTE3 := FND_API.G_MISS_CHAR;
234: l_trip_info_tab(1).ATTRIBUTE4 := FND_API.G_MISS_CHAR;
235: l_trip_info_tab(1).ATTRIBUTE5 := FND_API.G_MISS_CHAR;
236: l_trip_info_tab(1).ATTRIBUTE6 := FND_API.G_MISS_CHAR;
237: l_trip_info_tab(1).ATTRIBUTE7 := FND_API.G_MISS_CHAR;
238: l_trip_info_tab(1).ATTRIBUTE8 := FND_API.G_MISS_CHAR;
239: l_trip_info_tab(1).ATTRIBUTE9 := FND_API.G_MISS_CHAR;
240: l_trip_info_tab(1).ATTRIBUTE10 := FND_API.G_MISS_CHAR;

Line 237: l_trip_info_tab(1).ATTRIBUTE7 := FND_API.G_MISS_CHAR;

233: l_trip_info_tab(1).ATTRIBUTE3 := FND_API.G_MISS_CHAR;
234: l_trip_info_tab(1).ATTRIBUTE4 := FND_API.G_MISS_CHAR;
235: l_trip_info_tab(1).ATTRIBUTE5 := FND_API.G_MISS_CHAR;
236: l_trip_info_tab(1).ATTRIBUTE6 := FND_API.G_MISS_CHAR;
237: l_trip_info_tab(1).ATTRIBUTE7 := FND_API.G_MISS_CHAR;
238: l_trip_info_tab(1).ATTRIBUTE8 := FND_API.G_MISS_CHAR;
239: l_trip_info_tab(1).ATTRIBUTE9 := FND_API.G_MISS_CHAR;
240: l_trip_info_tab(1).ATTRIBUTE10 := FND_API.G_MISS_CHAR;
241: l_trip_info_tab(1).ATTRIBUTE11 := FND_API.G_MISS_CHAR;

Line 238: l_trip_info_tab(1).ATTRIBUTE8 := FND_API.G_MISS_CHAR;

234: l_trip_info_tab(1).ATTRIBUTE4 := FND_API.G_MISS_CHAR;
235: l_trip_info_tab(1).ATTRIBUTE5 := FND_API.G_MISS_CHAR;
236: l_trip_info_tab(1).ATTRIBUTE6 := FND_API.G_MISS_CHAR;
237: l_trip_info_tab(1).ATTRIBUTE7 := FND_API.G_MISS_CHAR;
238: l_trip_info_tab(1).ATTRIBUTE8 := FND_API.G_MISS_CHAR;
239: l_trip_info_tab(1).ATTRIBUTE9 := FND_API.G_MISS_CHAR;
240: l_trip_info_tab(1).ATTRIBUTE10 := FND_API.G_MISS_CHAR;
241: l_trip_info_tab(1).ATTRIBUTE11 := FND_API.G_MISS_CHAR;
242: l_trip_info_tab(1).ATTRIBUTE12 := FND_API.G_MISS_CHAR;

Line 239: l_trip_info_tab(1).ATTRIBUTE9 := FND_API.G_MISS_CHAR;

235: l_trip_info_tab(1).ATTRIBUTE5 := FND_API.G_MISS_CHAR;
236: l_trip_info_tab(1).ATTRIBUTE6 := FND_API.G_MISS_CHAR;
237: l_trip_info_tab(1).ATTRIBUTE7 := FND_API.G_MISS_CHAR;
238: l_trip_info_tab(1).ATTRIBUTE8 := FND_API.G_MISS_CHAR;
239: l_trip_info_tab(1).ATTRIBUTE9 := FND_API.G_MISS_CHAR;
240: l_trip_info_tab(1).ATTRIBUTE10 := FND_API.G_MISS_CHAR;
241: l_trip_info_tab(1).ATTRIBUTE11 := FND_API.G_MISS_CHAR;
242: l_trip_info_tab(1).ATTRIBUTE12 := FND_API.G_MISS_CHAR;
243: l_trip_info_tab(1).ATTRIBUTE13 := FND_API.G_MISS_CHAR;

Line 240: l_trip_info_tab(1).ATTRIBUTE10 := FND_API.G_MISS_CHAR;

236: l_trip_info_tab(1).ATTRIBUTE6 := FND_API.G_MISS_CHAR;
237: l_trip_info_tab(1).ATTRIBUTE7 := FND_API.G_MISS_CHAR;
238: l_trip_info_tab(1).ATTRIBUTE8 := FND_API.G_MISS_CHAR;
239: l_trip_info_tab(1).ATTRIBUTE9 := FND_API.G_MISS_CHAR;
240: l_trip_info_tab(1).ATTRIBUTE10 := FND_API.G_MISS_CHAR;
241: l_trip_info_tab(1).ATTRIBUTE11 := FND_API.G_MISS_CHAR;
242: l_trip_info_tab(1).ATTRIBUTE12 := FND_API.G_MISS_CHAR;
243: l_trip_info_tab(1).ATTRIBUTE13 := FND_API.G_MISS_CHAR;
244: l_trip_info_tab(1).ATTRIBUTE14 := FND_API.G_MISS_CHAR;

Line 241: l_trip_info_tab(1).ATTRIBUTE11 := FND_API.G_MISS_CHAR;

237: l_trip_info_tab(1).ATTRIBUTE7 := FND_API.G_MISS_CHAR;
238: l_trip_info_tab(1).ATTRIBUTE8 := FND_API.G_MISS_CHAR;
239: l_trip_info_tab(1).ATTRIBUTE9 := FND_API.G_MISS_CHAR;
240: l_trip_info_tab(1).ATTRIBUTE10 := FND_API.G_MISS_CHAR;
241: l_trip_info_tab(1).ATTRIBUTE11 := FND_API.G_MISS_CHAR;
242: l_trip_info_tab(1).ATTRIBUTE12 := FND_API.G_MISS_CHAR;
243: l_trip_info_tab(1).ATTRIBUTE13 := FND_API.G_MISS_CHAR;
244: l_trip_info_tab(1).ATTRIBUTE14 := FND_API.G_MISS_CHAR;
245: l_trip_info_tab(1).ATTRIBUTE15 := FND_API.G_MISS_CHAR;

Line 242: l_trip_info_tab(1).ATTRIBUTE12 := FND_API.G_MISS_CHAR;

238: l_trip_info_tab(1).ATTRIBUTE8 := FND_API.G_MISS_CHAR;
239: l_trip_info_tab(1).ATTRIBUTE9 := FND_API.G_MISS_CHAR;
240: l_trip_info_tab(1).ATTRIBUTE10 := FND_API.G_MISS_CHAR;
241: l_trip_info_tab(1).ATTRIBUTE11 := FND_API.G_MISS_CHAR;
242: l_trip_info_tab(1).ATTRIBUTE12 := FND_API.G_MISS_CHAR;
243: l_trip_info_tab(1).ATTRIBUTE13 := FND_API.G_MISS_CHAR;
244: l_trip_info_tab(1).ATTRIBUTE14 := FND_API.G_MISS_CHAR;
245: l_trip_info_tab(1).ATTRIBUTE15 := FND_API.G_MISS_CHAR;
246: l_trip_info_tab(1).IGNORE_FOR_PLANNING := l_ignore_for_planning;

Line 243: l_trip_info_tab(1).ATTRIBUTE13 := FND_API.G_MISS_CHAR;

239: l_trip_info_tab(1).ATTRIBUTE9 := FND_API.G_MISS_CHAR;
240: l_trip_info_tab(1).ATTRIBUTE10 := FND_API.G_MISS_CHAR;
241: l_trip_info_tab(1).ATTRIBUTE11 := FND_API.G_MISS_CHAR;
242: l_trip_info_tab(1).ATTRIBUTE12 := FND_API.G_MISS_CHAR;
243: l_trip_info_tab(1).ATTRIBUTE13 := FND_API.G_MISS_CHAR;
244: l_trip_info_tab(1).ATTRIBUTE14 := FND_API.G_MISS_CHAR;
245: l_trip_info_tab(1).ATTRIBUTE15 := FND_API.G_MISS_CHAR;
246: l_trip_info_tab(1).IGNORE_FOR_PLANNING := l_ignore_for_planning;
247: l_trip_info_tab(1).CREATION_DATE := SYSDATE;

Line 244: l_trip_info_tab(1).ATTRIBUTE14 := FND_API.G_MISS_CHAR;

240: l_trip_info_tab(1).ATTRIBUTE10 := FND_API.G_MISS_CHAR;
241: l_trip_info_tab(1).ATTRIBUTE11 := FND_API.G_MISS_CHAR;
242: l_trip_info_tab(1).ATTRIBUTE12 := FND_API.G_MISS_CHAR;
243: l_trip_info_tab(1).ATTRIBUTE13 := FND_API.G_MISS_CHAR;
244: l_trip_info_tab(1).ATTRIBUTE14 := FND_API.G_MISS_CHAR;
245: l_trip_info_tab(1).ATTRIBUTE15 := FND_API.G_MISS_CHAR;
246: l_trip_info_tab(1).IGNORE_FOR_PLANNING := l_ignore_for_planning;
247: l_trip_info_tab(1).CREATION_DATE := SYSDATE;
248: l_trip_info_tab(1).CREATED_BY := fnd_global.user_id;

Line 245: l_trip_info_tab(1).ATTRIBUTE15 := FND_API.G_MISS_CHAR;

241: l_trip_info_tab(1).ATTRIBUTE11 := FND_API.G_MISS_CHAR;
242: l_trip_info_tab(1).ATTRIBUTE12 := FND_API.G_MISS_CHAR;
243: l_trip_info_tab(1).ATTRIBUTE13 := FND_API.G_MISS_CHAR;
244: l_trip_info_tab(1).ATTRIBUTE14 := FND_API.G_MISS_CHAR;
245: l_trip_info_tab(1).ATTRIBUTE15 := FND_API.G_MISS_CHAR;
246: l_trip_info_tab(1).IGNORE_FOR_PLANNING := l_ignore_for_planning;
247: l_trip_info_tab(1).CREATION_DATE := SYSDATE;
248: l_trip_info_tab(1).CREATED_BY := fnd_global.user_id;
249: l_trip_info_tab(1).LAST_UPDATE_DATE := SYSDATE;

Line 252: l_trip_info_tab(1).PROGRAM_APPLICATION_ID := FND_API.G_MISS_NUM;

248: l_trip_info_tab(1).CREATED_BY := fnd_global.user_id;
249: l_trip_info_tab(1).LAST_UPDATE_DATE := SYSDATE;
250: l_trip_info_tab(1).LAST_UPDATED_BY := fnd_global.user_id;
251: l_trip_info_tab(1).LAST_UPDATE_LOGIN := fnd_global.login_id;
252: l_trip_info_tab(1).PROGRAM_APPLICATION_ID := FND_API.G_MISS_NUM;
253: l_trip_info_tab(1).PROGRAM_ID := FND_API.G_MISS_NUM;
254: l_trip_info_tab(1).PROGRAM_UPDATE_DATE := FND_API.G_MISS_DATE;
255: l_trip_info_tab(1).REQUEST_ID := FND_API.G_MISS_NUM;
256:

Line 253: l_trip_info_tab(1).PROGRAM_ID := FND_API.G_MISS_NUM;

249: l_trip_info_tab(1).LAST_UPDATE_DATE := SYSDATE;
250: l_trip_info_tab(1).LAST_UPDATED_BY := fnd_global.user_id;
251: l_trip_info_tab(1).LAST_UPDATE_LOGIN := fnd_global.login_id;
252: l_trip_info_tab(1).PROGRAM_APPLICATION_ID := FND_API.G_MISS_NUM;
253: l_trip_info_tab(1).PROGRAM_ID := FND_API.G_MISS_NUM;
254: l_trip_info_tab(1).PROGRAM_UPDATE_DATE := FND_API.G_MISS_DATE;
255: l_trip_info_tab(1).REQUEST_ID := FND_API.G_MISS_NUM;
256:
257: IF (p_carrier_sel_result_rec.service_level is null) THEN

Line 254: l_trip_info_tab(1).PROGRAM_UPDATE_DATE := FND_API.G_MISS_DATE;

250: l_trip_info_tab(1).LAST_UPDATED_BY := fnd_global.user_id;
251: l_trip_info_tab(1).LAST_UPDATE_LOGIN := fnd_global.login_id;
252: l_trip_info_tab(1).PROGRAM_APPLICATION_ID := FND_API.G_MISS_NUM;
253: l_trip_info_tab(1).PROGRAM_ID := FND_API.G_MISS_NUM;
254: l_trip_info_tab(1).PROGRAM_UPDATE_DATE := FND_API.G_MISS_DATE;
255: l_trip_info_tab(1).REQUEST_ID := FND_API.G_MISS_NUM;
256:
257: IF (p_carrier_sel_result_rec.service_level is null) THEN
258: l_trip_info_tab(1).SERVICE_LEVEL := FND_API.G_MISS_CHAR;

Line 255: l_trip_info_tab(1).REQUEST_ID := FND_API.G_MISS_NUM;

251: l_trip_info_tab(1).LAST_UPDATE_LOGIN := fnd_global.login_id;
252: l_trip_info_tab(1).PROGRAM_APPLICATION_ID := FND_API.G_MISS_NUM;
253: l_trip_info_tab(1).PROGRAM_ID := FND_API.G_MISS_NUM;
254: l_trip_info_tab(1).PROGRAM_UPDATE_DATE := FND_API.G_MISS_DATE;
255: l_trip_info_tab(1).REQUEST_ID := FND_API.G_MISS_NUM;
256:
257: IF (p_carrier_sel_result_rec.service_level is null) THEN
258: l_trip_info_tab(1).SERVICE_LEVEL := FND_API.G_MISS_CHAR;
259: ELSE

Line 258: l_trip_info_tab(1).SERVICE_LEVEL := FND_API.G_MISS_CHAR;

254: l_trip_info_tab(1).PROGRAM_UPDATE_DATE := FND_API.G_MISS_DATE;
255: l_trip_info_tab(1).REQUEST_ID := FND_API.G_MISS_NUM;
256:
257: IF (p_carrier_sel_result_rec.service_level is null) THEN
258: l_trip_info_tab(1).SERVICE_LEVEL := FND_API.G_MISS_CHAR;
259: ELSE
260: l_trip_info_tab(1).SERVICE_LEVEL := p_carrier_sel_result_rec.service_level;
261: END IF;
262:

Line 264: l_trip_info_tab(1).MODE_OF_TRANSPORT := FND_API.G_MISS_CHAR;

260: l_trip_info_tab(1).SERVICE_LEVEL := p_carrier_sel_result_rec.service_level;
261: END IF;
262:
263: IF (p_carrier_sel_result_rec.mode_of_transport is null) THEN
264: l_trip_info_tab(1).MODE_OF_TRANSPORT := FND_API.G_MISS_CHAR;
265: ELSE
266: l_trip_info_tab(1).MODE_OF_TRANSPORT := p_carrier_sel_result_rec.mode_of_transport;
267: END IF;
268:

Line 270: l_trip_info_tab(1).FREIGHT_TERMS_CODE := FND_API.G_MISS_CHAR;

266: l_trip_info_tab(1).MODE_OF_TRANSPORT := p_carrier_sel_result_rec.mode_of_transport;
267: END IF;
268:
269: IF (p_carrier_sel_result_rec.freight_terms_code is null) THEN
270: l_trip_info_tab(1).FREIGHT_TERMS_CODE := FND_API.G_MISS_CHAR;
271: ELSE
272: l_trip_info_tab(1).FREIGHT_TERMS_CODE := p_carrier_sel_result_rec.freight_terms_code;
273: END IF;
274:

Line 275: l_trip_info_tab(1).CONSOLIDATION_ALLOWED := FND_API.G_MISS_CHAR;

271: ELSE
272: l_trip_info_tab(1).FREIGHT_TERMS_CODE := p_carrier_sel_result_rec.freight_terms_code;
273: END IF;
274:
275: l_trip_info_tab(1).CONSOLIDATION_ALLOWED := FND_API.G_MISS_CHAR;
276: l_trip_info_tab(1).LOAD_TENDER_STATUS := FND_API.G_MISS_CHAR;
277: l_trip_info_tab(1).ROUTE_LANE_ID := FND_API.G_MISS_NUM;
278: l_trip_info_tab(1).LANE_ID := FND_API.G_MISS_NUM;
279: l_trip_info_tab(1).SCHEDULE_ID := FND_API.G_MISS_NUM;

Line 276: l_trip_info_tab(1).LOAD_TENDER_STATUS := FND_API.G_MISS_CHAR;

272: l_trip_info_tab(1).FREIGHT_TERMS_CODE := p_carrier_sel_result_rec.freight_terms_code;
273: END IF;
274:
275: l_trip_info_tab(1).CONSOLIDATION_ALLOWED := FND_API.G_MISS_CHAR;
276: l_trip_info_tab(1).LOAD_TENDER_STATUS := FND_API.G_MISS_CHAR;
277: l_trip_info_tab(1).ROUTE_LANE_ID := FND_API.G_MISS_NUM;
278: l_trip_info_tab(1).LANE_ID := FND_API.G_MISS_NUM;
279: l_trip_info_tab(1).SCHEDULE_ID := FND_API.G_MISS_NUM;
280: l_trip_info_tab(1).BOOKING_NUMBER := FND_API.G_MISS_CHAR;

Line 277: l_trip_info_tab(1).ROUTE_LANE_ID := FND_API.G_MISS_NUM;

273: END IF;
274:
275: l_trip_info_tab(1).CONSOLIDATION_ALLOWED := FND_API.G_MISS_CHAR;
276: l_trip_info_tab(1).LOAD_TENDER_STATUS := FND_API.G_MISS_CHAR;
277: l_trip_info_tab(1).ROUTE_LANE_ID := FND_API.G_MISS_NUM;
278: l_trip_info_tab(1).LANE_ID := FND_API.G_MISS_NUM;
279: l_trip_info_tab(1).SCHEDULE_ID := FND_API.G_MISS_NUM;
280: l_trip_info_tab(1).BOOKING_NUMBER := FND_API.G_MISS_CHAR;
281: l_trip_info_tab(1).ARRIVE_AFTER_TRIP_NAME := FND_API.G_MISS_CHAR;

Line 278: l_trip_info_tab(1).LANE_ID := FND_API.G_MISS_NUM;

274:
275: l_trip_info_tab(1).CONSOLIDATION_ALLOWED := FND_API.G_MISS_CHAR;
276: l_trip_info_tab(1).LOAD_TENDER_STATUS := FND_API.G_MISS_CHAR;
277: l_trip_info_tab(1).ROUTE_LANE_ID := FND_API.G_MISS_NUM;
278: l_trip_info_tab(1).LANE_ID := FND_API.G_MISS_NUM;
279: l_trip_info_tab(1).SCHEDULE_ID := FND_API.G_MISS_NUM;
280: l_trip_info_tab(1).BOOKING_NUMBER := FND_API.G_MISS_CHAR;
281: l_trip_info_tab(1).ARRIVE_AFTER_TRIP_NAME := FND_API.G_MISS_CHAR;
282: l_trip_info_tab(1).SHIP_METHOD_NAME := FND_API.G_MISS_CHAR;

Line 279: l_trip_info_tab(1).SCHEDULE_ID := FND_API.G_MISS_NUM;

275: l_trip_info_tab(1).CONSOLIDATION_ALLOWED := FND_API.G_MISS_CHAR;
276: l_trip_info_tab(1).LOAD_TENDER_STATUS := FND_API.G_MISS_CHAR;
277: l_trip_info_tab(1).ROUTE_LANE_ID := FND_API.G_MISS_NUM;
278: l_trip_info_tab(1).LANE_ID := FND_API.G_MISS_NUM;
279: l_trip_info_tab(1).SCHEDULE_ID := FND_API.G_MISS_NUM;
280: l_trip_info_tab(1).BOOKING_NUMBER := FND_API.G_MISS_CHAR;
281: l_trip_info_tab(1).ARRIVE_AFTER_TRIP_NAME := FND_API.G_MISS_CHAR;
282: l_trip_info_tab(1).SHIP_METHOD_NAME := FND_API.G_MISS_CHAR;
283: l_trip_info_tab(1).VEHICLE_ITEM_DESC := FND_API.G_MISS_CHAR;

Line 280: l_trip_info_tab(1).BOOKING_NUMBER := FND_API.G_MISS_CHAR;

276: l_trip_info_tab(1).LOAD_TENDER_STATUS := FND_API.G_MISS_CHAR;
277: l_trip_info_tab(1).ROUTE_LANE_ID := FND_API.G_MISS_NUM;
278: l_trip_info_tab(1).LANE_ID := FND_API.G_MISS_NUM;
279: l_trip_info_tab(1).SCHEDULE_ID := FND_API.G_MISS_NUM;
280: l_trip_info_tab(1).BOOKING_NUMBER := FND_API.G_MISS_CHAR;
281: l_trip_info_tab(1).ARRIVE_AFTER_TRIP_NAME := FND_API.G_MISS_CHAR;
282: l_trip_info_tab(1).SHIP_METHOD_NAME := FND_API.G_MISS_CHAR;
283: l_trip_info_tab(1).VEHICLE_ITEM_DESC := FND_API.G_MISS_CHAR;
284: l_trip_info_tab(1).VEHICLE_ORGANIZATION_CODE := FND_API.G_MISS_CHAR;

Line 281: l_trip_info_tab(1).ARRIVE_AFTER_TRIP_NAME := FND_API.G_MISS_CHAR;

277: l_trip_info_tab(1).ROUTE_LANE_ID := FND_API.G_MISS_NUM;
278: l_trip_info_tab(1).LANE_ID := FND_API.G_MISS_NUM;
279: l_trip_info_tab(1).SCHEDULE_ID := FND_API.G_MISS_NUM;
280: l_trip_info_tab(1).BOOKING_NUMBER := FND_API.G_MISS_CHAR;
281: l_trip_info_tab(1).ARRIVE_AFTER_TRIP_NAME := FND_API.G_MISS_CHAR;
282: l_trip_info_tab(1).SHIP_METHOD_NAME := FND_API.G_MISS_CHAR;
283: l_trip_info_tab(1).VEHICLE_ITEM_DESC := FND_API.G_MISS_CHAR;
284: l_trip_info_tab(1).VEHICLE_ORGANIZATION_CODE := FND_API.G_MISS_CHAR;
285:

Line 282: l_trip_info_tab(1).SHIP_METHOD_NAME := FND_API.G_MISS_CHAR;

278: l_trip_info_tab(1).LANE_ID := FND_API.G_MISS_NUM;
279: l_trip_info_tab(1).SCHEDULE_ID := FND_API.G_MISS_NUM;
280: l_trip_info_tab(1).BOOKING_NUMBER := FND_API.G_MISS_CHAR;
281: l_trip_info_tab(1).ARRIVE_AFTER_TRIP_NAME := FND_API.G_MISS_CHAR;
282: l_trip_info_tab(1).SHIP_METHOD_NAME := FND_API.G_MISS_CHAR;
283: l_trip_info_tab(1).VEHICLE_ITEM_DESC := FND_API.G_MISS_CHAR;
284: l_trip_info_tab(1).VEHICLE_ORGANIZATION_CODE := FND_API.G_MISS_CHAR;
285:
286: WSH_TRIPS_GRP.Create_Update_Trip(

Line 283: l_trip_info_tab(1).VEHICLE_ITEM_DESC := FND_API.G_MISS_CHAR;

279: l_trip_info_tab(1).SCHEDULE_ID := FND_API.G_MISS_NUM;
280: l_trip_info_tab(1).BOOKING_NUMBER := FND_API.G_MISS_CHAR;
281: l_trip_info_tab(1).ARRIVE_AFTER_TRIP_NAME := FND_API.G_MISS_CHAR;
282: l_trip_info_tab(1).SHIP_METHOD_NAME := FND_API.G_MISS_CHAR;
283: l_trip_info_tab(1).VEHICLE_ITEM_DESC := FND_API.G_MISS_CHAR;
284: l_trip_info_tab(1).VEHICLE_ORGANIZATION_CODE := FND_API.G_MISS_CHAR;
285:
286: WSH_TRIPS_GRP.Create_Update_Trip(
287: p_api_version_number => l_api_version_number,

Line 284: l_trip_info_tab(1).VEHICLE_ORGANIZATION_CODE := FND_API.G_MISS_CHAR;

280: l_trip_info_tab(1).BOOKING_NUMBER := FND_API.G_MISS_CHAR;
281: l_trip_info_tab(1).ARRIVE_AFTER_TRIP_NAME := FND_API.G_MISS_CHAR;
282: l_trip_info_tab(1).SHIP_METHOD_NAME := FND_API.G_MISS_CHAR;
283: l_trip_info_tab(1).VEHICLE_ITEM_DESC := FND_API.G_MISS_CHAR;
284: l_trip_info_tab(1).VEHICLE_ORGANIZATION_CODE := FND_API.G_MISS_CHAR;
285:
286: WSH_TRIPS_GRP.Create_Update_Trip(
287: p_api_version_number => l_api_version_number,
288: p_init_msg_list => l_init_msg_list,

Line 298: raise FND_API.G_EXC_UNEXPECTED_ERROR;

294: p_in_rec => l_trip_in_rec,
295: x_out_tab => l_trip_out_rec_tab);
296:
297: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
298: raise FND_API.G_EXC_UNEXPECTED_ERROR;
299: END IF;
300:
301: l_trip_id := l_trip_out_rec_tab(1).trip_id;
302: l_trip_name := l_trip_out_rec_tab(1).trip_name;

Line 350: raise FND_API.G_EXC_UNEXPECTED_ERROR;

346: x_msg_data => l_msg_data,
347: x_stop_wt_vol_out_tab => l_stop_wt_vol_out_tab);
348:
349: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
350: raise FND_API.G_EXC_UNEXPECTED_ERROR;
351: END IF;
352:
353: IF l_debug_on THEN
354: WSH_DEBUG_SV.logmsg(l_module_name,'Stop1: stop_id :'||l_pickup_stop_out_tab(1).stop_id);

Line 381: raise FND_API.G_EXC_UNEXPECTED_ERROR;

377: x_msg_data => l_msg_data,
378: x_stop_wt_vol_out_tab => l_stop_wt_vol_out_tab);
379:
380: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
381: raise FND_API.G_EXC_UNEXPECTED_ERROR;
382: END IF;
383:
384: IF l_debug_on THEN
385: WSH_DEBUG_SV.logmsg(l_module_name,'Stop2: stop_id :'||l_dropoff_stop_out_tab(1).stop_id);

Line 455: raise FND_API.G_EXC_UNEXPECTED_ERROR;

451: x_msg_count => l_msg_count,
452: x_msg_data => l_msg_data);
453:
454: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
455: raise FND_API.G_EXC_UNEXPECTED_ERROR;
456: END IF;
457:
458: x_trip_id := l_trip_id;
459: x_trip_name := l_trip_name;

Line 537: raise FND_API.G_EXC_UNEXPECTED_ERROR;

533:
534:
535: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
536: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
537: raise FND_API.G_EXC_UNEXPECTED_ERROR;
538: END IF;
539: END IF;
540:
541: itr := l_result_tab.FIRST;

Line 594: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

590: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
591:
592: IF l_debug_on THEN
593: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
594: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
595: END IF;
596: --
597:
598: END GET_RANKED_RESULTS;