DBA Data[Home] [Help]

APPS.AMS_ACT_MARKET_SEGMENTS_PVT dependencies on FND_MESSAGE

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

395: AND object_version_number = l_mks_rec.object_version_number;
396:
397: IF (SQL%NOTFOUND) THEN
398: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
399: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
400: FND_MSG_PUB.add;
401: END IF;
402: RAISE FND_API.g_exc_error;
403: END IF;

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

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

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

685: FETCH c_obj INTO l_mks_id;
686: IF (c_obj%NOTFOUND) THEN
687: CLOSE c_obj;
688: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
689: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
690: FND_MSG_PUB.add;
691: END IF;
692: RAISE FND_API.g_exc_error;
693: END IF;

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

707:
708: WHEN AMS_Utility_PVT.resource_locked THEN
709: x_return_status := FND_API.g_ret_sts_error;
710: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
711: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
712: FND_MSG_PUB.add;
713: END IF;
714: FND_MSG_PUB.count_and_get
715: (

Line 931: -- FND_MESSAGE.set_name('AMS', 'AMS_MKS_NO_ACT_MKS_ID');

927: -- IF p_mks_rec.activity_market_segment_id IS NULL
928: -- AND p_validation_mode = JTF_PLSQL_API.g_update
929: -- THEN
930: -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
931: -- FND_MESSAGE.set_name('AMS', 'AMS_MKS_NO_ACT_MKS_ID');
932: -- FND_MSG_PUB.add;
933: -- END IF;
934: --
935: -- x_return_status := FND_API.g_ret_sts_error;

Line 945: -- FND_MESSAGE.set_name('AMS', 'AMS_MKS_NO_OBJ_VER_NUM');

941: -- IF p_mks_rec.object_version_number IS NULL
942: -- AND p_validation_mode = JTF_PLSQL_API.g_update
943: -- THEN
944: -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
945: -- FND_MESSAGE.set_name('AMS', 'AMS_MKS_NO_OBJ_VER_NUM');
946: -- FND_MSG_PUB.add;
947: -- END IF;
948: --
949: -- x_return_status := FND_API.g_ret_sts_error;

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

954: -- check market_segment_id
955: /* comment by julou 29-MAY-2001
956: IF p_mks_rec.market_segment_id 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_MKS_NO_MKS_ID');
959: FND_MSG_PUB.add;
960: END IF;
961:
962: x_return_status := FND_API.g_ret_sts_error;

Line 969: FND_MESSAGE.set_name('AMS', 'AMS_MKS_NO_ACT_MKS_USED_BY_ID');

965: */
966: -- check act_market_segment_used_by_id
967: IF p_mks_rec.act_market_segment_used_by_id IS NULL THEN
968: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
969: FND_MESSAGE.set_name('AMS', 'AMS_MKS_NO_ACT_MKS_USED_BY_ID');
970: FND_MSG_PUB.add;
971: END IF;
972:
973: x_return_status := FND_API.g_ret_sts_error;

Line 980: FND_MESSAGE.set_name('AMS', 'AMS_MKS_NO_ARC_ACT_MKS_USED_BY');

976:
977: -- check arc_act_market_segment_used_by
978: IF p_mks_rec.arc_act_market_segment_used_by IS NULL THEN
979: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
980: FND_MESSAGE.set_name('AMS', 'AMS_MKS_NO_ARC_ACT_MKS_USED_BY');
981: FND_MSG_PUB.add;
982: END IF;
983:
984: x_return_status := FND_API.g_ret_sts_error;

Line 994: FND_MESSAGE.set_name('AMS', 'AMS_MKS_MISSING_MKS_TYPE');

990: -- Commented by skarumur as there is no segment type any more
991:
992: /* IF p_mks_rec.segment_type IS NULL THEN
993: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
994: FND_MESSAGE.set_name('AMS', 'AMS_MKS_MISSING_MKS_TYPE');
995: FND_MSG_PUB.add;
996: END IF;
997:
998: x_return_status := FND_API.g_ret_sts_error;

Line 1028: FND_MESSAGE.set_name('AMS', 'AMS_MKS_BAD_ARC_ACT_MKS_USEDBY');

1024: /*
1025: IF UPPER(p_mks_rec.arc_act_market_segment_used_by)
1026: NOT IN ('CAMP', 'EVEH', 'EVEO', 'CELL') THEN
1027: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1028: FND_MESSAGE.set_name('AMS', 'AMS_MKS_BAD_ARC_ACT_MKS_USEDBY');
1029: FND_MSG_PUB.add;
1030: END IF;
1031:
1032: x_return_status := FND_API.g_ret_sts_error;

Line 1065: -- FND_MESSAGE.set_name('AMS', 'AMS_MKS_BAD_ARC_ACT_MKS_USEDBY');

1061: -- p_mks_rec.act_market_segment_used_by_id
1062: -- );
1063: -- ELSE
1064: -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1065: -- FND_MESSAGE.set_name('AMS', 'AMS_MKS_BAD_ARC_ACT_MKS_USEDBY');
1066: -- FND_MSG_PUB.add;
1067: -- END IF;
1068: /* End of Comments by ptendulk on 16-dec-1999 */
1069:

Line 1094: -- FND_MESSAGE.Set_Name('AMS', 'AMS_MKS_BAD_ARC_ACT_MKS_USEDBY');

1090: -- -- invalid item
1091: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1092: -- THEN -- MMSG
1093: ---- DBMS_OUTPUT.Put_Line('Foreign Key Does not Exist');
1094: -- FND_MESSAGE.Set_Name('AMS', 'AMS_MKS_BAD_ARC_ACT_MKS_USEDBY');
1095: -- FND_MSG_PUB.Add;
1096: -- END IF;
1097: -- x_return_status := FND_API.G_RET_STS_ERROR;
1098: -- -- If any errors happen abort API/Procedure.

Line 1145: FND_MESSAGE.set_name('AMS', 'AMS_MKS_DUP_ACt_ID');

1141: ) = FND_API.g_false
1142: THEN
1143: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1144: THEN
1145: FND_MESSAGE.set_name('AMS', 'AMS_MKS_DUP_ACt_ID');
1146: FND_MSG_PUB.add;
1147: END IF;
1148: x_return_status := FND_API.g_ret_sts_error;
1149: RETURN;

Line 1185: FND_MESSAGE.set_name('AMS', 'AMS_MKS_BAD_SEGMENT_TYPE');

1181: END IF;
1182:
1183: IF l_lookup_flag = FND_API.g_false THEN
1184: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1185: FND_MESSAGE.set_name('AMS', 'AMS_MKS_BAD_SEGMENT_TYPE');
1186: FND_MSG_PUB.add;
1187: END IF;
1188:
1189: x_return_status := FND_API.g_ret_sts_error;

Line 1204: FND_MESSAGE.set_name('AMS', 'AMS_MKS_BAD_CONDITION_TYPE');

1200: END IF;
1201:
1202: IF l_lookup_flag = FND_API.g_false THEN
1203: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1204: FND_MESSAGE.set_name('AMS', 'AMS_MKS_BAD_CONDITION_TYPE');
1205: FND_MSG_PUB.add;
1206: END IF;
1207:
1208: x_return_status := FND_API.g_ret_sts_error;

Line 1346: FND_MESSAGE.set_name('AMS', 'AMS_MKS_DUP_SEGMENT');

1342: ) = FND_API.g_false
1343: THEN
1344: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1345: THEN
1346: FND_MESSAGE.set_name('AMS', 'AMS_MKS_DUP_SEGMENT');
1347: FND_MSG_PUB.add;
1348: END IF;
1349: x_return_status := FND_API.g_ret_sts_error;
1350: RETURN;

Line 1444: FND_MESSAGE.Set_Name ('AMS', 'AMS_MKS_INVALID_USED_BY');

1440: ,p_additional_where_clause => l_additional_where_clause
1441: ) = FND_API.G_FALSE
1442: THEN
1443: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1444: FND_MESSAGE.Set_Name ('AMS', 'AMS_MKS_INVALID_USED_BY');
1445: FND_MSG_PUB.Add;
1446: END IF;
1447:
1448: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1490: FND_MESSAGE.Set_Name('AMS', 'AMS_MKS_INVALID_MKS_ID');

1486: ) = FND_API.G_FALSE
1487: THEN
1488: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1489: THEN
1490: FND_MESSAGE.Set_Name('AMS', 'AMS_MKS_INVALID_MKS_ID');
1491: FND_MSG_PUB.Add;
1492: END IF;
1493:
1494: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1510: FND_MESSAGE.Set_Name('AMS', 'AMS_MKS_INVALID_MKS_ID');

1506: CLOSE c_mkt_seg_id;
1507:
1508: IF l_dummy = 0 THEN
1509: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1510: FND_MESSAGE.Set_Name('AMS', 'AMS_MKS_INVALID_MKS_ID');
1511: FND_MSG_PUB.Add;
1512: END IF;
1513: END IF;
1514: END IF;*/

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

1550: FETCH c_obj INTO l_mks_rec;
1551: IF (c_obj%NOTFOUND) THEN
1552: CLOSE c_obj;
1553: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1554: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1555: FND_MSG_PUB.add;
1556: END IF;
1557: RAISE FND_API.g_exc_error;
1558: END IF;