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.IEM_MAILPREPROCWF_PUB dependencies on WF_ENGINE

Line 52: wf_engine.CreateProcess( ItemType => itemtype,

48: l_ret1 number;
49:
50: begin
51: -- invoke an instance of workflow process
52: wf_engine.CreateProcess( ItemType => itemtype,
53: ItemKey => ItemKey,
54: process => WorkflowProcess );
55: wf_engine.SetItemAttrNumber(itemtype => itemtype,
56: itemkey => itemkey,

Line 55: wf_engine.SetItemAttrNumber(itemtype => itemtype,

51: -- invoke an instance of workflow process
52: wf_engine.CreateProcess( ItemType => itemtype,
53: ItemKey => ItemKey,
54: process => WorkflowProcess );
55: wf_engine.SetItemAttrNumber(itemtype => itemtype,
56: itemkey => itemkey,
57: aname => 'MSGID',
58: avalue => p_msgid );
59: wf_engine.SetItemAttrText (itemtype => itemtype,

Line 59: wf_engine.SetItemAttrText (itemtype => itemtype,

55: wf_engine.SetItemAttrNumber(itemtype => itemtype,
56: itemkey => itemkey,
57: aname => 'MSGID',
58: avalue => p_msgid );
59: wf_engine.SetItemAttrText (itemtype => itemtype,
60: itemkey => itemkey,
61: aname => 'USER_NAME',
62: avalue => p_username );
63: wf_engine.SetItemAttrText (itemtype => itemtype,

Line 63: wf_engine.SetItemAttrText (itemtype => itemtype,

59: wf_engine.SetItemAttrText (itemtype => itemtype,
60: itemkey => itemkey,
61: aname => 'USER_NAME',
62: avalue => p_username );
63: wf_engine.SetItemAttrText (itemtype => itemtype,
64: itemkey => itemkey,
65: aname => 'DOMAIN',
66: avalue => p_domain );
67: G_STAT:='S' ; -- Process Intialized To Success

Line 75: wf_engine.SetItemAttrNumber ( itemtype => itemtype,

71: g_outval:=null;
72:
73: IF p_sender is not null then -- Regular Processing
74:
75: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
76: itemkey => itemkey,
77: aname => 'MSG_SIZE',
78: avalue => p_msgsize);
79:

Line 80: wf_engine.SetItemAttrText (itemtype => itemtype,

76: itemkey => itemkey,
77: aname => 'MSG_SIZE',
78: avalue => p_msgsize);
79:
80: wf_engine.SetItemAttrText (itemtype => itemtype,
81: itemkey => itemkey,
82: aname => 'SENDER',
83: avalue => p_sender );
84:

Line 86: wf_engine.SetItemAttrText (itemtype => itemtype,

82: aname => 'SENDER',
83: avalue => p_sender );
84:
85:
86: wf_engine.SetItemAttrText (itemtype => itemtype,
87: itemkey => itemkey,
88: aname => 'PRIORITY',
89: avalue => p_priority );
90:

Line 91: wf_engine.SetItemAttrText (itemtype => itemtype,

87: itemkey => itemkey,
88: aname => 'PRIORITY',
89: avalue => p_priority );
90:
91: wf_engine.SetItemAttrText (itemtype => itemtype,
92: itemkey => itemkey,
93: aname => 'MSG_STATUS',
94: avalue => p_msg_status );
95: ELSE -- Processing The Retry Folder

Line 96: wf_engine.SetItemAttrNumber (itemtype => ItemType,

92: itemkey => itemkey,
93: aname => 'MSG_STATUS',
94: avalue => p_msg_status );
95: ELSE -- Processing The Retry Folder
96: wf_engine.SetItemAttrNumber (itemtype => ItemType,
97: itemkey => ItemKey,
98: aname => 'EMAILACCOUNTID',
99: avalue => p_email_account_id);
100: END IF;

Line 101: wf_engine.StartProcess(itemtype => itemtype,

97: itemkey => ItemKey,
98: aname => 'EMAILACCOUNTID',
99: avalue => p_email_account_id);
100: END IF;
101: wf_engine.StartProcess(itemtype => itemtype,
102: itemkey => itemkey );
103: x_outval:=g_outval;
104: x_process:=g_process;
105: exception

Line 133: -- step must be performed. A call to wf_engine.CompleteActivty

129: -- - DEFERED
130: -- execution should be defered to background
131: -- - NOTIFIED[::]
132: -- activity has notified an external entity that this
133: -- step must be performed. A call to wf_engine.CompleteActivty
134: -- will signal when this step is complete. Optional
135: -- return of notification ID and assigned user.
136: -- - ERROR[:]
137: -- function encountered an error.

Line 162: l_msgid := wf_engine.GetItemAttrText(

158: l_stat varchar2(10);
159: l_count number;
160: l_data varchar2(255);
161: begin
162: l_msgid := wf_engine.GetItemAttrText(
163: itemtype => ItemType,
164: itemkey => ItemKey,
165: aname => 'MSGID' );
166: select email_account_id into l_email_account_id from

Line 168: wf_engine.SetItemAttrNumber (itemtype => ItemType,

164: itemkey => ItemKey,
165: aname => 'MSGID' );
166: select email_account_id into l_email_account_id from
167: iem_rt_preproc_emails where message_id=l_msgid;
168: wf_engine.SetItemAttrNumber (itemtype => ItemType,
169: itemkey => ItemKey,
170: aname => 'EMAILACCOUNTID',
171: avalue => l_email_account_id);
172: result:='COMPLETE:T';

Line 203: -- step must be performed. A call to wf_engine.CompleteActivty

199: -- - DEFERED
200: -- execution should be defered to background
201: -- - NOTIFIED[::]
202: -- activity has notified an external entity that this
203: -- step must be performed. A call to wf_engine.CompleteActivty
204: -- will signal when this step is complete. Optional
205: -- return of notification ID and assigned user.
206: -- - ERROR[:]
207: -- function encountered an error.

Line 220: l_user := wf_engine.GetItemAttrText(

216: l_proc_name varchar2(20):='IEM_WF_CHKUSERGRP';
217: l_ret number;
218: l_msgid number;
219: begin
220: l_user := wf_engine.GetItemAttrText(
221: itemtype => ItemType,
222: itemkey => ItemKey,
223: aname => 'USER_NAME' );
224: l_msgid := wf_engine.GetItemAttrText(

Line 224: l_msgid := wf_engine.GetItemAttrText(

220: l_user := wf_engine.GetItemAttrText(
221: itemtype => ItemType,
222: itemkey => ItemKey,
223: aname => 'USER_NAME' );
224: l_msgid := wf_engine.GetItemAttrText(
225: itemtype => ItemType,
226: itemkey => ItemKey,
227: aname => 'MSGID' );
228: result:='COMPLETE:'||upper(l_user);

Line 259: -- step must be performed. A call to wf_engine.CompleteActivty

255: -- - DEFERED
256: -- execution should be defered to background
257: -- - NOTIFIED[::]
258: -- activity has notified an external entity that this
259: -- step must be performed. A call to wf_engine.CompleteActivty
260: -- will signal when this step is complete. Optional
261: -- return of notification ID and assigned user.
262: -- - ERROR[:]
263: -- function encountered an error.

Line 282: wf_engine.abortprocess(itemtype,itemkey);

278: begin
279: result:='COMPLETE:';
280: exception
281: when ext_hdr_exception then
282: wf_engine.abortprocess(itemtype,itemkey);
283: result:='COMPLETE:';
284: when others then
285: -- The line below records this function call in the error system
286: -- in the case of an exception.

Line 313: -- step must be performed. A call to wf_engine.CompleteActivty

309: -- - DEFERED
310: -- execution should be defered to background
311: -- - NOTIFIED[::]
312: -- activity has notified an external entity that this
313: -- step must be performed. A call to wf_engine.CompleteActivty
314: -- will signal when this step is complete. Optional
315: -- return of notification ID and assigned user.
316: -- - ERROR[:]
317: -- function encountered an error.

Line 344: l_msgid := wf_engine.GetItemAttrNumber(

340: l_msgid number;
341: l_errmsg varchar2(200);
342: msg_hdr_exception EXCEPTION;
343: begin
344: l_msgid := wf_engine.GetItemAttrNumber(
345: itemtype => ItemType,
346: itemkey => ItemKey,
347: aname => 'MSGID' );
348: select to_str,cc_str,from_str,reply_to_str,subject,message_size into

Line 352: wf_engine.SetItemAttrText (itemtype => ItemType,

348: select to_str,cc_str,from_str,reply_to_str,subject,message_size into
349: l_to_recip,l_cc_recip,l_frm_str,l_reply_to,l_subject,l_msg_size
350: from iem_ms_base_headers
351: where message_id=l_msgid;
352: wf_engine.SetItemAttrText (itemtype => ItemType,
353: itemkey => ItemKey,
354: aname => 'MSG_TO',
355: avalue => l_to_recip);
356: wf_engine.SetItemAttrText (itemtype => ItemType,

Line 356: wf_engine.SetItemAttrText (itemtype => ItemType,

352: wf_engine.SetItemAttrText (itemtype => ItemType,
353: itemkey => ItemKey,
354: aname => 'MSG_TO',
355: avalue => l_to_recip);
356: wf_engine.SetItemAttrText (itemtype => ItemType,
357: itemkey => ItemKey,
358: aname => 'MSG_FROM',
359: avalue => l_frm_str);
360: wf_engine.SetItemAttrText (itemtype => ItemType,

Line 360: wf_engine.SetItemAttrText (itemtype => ItemType,

356: wf_engine.SetItemAttrText (itemtype => ItemType,
357: itemkey => ItemKey,
358: aname => 'MSG_FROM',
359: avalue => l_frm_str);
360: wf_engine.SetItemAttrText (itemtype => ItemType,
361: itemkey => ItemKey,
362: aname => 'MSG_CC',
363: avalue => l_cc_recip);
364: wf_engine.SetItemAttrText (itemtype => ItemType,

Line 364: wf_engine.SetItemAttrText (itemtype => ItemType,

360: wf_engine.SetItemAttrText (itemtype => ItemType,
361: itemkey => ItemKey,
362: aname => 'MSG_CC',
363: avalue => l_cc_recip);
364: wf_engine.SetItemAttrText (itemtype => ItemType,
365: itemkey => ItemKey,
366: aname => 'SUBJECT',
367: avalue => l_subject);
368: wf_engine.SetItemAttrText (itemtype => ItemType,

Line 368: wf_engine.SetItemAttrText (itemtype => ItemType,

364: wf_engine.SetItemAttrText (itemtype => ItemType,
365: itemkey => ItemKey,
366: aname => 'SUBJECT',
367: avalue => l_subject);
368: wf_engine.SetItemAttrText (itemtype => ItemType,
369: itemkey => ItemKey,
370: aname => 'SENDER',
371: avalue => l_frm_str);
372: wf_engine.SetItemAttrText (itemtype => ItemType,

Line 372: wf_engine.SetItemAttrText (itemtype => ItemType,

368: wf_engine.SetItemAttrText (itemtype => ItemType,
369: itemkey => ItemKey,
370: aname => 'SENDER',
371: avalue => l_frm_str);
372: wf_engine.SetItemAttrText (itemtype => ItemType,
373: itemkey => ItemKey,
374: aname => 'REPLY_TO',
375: avalue => l_reply_to);
376: wf_engine.SetItemAttrNumber (itemtype => ItemType,

Line 376: wf_engine.SetItemAttrNumber (itemtype => ItemType,

372: wf_engine.SetItemAttrText (itemtype => ItemType,
373: itemkey => ItemKey,
374: aname => 'REPLY_TO',
375: avalue => l_reply_to);
376: wf_engine.SetItemAttrNumber (itemtype => ItemType,
377: itemkey => ItemKey,
378: aname => 'MSG_SIZE',
379: avalue => l_msg_size);
380: result:='COMPLETE:';

Line 386: wf_engine.abortprocess(itemtype,itemkey);

382: when msg_hdr_exception then
383: if g_flow='N' then
384: G_STAT:='E';
385: end if;
386: wf_engine.abortprocess(itemtype,itemkey);
387: result:='COMPLETE:';
388: when others then
389: -- The line below records this function call in the error system
390: -- in the case of an exception.

Line 417: -- step must be performed. A call to wf_engine.CompleteActivty

413: -- - DEFERED
414: -- execution should be defered to background
415: -- - NOTIFIED[::]
416: -- activity has notified an external entity that this
417: -- step must be performed. A call to wf_engine.CompleteActivty
418: -- will signal when this step is complete. Optional
419: -- return of notification ID and assigned user.
420: -- - ERROR[:]
421: -- function encountered an error.

Line 448: wf_engine.abortprocess(itemtype,itemkey);

444: begin
445: result:='COMPLETE:';
446: exception
447: when get_part_exception then
448: wf_engine.abortprocess(itemtype,itemkey);
449: result:='COMPLETE:';
450: when others then
451: -- The line below records this function call in the error system
452: -- in the case of an exception.

Line 479: -- step must be performed. A call to wf_engine.CompleteActivty

475: -- - DEFERED
476: -- execution should be defered to background
477: -- - NOTIFIED[::]
478: -- activity has notified an external entity that this
479: -- step must be performed. A call to wf_engine.CompleteActivty
480: -- will signal when this step is complete. Optional
481: -- return of notification ID and assigned user.
482: -- - ERROR[:]
483: -- function encountered an error.

Line 496: l_msg_id := wf_engine.GetItemAttrNumber(

492: l_proc_name varchar2(20):='IEM_WF_AUTHFAILED';
493: auth_fail_exception EXCEPTION;
494: l_msg_id number;
495: begin
496: l_msg_id := wf_engine.GetItemAttrNumber(
497: itemtype => ItemType,
498: itemkey => ItemKey,
499: aname => 'MSGID' );
500: result:='COMPLETE:';

Line 535: -- step must be performed. A call to wf_engine.CompleteActivty

531: -- - DEFERED
532: -- execution should be defered to background
533: -- - NOTIFIED[::]
534: -- activity has notified an external entity that this
535: -- step must be performed. A call to wf_engine.CompleteActivty
536: -- will signal when this step is complete. Optional
537: -- return of notification ID and assigned user.
538: -- - ERROR[:]
539: -- functioN ENCOUNTered an error.

Line 604: wf_engine.abortprocess(itemtype,itemkey);

600: begin
601: result:='COMPLETE:';
602: exception
603: when enq_exception then
604: wf_engine.abortprocess(itemtype,itemkey);
605: result:='COMPLETE:';
606: when others then
607: -- The line below records this function call in the error system
608: -- in the case of an exception.

Line 635: -- step must be performed. A call to wf_engine.CompleteActivty

631: -- - DEFERED
632: -- execution should be defered to background
633: -- - NOTIFIED[::]
634: -- activity has notified an external entity that this
635: -- step must be performed. A call to wf_engine.CompleteActivty
636: -- will signal when this step is complete. Optional
637: -- return of notification ID and assigned user.
638: -- - ERROR[:]
639: -- function encountered an error.

Line 654: l_msg_id := wf_engine.GetItemAttrNumber(

650: l_msg_id number;
651: l_str varchar2(200);
652: l_errmsg varchar2(200);
653: begin
654: l_msg_id := wf_engine.GetItemAttrNumber(
655: itemtype => ItemType,
656: itemkey => ItemKey,
657: aname => 'MSGID' );
658: l_user := wf_engine.GetItemAttrText(

Line 658: l_user := wf_engine.GetItemAttrText(

654: l_msg_id := wf_engine.GetItemAttrNumber(
655: itemtype => ItemType,
656: itemkey => ItemKey,
657: aname => 'MSGID' );
658: l_user := wf_engine.GetItemAttrText(
659: itemtype => ItemType,
660: itemkey => ItemKey,
661: aname => 'USER_NAME' );
662: result:='COMPLETE:';

Line 693: -- step must be performed. A call to wf_engine.CompleteActivty

689: -- - DEFERED
690: -- execution should be defered to background
691: -- - NOTIFIED[::]
692: -- activity has notified an external entity that this
693: -- step must be performed. A call to wf_engine.CompleteActivty
694: -- will signal when this step is complete. Optional
695: -- return of notification ID and assigned user.
696: -- - ERROR[:]
697: -- function encountered an error.

Line 729: wf_engine.abortprocess(itemtype,itemkey);

725: when struct_exception then
726: if g_flow='N' then
727: G_STAT:='E';
728: end if;
729: wf_engine.abortprocess(itemtype,itemkey);
730: result:='COMPLETE:';
731: when others then
732: -- The line below records this function call in the error system
733: -- in the case of an exception.

Line 761: -- step must be performed. A call to wf_engine.CompleteActivty

757: -- - DEFERED
758: -- execution should be defered to background
759: -- - NOTIFIED[::]
760: -- activity has notified an external entity that this
761: -- step must be performed. A call to wf_engine.CompleteActivty
762: -- will signal when this step is complete. Optional
763: -- return of notification ID and assigned user.
764: -- - ERROR[:]
765: -- function encountered an error.

Line 813: -- step must be performed. A call to wf_engine.CompleteActivty

809: -- - DEFERED
810: -- execution should be defered to background
811: -- - NOTIFIED[::]
812: -- activity has notified an external entity that this
813: -- step must be performed. A call to wf_engine.CompleteActivty
814: -- will signal when this step is complete. Optional
815: -- return of notification ID and assigned user.
816: -- - ERROR[:]
817: -- function encountered an error.

Line 865: -- step must be performed. A call to wf_engine.CompleteActivty

861: -- - DEFERED
862: -- execution should be defered to background
863: -- - NOTIFIED[::]
864: -- activity has notified an external entity that this
865: -- step must be performed. A call to wf_engine.CompleteActivty
866: -- will signal when this step is complete. Optional
867: -- return of notification ID and assigned user.
868: -- - ERROR[:]
869: -- function encountered an error.

Line 890: wf_engine.abortprocess(itemtype,itemkey);

886: begin
887: result:='COMPLETE:';
888: exception
889: when del_exception then
890: wf_engine.abortprocess(itemtype,itemkey);
891: result:='COMPLETE:';
892: when others then
893: -- The line below records this function call in the error system
894: -- in the case of an exception.

Line 921: -- step must be performed. A call to wf_engine.CompleteActivty

917: -- - DEFERED
918: -- execution should be defered to background
919: -- - NOTIFIED[::]
920: -- activity has notified an external entity that this
921: -- step must be performed. A call to wf_engine.CompleteActivty
922: -- will signal when this step is complete. Optional
923: -- return of notification ID and assigned user.
924: -- - ERROR[:]
925: -- function encountered an error.

Line 973: -- step must be performed. A call to wf_engine.CompleteActivty

969: -- - DEFERED
970: -- execution should be defered to background
971: -- - NOTIFIED[::]
972: -- activity has notified an external entity that this
973: -- step must be performed. A call to wf_engine.CompleteActivty
974: -- will signal when this step is complete. Optional
975: -- return of notification ID and assigned user.
976: -- - ERROR[:]
977: -- function encountered an error.

Line 1025: -- step must be performed. A call to wf_engine.CompleteActivty

1021: -- - DEFERED
1022: -- execution should be defered to background
1023: -- - NOTIFIED[::]
1024: -- activity has notified an external entity that this
1025: -- step must be performed. A call to wf_engine.CompleteActivty
1026: -- will signal when this step is complete. Optional
1027: -- return of notification ID and assigned user.
1028: -- - ERROR[:]
1029: -- function encountered an error.

Line 1080: -- step must be performed. A call to wf_engine.CompleteActivty

1076: -- - DEFERED
1077: -- execution should be defered to background
1078: -- - NOTIFIED[::]
1079: -- activity has notified an external entity that this
1080: -- step must be performed. A call to wf_engine.CompleteActivty
1081: -- will signal when this step is complete. Optional
1082: -- return of notification ID and assigned user.
1083: -- - ERROR[:]
1084: -- function encountered an error.

Line 1126: -- step must be performed. A call to wf_engine.CompleteActivty

1122: -- - DEFERED
1123: -- execution should be defered to background
1124: -- - NOTIFIED[::]
1125: -- activity has notified an external entity that this
1126: -- step must be performed. A call to wf_engine.CompleteActivty
1127: -- will signal when this step is complete. Optional
1128: -- return of notification ID and assigned user.
1129: -- - ERROR[:]
1130: -- function encountered an error.

Line 1232: -- step must be performed. A call to wf_engine.CompleteActivty

1228: -- - DEFERED
1229: -- execution should be defered to background
1230: -- - NOTIFIED[::]
1231: -- activity has notified an external entity that this
1232: -- step must be performed. A call to wf_engine.CompleteActivty
1233: -- will signal when this step is complete. Optional
1234: -- return of notification ID and assigned user.
1235: -- - ERROR[:]
1236: -- function encountered an error.

Line 1288: -- step must be performed. A call to wf_engine.CompleteActivty

1284: -- - DEFERED
1285: -- execution should be defered to background
1286: -- - NOTIFIED[::]
1287: -- activity has notified an external entity that this
1288: -- step must be performed. A call to wf_engine.CompleteActivty
1289: -- will signal when this step is complete. Optional
1290: -- return of notification ID and assigned user.
1291: -- - ERROR[:]
1292: -- function encountered an error.

Line 1341: -- step must be performed. A call to wf_engine.CompleteActivty

1337: -- - DEFERED
1338: -- execution should be defered to background
1339: -- - NOTIFIED[::]
1340: -- activity has notified an external entity that this
1341: -- step must be performed. A call to wf_engine.CompleteActivty
1342: -- will signal when this step is complete. Optional
1343: -- return of notification ID and assigned user.
1344: -- - ERROR[:]
1345: -- function encountered an error.

Line 1398: -- step must be performed. A call to wf_engine.CompleteActivty

1394: -- - DEFERED
1395: -- execution should be defered to background
1396: -- - NOTIFIED[::]
1397: -- activity has notified an external entity that this
1398: -- step must be performed. A call to wf_engine.CompleteActivty
1399: -- will signal when this step is complete. Optional
1400: -- return of notification ID and assigned user.
1401: -- - ERROR[:]
1402: -- function encountered an error.

Line 1438: -- step must be performed. A call to wf_engine.CompleteActivty

1434: -- - DEFERED
1435: -- execution should be defered to background
1436: -- - NOTIFIED[::]
1437: -- activity has notified an external entity that this
1438: -- step must be performed. A call to wf_engine.CompleteActivty
1439: -- will signal when this step is complete. Optional
1440: -- return of notification ID and assigned user.
1441: -- - ERROR[:]
1442: -- function encountered an error.