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_TRIPS_PVT dependencies on FTE_TRIPS

Line 1: PACKAGE BODY FTE_TRIPS_PVT AS

1: PACKAGE BODY FTE_TRIPS_PVT AS
2: /* $Header: FTETRTHB.pls 115.22 2003/04/24 23:48:35 nltan noship $ */
3:
4: --===================
5: -- CONSTANTS

Line 7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'FTE_TRIPS_PVT';

3:
4: --===================
5: -- CONSTANTS
6: --===================
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'FTE_TRIPS_PVT';
8:
9:
10:
11: -- Wrapper around create_trip and update_trip

Line 186: wsh_util_core.default_handler('FTE_TRIPS_PVT.Create_Update_Delete_Fte_Trip');

182: wsh_debug_sv.dpop (c_sdebug);
183: wsh_debug_sv.stop_debug;
184:
185: WHEN others THEN
186: wsh_util_core.default_handler('FTE_TRIPS_PVT.Create_Update_Delete_Fte_Trip');
187: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
188: FND_MSG_PUB.Count_And_Get
189: ( p_encoded => FND_API.G_FALSE,
190: p_count => x_msg_count

Line 219: SELECT fte_trips_s.nextval

215: x_return_status OUT NOCOPY VARCHAR2
216: ) IS
217:
218: CURSOR get_next_trip IS
219: SELECT fte_trips_s.nextval
220: FROM sys.dual;
221:
222: CURSOR check_trip_names (v_trip_name VARCHAR2) IS
223: SELECT fte_trip_id FROM fte_trips

Line 223: SELECT fte_trip_id FROM fte_trips

219: SELECT fte_trips_s.nextval
220: FROM sys.dual;
221:
222: CURSOR check_trip_names (v_trip_name VARCHAR2) IS
223: SELECT fte_trip_id FROM fte_trips
224: WHERE name = v_trip_name;
225:
226: CURSOR check_trip_ids (v_trip_id NUMBER) IS
227: SELECT fte_trip_id FROM fte_trips

Line 227: SELECT fte_trip_id FROM fte_trips

223: SELECT fte_trip_id FROM fte_trips
224: WHERE name = v_trip_name;
225:
226: CURSOR check_trip_ids (v_trip_id NUMBER) IS
227: SELECT fte_trip_id FROM fte_trips
228: WHERE fte_trip_id = v_trip_id;
229:
230: l_name fte_trips.name%TYPE;
231: l_row_check NUMBER;

Line 230: l_name fte_trips.name%TYPE;

226: CURSOR check_trip_ids (v_trip_id NUMBER) IS
227: SELECT fte_trip_id FROM fte_trips
228: WHERE fte_trip_id = v_trip_id;
229:
230: l_name fte_trips.name%TYPE;
231: l_row_check NUMBER;
232: l_temp_id NUMBER;
233:
234: l_tmp_count NUMBER := 0;

Line 319: wsh_debug_sv.dlog (c_debug,'about to insert into fte_trips table...');

315: END IF;
316:
317: END IF;
318:
319: wsh_debug_sv.dlog (c_debug,'about to insert into fte_trips table...');
320: wsh_debug_sv.dlog (c_debug,'trip id ', x_trip_id);
321: wsh_debug_sv.dlog (c_debug,'name', x_name);
322:
323: INSERT INTO fte_trips(

Line 323: INSERT INTO fte_trips(

319: wsh_debug_sv.dlog (c_debug,'about to insert into fte_trips table...');
320: wsh_debug_sv.dlog (c_debug,'trip id ', x_trip_id);
321: wsh_debug_sv.dlog (c_debug,'name', x_name);
322:
323: INSERT INTO fte_trips(
324: FTE_TRIP_ID ,
325: NAME ,
326: STATUS_CODE ,
327: PRIVATE_TRIP ,

Line 408: wsh_util_core.default_handler('FTE_TRIPS_PVT.CREATE_TRIP');

404: wsh_debug_sv.dlog (c_debug,'wsh_duplicate_name exception');
405: wsh_debug_sv.dpop (c_sdebug);
406:
407: WHEN others THEN
408: wsh_util_core.default_handler('FTE_TRIPS_PVT.CREATE_TRIP');
409: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
410:
411: wsh_debug_sv.dlog (c_debug,'Return Status',x_Return_Status);
412: wsh_debug_sv.dlog (c_debug,'others exception');

Line 425: SELECT fte_trip_id FROM fte_trips

421: x_return_status OUT NOCOPY VARCHAR2
422: ) IS
423:
424: CURSOR check_trip_names (v_trip_name VARCHAR2) IS
425: SELECT fte_trip_id FROM fte_trips
426: WHERE name = v_trip_name;
427:
428: l_name fte_trips.name%TYPE;
429: l_row_check NUMBER;

Line 428: l_name fte_trips.name%TYPE;

424: CURSOR check_trip_names (v_trip_name VARCHAR2) IS
425: SELECT fte_trip_id FROM fte_trips
426: WHERE name = v_trip_name;
427:
428: l_name fte_trips.name%TYPE;
429: l_row_check NUMBER;
430: wsh_duplicate_name EXCEPTION;
431:
432: BEGIN

Line 466: wsh_util_core.default_handler('FTE_TRIPS_PVT.VALIDATE_CREATETRIP');

462: wsh_debug_sv.dlog (c_debug,'wsh_duplicate_name exception');
463: wsh_debug_sv.dpop (c_sdebug);
464:
465: WHEN others THEN
466: wsh_util_core.default_handler('FTE_TRIPS_PVT.VALIDATE_CREATETRIP');
467: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
468:
469: wsh_debug_sv.dlog (c_debug,'Return Status',x_Return_Status);
470: wsh_debug_sv.dlog (c_debug,'others exception');

Line 492: SELECT fte_trip_id FROM fte_trips

488: p_trip_info IN fte_trip_rec_type,
489: x_return_status OUT NOCOPY VARCHAR2) IS
490:
491: CURSOR check_trip_names (v_trip_name VARCHAR2) IS
492: SELECT fte_trip_id FROM fte_trips
493: WHERE name = v_trip_name;
494:
495: l_row_check NUMBER;
496:

Line 515: UPDATE fte_trips SET

511: RETURN;
512: END IF;
513:
514:
515: UPDATE fte_trips SET
516: fte_trip_id = decode(p_trip_info.fte_trip_id,FND_API.G_MISS_NUM, fte_trip_id, p_trip_info.fte_trip_id),
517: name = decode(p_trip_info.name, FND_API.G_MISS_CHAR, name, p_trip_info.name),
518: status_code = decode(p_trip_info.status_code, FND_API.G_MISS_CHAR, status_code, p_trip_info.status_code),
519: private_trip=decode(p_trip_info.private_trip, FND_API.G_MISS_CHAR, NULL, p_trip_info.private_trip),

Line 565: wsh_util_core.default_handler('FTE_TRIPS_PVT.UPDATE_TRIP');

561: FND_MESSAGE.SET_NAME('FTE','FTE_TRIP_NOT_FOUND');
562: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
563: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
564: WHEN others THEN
565: wsh_util_core.default_handler('FTE_TRIPS_PVT.UPDATE_TRIP');
566: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
567:
568: END Update_Trip;
569:

Line 578: SELECT fte_trip_id FROM fte_trips

574: p_trip_status IN VARCHAR2,
575: x_return_status OUT NOCOPY VARCHAR2) IS
576:
577: CURSOR check_trip_names (v_trip_name VARCHAR2) IS
578: SELECT fte_trip_id FROM fte_trips
579: WHERE name = v_trip_name;
580:
581: l_row_check NUMBER;
582:

Line 627: wsh_util_core.default_handler('FTE_TRIPS_PVT.VALIDATE_UPDATETRIP');

623: FND_MESSAGE.SET_NAME('FTE','FTE_INVALID_TRIP_STATUS');
624: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
625: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
626: WHEN others THEN
627: wsh_util_core.default_handler('FTE_TRIPS_PVT.VALIDATE_UPDATETRIP');
628: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
629:
630: END Validate_UpdateTrip;
631:

Line 664: DELETE FROM fte_trips

660: THEN
661: RETURN;
662: END IF;
663:
664: DELETE FROM fte_trips
665: WHERE fte_trip_id = l_trip_id;
666:
667: IF (SQL%NOTFOUND) THEN
668: FND_MESSAGE.SET_NAME('FTE','FTE_NO_TRIP_ID');

Line 676: wsh_util_core.default_handler('FTE_TRIPS_PVT.DELETE_TRIP');

672: END IF;
673:
674: EXCEPTION
675: WHEN others THEN
676: wsh_util_core.default_handler('FTE_TRIPS_PVT.DELETE_TRIP');
677: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
678:
679: END Delete_Trip;
680:

Line 724: wsh_util_core.default_handler('FTE_TRIPS_PVT.VALIDATE_DELETETRIP');

720: end if;
721:
722: EXCEPTION
723: WHEN others THEN
724: wsh_util_core.default_handler('FTE_TRIPS_PVT.VALIDATE_DELETETRIP');
725: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
726:
727: END Validate_DeleteTrip;
728:

Line 786: UPDATE FTE_TRIPS SET validation_required='Y'

782: if ((l_segment_sequencenum_prev=l_segment_sequencenum_next)) then
783:
784: wsh_debug_sv.dlog (c_debug,'segment number unique check');
785:
786: UPDATE FTE_TRIPS SET validation_required='Y'
787: where fte_trip_id=p_trip_id;
788:
789: IF (SQL%NOTFOUND) THEN
790: RAISE no_data_found;

Line 827: UPDATE FTE_TRIPS SET validation_required='Y'

823:
824: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
825: wsh_debug_sv.dlog (c_debug,'could not get 1st stop location');
826: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
827: UPDATE FTE_TRIPS SET validation_required='Y'
828: where fte_trip_id=p_trip_id;
829: IF (SQL%NOTFOUND) THEN
830: RAISE no_data_found;
831: END IF;

Line 855: UPDATE FTE_TRIPS SET validation_required='Y'

851: --1. segment shud have atleast 2 stops
852: if ((trip_stops%ROWCOUNT<2)) then
853: CLOSE trip_stops;
854: wsh_debug_sv.dlog (c_debug,'segment shud have atleast 2 stops');
855: UPDATE FTE_TRIPS SET validation_required='Y'
856: where fte_trip_id=p_trip_id;
857:
858: IF (SQL%NOTFOUND) THEN
859: RAISE no_data_found;

Line 882: UPDATE FTE_TRIPS SET validation_required='Y'

878:
879: --2.origin of 1st segment=dest. of next segment
880: if ((l_count>1) AND (l_segment_dest<>l_segment_origin)) then
881: wsh_debug_sv.dlog (c_debug,'origin of 1st segment!=dest. of next segment');
882: UPDATE FTE_TRIPS SET validation_required='Y'
883: where fte_trip_id=p_trip_id;
884: IF (SQL%NOTFOUND) THEN
885: RAISE no_data_found;
886: END IF;

Line 920: UPDATE FTE_TRIPS SET validation_required='Y'

916: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
917: wsh_debug_sv.dlog (c_debug,'could not get last stop location');
918: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
919:
920: UPDATE FTE_TRIPS SET validation_required='Y'
921: where fte_trip_id=p_trip_id;
922: IF (SQL%NOTFOUND) THEN
923: RAISE no_data_found;
924: END IF;

Line 936: UPDATE FTE_TRIPS SET validation_required='N'

932: END LOOP;
933:
934: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
935: wsh_debug_sv.dlog (c_debug,'validation success');
936: UPDATE FTE_TRIPS SET validation_required='N'
937: where fte_trip_id=p_trip_id;
938: IF (SQL%NOTFOUND) THEN
939: RAISE no_data_found;
940: END IF;

Line 964: wsh_util_core.default_handler('FTE_TRIPS_PVT.VALIDATE_DELETETRIP');

960: p_count => x_msg_count
961: ,p_data => x_msg_data
962: );
963: WHEN others THEN
964: wsh_util_core.default_handler('FTE_TRIPS_PVT.VALIDATE_DELETETRIP');
965: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
966: wsh_debug_sv.dpop (c_sdebug);
967: wsh_debug_sv.stop_debug;
968: -- Get message count and data

Line 989: FROM fte_trips

985:
986: CURSOR get_trip_cur
987: IS
988: SELECT name
989: FROM fte_trips
990: WHERE fte_trip_id = p_trip_id;
991:
992: BEGIN
993:

Line 1012: wsh_util_core.default_handler('FTE_TRIPS_PVT.GET_TRIP_NAME');

1008: x_trip_name := l_trip_name;
1009:
1010: EXCEPTION
1011: WHEN OTHERS THEN
1012: wsh_util_core.default_handler('FTE_TRIPS_PVT.GET_TRIP_NAME');
1013: FND_MESSAGE.SET_NAME('FTE','FTE_GET_TRIP_NAME_ERROR');
1014: FND_MESSAGE.SET_TOKEN('TRIP_ID',p_trip_id);
1015: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1016: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 1088: wsh_util_core.default_handler('FTE_TRIPS_PVT.assign_deliveries_to_ftetrip');

1084: p_count => x_msg_count
1085: ,p_data => x_msg_data
1086: );
1087: WHEN others THEN
1088: wsh_util_core.default_handler('FTE_TRIPS_PVT.assign_deliveries_to_ftetrip');
1089: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1090: FND_MSG_PUB.Count_And_Get
1091: ( p_encoded => FND_API.G_FALSE,
1092: p_count => x_msg_count

Line 1211: wsh_util_core.default_handler('FTE_TRIPS_PVT.GET_LAST_STOP_LOCATION_INFO');

1207:
1208: EXCEPTION
1209: --{
1210: WHEN OTHERS THEN
1211: wsh_util_core.default_handler('FTE_TRIPS_PVT.GET_LAST_STOP_LOCATION_INFO');
1212: FND_MESSAGE.SET_NAME('FTE','FTE_GET_LAST_STOP_ERROR');
1213: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_NAME',x_trip_segment_name);
1214: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1215: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 1297: wsh_util_core.default_handler('FTE_TRIPS_PVT.GET_FIRST_STOP_LOCATION_INFO');

1293:
1294: EXCEPTION
1295: --{
1296: WHEN OTHERS THEN
1297: wsh_util_core.default_handler('FTE_TRIPS_PVT.GET_FIRST_STOP_LOCATION_INFO');
1298: FND_MESSAGE.SET_NAME('FTE','FTE_GET_FIRST_STOP_ERROR');
1299: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_NAME',x_trip_segment_name);
1300: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1301: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 1348: wsh_util_core.default_handler('FTE_TRIPS_PVT.GET_TRIP_SEGMENT_NAME');

1344: --}
1345: EXCEPTION
1346: --{
1347: WHEN OTHERS THEN
1348: wsh_util_core.default_handler('FTE_TRIPS_PVT.GET_TRIP_SEGMENT_NAME');
1349: FND_MESSAGE.SET_NAME('FTE','FTE_GET_TRIP_SEG_NAME_ERROR');
1350: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_ID',p_trip_segment_id);
1351: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1352: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 1578: wsh_util_core.default_handler('FTE_TRIPS_PVT.GET_SHIPMENT_INFORMATION');

1574: p_encoded => FND_API.G_FALSE
1575: );
1576: WHEN OTHERS THEN
1577: ROLLBACK TO GET_SHIPMENT_INFORMATION_PUB;
1578: wsh_util_core.default_handler('FTE_TRIPS_PVT.GET_SHIPMENT_INFORMATION');
1579: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1580: FND_MSG_PUB.Count_And_Get
1581: (
1582: p_count => x_msg_count,

Line 1748: wsh_util_core.default_handler('FTE_TRIPS_PVT.GET_TRIP_INFO_FROM_DLVY');

1744: p_encoded => FND_API.G_FALSE
1745: );
1746: WHEN OTHERS THEN
1747: ROLLBACK TO GET_TRIP_INFO_FROM_DLVY_PUB;
1748: wsh_util_core.default_handler('FTE_TRIPS_PVT.GET_TRIP_INFO_FROM_DLVY');
1749: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1750: FND_MSG_PUB.Count_And_Get
1751: (
1752: p_count => x_msg_count,

Line 1764: END FTE_TRIPS_PVT;

1760:
1761: --
1762: --
1763: --
1764: END FTE_TRIPS_PVT;