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 1727: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

1723:
1724: --Start of code changes for inserting the delegate action in Action History. Bug 13951919 fix
1725: l_progress := '001';
1726: IF (g_po_wf_debug = 'Y') THEN
1727: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1728: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'funcmode : '||funcmode);
1729: END IF;
1730:
1731: if (funcmode IN ('FORWARD', 'QUESTION', 'ANSWER','TIMEOUT')) then

Line 1728: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'funcmode : '||funcmode);

1724: --Start of code changes for inserting the delegate action in Action History. Bug 13951919 fix
1725: l_progress := '001';
1726: IF (g_po_wf_debug = 'Y') THEN
1727: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1728: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'funcmode : '||funcmode);
1729: END IF;
1730:
1731: if (funcmode IN ('FORWARD', 'QUESTION', 'ANSWER','TIMEOUT')) then
1732: if (funcmode = 'FORWARD') then

Line 1743: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'l_action : '||l_action);

1739: l_action := 'NO ACTION';
1740: end if;
1741:
1742: IF (g_po_wf_debug = 'Y') THEN
1743: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'l_action : '||l_action);
1744: END IF;
1745:
1746: l_po_header_id := PO_WF_UTIL_PKG.GetItemAttrNumber( itemtype => itemtype,
1747: itemkey => itemkey,

Line 1765: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'Document_ID : '||l_po_header_id);

1761: itemkey => itemkey,
1762: aname => 'DRAFT_TYPE');
1763:
1764: IF (g_po_wf_debug = 'Y') THEN
1765: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'Document_ID : '||l_po_header_id);
1766: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'Draft_id : '||l_draft_id);
1767: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'l_doc_type : '||l_doc_type);
1768: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'l_doc_sub_type : '||l_doc_sub_type);
1769: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'l_draft_type : '||l_draft_type);

Line 1766: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'Draft_id : '||l_draft_id);

1762: aname => 'DRAFT_TYPE');
1763:
1764: IF (g_po_wf_debug = 'Y') THEN
1765: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'Document_ID : '||l_po_header_id);
1766: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'Draft_id : '||l_draft_id);
1767: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'l_doc_type : '||l_doc_type);
1768: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'l_doc_sub_type : '||l_doc_sub_type);
1769: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'l_draft_type : '||l_draft_type);
1770: END IF;

Line 1767: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'l_doc_type : '||l_doc_type);

1763:
1764: IF (g_po_wf_debug = 'Y') THEN
1765: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'Document_ID : '||l_po_header_id);
1766: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'Draft_id : '||l_draft_id);
1767: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'l_doc_type : '||l_doc_type);
1768: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'l_doc_sub_type : '||l_doc_sub_type);
1769: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'l_draft_type : '||l_draft_type);
1770: END IF;
1771:

Line 1768: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'l_doc_sub_type : '||l_doc_sub_type);

1764: IF (g_po_wf_debug = 'Y') THEN
1765: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'Document_ID : '||l_po_header_id);
1766: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'Draft_id : '||l_draft_id);
1767: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'l_doc_type : '||l_doc_type);
1768: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'l_doc_sub_type : '||l_doc_sub_type);
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

Line 1769: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'l_draft_type : '||l_draft_type);

1765: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'Document_ID : '||l_po_header_id);
1766: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'Draft_id : '||l_draft_id);
1767: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'l_doc_type : '||l_doc_type);
1768: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'l_doc_sub_type : '||l_doc_sub_type);
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);

Line 1776: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'l_origsys : '||l_origsys);

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);
1778: END IF;
1779:
1780: ELSE

Line 1777: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'l_new_recipient_id : '||l_new_recipient_id);

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);
1778: END IF;
1779:
1780: ELSE
1781: BEGIN

Line 1791: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'l_original_recipient : '||l_original_recipient);

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);
1792: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'l_current_recipient_role : '||l_current_recipient_role);
1793: END IF;
1794:
1795: EXCEPTION

Line 1792: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'l_current_recipient_role : '||l_current_recipient_role);

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);
1792: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'l_current_recipient_role : '||l_current_recipient_role);
1793: END IF;
1794:
1795: EXCEPTION
1796: WHEN OTHERS THEN

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

1823:
1824: l_progress := '003';
1825:
1826: IF (g_po_wf_debug = 'Y') THEN
1827: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1828: END IF;
1829:
1830: IF l_new_recipient_id IS NOT NULL THEN
1831: IF (g_po_wf_debug = 'Y') THEN

Line 1832: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'Before executing update_action_history');

1828: END IF;
1829:
1830: IF l_new_recipient_id IS NOT NULL THEN
1831: IF (g_po_wf_debug = 'Y') THEN
1832: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'Before executing update_action_history');
1833: END IF;
1834:
1835: --15859236 start
1836: wf_directory.GetUserName(l_origsys, l_new_recipient_id, l_new_recipient_name, l_new_recipient_display_name);

Line 1867: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'After executing update_action_history');

1863: p_draft_id => l_draft_id,
1864: p_draft_type => l_draft_type);
1865:
1866: IF (g_po_wf_debug = 'Y') THEN
1867: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'After executing update_action_history');
1868: END IF;
1869: END IF;
1870:
1871: l_progress := '004';

Line 1900: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,

1896: or APPROVE or APPROVE_AND_FORWARD or REJECT. */
1897: l_respond_action_text := Wf_Notification.GetAttrText(l_nid, 'RESULT');
1898:
1899: IF (g_po_wf_debug = 'Y') THEN
1900: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,
1901: 'l_respond_action_text: ' || l_respond_action_text);
1902: END IF;
1903:
1904: /* This boolean flag will be set to FALSE if the forwarded person is invalid */

Line 1919: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,

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,
1920: 'l_orgid: ' || l_orgid);
1921: END IF;
1922:
1923: IF l_orgid is NOT NULL THEN

Line 1939: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,

1935: */
1936: l_forward_to_username_response := wf_notification.GetAttrText(l_nid, 'FORWARD_TO_USERNAME_RESPONSE');
1937:
1938: IF (g_po_wf_debug = 'Y') THEN
1939: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,
1940: 'l_forward_to_username_response: ' || l_forward_to_username_response);
1941: END IF;
1942:
1943: l_forward_to_username_response := UPPER(l_forward_to_username_response);

Line 1957: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,

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,
1958: 'l_forward_to_username: ' || l_forward_to_username);
1959: END IF;
1960:
1961: /*

Line 1999: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,

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,
2000: 'l_preparer_id: ' || l_preparer_id ||
2001: ', x_user_id: ' || x_user_id);
2002: END IF;
2003:

Line 2010: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,

2006: PO_REQAPPROVAL_FINDAPPRV1.CheckOwnerCanApprove(itemtype, itemkey,
2007: x_CanOwnerApproveFlag);
2008:
2009: IF (g_po_wf_debug = 'Y') THEN
2010: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,
2011: 'l_preparer_id: ' || l_preparer_id ||
2012: ', x_CanOwnerApproveFlag: ' || x_CanOwnerApproveFlag);
2013: END IF;
2014:

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

2031: END IF;
2032:
2033: l_progress := '005 PO_WF_PO_NOTIFICATION.post_approval_notif';
2034: IF (g_po_wf_debug = 'Y') THEN
2035: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2036: END IF;
2037:
2038: /* If the FORWARD is valid, set all the required workflow attributes */
2039: IF (l_is_forward_valid = TRUE) THEN

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

2039: IF (l_is_forward_valid = TRUE) THEN
2040:
2041: l_progress := '005 is_forward_valid TRUE';
2042: IF (g_po_wf_debug = 'Y') THEN
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,

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

2091: ** Field in the Notification.
2092: */
2093: l_progress := '005 is_forward_valid FALSE';
2094: IF (g_po_wf_debug = 'Y') THEN
2095: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2096: END IF;
2097:
2098: /* Set the Subject of the Approval notification to "Invalid forward-to"
2099: ** Since the user entered an invalid forward-to, then set the

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

2119: ** The insert action is still performed in PO_DOCUMENT_ACTION_UTIL.handle_auth_action_history.
2120: */
2121: l_progress := '006 PO_WF_PO_NOTIFICATION.post_approval_notif';
2122: IF (g_po_wf_debug = 'Y') THEN
2123: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2124: END IF;
2125:
2126: /*
2127: ** Update action history for APPROVE_AND_FORWARD

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

2176: aname => 'DRAFT_TYPE');
2177:
2178: l_progress := '007 start to update action history';
2179: IF (g_po_wf_debug = 'Y') THEN
2180: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2181: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'l_action : ' || l_action ||
2182: ', l_po_header_id: ' || l_po_header_id ||
2183: ', l_draft_id: ' || l_draft_id ||
2184: ', l_draft_type: ' || l_draft_type ||

Line 2181: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'l_action : ' || l_action ||

2177:
2178: l_progress := '007 start to update action history';
2179: IF (g_po_wf_debug = 'Y') THEN
2180: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2181: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'l_action : ' || l_action ||
2182: ', l_po_header_id: ' || l_po_header_id ||
2183: ', l_draft_id: ' || l_draft_id ||
2184: ', l_draft_type: ' || l_draft_type ||
2185: ', l_current_recipient_id: ' || l_current_recipient_id);

Line 2186: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'l_note: ' || l_note);

2182: ', l_po_header_id: ' || l_po_header_id ||
2183: ', l_draft_id: ' || l_draft_id ||
2184: ', l_draft_type: ' || l_draft_type ||
2185: ', l_current_recipient_id: ' || l_current_recipient_id);
2186: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'l_note: ' || l_note);
2187: END IF;
2188:
2189: update_action_history(p_action_code => l_action,
2190: p_recipient_id => NULL,

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

2199: END IF;
2200:
2201: l_progress := '008 PO_WF_PO_NOTIFICATION.post_approval_notif';
2202: IF (g_po_wf_debug = 'Y') THEN
2203: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2204: END IF;
2205: --End of code changes.
2206:
2207: --

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

2211: l_preserved_ctx := 'FALSE';
2212: end if;
2213: l_progress := 'notif callback preserved_ctx : '||l_preserved_ctx;
2214: IF (g_po_wf_debug = 'Y') THEN
2215: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2216: END IF;
2217: --
2218:
2219: --

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

2218:
2219: --
2220: l_progress := '010 notif callback -responder id : '||l_responder_id;
2221: IF (g_po_wf_debug = 'Y') THEN
2222: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2223: END IF;
2224: --
2225: --Bug 5389914
2226: --Fnd_Profile.Get('USER_ID',l_session_user_id);

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

2246: l_progress :='020 notification callback ses_userid: '||l_session_user_id
2247: ||' sess_resp_id '||l_session_resp_id||' sess_appl_id '
2248: ||l_session_appl_id;
2249: IF (g_po_wf_debug = 'Y') THEN
2250: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2251: END IF;
2252: --
2253:
2254: -- bug 4901406 : need to shift the setting of the preparer resp and appl id

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

2266: --
2267: l_progress := '030 notif callback prep resp_id:'||l_preparer_resp_id
2268: ||' prep appl id '||l_preparer_appl_id;
2269: IF (g_po_wf_debug = 'Y') THEN
2270: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2271: END IF;
2272: --
2273:
2274: -- bug 4901406

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

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;
2366: return;
2367: end if;
2368:

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

2415: return;
2416: end if;
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');

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

2426: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
2427: END IF;
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,

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

2438: PO_WF_PO_NOTIFICATION.GetDisplayValue(itemtype, itemkey, l_user_name);
2439:
2440:
2441: l_progress := 'Get_po_user_msg_attribute:015: username: ' || l_user_name;
2442: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2443:
2444:
2445: -- Bug 3668188: added the NTF_USER_ROLE Activity Attribute, which is
2446: -- a constant with value 'SUBMITTER' or 'APPROVER'. This distinguishes

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

2453: ignore_notfound => TRUE);
2454:
2455: l_progress := 'Get_po_user_msg_attribute:020: notif type: ' || l_notification_type;
2456: -- DEBUG
2457: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2458:
2459:
2460: -- Bug 3668188: Removed old logic from bug 3564727 and replaced it
2461: -- with a call to is_open_document_allowed, which has updated logic.

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

2464: , p_itemkey => itemkey
2465: , p_notification_type => l_notification_type)
2466: ) THEN
2467: l_progress := 'Get_po_approver_msg_attribute: 040: NULL open form';
2468: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2469:
2470: -- HTML Orders R12
2471: -- Set the URL and form attributes
2472: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType,

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

2552:
2553:
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

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

2615:
2616: BEGIN
2617: l_progress := 'PO_WF_PO_NOTIFICATION.GetDisplayValue: 001, user name: '
2618: || username;
2619: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2620:
2621: if ((doctype is NULL) or (docsubtype is null)) then
2622: l_doc_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
2623: itemkey => itemkey,

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

2660: aname => 'DRAFT_TYPE');
2661:
2662: IF username is NULL THEN
2663: l_progress := 'PO_WF_PO_NOTIFICATION.GetDisplayValue: 050';
2664: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2665:
2666: IF l_doc_type = 'PA' AND l_doc_subtype IN ('BLANKET','CONTRACT') OR
2667: l_doc_type = 'PO' AND l_doc_subtype = 'STANDARD' then
2668: -- CLM Apprvl. In case of modification documents that document type display needs to be 'Modification'

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

2682: CLOSE c_lookup_value_doc;
2683: END IF;
2684: ELSE
2685: l_progress := 'PO_WF_PO_NOTIFICATION.GetDisplayValue: 060';
2686: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2687: WF_DIRECTORY.GETROLEINFO(
2688: username,
2689: l_display_name,
2690: l_email_address,

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

2692: l_language,
2693: l_territory);
2694: l_progress := 'PO_WF_PO_NOTIFICATION.GetDisplayValue: 080, language: '
2695: || l_language;
2696: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2697:
2698: BEGIN
2699:
2700: SELECT language_code

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

2728: END IF; /* if username is null */
2729: --
2730: l_progress := 'PO_WF_PO_NOTIFICATION.GetDisplayValue: 100, type disp: '
2731: || l_doc_disp;
2732: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2733:
2734: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
2735: itemkey => itemkey,
2736: aname => 'DOCUMENT_TYPE_DISP',

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

2801:
2802: EXCEPTION
2803: WHEN OTHERS THEN
2804: l_progress := 'PO_WF_PO_NOTIFICATION.GetDisplayValue: sql err: ' || sqlerrm;
2805: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2806: IF (c_lookup_value_user%ISOPEN) THEN
2807: CLOSE c_lookup_value_user;
2808: END IF;
2809: IF (c_lookup_value_doc%ISOPEN) THEN

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

2863: l_result BOOLEAN := TRUE;
2864:
2865: BEGIN
2866:
2867: l_progress:='000'; PO_WF_DEBUG_PKG.insert_debug(p_itemtype,p_itemkey,l_log_head||':'||l_progress || 'Notification Type = ' || p_notification_type);
2868:
2869: -- Get the Authorization Status (e.g. 'PRE-APPROVED','APPROVED',
2870: -- 'INCOMPLETE', etc.) of the document.
2871: --

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

2874: , itemkey => p_itemkey
2875: , aname => 'AUTHORIZATION_STATUS'
2876: );
2877:
2878: l_progress:='010'; PO_WF_DEBUG_PKG.insert_debug(p_itemtype,p_itemkey,l_log_head||':'||l_progress||' Authorization Status = '||l_authorization_status);
2879:
2880:
2881: -- bug 3668188: changed the Open Doc allowed logic.
2882: -- If document is ('Pre-Approved' or 'In Process') and the

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

2886: IF (l_authorization_status IN ('PRE-APPROVED', 'IN PROCESS')
2887: AND nvl(p_notification_type, 'SUBMITTER') = 'SUBMITTER')
2888: THEN
2889: l_progress:='020';
2890: PO_WF_DEBUG_PKG.insert_debug(p_itemtype,p_itemkey,l_log_head||':'||l_progress||':FALSE');
2891: l_result := FALSE;
2892: END IF;
2893:
2894: l_progress:='030';

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

2891: l_result := FALSE;
2892: END IF;
2893:
2894: l_progress:='030';
2895: PO_WF_DEBUG_PKG.insert_debug(p_itemtype,p_itemkey,l_log_head||':'||l_progress||':TRUE');
2896: return (l_result);
2897:
2898: EXCEPTION
2899:

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

2897:
2898: EXCEPTION
2899:
2900: WHEN OTHERS THEN
2901: PO_WF_DEBUG_PKG.insert_debug(p_itemtype,p_itemkey,l_log_head||':'||SQLERRM);
2902: RAISE;
2903:
2904: END is_open_document_allowed;
2905: