This record in table hz_customer_profiles cannot be locked as it has been updated by another user.

The current Object Version Number did not assign to p_object_version_number value before calling public API.

HZ_CUSTOMER_PROFILE_V2PUB.UPDATE_CUSTOMER_PROFILE API

Please add the following in script before calling API

SELECT object_version_number
INTO in_out_object_version_number
FROM hz_customer_profiles
WHERE cust_account_profile_id = &cust_account_profile_id;