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

Line 1675: wf_engine.createProcess ( ItemType => l_ItemType,

1671: END IF;
1672:
1673: fnd_profile.get('RESP_ID', l_responsibility_id);
1674: fnd_profile.get('RESP_APPL_ID', l_application_id);
1675: wf_engine.createProcess ( ItemType => l_ItemType,
1676: ItemKey => l_ItemKey,
1677: process => 'PO_APPROVAL_REMINDER' );
1678:
1679: -- bug 852056: Need to create RESP_ID and APPLICATION_ID

Line 1680: wf_engine.AddItemAttr( itemtype => l_itemtype,

1676: ItemKey => l_ItemKey,
1677: process => 'PO_APPROVAL_REMINDER' );
1678:
1679: -- bug 852056: Need to create RESP_ID and APPLICATION_ID
1680: wf_engine.AddItemAttr( itemtype => l_itemtype,
1681: itemkey => l_itemkey,
1682: aname => 'RESP_ID');
1683:
1684: wf_engine.AddItemAttr( itemtype => l_itemtype,

Line 1684: wf_engine.AddItemAttr( itemtype => l_itemtype,

1680: wf_engine.AddItemAttr( itemtype => l_itemtype,
1681: itemkey => l_itemkey,
1682: aname => 'RESP_ID');
1683:
1684: wf_engine.AddItemAttr( itemtype => l_itemtype,
1685: itemkey => l_itemkey,
1686: aname => 'APPLICATION_ID');
1687:
1688: wf_engine.SetItemAttrNumber ( itemtype => l_itemtype,

Line 1688: wf_engine.SetItemAttrNumber ( itemtype => l_itemtype,

1684: wf_engine.AddItemAttr( itemtype => l_itemtype,
1685: itemkey => l_itemkey,
1686: aname => 'APPLICATION_ID');
1687:
1688: wf_engine.SetItemAttrNumber ( itemtype => l_itemtype,
1689: itemkey => l_itemkey,
1690: aname => 'RESP_ID',
1691: avalue => l_responsibility_id );
1692:

Line 1693: wf_engine.SetItemAttrNumber ( itemtype => l_itemtype,

1689: itemkey => l_itemkey,
1690: aname => 'RESP_ID',
1691: avalue => l_responsibility_id );
1692:
1693: wf_engine.SetItemAttrNumber ( itemtype => l_itemtype,
1694: itemkey => l_itemkey,
1695: aname => 'APPLICATION_ID',
1696: avalue => l_application_id );
1697:

Line 1698: wf_engine.SetItemAttrNumber ( itemtype => l_ItemType,

1694: itemkey => l_itemkey,
1695: aname => 'APPLICATION_ID',
1696: avalue => l_application_id );
1697:
1698: wf_engine.SetItemAttrNumber ( itemtype => l_ItemType,
1699: itemkey => l_itemkey,
1700: aname => 'DOCUMENT_ID',
1701: avalue => p_doc_header_id );
1702:

Line 1703: wf_engine.SetItemAttrText ( itemtype => l_itemtype,

1699: itemkey => l_itemkey,
1700: aname => 'DOCUMENT_ID',
1701: avalue => p_doc_header_id );
1702:
1703: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
1704: itemkey => l_itemkey,
1705: aname => 'DOCUMENT_NUMBER',
1706: avalue => p_doc_number );
1707:

Line 1708: wf_engine.SetItemAttrText ( itemtype => l_itemtype,

1704: itemkey => l_itemkey,
1705: aname => 'DOCUMENT_NUMBER',
1706: avalue => p_doc_number );
1707:
1708: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
1709: itemkey => l_itemkey,
1710: aname => 'DOCUMENT_TYPE',
1711: avalue => p_doc_type );
1712:

Line 1713: wf_engine.SetItemAttrText ( itemtype => l_itemtype,

1709: itemkey => l_itemkey,
1710: aname => 'DOCUMENT_TYPE',
1711: avalue => p_doc_type );
1712:
1713: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
1714: itemkey => l_itemkey,
1715: aname => 'DOCUMENT_SUBTYPE',
1716: avalue => p_doc_subtype );
1717:

Line 1718: wf_engine.SetItemAttrNumber ( itemtype => l_ItemType,

1714: itemkey => l_itemkey,
1715: aname => 'DOCUMENT_SUBTYPE',
1716: avalue => p_doc_subtype );
1717:
1718: wf_engine.SetItemAttrNumber ( itemtype => l_ItemType,
1719: itemkey => l_itemkey,
1720: aname => 'RELEASE_REV_NUM',
1721: avalue => p_release_num );
1722:

Line 1724: wf_engine.SetItemAttrNumber ( itemtype => l_ItemType,

1720: aname => 'RELEASE_REV_NUM',
1721: avalue => p_release_num );
1722:
1723:
1724: wf_engine.SetItemAttrNumber ( itemtype => l_ItemType,
1725: itemkey => l_itemkey,
1726: aname => 'AGENT_ID',
1727: avalue => p_agent_id );
1728:

Line 1742: wf_engine.SetItemAttrText ( itemtype => l_itemtype,

1738: PO_REQAPPROVAL_INIT1.Get_User_Name (p_agent_id,
1739: l_agent_username,
1740: l_agent_disp_name);
1741:
1742: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
1743: itemkey => l_itemkey,
1744: aname => 'AGENT_USER_NAME',
1745: avalue => l_agent_username );
1746:

Line 1747: wf_engine.SetItemAttrText ( itemtype => l_itemtype,

1743: itemkey => l_itemkey,
1744: aname => 'AGENT_USER_NAME',
1745: avalue => l_agent_username );
1746:
1747: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
1748: itemkey => l_itemkey,
1749: aname => 'AGENT_DISP_NAME',
1750: avalue => l_agent_disp_name );
1751:

Line 1755: wf_engine.StartProcess ( ItemType => l_ItemType,

1751:
1752: -- dbms_output.put_line ('Start_Approval_Reminder, agent username '|| l_agent_username);
1753:
1754: -- dbms_output.put_line ('Start_Approval_Reminder, agent dispname '|| l_agent_disp_name);
1755: wf_engine.StartProcess ( ItemType => l_ItemType,
1756: ItemKey => l_ItemKey );
1757:
1758: l_progress := 'PO_APPROVAL_REMINDER_SV.Start_Approval_Reminder: 900 ';
1759: IF (g_po_wf_debug = 'Y') THEN

Line 1842: wf_engine.GetItemAttrNumber ( itemtype => ItemType,

1838: -- dbms_output.put_line ('Set doc type ' ||ItemKey);
1839:
1840:
1841: l_doc_header_id :=
1842: wf_engine.GetItemAttrNumber ( itemtype => ItemType,
1843: itemkey => itemkey,
1844: aname => 'DOCUMENT_ID');
1845:
1846: l_doc_type :=

Line 1847: wf_engine.GetItemAttrText ( itemtype => itemtype,

1843: itemkey => itemkey,
1844: aname => 'DOCUMENT_ID');
1845:
1846: l_doc_type :=
1847: wf_engine.GetItemAttrText ( itemtype => itemtype,
1848: itemkey => itemkey,
1849: aname => 'DOCUMENT_TYPE');
1850: l_doc_subtype :=
1851: wf_engine.GetItemAttrText ( itemtype => itemtype,

Line 1851: wf_engine.GetItemAttrText ( itemtype => itemtype,

1847: wf_engine.GetItemAttrText ( itemtype => itemtype,
1848: itemkey => itemkey,
1849: aname => 'DOCUMENT_TYPE');
1850: l_doc_subtype :=
1851: wf_engine.GetItemAttrText ( itemtype => itemtype,
1852: itemkey => itemkey,
1853: aname => 'DOCUMENT_SUBTYPE');
1854:
1855:

Line 1889: wf_engine.SetItemAttrText ( itemtype => itemType,

1885: l_doc_type_name,
1886: l_doc_type_lookup_code);
1887:
1888:
1889: wf_engine.SetItemAttrText ( itemtype => itemType,
1890: itemkey => itemkey,
1891: aname => 'DOC_TYPE_DISP' ,
1892: avalue => l_doc_type_name);
1893:

Line 1903: wf_engine.SetItemAttrText ( itemtype => itemType,

1899: fnd_message.set_name ('PO','PO_WF_NOTIF_REQUIRES_APPROVAL');
1900:
1901: l_error_msg := fnd_message.get;
1902:
1903: wf_engine.SetItemAttrText ( itemtype => itemType,
1904: itemkey => itemkey,
1905: aname => 'NEVER_APPROVED_MSG' ,
1906: avalue => l_error_msg);
1907:

Line 1913: wf_engine.SetItemAttrText ( itemtype => itemType,

1909: -- Get requires approval message
1910: fnd_message.set_name ('PO','PO_WF_NOTIF_REQUIRES_APPROVAL');
1911: l_error_msg := fnd_message.get;
1912:
1913: wf_engine.SetItemAttrText ( itemtype => itemType,
1914: itemkey => itemkey,
1915: aname => 'REQUIRES_APPROVAL_MSG' ,
1916: avalue => l_error_msg);
1917:

Line 1932: wf_engine.SetItemAttrText ( itemtype => itemType,

1928: -- Get requisition returned approval message
1929: fnd_message.set_name ('PO','PO_WF_NOTIF_RETURNED');
1930: l_error_msg := fnd_message.get;
1931:
1932: wf_engine.SetItemAttrText ( itemtype => itemType,
1933: itemkey => itemkey,
1934: aname => 'REQUISITION_RETURNED_MSG' ,
1935: avalue => l_error_msg);
1936:

Line 1943: wf_engine.SetItemAttrText ( itemtype => itemType,

1939: -- Get requisition returned approval message
1940: fnd_message.set_name ('PO','PO_WF_NOTIF_REJECTED');
1941: l_error_msg := fnd_message.get;
1942:
1943: wf_engine.SetItemAttrText ( itemtype => itemType,
1944: itemkey => itemkey,
1945: aname => 'REQUISITION_REJECTED_MSG' ,
1946: avalue => l_error_msg);
1947: end if;

Line 1958: wf_engine.SetItemAttrText ( itemtype => itemType,

1954: -- check if l_doc_type is REQUISITION.
1955:
1956: /*if NVL(l_req_status, 'INCOMPLETE') in ('RETURNED','REJECTED') then
1957:
1958: wf_engine.SetItemAttrText ( itemtype => itemType,
1959: itemkey => itemkey,
1960: aname => 'NEVER_APPROVED_MSG' ,
1961: avalue => '');
1962:

Line 1963: wf_engine.SetItemAttrText ( itemtype => itemType,

1959: itemkey => itemkey,
1960: aname => 'NEVER_APPROVED_MSG' ,
1961: avalue => '');
1962:
1963: wf_engine.SetItemAttrText ( itemtype => itemType,
1964: itemkey => itemkey,
1965: aname => 'REQUIRES_APPROVAL_MSG' ,
1966: avalue => '');
1967: end if;*/

Line 1976: wf_engine.SetItemAttrText ( itemtype => itemType,

1972: -- Set wrong forward to message to NULL until user enters
1973: -- an invalid forward to ID
1974: l_error_msg := '';
1975:
1976: wf_engine.SetItemAttrText ( itemtype => itemType,
1977: itemkey => itemkey,
1978: aname => 'WRONG_FORWARD_TO_MSG' ,
1979: avalue => '');
1980:

Line 2014: wf_engine.SetItemAttrDate ( itemtype => ItemType,

2010: l_acceptance_past_due := 'Y';
2011:
2012: END IF;
2013:
2014: wf_engine.SetItemAttrDate ( itemtype => ItemType,
2015: itemkey => itemkey,
2016: aname => 'ACCEPTANCE_DUE_DATE',
2017: avalue => l_acceptance_due_date );
2018:

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

2016: aname => 'ACCEPTANCE_DUE_DATE',
2017: avalue => l_acceptance_due_date );
2018:
2019:
2020: wf_engine.SetItemAttrText ( itemtype => itemtype,
2021: itemkey => itemkey,
2022: aname => 'ACCEPTANCE_PAST_DUE',
2023: avalue => l_acceptance_past_due );
2024:

Line 2059: wf_engine.SetItemAttrDate ( itemtype => ItemType,

2055: l_quote_type_lookup_code,
2056: l_quote_type_disp);
2057:
2058:
2059: wf_engine.SetItemAttrDate ( itemtype => ItemType,
2060: itemkey => itemkey,
2061: aname => 'RFQ_REPLY_DATE',
2062: avalue => l_rfq_reply_date );
2063:

Line 2065: wf_engine.SetItemAttrDate ( itemtype => ItemType,

2061: aname => 'RFQ_REPLY_DATE',
2062: avalue => l_rfq_reply_date );
2063:
2064:
2065: wf_engine.SetItemAttrDate ( itemtype => ItemType,
2066: itemkey => itemkey,
2067: aname => 'RFQ_CLOSE_DATE',
2068: avalue => l_RFQ_close_date );
2069:

Line 2071: wf_engine.SetItemAttrDate ( itemtype => ItemType,

2067: aname => 'RFQ_CLOSE_DATE',
2068: avalue => l_RFQ_close_date );
2069:
2070:
2071: wf_engine.SetItemAttrDate ( itemtype => ItemType,
2072: itemkey => itemkey,
2073: aname => 'QUOTE_END_DATE_ACTIVE',
2074: avalue => l_quote_end_date_active );
2075:

Line 2077: wf_engine.SetItemAttrNumber ( itemtype => ItemType,

2073: aname => 'QUOTE_END_DATE_ACTIVE',
2074: avalue => l_quote_end_date_active );
2075:
2076:
2077: wf_engine.SetItemAttrNumber ( itemtype => ItemType,
2078: itemkey => itemkey,
2079: aname => 'QUOTE_WARNING_DELAY',
2080: avalue => l_quote_warning_delay );
2081:

Line 2082: wf_engine.SetItemAttrText ( itemtype => ItemType,

2078: itemkey => itemkey,
2079: aname => 'QUOTE_WARNING_DELAY',
2080: avalue => l_quote_warning_delay );
2081:
2082: wf_engine.SetItemAttrText ( itemtype => ItemType,
2083: itemkey => Itemkey,
2084: aname => 'RFQ_STATUS',
2085: avalue => l_status_lookup_code );
2086:

Line 2087: wf_engine.SetItemAttrText ( itemtype => ItemType,

2083: itemkey => Itemkey,
2084: aname => 'RFQ_STATUS',
2085: avalue => l_status_lookup_code );
2086:
2087: wf_engine.SetItemAttrText ( itemtype => ItemType,
2088: itemkey => Itemkey,
2089: aname => 'QUOTE_STATUS',
2090: avalue => l_status_lookup_code );
2091:

Line 2093: wf_engine.SetItemAttrText ( itemtype => ItemType,

2089: aname => 'QUOTE_STATUS',
2090: avalue => l_status_lookup_code );
2091:
2092:
2093: wf_engine.SetItemAttrText ( itemtype => ItemType,
2094: itemkey => Itemkey,
2095: aname => 'QUOTE_TYPE_DISP',
2096: avalue => l_quote_type_disp );
2097:

Line 2201: wf_engine.GetItemAttrNumber (itemtype => itemtype,

2197: -- user context is lost. So need pass responsibility_id and
2198: -- application_id through workflow attributes.
2199:
2200: l_ResponsibilityID :=
2201: wf_engine.GetItemAttrNumber (itemtype => itemtype,
2202: itemkey => itemkey,
2203: aname => 'RESP_ID');
2204:
2205: l_ApplicationID :=

Line 2206: wf_engine.GetItemAttrNumber (itemtype => itemtype,

2202: itemkey => itemkey,
2203: aname => 'RESP_ID');
2204:
2205: l_ApplicationID :=
2206: wf_engine.GetItemAttrNumber (itemtype => itemtype,
2207: itemkey => itemkey,
2208: aname => 'APPLICATION_ID');
2209:
2210: l_DocumentTypeCode :=

Line 2211: wf_engine.GetItemAttrText ( itemtype => itemtype,

2207: itemkey => itemkey,
2208: aname => 'APPLICATION_ID');
2209:
2210: l_DocumentTypeCode :=
2211: wf_engine.GetItemAttrText ( itemtype => itemtype,
2212: itemkey => itemkey,
2213: aname => 'DOCUMENT_TYPE');
2214:
2215: l_DocumentSubtype :=

Line 2216: wf_engine.GetItemAttrText ( itemtype => itemtype,

2212: itemkey => itemkey,
2213: aname => 'DOCUMENT_TYPE');
2214:
2215: l_DocumentSubtype :=
2216: wf_engine.GetItemAttrText ( itemtype => itemtype,
2217: itemkey => itemkey,
2218: aname => 'DOCUMENT_SUBTYPE');
2219: l_DocumentNumber :=
2220: wf_engine.GetItemAttrText ( itemtype => itemtype,

Line 2220: wf_engine.GetItemAttrText ( itemtype => itemtype,

2216: wf_engine.GetItemAttrText ( itemtype => itemtype,
2217: itemkey => itemkey,
2218: aname => 'DOCUMENT_SUBTYPE');
2219: l_DocumentNumber :=
2220: wf_engine.GetItemAttrText ( itemtype => itemtype,
2221: itemkey => itemkey,
2222: aname => 'DOCUMENT_NUMBER');
2223: l_DocumentID :=
2224: wf_engine.GetItemAttrNumber ( itemtype => ItemType,

Line 2224: wf_engine.GetItemAttrNumber ( itemtype => ItemType,

2220: wf_engine.GetItemAttrText ( itemtype => itemtype,
2221: itemkey => itemkey,
2222: aname => 'DOCUMENT_NUMBER');
2223: l_DocumentID :=
2224: wf_engine.GetItemAttrNumber ( itemtype => ItemType,
2225: itemkey => itemkey,
2226: aname => 'DOCUMENT_ID');
2227:
2228:

Line 2230: wf_engine.GetItemAttrNumber ( itemtype => ItemType,

2226: aname => 'DOCUMENT_ID');
2227:
2228:
2229: l_PreparerID :=
2230: wf_engine.GetItemAttrNumber ( itemtype => ItemType,
2231: itemkey => itemkey,
2232: aname => 'AGENT_ID');
2233:
2234:

Line 2236: wf_engine.GetItemAttrNumber ( itemtype => ItemType,

2232: aname => 'AGENT_ID');
2233:
2234:
2235: l_forwardToID :=
2236: wf_engine.GetItemAttrNumber ( itemtype => ItemType,
2237: itemkey => itemkey,
2238: aname => 'FORWARD_TO_ID');
2239:
2240: l_forwardFromID :=

Line 2241: wf_engine.GetItemAttrNumber ( itemtype => ItemType,

2237: itemkey => itemkey,
2238: aname => 'FORWARD_TO_ID');
2239:
2240: l_forwardFromID :=
2241: wf_engine.GetItemAttrNumber ( itemtype => ItemType,
2242: itemkey => itemkey,
2243: aname => 'FORWARD_FROM_ID');
2244:
2245:

Line 2247: wf_engine.GetItemAttrText ( itemtype => itemtype,

2243: aname => 'FORWARD_FROM_ID');
2244:
2245:
2246: l_Note :=
2247: wf_engine.GetItemAttrText ( itemtype => itemtype,
2248: itemkey => itemkey,
2249: aname => 'NOTE');
2250:
2251:

Line 2254: wf_engine.GetItemAttrNumber ( itemtype => ItemType,

2250:
2251:
2252: /*** DEBUG
2253: l_DefaultApprovalPathID :=
2254: wf_engine.GetItemAttrNumber ( itemtype => ItemType,
2255: itemkey => itemkey,
2256: aname => 'DEFAULT_APPROVAL_PATH_ID');
2257: ***/
2258:

Line 2531: wf_engine.CreateProcess ( ItemType => l_ItemType,

2527:
2528: -- bug 852056: Need to create process here, and then set
2529: -- attributes: USER_ID, RESPONSIBILITY_ID, and APPLICATION_ID
2530: -- also need to initialize fnd_global
2531: wf_engine.CreateProcess ( ItemType => l_ItemType,
2532: ItemKey => l_ItemKey,
2533: process => l_WorkflowProcess);
2534:
2535: wf_engine.SetItemAttrNumber ( ItemType => l_ItemType,

Line 2535: wf_engine.SetItemAttrNumber ( ItemType => l_ItemType,

2531: wf_engine.CreateProcess ( ItemType => l_ItemType,
2532: ItemKey => l_ItemKey,
2533: process => l_WorkflowProcess);
2534:
2535: wf_engine.SetItemAttrNumber ( ItemType => l_ItemType,
2536: ItemKey => l_ItemKey,
2537: aname => 'USER_ID',
2538: avalue => l_user_id);
2539:

Line 2540: wf_engine.SetItemAttrNumber ( ItemType => l_ItemType,

2536: ItemKey => l_ItemKey,
2537: aname => 'USER_ID',
2538: avalue => l_user_id);
2539:
2540: wf_engine.SetItemAttrNumber ( ItemType => l_ItemType,
2541: ItemKey => l_ItemKey,
2542: aname => 'RESPONSIBILITY_ID',
2543: avalue => p_ResponsibilityID);
2544:

Line 2545: wf_engine.SetItemAttrNumber ( ItemType => l_ItemType,

2541: ItemKey => l_ItemKey,
2542: aname => 'RESPONSIBILITY_ID',
2543: avalue => p_ResponsibilityID);
2544:
2545: wf_engine.SetItemAttrNumber ( ItemType => l_ItemType,
2546: ItemKey => l_ItemKey,
2547: aname => 'APPLICATION_ID',
2548: avalue => p_ApplicationID);
2549:

Line 2642: if (funcmode <> wf_engine.eng_run) then

2638:
2639:
2640: -- Do nothing in cancel or timeout mode
2641: --
2642: if (funcmode <> wf_engine.eng_run) then
2643:
2644: resultout := wf_engine.eng_null;
2645: return;
2646:

Line 2644: resultout := wf_engine.eng_null;

2640: -- Do nothing in cancel or timeout mode
2641: --
2642: if (funcmode <> wf_engine.eng_run) then
2643:
2644: resultout := wf_engine.eng_null;
2645: return;
2646:
2647: end if;
2648:

Line 2656: l_forward_to_username_response := wf_engine.GetItemAttrText (itemtype => itemtype,

2652: ** Then set the Forward-To to the one the user entered in the response.
2653: */
2654: /* NOTE: We take the value entered by the user and set it to ALL CAPITAL LETTERS!!!
2655: */
2656: l_forward_to_username_response := wf_engine.GetItemAttrText (itemtype => itemtype,
2657: itemkey => itemkey,
2658: aname => 'FORWARD_TO_USERNAME_RESPONSE');
2659:
2660: l_forward_to_username_response := UPPER(l_forward_to_username_response);

Line 2672: resultout := wf_engine.eng_completed || ':' || 'Y';

2668: IF l_forward_to_username_response is NULL THEN
2669:
2670: -- NULL is a valid case in the remainder process
2671: --
2672: resultout := wf_engine.eng_completed || ':' || 'Y';
2673: --
2674:
2675: ELSIF PO_REQAPPROVAL_FINDAPPRV1.CheckForwardTo(l_forward_to_username_response,
2676: x_user_id) = 'Y' THEN

Line 2682: l_forward_to_username:= wf_engine.GetItemAttrText (itemtype => itemtype,

2678: /* The FORWARD-FROM is now the old FORWARD-TO and the NEW FORWARD-TO is set
2679: ** to what the user entered in the response
2680: */
2681:
2682: l_forward_to_username:= wf_engine.GetItemAttrText (itemtype => itemtype,
2683: itemkey => itemkey,
2684: aname => 'FORWARD_TO_USERNAME');
2685:
2686: l_forward_to_username_disp:= wf_engine.GetItemAttrText (itemtype => itemtype,

Line 2686: l_forward_to_username_disp:= wf_engine.GetItemAttrText (itemtype => itemtype,

2682: l_forward_to_username:= wf_engine.GetItemAttrText (itemtype => itemtype,
2683: itemkey => itemkey,
2684: aname => 'FORWARD_TO_USERNAME');
2685:
2686: l_forward_to_username_disp:= wf_engine.GetItemAttrText (itemtype => itemtype,
2687: itemkey => itemkey,
2688: aname => 'FORWARD_TO_DISPLAY_NAME');
2689:
2690: l_forward_to_id:= wf_engine.GetItemAttrNumber (itemtype => itemtype,

Line 2690: l_forward_to_id:= wf_engine.GetItemAttrNumber (itemtype => itemtype,

2686: l_forward_to_username_disp:= wf_engine.GetItemAttrText (itemtype => itemtype,
2687: itemkey => itemkey,
2688: aname => 'FORWARD_TO_DISPLAY_NAME');
2689:
2690: l_forward_to_id:= wf_engine.GetItemAttrNumber (itemtype => itemtype,
2691: itemkey => itemkey,
2692: aname => 'FORWARD_TO_ID');
2693: /* Set the FORWARD_FROM */
2694: wf_engine.SetItemAttrNumber ( itemtype => itemtype,

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

2690: l_forward_to_id:= wf_engine.GetItemAttrNumber (itemtype => itemtype,
2691: itemkey => itemkey,
2692: aname => 'FORWARD_TO_ID');
2693: /* Set the FORWARD_FROM */
2694: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
2695: itemkey => itemkey,
2696: aname => 'FORWARD_FROM_ID',
2697: avalue => l_forward_to_id);
2698:

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

2695: itemkey => itemkey,
2696: aname => 'FORWARD_FROM_ID',
2697: avalue => l_forward_to_id);
2698:
2699: wf_engine.SetItemAttrText ( itemtype => itemtype,
2700: itemkey => itemkey,
2701: aname => 'FORWARD_FROM_USER_NAME',
2702: avalue => l_forward_to_username);
2703:

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

2700: itemkey => itemkey,
2701: aname => 'FORWARD_FROM_USER_NAME',
2702: avalue => l_forward_to_username);
2703:
2704: wf_engine.SetItemAttrText ( itemtype => itemtype,
2705: itemkey => itemkey,
2706: aname => 'FORWARD_FROM_DISP_NAME',
2707: avalue => l_forward_to_username_disp);
2708:

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

2707: avalue => l_forward_to_username_disp);
2708:
2709: /* Set the FORWARD-TO */
2710:
2711: wf_engine.SetItemAttrText ( itemtype => itemtype,
2712: itemkey => itemkey,
2713: aname => 'FORWARD_TO_USERNAME',
2714: avalue => l_forward_to_username_response);
2715:

Line 2716: wf_engine.SetItemAttrNumber ( itemtype => itemType,

2712: itemkey => itemkey,
2713: aname => 'FORWARD_TO_USERNAME',
2714: avalue => l_forward_to_username_response);
2715:
2716: wf_engine.SetItemAttrNumber ( itemtype => itemType,
2717: itemkey => itemkey,
2718: aname => 'FORWARD_TO_ID',
2719: avalue => x_user_id);
2720:

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

2718: aname => 'FORWARD_TO_ID',
2719: avalue => x_user_id);
2720:
2721: /* Get the Display name for the user from the WF Directory */
2722: wf_engine.SetItemAttrText ( itemtype => itemtype,
2723: itemkey => itemkey,
2724: aname => 'FORWARD_TO_DISPLAY_NAME',
2725: avalue =>
2726: wf_directory.GetRoleDisplayName(l_forward_to_username_response));

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

2725: avalue =>
2726: wf_directory.GetRoleDisplayName(l_forward_to_username_response));
2727:
2728: /* Reset the FORWARD_TO_USERNAME_RESPONSE attribute */
2729: wf_engine.SetItemAttrText (itemtype => itemtype,
2730: itemkey => itemkey,
2731: aname => 'FORWARD_TO_USERNAME_RESPONSE',
2732: avalue => NULL);
2733:

Line 2743: wf_engine.SetItemAttrText ( itemtype => itemType,

2739: */
2740: fnd_message.set_name ('PO','PO_WF_NOTIF_REQUIRES_APPROVAL');
2741: l_error_msg := fnd_message.get;
2742:
2743: wf_engine.SetItemAttrText ( itemtype => itemType,
2744: itemkey => itemkey,
2745: aname => 'REQUIRES_APPROVAL_MSG' ,
2746: avalue => l_error_msg);
2747:

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

2745: aname => 'REQUIRES_APPROVAL_MSG' ,
2746: avalue => l_error_msg);
2747:
2748:
2749: wf_engine.SetItemAttrText ( itemtype => itemtype,
2750: itemkey => itemkey,
2751: aname => 'WRONG_FORWARD_TO_MSG',
2752: avalue => NULL);
2753:

Line 2755: resultout := wf_engine.eng_completed || ':' || 'Y';

2751: aname => 'WRONG_FORWARD_TO_MSG',
2752: avalue => NULL);
2753:
2754: --
2755: resultout := wf_engine.eng_completed || ':' || 'Y';
2756: --
2757:
2758: ELSE
2759:

Line 2772: wf_engine.SetItemAttrText ( itemtype => itemType,

2768: */
2769: fnd_message.set_name ('PO','PO_WF_NOTIF_INVALID_FORWARD');
2770: l_error_msg := fnd_message.get;
2771:
2772: wf_engine.SetItemAttrText ( itemtype => itemType,
2773: itemkey => itemkey,
2774: aname => 'REQUIRES_APPROVAL_MSG' ,
2775: avalue => '');
2776:

Line 2777: wf_engine.SetItemAttrText ( itemtype => itemType,

2773: itemkey => itemkey,
2774: aname => 'REQUIRES_APPROVAL_MSG' ,
2775: avalue => '');
2776:
2777: wf_engine.SetItemAttrText ( itemtype => itemType,
2778: itemkey => itemkey,
2779: aname => 'WRONG_FORWARD_TO_MSG' ,
2780: avalue => l_error_msg);
2781:

Line 2783: resultout := wf_engine.eng_completed || ':' || 'N';

2779: aname => 'WRONG_FORWARD_TO_MSG' ,
2780: avalue => l_error_msg);
2781:
2782: --
2783: resultout := wf_engine.eng_completed || ':' || 'N';
2784: --
2785:
2786: END IF;
2787:

Line 2869: WF_Engine.AbortProcess('APVRMDER',rec.item_key);

2865: to_char(p_DocumentId) ||'-';
2866:
2867: For rec in cand_active_wf(l_itemkey) LOOP
2868: if (po_approval_reminder_sv.is_active('APVRMDER',rec.item_key)) then
2869: WF_Engine.AbortProcess('APVRMDER',rec.item_key);
2870: end if;
2871: End Loop;
2872:
2873: elsif ((p_DocumentTypeCode = 'BLANKET') or (p_DocumentTypeCode = 'CONTRACT')) then

Line 2915: WF_Engine.AbortProcess('APVRMDER',l_itemkey);

2911: to_char(p_DocumentId) ||'-'||
2912: to_char(l_agent_id);
2913: end if;
2914: if (po_approval_reminder_sv.is_active('APVRMDER',l_itemkey)) then
2915: WF_Engine.AbortProcess('APVRMDER',l_itemkey);
2916: end if;
2917:
2918:
2919:

Line 2940: WF_Engine.AbortProcess('APVRMDER',l_itemkey);

2936: to_char(p_DocumentId) ||'-'||
2937: to_char(l_agent_id);
2938:
2939: if (po_approval_reminder_sv.is_active('APVRMDER',l_itemkey)) then
2940: WF_Engine.AbortProcess('APVRMDER',l_itemkey);
2941: end if;
2942:
2943: elsif (p_DocumentTypeCode = 'SCHEDULED') then
2944:

Line 2963: WF_Engine.AbortProcess('APVRMDER',l_itemkey);

2959: to_char(p_DocumentId) ||'-'||
2960: to_char(l_agent_id);
2961:
2962: if (po_approval_reminder_sv.is_active('APVRMDER',l_itemkey)) then
2963: WF_Engine.AbortProcess('APVRMDER',l_itemkey);
2964: end if;
2965: elsif (p_DocumentTypeCode = 'PO_ACCEPTANCE') then
2966:
2967: x_progress := 'PO_APPROVAL_REMINDER_SV.cancel_notif-006';

Line 2985: WF_Engine.AbortProcess('APVRMDER',l_itemkey);

2981: to_char(p_DocumentId);
2982:
2983:
2984: if (po_approval_reminder_sv.is_active('APVRMDER',l_itemkey)) then
2985: WF_Engine.AbortProcess('APVRMDER',l_itemkey);
2986: end if;
2987:
2988: -- Bug 3593182: Removed the item exists condition before
2989: -- the purge as purge only purges existing items

Line 3024: WF_Engine.AbortProcess('APVRMDER',l_itemkey);

3020: to_char(p_DocumentId);
3021:
3022:
3023: if (po_approval_reminder_sv.is_active('APVRMDER',l_itemkey)) then
3024: WF_Engine.AbortProcess('APVRMDER',l_itemkey);
3025: end if;
3026:
3027: -- Bug 3593182: Removed the item exists condition before
3028: -- the purge as purge only purges existing items

Line 3047: WF_Engine.AbortProcess('APVRMDER',l_itemkey);

3043: l_itemkey := l_doc_type ||
3044: to_char(p_DocumentId);
3045:
3046: if (po_approval_reminder_sv.is_active('APVRMDER',l_itemkey)) then
3047: WF_Engine.AbortProcess('APVRMDER',l_itemkey);
3048: end if;
3049:
3050:
3051: -- Bug 3593182: Removed the item exists condition before

Line 3070: WF_Engine.AbortProcess('APVRMDER',l_itemkey);

3066: l_itemkey := l_doc_type ||
3067: to_char(p_DocumentId);
3068:
3069: if (po_approval_reminder_sv.is_active('APVRMDER',l_itemkey)) then
3070: WF_Engine.AbortProcess('APVRMDER',l_itemkey);
3071: end if;
3072:
3073:
3074: -- Bug 3593182: Removed the item exists condition before

Line 3115: --WF Team has provided an api wf_engine.itemstatus to check the

3111: --a union all between wf_item_activity_statuses and
3112: --wf_item_activity_statuses_h(history). A new record
3113: --gets inserted into history table when the wf process
3114: --raises an error.
3115: --WF Team has provided an api wf_engine.itemstatus to check the
3116: --active status of any given activity. We need to call this
3117: --instead of query the wf_item_activity_statuses_v view directly.
3118: BEGIN
3119: wf_engine.itemstatus (itemtype => x_item_type,

Line 3119: wf_engine.itemstatus (itemtype => x_item_type,

3115: --WF Team has provided an api wf_engine.itemstatus to check the
3116: --active status of any given activity. We need to call this
3117: --instead of query the wf_item_activity_statuses_v view directly.
3118: BEGIN
3119: wf_engine.itemstatus (itemtype => x_item_type,
3120: itemkey => x_item_key,
3121: status => x_act_status,
3122: RESULT => x_result
3123: );

Line 3152: WF_Engine.AbortProcess(item_type,item_key,cascade=>true);

3148:
3149: BEGIN
3150:
3151: if (po_approval_reminder_sv.is_active(item_type,item_key)) then
3152: WF_Engine.AbortProcess(item_type,item_key,cascade=>true);
3153: end if;
3154:
3155: END stop_process;
3156:

Line 3483: WF_ENGINE.AbortProcess(g_reminder_item_type, l_item_key );

3479: p_Item_end_date => l_item_end_date);
3480: IF (l_item_exist = 'Y') THEN
3481: -- Abort the process if it is still active.
3482: IF (l_item_end_date IS NULL) THEN
3483: WF_ENGINE.AbortProcess(g_reminder_item_type, l_item_key );
3484: END IF;
3485:
3486: -- Purge the process so we can re-use the item key.
3487: --

Line 3498: wf_engine.CreateProcess ( ItemType => g_reminder_item_type,

3494:
3495: END IF; -- l_item_exist
3496:
3497: -- Create a Reminder workflow process for this PO line.
3498: wf_engine.CreateProcess ( ItemType => g_reminder_item_type,
3499: ItemKey => l_item_key,
3500: Process => 'PO_LINE_REMINDER' );
3501:
3502: -- Set some workflow item attributes.

Line 3605: wf_engine.StartProcess ( ItemType => g_reminder_item_type,

3601: END IF; -- l_req_header_id
3602: -- Bug 3441007 END
3603:
3604: -- Start the Reminder workflow process for this PO line.
3605: wf_engine.StartProcess ( ItemType => g_reminder_item_type,
3606: ItemKey => l_item_key );
3607:
3608: EXCEPTION
3609: WHEN OTHERS THEN

Line 3659: if (funcmode <> wf_engine.eng_run) then

3655: ) IS
3656: l_line_reminder_type VARCHAR2(20);
3657: BEGIN
3658: -- Do nothing if the Workflow mode is Cancel or Timeout.
3659: if (funcmode <> wf_engine.eng_run) then
3660: resultout := wf_engine.eng_null;
3661: return;
3662: end if;
3663:

Line 3660: resultout := wf_engine.eng_null;

3656: l_line_reminder_type VARCHAR2(20);
3657: BEGIN
3658: -- Do nothing if the Workflow mode is Cancel or Timeout.
3659: if (funcmode <> wf_engine.eng_run) then
3660: resultout := wf_engine.eng_null;
3661: return;
3662: end if;
3663:
3664: l_line_reminder_type :=

Line 3668: resultout := wf_engine.eng_completed || ':' || l_line_reminder_type;

3664: l_line_reminder_type :=
3665: po_wf_util_pkg.GetItemAttrText (itemtype => itemtype,
3666: itemkey => itemkey,
3667: aname => 'PO_LINE_REMINDER_TYPE');
3668: resultout := wf_engine.eng_completed || ':' || l_line_reminder_type;
3669:
3670: EXCEPTION
3671: WHEN OTHERS THEN
3672: wf_core.context( 'PO_APPROVAL_REMINDER_SV',