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_WSH_TRIPS_PVT dependencies on WSH_UTIL_CORE

Line 16: if (p_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS

12: if (p_return_status = null or p_return_status = FND_API.G_MISS_CHAR) then
13: return;
14: end if;
15:
16: if (p_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
17: and p_return_status <> WSH_UTIL_CORE.G_RET_STS_ERROR
18: and p_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
19: and p_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) then
20: return;

Line 17: and p_return_status <> WSH_UTIL_CORE.G_RET_STS_ERROR

13: return;
14: end if;
15:
16: if (p_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
17: and p_return_status <> WSH_UTIL_CORE.G_RET_STS_ERROR
18: and p_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
19: and p_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) then
20: return;
21: end if;

Line 18: and p_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING

14: end if;
15:
16: if (p_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
17: and p_return_status <> WSH_UTIL_CORE.G_RET_STS_ERROR
18: and p_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
19: and p_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) then
20: return;
21: end if;
22:

Line 19: and p_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) then

15:
16: if (p_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
17: and p_return_status <> WSH_UTIL_CORE.G_RET_STS_ERROR
18: and p_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
19: and p_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) then
20: return;
21: end if;
22:
23: if (x_return_status = null or x_return_status = FND_API.G_MISS_CHAR) then

Line 28: if (x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR

24: x_return_status := p_return_status;
25: return;
26: end if;
27:
28: if (x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
29: or x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) then
30: return;
31: end if;
32:

Line 29: or x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) then

