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_REQ_NOTIFICATION dependencies on PO_WF_REQ_NOTIFICATION

Line 1: PACKAGE BODY PO_WF_REQ_NOTIFICATION AS

1: PACKAGE BODY PO_WF_REQ_NOTIFICATION AS
2: /* $Header: POXWPA6B.pls 120.27.12020000.2 2013/05/09 15:26:56 rparise ship $ */
3:
4: -- Read the profile option that enables/disables the debug log
5: g_po_wf_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('PO_SET_DEBUG_WORKFLOW_ON'),'N');

Line 102: Referenced by : PO_WF_REQ_NOTIFICATION. This is invoked from

98:
99: DESCRIPTION : This private function returns true if foreign currency
100: column needs to be displayed for Req Approval notifications
101:
102: Referenced by : PO_WF_REQ_NOTIFICATION. This is invoked from
103: get_req_lines_details_link
104:
105: parameters : p_document_id - This is requisition Header id
106: p_func_currency_code - This is functional currency

Line 118: Referenced by : PO_WF_REQ_NOTIFICATION

114:
115: DESCRIPTION : This procedure retrieves item_type, item_key and
116: notification id(if #nid is present)
117:
118: Referenced by : PO_WF_REQ_NOTIFICATION
119: parameters : document_id - Document Identifier
120: itemtype - Workflow item type for Req approval
121: itemkey - Unique workflow item key
122: nid - Workflow id for current notification

Line 138: Referenced by : PO_WF_REQ_NOTIFICATION

134:
135: DESCRIPTION : This function finds the req total and
136: return the value with a displayable format specified by given currency.
137:
138: Referenced by : PO_WF_REQ_NOTIFICATION
139: parameters :
140: itemtype - Workflow item type for Req approval
141: itemkey - Unique workflow item key
142: p_document_id - req header id

Line 1824: PO_WF_REQ_NOTIFICATION.FORMAT_CURRENCY_NO_PRECESION(l_line.txn_curr_code,l_line.curr_unit_price) || ' ' || l_line.txn_curr_code || '' || NL;

1820: l_line.txn_curr_code is not null AND
1821: l_currency_code <> l_line.txn_curr_code) THEN
1822:
1823: l_document := l_document || '' ||
1824: PO_WF_REQ_NOTIFICATION.FORMAT_CURRENCY_NO_PRECESION(l_line.txn_curr_code,l_line.curr_unit_price) || ' ' || l_line.txn_curr_code || '' || NL;
1825: ELSE
1826: /* this line does not have foreign currency, display a blank cell */
1827: l_document := l_document || '' || ' ' || '' || NL;
1828: END IF;

Line 1832: PO_WF_REQ_NOTIFICATION.FORMAT_CURRENCY_NO_PRECESION(l_currency_code,l_line.unit_price ) || '' || NL;

1828: END IF;
1829: END IF;
1830:
1831: l_document := l_document || '' ||
1832: PO_WF_REQ_NOTIFICATION.FORMAT_CURRENCY_NO_PRECESION(l_currency_code,l_line.unit_price ) || '' || NL;
1833:
1834: l_document := l_document || '' ||
1835: TO_CHAR(l_line.line_amount, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) ||
1836: '' || NL;

Line 2640: wf_core.context('PO_WF_REQ_NOTIFICATION','update_action_history',l_progress,sqlerrm);

2636:
2637: commit;
2638: EXCEPTION
2639: WHEN OTHERS THEN
2640: wf_core.context('PO_WF_REQ_NOTIFICATION','update_action_history',l_progress,sqlerrm);
2641: RAISE;
2642: end;
2643:
2644:

Line 3198: wf_core.context('PO_WF_REQ_NOTIFICATION','set_doc_mgr_context',l_progress);

3194:
3195: EXCEPTION
3196:
3197: WHEN OTHERS THEN
3198: wf_core.context('PO_WF_REQ_NOTIFICATION','set_doc_mgr_context',l_progress);
3199: raise;
3200:
3201: END set_doc_mgr_context;
3202:

Line 3456: wf_core.context('PO_WF_REQ_NOTIFICATION','Get_req_approval_msg_attribute',l_progress);

3452: EXCEPTION
3453: WHEN OTHERS THEN
3454: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
3455: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
3456: wf_core.context('PO_WF_REQ_NOTIFICATION','Get_req_approval_msg_attribute',l_progress);
3457: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_WF_REQ_NOTIFICATION.GET_REQ_APPROVER_MSG_ATTRIBUTE');
3458: raise;
3459:
3460: END Get_req_approver_msg_attribute;

Line 3457: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_WF_REQ_NOTIFICATION.GET_REQ_APPROVER_MSG_ATTRIBUTE');

3453: WHEN OTHERS THEN
3454: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
3455: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
3456: wf_core.context('PO_WF_REQ_NOTIFICATION','Get_req_approval_msg_attribute',l_progress);
3457: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_WF_REQ_NOTIFICATION.GET_REQ_APPROVER_MSG_ATTRIBUTE');
3458: raise;
3459:
3460: END Get_req_approver_msg_attribute;
3461:

Line 3518: wf_core.context('PO_WF_REQ_NOTIFICATION','Get_req_preparer_msg_attribute',l_progress);

3514:
3515: EXCEPTION
3516: WHEN OTHERS THEN
3517: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
3518: wf_core.context('PO_WF_REQ_NOTIFICATION','Get_req_preparer_msg_attribute',l_progress);
3519: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_WF_REQ_NOTIFICATION.GET_REQ_PREPARER_MSG_ATTRIBUTE');
3520: raise;
3521:
3522: END Get_req_preparer_msg_attribute;

Line 3519: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_WF_REQ_NOTIFICATION.GET_REQ_PREPARER_MSG_ATTRIBUTE');

3515: EXCEPTION
3516: WHEN OTHERS THEN
3517: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
3518: wf_core.context('PO_WF_REQ_NOTIFICATION','Get_req_preparer_msg_attribute',l_progress);
3519: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_WF_REQ_NOTIFICATION.GET_REQ_PREPARER_MSG_ATTRIBUTE');
3520: raise;
3521:
3522: END Get_req_preparer_msg_attribute;
3523:

Line 3603: wf_core.context('PO_WF_REQ_NOTIFICATION','Get_req_fwdfrom_msg_attribute',l_progress);

3599: EXCEPTION
3600: WHEN OTHERS THEN
3601: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
3602: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
3603: wf_core.context('PO_WF_REQ_NOTIFICATION','Get_req_fwdfrom_msg_attribute',l_progress);
3604: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
3605: l_doc_string, sqlerrm, 'PO_WF_REQ_NOTIFICATION.GET_REQ_FWDFROM_MSG_ATTRIBUTE');
3606: raise;
3607:

Line 3605: l_doc_string, sqlerrm, 'PO_WF_REQ_NOTIFICATION.GET_REQ_FWDFROM_MSG_ATTRIBUTE');

3601: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
3602: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
3603: wf_core.context('PO_WF_REQ_NOTIFICATION','Get_req_fwdfrom_msg_attribute',l_progress);
3604: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
3605: l_doc_string, sqlerrm, 'PO_WF_REQ_NOTIFICATION.GET_REQ_FWDFROM_MSG_ATTRIBUTE');
3606: raise;
3607:
3608: END Get_req_fwdfrom_msg_attribute;
3609:

Line 3679: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'PO_WF_REQ_NOTIFICATION.get_item_info nid='||nid);

3675: end;
3676: end if;
3677:
3678: IF (g_po_wf_debug = 'Y') THEN
3679: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'PO_WF_REQ_NOTIFICATION.get_item_info nid='||nid);
3680: END IF;
3681:
3682: end;
3683:

Line 3738: END PO_WF_REQ_NOTIFICATION;

3734: return to_char(l_amount,l_mask);
3735:
3736: end FORMAT_CURRENCY_NO_PRECESION;
3737:
3738: END PO_WF_REQ_NOTIFICATION;