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

Line 34: hr_utility.set_location('deleting plips for pl '||Pl_Rec.Pl_Id,10);

30: -- 2. Fetch the programs to which the plan is added.
31: -- 3. Delete plan in program records.
32: -- 4. Delete the Plan
33: For Pl_rec in Pl loop
34: hr_utility.set_location('deleting plips for pl '||Pl_Rec.Pl_Id,10);
35: For Plip_Rec in Plip(Pl_Rec.Pl_Id) Loop
36: hr_utility.set_location('deleting plip '||PLip_rec.Plip_Id,15);
37: L_plip_Ovn_No := Plip_Rec.Object_version_number;
38: if plip_rec.effective_end_date <> l_eot then

Line 36: hr_utility.set_location('deleting plip '||PLip_rec.Plip_Id,15);

32: -- 4. Delete the Plan
33: For Pl_rec in Pl loop
34: hr_utility.set_location('deleting plips for pl '||Pl_Rec.Pl_Id,10);
35: For Plip_Rec in Plip(Pl_Rec.Pl_Id) Loop
36: hr_utility.set_location('deleting plip '||PLip_rec.Plip_Id,15);
37: L_plip_Ovn_No := Plip_Rec.Object_version_number;
38: if plip_rec.effective_end_date <> l_eot then
39: hr_utility.set_location('not on last row ',19);
40: l_datetrack_mode := 'FUTURE_CHANGE';

Line 39: hr_utility.set_location('not on last row ',19);

35: For Plip_Rec in Plip(Pl_Rec.Pl_Id) Loop
36: hr_utility.set_location('deleting plip '||PLip_rec.Plip_Id,15);
37: L_plip_Ovn_No := Plip_Rec.Object_version_number;
38: if plip_rec.effective_end_date <> l_eot then
39: hr_utility.set_location('not on last row ',19);
40: l_datetrack_mode := 'FUTURE_CHANGE';
41: else
42: hr_utility.set_location('on last row ',18);
43: l_datetrack_mode := 'DELETE';

Line 42: hr_utility.set_location('on last row ',18);

38: if plip_rec.effective_end_date <> l_eot then
39: hr_utility.set_location('not on last row ',19);
40: l_datetrack_mode := 'FUTURE_CHANGE';
41: else
42: hr_utility.set_location('on last row ',18);
43: l_datetrack_mode := 'DELETE';
44: end if;
45: begin
46: ben_Plan_in_Program_api.delete_Plan_in_Program

Line 55: hr_utility.set_location('issues in deleting plip ',30);

51: ,p_effective_date => Hr_general.Effective_Date
52: ,p_datetrack_mode => l_datetrack_mode);
53: exception
54: when others then
55: hr_utility.set_location('issues in deleting plip ',30);
56: Return 'FAILURE';
57: End;
58: End Loop;
59: hr_utility.set_location('deleting pl '||Pl_Rec.Pl_Id,10);

Line 59: hr_utility.set_location('deleting pl '||Pl_Rec.Pl_Id,10);

55: hr_utility.set_location('issues in deleting plip ',30);
56: Return 'FAILURE';
57: End;
58: End Loop;
59: hr_utility.set_location('deleting pl '||Pl_Rec.Pl_Id,10);
60: L_plan_Ovn_No := Pl_Rec.Object_version_number;
61: if pl_rec.effective_end_date <> l_eot then
62: hr_utility.set_location('not on last row ',19);
63: l_datetrack_mode := 'FUTURE_CHANGE';

Line 62: hr_utility.set_location('not on last row ',19);

58: End Loop;
59: hr_utility.set_location('deleting pl '||Pl_Rec.Pl_Id,10);
60: L_plan_Ovn_No := Pl_Rec.Object_version_number;
61: if pl_rec.effective_end_date <> l_eot then
62: hr_utility.set_location('not on last row ',19);
63: l_datetrack_mode := 'FUTURE_CHANGE';
64: else
65: hr_utility.set_location('on last row ',18);
66: l_datetrack_mode := 'DELETE';

Line 65: hr_utility.set_location('on last row ',18);

61: if pl_rec.effective_end_date <> l_eot then
62: hr_utility.set_location('not on last row ',19);
63: l_datetrack_mode := 'FUTURE_CHANGE';
64: else
65: hr_utility.set_location('on last row ',18);
66: l_datetrack_mode := 'DELETE';
67: end if;
68: ben_plan_api.delete_Plan
69: (p_pl_id => Pl_Rec.Pl_Id

Line 80: hr_utility.set_location('issues in deleting pl ',30);

76: --
77: Return 'SUCCESS';
78: Exception
79: When Others Then
80: hr_utility.set_location('issues in deleting pl ',30);
81: Return 'FAILURE';
82: End;
83: --
84: --------------------------------------------------------------------------------------

Line 136: hr_utility.set_location('grade rule id is '||p_grade_rule_id,10);

132: --
133: -- 1. Find the Standard rate which references the grade rule.
134: -- 2. Delete the Standard rate.
135:
136: hr_utility.set_location('grade rule id is '||p_grade_rule_id,10);
137: hr_utility.set_location('rate type is '||p_rate_type,11);
138: hr_utility.set_location('grade /point id is '||p_grade_or_spinal_point_id,12);
139: hr_utility.set_location('effdt is '||to_char(p_effective_date,'dd-mm-RRRR:hh-mm-ss'),13);
140:

Line 137: hr_utility.set_location('rate type is '||p_rate_type,11);

133: -- 1. Find the Standard rate which references the grade rule.
134: -- 2. Delete the Standard rate.
135:
136: hr_utility.set_location('grade rule id is '||p_grade_rule_id,10);
137: hr_utility.set_location('rate type is '||p_rate_type,11);
138: hr_utility.set_location('grade /point id is '||p_grade_or_spinal_point_id,12);
139: hr_utility.set_location('effdt is '||to_char(p_effective_date,'dd-mm-RRRR:hh-mm-ss'),13);
140:
141: OPEN csr_business_group_id;

Line 138: hr_utility.set_location('grade /point id is '||p_grade_or_spinal_point_id,12);

134: -- 2. Delete the Standard rate.
135:
136: hr_utility.set_location('grade rule id is '||p_grade_rule_id,10);
137: hr_utility.set_location('rate type is '||p_rate_type,11);
138: hr_utility.set_location('grade /point id is '||p_grade_or_spinal_point_id,12);
139: hr_utility.set_location('effdt is '||to_char(p_effective_date,'dd-mm-RRRR:hh-mm-ss'),13);
140:
141: OPEN csr_business_group_id;
142: FETCH csr_business_group_id INTO l_Business_group_id;

Line 139: hr_utility.set_location('effdt is '||to_char(p_effective_date,'dd-mm-RRRR:hh-mm-ss'),13);

135:
136: hr_utility.set_location('grade rule id is '||p_grade_rule_id,10);
137: hr_utility.set_location('rate type is '||p_rate_type,11);
138: hr_utility.set_location('grade /point id is '||p_grade_or_spinal_point_id,12);
139: hr_utility.set_location('effdt is '||to_char(p_effective_date,'dd-mm-RRRR:hh-mm-ss'),13);
140:
141: OPEN csr_business_group_id;
142: FETCH csr_business_group_id INTO l_Business_group_id;
143: CLOSE csr_business_group_id;

Line 150: hr_utility.set_location('Delete VAR Rate' || Var_Rec.ACTY_VRBL_RT_ID ,15);

146:
147: For Var_Rec in Csr_Var_Rt (Rates_Rec.ACTY_BASE_RT_ID)
148: Loop
149:
150: hr_utility.set_location('Delete VAR Rate' || Var_Rec.ACTY_VRBL_RT_ID ,15);
151: If Var_Rec.Acty_Vrbl_rt_Id is NOT NULL then
152:
153: l_Vrbl_ovn := Var_rec.Object_Version_Number;
154:

Line 166: hr_utility.set_location('abr to be deleted is '||Rates_Rec.ACTY_BASE_RT_ID,20);

162:
163: End If;
164: End Loop;
165:
166: hr_utility.set_location('abr to be deleted is '||Rates_Rec.ACTY_BASE_RT_ID,20);
167: l_Object_version_Number := Rates_Rec.Object_version_number;
168: ben_acty_base_rate_api.delete_acty_base_rate
169: (p_acty_base_rt_id => Rates_Rec.ACTY_BASE_RT_ID
170: ,p_effective_start_date => L_Effective_Start_Date

Line 182: hr_utility.set_location('issues in deleting abr ',30);

178: Return 'SUCCESS';
179: --
180: Exception
181: When Others Then
182: hr_utility.set_location('issues in deleting abr ',30);
183: Return 'FAILURE';
184: End;
185: --
186: --------------------------------------------------------------------------------------

Line 228: hr_utility.set_location('spinal point is '||p_spinal_point_id,15);

224: --1. Find the option corresponding to the spinal point.
225: --2. Delete the option. No need to delete option in plan records
226: -- as it will not be able to delete the spinal point if steps are there.
227:
228: hr_utility.set_location('spinal point is '||p_spinal_point_id,15);
229: hr_utility.set_location('effdt is '||to_char(l_effective_date,'dd-mm-RRRR:hh-mm-ss'),18);
230: For Opts_Rec in Opts Loop
231: hr_utility.set_location('opt to be deleted is'||Opts_Rec.Opt_id,20);
232: L_ovn_No := opts_rec.Object_version_number;

Line 229: hr_utility.set_location('effdt is '||to_char(l_effective_date,'dd-mm-RRRR:hh-mm-ss'),18);

225: --2. Delete the option. No need to delete option in plan records
226: -- as it will not be able to delete the spinal point if steps are there.
227:
228: hr_utility.set_location('spinal point is '||p_spinal_point_id,15);
229: hr_utility.set_location('effdt is '||to_char(l_effective_date,'dd-mm-RRRR:hh-mm-ss'),18);
230: For Opts_Rec in Opts Loop
231: hr_utility.set_location('opt to be deleted is'||Opts_Rec.Opt_id,20);
232: L_ovn_No := opts_rec.Object_version_number;
233:

Line 231: hr_utility.set_location('opt to be deleted is'||Opts_Rec.Opt_id,20);

227:
228: hr_utility.set_location('spinal point is '||p_spinal_point_id,15);
229: hr_utility.set_location('effdt is '||to_char(l_effective_date,'dd-mm-RRRR:hh-mm-ss'),18);
230: For Opts_Rec in Opts Loop
231: hr_utility.set_location('opt to be deleted is'||Opts_Rec.Opt_id,20);
232: L_ovn_No := opts_rec.Object_version_number;
233:
234: /* if opts_rec.effective_end_date <> l_eot then
235: hr_utility.set_location('not on last row ',19);

Line 235: hr_utility.set_location('not on last row ',19);

231: hr_utility.set_location('opt to be deleted is'||Opts_Rec.Opt_id,20);
232: L_ovn_No := opts_rec.Object_version_number;
233:
234: /* if opts_rec.effective_end_date <> l_eot then
235: hr_utility.set_location('not on last row ',19);
236: l_datetrack_mode := 'FUTURE_CHANGE';
237: else
238: hr_utility.set_location('on last row ',18);
239: l_datetrack_mode := 'DELETE';

Line 238: hr_utility.set_location('on last row ',18);

234: /* if opts_rec.effective_end_date <> l_eot then
235: hr_utility.set_location('not on last row ',19);
236: l_datetrack_mode := 'FUTURE_CHANGE';
237: else
238: hr_utility.set_location('on last row ',18);
239: l_datetrack_mode := 'DELETE';
240: end if; */
241: l_datetrack_mode := 'ZAP';
242: Open csr_Pl_Opt_Type(Opts_Rec.Opt_id);

Line 246: hr_utility.set_location('PLOptTyp to be deleted is'||l_Pl_Typ_Opt_Typ_Id,30);

242: Open csr_Pl_Opt_Type(Opts_Rec.Opt_id);
243: Fetch csr_Pl_Opt_Type into l_Pl_Typ_Opt_Typ_Id, l_opt_typ_Esd, l_Opt_Typ_Eed, l_Opt_typ_Ovn;
244: Close csr_Pl_Opt_Type;
245:
246: hr_utility.set_location('PLOptTyp to be deleted is'||l_Pl_Typ_Opt_Typ_Id,30);
247:
248: ben_plan_type_option_type_api.Delete_Plan_Type_Option_Type
249: (P_PL_TYP_OPT_TYP_ID => l_Pl_Typ_Opt_Typ_Id
250: ,P_EFFECTIVE_START_DATE => l_opt_typ_Esd

Line 256: hr_utility.set_location('PLOptTyp Deleted',40);

252: ,P_OBJECT_VERSION_NUMBER => l_Opt_typ_Ovn
253: ,P_EFFECTIVE_DATE => l_Effective_Date
254: ,P_DATETRACK_MODE => l_datetrack_mode);
255:
256: hr_utility.set_location('PLOptTyp Deleted',40);
257:
258: ben_option_definition_api.delete_option_definition
259: (p_opt_id => Opts_Rec.Opt_id
260: ,p_effective_start_date => L_Effective_Start_Date

Line 270: hr_utility.set_location('issues in deleting opt ',30);

266: Return 'SUCCESS';
267: --
268: Exception
269: When Others Then
270: hr_utility.set_location('issues in deleting opt ',30);
271: Return 'FAILURE';
272: End;
273: --
274: --------------------------------------------------------------------------------

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

307: -- 2. Do not allow deleting the step, if it is the last step in the
308: -- grade and the grade ladder is setup for 'Step' or 'Grade-Step' progression
309: -- 3. Delete the option in plan records.
310:
311: hr_utility.set_location('grade is '||p_grade_id,10);
312: hr_utility.set_location('spinal point is '||p_spinal_point_id,15);
313: hr_utility.set_location('effdt is '||to_char(p_effective_date,'dd-mm-RRRR:hh-mi-ss'),18);
314: For Oipl_Rec in Oipl Loop
315: hr_utility.set_location('oipl for deletion is '||Oipl_Rec.Oipl_Id,30);

Line 312: hr_utility.set_location('spinal point is '||p_spinal_point_id,15);

308: -- grade and the grade ladder is setup for 'Step' or 'Grade-Step' progression
309: -- 3. Delete the option in plan records.
310:
311: hr_utility.set_location('grade is '||p_grade_id,10);
312: hr_utility.set_location('spinal point is '||p_spinal_point_id,15);
313: hr_utility.set_location('effdt is '||to_char(p_effective_date,'dd-mm-RRRR:hh-mi-ss'),18);
314: For Oipl_Rec in Oipl Loop
315: hr_utility.set_location('oipl for deletion is '||Oipl_Rec.Oipl_Id,30);
316: l_Object_version_Number := Oipl_Rec.Object_Version_Number;

Line 313: hr_utility.set_location('effdt is '||to_char(p_effective_date,'dd-mm-RRRR:hh-mi-ss'),18);

309: -- 3. Delete the option in plan records.
310:
311: hr_utility.set_location('grade is '||p_grade_id,10);
312: hr_utility.set_location('spinal point is '||p_spinal_point_id,15);
313: hr_utility.set_location('effdt is '||to_char(p_effective_date,'dd-mm-RRRR:hh-mi-ss'),18);
314: For Oipl_Rec in Oipl Loop
315: hr_utility.set_location('oipl for deletion is '||Oipl_Rec.Oipl_Id,30);
316: l_Object_version_Number := Oipl_Rec.Object_Version_Number;
317: ben_Option_in_Plan_api.delete_Option_in_Plan

Line 315: hr_utility.set_location('oipl for deletion is '||Oipl_Rec.Oipl_Id,30);

311: hr_utility.set_location('grade is '||p_grade_id,10);
312: hr_utility.set_location('spinal point is '||p_spinal_point_id,15);
313: hr_utility.set_location('effdt is '||to_char(p_effective_date,'dd-mm-RRRR:hh-mi-ss'),18);
314: For Oipl_Rec in Oipl Loop
315: hr_utility.set_location('oipl for deletion is '||Oipl_Rec.Oipl_Id,30);
316: l_Object_version_Number := Oipl_Rec.Object_Version_Number;
317: ben_Option_in_Plan_api.delete_Option_in_Plan
318: (p_oipl_id => Oipl_Rec.Oipl_Id
319: ,p_effective_start_date => L_Effective_Start_Date

Line 329: hr_utility.set_location('issues in deleting oipl ',30);

325: Return 'SUCCESS';
326: --
327: Exception
328: When Others Then
329: hr_utility.set_location('issues in deleting oipl ',30);
330: Return 'FAILURE';
331: End;
332:
333: --

Line 349: hr_utility.set_location('oipl is '||l_oipl_id,30);

345: from ben_oipl_f
346: where pl_id = p_pl_id
347: and opt_id = p_opt_id
348: and p_effective_date between effective_start_date and effective_end_date;
349: hr_utility.set_location('oipl is '||l_oipl_id,30);
350: return true;
351: exception
352: when no_data_found then
353: hr_utility.set_location('invalid oipl for pl'||p_pl_id,100);

Line 353: hr_utility.set_location('invalid oipl for pl'||p_pl_id,100);

349: hr_utility.set_location('oipl is '||l_oipl_id,30);
350: return true;
351: exception
352: when no_data_found then
353: hr_utility.set_location('invalid oipl for pl'||p_pl_id,100);
354: return false;
355: when others then
356: hr_utility.set_location('issues in selecting oipl detail',120);
357: return false;

Line 356: hr_utility.set_location('issues in selecting oipl detail',120);

352: when no_data_found then
353: hr_utility.set_location('invalid oipl for pl'||p_pl_id,100);
354: return false;
355: when others then
356: hr_utility.set_location('issues in selecting oipl detail',120);
357: return false;
358: end;
359: else
360: hr_utility.set_location('either plan or opt is null',150);

Line 360: hr_utility.set_location('either plan or opt is null',150);

356: hr_utility.set_location('issues in selecting oipl detail',120);
357: return false;
358: end;
359: else
360: hr_utility.set_location('either plan or opt is null',150);
361: return false;
362: end if;
363: end chk_oipl_for_step;
364: --

Line 379: hr_utility.set_location('max seq is '||l_max_seq,10);

375: into l_max_seq
376: from ben_oipl_f
377: where pl_id = p_pl_id
378: and p_effective_date between effective_start_date and effective_end_date;
379: hr_utility.set_location('max seq is '||l_max_seq,10);
380: l_max_seq := nvl(l_max_seq,0) + 1;
381: return l_max_seq;
382: exception
383: when no_data_found then

Line 384: hr_utility.set_location('invalid oipl for pl'||p_pl_id,100);

380: l_max_seq := nvl(l_max_seq,0) + 1;
381: return l_max_seq;
382: exception
383: when no_data_found then
384: hr_utility.set_location('invalid oipl for pl'||p_pl_id,100);
385: return 1;
386: when others then
387: hr_utility.set_location('issues in selecting oipl detail',120);
388: raise;

Line 387: hr_utility.set_location('issues in selecting oipl detail',120);

383: when no_data_found then
384: hr_utility.set_location('invalid oipl for pl'||p_pl_id,100);
385: return 1;
386: when others then
387: hr_utility.set_location('issues in selecting oipl detail',120);
388: raise;
389: end;
390: else
391: hr_utility.set_location('either plan or opt is null',150);

Line 391: hr_utility.set_location('either plan or opt is null',150);

387: hr_utility.set_location('issues in selecting oipl detail',120);
388: raise;
389: end;
390: else
391: hr_utility.set_location('either plan or opt is null',150);
392: return 1;
393: end if;
394: end get_max_oipl_seq;
395: --

Line 440: hr_utility.set_location('Entering create_option',5);

436: l_continue := true;
437: -- Get the plan type that is to be linked.Assuming that there can be only
438: -- one plan type of option type 'GSP'.
439: --
440: hr_utility.set_location('Entering create_option',5);
441: Open get_pl_typ;
442: Fetch get_pl_typ into l_pl_typ_id;
443: If get_pl_typ%notfound then
444: Close get_pl_typ;

Line 445: hr_utility.set_location('No plan type found ',5);

441: Open get_pl_typ;
442: Fetch get_pl_typ into l_pl_typ_id;
443: If get_pl_typ%notfound then
444: Close get_pl_typ;
445: hr_utility.set_location('No plan type found ',5);
446: return 'FAILURE';
447: End if;
448: Close get_pl_typ;
449: hr_utility.set_location('plan type found '|| to_char(l_pl_typ_id),5);

Line 449: hr_utility.set_location('plan type found '|| to_char(l_pl_typ_id),5);

445: hr_utility.set_location('No plan type found ',5);
446: return 'FAILURE';
447: End if;
448: Close get_pl_typ;
449: hr_utility.set_location('plan type found '|| to_char(l_pl_typ_id),5);
450: --
451: -- Check if the option exists for the point
452: --
453: Open csr_opt_exists;

Line 466: hr_utility.set_location('Creating option for '|| p_spinal_point_name,5);

462: -- 2. Create the option if it does not already exist for the point.
463: --
464: If l_opt_exists = 'N' then
465: --
466: hr_utility.set_location('Creating option for '|| p_spinal_point_name,5);
467: ben_option_definition_api.create_option_definition
468: (P_OPT_ID => L_opt_id
469: ,P_EFFECTIVE_START_DATE => L_Effective_Start_Date
470: ,P_EFFECTIVE_END_DATE => L_Effective_End_Date

Line 480: hr_utility.set_location('plan type option type'|| p_spinal_point_name,5);

476: ,P_EFFECTIVE_DATE => l_effective_date );
477: --
478: -- Also create plan type option type link.
479: --
480: hr_utility.set_location('plan type option type'|| p_spinal_point_name,5);
481: ben_plan_type_option_type_api.create_plan_type_option_type
482: (
483: p_validate => false
484: ,p_pl_typ_opt_typ_id => l_pl_typ_opt_typ_id

Line 497: hr_utility.set_location('Leaving create_option',10);

493: );
494:
495: End if;
496: --
497: hr_utility.set_location('Leaving create_option',10);
498: Return 'SUCCESS';
499: --
500: End;
501: --

Line 553: hr_utility.set_location('pl id is'||pl_rec.pl_id,10);

549: -- 2. Create a option in plan record.
550: --
551: For Pl_Rec in Pl Loop
552: l_bg_id := pl_Rec.Business_group_id;
553: hr_utility.set_location('pl id is'||pl_rec.pl_id,10);
554: for pt_rec in point loop
555: hr_utility.set_location('pt is '||pt_rec.spinal_point_id,15);
556: begin
557: l_continue := create_option_for_point(p_spinal_point_id => pt_rec.spinal_point_id,

Line 555: hr_utility.set_location('pt is '||pt_rec.spinal_point_id,15);

551: For Pl_Rec in Pl Loop
552: l_bg_id := pl_Rec.Business_group_id;
553: hr_utility.set_location('pl id is'||pl_rec.pl_id,10);
554: for pt_rec in point loop
555: hr_utility.set_location('pt is '||pt_rec.spinal_point_id,15);
556: begin
557: l_continue := create_option_for_point(p_spinal_point_id => pt_rec.spinal_point_id,
558: p_pay_scale_name => pt_rec.scale_name,
559: p_business_group_id => l_bg_id,

Line 563: hr_utility.set_location('issues in creating option',15);

559: p_business_group_id => l_bg_id,
560: p_spinal_point_name => pt_rec.spinal_point);
561: exception
562: when others then
563: hr_utility.set_location('issues in creating option',15);
564: raise;
565: End;
566: end loop;
567: if l_continue <> 'SUCCESS' then

Line 571: hr_utility.set_location('opt id is'||opt_rec.opt_id,20);

567: if l_continue <> 'SUCCESS' then
568: return 'FAILURE';
569: else
570: For Opt_Rec in OPt Loop
571: hr_utility.set_location('opt id is'||opt_rec.opt_id,20);
572: l_oipl_exists := chk_oipl_for_step(p_pl_id => pl_rec.pl_id,
573: p_opt_id => opt_rec.opt_id,
574: p_effective_date => p_effective_date);
575: if not l_oipl_exists and pl_rec.pl_id is not null and opt_rec.opt_id is not null then

Line 576: hr_utility.set_location('going for oipl create',30);

572: l_oipl_exists := chk_oipl_for_step(p_pl_id => pl_rec.pl_id,
573: p_opt_id => opt_rec.opt_id,
574: p_effective_date => p_effective_date);
575: if not l_oipl_exists and pl_rec.pl_id is not null and opt_rec.opt_id is not null then
576: hr_utility.set_location('going for oipl create',30);
577: --start bug fix 6239174
578: /* if l_max_oipl_seq is null then
579: l_max_oipl_seq := get_max_oipl_seq(p_pl_id => pl_rec.pl_id,
580: p_opt_id => opt_rec.opt_id,

Line 593: hr_utility.set_location('seq is '||l_max_oipl_seq,31);

589: else
590: l_max_oipl_seq := Opt_Rec.ordr_num;
591: end if;
592: --end bug fix 6239174
593: hr_utility.set_location('seq is '||l_max_oipl_seq,31);
594: ben_Option_in_Plan_api.create_Option_in_Plan
595: (p_oipl_id => l_Oipl_id
596: ,p_effective_start_date => l_effective_Start_Date
597: ,p_effective_end_date => l_Effective_End_Date

Line 607: hr_utility.set_location('not enough details exists for oipl creation',40);

603: ,p_ordr_num => l_max_oipl_seq
604: ,p_object_version_number => l_ovn_no
605: ,p_effective_date => p_effective_date);
606: else
607: hr_utility.set_location('not enough details exists for oipl creation',40);
608: end if;
609: --
610: End Loop;
611: end if;

Line 613: hr_utility.set_location('going out ',50);

609: --
610: End Loop;
611: end if;
612: End loop;
613: hr_utility.set_location('going out ',50);
614: Return 'SUCCESS';
615: --
616: Exception
617: When Others Then

Line 618: hr_utility.set_location('issues in creating oipl',40);

614: Return 'SUCCESS';
615: --
616: Exception
617: When Others Then
618: hr_utility.set_location('issues in creating oipl',40);
619: raise;
620: End;
621: --
622: --