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_REQCHANGEREQUESTWF_PVT dependencies on PO_REQAPPROVAL_INIT1

Line 4300: PO_REQAPPROVAL_INIT1.get_user_name(l_requester_id, l_requester_name, l_requester_display_name);

4296: itemkey => item_key,
4297: process => 'CONVERT_INTO_PO_REQUEST');
4298: x_progress :='StartConvertProcess:004';
4299:
4300: PO_REQAPPROVAL_INIT1.get_user_name(l_requester_id, l_requester_name, l_requester_display_name);
4301: x_progress :='StartConvertProcess:005';
4302:
4303: n_varname(1) := 'CHANGE_REQUEST_GROUP_ID';
4304: n_varval(1) := p_change_request_group_id;

Line 4594: PO_REQAPPROVAL_INIT1.get_user_name(l_agent_id, l_buyer_name, l_buyer_display_name);

4590: message => 'change_request_group_id:' ||to_char(p_change_request_group_id) || '-after creating workflow');
4591: END IF;
4592: END IF;
4593:
4594: PO_REQAPPROVAL_INIT1.get_user_name(l_agent_id, l_buyer_name, l_buyer_display_name);
4595: PO_REQAPPROVAL_INIT1.get_user_name(l_preparer_id, l_preparer_username, l_preparer_display_name);
4596: x_progress :='StartPOChangeWF:005';
4597:
4598: open get_parent_group_id_csr(p_change_request_group_id);

Line 4595: PO_REQAPPROVAL_INIT1.get_user_name(l_preparer_id, l_preparer_username, l_preparer_display_name);

4591: END IF;
4592: END IF;
4593:
4594: PO_REQAPPROVAL_INIT1.get_user_name(l_agent_id, l_buyer_name, l_buyer_display_name);
4595: PO_REQAPPROVAL_INIT1.get_user_name(l_preparer_id, l_preparer_username, l_preparer_display_name);
4596: x_progress :='StartPOChangeWF:005';
4597:
4598: open get_parent_group_id_csr(p_change_request_group_id);
4599: fetch get_parent_group_id_csr into l_parent_group_id;

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

5001: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
5002:
5003: EXCEPTION
5004: WHEN OTHERS THEN
5005: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
5006: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
5007: wf_core.context('PO_ReqChangeRequestWF_PVT','Get_Req_Chg_Attributes',x_progress);
5008: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Get_Req_Chg_Attributes');
5009: raise;

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

5002:
5003: EXCEPTION
5004: WHEN OTHERS THEN
5005: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
5006: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
5007: wf_core.context('PO_ReqChangeRequestWF_PVT','Get_Req_Chg_Attributes',x_progress);
5008: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Get_Req_Chg_Attributes');
5009: raise;
5010:

Line 5008: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Get_Req_Chg_Attributes');

5004: WHEN OTHERS THEN
5005: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
5006: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
5007: wf_core.context('PO_ReqChangeRequestWF_PVT','Get_Req_Chg_Attributes',x_progress);
5008: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Get_Req_Chg_Attributes');
5009: raise;
5010:
5011:
5012: end Get_Req_Chg_Attributes;

Line 5080: x_progress := 'PO_REQAPPROVAL_INIT1.Update_Req_Change_Flag: 02';

5076: --
5077: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
5078: --
5079:
5080: x_progress := 'PO_REQAPPROVAL_INIT1.Update_Req_Change_Flag: 02';
5081:
5082:
5083: EXCEPTION
5084: WHEN OTHERS THEN

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

5081:
5082:
5083: EXCEPTION
5084: WHEN OTHERS THEN
5085: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
5086: l_preparer_user_name := PO_REQAPPROVAL_INIT1.
5087: get_preparer_user_name(itemType, itemkey);
5088: wf_core.context('PO_ReqChangeRequestWF_PVT',
5089: 'Update_Req_Change_Flag',x_progress);

Line 5086: l_preparer_user_name := PO_REQAPPROVAL_INIT1.

5082:
5083: EXCEPTION
5084: WHEN OTHERS THEN
5085: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
5086: l_preparer_user_name := PO_REQAPPROVAL_INIT1.
5087: get_preparer_user_name(itemType, itemkey);
5088: wf_core.context('PO_ReqChangeRequestWF_PVT',
5089: 'Update_Req_Change_Flag',x_progress);
5090: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,

Line 5090: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,

5086: l_preparer_user_name := PO_REQAPPROVAL_INIT1.
5087: get_preparer_user_name(itemType, itemkey);
5088: wf_core.context('PO_ReqChangeRequestWF_PVT',
5089: 'Update_Req_Change_Flag',x_progress);
5090: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,
5091: l_preparer_user_name, l_doc_string,
5092: sqlerrm, 'PO_ReqChangeRequestWF_PVT.Update_Req_Change_Flag');
5093: raise;
5094:

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

5207: x_progress := 'PO_ReqChangeRequestWF_PVT.Insert_into_History_CHGsubmit: 07';
5208:
5209: EXCEPTION
5210: WHEN OTHERS THEN
5211: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
5212: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
5213: itemType, itemkey);
5214: wf_core.context('PO_ReqChangeRequestWF_PVT',
5215: 'Insert_into_History_CHGsubmit',x_progress||sqlerrm);

Line 5212: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(

5208:
5209: EXCEPTION
5210: WHEN OTHERS THEN
5211: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
5212: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
5213: itemType, itemkey);
5214: wf_core.context('PO_ReqChangeRequestWF_PVT',
5215: 'Insert_into_History_CHGsubmit',x_progress||sqlerrm);
5216: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,

Line 5216: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,

5212: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
5213: itemType, itemkey);
5214: wf_core.context('PO_ReqChangeRequestWF_PVT',
5215: 'Insert_into_History_CHGsubmit',x_progress||sqlerrm);
5216: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,
5217: l_preparer_user_name, l_doc_string, sqlerrm,
5218: 'PO_ReqChangeRequestWF_PVT.Insert_into_History_CHGsubmit');
5219: raise;
5220:

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

5284:
5285:
5286: EXCEPTION
5287: WHEN OTHERS THEN
5288: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
5289: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
5290: itemType, itemkey);
5291: wf_core.context('PO_REQ_CHANGE_WF','APPROVAL_NEEDED',x_progress);
5292: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,

Line 5289: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(

5285:
5286: EXCEPTION
5287: WHEN OTHERS THEN
5288: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
5289: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
5290: itemType, itemkey);
5291: wf_core.context('PO_REQ_CHANGE_WF','APPROVAL_NEEDED',x_progress);
5292: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,
5293: l_preparer_user_name, l_doc_string,

Line 5292: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,

5288: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
5289: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
5290: itemType, itemkey);
5291: wf_core.context('PO_REQ_CHANGE_WF','APPROVAL_NEEDED',x_progress);
5292: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,
5293: l_preparer_user_name, l_doc_string,
5294: sqlerrm,
5295: 'PO_REQ_CHANGE_WF.Req_Change_Needs_Approval');
5296: raise;

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

5346:
5347:
5348: EXCEPTION
5349: WHEN OTHERS THEN
5350: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
5351: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
5352: itemType, itemkey);
5353: wf_core.context('PO_REQ_CHANGE_WF','Set_Change_Mgr_Pre_App',x_progress);
5354: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,

Line 5351: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(

5347:
5348: EXCEPTION
5349: WHEN OTHERS THEN
5350: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
5351: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
5352: itemType, itemkey);
5353: wf_core.context('PO_REQ_CHANGE_WF','Set_Change_Mgr_Pre_App',x_progress);
5354: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,
5355: l_preparer_user_name, l_doc_string,

Line 5354: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,

5350: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
5351: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
5352: itemType, itemkey);
5353: wf_core.context('PO_REQ_CHANGE_WF','Set_Change_Mgr_Pre_App',x_progress);
5354: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,
5355: l_preparer_user_name, l_doc_string,
5356: sqlerrm, 'PO_REQ_CHANGE_WF.Set_Change_Mgr_Pre_App');
5357: raise;
5358:

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

5405: x_progress := 'PO_ReqChangeRequestWF_PVT.Set_Change_Mgr_App: 02';
5406:
5407: EXCEPTION
5408: WHEN OTHERS THEN
5409: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
5410: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
5411: itemType, itemkey);
5412: wf_core.context('PO_REQ_CHANGE_WF','Set_Change_Mgr_App',x_progress);
5413: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,

Line 5410: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(

5406:
5407: EXCEPTION
5408: WHEN OTHERS THEN
5409: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
5410: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
5411: itemType, itemkey);
5412: wf_core.context('PO_REQ_CHANGE_WF','Set_Change_Mgr_App',x_progress);
5413: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,
5414: l_preparer_user_name, l_doc_string, sqlerrm,

Line 5413: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,

5409: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
5410: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
5411: itemType, itemkey);
5412: wf_core.context('PO_REQ_CHANGE_WF','Set_Change_Mgr_App',x_progress);
5413: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,
5414: l_preparer_user_name, l_doc_string, sqlerrm,
5415: 'PO_REQ_CHANGE_WF.Set_Change_Mgr_App');
5416: raise;
5417:

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

5469:
5470:
5471: EXCEPTION
5472: WHEN OTHERS THEN
5473: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
5474: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
5475: wf_core.context('PO_REQ_CHANGE_WF','Set_Change_Rejected',x_progress);
5476: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQ_CHANGE_WF.Set_Change_Rejected');
5477: raise;

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

5470:
5471: EXCEPTION
5472: WHEN OTHERS THEN
5473: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
5474: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
5475: wf_core.context('PO_REQ_CHANGE_WF','Set_Change_Rejected',x_progress);
5476: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQ_CHANGE_WF.Set_Change_Rejected');
5477: raise;
5478:

Line 5476: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQ_CHANGE_WF.Set_Change_Rejected');

5472: WHEN OTHERS THEN
5473: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
5474: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
5475: wf_core.context('PO_REQ_CHANGE_WF','Set_Change_Rejected',x_progress);
5476: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQ_CHANGE_WF.Set_Change_Rejected');
5477: raise;
5478:
5479: END Set_Change_Rejected;
5480:

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

5550: x_progress := 'PO_ReqChangeRequestWF_PVT.Is_Chg_Mgr_Pre_App: 02';
5551:
5552: EXCEPTION
5553: WHEN OTHERS THEN
5554: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
5555: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
5556: wf_core.context('PO_ReqChangeRequestWF_PVT','Is_Chg_Mgr_Pre_App',x_progress);
5557: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Is_Chg_Mgr_Pre_App');
5558: raise;

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

5551:
5552: EXCEPTION
5553: WHEN OTHERS THEN
5554: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
5555: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
5556: wf_core.context('PO_ReqChangeRequestWF_PVT','Is_Chg_Mgr_Pre_App',x_progress);
5557: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Is_Chg_Mgr_Pre_App');
5558: raise;
5559:

Line 5557: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Is_Chg_Mgr_Pre_App');

5553: WHEN OTHERS THEN
5554: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
5555: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
5556: wf_core.context('PO_ReqChangeRequestWF_PVT','Is_Chg_Mgr_Pre_App',x_progress);
5557: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Is_Chg_Mgr_Pre_App');
5558: raise;
5559:
5560:
5561: end Is_Chg_Mgr_Pre_App;

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

5705: x_progress := 'PO_ReqChangeRequestWF_PVT.Start_From_PO_Cancel: 02';
5706:
5707: EXCEPTION
5708: WHEN OTHERS THEN
5709: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
5710: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
5711: wf_core.context('PO_ReqChangeRequestWF_PVT','Start_From_PO_Cancel',x_progress);
5712: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Start_From_PO_Cancel');
5713: raise;

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

5706:
5707: EXCEPTION
5708: WHEN OTHERS THEN
5709: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
5710: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
5711: wf_core.context('PO_ReqChangeRequestWF_PVT','Start_From_PO_Cancel',x_progress);
5712: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Start_From_PO_Cancel');
5713: raise;
5714:

Line 5712: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Start_From_PO_Cancel');

5708: WHEN OTHERS THEN
5709: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
5710: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
5711: wf_core.context('PO_ReqChangeRequestWF_PVT','Start_From_PO_Cancel',x_progress);
5712: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Start_From_PO_Cancel');
5713: raise;
5714:
5715:
5716: end Start_From_PO_Cancel;

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

5785: x_progress := 'PO_ReqChangeRequestWF_PVT.Change_Request_Mgr_Approved: 02';
5786:
5787: EXCEPTION
5788: WHEN OTHERS THEN
5789: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
5790: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
5791: wf_core.context('PO_ReqChangeRequestWF_PVT','Change_Request_Mgr_Approved',x_progress);
5792: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Change_Request_Mgr_Approved');
5793: raise;

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

5786:
5787: EXCEPTION
5788: WHEN OTHERS THEN
5789: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
5790: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
5791: wf_core.context('PO_ReqChangeRequestWF_PVT','Change_Request_Mgr_Approved',x_progress);
5792: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Change_Request_Mgr_Approved');
5793: raise;
5794:

Line 5792: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Change_Request_Mgr_Approved');

5788: WHEN OTHERS THEN
5789: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
5790: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
5791: wf_core.context('PO_ReqChangeRequestWF_PVT','Change_Request_Mgr_Approved',x_progress);
5792: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Change_Request_Mgr_Approved');
5793: raise;
5794:
5795:
5796: end Change_Request_Mgr_Approved;

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

6049: l_progress := 'Update_Action_History_App_Rej: 999';
6050:
6051: EXCEPTION
6052: WHEN OTHERS THEN
6053: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
6054: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
6055: wf_core.context('PO_ReqChangeRequestWF_PVT','Update_Action_History_App_Rej',l_progress,sqlerrm);
6056: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Update_Action_History_App_Rej');
6057: RAISE;

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

6050:
6051: EXCEPTION
6052: WHEN OTHERS THEN
6053: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
6054: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
6055: wf_core.context('PO_ReqChangeRequestWF_PVT','Update_Action_History_App_Rej',l_progress,sqlerrm);
6056: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Update_Action_History_App_Rej');
6057: RAISE;
6058:

Line 6056: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Update_Action_History_App_Rej');

6052: WHEN OTHERS THEN
6053: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
6054: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
6055: wf_core.context('PO_ReqChangeRequestWF_PVT','Update_Action_History_App_Rej',l_progress,sqlerrm);
6056: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Update_Action_History_App_Rej');
6057: RAISE;
6058:
6059: END Update_Action_History_App_Rej;
6060:

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

6145: l_progress := 'Update_Action_History_Return: 999';
6146:
6147: EXCEPTION
6148: WHEN OTHERS THEN
6149: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
6150: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
6151: wf_core.context('PO_ReqChangeRequestWF_PVT','Update_Action_History_Return',l_progress,sqlerrm);
6152: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Update_Action_History_Return');
6153: RAISE;

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

6146:
6147: EXCEPTION
6148: WHEN OTHERS THEN
6149: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
6150: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
6151: wf_core.context('PO_ReqChangeRequestWF_PVT','Update_Action_History_Return',l_progress,sqlerrm);
6152: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Update_Action_History_Return');
6153: RAISE;
6154:

Line 6152: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Update_Action_History_Return');

6148: WHEN OTHERS THEN
6149: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
6150: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
6151: wf_core.context('PO_ReqChangeRequestWF_PVT','Update_Action_History_Return',l_progress,sqlerrm);
6152: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Update_Action_History_Return');
6153: RAISE;
6154:
6155: END Update_Action_History_Return;
6156:

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

6275:
6276:
6277: EXCEPTION
6278: WHEN OTHERS THEN
6279: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
6280: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
6281: wf_core.context('PO_ReqChangeRequestWF_PVT','Kickoff_POChange_WF',x_progress);
6282: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Kickoff_POChange_WF');
6283: raise;

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

6276:
6277: EXCEPTION
6278: WHEN OTHERS THEN
6279: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
6280: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
6281: wf_core.context('PO_ReqChangeRequestWF_PVT','Kickoff_POChange_WF',x_progress);
6282: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Kickoff_POChange_WF');
6283: raise;
6284:

Line 6282: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Kickoff_POChange_WF');

6278: WHEN OTHERS THEN
6279: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
6280: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
6281: wf_core.context('PO_ReqChangeRequestWF_PVT','Kickoff_POChange_WF',x_progress);
6282: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Kickoff_POChange_WF');
6283: raise;
6284:
6285: END Kickoff_POChange_WF;
6286:

Line 6350: x_progress := 'PO_REQAPPROVAL_INIT1.Reset_Change_Flag: 02';

6346: --
6347: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
6348: --
6349:
6350: x_progress := 'PO_REQAPPROVAL_INIT1.Reset_Change_Flag: 02';
6351:
6352:
6353: EXCEPTION
6354: WHEN OTHERS THEN

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

6351:
6352:
6353: EXCEPTION
6354: WHEN OTHERS THEN
6355: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
6356: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
6357: wf_core.context('PO_ReqChangeRequestWF_PVT','Reset_Change_Flag',x_progress);
6358: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Reset_Change_Flag');
6359: raise;

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

6352:
6353: EXCEPTION
6354: WHEN OTHERS THEN
6355: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
6356: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
6357: wf_core.context('PO_ReqChangeRequestWF_PVT','Reset_Change_Flag',x_progress);
6358: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Reset_Change_Flag');
6359: raise;
6360:

Line 6358: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Reset_Change_Flag');

6354: WHEN OTHERS THEN
6355: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
6356: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
6357: wf_core.context('PO_ReqChangeRequestWF_PVT','Reset_Change_Flag',x_progress);
6358: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Reset_Change_Flag');
6359: raise;
6360:
6361: END Reset_Change_Flag;
6362:

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

6695: x_progress := 'PO_ReqChangeRequestWF_PVT.Is_Doc_Approved: 02';
6696:
6697: EXCEPTION
6698: WHEN OTHERS THEN
6699: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
6700: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
6701: itemType, itemkey);
6702: wf_core.context('PO_ReqChangeRequestWF_PVT','Is_Doc_Approved',
6703: x_progress);

Line 6700: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(

6696:
6697: EXCEPTION
6698: WHEN OTHERS THEN
6699: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
6700: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
6701: itemType, itemkey);
6702: wf_core.context('PO_ReqChangeRequestWF_PVT','Is_Doc_Approved',
6703: x_progress);
6704: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,

Line 6704: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,

6700: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
6701: itemType, itemkey);
6702: wf_core.context('PO_ReqChangeRequestWF_PVT','Is_Doc_Approved',
6703: x_progress);
6704: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,
6705: l_preparer_user_name, l_doc_string, sqlerrm,
6706: 'PO_ReqChangeRequestWF_PVT.Is_Doc_Approved');
6707: raise;
6708:

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

6772: x_progress := 'PO_ReqChangeRequestWF_PVT.Set_Doc_In_Process: 02';
6773:
6774: EXCEPTION
6775: WHEN OTHERS THEN
6776: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
6777: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
6778: itemType, itemkey);
6779: wf_core.context('PO_ReqChangeRequestWF_PVT',
6780: 'Set_Doc_In_Process',x_progress);

Line 6777: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(

6773:
6774: EXCEPTION
6775: WHEN OTHERS THEN
6776: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
6777: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
6778: itemType, itemkey);
6779: wf_core.context('PO_ReqChangeRequestWF_PVT',
6780: 'Set_Doc_In_Process',x_progress);
6781: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,

Line 6781: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,

6777: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
6778: itemType, itemkey);
6779: wf_core.context('PO_ReqChangeRequestWF_PVT',
6780: 'Set_Doc_In_Process',x_progress);
6781: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,
6782: l_preparer_user_name, l_doc_string, sqlerrm,
6783: 'PO_ReqChangeRequestWF_PVT.Set_Doc_In_Process');
6784: raise;
6785:

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

