DBA Data[Home] [Help]

APPS.AMS_LIST_RULE_FIELDS_PVT dependencies on FND_MESSAGE

Line 93: FND_MESSAGE.set_name('AMS', 'AMS_LIST_RULE_CANNOT_MODIFY');

89: CLOSE c_list_rule_count;
90:
91: IF l_list_rule_count > 0 THEN
92: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
93: FND_MESSAGE.set_name('AMS', 'AMS_LIST_RULE_CANNOT_MODIFY');
94: FND_MSG_PUB.add;
95: END IF;
96: ---RAISE FND_API.g_exc_error;
97: END IF;

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

342: AND object_version_number = l_rule_fld_rec.object_version_number;
343:
344: IF (SQL%NOTFOUND) THEN
345: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
346: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
347: FND_MSG_PUB.add;
348: END IF;
349: RAISE FND_API.g_exc_error;
350: END IF;

Line 488: FND_MESSAGE.set_name('AMS', 'AMS_LIST_RULE_CANNOT_MODIFY');

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

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

502: AND object_version_number = p_object_version;
503:
504: IF (SQL%NOTFOUND) THEN
505: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
506: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
507: FND_MSG_PUB.add;
508: END IF;
509: RAISE FND_API.g_exc_error;
510: END IF;

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

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

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

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

Line 927: FND_MESSAGE.set_name('AMS', 'AMS_LIST_RULE_FLD_NO_ID');

923: -- check list_rule_field_id
924: IF p_rule_fld_rec.list_rule_field_id IS NULL
925: AND p_validation_mode = JTF_PLSQL_API.g_update THEN
926: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
927: FND_MESSAGE.set_name('AMS', 'AMS_LIST_RULE_FLD_NO_ID');
928: FND_MSG_PUB.add;
929: END IF;
930:
931: x_return_status := FND_API.g_ret_sts_error;

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

936: IF p_rule_fld_rec.object_version_number IS NULL
937: AND p_validation_mode = JTF_PLSQL_API.g_update
938: THEN
939: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
940: FND_MESSAGE.set_name('AMS', 'AMS_NO_OBJ_VER_NUM');
941: FND_MSG_PUB.add;
942: END IF;
943:
944: x_return_status := FND_API.g_ret_sts_error;

Line 951: FND_MESSAGE.set_name('AMS', 'AMS_LIST_RULE_FLD_NO_TBL_NAME');

947:
948: -- check field_table_name
949: IF p_rule_fld_rec.field_table_name IS NULL THEN
950: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
951: FND_MESSAGE.set_name('AMS', 'AMS_LIST_RULE_FLD_NO_TBL_NAME');
952: FND_MSG_PUB.add;
953: END IF;
954:
955: x_return_status := FND_API.g_ret_sts_error;

Line 962: FND_MESSAGE.set_name('AMS', 'AMS_LIST_RULE_FLD_NO_COL_NAME');

958:
959: -- check field_column_name
960: IF p_rule_fld_rec.field_column_name IS NULL THEN
961: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
962: FND_MESSAGE.set_name('AMS', 'AMS_LIST_RULE_FLD_NO_COL_NAME');
963: FND_MSG_PUB.add;
964: END IF;
965:
966: x_return_status := FND_API.g_ret_sts_error;

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

969:
970: -- check list_rule_id
971: IF p_rule_fld_rec.list_rule_id IS NULL THEN
972: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
973: FND_MESSAGE.set_name('AMS', 'AMS_LIST_RULES_ALL_NO_ID');
974: FND_MSG_PUB.add;
975: END IF;
976:
977: x_return_status := FND_API.g_ret_sts_error;

Line 1015: FND_MESSAGE.set_name('AMS', 'AMS_LIST_RULE_FLD_BAD_TBL_COL');

1011: );
1012:
1013: IF l_fk_flag = FND_API.g_false THEN
1014: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1015: FND_MESSAGE.set_name('AMS', 'AMS_LIST_RULE_FLD_BAD_TBL_COL');
1016: FND_MSG_PUB.add;
1017: END IF;
1018:
1019: x_return_status := FND_API.g_ret_sts_error;

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

1030: );
1031:
1032: IF l_fk_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 1079: FND_MESSAGE.set_name('AMS', 'AMS_LIST_RULE_FLD_NO_ID');

1075: END IF;
1076:
1077: IF l_uk_flag = FND_API.g_false THEN
1078: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1079: FND_MESSAGE.set_name('AMS', 'AMS_LIST_RULE_FLD_NO_ID');
1080: FND_MSG_PUB.add;
1081: END IF;
1082:
1083: x_return_status := FND_API.g_ret_sts_error;

Line 1109: FND_MESSAGE.set_name('AMS', 'AMS_LIST_RULE_FLD_DUP_RU_TB_CO');

1105: END IF;
1106:
1107: IF l_uk_flag = FND_API.g_false THEN
1108: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1109: FND_MESSAGE.set_name('AMS', 'AMS_LIST_RULE_FLD_DUP_RU_TB_CO');
1110: FND_MSG_PUB.add;
1111: END IF;
1112:
1113: x_return_status := FND_API.g_ret_sts_error;

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

1144: FETCH c_list_rule_field INTO l_rule_fld_rec;
1145: IF (c_list_rule_field%NOTFOUND) THEN
1146: CLOSE c_list_rule_field;
1147: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1148: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1149: FND_MSG_PUB.add;
1150: END IF;
1151: RAISE FND_API.g_exc_error;
1152: END IF;