DBA Data[Home] [Help]

APPS.AMS_USER_STATUSES_PVT dependencies on FND_MESSAGE

Line 342: FND_MESSAGE.set_name ('AMS', 'AMS_STATUS_SEED_DATA');

338:
339: IF l_user_status_rec.seeded_flag = 'Y' THEN
340: IF compare_columns(l_user_status_rec) = FND_API.g_false THEN
341: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
342: FND_MESSAGE.set_name ('AMS', 'AMS_STATUS_SEED_DATA');
343: FND_MSG_PUB.add;
344: END IF;
345: RAISE FND_API.g_exc_error;
346: END IF;

Line 401: FND_MESSAGE.set_name ('AMS', 'AMS_STATUS_CANNOT_DISABLE');

397: -- Check to see if the user status can be disabled
398: IF NVL(l_user_status_rec.enabled_flag,'Y') = 'N' THEN
399: IF can_disable_status(l_user_status_rec) = FND_API.g_false THEN
400: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
401: FND_MESSAGE.set_name ('AMS', 'AMS_STATUS_CANNOT_DISABLE');
402: FND_MESSAGE.set_token('USER_STATUS', l_user_status_rec.name);
403: FND_MSG_PUB.add;
404: END IF;
405: RAISE FND_API.G_EXC_ERROR;

Line 402: FND_MESSAGE.set_token('USER_STATUS', l_user_status_rec.name);

398: IF NVL(l_user_status_rec.enabled_flag,'Y') = 'N' THEN
399: IF can_disable_status(l_user_status_rec) = FND_API.g_false THEN
400: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
401: FND_MESSAGE.set_name ('AMS', 'AMS_STATUS_CANNOT_DISABLE');
402: FND_MESSAGE.set_token('USER_STATUS', l_user_status_rec.name);
403: FND_MSG_PUB.add;
404: END IF;
405: RAISE FND_API.G_EXC_ERROR;
406: END IF;

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

422: WHERE user_status_id = l_user_status_rec.user_status_id
423: AND object_version_number = l_user_status_rec.object_version_number;
424: IF (SQL%NOTFOUND) THEN
425: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
426: FND_MESSAGE.set_name ('AMS', 'AMS_API_RECORD_NOT_FOUND');
427: FND_MSG_PUB.add;
428: END IF;
429: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
430: END IF;

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

439: WHERE user_status_id = l_user_status_rec.user_status_id
440: AND USERENV('LANG') IN (LANGUAGE, SOURCE_LANG);
441: IF (SQL%NOTFOUND) THEN
442: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
443: FND_MESSAGE.set_name ('AMS', 'AMS_API_RECORD_NOT_FOUND');
444: FND_MSG_PUB.add;
445: END IF;
446: RAISE FND_API.g_exc_error;
447: END IF;

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

526: FETCH c_user_status INTO l_user_status_rec;
527: IF c_user_status%NOTFOUND THEN
528: CLOSE c_user_status;
529: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
530: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
531: FND_MSG_PUB.add;
532: END IF;
533: RAISE FND_API.g_exc_error;
534: END IF;

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

565: WHERE user_status_id = p_user_status_id;
566: IF (SQL%NOTFOUND) THEN
567: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error)
568: THEN
569: FND_MESSAGE.set_name ('AMS', 'AMS_API_RECORD_NOT_FOUND');
570: FND_MSG_PUB.add;
571: END IF;
572: RAISE FND_API.g_exc_error;
573: END IF;

Line 580: FND_MESSAGE.set_name ('AMS', 'AMS_API_SEED_DATA');

576: AND object_version_number = p_object_version;
577:
578: ELSE
579: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
580: FND_MESSAGE.set_name ('AMS', 'AMS_API_SEED_DATA');
581: FND_MSG_PUB.add;
582: RAISE FND_API.g_exc_error;
583: END IF;
584:

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

689: FETCH c_lock INTO l_dummy;
690: IF (c_lock%NOTFOUND) THEN
691: CLOSE c_lock;
692: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
693: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
694: FND_MSG_PUB.add;
695: END IF;
696: RAISE FND_API.g_exc_error;
697: END IF;

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

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

Line 970: FND_MESSAGE.set_name ('AMS', 'AMS_STATUS_FROMDT_GTR_TODT');

966:
967: IF l_start_date_active IS NOT NULL AND l_end_date_active IS NOT NULL THEN
968: IF l_start_date_active > l_end_date_active THEN
969: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
970: FND_MESSAGE.set_name ('AMS', 'AMS_STATUS_FROMDT_GTR_TODT');
971: FND_MSG_PUB.add;
972: END IF;
973: x_return_status := FND_API.g_ret_sts_error;
974: RETURN;

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

1032: FETCH c_user_status INTO l_user_status_rec;
1033: IF c_user_status%NOTFOUND THEN
1034: CLOSE c_user_status;
1035: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1036: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1037: FND_MSG_PUB.add;
1038: END IF;
1039: RAISE FND_API.g_exc_error;
1040: END IF;

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

1203: BEGIN
1204: -- SYSTEM_STATUS_TYPE
1205: IF p_user_status_rec.system_status_type IS NULL THEN
1206: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
1207: FND_MESSAGE.set_name ('AMS', 'AMS_STATUS_NO_STATUS_TYPE');
1208: FND_MSG_PUB.add;
1209: END IF;
1210: x_return_status := FND_API.g_ret_sts_error;
1211: RETURN;

Line 1216: FND_MESSAGE.set_name ('AMS', 'AMS_STATUS_NO_SYSTEM_STATUS');

1212: END IF;
1213: -- SYSTEM_STATUS_CODE
1214: IF p_user_status_rec.system_status_code IS NULL THEN
1215: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
1216: FND_MESSAGE.set_name ('AMS', 'AMS_STATUS_NO_SYSTEM_STATUS');
1217: FND_MSG_PUB.add;
1218: END IF;
1219: x_return_status := FND_API.g_ret_sts_error;
1220: RETURN;

Line 1225: FND_MESSAGE.set_name ('AMS', 'AMS_STATUS_NO_NAME');

1221: END IF;
1222: -- NAME
1223: IF p_user_status_rec.name IS NULL THEN
1224: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
1225: FND_MESSAGE.set_name ('AMS', 'AMS_STATUS_NO_NAME');
1226: FND_MSG_PUB.add;
1227: END IF;
1228: x_return_status := FND_API.g_ret_sts_error;
1229: RETURN;

Line 1237: -- FND_MESSAGE.set_name('AMS', 'AMS_STATUS_NO_ACTIVE_FROM');

1233: -- START_DATE_ACTIVE
1234: --IF p_user_status_rec.start_date_active IS NULL THEN
1235: -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1236: -- THEN
1237: -- FND_MESSAGE.set_name('AMS', 'AMS_STATUS_NO_ACTIVE_FROM');
1238: -- FND_MSG_PUB.add;
1239: -- END IF;
1240: --
1241: -- x_return_status := FND_API.g_ret_sts_error;

Line 1269: FND_MESSAGE.set_name ('AMS', 'AMS_STATUS_DUP_USR_ST_ID');

1265: 'user_status_id = ' || p_user_status_rec.user_status_id
1266: ) = FND_API.g_false
1267: THEN
1268: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
1269: FND_MESSAGE.set_name ('AMS', 'AMS_STATUS_DUP_USR_ST_ID');
1270: FND_MSG_PUB.add;
1271: END IF;
1272: x_return_status := FND_API.g_ret_sts_error;
1273: RETURN;

Line 1294: FND_MESSAGE.set_name ('AMS', 'AMS_STATUS_DUP_NAME');

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

Line 1340: FND_MESSAGE.set_name ('AMS', 'AMS_STATUS_BAD_SYSTEM_STATUS');

1336: p_view_application_id => fnd_global.resp_appl_id
1337: ) = FND_API.g_false
1338: THEN
1339: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
1340: FND_MESSAGE.set_name ('AMS', 'AMS_STATUS_BAD_SYSTEM_STATUS');
1341: FND_MSG_PUB.add;
1342: END IF;
1343: x_return_status := FND_API.g_ret_sts_error;
1344: RETURN;

Line 1360: FND_MESSAGE.set_name ('AMS', 'AMS_STATUS_BAD_DEFAULT_FLAG');

1356: -- DEFAULT_FLAG
1357: IF p_user_status_rec.default_flag <> FND_API.g_miss_char AND p_user_status_rec.default_flag IS NOT NULL THEN
1358: IF AMS_Utility_PVT.is_Y_or_N (p_user_status_rec.default_flag) = FND_API.g_false THEN
1359: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
1360: FND_MESSAGE.set_name ('AMS', 'AMS_STATUS_BAD_DEFAULT_FLAG');
1361: FND_MSG_PUB.add;
1362: END IF;
1363: x_return_status := FND_API.g_ret_sts_error;
1364: RETURN;

Line 1371: FND_MESSAGE.set_name ('AMS', 'AMS_STATUS_BAD_ENABLED_FLAG');

1367: -- ENABLED_FLAG
1368: IF p_user_status_rec.enabled_flag <> FND_API.g_miss_char AND p_user_status_rec.enabled_flag IS NOT NULL THEN
1369: IF AMS_Utility_PVT.is_Y_or_N (p_user_status_rec.enabled_flag) = FND_API.g_false THEN
1370: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
1371: FND_MESSAGE.set_name ('AMS', 'AMS_STATUS_BAD_ENABLED_FLAG');
1372: FND_MSG_PUB.add;
1373: END IF;
1374: x_return_status := FND_API.g_ret_sts_error;
1375: RETURN;