APEX

Dear Friends,

I have authentication problem. When i login then display me

Error
ORA-28231: no data passed to obfuscation toolkit
'
i am using Apex 4.1
i am using custom authentication so i have created function to control authenticate user.

My Function

create or replace FUNCTION TI_CUSTOM_APEX_CRM_AUTH (
p_username IN VARCHAR2,
p_password IN VARCHAR2
)
RETURN BOOLEAN
IS
l_expires_on DATE;
l_count NUMBER;
BEGIN
SELECT COUNT (1)
INTO l_count
FROM user_mas
WHERE user_id = UPPER(p_username)
and UPPER(PK_ENCRYPTION.FN_DECRYPT(USER_PASS_NEW)) = UPPER(RPAD(P_PASSWORD,16,'~'));
DBMS_OUTPUT.PUT_LINE(L_COUNT);
IF l_count > 0 THEN
RETURN TRUE;
ELSE
RETURN FALSE;
END IF;
END;

i have call that function in authentication scheme.
i have pass four process on login page

10. 

begin
owa_util.mime_header('text/html', FALSE);
owa_cookie.send(
    name=>'LOGIN_USERNAME_COOKIE',
    value=>lower(:P460_USERNAME));
exception when others then null;
end;


20. wwv_flow_custom_auth_std.login(
    P_UNAME       => :P460_USERNAME,
    P_PASSWORD    => :P460_PASSWORD,
    P_SESSION_ID  => v('APP_SESSION'),
    P_FLOW_PAGE   => :APP_ID||':107'
    );
30.clear cache page 460

here is problem ,when i use three user_id (0002,0011,0012) then login if i use 0015 or 0017 or 0018 then display me
Error
ORA-28231: no data passed to obfuscation toolkit

to remove this error i have reset password using query
UPDATE USER_MAS SET user_pass_new=pk_encryption.fn_encrypt(RPAD('password',16,'~')) where user_id='0015'
UPDATE USER_MAS SET user_pass_new=pk_encryption.fn_encrypt(RPAD('password',16,'~')) where user_id='0016'
UPDATE USER_MAS SET user_pass_new=pk_encryption.fn_encrypt(RPAD('password',16,'~')) where user_id='0017'

How to resolve this error.

Could you please tell me if there is option to verify or print any massage with error raise what password i enter and what system it read which i enter into password field.

Thanks

Edited by: Vedant on Oct 29, 2012 3:44 AM