25: return;
26: end if;
27:
28: if (x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
29: or x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) then
30: return;
31: end if;
32:
33: if ((x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS

Line 33: if ((x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS

29: or x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) then
30: return;
31: end if;
32:
33: if ((x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS
34: or x_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING)
35: and (p_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
36: or p_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) then
37: x_return_status := p_return_status;

Line 34: or x_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING)

30: return;
31: end if;
32:
33: if ((x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS
34: or x_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING)
35: and (p_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
36: or p_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) then
37: x_return_status := p_return_status;
38: return;

Line 35: and (p_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR

31: end if;
32:
33: if ((x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS
34: or x_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING)
35: and (p_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
36: or p_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) then
37: x_return_status := p_return_status;
38: return;
39: end if;

Line 36: or p_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) then

32:
33: if ((x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS
34: or x_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING)
35: and (p_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
36: or p_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) then
37: x_return_status := p_return_status;
38: return;
39: end if;
40:

Line 41: if (x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS

37: x_return_status := p_return_status;
38: return;
39: end if;
40:
41: if (x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS
42: and p_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) then
43: x_return_status := p_return_status;
44: return;
45: end if;

Line 42: and p_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) then

38: return;
39: end if;
40:
41: if (x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS
42: and p_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) then
43: x_return_status := p_return_status;
44: return;
45: end if;
46: end set_return_status;

Line 78: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

74: l_number NUMBER;
75:
76: BEGIN
77:
78: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
79:
80: --validate fte_trip_id
81:
82: OPEN check_fte_trip_id(p_fte_trip_id);

Line 108: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

104: EXCEPTION
105: WHEN invalid_fte_trip_id THEN
106: FND_MESSAGE.SET_NAME('FTE', 'FTE_NO_TRIP_ID');
107: FND_MESSAGE.SET_TOKEN('TRIP_ID',p_fte_trip_id);
108: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
109: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
110: WHEN invalid_wsh_trip_id THEN
111: FND_MESSAGE.SET_NAME('FTE', 'FTE_NO_TRIP_SEGMENT_ID');
112: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_ID',p_wsh_trip_id);

Line 109: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

105: WHEN invalid_fte_trip_id THEN
106: FND_MESSAGE.SET_NAME('FTE', 'FTE_NO_TRIP_ID');
107: FND_MESSAGE.SET_TOKEN('TRIP_ID',p_fte_trip_id);
108: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
109: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
110: WHEN invalid_wsh_trip_id THEN
111: FND_MESSAGE.SET_NAME('FTE', 'FTE_NO_TRIP_SEGMENT_ID');
112: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_ID',p_wsh_trip_id);
113: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 113: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

109: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
110: WHEN invalid_wsh_trip_id THEN
111: FND_MESSAGE.SET_NAME('FTE', 'FTE_NO_TRIP_SEGMENT_ID');
112: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_ID',p_wsh_trip_id);
113: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
114: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
115: WHEN others THEN
116: wsh_util_core.default_handler('FTE_WSH_TRIPS_PUB.Validate_PK');
117: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 114: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

110: WHEN invalid_wsh_trip_id THEN
111: FND_MESSAGE.SET_NAME('FTE', 'FTE_NO_TRIP_SEGMENT_ID');
112: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_ID',p_wsh_trip_id);
113: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
114: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
115: WHEN others THEN
116: wsh_util_core.default_handler('FTE_WSH_TRIPS_PUB.Validate_PK');
117: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
118: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

Line 116: wsh_util_core.default_handler('FTE_WSH_TRIPS_PUB.Validate_PK');

112: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_ID',p_wsh_trip_id);
113: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
114: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
115: WHEN others THEN
116: wsh_util_core.default_handler('FTE_WSH_TRIPS_PUB.Validate_PK');
117: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
118: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
119:
120: END Validate_PK;

Line 117: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

113: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
114: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
115: WHEN others THEN
116: wsh_util_core.default_handler('FTE_WSH_TRIPS_PUB.Validate_PK');
117: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
118: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
119:
120: END Validate_PK;
121:

Line 118: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

114: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
115: WHEN others THEN
116: wsh_util_core.default_handler('FTE_WSH_TRIPS_PUB.Validate_PK');
117: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
118: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
119:
120: END Validate_PK;
121:
122: --

Line 151: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

147: l_number NUMBER;
148:
149: BEGIN
150:
151: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
152:
153: --validate sequence
154:
155: if (p_sequence = null or p_sequence = FND_API.G_MISS_NUM) then

Line 172: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

168:
169: EXCEPTION
170: WHEN empty_sequence THEN
171: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEGMENT_SEQUENCE_MISSING');
172: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
173: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
174: WHEN duplicate_sequence THEN
175: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEGMENT_SEQUENCE_DUP');
176: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 173: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

169: EXCEPTION
170: WHEN empty_sequence THEN
171: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEGMENT_SEQUENCE_MISSING');
172: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
173: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
174: WHEN duplicate_sequence THEN
175: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEGMENT_SEQUENCE_DUP');
176: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
177: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

Line 176: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

172: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
173: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
174: WHEN duplicate_sequence THEN
175: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEGMENT_SEQUENCE_DUP');
176: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
177: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
178: WHEN others THEN
179: wsh_util_core.default_handler('FTE_WSH_TRIPS_PUB.Validate_Sequence');
180: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 177: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

173: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
174: WHEN duplicate_sequence THEN
175: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEGMENT_SEQUENCE_DUP');
176: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
177: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
178: WHEN others THEN
179: wsh_util_core.default_handler('FTE_WSH_TRIPS_PUB.Validate_Sequence');
180: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
181: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

Line 179: wsh_util_core.default_handler('FTE_WSH_TRIPS_PUB.Validate_Sequence');

175: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEGMENT_SEQUENCE_DUP');
176: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
177: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
178: WHEN others THEN
179: wsh_util_core.default_handler('FTE_WSH_TRIPS_PUB.Validate_Sequence');
180: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
181: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
182:
183: END Validate_Sequence;

Line 180: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

176: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
177: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
178: WHEN others THEN
179: wsh_util_core.default_handler('FTE_WSH_TRIPS_PUB.Validate_Sequence');
180: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
181: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
182:
183: END Validate_Sequence;
184:

Line 181: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

177: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
178: WHEN others THEN
179: wsh_util_core.default_handler('FTE_WSH_TRIPS_PUB.Validate_Sequence');
180: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
181: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
182:
183: END Validate_Sequence;
184:
185: FUNCTION Get_Fte_Trip_Status

Line 214: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR);

210:
211: IF (x_status IS NULL) THEN
212: FND_MESSAGE.SET_NAME('FTE','FTE_NO_TRIP_ID');
213: FND_MESSAGE.SET_TOKEN('TRIP_ID',p_trip_id);
214: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR);
215: RETURN null;
216: END IF;
217:
218: RETURN x_status;

Line 223: wsh_util_core.default_handler('FTE_WSH_TRIPS_PUB.GET_FTE_TRIP_STATUS');

219:
220: EXCEPTION
221:
222: WHEN others THEN
223: wsh_util_core.default_handler('FTE_WSH_TRIPS_PUB.GET_FTE_TRIP_STATUS');
224: RETURN null;
225:
226: END Get_Fte_Trip_Status;
227:

Line 275: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

271: wsh_debug_sv.dlog (c_debug,'WshTripId ',p_trip_info.wsh_trip_id);
272: wsh_debug_sv.dlog (c_debug,'SequenceNumber ',p_trip_info.sequence_number);
273: wsh_debug_sv.dlog (c_debug,'ActionCode ',p_action_code);
274:
275: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
276:
277: wsh_debug_sv.dlog (c_debug,'about to get segment name...');
278:
279: fte_mls_util.get_trip_segment_name

Line 289: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

285:
286: wsh_debug_sv.dlog (c_debug,'segment name',l_wsh_trip_name);
287: wsh_debug_sv.dlog (c_debug,'x_return_status',x_return_status);
288:
289: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
290: RETURN;
291: END IF;
292:
293: wsh_debug_sv.dlog (c_debug,'about to get trip name...');

Line 305: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

301:
302: wsh_debug_sv.dlog (c_debug,'trip name',l_fte_trip_name);
303: wsh_debug_sv.dlog (c_debug,'x_return_status',x_return_status);
304:
305: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
306: RETURN;
307: END IF;
308:
309: wsh_debug_sv.dlog (c_debug,'about to validate PK...');

Line 320: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

316: );
317:
318: wsh_debug_sv.dlog (c_debug,'x_return_status',x_return_status);
319:
320: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
321: RETURN;
322: END IF;
323:
324: wsh_debug_sv.dlog (c_debug,'about to validate sequence...');

Line 335: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

331: );
332:
333: wsh_debug_sv.dlog (c_debug,'x_return_status',x_return_status);
334:
335: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
336: RETURN;
337: END IF;
338:
339: wsh_debug_sv.dlog (c_debug,'about to validate status...');

Line 365: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS

361: x_next_segment_id => l_next_segment_id,
362: x_return_status => l_return_status
363: );
364:
365: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
366: AND l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
367: set_return_status
368: (
369: l_return_status,

Line 366: AND l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

362: x_return_status => l_return_status
363: );
364:
365: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
366: AND l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
367: set_return_status
368: (
369: l_return_status,
370: x_return_status

Line 412: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

408: wsh_debug_sv.dlog (c_debug,'about to set the warning message...');
409:
410: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEGMENT_NO_TWO_STOPS');
411: FND_MESSAGE.SET_TOKEN('WSH_TRIP_NAME',l_wsh_trip_name);
412: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
413: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_WARNING);
414:
415: return;
416: end if;

Line 413: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_WARNING);

409:
410: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEGMENT_NO_TWO_STOPS');
411: FND_MESSAGE.SET_TOKEN('WSH_TRIP_NAME',l_wsh_trip_name);
412: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
413: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_WARNING);
414:
415: return;
416: end if;
417:

Line 442: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS

438:
439: wsh_debug_sv.dlog (c_debug,'previous segment id', l_previous_segment_id);
440: wsh_debug_sv.dlog (c_debug,'return status from get_previous_segment_id', l_return_status);
441:
442: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
443: AND l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
444: set_return_status
445: (
446: l_return_status,

Line 443: AND l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

439: wsh_debug_sv.dlog (c_debug,'previous segment id', l_previous_segment_id);
440: wsh_debug_sv.dlog (c_debug,'return status from get_previous_segment_id', l_return_status);
441:
442: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
443: AND l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
444: set_return_status
445: (
446: l_return_status,
447: x_return_status

Line 474: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS

470:
471: wsh_debug_sv.dlog (c_debug,'first stop loc id',l_first_stop_location_id);
472: wsh_debug_sv.dlog (c_debug,'return status from get_first_stop_location_id',l_return_status);
473:
474: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
475: AND l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
476: set_return_status
477: (
478: l_return_status,

Line 475: AND l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

471: wsh_debug_sv.dlog (c_debug,'first stop loc id',l_first_stop_location_id);
472: wsh_debug_sv.dlog (c_debug,'return status from get_first_stop_location_id',l_return_status);
473:
474: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
475: AND l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
476: set_return_status
477: (
478: l_return_status,
479: x_return_status

Line 503: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS

499:
500: wsh_debug_sv.dlog (c_debug,'l_connected',l_connected);
501: wsh_debug_sv.dlog (c_debug,'return_status from check_previous_segment',l_return_status);
502:
503: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
504: AND l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
505: set_return_status
506: (
507: l_return_status,

Line 504: AND l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

500: wsh_debug_sv.dlog (c_debug,'l_connected',l_connected);
501: wsh_debug_sv.dlog (c_debug,'return_status from check_previous_segment',l_return_status);
502:
503: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
504: AND l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
505: set_return_status
506: (
507: l_return_status,
508: x_return_status

Line 529: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_WARNING);

525: -- give warning
526: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEGMENT_PREV_CONNECT_ERROR');
527: FND_MESSAGE.SET_TOKEN('TRIP_NAME',l_fte_trip_name);
528: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_NAME',l_wsh_trip_name);
529: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_WARNING);
530: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
531: end if;
532:
533: end if; -- l_previous_segment_id is NOT null

Line 530: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

526: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEGMENT_PREV_CONNECT_ERROR');
527: FND_MESSAGE.SET_TOKEN('TRIP_NAME',l_fte_trip_name);
528: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_NAME',l_wsh_trip_name);
529: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_WARNING);
530: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
531: end if;
532:
533: end if; -- l_previous_segment_id is NOT null
534:

Line 551: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS

547:
548: wsh_debug_sv.dlog (c_debug,'next segment id', l_next_segment_id);
549: wsh_debug_sv.dlog (c_debug,'return status from get_next_segment_id', l_return_status);
550:
551: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
552: AND l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
553: set_return_status
554: (
555: l_return_status,

Line 552: AND l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

548: wsh_debug_sv.dlog (c_debug,'next segment id', l_next_segment_id);
549: wsh_debug_sv.dlog (c_debug,'return status from get_next_segment_id', l_return_status);
550:
551: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
552: AND l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
553: set_return_status
554: (
555: l_return_status,
556: x_return_status

Line 583: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS

579:
580: wsh_debug_sv.dlog (c_debug,'last stop loc id',l_last_stop_location_id);
581: wsh_debug_sv.dlog (c_debug,'return status from get_last_stop_location_id',l_return_status);
582:
583: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
584: AND l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
585: set_return_status
586: (
587: l_return_status,

Line 584: AND l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

580: wsh_debug_sv.dlog (c_debug,'last stop loc id',l_last_stop_location_id);
581: wsh_debug_sv.dlog (c_debug,'return status from get_last_stop_location_id',l_return_status);
582:
583: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
584: AND l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
585: set_return_status
586: (
587: l_return_status,
588: x_return_status

Line 612: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS

608:
609: wsh_debug_sv.dlog (c_debug,'l_connected',l_connected);
610: wsh_debug_sv.dlog (c_debug,'return_status from check_next_segment',l_return_status);
611:
612: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
613: AND l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
614: set_return_status
615: (
616: l_return_status,

Line 613: AND l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

609: wsh_debug_sv.dlog (c_debug,'l_connected',l_connected);
610: wsh_debug_sv.dlog (c_debug,'return_status from check_next_segment',l_return_status);
611:
612: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
613: AND l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
614: set_return_status
615: (
616: l_return_status,
617: x_return_status

Line 638: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

634: -- give warning
635: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEGMENT_NEXT_CONNECT_ERROR');
636: FND_MESSAGE.SET_TOKEN('TRIP_NAME',l_fte_trip_name);
637: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_NAME',l_wsh_trip_name);
638: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
639: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
640:
641: end if;
642:

Line 639: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

635: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEGMENT_NEXT_CONNECT_ERROR');
636: FND_MESSAGE.SET_TOKEN('TRIP_NAME',l_fte_trip_name);
637: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_NAME',l_wsh_trip_name);
638: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
639: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
640:
641: end if;
642:
643: end if; -- l_next_segment_id is NOT null

Line 656: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

652:
653: EXCEPTION
654: WHEN add_segment_to_closed_trip THEN
655: FND_MESSAGE.SET_NAME('FTE', 'FTE_INVALID_TRIP_STATUS');
656: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
657: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
658:
659: wsh_debug_sv.dlog (c_debug,'Return Status',x_Return_Status);
660: wsh_debug_sv.dpop (c_sdebug);

Line 657: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

653: EXCEPTION
654: WHEN add_segment_to_closed_trip THEN
655: FND_MESSAGE.SET_NAME('FTE', 'FTE_INVALID_TRIP_STATUS');
656: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
657: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
658:
659: wsh_debug_sv.dlog (c_debug,'Return Status',x_Return_Status);
660: wsh_debug_sv.dpop (c_sdebug);
661: wsh_debug_sv.stop_debug;

Line 665: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

661: wsh_debug_sv.stop_debug;
662:
663: WHEN add_segment_to_in_transit_trip THEN
664: FND_MESSAGE.SET_NAME('FTE', 'FTE_INVALID_TRIP_STATUS2');
665: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
666: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
667:
668: wsh_debug_sv.dlog (c_debug,'Return Status',x_Return_Status);
669: wsh_debug_sv.dpop (c_sdebug);

Line 666: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

662:
663: WHEN add_segment_to_in_transit_trip THEN
664: FND_MESSAGE.SET_NAME('FTE', 'FTE_INVALID_TRIP_STATUS2');
665: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
666: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
667:
668: wsh_debug_sv.dlog (c_debug,'Return Status',x_Return_Status);
669: wsh_debug_sv.dpop (c_sdebug);
670: wsh_debug_sv.stop_debug;

Line 674: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

670: wsh_debug_sv.stop_debug;
671:
672: WHEN update_sequence_for_non_open THEN
673: FND_MESSAGE.SET_NAME('FTE', 'FTE_INVALID_TRIP_STATUS3');
674: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
675: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
676:
677: wsh_debug_sv.dlog (c_debug,'Return Status',x_Return_Status);
678: wsh_debug_sv.dpop (c_sdebug);

Line 675: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

671:
672: WHEN update_sequence_for_non_open THEN
673: FND_MESSAGE.SET_NAME('FTE', 'FTE_INVALID_TRIP_STATUS3');
674: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
675: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
676:
677: wsh_debug_sv.dlog (c_debug,'Return Status',x_Return_Status);
678: wsh_debug_sv.dpop (c_sdebug);
679: wsh_debug_sv.stop_debug;

Line 682: wsh_util_core.default_handler('FTE_WSH_TRIPS_PUB.Validate_Trip');

678: wsh_debug_sv.dpop (c_sdebug);
679: wsh_debug_sv.stop_debug;
680:
681: WHEN others THEN
682: wsh_util_core.default_handler('FTE_WSH_TRIPS_PUB.Validate_Trip');
683: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
684: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
685:
686: wsh_debug_sv.dlog (c_debug,'Return Status',x_Return_Status);

Line 683: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

679: wsh_debug_sv.stop_debug;
680:
681: WHEN others THEN
682: wsh_util_core.default_handler('FTE_WSH_TRIPS_PUB.Validate_Trip');
683: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
684: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
685:
686: wsh_debug_sv.dlog (c_debug,'Return Status',x_Return_Status);
687: wsh_debug_sv.dpop (c_sdebug);

Line 684: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

680:
681: WHEN others THEN
682: wsh_util_core.default_handler('FTE_WSH_TRIPS_PUB.Validate_Trip');
683: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
684: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
685:
686: wsh_debug_sv.dlog (c_debug,'Return Status',x_Return_Status);
687: wsh_debug_sv.dpop (c_sdebug);
688: wsh_debug_sv.stop_debug;

Line 712: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

708: wsh_debug_sv.dlog (c_debug,'FteTripId ',p_trip_info.fte_trip_id);
709: wsh_debug_sv.dlog (c_debug,'WshTripId ',p_trip_info.wsh_trip_id);
710: wsh_debug_sv.dlog (c_debug,'SequenceNumber ',p_trip_info.sequence_number);
711:
712: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
713:
714: wsh_debug_sv.dlog (c_debug,'about to validate trip...');
715:
716: Validate_Trip(p_trip_info, 'CREATE', x_return_status);

Line 717: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS

713:
714: wsh_debug_sv.dlog (c_debug,'about to validate trip...');
715:
716: Validate_Trip(p_trip_info, 'CREATE', x_return_status);
717: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
718: AND x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
719: RETURN;
720: END IF;
721:

Line 718: AND x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

714: wsh_debug_sv.dlog (c_debug,'about to validate trip...');
715:
716: Validate_Trip(p_trip_info, 'CREATE', x_return_status);
717: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
718: AND x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
719: RETURN;
720: END IF;
721:
722: wsh_debug_sv.dlog (c_debug,'about to insert into fte_wsh_trips table...');

Line 787: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

783: decode(p_trip_info.attribute14, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute14),
784: decode(p_trip_info.attribute15, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute15)
785: );
786:
787: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
788:
789: wsh_debug_sv.dlog (c_debug,'about to mark trip invalid...');
790:
791: --mark trip as invalid

Line 803: wsh_util_core.default_handler('FTE_WSH_TRIPS_PUB.Create_Trip');

799: wsh_debug_sv.stop_debug;
800:
801: EXCEPTION
802: WHEN others THEN
803: wsh_util_core.default_handler('FTE_WSH_TRIPS_PUB.Create_Trip');
804: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
805: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
806:
807: wsh_debug_sv.dlog (c_debug,'Return Status',x_Return_Status);

Line 804: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

800:
801: EXCEPTION
802: WHEN others THEN
803: wsh_util_core.default_handler('FTE_WSH_TRIPS_PUB.Create_Trip');
804: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
805: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
806:
807: wsh_debug_sv.dlog (c_debug,'Return Status',x_Return_Status);
808: wsh_debug_sv.dpop (c_sdebug);

Line 805: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

801: EXCEPTION
802: WHEN others THEN
803: wsh_util_core.default_handler('FTE_WSH_TRIPS_PUB.Create_Trip');
804: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
805: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
806:
807: wsh_debug_sv.dlog (c_debug,'Return Status',x_Return_Status);
808: wsh_debug_sv.dpop (c_sdebug);
809: wsh_debug_sv.stop_debug;

Line 832: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

828: no_trip_found EXCEPTION;
829:
830: BEGIN
831:
832: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
833:
834: if (p_validate_flag = 'Y') then
835:
836: Validate_Trip(p_trip_info, 'UPDATE', x_return_status);

Line 837: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS

833:
834: if (p_validate_flag = 'Y') then
835:
836: Validate_Trip(p_trip_info, 'UPDATE', x_return_status);
837: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
838: AND x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
839: RETURN;
840: END IF;
841:

Line 838: AND x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

834: if (p_validate_flag = 'Y') then
835:
836: Validate_Trip(p_trip_info, 'UPDATE', x_return_status);
837: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
838: AND x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
839: RETURN;
840: END IF;
841:
842: end if;

Line 881: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

877: EXCEPTION
878: WHEN no_trip_found THEN
879: FND_MESSAGE.SET_NAME('FTE','FTE_NO_TRIP_SEGMENT_ID');
880: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_ID',p_trip_info.WSH_TRIP_ID);
881: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
882: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
883: WHEN others THEN
884: wsh_util_core.default_handler('FTE_WSH_TRIPS_PUB.Update_Trip');
885: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 882: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

878: WHEN no_trip_found THEN
879: FND_MESSAGE.SET_NAME('FTE','FTE_NO_TRIP_SEGMENT_ID');
880: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_ID',p_trip_info.WSH_TRIP_ID);
881: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
882: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
883: WHEN others THEN
884: wsh_util_core.default_handler('FTE_WSH_TRIPS_PUB.Update_Trip');
885: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
886: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

Line 884: wsh_util_core.default_handler('FTE_WSH_TRIPS_PUB.Update_Trip');

880: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_ID',p_trip_info.WSH_TRIP_ID);
881: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
882: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
883: WHEN others THEN
884: wsh_util_core.default_handler('FTE_WSH_TRIPS_PUB.Update_Trip');
885: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
886: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
887:
888: END Update_Trip;

Line 885: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

881: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
882: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
883: WHEN others THEN
884: wsh_util_core.default_handler('FTE_WSH_TRIPS_PUB.Update_Trip');
885: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
886: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
887:
888: END Update_Trip;
889:

Line 886: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

882: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
883: WHEN others THEN
884: wsh_util_core.default_handler('FTE_WSH_TRIPS_PUB.Update_Trip');
885: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
886: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
887:
888: END Update_Trip;
889:
890: --

Line 932: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

928: THEN
929: FND_MSG_PUB.initialize;
930: END IF;
931:
932: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
933:
934: fte_mls_util.get_trip_segment_name
935: (
936: p_trip_segment_id => p_wsh_trip_id,

Line 940: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

936: p_trip_segment_id => p_wsh_trip_id,
937: x_trip_segment_name => l_wsh_trip_name,
938: x_return_status => x_return_status
939: );
940: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
941: RETURN;
942: END IF;
943:
944: fte_trips_pvt.get_trip_name

Line 950: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

946: p_trip_id => p_fte_trip_id,
947: x_trip_name => l_fte_trip_name,
948: x_return_status => x_return_status
949: );
950: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
951: RETURN;
952: END IF;
953:
954: Validate_PK

Line 961: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

957: p_wsh_trip_id,
958: x_return_status
959: );
960:
961: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
962: FND_MSG_PUB.Count_And_Get
963: ( p_count => x_msg_count
964: , p_data => x_msg_data
965: , p_encoded => FND_API.G_FALSE

Line 993: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS

989: x_previous_segment_id => l_previous_segment_id,
990: x_return_status => l_return_status
991: );
992:
993: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
994: AND l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
995: set_return_status
996: (
997: l_return_status,

Line 994: AND l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

990: x_return_status => l_return_status
991: );
992:
993: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
994: AND l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
995: set_return_status
996: (
997: l_return_status,
998: x_return_status

Line 1019: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS

1015: x_next_segment_id => l_next_segment_id,
1016: x_return_status => l_return_status
1017: );
1018:
1019: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
1020: AND l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
1021: set_return_status
1022: (
1023: l_return_status,

Line 1020: AND l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

1016: x_return_status => l_return_status
1017: );
1018:
1019: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
1020: AND l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
1021: set_return_status
1022: (
1023: l_return_status,
1024: x_return_status

Line 1044: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

1040:
1041: -- give warning
1042: FND_MESSAGE.SET_NAME('FTE', 'FTE_INVALID_CONNECT_SEGMENT');
1043: FND_MESSAGE.SET_TOKEN('TRIP_NAME',l_fte_trip_name);
1044: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1045: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1046:
1047: end if;
1048:

Line 1045: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

1041: -- give warning
1042: FND_MESSAGE.SET_NAME('FTE', 'FTE_INVALID_CONNECT_SEGMENT');
1043: FND_MESSAGE.SET_TOKEN('TRIP_NAME',l_fte_trip_name);
1044: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1045: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1046:
1047: end if;
1048:
1049: FND_MSG_PUB.Count_And_Get

Line 1059: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1055: EXCEPTION
1056: WHEN invalid_trip_status THEN
1057: -- cannot add/remove segments from trip with this status
1058: FND_MESSAGE.SET_NAME('FTE', 'FTE_INVALID_TRIP_STATUS3');
1059: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1060: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1061: FND_MSG_PUB.Count_And_Get
1062: ( p_count => x_msg_count
1063: , p_data => x_msg_data

Line 1060: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

1056: WHEN invalid_trip_status THEN
1057: -- cannot add/remove segments from trip with this status
1058: FND_MESSAGE.SET_NAME('FTE', 'FTE_INVALID_TRIP_STATUS3');
1059: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1060: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1061: FND_MSG_PUB.Count_And_Get
1062: ( p_count => x_msg_count
1063: , p_data => x_msg_data
1064: , p_encoded => FND_API.G_FALSE

Line 1067: wsh_util_core.default_handler('FTE_WSH_TRIPS_PUB.Validate_Trip_For_Delete');

1063: , p_data => x_msg_data
1064: , p_encoded => FND_API.G_FALSE
1065: );
1066: WHEN others THEN
1067: wsh_util_core.default_handler('FTE_WSH_TRIPS_PUB.Validate_Trip_For_Delete');
1068: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1069: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1070: FND_MSG_PUB.Count_And_Get
1071: ( p_count => x_msg_count

Line 1068: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1064: , p_encoded => FND_API.G_FALSE
1065: );
1066: WHEN others THEN
1067: wsh_util_core.default_handler('FTE_WSH_TRIPS_PUB.Validate_Trip_For_Delete');
1068: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1069: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1070: FND_MSG_PUB.Count_And_Get
1071: ( p_count => x_msg_count
1072: , p_data => x_msg_data

Line 1069: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

1065: );
1066: WHEN others THEN
1067: wsh_util_core.default_handler('FTE_WSH_TRIPS_PUB.Validate_Trip_For_Delete');
1068: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1069: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1070: FND_MSG_PUB.Count_And_Get
1071: ( p_count => x_msg_count
1072: , p_data => x_msg_data
1073: , p_encoded => FND_API.G_FALSE

Line 1113: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1109: THEN
1110: FND_MSG_PUB.initialize;
1111: END IF;
1112:
1113: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1114:
1115: Validate_Trip_For_Delete
1116: (
1117: p_fte_trip_id => p_fte_trip_id,

Line 1123: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS

1119: x_msg_count => x_msg_count,
1120: x_msg_data => x_msg_data,
1121: x_return_status => x_return_status);
1122:
1123: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
1124: AND x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
1125: FND_MSG_PUB.Count_And_Get
1126: ( p_count => x_msg_count
1127: , p_data => x_msg_data

Line 1124: AND x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

1120: x_msg_data => x_msg_data,
1121: x_return_status => x_return_status);
1122:
1123: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
1124: AND x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
1125: FND_MSG_PUB.Count_And_Get
1126: ( p_count => x_msg_count
1127: , p_data => x_msg_data
1128: , p_encoded => FND_API.G_FALSE

Line 1140: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

1136: if (SQL%NOTFOUND) then
1137: RAISE no_trip_found;
1138: end if;
1139:
1140: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
1141: --mark trip as invalid
1142: update fte_trips
1143: set validation_required = 'Y'
1144: where fte_trip_id = p_fte_trip_id;

Line 1161: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1157: EXCEPTION
1158: WHEN no_trip_found THEN
1159: FND_MESSAGE.SET_NAME('FTE','FTE_NO_TRIP_SEGMENT_ID');
1160: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_ID',p_wsh_trip_id);
1161: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1162: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1163: FND_MSG_PUB.Count_And_Get
1164: ( p_count => x_msg_count
1165: , p_data => x_msg_data

Line 1162: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

1158: WHEN no_trip_found THEN
1159: FND_MESSAGE.SET_NAME('FTE','FTE_NO_TRIP_SEGMENT_ID');
1160: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_ID',p_wsh_trip_id);
1161: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1162: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1163: FND_MSG_PUB.Count_And_Get
1164: ( p_count => x_msg_count
1165: , p_data => x_msg_data
1166: , p_encoded => FND_API.G_FALSE

Line 1169: wsh_util_core.default_handler('FTE_WSH_TRIPS_PUB.Delete_Trip');

1165: , p_data => x_msg_data
1166: , p_encoded => FND_API.G_FALSE
1167: );
1168: WHEN others THEN
1169: wsh_util_core.default_handler('FTE_WSH_TRIPS_PUB.Delete_Trip');
1170: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1171: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1172: FND_MSG_PUB.Count_And_Get
1173: ( p_count => x_msg_count

Line 1170: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1166: , p_encoded => FND_API.G_FALSE
1167: );
1168: WHEN others THEN
1169: wsh_util_core.default_handler('FTE_WSH_TRIPS_PUB.Delete_Trip');
1170: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1171: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1172: FND_MSG_PUB.Count_And_Get
1173: ( p_count => x_msg_count
1174: , p_data => x_msg_data

Line 1171: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

1167: );
1168: WHEN others THEN
1169: wsh_util_core.default_handler('FTE_WSH_TRIPS_PUB.Delete_Trip');
1170: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1171: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1172: FND_MSG_PUB.Count_And_Get
1173: ( p_count => x_msg_count
1174: , p_data => x_msg_data
1175: , p_encoded => FND_API.G_FALSE

Line 1239: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1235: THEN
1236: FND_MSG_PUB.initialize;
1237: END IF;
1238:
1239: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1240:
1241: -- populate trip record
1242: p_trip_info.FTE_TRIP_ID :=pp_FTE_TRIP_ID;
1243: p_trip_info.WSH_TRIP_ID :=pp_WSH_TRIP_ID;

Line 1300: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1296: EXCEPTION
1297: WHEN invalid_action THEN
1298: FND_MESSAGE.SET_NAME('FTE','FTE_WSH_TRIPS_WRAPPER_ERR1');
1299: FND_MESSAGE.SET_TOKEN('ACTION',p_action_code);
1300: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1301: wsh_util_core.add_message(x_return_status);
1302: FND_MSG_PUB.Count_And_Get
1303: ( p_count => x_msg_count
1304: , p_data => x_msg_data

Line 1301: wsh_util_core.add_message(x_return_status);

1297: WHEN invalid_action THEN
1298: FND_MESSAGE.SET_NAME('FTE','FTE_WSH_TRIPS_WRAPPER_ERR1');
1299: FND_MESSAGE.SET_TOKEN('ACTION',p_action_code);
1300: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1301: wsh_util_core.add_message(x_return_status);
1302: FND_MSG_PUB.Count_And_Get
1303: ( p_count => x_msg_count
1304: , p_data => x_msg_data
1305: , p_encoded => FND_API.G_FALSE

Line 1308: wsh_util_core.default_handler('FTE_WSH_TRIPS_PUB.Validate_Trip_Wrapper');

1304: , p_data => x_msg_data
1305: , p_encoded => FND_API.G_FALSE
1306: );
1307: WHEN others THEN
1308: wsh_util_core.default_handler('FTE_WSH_TRIPS_PUB.Validate_Trip_Wrapper');
1309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1310: wsh_util_core.add_message(x_return_status);
1311: FND_MSG_PUB.Count_And_Get
1312: ( p_count => x_msg_count

Line 1310: wsh_util_core.add_message(x_return_status);

1306: );
1307: WHEN others THEN
1308: wsh_util_core.default_handler('FTE_WSH_TRIPS_PUB.Validate_Trip_Wrapper');
1309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1310: wsh_util_core.add_message(x_return_status);
1311: FND_MSG_PUB.Count_And_Get
1312: ( p_count => x_msg_count
1313: , p_data => x_msg_data
1314: , p_encoded => FND_API.G_FALSE

Line 1387: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1383: THEN
1384: FND_MSG_PUB.initialize;
1385: END IF;
1386:
1387: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1388:
1389: -- populate trip record
1390: p_trip_info.FTE_TRIP_ID :=pp_FTE_TRIP_ID;
1391: p_trip_info.WSH_TRIP_ID :=pp_WSH_TRIP_ID;

Line 1451: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1447: EXCEPTION
1448: WHEN invalid_action THEN
1449: FND_MESSAGE.SET_NAME('FTE','FTE_WSH_TRIPS_WRAPPER_ERR1');
1450: FND_MESSAGE.SET_TOKEN('ACTION',p_action_code);
1451: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1452: wsh_util_core.add_message(x_return_status);
1453: FND_MSG_PUB.Count_And_Get
1454: ( p_count => x_msg_count
1455: , p_data => x_msg_data

Line 1452: wsh_util_core.add_message(x_return_status);

1448: WHEN invalid_action THEN
1449: FND_MESSAGE.SET_NAME('FTE','FTE_WSH_TRIPS_WRAPPER_ERR1');
1450: FND_MESSAGE.SET_TOKEN('ACTION',p_action_code);
1451: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1452: wsh_util_core.add_message(x_return_status);
1453: FND_MSG_PUB.Count_And_Get
1454: ( p_count => x_msg_count
1455: , p_data => x_msg_data
1456: , p_encoded => FND_API.G_FALSE

Line 1464: wsh_util_core.default_handler('FTE_WSH_TRIPS_PUB.Create_Update_Trip_Wrapper');

1460: wsh_debug_sv.dpop (c_sdebug);
1461: wsh_debug_sv.stop_debug;
1462:
1463: WHEN others THEN
1464: wsh_util_core.default_handler('FTE_WSH_TRIPS_PUB.Create_Update_Trip_Wrapper');
1465: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1466: wsh_util_core.add_message(x_return_status);
1467: FND_MSG_PUB.Count_And_Get
1468: ( p_count => x_msg_count

Line 1466: wsh_util_core.add_message(x_return_status);

1462:
1463: WHEN others THEN
1464: wsh_util_core.default_handler('FTE_WSH_TRIPS_PUB.Create_Update_Trip_Wrapper');
1465: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1466: wsh_util_core.add_message(x_return_status);
1467: FND_MSG_PUB.Count_And_Get
1468: ( p_count => x_msg_count
1469: , p_data => x_msg_data
1470: , p_encoded => FND_API.G_FALSE