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 WF_CORE

Line 696: wf_core.context('PO_ReqChangeRequestWF_PVT',

692: where change_request_id=
693: p_po_change_requests(i).parent_change_request_id;
694: end loop;
695: when others then
696: wf_core.context('PO_ReqChangeRequestWF_PVT',
697: 'ValidateAndSaveRequest',x_progress||sqlerrm);
698: raise;
699: end ValidateAndSaveRequest;
700:

Line 760: wf_core.context('PO_ReqChangeRequestWF_PVT',

756: where requisition_line_id=p_req_line_id;
757: x_progress :='002';
758: exception
759: when others then
760: wf_core.context('PO_ReqChangeRequestWF_PVT',
761: 'UpdateReqDistribution',x_progress||sqlerrm);
762: raise;
763: end UpdateReqDistribution;
764:

Line 833: wf_core.context('PO_ReqChangeRequestWF_PVT','UpdateReqLine',x_progress||sqlerrm);

829: where requisition_line_id=p_req_line_id;
830: x_progress :='005-';
831: EXCEPTION
832: WHEN OTHERS THEN
833: wf_core.context('PO_ReqChangeRequestWF_PVT','UpdateReqLine',x_progress||sqlerrm);
834: raise;
835:
836: end UpdateReqLine;
837:

Line 1568: wf_core.context('PO_ReqChangeRequestWF_PVT','ValidateChgAgainstNewPO',x_progress||sqlerrm);

1564: -- commit;
1565:
1566: exception
1567: when others then
1568: wf_core.context('PO_ReqChangeRequestWF_PVT','ValidateChgAgainstNewPO',x_progress||sqlerrm);
1569: raise;
1570: end ValidateChgAgainstNewPO;
1571:
1572:

Line 2438: wf_core.context('PO_ReqChangeRequestWF_PVT','ProcessBuyerAction',x_progress||sqlerrm);

2434: commit;
2435:
2436: EXCEPTION
2437: WHEN OTHERS THEN
2438: wf_core.context('PO_ReqChangeRequestWF_PVT','ProcessBuyerAction',x_progress||sqlerrm);
2439: raise;
2440:
2441: END ProcessBuyerAction;
2442:

Line 2808: wf_core.context('PO_ReqChangeRequestWF_PVT','ProcessSCOAcceptance',x_progress||sqlerrm);

2804: commit;
2805:
2806: EXCEPTION
2807: WHEN OTHERS THEN
2808: wf_core.context('PO_ReqChangeRequestWF_PVT','ProcessSCOAcceptance',x_progress||sqlerrm);
2809: raise;
2810:
2811: END ProcessSCOAcceptance;
2812: /*************************************************************************

Line 2849: wf_core.context('PO_ReqChangeRequestWF_PVT','SetPoRequestStatus',sqlerrm);

2845: commit;
2846:
2847: EXCEPTION
2848: WHEN OTHERS THEN
2849: wf_core.context('PO_ReqChangeRequestWF_PVT','SetPoRequestStatus',sqlerrm);
2850: raise;
2851:
2852: END SetPoRequestStatus;
2853:

Line 3479: wf_core.context('PO_ReqChangeRequestWF_PVT','ConvertIntoPOChange',x_progress);

3475: commit;
3476:
3477: EXCEPTION
3478: WHEN OTHERS THEN
3479: wf_core.context('PO_ReqChangeRequestWF_PVT','ConvertIntoPOChange',x_progress);
3480: raise;
3481:
3482: END ConvertIntoPOChange;
3483:

Line 3582: wf_core.context('PO_ReqChangeRequestWF_PVT','SetReqRequestStatus',x_progress);

3578: commit;
3579:
3580: EXCEPTION
3581: WHEN OTHERS THEN
3582: wf_core.context('PO_ReqChangeRequestWF_PVT','SetReqRequestStatus',x_progress);
3583: raise;
3584:
3585: END SetReqRequestStatus;
3586:

Line 3632: wf_core.context('PO_ReqChangeRequestWF_PVT','SetReqChangeFlag',x_progress);

3628: commit;
3629:
3630: EXCEPTION
3631: WHEN OTHERS THEN
3632: wf_core.context('PO_ReqChangeRequestWF_PVT','SetReqChangeFlag',x_progress);
3633: raise;
3634:
3635: END SetReqChangeFlag;
3636:

Line 3876: wf_core.context('PO_ReqChangeRequestWF_PVT',

3872: */
3873: commit;
3874: EXCEPTION
3875: WHEN OTHERS THEN
3876: wf_core.context('PO_ReqChangeRequestWF_PVT',
3877: 'InsertActionHist'||sqlerrm,x_progress);
3878: raise;
3879:
3880: END InsertActionHist;

Line 3937: wf_core.context('PO_REQ_CHANGE_WF','SetPOAuthStat',x_progress);

3933: commit;
3934:
3935: EXCEPTION
3936: WHEN OTHERS THEN
3937: wf_core.context('PO_REQ_CHANGE_WF','SetPOAuthStat',x_progress);
3938: raise;
3939:
3940: END SetPOAuthStat;
3941:

Line 3994: wf_core.context('PO_REQ_CHANGE_WF','SetRelAuthStat',x_progress);

3990: commit;
3991:
3992: EXCEPTION
3993: WHEN OTHERS THEN
3994: wf_core.context('PO_REQ_CHANGE_WF','SetRelAuthStat',x_progress);
3995: raise;
3996:
3997: END SetRelAuthStat;
3998:

Line 4065: wf_core.context('PO_ReqChangeRequestWF_PVT','StartInformBuyerWF',x_progress);

4061: StartPOChangeWF(p_change_request_group_id, item_key, 'INFORM_BUYER_PO_CHANGE', l_forward_from_username, l_user_id, l_responsibility_id, l_application_id);
4062: x_progress :='StartInformBuyerWF:002';
4063: EXCEPTION
4064: WHEN OTHERS THEN
4065: wf_core.context('PO_ReqChangeRequestWF_PVT','StartInformBuyerWF',x_progress);
4066:
4067: raise;
4068:
4069: end StartInformBuyerWF;

Line 4231: wf_core.context('PO_ReqChangeRequestWF_PVT','StartConvertProcess',x_progress);

4227: x_progress :='StartConvertProcess:008';
4228: commit;
4229: EXCEPTION
4230: WHEN OTHERS THEN
4231: wf_core.context('PO_ReqChangeRequestWF_PVT','StartConvertProcess',x_progress);
4232:
4233: raise;
4234: end StartConvertProcess;
4235:

Line 4688: wf_core.context('PO_ReqChangeRequestWF_PVT','StartPOChangeWF',x_progress||sqlerrm);

4684: message => l_procedure_name||'-'|| x_progress|| ' ' || sqlerrm);
4685: END IF;
4686: END IF;
4687:
4688: wf_core.context('PO_ReqChangeRequestWF_PVT','StartPOChangeWF',x_progress||sqlerrm);
4689: raise;
4690: end StartPOChangeWF;
4691:
4692:

Line 4720: wf_core.context('PO_ReqChangeRequestWF_PVT','UpdatePODocHeaderTables',x_progress|| sqlerrm);

4716: commit;
4717:
4718: EXCEPTION
4719: WHEN OTHERS THEN
4720: wf_core.context('PO_ReqChangeRequestWF_PVT','UpdatePODocHeaderTables',x_progress|| sqlerrm);
4721: raise;
4722: END UpdatePODocHeaderTables;
4723:
4724:

Line 4819: wf_core.context('PO_ReqChangeRequestWF_PVT','Get_Req_Chg_Attributes',x_progress);

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

Line 4900: wf_core.context('PO_ReqChangeRequestWF_PVT',

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,
4903: l_preparer_user_name, l_doc_string,
4904: sqlerrm, 'PO_ReqChangeRequestWF_PVT.Update_Req_Change_Flag');

Line 5026: wf_core.context('PO_ReqChangeRequestWF_PVT',

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,
5029: l_preparer_user_name, l_doc_string, sqlerrm,
5030: 'PO_ReqChangeRequestWF_PVT.Insert_into_History_CHGsubmit');

Line 5103: wf_core.context('PO_REQ_CHANGE_WF','APPROVAL_NEEDED',x_progress);

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,
5106: sqlerrm,
5107: 'PO_REQ_CHANGE_WF.Req_Change_Needs_Approval');

Line 5165: wf_core.context('PO_REQ_CHANGE_WF','Set_Change_Mgr_Pre_App',x_progress);

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,
5168: sqlerrm, 'PO_REQ_CHANGE_WF.Set_Change_Mgr_Pre_App');
5169: raise;

Line 5224: wf_core.context('PO_REQ_CHANGE_WF','Set_Change_Mgr_App',x_progress);

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,
5227: 'PO_REQ_CHANGE_WF.Set_Change_Mgr_App');
5228: raise;

Line 5287: wf_core.context('PO_REQ_CHANGE_WF','Set_Change_Rejected',x_progress);

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:
5291: END Set_Change_Rejected;

Line 5368: wf_core.context('PO_ReqChangeRequestWF_PVT','Is_Chg_Mgr_Pre_App',x_progress);

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

Line 5401: wf_core.context('PO_ReqChangeRequestWF_PVT','Reset_Reminder_Counter',x_progress);

5397: avalue => 0);
5398: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
5399:
5400: exception when others then
5401: wf_core.context('PO_ReqChangeRequestWF_PVT','Reset_Reminder_Counter',x_progress);
5402: raise;
5403: END Reset_Reminder_Counter;
5404:
5405:

Line 5464: wf_core.context('PO_ReqChangeRequestWF_PVT','Reminder_Need_To_Be_Sent',x_progress);

5460: end if;
5461: end if;
5462:
5463: exception when others then
5464: wf_core.context('PO_ReqChangeRequestWF_PVT','Reminder_Need_To_Be_Sent',x_progress);
5465: raise;
5466: END Reminder_Need_To_Be_Sent;
5467:
5468:

Line 5523: wf_core.context('PO_ReqChangeRequestWF_PVT','Start_From_PO_Cancel',x_progress);

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

Line 5603: wf_core.context('PO_ReqChangeRequestWF_PVT','Change_Request_Mgr_Approved',x_progress);

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

Line 5867: wf_core.context('PO_ReqChangeRequestWF_PVT','Update_Action_History_App_Rej',l_progress,sqlerrm);

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:
5871: END Update_Action_History_App_Rej;

Line 5963: wf_core.context('PO_ReqChangeRequestWF_PVT','Update_Action_History_Return',l_progress,sqlerrm);

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:
5967: END Update_Action_History_Return;

Line 6093: wf_core.context('PO_ReqChangeRequestWF_PVT','Kickoff_POChange_WF',x_progress);

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:
6097: END Kickoff_POChange_WF;

Line 6169: wf_core.context('PO_ReqChangeRequestWF_PVT','Reset_Change_Flag',x_progress);

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:
6173: END Reset_Change_Flag;

Line 6224: wf_core.context('PO_ReqChangeRequestWF_PVT','Get_Change_Total_Attr',x_progress);

6220:
6221: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED' ;
6222:
6223: exception when others then
6224: wf_core.context('PO_ReqChangeRequestWF_PVT','Get_Change_Total_Attr',x_progress);
6225: raise;
6226: END Get_Change_Total_Attr;
6227:
6228: procedure setNewTotal(itemtype in varchar2, itemkey in varchar2) is

Line 6373: wf_core.context('PO_ReqChangeRequestWF_PVT','setNewTotal',x_progress||sqlerrm);

6369: avalue => l_amount_for_subject);
6370: x_progress :='004';
6371: exception
6372: when others then
6373: wf_core.context('PO_ReqChangeRequestWF_PVT','setNewTotal',x_progress||sqlerrm);
6374: raise;
6375:
6376: end setNewTotal;
6377:

Line 6469: wf_core.context('PO_ReqChangeRequestWF_PVT','Is_Doc_Approved',

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,
6472: l_preparer_user_name, l_doc_string, sqlerrm,
6473: 'PO_ReqChangeRequestWF_PVT.Is_Doc_Approved');

Line 6546: wf_core.context('PO_ReqChangeRequestWF_PVT',

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,
6549: l_preparer_user_name, l_doc_string, sqlerrm,
6550: 'PO_ReqChangeRequestWF_PVT.Set_Doc_In_Process');

Line 6641: wf_core.context('PO_ReqChangeRequestWF_PVT',

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,
6644: l_preparer_user_name, l_doc_string, sqlerrm,
6645: 'PO_ReqChangeRequestWF_PVT.Compare_Revision');

Line 6715: wf_core.context('PO_ReqChangeRequestWF_PVT',

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,
6718: l_preparer_user_name, l_doc_string, sqlerrm,
6719: 'PO_ReqChangeRequestWF_PVT.Record_Buyer_Rejection');

Line 6789: wf_core.context('PO_ReqChangeRequestWF_PVT',

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,
6792: l_preparer_user_name, l_doc_string, sqlerrm,
6793: 'PO_ReqChangeRequestWF_PVT.Record_Buyer_Acceptance');

Line 6858: wf_core.context('PO_ReqChangeRequestWF_PVT',

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,
6861: l_preparer_user_name, l_doc_string, sqlerrm,
6862: 'PO_ReqChangeRequestWF_PVT.Inssert_into_History_CHGsubmit');

Line 6993: wf_core.context('PO_ReqChangeRequestWF_PVT',

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,
6996: l_preparer_user_name, l_doc_string, sqlerrm,
6997: 'PO_ReqChangeRequestWF_PVT.Insert_Buyer_Action_History');

Line 7068: wf_core.context('PO_ReqChangeRequestWF_PVT',

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,
7071: l_preparer_user_name, l_doc_string, sqlerrm,
7072: 'PO_ReqChangeRequestWF_PVT.Process_Buyer_Rejection');

Line 7159: wf_core.context('PO_ReqChangeRequestWF_PVT','Process_Cancel_Acceptance',x_progress);

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

Line 7237: wf_core.context('PO_ReqChangeRequestWF_PVT','Change_Acceptance_Exists',x_progress);

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

Line 7310: wf_core.context('PO_ReqChangeRequestWF_PVT','Process_Change_Acceptance',x_progress);

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

Line 7343: wf_core.context('PO_ReqChangeRequestWF_PVT','KickOffPOApproval',sqlerrm);

7339: commit;
7340: end if;
7341: exception
7342: when others then
7343: wf_core.context('PO_ReqChangeRequestWF_PVT','KickOffPOApproval',sqlerrm);
7344: raise;
7345: end;
7346:
7347:

Line 7476: wf_core.context('PO_ReqChangeRequestWF_PVT','Start_Poapprv_WF',x_progress||sqlerrm);

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

Line 7564: wf_core.context('PO_ReqChangeRequestWF_PVT','Req_Change_Responded',x_progress);

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

Line 7645: wf_core.context('PO_ReqChangeRequestWF_PVT','Reset_Req_Change_Flag',x_progress);

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:
7649: END Reset_Req_Change_Flag;

Line 8000: wf_core.context('PO_ReqChangeRequestWF_PVT','Get_Total_Amount_Currency',x_progress);

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:
8004: END Get_Total_Amount_Currency;

Line 8101: wf_core.context('PO_ReqChangeRequestWF_PVT','REQ_PO_CHANGE_RESPONDED',x_progress);

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

Line 8225: wf_core.context('PO_ReqChangeRequestWF_PVT','Get_Change_Attribute',x_progress);

8221: 'plsqlclob:PO_ReqChangeRequestNotif_PVT.get_req_chg_response_notif/'||
8222: to_char(l_parent_group_id));
8223:
8224: exception when others then
8225: wf_core.context('PO_ReqChangeRequestWF_PVT','Get_Change_Attribute',x_progress);
8226: raise;
8227: END Get_Change_Attribute;
8228:
8229:

Line 8316: wf_core.context('PO_ReqChangeRequestWF_PVT','New_PO_Change_Exists',x_progress);

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

Line 8382: wf_core.context('PO_ReqChangeRequestWF_PVT','Record_PO_Approval',x_progress);

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

Line 8448: wf_core.context('PO_ReqChangeRequestWF_PVT','Record_PO_Rejection',x_progress);

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

Line 8517: wf_core.context('PO_ReqChangeRequestWF_PVT','Validate_Chg_Against_New_PO',x_progress);

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:
8521: end Validate_Chg_Against_New_PO;

Line 8584: wf_core.context('PO_ReqChangeRequestWF_PVT','Any_Requester_Change','010');

8580: resultout := 'N';
8581: end if;
8582:
8583: exception when no_data_found then
8584: wf_core.context('PO_ReqChangeRequestWF_PVT','Any_Requester_Change','010');
8585: raise;
8586: when others then
8587: wf_core.context('PO_ReqChangeRequestWF_PVT','Any_Requester_Change',x_progress);
8588: raise;

Line 8587: wf_core.context('PO_ReqChangeRequestWF_PVT','Any_Requester_Change',x_progress);

8583: exception when no_data_found then
8584: wf_core.context('PO_ReqChangeRequestWF_PVT','Any_Requester_Change','010');
8585: raise;
8586: when others then
8587: wf_core.context('PO_ReqChangeRequestWF_PVT','Any_Requester_Change',x_progress);
8588: raise;
8589: END Any_Requester_Change;
8590:
8591: /*************************************************************************

Line 8633: wf_core.context('PO_ReqChangeRequestWF_PVT','set_data_sup_chn_evt',x_progress);

8629: avalue => l_item_key );
8630:
8631:
8632: exception when others then
8633: wf_core.context('PO_ReqChangeRequestWF_PVT','set_data_sup_chn_evt',x_progress);
8634: raise;
8635: END Set_Data_Req_Chn_Evt;
8636:
8637:

Line 9291: wf_core.context('PO_ReqChangeRequestWF_PVT','Any_Cancellation_Change',x_progress);

9287: WHEN no_data_found THEN
9288: resultout := 'N';
9289:
9290: WHEN others THEN
9291: wf_core.context('PO_ReqChangeRequestWF_PVT','Any_Cancellation_Change',x_progress);
9292: raise;
9293: END Any_Cancellation_Change;
9294:
9295: /*************************************************************************

Line 9543: wf_core.context('PO_ReqChangeRequestWF_PVT','CalculateRcoTotal',x_progress||sqlerrm);

9539: x_new_total := l_new_total;
9540:
9541: EXCEPTION
9542: WHEN OTHERS THEN
9543: wf_core.context('PO_ReqChangeRequestWF_PVT','CalculateRcoTotal',x_progress||sqlerrm);
9544: raise;
9545:
9546:
9547: END CalculateRcoTotal;

Line 9671: wf_core.context('PO_ReqChangeRequestWF_PVT','Set_Buyer_Approval_Notfn_Attr',

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,
9674: l_preparer_user_name, l_doc_string, sqlerrm,
9675: 'PO_ReqChangeRequestWF_PVT.Set_Buyer_Approval_Notfn_Attr');

Line 9751: wf_core.context('PO_ReqChangeRequestWF_PVT','Reject_Supplier_Change',x_progress);

9747:
9748: SetReqChangeFlag(l_change_request_group_id, l_req_document_id, itemtype, itemkey, 'N');
9749:
9750: EXCEPTION when others THEN
9751: wf_core.context('PO_ReqChangeRequestWF_PVT','Reject_Supplier_Change',x_progress);
9752: raise;
9753: END Reject_Supplier_Change;
9754:
9755: /*************************************************************************

Line 9809: wf_core.context('PO_ReqChangeRequestWF_PVT','Accept_Supplier_Change',x_progress);

9805:
9806: SetReqChangeFlag(l_change_request_group_id, l_document_id, itemtype, itemkey, 'N');
9807:
9808: EXCEPTION when others THEN
9809: wf_core.context('PO_ReqChangeRequestWF_PVT','Accept_Supplier_Change',x_progress);
9810: raise;
9811: END Accept_Supplier_Change;
9812:
9813: /*************************************************************************

Line 9883: wf_core.context('PO_ReqChangeRequestWF_PVT','Start_POChange_WF',x_progress);

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:
9887: END Start_POChange_WF;

Line 10010: wf_core.context('PO_ReqChangeRequestWF_PVT','Is_Tolerance_Check_Needed',l_progress);

10006:
10007: resultout := wf_engine.eng_completed || ':' || l_result;
10008:
10009: EXCEPTION when others THEN
10010: wf_core.context('PO_ReqChangeRequestWF_PVT','Is_Tolerance_Check_Needed',l_progress);
10011: raise;
10012: END Is_Tolerance_Check_Needed;
10013:
10014: /*************************************************************************

Line 10107: wf_core.context('PO_ReqChangeRequestWF_PVT','More_Po_To_Process',l_progress);

10103:
10104: resultout := wf_engine.eng_completed || ':' || l_result;
10105:
10106: EXCEPTION when others THEN
10107: wf_core.context('PO_ReqChangeRequestWF_PVT','More_Po_To_Process',l_progress);
10108: raise;
10109: END More_Po_To_Process;
10110:
10111: /*************************************************************************

Line 10268: wf_core.context('PO_ReqChangeRequestWF_PVT','Accept_Po_Changes',l_progress);

10264: end if;
10265: END IF;
10266:
10267: EXCEPTION when others THEN
10268: wf_core.context('PO_ReqChangeRequestWF_PVT','Accept_Po_Changes',l_progress);
10269: raise;
10270: END Accept_Po_Changes;
10271:
10272: /*************************************************************************

Line 10370: wf_core.context('PO_ReqChangeRequestWF_PVT','Set_Buyer_FYI_Notif_Attributes',l_progress);

10366: avalue =>
10367: to_char(l_new_total, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30)) || ' ' || l_po_currency);
10368:
10369: EXCEPTION when others THEN
10370: wf_core.context('PO_ReqChangeRequestWF_PVT','Set_Buyer_FYI_Notif_Attributes',l_progress);
10371: raise;
10372: END Set_Buyer_FYI_Notif_Attributes;
10373:
10374: /*************************************************************************

Line 10980: wf_core.context('PO_ReqChangeRequestWF_PVT','More_Req_To_Process',l_progress);

10976:
10977: resultout := wf_engine.eng_completed || ':' || l_result;
10978:
10979: EXCEPTION when others THEN
10980: wf_core.context('PO_ReqChangeRequestWF_PVT','More_Req_To_Process',l_progress);
10981: raise;
10982: END More_Req_To_Process;
10983:
10984: /*************************************************************************

Line 11033: wf_core.context('PO_ReqChangeRequestWF_PVT','Start_Notify_Requester_Process',l_progress || 'SQL ERROR:' || sqlerrm);

11029:
11030: l_progress := 'PO_ReqChangeRequestWF_PVT.Start_Notify_Requester_Process: 04';
11031:
11032: EXCEPTION when others THEN
11033: wf_core.context('PO_ReqChangeRequestWF_PVT','Start_Notify_Requester_Process',l_progress || 'SQL ERROR:' || sqlerrm);
11034: RAISE;
11035: END Start_Notify_Requester_Process;
11036:
11037: /*************************************************************************

Line 11091: wf_core.context('PO_ReqChangeRequestWF_PVT','Start_NotifyRequesterProcess',l_progress || 'SQL ERROR:' || sqlerrm);

11087:
11088: StartPOChangeWF(p_po_change_request_group_id, l_item_key, 'NOTIFY_REQUESTER_PROCESS', l_forward_from_username, l_user_id, l_responsibility_id, l_application_id);
11089:
11090: EXCEPTION when others THEN
11091: wf_core.context('PO_ReqChangeRequestWF_PVT','Start_NotifyRequesterProcess',l_progress || 'SQL ERROR:' || sqlerrm);
11092: RAISE;
11093: END Start_NotifyRequesterProcess;
11094:
11095:

Line 11370: wf_core.context('PO_ReqChangeRequestWF_PVT',

11366:
11367: EXCEPTION
11368: WHEN OTHERS THEN
11369:
11370: wf_core.context('PO_ReqChangeRequestWF_PVT',
11371: 'get_po_line_amount',l_progress||'-'||sqlerrm);
11372:
11373: raise;
11374:

Line 11707: wf_core.context('PO_ReqChangeRequestWF_PVT', 'Convert_Into_sO_Change', x_progress);

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:
11711: END convert_into_so_change;

Line 12006: wf_core.context('PO_ReqChangeRequestWF_PVT', 'ConvertIntoSOChange '||l_return_status, l_progress);

12002: IF l_orgid is NOT NULL THEN
12003: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
12004: END IF;
12005:
12006: wf_core.context('PO_ReqChangeRequestWF_PVT', 'ConvertIntoSOChange '||l_return_status, l_progress);
12007: ROLLBACK TO convertintosochange_SP;
12008: RAISE;
12009: END ConvertIntoSOChange;
12010:

Line 12614: wf_core.context('PO_REQ_CHANGE_WF', 'SEND_INTERNAL_NOTIF', x_progress);

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,
12617: SQLERRM,
12618: 'PO_REQ_CHANGE_WF.SEND_INTERNAL_NOTIF');

Line 12684: wf_core.context('PO_REQ_CHANGE_WF', 'NEXT_INTERNAL_NOTIF', x_progress);

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,
12687: SQLERRM,
12688: 'PO_REQ_CHANGE_WF.NEXT_INTERNAL_NOTIF');