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

Line 18: wf_engine.abortprocess(itemtype => p_itemtype, itemkey => p_itemkey);

14: -- PG_DEBUG NUMBER(2) := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
15: PG_DEBUG NUMBER ;
16: procedure custom_abort_process(p_itemtype IN varchar2, p_itemkey IN varchar2) is
17: begin
18: wf_engine.abortprocess(itemtype => p_itemtype, itemkey => p_itemkey);
19: exception
20: when others then
21: iex_debug_pub.logmessage('Exception of custom abort_processes: ');
22: end;

Line 84: wf_engine.itemstatus(itemtype => 'IEXWRREQ', itemkey => l_itemkey, status => l_status, result => l_result);

80: exit when get_itemkey%NOTFOUND;
81:
82: iex_debug_pub.logmessage('IEXWRREQ Workflow and itemkey is...'||l_itemkey);
83:
84: wf_engine.itemstatus(itemtype => 'IEXWRREQ', itemkey => l_itemkey, status => l_status, result => l_result);
85: iex_debug_pub.logmessage('IEXWRREQ Workflow Status = :: =>' || l_status||'and itemkey is...'||l_itemkey);
86:
87: if l_status <> wf_engine.eng_completed then
88: wf_engine.abortprocess(itemtype => 'IEXWRREQ', itemkey => l_itemkey);

Line 87: if l_status <> wf_engine.eng_completed then

83:
84: wf_engine.itemstatus(itemtype => 'IEXWRREQ', itemkey => l_itemkey, status => l_status, result => l_result);
85: iex_debug_pub.logmessage('IEXWRREQ Workflow Status = :: =>' || l_status||'and itemkey is...'||l_itemkey);
86:
87: if l_status <> wf_engine.eng_completed then
88: wf_engine.abortprocess(itemtype => 'IEXWRREQ', itemkey => l_itemkey);
89: wf_engine.itemstatus(itemtype => 'IEXWRREQ', itemkey => l_itemkey, status => l_status, result => l_result);
90: iex_debug_pub.logmessage('cancel Writeoff workflow: Abort process has completed and status =>' || l_status);
91: end if;

Line 88: wf_engine.abortprocess(itemtype => 'IEXWRREQ', itemkey => l_itemkey);

84: wf_engine.itemstatus(itemtype => 'IEXWRREQ', itemkey => l_itemkey, status => l_status, result => l_result);
85: iex_debug_pub.logmessage('IEXWRREQ Workflow Status = :: =>' || l_status||'and itemkey is...'||l_itemkey);
86:
87: if l_status <> wf_engine.eng_completed then
88: wf_engine.abortprocess(itemtype => 'IEXWRREQ', itemkey => l_itemkey);
89: wf_engine.itemstatus(itemtype => 'IEXWRREQ', itemkey => l_itemkey, status => l_status, result => l_result);
90: iex_debug_pub.logmessage('cancel Writeoff workflow: Abort process has completed and status =>' || l_status);
91: end if;
92: End Loop;

Line 89: wf_engine.itemstatus(itemtype => 'IEXWRREQ', itemkey => l_itemkey, status => l_status, result => l_result);

85: iex_debug_pub.logmessage('IEXWRREQ Workflow Status = :: =>' || l_status||'and itemkey is...'||l_itemkey);
86:
87: if l_status <> wf_engine.eng_completed then
88: wf_engine.abortprocess(itemtype => 'IEXWRREQ', itemkey => l_itemkey);
89: wf_engine.itemstatus(itemtype => 'IEXWRREQ', itemkey => l_itemkey, status => l_status, result => l_result);
90: iex_debug_pub.logmessage('cancel Writeoff workflow: Abort process has completed and status =>' || l_status);
91: end if;
92: End Loop;
93: close get_itemkey;

Line 106: wf_engine.itemstatus(itemtype => c_rec.itemtype,

102:
103: FOR c_rec in c_get_itemtype
104: LOOP
105: if c_rec.itemtype IS NOT NULL THEN
106: wf_engine.itemstatus(itemtype => c_rec.itemtype,
107: itemkey => c_rec.work_item_id,
108: status => l_status,
109: result => l_result);
110: -- IF PG_DEBUG < 10 THEN

Line 116: IF l_status <> wf_engine.eng_completed THEN

112: iex_debug_pub.logmessage('abort_processes: ' || 'after workflow status check ' ||l_status || ' item key'
113: || c_rec.work_item_id);
114: END IF;
115:
116: IF l_status <> wf_engine.eng_completed THEN
117: -- IF PG_DEBUG < 10 THEN
118: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
119: iex_debug_pub.logmessage('abort_processes: ' || ' process has not completed and status =>'|| l_status);
120: END IF;

Line 122: wf_engine.abortprocess(itemtype => c_rec.itemtype,

118: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
119: iex_debug_pub.logmessage('abort_processes: ' || ' process has not completed and status =>'|| l_status);
120: END IF;
121: BEGIN
122: wf_engine.abortprocess(itemtype => c_rec.itemtype,
123: itemkey => c_rec.work_item_id);
124: EXCEPTION
125: WHEN OTHERS THEN
126: -- IF PG_DEBUG < 10 THEN

Line 144: wf_engine.itemstatus(itemtype => l_itemtype,

140: BEGIN
141: l_itemtype :='IEXSTFFM';
142: FOR c_rec in c_workitems
143: LOOP
144: wf_engine.itemstatus(itemtype => l_itemtype,
145: itemkey => c_rec.work_item_id,
146: status =>l_status,
147: result =>l_result);
148: -- IF PG_DEBUG < 10 THEN

Line 153: IF l_status <> wf_engine.eng_completed THEN

149: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
150: iex_debug_pub.logmessage('abort_processes: ' || 'after workflow status check ' ||l_status || ' item key'
151: ||c_rec.work_item_id);
152: END IF;
153: IF l_status <> wf_engine.eng_completed THEN
154: -- IF PG_DEBUG < 10 THEN
155: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
156: iex_debug_pub.logmessage ('abort_processes: ' || ' in fulfilment and process has not completed '||
157: 'and status =>'||l_status);

Line 160: wf_engine.abortprocess(itemtype => l_itemtype,

156: iex_debug_pub.logmessage ('abort_processes: ' || ' in fulfilment and process has not completed '||
157: 'and status =>'||l_status);
158: END IF;
159: BEGIN
160: wf_engine.abortprocess(itemtype => l_itemtype,
161: itemkey => c_rec.work_item_id);
162: EXCEPTION
163: WHEN OTHERS THEN
164: -- IF PG_DEBUG < 10 THEN

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

345: get_username ( p_resource_id =>p_resource_id,
346: x_username =>l_username,
347: x_source_name =>l_source_name);
348:
349: wf_engine.SetItemAttrText(itemtype => itemtype,
350: itemkey => itemkey,
351: aname => 'ASSIGNEE',
352: avalue => l_source_name);
353: --End bug 6717880/7170165 by Ehuh

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

351: aname => 'ASSIGNEE',
352: avalue => l_source_name);
353: --End bug 6717880/7170165 by Ehuh
354:
355: wf_engine.SetItemAttrText(itemtype => itemtype,
356: itemkey => itemkey,
357: aname => 'NOTIFICATION_USERNAME',
358: avalue => l_username);
359:

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

380: l_mgr_resource_id := p_resource_id;
381: end if;
382:
383:
384: wf_engine.SetItemAttrText(itemtype => itemtype,
385: itemkey => itemkey,
386: aname => 'NOTIFICATION_MGRNAME',
387: avalue => l_mgrname);
388: -- IF PG_DEBUG < 10 THEN

Line 418: wf_engine.SetItemAttrDate(itemtype => itemtype,

414: -- IF PG_DEBUG < 10 THEN
415: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
416: iex_debug_pub.logmessage ('**** BEGIN set_escalate_wait_time ************');
417: END IF;
418: wf_engine.SetItemAttrDate(itemtype => itemtype,
419: itemkey => itemkey,
420: aname => 'ESCALATE_WAIT_TIME',
421: avalue => p_escalate_date);
422: -- IF PG_DEBUG < 10 THEN

Line 448: wf_engine.SetItemAttrDate(itemtype => itemtype,

444: -- IF PG_DEBUG < 10 THEN
445: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
446: iex_debug_pub.logmessage ('**** BEGIN set_optional_wait_time ************');
447: END IF;
448: wf_engine.SetItemAttrDate(itemtype => itemtype,
449: itemkey => itemkey,
450: aname => 'OPTIONAL_WAIT_TIME',
451: avalue => p_optional_date);
452: -- IF PG_DEBUG < 10 THEN

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

542: itemtype =>itemtype,
543: itemkey =>itemkey);
544: end if;
545: --set workitem_template_id attribute
546: wf_engine.SetItemAttrNumber(itemtype => itemtype,
547: itemkey => itemkey,
548: aname => 'WORKITEM_TEMPLATE_ID',
549: avalue => p_work_item_temp_id);
550: --reset the activity_label

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

547: itemkey => itemkey,
548: aname => 'WORKITEM_TEMPLATE_ID',
549: avalue => p_work_item_temp_id);
550: --reset the activity_label
551: wf_engine.SetItemAttrText(itemtype => itemtype,
552: itemkey => itemkey,
553: aname => 'ACTIVITY_NAME',
554: avalue => null);
555: --reset the status

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

552: itemkey => itemkey,
553: aname => 'ACTIVITY_NAME',
554: avalue => null);
555: --reset the status
556: wf_engine.SetItemAttrText(itemtype => itemtype,
557: itemkey => itemkey,
558: aname => 'STRATEGY_STATUS',
559: avalue => null);
560:

Line 1123: wf_engine.SetItemAttrText(

1119: Open c_get_accloc(p_strategy_id);
1120: Fetch c_get_accloc into l_acct_number,l_location;
1121: if c_get_accloc%NOTFOUND then null;
1122: else
1123: wf_engine.SetItemAttrText(
1124: itemtype =>itemtype,
1125: itemkey =>itemkey,
1126: aname => 'ACCOUNT_NUMBER',
1127: avalue => l_acct_number);

Line 1129: wf_engine.SetItemAttrText(

1125: itemkey =>itemkey,
1126: aname => 'ACCOUNT_NUMBER',
1127: avalue => l_acct_number);
1128:
1129: wf_engine.SetItemAttrText(
1130: itemtype =>itemtype,
1131: itemkey =>itemkey,
1132: aname => 'BILL_TO',
1133: avalue => l_location);

Line 1177: wf_engine.SetItemAttrNumber(

1173: x_return_status => l_return_status,
1174: p_strategy_id => p_strategy_id,
1175: p_work_item_id => x_work_item_id);
1176:
1177: wf_engine.SetItemAttrNumber(
1178: itemtype =>itemtype,
1179: itemkey =>itemkey,
1180: aname => 'WORK_ITEMID',
1181: avalue => x_work_item_id);

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

1186: from IEX_STRY_TEMP_WORK_ITEMS_VL a, IEX_STRATEGY_WORK_ITEMS b
1187: where b.work_item_template_id = a.work_item_temp_id
1188: and b.work_item_id = x_work_item_id;
1189:
1190: wf_engine.SetItemAttrText(itemtype =>itemtype,
1191: itemkey => itemkey,
1192: aname => 'WORK_ITEM_NAME',
1193: avalue => l_workitem_name);
1194: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

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

1225: END IF;
1226:
1227: -- reset activity_name attribute each time a work item is created
1228: --06/26
1229: wf_engine.SetItemAttrText(itemtype => itemtype,
1230: itemkey => itemkey,
1231: aname => 'ACTIVITY_NAME',
1232: avalue => NULL);
1233:

Line 1270: -- to see if the process is SUSPEND(wf_engine.eng_suspended )

1266: END IF;
1267: End create_work_item;
1268:
1269: -----------get the status of the process---------------------------------------
1270: -- to see if the process is SUSPEND(wf_engine.eng_suspended )
1271:
1272: PROCEDURE process_status ( p_process in varchar2,
1273: p_itemtype in varchar2,
1274: p_itemkey in varchar2,

Line 1299: x_status :=wf_engine.eng_active;

1295: iex_debug_pub.logmessage ('process_status: ' || 'status is '||x_status);
1296: END IF;
1297: EXCEPTION WHEN OTHERS THEN
1298: -- send the status has active
1299: x_status :=wf_engine.eng_active;
1300:
1301: END process_status;
1302:
1303: --- populate strategy mailer record type

Line 1313: l_strategy_mailer_rec.strategy_id := wf_engine.GetItemAttrNumber(

1309: -- IF PG_DEBUG < 10 THEN
1310: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1311: iex_debug_pub.logmessage ('**** BEGIN populate_strategy_mailer ************');
1312: END IF;
1313: l_strategy_mailer_rec.strategy_id := wf_engine.GetItemAttrNumber(
1314: itemtype => itemtype,
1315: itemkey => itemkey,
1316: aname => 'STRATEGY_ID');
1317:

Line 1318: l_strategy_mailer_rec.delinquency_id := wf_engine.GetItemAttrNumber(

1314: itemtype => itemtype,
1315: itemkey => itemkey,
1316: aname => 'STRATEGY_ID');
1317:
1318: l_strategy_mailer_rec.delinquency_id := wf_engine.GetItemAttrNumber(
1319: itemtype => itemtype,
1320: itemkey => itemkey,
1321: aname => 'DELINQUENCY_ID');
1322:

Line 1324: l_strategy_mailer_rec.workitem_id := wf_engine.GetItemAttrNumber(

1320: itemkey => itemkey,
1321: aname => 'DELINQUENCY_ID');
1322:
1323:
1324: l_strategy_mailer_rec.workitem_id := wf_engine.GetItemAttrNumber(
1325: itemtype => itemtype,
1326: itemkey => itemkey,
1327: aname => 'WORK_ITEMID');
1328:

Line 1329: l_strategy_mailer_rec.user_id := wf_engine.GetItemAttrNumber(

1325: itemtype => itemtype,
1326: itemkey => itemkey,
1327: aname => 'WORK_ITEMID');
1328:
1329: l_strategy_mailer_rec.user_id := wf_engine.GetItemAttrNumber(
1330: itemtype => itemtype,
1331: itemkey => itemkey,
1332: aname => 'USER_ID');
1333:

Line 1334: l_strategy_mailer_rec.resp_id := wf_engine.GetItemAttrNumber(

1330: itemtype => itemtype,
1331: itemkey => itemkey,
1332: aname => 'USER_ID');
1333:
1334: l_strategy_mailer_rec.resp_id := wf_engine.GetItemAttrNumber(
1335: itemtype => itemtype,
1336: itemkey => itemkey,
1337: aname => 'RESP_ID');
1338:

Line 1339: l_strategy_mailer_rec.resp_appl_id := wf_engine.GetItemAttrNumber(

1335: itemtype => itemtype,
1336: itemkey => itemkey,
1337: aname => 'RESP_ID');
1338:
1339: l_strategy_mailer_rec.resp_appl_id := wf_engine.GetItemAttrNumber(
1340: itemtype => itemtype,
1341: itemkey => itemkey,
1342: aname => 'RESP_APPL_ID');
1343: -- IF PG_DEBUG < 10 THEN

Line 1367: l_custom_wf_rec.strategy_id := wf_engine.GetItemAttrNumber(

1363: -- IF PG_DEBUG < 10 THEN
1364: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1365: iex_debug_pub.logmessage ('**** BEGIN populate_custom_workflow ************');
1366: END IF;
1367: l_custom_wf_rec.strategy_id := wf_engine.GetItemAttrNumber(
1368: itemtype => itemtype,
1369: itemkey => itemkey,
1370: aname => 'STRATEGY_ID');
1371:

Line 1374: l_custom_wf_rec.workitem_id := wf_engine.GetItemAttrNumber(

1370: aname => 'STRATEGY_ID');
1371:
1372:
1373:
1374: l_custom_wf_rec.workitem_id := wf_engine.GetItemAttrNumber(
1375: itemtype => itemtype,
1376: itemkey => itemkey,
1377: aname => 'WORK_ITEMID');
1378:

Line 1381: l_custom_wf_rec.user_id := wf_engine.GetItemAttrNumber(

1377: aname => 'WORK_ITEMID');
1378:
1379: l_custom_wf_rec.custom_itemtype := p_custom_itemtype;
1380:
1381: l_custom_wf_rec.user_id := wf_engine.GetItemAttrNumber(
1382: itemtype => itemtype,
1383: itemkey => itemkey,
1384: aname => 'USER_ID');
1385:

Line 1386: l_custom_wf_rec.resp_id := wf_engine.GetItemAttrNumber(

1382: itemtype => itemtype,
1383: itemkey => itemkey,
1384: aname => 'USER_ID');
1385:
1386: l_custom_wf_rec.resp_id := wf_engine.GetItemAttrNumber(
1387: itemtype => itemtype,
1388: itemkey => itemkey,
1389: aname => 'RESP_ID');
1390:

Line 1391: l_custom_wf_rec.resp_appl_id := wf_engine.GetItemAttrNumber(

1387: itemtype => itemtype,
1388: itemkey => itemkey,
1389: aname => 'RESP_ID');
1390:
1391: l_custom_wf_rec.resp_appl_id := wf_engine.GetItemAttrNumber(
1392: itemtype => itemtype,
1393: itemkey => itemkey,
1394: aname => 'RESP_APPL_ID');
1395:

Line 1637: result := wf_engine.eng_null;

1633:
1634: Begin
1635:
1636: if funcmode <> 'RUN' then
1637: result := wf_engine.eng_null;
1638: return;
1639: end if;
1640:
1641: --IF PG_DEBUG < 10 THEN

Line 1654: /* l_value :=wf_engine.GetActivityLabel(actid);

1650: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1651: iex_debug_pub.logmessage ('check_work_items_completed: ' || 'ITEMKEY =>'||itemkey);
1652: END IF;
1653:
1654: /* l_value :=wf_engine.GetActivityLabel(actid);
1655: wf_engine.SetItemAttrText(itemtype => itemtype,
1656: itemkey => itemkey,
1657: aname => 'ACTIVITY_NAME',
1658: avalue => l_value);

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

1651: iex_debug_pub.logmessage ('check_work_items_completed: ' || 'ITEMKEY =>'||itemkey);
1652: END IF;
1653:
1654: /* l_value :=wf_engine.GetActivityLabel(actid);
1655: wf_engine.SetItemAttrText(itemtype => itemtype,
1656: itemkey => itemkey,
1657: aname => 'ACTIVITY_NAME',
1658: avalue => l_value);
1659: --IF PG_DEBUG < 10 THEN

Line 1680: l_strategy_status := wf_engine.GetItemAttrText(

1676: * work item id is not passed, but we still have to
1677: * check for pending work item if status is 'OPEN'
1678: **/
1679:
1680: l_strategy_status := wf_engine.GetItemAttrText(
1681: itemtype => itemtype,
1682: itemkey => itemkey,
1683: aname => 'STRATEGY_STATUS');
1684:

Line 1686: l_work_item_id := wf_engine.GetItemAttrNumber(

1682: itemkey => itemkey,
1683: aname => 'STRATEGY_STATUS');
1684:
1685:
1686: l_work_item_id := wf_engine.GetItemAttrNumber(
1687: itemtype => itemtype,
1688: itemkey => itemkey,
1689: aname => 'WORK_ITEMID');
1690:

Line 1699: result := wf_engine.eng_completed||':'||wf_yes;

1695: 'l_work_item_id =>'||l_work_item_id);
1696: END IF;
1697:
1698: IF l_work_item_id IS NULL and l_strategy_status <> 'OPEN' THEN
1699: result := wf_engine.eng_completed||':'||wf_yes;
1700: return;
1701: END IF;
1702:
1703:

Line 1707: l_strategy_id := wf_engine.GetItemAttrNumber(

1703:
1704:
1705: ---get strategy_id from the work flow
1706:
1707: l_strategy_id := wf_engine.GetItemAttrNumber(
1708: itemtype => itemtype,
1709: itemkey => itemkey,
1710: aname => 'STRATEGY_ID');
1711:

Line 1734: result := wf_engine.eng_completed ||':'||wf_no;

1730: LOOP
1731: IF c_get_witem_rec.status IN ('NOTCREATED') THEN
1732: -- NOT IN ('COMPLETE','CANCELLED','TIMEOUT','SKIP') THEN
1733: -- there are pending work items to be processed
1734: result := wf_engine.eng_completed ||':'||wf_no;
1735: -- IF PG_DEBUG < 10 THEN
1736: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1737: iex_debug_pub.logmessage ('check_work_items_completed: ' || 'there are pending witems to be created and result is'||
1738: '=>'||result);

Line 1744: result := wf_engine.eng_completed ||':'||wf_yes;

1740: return;
1741: END IF;
1742:
1743: END LOOP;
1744: result := wf_engine.eng_completed ||':'||wf_yes;
1745: -- IF PG_DEBUG < 10 THEN
1746: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1747: iex_debug_pub.logmessage ('check_work_items_completed: ' || 'result =>'||result);
1748: END IF;

Line 1798: result := wf_engine.eng_null;

1794: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1795: iex_debug_pub.logmessage ('**** BEGIN close_strategy ************');
1796: END IF;
1797: if funcmode <> 'RUN' then
1798: result := wf_engine.eng_null;
1799: return;
1800: end if;
1801:
1802: /*l_value :=wf_engine.GetActivityLabel(actid);

Line 1802: /*l_value :=wf_engine.GetActivityLabel(actid);

1798: result := wf_engine.eng_null;
1799: return;
1800: end if;
1801:
1802: /*l_value :=wf_engine.GetActivityLabel(actid);
1803: wf_engine.SetItemAttrText(itemtype => itemtype,
1804: itemkey => itemkey,
1805: aname => 'ACTIVITY_NAME',
1806: avalue => l_value);

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

1799: return;
1800: end if;
1801:
1802: /*l_value :=wf_engine.GetActivityLabel(actid);
1803: wf_engine.SetItemAttrText(itemtype => itemtype,
1804: itemkey => itemkey,
1805: aname => 'ACTIVITY_NAME',
1806: avalue => l_value);
1807: -- IF PG_DEBUG < 10 THEN

Line 1815: l_strategy_id := wf_engine.GetItemAttrNumber(

1811: */
1812:
1813: ---get strategy_id from the work flow
1814:
1815: l_strategy_id := wf_engine.GetItemAttrNumber(
1816: itemtype => itemtype,
1817: itemkey => itemkey,
1818: aname => 'STRATEGY_ID');
1819:

Line 1820: l_strategy_status := wf_engine.GetItemAttrText(

1816: itemtype => itemtype,
1817: itemkey => itemkey,
1818: aname => 'STRATEGY_ID');
1819:
1820: l_strategy_status := wf_engine.GetItemAttrText(
1821: itemtype => itemtype,
1822: itemkey => itemkey,
1823: aname => 'STRATEGY_STATUS');
1824:

Line 1825: l_work_item_id := wf_engine.GetItemAttrNumber(

1821: itemtype => itemtype,
1822: itemkey => itemkey,
1823: aname => 'STRATEGY_STATUS');
1824:
1825: l_work_item_id := wf_engine.GetItemAttrNumber(
1826: itemtype => itemtype,
1827: itemkey => itemkey,
1828: aname => 'WORK_ITEMID');
1829:

Line 1868: result := wf_engine.eng_completed ||':'||wf_yes;

1864:
1865: -- if the result is 'N' then go back to
1866: -- sleep or wait mode
1867: if l_return_status =FND_API.G_RET_STS_SUCCESS THEN
1868: result := wf_engine.eng_completed ||':'||wf_yes;
1869: else
1870: result := wf_engine.eng_completed ||':'||wf_no;
1871: --set the strategy_status back to 'OPEN'
1872: --and go back to sleep mode

Line 1870: result := wf_engine.eng_completed ||':'||wf_no;

1866: -- sleep or wait mode
1867: if l_return_status =FND_API.G_RET_STS_SUCCESS THEN
1868: result := wf_engine.eng_completed ||':'||wf_yes;
1869: else
1870: result := wf_engine.eng_completed ||':'||wf_no;
1871: --set the strategy_status back to 'OPEN'
1872: --and go back to sleep mode
1873: wf_engine.SetItemAttrText(itemtype => itemtype,
1874: itemkey => itemkey,

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

1869: else
1870: result := wf_engine.eng_completed ||':'||wf_no;
1871: --set the strategy_status back to 'OPEN'
1872: --and go back to sleep mode
1873: wf_engine.SetItemAttrText(itemtype => itemtype,
1874: itemkey => itemkey,
1875: aname => 'STRATEGY_STATUS',
1876: avalue => 'OPEN');
1877:

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

1889: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1890: iex_debug_pub.logmessage('close_strategy: ' || 'error message is ' || l_error);
1891: END IF;
1892:
1893: wf_engine.SetItemAttrText(itemtype => itemtype,
1894: itemkey => itemkey,
1895: aname => 'ERROR_MESSAGE',
1896: avalue => l_error);
1897:

Line 1956: result := wf_engine.eng_null;

1952: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1953: iex_debug_pub.logmessage ('**** BEGIN create_next_work_item ************');
1954: END IF;
1955: if funcmode <> 'RUN' then
1956: result := wf_engine.eng_null;
1957: return;
1958: end if;
1959:
1960: /*l_value :=wf_engine.GetActivityLabel(actid);

Line 1960: /*l_value :=wf_engine.GetActivityLabel(actid);

1956: result := wf_engine.eng_null;
1957: return;
1958: end if;
1959:
1960: /*l_value :=wf_engine.GetActivityLabel(actid);
1961: wf_engine.SetItemAttrText(itemtype => itemtype,
1962: itemkey => itemkey,
1963: aname => 'ACTIVITY_NAME',
1964: avalue => l_value);

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

1957: return;
1958: end if;
1959:
1960: /*l_value :=wf_engine.GetActivityLabel(actid);
1961: wf_engine.SetItemAttrText(itemtype => itemtype,
1962: itemkey => itemkey,
1963: aname => 'ACTIVITY_NAME',
1964: avalue => l_value);
1965: --IF PG_DEBUG < 10 THEN

Line 1972: l_strategy_id := wf_engine.GetItemAttrNumber(

1968: END IF;
1969: */
1970:
1971: ---get strategy_id from the work flow
1972: l_strategy_id := wf_engine.GetItemAttrNumber(
1973: itemtype => itemtype,
1974: itemkey => itemkey,
1975: aname => 'STRATEGY_ID');
1976:

Line 1978: l_party_id := wf_engine.GetItemAttrNumber(

1974: itemkey => itemkey,
1975: aname => 'STRATEGY_ID');
1976:
1977: ---get party_id from the work flow
1978: l_party_id := wf_engine.GetItemAttrNumber(
1979: itemtype => itemtype,
1980: itemkey => itemkey,
1981: aname => 'PARTY_ID');
1982:

Line 2012: result := wf_engine.eng_completed ||':'||wf_no;

2008: iex_debug_pub.logmessage ('create_next_work_item: ' || ' creation of work items and status => '||l_return_status);
2009: END IF;
2010:
2011: if l_return_status <>FND_API.G_RET_STS_SUCCESS THEN
2012: result := wf_engine.eng_completed ||':'||wf_no;
2013: --pass the error message
2014: wf_engine.SetItemAttrText(itemtype => itemtype,
2015: itemkey => itemkey,
2016: aname => 'ERROR_MESSAGE',

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

2010:
2011: if l_return_status <>FND_API.G_RET_STS_SUCCESS THEN
2012: result := wf_engine.eng_completed ||':'||wf_no;
2013: --pass the error message
2014: wf_engine.SetItemAttrText(itemtype => itemtype,
2015: itemkey => itemkey,
2016: aname => 'ERROR_MESSAGE',
2017: avalue => l_error);
2018:

Line 2020: result := wf_engine.eng_completed ||':'||wf_yes;

2016: aname => 'ERROR_MESSAGE',
2017: avalue => l_error);
2018:
2019: else
2020: result := wf_engine.eng_completed ||':'||wf_yes;
2021:
2022: end if;
2023: --IF PG_DEBUG < 10 THEN
2024: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 2054: result := wf_engine.eng_null;

2050: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2051: iex_debug_pub.logmessage ('**** BEGIN WAIT_SIGNAL ************');
2052: END IF;
2053: if funcmode <> 'RUN' then
2054: result := wf_engine.eng_null;
2055: return;
2056: end if;
2057:
2058: /*l_value :=wf_engine.GetActivityLabel(actid);

Line 2058: /*l_value :=wf_engine.GetActivityLabel(actid);

2054: result := wf_engine.eng_null;
2055: return;
2056: end if;
2057:
2058: /*l_value :=wf_engine.GetActivityLabel(actid);
2059: wf_engine.SetItemAttrText(itemtype => itemtype,
2060: itemkey => itemkey,
2061: aname => 'ACTIVITY_NAME',
2062: avalue => l_value);

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

2055: return;
2056: end if;
2057:
2058: /*l_value :=wf_engine.GetActivityLabel(actid);
2059: wf_engine.SetItemAttrText(itemtype => itemtype,
2060: itemkey => itemkey,
2061: aname => 'ACTIVITY_NAME',
2062: avalue => l_value);
2063: --IF PG_DEBUG < 10 THEN

Line 2070: wf_engine.SuspendProcess(

2066: END IF;
2067: */
2068:
2069: --- suspend process
2070: wf_engine.SuspendProcess(
2071: itemtype => itemtype,
2072: itemkey => itemkey);
2073: -- 05/10/02 the form doesnot know the workflow is
2074: -- suspended, so trying to issue a commit to see

Line 2077: result := wf_engine.eng_completed ||':'||wf_yes;

2073: -- 05/10/02 the form doesnot know the workflow is
2074: -- suspended, so trying to issue a commit to see
2075: --if it works.
2076: --COMMIT;
2077: result := wf_engine.eng_completed ||':'||wf_yes;
2078: -- IF PG_DEBUG < 10 THEN
2079: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2080: iex_debug_pub.logmessage ('**** END WAIT_SIGNAL ************');
2081: END IF;

Line 2109: if funcmode <> wf_engine.eng_run then

2105: BEGIN
2106: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2107: iex_debug_pub.logmessage ('**** START wait_complete_signal ************');
2108: END IF;
2109: if funcmode <> wf_engine.eng_run then
2110: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2111: iex_debug_pub.logmessage('SECOND TIME FUNCMODE' ||funcmode);
2112: END IF;
2113: result := wf_engine.eng_null;

Line 2113: result := wf_engine.eng_null;

2109: if funcmode <> wf_engine.eng_run then
2110: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2111: iex_debug_pub.logmessage('SECOND TIME FUNCMODE' ||funcmode);
2112: END IF;
2113: result := wf_engine.eng_null;
2114: return;
2115: end if;
2116:
2117:

Line 2122: l_value :=wf_engine.GetActivityLabel(actid);

2118:
2119: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2120: iex_debug_pub.logmessage('FUNCMODE' ||funcmode);
2121: END IF;
2122: l_value :=wf_engine.GetActivityLabel(actid);
2123: wf_engine.SetItemAttrText(itemtype => itemtype,
2124: itemkey => itemkey,
2125: aname => 'ACTIVITY_NAME',
2126: avalue => l_value);

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

2119: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2120: iex_debug_pub.logmessage('FUNCMODE' ||funcmode);
2121: END IF;
2122: l_value :=wf_engine.GetActivityLabel(actid);
2123: wf_engine.SetItemAttrText(itemtype => itemtype,
2124: itemkey => itemkey,
2125: aname => 'ACTIVITY_NAME',
2126: avalue => l_value);
2127: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 2132: result := wf_engine.eng_notified||':'||wf_engine.eng_null||

2128: iex_debug_pub.logMessage('ACTIVITYNAME' ||l_value);
2129: END IF;
2130:
2131:
2132: result := wf_engine.eng_notified||':'||wf_engine.eng_null||
2133: ':'||wf_engine.eng_null;
2134: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2135: iex_debug_pub.logmessage ('**** END wait_complete_signal ************');
2136: END IF;

Line 2133: ':'||wf_engine.eng_null;

2129: END IF;
2130:
2131:
2132: result := wf_engine.eng_notified||':'||wf_engine.eng_null||
2133: ':'||wf_engine.eng_null;
2134: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2135: iex_debug_pub.logmessage ('**** END wait_complete_signal ************');
2136: END IF;
2137: exception

Line 2139: result := wf_engine.eng_completed ||':'||wf_no;

2135: iex_debug_pub.logmessage ('**** END wait_complete_signal ************');
2136: END IF;
2137: exception
2138: when others then
2139: result := wf_engine.eng_completed ||':'||wf_no;
2140: wf_core.context('IEX_STRATEGY_WF','wait_complete_signal',itemtype,
2141: itemkey,to_char(actid),funcmode);
2142: raise;
2143:

Line 2206: wf_engine.itemstatus(itemtype => process,

2202: iex_debug_pub.logmessage ('wait_signal: ' || 'status' ||status ||'workitemid ' ||work_item_id || '**'||
2203: 'signal source '||signal_source||'strategy_id' ||strategy_id);
2204: END IF;
2205:
2206: wf_engine.itemstatus(itemtype => process,
2207: itemkey => strategy_id,
2208: status =>l_status,
2209: result =>l_result);
2210:

Line 2219: IF l_status =wf_engine.eng_suspended THEN

2215:
2216: --- resume process only if it is suspend
2217: -- check for other than fulfilment and custom work flow
2218:
2219: IF l_status =wf_engine.eng_suspended THEN
2220:
2221: --check if the signal_source is fulfillment or optional
2222: if signal_source in ('FULFILLMENT','CUSTOM') THEN
2223: -- IF PG_DEBUG < 10 THEN

Line 2299: wf_engine.SetItemAttrText(itemtype => process,

2295: abort_processes(strategy_id);
2296: end if;--work item id is null
2297: end if; -- signal source check
2298:
2299: wf_engine.SetItemAttrText(itemtype => process,
2300: itemkey => strategy_id,
2301: aname => 'STRATEGY_STATUS',
2302: avalue => status);
2303:

Line 2304: wf_engine.SetItemAttrNumber(itemtype => process,

2300: itemkey => strategy_id,
2301: aname => 'STRATEGY_STATUS',
2302: avalue => status);
2303:
2304: wf_engine.SetItemAttrNumber(itemtype => process,
2305: itemkey => strategy_id,
2306: aname => 'WORK_ITEMID',
2307: avalue => work_item_id);
2308:

Line 2309: wf_engine.ResumeProcess(itemtype => process,

2305: itemkey => strategy_id,
2306: aname => 'WORK_ITEMID',
2307: avalue => work_item_id);
2308:
2309: wf_engine.ResumeProcess(itemtype => process,
2310: itemkey => strategy_id);
2311:
2312: --COMMIT; -- the work flow was not going to end from the close strategy
2313:

Line 2314: ELSIF l_status =wf_engine.eng_active THEN

2310: itemkey => strategy_id);
2311:
2312: --COMMIT; -- the work flow was not going to end from the close strategy
2313:
2314: ELSIF l_status =wf_engine.eng_active THEN
2315:
2316: --complete the current activity
2317: --this will be either complete the ESCALATE_CHECK
2318: --OR OPTIONAL_CHECK activity

Line 2362: l_activity_label := wf_engine.GetItemAttrText(

2358: --activity without the label being set.
2359:
2360: end if;--work item id is null
2361:
2362: l_activity_label := wf_engine.GetItemAttrText(
2363: itemtype => process,
2364: itemkey => strategy_id,
2365: aname => 'ACTIVITY_NAME');
2366: -- IF PG_DEBUG < 10 THEN

Line 2375: wf_engine.SetItemAttrText(itemtype => process,

2371: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2372: iex_debug_pub.logmessage('wait_signal: ' || process ||strategy_id||l_activity_label);
2373: END IF;
2374:
2375: wf_engine.SetItemAttrText(itemtype => process,
2376: itemkey => strategy_id,
2377: aname => 'STRATEGY_STATUS',
2378: avalue => status);
2379:

Line 2380: wf_engine.SetItemAttrNumber(itemtype => process,

2376: itemkey => strategy_id,
2377: aname => 'STRATEGY_STATUS',
2378: avalue => status);
2379:
2380: wf_engine.SetItemAttrNumber(itemtype => process,
2381: itemkey => strategy_id,
2382: aname => 'WORK_ITEMID',
2383: avalue => work_item_id);
2384:

Line 2390: wf_engine.CompleteActivity(

2386: -- change strategy from the UI, then send signal was failing
2387: --check value of activity label before resuming process
2388: If l_activity_label IS NOT NULL THEN
2389: abort_processes(strategy_id); -- added on 05/10/02
2390: wf_engine.CompleteActivity(
2391: itemtype => process,
2392: itemkey => strategy_id,
2393: activity =>l_activity_label,
2394: result =>'Yes');

Line 2414: ELSIF l_status =wf_engine.eng_error THEN

2410: end if;
2411:
2412: end if; --signal_source
2413:
2414: ELSIF l_status =wf_engine.eng_error THEN
2415: CLOSE_AND_ABORT_STRATEGY_WF(strategy_id,status);
2416: NULL;
2417: --COMMIT; -- the work flow was not going to end from the close strategy
2418: END IF; -- item status

Line 2463: result := wf_engine.eng_null;

2459: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2460: iex_debug_pub.logmessage ('**** START CUSTOM_CHECK ************');
2461: END IF;
2462: if funcmode <> 'RUN' then
2463: result := wf_engine.eng_null;
2464: return;
2465: end if;
2466:
2467: /* Begin 06-dec-2005 schekuri bug 4506922 - All work items are created as PRE-WAIT */

Line 2468: l_work_item_id := wf_engine.GetItemAttrNumber(

2464: return;
2465: end if;
2466:
2467: /* Begin 06-dec-2005 schekuri bug 4506922 - All work items are created as PRE-WAIT */
2468: l_work_item_id := wf_engine.GetItemAttrNumber(
2469: itemtype => itemtype,
2470: itemkey => itemkey,
2471: aname => 'WORK_ITEMID');
2472:

Line 2489: /* l_value :=wf_engine.GetActivityLabel(actid);

2485: END IF;
2486:
2487: /* End 06-dec-2005 schekuri bug 4506922 - All work items are created as PRE-WAIT */
2488:
2489: /* l_value :=wf_engine.GetActivityLabel(actid);
2490: wf_engine.SetItemAttrText(itemtype => itemtype,
2491: itemkey => itemkey,
2492: aname => 'ACTIVITY_NAME',
2493: avalue => l_value);

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

2486:
2487: /* End 06-dec-2005 schekuri bug 4506922 - All work items are created as PRE-WAIT */
2488:
2489: /* l_value :=wf_engine.GetActivityLabel(actid);
2490: wf_engine.SetItemAttrText(itemtype => itemtype,
2491: itemkey => itemkey,
2492: aname => 'ACTIVITY_NAME',
2493: avalue => l_value);
2494:

Line 2500: l_work_item_temp_id := wf_engine.GetItemAttrNumber(

2496: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2497: iex_debug_pub.logMessage('CUSTOM_CHECK: ' || 'ACTIVITYNAME' ||l_value);
2498: END IF;
2499: */
2500: l_work_item_temp_id := wf_engine.GetItemAttrNumber(
2501: itemtype => itemtype,
2502: itemkey => itemkey,
2503: aname => 'WORKITEM_TEMPLATE_ID');
2504:

Line 2537: result := wf_engine.eng_completed ||':'||l_result;

2533: -- IF PG_DEBUG < 10 THEN
2534: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2535: iex_debug_pub.logmessage ('CUSTOM_CHECK: ' || 'End of custom work flow ');
2536: END IF;
2537: result := wf_engine.eng_completed ||':'||l_result;
2538: return;
2539: -- result := wf_engine.eng_completed ||':'||l_result;
2540:
2541: -- don't check for result, what ever is the outcome

Line 2539: -- result := wf_engine.eng_completed ||':'||l_result;

2535: iex_debug_pub.logmessage ('CUSTOM_CHECK: ' || 'End of custom work flow ');
2536: END IF;
2537: result := wf_engine.eng_completed ||':'||l_result;
2538: return;
2539: -- result := wf_engine.eng_completed ||':'||l_result;
2540:
2541: -- don't check for result, what ever is the outcome
2542: -- go and wait, the UI will relaunch the custom workflow
2543:

Line 2545: result := wf_engine.eng_completed ||':'||wf_yes;

2541: -- don't check for result, what ever is the outcome
2542: -- go and wait, the UI will relaunch the custom workflow
2543:
2544: /* if l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2545: result := wf_engine.eng_completed ||':'||wf_yes;
2546: else
2547: result := wf_engine.eng_completed ||':'||wf_no;
2548: end if;
2549:

Line 2547: result := wf_engine.eng_completed ||':'||wf_no;

2543:
2544: /* if l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2545: result := wf_engine.eng_completed ||':'||wf_yes;
2546: else
2547: result := wf_engine.eng_completed ||':'||wf_no;
2548: end if;
2549:
2550: */
2551:

Line 2559: result := wf_engine.eng_completed ||':'||wf_no;

2555: iex_debug_pub.logmessage ('**** END CUSTOM_CHECK ************');
2556: END IF;
2557: exception
2558: when others then
2559: result := wf_engine.eng_completed ||':'||wf_no;
2560: wf_core.context('IEX_STRATEGY_WF','CUSTOM_CHECK',itemtype,
2561: itemkey,to_char(actid),funcmode);
2562: raise;
2563:

Line 2596: result := wf_engine.eng_null;

2592: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2593: iex_debug_pub.logmessage ('**** START FULFIL_CHECK ************');
2594: END IF;
2595: if funcmode <> 'RUN' then
2596: result := wf_engine.eng_null;
2597: return;
2598: end if;
2599:
2600: /* l_value :=wf_engine.GetActivityLabel(actid);

Line 2600: /* l_value :=wf_engine.GetActivityLabel(actid);

2596: result := wf_engine.eng_null;
2597: return;
2598: end if;
2599:
2600: /* l_value :=wf_engine.GetActivityLabel(actid);
2601: wf_engine.SetItemAttrText(itemtype => itemtype,
2602: itemkey => itemkey,
2603: aname => 'ACTIVITY_NAME',
2604: avalue => l_value);

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

2597: return;
2598: end if;
2599:
2600: /* l_value :=wf_engine.GetActivityLabel(actid);
2601: wf_engine.SetItemAttrText(itemtype => itemtype,
2602: itemkey => itemkey,
2603: aname => 'ACTIVITY_NAME',
2604: avalue => l_value);
2605: -- IF PG_DEBUG < 10 THEN

Line 2611: l_work_item_temp_id := wf_engine.GetItemAttrNumber(

2607: iex_debug_pub.logMessage('FULFIL_CHECK: ' || 'ACTIVITYNAME' ||l_value);
2608: END IF;
2609: */
2610:
2611: l_work_item_temp_id := wf_engine.GetItemAttrNumber(
2612: itemtype => itemtype,
2613: itemkey => itemkey,
2614: aname => 'WORKITEM_TEMPLATE_ID');
2615:

Line 2654: result := wf_engine.eng_completed ||':'||l_result;

2650: x_return_status => l_return_status);
2651:
2652: End if;
2653:
2654: result := wf_engine.eng_completed ||':'||l_result;
2655:
2656: -- don't check for result, what ever is the outcome
2657: -- go and wait, the UI will relaunch the fulilment workflow
2658:

Line 2660: result := wf_engine.eng_completed ||':'||wf_yes;

2656: -- don't check for result, what ever is the outcome
2657: -- go and wait, the UI will relaunch the fulilment workflow
2658:
2659: /* if l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2660: result := wf_engine.eng_completed ||':'||wf_yes;
2661: else
2662: result := wf_engine.eng_completed ||':'||wf_no;
2663: end if;
2664:

Line 2662: result := wf_engine.eng_completed ||':'||wf_no;

2658:
2659: /* if l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2660: result := wf_engine.eng_completed ||':'||wf_yes;
2661: else
2662: result := wf_engine.eng_completed ||':'||wf_no;
2663: end if;
2664:
2665: */
2666:

Line 2674: result := wf_engine.eng_completed ||':'||wf_no;

2670: iex_debug_pub.logmessage ('**** END FULFIL_CHECK ************');
2671: END IF;
2672: exception
2673: when others then
2674: result := wf_engine.eng_completed ||':'||wf_no;
2675: wf_core.context('IEX_STRATEGY_WF','FULFIL_CHECK',itemtype,
2676: itemkey,to_char(actid),funcmode);
2677: raise;
2678:

Line 2718: result := wf_engine.eng_null;

2714: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2715: iex_debug_pub.logmessage ('**** START cal_post_wait ************');
2716: END IF;
2717: if funcmode <> 'RUN' then
2718: result := wf_engine.eng_null;
2719: return;
2720: end if;
2721:
2722: l_strategy_status := wf_engine.GetItemAttrText(itemtype => itemtype,

Line 2722: l_strategy_status := wf_engine.GetItemAttrText(itemtype => itemtype,

2718: result := wf_engine.eng_null;
2719: return;
2720: end if;
2721:
2722: l_strategy_status := wf_engine.GetItemAttrText(itemtype => itemtype,
2723: itemkey => itemkey,
2724: aname => 'STRATEGY_STATUS');
2725:
2726: l_work_item_id := wf_engine.GetItemAttrNumber(

Line 2726: l_work_item_id := wf_engine.GetItemAttrNumber(

2722: l_strategy_status := wf_engine.GetItemAttrText(itemtype => itemtype,
2723: itemkey => itemkey,
2724: aname => 'STRATEGY_STATUS');
2725:
2726: l_work_item_id := wf_engine.GetItemAttrNumber(
2727: itemtype => itemtype,
2728: itemkey => itemkey,
2729: aname => 'WORK_ITEMID');
2730:

Line 2739: result := wf_engine.eng_completed ||':'||l_return;

2735: IEX_STRY_UTL_PUB.refresh_uwq_str_summ(l_work_item_id);
2736: end if;
2737: --End bug#5874874 gnramasa 25-Apr-2007
2738: l_return := wf_no;
2739: result := wf_engine.eng_completed ||':'||l_return;
2740: return;
2741: end if;
2742:
2743: l_work_item_temp_id := wf_engine.GetItemAttrNumber(

Line 2743: l_work_item_temp_id := wf_engine.GetItemAttrNumber(

2739: result := wf_engine.eng_completed ||':'||l_return;
2740: return;
2741: end if;
2742:
2743: l_work_item_temp_id := wf_engine.GetItemAttrNumber(
2744: itemtype => itemtype,
2745: itemkey => itemkey,
2746: aname => 'WORKITEM_TEMPLATE_ID');
2747:

Line 2830: wf_engine.SetItemAttrDate(itemtype => itemtype,

2826: end if;
2827:
2828: --End if; --Removed if for bug#5502077 schekuri 30-Apr-2007
2829:
2830: wf_engine.SetItemAttrDate(itemtype => itemtype,
2831: itemkey => itemkey,
2832: aname => 'EXECUTION_TIME',
2833: avalue => l_execution_time);
2834:

Line 2846: result := wf_engine.eng_completed ||':'||l_return;

2842: IEX_STRY_UTL_PUB.refresh_uwq_str_summ(l_work_item_id);
2843: end if;
2844: --End bug#5874874 gnramasa 25-Apr-2007
2845:
2846: result := wf_engine.eng_completed ||':'||l_return;
2847:
2848: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2849: iex_debug_pub.logmessage ('**** END cal_post_wait ************');
2850: END IF;

Line 2853: result := wf_engine.eng_completed ||':'||wf_no;

2849: iex_debug_pub.logmessage ('**** END cal_post_wait ************');
2850: END IF;
2851: exception
2852: when others then
2853: result := wf_engine.eng_completed ||':'||wf_no;
2854: wf_core.context('IEX_STRATEGY_WF','cal_post_wait',itemtype,
2855: itemkey,to_char(actid),funcmode);
2856: raise;
2857:

Line 2887: result := wf_engine.eng_null;

2883: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2884: iex_debug_pub.logmessage ('**** START cal_pre_wait ************');
2885: END IF;
2886: if funcmode <> 'RUN' then
2887: result := wf_engine.eng_null;
2888: return;
2889: end if;
2890:
2891: l_strategy_status := wf_engine.GetItemAttrText(itemtype => itemtype,

Line 2891: l_strategy_status := wf_engine.GetItemAttrText(itemtype => itemtype,

2887: result := wf_engine.eng_null;
2888: return;
2889: end if;
2890:
2891: l_strategy_status := wf_engine.GetItemAttrText(itemtype => itemtype,
2892: itemkey => itemkey,
2893: aname => 'STRATEGY_STATUS');
2894: if l_strategy_status = 'CANCELLED' then
2895: l_return := wf_no;

Line 2896: result := wf_engine.eng_completed ||':'||l_return;

2892: itemkey => itemkey,
2893: aname => 'STRATEGY_STATUS');
2894: if l_strategy_status = 'CANCELLED' then
2895: l_return := wf_no;
2896: result := wf_engine.eng_completed ||':'||l_return;
2897: return;
2898: end if;
2899:
2900: l_work_item_temp_id := wf_engine.GetItemAttrNumber(

Line 2900: l_work_item_temp_id := wf_engine.GetItemAttrNumber(

2896: result := wf_engine.eng_completed ||':'||l_return;
2897: return;
2898: end if;
2899:
2900: l_work_item_temp_id := wf_engine.GetItemAttrNumber(
2901: itemtype => itemtype,
2902: itemkey => itemkey,
2903: aname => 'WORKITEM_TEMPLATE_ID');
2904:

Line 2905: l_work_item_id := wf_engine.GetItemAttrNumber(

2901: itemtype => itemtype,
2902: itemkey => itemkey,
2903: aname => 'WORKITEM_TEMPLATE_ID');
2904:
2905: l_work_item_id := wf_engine.GetItemAttrNumber(
2906: itemtype => itemtype,
2907: itemkey => itemkey,
2908: aname => 'WORK_ITEMID');
2909:

Line 2953: wf_engine.SetItemAttrDate(itemtype => itemtype,

2949: l_return := wf_yes;
2950: end if;
2951:
2952:
2953: wf_engine.SetItemAttrDate(itemtype => itemtype,
2954: itemkey => itemkey,
2955: aname => 'PRE_WAIT_TIME',
2956: avalue => l_schedule);
2957:

Line 2962: result := wf_engine.eng_completed ||':'||l_return;

2958: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2959: iex_debug_pub.logMessage('cal_pre_wait result = ' ||l_return);
2960: END IF;
2961:
2962: result := wf_engine.eng_completed ||':'||l_return;
2963:
2964: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2965: iex_debug_pub.logmessage ('**** END cal_pre_wait ************');
2966: END IF;

Line 2969: result := wf_engine.eng_completed ||':'||wf_no;

2965: iex_debug_pub.logmessage ('**** END cal_pre_wait ************');
2966: END IF;
2967: exception
2968: when others then
2969: result := wf_engine.eng_completed ||':'||wf_no;
2970: wf_core.context('IEX_STRATEGY_WF','cal_pre_wait',itemtype,
2971: itemkey,to_char(actid),funcmode);
2972: raise;
2973:

Line 3002: result := wf_engine.eng_null;

2998: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2999: iex_debug_pub.logmessage ('**** START wi_failed_first_time ************');
3000: END IF;
3001: if funcmode <> 'RUN' then
3002: result := wf_engine.eng_null;
3003: return;
3004: end if;
3005:
3006: l_strategy_status := wf_engine.GetItemAttrText(itemtype => itemtype,

Line 3006: l_strategy_status := wf_engine.GetItemAttrText(itemtype => itemtype,

3002: result := wf_engine.eng_null;
3003: return;
3004: end if;
3005:
3006: l_strategy_status := wf_engine.GetItemAttrText(itemtype => itemtype,
3007: itemkey => itemkey,
3008: aname => 'STRATEGY_STATUS');
3009: if l_strategy_status = 'CANCELLED' then
3010: l_return := wf_no;

Line 3011: result := wf_engine.eng_completed ||':'||l_return;

3007: itemkey => itemkey,
3008: aname => 'STRATEGY_STATUS');
3009: if l_strategy_status = 'CANCELLED' then
3010: l_return := wf_no;
3011: result := wf_engine.eng_completed ||':'||l_return;
3012: return;
3013: end if;
3014:
3015: l_create_wi_error_count := wf_engine.GetItemAttrNumber(

Line 3015: l_create_wi_error_count := wf_engine.GetItemAttrNumber(

3011: result := wf_engine.eng_completed ||':'||l_return;
3012: return;
3013: end if;
3014:
3015: l_create_wi_error_count := wf_engine.GetItemAttrNumber(
3016: itemtype => itemtype,
3017: itemkey => itemkey,
3018: aname => 'CREATE_WI_ERROR_COUNT');
3019:

Line 3046: wf_engine.SetItemAttrDate(itemtype => itemtype,

3042:
3043: l_create_wi_error_count := 1;
3044: l_return := wf_yes;
3045:
3046: wf_engine.SetItemAttrDate(itemtype => itemtype,
3047: itemkey => itemkey,
3048: aname => 'RESTART_CREATE_WI_TIME',
3049: avalue => l_restart_create_wi_time);
3050: end if;

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

3048: aname => 'RESTART_CREATE_WI_TIME',
3049: avalue => l_restart_create_wi_time);
3050: end if;
3051:
3052: wf_engine.SetItemAttrNumber(itemtype =>itemtype,
3053: itemkey => itemkey,
3054: aname => 'CREATE_WI_ERROR_COUNT',
3055: avalue => l_create_wi_error_count);
3056:

Line 3061: result := wf_engine.eng_completed ||':'||l_return;

3057: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3058: iex_debug_pub.logMessage('wi_failed_first_time result = ' ||l_return);
3059: END IF;
3060:
3061: result := wf_engine.eng_completed ||':'||l_return;
3062:
3063: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3064: iex_debug_pub.logmessage ('**** END wi_failed_first_time ************');
3065: END IF;

Line 3068: result := wf_engine.eng_completed ||':'||wf_no;

3064: iex_debug_pub.logmessage ('**** END wi_failed_first_time ************');
3065: END IF;
3066: exception
3067: when others then
3068: result := wf_engine.eng_completed ||':'||wf_no;
3069: wf_core.context('IEX_STRATEGY_WF','wi_failed_first_time',itemtype,
3070: itemkey,to_char(actid),funcmode);
3071: raise;
3072:

Line 3097: result := wf_engine.eng_null;

3093: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3094: iex_debug_pub.logmessage ('**** START OPTIONAL_CHECK ************');
3095: END IF;
3096: if funcmode <> 'RUN' then
3097: result := wf_engine.eng_null;
3098: return;
3099: end if;
3100:
3101: -- IF PG_DEBUG < 10 THEN

Line 3106: l_value :=wf_engine.GetActivityLabel(actid);

3102: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3103: iex_debug_pub.logmessage('OPTIONAL_CHECK: ' || '*************FUNCMODE' ||funcmode||'**********************');
3104: END IF;
3105:
3106: l_value :=wf_engine.GetActivityLabel(actid);
3107: wf_engine.SetItemAttrText(itemtype => itemtype,
3108: itemkey => itemkey,
3109: aname => 'ACTIVITY_NAME',
3110: avalue => l_value);

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

3103: iex_debug_pub.logmessage('OPTIONAL_CHECK: ' || '*************FUNCMODE' ||funcmode||'**********************');
3104: END IF;
3105:
3106: l_value :=wf_engine.GetActivityLabel(actid);
3107: wf_engine.SetItemAttrText(itemtype => itemtype,
3108: itemkey => itemkey,
3109: aname => 'ACTIVITY_NAME',
3110: avalue => l_value);
3111: -- IF PG_DEBUG < 10 THEN

Line 3116: l_work_item_temp_id := wf_engine.GetItemAttrNumber(

3112: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3113: iex_debug_pub.logMessage('OPTIONAL_CHECK: ' || 'ACTIVITYNAME' ||l_value);
3114: END IF;
3115:
3116: l_work_item_temp_id := wf_engine.GetItemAttrNumber(
3117: itemtype => itemtype,
3118: itemkey => itemkey,
3119: aname => 'WORKITEM_TEMPLATE_ID');
3120:

Line 3125: result := wf_engine.eng_completed ||':'||l_result;

3121: select nvl(optional_yn,'N') INTO l_result
3122: from iex_stry_temp_work_items_vl
3123: where work_item_temp_id =l_work_item_temp_id;
3124:
3125: result := wf_engine.eng_completed ||':'||l_result;
3126: -- IF PG_DEBUG < 10 THEN
3127: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3128: iex_debug_pub.logmessage ('**** END OPTIONAL_CHECK ************');
3129: END IF;

Line 3132: result := wf_engine.eng_completed ||':'||wf_no;

3128: iex_debug_pub.logmessage ('**** END OPTIONAL_CHECK ************');
3129: END IF;
3130: exception
3131: when others then
3132: result := wf_engine.eng_completed ||':'||wf_no;
3133: wf_core.context('IEX_STRATEGY_WF','OPTIONAL_CHECK',itemtype,
3134: itemkey,to_char(actid),funcmode);
3135: raise;
3136:

Line 3159: result := wf_engine.eng_null;

3155: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3156: iex_debug_pub.logmessage ('**** START ESCALATE_CHECK ************');
3157: END IF;
3158: if funcmode <> 'RUN' then
3159: result := wf_engine.eng_null;
3160: return;
3161: end if;
3162:
3163: l_value :=wf_engine.GetActivityLabel(actid);

Line 3163: l_value :=wf_engine.GetActivityLabel(actid);

3159: result := wf_engine.eng_null;
3160: return;
3161: end if;
3162:
3163: l_value :=wf_engine.GetActivityLabel(actid);
3164: wf_engine.SetItemAttrText(itemtype => itemtype,
3165: itemkey => itemkey,
3166: aname => 'ACTIVITY_NAME',
3167: avalue => l_value);

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

3160: return;
3161: end if;
3162:
3163: l_value :=wf_engine.GetActivityLabel(actid);
3164: wf_engine.SetItemAttrText(itemtype => itemtype,
3165: itemkey => itemkey,
3166: aname => 'ACTIVITY_NAME',
3167: avalue => l_value);
3168:

Line 3174: l_work_item_temp_id := wf_engine.GetItemAttrNumber(

3170: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3171: iex_debug_pub.logMessage('ESCALATE_CHECK: ' || 'ACTIVITYNAME' ||l_value);
3172: END IF;
3173:
3174: l_work_item_temp_id := wf_engine.GetItemAttrNumber(
3175: itemtype => itemtype,
3176: itemkey => itemkey,
3177: aname => 'WORKITEM_TEMPLATE_ID');
3178:

Line 3183: result := wf_engine.eng_completed ||':'||l_result;

3179: select nvl(escalate_yn,'N') INTO l_result
3180: from iex_stry_temp_work_items_vl
3181: where work_item_temp_id =l_work_item_temp_id;
3182:
3183: result := wf_engine.eng_completed ||':'||l_result;
3184: -- IF PG_DEBUG < 10 THEN
3185: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3186: iex_debug_pub.logmessage ('**** END ESCALATE_CHECK ************');
3187: END IF;

Line 3190: result := wf_engine.eng_completed ||':'||wf_no;

3186: iex_debug_pub.logmessage ('**** END ESCALATE_CHECK ************');
3187: END IF;
3188: exception
3189: when others then
3190: result := wf_engine.eng_completed ||':'||wf_no;
3191: wf_core.context('IEX_STRATEGY_WF','ESCALATE_CHECK',itemtype,
3192: itemkey,to_char(actid),funcmode);
3193: raise;
3194:

Line 3216: result := wf_engine.eng_null;

3212: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3213: iex_debug_pub.logmessage ('**** START NOTIFY_CHECK ************');
3214: END IF;
3215: if funcmode <> 'RUN' then
3216: result := wf_engine.eng_null;
3217: return;
3218: end if;
3219:
3220: /* l_value :=wf_engine.GetActivityLabel(actid);

Line 3220: /* l_value :=wf_engine.GetActivityLabel(actid);

3216: result := wf_engine.eng_null;
3217: return;
3218: end if;
3219:
3220: /* l_value :=wf_engine.GetActivityLabel(actid);
3221: wf_engine.SetItemAttrText(itemtype => itemtype,
3222: itemkey => itemkey,
3223: aname => 'ACTIVITY_NAME',
3224: avalue => l_value);

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

3217: return;
3218: end if;
3219:
3220: /* l_value :=wf_engine.GetActivityLabel(actid);
3221: wf_engine.SetItemAttrText(itemtype => itemtype,
3222: itemkey => itemkey,
3223: aname => 'ACTIVITY_NAME',
3224: avalue => l_value);
3225: -- IF PG_DEBUG < 10 THEN

Line 3230: l_work_item_temp_id := wf_engine.GetItemAttrNumber(

3226: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3227: iex_debug_pub.logMessage('NOTIFY_CHECK: ' || 'ACTIVITYNAME' ||l_value);
3228: END IF;
3229: */
3230: l_work_item_temp_id := wf_engine.GetItemAttrNumber(
3231: itemtype => itemtype,
3232: itemkey => itemkey,
3233: aname => 'WORKITEM_TEMPLATE_ID');
3234:

Line 3239: result := wf_engine.eng_completed ||':'||l_result;

3235: select nvl(notify_yn,'N') INTO l_result
3236: from iex_stry_temp_work_items_vl
3237: where work_item_temp_id =l_work_item_temp_id;
3238:
3239: result := wf_engine.eng_completed ||':'||l_result;
3240: -- IF PG_DEBUG < 10 THEN
3241: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3242: iex_debug_pub.logmessage ('**** END NOTIFY_CHECK ************');
3243: END IF;

Line 3246: result := wf_engine.eng_completed ||':'||wf_no;

3242: iex_debug_pub.logmessage ('**** END NOTIFY_CHECK ************');
3243: END IF;
3244: exception
3245: when others then
3246: result := wf_engine.eng_completed ||':'||wf_no;
3247: wf_core.context('IEX_STRATEGY_WF','NOTIFY_CHECK',itemtype,
3248: itemkey,to_char(actid),funcmode);
3249: raise;
3250:

Line 3270: wf_engine.SetItemAttrDate(itemtype => itemtype,

3266: END IF;
3267: select sysdate+(23/24)
3268: into l_execution_time
3269: from dual;
3270: wf_engine.SetItemAttrDate(itemtype => itemtype,
3271: itemkey => itemkey,
3272: aname => 'ON_HOLD_WAIT_TIME',
3273: avalue => l_execution_time);
3274:

Line 3310: result := wf_engine.eng_null;

3306: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3307: iex_debug_pub.logmessage ('**** START ONHOLD_CHECK ************');
3308: END IF;
3309: if funcmode <> 'RUN' then
3310: result := wf_engine.eng_null;
3311: return;
3312: end if;
3313:
3314: /*l_value :=wf_engine.GetActivityLabel(actid);

Line 3314: /*l_value :=wf_engine.GetActivityLabel(actid);

3310: result := wf_engine.eng_null;
3311: return;
3312: end if;
3313:
3314: /*l_value :=wf_engine.GetActivityLabel(actid);
3315: wf_engine.SetItemAttrText(itemtype => itemtype,
3316: itemkey => itemkey,
3317: aname => 'ACTIVITY_NAME',
3318: avalue => l_value);

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

3311: return;
3312: end if;
3313:
3314: /*l_value :=wf_engine.GetActivityLabel(actid);
3315: wf_engine.SetItemAttrText(itemtype => itemtype,
3316: itemkey => itemkey,
3317: aname => 'ACTIVITY_NAME',
3318: avalue => l_value);
3319: -- IF PG_DEBUG < 10 THEN

Line 3333: l_value :=wf_engine.GetActivityLabel(actid);

3329: --But status of the strategy in table IEX_STRATEGIES is still 'ONHOLD'.
3330: --If workflow is waiting at WAIT_ON_HOLD_SIGNAL node, it will be completed and it goes to ONHOLD_CHECK node.
3331: --Since the status of the strategy in table IEX_STRATEGIES is still 'ONHOLD', it again goes to WAIT_ON_HOLD_SIGNAL node
3332: --and waits for 23 hrs. To avoid this added the following code.
3333: l_value :=wf_engine.GetActivityLabel(actid);
3334: if instr(l_value,'STRATEGY_WORKFLOW')>0 then
3335: l_strategy_status := wf_engine.GetItemAttrText(
3336: itemtype => itemtype,
3337: itemkey => itemkey,

Line 3335: l_strategy_status := wf_engine.GetItemAttrText(

3331: --Since the status of the strategy in table IEX_STRATEGIES is still 'ONHOLD', it again goes to WAIT_ON_HOLD_SIGNAL node
3332: --and waits for 23 hrs. To avoid this added the following code.
3333: l_value :=wf_engine.GetActivityLabel(actid);
3334: if instr(l_value,'STRATEGY_WORKFLOW')>0 then
3335: l_strategy_status := wf_engine.GetItemAttrText(
3336: itemtype => itemtype,
3337: itemkey => itemkey,
3338: aname => 'STRATEGY_STATUS');
3339:

Line 3341: result := wf_engine.eng_completed ||':'||'N';

3337: itemkey => itemkey,
3338: aname => 'STRATEGY_STATUS');
3339:
3340: if l_strategy_status in ('CLOSED','CANCELLED') then
3341: result := wf_engine.eng_completed ||':'||'N';
3342: return;
3343: end if;
3344: end if;
3345: --end bug#4506922 schekuri 03-Dec-2005

Line 3347: l_strategy_id := wf_engine.GetItemAttrNumber(

3343: end if;
3344: end if;
3345: --end bug#4506922 schekuri 03-Dec-2005
3346:
3347: l_strategy_id := wf_engine.GetItemAttrNumber(
3348: itemtype => itemtype,
3349: itemkey => itemkey,
3350: aname => 'STRATEGY_ID');
3351:

Line 3362: --l_value :=wf_engine.GetActivityLabel(actid);

3358: --added the following code to avoid the workflow to get suspended at calc post wait node
3359: --after the timeout of the optional work item when the status of strategy is onhold.
3360: --Onhold check after calc post wait node stops the workflow when the strategy is onhold.
3361: --This is needed for workflows which are already started by the time this patch applied.
3362: --l_value :=wf_engine.GetActivityLabel(actid);
3363: if instr(l_value,'STRATEGY_SUBPROCESS')>0 and l_result = 'Y' then
3364: l_work_item_id := wf_engine.GetItemAttrText(
3365: itemtype => itemtype,
3366: itemkey => itemkey,

Line 3364: l_work_item_id := wf_engine.GetItemAttrText(

3360: --Onhold check after calc post wait node stops the workflow when the strategy is onhold.
3361: --This is needed for workflows which are already started by the time this patch applied.
3362: --l_value :=wf_engine.GetActivityLabel(actid);
3363: if instr(l_value,'STRATEGY_SUBPROCESS')>0 and l_result = 'Y' then
3364: l_work_item_id := wf_engine.GetItemAttrText(
3365: itemtype => itemtype,
3366: itemkey => itemkey,
3367: aname => 'WORK_ITEMID');
3368: if l_work_item_id is not null then

Line 3387: result := wf_engine.eng_completed ||':'||l_result;

3383: end if;
3384:
3385: --end bug#4506922 schekuri 03-Dec-2005
3386:
3387: result := wf_engine.eng_completed ||':'||l_result;
3388:
3389: --Begin - schekuri - 03-Dec-2005 - bug#4506922
3390: --if strategy is ONHOLD update the attribute 'ON_HOLD_WAIT_TIME' to sysdate + 23 hrs.
3391: if l_result='Y' then

Line 3404: result := wf_engine.eng_completed ||':'||wf_no;

3400: END IF;
3401:
3402: exception
3403: when others then
3404: result := wf_engine.eng_completed ||':'||wf_no;
3405: wf_core.context('IEX_STRATEGY_WF','ONHOLD_CHECK',itemtype,
3406: itemkey,to_char(actid),funcmode);
3407: raise;
3408:

Line 3433: result := wf_engine.eng_null;

3429: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3430: iex_debug_pub.logmessage ('**** START UPDATE_WORK_ITEM ************');
3431: END IF;
3432: if funcmode <> 'RUN' then
3433: result := wf_engine.eng_null;
3434: return;
3435: end if;
3436:
3437: l_work_item_id := wf_engine.GetItemAttrText(

Line 3437: l_work_item_id := wf_engine.GetItemAttrText(

3433: result := wf_engine.eng_null;
3434: return;
3435: end if;
3436:
3437: l_work_item_id := wf_engine.GetItemAttrText(
3438: itemtype => itemtype,
3439: itemkey => itemkey,
3440: aname => 'WORK_ITEMID');
3441: -- IF PG_DEBUG < 10 THEN

Line 3454: result := wf_engine.eng_completed ||':'||wf_yes;

3450: x_return_status => l_return_status,
3451: p_work_item_id => l_work_item_id,
3452: p_status => 'TIMEOUT');
3453: if l_return_status =FND_API.G_RET_STS_SUCCESS THEN
3454: result := wf_engine.eng_completed ||':'||wf_yes;
3455: else
3456: RAISE EXC;
3457: END IF;
3458: -- IF PG_DEBUG < 10 THEN

Line 3502: if funcmode <> wf_engine.eng_run then

3498: -- IF PG_DEBUG < 10 THEN
3499: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3500: iex_debug_pub.logmessage ('**** START WAIT_OPTIONAL ************');
3501: END IF;
3502: if funcmode <> wf_engine.eng_run then
3503: -- IF PG_DEBUG < 10 THEN
3504: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3505: iex_debug_pub.logmessage('WAIT_OPTIONAL: ' || 'SECOND TIME FUNCMODE' ||funcmode);
3506: END IF;

Line 3507: result := wf_engine.eng_null;

3503: -- IF PG_DEBUG < 10 THEN
3504: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3505: iex_debug_pub.logmessage('WAIT_OPTIONAL: ' || 'SECOND TIME FUNCMODE' ||funcmode);
3506: END IF;
3507: result := wf_engine.eng_null;
3508: return;
3509: end if;
3510:
3511:

Line 3517: l_value :=wf_engine.GetActivityLabel(actid);

3513: -- IF PG_DEBUG < 10 THEN
3514: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3515: iex_debug_pub.logmessage('WAIT_OPTIONAL: ' || 'FUNCMODE' ||funcmode);
3516: END IF;
3517: l_value :=wf_engine.GetActivityLabel(actid);
3518: wf_engine.SetItemAttrText(itemtype => itemtype,
3519: itemkey => itemkey,
3520: aname => 'ACTIVITY_NAME',
3521: avalue => l_value);

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

3514: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3515: iex_debug_pub.logmessage('WAIT_OPTIONAL: ' || 'FUNCMODE' ||funcmode);
3516: END IF;
3517: l_value :=wf_engine.GetActivityLabel(actid);
3518: wf_engine.SetItemAttrText(itemtype => itemtype,
3519: itemkey => itemkey,
3520: aname => 'ACTIVITY_NAME',
3521: avalue => l_value);
3522: -- IF PG_DEBUG < 10 THEN

Line 3528: result := wf_engine.eng_notified||':'||wf_engine.eng_null||

3524: iex_debug_pub.logMessage('WAIT_OPTIONAL: ' || 'ACTIVITYNAME' ||l_value);
3525: END IF;
3526:
3527:
3528: result := wf_engine.eng_notified||':'||wf_engine.eng_null||
3529: ':'||wf_engine.eng_null;
3530: -- IF PG_DEBUG < 10 THEN
3531: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3532: iex_debug_pub.logmessage ('**** END WAIT_OPTIONAL ************');

Line 3529: ':'||wf_engine.eng_null;

3525: END IF;
3526:
3527:
3528: result := wf_engine.eng_notified||':'||wf_engine.eng_null||
3529: ':'||wf_engine.eng_null;
3530: -- IF PG_DEBUG < 10 THEN
3531: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3532: iex_debug_pub.logmessage ('**** END WAIT_OPTIONAL ************');
3533: END IF;

Line 3536: result := wf_engine.eng_completed ||':'||wf_no;

3532: iex_debug_pub.logmessage ('**** END WAIT_OPTIONAL ************');
3533: END IF;
3534: exception
3535: when others then
3536: result := wf_engine.eng_completed ||':'||wf_no;
3537: wf_core.context('IEX_STRATEGY_WF','WAIT_OPTIONAL',itemtype,
3538: itemkey,to_char(actid),funcmode);
3539: raise;
3540:

Line 3562: if funcmode <> wf_engine.eng_run then

3558: -- IF PG_DEBUG < 10 THEN
3559: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3560: iex_debug_pub.logmessage ('**** START WAIT_ESCALATION ************');
3561: END IF;
3562: if funcmode <> wf_engine.eng_run then
3563: result := wf_engine.eng_null;
3564: return;
3565: end if;
3566:

Line 3563: result := wf_engine.eng_null;

3559: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3560: iex_debug_pub.logmessage ('**** START WAIT_ESCALATION ************');
3561: END IF;
3562: if funcmode <> wf_engine.eng_run then
3563: result := wf_engine.eng_null;
3564: return;
3565: end if;
3566:
3567:

Line 3573: l_value :=wf_engine.GetActivityLabel(actid);

3569: -- IF PG_DEBUG < 10 THEN
3570: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3571: iex_debug_pub.logmessage('WAIT_ESCALATION: ' || 'FUNCMODE' ||funcmode);
3572: END IF;
3573: l_value :=wf_engine.GetActivityLabel(actid);
3574: wf_engine.SetItemAttrText(itemtype => itemtype,
3575: itemkey => itemkey,
3576: aname => 'ACTIVITY_NAME',
3577: avalue => l_value);

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

3570: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3571: iex_debug_pub.logmessage('WAIT_ESCALATION: ' || 'FUNCMODE' ||funcmode);
3572: END IF;
3573: l_value :=wf_engine.GetActivityLabel(actid);
3574: wf_engine.SetItemAttrText(itemtype => itemtype,
3575: itemkey => itemkey,
3576: aname => 'ACTIVITY_NAME',
3577: avalue => l_value);
3578:

Line 3585: result := wf_engine.eng_notified||':'||wf_engine.eng_null||

3581: iex_debug_pub.logMessage('WAIT_ESCALATION: ' || 'ACTIVITYNAME' ||l_value);
3582: END IF;
3583:
3584:
3585: result := wf_engine.eng_notified||':'||wf_engine.eng_null||
3586: ':'||wf_engine.eng_null;
3587: -- IF PG_DEBUG < 10 THEN
3588: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3589: iex_debug_pub.logmessage ('**** END WAIT_ESCALATION ************');

Line 3586: ':'||wf_engine.eng_null;

3582: END IF;
3583:
3584:
3585: result := wf_engine.eng_notified||':'||wf_engine.eng_null||
3586: ':'||wf_engine.eng_null;
3587: -- IF PG_DEBUG < 10 THEN
3588: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3589: iex_debug_pub.logmessage ('**** END WAIT_ESCALATION ************');
3590: END IF;

Line 3593: result := wf_engine.eng_completed ||':'||wf_no;

3589: iex_debug_pub.logmessage ('**** END WAIT_ESCALATION ************');
3590: END IF;
3591: exception
3592: when others then
3593: result := wf_engine.eng_completed ||':'||wf_no;
3594: wf_core.context('IEX_STRATEGY_WF','WAIT_ESCALATION',itemtype,
3595: itemkey,to_char(actid),funcmode);
3596: raise;
3597:

Line 3628: if funcmode <> wf_engine.eng_run then

3624: -- IF PG_DEBUG < 10 THEN
3625: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3626: iex_debug_pub.logmessage ('**** START WAIT_STRATEGY ************');
3627: END IF;
3628: if funcmode <> wf_engine.eng_run then
3629: result := wf_engine.eng_null;
3630: return;
3631: end if;
3632:

Line 3629: result := wf_engine.eng_null;

3625: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3626: iex_debug_pub.logmessage ('**** START WAIT_STRATEGY ************');
3627: END IF;
3628: if funcmode <> wf_engine.eng_run then
3629: result := wf_engine.eng_null;
3630: return;
3631: end if;
3632:
3633:

Line 3639: l_value :=wf_engine.GetActivityLabel(actid);

3635: -- IF PG_DEBUG < 10 THEN
3636: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3637: iex_debug_pub.logmessage('WAIT_STRATEGY: ' || 'FUNCMODE' ||funcmode);
3638: END IF;
3639: l_value :=wf_engine.GetActivityLabel(actid);
3640: wf_engine.SetItemAttrText(itemtype => itemtype,
3641: itemkey => itemkey,
3642: aname => 'ACTIVITY_NAME',
3643: avalue => l_value);

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

3636: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3637: iex_debug_pub.logmessage('WAIT_STRATEGY: ' || 'FUNCMODE' ||funcmode);
3638: END IF;
3639: l_value :=wf_engine.GetActivityLabel(actid);
3640: wf_engine.SetItemAttrText(itemtype => itemtype,
3641: itemkey => itemkey,
3642: aname => 'ACTIVITY_NAME',
3643: avalue => l_value);
3644:

Line 3651: result := wf_engine.eng_notified||':'||wf_engine.eng_null||

3647: iex_debug_pub.logMessage('WAIT_STRATEGY: ' || 'ACTIVITYNAME' ||l_value);
3648: END IF;
3649:
3650:
3651: result := wf_engine.eng_notified||':'||wf_engine.eng_null||
3652: ':'||wf_engine.eng_null;
3653: -- IF PG_DEBUG < 10 THEN
3654: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3655: iex_debug_pub.logmessage ('**** END WAIT_STRATEGY ************');

Line 3652: ':'||wf_engine.eng_null;

3648: END IF;
3649:
3650:
3651: result := wf_engine.eng_notified||':'||wf_engine.eng_null||
3652: ':'||wf_engine.eng_null;
3653: -- IF PG_DEBUG < 10 THEN
3654: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3655: iex_debug_pub.logmessage ('**** END WAIT_STRATEGY ************');
3656: END IF;

Line 3659: result := wf_engine.eng_completed ||':'||wf_engine.eng_null;

3655: iex_debug_pub.logmessage ('**** END WAIT_STRATEGY ************');
3656: END IF;
3657: exception
3658: when others then
3659: result := wf_engine.eng_completed ||':'||wf_engine.eng_null;
3660: wf_core.context('IEX_STRATEGY_WF','WAIT_STRATEGY',itemtype,
3661: itemkey,to_char(actid),funcmode);
3662: raise;
3663:

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

3682: l_strategy_id NUMBER;
3683:
3684: BEGIN
3685:
3686: wf_engine.SetItemAttrText(itemtype => itemtype,
3687: itemkey => itemkey,
3688: aname => 'STRATEGY_STATUS',
3689: avalue => 'CANCELLED');
3690:

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

3689: avalue => 'CANCELLED');
3690:
3691: -- inside the close_strategy_procedure , the
3692: --existing strategy is CANCELLED.
3693: wf_engine.SetItemAttrNumber(itemtype =>itemtype,
3694: itemkey => itemkey,
3695: aname => 'WORK_ITEMID',
3696: avalue => NULL);
3697:

Line 3700: result := wf_engine.eng_completed ||':'||wf_engine.eng_null;

3696: avalue => NULL);
3697:
3698: exception
3699: when others then
3700: result := wf_engine.eng_completed ||':'||wf_engine.eng_null;
3701: wf_core.context('IEX_STRATEGY_WF','SET_STRATEGY_STATUS',itemtype,
3702: itemkey,to_char(actid),funcmode);
3703: raise;
3704: END SET_STRATEGY_STATUS;

Line 3751: wf_engine.abortprocess(itemtype =>'IEXSTRY',

3747: l_return_status);
3748: END IF;
3749:
3750: BEGIN
3751: wf_engine.abortprocess(itemtype =>'IEXSTRY',
3752: itemkey => l_strategy_id);
3753: EXCEPTION
3754: WHEN OTHERS THEN
3755: -- IF PG_DEBUG < 10 THEN

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

3789: iex_debug_pub.logmessage ('**** start SET_SESSION_CTX ************');
3790: END IF;
3791: --set item Attributes
3792: --set org_id
3793: wf_engine.SetItemAttrNumber(itemtype =>itemtype,
3794: itemkey => itemkey,
3795: aname => 'USER_ID',
3796: avalue => FND_GLOBAL.USER_ID);
3797: --set resp_id

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

3794: itemkey => itemkey,
3795: aname => 'USER_ID',
3796: avalue => FND_GLOBAL.USER_ID);
3797: --set resp_id
3798: wf_engine.SetItemAttrNumber(itemtype =>itemtype,
3799: itemkey => itemkey,
3800: aname => 'RESP_ID',
3801: avalue => FND_GLOBAL.RESP_ID);
3802: --set app_resp_id

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

3799: itemkey => itemkey,
3800: aname => 'RESP_ID',
3801: avalue => FND_GLOBAL.RESP_ID);
3802: --set app_resp_id
3803: wf_engine.SetItemAttrNumber(itemtype =>itemtype,
3804: itemkey => itemkey,
3805: aname => 'RESP_APPL_ID',
3806: avalue => FND_GLOBAL.RESP_APPL_ID );
3807:

Line 3823: l_party_id := wf_engine.GetItemAttrNumber(

3819: END IF;
3820:
3821:
3822: ---get party_id from the work flow
3823: l_party_id := wf_engine.GetItemAttrNumber(
3824: itemtype => itemtype,
3825: itemkey => itemkey,
3826: aname => 'PARTY_ID');
3827:

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

3827:
3828: if l_party_id is not null then
3829: begin
3830: select party_name into l_party_name from hz_parties where party_id = l_party_id;
3831: wf_engine.SetItemAttrText(itemtype =>itemtype,
3832: itemkey => itemkey,
3833: aname => 'CUSTOMER_NAME',
3834: avalue => l_party_name);
3835: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 3849: result := wf_engine.eng_completed ||':'||wf_engine.eng_null;

3845: iex_debug_pub.logmessage ('**** End SET_SESSION_CTX ************');
3846: END IF;
3847: EXCEPTION
3848: when others then
3849: result := wf_engine.eng_completed ||':'||wf_engine.eng_null;
3850: wf_core.context('IEX_STRATEGY_WF','SET_SESSION_CTX',itemtype,
3851: itemkey,to_char(actid),funcmode);
3852: raise;
3853:

Line 4248: if funcmode <> wf_engine.eng_run then

4244: BEGIN
4245: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
4246: iex_debug_pub.logmessage ('**** START wait_on_hold_signal ************');
4247: END IF;
4248: if funcmode <> wf_engine.eng_run then
4249: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
4250: iex_debug_pub.logmessage('SECOND TIME FUNCMODE' ||funcmode);
4251: END IF;
4252: result := wf_engine.eng_null;

Line 4252: result := wf_engine.eng_null;

4248: if funcmode <> wf_engine.eng_run then
4249: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
4250: iex_debug_pub.logmessage('SECOND TIME FUNCMODE' ||funcmode);
4251: END IF;
4252: result := wf_engine.eng_null;
4253: return;
4254: end if;
4255:
4256:

Line 4261: l_value :=wf_engine.GetActivityLabel(actid);

4257:
4258: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
4259: iex_debug_pub.logmessage('FUNCMODE' ||funcmode);
4260: END IF;
4261: l_value :=wf_engine.GetActivityLabel(actid);
4262: wf_engine.SetItemAttrText(itemtype => itemtype,
4263: itemkey => itemkey,
4264: aname => 'ACTIVITY_NAME',
4265: avalue => l_value);

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

4258: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
4259: iex_debug_pub.logmessage('FUNCMODE' ||funcmode);
4260: END IF;
4261: l_value :=wf_engine.GetActivityLabel(actid);
4262: wf_engine.SetItemAttrText(itemtype => itemtype,
4263: itemkey => itemkey,
4264: aname => 'ACTIVITY_NAME',
4265: avalue => l_value);
4266: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 4271: result := wf_engine.eng_notified||':'||wf_engine.eng_null||

4267: iex_debug_pub.logMessage('ACTIVITYNAME' ||l_value);
4268: END IF;
4269:
4270:
4271: result := wf_engine.eng_notified||':'||wf_engine.eng_null||
4272: ':'||wf_engine.eng_null;
4273: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
4274: iex_debug_pub.logmessage ('**** END wait_on_hold_signal ************');
4275: END IF;

Line 4272: ':'||wf_engine.eng_null;

4268: END IF;
4269:
4270:
4271: result := wf_engine.eng_notified||':'||wf_engine.eng_null||
4272: ':'||wf_engine.eng_null;
4273: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
4274: iex_debug_pub.logmessage ('**** END wait_on_hold_signal ************');
4275: END IF;
4276: exception

Line 4278: result := wf_engine.eng_completed ||':'||wf_no;

4274: iex_debug_pub.logmessage ('**** END wait_on_hold_signal ************');
4275: END IF;
4276: exception
4277: when others then
4278: result := wf_engine.eng_completed ||':'||wf_no;
4279: wf_core.context('IEX_STRATEGY_WF','wait_on_hold_signal',itemtype,
4280: itemkey,to_char(actid),funcmode);
4281: raise;
4282:

Line 4307: if funcmode <> wf_engine.eng_run then

4303:
4304: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
4305: iex_debug_pub.logmessage ('**** START update_work_item_to_open ************');
4306: END IF;
4307: if funcmode <> wf_engine.eng_run then
4308: result := wf_engine.eng_null;
4309: return;
4310: end if;
4311:

Line 4308: result := wf_engine.eng_null;

4304: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
4305: iex_debug_pub.logmessage ('**** START update_work_item_to_open ************');
4306: END IF;
4307: if funcmode <> wf_engine.eng_run then
4308: result := wf_engine.eng_null;
4309: return;
4310: end if;
4311:
4312: l_work_item_id := wf_engine.GetItemAttrNumber(

Line 4312: l_work_item_id := wf_engine.GetItemAttrNumber(

4308: result := wf_engine.eng_null;
4309: return;
4310: end if;
4311:
4312: l_work_item_id := wf_engine.GetItemAttrNumber(
4313: itemtype => itemtype,
4314: itemkey => itemkey,
4315: aname => 'WORK_ITEMID');
4316:

Line 4317: l_strategy_status := wf_engine.GetItemAttrText(

4313: itemtype => itemtype,
4314: itemkey => itemkey,
4315: aname => 'WORK_ITEMID');
4316:
4317: l_strategy_status := wf_engine.GetItemAttrText(
4318: itemtype => itemtype,
4319: itemkey => itemkey,
4320: aname => 'STRATEGY_STATUS');
4321:

Line 4326: result := wf_engine.eng_completed ||':'||wf_yes;

4322: iex_debug_pub.logMessage('Got the work item ' || itemtype || ' item key ' || itemkey
4323: || ' l_work_item_ID ' || l_work_item_id || ' Strategy_status ' || l_strategy_status);
4324:
4325: if l_strategy_status in ('CLOSED','CANCELLED') then
4326: result := wf_engine.eng_completed ||':'||wf_yes;
4327: return;
4328: end if;
4329:
4330: if (l_work_item_id is not null ) then

Line 4350: l_value :=wf_engine.GetActivityLabel(actid);

4346: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
4347: iex_debug_pub.logmessage('FUNCMODE ' ||funcmode);
4348: END IF;
4349:
4350: l_value :=wf_engine.GetActivityLabel(actid);
4351:
4352: wf_engine.SetItemAttrText(itemtype => itemtype,
4353: itemkey => itemkey,
4354: aname => 'ACTIVITY_NAME',

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

4348: END IF;
4349:
4350: l_value :=wf_engine.GetActivityLabel(actid);
4351:
4352: wf_engine.SetItemAttrText(itemtype => itemtype,
4353: itemkey => itemkey,
4354: aname => 'ACTIVITY_NAME',
4355: avalue => l_value);
4356:

Line 4362: result := wf_engine.eng_completed ||':'||wf_yes;

4358: iex_debug_pub.logMessage('ACTIVITYNAME ' ||l_value);
4359: END IF;
4360:
4361:
4362: result := wf_engine.eng_completed ||':'||wf_yes;
4363:
4364: exception
4365: when others then
4366: iex_debug_pub.logmessage ('**** EXCEPTION update_work_item_to_open ************');

Line 4367: result := wf_engine.eng_completed ||':'||wf_no;

4363:
4364: exception
4365: when others then
4366: iex_debug_pub.logmessage ('**** EXCEPTION update_work_item_to_open ************');
4367: result := wf_engine.eng_completed ||':'||wf_no;
4368: wf_core.context('IEX_STRATEGY_WF','wait_on_hold_signal',itemtype,
4369: itemkey,to_char(actid),funcmode);
4370: raise;
4371: END;

Line 4402: result := wf_engine.eng_null;

4398: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
4399: iex_debug_pub.logmessage ('**** START UPDATE_ESCALATION_FLAG ************');
4400: END IF;
4401: if funcmode <> 'RUN' then
4402: result := wf_engine.eng_null;
4403: return;
4404: end if;
4405:
4406: l_work_item_id := wf_engine.GetItemAttrText(

Line 4406: l_work_item_id := wf_engine.GetItemAttrText(

4402: result := wf_engine.eng_null;
4403: return;
4404: end if;
4405:
4406: l_work_item_id := wf_engine.GetItemAttrText(
4407: itemtype => itemtype,
4408: itemkey => itemkey,
4409: aname => 'WORK_ITEMID');
4410: l_party_id := wf_engine.GetItemAttrText(

Line 4410: l_party_id := wf_engine.GetItemAttrText(

4406: l_work_item_id := wf_engine.GetItemAttrText(
4407: itemtype => itemtype,
4408: itemkey => itemkey,
4409: aname => 'WORK_ITEMID');
4410: l_party_id := wf_engine.GetItemAttrText(
4411: itemtype => itemtype,
4412: itemkey => itemkey,
4413: aname => 'PARTY_ID');
4414: -- IF PG_DEBUG < 10 THEN

Line 4449: result := wf_engine.eng_completed ||':'||wf_yes;

4445: when others then
4446: iex_debug_pub.logmessage('UPDATE_ESC_FLAG:Exception when refreshing UWQ Summary: '||SQLERRM);
4447: end;
4448:
4449: result := wf_engine.eng_completed ||':'||wf_yes;
4450: else
4451: RAISE EXC;
4452: END IF;
4453: -- IF PG_DEBUG < 10 THEN