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_WF_PO_NOTIFICATION dependencies on WF_ENGINE

Line 68: l_document_id := wf_engine.GetItemAttrNumber

64:
65: l_item_type := substr(document_id, 1, instr(document_id, ':') - 1);
66: l_item_key := substr(document_id, instr(document_id, ':') + 1, length(document_id) - 2);
67:
68: l_document_id := wf_engine.GetItemAttrNumber
69: (itemtype => l_item_type,
70: itemkey => l_item_key,
71: aname => 'DOCUMENT_ID');
72:

Line 73: l_org_id := wf_engine.GetItemAttrNumber

69: (itemtype => l_item_type,
70: itemkey => l_item_key,
71: aname => 'DOCUMENT_ID');
72:
73: l_org_id := wf_engine.GetItemAttrNumber
74: (itemtype => l_item_type,
75: itemkey => l_item_key,
76: aname => 'ORG_ID');
77:

Line 81: l_currency_code := wf_engine.GetItemAttrText

77:
78: PO_MOAC_UTILS_PVT.set_org_context(l_org_id) ; --
79:
80:
81: l_currency_code := wf_engine.GetItemAttrText
82: (itemtype => l_item_type,
83: itemkey => l_item_key,
84: aname => 'FUNCTIONAL_CURRENCY');
85:

Line 86: l_po_amount := wf_engine.GetItemAttrText

82: (itemtype => l_item_type,
83: itemkey => l_item_key,
84: aname => 'FUNCTIONAL_CURRENCY');
85:
86: l_po_amount := wf_engine.GetItemAttrText
87: (itemtype => l_item_type,
88: itemkey => l_item_key,
89: aname => 'PO_AMOUNT_DSP');
90:

Line 91: l_tax_amount := wf_engine.GetItemAttrText

87: (itemtype => l_item_type,
88: itemkey => l_item_key,
89: aname => 'PO_AMOUNT_DSP');
90:
91: l_tax_amount := wf_engine.GetItemAttrText
92: (itemtype => l_item_type,
93: itemkey => l_item_key,
94: aname => 'TAX_AMOUNT_DSP');
95: -- bug 12396408

Line 96: l_po_amount_numeric := wf_engine.GetItemAttrNumber

92: (itemtype => l_item_type,
93: itemkey => l_item_key,
94: aname => 'TAX_AMOUNT_DSP');
95: -- bug 12396408
96: l_po_amount_numeric := wf_engine.GetItemAttrNumber
97: (itemtype => l_item_type,
98: itemkey => l_item_key,
99: aname => 'PO_AMOUNT_DSP_NUMERIC');
100:

Line 101: l_tax_amount_numeric := wf_engine.GetItemAttrNumber

97: (itemtype => l_item_type,
98: itemkey => l_item_key,
99: aname => 'PO_AMOUNT_DSP_NUMERIC');
100:
101: l_tax_amount_numeric := wf_engine.GetItemAttrNumber
102: (itemtype => l_item_type,
103: itemkey => l_item_key,
104: aname => 'TAX_AMOUNT_DSP_NUMERIC');
105:

Line 106: l_description := wf_engine.GetItemAttrText

102: (itemtype => l_item_type,
103: itemkey => l_item_key,
104: aname => 'TAX_AMOUNT_DSP_NUMERIC');
105:
106: l_description := wf_engine.GetItemAttrText
107: (itemtype => l_item_type,
108: itemkey => l_item_key,
109: aname => 'PO_DESCRIPTION');
110:

Line 111: l_forwarded_from := wf_engine.GetItemAttrText

107: (itemtype => l_item_type,
108: itemkey => l_item_key,
109: aname => 'PO_DESCRIPTION');
110:
111: l_forwarded_from := wf_engine.GetItemAttrText
112: (itemtype => l_item_type,
113: itemkey => l_item_key,
114: aname => 'FORWARD_FROM_DISP_NAME');
115:

Line 116: l_preparer := wf_engine.GetItemAttrText

112: (itemtype => l_item_type,
113: itemkey => l_item_key,
114: aname => 'FORWARD_FROM_DISP_NAME');
115:
116: l_preparer := wf_engine.GetItemAttrText
117: (itemtype => l_item_type,
118: itemkey => l_item_key,
119: aname => 'PREPARER_DISPLAY_NAME');
120:

Line 121: l_note := wf_engine.GetItemAttrText

117: (itemtype => l_item_type,
118: itemkey => l_item_key,
119: aname => 'PREPARER_DISPLAY_NAME');
120:
121: l_note := wf_engine.GetItemAttrText
122: (itemtype => l_item_type,
123: itemkey => l_item_key,
124: aname => 'NOTE');
125:

Line 166: lv_document_type := wf_engine.GetItemAttrText

162:
163: IF (lv_tax_region ='JAI')
164: THEN
165: --Get document type
166: lv_document_type := wf_engine.GetItemAttrText
167: ( itemtype => l_item_type
168: , itemkey => l_item_key
169: , aname => 'DOCUMENT_TYPE'
170: );

Line 574: l_document_id := wf_engine.GetItemAttrNumber (itemtype => l_item_type,

570: */
571:
572: PO_REQAPPROVAL_INIT1.Set_doc_mgr_context(l_item_type, l_item_key);
573:
574: l_document_id := wf_engine.GetItemAttrNumber (itemtype => l_item_type,
575: itemkey => l_item_key,
576: aname => 'DOCUMENT_ID');
577:
578: l_org_id := wf_engine.GetItemAttrNumber (itemtype => l_item_type,

Line 578: l_org_id := wf_engine.GetItemAttrNumber (itemtype => l_item_type,

574: l_document_id := wf_engine.GetItemAttrNumber (itemtype => l_item_type,
575: itemkey => l_item_key,
576: aname => 'DOCUMENT_ID');
577:
578: l_org_id := wf_engine.GetItemAttrNumber (itemtype => l_item_type,
579: itemkey => l_item_key,
580: aname => 'ORG_ID');
581:
582: l_document_type := wf_engine.GetItemAttrText (itemtype => l_item_type,

Line 582: l_document_type := wf_engine.GetItemAttrText (itemtype => l_item_type,

578: l_org_id := wf_engine.GetItemAttrNumber (itemtype => l_item_type,
579: itemkey => l_item_key,
580: aname => 'ORG_ID');
581:
582: l_document_type := wf_engine.GetItemAttrText (itemtype => l_item_type,
583: itemkey => l_item_key,
584: aname => 'DOCUMENT_TYPE');
585:
586: -- CLM Apprvl

Line 599: l_currency_code := wf_engine.GetItemAttrText

595: ** Desc: Use the functional currency of the PO for the precision of
596: ** line amounts.
597: */
598:
599: l_currency_code := wf_engine.GetItemAttrText
600: (itemtype => l_item_type,
601: itemkey => l_item_key,
602: aname => 'FUNCTIONAL_CURRENCY');
603:

Line 1330: l_document_id := wf_engine.GetItemAttrNumber

1326: l_item_type := substr(document_id, 1, instr(document_id, ':') - 1);
1327: l_item_key := substr(document_id, instr(document_id, ':') + 1,
1328: length(document_id) - 2);
1329:
1330: l_document_id := wf_engine.GetItemAttrNumber
1331: (itemtype => l_item_type,
1332: itemkey => l_item_key,
1333: aname => 'DOCUMENT_ID');
1334:

Line 1340: l_org_id := wf_engine.GetItemAttrNumber

1336: (itemtype => l_item_type,
1337: itemkey => l_item_key,
1338: aname => 'DRAFT_ID');
1339:
1340: l_org_id := wf_engine.GetItemAttrNumber
1341: (itemtype => l_item_type,
1342: itemkey => l_item_key,
1343: aname => 'ORG_ID');
1344:

Line 1345: l_doc_type_code := wf_engine.GetItemAttrText (itemtype => l_item_type,

1341: (itemtype => l_item_type,
1342: itemkey => l_item_key,
1343: aname => 'ORG_ID');
1344:
1345: l_doc_type_code := wf_engine.GetItemAttrText (itemtype => l_item_type,
1346: itemkey => l_item_key,
1347: aname => 'DOCUMENT_TYPE');
1348:
1349: -- CLM Apprvl, object sub type code for mods need to recorded as 'MODIFICATION' in po action history

Line 1352: l_draft_type := wf_engine.GetItemAttrText (itemtype => l_item_type,

1348:
1349: -- CLM Apprvl, object sub type code for mods need to recorded as 'MODIFICATION' in po action history
1350: if l_draft_id is not null and l_draft_id <> -1 then
1351: -- pAR Approval
1352: l_draft_type := wf_engine.GetItemAttrText (itemtype => l_item_type,
1353: itemkey => l_item_key,
1354: aname => 'DRAFT_TYPE');
1355: IF l_draft_type = 'PAR' THEN
1356: l_doc_sub_type_code := 'POST_AWARD_REQUEST';

Line 1361: l_doc_sub_type_code := wf_engine.GetItemAttrText (itemtype => l_item_type,

1357: ELSE
1358: l_doc_sub_type_code := 'MODIFICATION';
1359: END IF;
1360: else
1361: l_doc_sub_type_code := wf_engine.GetItemAttrText (itemtype => l_item_type,
1362: itemkey => l_item_key,
1363: aname => 'DOCUMENT_SUBTYPE');
1364: end if;
1365:

Line 1773: Wf_Directory.GetRoleOrigSysInfo(WF_ENGINE.CONTEXT_NEW_ROLE, l_origsys, l_new_recipient_id);

1769: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'l_draft_type : '||l_draft_type);
1770: END IF;
1771:
1772: IF (l_action <> 'NO ACTION') THEN
1773: Wf_Directory.GetRoleOrigSysInfo(WF_ENGINE.CONTEXT_NEW_ROLE, l_origsys, l_new_recipient_id);
1774:
1775: IF (g_po_wf_debug = 'Y') THEN
1776: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'l_origsys : '||l_origsys);
1777: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'l_new_recipient_id : '||l_new_recipient_id);

Line 1787: notification_id = WF_ENGINE.context_nid

1783: Decode(MORE_INFO_ROLE, NULL, RECIPIENT_ROLE,MORE_INFO_ROLE)
1784: INTO l_original_recipient, l_current_recipient_role
1785: FROM wf_notifications
1786: WHERE
1787: notification_id = WF_ENGINE.context_nid
1788: AND ( MORE_INFO_ROLE IS NOT NULL OR RECIPIENT_ROLE <> ORIGINAL_RECIPIENT );
1789:
1790: IF (g_po_wf_debug = 'Y') THEN
1791: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'l_original_recipient : '||l_original_recipient);

Line 1817: Wf_Directory.GetRoleOrigSysInfo(WF_ENGINE.CONTEXT_MORE_INFO_ROLE, l_origsys, l_current_recipient_id);

1813:
1814: l_progress := '002';
1815:
1816: IF (funcmode = 'ANSWER') THEN
1817: Wf_Directory.GetRoleOrigSysInfo(WF_ENGINE.CONTEXT_MORE_INFO_ROLE, l_origsys, l_current_recipient_id);
1818: ELSIF (funcmode = 'TIMEOUT') THEN
1819: Wf_Directory.GetRoleOrigSysInfo(l_current_recipient_role, l_origsys, l_current_recipient_id);
1820: ELSE
1821: Wf_Directory.GetRoleOrigSysInfo(WF_ENGINE.CONTEXT_RECIPIENT_ROLE, l_origsys, l_current_recipient_id);

Line 1821: Wf_Directory.GetRoleOrigSysInfo(WF_ENGINE.CONTEXT_RECIPIENT_ROLE, l_origsys, l_current_recipient_id);

1817: Wf_Directory.GetRoleOrigSysInfo(WF_ENGINE.CONTEXT_MORE_INFO_ROLE, l_origsys, l_current_recipient_id);
1818: ELSIF (funcmode = 'TIMEOUT') THEN
1819: Wf_Directory.GetRoleOrigSysInfo(l_current_recipient_role, l_origsys, l_current_recipient_id);
1820: ELSE
1821: Wf_Directory.GetRoleOrigSysInfo(WF_ENGINE.CONTEXT_RECIPIENT_ROLE, l_origsys, l_current_recipient_id);
1822: END IF;
1823:
1824: l_progress := '003';
1825:

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

1834:
1835: --15859236 start
1836: wf_directory.GetUserName(l_origsys, l_new_recipient_id, l_new_recipient_name, l_new_recipient_display_name);
1837:
1838: wf_engine.SetItemAttrNumber (itemtype => itemtype,
1839: itemkey => itemkey,
1840: aname => 'FORWARD_TO_ID',
1841: avalue => l_new_recipient_id);
1842:

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

1839: itemkey => itemkey,
1840: aname => 'FORWARD_TO_ID',
1841: avalue => l_new_recipient_id);
1842:
1843: wf_engine.SetItemAttrText (itemtype => itemtype,
1844: itemkey => itemkey,
1845: aname => 'FORWARD_TO_USERNAME',
1846: avalue => l_new_recipient_name);
1847:

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

1844: itemkey => itemkey,
1845: aname => 'FORWARD_TO_USERNAME',
1846: avalue => l_new_recipient_name);
1847:
1848: wf_engine.SetItemAttrText (itemtype => itemtype,
1849: itemkey => itemkey,
1850: aname => 'FORWARD_TO_DISPLAY_NAME',
1851: avalue => l_new_recipient_display_name);
1852: --15859236 end

Line 1857: p_note => WF_ENGINE.CONTEXT_USER_COMMENT,

1853:
1854: -- PAR Approval
1855: update_action_history(p_action_code => l_action,
1856: p_recipient_id => l_new_recipient_id,
1857: p_note => WF_ENGINE.CONTEXT_USER_COMMENT,
1858: p_po_header_id => l_po_header_id,
1859: p_current_id => l_current_recipient_id,
1860: p_doc_type => l_doc_type,
1861: p_doc_subtype => l_doc_sub_type,

Line 1874: resultout := wf_engine.eng_completed || ':' || wf_engine.eng_null;

1870:
1871: l_progress := '004';
1872:
1873: IF (funcmode <> 'TIMEOUT') THEN
1874: resultout := wf_engine.eng_completed || ':' || wf_engine.eng_null;
1875: END IF;
1876:
1877: return;
1878: end if;

Line 1884: l_nid := WF_ENGINE.context_nid;

1880: --End of code changes for inserting the delegate action in Action History. Bug 13951919 fix
1881:
1882: -- Context setting revamp
1883: if (funcmode = 'RESPOND') then
1884: l_nid := WF_ENGINE.context_nid;
1885:
1886: SELECT fu.USER_ID
1887: INTO l_responder_id
1888: FROM fnd_user fu,

Line 1915: l_orgid := wf_engine.GetItemAttrNumber (itemtype => itemtype,

1911: ** Desc: When responding from the E-mail notifications, the forward
1912: ** to failed as the org context was not set.
1913: */
1914:
1915: l_orgid := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1916: itemkey => itemkey,
1917: aname => 'ORG_ID');
1918: IF (g_po_wf_debug = 'Y') THEN
1919: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,

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

1949: /* The FORWARD-FROM is now the old FORWARD-TO and the NEW FORWARD-TO is set
1950: ** to what the user entered in the response
1951: */
1952:
1953: l_forward_to_username:= wf_engine.GetItemAttrText (itemtype => itemtype,
1954: itemkey => itemkey,
1955: aname => 'FORWARD_TO_USERNAME');
1956: IF (g_po_wf_debug = 'Y') THEN
1957: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,

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

1976: */
1977:
1978: IF l_forward_to_username is NOT NULL THEN
1979:
1980: l_forward_to_id:= wf_engine.GetItemAttrNumber (itemtype => itemtype,
1981: itemkey => itemkey,
1982: aname => 'FORWARD_TO_ID');
1983: ELSE /* get the approver name who took this action */
1984: l_forward_to_id:= wf_engine.GetItemAttrNumber (itemtype => itemtype,

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

1980: l_forward_to_id:= wf_engine.GetItemAttrNumber (itemtype => itemtype,
1981: itemkey => itemkey,
1982: aname => 'FORWARD_TO_ID');
1983: ELSE /* get the approver name who took this action */
1984: l_forward_to_id:= wf_engine.GetItemAttrNumber (itemtype => itemtype,
1985: itemkey => itemkey,
1986: aname => 'APPROVER_EMPID');
1987: END IF;
1988:

Line 1995: l_preparer_id := wf_engine.GetItemAttrText(itemtype => itemtype,

1991: /*
1992: ** Here, x_user_id is forwarded person user ID
1993: ** l_preparer_id is Document Preparer ID
1994: */
1995: l_preparer_id := wf_engine.GetItemAttrText(itemtype => itemtype,
1996: itemkey => itemkey,
1997: aname => 'PREPARER_ID');
1998: IF (g_po_wf_debug = 'Y') THEN
1999: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,

Line 2022: l_current_recipient_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

2018: END IF;
2019: ELSE
2020: --Forward-To person is invalid, set current employee id as recipient.
2021: l_is_forward_valid := FALSE;
2022: l_current_recipient_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2023: itemkey => itemkey,
2024: aname => 'APPROVER_EMPID');
2025: END IF;
2026: ELSE

Line 2029: Wf_Directory.GetRoleOrigSysInfo(WF_ENGINE.CONTEXT_RECIPIENT_ROLE, l_origsys, l_current_recipient_id);

2025: END IF;
2026: ELSE
2027: l_is_forward_valid := FALSE;
2028: --To record the real approver.
2029: Wf_Directory.GetRoleOrigSysInfo(WF_ENGINE.CONTEXT_RECIPIENT_ROLE, l_origsys, l_current_recipient_id);
2030:
2031: END IF;
2032:
2033: l_progress := '005 PO_WF_PO_NOTIFICATION.post_approval_notif';

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

2043: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2044: END IF;
2045:
2046: /* Set the FORWARD_FROM */
2047: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
2048: itemkey => itemkey,
2049: aname => 'FORWARD_FROM_ID',
2050: avalue => l_forward_to_id);
2051:

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

2051:
2052: /* Set the approver to the person who took the action on the notification,
2053: ** i.e. the old forward-to person
2054: */
2055: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
2056: itemkey => itemkey,
2057: aname => 'APPROVER_EMPID',
2058: avalue => l_forward_to_id);
2059:

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

2056: itemkey => itemkey,
2057: aname => 'APPROVER_EMPID',
2058: avalue => l_forward_to_id);
2059:
2060: wf_engine.SetItemAttrNumber ( itemtype => itemType,
2061: itemkey => itemkey,
2062: aname => 'FORWARD_TO_ID',
2063: avalue => x_user_id);
2064:

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

2068: */
2069: fnd_message.set_name ('PO','PO_WF_NOTIF_REQUIRES_APPROVAL');
2070: l_error_msg := fnd_message.get;
2071:
2072: wf_engine.SetItemAttrText ( itemtype => itemType,
2073: itemkey => itemkey,
2074: aname => 'REQUIRES_APPROVAL_MSG' ,
2075: avalue => l_error_msg);
2076:

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

2073: itemkey => itemkey,
2074: aname => 'REQUIRES_APPROVAL_MSG' ,
2075: avalue => l_error_msg);
2076:
2077: wf_engine.SetItemAttrText ( itemtype => itemType,
2078: itemkey => itemkey,
2079: aname => 'WRONG_FORWARD_TO_MSG' ,
2080: avalue => '');
2081:

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

