APPS.HZ_WORD_REPLACEMENT_PUB dependencies on FND_TERRITORIES

Line 538: FROM fnd_territories

534: --Check FK validations for country_code.
535: IF p_word_replacement_rec.country_code IS NOT NULL
536: AND p_word_replacement_rec.country_code <> FND_API.G_MISS_CHAR THEN
537: SELECT COUNT(*) INTO l_count
538: FROM fnd_territories
539: WHERE territory_code = p_word_replacement_rec.country_code;
540:
541: IF l_count = 0 THEN
542: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');

Line 545: FND_MESSAGE.SET_TOKEN('TABLE', 'fnd_territories');

541: IF l_count = 0 THEN
542: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
543: FND_MESSAGE.SET_TOKEN('FK', 'country_code');
544: FND_MESSAGE.SET_TOKEN('COLUMN', 'territory_code');
545: FND_MESSAGE.SET_TOKEN('TABLE', 'fnd_territories');
546: FND_MSG_PUB.ADD;
547: x_return_status := FND_API.G_RET_STS_ERROR;
548: END IF;
549: END IF;