PMS Appraisal Completing From Backend Creating Problems ?

Hi.. I have a client requirement to complete the appraisal from back end. I used hr_appraisals_api.update_appraisal to achieve this task. But the problem is if we directly use this API to complete the appraisals, the corresponding data is not populating in per_performance_reviews table because of which the data for completed Appraisals using API (hr_appraisals_api.update_appraisal) is not appearing in the 'My Information' tab. Now when I tried generating the data in per_performance_reviews table, it is throwing the error SQLERRM ORA-20001: The performance rating which was entered is invalid though the performance rating I have entered is as per the PERFORMANCE_RATINGS lookup.