DBA Data[Home] [Help]

APPS.AMS_GEO_AREAS_PVT dependencies on FND_MESSAGE

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

384: AND object_version_number = l_geo_area_rec.object_version_number;
385:
386: IF (SQL%NOTFOUND) THEN
387: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
388: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
389: FND_MSG_PUB.add;
390: END IF;
391: RAISE FND_API.g_exc_error;
392: END IF;

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

532: AND object_version_number = p_object_version;
533:
534: IF (SQL%NOTFOUND) THEN
535: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
536: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
537: FND_MSG_PUB.add;
538: END IF;
539: RAISE FND_API.g_exc_error;
540: END IF;

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

697: FETCH c_geo_area INTO l_geo_area_id;
698: IF (c_geo_area%NOTFOUND) THEN
699: CLOSE c_geo_area;
700: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
701: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
702: FND_MSG_PUB.add;
703: END IF;
704: RAISE FND_API.g_exc_error;
705: END IF;

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

725:
726: WHEN AMS_Utility_PVT.resource_locked THEN
727: x_return_status := FND_API.g_ret_sts_error;
728: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
729: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
730: FND_MSG_PUB.add;
731: END IF;
732: FND_MSG_PUB.count_and_get
733: (

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

986: -- check activity_geo_area_id
987: IF p_geo_area_rec.activity_geo_area_id IS NULL
988: AND p_validation_mode = JTF_PLSQL_API.g_update THEN
989: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
990: FND_MESSAGE.set_name('AMS', 'AMS_GEO_NO_ACT_AREA_ID');
991: FND_MSG_PUB.add;
992: END IF;
993:
994: x_return_status := FND_API.g_ret_sts_error;

Line 1003: FND_MESSAGE.set_name('AMS', 'AMS_API_NO_OBJ_VER_NUM');

999: IF p_geo_area_rec.object_version_number IS NULL
1000: AND p_validation_mode = JTF_PLSQL_API.g_update
1001: THEN
1002: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1003: FND_MESSAGE.set_name('AMS', 'AMS_API_NO_OBJ_VER_NUM');
1004: FND_MSG_PUB.add;
1005: END IF;
1006:
1007: x_return_status := FND_API.g_ret_sts_error;

Line 1014: FND_MESSAGE.set_name('AMS', 'AMS_GEO_NO_AREA_USED_BY_ID');

1010:
1011: -- check act_geo_area_used_by_id
1012: IF p_geo_area_rec.act_geo_area_used_by_id IS NULL THEN
1013: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1014: FND_MESSAGE.set_name('AMS', 'AMS_GEO_NO_AREA_USED_BY_ID');
1015: FND_MSG_PUB.add;
1016: END IF;
1017:
1018: x_return_status := FND_API.g_ret_sts_error;

Line 1025: FND_MESSAGE.set_name('AMS', 'AMS_GEO_NO_AREA_USED_BY');

1021:
1022: -- check arc_act_geo_area_used_by
1023: IF p_geo_area_rec.arc_act_geo_area_used_by IS NULL THEN
1024: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1025: FND_MESSAGE.set_name('AMS', 'AMS_GEO_NO_AREA_USED_BY');
1026: FND_MSG_PUB.add;
1027: END IF;
1028:
1029: x_return_status := FND_API.g_ret_sts_error;

Line 1036: -- FND_MESSAGE.set_name('AMS', 'AMS_GEO_BAD_AREA_USED_BY');

1032:
1033: -- commented out by soagrawa on 29-Jun-2001
1034: -- IF p_geo_area_rec.arc_act_geo_area_used_by NOT IN ('CAMP','ECAM','RCAM') THEN
1035: -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1036: -- FND_MESSAGE.set_name('AMS', 'AMS_GEO_BAD_AREA_USED_BY');
1037: -- FND_MSG_PUB.add;
1038: -- END IF;
1039:
1040: -- x_return_status := FND_API.g_ret_sts_error;

Line 1047: FND_MESSAGE.set_name('AMS', 'AMS_GEO_NO_AREA_TYPE_CODE');

1043:
1044: -- check geo_area_type_code
1045: IF p_geo_area_rec.geo_area_type_code IS NULL THEN
1046: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1047: FND_MESSAGE.set_name('AMS', 'AMS_GEO_NO_AREA_TYPE_CODE');
1048: FND_MSG_PUB.add;
1049: END IF;
1050:
1051: x_return_status := FND_API.g_ret_sts_error;

Line 1058: FND_MESSAGE.set_name('AMS', 'AMS_GEO_NO_HIERARCHY_ID');

1054:
1055: -- check geo_hierarchy_id
1056: IF p_geo_area_rec.geo_hierarchy_id IS NULL THEN
1057: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1058: FND_MESSAGE.set_name('AMS', 'AMS_GEO_NO_HIERARCHY_ID');
1059: FND_MSG_PUB.add;
1060: END IF;
1061:
1062: x_return_status := FND_API.g_ret_sts_error;

Line 1102: FND_MESSAGE.set_name('AMS', 'AMS_ACT_GEO_AREAS_DUP_ID');

1098: END IF;
1099:
1100: IF l_uk_flag = FND_API.g_false THEN
1101: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1102: FND_MESSAGE.set_name('AMS', 'AMS_ACT_GEO_AREAS_DUP_ID');
1103: FND_MSG_PUB.add;
1104: END IF;
1105:
1106: x_return_status := FND_API.g_ret_sts_error;

Line 1133: FND_MESSAGE.set_name('AMS', 'AMS_GEO_DUP_USED_BY_AND_ID');

1129: END IF;
1130:
1131: IF l_uk_flag = FND_API.g_false THEN
1132: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1133: FND_MESSAGE.set_name('AMS', 'AMS_GEO_DUP_USED_BY_AND_ID');
1134: FND_MSG_PUB.add;
1135: END IF;
1136:
1137: x_return_status := FND_API.g_ret_sts_error;

Line 1208: FND_MESSAGE.set_name('AMS', 'AMS_GEO_BAD_AREA_USED_BY_ID');

1204: -- end soagrawa
1205:
1206: IF l_fk_flag = FND_API.g_false THEN
1207: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1208: FND_MESSAGE.set_name('AMS', 'AMS_GEO_BAD_AREA_USED_BY_ID');
1209: FND_MSG_PUB.add;
1210: END IF;
1211:
1212: x_return_status := FND_API.g_ret_sts_error;

Line 1230: FND_MESSAGE.set_name('AMS', 'AMS_GEO_BAD_AREA_TYPE_CODE');

1226: );
1227:
1228: IF l_fk_flag = FND_API.g_false THEN
1229: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1230: FND_MESSAGE.set_name('AMS', 'AMS_GEO_BAD_AREA_TYPE_CODE');
1231: FND_MSG_PUB.add;
1232: END IF;
1233:
1234: x_return_status := FND_API.g_ret_sts_error;

Line 1248: FND_MESSAGE.set_name('AMS', 'AMS_GEO_BAD_AREA_HIERARCHY_ID');

1244: );
1245:
1246: IF l_fk_flag = FND_API.g_false THEN
1247: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1248: FND_MESSAGE.set_name('AMS', 'AMS_GEO_BAD_AREA_HIERARCHY_ID');
1249: FND_MSG_PUB.add;
1250: END IF;
1251:
1252: x_return_status := FND_API.g_ret_sts_error;

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

1283: FETCH c_geo_area INTO l_geo_area_rec;
1284: IF (c_geo_area%NOTFOUND) THEN
1285: CLOSE c_geo_area;
1286: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1287: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1288: FND_MSG_PUB.add;
1289: END IF;
1290: RAISE FND_API.g_exc_error;
1291: END IF;