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_ENGINE_UTIL dependencies on WF_CORE

Line 61: Wf_Core.Context('Wf_Engine_Util', 'ClearCache');

57: wf_engine_util.app_itemkey := '';
58: wf_engine_util.app_level := '';
59: exception
60: when others then
61: Wf_Core.Context('Wf_Engine_Util', 'ClearCache');
62: raise;
63: end ClearCache;
64:
65: --

Line 97: Wf_Core.Token('ITEMTYPE', itemtype);

93: if (itemkey = wf_engine.eng_synch) then
94: if ((not rootflag) and
95: ((nvl(wf_engine_util.app_itemtype, 'x') <> itemtype) or
96: (nvl(wf_engine_util.app_itemkey, 'x') <> itemkey))) then
97: Wf_Core.Token('ITEMTYPE', itemtype);
98: Wf_Core.Token('ITEMKEY', itemkey);
99: Wf_Core.Raise('WFENG_SYNCH_ITEM');
100: end if;
101: end if;

Line 98: Wf_Core.Token('ITEMKEY', itemkey);

94: if ((not rootflag) and
95: ((nvl(wf_engine_util.app_itemtype, 'x') <> itemtype) or
96: (nvl(wf_engine_util.app_itemkey, 'x') <> itemkey))) then
97: Wf_Core.Token('ITEMTYPE', itemtype);
98: Wf_Core.Token('ITEMKEY', itemkey);
99: Wf_Core.Raise('WFENG_SYNCH_ITEM');
100: end if;
101: end if;
102:

Line 99: Wf_Core.Raise('WFENG_SYNCH_ITEM');

95: ((nvl(wf_engine_util.app_itemtype, 'x') <> itemtype) or
96: (nvl(wf_engine_util.app_itemkey, 'x') <> itemkey))) then
97: Wf_Core.Token('ITEMTYPE', itemtype);
98: Wf_Core.Token('ITEMKEY', itemkey);
99: Wf_Core.Raise('WFENG_SYNCH_ITEM');
100: end if;
101: end if;
102:
103: -- If this is the root process, OR this is a different item,

Line 120: Wf_Core.Context('Wf_Engine_Util', 'AddProcessStack',

116: wf_engine_util.app_parent_name(wf_engine_util.app_level) := act_name;
117: wf_engine_util.app_parent_id(wf_engine_util.app_level) := actid;
118: exception
119: when others then
120: Wf_Core.Context('Wf_Engine_Util', 'AddProcessStack',
121: itemtype, itemkey, act_itemtype, act_name, to_char(actid));
122: raise;
123: end AddProcessStack;
124:

Line 152: Wf_Core.Context('Wf_Engine_Util', 'RemoveProcessStack', itemtype,

148: end if;
149: end if;
150: exception
151: when others then
152: Wf_Core.Context('Wf_Engine_Util', 'RemoveProcessStack', itemtype,
153: itemkey, to_char(actid));
154: raise;
155: end RemoveProcessStack;
156:

Line 213: Wf_Core.Token('ITEMTYPE', itemtype);

209:
210: -- SYNCHMODE: If we don't have a match in the cache, then some restricted
211: -- activity must have happened. Raise an error.
212: if (itemkey = wf_engine.eng_synch) then
213: Wf_Core.Token('ITEMTYPE', itemtype);
214: Wf_Core.Token('ITEMKEY', itemkey);
215: Wf_Core.Raise('WFENG_SYNCH_ITEM');
216: end if;
217:

Line 214: Wf_Core.Token('ITEMKEY', itemkey);

210: -- SYNCHMODE: If we don't have a match in the cache, then some restricted
211: -- activity must have happened. Raise an error.
212: if (itemkey = wf_engine.eng_synch) then
213: Wf_Core.Token('ITEMTYPE', itemtype);
214: Wf_Core.Token('ITEMKEY', itemkey);
215: Wf_Core.Raise('WFENG_SYNCH_ITEM');
216: end if;
217:
218: -- If no match was found, then either

Line 215: Wf_Core.Raise('WFENG_SYNCH_ITEM');

211: -- activity must have happened. Raise an error.
212: if (itemkey = wf_engine.eng_synch) then
213: Wf_Core.Token('ITEMTYPE', itemtype);
214: Wf_Core.Token('ITEMKEY', itemkey);
215: Wf_Core.Raise('WFENG_SYNCH_ITEM');
216: end if;
217:
218: -- If no match was found, then either
219: -- 1. Activity has a different parent process name

Line 253: Wf_Core.Context('Wf_Engine_Util', 'Activity_Parent_Process',

249:
250: return parentid;
251: exception
252: when no_data_found then
253: Wf_Core.Context('Wf_Engine_Util', 'Activity_Parent_Process',
254: to_char(actid));
255: Wf_Core.Token('ITEMTYPE', itemtype);
256: Wf_Core.Token('ITEMKEY', itemkey);
257: Wf_Core.Token('CHILDPROCESS', to_char(actid));

Line 255: Wf_Core.Token('ITEMTYPE', itemtype);

251: exception
252: when no_data_found then
253: Wf_Core.Context('Wf_Engine_Util', 'Activity_Parent_Process',
254: to_char(actid));
255: Wf_Core.Token('ITEMTYPE', itemtype);
256: Wf_Core.Token('ITEMKEY', itemkey);
257: Wf_Core.Token('CHILDPROCESS', to_char(actid));
258: Wf_Core.Token('FUNCTION', 'Activity_Parent_Process');
259: Wf_Core.Raise('WFSQL_INTERNAL');

Line 256: Wf_Core.Token('ITEMKEY', itemkey);

252: when no_data_found then
253: Wf_Core.Context('Wf_Engine_Util', 'Activity_Parent_Process',
254: to_char(actid));
255: Wf_Core.Token('ITEMTYPE', itemtype);
256: Wf_Core.Token('ITEMKEY', itemkey);
257: Wf_Core.Token('CHILDPROCESS', to_char(actid));
258: Wf_Core.Token('FUNCTION', 'Activity_Parent_Process');
259: Wf_Core.Raise('WFSQL_INTERNAL');
260: when others then

Line 257: Wf_Core.Token('CHILDPROCESS', to_char(actid));

253: Wf_Core.Context('Wf_Engine_Util', 'Activity_Parent_Process',
254: to_char(actid));
255: Wf_Core.Token('ITEMTYPE', itemtype);
256: Wf_Core.Token('ITEMKEY', itemkey);
257: Wf_Core.Token('CHILDPROCESS', to_char(actid));
258: Wf_Core.Token('FUNCTION', 'Activity_Parent_Process');
259: Wf_Core.Raise('WFSQL_INTERNAL');
260: when others then
261: Wf_Core.Context('Wf_Engine_Util', 'Activity_Parent_Process',

Line 258: Wf_Core.Token('FUNCTION', 'Activity_Parent_Process');

254: to_char(actid));
255: Wf_Core.Token('ITEMTYPE', itemtype);
256: Wf_Core.Token('ITEMKEY', itemkey);
257: Wf_Core.Token('CHILDPROCESS', to_char(actid));
258: Wf_Core.Token('FUNCTION', 'Activity_Parent_Process');
259: Wf_Core.Raise('WFSQL_INTERNAL');
260: when others then
261: Wf_Core.Context('Wf_Engine_Util', 'Activity_Parent_Process',
262: to_char(actid));

Line 259: Wf_Core.Raise('WFSQL_INTERNAL');

255: Wf_Core.Token('ITEMTYPE', itemtype);
256: Wf_Core.Token('ITEMKEY', itemkey);
257: Wf_Core.Token('CHILDPROCESS', to_char(actid));
258: Wf_Core.Token('FUNCTION', 'Activity_Parent_Process');
259: Wf_Core.Raise('WFSQL_INTERNAL');
260: when others then
261: Wf_Core.Context('Wf_Engine_Util', 'Activity_Parent_Process',
262: to_char(actid));
263: raise;

Line 261: Wf_Core.Context('Wf_Engine_Util', 'Activity_Parent_Process',

257: Wf_Core.Token('CHILDPROCESS', to_char(actid));
258: Wf_Core.Token('FUNCTION', 'Activity_Parent_Process');
259: Wf_Core.Raise('WFSQL_INTERNAL');
260: when others then
261: Wf_Core.Context('Wf_Engine_Util', 'Activity_Parent_Process',
262: to_char(actid));
263: raise;
264:
265: end activity_parent_process;

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

548:
549: -- SYNCHMODE: Check for branching.
550: -- If more than one transition out, this is an illegal branch point.
551: if ((itemkey = wf_engine.eng_synch) and (i > 1)) then
552: Wf_Core.Token('ACTID', to_char(actid));
553: Wf_Core.Token('RESULT', lresult);
554: Wf_Core.Raise('WFENG_SYNCH_BRANCH');
555: end if;
556:

Line 553: Wf_Core.Token('RESULT', lresult);

549: -- SYNCHMODE: Check for branching.
550: -- If more than one transition out, this is an illegal branch point.
551: if ((itemkey = wf_engine.eng_synch) and (i > 1)) then
552: Wf_Core.Token('ACTID', to_char(actid));
553: Wf_Core.Token('RESULT', lresult);
554: Wf_Core.Raise('WFENG_SYNCH_BRANCH');
555: end if;
556:
557: i := 0;

Line 554: Wf_Core.Raise('WFENG_SYNCH_BRANCH');

550: -- If more than one transition out, this is an illegal branch point.
551: if ((itemkey = wf_engine.eng_synch) and (i > 1)) then
552: Wf_Core.Token('ACTID', to_char(actid));
553: Wf_Core.Token('RESULT', lresult);
554: Wf_Core.Raise('WFENG_SYNCH_BRANCH');
555: end if;
556:
557: i := 0;
558: -- While loop to hande the next transition activities.

Line 568: Wf_Core.Context('Wf_Engine_Util', 'Complete_Activity', itemtype, itemkey,

564: end loop;
565:
566: exception
567: when others then
568: Wf_Core.Context('Wf_Engine_Util', 'Complete_Activity', itemtype, itemkey,
569: actid, result);
570: raise;
571: end complete_activity;
572:

Line 644: Wf_Core.Token('TYPE', itemtype);

640: -- Check if the item exists and also get back the root process name
641: -- and version
642: Wf_Item.Root_Process(itemtype, itemkey, process, version);
643: if (process is null) then
644: Wf_Core.Token('TYPE', itemtype);
645: Wf_Core.Token('KEY', itemkey);
646: Wf_Core.Raise('WFENG_ITEM');
647: end if;
648:

Line 645: Wf_Core.Token('KEY', itemkey);

641: -- and version
642: Wf_Item.Root_Process(itemtype, itemkey, process, version);
643: if (process is null) then
644: Wf_Core.Token('TYPE', itemtype);
645: Wf_Core.Token('KEY', itemkey);
646: Wf_Core.Raise('WFENG_ITEM');
647: end if;
648:
649: -- Insert a row for the process into WIAS table.

Line 646: Wf_Core.Raise('WFENG_ITEM');

642: Wf_Item.Root_Process(itemtype, itemkey, process, version);
643: if (process is null) then
644: Wf_Core.Token('TYPE', itemtype);
645: Wf_Core.Token('KEY', itemkey);
646: Wf_Core.Raise('WFENG_ITEM');
647: end if;
648:
649: -- Insert a row for the process into WIAS table.
650: -- Get the id of the process root.

Line 654: Wf_Core.Token('TYPE', itemtype);

650: -- Get the id of the process root.
651: processid := Wf_Process_Activity.RootInstanceId(itemtype, itemkey,
652: process);
653: if (processid is null) then
654: Wf_Core.Token('TYPE', itemtype);
655: Wf_Core.Token('NAME', process);
656: Wf_Core.Raise('WFENG_PROCESS_RUNNABLE');
657: end if;
658:

Line 655: Wf_Core.Token('NAME', process);

651: processid := Wf_Process_Activity.RootInstanceId(itemtype, itemkey,
652: process);
653: if (processid is null) then
654: Wf_Core.Token('TYPE', itemtype);
655: Wf_Core.Token('NAME', process);
656: Wf_Core.Raise('WFENG_PROCESS_RUNNABLE');
657: end if;
658:
659: Wf_Item_Activity_Status.Create_Status(itemtype, itemkey, processid,

Line 656: Wf_Core.Raise('WFENG_PROCESS_RUNNABLE');

652: process);
653: if (processid is null) then
654: Wf_Core.Token('TYPE', itemtype);
655: Wf_Core.Token('NAME', process);
656: Wf_Core.Raise('WFENG_PROCESS_RUNNABLE');
657: end if;
658:
659: Wf_Item_Activity_Status.Create_Status(itemtype, itemkey, processid,
660: wf_engine.eng_active, wf_engine.eng_null, SYSDATE, null,

Line 801: Wf_Core.Token('ACTID', process);

797:
798: -- SYNCHMODE: Only 1 starter allowed in synch processes
799: if ((itemkey = wf_engine.eng_synch) and
800: (i > 1)) then
801: Wf_Core.Token('ACTID', process);
802: Wf_Core.Token('RESULT', 'START');
803: Wf_Core.Raise('WFENG_SYNCH_BRANCH');
804: end if;
805:

Line 802: Wf_Core.Token('RESULT', 'START');

798: -- SYNCHMODE: Only 1 starter allowed in synch processes
799: if ((itemkey = wf_engine.eng_synch) and
800: (i > 1)) then
801: Wf_Core.Token('ACTID', process);
802: Wf_Core.Token('RESULT', 'START');
803: Wf_Core.Raise('WFENG_SYNCH_BRANCH');
804: end if;
805:
806: -- SS: Process all 'true' start activities of this process.

Line 803: Wf_Core.Raise('WFENG_SYNCH_BRANCH');

799: if ((itemkey = wf_engine.eng_synch) and
800: (i > 1)) then
801: Wf_Core.Token('ACTID', process);
802: Wf_Core.Token('RESULT', 'START');
803: Wf_Core.Raise('WFENG_SYNCH_BRANCH');
804: end if;
805:
806: -- SS: Process all 'true' start activities of this process.
807: -- 'True' start activities are those which are marked as starts,

Line 855: Wf_Core.Context('Wf_Engine', 'Start_Process_Internal', itemtype, itemkey);

851: -- 2. set this activity to error status
852: -- 3. execute the error process (if any)
853: -- 4. clear the error to continue with next activity
854: rollback to wf_savepoint;
855: Wf_Core.Context('Wf_Engine', 'Start_Process_Internal', itemtype, itemkey);
856: Wf_Item_Activity_Status.Set_Error(itemtype, itemkey, processid,
857: wf_engine.eng_exception, FALSE);
858: Wf_Engine_Util.Execute_Error_Process(itemtype, itemkey, processid,
859: wf_engine.eng_exception);

Line 860: Wf_Core.Clear;

856: Wf_Item_Activity_Status.Set_Error(itemtype, itemkey, processid,
857: wf_engine.eng_exception, FALSE);
858: Wf_Engine_Util.Execute_Error_Process(itemtype, itemkey, processid,
859: wf_engine.eng_exception);
860: Wf_Core.Clear;
861: return;
862: end;
863: end if;
864: end if;

Line 870: Wf_Core.Token('PROCESS', process);

866: end loop;
867:
868: -- Report an error if no start activities can be found.
869: if (i = 0) then
870: Wf_Core.Token('PROCESS', process);
871: Wf_Core.Raise('WFENG_NO_START');
872: end if;
873:
874: exception

Line 871: Wf_Core.Raise('WFENG_NO_START');

867:
868: -- Report an error if no start activities can be found.
869: if (i = 0) then
870: Wf_Core.Token('PROCESS', process);
871: Wf_Core.Raise('WFENG_NO_START');
872: end if;
873:
874: exception
875: when others then

Line 879: (wf_core.error_name is null or wf_core.error_name <> 'WFENG_SYNCH_ITEM') and

875: when others then
876: -- Bug 4117740
877: -- Call clearcache() when #SYNCH flow is in error
878: if ((itemkey = WF_ENGINE.eng_synch) and
879: (wf_core.error_name is null or wf_core.error_name <> 'WFENG_SYNCH_ITEM') and
880: (not WF_ENGINE.debug)) then
881: Wf_Item.ClearCache;
882: end if;
883:

Line 884: Wf_Core.Context('Wf_Engine_Util', 'Start_Process_Internal',

880: (not WF_ENGINE.debug)) then
881: Wf_Item.ClearCache;
882: end if;
883:
884: Wf_Core.Context('Wf_Engine_Util', 'Start_Process_Internal',
885: itemtype, itemkey);
886: raise;
887: end Start_Process_Internal;
888:

Line 978: Wf_Core.Token('ITEM_TYPE', itemtype);

974: wf_engine.eng_deferred)) then
975: -- NOTE: This should never happened because the engine will never
976: -- set the status of a process to be 'WAITING' or 'NOTIFIED'
977: -- return;
978: Wf_Core.Token('ITEM_TYPE', itemtype);
979: Wf_Core.Token('ITEM_KEY', itemkey);
980: Wf_Core.Token('PROCESS', to_char(actid));
981: Wf_Core.Token('STATUS', status);
982: Wf_Core.Raise('WFSQL_INTERNAL');

Line 979: Wf_Core.Token('ITEM_KEY', itemkey);

975: -- NOTE: This should never happened because the engine will never
976: -- set the status of a process to be 'WAITING' or 'NOTIFIED'
977: -- return;
978: Wf_Core.Token('ITEM_TYPE', itemtype);
979: Wf_Core.Token('ITEM_KEY', itemkey);
980: Wf_Core.Token('PROCESS', to_char(actid));
981: Wf_Core.Token('STATUS', status);
982: Wf_Core.Raise('WFSQL_INTERNAL');
983: end if;

Line 980: Wf_Core.Token('PROCESS', to_char(actid));

976: -- set the status of a process to be 'WAITING' or 'NOTIFIED'
977: -- return;
978: Wf_Core.Token('ITEM_TYPE', itemtype);
979: Wf_Core.Token('ITEM_KEY', itemkey);
980: Wf_Core.Token('PROCESS', to_char(actid));
981: Wf_Core.Token('STATUS', status);
982: Wf_Core.Raise('WFSQL_INTERNAL');
983: end if;
984: end if;

Line 981: Wf_Core.Token('STATUS', status);

977: -- return;
978: Wf_Core.Token('ITEM_TYPE', itemtype);
979: Wf_Core.Token('ITEM_KEY', itemkey);
980: Wf_Core.Token('PROCESS', to_char(actid));
981: Wf_Core.Token('STATUS', status);
982: Wf_Core.Raise('WFSQL_INTERNAL');
983: end if;
984: end if;
985:

Line 982: Wf_Core.Raise('WFSQL_INTERNAL');

978: Wf_Core.Token('ITEM_TYPE', itemtype);
979: Wf_Core.Token('ITEM_KEY', itemkey);
980: Wf_Core.Token('PROCESS', to_char(actid));
981: Wf_Core.Token('STATUS', status);
982: Wf_Core.Raise('WFSQL_INTERNAL');
983: end if;
984: end if;
985:
986: -- If we came here, that means the parent process is ACTIVE

Line 1032: Wf_Core.Token('ITEM_TYPE', itemtype);

1028: (acttype <> wf_engine.eng_process))then
1029: -- Only the process type of activity can have a 'SUSPENDED' status
1030: -- If this is not a process type activity, then THIS IS A PROBLEM
1031: -- CAN NOT DO ANYTHING
1032: Wf_Core.Token('ITEM_TYPE', itemtype);
1033: Wf_Core.Token('ITEM_KEY', itemkey);
1034: Wf_Core.Token('ACTIVITY_TYPE', acttype);
1035: Wf_Core.Token('STATUS', status);
1036: Wf_Core.Raise('WFSQL_INTERNAL');

Line 1033: Wf_Core.Token('ITEM_KEY', itemkey);

1029: -- Only the process type of activity can have a 'SUSPENDED' status
1030: -- If this is not a process type activity, then THIS IS A PROBLEM
1031: -- CAN NOT DO ANYTHING
1032: Wf_Core.Token('ITEM_TYPE', itemtype);
1033: Wf_Core.Token('ITEM_KEY', itemkey);
1034: Wf_Core.Token('ACTIVITY_TYPE', acttype);
1035: Wf_Core.Token('STATUS', status);
1036: Wf_Core.Raise('WFSQL_INTERNAL');
1037: end if;

Line 1034: Wf_Core.Token('ACTIVITY_TYPE', acttype);

1030: -- If this is not a process type activity, then THIS IS A PROBLEM
1031: -- CAN NOT DO ANYTHING
1032: Wf_Core.Token('ITEM_TYPE', itemtype);
1033: Wf_Core.Token('ITEM_KEY', itemkey);
1034: Wf_Core.Token('ACTIVITY_TYPE', acttype);
1035: Wf_Core.Token('STATUS', status);
1036: Wf_Core.Raise('WFSQL_INTERNAL');
1037: end if;
1038: end if;

Line 1035: Wf_Core.Token('STATUS', status);

1031: -- CAN NOT DO ANYTHING
1032: Wf_Core.Token('ITEM_TYPE', itemtype);
1033: Wf_Core.Token('ITEM_KEY', itemkey);
1034: Wf_Core.Token('ACTIVITY_TYPE', acttype);
1035: Wf_Core.Token('STATUS', status);
1036: Wf_Core.Raise('WFSQL_INTERNAL');
1037: end if;
1038: end if;
1039: end if;

Line 1036: Wf_Core.Raise('WFSQL_INTERNAL');

1032: Wf_Core.Token('ITEM_TYPE', itemtype);
1033: Wf_Core.Token('ITEM_KEY', itemkey);
1034: Wf_Core.Token('ACTIVITY_TYPE', acttype);
1035: Wf_Core.Token('STATUS', status);
1036: Wf_Core.Raise('WFSQL_INTERNAL');
1037: end if;
1038: end if;
1039: end if;
1040:

Line 1084: Wf_Core.Token('ACTID', act_name);

1080: childarr(i) := '';
1081:
1082: -- SYNCHMODE: Only one starter allowed in synch process
1083: if ((itemkey = wf_engine.eng_synch) and (i > 1)) then
1084: Wf_Core.Token('ACTID', act_name);
1085: Wf_Core.Token('RESULT', 'START');
1086: Wf_Core.Raise('WFENG_SYNCH_BRANCH');
1087: end if;
1088:

Line 1085: Wf_Core.Token('RESULT', 'START');

1081:
1082: -- SYNCHMODE: Only one starter allowed in synch process
1083: if ((itemkey = wf_engine.eng_synch) and (i > 1)) then
1084: Wf_Core.Token('ACTID', act_name);
1085: Wf_Core.Token('RESULT', 'START');
1086: Wf_Core.Raise('WFENG_SYNCH_BRANCH');
1087: end if;
1088:
1089: -- While loop to handle all the start activities

Line 1086: Wf_Core.Raise('WFENG_SYNCH_BRANCH');

1082: -- SYNCHMODE: Only one starter allowed in synch process
1083: if ((itemkey = wf_engine.eng_synch) and (i > 1)) then
1084: Wf_Core.Token('ACTID', act_name);
1085: Wf_Core.Token('RESULT', 'START');
1086: Wf_Core.Raise('WFENG_SYNCH_BRANCH');
1087: end if;
1088:
1089: -- While loop to handle all the start activities
1090: i := 0;

Line 1124: Wf_Core.Context('Wf_Engine_Util', 'Process_Activity', itemtype, itemkey,

1120:
1121: return;
1122: exception
1123: when others then
1124: Wf_Core.Context('Wf_Engine_Util', 'Process_Activity', itemtype, itemkey,
1125: to_char(actid), to_char(threshold));
1126: raise;
1127: end process_activity;
1128:

Line 1354: Wf_Core.Context('Wf_Engine_Util', 'Reset_Activities', itemtype, itemkey,

1350: end if;
1351: --
1352: exception
1353: when others then
1354: Wf_Core.Context('Wf_Engine_Util', 'Reset_Activities', itemtype, itemkey,
1355: to_char(actid));
1356: raise;
1357: end reset_activities;
1358:

Line 1577: Wf_Core.Context('Wf_Engine_Util', 'Reset_Tree', itemtype, itemkey,

1573: -- Goal not found anywhere.
1574: return(FALSE);
1575: exception
1576: when others then
1577: Wf_Core.Context('Wf_Engine_Util', 'Reset_Tree', itemtype, itemkey,
1578: to_char(rootid), to_char(goalid), to_char(actdate));
1579: raise;
1580: end Reset_Tree;
1581:

Line 1697: Wf_Core.Context('Wf_Engine_Util', 'Move_To_History', itemtype, itemkey,

1693: Wf_Item_Activity_Status.Delete_Status(itemtype, itemkey, actid);
1694:
1695: EXCEPTION
1696: when OTHERS then
1697: Wf_Core.Context('Wf_Engine_Util', 'Move_To_History', itemtype, itemkey,
1698: to_char(actid));
1699: raise;
1700:
1701: END move_to_history;

Line 1733: Wf_Core.Token('TYPE', itemtype);

1729:
1730: if (acttype = wf_engine.eng_function) then
1731: funcname := Wf_Activity.Activity_Function(itemtype, itemkey, actid);
1732: if (funcname is null) then
1733: Wf_Core.Token('TYPE', itemtype);
1734: Wf_Core.Token('NAME', to_char(actid));
1735: Wf_Core.Raise('WFENG_ACTIVITY_FUNCTION');
1736: end if;
1737: end if;

Line 1734: Wf_Core.Token('NAME', to_char(actid));

1730: if (acttype = wf_engine.eng_function) then
1731: funcname := Wf_Activity.Activity_Function(itemtype, itemkey, actid);
1732: if (funcname is null) then
1733: Wf_Core.Token('TYPE', itemtype);
1734: Wf_Core.Token('NAME', to_char(actid));
1735: Wf_Core.Raise('WFENG_ACTIVITY_FUNCTION');
1736: end if;
1737: end if;
1738:

Line 1735: Wf_Core.Raise('WFENG_ACTIVITY_FUNCTION');

1731: funcname := Wf_Activity.Activity_Function(itemtype, itemkey, actid);
1732: if (funcname is null) then
1733: Wf_Core.Token('TYPE', itemtype);
1734: Wf_Core.Token('NAME', to_char(actid));
1735: Wf_Core.Raise('WFENG_ACTIVITY_FUNCTION');
1736: end if;
1737: end if;
1738:
1739: -- Execute the activity function

Line 1740: Wf_Core.Clear;

1736: end if;
1737: end if;
1738:
1739: -- Execute the activity function
1740: Wf_Core.Clear;
1741: begin
1742: if (acttype = wf_engine.eng_notification) then
1743: Wf_Engine_Util.Notification(itemtype, itemkey, actid, funmode, result);
1744: elsif (acttype = wf_engine.eng_function) then

Line 1751: Wf_Core.Token('ITEM_TYPE', itemtype);

1747: elsif (acttype = wf_engine.eng_event) then
1748: Wf_Engine_Util.Event_Activity(itemtype, itemkey, actid, funmode, result);
1749: else
1750: -- Bad activity type, don't know how to execute.
1751: Wf_Core.Token('ITEM_TYPE', itemtype);
1752: Wf_Core.Token('ITEM_KEY', itemkey);
1753: Wf_Core.Token('ACTIVITY_ID', to_char(actid));
1754: Wf_Core.Token('ACTIVITY_TYPE', acttype);
1755: Wf_Core.Raise('WFSQL_INTERNAL');

Line 1752: Wf_Core.Token('ITEM_KEY', itemkey);

1748: Wf_Engine_Util.Event_Activity(itemtype, itemkey, actid, funmode, result);
1749: else
1750: -- Bad activity type, don't know how to execute.
1751: Wf_Core.Token('ITEM_TYPE', itemtype);
1752: Wf_Core.Token('ITEM_KEY', itemkey);
1753: Wf_Core.Token('ACTIVITY_ID', to_char(actid));
1754: Wf_Core.Token('ACTIVITY_TYPE', acttype);
1755: Wf_Core.Raise('WFSQL_INTERNAL');
1756: end if;

Line 1753: Wf_Core.Token('ACTIVITY_ID', to_char(actid));

1749: else
1750: -- Bad activity type, don't know how to execute.
1751: Wf_Core.Token('ITEM_TYPE', itemtype);
1752: Wf_Core.Token('ITEM_KEY', itemkey);
1753: Wf_Core.Token('ACTIVITY_ID', to_char(actid));
1754: Wf_Core.Token('ACTIVITY_TYPE', acttype);
1755: Wf_Core.Raise('WFSQL_INTERNAL');
1756: end if;
1757: exception

Line 1754: Wf_Core.Token('ACTIVITY_TYPE', acttype);

1750: -- Bad activity type, don't know how to execute.
1751: Wf_Core.Token('ITEM_TYPE', itemtype);
1752: Wf_Core.Token('ITEM_KEY', itemkey);
1753: Wf_Core.Token('ACTIVITY_ID', to_char(actid));
1754: Wf_Core.Token('ACTIVITY_TYPE', acttype);
1755: Wf_Core.Raise('WFSQL_INTERNAL');
1756: end if;
1757: exception
1758: when others then

Line 1755: Wf_Core.Raise('WFSQL_INTERNAL');

1751: Wf_Core.Token('ITEM_TYPE', itemtype);
1752: Wf_Core.Token('ITEM_KEY', itemkey);
1753: Wf_Core.Token('ACTIVITY_ID', to_char(actid));
1754: Wf_Core.Token('ACTIVITY_TYPE', acttype);
1755: Wf_Core.Raise('WFSQL_INTERNAL');
1756: end if;
1757: exception
1758: when others then
1759: if (itemkey = wf_engine.eng_synch) then

Line 1868: Wf_Core.Context('Wf_Engine_Util', 'Execute_Activity', itemtype, itemkey,

1864: end if;
1865:
1866: exception
1867: when others then
1868: Wf_Core.Context('Wf_Engine_Util', 'Execute_Activity', itemtype, itemkey,
1869: to_char(actid), funmode);
1870: raise;
1871: end execute_activity;
1872:

Line 1964: Wf_Core.Clear;

1960: wf_engine.eng_setctx);
1961: end if;
1962: end if;
1963:
1964: Wf_Core.Clear;
1965:
1966: temp := '012345678901234567890123456789012345678901234567890123456789'||
1967: '012345678901234567890123456789012345678901234567890123456789';
1968:

Line 2044: Wf_Core.Token('FUNCTION', funname);

2040: raise;
2041: end;
2042: exception
2043: when NO_SAVEPOINT then
2044: Wf_Core.Token('FUNCTION', funname);
2045: Wf_Core.Token('ACTIVITY', Wf_Engine.GetActivityLabel(actid));
2046: Wf_Core.Raise('WFENG_COMMIT_INSIDE');
2047: end;
2048:

Line 2045: Wf_Core.Token('ACTIVITY', Wf_Engine.GetActivityLabel(actid));

2041: end;
2042: exception
2043: when NO_SAVEPOINT then
2044: Wf_Core.Token('FUNCTION', funname);
2045: Wf_Core.Token('ACTIVITY', Wf_Engine.GetActivityLabel(actid));
2046: Wf_Core.Raise('WFENG_COMMIT_INSIDE');
2047: end;
2048:
2049: exception

Line 2046: Wf_Core.Raise('WFENG_COMMIT_INSIDE');

2042: exception
2043: when NO_SAVEPOINT then
2044: Wf_Core.Token('FUNCTION', funname);
2045: Wf_Core.Token('ACTIVITY', Wf_Engine.GetActivityLabel(actid));
2046: Wf_Core.Raise('WFENG_COMMIT_INSIDE');
2047: end;
2048:
2049: exception
2050: when OTHERS then

Line 2054: Wf_Core.Context('Wf_Engine_Util', 'Function_Call', funname, itemtype,

2050: when OTHERS then
2051: wf_engine.setctx_itemtype := '';
2052: wf_engine.setctx_itemkey := '';
2053: result := wf_engine.eng_error;
2054: Wf_Core.Context('Wf_Engine_Util', 'Function_Call', funname, itemtype,
2055: itemkey, to_char(actid), funmode);
2056: raise;
2057: end function_call;
2058:

Line 2097: Wf_Core.Token('TYPE', itemtype);

2093: end if;
2094:
2095: exception
2096: when no_data_found then
2097: Wf_Core.Token('TYPE', itemtype);
2098: Wf_Core.Raise('WFENG_ITEM_TYPE');
2099: end;
2100:
2101: -- If no selector found, then nothing to do

Line 2098: Wf_Core.Raise('WFENG_ITEM_TYPE');

2094:
2095: exception
2096: when no_data_found then
2097: Wf_Core.Token('TYPE', itemtype);
2098: Wf_Core.Raise('WFENG_ITEM_TYPE');
2099: end;
2100:
2101: -- If no selector found, then nothing to do
2102: if (WF_CACHE.ItemTypes(witIND).WF_SELECTOR is null) then

Line 2133: Wf_Core.Context('Wf_Engine_Util', 'Execute_Selector_Function',

2129: return(null);
2130: end if;
2131: exception
2132: when others then
2133: Wf_Core.Context('Wf_Engine_Util', 'Execute_Selector_Function',
2134: itemtype, itemkey, runmode);
2135: raise;
2136: end Execute_Selector_Function;
2137:

Line 2238: Wf_Core.Context('Wf_Engine_Util', 'Get_Root_Process', itemtype, itemkey,

2234:
2235: return(root);
2236: exception
2237: when others then
2238: Wf_Core.Context('Wf_Engine_Util', 'Get_Root_Process', itemtype, itemkey,
2239: activity);
2240: raise;
2241: end Get_Root_Process;
2242:

Line 2299: Wf_Core.Context('Wf_Engine_Util', 'Process_kill_childprocess', itemtype, itemkey);

2295: end loop;
2296: */
2297: exception
2298: when others then
2299: Wf_Core.Context('Wf_Engine_Util', 'Process_kill_childprocess', itemtype, itemkey);
2300: raise;
2301: end Process_kill_childprocess;
2302:
2303: --

Line 2411: Wf_Core.Context('Wf_Engine_Util', 'Process_Kill_Children', itemtype,

2407: end loop;
2408:
2409: exception
2410: when others then
2411: Wf_Core.Context('Wf_Engine_Util', 'Process_Kill_Children', itemtype,
2412: itemkey, to_char(processid));
2413: raise;
2414:
2415: end process_kill_children;

Line 2480: Wf_Core.Context('Wf_Engine_Util', 'Suspend_Child_Processes', itemtype,

2476: end loop;
2477:
2478: exception
2479: when others then
2480: Wf_Core.Context('Wf_Engine_Util', 'Suspend_Child_Processes', itemtype,
2481: itemkey, to_char(processid));
2482: raise;
2483: end suspend_child_processes;
2484:

Line 2544: Wf_Core.Context('Wf_Engine_Util', 'Resume_Child_Processes', itemtype,

2540: end loop;
2541:
2542: exception
2543: when others then
2544: Wf_Core.Context('Wf_Engine_Util', 'Resume_Child_Processes', itemtype,
2545: itemkey, to_char(processid));
2546: raise;
2547: end resume_child_processes;
2548:

Line 2575: Wf_Core.Token('OPERATION', 'Wf_Engine.Notification');

2571: expand_role varchar2(1);
2572: begin
2573: -- SYNCHMODE: Not allowed
2574: if (itemkey = wf_engine.eng_synch) then
2575: Wf_Core.Token('OPERATION', 'Wf_Engine.Notification');
2576: Wf_Core.Raise('WFENG_SYNCH_DISABLED');
2577: end if;
2578:
2579: -- Get the message, perform role, and timeout

Line 2576: Wf_Core.Raise('WFENG_SYNCH_DISABLED');

2572: begin
2573: -- SYNCHMODE: Not allowed
2574: if (itemkey = wf_engine.eng_synch) then
2575: Wf_Core.Token('OPERATION', 'Wf_Engine.Notification');
2576: Wf_Core.Raise('WFENG_SYNCH_DISABLED');
2577: end if;
2578:
2579: -- Get the message, perform role, and timeout
2580: -- msg and prole could came back as null since they are nullable columns

Line 2590: wf_core.context('Wf_Engine_Util', 'Notification', itemtype, itemkey,

2586: prole, expand_role, result);
2587:
2588: exception
2589: when others then
2590: wf_core.context('Wf_Engine_Util', 'Notification', itemtype, itemkey,
2591: to_char(actid), funcmode);
2592: raise;
2593: end Notification;
2594:

Line 2627: Wf_Core.Token('TYPE', itemtype);

2623: dummy pls_integer;
2624: performer varchar2(320);
2625: begin
2626: if (msg is null) then
2627: Wf_Core.Token('TYPE', itemtype);
2628: Wf_Core.Token('ACTID', to_char(actid));
2629: Wf_Core.Raise('WFENG_NOTIFICATION_MESSAGE');
2630: end if;
2631:

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

2624: performer varchar2(320);
2625: begin
2626: if (msg is null) then
2627: Wf_Core.Token('TYPE', itemtype);
2628: Wf_Core.Token('ACTID', to_char(actid));
2629: Wf_Core.Raise('WFENG_NOTIFICATION_MESSAGE');
2630: end if;
2631:
2632: if (prole is null) then

Line 2629: Wf_Core.Raise('WFENG_NOTIFICATION_MESSAGE');

2625: begin
2626: if (msg is null) then
2627: Wf_Core.Token('TYPE', itemtype);
2628: Wf_Core.Token('ACTID', to_char(actid));
2629: Wf_Core.Raise('WFENG_NOTIFICATION_MESSAGE');
2630: end if;
2631:
2632: if (prole is null) then
2633: Wf_Core.Token('TYPE', itemtype);

Line 2633: Wf_Core.Token('TYPE', itemtype);

2629: Wf_Core.Raise('WFENG_NOTIFICATION_MESSAGE');
2630: end if;
2631:
2632: if (prole is null) then
2633: Wf_Core.Token('TYPE', itemtype);
2634: Wf_Core.Token('ACTID', to_char(actid));
2635: Wf_Core.Raise('WFENG_NOTIFICATION_PERFORMER');
2636: end if;
2637:

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

2630: end if;
2631:
2632: if (prole is null) then
2633: Wf_Core.Token('TYPE', itemtype);
2634: Wf_Core.Token('ACTID', to_char(actid));
2635: Wf_Core.Raise('WFENG_NOTIFICATION_PERFORMER');
2636: end if;
2637:
2638: /* Bug 2156047 */

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

2631:
2632: if (prole is null) then
2633: Wf_Core.Token('TYPE', itemtype);
2634: Wf_Core.Token('ACTID', to_char(actid));
2635: Wf_Core.Raise('WFENG_NOTIFICATION_PERFORMER');
2636: end if;
2637:
2638: /* Bug 2156047 */
2639: -- clear global variables to store context info

Line 2656: if (wf_core.error_name = 'WFENG_ACTIVITY_ATTR') then

2652: priority := Wf_Engine.GetActivityAttrNumber(itemtype, itemkey, actid,
2653: wf_engine.eng_priority, ignore_notfound=>TRUE);
2654: exception
2655: when others then
2656: if (wf_core.error_name = 'WFENG_ACTIVITY_ATTR') then
2657: -- If no priority attr default to null
2658: priority := '';
2659: Wf_Core.Clear;
2660: else

Line 2659: Wf_Core.Clear;

2655: when others then
2656: if (wf_core.error_name = 'WFENG_ACTIVITY_ATTR') then
2657: -- If no priority attr default to null
2658: priority := '';
2659: Wf_Core.Clear;
2660: else
2661: raise;
2662: end if;
2663: end;

Line 2717: Wf_Core.Context('Wf_Engine_Util', 'Notification_Send', itemtype, itemkey,

2713: Wf_Engine.g_text := performer;
2714:
2715: exception
2716: when others then
2717: Wf_Core.Context('Wf_Engine_Util', 'Notification_Send', itemtype, itemkey,
2718: to_char(actid), msgtype||':'||msg);
2719: raise;
2720: end Notification_Send;
2721:

Line 2746: wf_core.random,

2742: group_id,
2743: MESSAGE_TYPE, MESSAGE_NAME,
2744: RECIPIENT_ROLE, ORIGINAL_RECIPIENT,
2745: STATUS,
2746: wf_core.random,
2747: MAIL_STATUS, PRIORITY,
2748: BEGIN_DATE, END_DATE, DUE_DATE,
2749: USER_COMMENT,CALLBACK,
2750: CONTEXT

Line 2783: wf_core.random,

2779: nid, gid,
2780: ntf_row.MESSAGE_TYPE, ntf_row.MESSAGE_NAME,
2781: ntf_row.RECIPIENT_ROLE, ntf_row.ORIGINAL_RECIPIENT,
2782: ntf_row.STATUS,
2783: wf_core.random,
2784: ntf_row.MAIL_STATUS, ntf_row.PRIORITY,
2785: ntf_row.BEGIN_DATE, ntf_row.END_DATE, ntf_row.DUE_DATE,
2786: ntf_row.USER_COMMENT,ntf_row.CALLBACK,
2787: replace(ntf_row.CONTEXT,':'||old_itemkey||':',':'||new_itemkey||':'));

Line 2850: Wf_Core.Context('Wf_Engine_Util', 'Notification_Copy');

2846: nid:=gid;
2847:
2848: exception
2849: when others then
2850: Wf_Core.Context('Wf_Engine_Util', 'Notification_Copy');
2851: raise;
2852: end notification_copy;
2853:
2854: --Notification_refresh (PRIVATE)

Line 2923: Wf_Core.Context('Wf_Engine_Util', 'Notification_refresh');

2919:
2920:
2921: exception
2922: when others then
2923: Wf_Core.Context('Wf_Engine_Util', 'Notification_refresh');
2924: raise;
2925: end notification_refresh;
2926:
2927:

Line 2973: Wf_Core.Token('TYPE', itemtype);

2969: --
2970: Wf_Item.Root_Process(itemtype, itemkey, root, version);
2971: rootid := Wf_Process_Activity.RootInstanceId(itemtype, itemkey, root);
2972: if (rootid is null) then
2973: Wf_Core.Token('TYPE', itemtype);
2974: Wf_Core.Token('KEY', itemkey);
2975: Wf_Core.Token('NAME', root);
2976: Wf_Core.Raise('WFENG_ITEM_ROOT');
2977: end if;

Line 2974: Wf_Core.Token('KEY', itemkey);

2970: Wf_Item.Root_Process(itemtype, itemkey, root, version);
2971: rootid := Wf_Process_Activity.RootInstanceId(itemtype, itemkey, root);
2972: if (rootid is null) then
2973: Wf_Core.Token('TYPE', itemtype);
2974: Wf_Core.Token('KEY', itemkey);
2975: Wf_Core.Token('NAME', root);
2976: Wf_Core.Raise('WFENG_ITEM_ROOT');
2977: end if;
2978:

Line 2975: Wf_Core.Token('NAME', root);

2971: rootid := Wf_Process_Activity.RootInstanceId(itemtype, itemkey, root);
2972: if (rootid is null) then
2973: Wf_Core.Token('TYPE', itemtype);
2974: Wf_Core.Token('KEY', itemkey);
2975: Wf_Core.Token('NAME', root);
2976: Wf_Core.Raise('WFENG_ITEM_ROOT');
2977: end if;
2978:
2979: erractid := actid;

Line 2976: Wf_Core.Raise('WFENG_ITEM_ROOT');

2972: if (rootid is null) then
2973: Wf_Core.Token('TYPE', itemtype);
2974: Wf_Core.Token('KEY', itemkey);
2975: Wf_Core.Token('NAME', root);
2976: Wf_Core.Raise('WFENG_ITEM_ROOT');
2977: end if;
2978:
2979: erractid := actid;
2980:

Line 3004: if (( wf_core.translate('WF_HANDLEERRORS') <> 'N')

3000:
3001: --For eliminating potential infinite loop now if
3002: --there is a scenario of the default error processing
3003: --erroring out due to some reason
3004: if (( wf_core.translate('WF_HANDLEERRORS') <> 'N')
3005: AND (itemtype <> 'WFERROR')) then
3006: --Set the error process and type to DEFAULT_ERROR
3007: errortype := 'WFERROR';
3008: errorprocess := 'DEFAULT_ERROR';

Line 3035: ( x_agent => wf_core.translate('WF_WEB_AGENT'),

3031: errname, errmsg, errstack);
3032:
3033: -- look up the monitor URL
3034: err_url := WF_MONITOR.GetEnvelopeURL
3035: ( x_agent => wf_core.translate('WF_WEB_AGENT'),
3036: x_item_type => itemtype,
3037: x_item_key => itemkey,
3038: x_admin_mode => 'YES');
3039: -- look up the user key

Line 3076: Wf_Core.Clear;

3072: -- If an error is raised in error process, do NOT raise another exception.
3073: -- Append the new error to the original error in WIAS error columns,
3074: -- then clear and ignore the exception.
3075: Wf_Item_Activity_Status.Set_Error(itemtype, itemkey, actid, '', TRUE);
3076: Wf_Core.Clear;
3077: end Execute_Error_Process;
3078:
3079: --
3080: -- SetErrorItemAttr (PRIVATE)

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

3100: Wf_Engine.SetItemAttrNumber(error_type, error_key, item_attr, to_number(avalue));
3101: end if;
3102: exception
3103: when others then
3104: if (wf_core.error_name = 'WFENG_ITEM_ATTR') then
3105: if (attrtype = 'TEXT') then
3106: Wf_Engine.AddItemAttr(error_type, error_key, item_attr, avalue);
3107: WF_CORE.Clear;
3108: else

Line 3107: WF_CORE.Clear;

3103: when others then
3104: if (wf_core.error_name = 'WFENG_ITEM_ATTR') then
3105: if (attrtype = 'TEXT') then
3106: Wf_Engine.AddItemAttr(error_type, error_key, item_attr, avalue);
3107: WF_CORE.Clear;
3108: else
3109: Wf_Engine.AddItemAttr(error_type, error_key, item_attr, '',
3110: to_number(avalue));
3111: WF_CORE.Clear;

Line 3111: WF_CORE.Clear;

3107: WF_CORE.Clear;
3108: else
3109: Wf_Engine.AddItemAttr(error_type, error_key, item_attr, '',
3110: to_number(avalue));
3111: WF_CORE.Clear;
3112: end if;
3113: else
3114: raise;
3115: end if;

Line 3239: Wf_Core.Context('Wf_Engine_Util', 'Execute_Post_NTF_Function', itemtype,

3235: end if;
3236: return;
3237: exception
3238: when others then
3239: Wf_Core.Context('Wf_Engine_Util', 'Execute_Post_NTF_Function', itemtype,
3240: itemkey, to_char(actid), funmode);
3241: raise;
3242: end Execute_Post_NTF_Function;
3243:

Line 3308: Wf_Core.Token('ERRCODE', errcode);

3304: -- the originating function will fail.
3305: if (substr(result, 1, length(wf_engine.eng_error)) =
3306: wf_engine.eng_error) then
3307: errcode := substr(result, length(wf_engine.eng_error)+2, 2000);
3308: Wf_Core.Token('ERRCODE', errcode);
3309: Wf_Core.Raise('WFENG_NOTIFICATION_FUNCTION');
3310: end if;
3311:
3312: -- Clear global context areas

Line 3309: Wf_Core.Raise('WFENG_NOTIFICATION_FUNCTION');

3305: if (substr(result, 1, length(wf_engine.eng_error)) =
3306: wf_engine.eng_error) then
3307: errcode := substr(result, length(wf_engine.eng_error)+2, 2000);
3308: Wf_Core.Token('ERRCODE', errcode);
3309: Wf_Core.Raise('WFENG_NOTIFICATION_FUNCTION');
3310: end if;
3311:
3312: -- Clear global context areas
3313: Wf_Engine.context_nid := '';

Line 3343: Wf_Core.Context('Wf_Engine_Util', 'Execute_Notification_Callback',

3339: wf_engine.context_more_info_role := '';
3340: wf_engine.context_user_key := '';
3341: wf_engine.context_proxy := '';
3342:
3343: Wf_Core.Context('Wf_Engine_Util', 'Execute_Notification_Callback',
3344: funcmode, itemtype, itemkey, to_char(actid),
3345: to_char(ctx_nid)||':'||ctx_text);
3346: raise;
3347: end Execute_Notification_Callback;

Line 3361: Wf_Core.Token('ACTID', nvl(actid, 'NULL'));

3357:
3358: begin
3359: -- Check Arguments
3360: if (actid is null) then
3361: Wf_Core.Token('ACTID', nvl(actid, 'NULL'));
3362: Wf_Core.Raise('WFSQL_ARGS');
3363: end if;
3364: -- Check value_type flag for possible item_attribute ref.
3365: WF_CACHE.GetActivityAttrValue(actid, '#TIMEOUT', status, waavIND);

Line 3362: Wf_Core.Raise('WFSQL_ARGS');

3358: begin
3359: -- Check Arguments
3360: if (actid is null) then
3361: Wf_Core.Token('ACTID', nvl(actid, 'NULL'));
3362: Wf_Core.Raise('WFSQL_ARGS');
3363: end if;
3364: -- Check value_type flag for possible item_attribute ref.
3365: WF_CACHE.GetActivityAttrValue(actid, '#TIMEOUT', status, waavIND);
3366:

Line 3495: Wf_Core.Token('#EVENTNAME', '');

3491: -- #EVENTNAME
3492: evtname := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid,
3493: wf_engine.eng_eventname);
3494: if (evtname is null) then
3495: Wf_Core.Token('#EVENTNAME', '');
3496: Wf_Core.Raise('WFSQL_ARGS');
3497: end if;
3498: -- #EVENTKEY
3499: evtkey := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid,

Line 3496: Wf_Core.Raise('WFSQL_ARGS');

3492: evtname := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid,
3493: wf_engine.eng_eventname);
3494: if (evtname is null) then
3495: Wf_Core.Token('#EVENTNAME', '');
3496: Wf_Core.Raise('WFSQL_ARGS');
3497: end if;
3498: -- #EVENTKEY
3499: evtkey := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid,
3500: wf_engine.eng_eventkey);

Line 3502: Wf_Core.Token('#EVENTKEY', '');

3498: -- #EVENTKEY
3499: evtkey := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid,
3500: wf_engine.eng_eventkey);
3501: if (evtkey is null) then
3502: Wf_Core.Token('#EVENTKEY', '');
3503: Wf_Core.Raise('WFSQL_ARGS');
3504: end if;
3505:
3506: -- #EVENTMESSAGE (may be null)

Line 3503: Wf_Core.Raise('WFSQL_ARGS');

3499: evtkey := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid,
3500: wf_engine.eng_eventkey);
3501: if (evtkey is null) then
3502: Wf_Core.Token('#EVENTKEY', '');
3503: Wf_Core.Raise('WFSQL_ARGS');
3504: end if;
3505:
3506: -- #EVENTMESSAGE (may be null)
3507: msgdata := Wf_Engine.GetActivityAttrClob(itemtype, itemkey, actid,

Line 3521: if (wf_core.error_name ='WFENG_ACTIVITY_ATTR') then

3517: exception
3518: when others then
3519: --If this atrribute does not exist the exception is
3520: --raised we just ignore it.
3521: if (wf_core.error_name ='WFENG_ACTIVITY_ATTR') then
3522: --we will initialise the event here so that the
3523: --parameterlist is usable down the line
3524: wf_event_t.initialize(evtmsg);
3525: --clear the error stack

Line 3526: wf_core.clear;

3522: --we will initialise the event here so that the
3523: --parameterlist is usable down the line
3524: wf_event_t.initialize(evtmsg);
3525: --clear the error stack
3526: wf_core.clear;
3527: else
3528: --Any other error raise it
3529: raise;
3530: end if;

Line 3566: actid, attr.name),wf_core.canonical_number_mask);

3562:
3563: -- NUMBER Value
3564: if (atype = 'NUMBER') then
3565: avalue:= to_char(wf_engine.GetActivityAttrNumber(itemtype,itemkey,
3566: actid, attr.name),wf_core.canonical_number_mask);
3567:
3568: -- DATE Value
3569: elsif (atype = 'DATE') then
3570: avalue:=to_char(wf_engine.GetActivityAttrDate(itemtype,itemkey,

Line 3571: actid, attr.name),nvl(aformat,wf_core.canonical_date_mask));

3567:
3568: -- DATE Value
3569: elsif (atype = 'DATE') then
3570: avalue:=to_char(wf_engine.GetActivityAttrDate(itemtype,itemkey,
3571: actid, attr.name),nvl(aformat,wf_core.canonical_date_mask));
3572:
3573: -- TEXT/LOOKUP/ROLE/ATTR etc Value
3574: else
3575: avalue:=substr(wf_engine.GetActivityAttrText(itemtype,itemkey,

Line 3615: Wf_Core.Token('#EVENTMESSAGE', '');

3611: -- #EVENTMESSAGE
3612: evtmsg := Wf_Engine.GetActivityAttrEvent(itemtype, itemkey, actid,
3613: Wf_Engine.eng_eventmessage);
3614: if (evtmsg is null) then
3615: Wf_Core.Token('#EVENTMESSAGE', '');
3616: Wf_Core.Raise('WFSQL_ARGS');
3617: end if;
3618:
3619: -- Initialize the variables here

Line 3616: Wf_Core.Raise('WFSQL_ARGS');

3612: evtmsg := Wf_Engine.GetActivityAttrEvent(itemtype, itemkey, actid,
3613: Wf_Engine.eng_eventmessage);
3614: if (evtmsg is null) then
3615: Wf_Core.Token('#EVENTMESSAGE', '');
3616: Wf_Core.Raise('WFSQL_ARGS');
3617: end if;
3618:
3619: -- Initialize the variables here
3620: outagent := wf_agent_t(NULL, NULL); -- Out agent override (send)

Line 3650: Wf_Core.Token('#EVENTOUTAGENT', attr);

3646: if (attr is not null) then
3647: -- Value must be in format @
3648: atsign := instr(attr, '@');
3649: if (atsign is null) then
3650: Wf_Core.Token('#EVENTOUTAGENT', attr);
3651: Wf_Core.Raise('WFSQL_ARGS');
3652: end if;
3653: outagent.setname(substr(attr, 1, atsign-1));
3654: outagent.setsystem(substr(attr, atsign+1));

Line 3651: Wf_Core.Raise('WFSQL_ARGS');

3647: -- Value must be in format @
3648: atsign := instr(attr, '@');
3649: if (atsign is null) then
3650: Wf_Core.Token('#EVENTOUTAGENT', attr);
3651: Wf_Core.Raise('WFSQL_ARGS');
3652: end if;
3653: outagent.setname(substr(attr, 1, atsign-1));
3654: outagent.setsystem(substr(attr, atsign+1));
3655: evtmsg.SetFromAgent(outagent);

Line 3665: Wf_Core.Token('#EVENTTOAGENT', attr);

3661: if (attr is not null) then
3662: -- Value must be in format @
3663: atsign := instr(attr, '@');
3664: if (atsign is null) then
3665: Wf_Core.Token('#EVENTTOAGENT', attr);
3666: Wf_Core.Raise('WFSQL_ARGS');
3667: end if;
3668: toagent.setname(substr(attr, 1, atsign-1));
3669: toagent.setsystem(substr(attr, atsign+1));

Line 3666: Wf_Core.Raise('WFSQL_ARGS');

3662: -- Value must be in format @
3663: atsign := instr(attr, '@');
3664: if (atsign is null) then
3665: Wf_Core.Token('#EVENTTOAGENT', attr);
3666: Wf_Core.Raise('WFSQL_ARGS');
3667: end if;
3668: toagent.setname(substr(attr, 1, atsign-1));
3669: toagent.setsystem(substr(attr, atsign+1));
3670: evtmsg.SetToAgent(toagent);

Line 3682: if (wf_core.error_name = 'WFENG_ACTIVITY_ATTR') then

3678: evtmsg.SetPriority(priority);
3679: end if;
3680: exception
3681: when others then
3682: if (wf_core.error_name = 'WFENG_ACTIVITY_ATTR') then
3683: -- Ignore if priority attr not found
3684: Wf_Core.Clear;
3685: else
3686: raise;

Line 3684: Wf_Core.Clear;

3680: exception
3681: when others then
3682: if (wf_core.error_name = 'WFENG_ACTIVITY_ATTR') then
3683: -- Ignore if priority attr not found
3684: Wf_Core.Clear;
3685: else
3686: raise;
3687: end if;
3688: end;

Line 3739: wf_core.canonical_number_mask);

3735:
3736: if (atype = 'NUMBER') then
3737: avalue := to_char(wf_engine.GetActivityAttrNumber(
3738: itemtype,itemkey,actid, attr.name),
3739: wf_core.canonical_number_mask);
3740:
3741: elsif (atype = 'DATE') then
3742: avalue := to_char(wf_engine.GetActivityAttrDate(
3743: itemtype,itemkey,actid, attr.name),

Line 3744: nvl(aformat,wf_core.canonical_date_mask));

3740:
3741: elsif (atype = 'DATE') then
3742: avalue := to_char(wf_engine.GetActivityAttrDate(
3743: itemtype,itemkey,actid, attr.name),
3744: nvl(aformat,wf_core.canonical_date_mask));
3745:
3746: else
3747: avalue := substr(wf_engine.GetActivityAttrText(
3748: itemtype,itemkey,actid, attr.name),1,2000);

Line 3797: if (wf_core.Translate('WF_INSTALL')='EMBEDDED') then

3793:
3794: -- Send event
3795: Wf_Event.Send(p_event => evtmsg);
3796:
3797: if (wf_core.Translate('WF_INSTALL')='EMBEDDED') then
3798: ECX_ERRORLOG.Outbound_Log (p_event => evtmsg);
3799: end if;
3800:
3801: -- Checking for reserved attribute to store msgid.

Line 3810: if (WF_CORE.error_name = 'WFENG_ACTIVITY_ATTR') then

3806: rawtohex(WF_EVENT.g_msgID));
3807:
3808: exception
3809: when others then
3810: if (WF_CORE.error_name = 'WFENG_ACTIVITY_ATTR') then
3811: null; --If the activity attribute is not setup by the ItemType
3812: --developer, we will do nothing.
3813: else
3814: raise; --Some other problem has occured.

Line 3821: Wf_Core.Token('ITEMTYPE', itemtype);

3817: end;
3818:
3819: else
3820: -- Unrecognized event direction, raise error
3821: Wf_Core.Token('ITEMTYPE', itemtype);
3822: Wf_Core.Token('ITEMKEY', itemkey);
3823: Wf_Core.Token('ACTID', to_char(actid));
3824: Wf_Core.Token('DIRECTION', direction);
3825: Wf_Core.Raise('WFSQL_INTERNAL');

Line 3822: Wf_Core.Token('ITEMKEY', itemkey);

3818:
3819: else
3820: -- Unrecognized event direction, raise error
3821: Wf_Core.Token('ITEMTYPE', itemtype);
3822: Wf_Core.Token('ITEMKEY', itemkey);
3823: Wf_Core.Token('ACTID', to_char(actid));
3824: Wf_Core.Token('DIRECTION', direction);
3825: Wf_Core.Raise('WFSQL_INTERNAL');
3826: end if;

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

3819: else
3820: -- Unrecognized event direction, raise error
3821: Wf_Core.Token('ITEMTYPE', itemtype);
3822: Wf_Core.Token('ITEMKEY', itemkey);
3823: Wf_Core.Token('ACTID', to_char(actid));
3824: Wf_Core.Token('DIRECTION', direction);
3825: Wf_Core.Raise('WFSQL_INTERNAL');
3826: end if;
3827:

Line 3824: Wf_Core.Token('DIRECTION', direction);

3820: -- Unrecognized event direction, raise error
3821: Wf_Core.Token('ITEMTYPE', itemtype);
3822: Wf_Core.Token('ITEMKEY', itemkey);
3823: Wf_Core.Token('ACTID', to_char(actid));
3824: Wf_Core.Token('DIRECTION', direction);
3825: Wf_Core.Raise('WFSQL_INTERNAL');
3826: end if;
3827:
3828:

Line 3825: Wf_Core.Raise('WFSQL_INTERNAL');

3821: Wf_Core.Token('ITEMTYPE', itemtype);
3822: Wf_Core.Token('ITEMKEY', itemkey);
3823: Wf_Core.Token('ACTID', to_char(actid));
3824: Wf_Core.Token('DIRECTION', direction);
3825: Wf_Core.Raise('WFSQL_INTERNAL');
3826: end if;
3827:
3828:
3829: --If block mode is set to 'Y'then the activity status is

Line 3841: Wf_Core.Context('Wf_Engine_Util', 'Event_Activity', itemtype,

3837: end if;
3838:
3839: exception
3840: when others then
3841: Wf_Core.Context('Wf_Engine_Util', 'Event_Activity', itemtype,
3842: itemkey, to_char(actid), funcmode);
3843: raise;
3844: end Event_Activity;
3845: