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 FTE_CARRIER_RANK_LIST

Line 1: PACKAGE BODY FTE_CARRIER_RANK_LIST_PVT AS

1: PACKAGE BODY FTE_CARRIER_RANK_LIST_PVT AS
2: /* $Header: FTECLTHB.pls 120.7 2005/08/05 16:05:30 hbhagava noship $ */
3:
4: --===================
5: -- CONSTANTS

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

3:
4: --===================
5: -- CONSTANTS
6: --===================
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'FTE_CARRIER_RANK_LIST_PVT';
8:
9:
10:
11:

Line 37: UPDATE FTE_CARRIER_RANK_LIST SET

33:
34: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
35:
36:
37: UPDATE FTE_CARRIER_RANK_LIST SET
38: CARRIER_ID = decode(p_rank_info_rec.CARRIER_ID,NULL,CARRIER_ID,
39: FND_API.G_MISS_NUM,NULL,
40: p_rank_info_rec.CARRIER_ID),
41: SERVICE_LEVEL =decode(p_rank_info_rec.SERVICE_LEVEL,NULL,SERVICE_LEVEL,

Line 149: wsh_util_core.default_handler('FTE_CARRIER_RANK_LIST_PVT.UPDATE');

145: FND_MESSAGE.SET_NAME('FTE','FTE_RANK_NOT_FOUND');
146: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
147: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
148: WHEN others THEN
149: wsh_util_core.default_handler('FTE_CARRIER_RANK_LIST_PVT.UPDATE');
150: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
151:
152: END UPDATE_RANK;
153:

Line 192: SELECT trip_id INTO l_trip_id FROM FTE_CARRIER_RANK_LIST

188: --}
189:
190:
191: CURSOR get_trip IS
192: SELECT trip_id INTO l_trip_id FROM FTE_CARRIER_RANK_LIST
193: WHERE TRIP_ID = p_trip_id
194: AND ROWNUM = 1;
195:
196:

Line 313: WSH_UTIL_CORE.DEFAULT_HANDLER('FTE_CARRIER_RANK_LIST_PVT.SET_RANK_CURRENT');

309: END IF;
310:
311: WHEN OTHERS THEN
312: ROLLBACK TO SET_RANK_CURRENT_PUB;
313: WSH_UTIL_CORE.DEFAULT_HANDLER('FTE_CARRIER_RANK_LIST_PVT.SET_RANK_CURRENT');
314: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
315: IF l_debug_on THEN
316: WSH_DEBUG_SV.pop(l_module_name);
317: END IF;

Line 407: DELETE FROM fte_carrier_rank_list

403:
404:
405: BEGIN
406:
407: DELETE FROM fte_carrier_rank_list
408: WHERE trip_id = p_trip_id;
409:
410:
411: IF (SQL%NOTFOUND) THEN

Line 506: wsh_util_core.default_handler('FTE_CARRIER_RANK_LIST_PVT.DELETE_RANK_LIST');

502: IF l_debug_on THEN
503: WSH_DEBUG_SV.pop(l_module_name);
504: END IF;
505: WHEN others THEN
506: wsh_util_core.default_handler('FTE_CARRIER_RANK_LIST_PVT.DELETE_RANK_LIST');
507: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
508: IF l_debug_on THEN
509: WSH_DEBUG_SV.pop(l_module_name);
510: END IF;

Line 528: SELECT fte_carrier_rank_list_s.nextval

524: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || l_api_name;
525:
526:
527: CURSOR get_next_rank_id IS
528: SELECT fte_carrier_rank_list_s.nextval
529: FROM sys.dual;
530:
531: l_temp_id NUMBER;
532: EMPTY_TRIP_ID EXCEPTION;

Line 614: insert into FTE_CARRIER_RANK_LIST

610: Log(l_module_name,' p_rank_info_rec.CALL_RG_FLAG ' || p_rank_info_rec.CALL_RG_FLAG,WSH_DEBUG_SV.C_PROC_LEVEL);
611: END IF;
612:
613:
614: insert into FTE_CARRIER_RANK_LIST
615: (
616: RANK_ID ,
617: TRIP_ID ,
618: RANK_SEQUENCE ,

Line 721: wsh_util_core.default_handler('FTE_CARRIER_RANK_LIST_PVT.CREATE');

717: FND_MESSAGE.SET_NAME('FTE', 'FTE_RANK_SEQUENCE_MISSING');
718: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
719: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
720: WHEN others THEN
721: wsh_util_core.default_handler('FTE_CARRIER_RANK_LIST_PVT.CREATE');
722: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
723: END CREATE_RANK;
724:
725:

Line 764: SELECT trip_id INTO l_trip_id FROM FTE_CARRIER_RANK_LIST

760: --}
761:
762:
763: CURSOR get_trip IS
764: SELECT trip_id INTO l_trip_id FROM FTE_CARRIER_RANK_LIST
765: WHERE TRIP_ID = p_trip_id
766: AND ROWNUM = 1;
767:
768:

Line 927: WSH_UTIL_CORE.DEFAULT_HANDLER('FTE_CARRIER_RANK_LIST_PVT.CREATE_RANK_LIST');

923: END IF;
924:
925: WHEN OTHERS THEN
926: ROLLBACK TO CREATE_RANK_LIST_PUB;
927: WSH_UTIL_CORE.DEFAULT_HANDLER('FTE_CARRIER_RANK_LIST_PVT.CREATE_RANK_LIST');
928: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
929: IF l_debug_on THEN
930: WSH_DEBUG_SV.pop(l_module_name);
931: END IF;

Line 964: SELECT trip_id INTO l_trip_id FROM FTE_CARRIER_RANK_LIST

960: l_trip_id NUMBER;
961: l_trip_name VARCHAR2(32767);
962:
963: CURSOR get_trip IS
964: SELECT trip_id INTO l_trip_id FROM FTE_CARRIER_RANK_LIST
965: WHERE TRIP_ID = p_trip_id
966: AND ROWNUM = 1;
967:
968:

Line 1057: WSH_UTIL_CORE.DEFAULT_HANDLER('FTE_CARRIER_RANK_LIST_PVT.UPDATE_RANK_LIST');

1053: END IF;
1054:
1055: WHEN OTHERS THEN
1056: ROLLBACK TO UPDATE_RANK_LIST_PUB;
1057: WSH_UTIL_CORE.DEFAULT_HANDLER('FTE_CARRIER_RANK_LIST_PVT.UPDATE_RANK_LIST');
1058: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1059: IF l_debug_on THEN
1060: WSH_DEBUG_SV.pop(l_module_name);
1061: END IF;

Line 1101: FROM FTE_CARRIER_RANK_LIST

1097:
1098:
1099: CURSOR get_max_seq IS
1100: SELECT MAX(RANK_SEQUENCE)
1101: FROM FTE_CARRIER_RANK_LIST
1102: WHERE TRIP_ID = p_trip_id;
1103:
1104:
1105: BEGIN

Line 1126: FROM FTE_CARRIER_RANK_LIST

1122: WSH_DEBUG_SV.C_PROC_LEVEL);
1123: END IF;
1124:
1125: SELECT MAX(RANK_SEQUENCE) INTO l_max_rank_seq
1126: FROM FTE_CARRIER_RANK_LIST
1127: WHERE TRIP_ID = p_trip_id;
1128:
1129: IF (l_max_rank_seq IS NULL) THEN
1130: FND_MESSAGE.SET_NAME('FTE','FTE_TRIP_LIST_NOTEXISTS');

Line 1268: WSH_UTIL_CORE.DEFAULT_HANDLER('FTE_CARRIER_RANK_LIST_PVT.APPEND_RANK_LIST');

