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.30.12020000.6 2013/03/16 14:04:59 inagdeo 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.30.12020000.6 2013/03/16 14:04:59 inagdeo 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: --Added this private procedure as part of bug 13951919 fix
8: PROCEDURE update_action_history (p_action_code IN VARCHAR2,
9: p_recipient_id IN NUMBER,

Line 2033: l_progress := '005 PO_WF_PO_NOTIFICATION.post_approval_notif';

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';
2034: IF (g_po_wf_debug = 'Y') THEN
2035: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2036: END IF;
2037:

Line 2121: l_progress := '006 PO_WF_PO_NOTIFICATION.post_approval_notif';

2117: /*
2118: ** Here the logic to update the action code in action history.
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:

Line 2201: l_progress := '008 PO_WF_PO_NOTIFICATION.post_approval_notif';

2197: p_draft_id => l_draft_id,
2198: p_draft_type => l_draft_type); -- PAR Approval
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.

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

2434: actid => actid,
2435: aname => 'NTF_USER_NAME',
2436: ignore_notfound => TRUE);
2437:
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);

Line 2462: IF NOT (PO_WF_PO_NOTIFICATION.is_open_document_allowed(

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.
2462: IF NOT (PO_WF_PO_NOTIFICATION.is_open_document_allowed(
2463: p_itemtype => itemtype
2464: , p_itemkey => itemkey
2465: , p_notification_type => l_notification_type)
2466: ) THEN

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

2560: EXCEPTION
2561: WHEN OTHERS THEN
2562: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2563: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2564: wf_core.context('PO_WF_PO_NOTIFICATION','Get_req_approval_msg_attribute',l_progress);
2565: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
2566: l_doc_string, sqlerrm, 'PO_WF_PO_NOTIFICATION.Get_po_approver_msg_attribute');
2567: raise;
2568:

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

2562: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2563: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2564: wf_core.context('PO_WF_PO_NOTIFICATION','Get_req_approval_msg_attribute',l_progress);
2565: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
2566: l_doc_string, sqlerrm, 'PO_WF_PO_NOTIFICATION.Get_po_approver_msg_attribute');
2567: raise;
2568:
2569: END Get_po_user_msg_attribute;
2570:

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

2613: l_draft_id NUMBER; -- CLM Apprvl
2614: l_draft_type PO_DRAFTS.DRAFT_TYPE%TYPE; -- PAR Approval
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

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

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

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

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

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

2690: l_email_address,
2691: l_notification_preference,
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

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

2726: CLOSE c_lookup_value_user;
2727: END IF;
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,

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

2800: /* PO AME Project end */
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;

Line 3079: wf_core.context('PO_WF_PO_NOTIFICATION','update_action_history',l_progress,sqlerrm);

3075:
3076: commit;
3077: EXCEPTION
3078: WHEN OTHERS THEN
3079: wf_core.context('PO_WF_PO_NOTIFICATION','update_action_history',l_progress,sqlerrm);
3080: RAISE;
3081: END;
3082:
3083: END PO_WF_PO_NOTIFICATION;

Line 3083: END PO_WF_PO_NOTIFICATION;

3079: wf_core.context('PO_WF_PO_NOTIFICATION','update_action_history',l_progress,sqlerrm);
3080: RAISE;
3081: END;
3082:
3083: END PO_WF_PO_NOTIFICATION;