DBA Data[Home] [Help]

APPS.AMS_CELL_PVT dependencies on FND_MESSAGE

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

303:
304: IF (SQL%NOTFOUND) THEN
305: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
306: THEN
307: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
308: FND_MSG_PUB.add;
309: END IF;
310: RAISE FND_API.g_exc_error;
311: END IF;

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

429: FETCH c_cell_b INTO l_cell_id;
430: IF (c_cell_b%NOTFOUND) THEN
431: CLOSE c_cell_b;
432: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
433: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
434: FND_MSG_PUB.add;
435: END IF;
436: RAISE FND_API.g_exc_error;
437: END IF;

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

453:
454: WHEN AMS_Utility_PVT.resource_locked THEN
455: x_return_status := FND_API.g_ret_sts_error;
456: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
457: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
458: FND_MSG_PUB.add;
459: END IF;
460:
461: FND_MSG_PUB.count_and_get(

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

592: AND object_version_number = l_cell_rec.object_version_number;
593:
594: IF (SQL%NOTFOUND) THEN
595: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
596: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
597: FND_MSG_PUB.add;
598: END IF;
599: AMS_Utility_PVT.debug_message(l_full_name ||': update b');
600: RAISE FND_API.g_exc_error;

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

611: AND USERENV('LANG') IN (language, source_lang);
612:
613: IF (SQL%NOTFOUND) THEN
614: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
615: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
616: FND_MSG_PUB.add;
617: AMS_Utility_PVT.debug_message(l_full_name ||': updatetl');
618: END IF;
619: RAISE FND_API.g_exc_error;

Line 800: FND_MESSAGE.set_name('AMS', 'AMS_CELL_NO_CODE');

796: ------------------------ cell_code --------------------------
797: IF p_cell_rec.cell_code IS NULL THEN
798: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
799: THEN
800: FND_MESSAGE.set_name('AMS', 'AMS_CELL_NO_CODE');
801: FND_MSG_PUB.add;
802: END IF;
803: x_return_status := FND_API.g_ret_sts_error;
804: RETURN;

Line 811: FND_MESSAGE.set_name('AMS', 'AMS_CELL_NO_NAME');

807: ------------------------ cell_name --------------------------
808: IF p_cell_rec.cell_name IS NULL THEN
809: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
810: THEN
811: FND_MESSAGE.set_name('AMS', 'AMS_CELL_NO_NAME');
812: FND_MSG_PUB.add;
813: END IF;
814: x_return_status := FND_API.g_ret_sts_error;
815: RETURN;

Line 851: FND_MESSAGE.set_name('AMS', 'AMS_CELL_DUPLICATE_ID');

847: ) = FND_API.g_false
848: THEN
849: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
850: THEN
851: FND_MESSAGE.set_name('AMS', 'AMS_CELL_DUPLICATE_ID');
852: FND_MSG_PUB.add;
853: END IF;
854: x_return_status := FND_API.g_ret_sts_error;
855: RETURN;

Line 878: FND_MESSAGE.set_name('AMS', 'AMS_CELL_DUPLICATE_NAME');

874:
875: IF l_valid_flag = FND_API.g_false THEN
876: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
877: THEN
878: FND_MESSAGE.set_name('AMS', 'AMS_CELL_DUPLICATE_NAME');
879: FND_MSG_PUB.add;
880: END IF;
881: x_return_status := FND_API.g_ret_sts_error;
882: RETURN;

Line 902: FND_MESSAGE.set_name('AMS', 'AMS_CELL_INVALID_CODE');

898:
899: IF l_valid_flag = FND_API.g_false THEN
900: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
901: THEN
902: FND_MESSAGE.set_name('AMS', 'AMS_CELL_INVALID_CODE');
903: FND_MSG_PUB.add;
904: END IF;
905: x_return_status := FND_API.g_ret_sts_error;
906: RETURN;

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

932: ) = FND_API.g_false
933: THEN
934: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
935: THEN
936: FND_MESSAGE.set_name('AMS', 'AMS_CELL_BAD_OWNER_USER_ID');
937: FND_MSG_PUB.add;
938: END IF;
939: x_return_status := FND_API.g_ret_sts_error;
940: RETURN;

