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_TRIPS

Line 1: PACKAGE BODY FTE_WSH_TRIPS_PVT AS

1: PACKAGE BODY FTE_WSH_TRIPS_PVT AS
2: /* $Header: FTEFWTHB.pls 115.11 2002/12/03 21:48:40 hbhagava noship $ */
3:
4:
5: procedure set_return_status

Line 68: SELECT trip_id FROM wsh_trips

64: SELECT fte_trip_id FROM fte_trips
65: WHERE fte_trip_id = v_trip_id;
66:
67: CURSOR check_wsh_trip_id (v_trip_id NUMBER) IS
68: SELECT trip_id FROM wsh_trips
69: WHERE trip_id = v_trip_id;
70:
71: invalid_fte_trip_id EXCEPTION;
72: invalid_wsh_trip_id EXCEPTION;

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 141: SELECT fte_trip_id FROM fte_wsh_trips

137: x_return_status OUT NOCOPY VARCHAR2
138: ) IS
139:
140: CURSOR check_sequence (v_fte_trip_id NUMBER, v_sequence NUMBER) IS
141: SELECT fte_trip_id FROM fte_wsh_trips
142: WHERE fte_trip_id = v_fte_trip_id and sequence_number = v_sequence;
143:
144: empty_sequence EXCEPTION;
145: duplicate_sequence EXCEPTION;

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 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 457: from fte_wsh_trips

453:
454: if (l_previous_segment_id is NOT null) then
455:
456: select sequence_number into l_previous_sequence_number
457: from fte_wsh_trips
458: where fte_trip_id = p_trip_info.FTE_TRIP_ID
459: and wsh_trip_id = l_previous_segment_id;
460:
461: wsh_debug_sv.dlog (c_debug,'about to get_first_stop_location_id...');

Line 566: from fte_wsh_trips

562:
563: if (l_next_segment_id is NOT null) then
564:
565: select sequence_number into l_next_sequence_number
566: from fte_wsh_trips
567: where fte_trip_id = p_trip_info.FTE_TRIP_ID
568: and wsh_trip_id = l_next_segment_id;
569:
570: wsh_debug_sv.dlog (c_debug,'about to get_last_stop_location_id...');

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 722: wsh_debug_sv.dlog (c_debug,'about to insert into fte_wsh_trips table...');

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...');
723:
724: insert into fte_wsh_trips
725: (
726: FTE_TRIP_ID ,

Line 724: insert into fte_wsh_trips

720: END IF;
721:
722: wsh_debug_sv.dlog (c_debug,'about to insert into fte_wsh_trips table...');
723:
724: insert into fte_wsh_trips
725: (
726: FTE_TRIP_ID ,
727: WSH_TRIP_ID ,
728: SEQUENCE_NUMBER ,

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 844: update fte_wsh_trips set

840: END IF;
841:
842: end if;
843:
844: update fte_wsh_trips set
845: SEQUENCE_NUMBER = decode(p_trip_info.SEQUENCE_NUMBER, FND_API.G_MISS_NUM, NULL, p_trip_info.SEQUENCE_NUMBER),
846: creation_date = decode(p_trip_info.creation_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE, p_trip_info.creation_date),
847: created_by = decode(p_trip_info.created_by,FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_trip_info.created_by),
848: last_update_date = decode(p_trip_info.last_update_date,FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE, p_trip_info.creation_date),

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 979: from fte_wsh_trips

975:
976: -- if removing from middle, giving Warning
977:
978: select sequence_number into l_sequence_number
979: from fte_wsh_trips
980: where fte_trip_id = p_fte_trip_id and wsh_trip_id = p_wsh_trip_id;
981:
982: fte_mls_util.get_previous_segment_id
983: (

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 1133: delete from fte_wsh_trips

1129: );
1130: RETURN;
1131: END IF;
1132:
1133: delete from fte_wsh_trips
1134: where fte_trip_id = p_fte_trip_id and wsh_trip_id = p_wsh_trip_id;
1135:
1136: if (SQL%NOTFOUND) then
1137: RAISE no_trip_found;

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 1298: FND_MESSAGE.SET_NAME('FTE','FTE_WSH_TRIPS_WRAPPER_ERR1');

1294: );
1295:
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

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 1449: FND_MESSAGE.SET_NAME('FTE','FTE_WSH_TRIPS_WRAPPER_ERR1');

1445: wsh_debug_sv.stop_debug;
1446:
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

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 1479: END FTE_WSH_TRIPS_PVT;

1475: wsh_debug_sv.stop_debug;
1476:
1477: END Create_Update_Trip_Wrapper;
1478:
1479: END FTE_WSH_TRIPS_PVT;