251: --
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,
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);
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;
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:
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:
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:
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:
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');
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;
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;