141: END IF;
142:
143: EXCEPTION
144: WHEN no_data_found THEN
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');
376: IF (GET_TENDER_STATUS%NOTFOUND)
377: THEN
378: CLOSE GET_TENDER_STATUS;
379:
380: FND_MESSAGE.SET_NAME('FTE','FTE_INVALID_TRIP');
381: FND_MESSAGE.SET_TOKEN('TRIP_ID', p_trip_id);
382: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
383: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
384: RAISE FND_API.G_EXC_ERROR;
377: THEN
378: CLOSE GET_TENDER_STATUS;
379:
380: FND_MESSAGE.SET_NAME('FTE','FTE_INVALID_TRIP');
381: FND_MESSAGE.SET_TOKEN('TRIP_ID', p_trip_id);
382: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
383: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
384: RAISE FND_API.G_EXC_ERROR;
385:
391: l_tender_status = FTE_TENDER_PVT.S_ACCEPTED OR
392: l_tender_status = FTE_TENDER_PVT.S_AUTO_ACCEPTED)
393: THEN
394:
395: FND_MESSAGE.SET_NAME('FTE','FTE_CNT_DELETE_TENDER_CHECK');
396: FND_MESSAGE.SET_TOKEN('TENDER_STATUS',
397: WSH_UTIL_CORE.Get_Lookup_Meaning('WSH_TENDER_STATUS',
398: l_tender_status));
399: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
392: l_tender_status = FTE_TENDER_PVT.S_AUTO_ACCEPTED)
393: THEN
394:
395: FND_MESSAGE.SET_NAME('FTE','FTE_CNT_DELETE_TENDER_CHECK');
396: FND_MESSAGE.SET_TOKEN('TENDER_STATUS',
397: WSH_UTIL_CORE.Get_Lookup_Meaning('WSH_TENDER_STATUS',
398: l_tender_status));
399: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
400: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
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);
421: RAISE FND_API.G_EXC_ERROR;
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);
421: RAISE FND_API.G_EXC_ERROR;
422: END;
709:
710:
711: EXCEPTION
712: WHEN EMPTY_TRIP_ID THEN
713: FND_MESSAGE.SET_NAME('FTE', 'FTE_RANK_TRIP_ID_MISSING');
714: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
715: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
716: WHEN EMPTY_RANK_SEQUENCE THEN
717: FND_MESSAGE.SET_NAME('FTE', 'FTE_RANK_SEQUENCE_MISSING');
713: FND_MESSAGE.SET_NAME('FTE', 'FTE_RANK_TRIP_ID_MISSING');
714: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
715: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
716: WHEN EMPTY_RANK_SEQUENCE THEN
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');
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);
801: RAISE FND_API.G_EXC_ERROR;
802: END IF;
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);
801: RAISE FND_API.G_EXC_ERROR;
802: END IF;
803:
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);
847: RAISE FND_API.G_EXC_ERROR;
848: END IF;
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);
847: RAISE FND_API.G_EXC_ERROR;
848: END IF;
849:
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);
999: RAISE FND_API.G_EXC_ERROR;
1000: END IF;
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);
999: RAISE FND_API.G_EXC_ERROR;
1000: END IF;
1001:
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');
1131: FND_MESSAGE.SET_TOKEN('TRIP_ID',p_trip_id);
1132: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1133: RAISE FND_API.G_EXC_ERROR;
1134: END IF;
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');
1131: FND_MESSAGE.SET_TOKEN('TRIP_ID',p_trip_id);
1132: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1133: RAISE FND_API.G_EXC_ERROR;
1134: END IF;
1135:
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);
1182: RAISE FND_API.G_EXC_ERROR;
1183: END IF;
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);
1182: RAISE FND_API.G_EXC_ERROR;
1183: END IF;
1184:
1414: END IF;
1415:
1416: EXCEPTION
1417: WHEN NO_DATA_FOUND THEN
1418: FND_MESSAGE.SET_NAME('FTE','FTE_RANK_NOT_FOUND');
1419: FND_MESSAGE.SET_TOKEN('RANK_ID', p_rank_id);
1420: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1421: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1422: RAISE FND_API.G_EXC_ERROR;
1415:
1416: EXCEPTION
1417: WHEN NO_DATA_FOUND THEN
1418: FND_MESSAGE.SET_NAME('FTE','FTE_RANK_NOT_FOUND');
1419: FND_MESSAGE.SET_TOKEN('RANK_ID', p_rank_id);
1420: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1421: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1422: RAISE FND_API.G_EXC_ERROR;
1423:
1998: OPEN get_rank_details_c;
1999: FETCH get_rank_details_c INTO x_rankdetails;
2000:
2001: IF (get_rank_details_c%NOTFOUND) THEN
2002: FND_MESSAGE.SET_NAME('FTE','FTE_RANK_NOT_FOUND');
2003: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2004: wsh_util_core.add_message(x_return_status);
2005: ELSE
2006: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2397: END IF;
2398:
2399: EXCEPTION
2400: WHEN NO_DATA_FOUND THEN
2401: FND_MESSAGE.SET_NAME('FTE','FTE_RANK_NOT_FOUND');
2402: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2403: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
2404: RAISE FND_API.G_EXC_ERROR;
2405: END;
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);
2432:
2433: l_list_exhausted := 'T';
2434: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
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);
2432:
2433: l_list_exhausted := 'T';
2434: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2435: wsh_util_core.add_message(x_return_status);
2799: END IF;
2800:
2801: EXCEPTION
2802: WHEN NO_DATA_FOUND THEN
2803: FND_MESSAGE.SET_NAME('FTE','FTE_RANK_NOT_FOUND');
2804: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2805: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
2806: RAISE FND_API.G_EXC_ERROR;
2807:
3168:
3169:
3170: IF (l_success_tab.count = p_trip_id.count)
3171: THEN
3172: --FND_MESSAGE.SET_NAME('FTE','FTE_MULTI_RANK_DEL_SUCCESS');
3173: --FND_MSG_PUB.ADD;
3174: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3175: ELSIF (l_error_tab.count = p_trip_id.count)
3176: THEN
3173: --FND_MSG_PUB.ADD;
3174: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3175: ELSIF (l_error_tab.count = p_trip_id.count)
3176: THEN
3177: FND_MESSAGE.SET_NAME('FTE','FTE_MULTI_RANK_DEL_FAIL');
3178: FND_MESSAGE.SET_TOKEN('TRIP_NAMES', l_trip_names);
3179: FND_MSG_PUB.ADD;
3180: RAISE FND_API.G_EXC_ERROR;
3181: ELSE
3174: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3175: ELSIF (l_error_tab.count = p_trip_id.count)
3176: THEN
3177: FND_MESSAGE.SET_NAME('FTE','FTE_MULTI_RANK_DEL_FAIL');
3178: FND_MESSAGE.SET_TOKEN('TRIP_NAMES', l_trip_names);
3179: FND_MSG_PUB.ADD;
3180: RAISE FND_API.G_EXC_ERROR;
3181: ELSE
3182: FND_MESSAGE.SET_NAME('FTE','FTE_MULTI_RANK_DEL_WARN');
3178: FND_MESSAGE.SET_TOKEN('TRIP_NAMES', l_trip_names);
3179: FND_MSG_PUB.ADD;
3180: RAISE FND_API.G_EXC_ERROR;
3181: ELSE
3182: FND_MESSAGE.SET_NAME('FTE','FTE_MULTI_RANK_DEL_WARN');
3183: FND_MESSAGE.SET_TOKEN('TRIP_NAMES', l_trip_names);
3184: FND_MSG_PUB.ADD;
3185: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3186: END IF;
3179: FND_MSG_PUB.ADD;
3180: RAISE FND_API.G_EXC_ERROR;
3181: ELSE
3182: FND_MESSAGE.SET_NAME('FTE','FTE_MULTI_RANK_DEL_WARN');
3183: FND_MESSAGE.SET_TOKEN('TRIP_NAMES', l_trip_names);
3184: FND_MSG_PUB.ADD;
3185: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3186: END IF;
3187:
3489:
3490: IF (l_trip_names IS NOT NULL)
3491: THEN
3492:
3493: FND_MESSAGE.SET_NAME('FTE','FTE_RANK_CRE_FAILED_TRIPS');
3494: FND_MESSAGE.SET_TOKEN('trip_names', l_trip_names);
3495: FND_MSG_PUB.ADD;
3496: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3497: END IF;
3490: IF (l_trip_names IS NOT NULL)
3491: THEN
3492:
3493: FND_MESSAGE.SET_NAME('FTE','FTE_RANK_CRE_FAILED_TRIPS');
3494: FND_MESSAGE.SET_TOKEN('trip_names', l_trip_names);
3495: FND_MSG_PUB.ADD;
3496: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3497: END IF;
3498: