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 PO_WF_DEBUG_PKG

Line 1379: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

1375: l_preserved_ctx := 'FALSE';
1376: end if;
1377: l_progress := 'notif callback preserved_ctx : '||l_preserved_ctx;
1378: IF (g_po_wf_debug = 'Y') THEN
1379: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1380: END IF;
1381: --
1382:
1383: --

Line 1386: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

1382:
1383: --
1384: l_progress := '010 notif callback -responder id : '||l_responder_id;
1385: IF (g_po_wf_debug = 'Y') THEN
1386: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1387: END IF;
1388: --
1389: --Bug 5389914
1390: --Fnd_Profile.Get('USER_ID',l_session_user_id);

Line 1414: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

1410: l_progress :='020 notification callback ses_userid: '||l_session_user_id
1411: ||' sess_resp_id '||l_session_resp_id||' sess_appl_id '
1412: ||l_session_appl_id;
1413: IF (g_po_wf_debug = 'Y') THEN
1414: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1415: END IF;
1416: --
1417:
1418: -- bug 4901406 : need to shift the setting of the preparer resp and appl id

Line 1434: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

1430: --
1431: l_progress := '030 notif callback prep resp_id:'||l_preparer_resp_id
1432: ||' prep appl id '||l_preparer_appl_id;
1433: IF (g_po_wf_debug = 'Y') THEN
1434: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1435: END IF;
1436: --
1437:
1438: -- bug 4901406

Line 1528: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

1524:
1525: resultout := wf_engine.eng_completed || ':' || wf_engine.eng_null;
1526: l_progress := '040 returning from notif callback -respond mode';
1527: IF (g_po_wf_debug = 'Y') THEN
1528: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1529: END IF;
1530: return;
1531: end if;
1532:

Line 1583: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

1579: return;
1580: end if;
1581:
1582: l_progress := 'Get_po_user_msg_attribute:001: actid: ' || actid;
1583: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1584:
1585: l_orgid := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1586: itemkey => itemkey,
1587: aname => 'ORG_ID');

Line 1594: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

1590: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
1591: END IF;
1592:
1593: l_progress := 'Get_po_user_msg_attribute:010: orgid: ' || l_orgid;
1594: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1595:
1596: l_user_name := wf_engine.GetActivityAttrText (itemtype => itemtype,
1597: itemkey => itemkey,
1598: actid => actid,

Line 1606: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

1602: PO_WF_PO_NOTIFICATION.GetDisplayValue(itemtype, itemkey, l_user_name);
1603:
1604:
1605: l_progress := 'Get_po_user_msg_attribute:015: username: ' || l_user_name;
1606: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1607:
1608:
1609: -- Bug 3668188: added the NTF_USER_ROLE Activity Attribute, which is
1610: -- a constant with value 'SUBMITTER' or 'APPROVER'. This distinguishes

Line 1621: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

1617: ignore_notfound => TRUE);
1618:
1619: l_progress := 'Get_po_user_msg_attribute:020: notif type: ' || l_notification_type;
1620: -- DEBUG
1621: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1622:
1623:
1624: -- Bug 3668188: Removed old logic from bug 3564727 and replaced it
1625: -- with a call to is_open_document_allowed, which has updated logic.

Line 1632: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

1628: , p_itemkey => itemkey
1629: , p_notification_type => l_notification_type)
1630: ) THEN
1631: l_progress := 'Get_po_approver_msg_attribute: 040: NULL open form';
1632: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1633:
1634: -- HTML Orders R12
1635: -- Set the URL and form attributes
1636: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType,

Line 1719: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

1715:
1716:
1717:
1718: l_progress := 'Get_po_approver_msg_attribute: 999';
1719: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1720:
1721: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
1722:
1723: EXCEPTION

Line 1779: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

1775:
1776: BEGIN
1777: l_progress := 'PO_WF_PO_NOTIFICATION.GetDisplayValue: 001, user name: '
1778: || username;
1779: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1780:
1781: if ((doctype is NULL) or (docsubtype is null)) then
1782: l_doc_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
1783: itemkey => itemkey,

Line 1813: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

1809: aname => 'DOCUMENT_ID');
1810:
1811: IF username is NULL THEN
1812: l_progress := 'PO_WF_PO_NOTIFICATION.GetDisplayValue: 050';
1813: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1814:
1815: IF l_doc_type = 'PA' AND l_doc_subtype IN ('BLANKET','CONTRACT') OR
1816: l_doc_type = 'PO' AND l_doc_subtype = 'STANDARD' then
1817:

