I was creating a custom function (for demo purposes) and was stumbled with this error.
ORA-44004: invalid qualified SQL name
I was referring to my code in APEX 4.0 which was calling the procedure as return f_validate; I was trying to do the same in APEX 4.2.1 also. But I was continuously bugged by this or some other error.