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_PO_NOTIFICATION

Line 1: PACKAGE BODY PO_WF_PO_NOTIFICATION AS

1: PACKAGE BODY PO_WF_PO_NOTIFICATION AS
2: /* $Header: POXWPA7B.pls 120.9.12010000.2 2008/08/04 08:36:10 rramasam ship $ */
3:
4: g_po_wf_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('PO_SET_DEBUG_WORKFLOW_ON'),'N');
5: g_pkg_name VARCHAR2(30) := 'PO_WF_PO_NOTIFICATION'; --

Line 5: g_pkg_name VARCHAR2(30) := 'PO_WF_PO_NOTIFICATION'; --

1: PACKAGE BODY PO_WF_PO_NOTIFICATION AS
2: /* $Header: POXWPA7B.pls 120.9.12010000.2 2008/08/04 08:36:10 rramasam ship $ */
3:
4: g_po_wf_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('PO_SET_DEBUG_WORKFLOW_ON'),'N');
5: g_pkg_name VARCHAR2(30) := 'PO_WF_PO_NOTIFICATION'; --
6:
7: PROCEDURE get_po_approve_msg ( document_id in varchar2,
8: display_type in varchar2,
9: document in out NOCOPY varchar2,

Line 1602: PO_WF_PO_NOTIFICATION.GetDisplayValue(itemtype, itemkey, l_user_name);

1598: actid => actid,
1599: aname => 'NTF_USER_NAME',
1600: ignore_notfound => TRUE);
1601:
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);

Line 1626: IF NOT (PO_WF_PO_NOTIFICATION.is_open_document_allowed(

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.
1626: IF NOT (PO_WF_PO_NOTIFICATION.is_open_document_allowed(
1627: p_itemtype => itemtype
1628: , p_itemkey => itemkey
1629: , p_notification_type => l_notification_type)
1630: ) THEN

Line 1727: wf_core.context('PO_WF_PO_NOTIFICATION','Get_req_approval_msg_attribute',l_progress);

1723: EXCEPTION
1724: WHEN OTHERS THEN
1725: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1726: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1727: wf_core.context('PO_WF_PO_NOTIFICATION','Get_req_approval_msg_attribute',l_progress);
1728: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
1729: l_doc_string, sqlerrm, 'PO_WF_PO_NOTIFICATION.Get_po_approver_msg_attribute');
1730: raise;
1731:

Line 1729: l_doc_string, sqlerrm, 'PO_WF_PO_NOTIFICATION.Get_po_approver_msg_attribute');

1725: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1726: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1727: wf_core.context('PO_WF_PO_NOTIFICATION','Get_req_approval_msg_attribute',l_progress);
1728: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
1729: l_doc_string, sqlerrm, 'PO_WF_PO_NOTIFICATION.Get_po_approver_msg_attribute');
1730: raise;
1731:
1732: END Get_po_user_msg_attribute;
1733:

Line 1777: l_progress := 'PO_WF_PO_NOTIFICATION.GetDisplayValue: 001, user name: '

1773:
1774: l_document_id PO_HEADERS_ALL.po_header_id%TYPE; --
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

Line 1812: l_progress := 'PO_WF_PO_NOTIFICATION.GetDisplayValue: 050';

1808: itemkey => itemkey,
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

Line 1825: l_progress := 'PO_WF_PO_NOTIFICATION.GetDisplayValue: 060';

1821: FETCH c_lookup_value_doc into l_doc_disp;
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,

Line 1834: l_progress := 'PO_WF_PO_NOTIFICATION.GetDisplayValue: 080, language: '

1830: l_email_address,
1831: l_notification_preference,
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

Line 1849: l_progress := 'PO_WF_PO_NOTIFICATION.GetDisplayValue: 100, type disp: '

1845: CLOSE c_lookup_value_user;
1846: END IF;
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,

Line 1879: l_progress := 'PO_WF_PO_NOTIFICATION.GetDisplayValue: sql err: ' || sqlerrm;

1875: avalue => l_msg_text );
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;

Line 1983: END PO_WF_PO_NOTIFICATION;

1979: END is_open_document_allowed;
1980:
1981:
1982:
1983: END PO_WF_PO_NOTIFICATION;