DBA Data[Home] [Help]

APPS.AMS_CUST_SETUP_PVT dependencies on FND_MESSAGE

Line 649: FND_MESSAGE.set_name('AMS', 'AMS_CUS_SETUP_SEED_DATA');

645: -- check custom_setup_id, dont update setups if id < 10000 as they are seed data
646: /**
647: IF l_cust_setup_rec.custom_setup_id < 10000 THEN
648: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
649: FND_MESSAGE.set_name('AMS', 'AMS_CUS_SETUP_SEED_DATA');
650: FND_MSG_PUB.add;
651: END IF;
652: RAISE FND_API.g_exc_error;
653: END IF;

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

706: AND object_version_number = l_cust_setup_rec.object_version_number;
707:
708: IF (SQL%NOTFOUND) THEN
709: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
710: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
711: FND_MSG_PUB.add;
712: END IF;
713: RAISE FND_API.g_exc_error;
714: END IF;

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

724: AND USERENV('LANG') IN (language, source_lang);
725:
726: IF (SQL%NOTFOUND) THEN
727: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
728: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
729: FND_MSG_PUB.add;
730: END IF;
731: RAISE FND_API.g_exc_error;
732: END IF;

Line 861: FND_MESSAGE.set_name('AMS', 'AMS_CUS_SETUP_SEED_DATA');

857:
858: -- check custom_setup_id, dont delete setups if id < 10000 as they are seed data
859: IF p_cust_setup_id < 10000 THEN
860: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
861: FND_MESSAGE.set_name('AMS', 'AMS_CUS_SETUP_SEED_DATA');
862: FND_MSG_PUB.add;
863: END IF;
864: RAISE FND_API.g_exc_error;
865: END IF;

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

887: WHERE custom_setup_id = p_cust_setup_id;
888:
889: IF (SQL%NOTFOUND) THEN
890: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
891: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
892: FND_MSG_PUB.add;
893: END IF;
894: RAISE FND_API.g_exc_error;
895: END IF;

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

899: AND object_version_number = p_object_version;
900:
901: IF (SQL%NOTFOUND) THEN
902: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
903: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
904: FND_MSG_PUB.add;
905: END IF;
906: RAISE FND_API.g_exc_error;
907: END IF;

Line 910: FND_MESSAGE.set_name('AMS', 'AMS_API_VERS_DONT_MATCH');

906: RAISE FND_API.g_exc_error;
907: END IF;
908: ELSE
909: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
910: FND_MESSAGE.set_name('AMS', 'AMS_API_VERS_DONT_MATCH');
911: FND_MSG_PUB.add;
912: END IF;
913: RAISE FND_API.g_exc_error;
914: END IF;

Line 923: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_IN_USE');

919: WHERE custom_setup_id = p_cust_setup_id
920: AND object_version_number = p_object_version;
921: /*
922: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
923: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_IN_USE');
924: FND_MSG_PUB.add;
925: END IF;
926: RAISE FND_API.g_exc_error;
927: */

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

1058: FETCH c_cust_setup_b INTO l_cust_setup_id;
1059: IF (c_cust_setup_b%NOTFOUND) THEN
1060: CLOSE c_cust_setup_b;
1061: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1062: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1063: FND_MSG_PUB.add;
1064: END IF;
1065: RAISE FND_API.g_exc_error;
1066: END IF;

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

1070: FETCH c_cust_setup_tl INTO l_cust_setup_id;
1071: IF (c_cust_setup_tl%NOTFOUND) THEN
1072: CLOSE c_cust_setup_tl;
1073: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1074: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1075: FND_MSG_PUB.add;
1076: END IF;
1077: RAISE FND_API.g_exc_error;
1078: END IF;

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

1098:
1099: WHEN AMS_Utility_PVT.resource_locked THEN
1100: x_return_status := FND_API.g_ret_sts_error;
1101: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1102: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
1103: FND_MSG_PUB.add;
1104: END IF;
1105: FND_MSG_PUB.count_and_get
1106: (

Line 1385: FND_MESSAGE.set_name('AMS', 'AMS_CUS_SETUP_NO_CUS_SETUP_ID');

1381: IF p_cust_setup_rec.custom_setup_id IS NULL
1382: AND p_validation_mode = JTF_PLSQL_API.g_update
1383: THEN
1384: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1385: FND_MESSAGE.set_name('AMS', 'AMS_CUS_SETUP_NO_CUS_SETUP_ID');
1386: FND_MSG_PUB.add;
1387: END IF;
1388:
1389: x_return_status := FND_API.g_ret_sts_error;

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

1394: IF p_cust_setup_rec.object_version_number IS NULL
1395: AND p_validation_mode = JTF_PLSQL_API.g_update
1396: THEN
1397: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1398: FND_MESSAGE.set_name('AMS', 'AMS_API_NO_OBJ_VER_NUM');
1399: FND_MSG_PUB.add;
1400: END IF;
1401:
1402: x_return_status := FND_API.g_ret_sts_error;

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

1405:
1406: -- check object_type
1407: /* IF p_cust_setup_rec.object_type NOT IN ('CAMP','ECAM','RCAM','EVEH','EVEO') THEN
1408: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1409: FND_MESSAGE.set_name('AMS', 'AMS_CUS_SETUP_BAD_OBJ_TYPE');
1410: FND_MSG_PUB.add;
1411: END IF;
1412:
1413: x_return_status := FND_API.g_ret_sts_error;

Line 1425: FND_MESSAGE.set_name('AMS', 'AMS_CUS_SETUP_NO_ACT_TP_CODE');

1421: IF p_cust_setup_rec.object_type IN ('CAMP','ECAM')
1422: AND p_cust_setup_rec.activity_type_code IS NULL
1423: THEN
1424: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1425: FND_MESSAGE.set_name('AMS', 'AMS_CUS_SETUP_NO_ACT_TP_CODE');
1426: FND_MSG_PUB.add;
1427: END IF;
1428:
1429: x_return_status := FND_API.g_ret_sts_error;

Line 1440: FND_MESSAGE.set_name('AMS', 'AMS_CUS_SETUP_BAD_ACT_TP_CODE');

1436: IF p_cust_setup_rec.activity_type_code IS NOT NULL
1437: OR p_cust_setup_rec.media_id IS NOT NULL
1438: THEN
1439: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1440: FND_MESSAGE.set_name('AMS', 'AMS_CUS_SETUP_BAD_ACT_TP_CODE');
1441: FND_MSG_PUB.add;
1442: END IF;
1443:
1444: x_return_status := FND_API.g_ret_sts_error;

Line 1452: FND_MESSAGE.set_name('AMS', 'AMS_CUS_SETUP_NO_SETUP_NAME');

1448:
1449: -- check setup_name
1450: IF p_cust_setup_rec.setup_name IS NULL THEN
1451: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1452: FND_MESSAGE.set_name('AMS', 'AMS_CUS_SETUP_NO_SETUP_NAME');
1453: FND_MSG_PUB.add;
1454: END IF;
1455:
1456: x_return_status := FND_API.g_ret_sts_error;

Line 1513: FND_MESSAGE.set_name('AMS', 'AMS_CUSTOM_SETUP_DUPLICATE_ID');

1509: END IF;
1510:
1511: IF l_uk_flag = FND_API.g_false THEN
1512: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1513: FND_MESSAGE.set_name('AMS', 'AMS_CUSTOM_SETUP_DUPLICATE_ID');
1514: FND_MSG_PUB.add;
1515: END IF;
1516:
1517: x_return_status := FND_API.g_ret_sts_error;

Line 1542: FND_MESSAGE.set_name('AMS', 'AMS_CUST_SETUP_DUP_NAME_LANG');

1538: END IF;
1539:
1540: IF l_uk_flag = FND_API.g_false THEN
1541: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1542: FND_MESSAGE.set_name('AMS', 'AMS_CUST_SETUP_DUP_NAME_LANG');
1543: FND_MSG_PUB.add;
1544: END IF;
1545:
1546: x_return_status := FND_API.g_ret_sts_error;

Line 1576: FND_MESSAGE.set_name('AMS', 'AMS_CUST_SETUP_DUP_NAME_LANG');

1572: END IF;
1573:
1574: IF (l_flag = 'Y') THEN
1575: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1576: FND_MESSAGE.set_name('AMS', 'AMS_CUST_SETUP_DUP_NAME_LANG');
1577: FND_MSG_PUB.add;
1578: END IF;
1579:
1580: x_return_status := FND_API.g_ret_sts_error;

Line 1627: FND_MESSAGE.set_name('AMS', 'AMS_CUS_SETUP_BAD_MEDIA_ID');

1623: END IF;
1624: -- end change. 07/21/01
1625: IF l_fk_flag = FND_API.g_false THEN
1626: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1627: FND_MESSAGE.set_name('AMS', 'AMS_CUS_SETUP_BAD_MEDIA_ID');
1628: FND_MSG_PUB.add;
1629: END IF;
1630:
1631: x_return_status := FND_API.g_ret_sts_error;

Line 1662: FND_MESSAGE.set_name('AMS', 'AMS_CUS_SETUP_BAD_ENBL_FLAG');

1658: IF p_cust_setup_rec.enabled_flag NOT IN ('Y','N',FND_API.g_miss_char)
1659: AND p_cust_setup_rec.enabled_flag IS NOT NULL
1660: THEN
1661: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1662: FND_MESSAGE.set_name('AMS', 'AMS_CUS_SETUP_BAD_ENBL_FLAG');
1663: FND_MSG_PUB.add;
1664: END IF;
1665:
1666: x_return_status := FND_API.g_ret_sts_error;

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

1697: FETCH c_cust_setup INTO l_cust_setup_rec;
1698: IF (c_cust_setup%NOTFOUND) THEN
1699: CLOSE c_cust_setup;
1700: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1701: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1702: FND_MSG_PUB.add;
1703: END IF;
1704: RAISE FND_API.g_exc_error;
1705: END IF;