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;
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:
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;
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;
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;
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;
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;
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:
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;
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:
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;
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: */
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;
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:
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;
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: */
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;
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:
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;
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:
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;
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:
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;
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: */
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;
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
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;
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;
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;