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

Line 18: -- p_init_msg_list FND_API.G_TRUE to reset list

14: --========================================================================
15: -- PROCEDURE : Stop_Action PUBLIC
16: --
17: -- PARAMETERS: p_api_version_number known api version error number
18: -- p_init_msg_list FND_API.G_TRUE to reset list
19: -- x_return_status return status
20: -- x_msg_count number of messages in the list
21: -- x_msg_data text of messages
22: -- p_action_code Stop action code. Valid action codes are

Line 113: IF NOT FND_API.Compatible_API_Call

109: p_defer_interface_flag);
110: END IF;
111:
112: -- Standard call to check for call compatibility
113: IF NOT FND_API.Compatible_API_Call
114: ( l_api_version_number
115: , p_api_version_number
116: , l_api_name
117: , G_PKG_NAME

Line 120: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

116: , l_api_name
117: , G_PKG_NAME
118: )
119: THEN
120: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
121: END IF;
122:
123: -- Initialize message stack if required
124: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 124: IF FND_API.to_Boolean(p_init_msg_list) THEN

120: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
121: END IF;
122:
123: -- Initialize message stack if required
124: IF FND_API.to_Boolean(p_init_msg_list) THEN
125: FND_MSG_PUB.initialize;
126: END IF;
127:
128:

Line 138: AND (l_stop_location_id <> FND_API.G_MISS_NUM))

134: x_num_warnings =>l_num_warning,
135: x_num_errors =>l_num_errors);
136:
137: IF ((l_stop_location_id IS NOT NULL)
138: AND (l_stop_location_id <> FND_API.G_MISS_NUM))
139: OR ((p_stop_location_code IS NOT NULL)
140: AND (p_stop_location_code <> FND_API.G_MISS_CHAR)) THEN
141:
142: wsh_util_validate.validate_location( l_stop_location_id,

Line 140: AND (p_stop_location_code <> FND_API.G_MISS_CHAR)) THEN

136:
137: IF ((l_stop_location_id IS NOT NULL)
138: AND (l_stop_location_id <> FND_API.G_MISS_NUM))
139: OR ((p_stop_location_code IS NOT NULL)
140: AND (p_stop_location_code <> FND_API.G_MISS_CHAR)) THEN
141:
142: wsh_util_validate.validate_location( l_stop_location_id,
143: p_stop_location_code,
144: l_return_status);

Line 162: RAISE FND_API.G_EXC_ERROR;

158: x_num_warnings =>l_num_warning,
159: x_num_errors =>l_num_errors);
160:
161: IF (l_stop_id IS NULL) THEN
162: RAISE FND_API.G_EXC_ERROR;
163: END IF;
164:
165: l_action_prms.caller := 'WSH_PUB';
166: IF UPPER(p_action_code) IN ('CLOSE','ARRIVE') THEN

Line 178: p_init_msg_list => FND_API.G_FALSE,

174: l_entity_id_tab(1) := l_stop_id;
175:
176: WSH_INTERFACE_GRP.Stop_Action (
177: p_api_version_number => 1.0,
178: p_init_msg_list => FND_API.G_FALSE,
179: p_commit => FND_API.G_TRUE,
180: p_entity_id_tab => l_entity_id_tab,
181: p_action_prms => l_action_prms,
182: x_stop_out_rec => l_stop_out_rec,

Line 179: p_commit => FND_API.G_TRUE,

175:
176: WSH_INTERFACE_GRP.Stop_Action (
177: p_api_version_number => 1.0,
178: p_init_msg_list => FND_API.G_FALSE,
179: p_commit => FND_API.G_TRUE,
180: p_entity_id_tab => l_entity_id_tab,
181: p_action_prms => l_action_prms,
182: x_stop_out_rec => l_stop_out_rec,
183: x_return_status => x_return_status,

Line 190: , p_encoded => FND_API.G_FALSE

186:
187: FND_MSG_PUB.Count_And_Get
188: ( p_count => x_msg_count
189: , p_data => x_msg_data
190: , p_encoded => FND_API.G_FALSE
191: );
192:
193: IF l_debug_on THEN
194: WSH_DEBUG_SV.pop(l_module_name);

Line 199: WHEN FND_API.G_EXC_ERROR THEN

195: END IF;
196:
197: EXCEPTION
198:
199: WHEN FND_API.G_EXC_ERROR THEN
200: x_return_status := FND_API.G_RET_STS_ERROR;
201: FND_MESSAGE.SET_NAME('WSH','WSH_OI_STOP_ACTION_ERROR');
202: FND_MESSAGE.SET_TOKEN('STOP_NAME', wsh_trip_stops_pvt.get_name(l_stop_id));
203: FND_MESSAGE.SET_TOKEN('ACTION', wsh_util_core.get_action_meaning('STOP',p_action_code));

Line 200: x_return_status := FND_API.G_RET_STS_ERROR;

196:
197: EXCEPTION
198:
199: WHEN FND_API.G_EXC_ERROR THEN
200: x_return_status := FND_API.G_RET_STS_ERROR;
201: FND_MESSAGE.SET_NAME('WSH','WSH_OI_STOP_ACTION_ERROR');
202: FND_MESSAGE.SET_TOKEN('STOP_NAME', wsh_trip_stops_pvt.get_name(l_stop_id));
203: FND_MESSAGE.SET_TOKEN('ACTION', wsh_util_core.get_action_meaning('STOP',p_action_code));
204: wsh_util_core.add_message(x_return_status,l_module_name);

Line 212: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

208: WSH_DEBUG_SV.pop(l_module_name);
209: END IF;
210:
211:
212: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
214: FND_MESSAGE.SET_NAME('WSH','WSH_OI_STOP_ACTION_ERROR');
215: FND_MESSAGE.SET_TOKEN('STOP_NAME', wsh_trip_stops_pvt.get_name(l_stop_id));
216: FND_MESSAGE.SET_TOKEN('ACTION', wsh_util_core.get_action_meaning('STOP',p_action_code));

Line 213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

209: END IF;
210:
211:
212: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
214: FND_MESSAGE.SET_NAME('WSH','WSH_OI_STOP_ACTION_ERROR');
215: FND_MESSAGE.SET_TOKEN('STOP_NAME', wsh_trip_stops_pvt.get_name(l_stop_id));
216: FND_MESSAGE.SET_TOKEN('ACTION', wsh_util_core.get_action_meaning('STOP',p_action_code));
217: wsh_util_core.add_message(x_return_status,l_module_name);

Line 222: , p_encoded => FND_API.G_FALSE

218: -- Get message count and data
219: FND_MSG_PUB.Count_And_Get
220: ( p_count => x_msg_count
221: , p_data => x_msg_data
222: , p_encoded => FND_API.G_FALSE
223: );
224: IF l_debug_on THEN
225: wsh_debug_sv.log (l_module_name,'EXCEPTION:G_EXC_UNEXPECTED_ERROR');
226: WSH_DEBUG_SV.pop(l_module_name);

Line 230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

226: WSH_DEBUG_SV.pop(l_module_name);
227: END IF;
228:
229: WHEN OTHERS THEN
230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
231: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
232: THEN
233: FND_MSG_PUB.Add_Exc_Msg
234: ( G_PKG_NAME

Line 242: , p_encoded => FND_API.G_FALSE

238: -- Get message count and data
239: FND_MSG_PUB.Count_And_Get
240: ( p_count => x_msg_count
241: , p_data => x_msg_data
242: , p_encoded => FND_API.G_FALSE
243: );
244:
245: IF l_debug_on THEN
246: wsh_debug_sv.log (l_module_name,'Error',substr(sqlerrm,1,200));

Line 280: x_pvt_stop_rec.STATUS_CODE := FND_API.G_MISS_CHAR;

276:
277: x_pvt_stop_rec.STOP_ID := p_pub_stop_rec.STOP_ID;
278: x_pvt_stop_rec.TRIP_ID := p_pub_stop_rec.TRIP_ID;
279: x_pvt_stop_rec.STOP_LOCATION_ID := p_pub_stop_rec.STOP_LOCATION_ID;
280: x_pvt_stop_rec.STATUS_CODE := FND_API.G_MISS_CHAR;
281: x_pvt_stop_rec.STOP_SEQUENCE_NUMBER := p_pub_stop_rec.STOP_SEQUENCE_NUMBER;
282: x_pvt_stop_rec.PLANNED_ARRIVAL_DATE := p_pub_stop_rec.PLANNED_ARRIVAL_DATE;
283: x_pvt_stop_rec.PLANNED_DEPARTURE_DATE := p_pub_stop_rec.PLANNED_DEPARTURE_DATE;
284: x_pvt_stop_rec.ACTUAL_ARRIVAL_DATE := p_pub_stop_rec.ACTUAL_ARRIVAL_DATE;

Line 334: x_pvt_stop_rec.WSH_LOCATION_ID := FND_API.G_MISS_NUM;

330: x_pvt_stop_rec.PROGRAM_APPLICATION_ID := p_pub_stop_rec.PROGRAM_APPLICATION_ID;
331: x_pvt_stop_rec.PROGRAM_ID := p_pub_stop_rec.PROGRAM_ID;
332: x_pvt_stop_rec.PROGRAM_UPDATE_DATE := p_pub_stop_rec.PROGRAM_UPDATE_DATE;
333: x_pvt_stop_rec.REQUEST_ID := p_pub_stop_rec.REQUEST_ID;
334: x_pvt_stop_rec.WSH_LOCATION_ID := FND_API.G_MISS_NUM;
335: x_pvt_stop_rec.TRACKING_DRILLDOWN_FLAG := FND_API.G_MISS_CHAR;
336: x_pvt_stop_rec.TRACKING_REMARKS := FND_API.G_MISS_CHAR;
337: x_pvt_stop_rec.CARRIER_EST_DEPARTURE_DATE := FND_API.G_MISS_DATE;
338: x_pvt_stop_rec.CARRIER_EST_ARRIVAL_DATE := FND_API.G_MISS_DATE;

Line 335: x_pvt_stop_rec.TRACKING_DRILLDOWN_FLAG := FND_API.G_MISS_CHAR;

331: x_pvt_stop_rec.PROGRAM_ID := p_pub_stop_rec.PROGRAM_ID;
332: x_pvt_stop_rec.PROGRAM_UPDATE_DATE := p_pub_stop_rec.PROGRAM_UPDATE_DATE;
333: x_pvt_stop_rec.REQUEST_ID := p_pub_stop_rec.REQUEST_ID;
334: x_pvt_stop_rec.WSH_LOCATION_ID := FND_API.G_MISS_NUM;
335: x_pvt_stop_rec.TRACKING_DRILLDOWN_FLAG := FND_API.G_MISS_CHAR;
336: x_pvt_stop_rec.TRACKING_REMARKS := FND_API.G_MISS_CHAR;
337: x_pvt_stop_rec.CARRIER_EST_DEPARTURE_DATE := FND_API.G_MISS_DATE;
338: x_pvt_stop_rec.CARRIER_EST_ARRIVAL_DATE := FND_API.G_MISS_DATE;
339: x_pvt_stop_rec.LOADING_START_DATETIME := FND_API.G_MISS_DATE;

Line 336: x_pvt_stop_rec.TRACKING_REMARKS := FND_API.G_MISS_CHAR;

332: x_pvt_stop_rec.PROGRAM_UPDATE_DATE := p_pub_stop_rec.PROGRAM_UPDATE_DATE;
333: x_pvt_stop_rec.REQUEST_ID := p_pub_stop_rec.REQUEST_ID;
334: x_pvt_stop_rec.WSH_LOCATION_ID := FND_API.G_MISS_NUM;
335: x_pvt_stop_rec.TRACKING_DRILLDOWN_FLAG := FND_API.G_MISS_CHAR;
336: x_pvt_stop_rec.TRACKING_REMARKS := FND_API.G_MISS_CHAR;
337: x_pvt_stop_rec.CARRIER_EST_DEPARTURE_DATE := FND_API.G_MISS_DATE;
338: x_pvt_stop_rec.CARRIER_EST_ARRIVAL_DATE := FND_API.G_MISS_DATE;
339: x_pvt_stop_rec.LOADING_START_DATETIME := FND_API.G_MISS_DATE;
340: x_pvt_stop_rec.LOADING_END_DATETIME := FND_API.G_MISS_DATE;

Line 337: x_pvt_stop_rec.CARRIER_EST_DEPARTURE_DATE := FND_API.G_MISS_DATE;

333: x_pvt_stop_rec.REQUEST_ID := p_pub_stop_rec.REQUEST_ID;
334: x_pvt_stop_rec.WSH_LOCATION_ID := FND_API.G_MISS_NUM;
335: x_pvt_stop_rec.TRACKING_DRILLDOWN_FLAG := FND_API.G_MISS_CHAR;
336: x_pvt_stop_rec.TRACKING_REMARKS := FND_API.G_MISS_CHAR;
337: x_pvt_stop_rec.CARRIER_EST_DEPARTURE_DATE := FND_API.G_MISS_DATE;
338: x_pvt_stop_rec.CARRIER_EST_ARRIVAL_DATE := FND_API.G_MISS_DATE;
339: x_pvt_stop_rec.LOADING_START_DATETIME := FND_API.G_MISS_DATE;
340: x_pvt_stop_rec.LOADING_END_DATETIME := FND_API.G_MISS_DATE;
341: x_pvt_stop_rec.UNLOADING_START_DATETIME := FND_API.G_MISS_DATE;

Line 338: x_pvt_stop_rec.CARRIER_EST_ARRIVAL_DATE := FND_API.G_MISS_DATE;

334: x_pvt_stop_rec.WSH_LOCATION_ID := FND_API.G_MISS_NUM;
335: x_pvt_stop_rec.TRACKING_DRILLDOWN_FLAG := FND_API.G_MISS_CHAR;
336: x_pvt_stop_rec.TRACKING_REMARKS := FND_API.G_MISS_CHAR;
337: x_pvt_stop_rec.CARRIER_EST_DEPARTURE_DATE := FND_API.G_MISS_DATE;
338: x_pvt_stop_rec.CARRIER_EST_ARRIVAL_DATE := FND_API.G_MISS_DATE;
339: x_pvt_stop_rec.LOADING_START_DATETIME := FND_API.G_MISS_DATE;
340: x_pvt_stop_rec.LOADING_END_DATETIME := FND_API.G_MISS_DATE;
341: x_pvt_stop_rec.UNLOADING_START_DATETIME := FND_API.G_MISS_DATE;
342: x_pvt_stop_rec.UNLOADING_END_DATETIME := FND_API.G_MISS_DATE;

Line 339: x_pvt_stop_rec.LOADING_START_DATETIME := FND_API.G_MISS_DATE;

335: x_pvt_stop_rec.TRACKING_DRILLDOWN_FLAG := FND_API.G_MISS_CHAR;
336: x_pvt_stop_rec.TRACKING_REMARKS := FND_API.G_MISS_CHAR;
337: x_pvt_stop_rec.CARRIER_EST_DEPARTURE_DATE := FND_API.G_MISS_DATE;
338: x_pvt_stop_rec.CARRIER_EST_ARRIVAL_DATE := FND_API.G_MISS_DATE;
339: x_pvt_stop_rec.LOADING_START_DATETIME := FND_API.G_MISS_DATE;
340: x_pvt_stop_rec.LOADING_END_DATETIME := FND_API.G_MISS_DATE;
341: x_pvt_stop_rec.UNLOADING_START_DATETIME := FND_API.G_MISS_DATE;
342: x_pvt_stop_rec.UNLOADING_END_DATETIME := FND_API.G_MISS_DATE;
343:

Line 340: x_pvt_stop_rec.LOADING_END_DATETIME := FND_API.G_MISS_DATE;

336: x_pvt_stop_rec.TRACKING_REMARKS := FND_API.G_MISS_CHAR;
337: x_pvt_stop_rec.CARRIER_EST_DEPARTURE_DATE := FND_API.G_MISS_DATE;
338: x_pvt_stop_rec.CARRIER_EST_ARRIVAL_DATE := FND_API.G_MISS_DATE;
339: x_pvt_stop_rec.LOADING_START_DATETIME := FND_API.G_MISS_DATE;
340: x_pvt_stop_rec.LOADING_END_DATETIME := FND_API.G_MISS_DATE;
341: x_pvt_stop_rec.UNLOADING_START_DATETIME := FND_API.G_MISS_DATE;
342: x_pvt_stop_rec.UNLOADING_END_DATETIME := FND_API.G_MISS_DATE;
343:
344: --x_pvt_stop_rec.ROWID := FND_API.G_MISS_CHAR;

Line 341: x_pvt_stop_rec.UNLOADING_START_DATETIME := FND_API.G_MISS_DATE;

337: x_pvt_stop_rec.CARRIER_EST_DEPARTURE_DATE := FND_API.G_MISS_DATE;
338: x_pvt_stop_rec.CARRIER_EST_ARRIVAL_DATE := FND_API.G_MISS_DATE;
339: x_pvt_stop_rec.LOADING_START_DATETIME := FND_API.G_MISS_DATE;
340: x_pvt_stop_rec.LOADING_END_DATETIME := FND_API.G_MISS_DATE;
341: x_pvt_stop_rec.UNLOADING_START_DATETIME := FND_API.G_MISS_DATE;
342: x_pvt_stop_rec.UNLOADING_END_DATETIME := FND_API.G_MISS_DATE;
343:
344: --x_pvt_stop_rec.ROWID := FND_API.G_MISS_CHAR;
345: x_pvt_stop_rec.TRIP_NAME := p_pub_stop_rec.TRIP_NAME;

Line 342: x_pvt_stop_rec.UNLOADING_END_DATETIME := FND_API.G_MISS_DATE;

338: x_pvt_stop_rec.CARRIER_EST_ARRIVAL_DATE := FND_API.G_MISS_DATE;
339: x_pvt_stop_rec.LOADING_START_DATETIME := FND_API.G_MISS_DATE;
340: x_pvt_stop_rec.LOADING_END_DATETIME := FND_API.G_MISS_DATE;
341: x_pvt_stop_rec.UNLOADING_START_DATETIME := FND_API.G_MISS_DATE;
342: x_pvt_stop_rec.UNLOADING_END_DATETIME := FND_API.G_MISS_DATE;
343:
344: --x_pvt_stop_rec.ROWID := FND_API.G_MISS_CHAR;
345: x_pvt_stop_rec.TRIP_NAME := p_pub_stop_rec.TRIP_NAME;
346: x_pvt_stop_rec.STOP_LOCATION_CODE := p_pub_stop_rec.STOP_LOCATION_CODE;

Line 344: --x_pvt_stop_rec.ROWID := FND_API.G_MISS_CHAR;

340: x_pvt_stop_rec.LOADING_END_DATETIME := FND_API.G_MISS_DATE;
341: x_pvt_stop_rec.UNLOADING_START_DATETIME := FND_API.G_MISS_DATE;
342: x_pvt_stop_rec.UNLOADING_END_DATETIME := FND_API.G_MISS_DATE;
343:
344: --x_pvt_stop_rec.ROWID := FND_API.G_MISS_CHAR;
345: x_pvt_stop_rec.TRIP_NAME := p_pub_stop_rec.TRIP_NAME;
346: x_pvt_stop_rec.STOP_LOCATION_CODE := p_pub_stop_rec.STOP_LOCATION_CODE;
347: x_pvt_stop_rec.WEIGHT_UOM_DESC := p_pub_stop_rec.WEIGHT_UOM_DESC;
348: x_pvt_stop_rec.VOLUME_UOM_DESC := p_pub_stop_rec.VOLUME_UOM_DESC;

Line 349: x_pvt_stop_rec.LOCK_STOP_ID := FND_API.G_MISS_NUM;

345: x_pvt_stop_rec.TRIP_NAME := p_pub_stop_rec.TRIP_NAME;
346: x_pvt_stop_rec.STOP_LOCATION_CODE := p_pub_stop_rec.STOP_LOCATION_CODE;
347: x_pvt_stop_rec.WEIGHT_UOM_DESC := p_pub_stop_rec.WEIGHT_UOM_DESC;
348: x_pvt_stop_rec.VOLUME_UOM_DESC := p_pub_stop_rec.VOLUME_UOM_DESC;
349: x_pvt_stop_rec.LOCK_STOP_ID := FND_API.G_MISS_NUM;
350: x_pvt_stop_rec.PENDING_INTERFACE_FLAG := FND_API.G_MISS_CHAR;
351: x_pvt_stop_rec.TRANSACTION_HEADER_ID := FND_API.G_MISS_NUM;
352:
353: -- csun 10+ internal location change

Line 350: x_pvt_stop_rec.PENDING_INTERFACE_FLAG := FND_API.G_MISS_CHAR;

346: x_pvt_stop_rec.STOP_LOCATION_CODE := p_pub_stop_rec.STOP_LOCATION_CODE;
347: x_pvt_stop_rec.WEIGHT_UOM_DESC := p_pub_stop_rec.WEIGHT_UOM_DESC;
348: x_pvt_stop_rec.VOLUME_UOM_DESC := p_pub_stop_rec.VOLUME_UOM_DESC;
349: x_pvt_stop_rec.LOCK_STOP_ID := FND_API.G_MISS_NUM;
350: x_pvt_stop_rec.PENDING_INTERFACE_FLAG := FND_API.G_MISS_CHAR;
351: x_pvt_stop_rec.TRANSACTION_HEADER_ID := FND_API.G_MISS_NUM;
352:
353: -- csun 10+ internal location change
354: x_pvt_stop_rec.PHYSICAL_STOP_ID := p_pub_stop_rec.PHYSICAL_STOP_ID;

Line 351: x_pvt_stop_rec.TRANSACTION_HEADER_ID := FND_API.G_MISS_NUM;

347: x_pvt_stop_rec.WEIGHT_UOM_DESC := p_pub_stop_rec.WEIGHT_UOM_DESC;
348: x_pvt_stop_rec.VOLUME_UOM_DESC := p_pub_stop_rec.VOLUME_UOM_DESC;
349: x_pvt_stop_rec.LOCK_STOP_ID := FND_API.G_MISS_NUM;
350: x_pvt_stop_rec.PENDING_INTERFACE_FLAG := FND_API.G_MISS_CHAR;
351: x_pvt_stop_rec.TRANSACTION_HEADER_ID := FND_API.G_MISS_NUM;
352:
353: -- csun 10+ internal location change
354: x_pvt_stop_rec.PHYSICAL_STOP_ID := p_pub_stop_rec.PHYSICAL_STOP_ID;
355: x_pvt_stop_rec.PHYSICAL_LOCATION_ID := p_pub_stop_rec.PHYSICAL_LOCATION_ID;

Line 378: -- p_init_msg_list FND_API.G_TRUE to reset list

374: --========================================================================
375: -- PROCEDURE : Create_Update_Stop PUBLIC
376: --
377: -- PARAMETERS: p_api_version_number known api versionerror buffer
378: -- p_init_msg_list FND_API.G_TRUE to reset list
379: -- x_return_status return status
380: -- x_msg_count number of messages in the list
381: -- x_msg_data text of messages
382: -- p_stop_info Attributes for the stop entity

Line 404: p_trip_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

400: x_msg_count OUT NOCOPY NUMBER,
401: x_msg_data OUT NOCOPY VARCHAR2,
402: p_action_code IN VARCHAR2,
403: p_stop_info IN OUT NOCOPY Trip_Stop_Pub_Rec_Type,
404: p_trip_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
405: p_trip_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
406: p_stop_location_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
407: p_stop_location_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
408: p_planned_dep_date IN DATE DEFAULT FND_API.G_MISS_DATE,

Line 405: p_trip_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

401: x_msg_data OUT NOCOPY VARCHAR2,
402: p_action_code IN VARCHAR2,
403: p_stop_info IN OUT NOCOPY Trip_Stop_Pub_Rec_Type,
404: p_trip_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
405: p_trip_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
406: p_stop_location_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
407: p_stop_location_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
408: p_planned_dep_date IN DATE DEFAULT FND_API.G_MISS_DATE,
409: x_stop_id OUT NOCOPY NUMBER) IS

Line 406: p_stop_location_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

402: p_action_code IN VARCHAR2,
403: p_stop_info IN OUT NOCOPY Trip_Stop_Pub_Rec_Type,
404: p_trip_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
405: p_trip_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
406: p_stop_location_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
407: p_stop_location_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
408: p_planned_dep_date IN DATE DEFAULT FND_API.G_MISS_DATE,
409: x_stop_id OUT NOCOPY NUMBER) IS
410:

Line 407: p_stop_location_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

403: p_stop_info IN OUT NOCOPY Trip_Stop_Pub_Rec_Type,
404: p_trip_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
405: p_trip_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
406: p_stop_location_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
407: p_stop_location_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
408: p_planned_dep_date IN DATE DEFAULT FND_API.G_MISS_DATE,
409: x_stop_id OUT NOCOPY NUMBER) IS
410:
411: l_debug_on BOOLEAN;

Line 408: p_planned_dep_date IN DATE DEFAULT FND_API.G_MISS_DATE,

404: p_trip_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
405: p_trip_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
406: p_stop_location_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
407: p_stop_location_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
408: p_planned_dep_date IN DATE DEFAULT FND_API.G_MISS_DATE,
409: x_stop_id OUT NOCOPY NUMBER) IS
410:
411: l_debug_on BOOLEAN;
412: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Create_Update_Stop';

Line 437: IF NOT FND_API.Compatible_API_Call (l_api_version_number,p_api_version_number ,l_api_name ,G_PKG_NAME) THEN

433: IF l_debug_on THEN
434: wsh_debug_sv.push (l_module_name, 'Create_Update_Stop');
435: END IF;
436:
437: IF NOT FND_API.Compatible_API_Call (l_api_version_number,p_api_version_number ,l_api_name ,G_PKG_NAME) THEN
438: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
439: END IF;
440:
441: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 438: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

434: wsh_debug_sv.push (l_module_name, 'Create_Update_Stop');
435: END IF;
436:
437: IF NOT FND_API.Compatible_API_Call (l_api_version_number,p_api_version_number ,l_api_name ,G_PKG_NAME) THEN
438: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
439: END IF;
440:
441: IF FND_API.to_Boolean(p_init_msg_list) THEN
442: FND_MSG_PUB.initialize;

Line 441: IF FND_API.to_Boolean(p_init_msg_list) THEN

437: IF NOT FND_API.Compatible_API_Call (l_api_version_number,p_api_version_number ,l_api_name ,G_PKG_NAME) THEN
438: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
439: END IF;
440:
441: IF FND_API.to_Boolean(p_init_msg_list) THEN
442: FND_MSG_PUB.initialize;
443: END IF;
444:
445: map_stoppub_to_pvt (

Line 453: raise FND_API.G_EXC_ERROR;

449: IF l_debug_on THEN
450: wsh_debug_sv.log (l_module_name, 'map_stoppub_to_pvt x_return_status',x_return_status);
451: END IF;
452: IF ( x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
453: raise FND_API.G_EXC_ERROR;
454: END IF;
455:
456: IF (p_trip_id IS NOT NULL) AND (p_trip_id <> FND_API.G_MISS_NUM) THEN
457: l_pvt_stop_rec.trip_id := p_trip_id;

Line 456: IF (p_trip_id IS NOT NULL) AND (p_trip_id <> FND_API.G_MISS_NUM) THEN

452: IF ( x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
453: raise FND_API.G_EXC_ERROR;
454: END IF;
455:
456: IF (p_trip_id IS NOT NULL) AND (p_trip_id <> FND_API.G_MISS_NUM) THEN
457: l_pvt_stop_rec.trip_id := p_trip_id;
458: END IF;
459:
460: IF (p_trip_name IS NOT NULL) AND (p_trip_name <> FND_API.G_MISS_CHAR) THEN

Line 460: IF (p_trip_name IS NOT NULL) AND (p_trip_name <> FND_API.G_MISS_CHAR) THEN

456: IF (p_trip_id IS NOT NULL) AND (p_trip_id <> FND_API.G_MISS_NUM) THEN
457: l_pvt_stop_rec.trip_id := p_trip_id;
458: END IF;
459:
460: IF (p_trip_name IS NOT NULL) AND (p_trip_name <> FND_API.G_MISS_CHAR) THEN
461: l_pvt_stop_rec.trip_name := p_trip_name;
462: END IF;
463:
464: IF (p_stop_location_id IS NOT NULL) AND (p_stop_location_id <> FND_API.G_MISS_NUM) THEN

Line 464: IF (p_stop_location_id IS NOT NULL) AND (p_stop_location_id <> FND_API.G_MISS_NUM) THEN

460: IF (p_trip_name IS NOT NULL) AND (p_trip_name <> FND_API.G_MISS_CHAR) THEN
461: l_pvt_stop_rec.trip_name := p_trip_name;
462: END IF;
463:
464: IF (p_stop_location_id IS NOT NULL) AND (p_stop_location_id <> FND_API.G_MISS_NUM) THEN
465: l_pvt_stop_rec.stop_location_id := p_stop_location_id;
466: END IF;
467:
468: IF (p_stop_location_code IS NOT NULL) AND (p_stop_location_code <> FND_API.G_MISS_CHAR) THEN

Line 468: IF (p_stop_location_code IS NOT NULL) AND (p_stop_location_code <> FND_API.G_MISS_CHAR) THEN

464: IF (p_stop_location_id IS NOT NULL) AND (p_stop_location_id <> FND_API.G_MISS_NUM) THEN
465: l_pvt_stop_rec.stop_location_id := p_stop_location_id;
466: END IF;
467:
468: IF (p_stop_location_code IS NOT NULL) AND (p_stop_location_code <> FND_API.G_MISS_CHAR) THEN
469: l_pvt_stop_rec.stop_location_code := p_stop_location_code;
470: END IF;
471:
472: IF (p_planned_dep_date IS NOT NULL) AND (p_planned_dep_date <> FND_API.G_MISS_DATE)THEN

Line 472: IF (p_planned_dep_date IS NOT NULL) AND (p_planned_dep_date <> FND_API.G_MISS_DATE)THEN

468: IF (p_stop_location_code IS NOT NULL) AND (p_stop_location_code <> FND_API.G_MISS_CHAR) THEN
469: l_pvt_stop_rec.stop_location_code := p_stop_location_code;
470: END IF;
471:
472: IF (p_planned_dep_date IS NOT NULL) AND (p_planned_dep_date <> FND_API.G_MISS_DATE)THEN
473: l_pvt_stop_rec.planned_departure_date := p_planned_dep_date;
474: END IF;
475:
476: -- bug 3666967 - treating non-passed parameters as FND_API.G_MISS_NUM

Line 476: -- bug 3666967 - treating non-passed parameters as FND_API.G_MISS_NUM

472: IF (p_planned_dep_date IS NOT NULL) AND (p_planned_dep_date <> FND_API.G_MISS_DATE)THEN
473: l_pvt_stop_rec.planned_departure_date := p_planned_dep_date;
474: END IF;
475:
476: -- bug 3666967 - treating non-passed parameters as FND_API.G_MISS_NUM
477: IF (p_action_code = 'CREATE') THEN
478: IF (l_pvt_stop_rec.departure_gross_weight = FND_API.G_MISS_NUM AND
479: l_pvt_stop_rec.departure_net_weight = FND_API.G_MISS_NUM AND
480: l_pvt_stop_rec.departure_volume = FND_API.G_MISS_NUM AND

Line 478: IF (l_pvt_stop_rec.departure_gross_weight = FND_API.G_MISS_NUM AND

474: END IF;
475:
476: -- bug 3666967 - treating non-passed parameters as FND_API.G_MISS_NUM
477: IF (p_action_code = 'CREATE') THEN
478: IF (l_pvt_stop_rec.departure_gross_weight = FND_API.G_MISS_NUM AND
479: l_pvt_stop_rec.departure_net_weight = FND_API.G_MISS_NUM AND
480: l_pvt_stop_rec.departure_volume = FND_API.G_MISS_NUM AND
481: l_pvt_stop_rec.departure_fill_percent = FND_API.G_MISS_NUM) THEN
482: l_pvt_stop_rec.wv_frozen_flag := 'N';

Line 479: l_pvt_stop_rec.departure_net_weight = FND_API.G_MISS_NUM AND

475:
476: -- bug 3666967 - treating non-passed parameters as FND_API.G_MISS_NUM
477: IF (p_action_code = 'CREATE') THEN
478: IF (l_pvt_stop_rec.departure_gross_weight = FND_API.G_MISS_NUM AND
479: l_pvt_stop_rec.departure_net_weight = FND_API.G_MISS_NUM AND
480: l_pvt_stop_rec.departure_volume = FND_API.G_MISS_NUM AND
481: l_pvt_stop_rec.departure_fill_percent = FND_API.G_MISS_NUM) THEN
482: l_pvt_stop_rec.wv_frozen_flag := 'N';
483: ELSE

Line 480: l_pvt_stop_rec.departure_volume = FND_API.G_MISS_NUM AND

476: -- bug 3666967 - treating non-passed parameters as FND_API.G_MISS_NUM
477: IF (p_action_code = 'CREATE') THEN
478: IF (l_pvt_stop_rec.departure_gross_weight = FND_API.G_MISS_NUM AND
479: l_pvt_stop_rec.departure_net_weight = FND_API.G_MISS_NUM AND
480: l_pvt_stop_rec.departure_volume = FND_API.G_MISS_NUM AND
481: l_pvt_stop_rec.departure_fill_percent = FND_API.G_MISS_NUM) THEN
482: l_pvt_stop_rec.wv_frozen_flag := 'N';
483: ELSE
484: l_pvt_stop_rec.wv_frozen_flag := 'Y';

Line 481: l_pvt_stop_rec.departure_fill_percent = FND_API.G_MISS_NUM) THEN

477: IF (p_action_code = 'CREATE') THEN
478: IF (l_pvt_stop_rec.departure_gross_weight = FND_API.G_MISS_NUM AND
479: l_pvt_stop_rec.departure_net_weight = FND_API.G_MISS_NUM AND
480: l_pvt_stop_rec.departure_volume = FND_API.G_MISS_NUM AND
481: l_pvt_stop_rec.departure_fill_percent = FND_API.G_MISS_NUM) THEN
482: l_pvt_stop_rec.wv_frozen_flag := 'N';
483: ELSE
484: l_pvt_stop_rec.wv_frozen_flag := 'Y';
485: END IF;

Line 524: WHEN FND_API.G_EXC_ERROR THEN

520: WSH_DEBUG_SV.pop(l_module_name);
521: END IF;
522:
523: EXCEPTION
524: WHEN FND_API.G_EXC_ERROR THEN
525: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
526: FND_MSG_PUB.Count_And_Get (
527: p_count => x_msg_count,
528: p_data => x_msg_data,

Line 529: p_encoded => FND_API.G_FALSE);

525: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
526: FND_MSG_PUB.Count_And_Get (
527: p_count => x_msg_count,
528: p_data => x_msg_data,
529: p_encoded => FND_API.G_FALSE);
530: IF l_debug_on THEN
531: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',
532: WSH_DEBUG_SV.C_EXCEP_LEVEL);
533: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

Line 531: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',

527: p_count => x_msg_count,
528: p_data => x_msg_data,
529: p_encoded => FND_API.G_FALSE);
530: IF l_debug_on THEN
531: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',
532: WSH_DEBUG_SV.C_EXCEP_LEVEL);
533: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
534: END IF;
535:

Line 533: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

529: p_encoded => FND_API.G_FALSE);
530: IF l_debug_on THEN
531: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',
532: WSH_DEBUG_SV.C_EXCEP_LEVEL);
533: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
534: END IF;
535:
536: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
537: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 536: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

532: WSH_DEBUG_SV.C_EXCEP_LEVEL);
533: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
534: END IF;
535:
536: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
537: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
538: FND_MSG_PUB.Count_And_Get (
539: p_count => x_msg_count,
540: p_data => x_msg_data,

Line 541: p_encoded => FND_API.G_FALSE);

537: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
538: FND_MSG_PUB.Count_And_Get (
539: p_count => x_msg_count,
540: p_data => x_msg_data,
541: p_encoded => FND_API.G_FALSE);
542: IF l_debug_on THEN
543: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',
544: WSH_DEBUG_SV.C_EXCEP_LEVEL);
545: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

Line 543: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',

539: p_count => x_msg_count,
540: p_data => x_msg_data,
541: p_encoded => FND_API.G_FALSE);
542: IF l_debug_on THEN
543: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',
544: WSH_DEBUG_SV.C_EXCEP_LEVEL);
545: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
546: END IF;
547:

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

541: p_encoded => FND_API.G_FALSE);
542: IF l_debug_on THEN
543: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',
544: WSH_DEBUG_SV.C_EXCEP_LEVEL);
545: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
546: END IF;
547:
548: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
549: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 553: p_encoded => FND_API.G_FALSE);

549: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
550: FND_MSG_PUB.Count_And_Get (
551: p_count => x_msg_count,
552: p_data => x_msg_data,
553: p_encoded => FND_API.G_FALSE);
554: IF l_debug_on THEN
555: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',
556: WSH_DEBUG_SV.C_EXCEP_LEVEL);
557: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');

Line 566: p_encoded => FND_API.G_FALSE);

562: wsh_util_core.default_handler ('WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP');
563: FND_MSG_PUB.Count_And_Get (
564: p_count => x_msg_count,
565: p_data => x_msg_data,
566: p_encoded => FND_API.G_FALSE);
567: IF l_debug_on THEN
568: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
569: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
570: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');