Line 954: FND_MESSAGE.set_name('AMS', 'AMS_CELL_WRONG_PARENT_CELL_ID');

950: ) = FND_API.g_false
951: THEN
952: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
953: THEN
954: FND_MESSAGE.set_name('AMS', 'AMS_CELL_WRONG_PARENT_CELL_ID');
955: FND_MSG_PUB.add;
956: END IF;
957: x_return_status := FND_API.g_ret_sts_error;
958: RETURN;

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

986: IF AMS_Utility_PVT.is_Y_or_N(p_cell_rec.enabled_flag) = FND_API.g_false
987: THEN
988: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
989: THEN
990: FND_MESSAGE.set_name('AMS', 'AMS_CELL_WRONG_ENABLED_FLAG');
991: FND_MSG_PUB.add;
992: END IF;
993: x_return_status := FND_API.g_ret_sts_error;
994: RETURN;

Line 1046: FND_MESSAGE.set_name('AMS', 'AMS_CELL_CANCEL_ERROR');

1042:
1043: THEN
1044: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1045: THEN
1046: FND_MESSAGE.set_name('AMS', 'AMS_CELL_CANCEL_ERROR');
1047: FND_MSG_PUB.add;
1048: END IF;
1049: x_return_status := FND_API.g_ret_sts_error;
1050: RETURN;

Line 1067: FND_MESSAGE.set_name('AMS', 'AMS_CELL_PARENT_ERROR');

1063: IF l_count > 0
1064: THEN
1065: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1066: THEN
1067: FND_MESSAGE.set_name('AMS', 'AMS_CELL_PARENT_ERROR');
1068: FND_MSG_PUB.add;
1069: END IF;
1070: x_return_status := FND_API.g_ret_sts_error;
1071: RETURN;

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

1203: FETCH c_cell INTO l_cell_rec;
1204: IF c_cell%NOTFOUND THEN
1205: CLOSE c_cell;
1206: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1207: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1208: FND_MSG_PUB.add;
1209: END IF;
1210: RAISE FND_API.g_exc_error;
1211: END IF;

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

1343: OPEN c_discoverer_cell;
1344: FETCH c_discoverer_cell INTO l_discoverer_cell_rec;
1345: IF c_discoverer_cell%NOTFOUND THEN
1346: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1347: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1348: FND_MSG_PUB.add;
1349: END IF;
1350: RAISE FND_API.g_exc_error;
1351: END IF;

Line 1394: FND_MESSAGE.set_name('AMS', 'AMS_CELL_INVALID_SQL');

1390: OR l_from_position = 0
1391: OR instr(l_sql_string, 'PARTY_ID') > l_from_position
1392: THEN
1393: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1394: FND_MESSAGE.set_name('AMS', 'AMS_CELL_INVALID_SQL');
1395: FND_MSG_PUB.add;
1396: END IF;
1397: RAISE FND_API.g_exc_error;
1398: -- x_return_status := FND_API.g_ret_sts_error;

Line 1409: FND_MESSAGE.set_name('AMS', 'AMS_CELL_INVALID_ORDERBY');

1405: IF instr(l_sql_string, 'ORDER BY') > 0
1406: OR instr(l_sql_string, 'GROUP BY') > 0
1407: THEN
1408: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1409: FND_MESSAGE.set_name('AMS', 'AMS_CELL_INVALID_ORDERBY');
1410: FND_MSG_PUB.add;
1411: END IF;
1412: RAISE FND_API.g_exc_error;
1413: -- x_return_status := FND_API.g_ret_sts_error;

Line 1599: FND_MESSAGE.set_name('AMS', 'AMS_CELL_INVALID_SQL');

1595: IF instr(l_sql_string, 'PARTY_ID') = 0
1596: OR instr(l_sql_string, 'PARTY_ID', 1, 1) > l_from_position
1597: THEN
1598: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1599: FND_MESSAGE.set_name('AMS', 'AMS_CELL_INVALID_SQL');
1600: FND_MSG_PUB.add;
1601: END IF;
1602: RAISE FND_API.g_exc_error;
1603: RETURN;

Line 1610: FND_MESSAGE.set_name('AMS', 'AMS_CELL_INVALID_ORDERBY');

1606: IF instr(l_sql_string, 'ORDER BY') > 0
1607: OR instr(l_sql_string, 'GROUP BY') > 0
1608: THEN
1609: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1610: FND_MESSAGE.set_name('AMS', 'AMS_CELL_INVALID_ORDERBY');
1611: FND_MSG_PUB.add;
1612: END IF;
1613: RAISE FND_API.g_exc_error;
1614: -- x_return_status := FND_API.g_ret_sts_error;

Line 2399: FND_MESSAGE.set_name('AMS', 'AMS_CELL_INVALID_SQL');

2395: IF instr(l_sql_string, 'PARTY_ID') = 0
2396: OR instr(l_sql_string, 'PARTY_ID', 1, 1) > instr(l_sql_string, 'FROM', 1, 1)
2397: THEN
2398: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2399: FND_MESSAGE.set_name('AMS', 'AMS_CELL_INVALID_SQL');
2400: FND_MSG_PUB.add;
2401: END IF;
2402: RAISE FND_API.g_exc_error;
2403: -- x_return_status := FND_API.g_ret_sts_error;

Line 2729: FND_MESSAGE.set_name('AMS', 'AMS_CELL_BLANK_SQL');

2725: ------------------ call create_cell -------------------
2726:
2727: --bmuthukr bug 5130570
2728: if trim(l_sql_cell_rec.list_sql_string) is null AND l_sql_cell_rec.sel_type = 'SQL' then
2729: FND_MESSAGE.set_name('AMS', 'AMS_CELL_BLANK_SQL');
2730: FND_MSG_PUB.add;
2731: RAISE FND_API.g_exc_error;
2732: end if;
2733: --

Line 2948: FND_MESSAGE.set_name('AMS', 'AMS_CELL_BLANK_SQL');

2944: ------------------ call update_cell -------------------
2945:
2946: --bmuthukr bug 5130570
2947: if trim(l_sql_cell_rec.list_sql_string) is null then
2948: FND_MESSAGE.set_name('AMS', 'AMS_CELL_BLANK_SQL');
2949: FND_MSG_PUB.add;
2950: RAISE FND_API.g_exc_error;
2951: end if;
2952: --

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

2998: FETCH c_cell INTO l_sql_cell_rec_old;
2999: IF c_cell%NOTFOUND THEN
3000: CLOSE c_cell;
3001: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3002: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
3003: FND_MSG_PUB.add;
3004: END IF;
3005: RAISE FND_API.g_exc_error;
3006: END IF;

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

3015: AND arc_act_discoverer_used_by = 'CELL';
3016:
3017: IF (SQL%NOTFOUND) THEN
3018: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3019: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
3020: FND_MSG_PUB.add;
3021: END IF;
3022: AMS_Utility_PVT.debug_message(l_full_name ||': delete from ams_act_discoverer_all');
3023: RAISE FND_API.g_exc_error;

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

3049: AND arc_act_discoverer_used_by = 'CELL';
3050:
3051: IF (SQL%NOTFOUND) THEN
3052: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3053: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
3054: FND_MSG_PUB.add;
3055: END IF;
3056: AMS_Utility_PVT.debug_message(l_full_name ||': delete from ams_act_discoverer_all');
3057: RAISE FND_API.g_exc_error;

Line 3100: FND_MESSAGE.set_name('AMS', 'AMS_CELL_INVALID_SQL');

3096: OR l_from_position = 0
3097: OR instr(l_sql_string, 'PARTY_ID') > l_from_position
3098: THEN
3099: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3100: FND_MESSAGE.set_name('AMS', 'AMS_CELL_INVALID_SQL');
3101: FND_MSG_PUB.add;
3102: END IF;
3103: RAISE FND_API.g_exc_error;
3104: RETURN;

Line 3111: FND_MESSAGE.set_name('AMS', 'AMS_CELL_INVALID_ORDERBY');

3107: IF instr(l_sql_string, 'ORDER BY') > 0
3108: OR instr(l_sql_string, 'GROUP BY') > 0
3109: THEN
3110: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3111: FND_MESSAGE.set_name('AMS', 'AMS_CELL_INVALID_ORDERBY');
3112: FND_MSG_PUB.add;
3113: END IF;
3114: RAISE FND_API.g_exc_error;
3115: -- x_return_status := FND_API.g_ret_sts_error;