6867: x_progress := 'PO_ReqChangeRequestWF_PVT.Compare_Revision: 02';
6868:
6869: EXCEPTION
6870: WHEN OTHERS THEN
6871: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
6872: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
6873: itemType, itemkey);
6874: wf_core.context('PO_ReqChangeRequestWF_PVT',
6875: 'Compare_Revision',x_progress||sqlerrm);

Line 6872: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(

6868:
6869: EXCEPTION
6870: WHEN OTHERS THEN
6871: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
6872: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
6873: itemType, itemkey);
6874: wf_core.context('PO_ReqChangeRequestWF_PVT',
6875: 'Compare_Revision',x_progress||sqlerrm);
6876: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,

Line 6876: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,

6872: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
6873: itemType, itemkey);
6874: wf_core.context('PO_ReqChangeRequestWF_PVT',
6875: 'Compare_Revision',x_progress||sqlerrm);
6876: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,
6877: l_preparer_user_name, l_doc_string, sqlerrm,
6878: 'PO_ReqChangeRequestWF_PVT.Compare_Revision');
6879: raise;
6880: end Compare_Revision;

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

6941: x_progress := 'PO_ReqChangeRequestWF_PVT.Record_Buyer_Rejection: 02';
6942:
6943: EXCEPTION
6944: WHEN OTHERS THEN
6945: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
6946: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
6947: itemType, itemkey);
6948: wf_core.context('PO_ReqChangeRequestWF_PVT',
6949: 'Record_Buyer_Rejection',x_progress);

Line 6946: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(

6942:
6943: EXCEPTION
6944: WHEN OTHERS THEN
6945: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
6946: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
6947: itemType, itemkey);
6948: wf_core.context('PO_ReqChangeRequestWF_PVT',
6949: 'Record_Buyer_Rejection',x_progress);
6950: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,

Line 6950: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,

6946: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
6947: itemType, itemkey);
6948: wf_core.context('PO_ReqChangeRequestWF_PVT',
6949: 'Record_Buyer_Rejection',x_progress);
6950: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,
6951: l_preparer_user_name, l_doc_string, sqlerrm,
6952: 'PO_ReqChangeRequestWF_PVT.Record_Buyer_Rejection');
6953: raise;
6954:

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

7015: x_progress := 'PO_ReqChangeRequestWF_PVT.Record_Buyer_Acceptance: 02';
7016:
7017: EXCEPTION
7018: WHEN OTHERS THEN
7019: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
7020: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
7021: itemType, itemkey);
7022: wf_core.context('PO_ReqChangeRequestWF_PVT',
7023: 'Record_Buyer_Acceptance',x_progress);

Line 7020: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(

7016:
7017: EXCEPTION
7018: WHEN OTHERS THEN
7019: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
7020: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
7021: itemType, itemkey);
7022: wf_core.context('PO_ReqChangeRequestWF_PVT',
7023: 'Record_Buyer_Acceptance',x_progress);
7024: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,

Line 7024: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,

7020: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
7021: itemType, itemkey);
7022: wf_core.context('PO_ReqChangeRequestWF_PVT',
7023: 'Record_Buyer_Acceptance',x_progress);
7024: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,
7025: l_preparer_user_name, l_doc_string, sqlerrm,
7026: 'PO_ReqChangeRequestWF_PVT.Record_Buyer_Acceptance');
7027: raise;
7028:

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

7084: x_progress := 'PO_ReqChangeRequestWF_PVT.Start_Process_Buy_Response_WF: 02';
7085:
7086: EXCEPTION
7087: WHEN OTHERS THEN
7088: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
7089: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
7090: itemType, itemkey);
7091: wf_core.context('PO_ReqChangeRequestWF_PVT',
7092: 'Start_Process_Buy_Response_WF',x_progress);

Line 7089: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(

7085:
7086: EXCEPTION
7087: WHEN OTHERS THEN
7088: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
7089: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
7090: itemType, itemkey);
7091: wf_core.context('PO_ReqChangeRequestWF_PVT',
7092: 'Start_Process_Buy_Response_WF',x_progress);
7093: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,

Line 7093: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,

7089: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
7090: itemType, itemkey);
7091: wf_core.context('PO_ReqChangeRequestWF_PVT',
7092: 'Start_Process_Buy_Response_WF',x_progress);
7093: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,
7094: l_preparer_user_name, l_doc_string, sqlerrm,
7095: 'PO_ReqChangeRequestWF_PVT.Inssert_into_History_CHGsubmit');
7096: raise;
7097:

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

7223: x_progress := 'PO_ReqChangeRequestWF_PVT.Insert_Buyer_Action_History: 02';
7224:
7225: EXCEPTION
7226: WHEN OTHERS THEN
7227: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
7228: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
7229: itemType, itemkey);
7230: wf_core.context('PO_ReqChangeRequestWF_PVT',
7231: 'Insert_Buyer_Action_History',x_progress);

Line 7228: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(

7224:
7225: EXCEPTION
7226: WHEN OTHERS THEN
7227: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
7228: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
7229: itemType, itemkey);
7230: wf_core.context('PO_ReqChangeRequestWF_PVT',
7231: 'Insert_Buyer_Action_History',x_progress);
7232: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,

Line 7232: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,

7228: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
7229: itemType, itemkey);
7230: wf_core.context('PO_ReqChangeRequestWF_PVT',
7231: 'Insert_Buyer_Action_History',x_progress);
7232: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,
7233: l_preparer_user_name, l_doc_string, sqlerrm,
7234: 'PO_ReqChangeRequestWF_PVT.Insert_Buyer_Action_History');
7235: raise;
7236:

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

7298: x_progress := 'PO_ReqChangeRequestWF_PVT.Process_Buyer_Rejection: 02';
7299:
7300: EXCEPTION
7301: WHEN OTHERS THEN
7302: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
7303: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
7304: itemType, itemkey);
7305: wf_core.context('PO_ReqChangeRequestWF_PVT',
7306: 'Process_Buyer_Rejection',x_progress);

Line 7303: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(

7299:
7300: EXCEPTION
7301: WHEN OTHERS THEN
7302: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
7303: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
7304: itemType, itemkey);
7305: wf_core.context('PO_ReqChangeRequestWF_PVT',
7306: 'Process_Buyer_Rejection',x_progress);
7307: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,

Line 7307: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,

7303: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
7304: itemType, itemkey);
7305: wf_core.context('PO_ReqChangeRequestWF_PVT',
7306: 'Process_Buyer_Rejection',x_progress);
7307: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,
7308: l_preparer_user_name, l_doc_string, sqlerrm,
7309: 'PO_ReqChangeRequestWF_PVT.Process_Buyer_Rejection');
7310: raise;
7311:

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

7390: x_progress := 'PO_ReqChangeRequestWF_PVT.Process_Cancel_Acceptance: 02';
7391:
7392: EXCEPTION
7393: WHEN OTHERS THEN
7394: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
7395: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
7396: wf_core.context('PO_ReqChangeRequestWF_PVT','Process_Cancel_Acceptance',x_progress);
7397: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Process_Cancel_Acceptance');
7398: raise;

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

7391:
7392: EXCEPTION
7393: WHEN OTHERS THEN
7394: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
7395: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
7396: wf_core.context('PO_ReqChangeRequestWF_PVT','Process_Cancel_Acceptance',x_progress);
7397: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Process_Cancel_Acceptance');
7398: raise;
7399:

Line 7397: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Process_Cancel_Acceptance');

7393: WHEN OTHERS THEN
7394: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
7395: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
7396: wf_core.context('PO_ReqChangeRequestWF_PVT','Process_Cancel_Acceptance',x_progress);
7397: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Process_Cancel_Acceptance');
7398: raise;
7399:
7400:
7401: end Process_Cancel_Acceptance;

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

7468: x_progress := 'PO_ReqChangeRequestWF_PVT.Change_Acceptance_Exists: 02';
7469:
7470: EXCEPTION
7471: WHEN OTHERS THEN
7472: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
7473: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
7474: wf_core.context('PO_ReqChangeRequestWF_PVT','Change_Acceptance_Exists',x_progress);
7475: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Change_Acceptance_Exists');
7476: raise;

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

7469:
7470: EXCEPTION
7471: WHEN OTHERS THEN
7472: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
7473: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
7474: wf_core.context('PO_ReqChangeRequestWF_PVT','Change_Acceptance_Exists',x_progress);
7475: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Change_Acceptance_Exists');
7476: raise;
7477:

Line 7475: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Change_Acceptance_Exists');

7471: WHEN OTHERS THEN
7472: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
7473: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
7474: wf_core.context('PO_ReqChangeRequestWF_PVT','Change_Acceptance_Exists',x_progress);
7475: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Change_Acceptance_Exists');
7476: raise;
7477:
7478:
7479: end Change_Acceptance_Exists;

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

7541: x_progress := 'PO_ReqChangeRequestWF_PVT.Process_Change_Acceptance: 02';
7542:
7543: EXCEPTION
7544: WHEN OTHERS THEN
7545: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
7546: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
7547: wf_core.context('PO_ReqChangeRequestWF_PVT','Process_Change_Acceptance',x_progress);
7548: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Process_Change_Acceptance');
7549: raise;

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

7542:
7543: EXCEPTION
7544: WHEN OTHERS THEN
7545: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
7546: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
7547: wf_core.context('PO_ReqChangeRequestWF_PVT','Process_Change_Acceptance',x_progress);
7548: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Process_Change_Acceptance');
7549: raise;
7550:

Line 7548: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Process_Change_Acceptance');

7544: WHEN OTHERS THEN
7545: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
7546: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
7547: wf_core.context('PO_ReqChangeRequestWF_PVT','Process_Change_Acceptance',x_progress);
7548: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Process_Change_Acceptance');
7549: raise;
7550:
7551:
7552: end Process_Change_Acceptance;

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

7707: x_progress := 'PO_ReqChangeRequestWF_PVT.Start_Poapprv_WF:06';
7708:
7709: EXCEPTION
7710: WHEN OTHERS THEN
7711: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
7712: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
7713: wf_core.context('PO_ReqChangeRequestWF_PVT','Start_Poapprv_WF',x_progress||sqlerrm);
7714: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Start_Poapprv_WF');
7715: raise;

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

7708:
7709: EXCEPTION
7710: WHEN OTHERS THEN
7711: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
7712: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
7713: wf_core.context('PO_ReqChangeRequestWF_PVT','Start_Poapprv_WF',x_progress||sqlerrm);
7714: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Start_Poapprv_WF');
7715: raise;
7716:

Line 7714: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Start_Poapprv_WF');

7710: WHEN OTHERS THEN
7711: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
7712: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
7713: wf_core.context('PO_ReqChangeRequestWF_PVT','Start_Poapprv_WF',x_progress||sqlerrm);
7714: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Start_Poapprv_WF');
7715: raise;
7716:
7717:
7718: end Start_Poapprv_WF;

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

7795: x_progress := 'PO_ReqChangeRequestWF_PVT.Req_Change_Responded: 02';
7796:
7797: EXCEPTION
7798: WHEN OTHERS THEN
7799: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
7800: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
7801: wf_core.context('PO_ReqChangeRequestWF_PVT','Req_Change_Responded',x_progress);
7802: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Req_Change_Responded');
7803: raise;

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

7796:
7797: EXCEPTION
7798: WHEN OTHERS THEN
7799: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
7800: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
7801: wf_core.context('PO_ReqChangeRequestWF_PVT','Req_Change_Responded',x_progress);
7802: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Req_Change_Responded');
7803: raise;
7804:

Line 7802: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Req_Change_Responded');

7798: WHEN OTHERS THEN
7799: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
7800: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
7801: wf_core.context('PO_ReqChangeRequestWF_PVT','Req_Change_Responded',x_progress);
7802: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Req_Change_Responded');
7803: raise;
7804:
7805:
7806: end Req_Change_Responded;

Line 7867: x_progress := 'PO_REQAPPROVAL_INIT1.Reset_Req_Change_Flag: 02';

7863: itemtype => itemtype,
7864: itemkey => itemkey,
7865: aname => 'REQ_HEADER_ID');
7866:
7867: x_progress := 'PO_REQAPPROVAL_INIT1.Reset_Req_Change_Flag: 02';
7868:
7869: SetReqChangeFlag(l_req_change_request_group_id, l_document_id, itemtype, itemkey, 'N');
7870:
7871: --

Line 7875: x_progress := 'PO_REQAPPROVAL_INIT1.Reset_Req_Change_Flag: 03';

7871: --
7872: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
7873: --
7874:
7875: x_progress := 'PO_REQAPPROVAL_INIT1.Reset_Req_Change_Flag: 03';
7876:
7877:
7878: EXCEPTION
7879: WHEN OTHERS THEN

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

7876:
7877:
7878: EXCEPTION
7879: WHEN OTHERS THEN
7880: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
7881: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
7882: wf_core.context('PO_ReqChangeRequestWF_PVT','Reset_Req_Change_Flag',x_progress);
7883: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Reset_Req_Change_Flag');
7884: raise;

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

7877:
7878: EXCEPTION
7879: WHEN OTHERS THEN
7880: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
7881: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
7882: wf_core.context('PO_ReqChangeRequestWF_PVT','Reset_Req_Change_Flag',x_progress);
7883: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Reset_Req_Change_Flag');
7884: raise;
7885:

Line 7883: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Reset_Req_Change_Flag');

7879: WHEN OTHERS THEN
7880: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
7881: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
7882: wf_core.context('PO_ReqChangeRequestWF_PVT','Reset_Req_Change_Flag',x_progress);
7883: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Reset_Req_Change_Flag');
7884: raise;
7885:
7886: END Reset_Req_Change_Flag;
7887:

Line 8177: x_progress := 'PO_REQAPPROVAL_INIT1.Get_Total_Amount_Currency: 04';

8173: t_varval(10) := l_preparer_user_name;
8174:
8175: Wf_Engine.SetItemAttrTextArray(itemtype, itemkey,t_varname,t_varval);
8176:
8177: x_progress := 'PO_REQAPPROVAL_INIT1.Get_Total_Amount_Currency: 04';
8178:
8179: --bug 5379796, if POREQCHA is not available, we need to get notification related
8180: --attributes from other places ( pcr table, po_headers,po_lines etc.)
8181: --Note: three attributes (REQ_AMOUNT_CURRENCY_DSP,TAX_AMOUNT_CURRENCY_DSP, TOTAL_AMOUNT_DSP) are set in StartPOChangeWF before kicking off the 'buyer response' wf,

Line 8309: x_progress := 'PO_REQAPPROVAL_INIT1.Get_Total_Amount_Currency: 02';

8305: --
8306: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
8307: --
8308:
8309: x_progress := 'PO_REQAPPROVAL_INIT1.Get_Total_Amount_Currency: 02';
8310:
8311:
8312: EXCEPTION
8313: WHEN OTHERS THEN

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

8310:
8311:
8312: EXCEPTION
8313: WHEN OTHERS THEN
8314: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
8315: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
8316: wf_core.context('PO_ReqChangeRequestWF_PVT','Get_Total_Amount_Currency',x_progress);
8317: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Get_Total_Amount_Currency');
8318: raise;

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

8311:
8312: EXCEPTION
8313: WHEN OTHERS THEN
8314: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
8315: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
8316: wf_core.context('PO_ReqChangeRequestWF_PVT','Get_Total_Amount_Currency',x_progress);
8317: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Get_Total_Amount_Currency');
8318: raise;
8319:

Line 8317: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Get_Total_Amount_Currency');

8313: WHEN OTHERS THEN
8314: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
8315: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
8316: wf_core.context('PO_ReqChangeRequestWF_PVT','Get_Total_Amount_Currency',x_progress);
8317: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Get_Total_Amount_Currency');
8318: raise;
8319:
8320: END Get_Total_Amount_Currency;
8321:

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

8411: x_progress := 'PO_ReqChangeRequestWF_PVT.REQ_PO_CHANGE_RESPONDED: 02';
8412:
8413: EXCEPTION
8414: WHEN OTHERS THEN
8415: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
8416: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
8417: wf_core.context('PO_ReqChangeRequestWF_PVT','REQ_PO_CHANGE_RESPONDED',x_progress);
8418: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.REQ_PO_CHANGE_RESPONDED');
8419: raise;

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

8412:
8413: EXCEPTION
8414: WHEN OTHERS THEN
8415: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
8416: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
8417: wf_core.context('PO_ReqChangeRequestWF_PVT','REQ_PO_CHANGE_RESPONDED',x_progress);
8418: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.REQ_PO_CHANGE_RESPONDED');
8419: raise;
8420:

Line 8418: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.REQ_PO_CHANGE_RESPONDED');

8414: WHEN OTHERS THEN
8415: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
8416: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
8417: wf_core.context('PO_ReqChangeRequestWF_PVT','REQ_PO_CHANGE_RESPONDED',x_progress);
8418: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.REQ_PO_CHANGE_RESPONDED');
8419: raise;
8420:
8421:
8422: end REQ_PO_CHANGE_RESPONDED;

Line 8528: PO_REQAPPROVAL_INIT1.get_user_name(l_buyer_id, l_buyer_name, l_buyer_display_name);

8524: avalue => l_org_id);
8525:
8526:
8527: -- get Buyer's name
8528: PO_REQAPPROVAL_INIT1.get_user_name(l_buyer_id, l_buyer_name, l_buyer_display_name);
8529:
8530: -- set value of BUYER_USER_NAME WF attribute
8531: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => itemtype,
8532: itemkey => itemkey,

Line 8585: PO_REQAPPROVAL_INIT1.get_user_name(l_requester_id, l_requester_name, l_requester_display_name);

8581: open change_request(l_parent_group_id);
8582: fetch change_request into l_requester_id;
8583: close change_request;
8584:
8585: PO_REQAPPROVAL_INIT1.get_user_name(l_requester_id, l_requester_name, l_requester_display_name);
8586:
8587: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
8588: itemkey => itemkey,
8589: aname => 'PREPARER_USER_NAME',

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

8697: x_progress := 'PO_ReqChangeRequestWF_PVT.New_PO_Change_Exists: 02';
8698:
8699: EXCEPTION
8700: WHEN OTHERS THEN
8701: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
8702: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
8703: wf_core.context('PO_ReqChangeRequestWF_PVT','New_PO_Change_Exists',x_progress);
8704: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.New_PO_Change_Exists');
8705: raise;

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

8698:
8699: EXCEPTION
8700: WHEN OTHERS THEN
8701: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
8702: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
8703: wf_core.context('PO_ReqChangeRequestWF_PVT','New_PO_Change_Exists',x_progress);
8704: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.New_PO_Change_Exists');
8705: raise;
8706:

Line 8704: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.New_PO_Change_Exists');

8700: WHEN OTHERS THEN
8701: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
8702: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
8703: wf_core.context('PO_ReqChangeRequestWF_PVT','New_PO_Change_Exists',x_progress);
8704: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.New_PO_Change_Exists');
8705: raise;
8706:
8707:
8708: end New_PO_Change_Exists;

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

8763: x_progress := 'PO_ReqChangeRequestWF_PVT.Record_PO_Approval: 02';
8764:
8765: EXCEPTION
8766: WHEN OTHERS THEN
8767: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
8768: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
8769: wf_core.context('PO_ReqChangeRequestWF_PVT','Record_PO_Approval',x_progress);
8770: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Record_PO_Approval');
8771: raise;

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

8764:
8765: EXCEPTION
8766: WHEN OTHERS THEN
8767: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
8768: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
8769: wf_core.context('PO_ReqChangeRequestWF_PVT','Record_PO_Approval',x_progress);
8770: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Record_PO_Approval');
8771: raise;
8772:

Line 8770: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Record_PO_Approval');

8766: WHEN OTHERS THEN
8767: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
8768: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
8769: wf_core.context('PO_ReqChangeRequestWF_PVT','Record_PO_Approval',x_progress);
8770: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Record_PO_Approval');
8771: raise;
8772:
8773:
8774: end Record_PO_Approval;

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

8829: x_progress := 'PO_ReqChangeRequestWF_PVT.Record_PO_Rejection: 02';
8830:
8831: EXCEPTION
8832: WHEN OTHERS THEN
8833: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
8834: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
8835: wf_core.context('PO_ReqChangeRequestWF_PVT','Record_PO_Rejection',x_progress);
8836: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Record_PO_Rejection');
8837: raise;

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

8830:
8831: EXCEPTION
8832: WHEN OTHERS THEN
8833: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
8834: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
8835: wf_core.context('PO_ReqChangeRequestWF_PVT','Record_PO_Rejection',x_progress);
8836: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Record_PO_Rejection');
8837: raise;
8838:

Line 8836: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Record_PO_Rejection');

8832: WHEN OTHERS THEN
8833: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
8834: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
8835: wf_core.context('PO_ReqChangeRequestWF_PVT','Record_PO_Rejection',x_progress);
8836: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Record_PO_Rejection');
8837: raise;
8838:
8839:
8840: end Record_PO_Rejection;

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

8898: x_progress := 'PO_ReqChangeRequestWF_PVT.Validate_Chg_Against_New_PO: 02';
8899:
8900: EXCEPTION
8901: WHEN OTHERS THEN
8902: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
8903: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
8904: wf_core.context('PO_ReqChangeRequestWF_PVT','Validate_Chg_Against_New_PO',x_progress);
8905: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Validate_Chg_Against_New_PO'); raise;
8906:

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

8899:
8900: EXCEPTION
8901: WHEN OTHERS THEN
8902: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
8903: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
8904: wf_core.context('PO_ReqChangeRequestWF_PVT','Validate_Chg_Against_New_PO',x_progress);
8905: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Validate_Chg_Against_New_PO'); raise;
8906:
8907:

Line 8905: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Validate_Chg_Against_New_PO'); raise;

8901: WHEN OTHERS THEN
8902: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
8903: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
8904: wf_core.context('PO_ReqChangeRequestWF_PVT','Validate_Chg_Against_New_PO',x_progress);
8905: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Validate_Chg_Against_New_PO'); raise;
8906:
8907:
8908: end Validate_Chg_Against_New_PO;
8909:

Line 9217: * it will call PO_REQAPPROVAL_INIT1.Start_WF_Process to start

9213: * called. If the change request is valid, the validation API
9214: * will call this procedure to submit the request and start
9215: * workflow to process the request.
9216: *
9217: * it will call PO_REQAPPROVAL_INIT1.Start_WF_Process to start
9218: * the workflow
9219: *
9220: * Returns:
9221: ************************************************************************/

Line 9273: PO_REQAPPROVAL_INIT1.Start_WF_Process(

9269: into l_preparer_id, l_req_num
9270: from po_requisition_headers_all
9271: where requisition_header_id= p_req_header_id;
9272:
9273: PO_REQAPPROVAL_INIT1.Start_WF_Process(
9274: ItemType => p_item_type,
9275: ItemKey => p_item_key,
9276: WorkflowProcess => p_workflow_process,
9277: ActionOriginatedFrom => p_interface_source_code,

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

10051: x_progress := 'PO_ReqChangeRequestWF_PVT.Set_Buyer_Approval_Notfn_Attr: 05';
10052:
10053: EXCEPTION
10054: WHEN OTHERS THEN
10055: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
10056: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
10057: itemType, itemkey);
10058: wf_core.context('PO_ReqChangeRequestWF_PVT','Set_Buyer_Approval_Notfn_Attr',
10059: x_progress);

Line 10056: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(

10052:
10053: EXCEPTION
10054: WHEN OTHERS THEN
10055: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
10056: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
10057: itemType, itemkey);
10058: wf_core.context('PO_ReqChangeRequestWF_PVT','Set_Buyer_Approval_Notfn_Attr',
10059: x_progress);
10060: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,

Line 10060: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,

10056: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
10057: itemType, itemkey);
10058: wf_core.context('PO_ReqChangeRequestWF_PVT','Set_Buyer_Approval_Notfn_Attr',
10059: x_progress);
10060: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,
10061: l_preparer_user_name, l_doc_string, sqlerrm,
10062: 'PO_ReqChangeRequestWF_PVT.Set_Buyer_Approval_Notfn_Attr');
10063: raise;
10064:

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

10264: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
10265:
10266: EXCEPTION
10267: WHEN OTHERS THEN
10268: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
10269: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
10270: wf_core.context('PO_ReqChangeRequestWF_PVT','Start_POChange_WF',x_progress);
10271: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Start_POChange_WF');
10272: raise;

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

10265:
10266: EXCEPTION
10267: WHEN OTHERS THEN
10268: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
10269: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
10270: wf_core.context('PO_ReqChangeRequestWF_PVT','Start_POChange_WF',x_progress);
10271: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Start_POChange_WF');
10272: raise;
10273:

Line 10271: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Start_POChange_WF');

10267: WHEN OTHERS THEN
10268: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
10269: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
10270: wf_core.context('PO_ReqChangeRequestWF_PVT','Start_POChange_WF',x_progress);
10271: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Start_POChange_WF');
10272: raise;
10273:
10274: END Start_POChange_WF;
10275:

Line 10580: PO_REQAPPROVAL_INIT1.get_user_name(l_buyer_id, l_buyer_name, l_buyer_display_name);

10576:
10577: l_progress := 'PO_ReqChangeRequestWF_PVT.Accept_Po_Changes: 04';
10578:
10579: -- get Buyer's name
10580: PO_REQAPPROVAL_INIT1.get_user_name(l_buyer_id, l_buyer_name, l_buyer_display_name);
10581:
10582: -- set value of BUYER_USER_NAME WF attribute
10583: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => itemtype,
10584: itemkey => itemkey,

Line 11793: * it will call PO_REQAPPROVAL_INIT1.Start_WF_Process to start

11789: * called. If the change request is valid, the validation API
11790: * will call this procedure to submit the request and start
11791: * workflow to process the request.
11792: *
11793: * it will call PO_REQAPPROVAL_INIT1.Start_WF_Process to start
11794: * the workflow
11795: *
11796: * Returns:
11797: ************************************************************************/

Line 11925: po_reqapproval_init1.start_wf_process(

11921: po_debug.debug_var(l_log_head,l_progress,'l_req_num',l_req_num );
11922: po_debug.debug_stmt(l_log_head, l_progress,'Starting POREQCHA workflow');
11923: END IF;
11924:
11925: po_reqapproval_init1.start_wf_process(
11926: itemtype => p_item_type,
11927: itemkey => p_item_key,
11928: workflowprocess => p_workflow_process,
11929: actionoriginatedfrom => p_interface_source_code,

Line 12133: l_doc_string := po_reqapproval_init1.get_error_doc(itemtype, itemkey);

12129: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
12130:
12131: EXCEPTION
12132: WHEN OTHERS THEN
12133: l_doc_string := po_reqapproval_init1.get_error_doc(itemtype, itemkey);
12134: l_preparer_user_name := po_reqapproval_init1.get_preparer_user_name(itemtype, itemkey);
12135: wf_core.context('PO_ReqChangeRequestWF_PVT', 'Convert_Into_sO_Change', x_progress);
12136: po_reqapproval_init1.send_error_notif(itemtype, itemkey, l_preparer_user_name, l_doc_string, SQLERRM, 'PO_ReqChangeRequestWF_PVT.Convert_Into_sO_Change'||l_return_status||l_return_msg);
12137: RAISE;

Line 12134: l_preparer_user_name := po_reqapproval_init1.get_preparer_user_name(itemtype, itemkey);

12130:
12131: EXCEPTION
12132: WHEN OTHERS THEN
12133: l_doc_string := po_reqapproval_init1.get_error_doc(itemtype, itemkey);
12134: l_preparer_user_name := po_reqapproval_init1.get_preparer_user_name(itemtype, itemkey);
12135: wf_core.context('PO_ReqChangeRequestWF_PVT', 'Convert_Into_sO_Change', x_progress);
12136: po_reqapproval_init1.send_error_notif(itemtype, itemkey, l_preparer_user_name, l_doc_string, SQLERRM, 'PO_ReqChangeRequestWF_PVT.Convert_Into_sO_Change'||l_return_status||l_return_msg);
12137: RAISE;
12138:

Line 12136: po_reqapproval_init1.send_error_notif(itemtype, itemkey, l_preparer_user_name, l_doc_string, SQLERRM, 'PO_ReqChangeRequestWF_PVT.Convert_Into_sO_Change'||l_return_status||l_return_msg);

12132: WHEN OTHERS THEN
12133: l_doc_string := po_reqapproval_init1.get_error_doc(itemtype, itemkey);
12134: l_preparer_user_name := po_reqapproval_init1.get_preparer_user_name(itemtype, itemkey);
12135: wf_core.context('PO_ReqChangeRequestWF_PVT', 'Convert_Into_sO_Change', x_progress);
12136: po_reqapproval_init1.send_error_notif(itemtype, itemkey, l_preparer_user_name, l_doc_string, SQLERRM, 'PO_ReqChangeRequestWF_PVT.Convert_Into_sO_Change'||l_return_status||l_return_msg);
12137: RAISE;
12138:
12139: END convert_into_so_change;
12140:

Line 13203: l_doc_string := po_reqapproval_init1.get_error_doc(itemtype, itemkey);

13199: END IF;
13200:
13201: EXCEPTION
13202: WHEN OTHERS THEN
13203: l_doc_string := po_reqapproval_init1.get_error_doc(itemtype, itemkey);
13204: l_preparer_user_name := po_reqapproval_init1.get_preparer_user_name(
13205: itemtype, itemkey);
13206: wf_core.context('PO_REQ_CHANGE_WF', 'SEND_INTERNAL_NOTIF', x_progress);
13207: po_reqapproval_init1.send_error_notif(itemtype, itemkey,

Line 13204: l_preparer_user_name := po_reqapproval_init1.get_preparer_user_name(

13200:
13201: EXCEPTION
13202: WHEN OTHERS THEN
13203: l_doc_string := po_reqapproval_init1.get_error_doc(itemtype, itemkey);
13204: l_preparer_user_name := po_reqapproval_init1.get_preparer_user_name(
13205: itemtype, itemkey);
13206: wf_core.context('PO_REQ_CHANGE_WF', 'SEND_INTERNAL_NOTIF', x_progress);
13207: po_reqapproval_init1.send_error_notif(itemtype, itemkey,
13208: l_preparer_user_name, l_doc_string,

Line 13207: po_reqapproval_init1.send_error_notif(itemtype, itemkey,

13203: l_doc_string := po_reqapproval_init1.get_error_doc(itemtype, itemkey);
13204: l_preparer_user_name := po_reqapproval_init1.get_preparer_user_name(
13205: itemtype, itemkey);
13206: wf_core.context('PO_REQ_CHANGE_WF', 'SEND_INTERNAL_NOTIF', x_progress);
13207: po_reqapproval_init1.send_error_notif(itemtype, itemkey,
13208: l_preparer_user_name, l_doc_string,
13209: SQLERRM,
13210: 'PO_REQ_CHANGE_WF.SEND_INTERNAL_NOTIF');
13211: RAISE;

Line 13273: l_doc_string := po_reqapproval_init1.get_error_doc(itemtype, itemkey);

13269: END IF;
13270:
13271: EXCEPTION
13272: WHEN OTHERS THEN
13273: l_doc_string := po_reqapproval_init1.get_error_doc(itemtype, itemkey);
13274: l_preparer_user_name := po_reqapproval_init1.get_preparer_user_name(
13275: itemtype, itemkey);
13276: wf_core.context('PO_REQ_CHANGE_WF', 'NEXT_INTERNAL_NOTIF', x_progress);
13277: po_reqapproval_init1.send_error_notif(itemtype, itemkey,

Line 13274: l_preparer_user_name := po_reqapproval_init1.get_preparer_user_name(

13270:
13271: EXCEPTION
13272: WHEN OTHERS THEN
13273: l_doc_string := po_reqapproval_init1.get_error_doc(itemtype, itemkey);
13274: l_preparer_user_name := po_reqapproval_init1.get_preparer_user_name(
13275: itemtype, itemkey);
13276: wf_core.context('PO_REQ_CHANGE_WF', 'NEXT_INTERNAL_NOTIF', x_progress);
13277: po_reqapproval_init1.send_error_notif(itemtype, itemkey,
13278: l_preparer_user_name, l_doc_string,

Line 13277: po_reqapproval_init1.send_error_notif(itemtype, itemkey,

13273: l_doc_string := po_reqapproval_init1.get_error_doc(itemtype, itemkey);
13274: l_preparer_user_name := po_reqapproval_init1.get_preparer_user_name(
13275: itemtype, itemkey);
13276: wf_core.context('PO_REQ_CHANGE_WF', 'NEXT_INTERNAL_NOTIF', x_progress);
13277: po_reqapproval_init1.send_error_notif(itemtype, itemkey,
13278: l_preparer_user_name, l_doc_string,
13279: SQLERRM,
13280: 'PO_REQ_CHANGE_WF.NEXT_INTERNAL_NOTIF');
13281: RAISE;