DBA Data[Home] [Help]

APPS.AMS_CHANNEL_PVT dependencies on FND_MESSAGE

Line 413: FND_MESSAGE.set_name('AMS', 'AMS_CHAN_CANNOT_DELETE');

409:
410: IF l_media_id IS NOT NULL THEN
411: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
412: THEN
413: FND_MESSAGE.set_name('AMS', 'AMS_CHAN_CANNOT_DELETE');
414: FND_MSG_PUB.add;
415: END IF;
416: RAISE FND_API.g_exc_error;
417: END IF;

Line 427: FND_MESSAGE.set_name('AMS', 'AMS_MKTG_MEDIA_IS_USED_BY_CSCH');

423:
424: IF l_mktg_medium_id IS NOT NULL THEN
425: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
426: THEN
427: FND_MESSAGE.set_name('AMS', 'AMS_MKTG_MEDIA_IS_USED_BY_CSCH');
428: FND_MSG_PUB.add;
429: END IF;
430: RAISE FND_API.g_exc_error;
431: END IF;

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

442:
443: IF (SQL%NOTFOUND) THEN
444: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
445: THEN
446: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
447: FND_MSG_PUB.add;
448: END IF;
449: RAISE FND_API.g_exc_error;
450: END IF;

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

454:
455: IF (SQL%NOTFOUND) THEN
456: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
457: 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 595: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');

591: FETCH c_chan_b INTO l_chan_id;
592: IF (c_chan_b%NOTFOUND) THEN
593: CLOSE c_chan_b;
594: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
595: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
596: FND_MSG_PUB.add;
597: END IF;
598: RAISE FND_API.g_exc_error;
599: END IF;

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

621:
622: WHEN AMS_Utility_PVT.resource_locked THEN
623: x_return_status := FND_API.g_ret_sts_error;
624: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
625: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
626: FND_MSG_PUB.add;
627: END IF;
628:
629: FND_MSG_PUB.count_and_get(

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

821: AND object_version_number = l_chan_rec.object_version_number;
822:
823: IF (SQL%NOTFOUND) THEN
824: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
825: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
826: FND_MSG_PUB.add;
827: END IF;
828: RAISE FND_API.g_exc_error;
829: END IF;

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

839: AND USERENV('LANG') IN (language, source_lang);
840:
841: IF (SQL%NOTFOUND) THEN
842: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
843: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
844: FND_MSG_PUB.add;
845: END IF;
846: RAISE FND_API.g_exc_error;
847: END IF;

Line 1068: FND_MESSAGE.set_name('AMS', 'AMS_CHAN_INVALID_TYPE_CODE');

1064: ------------------------ channel_type --------------------------
1065: IF p_chan_rec.channel_type_code IS NULL THEN
1066: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1067: THEN
1068: FND_MESSAGE.set_name('AMS', 'AMS_CHAN_INVALID_TYPE_CODE');
1069: FND_MSG_PUB.add;
1070: END IF;
1071: x_return_status := FND_API.g_ret_sts_error;
1072: RETURN;

Line 1079: FND_MESSAGE.set_name('AMS', 'AMS_CHAN_NO_NAME');

1075: ------------------------ channel_name --------------------------
1076: IF p_chan_rec.channel_name IS NULL THEN
1077: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1078: THEN
1079: FND_MESSAGE.set_name('AMS', 'AMS_CHAN_NO_NAME');
1080: FND_MSG_PUB.add;
1081: END IF;
1082: x_return_status := FND_API.g_ret_sts_error;
1083: RETURN;

Line 1091: FND_MESSAGE.set_name('AMS', 'AMS_CHAN_INVALID_COUNTRY_ID');

1087: ------------------------ country_id --------------------------
1088: IF p_chan_rec.country_id IS NULL THEN
1089: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1090: THEN
1091: FND_MESSAGE.set_name('AMS', 'AMS_CHAN_INVALID_COUNTRY_ID');
1092: FND_MSG_PUB.add;
1093: END IF;
1094: x_return_status := FND_API.g_ret_sts_error;
1095: RETURN;

Line 1104: FND_MESSAGE.set_name('AMS', 'AMS_MED_CFD_IS_NULL');

1100: ------------------------ Active From Date ---------------------
1101: IF p_chan_rec.active_from_date IS NULL THEN
1102: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1103: THEN
1104: FND_MESSAGE.set_name('AMS', 'AMS_MED_CFD_IS_NULL');
1105: FND_MSG_PUB.add;
1106: END IF;
1107: x_return_status := FND_API.g_ret_sts_error;
1108: RETURN;

Line 1173: FND_MESSAGE.set_name('AMS', 'AMS_CHAN_DUPLICATE_ID');

1169: ) = FND_API.g_false
1170: THEN
1171: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1172: THEN
1173: FND_MESSAGE.set_name('AMS', 'AMS_CHAN_DUPLICATE_ID');
1174: FND_MSG_PUB.add;
1175: END IF;
1176: x_return_status := FND_API.g_ret_sts_error;
1177: RETURN;

Line 1222: FND_MESSAGE.set_name('AMS', 'AMS_CHAN_DUPLICATE_NAME');

1218: --IF l_valid_flag = FND_API.g_false THEN
1219: -- rrajesh end 11/08
1220: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1221: THEN
1222: FND_MESSAGE.set_name('AMS', 'AMS_CHAN_DUPLICATE_NAME');
1223: FND_MSG_PUB.add;
1224: END IF;
1225: x_return_status := FND_API.g_ret_sts_error;
1226: RETURN;

Line 1260: FND_MESSAGE.set_name('AMS', 'AMS_CHAN_BAD_MANAGED_BY_ID');

1256: ) = FND_API.g_false
1257: THEN
1258: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1259: THEN
1260: FND_MESSAGE.set_name('AMS', 'AMS_CHAN_BAD_MANAGED_BY_ID');
1261: FND_MSG_PUB.add;
1262: END IF;
1263: x_return_status := FND_API.g_ret_sts_error;
1264: RETURN;

Line 1278: FND_MESSAGE.set_name('AMS', 'AMS_CHAN_WRONG_VENDOR_ID');

1274: ) = FND_API.g_false
1275: THEN
1276: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1277: THEN
1278: FND_MESSAGE.set_name('AMS', 'AMS_CHAN_WRONG_VENDOR_ID');
1279: FND_MSG_PUB.add;
1280: END IF;
1281: x_return_status := FND_API.g_ret_sts_error;
1282: RETURN;

Line 1295: FND_MESSAGE.set_name('AMS', 'AMS_CHAN_WRONG_PARTY_ID');

1291: ) = FND_API.g_false
1292: THEN
1293: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1294: THEN
1295: FND_MESSAGE.set_name('AMS', 'AMS_CHAN_WRONG_PARTY_ID');
1296: FND_MSG_PUB.add;
1297: END IF;
1298: x_return_status := FND_API.g_ret_sts_error;
1299: RETURN;

Line 1319: FND_MESSAGE.set_name('AMS', 'AMS_CHAN_WRONG_COUNTRY_ID');

1315: ) = FND_API.g_false
1316: THEN
1317: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1318: THEN
1319: FND_MESSAGE.set_name('AMS', 'AMS_CHAN_WRONG_COUNTRY_ID');
1320: FND_MSG_PUB.add;
1321: END IF;
1322: x_return_status := FND_API.g_ret_sts_error;
1323: RETURN;

Line 1357: FND_MESSAGE.set_name('AMS', 'AMS_CAMP_WRONG_CHANNEL_TYPE');

1353: ) = FND_API.g_false
1354: THEN
1355: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1356: THEN
1357: FND_MESSAGE.set_name('AMS', 'AMS_CAMP_WRONG_CHANNEL_TYPE');
1358: FND_MSG_PUB.add;
1359: END IF;
1360: x_return_status := FND_API.g_ret_sts_error;
1361: RETURN;

Line 1376: FND_MESSAGE.set_name('AMS', 'AMS_CHAN_WRONG_RATING_VALUE');

1372: ) = FND_API.g_false
1373: THEN
1374: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1375: THEN
1376: FND_MESSAGE.set_name('AMS', 'AMS_CHAN_WRONG_RATING_VALUE');
1377: FND_MSG_PUB.add;
1378: END IF;
1379: x_return_status := FND_API.g_ret_sts_error;
1380: RETURN;

Line 1414: FND_MESSAGE.set_name('AMS', 'AMS_CHAN_WRONG_OUTBOUND_FLAG');

1410: IF AMS_Utility_PVT.is_Y_or_N(p_chan_rec.outbound_flag) = FND_API.g_false
1411: THEN
1412: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1413: THEN
1414: FND_MESSAGE.set_name('AMS', 'AMS_CHAN_WRONG_OUTBOUND_FLAG');
1415: FND_MSG_PUB.add;
1416: END IF;
1417: x_return_status := FND_API.g_ret_sts_error;
1418: RETURN;

Line 1430: FND_MESSAGE.set_name('AMS', 'AMS_CHAN_WRONG_INBOUND_FLAG');

1426: IF AMS_Utility_PVT.is_Y_or_N(p_chan_rec.inbound_flag) = FND_API.g_false
1427: THEN
1428: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1429: THEN
1430: FND_MESSAGE.set_name('AMS', 'AMS_CHAN_WRONG_INBOUND_FLAG');
1431: FND_MSG_PUB.add;
1432: END IF;
1433: x_return_status := FND_API.g_ret_sts_error;
1434: RETURN;

Line 1567: FND_MESSAGE.Set_Name('AMS', 'AMS_MED_FROMDT_GTR_TODT');

1563: -- invalid item
1564: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1565: THEN -- MMSG
1566: -- DBMS_OUTPUT.Put_Line('Start Date time or End Date Time is invalid');
1567: FND_MESSAGE.Set_Name('AMS', 'AMS_MED_FROMDT_GTR_TODT');
1568: -- FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_INVALID_DT_RANGE');
1569: FND_MSG_PUB.Add;
1570: END IF;
1571: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1568: -- FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_INVALID_DT_RANGE');

1564: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1565: THEN -- MMSG
1566: -- DBMS_OUTPUT.Put_Line('Start Date time or End Date Time is invalid');
1567: FND_MESSAGE.Set_Name('AMS', 'AMS_MED_FROMDT_GTR_TODT');
1568: -- FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_INVALID_DT_RANGE');
1569: FND_MSG_PUB.Add;
1570: END IF;
1571: x_return_status := FND_API.G_RET_STS_ERROR;
1572: -- If any errors happen abort API/Procedure.

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

1669: FETCH c_chan INTO l_chan_rec;
1670: IF c_chan%NOTFOUND THEN
1671: CLOSE c_chan;
1672: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1673: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1674: FND_MSG_PUB.add;
1675: END IF;
1676: RAISE FND_API.g_exc_error;
1677: END IF;