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

Line 138: WF_ENGINE.SetItemAttrText(

134:
135: l_system_scheduled_date DATE;
136:
137: BEGIN
138: WF_ENGINE.SetItemAttrText(
139: itemtype => p_itemtype
140: , itemkey => p_itemkey
141: , aname => 'MONITOR_URL'
142: , avalue => wf_monitor.geturl(wf_core.TRANSLATE('WF_WEB_AGENT'), p_itemtype, p_itemkey, 'NO')

Line 149: WF_ENGINE.SetItemAttrNumber(

145: IF (AMS_DEBUG_HIGH_ON) THEN
146: AMS_Utility_PVT.debug_message ('URL: ' || wf_monitor.geturl(wf_core.TRANSLATE('WF_WEB_AGENT'), p_itemtype, p_itemkey, 'NO'));
147: END IF;
148:
149: WF_ENGINE.SetItemAttrNumber(
150: itemtype => p_itemtype
151: , itemkey => p_itemkey
152: , aname => 'OBJECT_ID'
153: , avalue => p_object_id

Line 156: WF_ENGINE.SetItemAttrText(

152: , aname => 'OBJECT_ID'
153: , avalue => p_object_id
154: );
155:
156: WF_ENGINE.SetItemAttrText(
157: itemtype => p_itemtype
158: , itemkey => p_itemkey
159: , aname => 'OBJECT_TYPE'
160: , avalue => p_object_type

Line 163: WF_ENGINE.SetItemAttrNumber(

159: , aname => 'OBJECT_TYPE'
160: , avalue => p_object_type
161: );
162:
163: WF_ENGINE.SetItemAttrNumber(
164: itemtype => p_itemtype
165: , itemkey => p_itemkey
166: , aname => 'ORIG_USER_STATUS_ID'
167: , avalue => p_user_status_id

Line 191: WF_ENGINE.SetItemAttrDate(

187: IF (AMS_DEBUG_HIGH_ON) THEN
188: AMS_Utility_PVT.debug_message ('SYSTEM SCHEDULED - WAIT: ' || TO_CHAR (l_system_scheduled_date, 'DD-MON-RRRR HH24:MI:SS'));
189: END IF;
190:
191: WF_ENGINE.SetItemAttrDate(
192: itemtype => p_itemtype
193: , itemkey => p_itemkey
194: , aname => 'SCHEDULE_DATE'
195: , avalue => l_system_scheduled_date

Line 199: WF_ENGINE.SetItemAttrText(

195: , avalue => l_system_scheduled_date
196: );
197:
198: IF p_request_type IS NULL THEN
199: WF_ENGINE.SetItemAttrText(
200: itemtype => p_itemtype
201: , itemkey => p_itemkey
202: , aname => 'REQUEST_TYPE'
203: , avalue => ' '

Line 206: WF_ENGINE.SetItemAttrText(

202: , aname => 'REQUEST_TYPE'
203: , avalue => ' '
204: );
205: ELSE
206: WF_ENGINE.SetItemAttrText(
207: itemtype => p_itemtype
208: , itemkey => p_itemkey
209: , aname => 'REQUEST_TYPE'
210: , avalue => p_request_type

Line 215: WF_ENGINE.SetItemAttrText(

211: );
212: END IF;
213:
214:
215: WF_ENGINE.SetItemAttrText(
216: itemtype => p_itemtype
217: , itemkey => p_itemkey
218: , aname => 'SELECT_LIST'
219: , avalue => p_select_list

Line 224: WF_ENGINE.SetItemAttrText(

220: );
221:
222: /* If PREVIEW request, then set the STATUS_CODE variable to PREVIEWING */
223: IF p_request_type = G_PREVIEW_REQUEST THEN
224: WF_ENGINE.SetItemAttrText(
225: itemtype => p_itemtype
226: , itemkey => p_itemkey
227: , aname => 'STATUS_CODE'
228: , avalue => G_STATUS_PREVIEWING

Line 233: WF_ENGINE.SetItemAttrText(

229: );
230: ELSE
231: /* Set status to BUILDING or SCORING as per object_type */
232: IF p_object_type = G_OBJECT_TYPE_MODEL THEN
233: WF_ENGINE.SetItemAttrText(
234: itemtype => p_itemtype
235: , itemkey => p_itemkey
236: , aname => 'STATUS_CODE'
237: , avalue => G_STATUS_BUILDING

Line 240: WF_ENGINE.SetItemAttrText(

236: , aname => 'STATUS_CODE'
237: , avalue => G_STATUS_BUILDING
238: );
239: ELSIF p_object_type = G_OBJECT_TYPE_SCORE THEN
240: WF_ENGINE.SetItemAttrText(
241: itemtype => p_itemtype
242: , itemkey => p_itemkey
243: , aname => 'STATUS_CODE'
244: , avalue => G_STATUS_SCORING

Line 252: AMS_Utility_PVT.debug_message ('STATUS_CODE: ' || WF_ENGINE.GetItemAttrText(itemtype => p_itemtype, itemkey => p_itemkey, aname => 'STATUS_CODE'));

248:
249: IF (AMS_DEBUG_HIGH_ON) THEN
250: AMS_Utility_PVT.debug_message ('REQUEST_TYPE: ' || p_request_type);
251: AMS_Utility_PVT.debug_message ('ORIG_USER_STATUS_ID: ' || p_user_status_id);
252: AMS_Utility_PVT.debug_message ('STATUS_CODE: ' || WF_ENGINE.GetItemAttrText(itemtype => p_itemtype, itemkey => p_itemkey, aname => 'STATUS_CODE'));
253: END IF;
254:
255: END Initialize_Var ;
256:

Line 391: WF_ENGINE.CreateProcess ( itemtype => l_itemtype

387: Ams_Utility_pvt.debug_message('ITEMTYPE: ' || l_itemtype || ' - ITEMKEY: ' || itemkey);
388: END IF;
389:
390: -- dbms_output.put_line('Start');
391: WF_ENGINE.CreateProcess ( itemtype => l_itemtype
392: , itemkey => itemkey
393: , process => 'MODEL_BUILD_SCORE'
394: );
395:

Line 410: Wf_Engine.SetItemOwner(itemtype => itemtype,

406: , p_itemkey => itemkey
407: );
408:
409: -- srivikri - bug4305459 04/22/05- setting item owner
410: Wf_Engine.SetItemOwner(itemtype => itemtype,
411: itemkey => itemkey,
412: owner => l_owner_role);
413:
414: WF_ENGINE.StartProcess ( itemtype => l_itemtype

Line 414: WF_ENGINE.StartProcess ( itemtype => l_itemtype

410: Wf_Engine.SetItemOwner(itemtype => itemtype,
411: itemkey => itemkey,
412: owner => l_owner_role);
413:
414: WF_ENGINE.StartProcess ( itemtype => l_itemtype
415: , itemkey => itemkey
416: );
417:
418: -- return to calling procedure

Line 487: l_object_id := WF_ENGINE.GetItemAttrNumber(

483: l_return_status VARCHAR2(1);
484: l_object_id NUMBER;
485: l_object_type VARCHAR2(30);
486: BEGIN
487: l_object_id := WF_ENGINE.GetItemAttrNumber(
488: itemtype => itemtype
489: , itemkey => itemkey
490: , aname => 'OBJECT_ID'
491: );

Line 493: l_object_type := WF_ENGINE.GetItemAttrText (

489: , itemkey => itemkey
490: , aname => 'OBJECT_ID'
491: );
492:
493: l_object_type := WF_ENGINE.GetItemAttrText (
494: itemtype => itemtype
495: , itemkey => itemkey
496: , aname => 'OBJECT_TYPE'
497: );

Line 629: l_object_id := WF_ENGINE.GetItemAttrNumber(

625: l_owner_role VARCHAR2(80);
626: l_owner_role_name VARCHAR2(120);
627: l_target_active_flag VARCHAR2(1);
628: BEGIN
629: l_object_id := WF_ENGINE.GetItemAttrNumber(
630: itemtype => itemtype
631: , itemkey => itemkey
632: , aname => 'OBJECT_ID'
633: );

Line 635: l_object_type := WF_ENGINE.GetItemAttrText (

631: , itemkey => itemkey
632: , aname => 'OBJECT_ID'
633: );
634:
635: l_object_type := WF_ENGINE.GetItemAttrText (
636: itemtype => itemtype
637: , itemkey => itemkey
638: , aname => 'OBJECT_TYPE'
639: );

Line 726: WF_ENGINE.SetItemAttrText (

722: IF (AMS_DEBUG_HIGH_ON) THEN
723: AMS_Utility_PVT.debug_message (L_API_NAME || ' - Get_User_Role Succeeded. ' );
724: END IF;
725:
726: WF_ENGINE.SetItemAttrText (
727: itemtype => itemtype
728: , itemkey => itemkey
729: , aname => 'OWNER_USERNAME'
730: , avalue => l_owner_role );

Line 733: WF_ENGINE.SetItemAttrText(

729: , aname => 'OWNER_USERNAME'
730: , avalue => l_owner_role );
731:
732:
733: WF_ENGINE.SetItemAttrText(
734: itemtype => itemtype
735: , itemkey => itemkey
736: , aname => 'MODEL_TYPE'
737: , avalue => l_model_type

Line 739: WF_ENGINE.SetItemAttrNumber(

735: , itemkey => itemkey
736: , aname => 'MODEL_TYPE'
737: , avalue => l_model_type
738: );
739: WF_ENGINE.SetItemAttrNumber(
740: itemtype => itemtype
741: , itemkey => itemkey
742: , aname => 'DATA_SOURCE_ID'
743: , avalue => l_data_source_id

Line 745: WF_ENGINE.SetItemAttrNumber(

741: , itemkey => itemkey
742: , aname => 'DATA_SOURCE_ID'
743: , avalue => l_data_source_id
744: );
745: WF_ENGINE.SetItemAttrNumber(
746: itemtype => itemtype
747: , itemkey => itemkey
748: , aname => 'TARGET_POSITIVE_VALUE'
749: , avalue => l_target_positive_value

Line 752: WF_ENGINE.SetItemAttrText(

748: , aname => 'TARGET_POSITIVE_VALUE'
749: , avalue => l_target_positive_value
750: );
751:
752: WF_ENGINE.SetItemAttrText(
753: itemtype => itemtype
754: , itemkey => itemkey
755: , aname => 'NAME'
756: , avalue => l_name

Line 796: WF_ENGINE.SetItemAttrText(

792:
793: wf_core.context(G_PKG_NAME,'Validate', itemtype,itemkey,to_char(actid),funcmode);
794:
795: /* populate status to DRAFT */
796: WF_ENGINE.SetItemAttrText(
797: itemtype => itemtype
798: , itemkey => itemkey
799: , aname => 'STATUS_CODE'
800: , avalue => G_STATUS_DRAFT

Line 852: l_object_id := WF_ENGINE.GetItemAttrNumber(

848: l_message VARCHAR2(4000);
849: l_object_id NUMBER;
850: l_object_type VARCHAR2(30);
851: BEGIN
852: l_object_id := WF_ENGINE.GetItemAttrNumber(
853: itemtype => itemtype
854: , itemkey => itemkey
855: , aname => 'OBJECT_ID'
856: );

Line 858: l_object_type := WF_ENGINE.GetItemAttrText (

854: , itemkey => itemkey
855: , aname => 'OBJECT_ID'
856: );
857:
858: l_object_type := WF_ENGINE.GetItemAttrText (
859: itemtype => itemtype
860: , itemkey => itemkey
861: , aname => 'OBJECT_TYPE'
862: );

Line 890: WF_ENGINE.SetItemAttrText(

886: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
887: result := 'COMPLETE:SUCCESS' ;
888: ELSE
889: /* populate error message */
890: WF_ENGINE.SetItemAttrText(
891: itemtype => itemtype
892: , itemkey => itemkey
893: , aname => 'AGGR_ERR_MESSAGE'
894: , avalue => l_message

Line 897: WF_ENGINE.SetItemAttrText(

893: , aname => 'AGGR_ERR_MESSAGE'
894: , avalue => l_message
895: );
896: /* populate status to DRAFT */
897: WF_ENGINE.SetItemAttrText(
898: itemtype => itemtype
899: , itemkey => itemkey
900: , aname => 'STATUS_CODE'
901: , avalue => G_STATUS_DRAFT

Line 947: WF_ENGINE.SetItemAttrText(

943: p_log_used_by_id => l_object_id,
944: p_msg_data => L_API_NAME || ': EXCEPTION BUFFER WRITTEN'
945: );
946: /* populate status to DRAFT */
947: WF_ENGINE.SetItemAttrText(
948: itemtype => itemtype
949: , itemkey => itemkey
950: , aname => 'STATUS_CODE'
951: , avalue => G_STATUS_DRAFT

Line 1033: l_object_id := WF_ENGINE.GetItemAttrNumber(

1029:
1030: l_target_id NUMBER;
1031:
1032: BEGIN
1033: l_object_id := WF_ENGINE.GetItemAttrNumber(
1034: itemtype => itemtype
1035: , itemkey => itemkey
1036: , aname => 'OBJECT_ID'
1037: );

Line 1038: l_object_type := WF_ENGINE.GetItemAttrText (

1034: itemtype => itemtype
1035: , itemkey => itemkey
1036: , aname => 'OBJECT_ID'
1037: );
1038: l_object_type := WF_ENGINE.GetItemAttrText (
1039: itemtype => itemtype
1040: , itemkey => itemkey
1041: , aname => 'OBJECT_TYPE'
1042: );

Line 1058: l_data_source_id := WF_ENGINE.GetItemAttrNumber (

1054: p_log_used_by_id => l_object_id,
1055: p_msg_data => L_API_NAME || ' - FUNCMODE: ' || funcmode
1056: );
1057:
1058: l_data_source_id := WF_ENGINE.GetItemAttrNumber (
1059: itemtype => itemtype
1060: , itemkey => itemkey
1061: , aname => 'DATA_SOURCE_ID'
1062: );

Line 1109: WF_ENGINE.SetItemAttrText(

1105: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1106: result := 'COMPLETE:FAILURE' ;
1107:
1108: /* populate error message */
1109: WF_ENGINE.SetItemAttrText(
1110: itemtype => itemtype
1111: , itemkey => itemkey
1112: , aname => 'TRAN_ERR_MESSAGE'
1113: , avalue => l_message

Line 1116: WF_ENGINE.SetItemAttrText(

1112: , aname => 'TRAN_ERR_MESSAGE'
1113: , avalue => l_message
1114: );
1115: /* populate status to DRAFT */
1116: WF_ENGINE.SetItemAttrText(
1117: itemtype => itemtype
1118: , itemkey => itemkey
1119: , aname => 'STATUS_CODE'
1120: , avalue => G_STATUS_DRAFT

Line 1142: WF_ENGINE.SetItemAttrText(

1138: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1139: result := 'COMPLETE:SUCCESS' ;
1140: ELSE
1141: /* populate error message */
1142: WF_ENGINE.SetItemAttrText(
1143: itemtype => itemtype
1144: , itemkey => itemkey
1145: , aname => 'TRAN_ERR_MESSAGE'
1146: , avalue => l_msg_data

Line 1149: WF_ENGINE.SetItemAttrText(

1145: , aname => 'TRAN_ERR_MESSAGE'
1146: , avalue => l_msg_data
1147: );
1148: /* populate status to DRAFT */
1149: WF_ENGINE.SetItemAttrText(
1150: itemtype => itemtype
1151: , itemkey => itemkey
1152: , aname => 'STATUS_CODE'
1153: , avalue => G_STATUS_DRAFT

Line 1202: WF_ENGINE.SetItemAttrText(

1198:
1199: wf_core.context(G_PKG_NAME,'Transform',itemtype,itemkey,to_char(actid),funcmode);
1200:
1201: /* populate status to DRAFT */
1202: WF_ENGINE.SetItemAttrText(
1203: itemtype => itemtype
1204: , itemkey => itemkey
1205: , aname => 'STATUS_CODE'
1206: , avalue => G_STATUS_DRAFT

Line 1279: l_object_id := WF_ENGINE.GetItemAttrNumber(

1275: SELECT model_id
1276: FROM ams_dm_scores_all_b
1277: WHERE score_id = p_score_id;
1278: BEGIN
1279: l_object_id := WF_ENGINE.GetItemAttrNumber(
1280: itemtype => itemtype
1281: , itemkey => itemkey
1282: , aname => 'OBJECT_ID'
1283: );

Line 1284: l_object_type := WF_ENGINE.GetItemAttrText (

1280: itemtype => itemtype
1281: , itemkey => itemkey
1282: , aname => 'OBJECT_ID'
1283: );
1284: l_object_type := WF_ENGINE.GetItemAttrText (
1285: itemtype => itemtype
1286: , itemkey => itemkey
1287: , aname => 'OBJECT_TYPE'
1288: );

Line 1303: l_model_type := WF_ENGINE.GetItemAttrText(

1299: END IF;
1300:
1301: -- RUN mode - Normal Process Execution
1302: IF (funcmode = 'RUN') THEN
1303: l_model_type := WF_ENGINE.GetItemAttrText(
1304: itemtype => itemtype
1305: , itemkey => itemkey
1306: , aname => 'MODEL_TYPE'
1307: );

Line 1308: l_target_group := WF_ENGINE.GetItemAttrNumber(

1304: itemtype => itemtype
1305: , itemkey => itemkey
1306: , aname => 'MODEL_TYPE'
1307: );
1308: l_target_group := WF_ENGINE.GetItemAttrNumber(
1309: itemtype => itemtype
1310: , itemkey => itemkey
1311: , aname => 'DATA_SOURCE_ID'
1312: );

Line 1313: l_request_type := WF_ENGINE.GetItemAttrText (

1309: itemtype => itemtype
1310: , itemkey => itemkey
1311: , aname => 'DATA_SOURCE_ID'
1312: );
1313: l_request_type := WF_ENGINE.GetItemAttrText (
1314: itemtype => itemtype
1315: , itemkey => itemkey
1316: , aname => 'REQUEST_TYPE'
1317: );

Line 1318: l_select_list := WF_ENGINE.GetItemAttrText(

1314: itemtype => itemtype
1315: , itemkey => itemkey
1316: , aname => 'REQUEST_TYPE'
1317: );
1318: l_select_list := WF_ENGINE.GetItemAttrText(
1319: itemtype => itemtype
1320: , itemkey => itemkey
1321: , aname => 'SELECT_LIST'
1322: );

Line 1324: l_target_positive_value := WF_ENGINE.GetItemAttrNumber(

1320: , itemkey => itemkey
1321: , aname => 'SELECT_LIST'
1322: );
1323:
1324: l_target_positive_value := WF_ENGINE.GetItemAttrNumber(
1325: itemtype => itemtype
1326: , itemkey => itemkey
1327: , aname => 'TARGET_POSITIVE_VALUE'
1328: );

Line 1359: WF_ENGINE.SetItemAttrNumber(

1355: AMS_Utility_PVT.debug_message (L_API_NAME || ' - REQUEST_ID: ' || l_request_id);
1356: END IF;
1357:
1358: IF l_request_id <> 0 THEN
1359: WF_ENGINE.SetItemAttrNumber(
1360: itemtype => itemtype
1361: , itemkey => itemkey
1362: , aname => 'REQUEST_ID'
1363: , avalue => l_request_id

Line 1400: WF_ENGINE.SetItemAttrText(

1396: );
1397: -- AMS_Utility_PVT.error_message ( L_API_NAME || '- CONCURRENT REQUEST ERROR: ' || l_message);
1398:
1399: /* populate status to DRAFT */
1400: WF_ENGINE.SetItemAttrText(
1401: itemtype => itemtype
1402: , itemkey => itemkey
1403: , aname => 'STATUS_CODE'
1404: , avalue => G_STATUS_DRAFT

Line 1418: WF_ENGINE.SetItemAttrText(

1414: );
1415: -- AMS_Utility_PVT.error_message ( L_API_NAME || ' - NO CONCURRENT REQUEST');
1416:
1417: /* populate status to DRAFT */
1418: WF_ENGINE.SetItemAttrText(
1419: itemtype => itemtype
1420: , itemkey => itemkey
1421: , aname => 'STATUS_CODE'
1422: , avalue => G_STATUS_DRAFT

Line 1466: WF_ENGINE.SetItemAttrText(

1462:
1463: wf_core.context(G_PKG_NAME,'Command',itemtype,itemkey,to_char(actid),funcmode);
1464:
1465: /* populate status to DRAFT */
1466: WF_ENGINE.SetItemAttrText(
1467: itemtype => itemtype
1468: , itemkey => itemkey
1469: , aname => 'STATUS_CODE'
1470: , avalue => G_STATUS_DRAFT

Line 1543: l_object_id := WF_ENGINE.GetItemAttrNumber(

1539: l_msg_data VARCHAR2 (2000);
1540:
1541: BEGIN
1542: /***
1543: l_object_id := WF_ENGINE.GetItemAttrNumber(
1544: itemtype => itemtype
1545: , itemkey => itemkey
1546: , aname => 'OBJECT_ID'
1547: );

Line 1548: l_object_type := WF_ENGINE.GetItemAttrText (

1544: itemtype => itemtype
1545: , itemkey => itemkey
1546: , aname => 'OBJECT_ID'
1547: );
1548: l_object_type := WF_ENGINE.GetItemAttrText (
1549: itemtype => itemtype
1550: , itemkey => itemkey
1551: , aname => 'OBJECT_TYPE'
1552: );

Line 1586: WF_ENGINE.SetItemAttrText(

1582: AMS_Utility_PVT.debug_message (L_API_NAME || ' - AQ MESG: ' || l_message);
1583: END IF;
1584: ELSIF NVL(l_return_status,'E') = 'N' THEN
1585: result := 'COMPLETE:NO' ;
1586: WF_ENGINE.SetItemAttrText(
1587: itemtype => itemtype
1588: , itemkey => itemkey
1589: , aname => 'AQ_ERR_MESSAGE'
1590: , avalue => l_msg_data

Line 1592: WF_ENGINE.SetItemAttrText(

1588: , itemkey => itemkey
1589: , aname => 'AQ_ERR_MESSAGE'
1590: , avalue => l_msg_data
1591: );
1592: WF_ENGINE.SetItemAttrText(
1593: itemtype => itemtype
1594: , itemkey => itemkey
1595: , aname => 'AQ_OPERATION'
1596: , avalue => 'Polling from Response'

Line 1600: WF_ENGINE.SetItemAttrText(

1596: , avalue => 'Polling from Response'
1597: );
1598: ELSIF NVL(l_return_status,'E') = 'F' THEN
1599: result := 'COMPLETE:FAILURE' ;
1600: WF_ENGINE.SetItemAttrText(
1601: itemtype => itemtype
1602: , itemkey => itemkey
1603: , aname => 'RESP_ERR_MESSAGE'
1604: , avalue => l_msg_data

Line 1608: WF_ENGINE.SetItemAttrText(

1604: , avalue => l_msg_data
1605: );
1606: ELSIF NVL(l_return_status,'E') = 'E' THEN
1607: result := 'COMPLETE:ERROR' ;
1608: WF_ENGINE.SetItemAttrText(
1609: itemtype => itemtype
1610: , itemkey => itemkey
1611: , aname => 'RESP_ERR_MESSAGE'
1612: , avalue => l_message

Line 1614: WF_ENGINE.SetItemAttrText(

1610: , itemkey => itemkey
1611: , aname => 'RESP_ERR_MESSAGE'
1612: , avalue => l_message
1613: );
1614: WF_ENGINE.SetItemAttrText(
1615: itemtype => itemtype
1616: , itemkey => itemkey
1617: , aname => 'STATUS_CODE'
1618: , avalue => G_STATUS_DRAFT

Line 1714: l_object_id := WF_ENGINE.GetItemAttrNumber(

1710: l_message VARCHAR2(4000);
1711:
1712:
1713: BEGIN
1714: l_object_id := WF_ENGINE.GetItemAttrNumber(
1715: itemtype => itemtype
1716: , itemkey => itemkey
1717: , aname => 'OBJECT_ID'
1718: );

Line 1719: l_object_type := WF_ENGINE.GetItemAttrText (

1715: itemtype => itemtype
1716: , itemkey => itemkey
1717: , aname => 'OBJECT_ID'
1718: );
1719: l_object_type := WF_ENGINE.GetItemAttrText (
1720: itemtype => itemtype
1721: , itemkey => itemkey
1722: , aname => 'OBJECT_TYPE'
1723: );

Line 1749: WF_ENGINE.SetItemAttrText(

1745:
1746: IF l_object_type = G_OBJECT_TYPE_MODEL THEN
1747: result := 'COMPLETE:SUCCESS' ;
1748: /* populate status to AVAILABLE */
1749: WF_ENGINE.SetItemAttrText(
1750: itemtype => itemtype
1751: , itemkey => itemkey
1752: , aname => 'STATUS_CODE'
1753: , avalue => G_STATUS_AVAILABLE

Line 1777: WF_ENGINE.SetItemAttrText(

1773: );
1774:
1775:
1776: /* populate error message */
1777: WF_ENGINE.SetItemAttrText(
1778: itemtype => itemtype
1779: , itemkey => itemkey
1780: , aname => 'COLL_ERR_MESSAGE'
1781: , avalue => l_msg_data

Line 1784: WF_ENGINE.SetItemAttrText(

1780: , aname => 'COLL_ERR_MESSAGE'
1781: , avalue => l_msg_data
1782: );
1783: /* populate status to DRAFT */
1784: WF_ENGINE.SetItemAttrText(
1785: itemtype => itemtype
1786: , itemkey => itemkey
1787: , aname => 'STATUS_CODE'
1788: , avalue => G_STATUS_DRAFT

Line 1809: WF_ENGINE.SetItemAttrText(

1805: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1806: result := 'COMPLETE:FAILURE' ;
1807:
1808: /* populate error message */
1809: WF_ENGINE.SetItemAttrText(
1810: itemtype => itemtype
1811: , itemkey => itemkey
1812: , aname => 'COLL_ERR_MESSAGE'
1813: , avalue => l_msg_data

Line 1816: WF_ENGINE.SetItemAttrText(

1812: , aname => 'COLL_ERR_MESSAGE'
1813: , avalue => l_msg_data
1814: );
1815: /* populate status to DRAFT */
1816: WF_ENGINE.SetItemAttrText(
1817: itemtype => itemtype
1818: , itemkey => itemkey
1819: , aname => 'STATUS_CODE'
1820: , avalue => G_STATUS_DRAFT

Line 1839: WF_ENGINE.SetItemAttrText(

1835: );
1836: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1837: result := 'COMPLETE:SUCCESS' ;
1838: /* populate status to COMPLETED */
1839: WF_ENGINE.SetItemAttrText(
1840: itemtype => itemtype
1841: , itemkey => itemkey
1842: , aname => 'STATUS_CODE'
1843: , avalue => G_STATUS_COMPLETED

Line 1849: WF_ENGINE.SetItemAttrText(

1845: ELSE
1846: result := 'COMPLETE:FAILURE' ;
1847:
1848: /* populate error message */
1849: WF_ENGINE.SetItemAttrText(
1850: itemtype => itemtype
1851: , itemkey => itemkey
1852: , aname => 'COLL_ERR_MESSAGE'
1853: , avalue => l_msg_data

Line 1856: WF_ENGINE.SetItemAttrText(

1852: , aname => 'COLL_ERR_MESSAGE'
1853: , avalue => l_msg_data
1854: );
1855: /* populate status to DRAFT */
1856: WF_ENGINE.SetItemAttrText(
1857: itemtype => itemtype
1858: , itemkey => itemkey
1859: , aname => 'STATUS_CODE'
1860: , avalue => G_STATUS_DRAFT

Line 1907: WF_ENGINE.SetItemAttrText(

1903:
1904: wf_core.context(G_PKG_NAME,'Collect_Results',itemtype,itemkey,to_char(actid),funcmode);
1905:
1906: /* populate status to DRAFT */
1907: WF_ENGINE.SetItemAttrText(
1908: itemtype => itemtype
1909: , itemkey => itemkey
1910: , aname => 'STATUS_CODE'
1911: , avalue => G_STATUS_DRAFT

Line 1966: l_object_id := WF_ENGINE.GetItemAttrNumber(

1962:
1963: l_request_type VARCHAR2(30);
1964:
1965: BEGIN
1966: l_object_id := WF_ENGINE.GetItemAttrNumber(
1967: itemtype => itemtype
1968: , itemkey => itemkey
1969: , aname => 'OBJECT_ID'
1970: );

Line 1971: l_object_type := WF_ENGINE.GetItemAttrText (

1967: itemtype => itemtype
1968: , itemkey => itemkey
1969: , aname => 'OBJECT_ID'
1970: );
1971: l_object_type := WF_ENGINE.GetItemAttrText (
1972: itemtype => itemtype
1973: , itemkey => itemkey
1974: , aname => 'OBJECT_TYPE'
1975: );

Line 1976: l_request_type := WF_ENGINE.GetItemAttrText (

1972: itemtype => itemtype
1973: , itemkey => itemkey
1974: , aname => 'OBJECT_TYPE'
1975: );
1976: l_request_type := WF_ENGINE.GetItemAttrText (
1977: itemtype => itemtype
1978: , itemkey => itemkey
1979: , aname => 'REQUEST_TYPE'
1980: );

Line 1995: l_object_status := WF_ENGINE.GetItemAttrText (

1991: END IF;
1992:
1993: -- RUN mode - Normal Process Execution
1994: IF (funcmode = 'RUN') THEN
1995: l_object_status := WF_ENGINE.GetItemAttrText (
1996: itemtype => itemtype
1997: , itemkey => itemkey
1998: , aname => 'STATUS_CODE'
1999: );

Line 2115: WF_ENGINE.SetItemAttrText(

2111:
2112: wf_core.context(G_PKG_NAME,'Update_Obj_Status',itemtype,itemkey,to_char(actid),funcmode);
2113:
2114: /* populate status to DRAFT */
2115: WF_ENGINE.SetItemAttrText(
2116: itemtype => itemtype
2117: , itemkey => itemkey
2118: , aname => 'STATUS_CODE'
2119: , avalue => G_STATUS_DRAFT

Line 2224: WF_Engine.AbortProcess (

2220: l_wf_result VARCHAR2(30);
2221: BEGIN
2222: x_return_status := FND_API.G_RET_STS_SUCCESS;
2223:
2224: WF_Engine.AbortProcess (
2225: itemtype => G_DEFAULT_ITEMTYPE,
2226: itemkey => p_itemkey,
2227: result => l_wf_result
2228: );

Line 2275: l_object_id := WF_ENGINE.GetItemAttrNumber(

2271:
2272: -- after copying all the process attributes,
2273: -- cancel the current process and create a
2274: -- new one.
2275: l_object_id := WF_ENGINE.GetItemAttrNumber(
2276: itemtype => G_DEFAULT_ITEMTYPE
2277: , itemkey => p_itemkey
2278: , aname => 'OBJECT_ID'
2279: );

Line 2280: l_object_type := WF_ENGINE.GetItemAttrText (

2276: itemtype => G_DEFAULT_ITEMTYPE
2277: , itemkey => p_itemkey
2278: , aname => 'OBJECT_ID'
2279: );
2280: l_object_type := WF_ENGINE.GetItemAttrText (
2281: itemtype => G_DEFAULT_ITEMTYPE
2282: , itemkey => p_itemkey
2283: , aname => 'OBJECT_TYPE'
2284: );

Line 2285: l_user_status_id := WF_ENGINE.GetItemAttrNumber(

2281: itemtype => G_DEFAULT_ITEMTYPE
2282: , itemkey => p_itemkey
2283: , aname => 'OBJECT_TYPE'
2284: );
2285: l_user_status_id := WF_ENGINE.GetItemAttrNumber(
2286: itemtype => G_DEFAULT_ITEMTYPE
2287: , itemkey => p_itemkey
2288: , aname => 'ORIG_USER_STATUS_ID'
2289: );

Line 2306: WF_Engine.AbortProcess (

2302: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2303: END IF;
2304:
2305: -- abort the current process
2306: WF_Engine.AbortProcess (
2307: itemtype => G_DEFAULT_ITEMTYPE,
2308: itemkey => p_itemkey,
2309: result => l_wf_result
2310: );

Line 2324: --COMMIT; -- otherwise, WF engine does not get this

2320: p_select_list => NULL,
2321: x_itemkey => x_new_itemkey
2322: );
2323:
2324: --COMMIT; -- otherwise, WF engine does not get this
2325: EXCEPTION
2326: WHEN OTHERS THEN
2327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2328: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 2394: l_object_id := WF_ENGINE.GetItemAttrNumber(

2390: -- initialize the result to allow the model/score
2391: -- request to pass.
2392: x_result := 'COMPLETE:T';
2393:
2394: l_object_id := WF_ENGINE.GetItemAttrNumber(
2395: itemtype => p_itemtype
2396: , itemkey => p_itemkey
2397: , aname => 'OBJECT_ID'
2398: );

Line 2399: l_object_type := WF_ENGINE.GetItemAttrText (

2395: itemtype => p_itemtype
2396: , itemkey => p_itemkey
2397: , aname => 'OBJECT_ID'
2398: );
2399: l_object_type := WF_ENGINE.GetItemAttrText (
2400: itemtype => p_itemtype
2401: , itemkey => p_itemkey
2402: , aname => 'OBJECT_TYPE'
2403: );

Line 2409: l_request_type := WF_ENGINE.GetItemAttrText (

2405: -- REQUEST_TYPE will be set to PREVIEW if the WF Process is handling
2406: -- a Preview request. It will be blank if a Build/Score is requested.
2407: -- REQUEST_TYPE will be set to PREVIEW_STARTED if the Preview request
2408: -- is going to execute the aggregate_soruces step.
2409: l_request_type := WF_ENGINE.GetItemAttrText (
2410: itemtype => p_itemtype
2411: , itemkey => p_itemkey
2412: , aname => 'REQUEST_TYPE'
2413: );

Line 2453: -- l_preview_status := WF_ENGINE.GetItemAttrText (

2449:
2450: -- If we are handling a Preview request, then check if the other Model/Scoring Run
2451: -- in progress has finished the aggregate_sources step.
2452: -- IF l_request_type = G_PREVIEW_REQUEST THEN
2453: -- l_preview_status := WF_ENGINE.GetItemAttrText (
2454: -- itemtype => p_itemtype
2455: -- , itemkey => l_temp_wf_itemkey
2456: -- , aname => 'REQUEST_TYPE'
2457: -- );

Line 2471: --WF_ENGINE.SetItemAttrText (

2467: --ELSE
2468: -- For model build/score request, return false and set the status to QUEUED
2469: --x_result := 'COMPLETE:F';
2470:
2471: --WF_ENGINE.SetItemAttrText (
2472: -- itemtype => p_itemtype
2473: -- , itemkey => p_itemkey
2474: -- , aname => 'STATUS_CODE'
2475: -- , avalue => G_STATUS_QUEUED

Line 2479: -- WF_ENGINE.SetItemAttrDate (

2475: -- , avalue => G_STATUS_QUEUED
2476: --);
2477: -- END IF;
2478:
2479: -- WF_ENGINE.SetItemAttrDate (
2480: -- itemtype => p_itemtype
2481: -- , itemkey => p_itemkey
2482: -- , aname => 'NEXT_QUEUE_CHECK'
2483: -- , avalue => l_next_date

Line 2495: WF_ENGINE.SetItemAttrText (

2491: -- No Model/Scoring Run in progress.
2492: -- For Model, set status to BUILDING if we are not performing a Preview operation
2493: IF l_request_type <> G_PREVIEW_REQUEST THEN
2494: IF l_object_type = G_OBJECT_TYPE_MODEL THEN
2495: WF_ENGINE.SetItemAttrText (
2496: itemtype => p_itemtype
2497: , itemkey => p_itemkey
2498: , aname => 'STATUS_CODE'
2499: , avalue => G_STATUS_BUILDING

Line 2503: WF_ENGINE.SetItemAttrText (

2499: , avalue => G_STATUS_BUILDING
2500: );
2501: -- For Scoring Run, set status to SCORING if we are not performing a Preview operation
2502: ELSIF l_object_type = G_OBJECT_TYPE_SCORE THEN
2503: WF_ENGINE.SetItemAttrText (
2504: itemtype => p_itemtype
2505: , itemkey => p_itemkey
2506: , aname => 'STATUS_CODE'
2507: , avalue => G_STATUS_SCORING

Line 2591: l_object_id := WF_ENGINE.GetItemAttrNumber(

2587: l_object_type VARCHAR2(30);
2588: l_return_status VARCHAR2(1);
2589:
2590: BEGIN
2591: l_object_id := WF_ENGINE.GetItemAttrNumber(
2592: itemtype => p_itemtype
2593: , itemkey => p_itemkey
2594: , aname => 'OBJECT_ID'
2595: );

Line 2596: l_object_type := WF_ENGINE.GetItemAttrText (

2592: itemtype => p_itemtype
2593: , itemkey => p_itemkey
2594: , aname => 'OBJECT_ID'
2595: );
2596: l_object_type := WF_ENGINE.GetItemAttrText (
2597: itemtype => p_itemtype
2598: , itemkey => p_itemkey
2599: , aname => 'OBJECT_TYPE'
2600: );

Line 2634: WF_ENGINE.SetItemAttrText(

2630: END IF;
2631:
2632: -- nyostos 09/17/2002 - Set STATUS_CODE Workflow global variable to FAILED instead of DRAFT
2633: -- Set STATUS_CODE Workflow global variable to FAILED
2634: WF_ENGINE.SetItemAttrText(
2635: itemtype => p_itemtype
2636: , itemkey => p_itemkey
2637: , aname => 'STATUS_CODE'
2638: , avalue => G_STATUS_FAILED

Line 2677: WF_ENGINE.SetItemAttrText(

2673: wf_core.context(G_PKG_NAME, 'Reset_Status', p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);
2674:
2675: -- nyostos 09/17/2002 - Set STATUS_CODE Workflow global variable to FAILED instead of DRAFT
2676: -- Set STATUS_CODE Workflow global variable to FAILED
2677: WF_ENGINE.SetItemAttrText(
2678: itemtype => p_itemtype
2679: , itemkey => p_itemkey
2680: , aname => 'STATUS_CODE'
2681: , avalue => G_STATUS_FAILED

Line 2734: l_request_type := WF_ENGINE.GetItemAttrText(

2730: BEGIN
2731: -- initialize the result
2732: x_result := 'COMPLETE:T';
2733:
2734: l_request_type := WF_ENGINE.GetItemAttrText(
2735: itemtype => p_itemtype
2736: , itemkey => p_itemkey
2737: , aname => 'REQUEST_TYPE'
2738: );

Line 2739: l_object_id := WF_ENGINE.GetItemAttrNumber(

2735: itemtype => p_itemtype
2736: , itemkey => p_itemkey
2737: , aname => 'REQUEST_TYPE'
2738: );
2739: l_object_id := WF_ENGINE.GetItemAttrNumber(
2740: itemtype => p_itemtype
2741: , itemkey => p_itemkey
2742: , aname => 'OBJECT_ID'
2743: );

Line 2744: l_object_type := WF_ENGINE.GetItemAttrText (

2740: itemtype => p_itemtype
2741: , itemkey => p_itemkey
2742: , aname => 'OBJECT_ID'
2743: );
2744: l_object_type := WF_ENGINE.GetItemAttrText (
2745: itemtype => p_itemtype
2746: , itemkey => p_itemkey
2747: , aname => 'OBJECT_TYPE'
2748: );

Line 2765: WF_ENGINE.SetItemAttrText(

2761: -- finished successfully.
2762: IF l_request_type = G_PREVIEW_REQUEST OR l_request_type = G_PREVIEW_STARTED THEN
2763:
2764: -- Set STATUS_CODE attribute to DRAFT
2765: WF_ENGINE.SetItemAttrText(
2766: itemtype => p_itemtype
2767: , itemkey => p_itemkey
2768: , aname => 'STATUS_CODE'
2769: , avalue => G_STATUS_DRAFT

Line 2776: WF_ENGINE.SetItemAttrText(

2772: -- WF Process was started to Build/Score so return False
2773: x_result := 'COMPLETE:F' ;
2774:
2775: -- Set REQUEST_TYPE attribute to PREVIEW_COMPLETE
2776: WF_ENGINE.SetItemAttrText(
2777: itemtype => p_itemtype
2778: , itemkey => p_itemkey
2779: , aname => 'REQUEST_TYPE'
2780: , avalue => G_PREVIEW_COMPLETE

Line 2818: WF_ENGINE.SetItemAttrText(

2814:
2815: wf_core.context(G_PKG_NAME,'Is_Previewing', p_itemtype, p_itemkey,to_char(p_actid), p_funcmode);
2816:
2817: -- Set STATUS_CODE attribute to DRAFT
2818: WF_ENGINE.SetItemAttrText(
2819: itemtype => p_itemtype
2820: , itemkey => p_itemkey
2821: , aname => 'STATUS_CODE'
2822: , avalue => G_STATUS_DRAFT

Line 2853: l_orig_status_id := WF_ENGINE.GetItemAttrNumber(

2849:
2850: BEGIN
2851:
2852:
2853: l_orig_status_id := WF_ENGINE.GetItemAttrNumber(
2854: itemtype => G_DEFAULT_ITEMTYPE
2855: , itemkey => p_itemkey
2856: , aname => 'ORIG_USER_STATUS_ID'
2857: );

Line 2923: l_request_type := WF_ENGINE.GetItemAttrText(

2919: BEGIN
2920: -- initialize the result
2921: x_result := 'COMPLETE:T';
2922:
2923: l_request_type := WF_ENGINE.GetItemAttrText(
2924: itemtype => p_itemtype
2925: , itemkey => p_itemkey
2926: , aname => 'REQUEST_TYPE'
2927: );

Line 2928: l_object_id := WF_ENGINE.GetItemAttrNumber(

2924: itemtype => p_itemtype
2925: , itemkey => p_itemkey
2926: , aname => 'REQUEST_TYPE'
2927: );
2928: l_object_id := WF_ENGINE.GetItemAttrNumber(
2929: itemtype => p_itemtype
2930: , itemkey => p_itemkey
2931: , aname => 'OBJECT_ID'
2932: );

Line 2933: l_object_type := WF_ENGINE.GetItemAttrText (

2929: itemtype => p_itemtype
2930: , itemkey => p_itemkey
2931: , aname => 'OBJECT_ID'
2932: );
2933: l_object_type := WF_ENGINE.GetItemAttrText (
2934: itemtype => p_itemtype
2935: , itemkey => p_itemkey
2936: , aname => 'OBJECT_TYPE'
2937: );

Line 2997: WF_ENGINE.SetItemAttrText (

2993: END IF;
2994: ELSIF x_result <> 'COMPLETE:F' AND l_request_type = G_PREVIEW_REQUEST THEN
2995: -- Set the Request type to PREVIEW_STARTED. This will be checked by other
2996: -- Preview requests when validating concurrency to resolve any potential deadlock
2997: WF_ENGINE.SetItemAttrText (
2998: itemtype => p_itemtype
2999: , itemkey => p_itemkey
3000: , aname => 'REQUEST_TYPE'
3001: , avalue => G_PREVIEW_STARTED

Line 3038: WF_ENGINE.SetItemAttrText(

3034:
3035: wf_core.context(G_PKG_NAME,'ok_to_proceed', p_itemtype, p_itemkey,to_char(p_actid), p_funcmode);
3036:
3037: -- Set STATUS_CODE attribute to DRAFT
3038: WF_ENGINE.SetItemAttrText(
3039: itemtype => p_itemtype
3040: , itemkey => p_itemkey
3041: , aname => 'STATUS_CODE'
3042: , avalue => G_STATUS_DRAFT