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 4147: PO_REQAPPROVAL_INIT1.get_user_name(l_requester_id, l_requester_name, l_requester_display_name);

4143: itemkey => item_key,
4144: process => 'CONVERT_INTO_PO_REQUEST');
4145: x_progress :='StartConvertProcess:004';
4146:
4147: PO_REQAPPROVAL_INIT1.get_user_name(l_requester_id, l_requester_name, l_requester_display_name);
4148: x_progress :='StartConvertProcess:005';
4149:
4150: n_varname(1) := 'CHANGE_REQUEST_GROUP_ID';
4151: n_varval(1) := p_change_request_group_id;

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

4430: message => 'change_request_group_id:' ||to_char(p_change_request_group_id) || '-after creating workflow');
4431: END IF;
4432: END IF;
4433:
4434: PO_REQAPPROVAL_INIT1.get_user_name(l_agent_id, l_buyer_name, l_buyer_display_name);
4435: PO_REQAPPROVAL_INIT1.get_user_name(l_preparer_id, l_preparer_username, l_preparer_display_name);
4436: x_progress :='StartPOChangeWF:005';
4437:
4438: open get_parent_group_id_csr(p_change_request_group_id);

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

4431: END IF;
4432: END IF;
4433:
4434: PO_REQAPPROVAL_INIT1.get_user_name(l_agent_id, l_buyer_name, l_buyer_display_name);
4435: PO_REQAPPROVAL_INIT1.get_user_name(l_preparer_id, l_preparer_username, l_preparer_display_name);
4436: x_progress :='StartPOChangeWF:005';
4437:
4438: open get_parent_group_id_csr(p_change_request_group_id);
4439: fetch get_parent_group_id_csr into l_parent_group_id;

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

4813: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
4814:
4815: EXCEPTION
4816: WHEN OTHERS THEN
4817: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
4818: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
4819: wf_core.context('PO_ReqChangeRequestWF_PVT','Get_Req_Chg_Attributes',x_progress);
4820: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Get_Req_Chg_Attributes');
4821: raise;

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

4814:
4815: EXCEPTION
4816: WHEN OTHERS THEN
4817: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
4818: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
4819: wf_core.context('PO_ReqChangeRequestWF_PVT','Get_Req_Chg_Attributes',x_progress);
4820: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Get_Req_Chg_Attributes');
4821: raise;
4822:

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

4816: WHEN OTHERS THEN
4817: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
4818: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
4819: wf_core.context('PO_ReqChangeRequestWF_PVT','Get_Req_Chg_Attributes',x_progress);
4820: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Get_Req_Chg_Attributes');
4821: raise;
4822:
4823:
4824: end Get_Req_Chg_Attributes;

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

4888: --
4889: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
4890: --
4891:
4892: x_progress := 'PO_REQAPPROVAL_INIT1.Update_Req_Change_Flag: 02';
4893:
4894:
4895: EXCEPTION
4896: WHEN OTHERS THEN

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

4893:
4894:
4895: EXCEPTION
4896: WHEN OTHERS THEN
4897: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
4898: l_preparer_user_name := PO_REQAPPROVAL_INIT1.
4899: get_preparer_user_name(itemType, itemkey);
4900: wf_core.context('PO_ReqChangeRequestWF_PVT',
4901: 'Update_Req_Change_Flag',x_progress);

Line 4898: l_preparer_user_name := PO_REQAPPROVAL_INIT1.

4894:
4895: EXCEPTION
4896: WHEN OTHERS THEN
4897: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
4898: l_preparer_user_name := PO_REQAPPROVAL_INIT1.
4899: get_preparer_user_name(itemType, itemkey);
4900: wf_core.context('PO_ReqChangeRequestWF_PVT',
4901: 'Update_Req_Change_Flag',x_progress);
4902: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,

Line 4902: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,

4898: l_preparer_user_name := PO_REQAPPROVAL_INIT1.
4899: get_preparer_user_name(itemType, itemkey);
4900: wf_core.context('PO_ReqChangeRequestWF_PVT',
4901: 'Update_Req_Change_Flag',x_progress);
4902: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,
4903: l_preparer_user_name, l_doc_string,
4904: sqlerrm, 'PO_ReqChangeRequestWF_PVT.Update_Req_Change_Flag');
4905: raise;
4906:

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

5019: x_progress := 'PO_ReqChangeRequestWF_PVT.Insert_into_History_CHGsubmit: 07';
5020:
5021: EXCEPTION
5022: WHEN OTHERS THEN
5023: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
5024: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
5025: itemType, itemkey);
5026: wf_core.context('PO_ReqChangeRequestWF_PVT',
5027: 'Insert_into_History_CHGsubmit',x_progress||sqlerrm);

Line 5024: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(

5020:
5021: EXCEPTION
5022: WHEN OTHERS THEN
5023: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
5024: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
5025: itemType, itemkey);
5026: wf_core.context('PO_ReqChangeRequestWF_PVT',
5027: 'Insert_into_History_CHGsubmit',x_progress||sqlerrm);
5028: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,

Line 5028: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,

5024: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
5025: itemType, itemkey);
5026: wf_core.context('PO_ReqChangeRequestWF_PVT',
5027: 'Insert_into_History_CHGsubmit',x_progress||sqlerrm);
5028: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,
5029: l_preparer_user_name, l_doc_string, sqlerrm,
5030: 'PO_ReqChangeRequestWF_PVT.Insert_into_History_CHGsubmit');
5031: raise;
5032:

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

5096:
5097:
5098: EXCEPTION
5099: WHEN OTHERS THEN
5100: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
5101: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
5102: itemType, itemkey);
5103: wf_core.context('PO_REQ_CHANGE_WF','APPROVAL_NEEDED',x_progress);
5104: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,

Line 5101: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(

5097:
5098: EXCEPTION
5099: WHEN OTHERS THEN
5100: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
5101: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
5102: itemType, itemkey);
5103: wf_core.context('PO_REQ_CHANGE_WF','APPROVAL_NEEDED',x_progress);
5104: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,
5105: l_preparer_user_name, l_doc_string,

Line 5104: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,

5100: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
5101: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
5102: itemType, itemkey);
5103: wf_core.context('PO_REQ_CHANGE_WF','APPROVAL_NEEDED',x_progress);
5104: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,
5105: l_preparer_user_name, l_doc_string,
5106: sqlerrm,
5107: 'PO_REQ_CHANGE_WF.Req_Change_Needs_Approval');
5108: raise;

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

5158:
5159:
5160: EXCEPTION
5161: WHEN OTHERS THEN
5162: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
5163: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
5164: itemType, itemkey);
5165: wf_core.context('PO_REQ_CHANGE_WF','Set_Change_Mgr_Pre_App',x_progress);
5166: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,

Line 5163: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(

5159:
5160: EXCEPTION
5161: WHEN OTHERS THEN
5162: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
5163: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
5164: itemType, itemkey);
5165: wf_core.context('PO_REQ_CHANGE_WF','Set_Change_Mgr_Pre_App',x_progress);
5166: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,
5167: l_preparer_user_name, l_doc_string,

Line 5166: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,

5162: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
5163: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
5164: itemType, itemkey);
5165: wf_core.context('PO_REQ_CHANGE_WF','Set_Change_Mgr_Pre_App',x_progress);
5166: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,
5167: l_preparer_user_name, l_doc_string,
5168: sqlerrm, 'PO_REQ_CHANGE_WF.Set_Change_Mgr_Pre_App');
5169: raise;
5170:

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

5217: x_progress := 'PO_ReqChangeRequestWF_PVT.Set_Change_Mgr_App: 02';
5218:
5219: EXCEPTION
5220: WHEN OTHERS THEN
5221: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
5222: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
5223: itemType, itemkey);
5224: wf_core.context('PO_REQ_CHANGE_WF','Set_Change_Mgr_App',x_progress);
5225: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,

Line 5222: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(

5218:
5219: EXCEPTION
5220: WHEN OTHERS THEN
5221: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
5222: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
5223: itemType, itemkey);
5224: wf_core.context('PO_REQ_CHANGE_WF','Set_Change_Mgr_App',x_progress);
5225: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,
5226: l_preparer_user_name, l_doc_string, sqlerrm,

Line 5225: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,

5221: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
5222: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
5223: itemType, itemkey);
5224: wf_core.context('PO_REQ_CHANGE_WF','Set_Change_Mgr_App',x_progress);
5225: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,
5226: l_preparer_user_name, l_doc_string, sqlerrm,
5227: 'PO_REQ_CHANGE_WF.Set_Change_Mgr_App');
5228: raise;
5229:

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

5281:
5282:
5283: EXCEPTION
5284: WHEN OTHERS THEN
5285: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
5286: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
5287: wf_core.context('PO_REQ_CHANGE_WF','Set_Change_Rejected',x_progress);
5288: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQ_CHANGE_WF.Set_Change_Rejected');
5289: raise;

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

5282:
5283: EXCEPTION
5284: WHEN OTHERS THEN
5285: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
5286: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
5287: wf_core.context('PO_REQ_CHANGE_WF','Set_Change_Rejected',x_progress);
5288: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQ_CHANGE_WF.Set_Change_Rejected');
5289: raise;
5290:

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

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

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

5362: x_progress := 'PO_ReqChangeRequestWF_PVT.Is_Chg_Mgr_Pre_App: 02';
5363:
5364: EXCEPTION
5365: WHEN OTHERS THEN
5366: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
5367: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
5368: wf_core.context('PO_ReqChangeRequestWF_PVT','Is_Chg_Mgr_Pre_App',x_progress);
5369: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Is_Chg_Mgr_Pre_App');
5370: raise;

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

5363:
5364: EXCEPTION
5365: WHEN OTHERS THEN
5366: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
5367: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
5368: wf_core.context('PO_ReqChangeRequestWF_PVT','Is_Chg_Mgr_Pre_App',x_progress);
5369: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Is_Chg_Mgr_Pre_App');
5370: raise;
5371:

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

5365: WHEN OTHERS THEN
5366: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
5367: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
5368: wf_core.context('PO_ReqChangeRequestWF_PVT','Is_Chg_Mgr_Pre_App',x_progress);
5369: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Is_Chg_Mgr_Pre_App');
5370: raise;
5371:
5372:
5373: end Is_Chg_Mgr_Pre_App;

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

5517: x_progress := 'PO_ReqChangeRequestWF_PVT.Start_From_PO_Cancel: 02';
5518:
5519: EXCEPTION
5520: WHEN OTHERS THEN
5521: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
5522: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
5523: wf_core.context('PO_ReqChangeRequestWF_PVT','Start_From_PO_Cancel',x_progress);
5524: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Start_From_PO_Cancel');
5525: raise;

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

5518:
5519: EXCEPTION
5520: WHEN OTHERS THEN
5521: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
5522: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
5523: wf_core.context('PO_ReqChangeRequestWF_PVT','Start_From_PO_Cancel',x_progress);
5524: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Start_From_PO_Cancel');
5525: raise;
5526:

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

5520: WHEN OTHERS THEN
5521: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
5522: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
5523: wf_core.context('PO_ReqChangeRequestWF_PVT','Start_From_PO_Cancel',x_progress);
5524: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Start_From_PO_Cancel');
5525: raise;
5526:
5527:
5528: end Start_From_PO_Cancel;

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

5597: x_progress := 'PO_ReqChangeRequestWF_PVT.Change_Request_Mgr_Approved: 02';
5598:
5599: EXCEPTION
5600: WHEN OTHERS THEN
5601: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
5602: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
5603: wf_core.context('PO_ReqChangeRequestWF_PVT','Change_Request_Mgr_Approved',x_progress);
5604: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Change_Request_Mgr_Approved');
5605: raise;

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

5598:
5599: EXCEPTION
5600: WHEN OTHERS THEN
5601: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
5602: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
5603: wf_core.context('PO_ReqChangeRequestWF_PVT','Change_Request_Mgr_Approved',x_progress);
5604: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Change_Request_Mgr_Approved');
5605: raise;
5606:

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

5600: WHEN OTHERS THEN
5601: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
5602: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
5603: wf_core.context('PO_ReqChangeRequestWF_PVT','Change_Request_Mgr_Approved',x_progress);
5604: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Change_Request_Mgr_Approved');
5605: raise;
5606:
5607:
5608: end Change_Request_Mgr_Approved;

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

5861: l_progress := 'Update_Action_History_App_Rej: 999';
5862:
5863: EXCEPTION
5864: WHEN OTHERS THEN
5865: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
5866: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
5867: wf_core.context('PO_ReqChangeRequestWF_PVT','Update_Action_History_App_Rej',l_progress,sqlerrm);
5868: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Update_Action_History_App_Rej');
5869: RAISE;

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

5862:
5863: EXCEPTION
5864: WHEN OTHERS THEN
5865: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
5866: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
5867: wf_core.context('PO_ReqChangeRequestWF_PVT','Update_Action_History_App_Rej',l_progress,sqlerrm);
5868: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Update_Action_History_App_Rej');
5869: RAISE;
5870:

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

5864: WHEN OTHERS THEN
5865: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
5866: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
5867: wf_core.context('PO_ReqChangeRequestWF_PVT','Update_Action_History_App_Rej',l_progress,sqlerrm);
5868: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Update_Action_History_App_Rej');
5869: RAISE;
5870:
5871: END Update_Action_History_App_Rej;
5872:

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

5957: l_progress := 'Update_Action_History_Return: 999';
5958:
5959: EXCEPTION
5960: WHEN OTHERS THEN
5961: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
5962: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
5963: wf_core.context('PO_ReqChangeRequestWF_PVT','Update_Action_History_Return',l_progress,sqlerrm);
5964: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Update_Action_History_Return');
5965: RAISE;

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

5958:
5959: EXCEPTION
5960: WHEN OTHERS THEN
5961: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
5962: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
5963: wf_core.context('PO_ReqChangeRequestWF_PVT','Update_Action_History_Return',l_progress,sqlerrm);
5964: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Update_Action_History_Return');
5965: RAISE;
5966:

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

5960: WHEN OTHERS THEN
5961: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
5962: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
5963: wf_core.context('PO_ReqChangeRequestWF_PVT','Update_Action_History_Return',l_progress,sqlerrm);
5964: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Update_Action_History_Return');
5965: RAISE;
5966:
5967: END Update_Action_History_Return;
5968:

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

6087:
6088:
6089: EXCEPTION
6090: WHEN OTHERS THEN
6091: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
6092: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
6093: wf_core.context('PO_ReqChangeRequestWF_PVT','Kickoff_POChange_WF',x_progress);
6094: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Kickoff_POChange_WF');
6095: raise;

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

6088:
6089: EXCEPTION
6090: WHEN OTHERS THEN
6091: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
6092: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
6093: wf_core.context('PO_ReqChangeRequestWF_PVT','Kickoff_POChange_WF',x_progress);
6094: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Kickoff_POChange_WF');
6095: raise;
6096:

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

6090: WHEN OTHERS THEN
6091: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
6092: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
6093: wf_core.context('PO_ReqChangeRequestWF_PVT','Kickoff_POChange_WF',x_progress);
6094: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Kickoff_POChange_WF');
6095: raise;
6096:
6097: END Kickoff_POChange_WF;
6098:

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

6158: --
6159: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
6160: --
6161:
6162: x_progress := 'PO_REQAPPROVAL_INIT1.Reset_Change_Flag: 02';
6163:
6164:
6165: EXCEPTION
6166: WHEN OTHERS THEN

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

6163:
6164:
6165: EXCEPTION
6166: WHEN OTHERS THEN
6167: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
6168: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
6169: wf_core.context('PO_ReqChangeRequestWF_PVT','Reset_Change_Flag',x_progress);
6170: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Reset_Change_Flag');
6171: raise;

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

6164:
6165: EXCEPTION
6166: WHEN OTHERS THEN
6167: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
6168: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
6169: wf_core.context('PO_ReqChangeRequestWF_PVT','Reset_Change_Flag',x_progress);
6170: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Reset_Change_Flag');
6171: raise;
6172:

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

6166: WHEN OTHERS THEN
6167: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
6168: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
6169: wf_core.context('PO_ReqChangeRequestWF_PVT','Reset_Change_Flag',x_progress);
6170: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Reset_Change_Flag');
6171: raise;
6172:
6173: END Reset_Change_Flag;
6174:

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

6462: x_progress := 'PO_ReqChangeRequestWF_PVT.Is_Doc_Approved: 02';
6463:
6464: EXCEPTION
6465: WHEN OTHERS THEN
6466: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
6467: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
6468: itemType, itemkey);
6469: wf_core.context('PO_ReqChangeRequestWF_PVT','Is_Doc_Approved',
6470: x_progress);

Line 6467: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(

6463:
6464: EXCEPTION
6465: WHEN OTHERS THEN
6466: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
6467: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
6468: itemType, itemkey);
6469: wf_core.context('PO_ReqChangeRequestWF_PVT','Is_Doc_Approved',
6470: x_progress);
6471: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,

Line 6471: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,

6467: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
6468: itemType, itemkey);
6469: wf_core.context('PO_ReqChangeRequestWF_PVT','Is_Doc_Approved',
6470: x_progress);
6471: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,
6472: l_preparer_user_name, l_doc_string, sqlerrm,
6473: 'PO_ReqChangeRequestWF_PVT.Is_Doc_Approved');
6474: raise;
6475:

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

6539: x_progress := 'PO_ReqChangeRequestWF_PVT.Set_Doc_In_Process: 02';
6540:
6541: EXCEPTION
6542: WHEN OTHERS THEN
6543: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
6544: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
6545: itemType, itemkey);
6546: wf_core.context('PO_ReqChangeRequestWF_PVT',
6547: 'Set_Doc_In_Process',x_progress);

Line 6544: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(

6540:
6541: EXCEPTION
6542: WHEN OTHERS THEN
6543: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
6544: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
6545: itemType, itemkey);
6546: wf_core.context('PO_ReqChangeRequestWF_PVT',
6547: 'Set_Doc_In_Process',x_progress);
6548: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,

Line 6548: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,

6544: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
6545: itemType, itemkey);
6546: wf_core.context('PO_ReqChangeRequestWF_PVT',
6547: 'Set_Doc_In_Process',x_progress);
6548: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,
6549: l_preparer_user_name, l_doc_string, sqlerrm,
6550: 'PO_ReqChangeRequestWF_PVT.Set_Doc_In_Process');
6551: raise;
6552:

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

6634: x_progress := 'PO_ReqChangeRequestWF_PVT.Compare_Revision: 02';
6635:
6636: EXCEPTION
6637: WHEN OTHERS THEN
6638: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
6639: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
6640: itemType, itemkey);
6641: wf_core.context('PO_ReqChangeRequestWF_PVT',
6642: 'Compare_Revision',x_progress||sqlerrm);

Line 6639: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(

6635:
6636: EXCEPTION
6637: WHEN OTHERS THEN
6638: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
6639: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
6640: itemType, itemkey);
6641: wf_core.context('PO_ReqChangeRequestWF_PVT',
6642: 'Compare_Revision',x_progress||sqlerrm);
6643: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,

Line 6643: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,

6639: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
6640: itemType, itemkey);
6641: wf_core.context('PO_ReqChangeRequestWF_PVT',
6642: 'Compare_Revision',x_progress||sqlerrm);
6643: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,
6644: l_preparer_user_name, l_doc_string, sqlerrm,
6645: 'PO_ReqChangeRequestWF_PVT.Compare_Revision');
6646: raise;
6647: end Compare_Revision;

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

6708: x_progress := 'PO_ReqChangeRequestWF_PVT.Record_Buyer_Rejection: 02';
6709:
6710: EXCEPTION
6711: WHEN OTHERS THEN
6712: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
6713: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
6714: itemType, itemkey);
6715: wf_core.context('PO_ReqChangeRequestWF_PVT',
6716: 'Record_Buyer_Rejection',x_progress);

Line 6713: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(

6709:
6710: EXCEPTION
6711: WHEN OTHERS THEN
6712: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
6713: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
6714: itemType, itemkey);
6715: wf_core.context('PO_ReqChangeRequestWF_PVT',
6716: 'Record_Buyer_Rejection',x_progress);
6717: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,

Line 6717: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,

6713: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
6714: itemType, itemkey);
6715: wf_core.context('PO_ReqChangeRequestWF_PVT',
6716: 'Record_Buyer_Rejection',x_progress);
6717: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,
6718: l_preparer_user_name, l_doc_string, sqlerrm,
6719: 'PO_ReqChangeRequestWF_PVT.Record_Buyer_Rejection');
6720: raise;
6721:

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

6782: x_progress := 'PO_ReqChangeRequestWF_PVT.Record_Buyer_Acceptance: 02';
6783:
6784: EXCEPTION
6785: WHEN OTHERS THEN
6786: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
6787: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
6788: itemType, itemkey);
6789: wf_core.context('PO_ReqChangeRequestWF_PVT',
6790: 'Record_Buyer_Acceptance',x_progress);

Line 6787: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(

6783:
6784: EXCEPTION
6785: WHEN OTHERS THEN
6786: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
6787: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
6788: itemType, itemkey);
6789: wf_core.context('PO_ReqChangeRequestWF_PVT',
6790: 'Record_Buyer_Acceptance',x_progress);
6791: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,

Line 6791: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,

6787: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
6788: itemType, itemkey);
6789: wf_core.context('PO_ReqChangeRequestWF_PVT',
6790: 'Record_Buyer_Acceptance',x_progress);
6791: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,
6792: l_preparer_user_name, l_doc_string, sqlerrm,
6793: 'PO_ReqChangeRequestWF_PVT.Record_Buyer_Acceptance');
6794: raise;
6795:

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

6851: x_progress := 'PO_ReqChangeRequestWF_PVT.Start_Process_Buy_Response_WF: 02';
6852:
6853: EXCEPTION
6854: WHEN OTHERS THEN
6855: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
6856: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
6857: itemType, itemkey);
6858: wf_core.context('PO_ReqChangeRequestWF_PVT',
6859: 'Start_Process_Buy_Response_WF',x_progress);

Line 6856: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(

6852:
6853: EXCEPTION
6854: WHEN OTHERS THEN
6855: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
6856: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
6857: itemType, itemkey);
6858: wf_core.context('PO_ReqChangeRequestWF_PVT',
6859: 'Start_Process_Buy_Response_WF',x_progress);
6860: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,

Line 6860: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,

6856: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
6857: itemType, itemkey);
6858: wf_core.context('PO_ReqChangeRequestWF_PVT',
6859: 'Start_Process_Buy_Response_WF',x_progress);
6860: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,
6861: l_preparer_user_name, l_doc_string, sqlerrm,
6862: 'PO_ReqChangeRequestWF_PVT.Inssert_into_History_CHGsubmit');
6863: raise;
6864:

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

6986: x_progress := 'PO_ReqChangeRequestWF_PVT.Insert_Buyer_Action_History: 02';
6987:
6988: EXCEPTION
6989: WHEN OTHERS THEN
6990: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
6991: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
6992: itemType, itemkey);
6993: wf_core.context('PO_ReqChangeRequestWF_PVT',
6994: 'Insert_Buyer_Action_History',x_progress);

Line 6991: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(

6987:
6988: EXCEPTION
6989: WHEN OTHERS THEN
6990: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
6991: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
6992: itemType, itemkey);
6993: wf_core.context('PO_ReqChangeRequestWF_PVT',
6994: 'Insert_Buyer_Action_History',x_progress);
6995: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,

Line 6995: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,

6991: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
6992: itemType, itemkey);
6993: wf_core.context('PO_ReqChangeRequestWF_PVT',
6994: 'Insert_Buyer_Action_History',x_progress);
6995: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,
6996: l_preparer_user_name, l_doc_string, sqlerrm,
6997: 'PO_ReqChangeRequestWF_PVT.Insert_Buyer_Action_History');
6998: raise;
6999:

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

7061: x_progress := 'PO_ReqChangeRequestWF_PVT.Process_Buyer_Rejection: 02';
7062:
7063: EXCEPTION
7064: WHEN OTHERS THEN
7065: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
7066: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
7067: itemType, itemkey);
7068: wf_core.context('PO_ReqChangeRequestWF_PVT',
7069: 'Process_Buyer_Rejection',x_progress);

Line 7066: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(

7062:
7063: EXCEPTION
7064: WHEN OTHERS THEN
7065: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
7066: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
7067: itemType, itemkey);
7068: wf_core.context('PO_ReqChangeRequestWF_PVT',
7069: 'Process_Buyer_Rejection',x_progress);
7070: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,

Line 7070: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,

7066: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
7067: itemType, itemkey);
7068: wf_core.context('PO_ReqChangeRequestWF_PVT',
7069: 'Process_Buyer_Rejection',x_progress);
7070: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,
7071: l_preparer_user_name, l_doc_string, sqlerrm,
7072: 'PO_ReqChangeRequestWF_PVT.Process_Buyer_Rejection');
7073: raise;
7074:

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

7153: x_progress := 'PO_ReqChangeRequestWF_PVT.Process_Cancel_Acceptance: 02';
7154:
7155: EXCEPTION
7156: WHEN OTHERS THEN
7157: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
7158: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
7159: wf_core.context('PO_ReqChangeRequestWF_PVT','Process_Cancel_Acceptance',x_progress);
7160: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Process_Cancel_Acceptance');
7161: raise;

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

7154:
7155: EXCEPTION
7156: WHEN OTHERS THEN
7157: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
7158: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
7159: wf_core.context('PO_ReqChangeRequestWF_PVT','Process_Cancel_Acceptance',x_progress);
7160: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Process_Cancel_Acceptance');
7161: raise;
7162:

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

7156: WHEN OTHERS THEN
7157: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
7158: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
7159: wf_core.context('PO_ReqChangeRequestWF_PVT','Process_Cancel_Acceptance',x_progress);
7160: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Process_Cancel_Acceptance');
7161: raise;
7162:
7163:
7164: end Process_Cancel_Acceptance;

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

7231: x_progress := 'PO_ReqChangeRequestWF_PVT.Change_Acceptance_Exists: 02';
7232:
7233: EXCEPTION
7234: WHEN OTHERS THEN
7235: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
7236: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
7237: wf_core.context('PO_ReqChangeRequestWF_PVT','Change_Acceptance_Exists',x_progress);
7238: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Change_Acceptance_Exists');
7239: raise;

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

7232:
7233: EXCEPTION
7234: WHEN OTHERS THEN
7235: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
7236: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
7237: wf_core.context('PO_ReqChangeRequestWF_PVT','Change_Acceptance_Exists',x_progress);
7238: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Change_Acceptance_Exists');
7239: raise;
7240:

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

7234: WHEN OTHERS THEN
7235: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
7236: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
7237: wf_core.context('PO_ReqChangeRequestWF_PVT','Change_Acceptance_Exists',x_progress);
7238: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Change_Acceptance_Exists');
7239: raise;
7240:
7241:
7242: end Change_Acceptance_Exists;

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

7304: x_progress := 'PO_ReqChangeRequestWF_PVT.Process_Change_Acceptance: 02';
7305:
7306: EXCEPTION
7307: WHEN OTHERS THEN
7308: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
7309: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
7310: wf_core.context('PO_ReqChangeRequestWF_PVT','Process_Change_Acceptance',x_progress);
7311: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Process_Change_Acceptance');
7312: raise;

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

7305:
7306: EXCEPTION
7307: WHEN OTHERS THEN
7308: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
7309: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
7310: wf_core.context('PO_ReqChangeRequestWF_PVT','Process_Change_Acceptance',x_progress);
7311: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Process_Change_Acceptance');
7312: raise;
7313:

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

7307: WHEN OTHERS THEN
7308: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
7309: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
7310: wf_core.context('PO_ReqChangeRequestWF_PVT','Process_Change_Acceptance',x_progress);
7311: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Process_Change_Acceptance');
7312: raise;
7313:
7314:
7315: end Process_Change_Acceptance;

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

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

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

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

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

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

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

7558: x_progress := 'PO_ReqChangeRequestWF_PVT.Req_Change_Responded: 02';
7559:
7560: EXCEPTION
7561: WHEN OTHERS THEN
7562: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
7563: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
7564: wf_core.context('PO_ReqChangeRequestWF_PVT','Req_Change_Responded',x_progress);
7565: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Req_Change_Responded');
7566: raise;

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

7559:
7560: EXCEPTION
7561: WHEN OTHERS THEN
7562: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
7563: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
7564: wf_core.context('PO_ReqChangeRequestWF_PVT','Req_Change_Responded',x_progress);
7565: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Req_Change_Responded');
7566: raise;
7567:

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

7561: WHEN OTHERS THEN
7562: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
7563: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
7564: wf_core.context('PO_ReqChangeRequestWF_PVT','Req_Change_Responded',x_progress);
7565: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Req_Change_Responded');
7566: raise;
7567:
7568:
7569: end Req_Change_Responded;

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

