APPS.HZ_GEOGRAPHY_VALIDATE_PVT dependencies on FND_TERRITORIES

Line 671: -- validate geography_code for FK to FND_TERRITORIES if geography_type is 'COUNTRY'

667: x_return_status => x_return_status);
668: END IF;
669: END LOOP;
670: END IF;
671: -- validate geography_code for FK to FND_TERRITORIES if geography_type is 'COUNTRY'
672: IF p_master_geography_rec.geography_type = 'COUNTRY' THEN
673: SELECT count(*) INTO l_count
674: FROM FND_TERRITORIES
675: WHERE territory_code = UPPER(p_master_geography_rec.geography_code);

Line 674: FROM FND_TERRITORIES

670: END IF;
671: -- validate geography_code for FK to FND_TERRITORIES if geography_type is 'COUNTRY'
672: IF p_master_geography_rec.geography_type = 'COUNTRY' THEN
673: SELECT count(*) INTO l_count
674: FROM FND_TERRITORIES
675: WHERE territory_code = UPPER(p_master_geography_rec.geography_code);
676: IF l_count = 0 THEN
677: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
678: fnd_message.set_token('FK','territory_code');

Line 680: fnd_message.set_token('TABLE','FND_TERRITORIES');

676: IF l_count = 0 THEN
677: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
678: fnd_message.set_token('FK','territory_code');
679: fnd_message.set_token('COLUMN', 'geography_code');
680: fnd_message.set_token('TABLE','FND_TERRITORIES');
681: fnd_msg_pub.add;
682: x_return_status := fnd_api.g_ret_sts_error;
683: END IF;
684: END IF;