DBA Data[Home] [Help]

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 3004: l_cells wf_notification.tdType;

3000: i pls_integer;
3001:
3002: l_event_t wf_event_t;
3003: l_parmlist_t wf_parameter_list_t;
3004: l_cells wf_notification.tdType;
3005: j number;
3006: l_result varchar2(32000);
3007:
3008: begin

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

3040: --
3041: l_send_date := l_event_t.GetSendDate();
3042:
3043: IF l_send_date IS NOT NULL THEN
3044: l_send_date_text := WF_NOTIFICATION_UTIL.GetCalendarDate(-1, l_send_date, null, true);
3045: END IF;
3046:
3047: l_receive_date := l_event_t.GetReceiveDate();
3048:

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

3046:
3047: l_receive_date := l_event_t.GetReceiveDate();
3048:
3049: IF l_receive_date IS NOT NULL THEN
3050: l_receive_date_text := WF_NOTIFICATION_UTIL.GetCalendarDate(-1, l_receive_date, null, true);
3051: END IF;
3052:
3053: --
3054: -- Get the Priority

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

3058: --
3059: -- Build up the PL/SQL Document depending on the User Mail Preference
3060: --
3061: -- bug 6955474
3062: -- Using WF_NOTIFICATION.NTF_Table API to maintain consistency with BLAF
3063: --
3064: -- Build the Table
3065: if (display_type = wf_notification.doc_html) then
3066: i := 1;

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

3061: -- bug 6955474
3062: -- Using WF_NOTIFICATION.NTF_Table API to maintain consistency with BLAF
3063: --
3064: -- Build the Table
3065: if (display_type = wf_notification.doc_html) then
3066: i := 1;
3067: l_cells(i) := wf_core.translate('WF_EVENT_HEADING');
3068: l_cells(i) := 'S30%:'||l_cells(i);
3069:

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

3150: l_parmlist_t := l_event_t.getParameterList();
3151: if (l_parmlist_t is not null) then
3152: j := l_parmlist_t.FIRST;
3153: while (j <= l_parmlist_t.LAST) loop
3154: if (display_type = wf_notification.doc_html) then
3155: i := i + 1;
3156: l_cells(i) := 'S:'||wf_core.translate('WF_PARAMETER')||' : '||l_parmlist_t(j).getName();
3157:
3158: i := i + 1;

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

3166: j := l_parmlist_t.NEXT(j);
3167: end loop;
3168: end if;
3169:
3170: if (display_type = wf_notification.doc_html) then
3171: document_type := wf_notification.doc_html;
3172: wf_notification.NTF_Table(cells => l_cells,
3173: col => 2,
3174: type => 'H',

Line 3171: document_type := wf_notification.doc_html;

3167: end loop;
3168: end if;
3169:
3170: if (display_type = wf_notification.doc_html) then
3171: document_type := wf_notification.doc_html;
3172: wf_notification.NTF_Table(cells => l_cells,
3173: col => 2,
3174: type => 'H',
3175: rs => l_result);

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

3168: end if;
3169:
3170: if (display_type = wf_notification.doc_html) then
3171: document_type := wf_notification.doc_html;
3172: wf_notification.NTF_Table(cells => l_cells,
3173: col => 2,
3174: type => 'H',
3175: rs => l_result);
3176: -- Display title

Line 3182: document_type := wf_notification.doc_text;

3178: ''||wf_core.Translate('WFITD_EVENT_DETAILS')||
3179: ''||''||l_result||'';
3180:
3181: else
3182: document_type := wf_notification.doc_text;
3183: end if;
3184: document := l_result;
3185:
3186: exception

Line 3440: l_cells wf_notification.tdType;

3436: l_item_key varchar2(240);
3437: l_subscription raw(16);
3438: l_params varchar2(4000);
3439: l_rule_func varchar2(240);
3440: l_cells wf_notification.tdType;
3441: l_cells2 wf_notification.tdType;
3442: i pls_integer;
3443: j pls_integer;
3444: l_document varchar2(32000);

Line 3441: l_cells2 wf_notification.tdType;

3437: l_subscription raw(16);
3438: l_params varchar2(4000);
3439: l_rule_func varchar2(240);
3440: l_cells wf_notification.tdType;
3441: l_cells2 wf_notification.tdType;
3442: i pls_integer;
3443: j pls_integer;
3444: l_document varchar2(32000);
3445: l_sub_param_list wf_parameter_list_t;

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

3467: WHERE guid = l_subscription;
3468:
3469: l_sub_param_list := wf_event.GetParamListFromString(l_params);
3470:
3471: if (display_type = wf_notification.doc_html) then
3472: i := 1;
3473: l_cells(i) := 'S30%:'||wf_core.Translate('WF_PARAMETER');
3474:
3475: i := i + 1;

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

3483: -- meta-data store for WS definition
3484: if (l_sub_param_list is not null) then
3485: j := l_sub_param_list.FIRST;
3486: while (j is not null) loop
3487: if (display_type = wf_notification.doc_html) then
3488: i := i + 1;
3489: l_cells(i) := 'S:'||l_sub_param_list(j).getName();
3490:
3491: i := i + 1;

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

3506: l_sub_url := wf_engine.GetItemAttrText(itemtype => l_item_type,
3507: itemkey => l_item_key,
3508: aname => 'EVENT_SUBSCRIPTION');
3509:
3510: if (display_type = wf_notification.doc_html) then
3511: i := i + 1;
3512: l_cells(i) := 'S:'||wf_core.Translate('WF_INOKER_RULE_FUNC');
3513: i := i + 1;
3514: l_cells(i) := 'S:'||l_rule_func;

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

3524: i := i + 1;
3525: l_url := ''||wf_core.Translate('WF_CLICK_HERE')||'';
3526: l_cells(i) := 'S:'||l_url;
3527:
3528: wf_notification.Ntf_Table(l_cells, 2, 'H', l_result);
3529:
3530: -- Display title "Web Service Details"
3531: l_result := '' ||
3532: ''||

Line 3570: l_cells wf_notification.tdType;

3566: l_item_type varchar2(30);
3567: l_item_key varchar2(240);
3568: l_error_message varchar2(2000);
3569: l_error_stack varchar2(2000);
3570: l_cells wf_notification.tdType;
3571: i pls_integer;
3572: begin
3573:
3574: l_item_type := nvl(substr(document_id, 1, instr(document_id,':')-1),'WFERROR');

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

3583: l_error_stack := wf_engine.GetItemAttrText(itemtype => l_item_type,
3584: itemkey => l_item_key,
3585: aname => 'ERROR_STACK');
3586:
3587: if (display_type = wf_notification.doc_html) then
3588: document_type := wf_notification.doc_html;
3589:
3590: i := 1;
3591: if (l_error_name is not null) then

Line 3588: document_type := wf_notification.doc_html;

3584: itemkey => l_item_key,
3585: aname => 'ERROR_STACK');
3586:
3587: if (display_type = wf_notification.doc_html) then
3588: document_type := wf_notification.doc_html;
3589:
3590: i := 1;
3591: if (l_error_name is not null) then
3592: l_cells(i) := 'E20%:'||wf_core.Translate('WFMON_ERROR_NAME');

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

3603: l_cells(i) := 'E20%:'||wf_core.Translate('WFMON_ERROR_STACK');
3604: i := i + 1;
3605: l_cells(i) := 'S:'||l_error_stack;
3606:
3607: wf_notification.NTF_Table(cells => l_cells,
3608: col => 2,
3609: type => 'V',
3610: rs => l_result);
3611:

Line 3617: document_type := wf_notification.doc_text;

3613: l_result := '

'||wf_core.Translate('WF_WEBSERVICE_DETAILS')||'
' ||
3614: ''||'
'||wf_core.Translate('WF_ERROR_DETAILS') ||
3615: '
'||l_result||'
';
3616: else
3617: document_type := wf_notification.doc_text;
3618: l_result := rpad(wf_core.Translate('WFMON_ERROR_NAME'),40)||' : '||l_error_name||wf_core.newline||
3619: rpad(wf_core.Translate('WFMON_ERROR_MESSAGE'),40)||' : '||l_error_message||wf_core.newline||
3620: rpad(wf_core.Translate('WFMON_ERROR_STACK'),40)||' : '||l_error_stack||wf_core.newline;
3621: end if;