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 1645: wf_engine.createProcess ( ItemType => l_ItemType,

1641: END IF;
1642:
1643: fnd_profile.get('RESP_ID', l_responsibility_id);
1644: fnd_profile.get('RESP_APPL_ID', l_application_id);
1645: wf_engine.createProcess ( ItemType => l_ItemType,
1646: ItemKey => l_ItemKey,
1647: process => 'PO_APPROVAL_REMINDER' );
1648:
1649: -- bug 852056: Need to create RESP_ID and APPLICATION_ID

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

1646: ItemKey => l_ItemKey,
1647: process => 'PO_APPROVAL_REMINDER' );
1648:
1649: -- bug 852056: Need to create RESP_ID and APPLICATION_ID
1650: wf_engine.AddItemAttr( itemtype => l_itemtype,
1651: itemkey => l_itemkey,
1652: aname => 'RESP_ID');
1653:
1654: wf_engine.AddItemAttr( itemtype => l_itemtype,

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

1650: wf_engine.AddItemAttr( itemtype => l_itemtype,
1651: itemkey => l_itemkey,
1652: aname => 'RESP_ID');
1653:
1654: wf_engine.AddItemAttr( itemtype => l_itemtype,
1655: itemkey => l_itemkey,
1656: aname => 'APPLICATION_ID');
1657:
1658: wf_engine.SetItemAttrNumber ( itemtype => l_itemtype,

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

1654: wf_engine.AddItemAttr( itemtype => l_itemtype,
1655: itemkey => l_itemkey,
1656: aname => 'APPLICATION_ID');
1657:
1658: wf_engine.SetItemAttrNumber ( itemtype => l_itemtype,
1659: itemkey => l_itemkey,
1660: aname => 'RESP_ID',
1661: avalue => l_responsibility_id );
1662:

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

1659: itemkey => l_itemkey,
1660: aname => 'RESP_ID',
1661: avalue => l_responsibility_id );
1662:
1663: wf_engine.SetItemAttrNumber ( itemtype => l_itemtype,
1664: itemkey => l_itemkey,
1665: aname => 'APPLICATION_ID',
1666: avalue => l_application_id );
1667:

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

1664: itemkey => l_itemkey,
1665: aname => 'APPLICATION_ID',
1666: avalue => l_application_id );
1667:
1668: wf_engine.SetItemAttrNumber ( itemtype => l_ItemType,
1669: itemkey => l_itemkey,
1670: aname => 'DOCUMENT_ID',
1671: avalue => p_doc_header_id );
1672:

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

1669: itemkey => l_itemkey,
1670: aname => 'DOCUMENT_ID',
1671: avalue => p_doc_header_id );
1672:
1673: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
1674: itemkey => l_itemkey,
1675: aname => 'DOCUMENT_NUMBER',
1676: avalue => p_doc_number );
1677:

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

1674: itemkey => l_itemkey,
1675: aname => 'DOCUMENT_NUMBER',
1676: avalue => p_doc_number );
1677:
1678: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
1679: itemkey => l_itemkey,
1680: aname => 'DOCUMENT_TYPE',
1681: avalue => p_doc_type );
1682:

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

1679: itemkey => l_itemkey,
1680: aname => 'DOCUMENT_TYPE',
1681: avalue => p_doc_type );
1682:
1683: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
1684: itemkey => l_itemkey,
1685: aname => 'DOCUMENT_SUBTYPE',
1686: avalue => p_doc_subtype );
1687:

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

1684: itemkey => l_itemkey,
1685: aname => 'DOCUMENT_SUBTYPE',
1686: avalue => p_doc_subtype );
1687:
1688: wf_engine.SetItemAttrNumber ( itemtype => l_ItemType,
1689: itemkey => l_itemkey,
1690: aname => 'RELEASE_REV_NUM',
1691: avalue => p_release_num );
1692:

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

1690: aname => 'RELEASE_REV_NUM',
1691: avalue => p_release_num );
1692:
1693:
1694: wf_engine.SetItemAttrNumber ( itemtype => l_ItemType,
1695: itemkey => l_itemkey,
1696: aname => 'AGENT_ID',
1697: avalue => p_agent_id );
1698:

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

1708: PO_REQAPPROVAL_INIT1.Get_User_Name (p_agent_id,
1709: l_agent_username,
1710: l_agent_disp_name);
1711:
1712: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
1713: itemkey => l_itemkey,
1714: aname => 'AGENT_USER_NAME',
1715: avalue => l_agent_username );
1716:

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

1713: itemkey => l_itemkey,
1714: aname => 'AGENT_USER_NAME',
1715: avalue => l_agent_username );
1716:
1717: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
1718: itemkey => l_itemkey,
1719: aname => 'AGENT_DISP_NAME',
1720: avalue => l_agent_disp_name );
1721:

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

1721:
1722: -- dbms_output.put_line ('Start_Approval_Reminder, agent username '|| l_agent_username);
1723:
1724: -- dbms_output.put_line ('Start_Approval_Reminder, agent dispname '|| l_agent_disp_name);
1725: wf_engine.StartProcess ( ItemType => l_ItemType,
1726: ItemKey => l_ItemKey );
1727:
1728: l_progress := 'PO_APPROVAL_REMINDER_SV.Start_Approval_Reminder: 900 ';
1729: IF (g_po_wf_debug = 'Y') THEN

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

1808: -- dbms_output.put_line ('Set doc type ' ||ItemKey);
1809:
1810:
1811: l_doc_header_id :=
1812: wf_engine.GetItemAttrNumber ( itemtype => ItemType,
1813: itemkey => itemkey,
1814: aname => 'DOCUMENT_ID');
1815:
1816: l_doc_type :=

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

1813: itemkey => itemkey,
1814: aname => 'DOCUMENT_ID');
1815:
1816: l_doc_type :=
1817: wf_engine.GetItemAttrText ( itemtype => itemtype,
1818: itemkey => itemkey,
1819: aname => 'DOCUMENT_TYPE');
1820: l_doc_subtype :=
1821: wf_engine.GetItemAttrText ( itemtype => itemtype,

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

1817: wf_engine.GetItemAttrText ( itemtype => itemtype,
1818: itemkey => itemkey,
1819: aname => 'DOCUMENT_TYPE');
1820: l_doc_subtype :=
1821: wf_engine.GetItemAttrText ( itemtype => itemtype,
1822: itemkey => itemkey,
1823: aname => 'DOCUMENT_SUBTYPE');
1824:
1825:

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

1855: l_doc_type_name,
1856: l_doc_type_lookup_code);
1857:
1858:
1859: wf_engine.SetItemAttrText ( itemtype => itemType,
1860: itemkey => itemkey,
1861: aname => 'DOC_TYPE_DISP' ,
1862: avalue => l_doc_type_name);
1863:

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

1869: fnd_message.set_name ('PO','PO_WF_NOTIF_REQUIRES_APPROVAL');
1870:
1871: l_error_msg := fnd_message.get;
1872:
1873: wf_engine.SetItemAttrText ( itemtype => itemType,
1874: itemkey => itemkey,
1875: aname => 'NEVER_APPROVED_MSG' ,
1876: avalue => l_error_msg);
1877:

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

1879: -- Get requires approval message
1880: fnd_message.set_name ('PO','PO_WF_NOTIF_REQUIRES_APPROVAL');
1881: l_error_msg := fnd_message.get;
1882:
1883: wf_engine.SetItemAttrText ( itemtype => itemType,
1884: itemkey => itemkey,
1885: aname => 'REQUIRES_APPROVAL_MSG' ,
1886: avalue => l_error_msg);
1887:

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

1898: -- Get requisition returned approval message
1899: fnd_message.set_name ('PO','PO_WF_NOTIF_RETURNED');
1900: l_error_msg := fnd_message.get;
1901:
1902: wf_engine.SetItemAttrText ( itemtype => itemType,
1903: itemkey => itemkey,
1904: aname => 'REQUISITION_RETURNED_MSG' ,
1905: avalue => l_error_msg);
1906:

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

1909: -- Get requisition returned approval message
1910: fnd_message.set_name ('PO','PO_WF_NOTIF_REJECTED');
1911: l_error_msg := fnd_message.get;
1912:
1913: wf_engine.SetItemAttrText ( itemtype => itemType,
1914: itemkey => itemkey,
1915: aname => 'REQUISITION_REJECTED_MSG' ,
1916: avalue => l_error_msg);
1917: end if;

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

1924: -- check if l_doc_type is REQUISITION.
1925:
1926: /*if NVL(l_req_status, 'INCOMPLETE') in ('RETURNED','REJECTED') then
1927:
1928: wf_engine.SetItemAttrText ( itemtype => itemType,
1929: itemkey => itemkey,
1930: aname => 'NEVER_APPROVED_MSG' ,
1931: avalue => '');
1932:

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

1929: itemkey => itemkey,
1930: aname => 'NEVER_APPROVED_MSG' ,
1931: avalue => '');
1932:
1933: wf_engine.SetItemAttrText ( itemtype => itemType,
1934: itemkey => itemkey,
1935: aname => 'REQUIRES_APPROVAL_MSG' ,
1936: avalue => '');
1937: end if;*/

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

1942: -- Set wrong forward to message to NULL until user enters
1943: -- an invalid forward to ID
1944: l_error_msg := '';
1945:
1946: wf_engine.SetItemAttrText ( itemtype => itemType,
1947: itemkey => itemkey,
1948: aname => 'WRONG_FORWARD_TO_MSG' ,
1949: avalue => '');
1950:

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

1980: l_acceptance_past_due := 'Y';
1981:
1982: END IF;
1983:
1984: wf_engine.SetItemAttrDate ( itemtype => ItemType,
1985: itemkey => itemkey,
1986: aname => 'ACCEPTANCE_DUE_DATE',
1987: avalue => l_acceptance_due_date );
1988:

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

1986: aname => 'ACCEPTANCE_DUE_DATE',
1987: avalue => l_acceptance_due_date );
1988:
1989:
1990: wf_engine.SetItemAttrText ( itemtype => itemtype,
1991: itemkey => itemkey,
1992: aname => 'ACCEPTANCE_PAST_DUE',
1993: avalue => l_acceptance_past_due );
1994:

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

2021: l_quote_type_lookup_code,
2022: l_quote_type_disp);
2023:
2024:
2025: wf_engine.SetItemAttrDate ( itemtype => ItemType,
2026: itemkey => itemkey,
2027: aname => 'RFQ_REPLY_DATE',
2028: avalue => l_rfq_reply_date );
2029:

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

2027: aname => 'RFQ_REPLY_DATE',
2028: avalue => l_rfq_reply_date );
2029:
2030:
2031: wf_engine.SetItemAttrDate ( itemtype => ItemType,
2032: itemkey => itemkey,
2033: aname => 'RFQ_CLOSE_DATE',
2034: avalue => l_RFQ_close_date );
2035:

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

2033: aname => 'RFQ_CLOSE_DATE',
2034: avalue => l_RFQ_close_date );
2035:
2036:
2037: wf_engine.SetItemAttrDate ( itemtype => ItemType,
2038: itemkey => itemkey,
2039: aname => 'QUOTE_END_DATE_ACTIVE',
2040: avalue => l_quote_end_date_active );
2041:

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

2039: aname => 'QUOTE_END_DATE_ACTIVE',
2040: avalue => l_quote_end_date_active );
2041:
2042:
2043: wf_engine.SetItemAttrNumber ( itemtype => ItemType,
2044: itemkey => itemkey,
2045: aname => 'QUOTE_WARNING_DELAY',
2046: avalue => l_quote_warning_delay );
2047:

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

2044: itemkey => itemkey,
2045: aname => 'QUOTE_WARNING_DELAY',
2046: avalue => l_quote_warning_delay );
2047:
2048: wf_engine.SetItemAttrText ( itemtype => ItemType,
2049: itemkey => Itemkey,
2050: aname => 'RFQ_STATUS',
2051: avalue => l_status_lookup_code );
2052:

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

2049: itemkey => Itemkey,
2050: aname => 'RFQ_STATUS',
2051: avalue => l_status_lookup_code );
2052:
2053: wf_engine.SetItemAttrText ( itemtype => ItemType,
2054: itemkey => Itemkey,
2055: aname => 'QUOTE_STATUS',
2056: avalue => l_status_lookup_code );
2057:

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

2055: aname => 'QUOTE_STATUS',
2056: avalue => l_status_lookup_code );
2057:
2058:
2059: wf_engine.SetItemAttrText ( itemtype => ItemType,
2060: itemkey => Itemkey,
2061: aname => 'QUOTE_TYPE_DISP',
2062: avalue => l_quote_type_disp );
2063:

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

2163: -- user context is lost. So need pass responsibility_id and
2164: -- application_id through workflow attributes.
2165:
2166: l_ResponsibilityID :=
2167: wf_engine.GetItemAttrNumber (itemtype => itemtype,
2168: itemkey => itemkey,
2169: aname => 'RESP_ID');
2170:
2171: l_ApplicationID :=

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

2168: itemkey => itemkey,
2169: aname => 'RESP_ID');
2170:
2171: l_ApplicationID :=
2172: wf_engine.GetItemAttrNumber (itemtype => itemtype,
2173: itemkey => itemkey,
2174: aname => 'APPLICATION_ID');
2175:
2176: l_DocumentTypeCode :=

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

2173: itemkey => itemkey,
2174: aname => 'APPLICATION_ID');
2175:
2176: l_DocumentTypeCode :=
2177: wf_engine.GetItemAttrText ( itemtype => itemtype,
2178: itemkey => itemkey,
2179: aname => 'DOCUMENT_TYPE');
2180:
2181: l_DocumentSubtype :=

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

2178: itemkey => itemkey,
2179: aname => 'DOCUMENT_TYPE');
2180:
2181: l_DocumentSubtype :=
2182: wf_engine.GetItemAttrText ( itemtype => itemtype,
2183: itemkey => itemkey,
2184: aname => 'DOCUMENT_SUBTYPE');
2185: l_DocumentNumber :=
2186: wf_engine.GetItemAttrText ( itemtype => itemtype,

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

2182: wf_engine.GetItemAttrText ( itemtype => itemtype,
2183: itemkey => itemkey,
2184: aname => 'DOCUMENT_SUBTYPE');
2185: l_DocumentNumber :=
2186: wf_engine.GetItemAttrText ( itemtype => itemtype,
2187: itemkey => itemkey,
2188: aname => 'DOCUMENT_NUMBER');
2189: l_DocumentID :=
2190: wf_engine.GetItemAttrNumber ( itemtype => ItemType,

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

2186: wf_engine.GetItemAttrText ( itemtype => itemtype,
2187: itemkey => itemkey,
2188: aname => 'DOCUMENT_NUMBER');
2189: l_DocumentID :=
2190: wf_engine.GetItemAttrNumber ( itemtype => ItemType,
2191: itemkey => itemkey,
2192: aname => 'DOCUMENT_ID');
2193:
2194:

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

2192: aname => 'DOCUMENT_ID');
2193:
2194:
2195: l_PreparerID :=
2196: wf_engine.GetItemAttrNumber ( itemtype => ItemType,
2197: itemkey => itemkey,
2198: aname => 'AGENT_ID');
2199:
2200:

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

2198: aname => 'AGENT_ID');
2199:
2200:
2201: l_forwardToID :=
2202: wf_engine.GetItemAttrNumber ( itemtype => ItemType,
2203: itemkey => itemkey,
2204: aname => 'FORWARD_TO_ID');
2205:
2206: l_forwardFromID :=

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

2203: itemkey => itemkey,
2204: aname => 'FORWARD_TO_ID');
2205:
2206: l_forwardFromID :=
2207: wf_engine.GetItemAttrNumber ( itemtype => ItemType,
2208: itemkey => itemkey,
2209: aname => 'FORWARD_FROM_ID');
2210:
2211:

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

2209: aname => 'FORWARD_FROM_ID');
2210:
2211:
2212: l_Note :=
2213: wf_engine.GetItemAttrText ( itemtype => itemtype,
2214: itemkey => itemkey,
2215: aname => 'NOTE');
2216:
2217:

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

