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_CARRIER_RANK_LIST_PVT dependencies on WSH_TRIPS

Line 184: p_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;

180:
181: l_trip_name VARCHAR2(32767);
182:
183: --{Trip update parameters
184: p_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
185: p_trip_info WSH_TRIPS_PVT.Trip_Rec_Type;
186: p_trip_in_rec WSH_TRIPS_GRP.TripInRecType;
187: x_out_tab WSH_TRIPS_GRP.trip_Out_tab_type;
188: --}

Line 185: p_trip_info WSH_TRIPS_PVT.Trip_Rec_Type;

181: l_trip_name VARCHAR2(32767);
182:
183: --{Trip update parameters
184: p_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
185: p_trip_info WSH_TRIPS_PVT.Trip_Rec_Type;
186: p_trip_in_rec WSH_TRIPS_GRP.TripInRecType;
187: x_out_tab WSH_TRIPS_GRP.trip_Out_tab_type;
188: --}
189:

Line 186: p_trip_in_rec WSH_TRIPS_GRP.TripInRecType;

182:
183: --{Trip update parameters
184: p_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
185: p_trip_info WSH_TRIPS_PVT.Trip_Rec_Type;
186: p_trip_in_rec WSH_TRIPS_GRP.TripInRecType;
187: x_out_tab WSH_TRIPS_GRP.trip_Out_tab_type;
188: --}
189:
190:

Line 187: x_out_tab WSH_TRIPS_GRP.trip_Out_tab_type;

183: --{Trip update parameters
184: p_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
185: p_trip_info WSH_TRIPS_PVT.Trip_Rec_Type;
186: p_trip_in_rec WSH_TRIPS_GRP.TripInRecType;
187: x_out_tab WSH_TRIPS_GRP.trip_Out_tab_type;
188: --}
189:
190:
191: CURSOR get_trip IS

Line 345: p_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;

341: l_number_of_warnings NUMBER;
342: l_number_of_errors NUMBER;
343:
344: --{Trip update parameters
345: p_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
346: p_trip_info WSH_TRIPS_PVT.Trip_Rec_Type;
347: p_trip_in_rec WSH_TRIPS_GRP.TripInRecType;
348: x_out_tab WSH_TRIPS_GRP.trip_Out_tab_type;
349: --}

Line 346: p_trip_info WSH_TRIPS_PVT.Trip_Rec_Type;

342: l_number_of_errors NUMBER;
343:
344: --{Trip update parameters
345: p_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
346: p_trip_info WSH_TRIPS_PVT.Trip_Rec_Type;
347: p_trip_in_rec WSH_TRIPS_GRP.TripInRecType;
348: x_out_tab WSH_TRIPS_GRP.trip_Out_tab_type;
349: --}
350:

Line 347: p_trip_in_rec WSH_TRIPS_GRP.TripInRecType;

343:
344: --{Trip update parameters
345: p_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
346: p_trip_info WSH_TRIPS_PVT.Trip_Rec_Type;
347: p_trip_in_rec WSH_TRIPS_GRP.TripInRecType;
348: x_out_tab WSH_TRIPS_GRP.trip_Out_tab_type;
349: --}
350:
351:

Line 348: x_out_tab WSH_TRIPS_GRP.trip_Out_tab_type;

344: --{Trip update parameters
345: p_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
346: p_trip_info WSH_TRIPS_PVT.Trip_Rec_Type;
347: p_trip_in_rec WSH_TRIPS_GRP.TripInRecType;
348: x_out_tab WSH_TRIPS_GRP.trip_Out_tab_type;
349: --}
350:
351:
352: CURSOR GET_TENDER_STATUS IS

Line 353: SELECT LOAD_TENDER_STATUS FROM WSH_TRIPS

349: --}
350:
351:
352: CURSOR GET_TENDER_STATUS IS
353: SELECT LOAD_TENDER_STATUS FROM WSH_TRIPS
354: WHERE TRIP_ID = p_trip_id;
355:
356: BEGIN
357:

Line 416: SELECT NAME INTO l_trip_name FROM WSH_TRIPS WHERE TRIP_ID = p_trip_id;

