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_NOTIFICATION

Line 77: g_ntfDocText varchar2(30) := wf_notification.doc_text;

73: g_none varchar2(200);
74: g_truncate varchar2(200);
75: g_noResult varchar2(200);
76: g_install varchar2(60) := wf_core.translate('WF_INSTALL');
77: g_ntfDocText varchar2(30) := wf_notification.doc_text;
78: g_ntfDocHtml varchar2(30) := wf_notification.doc_html;
79: g_Id varchar2(30);
80: g_isFwkNtf boolean;
81: g_sig_required varchar2(1);

Line 78: g_ntfDocHtml varchar2(30) := wf_notification.doc_html;

74: g_truncate varchar2(200);
75: g_noResult varchar2(200);
76: g_install varchar2(60) := wf_core.translate('WF_INSTALL');
77: g_ntfDocText varchar2(30) := wf_notification.doc_text;
78: g_ntfDocHtml varchar2(30) := wf_notification.doc_html;
79: g_Id varchar2(30);
80: g_isFwkNtf boolean;
81: g_sig_required varchar2(1);
82: g_fwk_flavor varchar2(255);

Line 174: from wf_notifications

170: parameterList wf_parameter_list_t;
171: begin
172: select message_type, message_name, mail_status, recipient_role
173: into l_mType, l_mName, l_currState, l_role
174: from wf_notifications
175: where notification_id = nid;
176:
177: -- If the prevsious state was FAILED, then preserve this state.
178: -- A new status of null means that a null message was sent.

Line 189: update WF_NOTIFICATIONS

185: end if;
186:
187: if updateState then
188: -- This notification had already locked by wfmail() in the mailer
189: update WF_NOTIFICATIONS
190: set MAIL_STATUS = UpdateStatus2.status
191: where NOTIFICATION_ID = nid;
192: end if;
193:

Line 202: -- oracle.apps.wf.notification.send.failure

198: error_name => UpdateStatus2.error_name,
199: external_error => UpdateStatus2.external_error);
200: elsif (UpdateStatus2.status = 'FAILED') then
201: -- Here we only raise an event and leave the message as is.
202: -- oracle.apps.wf.notification.send.failure
203: parameterlist := wf_parameter_list_t();
204:
205: wf_event.AddParameterToList('NOTIFICATION_ID',nid,parameterlist);
206: wf_event.AddParameterToList('ROLE',l_role,parameterlist);

Line 215: wf_event.Raise(p_event_name => 'oracle.apps.wf.notification.send.failure',

211: parameterlist);
212: wf_event.addParameterToList('Q_CORRELATION_ID', l_mType || ':' || l_mName, parameterlist);
213:
214: --Raise the event
215: wf_event.Raise(p_event_name => 'oracle.apps.wf.notification.send.failure',
216: p_event_key => l_role,
217: p_parameters => parameterlist);
218:
219: elsif UpdateStatus2.status = 'UNAVAIL' then

Line 236: wf_event.Raise(p_event_name=>'oracle.apps.wf.notification.receive.unavail',

232:
233: -- Raise the event
234: -- As of now there is NO subscription of this event with SOURCE_TYPE LOCAL.
235: -- So this is just for future point of view ....
236: wf_event.Raise(p_event_name=>'oracle.apps.wf.notification.receive.unavail',
237: p_event_key => to_char(nid),
238: p_parameters => parameterlist);
239:
240: elsif (UpdateStatus2.status = 'SENT') then

Line 247: update WF_NOTIFICATIONS N

243: -- This is contrary to the behaviour of previous releases
244: -- and will be re-Addressed a little later on.
245:
246: -- close this notification if there is no response
247: update WF_NOTIFICATIONS N
248: set N.STATUS = 'CLOSED',
249: N.END_DATE = sysdate
250: where N.NOTIFICATION_ID = nid
251: and not exists (select NULL

Line 284: l_recipient WF_NOTIFICATIONS.RECIPIENT_ROLE%TYPE;

280: -- Queue number on which to process
281: procedure ResetFailed(p_queue varchar2)
282: is
283: l_nid number;
284: l_recipient WF_NOTIFICATIONS.RECIPIENT_ROLE%TYPE;
285: l_status varchar2 (8);
286: l_timeout boolean;
287: l_error_result varchar2(2000);
288:

Line 299: update WF_NOTIFICATIONS N

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'
301: where N.NOTIFICATION_ID = l_nid;
302: -- wf_xml.EnqueueNotification(l_nid);
303: end if;

Line 342: from WF_NOTIFICATIONS

338: begin
339: -- Get the callback function.
340: select CALLBACK, CONTEXT, RECIPIENT_ROLE
341: into cb, ctx, role
342: from WF_NOTIFICATIONS
343: where NOTIFICATION_ID = nid;
344:
345: -- If there is no callback, just clear any error and return.
346: if (cb is null) then

Line 404: -- This function is triggered by the oracle.apps.wf.notification.send.failure

400:
401: -- Disable_Recipient_Ntf_pref
402: -- Updates the recipient of a notification to DISABLED where
403: -- there has been a failure to deliver to their email address.
404: -- This function is triggered by the oracle.apps.wf.notification.send.failure
405: -- event.
406: function Disable_Recipient_Ntf_Pref(p_subscription_guid in raw,
407: p_event in out NOCOPY WF_EVENT_T) return varchar2
408: is

Line 502: from wf_notifications

498: end if;
499:
500: select recipient_role
501: into recipient
502: from wf_notifications
503: where notification_id = nid;
504:
505: exception
506: when no_data_found then

Line 674: alertNid := WF_NOTIFICATION.send(role => 'SYSADMIN',

670:
671: current_maxthreshold := wf_event.phase_maxthreshold;
672: wf_event.SetDispatchMode ('ASYNC');
673:
674: alertNid := WF_NOTIFICATION.send(role => 'SYSADMIN',
675: msg_type => 'WFMAIL',
676: msg_name => 'USER_PREF_UPDATE_REPORT');
677:
678: -- Set the attributes for the report. The message won't be dispatched

Line 680: WF_NOTIFICATION.setAttrText(nid => alertNid,

676: msg_name => 'USER_PREF_UPDATE_REPORT');
677:
678: -- Set the attributes for the report. The message won't be dispatched
679: -- until the commit is performed by the calling process.
680: WF_NOTIFICATION.setAttrText(nid => alertNid,
681: aname => 'NOTIFICATION_ID',
682: avalue => to_char(nid));
683: WF_NOTIFICATION.setAttrText(nid => alertNid,
684: aname => 'ROLE',

Line 683: WF_NOTIFICATION.setAttrText(nid => alertNid,

679: -- until the commit is performed by the calling process.
680: WF_NOTIFICATION.setAttrText(nid => alertNid,
681: aname => 'NOTIFICATION_ID',
682: avalue => to_char(nid));
683: WF_NOTIFICATION.setAttrText(nid => alertNid,
684: aname => 'ROLE',
685: avalue => role);
686: WF_NOTIFICATION.setAttrText(nid => alertNid,
687: aname => 'UPDATED_USER_REPORT',

Line 686: WF_NOTIFICATION.setAttrText(nid => alertNid,

682: avalue => to_char(nid));
683: WF_NOTIFICATION.setAttrText(nid => alertNid,
684: aname => 'ROLE',
685: avalue => role);
686: WF_NOTIFICATION.setAttrText(nid => alertNid,
687: aname => 'UPDATED_USER_REPORT',
688: avalue => errorReport);
689:
690: -- Ensure that the subject is correctly populated.

Line 691: WF_NOTIFICATION.Denormalize_Notification(alertNid);

687: aname => 'UPDATED_USER_REPORT',
688: avalue => errorReport);
689:
690: -- Ensure that the subject is correctly populated.
691: WF_NOTIFICATION.Denormalize_Notification(alertNid);
692:
693: -- Resetting the wf_event.phase_maxthreshold value
694: wf_event.phase_maxthreshold := current_maxthreshold;
695:

Line 876: Wf_Notification.SetAttrText(nid, 'MAIL_ERROR_NAME', errname);

872: error_result := errmsg;
873:
874: -- Set MAIL_ERROR_NAME attribute
875: begin
876: Wf_Notification.SetAttrText(nid, 'MAIL_ERROR_NAME', errname);
877: exception
878: when no_program_unit then
879: raise;
880: when others then

Line 883: Wf_Notification.AddAttr(nid, 'MAIL_ERROR_NAME');

879: raise;
880: when others then
881: if (wf_core.error_name = 'WFNTF_ATTR') then
882: Wf_Core.Clear;
883: Wf_Notification.AddAttr(nid, 'MAIL_ERROR_NAME');
884: Wf_Notification.SetAttrText(nid, 'MAIL_ERROR_NAME', errname);
885: end if;
886: end;
887:

Line 884: Wf_Notification.SetAttrText(nid, 'MAIL_ERROR_NAME', errname);

880: when others then
881: if (wf_core.error_name = 'WFNTF_ATTR') then
882: Wf_Core.Clear;
883: Wf_Notification.AddAttr(nid, 'MAIL_ERROR_NAME');
884: Wf_Notification.SetAttrText(nid, 'MAIL_ERROR_NAME', errname);
885: end if;
886: end;
887:
888: -- Bug# 2301881 setting the values for message attributes

Line 891: Wf_Notification.SetAttrText(nid, 'MAIL_ERROR_MESSAGE', errmsg);

887:
888: -- Bug# 2301881 setting the values for message attributes
889: -- Set MAIL_ERROR_MESSAGE attribute
890: begin
891: Wf_Notification.SetAttrText(nid, 'MAIL_ERROR_MESSAGE', errmsg);
892: exception
893: when no_program_unit then
894: raise;
895: when others then

Line 898: Wf_Notification.AddAttr(nid, 'MAIL_ERROR_MESSAGE');

894: raise;
895: when others then
896: if (wf_core.error_name = 'WFNTF_ATTR') then
897: Wf_Core.Clear;
898: Wf_Notification.AddAttr(nid, 'MAIL_ERROR_MESSAGE');
899: Wf_Notification.SetAttrText(nid, 'MAIL_ERROR_MESSAGE', errmsg);
900: end if;
901: end;
902:

Line 899: Wf_Notification.SetAttrText(nid, 'MAIL_ERROR_MESSAGE', errmsg);

895: when others then
896: if (wf_core.error_name = 'WFNTF_ATTR') then
897: Wf_Core.Clear;
898: Wf_Notification.AddAttr(nid, 'MAIL_ERROR_MESSAGE');
899: Wf_Notification.SetAttrText(nid, 'MAIL_ERROR_MESSAGE', errmsg);
900: end if;
901: end;
902:
903: -- Set MAIL_VALUE_FOUND attribute

Line 905: Wf_Notification.SetAttrText(nid, 'MAIL_VALUE_FOUND', value_found);

901: end;
902:
903: -- Set MAIL_VALUE_FOUND attribute
904: begin
905: Wf_Notification.SetAttrText(nid, 'MAIL_VALUE_FOUND', value_found);
906: exception
907: when no_program_unit then
908: raise;
909: when others then

Line 912: Wf_Notification.AddAttr(nid, 'MAIL_VALUE_FOUND');

908: raise;
909: when others then
910: if (wf_core.error_name = 'WFNTF_ATTR') then
911: Wf_Core.Clear;
912: Wf_Notification.AddAttr(nid, 'MAIL_VALUE_FOUND');
913: Wf_Notification.SetAttrText(nid, 'MAIL_VALUE_FOUND', value_found);
914: end if;
915: end;
916:

Line 913: Wf_Notification.SetAttrText(nid, 'MAIL_VALUE_FOUND', value_found);

909: when others then
910: if (wf_core.error_name = 'WFNTF_ATTR') then
911: Wf_Core.Clear;
912: Wf_Notification.AddAttr(nid, 'MAIL_VALUE_FOUND');
913: Wf_Notification.SetAttrText(nid, 'MAIL_VALUE_FOUND', value_found);
914: end if;
915: end;
916:
917: -- Set MAIL_EXP_VALUES attribute

Line 919: Wf_Notification.SetAttrText(nid, 'MAIL_EXP_VALUES', remarks);

915: end;
916:
917: -- Set MAIL_EXP_VALUES attribute
918: begin
919: Wf_Notification.SetAttrText(nid, 'MAIL_EXP_VALUES', remarks);
920: exception
921: when no_program_unit then
922: raise;
923: when others then

Line 926: Wf_Notification.AddAttr(nid, 'MAIL_EXP_VALUES');

922: raise;
923: when others then
924: if (wf_core.error_name = 'WFNTF_ATTR') then
925: Wf_Core.Clear;
926: Wf_Notification.AddAttr(nid, 'MAIL_EXP_VALUES');
927: Wf_Notification.SetAttrText(nid, 'MAIL_EXP_VALUES', remarks);
928: end if;
929: end;
930:

Line 927: Wf_Notification.SetAttrText(nid, 'MAIL_EXP_VALUES', remarks);

923: when others then
924: if (wf_core.error_name = 'WFNTF_ATTR') then
925: Wf_Core.Clear;
926: Wf_Notification.AddAttr(nid, 'MAIL_EXP_VALUES');
927: Wf_Notification.SetAttrText(nid, 'MAIL_EXP_VALUES', remarks);
928: end if;
929: end;
930:
931: -- End Bug# 2301881

Line 939: Wf_Notification.SetAttrText(nid, 'MAIL_ERROR_STACK', errstack);

935: errstack := ' ';
936: end if;
937:
938: begin
939: Wf_Notification.SetAttrText(nid, 'MAIL_ERROR_STACK', errstack);
940: exception
941: when no_program_unit then
942: raise;
943: when others then

Line 946: Wf_Notification.AddAttr(nid, 'MAIL_ERROR_STACK');

942: raise;
943: when others then
944: if (wf_core.error_name = 'WFNTF_ATTR') then
945: Wf_Core.Clear;
946: Wf_Notification.AddAttr(nid, 'MAIL_ERROR_STACK');
947: Wf_Notification.SetAttrText(nid, 'MAIL_ERROR_STACK', errstack);
948: end if;
949: end;
950:

Line 947: Wf_Notification.SetAttrText(nid, 'MAIL_ERROR_STACK', errstack);

943: when others then
944: if (wf_core.error_name = 'WFNTF_ATTR') then
945: Wf_Core.Clear;
946: Wf_Notification.AddAttr(nid, 'MAIL_ERROR_STACK');
947: Wf_Notification.SetAttrText(nid, 'MAIL_ERROR_STACK', errstack);
948: end if;
949: end;
950:
951: -- Set the mail_status to INVALID (mailer will pick this up)

Line 952: update WF_NOTIFICATIONS

948: end if;
949: end;
950:
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:

Line 959: from wf_notifications

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
960: where notification_id = nid;
961:
962: wf_event.AddParameterToList('NOTIFICATION_ID', nid, parameterlist);
963: wf_event.AddParameterToList('ROLE', role, parameterlist);

Line 974: wf_event.Raise(p_event_name => 'oracle.apps.wf.notification.send',

970: 'Raising the Send event');
971: end if;
972:
973: --Raise the event
974: wf_event.Raise(p_event_name => 'oracle.apps.wf.notification.send',
975: p_event_key => to_char(nid),
976: p_parameters => parameterlist);
977:
978: exception

Line 1292: from WF_NOTIFICATION_ATTRIBUTES WNA,

1288: '', to_char(WNA.DATE_VALUE),
1289: to_char(WNA.DATE_VALUE, WMA.FORMAT)),
1290: 'LOOKUP', WNA.TEXT_VALUE,
1291: WNA.TEXT_VALUE) VALUE
1292: from WF_NOTIFICATION_ATTRIBUTES WNA,
1293: WF_NOTIFICATIONS WN,
1294: WF_MESSAGE_ATTRIBUTES_VL WMA
1295: where WNA.NOTIFICATION_ID = nid
1296: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID

Line 1293: WF_NOTIFICATIONS WN,

1289: to_char(WNA.DATE_VALUE, WMA.FORMAT)),
1290: 'LOOKUP', WNA.TEXT_VALUE,
1291: WNA.TEXT_VALUE) VALUE
1292: from WF_NOTIFICATION_ATTRIBUTES WNA,
1293: WF_NOTIFICATIONS WN,
1294: WF_MESSAGE_ATTRIBUTES_VL WMA
1295: where WNA.NOTIFICATION_ID = nid
1296: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID
1297: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE

Line 1363: from WF_NOTIFICATION_ATTRIBUTES WNA,

1359: '', to_char(WNA.DATE_VALUE),
1360: to_char(WNA.DATE_VALUE, WMA.FORMAT)),
1361: 'LOOKUP', WNA.TEXT_VALUE,
1362: WNA.TEXT_VALUE) VALUE
1363: from WF_NOTIFICATION_ATTRIBUTES WNA,
1364: WF_NOTIFICATIONS WN,
1365: WF_MESSAGE_ATTRIBUTES_VL WMA
1366: where WNA.NOTIFICATION_ID = nid
1367: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID

Line 1364: WF_NOTIFICATIONS WN,

1360: to_char(WNA.DATE_VALUE, WMA.FORMAT)),
1361: 'LOOKUP', WNA.TEXT_VALUE,
1362: WNA.TEXT_VALUE) VALUE
1363: from WF_NOTIFICATION_ATTRIBUTES WNA,
1364: WF_NOTIFICATIONS WN,
1365: WF_MESSAGE_ATTRIBUTES_VL WMA
1366: where WNA.NOTIFICATION_ID = nid
1367: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID
1368: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE

Line 1557: and ias.item_key = itemKey) intf, wf_notifications ntf

1553: union all
1554: select notification_id
1555: from wf_item_activity_statuses_h ias
1556: where ias.item_type = itemType
1557: and ias.item_key = itemKey) intf, wf_notifications ntf
1558: where intf.notification_id = ntf.group_id)
1559: where role <> current_role
1560: and role not in (select wur.role_name
1561: from wf_user_roles wur

Line 1571: from wf_notifications

1567:
1568: begin
1569: select context
1570: into context
1571: from wf_notifications
1572: where notification_id = nid;
1573:
1574: -- get item type and item key from the context
1575: pos := instr(context, ':', 1, 1);

Line 1707: body := body || wf_notification.SubstituteSpecialChars(l_requestee);

1703: l_requestee := GetMoreInfoLOV(nid, g_to_role);
1704: if (l_requestee is null) then
1705: l_requestee := g_moreInfoRequestee;
1706: end if;
1707: body := body || wf_notification.SubstituteSpecialChars(l_requestee);
1708: -- body := body || GetMoreInfoLOV(nid, g_to_role);
1709:
1710: -- ankung (continuation of above)
1711: body := body || wf_mail.g_close_html_delimiter;

Line 1771: from WF_NOTIFICATION_ATTRIBUTES WNA,

1767: '', to_char(WNA.DATE_VALUE),
1768: to_char(WNA.DATE_VALUE, WMA.FORMAT)),
1769: 'LOOKUP', WNA.TEXT_VALUE,
1770: WNA.TEXT_VALUE) VALUE
1771: from WF_NOTIFICATION_ATTRIBUTES WNA,
1772: WF_NOTIFICATIONS WN,
1773: WF_MESSAGE_ATTRIBUTES_VL WMA
1774: where WNA.NOTIFICATION_ID = nid
1775: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID

Line 1772: WF_NOTIFICATIONS WN,

1768: to_char(WNA.DATE_VALUE, WMA.FORMAT)),
1769: 'LOOKUP', WNA.TEXT_VALUE,
1770: WNA.TEXT_VALUE) VALUE
1771: from WF_NOTIFICATION_ATTRIBUTES WNA,
1772: WF_NOTIFICATIONS WN,
1773: WF_MESSAGE_ATTRIBUTES_VL WMA
1774: where WNA.NOTIFICATION_ID = nid
1775: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID
1776: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE

Line 1855: from WF_NOTIFICATION_ATTRIBUTES WNA,

1851: '', to_char(WNA.DATE_VALUE),
1852: to_char(WNA.DATE_VALUE, WMA.FORMAT)),
1853: 'LOOKUP', WNA.TEXT_VALUE,
1854: WNA.TEXT_VALUE) VALUE
1855: from WF_NOTIFICATION_ATTRIBUTES WNA,
1856: WF_NOTIFICATIONS WN,
1857: WF_MESSAGE_ATTRIBUTES_VL WMA
1858: where WNA.NOTIFICATION_ID = nid
1859: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID

Line 1856: WF_NOTIFICATIONS WN,

1852: to_char(WNA.DATE_VALUE, WMA.FORMAT)),
1853: 'LOOKUP', WNA.TEXT_VALUE,
1854: WNA.TEXT_VALUE) VALUE
1855: from WF_NOTIFICATION_ATTRIBUTES WNA,
1856: WF_NOTIFICATIONS WN,
1857: WF_MESSAGE_ATTRIBUTES_VL WMA
1858: where WNA.NOTIFICATION_ID = nid
1859: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID
1860: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE

Line 1958: from WF_NOTIFICATION_ATTRIBUTES WNA,

1954: is
1955: -- SQL Statement for fetching URL RESPONSE attributes.
1956: cursor c1 is
1957: select WMA.NAME, WMA.DISPLAY_NAME, WNA.TEXT_VALUE, WMA.DESCRIPTION
1958: from WF_NOTIFICATION_ATTRIBUTES WNA,
1959: WF_NOTIFICATIONS WN,
1960: WF_MESSAGE_ATTRIBUTES_VL WMA
1961: where WNA.NOTIFICATION_ID = nid
1962: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID

Line 1959: WF_NOTIFICATIONS WN,

1955: -- SQL Statement for fetching URL RESPONSE attributes.
1956: cursor c1 is
1957: select WMA.NAME, WMA.DISPLAY_NAME, WNA.TEXT_VALUE, WMA.DESCRIPTION
1958: from WF_NOTIFICATION_ATTRIBUTES WNA,
1959: WF_NOTIFICATIONS WN,
1960: WF_MESSAGE_ATTRIBUTES_VL WMA
1961: where WNA.NOTIFICATION_ID = nid
1962: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID
1963: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE

Line 2002: buffer := buffer|| '';

1998: buffer := buffer||'

';
1999: if (rec.description is not null) then
2000: buffer := buffer||rec.description||'

';
2001: end if;
2002: buffer := buffer|| '';
2003: buffer := buffer||' '||rec.display_name;
2004: buffer := buffer||''||'';
2005: buffer := buffer||g_newLine;
2006: end loop;

Line 2030: from WF_NOTIFICATION_ATTRIBUTES WNA,

2026: to_char(WNA.DATE_VALUE, WMA.FORMAT)),
2027: 'LOOKUP', WNA.TEXT_VALUE,
2028: WNA.TEXT_VALUE), WMA.DESCRIPTION
2029: into disp_name, attr_type, attr_format, attr_value, attr_desc
2030: from WF_NOTIFICATION_ATTRIBUTES WNA,
2031: WF_NOTIFICATIONS WN,
2032: WF_MESSAGE_ATTRIBUTES_VL WMA
2033: where WNA.NOTIFICATION_ID = nid
2034: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID

Line 2031: WF_NOTIFICATIONS WN,

2027: 'LOOKUP', WNA.TEXT_VALUE,
2028: WNA.TEXT_VALUE), WMA.DESCRIPTION
2029: into disp_name, attr_type, attr_format, attr_value, attr_desc
2030: from WF_NOTIFICATION_ATTRIBUTES WNA,
2031: WF_NOTIFICATIONS WN,
2032: WF_MESSAGE_ATTRIBUTES_VL WMA
2033: where WNA.NOTIFICATION_ID = nid
2034: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID
2035: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE

Line 2148: -- n_due_date_text := to_char(n_due_date, Wf_Notification.g_nls_date_mask);

2144:
2145: begin
2146: -- BLAF recommends displaying date with the TIME element
2147:
2148: -- n_due_date_text := to_char(n_due_date, Wf_Notification.g_nls_date_mask);
2149: -- n_start_date_text := to_char(n_start_date, Wf_Notification.g_nls_date_mask);
2150: -- >: 7578922
2151: n_start_date_text := wf_notification_util.GetCalendarDate(n_nid, n_start_date, null, true);
2152: n_due_date_text := wf_notification_util.GetCalendarDate(n_nid, n_due_date, null, true);

Line 2149: -- n_start_date_text := to_char(n_start_date, Wf_Notification.g_nls_date_mask);

2145: begin
2146: -- BLAF recommends displaying date with the TIME element
2147:
2148: -- n_due_date_text := to_char(n_due_date, Wf_Notification.g_nls_date_mask);
2149: -- n_start_date_text := to_char(n_start_date, Wf_Notification.g_nls_date_mask);
2150: -- >: 7578922
2151: n_start_date_text := wf_notification_util.GetCalendarDate(n_nid, n_start_date, null, true);
2152: n_due_date_text := wf_notification_util.GetCalendarDate(n_nid, n_due_date, null, true);
2153:

Line 2151: n_start_date_text := wf_notification_util.GetCalendarDate(n_nid, n_start_date, null, true);

2147:
2148: -- n_due_date_text := to_char(n_due_date, Wf_Notification.g_nls_date_mask);
2149: -- n_start_date_text := to_char(n_start_date, Wf_Notification.g_nls_date_mask);
2150: -- >: 7578922
2151: n_start_date_text := wf_notification_util.GetCalendarDate(n_nid, n_start_date, null, true);
2152: n_due_date_text := wf_notification_util.GetCalendarDate(n_nid, n_due_date, null, true);
2153:
2154: n_end_date_text := wf_notification_util.GetCalendarDate(n_nid, n_end_date, null, true);
2155:

Line 2152: n_due_date_text := wf_notification_util.GetCalendarDate(n_nid, n_due_date, null, true);

2148: -- n_due_date_text := to_char(n_due_date, Wf_Notification.g_nls_date_mask);
2149: -- n_start_date_text := to_char(n_start_date, Wf_Notification.g_nls_date_mask);
2150: -- >: 7578922
2151: n_start_date_text := wf_notification_util.GetCalendarDate(n_nid, n_start_date, null, true);
2152: n_due_date_text := wf_notification_util.GetCalendarDate(n_nid, n_due_date, null, true);
2153:
2154: n_end_date_text := wf_notification_util.GetCalendarDate(n_nid, n_end_date, null, true);
2155:
2156: if (n_priority > 66) then

Line 2154: n_end_date_text := wf_notification_util.GetCalendarDate(n_nid, n_end_date, null, true);

2150: -- >: 7578922
2151: n_start_date_text := wf_notification_util.GetCalendarDate(n_nid, n_start_date, null, true);
2152: n_due_date_text := wf_notification_util.GetCalendarDate(n_nid, n_due_date, null, true);
2153:
2154: n_end_date_text := wf_notification_util.GetCalendarDate(n_nid, n_end_date, null, true);
2155:
2156: if (n_priority > 66) then
2157: --Bug 2774891 fix - sacsharm
2158: --n_priority_text := wf_core.substitute('WFTKN', 'HIGH');

Line 2354: WF_NOTIFICATIONS N

2350: select 1 into fyi
2351: from dual
2352: where not exists (select NULL
2353: from WF_MESSAGE_ATTRIBUTES MA,
2354: WF_NOTIFICATIONS N
2355: where N.NOTIFICATION_ID = nid
2356: and MA.MESSAGE_TYPE = N.MESSAGE_TYPE
2357: and MA.MESSAGE_NAME = N.MESSAGE_NAME
2358: and MA.SUBTYPE = 'RESPOND');

Line 2380: from wf_notifications

2376: end if;
2377:
2378: select message_type, message_name
2379: into mType, mName
2380: from wf_notifications
2381: where notification_id = nid;
2382:
2383: -- Now that the template name has been derrived, see
2384: -- if the default value has been overridden.

