[Home] [Help]
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
3:
4: --===================
5: -- CONSTANTS
6: --===================
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'FTE_CARRIER_RANK_LIST_PVT';
8:
9:
10:
11:
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:
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;
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;
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:
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;
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;
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;
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,
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,
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,
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,
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:
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);
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:
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:
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: --{
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,
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,
3535: --}
3536:
3537:
3538: --
3539: END FTE_CARRIER_RANK_LIST_PVT;