412: RAISE NO_DATA_FOUND;
413: END IF;
414: EXCEPTION
415: WHEN no_data_found THEN
416: SELECT NAME INTO l_trip_name FROM WSH_TRIPS WHERE TRIP_ID = p_trip_id;
417: FND_MESSAGE.SET_NAME('FTE','FTE_RANK_TRIP_NOT_FOUND');
418: FND_MESSAGE.SET_TOKEN('TRIP_NAME', l_trip_name);
419: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
420: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

Line 756: p_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;

752:
753: l_trip_name VARCHAR2(32767);
754:
755: --{Trip update parameters
756: p_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
757: p_trip_info WSH_TRIPS_PVT.Trip_Rec_Type;
758: p_trip_in_rec WSH_TRIPS_GRP.TripInRecType;
759: x_out_tab WSH_TRIPS_GRP.trip_Out_tab_type;
760: --}

Line 757: p_trip_info WSH_TRIPS_PVT.Trip_Rec_Type;

753: l_trip_name VARCHAR2(32767);
754:
755: --{Trip update parameters
756: p_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
757: p_trip_info WSH_TRIPS_PVT.Trip_Rec_Type;
758: p_trip_in_rec WSH_TRIPS_GRP.TripInRecType;
759: x_out_tab WSH_TRIPS_GRP.trip_Out_tab_type;
760: --}
761:

Line 758: p_trip_in_rec WSH_TRIPS_GRP.TripInRecType;

754:
755: --{Trip update parameters
756: p_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
757: p_trip_info WSH_TRIPS_PVT.Trip_Rec_Type;
758: p_trip_in_rec WSH_TRIPS_GRP.TripInRecType;
759: x_out_tab WSH_TRIPS_GRP.trip_Out_tab_type;
760: --}
761:
762:

Line 759: x_out_tab WSH_TRIPS_GRP.trip_Out_tab_type;

755: --{Trip update parameters
756: p_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
757: p_trip_info WSH_TRIPS_PVT.Trip_Rec_Type;
758: p_trip_in_rec WSH_TRIPS_GRP.TripInRecType;
759: x_out_tab WSH_TRIPS_GRP.trip_Out_tab_type;
760: --}
761:
762:
763: CURSOR get_trip IS

Line 796: SELECT NAME INTO l_trip_name FROM WSH_TRIPS WHERE TRIP_ID = p_trip_id;

792: CLOSE get_trip;
793: ELSE
794: CLOSE get_trip;
795:
796: SELECT NAME INTO l_trip_name FROM WSH_TRIPS WHERE TRIP_ID = p_trip_id;
797:
798: FND_MESSAGE.SET_NAME('FTE','FTE_TRIP_LIST_EXISTS');
799: FND_MESSAGE.SET_TOKEN('TRIP_NAME',l_trip_name);
800: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);

Line 842: SELECT NAME INTO l_trip_name FROM WSH_TRIPS WHERE TRIP_ID = p_trip_id;

838:
839: IF (p_ranklist(i).IS_CURRENT = 'Y') THEN
840:
841: IF (l_currentSet = FND_API.G_TRUE) THEN
842: SELECT NAME INTO l_trip_name FROM WSH_TRIPS WHERE TRIP_ID = p_trip_id;
843:
844: FND_MESSAGE.SET_NAME('FTE','FTE_CANNOT_SET_MORE_CURR');
845: FND_MESSAGE.SET_TOKEN('TRIP_NAME',l_trip_name);
846: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);

Line 994: SELECT NAME INTO l_trip_name FROM WSH_TRIPS WHERE TRIP_ID = p_trip_id;

990:
991: IF (get_trip%NOTFOUND) THEN
992: CLOSE get_trip;
993:
994: SELECT NAME INTO l_trip_name FROM WSH_TRIPS WHERE TRIP_ID = p_trip_id;
995:
996: FND_MESSAGE.SET_NAME('FTE','FTE_TRIP_LIST_NOTEXISTS');
997: FND_MESSAGE.SET_TOKEN('TRIP_NAME',l_trip_name);
998: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);

Line 1177: SELECT NAME INTO l_trip_name FROM WSH_TRIPS WHERE TRIP_ID = p_trip_id;

1173:
1174: IF (p_ranklist(i).IS_CURRENT = 'Y') THEN
1175:
1176: IF (l_currentSet = FND_API.G_TRUE) THEN
1177: SELECT NAME INTO l_trip_name FROM WSH_TRIPS WHERE TRIP_ID = p_trip_id;
1178:
1179: FND_MESSAGE.SET_NAME('FTE','FTE_CANNOT_SET_MORE_CURR');
1180: FND_MESSAGE.SET_TOKEN('TRIP_NAME',l_trip_name);
1181: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);

Line 1312: p_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;

1308: l_current_version NUMBER;
1309: l_temp_id NUMBER;
1310:
1311: --{Trip update parameters
1312: p_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
1313: p_trip_info WSH_TRIPS_PVT.Trip_Rec_Type;
1314: p_trip_in_rec WSH_TRIPS_GRP.TripInRecType;
1315: x_out_tab WSH_TRIPS_GRP.trip_Out_tab_type;
1316: --}

Line 1313: p_trip_info WSH_TRIPS_PVT.Trip_Rec_Type;

1309: l_temp_id NUMBER;
1310:
1311: --{Trip update parameters
1312: p_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
1313: p_trip_info WSH_TRIPS_PVT.Trip_Rec_Type;
1314: p_trip_in_rec WSH_TRIPS_GRP.TripInRecType;
1315: x_out_tab WSH_TRIPS_GRP.trip_Out_tab_type;
1316: --}
1317:

Line 1314: p_trip_in_rec WSH_TRIPS_GRP.TripInRecType;

1310:
1311: --{Trip update parameters
1312: p_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
1313: p_trip_info WSH_TRIPS_PVT.Trip_Rec_Type;
1314: p_trip_in_rec WSH_TRIPS_GRP.TripInRecType;
1315: x_out_tab WSH_TRIPS_GRP.trip_Out_tab_type;
1316: --}
1317:
1318:

Line 1315: x_out_tab WSH_TRIPS_GRP.trip_Out_tab_type;

1311: --{Trip update parameters
1312: p_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
1313: p_trip_info WSH_TRIPS_PVT.Trip_Rec_Type;
1314: p_trip_in_rec WSH_TRIPS_GRP.TripInRecType;
1315: x_out_tab WSH_TRIPS_GRP.trip_Out_tab_type;
1316: --}
1317:
1318:
1319: BEGIN

Line 1582: FROM WSH_TRIPS

1578: WSH_DEBUG_SV.C_PROC_LEVEL);
1579: END IF;
1580:
1581: SELECT RANK_ID INTO l_temp_id
1582: FROM WSH_TRIPS
1583: where TRIP_ID = p_trip_id;
1584:
1585: IF l_debug_on
1586: THEN

Line 2301: l_trip_name WSH_TRIPS.NAME%TYPE;

2297:
2298: l_current_rank_sequence NUMBER;
2299:
2300: l_list_exhausted VARCHAR2(32767);
2301: l_trip_name WSH_TRIPS.NAME%TYPE;
2302:
2303: --{Trip update parameters
2304: p_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
2305: p_trip_info WSH_TRIPS_PVT.Trip_Rec_Type;

Line 2304: p_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;

2300: l_list_exhausted VARCHAR2(32767);
2301: l_trip_name WSH_TRIPS.NAME%TYPE;
2302:
2303: --{Trip update parameters
2304: p_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
2305: p_trip_info WSH_TRIPS_PVT.Trip_Rec_Type;
2306: p_trip_in_rec WSH_TRIPS_GRP.TripInRecType;
2307: x_out_tab WSH_TRIPS_GRP.trip_Out_tab_type;
2308: --}

Line 2305: p_trip_info WSH_TRIPS_PVT.Trip_Rec_Type;

2301: l_trip_name WSH_TRIPS.NAME%TYPE;
2302:
2303: --{Trip update parameters
2304: p_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
2305: p_trip_info WSH_TRIPS_PVT.Trip_Rec_Type;
2306: p_trip_in_rec WSH_TRIPS_GRP.TripInRecType;
2307: x_out_tab WSH_TRIPS_GRP.trip_Out_tab_type;
2308: --}
2309:

Line 2306: p_trip_in_rec WSH_TRIPS_GRP.TripInRecType;

2302:
2303: --{Trip update parameters
2304: p_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
2305: p_trip_info WSH_TRIPS_PVT.Trip_Rec_Type;
2306: p_trip_in_rec WSH_TRIPS_GRP.TripInRecType;
2307: x_out_tab WSH_TRIPS_GRP.trip_Out_tab_type;
2308: --}
2309:
2310:

Line 2307: x_out_tab WSH_TRIPS_GRP.trip_Out_tab_type;

2303: --{Trip update parameters
2304: p_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
2305: p_trip_info WSH_TRIPS_PVT.Trip_Rec_Type;
2306: p_trip_in_rec WSH_TRIPS_GRP.TripInRecType;
2307: x_out_tab WSH_TRIPS_GRP.trip_Out_tab_type;
2308: --}
2309:
2310:
2311:

Line 2391: FROM FTE_CARRIER_RANK_LIST rank_list, WSH_TRIPS trips

2387: BEGIN
2388:
2389:
2390: SELECT RANK_SEQUENCE INTO l_current_rank_sequence
2391: FROM FTE_CARRIER_RANK_LIST rank_list, WSH_TRIPS trips
2392: WHERE trips.trip_id = p_trip_id
2393: AND trips.RANK_ID = rank_list.RANK_ID;
2394:
2395: IF (SQL%NOTFOUND) THEN

Line 2427: SELECT NAME INTO l_trip_name from WSH_TRIPS

2423: END IF;
2424:
2425:
2426: IF (get_next_rank%NOTFOUND) THEN
2427: SELECT NAME INTO l_trip_name from WSH_TRIPS
2428: WHERE TRIP_ID = p_trip_id;
2429:
2430: FND_MESSAGE.SET_NAME('FTE','FTE_RANK_LIST_EXAUSTED');
2431: FND_MESSAGE.SET_TOKEN('TRIP_NAME',l_trip_name);

Line 2482: UPDATE WSH_TRIPS

2478: END IF;
2479:
2480: -- Call shipping API to update trip information with next shipmethod
2481: /**
2482: UPDATE WSH_TRIPS
2483: SET CARRIER_ID = l_rank_rec.CARRIER_ID,
2484: SERVICE_LEVEL = l_rank_rec.SERVICE_LEVEL,
2485: MODE_OF_TRANSPORT = l_rank_rec.MODE_OF_TRANSPORT,
2486: VEHICLE_ITEM_ID = l_rank_rec.VEHICLE_ITEM_ID,

Line 3127: SELECT NAME INTO l_temp_name FROM WSH_TRIPS

3123: l_error_tab(l_error_tab.COUNT) := p_trip_id(i);
3124: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3125:
3126: -- Get the trip name
3127: SELECT NAME INTO l_temp_name FROM WSH_TRIPS
3128: WHERE TRIP_ID = p_trip_id(i);
3129:
3130: l_trip_names := l_trip_names || ', ' || l_temp_name;
3131: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING)

Line 3316: SELECT NAME INTO l_trip_name FROM WSH_TRIPS WHERE TRIP_ID = p_ranklist.TRIP_ID(i);

3312: Log(l_module_name,' Rank list exist for trip ' || p_ranklist.TRIP_ID(i),
3313: WSH_DEBUG_SV.C_PROC_LEVEL);
3314: END IF;
3315:
3316: SELECT NAME INTO l_trip_name FROM WSH_TRIPS WHERE TRIP_ID = p_ranklist.TRIP_ID(i);
3317: l_trip_names := l_trip_names || ', ' || l_trip_name;
3318: END IF;
3319:
3320: EXCEPTION

Line 3479: UPDATE WSH_TRIPS

3475:
3476:
3477: FOR i IN l_temp_table.TRIP_ID.FIRST..l_temp_table.TRIP_ID.LAST
3478: LOOP
3479: UPDATE WSH_TRIPS
3480: SET RANK_ID = l_temp_table.RANK_ID(i)
3481: WHERE TRIP_ID = l_temp_table.TRIP_ID(i);
3482:
3483: IF l_debug_on