Login
Register

Home

Trainings

Fusion Blog

EBS Blog

Authors

Contact Us

Oracle Workflows - All Articles
  • Register

Oracle Gold Partners, our very popular training packages, training schedule is listed here
Designed by Five Star Rated Oracle Press Authors & Oracle ACE's.

webinar new Click here to raise Support Ticket. Get reply within 48 hours.

Search Courses

User Rating: 4 / 5

Star ActiveStar ActiveStar ActiveStar ActiveStar Inactive
 
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         => '___________________________________________________________________________________________________
<br>
<CENTER><b><font size=+1>Annual Return 2003</font></b></CENTER>
<br>____________________________________________________________________________________________________
<p>
<CENTER><b>DECLARATION OF INTERESTS</b></CENTER><b></b>
<p>
Each member of Company must respond, whether full or part time.
<br><b>
To be completed even if the return is zero</b><b></b>
<p><b>Full Name </b>Anil Passi
<br><b>Employee Number
</b>163707
<p>
This return covers the period between 1 August 2002 and 31 July 2003. The
information you
<br>
give should relate to this period only
<p><b>During this period have you occupied a position of Director, Partner,
Consultant, Trustee or Trader?</b>
</body>
</html>');
  dbms_output.put_line('n_not_id: ' || n_not_id);
  commit;
END;
/

Anil Passi

Comments   

0 #1 Sai 2008-02-27 15:20
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
Quote
0 #2 Anil Passi 2008-02-27 16:12
Indeed, you can use the generic API that I have contributed to open source to achieve the desired result.

Cheers
Anil Passi
Quote
0 #3 Anoop Dangui 2008-03-03 09:17
Hi Anil,

Is this a custom API? or a seeded one ? Can we use this in any of our user procedure?
Quote
0 #4 Raven 2009-03-20 03:27
hi sir,
Could you provide source code for this package 'xx_notificatio ns_api_pkg'.
I wan to know how did you to implement it in your package.
Quote
0 #5 meetvass 2010-02-19 11:26
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
Sriniva s
Quote
0 #6 emre 2013-06-06 04:02
hi how can ? reach tho source of the xx_notification s_api_pkg ?
Quote
0 #7 mahesh.budhanam 2013-11-09 04:04
Hi,

i am trying to send notification to application and it was working fine but my problem in add_query procedure i want pass bindvariable plz send me any script by useing bindvairables in add_query procedure.
Quote

Add comment


Security code
Refresh

Search Trainings

Fully verifiable testimonials

Apps2Fusion - Event List

<<  Jun 2021  >>
 Mon  Tue  Wed  Thu  Fri  Sat  Sun 
   1  2  3  4  5  6
  7  8  910111213
14151617181920
21222324252627
282930    

Enquire For Training

Related Items

Fusion Training Packages

Get Email Updates


Powered by Google FeedBurner