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_CPD_HR_TO_STAGE dependencies on HR_UTILITY

Line 19: hr_utility.set_location('hierarchy doesnot exist',10);

15: fetch c1 into l_hierarchy_version_id;
16: if c1%found then
17: return l_hierarchy_version_id;
18: else
19: hr_utility.set_location('hierarchy doesnot exist',10);
20: return -1;
21: end if;
22: end get_crpth_hier_ver;
23: procedure get_scale_ddf_det(p_scale_id in number,

Line 28: hr_utility.set_location('getting scale ddf det',10);

24: p_information_category out nocopy varchar2,
25: p_information1 out nocopy varchar2,
26: p_information2 out nocopy varchar2) is
27: begin
28: hr_utility.set_location('getting scale ddf det',10);
29: if p_scale_id is not null then
30: select information_category,information1,information2
31: into p_information_category,p_information1,p_information2
32: from per_parent_spines

Line 37: hr_utility.set_location('issues is selecting scale',10);

33: where parent_spine_id = p_scale_id;
34: end if;
35: exception
36: when others then
37: hr_utility.set_location('issues is selecting scale',10);
38: raise;
39: end get_scale_ddf_det;
40:
41: procedure pgm_extra_info_update(p_pgm_id in number,

Line 49: hr_utility.set_location('inside pgm_extra_info_update',10);

45: p_review_period in number) is
46: l_peit_ovn number;
47: l_pgm_extra_info_id number;
48: begin
49: hr_utility.set_location('inside pgm_extra_info_update',10);
50: if p_pgm_extra_info_id is null then
51: hr_utility.set_location('insert pgm extra info ',10);
52: ben_pgm_extra_info_api.create_pgm_extra_info
53: ( p_pgm_id => p_pgm_id

Line 51: hr_utility.set_location('insert pgm extra info ',10);

47: l_pgm_extra_info_id number;
48: begin
49: hr_utility.set_location('inside pgm_extra_info_update',10);
50: if p_pgm_extra_info_id is null then
51: hr_utility.set_location('insert pgm extra info ',10);
52: ben_pgm_extra_info_api.create_pgm_extra_info
53: ( p_pgm_id => p_pgm_id
54: ,p_information_type => 'PQH_FR_CORP_INFO'
55: ,p_pgi_information_category => 'PQH_FR_CORP_INFO'

Line 63: hr_utility.set_location('update pgm extra info',10);

59: ,p_pgm_extra_info_id => l_pgm_extra_info_id
60: ,p_object_version_number => l_peit_ovn
61: );
62: else
63: hr_utility.set_location('update pgm extra info',10);
64: l_peit_ovn := pqh_gsp_stage_to_ben.get_ovn(p_table_name => 'BEN_PGM_EXTRA_INFO',
65: p_key_column_name => 'PGM_EXTRA_INFO_ID',
66: p_key_column_value => p_pgm_extra_info_id);
67: hr_utility.set_location(' ovn is '||l_peit_ovn,30);

Line 67: hr_utility.set_location(' ovn is '||l_peit_ovn,30);

63: hr_utility.set_location('update pgm extra info',10);
64: l_peit_ovn := pqh_gsp_stage_to_ben.get_ovn(p_table_name => 'BEN_PGM_EXTRA_INFO',
65: p_key_column_name => 'PGM_EXTRA_INFO_ID',
66: p_key_column_value => p_pgm_extra_info_id);
67: hr_utility.set_location(' ovn is '||l_peit_ovn,30);
68: ben_pgm_extra_info_api.update_pgm_extra_info
69: ( p_pgm_extra_info_id => p_pgm_extra_info_id
70: ,p_object_version_number => l_peit_ovn
71: ,p_pgi_information1 => p_quota_flag

Line 76: hr_utility.set_location('leaving pgm_extra_info_update',10);

72: ,p_pgi_information2 => p_appraisal_type
73: ,p_pgi_information3 => to_char(p_review_period)
74: );
75: end if;
76: hr_utility.set_location('leaving pgm_extra_info_update',10);
77: exception
78: when others then
79: raise;
80: end pgm_extra_info_update;

Line 94: hr_utility.set_location('pgm id is'||p_pgm_id,10);

90: FROM ben_pgm_extra_info
91: where information_type ='PQH_FR_CORP_INFO'
92: and pgm_id = p_pgm_id;
93: begin
94: hr_utility.set_location('pgm id is'||p_pgm_id,10);
95: if p_pgm_id is not null then
96: for i in c1 loop
97: hr_utility.set_location('assigning value',11);
98: p_pgm_extra_info_id := i.pgm_extra_info_id;

Line 97: hr_utility.set_location('assigning value',11);

93: begin
94: hr_utility.set_location('pgm id is'||p_pgm_id,10);
95: if p_pgm_id is not null then
96: for i in c1 loop
97: hr_utility.set_location('assigning value',11);
98: p_pgm_extra_info_id := i.pgm_extra_info_id;
99: p_quota_flag := i.pgi_information1;
100: p_appraisal_type := i.pgi_information2;
101: p_review_period := to_number(i.pgi_information3);

Line 107: hr_utility.set_location('no extra info ',10);

103:
104: end if;
105: exception
106: when no_data_found then
107: hr_utility.set_location('no extra info ',10);
108: when others then
109: hr_utility.set_location('issues is selecting pgm extra info',10);
110: raise;
111: end get_pgm_extra_info;

Line 109: hr_utility.set_location('issues is selecting pgm extra info',10);

105: exception
106: when no_data_found then
107: hr_utility.set_location('no extra info ',10);
108: when others then
109: hr_utility.set_location('issues is selecting pgm extra info',10);
110: raise;
111: end get_pgm_extra_info;
112:
113: procedure get_point_details(p_point_id in number,

Line 121: hr_utility.set_location('getting point ddf det',10);

117: p_information3 out nocopy varchar2,
118: p_information4 out nocopy varchar2,
119: p_information5 out nocopy varchar2) is
120: begin
121: hr_utility.set_location('getting point ddf det',10);
122: if p_point_id is not null then
123: select information_category,information1,information2,information3,information4,information5
124: into p_information_category,p_information1,p_information2,p_information3,p_information4,p_information5
125: from per_spinal_points

Line 130: hr_utility.set_location('issues is selecting point',10);

126: where spinal_point_id = p_point_id;
127: end if;
128: exception
129: when others then
130: hr_utility.set_location('issues is selecting point',10);
131: raise;
132: end get_point_details;
133: procedure get_corp(p_pgm_cer_id in number,
134: p_corps_id out nocopy number,

Line 172: hr_utility.set_location('inside build_comb_for_plip cet'||p_cet_id,10);

168: -- data passed is having grade_ids concatenated
169: -- what we have to pass is plip_cer_ids concatenated for page to read
170: -- this routine will get the grade_ids and for the grade get the plip cer
171: l_comb_grade := p_comb_grade;
172: hr_utility.set_location('inside build_comb_for_plip cet'||p_cet_id,10);
173: loop
174: l_grade_pos := instr(l_comb_grade,',');
175: hr_utility.set_location('sep pos is'||l_grade_pos,11);
176: if l_grade_pos = 0 then

Line 175: hr_utility.set_location('sep pos is'||l_grade_pos,11);

171: l_comb_grade := p_comb_grade;
172: hr_utility.set_location('inside build_comb_for_plip cet'||p_cet_id,10);
173: loop
174: l_grade_pos := instr(l_comb_grade,',');
175: hr_utility.set_location('sep pos is'||l_grade_pos,11);
176: if l_grade_pos = 0 then
177: l_grade_id := l_comb_grade;
178: else
179: l_grade_id := substr(l_comb_grade,1,l_grade_pos-1);

Line 182: hr_utility.set_location('grade is'||l_grade_id,12);

178: else
179: l_grade_id := substr(l_comb_grade,1,l_grade_pos-1);
180: l_comb_grade := substr(l_comb_grade,l_grade_pos+1);
181: end if;
182: hr_utility.set_location('grade is'||l_grade_id,12);
183: open get_plip_cer(l_grade_id);
184: fetch get_plip_cer into l_plip_cer_id;
185: if get_plip_cer%notfound then
186: hr_utility.set_location('plip not found '||l_grade_id,12);

Line 186: hr_utility.set_location('plip not found '||l_grade_id,12);

182: hr_utility.set_location('grade is'||l_grade_id,12);
183: open get_plip_cer(l_grade_id);
184: fetch get_plip_cer into l_plip_cer_id;
185: if get_plip_cer%notfound then
186: hr_utility.set_location('plip not found '||l_grade_id,12);
187: close get_plip_cer;
188: else
189: close get_plip_cer;
190: hr_utility.set_location('plip cer is '||l_plip_cer_id,12);

Line 190: hr_utility.set_location('plip cer is '||l_plip_cer_id,12);

186: hr_utility.set_location('plip not found '||l_grade_id,12);
187: close get_plip_cer;
188: else
189: close get_plip_cer;
190: hr_utility.set_location('plip cer is '||l_plip_cer_id,12);
191: if l_comb_plip_cer is null then
192: l_comb_plip_cer := l_plip_cer_id;
193: else
194: l_comb_plip_cer := l_comb_plip_cer||','||l_plip_cer_id;

Line 218: hr_utility.set_location('inside build_comb_for_grd',10);

214: -- data passed is having grade_ids concatenated
215: -- what we have to pass is plip_cer_ids concatenated for page to read
216: -- this routine will get the grade_ids and for the grade get the plip cer
217: l_comb_plip := p_comb_plip;
218: hr_utility.set_location('inside build_comb_for_grd',10);
219: loop
220: l_plip_pos := instr(l_comb_plip,',');
221: hr_utility.set_location('separator pos is'||l_plip_pos,11);
222: if l_plip_pos = 0 then

Line 221: hr_utility.set_location('separator pos is'||l_plip_pos,11);

217: l_comb_plip := p_comb_plip;
218: hr_utility.set_location('inside build_comb_for_grd',10);
219: loop
220: l_plip_pos := instr(l_comb_plip,',');
221: hr_utility.set_location('separator pos is'||l_plip_pos,11);
222: if l_plip_pos = 0 then
223: l_plip_cer_id := l_comb_plip;
224: else
225: l_plip_cer_id := substr(l_comb_plip,1,l_plip_pos-1);

Line 228: hr_utility.set_location('plip_cer is'||l_plip_cer_id,12);

224: else
225: l_plip_cer_id := substr(l_comb_plip,1,l_plip_pos-1);
226: l_comb_plip := substr(l_comb_plip,l_plip_pos+1);
227: end if;
228: hr_utility.set_location('plip_cer is'||l_plip_cer_id,12);
229: open get_grade(l_plip_cer_id);
230: fetch get_grade into l_grade_id;
231: if get_grade%notfound then
232: close get_grade;

Line 235: hr_utility.set_location('grade is'||l_grade_id,12);

231: if get_grade%notfound then
232: close get_grade;
233: else
234: close get_grade;
235: hr_utility.set_location('grade is'||l_grade_id,12);
236: if l_comb_grade is null then
237: l_comb_grade := l_grade_id;
238: else
239: l_comb_grade := l_comb_grade||','||l_grade_id;

Line 266: hr_utility.set_location('grade id is'||p_grade_id,10);

262: where information_type ='GRADE'
263: and corps_definition_id = p_corps_definition_id
264: and to_number(information3) = p_grade_id;
265: begin
266: hr_utility.set_location('grade id is'||p_grade_id,10);
267: hr_utility.set_location('cpd id id is'||p_corps_definition_id,10);
268: hr_utility.set_location('pgm_cer id is'||p_pgm_cer_id,10);
269: if p_corps_definition_id is not null then
270: for i in c1 loop

Line 267: hr_utility.set_location('cpd id id is'||p_corps_definition_id,10);

263: and corps_definition_id = p_corps_definition_id
264: and to_number(information3) = p_grade_id;
265: begin
266: hr_utility.set_location('grade id is'||p_grade_id,10);
267: hr_utility.set_location('cpd id id is'||p_corps_definition_id,10);
268: hr_utility.set_location('pgm_cer id is'||p_pgm_cer_id,10);
269: if p_corps_definition_id is not null then
270: for i in c1 loop
271: hr_utility.set_location('assigning value',11);

Line 268: hr_utility.set_location('pgm_cer id is'||p_pgm_cer_id,10);

264: and to_number(information3) = p_grade_id;
265: begin
266: hr_utility.set_location('grade id is'||p_grade_id,10);
267: hr_utility.set_location('cpd id id is'||p_corps_definition_id,10);
268: hr_utility.set_location('pgm_cer id is'||p_pgm_cer_id,10);
269: if p_corps_definition_id is not null then
270: for i in c1 loop
271: hr_utility.set_location('assigning value',11);
272: p_corps_extra_info_id := i.corps_extra_info_id;

Line 271: hr_utility.set_location('assigning value',11);

267: hr_utility.set_location('cpd id id is'||p_corps_definition_id,10);
268: hr_utility.set_location('pgm_cer id is'||p_pgm_cer_id,10);
269: if p_corps_definition_id is not null then
270: for i in c1 loop
271: hr_utility.set_location('assigning value',11);
272: p_corps_extra_info_id := i.corps_extra_info_id;
273: p_perc_quota := i.information4;
274: p_max_speed_quota := i.information6;
275: p_avg_speed_quota := i.information7;

Line 280: hr_utility.set_location('going for building plip cer',11);

276: p_population_cd := i.information8;
277: l_comb_grade := i.information30;
278: end loop;
279: if l_comb_grade is not null then
280: hr_utility.set_location('going for building plip cer',11);
281: hr_utility.set_location('comb plip is'||substr(l_comb_grade,1,30),17);
282: hr_utility.set_location('comb plip2 is'||substr(l_comb_grade,31,30),17);
283: p_comb_grade := build_comb_for_plip(p_cet_id => p_cet_id,
284: p_comb_grade => l_comb_grade);

Line 281: hr_utility.set_location('comb plip is'||substr(l_comb_grade,1,30),17);

277: l_comb_grade := i.information30;
278: end loop;
279: if l_comb_grade is not null then
280: hr_utility.set_location('going for building plip cer',11);
281: hr_utility.set_location('comb plip is'||substr(l_comb_grade,1,30),17);
282: hr_utility.set_location('comb plip2 is'||substr(l_comb_grade,31,30),17);
283: p_comb_grade := build_comb_for_plip(p_cet_id => p_cet_id,
284: p_comb_grade => l_comb_grade);
285: hr_utility.set_location('comb grd is'||substr(p_comb_grade,1,30),17);

Line 282: hr_utility.set_location('comb plip2 is'||substr(l_comb_grade,31,30),17);

278: end loop;
279: if l_comb_grade is not null then
280: hr_utility.set_location('going for building plip cer',11);
281: hr_utility.set_location('comb plip is'||substr(l_comb_grade,1,30),17);
282: hr_utility.set_location('comb plip2 is'||substr(l_comb_grade,31,30),17);
283: p_comb_grade := build_comb_for_plip(p_cet_id => p_cet_id,
284: p_comb_grade => l_comb_grade);
285: hr_utility.set_location('comb grd is'||substr(p_comb_grade,1,30),17);
286: hr_utility.set_location('comb grd2 is'||substr(p_comb_grade,31,30),17);

Line 285: hr_utility.set_location('comb grd is'||substr(p_comb_grade,1,30),17);

281: hr_utility.set_location('comb plip is'||substr(l_comb_grade,1,30),17);
282: hr_utility.set_location('comb plip2 is'||substr(l_comb_grade,31,30),17);
283: p_comb_grade := build_comb_for_plip(p_cet_id => p_cet_id,
284: p_comb_grade => l_comb_grade);
285: hr_utility.set_location('comb grd is'||substr(p_comb_grade,1,30),17);
286: hr_utility.set_location('comb grd2 is'||substr(p_comb_grade,31,30),17);
287: end if;
288: end if;
289: exception

Line 286: hr_utility.set_location('comb grd2 is'||substr(p_comb_grade,31,30),17);

282: hr_utility.set_location('comb plip2 is'||substr(l_comb_grade,31,30),17);
283: p_comb_grade := build_comb_for_plip(p_cet_id => p_cet_id,
284: p_comb_grade => l_comb_grade);
285: hr_utility.set_location('comb grd is'||substr(p_comb_grade,1,30),17);
286: hr_utility.set_location('comb grd2 is'||substr(p_comb_grade,31,30),17);
287: end if;
288: end if;
289: exception
290: when no_data_found then

Line 291: hr_utility.set_location('no quota defined ',10);

287: end if;
288: end if;
289: exception
290: when no_data_found then
291: hr_utility.set_location('no quota defined ',10);
292: when others then
293: hr_utility.set_location('issues is selecting quota',10);
294: raise;
295: end get_grd_quota;

Line 293: hr_utility.set_location('issues is selecting quota',10);

289: exception
290: when no_data_found then
291: hr_utility.set_location('no quota defined ',10);
292: when others then
293: hr_utility.set_location('issues is selecting quota',10);
294: raise;
295: end get_grd_quota;
296: function check_cdd_row(p_copy_entity_txn_id in number) return varchar2 is
297: l_cdd_exists varchar2(10) := 'N';

Line 346: hr_utility.set_location('inside pth create',10);

342: from per_gen_hierarchy_nodes
343: where information4 = p_corps_definition_id
344: and hierarchy_version_id = l_hierarchy_version_id;
345: begin
346: hr_utility.set_location('inside pth create',10);
347: l_hierarchy_version_id := get_crpth_hier_ver;
348: hr_utility.set_location('pth hier ver'||l_hierarchy_version_id,10);
349: if l_hierarchy_version_id is null then
350: l_continue := FALSE;

Line 348: hr_utility.set_location('pth hier ver'||l_hierarchy_version_id,10);

344: and hierarchy_version_id = l_hierarchy_version_id;
345: begin
346: hr_utility.set_location('inside pth create',10);
347: l_hierarchy_version_id := get_crpth_hier_ver;
348: hr_utility.set_location('pth hier ver'||l_hierarchy_version_id,10);
349: if l_hierarchy_version_id is null then
350: l_continue := FALSE;
351: end if;
352: pqh_gsp_hr_to_stage.get_table_route_details

Line 356: hr_utility.set_location('pth tr name'||l_pth_tr_name,20);

352: pqh_gsp_hr_to_stage.get_table_route_details
353: (p_table_alias => 'CRPATH',
354: p_table_route_id => l_pth_tr_id,
355: p_table_name => l_pth_tr_name);
356: hr_utility.set_location('pth tr name'||l_pth_tr_name,20);
357: if l_pth_tr_name is null then
358: hr_utility.set_location('pth tr name'||l_pth_tr_name,45);
359: l_continue := FALSE;
360: end if;

Line 358: hr_utility.set_location('pth tr name'||l_pth_tr_name,45);

354: p_table_route_id => l_pth_tr_id,
355: p_table_name => l_pth_tr_name);
356: hr_utility.set_location('pth tr name'||l_pth_tr_name,20);
357: if l_pth_tr_name is null then
358: hr_utility.set_location('pth tr name'||l_pth_tr_name,45);
359: l_continue := FALSE;
360: end if;
361: if p_copy_entity_txn_id is null then
362: hr_utility.set_location('CET is '||p_copy_entity_txn_id,50);

Line 362: hr_utility.set_location('CET is '||p_copy_entity_txn_id,50);

358: hr_utility.set_location('pth tr name'||l_pth_tr_name,45);
359: l_continue := FALSE;
360: end if;
361: if p_copy_entity_txn_id is null then
362: hr_utility.set_location('CET is '||p_copy_entity_txn_id,50);
363: l_continue := FALSE;
364: end if;
365: if p_cpd_cer_id is null then
366: hr_utility.set_location('cpd cer is '||p_cpd_cer_id,50);

Line 366: hr_utility.set_location('cpd cer is '||p_cpd_cer_id,50);

362: hr_utility.set_location('CET is '||p_copy_entity_txn_id,50);
363: l_continue := FALSE;
364: end if;
365: if p_cpd_cer_id is null then
366: hr_utility.set_location('cpd cer is '||p_cpd_cer_id,50);
367: l_continue := FALSE;
368: end if;
369: if l_continue then
370: for pth_rec in csr_pth_rec loop

Line 385: hr_utility.set_location('step cer id is '||l_step_cer_id,10);

381: when others then
382: raise;
383: end;
384: end if;
385: hr_utility.set_location('step cer id is '||l_step_cer_id,10);
386: hr_utility.set_location('hier ver is '||l_hierarchy_version_id,11);
387: begin
388: hr_utility.set_location('cer insert api called',55);
389: ben_copy_entity_results_api.create_copy_entity_results

Line 386: hr_utility.set_location('hier ver is '||l_hierarchy_version_id,11);

382: raise;
383: end;
384: end if;
385: hr_utility.set_location('step cer id is '||l_step_cer_id,10);
386: hr_utility.set_location('hier ver is '||l_hierarchy_version_id,11);
387: begin
388: hr_utility.set_location('cer insert api called',55);
389: ben_copy_entity_results_api.create_copy_entity_results
390: (p_effective_date => p_effective_date

Line 388: hr_utility.set_location('cer insert api called',55);

384: end if;
385: hr_utility.set_location('step cer id is '||l_step_cer_id,10);
386: hr_utility.set_location('hier ver is '||l_hierarchy_version_id,11);
387: begin
388: hr_utility.set_location('cer insert api called',55);
389: ben_copy_entity_results_api.create_copy_entity_results
390: (p_effective_date => p_effective_date
391: ,p_copy_entity_txn_id => p_copy_entity_txn_id
392: ,p_result_type_cd => 'DISPLAY'

Line 426: hr_utility.set_location('some issue in creating pth row ',120);

422: ,p_copy_entity_result_id => l_pth_cer_id
423: ,p_object_version_number => l_pth_cer_ovn);
424: exception
425: when others then
426: hr_utility.set_location('some issue in creating pth row ',120);
427: raise;
428: end;
429: end loop;
430: end if;

Line 431: hr_utility.set_location('leaving create pth',55);

427: raise;
428: end;
429: end loop;
430: end if;
431: hr_utility.set_location('leaving create pth',55);
432: end crpaths_to_stage;
433: procedure documents_to_stage(p_copy_entity_txn_id in number,
434: p_corps_definition_id in number,
435: p_effective_date in date,

Line 448: hr_utility.set_location('inside cdd create',10);

444: from pqh_corps_extra_info
445: where corps_definition_id = p_corps_definition_id
446: and information_type = 'DOCUMENT';
447: begin
448: hr_utility.set_location('inside cdd create',10);
449: pqh_gsp_hr_to_stage.get_table_route_details
450: (p_table_alias => 'CORPS_DOC',
451: p_table_route_id => l_cdd_tr_id,
452: p_table_name => l_cdd_tr_name);

Line 453: hr_utility.set_location('cdd tr name'||l_cdd_tr_name,20);

449: pqh_gsp_hr_to_stage.get_table_route_details
450: (p_table_alias => 'CORPS_DOC',
451: p_table_route_id => l_cdd_tr_id,
452: p_table_name => l_cdd_tr_name);
453: hr_utility.set_location('cdd tr name'||l_cdd_tr_name,20);
454: if l_cdd_tr_name is null then
455: hr_utility.set_location('cdd tr name'||l_cdd_tr_name,45);
456: l_continue := FALSE;
457: end if;

Line 455: hr_utility.set_location('cdd tr name'||l_cdd_tr_name,45);

451: p_table_route_id => l_cdd_tr_id,
452: p_table_name => l_cdd_tr_name);
453: hr_utility.set_location('cdd tr name'||l_cdd_tr_name,20);
454: if l_cdd_tr_name is null then
455: hr_utility.set_location('cdd tr name'||l_cdd_tr_name,45);
456: l_continue := FALSE;
457: end if;
458: if p_copy_entity_txn_id is null then
459: hr_utility.set_location('CET is '||p_copy_entity_txn_id,50);

Line 459: hr_utility.set_location('CET is '||p_copy_entity_txn_id,50);

455: hr_utility.set_location('cdd tr name'||l_cdd_tr_name,45);
456: l_continue := FALSE;
457: end if;
458: if p_copy_entity_txn_id is null then
459: hr_utility.set_location('CET is '||p_copy_entity_txn_id,50);
460: l_continue := FALSE;
461: end if;
462: if p_cpd_cer_id is null then
463: hr_utility.set_location('cpd cer is '||p_cpd_cer_id,50);

Line 463: hr_utility.set_location('cpd cer is '||p_cpd_cer_id,50);

459: hr_utility.set_location('CET is '||p_copy_entity_txn_id,50);
460: l_continue := FALSE;
461: end if;
462: if p_cpd_cer_id is null then
463: hr_utility.set_location('cpd cer is '||p_cpd_cer_id,50);
464: l_continue := FALSE;
465: end if;
466: if l_continue then
467: for cdd_rec in csr_cdd_rec loop

Line 469: hr_utility.set_location('cer insert api called',55);

465: end if;
466: if l_continue then
467: for cdd_rec in csr_cdd_rec loop
468: begin
469: hr_utility.set_location('cer insert api called',55);
470: ben_copy_entity_results_api.create_copy_entity_results
471: (p_effective_date => p_effective_date
472: ,p_copy_entity_txn_id => p_copy_entity_txn_id
473: ,p_result_type_cd => 'DISPLAY'

Line 491: hr_utility.set_location('some issue in creating cdd row ',120);

487: ,p_copy_entity_result_id => l_cdd_cer_id
488: ,p_object_version_number => l_cdd_cer_ovn);
489: exception
490: when others then
491: hr_utility.set_location('some issue in creating cdd row ',120);
492: raise;
493: end;
494: end loop;
495: end if;

Line 496: hr_utility.set_location('leaving create cdd',55);

492: raise;
493: end;
494: end loop;
495: end if;
496: hr_utility.set_location('leaving create cdd',55);
497: end documents_to_stage;
498: procedure corps_to_stage(p_copy_entity_txn_id in number,
499: p_pgm_id in number,
500: p_effective_date in date,

Line 518: hr_utility.set_location('inside corps_to_stage',10);

514: l_appraisal_type varchar2(30);
515: l_pgm_extra_info_id number;
516: l_review_period number;
517: begin
518: hr_utility.set_location('inside corps_to_stage',10);
519: for cpd_rec in csr_cpd_rec loop
520: pqh_gsp_hr_to_stage.get_table_route_details
521: (p_table_alias => 'CPD',
522: p_table_route_id => l_cpd_tr_id,

Line 524: hr_utility.set_location('cpd tr name'||l_cpd_tr_name,20);

520: pqh_gsp_hr_to_stage.get_table_route_details
521: (p_table_alias => 'CPD',
522: p_table_route_id => l_cpd_tr_id,
523: p_table_name => l_cpd_tr_name);
524: hr_utility.set_location('cpd tr name'||l_cpd_tr_name,20);
525: if l_cpd_tr_name is null then
526: hr_utility.set_location('cpd tr name'||l_cpd_tr_name,45);
527: l_continue := FALSE;
528: end if;

Line 526: hr_utility.set_location('cpd tr name'||l_cpd_tr_name,45);

522: p_table_route_id => l_cpd_tr_id,
523: p_table_name => l_cpd_tr_name);
524: hr_utility.set_location('cpd tr name'||l_cpd_tr_name,20);
525: if l_cpd_tr_name is null then
526: hr_utility.set_location('cpd tr name'||l_cpd_tr_name,45);
527: l_continue := FALSE;
528: end if;
529: if p_copy_entity_txn_id is null then
530: hr_utility.set_location('CET is '||p_copy_entity_txn_id,50);

Line 530: hr_utility.set_location('CET is '||p_copy_entity_txn_id,50);

526: hr_utility.set_location('cpd tr name'||l_cpd_tr_name,45);
527: l_continue := FALSE;
528: end if;
529: if p_copy_entity_txn_id is null then
530: hr_utility.set_location('CET is '||p_copy_entity_txn_id,50);
531: l_continue := FALSE;
532: end if;
533: if p_pgm_cer_id is null then
534: hr_utility.set_location('pgm cer is '||p_pgm_cer_id,50);

Line 534: hr_utility.set_location('pgm cer is '||p_pgm_cer_id,50);

530: hr_utility.set_location('CET is '||p_copy_entity_txn_id,50);
531: l_continue := FALSE;
532: end if;
533: if p_pgm_cer_id is null then
534: hr_utility.set_location('pgm cer is '||p_pgm_cer_id,50);
535: l_continue := FALSE;
536: end if;
537: if cpd_rec.starting_grade_id is not null then
538: hr_utility.set_location('starting grade is '||cpd_rec.starting_grade_id,60);

Line 538: hr_utility.set_location('starting grade is '||cpd_rec.starting_grade_id,60);

534: hr_utility.set_location('pgm cer is '||p_pgm_cer_id,50);
535: l_continue := FALSE;
536: end if;
537: if cpd_rec.starting_grade_id is not null then
538: hr_utility.set_location('starting grade is '||cpd_rec.starting_grade_id,60);
539: begin
540: select copy_entity_result_id
541: into l_starting_plip_cer_id
542: from ben_copy_entity_results

Line 548: hr_utility.set_location('no plip found for the grd'||cpd_rec.starting_grade_id,65);

544: and table_alias = 'CPP'
545: and information253 = cpd_rec.starting_grade_id;
546: exception
547: when no_data_found then
548: hr_utility.set_location('no plip found for the grd'||cpd_rec.starting_grade_id,65);
549: when others then
550: hr_utility.set_location('issues in selecting plip',70);
551: raise;
552: end;

Line 550: hr_utility.set_location('issues in selecting plip',70);

546: exception
547: when no_data_found then
548: hr_utility.set_location('no plip found for the grd'||cpd_rec.starting_grade_id,65);
549: when others then
550: hr_utility.set_location('issues in selecting plip',70);
551: raise;
552: end;
553: if cpd_rec.starting_grade_step_id is not null then
554: hr_utility.set_location('starting grade step is '||cpd_rec.starting_grade_step_id,60);

Line 554: hr_utility.set_location('starting grade step is '||cpd_rec.starting_grade_step_id,60);

550: hr_utility.set_location('issues in selecting plip',70);
551: raise;
552: end;
553: if cpd_rec.starting_grade_step_id is not null then
554: hr_utility.set_location('starting grade step is '||cpd_rec.starting_grade_step_id,60);
555: begin
556: select copy_entity_result_id
557: into l_starting_oipl_cer_id
558: from ben_copy_entity_results

Line 564: hr_utility.set_location('no plip found for the grd'||cpd_rec.starting_grade_step_id,65);

560: and table_alias = 'COP'
561: and information253 = cpd_rec.starting_grade_step_id;
562: exception
563: when no_data_found then
564: hr_utility.set_location('no plip found for the grd'||cpd_rec.starting_grade_step_id,65);
565: when others then
566: hr_utility.set_location('issues in selecting oipl',70);
567: raise;
568: end;

Line 566: hr_utility.set_location('issues in selecting oipl',70);

562: exception
563: when no_data_found then
564: hr_utility.set_location('no plip found for the grd'||cpd_rec.starting_grade_step_id,65);
565: when others then
566: hr_utility.set_location('issues in selecting oipl',70);
567: raise;
568: end;
569: end if;
570: end if;

Line 579: hr_utility.set_location('quota flag '||l_quota_flag,55);

575: p_appraisal_type => l_appraisal_type,
576: p_review_period => l_review_period,
577: p_pgm_extra_info_id => l_pgm_extra_info_id);
578:
579: hr_utility.set_location('quota flag '||l_quota_flag,55);
580: hr_utility.set_location('l_appraisal_type flag '||l_appraisal_type,55);
581: hr_utility.set_location('l_review_period flag '||l_review_period,55);
582: hr_utility.set_location('l_pgm_extra_info_id flag '||l_pgm_extra_info_id,55);
583:

Line 580: hr_utility.set_location('l_appraisal_type flag '||l_appraisal_type,55);

576: p_review_period => l_review_period,
577: p_pgm_extra_info_id => l_pgm_extra_info_id);
578:
579: hr_utility.set_location('quota flag '||l_quota_flag,55);
580: hr_utility.set_location('l_appraisal_type flag '||l_appraisal_type,55);
581: hr_utility.set_location('l_review_period flag '||l_review_period,55);
582: hr_utility.set_location('l_pgm_extra_info_id flag '||l_pgm_extra_info_id,55);
583:
584: hr_utility.set_location('cer insert api called',55);

Line 581: hr_utility.set_location('l_review_period flag '||l_review_period,55);

577: p_pgm_extra_info_id => l_pgm_extra_info_id);
578:
579: hr_utility.set_location('quota flag '||l_quota_flag,55);
580: hr_utility.set_location('l_appraisal_type flag '||l_appraisal_type,55);
581: hr_utility.set_location('l_review_period flag '||l_review_period,55);
582: hr_utility.set_location('l_pgm_extra_info_id flag '||l_pgm_extra_info_id,55);
583:
584: hr_utility.set_location('cer insert api called',55);
585: ben_copy_entity_results_api.create_copy_entity_results

Line 582: hr_utility.set_location('l_pgm_extra_info_id flag '||l_pgm_extra_info_id,55);

578:
579: hr_utility.set_location('quota flag '||l_quota_flag,55);
580: hr_utility.set_location('l_appraisal_type flag '||l_appraisal_type,55);
581: hr_utility.set_location('l_review_period flag '||l_review_period,55);
582: hr_utility.set_location('l_pgm_extra_info_id flag '||l_pgm_extra_info_id,55);
583:
584: hr_utility.set_location('cer insert api called',55);
585: ben_copy_entity_results_api.create_copy_entity_results
586: (p_effective_date => p_effective_date

Line 584: hr_utility.set_location('cer insert api called',55);

580: hr_utility.set_location('l_appraisal_type flag '||l_appraisal_type,55);
581: hr_utility.set_location('l_review_period flag '||l_review_period,55);
582: hr_utility.set_location('l_pgm_extra_info_id flag '||l_pgm_extra_info_id,55);
583:
584: hr_utility.set_location('cer insert api called',55);
585: ben_copy_entity_results_api.create_copy_entity_results
586: (p_effective_date => p_effective_date
587: ,p_copy_entity_txn_id => p_copy_entity_txn_id
588: ,p_result_type_cd => 'DISPLAY'

Line 627: hr_utility.set_location('some issue in creating cpd row ',120);

623: ,p_copy_entity_result_id => l_cpd_cer_id
624: ,p_object_version_number => l_cpd_cer_ovn);
625: exception
626: when others then
627: hr_utility.set_location('some issue in creating cpd row ',120);
628: raise;
629: end;
630: end if;
631: if l_cpd_cer_id is not null then

Line 632: hr_utility.set_location('calling documents',55);

628: raise;
629: end;
630: end if;
631: if l_cpd_cer_id is not null then
632: hr_utility.set_location('calling documents',55);
633: documents_to_stage(p_copy_entity_txn_id => p_copy_entity_txn_id,
634: p_corps_definition_id => cpd_rec.corps_definition_id,
635: p_effective_date => p_effective_date,
636: p_cpd_cer_id => l_cpd_cer_id);

Line 637: hr_utility.set_location('documents done',55);

633: documents_to_stage(p_copy_entity_txn_id => p_copy_entity_txn_id,
634: p_corps_definition_id => cpd_rec.corps_definition_id,
635: p_effective_date => p_effective_date,
636: p_cpd_cer_id => l_cpd_cer_id);
637: hr_utility.set_location('documents done',55);
638: hr_utility.set_location('calling crpaths',55);
639: crpaths_to_stage(p_copy_entity_txn_id => p_copy_entity_txn_id,
640: p_corps_definition_id => cpd_rec.corps_definition_id,
641: p_business_group_id => cpd_rec.business_group_id,

Line 638: hr_utility.set_location('calling crpaths',55);

634: p_corps_definition_id => cpd_rec.corps_definition_id,
635: p_effective_date => p_effective_date,
636: p_cpd_cer_id => l_cpd_cer_id);
637: hr_utility.set_location('documents done',55);
638: hr_utility.set_location('calling crpaths',55);
639: crpaths_to_stage(p_copy_entity_txn_id => p_copy_entity_txn_id,
640: p_corps_definition_id => cpd_rec.corps_definition_id,
641: p_business_group_id => cpd_rec.business_group_id,
642: p_effective_date => p_effective_date,

Line 644: hr_utility.set_location('crpaths done',55);

640: p_corps_definition_id => cpd_rec.corps_definition_id,
641: p_business_group_id => cpd_rec.business_group_id,
642: p_effective_date => p_effective_date,
643: p_cpd_cer_id => l_cpd_cer_id);
644: hr_utility.set_location('crpaths done',55);
645: end if;
646: hr_utility.set_location('leaving create cpd',55);
647: end loop;
648: end corps_to_stage;

Line 646: hr_utility.set_location('leaving create cpd',55);

642: p_effective_date => p_effective_date,
643: p_cpd_cer_id => l_cpd_cer_id);
644: hr_utility.set_location('crpaths done',55);
645: end if;
646: hr_utility.set_location('leaving create cpd',55);
647: end loop;
648: end corps_to_stage;
649: procedure stage_to_crpaths(p_copy_entity_txn_id in number,
650: p_effective_date in date,

Line 681: hr_utility.set_location('getting corps id from corp_cer',10);

677: for pth_rec in csr_crpth_rec loop
678: l_pth_id := pth_rec.information1;
679: l_pth_ovn := pth_rec.information298;
680: if pth_rec.information232 is null and pth_rec.information160 is not null then
681: hr_utility.set_location('getting corps id from corp_cer',10);
682: select information1
683: into l_cpd_id
684: from ben_copy_entity_results
685: where copy_entity_result_id = pth_rec.information160;

Line 690: hr_utility.set_location('getting step id from oipl_cer',10);

686: else
687: l_cpd_id := pth_rec.information232;
688: end if;
689: if pth_rec.information234 is null and pth_rec.information161 is not null then
690: hr_utility.set_location('getting step id from oipl_cer',10);
691: select information253
692: into l_entity_id
693: from ben_copy_entity_results
694: where copy_entity_result_id = pth_rec.information161;

Line 738: hr_utility.set_location(' dt mode is '||p_datetrack_mode,30);

734: and l_hierarchy_version_id is not null
735: and l_pth_ovn is not null
736: and l_entity_id is not null
737: and l_cpd_id is not null then
738: hr_utility.set_location(' dt mode is '||p_datetrack_mode,30);
739: l_db_ovn := pqh_gsp_stage_to_ben.get_ovn(p_table_name => 'PER_GEN_HIERARCHY_NODES',
740: p_key_column_name => 'HIERARCHY_NODE_ID',
741: p_key_column_value => l_pth_id);
742: hr_utility.set_location(' ovn is '||l_db_ovn,30);

Line 742: hr_utility.set_location(' ovn is '||l_db_ovn,30);

738: hr_utility.set_location(' dt mode is '||p_datetrack_mode,30);
739: l_db_ovn := pqh_gsp_stage_to_ben.get_ovn(p_table_name => 'PER_GEN_HIERARCHY_NODES',
740: p_key_column_name => 'HIERARCHY_NODE_ID',
741: p_key_column_value => l_pth_id);
742: hr_utility.set_location(' ovn is '||l_db_ovn,30);
743: if l_db_ovn <> l_pth_ovn then
744: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','CCP');
745: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
746: fnd_message.set_token('OBJECT ',l_object);

Line 849: hr_utility.set_location(' dt mode is '||p_datetrack_mode,30);

845: elsif cdd_rec.dml_operation ='UPDATE'
846: and l_cdd_id is not null
847: and l_cdd_ovn is not null
848: and l_cpd_id is not null then
849: hr_utility.set_location(' dt mode is '||p_datetrack_mode,30);
850: l_db_ovn := pqh_gsp_stage_to_ben.get_ovn(p_table_name => 'PQH_CORPS_EXTRA_INFO',
851: p_key_column_name => 'CORPS_EXTRA_INFO_ID',
852: p_key_column_value => l_cdd_id);
853: hr_utility.set_location(' ovn is '||l_db_ovn,30);

Line 853: hr_utility.set_location(' ovn is '||l_db_ovn,30);

849: hr_utility.set_location(' dt mode is '||p_datetrack_mode,30);
850: l_db_ovn := pqh_gsp_stage_to_ben.get_ovn(p_table_name => 'PQH_CORPS_EXTRA_INFO',
851: p_key_column_name => 'CORPS_EXTRA_INFO_ID',
852: p_key_column_value => l_cdd_id);
853: hr_utility.set_location(' ovn is '||l_db_ovn,30);
854: if l_db_ovn <> l_cdd_ovn then
855: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','CDD');
856: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
857: fnd_message.set_token('OBJECT ',l_object);

Line 898: hr_utility.set_location('cpd id is '||p_cpd_id,1);

894: procedure cpd_writeback(p_copy_entity_txn_id in number,
895: p_cpd_id in number,
896: p_cpd_cer_id in number) is
897: begin
898: hr_utility.set_location('cpd id is '||p_cpd_id,1);
899: hr_utility.set_location('cpd cer id is '||p_cpd_cer_id,2);
900: hr_utility.set_location('cet id is '||p_copy_entity_txn_id,4);
901: -- update corp rows with corps id
902: begin

Line 899: hr_utility.set_location('cpd cer id is '||p_cpd_cer_id,2);

895: p_cpd_id in number,
896: p_cpd_cer_id in number) is
897: begin
898: hr_utility.set_location('cpd id is '||p_cpd_id,1);
899: hr_utility.set_location('cpd cer id is '||p_cpd_cer_id,2);
900: hr_utility.set_location('cet id is '||p_copy_entity_txn_id,4);
901: -- update corp rows with corps id
902: begin
903: hr_utility.set_location('updating plips for cpd :'||p_cpd_id,4);

Line 900: hr_utility.set_location('cet id is '||p_copy_entity_txn_id,4);

896: p_cpd_cer_id in number) is
897: begin
898: hr_utility.set_location('cpd id is '||p_cpd_id,1);
899: hr_utility.set_location('cpd cer id is '||p_cpd_cer_id,2);
900: hr_utility.set_location('cet id is '||p_copy_entity_txn_id,4);
901: -- update corp rows with corps id
902: begin
903: hr_utility.set_location('updating plips for cpd :'||p_cpd_id,4);
904: update ben_copy_entity_results

Line 903: hr_utility.set_location('updating plips for cpd :'||p_cpd_id,4);

899: hr_utility.set_location('cpd cer id is '||p_cpd_cer_id,2);
900: hr_utility.set_location('cet id is '||p_copy_entity_txn_id,4);
901: -- update corp rows with corps id
902: begin
903: hr_utility.set_location('updating plips for cpd :'||p_cpd_id,4);
904: update ben_copy_entity_results
905: set information1 = p_cpd_id
906: where copy_entity_txn_id = p_copy_entity_txn_id
907: and table_alias = 'CPD';

Line 908: hr_utility.set_location('num of corp updated'||sql%rowcount,20);

904: update ben_copy_entity_results
905: set information1 = p_cpd_id
906: where copy_entity_txn_id = p_copy_entity_txn_id
907: and table_alias = 'CPD';
908: hr_utility.set_location('num of corp updated'||sql%rowcount,20);
909: exception
910: when others then
911: hr_utility.set_location('issues in updating cpd to corp',10);
912: raise;

Line 911: hr_utility.set_location('issues in updating cpd to corp',10);

907: and table_alias = 'CPD';
908: hr_utility.set_location('num of corp updated'||sql%rowcount,20);
909: exception
910: when others then
911: hr_utility.set_location('issues in updating cpd to corp',10);
912: raise;
913: end;
914: -- update crpath rows with corps id
915: begin

Line 916: hr_utility.set_location('updating plips for cpd :'||p_cpd_id,4);

912: raise;
913: end;
914: -- update crpath rows with corps id
915: begin
916: hr_utility.set_location('updating plips for cpd :'||p_cpd_id,4);
917: update ben_copy_entity_results
918: set information232 = p_cpd_id
919: where copy_entity_txn_id = p_copy_entity_txn_id
920: and table_alias = 'CRPATH';

Line 921: hr_utility.set_location('num of crpaths updated'||sql%rowcount,20);

917: update ben_copy_entity_results
918: set information232 = p_cpd_id
919: where copy_entity_txn_id = p_copy_entity_txn_id
920: and table_alias = 'CRPATH';
921: hr_utility.set_location('num of crpaths updated'||sql%rowcount,20);
922: exception
923: when others then
924: hr_utility.set_location('issues in updating cpd to crpaths',10);
925: raise;

Line 924: hr_utility.set_location('issues in updating cpd to crpaths',10);

920: and table_alias = 'CRPATH';
921: hr_utility.set_location('num of crpaths updated'||sql%rowcount,20);
922: exception
923: when others then
924: hr_utility.set_location('issues in updating cpd to crpaths',10);
925: raise;
926: end;
927: -- update cpp rows with corps id
928: begin

Line 929: hr_utility.set_location('updating plips for cpd :'||p_cpd_id,4);

925: raise;
926: end;
927: -- update cpp rows with corps id
928: begin
929: hr_utility.set_location('updating plips for cpd :'||p_cpd_id,4);
930: update ben_copy_entity_results
931: set information291 = p_cpd_id
932: where copy_entity_txn_id = p_copy_entity_txn_id
933: and table_alias = 'CPP';

Line 934: hr_utility.set_location('num of plips updated'||sql%rowcount,20);

930: update ben_copy_entity_results
931: set information291 = p_cpd_id
932: where copy_entity_txn_id = p_copy_entity_txn_id
933: and table_alias = 'CPP';
934: hr_utility.set_location('num of plips updated'||sql%rowcount,20);
935: exception
936: when others then
937: hr_utility.set_location('issues in updating cpd to plips',10);
938: raise;

Line 937: hr_utility.set_location('issues in updating cpd to plips',10);

933: and table_alias = 'CPP';
934: hr_utility.set_location('num of plips updated'||sql%rowcount,20);
935: exception
936: when others then
937: hr_utility.set_location('issues in updating cpd to plips',10);
938: raise;
939: end;
940: -- update cdd rows with corps id
941: begin

Line 942: hr_utility.set_location('updating docs for cpd :'||p_cpd_id,4);

938: raise;
939: end;
940: -- update cdd rows with corps id
941: begin
942: hr_utility.set_location('updating docs for cpd :'||p_cpd_id,4);
943: update ben_copy_entity_results
944: set information160 = p_cpd_id
945: where copy_entity_txn_id = p_copy_entity_txn_id
946: and table_alias = 'CORPS_DOC';

Line 947: hr_utility.set_location('num of docs updated'||sql%rowcount,20);

943: update ben_copy_entity_results
944: set information160 = p_cpd_id
945: where copy_entity_txn_id = p_copy_entity_txn_id
946: and table_alias = 'CORPS_DOC';
947: hr_utility.set_location('num of docs updated'||sql%rowcount,20);
948: exception
949: when others then
950: hr_utility.set_location('issues in updating cpd to docs',10);
951: raise;

Line 950: hr_utility.set_location('issues in updating cpd to docs',10);

946: and table_alias = 'CORPS_DOC';
947: hr_utility.set_location('num of docs updated'||sql%rowcount,20);
948: exception
949: when others then
950: hr_utility.set_location('issues in updating cpd to docs',10);
951: raise;
952: end;
953: end cpd_writeback;
954: procedure pop_pri_filiere(p_corps_definition_id in number,

Line 1060: hr_utility.set_location ('issues in getting pgm name', 10);

1056: cpd_rec.gs_mirror_src_entity_result_id;
1057: EXCEPTION
1058: WHEN OTHERS
1059: THEN
1060: hr_utility.set_location ('issues in getting pgm name', 10);
1061: RAISE;
1062: END;
1063:
1064: hr_utility.set_location ('corps name is ' || l_pgm_name, 10);

Line 1064: hr_utility.set_location ('corps name is ' || l_pgm_name, 10);

1060: hr_utility.set_location ('issues in getting pgm name', 10);
1061: RAISE;
1062: END;
1063:
1064: hr_utility.set_location ('corps name is ' || l_pgm_name, 10);
1065: hr_utility.set_location ('pgm id is ' || l_pgm_id, 10);
1066:
1067: IF cpd_rec.information290 IS NOT NULL
1068: THEN

Line 1065: hr_utility.set_location ('pgm id is ' || l_pgm_id, 10);

1061: RAISE;
1062: END;
1063:
1064: hr_utility.set_location ('corps name is ' || l_pgm_name, 10);
1065: hr_utility.set_location ('pgm id is ' || l_pgm_id, 10);
1066:
1067: IF cpd_rec.information290 IS NOT NULL
1068: THEN
1069: l_min_freq := cpd_rec.information15;

Line 1076: hr_utility.set_location

1072: END IF;
1073:
1074: IF cpd_rec.information162 IS NULL
1075: THEN
1076: hr_utility.set_location
1077: ('no value selected, get lowest plip grade',
1078: 10
1079: );
1080:

Line 1088: hr_utility.set_location ('no plip defined', 10);

1084: INTO l_plip_cer_id, l_starting_grade_id;
1085:
1086: IF c_plip%NOTFOUND
1087: THEN
1088: hr_utility.set_location ('no plip defined', 10);
1089: ELSE
1090: hr_utility.set_location ('plip cer is' || l_plip_cer_id, 10);
1091:
1092: OPEN c_oipl (l_plip_cer_id);

Line 1090: hr_utility.set_location ('plip cer is' || l_plip_cer_id, 10);

1086: IF c_plip%NOTFOUND
1087: THEN
1088: hr_utility.set_location ('no plip defined', 10);
1089: ELSE
1090: hr_utility.set_location ('plip cer is' || l_plip_cer_id, 10);
1091:
1092: OPEN c_oipl (l_plip_cer_id);
1093:
1094: FETCH c_oipl

Line 1099: hr_utility.set_location ( 'no oipl defined for plip'

1095: INTO l_oipl_cer_id, l_starting_step_id;
1096:
1097: IF c_oipl%NOTFOUND
1098: THEN
1099: hr_utility.set_location ( 'no oipl defined for plip'
1100: || l_plip_cer_id,
1101: 30
1102: );
1103: ELSE

Line 1104: hr_utility.set_location ('oipl cer is' || l_oipl_cer_id,

1100: || l_plip_cer_id,
1101: 30
1102: );
1103: ELSE
1104: hr_utility.set_location ('oipl cer is' || l_oipl_cer_id,
1105: 10);
1106: END IF;
1107:
1108: CLOSE c_oipl;

Line 1113: hr_utility.set_location ('start plip entered', 10);

1109: END IF;
1110:
1111: CLOSE c_plip;
1112: ELSE
1113: hr_utility.set_location ('start plip entered', 10);
1114:
1115: IF cpd_rec.information169 IS NULL
1116: THEN
1117: hr_utility.set_location ('start oipl not entered,get lowest',

Line 1117: hr_utility.set_location ('start oipl not entered,get lowest',

1113: hr_utility.set_location ('start plip entered', 10);
1114:
1115: IF cpd_rec.information169 IS NULL
1116: THEN
1117: hr_utility.set_location ('start oipl not entered,get lowest',
1118: 10
1119: );
1120:
1121: OPEN c_oipl (cpd_rec.information162);

Line 1128: hr_utility.set_location ( 'no oipl defined for plip'

1124: INTO l_oipl_cer_id, l_starting_step_id;
1125:
1126: IF c_oipl%NOTFOUND
1127: THEN
1128: hr_utility.set_location ( 'no oipl defined for plip'
1129: || cpd_rec.information162,
1130: 30
1131: );
1132: END IF;

Line 1136: hr_utility.set_location

1132: END IF;
1133:
1134: CLOSE c_oipl;
1135: ELSE
1136: hr_utility.set_location
1137: ('start plip and oipl entered,get grade step',
1138: 50
1139: );
1140:

Line 1149: hr_utility.set_location

1145: WHERE copy_entity_result_id = cpd_rec.information162;
1146: EXCEPTION
1147: WHEN OTHERS
1148: THEN
1149: hr_utility.set_location
1150: ('issues in selecting grade for plip',
1151: 10
1152: );
1153: END;

Line 1163: hr_utility.set_location

1159: WHERE copy_entity_result_id = cpd_rec.information169;
1160: EXCEPTION
1161: WHEN OTHERS
1162: THEN
1163: hr_utility.set_location
1164: ('issues in selecting step for oipl',
1165: 10
1166: );
1167: END;

Line 1171: hr_utility.set_location ('starting grade id is'

1167: END;
1168: END IF;
1169: END IF;
1170:
1171: hr_utility.set_location ('starting grade id is'
1172: || l_starting_grade_id,
1173: 100
1174: );
1175: hr_utility.set_location ('starting step id is' || l_starting_step_id,

Line 1175: hr_utility.set_location ('starting step id is' || l_starting_step_id,

1171: hr_utility.set_location ('starting grade id is'
1172: || l_starting_grade_id,
1173: 100
1174: );
1175: hr_utility.set_location ('starting step id is' || l_starting_step_id,
1176: 100
1177: );
1178:
1179: IF cpd_rec.dml_operation = 'INSERT'

Line 1226: hr_utility.set_location (' dt mode is ' || p_datetrack_mode, 30);

1222: AND l_cpd_ovn IS NOT NULL
1223: AND l_pgm_name IS NOT NULL
1224: AND l_pgm_id IS NOT NULL
1225: THEN
1226: hr_utility.set_location (' dt mode is ' || p_datetrack_mode, 30);
1227: l_db_ovn :=
1228: pqh_gsp_stage_to_ben.get_ovn
1229: (p_table_name => 'PQH_CORPS_DEFINITIONS',
1230: p_key_column_name => 'CORPS_DEFINITION_ID',

Line 1233: hr_utility.set_location (' ovn is ' || l_db_ovn, 30);

1229: (p_table_name => 'PQH_CORPS_DEFINITIONS',
1230: p_key_column_name => 'CORPS_DEFINITION_ID',
1231: p_key_column_value => l_cpd_id
1232: );
1233: hr_utility.set_location (' ovn is ' || l_db_ovn, 30);
1234:
1235: IF l_db_ovn <> l_cpd_ovn
1236: THEN
1237: l_object :=

Line 1307: hr_utility.set_location ('going for populating pri filere', 10);

1303: END IF;
1304:
1305: IF l_cpd_id IS NOT NULL AND cpd_rec.information292 IS NOT NULL
1306: THEN
1307: hr_utility.set_location ('going for populating pri filere', 10);
1308: pop_pri_filiere (p_corps_definition_id => l_cpd_id,
1309: p_filiere_id => cpd_rec.information292,
1310: p_effective_date => p_effective_date
1311: );

Line 1312: hr_utility.set_location ('pri filere done', 11);

1308: pop_pri_filiere (p_corps_definition_id => l_cpd_id,
1309: p_filiere_id => cpd_rec.information292,
1310: p_effective_date => p_effective_date
1311: );
1312: hr_utility.set_location ('pri filere done', 11);
1313: END IF;
1314:
1315: IF l_cpd_id IS NOT NULL AND cpd_rec.copy_entity_result_id IS NOT NULL
1316: THEN

Line 1317: hr_utility.set_location ('going for cpd writeback ', 12);

1313: END IF;
1314:
1315: IF l_cpd_id IS NOT NULL AND cpd_rec.copy_entity_result_id IS NOT NULL
1316: THEN
1317: hr_utility.set_location ('going for cpd writeback ', 12);
1318: cpd_writeback (p_copy_entity_txn_id => p_copy_entity_txn_id,
1319: p_cpd_id => l_cpd_id,
1320: p_cpd_cer_id => cpd_rec.copy_entity_result_id
1321: );

Line 1322: hr_utility.set_location ('cpd writeback done', 13);

1318: cpd_writeback (p_copy_entity_txn_id => p_copy_entity_txn_id,
1319: p_cpd_id => l_cpd_id,
1320: p_cpd_cer_id => cpd_rec.copy_entity_result_id
1321: );
1322: hr_utility.set_location ('cpd writeback done', 13);
1323: END IF;
1324: END LOOP;
1325:
1326: IF l_updated = FALSE

Line 1357: hr_utility.set_location ('Error thrown', 13);

1353: );
1354: EXCEPTION
1355: WHEN OTHERS
1356: THEN
1357: hr_utility.set_location ('Error thrown', 13);
1358: pqh_gsp_process_log.log_process_dtls
1359: (p_master_txn_id => p_copy_entity_txn_id,
1360: p_txn_id => NVL
1361: (l_cpd_id,

Line 1387: hr_utility.set_location('inside grd_quota_update',10);

1383: l_db_ovn number;
1384: l_cei_id number;
1385: l_comp_grd varchar2(2000);
1386: begin
1387: hr_utility.set_location('inside grd_quota_update',10);
1388: if p_comb_grades is not null then
1389: l_comp_grd := build_comb_for_grd(p_comb_plip => p_comb_grades);
1390: end if;
1391: if p_corps_extra_info_id is null then

Line 1392: hr_utility.set_location('insert grd quota ',10);

1388: if p_comb_grades is not null then
1389: l_comp_grd := build_comb_for_grd(p_comb_plip => p_comb_grades);
1390: end if;
1391: if p_corps_extra_info_id is null then
1392: hr_utility.set_location('insert grd quota ',10);
1393: pqh_corps_extra_info_api.create_corps_extra_info(
1394: p_effective_date => p_effective_date
1395: ,p_corps_extra_info_id => l_cei_id
1396: ,p_corps_definition_id => p_corps_definition_id

Line 1407: hr_utility.set_location('update grd quota',10);

1403: ,p_information30 => l_comp_grd
1404: ,p_object_version_number => l_db_ovn
1405: );
1406: else
1407: hr_utility.set_location('update grd quota',10);
1408: l_db_ovn := pqh_gsp_stage_to_ben.get_ovn(p_table_name => 'PQH_CORPS_EXTRA_INFO',
1409: p_key_column_name => 'CORPS_EXTRA_INFO_ID',
1410: p_key_column_value => p_corps_extra_info_id);
1411: hr_utility.set_location(' ovn is '||l_db_ovn,30);

Line 1411: hr_utility.set_location(' ovn is '||l_db_ovn,30);

1407: hr_utility.set_location('update grd quota',10);
1408: l_db_ovn := pqh_gsp_stage_to_ben.get_ovn(p_table_name => 'PQH_CORPS_EXTRA_INFO',
1409: p_key_column_name => 'CORPS_EXTRA_INFO_ID',
1410: p_key_column_value => p_corps_extra_info_id);
1411: hr_utility.set_location(' ovn is '||l_db_ovn,30);
1412: pqh_corps_extra_info_api.update_corps_extra_info(
1413: p_effective_date => p_effective_date
1414: ,p_corps_extra_info_id => p_corps_extra_info_id
1415: ,p_corps_definition_id => p_corps_definition_id

Line 1426: hr_utility.set_location('leaving grd_quota_update',10);

1422: ,p_information30 => l_comp_grd
1423: ,p_object_version_number => l_db_ovn
1424: );
1425: end if;
1426: hr_utility.set_location('leaving grd_quota_update',10);
1427: exception
1428: when others then
1429: raise;
1430: end grd_quota_update;

Line 1470: hr_utility.set_location('issues in updating point'||p_spinal_point,30);

1466: ,p_called_from => 'GSPW' -- added for bug 9328526
1467: );
1468: exception
1469: when others then
1470: hr_utility.set_location('issues in updating point'||p_spinal_point,30);
1471: raise;
1472: end update_point;
1473: procedure create_point(p_point_id out nocopy number,
1474: p_point_ovn out nocopy number,

Line 1504: hr_utility.set_location('issues in creating point'||p_spinal_point,30);

1500: ,p_information5 => p_information5
1501: );
1502: exception
1503: when others then
1504: hr_utility.set_location('issues in creating point'||p_spinal_point,30);
1505: raise;
1506: end create_point;
1507: procedure create_scale(p_scale_id out nocopy number,
1508: p_scale_ovn out nocopy number,

Line 1518: hr_utility.set_location('inf_cat is'||p_information_category,10);

1514: p_effective_date in date,
1515: p_increment_frequency in number,
1516: p_increment_period in varchar2) is
1517: begin
1518: hr_utility.set_location('inf_cat is'||p_information_category,10);
1519: hr_utility.set_location('inf1 is'||p_information1,10);
1520: hr_utility.set_location('inf2 is'||p_information2,10);
1521: hr_pay_scale_api.create_pay_scale
1522: (p_business_group_id => p_business_group_id

Line 1519: hr_utility.set_location('inf1 is'||p_information1,10);

1515: p_increment_frequency in number,
1516: p_increment_period in varchar2) is
1517: begin
1518: hr_utility.set_location('inf_cat is'||p_information_category,10);
1519: hr_utility.set_location('inf1 is'||p_information1,10);
1520: hr_utility.set_location('inf2 is'||p_information2,10);
1521: hr_pay_scale_api.create_pay_scale
1522: (p_business_group_id => p_business_group_id
1523: ,p_name => p_name

Line 1520: hr_utility.set_location('inf2 is'||p_information2,10);

1516: p_increment_period in varchar2) is
1517: begin
1518: hr_utility.set_location('inf_cat is'||p_information_category,10);
1519: hr_utility.set_location('inf1 is'||p_information1,10);
1520: hr_utility.set_location('inf2 is'||p_information2,10);
1521: hr_pay_scale_api.create_pay_scale
1522: (p_business_group_id => p_business_group_id
1523: ,p_name => p_name
1524: ,p_effective_date => p_effective_date

Line 1535: hr_utility.set_location('issues in creating scale'||p_name,30);

1531: ,p_information2 => p_information2
1532: ) ;
1533: exception
1534: when others then
1535: hr_utility.set_location('issues in creating scale'||p_name,30);
1536: raise;
1537: end create_scale;
1538: procedure update_scale(p_scale_id in number,
1539: p_scale_ovn in out nocopy number,

Line 1564: hr_utility.set_location('issues in updating scale'||p_name,30);

1560: ,p_called_from => 'GSPW' -- added for bug 9328526
1561: ) ;
1562: exception
1563: when others then
1564: hr_utility.set_location('issues in updating scale'||p_name,30);
1565: raise;
1566: end update_scale;
1567: end pqh_cpd_hr_to_stage;