Make Concurrent Program error out by adding logic to PL/SQL

HI Gurus

I have a requirement the program to error out if certain conditions are met, For example, if the Profile Option is not enabled, the program will error out with the message that profile option is not enabled.

Wrote a program in PL/SQL and defined a concurrent program for this.

Added an exception clause to the select and added RAISE as exception so that the program errors out.

-- For Example

BEGIN

SELECT enabled_flag

INTO      'Y'

FROM FND_PROFILE_VALUES

WHERE VALUE_NAME = 'X';

EXCEPTION

WHEN OTHERS THEN

  FND_FILE.put_line(FND_FILE.LOG,TO_CHAR(SYSDATE,'DD-MON-YYYY HH:MI:SS')||'Profile Option'||'X'||'is not set');