DBA Data[Home] [Help]

APPS.FTE_TRIPS_PVT dependencies on FTE_TRIPS_PVT

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 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 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 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 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 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 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 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;