2216:
2217:
2218: /*** DEBUG
2219: l_DefaultApprovalPathID :=
2220: wf_engine.GetItemAttrNumber ( itemtype => ItemType,
2221: itemkey => itemkey,
2222: aname => 'DEFAULT_APPROVAL_PATH_ID');
2223: ***/
2224:

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

2493:
2494: -- bug 852056: Need to create process here, and then set
2495: -- attributes: USER_ID, RESPONSIBILITY_ID, and APPLICATION_ID
2496: -- also need to initialize fnd_global
2497: wf_engine.CreateProcess ( ItemType => l_ItemType,
2498: ItemKey => l_ItemKey,
2499: process => l_WorkflowProcess);
2500:
2501: wf_engine.SetItemAttrNumber ( ItemType => l_ItemType,

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

2497: wf_engine.CreateProcess ( ItemType => l_ItemType,
2498: ItemKey => l_ItemKey,
2499: process => l_WorkflowProcess);
2500:
2501: wf_engine.SetItemAttrNumber ( ItemType => l_ItemType,
2502: ItemKey => l_ItemKey,
2503: aname => 'USER_ID',
2504: avalue => l_user_id);
2505:

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

2502: ItemKey => l_ItemKey,
2503: aname => 'USER_ID',
2504: avalue => l_user_id);
2505:
2506: wf_engine.SetItemAttrNumber ( ItemType => l_ItemType,
2507: ItemKey => l_ItemKey,
2508: aname => 'RESPONSIBILITY_ID',
2509: avalue => p_ResponsibilityID);
2510:

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

2507: ItemKey => l_ItemKey,
2508: aname => 'RESPONSIBILITY_ID',
2509: avalue => p_ResponsibilityID);
2510:
2511: wf_engine.SetItemAttrNumber ( ItemType => l_ItemType,
2512: ItemKey => l_ItemKey,
2513: aname => 'APPLICATION_ID',
2514: avalue => p_ApplicationID);
2515:

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

2604:
2605:
2606: -- Do nothing in cancel or timeout mode
2607: --
2608: if (funcmode <> wf_engine.eng_run) then
2609:
2610: resultout := wf_engine.eng_null;
2611: return;
2612:

Line 2610: resultout := wf_engine.eng_null;

2606: -- Do nothing in cancel or timeout mode
2607: --
2608: if (funcmode <> wf_engine.eng_run) then
2609:
2610: resultout := wf_engine.eng_null;
2611: return;
2612:
2613: end if;
2614:

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

2618: ** Then set the Forward-To to the one the user entered in the response.
2619: */
2620: /* NOTE: We take the value entered by the user and set it to ALL CAPITAL LETTERS!!!
2621: */
2622: l_forward_to_username_response := wf_engine.GetItemAttrText (itemtype => itemtype,
2623: itemkey => itemkey,
2624: aname => 'FORWARD_TO_USERNAME_RESPONSE');
2625:
2626: l_forward_to_username_response := UPPER(l_forward_to_username_response);

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

2634: IF l_forward_to_username_response is NULL THEN
2635:
2636: -- NULL is a valid case in the remainder process
2637: --
2638: resultout := wf_engine.eng_completed || ':' || 'Y';
2639: --
2640:
2641: ELSIF PO_REQAPPROVAL_FINDAPPRV1.CheckForwardTo(l_forward_to_username_response,
2642: x_user_id) = 'Y' THEN

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

