eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WF_MAIL dependencies on WF_XML

Line 294: wf_xml.setFirstMessage('TRUE');

290:
291: -- Dequeue from the exception queue
292: -- and re-enqueue the message.
293: l_timeout := FALSE;
294: wf_xml.setFirstMessage('TRUE');
295: while not l_timeout loop
296: wf_xml.GetExceptionMessage(p_queue, l_nid, l_recipient, l_status,
297: l_timeout, l_error_result);
298: if ( not l_timeout ) then

Line 296: wf_xml.GetExceptionMessage(p_queue, l_nid, l_recipient, l_status,

292: -- and re-enqueue the message.
293: l_timeout := FALSE;
294: wf_xml.setFirstMessage('TRUE');
295: while not l_timeout loop
296: wf_xml.GetExceptionMessage(p_queue, l_nid, l_recipient, l_status,
297: l_timeout, l_error_result);
298: if ( not l_timeout ) then
299: update WF_NOTIFICATIONS N
300: set N.MAIL_STATUS = 'MAIL'

Line 302: -- wf_xml.EnqueueNotification(l_nid);

298: if ( not l_timeout ) then
299: update WF_NOTIFICATIONS N
300: set N.MAIL_STATUS = 'MAIL'
301: where N.NOTIFICATION_ID = l_nid;
302: -- wf_xml.EnqueueNotification(l_nid);
303: end if;
304: end loop;
305: commit;
306:

Line 955: -- wf_xml.enqueueNotification(nid);

951: -- Set the mail_status to INVALID (mailer will pick this up)
952: update WF_NOTIFICATIONS
953: set MAIL_STATUS = 'INVALID'
954: where NOTIFICATION_ID = nid;
955: -- wf_xml.enqueueNotification(nid);
956:
957: select recipient_role, group_id, message_type, message_name
958: into role, group_id, mType, mName
959: from wf_notifications

Line 5092: -- Below Allocated TEMP LOB here is released within WF_XML.getBodyPart

5088: t_headerText := '';
5089: t_headerHTML := '';
5090: step := 'Getting body';
5091: if (r_ntf_pref in ('MAILTEXT', 'MAILATTH')) then
5092: -- Below Allocated TEMP LOB here is released within WF_XML.getBodyPart
5093: -- ( which is called by caller of getLOBMessage3 API)
5094: -- based on the Ntf type (text/plain or text/html) by calling wf_mail.CloseLOB
5095: g_text_messageIdx := wf_temp_lob.getLob(g_LOBTable);
5096:

Line 5128: -- Below Allocated TEMP LOB IS released within WF_XML.getBodyPart

5124: end if;
5125: end if;
5126:
5127: if (r_ntf_pref in ('MAILHTML', 'MAILATTH', 'MAILHTM2')) then
5128: -- Below Allocated TEMP LOB IS released within WF_XML.getBodyPart
5129: -- based on the Ntf type (text/plain or text/html) by calling wf_mail.CloseLOB
5130: g_html_messageIdx := wf_temp_lob.getLob(g_LOBTable);
5131:
5132: if (renderbody = 'Y') then

Line 7548: l_attrlist wf_xml.wf_xml_attr_table_type;

7544: p_fyi_flag in varchar2)
7545: is
7546: l_module varchar2(10);
7547: l_str varchar2(4000);
7548: l_attrlist wf_xml.wf_xml_attr_table_type;
7549: l_pos integer;
7550: l_amt number;
7551:
7552: l_msg_doc clob;

Line 7643: wf_xml.AddElementAttribute('maxcount', '1', l_attrlist);

7639: l_pos := length(l_str);
7640: dbms_lob.write(l_msg_doc, l_pos, 1, l_str);
7641:
7642: -- begin
7643: wf_xml.AddElementAttribute('maxcount', '1', l_attrlist);
7644: l_pos := wf_xml.NewLOBTag(l_msg_doc, l_pos, 'NOTIFICATIONGROUP', '', l_attrlist);
7645: l_attrlist.DELETE;
7646:
7647: l_nodename := WF_MAILER_PARAMETER.GetValueForCorr(p_module, 'NODENAME');

Line 7644: l_pos := wf_xml.NewLOBTag(l_msg_doc, l_pos, 'NOTIFICATIONGROUP', '', l_attrlist);

7640: dbms_lob.write(l_msg_doc, l_pos, 1, l_str);
7641:
7642: -- begin
7643: wf_xml.AddElementAttribute('maxcount', '1', l_attrlist);
7644: l_pos := wf_xml.NewLOBTag(l_msg_doc, l_pos, 'NOTIFICATIONGROUP', '', l_attrlist);
7645: l_attrlist.DELETE;
7646:
7647: l_nodename := WF_MAILER_PARAMETER.GetValueForCorr(p_module, 'NODENAME');
7648:

Line 7663: wf_xml.AddElementAttribute('nid', '0', l_attrlist);

7659: l_idstr := null;
7660: end if;
7661:
7662: -- begin
7663: wf_xml.AddElementAttribute('nid', '0', l_attrlist);
7664: wf_xml.AddElementAttribute('nidstr', l_idstr, l_attrlist);
7665: wf_xml.AddElementAttribute('language', p_language, l_attrlist);
7666: wf_xml.AddElementAttribute('territory', p_territory, l_attrlist);
7667: wf_xml.AddElementAttribute('codeset', p_codeset, l_attrlist);

Line 7664: wf_xml.AddElementAttribute('nidstr', l_idstr, l_attrlist);

7660: end if;
7661:
7662: -- begin
7663: wf_xml.AddElementAttribute('nid', '0', l_attrlist);
7664: wf_xml.AddElementAttribute('nidstr', l_idstr, l_attrlist);
7665: wf_xml.AddElementAttribute('language', p_language, l_attrlist);
7666: wf_xml.AddElementAttribute('territory', p_territory, l_attrlist);
7667: wf_xml.AddElementAttribute('codeset', p_codeset, l_attrlist);
7668:

Line 7665: wf_xml.AddElementAttribute('language', p_language, l_attrlist);

7661:
7662: -- begin
7663: wf_xml.AddElementAttribute('nid', '0', l_attrlist);
7664: wf_xml.AddElementAttribute('nidstr', l_idstr, l_attrlist);
7665: wf_xml.AddElementAttribute('language', p_language, l_attrlist);
7666: wf_xml.AddElementAttribute('territory', p_territory, l_attrlist);
7667: wf_xml.AddElementAttribute('codeset', p_codeset, l_attrlist);
7668:
7669: -- <>:

Line 7666: wf_xml.AddElementAttribute('territory', p_territory, l_attrlist);

7662: -- begin
7663: wf_xml.AddElementAttribute('nid', '0', l_attrlist);
7664: wf_xml.AddElementAttribute('nidstr', l_idstr, l_attrlist);
7665: wf_xml.AddElementAttribute('language', p_language, l_attrlist);
7666: wf_xml.AddElementAttribute('territory', p_territory, l_attrlist);
7667: wf_xml.AddElementAttribute('codeset', p_codeset, l_attrlist);
7668:
7669: -- <>:
7670: -- Setting default parameter's value until ALR team starts to pass

Line 7667: wf_xml.AddElementAttribute('codeset', p_codeset, l_attrlist);

7663: wf_xml.AddElementAttribute('nid', '0', l_attrlist);
7664: wf_xml.AddElementAttribute('nidstr', l_idstr, l_attrlist);
7665: wf_xml.AddElementAttribute('language', p_language, l_attrlist);
7666: wf_xml.AddElementAttribute('territory', p_territory, l_attrlist);
7667: wf_xml.AddElementAttribute('codeset', p_codeset, l_attrlist);
7668:
7669: -- <>:
7670: -- Setting default parameter's value until ALR team starts to pass
7671: -- below parameter's values.

Line 7673: wf_xml.AddElementAttribute('nlsDateformat', wf_core.nls_date_format, l_attrlist);

7669: -- <>:
7670: -- Setting default parameter's value until ALR team starts to pass
7671: -- below parameter's values.
7672: -- TODO>>
7673: wf_xml.AddElementAttribute('nlsDateformat', wf_core.nls_date_format, l_attrlist);
7674: wf_xml.AddElementAttribute('nlsDateLanguage', wf_core.nls_date_language, l_attrlist);
7675: wf_xml.AddElementAttribute('nlsNumericCharacters', wf_core.nls_numeric_characters, l_attrlist);
7676: wf_xml.AddElementAttribute('nlsSort', wf_core.nls_sort, l_attrlist);
7677:

Line 7674: wf_xml.AddElementAttribute('nlsDateLanguage', wf_core.nls_date_language, l_attrlist);

7670: -- Setting default parameter's value until ALR team starts to pass
7671: -- below parameter's values.
7672: -- TODO>>
7673: wf_xml.AddElementAttribute('nlsDateformat', wf_core.nls_date_format, l_attrlist);
7674: wf_xml.AddElementAttribute('nlsDateLanguage', wf_core.nls_date_language, l_attrlist);
7675: wf_xml.AddElementAttribute('nlsNumericCharacters', wf_core.nls_numeric_characters, l_attrlist);
7676: wf_xml.AddElementAttribute('nlsSort', wf_core.nls_sort, l_attrlist);
7677:
7678: wf_xml.AddElementAttribute('priority', '50', l_attrlist);

Line 7675: wf_xml.AddElementAttribute('nlsNumericCharacters', wf_core.nls_numeric_characters, l_attrlist);

7671: -- below parameter's values.
7672: -- TODO>>
7673: wf_xml.AddElementAttribute('nlsDateformat', wf_core.nls_date_format, l_attrlist);
7674: wf_xml.AddElementAttribute('nlsDateLanguage', wf_core.nls_date_language, l_attrlist);
7675: wf_xml.AddElementAttribute('nlsNumericCharacters', wf_core.nls_numeric_characters, l_attrlist);
7676: wf_xml.AddElementAttribute('nlsSort', wf_core.nls_sort, l_attrlist);
7677:
7678: wf_xml.AddElementAttribute('priority', '50', l_attrlist);
7679: wf_xml.AddElementAttribute('accesskey', '0', l_attrlist);

Line 7676: wf_xml.AddElementAttribute('nlsSort', wf_core.nls_sort, l_attrlist);

7672: -- TODO>>
7673: wf_xml.AddElementAttribute('nlsDateformat', wf_core.nls_date_format, l_attrlist);
7674: wf_xml.AddElementAttribute('nlsDateLanguage', wf_core.nls_date_language, l_attrlist);
7675: wf_xml.AddElementAttribute('nlsNumericCharacters', wf_core.nls_numeric_characters, l_attrlist);
7676: wf_xml.AddElementAttribute('nlsSort', wf_core.nls_sort, l_attrlist);
7677:
7678: wf_xml.AddElementAttribute('priority', '50', l_attrlist);
7679: wf_xml.AddElementAttribute('accesskey', '0', l_attrlist);
7680: wf_xml.AddElementAttribute('node', l_nodename, l_attrlist);

Line 7678: wf_xml.AddElementAttribute('priority', '50', l_attrlist);

7674: wf_xml.AddElementAttribute('nlsDateLanguage', wf_core.nls_date_language, l_attrlist);
7675: wf_xml.AddElementAttribute('nlsNumericCharacters', wf_core.nls_numeric_characters, l_attrlist);
7676: wf_xml.AddElementAttribute('nlsSort', wf_core.nls_sort, l_attrlist);
7677:
7678: wf_xml.AddElementAttribute('priority', '50', l_attrlist);
7679: wf_xml.AddElementAttribute('accesskey', '0', l_attrlist);
7680: wf_xml.AddElementAttribute('node', l_nodename, l_attrlist);
7681: wf_xml.AddElementAttribute('item_type', 'NULL', l_attrlist);
7682: wf_xml.AddElementAttribute('message_name', 'NULL', l_attrlist);

Line 7679: wf_xml.AddElementAttribute('accesskey', '0', l_attrlist);

7675: wf_xml.AddElementAttribute('nlsNumericCharacters', wf_core.nls_numeric_characters, l_attrlist);
7676: wf_xml.AddElementAttribute('nlsSort', wf_core.nls_sort, l_attrlist);
7677:
7678: wf_xml.AddElementAttribute('priority', '50', l_attrlist);
7679: wf_xml.AddElementAttribute('accesskey', '0', l_attrlist);
7680: wf_xml.AddElementAttribute('node', l_nodename, l_attrlist);
7681: wf_xml.AddElementAttribute('item_type', 'NULL', l_attrlist);
7682: wf_xml.AddElementAttribute('message_name', 'NULL', l_attrlist);
7683: wf_xml.AddElementAttribute('full-document', 'Y', l_attrlist);

Line 7680: wf_xml.AddElementAttribute('node', l_nodename, l_attrlist);

7676: wf_xml.AddElementAttribute('nlsSort', wf_core.nls_sort, l_attrlist);
7677:
7678: wf_xml.AddElementAttribute('priority', '50', l_attrlist);
7679: wf_xml.AddElementAttribute('accesskey', '0', l_attrlist);
7680: wf_xml.AddElementAttribute('node', l_nodename, l_attrlist);
7681: wf_xml.AddElementAttribute('item_type', 'NULL', l_attrlist);
7682: wf_xml.AddElementAttribute('message_name', 'NULL', l_attrlist);
7683: wf_xml.AddElementAttribute('full-document', 'Y', l_attrlist);
7684:

Line 7681: wf_xml.AddElementAttribute('item_type', 'NULL', l_attrlist);

7677:
7678: wf_xml.AddElementAttribute('priority', '50', l_attrlist);
7679: wf_xml.AddElementAttribute('accesskey', '0', l_attrlist);
7680: wf_xml.AddElementAttribute('node', l_nodename, l_attrlist);
7681: wf_xml.AddElementAttribute('item_type', 'NULL', l_attrlist);
7682: wf_xml.AddElementAttribute('message_name', 'NULL', l_attrlist);
7683: wf_xml.AddElementAttribute('full-document', 'Y', l_attrlist);
7684:
7685: if (p_callback_event is not null) then

Line 7682: wf_xml.AddElementAttribute('message_name', 'NULL', l_attrlist);

7678: wf_xml.AddElementAttribute('priority', '50', l_attrlist);
7679: wf_xml.AddElementAttribute('accesskey', '0', l_attrlist);
7680: wf_xml.AddElementAttribute('node', l_nodename, l_attrlist);
7681: wf_xml.AddElementAttribute('item_type', 'NULL', l_attrlist);
7682: wf_xml.AddElementAttribute('message_name', 'NULL', l_attrlist);
7683: wf_xml.AddElementAttribute('full-document', 'Y', l_attrlist);
7684:
7685: if (p_callback_event is not null) then
7686: wf_xml.AddElementAttribute('callback', p_callback_event, l_attrlist);

Line 7683: wf_xml.AddElementAttribute('full-document', 'Y', l_attrlist);

7679: wf_xml.AddElementAttribute('accesskey', '0', l_attrlist);
7680: wf_xml.AddElementAttribute('node', l_nodename, l_attrlist);
7681: wf_xml.AddElementAttribute('item_type', 'NULL', l_attrlist);
7682: wf_xml.AddElementAttribute('message_name', 'NULL', l_attrlist);
7683: wf_xml.AddElementAttribute('full-document', 'Y', l_attrlist);
7684:
7685: if (p_callback_event is not null) then
7686: wf_xml.AddElementAttribute('callback', p_callback_event, l_attrlist);
7687: end if;

Line 7686: wf_xml.AddElementAttribute('callback', p_callback_event, l_attrlist);

7682: wf_xml.AddElementAttribute('message_name', 'NULL', l_attrlist);
7683: wf_xml.AddElementAttribute('full-document', 'Y', l_attrlist);
7684:
7685: if (p_callback_event is not null) then
7686: wf_xml.AddElementAttribute('callback', p_callback_event, l_attrlist);
7687: end if;
7688:
7689: l_pos := wf_xml.NewLOBTag(l_msg_doc, l_pos, 'NOTIFICATION', '', l_attrlist);
7690: l_attrlist.DELETE;

Line 7689: l_pos := wf_xml.NewLOBTag(l_msg_doc, l_pos, 'NOTIFICATION', '', l_attrlist);

7685: if (p_callback_event is not null) then
7686: wf_xml.AddElementAttribute('callback', p_callback_event, l_attrlist);
7687: end if;
7688:
7689: l_pos := wf_xml.NewLOBTag(l_msg_doc, l_pos, 'NOTIFICATION', '', l_attrlist);
7690: l_attrlist.DELETE;
7691:
7692: dbms_lob.createTemporary(l_recp_clob, TRUE, dbms_lob.call);
7693:

Line 7703: wf_xml.AddElementAttribute('name', l_name, l_attrlist);

7699: l_name := replace(p_recipient_list(i).name, g_newline);
7700: l_recp_type := p_recipient_list(i).recipient_type;
7701:
7702: -- begin
7703: wf_xml.AddElementAttribute('name', l_name, l_attrlist);
7704: wf_xml.AddElementAttribute('type', l_recp_type, l_attrlist);
7705: l_recp_pos := wf_xml.NewTag(l_recp_tmp, l_recp_pos, 'RECIPIENT', '', l_attrlist);
7706: l_attrlist.DELETE;
7707:

Line 7704: wf_xml.AddElementAttribute('type', l_recp_type, l_attrlist);

7700: l_recp_type := p_recipient_list(i).recipient_type;
7701:
7702: -- begin
7703: wf_xml.AddElementAttribute('name', l_name, l_attrlist);
7704: wf_xml.AddElementAttribute('type', l_recp_type, l_attrlist);
7705: l_recp_pos := wf_xml.NewTag(l_recp_tmp, l_recp_pos, 'RECIPIENT', '', l_attrlist);
7706: l_attrlist.DELETE;
7707:
7708: --

Line 7705: l_recp_pos := wf_xml.NewTag(l_recp_tmp, l_recp_pos, 'RECIPIENT', '', l_attrlist);

7701:
7702: -- begin
7703: wf_xml.AddElementAttribute('name', l_name, l_attrlist);
7704: wf_xml.AddElementAttribute('type', l_recp_type, l_attrlist);
7705: l_recp_pos := wf_xml.NewTag(l_recp_tmp, l_recp_pos, 'RECIPIENT', '', l_attrlist);
7706: l_attrlist.DELETE;
7707:
7708: --
7709: l_recp_pos := wf_xml.NewTag(l_recp_tmp, l_recp_pos, 'NAME', l_name, l_attrlist);

Line 7709: l_recp_pos := wf_xml.NewTag(l_recp_tmp, l_recp_pos, 'NAME', l_name, l_attrlist);

7705: l_recp_pos := wf_xml.NewTag(l_recp_tmp, l_recp_pos, 'RECIPIENT', '', l_attrlist);
7706: l_attrlist.DELETE;
7707:
7708: --
7709: l_recp_pos := wf_xml.NewTag(l_recp_tmp, l_recp_pos, 'NAME', l_name, l_attrlist);
7710: l_recp_pos := wf_xml.SkipTag(l_recp_tmp, 'NAME', l_recp_pos, l_occurance);
7711:
7712: --

7713: l_email := '';

Line 7710: l_recp_pos := wf_xml.SkipTag(l_recp_tmp, 'NAME', l_recp_pos, l_occurance);

7706: l_attrlist.DELETE;
7707:
7708: --
7709: l_recp_pos := wf_xml.NewTag(l_recp_tmp, l_recp_pos, 'NAME', l_name, l_attrlist);
7710: l_recp_pos := wf_xml.SkipTag(l_recp_tmp, 'NAME', l_recp_pos, l_occurance);
7711:
7712: --

7713: l_email := '';
7714: l_recp_pos := wf_xml.NewTag(l_recp_tmp, l_recp_pos, 'ADDRESS', l_email, l_attrlist);

Line 7714: l_recp_pos := wf_xml.NewTag(l_recp_tmp, l_recp_pos, 'ADDRESS', l_email, l_attrlist);

7710: l_recp_pos := wf_xml.SkipTag(l_recp_tmp, 'NAME', l_recp_pos, l_occurance);
7711:
7712: --

7713: l_email := '';
7714: l_recp_pos := wf_xml.NewTag(l_recp_tmp, l_recp_pos, 'ADDRESS', l_email, l_attrlist);
7715: l_recp_pos := wf_xml.SkipTag(l_recp_tmp, 'ADDRESS', l_recp_pos, l_occurance);
7716:
7717: -- end
7718: l_recp_pos := wf_xml.SkipTag(l_recp_tmp, 'RECIPIENT', l_recp_pos, l_occurance);

Line 7715: l_recp_pos := wf_xml.SkipTag(l_recp_tmp, 'ADDRESS', l_recp_pos, l_occurance);

7711:
7712: --

7713: l_email := '';
7714: l_recp_pos := wf_xml.NewTag(l_recp_tmp, l_recp_pos, 'ADDRESS', l_email, l_attrlist);
7715: l_recp_pos := wf_xml.SkipTag(l_recp_tmp, 'ADDRESS', l_recp_pos, l_occurance);
7716:
7717: -- end
7718: l_recp_pos := wf_xml.SkipTag(l_recp_tmp, 'RECIPIENT', l_recp_pos, l_occurance);
7719: l_attrlist.DELETE;

Line 7718: l_recp_pos := wf_xml.SkipTag(l_recp_tmp, 'RECIPIENT', l_recp_pos, l_occurance);

7714: l_recp_pos := wf_xml.NewTag(l_recp_tmp, l_recp_pos, 'ADDRESS', l_email, l_attrlist);
7715: l_recp_pos := wf_xml.SkipTag(l_recp_tmp, 'ADDRESS', l_recp_pos, l_occurance);
7716:
7717: -- end
7718: l_recp_pos := wf_xml.SkipTag(l_recp_tmp, 'RECIPIENT', l_recp_pos, l_occurance);
7719: l_attrlist.DELETE;
7720:
7721: i := p_recipient_list.next(i);
7722:

Line 7741: l_recp_pos := wf_xml.NewLOBTag(l_recp, l_recp_pos, 'RECIPIENTLIST', l_recp_clob, l_attrlist);

7737: -- start
7738: l_recp_pos := 0;
7739: if (l_recp_is_lob) then
7740: dbms_lob.createTemporary(l_recp, TRUE, dbms_lob.call);
7741: l_recp_pos := wf_xml.NewLOBTag(l_recp, l_recp_pos, 'RECIPIENTLIST', l_recp_clob, l_attrlist);
7742: l_recp_pos := wf_xml.SkipLOBTag(l_recp, 'RECIPIENTLIST', l_recp_pos, l_occurance);
7743: else
7744: l_recp_pos := wf_xml.NewTag(l_recp_txt, l_recp_pos, 'RECIPIENTLIST', l_recp_tmp, l_attrlist);
7745: l_recp_pos := wf_xml.SkipTag(l_recp_txt, 'RECIPIENTLIST', l_recp_pos, l_occurance);

Line 7742: l_recp_pos := wf_xml.SkipLOBTag(l_recp, 'RECIPIENTLIST', l_recp_pos, l_occurance);

7738: l_recp_pos := 0;
7739: if (l_recp_is_lob) then
7740: dbms_lob.createTemporary(l_recp, TRUE, dbms_lob.call);
7741: l_recp_pos := wf_xml.NewLOBTag(l_recp, l_recp_pos, 'RECIPIENTLIST', l_recp_clob, l_attrlist);
7742: l_recp_pos := wf_xml.SkipLOBTag(l_recp, 'RECIPIENTLIST', l_recp_pos, l_occurance);
7743: else
7744: l_recp_pos := wf_xml.NewTag(l_recp_txt, l_recp_pos, 'RECIPIENTLIST', l_recp_tmp, l_attrlist);
7745: l_recp_pos := wf_xml.SkipTag(l_recp_txt, 'RECIPIENTLIST', l_recp_pos, l_occurance);
7746: end if;

Line 7744: l_recp_pos := wf_xml.NewTag(l_recp_txt, l_recp_pos, 'RECIPIENTLIST', l_recp_tmp, l_attrlist);

7740: dbms_lob.createTemporary(l_recp, TRUE, dbms_lob.call);
7741: l_recp_pos := wf_xml.NewLOBTag(l_recp, l_recp_pos, 'RECIPIENTLIST', l_recp_clob, l_attrlist);
7742: l_recp_pos := wf_xml.SkipLOBTag(l_recp, 'RECIPIENTLIST', l_recp_pos, l_occurance);
7743: else
7744: l_recp_pos := wf_xml.NewTag(l_recp_txt, l_recp_pos, 'RECIPIENTLIST', l_recp_tmp, l_attrlist);
7745: l_recp_pos := wf_xml.SkipTag(l_recp_txt, 'RECIPIENTLIST', l_recp_pos, l_occurance);
7746: end if;
7747:
7748: l_hdr_pos := 0;

Line 7745: l_recp_pos := wf_xml.SkipTag(l_recp_txt, 'RECIPIENTLIST', l_recp_pos, l_occurance);

7741: l_recp_pos := wf_xml.NewLOBTag(l_recp, l_recp_pos, 'RECIPIENTLIST', l_recp_clob, l_attrlist);
7742: l_recp_pos := wf_xml.SkipLOBTag(l_recp, 'RECIPIENTLIST', l_recp_pos, l_occurance);
7743: else
7744: l_recp_pos := wf_xml.NewTag(l_recp_txt, l_recp_pos, 'RECIPIENTLIST', l_recp_tmp, l_attrlist);
7745: l_recp_pos := wf_xml.SkipTag(l_recp_txt, 'RECIPIENTLIST', l_recp_pos, l_occurance);
7746: end if;
7747:
7748: l_hdr_pos := 0;
7749: l_hdr_tmp := '';

Line 7753: l_hdr_pos := wf_xml.NewTag(l_hdr_tmp, l_hdr_pos, 'FROM', '', l_attrlist);

7749: l_hdr_tmp := '';
7750:
7751: if (p_from is not null or p_replyto is not null) then
7752: -- start
7753: l_hdr_pos := wf_xml.NewTag(l_hdr_tmp, l_hdr_pos, 'FROM', '', l_attrlist);
7754:
7755: --
7756: if (p_from is not null) then
7757: l_from := replace(p_from, g_newLine);

Line 7758: l_hdr_pos := wf_xml.NewTag(l_hdr_tmp, l_hdr_pos, 'NAME', l_from, l_attrlist);

7754:
7755: --
7756: if (p_from is not null) then
7757: l_from := replace(p_from, g_newLine);
7758: l_hdr_pos := wf_xml.NewTag(l_hdr_tmp, l_hdr_pos, 'NAME', l_from, l_attrlist);
7759: l_hdr_pos := wf_xml.SkipTag(l_hdr_tmp, 'NAME', l_hdr_pos, l_occurance);
7760: end if;
7761:
7762: --

Line 7759: l_hdr_pos := wf_xml.SkipTag(l_hdr_tmp, 'NAME', l_hdr_pos, l_occurance);

7755: --
7756: if (p_from is not null) then
7757: l_from := replace(p_from, g_newLine);
7758: l_hdr_pos := wf_xml.NewTag(l_hdr_tmp, l_hdr_pos, 'NAME', l_from, l_attrlist);
7759: l_hdr_pos := wf_xml.SkipTag(l_hdr_tmp, 'NAME', l_hdr_pos, l_occurance);
7760: end if;
7761:
7762: --

7763: if (p_replyto is not null) then

Line 7766: l_hdr_pos := wf_xml.NewTag(l_hdr_tmp, l_hdr_pos, 'ADDRESS', l_replyto, l_attrlist);

7762: --

7763: if (p_replyto is not null) then
7764: l_replyto := replace(p_replyto, g_newLine);
7765: l_replyto := '';
7766: l_hdr_pos := wf_xml.NewTag(l_hdr_tmp, l_hdr_pos, 'ADDRESS', l_replyto, l_attrlist);
7767: l_hdr_pos := wf_xml.SkipTag(l_hdr_tmp, 'ADDRESS', l_hdr_pos, l_occurance);
7768: end if;
7769:
7770: -- end

Line 7767: l_hdr_pos := wf_xml.SkipTag(l_hdr_tmp, 'ADDRESS', l_hdr_pos, l_occurance);

7763: if (p_replyto is not null) then
7764: l_replyto := replace(p_replyto, g_newLine);
7765: l_replyto := '';
7766: l_hdr_pos := wf_xml.NewTag(l_hdr_tmp, l_hdr_pos, 'ADDRESS', l_replyto, l_attrlist);
7767: l_hdr_pos := wf_xml.SkipTag(l_hdr_tmp, 'ADDRESS', l_hdr_pos, l_occurance);
7768: end if;
7769:
7770: -- end
7771: l_hdr_pos := wf_xml.SkipTag(l_hdr_tmp, 'FROM', l_hdr_pos, l_occurance);

Line 7771: l_hdr_pos := wf_xml.SkipTag(l_hdr_tmp, 'FROM', l_hdr_pos, l_occurance);

7767: l_hdr_pos := wf_xml.SkipTag(l_hdr_tmp, 'ADDRESS', l_hdr_pos, l_occurance);
7768: end if;
7769:
7770: -- end
7771: l_hdr_pos := wf_xml.SkipTag(l_hdr_tmp, 'FROM', l_hdr_pos, l_occurance);
7772: end if;
7773:
7774: l_subject := replace(p_subject, g_newLine);
7775: l_subject := '';

Line 7776: l_hdr_pos := wf_xml.NewTag(l_hdr_tmp, l_hdr_pos, 'SUBJECT', l_subject, l_attrlist);

7772: end if;
7773:
7774: l_subject := replace(p_subject, g_newLine);
7775: l_subject := '';
7776: l_hdr_pos := wf_xml.NewTag(l_hdr_tmp, l_hdr_pos, 'SUBJECT', l_subject, l_attrlist);
7777: l_hdr_pos := wf_xml.SkipTag(l_hdr_tmp, 'SUBJECT', l_hdr_pos, l_occurance);
7778:
7779: if (l_recp_is_lob) then
7780: dbms_lob.WriteAppend(l_recp, length(l_hdr_tmp), l_hdr_tmp);

Line 7777: l_hdr_pos := wf_xml.SkipTag(l_hdr_tmp, 'SUBJECT', l_hdr_pos, l_occurance);

7773:
7774: l_subject := replace(p_subject, g_newLine);
7775: l_subject := '';
7776: l_hdr_pos := wf_xml.NewTag(l_hdr_tmp, l_hdr_pos, 'SUBJECT', l_subject, l_attrlist);
7777: l_hdr_pos := wf_xml.SkipTag(l_hdr_tmp, 'SUBJECT', l_hdr_pos, l_occurance);
7778:
7779: if (l_recp_is_lob) then
7780: dbms_lob.WriteAppend(l_recp, length(l_hdr_tmp), l_hdr_tmp);
7781: l_pos := wf_xml.NewLOBTag(l_msg_doc, l_pos, 'HEADER', l_recp, l_attrlist);

Line 7781: l_pos := wf_xml.NewLOBTag(l_msg_doc, l_pos, 'HEADER', l_recp, l_attrlist);

7777: l_hdr_pos := wf_xml.SkipTag(l_hdr_tmp, 'SUBJECT', l_hdr_pos, l_occurance);
7778:
7779: if (l_recp_is_lob) then
7780: dbms_lob.WriteAppend(l_recp, length(l_hdr_tmp), l_hdr_tmp);
7781: l_pos := wf_xml.NewLOBTag(l_msg_doc, l_pos, 'HEADER', l_recp, l_attrlist);
7782: else
7783: l_hdr_tmp := l_recp_txt || l_hdr_tmp;
7784: l_pos := wf_xml.NewLOBTag(l_msg_doc, l_pos, 'HEADER', l_hdr_tmp, l_attrlist);
7785: end if;

Line 7784: l_pos := wf_xml.NewLOBTag(l_msg_doc, l_pos, 'HEADER', l_hdr_tmp, l_attrlist);

7780: dbms_lob.WriteAppend(l_recp, length(l_hdr_tmp), l_hdr_tmp);
7781: l_pos := wf_xml.NewLOBTag(l_msg_doc, l_pos, 'HEADER', l_recp, l_attrlist);
7782: else
7783: l_hdr_tmp := l_recp_txt || l_hdr_tmp;
7784: l_pos := wf_xml.NewLOBTag(l_msg_doc, l_pos, 'HEADER', l_hdr_tmp, l_attrlist);
7785: end if;
7786: l_pos := wf_xml.SkipLOBTag(l_msg_doc, 'HEADER', l_pos, l_occurance);
7787: l_attrlist.DELETE;
7788:

Line 7786: l_pos := wf_xml.SkipLOBTag(l_msg_doc, 'HEADER', l_pos, l_occurance);

7782: else
7783: l_hdr_tmp := l_recp_txt || l_hdr_tmp;
7784: l_pos := wf_xml.NewLOBTag(l_msg_doc, l_pos, 'HEADER', l_hdr_tmp, l_attrlist);
7785: end if;
7786: l_pos := wf_xml.SkipLOBTag(l_msg_doc, 'HEADER', l_pos, l_occurance);
7787: l_attrlist.DELETE;
7788:
7789: -- start
7790: wf_xml.AddElementAttribute('content-type', 'multipart/mixed', l_attrlist);

Line 7790: wf_xml.AddElementAttribute('content-type', 'multipart/mixed', l_attrlist);

7786: l_pos := wf_xml.SkipLOBTag(l_msg_doc, 'HEADER', l_pos, l_occurance);
7787: l_attrlist.DELETE;
7788:
7789: -- start
7790: wf_xml.AddElementAttribute('content-type', 'multipart/mixed', l_attrlist);
7791: l_pos := wf_xml.NewLOBTag(l_msg_doc, l_pos, 'CONTENT', '', l_attrlist);
7792: l_attrlist.DELETE;
7793:
7794: -- start

Line 7791: l_pos := wf_xml.NewLOBTag(l_msg_doc, l_pos, 'CONTENT', '', l_attrlist);

7787: l_attrlist.DELETE;
7788:
7789: -- start
7790: wf_xml.AddElementAttribute('content-type', 'multipart/mixed', l_attrlist);
7791: l_pos := wf_xml.NewLOBTag(l_msg_doc, l_pos, 'CONTENT', '', l_attrlist);
7792: l_attrlist.DELETE;
7793:
7794: -- start
7795: wf_xml.AddElementAttribute('content-type', p_content_type, l_attrlist);

Line 7795: wf_xml.AddElementAttribute('content-type', p_content_type, l_attrlist);

7791: l_pos := wf_xml.NewLOBTag(l_msg_doc, l_pos, 'CONTENT', '', l_attrlist);
7792: l_attrlist.DELETE;
7793:
7794: -- start
7795: wf_xml.AddElementAttribute('content-type', p_content_type, l_attrlist);
7796: l_pos := wf_xml.NewLOBTag(l_msg_doc, l_pos, 'BODYPART', '', l_attrlist);
7797:
7798: --
7799:

Line 7796: l_pos := wf_xml.NewLOBTag(l_msg_doc, l_pos, 'BODYPART', '', l_attrlist);

7792: l_attrlist.DELETE;
7793:
7794: -- start
7795: wf_xml.AddElementAttribute('content-type', p_content_type, l_attrlist);
7796: l_pos := wf_xml.NewLOBTag(l_msg_doc, l_pos, 'BODYPART', '', l_attrlist);
7797:
7798: --
7799:
7800: l_messageIdx := wf_temp_lob.getLOB(g_LOBTable);

Line 7822: l_pos := wf_xml.NewLOBTag(l_msg_doc, l_pos, 'MESSAGE',

7818: dbms_lob.writeAppend(g_LOBTable(l_messageIdx).temp_lob,
7819: length(l_end_cdata), l_end_cdata);
7820:
7821: -- Alert Message has been appended in XML Payload, can be released now
7822: l_pos := wf_xml.NewLOBTag(l_msg_doc, l_pos, 'MESSAGE',
7823: g_LOBTable(l_messageIdx).temp_lob, l_attrlist);
7824: l_pos := wf_xml.SkipLOBTag(l_msg_doc, 'MESSAGE', l_pos, l_occurance);
7825:
7826: l_attrlist.DELETE;

Line 7824: l_pos := wf_xml.SkipLOBTag(l_msg_doc, 'MESSAGE', l_pos, l_occurance);

7820:
7821: -- Alert Message has been appended in XML Payload, can be released now
7822: l_pos := wf_xml.NewLOBTag(l_msg_doc, l_pos, 'MESSAGE',
7823: g_LOBTable(l_messageIdx).temp_lob, l_attrlist);
7824: l_pos := wf_xml.SkipLOBTag(l_msg_doc, 'MESSAGE', l_pos, l_occurance);
7825:
7826: l_attrlist.DELETE;
7827:
7828: -- end

Line 7829: l_pos := wf_xml.SkipLOBTag(l_msg_doc, 'BODYPART', l_pos, l_occurance);

7825:
7826: l_attrlist.DELETE;
7827:
7828: -- end
7829: l_pos := wf_xml.SkipLOBTag(l_msg_doc, 'BODYPART', l_pos, l_occurance);
7830:
7831: -- end
7832: l_pos := wf_xml.SkipLOBTag(l_msg_doc, 'CONTENT', l_pos, l_occurance);
7833:

Line 7832: l_pos := wf_xml.SkipLOBTag(l_msg_doc, 'CONTENT', l_pos, l_occurance);

7828: -- end
7829: l_pos := wf_xml.SkipLOBTag(l_msg_doc, 'BODYPART', l_pos, l_occurance);
7830:
7831: -- end
7832: l_pos := wf_xml.SkipLOBTag(l_msg_doc, 'CONTENT', l_pos, l_occurance);
7833:
7834: -- end
7835: l_pos := wf_xml.SkipLOBTag(l_msg_doc, 'NOTIFICATION', l_pos, l_occurance);
7836:

Line 7835: l_pos := wf_xml.SkipLOBTag(l_msg_doc, 'NOTIFICATION', l_pos, l_occurance);

7831: -- end
7832: l_pos := wf_xml.SkipLOBTag(l_msg_doc, 'CONTENT', l_pos, l_occurance);
7833:
7834: -- end
7835: l_pos := wf_xml.SkipLOBTag(l_msg_doc, 'NOTIFICATION', l_pos, l_occurance);
7836:
7837: -- end
7838: l_pos := wf_xml.SkipLOBTag(l_msg_doc, 'NOTIFICATIONGROUP', l_pos, l_occurance);
7839:

Line 7838: l_pos := wf_xml.SkipLOBTag(l_msg_doc, 'NOTIFICATIONGROUP', l_pos, l_occurance);

7834: -- end
7835: l_pos := wf_xml.SkipLOBTag(l_msg_doc, 'NOTIFICATION', l_pos, l_occurance);
7836:
7837: -- end
7838: l_pos := wf_xml.SkipLOBTag(l_msg_doc, 'NOTIFICATIONGROUP', l_pos, l_occurance);
7839:
7840: wf_event_t.Initialize(l_event);
7841:
7842: l_event.event_name := wf_xml.WF_NTF_SEND_MESSAGE;

Line 7842: l_event.event_name := wf_xml.WF_NTF_SEND_MESSAGE;

7838: l_pos := wf_xml.SkipLOBTag(l_msg_doc, 'NOTIFICATIONGROUP', l_pos, l_occurance);
7839:
7840: wf_event_t.Initialize(l_event);
7841:
7842: l_event.event_name := wf_xml.WF_NTF_SEND_MESSAGE;
7843:
7844: -- Create an event key based firstly on the parameter. If that does not
7845: -- exist, then base it on the ID string. If that too is null (FYI for
7846: -- instance) then create a default, non unique key.

Line 7939: l_attrlist wf_xml.wf_xml_attr_table_type;

7935: l_orig_system varchar2(30);
7936: l_orig_system_id number;
7937:
7938: l_msg_doc CLOB;
7939: l_attrlist wf_xml.wf_xml_attr_table_type;
7940:
7941: l_messageidx pls_integer;
7942: l_pos INTEGER;
7943: l_occurance INTEGER := 1;

Line 8113: wf_xml.AddElementAttribute('maxcount','1',l_attrlist);

8109: l_pos := LENGTH(l_str);
8110: dbms_lob.WRITE(l_msg_doc, l_pos, 1, l_str);
8111:
8112: -- begin
8113: wf_xml.AddElementAttribute('maxcount','1',l_attrlist);
8114: l_pos := wf_xml.newlobtag(l_msg_doc,l_pos,'NOTIFICATIONGROUP','',l_attrlist);
8115: l_attrlist.DELETE;
8116:
8117:

Line 8114: l_pos := wf_xml.newlobtag(l_msg_doc,l_pos,'NOTIFICATIONGROUP','',l_attrlist);

8110: dbms_lob.WRITE(l_msg_doc, l_pos, 1, l_str);
8111:
8112: -- begin
8113: wf_xml.AddElementAttribute('maxcount','1',l_attrlist);
8114: l_pos := wf_xml.newlobtag(l_msg_doc,l_pos,'NOTIFICATIONGROUP','',l_attrlist);
8115: l_attrlist.DELETE;
8116:
8117:
8118: -- begin , set NID as 0 so that

Line 8121: wf_xml.AddElementAttribute('nid','0',l_attrlist);

8117:
8118: -- begin , set NID as 0 so that
8119: -- WF_NOTIFICATION.MAIL_STAUTS should not affect to deliver
8120: -- this warning message.
8121: wf_xml.AddElementAttribute('nid','0',l_attrlist);
8122: wf_xml.AddElementAttribute('nidstr',l_idstr,l_attrlist);
8123: wf_xml.AddElementAttribute('language',l_language,l_attrlist);
8124: wf_xml.AddElementAttribute('territory',l_territory,l_attrlist);
8125: wf_xml.AddElementAttribute('codeset',l_codeset,l_attrlist);

Line 8122: wf_xml.AddElementAttribute('nidstr',l_idstr,l_attrlist);

8118: -- begin , set NID as 0 so that
8119: -- WF_NOTIFICATION.MAIL_STAUTS should not affect to deliver
8120: -- this warning message.
8121: wf_xml.AddElementAttribute('nid','0',l_attrlist);
8122: wf_xml.AddElementAttribute('nidstr',l_idstr,l_attrlist);
8123: wf_xml.AddElementAttribute('language',l_language,l_attrlist);
8124: wf_xml.AddElementAttribute('territory',l_territory,l_attrlist);
8125: wf_xml.AddElementAttribute('codeset',l_codeset,l_attrlist);
8126:

Line 8123: wf_xml.AddElementAttribute('language',l_language,l_attrlist);

8119: -- WF_NOTIFICATION.MAIL_STAUTS should not affect to deliver
8120: -- this warning message.
8121: wf_xml.AddElementAttribute('nid','0',l_attrlist);
8122: wf_xml.AddElementAttribute('nidstr',l_idstr,l_attrlist);
8123: wf_xml.AddElementAttribute('language',l_language,l_attrlist);
8124: wf_xml.AddElementAttribute('territory',l_territory,l_attrlist);
8125: wf_xml.AddElementAttribute('codeset',l_codeset,l_attrlist);
8126:
8127: -- <>:

Line 8124: wf_xml.AddElementAttribute('territory',l_territory,l_attrlist);

8120: -- this warning message.
8121: wf_xml.AddElementAttribute('nid','0',l_attrlist);
8122: wf_xml.AddElementAttribute('nidstr',l_idstr,l_attrlist);
8123: wf_xml.AddElementAttribute('language',l_language,l_attrlist);
8124: wf_xml.AddElementAttribute('territory',l_territory,l_attrlist);
8125: wf_xml.AddElementAttribute('codeset',l_codeset,l_attrlist);
8126:
8127: -- <>:
8128: -- Setting default parameter's value as for warning, as these parameters

Line 8125: wf_xml.AddElementAttribute('codeset',l_codeset,l_attrlist);

8121: wf_xml.AddElementAttribute('nid','0',l_attrlist);
8122: wf_xml.AddElementAttribute('nidstr',l_idstr,l_attrlist);
8123: wf_xml.AddElementAttribute('language',l_language,l_attrlist);
8124: wf_xml.AddElementAttribute('territory',l_territory,l_attrlist);
8125: wf_xml.AddElementAttribute('codeset',l_codeset,l_attrlist);
8126:
8127: -- <>:
8128: -- Setting default parameter's value as for warning, as these parameters
8129: -- won't be used to update AppsContext (non-OAF content)

Line 8131: wf_xml.AddElementAttribute('nlsDateformat', wf_core.nls_date_format, l_attrlist);

8127: -- <>:
8128: -- Setting default parameter's value as for warning, as these parameters
8129: -- won't be used to update AppsContext (non-OAF content)
8130: -- TODO>>
8131: wf_xml.AddElementAttribute('nlsDateformat', wf_core.nls_date_format, l_attrlist);
8132: wf_xml.AddElementAttribute('nlsDateLanguage', wf_core.nls_date_language, l_attrlist);
8133: wf_xml.AddElementAttribute('nlsNumericCharacters', wf_core.nls_numeric_characters, l_attrlist);
8134: wf_xml.AddElementAttribute('nlsSort', wf_core.nls_sort, l_attrlist);
8135:

Line 8132: wf_xml.AddElementAttribute('nlsDateLanguage', wf_core.nls_date_language, l_attrlist);

8128: -- Setting default parameter's value as for warning, as these parameters
8129: -- won't be used to update AppsContext (non-OAF content)
8130: -- TODO>>
8131: wf_xml.AddElementAttribute('nlsDateformat', wf_core.nls_date_format, l_attrlist);
8132: wf_xml.AddElementAttribute('nlsDateLanguage', wf_core.nls_date_language, l_attrlist);
8133: wf_xml.AddElementAttribute('nlsNumericCharacters', wf_core.nls_numeric_characters, l_attrlist);
8134: wf_xml.AddElementAttribute('nlsSort', wf_core.nls_sort, l_attrlist);
8135:
8136: wf_xml.AddElementAttribute('priority','50',l_attrlist);

Line 8133: wf_xml.AddElementAttribute('nlsNumericCharacters', wf_core.nls_numeric_characters, l_attrlist);

8129: -- won't be used to update AppsContext (non-OAF content)
8130: -- TODO>>
8131: wf_xml.AddElementAttribute('nlsDateformat', wf_core.nls_date_format, l_attrlist);
8132: wf_xml.AddElementAttribute('nlsDateLanguage', wf_core.nls_date_language, l_attrlist);
8133: wf_xml.AddElementAttribute('nlsNumericCharacters', wf_core.nls_numeric_characters, l_attrlist);
8134: wf_xml.AddElementAttribute('nlsSort', wf_core.nls_sort, l_attrlist);
8135:
8136: wf_xml.AddElementAttribute('priority','50',l_attrlist);
8137: wf_xml.AddElementAttribute('accesskey','0',l_attrlist);

Line 8134: wf_xml.AddElementAttribute('nlsSort', wf_core.nls_sort, l_attrlist);

8130: -- TODO>>
8131: wf_xml.AddElementAttribute('nlsDateformat', wf_core.nls_date_format, l_attrlist);
8132: wf_xml.AddElementAttribute('nlsDateLanguage', wf_core.nls_date_language, l_attrlist);
8133: wf_xml.AddElementAttribute('nlsNumericCharacters', wf_core.nls_numeric_characters, l_attrlist);
8134: wf_xml.AddElementAttribute('nlsSort', wf_core.nls_sort, l_attrlist);
8135:
8136: wf_xml.AddElementAttribute('priority','50',l_attrlist);
8137: wf_xml.AddElementAttribute('accesskey','0',l_attrlist);
8138: wf_xml.AddElementAttribute('node',l_nodename,l_attrlist);

Line 8136: wf_xml.AddElementAttribute('priority','50',l_attrlist);

8132: wf_xml.AddElementAttribute('nlsDateLanguage', wf_core.nls_date_language, l_attrlist);
8133: wf_xml.AddElementAttribute('nlsNumericCharacters', wf_core.nls_numeric_characters, l_attrlist);
8134: wf_xml.AddElementAttribute('nlsSort', wf_core.nls_sort, l_attrlist);
8135:
8136: wf_xml.AddElementAttribute('priority','50',l_attrlist);
8137: wf_xml.AddElementAttribute('accesskey','0',l_attrlist);
8138: wf_xml.AddElementAttribute('node',l_nodename,l_attrlist);
8139: wf_xml.AddElementAttribute('item_type',l_msg_type,l_attrlist);
8140: wf_xml.AddElementAttribute('message_name',l_msg_name,l_attrlist);

Line 8137: wf_xml.AddElementAttribute('accesskey','0',l_attrlist);

8133: wf_xml.AddElementAttribute('nlsNumericCharacters', wf_core.nls_numeric_characters, l_attrlist);
8134: wf_xml.AddElementAttribute('nlsSort', wf_core.nls_sort, l_attrlist);
8135:
8136: wf_xml.AddElementAttribute('priority','50',l_attrlist);
8137: wf_xml.AddElementAttribute('accesskey','0',l_attrlist);
8138: wf_xml.AddElementAttribute('node',l_nodename,l_attrlist);
8139: wf_xml.AddElementAttribute('item_type',l_msg_type,l_attrlist);
8140: wf_xml.AddElementAttribute('message_name',l_msg_name,l_attrlist);
8141: wf_xml.AddElementAttribute('full-document','Y',l_attrlist);

Line 8138: wf_xml.AddElementAttribute('node',l_nodename,l_attrlist);

8134: wf_xml.AddElementAttribute('nlsSort', wf_core.nls_sort, l_attrlist);
8135:
8136: wf_xml.AddElementAttribute('priority','50',l_attrlist);
8137: wf_xml.AddElementAttribute('accesskey','0',l_attrlist);
8138: wf_xml.AddElementAttribute('node',l_nodename,l_attrlist);
8139: wf_xml.AddElementAttribute('item_type',l_msg_type,l_attrlist);
8140: wf_xml.AddElementAttribute('message_name',l_msg_name,l_attrlist);
8141: wf_xml.AddElementAttribute('full-document','Y',l_attrlist);
8142:

Line 8139: wf_xml.AddElementAttribute('item_type',l_msg_type,l_attrlist);

8135:
8136: wf_xml.AddElementAttribute('priority','50',l_attrlist);
8137: wf_xml.AddElementAttribute('accesskey','0',l_attrlist);
8138: wf_xml.AddElementAttribute('node',l_nodename,l_attrlist);
8139: wf_xml.AddElementAttribute('item_type',l_msg_type,l_attrlist);
8140: wf_xml.AddElementAttribute('message_name',l_msg_name,l_attrlist);
8141: wf_xml.AddElementAttribute('full-document','Y',l_attrlist);
8142:
8143: l_pos := wf_xml.NewLOBTag(l_msg_doc, l_pos,'NOTIFICATION','',l_attrlist);

Line 8140: wf_xml.AddElementAttribute('message_name',l_msg_name,l_attrlist);

8136: wf_xml.AddElementAttribute('priority','50',l_attrlist);
8137: wf_xml.AddElementAttribute('accesskey','0',l_attrlist);
8138: wf_xml.AddElementAttribute('node',l_nodename,l_attrlist);
8139: wf_xml.AddElementAttribute('item_type',l_msg_type,l_attrlist);
8140: wf_xml.AddElementAttribute('message_name',l_msg_name,l_attrlist);
8141: wf_xml.AddElementAttribute('full-document','Y',l_attrlist);
8142:
8143: l_pos := wf_xml.NewLOBTag(l_msg_doc, l_pos,'NOTIFICATION','',l_attrlist);
8144: l_attrlist.DELETE;

Line 8141: wf_xml.AddElementAttribute('full-document','Y',l_attrlist);

8137: wf_xml.AddElementAttribute('accesskey','0',l_attrlist);
8138: wf_xml.AddElementAttribute('node',l_nodename,l_attrlist);
8139: wf_xml.AddElementAttribute('item_type',l_msg_type,l_attrlist);
8140: wf_xml.AddElementAttribute('message_name',l_msg_name,l_attrlist);
8141: wf_xml.AddElementAttribute('full-document','Y',l_attrlist);
8142:
8143: l_pos := wf_xml.NewLOBTag(l_msg_doc, l_pos,'NOTIFICATION','',l_attrlist);
8144: l_attrlist.DELETE;
8145:

Line 8143: l_pos := wf_xml.NewLOBTag(l_msg_doc, l_pos,'NOTIFICATION','',l_attrlist);

8139: wf_xml.AddElementAttribute('item_type',l_msg_type,l_attrlist);
8140: wf_xml.AddElementAttribute('message_name',l_msg_name,l_attrlist);
8141: wf_xml.AddElementAttribute('full-document','Y',l_attrlist);
8142:
8143: l_pos := wf_xml.NewLOBTag(l_msg_doc, l_pos,'NOTIFICATION','',l_attrlist);
8144: l_attrlist.DELETE;
8145:
8146: -- Below variabkes are just to generate HEADER of
8147: -- xml PAYLOAD

Line 8151: hdrxmlPos := WF_XML.NewTag(hdrxml, hdrxmlPos, 'RECIPIENTLIST', '', l_attrlist);

8147: -- xml PAYLOAD
8148: hdrxmlPos := 0;
8149: hdrxml := '';
8150:
8151: hdrxmlPos := WF_XML.NewTag(hdrxml, hdrxmlPos, 'RECIPIENTLIST', '', l_attrlist);
8152:
8153: -- TO
8154: WF_XML.AddElementAttribute('name', l_to_role, l_attrlist);
8155: WF_XML.AddElementAttribute('type', 'to', l_attrlist);

Line 8154: WF_XML.AddElementAttribute('name', l_to_role, l_attrlist);

8150:
8151: hdrxmlPos := WF_XML.NewTag(hdrxml, hdrxmlPos, 'RECIPIENTLIST', '', l_attrlist);
8152:
8153: -- TO
8154: WF_XML.AddElementAttribute('name', l_to_role, l_attrlist);
8155: WF_XML.AddElementAttribute('type', 'to', l_attrlist);
8156:
8157: hdrxmlPos := WF_XML.NewTag(hdrxml, hdrxmlPos, 'RECIPIENT', '', l_attrlist);
8158: l_attrlist.DELETE;

Line 8155: WF_XML.AddElementAttribute('type', 'to', l_attrlist);

8151: hdrxmlPos := WF_XML.NewTag(hdrxml, hdrxmlPos, 'RECIPIENTLIST', '', l_attrlist);
8152:
8153: -- TO
8154: WF_XML.AddElementAttribute('name', l_to_role, l_attrlist);
8155: WF_XML.AddElementAttribute('type', 'to', l_attrlist);
8156:
8157: hdrxmlPos := WF_XML.NewTag(hdrxml, hdrxmlPos, 'RECIPIENT', '', l_attrlist);
8158: l_attrlist.DELETE;
8159:

Line 8157: hdrxmlPos := WF_XML.NewTag(hdrxml, hdrxmlPos, 'RECIPIENT', '', l_attrlist);

8153: -- TO
8154: WF_XML.AddElementAttribute('name', l_to_role, l_attrlist);
8155: WF_XML.AddElementAttribute('type', 'to', l_attrlist);
8156:
8157: hdrxmlPos := WF_XML.NewTag(hdrxml, hdrxmlPos, 'RECIPIENT', '', l_attrlist);
8158: l_attrlist.DELETE;
8159:
8160:
8161: if (l_display_name is not null or l_display_name <> '') then

Line 8169: hdrxmlPos := WF_XML.NewTag(hdrxml, hdrxmlPos, 'NAME', l_display_name, l_attrlist);

8165: l_display_name := '';
8166: end if;
8167:
8168: -- attrlist is empty
8169: hdrxmlPos := WF_XML.NewTag(hdrxml, hdrxmlPos, 'NAME', l_display_name, l_attrlist);
8170: hdrxmlPos := WF_XML.SkipTag(hdrxml, 'NAME', hdrxmlPos, l_occurance);
8171:
8172: l_to_emailaddress := replace(l_to_emailaddress, g_newLine);
8173: l_to_emailaddress := '';

Line 8170: hdrxmlPos := WF_XML.SkipTag(hdrxml, 'NAME', hdrxmlPos, l_occurance);

8166: end if;
8167:
8168: -- attrlist is empty
8169: hdrxmlPos := WF_XML.NewTag(hdrxml, hdrxmlPos, 'NAME', l_display_name, l_attrlist);
8170: hdrxmlPos := WF_XML.SkipTag(hdrxml, 'NAME', hdrxmlPos, l_occurance);
8171:
8172: l_to_emailaddress := replace(l_to_emailaddress, g_newLine);
8173: l_to_emailaddress := '';
8174:

Line 8176: hdrxmlPos := WF_XML.NewTag(hdrxml, hdrxmlPos, 'ADDRESS', l_to_emailaddress, l_attrlist);

8172: l_to_emailaddress := replace(l_to_emailaddress, g_newLine);
8173: l_to_emailaddress := '';
8174:
8175: -- attrlist is empty
8176: hdrxmlPos := WF_XML.NewTag(hdrxml, hdrxmlPos, 'ADDRESS', l_to_emailaddress, l_attrlist);
8177: hdrxmlPos := WF_XML.SkipTag(hdrxml, 'ADDRESS', hdrxmlPos, l_occurance);
8178:
8179: hdrxmlPos := WF_XML.SkipTag(hdrxml, 'RECIPIENT', hdrxmlPos, l_occurance);
8180:

Line 8177: hdrxmlPos := WF_XML.SkipTag(hdrxml, 'ADDRESS', hdrxmlPos, l_occurance);

8173: l_to_emailaddress := '';
8174:
8175: -- attrlist is empty
8176: hdrxmlPos := WF_XML.NewTag(hdrxml, hdrxmlPos, 'ADDRESS', l_to_emailaddress, l_attrlist);
8177: hdrxmlPos := WF_XML.SkipTag(hdrxml, 'ADDRESS', hdrxmlPos, l_occurance);
8178:
8179: hdrxmlPos := WF_XML.SkipTag(hdrxml, 'RECIPIENT', hdrxmlPos, l_occurance);
8180:
8181: -- end RECIPIENTLIST tag

Line 8179: hdrxmlPos := WF_XML.SkipTag(hdrxml, 'RECIPIENT', hdrxmlPos, l_occurance);

8175: -- attrlist is empty
8176: hdrxmlPos := WF_XML.NewTag(hdrxml, hdrxmlPos, 'ADDRESS', l_to_emailaddress, l_attrlist);
8177: hdrxmlPos := WF_XML.SkipTag(hdrxml, 'ADDRESS', hdrxmlPos, l_occurance);
8178:
8179: hdrxmlPos := WF_XML.SkipTag(hdrxml, 'RECIPIENT', hdrxmlPos, l_occurance);
8180:
8181: -- end RECIPIENTLIST tag
8182: hdrxmlPos := WF_XML.SkipTag(hdrxml, 'RECIPIENTLIST', hdrxmlPos, l_occurance);
8183: l_attrlist.DELETE;

Line 8182: hdrxmlPos := WF_XML.SkipTag(hdrxml, 'RECIPIENTLIST', hdrxmlPos, l_occurance);

8178:
8179: hdrxmlPos := WF_XML.SkipTag(hdrxml, 'RECIPIENT', hdrxmlPos, l_occurance);
8180:
8181: -- end RECIPIENTLIST tag
8182: hdrxmlPos := WF_XML.SkipTag(hdrxml, 'RECIPIENTLIST', hdrxmlPos, l_occurance);
8183: l_attrlist.DELETE;
8184:
8185:
8186: -- Use from_role which asked the Question or requested for more info.

Line 8190: hdrxmlPos := WF_XML.NewTag(hdrxml, hdrxmlPos, 'FROM', '', l_attrlist);

8186: -- Use from_role which asked the Question or requested for more info.
8187: -- TODO : we should use Display name of that role.
8188: IF(l_from_role IS NOT NULL AND l_from_role <> '' ) then
8189: -- attrlist is empty
8190: hdrxmlPos := WF_XML.NewTag(hdrxml, hdrxmlPos, 'FROM', '', l_attrlist);
8191:
8192: l_from_role := replace(l_from_role, g_newLine);
8193: hdrxmlPos := WF_XML.NewTag(hdrxml, hdrxmlPos, 'NAME', l_from_role, l_attrlist);
8194: hdrxmlPos := WF_XML.SkipTag(hdrxml, 'NAME', hdrxmlPos, l_occurance);

Line 8193: hdrxmlPos := WF_XML.NewTag(hdrxml, hdrxmlPos, 'NAME', l_from_role, l_attrlist);

8189: -- attrlist is empty
8190: hdrxmlPos := WF_XML.NewTag(hdrxml, hdrxmlPos, 'FROM', '', l_attrlist);
8191:
8192: l_from_role := replace(l_from_role, g_newLine);
8193: hdrxmlPos := WF_XML.NewTag(hdrxml, hdrxmlPos, 'NAME', l_from_role, l_attrlist);
8194: hdrxmlPos := WF_XML.SkipTag(hdrxml, 'NAME', hdrxmlPos, l_occurance);
8195:
8196: hdrxmlPos := WF_XML.SkipTag(hdrxml, 'FROM', hdrxmlPos, l_occurance);
8197:

Line 8194: hdrxmlPos := WF_XML.SkipTag(hdrxml, 'NAME', hdrxmlPos, l_occurance);

8190: hdrxmlPos := WF_XML.NewTag(hdrxml, hdrxmlPos, 'FROM', '', l_attrlist);
8191:
8192: l_from_role := replace(l_from_role, g_newLine);
8193: hdrxmlPos := WF_XML.NewTag(hdrxml, hdrxmlPos, 'NAME', l_from_role, l_attrlist);
8194: hdrxmlPos := WF_XML.SkipTag(hdrxml, 'NAME', hdrxmlPos, l_occurance);
8195:
8196: hdrxmlPos := WF_XML.SkipTag(hdrxml, 'FROM', hdrxmlPos, l_occurance);
8197:
8198: end if;

Line 8196: hdrxmlPos := WF_XML.SkipTag(hdrxml, 'FROM', hdrxmlPos, l_occurance);

8192: l_from_role := replace(l_from_role, g_newLine);
8193: hdrxmlPos := WF_XML.NewTag(hdrxml, hdrxmlPos, 'NAME', l_from_role, l_attrlist);
8194: hdrxmlPos := WF_XML.SkipTag(hdrxml, 'NAME', hdrxmlPos, l_occurance);
8195:
8196: hdrxmlPos := WF_XML.SkipTag(hdrxml, 'FROM', hdrxmlPos, l_occurance);
8197:
8198: end if;
8199:
8200: l_attrlist.DELETE;

Line 8203: hdrxmlPos := WF_XML.NewTag(hdrxml, hdrxmlPos, 'SUBJECT', l_subject, l_attrlist);

8199:
8200: l_attrlist.DELETE;
8201: l_subject := replace(l_subject, g_newLine);
8202: l_subject := '';
8203: hdrxmlPos := WF_XML.NewTag(hdrxml, hdrxmlPos, 'SUBJECT', l_subject, l_attrlist);
8204:
8205: -- Add HEADER tag in LOB.
8206: l_pos := WF_XML.NewLOBTag(l_msg_doc, l_pos, 'HEADER', hdrxml, l_attrlist);
8207: l_pos := WF_XML.SkipLOBTag(l_msg_doc, 'HEADER', l_pos, l_occurance);

Line 8206: l_pos := WF_XML.NewLOBTag(l_msg_doc, l_pos, 'HEADER', hdrxml, l_attrlist);

8202: l_subject := '';
8203: hdrxmlPos := WF_XML.NewTag(hdrxml, hdrxmlPos, 'SUBJECT', l_subject, l_attrlist);
8204:
8205: -- Add HEADER tag in LOB.
8206: l_pos := WF_XML.NewLOBTag(l_msg_doc, l_pos, 'HEADER', hdrxml, l_attrlist);
8207: l_pos := WF_XML.SkipLOBTag(l_msg_doc, 'HEADER', l_pos, l_occurance);
8208: l_attrlist.DELETE;
8209:
8210: -- start

Line 8207: l_pos := WF_XML.SkipLOBTag(l_msg_doc, 'HEADER', l_pos, l_occurance);

8203: hdrxmlPos := WF_XML.NewTag(hdrxml, hdrxmlPos, 'SUBJECT', l_subject, l_attrlist);
8204:
8205: -- Add HEADER tag in LOB.
8206: l_pos := WF_XML.NewLOBTag(l_msg_doc, l_pos, 'HEADER', hdrxml, l_attrlist);
8207: l_pos := WF_XML.SkipLOBTag(l_msg_doc, 'HEADER', l_pos, l_occurance);
8208: l_attrlist.DELETE;
8209:
8210: -- start
8211: wf_xml.AddElementAttribute('content-type','multipart/mixed',l_attrlist);

Line 8211: wf_xml.AddElementAttribute('content-type','multipart/mixed',l_attrlist);

8207: l_pos := WF_XML.SkipLOBTag(l_msg_doc, 'HEADER', l_pos, l_occurance);
8208: l_attrlist.DELETE;
8209:
8210: -- start
8211: wf_xml.AddElementAttribute('content-type','multipart/mixed',l_attrlist);
8212: l_pos := wf_xml.NewLOBTag(l_msg_doc,l_pos,'CONTENT','',l_attrlist);
8213: l_attrlist.DELETE;
8214:
8215: -- start

Line 8212: l_pos := wf_xml.NewLOBTag(l_msg_doc,l_pos,'CONTENT','',l_attrlist);

8208: l_attrlist.DELETE;
8209:
8210: -- start
8211: wf_xml.AddElementAttribute('content-type','multipart/mixed',l_attrlist);
8212: l_pos := wf_xml.NewLOBTag(l_msg_doc,l_pos,'CONTENT','',l_attrlist);
8213: l_attrlist.DELETE;
8214:
8215: -- start
8216: wf_xml.AddElementAttribute('content-type','text/plain', l_attrlist);

Line 8216: wf_xml.AddElementAttribute('content-type','text/plain', l_attrlist);

8212: l_pos := wf_xml.NewLOBTag(l_msg_doc,l_pos,'CONTENT','',l_attrlist);
8213: l_attrlist.DELETE;
8214:
8215: -- start
8216: wf_xml.AddElementAttribute('content-type','text/plain', l_attrlist);
8217: l_pos := wf_xml.NewLOBTag(l_msg_doc,l_pos,'BODYPART', '', l_attrlist);
8218:
8219:
8220: l_messageidx := wf_temp_lob.getlob(g_lobtable);

Line 8217: l_pos := wf_xml.NewLOBTag(l_msg_doc,l_pos,'BODYPART', '', l_attrlist);

8213: l_attrlist.DELETE;
8214:
8215: -- start
8216: wf_xml.AddElementAttribute('content-type','text/plain', l_attrlist);
8217: l_pos := wf_xml.NewLOBTag(l_msg_doc,l_pos,'BODYPART', '', l_attrlist);
8218:
8219:
8220: l_messageidx := wf_temp_lob.getlob(g_lobtable);
8221:

Line 8236: l_pos := wf_xml.NewLOBTag(l_msg_doc,l_pos, 'MESSAGE',

8232:
8233: -- l_attrlist content-type='text/plain' will be used same
8234: -- as for BODYPART
8235: -- --
8236: l_pos := wf_xml.NewLOBTag(l_msg_doc,l_pos, 'MESSAGE',
8237: g_lobtable(l_messageidx).temp_lob,
8238: l_attrlist);
8239:
8240: l_pos := wf_xml.SkipLOBTag(l_msg_doc,'MESSAGE',l_pos,l_occurance);

Line 8240: l_pos := wf_xml.SkipLOBTag(l_msg_doc,'MESSAGE',l_pos,l_occurance);

8236: l_pos := wf_xml.NewLOBTag(l_msg_doc,l_pos, 'MESSAGE',
8237: g_lobtable(l_messageidx).temp_lob,
8238: l_attrlist);
8239:
8240: l_pos := wf_xml.SkipLOBTag(l_msg_doc,'MESSAGE',l_pos,l_occurance);
8241: l_attrlist.DELETE;
8242:
8243: -- end
8244: l_pos := wf_xml.SkipLOBTag(l_msg_doc,'BODYPART',l_pos,l_occurance);

Line 8244: l_pos := wf_xml.SkipLOBTag(l_msg_doc,'BODYPART',l_pos,l_occurance);

8240: l_pos := wf_xml.SkipLOBTag(l_msg_doc,'MESSAGE',l_pos,l_occurance);
8241: l_attrlist.DELETE;
8242:
8243: -- end
8244: l_pos := wf_xml.SkipLOBTag(l_msg_doc,'BODYPART',l_pos,l_occurance);
8245:
8246: -- TODO : << sstomar>>
8247: -- Later we will consider to send HTML body part
8248: -- commenting below code as of now.

Line 8257: --wf_xml.AddElementAttribute('content-type','text/html', l_attrlist);

8253:
8254: --l_attrlist.DELETE;
8255:
8256: -- start
8257: --wf_xml.AddElementAttribute('content-type','text/html', l_attrlist);
8258: --l_pos := wf_xml.NewLOBTag(l_msg_doc,l_pos,'BODYPART', '', l_attrlist);
8259:
8260: --dbms_lob.writeappend(g_lobtable(l_messageidx).temp_lob,
8261: -- LENGTH(l_start_cdata), l_start_cdata);

Line 8258: --l_pos := wf_xml.NewLOBTag(l_msg_doc,l_pos,'BODYPART', '', l_attrlist);

8254: --l_attrlist.DELETE;
8255:
8256: -- start
8257: --wf_xml.AddElementAttribute('content-type','text/html', l_attrlist);
8258: --l_pos := wf_xml.NewLOBTag(l_msg_doc,l_pos,'BODYPART', '', l_attrlist);
8259:
8260: --dbms_lob.writeappend(g_lobtable(l_messageidx).temp_lob,
8261: -- LENGTH(l_start_cdata), l_start_cdata);
8262:

Line 8269: --l_pos := wf_xml.NewLOBTag(l_msg_doc,l_pos, 'MESSAGE',

8265:
8266: --dbms_lob.writeappend(g_lobtable(l_messageidx).temp_lob,
8267: -- LENGTH(l_end_cdata),l_end_cdata);
8268:
8269: --l_pos := wf_xml.NewLOBTag(l_msg_doc,l_pos, 'MESSAGE',
8270: -- g_lobtable(l_messageidx).temp_lob,
8271: -- l_attrlist);
8272:
8273: --l_pos := wf_xml.SkipLOBTag(l_msg_doc,'MESSAGE',l_pos,l_occurance);

Line 8273: --l_pos := wf_xml.SkipLOBTag(l_msg_doc,'MESSAGE',l_pos,l_occurance);

8269: --l_pos := wf_xml.NewLOBTag(l_msg_doc,l_pos, 'MESSAGE',
8270: -- g_lobtable(l_messageidx).temp_lob,
8271: -- l_attrlist);
8272:
8273: --l_pos := wf_xml.SkipLOBTag(l_msg_doc,'MESSAGE',l_pos,l_occurance);
8274: --l_attrlist.DELETE;
8275:
8276: -- end
8277: --l_pos := wf_xml.SkipLOBTag(l_msg_doc,'BODYPART',l_pos,l_occurance);

Line 8277: --l_pos := wf_xml.SkipLOBTag(l_msg_doc,'BODYPART',l_pos,l_occurance);

8273: --l_pos := wf_xml.SkipLOBTag(l_msg_doc,'MESSAGE',l_pos,l_occurance);
8274: --l_attrlist.DELETE;
8275:
8276: -- end
8277: --l_pos := wf_xml.SkipLOBTag(l_msg_doc,'BODYPART',l_pos,l_occurance);
8278:
8279: -- end
8280: l_pos := wf_xml.skiplobtag(l_msg_doc,'CONTENT',l_pos,l_occurance);
8281: -- end

Line 8280: l_pos := wf_xml.skiplobtag(l_msg_doc,'CONTENT',l_pos,l_occurance);

8276: -- end
8277: --l_pos := wf_xml.SkipLOBTag(l_msg_doc,'BODYPART',l_pos,l_occurance);
8278:
8279: -- end
8280: l_pos := wf_xml.skiplobtag(l_msg_doc,'CONTENT',l_pos,l_occurance);
8281: -- end
8282: l_pos := wf_xml.skiplobtag(l_msg_doc,'NOTIFICATION',l_pos,l_occurance);
8283: -- end
8284: l_pos := wf_xml.skiplobtag(l_msg_doc,'NOTIFICATIONGROUP',l_pos,l_occurance);

Line 8282: l_pos := wf_xml.skiplobtag(l_msg_doc,'NOTIFICATION',l_pos,l_occurance);

8278:
8279: -- end
8280: l_pos := wf_xml.skiplobtag(l_msg_doc,'CONTENT',l_pos,l_occurance);
8281: -- end
8282: l_pos := wf_xml.skiplobtag(l_msg_doc,'NOTIFICATION',l_pos,l_occurance);
8283: -- end
8284: l_pos := wf_xml.skiplobtag(l_msg_doc,'NOTIFICATIONGROUP',l_pos,l_occurance);
8285:
8286:

Line 8284: l_pos := wf_xml.skiplobtag(l_msg_doc,'NOTIFICATIONGROUP',l_pos,l_occurance);

8280: l_pos := wf_xml.skiplobtag(l_msg_doc,'CONTENT',l_pos,l_occurance);
8281: -- end
8282: l_pos := wf_xml.skiplobtag(l_msg_doc,'NOTIFICATION',l_pos,l_occurance);
8283: -- end
8284: l_pos := wf_xml.skiplobtag(l_msg_doc,'NOTIFICATIONGROUP',l_pos,l_occurance);
8285:
8286:
8287: if(wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
8288: wf_log_pkg.string(wf_log_pkg.level_procedure,

Line 8290: 'Initializing ' || wf_xml.wf_ntf_send_message || ' event');

8286:
8287: if(wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
8288: wf_log_pkg.string(wf_log_pkg.level_procedure,
8289: 'wf.plsql.WF_MAIL.SendMoreInfoResponseWarning',
8290: 'Initializing ' || wf_xml.wf_ntf_send_message || ' event');
8291: end if;
8292:
8293: wf_event_t.initialize(l_event);
8294: l_event.event_name := wf_xml.wf_ntf_send_message;

Line 8294: l_event.event_name := wf_xml.wf_ntf_send_message;

8290: 'Initializing ' || wf_xml.wf_ntf_send_message || ' event');
8291: end if;
8292:
8293: wf_event_t.initialize(l_event);
8294: l_event.event_name := wf_xml.wf_ntf_send_message;
8295:
8296: -- Create an event key : make it as 0 so that this warning message
8297: -- waon't rely on wf_notification TABLE.
8298: l_event.event_key := 0;