DBA Data[Home] [Help]

APPS.FTE_CARRIER_RANK_LIST_PVT dependencies on FND_MESSAGE

Line 145: FND_MESSAGE.SET_NAME('FTE','FTE_RANK_NOT_FOUND');

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

Line 380: FND_MESSAGE.SET_NAME('FTE','FTE_INVALID_TRIP');

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;

Line 381: FND_MESSAGE.SET_TOKEN('TRIP_ID', p_trip_id);

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:

Line 395: FND_MESSAGE.SET_NAME('FTE','FTE_CNT_DELETE_TENDER_CHECK');

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;

Line 396: FND_MESSAGE.SET_TOKEN('TENDER_STATUS',

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

Line 417: FND_MESSAGE.SET_NAME('FTE','FTE_RANK_TRIP_NOT_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);
421: RAISE FND_API.G_EXC_ERROR;

Line 418: FND_MESSAGE.SET_TOKEN('TRIP_NAME', l_trip_name);

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;

Line 713: FND_MESSAGE.SET_NAME('FTE', 'FTE_RANK_TRIP_ID_MISSING');

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

Line 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');

Line 798: FND_MESSAGE.SET_NAME('FTE','FTE_TRIP_LIST_EXISTS');

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;

Line 799: FND_MESSAGE.SET_TOKEN('TRIP_NAME',l_trip_name);

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:

Line 844: FND_MESSAGE.SET_NAME('FTE','FTE_CANNOT_SET_MORE_CURR');

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;

Line 845: FND_MESSAGE.SET_TOKEN('TRIP_NAME',l_trip_name);

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:

Line 996: FND_MESSAGE.SET_NAME('FTE','FTE_TRIP_LIST_NOTEXISTS');

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;

Line 997: FND_MESSAGE.SET_TOKEN('TRIP_NAME',l_trip_name);

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:

Line 1130: FND_MESSAGE.SET_NAME('FTE','FTE_TRIP_LIST_NOTEXISTS');

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;

Line 1131: FND_MESSAGE.SET_TOKEN('TRIP_ID',p_trip_id);

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:

Line 1179: FND_MESSAGE.SET_NAME('FTE','FTE_CANNOT_SET_MORE_CURR');

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;

Line 1180: FND_MESSAGE.SET_TOKEN('TRIP_NAME',l_trip_name);

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:

Line 1418: FND_MESSAGE.SET_NAME('FTE','FTE_RANK_NOT_FOUND');

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;

Line 1419: FND_MESSAGE.SET_TOKEN('RANK_ID', p_rank_id);

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:

Line 2002: FND_MESSAGE.SET_NAME('FTE','FTE_RANK_NOT_FOUND');

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;

Line 2401: FND_MESSAGE.SET_NAME('FTE','FTE_RANK_NOT_FOUND');

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;

Line 2430: FND_MESSAGE.SET_NAME('FTE','FTE_RANK_LIST_EXAUSTED');

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;

Line 2431: FND_MESSAGE.SET_TOKEN('TRIP_NAME',l_trip_name);

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

Line 2803: FND_MESSAGE.SET_NAME('FTE','FTE_RANK_NOT_FOUND');

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:

Line 3172: --FND_MESSAGE.SET_NAME('FTE','FTE_MULTI_RANK_DEL_SUCCESS');

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

Line 3177: FND_MESSAGE.SET_NAME('FTE','FTE_MULTI_RANK_DEL_FAIL');

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

Line 3178: FND_MESSAGE.SET_TOKEN('TRIP_NAMES', l_trip_names);

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

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

Line 3183: 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;
3187:

Line 3493: FND_MESSAGE.SET_NAME('FTE','FTE_RANK_CRE_FAILED_TRIPS');

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;

Line 3494: FND_MESSAGE.SET_TOKEN('trip_names', l_trip_names);

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: