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 124: --debug_msg ( 'before WF_ENGINE createProcess: ' || p_Process_Name);

120:
121: x_return_status := FND_API.G_RET_STS_SUCCESS;
122:
123:
124: --debug_msg ( 'before WF_ENGINE createProcess: ' || p_Process_Name);
125:
126: -- create the workflow process
127: WF_ENGINE.CreateProcess( p_item_type
128: , x_item_key

Line 127: WF_ENGINE.CreateProcess( p_item_type

123:
124: --debug_msg ( 'before WF_ENGINE createProcess: ' || p_Process_Name);
125:
126: -- create the workflow process
127: WF_ENGINE.CreateProcess( p_item_type
128: , x_item_key
129: , p_Process_Name);
130: --debug_msg ( 'after WF_ENGINE createProcess: key = ' || x_item_key);
131:

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

126: -- create the workflow process
127: WF_ENGINE.CreateProcess( p_item_type
128: , x_item_key
129: , p_Process_Name);
130: --debug_msg ( 'after WF_ENGINE createProcess: key = ' || x_item_key);
131:
132: pa_control_items_wf_client.start_workflow(
133: p_item_type
134: , p_process_name

Line 151: WF_ENGINE.AbortProcess( p_Item_Type

147: FETCH get_last_workflow_info INTO l_last_item_key;
148: IF get_last_workflow_info%found THEN
149: begin
150: -- abort this process if it is running
151: WF_ENGINE.AbortProcess( p_Item_Type
152: , l_last_Item_Key
153: );
154: EXCEPTION
155: WHEN OTHERS THEN

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

157: END;
158:
159: END IF;
160:
161: --debug_msg_s1 ( 'before WF_ENGINE startProcess' );
162: --debug_msg_s1 ( 'startProcess: item_type = ' || p_item_type || ' item_key = ' || x_Item_Key );
163:
164: WF_ENGINE.StartProcess(
165: p_Item_Type

Line 164: WF_ENGINE.StartProcess(

160:
161: --debug_msg_s1 ( 'before WF_ENGINE startProcess' );
162: --debug_msg_s1 ( 'startProcess: item_type = ' || p_item_type || ' item_key = ' || x_Item_Key );
163:
164: WF_ENGINE.StartProcess(
165: p_Item_Type
166: , x_Item_Key
167: );
168: -- debug_msg_s1 ( 'after start Process: item_type = ' || p_item_type || ' item_key = ' || x_Item_Key );

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

167: );
168: -- debug_msg_s1 ( 'after start Process: item_type = ' || p_item_type || ' item_key = ' || x_Item_Key );
169: END IF;
170:
171: --debug_msg ( 'after WF_ENGINE startProcess' );
172:
173: -- insert into pa_wf_process table
174:
175: --debug_msg_s1 ('after workflow 1: isnertwf processes' || p_item_type);

Line 180: l_project_id := wf_engine.GetItemAttrNumber( p_item_type

176: --debug_msg_s1 ('after workflow 1: isnertwf processes' || l_item_key);
177:
178: --debug_msg_s1 ( 'b4 get project id ' );
179:
180: l_project_id := wf_engine.GetItemAttrNumber( p_item_type
181: , l_item_key
182: , 'PROJECT_ID'
183: );
184:

Line 207: WF_ENGINE.AbortProcess( p_Item_Type

203: x_return_status := FND_API.G_RET_STS_ERROR;
204:
205:
206: -- abort the workflow process just launched, there is a problem
207: WF_ENGINE.AbortProcess( p_Item_Type
208: , l_Item_Key
209: );
210:
211: END IF;

Line 251: WF_ENGINE.AbortProcess( p_Item_Type

247:
248: --debug_msg ( 'after client cancel_workflow call' );
249:
250: IF (x_return_status = FND_API.g_ret_sts_success) THEN
251: WF_ENGINE.AbortProcess( p_Item_Type
252: , p_Item_Key
253: );
254:
255: --debug_msg ( 'after WF_ENGINE abortProcess' );

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

251: WF_ENGINE.AbortProcess( p_Item_Type
252: , p_Item_Key
253: );
254:
255: --debug_msg ( 'after WF_ENGINE abortProcess' );
256:
257: --debug_msg ('before get task_id');
258:
259: END IF;

Line 293: l_ci_id := wf_engine.GetItemAttrNumber

289:
290:
291: BEGIN
292:
293: l_ci_id := wf_engine.GetItemAttrNumber
294: ( itemtype => itemtype,
295: itemkey => itemkey,
296: aname => 'CI_ID');
297:

Line 301: l_record_version_number := wf_engine.GetItemAttrNumber

297:
298:
299:
300:
301: l_record_version_number := wf_engine.GetItemAttrNumber
302: ( itemtype => itemtype,
303: itemkey => itemkey,
304: aname => 'RECORD_VERSION_NUMBER');
305:

Line 367: l_ci_id := wf_engine.GetItemAttrNumber

363: and ps.wf_failure_status_code is NOT NULL;
364:
365: BEGIN
366:
367: l_ci_id := wf_engine.GetItemAttrNumber
368: ( itemtype => itemtype,
369: itemkey => itemkey,
370: aname => 'CI_ID');
371:

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

368: ( itemtype => itemtype,
369: itemkey => itemkey,
370: aname => 'CI_ID');
371:
372: --debug_msg_s1 ('AAAAAAAAAAA report rejected' || WF_ENGINE.context_text);
373:
374: l_comment := wf_engine.GetItemAttrText
375: ( itemtype => itemtype,
376: itemkey => itemkey,

Line 374: l_comment := wf_engine.GetItemAttrText

370: aname => 'CI_ID');
371:
372: --debug_msg_s1 ('AAAAAAAAAAA report rejected' || WF_ENGINE.context_text);
373:
374: l_comment := wf_engine.GetItemAttrText
375: ( itemtype => itemtype,
376: itemkey => itemkey,
377: aname => 'COMMENT');
378:

Line 379: l_name := wf_engine.GetItemAttrText( itemtype

375: ( itemtype => itemtype,
376: itemkey => itemkey,
377: aname => 'COMMENT');
378:
379: l_name := wf_engine.GetItemAttrText( itemtype
380: , itemkey
381: , 'CI_APPROVER_NAME');
382:
383:

Line 384: l_record_version_number := wf_engine.GetItemAttrNumber

380: , itemkey
381: , 'CI_APPROVER_NAME');
382:
383:
384: l_record_version_number := wf_engine.GetItemAttrNumber
385: ( itemtype => itemtype,
386: itemkey => itemkey,
387: aname => 'RECORD_VERSION_NUMBER');
388:

Line 490: l_ci_id := wf_engine.GetItemAttrNumber

486:
487:
488: BEGIN
489:
490: l_ci_id := wf_engine.GetItemAttrNumber
491: ( itemtype => itemtype,
492: itemkey => itemkey,
493: aname => 'CI_ID');
494:

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

492: itemkey => itemkey,
493: aname => 'CI_ID');
494:
495:
496: -- debug_msg_s1 ('AAAAAAAAAAA report approved ' || WF_ENGINE.context_text);
497:
498: l_comment := wf_engine.GetItemAttrText
499: ( itemtype => itemtype,
500: itemkey => itemkey,

Line 498: l_comment := wf_engine.GetItemAttrText

494:
495:
496: -- debug_msg_s1 ('AAAAAAAAAAA report approved ' || WF_ENGINE.context_text);
497:
498: l_comment := wf_engine.GetItemAttrText
499: ( itemtype => itemtype,
500: itemkey => itemkey,
501: aname => 'COMMENT');
502:

Line 503: l_name := wf_engine.GetItemAttrText( itemtype

499: ( itemtype => itemtype,
500: itemkey => itemkey,
501: aname => 'COMMENT');
502:
503: l_name := wf_engine.GetItemAttrText( itemtype
504: , itemkey
505: , 'CI_APPROVER_NAME');
506:
507: -- Added for Bug 6053648

Line 528: l_record_version_number := wf_engine.GetItemAttrNumber

524:
525:
526: -- debug_msg_s1 ('AAAAAAAAAAA report approved approver name' || l_name);
527:
528: l_record_version_number := wf_engine.GetItemAttrNumber
529: ( itemtype => itemtype,
530: itemkey => itemkey,
531: aname => 'RECORD_VERSION_NUMBER');
532:

Line 619: l_proj_mgr_id := wf_engine.GetItemAttrNumber

615: WHERE user_id = FND_GLOBAL.user_id;
616:
617: BEGIN
618:
619: l_proj_mgr_id := wf_engine.GetItemAttrNumber
620: ( itemtype => itemtype,
621: itemkey => itemkey,
622: aname => 'PROJ_MGR_ID');
623:

Line 624: l_submitter_id := wf_engine.GetItemAttrNumber

620: ( itemtype => itemtype,
621: itemkey => itemkey,
622: aname => 'PROJ_MGR_ID');
623:
624: l_submitter_id := wf_engine.GetItemAttrNumber
625: ( itemtype => itemtype,
626: itemkey => itemkey,
627: aname => 'SUBMITTED_BY_ID');
628:

Line 649: wf_engine.SetItemAttrText( itemtype

645: ,'');
646:
647: IF l_submitter_id = l_proj_mgr_id THEN
648:
649: wf_engine.SetItemAttrText( itemtype
650: , itemkey
651: , 'CI_APPROVER_NAME'
652: , l_user_name);
653:

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

650: , itemkey
651: , 'CI_APPROVER_NAME'
652: , l_user_name);
653:
654: resultout := wf_engine.eng_completed||':'||'T';
655: ELSE
656:
657: resultout := wf_engine.eng_completed||':'||'F';
658: END IF;

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

653:
654: resultout := wf_engine.eng_completed||':'||'T';
655: ELSE
656:
657: resultout := wf_engine.eng_completed||':'||'F';
658: END IF;
659:
660:
661: END;

Line 686: l_ci_id := wf_engine.GetItemAttrNumber

682:
683:
684: BEGIN
685:
686: l_ci_id := wf_engine.GetItemAttrNumber
687: ( itemtype => itemtype,
688: itemkey => itemkey,
689: aname => 'CI_ID');
690:

Line 696: wf_engine.SetItemAttrText

692: FETCH get_status INTO l_status;
693:
694: CLOSE get_status;
695:
696: wf_engine.SetItemAttrText
697: ( itemtype,
698: itemkey,
699: 'STATUS_CODE',
700: l_status);

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

700: l_status);
701:
702:
703: IF l_status = 'CI_APPROVED' THEN
704: resultout := wf_engine.eng_completed||':'||'APPROVED';
705: ELSIF l_status = 'CI_REJECTED' THEN
706: resultout := wf_engine.eng_completed||':'||'REJECTED';
707: END IF;
708:

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

702:
703: IF l_status = 'CI_APPROVED' THEN
704: resultout := wf_engine.eng_completed||':'||'APPROVED';
705: ELSIF l_status = 'CI_REJECTED' THEN
706: resultout := wf_engine.eng_completed||':'||'REJECTED';
707: END IF;
708:
709:
710: -- added by syao

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

731: IS
732: BEGIN
733:
734: resultout:='COMPLETE:'||'SUCCESS';
735: --resultout := wf_engine.eng_completed||':'||'T';
736:
737: END;
738:
739: PROCEDURE forward_notification(

Line 797: l_comment := wf_engine.GetItemAttrText

793:
794: --debug_msg_s1 ('call forward AAAAAAAAAAA' || funcmode);
795:
796: IF funcmode = 'RUN' then
797: l_comment := wf_engine.GetItemAttrText
798: ( itemtype => itemtype,
799: itemkey => itemkey,
800: aname => 'COMMENT');
801:

Line 806: l_forward_to := wf_engine.GetItemAttrText

802: --debug_msg_s1 ('forward AAAAAAAAAAA get approval comment' || funcmode);
803: --debug_msg_s1 ('forward AAAAAAAAAAA get approval comment' || actid);
804:
805:
806: l_forward_to := wf_engine.GetItemAttrText
807: ( itemtype => itemtype,
808: itemkey => itemkey,
809: aname => 'FORWARD_TO');
810:

Line 820: wf_engine.SetItemAttrText

816: -- the forward to is invalid
817: fnd_message.set_name ('PO', 'PO_WF_NOTIF_INVALID_FORWARD');
818: l_error_msg := fnd_message.get;
819:
820: wf_engine.SetItemAttrText
821: ( itemtype,
822: itemkey,
823: 'WRONG_FORWARD',
824: l_error_msg);

Line 847: wf_engine.SetItemAttrText( itemtype

843: END IF;
844:
845: --debug_msg_s1 ('forward AAAAAAAAAAA get approval comment: forward to = ' || l_forward_to);
846:
847: wf_engine.SetItemAttrText( itemtype
848: , itemkey
849: , 'CI_APPROVER'
850: , l_forward_to);
851:

Line 857: l_name := wf_engine.GetItemAttrText( itemtype

853: OPEN get_name ;
854: FETCH get_name INTO l_forward_to_name;
855: CLOSE get_name;
856:
857: l_name := wf_engine.GetItemAttrText( itemtype
858: , itemkey
859: , 'CI_APPROVER_NAME');
860:
861:

Line 863: wf_engine.SetItemAttrText( itemtype

859: , 'CI_APPROVER_NAME');
860:
861:
862:
863: wf_engine.SetItemAttrText( itemtype
864: , itemkey
865: , 'CI_APPROVER_NAME'
866: , l_forward_to);
867:

Line 877: wf_engine.SetItemAttrText

873: ,'FORWARD'
874: ,l_name
875: ,l_comment);
876:
877: wf_engine.SetItemAttrText
878: ( itemtype,
879: itemkey ,
880: 'COMMENT',
881: ''

Line 884: wf_engine.SetItemAttrText( itemtype

880: 'COMMENT',
881: ''
882: );
883:
884: wf_engine.SetItemAttrText( itemtype
885: , itemkey
886: , 'RESULT'
887: , '');
888:

Line 889: wf_engine.SetItemAttrText( itemtype

885: , itemkey
886: , 'RESULT'
887: , '');
888:
889: wf_engine.SetItemAttrText( itemtype
890: , itemkey
891: , 'FORWARD_TO'
892: , '');
893:

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

896:
897:
898: resultout:='COMPLETE:'||'SUCCESS';
899:
900: --resultout := wf_engine.eng_completed||':'||'T';
901:
902:
903: END;
904:

Line 1129: WF_ENGINE.CreateProcess(p_item_type

1125: pa_debug.g_err_stage:= 'x_item_key = '|| x_item_key;
1126: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
1127: END IF;
1128: -- create the workflow process
1129: WF_ENGINE.CreateProcess(p_item_type
1130: ,x_item_key
1131: ,p_process_name);
1132:
1133:

Line 1165: WF_ENGINE.StartProcess(p_item_type

1161: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
1162: END IF;
1163:
1164:
1165: WF_ENGINE.StartProcess(p_item_type
1166: ,x_item_key);
1167:
1168: PA_WORKFLOW_UTILS.Insert_WF_Processes
1169: (p_wf_type_code => l_wf_type_code

Line 1182: WF_ENGINE.AbortProcess(p_Item_Type

1178: );
1179:
1180: IF l_err_code <> 0 THEN
1181: -- abort the workflow process just launched, there is a problem
1182: WF_ENGINE.AbortProcess(p_Item_Type
1183: ,l_Item_Key);
1184:
1185: --Log an error message and go to exception section.
1186: PA_UTILS.Add_Message( p_app_short_name => 'PA'

Line 1515: wf_engine.SetItemAttrText( p_item_type

1511: RAISE Invalid_Arg_Exc_CI;
1512: END IF;
1513:
1514: -- Set the workflow attributes.
1515: wf_engine.SetItemAttrText( p_item_type
1516: ,p_item_key
1517: ,'ITEM_TYPE'
1518: ,p_item_type);
1519:

Line 1520: wf_engine.SetItemAttrText( p_item_type

1516: ,p_item_key
1517: ,'ITEM_TYPE'
1518: ,p_item_type);
1519:
1520: wf_engine.SetItemAttrText( p_item_type
1521: ,p_item_key
1522: ,'ITEM_KEY'
1523: ,p_item_key);
1524:

Line 1525: wf_engine.SetItemAttrNumber( p_item_type

1521: ,p_item_key
1522: ,'ITEM_KEY'
1523: ,p_item_key);
1524:
1525: wf_engine.SetItemAttrNumber( p_item_type
1526: , p_item_key
1527: , 'CI_ID'
1528: , p_ci_id);
1529:

Line 1535: wf_engine.SetItemAttrNumber(p_item_type

1531:
1532: pa_utils.getprojinfo(rec.project_id, l_project_number, l_project_name);
1533: l_owner_id := rec.owner_id;
1534:
1535: wf_engine.SetItemAttrNumber(p_item_type
1536: , p_item_key
1537: , 'PROJECT_ID'
1538: , rec.project_id);
1539:

Line 1540: wf_engine.SetItemAttrText( p_item_type

1536: , p_item_key
1537: , 'PROJECT_ID'
1538: , rec.project_id);
1539:
1540: wf_engine.SetItemAttrText( p_item_type
1541: , p_item_key
1542: , 'PROJECT_NAME'
1543: , l_project_name);
1544:

Line 1545: wf_engine.SetItemAttrText( p_item_type

1541: , p_item_key
1542: , 'PROJECT_NAME'
1543: , l_project_name);
1544:
1545: wf_engine.SetItemAttrText( p_item_type
1546: , p_item_key
1547: , 'PROJECT_NUMBER'
1548: , l_project_number);
1549:

Line 1550: wf_engine.SetItemAttrText( p_item_type

1546: , p_item_key
1547: , 'PROJECT_NUMBER'
1548: , l_project_number);
1549:
1550: wf_engine.SetItemAttrText( p_item_type
1551: , p_item_key
1552: , 'PROJECT'
1553: , l_project_name||'('||l_project_number||')');
1554:

Line 1555: wf_engine.SetItemAttrDate( p_item_type

1551: , p_item_key
1552: , 'PROJECT'
1553: , l_project_name||'('||l_project_number||')');
1554:
1555: wf_engine.SetItemAttrDate( p_item_type
1556: , p_item_key
1557: , 'DATE_REQUIRED'
1558: , rec.date_required);
1559:

Line 1560: wf_engine.SetItemAttrText( p_item_type

1556: , p_item_key
1557: , 'DATE_REQUIRED'
1558: , rec.date_required);
1559:
1560: wf_engine.SetItemAttrText( p_item_type
1561: , p_item_key
1562: , 'SUMMARY'
1563: , rec.summary);
1564:

Line 1565: wf_engine.SetItemAttrText( p_item_type

1561: , p_item_key
1562: , 'SUMMARY'
1563: , rec.summary);
1564:
1565: wf_engine.SetItemAttrText( p_item_type
1566: , p_item_key
1567: , 'CONTROL_ITEM_TYPE'
1568: , rec.ci_type_name);
1569:

Line 1570: wf_engine.SetItemAttrText( p_item_type

1566: , p_item_key
1567: , 'CONTROL_ITEM_TYPE'
1568: , rec.ci_type_name);
1569:
1570: wf_engine.SetItemAttrText( p_item_type
1571: , p_item_key
1572: , 'CONTROL_ITEM_TYPE_SN'
1573: , rec.ci_type_sn);
1574:

Line 1575: wf_engine.SetItemAttrText( p_item_type

1571: , p_item_key
1572: , 'CONTROL_ITEM_TYPE_SN'
1573: , rec.ci_type_sn);
1574:
1575: wf_engine.SetItemAttrText( p_item_type
1576: , p_item_key
1577: , 'CONTROL_ITEM_NUMBER'
1578: , rec.ci_number);
1579:

Line 1580: wf_engine.SetItemAttrText( p_item_type

1576: , p_item_key
1577: , 'CONTROL_ITEM_NUMBER'
1578: , rec.ci_number);
1579:
1580: wf_engine.SetItemAttrText( p_item_type
1581: , p_item_key
1582: , 'CONTROL_ITEM_CLASS'
1583: , rec.ci_type_class);
1584:

Line 1593: wf_engine.SetItemAttrText( p_item_type

1589: close get_lookup_meaning;
1590: else
1591: l_priority_name := null;
1592: end if;
1593: wf_engine.SetItemAttrText( p_item_type
1594: , p_item_key
1595: , 'PRIORITY'
1596: , l_priority_name);
1597:

Line 1598: wf_engine.SetItemAttrText( p_item_type

1594: , p_item_key
1595: , 'PRIORITY'
1596: , l_priority_name);
1597:
1598: wf_engine.SetItemAttrText( p_item_type
1599: , p_item_key
1600: , 'CLASSIFICATION'
1601: , rec.classification);
1602:

Line 1607: wf_engine.SetItemAttrText( p_item_type

1603: -- set project manager, organization name and customer
1604: OPEN get_project_info(rec.project_id);
1605: FETCH get_project_info INTO l_customer,l_project_manager, l_org;
1606:
1607: wf_engine.SetItemAttrText( p_item_type
1608: , p_item_key
1609: , 'PROJECT_MANAGER'
1610: , l_project_manager);
1611:

Line 1613: wf_engine.SetItemAttrText( p_item_type

1609: , 'PROJECT_MANAGER'
1610: , l_project_manager);
1611:
1612:
1613: wf_engine.SetItemAttrText( p_item_type
1614: , p_item_key
1615: , 'ORGANIZATION'
1616: , l_org);
1617:

Line 1618: wf_engine.SetItemAttrText( p_item_type

1614: , p_item_key
1615: , 'ORGANIZATION'
1616: , l_org);
1617:
1618: wf_engine.SetItemAttrText( p_item_type
1619: , p_item_key
1620: , 'CUSTOMER'
1621: , l_customer);
1622: CLOSE get_project_info;

Line 1631: wf_engine.SetItemAttrText( p_item_type

1627: l_url := 'JSP:/OA_HTML/OA.jsp?'||'page=/oracle/apps/pa/ci/webui/CiCiReviewPG' ||
1628: '&addBreadCrumb=N&paCiId='||p_ci_id || '&paProjectId=' || rec.project_id ||
1629: '&paCITypeClassCode=' || rec.ci_type_class_code|| '&paNotificationId=-&#NID-';
1630:
1631: wf_engine.SetItemAttrText( p_item_type
1632: , p_item_key
1633: , 'CI_LINK'
1634: , l_url);
1635: --end if;

Line 1643: wf_engine.SetItemAttrText( p_item_type

1639: fetch get_comment_text into l_comment_text;
1640: close get_comment_text;
1641:
1642:
1643: wf_engine.SetItemAttrText( p_item_type
1644: , p_item_key
1645: , 'COMMENT'
1646: , l_comment_text);
1647: end if;

Line 1660: wf_engine.SetItemAttrText( p_item_type

1656: l_ci_owner_id,
1657: l_ci_owner_name;
1658: close cur_ci_status_n_owner; /* Added for Bug#4124900 */
1659:
1660: wf_engine.SetItemAttrText( p_item_type
1661: , p_item_key
1662: , 'CI_STATUS_CODE'
1663: , l_ci_status_code);
1664:

Line 1665: wf_engine.SetItemAttrText( p_item_type

1661: , p_item_key
1662: , 'CI_STATUS_CODE'
1663: , l_ci_status_code);
1664:
1665: wf_engine.SetItemAttrText( p_item_type
1666: , p_item_key
1667: , 'CI_STATUS'
1668: , l_ci_status_name);
1669:

Line 1670: wf_engine.SetItemAttrNumber( p_item_type

1666: , p_item_key
1667: , 'CI_STATUS'
1668: , l_ci_status_name);
1669:
1670: wf_engine.SetItemAttrNumber( p_item_type
1671: , p_item_key
1672: , 'CI_OWNER_ID'
1673: , l_ci_owner_id);
1674:

Line 1675: wf_engine.SetItemAttrText( p_item_type

1671: , p_item_key
1672: , 'CI_OWNER_ID'
1673: , l_ci_owner_id);
1674:
1675: wf_engine.SetItemAttrText( p_item_type
1676: , p_item_key
1677: , 'CI_OWNER_NAME'
1678: , l_ci_owner_name);
1679: --Changes for the bug# 3691192 ends

Line 1698: wf_engine.SetItemAttrNumber( p_item_type

1694: l_action_status_meaning,
1695: l_sign_off_req_flag,
1696: l_sign_off_req_meaning; --FP.M.IB1 Sanity
1697:
1698: wf_engine.SetItemAttrNumber( p_item_type
1699: , p_item_key
1700: , 'ACTION_ID'
1701: , p_action_id);
1702:

Line 1703: wf_engine.SetItemAttrNumber( p_item_type

1699: , p_item_key
1700: , 'ACTION_ID'
1701: , p_action_id);
1702:
1703: wf_engine.SetItemAttrNumber( p_item_type
1704: , p_item_key
1705: , 'RECORD_VERSION_NUMBER'
1706: , l_record_version_number);
1707:

Line 1708: wf_engine.SetItemAttrNumber( p_item_type

1704: , p_item_key
1705: , 'RECORD_VERSION_NUMBER'
1706: , l_record_version_number);
1707:
1708: wf_engine.SetItemAttrNumber( p_item_type
1709: , p_item_key
1710: , 'ACTION_NUMBER'
1711: , l_action_number);
1712:

Line 1713: wf_engine.SetItemAttrText( p_item_type

1709: , p_item_key
1710: , 'ACTION_NUMBER'
1711: , l_action_number);
1712:
1713: wf_engine.SetItemAttrText( p_item_type
1714: , p_item_key
1715: , 'ACTION_REQUEST'
1716: , l_action_request);
1717:

Line 1719: wf_engine.SetItemAttrText( p_item_type

1715: , 'ACTION_REQUEST'
1716: , l_action_request);
1717:
1718:
1719: wf_engine.SetItemAttrText( p_item_type
1720: , p_item_key
1721: , 'ACTION_REQUESTOR'
1722: , l_action_requestor);
1723:

Line 1724: wf_engine.SetItemAttrDate( p_item_type

1720: , p_item_key
1721: , 'ACTION_REQUESTOR'
1722: , l_action_requestor);
1723:
1724: wf_engine.SetItemAttrDate( p_item_type
1725: , p_item_key
1726: , 'ACTION_DATE_REQUIRED'
1727: , l_action_date_required);
1728:

Line 1729: wf_engine.SetItemAttrNumber( p_item_type

1725: , p_item_key
1726: , 'ACTION_DATE_REQUIRED'
1727: , l_action_date_required);
1728:
1729: wf_engine.SetItemAttrNumber( p_item_type
1730: , p_item_key
1731: , 'ASSIGN_PARTY_ID'
1732: , l_assign_party_id);
1733:

Line 1737: wf_engine.SetItemAttrText( p_item_type

1733:
1734:
1735: --Changes for the bug# 3691192 starts
1736: -- Follwing are the new Item Attributes added in the workflow PAWFCIAC
1737: wf_engine.SetItemAttrText( p_item_type
1738: , p_item_key
1739: , 'ACTION_TYPE_CODE'
1740: , l_action_type_code);
1741:

Line 1742: wf_engine.SetItemAttrText( p_item_type

1738: , p_item_key
1739: , 'ACTION_TYPE_CODE'
1740: , l_action_type_code);
1741:
1742: wf_engine.SetItemAttrText( p_item_type
1743: , p_item_key
1744: , 'ACTION_TYPE'
1745: , l_action_type);
1746:

Line 1748: wf_engine.SetItemAttrDate( p_item_type

1744: , 'ACTION_TYPE'
1745: , l_action_type);
1746:
1747:
1748: wf_engine.SetItemAttrDate( p_item_type
1749: , p_item_key
1750: , 'SYSDATE'
1751: , sysdate);
1752:

Line 1753: wf_engine.SetItemAttrDate( p_item_type

1749: , p_item_key
1750: , 'SYSDATE'
1751: , sysdate);
1752:
1753: wf_engine.SetItemAttrDate( p_item_type
1754: , p_item_key
1755: , 'LAST_UPDATE_DATE'
1756: , l_last_updated);
1757:

Line 1758: wf_engine.SetItemAttrText( p_item_type

1754: , p_item_key
1755: , 'LAST_UPDATE_DATE'
1756: , l_last_updated);
1757:
1758: wf_engine.SetItemAttrText( p_item_type
1759: , p_item_key
1760: , 'ACTION_STATUS_CODE'
1761: , l_action_status_code);
1762:

Line 1763: wf_engine.SetItemAttrText( p_item_type

1759: , p_item_key
1760: , 'ACTION_STATUS_CODE'
1761: , l_action_status_code);
1762:
1763: wf_engine.SetItemAttrText( p_item_type
1764: , p_item_key
1765: , 'ACTION_STATUS'
1766: , l_action_status_meaning);
1767:

Line 1768: wf_engine.SetItemAttrText( p_item_type

1764: , p_item_key
1765: , 'ACTION_STATUS'
1766: , l_action_status_meaning);
1767:
1768: wf_engine.SetItemAttrText( p_item_type
1769: , p_item_key
1770: , 'SIGN_OFF_REQUESTED_FLAG'
1771: , l_sign_off_req_flag);
1772:

Line 1773: wf_engine.SetItemAttrText( p_item_type

1769: , p_item_key
1770: , 'SIGN_OFF_REQUESTED_FLAG'
1771: , l_sign_off_req_flag);
1772:
1773: wf_engine.SetItemAttrText( p_item_type
1774: , p_item_key
1775: , 'SIGN_OFF_REQUESTED'
1776: , l_sign_off_req_meaning);
1777:

Line 1801: wf_engine.SetItemAttrText( p_item_type

1797: '&addBreadCrumb=N&paCiId='||p_ci_id || '&paProjectId=' || rec.project_id || '&paCiActionId='
1798: || p_action_id || '&paCITypeClassCode=' || rec.ci_type_class_code || '&paNotificationId=-&#NID-';*/
1799:
1800: --Set the closure comment if it is action closure.
1801: wf_engine.SetItemAttrText( p_item_type
1802: , p_item_key
1803: , 'ACTION_CLOSURE_COMMENT'
1804: , l_action_closure_comment);
1805: end if;

Line 1809: wf_engine.SetItemAttrText( p_item_type

1805: end if;
1806:
1807: -- New item attribute added in the workflow PAWFCIAC for the bug# 3691192
1808: if (l_act_url is not null) then
1809: wf_engine.SetItemAttrText( p_item_type
1810: , p_item_key
1811: , 'CI_ACT_LINK'
1812: , l_act_url);
1813: end if;

Line 1911: wf_engine.SetItemAttrText( p_item_type

1907:
1908: IF (l_role_users is NOT NULL) THEN
1909: WF_DIRECTORY.AddUsersToAdHocRole( l_role, l_role_users);
1910:
1911: wf_engine.SetItemAttrText( p_item_type
1912: , p_item_key
1913: , 'CI_NOTIFICATION_PARTY'
1914: , l_role);
1915: END IF;

Line 2083: l_ci_id := wf_engine.GetItemAttrNumber

2079: -- Initialize the Error Stack
2080: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_WORKFLOW.CLOSE_CI_ACTION');
2081:
2082:
2083: l_ci_id := wf_engine.GetItemAttrNumber
2084: ( itemtype => itemtype,
2085: itemkey => itemkey,
2086: aname => 'CI_ID');
2087:

Line 2088: l_ci_action_id := wf_engine.GetItemAttrNumber

2084: ( itemtype => itemtype,
2085: itemkey => itemkey,
2086: aname => 'CI_ID');
2087:
2088: l_ci_action_id := wf_engine.GetItemAttrNumber
2089: ( itemtype => itemtype,
2090: itemkey => itemkey,
2091: aname => 'ACTION_ID');
2092:

Line 2093: l_record_version_number := wf_engine.GetItemAttrNumber

2089: ( itemtype => itemtype,
2090: itemkey => itemkey,
2091: aname => 'ACTION_ID');
2092:
2093: l_record_version_number := wf_engine.GetItemAttrNumber
2094: ( itemtype => itemtype,
2095: itemkey => itemkey,
2096: aname => 'RECORD_VERSION_NUMBER');
2097:

Line 2098: l_comment_text := wf_engine.GetItemAttrText

2094: ( itemtype => itemtype,
2095: itemkey => itemkey,
2096: aname => 'RECORD_VERSION_NUMBER');
2097:
2098: l_comment_text := wf_engine.GetItemAttrText
2099: ( itemtype => itemtype,
2100: itemkey => itemkey,
2101: aname => 'COMMENT');
2102:

Line 2103: l_comment_text := wf_engine.GetItemAttrText

2099: ( itemtype => itemtype,
2100: itemkey => itemkey,
2101: aname => 'COMMENT');
2102:
2103: l_comment_text := wf_engine.GetItemAttrText
2104: ( itemtype => itemtype,
2105: itemkey => itemkey,
2106: aname => 'COMMENT');
2107: --Added for Bug# 3802238

Line 2108: l_user_sign_off := wf_engine.GetItemAttrText

2104: ( itemtype => itemtype,
2105: itemkey => itemkey,
2106: aname => 'COMMENT');
2107: --Added for Bug# 3802238
2108: l_user_sign_off := wf_engine.GetItemAttrText
2109: ( itemtype => itemtype,
2110: itemkey => itemkey,
2111: aname => 'SIGN_OFF');
2112:

Line 2113: l_assign_party_id := wf_engine.GetItemAttrNumber

2109: ( itemtype => itemtype,
2110: itemkey => itemkey,
2111: aname => 'SIGN_OFF');
2112:
2113: l_assign_party_id := wf_engine.GetItemAttrNumber
2114: ( itemtype => itemtype,
2115: itemkey => itemkey,
2116: aname => 'ASSIGN_PARTY_ID');
2117:

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

2124: l_created_by, l_creation_date;
2125: IF ci_action%NOTFOUND THEN
2126: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2127: ,p_msg_name => 'PA_NO_ACTION_FOUND');
2128: resultout := wf_engine.eng_completed||':'||'F';
2129: CLOSE ci_action;
2130: return;
2131: END IF;
2132:

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

2135: FETCH check_record_changed INTO l_rowid;
2136: IF check_record_changed%NOTFOUND THEN
2137: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2138: ,p_msg_name => 'PA_PR_RECORD_CHANGED');
2139: resultout := wf_engine.eng_completed||':'||'F';
2140: CLOSE check_record_changed;
2141: return;
2142: END IF;
2143:

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

2222:
2223: -- Commit the changes if requested
2224: if l_return_status = fnd_api.g_ret_sts_success then
2225: commit;
2226: resultout := wf_engine.eng_completed||':'||'T';
2227: end if;
2228: commit;
2229:
2230:

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

2229:
2230:
2231: EXCEPTION WHEN FND_API.G_EXC_ERROR THEN
2232: ROLLBACK TO CLOSE_CI_ACTION;
2233: resultout := wf_engine.eng_completed||':'||'F';
2234: WHEN OTHERS THEN
2235: ROLLBACK TO CLOSE_CI_ACTION;
2236: resultout := wf_engine.eng_completed||':'||'F';
2237: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CONTROL_ITEMS_WORKFLOW',

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

2232: ROLLBACK TO CLOSE_CI_ACTION;
2233: resultout := wf_engine.eng_completed||':'||'F';
2234: WHEN OTHERS THEN
2235: ROLLBACK TO CLOSE_CI_ACTION;
2236: resultout := wf_engine.eng_completed||':'||'F';
2237: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CONTROL_ITEMS_WORKFLOW',
2238: p_procedure_name => 'CLOSE_CI_ACTIONS',
2239: p_error_text => SUBSTRB(SQLERRM,1,240));
2240: RAISE;

Line 2311: l_ci_id := wf_engine.GetItemAttrNumber

2307: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_WORKFLOW.KEEP_OPEN');
2308:
2309:
2310:
2311: l_ci_id := wf_engine.GetItemAttrNumber
2312: ( itemtype => itemtype,
2313: itemkey => itemkey,
2314: aname => 'CI_ID');
2315:

Line 2316: l_ci_action_id := wf_engine.GetItemAttrNumber

2312: ( itemtype => itemtype,
2313: itemkey => itemkey,
2314: aname => 'CI_ID');
2315:
2316: l_ci_action_id := wf_engine.GetItemAttrNumber
2317: ( itemtype => itemtype,
2318: itemkey => itemkey,
2319: aname => 'ACTION_ID');
2320:

Line 2321: l_record_version_number := wf_engine.GetItemAttrNumber

2317: ( itemtype => itemtype,
2318: itemkey => itemkey,
2319: aname => 'ACTION_ID');
2320:
2321: l_record_version_number := wf_engine.GetItemAttrNumber
2322: ( itemtype => itemtype,
2323: itemkey => itemkey,
2324: aname => 'RECORD_VERSION_NUMBER');
2325:

Line 2326: l_comment_text := wf_engine.GetItemAttrText

2322: ( itemtype => itemtype,
2323: itemkey => itemkey,
2324: aname => 'RECORD_VERSION_NUMBER');
2325:
2326: l_comment_text := wf_engine.GetItemAttrText
2327: ( itemtype => itemtype,
2328: itemkey => itemkey,
2329: aname => 'COMMENT');
2330:

Line 2331: l_assign_party_id := wf_engine.GetItemAttrNumber

2327: ( itemtype => itemtype,
2328: itemkey => itemkey,
2329: aname => 'COMMENT');
2330:
2331: l_assign_party_id := wf_engine.GetItemAttrNumber
2332: ( itemtype => itemtype,
2333: itemkey => itemkey,
2334: aname => 'ASSIGN_PARTY_ID');
2335:

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

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

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

2394:
2395:
2396: if l_return_status = fnd_api.g_ret_sts_success then
2397: commit;
2398: resultout := wf_engine.eng_completed||':'||'T';
2399: end if;
2400: commit;
2401: ELSE
2402: CLOSE is_comment_inserted_cur;

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

2403: END IF;
2404:
2405: EXCEPTION WHEN FND_API.G_EXC_ERROR THEN
2406: ROLLBACK TO KEEP_OPEN;
2407: resultout := wf_engine.eng_completed||':'||'F';
2408: WHEN OTHERS THEN
2409: ROLLBACK TO KEEP_OPEN;
2410: resultout := wf_engine.eng_completed||':'||'F';
2411: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CONTROL_ITEMS_WORKFLOW',

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

2406: ROLLBACK TO KEEP_OPEN;
2407: resultout := wf_engine.eng_completed||':'||'F';
2408: WHEN OTHERS THEN
2409: ROLLBACK TO KEEP_OPEN;
2410: resultout := wf_engine.eng_completed||':'||'F';
2411: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CONTROL_ITEMS_WORKFLOW',
2412: p_procedure_name => 'KEEP_OPEN',
2413: p_error_text => SUBSTRB(SQLERRM,1,240));
2414: RAISE;

Line 2507: l_sign_off_requested:= wf_engine.GetItemAttrText

2503: BEGIN
2504:
2505: x_return_status := FND_API.G_RET_STS_SUCCESS;
2506:
2507: l_sign_off_requested:= wf_engine.GetItemAttrText
2508: ( itemtype => p_item_type,
2509: itemkey => p_item_key,
2510: aname => 'SIGN_OFF_REQUESTED_FLAG');
2511: