Validate oracle apps R12 application login throuhg sqlplus

Use the following select:

fnd_web_sec.validate_login(USERNAME,PASSWORD)

Example:
select fnd_web_sec.validate_login('sysadmin','oracle123') from dual;