I build a quick demo for those of you who need the "good old Oracle Forms" Alert functionality in APEX.
IF [condition] THEN
Alert("the alert message!", OK, Cancel);
There's not much to explain. As usual, you'll find all the code on the demo page.
Here's the working demo of an Alert Message initiated by PL/SQL code.