2644: /* The FORWARD-FROM is now the old FORWARD-TO and the NEW FORWARD-TO is set
2645: ** to what the user entered in the response
2646: */
2647:
2648: l_forward_to_username:= wf_engine.GetItemAttrText (itemtype => itemtype,
2649: itemkey => itemkey,
2650: aname => 'FORWARD_TO_USERNAME');
2651:
2652: l_forward_to_username_disp:= wf_engine.GetItemAttrText (itemtype => itemtype,

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

2648: l_forward_to_username:= wf_engine.GetItemAttrText (itemtype => itemtype,
2649: itemkey => itemkey,
2650: aname => 'FORWARD_TO_USERNAME');
2651:
2652: l_forward_to_username_disp:= wf_engine.GetItemAttrText (itemtype => itemtype,
2653: itemkey => itemkey,
2654: aname => 'FORWARD_TO_DISPLAY_NAME');
2655:
2656: l_forward_to_id:= wf_engine.GetItemAttrNumber (itemtype => itemtype,

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

2652: l_forward_to_username_disp:= wf_engine.GetItemAttrText (itemtype => itemtype,
2653: itemkey => itemkey,
2654: aname => 'FORWARD_TO_DISPLAY_NAME');
2655:
2656: l_forward_to_id:= wf_engine.GetItemAttrNumber (itemtype => itemtype,
2657: itemkey => itemkey,
2658: aname => 'FORWARD_TO_ID');
2659: /* Set the FORWARD_FROM */
2660: wf_engine.SetItemAttrNumber ( itemtype => itemtype,

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

2656: l_forward_to_id:= wf_engine.GetItemAttrNumber (itemtype => itemtype,
2657: itemkey => itemkey,
2658: aname => 'FORWARD_TO_ID');
2659: /* Set the FORWARD_FROM */
2660: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
2661: itemkey => itemkey,
2662: aname => 'FORWARD_FROM_ID',
2663: avalue => l_forward_to_id);
2664:

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

2661: itemkey => itemkey,
2662: aname => 'FORWARD_FROM_ID',
2663: avalue => l_forward_to_id);
2664:
2665: wf_engine.SetItemAttrText ( itemtype => itemtype,
2666: itemkey => itemkey,
2667: aname => 'FORWARD_FROM_USER_NAME',
2668: avalue => l_forward_to_username);
2669:

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

2666: itemkey => itemkey,
2667: aname => 'FORWARD_FROM_USER_NAME',
2668: avalue => l_forward_to_username);
2669:
2670: wf_engine.SetItemAttrText ( itemtype => itemtype,
2671: itemkey => itemkey,
2672: aname => 'FORWARD_FROM_DISP_NAME',
2673: avalue => l_forward_to_username_disp);
2674:

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

2673: avalue => l_forward_to_username_disp);
2674:
2675: /* Set the FORWARD-TO */
2676:
2677: wf_engine.SetItemAttrText ( itemtype => itemtype,
2678: itemkey => itemkey,
2679: aname => 'FORWARD_TO_USERNAME',
2680: avalue => l_forward_to_username_response);
2681:

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

2678: itemkey => itemkey,
2679: aname => 'FORWARD_TO_USERNAME',
2680: avalue => l_forward_to_username_response);
2681:
2682: wf_engine.SetItemAttrNumber ( itemtype => itemType,
2683: itemkey => itemkey,
2684: aname => 'FORWARD_TO_ID',
2685: avalue => x_user_id);
2686:

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

2684: aname => 'FORWARD_TO_ID',
2685: avalue => x_user_id);
2686:
2687: /* Get the Display name for the user from the WF Directory */
2688: wf_engine.SetItemAttrText ( itemtype => itemtype,
2689: itemkey => itemkey,
2690: aname => 'FORWARD_TO_DISPLAY_NAME',
2691: avalue =>
2692: wf_directory.GetRoleDisplayName(l_forward_to_username_response));

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

2691: avalue =>
2692: wf_directory.GetRoleDisplayName(l_forward_to_username_response));
2693:
2694: /* Reset the FORWARD_TO_USERNAME_RESPONSE attribute */
2695: wf_engine.SetItemAttrText (itemtype => itemtype,
2696: itemkey => itemkey,
2697: aname => 'FORWARD_TO_USERNAME_RESPONSE',
2698: avalue => NULL);
2699:

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

2705: */
2706: fnd_message.set_name ('PO','PO_WF_NOTIF_REQUIRES_APPROVAL');
2707: l_error_msg := fnd_message.get;
2708:
2709: wf_engine.SetItemAttrText ( itemtype => itemType,
2710: itemkey => itemkey,
2711: aname => 'REQUIRES_APPROVAL_MSG' ,
2712: avalue => l_error_msg);
2713:

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

2711: aname => 'REQUIRES_APPROVAL_MSG' ,
2712: avalue => l_error_msg);
2713:
2714:
2715: wf_engine.SetItemAttrText ( itemtype => itemtype,
2716: itemkey => itemkey,
2717: aname => 'WRONG_FORWARD_TO_MSG',
2718: avalue => NULL);
2719:

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

2717: aname => 'WRONG_FORWARD_TO_MSG',
2718: avalue => NULL);
2719:
2720: --
2721: resultout := wf_engine.eng_completed || ':' || 'Y';
2722: --
2723:
2724: ELSE
2725:

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

2734: */
2735: fnd_message.set_name ('PO','PO_WF_NOTIF_INVALID_FORWARD');
2736: l_error_msg := fnd_message.get;
2737:
2738: wf_engine.SetItemAttrText ( itemtype => itemType,
2739: itemkey => itemkey,
2740: aname => 'REQUIRES_APPROVAL_MSG' ,
2741: avalue => '');
2742:

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

2739: itemkey => itemkey,
2740: aname => 'REQUIRES_APPROVAL_MSG' ,
2741: avalue => '');
2742:
2743: wf_engine.SetItemAttrText ( itemtype => itemType,
2744: itemkey => itemkey,
2745: aname => 'WRONG_FORWARD_TO_MSG' ,
2746: avalue => l_error_msg);
2747:

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

2745: aname => 'WRONG_FORWARD_TO_MSG' ,
2746: avalue => l_error_msg);
2747:
2748: --
2749: resultout := wf_engine.eng_completed || ':' || 'N';
2750: --
2751:
2752: END IF;
2753:

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

2831: to_char(p_DocumentId) ||'-';
2832:
2833: For rec in cand_active_wf(l_itemkey) LOOP
2834: if (po_approval_reminder_sv.is_active('APVRMDER',rec.item_key)) then
2835: WF_Engine.AbortProcess('APVRMDER',rec.item_key);
2836: end if;
2837: End Loop;
2838:
2839: elsif ((p_DocumentTypeCode = 'BLANKET') or (p_DocumentTypeCode = 'CONTRACT')) then

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

2877: to_char(p_DocumentId) ||'-'||
2878: to_char(l_agent_id);
2879: end if;
2880: if (po_approval_reminder_sv.is_active('APVRMDER',l_itemkey)) then
2881: WF_Engine.AbortProcess('APVRMDER',l_itemkey);
2882: end if;
2883:
2884:
2885:

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

2902: to_char(p_DocumentId) ||'-'||
2903: to_char(l_agent_id);
2904:
2905: if (po_approval_reminder_sv.is_active('APVRMDER',l_itemkey)) then
2906: WF_Engine.AbortProcess('APVRMDER',l_itemkey);
2907: end if;
2908:
2909: elsif (p_DocumentTypeCode = 'SCHEDULED') then
2910:

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

2925: to_char(p_DocumentId) ||'-'||
2926: to_char(l_agent_id);
2927:
2928: if (po_approval_reminder_sv.is_active('APVRMDER',l_itemkey)) then
2929: WF_Engine.AbortProcess('APVRMDER',l_itemkey);
2930: end if;
2931: elsif (p_DocumentTypeCode = 'PO_ACCEPTANCE') then
2932:
2933: x_progress := 'PO_APPROVAL_REMINDER_SV.cancel_notif-006';

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

2947: to_char(p_DocumentId);
2948:
2949:
2950: if (po_approval_reminder_sv.is_active('APVRMDER',l_itemkey)) then
2951: WF_Engine.AbortProcess('APVRMDER',l_itemkey);
2952: end if;
2953:
2954: -- Bug 3593182: Removed the item exists condition before
2955: -- the purge as purge only purges existing items

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

2986: to_char(p_DocumentId);
2987:
2988:
2989: if (po_approval_reminder_sv.is_active('APVRMDER',l_itemkey)) then
2990: WF_Engine.AbortProcess('APVRMDER',l_itemkey);
2991: end if;
2992:
2993: -- Bug 3593182: Removed the item exists condition before
2994: -- the purge as purge only purges existing items

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

3009: l_itemkey := l_doc_type ||
3010: to_char(p_DocumentId);
3011:
3012: if (po_approval_reminder_sv.is_active('APVRMDER',l_itemkey)) then
3013: WF_Engine.AbortProcess('APVRMDER',l_itemkey);
3014: end if;
3015:
3016:
3017: -- Bug 3593182: Removed the item exists condition before

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

3032: l_itemkey := l_doc_type ||
3033: to_char(p_DocumentId);
3034:
3035: if (po_approval_reminder_sv.is_active('APVRMDER',l_itemkey)) then
3036: WF_Engine.AbortProcess('APVRMDER',l_itemkey);
3037: end if;
3038:
3039:
3040: -- Bug 3593182: Removed the item exists condition before

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

3077: --a union all between wf_item_activity_statuses and
3078: --wf_item_activity_statuses_h(history). A new record
3079: --gets inserted into history table when the wf process
3080: --raises an error.
3081: --WF Team has provided an api wf_engine.itemstatus to check the
3082: --active status of any given activity. We need to call this
3083: --instead of query the wf_item_activity_statuses_v view directly.
3084: BEGIN
3085: wf_engine.itemstatus (itemtype => x_item_type,

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

3081: --WF Team has provided an api wf_engine.itemstatus to check the
3082: --active status of any given activity. We need to call this
3083: --instead of query the wf_item_activity_statuses_v view directly.
3084: BEGIN
3085: wf_engine.itemstatus (itemtype => x_item_type,
3086: itemkey => x_item_key,
3087: status => x_act_status,
3088: RESULT => x_result
3089: );

Line 3118: WF_Engine.AbortProcess(item_type,item_key);

3114:
3115: BEGIN
3116:
3117: if (po_approval_reminder_sv.is_active(item_type,item_key)) then
3118: WF_Engine.AbortProcess(item_type,item_key);
3119: end if;
3120:
3121: END stop_process;
3122:

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

3445: p_Item_end_date => l_item_end_date);
3446: IF (l_item_exist = 'Y') THEN
3447: -- Abort the process if it is still active.
3448: IF (l_item_end_date IS NULL) THEN
3449: WF_ENGINE.AbortProcess(g_reminder_item_type, l_item_key );
3450: END IF;
3451:
3452: -- Purge the process so we can re-use the item key.
3453: --

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

3460:
3461: END IF; -- l_item_exist
3462:
3463: -- Create a Reminder workflow process for this PO line.
3464: wf_engine.CreateProcess ( ItemType => g_reminder_item_type,
3465: ItemKey => l_item_key,
3466: Process => 'PO_LINE_REMINDER' );
3467:
3468: -- Set some workflow item attributes.

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

3567: END IF; -- l_req_header_id
3568: -- Bug 3441007 END
3569:
3570: -- Start the Reminder workflow process for this PO line.
3571: wf_engine.StartProcess ( ItemType => g_reminder_item_type,
3572: ItemKey => l_item_key );
3573:
3574: EXCEPTION
3575: WHEN OTHERS THEN

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

3621: ) IS
3622: l_line_reminder_type VARCHAR2(20);
3623: BEGIN
3624: -- Do nothing if the Workflow mode is Cancel or Timeout.
3625: if (funcmode <> wf_engine.eng_run) then
3626: resultout := wf_engine.eng_null;
3627: return;
3628: end if;
3629:

Line 3626: resultout := wf_engine.eng_null;

3622: l_line_reminder_type VARCHAR2(20);
3623: BEGIN
3624: -- Do nothing if the Workflow mode is Cancel or Timeout.
3625: if (funcmode <> wf_engine.eng_run) then
3626: resultout := wf_engine.eng_null;
3627: return;
3628: end if;
3629:
3630: l_line_reminder_type :=

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

3630: l_line_reminder_type :=
3631: po_wf_util_pkg.GetItemAttrText (itemtype => itemtype,
3632: itemkey => itemkey,
3633: aname => 'PO_LINE_REMINDER_TYPE');
3634: resultout := wf_engine.eng_completed || ':' || l_line_reminder_type;
3635:
3636: EXCEPTION
3637: WHEN OTHERS THEN
3638: wf_core.context( 'PO_APPROVAL_REMINDER_SV',