APPS.HZ_PARTY_CONTACT_V2PUB dependencies on HZ_RELATIONSHIP_TYPES

Line 181: FROM HZ_RELATIONSHIP_TYPES

177: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;
178:
179: CURSOR c_rel IS
180: SELECT BACKWARD_REL_CODE
181: FROM HZ_RELATIONSHIP_TYPES
182: WHERE RELATIONSHIP_TYPE = p_org_contact_rec.party_rel_rec.relationship_type
183: AND FORWARD_REL_CODE = p_org_contact_rec.party_rel_rec.relationship_code
184: AND SUBJECT_TYPE = p_org_contact_rec.party_rel_rec.subject_type
185: AND OBJECT_TYPE = p_org_contact_rec.party_rel_rec.object_type

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

263: IF c_rel%NOTFOUND THEN
264: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
265: FND_MESSAGE.SET_TOKEN('FK', 'relationship_code, subject_type, object_type');
266: FND_MESSAGE.SET_TOKEN('COLUMN', 'forward_rel_code, subject_type, object_type');
267: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_relationship_types');
268: FND_MSG_PUB.ADD;
269: RAISE FND_API.G_EXC_ERROR;
270: END IF;
271: CLOSE c_rel;