DBA Data[Home] [Help]

APPS.AMS_LIST_RULES_ALL_PVT dependencies on FND_MESSAGE

Line 352: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');

348: AND object_version_number = l_list_rule_rec.object_version_number;
349:
350: IF (SQL%NOTFOUND) THEN
351: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
352: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
353: FND_MSG_PUB.add;
354: END IF;
355: RAISE FND_API.g_exc_error;
356: END IF;

Line 487: FND_MESSAGE.set_name('AMS', 'AMS_LIST_RULE_BEING_USED');

483: CLOSE c_list_rule_count;
484:
485: IF l_list_rule_count > 0 THEN
486: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
487: FND_MESSAGE.set_name('AMS', 'AMS_LIST_RULE_BEING_USED');
488: FND_MSG_PUB.add;
489: END IF;
490: RAISE FND_API.g_exc_error;
491: END IF;

Line 499: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');

495: AND object_version_number = p_object_version;
496:
497: IF (SQL%NOTFOUND) THEN
498: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
499: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
500: FND_MSG_PUB.add;
501: END IF;
502: RAISE FND_API.g_exc_error;
503: END IF;

Line 635: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');

631: FETCH c_list_rule INTO l_list_rule_id;
632: IF (c_list_rule%NOTFOUND) THEN
633: CLOSE c_list_rule;
634: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
635: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
636: FND_MSG_PUB.add;
637: END IF;
638: RAISE FND_API.g_exc_error;
639: END IF;

Line 663: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');

659:
660: WHEN AMS_Utility_PVT.resource_locked THEN
661: x_return_status := FND_API.g_ret_sts_error;
662: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
663: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
664: FND_MSG_PUB.add;
665: END IF;
666: FND_MSG_PUB.count_and_get
667: (

Line 943: FND_MESSAGE.set_name('AMS', 'AMS_LIST_RULES_ALL_NO_ID');

939: -- check list_rule_id
940: IF p_list_rule_rec.list_rule_id IS NULL
941: AND p_validation_mode = JTF_PLSQL_API.g_update THEN
942: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
943: FND_MESSAGE.set_name('AMS', 'AMS_LIST_RULES_ALL_NO_ID');
944: FND_MSG_PUB.add;
945: END IF;
946:
947: x_return_status := FND_API.g_ret_sts_error;

Line 956: FND_MESSAGE.set_name('AMS', 'AMS_NO_OBJ_VER_NUM');

952: IF p_list_rule_rec.object_version_number IS NULL
953: AND p_validation_mode = JTF_PLSQL_API.g_update
954: THEN
955: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
956: FND_MESSAGE.set_name('AMS', 'AMS_NO_OBJ_VER_NUM');
957: FND_MSG_PUB.add;
958: END IF;
959:
960: x_return_status := FND_API.g_ret_sts_error;

Line 967: FND_MESSAGE.set_name('AMS', 'AMS_LIST_RULES_ALL_NO_NAME');

963:
964: -- check list_rule_name
965: IF p_list_rule_rec.list_rule_name IS NULL THEN
966: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
967: FND_MESSAGE.set_name('AMS', 'AMS_LIST_RULES_ALL_NO_NAME');
968: FND_MSG_PUB.add;
969: END IF;
970:
971: x_return_status := FND_API.g_ret_sts_error;

Line 979: FND_MESSAGE.set_name('AMS', 'AMS_LIST_RULES_ALL_NO_DEDUPE');

975: -- check weightage_for_dedupe
976: --commented by vb 08/30/2001 after we made this column nullable
977: /* IF p_list_rule_rec.weightage_for_dedupe IS NULL THEN
978: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
979: FND_MESSAGE.set_name('AMS', 'AMS_LIST_RULES_ALL_NO_DEDUPE');
980: FND_MSG_PUB.add;
981: END IF;
982:
983: x_return_status := FND_API.g_ret_sts_error;

Line 990: FND_MESSAGE.set_name('AMS', 'AMS_LIST_RULES_ALL_NO_STRT_DT');

986:
987: -- check active_from_date
988: IF p_list_rule_rec.active_from_date IS NULL THEN
989: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
990: FND_MESSAGE.set_name('AMS', 'AMS_LIST_RULES_ALL_NO_STRT_DT');
991: FND_MSG_PUB.add;
992: END IF;
993:
994: x_return_status := FND_API.g_ret_sts_error;

Line 1034: FND_MESSAGE.set_name('AMS', 'AMS_LIST_RULES_ALL_NO_ID');

1030: END IF;
1031:
1032: IF l_uk_flag = FND_API.g_false THEN
1033: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1034: FND_MESSAGE.set_name('AMS', 'AMS_LIST_RULES_ALL_NO_ID');
1035: FND_MSG_PUB.add;
1036: END IF;
1037:
1038: x_return_status := FND_API.g_ret_sts_error;

Line 1060: FND_MESSAGE.set_name('AMS', 'AMS_LIST_RULES_ALL_DUP_NAME');

1056: END IF;
1057:
1058: IF l_uk_flag = FND_API.g_false THEN
1059: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1060: FND_MESSAGE.set_name('AMS', 'AMS_LIST_RULES_ALL_DUP_NAME');
1061: FND_MSG_PUB.add;
1062: END IF;
1063:
1064: x_return_status := FND_API.g_ret_sts_error;

Line 1100: FND_MESSAGE.set_name('AMS', 'AMS_LST_RULE_BAD_LST_RULE_TYPE');

1096: ) = FND_API.g_false
1097: THEN
1098: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1099: THEN
1100: FND_MESSAGE.set_name('AMS', 'AMS_LST_RULE_BAD_LST_RULE_TYPE');
1101: FND_MSG_PUB.add;
1102: END IF;
1103: x_return_status := FND_API.g_ret_sts_error;
1104: RETURN;

Line 1143: FND_MESSAGE.set_name('AMS', 'AMS_DATE_FROM_AFTER_DATE_TO');

1139: l_from_date := p_complete_rec.active_from_date;
1140: l_to_date := p_complete_rec.active_to_date;
1141: IF l_from_date > l_to_date THEN
1142: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1143: FND_MESSAGE.set_name('AMS', 'AMS_DATE_FROM_AFTER_DATE_TO');
1144: FND_MSG_PUB.add;
1145: END IF;
1146:
1147: x_return_status := FND_API.g_ret_sts_error;

Line 1183: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');

1179: FETCH c_list_rule INTO l_list_rule_rec;
1180: IF (c_list_rule%NOTFOUND) THEN
1181: CLOSE c_list_rule;
1182: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1183: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1184: FND_MSG_PUB.add;
1185: END IF;
1186: RAISE FND_API.g_exc_error;
1187: END IF;