How to send HTML Based Notification by a mere PL/SQL Call?

How to send HTML Based Notification by a mere PL/SQL Call?

To see a notification as below.
If there is an email attached to the WF Role of recepient, then an Email will be sent out to that recepient with the contents as shown below.

Run the API, as shown below

DECLARE
n_not_id INTEGER;
BEGIN
xx_notifications_api_pkg.send_notification(
x_email_address => ''
,x_user_name => 'PASSIA'
,x_notification_api_id => n_not_id
,x_message_type => 'TEXT_AND_QUERY'
,x_process_short_code=> 'TEST'
,x_message_subject => 'Annual Return 2001'
,x_response_lookup_type => ''
,x_message_text => '___________________________________________________________________________________________________
 
<CENTER>Annual Return 2003</CENTER>
 ____________________________________________________________________________________________________

<CENTER>DECLARATION OF INTERESTS</CENTER>

Each member of Company must respond, whether full or part time.
 
To be completed even if the return is zero
Full Name Anil Passi
 Employee Number
163707

This return covers the period between 1 August 2002 and 31 July 2003. The
information you
 
give should relate to this period only
During this period have you occupied a position of Director, Partner,
Consultant, Trustee or Trader?
</body>
</html>');
dbms_output.put_line('n_not_id: ' || n_not_id);
commit;
END;
/

Set as favorite

Bookmark

Email This

Comments (5)

Subscribe to this comment's feed

Recommendation requested.
written by Michael Clayback , February 27, 2008

We are using Oracle TeleSales and would like to send an email notification to the sales rep when an opportunity status is updated to ready for quote. Calling the pl/sql api from a forms personalization sure looks like the most efficient way when compared to Alerts or Custom Workflow. Any recommendation?

Thanks - Mike

report abuse

vote down

vote up

Votes: +0

...
written by Anil Passi , February 27, 2008

Indeed, you can use the generic API that I have contributed to open source to achieve the desired result.

Cheers
Anil Passi

report abuse

vote down

vote up

Votes: +0

...
written by Anoop Dangui , March 03, 2008

Hi Anil,

Is this a custom API? or a seeded one ? Can we use this in any of our user procedure?

report abuse

vote down

vote up

Votes: +0

Provide source code for this package 'xx_notifications_api_pkg'.
written by Raven , March 20, 2009

hi sir,
Could you provide source code for this package 'xx_notifications_api_pkg'.
I wan to know how did you to implement it in your package.

report abuse

vote down

vote up

Votes: +0

Oracle Techno/func Consultant
written by meetvass , February 19, 2010

Good Day,

I have to develop the same functionality , thank god you have this code, can you please help me.

Please provide me the source code or suggest me how to send HTML notifications.

Thanks
Srinivas

report abuse

vote down

vote up

Votes: +0

Write comment

Name

Title

Comment