Line 1826: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

1822: CLOSE c_lookup_value_doc;
1823: END IF;
1824: ELSE
1825: l_progress := 'PO_WF_PO_NOTIFICATION.GetDisplayValue: 060';
1826: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1827: WF_DIRECTORY.GETROLEINFO(
1828: username,
1829: l_display_name,
1830: l_email_address,

Line 1836: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

1832: l_language,
1833: l_territory);
1834: l_progress := 'PO_WF_PO_NOTIFICATION.GetDisplayValue: 080, language: '
1835: || l_language;
1836: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1837:
1838: IF l_doc_type = 'PA' AND l_doc_subtype IN ('BLANKET','CONTRACT') OR
1839: l_doc_type = 'PO' AND l_doc_subtype = 'STANDARD' then
1840:

Line 1851: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

1847: END IF; /* if username is null */
1848: --
1849: l_progress := 'PO_WF_PO_NOTIFICATION.GetDisplayValue: 100, type disp: '
1850: || l_doc_disp;
1851: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1852:
1853: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
1854: itemkey => itemkey,
1855: aname => 'DOCUMENT_TYPE_DISP',

Line 1880: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

1876:
1877: EXCEPTION
1878: WHEN OTHERS THEN
1879: l_progress := 'PO_WF_PO_NOTIFICATION.GetDisplayValue: sql err: ' || sqlerrm;
1880: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1881: IF (c_lookup_value_user%ISOPEN) THEN
1882: CLOSE c_lookup_value_user;
1883: END IF;
1884: IF (c_lookup_value_doc%ISOPEN) THEN

Line 1942: l_progress:='000'; PO_WF_DEBUG_PKG.insert_debug(p_itemtype,p_itemkey,l_log_head||':'||l_progress || 'Notification Type = ' || p_notification_type);

1938: l_result BOOLEAN := TRUE;
1939:
1940: BEGIN
1941:
1942: l_progress:='000'; PO_WF_DEBUG_PKG.insert_debug(p_itemtype,p_itemkey,l_log_head||':'||l_progress || 'Notification Type = ' || p_notification_type);
1943:
1944: -- Get the Authorization Status (e.g. 'PRE-APPROVED','APPROVED',
1945: -- 'INCOMPLETE', etc.) of the document.
1946: --

Line 1953: l_progress:='010'; PO_WF_DEBUG_PKG.insert_debug(p_itemtype,p_itemkey,l_log_head||':'||l_progress||' Authorization Status = '||l_authorization_status);

1949: , itemkey => p_itemkey
1950: , aname => 'AUTHORIZATION_STATUS'
1951: );
1952:
1953: l_progress:='010'; PO_WF_DEBUG_PKG.insert_debug(p_itemtype,p_itemkey,l_log_head||':'||l_progress||' Authorization Status = '||l_authorization_status);
1954:
1955:
1956: -- bug 3668188: changed the Open Doc allowed logic.
1957: -- If document is ('Pre-Approved' or 'In Process') and the

Line 1965: PO_WF_DEBUG_PKG.insert_debug(p_itemtype,p_itemkey,l_log_head||':'||l_progress||':FALSE');

1961: IF (l_authorization_status IN ('PRE-APPROVED', 'IN PROCESS')
1962: AND nvl(p_notification_type, 'SUBMITTER') = 'SUBMITTER')
1963: THEN
1964: l_progress:='020';
1965: PO_WF_DEBUG_PKG.insert_debug(p_itemtype,p_itemkey,l_log_head||':'||l_progress||':FALSE');
1966: l_result := FALSE;
1967: END IF;
1968:
1969: l_progress:='030';

Line 1970: PO_WF_DEBUG_PKG.insert_debug(p_itemtype,p_itemkey,l_log_head||':'||l_progress||':TRUE');

1966: l_result := FALSE;
1967: END IF;
1968:
1969: l_progress:='030';
1970: PO_WF_DEBUG_PKG.insert_debug(p_itemtype,p_itemkey,l_log_head||':'||l_progress||':TRUE');
1971: return (l_result);
1972:
1973: EXCEPTION
1974:

Line 1976: PO_WF_DEBUG_PKG.insert_debug(p_itemtype,p_itemkey,l_log_head||':'||SQLERRM);

1972:
1973: EXCEPTION
1974:
1975: WHEN OTHERS THEN
1976: PO_WF_DEBUG_PKG.insert_debug(p_itemtype,p_itemkey,l_log_head||':'||SQLERRM);
1977: RAISE;
1978:
1979: END is_open_document_allowed;
1980: