Generally Oracle applications user password is reset/changed through the System administrator> Define user form.
But if you would like to do the same programmatically then this is the way.
Use the following script.
if fnd_user_pkg.changepassword(username => ‘USER’
,newpassword => ‘pwd’) then
Note :USER is the User Name, pwd is the new password that you would like to set.