APPS.PQH_BUDGET dependencies on PQH_WF

Line 258: l_workflow_name := pqh_wf.get_workflow_name(p_transaction_category_id => p_transaction_category_id);

254: l_wks_ovn number;
255: l_number number;
256: begin
257: hr_utility.set_location('inside '||l_proc,10);
258: l_workflow_name := pqh_wf.get_workflow_name(p_transaction_category_id => p_transaction_category_id);
259: hr_utility.set_location('workflow name is '||l_workflow_name||l_proc,20);
260: select wkd.status,wkd.parent_worksheet_detail_id,wkd.object_version_number,
261: wks.worksheet_id,wks.object_version_number
262: into l_status,l_parent_wkd_id,l_wkd_ovn,l_worksheet_id,l_wks_ovn

Line 292: hr_utility.set_location('pqh_wf1_delegate is getting failed ',82);

288: exception
289: when others then
290: hr_utility.set_location(substr(sqlerrm,1,55),80);
291: hr_utility.set_location(substr(sqlerrm,56,55),81);
292: hr_utility.set_location('pqh_wf1_delegate is getting failed ',82);
293: raise;
294: end;
295: -- as delegated row was already approved, so its balances must have gone up. Those balances
296: -- are to be brought down.

Line 310: hr_utility.set_location('pqh_wf2 is getting failed ',102);

306: exception
307: when others then
308: hr_utility.set_location(substr(sqlerrm,1,55),100);
309: hr_utility.set_location(substr(sqlerrm,56,55),101);
310: hr_utility.set_location('pqh_wf2 is getting failed ',102);
311: raise;
312: end;
313: else
314: hr_utility.set_location('status of delegated row is '||i.status,105);

Line 374: hr_utility.set_location('pqh_wf3 is getting failed ',162);

370: exception
371: when others then
372: hr_utility.set_location(substr(sqlerrm,1,55),160);
373: hr_utility.set_location(substr(sqlerrm,56,55),161);
374: hr_utility.set_location('pqh_wf3 is getting failed ',162);
375: raise;
376: end;
377: end if;
378: hr_utility.set_location('updating status for '||i.worksheet_detail_id||l_proc,153);