665: FND_MSG_PUB.ADD;
666: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
667: END;
668:
669: --Validate INVENTORY_ITEM_ID, INVENTORY_ORG_ID, ITEM_REVISION from AHL_ITEM_ASSOCIATIONS_B
670: BEGIN
671: SELECT 'Y'
672: INTO l_dummy
673: FROM dual
671: SELECT 'Y'
672: INTO l_dummy
673: FROM dual
674: WHERE EXISTS(SELECT 'X'
675: FROM ahl_mc_relationships mcr, ahl_item_associations_b ia
676: WHERE mcr.relationship_id = l_ra_def_hdr_rec.RELATIONSHIP_ID
677: AND mcr.item_group_id = ia.item_group_id
678: AND ia.inventory_item_id = l_ra_def_hdr_rec.INVENTORY_ITEM_ID
679: AND ia.inventory_org_id = l_ra_def_hdr_rec.INVENTORY_ORG_ID