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

Line 54: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

50: l_found BOOLEAN;
51:
52: BEGIN
53:
54: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
55:
56: --validate sequence
57:
58: if (p_trip_moves_info.sequence_number = null

Line 95: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

91:
92: EXCEPTION
93: WHEN empty_move THEN
94: FND_MESSAGE.SET_NAME('FTE', 'FTE_MOVE_MISSING');
95: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
96: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
97: WHEN empty_sequence THEN
98: FND_MESSAGE.SET_NAME('FTE', 'FTE_MOVE_SEQUENCE_MISSING');
99: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 96: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

92: EXCEPTION
93: WHEN empty_move THEN
94: FND_MESSAGE.SET_NAME('FTE', 'FTE_MOVE_MISSING');
95: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
96: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
97: WHEN empty_sequence THEN
98: FND_MESSAGE.SET_NAME('FTE', 'FTE_MOVE_SEQUENCE_MISSING');
99: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
100: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

Line 99: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

95: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
96: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
97: WHEN empty_sequence THEN
98: FND_MESSAGE.SET_NAME('FTE', 'FTE_MOVE_SEQUENCE_MISSING');
99: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
100: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
101: WHEN duplicate_sequence THEN
102: FND_MESSAGE.SET_NAME('FTE', 'FTE_MOVE_SEQUENCE_DUP');
103: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 100: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

96: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
97: WHEN empty_sequence THEN
98: FND_MESSAGE.SET_NAME('FTE', 'FTE_MOVE_SEQUENCE_MISSING');
99: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
100: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
101: WHEN duplicate_sequence THEN
102: FND_MESSAGE.SET_NAME('FTE', 'FTE_MOVE_SEQUENCE_DUP');
103: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
104: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

Line 103: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

99: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
100: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
101: WHEN duplicate_sequence THEN
102: FND_MESSAGE.SET_NAME('FTE', 'FTE_MOVE_SEQUENCE_DUP');
103: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
104: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
105: WHEN others THEN
106: IF check_sequence_create%ISOPEN THEN
107: CLOSE check_sequence_create;

Line 104: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

100: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
101: WHEN duplicate_sequence THEN
102: FND_MESSAGE.SET_NAME('FTE', 'FTE_MOVE_SEQUENCE_DUP');
103: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
104: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
105: WHEN others THEN
106: IF check_sequence_create%ISOPEN THEN
107: CLOSE check_sequence_create;
108: END IF;

Line 115: wsh_util_core.default_handler('FTE_TRIP_MOVES_PUB.Validate_Sequence');

111: END IF;
112: IF check_move_id%ISOPEN THEN
113: CLOSE check_move_id;
114: END IF;
115: wsh_util_core.default_handler('FTE_TRIP_MOVES_PUB.Validate_Sequence');
116: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
117: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
118:
119: END Validate_Sequence;

Line 116: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

112: IF check_move_id%ISOPEN THEN
113: CLOSE check_move_id;
114: END IF;
115: wsh_util_core.default_handler('FTE_TRIP_MOVES_PUB.Validate_Sequence');
116: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
117: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
118:
119: END Validate_Sequence;
120:

Line 117: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

113: CLOSE check_move_id;
114: END IF;
115: wsh_util_core.default_handler('FTE_TRIP_MOVES_PUB.Validate_Sequence');
116: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
117: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
118:
119: END Validate_Sequence;
120:
121:

Line 167: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

163: l_found BOOLEAN;
164:
165: BEGIN
166:
167: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
168:
169:
170: OPEN check_trip_id(p_trip_moves_info.trip_id);
171: FETCH check_trip_id INTO l_number;

Line 211: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

207:
208: EXCEPTION
209: WHEN empty_trip THEN
210: FND_MESSAGE.SET_NAME('FTE', 'FTE_TRIP_MISSING');
211: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
212: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
213: WHEN duplicate_trip THEN
214: FND_MESSAGE.SET_NAME('FTE', 'FTE_MOVE_TRIP_DUP');
215: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 212: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

208: EXCEPTION
209: WHEN empty_trip THEN
210: FND_MESSAGE.SET_NAME('FTE', 'FTE_TRIP_MISSING');
211: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
212: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
213: WHEN duplicate_trip THEN
214: FND_MESSAGE.SET_NAME('FTE', 'FTE_MOVE_TRIP_DUP');
215: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
216: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

Line 215: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

211: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
212: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
213: WHEN duplicate_trip THEN
214: FND_MESSAGE.SET_NAME('FTE', 'FTE_MOVE_TRIP_DUP');
215: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
216: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
217: WHEN others THEN
218: if check_trip_id%ISOPEN THEN
219: close check_trip_id;

Line 216: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

212: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
213: WHEN duplicate_trip THEN
214: FND_MESSAGE.SET_NAME('FTE', 'FTE_MOVE_TRIP_DUP');
215: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
216: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
217: WHEN others THEN
218: if check_trip_id%ISOPEN THEN
219: close check_trip_id;
220: end if;

Line 227: wsh_util_core.default_handler('FTE_TRIP_MOVES_PUB.validate_unique_trip');

223: end if;
224: if check_unique_trip_update%ISOPEN THEN
225: close check_unique_trip_update;
226: end if;
227: wsh_util_core.default_handler('FTE_TRIP_MOVES_PUB.validate_unique_trip');
228: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
229: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
230:
231: END validate_unique_trip;

Line 228: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

224: if check_unique_trip_update%ISOPEN THEN
225: close check_unique_trip_update;
226: end if;
227: wsh_util_core.default_handler('FTE_TRIP_MOVES_PUB.validate_unique_trip');
228: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
229: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
230:
231: END validate_unique_trip;
232:

Line 229: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

225: close check_unique_trip_update;
226: end if;
227: wsh_util_core.default_handler('FTE_TRIP_MOVES_PUB.validate_unique_trip');
228: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
229: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
230:
231: END validate_unique_trip;
232:
233:

Line 260: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

256: l_temp_id NUMBER;
257:
258: BEGIN
259:
260: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
261:
262: IF FND_API.to_Boolean( p_init_msg_list )
263: THEN
264: FND_MSG_PUB.initialize;

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

269: p_trip_moves_info,
270: x_return_status
271: );
272:
273: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
274: RETURN;
275: END IF;
276:
277: Validate_Unique_trip

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

279: p_trip_moves_info,
280: x_return_status
281: );
282:
283: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
284: RETURN;
285: END IF;
286:
287:

Line 327: wsh_util_core.default_handler('FTE_TRIP_MOVES.CREATE_TRIP_MOVES');

323: );
324:
325: EXCEPTION
326: WHEN others THEN
327: wsh_util_core.default_handler('FTE_TRIP_MOVES.CREATE_TRIP_MOVES');
328: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
329: END Create_Trip_Moves;
330:
331:

Line 328: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

324:
325: EXCEPTION
326: WHEN others THEN
327: wsh_util_core.default_handler('FTE_TRIP_MOVES.CREATE_TRIP_MOVES');
328: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
329: END Create_Trip_Moves;
330:
331:
332: --========================================================================

Line 355: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

351: THEN
352: FND_MSG_PUB.initialize;
353: END IF;
354:
355: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
356:
357: Validate_Sequence
358: (
359: p_trip_moves_info,

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

359: p_trip_moves_info,
360: x_return_status
361: );
362:
363: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
364: RETURN;
365: END IF;
366:
367: Validate_Unique_trip

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

369: p_trip_moves_info,
370: x_return_status
371: );
372:
373: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
374: RETURN;
375: END IF;
376:
377:

Line 419: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

415:
416: EXCEPTION
417: WHEN FTE_DUPLICATE_MOVE THEN
418: FND_MESSAGE.Set_Name('FND', 'FORM_DUPLICATE_KEY_IN_INDEX');
419: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
420: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
421: WHEN no_data_found THEN
422: FND_MESSAGE.SET_NAME('FTE','FTE_TRIP_MOVE_NOT_FOUND');
423: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 420: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

416: EXCEPTION
417: WHEN FTE_DUPLICATE_MOVE THEN
418: FND_MESSAGE.Set_Name('FND', 'FORM_DUPLICATE_KEY_IN_INDEX');
419: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
420: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
421: WHEN no_data_found THEN
422: FND_MESSAGE.SET_NAME('FTE','FTE_TRIP_MOVE_NOT_FOUND');
423: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
424: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

Line 423: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

419: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
420: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
421: WHEN no_data_found THEN
422: FND_MESSAGE.SET_NAME('FTE','FTE_TRIP_MOVE_NOT_FOUND');
423: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
424: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
425: WHEN others THEN
426: wsh_util_core.default_handler('FTE_TRIP_MOVES_PVT.UPDATE_TRIP_MOVES');
427: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 424: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

420: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
421: WHEN no_data_found THEN
422: FND_MESSAGE.SET_NAME('FTE','FTE_TRIP_MOVE_NOT_FOUND');
423: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
424: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
425: WHEN others THEN
426: wsh_util_core.default_handler('FTE_TRIP_MOVES_PVT.UPDATE_TRIP_MOVES');
427: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
428:

Line 426: wsh_util_core.default_handler('FTE_TRIP_MOVES_PVT.UPDATE_TRIP_MOVES');

422: FND_MESSAGE.SET_NAME('FTE','FTE_TRIP_MOVE_NOT_FOUND');
423: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
424: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
425: WHEN others THEN
426: wsh_util_core.default_handler('FTE_TRIP_MOVES_PVT.UPDATE_TRIP_MOVES');
427: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
428:
429: END Update_Trip_Moves;
430:

Line 427: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

423: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
424: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
425: WHEN others THEN
426: wsh_util_core.default_handler('FTE_TRIP_MOVES_PVT.UPDATE_TRIP_MOVES');
427: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
428:
429: END Update_Trip_Moves;
430:
431:

Line 446: x_return_Status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

442: THEN
443: FND_MSG_PUB.initialize;
444: END IF;
445:
446: x_return_Status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
447:
448: DELETE FROM fte_trip_moves
449: WHERE trip_move_id = p_trip_move_id;
450:

Line 454: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

450:
451: IF (SQL%NOTFOUND) THEN
452: FND_MESSAGE.SET_NAME('FTE','FTE_TRIP_MOVE_NOT_FOUND');
453: FND_MESSAGE.SET_TOKEN('TRIP_MOVE_ID', p_trip_move_id);
454: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
455: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
456: END IF;
457:
458: EXCEPTION

Line 455: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

451: IF (SQL%NOTFOUND) THEN
452: FND_MESSAGE.SET_NAME('FTE','FTE_TRIP_MOVE_NOT_FOUND');
453: FND_MESSAGE.SET_TOKEN('TRIP_MOVE_ID', p_trip_move_id);
454: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
455: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
456: END IF;
457:
458: EXCEPTION
459: WHEN others THEN

Line 460: wsh_util_core.default_handler('FTE_TRIP_MOVES_PVT.DELETE_TRIP_MOVES');

456: END IF;
457:
458: EXCEPTION
459: WHEN others THEN
460: wsh_util_core.default_handler('FTE_TRIP_MOVES_PVT.DELETE_TRIP_MOVES');
461: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
462:
463: END Delete_Trip_moves;
464:

Line 461: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

457:
458: EXCEPTION
459: WHEN others THEN
460: wsh_util_core.default_handler('FTE_TRIP_MOVES_PVT.DELETE_TRIP_MOVES');
461: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
462:
463: END Delete_Trip_moves;
464:
465: --