7626: itemtype => itemtype,
7627: itemkey => itemkey,
7628: aname => 'REQ_HEADER_ID');
7629:
7630: x_progress := 'PO_REQAPPROVAL_INIT1.Reset_Req_Change_Flag: 02';
7631:
7632: SetReqChangeFlag(l_req_change_request_group_id, l_document_id, itemtype, itemkey, 'N');
7633:
7634: --

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

7634: --
7635: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
7636: --
7637:
7638: x_progress := 'PO_REQAPPROVAL_INIT1.Reset_Req_Change_Flag: 03';
7639:
7640:
7641: EXCEPTION
7642: WHEN OTHERS THEN

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

7639:
7640:
7641: EXCEPTION
7642: WHEN OTHERS THEN
7643: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
7644: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
7645: wf_core.context('PO_ReqChangeRequestWF_PVT','Reset_Req_Change_Flag',x_progress);
7646: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Reset_Req_Change_Flag');
7647: raise;

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

7640:
7641: EXCEPTION
7642: WHEN OTHERS THEN
7643: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
7644: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
7645: wf_core.context('PO_ReqChangeRequestWF_PVT','Reset_Req_Change_Flag',x_progress);
7646: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Reset_Req_Change_Flag');
7647: raise;
7648:

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

7642: WHEN OTHERS THEN
7643: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
7644: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
7645: wf_core.context('PO_ReqChangeRequestWF_PVT','Reset_Req_Change_Flag',x_progress);
7646: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Reset_Req_Change_Flag');
7647: raise;
7648:
7649: END Reset_Req_Change_Flag;
7650:

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

7887: t_varval(10) := l_preparer_user_name;
7888:
7889: Wf_Engine.SetItemAttrTextArray(itemtype, itemkey,t_varname,t_varval);
7890:
7891: x_progress := 'PO_REQAPPROVAL_INIT1.Get_Total_Amount_Currency: 04';
7892:
7893: --bug 5379796, if POREQCHA is not available, we need to get notification related
7894: --attributes from other places ( pcr table, po_headers,po_lines etc.)
7895: --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 7993: x_progress := 'PO_REQAPPROVAL_INIT1.Get_Total_Amount_Currency: 02';

7989: --
7990: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
7991: --
7992:
7993: x_progress := 'PO_REQAPPROVAL_INIT1.Get_Total_Amount_Currency: 02';
7994:
7995:
7996: EXCEPTION
7997: WHEN OTHERS THEN

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

7994:
7995:
7996: EXCEPTION
7997: WHEN OTHERS THEN
7998: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
7999: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
8000: wf_core.context('PO_ReqChangeRequestWF_PVT','Get_Total_Amount_Currency',x_progress);
8001: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Get_Total_Amount_Currency');
8002: raise;

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

7995:
7996: EXCEPTION
7997: WHEN OTHERS THEN
7998: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
7999: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
8000: wf_core.context('PO_ReqChangeRequestWF_PVT','Get_Total_Amount_Currency',x_progress);
8001: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Get_Total_Amount_Currency');
8002: raise;
8003:

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

7997: WHEN OTHERS THEN
7998: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
7999: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
8000: wf_core.context('PO_ReqChangeRequestWF_PVT','Get_Total_Amount_Currency',x_progress);
8001: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Get_Total_Amount_Currency');
8002: raise;
8003:
8004: END Get_Total_Amount_Currency;
8005:

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

8095: x_progress := 'PO_ReqChangeRequestWF_PVT.REQ_PO_CHANGE_RESPONDED: 02';
8096:
8097: EXCEPTION
8098: WHEN OTHERS THEN
8099: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
8100: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
8101: wf_core.context('PO_ReqChangeRequestWF_PVT','REQ_PO_CHANGE_RESPONDED',x_progress);
8102: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.REQ_PO_CHANGE_RESPONDED');
8103: raise;

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

8096:
8097: EXCEPTION
8098: WHEN OTHERS THEN
8099: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
8100: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
8101: wf_core.context('PO_ReqChangeRequestWF_PVT','REQ_PO_CHANGE_RESPONDED',x_progress);
8102: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.REQ_PO_CHANGE_RESPONDED');
8103: raise;
8104:

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

8098: WHEN OTHERS THEN
8099: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
8100: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
8101: wf_core.context('PO_ReqChangeRequestWF_PVT','REQ_PO_CHANGE_RESPONDED',x_progress);
8102: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.REQ_PO_CHANGE_RESPONDED');
8103: raise;
8104:
8105:
8106: end REQ_PO_CHANGE_RESPONDED;

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

8206: open change_request(l_parent_group_id);
8207: fetch change_request into l_requester_id;
8208: close change_request;
8209:
8210: PO_REQAPPROVAL_INIT1.get_user_name(l_requester_id, l_requester_name, l_requester_display_name);
8211:
8212: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
8213: itemkey => itemkey,
8214: aname => 'PREPARER_USER_NAME',

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

8310: x_progress := 'PO_ReqChangeRequestWF_PVT.New_PO_Change_Exists: 02';
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','New_PO_Change_Exists',x_progress);
8317: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.New_PO_Change_Exists');
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','New_PO_Change_Exists',x_progress);
8317: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.New_PO_Change_Exists');
8318: raise;
8319:

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

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','New_PO_Change_Exists',x_progress);
8317: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.New_PO_Change_Exists');
8318: raise;
8319:
8320:
8321: end New_PO_Change_Exists;

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

8376: x_progress := 'PO_ReqChangeRequestWF_PVT.Record_PO_Approval: 02';
8377:
8378: EXCEPTION
8379: WHEN OTHERS THEN
8380: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
8381: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
8382: wf_core.context('PO_ReqChangeRequestWF_PVT','Record_PO_Approval',x_progress);
8383: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Record_PO_Approval');
8384: raise;

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

8377:
8378: EXCEPTION
8379: WHEN OTHERS THEN
8380: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
8381: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
8382: wf_core.context('PO_ReqChangeRequestWF_PVT','Record_PO_Approval',x_progress);
8383: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Record_PO_Approval');
8384: raise;
8385:

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

8379: WHEN OTHERS THEN
8380: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
8381: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
8382: wf_core.context('PO_ReqChangeRequestWF_PVT','Record_PO_Approval',x_progress);
8383: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Record_PO_Approval');
8384: raise;
8385:
8386:
8387: end Record_PO_Approval;

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

8442: x_progress := 'PO_ReqChangeRequestWF_PVT.Record_PO_Rejection: 02';
8443:
8444: EXCEPTION
8445: WHEN OTHERS THEN
8446: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
8447: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
8448: wf_core.context('PO_ReqChangeRequestWF_PVT','Record_PO_Rejection',x_progress);
8449: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Record_PO_Rejection');
8450: raise;

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

8443:
8444: EXCEPTION
8445: WHEN OTHERS THEN
8446: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
8447: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
8448: wf_core.context('PO_ReqChangeRequestWF_PVT','Record_PO_Rejection',x_progress);
8449: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Record_PO_Rejection');
8450: raise;
8451:

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

8445: WHEN OTHERS THEN
8446: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
8447: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
8448: wf_core.context('PO_ReqChangeRequestWF_PVT','Record_PO_Rejection',x_progress);
8449: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Record_PO_Rejection');
8450: raise;
8451:
8452:
8453: end Record_PO_Rejection;

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

8511: x_progress := 'PO_ReqChangeRequestWF_PVT.Validate_Chg_Against_New_PO: 02';
8512:
8513: EXCEPTION
8514: WHEN OTHERS THEN
8515: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
8516: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
8517: wf_core.context('PO_ReqChangeRequestWF_PVT','Validate_Chg_Against_New_PO',x_progress);
8518: 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;
8519:

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

8512:
8513: EXCEPTION
8514: WHEN OTHERS THEN
8515: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
8516: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
8517: wf_core.context('PO_ReqChangeRequestWF_PVT','Validate_Chg_Against_New_PO',x_progress);
8518: 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;
8519:
8520:

Line 8518: 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;

8514: WHEN OTHERS THEN
8515: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
8516: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
8517: wf_core.context('PO_ReqChangeRequestWF_PVT','Validate_Chg_Against_New_PO',x_progress);
8518: 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;
8519:
8520:
8521: end Validate_Chg_Against_New_PO;
8522:

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

8826: * called. If the change request is valid, the validation API
8827: * will call this procedure to submit the request and start
8828: * workflow to process the request.
8829: *
8830: * it will call PO_REQAPPROVAL_INIT1.Start_WF_Process to start
8831: * the workflow
8832: *
8833: * Returns:
8834: ************************************************************************/

Line 8886: PO_REQAPPROVAL_INIT1.Start_WF_Process(

8882: into l_preparer_id, l_req_num
8883: from po_requisition_headers_all
8884: where requisition_header_id= p_req_header_id;
8885:
8886: PO_REQAPPROVAL_INIT1.Start_WF_Process(
8887: ItemType => p_item_type,
8888: ItemKey => p_item_key,
8889: WorkflowProcess => p_workflow_process,
8890: ActionOriginatedFrom => p_interface_source_code,

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

9664: x_progress := 'PO_ReqChangeRequestWF_PVT.Set_Buyer_Approval_Notfn_Attr: 05';
9665:
9666: EXCEPTION
9667: WHEN OTHERS THEN
9668: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
9669: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
9670: itemType, itemkey);
9671: wf_core.context('PO_ReqChangeRequestWF_PVT','Set_Buyer_Approval_Notfn_Attr',
9672: x_progress);

Line 9669: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(

9665:
9666: EXCEPTION
9667: WHEN OTHERS THEN
9668: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
9669: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
9670: itemType, itemkey);
9671: wf_core.context('PO_ReqChangeRequestWF_PVT','Set_Buyer_Approval_Notfn_Attr',
9672: x_progress);
9673: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,

Line 9673: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,

9669: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(
9670: itemType, itemkey);
9671: wf_core.context('PO_ReqChangeRequestWF_PVT','Set_Buyer_Approval_Notfn_Attr',
9672: x_progress);
9673: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey,
9674: l_preparer_user_name, l_doc_string, sqlerrm,
9675: 'PO_ReqChangeRequestWF_PVT.Set_Buyer_Approval_Notfn_Attr');
9676: raise;
9677:

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

9877: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
9878:
9879: EXCEPTION
9880: WHEN OTHERS THEN
9881: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
9882: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
9883: wf_core.context('PO_ReqChangeRequestWF_PVT','Start_POChange_WF',x_progress);
9884: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Start_POChange_WF');
9885: raise;

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

9878:
9879: EXCEPTION
9880: WHEN OTHERS THEN
9881: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
9882: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
9883: wf_core.context('PO_ReqChangeRequestWF_PVT','Start_POChange_WF',x_progress);
9884: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Start_POChange_WF');
9885: raise;
9886:

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

9880: WHEN OTHERS THEN
9881: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
9882: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
9883: wf_core.context('PO_ReqChangeRequestWF_PVT','Start_POChange_WF',x_progress);
9884: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Start_POChange_WF');
9885: raise;
9886:
9887: END Start_POChange_WF;
9888:

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

10189:
10190: l_progress := 'PO_ReqChangeRequestWF_PVT.Accept_Po_Changes: 04';
10191:
10192: -- get Buyer's name
10193: PO_REQAPPROVAL_INIT1.get_user_name(l_buyer_id, l_buyer_name, l_buyer_display_name);
10194:
10195: -- set value of BUYER_USER_NAME WF attribute
10196: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => itemtype,
10197: itemkey => itemkey,

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

11385: * called. If the change request is valid, the validation API
11386: * will call this procedure to submit the request and start
11387: * workflow to process the request.
11388: *
11389: * it will call PO_REQAPPROVAL_INIT1.Start_WF_Process to start
11390: * the workflow
11391: *
11392: * Returns:
11393: ************************************************************************/

Line 11512: po_reqapproval_init1.start_wf_process(

11508: po_debug.debug_var(l_log_head,l_progress,'l_req_num',l_req_num );
11509: po_debug.debug_stmt(l_log_head, l_progress,'Starting POREQCHA workflow');
11510: END IF;
11511:
11512: po_reqapproval_init1.start_wf_process(
11513: itemtype => p_item_type,
11514: itemkey => p_item_key,
11515: workflowprocess => p_workflow_process,
11516: actionoriginatedfrom => p_interface_source_code,

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

11701: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
11702:
11703: EXCEPTION
11704: WHEN OTHERS THEN
11705: l_doc_string := po_reqapproval_init1.get_error_doc(itemtype, itemkey);
11706: l_preparer_user_name := po_reqapproval_init1.get_preparer_user_name(itemtype, itemkey);
11707: wf_core.context('PO_ReqChangeRequestWF_PVT', 'Convert_Into_sO_Change', x_progress);
11708: 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);
11709: RAISE;

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

11702:
11703: EXCEPTION
11704: WHEN OTHERS THEN
11705: l_doc_string := po_reqapproval_init1.get_error_doc(itemtype, itemkey);
11706: l_preparer_user_name := po_reqapproval_init1.get_preparer_user_name(itemtype, itemkey);
11707: wf_core.context('PO_ReqChangeRequestWF_PVT', 'Convert_Into_sO_Change', x_progress);
11708: 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);
11709: RAISE;
11710:

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

11704: WHEN OTHERS THEN
11705: l_doc_string := po_reqapproval_init1.get_error_doc(itemtype, itemkey);
11706: l_preparer_user_name := po_reqapproval_init1.get_preparer_user_name(itemtype, itemkey);
11707: wf_core.context('PO_ReqChangeRequestWF_PVT', 'Convert_Into_sO_Change', x_progress);
11708: 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);
11709: RAISE;
11710:
11711: END convert_into_so_change;
11712:

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

12607: END IF;
12608:
12609: EXCEPTION
12610: WHEN OTHERS THEN
12611: l_doc_string := po_reqapproval_init1.get_error_doc(itemtype, itemkey);
12612: l_preparer_user_name := po_reqapproval_init1.get_preparer_user_name(
12613: itemtype, itemkey);
12614: wf_core.context('PO_REQ_CHANGE_WF', 'SEND_INTERNAL_NOTIF', x_progress);
12615: po_reqapproval_init1.send_error_notif(itemtype, itemkey,

Line 12612: l_preparer_user_name := po_reqapproval_init1.get_preparer_user_name(

12608:
12609: EXCEPTION
12610: WHEN OTHERS THEN
12611: l_doc_string := po_reqapproval_init1.get_error_doc(itemtype, itemkey);
12612: l_preparer_user_name := po_reqapproval_init1.get_preparer_user_name(
12613: itemtype, itemkey);
12614: wf_core.context('PO_REQ_CHANGE_WF', 'SEND_INTERNAL_NOTIF', x_progress);
12615: po_reqapproval_init1.send_error_notif(itemtype, itemkey,
12616: l_preparer_user_name, l_doc_string,

Line 12615: po_reqapproval_init1.send_error_notif(itemtype, itemkey,

12611: l_doc_string := po_reqapproval_init1.get_error_doc(itemtype, itemkey);
12612: l_preparer_user_name := po_reqapproval_init1.get_preparer_user_name(
12613: itemtype, itemkey);
12614: wf_core.context('PO_REQ_CHANGE_WF', 'SEND_INTERNAL_NOTIF', x_progress);
12615: po_reqapproval_init1.send_error_notif(itemtype, itemkey,
12616: l_preparer_user_name, l_doc_string,
12617: SQLERRM,
12618: 'PO_REQ_CHANGE_WF.SEND_INTERNAL_NOTIF');
12619: RAISE;

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

12677: END IF;
12678:
12679: EXCEPTION
12680: WHEN OTHERS THEN
12681: l_doc_string := po_reqapproval_init1.get_error_doc(itemtype, itemkey);
12682: l_preparer_user_name := po_reqapproval_init1.get_preparer_user_name(
12683: itemtype, itemkey);
12684: wf_core.context('PO_REQ_CHANGE_WF', 'NEXT_INTERNAL_NOTIF', x_progress);
12685: po_reqapproval_init1.send_error_notif(itemtype, itemkey,

Line 12682: l_preparer_user_name := po_reqapproval_init1.get_preparer_user_name(

12678:
12679: EXCEPTION
12680: WHEN OTHERS THEN
12681: l_doc_string := po_reqapproval_init1.get_error_doc(itemtype, itemkey);
12682: l_preparer_user_name := po_reqapproval_init1.get_preparer_user_name(
12683: itemtype, itemkey);
12684: wf_core.context('PO_REQ_CHANGE_WF', 'NEXT_INTERNAL_NOTIF', x_progress);
12685: po_reqapproval_init1.send_error_notif(itemtype, itemkey,
12686: l_preparer_user_name, l_doc_string,

Line 12685: po_reqapproval_init1.send_error_notif(itemtype, itemkey,

12681: l_doc_string := po_reqapproval_init1.get_error_doc(itemtype, itemkey);
12682: l_preparer_user_name := po_reqapproval_init1.get_preparer_user_name(
12683: itemtype, itemkey);
12684: wf_core.context('PO_REQ_CHANGE_WF', 'NEXT_INTERNAL_NOTIF', x_progress);
12685: po_reqapproval_init1.send_error_notif(itemtype, itemkey,
12686: l_preparer_user_name, l_doc_string,
12687: SQLERRM,
12688: 'PO_REQ_CHANGE_WF.NEXT_INTERNAL_NOTIF');
12689: RAISE;