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

Line 148: --debug_msg ( 'before WF_ENGINE createProcess: ' || p_Process_Name);

144:
145: x_return_status := FND_API.G_RET_STS_SUCCESS;
146:
147:
148: --debug_msg ( 'before WF_ENGINE createProcess: ' || p_Process_Name);
149:
150: -- create the workflow process
151: WF_ENGINE.CreateProcess( p_item_type
152: , x_item_key

Line 151: WF_ENGINE.CreateProcess( p_item_type

147:
148: --debug_msg ( 'before WF_ENGINE createProcess: ' || p_Process_Name);
149:
150: -- create the workflow process
151: WF_ENGINE.CreateProcess( p_item_type
152: , x_item_key
153: , p_Process_Name);
154: --debug_msg ( 'after WF_ENGINE createProcess: key = ' || x_item_key);
155:

Line 154: --debug_msg ( 'after WF_ENGINE createProcess: key = ' || x_item_key);

150: -- create the workflow process
151: WF_ENGINE.CreateProcess( p_item_type
152: , x_item_key
153: , p_Process_Name);
154: --debug_msg ( 'after WF_ENGINE createProcess: key = ' || x_item_key);
155:
156: pa_control_items_wf_client.start_workflow(
157: p_item_type
158: , p_process_name

Line 175: WF_ENGINE.AbortProcess( p_Item_Type

171: FETCH get_last_workflow_info INTO l_last_item_key;
172: IF get_last_workflow_info%found THEN
173: begin
174: -- abort this process if it is running
175: WF_ENGINE.AbortProcess( p_Item_Type
176: , l_last_Item_Key
177: );
178: EXCEPTION
179: WHEN OTHERS THEN

Line 187: wf_engine.SetItemAttrText(itemtype => p_item_type,

183: END IF;
184: --Changes for bug 8942843 start
185: if p_item_type = 'PAWFCISC' then
186: --Bug 8566495 Changes for E&C enhancement related to CR workflow
187: wf_engine.SetItemAttrText(itemtype => p_item_type,
188: itemkey => x_item_key,
189: aname => 'CI_TASK_INFO',
190: avalue =>
191: 'PLSQL:pa_control_items_workflow.show_task_details/'||

Line 196: --debug_msg_s1 ( 'before WF_ENGINE startProcess' );

192: p_ci_id);
193: end if;
194: --Changes for bug 8942843 end
195:
196: --debug_msg_s1 ( 'before WF_ENGINE startProcess' );
197: --debug_msg_s1 ( 'startProcess: item_type = ' || p_item_type || ' item_key = ' || x_Item_Key );
198:
199: WF_ENGINE.StartProcess(
200: p_Item_Type

Line 199: WF_ENGINE.StartProcess(

195:
196: --debug_msg_s1 ( 'before WF_ENGINE startProcess' );
197: --debug_msg_s1 ( 'startProcess: item_type = ' || p_item_type || ' item_key = ' || x_Item_Key );
198:
199: WF_ENGINE.StartProcess(
200: p_Item_Type
201: , x_Item_Key
202: );
203: -- debug_msg_s1 ( 'after start Process: item_type = ' || p_item_type || ' item_key = ' || x_Item_Key );

Line 206: --debug_msg ( 'after WF_ENGINE startProcess' );

202: );
203: -- debug_msg_s1 ( 'after start Process: item_type = ' || p_item_type || ' item_key = ' || x_Item_Key );
204: END IF;
205:
206: --debug_msg ( 'after WF_ENGINE startProcess' );
207:
208: -- insert into pa_wf_process table
209:
210: --debug_msg_s1 ('after workflow 1: isnertwf processes' || p_item_type);

Line 215: l_project_id := wf_engine.GetItemAttrNumber( p_item_type

211: --debug_msg_s1 ('after workflow 1: isnertwf processes' || l_item_key);
212:
213: --debug_msg_s1 ( 'b4 get project id ' );
214:
215: l_project_id := wf_engine.GetItemAttrNumber( p_item_type
216: , l_item_key
217: , 'PROJECT_ID'
218: );
219:

Line 242: WF_ENGINE.AbortProcess( p_Item_Type

238: x_return_status := FND_API.G_RET_STS_ERROR;
239:
240:
241: -- abort the workflow process just launched, there is a problem
242: WF_ENGINE.AbortProcess( p_Item_Type
243: , l_Item_Key
244: );
245:
246: END IF;

Line 286: WF_ENGINE.AbortProcess( p_Item_Type

282:
283: --debug_msg ( 'after client cancel_workflow call' );
284:
285: IF (x_return_status = FND_API.g_ret_sts_success) THEN
286: WF_ENGINE.AbortProcess( p_Item_Type
287: , p_Item_Key
288: );
289:
290: --debug_msg ( 'after WF_ENGINE abortProcess' );

Line 290: --debug_msg ( 'after WF_ENGINE abortProcess' );

286: WF_ENGINE.AbortProcess( p_Item_Type
287: , p_Item_Key
288: );
289:
290: --debug_msg ( 'after WF_ENGINE abortProcess' );
291:
292: --debug_msg ('before get task_id');
293:
294: END IF;

Line 328: l_ci_id := wf_engine.GetItemAttrNumber

324:
325:
326: BEGIN
327:
328: l_ci_id := wf_engine.GetItemAttrNumber
329: ( itemtype => itemtype,
330: itemkey => itemkey,
331: aname => 'CI_ID');
332:

Line 336: l_record_version_number := wf_engine.GetItemAttrNumber

332:
333:
334:
335:
336: l_record_version_number := wf_engine.GetItemAttrNumber
337: ( itemtype => itemtype,
338: itemkey => itemkey,
339: aname => 'RECORD_VERSION_NUMBER');
340:

Line 407: l_ci_id := wf_engine.GetItemAttrNumber

403: and ps.enable_wf_flag = 'Y'
404: and ps.wf_failure_status_code is NOT NULL;
405:
406: BEGIN
407: l_ci_id := wf_engine.GetItemAttrNumber
408: ( itemtype => itemtype,
409: itemkey => itemkey,
410: aname => 'CI_ID');
411:

Line 412: --debug_msg_s1 ('AAAAAAAAAAA report rejected' || WF_ENGINE.context_text);

408: ( itemtype => itemtype,
409: itemkey => itemkey,
410: aname => 'CI_ID');
411:
412: --debug_msg_s1 ('AAAAAAAAAAA report rejected' || WF_ENGINE.context_text);
413:
414: l_comment := wf_engine.GetItemAttrText
415: ( itemtype => itemtype,
416: itemkey => itemkey,

Line 414: l_comment := wf_engine.GetItemAttrText

410: aname => 'CI_ID');
411:
412: --debug_msg_s1 ('AAAAAAAAAAA report rejected' || WF_ENGINE.context_text);
413:
414: l_comment := wf_engine.GetItemAttrText
415: ( itemtype => itemtype,
416: itemkey => itemkey,
417: aname => 'COMMENT');
418:

Line 419: l_name := wf_engine.GetItemAttrText( itemtype

415: ( itemtype => itemtype,
416: itemkey => itemkey,
417: aname => 'COMMENT');
418:
419: l_name := wf_engine.GetItemAttrText( itemtype
420: , itemkey
421: , 'CI_APPROVER_NAME');
422:
423: l_record_version_number := wf_engine.GetItemAttrNumber

Line 423: l_record_version_number := wf_engine.GetItemAttrNumber

419: l_name := wf_engine.GetItemAttrText( itemtype
420: , itemkey
421: , 'CI_APPROVER_NAME');
422:
423: l_record_version_number := wf_engine.GetItemAttrNumber
424: ( itemtype => itemtype,
425: itemkey => itemkey,
426: aname => 'RECORD_VERSION_NUMBER');
427:

Line 489: wf_engine.SetItemAttrText( itemtype

485: NULL;
486: l_msg_data := fnd_msg_pub.get(p_msg_index => 1,
487: p_encoded => FND_API.G_FALSE);
488:
489: wf_engine.SetItemAttrText( itemtype
490: , itemkey
491: , 'ERROR_MSG'
492: , l_msg_data);
493: open c_get_working_status_code(l_ci_id);

Line 509: resultout := wf_engine.eng_completed||':'||'F';

505: x_msg_count=>l_msg_count,
506: x_msg_data=> l_msg_data
507: );
508:
509: resultout := wf_engine.eng_completed||':'||'F';
510: ELSE
511: resultout := wf_engine.eng_completed||':'||'T';
512: -- #Bug#13683760 changes end.
513:

Line 511: resultout := wf_engine.eng_completed||':'||'T';

507: );
508:
509: resultout := wf_engine.eng_completed||':'||'F';
510: ELSE
511: resultout := wf_engine.eng_completed||':'||'T';
512: -- #Bug#13683760 changes end.
513:
514: END IF;
515:

Line 568: l_ci_id := wf_engine.GetItemAttrNumber

564: and ps.project_system_status_code = 'CI_WORKING' and rownum = 1;
565: -- #Bug#13683760 changes end.
566:
567: BEGIN
568: l_ci_id := wf_engine.GetItemAttrNumber
569: ( itemtype => itemtype,
570: itemkey => itemkey,
571: aname => 'CI_ID');
572:

Line 574: -- debug_msg_s1 ('AAAAAAAAAAA report approved ' || WF_ENGINE.context_text);

570: itemkey => itemkey,
571: aname => 'CI_ID');
572:
573:
574: -- debug_msg_s1 ('AAAAAAAAAAA report approved ' || WF_ENGINE.context_text);
575: l_comment := wf_engine.GetItemAttrText
576: ( itemtype => itemtype,
577: itemkey => itemkey,
578: aname => 'COMMENT');

Line 575: l_comment := wf_engine.GetItemAttrText

571: aname => 'CI_ID');
572:
573:
574: -- debug_msg_s1 ('AAAAAAAAAAA report approved ' || WF_ENGINE.context_text);
575: l_comment := wf_engine.GetItemAttrText
576: ( itemtype => itemtype,
577: itemkey => itemkey,
578: aname => 'COMMENT');
579:

Line 580: l_name := wf_engine.GetItemAttrText( itemtype

576: ( itemtype => itemtype,
577: itemkey => itemkey,
578: aname => 'COMMENT');
579:
580: l_name := wf_engine.GetItemAttrText( itemtype
581: , itemkey
582: , 'CI_APPROVER_NAME');
583:
584: -- Added for Bug 6053648

Line 605: l_record_version_number := wf_engine.GetItemAttrNumber

601:
602:
603: -- debug_msg_s1 ('AAAAAAAAAAA report approved approver name' || l_name);
604:
605: l_record_version_number := wf_engine.GetItemAttrNumber
606: ( itemtype => itemtype,
607: itemkey => itemkey,
608: aname => 'RECORD_VERSION_NUMBER');
609:

Line 673: wf_engine.SetItemAttrText( itemtype

669:
670: -- #Bug#13683760 changes start.
671: l_msg_data := fnd_msg_pub.get(p_msg_index => 1,
672: p_encoded => FND_API.G_FALSE);
673: wf_engine.SetItemAttrText( itemtype
674: , itemkey
675: , 'ERROR_MSG'
676: , l_msg_data);
677:

Line 692: resultout := wf_engine.eng_completed||':'||'F';

688: x_return_status=> l_return_status,
689: x_msg_count=>l_msg_count,
690: x_msg_data=> l_msg_data
691: );
692: resultout := wf_engine.eng_completed||':'||'F';
693: ELSE
694: resultout := wf_engine.eng_completed||':'||'T';
695: END IF;
696: -- #Bug#13683760 changes end.

Line 694: resultout := wf_engine.eng_completed||':'||'T';

690: x_msg_data=> l_msg_data
691: );
692: resultout := wf_engine.eng_completed||':'||'F';
693: ELSE
694: resultout := wf_engine.eng_completed||':'||'T';
695: END IF;
696: -- #Bug#13683760 changes end.
697:
698: END ;

Line 722: l_proj_mgr_id := wf_engine.GetItemAttrNumber

718: WHERE user_id = FND_GLOBAL.user_id;
719:
720: BEGIN
721:
722: l_proj_mgr_id := wf_engine.GetItemAttrNumber
723: ( itemtype => itemtype,
724: itemkey => itemkey,
725: aname => 'PROJ_MGR_ID');
726:

Line 727: l_submitter_id := wf_engine.GetItemAttrNumber

723: ( itemtype => itemtype,
724: itemkey => itemkey,
725: aname => 'PROJ_MGR_ID');
726:
727: l_submitter_id := wf_engine.GetItemAttrNumber
728: ( itemtype => itemtype,
729: itemkey => itemkey,
730: aname => 'SUBMITTED_BY_ID');
731:

Line 752: wf_engine.SetItemAttrText( itemtype

748: ,'');
749:
750: IF l_submitter_id = l_proj_mgr_id THEN
751:
752: wf_engine.SetItemAttrText( itemtype
753: , itemkey
754: , 'CI_APPROVER_NAME'
755: , l_user_name);
756:

Line 757: resultout := wf_engine.eng_completed||':'||'T';

753: , itemkey
754: , 'CI_APPROVER_NAME'
755: , l_user_name);
756:
757: resultout := wf_engine.eng_completed||':'||'T';
758: ELSE
759:
760: resultout := wf_engine.eng_completed||':'||'F';
761: END IF;

Line 760: resultout := wf_engine.eng_completed||':'||'F';

756:
757: resultout := wf_engine.eng_completed||':'||'T';
758: ELSE
759:
760: resultout := wf_engine.eng_completed||':'||'F';
761: END IF;
762:
763: END;
764:

Line 786: l_ci_id := wf_engine.GetItemAttrNumber

782:
783:
784: BEGIN
785:
786: l_ci_id := wf_engine.GetItemAttrNumber
787: ( itemtype => itemtype,
788: itemkey => itemkey,
789: aname => 'CI_ID');
790:

Line 796: wf_engine.SetItemAttrText

792: FETCH get_status INTO l_status;
793:
794: CLOSE get_status;
795:
796: wf_engine.SetItemAttrText
797: ( itemtype,
798: itemkey,
799: 'STATUS_CODE',
800: l_status);

Line 804: resultout := wf_engine.eng_completed||':'||'APPROVED';

800: l_status);
801:
802:
803: IF l_status = 'CI_APPROVED' THEN
804: resultout := wf_engine.eng_completed||':'||'APPROVED';
805: ELSIF l_status = 'CI_REJECTED' THEN
806: resultout := wf_engine.eng_completed||':'||'REJECTED';
807: END IF;
808:

Line 806: resultout := wf_engine.eng_completed||':'||'REJECTED';

802:
803: IF l_status = 'CI_APPROVED' THEN
804: resultout := wf_engine.eng_completed||':'||'APPROVED';
805: ELSIF l_status = 'CI_REJECTED' THEN
806: resultout := wf_engine.eng_completed||':'||'REJECTED';
807: END IF;
808:
809:
810: -- added by syao

Line 835: --resultout := wf_engine.eng_completed||':'||'T';

831: IS
832: BEGIN
833:
834: resultout:='COMPLETE:'||'SUCCESS';
835: --resultout := wf_engine.eng_completed||':'||'T';
836:
837: END;
838:
839: PROCEDURE forward_notification(

Line 897: l_comment := wf_engine.GetItemAttrText

893:
894: --debug_msg_s1 ('call forward AAAAAAAAAAA' || funcmode);
895:
896: IF funcmode = 'RUN' then
897: l_comment := wf_engine.GetItemAttrText
898: ( itemtype => itemtype,
899: itemkey => itemkey,
900: aname => 'COMMENT');
901:

Line 906: l_forward_to := wf_engine.GetItemAttrText

902: --debug_msg_s1 ('forward AAAAAAAAAAA get approval comment' || funcmode);
903: --debug_msg_s1 ('forward AAAAAAAAAAA get approval comment' || actid);
904:
905:
906: l_forward_to := wf_engine.GetItemAttrText
907: ( itemtype => itemtype,
908: itemkey => itemkey,
909: aname => 'FORWARD_TO');
910:

Line 920: wf_engine.SetItemAttrText

916: -- the forward to is invalid
917: fnd_message.set_name ('PO', 'PO_WF_NOTIF_INVALID_FORWARD');
918: l_error_msg := fnd_message.get;
919:
920: wf_engine.SetItemAttrText
921: ( itemtype,
922: itemkey,
923: 'WRONG_FORWARD',
924: l_error_msg);

Line 947: wf_engine.SetItemAttrText( itemtype

943: END IF;
944:
945: --debug_msg_s1 ('forward AAAAAAAAAAA get approval comment: forward to = ' || l_forward_to);
946:
947: wf_engine.SetItemAttrText( itemtype
948: , itemkey
949: , 'CI_APPROVER'
950: , l_forward_to);
951:

Line 957: l_name := wf_engine.GetItemAttrText( itemtype

953: OPEN get_name ;
954: FETCH get_name INTO l_forward_to_name;
955: CLOSE get_name;
956:
957: l_name := wf_engine.GetItemAttrText( itemtype
958: , itemkey
959: , 'CI_APPROVER_NAME');
960:
961:

Line 963: wf_engine.SetItemAttrText( itemtype

959: , 'CI_APPROVER_NAME');
960:
961:
962:
963: wf_engine.SetItemAttrText( itemtype
964: , itemkey
965: , 'CI_APPROVER_NAME'
966: , l_forward_to);
967:

Line 977: wf_engine.SetItemAttrText

973: ,'FORWARD'
974: ,l_name
975: ,l_comment);
976:
977: wf_engine.SetItemAttrText
978: ( itemtype,
979: itemkey ,
980: 'COMMENT',
981: ''

Line 984: wf_engine.SetItemAttrText( itemtype

980: 'COMMENT',
981: ''
982: );
983:
984: wf_engine.SetItemAttrText( itemtype
985: , itemkey
986: , 'RESULT'
987: , '');
988:

Line 989: wf_engine.SetItemAttrText( itemtype

985: , itemkey
986: , 'RESULT'
987: , '');
988:
989: wf_engine.SetItemAttrText( itemtype
990: , itemkey
991: , 'FORWARD_TO'
992: , '');
993:

Line 1000: --resultout := wf_engine.eng_completed||':'||'T';

996:
997:
998: resultout:='COMPLETE:'||'SUCCESS';
999:
1000: --resultout := wf_engine.eng_completed||':'||'T';
1001:
1002:
1003: END;
1004:

Line 1230: WF_ENGINE.CreateProcess(p_item_type

1226: pa_debug.g_err_stage:= 'x_item_key = '|| x_item_key;
1227: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
1228: END IF;
1229: -- create the workflow process
1230: WF_ENGINE.CreateProcess(p_item_type
1231: ,x_item_key
1232: ,p_process_name);
1233:
1234:

Line 1266: WF_ENGINE.StartProcess(p_item_type

1262: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
1263: END IF;
1264:
1265:
1266: WF_ENGINE.StartProcess(p_item_type
1267: ,x_item_key);
1268:
1269: PA_WORKFLOW_UTILS.Insert_WF_Processes
1270: (p_wf_type_code => l_wf_type_code

Line 1283: WF_ENGINE.AbortProcess(p_Item_Type

1279: );
1280:
1281: IF l_err_code <> 0 THEN
1282: -- abort the workflow process just launched, there is a problem
1283: WF_ENGINE.AbortProcess(p_Item_Type
1284: ,l_Item_Key);
1285:
1286: --Log an error message and go to exception section.
1287: PA_UTILS.Add_Message( p_app_short_name => 'PA'

Line 1651: wf_engine.SetItemAttrText( p_item_type

1647: RAISE Invalid_Arg_Exc_CI;
1648: END IF;
1649:
1650: -- Set the workflow attributes.
1651: wf_engine.SetItemAttrText( p_item_type
1652: ,p_item_key
1653: ,'ITEM_TYPE'
1654: ,p_item_type);
1655:

Line 1656: wf_engine.SetItemAttrText( p_item_type

1652: ,p_item_key
1653: ,'ITEM_TYPE'
1654: ,p_item_type);
1655:
1656: wf_engine.SetItemAttrText( p_item_type
1657: ,p_item_key
1658: ,'ITEM_KEY'
1659: ,p_item_key);
1660:

Line 1661: wf_engine.SetItemAttrNumber( p_item_type

1657: ,p_item_key
1658: ,'ITEM_KEY'
1659: ,p_item_key);
1660:
1661: wf_engine.SetItemAttrNumber( p_item_type
1662: , p_item_key
1663: , 'CI_ID'
1664: , p_ci_id);
1665:

Line 1675: wf_engine.SetItemOwner ( p_item_type

1671: open get_owner_role(l_owner_id);
1672: fetch get_owner_role into l_owner_role;
1673: close get_owner_role;
1674:
1675: wf_engine.SetItemOwner ( p_item_type
1676: , p_item_key
1677: , l_owner_role );
1678: wf_engine.SetItemAttrNumber(p_item_type
1679: , p_item_key

Line 1678: wf_engine.SetItemAttrNumber(p_item_type

1674:
1675: wf_engine.SetItemOwner ( p_item_type
1676: , p_item_key
1677: , l_owner_role );
1678: wf_engine.SetItemAttrNumber(p_item_type
1679: , p_item_key
1680: , 'PROJECT_ID'
1681: , rec.project_id);
1682:

Line 1683: wf_engine.SetItemAttrText( p_item_type

1679: , p_item_key
1680: , 'PROJECT_ID'
1681: , rec.project_id);
1682:
1683: wf_engine.SetItemAttrText( p_item_type
1684: , p_item_key
1685: , 'PROJECT_NAME'
1686: , l_project_name);
1687:

Line 1688: wf_engine.SetItemAttrText( p_item_type

1684: , p_item_key
1685: , 'PROJECT_NAME'
1686: , l_project_name);
1687:
1688: wf_engine.SetItemAttrText( p_item_type
1689: , p_item_key
1690: , 'PROJECT_NUMBER'
1691: , l_project_number);
1692:

Line 1693: wf_engine.SetItemAttrText( p_item_type

1689: , p_item_key
1690: , 'PROJECT_NUMBER'
1691: , l_project_number);
1692:
1693: wf_engine.SetItemAttrText( p_item_type
1694: , p_item_key
1695: , 'PROJECT'
1696: , l_project_name||'('||l_project_number||')');
1697:

Line 1698: wf_engine.SetItemAttrDate( p_item_type

1694: , p_item_key
1695: , 'PROJECT'
1696: , l_project_name||'('||l_project_number||')');
1697:
1698: wf_engine.SetItemAttrDate( p_item_type
1699: , p_item_key
1700: , 'DATE_REQUIRED'
1701: , rec.date_required);
1702:

Line 1703: wf_engine.SetItemAttrText( p_item_type

1699: , p_item_key
1700: , 'DATE_REQUIRED'
1701: , rec.date_required);
1702:
1703: wf_engine.SetItemAttrText( p_item_type
1704: , p_item_key
1705: , 'SUMMARY'
1706: , rec.summary);
1707: --Changes for bug 8942843 start

Line 1711: wf_engine.SetItemAttrDate( p_item_type

1707: --Changes for bug 8942843 start
1708: if p_action_id is null
1709: then
1710:
1711: wf_engine.SetItemAttrDate( p_item_type
1712: , p_item_key
1713: , 'CI_CREATION_DATE'
1714: , rec.creation_date);
1715: end if;

Line 1721: wf_engine.SetItemAttrText( p_item_type

1717: -- Bug#12553936: Moved the description code from above if to here as
1718: -- CI_DESCRIPTION is seeded now .
1719: --Bug#12588071 modified the below if conditon.
1720: if(l_action_process = false) then -- Bug#12703270
1721: wf_engine.SetItemAttrText( p_item_type
1722: , p_item_key
1723: , 'CI_DESCRIPTION'
1724: , rec.description);
1725: end if;

Line 1727: wf_engine.SetItemAttrText( p_item_type

1723: , 'CI_DESCRIPTION'
1724: , rec.description);
1725: end if;
1726: -- Bug#12553936 end
1727: wf_engine.SetItemAttrText( p_item_type
1728: , p_item_key
1729: , 'CONTROL_ITEM_TYPE'
1730: , rec.ci_type_name);
1731:

Line 1732: wf_engine.SetItemAttrText( p_item_type

1728: , p_item_key
1729: , 'CONTROL_ITEM_TYPE'
1730: , rec.ci_type_name);
1731:
1732: wf_engine.SetItemAttrText( p_item_type
1733: , p_item_key
1734: , 'CONTROL_ITEM_TYPE_SN'
1735: , rec.ci_type_sn);
1736:

Line 1737: wf_engine.SetItemAttrText( p_item_type

1733: , p_item_key
1734: , 'CONTROL_ITEM_TYPE_SN'
1735: , rec.ci_type_sn);
1736:
1737: wf_engine.SetItemAttrText( p_item_type
1738: , p_item_key
1739: , 'CONTROL_ITEM_NUMBER'
1740: , rec.ci_number);
1741:

Line 1742: wf_engine.SetItemAttrText( p_item_type

1738: , p_item_key
1739: , 'CONTROL_ITEM_NUMBER'
1740: , rec.ci_number);
1741:
1742: wf_engine.SetItemAttrText( p_item_type
1743: , p_item_key
1744: , 'CONTROL_ITEM_CLASS'
1745: , rec.ci_type_class);
1746:

Line 1755: wf_engine.SetItemAttrText( p_item_type

1751: close get_lookup_meaning;
1752: else
1753: l_priority_name := null;
1754: end if;
1755: wf_engine.SetItemAttrText( p_item_type
1756: , p_item_key
1757: , 'PRIORITY'
1758: , l_priority_name);
1759:

Line 1760: wf_engine.SetItemAttrText( p_item_type

1756: , p_item_key
1757: , 'PRIORITY'
1758: , l_priority_name);
1759:
1760: wf_engine.SetItemAttrText( p_item_type
1761: , p_item_key
1762: , 'CLASSIFICATION'
1763: , rec.classification);
1764:

Line 1769: wf_engine.SetItemAttrText( p_item_type

1765: -- set project manager, organization name and customer
1766: OPEN get_project_info(rec.project_id);
1767: FETCH get_project_info INTO l_customer,l_project_manager, l_org;
1768:
1769: wf_engine.SetItemAttrText( p_item_type
1770: , p_item_key
1771: , 'PROJECT_MANAGER'
1772: , l_project_manager);
1773:

Line 1775: wf_engine.SetItemAttrText( p_item_type

1771: , 'PROJECT_MANAGER'
1772: , l_project_manager);
1773:
1774:
1775: wf_engine.SetItemAttrText( p_item_type
1776: , p_item_key
1777: , 'ORGANIZATION'
1778: , l_org);
1779:

Line 1780: wf_engine.SetItemAttrText( p_item_type

1776: , p_item_key
1777: , 'ORGANIZATION'
1778: , l_org);
1779:
1780: wf_engine.SetItemAttrText( p_item_type
1781: , p_item_key
1782: , 'CUSTOMER'
1783: , l_customer);
1784: CLOSE get_project_info;

Line 1793: wf_engine.SetItemAttrText( p_item_type

1789: l_url := 'JSP:/OA_HTML/OA.jsp?'||'page=/oracle/apps/pa/ci/webui/CiCiReviewPG' ||
1790: '&addBreadCrumb=N&paCiId='||p_ci_id || '&paProjectId=' || rec.project_id ||
1791: '&paCITypeClassCode=' || rec.ci_type_class_code|| '&paNotificationId=-&#NID-';
1792:
1793: wf_engine.SetItemAttrText( p_item_type
1794: , p_item_key
1795: , 'CI_LINK'
1796: , l_url);
1797: --end if;

Line 1805: wf_engine.SetItemAttrText( p_item_type

1801: fetch get_comment_text into l_comment_text;
1802: close get_comment_text;
1803:
1804:
1805: wf_engine.SetItemAttrText( p_item_type
1806: , p_item_key
1807: , 'COMMENT'
1808: , l_comment_text);
1809: end if;

Line 1824: wf_engine.SetItemAttrText( p_item_type

1820:
1821: -- Bug#12553936 start
1822: --Bug#12588071 modified the below if conditon.
1823: if (l_action_process = false) then -- Bug#12703270
1824: wf_engine.SetItemAttrText( p_item_type
1825: , p_item_key
1826: , 'CI_OWNER'
1827: , l_ci_owner_name);
1828: end if;

Line 1833: wf_engine.SetItemAttrText( p_item_type

1829: -- Bug#12553936 end
1830: -- Bug# 12553936, CI_STATUS_CODE,CI_STATUS are not involved if p_action_id is null
1831: -- owner_id, owner_name needs to be populated.
1832: if (p_action_id is not null) then
1833: wf_engine.SetItemAttrText( p_item_type
1834: , p_item_key
1835: , 'CI_STATUS_CODE'
1836: , l_ci_status_code);
1837: wf_engine.SetItemAttrText( p_item_type

Line 1837: wf_engine.SetItemAttrText( p_item_type

1833: wf_engine.SetItemAttrText( p_item_type
1834: , p_item_key
1835: , 'CI_STATUS_CODE'
1836: , l_ci_status_code);
1837: wf_engine.SetItemAttrText( p_item_type
1838: , p_item_key
1839: , 'CI_STATUS'
1840: , l_ci_status_name);
1841:

Line 1842: wf_engine.SetItemAttrNumber( p_item_type

1838: , p_item_key
1839: , 'CI_STATUS'
1840: , l_ci_status_name);
1841:
1842: wf_engine.SetItemAttrNumber( p_item_type
1843: , p_item_key
1844: , 'CI_OWNER_ID'
1845: , l_ci_owner_id);
1846: wf_engine.SetItemAttrText( p_item_type

Line 1846: wf_engine.SetItemAttrText( p_item_type

1842: wf_engine.SetItemAttrNumber( p_item_type
1843: , p_item_key
1844: , 'CI_OWNER_ID'
1845: , l_ci_owner_id);
1846: wf_engine.SetItemAttrText( p_item_type
1847: , p_item_key
1848: , 'CI_OWNER_NAME'
1849: , l_ci_owner_name);
1850:

Line 1870: wf_engine.SetItemAttrNumber( p_item_type

1866: l_action_status_meaning,
1867: l_sign_off_req_flag,
1868: l_sign_off_req_meaning; --FP.M.IB1 Sanity
1869:
1870: wf_engine.SetItemAttrNumber( p_item_type
1871: , p_item_key
1872: , 'ACTION_ID'
1873: , p_action_id);
1874:

Line 1875: wf_engine.SetItemAttrNumber( p_item_type

1871: , p_item_key
1872: , 'ACTION_ID'
1873: , p_action_id);
1874:
1875: wf_engine.SetItemAttrNumber( p_item_type
1876: , p_item_key
1877: , 'RECORD_VERSION_NUMBER'
1878: , l_record_version_number);
1879:

Line 1880: wf_engine.SetItemAttrNumber( p_item_type

1876: , p_item_key
1877: , 'RECORD_VERSION_NUMBER'
1878: , l_record_version_number);
1879:
1880: wf_engine.SetItemAttrNumber( p_item_type
1881: , p_item_key
1882: , 'ACTION_NUMBER'
1883: , l_action_number);
1884:

Line 1885: wf_engine.SetItemAttrText( p_item_type

1881: , p_item_key
1882: , 'ACTION_NUMBER'
1883: , l_action_number);
1884:
1885: wf_engine.SetItemAttrText( p_item_type
1886: , p_item_key
1887: , 'ACTION_REQUEST'
1888: , l_action_request);
1889:

Line 1891: wf_engine.SetItemAttrText( p_item_type

1887: , 'ACTION_REQUEST'
1888: , l_action_request);
1889:
1890:
1891: wf_engine.SetItemAttrText( p_item_type
1892: , p_item_key
1893: , 'ACTION_REQUESTOR'
1894: , l_action_requestor);
1895:

Line 1896: wf_engine.SetItemAttrDate( p_item_type

1892: , p_item_key
1893: , 'ACTION_REQUESTOR'
1894: , l_action_requestor);
1895:
1896: wf_engine.SetItemAttrDate( p_item_type
1897: , p_item_key
1898: , 'ACTION_DATE_REQUIRED'
1899: , l_action_date_required);
1900:

Line 1901: wf_engine.SetItemAttrNumber( p_item_type

1897: , p_item_key
1898: , 'ACTION_DATE_REQUIRED'
1899: , l_action_date_required);
1900:
1901: wf_engine.SetItemAttrNumber( p_item_type
1902: , p_item_key
1903: , 'ASSIGN_PARTY_ID'
1904: , l_assign_party_id);
1905:

Line 1909: wf_engine.SetItemAttrText( p_item_type

1905:
1906:
1907: --Changes for the bug# 3691192 starts
1908: -- Follwing are the new Item Attributes added in the workflow PAWFCIAC
1909: wf_engine.SetItemAttrText( p_item_type
1910: , p_item_key
1911: , 'ACTION_TYPE_CODE'
1912: , l_action_type_code);
1913:

Line 1914: wf_engine.SetItemAttrText( p_item_type

1910: , p_item_key
1911: , 'ACTION_TYPE_CODE'
1912: , l_action_type_code);
1913:
1914: wf_engine.SetItemAttrText( p_item_type
1915: , p_item_key
1916: , 'ACTION_TYPE'
1917: , l_action_type);
1918:

Line 1920: wf_engine.SetItemAttrDate( p_item_type

1916: , 'ACTION_TYPE'
1917: , l_action_type);
1918:
1919:
1920: wf_engine.SetItemAttrDate( p_item_type
1921: , p_item_key
1922: , 'SYSDATE'
1923: , sysdate);
1924:

Line 1925: wf_engine.SetItemAttrDate( p_item_type

1921: , p_item_key
1922: , 'SYSDATE'
1923: , sysdate);
1924:
1925: wf_engine.SetItemAttrDate( p_item_type
1926: , p_item_key
1927: , 'LAST_UPDATE_DATE'
1928: , l_last_updated);
1929:

Line 1930: wf_engine.SetItemAttrText( p_item_type

1926: , p_item_key
1927: , 'LAST_UPDATE_DATE'
1928: , l_last_updated);
1929:
1930: wf_engine.SetItemAttrText( p_item_type
1931: , p_item_key
1932: , 'ACTION_STATUS_CODE'
1933: , l_action_status_code);
1934:

Line 1935: wf_engine.SetItemAttrText( p_item_type

1931: , p_item_key
1932: , 'ACTION_STATUS_CODE'
1933: , l_action_status_code);
1934:
1935: wf_engine.SetItemAttrText( p_item_type
1936: , p_item_key
1937: , 'ACTION_STATUS'
1938: , l_action_status_meaning);
1939:

Line 1940: wf_engine.SetItemAttrText( p_item_type

1936: , p_item_key
1937: , 'ACTION_STATUS'
1938: , l_action_status_meaning);
1939:
1940: wf_engine.SetItemAttrText( p_item_type
1941: , p_item_key
1942: , 'SIGN_OFF_REQUESTED_FLAG'
1943: , l_sign_off_req_flag);
1944:

Line 1945: wf_engine.SetItemAttrText( p_item_type

1941: , p_item_key
1942: , 'SIGN_OFF_REQUESTED_FLAG'
1943: , l_sign_off_req_flag);
1944:
1945: wf_engine.SetItemAttrText( p_item_type
1946: , p_item_key
1947: , 'SIGN_OFF_REQUESTED'
1948: , l_sign_off_req_meaning);
1949:

Line 1973: wf_engine.SetItemAttrText( p_item_type

1969: '&addBreadCrumb=N&paCiId='||p_ci_id || '&paProjectId=' || rec.project_id || '&paCiActionId='
1970: || p_action_id || '&paCITypeClassCode=' || rec.ci_type_class_code || '&paNotificationId=-&#NID-';*/
1971:
1972: --Set the closure comment if it is action closure.
1973: wf_engine.SetItemAttrText( p_item_type
1974: , p_item_key
1975: , 'ACTION_CLOSURE_COMMENT'
1976: , l_action_closure_comment);
1977: end if;

Line 1981: wf_engine.SetItemAttrText( p_item_type

1977: end if;
1978:
1979: -- New item attribute added in the workflow PAWFCIAC for the bug# 3691192
1980: if (l_act_url is not null) then
1981: wf_engine.SetItemAttrText( p_item_type
1982: , p_item_key
1983: , 'CI_ACT_LINK'
1984: , l_act_url);
1985: end if;

Line 2000: wf_engine.SetItemAttrText( p_item_type

1996: l_task_number;
1997: close get_task_info;
1998:
1999: if l_task_name is not null then
2000: wf_engine.SetItemAttrText( p_item_type
2001: , p_item_key
2002: , 'TASK_NAME'
2003: , l_task_name);
2004: end if;

Line 2006: wf_engine.SetItemAttrText( p_item_type

2002: , 'TASK_NAME'
2003: , l_task_name);
2004: end if;
2005: if l_task_number is not null then
2006: wf_engine.SetItemAttrText( p_item_type
2007: , p_item_key
2008: , 'TASK_NUMBER'
2009: , l_task_number);
2010: end if;

Line 2114: wf_engine.SetItemAttrText( p_item_type

2110: end loop;
2111: IF (l_role_users is NOT NULL) THEN
2112: WF_DIRECTORY.AddUsersToAdHocRole( l_role, l_role_users);
2113:
2114: wf_engine.SetItemAttrText( p_item_type
2115: , p_item_key
2116: , 'CI_NOTIFICATION_PARTY'
2117: , l_role);
2118: END IF;

Line 2291: l_ci_id := wf_engine.GetItemAttrNumber

2287: -- Initialize the Error Stack
2288: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_WORKFLOW.CLOSE_CI_ACTION');
2289:
2290:
2291: l_ci_id := wf_engine.GetItemAttrNumber
2292: ( itemtype => itemtype,
2293: itemkey => itemkey,
2294: aname => 'CI_ID');
2295:

Line 2296: l_ci_action_id := wf_engine.GetItemAttrNumber

2292: ( itemtype => itemtype,
2293: itemkey => itemkey,
2294: aname => 'CI_ID');
2295:
2296: l_ci_action_id := wf_engine.GetItemAttrNumber
2297: ( itemtype => itemtype,
2298: itemkey => itemkey,
2299: aname => 'ACTION_ID');
2300:

Line 2301: l_record_version_number := wf_engine.GetItemAttrNumber

2297: ( itemtype => itemtype,
2298: itemkey => itemkey,
2299: aname => 'ACTION_ID');
2300:
2301: l_record_version_number := wf_engine.GetItemAttrNumber
2302: ( itemtype => itemtype,
2303: itemkey => itemkey,
2304: aname => 'RECORD_VERSION_NUMBER');
2305:

Line 2306: l_comment_text := wf_engine.GetItemAttrText

2302: ( itemtype => itemtype,
2303: itemkey => itemkey,
2304: aname => 'RECORD_VERSION_NUMBER');
2305:
2306: l_comment_text := wf_engine.GetItemAttrText
2307: ( itemtype => itemtype,
2308: itemkey => itemkey,
2309: aname => 'COMMENT');
2310: --Added for Bug#12860002

Line 2311: wf_engine.SetItemAttrText( itemtype

2307: ( itemtype => itemtype,
2308: itemkey => itemkey,
2309: aname => 'COMMENT');
2310: --Added for Bug#12860002
2311: wf_engine.SetItemAttrText( itemtype
2312: , itemkey
2313: , 'ACTION_CLOSURE_COMMENT'
2314: , l_comment_text);
2315: --Added for Bug# 3802238

Line 2316: l_user_sign_off := wf_engine.GetItemAttrText

2312: , itemkey
2313: , 'ACTION_CLOSURE_COMMENT'
2314: , l_comment_text);
2315: --Added for Bug# 3802238
2316: l_user_sign_off := wf_engine.GetItemAttrText
2317: ( itemtype => itemtype,
2318: itemkey => itemkey,
2319: aname => 'SIGN_OFF');
2320:

Line 2321: l_assign_party_id := wf_engine.GetItemAttrNumber

2317: ( itemtype => itemtype,
2318: itemkey => itemkey,
2319: aname => 'SIGN_OFF');
2320:
2321: l_assign_party_id := wf_engine.GetItemAttrNumber
2322: ( itemtype => itemtype,
2323: itemkey => itemkey,
2324: aname => 'ASSIGN_PARTY_ID');
2325:

Line 2343: resultout := wf_engine.eng_completed||':'||'F';

2339: l_created_by, l_creation_date;
2340: IF ci_action%NOTFOUND THEN
2341: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2342: ,p_msg_name => 'PA_NO_ACTION_FOUND');
2343: resultout := wf_engine.eng_completed||':'||'F';
2344: CLOSE ci_action;
2345: return;
2346: END IF;
2347:

Line 2354: resultout := wf_engine.eng_completed||':'||'F';

2350: FETCH check_record_changed INTO l_rowid;
2351: IF check_record_changed%NOTFOUND THEN
2352: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2353: ,p_msg_name => 'PA_PR_RECORD_CHANGED');
2354: resultout := wf_engine.eng_completed||':'||'F';
2355: CLOSE check_record_changed;
2356: return;
2357: END IF;
2358:

Line 2466: resultout := wf_engine.eng_completed||':'||'T';

2462: if(l_return_status <> FND_API.g_ret_sts_success) then
2463: raise FND_API.G_EXC_ERROR;
2464: end if;
2465: -- Bug#12859815 end.
2466: resultout := wf_engine.eng_completed||':'||'T';
2467:
2468: END IF;
2469: END IF;
2470: -- End Modification for Bug#12839389

Line 2476: resultout := wf_engine.eng_completed||':'||'F';

2472:
2473:
2474: EXCEPTION WHEN FND_API.G_EXC_ERROR THEN
2475: ROLLBACK TO CLOSE_CI_ACTION;
2476: resultout := wf_engine.eng_completed||':'||'F';
2477: WHEN OTHERS THEN
2478: ROLLBACK TO CLOSE_CI_ACTION;
2479: resultout := wf_engine.eng_completed||':'||'F';
2480: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CONTROL_ITEMS_WORKFLOW',

Line 2479: resultout := wf_engine.eng_completed||':'||'F';

2475: ROLLBACK TO CLOSE_CI_ACTION;
2476: resultout := wf_engine.eng_completed||':'||'F';
2477: WHEN OTHERS THEN
2478: ROLLBACK TO CLOSE_CI_ACTION;
2479: resultout := wf_engine.eng_completed||':'||'F';
2480: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CONTROL_ITEMS_WORKFLOW',
2481: p_procedure_name => 'CLOSE_CI_ACTIONS',
2482: p_error_text => SUBSTRB(SQLERRM,1,240));
2483: RAISE;

Line 2554: l_ci_id := wf_engine.GetItemAttrNumber

2550: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_WORKFLOW.KEEP_OPEN');
2551:
2552:
2553:
2554: l_ci_id := wf_engine.GetItemAttrNumber
2555: ( itemtype => itemtype,
2556: itemkey => itemkey,
2557: aname => 'CI_ID');
2558:

Line 2559: l_ci_action_id := wf_engine.GetItemAttrNumber

2555: ( itemtype => itemtype,
2556: itemkey => itemkey,
2557: aname => 'CI_ID');
2558:
2559: l_ci_action_id := wf_engine.GetItemAttrNumber
2560: ( itemtype => itemtype,
2561: itemkey => itemkey,
2562: aname => 'ACTION_ID');
2563:

Line 2564: l_record_version_number := wf_engine.GetItemAttrNumber

2560: ( itemtype => itemtype,
2561: itemkey => itemkey,
2562: aname => 'ACTION_ID');
2563:
2564: l_record_version_number := wf_engine.GetItemAttrNumber
2565: ( itemtype => itemtype,
2566: itemkey => itemkey,
2567: aname => 'RECORD_VERSION_NUMBER');
2568:

Line 2569: l_comment_text := wf_engine.GetItemAttrText

2565: ( itemtype => itemtype,
2566: itemkey => itemkey,
2567: aname => 'RECORD_VERSION_NUMBER');
2568:
2569: l_comment_text := wf_engine.GetItemAttrText
2570: ( itemtype => itemtype,
2571: itemkey => itemkey,
2572: aname => 'COMMENT');
2573:

Line 2574: l_assign_party_id := wf_engine.GetItemAttrNumber

2570: ( itemtype => itemtype,
2571: itemkey => itemkey,
2572: aname => 'COMMENT');
2573:
2574: l_assign_party_id := wf_engine.GetItemAttrNumber
2575: ( itemtype => itemtype,
2576: itemkey => itemkey,
2577: aname => 'ASSIGN_PARTY_ID');
2578:

Line 2590: resultout := wf_engine.eng_completed||':'||'F';

2586: l_created_by, l_creation_date;
2587: IF ci_action%NOTFOUND THEN
2588: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2589: ,p_msg_name => 'PA_NO_ACTION_FOUND');
2590: resultout := wf_engine.eng_completed||':'||'F';
2591: CLOSE ci_action;
2592: return;
2593: END IF;
2594:

Line 2641: resultout := wf_engine.eng_completed||':'||'T';

2637:
2638:
2639: if l_return_status = fnd_api.g_ret_sts_success then
2640: commit;
2641: resultout := wf_engine.eng_completed||':'||'T';
2642: end if;
2643: commit;
2644: ELSE
2645: CLOSE is_comment_inserted_cur;

Line 2650: resultout := wf_engine.eng_completed||':'||'F';

2646: END IF;
2647:
2648: EXCEPTION WHEN FND_API.G_EXC_ERROR THEN
2649: ROLLBACK TO KEEP_OPEN;
2650: resultout := wf_engine.eng_completed||':'||'F';
2651: WHEN OTHERS THEN
2652: ROLLBACK TO KEEP_OPEN;
2653: resultout := wf_engine.eng_completed||':'||'F';
2654: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CONTROL_ITEMS_WORKFLOW',

Line 2653: resultout := wf_engine.eng_completed||':'||'F';

2649: ROLLBACK TO KEEP_OPEN;
2650: resultout := wf_engine.eng_completed||':'||'F';
2651: WHEN OTHERS THEN
2652: ROLLBACK TO KEEP_OPEN;
2653: resultout := wf_engine.eng_completed||':'||'F';
2654: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CONTROL_ITEMS_WORKFLOW',
2655: p_procedure_name => 'KEEP_OPEN',
2656: p_error_text => SUBSTRB(SQLERRM,1,240));
2657: RAISE;

Line 2750: l_sign_off_requested:= wf_engine.GetItemAttrText

2746: BEGIN
2747:
2748: x_return_status := FND_API.G_RET_STS_SUCCESS;
2749:
2750: l_sign_off_requested:= wf_engine.GetItemAttrText
2751: ( itemtype => p_item_type,
2752: itemkey => p_item_key,
2753: aname => 'SIGN_OFF_REQUESTED_FLAG');
2754: