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_EVENT

Line 205: wf_event.AddParameterToList('NOTIFICATION_ID',nid,parameterlist);

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);
207: wf_event.AddParameterToList('STATUS',status,parameterlist);
208: wf_event.AddParameterToList('ERROR_NAME',error_name,
209: parameterlist);

Line 206: wf_event.AddParameterToList('ROLE',l_role,parameterlist);

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);
207: wf_event.AddParameterToList('STATUS',status,parameterlist);
208: wf_event.AddParameterToList('ERROR_NAME',error_name,
209: parameterlist);
210: wf_event.AddParameterToList('EXTERNAL_ERROR',external_error,

Line 207: wf_event.AddParameterToList('STATUS',status,parameterlist);

203: parameterlist := wf_parameter_list_t();
204:
205: wf_event.AddParameterToList('NOTIFICATION_ID',nid,parameterlist);
206: wf_event.AddParameterToList('ROLE',l_role,parameterlist);
207: wf_event.AddParameterToList('STATUS',status,parameterlist);
208: wf_event.AddParameterToList('ERROR_NAME',error_name,
209: parameterlist);
210: wf_event.AddParameterToList('EXTERNAL_ERROR',external_error,
211: parameterlist);

Line 208: wf_event.AddParameterToList('ERROR_NAME',error_name,

204:
205: wf_event.AddParameterToList('NOTIFICATION_ID',nid,parameterlist);
206: wf_event.AddParameterToList('ROLE',l_role,parameterlist);
207: wf_event.AddParameterToList('STATUS',status,parameterlist);
208: wf_event.AddParameterToList('ERROR_NAME',error_name,
209: parameterlist);
210: wf_event.AddParameterToList('EXTERNAL_ERROR',external_error,
211: parameterlist);
212: wf_event.addParameterToList('Q_CORRELATION_ID', l_mType || ':' || l_mName, parameterlist);

Line 210: wf_event.AddParameterToList('EXTERNAL_ERROR',external_error,

206: wf_event.AddParameterToList('ROLE',l_role,parameterlist);
207: wf_event.AddParameterToList('STATUS',status,parameterlist);
208: wf_event.AddParameterToList('ERROR_NAME',error_name,
209: parameterlist);
210: wf_event.AddParameterToList('EXTERNAL_ERROR',external_error,
211: parameterlist);
212: wf_event.addParameterToList('Q_CORRELATION_ID', l_mType || ':' || l_mName, parameterlist);
213:
214: --Raise the event

Line 212: wf_event.addParameterToList('Q_CORRELATION_ID', l_mType || ':' || l_mName, parameterlist);

208: wf_event.AddParameterToList('ERROR_NAME',error_name,
209: parameterlist);
210: wf_event.AddParameterToList('EXTERNAL_ERROR',external_error,
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,

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 227: wf_event.AddParameterToList('NOTIFICATION_ID', UpdateStatus2.nid, parameterlist);

223: -- that indicates that a recipient is not available to respond
224: -- to the notification.
225: parameterlist := wf_parameter_list_t();
226:
227: wf_event.AddParameterToList('NOTIFICATION_ID', UpdateStatus2.nid, parameterlist);
228: wf_event.AddParameterToList('STATUS', UpdateStatus2.status, parameterlist);
229:
230: -- Just for Future point of view. (...receive.unavail event).
231: wf_event.addParameterToList('Q_CORRELATION_ID', l_mType || ':' || l_mName, parameterlist);

Line 228: wf_event.AddParameterToList('STATUS', UpdateStatus2.status, parameterlist);

224: -- to the notification.
225: parameterlist := wf_parameter_list_t();
226:
227: wf_event.AddParameterToList('NOTIFICATION_ID', UpdateStatus2.nid, parameterlist);
228: wf_event.AddParameterToList('STATUS', UpdateStatus2.status, parameterlist);
229:
230: -- Just for Future point of view. (...receive.unavail event).
231: wf_event.addParameterToList('Q_CORRELATION_ID', l_mType || ':' || l_mName, parameterlist);
232:

Line 231: wf_event.addParameterToList('Q_CORRELATION_ID', l_mType || ':' || l_mName, parameterlist);

227: wf_event.AddParameterToList('NOTIFICATION_ID', UpdateStatus2.nid, parameterlist);
228: wf_event.AddParameterToList('STATUS', UpdateStatus2.status, parameterlist);
229:
230: -- Just for Future point of view. (...receive.unavail event).
231: wf_event.addParameterToList('Q_CORRELATION_ID', l_mType || ':' || l_mName, parameterlist);
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 ....

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 407: p_event in out NOCOPY WF_EVENT_T) return varchar2

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
409:
410: role varchar2(320);
411: recipient varchar2(320);

Line 460: errorName := wf_event.getValueForParameter('ERROR_NAME', params);

456: 'BEGIN');
457: end if;
458: role := p_event.getEventKey();
459: params := p_event.getParameterList();
460: errorName := wf_event.getValueForParameter('ERROR_NAME', params);
461: externError := wf_event.getValueForParameter('EXTERNAL_ERROR', params);
462: nid := to_number(wf_event.getValueForParameter('NOTIFICATION_ID', params));
463:
464: if errorName = 'WFMLRSND_FAILED_UNDELIVERABLE' or

Line 461: externError := wf_event.getValueForParameter('EXTERNAL_ERROR', params);

457: end if;
458: role := p_event.getEventKey();
459: params := p_event.getParameterList();
460: errorName := wf_event.getValueForParameter('ERROR_NAME', params);
461: externError := wf_event.getValueForParameter('EXTERNAL_ERROR', params);
462: nid := to_number(wf_event.getValueForParameter('NOTIFICATION_ID', params));
463:
464: if errorName = 'WFMLRSND_FAILED_UNDELIVERABLE' or
465: errorName = 'WFMLRSND_FAILED_DELIVERY' then

Line 462: nid := to_number(wf_event.getValueForParameter('NOTIFICATION_ID', params));

458: role := p_event.getEventKey();
459: params := p_event.getParameterList();
460: errorName := wf_event.getValueForParameter('ERROR_NAME', params);
461: externError := wf_event.getValueForParameter('EXTERNAL_ERROR', params);
462: nid := to_number(wf_event.getValueForParameter('NOTIFICATION_ID', params));
463:
464: if errorName = 'WFMLRSND_FAILED_UNDELIVERABLE' or
465: errorName = 'WFMLRSND_FAILED_DELIVERY' then
466:

Line 597: wf_event.AddParameterToList('USER_NAME', tokens(tk),

593: else
594:
595: paramList.DELETE;
596:
597: wf_event.AddParameterToList('USER_NAME', tokens(tk),
598: paramList);
599: wf_event.AddParameterToList('ORCLWORKFLOWNOTIFICATIONPREF',
600: 'DISABLED', paramList);
601:

Line 599: wf_event.AddParameterToList('ORCLWORKFLOWNOTIFICATIONPREF',

595: paramList.DELETE;
596:
597: wf_event.AddParameterToList('USER_NAME', tokens(tk),
598: paramList);
599: wf_event.AddParameterToList('ORCLWORKFLOWNOTIFICATIONPREF',
600: 'DISABLED', paramList);
601:
602: wf_event.AddParameterToList('RAISEERRORS',
603: 'TRUE', paramList);

Line 602: wf_event.AddParameterToList('RAISEERRORS',

598: paramList);
599: wf_event.AddParameterToList('ORCLWORKFLOWNOTIFICATIONPREF',
600: 'DISABLED', paramList);
601:
602: wf_event.AddParameterToList('RAISEERRORS',
603: 'TRUE', paramList);
604: begin
605: wf_local_synch.propagate_user(p_orig_system => orig_system,
606: p_orig_system_id => orig_system_id,

Line 666: -- Bug 6431003: Modifying the value of wf_event.phase_maxthreshold

662: -- Hardcoding the recipient as SYSADMIN. The WFERROR process
663: -- notifications all have the same, hardcoded value for their
664: -- recipients.
665:
666: -- Bug 6431003: Modifying the value of wf_event.phase_maxthreshold
667: -- so that the event gets deferred.
668:
669: -- Taking the backup of current wf_event.phase_maxthreshold value
670:

Line 669: -- Taking the backup of current wf_event.phase_maxthreshold value

665:
666: -- Bug 6431003: Modifying the value of wf_event.phase_maxthreshold
667: -- so that the event gets deferred.
668:
669: -- Taking the backup of current wf_event.phase_maxthreshold value
670:
671: current_maxthreshold := wf_event.phase_maxthreshold;
672: wf_event.SetDispatchMode ('ASYNC');
673:

Line 671: current_maxthreshold := wf_event.phase_maxthreshold;

667: -- so that the event gets deferred.
668:
669: -- Taking the backup of current wf_event.phase_maxthreshold value
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',

Line 672: wf_event.SetDispatchMode ('ASYNC');

668:
669: -- Taking the backup of current wf_event.phase_maxthreshold value
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');

Line 693: -- Resetting the wf_event.phase_maxthreshold value

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:
696: end if;
697:

Line 694: wf_event.phase_maxthreshold := current_maxthreshold;

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:
696: end if;
697:
698: end if;

Line 962: wf_event.AddParameterToList('NOTIFICATION_ID', nid, parameterlist);

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);
964: wf_event.AddParameterToList('GROUP_ID', nvl(group_id, nid), parameterlist);
965: wf_event.addParameterToList('Q_CORRELATION_ID', mType || ':' || mName, parameterlist);
966:

Line 963: wf_event.AddParameterToList('ROLE', role, parameterlist);

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);
964: wf_event.AddParameterToList('GROUP_ID', nvl(group_id, nid), parameterlist);
965: wf_event.addParameterToList('Q_CORRELATION_ID', mType || ':' || mName, parameterlist);
966:
967: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

Line 964: wf_event.AddParameterToList('GROUP_ID', nvl(group_id, nid), parameterlist);

960: where notification_id = nid;
961:
962: wf_event.AddParameterToList('NOTIFICATION_ID', nid, parameterlist);
963: wf_event.AddParameterToList('ROLE', role, parameterlist);
964: wf_event.AddParameterToList('GROUP_ID', nvl(group_id, nid), parameterlist);
965: wf_event.addParameterToList('Q_CORRELATION_ID', mType || ':' || mName, parameterlist);
966:
967: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
968: wf_log_pkg.string(WF_LOG_PKG.level_statement,

Line 965: wf_event.addParameterToList('Q_CORRELATION_ID', mType || ':' || mName, parameterlist);

961:
962: wf_event.AddParameterToList('NOTIFICATION_ID', nid, parameterlist);
963: wf_event.AddParameterToList('ROLE', role, parameterlist);
964: wf_event.AddParameterToList('GROUP_ID', nvl(group_id, nid), parameterlist);
965: wf_event.addParameterToList('Q_CORRELATION_ID', mType || ':' || mName, parameterlist);
966:
967: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
968: wf_log_pkg.string(WF_LOG_PKG.level_statement,
969: 'wf.plsql.WF_MAIL.HandleResponseError',

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 7553: l_event wf_event_t;

7549: l_pos integer;
7550: l_amt number;
7551:
7552: l_msg_doc clob;
7553: l_event wf_event_t;
7554: l_agent wf_agent_t;
7555: l_parameter_list wf_parameter_list_t;
7556: l_event_name varchar2(240);
7557: l_event_key varchar2(240);

Line 7840: wf_event_t.Initialize(l_event);

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;
7843:
7844: -- Create an event key based firstly on the parameter. If that does not

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 7869: wf_event.send(l_event);

7865: END if;
7866:
7867: l_event.addParameterToList('NOTIFICATION_ID', '0');
7868:
7869: wf_event.send(l_event);
7870:
7871: -- Release allocated temp LOBs back to pool
7872: wf_temp_lob.releaseLob(g_LOBTable, l_messageIdx);
7873:

Line 7945: l_event wf_event_t;

7941: l_messageidx pls_integer;
7942: l_pos INTEGER;
7943: l_occurance INTEGER := 1;
7944:
7945: l_event wf_event_t;
7946: l_agent wf_agent_t;
7947:
7948: l_start pls_integer;
7949: l_end pls_integer;

Line 8293: wf_event_t.initialize(l_event);

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;
8295:
8296: -- Create an event key : make it as 0 so that this warning message
8297: -- waon't rely on wf_notification TABLE.

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 8307: wf_event.send(l_event);

8303:
8304: l_event.addparametertolist('Q_CORRELATION_ID',l_msg_type || ':' ||l_msg_name);
8305: l_event.addparametertolist('NOTIFICATION_ID','0');
8306:
8307: wf_event.send(l_event);
8308:
8309: -- Release allocated temp LOBs back to pool
8310: wf_temp_lob.releaselob(g_lobtable, l_messageidx);
8311:

Line 8348: UPDATE wf_event_subscriptions

8344:
8345: if (p_status in ('ENABLED', 'DISABLED')) then
8346: -- Update the notification send event group subscription
8347: -- with the specified status
8348: UPDATE wf_event_subscriptions
8349: SET status = p_status
8350: WHERE rule_data = 'MESSAGE'
8351: AND owner_name = 'Oracle Workflow'
8352: AND owner_tag = 'FND'

Line 8355: FROM wf_events

8351: AND owner_name = 'Oracle Workflow'
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