DBA Data[Home] [Help]

APPS.AMS_ACTRESOURCE_PVT dependencies on FND_MESSAGE

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

502: IF (SQL%NOTFOUND)
503: THEN
504: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
505: THEN -- MMSG
506: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
507: FND_MSG_PUB.Add;
508: END IF;
509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
510: END IF;

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

617: AND p_object_version = p_object_version;
618:
619: IF (SQL%NOTFOUND) THEN
620: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
621: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
622: FND_MSG_PUB.add;
623: END IF;
624: RAISE FND_API.g_exc_error;
625: END IF;

Line 739: FND_MESSAGE.Set_Name('AMS', 'AMS_API_RECORD_NOT_FOUND');

735: CLOSE c_act_resource;
736:
737: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
738: THEN
739: FND_MESSAGE.Set_Name('AMS', 'AMS_API_RECORD_NOT_FOUND');
740: FND_MSG_PUB.Add;
741: END IF;
742:
743: RAISE FND_API.G_EXC_ERROR;

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

769: );
770: WHEN AMS_Utility_PVT.resource_locked THEN
771: x_return_status := FND_API.g_ret_sts_error;
772: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
773: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
774: FND_MSG_PUB.add;
775: END IF;
776:
777: FND_MSG_PUB.Count_AND_Get

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

954: 'activity_resource_id = ' || p_act_Resource_rec.activity_resource_id
955: ) = FND_API.g_false
956: THEN
957: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
958: FND_MESSAGE.set_name('AMS', 'AMS_RES_DUPLICATE_ID');
959: FND_MSG_PUB.add;
960: END IF;
961: x_return_status := FND_API.g_ret_sts_error;
962: RETURN;

Line 1001: FND_MESSAGE.set_name('AMS', 'AMS_EVO_NO_USER_STATUS_ID');

997: IF (p_act_Resource_rec.user_status_id IS NULL OR
998: p_act_Resource_rec.user_status_id = FND_API.g_miss_num)
999: THEN
1000: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1001: FND_MESSAGE.set_name('AMS', 'AMS_EVO_NO_USER_STATUS_ID');
1002: FND_MSG_PUB.add;
1003: END IF;
1004: x_return_status := FND_API.g_ret_sts_error;
1005: END IF;

Line 1012: FND_MESSAGE.set_name('AMS', 'AMS_API_NO_APPLICATION_ID');

1008: /* IF (p_act_Resource_rec.application_id IS NULL OR
1009: p_act_Resource_rec.application_id = FND_API.g_miss_num)
1010: THEN
1011: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1012: FND_MESSAGE.set_name('AMS', 'AMS_API_NO_APPLICATION_ID');
1013: FND_MSG_PUB.add;
1014: END IF;
1015: x_return_status := FND_API.g_ret_sts_error;
1016: RETURN;

Line 1024: FND_MESSAGE.set_name('AMS', 'AMS_ACT_RSC_NO_RESOURCE_ID');

1020: IF (p_act_Resource_rec.resource_id IS NULL OR
1021: p_act_Resource_rec.resource_id = FND_API.g_miss_num)
1022: THEN
1023: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1024: FND_MESSAGE.set_name('AMS', 'AMS_ACT_RSC_NO_RESOURCE_ID');
1025: FND_MSG_PUB.add;
1026: END IF;
1027: x_return_status := FND_API.g_ret_sts_error;
1028: RETURN;

Line 1040: FND_MESSAGE.set_name('AMS', 'AMS_SAME_COORDINATOR_PRESENT');

1036:
1037: IF( l_coordinator_id = p_act_Resource_rec.resource_id AND p_act_Resource_rec.role_cd = 'COORDINATOR')
1038: THEN
1039: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1040: FND_MESSAGE.set_name('AMS', 'AMS_SAME_COORDINATOR_PRESENT');
1041: FND_MSG_PUB.add;
1042: END IF;
1043: x_return_status := FND_API.g_ret_sts_error;
1044: RETURN;

Line 1053: FND_MESSAGE.set_name('AMS', 'AMS_NO_ROLE_CD');

1049: IF (p_act_Resource_rec.role_cd IS NULL OR
1050: p_act_Resource_rec.role_cd = FND_API.g_miss_char)
1051: THEN
1052: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1053: FND_MESSAGE.set_name('AMS', 'AMS_NO_ROLE_CD');
1054: FND_MSG_PUB.add;
1055: END IF;
1056: x_return_status := FND_API.g_ret_sts_error;
1057: RETURN;

Line 1066: FND_MESSAGE.set_name('AMS', 'AMS_ACT_RSC_NO_USEDBYID');

1062: p_act_Resource_rec.act_resource_used_by_id IS NULL)
1063: THEN
1064: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1065: THEN
1066: FND_MESSAGE.set_name('AMS', 'AMS_ACT_RSC_NO_USEDBYID');
1067: FND_MSG_PUB.add;
1068: END IF;
1069: x_return_status := FND_API.G_RET_STS_ERROR;
1070: RETURN;

Line 1080: FND_MESSAGE.set_name('AMS', 'AMS_ACT_RSC_NO_USEDBY');

1076: THEN
1077: -- missing required fields
1078: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1079: THEN -- MMSG
1080: FND_MESSAGE.set_name('AMS', 'AMS_ACT_RSC_NO_USEDBY');
1081: FND_MSG_PUB.add;
1082: END IF;
1083: x_return_status := FND_API.G_RET_STS_ERROR;
1084: -- If any error happens abort API.

Line 1127: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_APP_ID');

1123: ) = FND_API.g_false
1124: THEN
1125: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1126: THEN
1127: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_APP_ID');
1128: FND_MSG_PUB.add;
1129: END IF;
1130: x_return_status := FND_API.g_ret_sts_error;
1131: RETURN;

Line 1146: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_USER_ST_ID');

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

Line 1169: FND_MESSAGE.set_name('AMS', 'AMS_ACT_RSC_BAD_RESOURCE');

1165: ) = FND_API.G_FALSE
1166: THEN
1167: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1168: THEN
1169: FND_MESSAGE.set_name('AMS', 'AMS_ACT_RSC_BAD_RESOURCE');
1170: FND_MSG_PUB.add;
1171: END IF;
1172: x_return_status := FND_API.G_RET_STS_ERROR;
1173: -- If any errors happen abort API/Procedure.

Line 1200: FND_MESSAGE.set_name('AMS', 'AMS_ACT_RSC_INVALID_REFERENCE');

1196: ) = FND_API.G_FALSE
1197: THEN
1198: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1199: THEN
1200: FND_MESSAGE.set_name('AMS', 'AMS_ACT_RSC_INVALID_REFERENCE');
1201: FND_MSG_PUB.add;
1202: END IF;
1203: x_return_status := FND_API.G_RET_STS_ERROR;
1204: -- If any errors happen abort API/Procedure.

Line 1238: FND_MESSAGE.set_name('AMS', 'AMS_BAD_ROLE_TYPE');

1234: ) = FND_API.g_false
1235: THEN
1236: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1237: THEN
1238: FND_MESSAGE.set_name('AMS', 'AMS_BAD_ROLE_TYPE');
1239: FND_MSG_PUB.add;
1240: END IF;
1241: x_return_status := FND_API.g_ret_sts_error;
1242: RETURN;

Line 1257: FND_MESSAGE.set_name('AMS', 'AMS_EVENT_BAD_USER_STATUS');

1253: ) = FND_API.g_false
1254: THEN
1255: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1256: THEN
1257: FND_MESSAGE.set_name('AMS', 'AMS_EVENT_BAD_USER_STATUS');
1258: FND_MSG_PUB.add;
1259: END IF;
1260: x_return_status := FND_API.g_ret_sts_error;
1261: RETURN;

Line 1274: FND_MESSAGE.set_name('AMS', 'AMS_ACT_RSC_BAD_SYS_ARC');

1270: ) = FND_API.g_false
1271: THEN
1272: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1273: THEN
1274: FND_MESSAGE.set_name('AMS', 'AMS_ACT_RSC_BAD_SYS_ARC');
1275: FND_MSG_PUB.add;
1276: END IF;
1277: x_return_status := FND_API.g_ret_sts_error;
1278: RETURN;

Line 1312: FND_MESSAGE.set_name('AMS', 'AMS_OBJ_BAD_PRIMARY_FLAG');

1308: IF AMS_Utility_PVT.is_Y_or_N(p_act_Resource_rec.primary_flag) = FND_API.g_false
1309: THEN
1310: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1311: THEN
1312: FND_MESSAGE.set_name('AMS', 'AMS_OBJ_BAD_PRIMARY_FLAG');
1313: FND_MSG_PUB.add;
1314: END IF;
1315: x_return_status := FND_API.g_ret_sts_error;
1316: RETURN;

Line 1408: Fnd_Message.set_name('AMS', 'AMS_NO_RESOURCE');

1404: IF(l_count > 0)
1405: THEN
1406: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR)
1407: THEN
1408: Fnd_Message.set_name('AMS', 'AMS_NO_RESOURCE');
1409: Fnd_Msg_Pub.ADD;
1410: END IF;
1411: RAISE FND_API.g_exc_error;
1412: END IF;

Line 1416: FND_MESSAGE.set_name('AMS', 'AMS_RES_STTIME_LS_SES_STTIME');

1412: END IF;
1413:
1414: IF p_act_Resource_rec.start_date_time < l_parent_start_date
1415: THEN
1416: FND_MESSAGE.set_name('AMS', 'AMS_RES_STTIME_LS_SES_STTIME');
1417: FND_MSG_PUB.add;
1418: RAISE FND_API.g_exc_error;
1419: ELSIF p_act_Resource_rec.end_date_time > l_parent_end_date
1420: THEN

Line 1421: FND_MESSAGE.set_name('AMS', 'AMS_RES_EDTIME_GT_SES_EDTIME');

1417: FND_MSG_PUB.add;
1418: RAISE FND_API.g_exc_error;
1419: ELSIF p_act_Resource_rec.end_date_time > l_parent_end_date
1420: THEN
1421: FND_MESSAGE.set_name('AMS', 'AMS_RES_EDTIME_GT_SES_EDTIME');
1422: FND_MSG_PUB.add;
1423: RAISE FND_API.g_exc_error;
1424: END IF;
1425:

Line 1441: Fnd_Message.set_name('AMS', 'AMS_NO_RESOURCE');

1437: IF(l_count > 0)
1438: THEN
1439: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR)
1440: THEN
1441: Fnd_Message.set_name('AMS', 'AMS_NO_RESOURCE');
1442: Fnd_Msg_Pub.ADD;
1443: END IF;
1444: RAISE FND_API.g_exc_error;
1445: END IF;

Line 1456: FND_MESSAGE.set_name('AMS', 'AMS_RES_SD_GT_PRNT_SD');

1452: IF l_res_start_date < l_start_date
1453: THEN
1454: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1455: THEN
1456: FND_MESSAGE.set_name('AMS', 'AMS_RES_SD_GT_PRNT_SD');
1457: FND_MSG_PUB.add;
1458: END IF;
1459: x_return_status := FND_API.g_ret_sts_error;
1460: RETURN;

Line 1465: FND_MESSAGE.set_name('AMS', 'AMS_RES_SD_ST_PRNT_ED');

1461: ELSIF l_res_start_date > l_end_date
1462: THEN
1463: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1464: THEN
1465: FND_MESSAGE.set_name('AMS', 'AMS_RES_SD_ST_PRNT_ED');
1466: FND_MSG_PUB.add;
1467: END IF;
1468: x_return_status := FND_API.g_ret_sts_error;
1469: RETURN;

Line 1479: FND_MESSAGE.set_name('AMS', 'AMS_RES_STTIME_LS_EVN_STTIME');

1475: AND p_act_Resource_rec.start_date_time < l_parent_start_date )
1476: THEN
1477: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1478: THEN
1479: FND_MESSAGE.set_name('AMS', 'AMS_RES_STTIME_LS_EVN_STTIME');
1480: FND_MSG_PUB.add;
1481: END IF;
1482: x_return_status := FND_API.g_ret_sts_error;
1483: RETURN;

Line 1491: FND_MESSAGE.set_name('AMS', 'AMS_RES_ED_GT_PRNT_SD');

1487: IF l_res_end_date < l_start_date
1488: THEN
1489: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1490: THEN
1491: FND_MESSAGE.set_name('AMS', 'AMS_RES_ED_GT_PRNT_SD');
1492: FND_MSG_PUB.add;
1493: END IF;
1494: x_return_status := FND_API.g_ret_sts_error;
1495: RETURN;

Line 1499: FND_MESSAGE.set_name('AMS', 'AMS_RES_ED_LT_PRNT_ED');

1495: RETURN;
1496: ELSIF l_res_end_date > l_end_date
1497: THEN
1498: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1499: FND_MESSAGE.set_name('AMS', 'AMS_RES_ED_LT_PRNT_ED');
1500: FND_MSG_PUB.add;
1501: END IF;
1502: x_return_status := FND_API.g_ret_sts_error;
1503: RETURN;

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

1509: AND p_act_Resource_rec.end_date_time > l_parent_end_date)
1510: THEN
1511: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1512: THEN
1513: FND_MESSAGE.set_name('AMS', 'AMS_RES_EDTIME_GT_EVN_EDTIME');
1514: FND_MSG_PUB.add;
1515: END IF;
1516: x_return_status := FND_API.g_ret_sts_error;
1517: RETURN;

Line 1624: FND_MESSAGE.set_name('AMS', 'AMS_EDTIME_LS_STTIME');

1620: IF ( p_act_Resource_rec.start_date_time > p_act_Resource_rec.end_date_time)
1621: THEN
1622: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1623: THEN
1624: FND_MESSAGE.set_name('AMS', 'AMS_EDTIME_LS_STTIME');
1625: FND_MSG_PUB.add;
1626: END IF;
1627: x_return_status := FND_API.g_ret_sts_error;
1628: RETURN;

Line 1714: FND_MESSAGE.set_name ('AMS', 'AMS_SAME_COORDINATOR_PRESENT');

1710: IF l_count > 0
1711: THEN
1712: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error)
1713: THEN
1714: FND_MESSAGE.set_name ('AMS', 'AMS_SAME_COORDINATOR_PRESENT');
1715: FND_MSG_PUB.add;
1716: END IF;
1717: x_return_status := FND_API.G_RET_STS_ERROR;
1718:

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

1796: FETCH c_resource INTO l_act_Resource_rec;
1797: IF c_resource%NOTFOUND THEN
1798: CLOSE c_resource;
1799: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1800: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1801: FND_MSG_PUB.add;
1802: END IF;
1803: RAISE FND_API.g_exc_error;
1804: END IF;

Line 2192: Fnd_Message.set_name('AMS', 'AMS_SESSION_RESOURCE_BOOKED');

2188: IF( x_return_status = Fnd_Api.g_ret_sts_error) -- to avoid flow though
2189: THEN
2190: IF (p_act_Resource_rec.arc_act_resource_used_by = 'SESSION')
2191: THEN
2192: Fnd_Message.set_name('AMS', 'AMS_SESSION_RESOURCE_BOOKED');
2193: ELSE
2194: Fnd_Message.set_name('AMS', 'AMS_RESOURCE_BOOKED');
2195: END IF;
2196: Fnd_Msg_Pub.ADD;

Line 2194: Fnd_Message.set_name('AMS', 'AMS_RESOURCE_BOOKED');

2190: IF (p_act_Resource_rec.arc_act_resource_used_by = 'SESSION')
2191: THEN
2192: Fnd_Message.set_name('AMS', 'AMS_SESSION_RESOURCE_BOOKED');
2193: ELSE
2194: Fnd_Message.set_name('AMS', 'AMS_RESOURCE_BOOKED');
2195: END IF;
2196: Fnd_Msg_Pub.ADD;
2197: RETURN;
2198: END IF;