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 2903: PO_REQAPPROVAL_INIT1.Set_doc_mgr_context(itemtype, itemkey);

2899:
2900: /* Set the context for the doc manager */
2901: -- Bug 4290541, replaced apps init call with set doc mgr context
2902:
2903: PO_REQAPPROVAL_INIT1.Set_doc_mgr_context(itemtype, itemkey);
2904:
2905: l_progress := 'set_doc_mgr_context. USER_ID= ' || to_char(l_user_id)
2906: || ' APPLICATION_ID= ' || to_char(l_application_id) ||
2907: 'RESPONSIBILITY_ID= ' || to_char(l_responsibility_id);

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

3137:
3138:
3139: EXCEPTION
3140: WHEN OTHERS THEN
3141: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
3142: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
3143: wf_core.context('PO_WF_REQ_NOTIFICATION','Get_req_approval_msg_attribute',l_progress);
3144: 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');
3145: raise;

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

3138:
3139: EXCEPTION
3140: WHEN OTHERS THEN
3141: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
3142: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
3143: wf_core.context('PO_WF_REQ_NOTIFICATION','Get_req_approval_msg_attribute',l_progress);
3144: 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');
3145: raise;
3146:

Line 3144: 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');

3140: WHEN OTHERS THEN
3141: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
3142: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
3143: wf_core.context('PO_WF_REQ_NOTIFICATION','Get_req_approval_msg_attribute',l_progress);
3144: 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');
3145: raise;
3146:
3147: END Get_req_approver_msg_attribute;
3148:

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

3200:
3201:
3202: EXCEPTION
3203: WHEN OTHERS THEN
3204: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
3205: wf_core.context('PO_WF_REQ_NOTIFICATION','Get_req_preparer_msg_attribute',l_progress);
3206: 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');
3207: raise;
3208:

Line 3206: 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');

3202: EXCEPTION
3203: WHEN OTHERS THEN
3204: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
3205: wf_core.context('PO_WF_REQ_NOTIFICATION','Get_req_preparer_msg_attribute',l_progress);
3206: 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');
3207: raise;
3208:
3209: END Get_req_preparer_msg_attribute;
3210:

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

3284: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
3285:
3286: EXCEPTION
3287: WHEN OTHERS THEN
3288: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
3289: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
3290: wf_core.context('PO_WF_REQ_NOTIFICATION','Get_req_fwdfrom_msg_attribute',l_progress);
3291: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
3292: l_doc_string, sqlerrm, 'PO_WF_REQ_NOTIFICATION.GET_REQ_FWDFROM_MSG_ATTRIBUTE');

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

3285:
3286: EXCEPTION
3287: WHEN OTHERS THEN
3288: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
3289: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
3290: wf_core.context('PO_WF_REQ_NOTIFICATION','Get_req_fwdfrom_msg_attribute',l_progress);
3291: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
3292: l_doc_string, sqlerrm, 'PO_WF_REQ_NOTIFICATION.GET_REQ_FWDFROM_MSG_ATTRIBUTE');
3293: raise;

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

3287: WHEN OTHERS THEN
3288: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
3289: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
3290: wf_core.context('PO_WF_REQ_NOTIFICATION','Get_req_fwdfrom_msg_attribute',l_progress);
3291: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
3292: l_doc_string, sqlerrm, 'PO_WF_REQ_NOTIFICATION.GET_REQ_FWDFROM_MSG_ATTRIBUTE');
3293: raise;
3294:
3295: END Get_req_fwdfrom_msg_attribute;