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.PQH_WKS_BUDGET dependencies on HR_UTILITY

Line 31: hr_utility.set_location('All grades valid',10);

27: return 'TRUE';
28: /*
29: -- Commented the grade code to return everything as valid for the time being
30: if p_position_id is null and p_job_id is null then
31: hr_utility.set_location('All grades valid',10);
32: return 'TRUE';
33: else
34: open c1;
35: fetch c1 into l_check;

Line 37: hr_utility.set_location('invalid grade:'||p_grade_id||' for pos:'||p_position_id||' and job:'||p_job_id,20);

33: else
34: open c1;
35: fetch c1 into l_check;
36: if c1%notfound then
37: hr_utility.set_location('invalid grade:'||p_grade_id||' for pos:'||p_position_id||' and job:'||p_job_id,20);
38: return 'FALSE';
39: else
40: hr_utility.set_location('valid grade:'||p_grade_id||' for pos:'||p_position_id||' and job:'||p_job_id,30);
41: return 'TRUE';

Line 40: hr_utility.set_location('valid grade:'||p_grade_id||' for pos:'||p_position_id||' and job:'||p_job_id,30);

36: if c1%notfound then
37: hr_utility.set_location('invalid grade:'||p_grade_id||' for pos:'||p_position_id||' and job:'||p_job_id,20);
38: return 'FALSE';
39: else
40: hr_utility.set_location('valid grade:'||p_grade_id||' for pos:'||p_position_id||' and job:'||p_job_id,30);
41: return 'TRUE';
42: end if;
43: end if;
44: */

Line 117: hr_utility.set_message(8302,'PQH_INVALID_WKD_PASSED');

113: fetch c1 into l_budget_unit1_id,l_budget_unit2_id,l_budget_unit3_id;
114: close c1;
115: exception
116: when others then
117: hr_utility.set_message(8302,'PQH_INVALID_WKD_PASSED');
118: hr_utility.raise_error;
119: end;
120: p_unit1_desc := get_unit_desc(l_budget_unit1_id);
121: if l_budget_unit2_id is not null then

Line 118: hr_utility.raise_error;

114: close c1;
115: exception
116: when others then
117: hr_utility.set_message(8302,'PQH_INVALID_WKD_PASSED');
118: hr_utility.raise_error;
119: end;
120: p_unit1_desc := get_unit_desc(l_budget_unit1_id);
121: if l_budget_unit2_id is not null then
122: p_unit2_desc := get_unit_desc(l_budget_unit2_id);

Line 132: hr_utility.set_message(8302,'PQH_INVALID_WKD_PASSED');

128: else
129: p_unit3_desc := null;
130: end if;
131: else
132: hr_utility.set_message(8302,'PQH_INVALID_WKD_PASSED');
133: hr_utility.raise_error;
134: end if;
135: exception
136: when others then

Line 133: hr_utility.raise_error;

129: p_unit3_desc := null;
130: end if;
131: else
132: hr_utility.set_message(8302,'PQH_INVALID_WKD_PASSED');
133: hr_utility.raise_error;
134: end if;
135: exception
136: when others then
137: p_unit1_desc := null;

Line 140: hr_utility.set_message(8302,'PQH_INVALID_WKD_PASSED');

136: when others then
137: p_unit1_desc := null;
138: p_unit2_desc := null;
139: p_unit3_desc := null;
140: hr_utility.set_message(8302,'PQH_INVALID_WKD_PASSED');
141: hr_utility.raise_error;
142: end get_all_unit_desc;
143: */
144:

Line 141: hr_utility.raise_error;

137: p_unit1_desc := null;
138: p_unit2_desc := null;
139: p_unit3_desc := null;
140: hr_utility.set_message(8302,'PQH_INVALID_WKD_PASSED');
141: hr_utility.raise_error;
142: end get_all_unit_desc;
143: */
144:
145: function get_org_hier(p_org_structure_version_id in number) return varchar2 is

Line 171: hr_utility.set_message(8302,'PQH_INVALID_UNIT_ENTERED');

167: close c1;
168: return l_system_type_cd;
169: exception
170: when others then
171: hr_utility.set_message(8302,'PQH_INVALID_UNIT_ENTERED');
172: hr_utility.raise_error;
173: end get_unit_type;
174:
175: function get_unit_desc(p_unit_id in number) return varchar2 is

Line 172: hr_utility.raise_error;

168: return l_system_type_cd;
169: exception
170: when others then
171: hr_utility.set_message(8302,'PQH_INVALID_UNIT_ENTERED');
172: hr_utility.raise_error;
173: end get_unit_type;
174:
175: function get_unit_desc(p_unit_id in number) return varchar2 is
176: l_unit_name per_shared_types_vl.shared_type_name%type;

Line 198: hr_utility.set_message(8302,'PQH_INVALID_UNIT_ENTERED');

194: close c1;
195: return l_shared_type_name;
196: exception
197: when others then
198: hr_utility.set_message(8302,'PQH_INVALID_UNIT_ENTERED');
199: hr_utility.raise_error;
200: end get_unit_desc;
201: */
202: function get_parent_value(p_worksheet_detail_id in number,

Line 199: hr_utility.raise_error;

195: return l_shared_type_name;
196: exception
197: when others then
198: hr_utility.set_message(8302,'PQH_INVALID_UNIT_ENTERED');
199: hr_utility.raise_error;
200: end get_unit_desc;
201: */
202: function get_parent_value(p_worksheet_detail_id in number,
203: p_worksheet_propagate_code in varchar2) return varchar2 is

Line 222: hr_utility.set_location('entering '||l_proc,10);

218: l_worksheet_id number;
219: l_code varchar2(3);
220: l_proc varchar2(100) := g_package||'get_parent_value' ;
221: begin
222: hr_utility.set_location('entering '||l_proc,10);
223: if p_worksheet_detail_id is not null then
224: begin
225: open c1(p_worksheet_detail_id);
226: fetch c1 into l_parent_worksheet_detail_id,l_worksheet_id;

Line 230: hr_utility.set_message(8302,'PQH_INVALID_WKD_PASSED');

226: fetch c1 into l_parent_worksheet_detail_id,l_worksheet_id;
227: close c1;
228: exception
229: when others then
230: hr_utility.set_message(8302,'PQH_INVALID_WKD_PASSED');
231: hr_utility.raise_error;
232: end;
233: if l_parent_worksheet_detail_id is null then
234: hr_utility.set_location('parent null '||l_proc,20);

Line 231: hr_utility.raise_error;

227: close c1;
228: exception
229: when others then
230: hr_utility.set_message(8302,'PQH_INVALID_WKD_PASSED');
231: hr_utility.raise_error;
232: end;
233: if l_parent_worksheet_detail_id is null then
234: hr_utility.set_location('parent null '||l_proc,20);
235: begin

Line 234: hr_utility.set_location('parent null '||l_proc,20);

230: hr_utility.set_message(8302,'PQH_INVALID_WKD_PASSED');
231: hr_utility.raise_error;
232: end;
233: if l_parent_worksheet_detail_id is null then
234: hr_utility.set_location('parent null '||l_proc,20);
235: begin
236: open c3(l_worksheet_id);
237: fetch c3 into l_code;
238: close c3;

Line 241: hr_utility.set_message(8302,'PQH_INVALID_WKS_PASSED');

237: fetch c3 into l_code;
238: close c3;
239: exception
240: when others then
241: hr_utility.set_message(8302,'PQH_INVALID_WKS_PASSED');
242: hr_utility.raise_error;
243: end;
244: return l_code;
245: else

Line 242: hr_utility.raise_error;

238: close c3;
239: exception
240: when others then
241: hr_utility.set_message(8302,'PQH_INVALID_WKS_PASSED');
242: hr_utility.raise_error;
243: end;
244: return l_code;
245: else
246: hr_utility.set_location('parent not null '||l_parent_worksheet_detail_id||l_proc,30);

Line 246: hr_utility.set_location('parent not null '||l_parent_worksheet_detail_id||l_proc,30);

242: hr_utility.raise_error;
243: end;
244: return l_code;
245: else
246: hr_utility.set_location('parent not null '||l_parent_worksheet_detail_id||l_proc,30);
247: begin
248: open c2(l_parent_worksheet_detail_id);
249: fetch c2 into l_code,l_worksheet_detail_id;
250: close c2;

Line 253: hr_utility.set_message(8302,'PQH_INVALID_WKD_PASSED');

249: fetch c2 into l_code,l_worksheet_detail_id;
250: close c2;
251: exception
252: when others then
253: hr_utility.set_message(8302,'PQH_INVALID_WKD_PASSED');
254: hr_utility.raise_error;
255: end;
256: if l_code = 'PC' then
257: l_code := get_parent_value(l_worksheet_detail_id,p_worksheet_propagate_code);

Line 254: hr_utility.raise_error;

250: close c2;
251: exception
252: when others then
253: hr_utility.set_message(8302,'PQH_INVALID_WKD_PASSED');
254: hr_utility.raise_error;
255: end;
256: if l_code = 'PC' then
257: l_code := get_parent_value(l_worksheet_detail_id,p_worksheet_propagate_code);
258: end if;

Line 259: hr_utility.set_location('l_code is '||l_code||l_proc,40);

255: end;
256: if l_code = 'PC' then
257: l_code := get_parent_value(l_worksheet_detail_id,p_worksheet_propagate_code);
258: end if;
259: hr_utility.set_location('l_code is '||l_code||l_proc,40);
260: return l_code;
261: end if;
262: else
263: l_code := p_worksheet_propagate_code;

Line 264: hr_utility.set_location('l_code is '||l_code||l_proc,50);

260: return l_code;
261: end if;
262: else
263: l_code := p_worksheet_propagate_code;
264: hr_utility.set_location('l_code is '||l_code||l_proc,50);
265: return l_code;
266: end if;
267: end;
268: function get_value(p_worksheet_detail_id in number,

Line 276: hr_utility.set_location('entering '||code||l_proc,10);

272: l_meaning varchar2(80);
273: l_meaning1 varchar2(80);
274: l_proc varchar2(100) := g_package||'get_value' ;
275: begin
276: hr_utility.set_location('entering '||code||l_proc,10);
277: if code = 'PC' then
278: l_code := get_parent_value(p_worksheet_detail_id,p_worksheet_propagate_code);
279: l_meaning := hr_general.decode_lookup('PQH_WORKSHEET_PROPAGATE_METHOD','PC');
280: l_meaning1 := hr_general.decode_lookup('PQH_WORKSHEET_PROPAGATE_METHOD',l_code);

Line 285: hr_utility.set_message(8302,'PQH_INVALID_PROPAGATION_METHOD');

281: l_meaning := l_meaning||'('||l_meaning1||')' ;
282: elsif code in ('RV','RP','UE') then
283: l_meaning := hr_general.decode_lookup('PQH_WORKSHEET_PROPAGATE_METHOD',code);
284: else
285: hr_utility.set_message(8302,'PQH_INVALID_PROPAGATION_METHOD');
286: hr_utility.raise_error;
287: end if;
288: hr_utility.set_location('exiting with meaning'||l_meaning||l_proc,50);
289: return l_meaning;

Line 286: hr_utility.raise_error;

282: elsif code in ('RV','RP','UE') then
283: l_meaning := hr_general.decode_lookup('PQH_WORKSHEET_PROPAGATE_METHOD',code);
284: else
285: hr_utility.set_message(8302,'PQH_INVALID_PROPAGATION_METHOD');
286: hr_utility.raise_error;
287: end if;
288: hr_utility.set_location('exiting with meaning'||l_meaning||l_proc,50);
289: return l_meaning;
290: end get_value;

Line 288: hr_utility.set_location('exiting with meaning'||l_meaning||l_proc,50);

284: else
285: hr_utility.set_message(8302,'PQH_INVALID_PROPAGATION_METHOD');
286: hr_utility.raise_error;
287: end if;
288: hr_utility.set_location('exiting with meaning'||l_meaning||l_proc,50);
289: return l_meaning;
290: end get_value;
291: function lookup_desc(p_lookup_type in varchar2,
292: p_lookup_code in varchar2) return varchar2 is

Line 322: hr_utility.set_message(8302,'PQH_INVALID_WKD_PASSED');

318: fetch c0 into l_worksheet_id,l_change_mode ;
319: close c0;
320: exception
321: when others then
322: hr_utility.set_message(8302,'PQH_INVALID_WKD_PASSED');
323: hr_utility.raise_error;
324: end;
325: if l_change_mode = 'PC' then
326: open c1;

Line 323: hr_utility.raise_error;

319: close c0;
320: exception
321: when others then
322: hr_utility.set_message(8302,'PQH_INVALID_WKD_PASSED');
323: hr_utility.raise_error;
324: end;
325: if l_change_mode = 'PC' then
326: open c1;
327: fetch c1 into l_wks_change_mode;

Line 490: hr_utility.set_message(8302,'PQH_WKS_MIG_INV_SET');

486: l_count number(15) ;
487: BEGIN
488: if p_worksheet_budget_set_id is not null then
489: if p_dflt_budget_set_id is null then
490: hr_utility.set_message(8302,'PQH_WKS_MIG_INV_SET');
491: hr_utility.raise_error;
492: else
493: select count(*) into l_count from pqh_worksheet_bdgt_elmnts
494: where worksheet_budget_set_id = p_worksheet_budget_set_id ;

Line 491: hr_utility.raise_error;

487: BEGIN
488: if p_worksheet_budget_set_id is not null then
489: if p_dflt_budget_set_id is null then
490: hr_utility.set_message(8302,'PQH_WKS_MIG_INV_SET');
491: hr_utility.raise_error;
492: else
493: select count(*) into l_count from pqh_worksheet_bdgt_elmnts
494: where worksheet_budget_set_id = p_worksheet_budget_set_id ;
495: if l_count = 0 then

Line 543: hr_utility.set_message(8302,'PQH_WKS_MIG_INV_SET');

539: l_object_version_number number;
540: BEGIN
541: if p_budget_set_id is not null then
542: if p_dflt_budget_set_id is null then
543: hr_utility.set_message(8302,'PQH_WKS_MIG_INV_SET');
544: hr_utility.raise_error;
545: else
546: select count(*) into l_count from pqh_budget_elements
547: where budget_set_id = p_budget_set_id ;

Line 544: hr_utility.raise_error;

540: BEGIN
541: if p_budget_set_id is not null then
542: if p_dflt_budget_set_id is null then
543: hr_utility.set_message(8302,'PQH_WKS_MIG_INV_SET');
544: hr_utility.raise_error;
545: else
546: select count(*) into l_count from pqh_budget_elements
547: where budget_set_id = p_budget_set_id ;
548: if l_count = 0 then

Line 603: hr_utility.set_location('entering '||l_proc,10);

599: l_transaction_name varchar2(200);
600: l_apply_error_mesg varchar2(200);
601: l_apply_error_num varchar2(30);
602: begin
603: hr_utility.set_location('entering '||l_proc,10);
604: for i in c1 loop
605: hr_utility.set_location('inside loop '||l_proc,11);
606: begin
607: open c2(i.user_id);

Line 605: hr_utility.set_location('inside loop '||l_proc,11);

601: l_apply_error_num varchar2(30);
602: begin
603: hr_utility.set_location('entering '||l_proc,10);
604: for i in c1 loop
605: hr_utility.set_location('inside loop '||l_proc,11);
606: begin
607: open c2(i.user_id);
608: fetch c2 into l_user_name;
609: close c2;

Line 612: hr_utility.set_location('user name fetch raised error '||l_proc,20);

608: fetch c2 into l_user_name;
609: close c2;
610: exception
611: when others then
612: hr_utility.set_location('user name fetch raised error '||l_proc,20);
613: raise;
614: end;
615: hr_utility.set_location('user name is '||l_user_name||l_proc,30);
616: hr_utility.set_location('calling process user action'||l_proc,40);

Line 615: hr_utility.set_location('user name is '||l_user_name||l_proc,30);

611: when others then
612: hr_utility.set_location('user name fetch raised error '||l_proc,20);
613: raise;
614: end;
615: hr_utility.set_location('user name is '||l_user_name||l_proc,30);
616: hr_utility.set_location('calling process user action'||l_proc,40);
617: begin
618: l_transaction_name := get_transaction_name(p_worksheet_detail_id => i.worksheet_detail_id);
619: pqh_wf.process_user_action(p_transaction_category_id => p_transaction_category_id,

Line 616: hr_utility.set_location('calling process user action'||l_proc,40);

612: hr_utility.set_location('user name fetch raised error '||l_proc,20);
613: raise;
614: end;
615: hr_utility.set_location('user name is '||l_user_name||l_proc,30);
616: hr_utility.set_location('calling process user action'||l_proc,40);
617: begin
618: l_transaction_name := get_transaction_name(p_worksheet_detail_id => i.worksheet_detail_id);
619: pqh_wf.process_user_action(p_transaction_category_id => p_transaction_category_id,
620: p_transaction_id => i.worksheet_detail_id,

Line 632: hr_utility.set_location('process user action raised error'||l_proc,50);

628: p_apply_error_mesg => l_apply_error_mesg,
629: p_apply_error_num => l_apply_error_num);
630: exception
631: when others then
632: hr_utility.set_location('process user action raised error'||l_proc,50);
633: raise;
634: end;
635: hr_utility.set_location('going to update status'||l_proc,60);
636: l_object_version_number := i.object_version_number;

Line 635: hr_utility.set_location('going to update status'||l_proc,60);

631: when others then
632: hr_utility.set_location('process user action raised error'||l_proc,50);
633: raise;
634: end;
635: hr_utility.set_location('going to update status'||l_proc,60);
636: l_object_version_number := i.object_version_number;
637: pqh_budget.update_worksheet_detail(
638: p_worksheet_detail_id => i.worksheet_detail_id,
639: p_effective_date => trunc(sysdate),

Line 643: hr_utility.set_location('updated status'||l_proc,60);

639: p_effective_date => trunc(sysdate),
640: p_object_version_number => l_object_version_number,
641: p_status => 'DELEGATED'
642: );
643: hr_utility.set_location('updated status'||l_proc,60);
644: end loop;
645: hr_utility.set_location('leaving '||l_proc,1000);
646: end delegating_org;
647: procedure wks_date_validation( p_worksheet_mode in varchar2,

Line 645: hr_utility.set_location('leaving '||l_proc,1000);

641: p_status => 'DELEGATED'
642: );
643: hr_utility.set_location('updated status'||l_proc,60);
644: end loop;
645: hr_utility.set_location('leaving '||l_proc,1000);
646: end delegating_org;
647: procedure wks_date_validation( p_worksheet_mode in varchar2,
648: p_budget_id in number,
649: p_budget_version_id in number default null,

Line 671: hr_utility.set_location('entering '||l_proc,10);

667: l_ver_chk varchar2(15);
668: l_version_number number;
669: l_proc varchar2(61) := g_package ||'wks_date_validation' ;
670: begin
671: hr_utility.set_location('entering '||l_proc,10);
672: -- mode N is edit and make new version
673: -- mode S is start from scratch
674: -- mode O is copy and edit version
675: if p_worksheet_mode not in ('N','S','O') then

Line 676: hr_utility.set_message(8302,'PQH_INVALID_WORKSHEET_MODE');

672: -- mode N is edit and make new version
673: -- mode S is start from scratch
674: -- mode O is copy and edit version
675: if p_worksheet_mode not in ('N','S','O') then
676: hr_utility.set_message(8302,'PQH_INVALID_WORKSHEET_MODE');
677: hr_utility.raise_error;
678: elsif p_budget_id is null then
679: hr_utility.set_message(8302,'PQH_INVALID_BUDGET');
680: hr_utility.raise_error;

Line 677: hr_utility.raise_error;

673: -- mode S is start from scratch
674: -- mode O is copy and edit version
675: if p_worksheet_mode not in ('N','S','O') then
676: hr_utility.set_message(8302,'PQH_INVALID_WORKSHEET_MODE');
677: hr_utility.raise_error;
678: elsif p_budget_id is null then
679: hr_utility.set_message(8302,'PQH_INVALID_BUDGET');
680: hr_utility.raise_error;
681: elsif p_worksheet_mode in ('O','N') and p_budget_version_id is null then

Line 679: hr_utility.set_message(8302,'PQH_INVALID_BUDGET');

675: if p_worksheet_mode not in ('N','S','O') then
676: hr_utility.set_message(8302,'PQH_INVALID_WORKSHEET_MODE');
677: hr_utility.raise_error;
678: elsif p_budget_id is null then
679: hr_utility.set_message(8302,'PQH_INVALID_BUDGET');
680: hr_utility.raise_error;
681: elsif p_worksheet_mode in ('O','N') and p_budget_version_id is null then
682: hr_utility.set_message(8302,'PQH_INVALID_BUDGET_VERSION');
683: hr_utility.raise_error;

Line 680: hr_utility.raise_error;

676: hr_utility.set_message(8302,'PQH_INVALID_WORKSHEET_MODE');
677: hr_utility.raise_error;
678: elsif p_budget_id is null then
679: hr_utility.set_message(8302,'PQH_INVALID_BUDGET');
680: hr_utility.raise_error;
681: elsif p_worksheet_mode in ('O','N') and p_budget_version_id is null then
682: hr_utility.set_message(8302,'PQH_INVALID_BUDGET_VERSION');
683: hr_utility.raise_error;
684: elsif p_wks_start_date is null then

Line 682: hr_utility.set_message(8302,'PQH_INVALID_BUDGET_VERSION');

678: elsif p_budget_id is null then
679: hr_utility.set_message(8302,'PQH_INVALID_BUDGET');
680: hr_utility.raise_error;
681: elsif p_worksheet_mode in ('O','N') and p_budget_version_id is null then
682: hr_utility.set_message(8302,'PQH_INVALID_BUDGET_VERSION');
683: hr_utility.raise_error;
684: elsif p_wks_start_date is null then
685: hr_utility.set_message(8302,'PQH_START_DT_NULL');
686: hr_utility.raise_error;

Line 683: hr_utility.raise_error;

679: hr_utility.set_message(8302,'PQH_INVALID_BUDGET');
680: hr_utility.raise_error;
681: elsif p_worksheet_mode in ('O','N') and p_budget_version_id is null then
682: hr_utility.set_message(8302,'PQH_INVALID_BUDGET_VERSION');
683: hr_utility.raise_error;
684: elsif p_wks_start_date is null then
685: hr_utility.set_message(8302,'PQH_START_DT_NULL');
686: hr_utility.raise_error;
687: elsif p_wks_end_date is null then

Line 685: hr_utility.set_message(8302,'PQH_START_DT_NULL');

681: elsif p_worksheet_mode in ('O','N') and p_budget_version_id is null then
682: hr_utility.set_message(8302,'PQH_INVALID_BUDGET_VERSION');
683: hr_utility.raise_error;
684: elsif p_wks_start_date is null then
685: hr_utility.set_message(8302,'PQH_START_DT_NULL');
686: hr_utility.raise_error;
687: elsif p_wks_end_date is null then
688: hr_utility.set_message(8302,'PQH_END_DT_NULL');
689: hr_utility.raise_error;

Line 686: hr_utility.raise_error;

682: hr_utility.set_message(8302,'PQH_INVALID_BUDGET_VERSION');
683: hr_utility.raise_error;
684: elsif p_wks_start_date is null then
685: hr_utility.set_message(8302,'PQH_START_DT_NULL');
686: hr_utility.raise_error;
687: elsif p_wks_end_date is null then
688: hr_utility.set_message(8302,'PQH_END_DT_NULL');
689: hr_utility.raise_error;
690: elsif p_wks_start_date > p_wks_end_date then

Line 688: hr_utility.set_message(8302,'PQH_END_DT_NULL');

684: elsif p_wks_start_date is null then
685: hr_utility.set_message(8302,'PQH_START_DT_NULL');
686: hr_utility.raise_error;
687: elsif p_wks_end_date is null then
688: hr_utility.set_message(8302,'PQH_END_DT_NULL');
689: hr_utility.raise_error;
690: elsif p_wks_start_date > p_wks_end_date then
691: hr_utility.set_message(8302,'PQH_INVALID_END_DT');
692: /* Commented and added as a part of Bug#10239077 Starts

Line 689: hr_utility.raise_error;

685: hr_utility.set_message(8302,'PQH_START_DT_NULL');
686: hr_utility.raise_error;
687: elsif p_wks_end_date is null then
688: hr_utility.set_message(8302,'PQH_END_DT_NULL');
689: hr_utility.raise_error;
690: elsif p_wks_start_date > p_wks_end_date then
691: hr_utility.set_message(8302,'PQH_INVALID_END_DT');
692: /* Commented and added as a part of Bug#10239077 Starts
693: hr_utility.set_message_token('STARTDATE',fnd_date.date_to_chardate(p_wks_start_date));

Line 691: hr_utility.set_message(8302,'PQH_INVALID_END_DT');

687: elsif p_wks_end_date is null then
688: hr_utility.set_message(8302,'PQH_END_DT_NULL');
689: hr_utility.raise_error;
690: elsif p_wks_start_date > p_wks_end_date then
691: hr_utility.set_message(8302,'PQH_INVALID_END_DT');
692: /* Commented and added as a part of Bug#10239077 Starts
693: hr_utility.set_message_token('STARTDATE',fnd_date.date_to_chardate(p_wks_start_date));
694: hr_utility.set_message_token('ENDDATE',fnd_date.date_to_chardate(p_wks_end_date)); */
695: hr_utility.set_message_token('STARTDATE',fnd_date.date_to_chardate(p_wks_start_date, calendar_aware => FND_DATE.calendar_aware_alt));

Line 693: hr_utility.set_message_token('STARTDATE',fnd_date.date_to_chardate(p_wks_start_date));

689: hr_utility.raise_error;
690: elsif p_wks_start_date > p_wks_end_date then
691: hr_utility.set_message(8302,'PQH_INVALID_END_DT');
692: /* Commented and added as a part of Bug#10239077 Starts
693: hr_utility.set_message_token('STARTDATE',fnd_date.date_to_chardate(p_wks_start_date));
694: hr_utility.set_message_token('ENDDATE',fnd_date.date_to_chardate(p_wks_end_date)); */
695: hr_utility.set_message_token('STARTDATE',fnd_date.date_to_chardate(p_wks_start_date, calendar_aware => FND_DATE.calendar_aware_alt));
696: hr_utility.set_message_token('ENDDATE',fnd_date.date_to_chardate(p_wks_end_date, calendar_aware => FND_DATE.calendar_aware_alt));
697: /* Commented and added as a part of Bug#10239077 Ends*/

Line 694: hr_utility.set_message_token('ENDDATE',fnd_date.date_to_chardate(p_wks_end_date)); */

690: elsif p_wks_start_date > p_wks_end_date then
691: hr_utility.set_message(8302,'PQH_INVALID_END_DT');
692: /* Commented and added as a part of Bug#10239077 Starts
693: hr_utility.set_message_token('STARTDATE',fnd_date.date_to_chardate(p_wks_start_date));
694: hr_utility.set_message_token('ENDDATE',fnd_date.date_to_chardate(p_wks_end_date)); */
695: hr_utility.set_message_token('STARTDATE',fnd_date.date_to_chardate(p_wks_start_date, calendar_aware => FND_DATE.calendar_aware_alt));
696: hr_utility.set_message_token('ENDDATE',fnd_date.date_to_chardate(p_wks_end_date, calendar_aware => FND_DATE.calendar_aware_alt));
697: /* Commented and added as a part of Bug#10239077 Ends*/
698: hr_utility.raise_error;

Line 695: hr_utility.set_message_token('STARTDATE',fnd_date.date_to_chardate(p_wks_start_date, calendar_aware => FND_DATE.calendar_aware_alt));

691: hr_utility.set_message(8302,'PQH_INVALID_END_DT');
692: /* Commented and added as a part of Bug#10239077 Starts
693: hr_utility.set_message_token('STARTDATE',fnd_date.date_to_chardate(p_wks_start_date));
694: hr_utility.set_message_token('ENDDATE',fnd_date.date_to_chardate(p_wks_end_date)); */
695: hr_utility.set_message_token('STARTDATE',fnd_date.date_to_chardate(p_wks_start_date, calendar_aware => FND_DATE.calendar_aware_alt));
696: hr_utility.set_message_token('ENDDATE',fnd_date.date_to_chardate(p_wks_end_date, calendar_aware => FND_DATE.calendar_aware_alt));
697: /* Commented and added as a part of Bug#10239077 Ends*/
698: hr_utility.raise_error;
699: end if;

Line 696: hr_utility.set_message_token('ENDDATE',fnd_date.date_to_chardate(p_wks_end_date, calendar_aware => FND_DATE.calendar_aware_alt));

692: /* Commented and added as a part of Bug#10239077 Starts
693: hr_utility.set_message_token('STARTDATE',fnd_date.date_to_chardate(p_wks_start_date));
694: hr_utility.set_message_token('ENDDATE',fnd_date.date_to_chardate(p_wks_end_date)); */
695: hr_utility.set_message_token('STARTDATE',fnd_date.date_to_chardate(p_wks_start_date, calendar_aware => FND_DATE.calendar_aware_alt));
696: hr_utility.set_message_token('ENDDATE',fnd_date.date_to_chardate(p_wks_end_date, calendar_aware => FND_DATE.calendar_aware_alt));
697: /* Commented and added as a part of Bug#10239077 Ends*/
698: hr_utility.raise_error;
699: end if;
700: if p_budget_version_id is not null then

Line 698: hr_utility.raise_error;

694: hr_utility.set_message_token('ENDDATE',fnd_date.date_to_chardate(p_wks_end_date)); */
695: hr_utility.set_message_token('STARTDATE',fnd_date.date_to_chardate(p_wks_start_date, calendar_aware => FND_DATE.calendar_aware_alt));
696: hr_utility.set_message_token('ENDDATE',fnd_date.date_to_chardate(p_wks_end_date, calendar_aware => FND_DATE.calendar_aware_alt));
697: /* Commented and added as a part of Bug#10239077 Ends*/
698: hr_utility.raise_error;
699: end if;
700: if p_budget_version_id is not null then
701: open c1;
702: fetch c1 into l_ver_chk;

Line 705: hr_utility.set_message(8302,'PQH_INVALID_BUDGET_VER');

701: open c1;
702: fetch c1 into l_ver_chk;
703: if c1%notfound then
704: close c1;
705: hr_utility.set_message(8302,'PQH_INVALID_BUDGET_VER');
706: hr_utility.raise_error;
707: end if;
708: close c1;
709: end if;

Line 706: hr_utility.raise_error;

702: fetch c1 into l_ver_chk;
703: if c1%notfound then
704: close c1;
705: hr_utility.set_message(8302,'PQH_INVALID_BUDGET_VER');
706: hr_utility.raise_error;
707: end if;
708: close c1;
709: end if;
710: hr_utility.set_location('wks_mode is '||p_worksheet_mode||l_proc,20);

Line 710: hr_utility.set_location('wks_mode is '||p_worksheet_mode||l_proc,20);

706: hr_utility.raise_error;
707: end if;
708: close c1;
709: end if;
710: hr_utility.set_location('wks_mode is '||p_worksheet_mode||l_proc,20);
711: if p_worksheet_mode in ('S','N') then
712: -- in the case of start from scratch, worksheet dates should be greater than all the existing
713: -- version dates as it is going to make a new version in all cases, if the dates
714: -- are not highest in that case status is returned as error

Line 720: hr_utility.set_location('max_version is '||l_max_version||l_proc,30);

716: -- gaps are also ok
717: open c0;
718: fetch c0 into l_max_version;
719: close c0;
720: hr_utility.set_location('max_version is '||l_max_version||l_proc,30);
721: open c2;
722: fetch c2 into l_max_end_date;
723: if c2%notfound then
724: hr_utility.set_location('max_end_date notfound '||l_proc,40);

Line 724: hr_utility.set_location('max_end_date notfound '||l_proc,40);

720: hr_utility.set_location('max_version is '||l_max_version||l_proc,30);
721: open c2;
722: fetch c2 into l_max_end_date;
723: if c2%notfound then
724: hr_utility.set_location('max_end_date notfound '||l_proc,40);
725: if p_worksheet_mode ='S' then
726: -- no dates in the budget version as it is a initial case so
727: p_status := 'SUCCESS' ;
728: else

Line 733: hr_utility.set_location('max_end_date is '||l_max_end_date||l_proc,50);

729: -- mode is correction but no records
730: p_status := 'ERROR' ;
731: end if;
732: else
733: hr_utility.set_location('max_end_date is '||l_max_end_date||l_proc,50);
734: if l_max_end_date is not null then
735: if p_wks_start_date = l_max_end_date + 1 then
736: -- start date is valid as it is not overlapping and nor giving any gap.
737: p_wks_ll_date := l_max_end_date+1 ;

Line 754: hr_utility.set_location('end of validation with status'||p_status||l_proc,60);

750: p_status := 'SUCCESS' ;
751: end if;
752: end if;
753: close c2;
754: hr_utility.set_location('end of validation with status'||p_status||l_proc,60);
755: else
756: open c3;
757: fetch c3 into l_version_number;
758: close c3;

Line 766: hr_utility.set_location('end of validation with status'||p_status||l_proc,170);

762: p_date_to => p_wks_end_date,
763: p_bgv_ll_date => p_wks_ll_date,
764: p_bgv_ul_date => p_wks_ul_date,
765: p_status => p_status ) ;
766: hr_utility.set_location('end of validation with status'||p_status||l_proc,170);
767: end if;
768: exception when others then
769: p_wks_ll_date := null;
770: p_wks_ul_date := null;

Line 800: hr_utility.set_location('entering bootom_up for wkd'||p_worksheet_detail_id,05);

796: l_budget_unit3_value number;
797: l_lck_success boolean := FALSE;
798: l_status varchar2(30) ;
799: begin
800: hr_utility.set_location('entering bootom_up for wkd'||p_worksheet_detail_id,05);
801: for i in c1 loop
802: hr_utility.set_location('inside the loop for wkd'||i.worksheet_detail_id,10);
803: begin
804: hr_utility.set_location('going to lock'||i.worksheet_detail_id,20);

Line 802: hr_utility.set_location('inside the loop for wkd'||i.worksheet_detail_id,10);

798: l_status varchar2(30) ;
799: begin
800: hr_utility.set_location('entering bootom_up for wkd'||p_worksheet_detail_id,05);
801: for i in c1 loop
802: hr_utility.set_location('inside the loop for wkd'||i.worksheet_detail_id,10);
803: begin
804: hr_utility.set_location('going to lock'||i.worksheet_detail_id,20);
805: pqh_wdt_shd.lck(p_worksheet_detail_id => i.worksheet_detail_id,
806: p_object_version_number => i.object_version_number );

Line 804: hr_utility.set_location('going to lock'||i.worksheet_detail_id,20);

800: hr_utility.set_location('entering bootom_up for wkd'||p_worksheet_detail_id,05);
801: for i in c1 loop
802: hr_utility.set_location('inside the loop for wkd'||i.worksheet_detail_id,10);
803: begin
804: hr_utility.set_location('going to lock'||i.worksheet_detail_id,20);
805: pqh_wdt_shd.lck(p_worksheet_detail_id => i.worksheet_detail_id,
806: p_object_version_number => i.object_version_number );
807: l_lck_success := TRUE;
808: hr_utility.set_location('lock success',30);

Line 808: hr_utility.set_location('lock success',30);

804: hr_utility.set_location('going to lock'||i.worksheet_detail_id,20);
805: pqh_wdt_shd.lck(p_worksheet_detail_id => i.worksheet_detail_id,
806: p_object_version_number => i.object_version_number );
807: l_lck_success := TRUE;
808: hr_utility.set_location('lock success',30);
809: exception
810: when others then
811: hr_utility.set_location('lock failed',40);
812: l_lck_success := FALSE;

Line 811: hr_utility.set_location('lock failed',40);

807: l_lck_success := TRUE;
808: hr_utility.set_location('lock success',30);
809: exception
810: when others then
811: hr_utility.set_location('lock failed',40);
812: l_lck_success := FALSE;
813: if p_status <> 'LOCK' then
814: p_status := 'LOCK';
815: end if;

Line 818: hr_utility.set_location('going for propagation',50);

814: p_status := 'LOCK';
815: end if;
816: end;
817: if l_lck_success then
818: hr_utility.set_location('going for propagation',50);
819: l_object_version_number := i.object_version_number;
820: l_budget_unit1_value := i.budget_unit1_value;
821: l_budget_unit2_value := i.budget_unit2_value;
822: l_budget_unit3_value := i.budget_unit3_value;

Line 823: hr_utility.set_location('calling propagate bottom_up',60);

819: l_object_version_number := i.object_version_number;
820: l_budget_unit1_value := i.budget_unit1_value;
821: l_budget_unit2_value := i.budget_unit2_value;
822: l_budget_unit3_value := i.budget_unit3_value;
823: hr_utility.set_location('calling propagate bottom_up',60);
824: begin
825: propagate_bottom_up(p_worksheet_detail_id => i.worksheet_detail_id,
826: p_budget_unit1_value => l_budget_unit1_value,
827: p_budget_unit2_value => l_budget_unit2_value,

Line 848: hr_utility.set_location('end of the loop for wkd'||i.worksheet_detail_id,120);

844: p_old_unit1_value => l_budget_unit1_value,
845: p_old_unit2_value => l_budget_unit2_value,
846: p_old_unit3_value => l_budget_unit3_value);
847: end if;
848: hr_utility.set_location('end of the loop for wkd'||i.worksheet_detail_id,120);
849: end loop;
850: hr_utility.set_location('exiting propagate_bottom_up for wkd'||p_worksheet_detail_id,130);
851: exception when others then
852: p_budget_unit1_value := init_budget_unit1_value;

Line 850: hr_utility.set_location('exiting propagate_bottom_up for wkd'||p_worksheet_detail_id,130);

846: p_old_unit3_value => l_budget_unit3_value);
847: end if;
848: hr_utility.set_location('end of the loop for wkd'||i.worksheet_detail_id,120);
849: end loop;
850: hr_utility.set_location('exiting propagate_bottom_up for wkd'||p_worksheet_detail_id,130);
851: exception when others then
852: p_budget_unit1_value := init_budget_unit1_value;
853: p_budget_unit2_value := init_budget_unit2_value;
854: p_budget_unit3_value := init_budget_unit3_value;

Line 884: hr_utility.set_location('entering '||l_proc,10);

880: l_rows_inserted number := 0;
881: l_object_version_number number := 1;
882: l_proc varchar2(100) := g_package||'populate_bud_grades' ;
883: begin
884: hr_utility.set_location('entering '||l_proc,10);
885: open c0;
886: fetch c0 into l_budget_start_date,l_budget_end_date,l_valid_grade_flag,l_budgeted_entity_cd;
887: close c0;
888: hr_utility.set_location('budget_start_date is'||to_char(l_budget_start_date,'DD/MM/RRRR')||l_proc,11);

Line 888: hr_utility.set_location('budget_start_date is'||to_char(l_budget_start_date,'DD/MM/RRRR')||l_proc,11);

884: hr_utility.set_location('entering '||l_proc,10);
885: open c0;
886: fetch c0 into l_budget_start_date,l_budget_end_date,l_valid_grade_flag,l_budgeted_entity_cd;
887: close c0;
888: hr_utility.set_location('budget_start_date is'||to_char(l_budget_start_date,'DD/MM/RRRR')||l_proc,11);
889: hr_utility.set_location('budget_end_date is'||to_char(l_budget_end_date,'DD/MM/RRRR')||l_proc,12);
890: for i in c1 loop
891: l_rows_inserted := l_rows_inserted + 1;
892: pqh_budget_details_api.create_budget_detail(

Line 889: hr_utility.set_location('budget_end_date is'||to_char(l_budget_end_date,'DD/MM/RRRR')||l_proc,12);

885: open c0;
886: fetch c0 into l_budget_start_date,l_budget_end_date,l_valid_grade_flag,l_budgeted_entity_cd;
887: close c0;
888: hr_utility.set_location('budget_start_date is'||to_char(l_budget_start_date,'DD/MM/RRRR')||l_proc,11);
889: hr_utility.set_location('budget_end_date is'||to_char(l_budget_end_date,'DD/MM/RRRR')||l_proc,12);
890: for i in c1 loop
891: l_rows_inserted := l_rows_inserted + 1;
892: pqh_budget_details_api.create_budget_detail(
893: p_validate => FALSE

Line 917: hr_utility.set_location('exiting '||l_proc,1000);

913: );
914: pqh_budget.insert_grd_is_bud(i.grade_id);
915: end loop;
916: p_rows_inserted := l_rows_inserted;
917: hr_utility.set_location('exiting '||l_proc,1000);
918: exception when others then
919: p_rows_inserted := null;
920: raise;
921: end populate_bud_grades;

Line 943: hr_utility.set_location('entering '||l_proc,10);

939: l_rows_inserted number := 0;
940: l_object_version_number number := 1;
941: l_proc varchar2(100) := g_package||'populate_bud_jobs' ;
942: begin
943: hr_utility.set_location('entering '||l_proc,10);
944: open c0;
945: fetch c0 into l_budget_start_date,l_budget_end_date;
946: close c0;
947: hr_utility.set_location('budget_start_date is'||to_char(l_budget_start_date,'DD/MM/RRRR')||l_proc,11);

Line 947: hr_utility.set_location('budget_start_date is'||to_char(l_budget_start_date,'DD/MM/RRRR')||l_proc,11);

943: hr_utility.set_location('entering '||l_proc,10);
944: open c0;
945: fetch c0 into l_budget_start_date,l_budget_end_date;
946: close c0;
947: hr_utility.set_location('budget_start_date is'||to_char(l_budget_start_date,'DD/MM/RRRR')||l_proc,11);
948: hr_utility.set_location('budget_end_date is'||to_char(l_budget_end_date,'DD/MM/RRRR')||l_proc,12);
949: for i in c1 loop
950: l_rows_inserted := l_rows_inserted + 1;
951: pqh_budget_details_api.create_budget_detail(

Line 948: hr_utility.set_location('budget_end_date is'||to_char(l_budget_end_date,'DD/MM/RRRR')||l_proc,12);

944: open c0;
945: fetch c0 into l_budget_start_date,l_budget_end_date;
946: close c0;
947: hr_utility.set_location('budget_start_date is'||to_char(l_budget_start_date,'DD/MM/RRRR')||l_proc,11);
948: hr_utility.set_location('budget_end_date is'||to_char(l_budget_end_date,'DD/MM/RRRR')||l_proc,12);
949: for i in c1 loop
950: l_rows_inserted := l_rows_inserted + 1;
951: pqh_budget_details_api.create_budget_detail(
952: p_validate => FALSE

Line 976: hr_utility.set_location('exiting '||l_proc,1000);

972: );
973: pqh_budget.insert_job_is_bud(i.job_id);
974: end loop;
975: p_rows_inserted := l_rows_inserted;
976: hr_utility.set_location('exiting '||l_proc,1000);
977: exception when others then
978: p_rows_inserted := null;
979: raise;
980: end populate_bud_jobs;

Line 1022: hr_utility.set_location('entering '||l_proc,10);

1018: l_rows_inserted number := 0;
1019: l_object_version_number number := 1;
1020: l_proc varchar2(100) := g_package||'populate_budget_positions' ;
1021: begin
1022: hr_utility.set_location('entering '||l_proc,10);
1023: hr_utility.set_location('business_group_id is '||p_business_group_id||l_proc,11);
1024: hr_utility.set_location('org_hier is '||p_org_hier_ver||l_proc,13);
1025: hr_utility.set_location('start organization is '||p_start_organization_id||l_proc,15);
1026: open c0;

Line 1023: hr_utility.set_location('business_group_id is '||p_business_group_id||l_proc,11);

1019: l_object_version_number number := 1;
1020: l_proc varchar2(100) := g_package||'populate_budget_positions' ;
1021: begin
1022: hr_utility.set_location('entering '||l_proc,10);
1023: hr_utility.set_location('business_group_id is '||p_business_group_id||l_proc,11);
1024: hr_utility.set_location('org_hier is '||p_org_hier_ver||l_proc,13);
1025: hr_utility.set_location('start organization is '||p_start_organization_id||l_proc,15);
1026: open c0;
1027: fetch c0 into l_budget_start_date, l_budget_end_date;

Line 1024: hr_utility.set_location('org_hier is '||p_org_hier_ver||l_proc,13);

1020: l_proc varchar2(100) := g_package||'populate_budget_positions' ;
1021: begin
1022: hr_utility.set_location('entering '||l_proc,10);
1023: hr_utility.set_location('business_group_id is '||p_business_group_id||l_proc,11);
1024: hr_utility.set_location('org_hier is '||p_org_hier_ver||l_proc,13);
1025: hr_utility.set_location('start organization is '||p_start_organization_id||l_proc,15);
1026: open c0;
1027: fetch c0 into l_budget_start_date, l_budget_end_date;
1028: close c0;

Line 1025: hr_utility.set_location('start organization is '||p_start_organization_id||l_proc,15);

1021: begin
1022: hr_utility.set_location('entering '||l_proc,10);
1023: hr_utility.set_location('business_group_id is '||p_business_group_id||l_proc,11);
1024: hr_utility.set_location('org_hier is '||p_org_hier_ver||l_proc,13);
1025: hr_utility.set_location('start organization is '||p_start_organization_id||l_proc,15);
1026: open c0;
1027: fetch c0 into l_budget_start_date, l_budget_end_date;
1028: close c0;
1029: if p_org_hier_ver is null then

Line 1030: hr_utility.set_location('Business group cursor selected '||l_proc,20);

1026: open c0;
1027: fetch c0 into l_budget_start_date, l_budget_end_date;
1028: close c0;
1029: if p_org_hier_ver is null then
1030: hr_utility.set_location('Business group cursor selected '||l_proc,20);
1031: for i in c1 loop
1032: l_rows_inserted := l_rows_inserted + 1;
1033: pqh_budget_details_api.create_budget_detail(
1034: p_validate => FALSE

Line 1056: hr_utility.set_location('position inserted '||i.position_id||l_proc,40);

1052: ,p_budget_unit3_value_type_cd => ''
1053: ,p_object_version_number => l_object_version_number
1054: );
1055: pqh_budget.insert_pos_is_bud(i.position_id);
1056: hr_utility.set_location('position inserted '||i.position_id||l_proc,40);
1057: end loop;
1058: else
1059: hr_utility.set_location('Org hierarchy cursor selected '||l_proc,45);
1060: for i in c2 loop

Line 1059: hr_utility.set_location('Org hierarchy cursor selected '||l_proc,45);

1055: pqh_budget.insert_pos_is_bud(i.position_id);
1056: hr_utility.set_location('position inserted '||i.position_id||l_proc,40);
1057: end loop;
1058: else
1059: hr_utility.set_location('Org hierarchy cursor selected '||l_proc,45);
1060: for i in c2 loop
1061: l_rows_inserted := l_rows_inserted + 1;
1062: pqh_budget_details_api.create_budget_detail(
1063: p_validate => FALSE

Line 1085: hr_utility.set_location('position inserted '||i.position_id||l_proc,50);

1081: ,p_budget_unit3_value_type_cd => ''
1082: ,p_object_version_number => l_object_version_number
1083: );
1084: pqh_budget.insert_pos_is_bud(i.position_id);
1085: hr_utility.set_location('position inserted '||i.position_id||l_proc,50);
1086: end loop;
1087: end if;
1088: p_rows_inserted := l_rows_inserted;
1089: hr_utility.set_location('exiting '||l_proc,90);

Line 1089: hr_utility.set_location('exiting '||l_proc,90);

1085: hr_utility.set_location('position inserted '||i.position_id||l_proc,50);
1086: end loop;
1087: end if;
1088: p_rows_inserted := l_rows_inserted;
1089: hr_utility.set_location('exiting '||l_proc,90);
1090: exception when others then
1091: p_rows_inserted := null;
1092: raise;
1093: end populate_bud_positions;

Line 1148: hr_utility.set_location('entering '||l_proc,10);

1144: l_object_version_number number := 1;
1145: l_rows_inserted number := 0;
1146: l_proc varchar2(100) := g_package||'populate_bud_orgs' ;
1147: begin
1148: hr_utility.set_location('entering '||l_proc,10);
1149: open c0;
1150: fetch c0 into l_budget_start_date,l_budget_end_date;
1151: close c0;
1152: hr_utility.set_location('budget_start_date is'||to_char(l_budget_start_date,'DD/MM/RRRR')||l_proc,11);

Line 1152: hr_utility.set_location('budget_start_date is'||to_char(l_budget_start_date,'DD/MM/RRRR')||l_proc,11);

1148: hr_utility.set_location('entering '||l_proc,10);
1149: open c0;
1150: fetch c0 into l_budget_start_date,l_budget_end_date;
1151: close c0;
1152: hr_utility.set_location('budget_start_date is'||to_char(l_budget_start_date,'DD/MM/RRRR')||l_proc,11);
1153: hr_utility.set_location('budget_end_date is'||to_char(l_budget_end_date,'DD/MM/RRRR')||l_proc,12);
1154: if p_org_hier_ver is null then
1155: hr_utility.set_location('bg is used '||l_proc,20);
1156: for i in c1 loop

Line 1153: hr_utility.set_location('budget_end_date is'||to_char(l_budget_end_date,'DD/MM/RRRR')||l_proc,12);

1149: open c0;
1150: fetch c0 into l_budget_start_date,l_budget_end_date;
1151: close c0;
1152: hr_utility.set_location('budget_start_date is'||to_char(l_budget_start_date,'DD/MM/RRRR')||l_proc,11);
1153: hr_utility.set_location('budget_end_date is'||to_char(l_budget_end_date,'DD/MM/RRRR')||l_proc,12);
1154: if p_org_hier_ver is null then
1155: hr_utility.set_location('bg is used '||l_proc,20);
1156: for i in c1 loop
1157: hr_utility.set_location('in loop for '||i.organization_id||l_proc,25);

Line 1155: hr_utility.set_location('bg is used '||l_proc,20);

1151: close c0;
1152: hr_utility.set_location('budget_start_date is'||to_char(l_budget_start_date,'DD/MM/RRRR')||l_proc,11);
1153: hr_utility.set_location('budget_end_date is'||to_char(l_budget_end_date,'DD/MM/RRRR')||l_proc,12);
1154: if p_org_hier_ver is null then
1155: hr_utility.set_location('bg is used '||l_proc,20);
1156: for i in c1 loop
1157: hr_utility.set_location('in loop for '||i.organization_id||l_proc,25);
1158: l_rows_inserted := l_rows_inserted + 1;
1159: pqh_budget_details_api.create_budget_detail(

Line 1157: hr_utility.set_location('in loop for '||i.organization_id||l_proc,25);

1153: hr_utility.set_location('budget_end_date is'||to_char(l_budget_end_date,'DD/MM/RRRR')||l_proc,12);
1154: if p_org_hier_ver is null then
1155: hr_utility.set_location('bg is used '||l_proc,20);
1156: for i in c1 loop
1157: hr_utility.set_location('in loop for '||i.organization_id||l_proc,25);
1158: l_rows_inserted := l_rows_inserted + 1;
1159: pqh_budget_details_api.create_budget_detail(
1160: p_validate => FALSE
1161: ,p_budget_detail_id => l_budget_detail_id

Line 1181: hr_utility.set_location('inserting '||i.organization_id||l_proc,30);

1177: ,p_budget_unit3_available => ''
1178: ,p_budget_unit3_value_type_cd => ''
1179: ,p_object_version_number => l_object_version_number
1180: );
1181: hr_utility.set_location('inserting '||i.organization_id||l_proc,30);
1182: pqh_budget.insert_org_is_bud(i.organization_id);
1183: end loop;
1184: else
1185: hr_utility.set_location('oh is used '||l_proc,40);

Line 1185: hr_utility.set_location('oh is used '||l_proc,40);

1181: hr_utility.set_location('inserting '||i.organization_id||l_proc,30);
1182: pqh_budget.insert_org_is_bud(i.organization_id);
1183: end loop;
1184: else
1185: hr_utility.set_location('oh is used '||l_proc,40);
1186: for i in c2 loop
1187: l_rows_inserted := l_rows_inserted + 1;
1188: pqh_budget_details_api.create_budget_detail(
1189: p_validate => FALSE

Line 1210: hr_utility.set_location('inserting '||i.organization_id||l_proc,50);

1206: ,p_budget_unit3_available => ''
1207: ,p_budget_unit3_value_type_cd => ''
1208: ,p_object_version_number => l_object_version_number
1209: );
1210: hr_utility.set_location('inserting '||i.organization_id||l_proc,50);
1211: pqh_budget.insert_org_is_bud(i.organization_id);
1212: end loop;
1213: end if;
1214: p_rows_inserted := l_rows_inserted;

Line 1215: hr_utility.set_location('entering '||l_proc,60);

1211: pqh_budget.insert_org_is_bud(i.organization_id);
1212: end loop;
1213: end if;
1214: p_rows_inserted := l_rows_inserted;
1215: hr_utility.set_location('entering '||l_proc,60);
1216: exception when others then
1217: p_rows_inserted := null;
1218: raise;
1219: end populate_bud_organizations;

Line 1287: hr_utility.set_location('entering '||l_proc,10);

1283: and end_date > l_period_start_date
1284: order by end_date desc;
1285: l_proc varchar2(100) := g_package||'insert_default_period' ;
1286: begin
1287: hr_utility.set_location('entering '||l_proc,10);
1288: hr_utility.set_location('unit1_value '||p_worksheet_unit1_value||l_proc,11);
1289: hr_utility.set_location('unit2_value '||p_worksheet_unit2_value||l_proc,12);
1290: hr_utility.set_location('unit3_value '||p_worksheet_unit3_value||l_proc,13);
1291: l_budget_id := get_wkd_budget(p_worksheet_detail_id);

Line 1288: hr_utility.set_location('unit1_value '||p_worksheet_unit1_value||l_proc,11);

1284: order by end_date desc;
1285: l_proc varchar2(100) := g_package||'insert_default_period' ;
1286: begin
1287: hr_utility.set_location('entering '||l_proc,10);
1288: hr_utility.set_location('unit1_value '||p_worksheet_unit1_value||l_proc,11);
1289: hr_utility.set_location('unit2_value '||p_worksheet_unit2_value||l_proc,12);
1290: hr_utility.set_location('unit3_value '||p_worksheet_unit3_value||l_proc,13);
1291: l_budget_id := get_wkd_budget(p_worksheet_detail_id);
1292: hr_utility.set_location('budget id is '||l_budget_id||l_proc,20);

Line 1289: hr_utility.set_location('unit2_value '||p_worksheet_unit2_value||l_proc,12);

1285: l_proc varchar2(100) := g_package||'insert_default_period' ;
1286: begin
1287: hr_utility.set_location('entering '||l_proc,10);
1288: hr_utility.set_location('unit1_value '||p_worksheet_unit1_value||l_proc,11);
1289: hr_utility.set_location('unit2_value '||p_worksheet_unit2_value||l_proc,12);
1290: hr_utility.set_location('unit3_value '||p_worksheet_unit3_value||l_proc,13);
1291: l_budget_id := get_wkd_budget(p_worksheet_detail_id);
1292: hr_utility.set_location('budget id is '||l_budget_id||l_proc,20);
1293: select period_set_name,budget_start_date,budget_end_date

Line 1290: hr_utility.set_location('unit3_value '||p_worksheet_unit3_value||l_proc,13);

1286: begin
1287: hr_utility.set_location('entering '||l_proc,10);
1288: hr_utility.set_location('unit1_value '||p_worksheet_unit1_value||l_proc,11);
1289: hr_utility.set_location('unit2_value '||p_worksheet_unit2_value||l_proc,12);
1290: hr_utility.set_location('unit3_value '||p_worksheet_unit3_value||l_proc,13);
1291: l_budget_id := get_wkd_budget(p_worksheet_detail_id);
1292: hr_utility.set_location('budget id is '||l_budget_id||l_proc,20);
1293: select period_set_name,budget_start_date,budget_end_date
1294: into l_calendar,l_budget_start_date,l_budget_end_date

Line 1292: hr_utility.set_location('budget id is '||l_budget_id||l_proc,20);

1288: hr_utility.set_location('unit1_value '||p_worksheet_unit1_value||l_proc,11);
1289: hr_utility.set_location('unit2_value '||p_worksheet_unit2_value||l_proc,12);
1290: hr_utility.set_location('unit3_value '||p_worksheet_unit3_value||l_proc,13);
1291: l_budget_id := get_wkd_budget(p_worksheet_detail_id);
1292: hr_utility.set_location('budget id is '||l_budget_id||l_proc,20);
1293: select period_set_name,budget_start_date,budget_end_date
1294: into l_calendar,l_budget_start_date,l_budget_end_date
1295: from pqh_budgets
1296: where budget_id = l_budget_id;

Line 1297: hr_utility.set_location('calendar id is '||l_calendar||l_proc,30);

1293: select period_set_name,budget_start_date,budget_end_date
1294: into l_calendar,l_budget_start_date,l_budget_end_date
1295: from pqh_budgets
1296: where budget_id = l_budget_id;
1297: hr_utility.set_location('calendar id is '||l_calendar||l_proc,30);
1298: hr_utility.set_location('budget start date is '||to_char(l_budget_start_date,'DD/MM/RRRR')||l_proc,40);
1299: hr_utility.set_location('budget_end date id is '||to_char(l_budget_end_date,'DD/MM/RRRR')||l_proc,50);
1300: open c1;
1301: fetch c1 into l_start_time_period_id,l_period_start_date;

Line 1298: hr_utility.set_location('budget start date is '||to_char(l_budget_start_date,'DD/MM/RRRR')||l_proc,40);

1294: into l_calendar,l_budget_start_date,l_budget_end_date
1295: from pqh_budgets
1296: where budget_id = l_budget_id;
1297: hr_utility.set_location('calendar id is '||l_calendar||l_proc,30);
1298: hr_utility.set_location('budget start date is '||to_char(l_budget_start_date,'DD/MM/RRRR')||l_proc,40);
1299: hr_utility.set_location('budget_end date id is '||to_char(l_budget_end_date,'DD/MM/RRRR')||l_proc,50);
1300: open c1;
1301: fetch c1 into l_start_time_period_id,l_period_start_date;
1302: hr_utility.set_location('period_start date id is '||to_char(l_period_start_date,'DD/MM/RRRR')||l_proc,60);

Line 1299: hr_utility.set_location('budget_end date id is '||to_char(l_budget_end_date,'DD/MM/RRRR')||l_proc,50);

1295: from pqh_budgets
1296: where budget_id = l_budget_id;
1297: hr_utility.set_location('calendar id is '||l_calendar||l_proc,30);
1298: hr_utility.set_location('budget start date is '||to_char(l_budget_start_date,'DD/MM/RRRR')||l_proc,40);
1299: hr_utility.set_location('budget_end date id is '||to_char(l_budget_end_date,'DD/MM/RRRR')||l_proc,50);
1300: open c1;
1301: fetch c1 into l_start_time_period_id,l_period_start_date;
1302: hr_utility.set_location('period_start date id is '||to_char(l_period_start_date,'DD/MM/RRRR')||l_proc,60);
1303: if c1%found then

Line 1302: hr_utility.set_location('period_start date id is '||to_char(l_period_start_date,'DD/MM/RRRR')||l_proc,60);

1298: hr_utility.set_location('budget start date is '||to_char(l_budget_start_date,'DD/MM/RRRR')||l_proc,40);
1299: hr_utility.set_location('budget_end date id is '||to_char(l_budget_end_date,'DD/MM/RRRR')||l_proc,50);
1300: open c1;
1301: fetch c1 into l_start_time_period_id,l_period_start_date;
1302: hr_utility.set_location('period_start date id is '||to_char(l_period_start_date,'DD/MM/RRRR')||l_proc,60);
1303: if c1%found then
1304: open c2;
1305: fetch c2 into l_end_time_period_id,l_period_end_date;
1306: hr_utility.set_location('period_end date id is '||to_char(l_period_end_date,'DD/MM/RRRR')||l_proc,70);

Line 1306: hr_utility.set_location('period_end date id is '||to_char(l_period_end_date,'DD/MM/RRRR')||l_proc,70);

1302: hr_utility.set_location('period_start date id is '||to_char(l_period_start_date,'DD/MM/RRRR')||l_proc,60);
1303: if c1%found then
1304: open c2;
1305: fetch c2 into l_end_time_period_id,l_period_end_date;
1306: hr_utility.set_location('period_end date id is '||to_char(l_period_end_date,'DD/MM/RRRR')||l_proc,70);
1307: close c2;
1308: end if;
1309: close c1;
1310: if l_end_time_period_id is null then

Line 1311: hr_utility.set_location('no period lies during budget life'||l_proc,80);

1307: close c2;
1308: end if;
1309: close c1;
1310: if l_end_time_period_id is null then
1311: hr_utility.set_location('no period lies during budget life'||l_proc,80);
1312: pqh_budget.update_worksheet_detail(
1313: p_worksheet_detail_id => p_worksheet_detail_id,
1314: p_object_version_number => p_wkd_ovn,
1315: p_effective_date => trunc(sysdate),

Line 1319: hr_utility.set_location('ovn of wkd after is'||p_wkd_ovn||l_proc,90);

1315: p_effective_date => trunc(sysdate),
1316: p_budget_unit1_available => p_worksheet_unit1_value,
1317: p_budget_unit2_available => p_worksheet_unit1_value,
1318: p_budget_unit3_available => p_worksheet_unit1_value);
1319: hr_utility.set_location('ovn of wkd after is'||p_wkd_ovn||l_proc,90);
1320: else
1321: hr_utility.set_location('inserting worksheet period '||l_proc,100);
1322: pqh_worksheet_periods_api.create_worksheet_period
1323: (

Line 1321: hr_utility.set_location('inserting worksheet period '||l_proc,100);

1317: p_budget_unit2_available => p_worksheet_unit1_value,
1318: p_budget_unit3_available => p_worksheet_unit1_value);
1319: hr_utility.set_location('ovn of wkd after is'||p_wkd_ovn||l_proc,90);
1320: else
1321: hr_utility.set_location('inserting worksheet period '||l_proc,100);
1322: pqh_worksheet_periods_api.create_worksheet_period
1323: (
1324: p_worksheet_period_id => p_worksheet_period_id
1325: ,p_end_time_period_id => l_end_time_period_id

Line 1344: hr_utility.set_location('exiting '||l_proc,1000);

1340: ,p_budget_unit3_available => p_worksheet_unit3_value
1341: ,p_effective_date => trunc(sysdate)
1342: );
1343: end if;
1344: hr_utility.set_location('exiting '||l_proc,1000);
1345: exception when others then
1346: p_wkd_ovn := l_wkd_ovn;
1347: p_worksheet_period_id := null;
1348: p_wpr_ovn := null;

Line 1361: hr_utility.set_location('entering '||l_proc,10);

1357: l_wkd_ovn number;
1358: l_wks_ovn number;
1359: l_proc varchar2(61) := g_package||'apply_wks' ;
1360: BEGIN
1361: hr_utility.set_location('entering '||l_proc,10);
1362: approve_wks(p_transaction_id => p_transaction_id,
1363: p_transaction_category_id => p_transaction_category_id,
1364: p_wkd_ovn => l_wkd_ovn,
1365: p_wks_ovn => l_wks_ovn);

Line 1366: hr_utility.set_location(l_proc||'wks_ovn is '||l_wks_ovn,20);

1362: approve_wks(p_transaction_id => p_transaction_id,
1363: p_transaction_category_id => p_transaction_category_id,
1364: p_wkd_ovn => l_wkd_ovn,
1365: p_wks_ovn => l_wks_ovn);
1366: hr_utility.set_location(l_proc||'wks_ovn is '||l_wks_ovn,20);
1367: hr_utility.set_location(l_proc||'wkd_ovn is '||l_wkd_ovn,30);
1368: pqh_budget.complete_workflow(p_worksheet_detail_id => p_transaction_id,
1369: p_transaction_category_id => p_transaction_category_id,
1370: p_result_status => 'SUBMITTED',

Line 1367: hr_utility.set_location(l_proc||'wkd_ovn is '||l_wkd_ovn,30);

1363: p_transaction_category_id => p_transaction_category_id,
1364: p_wkd_ovn => l_wkd_ovn,
1365: p_wks_ovn => l_wks_ovn);
1366: hr_utility.set_location(l_proc||'wks_ovn is '||l_wks_ovn,20);
1367: hr_utility.set_location(l_proc||'wkd_ovn is '||l_wkd_ovn,30);
1368: pqh_budget.complete_workflow(p_worksheet_detail_id => p_transaction_id,
1369: p_transaction_category_id => p_transaction_category_id,
1370: p_result_status => 'SUBMITTED',
1371: p_wkd_object_version_number => p_wkd_ovn,

Line 1373: hr_utility.set_location(l_proc||'wks_ovn is '||l_wks_ovn,40);

1369: p_transaction_category_id => p_transaction_category_id,
1370: p_result_status => 'SUBMITTED',
1371: p_wkd_object_version_number => p_wkd_ovn,
1372: p_wks_object_version_number => p_wks_ovn);
1373: hr_utility.set_location(l_proc||'wks_ovn is '||l_wks_ovn,40);
1374: hr_utility.set_location(l_proc||'wkd_ovn is '||l_wkd_ovn,50);
1375: exception when others then
1376: p_wkd_ovn := null;
1377: p_wks_ovn := null;

Line 1374: hr_utility.set_location(l_proc||'wkd_ovn is '||l_wkd_ovn,50);

1370: p_result_status => 'SUBMITTED',
1371: p_wkd_object_version_number => p_wkd_ovn,
1372: p_wks_object_version_number => p_wks_ovn);
1373: hr_utility.set_location(l_proc||'wks_ovn is '||l_wks_ovn,40);
1374: hr_utility.set_location(l_proc||'wkd_ovn is '||l_wkd_ovn,50);
1375: exception when others then
1376: p_wkd_ovn := null;
1377: p_wks_ovn := null;
1378: raise;

Line 1390: hr_utility.set_location('entering'||l_proc,10);

1386: l_status varchar2(30);
1387: l_working_users varchar2(2000);
1388: l_proc varchar2(61) := g_package||'pending_wks' ;
1389: BEGIN
1390: hr_utility.set_location('entering'||l_proc,10);
1391: pqh_budget.complete_workflow(p_worksheet_detail_id => p_transaction_id,
1392: p_transaction_category_id => p_transaction_category_id,
1393: p_result_status => 'PENDING',
1394: p_wkd_object_version_number => p_wkd_ovn,

Line 1396: hr_utility.set_location(l_proc||'wks_ovn is '||p_wks_ovn,40);

1392: p_transaction_category_id => p_transaction_category_id,
1393: p_result_status => 'PENDING',
1394: p_wkd_object_version_number => p_wkd_ovn,
1395: p_wks_object_version_number => p_wks_ovn);
1396: hr_utility.set_location(l_proc||'wks_ovn is '||p_wks_ovn,40);
1397: hr_utility.set_location(l_proc||'wkd_ovn is '||p_wkd_ovn,50);
1398: exception when others then
1399: p_wkd_ovn := null;
1400: p_wks_ovn := null;

Line 1397: hr_utility.set_location(l_proc||'wkd_ovn is '||p_wkd_ovn,50);

1393: p_result_status => 'PENDING',
1394: p_wkd_object_version_number => p_wkd_ovn,
1395: p_wks_object_version_number => p_wks_ovn);
1396: hr_utility.set_location(l_proc||'wks_ovn is '||p_wks_ovn,40);
1397: hr_utility.set_location(l_proc||'wkd_ovn is '||p_wkd_ovn,50);
1398: exception when others then
1399: p_wkd_ovn := null;
1400: p_wks_ovn := null;
1401: raise;

Line 1413: hr_utility.set_location('entering'||l_proc,10);

1409: l_status varchar2(30);
1410: l_working_users varchar2(2000);
1411: l_proc varchar2(61) := g_package||'approve_wks' ;
1412: BEGIN
1413: hr_utility.set_location('entering'||l_proc,10);
1414: pqh_budget.lock_all_children(p_worksheet_detail_id => p_transaction_id,
1415: p_transaction_category_id => p_transaction_category_id,
1416: p_status => l_status,
1417: p_working_users => l_working_users);

Line 1418: hr_utility.set_location('child locked'||l_proc,20);

1414: pqh_budget.lock_all_children(p_worksheet_detail_id => p_transaction_id,
1415: p_transaction_category_id => p_transaction_category_id,
1416: p_status => l_status,
1417: p_working_users => l_working_users);
1418: hr_utility.set_location('child locked'||l_proc,20);
1419: if nvl(l_status,'Y') ='Y' then
1420: -- close notifications and change status
1421: hr_utility.set_location('changing status'||l_proc,30);
1422: pqh_budget.complete_workflow(p_worksheet_detail_id => p_transaction_id,

Line 1421: hr_utility.set_location('changing status'||l_proc,30);

1417: p_working_users => l_working_users);
1418: hr_utility.set_location('child locked'||l_proc,20);
1419: if nvl(l_status,'Y') ='Y' then
1420: -- close notifications and change status
1421: hr_utility.set_location('changing status'||l_proc,30);
1422: pqh_budget.complete_workflow(p_worksheet_detail_id => p_transaction_id,
1423: p_transaction_category_id => p_transaction_category_id,
1424: p_result_status => 'APPROVED',
1425: p_wkd_object_version_number => p_wkd_ovn,

Line 1427: hr_utility.set_location('status changed'||l_proc,40);

1423: p_transaction_category_id => p_transaction_category_id,
1424: p_result_status => 'APPROVED',
1425: p_wkd_object_version_number => p_wkd_ovn,
1426: p_wks_object_version_number => p_wks_ovn);
1427: hr_utility.set_location('status changed'||l_proc,40);
1428: else
1429: hr_utility.set_message(8302,'PQH_WKS_CHILD_WORKING');
1430: hr_utility.set_message_token('USERS',l_working_users);
1431: hr_utility.raise_error;

Line 1429: hr_utility.set_message(8302,'PQH_WKS_CHILD_WORKING');

1425: p_wkd_object_version_number => p_wkd_ovn,
1426: p_wks_object_version_number => p_wks_ovn);
1427: hr_utility.set_location('status changed'||l_proc,40);
1428: else
1429: hr_utility.set_message(8302,'PQH_WKS_CHILD_WORKING');
1430: hr_utility.set_message_token('USERS',l_working_users);
1431: hr_utility.raise_error;
1432: end if;
1433: hr_utility.set_location('wks out nocopy ovn is'||p_wks_ovn||l_proc,90);

Line 1430: hr_utility.set_message_token('USERS',l_working_users);

1426: p_wks_object_version_number => p_wks_ovn);
1427: hr_utility.set_location('status changed'||l_proc,40);
1428: else
1429: hr_utility.set_message(8302,'PQH_WKS_CHILD_WORKING');
1430: hr_utility.set_message_token('USERS',l_working_users);
1431: hr_utility.raise_error;
1432: end if;
1433: hr_utility.set_location('wks out nocopy ovn is'||p_wks_ovn||l_proc,90);
1434: hr_utility.set_location('wkd out nocopy ovn is'||p_wkd_ovn||l_proc,100);

Line 1431: hr_utility.raise_error;

1427: hr_utility.set_location('status changed'||l_proc,40);
1428: else
1429: hr_utility.set_message(8302,'PQH_WKS_CHILD_WORKING');
1430: hr_utility.set_message_token('USERS',l_working_users);
1431: hr_utility.raise_error;
1432: end if;
1433: hr_utility.set_location('wks out nocopy ovn is'||p_wks_ovn||l_proc,90);
1434: hr_utility.set_location('wkd out nocopy ovn is'||p_wkd_ovn||l_proc,100);
1435: exception when others then

Line 1433: hr_utility.set_location('wks out nocopy ovn is'||p_wks_ovn||l_proc,90);

1429: hr_utility.set_message(8302,'PQH_WKS_CHILD_WORKING');
1430: hr_utility.set_message_token('USERS',l_working_users);
1431: hr_utility.raise_error;
1432: end if;
1433: hr_utility.set_location('wks out nocopy ovn is'||p_wks_ovn||l_proc,90);
1434: hr_utility.set_location('wkd out nocopy ovn is'||p_wkd_ovn||l_proc,100);
1435: exception when others then
1436: p_wkd_ovn := null;
1437: p_wks_ovn := null;

Line 1434: hr_utility.set_location('wkd out nocopy ovn is'||p_wkd_ovn||l_proc,100);

1430: hr_utility.set_message_token('USERS',l_working_users);
1431: hr_utility.raise_error;
1432: end if;
1433: hr_utility.set_location('wks out nocopy ovn is'||p_wks_ovn||l_proc,90);
1434: hr_utility.set_location('wkd out nocopy ovn is'||p_wkd_ovn||l_proc,100);
1435: exception when others then
1436: p_wkd_ovn := null;
1437: p_wks_ovn := null;
1438: raise;

Line 1450: hr_utility.set_location('entering'||l_proc,10);

1446: l_status varchar2(30);
1447: l_working_users varchar2(2000);
1448: l_proc varchar2(61) := g_package||'reject_wks' ;
1449: BEGIN
1450: hr_utility.set_location('entering'||l_proc,10);
1451: -- if the current user is the initiator of the txn then mark the status
1452: -- as reject else status remains the same and notification will be sent to initiator.
1453: l_user := pqh_wf.get_requestor(p_transaction_category_id => p_transaction_category_id,
1454: p_transaction_id => p_transaction_id);

Line 1455: hr_utility.set_location('requestor is'||l_user||l_proc,20);

1451: -- if the current user is the initiator of the txn then mark the status
1452: -- as reject else status remains the same and notification will be sent to initiator.
1453: l_user := pqh_wf.get_requestor(p_transaction_category_id => p_transaction_category_id,
1454: p_transaction_id => p_transaction_id);
1455: hr_utility.set_location('requestor is'||l_user||l_proc,20);
1456: -- change the status of the delegated rows to reject
1457: -- and all open notifications to be killed
1458: -- depending upon the initator of the delegated row
1459: if l_user is null or l_user = fnd_profile.value('USERNAME') then

Line 1460: hr_utility.set_location('going for lock'||l_proc,30);

1456: -- change the status of the delegated rows to reject
1457: -- and all open notifications to be killed
1458: -- depending upon the initator of the delegated row
1459: if l_user is null or l_user = fnd_profile.value('USERNAME') then
1460: hr_utility.set_location('going for lock'||l_proc,30);
1461: pqh_budget.lock_all_children(p_worksheet_detail_id => p_transaction_id,
1462: p_transaction_category_id => p_transaction_category_id,
1463: p_status => l_status,
1464: p_working_users => l_working_users);

Line 1465: hr_utility.set_location('locked'||l_proc,40);

1461: pqh_budget.lock_all_children(p_worksheet_detail_id => p_transaction_id,
1462: p_transaction_category_id => p_transaction_category_id,
1463: p_status => l_status,
1464: p_working_users => l_working_users);
1465: hr_utility.set_location('locked'||l_proc,40);
1466: if nvl(l_status,'Y') ='Y' then
1467: -- notifications are to be closed and change status
1468: hr_utility.set_location('changing status'||l_proc,50);
1469: pqh_budget.complete_workflow(p_worksheet_detail_id => p_transaction_id,

Line 1468: hr_utility.set_location('changing status'||l_proc,50);

1464: p_working_users => l_working_users);
1465: hr_utility.set_location('locked'||l_proc,40);
1466: if nvl(l_status,'Y') ='Y' then
1467: -- notifications are to be closed and change status
1468: hr_utility.set_location('changing status'||l_proc,50);
1469: pqh_budget.complete_workflow(p_worksheet_detail_id => p_transaction_id,
1470: p_transaction_category_id => p_transaction_category_id,
1471: p_result_status => 'REJECT',
1472: p_wkd_object_version_number => p_wkd_ovn,

Line 1474: hr_utility.set_location('status changed'||l_proc,60);

1470: p_transaction_category_id => p_transaction_category_id,
1471: p_result_status => 'REJECT',
1472: p_wkd_object_version_number => p_wkd_ovn,
1473: p_wks_object_version_number => p_wks_ovn);
1474: hr_utility.set_location('status changed'||l_proc,60);
1475: else
1476: hr_utility.set_message(8302,'PQH_WKS_CHILD_WORKING');
1477: hr_utility.set_message_token('USERS',l_working_users);
1478: hr_utility.raise_error;

Line 1476: hr_utility.set_message(8302,'PQH_WKS_CHILD_WORKING');

1472: p_wkd_object_version_number => p_wkd_ovn,
1473: p_wks_object_version_number => p_wks_ovn);
1474: hr_utility.set_location('status changed'||l_proc,60);
1475: else
1476: hr_utility.set_message(8302,'PQH_WKS_CHILD_WORKING');
1477: hr_utility.set_message_token('USERS',l_working_users);
1478: hr_utility.raise_error;
1479: end if;
1480: else

Line 1477: hr_utility.set_message_token('USERS',l_working_users);

1473: p_wks_object_version_number => p_wks_ovn);
1474: hr_utility.set_location('status changed'||l_proc,60);
1475: else
1476: hr_utility.set_message(8302,'PQH_WKS_CHILD_WORKING');
1477: hr_utility.set_message_token('USERS',l_working_users);
1478: hr_utility.raise_error;
1479: end if;
1480: else
1481: hr_utility.set_location('changing status'||l_proc,70);

Line 1478: hr_utility.raise_error;

1474: hr_utility.set_location('status changed'||l_proc,60);
1475: else
1476: hr_utility.set_message(8302,'PQH_WKS_CHILD_WORKING');
1477: hr_utility.set_message_token('USERS',l_working_users);
1478: hr_utility.raise_error;
1479: end if;
1480: else
1481: hr_utility.set_location('changing status'||l_proc,70);
1482: pqh_budget.complete_workflow(p_worksheet_detail_id => p_transaction_id,

Line 1481: hr_utility.set_location('changing status'||l_proc,70);

1477: hr_utility.set_message_token('USERS',l_working_users);
1478: hr_utility.raise_error;
1479: end if;
1480: else
1481: hr_utility.set_location('changing status'||l_proc,70);
1482: pqh_budget.complete_workflow(p_worksheet_detail_id => p_transaction_id,
1483: p_transaction_category_id => p_transaction_category_id,
1484: p_result_status => 'PENDING',
1485: p_wkd_object_version_number => p_wkd_ovn,

Line 1487: hr_utility.set_location('status changed'||l_proc,80);

1483: p_transaction_category_id => p_transaction_category_id,
1484: p_result_status => 'PENDING',
1485: p_wkd_object_version_number => p_wkd_ovn,
1486: p_wks_object_version_number => p_wks_ovn);
1487: hr_utility.set_location('status changed'||l_proc,80);
1488: end if;
1489: hr_utility.set_location('wks out nocopy ovn is'||p_wks_ovn||l_proc,90);
1490: hr_utility.set_location('wkd out nocopy ovn is'||p_wkd_ovn||l_proc,100);
1491: exception when others then

Line 1489: hr_utility.set_location('wks out nocopy ovn is'||p_wks_ovn||l_proc,90);

1485: p_wkd_object_version_number => p_wkd_ovn,
1486: p_wks_object_version_number => p_wks_ovn);
1487: hr_utility.set_location('status changed'||l_proc,80);
1488: end if;
1489: hr_utility.set_location('wks out nocopy ovn is'||p_wks_ovn||l_proc,90);
1490: hr_utility.set_location('wkd out nocopy ovn is'||p_wkd_ovn||l_proc,100);
1491: exception when others then
1492: p_wkd_ovn := null;
1493: p_wks_ovn := null;

Line 1490: hr_utility.set_location('wkd out nocopy ovn is'||p_wkd_ovn||l_proc,100);

1486: p_wks_object_version_number => p_wks_ovn);
1487: hr_utility.set_location('status changed'||l_proc,80);
1488: end if;
1489: hr_utility.set_location('wks out nocopy ovn is'||p_wks_ovn||l_proc,90);
1490: hr_utility.set_location('wkd out nocopy ovn is'||p_wkd_ovn||l_proc,100);
1491: exception when others then
1492: p_wkd_ovn := null;
1493: p_wks_ovn := null;
1494: raise;