DBA Data[Home] [Help]

APPS.AMS_VENUE_RATES_PVT dependencies on FND_MESSAGE

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

685:
686: IF (c_Venue_Rates%NOTFOUND) THEN
687: CLOSE c_Venue_Rates;
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 791: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');

787: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
788:
789: /*
790: IF p_venue_rates_rec.rate_id = FND_API.g_miss_num OR p_venue_rates_rec.rate_id IS NULL THEN
791: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');
792: FND_MESSAGE.set_token('MISS_FIELD','RATE_ID');
793: FND_MESSAGE.set_name('AMS', 'AMS_MISS_RATE_ID');
794: FND_MSG_PUB.Add;
795:

Line 792: FND_MESSAGE.set_token('MISS_FIELD','RATE_ID');

788:
789: /*
790: IF p_venue_rates_rec.rate_id = FND_API.g_miss_num OR p_venue_rates_rec.rate_id IS NULL THEN
791: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');
792: FND_MESSAGE.set_token('MISS_FIELD','RATE_ID');
793: FND_MESSAGE.set_name('AMS', 'AMS_MISS_RATE_ID');
794: FND_MSG_PUB.Add;
795:
796: x_return_status := FND_API.g_ret_sts_error;

Line 793: FND_MESSAGE.set_name('AMS', 'AMS_MISS_RATE_ID');

789: /*
790: IF p_venue_rates_rec.rate_id = FND_API.g_miss_num OR p_venue_rates_rec.rate_id IS NULL THEN
791: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');
792: FND_MESSAGE.set_token('MISS_FIELD','RATE_ID');
793: FND_MESSAGE.set_name('AMS', 'AMS_MISS_RATE_ID');
794: FND_MSG_PUB.Add;
795:
796: x_return_status := FND_API.g_ret_sts_error;
797: RETURN;

Line 802: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');

798: END IF;
799:
800:
801: IF p_venue_rates_rec.last_update_date = FND_API.g_miss_date OR p_venue_rates_rec.last_update_date IS NULL THEN
802: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');
803: FND_MESSAGE.set_token('MISS_FIELD','LAST_UPDATE_DATE');
804:
805: x_return_status := FND_API.g_ret_sts_error;
806: RETURN;

Line 803: FND_MESSAGE.set_token('MISS_FIELD','LAST_UPDATE_DATE');

799:
800:
801: IF p_venue_rates_rec.last_update_date = FND_API.g_miss_date OR p_venue_rates_rec.last_update_date IS NULL THEN
802: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');
803: FND_MESSAGE.set_token('MISS_FIELD','LAST_UPDATE_DATE');
804:
805: x_return_status := FND_API.g_ret_sts_error;
806: RETURN;
807: END IF;

Line 811: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');

807: END IF;
808:
809:
810: IF p_venue_rates_rec.last_updated_by = FND_API.g_miss_num OR p_venue_rates_rec.last_updated_by IS NULL THEN
811: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');
812: FND_MESSAGE.set_token('MISS_FIELD','LAST_UPDATED_BY');
813: x_return_status := FND_API.g_ret_sts_error;
814: RETURN;
815: END IF;

Line 812: FND_MESSAGE.set_token('MISS_FIELD','LAST_UPDATED_BY');

808:
809:
810: IF p_venue_rates_rec.last_updated_by = FND_API.g_miss_num OR p_venue_rates_rec.last_updated_by IS NULL THEN
811: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');
812: FND_MESSAGE.set_token('MISS_FIELD','LAST_UPDATED_BY');
813: x_return_status := FND_API.g_ret_sts_error;
814: RETURN;
815: END IF;
816:

Line 819: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');

815: END IF;
816:
817:
818: IF p_venue_rates_rec.creation_date = FND_API.g_miss_date OR p_venue_rates_rec.creation_date IS NULL THEN
819: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');
820: FND_MESSAGE.set_token('MISS_FIELD','CREATION_DATE');
821: x_return_status := FND_API.g_ret_sts_error;
822: RETURN;
823: END IF;

Line 820: FND_MESSAGE.set_token('MISS_FIELD','CREATION_DATE');

816:
817:
818: IF p_venue_rates_rec.creation_date = FND_API.g_miss_date OR p_venue_rates_rec.creation_date IS NULL THEN
819: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');
820: FND_MESSAGE.set_token('MISS_FIELD','CREATION_DATE');
821: x_return_status := FND_API.g_ret_sts_error;
822: RETURN;
823: END IF;
824:

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

823: END IF;
824:
825:
826: IF p_venue_rates_rec.created_by = FND_API.g_miss_num OR p_venue_rates_rec.created_by IS NULL THEN
827: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');
828: FND_MESSAGE.set_token('MISS_FIELD','CREATED_BY');
829: x_return_status := FND_API.g_ret_sts_error;
830: RETURN;
831: END IF;

Line 828: FND_MESSAGE.set_token('MISS_FIELD','CREATED_BY');

824:
825:
826: IF p_venue_rates_rec.created_by = FND_API.g_miss_num OR p_venue_rates_rec.created_by IS NULL THEN
827: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');
828: FND_MESSAGE.set_token('MISS_FIELD','CREATED_BY');
829: x_return_status := FND_API.g_ret_sts_error;
830: RETURN;
831: END IF;
832: */

Line 835: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');

831: END IF;
832: */
833:
834: IF p_venue_rates_rec.venue_id = FND_API.g_miss_num OR p_venue_rates_rec.venue_id IS NULL THEN
835: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');
836: FND_MESSAGE.set_token('MISS_FIELD','VENUE_ID');
837: x_return_status := FND_API.g_ret_sts_error;
838: RETURN;
839: END IF;

Line 836: FND_MESSAGE.set_token('MISS_FIELD','VENUE_ID');

832: */
833:
834: IF p_venue_rates_rec.venue_id = FND_API.g_miss_num OR p_venue_rates_rec.venue_id IS NULL THEN
835: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');
836: FND_MESSAGE.set_token('MISS_FIELD','VENUE_ID');
837: x_return_status := FND_API.g_ret_sts_error;
838: RETURN;
839: END IF;
840:

Line 844: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');

840:
841: -- Following code is commented by GMADANA
842: /*
843: IF p_venue_rates_rec.metric_id = FND_API.g_miss_num OR p_venue_rates_rec.metric_id IS NULL THEN
844: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');
845: FND_MESSAGE.set_token('MISS_FIELD','METRIC_ID');
846: x_return_status := FND_API.g_ret_sts_error;
847: RETURN;
848: END IF;

Line 845: FND_MESSAGE.set_token('MISS_FIELD','METRIC_ID');

841: -- Following code is commented by GMADANA
842: /*
843: IF p_venue_rates_rec.metric_id = FND_API.g_miss_num OR p_venue_rates_rec.metric_id IS NULL THEN
844: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');
845: FND_MESSAGE.set_token('MISS_FIELD','METRIC_ID');
846: x_return_status := FND_API.g_ret_sts_error;
847: RETURN;
848: END IF;
849: */

Line 853: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');

849: */
850:
851:
852: IF p_venue_rates_rec.transactional_value = FND_API.g_miss_num OR p_venue_rates_rec.transactional_value IS NULL THEN
853: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');
854: FND_MESSAGE.set_token('MISS_FIELD','TRANSACTIONAL_VALUE');
855: x_return_status := FND_API.g_ret_sts_error;
856: RETURN;
857: END IF;

Line 854: FND_MESSAGE.set_token('MISS_FIELD','TRANSACTIONAL_VALUE');

850:
851:
852: IF p_venue_rates_rec.transactional_value = FND_API.g_miss_num OR p_venue_rates_rec.transactional_value IS NULL THEN
853: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');
854: FND_MESSAGE.set_token('MISS_FIELD','TRANSACTIONAL_VALUE');
855: x_return_status := FND_API.g_ret_sts_error;
856: RETURN;
857: END IF;
858:

Line 861: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');

857: END IF;
858:
859:
860: IF p_venue_rates_rec.transactional_currency_code = FND_API.g_miss_char OR p_venue_rates_rec.transactional_currency_code IS NULL THEN
861: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');
862: FND_MESSAGE.set_token('MISS_FIELD','TRANSACTIONAL_CURRENCY_CODE');
863: x_return_status := FND_API.g_ret_sts_error;
864: RETURN;
865: END IF;

Line 862: FND_MESSAGE.set_token('MISS_FIELD','TRANSACTIONAL_CURRENCY_CODE');

858:
859:
860: IF p_venue_rates_rec.transactional_currency_code = FND_API.g_miss_char OR p_venue_rates_rec.transactional_currency_code IS NULL THEN
861: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');
862: FND_MESSAGE.set_token('MISS_FIELD','TRANSACTIONAL_CURRENCY_CODE');
863: x_return_status := FND_API.g_ret_sts_error;
864: RETURN;
865: END IF;
866:

Line 869: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');

865: END IF;
866:
867: /*
868: IF p_venue_rates_rec.functional_value = FND_API.g_miss_num OR p_venue_rates_rec.functional_value IS NULL THEN
869: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');
870: FND_MESSAGE.set_token('MISS_FIELD','FUNCTIONAL_VALUE');
871: x_return_status := FND_API.g_ret_sts_error;
872: RETURN;
873: END IF;

Line 870: FND_MESSAGE.set_token('MISS_FIELD','FUNCTIONAL_VALUE');

866:
867: /*
868: IF p_venue_rates_rec.functional_value = FND_API.g_miss_num OR p_venue_rates_rec.functional_value IS NULL THEN
869: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');
870: FND_MESSAGE.set_token('MISS_FIELD','FUNCTIONAL_VALUE');
871: x_return_status := FND_API.g_ret_sts_error;
872: RETURN;
873: END IF;
874:

Line 877: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');

873: END IF;
874:
875:
876: IF p_venue_rates_rec.functional_currency_code = FND_API.g_miss_char OR p_venue_rates_rec.functional_currency_code IS NULL THEN
877: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');
878: FND_MESSAGE.set_token('MISS_FIELD','FUNCTIONAL_CURRENCY_CODE');
879: x_return_status := FND_API.g_ret_sts_error;
880: RETURN;
881: END IF;

Line 878: FND_MESSAGE.set_token('MISS_FIELD','FUNCTIONAL_CURRENCY_CODE');

874:
875:
876: IF p_venue_rates_rec.functional_currency_code = FND_API.g_miss_char OR p_venue_rates_rec.functional_currency_code IS NULL THEN
877: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');
878: FND_MESSAGE.set_token('MISS_FIELD','FUNCTIONAL_CURRENCY_CODE');
879: x_return_status := FND_API.g_ret_sts_error;
880: RETURN;
881: END IF;
882: */

Line 885: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');

881: END IF;
882: */
883:
884: IF p_venue_rates_rec.uom_code = FND_API.g_miss_char OR p_venue_rates_rec.uom_code IS NULL THEN
885: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');
886: FND_MESSAGE.set_token('MISS_FIELD','UOM_CODE');
887: x_return_status := FND_API.g_ret_sts_error;
888: RETURN;
889: END IF;

Line 886: FND_MESSAGE.set_token('MISS_FIELD','UOM_CODE');

882: */
883:
884: IF p_venue_rates_rec.uom_code = FND_API.g_miss_char OR p_venue_rates_rec.uom_code IS NULL THEN
885: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');
886: FND_MESSAGE.set_token('MISS_FIELD','UOM_CODE');
887: x_return_status := FND_API.g_ret_sts_error;
888: RETURN;
889: END IF;
890: ELSE

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

1004: ) = FND_API.g_false
1005: THEN
1006: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1007: THEN
1008: -- FND_MESSAGE.set_name('AMS', 'AMS_BAD_RATE_TYPE');
1009: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');
1010: FND_MESSAGE.set_token('MISS_FIELD','RATE_CODE');
1011: FND_MSG_PUB.add;
1012: END IF;

Line 1009: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');

1005: THEN
1006: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1007: THEN
1008: -- FND_MESSAGE.set_name('AMS', 'AMS_BAD_RATE_TYPE');
1009: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');
1010: FND_MESSAGE.set_token('MISS_FIELD','RATE_CODE');
1011: FND_MSG_PUB.add;
1012: END IF;
1013: x_return_status := FND_API.g_ret_sts_error;

Line 1010: FND_MESSAGE.set_token('MISS_FIELD','RATE_CODE');

1006: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1007: THEN
1008: -- FND_MESSAGE.set_name('AMS', 'AMS_BAD_RATE_TYPE');
1009: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');
1010: FND_MESSAGE.set_token('MISS_FIELD','RATE_CODE');
1011: FND_MSG_PUB.add;
1012: END IF;
1013: x_return_status := FND_API.g_ret_sts_error;
1014: RETURN;