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: -- p_commit To commit the data or not
20: -- x_return_status return status
21: -- x_msg_count number of messages in the list
22: -- x_msg_data text of messages

Line 46: p_commit IN VARCHAR2 DEFAULT FND_API.G_TRUE,

42:
43: PROCEDURE Stop_Action
44: ( p_api_version_number IN NUMBER,
45: p_init_msg_list IN VARCHAR2,
46: p_commit IN VARCHAR2 DEFAULT FND_API.G_TRUE,
47: x_return_status OUT NOCOPY VARCHAR2,
48: x_msg_count OUT NOCOPY NUMBER,
49: x_msg_data OUT NOCOPY VARCHAR2,
50: p_action_code IN VARCHAR2,

Line 116: IF NOT FND_API.Compatible_API_Call

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

Line 123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 127: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

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

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

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

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

Line 165: RAISE FND_API.G_EXC_ERROR;

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

Line 181: p_init_msg_list => FND_API.G_FALSE,

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

Line 182: p_commit => FND_API.G_FALSE,

178:
179: WSH_INTERFACE_GRP.Stop_Action (
180: p_api_version_number => 1.0,
181: p_init_msg_list => FND_API.G_FALSE,
182: p_commit => FND_API.G_FALSE,
183: p_entity_id_tab => l_entity_id_tab,
184: p_action_prms => l_action_prms,
185: x_stop_out_rec => l_stop_out_rec,
186: x_return_status => x_return_status,

Line 190: IF FND_API.TO_BOOLEAN(p_commit)

186: x_return_status => x_return_status,
187: x_msg_count => x_msg_count,
188: x_msg_data => x_msg_data);
189:
190: IF FND_API.TO_BOOLEAN(p_commit)
191: THEN
192: IF l_debug_on
193: THEN
194: wsh_debug_sv.log (l_module_name,'Committing Transaction');

Line 202: , p_encoded => FND_API.G_FALSE

198:
199: FND_MSG_PUB.Count_And_Get
200: ( p_count => x_msg_count
201: , p_data => x_msg_data
202: , p_encoded => FND_API.G_FALSE
203: );
204:
205: IF l_debug_on THEN
206: WSH_DEBUG_SV.pop(l_module_name);

Line 211: WHEN FND_API.G_EXC_ERROR THEN

207: END IF;
208:
209: EXCEPTION
210:
211: WHEN FND_API.G_EXC_ERROR THEN
212: x_return_status := FND_API.G_RET_STS_ERROR;
213: FND_MESSAGE.SET_NAME('WSH','WSH_OI_STOP_ACTION_ERROR');
214: FND_MESSAGE.SET_TOKEN('STOP_NAME', wsh_trip_stops_pvt.get_name(l_stop_id));
215: FND_MESSAGE.SET_TOKEN('ACTION', wsh_util_core.get_action_meaning('STOP',p_action_code));

Line 212: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 224: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

220: WSH_DEBUG_SV.pop(l_module_name);
221: END IF;
222:
223:
224: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
226: FND_MESSAGE.SET_NAME('WSH','WSH_OI_STOP_ACTION_ERROR');
227: FND_MESSAGE.SET_TOKEN('STOP_NAME', wsh_trip_stops_pvt.get_name(l_stop_id));
228: FND_MESSAGE.SET_TOKEN('ACTION', wsh_util_core.get_action_meaning('STOP',p_action_code));

Line 225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

221: END IF;
222:
223:
224: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
226: FND_MESSAGE.SET_NAME('WSH','WSH_OI_STOP_ACTION_ERROR');
227: FND_MESSAGE.SET_TOKEN('STOP_NAME', wsh_trip_stops_pvt.get_name(l_stop_id));
228: FND_MESSAGE.SET_TOKEN('ACTION', wsh_util_core.get_action_meaning('STOP',p_action_code));
229: wsh_util_core.add_message(x_return_status,l_module_name);

Line 234: , p_encoded => FND_API.G_FALSE

230: -- Get message count and data
231: FND_MSG_PUB.Count_And_Get
232: ( p_count => x_msg_count
233: , p_data => x_msg_data
234: , p_encoded => FND_API.G_FALSE
235: );
236: IF l_debug_on THEN
237: wsh_debug_sv.log (l_module_name,'EXCEPTION:G_EXC_UNEXPECTED_ERROR');
238: WSH_DEBUG_SV.pop(l_module_name);

Line 242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

238: WSH_DEBUG_SV.pop(l_module_name);
239: END IF;
240:
241: WHEN OTHERS THEN
242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
243: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
244: THEN
245: FND_MSG_PUB.Add_Exc_Msg
246: ( G_PKG_NAME

Line 254: , p_encoded => FND_API.G_FALSE

250: -- Get message count and data
251: FND_MSG_PUB.Count_And_Get
252: ( p_count => x_msg_count
253: , p_data => x_msg_data
254: , p_encoded => FND_API.G_FALSE
255: );
256:
257: IF l_debug_on THEN
258: wsh_debug_sv.log (l_module_name,'Error',substr(sqlerrm,1,200));

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

288:
289: x_pvt_stop_rec.STOP_ID := p_pub_stop_rec.STOP_ID;
290: x_pvt_stop_rec.TRIP_ID := p_pub_stop_rec.TRIP_ID;
291: x_pvt_stop_rec.STOP_LOCATION_ID := p_pub_stop_rec.STOP_LOCATION_ID;
292: x_pvt_stop_rec.STATUS_CODE := FND_API.G_MISS_CHAR;
293: x_pvt_stop_rec.STOP_SEQUENCE_NUMBER := p_pub_stop_rec.STOP_SEQUENCE_NUMBER;
294: x_pvt_stop_rec.PLANNED_ARRIVAL_DATE := p_pub_stop_rec.PLANNED_ARRIVAL_DATE;
295: x_pvt_stop_rec.PLANNED_DEPARTURE_DATE := p_pub_stop_rec.PLANNED_DEPARTURE_DATE;
296: x_pvt_stop_rec.ACTUAL_ARRIVAL_DATE := p_pub_stop_rec.ACTUAL_ARRIVAL_DATE;

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

342: x_pvt_stop_rec.PROGRAM_APPLICATION_ID := p_pub_stop_rec.PROGRAM_APPLICATION_ID;
343: x_pvt_stop_rec.PROGRAM_ID := p_pub_stop_rec.PROGRAM_ID;
344: x_pvt_stop_rec.PROGRAM_UPDATE_DATE := p_pub_stop_rec.PROGRAM_UPDATE_DATE;
345: x_pvt_stop_rec.REQUEST_ID := p_pub_stop_rec.REQUEST_ID;
346: x_pvt_stop_rec.WSH_LOCATION_ID := FND_API.G_MISS_NUM;
347: x_pvt_stop_rec.TRACKING_DRILLDOWN_FLAG := FND_API.G_MISS_CHAR;
348: x_pvt_stop_rec.TRACKING_REMARKS := FND_API.G_MISS_CHAR;
349: x_pvt_stop_rec.CARRIER_EST_DEPARTURE_DATE := FND_API.G_MISS_DATE;
350: x_pvt_stop_rec.CARRIER_EST_ARRIVAL_DATE := FND_API.G_MISS_DATE;

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

343: x_pvt_stop_rec.PROGRAM_ID := p_pub_stop_rec.PROGRAM_ID;
344: x_pvt_stop_rec.PROGRAM_UPDATE_DATE := p_pub_stop_rec.PROGRAM_UPDATE_DATE;
345: x_pvt_stop_rec.REQUEST_ID := p_pub_stop_rec.REQUEST_ID;
346: x_pvt_stop_rec.WSH_LOCATION_ID := FND_API.G_MISS_NUM;
347: x_pvt_stop_rec.TRACKING_DRILLDOWN_FLAG := FND_API.G_MISS_CHAR;
348: x_pvt_stop_rec.TRACKING_REMARKS := FND_API.G_MISS_CHAR;
349: x_pvt_stop_rec.CARRIER_EST_DEPARTURE_DATE := FND_API.G_MISS_DATE;
350: x_pvt_stop_rec.CARRIER_EST_ARRIVAL_DATE := FND_API.G_MISS_DATE;
351: x_pvt_stop_rec.LOADING_START_DATETIME := FND_API.G_MISS_DATE;

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

344: x_pvt_stop_rec.PROGRAM_UPDATE_DATE := p_pub_stop_rec.PROGRAM_UPDATE_DATE;
345: x_pvt_stop_rec.REQUEST_ID := p_pub_stop_rec.REQUEST_ID;
346: x_pvt_stop_rec.WSH_LOCATION_ID := FND_API.G_MISS_NUM;
347: x_pvt_stop_rec.TRACKING_DRILLDOWN_FLAG := FND_API.G_MISS_CHAR;
348: x_pvt_stop_rec.TRACKING_REMARKS := FND_API.G_MISS_CHAR;
349: x_pvt_stop_rec.CARRIER_EST_DEPARTURE_DATE := FND_API.G_MISS_DATE;
350: x_pvt_stop_rec.CARRIER_EST_ARRIVAL_DATE := FND_API.G_MISS_DATE;
351: x_pvt_stop_rec.LOADING_START_DATETIME := FND_API.G_MISS_DATE;
352: x_pvt_stop_rec.LOADING_END_DATETIME := FND_API.G_MISS_DATE;

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

345: x_pvt_stop_rec.REQUEST_ID := p_pub_stop_rec.REQUEST_ID;
346: x_pvt_stop_rec.WSH_LOCATION_ID := FND_API.G_MISS_NUM;
347: x_pvt_stop_rec.TRACKING_DRILLDOWN_FLAG := FND_API.G_MISS_CHAR;
348: x_pvt_stop_rec.TRACKING_REMARKS := FND_API.G_MISS_CHAR;
349: x_pvt_stop_rec.CARRIER_EST_DEPARTURE_DATE := FND_API.G_MISS_DATE;
350: x_pvt_stop_rec.CARRIER_EST_ARRIVAL_DATE := FND_API.G_MISS_DATE;
351: x_pvt_stop_rec.LOADING_START_DATETIME := FND_API.G_MISS_DATE;
352: x_pvt_stop_rec.LOADING_END_DATETIME := FND_API.G_MISS_DATE;
353: x_pvt_stop_rec.UNLOADING_START_DATETIME := FND_API.G_MISS_DATE;

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

346: x_pvt_stop_rec.WSH_LOCATION_ID := FND_API.G_MISS_NUM;
347: x_pvt_stop_rec.TRACKING_DRILLDOWN_FLAG := FND_API.G_MISS_CHAR;
348: x_pvt_stop_rec.TRACKING_REMARKS := FND_API.G_MISS_CHAR;
349: x_pvt_stop_rec.CARRIER_EST_DEPARTURE_DATE := FND_API.G_MISS_DATE;
350: x_pvt_stop_rec.CARRIER_EST_ARRIVAL_DATE := FND_API.G_MISS_DATE;
351: x_pvt_stop_rec.LOADING_START_DATETIME := FND_API.G_MISS_DATE;
352: x_pvt_stop_rec.LOADING_END_DATETIME := FND_API.G_MISS_DATE;
353: x_pvt_stop_rec.UNLOADING_START_DATETIME := FND_API.G_MISS_DATE;
354: x_pvt_stop_rec.UNLOADING_END_DATETIME := FND_API.G_MISS_DATE;

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

347: x_pvt_stop_rec.TRACKING_DRILLDOWN_FLAG := FND_API.G_MISS_CHAR;
348: x_pvt_stop_rec.TRACKING_REMARKS := FND_API.G_MISS_CHAR;
349: x_pvt_stop_rec.CARRIER_EST_DEPARTURE_DATE := FND_API.G_MISS_DATE;
350: x_pvt_stop_rec.CARRIER_EST_ARRIVAL_DATE := FND_API.G_MISS_DATE;
351: x_pvt_stop_rec.LOADING_START_DATETIME := FND_API.G_MISS_DATE;
352: x_pvt_stop_rec.LOADING_END_DATETIME := FND_API.G_MISS_DATE;
353: x_pvt_stop_rec.UNLOADING_START_DATETIME := FND_API.G_MISS_DATE;
354: x_pvt_stop_rec.UNLOADING_END_DATETIME := FND_API.G_MISS_DATE;
355:

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

348: x_pvt_stop_rec.TRACKING_REMARKS := FND_API.G_MISS_CHAR;
349: x_pvt_stop_rec.CARRIER_EST_DEPARTURE_DATE := FND_API.G_MISS_DATE;
350: x_pvt_stop_rec.CARRIER_EST_ARRIVAL_DATE := FND_API.G_MISS_DATE;
351: x_pvt_stop_rec.LOADING_START_DATETIME := FND_API.G_MISS_DATE;
352: x_pvt_stop_rec.LOADING_END_DATETIME := FND_API.G_MISS_DATE;
353: x_pvt_stop_rec.UNLOADING_START_DATETIME := FND_API.G_MISS_DATE;
354: x_pvt_stop_rec.UNLOADING_END_DATETIME := FND_API.G_MISS_DATE;
355:
356: --x_pvt_stop_rec.ROWID := FND_API.G_MISS_CHAR;

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

349: x_pvt_stop_rec.CARRIER_EST_DEPARTURE_DATE := FND_API.G_MISS_DATE;
350: x_pvt_stop_rec.CARRIER_EST_ARRIVAL_DATE := FND_API.G_MISS_DATE;
351: x_pvt_stop_rec.LOADING_START_DATETIME := FND_API.G_MISS_DATE;
352: x_pvt_stop_rec.LOADING_END_DATETIME := FND_API.G_MISS_DATE;
353: x_pvt_stop_rec.UNLOADING_START_DATETIME := FND_API.G_MISS_DATE;
354: x_pvt_stop_rec.UNLOADING_END_DATETIME := FND_API.G_MISS_DATE;
355:
356: --x_pvt_stop_rec.ROWID := FND_API.G_MISS_CHAR;
357: x_pvt_stop_rec.TRIP_NAME := p_pub_stop_rec.TRIP_NAME;

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

350: x_pvt_stop_rec.CARRIER_EST_ARRIVAL_DATE := FND_API.G_MISS_DATE;
351: x_pvt_stop_rec.LOADING_START_DATETIME := FND_API.G_MISS_DATE;
352: x_pvt_stop_rec.LOADING_END_DATETIME := FND_API.G_MISS_DATE;
353: x_pvt_stop_rec.UNLOADING_START_DATETIME := FND_API.G_MISS_DATE;
354: x_pvt_stop_rec.UNLOADING_END_DATETIME := FND_API.G_MISS_DATE;
355:
356: --x_pvt_stop_rec.ROWID := FND_API.G_MISS_CHAR;
357: x_pvt_stop_rec.TRIP_NAME := p_pub_stop_rec.TRIP_NAME;
358: x_pvt_stop_rec.STOP_LOCATION_CODE := p_pub_stop_rec.STOP_LOCATION_CODE;

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

352: x_pvt_stop_rec.LOADING_END_DATETIME := FND_API.G_MISS_DATE;
353: x_pvt_stop_rec.UNLOADING_START_DATETIME := FND_API.G_MISS_DATE;
354: x_pvt_stop_rec.UNLOADING_END_DATETIME := FND_API.G_MISS_DATE;
355:
356: --x_pvt_stop_rec.ROWID := FND_API.G_MISS_CHAR;
357: x_pvt_stop_rec.TRIP_NAME := p_pub_stop_rec.TRIP_NAME;
358: x_pvt_stop_rec.STOP_LOCATION_CODE := p_pub_stop_rec.STOP_LOCATION_CODE;
359: x_pvt_stop_rec.WEIGHT_UOM_DESC := p_pub_stop_rec.WEIGHT_UOM_DESC;
360: x_pvt_stop_rec.VOLUME_UOM_DESC := p_pub_stop_rec.VOLUME_UOM_DESC;

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

357: x_pvt_stop_rec.TRIP_NAME := p_pub_stop_rec.TRIP_NAME;
358: x_pvt_stop_rec.STOP_LOCATION_CODE := p_pub_stop_rec.STOP_LOCATION_CODE;
359: x_pvt_stop_rec.WEIGHT_UOM_DESC := p_pub_stop_rec.WEIGHT_UOM_DESC;
360: x_pvt_stop_rec.VOLUME_UOM_DESC := p_pub_stop_rec.VOLUME_UOM_DESC;
361: x_pvt_stop_rec.LOCK_STOP_ID := FND_API.G_MISS_NUM;
362: x_pvt_stop_rec.PENDING_INTERFACE_FLAG := FND_API.G_MISS_CHAR;
363: x_pvt_stop_rec.TRANSACTION_HEADER_ID := FND_API.G_MISS_NUM;
364:
365: -- csun 10+ internal location change

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

358: x_pvt_stop_rec.STOP_LOCATION_CODE := p_pub_stop_rec.STOP_LOCATION_CODE;
359: x_pvt_stop_rec.WEIGHT_UOM_DESC := p_pub_stop_rec.WEIGHT_UOM_DESC;
360: x_pvt_stop_rec.VOLUME_UOM_DESC := p_pub_stop_rec.VOLUME_UOM_DESC;
361: x_pvt_stop_rec.LOCK_STOP_ID := FND_API.G_MISS_NUM;
362: x_pvt_stop_rec.PENDING_INTERFACE_FLAG := FND_API.G_MISS_CHAR;
363: x_pvt_stop_rec.TRANSACTION_HEADER_ID := FND_API.G_MISS_NUM;
364:
365: -- csun 10+ internal location change
366: x_pvt_stop_rec.PHYSICAL_STOP_ID := p_pub_stop_rec.PHYSICAL_STOP_ID;

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

359: x_pvt_stop_rec.WEIGHT_UOM_DESC := p_pub_stop_rec.WEIGHT_UOM_DESC;
360: x_pvt_stop_rec.VOLUME_UOM_DESC := p_pub_stop_rec.VOLUME_UOM_DESC;
361: x_pvt_stop_rec.LOCK_STOP_ID := FND_API.G_MISS_NUM;
362: x_pvt_stop_rec.PENDING_INTERFACE_FLAG := FND_API.G_MISS_CHAR;
363: x_pvt_stop_rec.TRANSACTION_HEADER_ID := FND_API.G_MISS_NUM;
364:
365: -- csun 10+ internal location change
366: x_pvt_stop_rec.PHYSICAL_STOP_ID := p_pub_stop_rec.PHYSICAL_STOP_ID;
367: x_pvt_stop_rec.PHYSICAL_LOCATION_ID := p_pub_stop_rec.PHYSICAL_LOCATION_ID;

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

386: --========================================================================
387: -- PROCEDURE : Create_Update_Stop PUBLIC
388: --
389: -- PARAMETERS: p_api_version_number known api versionerror buffer
390: -- p_init_msg_list FND_API.G_TRUE to reset list
391: -- x_return_status return status
392: -- x_msg_count number of messages in the list
393: -- x_msg_data text of messages
394: -- p_stop_info Attributes for the stop entity

Line 416: p_trip_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

412: x_msg_count OUT NOCOPY NUMBER,
413: x_msg_data OUT NOCOPY VARCHAR2,
414: p_action_code IN VARCHAR2,
415: p_stop_info IN OUT NOCOPY Trip_Stop_Pub_Rec_Type,
416: p_trip_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
417: p_trip_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
418: p_stop_location_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
419: p_stop_location_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
420: p_planned_dep_date IN DATE DEFAULT FND_API.G_MISS_DATE,

Line 417: p_trip_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

413: x_msg_data OUT NOCOPY VARCHAR2,
414: p_action_code IN VARCHAR2,
415: p_stop_info IN OUT NOCOPY Trip_Stop_Pub_Rec_Type,
416: p_trip_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
417: p_trip_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
418: p_stop_location_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
419: p_stop_location_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
420: p_planned_dep_date IN DATE DEFAULT FND_API.G_MISS_DATE,
421: x_stop_id OUT NOCOPY NUMBER) IS

Line 418: p_stop_location_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

414: p_action_code IN VARCHAR2,
415: p_stop_info IN OUT NOCOPY Trip_Stop_Pub_Rec_Type,
416: p_trip_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
417: p_trip_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
418: p_stop_location_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
419: p_stop_location_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
420: p_planned_dep_date IN DATE DEFAULT FND_API.G_MISS_DATE,
421: x_stop_id OUT NOCOPY NUMBER) IS
422:

Line 419: p_stop_location_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

415: p_stop_info IN OUT NOCOPY Trip_Stop_Pub_Rec_Type,
416: p_trip_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
417: p_trip_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
418: p_stop_location_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
419: p_stop_location_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
420: p_planned_dep_date IN DATE DEFAULT FND_API.G_MISS_DATE,
421: x_stop_id OUT NOCOPY NUMBER) IS
422:
423: l_debug_on BOOLEAN;

Line 420: p_planned_dep_date IN DATE DEFAULT FND_API.G_MISS_DATE,

416: p_trip_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
417: p_trip_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
418: p_stop_location_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
419: p_stop_location_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
420: p_planned_dep_date IN DATE DEFAULT FND_API.G_MISS_DATE,
421: x_stop_id OUT NOCOPY NUMBER) IS
422:
423: l_debug_on BOOLEAN;
424: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Create_Update_Stop';

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

445: IF l_debug_on THEN
446: wsh_debug_sv.push (l_module_name, 'Create_Update_Stop');
447: END IF;
448:
449: IF NOT FND_API.Compatible_API_Call (l_api_version_number,p_api_version_number ,l_api_name ,G_PKG_NAME) THEN
450: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
451: END IF;
452:
453: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 450: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

446: wsh_debug_sv.push (l_module_name, 'Create_Update_Stop');
447: END IF;
448:
449: IF NOT FND_API.Compatible_API_Call (l_api_version_number,p_api_version_number ,l_api_name ,G_PKG_NAME) THEN
450: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
451: END IF;
452:
453: IF FND_API.to_Boolean(p_init_msg_list) THEN
454: FND_MSG_PUB.initialize;

Line 453: IF FND_API.to_Boolean(p_init_msg_list) THEN

449: IF NOT FND_API.Compatible_API_Call (l_api_version_number,p_api_version_number ,l_api_name ,G_PKG_NAME) THEN
450: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
451: END IF;
452:
453: IF FND_API.to_Boolean(p_init_msg_list) THEN
454: FND_MSG_PUB.initialize;
455: END IF;
456:
457: map_stoppub_to_pvt (

Line 465: raise FND_API.G_EXC_ERROR;

461: IF l_debug_on THEN
462: wsh_debug_sv.log (l_module_name, 'map_stoppub_to_pvt x_return_status',x_return_status);
463: END IF;
464: IF ( x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
465: raise FND_API.G_EXC_ERROR;
466: END IF;
467:
468: IF (p_trip_id IS NOT NULL) AND (p_trip_id <> FND_API.G_MISS_NUM) THEN
469: l_pvt_stop_rec.trip_id := p_trip_id;

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

464: IF ( x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
465: raise FND_API.G_EXC_ERROR;
466: END IF;
467:
468: IF (p_trip_id IS NOT NULL) AND (p_trip_id <> FND_API.G_MISS_NUM) THEN
469: l_pvt_stop_rec.trip_id := p_trip_id;
470: END IF;
471:
472: IF (p_trip_name IS NOT NULL) AND (p_trip_name <> FND_API.G_MISS_CHAR) THEN

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

468: IF (p_trip_id IS NOT NULL) AND (p_trip_id <> FND_API.G_MISS_NUM) THEN
469: l_pvt_stop_rec.trip_id := p_trip_id;
470: END IF;
471:
472: IF (p_trip_name IS NOT NULL) AND (p_trip_name <> FND_API.G_MISS_CHAR) THEN
473: l_pvt_stop_rec.trip_name := p_trip_name;
474: END IF;
475:
476: IF (p_stop_location_id IS NOT NULL) AND (p_stop_location_id <> FND_API.G_MISS_NUM) THEN

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

472: IF (p_trip_name IS NOT NULL) AND (p_trip_name <> FND_API.G_MISS_CHAR) THEN
473: l_pvt_stop_rec.trip_name := p_trip_name;
474: END IF;
475:
476: IF (p_stop_location_id IS NOT NULL) AND (p_stop_location_id <> FND_API.G_MISS_NUM) THEN
477: l_pvt_stop_rec.stop_location_id := p_stop_location_id;
478: END IF;
479:
480: IF (p_stop_location_code IS NOT NULL) AND (p_stop_location_code <> FND_API.G_MISS_CHAR) THEN

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

476: IF (p_stop_location_id IS NOT NULL) AND (p_stop_location_id <> FND_API.G_MISS_NUM) THEN
477: l_pvt_stop_rec.stop_location_id := p_stop_location_id;
478: END IF;
479:
480: IF (p_stop_location_code IS NOT NULL) AND (p_stop_location_code <> FND_API.G_MISS_CHAR) THEN
481: l_pvt_stop_rec.stop_location_code := p_stop_location_code;
482: END IF;
483:
484: IF (p_planned_dep_date IS NOT NULL) AND (p_planned_dep_date <> FND_API.G_MISS_DATE)THEN

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

480: IF (p_stop_location_code IS NOT NULL) AND (p_stop_location_code <> FND_API.G_MISS_CHAR) THEN
481: l_pvt_stop_rec.stop_location_code := p_stop_location_code;
482: END IF;
483:
484: IF (p_planned_dep_date IS NOT NULL) AND (p_planned_dep_date <> FND_API.G_MISS_DATE)THEN
485: l_pvt_stop_rec.planned_departure_date := p_planned_dep_date;
486: END IF;
487:
488: -- bug 3666967 - treating non-passed parameters as FND_API.G_MISS_NUM

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

484: IF (p_planned_dep_date IS NOT NULL) AND (p_planned_dep_date <> FND_API.G_MISS_DATE)THEN
485: l_pvt_stop_rec.planned_departure_date := p_planned_dep_date;
486: END IF;
487:
488: -- bug 3666967 - treating non-passed parameters as FND_API.G_MISS_NUM
489: IF (p_action_code = 'CREATE') THEN
490: IF (l_pvt_stop_rec.departure_gross_weight = FND_API.G_MISS_NUM AND
491: l_pvt_stop_rec.departure_net_weight = FND_API.G_MISS_NUM AND
492: l_pvt_stop_rec.departure_volume = FND_API.G_MISS_NUM AND

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

486: END IF;
487:
488: -- bug 3666967 - treating non-passed parameters as FND_API.G_MISS_NUM
489: IF (p_action_code = 'CREATE') THEN
490: IF (l_pvt_stop_rec.departure_gross_weight = FND_API.G_MISS_NUM AND
491: l_pvt_stop_rec.departure_net_weight = FND_API.G_MISS_NUM AND
492: l_pvt_stop_rec.departure_volume = FND_API.G_MISS_NUM AND
493: l_pvt_stop_rec.departure_fill_percent = FND_API.G_MISS_NUM) THEN
494: l_pvt_stop_rec.wv_frozen_flag := 'N';

Line 491: l_pvt_stop_rec.departure_net_weight = FND_API.G_MISS_NUM AND

487:
488: -- bug 3666967 - treating non-passed parameters as FND_API.G_MISS_NUM
489: IF (p_action_code = 'CREATE') THEN
490: IF (l_pvt_stop_rec.departure_gross_weight = FND_API.G_MISS_NUM AND
491: l_pvt_stop_rec.departure_net_weight = FND_API.G_MISS_NUM AND
492: l_pvt_stop_rec.departure_volume = FND_API.G_MISS_NUM AND
493: l_pvt_stop_rec.departure_fill_percent = FND_API.G_MISS_NUM) THEN
494: l_pvt_stop_rec.wv_frozen_flag := 'N';
495: ELSE

Line 492: l_pvt_stop_rec.departure_volume = FND_API.G_MISS_NUM AND

488: -- bug 3666967 - treating non-passed parameters as FND_API.G_MISS_NUM
489: IF (p_action_code = 'CREATE') THEN
490: IF (l_pvt_stop_rec.departure_gross_weight = FND_API.G_MISS_NUM AND
491: l_pvt_stop_rec.departure_net_weight = FND_API.G_MISS_NUM AND
492: l_pvt_stop_rec.departure_volume = FND_API.G_MISS_NUM AND
493: l_pvt_stop_rec.departure_fill_percent = FND_API.G_MISS_NUM) THEN
494: l_pvt_stop_rec.wv_frozen_flag := 'N';
495: ELSE
496: l_pvt_stop_rec.wv_frozen_flag := 'Y';

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

489: IF (p_action_code = 'CREATE') THEN
490: IF (l_pvt_stop_rec.departure_gross_weight = FND_API.G_MISS_NUM AND
491: l_pvt_stop_rec.departure_net_weight = FND_API.G_MISS_NUM AND
492: l_pvt_stop_rec.departure_volume = FND_API.G_MISS_NUM AND
493: l_pvt_stop_rec.departure_fill_percent = FND_API.G_MISS_NUM) THEN
494: l_pvt_stop_rec.wv_frozen_flag := 'N';
495: ELSE
496: l_pvt_stop_rec.wv_frozen_flag := 'Y';
497: END IF;

Line 536: WHEN FND_API.G_EXC_ERROR THEN

532: WSH_DEBUG_SV.pop(l_module_name);
533: END IF;
534:
535: EXCEPTION
536: WHEN FND_API.G_EXC_ERROR THEN
537: x_return_status := WSH_UTIL_CORE.G_RET_STS_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_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_ERROR exception has occured.',
544: WSH_DEBUG_SV.C_EXCEP_LEVEL);
545: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

Line 543: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_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_ERROR exception has occured.',
544: WSH_DEBUG_SV.C_EXCEP_LEVEL);
545: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
546: END IF;
547:

Line 545: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_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_ERROR exception has occured.',
544: WSH_DEBUG_SV.C_EXCEP_LEVEL);
545: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
546: END IF;
547:
548: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
549: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 548: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

544: WSH_DEBUG_SV.C_EXCEP_LEVEL);
545: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
546: END IF;
547:
548: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
549: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
550: FND_MSG_PUB.Count_And_Get (
551: p_count => x_msg_count,
552: p_data => x_msg_data,

Line 553: p_encoded => FND_API.G_FALSE);

549: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
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,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',
556: WSH_DEBUG_SV.C_EXCEP_LEVEL);
557: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

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

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,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',
556: WSH_DEBUG_SV.C_EXCEP_LEVEL);
557: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
558: END IF;
559:

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

553: p_encoded => FND_API.G_FALSE);
554: IF l_debug_on THEN
555: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',
556: WSH_DEBUG_SV.C_EXCEP_LEVEL);
557: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
558: END IF;
559:
560: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
561: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 565: p_encoded => FND_API.G_FALSE);

561: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
562: FND_MSG_PUB.Count_And_Get (
563: p_count => x_msg_count,
564: p_data => x_msg_data,
565: p_encoded => FND_API.G_FALSE);
566: IF l_debug_on THEN
567: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',
568: WSH_DEBUG_SV.C_EXCEP_LEVEL);
569: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');

Line 578: p_encoded => FND_API.G_FALSE);

574: wsh_util_core.default_handler ('WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP');
575: FND_MSG_PUB.Count_And_Get (
576: p_count => x_msg_count,
577: p_data => x_msg_data,
578: p_encoded => FND_API.G_FALSE);
579: IF l_debug_on THEN
580: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
581: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
582: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');