APPS.WF_STANDARD dependencies on WF_CORE

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 153: Wf_Core.Raise('WFENG_SYNCH_DISABLED');

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
157: -- incomplete or complete with the wrong result.

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 282: Wf_Core.Raise('WFENG_SYNCH_DISABLED');

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
286: aname := wf_engine.GetActivityAttrText(itemtype,itemkey,actid, 'ATTR');

Line 294: wf_core.translate('WF_WEB_AGENT'), itemtype, itemkey, admin));

290:
291: -- Set item attribute
292: wf_engine.SetItemAttrText(itemtype, itemkey, aname,
293: wf_monitor.geturl(
294: wf_core.translate('WF_WEB_AGENT'), itemtype, itemkey, admin));
295:
296: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;
297: exception
298: when others then

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 1058: wf_core.token('ITEMTYPE','NULL');

1054: SItemtype := upper(Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ITEMTYPE'));
1055: Deferit := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'DEFER');
1056:
1057: if SItemtype is null then
1058: wf_core.token('ITEMTYPE','NULL');
1059: wf_core.raise('WFSQL_ARGS');
1060: end if;
1061:
1062: if deferit = 'Y' then

Line 1059: wf_core.raise('WFSQL_ARGS');

1055: Deferit := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'DEFER');
1056:
1057: if SItemtype is null then
1058: wf_core.token('ITEMTYPE','NULL');
1059: wf_core.raise('WFSQL_ARGS');
1060: end if;
1061:
1062: if deferit = 'Y' then
1063: -- Check if this is the first or second execution of this activity.

Line 1097: if ( wf_core.error_name = 'WFENG_ITEM_ATTR' ) then

1093: when others then
1094: --
1095: -- If item attribute does not exist then create it;
1096: --
1097: if ( wf_core.error_name = 'WFENG_ITEM_ATTR' ) then
1098: wf_engine.AddItemAttr(itemtype,itemkey, 'LAUNCH_COUNT');
1099: launch_count := 0;
1100: else
1101: raise;

Line 1119: if ( wf_core.error_name <> 'WFENG_ITEM_UNIQUE' ) then

1115: when others then
1116: --
1117: -- Dont raise error if its a dup name: instead we will loop
1118: -- around and increment the counter.
1119: if ( wf_core.error_name <> 'WFENG_ITEM_UNIQUE' ) then
1120: raise;
1121: end if;
1122: end;
1123: end loop;

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 1176: Wf_Core.Raise('WFENG_SYNCH_DISABLED');

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:
1180:

Line 1186: wf_core.token('ITEMKEY',Sitemkey);

1182: SameVersionFlag := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'SAME_VERSION');
1183:
1184: if SItemkey is null
1185: or SameVersionFlag is null then
1186: wf_core.token('ITEMKEY',Sitemkey);
1187: wf_core.token('SAME_VERSION',SameVersionFlag);
1188: wf_core.raise('WFSQL_ARGS');
1189: end if;
1190:

Line 1187: wf_core.token('SAME_VERSION',SameVersionFlag);

1183:
1184: if SItemkey is null
1185: or SameVersionFlag is null then
1186: wf_core.token('ITEMKEY',Sitemkey);
1187: wf_core.token('SAME_VERSION',SameVersionFlag);
1188: wf_core.raise('WFSQL_ARGS');
1189: end if;
1190:
1191: if SameVersionFlag = 'T' then

Line 1188: wf_core.raise('WFSQL_ARGS');

1184: if SItemkey is null
1185: or SameVersionFlag is null then
1186: wf_core.token('ITEMKEY',Sitemkey);
1187: wf_core.token('SAME_VERSION',SameVersionFlag);
1188: wf_core.raise('WFSQL_ARGS');
1189: end if;
1190:
1191: if SameVersionFlag = 'T' then
1192: sameversion := TRUE;

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 1271: Wf_Core.Token('TYPE', itemtype);

1267: prole := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'PERFORMER');
1268: end if;
1269:
1270: if prole is null then
1271: Wf_Core.Token('TYPE', itemtype);
1272: Wf_Core.Token('ACTID', to_char(actid));
1273: Wf_Core.Raise('WFENG_NOTIFICATION_PERFORMER');
1274: end if;
1275:

Line 1272: Wf_Core.Token('ACTID', to_char(actid));

1268: end if;
1269:
1270: if prole is null then
1271: Wf_Core.Token('TYPE', itemtype);
1272: Wf_Core.Token('ACTID', to_char(actid));
1273: Wf_Core.Raise('WFENG_NOTIFICATION_PERFORMER');
1274: end if;
1275:
1276: -- message name and expand roles will be null. Get these from attributes

Line 1273: Wf_Core.Raise('WFENG_NOTIFICATION_PERFORMER');

1269:
1270: if prole is null then
1271: Wf_Core.Token('TYPE', itemtype);
1272: Wf_Core.Token('ACTID', to_char(actid));
1273: Wf_Core.Raise('WFENG_NOTIFICATION_PERFORMER');
1274: end if;
1275:
1276: -- message name and expand roles will be null. Get these from attributes
1277: avalue := upper(Wf_Engine.GetActivityAttrText(itemtype, itemkey,

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 1447: Wf_Core.Raise('WFENG_SYNCH_DISABLED');

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.
1451: -- First -> result_code will be null (really null).

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 1531: Wf_Core.Token('COMMAND', wait_mode);

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
1534: Wf_Core.Context('Wf_Standard', 'Wait', itemtype, itemkey,
1535: to_char(actid), funcmode);

Line 1532: Wf_Core.Raise('WFSQL_COMMAND');

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
1534: Wf_Core.Context('Wf_Standard', 'Wait', itemtype, itemkey,
1535: to_char(actid), funcmode);
1536: raise;

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 1571: Wf_Core.Raise('WFENG_SYNCH_DISABLED');

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
1575: cmd := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, '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 1609: Wf_Core.Token('COMMAND', cmd);

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
1612: Wf_Core.Context('Wf_Standard', 'ResetError', itemtype,
1613: itemkey, to_char(actid), funcmode);

Line 1610: Wf_Core.Raise('WFSQL_COMMAND');

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
1612: Wf_Core.Context('Wf_Standard', 'ResetError', itemtype,
1613: itemkey, to_char(actid), funcmode);
1614: raise;

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 1685: Wf_Core.Raise('WFENG_SYNCH_DISABLED');

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);
1689: cmd := Wf_Engine.GetActivityAttrText(itemtype,itemkey,actid,'METHOD');

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 1788: wf_core.token('COMMAND', cmd);

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
1791: wf_core.Context('Wf_Standard', 'RoleResolution',
1792: itemtype, itemkey, to_char(actid), funcmode);

Line 1789: wf_core.raise('WFSQL_COMMAND');

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
1791: wf_core.Context('Wf_Standard', 'RoleResolution',
1792: itemtype, itemkey, to_char(actid), funcmode);
1793: raise;

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 1821: Wf_Core.Raise('WFENG_SYNCH_DISABLED');

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(
1825: itemtype, itemkey, actid,'WAITING_ACTIVITY'));

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 1841: Wf_Core.Token('COMMAND', l_waiting_flow );

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
1844: Wf_Core.Context('Wf_Standard', 'ContinueFlow',
1845: itemtype,itemkey, to_char(actid), funcmode);