1264: END IF;
1265:
1266: WHEN OTHERS THEN
1267: ROLLBACK TO APPEND_RANK_LIST_PUB;
1268: WSH_UTIL_CORE.DEFAULT_HANDLER('FTE_CARRIER_RANK_LIST_PVT.APPEND_RANK_LIST');
1269: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1270: IF l_debug_on THEN
1271: WSH_DEBUG_SV.pop(l_module_name);
1272: END IF;

Line 1409: FROM FTE_CARRIER_RANK_LIST

1405: BEGIN
1406:
1407:
1408: SELECT VERSION INTO l_current_version
1409: FROM FTE_CARRIER_RANK_LIST
1410: WHERE RANK_ID = p_rank_id;
1411:
1412: IF (SQL%NOTFOUND) THEN
1413: RAISE NO_DATA_FOUND;

Line 1526: SELECT count(*) INTO l_temp_id FROM FTE_CARRIER_RANK_LIST

1522: Log(l_module_name,' Replace existing rank list. Calling Delete first ' || p_trip_id,
1523: WSH_DEBUG_SV.C_PROC_LEVEL);
1524: END IF;
1525:
1526: SELECT count(*) INTO l_temp_id FROM FTE_CARRIER_RANK_LIST
1527: WHERE TRIP_ID = p_trip_id and rownum = 1;
1528:
1529: IF (l_temp_id > 0) THEN
1530:

Line 1658: wsh_util_core.default_handler('FTE_CARRIER_RANK_LIST_PVT.RANK_LIST_ACTION');

