DBA Data[Home] [Help]

APPS.HZ_ORG_INFO_VALIDATE dependencies on HZ_INDUSTRIAL_CLASSES

Line 844: FROM hz_industrial_classes

840: IF p_industrial_class_app_rec.industrial_class_id is NOT NULL AND
841: p_industrial_class_app_rec.industrial_class_id <> FND_API.G_MISS_NUM THEN
842:
843: SELECT COUNT(*) INTO l_count
844: FROM hz_industrial_classes
845: where industrial_class_id = p_industrial_class_app_rec.industrial_class_id;
846:
847: IF l_count = 0 THEN
848: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');

Line 851: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_industrial_classes');

847: IF l_count = 0 THEN
848: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
849: FND_MESSAGE.SET_TOKEN('FK', 'industrial_class_id');
850: FND_MESSAGE.SET_TOKEN('COLUMN', 'industrial_class_id');
851: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_industrial_classes');
852: FND_MSG_PUB.ADD;
853: x_return_status := FND_API.G_RET_STS_ERROR;
854:
855: END IF;