APPS.HZ_HIERARCHY_V2PUB dependencies on HZ_RELATIONSHIP_TYPES

Line 135: FROM HZ_RELATIONSHIP_TYPES

131: --------------------------
132:
133: BEGIN
134: SELECT HIERARCHICAL_FLAG INTO l_dummy
135: FROM HZ_RELATIONSHIP_TYPES
136: WHERE RELATIONSHIP_TYPE = p_hierarchy_type
137: AND ROWNUM = 1;
138:
139: IF l_dummy <> 'Y' THEN

Line 152: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_relationship_types');

148: -- no relationship type record found, so error out NOCOPY
149: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
150: FND_MESSAGE.SET_TOKEN('FK', 'hierarchy_type');
151: FND_MESSAGE.SET_TOKEN('COLUMN', 'relationship_type');
152: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_relationship_types');
153: FND_MSG_PUB.ADD;
154: x_return_status := fnd_api.g_ret_sts_error;
155: END;
156: