DBA Data[Home] [Help]

APPS.AMS_APPROVERS_PVT dependencies on FND_MESSAGE

Line 360: Fnd_Message.set_name ('AMS', 'AMS_STATUS_SEED_DATA');

356: Complete_approvers_Rec(p_approvers_rec,l_approvers_rec);
357: IF l_approvers_rec.seeded_flag = 'Y' THEN
358: IF compare_columns(l_approvers_rec) = Fnd_Api.g_false THEN
359: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
360: Fnd_Message.set_name ('AMS', 'AMS_STATUS_SEED_DATA');
361: Fnd_Msg_Pub.ADD;
362: END IF;
363: RAISE Fnd_Api.g_exc_error;
364: END IF;

Line 522: Fnd_Message.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');

518: FETCH c_approvers INTO l_approvers_rec;
519: IF c_approvers%NOTFOUND THEN
520: CLOSE c_approvers;
521: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
522: Fnd_Message.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
523: Fnd_Msg_Pub.ADD;
524: END IF;
525: RAISE Fnd_Api.g_exc_error;
526: END IF;

Line 558: Fnd_Message.set_name ('AMS', 'AMS_API_SEED_DATA');

554: THEN
555: Ams_Approvers_Pkg.DELETE_ROW (p_approver_id);
556: ELSE
557: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
558: Fnd_Message.set_name ('AMS', 'AMS_API_SEED_DATA');
559: Fnd_Msg_Pub.ADD;
560: RAISE Fnd_Api.g_exc_error;
561: END IF;
562: END IF;

Line 836: Fnd_Message.set_name('AMS', 'AMS_APPR_DTL_SD_BFR_ED');

832: END IF;
833: IF (p_approvers_rec.start_date_active > p_approvers_rec.end_date_active) THEN
834: --dbms_output.put_line('st > ed ');
835: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
836: Fnd_Message.set_name('AMS', 'AMS_APPR_DTL_SD_BFR_ED');
837: Fnd_Msg_Pub.ADD;
838: x_return_status := Fnd_Api.g_ret_sts_error;
839: RETURN;
840: END IF;

Line 887: Fnd_Message.set_name ('AMS', 'AMS_APPR_APRVR_SD_BFR_ED');

883: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
884: IF l_start_date_active IS NOT NULL AND l_end_date_active IS NOT NULL THEN
885: IF l_start_date_active > l_end_date_active THEN
886: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
887: Fnd_Message.set_name ('AMS', 'AMS_APPR_APRVR_SD_BFR_ED');
888: Fnd_Msg_Pub.ADD;
889: END IF;
890: x_return_status := Fnd_Api.g_ret_sts_error;
891: RETURN;

Line 957: Fnd_Message.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');

953: FETCH c_approvers INTO l_approvers_rec;
954: IF c_approvers%NOTFOUND THEN
955: CLOSE c_approvers;
956: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
957: Fnd_Message.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
958: Fnd_Msg_Pub.ADD;
959: END IF;
960: RAISE Fnd_Api.g_exc_error;
961: END IF;

Line 1159: Fnd_Message.set_name ('AMS', 'AMS_NO_APPROVAL_DETAIL_ID');

1155: IF p_approvers_rec.ams_approval_detail_id = NULL
1156: OR p_approvers_rec.ams_approval_detail_id = Fnd_Api.g_miss_num
1157: THEN
1158: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
1159: Fnd_Message.set_name ('AMS', 'AMS_NO_APPROVAL_DETAIL_ID');
1160: Fnd_Msg_Pub.ADD;
1161: END IF;
1162: x_return_status := Fnd_Api.g_ret_sts_error;
1163: RETURN;

Line 1174: Fnd_Message.set_name('AMS', 'AMS_APPR_SD_LT_APD_SD');

1170: AND p_approvers_rec.START_DATE_ACTIVE <> Fnd_Api.g_miss_date)
1171: THEN
1172: IF p_approvers_rec.START_DATE_ACTIVE < l_start_date THEN
1173: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
1174: Fnd_Message.set_name('AMS', 'AMS_APPR_SD_LT_APD_SD');
1175: Fnd_Msg_Pub.ADD;
1176: END IF;
1177: x_return_status := Fnd_Api.g_ret_sts_error;
1178: RETURN;

Line 1182: Fnd_Message.set_name('AMS', 'AMS_APPR_SD_LT_APD_ED');

1178: RETURN;
1179: END IF;
1180: IF p_approvers_rec.START_DATE_ACTIVE > l_end_date THEN
1181: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
1182: Fnd_Message.set_name('AMS', 'AMS_APPR_SD_LT_APD_ED');
1183: Fnd_Msg_Pub.ADD;
1184: END IF;
1185: x_return_status := Fnd_Api.g_ret_sts_error;
1186: RETURN;

Line 1194: Fnd_Message.set_name('AMS', 'AMS_APPR_ED_LT_APD_SD');

1190: OR p_approvers_rec.END_DATE_ACTIVE <> Fnd_Api.g_miss_date)
1191: THEN
1192: IF p_approvers_rec.END_DATE_ACTIVE < l_start_date THEN
1193: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
1194: Fnd_Message.set_name('AMS', 'AMS_APPR_ED_LT_APD_SD');
1195: Fnd_Msg_Pub.ADD;
1196: END IF;
1197: x_return_status := Fnd_Api.g_ret_sts_error;
1198: RETURN;

Line 1202: Fnd_Message.set_name('AMS', 'AMS_APPR_ED_LT_APD_ED');

1198: RETURN;
1199: END IF;
1200: IF p_approvers_rec.END_DATE_ACTIVE > l_end_date THEN
1201: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
1202: Fnd_Message.set_name('AMS', 'AMS_APPR_ED_LT_APD_ED');
1203: Fnd_Msg_Pub.ADD;
1204: END IF;
1205: x_return_status := Fnd_Api.g_ret_sts_error;
1206: RETURN;

Line 1237: Fnd_Message.set_name('AMS', 'AMS_APPR_DUP_SEQ');

1233: FETCH c_appr_seq_exists INTO l_dummy;
1234: CLOSE c_appr_seq_exists;
1235: IF l_dummy = 1 THEN
1236: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1237: Fnd_Message.set_name('AMS', 'AMS_APPR_DUP_SEQ');
1238: Fnd_Msg_Pub.ADD;
1239: x_return_status := Fnd_Api.g_ret_sts_error;
1240: RETURN;
1241: END IF;

Line 1346: Fnd_Message.set_name('AMS', 'AMS_APPR_NO_RESORS');

1342: END IF;
1343:
1344: IF l_dummy <> 1 THEN
1345: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1346: Fnd_Message.set_name('AMS', 'AMS_APPR_NO_RESORS');
1347: Fnd_Msg_Pub.ADD;
1348: x_return_status := Fnd_Api.g_ret_sts_error;
1349: RETURN;
1350: END IF;

Line 1368: Fnd_Message.set_name('AMS', 'AMS_APPR_NO_RESORS');

1364: FETCH c_rappr_id_exists INTO l_dummy;
1365: CLOSE c_rappr_id_exists;
1366: IF l_dummy <> 1 THEN
1367: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1368: Fnd_Message.set_name('AMS', 'AMS_APPR_NO_RESORS');
1369: Fnd_Msg_Pub.ADD;
1370: x_return_status := Fnd_Api.g_ret_sts_error;
1371: RETURN;
1372: END IF;

Line 1381: Fnd_Message.set_name('AMS', 'AMS_MANY_DEFAULT_ROLE');

1377: FETCH c_multi_appr_exists INTO l_dummy;
1378: CLOSE c_multi_appr_exists;
1379: IF l_dummy > 1 THEN
1380: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1381: Fnd_Message.set_name('AMS', 'AMS_MANY_DEFAULT_ROLE');
1382: Fnd_Msg_Pub.ADD;
1383: x_return_status := Fnd_Api.g_ret_sts_error;
1384: RETURN;
1385: END IF;

Line 1412: Fnd_Message.set_name('AMS', 'AMS_APPR_NO_APPR_TYPE');

1408: l_meaning
1409: );
1410: IF x_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
1411: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1412: Fnd_Message.set_name('AMS', 'AMS_APPR_NO_APPR_TYPE');
1413: Fnd_Msg_Pub.ADD;
1414: x_return_status := Fnd_Api.g_ret_sts_error;
1415: RETURN;
1416: END IF;

Line 1466: Fnd_Message.set_name('AMS', 'AMS_APPR_NO_START_DATE');

1462: Ams_Utility_Pvt.debug_message('Approver end date cannot be specified without start date');
1463: END IF;
1464:
1465: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1466: Fnd_Message.set_name('AMS', 'AMS_APPR_NO_START_DATE');
1467: Fnd_Msg_Pub.ADD;
1468: x_return_status := Fnd_Api.g_ret_sts_error;
1469: END IF;
1470:

Line 1483: Fnd_Message.set_name('AMS', 'AMS_APPR_START_DATE_LT_SYSDATE');

1479: Ams_Utility_Pvt.debug_message('Approver start date cannot be less than the system date');
1480: END IF;
1481:
1482: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1483: Fnd_Message.set_name('AMS', 'AMS_APPR_START_DATE_LT_SYSDATE');
1484: Fnd_Msg_Pub.ADD;
1485: x_return_status := Fnd_Api.g_ret_sts_error;
1486: END IF;
1487:

Line 1497: Fnd_Message.set_name('AMS', 'AMS_APPR_STDT_GT_APRD_STDT');

1493: Ams_Utility_Pvt.debug_message('Approver Start Date cannot be less than the Approval Rule Start Date');
1494: END IF;
1495:
1496: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1497: Fnd_Message.set_name('AMS', 'AMS_APPR_STDT_GT_APRD_STDT');
1498: Fnd_Msg_Pub.ADD;
1499: x_return_status := Fnd_Api.g_ret_sts_error;
1500: END IF;
1501:

Line 1515: Fnd_Message.set_name('AMS', 'AMS_APPR_END_DATE_LT_SYSDATE');

1511: Ams_Utility_Pvt.debug_message('Approver end date cannot be less than the system date');
1512: END IF;
1513:
1514: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1515: Fnd_Message.set_name('AMS', 'AMS_APPR_END_DATE_LT_SYSDATE');
1516: Fnd_Msg_Pub.ADD;
1517: x_return_status := Fnd_Api.g_ret_sts_error;
1518: END IF;
1519:

Line 1529: Fnd_Message.set_name('AMS', 'AMS_APPR_EDDT_GT_APRD_EDDT');

1525: Ams_Utility_Pvt.debug_message('Approver end date cannot be greater than the Approval Rule end date');
1526: END IF;
1527:
1528: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1529: Fnd_Message.set_name('AMS', 'AMS_APPR_EDDT_GT_APRD_EDDT');
1530: Fnd_Msg_Pub.ADD;
1531: x_return_status := Fnd_Api.g_ret_sts_error;
1532: END IF;
1533:

Line 1585: Fnd_Message.set_name('AMS', 'AMS_APPR_NO_START_DATE');

1581: Ams_Utility_Pvt.debug_message('Approver End Date cannot be specified without Start Date');
1582: END IF;
1583:
1584: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1585: Fnd_Message.set_name('AMS', 'AMS_APPR_NO_START_DATE');
1586: Fnd_Msg_Pub.ADD;
1587: x_return_status := Fnd_Api.g_ret_sts_error;
1588: END IF;
1589:

Line 1604: Fnd_Message.set_name('AMS', 'AMS_APPR_STDT_NO_CHANGE');

1600: Ams_Utility_Pvt.debug_message('Approver start date cannot be changed as it is already active');
1601: END IF;
1602:
1603: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1604: Fnd_Message.set_name('AMS', 'AMS_APPR_STDT_NO_CHANGE');
1605: Fnd_Msg_Pub.ADD;
1606: x_return_status := Fnd_Api.g_ret_sts_error;
1607: END IF;
1608:

Line 1620: Fnd_Message.set_name('AMS', 'AMS_APPR_STDT_LT_APRD_STDT');

1616: Ams_Utility_Pvt.debug_message('Approver start date cannot be less than the Approval Rule start date');
1617: END IF;
1618:
1619: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1620: Fnd_Message.set_name('AMS', 'AMS_APPR_STDT_LT_APRD_STDT');
1621: Fnd_Msg_Pub.ADD;
1622: x_return_status := Fnd_Api.g_ret_sts_error;
1623: END IF;
1624:

Line 1640: Fnd_Message.set_name('AMS', 'AMS_APPR_END_DATE_LT_SYSDATE');

1636: Ams_Utility_Pvt.debug_message('Approver end date cannot be less than the system date');
1637: END IF;
1638:
1639: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1640: Fnd_Message.set_name('AMS', 'AMS_APPR_END_DATE_LT_SYSDATE');
1641: Fnd_Msg_Pub.ADD;
1642: x_return_status := Fnd_Api.g_ret_sts_error;
1643: END IF;
1644:

Line 1656: Fnd_Message.set_name('AMS', 'AMS_APPR_EDDT_GT_APRD_EDDT');

1652: Ams_Utility_Pvt.debug_message('Approver end date cannot be greater than the Approval Rule end date');
1653: END IF;
1654:
1655: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1656: Fnd_Message.set_name('AMS', 'AMS_APPR_EDDT_GT_APRD_EDDT');
1657: Fnd_Msg_Pub.ADD;
1658: x_return_status := Fnd_Api.g_ret_sts_error;
1659: END IF;
1660:

Line 1673: Fnd_Message.set_name('AMS', 'AMS_APPR_EDDT_OPEN');

1669: Ams_Utility_Pvt.debug_message('Approver end date cannot be open as the end date for Approval Rule is Closed');
1670: END IF;
1671:
1672: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1673: Fnd_Message.set_name('AMS', 'AMS_APPR_EDDT_OPEN');
1674: Fnd_Msg_Pub.ADD;
1675: x_return_status := Fnd_Api.g_ret_sts_error;
1676: END IF;
1677:

Line 1730: Fnd_Message.set_name('AMS', 'AMS_APPR_FUNC_INVALID');

1726: Ams_Utility_Pvt.debug_message('Invalid Use of Function for this objects Approval');
1727: END IF;
1728:
1729: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1730: Fnd_Message.set_name('AMS', 'AMS_APPR_FUNC_INVALID');
1731: Fnd_Msg_Pub.ADD;
1732: x_return_status := Fnd_Api.g_ret_sts_error;
1733: END IF;
1734:

Line 1748: Fnd_Message.set_name('AMS', 'AMS_APPR_FUNC_INVALID');

1744: Ams_Utility_Pvt.debug_message('Invalid Use of Function for this objects Approval');
1745: END IF;
1746:
1747: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1748: Fnd_Message.set_name('AMS', 'AMS_APPR_FUNC_INVALID');
1749: Fnd_Msg_Pub.ADD;
1750: x_return_status := Fnd_Api.g_ret_sts_error;
1751: END IF;
1752:

Line 1761: Fnd_Message.Set_Name('AMS','AMS_APPR_FUNC_INVALID');

1757: AND l_package_name = 'AMS_APPROVAL_UTIL_PVT'
1758: AND l_proc_name = 'GET_PARENT_OBJECT_OWNER' THEN
1759:
1760: IF NVL(Fnd_Profile.Value(name => 'AMS_SOURCE_FROM_PARENT'), 'N') = 'N' THEN
1761: Fnd_Message.Set_Name('AMS','AMS_APPR_FUNC_INVALID');
1762: Fnd_Msg_Pub.ADD;
1763: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1764: IF (AMS_DEBUG_HIGH_ON) THEN
1765: Ams_Utility_Pvt.debug_message('Invalid Use of Function for this objects Approval as SFP is NO');

Line 1782: Fnd_Message.set_name('AMS', 'AMS_APPR_FUNC_INVALID');

1778: Ams_Utility_Pvt.debug_message('Invalid Use of Function for this objects Approval');
1779: END IF;
1780:
1781: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1782: Fnd_Message.set_name('AMS', 'AMS_APPR_FUNC_INVALID');
1783: Fnd_Msg_Pub.ADD;
1784: x_return_status := Fnd_Api.g_ret_sts_error;
1785: END IF;
1786:

Line 1800: Fnd_Message.set_name('AMS', 'AMS_APPR_FUNC_INVALID');

1796: Ams_Utility_Pvt.debug_message('Invalid Use of Function for this objects Approval');
1797: END IF;
1798:
1799: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1800: Fnd_Message.set_name('AMS', 'AMS_APPR_FUNC_INVALID');
1801: Fnd_Msg_Pub.ADD;
1802: x_return_status := Fnd_Api.g_ret_sts_error;
1803: END IF;
1804: