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 713: wf_core.context('PO_ReqChangeRequestWF_PVT',

709: where change_request_id=
710: p_po_change_requests(i).parent_change_request_id;
711: end loop;
712: when others then
713: wf_core.context('PO_ReqChangeRequestWF_PVT',
714: 'ValidateAndSaveRequest',x_progress||sqlerrm);
715: raise;
716: end ValidateAndSaveRequest;
717:

Line 777: wf_core.context('PO_ReqChangeRequestWF_PVT',

773: where requisition_line_id=p_req_line_id;
774: x_progress :='002';
775: exception
776: when others then
777: wf_core.context('PO_ReqChangeRequestWF_PVT',
778: 'UpdateReqDistribution',x_progress||sqlerrm);
779: raise;
780: end UpdateReqDistribution;
781:

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

846: where requisition_line_id=p_req_line_id;
847: x_progress :='005-';
848: EXCEPTION
849: WHEN OTHERS THEN
850: wf_core.context('PO_ReqChangeRequestWF_PVT','UpdateReqLine',x_progress||sqlerrm);
851: raise;
852:
853: end UpdateReqLine;
854:

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

1581: -- commit;
1582:
1583: exception
1584: when others then
1585: wf_core.context('PO_ReqChangeRequestWF_PVT','ValidateChgAgainstNewPO',x_progress||sqlerrm);
1586: raise;
1587: end ValidateChgAgainstNewPO;
1588:
1589:

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

2556: commit;
2557:
2558: EXCEPTION
2559: WHEN OTHERS THEN
2560: wf_core.context('PO_ReqChangeRequestWF_PVT','ProcessBuyerAction',x_progress||sqlerrm);
2561: raise;
2562:
2563: END ProcessBuyerAction;
2564:

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

2926: commit;
2927:
2928: EXCEPTION
2929: WHEN OTHERS THEN
2930: wf_core.context('PO_ReqChangeRequestWF_PVT','ProcessSCOAcceptance',x_progress||sqlerrm);
2931: raise;
2932:
2933: END ProcessSCOAcceptance;
2934: /*************************************************************************

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

2967: commit;
2968:
2969: EXCEPTION
2970: WHEN OTHERS THEN
2971: wf_core.context('PO_ReqChangeRequestWF_PVT','SetPoRequestStatus',sqlerrm);
2972: raise;
2973:
2974: END SetPoRequestStatus;
2975:

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

3606: commit;
3607:
3608: EXCEPTION
3609: WHEN OTHERS THEN
3610: wf_core.context('PO_ReqChangeRequestWF_PVT','ConvertIntoPOChange',x_progress);
3611: raise;
3612:
3613: END ConvertIntoPOChange;
3614:

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

3709: commit;
3710:
3711: EXCEPTION
3712: WHEN OTHERS THEN
3713: wf_core.context('PO_ReqChangeRequestWF_PVT','SetReqRequestStatus',x_progress);
3714: raise;
3715:
3716: END SetReqRequestStatus;
3717:

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

3771: commit;
3772:
3773: EXCEPTION
3774: WHEN OTHERS THEN
3775: wf_core.context('PO_ReqChangeRequestWF_PVT','SetReqChangeFlag',x_progress);
3776: raise;
3777:
3778: END SetReqChangeFlag;
3779:

Line 4029: wf_core.context('PO_ReqChangeRequestWF_PVT',

4025:
4026: commit;
4027: EXCEPTION
4028: WHEN OTHERS THEN
4029: wf_core.context('PO_ReqChangeRequestWF_PVT',
4030: 'InsertActionHist'||sqlerrm,x_progress);
4031: raise;
4032:
4033: END InsertActionHist;

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

4086: commit;
4087:
4088: EXCEPTION
4089: WHEN OTHERS THEN
4090: wf_core.context('PO_REQ_CHANGE_WF','SetPOAuthStat',x_progress);
4091: raise;
4092:
4093: END SetPOAuthStat;
4094:

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

4143: commit;
4144:
4145: EXCEPTION
4146: WHEN OTHERS THEN
4147: wf_core.context('PO_REQ_CHANGE_WF','SetRelAuthStat',x_progress);
4148: raise;
4149:
4150: END SetRelAuthStat;
4151:

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

4214: 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);
4215: x_progress :='StartInformBuyerWF:002';
4216: EXCEPTION
4217: WHEN OTHERS THEN
4218: wf_core.context('PO_ReqChangeRequestWF_PVT','StartInformBuyerWF',x_progress);
4219:
4220: raise;
4221:
4222: end StartInformBuyerWF;

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

4380: x_progress :='StartConvertProcess:008';
4381: commit;
4382: EXCEPTION
4383: WHEN OTHERS THEN
4384: wf_core.context('PO_ReqChangeRequestWF_PVT','StartConvertProcess',x_progress);
4385:
4386: raise;
4387: end StartConvertProcess;
4388:

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

4872: message => l_procedure_name||'-'|| x_progress|| ' ' || sqlerrm);
4873: END IF;
4874: END IF;
4875:
4876: wf_core.context('PO_ReqChangeRequestWF_PVT','StartPOChangeWF',x_progress||sqlerrm);
4877: raise;
4878: end StartPOChangeWF;
4879:
4880:

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

4904: commit;
4905:
4906: EXCEPTION
4907: WHEN OTHERS THEN
4908: wf_core.context('PO_ReqChangeRequestWF_PVT','UpdatePODocHeaderTables',x_progress|| sqlerrm);
4909: raise;
4910: END UpdatePODocHeaderTables;
4911:
4912:

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

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

Line 5088: wf_core.context('PO_ReqChangeRequestWF_PVT',

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

Line 5214: wf_core.context('PO_ReqChangeRequestWF_PVT',

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

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

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

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

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

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

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

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

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

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

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

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

5585: avalue => 0);
5586: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
5587:
5588: exception when others then
5589: wf_core.context('PO_ReqChangeRequestWF_PVT','Reset_Reminder_Counter',x_progress);
5590: raise;
5591: END Reset_Reminder_Counter;
5592:
5593:

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

5648: end if;
5649: end if;
5650:
5651: exception when others then
5652: wf_core.context('PO_ReqChangeRequestWF_PVT','Reminder_Need_To_Be_Sent',x_progress);
5653: raise;
5654: END Reminder_Need_To_Be_Sent;
5655:
5656:

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

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

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

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

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

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

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

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

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

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

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

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

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

6408:
6409: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED' ;
6410:
6411: exception when others then
6412: wf_core.context('PO_ReqChangeRequestWF_PVT','Get_Change_Total_Attr',x_progress);
6413: raise;
6414: END Get_Change_Total_Attr;
6415:
6416: procedure setNewTotal(itemtype in varchar2, itemkey in varchar2) is

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

6602: avalue => l_amount_for_subject);
6603: x_progress :='004';
6604: exception
6605: when others then
6606: wf_core.context('PO_ReqChangeRequestWF_PVT','setNewTotal',x_progress||sqlerrm);
6607: raise;
6608:
6609: end setNewTotal;
6610:

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

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

Line 6779: wf_core.context('PO_ReqChangeRequestWF_PVT',

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

Line 6874: wf_core.context('PO_ReqChangeRequestWF_PVT',

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

Line 6948: wf_core.context('PO_ReqChangeRequestWF_PVT',

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

Line 7022: wf_core.context('PO_ReqChangeRequestWF_PVT',

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

Line 7091: wf_core.context('PO_ReqChangeRequestWF_PVT',

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

Line 7230: wf_core.context('PO_ReqChangeRequestWF_PVT',

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

Line 7305: wf_core.context('PO_ReqChangeRequestWF_PVT',

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

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

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

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

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

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

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

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

7576: commit;
7577: end if;
7578: exception
7579: when others then
7580: wf_core.context('PO_ReqChangeRequestWF_PVT','KickOffPOApproval',sqlerrm);
7581: raise;
7582: end;
7583:
7584:

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

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

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

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

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

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

Line 8316: wf_core.context('PO_ReqChangeRequestWF_PVT','Get_Total_Amount_Currency',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','Get_Total_Amount_Currency',x_progress);
8317: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_ReqChangeRequestWF_PVT.Get_Total_Amount_Currency');
8318: raise;
8319:
8320: END Get_Total_Amount_Currency;

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

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

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

8608: 'plsqlclob:PO_ReqChangeRequestNotif_PVT.get_req_chg_response_notif/'||
8609: to_char(l_parent_group_id));
8610:
8611: exception when others then
8612: wf_core.context('PO_ReqChangeRequestWF_PVT','Get_Change_Attribute',x_progress);
8613: raise;
8614: END Get_Change_Attribute;
8615:
8616:

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

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

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

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

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

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

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

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

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

8967: resultout := 'N';
8968: end if;
8969:
8970: exception when no_data_found then
8971: wf_core.context('PO_ReqChangeRequestWF_PVT','Any_Requester_Change','010');
8972: raise;
8973: when others then
8974: wf_core.context('PO_ReqChangeRequestWF_PVT','Any_Requester_Change',x_progress);
8975: raise;

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

8970: exception when no_data_found then
8971: wf_core.context('PO_ReqChangeRequestWF_PVT','Any_Requester_Change','010');
8972: raise;
8973: when others then
8974: wf_core.context('PO_ReqChangeRequestWF_PVT','Any_Requester_Change',x_progress);
8975: raise;
8976: END Any_Requester_Change;
8977:
8978: /*************************************************************************

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

9016: avalue => l_item_key );
9017:
9018:
9019: exception when others then
9020: wf_core.context('PO_ReqChangeRequestWF_PVT','set_data_sup_chn_evt',x_progress);
9021: raise;
9022: END Set_Data_Req_Chn_Evt;
9023:
9024:

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

9674: WHEN no_data_found THEN
9675: resultout := 'N';
9676:
9677: WHEN others THEN
9678: wf_core.context('PO_ReqChangeRequestWF_PVT','Any_Cancellation_Change',x_progress);
9679: raise;
9680: END Any_Cancellation_Change;
9681:
9682: /*************************************************************************

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

9926: x_new_total := l_new_total;
9927:
9928: EXCEPTION
9929: WHEN OTHERS THEN
9930: wf_core.context('PO_ReqChangeRequestWF_PVT','CalculateRcoTotal',x_progress||sqlerrm);
9931: raise;
9932:
9933:
9934: END CalculateRcoTotal;

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

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

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

10134:
10135: SetReqChangeFlag(l_change_request_group_id, l_req_document_id, itemtype, itemkey, 'N');
10136:
10137: EXCEPTION when others THEN
10138: wf_core.context('PO_ReqChangeRequestWF_PVT','Reject_Supplier_Change',x_progress);
10139: raise;
10140: END Reject_Supplier_Change;
10141:
10142: /*************************************************************************

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

10192:
10193: SetReqChangeFlag(l_change_request_group_id, l_document_id, itemtype, itemkey, 'N');
10194:
10195: EXCEPTION when others THEN
10196: wf_core.context('PO_ReqChangeRequestWF_PVT','Accept_Supplier_Change',x_progress);
10197: raise;
10198: END Accept_Supplier_Change;
10199:
10200: /*************************************************************************

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

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

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

10393:
10394: resultout := wf_engine.eng_completed || ':' || l_result;
10395:
10396: EXCEPTION when others THEN
10397: wf_core.context('PO_ReqChangeRequestWF_PVT','Is_Tolerance_Check_Needed',l_progress);
10398: raise;
10399: END Is_Tolerance_Check_Needed;
10400:
10401: /*************************************************************************

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

10490:
10491: resultout := wf_engine.eng_completed || ':' || l_result;
10492:
10493: EXCEPTION when others THEN
10494: wf_core.context('PO_ReqChangeRequestWF_PVT','More_Po_To_Process',l_progress);
10495: raise;
10496: END More_Po_To_Process;
10497:
10498: /*************************************************************************

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

10654: end if;
10655: END IF;
10656:
10657: EXCEPTION when others THEN
10658: wf_core.context('PO_ReqChangeRequestWF_PVT','Accept_Po_Changes',l_progress);
10659: raise;
10660: END Accept_Po_Changes;
10661:
10662: /*************************************************************************

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

10756: avalue =>
10757: to_char(l_new_total, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30)) || ' ' || l_po_currency);
10758:
10759: EXCEPTION when others THEN
10760: wf_core.context('PO_ReqChangeRequestWF_PVT','Set_Buyer_FYI_Notif_Attributes',l_progress);
10761: raise;
10762: END Set_Buyer_FYI_Notif_Attributes;
10763:
10764: /*************************************************************************

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

11366:
11367: resultout := wf_engine.eng_completed || ':' || l_result;
11368:
11369: EXCEPTION when others THEN
11370: wf_core.context('PO_ReqChangeRequestWF_PVT','More_Req_To_Process',l_progress);
11371: raise;
11372: END More_Req_To_Process;
11373:
11374: /*************************************************************************

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

11433:
11434: l_progress := 'PO_ReqChangeRequestWF_PVT.Start_Notify_Requester_Process: 05';
11435:
11436: EXCEPTION when others THEN
11437: wf_core.context('PO_ReqChangeRequestWF_PVT','Start_Notify_Requester_Process',l_progress || 'SQL ERROR:' || sqlerrm);
11438: RAISE;
11439: END Start_Notify_Requester_Process;
11440:
11441: /*************************************************************************

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

11491:
11492: 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);
11493:
11494: EXCEPTION when others THEN
11495: wf_core.context('PO_ReqChangeRequestWF_PVT','Start_NotifyRequesterProcess',l_progress || 'SQL ERROR:' || sqlerrm);
11496: RAISE;
11497: END Start_NotifyRequesterProcess;
11498:
11499:

Line 11774: wf_core.context('PO_ReqChangeRequestWF_PVT',

11770:
11771: EXCEPTION
11772: WHEN OTHERS THEN
11773:
11774: wf_core.context('PO_ReqChangeRequestWF_PVT',
11775: 'get_po_line_amount',l_progress||'-'||sqlerrm);
11776:
11777: raise;
11778:

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

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

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

12441: IF l_orgid is NOT NULL THEN
12442: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
12443: END IF;
12444:
12445: wf_core.context('PO_ReqChangeRequestWF_PVT', 'ConvertIntoSOChange '||l_return_status, l_progress);
12446: ROLLBACK TO convertintosochange_SP;
12447: RAISE;
12448: END ConvertIntoSOChange;
12449:

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

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

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

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