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_STANDARD dependencies on WF_NOTIFICATION

Line 2083: if (wf_notification.OpenNotificationsExist(l_group_id)) then

2079: -- (in timeout mode).
2080: if ((l_voting_option = 'REQUIRE_ALL_VOTES') or
2081: ((funcmode = wf_engine.eng_run) and
2082: (l_voting_option = 'WAIT_FOR_ALL_VOTES'))) then
2083: if (wf_notification.OpenNotificationsExist(l_group_id)) then
2084: resultout := wf_engine.eng_waiting;
2085: return;
2086: end if;
2087: end if;

Line 2097: Wf_Notification.VoteCount(l_group_id,result_rec.result_code,

2093: -- d. REQUIRE_ALL_VOTES and all votes are cast
2094: -- Tally votes.
2095: for result_rec in result_codes loop
2096: -- Tally Vote Count for this result code
2097: Wf_Notification.VoteCount(l_group_id,result_rec.result_code,
2098: l_code_count,l_per_of_total,l_per_of_vote);
2099:
2100: -- If this is timeout mode, then use the percent of votes cast so far.
2101: -- If this is run mode, then use the percent of total votes possible.

Line 2149: wf_notification.OpenNotificationsExist(l_group_id)) then

2145: resultout := wf_engine.eng_completed||':'||result;
2146: else
2147: -- If we get here no non-default results were satisfied.
2148: if (funcmode = wf_engine.eng_run and
2149: wf_notification.OpenNotificationsExist(l_group_id)) then
2150: -- Not timed out and still open notifications.
2151: -- Return waiting to continue voting.
2152: resultout := wf_engine.eng_waiting;
2153: elsif (default_result is not null) then

Line 3036: l_cells wf_notification.tdType;

3032: i pls_integer;
3033:
3034: l_event_t wf_event_t;
3035: l_parmlist_t wf_parameter_list_t;
3036: l_cells wf_notification.tdType;
3037: j number;
3038: l_result varchar2(32000);
3039:
3040: begin

Line 3076: l_send_date_text := WF_NOTIFICATION_UTIL.GetCalendarDate(-1, l_send_date, null, true);

3072: --
3073: l_send_date := l_event_t.GetSendDate();
3074:
3075: IF l_send_date IS NOT NULL THEN
3076: l_send_date_text := WF_NOTIFICATION_UTIL.GetCalendarDate(-1, l_send_date, null, true);
3077: END IF;
3078:
3079: l_receive_date := l_event_t.GetReceiveDate();
3080:

Line 3082: l_receive_date_text := WF_NOTIFICATION_UTIL.GetCalendarDate(-1, l_receive_date, null, true);

3078:
3079: l_receive_date := l_event_t.GetReceiveDate();
3080:
3081: IF l_receive_date IS NOT NULL THEN
3082: l_receive_date_text := WF_NOTIFICATION_UTIL.GetCalendarDate(-1, l_receive_date, null, true);
3083: END IF;
3084:
3085: --
3086: -- Get the Priority

Line 3094: -- Using WF_NOTIFICATION.NTF_Table API to maintain consistency with BLAF

3090: --
3091: -- Build up the PL/SQL Document depending on the User Mail Preference
3092: --
3093: -- bug 6955474
3094: -- Using WF_NOTIFICATION.NTF_Table API to maintain consistency with BLAF
3095: --
3096: -- Build the Table
3097: if (display_type = wf_notification.doc_html) then
3098: i := 1;

Line 3097: if (display_type = wf_notification.doc_html) then

3093: -- bug 6955474
3094: -- Using WF_NOTIFICATION.NTF_Table API to maintain consistency with BLAF
3095: --
3096: -- Build the Table
3097: if (display_type = wf_notification.doc_html) then
3098: i := 1;
3099: l_cells(i) := wf_core.translate('WF_EVENT_HEADING');
3100: l_cells(i) := 'S30%:'||l_cells(i);
3101:

Line 3186: if (display_type = wf_notification.doc_html) then

3182: l_parmlist_t := l_event_t.getParameterList();
3183: if (l_parmlist_t is not null) then
3184: j := l_parmlist_t.FIRST;
3185: while (j <= l_parmlist_t.LAST) loop
3186: if (display_type = wf_notification.doc_html) then
3187: i := i + 1;
3188: l_cells(i) := 'S:'||wf_core.translate('WF_PARAMETER')||' : '||l_parmlist_t(j).getName();
3189:
3190: i := i + 1;

Line 3202: if (display_type = wf_notification.doc_html) then

3198: j := l_parmlist_t.NEXT(j);
3199: end loop;
3200: end if;
3201:
3202: if (display_type = wf_notification.doc_html) then
3203: document_type := wf_notification.doc_html;
3204: wf_notification.NTF_Table(cells => l_cells,
3205: col => 2,
3206: type => 'H',

Line 3203: document_type := wf_notification.doc_html;

3199: end loop;
3200: end if;
3201:
3202: if (display_type = wf_notification.doc_html) then
3203: document_type := wf_notification.doc_html;
3204: wf_notification.NTF_Table(cells => l_cells,
3205: col => 2,
3206: type => 'H',
3207: rs => l_result);

Line 3204: wf_notification.NTF_Table(cells => l_cells,

3200: end if;
3201:
3202: if (display_type = wf_notification.doc_html) then
3203: document_type := wf_notification.doc_html;
3204: wf_notification.NTF_Table(cells => l_cells,
3205: col => 2,
3206: type => 'H',
3207: rs => l_result);
3208: -- Display title

Line 3214: document_type := wf_notification.doc_text;

3210: ''||wf_core.Translate('WFITD_EVENT_DETAILS')||
3211: ''||''||l_result||'';
3212:
3213: else
3214: document_type := wf_notification.doc_text;
3215: end if;
3216: document := l_result;
3217:
3218: exception

Line 3472: l_cells wf_notification.tdType;

3468: l_item_key varchar2(240);
3469: l_subscription raw(16);
3470: l_params varchar2(4000);
3471: l_rule_func varchar2(240);
3472: l_cells wf_notification.tdType;
3473: l_cells2 wf_notification.tdType;
3474: i pls_integer;
3475: j pls_integer;
3476: l_document varchar2(32000);

Line 3473: l_cells2 wf_notification.tdType;

3469: l_subscription raw(16);
3470: l_params varchar2(4000);
3471: l_rule_func varchar2(240);
3472: l_cells wf_notification.tdType;
3473: l_cells2 wf_notification.tdType;
3474: i pls_integer;
3475: j pls_integer;
3476: l_document varchar2(32000);
3477: l_sub_param_list wf_parameter_list_t;

Line 3503: if (display_type = wf_notification.doc_html) then

3499: WHERE guid = l_subscription;
3500:
3501: l_sub_param_list := wf_event.GetParamListFromString(l_params);
3502:
3503: if (display_type = wf_notification.doc_html) then
3504: i := 1;
3505: l_cells(i) := 'S30%:'||wf_core.Translate('WF_PARAMETER');
3506:
3507: i := i + 1;

Line 3519: if (display_type = wf_notification.doc_html) then

3515: -- meta-data store for WS definition
3516: if (l_sub_param_list is not null) then
3517: j := l_sub_param_list.FIRST;
3518: while (j is not null) loop
3519: if (display_type = wf_notification.doc_html) then
3520: i := i + 1;
3521: l_cells(i) := 'S:'||l_sub_param_list(j).getName();
3522:
3523: i := i + 1;

Line 3542: if (display_type = wf_notification.doc_html) then

3538: l_sub_url := wf_engine.GetItemAttrText(itemtype => l_item_type,
3539: itemkey => l_item_key,
3540: aname => 'EVENT_SUBSCRIPTION');
3541:
3542: if (display_type = wf_notification.doc_html) then
3543: i := i + 1;
3544: l_cells(i) := 'S:'||wf_core.Translate('WF_INOKER_RULE_FUNC');
3545: i := i + 1;
3546: l_cells(i) := 'S:'||l_rule_func;

Line 3560: wf_notification.Ntf_Table(l_cells, 2, 'H', l_result);

3556: i := i + 1;
3557: l_url := ''||wf_core.Translate('WF_CLICK_HERE')||'';
3558: l_cells(i) := 'S:'||l_url;
3559:
3560: wf_notification.Ntf_Table(l_cells, 2, 'H', l_result);
3561:
3562: -- Display title "Web Service Details"
3563: l_result := '' ||
3564: ''||
Line 3602: l_cells wf_notification.tdType;

3598: l_item_type varchar2(30);
3599: l_item_key varchar2(240);
3600: l_error_message varchar2(2000);
3601: l_error_stack varchar2(2000);
3602: l_cells wf_notification.tdType;
3603: i pls_integer;
3604: begin
3605:
3606: l_item_type := nvl(substr(document_id, 1, instr(document_id,':')-1),'WFERROR');

Line 3619: if (display_type = wf_notification.doc_html) then

3615: l_error_stack := wf_engine.GetItemAttrText(itemtype => l_item_type,
3616: itemkey => l_item_key,
3617: aname => 'ERROR_STACK');
3618:
3619: if (display_type = wf_notification.doc_html) then
3620: document_type := wf_notification.doc_html;
3621:
3622: i := 1;
3623: if (l_error_name is not null) then

Line 3620: document_type := wf_notification.doc_html;

3616: itemkey => l_item_key,
3617: aname => 'ERROR_STACK');
3618:
3619: if (display_type = wf_notification.doc_html) then
3620: document_type := wf_notification.doc_html;
3621:
3622: i := 1;
3623: if (l_error_name is not null) then
3624: l_cells(i) := 'E20%:'||wf_core.Translate('WFMON_ERROR_NAME');

Line 3639: wf_notification.NTF_Table(cells => l_cells,

3635: l_cells(i) := 'E20%:'||wf_core.Translate('WFMON_ERROR_STACK');
3636: i := i + 1;
3637: l_cells(i) := 'S:'||l_error_stack;
3638:
3639: wf_notification.NTF_Table(cells => l_cells,
3640: col => 2,
3641: type => 'V',
3642: rs => l_result);
3643:

Line 3649: document_type := wf_notification.doc_text;

3645: l_result := '
'||wf_core.Translate('WF_WEBSERVICE_DETAILS')||'

' ||
3646: ''||'
'||wf_core.Translate('WF_ERROR_DETAILS') ||
3647: '
'||l_result||'
';
3648: else
3649: document_type := wf_notification.doc_text;
3650: l_result := rpad(wf_core.Translate('WFMON_ERROR_NAME'),40)||' : '||l_error_name||wf_core.newline||
3651: rpad(wf_core.Translate('WFMON_ERROR_MESSAGE'),40)||' : '||l_error_message||wf_core.newline||
3652: rpad(wf_core.Translate('WFMON_ERROR_STACK'),40)||' : '||l_error_stack||wf_core.newline;
3653: end if;

Line 3723: l_subject WF_NOTIFICATIONS.SUBJECT%TYPE;

3719: l_parmlist_t wf_parameter_list_t;
3720:
3721:
3722: l_nid number;
3723: l_subject WF_NOTIFICATIONS.SUBJECT%TYPE;
3724: l_messageType WF_NOTIFICATIONS.MESSAGE_TYPE%TYPE;
3725: l_messageName WF_NOTIFICATIONS.MESSAGE_NAME%TYPE;
3726: l_recipient WF_LOCAL_ROLES.NAME%TYPE;
3727: l_recipient_dispname WF_LOCAL_ROLES.DISPLAY_NAME%TYPE;

Line 3724: l_messageType WF_NOTIFICATIONS.MESSAGE_TYPE%TYPE;

3720:
3721:
3722: l_nid number;
3723: l_subject WF_NOTIFICATIONS.SUBJECT%TYPE;
3724: l_messageType WF_NOTIFICATIONS.MESSAGE_TYPE%TYPE;
3725: l_messageName WF_NOTIFICATIONS.MESSAGE_NAME%TYPE;
3726: l_recipient WF_LOCAL_ROLES.NAME%TYPE;
3727: l_recipient_dispname WF_LOCAL_ROLES.DISPLAY_NAME%TYPE;
3728: l_responder WF_LOCAL_ROLES.NAME%TYPE;

Line 3725: l_messageName WF_NOTIFICATIONS.MESSAGE_NAME%TYPE;

3721:
3722: l_nid number;
3723: l_subject WF_NOTIFICATIONS.SUBJECT%TYPE;
3724: l_messageType WF_NOTIFICATIONS.MESSAGE_TYPE%TYPE;
3725: l_messageName WF_NOTIFICATIONS.MESSAGE_NAME%TYPE;
3726: l_recipient WF_LOCAL_ROLES.NAME%TYPE;
3727: l_recipient_dispname WF_LOCAL_ROLES.DISPLAY_NAME%TYPE;
3728: l_responder WF_LOCAL_ROLES.NAME%TYPE;
3729: l_responder_dispname WF_LOCAL_ROLES.DISPLAY_NAME%TYPE;

Line 3798: from wf_notifications

3794: l_nid := l_event_t.getValueForParameter('NOTIFICATION_ID');
3795:
3796: select message_type, message_name, subject, recipient_role, responder
3797: into l_messageType, l_messageName, l_subject, l_recipient, l_responder
3798: from wf_notifications
3799: where notification_id = l_nid;
3800:
3801: l_responder_dispname := WF_DIRECTORY.GetRoleDisplayName(l_responder);
3802: l_recipient_dispname := WF_DIRECTORY.GetRoleDisplayName(l_recipient);

Line 3840: -- the notification response message into WF_NOTIFICATION_IN queue

3836:
3837: --
3838: -- RetryEvent
3839: -- ER 10177347: Called by the Error Process, to re-enqueue
3840: -- the notification response message into WF_NOTIFICATION_IN queue
3841: -- IN
3842: -- itemtype - item type
3843: -- itemkey - item key
3844: -- actid - process activity instance id

Line 3869: l_agent.name := 'WF_NOTIFICATION_IN';

3865: itemkey => itemkey,
3866: name => 'EVENT_MESSAGE' );
3867:
3868: l_agent := wf_agent_t(null, null);
3869: l_agent.name := 'WF_NOTIFICATION_IN';
3870: l_agent.SYSTEM := wf_event.local_system_name;
3871:
3872: -- enqueue the event message in to WF_NOTIFIOCATION_IN queue again
3873: wf_event_ojmstext_qh.enqueue( l_event, l_agent);

Line 3907: l_itemtype WF_NOTIFICATIONS.MESSAGE_TYPE%TYPE;

3903: l_event_t wf_event_t;
3904: l_paramlist wf_parameter_list_t := null;
3905: l_nid number;
3906: l_user WF_LOCAL_ROLES.NAME%TYPE;
3907: l_itemtype WF_NOTIFICATIONS.MESSAGE_TYPE%TYPE;
3908: l_itemkey WF_NOTIFICATIONS.ITEM_KEY%TYPE;
3909: l_context WF_NOTIFICATIONS.CONTEXT%TYPE;
3910: l_actid number;
3911: l_status WF_ITEM_ACTIVITY_STATUSES.ACTIVITY_STATUS%TYPE;

Line 3908: l_itemkey WF_NOTIFICATIONS.ITEM_KEY%TYPE;

3904: l_paramlist wf_parameter_list_t := null;
3905: l_nid number;
3906: l_user WF_LOCAL_ROLES.NAME%TYPE;
3907: l_itemtype WF_NOTIFICATIONS.MESSAGE_TYPE%TYPE;
3908: l_itemkey WF_NOTIFICATIONS.ITEM_KEY%TYPE;
3909: l_context WF_NOTIFICATIONS.CONTEXT%TYPE;
3910: l_actid number;
3911: l_status WF_ITEM_ACTIVITY_STATUSES.ACTIVITY_STATUS%TYPE;
3912: l_result varchar2(20);

Line 3909: l_context WF_NOTIFICATIONS.CONTEXT%TYPE;

3905: l_nid number;
3906: l_user WF_LOCAL_ROLES.NAME%TYPE;
3907: l_itemtype WF_NOTIFICATIONS.MESSAGE_TYPE%TYPE;
3908: l_itemkey WF_NOTIFICATIONS.ITEM_KEY%TYPE;
3909: l_context WF_NOTIFICATIONS.CONTEXT%TYPE;
3910: l_actid number;
3911: l_status WF_ITEM_ACTIVITY_STATUSES.ACTIVITY_STATUS%TYPE;
3912: l_result varchar2(20);
3913: l_err_nid number;

Line 3934: l_result := Wf_Notification.GetAttrText(l_err_nid, 'RESULT');

3930:
3931: -- Get the error notification id from Notification_Status() API by passing itemtype, itemkey and activity id
3932: WF_ITEM_ACTIVITY_STATUS.Notification_Status(itemtype, itemkey, actid, l_err_nid, l_user);
3933:
3934: l_result := Wf_Notification.GetAttrText(l_err_nid, 'RESULT');
3935:
3936: -- If the result attribute value is 'RESOLVED', then get the activity status of parent notification
3937: if( l_result = 'RESOLVED') then
3938:

Line 3943: from wf_notifications

3939: begin
3940:
3941: select message_type, item_key, context
3942: into l_itemtype, l_itemkey, l_context
3943: from wf_notifications
3944: where notification_id = l_nid;
3945:
3946: -- extract the activity id
3947: l_actid := to_number(SubStr(l_context, instr(l_context,':',1,2)+1));