Line 1842: Wf_Core.Raise('WFSQL_COMMAND');

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
1844: Wf_Core.Context('Wf_Standard', 'ContinueFlow',
1845: itemtype,itemkey, to_char(actid), funcmode);
1846: raise;

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 1874: Wf_Core.Raise('WFENG_SYNCH_DISABLED');

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(
1878: itemtype, itemkey, actid,

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 1897: Wf_Core.Token('COMMAND', l_continuation_flow );

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
1900: Wf_Core.Context('Wf_Standard', 'WaitForFlow',
1901: itemtype,itemkey, to_char(actid), funcmode);

Line 1898: Wf_Core.Raise('WFSQL_COMMAND');

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
1900: Wf_Core.Context('Wf_Standard', 'WaitForFlow',
1901: itemtype,itemkey, to_char(actid), funcmode);
1902: raise;

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 1932: wf_core.token('MAX_TIMES',max_times);

1928: -- Get maximum times activity can be executed.
1929: max_times := wf_engine.GetActivityAttrNumber(
1930: itemtype, itemkey, actid, 'MAX_TIMES');
1931: if ( max_times is null ) then
1932: wf_core.token('MAX_TIMES',max_times);
1933: wf_core.raise('WFSQL_ARGS');
1934: end if;
1935:
1936: begin

Line 1933: wf_core.raise('WFSQL_ARGS');

1929: max_times := wf_engine.GetActivityAttrNumber(
1930: itemtype, itemkey, actid, 'MAX_TIMES');
1931: if ( max_times is null ) then
1932: wf_core.token('MAX_TIMES',max_times);
1933: wf_core.raise('WFSQL_ARGS');
1934: end if;
1935:
1936: begin
1937: loop_count := wf_engine.GetItemAttrNumber(

Line 1944: if ( wf_core.error_name = 'WFENG_ITEM_ATTR' ) then

1940: when others then
1941: --
1942: -- If item attribute does not exist then create it;
1943: --
1944: if ( wf_core.error_name = 'WFENG_ITEM_ATTR' ) then
1945: wf_engine.AddItemAttr(
1946: itemtype,itemkey, 'LOOP_COUNT'||':'||actid);
1947: loop_count := 0;
1948: else

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 2061: Wf_Core.Raise('WFENG_SYNCH_DISABLED');

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
2065: Wf_Item_Activity_Status.Notification_Status(itemtype,itemkey,actid,

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 2172: Wf_Core.Token('COMMAND', l_voting_option);

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
2175: Wf_Core.Context('Wf_Standard', 'VoteForResultType',itemtype,
2176: itemkey, to_char(actid), funcmode);

Line 2173: Wf_Core.Raise('WFSQL_COMMAND');

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
2175: Wf_Core.Context('Wf_Standard', 'VoteForResultType',itemtype,
2176: itemkey, to_char(actid), funcmode);
2177: raise;

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 2354: Wf_Core.Context('WF_ENGINE', l_module, WaitForDetailFlow.itemtype,

2350: aname=>'#CNT_'||l_waitLabel,
2351: number_value=>l_childCount);
2352: exception
2353: when ValTooLarge OR ValTooLargeNew then
2354: Wf_Core.Context('WF_ENGINE', l_module, WaitForDetailFlow.itemtype,
2355: WaitForDetailFlow.itemkey);
2356: WF_CORE.Token('LABEL', '#CNT_'||l_waitLabel);
2357: WF_CORE.Token('LENGTH', 30);
2358: WF_CORE.Raise('WFENG_LABEL_TOO_LARGE');

Line 2356: WF_CORE.Token('LABEL', '#CNT_'||l_waitLabel);

2352: exception
2353: when ValTooLarge OR ValTooLargeNew then
2354: Wf_Core.Context('WF_ENGINE', l_module, WaitForDetailFlow.itemtype,
2355: WaitForDetailFlow.itemkey);
2356: WF_CORE.Token('LABEL', '#CNT_'||l_waitLabel);
2357: WF_CORE.Token('LENGTH', 30);
2358: WF_CORE.Raise('WFENG_LABEL_TOO_LARGE');
2359: end;
2360: if (l_childCount > 0) then

Line 2357: WF_CORE.Token('LENGTH', 30);

2353: when ValTooLarge OR ValTooLargeNew then
2354: Wf_Core.Context('WF_ENGINE', l_module, WaitForDetailFlow.itemtype,
2355: WaitForDetailFlow.itemkey);
2356: WF_CORE.Token('LABEL', '#CNT_'||l_waitLabel);
2357: WF_CORE.Token('LENGTH', 30);
2358: WF_CORE.Raise('WFENG_LABEL_TOO_LARGE');
2359: end;
2360: if (l_childCount > 0) then
2361: resultout := wf_engine.eng_notified||':'||

Line 2358: WF_CORE.Raise('WFENG_LABEL_TOO_LARGE');

2354: Wf_Core.Context('WF_ENGINE', l_module, WaitForDetailFlow.itemtype,
2355: WaitForDetailFlow.itemkey);
2356: WF_CORE.Token('LABEL', '#CNT_'||l_waitLabel);
2357: WF_CORE.Token('LENGTH', 30);
2358: WF_CORE.Raise('WFENG_LABEL_TOO_LARGE');
2359: end;
2360: if (l_childCount > 0) then
2361: resultout := wf_engine.eng_notified||':'||
2362: wf_engine.eng_null||':'||wf_engine.eng_null;

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 2425: if ( wf_core.error_name = 'WFENG_NOT_NOTIFIED' ) then

2421: when others then
2422: -- If call to CompleteActivity cannot find activity, return null
2423: -- As either the detail flows does not have a waiting activity OR
2424: -- the detail flow has not reach the waiting activity
2425: if ( wf_core.error_name = 'WFENG_NOT_NOTIFIED' ) then
2426: wf_core.clear;
2427: else
2428: raise;
2429: end if;

Line 2426: wf_core.clear;

2422: -- If call to CompleteActivity cannot find activity, return null
2423: -- As either the detail flows does not have a waiting activity OR
2424: -- the detail flow has not reach the waiting activity
2425: if ( wf_core.error_name = 'WFENG_NOT_NOTIFIED' ) then
2426: wf_core.clear;
2427: else
2428: raise;
2429: end if;
2430: end;

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 2591: if ( wf_core.error_name = 'WFENG_NOT_NOTIFIED' ) then

2587: waiting_activity,wf_engine.eng_null);
2588: resultout := wf_engine.eng_null;
2589: exception
2590: when OTHERS then
2591: if ( wf_core.error_name = 'WFENG_NOT_NOTIFIED' ) then
2592: wf_core.clear;
2593: ContinueMasterFlow.resultout := wf_engine.eng_null;
2594: else
2595: raise;

Line 2592: wf_core.clear;

2588: resultout := wf_engine.eng_null;
2589: exception
2590: when OTHERS then
2591: if ( wf_core.error_name = 'WFENG_NOT_NOTIFIED' ) then
2592: wf_core.clear;
2593: ContinueMasterFlow.resultout := wf_engine.eng_null;
2594: else
2595: raise;
2596: end if;

Line 2616: if ( wf_core.error_name = 'WFENG_NOT_NOTIFIED' ) then

2612: --
2613: -- If call to CompleteActivity cannot find activity, return
2614: -- null and wait for master flow
2615: --
2616: if ( wf_core.error_name = 'WFENG_NOT_NOTIFIED' ) then
2617: wf_core.clear;
2618: ContinueMasterFlow.resultout := wf_engine.eng_null;
2619: else
2620: raise;

Line 2617: wf_core.clear;

2613: -- If call to CompleteActivity cannot find activity, return
2614: -- null and wait for master flow
2615: --
2616: if ( wf_core.error_name = 'WFENG_NOT_NOTIFIED' ) then
2617: wf_core.clear;
2618: ContinueMasterFlow.resultout := wf_engine.eng_null;
2619: else
2620: raise;
2621: end if;

Line 2648: if ( wf_core.error_name = 'WFENG_NOT_NOTIFIED' ) then

2644: wf_engine.CompleteActivity(l_parent_itemtype,l_parent_itemkey,
2645: waiting_activity,wf_engine.eng_null);
2646: exception
2647: when OTHERS then
2648: if ( wf_core.error_name = 'WFENG_NOT_NOTIFIED' ) then
2649: wf_core.clear;
2650: ContinueMasterFlow.resultout := wf_engine.eng_null;
2651: else
2652: raise;

Line 2649: wf_core.clear;

2645: waiting_activity,wf_engine.eng_null);
2646: exception
2647: when OTHERS then
2648: if ( wf_core.error_name = 'WFENG_NOT_NOTIFIED' ) then
2649: wf_core.clear;
2650: ContinueMasterFlow.resultout := wf_engine.eng_null;
2651: else
2652: raise;
2653: end if;

Line 2672: Wf_Core.Context('WF_ENGINE', l_module, ContinueMasterFlow.itemtype,

2668: end if; --First execution
2669:
2670: exception
2671: when ValTooLarge OR ValTooLargeNew then
2672: Wf_Core.Context('WF_ENGINE', l_module, ContinueMasterFlow.itemtype,
2673: ContinueMasterFlow.itemkey);
2674: WF_CORE.Token('LABEL', l_activity_label);
2675: WF_CORE.Token('LENGTH', 30);
2676: WF_CORE.Raise('WFENG_LABEL_TOO_LARGE');

Line 2674: WF_CORE.Token('LABEL', l_activity_label);

2670: exception
2671: when ValTooLarge OR ValTooLargeNew then
2672: Wf_Core.Context('WF_ENGINE', l_module, ContinueMasterFlow.itemtype,
2673: ContinueMasterFlow.itemkey);
2674: WF_CORE.Token('LABEL', l_activity_label);
2675: WF_CORE.Token('LENGTH', 30);
2676: WF_CORE.Raise('WFENG_LABEL_TOO_LARGE');
2677:
2678: when others then

Line 2675: WF_CORE.Token('LENGTH', 30);

2671: when ValTooLarge OR ValTooLargeNew then
2672: Wf_Core.Context('WF_ENGINE', l_module, ContinueMasterFlow.itemtype,
2673: ContinueMasterFlow.itemkey);
2674: WF_CORE.Token('LABEL', l_activity_label);
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',

Line 2676: WF_CORE.Raise('WFENG_LABEL_TOO_LARGE');

2672: Wf_Core.Context('WF_ENGINE', l_module, ContinueMasterFlow.itemtype,
2673: ContinueMasterFlow.itemkey);
2674: WF_CORE.Token('LABEL', l_activity_label);
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);

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 2923: where ws.guid = hextoraw(wf_core.translate('WF_SYSTEM_GUID'))

2919: -- Since no subscription found, look at from agent details
2920: begin
2921: select 'LOCAL' into l_source
2922: from wf_systems ws
2923: where ws.guid = hextoraw(wf_core.translate('WF_SYSTEM_GUID'))
2924: and ws.name = nvl(l_event_t.GetFromAgent().GetSystem(),ws.name);
2925: exception
2926: when no_data_found then
2927: l_source := 'EXTERNAL';

Line 2937: l_error_message := wf_core.translate('NO_ERROR_MESSAGE');

2933: --
2934: l_error_message := substr(l_event_t.GetErrorMessage(),1,2000);
2935: IF (l_error_message is null) THEN
2936: -- Bug 10126673: Show 'NO_ERROR_MESSAGE' message token when error message is null
2937: l_error_message := wf_core.translate('NO_ERROR_MESSAGE');
2938: END IF;
2939:
2940: -- Get the Error Stack
2941: l_error_stack := substr(l_event_t.GetErrorStack(),1,2000);

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 3099: l_cells(i) := wf_core.translate('WF_EVENT_HEADING');

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:
3102: i := i + 1;
3103: l_cells(i) := wf_core.translate('WF_VALUE');

Line 3103: l_cells(i) := wf_core.translate('WF_VALUE');

3099: l_cells(i) := wf_core.translate('WF_EVENT_HEADING');
3100: l_cells(i) := 'S30%:'||l_cells(i);
3101:
3102: i := i + 1;
3103: l_cells(i) := wf_core.translate('WF_VALUE');
3104: l_cells(i) := 'S70%:'||l_cells(i);
3105:
3106: i := i + 1;
3107: l_cells(i) := 'S:'||wf_core.translate('WF_EVENT_NAME');

Line 3107: l_cells(i) := 'S:'||wf_core.translate('WF_EVENT_NAME');

3103: l_cells(i) := wf_core.translate('WF_VALUE');
3104: l_cells(i) := 'S70%:'||l_cells(i);
3105:
3106: i := i + 1;
3107: l_cells(i) := 'S:'||wf_core.translate('WF_EVENT_NAME');
3108: i := i + 1;
3109: l_cells(i) := 'S:'||nvl(l_event_t.GetEventName(),'&'||'nbsp');
3110:
3111: i := i + 1;

Line 3112: l_cells(i) := 'S:'||wf_core.translate('WF_EVENT_KEY');

3108: i := i + 1;
3109: l_cells(i) := 'S:'||nvl(l_event_t.GetEventName(),'&'||'nbsp');
3110:
3111: i := i + 1;
3112: l_cells(i) := 'S:'||wf_core.translate('WF_EVENT_KEY');
3113: i := i + 1;
3114: l_cells(i) := 'S:'||nvl(l_event_t.GetEventKey(),'&'||'nbsp');
3115:
3116: i := i + 1;

Line 3117: l_cells(i) := 'S:'||wf_core.translate('WF_TO_AGENT_NAME');

3113: i := i + 1;
3114: l_cells(i) := 'S:'||nvl(l_event_t.GetEventKey(),'&'||'nbsp');
3115:
3116: i := i + 1;
3117: l_cells(i) := 'S:'||wf_core.translate('WF_TO_AGENT_NAME');
3118: i := i + 1;
3119: l_cells(i) := 'S:'||l_to_agent;
3120: i := i + 1;
3121: l_cells(i) := 'S:'||wf_core.translate('WF_TO_AGENT_SYSTEM');

Line 3121: l_cells(i) := 'S:'||wf_core.translate('WF_TO_AGENT_SYSTEM');

3117: l_cells(i) := 'S:'||wf_core.translate('WF_TO_AGENT_NAME');
3118: i := i + 1;
3119: l_cells(i) := 'S:'||l_to_agent;
3120: i := i + 1;
3121: l_cells(i) := 'S:'||wf_core.translate('WF_TO_AGENT_SYSTEM');
3122: i := i + 1;
3123: l_cells(i) := 'S:'||l_to_system;
3124:
3125: i := i + 1;

Line 3126: l_cells(i) := 'S:'||wf_core.translate('WF_FROM_AGENT_NAME');

3122: i := i + 1;
3123: l_cells(i) := 'S:'||l_to_system;
3124:
3125: i := i + 1;
3126: l_cells(i) := 'S:'||wf_core.translate('WF_FROM_AGENT_NAME');
3127: i := i + 1;
3128: l_cells(i) := 'S:'||l_from_agent;
3129: i := i + 1;
3130: l_cells(i) := 'S:'||wf_core.translate('WF_FROM_AGENT_SYSTEM');

Line 3130: l_cells(i) := 'S:'||wf_core.translate('WF_FROM_AGENT_SYSTEM');

3126: l_cells(i) := 'S:'||wf_core.translate('WF_FROM_AGENT_NAME');
3127: i := i + 1;
3128: l_cells(i) := 'S:'||l_from_agent;
3129: i := i + 1;
3130: l_cells(i) := 'S:'||wf_core.translate('WF_FROM_AGENT_SYSTEM');
3131: i := i + 1;
3132: l_cells(i) := 'S:'||l_from_system;
3133:
3134: i := i + 1;

Line 3135: l_cells(i) := 'S:'||wf_core.translate('WF_SEND_DATE');

3131: i := i + 1;
3132: l_cells(i) := 'S:'||l_from_system;
3133:
3134: i := i + 1;
3135: l_cells(i) := 'S:'||wf_core.translate('WF_SEND_DATE');
3136: i := i + 1;
3137: l_cells(i) := 'S:'||l_send_date_text||'';
3138:
3139: i := i + 1;

Line 3140: l_cells(i) := 'S:'||wf_core.translate('WF_RECEIVE_DATE');

3136: i := i + 1;
3137: l_cells(i) := 'S:'||l_send_date_text||'';
3138:
3139: i := i + 1;
3140: l_cells(i) := 'S:'||wf_core.translate('WF_RECEIVE_DATE');
3141: i := i + 1;
3142: l_cells(i) := 'S:'||l_receive_date_text||'';
3143:
3144: i := i + 1;

Line 3145: l_cells(i) := 'S:'||wf_core.translate('WF_PRIORITY');

3141: i := i + 1;
3142: l_cells(i) := 'S:'||l_receive_date_text||'';
3143:
3144: i := i + 1;
3145: l_cells(i) := 'S:'||wf_core.translate('WF_PRIORITY');
3146: i := i + 1;
3147: l_cells(i) := 'S:'||l_priority;
3148:
3149: i := i + 1;

Line 3150: l_cells(i) := 'S:'||wf_core.translate('WF_CORRELATION');

3146: i := i + 1;
3147: l_cells(i) := 'S:'||l_priority;
3148:
3149: i := i + 1;
3150: l_cells(i) := 'S:'||wf_core.translate('WF_CORRELATION');
3151: i := i + 1;
3152: l_cells(i) := 'S:'||nvl(l_event_t.GetCorrelationId(),'&'||'nbsp');
3153:
3154: else

Line 3155: l_result := Wf_Core.Newline||rpad(wf_core.translate('WF_EVENT_HEADING'),40)

3151: i := i + 1;
3152: l_cells(i) := 'S:'||nvl(l_event_t.GetCorrelationId(),'&'||'nbsp');
3153:
3154: else
3155: l_result := Wf_Core.Newline||rpad(wf_core.translate('WF_EVENT_HEADING'),40)
3156: ||wf_core.translate('WF_VALUE')||Wf_Core.Newline;
3157:
3158: l_result := l_result||rpad(wf_core.translate('WF_EVENT_NAME'),40)||
3159: l_event_t.GetEventName()||Wf_Core.Newline||

Line 3156: ||wf_core.translate('WF_VALUE')||Wf_Core.Newline;

3152: l_cells(i) := 'S:'||nvl(l_event_t.GetCorrelationId(),'&'||'nbsp');
3153:
3154: else
3155: l_result := Wf_Core.Newline||rpad(wf_core.translate('WF_EVENT_HEADING'),40)
3156: ||wf_core.translate('WF_VALUE')||Wf_Core.Newline;
3157:
3158: l_result := l_result||rpad(wf_core.translate('WF_EVENT_NAME'),40)||
3159: l_event_t.GetEventName()||Wf_Core.Newline||
3160: rpad(wf_core.translate('WF_EVENT_KEY'),40)||

Line 3158: l_result := l_result||rpad(wf_core.translate('WF_EVENT_NAME'),40)||

3154: else
3155: l_result := Wf_Core.Newline||rpad(wf_core.translate('WF_EVENT_HEADING'),40)
3156: ||wf_core.translate('WF_VALUE')||Wf_Core.Newline;
3157:
3158: l_result := l_result||rpad(wf_core.translate('WF_EVENT_NAME'),40)||
3159: l_event_t.GetEventName()||Wf_Core.Newline||
3160: rpad(wf_core.translate('WF_EVENT_KEY'),40)||
3161: l_event_t.GetEventKey()||Wf_Core.Newline||
3162: rpad(wf_core.translate('WF_FROM_AGENT_NAME'),40)||

Line 3159: l_event_t.GetEventName()||Wf_Core.Newline||

3155: l_result := Wf_Core.Newline||rpad(wf_core.translate('WF_EVENT_HEADING'),40)
3156: ||wf_core.translate('WF_VALUE')||Wf_Core.Newline;
3157:
3158: l_result := l_result||rpad(wf_core.translate('WF_EVENT_NAME'),40)||
3159: l_event_t.GetEventName()||Wf_Core.Newline||
3160: rpad(wf_core.translate('WF_EVENT_KEY'),40)||
3161: l_event_t.GetEventKey()||Wf_Core.Newline||
3162: rpad(wf_core.translate('WF_FROM_AGENT_NAME'),40)||
3163: l_From_Agent||Wf_Core.Newline||

Line 3160: rpad(wf_core.translate('WF_EVENT_KEY'),40)||

3156: ||wf_core.translate('WF_VALUE')||Wf_Core.Newline;
3157:
3158: l_result := l_result||rpad(wf_core.translate('WF_EVENT_NAME'),40)||
3159: l_event_t.GetEventName()||Wf_Core.Newline||
3160: rpad(wf_core.translate('WF_EVENT_KEY'),40)||
3161: l_event_t.GetEventKey()||Wf_Core.Newline||
3162: rpad(wf_core.translate('WF_FROM_AGENT_NAME'),40)||
3163: l_From_Agent||Wf_Core.Newline||
3164: rpad(wf_core.translate('WF_FROM_AGENT_SYSTEM'),40)||

Line 3161: l_event_t.GetEventKey()||Wf_Core.Newline||

3157:
3158: l_result := l_result||rpad(wf_core.translate('WF_EVENT_NAME'),40)||
3159: l_event_t.GetEventName()||Wf_Core.Newline||
3160: rpad(wf_core.translate('WF_EVENT_KEY'),40)||
3161: l_event_t.GetEventKey()||Wf_Core.Newline||
3162: rpad(wf_core.translate('WF_FROM_AGENT_NAME'),40)||
3163: l_From_Agent||Wf_Core.Newline||
3164: rpad(wf_core.translate('WF_FROM_AGENT_SYSTEM'),40)||
3165: l_From_System||Wf_Core.Newline||

Line 3162: rpad(wf_core.translate('WF_FROM_AGENT_NAME'),40)||

3158: l_result := l_result||rpad(wf_core.translate('WF_EVENT_NAME'),40)||
3159: l_event_t.GetEventName()||Wf_Core.Newline||
3160: rpad(wf_core.translate('WF_EVENT_KEY'),40)||
3161: l_event_t.GetEventKey()||Wf_Core.Newline||
3162: rpad(wf_core.translate('WF_FROM_AGENT_NAME'),40)||
3163: l_From_Agent||Wf_Core.Newline||
3164: rpad(wf_core.translate('WF_FROM_AGENT_SYSTEM'),40)||
3165: l_From_System||Wf_Core.Newline||
3166: rpad(wf_core.translate('WF_TO_AGENT_NAME'),40)||

Line 3163: l_From_Agent||Wf_Core.Newline||

3159: l_event_t.GetEventName()||Wf_Core.Newline||
3160: rpad(wf_core.translate('WF_EVENT_KEY'),40)||
3161: l_event_t.GetEventKey()||Wf_Core.Newline||
3162: rpad(wf_core.translate('WF_FROM_AGENT_NAME'),40)||
3163: l_From_Agent||Wf_Core.Newline||
3164: rpad(wf_core.translate('WF_FROM_AGENT_SYSTEM'),40)||
3165: l_From_System||Wf_Core.Newline||
3166: rpad(wf_core.translate('WF_TO_AGENT_NAME'),40)||
3167: l_To_Agent||Wf_Core.Newline||

Line 3164: rpad(wf_core.translate('WF_FROM_AGENT_SYSTEM'),40)||

3160: rpad(wf_core.translate('WF_EVENT_KEY'),40)||
3161: l_event_t.GetEventKey()||Wf_Core.Newline||
3162: rpad(wf_core.translate('WF_FROM_AGENT_NAME'),40)||
3163: l_From_Agent||Wf_Core.Newline||
3164: rpad(wf_core.translate('WF_FROM_AGENT_SYSTEM'),40)||
3165: l_From_System||Wf_Core.Newline||
3166: rpad(wf_core.translate('WF_TO_AGENT_NAME'),40)||
3167: l_To_Agent||Wf_Core.Newline||
3168: rpad(wf_core.translate('WF_TO_AGENT_SYSTEM'),40)||

Line 3165: l_From_System||Wf_Core.Newline||

3161: l_event_t.GetEventKey()||Wf_Core.Newline||
3162: rpad(wf_core.translate('WF_FROM_AGENT_NAME'),40)||
3163: l_From_Agent||Wf_Core.Newline||
3164: rpad(wf_core.translate('WF_FROM_AGENT_SYSTEM'),40)||
3165: l_From_System||Wf_Core.Newline||
3166: rpad(wf_core.translate('WF_TO_AGENT_NAME'),40)||
3167: l_To_Agent||Wf_Core.Newline||
3168: rpad(wf_core.translate('WF_TO_AGENT_SYSTEM'),40)||
3169: l_To_System||Wf_Core.Newline||

Line 3166: rpad(wf_core.translate('WF_TO_AGENT_NAME'),40)||

3162: rpad(wf_core.translate('WF_FROM_AGENT_NAME'),40)||
3163: l_From_Agent||Wf_Core.Newline||
3164: rpad(wf_core.translate('WF_FROM_AGENT_SYSTEM'),40)||
3165: l_From_System||Wf_Core.Newline||
3166: rpad(wf_core.translate('WF_TO_AGENT_NAME'),40)||
3167: l_To_Agent||Wf_Core.Newline||
3168: rpad(wf_core.translate('WF_TO_AGENT_SYSTEM'),40)||
3169: l_To_System||Wf_Core.Newline||
3170: rpad(wf_core.translate('WF_PRIORITY'),40)||

Line 3167: l_To_Agent||Wf_Core.Newline||

3163: l_From_Agent||Wf_Core.Newline||
3164: rpad(wf_core.translate('WF_FROM_AGENT_SYSTEM'),40)||
3165: l_From_System||Wf_Core.Newline||
3166: rpad(wf_core.translate('WF_TO_AGENT_NAME'),40)||
3167: l_To_Agent||Wf_Core.Newline||
3168: rpad(wf_core.translate('WF_TO_AGENT_SYSTEM'),40)||
3169: l_To_System||Wf_Core.Newline||
3170: rpad(wf_core.translate('WF_PRIORITY'),40)||
3171: l_Priority||Wf_Core.Newline||

Line 3168: rpad(wf_core.translate('WF_TO_AGENT_SYSTEM'),40)||

3164: rpad(wf_core.translate('WF_FROM_AGENT_SYSTEM'),40)||
3165: l_From_System||Wf_Core.Newline||
3166: rpad(wf_core.translate('WF_TO_AGENT_NAME'),40)||
3167: l_To_Agent||Wf_Core.Newline||
3168: rpad(wf_core.translate('WF_TO_AGENT_SYSTEM'),40)||
3169: l_To_System||Wf_Core.Newline||
3170: rpad(wf_core.translate('WF_PRIORITY'),40)||
3171: l_Priority||Wf_Core.Newline||
3172: rpad(wf_core.translate('WF_SEND_DATE'),40)||

Line 3169: l_To_System||Wf_Core.Newline||

3165: l_From_System||Wf_Core.Newline||
3166: rpad(wf_core.translate('WF_TO_AGENT_NAME'),40)||
3167: l_To_Agent||Wf_Core.Newline||
3168: rpad(wf_core.translate('WF_TO_AGENT_SYSTEM'),40)||
3169: l_To_System||Wf_Core.Newline||
3170: rpad(wf_core.translate('WF_PRIORITY'),40)||
3171: l_Priority||Wf_Core.Newline||
3172: rpad(wf_core.translate('WF_SEND_DATE'),40)||
3173: l_send_date_text||Wf_Core.Newline||

Line 3170: rpad(wf_core.translate('WF_PRIORITY'),40)||

3166: rpad(wf_core.translate('WF_TO_AGENT_NAME'),40)||
3167: l_To_Agent||Wf_Core.Newline||
3168: rpad(wf_core.translate('WF_TO_AGENT_SYSTEM'),40)||
3169: l_To_System||Wf_Core.Newline||
3170: rpad(wf_core.translate('WF_PRIORITY'),40)||
3171: l_Priority||Wf_Core.Newline||
3172: rpad(wf_core.translate('WF_SEND_DATE'),40)||
3173: l_send_date_text||Wf_Core.Newline||
3174: rpad(wf_core.translate('WF_RECEIVE_DATE'),40)||

Line 3171: l_Priority||Wf_Core.Newline||

3167: l_To_Agent||Wf_Core.Newline||
3168: rpad(wf_core.translate('WF_TO_AGENT_SYSTEM'),40)||
3169: l_To_System||Wf_Core.Newline||
3170: rpad(wf_core.translate('WF_PRIORITY'),40)||
3171: l_Priority||Wf_Core.Newline||
3172: rpad(wf_core.translate('WF_SEND_DATE'),40)||
3173: l_send_date_text||Wf_Core.Newline||
3174: rpad(wf_core.translate('WF_RECEIVE_DATE'),40)||
3175: l_receive_date_text||Wf_Core.Newline||

Line 3172: rpad(wf_core.translate('WF_SEND_DATE'),40)||

3168: rpad(wf_core.translate('WF_TO_AGENT_SYSTEM'),40)||
3169: l_To_System||Wf_Core.Newline||
3170: rpad(wf_core.translate('WF_PRIORITY'),40)||
3171: l_Priority||Wf_Core.Newline||
3172: rpad(wf_core.translate('WF_SEND_DATE'),40)||
3173: l_send_date_text||Wf_Core.Newline||
3174: rpad(wf_core.translate('WF_RECEIVE_DATE'),40)||
3175: l_receive_date_text||Wf_Core.Newline||
3176: rpad(wf_core.translate('WF_CORRELATION'),40)||

Line 3173: l_send_date_text||Wf_Core.Newline||

3169: l_To_System||Wf_Core.Newline||
3170: rpad(wf_core.translate('WF_PRIORITY'),40)||
3171: l_Priority||Wf_Core.Newline||
3172: rpad(wf_core.translate('WF_SEND_DATE'),40)||
3173: l_send_date_text||Wf_Core.Newline||
3174: rpad(wf_core.translate('WF_RECEIVE_DATE'),40)||
3175: l_receive_date_text||Wf_Core.Newline||
3176: rpad(wf_core.translate('WF_CORRELATION'),40)||
3177: l_event_t.GetCorrelationId()||Wf_Core.Newline;

Line 3174: rpad(wf_core.translate('WF_RECEIVE_DATE'),40)||

3170: rpad(wf_core.translate('WF_PRIORITY'),40)||
3171: l_Priority||Wf_Core.Newline||
3172: rpad(wf_core.translate('WF_SEND_DATE'),40)||
3173: l_send_date_text||Wf_Core.Newline||
3174: rpad(wf_core.translate('WF_RECEIVE_DATE'),40)||
3175: l_receive_date_text||Wf_Core.Newline||
3176: rpad(wf_core.translate('WF_CORRELATION'),40)||
3177: l_event_t.GetCorrelationId()||Wf_Core.Newline;
3178:

Line 3175: l_receive_date_text||Wf_Core.Newline||

3171: l_Priority||Wf_Core.Newline||
3172: rpad(wf_core.translate('WF_SEND_DATE'),40)||
3173: l_send_date_text||Wf_Core.Newline||
3174: rpad(wf_core.translate('WF_RECEIVE_DATE'),40)||
3175: l_receive_date_text||Wf_Core.Newline||
3176: rpad(wf_core.translate('WF_CORRELATION'),40)||
3177: l_event_t.GetCorrelationId()||Wf_Core.Newline;
3178:
3179: end if;

Line 3176: rpad(wf_core.translate('WF_CORRELATION'),40)||

3172: rpad(wf_core.translate('WF_SEND_DATE'),40)||
3173: l_send_date_text||Wf_Core.Newline||
3174: rpad(wf_core.translate('WF_RECEIVE_DATE'),40)||
3175: l_receive_date_text||Wf_Core.Newline||
3176: rpad(wf_core.translate('WF_CORRELATION'),40)||
3177: l_event_t.GetCorrelationId()||Wf_Core.Newline;
3178:
3179: end if;
3180:

Line 3177: l_event_t.GetCorrelationId()||Wf_Core.Newline;

3173: l_send_date_text||Wf_Core.Newline||
3174: rpad(wf_core.translate('WF_RECEIVE_DATE'),40)||
3175: l_receive_date_text||Wf_Core.Newline||
3176: rpad(wf_core.translate('WF_CORRELATION'),40)||
3177: l_event_t.GetCorrelationId()||Wf_Core.Newline;
3178:
3179: end if;
3180:
3181: -- Display the Parameter List

Line 3188: l_cells(i) := 'S:'||wf_core.translate('WF_PARAMETER')||' : '||l_parmlist_t(j).getName();

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;
3191: l_cells(i) :=
3192: 'S:'||substr(nvl(l_parmlist_t(j).getValue(),'&'||'nbsp'),1,20);

Line 3194: l_result := l_result||rpad(wf_core.translate('WF_PARAMETER')

3190: i := i + 1;
3191: l_cells(i) :=
3192: 'S:'||substr(nvl(l_parmlist_t(j).getValue(),'&'||'nbsp'),1,20);
3193: else
3194: l_result := l_result||rpad(wf_core.translate('WF_PARAMETER')
3195: ||l_parmlist_t(j).getName(),40)
3196: ||substr(l_parmlist_t(j).getValue(),1,20)||Wf_Core.Newline;
3197: end if;
3198: j := l_parmlist_t.NEXT(j);

Line 3196: ||substr(l_parmlist_t(j).getValue(),1,20)||Wf_Core.Newline;

3192: 'S:'||substr(nvl(l_parmlist_t(j).getValue(),'&'||'nbsp'),1,20);
3193: else
3194: l_result := l_result||rpad(wf_core.translate('WF_PARAMETER')
3195: ||l_parmlist_t(j).getName(),40)
3196: ||substr(l_parmlist_t(j).getValue(),1,20)||Wf_Core.Newline;
3197: end if;
3198: j := l_parmlist_t.NEXT(j);
3199: end loop;
3200: end if;

Line 3210: ''||wf_core.Translate('WFITD_EVENT_DETAILS')||

3206: type => 'H',
3207: rs => l_result);
3208: -- Display title
3209: l_result := '' ||
3210: ''||'

'||wf_core.Translate('WFITD_EVENT_DETAILS')|| 3211: '

'||l_result||'

';
3212:
3213: else
3214: document_type := wf_notification.doc_text;