DBA Data[Home] [Help]

APPS.AMS_LIST_WORD_FIELDS_PVT dependencies on FND_MESSAGE

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

324: AND object_version_number = l_wrd_fld_rec.object_version_number;
325:
326: IF (SQL%NOTFOUND) THEN
327: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
328: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
329: FND_MSG_PUB.add;
330: END IF;
331: RAISE FND_API.g_exc_error;
332: END IF;

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

454: AND object_version_number = p_object_version;
455:
456: IF (SQL%NOTFOUND) THEN
457: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
458: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
459: FND_MSG_PUB.add;
460: END IF;
461: RAISE FND_API.g_exc_error;
462: END IF;

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

585: FETCH c_list_word_field INTO l_wrd_fld_id;
586: IF (c_list_word_field%NOTFOUND) THEN
587: CLOSE c_list_word_field;
588: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
589: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
590: FND_MSG_PUB.add;
591: END IF;
592: RAISE FND_API.g_exc_error;
593: END IF;

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

613:
614: WHEN AMS_Utility_PVT.resource_locked THEN
615: x_return_status := FND_API.g_ret_sts_error;
616: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
617: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
618: FND_MSG_PUB.add;
619: END IF;
620: FND_MSG_PUB.count_and_get
621: (

Line 879: FND_MESSAGE.set_name('AMS', 'AMS_LIST_WORD_FIELDS_NO_ID');

875: -- check list_word_field_id
876: IF p_wrd_fld_rec.list_word_field_id IS NULL
877: AND p_validation_mode = JTF_PLSQL_API.g_update THEN
878: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
879: FND_MESSAGE.set_name('AMS', 'AMS_LIST_WORD_FIELDS_NO_ID');
880: FND_MSG_PUB.add;
881: END IF;
882:
883: x_return_status := FND_API.g_ret_sts_error;

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

888: IF p_wrd_fld_rec.object_version_number IS NULL
889: AND p_validation_mode = JTF_PLSQL_API.g_update
890: THEN
891: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
892: FND_MESSAGE.set_name('AMS', 'AMS_NO_OBJ_VER_NUM');
893: FND_MSG_PUB.add;
894: END IF;
895:
896: x_return_status := FND_API.g_ret_sts_error;

Line 903: FND_MESSAGE.set_name('AMS', 'AMS_LIST_WRD_FLD_NO_TBL_NAME');

899:
900: -- check field_table_name
901: IF p_wrd_fld_rec.field_table_name IS NULL THEN
902: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
903: FND_MESSAGE.set_name('AMS', 'AMS_LIST_WRD_FLD_NO_TBL_NAME');
904: FND_MSG_PUB.add;
905: END IF;
906:
907: x_return_status := FND_API.g_ret_sts_error;

Line 914: FND_MESSAGE.set_name('AMS', 'AMS_LIST_WRD_FLD_NO_COL_NAME');

910:
911: -- check field_column_name
912: IF p_wrd_fld_rec.field_column_name IS NULL THEN
913: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
914: FND_MESSAGE.set_name('AMS', 'AMS_LIST_WRD_FLD_NO_COL_NAME');
915: FND_MSG_PUB.add;
916: END IF;
917:
918: x_return_status := FND_API.g_ret_sts_error;

Line 925: FND_MESSAGE.set_name('AMS', 'AMS_LIST_WRD_FLD_NO_RPL_ID');

921:
922: -- check list_word_replaces_id
923: IF p_wrd_fld_rec.list_word_replaces_id IS NULL THEN
924: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
925: FND_MESSAGE.set_name('AMS', 'AMS_LIST_WRD_FLD_NO_RPL_ID');
926: FND_MSG_PUB.add;
927: END IF;
928:
929: x_return_status := FND_API.g_ret_sts_error;

Line 936: FND_MESSAGE.set_name('AMS', 'AMS_LIST_WRD_FLD_NO_ORG_WRD');

932:
933: -- check original_word
934: IF p_wrd_fld_rec.original_word IS NULL THEN
935: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
936: FND_MESSAGE.set_name('AMS', 'AMS_LIST_WRD_FLD_NO_ORG_WRD');
937: FND_MSG_PUB.add;
938: END IF;
939:
940: x_return_status := FND_API.g_ret_sts_error;

Line 947: FND_MESSAGE.set_name('AMS', 'AMS_LIST_WRD_FLD_NO_RPL_WRD');

943:
944: -- check replacement_word
945: IF p_wrd_fld_rec.replacement_word IS NULL THEN
946: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
947: FND_MESSAGE.set_name('AMS', 'AMS_LIST_WRD_FLD_NO_RPL_WRD');
948: FND_MSG_PUB.add;
949: END IF;
950:
951: x_return_status := FND_API.g_ret_sts_error;

Line 958: FND_MESSAGE.set_name('AMS', 'AMS_LIST_WRD_FLD_NO_ENBL_FLAG');

954:
955: -- check enabled_flag
956: IF p_wrd_fld_rec.enabled_flag IS NULL THEN
957: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
958: FND_MESSAGE.set_name('AMS', 'AMS_LIST_WRD_FLD_NO_ENBL_FLAG');
959: FND_MSG_PUB.add;
960: END IF;
961:
962: x_return_status := FND_API.g_ret_sts_error;

Line 971: FND_MESSAGE.set_name('AMS', 'AMS_LIST_WRD_FLD_NO_ENBL_FLAG');

967: AND p_wrd_fld_rec.enabled_flag <> 'N'
968: AND p_wrd_fld_rec.enabled_flag <> FND_API.g_miss_char
969: THEN
970: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
971: FND_MESSAGE.set_name('AMS', 'AMS_LIST_WRD_FLD_NO_ENBL_FLAG');
972: FND_MSG_PUB.add;
973: END IF;
974:
975: x_return_status := FND_API.g_ret_sts_error;

Line 1013: FND_MESSAGE.set_name('AMS', 'AMS_LIST_WORD_FLD_BAD_TBL_COL');

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

Line 1032: FND_MESSAGE.set_name('AMS', 'AMS_LIST_WORD_FLD_BAD_RPL_ID');

1028: );
1029:
1030: IF l_fk_flag = FND_API.g_false THEN
1031: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1032: FND_MESSAGE.set_name('AMS', 'AMS_LIST_WORD_FLD_BAD_RPL_ID');
1033: FND_MSG_PUB.add;
1034: END IF;
1035:
1036: x_return_status := FND_API.g_ret_sts_error;

Line 1077: FND_MESSAGE.set_name('AMS', 'AMS_LIST_WORD_FIELDS_NO_ID');

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

Line 1107: FND_MESSAGE.set_name('AMS', 'AMS_LIST_WORD_FLD_DUP_RP_TB_CO');

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

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

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