0ORA-0000: normal, successful completion -API error

Error : 

error-2 0ORA-0000: normal, successful completion

Scnario:

when updating customer sites using  hz_location_v2pub.update_location

Solution

 SELECT object_version_number
           INTO l_object_version_number
           FROM hz_locations
          WHERE location_id = l_location_id;