DBA Data[Home] [Help]

APPS.WF_STANDARD dependencies on WF_STANDARD

Line 1: package body WF_STANDARD as

1: package body WF_STANDARD as
2: /* $Header: wfstdb.pls 120.17.12020000.2 2012/11/13 19:39:29 alsosa ship $ */
3:
4:
5:

Line 102: Wf_Core.Context('Wf_Standard', 'AbortProcess', itemtype,

98: resultout := wf_engine.eng_null;
99:
100: exception
101: when others then
102: Wf_Core.Context('Wf_Standard', 'AbortProcess', itemtype,
103: itemkey, to_char(actid), funcmode);
104: raise;
105: end AbortProcess;
106:

Line 123: Wf_Core.Context('Wf_Standard', 'OrJoin', itemtype, itemkey,

119: begin
120: resultout := wf_engine.eng_null;
121: exception
122: when others then
123: Wf_Core.Context('Wf_Standard', 'OrJoin', itemtype, itemkey,
124: to_char(actid), funcmode);
125: raise;
126: end OrJoin;
127:

Line 152: Wf_Core.Token('OPERATION', 'Wf_Standard.AndJoin');

148: end if;
149:
150: -- SYNCHMODE: Not allowed
151: if (itemkey = wf_engine.eng_synch) then
152: Wf_Core.Token('OPERATION', 'Wf_Standard.AndJoin');
153: Wf_Core.Raise('WFENG_SYNCH_DISABLED');
154: end if;
155:
156: -- The And fails if there is at least one in-transition which is either

Line 196: Wf_Core.Context('Wf_Standard', 'AndJoin', itemtype,

192: end if;
193: return;
194: exception
195: when others then
196: Wf_Core.Context('Wf_Standard', 'AndJoin', itemtype,
197: itemkey, to_char(actid), funcmode);
198: raise;
199: end AndJoin;
200:

Line 251: Wf_Core.Context('Wf_Standard', 'Assign', itemtype,

247:
248: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;
249: exception
250: when others then
251: Wf_Core.Context('Wf_Standard', 'Assign', itemtype,
252: itemkey, to_char(actid), funcmode);
253: raise;
254: end Assign;
255:

Line 281: Wf_Core.Token('OPERATION', 'Wf_Standard.GetUrl');

277: end if;
278:
279: -- SYNCHMODE: Not allowed
280: if (itemkey = wf_engine.eng_synch) then
281: Wf_Core.Token('OPERATION', 'Wf_Standard.GetUrl');
282: Wf_Core.Raise('WFENG_SYNCH_DISABLED');
283: end if;
284:
285: -- Get item attribute name

Line 299: Wf_Core.Context('Wf_Standard', 'GetUrl', itemtype,

295:
296: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;
297: exception
298: when others then
299: Wf_Core.Context('Wf_Standard', 'GetUrl', itemtype,
300: itemkey, to_char(actid), funcmode);
301: raise;
302: end GetURL;
303:

Line 402: Wf_Core.Context('Wf_Standard', 'Compare', itemtype,

398: end if;
399:
400: exception
401: when others then
402: Wf_Core.Context('Wf_Standard', 'Compare', itemtype,
403: itemkey, to_char(actid), funcmode);
404: raise;
405: end Compare;
406:

Line 480: Wf_Core.Context('Wf_Standard', 'CompareExecutionTime', itemtype,

476: end if;
477:
478: exception
479: when others then
480: Wf_Core.Context('Wf_Standard', 'CompareExecutionTime', itemtype,
481: itemkey, to_char(actid), funcmode);
482: raise;
483: end CompareExecutionTime;
484:

Line 694: Wf_Core.Context('Wf_Standard', 'CompareEventProperty', itemtype,

690: end if;
691:
692: exception
693: when others then
694: Wf_Core.Context('Wf_Standard', 'CompareEventProperty', itemtype,
695: itemkey, to_char(actid), funcmode);
696: raise;
697: end CompareEventProperty;
698:

Line 873: Wf_Core.Context('Wf_Standard', 'SetEventProperty', itemtype,

869: end if; -- RUN
870:
871: exception
872: when others then
873: Wf_Core.Context('Wf_Standard', 'SetEventProperty', itemtype,
874: itemkey, to_char(actid), funcmode);
875: raise;
876: end SetEventProperty;
877:

Line 1012: Wf_Core.Context('Wf_Standard', 'GetEventProperty', itemtype,

1008: end if; -- RUN
1009:
1010: exception
1011: when others then
1012: Wf_Core.Context('Wf_Standard', 'GetEventProperty', itemtype,
1013: itemkey, to_char(actid), funcmode);
1014: raise;
1015: end GetEventProperty;
1016:

Line 1135: Wf_Core.Context('Wf_Standard', 'LaunchProcess', itemtype,

1131: resultout := wf_engine.eng_completed;
1132:
1133: exception
1134: when others then
1135: Wf_Core.Context('Wf_Standard', 'LaunchProcess', itemtype,
1136: itemkey, to_char(actid), Sitemtype||':'||Sitemkey||SProcess);
1137: raise;
1138: end LaunchProcess;
1139:

Line 1175: Wf_Core.Token('OPERATION', 'Wf_Standard.ForkItem');

1171: return;
1172: end if;
1173:
1174: if (itemkey = wf_engine.eng_synch) then
1175: Wf_Core.Token('OPERATION', 'Wf_Standard.ForkItem');
1176: Wf_Core.Raise('WFENG_SYNCH_DISABLED');
1177: end if;
1178:
1179:

Line 1207: Wf_Core.Context('Wf_Standard', 'ForkItem', itemtype,

1203: resultout := wf_engine.eng_completed;
1204:
1205: exception
1206: when others then
1207: Wf_Core.Context('Wf_Standard', 'ForkItem', itemtype,
1208: itemkey, to_char(actid), Sitemkey);
1209: raise;
1210: end ForkItem;
1211:

Line 1226: Wf_Core.Context('Wf_Standard', 'Noop', itemtype,

1222: begin
1223: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;
1224: exception
1225: when others then
1226: Wf_Core.Context('Wf_Standard', 'Noop', itemtype,
1227: itemkey, to_char(actid), funcmode);
1228: raise;
1229: end Noop;
1230:

Line 1308: Wf_Core.Context('Wf_Standard', 'Notify', itemtype,

1304:
1305:
1306: exception
1307: when others then
1308: Wf_Core.Context('Wf_Standard', 'Notify', itemtype,
1309: itemkey, to_char(actid), funcmode);
1310: raise;
1311: end Notify;
1312:

Line 1335: Wf_Core.Context('Wf_Standard', 'Block', itemtype,

1331: resultout := wf_engine.eng_notified||':'||wf_engine.eng_null||
1332: ':'||wf_engine.eng_null;
1333: exception
1334: when others then
1335: Wf_Core.Context('Wf_Standard', 'Block', itemtype,
1336: itemkey, to_char(actid), funcmode);
1337: raise;
1338: end Block;
1339:

Line 1378: Wf_Core.Context('Wf_Standard', 'Defer', itemtype, itemkey,

1374: end if;
1375:
1376: exception
1377: when others then
1378: Wf_Core.Context('Wf_Standard', 'Defer', itemtype, itemkey,
1379: to_char(actid), funcmode);
1380: raise;
1381: end Defer;
1382:

Line 1446: Wf_Core.Token('OPERATION', 'Wf_Standard.Wait');

1442: end if;
1443:
1444: -- SYNCHMODE: Not allowed
1445: if (itemkey = wf_engine.eng_synch) then
1446: Wf_Core.Token('OPERATION', 'Wf_Standard.Wait');
1447: Wf_Core.Raise('WFENG_SYNCH_DISABLED');
1448: end if;
1449:
1450: -- Check if this is the first or second execution of this activity.

Line 1529: Wf_Core.Context('Wf_Standard', 'Wait', itemtype, itemkey,

1525: end if;
1526:
1527: exception
1528: when wf_invalid_mode then
1529: Wf_Core.Context('Wf_Standard', 'Wait', itemtype, itemkey,
1530: to_char(actid), funcmode);
1531: Wf_Core.Token('COMMAND', wait_mode);
1532: Wf_Core.Raise('WFSQL_COMMAND');
1533: when others then

Line 1534: Wf_Core.Context('Wf_Standard', 'Wait', itemtype, itemkey,

1530: to_char(actid), funcmode);
1531: Wf_Core.Token('COMMAND', wait_mode);
1532: Wf_Core.Raise('WFSQL_COMMAND');
1533: when others then
1534: Wf_Core.Context('Wf_Standard', 'Wait', itemtype, itemkey,
1535: to_char(actid), funcmode);
1536: raise;
1537: end Wait;
1538:

Line 1570: Wf_Core.Token('OPERATION', 'Wf_Standard.ResetError');

1566: end if;
1567:
1568: -- SYNCHMODE: Not allowed
1569: if (itemkey = wf_engine.eng_synch) then
1570: Wf_Core.Token('OPERATION', 'Wf_Standard.ResetError');
1571: Wf_Core.Raise('WFENG_SYNCH_DISABLED');
1572: end if;
1573:
1574: -- Get RETRY or SKIP command

Line 1607: Wf_Core.Context('Wf_Standard', 'ResetError', itemtype,

1603:
1604: resultout := wf_engine.eng_null;
1605: exception
1606: when wf_invalid_command then
1607: Wf_Core.Context('Wf_Standard', 'ResetError', itemtype,
1608: itemkey, to_char(actid), funcmode);
1609: Wf_Core.Token('COMMAND', cmd);
1610: Wf_Core.Raise('WFSQL_COMMAND');
1611: when others then

Line 1612: Wf_Core.Context('Wf_Standard', 'ResetError', itemtype,

1608: itemkey, to_char(actid), funcmode);
1609: Wf_Core.Token('COMMAND', cmd);
1610: Wf_Core.Raise('WFSQL_COMMAND');
1611: when others then
1612: Wf_Core.Context('Wf_Standard', 'ResetError', itemtype,
1613: itemkey, to_char(actid), funcmode);
1614: raise;
1615: end ResetError;
1616:

Line 1684: Wf_Core.Token('OPERATION', 'Wf_Standard.AndJoin');

1680: end if;
1681:
1682: -- SYNCHMODE: Not allowed
1683: if (itemkey = wf_engine.eng_synch) then
1684: Wf_Core.Token('OPERATION', 'Wf_Standard.AndJoin');
1685: Wf_Core.Raise('WFENG_SYNCH_DISABLED');
1686: end if;
1687:
1688: actdate := wf_item.active_date(itemtype, itemkey);

Line 1786: wf_core.context('Wf_Standard', 'RoleResoluion',

1782: end;
1783: end loop;
1784: exception
1785: when wf_invalid_command then
1786: wf_core.context('Wf_Standard', 'RoleResoluion',
1787: itemtype, itemkey, to_char(actid), funcmode);
1788: wf_core.token('COMMAND', cmd);
1789: wf_core.raise('WFSQL_COMMAND');
1790: when others then

Line 1791: wf_core.Context('Wf_Standard', 'RoleResolution',

1787: itemtype, itemkey, to_char(actid), funcmode);
1788: wf_core.token('COMMAND', cmd);
1789: wf_core.raise('WFSQL_COMMAND');
1790: when others then
1791: wf_core.Context('Wf_Standard', 'RoleResolution',
1792: itemtype, itemkey, to_char(actid), funcmode);
1793: raise;
1794: end RoleResolution;
1795:

Line 1820: Wf_Core.Token('OPERATION', 'Wf_Standard.AndJoin');

1816: end if;
1817:
1818: -- SYNCHMODE: Not allowed
1819: if (itemkey = wf_engine.eng_synch) then
1820: Wf_Core.Token('OPERATION', 'Wf_Standard.AndJoin');
1821: Wf_Core.Raise('WFENG_SYNCH_DISABLED');
1822: end if;
1823:
1824: l_waiting_activity := upper(Wf_Engine.GetActivityAttrText(

Line 1839: Wf_Core.Context('Wf_Standard', 'ContinueFlow',

1835: end if;
1836:
1837: exception
1838: when wf_invalid_command then
1839: Wf_Core.Context('Wf_Standard', 'ContinueFlow',
1840: itemtype,itemkey, to_char(actid), funcmode);
1841: Wf_Core.Token('COMMAND', l_waiting_flow );
1842: Wf_Core.Raise('WFSQL_COMMAND');
1843: when others then

Line 1844: Wf_Core.Context('Wf_Standard', 'ContinueFlow',

1840: itemtype,itemkey, to_char(actid), funcmode);
1841: Wf_Core.Token('COMMAND', l_waiting_flow );
1842: Wf_Core.Raise('WFSQL_COMMAND');
1843: when others then
1844: Wf_Core.Context('Wf_Standard', 'ContinueFlow',
1845: itemtype,itemkey, to_char(actid), funcmode);
1846: raise;
1847: end continueflow;
1848:

Line 1873: Wf_Core.Token('OPERATION', 'Wf_Standard.WaitForFlow');

1869: end if;
1870:
1871: -- SYNCHMODE: Not allowed
1872: if (itemkey = wf_engine.eng_synch) then
1873: Wf_Core.Token('OPERATION', 'Wf_Standard.WaitForFlow');
1874: Wf_Core.Raise('WFENG_SYNCH_DISABLED');
1875: end if;
1876:
1877: l_continuation_activity := upper(Wf_Engine.GetActivityAttrText(

Line 1895: Wf_Core.Context('Wf_Standard', 'WaitForFlow',

1891: end if;
1892:
1893: exception
1894: when wf_invalid_command then
1895: Wf_Core.Context('Wf_Standard', 'WaitForFlow',
1896: itemtype,itemkey, to_char(actid), funcmode);
1897: Wf_Core.Token('COMMAND', l_continuation_flow );
1898: Wf_Core.Raise('WFSQL_COMMAND');
1899: when others then

Line 1900: Wf_Core.Context('Wf_Standard', 'WaitForFlow',

1896: itemtype,itemkey, to_char(actid), funcmode);
1897: Wf_Core.Token('COMMAND', l_continuation_flow );
1898: Wf_Core.Raise('WFSQL_COMMAND');
1899: when others then
1900: Wf_Core.Context('Wf_Standard', 'WaitForFlow',
1901: itemtype,itemkey, to_char(actid), funcmode);
1902: raise;
1903: end WaitForFlow;
1904:

Line 1965: wf_core.context('Wf_Standard','LoopCount',

1961: wf_engine.SetItemAttrNumber(
1962: itemtype, itemkey, 'LOOP_COUNT'||':'||actid,loop_count);
1963: exception
1964: when others then
1965: wf_core.context('Wf_Standard','LoopCount',
1966: itemtype, itemkey, to_char(actid), funcmode);
1967: raise;
1968: end loopcounter;
1969:

Line 2060: Wf_Core.Token('OPERATION', 'Wf_Standard.VotForResultType');

2056: end if;
2057:
2058: -- SYNCHMODE: Not allowed
2059: if (itemkey = wf_engine.eng_synch) then
2060: Wf_Core.Token('OPERATION', 'Wf_Standard.VotForResultType');
2061: Wf_Core.Raise('WFENG_SYNCH_DISABLED');
2062: end if;
2063:
2064: -- Get Notifications group_id for activity

Line 2170: Wf_Core.Context('Wf_Standard', 'VoteForResultType', itemtype,

2166: end if;
2167: return;
2168: exception
2169: when wf_invalid_command then
2170: Wf_Core.Context('Wf_Standard', 'VoteForResultType', itemtype,
2171: itemkey, to_char(actid), funcmode);
2172: Wf_Core.Token('COMMAND', l_voting_option);
2173: Wf_Core.Raise('WFSQL_COMMAND');
2174: when others then

Line 2175: Wf_Core.Context('Wf_Standard', 'VoteForResultType',itemtype,

2171: itemkey, to_char(actid), funcmode);
2172: Wf_Core.Token('COMMAND', l_voting_option);
2173: Wf_Core.Raise('WFSQL_COMMAND');
2174: when others then
2175: Wf_Core.Context('Wf_Standard', 'VoteForResultType',itemtype,
2176: itemkey, to_char(actid), funcmode);
2177: raise;
2178: end VoteForResultType;
2179:

Line 2245: wf_core.context('Wf_Standard', 'WaitForMasterFlow',

2241: end;
2242: resultout := wf_engine.eng_null;
2243: exception
2244: when others then
2245: wf_core.context('Wf_Standard', 'WaitForMasterFlow',
2246: itemtype,itemkey,to_char(actid),continuation_activity);
2247: raise;
2248: end WaitForMasterFlow;
2249:

Line 2380: wf_core.context('Wf_Standard', 'WaitForDetailFlow',

2376:
2377:
2378: exception
2379: when others then
2380: wf_core.context('Wf_Standard', 'WaitForDetailFlow',
2381: itemtype,itemkey,to_char(actid),continuation_activity);
2382: raise;
2383: end WaitForDetailFlow;
2384:

Line 2437: wf_core.context('Wf_Standard','ContinueDetailFlow',

2433: ContinueDetailFlow.resultout := wf_engine.eng_null;
2434:
2435: exception
2436: when others then
2437: wf_core.context('Wf_Standard','ContinueDetailFlow',
2438: itemtype, itemkey, to_char(actid),waiting_activity);
2439: raise;
2440: end ContinueDetailFlow;
2441:

Line 2679: wf_core.context('Wf_Standard', 'ContinueMasterFlow',

2675: WF_CORE.Token('LENGTH', 30);
2676: WF_CORE.Raise('WFENG_LABEL_TOO_LARGE');
2677:
2678: when others then
2679: wf_core.context('Wf_Standard', 'ContinueMasterFlow',
2680: itemtype, itemkey, to_char(actid), waiting_activity);
2681: raise;
2682: end ContinueMasterFlow;
2683:

Line 2781: WF_CORE.Context('WF_STANDARD', 'InitializeErrors',

2777: result := wf_engine.eng_completed;
2778: END IF;
2779: EXCEPTION
2780: WHEN OTHERS THEN
2781: WF_CORE.Context('WF_STANDARD', 'InitializeErrors',
2782: itemtype, itemkey, actid, funcmode);
2783: RAISE;
2784: END InitializeErrors;
2785:

Line 2847: WF_CORE.Context('WF_STANDARD', 'CheckErrorActive',

2843: END IF;
2844:
2845: EXCEPTION
2846: WHEN OTHERS THEN
2847: WF_CORE.Context('WF_STANDARD', 'CheckErrorActive',
2848: itemtype, itemkey, actid, funcmode);
2849: RAISE;
2850: END CheckErrorActive;
2851: -- -------------------------------------------------------------------

Line 2968: avalue => 'PLSQL:WF_STANDARD.EVENTDETAILS/'||ItemType||':'||ItemKey);

2964: -- Set the PL/SQL Document for the Event Details
2965: wf_engine.SetItemAttrText(itemtype => itemtype,
2966: itemkey => itemkey,
2967: aname => 'EVENT_DETAILS',
2968: avalue => 'PLSQL:WF_STANDARD.EVENTDETAILS/'||ItemType||':'||ItemKey);
2969:
2970: wf_engine.SetItemAttrText(itemtype => itemtype,
2971: itemkey => itemkey,
2972: aname => 'ERROR_DETAILS',

Line 2973: avalue => 'PLSQL:WF_STANDARD.ErrorDetails/'||ItemType||':'||ItemKey);

2969:
2970: wf_engine.SetItemAttrText(itemtype => itemtype,
2971: itemkey => itemkey,
2972: aname => 'ERROR_DETAILS',
2973: avalue => 'PLSQL:WF_STANDARD.ErrorDetails/'||ItemType||':'||ItemKey);
2974:
2975: wf_engine.SetItemAttrText(itemtype => itemtype,
2976: itemkey => itemkey,
2977: aname => 'SUBSCRIPTION_DETAILS',

Line 2978: avalue => 'PLSQL:WF_STANDARD.SubscriptionDetails/'||ItemType||':'||ItemKey);

2974:
2975: wf_engine.SetItemAttrText(itemtype => itemtype,
2976: itemkey => itemkey,
2977: aname => 'SUBSCRIPTION_DETAILS',
2978: avalue => 'PLSQL:WF_STANDARD.SubscriptionDetails/'||ItemType||':'||ItemKey);
2979:
2980: -- Set the Value for the Error Subscription URL
2981: wf_engine.SetItemAttrText(itemtype => itemtype,
2982: itemkey => itemkey,

Line 3006: WF_CORE.Context('WF_STANDARD', 'InitializeEventError',

3002: resultout := wf_engine.eng_completed;
3003: END IF;
3004: EXCEPTION
3005: WHEN OTHERS THEN
3006: WF_CORE.Context('WF_STANDARD', 'InitializeEventError',
3007: itemtype, itemkey, actid, funcmode);
3008: RAISE;
3009: END InitializeEventError;
3010: -- --------------------------------------------------------------------

Line 3220: wf_core.context('WF_STANDARD','EventDetails',document_id, display_type);

3216: document := l_result;
3217:
3218: exception
3219: when others then
3220: wf_core.context('WF_STANDARD','EventDetails',document_id, display_type);
3221: raise;
3222: end EventDetails;
3223: -- --------------------------------------------------------------------
3224: -- Retry Raise

Line 3295: WF_CORE.Context('WF_STANDARD', 'RetryRaise',

3291: END IF;
3292:
3293: EXCEPTION
3294: WHEN OTHERS THEN
3295: WF_CORE.Context('WF_STANDARD', 'RetryRaise',
3296: itemtype, itemkey, actid, funcmode);
3297: RAISE;
3298: end RetryRaise;
3299: -- --------------------------------------------------------------------

Line 3385: WF_CORE.Context('WF_STANDARD', 'GetAgents',

3381: END IF;
3382:
3383: EXCEPTION
3384: WHEN OTHERS THEN
3385: WF_CORE.Context('WF_STANDARD', 'GetAgents',
3386: itemtype, itemkey, actid, funcmode);
3387: RAISE;
3388: end GetAgents;
3389: -- --------------------------------------------------------------------

Line 3450: WF_CORE.Context('WF_STANDARD', 'GetAckAgent',

3446: END IF;
3447:
3448: EXCEPTION
3449: WHEN OTHERS THEN
3450: WF_CORE.Context('WF_STANDARD', 'GetAckAgent',
3451: itemtype, itemkey, actid, funcmode);
3452: RAISE;
3453: end GetAckAgent;
3454:

Line 3580: wf_core.context('WF_STANDARD', 'SubscriptionDetails', document_id);

3576: end if;
3577: document := l_result;
3578: exception
3579: when others then
3580: wf_core.context('WF_STANDARD', 'SubscriptionDetails', document_id);
3581: raise;
3582: end SubscriptionDetails;
3583:
3584: -- ErrorDetails

Line 3657: wf_core.context('WF_STANDARD', 'ErrorDetails', document_id);

3653: end if;
3654: document := l_result;
3655: exception
3656: when others then
3657: wf_core.context('WF_STANDARD', 'ErrorDetails', document_id);
3658: raise;
3659: end ErrorDetails;
3660:
3661: -- SubscriptionAction

Line 3878: WF_CORE.Context('WF_STANDARD', 'RetryEvent',

3874:
3875:
3876: EXCEPTION
3877: WHEN OTHERS THEN
3878: WF_CORE.Context('WF_STANDARD', 'RetryEvent',
3879: itemtype, itemkey, actid, funcmode);
3880: RAISE;
3881:
3882: end RetryEvent;

Line 3970: WF_CORE.Context('WF_STANDARD', 'VALIDATE_RESPONSE',

3966:
3967:
3968: EXCEPTION
3969: WHEN wf_incomplete_ntf THEN
3970: WF_CORE.Context('WF_STANDARD', 'VALIDATE_RESPONSE',
3971: itemtype, itemkey, actid, funcmode);
3972: wf_core.clear;
3973: Wf_Core.Token('NID', l_nid);
3974: Wf_Core.Raise('WFNTF_NOT_COMPLETE');

Line 3977: WF_CORE.Context('WF_STANDARD', 'VALIDATE_RESPONSE',

3973: Wf_Core.Token('NID', l_nid);
3974: Wf_Core.Raise('WFNTF_NOT_COMPLETE');
3975:
3976: WHEN OTHERS THEN
3977: WF_CORE.Context('WF_STANDARD', 'VALIDATE_RESPONSE',
3978: itemtype, itemkey, actid, funcmode);
3979: RAISE;
3980:
3981:

Line 3985: END WF_STANDARD;

3981:
3982: end VALIDATE_RESPONSE;
3983:
3984:
3985: END WF_STANDARD;