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_ENGINE

Line 4272: n_varname Wf_Engine.NameTabTyp;

4268: l_old_tax_currency varchar2(40);
4269: l_new_tax_currency varchar2(40);
4270: l_new_total_amount_dsp varchar2(40);
4271:
4272: n_varname Wf_Engine.NameTabTyp;
4273: n_varval Wf_Engine.NumTabTyp;
4274:
4275: t_varname Wf_Engine.NameTabTyp;
4276: t_varval Wf_Engine.TextTabTyp;

Line 4273: n_varval Wf_Engine.NumTabTyp;

4269: l_new_tax_currency varchar2(40);
4270: l_new_total_amount_dsp varchar2(40);
4271:
4272: n_varname Wf_Engine.NameTabTyp;
4273: n_varval Wf_Engine.NumTabTyp;
4274:
4275: t_varname Wf_Engine.NameTabTyp;
4276: t_varval Wf_Engine.TextTabTyp;
4277:

Line 4275: t_varname Wf_Engine.NameTabTyp;

4271:
4272: n_varname Wf_Engine.NameTabTyp;
4273: n_varval Wf_Engine.NumTabTyp;
4274:
4275: t_varname Wf_Engine.NameTabTyp;
4276: t_varval Wf_Engine.TextTabTyp;
4277:
4278: begin
4279: x_progress :='StartConvertProcess:001';

Line 4276: t_varval Wf_Engine.TextTabTyp;

4272: n_varname Wf_Engine.NameTabTyp;
4273: n_varval Wf_Engine.NumTabTyp;
4274:
4275: t_varname Wf_Engine.NameTabTyp;
4276: t_varval Wf_Engine.TextTabTyp;
4277:
4278: begin
4279: x_progress :='StartConvertProcess:001';
4280:

Line 4295: wf_engine.CreateProcess(itemtype => item_type,

4291: where requisition_header_id=l_document_id;
4292:
4293: x_progress :='StartConvertProcess:003';
4294:
4295: wf_engine.CreateProcess(itemtype => item_type,
4296: itemkey => item_key,
4297: process => 'CONVERT_INTO_PO_REQUEST');
4298: x_progress :='StartConvertProcess:004';
4299:

Line 4309: Wf_Engine.SetItemAttrNumberArray(item_type, item_key,n_varname,n_varval);

4305: n_varname(2) := 'DOCUMENT_ID';
4306: n_varval(2) := l_document_id;
4307: n_varname(3) := 'ORG_ID';
4308: n_varval(3) := l_org_id;
4309: Wf_Engine.SetItemAttrNumberArray(item_type, item_key,n_varname,n_varval);
4310: x_progress :='StartConvertProcess:006';
4311: t_varname(1) := 'DOCUMENT_TYPE';
4312: t_varval(1) := 'REQ';
4313: t_varname(2) := 'DOCUMENT_SUBTYPE';

Line 4375: Wf_Engine.SetItemAttrTextArray(item_type, item_key,t_varname,t_varval);

4371: t_varval(15) := l_document_number;
4372:
4373: x_progress :='StartConvertProcess:007';
4374:
4375: Wf_Engine.SetItemAttrTextArray(item_type, item_key,t_varname,t_varval);
4376:
4377: wf_engine.StartProcess(itemtype => item_type,
4378: itemkey => item_key);
4379:

Line 4377: wf_engine.StartProcess(itemtype => item_type,

4373: x_progress :='StartConvertProcess:007';
4374:
4375: Wf_Engine.SetItemAttrTextArray(item_type, item_key,t_varname,t_varval);
4376:
4377: wf_engine.StartProcess(itemtype => item_type,
4378: itemkey => item_key);
4379:
4380: x_progress :='StartConvertProcess:008';
4381: commit;

Line 4493: n_varname Wf_Engine.NameTabTyp;

4489: from po_requisition_headers_all prh, po_change_requests pcr
4490: where prh.requisition_header_id=pcr.document_header_id
4491: and pcr.change_request_group_id=l_change_request_group_id;
4492:
4493: n_varname Wf_Engine.NameTabTyp;
4494: n_varval Wf_Engine.NumTabTyp;
4495:
4496: t_varname Wf_Engine.NameTabTyp;
4497: t_varval Wf_Engine.TextTabTyp;

Line 4494: n_varval Wf_Engine.NumTabTyp;

4490: where prh.requisition_header_id=pcr.document_header_id
4491: and pcr.change_request_group_id=l_change_request_group_id;
4492:
4493: n_varname Wf_Engine.NameTabTyp;
4494: n_varval Wf_Engine.NumTabTyp;
4495:
4496: t_varname Wf_Engine.NameTabTyp;
4497: t_varval Wf_Engine.TextTabTyp;
4498:

Line 4496: t_varname Wf_Engine.NameTabTyp;

4492:
4493: n_varname Wf_Engine.NameTabTyp;
4494: n_varval Wf_Engine.NumTabTyp;
4495:
4496: t_varname Wf_Engine.NameTabTyp;
4497: t_varval Wf_Engine.TextTabTyp;
4498:
4499: l_document_type_disp varchar2(200);
4500:

Line 4497: t_varval Wf_Engine.TextTabTyp;

4493: n_varname Wf_Engine.NameTabTyp;
4494: n_varval Wf_Engine.NumTabTyp;
4495:
4496: t_varname Wf_Engine.NameTabTyp;
4497: t_varval Wf_Engine.TextTabTyp;
4498:
4499: l_document_type_disp varchar2(200);
4500:
4501: --Add by Xiao and Eric for IL PO Notification on Mar-30-2009, Begin

Line 4581: wf_engine.CreateProcess(itemtype => item_type,

4577: message => 'change_request_group_id:' ||to_char(p_change_request_group_id) || '-before creating workflow');
4578: END IF;
4579: END IF;
4580:
4581: wf_engine.CreateProcess(itemtype => item_type,
4582: itemkey => item_key,
4583: process => p_process);
4584: x_progress :='StartPOChangeWF:004';
4585:

Line 4633: Wf_Engine.SetItemAttrNumberArray(item_type, item_key,n_varname,n_varval);

4629: n_varname(7) := 'RESPONSIBILITY_ID';
4630: n_varval(7) := p_responsibility_id;
4631: n_varname(8) := 'APPLICATION_ID';
4632: n_varval(8) := p_application_id;
4633: Wf_Engine.SetItemAttrNumberArray(item_type, item_key,n_varname,n_varval);
4634:
4635: -- fnd_global.APPS_INITIALIZE (p_user_id, p_responsibility_id, p_application_id);
4636:
4637: t_varname(1) := 'DOCUMENT_TYPE';

Line 4665: Wf_Engine.SetItemAttrTextArray(item_type, item_key,t_varname,t_varval);

4661: t_varname(12) := 'DOCUMENT_TYPE_DISP';
4662: t_varval(12) := l_document_type_disp;
4663:
4664: x_progress :='StartPOChangeWF:007';
4665: Wf_Engine.SetItemAttrTextArray(item_type, item_key,t_varname,t_varval);
4666:
4667: -- bug 5379796, need to get old req_amount,tax_amount before kicking off the workflow, -- since 'buyer response' wf will update reqs.
4668: if (p_process='PROCESS_BUYER_RESPONSE') then
4669:

Line 4817: wf_engine.setItemParent( itemtype => item_type,

4813: message => 'change_request_group_id:' ||to_char(p_change_request_group_id)||'-before setting the parent-child relationship.');
4814: END IF;
4815: END IF;
4816:
4817: wf_engine.setItemParent( itemtype => item_type,
4818: itemkey => item_key,
4819: parent_itemtype => l_parent_item_type,
4820: parent_itemkey => l_parent_item_key,
4821: parent_context => NULL);

Line 4837: wf_engine.StartProcess(itemtype => item_type,

4833: END IF;
4834:
4835: x_progress :='StartPOChangeWF:010';
4836:
4837: wf_engine.StartProcess(itemtype => item_type,
4838: itemkey => item_key);
4839:
4840: IF (g_fnd_debug = 'Y') THEN
4841: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

Line 4947: if (funcmode <> wf_engine.eng_run) then

4943: x_progress := 'PO_ReqChangeRequestWF_PVT.Get_Req_Chg_Attributes';
4944:
4945:
4946: -- Do nothing in cancel or timeout mode
4947: if (funcmode <> wf_engine.eng_run) then
4948:
4949: resultout := wf_engine.eng_null;
4950: return;
4951:

Line 4949: resultout := wf_engine.eng_null;

4945:
4946: -- Do nothing in cancel or timeout mode
4947: if (funcmode <> wf_engine.eng_run) then
4948:
4949: resultout := wf_engine.eng_null;
4950: return;
4951:
4952: end if;
4953:

Line 5001: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';

4997: 'plsql:PO_ReqChangeRequestNotif_PVT.get_new_req_amount/'||itemtype||':'||itemkey);
4998:
4999: */
5000: x_progress := 'PO_ReqChangeRequestWF_PVT.Get_Req_Chg_Attributes: 02';
5001: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
5002:
5003: EXCEPTION
5004: WHEN OTHERS THEN
5005: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);

Line 5045: if (funcmode <> wf_engine.eng_run) then

5041: x_progress := 'PO_ReqChangeRequestWF_PVT.Update_Req_Change_Flag: 01';
5042:
5043: -- Do nothing in cancel or timeout mode
5044: --
5045: if (funcmode <> wf_engine.eng_run) then
5046:
5047: resultout := wf_engine.eng_null;
5048: return;
5049:

Line 5047: resultout := wf_engine.eng_null;

5043: -- Do nothing in cancel or timeout mode
5044: --
5045: if (funcmode <> wf_engine.eng_run) then
5046:
5047: resultout := wf_engine.eng_null;
5048: return;
5049:
5050: end if;
5051:

Line 5077: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';

5073: SetReqChangeFlag(l_change_request_group_id,
5074: l_document_id, itemtype, itemkey, 'Y');
5075:
5076: --
5077: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
5078: --
5079:
5080: x_progress := 'PO_REQAPPROVAL_INIT1.Update_Req_Change_Flag: 02';
5081:

Line 5137: if (funcmode <> wf_engine.eng_run) then

5133:
5134: x_progress := 'PO_ReqChangeRequestWF_PVT.Insert_into_History_CHGsubmit: 01';
5135:
5136: -- Do nothing in cancel or timeout mode
5137: if (funcmode <> wf_engine.eng_run) then
5138: resultout := wf_engine.eng_null;
5139: return;
5140: end if;
5141:

Line 5138: resultout := wf_engine.eng_null;

5134: x_progress := 'PO_ReqChangeRequestWF_PVT.Insert_into_History_CHGsubmit: 01';
5135:
5136: -- Do nothing in cancel or timeout mode
5137: if (funcmode <> wf_engine.eng_run) then
5138: resultout := wf_engine.eng_null;
5139: return;
5140: end if;
5141:
5142: l_change_request_group_id:= PO_WF_UTIL_PKG.GetItemAttrNumber (

Line 5205: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED' ;

5201: InsertActionHist(itemtype,itemkey,l_doc_id, l_doc_type,
5202: l_doc_subtype, l_employee_id,
5203: 'SUBMIT CHANGE', l_note, null);
5204:
5205: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED' ;
5206:
5207: x_progress := 'PO_ReqChangeRequestWF_PVT.Insert_into_History_CHGsubmit: 07';
5208:
5209: EXCEPTION

Line 5261: if (funcmode <> wf_engine.eng_run) then

5257:
5258: x_progress := 'PO_ReqChangeRequestWF_PVT.Req_Change_Needs_Approval: 01';
5259:
5260: -- Do nothing in cancel or timeout mode
5261: if (funcmode <> wf_engine.eng_run) then
5262: resultout := wf_engine.eng_null;
5263: return;
5264: end if;
5265:

Line 5262: resultout := wf_engine.eng_null;

5258: x_progress := 'PO_ReqChangeRequestWF_PVT.Req_Change_Needs_Approval: 01';
5259:
5260: -- Do nothing in cancel or timeout mode
5261: if (funcmode <> wf_engine.eng_run) then
5262: resultout := wf_engine.eng_null;
5263: return;
5264: end if;
5265:
5266: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (

Line 5276: resultout := wf_engine.eng_completed || ':' || 'N';

5272:
5273: open approval_flag;
5274: fetch approval_flag into l_approval_flag;
5275: if(approval_flag%NOTFOUND) then
5276: resultout := wf_engine.eng_completed || ':' || 'N';
5277: else
5278: resultout := wf_engine.eng_completed || ':'
5279: || nvl(l_approval_flag, 'Y');
5280: end if;

Line 5278: resultout := wf_engine.eng_completed || ':'

5274: fetch approval_flag into l_approval_flag;
5275: if(approval_flag%NOTFOUND) then
5276: resultout := wf_engine.eng_completed || ':' || 'N';
5277: else
5278: resultout := wf_engine.eng_completed || ':'
5279: || nvl(l_approval_flag, 'Y');
5280: end if;
5281: close approval_flag;
5282:

Line 5328: if (funcmode <> wf_engine.eng_run) then

5324: x_progress := 'PO_ReqChangeRequestWF_PVT.Set_Change_Mgr_Pre_App: 01';
5325:
5326:
5327: -- Do nothing in cancel or timeout mode
5328: if (funcmode <> wf_engine.eng_run) then
5329: resultout := wf_engine.eng_null;
5330: return;
5331: end if;
5332:

Line 5329: resultout := wf_engine.eng_null;

5325:
5326:
5327: -- Do nothing in cancel or timeout mode
5328: if (funcmode <> wf_engine.eng_run) then
5329: resultout := wf_engine.eng_null;
5330: return;
5331: end if;
5332:
5333: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

Line 5342: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';

5338: SetReqRequestStatus(l_change_request_group_id, 'N', 'MGR_PRE_APP',
5339: null, null);
5340:
5341: --
5342: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
5343: --
5344:
5345: x_progress := 'PO_ReqChangeRequestWF_PVT.Set_Change_Mgr_Pre_App: 02';
5346:

Line 5391: if (funcmode <> wf_engine.eng_run) then

5387: x_progress := 'PO_ReqChangeRequestWF_PVT.Set_Change_Mgr_App: 01';
5388:
5389:
5390: -- Do nothing in cancel or timeout mode
5391: if (funcmode <> wf_engine.eng_run) then
5392: resultout := wf_engine.eng_null;
5393: return;
5394: end if;
5395:

Line 5392: resultout := wf_engine.eng_null;

5388:
5389:
5390: -- Do nothing in cancel or timeout mode
5391: if (funcmode <> wf_engine.eng_run) then
5392: resultout := wf_engine.eng_null;
5393: return;
5394: end if;
5395:
5396: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (

Line 5403: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';

5399: aname => 'CHANGE_REQUEST_GROUP_ID');
5400:
5401: SetReqRequestStatus(l_change_request_group_id, 'N', 'MGR_APP', null, null);
5402:
5403: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
5404:
5405: x_progress := 'PO_ReqChangeRequestWF_PVT.Set_Change_Mgr_App: 02';
5406:
5407: EXCEPTION

Line 5450: if (funcmode <> wf_engine.eng_run) then

5446:
5447:
5448: -- Do nothing in cancel or timeout mode
5449: --
5450: if (funcmode <> wf_engine.eng_run) then
5451:
5452: resultout := wf_engine.eng_null;
5453: return;
5454:

Line 5452: resultout := wf_engine.eng_null;

5448: -- Do nothing in cancel or timeout mode
5449: --
5450: if (funcmode <> wf_engine.eng_run) then
5451:
5452: resultout := wf_engine.eng_null;
5453: return;
5454:
5455: end if;
5456:

Line 5465: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';

5461:
5462: SetReqRequestStatus(l_change_request_group_id, 'N', 'REJECTED', null, null);
5463:
5464: --
5465: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
5466: --
5467:
5468: x_progress := 'PO_ReqChangeRequestWF_PVT.Set_Change_Rejected: 02';
5469:

Line 5517: if (funcmode <> wf_engine.eng_run) then

5513: x_progress := 'PO_ReqChangeRequestWF_PVT.Is_Chg_Mgr_Pre_App';
5514:
5515:
5516: -- Do nothing in cancel or timeout mode
5517: if (funcmode <> wf_engine.eng_run) then
5518:
5519: resultout := wf_engine.eng_null;
5520: return;
5521:

Line 5519: resultout := wf_engine.eng_null;

5515:
5516: -- Do nothing in cancel or timeout mode
5517: if (funcmode <> wf_engine.eng_run) then
5518:
5519: resultout := wf_engine.eng_null;
5520: return;
5521:
5522: end if;
5523:

Line 5546: resultout := wf_engine.eng_completed || ':' || 'N' ;

5542: close accepted_change;
5543:
5544: if(l_change_request_id is null) then
5545: -- not exist
5546: resultout := wf_engine.eng_completed || ':' || 'N' ;
5547: else
5548: resultout := wf_engine.eng_completed || ':' || 'Y' ;
5549: end if;
5550: x_progress := 'PO_ReqChangeRequestWF_PVT.Is_Chg_Mgr_Pre_App: 02';

Line 5548: resultout := wf_engine.eng_completed || ':' || 'Y' ;

5544: if(l_change_request_id is null) then
5545: -- not exist
5546: resultout := wf_engine.eng_completed || ':' || 'N' ;
5547: else
5548: resultout := wf_engine.eng_completed || ':' || 'Y' ;
5549: end if;
5550: x_progress := 'PO_ReqChangeRequestWF_PVT.Is_Chg_Mgr_Pre_App: 02';
5551:
5552: EXCEPTION

Line 5586: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';

5582: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => itemtype,
5583: itemkey => itemkey,
5584: aname => 'REMINDER_COUNTER',
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;

Line 5621: resultout := wf_engine.eng_completed || ':' || 'N';

5617: itemkey => itemkey,
5618: aname => 'MAX_REMINDER_MSG_COUNT');
5619:
5620: if(l_reminder_counter=l_max_reminder) then
5621: resultout := wf_engine.eng_completed || ':' || 'N';
5622: else
5623: resultout := wf_engine.eng_completed || ':' || 'Y';
5624: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
5625: itemkey => itemkey,

Line 5623: resultout := wf_engine.eng_completed || ':' || 'Y';

5619:
5620: if(l_reminder_counter=l_max_reminder) then
5621: resultout := wf_engine.eng_completed || ':' || 'N';
5622: else
5623: resultout := wf_engine.eng_completed || ':' || 'Y';
5624: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
5625: itemkey => itemkey,
5626: aname => 'REMINDER_COUNTER',
5627: avalue => l_reminder_counter+1);

Line 5624: wf_engine.SetItemAttrNumber ( itemtype => itemtype,

5620: if(l_reminder_counter=l_max_reminder) then
5621: resultout := wf_engine.eng_completed || ':' || 'N';
5622: else
5623: resultout := wf_engine.eng_completed || ':' || 'Y';
5624: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
5625: itemkey => itemkey,
5626: aname => 'REMINDER_COUNTER',
5627: avalue => l_reminder_counter+1);
5628: if(l_reminder_counter=l_max_reminder-1) then

Line 5689: if (funcmode <> wf_engine.eng_run) then

5685:
5686: x_progress := 'PO_ReqChangeRequestWF_PVT.Start_From_PO_Cancel';
5687:
5688: -- Do nothing in cancel or timeout mode
5689: if (funcmode <> wf_engine.eng_run) then
5690:
5691: resultout := wf_engine.eng_null;
5692: return;
5693:

Line 5691: resultout := wf_engine.eng_null;

5687:
5688: -- Do nothing in cancel or timeout mode
5689: if (funcmode <> wf_engine.eng_run) then
5690:
5691: resultout := wf_engine.eng_null;
5692: return;
5693:
5694: end if;
5695: l_ActionOriginatedFrom := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => itemtype,

Line 5701: resultout := wf_engine.eng_completed || ':' || 'Y';

5697: aname => 'INTERFACE_SOURCE_CODE');
5698:
5699:
5700: if(nvl(l_ActionOriginatedFrom, 'N')='PO_CANCEL') then
5701: resultout := wf_engine.eng_completed || ':' || 'Y';
5702: else
5703: resultout := wf_engine.eng_completed || ':' || 'N';
5704: end if;
5705: x_progress := 'PO_ReqChangeRequestWF_PVT.Start_From_PO_Cancel: 02';

Line 5703: resultout := wf_engine.eng_completed || ':' || 'N';

5699:
5700: if(nvl(l_ActionOriginatedFrom, 'N')='PO_CANCEL') then
5701: resultout := wf_engine.eng_completed || ':' || 'Y';
5702: else
5703: resultout := wf_engine.eng_completed || ':' || 'N';
5704: end if;
5705: x_progress := 'PO_ReqChangeRequestWF_PVT.Start_From_PO_Cancel: 02';
5706:
5707: EXCEPTION

Line 5754: if (funcmode <> wf_engine.eng_run) then

5750: x_progress := 'PO_ReqChangeRequestWF_PVT.Change_Request_Mgr_Approved';
5751:
5752:
5753: -- Do nothing in cancel or timeout mode
5754: if (funcmode <> wf_engine.eng_run) then
5755:
5756: resultout := wf_engine.eng_null;
5757: return;
5758:

Line 5756: resultout := wf_engine.eng_null;

5752:
5753: -- Do nothing in cancel or timeout mode
5754: if (funcmode <> wf_engine.eng_run) then
5755:
5756: resultout := wf_engine.eng_null;
5757: return;
5758:
5759: end if;
5760:

Line 5781: resultout := wf_engine.eng_completed || ':' || 'Y';

5777: fetch change_request_status into l_change_request_status ;
5778: close change_request_status ;
5779:
5780: if(l_change_request_status is not null) then
5781: resultout := wf_engine.eng_completed || ':' || 'Y';
5782: else
5783: resultout := wf_engine.eng_completed || ':' || 'N';
5784: end if;
5785: x_progress := 'PO_ReqChangeRequestWF_PVT.Change_Request_Mgr_Approved: 02';

Line 5783: resultout := wf_engine.eng_completed || ':' || 'N';

5779:
5780: if(l_change_request_status is not null) then
5781: resultout := wf_engine.eng_completed || ':' || 'Y';
5782: else
5783: resultout := wf_engine.eng_completed || ':' || 'N';
5784: end if;
5785: x_progress := 'PO_ReqChangeRequestWF_PVT.Change_Request_Mgr_Approved: 02';
5786:
5787: EXCEPTION

Line 6185: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';

6181:
6182: ConvertIntoPOChange(l_change_request_group_id);
6183:
6184:
6185: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
6186: end Convert_Into_PO_Change;
6187:
6188:
6189:

Line 6238: if (funcmode <> wf_engine.eng_run) then

6234:
6235:
6236: -- Do nothing in cancel or timeout mode
6237: --
6238: if (funcmode <> wf_engine.eng_run) then
6239:
6240: resultout := wf_engine.eng_null;
6241: return;
6242:

Line 6240: resultout := wf_engine.eng_null;

6236: -- Do nothing in cancel or timeout mode
6237: --
6238: if (funcmode <> wf_engine.eng_run) then
6239:
6240: resultout := wf_engine.eng_null;
6241: return;
6242:
6243: end if;
6244:

Line 6271: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';

6267: end loop;
6268: close child_request_group_id;
6269:
6270: --
6271: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
6272: --
6273:
6274: x_progress := 'PO_ReqChangeRequestWF_PVT.Kickoff_POChange_WF: 02';
6275:

Line 6318: if (funcmode <> wf_engine.eng_run) then

6314:
6315:
6316: -- Do nothing in cancel or timeout mode
6317: --
6318: if (funcmode <> wf_engine.eng_run) then
6319:
6320: resultout := wf_engine.eng_null;
6321: return;
6322:

Line 6320: resultout := wf_engine.eng_null;

6316: -- Do nothing in cancel or timeout mode
6317: --
6318: if (funcmode <> wf_engine.eng_run) then
6319:
6320: resultout := wf_engine.eng_null;
6321: return;
6322:
6323: end if;
6324:

Line 6347: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';

6343:
6344: SetReqChangeFlag(l_change_request_group_id, l_document_id, itemtype, itemkey, 'N');
6345:
6346: --
6347: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
6348: --
6349:
6350: x_progress := 'PO_REQAPPROVAL_INIT1.Reset_Change_Flag: 02';
6351:

Line 6389: if (funcmode <> wf_engine.eng_run) then

6385: l_new_req_amount number;
6386: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;
6387:
6388: BEGIN
6389: if (funcmode <> wf_engine.eng_run) then
6390:
6391: resultout := wf_engine.eng_null;
6392: return;
6393:

Line 6391: resultout := wf_engine.eng_null;

6387:
6388: BEGIN
6389: if (funcmode <> wf_engine.eng_run) then
6390:
6391: resultout := wf_engine.eng_null;
6392: return;
6393:
6394: end if;
6395:

Line 6409: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED' ;

6405: END IF;
6406:
6407: setNewTotal(itemtype, itemkey);
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;

Line 6643: if (funcmode <> wf_engine.eng_run) then

6639:
6640: x_progress := 'PO_ReqChangeRequestWF_PVT.Is_Doc_Approved: 01';
6641:
6642: -- Do nothing in cancel or timeout mode
6643: if (funcmode <> wf_engine.eng_run) then
6644: resultout := wf_engine.eng_null;
6645: return;
6646: end if;
6647:

Line 6644: resultout := wf_engine.eng_null;

6640: x_progress := 'PO_ReqChangeRequestWF_PVT.Is_Doc_Approved: 01';
6641:
6642: -- Do nothing in cancel or timeout mode
6643: if (funcmode <> wf_engine.eng_run) then
6644: resultout := wf_engine.eng_null;
6645: return;
6646: end if;
6647:
6648: l_doc_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

Line 6689: resultout := wf_engine.eng_completed || ':' || 'Y' ;

6685: -- the authorization_status of corresponding PO/REALEASE will be 'pre_approved'(pending signature)
6686: -- This way,is_doc_approved should return 'Y' so that PO change requests will be updated to 'ACCEPTED' status later.
6687:
6688: if(nvl(l_authorization_status, 'IN PROCESS') in ('APPROVED','PRE-APPROVED') ) then
6689: resultout := wf_engine.eng_completed || ':' || 'Y' ;
6690:
6691: else
6692: resultout := wf_engine.eng_completed || ':' || 'N' ;
6693: end if;

Line 6692: resultout := wf_engine.eng_completed || ':' || 'N' ;

6688: if(nvl(l_authorization_status, 'IN PROCESS') in ('APPROVED','PRE-APPROVED') ) then
6689: resultout := wf_engine.eng_completed || ':' || 'Y' ;
6690:
6691: else
6692: resultout := wf_engine.eng_completed || ':' || 'N' ;
6693: end if;
6694:
6695: x_progress := 'PO_ReqChangeRequestWF_PVT.Is_Doc_Approved: 02';
6696:

Line 6741: if (funcmode <> wf_engine.eng_run) then

6737: BEGIN
6738:
6739: x_progress := 'PO_ReqChangeRequestWF_PVT.Set_Doc_In_Process01';
6740:
6741: if (funcmode <> wf_engine.eng_run) then
6742: resultout := wf_engine.eng_null;
6743: return;
6744: end if;
6745:

Line 6742: resultout := wf_engine.eng_null;

6738:
6739: x_progress := 'PO_ReqChangeRequestWF_PVT.Set_Doc_In_Process01';
6740:
6741: if (funcmode <> wf_engine.eng_run) then
6742: resultout := wf_engine.eng_null;
6743: return;
6744: end if;
6745:
6746: l_doc_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

Line 6822: if (funcmode <> wf_engine.eng_run) then

6818:
6819: x_progress := 'PO_ReqChangeRequestWF_PVT.Compare_Revision';
6820:
6821: -- Do nothing in cancel or timeout mode
6822: if (funcmode <> wf_engine.eng_run) then
6823:
6824: resultout := wf_engine.eng_null;
6825: return;
6826:

Line 6824: resultout := wf_engine.eng_null;

6820:
6821: -- Do nothing in cancel or timeout mode
6822: if (funcmode <> wf_engine.eng_run) then
6823:
6824: resultout := wf_engine.eng_null;
6825: return;
6826:
6827: end if;
6828:

Line 6863: resultout := wf_engine.eng_completed || ':' || 'N' ;

6859: where po_release_id=l_doc_id;
6860: end if;
6861:
6862: if(nvl(l_old_doc_revision, -1)=nvl(l_doc_revision, -1)) then
6863: resultout := wf_engine.eng_completed || ':' || 'N' ;
6864: else
6865: resultout := wf_engine.eng_completed || ':' || 'Y' ;
6866: end if;
6867: x_progress := 'PO_ReqChangeRequestWF_PVT.Compare_Revision: 02';

Line 6865: resultout := wf_engine.eng_completed || ':' || 'Y' ;

6861:
6862: if(nvl(l_old_doc_revision, -1)=nvl(l_doc_revision, -1)) then
6863: resultout := wf_engine.eng_completed || ':' || 'N' ;
6864: else
6865: resultout := wf_engine.eng_completed || ':' || 'Y' ;
6866: end if;
6867: x_progress := 'PO_ReqChangeRequestWF_PVT.Compare_Revision: 02';
6868:
6869: EXCEPTION

Line 6919: if (funcmode <> wf_engine.eng_run) then

6915:
6916: x_progress := 'PO_ReqChangeRequestWF_PVT.Record_Buyer_Rejection';
6917:
6918: -- Do nothing in cancel or timeout mode
6919: if (funcmode <> wf_engine.eng_run) then
6920: resultout := wf_engine.eng_null;
6921: return;
6922: end if;
6923:

Line 6920: resultout := wf_engine.eng_null;

6916: x_progress := 'PO_ReqChangeRequestWF_PVT.Record_Buyer_Rejection';
6917:
6918: -- Do nothing in cancel or timeout mode
6919: if (funcmode <> wf_engine.eng_run) then
6920: resultout := wf_engine.eng_null;
6921: return;
6922: end if;
6923:
6924: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (

Line 6992: if (funcmode <> wf_engine.eng_run) then

6988:
6989: x_progress := 'PO_ReqChangeRequestWF_PVT.Record_Buyer_Acceptance';
6990:
6991: -- Do nothing in cancel or timeout mode
6992: if (funcmode <> wf_engine.eng_run) then
6993: resultout := wf_engine.eng_null;
6994: return;
6995: end if;
6996:

Line 6993: resultout := wf_engine.eng_null;

6989: x_progress := 'PO_ReqChangeRequestWF_PVT.Record_Buyer_Acceptance';
6990:
6991: -- Do nothing in cancel or timeout mode
6992: if (funcmode <> wf_engine.eng_run) then
6993: resultout := wf_engine.eng_null;
6994: return;
6995: end if;
6996:
6997: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (

Line 7064: if (funcmode <> wf_engine.eng_run) then

7060: BEGIN
7061:
7062: x_progress := 'PO_ReqChangeRequestWF_PVT.Start_Process_Buy_Response_WF';
7063:
7064: if (funcmode <> wf_engine.eng_run) then
7065: resultout := wf_engine.eng_null;
7066: return;
7067: end if;
7068:

Line 7065: resultout := wf_engine.eng_null;

7061:
7062: x_progress := 'PO_ReqChangeRequestWF_PVT.Start_Process_Buy_Response_WF';
7063:
7064: if (funcmode <> wf_engine.eng_run) then
7065: resultout := wf_engine.eng_null;
7066: return;
7067: end if;
7068:
7069: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (

Line 7146: if (funcmode <> wf_engine.eng_run) then

7142: x_progress := 'PO_ReqChangeRequestWF_PVT.Insert_Buyer_Action_History: 01';
7143:
7144: -- Do nothing in cancel or timeout mode
7145: --
7146: if (funcmode <> wf_engine.eng_run) then
7147: resultout := wf_engine.eng_null;
7148: return;
7149: end if;
7150:

Line 7147: resultout := wf_engine.eng_null;

7143:
7144: -- Do nothing in cancel or timeout mode
7145: --
7146: if (funcmode <> wf_engine.eng_run) then
7147: resultout := wf_engine.eng_null;
7148: return;
7149: end if;
7150:
7151: l_change_request_group_id:= PO_WF_UTIL_PKG.GetItemAttrNumber (

Line 7221: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED' ;

7217:
7218: InsertActionHist(itemtype,itemkey,l_doc_id, l_doc_type,
7219: l_doc_subtype, l_employee_id, l_action, l_note, null);
7220:
7221: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED' ;
7222:
7223: x_progress := 'PO_ReqChangeRequestWF_PVT.Insert_Buyer_Action_History: 02';
7224:
7225: EXCEPTION

Line 7275: if (funcmode <> wf_engine.eng_run) then

7271:
7272: x_progress := 'PO_ReqChangeRequestWF_PVT.Process_Buyer_Rejection';
7273:
7274: -- Do nothing in cancel or timeout mode
7275: if (funcmode <> wf_engine.eng_run) then
7276: resultout := wf_engine.eng_null;
7277: return;
7278: end if;
7279:

Line 7276: resultout := wf_engine.eng_null;

7272: x_progress := 'PO_ReqChangeRequestWF_PVT.Process_Buyer_Rejection';
7273:
7274: -- Do nothing in cancel or timeout mode
7275: if (funcmode <> wf_engine.eng_run) then
7276: resultout := wf_engine.eng_null;
7277: return;
7278: end if;
7279:
7280:

Line 7352: if (funcmode <> wf_engine.eng_run) then

7348:
7349: x_progress := 'PO_ReqChangeRequestWF_PVT.Process_Cancel_Acceptance';
7350:
7351: -- Do nothing in cancel or timeout mode
7352: if (funcmode <> wf_engine.eng_run) then
7353: resultout := wf_engine.eng_null;
7354: return;
7355: end if;
7356:

Line 7353: resultout := wf_engine.eng_null;

7349: x_progress := 'PO_ReqChangeRequestWF_PVT.Process_Cancel_Acceptance';
7350:
7351: -- Do nothing in cancel or timeout mode
7352: if (funcmode <> wf_engine.eng_run) then
7353: resultout := wf_engine.eng_null;
7354: return;
7355: end if;
7356:
7357: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

Line 7440: if (funcmode <> wf_engine.eng_run) then

7436:
7437: x_progress := 'PO_ReqChangeRequestWF_PVT.Change_Acceptance_Exists';
7438:
7439: -- Do nothing in cancel or timeout mode
7440: if (funcmode <> wf_engine.eng_run) then
7441: resultout := wf_engine.eng_null;
7442: return;
7443: end if;
7444:

Line 7441: resultout := wf_engine.eng_null;

7437: x_progress := 'PO_ReqChangeRequestWF_PVT.Change_Acceptance_Exists';
7438:
7439: -- Do nothing in cancel or timeout mode
7440: if (funcmode <> wf_engine.eng_run) then
7441: resultout := wf_engine.eng_null;
7442: return;
7443: end if;
7444:
7445: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

Line 7464: resultout := wf_engine.eng_completed || ':' || 'N' ;

7460: close accepted_change;
7461:
7462: if(l_change_request_id is null) then
7463: -- not exist
7464: resultout := wf_engine.eng_completed || ':' || 'N' ;
7465: else
7466: resultout := wf_engine.eng_completed || ':' || 'Y' ;
7467: end if;
7468: x_progress := 'PO_ReqChangeRequestWF_PVT.Change_Acceptance_Exists: 02';

Line 7466: resultout := wf_engine.eng_completed || ':' || 'Y' ;

7462: if(l_change_request_id is null) then
7463: -- not exist
7464: resultout := wf_engine.eng_completed || ':' || 'N' ;
7465: else
7466: resultout := wf_engine.eng_completed || ':' || 'Y' ;
7467: end if;
7468: x_progress := 'PO_ReqChangeRequestWF_PVT.Change_Acceptance_Exists: 02';
7469:
7470: EXCEPTION

Line 7517: if (funcmode <> wf_engine.eng_run) then

7513: x_progress := 'PO_ReqChangeRequestWF_PVT.Process_Change_Acceptance';
7514:
7515:
7516: -- Do nothing in cancel or timeout mode
7517: if (funcmode <> wf_engine.eng_run) then
7518:
7519: resultout := wf_engine.eng_null;
7520: return;
7521:

Line 7519: resultout := wf_engine.eng_null;

7515:
7516: -- Do nothing in cancel or timeout mode
7517: if (funcmode <> wf_engine.eng_run) then
7518:
7519: resultout := wf_engine.eng_null;
7520: return;
7521:
7522: end if;
7523:

Line 7637: if (funcmode <> wf_engine.eng_run) then

7633: x_progress := 'PO_ReqChangeRequestWF_PVT.Start_Poapprv_WF';
7634:
7635:
7636: -- Do nothing in cancel or timeout mode
7637: if (funcmode <> wf_engine.eng_run) then
7638:
7639: resultout := wf_engine.eng_null;
7640: return;
7641:

Line 7639: resultout := wf_engine.eng_null;

7635:
7636: -- Do nothing in cancel or timeout mode
7637: if (funcmode <> wf_engine.eng_run) then
7638:
7639: resultout := wf_engine.eng_null;
7640: return;
7641:
7642: end if;
7643:

Line 7765: if (funcmode <> wf_engine.eng_run) then

7761:
7762: x_progress := 'PO_ReqChangeRequestWF_PVT.Req_Change_Responded';
7763:
7764: -- Do nothing in cancel or timeout mode
7765: if (funcmode <> wf_engine.eng_run) then
7766: resultout := wf_engine.eng_null;
7767: return;
7768: end if;
7769:

Line 7766: resultout := wf_engine.eng_null;

7762: x_progress := 'PO_ReqChangeRequestWF_PVT.Req_Change_Responded';
7763:
7764: -- Do nothing in cancel or timeout mode
7765: if (funcmode <> wf_engine.eng_run) then
7766: resultout := wf_engine.eng_null;
7767: return;
7768: end if;
7769:
7770: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

Line 7790: resultout := wf_engine.eng_completed || ':' || 'Y' ;

7786: fetch pending_parent_change_csr into l_change_request_id;
7787: close pending_parent_change_csr;
7788:
7789: if(l_change_request_id is null) then
7790: resultout := wf_engine.eng_completed || ':' || 'Y' ;
7791: else
7792: resultout := wf_engine.eng_completed || ':' || 'N' ;
7793: end if;
7794:

Line 7792: resultout := wf_engine.eng_completed || ':' || 'N' ;

7788:
7789: if(l_change_request_id is null) then
7790: resultout := wf_engine.eng_completed || ':' || 'Y' ;
7791: else
7792: resultout := wf_engine.eng_completed || ':' || 'N' ;
7793: end if;
7794:
7795: x_progress := 'PO_ReqChangeRequestWF_PVT.Req_Change_Responded: 02';
7796:

Line 7839: if (funcmode <> wf_engine.eng_run) then

7835:
7836:
7837: -- Do nothing in cancel or timeout mode
7838: --
7839: if (funcmode <> wf_engine.eng_run) then
7840:
7841: resultout := wf_engine.eng_null;
7842: return;
7843:

Line 7841: resultout := wf_engine.eng_null;

7837: -- Do nothing in cancel or timeout mode
7838: --
7839: if (funcmode <> wf_engine.eng_run) then
7840:
7841: resultout := wf_engine.eng_null;
7842: return;
7843:
7844: end if;
7845:

Line 7872: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';

7868:
7869: SetReqChangeFlag(l_req_change_request_group_id, l_document_id, itemtype, itemkey, 'N');
7870:
7871: --
7872: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
7873: --
7874:
7875: x_progress := 'PO_REQAPPROVAL_INIT1.Reset_Req_Change_Flag: 03';
7876:

Line 7911: t_varname Wf_Engine.NameTabTyp;

7907: l_req_item_type wf_items.item_type%type;
7908: x_progress varchar2(100);
7909: l_functional_currency varchar2(200);
7910: l_total_amount_dsp varchar2(100);
7911: t_varname Wf_Engine.NameTabTyp;
7912: t_varval Wf_Engine.TextTabTyp;
7913: l_doc_string varchar2(200);
7914: l_preparer_user_name varchar2(100);
7915: l_note po_action_history.note%TYPE;

Line 7912: t_varval Wf_Engine.TextTabTyp;

7908: x_progress varchar2(100);
7909: l_functional_currency varchar2(200);
7910: l_total_amount_dsp varchar2(100);
7911: t_varname Wf_Engine.NameTabTyp;
7912: t_varval Wf_Engine.TextTabTyp;
7913: l_doc_string varchar2(200);
7914: l_preparer_user_name varchar2(100);
7915: l_note po_action_history.note%TYPE;
7916: l_old_amount_currency varchar2(40);

Line 7948: if (funcmode <> wf_engine.eng_run) then

7944:
7945: x_progress := 'PO_ReqChangeRequestWF_PVT.Get_Total_Amount_Currency: 01';
7946:
7947: -- Do nothing in cancel or timeout mode
7948: if (funcmode <> wf_engine.eng_run) then
7949: resultout := wf_engine.eng_null;
7950: return;
7951: end if;
7952:

Line 7949: resultout := wf_engine.eng_null;

7945: x_progress := 'PO_ReqChangeRequestWF_PVT.Get_Total_Amount_Currency: 01';
7946:
7947: -- Do nothing in cancel or timeout mode
7948: if (funcmode <> wf_engine.eng_run) then
7949: resultout := wf_engine.eng_null;
7950: return;
7951: end if;
7952:
7953: -- Set the multi-org context

Line 8175: Wf_Engine.SetItemAttrTextArray(itemtype, itemkey,t_varname,t_varval);

8171:
8172: t_varname(10) := 'PREPARER_USER_NAME';
8173: t_varval(10) := l_preparer_user_name;
8174:
8175: Wf_Engine.SetItemAttrTextArray(itemtype, itemkey,t_varname,t_varval);
8176:
8177: x_progress := 'PO_REQAPPROVAL_INIT1.Get_Total_Amount_Currency: 04';
8178:
8179: --bug 5379796, if POREQCHA is not available, we need to get notification related

Line 8300: Wf_Engine.SetItemAttrTextArray(itemtype, itemkey,t_varname,t_varval);

8296:
8297: t_varname(6) := 'NEW_TOTAL_AMOUNT_DSP';
8298: t_varval(6) := l_functional_currency ;
8299:
8300: Wf_Engine.SetItemAttrTextArray(itemtype, itemkey,t_varname,t_varval);
8301:
8302: x_progress := 'PO_ReqChangeRequestWF_PVT.Get_Total_Amount_Currency: 08';
8303:
8304: end if;

Line 8306: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';

8302: x_progress := 'PO_ReqChangeRequestWF_PVT.Get_Total_Amount_Currency: 08';
8303:
8304: end if;
8305: --
8306: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
8307: --
8308:
8309: x_progress := 'PO_REQAPPROVAL_INIT1.Get_Total_Amount_Currency: 02';
8310:

Line 8364: if (funcmode <> wf_engine.eng_run) then

8360: x_progress := 'PO_ReqChangeRequestWF_PVT.Req_Change_Responded';
8361:
8362:
8363: -- Do nothing in cancel or timeout mode
8364: if (funcmode <> wf_engine.eng_run) then
8365:
8366: resultout := wf_engine.eng_null;
8367: return;
8368:

Line 8366: resultout := wf_engine.eng_null;

8362:
8363: -- Do nothing in cancel or timeout mode
8364: if (funcmode <> wf_engine.eng_run) then
8365:
8366: resultout := wf_engine.eng_null;
8367: return;
8368:
8369: end if;
8370:

Line 8403: resultout := wf_engine.eng_completed || ':' || 'Y' ;

8399: close pending_child_change;
8400:
8401: if(l_change_request_id is null) then
8402:
8403: resultout := wf_engine.eng_completed || ':' || 'Y' ;
8404: else
8405: resultout := wf_engine.eng_completed || ':' || 'N' ;
8406: end if;
8407: else

Line 8405: resultout := wf_engine.eng_completed || ':' || 'N' ;

8401: if(l_change_request_id is null) then
8402:
8403: resultout := wf_engine.eng_completed || ':' || 'Y' ;
8404: else
8405: resultout := wf_engine.eng_completed || ':' || 'N' ;
8406: end if;
8407: else
8408: resultout := wf_engine.eng_completed || ':' || 'N' ;
8409: end if;

Line 8408: resultout := wf_engine.eng_completed || ':' || 'N' ;

8404: else
8405: resultout := wf_engine.eng_completed || ':' || 'N' ;
8406: end if;
8407: else
8408: resultout := wf_engine.eng_completed || ':' || 'N' ;
8409: end if;
8410:
8411: x_progress := 'PO_ReqChangeRequestWF_PVT.REQ_PO_CHANGE_RESPONDED: 02';
8412:

Line 8656: if (funcmode <> wf_engine.eng_run) then

8652:
8653: x_progress := 'PO_ReqChangeRequestWF_PVT.New_PO_Change_Exists';
8654:
8655: -- Do nothing in cancel or timeout mode
8656: if (funcmode <> wf_engine.eng_run) then
8657: resultout := wf_engine.eng_null;
8658: return;
8659: end if;
8660:

Line 8657: resultout := wf_engine.eng_null;

8653: x_progress := 'PO_ReqChangeRequestWF_PVT.New_PO_Change_Exists';
8654:
8655: -- Do nothing in cancel or timeout mode
8656: if (funcmode <> wf_engine.eng_run) then
8657: resultout := wf_engine.eng_null;
8658: return;
8659: end if;
8660:
8661: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

Line 8692: resultout := wf_engine.eng_completed || ':' || 'N' ;

8688: --Moved the update to po_headers/po_releases to an autonomous transaction procedure UpdatePODocheaderTables
8689: --to avoid deadlock in POAPPRV workflow while updating the Order status for a change request response.
8690: UpdatePODocHeaderTables(l_document_type, l_document_id);
8691:
8692: resultout := wf_engine.eng_completed || ':' || 'N' ;
8693: else
8694: resultout := wf_engine.eng_completed || ':' || 'Y' ;
8695: end if;
8696:

Line 8694: resultout := wf_engine.eng_completed || ':' || 'Y' ;

8690: UpdatePODocHeaderTables(l_document_type, l_document_id);
8691:
8692: resultout := wf_engine.eng_completed || ':' || 'N' ;
8693: else
8694: resultout := wf_engine.eng_completed || ':' || 'Y' ;
8695: end if;
8696:
8697: x_progress := 'PO_ReqChangeRequestWF_PVT.New_PO_Change_Exists: 02';
8698:

Line 8739: if (funcmode <> wf_engine.eng_run) then

8735: x_progress := 'PO_ReqChangeRequestWF_PVT.Record_PO_Approval';
8736:
8737:
8738: -- Do nothing in cancel or timeout mode
8739: if (funcmode <> wf_engine.eng_run) then
8740:
8741: resultout := wf_engine.eng_null;
8742: return;
8743:

Line 8741: resultout := wf_engine.eng_null;

8737:
8738: -- Do nothing in cancel or timeout mode
8739: if (funcmode <> wf_engine.eng_run) then
8740:
8741: resultout := wf_engine.eng_null;
8742: return;
8743:
8744: end if;
8745:

Line 8805: if (funcmode <> wf_engine.eng_run) then

8801: x_progress := 'PO_ReqChangeRequestWF_PVT.Record_PO_Rejection';
8802:
8803:
8804: -- Do nothing in cancel or timeout mode
8805: if (funcmode <> wf_engine.eng_run) then
8806:
8807: resultout := wf_engine.eng_null;
8808: return;
8809:

Line 8807: resultout := wf_engine.eng_null;

8803:
8804: -- Do nothing in cancel or timeout mode
8805: if (funcmode <> wf_engine.eng_run) then
8806:
8807: resultout := wf_engine.eng_null;
8808: return;
8809:
8810: end if;
8811:

Line 8874: if (funcmode <> wf_engine.eng_run) then

8870: x_progress := 'PO_ReqChangeRequestWF_PVT.Validate_Chg_Against_New_PO';
8871:
8872:
8873: -- Do nothing in cancel or timeout mode
8874: if (funcmode <> wf_engine.eng_run) then
8875:
8876: resultout := wf_engine.eng_null;
8877: return;
8878:

Line 8876: resultout := wf_engine.eng_null;

8872:
8873: -- Do nothing in cancel or timeout mode
8874: if (funcmode <> wf_engine.eng_run) then
8875:
8876: resultout := wf_engine.eng_null;
8877: return;
8878:
8879: end if;
8880:

Line 9159: wf_engine.abortprocess(l_wf_item_type, l_wf_item_key);

9155: -- no pending change request in status 'new' or 'mgr_pre_app'
9156: -- so we need start the convert into po change
9157: -- workflow to convert the change request.
9158: begin
9159: wf_engine.abortprocess(l_wf_item_type, l_wf_item_key);
9160:
9161: l_note := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => l_wf_item_type,
9162: itemkey => l_wf_item_key,
9163: aname => 'NOTE');

Line 9434: wf_engine.AbortProcess(l_item_type, l_item_key);

9430: open l_notif_status_csr('NEW_PO_CHANGE');
9431: fetch l_notif_status_csr into l_notif_status, l_notification_id;
9432: if(l_notif_status_csr%FOUND) then
9433: if(l_notif_status='OPEN') then
9434: wf_engine.AbortProcess(l_item_type, l_item_key);
9435: end if;
9436: end if;
9437: close l_notif_status_csr;
9438: end if;

Line 9969: if (funcmode <> wf_engine.eng_run) then

9965: BEGIN
9966: x_progress := 'PO_ReqChangeRequestWF_PVT.Set_Buyer_Approval_Notfn_Attr: 01';
9967:
9968: -- Do nothing in cancel or timeout mode
9969: if (funcmode <> wf_engine.eng_run) then
9970: resultout := wf_engine.eng_null;
9971: return;
9972: end if;
9973:

Line 9970: resultout := wf_engine.eng_null;

9966: x_progress := 'PO_ReqChangeRequestWF_PVT.Set_Buyer_Approval_Notfn_Attr: 01';
9967:
9968: -- Do nothing in cancel or timeout mode
9969: if (funcmode <> wf_engine.eng_run) then
9970: resultout := wf_engine.eng_null;
9971: return;
9972: end if;
9973:
9974: l_doc_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

Line 10229: if (funcmode <> wf_engine.eng_run) then

10225:
10226:
10227: -- Do nothing in cancel or timeout mode
10228: --
10229: if (funcmode <> wf_engine.eng_run) then
10230:
10231: resultout := wf_engine.eng_null;
10232: return;
10233:

Line 10231: resultout := wf_engine.eng_null;

10227: -- Do nothing in cancel or timeout mode
10228: --
10229: if (funcmode <> wf_engine.eng_run) then
10230:
10231: resultout := wf_engine.eng_null;
10232: return;
10233:
10234: end if;
10235:

Line 10264: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';

10260: StartInformBuyerWF(l_po_chg_request_group_id);
10261:
10262: x_progress := 'PO_ReqChangeRequestWF_PVT.Start_POChange_WF: 06';
10263:
10264: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
10265:
10266: EXCEPTION
10267: WHEN OTHERS THEN
10268: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);

Line 10394: resultout := wf_engine.eng_completed || ':' || l_result;

10390: END IF;
10391:
10392: END IF;
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;

Line 10424: if (funcmode <> wf_engine.eng_run) then

10420: l_po_document_id po_change_requests.document_header_id%type;
10421: l_progress VARCHAR2(100);
10422: BEGIN
10423: -- Do nothing in cancel or timeout mode
10424: if (funcmode <> wf_engine.eng_run) then
10425:
10426: resultout := wf_engine.eng_null;
10427: return;
10428:

Line 10426: resultout := wf_engine.eng_null;

10422: BEGIN
10423: -- Do nothing in cancel or timeout mode
10424: if (funcmode <> wf_engine.eng_run) then
10425:
10426: resultout := wf_engine.eng_null;
10427: return;
10428:
10429: end if;
10430:

Line 10491: resultout := wf_engine.eng_completed || ':' || l_result;

10487: avalue => l_po_document_id );
10488: l_result := 'Y';
10489: END IF;
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;

Line 10531: if (funcmode <> wf_engine.eng_run) then

10527:
10528: BEGIN
10529:
10530: -- Do nothing in cancel or timeout mode
10531: if (funcmode <> wf_engine.eng_run) then
10532:
10533: resultout := wf_engine.eng_null;
10534: return;
10535:

Line 10533: resultout := wf_engine.eng_null;

10529:
10530: -- Do nothing in cancel or timeout mode
10531: if (funcmode <> wf_engine.eng_run) then
10532:
10533: resultout := wf_engine.eng_null;
10534: return;
10535:
10536: end if;
10537:

Line 10689: if (funcmode <> wf_engine.eng_run) then

10685:
10686: l_progress := 'PO_ReqChangeRequestWF_PVT.Set_Buyer_FYI_Notif_Attributes: 01';
10687:
10688: -- Do nothing in cancel or timeout mode
10689: if (funcmode <> wf_engine.eng_run) then
10690: resultout := wf_engine.eng_null;
10691: return;
10692: end if;
10693:

Line 10690: resultout := wf_engine.eng_null;

10686: l_progress := 'PO_ReqChangeRequestWF_PVT.Set_Buyer_FYI_Notif_Attributes: 01';
10687:
10688: -- Do nothing in cancel or timeout mode
10689: if (funcmode <> wf_engine.eng_run) then
10690: resultout := wf_engine.eng_null;
10691: return;
10692: end if;
10693:
10694: l_progress := 'PO_ReqChangeRequestWF_PVT.Set_Buyer_FYI_Notif_Attributes: 02';

Line 11177: IF (funcmode <> wf_engine.eng_run) THEN

11173:
11174: BEGIN
11175:
11176: -- Do nothing in cancel or timeout mode
11177: IF (funcmode <> wf_engine.eng_run) THEN
11178: resultout := wf_engine.eng_null;
11179: RETURN;
11180: END IF;
11181:

Line 11178: resultout := wf_engine.eng_null;

11174: BEGIN
11175:
11176: -- Do nothing in cancel or timeout mode
11177: IF (funcmode <> wf_engine.eng_run) THEN
11178: resultout := wf_engine.eng_null;
11179: RETURN;
11180: END IF;
11181:
11182: l_pochggrp_id := PO_WF_UTIL_PKG.GetItemAttrNumber( itemtype => itemtype,

Line 11270: resultout := wf_engine.eng_completed || ':' || l_return_val;

11266: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, l_api_name || ' Return Value:' || l_return_val);
11267: END IF;
11268:
11269: -- set result value
11270: resultout := wf_engine.eng_completed || ':' || l_return_val;
11271:
11272: END IF; -- IF ( p_funcmode = 'RUN' )
11273:
11274: EXCEPTION WHEN OTHERS THEN

Line 11279: resultout := wf_engine.eng_completed || ':N';

11275: -- if something is wrong, just assume it needs approval
11276: IF (g_po_wf_debug = 'Y') THEN
11277: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, l_progress || 'SQL ERROR:' || sqlerrm);
11278: END IF;
11279: resultout := wf_engine.eng_completed || ':N';
11280: END Changes_Wthn_Buyer_Tol_values;
11281:
11282: /*************************************************************************
11283: * Public Procedure: More_Req_To_Process

Line 11307: IF (funcmode <> wf_engine.eng_run) THEN

11303: l_progress VARCHAR2(100);
11304:
11305: BEGIN
11306: -- Do nothing in cancel or timeout mode
11307: IF (funcmode <> wf_engine.eng_run) THEN
11308:
11309: resultout := wf_engine.eng_null;
11310: return;
11311:

Line 11309: resultout := wf_engine.eng_null;

11305: BEGIN
11306: -- Do nothing in cancel or timeout mode
11307: IF (funcmode <> wf_engine.eng_run) THEN
11308:
11309: resultout := wf_engine.eng_null;
11310: return;
11311:
11312: END IF;
11313:

Line 11367: resultout := wf_engine.eng_completed || ':' || l_result;

11363: avalue => l_document_num );
11364: l_result := 'Y';
11365: END IF;
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;

Line 11399: IF (funcmode <> wf_engine.eng_run) THEN

11395: BEGIN
11396:
11397: l_progress := 'PO_ReqChangeRequestWF_PVT.Start_Notify_Requester_Process : 01';
11398:
11399: IF (funcmode <> wf_engine.eng_run) THEN
11400: resultout := wf_engine.eng_null;
11401: return;
11402: END IF;
11403:

Line 11400: resultout := wf_engine.eng_null;

11396:
11397: l_progress := 'PO_ReqChangeRequestWF_PVT.Start_Notify_Requester_Process : 01';
11398:
11399: IF (funcmode <> wf_engine.eng_run) THEN
11400: resultout := wf_engine.eng_null;
11401: return;
11402: END IF;
11403:
11404: -- Set the multi-org context

Line 12129: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';

12125: aname => 'INTERNAL_CHANGE_REQUEST_ID',
12126: avalue => L_CHANGE_REQUEST_ID);
12127:
12128:
12129: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
12130:
12131: EXCEPTION
12132: WHEN OTHERS THEN
12133: l_doc_string := po_reqapproval_init1.get_error_doc(itemtype, itemkey);

Line 13088: IF (funcmode <> wf_engine.eng_run) THEN

13084: --INTERNAL_CHANGE_REQUEST_ID
13085: x_progress := 'PO_ReqChangeRequestWF_PVT.SEND_INTERNAL_NOTIF: 01';
13086:
13087: -- Do nothing in cancel or timeout mode
13088: IF (funcmode <> wf_engine.eng_run) THEN
13089: resultout := wf_engine.eng_null;
13090: RETURN;
13091: END IF;
13092:

Line 13089: resultout := wf_engine.eng_null;

13085: x_progress := 'PO_ReqChangeRequestWF_PVT.SEND_INTERNAL_NOTIF: 01';
13086:
13087: -- Do nothing in cancel or timeout mode
13088: IF (funcmode <> wf_engine.eng_run) THEN
13089: resultout := wf_engine.eng_null;
13090: RETURN;
13091: END IF;
13092:
13093:

Line 13179: wf_engine.setitemattrtext(itemtype, itemkey, 'PLANNER_USER_NAME',x_planner_name);

13175: l_planner_id,
13176: x_planner_name,
13177: x_planner_display_name);
13178:
13179: wf_engine.setitemattrtext(itemtype, itemkey, 'PLANNER_USER_NAME',x_planner_name);
13180:
13181: IF (l_PLANNERS_NOTIFIED is not null) THEN -- already planners
13182: l_PLANNERS_NOTIFIED := l_PLANNERS_NOTIFIED || ',' || l_planner_id;
13183: else

Line 13187: wf_engine.setitemattrtext(itemtype, itemkey, 'PLANNERS_NOTIFIED',l_PLANNERS_NOTIFIED);

13183: else
13184: l_PLANNERS_NOTIFIED := l_planner_id; -- first planner
13185: END IF;
13186:
13187: wf_engine.setitemattrtext(itemtype, itemkey, 'PLANNERS_NOTIFIED',l_PLANNERS_NOTIFIED);
13188:
13189: END IF;
13190:
13191: IF( l_planner_id is null) THEN

Line 13192: resultout := wf_engine.eng_completed || ':' || 'NO_PLANNER';

13188:
13189: END IF;
13190:
13191: IF( l_planner_id is null) THEN
13192: resultout := wf_engine.eng_completed || ':' || 'NO_PLANNER';
13193: ELSE
13194: resultout := wf_engine.eng_completed || ':' || 'NOTIFY_PLANNER';
13195: /* ELSIF l_action_type = 'MODIFICATION' AND l_planner_id is not null THEN
13196: resultout := wf_engine.eng_completed || ':' || 'NOTIFY_PLANNER_OF_CHANGE';

Line 13194: resultout := wf_engine.eng_completed || ':' || 'NOTIFY_PLANNER';

13190:
13191: IF( l_planner_id is null) THEN
13192: resultout := wf_engine.eng_completed || ':' || 'NO_PLANNER';
13193: ELSE
13194: resultout := wf_engine.eng_completed || ':' || 'NOTIFY_PLANNER';
13195: /* ELSIF l_action_type = 'MODIFICATION' AND l_planner_id is not null THEN
13196: resultout := wf_engine.eng_completed || ':' || 'NOTIFY_PLANNER_OF_CHANGE';
13197: ELSIF l_action_type = 'CANCELLATION' AND l_planner_id is not null THEN
13198: resultout := wf_engine.eng_completed || ':' || 'NOTIFY_PLANNER_OF_CANCEL';*/

Line 13196: resultout := wf_engine.eng_completed || ':' || 'NOTIFY_PLANNER_OF_CHANGE';

13192: resultout := wf_engine.eng_completed || ':' || 'NO_PLANNER';
13193: ELSE
13194: resultout := wf_engine.eng_completed || ':' || 'NOTIFY_PLANNER';
13195: /* ELSIF l_action_type = 'MODIFICATION' AND l_planner_id is not null THEN
13196: resultout := wf_engine.eng_completed || ':' || 'NOTIFY_PLANNER_OF_CHANGE';
13197: ELSIF l_action_type = 'CANCELLATION' AND l_planner_id is not null THEN
13198: resultout := wf_engine.eng_completed || ':' || 'NOTIFY_PLANNER_OF_CANCEL';*/
13199: END IF;
13200:

Line 13198: resultout := wf_engine.eng_completed || ':' || 'NOTIFY_PLANNER_OF_CANCEL';*/

13194: resultout := wf_engine.eng_completed || ':' || 'NOTIFY_PLANNER';
13195: /* ELSIF l_action_type = 'MODIFICATION' AND l_planner_id is not null THEN
13196: resultout := wf_engine.eng_completed || ':' || 'NOTIFY_PLANNER_OF_CHANGE';
13197: ELSIF l_action_type = 'CANCELLATION' AND l_planner_id is not null THEN
13198: resultout := wf_engine.eng_completed || ':' || 'NOTIFY_PLANNER_OF_CANCEL';*/
13199: END IF;
13200:
13201: EXCEPTION
13202: WHEN OTHERS THEN

Line 13231: IF (funcmode <> wf_engine.eng_run) THEN

13227: --INTERNAL_CHANGE_REQUEST_ID
13228: x_progress := 'PO_ReqChangeRequestWF_PVT.NEXT_INTERNAL_NOTIF: 01';
13229:
13230: -- Do nothing in cancel or timeout mode
13231: IF (funcmode <> wf_engine.eng_run) THEN
13232: resultout := wf_engine.eng_null;
13233: RETURN;
13234: END IF;
13235:

Line 13232: resultout := wf_engine.eng_null;

13228: x_progress := 'PO_ReqChangeRequestWF_PVT.NEXT_INTERNAL_NOTIF: 01';
13229:
13230: -- Do nothing in cancel or timeout mode
13231: IF (funcmode <> wf_engine.eng_run) THEN
13232: resultout := wf_engine.eng_null;
13233: RETURN;
13234: END IF;
13235:
13236:

Line 13268: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';

13264: itemkey => itemkey,
13265: aname => 'INTERNAL_CHANGE_REQUEST_ID',
13266: avalue => L_NEW_CHANGE_REQUEST_ID);
13267:
13268: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
13269: END IF;
13270:
13271: EXCEPTION
13272: WHEN OTHERS THEN