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 88: wf_engine.itemstatus(itemtype => 'IEXWRREQ', itemkey => l_itemkey, status => l_status, result => l_result);

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

Line 91: if l_status <> wf_engine.eng_completed then

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

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

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

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

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

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

107: FOR c_rec in c_get_itemtype
108: LOOP
109: begin -- Added for bug#8493656 by PNAVEENK Moved all the code in the loop into the scope of exception handler
110: if c_rec.itemtype IS NOT NULL THEN
111: wf_engine.itemstatus(itemtype => c_rec.itemtype,
112: itemkey => c_rec.work_item_id,
113: status => l_status,
114: result => l_result);
115: -- IF PG_DEBUG < 10 THEN

Line 121: IF l_status <> wf_engine.eng_completed THEN

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

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

123: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
124: iex_debug_pub.logmessage('abort_processes: ' || ' process has not completed and status =>'|| l_status);
125: END IF;
126: -- BEGIN commented for bug#8493656
127: wf_engine.abortprocess(itemtype => c_rec.itemtype,
128: itemkey => c_rec.work_item_id);
129: END IF; -- Added for bug#8493656
130: end if; -- Added for bug#8493656
131: EXCEPTION

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

149: FOR c_rec in c_workitems
150: LOOP
151: -- Start for the bug 8996459 PNAVEENK
152: Begin
153: wf_engine.itemstatus(itemtype => l_itemtype,
154: itemkey => c_rec.work_item_id,
155: status =>l_status,
156: result =>l_result);
157: -- IF PG_DEBUG < 10 THEN

Line 169: IF l_status <> wf_engine.eng_completed THEN

165: iex_debug_pub.logmessage(' Exception in finding workflow of work_item_id ' || c_rec.work_item_id);
166: end;
167:
168: -- end for bug 8996459
169: IF l_status <> wf_engine.eng_completed THEN
170: -- IF PG_DEBUG < 10 THEN
171: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
172: iex_debug_pub.logmessage ('abort_processes: ' || ' in fulfilment and process has not completed '||
173: 'and status =>'||l_status);

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

174: END IF;
175:
176:
177: BEGIN
178: wf_engine.abortprocess(itemtype => l_itemtype,
179: itemkey => c_rec.work_item_id);
180:
181:
182:

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

379: get_username ( p_resource_id =>p_resource_id,
380: x_username =>l_username,
381: x_source_name =>l_source_name);
382:
383: wf_engine.SetItemAttrText(itemtype => itemtype,
384: itemkey => itemkey,
385: aname => 'ASSIGNEE',
386: avalue => l_source_name);
387: --End bug 6717880/7170165 by Ehuh

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

385: aname => 'ASSIGNEE',
386: avalue => l_source_name);
387: --End bug 6717880/7170165 by Ehuh
388:
389: wf_engine.SetItemAttrText(itemtype => itemtype,
390: itemkey => itemkey,
391: aname => 'NOTIFICATION_USERNAME',
392: avalue => l_username);
393:

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

414: l_mgr_resource_id := p_resource_id;
415: end if;
416:
417:
418: wf_engine.SetItemAttrText(itemtype => itemtype,
419: itemkey => itemkey,
420: aname => 'NOTIFICATION_MGRNAME',
421: avalue => l_mgrname);
422: -- IF PG_DEBUG < 10 THEN

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

448: -- IF PG_DEBUG < 10 THEN
449: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
450: iex_debug_pub.logmessage ('**** BEGIN set_escalate_wait_time ************');
451: END IF;
452: wf_engine.SetItemAttrDate(itemtype => itemtype,
453: itemkey => itemkey,
454: aname => 'ESCALATE_WAIT_TIME',
455: avalue => p_escalate_date);
456: -- IF PG_DEBUG < 10 THEN

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

478: -- IF PG_DEBUG < 10 THEN
479: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
480: iex_debug_pub.logmessage ('**** BEGIN set_optional_wait_time ************');
481: END IF;
482: wf_engine.SetItemAttrDate(itemtype => itemtype,
483: itemkey => itemkey,
484: aname => 'OPTIONAL_WAIT_TIME',
485: avalue => p_optional_date);
486: -- IF PG_DEBUG < 10 THEN

Line 534: l_work_item_id := wf_engine.GetItemAttrNumber(

530: -- IF PG_DEBUG < 10 THEN
531: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
532: iex_debug_pub.logmessage ('**** BEGIN populate_schedule_times ************');
533: END IF;
534: l_work_item_id := wf_engine.GetItemAttrNumber(
535: itemtype => itemtype,
536: itemkey => itemkey,
537: aname => 'WORK_ITEMID');
538:

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

604: itemtype =>itemtype,
605: itemkey =>itemkey);
606: end if;
607: --set workitem_template_id attribute
608: wf_engine.SetItemAttrNumber(itemtype => itemtype,
609: itemkey => itemkey,
610: aname => 'WORKITEM_TEMPLATE_ID',
611: avalue => p_work_item_temp_id);
612: --reset the activity_label

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

609: itemkey => itemkey,
610: aname => 'WORKITEM_TEMPLATE_ID',
611: avalue => p_work_item_temp_id);
612: --reset the activity_label
613: wf_engine.SetItemAttrText(itemtype => itemtype,
614: itemkey => itemkey,
615: aname => 'ACTIVITY_NAME',
616: avalue => null);
617: --reset the status

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

614: itemkey => itemkey,
615: aname => 'ACTIVITY_NAME',
616: avalue => null);
617: --reset the status
618: wf_engine.SetItemAttrText(itemtype => itemtype,
619: itemkey => itemkey,
620: aname => 'STRATEGY_STATUS',
621: avalue => null);
622:

Line 1287: wf_engine.SetItemAttrText(

1283: Open c_get_accloc(p_strategy_id);
1284: Fetch c_get_accloc into l_acct_number,l_location;
1285: if c_get_accloc%NOTFOUND then null;
1286: else
1287: wf_engine.SetItemAttrText(
1288: itemtype =>itemtype,
1289: itemkey =>itemkey,
1290: aname => 'ACCOUNT_NUMBER',
1291: avalue => l_acct_number);

Line 1293: wf_engine.SetItemAttrText(

1289: itemkey =>itemkey,
1290: aname => 'ACCOUNT_NUMBER',
1291: avalue => l_acct_number);
1292:
1293: wf_engine.SetItemAttrText(
1294: itemtype =>itemtype,
1295: itemkey =>itemkey,
1296: aname => 'BILL_TO',
1297: avalue => l_location);

Line 1341: wf_engine.SetItemAttrNumber(

1337: x_return_status => l_return_status,
1338: p_strategy_id => p_strategy_id,
1339: p_work_item_id => x_work_item_id);
1340:
1341: wf_engine.SetItemAttrNumber(
1342: itemtype =>itemtype,
1343: itemkey =>itemkey,
1344: aname => 'WORK_ITEMID',
1345: avalue => x_work_item_id);

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

1350: from IEX_STRY_TEMP_WORK_ITEMS_VL a, IEX_STRATEGY_WORK_ITEMS b
1351: where b.work_item_template_id = a.work_item_temp_id
1352: and b.work_item_id = x_work_item_id;
1353:
1354: wf_engine.SetItemAttrText(itemtype =>itemtype,
1355: itemkey => itemkey,
1356: aname => 'WORK_ITEM_NAME',
1357: avalue => l_workitem_name);
1358: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

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

1389: END IF;
1390:
1391: -- reset activity_name attribute each time a work item is created
1392: --06/26
1393: wf_engine.SetItemAttrText(itemtype => itemtype,
1394: itemkey => itemkey,
1395: aname => 'ACTIVITY_NAME',
1396: avalue => NULL);
1397:

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

1430: END IF;
1431: End create_work_item;
1432:
1433: -----------get the status of the process---------------------------------------
1434: -- to see if the process is SUSPEND(wf_engine.eng_suspended )
1435:
1436: PROCEDURE process_status ( p_process in varchar2,
1437: p_itemtype in varchar2,
1438: p_itemkey in varchar2,

Line 1463: x_status :=wf_engine.eng_active;

1459: iex_debug_pub.logmessage ('process_status: ' || 'status is '||x_status);
1460: END IF;
1461: EXCEPTION WHEN OTHERS THEN
1462: -- send the status has active
1463: x_status :=wf_engine.eng_active;
1464:
1465: END process_status;
1466:
1467: --- populate strategy mailer record type

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

1473: -- IF PG_DEBUG < 10 THEN
1474: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1475: iex_debug_pub.logmessage ('**** BEGIN populate_strategy_mailer ************');
1476: END IF;
1477: l_strategy_mailer_rec.strategy_id := wf_engine.GetItemAttrNumber(
1478: itemtype => itemtype,
1479: itemkey => itemkey,
1480: aname => 'STRATEGY_ID');
1481:

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

1478: itemtype => itemtype,
1479: itemkey => itemkey,
1480: aname => 'STRATEGY_ID');
1481:
1482: l_strategy_mailer_rec.delinquency_id := wf_engine.GetItemAttrNumber(
1483: itemtype => itemtype,
1484: itemkey => itemkey,
1485: aname => 'DELINQUENCY_ID');
1486:

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

1484: itemkey => itemkey,
1485: aname => 'DELINQUENCY_ID');
1486:
1487:
1488: l_strategy_mailer_rec.workitem_id := wf_engine.GetItemAttrNumber(
1489: itemtype => itemtype,
1490: itemkey => itemkey,
1491: aname => 'WORK_ITEMID');
1492:

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

1489: itemtype => itemtype,
1490: itemkey => itemkey,
1491: aname => 'WORK_ITEMID');
1492:
1493: l_strategy_mailer_rec.user_id := wf_engine.GetItemAttrNumber(
1494: itemtype => itemtype,
1495: itemkey => itemkey,
1496: aname => 'USER_ID');
1497:

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

1494: itemtype => itemtype,
1495: itemkey => itemkey,
1496: aname => 'USER_ID');
1497:
1498: l_strategy_mailer_rec.resp_id := wf_engine.GetItemAttrNumber(
1499: itemtype => itemtype,
1500: itemkey => itemkey,
1501: aname => 'RESP_ID');
1502:

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

1499: itemtype => itemtype,
1500: itemkey => itemkey,
1501: aname => 'RESP_ID');
1502:
1503: l_strategy_mailer_rec.resp_appl_id := wf_engine.GetItemAttrNumber(
1504: itemtype => itemtype,
1505: itemkey => itemkey,
1506: aname => 'RESP_APPL_ID');
1507: -- IF PG_DEBUG < 10 THEN

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

1527: -- IF PG_DEBUG < 10 THEN
1528: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1529: iex_debug_pub.logmessage ('**** BEGIN populate_custom_workflow ************');
1530: END IF;
1531: l_custom_wf_rec.strategy_id := wf_engine.GetItemAttrNumber(
1532: itemtype => itemtype,
1533: itemkey => itemkey,
1534: aname => 'STRATEGY_ID');
1535:

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

1534: aname => 'STRATEGY_ID');
1535:
1536:
1537:
1538: l_custom_wf_rec.workitem_id := wf_engine.GetItemAttrNumber(
1539: itemtype => itemtype,
1540: itemkey => itemkey,
1541: aname => 'WORK_ITEMID');
1542:

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

1541: aname => 'WORK_ITEMID');
1542:
1543: l_custom_wf_rec.custom_itemtype := p_custom_itemtype;
1544:
1545: l_custom_wf_rec.user_id := wf_engine.GetItemAttrNumber(
1546: itemtype => itemtype,
1547: itemkey => itemkey,
1548: aname => 'USER_ID');
1549:

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

1546: itemtype => itemtype,
1547: itemkey => itemkey,
1548: aname => 'USER_ID');
1549:
1550: l_custom_wf_rec.resp_id := wf_engine.GetItemAttrNumber(
1551: itemtype => itemtype,
1552: itemkey => itemkey,
1553: aname => 'RESP_ID');
1554:

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

1551: itemtype => itemtype,
1552: itemkey => itemkey,
1553: aname => 'RESP_ID');
1554:
1555: l_custom_wf_rec.resp_appl_id := wf_engine.GetItemAttrNumber(
1556: itemtype => itemtype,
1557: itemkey => itemkey,
1558: aname => 'RESP_APPL_ID');
1559:

Line 1801: result := wf_engine.eng_null;

1797:
1798: Begin
1799:
1800: if funcmode <> 'RUN' then
1801: result := wf_engine.eng_null;
1802: return;
1803: end if;
1804:
1805: --IF PG_DEBUG < 10 THEN

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

1814: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1815: iex_debug_pub.logmessage ('check_work_items_completed: ' || 'ITEMKEY =>'||itemkey);
1816: END IF;
1817:
1818: /* l_value :=wf_engine.GetActivityLabel(actid);
1819: wf_engine.SetItemAttrText(itemtype => itemtype,
1820: itemkey => itemkey,
1821: aname => 'ACTIVITY_NAME',
1822: avalue => l_value);

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

1815: iex_debug_pub.logmessage ('check_work_items_completed: ' || 'ITEMKEY =>'||itemkey);
1816: END IF;
1817:
1818: /* l_value :=wf_engine.GetActivityLabel(actid);
1819: wf_engine.SetItemAttrText(itemtype => itemtype,
1820: itemkey => itemkey,
1821: aname => 'ACTIVITY_NAME',
1822: avalue => l_value);
1823: --IF PG_DEBUG < 10 THEN

Line 1844: l_strategy_status := wf_engine.GetItemAttrText(

1840: * work item id is not passed, but we still have to
1841: * check for pending work item if status is 'OPEN'
1842: **/
1843:
1844: l_strategy_status := wf_engine.GetItemAttrText(
1845: itemtype => itemtype,
1846: itemkey => itemkey,
1847: aname => 'STRATEGY_STATUS');
1848:

Line 1850: l_work_item_id := wf_engine.GetItemAttrNumber(

1846: itemkey => itemkey,
1847: aname => 'STRATEGY_STATUS');
1848:
1849:
1850: l_work_item_id := wf_engine.GetItemAttrNumber(
1851: itemtype => itemtype,
1852: itemkey => itemkey,
1853: aname => 'WORK_ITEMID');
1854:

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

1859: 'l_work_item_id =>'||l_work_item_id);
1860: END IF;
1861:
1862: IF l_work_item_id IS NULL and l_strategy_status <> 'OPEN' THEN
1863: result := wf_engine.eng_completed||':'||wf_yes;
1864: return;
1865: END IF;
1866:
1867:

Line 1871: l_strategy_id := wf_engine.GetItemAttrNumber(

1867:
1868:
1869: ---get strategy_id from the work flow
1870:
1871: l_strategy_id := wf_engine.GetItemAttrNumber(
1872: itemtype => itemtype,
1873: itemkey => itemkey,
1874: aname => 'STRATEGY_ID');
1875:

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

1894: LOOP
1895: IF c_get_witem_rec.status IN ('NOTCREATED') THEN
1896: -- NOT IN ('COMPLETE','CANCELLED','TIMEOUT','SKIP') THEN
1897: -- there are pending work items to be processed
1898: result := wf_engine.eng_completed ||':'||wf_no;
1899: -- IF PG_DEBUG < 10 THEN
1900: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1901: iex_debug_pub.logmessage ('check_work_items_completed: ' || 'there are pending witems to be created and result is'||
1902: '=>'||result);

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

1904: return;
1905: END IF;
1906:
1907: END LOOP;
1908: result := wf_engine.eng_completed ||':'||wf_yes;
1909: -- IF PG_DEBUG < 10 THEN
1910: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1911: iex_debug_pub.logmessage ('check_work_items_completed: ' || 'result =>'||result);
1912: END IF;

Line 1962: result := wf_engine.eng_null;

1958: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1959: iex_debug_pub.logmessage ('**** BEGIN close_strategy ************');
1960: END IF;
1961: if funcmode <> 'RUN' then
1962: result := wf_engine.eng_null;
1963: return;
1964: end if;
1965:
1966: /*l_value :=wf_engine.GetActivityLabel(actid);

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

1962: result := wf_engine.eng_null;
1963: return;
1964: end if;
1965:
1966: /*l_value :=wf_engine.GetActivityLabel(actid);
1967: wf_engine.SetItemAttrText(itemtype => itemtype,
1968: itemkey => itemkey,
1969: aname => 'ACTIVITY_NAME',
1970: avalue => l_value);

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

1963: return;
1964: end if;
1965:
1966: /*l_value :=wf_engine.GetActivityLabel(actid);
1967: wf_engine.SetItemAttrText(itemtype => itemtype,
1968: itemkey => itemkey,
1969: aname => 'ACTIVITY_NAME',
1970: avalue => l_value);
1971: -- IF PG_DEBUG < 10 THEN

Line 1979: l_strategy_id := wf_engine.GetItemAttrNumber(

1975: */
1976:
1977: ---get strategy_id from the work flow
1978:
1979: l_strategy_id := wf_engine.GetItemAttrNumber(
1980: itemtype => itemtype,
1981: itemkey => itemkey,
1982: aname => 'STRATEGY_ID');
1983:

Line 1984: l_strategy_status := wf_engine.GetItemAttrText(

1980: itemtype => itemtype,
1981: itemkey => itemkey,
1982: aname => 'STRATEGY_ID');
1983:
1984: l_strategy_status := wf_engine.GetItemAttrText(
1985: itemtype => itemtype,
1986: itemkey => itemkey,
1987: aname => 'STRATEGY_STATUS');
1988:

Line 1989: l_work_item_id := wf_engine.GetItemAttrNumber(

1985: itemtype => itemtype,
1986: itemkey => itemkey,
1987: aname => 'STRATEGY_STATUS');
1988:
1989: l_work_item_id := wf_engine.GetItemAttrNumber(
1990: itemtype => itemtype,
1991: itemkey => itemkey,
1992: aname => 'WORK_ITEMID');
1993:

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

2029:
2030: -- if the result is 'N' then go back to
2031: -- sleep or wait mode
2032: if l_return_status =FND_API.G_RET_STS_SUCCESS THEN
2033: result := wf_engine.eng_completed ||':'||wf_yes;
2034: else
2035: result := wf_engine.eng_completed ||':'||wf_no;
2036: --set the strategy_status back to 'OPEN'
2037: --and go back to sleep mode

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

2031: -- sleep or wait mode
2032: if l_return_status =FND_API.G_RET_STS_SUCCESS THEN
2033: result := wf_engine.eng_completed ||':'||wf_yes;
2034: else
2035: result := wf_engine.eng_completed ||':'||wf_no;
2036: --set the strategy_status back to 'OPEN'
2037: --and go back to sleep mode
2038: wf_engine.SetItemAttrText(itemtype => itemtype,
2039: itemkey => itemkey,

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

2034: else
2035: result := wf_engine.eng_completed ||':'||wf_no;
2036: --set the strategy_status back to 'OPEN'
2037: --and go back to sleep mode
2038: wf_engine.SetItemAttrText(itemtype => itemtype,
2039: itemkey => itemkey,
2040: aname => 'STRATEGY_STATUS',
2041: avalue => 'OPEN');
2042:

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

2054: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2055: iex_debug_pub.logmessage('close_strategy: ' || 'error message is ' || l_error);
2056: END IF;
2057:
2058: wf_engine.SetItemAttrText(itemtype => itemtype,
2059: itemkey => itemkey,
2060: aname => 'ERROR_MESSAGE',
2061: avalue => l_error);
2062:

Line 2121: result := wf_engine.eng_null;

2117: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2118: iex_debug_pub.logmessage ('**** BEGIN create_next_work_item ************');
2119: END IF;
2120: if funcmode <> 'RUN' then
2121: result := wf_engine.eng_null;
2122: return;
2123: end if;
2124:
2125: /*l_value :=wf_engine.GetActivityLabel(actid);

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

2121: result := wf_engine.eng_null;
2122: return;
2123: end if;
2124:
2125: /*l_value :=wf_engine.GetActivityLabel(actid);
2126: wf_engine.SetItemAttrText(itemtype => itemtype,
2127: itemkey => itemkey,
2128: aname => 'ACTIVITY_NAME',
2129: avalue => l_value);

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

2122: return;
2123: end if;
2124:
2125: /*l_value :=wf_engine.GetActivityLabel(actid);
2126: wf_engine.SetItemAttrText(itemtype => itemtype,
2127: itemkey => itemkey,
2128: aname => 'ACTIVITY_NAME',
2129: avalue => l_value);
2130: --IF PG_DEBUG < 10 THEN

Line 2137: l_strategy_id := wf_engine.GetItemAttrNumber(

2133: END IF;
2134: */
2135:
2136: ---get strategy_id from the work flow
2137: l_strategy_id := wf_engine.GetItemAttrNumber(
2138: itemtype => itemtype,
2139: itemkey => itemkey,
2140: aname => 'STRATEGY_ID');
2141:

Line 2143: l_party_id := wf_engine.GetItemAttrNumber(

2139: itemkey => itemkey,
2140: aname => 'STRATEGY_ID');
2141:
2142: ---get party_id from the work flow
2143: l_party_id := wf_engine.GetItemAttrNumber(
2144: itemtype => itemtype,
2145: itemkey => itemkey,
2146: aname => 'PARTY_ID');
2147:

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

2173: iex_debug_pub.logmessage ('create_next_work_item: ' || ' creation of work items and status => '||l_return_status);
2174: END IF;
2175:
2176: if l_return_status <>FND_API.G_RET_STS_SUCCESS THEN
2177: result := wf_engine.eng_completed ||':'||wf_no;
2178: --pass the error message
2179: wf_engine.SetItemAttrText(itemtype => itemtype,
2180: itemkey => itemkey,
2181: aname => 'ERROR_MESSAGE',

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

2175:
2176: if l_return_status <>FND_API.G_RET_STS_SUCCESS THEN
2177: result := wf_engine.eng_completed ||':'||wf_no;
2178: --pass the error message
2179: wf_engine.SetItemAttrText(itemtype => itemtype,
2180: itemkey => itemkey,
2181: aname => 'ERROR_MESSAGE',
2182: avalue => l_error);
2183:

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

2181: aname => 'ERROR_MESSAGE',
2182: avalue => l_error);
2183:
2184: else
2185: result := wf_engine.eng_completed ||':'||wf_yes;
2186:
2187: end if;
2188: --IF PG_DEBUG < 10 THEN
2189: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 2219: result := wf_engine.eng_null;

2215: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2216: iex_debug_pub.logmessage ('**** BEGIN WAIT_SIGNAL ************');
2217: END IF;
2218: if funcmode <> 'RUN' then
2219: result := wf_engine.eng_null;
2220: return;
2221: end if;
2222:
2223: /*l_value :=wf_engine.GetActivityLabel(actid);

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

2219: result := wf_engine.eng_null;
2220: return;
2221: end if;
2222:
2223: /*l_value :=wf_engine.GetActivityLabel(actid);
2224: wf_engine.SetItemAttrText(itemtype => itemtype,
2225: itemkey => itemkey,
2226: aname => 'ACTIVITY_NAME',
2227: avalue => l_value);

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

2220: return;
2221: end if;
2222:
2223: /*l_value :=wf_engine.GetActivityLabel(actid);
2224: wf_engine.SetItemAttrText(itemtype => itemtype,
2225: itemkey => itemkey,
2226: aname => 'ACTIVITY_NAME',
2227: avalue => l_value);
2228: --IF PG_DEBUG < 10 THEN

Line 2235: wf_engine.SuspendProcess(

2231: END IF;
2232: */
2233:
2234: --- suspend process
2235: wf_engine.SuspendProcess(
2236: itemtype => itemtype,
2237: itemkey => itemkey);
2238: -- 05/10/02 the form doesnot know the workflow is
2239: -- suspended, so trying to issue a commit to see

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

2238: -- 05/10/02 the form doesnot know the workflow is
2239: -- suspended, so trying to issue a commit to see
2240: --if it works.
2241: --COMMIT;
2242: result := wf_engine.eng_completed ||':'||wf_yes;
2243: -- IF PG_DEBUG < 10 THEN
2244: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2245: iex_debug_pub.logmessage ('**** END WAIT_SIGNAL ************');
2246: END IF;

Line 2274: if funcmode <> wf_engine.eng_run then

2270: BEGIN
2271: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2272: iex_debug_pub.logmessage ('**** START wait_complete_signal ************');
2273: END IF;
2274: if funcmode <> wf_engine.eng_run then
2275: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2276: iex_debug_pub.logmessage('SECOND TIME FUNCMODE' ||funcmode);
2277: END IF;
2278: result := wf_engine.eng_null;

Line 2278: result := wf_engine.eng_null;

2274: if funcmode <> wf_engine.eng_run then
2275: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2276: iex_debug_pub.logmessage('SECOND TIME FUNCMODE' ||funcmode);
2277: END IF;
2278: result := wf_engine.eng_null;
2279: return;
2280: end if;
2281:
2282:

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

2283:
2284: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2285: iex_debug_pub.logmessage('FUNCMODE' ||funcmode);
2286: END IF;
2287: l_value :=wf_engine.GetActivityLabel(actid);
2288: wf_engine.SetItemAttrText(itemtype => itemtype,
2289: itemkey => itemkey,
2290: aname => 'ACTIVITY_NAME',
2291: avalue => l_value);

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

2284: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2285: iex_debug_pub.logmessage('FUNCMODE' ||funcmode);
2286: END IF;
2287: l_value :=wf_engine.GetActivityLabel(actid);
2288: wf_engine.SetItemAttrText(itemtype => itemtype,
2289: itemkey => itemkey,
2290: aname => 'ACTIVITY_NAME',
2291: avalue => l_value);
2292: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

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

2293: iex_debug_pub.logMessage('ACTIVITYNAME' ||l_value);
2294: END IF;
2295:
2296:
2297: result := wf_engine.eng_notified||':'||wf_engine.eng_null||
2298: ':'||wf_engine.eng_null;
2299: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2300: iex_debug_pub.logmessage ('**** END wait_complete_signal ************');
2301: END IF;

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

2294: END IF;
2295:
2296:
2297: result := wf_engine.eng_notified||':'||wf_engine.eng_null||
2298: ':'||wf_engine.eng_null;
2299: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2300: iex_debug_pub.logmessage ('**** END wait_complete_signal ************');
2301: END IF;
2302: exception

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

2300: iex_debug_pub.logmessage ('**** END wait_complete_signal ************');
2301: END IF;
2302: exception
2303: when others then
2304: result := wf_engine.eng_completed ||':'||wf_no;
2305: wf_core.context('IEX_STRATEGY_WF','wait_complete_signal',itemtype,
2306: itemkey,to_char(actid),funcmode);
2307: raise;
2308:

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

2367: iex_debug_pub.logmessage ('wait_signal: ' || 'status' ||status ||'workitemid ' ||work_item_id || '**'||
2368: 'signal source '||signal_source||'strategy_id' ||strategy_id);
2369: END IF;
2370:
2371: wf_engine.itemstatus(itemtype => process,
2372: itemkey => strategy_id,
2373: status =>l_status,
2374: result =>l_result);
2375:

Line 2384: IF l_status =wf_engine.eng_suspended THEN

2380:
2381: --- resume process only if it is suspend
2382: -- check for other than fulfilment and custom work flow
2383:
2384: IF l_status =wf_engine.eng_suspended THEN
2385:
2386: --check if the signal_source is fulfillment or optional
2387: if signal_source in ('FULFILLMENT','CUSTOM') THEN
2388: -- IF PG_DEBUG < 10 THEN

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

2460: abort_processes(strategy_id);
2461: end if;--work item id is null
2462: end if; -- signal source check
2463:
2464: wf_engine.SetItemAttrText(itemtype => process,
2465: itemkey => strategy_id,
2466: aname => 'STRATEGY_STATUS',
2467: avalue => status);
2468:

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

2465: itemkey => strategy_id,
2466: aname => 'STRATEGY_STATUS',
2467: avalue => status);
2468:
2469: wf_engine.SetItemAttrNumber(itemtype => process,
2470: itemkey => strategy_id,
2471: aname => 'WORK_ITEMID',
2472: avalue => work_item_id);
2473:

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

2470: itemkey => strategy_id,
2471: aname => 'WORK_ITEMID',
2472: avalue => work_item_id);
2473:
2474: wf_engine.ResumeProcess(itemtype => process,
2475: itemkey => strategy_id);
2476:
2477: --COMMIT; -- the work flow was not going to end from the close strategy
2478:

Line 2479: ELSIF l_status =wf_engine.eng_active THEN

2475: itemkey => strategy_id);
2476:
2477: --COMMIT; -- the work flow was not going to end from the close strategy
2478:
2479: ELSIF l_status =wf_engine.eng_active THEN
2480:
2481: --complete the current activity
2482: --this will be either complete the ESCALATE_CHECK
2483: --OR OPTIONAL_CHECK activity

Line 2527: l_activity_label := wf_engine.GetItemAttrText(

2523: --activity without the label being set.
2524:
2525: end if;--work item id is null
2526:
2527: l_activity_label := wf_engine.GetItemAttrText(
2528: itemtype => process,
2529: itemkey => strategy_id,
2530: aname => 'ACTIVITY_NAME');
2531: -- IF PG_DEBUG < 10 THEN

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

2536: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2537: iex_debug_pub.logmessage('wait_signal: ' || process ||strategy_id||l_activity_label);
2538: END IF;
2539:
2540: wf_engine.SetItemAttrText(itemtype => process,
2541: itemkey => strategy_id,
2542: aname => 'STRATEGY_STATUS',
2543: avalue => status);
2544:

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

2541: itemkey => strategy_id,
2542: aname => 'STRATEGY_STATUS',
2543: avalue => status);
2544:
2545: wf_engine.SetItemAttrNumber(itemtype => process,
2546: itemkey => strategy_id,
2547: aname => 'WORK_ITEMID',
2548: avalue => work_item_id);
2549:

Line 2555: wf_engine.CompleteActivity(

2551: -- change strategy from the UI, then send signal was failing
2552: --check value of activity label before resuming process
2553: If l_activity_label IS NOT NULL THEN
2554: abort_processes(strategy_id); -- added on 05/10/02
2555: wf_engine.CompleteActivity(
2556: itemtype => process,
2557: itemkey => strategy_id,
2558: activity =>l_activity_label,
2559: result =>'Yes');

Line 2579: ELSIF l_status =wf_engine.eng_error THEN

2575: end if;
2576:
2577: end if; --signal_source
2578:
2579: ELSIF l_status =wf_engine.eng_error THEN
2580: CLOSE_AND_ABORT_STRATEGY_WF(strategy_id,status);
2581: NULL;
2582: --COMMIT; -- the work flow was not going to end from the close strategy
2583: END IF; -- item status

Line 2639: result := wf_engine.eng_null;

2635: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2636: iex_debug_pub.logmessage ('**** START CUSTOM_CHECK ************');
2637: END IF;
2638: if funcmode <> 'RUN' then
2639: result := wf_engine.eng_null;
2640: return;
2641: end if;
2642:
2643: /* Begin 06-dec-2005 schekuri bug 4506922 - All work items are created as PRE-WAIT */

Line 2644: l_work_item_id := wf_engine.GetItemAttrNumber(

2640: return;
2641: end if;
2642:
2643: /* Begin 06-dec-2005 schekuri bug 4506922 - All work items are created as PRE-WAIT */
2644: l_work_item_id := wf_engine.GetItemAttrNumber(
2645: itemtype => itemtype,
2646: itemkey => itemkey,
2647: aname => 'WORK_ITEMID');
2648:

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

2663: END IF;
2664:
2665: /* End 06-dec-2005 schekuri bug 4506922 - All work items are created as PRE-WAIT */
2666:
2667: /* l_value :=wf_engine.GetActivityLabel(actid);
2668: wf_engine.SetItemAttrText(itemtype => itemtype,
2669: itemkey => itemkey,
2670: aname => 'ACTIVITY_NAME',
2671: avalue => l_value);

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

2664:
2665: /* End 06-dec-2005 schekuri bug 4506922 - All work items are created as PRE-WAIT */
2666:
2667: /* l_value :=wf_engine.GetActivityLabel(actid);
2668: wf_engine.SetItemAttrText(itemtype => itemtype,
2669: itemkey => itemkey,
2670: aname => 'ACTIVITY_NAME',
2671: avalue => l_value);
2672:

Line 2678: l_work_item_temp_id := wf_engine.GetItemAttrNumber(

2674: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2675: iex_debug_pub.logMessage('CUSTOM_CHECK: ' || 'ACTIVITYNAME' ||l_value);
2676: END IF;
2677: */
2678: l_work_item_temp_id := wf_engine.GetItemAttrNumber(
2679: itemtype => itemtype,
2680: itemkey => itemkey,
2681: aname => 'WORKITEM_TEMPLATE_ID');
2682: iex_debug_pub.logmessage('l_work_item_temp_id '|| l_work_item_temp_id);

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

2725: -- IF PG_DEBUG < 10 THEN
2726: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2727: iex_debug_pub.logmessage ('CUSTOM_CHECK: ' || 'End of custom work flow ');
2728: END IF;
2729: result := wf_engine.eng_completed ||':'||l_result;
2730: return;
2731: -- result := wf_engine.eng_completed ||':'||l_result;
2732:
2733: -- don't check for result, what ever is the outcome

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

2727: iex_debug_pub.logmessage ('CUSTOM_CHECK: ' || 'End of custom work flow ');
2728: END IF;
2729: result := wf_engine.eng_completed ||':'||l_result;
2730: return;
2731: -- result := wf_engine.eng_completed ||':'||l_result;
2732:
2733: -- don't check for result, what ever is the outcome
2734: -- go and wait, the UI will relaunch the custom workflow
2735:

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

2733: -- don't check for result, what ever is the outcome
2734: -- go and wait, the UI will relaunch the custom workflow
2735:
2736: /* if l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2737: result := wf_engine.eng_completed ||':'||wf_yes;
2738: else
2739: result := wf_engine.eng_completed ||':'||wf_no;
2740: end if;
2741:

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

2735:
2736: /* if l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2737: result := wf_engine.eng_completed ||':'||wf_yes;
2738: else
2739: result := wf_engine.eng_completed ||':'||wf_no;
2740: end if;
2741:
2742: */
2743:

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

2747: iex_debug_pub.logmessage ('**** END CUSTOM_CHECK ************');
2748: END IF;
2749: exception
2750: when others then
2751: result := wf_engine.eng_completed ||':'||wf_no;
2752: wf_core.context('IEX_STRATEGY_WF','CUSTOM_CHECK',itemtype,
2753: itemkey,to_char(actid),funcmode);
2754: raise;
2755:

Line 2796: result := wf_engine.eng_null;

2792: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2793: iex_debug_pub.logmessage ('**** START FULFIL_CHECK ************');
2794: END IF;
2795: if funcmode <> 'RUN' then
2796: result := wf_engine.eng_null;
2797: return;
2798: end if;
2799:
2800: /* l_value :=wf_engine.GetActivityLabel(actid);

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

2796: result := wf_engine.eng_null;
2797: return;
2798: end if;
2799:
2800: /* l_value :=wf_engine.GetActivityLabel(actid);
2801: wf_engine.SetItemAttrText(itemtype => itemtype,
2802: itemkey => itemkey,
2803: aname => 'ACTIVITY_NAME',
2804: avalue => l_value);

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

2797: return;
2798: end if;
2799:
2800: /* l_value :=wf_engine.GetActivityLabel(actid);
2801: wf_engine.SetItemAttrText(itemtype => itemtype,
2802: itemkey => itemkey,
2803: aname => 'ACTIVITY_NAME',
2804: avalue => l_value);
2805: -- IF PG_DEBUG < 10 THEN

Line 2811: l_work_item_temp_id := wf_engine.GetItemAttrNumber(

2807: iex_debug_pub.logMessage('FULFIL_CHECK: ' || 'ACTIVITYNAME' ||l_value);
2808: END IF;
2809: */
2810:
2811: l_work_item_temp_id := wf_engine.GetItemAttrNumber(
2812: itemtype => itemtype,
2813: itemkey => itemkey,
2814: aname => 'WORKITEM_TEMPLATE_ID');
2815:

Line 2818: l_work_item_id := wf_engine.GetItemAttrNumber(

2814: aname => 'WORKITEM_TEMPLATE_ID');
2815:
2816: l_curr_dmethod := iex_send_xml_pvt.getCurrDeliveryMethod();
2817:
2818: l_work_item_id := wf_engine.GetItemAttrNumber(
2819: itemtype => itemtype,
2820: itemkey => itemkey,
2821: aname => 'WORK_ITEMID');
2822:

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

2868: x_return_status => l_return_status);
2869:
2870: End if;
2871:
2872: result := wf_engine.eng_completed ||':'||l_result;
2873:
2874: -- don't check for result, what ever is the outcome
2875: -- go and wait, the UI will relaunch the fulilment workflow
2876:

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

2874: -- don't check for result, what ever is the outcome
2875: -- go and wait, the UI will relaunch the fulilment workflow
2876:
2877: /* if l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2878: result := wf_engine.eng_completed ||':'||wf_yes;
2879: else
2880: result := wf_engine.eng_completed ||':'||wf_no;
2881: end if;
2882:

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

2876:
2877: /* if l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2878: result := wf_engine.eng_completed ||':'||wf_yes;
2879: else
2880: result := wf_engine.eng_completed ||':'||wf_no;
2881: end if;
2882:
2883: */
2884:

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

2888: iex_debug_pub.logmessage ('**** END FULFIL_CHECK ************');
2889: END IF;
2890: exception
2891: when others then
2892: result := wf_engine.eng_completed ||':'||wf_no;
2893: wf_core.context('IEX_STRATEGY_WF','FULFIL_CHECK',itemtype,
2894: itemkey,to_char(actid),funcmode);
2895: raise;
2896:

Line 2941: result := wf_engine.eng_null;

2937: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2938: iex_debug_pub.logmessage ('**** START cal_post_wait ************');
2939: END IF;
2940: if funcmode <> 'RUN' then
2941: result := wf_engine.eng_null;
2942: return;
2943: end if;
2944:
2945: l_strategy_status := wf_engine.GetItemAttrText(itemtype => itemtype,

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

2941: result := wf_engine.eng_null;
2942: return;
2943: end if;
2944:
2945: l_strategy_status := wf_engine.GetItemAttrText(itemtype => itemtype,
2946: itemkey => itemkey,
2947: aname => 'STRATEGY_STATUS');
2948:
2949: l_work_item_id := wf_engine.GetItemAttrNumber(

Line 2949: l_work_item_id := wf_engine.GetItemAttrNumber(

2945: l_strategy_status := wf_engine.GetItemAttrText(itemtype => itemtype,
2946: itemkey => itemkey,
2947: aname => 'STRATEGY_STATUS');
2948:
2949: l_work_item_id := wf_engine.GetItemAttrNumber(
2950: itemtype => itemtype,
2951: itemkey => itemkey,
2952: aname => 'WORK_ITEMID');
2953:

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

2958: IEX_STRY_UTL_PUB.refresh_uwq_str_summ(l_work_item_id);
2959: end if;
2960: --End bug#5874874 gnramasa 25-Apr-2007
2961: l_return := wf_no;
2962: result := wf_engine.eng_completed ||':'||l_return;
2963: return;
2964: end if;
2965:
2966: l_work_item_temp_id := wf_engine.GetItemAttrNumber(

Line 2966: l_work_item_temp_id := wf_engine.GetItemAttrNumber(

2962: result := wf_engine.eng_completed ||':'||l_return;
2963: return;
2964: end if;
2965:
2966: l_work_item_temp_id := wf_engine.GetItemAttrNumber(
2967: itemtype => itemtype,
2968: itemkey => itemkey,
2969: aname => 'WORKITEM_TEMPLATE_ID');
2970:

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

3057: end if;
3058:
3059: --End if; --Removed if for bug#5502077 schekuri 30-Apr-2007
3060:
3061: wf_engine.SetItemAttrDate(itemtype => itemtype,
3062: itemkey => itemkey,
3063: aname => 'EXECUTION_TIME',
3064: avalue => l_execution_time);
3065:

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

3073: IEX_STRY_UTL_PUB.refresh_uwq_str_summ(l_work_item_id);
3074: end if;
3075: --End bug#5874874 gnramasa 25-Apr-2007
3076:
3077: result := wf_engine.eng_completed ||':'||l_return;
3078:
3079: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3080: iex_debug_pub.logmessage ('**** END cal_post_wait ************');
3081: END IF;

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

3080: iex_debug_pub.logmessage ('**** END cal_post_wait ************');
3081: END IF;
3082: exception
3083: when others then
3084: result := wf_engine.eng_completed ||':'||wf_no;
3085: wf_core.context('IEX_STRATEGY_WF','cal_post_wait',itemtype,
3086: itemkey,to_char(actid),funcmode);
3087: raise;
3088:

Line 3123: result := wf_engine.eng_null;

3119: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3120: iex_debug_pub.logmessage ('**** START cal_pre_wait ************');
3121: END IF;
3122: if funcmode <> 'RUN' then
3123: result := wf_engine.eng_null;
3124: return;
3125: end if;
3126:
3127: l_strategy_status := wf_engine.GetItemAttrText(itemtype => itemtype,

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

3123: result := wf_engine.eng_null;
3124: return;
3125: end if;
3126:
3127: l_strategy_status := wf_engine.GetItemAttrText(itemtype => itemtype,
3128: itemkey => itemkey,
3129: aname => 'STRATEGY_STATUS');
3130: if l_strategy_status = 'CANCELLED' then
3131: l_return := wf_no;

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

3128: itemkey => itemkey,
3129: aname => 'STRATEGY_STATUS');
3130: if l_strategy_status = 'CANCELLED' then
3131: l_return := wf_no;
3132: result := wf_engine.eng_completed ||':'||l_return;
3133: return;
3134: end if;
3135:
3136: l_work_item_temp_id := wf_engine.GetItemAttrNumber(

Line 3136: l_work_item_temp_id := wf_engine.GetItemAttrNumber(

3132: result := wf_engine.eng_completed ||':'||l_return;
3133: return;
3134: end if;
3135:
3136: l_work_item_temp_id := wf_engine.GetItemAttrNumber(
3137: itemtype => itemtype,
3138: itemkey => itemkey,
3139: aname => 'WORKITEM_TEMPLATE_ID');
3140:

Line 3141: l_work_item_id := wf_engine.GetItemAttrNumber(

3137: itemtype => itemtype,
3138: itemkey => itemkey,
3139: aname => 'WORKITEM_TEMPLATE_ID');
3140:
3141: l_work_item_id := wf_engine.GetItemAttrNumber(
3142: itemtype => itemtype,
3143: itemkey => itemkey,
3144: aname => 'WORK_ITEMID');
3145:

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

3193: l_return := wf_yes;
3194: end if;
3195:
3196:
3197: wf_engine.SetItemAttrDate(itemtype => itemtype,
3198: itemkey => itemkey,
3199: aname => 'PRE_WAIT_TIME',
3200: avalue => l_schedule);
3201:

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

3202: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3203: iex_debug_pub.logMessage('cal_pre_wait result = ' ||l_return);
3204: END IF;
3205:
3206: result := wf_engine.eng_completed ||':'||l_return;
3207:
3208: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3209: iex_debug_pub.logmessage ('**** END cal_pre_wait ************');
3210: END IF;

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

3209: iex_debug_pub.logmessage ('**** END cal_pre_wait ************');
3210: END IF;
3211: exception
3212: when others then
3213: result := wf_engine.eng_completed ||':'||wf_no;
3214: wf_core.context('IEX_STRATEGY_WF','cal_pre_wait',itemtype,
3215: itemkey,to_char(actid),funcmode);
3216: raise;
3217:

Line 3246: result := wf_engine.eng_null;

3242: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3243: iex_debug_pub.logmessage ('**** START wi_failed_first_time ************');
3244: END IF;
3245: if funcmode <> 'RUN' then
3246: result := wf_engine.eng_null;
3247: return;
3248: end if;
3249:
3250: l_strategy_status := wf_engine.GetItemAttrText(itemtype => itemtype,

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

3246: result := wf_engine.eng_null;
3247: return;
3248: end if;
3249:
3250: l_strategy_status := wf_engine.GetItemAttrText(itemtype => itemtype,
3251: itemkey => itemkey,
3252: aname => 'STRATEGY_STATUS');
3253: if l_strategy_status = 'CANCELLED' then
3254: l_return := wf_no;

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

3251: itemkey => itemkey,
3252: aname => 'STRATEGY_STATUS');
3253: if l_strategy_status = 'CANCELLED' then
3254: l_return := wf_no;
3255: result := wf_engine.eng_completed ||':'||l_return;
3256: return;
3257: end if;
3258:
3259: l_create_wi_error_count := wf_engine.GetItemAttrNumber(

Line 3259: l_create_wi_error_count := wf_engine.GetItemAttrNumber(

3255: result := wf_engine.eng_completed ||':'||l_return;
3256: return;
3257: end if;
3258:
3259: l_create_wi_error_count := wf_engine.GetItemAttrNumber(
3260: itemtype => itemtype,
3261: itemkey => itemkey,
3262: aname => 'CREATE_WI_ERROR_COUNT');
3263:

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

3286:
3287: l_create_wi_error_count := 1;
3288: l_return := wf_yes;
3289:
3290: wf_engine.SetItemAttrDate(itemtype => itemtype,
3291: itemkey => itemkey,
3292: aname => 'RESTART_CREATE_WI_TIME',
3293: avalue => l_restart_create_wi_time);
3294: end if;

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

3292: aname => 'RESTART_CREATE_WI_TIME',
3293: avalue => l_restart_create_wi_time);
3294: end if;
3295:
3296: wf_engine.SetItemAttrNumber(itemtype =>itemtype,
3297: itemkey => itemkey,
3298: aname => 'CREATE_WI_ERROR_COUNT',
3299: avalue => l_create_wi_error_count);
3300:

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

3301: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3302: iex_debug_pub.logMessage('wi_failed_first_time result = ' ||l_return);
3303: END IF;
3304:
3305: result := wf_engine.eng_completed ||':'||l_return;
3306:
3307: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3308: iex_debug_pub.logmessage ('**** END wi_failed_first_time ************');
3309: END IF;

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

3308: iex_debug_pub.logmessage ('**** END wi_failed_first_time ************');
3309: END IF;
3310: exception
3311: when others then
3312: result := wf_engine.eng_completed ||':'||wf_no;
3313: wf_core.context('IEX_STRATEGY_WF','wi_failed_first_time',itemtype,
3314: itemkey,to_char(actid),funcmode);
3315: raise;
3316:

Line 3348: result := wf_engine.eng_null;

3344: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3345: iex_debug_pub.logmessage ('**** START OPTIONAL_CHECK ************');
3346: END IF;
3347: if funcmode <> 'RUN' then
3348: result := wf_engine.eng_null;
3349: return;
3350: end if;
3351:
3352: -- IF PG_DEBUG < 10 THEN

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

3353: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3354: iex_debug_pub.logmessage('OPTIONAL_CHECK: ' || '*************FUNCMODE' ||funcmode||'**********************');
3355: END IF;
3356:
3357: l_value :=wf_engine.GetActivityLabel(actid);
3358: wf_engine.SetItemAttrText(itemtype => itemtype,
3359: itemkey => itemkey,
3360: aname => 'ACTIVITY_NAME',
3361: avalue => l_value);

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

3354: iex_debug_pub.logmessage('OPTIONAL_CHECK: ' || '*************FUNCMODE' ||funcmode||'**********************');
3355: END IF;
3356:
3357: l_value :=wf_engine.GetActivityLabel(actid);
3358: wf_engine.SetItemAttrText(itemtype => itemtype,
3359: itemkey => itemkey,
3360: aname => 'ACTIVITY_NAME',
3361: avalue => l_value);
3362: -- IF PG_DEBUG < 10 THEN

Line 3367: l_work_item_temp_id := wf_engine.GetItemAttrNumber(

3363: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3364: iex_debug_pub.logMessage('OPTIONAL_CHECK: ' || 'ACTIVITYNAME' ||l_value);
3365: END IF;
3366:
3367: l_work_item_temp_id := wf_engine.GetItemAttrNumber(
3368: itemtype => itemtype,
3369: itemkey => itemkey,
3370: aname => 'WORKITEM_TEMPLATE_ID');
3371:

Line 3376: l_work_item_id := wf_engine.GetItemAttrNumber(

3372: select nvl(optional_yn,'N') INTO l_result
3373: from iex_stry_temp_work_items_vl
3374: where work_item_temp_id =l_work_item_temp_id;
3375:
3376: l_work_item_id := wf_engine.GetItemAttrNumber(
3377: itemtype => itemtype,
3378: itemkey => itemkey,
3379: aname => 'WORK_ITEMID');
3380:

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

3386: IF l_optional IS NOT NULL THEN
3387: l_result := l_optional;
3388: END IF;
3389: -- end bug 10133319
3390: result := wf_engine.eng_completed ||':'||l_result;
3391: -- IF PG_DEBUG < 10 THEN
3392: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3393: iex_debug_pub.logmessage ('**** END OPTIONAL_CHECK ************');
3394: END IF;

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

3393: iex_debug_pub.logmessage ('**** END OPTIONAL_CHECK ************');
3394: END IF;
3395: exception
3396: when others then
3397: result := wf_engine.eng_completed ||':'||wf_no;
3398: wf_core.context('IEX_STRATEGY_WF','OPTIONAL_CHECK',itemtype,
3399: itemkey,to_char(actid),funcmode);
3400: raise;
3401:

Line 3431: result := wf_engine.eng_null;

3427: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3428: iex_debug_pub.logmessage ('**** START ESCALATE_CHECK ************');
3429: END IF;
3430: if funcmode <> 'RUN' then
3431: result := wf_engine.eng_null;
3432: return;
3433: end if;
3434:
3435: l_value :=wf_engine.GetActivityLabel(actid);

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

3431: result := wf_engine.eng_null;
3432: return;
3433: end if;
3434:
3435: l_value :=wf_engine.GetActivityLabel(actid);
3436: wf_engine.SetItemAttrText(itemtype => itemtype,
3437: itemkey => itemkey,
3438: aname => 'ACTIVITY_NAME',
3439: avalue => l_value);

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

3432: return;
3433: end if;
3434:
3435: l_value :=wf_engine.GetActivityLabel(actid);
3436: wf_engine.SetItemAttrText(itemtype => itemtype,
3437: itemkey => itemkey,
3438: aname => 'ACTIVITY_NAME',
3439: avalue => l_value);
3440:

Line 3446: l_work_item_temp_id := wf_engine.GetItemAttrNumber(

3442: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3443: iex_debug_pub.logMessage('ESCALATE_CHECK: ' || 'ACTIVITYNAME' ||l_value);
3444: END IF;
3445:
3446: l_work_item_temp_id := wf_engine.GetItemAttrNumber(
3447: itemtype => itemtype,
3448: itemkey => itemkey,
3449: aname => 'WORKITEM_TEMPLATE_ID');
3450:

Line 3455: l_work_item_id := wf_engine.GetItemAttrNumber(

3451: select nvl(escalate_yn,'N') INTO l_result
3452: from iex_stry_temp_work_items_vl
3453: where work_item_temp_id =l_work_item_temp_id;
3454:
3455: l_work_item_id := wf_engine.GetItemAttrNumber(
3456: itemtype => itemtype,
3457: itemkey => itemkey,
3458: aname => 'WORK_ITEMID');
3459:

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

3465: IF l_escalate IS NOT NULL THEN
3466: l_result := l_escalate;
3467: END IF;
3468: -- end bug 10133319
3469: result := wf_engine.eng_completed ||':'||l_result;
3470: -- IF PG_DEBUG < 10 THEN
3471: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3472: iex_debug_pub.logmessage ('**** END ESCALATE_CHECK ************');
3473: END IF;

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

3472: iex_debug_pub.logmessage ('**** END ESCALATE_CHECK ************');
3473: END IF;
3474: exception
3475: when others then
3476: result := wf_engine.eng_completed ||':'||wf_no;
3477: wf_core.context('IEX_STRATEGY_WF','ESCALATE_CHECK',itemtype,
3478: itemkey,to_char(actid),funcmode);
3479: raise;
3480:

Line 3510: result := wf_engine.eng_null;

3506: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3507: iex_debug_pub.logmessage ('**** START NOTIFY_CHECK ************');
3508: END IF;
3509: if funcmode <> 'RUN' then
3510: result := wf_engine.eng_null;
3511: return;
3512: end if;
3513:
3514: /* l_value :=wf_engine.GetActivityLabel(actid);

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

3510: result := wf_engine.eng_null;
3511: return;
3512: end if;
3513:
3514: /* l_value :=wf_engine.GetActivityLabel(actid);
3515: wf_engine.SetItemAttrText(itemtype => itemtype,
3516: itemkey => itemkey,
3517: aname => 'ACTIVITY_NAME',
3518: avalue => l_value);

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

3511: return;
3512: end if;
3513:
3514: /* l_value :=wf_engine.GetActivityLabel(actid);
3515: wf_engine.SetItemAttrText(itemtype => itemtype,
3516: itemkey => itemkey,
3517: aname => 'ACTIVITY_NAME',
3518: avalue => l_value);
3519: -- IF PG_DEBUG < 10 THEN

Line 3524: l_work_item_temp_id := wf_engine.GetItemAttrNumber(

3520: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3521: iex_debug_pub.logMessage('NOTIFY_CHECK: ' || 'ACTIVITYNAME' ||l_value);
3522: END IF;
3523: */
3524: l_work_item_temp_id := wf_engine.GetItemAttrNumber(
3525: itemtype => itemtype,
3526: itemkey => itemkey,
3527: aname => 'WORKITEM_TEMPLATE_ID');
3528:

Line 3533: l_work_item_id := wf_engine.GetItemAttrNumber(

3529: select nvl(notify_yn,'N') INTO l_result
3530: from iex_stry_temp_work_items_vl
3531: where work_item_temp_id =l_work_item_temp_id;
3532:
3533: l_work_item_id := wf_engine.GetItemAttrNumber(
3534: itemtype => itemtype,
3535: itemkey => itemkey,
3536: aname => 'WORK_ITEMID');
3537:

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

3543: IF l_notify IS NOT NULL THEN
3544: l_result := l_notify;
3545: END IF;
3546: -- end bug 10133319
3547: result := wf_engine.eng_completed ||':'||l_result;
3548: -- IF PG_DEBUG < 10 THEN
3549: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3550: iex_debug_pub.logmessage ('**** END NOTIFY_CHECK ************');
3551: END IF;

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

3550: iex_debug_pub.logmessage ('**** END NOTIFY_CHECK ************');
3551: END IF;
3552: exception
3553: when others then
3554: result := wf_engine.eng_completed ||':'||wf_no;
3555: wf_core.context('IEX_STRATEGY_WF','NOTIFY_CHECK',itemtype,
3556: itemkey,to_char(actid),funcmode);
3557: raise;
3558:

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

3574: END IF;
3575: select sysdate+(23/24)
3576: into l_execution_time
3577: from dual;
3578: wf_engine.SetItemAttrDate(itemtype => itemtype,
3579: itemkey => itemkey,
3580: aname => 'ON_HOLD_WAIT_TIME',
3581: avalue => l_execution_time);
3582:

Line 3618: result := wf_engine.eng_null;

3614: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3615: iex_debug_pub.logmessage ('**** START ONHOLD_CHECK ************');
3616: END IF;
3617: if funcmode <> 'RUN' then
3618: result := wf_engine.eng_null;
3619: return;
3620: end if;
3621:
3622: /*l_value :=wf_engine.GetActivityLabel(actid);

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

3618: result := wf_engine.eng_null;
3619: return;
3620: end if;
3621:
3622: /*l_value :=wf_engine.GetActivityLabel(actid);
3623: wf_engine.SetItemAttrText(itemtype => itemtype,
3624: itemkey => itemkey,
3625: aname => 'ACTIVITY_NAME',
3626: avalue => l_value);

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

3619: return;
3620: end if;
3621:
3622: /*l_value :=wf_engine.GetActivityLabel(actid);
3623: wf_engine.SetItemAttrText(itemtype => itemtype,
3624: itemkey => itemkey,
3625: aname => 'ACTIVITY_NAME',
3626: avalue => l_value);
3627: -- IF PG_DEBUG < 10 THEN

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

3637: --But status of the strategy in table IEX_STRATEGIES is still 'ONHOLD'.
3638: --If workflow is waiting at WAIT_ON_HOLD_SIGNAL node, it will be completed and it goes to ONHOLD_CHECK node.
3639: --Since the status of the strategy in table IEX_STRATEGIES is still 'ONHOLD', it again goes to WAIT_ON_HOLD_SIGNAL node
3640: --and waits for 23 hrs. To avoid this added the following code.
3641: l_value :=wf_engine.GetActivityLabel(actid);
3642: if instr(l_value,'STRATEGY_WORKFLOW')>0 then
3643: l_strategy_status := wf_engine.GetItemAttrText(
3644: itemtype => itemtype,
3645: itemkey => itemkey,

Line 3643: l_strategy_status := wf_engine.GetItemAttrText(

3639: --Since the status of the strategy in table IEX_STRATEGIES is still 'ONHOLD', it again goes to WAIT_ON_HOLD_SIGNAL node
3640: --and waits for 23 hrs. To avoid this added the following code.
3641: l_value :=wf_engine.GetActivityLabel(actid);
3642: if instr(l_value,'STRATEGY_WORKFLOW')>0 then
3643: l_strategy_status := wf_engine.GetItemAttrText(
3644: itemtype => itemtype,
3645: itemkey => itemkey,
3646: aname => 'STRATEGY_STATUS');
3647:

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

3645: itemkey => itemkey,
3646: aname => 'STRATEGY_STATUS');
3647:
3648: if l_strategy_status in ('CLOSED','CANCELLED') then
3649: result := wf_engine.eng_completed ||':'||'N';
3650: return;
3651: end if;
3652: end if;
3653: --end bug#4506922 schekuri 03-Dec-2005

Line 3655: l_strategy_id := wf_engine.GetItemAttrNumber(

3651: end if;
3652: end if;
3653: --end bug#4506922 schekuri 03-Dec-2005
3654:
3655: l_strategy_id := wf_engine.GetItemAttrNumber(
3656: itemtype => itemtype,
3657: itemkey => itemkey,
3658: aname => 'STRATEGY_ID');
3659:

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

3666: --added the following code to avoid the workflow to get suspended at calc post wait node
3667: --after the timeout of the optional work item when the status of strategy is onhold.
3668: --Onhold check after calc post wait node stops the workflow when the strategy is onhold.
3669: --This is needed for workflows which are already started by the time this patch applied.
3670: --l_value :=wf_engine.GetActivityLabel(actid);
3671: if instr(l_value,'STRATEGY_SUBPROCESS')>0 and l_result = 'Y' then
3672: l_work_item_id := wf_engine.GetItemAttrText(
3673: itemtype => itemtype,
3674: itemkey => itemkey,

Line 3672: l_work_item_id := wf_engine.GetItemAttrText(

3668: --Onhold check after calc post wait node stops the workflow when the strategy is onhold.
3669: --This is needed for workflows which are already started by the time this patch applied.
3670: --l_value :=wf_engine.GetActivityLabel(actid);
3671: if instr(l_value,'STRATEGY_SUBPROCESS')>0 and l_result = 'Y' then
3672: l_work_item_id := wf_engine.GetItemAttrText(
3673: itemtype => itemtype,
3674: itemkey => itemkey,
3675: aname => 'WORK_ITEMID');
3676: if l_work_item_id is not null then

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

3691: end if;
3692:
3693: --end bug#4506922 schekuri 03-Dec-2005
3694:
3695: result := wf_engine.eng_completed ||':'||l_result;
3696:
3697: --Begin - schekuri - 03-Dec-2005 - bug#4506922
3698: --if strategy is ONHOLD update the attribute 'ON_HOLD_WAIT_TIME' to sysdate + 23 hrs.
3699: if l_result='Y' then

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

3708: END IF;
3709:
3710: exception
3711: when others then
3712: result := wf_engine.eng_completed ||':'||wf_no;
3713: wf_core.context('IEX_STRATEGY_WF','ONHOLD_CHECK',itemtype,
3714: itemkey,to_char(actid),funcmode);
3715: raise;
3716:

Line 3741: result := wf_engine.eng_null;

3737: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3738: iex_debug_pub.logmessage ('**** START UPDATE_WORK_ITEM ************');
3739: END IF;
3740: if funcmode <> 'RUN' then
3741: result := wf_engine.eng_null;
3742: return;
3743: end if;
3744:
3745: l_work_item_id := wf_engine.GetItemAttrText(

Line 3745: l_work_item_id := wf_engine.GetItemAttrText(

3741: result := wf_engine.eng_null;
3742: return;
3743: end if;
3744:
3745: l_work_item_id := wf_engine.GetItemAttrText(
3746: itemtype => itemtype,
3747: itemkey => itemkey,
3748: aname => 'WORK_ITEMID');
3749: -- IF PG_DEBUG < 10 THEN

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

3758: x_return_status => l_return_status,
3759: p_work_item_id => l_work_item_id,
3760: p_status => 'TIMEOUT');
3761: if l_return_status =FND_API.G_RET_STS_SUCCESS THEN
3762: result := wf_engine.eng_completed ||':'||wf_yes;
3763: else
3764: RAISE EXC;
3765: END IF;
3766: -- IF PG_DEBUG < 10 THEN

Line 3810: if funcmode <> wf_engine.eng_run then

3806: -- IF PG_DEBUG < 10 THEN
3807: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3808: iex_debug_pub.logmessage ('**** START WAIT_OPTIONAL ************');
3809: END IF;
3810: if funcmode <> wf_engine.eng_run then
3811: -- IF PG_DEBUG < 10 THEN
3812: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3813: iex_debug_pub.logmessage('WAIT_OPTIONAL: ' || 'SECOND TIME FUNCMODE' ||funcmode);
3814: END IF;

Line 3815: result := wf_engine.eng_null;

3811: -- IF PG_DEBUG < 10 THEN
3812: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3813: iex_debug_pub.logmessage('WAIT_OPTIONAL: ' || 'SECOND TIME FUNCMODE' ||funcmode);
3814: END IF;
3815: result := wf_engine.eng_null;
3816: return;
3817: end if;
3818:
3819:

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

3821: -- IF PG_DEBUG < 10 THEN
3822: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3823: iex_debug_pub.logmessage('WAIT_OPTIONAL: ' || 'FUNCMODE' ||funcmode);
3824: END IF;
3825: l_value :=wf_engine.GetActivityLabel(actid);
3826: wf_engine.SetItemAttrText(itemtype => itemtype,
3827: itemkey => itemkey,
3828: aname => 'ACTIVITY_NAME',
3829: avalue => l_value);

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

3822: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3823: iex_debug_pub.logmessage('WAIT_OPTIONAL: ' || 'FUNCMODE' ||funcmode);
3824: END IF;
3825: l_value :=wf_engine.GetActivityLabel(actid);
3826: wf_engine.SetItemAttrText(itemtype => itemtype,
3827: itemkey => itemkey,
3828: aname => 'ACTIVITY_NAME',
3829: avalue => l_value);
3830: -- IF PG_DEBUG < 10 THEN

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

3832: iex_debug_pub.logMessage('WAIT_OPTIONAL: ' || 'ACTIVITYNAME' ||l_value);
3833: END IF;
3834:
3835:
3836: result := wf_engine.eng_notified||':'||wf_engine.eng_null||
3837: ':'||wf_engine.eng_null;
3838: -- IF PG_DEBUG < 10 THEN
3839: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3840: iex_debug_pub.logmessage ('**** END WAIT_OPTIONAL ************');

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

3833: END IF;
3834:
3835:
3836: result := wf_engine.eng_notified||':'||wf_engine.eng_null||
3837: ':'||wf_engine.eng_null;
3838: -- IF PG_DEBUG < 10 THEN
3839: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3840: iex_debug_pub.logmessage ('**** END WAIT_OPTIONAL ************');
3841: END IF;

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

3840: iex_debug_pub.logmessage ('**** END WAIT_OPTIONAL ************');
3841: END IF;
3842: exception
3843: when others then
3844: result := wf_engine.eng_completed ||':'||wf_no;
3845: wf_core.context('IEX_STRATEGY_WF','WAIT_OPTIONAL',itemtype,
3846: itemkey,to_char(actid),funcmode);
3847: raise;
3848:

Line 3870: if funcmode <> wf_engine.eng_run then

3866: -- IF PG_DEBUG < 10 THEN
3867: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3868: iex_debug_pub.logmessage ('**** START WAIT_ESCALATION ************');
3869: END IF;
3870: if funcmode <> wf_engine.eng_run then
3871: result := wf_engine.eng_null;
3872: return;
3873: end if;
3874:

Line 3871: result := wf_engine.eng_null;

3867: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3868: iex_debug_pub.logmessage ('**** START WAIT_ESCALATION ************');
3869: END IF;
3870: if funcmode <> wf_engine.eng_run then
3871: result := wf_engine.eng_null;
3872: return;
3873: end if;
3874:
3875:

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

3877: -- IF PG_DEBUG < 10 THEN
3878: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3879: iex_debug_pub.logmessage('WAIT_ESCALATION: ' || 'FUNCMODE' ||funcmode);
3880: END IF;
3881: l_value :=wf_engine.GetActivityLabel(actid);
3882: wf_engine.SetItemAttrText(itemtype => itemtype,
3883: itemkey => itemkey,
3884: aname => 'ACTIVITY_NAME',
3885: avalue => l_value);

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

3878: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3879: iex_debug_pub.logmessage('WAIT_ESCALATION: ' || 'FUNCMODE' ||funcmode);
3880: END IF;
3881: l_value :=wf_engine.GetActivityLabel(actid);
3882: wf_engine.SetItemAttrText(itemtype => itemtype,
3883: itemkey => itemkey,
3884: aname => 'ACTIVITY_NAME',
3885: avalue => l_value);
3886:

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

3889: iex_debug_pub.logMessage('WAIT_ESCALATION: ' || 'ACTIVITYNAME' ||l_value);
3890: END IF;
3891:
3892:
3893: result := wf_engine.eng_notified||':'||wf_engine.eng_null||
3894: ':'||wf_engine.eng_null;
3895: -- IF PG_DEBUG < 10 THEN
3896: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3897: iex_debug_pub.logmessage ('**** END WAIT_ESCALATION ************');

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

3890: END IF;
3891:
3892:
3893: result := wf_engine.eng_notified||':'||wf_engine.eng_null||
3894: ':'||wf_engine.eng_null;
3895: -- IF PG_DEBUG < 10 THEN
3896: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3897: iex_debug_pub.logmessage ('**** END WAIT_ESCALATION ************');
3898: END IF;

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

3897: iex_debug_pub.logmessage ('**** END WAIT_ESCALATION ************');
3898: END IF;
3899: exception
3900: when others then
3901: result := wf_engine.eng_completed ||':'||wf_no;
3902: wf_core.context('IEX_STRATEGY_WF','WAIT_ESCALATION',itemtype,
3903: itemkey,to_char(actid),funcmode);
3904: raise;
3905:

Line 3936: if funcmode <> wf_engine.eng_run then

3932: -- IF PG_DEBUG < 10 THEN
3933: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3934: iex_debug_pub.logmessage ('**** START WAIT_STRATEGY ************');
3935: END IF;
3936: if funcmode <> wf_engine.eng_run then
3937: result := wf_engine.eng_null;
3938: return;
3939: end if;
3940:

Line 3937: result := wf_engine.eng_null;

3933: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3934: iex_debug_pub.logmessage ('**** START WAIT_STRATEGY ************');
3935: END IF;
3936: if funcmode <> wf_engine.eng_run then
3937: result := wf_engine.eng_null;
3938: return;
3939: end if;
3940:
3941:

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

3943: -- IF PG_DEBUG < 10 THEN
3944: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3945: iex_debug_pub.logmessage('WAIT_STRATEGY: ' || 'FUNCMODE' ||funcmode);
3946: END IF;
3947: l_value :=wf_engine.GetActivityLabel(actid);
3948: wf_engine.SetItemAttrText(itemtype => itemtype,
3949: itemkey => itemkey,
3950: aname => 'ACTIVITY_NAME',
3951: avalue => l_value);

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

3944: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3945: iex_debug_pub.logmessage('WAIT_STRATEGY: ' || 'FUNCMODE' ||funcmode);
3946: END IF;
3947: l_value :=wf_engine.GetActivityLabel(actid);
3948: wf_engine.SetItemAttrText(itemtype => itemtype,
3949: itemkey => itemkey,
3950: aname => 'ACTIVITY_NAME',
3951: avalue => l_value);
3952:

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

3955: iex_debug_pub.logMessage('WAIT_STRATEGY: ' || 'ACTIVITYNAME' ||l_value);
3956: END IF;
3957:
3958:
3959: result := wf_engine.eng_notified||':'||wf_engine.eng_null||
3960: ':'||wf_engine.eng_null;
3961: -- IF PG_DEBUG < 10 THEN
3962: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3963: iex_debug_pub.logmessage ('**** END WAIT_STRATEGY ************');

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

3956: END IF;
3957:
3958:
3959: result := wf_engine.eng_notified||':'||wf_engine.eng_null||
3960: ':'||wf_engine.eng_null;
3961: -- IF PG_DEBUG < 10 THEN
3962: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3963: iex_debug_pub.logmessage ('**** END WAIT_STRATEGY ************');
3964: END IF;

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

3963: iex_debug_pub.logmessage ('**** END WAIT_STRATEGY ************');
3964: END IF;
3965: exception
3966: when others then
3967: result := wf_engine.eng_completed ||':'||wf_engine.eng_null;
3968: wf_core.context('IEX_STRATEGY_WF','WAIT_STRATEGY',itemtype,
3969: itemkey,to_char(actid),funcmode);
3970: raise;
3971:

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

3990: l_strategy_id NUMBER;
3991:
3992: BEGIN
3993:
3994: wf_engine.SetItemAttrText(itemtype => itemtype,
3995: itemkey => itemkey,
3996: aname => 'STRATEGY_STATUS',
3997: avalue => 'CANCELLED');
3998:

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

3997: avalue => 'CANCELLED');
3998:
3999: -- inside the close_strategy_procedure , the
4000: --existing strategy is CANCELLED.
4001: wf_engine.SetItemAttrNumber(itemtype =>itemtype,
4002: itemkey => itemkey,
4003: aname => 'WORK_ITEMID',
4004: avalue => NULL);
4005:

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

4004: avalue => NULL);
4005:
4006: exception
4007: when others then
4008: result := wf_engine.eng_completed ||':'||wf_engine.eng_null;
4009: wf_core.context('IEX_STRATEGY_WF','SET_STRATEGY_STATUS',itemtype,
4010: itemkey,to_char(actid),funcmode);
4011: raise;
4012: END SET_STRATEGY_STATUS;

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

4055: l_return_status);
4056: END IF;
4057:
4058: BEGIN
4059: wf_engine.abortprocess(itemtype =>'IEXSTRY',
4060: itemkey => l_strategy_id);
4061: EXCEPTION
4062: WHEN OTHERS THEN
4063: -- IF PG_DEBUG < 10 THEN

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

4097: iex_debug_pub.logmessage ('**** start SET_SESSION_CTX ************');
4098: END IF;
4099: --set item Attributes
4100: --set org_id
4101: wf_engine.SetItemAttrNumber(itemtype =>itemtype,
4102: itemkey => itemkey,
4103: aname => 'USER_ID',
4104: avalue => FND_GLOBAL.USER_ID);
4105: --set resp_id

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

4102: itemkey => itemkey,
4103: aname => 'USER_ID',
4104: avalue => FND_GLOBAL.USER_ID);
4105: --set resp_id
4106: wf_engine.SetItemAttrNumber(itemtype =>itemtype,
4107: itemkey => itemkey,
4108: aname => 'RESP_ID',
4109: avalue => FND_GLOBAL.RESP_ID);
4110: --set app_resp_id

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

4107: itemkey => itemkey,
4108: aname => 'RESP_ID',
4109: avalue => FND_GLOBAL.RESP_ID);
4110: --set app_resp_id
4111: wf_engine.SetItemAttrNumber(itemtype =>itemtype,
4112: itemkey => itemkey,
4113: aname => 'RESP_APPL_ID',
4114: avalue => FND_GLOBAL.RESP_APPL_ID );
4115:

Line 4131: l_party_id := wf_engine.GetItemAttrNumber(

4127: END IF;
4128:
4129:
4130: ---get party_id from the work flow
4131: l_party_id := wf_engine.GetItemAttrNumber(
4132: itemtype => itemtype,
4133: itemkey => itemkey,
4134: aname => 'PARTY_ID');
4135:

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

4135:
4136: if l_party_id is not null then
4137: begin
4138: select party_name into l_party_name from hz_parties where party_id = l_party_id;
4139: wf_engine.SetItemAttrText(itemtype =>itemtype,
4140: itemkey => itemkey,
4141: aname => 'CUSTOMER_NAME',
4142: avalue => l_party_name);
4143: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

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

4153: iex_debug_pub.logmessage ('**** End SET_SESSION_CTX ************');
4154: END IF;
4155: EXCEPTION
4156: when others then
4157: result := wf_engine.eng_completed ||':'||wf_engine.eng_null;
4158: wf_core.context('IEX_STRATEGY_WF','SET_SESSION_CTX',itemtype,
4159: itemkey,to_char(actid),funcmode);
4160: raise;
4161:

Line 4556: if funcmode <> wf_engine.eng_run then

4552: BEGIN
4553: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
4554: iex_debug_pub.logmessage ('**** START wait_on_hold_signal ************');
4555: END IF;
4556: if funcmode <> wf_engine.eng_run then
4557: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
4558: iex_debug_pub.logmessage('SECOND TIME FUNCMODE' ||funcmode);
4559: END IF;
4560: result := wf_engine.eng_null;

Line 4560: result := wf_engine.eng_null;

4556: if funcmode <> wf_engine.eng_run then
4557: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
4558: iex_debug_pub.logmessage('SECOND TIME FUNCMODE' ||funcmode);
4559: END IF;
4560: result := wf_engine.eng_null;
4561: return;
4562: end if;
4563:
4564:

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

4565:
4566: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
4567: iex_debug_pub.logmessage('FUNCMODE' ||funcmode);
4568: END IF;
4569: l_value :=wf_engine.GetActivityLabel(actid);
4570: wf_engine.SetItemAttrText(itemtype => itemtype,
4571: itemkey => itemkey,
4572: aname => 'ACTIVITY_NAME',
4573: avalue => l_value);

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

4566: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
4567: iex_debug_pub.logmessage('FUNCMODE' ||funcmode);
4568: END IF;
4569: l_value :=wf_engine.GetActivityLabel(actid);
4570: wf_engine.SetItemAttrText(itemtype => itemtype,
4571: itemkey => itemkey,
4572: aname => 'ACTIVITY_NAME',
4573: avalue => l_value);
4574: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

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

4575: iex_debug_pub.logMessage('ACTIVITYNAME' ||l_value);
4576: END IF;
4577:
4578:
4579: result := wf_engine.eng_notified||':'||wf_engine.eng_null||
4580: ':'||wf_engine.eng_null;
4581: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
4582: iex_debug_pub.logmessage ('**** END wait_on_hold_signal ************');
4583: END IF;

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

4576: END IF;
4577:
4578:
4579: result := wf_engine.eng_notified||':'||wf_engine.eng_null||
4580: ':'||wf_engine.eng_null;
4581: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
4582: iex_debug_pub.logmessage ('**** END wait_on_hold_signal ************');
4583: END IF;
4584: exception

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

4582: iex_debug_pub.logmessage ('**** END wait_on_hold_signal ************');
4583: END IF;
4584: exception
4585: when others then
4586: result := wf_engine.eng_completed ||':'||wf_no;
4587: wf_core.context('IEX_STRATEGY_WF','wait_on_hold_signal',itemtype,
4588: itemkey,to_char(actid),funcmode);
4589: raise;
4590:

Line 4615: if funcmode <> wf_engine.eng_run then

4611:
4612: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
4613: iex_debug_pub.logmessage ('**** START update_work_item_to_open ************');
4614: END IF;
4615: if funcmode <> wf_engine.eng_run then
4616: result := wf_engine.eng_null;
4617: return;
4618: end if;
4619:

Line 4616: result := wf_engine.eng_null;

4612: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
4613: iex_debug_pub.logmessage ('**** START update_work_item_to_open ************');
4614: END IF;
4615: if funcmode <> wf_engine.eng_run then
4616: result := wf_engine.eng_null;
4617: return;
4618: end if;
4619:
4620: l_work_item_id := wf_engine.GetItemAttrNumber(

Line 4620: l_work_item_id := wf_engine.GetItemAttrNumber(

4616: result := wf_engine.eng_null;
4617: return;
4618: end if;
4619:
4620: l_work_item_id := wf_engine.GetItemAttrNumber(
4621: itemtype => itemtype,
4622: itemkey => itemkey,
4623: aname => 'WORK_ITEMID');
4624:

Line 4625: l_strategy_status := wf_engine.GetItemAttrText(

4621: itemtype => itemtype,
4622: itemkey => itemkey,
4623: aname => 'WORK_ITEMID');
4624:
4625: l_strategy_status := wf_engine.GetItemAttrText(
4626: itemtype => itemtype,
4627: itemkey => itemkey,
4628: aname => 'STRATEGY_STATUS');
4629:

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

4630: iex_debug_pub.logMessage('Got the work item ' || itemtype || ' item key ' || itemkey
4631: || ' l_work_item_ID ' || l_work_item_id || ' Strategy_status ' || l_strategy_status);
4632:
4633: if l_strategy_status in ('CLOSED','CANCELLED') then
4634: result := wf_engine.eng_completed ||':'||wf_yes;
4635: return;
4636: end if;
4637:
4638: if (l_work_item_id is not null ) then

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

4654: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
4655: iex_debug_pub.logmessage('FUNCMODE ' ||funcmode);
4656: END IF;
4657:
4658: l_value :=wf_engine.GetActivityLabel(actid);
4659:
4660: wf_engine.SetItemAttrText(itemtype => itemtype,
4661: itemkey => itemkey,
4662: aname => 'ACTIVITY_NAME',

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

4656: END IF;
4657:
4658: l_value :=wf_engine.GetActivityLabel(actid);
4659:
4660: wf_engine.SetItemAttrText(itemtype => itemtype,
4661: itemkey => itemkey,
4662: aname => 'ACTIVITY_NAME',
4663: avalue => l_value);
4664:

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

4666: iex_debug_pub.logMessage('ACTIVITYNAME ' ||l_value);
4667: END IF;
4668:
4669:
4670: result := wf_engine.eng_completed ||':'||wf_yes;
4671:
4672: exception
4673: when others then
4674: iex_debug_pub.logmessage ('**** EXCEPTION update_work_item_to_open ************');

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

4671:
4672: exception
4673: when others then
4674: iex_debug_pub.logmessage ('**** EXCEPTION update_work_item_to_open ************');
4675: result := wf_engine.eng_completed ||':'||wf_no;
4676: wf_core.context('IEX_STRATEGY_WF','wait_on_hold_signal',itemtype,
4677: itemkey,to_char(actid),funcmode);
4678: raise;
4679: END;

Line 4711: result := wf_engine.eng_null;

4707: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
4708: iex_debug_pub.logmessage ('**** START UPDATE_ESCALATION_FLAG ************');
4709: END IF;
4710: if funcmode <> 'RUN' then
4711: result := wf_engine.eng_null;
4712: return;
4713: end if;
4714:
4715: l_work_item_id := wf_engine.GetItemAttrText(

Line 4715: l_work_item_id := wf_engine.GetItemAttrText(

4711: result := wf_engine.eng_null;
4712: return;
4713: end if;
4714:
4715: l_work_item_id := wf_engine.GetItemAttrText(
4716: itemtype => itemtype,
4717: itemkey => itemkey,
4718: aname => 'WORK_ITEMID');
4719: l_party_id := wf_engine.GetItemAttrText(

Line 4719: l_party_id := wf_engine.GetItemAttrText(

4715: l_work_item_id := wf_engine.GetItemAttrText(
4716: itemtype => itemtype,
4717: itemkey => itemkey,
4718: aname => 'WORK_ITEMID');
4719: l_party_id := wf_engine.GetItemAttrText(
4720: itemtype => itemtype,
4721: itemkey => itemkey,
4722: aname => 'PARTY_ID');
4723: -- IF PG_DEBUG < 10 THEN

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

4754: when others then
4755: iex_debug_pub.logmessage('UPDATE_ESC_FLAG:Exception when refreshing UWQ Summary: '||SQLERRM);
4756: end;
4757:
4758: result := wf_engine.eng_completed ||':'||wf_yes;
4759: else
4760: RAISE EXC;
4761: END IF;
4762: -- IF PG_DEBUG < 10 THEN

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

4780: iex_debug_pub.logMessage('Current resource id ' || l_resource_id );
4781:
4782: set_notification_resources(l_resource_id, itemtype, itemkey);
4783:
4784: result := wf_engine.eng_completed ||':'||wf_yes;
4785:
4786: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
4787: iex_debug_pub.logmessage ('**** END UPDATE_NOTIFICATION_RESOURCE ************');
4788: END IF;