DBA Data[Home] [Help]

APPS.AMS_SETUP_ATTR_PVT dependencies on FND_MESSAGE

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

337: AND object_version_number = l_setup_attr_rec.object_version_number;
338:
339: IF (SQL%NOTFOUND) THEN
340: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
341: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
342: FND_MSG_PUB.add;
343: END IF;
344: RAISE FND_API.g_exc_error;
345: END IF;

Line 622: FND_MESSAGE.set_name('AMS', 'AMS_SETUP_ATT_NO_SETUP_ATT_ID');

618: -- check setup_attribute_id
619: IF p_setup_attr_rec.setup_attribute_id IS NULL
620: AND p_validation_mode = JTF_PLSQL_API.g_update THEN
621: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
622: FND_MESSAGE.set_name('AMS', 'AMS_SETUP_ATT_NO_SETUP_ATT_ID');
623: FND_MSG_PUB.add;
624: END IF;
625:
626: x_return_status := FND_API.g_ret_sts_error;

Line 635: FND_MESSAGE.set_name('AMS', 'AMS_API_NO_OBJ_VER_NUM');

631: IF p_setup_attr_rec.object_version_number IS NULL
632: AND p_validation_mode = JTF_PLSQL_API.g_update
633: THEN
634: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
635: FND_MESSAGE.set_name('AMS', 'AMS_API_NO_OBJ_VER_NUM');
636: FND_MSG_PUB.add;
637: END IF;
638:
639: x_return_status := FND_API.g_ret_sts_error;

Line 646: FND_MESSAGE.set_name('AMS', 'AMS_SETUP_ATT_NO_CUS_SETUP_ID');

642:
643: -- check custom_setup_id
644: IF p_setup_attr_rec.custom_setup_id IS NULL THEN
645: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
646: FND_MESSAGE.set_name('AMS', 'AMS_SETUP_ATT_NO_CUS_SETUP_ID');
647: FND_MSG_PUB.add;
648: END IF;
649:
650: x_return_status := FND_API.g_ret_sts_error;

Line 657: FND_MESSAGE.set_name('AMS', 'AMS_SETUP_ATT_NO_DIS_SEQ_NO');

653:
654: -- check display_sequence_no
655: IF p_setup_attr_rec.display_sequence_no IS NULL THEN
656: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
657: FND_MESSAGE.set_name('AMS', 'AMS_SETUP_ATT_NO_DIS_SEQ_NO');
658: FND_MSG_PUB.add;
659: END IF;
660:
661: x_return_status := FND_API.g_ret_sts_error;

Line 668: FND_MESSAGE.set_name('AMS', 'AMS_CUS_SETUP_NO_OBJ_ATTR');

664:
665: -- check object_attribute
666: IF p_setup_attr_rec.object_attribute IS NULL THEN
667: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
668: FND_MESSAGE.set_name('AMS', 'AMS_CUS_SETUP_NO_OBJ_ATTR');
669: FND_MSG_PUB.add;
670: END IF;
671:
672: x_return_status := FND_API.g_ret_sts_error;

Line 680: FND_MESSAGE.set_name('AMS', 'AMS_SETUP_ATT_NO_ATT_ESS_FLAG');

676: -- check attr_mandatory_flag
677: IF p_setup_attr_rec.attr_mandatory_flag IS NULL THEN
678: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
679: -- Change message here from Mandatory to Essential
680: FND_MESSAGE.set_name('AMS', 'AMS_SETUP_ATT_NO_ATT_ESS_FLAG');
681: FND_MSG_PUB.add;
682: END IF;
683:
684: x_return_status := FND_API.g_ret_sts_error;

Line 692: FND_MESSAGE.set_name('AMS', 'AMS_SETUP_ATT_NO_ESS_SEQ_NUM');

688: -- Put the check for the essential seq num here
689: IF (nvl(p_setup_attr_rec.attr_mandatory_flag, 'N') = 'Y' AND
690: p_setup_attr_rec.essential_seq_num IS NULL) THEN
691: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
692: FND_MESSAGE.set_name('AMS', 'AMS_SETUP_ATT_NO_ESS_SEQ_NUM');
693: FND_MSG_PUB.add;
694: END IF;
695:
696: x_return_status := FND_API.g_ret_sts_error;

Line 703: FND_MESSAGE.set_name('AMS', 'AMS_SETUP_ATT_NO_ATT_AVAL_FLAG');

699:
700: -- check attr_available_flag
701: IF p_setup_attr_rec.attr_available_flag IS NULL THEN
702: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
703: FND_MESSAGE.set_name('AMS', 'AMS_SETUP_ATT_NO_ATT_AVAL_FLAG');
704: FND_MSG_PUB.add;
705: END IF;
706:
707: x_return_status := FND_API.g_ret_sts_error;

Line 760: FND_MESSAGE.set_name('AMS', 'AMS_SETUP_ATTR_DUPLICATE_ID');

756: END IF;
757:
758: IF l_uk_flag = FND_API.g_false THEN
759: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
760: FND_MESSAGE.set_name('AMS', 'AMS_SETUP_ATTR_DUPLICATE_ID');
761: FND_MSG_PUB.add;
762: END IF;
763:
764:

Line 781: Fnd_Message.set_name('AMS', 'AMS_ESSENTIAL_DUP_SEQ');

777:
778: IF l_dummy = 1 THEN
779: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR)
780: THEN
781: Fnd_Message.set_name('AMS', 'AMS_ESSENTIAL_DUP_SEQ');
782: Fnd_Msg_Pub.ADD;
783: x_return_status := Fnd_Api.g_ret_sts_error;
784: RETURN;
785: END IF;

Line 827: FND_MESSAGE.set_name('AMS', 'AMS_SETUP_ATTR_BAD_CUS_SET_ID');

823: );
824:
825: IF l_fk_flag = FND_API.g_false THEN
826: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
827: FND_MESSAGE.set_name('AMS', 'AMS_SETUP_ATTR_BAD_CUS_SET_ID');
828: FND_MSG_PUB.add;
829: END IF;
830:
831: x_return_status := FND_API.g_ret_sts_error;

Line 918: FND_MESSAGE.set_name('AMS', 'AMS_SETUP_ATTR_INVALID_ESS_FLG');

914: l_mand_setup_attr := l_mand_setup_attr_rec.meaning;
915: CLOSE c_mand_setup_attr;
916: END IF;
917: END IF;
918: FND_MESSAGE.set_name('AMS', 'AMS_SETUP_ATTR_INVALID_ESS_FLG');
919: FND_MESSAGE.set_token('ESS_SETUP_ATTR', l_mand_setup_attr);
920: -- End Add by cgoyal
921: FND_MSG_PUB.add;
922: END IF;

Line 919: FND_MESSAGE.set_token('ESS_SETUP_ATTR', l_mand_setup_attr);

915: CLOSE c_mand_setup_attr;
916: END IF;
917: END IF;
918: FND_MESSAGE.set_name('AMS', 'AMS_SETUP_ATTR_INVALID_ESS_FLG');
919: FND_MESSAGE.set_token('ESS_SETUP_ATTR', l_mand_setup_attr);
920: -- End Add by cgoyal
921: FND_MSG_PUB.add;
922: END IF;
923: x_return_status := FND_API.g_ret_sts_error;

Line 942: FND_MESSAGE.set_name('AMS', 'AMS_SETUP_ATTR_INVALID_AVL_FLG');

938: ELSE
939: l_mand_setup_attr := l_mand_setup_attr_rec.meaning;
940: CLOSE c_mand_setup_attr;
941: END IF;
942: FND_MESSAGE.set_name('AMS', 'AMS_SETUP_ATTR_INVALID_AVL_FLG');
943: FND_MESSAGE.set_token('MAND_SETUP_ATTR', l_mand_setup_attr);
944: -- End Add by cgoyal
945: FND_MSG_PUB.add;
946: END IF;

Line 943: FND_MESSAGE.set_token('MAND_SETUP_ATTR', l_mand_setup_attr);

939: l_mand_setup_attr := l_mand_setup_attr_rec.meaning;
940: CLOSE c_mand_setup_attr;
941: END IF;
942: FND_MESSAGE.set_name('AMS', 'AMS_SETUP_ATTR_INVALID_AVL_FLG');
943: FND_MESSAGE.set_token('MAND_SETUP_ATTR', l_mand_setup_attr);
944: -- End Add by cgoyal
945: FND_MSG_PUB.add;
946: END IF;
947: END IF;

Line 983: FND_MESSAGE.set_name('AMS', 'AMS_SETUP_ATTR_BAD_ESS_FLAG');

979: l_mand_setup_attr := l_mand_setup_attr_rec.meaning;
980: CLOSE c_mand_setup_attr;
981: END IF;
982: END IF;
983: FND_MESSAGE.set_name('AMS', 'AMS_SETUP_ATTR_BAD_ESS_FLAG');
984: FND_MESSAGE.set_token('ESS_SETUP_ATTR', l_mand_setup_attr);
985: -- End Add by cgoyal
986: FND_MSG_PUB.add;
987: END IF;

Line 984: FND_MESSAGE.set_token('ESS_SETUP_ATTR', l_mand_setup_attr);

980: CLOSE c_mand_setup_attr;
981: END IF;
982: END IF;
983: FND_MESSAGE.set_name('AMS', 'AMS_SETUP_ATTR_BAD_ESS_FLAG');
984: FND_MESSAGE.set_token('ESS_SETUP_ATTR', l_mand_setup_attr);
985: -- End Add by cgoyal
986: FND_MSG_PUB.add;
987: END IF;
988: x_return_status := FND_API.g_ret_sts_error;

Line 1008: FND_MESSAGE.set_name('AMS', 'AMS_SETUP_ATTR_BAD_AVAL_FLAG');

1004: l_mand_setup_attr := l_mand_setup_attr_rec.meaning;
1005: CLOSE c_mand_setup_attr;
1006: END IF;
1007: END IF;
1008: FND_MESSAGE.set_name('AMS', 'AMS_SETUP_ATTR_BAD_AVAL_FLAG');
1009: FND_MESSAGE.set_token('MAND_SETUP_ATTR', l_mand_setup_attr);
1010: -- End Add by cgoyal
1011: FND_MSG_PUB.add;
1012: END IF;

Line 1009: FND_MESSAGE.set_token('MAND_SETUP_ATTR', l_mand_setup_attr);

1005: CLOSE c_mand_setup_attr;
1006: END IF;
1007: END IF;
1008: FND_MESSAGE.set_name('AMS', 'AMS_SETUP_ATTR_BAD_AVAL_FLAG');
1009: FND_MESSAGE.set_token('MAND_SETUP_ATTR', l_mand_setup_attr);
1010: -- End Add by cgoyal
1011: FND_MSG_PUB.add;
1012: END IF;
1013: x_return_status := FND_API.g_ret_sts_error;

Line 1035: FND_MESSAGE.set_name('AMS', 'AMS_SETUP_ATTR_BAD_AVAL_FLAG');

1031: l_mand_setup_attr := l_mand_setup_attr_rec.meaning;
1032: CLOSE c_mand_setup_attr;
1033: END IF;
1034: END IF;
1035: FND_MESSAGE.set_name('AMS', 'AMS_SETUP_ATTR_BAD_AVAL_FLAG');
1036: FND_MESSAGE.set_token('MAND_SETUP_ATTR', l_mand_setup_attr);
1037: -- End Add by cgoyal
1038: FND_MSG_PUB.add;
1039: END IF;

Line 1036: FND_MESSAGE.set_token('MAND_SETUP_ATTR', l_mand_setup_attr);

1032: CLOSE c_mand_setup_attr;
1033: END IF;
1034: END IF;
1035: FND_MESSAGE.set_name('AMS', 'AMS_SETUP_ATTR_BAD_AVAL_FLAG');
1036: FND_MESSAGE.set_token('MAND_SETUP_ATTR', l_mand_setup_attr);
1037: -- End Add by cgoyal
1038: FND_MSG_PUB.add;
1039: END IF;
1040: x_return_status := FND_API.g_ret_sts_error;

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

1071: FETCH c_setup_attr INTO l_setup_attr_rec;
1072: IF (c_setup_attr%NOTFOUND) THEN
1073: CLOSE c_setup_attr;
1074: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1075: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1076: FND_MSG_PUB.add;
1077: END IF;
1078: RAISE FND_API.g_exc_error;
1079: END IF;