APEX

Hi,

Trying to set up a simple email sender service.Have Followed HowTo doc.
Works fine with the Sample Application.But failed when reproducing the
same process within my application.
Thks for your advise.

----------------------
PAGE CONTENTS:

Item1 Name = "P2_SENDER";
Item1 Type = Text field; 
Item2 Name = "P2_PERSON_ID";

Item2 Type = Popup LOV to display desc and return id;
Item2 Source type = "Database Column";
Item2 Source value = PEOPLE_ID
Item2 Lov Definition =
"SELECT Name||'  -  '||Age||'  -  '||Role display_value,
Person_id return_value 
FROM People"

Process 
Name = "Send_Email";
Type = "PL/SQL";
Process point = "On submit after computations...";
Condition = "When Button Pressed";
Source =
"FOR c1 IN (SELECT email
             FROM People
            WHERE Person_id = :P2_PERSON_ID) LOOP
  IF c1.email IS NOT NULL THEN
    HTMLDB_MAIL.SEND(
      P_TO       => c1.cust_email,
      P_FROM     => :P2_SENDER,
      P_BODY     => 'Blablablablabla'||chr(10)||
         'Blablablablabla.',
      P_SUBJ     => 'Sent Email Test');
  END IF;
END LOOP;
"