DBA Data[Home] [Help]

APPS.PO_WF_REQ_NOTIFICATION dependencies on PO_REQAPPROVAL_INIT1

Line 255: -- PO_REQAPPROVAL_INIT1.Set_doc_mgr_context (l_item_type,l_item_key);

251: -- Need to initialize the apps session, so that
252: -- employee details can be selected for the Action History.
253: --
254: -- Context setting Revamp
255: -- PO_REQAPPROVAL_INIT1.Set_doc_mgr_context (l_item_type,l_item_key);
256:
257: /*
258: l_document_subtype := get_document_subtype_display(wf_engine.GetItemAttrText
259: (itemtype => l_item_type,

Line 3189: PO_REQAPPROVAL_INIT1.Set_doc_mgr_context(itemtype, itemkey);

3185:
3186: /* Set the context for the doc manager */
3187: -- Bug 4290541, replaced apps init call with set doc mgr context
3188:
3189: PO_REQAPPROVAL_INIT1.Set_doc_mgr_context(itemtype, itemkey);
3190:
3191: l_progress := 'set_doc_mgr_context. USER_ID= ' || to_char(l_user_id)
3192: || ' APPLICATION_ID= ' || to_char(l_application_id) ||
3193: 'RESPONSIBILITY_ID= ' || to_char(l_responsibility_id);

Line 3454: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);

3450:
3451:
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;

Line 3455: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);

3451:
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:

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 3517: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);

3513:
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:

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 3601: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);

3597: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
3598:
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');

Line 3602: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);

3598:
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;

Line 3604: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,

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:
3608: END Get_req_fwdfrom_msg_attribute;