1654: );
1655:
1656: WHEN OTHERS THEN
1657: ROLLBACK TO RANK_LIST_ACTION_PUB;
1658: wsh_util_core.default_handler('FTE_CARRIER_RANK_LIST_PVT.RANK_LIST_ACTION');
1659: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1660: FND_MSG_PUB.Count_And_Get
1661: (
1662: p_count => x_msg_count,

Line 1895: wsh_util_core.default_handler('FTE_CARRIER_RANK_LIST_PVT.RANK_LIST_ACTION_UIWRAPPER_PUB');

1891: );
1892:
1893: WHEN OTHERS THEN
1894: ROLLBACK TO RANK_LIST_ACTION_UIWRAPPER_PUB;
1895: wsh_util_core.default_handler('FTE_CARRIER_RANK_LIST_PVT.RANK_LIST_ACTION_UIWRAPPER_PUB');
1896: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1897: FND_MSG_PUB.Count_And_Get
1898: (
1899: p_count => x_msg_count,

Line 1979: FROM FTE_CARRIER_RANK_LIST WHERE RANK_ID = p_rank_id;

1975: LAST_UPDATED_BY ,
1976: LAST_UPDATE_LOGIN ,
1977: 'N',0,'SORT',NULL,NULL,-99,VEHICLE_ORG_ID,
1978: CALL_RG_FLAG
1979: FROM FTE_CARRIER_RANK_LIST WHERE RANK_ID = p_rank_id;
1980:
1981: BEGIN
1982:
1983:

Line 2044: wsh_util_core.default_handler('FTE_CARRIER_RANK_LIST_PVT.GET_RANK_DETAILS');

2040: );
2041:
2042: WHEN OTHERS THEN
2043: ROLLBACK TO GET_RANK_DETAILS_PUB;
2044: wsh_util_core.default_handler('FTE_CARRIER_RANK_LIST_PVT.GET_RANK_DETAILS');
2045: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2046: FND_MSG_PUB.Count_And_Get
2047: (
2048: p_count => x_msg_count,

Line 2130: FROM FTE_CARRIER_RANK_LIST WHERE trip_id = p_trip_id

2126: LAST_UPDATE_LOGIN ,
2127: 'N' IS_CURRENT,NULL SINGLE_CURR_RATE,NULL SORT,NULL SCHEDULE_FROM,NULL SCHEDULE_TO,NULL SCHEDULE_ID,
2128: VEHICLE_ORG_ID,
2129: CALL_RG_FLAG
2130: FROM FTE_CARRIER_RANK_LIST WHERE trip_id = p_trip_id
2131: ORDER BY RANK_ID, RANK_SEQUENCE;
2132:
2133: idx NUMBER;
2134: BEGIN

Line 2259: wsh_util_core.default_handler('FTE_CARRIER_RANK_LIST_PVT.GET_RANK_LIST');

2255: );
2256:
2257: WHEN OTHERS THEN
2258: ROLLBACK TO GET_RANK_LIST_PUB;
2259: wsh_util_core.default_handler('FTE_CARRIER_RANK_LIST_PVT.GET_RANK_LIST');
2260: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2261: FND_MSG_PUB.Count_And_Get
2262: (
2263: p_count => x_msg_count,

Line 2295: x_list_tbl FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;

2291: l_number_of_warnings NUMBER;
2292: l_number_of_errors NUMBER;
2293:
2294: l_rank_rec carrier_rank_list_rec;
2295: x_list_tbl FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;
2296: l_list_tbl FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;
2297:
2298: l_current_rank_sequence NUMBER;
2299:

Line 2296: l_list_tbl FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;

2292: l_number_of_errors NUMBER;
2293:
2294: l_rank_rec carrier_rank_list_rec;
2295: x_list_tbl FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;
2296: l_list_tbl FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;
2297:
2298: l_current_rank_sequence NUMBER;
2299:
2300: l_list_exhausted VARCHAR2(32767);

Line 2354: FROM FTE_CARRIER_RANK_LIST rank_list

2350: LAST_UPDATED_BY ,
2351: LAST_UPDATE_LOGIN ,
2352: 'N' IS_CURRENT,NULL SINGLE_CURR_RATE,NULL SORT,NULL SCHEDULE_FROM,NULL SCHEDULE_TO,NULL SCHEDULE_ID,
2353: VEHICLE_ORG_ID,CALL_RG_FLAG
2354: FROM FTE_CARRIER_RANK_LIST rank_list
2355: WHERE rank_list.trip_id = p_trip_id
2356: AND rank_list.RANK_SEQUENCE = (p_current_sequence+1);
2357:
2358: BEGIN

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 2647: p_action_code => FTE_CARRIER_RANK_LIST_PVT.S_SET_CURRENT,

2643: p_init_msg_list => FND_API.G_FALSE,
2644: x_return_status => l_return_status,
2645: x_msg_count => l_msg_count,
2646: x_msg_data => l_msg_data,
2647: p_action_code => FTE_CARRIER_RANK_LIST_PVT.S_SET_CURRENT,
2648: p_ranklist => l_list_tbl,
2649: p_trip_id => p_trip_id,
2650: p_rank_id => l_rank_rec.RANK_ID);
2651:

Line 2655: Log(l_module_name,' Result FTE_CARRIER_RANK_LIST_PVT.RANK_LIST_ACTION ' ||

2651:
2652:
2653: IF l_debug_on
2654: THEN
2655: Log(l_module_name,' Result FTE_CARRIER_RANK_LIST_PVT.RANK_LIST_ACTION ' ||
2656: l_return_status,
2657: WSH_DEBUG_SV.C_PROC_LEVEL);
2658: END IF;
2659:

Line 2793: SELECT COUNT(*) INTO l_count FROM FTE_CARRIER_RANK_LIST

2789:
2790: BEGIN
2791:
2792:
2793: SELECT COUNT(*) INTO l_count FROM FTE_CARRIER_RANK_LIST
2794: WHERE (VERSION IS NULL OR VERSION = 0)
2795: AND trip_id = p_trip_id;
2796:
2797: IF (SQL%NOTFOUND) THEN

Line 2961: FROM FTE_CARRIER_RANK_LIST WHERE trip_id = p_trip_id

2957: LAST_UPDATE_DATE ,
2958: LAST_UPDATED_BY ,
2959: LAST_UPDATE_LOGIN ,
2960: 'N'
2961: FROM FTE_CARRIER_RANK_LIST WHERE trip_id = p_trip_id
2962: ORDER BY RANK_ID , RANK_SEQUENCE;
2963:
2964: idx NUMBER;
2965:

Line 3043: wsh_util_core.default_handler('FTE_CARRIER_RANK_LIST_PVT.PRINT_RANK_LIST');

3039: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3040: ROLLBACK TO PRINT_RANK_LIST_PUB;
3041: WHEN OTHERS THEN
3042: ROLLBACK TO PRINT_RANK_LIST_PUB;
3043: wsh_util_core.default_handler('FTE_CARRIER_RANK_LIST_PVT.PRINT_RANK_LIST');
3044: END PRINT_RANK_LIST;
3045:
3046:
3047: --{

Line 3220: wsh_util_core.default_handler('FTE_CARRIER_RANK_LIST_PVT.DELETE_RANK_LIST_UIWRAPPER');

3216: p_encoded => FND_API.G_FALSE
3217: );
3218: WHEN OTHERS THEN
3219: ROLLBACK TO DELETE_RANK_LIST_UIWRAPPER_PUB;
3220: wsh_util_core.default_handler('FTE_CARRIER_RANK_LIST_PVT.DELETE_RANK_LIST_UIWRAPPER');
3221: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3222: FND_MSG_PUB.Count_And_Get
3223: (
3224: p_count => x_msg_count,

Line 3263: SELECT trip_id FROM FTE_CARRIER_RANK_LIST

3259:
3260: l_temp_table carrier_rank_list_bulk_rec;
3261:
3262: CURSOR get_trip (trip_id NUMBER) IS
3263: SELECT trip_id FROM FTE_CARRIER_RANK_LIST
3264: WHERE TRIP_ID = trip_id
3265: AND ROWNUM = 1;
3266:
3267: idx NUMBER;

Line 3302: FROM FTE_CARRIER_RANK_LIST

3298:
3299: BEGIN
3300:
3301: SELECT trip_id INTO l_trip_id
3302: FROM FTE_CARRIER_RANK_LIST
3303: WHERE TRIP_ID = p_ranklist.TRIP_ID(i)
3304: AND ROWNUM = 1;
3305:
3306: IF (SQL%NOTFOUND) THEN

Line 3323: SELECT FTE_CARRIER_RANK_LIST_S.NEXTVAL INTO

3319:
3320: EXCEPTION
3321: WHEN NO_DATA_FOUND THEN
3322:
3323: SELECT FTE_CARRIER_RANK_LIST_S.NEXTVAL INTO
3324: p_ranklist.RANK_ID(i) FROM DUAL;
3325:
3326: IF l_debug_on
3327: THEN

Line 3381: insert into FTE_CARRIER_RANK_LIST

3377:
3378: IF (l_temp_table.RANK_ID.COUNT > 0)
3379: THEN
3380: FORALL i IN l_temp_table.RANK_ID.FIRST..l_temp_table.RANK_ID.LAST
3381: insert into FTE_CARRIER_RANK_LIST
3382: ( RANK_ID ,
3383: TRIP_ID ,
3384: RANK_SEQUENCE ,
3385: CARRIER_ID ,

Line 3522: wsh_util_core.default_handler('FTE_CARRIER_RANK_LIST_PVT.CREATE_RANK_LIST_BULK');

3518: p_encoded => FND_API.G_FALSE
3519: );
3520: WHEN OTHERS THEN
3521: ROLLBACK TO CREATE_RANK_LIST_BULK_PUB;
3522: wsh_util_core.default_handler('FTE_CARRIER_RANK_LIST_PVT.CREATE_RANK_LIST_BULK');
3523: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3524: FND_MSG_PUB.Count_And_Get
3525: (
3526: p_count => x_msg_count,

Line 3539: END FTE_CARRIER_RANK_LIST_PVT;

3535: --}
3536:
3537:
3538: --
3539: END FTE_CARRIER_RANK_LIST_PVT;