2101: */
2102: fnd_message.set_name ('PO','PO_WF_NOTIF_INVALID_FORWARD');
2103: l_error_msg := fnd_message.get;
2104:
2105: wf_engine.SetItemAttrText ( itemtype => itemType,
2106: itemkey => itemkey,
2107: aname => 'REQUIRES_APPROVAL_MSG' ,
2108: avalue => '');
2109:

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

2106: itemkey => itemkey,
2107: aname => 'REQUIRES_APPROVAL_MSG' ,
2108: avalue => '');
2109:
2110: wf_engine.SetItemAttrText ( itemtype => itemType,
2111: itemkey => itemkey,
2112: aname => 'WRONG_FORWARD_TO_MSG' ,
2113: avalue => l_error_msg);
2114:

Line 2142: l_doc_type := wf_engine.GetItemAttrText (itemtype => itemtype,

2138: l_action := 'APPROVE AND FORWARD';
2139: END IF;
2140:
2141: /* Reset response note */
2142: l_doc_type := wf_engine.GetItemAttrText (itemtype => itemtype,
2143: itemkey => itemkey,
2144: aname => 'DOCUMENT_TYPE');
2145:
2146: IF (l_doc_type='PO' OR l_doc_type='PA' OR l_doc_type='RELEASE' ) THEN

Line 2160: l_po_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

2156: wf_notification.SetAttrText(l_nid, 'NOTE', l_note);
2157: wf_notification.SetAttrText(l_nid, 'NOTE_R', null);
2158: END IF;
2159:
2160: l_po_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
2161: itemkey => itemkey,
2162: aname => 'DOCUMENT_ID');
2163: l_doc_sub_type := wf_engine.GetItemAttrText(itemtype => itemtype,
2164: itemkey => itemkey,

Line 2163: l_doc_sub_type := wf_engine.GetItemAttrText(itemtype => itemtype,

2159:
2160: l_po_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
2161: itemkey => itemkey,
2162: aname => 'DOCUMENT_ID');
2163: l_doc_sub_type := wf_engine.GetItemAttrText(itemtype => itemtype,
2164: itemkey => itemkey,
2165: aname => 'DOCUMENT_SUBTYPE');
2166: l_approval_path_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2167: itemkey => itemkey,

Line 2166: l_approval_path_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

2162: aname => 'DOCUMENT_ID');
2163: l_doc_sub_type := wf_engine.GetItemAttrText(itemtype => itemtype,
2164: itemkey => itemkey,
2165: aname => 'DOCUMENT_SUBTYPE');
2166: l_approval_path_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2167: itemkey => itemkey,
2168: aname => 'APPROVAL_PATH_ID');
2169:
2170: l_draft_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

Line 2170: l_draft_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

2166: l_approval_path_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2167: itemkey => itemkey,
2168: aname => 'APPROVAL_PATH_ID');
2169:
2170: l_draft_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
2171: itemkey => itemkey,
2172: aname => 'DRAFT_ID');
2173: -- PAR Approval
2174: l_draft_type := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => itemtype,

Line 2208: if (wf_engine.preserved_context = TRUE) then

2204: END IF;
2205: --End of code changes.
2206:
2207: --
2208: if (wf_engine.preserved_context = TRUE) then
2209: l_preserved_ctx := 'TRUE';
2210: else
2211: l_preserved_ctx := 'FALSE';
2212: end if;

Line 2361: resultout := wf_engine.eng_completed || ':' || wf_engine.eng_null;

2357:
2358: -- Context setting revamp
2359:
2360:
2361: resultout := wf_engine.eng_completed || ':' || wf_engine.eng_null;
2362: l_progress := '040 returning from notif callback -respond mode';
2363: IF (g_po_wf_debug = 'Y') THEN
2364: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2365: END IF;

Line 2376: resultout := wf_engine.eng_completed;

2372:
2373: fnd_message.set_name('PO', 'PO_WF_NOTIF_NO_TRANSFER');
2374: app_exception.raise_exception;
2375:
2376: resultout := wf_engine.eng_completed;
2377: return;
2378:
2379: end if; -- end if for funcmode = 'TRANSFER'
2380:

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

2409: BEGIN
2410:
2411: -- Do nothing in cancel or timeout mode
2412: --
2413: if (funcmode <> wf_engine.eng_run) then
2414: resultout := wf_engine.eng_null;
2415: return;
2416: end if;
2417:

Line 2414: resultout := wf_engine.eng_null;

2410:
2411: -- Do nothing in cancel or timeout mode
2412: --
2413: if (funcmode <> wf_engine.eng_run) then
2414: resultout := wf_engine.eng_null;
2415: return;
2416: end if;
2417:
2418: l_progress := 'Get_po_user_msg_attribute:001: actid: ' || actid;

Line 2421: l_orgid := wf_engine.GetItemAttrNumber (itemtype => itemtype,

2417:
2418: l_progress := 'Get_po_user_msg_attribute:001: actid: ' || actid;
2419: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2420:
2421: l_orgid := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2422: itemkey => itemkey,
2423: aname => 'ORG_ID');
2424:
2425: IF l_orgid is NOT NULL THEN

Line 2432: l_user_name := wf_engine.GetActivityAttrText (itemtype => itemtype,

2428:
2429: l_progress := 'Get_po_user_msg_attribute:010: orgid: ' || l_orgid;
2430: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2431:
2432: l_user_name := wf_engine.GetActivityAttrText (itemtype => itemtype,
2433: itemkey => itemkey,
2434: actid => actid,
2435: aname => 'NTF_USER_NAME',
2436: ignore_notfound => TRUE);

Line 2448: l_notification_type := wf_engine.GetActivityAttrText (

2444:
2445: -- Bug 3668188: added the NTF_USER_ROLE Activity Attribute, which is
2446: -- a constant with value 'SUBMITTER' or 'APPROVER'. This distinguishes
2447: -- between the 3 different notification-functions that share this procedure.
2448: l_notification_type := wf_engine.GetActivityAttrText (
2449: itemtype => itemtype,
2450: itemkey => itemkey,
2451: actid => actid,
2452: aname => 'NTF_USER_ROLE',

Line 2558: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';

2554:
2555: l_progress := 'Get_po_approver_msg_attribute: 999';
2556: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2557:
2558: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
2559:
2560: EXCEPTION
2561: WHEN OTHERS THEN
2562: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);

Line 2872: l_authorization_status := wf_engine.GetItemAttrText

2868:
2869: -- Get the Authorization Status (e.g. 'PRE-APPROVED','APPROVED',
2870: -- 'INCOMPLETE', etc.) of the document.
2871: --
2872: l_authorization_status := wf_engine.GetItemAttrText
2873: ( itemtype => p_itemtype
2874: , itemkey => p_itemkey
2875: , aname => 'AUTHORIZATION_STATUS'
2876: );