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

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

22: -- - DEFERED
23: -- execution should be defered to background
24: -- - NOTIFIED[::]
25: -- activity has notified an external entity that this
26: -- step must be performed. A call to wf_engine.CompleteActivty
27: -- will signal when this step is complete. Optional
28: -- return of notification ID and assigned user.
29: -- - ERROR[:]
30: -- function encountered an error.

Line 143: i_event := Wf_Engine.GetItemAttrEvent(itemtype,

139: );
140:
141: /* Fetch the Workflow Event Attribute */
142:
143: i_event := Wf_Engine.GetItemAttrEvent(itemtype,
144: itemkey,
145: 'ECX_EVENT_MESSAGE');
146:
147: i_to_agent_name := 'ECX_OUTBOUND';

Line 182: wf_engine.SetItemAttrEvent(itemtype, itemkey, 'ECX_EVENT_MESSAGE', i_event);

178: i_event.addParameterToList('ITEM_TYPE', itemtype);
179: i_event.addParameterToList('ITEM_KEY', itemkey);
180:
181: -- set the event data back
182: wf_engine.SetItemAttrEvent(itemtype, itemkey, 'ECX_EVENT_MESSAGE', i_event);
183:
184: resultout := 'COMPLETE:';
185:
186: EXCEPTION

Line 419: l_run_wf_in_background CONSTANT WF_ENGINE.THRESHOLD%TYPE := -1;

415: /* make sure that process runs with background engine
416: to prevent SAVEPOINT/ROLLBACK error (see Workflow FAQ)
417: the value to use for this is -1 */
418:
419: l_run_wf_in_background CONSTANT WF_ENGINE.THRESHOLD%TYPE := -1;
420: l_WorkflowProcess VARCHAR2(30);
421: l_count NUMBER;
422: l_errname VARCHAR2(200);
423: l_errmsg VARCHAR2(200);

Line 431: WF_ENGINE.CREATEPROCESS (itemtype => l_itemtype,

427: l_itemtype := 'GRDCRBLD';
428: l_itemkey := to_char(p_item_no)||'-'||to_char(sysdate,'dd-MON-yyyy HH24:mi:ss');
429: l_WorkflowProcess := 'GRDCRBLD_PROCESS';
430: /* create the process */
431: WF_ENGINE.CREATEPROCESS (itemtype => l_itemtype,
432: itemkey => l_itemkey,
433: process => l_WorkflowProcess) ;
434:
435: /* make sure that process runs with background engine */

Line 436: WF_ENGINE.THRESHOLD := l_run_wf_in_background ;

432: itemkey => l_itemkey,
433: process => l_WorkflowProcess) ;
434:
435: /* make sure that process runs with background engine */
436: WF_ENGINE.THRESHOLD := l_run_wf_in_background ;
437:
438: /*Call the GR_DISPATCH_HISTORY_PVT.GET_ORGANIZATION_CODE to populate the ORGN_NAME */
439: GR_DISPATCH_HISTORY_PVT.GET_ORGANIZATION_CODE(p_orgn_id, l_orgn_name);
440:

Line 442: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,

438: /*Call the GR_DISPATCH_HISTORY_PVT.GET_ORGANIZATION_CODE to populate the ORGN_NAME */
439: GR_DISPATCH_HISTORY_PVT.GET_ORGANIZATION_CODE(p_orgn_id, l_orgn_name);
440:
441: /* set the item attributes */
442: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,
443: itemkey => l_itemkey,
444: aname => 'TRNS_TYPE_GRRRO_GRIIO',
445: avalue => 'GRRRO');
446:

Line 447: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,

443: itemkey => l_itemkey,
444: aname => 'TRNS_TYPE_GRRRO_GRIIO',
445: avalue => 'GRRRO');
446:
447: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,
448: itemkey => l_itemkey,
449: aname => 'ORGANIZATION_ID',
450: avalue => p_orgn_id);
451:

Line 452: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,

448: itemkey => l_itemkey,
449: aname => 'ORGANIZATION_ID',
450: avalue => p_orgn_id);
451:
452: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,
453: itemkey => l_itemkey,
454: aname => 'ORGN_NAME',
455: avalue => l_orgn_name);
456:

Line 457: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,

453: itemkey => l_itemkey,
454: aname => 'ORGN_NAME',
455: avalue => l_orgn_name);
456:
457: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,
458: itemkey => l_itemkey,
459: aname => 'ITEM_NO',
460: avalue => p_item_no);
461:

Line 462: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,

458: itemkey => l_itemkey,
459: aname => 'ITEM_NO',
460: avalue => p_item_no);
461:
462: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,
463: itemkey => l_itemkey,
464: aname => 'ITEM_DESC',
465: avalue => p_item_desc);
466:

Line 469: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,

465: avalue => p_item_desc);
466:
467: IF p_formula_no IS NOT NULL and p_formula_vers IS NOT NULL THEN
468:
469: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,
470: itemkey => l_itemkey,
471: aname => 'FORMULA_NO',
472: avalue => p_formula_no);
473:

Line 474: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,

470: itemkey => l_itemkey,
471: aname => 'FORMULA_NO',
472: avalue => p_formula_no);
473:
474: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,
475: itemkey => l_itemkey,
476: aname => 'FORMULA_VERSION',
477: avalue => to_char(p_formula_vers));
478:

Line 479: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,

475: itemkey => l_itemkey,
476: aname => 'FORMULA_VERSION',
477: avalue => to_char(p_formula_vers));
478:
479: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,
480: itemkey => l_itemkey,
481: aname => 'FORMULA_FLAG',
482: avalue => 'Y');
483: END IF;

Line 490: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,

486: INTO l_performer
487: FROM FND_USER
488: WHERE USER_ID = p_user;
489:
490: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,
491: itemkey => l_itemkey,
492: aname => '#FROM_ROLE',
493: avalue => l_performer );
494: -- get values to be stored into the workflow item

Line 500: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,

496:
497: IF l_performer_name IS NULL THEN
498: l_performer_name := l_performer;
499: END IF;
500: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,
501: itemkey => l_itemkey,
502: aname => 'REG_DOC_MGR',
503: avalue => l_performer_name );
504:

Line 506: WF_ENGINE.STARTPROCESS (itemtype => l_itemtype,

502: aname => 'REG_DOC_MGR',
503: avalue => l_performer_name );
504:
505: /* start the Workflow process */
506: WF_ENGINE.STARTPROCESS (itemtype => l_itemtype,
507: itemkey => l_itemkey);
508:
509: EXCEPTION
510: WHEN OTHERS THEN

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

653: -- - DEFERED
654: -- execution should be defered to background
655: -- - NOTIFIED[::]
656: -- activity has notified an external entity that this
657: -- step must be performed. A call to wf_engine.CompleteActivty
658: -- will signal when this step is complete. Optional
659: -- return of notification ID and assigned user.
660: -- - ERROR[:]
661: -- function encountered an error.

Line 687: formula_no := wf_engine.GetItemAttrNumber(itemtype => p_itemtype,

683:
684: BEGIN
685: IF p_funcmode='RUN' THEN
686:
687: formula_no := wf_engine.GetItemAttrNumber(itemtype => p_itemtype,
688: itemkey => p_itemkey,
689: aname => 'FORMULA_NO' );
690: formula_version := wf_engine.GetItemAttrText(itemtype => p_itemtype,
691: itemkey => p_itemkey,

Line 690: formula_version := wf_engine.GetItemAttrText(itemtype => p_itemtype,

686:
687: formula_no := wf_engine.GetItemAttrNumber(itemtype => p_itemtype,
688: itemkey => p_itemkey,
689: aname => 'FORMULA_NO' );
690: formula_version := wf_engine.GetItemAttrText(itemtype => p_itemtype,
691: itemkey => p_itemkey,
692: aname => 'FORMULA_VERSION' );
693:
694: IF formula_no is null and formula_version is null THEN

Line 895: l_trn_type := WF_ENGINE.GetItemAttrText(itemtype => p_itemtype,

891: l_trn_type VARCHAR2(10);
892: BEGIN
893:
894:
895: l_trn_type := WF_ENGINE.GetItemAttrText(itemtype => p_itemtype,
896: itemkey => p_itemkey,
897: aname => 'TRNS_TYPE_GRRRO_GRIIO');
898: IF l_trn_type = 'GRRRO' THEN
899: l_item_code := WF_ENGINE.GetItemAttrText(itemtype => p_itemtype,

Line 899: l_item_code := WF_ENGINE.GetItemAttrText(itemtype => p_itemtype,

895: l_trn_type := WF_ENGINE.GetItemAttrText(itemtype => p_itemtype,
896: itemkey => p_itemkey,
897: aname => 'TRNS_TYPE_GRRRO_GRIIO');
898: IF l_trn_type = 'GRRRO' THEN
899: l_item_code := WF_ENGINE.GetItemAttrText(itemtype => p_itemtype,
900: itemkey => p_itemkey,
901: aname => 'ITEM_NO');
902:
903: l_orgn_id := WF_ENGINE.GetItemAttrText(itemtype => p_itemtype,

Line 903: l_orgn_id := WF_ENGINE.GetItemAttrText(itemtype => p_itemtype,

899: l_item_code := WF_ENGINE.GetItemAttrText(itemtype => p_itemtype,
900: itemkey => p_itemkey,
901: aname => 'ITEM_NO');
902:
903: l_orgn_id := WF_ENGINE.GetItemAttrText(itemtype => p_itemtype,
904: itemkey => p_itemkey,
905: aname => 'ORGANIZATION_ID');
906: GR_WF_UTIL_PVT.SEND_OUTBOUND_DOCUMENT(
907: p_transaction_type => 'GR',

Line 913: l_orgn_id := WF_ENGINE.GetItemAttrText(itemtype => p_itemtype,

909: p_document_id => l_item_code,
910: p_parameter1 => l_orgn_id);
911: ELSIF l_trn_type = 'GRIIO' AND p_funcmode = 'RESPOND' THEN
912:
913: l_orgn_id := WF_ENGINE.GetItemAttrText(itemtype => p_itemtype,
914: itemkey => p_itemkey,
915: aname => 'ORGANIZATION_ID');
916:
917: l_from_item := WF_ENGINE.GetItemAttrText(itemtype => p_itemtype,

Line 917: l_from_item := WF_ENGINE.GetItemAttrText(itemtype => p_itemtype,

913: l_orgn_id := WF_ENGINE.GetItemAttrText(itemtype => p_itemtype,
914: itemkey => p_itemkey,
915: aname => 'ORGANIZATION_ID');
916:
917: l_from_item := WF_ENGINE.GetItemAttrText(itemtype => p_itemtype,
918: itemkey => p_itemkey,
919: aname => 'FROM_ITEM');
920:
921: l_to_item := WF_ENGINE.GetItemAttrText(itemtype => p_itemtype,

Line 921: l_to_item := WF_ENGINE.GetItemAttrText(itemtype => p_itemtype,

917: l_from_item := WF_ENGINE.GetItemAttrText(itemtype => p_itemtype,
918: itemkey => p_itemkey,
919: aname => 'FROM_ITEM');
920:
921: l_to_item := WF_ENGINE.GetItemAttrText(itemtype => p_itemtype,
922: itemkey => p_itemkey,
923: aname => 'TO_ITEM');
924:
925: GR_WF_UTIL_PVT.SEND_OUTBOUND_DOCUMENT(

Line 968: l_run_wf_in_background CONSTANT WF_ENGINE.THRESHOLD%TYPE := -1;

964: /* make sure that process runs with background engine
965: to prevent SAVEPOINT/ROLLBACK error (see Workflow FAQ)
966: the value to use for this is -1 */
967:
968: l_run_wf_in_background CONSTANT WF_ENGINE.THRESHOLD%TYPE := -1;
969: l_WorkflowProcess VARCHAR2(30);
970: l_count NUMBER;
971: l_errname VARCHAR2(2000);
972: l_errmsg VARCHAR2(2000);

Line 1057: WF_ENGINE.CREATEPROCESS (itemtype => l_itemtype,

1053: HH24:mi:ss');
1054: l_WorkflowProcess := 'GRTPDCHNG_PROCESS';
1055:
1056: /* create the process */
1057: WF_ENGINE.CREATEPROCESS (itemtype => l_itemtype,
1058: itemkey => l_itemkey,
1059: process => l_WorkflowProcess) ;
1060:
1061: /* make sure that process runs with background engine */

Line 1062: WF_ENGINE.THRESHOLD := l_run_wf_in_background ;

1058: itemkey => l_itemkey,
1059: process => l_WorkflowProcess) ;
1060:
1061: /* make sure that process runs with background engine */
1062: WF_ENGINE.THRESHOLD := l_run_wf_in_background ;
1063:
1064: l_item := NULL;
1065:
1066: FOR c1 IN gr_prop_chng_temp LOOP

Line 1153: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,

1149:
1150:
1151: /* set the item attributes */
1152:
1153: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,
1154: itemkey => l_itemkey,
1155: aname => 'PROPERTY_DETAILS',
1156: avalue => l_property_details);
1157:

Line 1162: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,

1158: select item_code into l_item_code from gr_item_General_v where rownum=1;
1159:
1160: -- get values to be stored into the workflow item
1161: l_performer_name := get_default_role('oracle.apps.gr.reg.documentmanager',l_item_code);
1162: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,
1163: itemkey => l_itemkey,
1164: aname => 'REG_DOC_MGR',
1165: avalue => l_performer_name );
1166:

Line 1168: WF_ENGINE.STARTPROCESS (itemtype => l_itemtype,itemkey => l_itemkey);

1164: aname => 'REG_DOC_MGR',
1165: avalue => l_performer_name );
1166:
1167: /* start the Workflow process */
1168: WF_ENGINE.STARTPROCESS (itemtype => l_itemtype,itemkey => l_itemkey);
1169: delete from gr_prop_chng_temp where message_icn = p_message_icn;
1170: EXCEPTION
1171: WHEN OTHERS THEN
1172: wf_core.context ('GR_TRD_PRTY_WF',

Line 1299: l_run_wf_in_background CONSTANT WF_ENGINE.THRESHOLD%TYPE := -1;

1295: /* make sure that process runs with background engine
1296: to prevent SAVEPOINT/ROLLBACK error (see Workflow FAQ)
1297: the value to use for this is -1 */
1298:
1299: l_run_wf_in_background CONSTANT WF_ENGINE.THRESHOLD%TYPE := -1;
1300: l_WorkflowProcess VARCHAR2(30);
1301: l_count NUMBER;
1302: l_errname VARCHAR2(200);
1303: l_errmsg VARCHAR2(200);

Line 1327: WF_ENGINE.CREATEPROCESS (itemtype => l_itemtype,

1323: l_itemkey := to_char(l_from_item)||'-'||to_char(sysdate,'dd-MON-yyyy HH24:mi:ss');
1324: l_WorkflowProcess := 'GRREGIIO_PROCESS';
1325: l_user_id := FND_GLOBAL.USER_ID;
1326: /* create the process */
1327: WF_ENGINE.CREATEPROCESS (itemtype => l_itemtype,
1328: itemkey => l_itemkey,
1329: process => l_WorkflowProcess) ;
1330:
1331: /* make sure that process runs with background engine */

Line 1332: WF_ENGINE.THRESHOLD := l_run_wf_in_background ;

1328: itemkey => l_itemkey,
1329: process => l_WorkflowProcess) ;
1330:
1331: /* make sure that process runs with background engine */
1332: WF_ENGINE.THRESHOLD := l_run_wf_in_background ;
1333:
1334: /*Call the GR_DISPATCH_HISTORY_PVT.GET_ORGANIZATION_CODE to populate the ORGN_NAME */
1335: GR_DISPATCH_HISTORY_PVT.GET_ORGANIZATION_CODE(l_orgn_id, l_orgn_name);
1336:

Line 1338: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,

1334: /*Call the GR_DISPATCH_HISTORY_PVT.GET_ORGANIZATION_CODE to populate the ORGN_NAME */
1335: GR_DISPATCH_HISTORY_PVT.GET_ORGANIZATION_CODE(l_orgn_id, l_orgn_name);
1336:
1337: /* set the item attributes */
1338: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,
1339: itemkey => l_itemkey,
1340: aname => 'TRNS_TYPE_GRRRO_GRIIO',
1341: avalue => 'GRIIO');
1342:

Line 1343: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,

1339: itemkey => l_itemkey,
1340: aname => 'TRNS_TYPE_GRRRO_GRIIO',
1341: avalue => 'GRIIO');
1342:
1343: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,
1344: itemkey => l_itemkey,
1345: aname => 'ORGANIZATION_ID',
1346: avalue => l_orgn_id);
1347:

Line 1348: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,

1344: itemkey => l_itemkey,
1345: aname => 'ORGANIZATION_ID',
1346: avalue => l_orgn_id);
1347:
1348: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,
1349: itemkey => l_itemkey,
1350: aname => 'ORGN_NAME',
1351: avalue => l_orgn_name);
1352:

Line 1353: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,

1349: itemkey => l_itemkey,
1350: aname => 'ORGN_NAME',
1351: avalue => l_orgn_name);
1352:
1353: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,
1354: itemkey => l_itemkey,
1355: aname => 'FROM_ITEM',
1356: avalue => l_from_item);
1357:

Line 1358: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,

1354: itemkey => l_itemkey,
1355: aname => 'FROM_ITEM',
1356: avalue => l_from_item);
1357:
1358: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,
1359: itemkey => l_itemkey,
1360: aname => 'TO_ITEM',
1361: avalue => l_to_item);
1362:

Line 1368: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,

1364: INTO l_performer
1365: FROM FND_USER
1366: WHERE USER_ID = l_user_id;
1367:
1368: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,
1369: itemkey => l_itemkey,
1370: aname => '#FROM_ROLE',
1371: avalue => l_performer );
1372:

Line 1377: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,

1373: select concatenated_segments into l_from_item from mtl_system_items_kfv where rownum=1;
1374: -- get values to be stored into the workflow item
1375: l_performer_name := get_default_role('oracle.apps.gr.reg.documentmanager',l_from_item);
1376:
1377: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,
1378: itemkey => l_itemkey,
1379: aname => 'REG_DOC_MGR',
1380: avalue => l_performer_name );
1381:

Line 1383: WF_ENGINE.STARTPROCESS (itemtype => l_itemtype,

1379: aname => 'REG_DOC_MGR',
1380: avalue => l_performer_name );
1381:
1382: /* start the Workflow process */
1383: WF_ENGINE.STARTPROCESS (itemtype => l_itemtype,
1384: itemkey => l_itemkey);
1385: delete from gr_items_requested where message_icn = p_message_icn;
1386:
1387: EXCEPTION