Line 2458: Wf_Notification.GetSignatureRequired(n_sig_policy, nid, g_sig_required,

2454: n_nid_str := 'NID '||to_char(nid);
2455: return;
2456: end if;
2457:
2458: Wf_Notification.GetSignatureRequired(n_sig_policy, nid, g_sig_required,
2459: g_fwk_flavor, g_email_flavor, g_render);
2460:
2461: -- No signature required for this notification
2462: if (g_sig_required = 'N') then

Line 2531: WF_NOTIFICATION_ATTRIBUTES WNA,

2527: is
2528: cursor headers(nid in Number) is
2529: select WMA.NAME
2530: from WF_MESSAGE_ATTRIBUTES_VL WMA,
2531: WF_NOTIFICATION_ATTRIBUTES WNA,
2532: WF_NOTIFICATIONS WN
2533: where WNA.NOTIFICATION_ID = nid
2534: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID
2535: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE

Line 2532: WF_NOTIFICATIONS WN

2528: cursor headers(nid in Number) is
2529: select WMA.NAME
2530: from WF_MESSAGE_ATTRIBUTES_VL WMA,
2531: WF_NOTIFICATION_ATTRIBUTES WNA,
2532: WF_NOTIFICATIONS WN
2533: where WNA.NOTIFICATION_ID = nid
2534: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID
2535: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE
2536: and WN.MESSAGE_NAME = WMA.MESSAGE_NAME

Line 2546: cells wf_notification.tdType;

2542: order by WMA.SEQUENCE;
2543:
2544: nid number;
2545: attrList varchar2(4000);
2546: cells wf_notification.tdType;
2547: j pls_integer;
2548: pos pls_integer;
2549: language varchar2(30);
2550: headerTable varchar2(32000);

Line 2572: FROM wf_notifications

2568:
2569: begin
2570: SELECT due_date, from_user
2571: INTO l_due_date, l_from_user
2572: FROM wf_notifications
2573: WHERE notification_id = nid;
2574: exception
2575: when no_data_found then
2576: wf_core.token('NID', to_char(nid));

Line 2592: document := wf_notification.wf_msg_attr(nid, attrList, display_type);

2588:
2589: document := '';
2590: if display_type = g_ntfDocText then
2591: if length(attrList) > 0 then
2592: document := wf_notification.wf_msg_attr(nid, attrList, display_type);
2593: end if;
2594: elsif display_type = g_ntfDocHtml then
2595: document := ''||g_newLine;
2596: document := document || '
';

Line 2637: wf_notification.NTF_Table(cells => cells, col => 3, type => 'N'||l_dir,

2633: j := j + 1;
2634: cells(j) := 'S12:';
2635: j := j + 1;
2636: cells(j) := 'S:'||'&'||'NOTIFICATION_ID';
2637: wf_notification.NTF_Table(cells => cells, col => 3, type => 'N'||l_dir,
2638: rs => headerTable);
2639:
2640: document := document || headerTable || g_newLine;
2641: document := document || '
' || g_newLine;

Line 2643: wf_notification.set_ntf_table_type('N');

2639:
2640: document := document || headerTable || g_newLine;
2641: document := document || '
' || g_newLine;
2642: if length(attrList) > 0 then
2643: wf_notification.set_ntf_table_type('N');
2644: wf_notification.set_ntf_table_direction(l_dir);
2645: document := document||wf_notification.wf_msg_attr(nid, attrList, display_type);
2646: wf_notification.set_ntf_table_type('V');
2647: end if;

Line 2644: wf_notification.set_ntf_table_direction(l_dir);

2640: document := document || headerTable || g_newLine;
2641: document := document || '
' || g_newLine;
2642: if length(attrList) > 0 then
2643: wf_notification.set_ntf_table_type('N');
2644: wf_notification.set_ntf_table_direction(l_dir);
2645: document := document||wf_notification.wf_msg_attr(nid, attrList, display_type);
2646: wf_notification.set_ntf_table_type('V');
2647: end if;
2648: document := document || '
'||g_newLine;

Line 2645: document := document||wf_notification.wf_msg_attr(nid, attrList, display_type);

2641: document := document || '' || g_newLine;
2642: if length(attrList) > 0 then
2643: wf_notification.set_ntf_table_type('N');
2644: wf_notification.set_ntf_table_direction(l_dir);
2645: document := document||wf_notification.wf_msg_attr(nid, attrList, display_type);
2646: wf_notification.set_ntf_table_type('V');
2647: end if;
2648: document := document || ''||g_newLine;
2649: else

Line 2646: wf_notification.set_ntf_table_type('V');

2642: if length(attrList) > 0 then
2643: wf_notification.set_ntf_table_type('N');
2644: wf_notification.set_ntf_table_direction(l_dir);
2645: document := document||wf_notification.wf_msg_attr(nid, attrList, display_type);
2646: wf_notification.set_ntf_table_type('V');
2647: end if;
2648: document := document || ''||g_newLine;
2649: else
2650: document := '';

Line 2755: -- Bug 2094159 get from_user from wf_notifications

2751: n_dir varchar2(16);
2752:
2753: begin
2754: -- Get notification information
2755: -- Bug 2094159 get from_user from wf_notifications
2756: begin
2757: select STATUS, MAIL_STATUS, ACCESS_KEY,
2758: RECIPIENT_ROLE, PRIORITY, USER_COMMENT,
2759: BEGIN_DATE, END_DATE, DUE_DATE, FROM_USER,

Line 2765: from WF_NOTIFICATIONS

2761: into n_status, n_mstatus, n_key,
2762: n_to_role, n_priority, n_comment,
2763: n_start_date, n_end_date, n_due_date, n_from_user,
2764: n_more_info_role
2765: from WF_NOTIFICATIONS
2766: where NOTIFICATION_ID = nid;
2767: exception
2768: when no_data_found then
2769: wf_core.token('NID', to_char(nid));

Line 2790: if (wf_notification.HideMoreInfo(nid) = 'N') then

2786: -- Timezone will not be supported in this version of the GetMessage
2787: -- API.
2788: n_timezone := '';
2789:
2790: if (wf_notification.HideMoreInfo(nid) = 'N') then
2791: if(n_more_info_role is not null) then
2792: n_to_role := n_more_info_role;
2793: g_to_role := n_more_info_role;
2794: g_moreinfo := 'SUB';

Line 2806: wf_notification.GetComments(nid, g_ntfDocText,

2802: Wf_Directory.GetRoleInfo(n_to_role, r_dname, r_email, r_ntf_pref,
2803: r_language, r_territory);
2804: r_ntf_pref := nvl(r_ntf_pref, 'QUERY');
2805:
2806: wf_notification.GetComments(nid, g_ntfDocText,
2807: n_text_history, n_last_ques);
2808: wf_notification.GetComments(nid, g_ntfDocHtml,
2809: n_html_history, n_last_ques);
2810: if n_text_history is not null or n_text_history <> '' then

Line 2808: wf_notification.GetComments(nid, g_ntfDocHtml,

2804: r_ntf_pref := nvl(r_ntf_pref, 'QUERY');
2805:
2806: wf_notification.GetComments(nid, g_ntfDocText,
2807: n_text_history, n_last_ques);
2808: wf_notification.GetComments(nid, g_ntfDocHtml,
2809: n_html_history, n_last_ques);
2810: if n_text_history is not null or n_text_history <> '' then
2811: if isBiDi(r_language) then
2812: n_text_history := n_text_history||' '|| g_ntfHistory;

Line 2840: n_subject := WF_NOTIFICATION.GetSubject(nid, 'text/plain');

2836:
2837: -- Bug 2375920 get signature policy for the notification
2838: Wf_Mail.GetSignaturePolicy(nid, n_sig_policy);
2839:
2840: n_subject := WF_NOTIFICATION.GetSubject(nid, 'text/plain');
2841:
2842: -- We will always fetch plain text version of the message because
2843: -- Because for sendmail MAILATTH case, we need to send out html message
2844: -- body as attachment and then the plain text message as the body.

Line 2847: WF_NOTIFICATION.Set_NTF_Table_Direction('R');

2843: -- Because for sendmail MAILATTH case, we need to send out html message
2844: -- body as attachment and then the plain text message as the body.
2845: -- For MAPI MAILATTH and MAILHTML cases, same thing.
2846: if isBiDi(r_language) then
2847: WF_NOTIFICATION.Set_NTF_Table_Direction('R');
2848: else
2849: WF_NOTIFICATION.Set_NTF_Table_Direction('L');
2850: end if;
2851:

Line 2849: WF_NOTIFICATION.Set_NTF_Table_Direction('L');

2845: -- For MAPI MAILATTH and MAILHTML cases, same thing.
2846: if isBiDi(r_language) then
2847: WF_NOTIFICATION.Set_NTF_Table_Direction('R');
2848: else
2849: WF_NOTIFICATION.Set_NTF_Table_Direction('L');
2850: end if;
2851:
2852: n_text_body := WF_NOTIFICATION.GetBody(nid, g_ntfDocText);
2853:

Line 2852: n_text_body := WF_NOTIFICATION.GetBody(nid, g_ntfDocText);

2848: else
2849: WF_NOTIFICATION.Set_NTF_Table_Direction('L');
2850: end if;
2851:
2852: n_text_body := WF_NOTIFICATION.GetBody(nid, g_ntfDocText);
2853:
2854: GetHeaderTable(r_language||':'||to_char(nid), g_ntfDocText,
2855: t_headerText, dummy);
2856:

Line 2858: n_html_body := WF_NOTIFICATION.GetBody(nid, g_ntfDocHtml);

2854: GetHeaderTable(r_language||':'||to_char(nid), g_ntfDocText,
2855: t_headerText, dummy);
2856:
2857: if r_ntf_pref in ('MAILHTML', 'MAILATTH', 'MAILHTML2') then
2858: n_html_body := WF_NOTIFICATION.GetBody(nid, g_ntfDocHtml);
2859: GetHeaderTable(r_language||':'||to_char(nid),
2860: g_ntfDocHtml, t_headerHTML, dummy);
2861:
2862: -- Extracts content between and if there is body tag

Line 2992: err_name := Wf_Notification.GetAttrText(nid, 'MAIL_ERROR_NAME');

2988:
2989: -- Retrieve errror attributes for INVALID message
2990: if (t_name = 'OPEN_INVALID') then
2991: begin
2992: err_name := Wf_Notification.GetAttrText(nid, 'MAIL_ERROR_NAME');
2993: err_message := Wf_Notification.GetAttrText(nid, 'MAIL_ERROR_MESSAGE');
2994: err_invalid := Wf_Notification.GetAttrText(nid, 'MAIL_VALUE_FOUND');
2995: err_expected := Wf_Notification.GetAttrText(nid, 'MAIL_EXP_VALUES');
2996: exception

Line 2993: err_message := Wf_Notification.GetAttrText(nid, 'MAIL_ERROR_MESSAGE');

2989: -- Retrieve errror attributes for INVALID message
2990: if (t_name = 'OPEN_INVALID') then
2991: begin
2992: err_name := Wf_Notification.GetAttrText(nid, 'MAIL_ERROR_NAME');
2993: err_message := Wf_Notification.GetAttrText(nid, 'MAIL_ERROR_MESSAGE');
2994: err_invalid := Wf_Notification.GetAttrText(nid, 'MAIL_VALUE_FOUND');
2995: err_expected := Wf_Notification.GetAttrText(nid, 'MAIL_EXP_VALUES');
2996: exception
2997: when others then null;

Line 2994: err_invalid := Wf_Notification.GetAttrText(nid, 'MAIL_VALUE_FOUND');

2990: if (t_name = 'OPEN_INVALID') then
2991: begin
2992: err_name := Wf_Notification.GetAttrText(nid, 'MAIL_ERROR_NAME');
2993: err_message := Wf_Notification.GetAttrText(nid, 'MAIL_ERROR_MESSAGE');
2994: err_invalid := Wf_Notification.GetAttrText(nid, 'MAIL_VALUE_FOUND');
2995: err_expected := Wf_Notification.GetAttrText(nid, 'MAIL_EXP_VALUES');
2996: exception
2997: when others then null;
2998: end;

Line 2995: err_expected := Wf_Notification.GetAttrText(nid, 'MAIL_EXP_VALUES');

2991: begin
2992: err_name := Wf_Notification.GetAttrText(nid, 'MAIL_ERROR_NAME');
2993: err_message := Wf_Notification.GetAttrText(nid, 'MAIL_ERROR_MESSAGE');
2994: err_invalid := Wf_Notification.GetAttrText(nid, 'MAIL_VALUE_FOUND');
2995: err_expected := Wf_Notification.GetAttrText(nid, 'MAIL_EXP_VALUES');
2996: exception
2997: when others then null;
2998: end;
2999: end if;

Line 3545: -- n_due_date_text := to_char(n_due_date, Wf_Notification.g_nls_date_mask);

3541:
3542: begin
3543:
3544: -- BLAF requriement to display the date with TIME elelment
3545: -- n_due_date_text := to_char(n_due_date, Wf_Notification.g_nls_date_mask);
3546: -- n_start_date_text := to_char(n_start_date, Wf_Notification.g_nls_date_mask);
3547:
3548: --<< sstomar>: NLS changes, bug 7578922
3549: n_due_date_text := wf_notification_util.GetCalendarDate(n_nid, n_due_date, null, true);

Line 3546: -- n_start_date_text := to_char(n_start_date, Wf_Notification.g_nls_date_mask);

3542: begin
3543:
3544: -- BLAF requriement to display the date with TIME elelment
3545: -- n_due_date_text := to_char(n_due_date, Wf_Notification.g_nls_date_mask);
3546: -- n_start_date_text := to_char(n_start_date, Wf_Notification.g_nls_date_mask);
3547:
3548: --<< sstomar>: NLS changes, bug 7578922
3549: n_due_date_text := wf_notification_util.GetCalendarDate(n_nid, n_due_date, null, true);
3550: n_start_date_text := wf_notification_util.GetCalendarDate(n_nid, n_start_date, null, true);

Line 3549: n_due_date_text := wf_notification_util.GetCalendarDate(n_nid, n_due_date, null, true);

3545: -- n_due_date_text := to_char(n_due_date, Wf_Notification.g_nls_date_mask);
3546: -- n_start_date_text := to_char(n_start_date, Wf_Notification.g_nls_date_mask);
3547:
3548: --<< sstomar>: NLS changes, bug 7578922
3549: n_due_date_text := wf_notification_util.GetCalendarDate(n_nid, n_due_date, null, true);
3550: n_start_date_text := wf_notification_util.GetCalendarDate(n_nid, n_start_date, null, true);
3551: n_end_date_text := wf_notification_util.GetCalendarDate(n_nid, n_end_date, null, true);
3552:
3553: if (n_priority > 66) then

Line 3550: n_start_date_text := wf_notification_util.GetCalendarDate(n_nid, n_start_date, null, true);

3546: -- n_start_date_text := to_char(n_start_date, Wf_Notification.g_nls_date_mask);
3547:
3548: --<< sstomar>: NLS changes, bug 7578922
3549: n_due_date_text := wf_notification_util.GetCalendarDate(n_nid, n_due_date, null, true);
3550: n_start_date_text := wf_notification_util.GetCalendarDate(n_nid, n_start_date, null, true);
3551: n_end_date_text := wf_notification_util.GetCalendarDate(n_nid, n_end_date, null, true);
3552:
3553: if (n_priority > 66) then
3554: --Bug 2774891 fix - sacsharm

Line 3551: n_end_date_text := wf_notification_util.GetCalendarDate(n_nid, n_end_date, null, true);

3547:
3548: --<< sstomar>: NLS changes, bug 7578922
3549: n_due_date_text := wf_notification_util.GetCalendarDate(n_nid, n_due_date, null, true);
3550: n_start_date_text := wf_notification_util.GetCalendarDate(n_nid, n_start_date, null, true);
3551: n_end_date_text := wf_notification_util.GetCalendarDate(n_nid, n_end_date, null, true);
3552:
3553: if (n_priority > 66) then
3554: --Bug 2774891 fix - sacsharm
3555: --n_priority_text := wf_core.substitute('WFTKN', 'HIGH');

Line 4265: from WF_NOTIFICATION_ATTRIBUTES WNA,

4261: is
4262: -- SQL Statement for fetching URL RESPONSE attributes.
4263: cursor c1 is
4264: select WMA.NAME, WMA.DISPLAY_NAME, WNA.TEXT_VALUE, WMA.DESCRIPTION
4265: from WF_NOTIFICATION_ATTRIBUTES WNA,
4266: WF_NOTIFICATIONS WN,
4267: WF_MESSAGE_ATTRIBUTES_VL WMA
4268: where WNA.NOTIFICATION_ID = nid
4269: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID

Line 4266: WF_NOTIFICATIONS WN,

4262: -- SQL Statement for fetching URL RESPONSE attributes.
4263: cursor c1 is
4264: select WMA.NAME, WMA.DISPLAY_NAME, WNA.TEXT_VALUE, WMA.DESCRIPTION
4265: from WF_NOTIFICATION_ATTRIBUTES WNA,
4266: WF_NOTIFICATIONS WN,
4267: WF_MESSAGE_ATTRIBUTES_VL WMA
4268: where WNA.NOTIFICATION_ID = nid
4269: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID
4270: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE

Line 4314: wf_notification.geturltext(rec.text_value, nid)||

4310: if (rec.description is not null) then
4311: str_buffer := str_buffer||rec.description||'

';
4312: end if;
4313: str_buffer := str_buffer|| '';
4316: str_buffer := str_buffer||' '||rec.display_name;
4317: str_buffer := str_buffer||''||'';
4318: str_buffer := str_buffer||g_newLine;

Line 4350: from WF_NOTIFICATION_ATTRIBUTES WNA,

4346: to_char(WNA.DATE_VALUE, WMA.FORMAT)),
4347: 'LOOKUP', WNA.TEXT_VALUE,
4348: WNA.TEXT_VALUE), WMA.DESCRIPTION
4349: into disp_name, attr_type, attr_format, attr_value, attr_desc
4350: from WF_NOTIFICATION_ATTRIBUTES WNA,
4351: WF_NOTIFICATIONS WN,
4352: WF_MESSAGE_ATTRIBUTES_VL WMA
4353: where WNA.NOTIFICATION_ID = nid
4354: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID

Line 4351: WF_NOTIFICATIONS WN,

4347: 'LOOKUP', WNA.TEXT_VALUE,
4348: WNA.TEXT_VALUE), WMA.DESCRIPTION
4349: into disp_name, attr_type, attr_format, attr_value, attr_desc
4350: from WF_NOTIFICATION_ATTRIBUTES WNA,
4351: WF_NOTIFICATIONS WN,
4352: WF_MESSAGE_ATTRIBUTES_VL WMA
4353: where WNA.NOTIFICATION_ID = nid
4354: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID
4355: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE

Line 4516: Wf_Notification.GetSignatureRequired(p_sig_policy => n_sig_policy,

4512: begin
4513:
4514: validateAccess := FND_PROFILE.value('WF_VALIDATE_NTF_ACCESS');
4515:
4516: Wf_Notification.GetSignatureRequired(p_sig_policy => n_sig_policy,
4517: p_nid => nid,
4518: p_sig_required => sig_required,
4519: p_fwk_sig_flavor => fwk_flavor,
4520: p_email_sig_flavor => email_flavor,

Line 4646: FROM wf_notifications

4642: begin
4643:
4644: SELECT context, callback
4645: into context, callback
4646: FROM wf_notifications
4647: where notification_id = nid;
4648:
4649: wf_engine.preserved_context := FALSE;
4650: if (callback is not null) then

Line 4754: FROM wf_notifications n, wf_messages_vl wm

4750: l_get_text := false;
4751:
4752: SELECT wm.body, wm.html_body
4753: INTO l_text_body, l_html_body
4754: FROM wf_notifications n, wf_messages_vl wm
4755: WHERE n.notification_id = p_nid
4756: AND n.message_name = wm.name
4757: AND n.message_type = wm.type;
4758:

Line 4770: if (instrb(l_text_body, 'WF_NOTIFICATION(HISTORY)') = 0) then

4766:
4767: -- If HISTORY macro is defined, Action History would appear anyways. If the FYI notification
4768: -- was reassigned at least once, include the Action History if even macro is not defined
4769: if (l_comm_cnt > 0) then
4770: if (instrb(l_text_body, 'WF_NOTIFICATION(HISTORY)') = 0) then
4771: l_get_text := true;
4772: end if;
4773: if (instrb(l_html_body, 'WF_NOTIFICATION(HISTORY)') = 0) then
4774: l_get_html := true;

Line 4773: if (instrb(l_html_body, 'WF_NOTIFICATION(HISTORY)') = 0) then

4769: if (l_comm_cnt > 0) then
4770: if (instrb(l_text_body, 'WF_NOTIFICATION(HISTORY)') = 0) then
4771: l_get_text := true;
4772: end if;
4773: if (instrb(l_html_body, 'WF_NOTIFICATION(HISTORY)') = 0) then
4774: l_get_html := true;
4775: end if;
4776: end if;
4777: close c_comm;

Line 4783: if (instrb(l_text_body, 'WF_NOTIFICATION(HISTORY)') = 0) then

4779: -- Response Required notification
4780: else
4781: -- If HISTORY macro is defined, Action History would appear anyways. Otherwise
4782: -- display it in the e-mail
4783: if (instrb(l_text_body, 'WF_NOTIFICATION(HISTORY)') = 0) then
4784: l_get_text := true;
4785: end if;
4786: if (instrb(l_html_body, 'WF_NOTIFICATION(HISTORY)') = 0) then
4787: l_get_html := true;

Line 4786: if (instrb(l_html_body, 'WF_NOTIFICATION(HISTORY)') = 0) then

4782: -- display it in the e-mail
4783: if (instrb(l_text_body, 'WF_NOTIFICATION(HISTORY)') = 0) then
4784: l_get_text := true;
4785: end if;
4786: if (instrb(l_html_body, 'WF_NOTIFICATION(HISTORY)') = 0) then
4787: l_get_html := true;
4788: end if;
4789: end if;
4790:

Line 4793: Wf_Notification.GetComments2(p_nid => Get_Action_History.p_nid,

4789: end if;
4790:
4791: -- Call the GetComments2 procedure to get the Action History
4792: if (l_get_text) then
4793: Wf_Notification.GetComments2(p_nid => Get_Action_History.p_nid,
4794: p_display_type => wf_notification.doc_text,
4795: p_hide_reassign => 'N',
4796: p_hide_requestinfo => 'N',
4797: p_action_history => l_text_history);

Line 4794: p_display_type => wf_notification.doc_text,

4790:
4791: -- Call the GetComments2 procedure to get the Action History
4792: if (l_get_text) then
4793: Wf_Notification.GetComments2(p_nid => Get_Action_History.p_nid,
4794: p_display_type => wf_notification.doc_text,
4795: p_hide_reassign => 'N',
4796: p_hide_requestinfo => 'N',
4797: p_action_history => l_text_history);
4798: end if;

Line 4800: Wf_Notification.GetComments2(p_nid => Get_Action_History.p_nid,

4796: p_hide_requestinfo => 'N',
4797: p_action_history => l_text_history);
4798: end if;
4799: if (l_get_html)then
4800: Wf_Notification.GetComments2(p_nid => Get_Action_History.p_nid,
4801: p_display_type => wf_notification.doc_html,
4802: p_hide_reassign => 'N',
4803: p_hide_requestinfo => 'N',
4804: p_action_history => l_html_history);

Line 4801: p_display_type => wf_notification.doc_html,

4797: p_action_history => l_text_history);
4798: end if;
4799: if (l_get_html)then
4800: Wf_Notification.GetComments2(p_nid => Get_Action_History.p_nid,
4801: p_display_type => wf_notification.doc_html,
4802: p_hide_reassign => 'N',
4803: p_hide_requestinfo => 'N',
4804: p_action_history => l_html_history);
4805: end if;

Line 4980: from WF_NOTIFICATIONS

4976: into n_status, n_mstatus, n_key,
4977: n_priority, n_comment,
4978: n_start_date, n_end_date, n_due_date, n_from_user,
4979: n_more_info_role
4980: from WF_NOTIFICATIONS
4981: where NOTIFICATION_ID = nid;
4982: exception
4983: when no_data_found then
4984: wf_core.token('NID', to_char(nid));

Line 5005: if (wf_notification.HideMoreInfo(nid) = 'N') then

5001: end if;
5002:
5003: -- More information processing
5004: g_moreinfo := NULL;
5005: if (wf_notification.HideMoreInfo(nid) = 'N') then
5006: if(n_more_info_role is not null) then
5007: n_to_role := n_more_info_role;
5008: g_to_role := n_more_info_role;
5009: -- Flags that template for More Info submission needs to be used

Line 5029: WF_NOTIFICATION.Set_NTF_Table_Direction('R');

5025: ProcessSignaturePolicy(nid, n_sig_policy, n_status, n_mstatus,
5026: n_key, node, t_type, t_name, n_nid_str);
5027:
5028: if isBiDi(r_language) then
5029: WF_NOTIFICATION.Set_NTF_Table_Direction('R');
5030: else
5031: WF_NOTIFICATION.Set_NTF_Table_Direction('L');
5032: end if;
5033:

Line 5031: WF_NOTIFICATION.Set_NTF_Table_Direction('L');

5027:
5028: if isBiDi(r_language) then
5029: WF_NOTIFICATION.Set_NTF_Table_Direction('R');
5030: else
5031: WF_NOTIFICATION.Set_NTF_Table_Direction('L');
5032: end if;
5033:
5034: -- PLSQL Action History for the notification will not be explicitly processed by the
5035: -- mailer now. The notification sub-system would handle this as part of GetFullBody.

Line 5077: n_subject := WF_NOTIFICATION.GetSubject(nid, 'text/plain');

5073: n_text_timezone := wf_mail_util.getTimezone(g_ntfDocText);
5074: n_html_timezone := wf_mail_util.getTimezone(g_ntfDocHtml);
5075:
5076: step := 'Getting subject';
5077: n_subject := WF_NOTIFICATION.GetSubject(nid, 'text/plain');
5078:
5079: -- We will always fetch plain text version of the message because
5080: -- Because for sendmail MAILATTH case, we need to send out html message
5081: -- body as attachment and then the plain text message as the body.

Line 5102: WF_NOTIFICATION.GetFullBody(nid, buffer, end_of_message,

5098: end_of_message := FALSE;
5099: step := 'Getting text/plain body';
5100: begin
5101: while not (end_of_message) loop
5102: WF_NOTIFICATION.GetFullBody(nid, buffer, end_of_message,
5103: g_ntfDocText);
5104: if buffer is not null and length(buffer) > 0 then
5105: DBMS_LOB.WriteAppend(g_LOBTable(g_text_messageIdx).temp_lob,
5106: length(buffer), buffer);

Line 5137: WF_NOTIFICATION.GetFullBody(nid, buffer, end_of_message,

5133: end_of_message := FALSE;
5134: step := 'Getting text/html body';
5135: begin
5136: while not (end_of_message) loop
5137: WF_NOTIFICATION.GetFullBody(nid, buffer, end_of_message,
5138: g_ntfDocHtml);
5139: if buffer is not null and length(buffer) > 0 then
5140: DBMS_LOB.WriteAppend(g_LOBTable(g_html_messageIdx).temp_lob,
5141: length(buffer), buffer);

Line 5186: err_name := Wf_Notification.GetAttrText(nid, 'MAIL_ERROR_NAME');

5182: -- to make the WARNING message to the responder more
5183: -- user-friendly
5184: if (t_name in ('OPEN_INVALID', 'OPEN_INVALID_MORE_INFO')) then
5185: begin
5186: err_name := Wf_Notification.GetAttrText(nid, 'MAIL_ERROR_NAME');
5187: err_message := Wf_Notification.GetAttrText(nid, 'MAIL_ERROR_MESSAGE');
5188: err_invalid := Wf_Notification.GetAttrText(nid, 'MAIL_VALUE_FOUND');
5189: err_expected := Wf_Notification.GetAttrText(nid, 'MAIL_EXP_VALUES');
5190: exception

Line 5187: err_message := Wf_Notification.GetAttrText(nid, 'MAIL_ERROR_MESSAGE');

5183: -- user-friendly
5184: if (t_name in ('OPEN_INVALID', 'OPEN_INVALID_MORE_INFO')) then
5185: begin
5186: err_name := Wf_Notification.GetAttrText(nid, 'MAIL_ERROR_NAME');
5187: err_message := Wf_Notification.GetAttrText(nid, 'MAIL_ERROR_MESSAGE');
5188: err_invalid := Wf_Notification.GetAttrText(nid, 'MAIL_VALUE_FOUND');
5189: err_expected := Wf_Notification.GetAttrText(nid, 'MAIL_EXP_VALUES');
5190: exception
5191: when others then null;

Line 5188: err_invalid := Wf_Notification.GetAttrText(nid, 'MAIL_VALUE_FOUND');

5184: if (t_name in ('OPEN_INVALID', 'OPEN_INVALID_MORE_INFO')) then
5185: begin
5186: err_name := Wf_Notification.GetAttrText(nid, 'MAIL_ERROR_NAME');
5187: err_message := Wf_Notification.GetAttrText(nid, 'MAIL_ERROR_MESSAGE');
5188: err_invalid := Wf_Notification.GetAttrText(nid, 'MAIL_VALUE_FOUND');
5189: err_expected := Wf_Notification.GetAttrText(nid, 'MAIL_EXP_VALUES');
5190: exception
5191: when others then null;
5192: end;

Line 5189: err_expected := Wf_Notification.GetAttrText(nid, 'MAIL_EXP_VALUES');

5185: begin
5186: err_name := Wf_Notification.GetAttrText(nid, 'MAIL_ERROR_NAME');
5187: err_message := Wf_Notification.GetAttrText(nid, 'MAIL_ERROR_MESSAGE');
5188: err_invalid := Wf_Notification.GetAttrText(nid, 'MAIL_VALUE_FOUND');
5189: err_expected := Wf_Notification.GetAttrText(nid, 'MAIL_EXP_VALUES');
5190: exception
5191: when others then null;
5192: end;
5193: end if;

Line 5544: from WF_NOTIFICATIONS

5540: -- Get notification information
5541: begin
5542: select RECIPIENT_ROLE
5543: into n_to_role
5544: from WF_NOTIFICATIONS
5545: where NOTIFICATION_ID = nid;
5546: exception
5547: when no_data_found then
5548: wf_core.token('NID', to_char(nid));

Line 5674: from WF_NOTIFICATIONS

5670: -- Bug 1753464 included sort order for the query
5671: -- Bug 2439529 Altered query to use UNION instead of OR.
5672: cursor c1 is
5673: select NOTIFICATION_ID, RECIPIENT_ROLE, ACCESS_KEY, PRIORITY, DUE_DATE
5674: from WF_NOTIFICATIONS
5675: where STATUS = 'OPEN'
5676: and RECIPIENT_ROLE IN
5677: (select role from dual
5678: union

Line 5814: n_subject := WF_NOTIFICATION.GetSubject(nid, 'text/plain');

5810: n_key := rec.access_key;
5811: to_name := rec.recipient_role;
5812:
5813: -- Get and token subsitute subject
5814: n_subject := WF_NOTIFICATION.GetSubject(nid, 'text/plain');
5815:
5816: if contType = g_ntfDocText then
5817: n_buf := lpad(to_char(nid), 7, ' ')||' '||
5818: rpad(substr(dname, 1, 42), 42, ' ')||' ';

Line 6152: doccontent := Wf_Notification.GetAttrDoc(nid, docattrname, disptype);

6148: err_message varchar2(2000);
6149: err_stack varchar2(4000);
6150: begin
6151:
6152: doccontent := Wf_Notification.GetAttrDoc(nid, docattrname, disptype);
6153:
6154: exception
6155: when no_program_unit then
6156: wf_core.context('WF_MAIL', 'GetDocContent', docattrname);

Line 6246: doc := WF_NOTIFICATION.GetAttrDoc(nid, docattrname, disptype);

6242: begin
6243: -- There is a difference betwen PLSQL: and PLSQLCLOB: documents
6244: -- First go for the PLSQL: if that returns the name of the
6245: -- attribute, then try the PLSQLCLOB:
6246: doc := WF_NOTIFICATION.GetAttrDoc(nid, docattrname, disptype);
6247: if disptype = g_ntfDocHtml then
6248: -- DBMS_LOB.CreateTemporary(g_html_message, true, dbms_lob.SESSION);
6249: -- DBMS_LOB.Open(g_html_message, DBMS_LOB.LOB_READWRITE);
6250: g_html_messageIdx := wf_temp_lob.getLob(g_LOBTable);

Line 6252: Wf_Notification.GetAttrCLOB(nid, docattrname, disptype,

6248: -- DBMS_LOB.CreateTemporary(g_html_message, true, dbms_lob.SESSION);
6249: -- DBMS_LOB.Open(g_html_message, DBMS_LOB.LOB_READWRITE);
6250: g_html_messageIdx := wf_temp_lob.getLob(g_LOBTable);
6251: if doc = '&'||docattrname then
6252: Wf_Notification.GetAttrCLOB(nid, docattrname, disptype,
6253: g_LOBTable(g_html_messageIdx).temp_lob, doctype, aname);
6254: else
6255: DBMS_LOB.Write(g_LOBTable(g_html_messageIdx).temp_lob, length(doc), 1, doc);
6256: end if;

Line 6262: Wf_Notification.GetAttrCLOB(nid, docattrname, disptype,

6258: -- DBMS_LOB.CreateTemporary(g_text_message, true, dbms_lob.SESSION);
6259: -- DBMS_LOB.Open(g_text_message, DBMS_LOB.LOB_READWRITE);
6260: g_text_messageIdx := wf_temp_lob.getLob(g_LOBTable);
6261: if doc = '&'||docattrname then
6262: Wf_Notification.GetAttrCLOB(nid, docattrname, disptype,
6263: g_LOBTable(g_text_messageIdx).temp_lob, doctype, aname);
6264: else
6265: DBMS_LOB.Write(g_LOBTable(g_text_messageIdx).temp_lob, length(doc), 1, doc);
6266: end if;

Line 6440: from WF_NOTIFICATIONS

6436: -- Get notification message and status
6437: begin
6438: select MESSAGE_NAME, MESSAGE_TYPE, STATUS
6439: into msg_name, msg_type, stat
6440: from WF_NOTIFICATIONS
6441: where NOTIFICATION_ID = nid;
6442: exception
6443: when no_data_found then
6444: wf_core.token('NID', to_char(nid));

Line 6583: Wf_Notification.SetAttrText(nid, resp_attrs(j).attr_name, value);

6579: -- Process this notification only if it has a status of 'OPEN'
6580: -- otherwise do nothing. Fix for bug 2202392.
6581: if (stat = 'OPEN') then
6582: -- Save the new attribute value for nid.
6583: Wf_Notification.SetAttrText(nid, resp_attrs(j).attr_name, value);
6584: end if;
6585: response := TRUE;
6586: end if;
6587: end if;

Line 6596: Wf_Notification.Respond(nid, NULL, 'email:'||from_addr);

6592: wf_engine.preserved_context := FALSE;
6593:
6594: -- Complete the response.
6595: if response then
6596: Wf_Notification.Respond(nid, NULL, 'email:'||from_addr);
6597: else
6598: wf_core.context('WF_MAIL', 'PutMessage', to_char(nid), node, from_addr);
6599: wf_core.raise('WFRSPR_NORESPONSE');
6600: end if;

Line 6654: from WF_NOTIFICATION_ATTRIBUTES WNA,

6650: '', to_char(WNA.DATE_VALUE),
6651: to_char(WNA.DATE_VALUE, WMA.FORMAT)),
6652: 'LOOKUP', WNA.TEXT_VALUE,
6653: WNA.TEXT_VALUE) VALUE
6654: from WF_NOTIFICATION_ATTRIBUTES WNA,
6655: WF_NOTIFICATIONS WN,
6656: WF_MESSAGE_ATTRIBUTES_VL WMA
6657: where WNA.NOTIFICATION_ID = nid
6658: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID

Line 6655: WF_NOTIFICATIONS WN,

6651: to_char(WNA.DATE_VALUE, WMA.FORMAT)),
6652: 'LOOKUP', WNA.TEXT_VALUE,
6653: WNA.TEXT_VALUE) VALUE
6654: from WF_NOTIFICATION_ATTRIBUTES WNA,
6655: WF_NOTIFICATIONS WN,
6656: WF_MESSAGE_ATTRIBUTES_VL WMA
6657: where WNA.NOTIFICATION_ID = nid
6658: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID
6659: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE

Line 6684: from WF_NOTIFICATIONS

6680: -- Get notification message and status
6681: begin
6682: select MESSAGE_NAME, MESSAGE_TYPE, STATUS
6683: into msg_name, msg_type, stat
6684: from WF_NOTIFICATIONS
6685: where NOTIFICATION_ID = nid;
6686: exception
6687: when no_data_found then
6688: wf_core.token('NID', to_char(nid));

Line 6757: Wf_Notification.SetAttrText(nid, rec.name, new_value);

6753: -- otherwise do nothing. Fix for bug 2202392.
6754:
6755: if (stat = 'OPEN') then
6756: -- Save the new attribute value for nid.
6757: Wf_Notification.SetAttrText(nid, rec.name, new_value);
6758: end if;
6759: response := TRUE;
6760: end loop;
6761:

Line 6767: Wf_Notification.Respond(nid, NULL, 'email:'||from_addr);

6763: wf_engine.preserved_context := FALSE;
6764:
6765: -- Complete the response.
6766: if response then
6767: Wf_Notification.Respond(nid, NULL, 'email:'||from_addr);
6768: else
6769: wf_core.context('WF_MAIL', 'PutDirectMessage', to_char(nid),
6770: node, from_addr);
6771: wf_core.raise('WFRSPR_NORESPONSE');

Line 6853: -- update wf_notifications and wf_comments in QUESTION mode

6849: comment := 'NULL';
6850: end if;
6851: -- validate the role before calling updateinfo
6852:
6853: -- update wf_notifications and wf_comments in QUESTION mode
6854: if (length(to_user) > 0 and length(comment) > 0) then
6855: wf_notification.UpdateInfo2(nid, to_user, from_addr, comment);
6856: end if;
6857: exception

Line 6855: wf_notification.UpdateInfo2(nid, to_user, from_addr, comment);

6851: -- validate the role before calling updateinfo
6852:
6853: -- update wf_notifications and wf_comments in QUESTION mode
6854: if (length(to_user) > 0 and length(comment) > 0) then
6855: wf_notification.UpdateInfo2(nid, to_user, from_addr, comment);
6856: end if;
6857: exception
6858: when no_program_unit then
6859: wf_core.context('WF_MAIL','PutMoreInfoRequest', to_char(nid));

Line 6871: -- update wf_notification and wf_comments apropriately

6867:
6868: -- PutMoreInfoMessage
6869: -- Reply processor. Read body of a reply for more information
6870: -- request, parse the body for the comments from the user and
6871: -- update wf_notification and wf_comments apropriately
6872: -- Used by the notification mail response processor.
6873: -- IN
6874: -- notification id
6875: -- mailer node name

Line 6937: -- update wf_notifications and wf_comments in ANSWER mode

6933: end if;
6934: end if;
6935: end if;
6936: end if;
6937: -- update wf_notifications and wf_comments in ANSWER mode
6938: to_user := NULL;
6939: wf_notification.UpdateInfo2(nid, to_user, from_addr, comment);
6940: exception
6941: when no_program_unit then

Line 6939: wf_notification.UpdateInfo2(nid, to_user, from_addr, comment);

6935: end if;
6936: end if;
6937: -- update wf_notifications and wf_comments in ANSWER mode
6938: to_user := NULL;
6939: wf_notification.UpdateInfo2(nid, to_user, from_addr, comment);
6940: exception
6941: when no_program_unit then
6942: wf_core.context('WF_MAIL','PutMoreInfoMessage', to_char(nid));
6943: raise;

Line 6973: decode(WMA.TYPE, 'URL', WF_NOTIFICATION.GetUrlText(WNA.TEXT_VALUE,

6969: err_stack varchar2(4000);
6970:
6971: cursor ntf is
6972: select WMA.TYPE, WMA.DISPLAY_NAME,
6973: decode(WMA.TYPE, 'URL', WF_NOTIFICATION.GetUrlText(WNA.TEXT_VALUE,
6974: GetURLAttachment.nid), WNA.TEXT_VALUE) URL,
6975: WNA.NAME
6976: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,
6977: WF_MESSAGE_ATTRIBUTES_VL WMA

Line 6976: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,

6972: select WMA.TYPE, WMA.DISPLAY_NAME,
6973: decode(WMA.TYPE, 'URL', WF_NOTIFICATION.GetUrlText(WNA.TEXT_VALUE,
6974: GetURLAttachment.nid), WNA.TEXT_VALUE) URL,
6975: WNA.NAME
6976: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,
6977: WF_MESSAGE_ATTRIBUTES_VL WMA
6978: where WNA.NOTIFICATION_ID = GetURLAttachment.nid
6979: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID
6980: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE

Line 7013: l_url := wf_notification.SetFrameworkAgent(urlattr.url);

7009: -- Build the list of URLs
7010: l_urlcount := 0;
7011: l_urllist := '
';
7012: for urlattr in ntf loop
7013: l_url := wf_notification.SetFrameworkAgent(urlattr.url);
7014: l_urllist := l_urllist || '' ||
7015: urlattr.display_name || '
'||g_newLine;
7016: l_urlcount := l_urlcount + 1;
7017: end loop;

Line 7230: sig_policy := Wf_Notification.GetAttrText(nid, '#WF_SIG_POLICY');

7226: is
7227: begin
7228: -- Get value for signature policy for the notification from
7229: -- notification attribute
7230: sig_policy := Wf_Notification.GetAttrText(nid, '#WF_SIG_POLICY');
7231:
7232: exception
7233: when others then
7234: if (wf_core.error_name = 'WFNTF_ATTR') then

Line 7257: p_sec_policy := Wf_Notification.GetAttrText(p_nid, '#WF_SECURITY_POLICY');

7253: p_sec_policy out NOCOPY varchar2)
7254: is
7255: begin
7256: -- Get security policy for the notification
7257: p_sec_policy := Wf_Notification.GetAttrText(p_nid, '#WF_SECURITY_POLICY');
7258: if (p_sec_policy is null) then
7259: p_sec_policy := 'DEFAULT';
7260: end if;
7261: exception

Line 7384: l_lang := upper(Wf_Notification.GetAttrText(p_nid, '#WFM_LANGUAGE'));

7380: end if;
7381:
7382: -- Get notification's language preference
7383: begin
7384: l_lang := upper(Wf_Notification.GetAttrText(p_nid, '#WFM_LANGUAGE'));
7385: exception
7386: when others then
7387: if (wf_core.error_name = 'WFNTF_ATTR') then
7388: wf_core.clear();

Line 7437: l_terr := upper(Wf_Notification.GetAttrText(p_nid, '#WFM_TERRITORY'));

7433: end if;
7434:
7435: -- Get notification's territory preference
7436: begin
7437: l_terr := upper(Wf_Notification.GetAttrText(p_nid, '#WFM_TERRITORY'));
7438: exception
7439: when others then
7440: if (wf_core.error_name = 'WFNTF_ATTR') then
7441: wf_core.clear();

Line 7490: WF_NOTIFICATION_UTIL.getNLSContext(

7486: -- <> :
7487: -- WF_MAIL.GetSessionLanguage(l_base_lang, l_base_terr, l_base_codeset);
7488: -- Note: we should AVOID to call below API here
7489: -- use global variables instead .
7490: WF_NOTIFICATION_UTIL.getNLSContext(
7491: l_base_lang ,
7492: l_base_terr ,
7493: l_base_codeset ,
7494: l_base_nlsDateFormat ,

Line 7528: -- This API unlike wf_notification.send does not require workflow

7524: --
7525:
7526: -- Send
7527: -- Sends a e-mail notification to the specified list of recipients.
7528: -- This API unlike wf_notification.send does not require workflow
7529: -- message or workflow roles to send a notification.
7530:
7531: procedure send(p_subject in varchar2,
7532: p_message in out nocopy clob,

Line 7857: l_agent := wf_agent_t('WF_NOTIFICATION_OUT', wf_event.local_system_name);

7853: end if;
7854:
7855: l_event.SetEventData(l_msg_doc);
7856:
7857: l_agent := wf_agent_t('WF_NOTIFICATION_OUT', wf_event.local_system_name);
7858: l_event.SetFromAgent(l_agent);
7859:
7860: -- Generally it would be 'ALR'
7861: if(instr( send.p_module, ':') = 0) then

Line 8038: -- wf_notification_util.setNLSContext / getNLSContext then we need to modify.

8034: -- << sstomar>: The content of this warning ntf emil
8035: -- are generated by Mailer, so other NLS parameters ( NLS_DATE_FORMAT etc.
8036: -- because we don;t have any such attributes in message body)
8037: -- are not required to SET/ RESET but if we want to use centralized API
8038: -- wf_notification_util.setNLSContext / getNLSContext then we need to modify.
8039: --
8040:
8041: -- getting the language for the session
8042: wf_notification.getnlslanguage(l_orig_lang, l_orig_terr, l_orig_chrs);

Line 8042: wf_notification.getnlslanguage(l_orig_lang, l_orig_terr, l_orig_chrs);

8038: -- wf_notification_util.setNLSContext / getNLSContext then we need to modify.
8039: --
8040:
8041: -- getting the language for the session
8042: wf_notification.getnlslanguage(l_orig_lang, l_orig_terr, l_orig_chrs);
8043:
8044: --
8045: If l_installed = 'Y' then
8046: -- Set user's language

Line 8047: wf_notification.setnlslanguage(l_language, l_territory);

8043:
8044: --
8045: If l_installed = 'Y' then
8046: -- Set user's language
8047: wf_notification.setnlslanguage(l_language, l_territory);
8048:
8049: end if;
8050:
8051: -- Get message details

Line 8054: FROM wf_notifications

8050:
8051: -- Get message details
8052: SELECT message_type,message_name
8053: INTO l_msg_type,l_msg_name
8054: FROM wf_notifications
8055: WHERE notification_id = p_nid;
8056:
8057: -- Get template 'WARNING'
8058: SELECT subject, BODY, HTML_BODY

Line 8103: WF_Notification.SetNLSLanguage(l_orig_lang, l_orig_terr);

8099:
8100: l_html_body := SUBSTR(REPLACE(l_html_body,'&QUESTION',l_question),1,32000);
8101:
8102: -- reset the session language
8103: WF_Notification.SetNLSLanguage(l_orig_lang, l_orig_terr);
8104:
8105: -- LOB to store message payload.
8106: dbms_lob.createtemporary(l_msg_doc, TRUE,dbms_lob.CALL);
8107:

Line 8119: -- WF_NOTIFICATION.MAIL_STAUTS should not affect to deliver

8115: l_attrlist.DELETE;
8116:
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);

Line 8297: -- waon't rely on wf_notification TABLE.

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;
8299: l_event.seteventdata(l_msg_doc);
8300:
8301: l_agent := wf_agent_t('WF_NOTIFICATION_OUT',wf_event.local_system_name);

Line 8301: l_agent := wf_agent_t('WF_NOTIFICATION_OUT',wf_event.local_system_name);

8297: -- waon't rely on wf_notification TABLE.
8298: l_event.event_key := 0;
8299: l_event.seteventdata(l_msg_doc);
8300:
8301: l_agent := wf_agent_t('WF_NOTIFICATION_OUT',wf_event.local_system_name);
8302: l_event.setfromagent(l_agent);
8303:
8304: l_event.addparametertolist('Q_CORRELATION_ID',l_msg_type || ':' ||l_msg_name);
8305: l_event.addparametertolist('NOTIFICATION_ID','0');

Line 8321: WF_Notification.SetNLSLanguage(l_orig_lang,l_orig_terr);

8317: exception
8318: when others then
8319: --Release allocated temp LOBs back to pool
8320: if (l_orig_lang is not null and l_orig_terr is not null) then
8321: WF_Notification.SetNLSLanguage(l_orig_lang,l_orig_terr);
8322: end IF;
8323:
8324: if(l_messageidx > 0) then
8325: wf_temp_lob.releaselob(g_lobtable, l_messageidx);

Line 8333: -- oracle.apps.wf.notification.send.group. This subscription is responsible

8329: end SendMoreInfoResponseWarning;
8330:
8331: -- SetNtfEventsSubStatus
8332: -- This procedure sets the status of seeded subscription to the event group
8333: -- oracle.apps.wf.notification.send.group. This subscription is responsible
8334: -- for notification XML message generation and presenting it to the mailer for
8335: -- e-mail dispatch. Disabling this subscription causes e-mails not to be sent.
8336: --
8337: -- ENABLED - E-mails are sent

Line 8356: WHERE name = 'oracle.apps.wf.notification.send.group'

8352: AND owner_tag = 'FND'
8353: AND event_filter_guid
8354: IN (SELECT guid
8355: FROM wf_events
8356: WHERE name = 'oracle.apps.wf.notification.send.group'
8357: AND type = 'GROUP')
8358: AND out_agent_guid
8359: IN (SELECT guid
8360: FROM wf_agents

Line 8361: WHERE name = 'WF_NOTIFICATION_OUT'

8357: AND type = 'GROUP')
8358: AND out_agent_guid
8359: IN (SELECT guid
8360: FROM wf_agents
8361: WHERE name = 'WF_NOTIFICATION_OUT'
8362: AND system_guid = hextoraw(wf_core.translate('WF_SYSTEM_GUID')))
8363: AND customization_level = 'L';
8364:
8365: -- Inform BES cache manager that BES meta-data state has changed