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

Line 10: g_debug boolean := hr_utility.debug_enabled;

6: -- we will try to check here that the event has not failed any GSP data
7: -- if any, we will be raising the error.
8:
9: g_package Varchar2(30) := 'pqh_gsp_ben_validations.';
10: g_debug boolean := hr_utility.debug_enabled;
11:
12: --
13: ---------------------------get_pl_type-----------------------------
14: --

Line 44: hr_utility.set_location('Entering'||l_proc,5);

40:
41: Begin
42:
43: if g_debug then
44: hr_utility.set_location('Entering'||l_proc,5);
45: hr_utility.set_location('p_pl_id'||p_pl_id,10);
46: hr_utility.set_location('p_effective_date'||p_effective_date,15);
47: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
48: end if;

Line 45: hr_utility.set_location('p_pl_id'||p_pl_id,10);

41: Begin
42:
43: if g_debug then
44: hr_utility.set_location('Entering'||l_proc,5);
45: hr_utility.set_location('p_pl_id'||p_pl_id,10);
46: hr_utility.set_location('p_effective_date'||p_effective_date,15);
47: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
48: end if;
49:

Line 46: hr_utility.set_location('p_effective_date'||p_effective_date,15);

42:
43: if g_debug then
44: hr_utility.set_location('Entering'||l_proc,5);
45: hr_utility.set_location('p_pl_id'||p_pl_id,10);
46: hr_utility.set_location('p_effective_date'||p_effective_date,15);
47: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
48: end if;
49:
50: Open csr_pl_type_id;

Line 47: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);

43: if g_debug then
44: hr_utility.set_location('Entering'||l_proc,5);
45: hr_utility.set_location('p_pl_id'||p_pl_id,10);
46: hr_utility.set_location('p_effective_date'||p_effective_date,15);
47: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
48: end if;
49:
50: Open csr_pl_type_id;
51: Fetch csr_pl_type_id into l_type_id;

Line 55: hr_utility.set_location('Plan Type Id '||l_type_id,25);

51: Fetch csr_pl_type_id into l_type_id;
52: Close csr_pl_type_id;
53:
54: if g_debug then
55: hr_utility.set_location('Plan Type Id '||l_type_id,25);
56: end if;
57: If l_type_id IS NOT NULL Then
58: Open csr_pl_type(l_type_id);
59: Fetch csr_pl_type into l_type;

Line 64: hr_utility.set_location('Plan Type '||l_type,35);

60: Close csr_pl_type;
61: End If;
62:
63: if g_debug then
64: hr_utility.set_location('Plan Type '||l_type,35);
65: hr_utility.set_location('Leaving'||l_proc,100);
66: end if;
67: return l_type;
68: Exception

Line 65: hr_utility.set_location('Leaving'||l_proc,100);

61: End If;
62:
63: if g_debug then
64: hr_utility.set_location('Plan Type '||l_type,35);
65: hr_utility.set_location('Leaving'||l_proc,100);
66: end if;
67: return l_type;
68: Exception
69: When Others then

Line 99: hr_utility.set_location('Entering'||l_proc,5);

95:
96:
97: Begin
98: if g_debug then
99: hr_utility.set_location('Entering'||l_proc,5);
100: hr_utility.set_location('p_plip_id'||p_plip_id,10);
101: hr_utility.set_location('p_effective_date'||p_effective_date,15);
102: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
103: end if;

Line 100: hr_utility.set_location('p_plip_id'||p_plip_id,10);

96:
97: Begin
98: if g_debug then
99: hr_utility.set_location('Entering'||l_proc,5);
100: hr_utility.set_location('p_plip_id'||p_plip_id,10);
101: hr_utility.set_location('p_effective_date'||p_effective_date,15);
102: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
103: end if;
104:

Line 101: hr_utility.set_location('p_effective_date'||p_effective_date,15);

97: Begin
98: if g_debug then
99: hr_utility.set_location('Entering'||l_proc,5);
100: hr_utility.set_location('p_plip_id'||p_plip_id,10);
101: hr_utility.set_location('p_effective_date'||p_effective_date,15);
102: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
103: end if;
104:
105: Open csr_pl_id;

Line 102: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);

98: if g_debug then
99: hr_utility.set_location('Entering'||l_proc,5);
100: hr_utility.set_location('p_plip_id'||p_plip_id,10);
101: hr_utility.set_location('p_effective_date'||p_effective_date,15);
102: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
103: end if;
104:
105: Open csr_pl_id;
106: Fetch csr_pl_id into l_pl_id,l_pgm_id;

Line 110: hr_utility.set_location('Plan Id '||l_pl_id,25);

106: Fetch csr_pl_id into l_pl_id,l_pgm_id;
107: Close csr_pl_id;
108:
109: if g_debug then
110: hr_utility.set_location('Plan Id '||l_pl_id,25);
111: hr_utility.set_location('PGM Id'||l_pgm_id,26);
112: end if;
113:
114: If l_pgm_id IS NOT NULL Then

Line 111: hr_utility.set_location('PGM Id'||l_pgm_id,26);

107: Close csr_pl_id;
108:
109: if g_debug then
110: hr_utility.set_location('Plan Id '||l_pl_id,25);
111: hr_utility.set_location('PGM Id'||l_pgm_id,26);
112: end if;
113:
114: If l_pgm_id IS NOT NULL Then
115:

Line 123: hr_utility.set_location('Is PGM Type is GSP (Y/N)'||l_is_pgm_type_gsp,27);

119: );
120: End If;
121:
122: if g_debug then
123: hr_utility.set_location('Is PGM Type is GSP (Y/N)'||l_is_pgm_type_gsp,27);
124: end if;
125:
126:
127: If l_is_pgm_type_gsp = 'Y' And l_pl_id IS NOT NULL Then

Line 134: hr_utility.set_location('Plan Type '||l_type,35);

130: p_Business_Group_Id => p_Business_Group_Id);
131: End If;
132:
133: if g_debug then
134: hr_utility.set_location('Plan Type '||l_type,35);
135: hr_utility.set_location('Leaving'||l_proc,100);
136: end if;
137: return l_type;
138:

Line 135: hr_utility.set_location('Leaving'||l_proc,100);

131: End If;
132:
133: if g_debug then
134: hr_utility.set_location('Plan Type '||l_type,35);
135: hr_utility.set_location('Leaving'||l_proc,100);
136: end if;
137: return l_type;
138:
139: Exception

Line 143: hr_utility.set_location('Leaving'||l_proc,100);

139: Exception
140: When Others then
141: return null;
142: if g_debug then
143: hr_utility.set_location('Leaving'||l_proc,100);
144: end if;
145: End get_plip_type;
146:
147: --

Line 192: hr_utility.set_location('Entering'||l_proc,5);

188:
189:
190: Begin
191: if g_debug then
192: hr_utility.set_location('Entering'||l_proc,5);
193: hr_utility.set_location('p_plip_id'||p_plip_id,10);
194: hr_utility.set_location('p_effective_date'||p_effective_date,15);
195: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
196: end if;

Line 193: hr_utility.set_location('p_plip_id'||p_plip_id,10);

189:
190: Begin
191: if g_debug then
192: hr_utility.set_location('Entering'||l_proc,5);
193: hr_utility.set_location('p_plip_id'||p_plip_id,10);
194: hr_utility.set_location('p_effective_date'||p_effective_date,15);
195: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
196: end if;
197:

Line 194: hr_utility.set_location('p_effective_date'||p_effective_date,15);

190: Begin
191: if g_debug then
192: hr_utility.set_location('Entering'||l_proc,5);
193: hr_utility.set_location('p_plip_id'||p_plip_id,10);
194: hr_utility.set_location('p_effective_date'||p_effective_date,15);
195: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
196: end if;
197:
198: -- Check PLIP Rec Type is GSP

Line 195: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);

191: if g_debug then
192: hr_utility.set_location('Entering'||l_proc,5);
193: hr_utility.set_location('p_plip_id'||p_plip_id,10);
194: hr_utility.set_location('p_effective_date'||p_effective_date,15);
195: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
196: end if;
197:
198: -- Check PLIP Rec Type is GSP
199: l_plip_type_cd := get_plip_type( p_plip_id => p_plip_id,

Line 203: hr_utility.set_location('PLIP Type '||l_plip_type_cd,30);

199: l_plip_type_cd := get_plip_type( p_plip_id => p_plip_id,
200: p_effective_date => p_effective_date,
201: p_Business_Group_Id => p_Business_Group_Id);
202: if g_debug then
203: hr_utility.set_location('PLIP Type '||l_plip_type_cd,30);
204: end if;
205:
206: If Nvl(l_plip_type_cd,'PPP') = 'GSP' Then
207: --

Line 215: hr_utility.set_location('Grade Id '||l_grade_id,40);

211: Close csr_grade_id;
212: --
213: --
214: if g_debug then
215: hr_utility.set_location('Grade Id '||l_grade_id,40);
216: end if;
217: If l_grade_id IS NOT NULL Then
218: Open csr_emp_placemnets(l_grade_id);
219: Fetch csr_emp_placemnets into l_dummy;

Line 222: hr_utility.set_location('Emp Placements are exists',50);

218: Open csr_emp_placemnets(l_grade_id);
219: Fetch csr_emp_placemnets into l_dummy;
220: If csr_emp_placemnets%Found Then
221: if g_debug then
222: hr_utility.set_location('Emp Placements are exists',50);
223: end if;
224: l_exists := 'Y';
225: End If;
226: Close csr_emp_placemnets;

Line 232: hr_utility.set_location('Leaving'||l_proc,100);

228: --
229: --
230: End If;
231: if g_debug then
232: hr_utility.set_location('Leaving'||l_proc,100);
233: end if;
234: return l_exists;
235:
236: Exception

Line 270: hr_utility.set_location('Entering'||l_proc,10);

266: And PL_TYP_OPT_TYP_CD = 'GSP';
267:
268: Begin
269: if g_debug then
270: hr_utility.set_location('Entering'||l_proc,10);
271: hr_utility.set_location('p_opt_id:'||p_opt_id, 15);
272: hr_utility.set_location('p_effective_date:'||p_effective_date, 20);
273: hr_utility.set_location('p_Business_Group_Id:'||p_Business_Group_Id, 25);
274: end if;

Line 271: hr_utility.set_location('p_opt_id:'||p_opt_id, 15);

267:
268: Begin
269: if g_debug then
270: hr_utility.set_location('Entering'||l_proc,10);
271: hr_utility.set_location('p_opt_id:'||p_opt_id, 15);
272: hr_utility.set_location('p_effective_date:'||p_effective_date, 20);
273: hr_utility.set_location('p_Business_Group_Id:'||p_Business_Group_Id, 25);
274: end if;
275:

Line 272: hr_utility.set_location('p_effective_date:'||p_effective_date, 20);

268: Begin
269: if g_debug then
270: hr_utility.set_location('Entering'||l_proc,10);
271: hr_utility.set_location('p_opt_id:'||p_opt_id, 15);
272: hr_utility.set_location('p_effective_date:'||p_effective_date, 20);
273: hr_utility.set_location('p_Business_Group_Id:'||p_Business_Group_Id, 25);
274: end if;
275:
276:

Line 273: hr_utility.set_location('p_Business_Group_Id:'||p_Business_Group_Id, 25);

269: if g_debug then
270: hr_utility.set_location('Entering'||l_proc,10);
271: hr_utility.set_location('p_opt_id:'||p_opt_id, 15);
272: hr_utility.set_location('p_effective_date:'||p_effective_date, 20);
273: hr_utility.set_location('p_Business_Group_Id:'||p_Business_Group_Id, 25);
274: end if;
275:
276:
277: Open csr_opt_type;

Line 284: hr_utility.set_location('Option has GSP Type (Y/N) :'||l_type, 45);

280: l_type := 'Y';
281: End If;
282: Close csr_opt_type;
283: if g_debug then
284: hr_utility.set_location('Option has GSP Type (Y/N) :'||l_type, 45);
285: hr_utility.set_location('Leaving:'||l_proc, 100);
286: end if;
287: return l_type;
288: Exception

Line 285: hr_utility.set_location('Leaving:'||l_proc, 100);

281: End If;
282: Close csr_opt_type;
283: if g_debug then
284: hr_utility.set_location('Option has GSP Type (Y/N) :'||l_type, 45);
285: hr_utility.set_location('Leaving:'||l_proc, 100);
286: end if;
287: return l_type;
288: Exception
289: When others then

Line 323: hr_utility.set_location('Entering'||l_proc,10);

319: And nvl(Effective_End_Date, hr_general.end_of_time);
320:
321: Begin
322: if g_debug then
323: hr_utility.set_location('Entering'||l_proc,10);
324: hr_utility.set_location('p_oipl_id:'||p_oipl_id, 15);
325: hr_utility.set_location('p_effective_date:'||p_effective_date, 20);
326: hr_utility.set_location('p_Business_Group_Id:'||p_Business_Group_Id, 25);
327: end if;

Line 324: hr_utility.set_location('p_oipl_id:'||p_oipl_id, 15);

320:
321: Begin
322: if g_debug then
323: hr_utility.set_location('Entering'||l_proc,10);
324: hr_utility.set_location('p_oipl_id:'||p_oipl_id, 15);
325: hr_utility.set_location('p_effective_date:'||p_effective_date, 20);
326: hr_utility.set_location('p_Business_Group_Id:'||p_Business_Group_Id, 25);
327: end if;
328:

Line 325: hr_utility.set_location('p_effective_date:'||p_effective_date, 20);

321: Begin
322: if g_debug then
323: hr_utility.set_location('Entering'||l_proc,10);
324: hr_utility.set_location('p_oipl_id:'||p_oipl_id, 15);
325: hr_utility.set_location('p_effective_date:'||p_effective_date, 20);
326: hr_utility.set_location('p_Business_Group_Id:'||p_Business_Group_Id, 25);
327: end if;
328:
329:

Line 326: hr_utility.set_location('p_Business_Group_Id:'||p_Business_Group_Id, 25);

322: if g_debug then
323: hr_utility.set_location('Entering'||l_proc,10);
324: hr_utility.set_location('p_oipl_id:'||p_oipl_id, 15);
325: hr_utility.set_location('p_effective_date:'||p_effective_date, 20);
326: hr_utility.set_location('p_Business_Group_Id:'||p_Business_Group_Id, 25);
327: end if;
328:
329:
330: Open csr_opt_id;

Line 335: hr_utility.set_location('Opt Id:'||l_opt_id, 35);

331: Fetch csr_opt_id into l_opt_id;
332: Close csr_opt_id;
333:
334: if g_debug then
335: hr_utility.set_location('Opt Id:'||l_opt_id, 35);
336: end if;
337:
338: If l_opt_id IS NOT NULL Then
339: l_type := chk_opt_has_gsp_type(p_opt_id => l_opt_id ,

Line 345: hr_utility.set_location('OIPL has GSP Type (Y/N) :'||l_type, 45);

341: p_business_group_id => p_business_group_id);
342: End If;
343:
344: if g_debug then
345: hr_utility.set_location('OIPL has GSP Type (Y/N) :'||l_type, 45);
346: hr_utility.set_location('Leaving:'||l_proc, 100);
347: end if;
348:
349: return l_type;

Line 346: hr_utility.set_location('Leaving:'||l_proc, 100);

342: End If;
343:
344: if g_debug then
345: hr_utility.set_location('OIPL has GSP Type (Y/N) :'||l_type, 45);
346: hr_utility.set_location('Leaving:'||l_proc, 100);
347: end if;
348:
349: return l_type;
350: Exception

Line 392: hr_utility.set_location('Entering'||l_proc,10);

388: And nvl(step.Effective_End_Date, hr_general.end_of_time);
389:
390: Begin
391: if g_debug then
392: hr_utility.set_location('Entering'||l_proc,10);
393: hr_utility.set_location('p_spinal_point_Id:'||p_spinal_point_Id, 15);
394: hr_utility.set_location('p_Grade_Id:'||p_Grade_Id, 20);
395: hr_utility.set_location('p_effective_date:'||p_effective_date, 25);
396: hr_utility.set_location('p_Business_Group_Id:'||p_Business_Group_Id, 30);

Line 393: hr_utility.set_location('p_spinal_point_Id:'||p_spinal_point_Id, 15);

389:
390: Begin
391: if g_debug then
392: hr_utility.set_location('Entering'||l_proc,10);
393: hr_utility.set_location('p_spinal_point_Id:'||p_spinal_point_Id, 15);
394: hr_utility.set_location('p_Grade_Id:'||p_Grade_Id, 20);
395: hr_utility.set_location('p_effective_date:'||p_effective_date, 25);
396: hr_utility.set_location('p_Business_Group_Id:'||p_Business_Group_Id, 30);
397: end if;

Line 394: hr_utility.set_location('p_Grade_Id:'||p_Grade_Id, 20);

390: Begin
391: if g_debug then
392: hr_utility.set_location('Entering'||l_proc,10);
393: hr_utility.set_location('p_spinal_point_Id:'||p_spinal_point_Id, 15);
394: hr_utility.set_location('p_Grade_Id:'||p_Grade_Id, 20);
395: hr_utility.set_location('p_effective_date:'||p_effective_date, 25);
396: hr_utility.set_location('p_Business_Group_Id:'||p_Business_Group_Id, 30);
397: end if;
398:

Line 395: hr_utility.set_location('p_effective_date:'||p_effective_date, 25);

391: if g_debug then
392: hr_utility.set_location('Entering'||l_proc,10);
393: hr_utility.set_location('p_spinal_point_Id:'||p_spinal_point_Id, 15);
394: hr_utility.set_location('p_Grade_Id:'||p_Grade_Id, 20);
395: hr_utility.set_location('p_effective_date:'||p_effective_date, 25);
396: hr_utility.set_location('p_Business_Group_Id:'||p_Business_Group_Id, 30);
397: end if;
398:
399: Open csr_step_id;

Line 396: hr_utility.set_location('p_Business_Group_Id:'||p_Business_Group_Id, 30);

392: hr_utility.set_location('Entering'||l_proc,10);
393: hr_utility.set_location('p_spinal_point_Id:'||p_spinal_point_Id, 15);
394: hr_utility.set_location('p_Grade_Id:'||p_Grade_Id, 20);
395: hr_utility.set_location('p_effective_date:'||p_effective_date, 25);
396: hr_utility.set_location('p_Business_Group_Id:'||p_Business_Group_Id, 30);
397: end if;
398:
399: Open csr_step_id;
400: Fetch csr_step_id into l_step_id;

Line 404: hr_utility.set_location('Step Id:'||l_step_id, 35);

400: Fetch csr_step_id into l_step_id;
401: Close csr_step_id;
402:
403: if g_debug then
404: hr_utility.set_location('Step Id:'||l_step_id, 35);
405: hr_utility.set_location('Leaving:'||l_proc, 100);
406: end if;
407:
408: return l_step_id;

Line 405: hr_utility.set_location('Leaving:'||l_proc, 100);

401: Close csr_step_id;
402:
403: if g_debug then
404: hr_utility.set_location('Step Id:'||l_step_id, 35);
405: hr_utility.set_location('Leaving:'||l_proc, 100);
406: end if;
407:
408: return l_step_id;
409: Exception

Line 475: hr_utility.set_location('Entering'||l_proc,5);

471: and nvl(effective_end_date,hr_general.end_of_time);
472:
473: Begin
474: if g_debug then
475: hr_utility.set_location('Entering'||l_proc,5);
476: hr_utility.set_location('p_oipl_id'||p_oipl_id,10);
477: hr_utility.set_location('p_effective_date'||p_effective_date,15);
478: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
479: end if;

Line 476: hr_utility.set_location('p_oipl_id'||p_oipl_id,10);

472:
473: Begin
474: if g_debug then
475: hr_utility.set_location('Entering'||l_proc,5);
476: hr_utility.set_location('p_oipl_id'||p_oipl_id,10);
477: hr_utility.set_location('p_effective_date'||p_effective_date,15);
478: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
479: end if;
480:

Line 477: hr_utility.set_location('p_effective_date'||p_effective_date,15);

473: Begin
474: if g_debug then
475: hr_utility.set_location('Entering'||l_proc,5);
476: hr_utility.set_location('p_oipl_id'||p_oipl_id,10);
477: hr_utility.set_location('p_effective_date'||p_effective_date,15);
478: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
479: end if;
480:
481: -- Check OIPL has GSP Plan Type

Line 478: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);

474: if g_debug then
475: hr_utility.set_location('Entering'||l_proc,5);
476: hr_utility.set_location('p_oipl_id'||p_oipl_id,10);
477: hr_utility.set_location('p_effective_date'||p_effective_date,15);
478: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
479: end if;
480:
481: -- Check OIPL has GSP Plan Type
482: l_gsp_type := chk_oipl_has_gsp_type(p_oipl_id => p_oipl_id,

Line 488: hr_utility.set_location('OIPL has GSP Plan Type',35);

484: p_business_group_id => p_business_group_id);
485:
486: If l_gsp_type = 'Y' Then
487: if g_debug then
488: hr_utility.set_location('OIPL has GSP Plan Type',35);
489: end if;
490: --
491: -- Get Grade Id, spinal_point_id
492: --

Line 498: hr_utility.set_location('Grade Id :'||l_grade_id,40);

494: Fetch csr_grade_point_id into l_grade_id,l_spinal_point_id;
495: Close csr_grade_point_id;
496:
497: if g_debug then
498: hr_utility.set_location('Grade Id :'||l_grade_id,40);
499: hr_utility.set_location('Spinal Point Id : '||l_spinal_point_id,50);
500: end if;
501:
502: l_step_Id := get_step_id(p_spinal_point_Id => l_spinal_point_id,

Line 499: hr_utility.set_location('Spinal Point Id : '||l_spinal_point_id,50);

495: Close csr_grade_point_id;
496:
497: if g_debug then
498: hr_utility.set_location('Grade Id :'||l_grade_id,40);
499: hr_utility.set_location('Spinal Point Id : '||l_spinal_point_id,50);
500: end if;
501:
502: l_step_Id := get_step_id(p_spinal_point_Id => l_spinal_point_id,
503: p_Grade_Id => l_grade_id,

Line 507: hr_utility.set_location('Step Id : '||l_step_Id,55);

503: p_Grade_Id => l_grade_id,
504: p_effective_date => p_effective_date,
505: p_business_group_id => p_business_group_id);
506: if g_debug then
507: hr_utility.set_location('Step Id : '||l_step_Id,55);
508: end if;
509:
510: /* Check step is
511: 1) Special Ceiling Step

Line 522: hr_utility.set_location('Step has Point Placement ',55);

518: If P_Effective_Date >= l_plcmt_Eed Then
519: l_steps_exists_on_oipl := 'N';
520: Else
521: if g_debug then
522: hr_utility.set_location('Step has Point Placement ',55);
523: end if;
524: l_steps_exists_on_oipl := 'Y';
525: End if;
526: End if;

Line 537: hr_utility.set_location('Step has Emp Placement ',65);

533: If P_Effective_Date >= l_Asgt_Eed Then
534: l_steps_exists_on_oipl := 'N';
535: Else
536: if g_debug then
537: hr_utility.set_location('Step has Emp Placement ',65);
538: end if;
539: l_steps_exists_on_oipl := 'Y';
540: End If;
541: End if;

Line 547: hr_utility.set_location('Leaving'||l_proc,100);

543:
544: end if; -- Step Id Not null
545: End If;
546: if g_debug then
547: hr_utility.set_location('Leaving'||l_proc,100);
548: end if;
549: return l_steps_exists_on_oipl;
550:
551: Exception

Line 587: hr_utility.set_location('Entering '||l_proc,5);

583:
584:
585: Begin
586: if g_debug then
587: hr_utility.set_location('Entering '||l_proc,5);
588: hr_utility.set_location('p_Pgm_Id :'||p_Pgm_Id ,10);
589: hr_utility.set_location('p_Business_Group_Id:'||p_Business_Group_Id, 15);
590: hr_utility.set_location('p_Effective_Date:'||p_Effective_Date, 20);
591: end if;

Line 588: hr_utility.set_location('p_Pgm_Id :'||p_Pgm_Id ,10);

584:
585: Begin
586: if g_debug then
587: hr_utility.set_location('Entering '||l_proc,5);
588: hr_utility.set_location('p_Pgm_Id :'||p_Pgm_Id ,10);
589: hr_utility.set_location('p_Business_Group_Id:'||p_Business_Group_Id, 15);
590: hr_utility.set_location('p_Effective_Date:'||p_Effective_Date, 20);
591: end if;
592:

Line 589: hr_utility.set_location('p_Business_Group_Id:'||p_Business_Group_Id, 15);

585: Begin
586: if g_debug then
587: hr_utility.set_location('Entering '||l_proc,5);
588: hr_utility.set_location('p_Pgm_Id :'||p_Pgm_Id ,10);
589: hr_utility.set_location('p_Business_Group_Id:'||p_Business_Group_Id, 15);
590: hr_utility.set_location('p_Effective_Date:'||p_Effective_Date, 20);
591: end if;
592:
593: Open csr_pgm_typ;

Line 590: hr_utility.set_location('p_Effective_Date:'||p_Effective_Date, 20);

586: if g_debug then
587: hr_utility.set_location('Entering '||l_proc,5);
588: hr_utility.set_location('p_Pgm_Id :'||p_Pgm_Id ,10);
589: hr_utility.set_location('p_Business_Group_Id:'||p_Business_Group_Id, 15);
590: hr_utility.set_location('p_Effective_Date:'||p_Effective_Date, 20);
591: end if;
592:
593: Open csr_pgm_typ;
594: Fetch csr_pgm_typ into l_dummy;

Line 601: hr_utility.set_location('Pgm Type is GSP (Y/N):'||l_type, 25);

597: End If;
598: Close csr_pgm_typ;
599:
600: if g_debug then
601: hr_utility.set_location('Pgm Type is GSP (Y/N):'||l_type, 25);
602: hr_utility.set_location('Leaving '||l_proc,100);
603: end if;
604:
605: return l_type;

Line 602: hr_utility.set_location('Leaving '||l_proc,100);

598: Close csr_pgm_typ;
599:
600: if g_debug then
601: hr_utility.set_location('Pgm Type is GSP (Y/N):'||l_type, 25);
602: hr_utility.set_location('Leaving '||l_proc,100);
603: end if;
604:
605: return l_type;
606: Exception

Line 650: hr_utility.set_location('Entering '||l_proc,5);

646: AND Assgt.business_group_id = p_Business_Group_Id;
647:
648: Begin
649: if g_debug then
650: hr_utility.set_location('Entering '||l_proc,5);
651: hr_utility.set_location('p_Pgm_Id :'||p_Pgm_Id ,10);
652: hr_utility.set_location('p_Business_Group_Id:'||p_Business_Group_Id, 15);
653: hr_utility.set_location('p_Effective_Date:'||p_Effective_Date, 20);
654: end if;

Line 651: hr_utility.set_location('p_Pgm_Id :'||p_Pgm_Id ,10);

647:
648: Begin
649: if g_debug then
650: hr_utility.set_location('Entering '||l_proc,5);
651: hr_utility.set_location('p_Pgm_Id :'||p_Pgm_Id ,10);
652: hr_utility.set_location('p_Business_Group_Id:'||p_Business_Group_Id, 15);
653: hr_utility.set_location('p_Effective_Date:'||p_Effective_Date, 20);
654: end if;
655:

Line 652: hr_utility.set_location('p_Business_Group_Id:'||p_Business_Group_Id, 15);

648: Begin
649: if g_debug then
650: hr_utility.set_location('Entering '||l_proc,5);
651: hr_utility.set_location('p_Pgm_Id :'||p_Pgm_Id ,10);
652: hr_utility.set_location('p_Business_Group_Id:'||p_Business_Group_Id, 15);
653: hr_utility.set_location('p_Effective_Date:'||p_Effective_Date, 20);
654: end if;
655:
656: Open csr_pgm_typ;

Line 653: hr_utility.set_location('p_Effective_Date:'||p_Effective_Date, 20);

649: if g_debug then
650: hr_utility.set_location('Entering '||l_proc,5);
651: hr_utility.set_location('p_Pgm_Id :'||p_Pgm_Id ,10);
652: hr_utility.set_location('p_Business_Group_Id:'||p_Business_Group_Id, 15);
653: hr_utility.set_location('p_Effective_Date:'||p_Effective_Date, 20);
654: end if;
655:
656: Open csr_pgm_typ;
657: Fetch csr_pgm_typ into l_pgm_type;

Line 661: hr_utility.set_location('Program Type :'||l_pgm_type, 25);

657: Fetch csr_pgm_typ into l_pgm_type;
658: Close csr_pgm_typ;
659:
660: if g_debug then
661: hr_utility.set_location('Program Type :'||l_pgm_type, 25);
662: end if;
663:
664: If l_pgm_type = 'GSP' Then
665: Open csr_emp_placemnets;

Line 669: hr_utility.set_location('Emp Placemnts exist on Program ',35);

665: Open csr_emp_placemnets;
666: Fetch csr_emp_placemnets into l_dummy;
667: If csr_emp_placemnets%Found then
668: if g_debug then
669: hr_utility.set_location('Emp Placemnts exist on Program ',35);
670: end if;
671: l_exists := 'Y';
672: End If;
673: Close csr_emp_placemnets;

Line 677: hr_utility.set_location('Leaving '||l_proc,100);

673: Close csr_emp_placemnets;
674: End If;
675:
676: if g_debug then
677: hr_utility.set_location('Leaving '||l_proc,100);
678: end if;
679: return l_exists;
680: Exception
681: when others then

Line 728: hr_utility.set_location('Entering '||l_proc,5);

724:
725:
726: Begin
727: if g_debug then
728: hr_utility.set_location('Entering '||l_proc,5);
729: hr_utility.set_location('p_Pgm_Id :'||p_Pgm_Id ,10);
730: hr_utility.set_location('p_Business_Group_Id:'||p_Business_Group_Id, 15);
731: hr_utility.set_location('p_Effective_Date:'||p_Effective_Date, 20);
732: end if;

Line 729: hr_utility.set_location('p_Pgm_Id :'||p_Pgm_Id ,10);

725:
726: Begin
727: if g_debug then
728: hr_utility.set_location('Entering '||l_proc,5);
729: hr_utility.set_location('p_Pgm_Id :'||p_Pgm_Id ,10);
730: hr_utility.set_location('p_Business_Group_Id:'||p_Business_Group_Id, 15);
731: hr_utility.set_location('p_Effective_Date:'||p_Effective_Date, 20);
732: end if;
733:

Line 730: hr_utility.set_location('p_Business_Group_Id:'||p_Business_Group_Id, 15);

726: Begin
727: if g_debug then
728: hr_utility.set_location('Entering '||l_proc,5);
729: hr_utility.set_location('p_Pgm_Id :'||p_Pgm_Id ,10);
730: hr_utility.set_location('p_Business_Group_Id:'||p_Business_Group_Id, 15);
731: hr_utility.set_location('p_Effective_Date:'||p_Effective_Date, 20);
732: end if;
733:
734: Open csr_grades;

Line 731: hr_utility.set_location('p_Effective_Date:'||p_Effective_Date, 20);

727: if g_debug then
728: hr_utility.set_location('Entering '||l_proc,5);
729: hr_utility.set_location('p_Pgm_Id :'||p_Pgm_Id ,10);
730: hr_utility.set_location('p_Business_Group_Id:'||p_Business_Group_Id, 15);
731: hr_utility.set_location('p_Effective_Date:'||p_Effective_Date, 20);
732: end if;
733:
734: Open csr_grades;
735: Fetch csr_grades into l_dummy;

Line 742: hr_utility.set_location('Program has Grades (Y/N) :'||l_exists, 25);

738: End If;
739: Close csr_grades;
740:
741: if g_debug then
742: hr_utility.set_location('Program has Grades (Y/N) :'||l_exists, 25);
743: hr_utility.set_location('Leaving '||l_proc,100);
744: end if;
745:
746: return l_exists;

Line 743: hr_utility.set_location('Leaving '||l_proc,100);

739: Close csr_grades;
740:
741: if g_debug then
742: hr_utility.set_location('Program has Grades (Y/N) :'||l_exists, 25);
743: hr_utility.set_location('Leaving '||l_proc,100);
744: end if;
745:
746: return l_exists;
747: Exception

Line 788: hr_utility.set_location('Entering'||l_proc,5);

784: and nvl(Pgm.effective_end_date,hr_general.end_of_time);
785:
786: Begin
787: if g_debug then
788: hr_utility.set_location('Entering'||l_proc,5);
789: hr_utility.set_location('p_pl_id'||p_pl_id,10);
790: hr_utility.set_location('p_effective_date:'||p_effective_date, 15);
791: hr_utility.set_location('p_Business_Group_Id:'||p_Business_Group_Id, 20);
792: end if;

Line 789: hr_utility.set_location('p_pl_id'||p_pl_id,10);

785:
786: Begin
787: if g_debug then
788: hr_utility.set_location('Entering'||l_proc,5);
789: hr_utility.set_location('p_pl_id'||p_pl_id,10);
790: hr_utility.set_location('p_effective_date:'||p_effective_date, 15);
791: hr_utility.set_location('p_Business_Group_Id:'||p_Business_Group_Id, 20);
792: end if;
793:

Line 790: hr_utility.set_location('p_effective_date:'||p_effective_date, 15);

786: Begin
787: if g_debug then
788: hr_utility.set_location('Entering'||l_proc,5);
789: hr_utility.set_location('p_pl_id'||p_pl_id,10);
790: hr_utility.set_location('p_effective_date:'||p_effective_date, 15);
791: hr_utility.set_location('p_Business_Group_Id:'||p_Business_Group_Id, 20);
792: end if;
793:
794:

Line 791: hr_utility.set_location('p_Business_Group_Id:'||p_Business_Group_Id, 20);

787: if g_debug then
788: hr_utility.set_location('Entering'||l_proc,5);
789: hr_utility.set_location('p_pl_id'||p_pl_id,10);
790: hr_utility.set_location('p_effective_date:'||p_effective_date, 15);
791: hr_utility.set_location('p_Business_Group_Id:'||p_Business_Group_Id, 20);
792: end if;
793:
794:
795: Open csr_pl_in_grdldr;

Line 804: hr_utility.set_location('Leaving'||l_proc,100);

800: Close csr_pl_in_grdldr;
801: --
802: --
803: if g_debug then
804: hr_utility.set_location('Leaving'||l_proc,100);
805: end if;
806: return l_exists;
807:
808: Exception

Line 855: hr_utility.set_location('Entering'||l_proc,5);

851: AND nvl(pl.effective_end_date,hr_general.end_of_time);
852:
853: Begin
854: if g_debug then
855: hr_utility.set_location('Entering'||l_proc,5);
856: hr_utility.set_location('p_opt_id'||p_opt_id,10);
857: hr_utility.set_location('p_effective_date:'||p_effective_date, 15);
858: hr_utility.set_location('p_Business_Group_Id:'||p_Business_Group_Id, 20);
859: end if;

Line 856: hr_utility.set_location('p_opt_id'||p_opt_id,10);

852:
853: Begin
854: if g_debug then
855: hr_utility.set_location('Entering'||l_proc,5);
856: hr_utility.set_location('p_opt_id'||p_opt_id,10);
857: hr_utility.set_location('p_effective_date:'||p_effective_date, 15);
858: hr_utility.set_location('p_Business_Group_Id:'||p_Business_Group_Id, 20);
859: end if;
860:

Line 857: hr_utility.set_location('p_effective_date:'||p_effective_date, 15);

853: Begin
854: if g_debug then
855: hr_utility.set_location('Entering'||l_proc,5);
856: hr_utility.set_location('p_opt_id'||p_opt_id,10);
857: hr_utility.set_location('p_effective_date:'||p_effective_date, 15);
858: hr_utility.set_location('p_Business_Group_Id:'||p_Business_Group_Id, 20);
859: end if;
860:
861: l_opt_has_gsp_type := chk_opt_has_gsp_type(p_opt_id => p_opt_id ,

Line 858: hr_utility.set_location('p_Business_Group_Id:'||p_Business_Group_Id, 20);

854: if g_debug then
855: hr_utility.set_location('Entering'||l_proc,5);
856: hr_utility.set_location('p_opt_id'||p_opt_id,10);
857: hr_utility.set_location('p_effective_date:'||p_effective_date, 15);
858: hr_utility.set_location('p_Business_Group_Id:'||p_Business_Group_Id, 20);
859: end if;
860:
861: l_opt_has_gsp_type := chk_opt_has_gsp_type(p_opt_id => p_opt_id ,
862: p_effective_date => p_effective_date,

Line 865: hr_utility.set_location('Is OPT has GSP Type (Y/N) '||l_opt_has_gsp_type,40);

861: l_opt_has_gsp_type := chk_opt_has_gsp_type(p_opt_id => p_opt_id ,
862: p_effective_date => p_effective_date,
863: p_business_group_id => p_business_group_id);
864: if g_debug then
865: hr_utility.set_location('Is OPT has GSP Type (Y/N) '||l_opt_has_gsp_type,40);
866: end if;
867:
868: If l_opt_has_gsp_type = 'Y' Then
869: Open csr_opt_in_pl;

Line 877: hr_utility.set_location('OPT is in GSP Plan (Y/N) '||l_exists,90);

873: End If;
874: Close csr_opt_in_pl;
875: End if;
876: if g_debug then
877: hr_utility.set_location('OPT is in GSP Plan (Y/N) '||l_exists,90);
878: hr_utility.set_location('Leaving'||l_proc,100);
879: end if;
880: return l_exists;
881:

Line 878: hr_utility.set_location('Leaving'||l_proc,100);

874: Close csr_opt_in_pl;
875: End if;
876: if g_debug then
877: hr_utility.set_location('OPT is in GSP Plan (Y/N) '||l_exists,90);
878: hr_utility.set_location('Leaving'||l_proc,100);
879: end if;
880: return l_exists;
881:
882: Exception

Line 926: hr_utility.set_location('Entering'||l_proc,5);

922:
923:
924: Begin
925: if g_debug then
926: hr_utility.set_location('Entering'||l_proc,5);
927: hr_utility.set_location('p_opt_id'||p_opt_id,10);
928: hr_utility.set_location('p_effective_date:'||p_effective_date, 15);
929: hr_utility.set_location('p_Business_Group_Id:'||p_Business_Group_Id, 20);
930: end if;

Line 927: hr_utility.set_location('p_opt_id'||p_opt_id,10);

923:
924: Begin
925: if g_debug then
926: hr_utility.set_location('Entering'||l_proc,5);
927: hr_utility.set_location('p_opt_id'||p_opt_id,10);
928: hr_utility.set_location('p_effective_date:'||p_effective_date, 15);
929: hr_utility.set_location('p_Business_Group_Id:'||p_Business_Group_Id, 20);
930: end if;
931:

Line 928: hr_utility.set_location('p_effective_date:'||p_effective_date, 15);

924: Begin
925: if g_debug then
926: hr_utility.set_location('Entering'||l_proc,5);
927: hr_utility.set_location('p_opt_id'||p_opt_id,10);
928: hr_utility.set_location('p_effective_date:'||p_effective_date, 15);
929: hr_utility.set_location('p_Business_Group_Id:'||p_Business_Group_Id, 20);
930: end if;
931:
932: -- 1) Check OPT has GSP Type

Line 929: hr_utility.set_location('p_Business_Group_Id:'||p_Business_Group_Id, 20);

925: if g_debug then
926: hr_utility.set_location('Entering'||l_proc,5);
927: hr_utility.set_location('p_opt_id'||p_opt_id,10);
928: hr_utility.set_location('p_effective_date:'||p_effective_date, 15);
929: hr_utility.set_location('p_Business_Group_Id:'||p_Business_Group_Id, 20);
930: end if;
931:
932: -- 1) Check OPT has GSP Type
933: -- 2) Check OPT is in GSP Plan through PLIP

Line 939: hr_utility.set_location('Is OPT has GSP Type (Y/N) '||l_opt_exist_in_plan,40);

935: l_opt_exist_in_plan := chk_opt_exists_in_gsp_pl(p_opt_id => p_opt_id ,
936: p_effective_date => p_effective_date,
937: p_business_group_id => p_business_group_id);
938: if g_debug then
939: hr_utility.set_location('Is OPT has GSP Type (Y/N) '||l_opt_exist_in_plan,40);
940: end if;
941:
942: If l_opt_exist_in_plan = 'Y' Then
943:

Line 949: hr_utility.set_location('Plan Id : '||l_pl_id,45);

945: Open csr_pl_id;
946: Fetch csr_pl_id into l_pl_id;
947: Close csr_pl_id;
948: if g_debug then
949: hr_utility.set_location('Plan Id : '||l_pl_id,45);
950: end if;
951:
952:
953: If l_pl_id IS NOT NULL Then

Line 961: hr_utility.set_location(' Plan Exists in Grdldr (Y/N) : '||l_pl_exists_in_grdldr,55);

957: p_effective_date =>p_effective_date,
958: p_Business_Group_Id =>p_business_group_id);
959:
960: if g_debug then
961: hr_utility.set_location(' Plan Exists in Grdldr (Y/N) : '||l_pl_exists_in_grdldr,55);
962: end if;
963:
964:
965: End if;

Line 969: hr_utility.set_location('Finally Opt Exists in Gsp Pgm (Y/N)'||l_pl_exists_in_grdldr,90);

965: End if;
966:
967: End if;
968: if g_debug then
969: hr_utility.set_location('Finally Opt Exists in Gsp Pgm (Y/N)'||l_pl_exists_in_grdldr,90);
970: hr_utility.set_location('Leaving'||l_proc,100);
971: end if;
972:
973: return l_pl_exists_in_grdldr;

Line 970: hr_utility.set_location('Leaving'||l_proc,100);

966:
967: End if;
968: if g_debug then
969: hr_utility.set_location('Finally Opt Exists in Gsp Pgm (Y/N)'||l_pl_exists_in_grdldr,90);
970: hr_utility.set_location('Leaving'||l_proc,100);
971: end if;
972:
973: return l_pl_exists_in_grdldr;
974:

Line 1035: hr_utility.set_location('Entering '||l_proc,5);

1031: And effective_end_date>= p_effective_date;
1032:
1033: Begin
1034: if g_debug then
1035: hr_utility.set_location('Entering '||l_proc,5);
1036: hr_utility.set_location('p_Pgm_Id :'||p_Pgm_Id ,10);
1037: hr_utility.set_location('p_Business_Group_Id:'||p_Business_Group_Id, 15);
1038: hr_utility.set_location('p_Short_Name:'||p_Short_Name, 20);
1039: hr_utility.set_location('p_Short_Code:'||p_Short_Code, 25);

Line 1036: hr_utility.set_location('p_Pgm_Id :'||p_Pgm_Id ,10);

1032:
1033: Begin
1034: if g_debug then
1035: hr_utility.set_location('Entering '||l_proc,5);
1036: hr_utility.set_location('p_Pgm_Id :'||p_Pgm_Id ,10);
1037: hr_utility.set_location('p_Business_Group_Id:'||p_Business_Group_Id, 15);
1038: hr_utility.set_location('p_Short_Name:'||p_Short_Name, 20);
1039: hr_utility.set_location('p_Short_Code:'||p_Short_Code, 25);
1040: hr_utility.set_location('p_Dflt_Pgm_Flag:'||p_Dflt_Pgm_Flag, 30);

Line 1037: hr_utility.set_location('p_Business_Group_Id:'||p_Business_Group_Id, 15);

1033: Begin
1034: if g_debug then
1035: hr_utility.set_location('Entering '||l_proc,5);
1036: hr_utility.set_location('p_Pgm_Id :'||p_Pgm_Id ,10);
1037: hr_utility.set_location('p_Business_Group_Id:'||p_Business_Group_Id, 15);
1038: hr_utility.set_location('p_Short_Name:'||p_Short_Name, 20);
1039: hr_utility.set_location('p_Short_Code:'||p_Short_Code, 25);
1040: hr_utility.set_location('p_Dflt_Pgm_Flag:'||p_Dflt_Pgm_Flag, 30);
1041: end if;

Line 1038: hr_utility.set_location('p_Short_Name:'||p_Short_Name, 20);

1034: if g_debug then
1035: hr_utility.set_location('Entering '||l_proc,5);
1036: hr_utility.set_location('p_Pgm_Id :'||p_Pgm_Id ,10);
1037: hr_utility.set_location('p_Business_Group_Id:'||p_Business_Group_Id, 15);
1038: hr_utility.set_location('p_Short_Name:'||p_Short_Name, 20);
1039: hr_utility.set_location('p_Short_Code:'||p_Short_Code, 25);
1040: hr_utility.set_location('p_Dflt_Pgm_Flag:'||p_Dflt_Pgm_Flag, 30);
1041: end if;
1042:

Line 1039: hr_utility.set_location('p_Short_Code:'||p_Short_Code, 25);

1035: hr_utility.set_location('Entering '||l_proc,5);
1036: hr_utility.set_location('p_Pgm_Id :'||p_Pgm_Id ,10);
1037: hr_utility.set_location('p_Business_Group_Id:'||p_Business_Group_Id, 15);
1038: hr_utility.set_location('p_Short_Name:'||p_Short_Name, 20);
1039: hr_utility.set_location('p_Short_Code:'||p_Short_Code, 25);
1040: hr_utility.set_location('p_Dflt_Pgm_Flag:'||p_Dflt_Pgm_Flag, 30);
1041: end if;
1042:
1043:

Line 1040: hr_utility.set_location('p_Dflt_Pgm_Flag:'||p_Dflt_Pgm_Flag, 30);

1036: hr_utility.set_location('p_Pgm_Id :'||p_Pgm_Id ,10);
1037: hr_utility.set_location('p_Business_Group_Id:'||p_Business_Group_Id, 15);
1038: hr_utility.set_location('p_Short_Name:'||p_Short_Name, 20);
1039: hr_utility.set_location('p_Short_Code:'||p_Short_Code, 25);
1040: hr_utility.set_location('p_Dflt_Pgm_Flag:'||p_Dflt_Pgm_Flag, 30);
1041: end if;
1042:
1043:
1044: --

Line 1047: hr_utility.set_location('Chk Short Name...', 35);

1043:
1044: --
1045: --
1046: if g_debug then
1047: hr_utility.set_location('Chk Short Name...', 35);
1048: end if;
1049: --
1050: --
1051: If p_Short_Name IS NOT NULL Then

Line 1056: hr_utility.set_message(8302,'PQH_GSP_GL_SHT_NAME_UNQ');

1052: Open csr_short_name;
1053: Fetch csr_short_name into l_dummy;
1054: If csr_short_name%Found then
1055: Close csr_short_name;
1056: hr_utility.set_message(8302,'PQH_GSP_GL_SHT_NAME_UNQ');
1057: hr_utility.raise_error;
1058: End If;
1059: Close csr_short_name;
1060: End If;

Line 1057: hr_utility.raise_error;

1053: Fetch csr_short_name into l_dummy;
1054: If csr_short_name%Found then
1055: Close csr_short_name;
1056: hr_utility.set_message(8302,'PQH_GSP_GL_SHT_NAME_UNQ');
1057: hr_utility.raise_error;
1058: End If;
1059: Close csr_short_name;
1060: End If;
1061: --

Line 1064: hr_utility.set_location('Chk Short Code....', 40);

1060: End If;
1061: --
1062: --
1063: if g_debug then
1064: hr_utility.set_location('Chk Short Code....', 40);
1065: end if;
1066: --
1067: --
1068: If p_Short_Code IS NOT NULL Then

Line 1073: hr_utility.set_message(8302,'PQH_GSP_GL_SHT_CODE_UNQ');

1069: Open csr_short_code;
1070: Fetch csr_short_code into l_dummy;
1071: If csr_short_code%Found then
1072: Close csr_short_code;
1073: hr_utility.set_message(8302,'PQH_GSP_GL_SHT_CODE_UNQ');
1074: hr_utility.raise_error;
1075: End If;
1076: Close csr_short_code;
1077: End If;

Line 1074: hr_utility.raise_error;

1070: Fetch csr_short_code into l_dummy;
1071: If csr_short_code%Found then
1072: Close csr_short_code;
1073: hr_utility.set_message(8302,'PQH_GSP_GL_SHT_CODE_UNQ');
1074: hr_utility.raise_error;
1075: End If;
1076: Close csr_short_code;
1077: End If;
1078: --

Line 1081: hr_utility.set_location('Chk Default Grade Ladder....', 45);

1077: End If;
1078: --
1079: --
1080: if g_debug then
1081: hr_utility.set_location('Chk Default Grade Ladder....', 45);
1082: end if;
1083: --
1084: --
1085: If p_Dflt_Pgm_Flag ='Y' Then

Line 1090: hr_utility.set_message(8302,'PQH_GSP_BEN_DFLT_GRDLDR');

1086: Open csr_default_grdldr;
1087: Fetch csr_default_grdldr into l_dummy;
1088: If csr_default_grdldr%Found then
1089: Close csr_default_grdldr;
1090: hr_utility.set_message(8302,'PQH_GSP_BEN_DFLT_GRDLDR');
1091: hr_utility.raise_error;
1092: End If;
1093: Close csr_default_grdldr;
1094: End If;

Line 1091: hr_utility.raise_error;

1087: Fetch csr_default_grdldr into l_dummy;
1088: If csr_default_grdldr%Found then
1089: Close csr_default_grdldr;
1090: hr_utility.set_message(8302,'PQH_GSP_BEN_DFLT_GRDLDR');
1091: hr_utility.raise_error;
1092: End If;
1093: Close csr_default_grdldr;
1094: End If;
1095: --

Line 1098: hr_utility.set_location('Leaving:'||l_proc, 100);

1094: End If;
1095: --
1096: --
1097: if g_debug then
1098: hr_utility.set_location('Leaving:'||l_proc, 100);
1099: end if;
1100:
1101: End;
1102:

Line 1144: hr_utility.set_location('Entering '||l_proc,5);

1140:
1141:
1142: Begin
1143: if g_debug then
1144: hr_utility.set_location('Entering '||l_proc,5);
1145: hr_utility.set_location('p_Pgm_Id :'||p_Pgm_Id ,10);
1146: hr_utility.set_location('p_Business_Group_Id:'||p_Business_Group_Id, 15);
1147: hr_utility.set_location('p_Short_Name:'||p_Short_Name, 20);
1148: hr_utility.set_location('p_Short_Code:'||p_Short_Code, 25);

Line 1145: hr_utility.set_location('p_Pgm_Id :'||p_Pgm_Id ,10);

1141:
1142: Begin
1143: if g_debug then
1144: hr_utility.set_location('Entering '||l_proc,5);
1145: hr_utility.set_location('p_Pgm_Id :'||p_Pgm_Id ,10);
1146: hr_utility.set_location('p_Business_Group_Id:'||p_Business_Group_Id, 15);
1147: hr_utility.set_location('p_Short_Name:'||p_Short_Name, 20);
1148: hr_utility.set_location('p_Short_Code:'||p_Short_Code, 25);
1149: hr_utility.set_location('p_Dflt_Pgm_Flag:'||p_Dflt_Pgm_Flag, 30);

Line 1146: hr_utility.set_location('p_Business_Group_Id:'||p_Business_Group_Id, 15);

1142: Begin
1143: if g_debug then
1144: hr_utility.set_location('Entering '||l_proc,5);
1145: hr_utility.set_location('p_Pgm_Id :'||p_Pgm_Id ,10);
1146: hr_utility.set_location('p_Business_Group_Id:'||p_Business_Group_Id, 15);
1147: hr_utility.set_location('p_Short_Name:'||p_Short_Name, 20);
1148: hr_utility.set_location('p_Short_Code:'||p_Short_Code, 25);
1149: hr_utility.set_location('p_Dflt_Pgm_Flag:'||p_Dflt_Pgm_Flag, 30);
1150: hr_utility.set_location('p_Pgm_Typ_Cd:'||p_Pgm_Typ_Cd, 35);

Line 1147: hr_utility.set_location('p_Short_Name:'||p_Short_Name, 20);

1143: if g_debug then
1144: hr_utility.set_location('Entering '||l_proc,5);
1145: hr_utility.set_location('p_Pgm_Id :'||p_Pgm_Id ,10);
1146: hr_utility.set_location('p_Business_Group_Id:'||p_Business_Group_Id, 15);
1147: hr_utility.set_location('p_Short_Name:'||p_Short_Name, 20);
1148: hr_utility.set_location('p_Short_Code:'||p_Short_Code, 25);
1149: hr_utility.set_location('p_Dflt_Pgm_Flag:'||p_Dflt_Pgm_Flag, 30);
1150: hr_utility.set_location('p_Pgm_Typ_Cd:'||p_Pgm_Typ_Cd, 35);
1151: hr_utility.set_location('p_pgm_Stat_cd:'||p_pgm_Stat_cd, 40);

Line 1148: hr_utility.set_location('p_Short_Code:'||p_Short_Code, 25);

1144: hr_utility.set_location('Entering '||l_proc,5);
1145: hr_utility.set_location('p_Pgm_Id :'||p_Pgm_Id ,10);
1146: hr_utility.set_location('p_Business_Group_Id:'||p_Business_Group_Id, 15);
1147: hr_utility.set_location('p_Short_Name:'||p_Short_Name, 20);
1148: hr_utility.set_location('p_Short_Code:'||p_Short_Code, 25);
1149: hr_utility.set_location('p_Dflt_Pgm_Flag:'||p_Dflt_Pgm_Flag, 30);
1150: hr_utility.set_location('p_Pgm_Typ_Cd:'||p_Pgm_Typ_Cd, 35);
1151: hr_utility.set_location('p_pgm_Stat_cd:'||p_pgm_Stat_cd, 40);
1152: hr_utility.set_location('p_Acty_Ref_Perd_Cd:'||p_Acty_Ref_Perd_Cd, 41);

Line 1149: hr_utility.set_location('p_Dflt_Pgm_Flag:'||p_Dflt_Pgm_Flag, 30);

1145: hr_utility.set_location('p_Pgm_Id :'||p_Pgm_Id ,10);
1146: hr_utility.set_location('p_Business_Group_Id:'||p_Business_Group_Id, 15);
1147: hr_utility.set_location('p_Short_Name:'||p_Short_Name, 20);
1148: hr_utility.set_location('p_Short_Code:'||p_Short_Code, 25);
1149: hr_utility.set_location('p_Dflt_Pgm_Flag:'||p_Dflt_Pgm_Flag, 30);
1150: hr_utility.set_location('p_Pgm_Typ_Cd:'||p_Pgm_Typ_Cd, 35);
1151: hr_utility.set_location('p_pgm_Stat_cd:'||p_pgm_Stat_cd, 40);
1152: hr_utility.set_location('p_Acty_Ref_Perd_Cd:'||p_Acty_Ref_Perd_Cd, 41);
1153: hr_utility.set_location('p_Pgm_Uom:'||p_Pgm_Uom, 42);

Line 1150: hr_utility.set_location('p_Pgm_Typ_Cd:'||p_Pgm_Typ_Cd, 35);

1146: hr_utility.set_location('p_Business_Group_Id:'||p_Business_Group_Id, 15);
1147: hr_utility.set_location('p_Short_Name:'||p_Short_Name, 20);
1148: hr_utility.set_location('p_Short_Code:'||p_Short_Code, 25);
1149: hr_utility.set_location('p_Dflt_Pgm_Flag:'||p_Dflt_Pgm_Flag, 30);
1150: hr_utility.set_location('p_Pgm_Typ_Cd:'||p_Pgm_Typ_Cd, 35);
1151: hr_utility.set_location('p_pgm_Stat_cd:'||p_pgm_Stat_cd, 40);
1152: hr_utility.set_location('p_Acty_Ref_Perd_Cd:'||p_Acty_Ref_Perd_Cd, 41);
1153: hr_utility.set_location('p_Pgm_Uom:'||p_Pgm_Uom, 42);
1154: end if;

Line 1151: hr_utility.set_location('p_pgm_Stat_cd:'||p_pgm_Stat_cd, 40);

1147: hr_utility.set_location('p_Short_Name:'||p_Short_Name, 20);
1148: hr_utility.set_location('p_Short_Code:'||p_Short_Code, 25);
1149: hr_utility.set_location('p_Dflt_Pgm_Flag:'||p_Dflt_Pgm_Flag, 30);
1150: hr_utility.set_location('p_Pgm_Typ_Cd:'||p_Pgm_Typ_Cd, 35);
1151: hr_utility.set_location('p_pgm_Stat_cd:'||p_pgm_Stat_cd, 40);
1152: hr_utility.set_location('p_Acty_Ref_Perd_Cd:'||p_Acty_Ref_Perd_Cd, 41);
1153: hr_utility.set_location('p_Pgm_Uom:'||p_Pgm_Uom, 42);
1154: end if;
1155:

Line 1152: hr_utility.set_location('p_Acty_Ref_Perd_Cd:'||p_Acty_Ref_Perd_Cd, 41);

1148: hr_utility.set_location('p_Short_Code:'||p_Short_Code, 25);
1149: hr_utility.set_location('p_Dflt_Pgm_Flag:'||p_Dflt_Pgm_Flag, 30);
1150: hr_utility.set_location('p_Pgm_Typ_Cd:'||p_Pgm_Typ_Cd, 35);
1151: hr_utility.set_location('p_pgm_Stat_cd:'||p_pgm_Stat_cd, 40);
1152: hr_utility.set_location('p_Acty_Ref_Perd_Cd:'||p_Acty_Ref_Perd_Cd, 41);
1153: hr_utility.set_location('p_Pgm_Uom:'||p_Pgm_Uom, 42);
1154: end if;
1155:
1156: pqh_gsp_ben_validations.pgm_ins_val( p_Pgm_Id => p_pgm_id,

Line 1153: hr_utility.set_location('p_Pgm_Uom:'||p_Pgm_Uom, 42);

1149: hr_utility.set_location('p_Dflt_Pgm_Flag:'||p_Dflt_Pgm_Flag, 30);
1150: hr_utility.set_location('p_Pgm_Typ_Cd:'||p_Pgm_Typ_Cd, 35);
1151: hr_utility.set_location('p_pgm_Stat_cd:'||p_pgm_Stat_cd, 40);
1152: hr_utility.set_location('p_Acty_Ref_Perd_Cd:'||p_Acty_Ref_Perd_Cd, 41);
1153: hr_utility.set_location('p_Pgm_Uom:'||p_Pgm_Uom, 42);
1154: end if;
1155:
1156: pqh_gsp_ben_validations.pgm_ins_val( p_Pgm_Id => p_pgm_id,
1157: p_Business_Group_Id => p_business_group_id,

Line 1169: hr_utility.set_location('Emp Exists on Pgm (Y/N) :'||l_exists, 95);

1165: p_Business_Group_Id => p_Business_Group_Id,
1166: p_Effective_Date => p_Effective_Date);
1167:
1168: if g_debug then
1169: hr_utility.set_location('Emp Exists on Pgm (Y/N) :'||l_exists, 95);
1170: end if;
1171:
1172: l_grd_exists := chk_pgm_has_grades(p_Pgm_Id => p_Pgm_Id,
1173: p_Business_Group_Id => p_Business_Group_Id,

Line 1177: hr_utility.set_location('Pgm has Grades (Y/N) :'||l_grd_exists, 100);

1173: p_Business_Group_Id => p_Business_Group_Id,
1174: p_Effective_Date => p_Effective_Date);
1175:
1176: if g_debug then
1177: hr_utility.set_location('Pgm has Grades (Y/N) :'||l_grd_exists, 100);
1178: end if;
1179:
1180: -- changed for Bug 7114098. Check for l_grd_exists has been removed as this check has already been
1181: -- done earlier in pqh_gsp_utility.chk_grdldr_grd_curreny_rate, which is called well before the

Line 1188: hr_utility.set_location('Old Pgm Type :'||ben_pgm_shd.g_old_rec.pgm_typ_cd, 100);

1184: -- If (l_exists = 'Y' OR l_grd_exists = 'Y') then
1185: IF (l_exists = 'Y') THEN -- bug 7114098
1186:
1187: if g_debug then
1188: hr_utility.set_location('Old Pgm Type :'||ben_pgm_shd.g_old_rec.pgm_typ_cd, 100);
1189: hr_utility.set_location('Old Pgm Status :'||ben_pgm_shd.g_old_rec.pgm_Stat_cd, 110);
1190: hr_utility.set_location('Old Points Flag :'||ben_pgm_shd.g_old_rec.Use_Prog_Points_Flag, 120);
1191: hr_utility.set_location('Old Rate Period :'||ben_pgm_shd.g_old_rec.Acty_Ref_Perd_Cd, 125);
1192: hr_utility.set_location('Old Currency :'||ben_pgm_shd.g_old_rec.Pgm_Uom, 130);

Line 1189: hr_utility.set_location('Old Pgm Status :'||ben_pgm_shd.g_old_rec.pgm_Stat_cd, 110);

1185: IF (l_exists = 'Y') THEN -- bug 7114098
1186:
1187: if g_debug then
1188: hr_utility.set_location('Old Pgm Type :'||ben_pgm_shd.g_old_rec.pgm_typ_cd, 100);
1189: hr_utility.set_location('Old Pgm Status :'||ben_pgm_shd.g_old_rec.pgm_Stat_cd, 110);
1190: hr_utility.set_location('Old Points Flag :'||ben_pgm_shd.g_old_rec.Use_Prog_Points_Flag, 120);
1191: hr_utility.set_location('Old Rate Period :'||ben_pgm_shd.g_old_rec.Acty_Ref_Perd_Cd, 125);
1192: hr_utility.set_location('Old Currency :'||ben_pgm_shd.g_old_rec.Pgm_Uom, 130);
1193: end if;

Line 1190: hr_utility.set_location('Old Points Flag :'||ben_pgm_shd.g_old_rec.Use_Prog_Points_Flag, 120);

1186:
1187: if g_debug then
1188: hr_utility.set_location('Old Pgm Type :'||ben_pgm_shd.g_old_rec.pgm_typ_cd, 100);
1189: hr_utility.set_location('Old Pgm Status :'||ben_pgm_shd.g_old_rec.pgm_Stat_cd, 110);
1190: hr_utility.set_location('Old Points Flag :'||ben_pgm_shd.g_old_rec.Use_Prog_Points_Flag, 120);
1191: hr_utility.set_location('Old Rate Period :'||ben_pgm_shd.g_old_rec.Acty_Ref_Perd_Cd, 125);
1192: hr_utility.set_location('Old Currency :'||ben_pgm_shd.g_old_rec.Pgm_Uom, 130);
1193: end if;
1194:

Line 1191: hr_utility.set_location('Old Rate Period :'||ben_pgm_shd.g_old_rec.Acty_Ref_Perd_Cd, 125);

1187: if g_debug then
1188: hr_utility.set_location('Old Pgm Type :'||ben_pgm_shd.g_old_rec.pgm_typ_cd, 100);
1189: hr_utility.set_location('Old Pgm Status :'||ben_pgm_shd.g_old_rec.pgm_Stat_cd, 110);
1190: hr_utility.set_location('Old Points Flag :'||ben_pgm_shd.g_old_rec.Use_Prog_Points_Flag, 120);
1191: hr_utility.set_location('Old Rate Period :'||ben_pgm_shd.g_old_rec.Acty_Ref_Perd_Cd, 125);
1192: hr_utility.set_location('Old Currency :'||ben_pgm_shd.g_old_rec.Pgm_Uom, 130);
1193: end if;
1194:
1195:

Line 1192: hr_utility.set_location('Old Currency :'||ben_pgm_shd.g_old_rec.Pgm_Uom, 130);

1188: hr_utility.set_location('Old Pgm Type :'||ben_pgm_shd.g_old_rec.pgm_typ_cd, 100);
1189: hr_utility.set_location('Old Pgm Status :'||ben_pgm_shd.g_old_rec.pgm_Stat_cd, 110);
1190: hr_utility.set_location('Old Points Flag :'||ben_pgm_shd.g_old_rec.Use_Prog_Points_Flag, 120);
1191: hr_utility.set_location('Old Rate Period :'||ben_pgm_shd.g_old_rec.Acty_Ref_Perd_Cd, 125);
1192: hr_utility.set_location('Old Currency :'||ben_pgm_shd.g_old_rec.Pgm_Uom, 130);
1193: end if;
1194:
1195:
1196: -- Program Type Cannot be Changed.

Line 1198: hr_utility.set_message(8302,'PQH_GSP_NOT_UPD_PGM_TYPE');

1194:
1195:
1196: -- Program Type Cannot be Changed.
1197: if (ben_pgm_shd.g_old_rec.pgm_typ_cd <> p_Pgm_Typ_Cd) then
1198: hr_utility.set_message(8302,'PQH_GSP_NOT_UPD_PGM_TYPE');
1199: hr_utility.raise_error;
1200: end if;
1201:
1202: -- Program Status Cannot be Changed.

Line 1199: hr_utility.raise_error;

1195:
1196: -- Program Type Cannot be Changed.
1197: if (ben_pgm_shd.g_old_rec.pgm_typ_cd <> p_Pgm_Typ_Cd) then
1198: hr_utility.set_message(8302,'PQH_GSP_NOT_UPD_PGM_TYPE');
1199: hr_utility.raise_error;
1200: end if;
1201:
1202: -- Program Status Cannot be Changed.
1203: if (ben_pgm_shd.g_old_rec.pgm_Stat_cd = 'A' And (ben_pgm_shd.g_old_rec.pgm_Stat_cd <> p_pgm_Stat_cd)) then

Line 1204: hr_utility.set_message(8302,'PQH_GSP_NOT_UPD_PGM_STATUS');

1200: end if;
1201:
1202: -- Program Status Cannot be Changed.
1203: if (ben_pgm_shd.g_old_rec.pgm_Stat_cd = 'A' And (ben_pgm_shd.g_old_rec.pgm_Stat_cd <> p_pgm_Stat_cd)) then
1204: hr_utility.set_message(8302,'PQH_GSP_NOT_UPD_PGM_STATUS');
1205: hr_utility.raise_error;
1206: end if;
1207:
1208: -- Progression Points flag Cannot be Changed.

Line 1205: hr_utility.raise_error;

1201:
1202: -- Program Status Cannot be Changed.
1203: if (ben_pgm_shd.g_old_rec.pgm_Stat_cd = 'A' And (ben_pgm_shd.g_old_rec.pgm_Stat_cd <> p_pgm_Stat_cd)) then
1204: hr_utility.set_message(8302,'PQH_GSP_NOT_UPD_PGM_STATUS');
1205: hr_utility.raise_error;
1206: end if;
1207:
1208: -- Progression Points flag Cannot be Changed.
1209: if (ben_pgm_shd.g_old_rec.use_prog_points_flag <> p_Use_Prog_Points_Flag) then

Line 1210: hr_utility.set_message(8302,'PQH_GSP_NOT_UPD_PGM_PRG_FLAG');

1206: end if;
1207:
1208: -- Progression Points flag Cannot be Changed.
1209: if (ben_pgm_shd.g_old_rec.use_prog_points_flag <> p_Use_Prog_Points_Flag) then
1210: hr_utility.set_message(8302,'PQH_GSP_NOT_UPD_PGM_PRG_FLAG');
1211: hr_utility.raise_error;
1212: end if;
1213:
1214:

Line 1211: hr_utility.raise_error;

1207:
1208: -- Progression Points flag Cannot be Changed.
1209: if (ben_pgm_shd.g_old_rec.use_prog_points_flag <> p_Use_Prog_Points_Flag) then
1210: hr_utility.set_message(8302,'PQH_GSP_NOT_UPD_PGM_PRG_FLAG');
1211: hr_utility.raise_error;
1212: end if;
1213:
1214:
1215: -- Rate Period Cannot be Changed.

Line 1217: hr_utility.set_message(8302,'PQH_GSP_NOT_UPD_PGM_RATE_PRD');

1213:
1214:
1215: -- Rate Period Cannot be Changed.
1216: if (ben_pgm_shd.g_old_rec.Acty_Ref_Perd_Cd <> p_Acty_Ref_Perd_Cd) then
1217: hr_utility.set_message(8302,'PQH_GSP_NOT_UPD_PGM_RATE_PRD');
1218: hr_utility.raise_error;
1219: end if;
1220:
1221: -- Currency Cannot be Changed.

Line 1218: hr_utility.raise_error;

1214:
1215: -- Rate Period Cannot be Changed.
1216: if (ben_pgm_shd.g_old_rec.Acty_Ref_Perd_Cd <> p_Acty_Ref_Perd_Cd) then
1217: hr_utility.set_message(8302,'PQH_GSP_NOT_UPD_PGM_RATE_PRD');
1218: hr_utility.raise_error;
1219: end if;
1220:
1221: -- Currency Cannot be Changed.
1222: if (ben_pgm_shd.g_old_rec.Pgm_Uom <> p_Pgm_Uom) then

Line 1223: hr_utility.set_message(8302,'PQH_GSP_NOT_UPD_PGM_CURRENCY');

1219: end if;
1220:
1221: -- Currency Cannot be Changed.
1222: if (ben_pgm_shd.g_old_rec.Pgm_Uom <> p_Pgm_Uom) then
1223: hr_utility.set_message(8302,'PQH_GSP_NOT_UPD_PGM_CURRENCY');
1224: hr_utility.raise_error;
1225: end if;
1226:
1227: End if; -- emp Exists

Line 1224: hr_utility.raise_error;

1220:
1221: -- Currency Cannot be Changed.
1222: if (ben_pgm_shd.g_old_rec.Pgm_Uom <> p_Pgm_Uom) then
1223: hr_utility.set_message(8302,'PQH_GSP_NOT_UPD_PGM_CURRENCY');
1224: hr_utility.raise_error;
1225: end if;
1226:
1227: End if; -- emp Exists
1228:

Line 1230: hr_utility.set_location('Leaving '||l_proc,100);

1226:
1227: End if; -- emp Exists
1228:
1229: if g_debug then
1230: hr_utility.set_location('Leaving '||l_proc,100);
1231: end if;
1232:
1233: End;
1234:

Line 1254: hr_utility.set_location('Entering '||l_proc,5);

1250: l_exists Varchar2(1) := 'N';
1251:
1252: Begin
1253: if g_debug then
1254: hr_utility.set_location('Entering '||l_proc,5);
1255: hr_utility.set_location('p_Pgm_Id :'||p_Pgm_Id ,10);
1256: hr_utility.set_location('p_Business_Group_Id:'||p_Business_Group_Id, 15);
1257: end if;
1258:

Line 1255: hr_utility.set_location('p_Pgm_Id :'||p_Pgm_Id ,10);

1251:
1252: Begin
1253: if g_debug then
1254: hr_utility.set_location('Entering '||l_proc,5);
1255: hr_utility.set_location('p_Pgm_Id :'||p_Pgm_Id ,10);
1256: hr_utility.set_location('p_Business_Group_Id:'||p_Business_Group_Id, 15);
1257: end if;
1258:
1259: l_exists := chk_pgm_emp_assign(p_Pgm_Id => p_Pgm_Id,

Line 1256: hr_utility.set_location('p_Business_Group_Id:'||p_Business_Group_Id, 15);

1252: Begin
1253: if g_debug then
1254: hr_utility.set_location('Entering '||l_proc,5);
1255: hr_utility.set_location('p_Pgm_Id :'||p_Pgm_Id ,10);
1256: hr_utility.set_location('p_Business_Group_Id:'||p_Business_Group_Id, 15);
1257: end if;
1258:
1259: l_exists := chk_pgm_emp_assign(p_Pgm_Id => p_Pgm_Id,
1260: p_Business_Group_Id => p_Business_Group_Id,

Line 1264: hr_utility.set_location('Emp Exists on Pgm (Y/N) :'||l_exists, 25);

1260: p_Business_Group_Id => p_Business_Group_Id,
1261: p_Effective_Date => p_Effective_Date);
1262:
1263: if g_debug then
1264: hr_utility.set_location('Emp Exists on Pgm (Y/N) :'||l_exists, 25);
1265: end if;
1266:
1267: If l_exists = 'Y' then
1268: hr_utility.set_message(8302,'PQH_GSP_BEN_NOT_DEL_PGM');

Line 1268: hr_utility.set_message(8302,'PQH_GSP_BEN_NOT_DEL_PGM');

1264: hr_utility.set_location('Emp Exists on Pgm (Y/N) :'||l_exists, 25);
1265: end if;
1266:
1267: If l_exists = 'Y' then
1268: hr_utility.set_message(8302,'PQH_GSP_BEN_NOT_DEL_PGM');
1269: hr_utility.raise_error;
1270: End If;
1271:
1272: if g_debug then

Line 1269: hr_utility.raise_error;

1265: end if;
1266:
1267: If l_exists = 'Y' then
1268: hr_utility.set_message(8302,'PQH_GSP_BEN_NOT_DEL_PGM');
1269: hr_utility.raise_error;
1270: End If;
1271:
1272: if g_debug then
1273: hr_utility.set_location('Leaving '||l_proc,100);

Line 1273: hr_utility.set_location('Leaving '||l_proc,100);

1269: hr_utility.raise_error;
1270: End If;
1271:
1272: if g_debug then
1273: hr_utility.set_location('Leaving '||l_proc,100);
1274: end if;
1275:
1276: End pgm_del_val;
1277:

Line 1313: hr_utility.set_location('Entering '||l_proc,5);

1309:
1310: --
1311: --
1312: if g_debug then
1313: hr_utility.set_location('Entering '||l_proc,5);
1314: hr_utility.set_location('p_Pgm_Id :'||p_Pgm_Id ,10);
1315: hr_utility.set_location('p_Business_Group_Id:'||p_Business_Group_Id, 15);
1316: hr_utility.set_location('p_Short_Name:'||p_Short_Name, 20);
1317: hr_utility.set_location('p_Short_Code:'||p_Short_Code, 25);

Line 1314: hr_utility.set_location('p_Pgm_Id :'||p_Pgm_Id ,10);

1310: --
1311: --
1312: if g_debug then
1313: hr_utility.set_location('Entering '||l_proc,5);
1314: hr_utility.set_location('p_Pgm_Id :'||p_Pgm_Id ,10);
1315: hr_utility.set_location('p_Business_Group_Id:'||p_Business_Group_Id, 15);
1316: hr_utility.set_location('p_Short_Name:'||p_Short_Name, 20);
1317: hr_utility.set_location('p_Short_Code:'||p_Short_Code, 25);
1318: hr_utility.set_location('p_Dflt_Pgm_Flag:'||p_Dflt_Pgm_Flag, 30);

Line 1315: hr_utility.set_location('p_Business_Group_Id:'||p_Business_Group_Id, 15);

1311: --
1312: if g_debug then
1313: hr_utility.set_location('Entering '||l_proc,5);
1314: hr_utility.set_location('p_Pgm_Id :'||p_Pgm_Id ,10);
1315: hr_utility.set_location('p_Business_Group_Id:'||p_Business_Group_Id, 15);
1316: hr_utility.set_location('p_Short_Name:'||p_Short_Name, 20);
1317: hr_utility.set_location('p_Short_Code:'||p_Short_Code, 25);
1318: hr_utility.set_location('p_Dflt_Pgm_Flag:'||p_Dflt_Pgm_Flag, 30);
1319: hr_utility.set_location('p_pgm_Stat_cd:'||p_pgm_Stat_cd, 35);

Line 1316: hr_utility.set_location('p_Short_Name:'||p_Short_Name, 20);

1312: if g_debug then
1313: hr_utility.set_location('Entering '||l_proc,5);
1314: hr_utility.set_location('p_Pgm_Id :'||p_Pgm_Id ,10);
1315: hr_utility.set_location('p_Business_Group_Id:'||p_Business_Group_Id, 15);
1316: hr_utility.set_location('p_Short_Name:'||p_Short_Name, 20);
1317: hr_utility.set_location('p_Short_Code:'||p_Short_Code, 25);
1318: hr_utility.set_location('p_Dflt_Pgm_Flag:'||p_Dflt_Pgm_Flag, 30);
1319: hr_utility.set_location('p_pgm_Stat_cd:'||p_pgm_Stat_cd, 35);
1320: hr_utility.set_location('p_Use_Prog_Points_Flag:'||p_Use_Prog_Points_Flag, 40);

Line 1317: hr_utility.set_location('p_Short_Code:'||p_Short_Code, 25);

1313: hr_utility.set_location('Entering '||l_proc,5);
1314: hr_utility.set_location('p_Pgm_Id :'||p_Pgm_Id ,10);
1315: hr_utility.set_location('p_Business_Group_Id:'||p_Business_Group_Id, 15);
1316: hr_utility.set_location('p_Short_Name:'||p_Short_Name, 20);
1317: hr_utility.set_location('p_Short_Code:'||p_Short_Code, 25);
1318: hr_utility.set_location('p_Dflt_Pgm_Flag:'||p_Dflt_Pgm_Flag, 30);
1319: hr_utility.set_location('p_pgm_Stat_cd:'||p_pgm_Stat_cd, 35);
1320: hr_utility.set_location('p_Use_Prog_Points_Flag:'||p_Use_Prog_Points_Flag, 40);
1321: hr_utility.set_location('p_Acty_Ref_Perd_Cd:'||p_Acty_Ref_Perd_Cd, 45);

Line 1318: hr_utility.set_location('p_Dflt_Pgm_Flag:'||p_Dflt_Pgm_Flag, 30);

1314: hr_utility.set_location('p_Pgm_Id :'||p_Pgm_Id ,10);
1315: hr_utility.set_location('p_Business_Group_Id:'||p_Business_Group_Id, 15);
1316: hr_utility.set_location('p_Short_Name:'||p_Short_Name, 20);
1317: hr_utility.set_location('p_Short_Code:'||p_Short_Code, 25);
1318: hr_utility.set_location('p_Dflt_Pgm_Flag:'||p_Dflt_Pgm_Flag, 30);
1319: hr_utility.set_location('p_pgm_Stat_cd:'||p_pgm_Stat_cd, 35);
1320: hr_utility.set_location('p_Use_Prog_Points_Flag:'||p_Use_Prog_Points_Flag, 40);
1321: hr_utility.set_location('p_Acty_Ref_Perd_Cd:'||p_Acty_Ref_Perd_Cd, 45);
1322: hr_utility.set_location('p_Pgm_Uom:'||p_Pgm_Uom, 50);

Line 1319: hr_utility.set_location('p_pgm_Stat_cd:'||p_pgm_Stat_cd, 35);

1315: hr_utility.set_location('p_Business_Group_Id:'||p_Business_Group_Id, 15);
1316: hr_utility.set_location('p_Short_Name:'||p_Short_Name, 20);
1317: hr_utility.set_location('p_Short_Code:'||p_Short_Code, 25);
1318: hr_utility.set_location('p_Dflt_Pgm_Flag:'||p_Dflt_Pgm_Flag, 30);
1319: hr_utility.set_location('p_pgm_Stat_cd:'||p_pgm_Stat_cd, 35);
1320: hr_utility.set_location('p_Use_Prog_Points_Flag:'||p_Use_Prog_Points_Flag, 40);
1321: hr_utility.set_location('p_Acty_Ref_Perd_Cd:'||p_Acty_Ref_Perd_Cd, 45);
1322: hr_utility.set_location('p_Pgm_Uom:'||p_Pgm_Uom, 50);
1323:

Line 1320: hr_utility.set_location('p_Use_Prog_Points_Flag:'||p_Use_Prog_Points_Flag, 40);

1316: hr_utility.set_location('p_Short_Name:'||p_Short_Name, 20);
1317: hr_utility.set_location('p_Short_Code:'||p_Short_Code, 25);
1318: hr_utility.set_location('p_Dflt_Pgm_Flag:'||p_Dflt_Pgm_Flag, 30);
1319: hr_utility.set_location('p_pgm_Stat_cd:'||p_pgm_Stat_cd, 35);
1320: hr_utility.set_location('p_Use_Prog_Points_Flag:'||p_Use_Prog_Points_Flag, 40);
1321: hr_utility.set_location('p_Acty_Ref_Perd_Cd:'||p_Acty_Ref_Perd_Cd, 45);
1322: hr_utility.set_location('p_Pgm_Uom:'||p_Pgm_Uom, 50);
1323:
1324: end if;

Line 1321: hr_utility.set_location('p_Acty_Ref_Perd_Cd:'||p_Acty_Ref_Perd_Cd, 45);

1317: hr_utility.set_location('p_Short_Code:'||p_Short_Code, 25);
1318: hr_utility.set_location('p_Dflt_Pgm_Flag:'||p_Dflt_Pgm_Flag, 30);
1319: hr_utility.set_location('p_pgm_Stat_cd:'||p_pgm_Stat_cd, 35);
1320: hr_utility.set_location('p_Use_Prog_Points_Flag:'||p_Use_Prog_Points_Flag, 40);
1321: hr_utility.set_location('p_Acty_Ref_Perd_Cd:'||p_Acty_Ref_Perd_Cd, 45);
1322: hr_utility.set_location('p_Pgm_Uom:'||p_Pgm_Uom, 50);
1323:
1324: end if;
1325:

Line 1322: hr_utility.set_location('p_Pgm_Uom:'||p_Pgm_Uom, 50);

1318: hr_utility.set_location('p_Dflt_Pgm_Flag:'||p_Dflt_Pgm_Flag, 30);
1319: hr_utility.set_location('p_pgm_Stat_cd:'||p_pgm_Stat_cd, 35);
1320: hr_utility.set_location('p_Use_Prog_Points_Flag:'||p_Use_Prog_Points_Flag, 40);
1321: hr_utility.set_location('p_Acty_Ref_Perd_Cd:'||p_Acty_Ref_Perd_Cd, 45);
1322: hr_utility.set_location('p_Pgm_Uom:'||p_Pgm_Uom, 50);
1323:
1324: end if;
1325:
1326: l_pgm_type_is_gsp := is_pgm_type_gsp(p_Pgm_Id => p_pgm_id,

Line 1331: hr_utility.set_location('Is PGM Type is GSP (Y/N):'||l_pgm_type_is_gsp, 85);

1327: p_Business_Group_Id => p_business_group_id,
1328: p_Effective_Date => p_effective_date );
1329:
1330: if g_debug then
1331: hr_utility.set_location('Is PGM Type is GSP (Y/N):'||l_pgm_type_is_gsp, 85);
1332: end if;
1333:
1334: If l_pgm_type_is_gsp = 'Y' Then
1335:

Line 1342: hr_utility.set_location(' PGM Insert Validations ', 90);

1338: --
1339: If p_dml_operation = 'I' then
1340:
1341: if g_debug then
1342: hr_utility.set_location(' PGM Insert Validations ', 90);
1343: end if;
1344: pqh_gsp_ben_validations.pgm_ins_val( p_Pgm_Id => p_pgm_id,
1345: p_Business_Group_Id => p_business_group_id,
1346: p_Short_Name => p_short_name,

Line 1357: hr_utility.set_location(' PGM Update Validations ', 95);

1353: --
1354: If p_dml_operation = 'U' then
1355:
1356: if g_debug then
1357: hr_utility.set_location(' PGM Update Validations ', 95);
1358: end if;
1359: pqh_gsp_ben_validations.pgm_upd_val( p_Pgm_Id => p_pgm_id,
1360: p_Business_Group_Id => p_business_group_id,
1361: p_Short_Name => p_short_name,

Line 1379: hr_utility.set_location(' PGM Delete Validations ', 100);

1375:
1376: If p_dml_operation = 'D' then
1377:
1378: if g_debug then
1379: hr_utility.set_location(' PGM Delete Validations ', 100);
1380: end if;
1381: pqh_gsp_ben_validations.pgm_del_val( p_Pgm_Id => p_pgm_id,
1382: p_Business_Group_Id => p_business_group_id,
1383: p_Effective_Date => p_effective_date);

Line 1389: hr_utility.set_location('Leaving'||l_proc,150);

1385:
1386: End If;
1387:
1388: if g_debug then
1389: hr_utility.set_location('Leaving'||l_proc,150);
1390: end if;
1391:
1392: end pgm_validations;
1393:

Line 1407: hr_utility.set_location('Entering'||l_proc,10);

1403: */
1404: l_proc varchar2(72) := g_package||'pl_ins_val';
1405: Begin
1406: if g_debug then
1407: hr_utility.set_location('Entering'||l_proc,10);
1408: end if;
1409:
1410: if g_debug then
1411: hr_utility.set_location('Leaving'||l_proc,100);

Line 1411: hr_utility.set_location('Leaving'||l_proc,100);

1407: hr_utility.set_location('Entering'||l_proc,10);
1408: end if;
1409:
1410: if g_debug then
1411: hr_utility.set_location('Leaving'||l_proc,100);
1412: end if;
1413:
1414: end pl_ins_val;
1415:

Line 1473: hr_utility.set_location('Entering'||l_proc,5);

1469:
1470:
1471: Begin
1472: if g_debug then
1473: hr_utility.set_location('Entering'||l_proc,5);
1474: hr_utility.set_location('p_pl_id'||p_pl_id,10);
1475: hr_utility.set_location('p_effective_date'||p_effective_date,15);
1476: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
1477: hr_utility.set_location('p_pl_Typ_Id'||p_pl_Typ_Id,25);

Line 1474: hr_utility.set_location('p_pl_id'||p_pl_id,10);

1470:
1471: Begin
1472: if g_debug then
1473: hr_utility.set_location('Entering'||l_proc,5);
1474: hr_utility.set_location('p_pl_id'||p_pl_id,10);
1475: hr_utility.set_location('p_effective_date'||p_effective_date,15);
1476: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
1477: hr_utility.set_location('p_pl_Typ_Id'||p_pl_Typ_Id,25);
1478: hr_utility.set_location('Old pl_Typ_Id'||ben_pln_shd.g_old_rec.PL_TYP_ID,30);

Line 1475: hr_utility.set_location('p_effective_date'||p_effective_date,15);

1471: Begin
1472: if g_debug then
1473: hr_utility.set_location('Entering'||l_proc,5);
1474: hr_utility.set_location('p_pl_id'||p_pl_id,10);
1475: hr_utility.set_location('p_effective_date'||p_effective_date,15);
1476: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
1477: hr_utility.set_location('p_pl_Typ_Id'||p_pl_Typ_Id,25);
1478: hr_utility.set_location('Old pl_Typ_Id'||ben_pln_shd.g_old_rec.PL_TYP_ID,30);
1479: hr_utility.set_location('p_Mapping_Table_PK_ID'||p_Mapping_Table_PK_ID,35);

Line 1476: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);

1472: if g_debug then
1473: hr_utility.set_location('Entering'||l_proc,5);
1474: hr_utility.set_location('p_pl_id'||p_pl_id,10);
1475: hr_utility.set_location('p_effective_date'||p_effective_date,15);
1476: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
1477: hr_utility.set_location('p_pl_Typ_Id'||p_pl_Typ_Id,25);
1478: hr_utility.set_location('Old pl_Typ_Id'||ben_pln_shd.g_old_rec.PL_TYP_ID,30);
1479: hr_utility.set_location('p_Mapping_Table_PK_ID'||p_Mapping_Table_PK_ID,35);
1480: hr_utility.set_location('Old Mapping_Table_PK_ID'||ben_pln_shd.g_old_rec.Mapping_Table_PK_ID,40);

Line 1477: hr_utility.set_location('p_pl_Typ_Id'||p_pl_Typ_Id,25);

1473: hr_utility.set_location('Entering'||l_proc,5);
1474: hr_utility.set_location('p_pl_id'||p_pl_id,10);
1475: hr_utility.set_location('p_effective_date'||p_effective_date,15);
1476: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
1477: hr_utility.set_location('p_pl_Typ_Id'||p_pl_Typ_Id,25);
1478: hr_utility.set_location('Old pl_Typ_Id'||ben_pln_shd.g_old_rec.PL_TYP_ID,30);
1479: hr_utility.set_location('p_Mapping_Table_PK_ID'||p_Mapping_Table_PK_ID,35);
1480: hr_utility.set_location('Old Mapping_Table_PK_ID'||ben_pln_shd.g_old_rec.Mapping_Table_PK_ID,40);
1481: hr_utility.set_location('p_pl_stat_cd'||p_pl_stat_cd,45);

Line 1478: hr_utility.set_location('Old pl_Typ_Id'||ben_pln_shd.g_old_rec.PL_TYP_ID,30);

1474: hr_utility.set_location('p_pl_id'||p_pl_id,10);
1475: hr_utility.set_location('p_effective_date'||p_effective_date,15);
1476: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
1477: hr_utility.set_location('p_pl_Typ_Id'||p_pl_Typ_Id,25);
1478: hr_utility.set_location('Old pl_Typ_Id'||ben_pln_shd.g_old_rec.PL_TYP_ID,30);
1479: hr_utility.set_location('p_Mapping_Table_PK_ID'||p_Mapping_Table_PK_ID,35);
1480: hr_utility.set_location('Old Mapping_Table_PK_ID'||ben_pln_shd.g_old_rec.Mapping_Table_PK_ID,40);
1481: hr_utility.set_location('p_pl_stat_cd'||p_pl_stat_cd,45);
1482: hr_utility.set_location('Old pl_stat_cd'||ben_pln_shd.g_old_rec.pl_stat_cd,60);

Line 1479: hr_utility.set_location('p_Mapping_Table_PK_ID'||p_Mapping_Table_PK_ID,35);

1475: hr_utility.set_location('p_effective_date'||p_effective_date,15);
1476: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
1477: hr_utility.set_location('p_pl_Typ_Id'||p_pl_Typ_Id,25);
1478: hr_utility.set_location('Old pl_Typ_Id'||ben_pln_shd.g_old_rec.PL_TYP_ID,30);
1479: hr_utility.set_location('p_Mapping_Table_PK_ID'||p_Mapping_Table_PK_ID,35);
1480: hr_utility.set_location('Old Mapping_Table_PK_ID'||ben_pln_shd.g_old_rec.Mapping_Table_PK_ID,40);
1481: hr_utility.set_location('p_pl_stat_cd'||p_pl_stat_cd,45);
1482: hr_utility.set_location('Old pl_stat_cd'||ben_pln_shd.g_old_rec.pl_stat_cd,60);
1483: end if;

Line 1480: hr_utility.set_location('Old Mapping_Table_PK_ID'||ben_pln_shd.g_old_rec.Mapping_Table_PK_ID,40);

1476: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
1477: hr_utility.set_location('p_pl_Typ_Id'||p_pl_Typ_Id,25);
1478: hr_utility.set_location('Old pl_Typ_Id'||ben_pln_shd.g_old_rec.PL_TYP_ID,30);
1479: hr_utility.set_location('p_Mapping_Table_PK_ID'||p_Mapping_Table_PK_ID,35);
1480: hr_utility.set_location('Old Mapping_Table_PK_ID'||ben_pln_shd.g_old_rec.Mapping_Table_PK_ID,40);
1481: hr_utility.set_location('p_pl_stat_cd'||p_pl_stat_cd,45);
1482: hr_utility.set_location('Old pl_stat_cd'||ben_pln_shd.g_old_rec.pl_stat_cd,60);
1483: end if;
1484:

Line 1481: hr_utility.set_location('p_pl_stat_cd'||p_pl_stat_cd,45);

1477: hr_utility.set_location('p_pl_Typ_Id'||p_pl_Typ_Id,25);
1478: hr_utility.set_location('Old pl_Typ_Id'||ben_pln_shd.g_old_rec.PL_TYP_ID,30);
1479: hr_utility.set_location('p_Mapping_Table_PK_ID'||p_Mapping_Table_PK_ID,35);
1480: hr_utility.set_location('Old Mapping_Table_PK_ID'||ben_pln_shd.g_old_rec.Mapping_Table_PK_ID,40);
1481: hr_utility.set_location('p_pl_stat_cd'||p_pl_stat_cd,45);
1482: hr_utility.set_location('Old pl_stat_cd'||ben_pln_shd.g_old_rec.pl_stat_cd,60);
1483: end if;
1484:
1485: l_exists := chk_pl_exists_in_grdldr(p_pl_id => p_pl_id,

Line 1482: hr_utility.set_location('Old pl_stat_cd'||ben_pln_shd.g_old_rec.pl_stat_cd,60);

1478: hr_utility.set_location('Old pl_Typ_Id'||ben_pln_shd.g_old_rec.PL_TYP_ID,30);
1479: hr_utility.set_location('p_Mapping_Table_PK_ID'||p_Mapping_Table_PK_ID,35);
1480: hr_utility.set_location('Old Mapping_Table_PK_ID'||ben_pln_shd.g_old_rec.Mapping_Table_PK_ID,40);
1481: hr_utility.set_location('p_pl_stat_cd'||p_pl_stat_cd,45);
1482: hr_utility.set_location('Old pl_stat_cd'||ben_pln_shd.g_old_rec.pl_stat_cd,60);
1483: end if;
1484:
1485: l_exists := chk_pl_exists_in_grdldr(p_pl_id => p_pl_id,
1486: p_effective_date => p_effective_date,

Line 1491: hr_utility.set_location('Plan Exists in Program : '||l_exists,90);

1487: p_Business_Group_Id => p_Business_Group_Id);
1488: --
1489: --
1490: if g_debug then
1491: hr_utility.set_location('Plan Exists in Program : '||l_exists,90);
1492: end if;
1493: If l_exists = 'Y' Then
1494:
1495: Open csr_pl_type(ben_pln_shd.g_old_rec.PL_TYP_ID);

Line 1501: hr_utility.set_location('Old Plan Type : '||l_exist_pl_type_cd,100);

1497: Close csr_pl_type;
1498:
1499:
1500: if g_debug then
1501: hr_utility.set_location('Old Plan Type : '||l_exist_pl_type_cd,100);
1502: end if;
1503:
1504: If (l_exist_pl_type_cd = 'GSP' ) Then
1505:

Line 1514: hr_utility.set_location('New Plan Type : '||l_new_pl_type_cd,145);

1510: Open csr_pl_type(p_pl_Typ_Id);
1511: Fetch csr_pl_type into l_new_pl_type_cd;
1512: Close csr_pl_type;
1513: if g_debug then
1514: hr_utility.set_location('New Plan Type : '||l_new_pl_type_cd,145);
1515: end if;
1516:
1517:
1518: if g_debug then

Line 1519: hr_utility.set_location('New Plan Type : '||l_new_pl_type_cd,155);

1515: end if;
1516:
1517:
1518: if g_debug then
1519: hr_utility.set_location('New Plan Type : '||l_new_pl_type_cd,155);
1520: end if;
1521: If (l_exist_pl_type_cd <> l_new_pl_type_cd ) Then
1522: hr_utility.set_message(8302,'PQH_GSP_NOT_PL_UPD_PGM_TYPE');
1523: hr_utility.raise_error;

Line 1522: hr_utility.set_message(8302,'PQH_GSP_NOT_PL_UPD_PGM_TYPE');

1518: if g_debug then
1519: hr_utility.set_location('New Plan Type : '||l_new_pl_type_cd,155);
1520: end if;
1521: If (l_exist_pl_type_cd <> l_new_pl_type_cd ) Then
1522: hr_utility.set_message(8302,'PQH_GSP_NOT_PL_UPD_PGM_TYPE');
1523: hr_utility.raise_error;
1524: End If;
1525:
1526: --

Line 1523: hr_utility.raise_error;

1519: hr_utility.set_location('New Plan Type : '||l_new_pl_type_cd,155);
1520: end if;
1521: If (l_exist_pl_type_cd <> l_new_pl_type_cd ) Then
1522: hr_utility.set_message(8302,'PQH_GSP_NOT_PL_UPD_PGM_TYPE');
1523: hr_utility.raise_error;
1524: End If;
1525:
1526: --
1527: -- Cannot Update Status

Line 1531: hr_utility.set_location('Old Plan Status : '||ben_pln_shd.g_old_rec.pl_stat_cd,165);

1527: -- Cannot Update Status
1528: --
1529:
1530: if g_debug then
1531: hr_utility.set_location('Old Plan Status : '||ben_pln_shd.g_old_rec.pl_stat_cd,165);
1532: end if;
1533:
1534:
1535: If (ben_pln_shd.g_old_rec.pl_stat_cd = 'A' And ben_pln_shd.g_old_rec.pl_stat_cd <> p_pl_stat_cd)Then

Line 1536: hr_utility.set_message(8302,'PQH_GSP_NOT_PL_UPD_PGM_STATUS');

1532: end if;
1533:
1534:
1535: If (ben_pln_shd.g_old_rec.pl_stat_cd = 'A' And ben_pln_shd.g_old_rec.pl_stat_cd <> p_pl_stat_cd)Then
1536: hr_utility.set_message(8302,'PQH_GSP_NOT_PL_UPD_PGM_STATUS');
1537: hr_utility.raise_error;
1538: End If;
1539:
1540: --

Line 1537: hr_utility.raise_error;

1533:
1534:
1535: If (ben_pln_shd.g_old_rec.pl_stat_cd = 'A' And ben_pln_shd.g_old_rec.pl_stat_cd <> p_pl_stat_cd)Then
1536: hr_utility.set_message(8302,'PQH_GSP_NOT_PL_UPD_PGM_STATUS');
1537: hr_utility.raise_error;
1538: End If;
1539:
1540: --
1541: -- Cannot Update Grade Id if Employees are placed on Grade

Line 1550: hr_utility.set_location('PLIP Id : '||l_plip_id,175);

1546: Open csr_plip_id;
1547: Fetch csr_plip_id into l_plip_id;
1548: Close csr_plip_id;
1549: if g_debug then
1550: hr_utility.set_location('PLIP Id : '||l_plip_id,175);
1551: end if;
1552:
1553:
1554: if l_plip_id IS NOT NULL Then

Line 1559: hr_utility.set_location('Emp Placements exists (Y/N) : '||l_emp_exists,190);

1555: l_emp_exists := chk_plip_emp_assign(p_plip_id => l_plip_id,
1556: p_effective_date => p_effective_date,
1557: p_business_group_id =>p_Business_Group_Id);
1558: if g_debug then
1559: hr_utility.set_location('Emp Placements exists (Y/N) : '||l_emp_exists,190);
1560: end if;
1561:
1562: if l_emp_exists = 'Y' Then
1563:

Line 1565: hr_utility.set_location('Old Grade Id : '||ben_pln_shd.g_old_rec.Mapping_Table_PK_ID,200);

1561:
1562: if l_emp_exists = 'Y' Then
1563:
1564: if g_debug then
1565: hr_utility.set_location('Old Grade Id : '||ben_pln_shd.g_old_rec.Mapping_Table_PK_ID,200);
1566: end if;
1567:
1568:
1569: If (ben_pln_shd.g_old_rec.Mapping_Table_PK_ID <> p_Mapping_Table_PK_ID)Then

Line 1570: hr_utility.set_message(8302,'PQH_GSP_NOT_PL_UPD_EMP_GRD_ID');

1566: end if;
1567:
1568:
1569: If (ben_pln_shd.g_old_rec.Mapping_Table_PK_ID <> p_Mapping_Table_PK_ID)Then
1570: hr_utility.set_message(8302,'PQH_GSP_NOT_PL_UPD_EMP_GRD_ID');
1571: hr_utility.raise_error;
1572: End If;
1573: end if;
1574:

Line 1571: hr_utility.raise_error;

1567:
1568:
1569: If (ben_pln_shd.g_old_rec.Mapping_Table_PK_ID <> p_Mapping_Table_PK_ID)Then
1570: hr_utility.set_message(8302,'PQH_GSP_NOT_PL_UPD_EMP_GRD_ID');
1571: hr_utility.raise_error;
1572: End If;
1573: end if;
1574:
1575: end if;-- plip id is not null

Line 1582: hr_utility.set_location('Leaving'||l_proc,300);

1578:
1579: End If; -- Pl Exists in PGM
1580:
1581: if g_debug then
1582: hr_utility.set_location('Leaving'||l_proc,300);
1583: end if;
1584:
1585: end pl_upd_val;
1586:

Line 1599: hr_utility.set_location('Entering'||l_proc,10);

1595: */
1596: l_proc varchar2(72) := g_package||'pl_del_val';
1597: Begin
1598: if g_debug then
1599: hr_utility.set_location('Entering'||l_proc,10);
1600: end if;
1601:
1602: if g_debug then
1603: hr_utility.set_location('Leaving'||l_proc,100);

Line 1603: hr_utility.set_location('Leaving'||l_proc,100);

1599: hr_utility.set_location('Entering'||l_proc,10);
1600: end if;
1601:
1602: if g_debug then
1603: hr_utility.set_location('Leaving'||l_proc,100);
1604: end if;
1605:
1606: end pl_del_val;
1607:

Line 1628: hr_utility.set_location('Entering'||l_proc,5);

1624: -- there should not be any assignment on the grade linked if getting deleted or disabled
1625: -- this should be the only plan linked to the grade
1626: -- etc
1627: if g_debug then
1628: hr_utility.set_location('Entering'||l_proc,5);
1629: hr_utility.set_location('p_pl_id'||p_pl_id,10);
1630: hr_utility.set_location('p_dml_operation'||p_dml_operation,11);
1631: hr_utility.set_location('p_effective_date'||p_effective_date,15);
1632: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);

Line 1629: hr_utility.set_location('p_pl_id'||p_pl_id,10);

1625: -- this should be the only plan linked to the grade
1626: -- etc
1627: if g_debug then
1628: hr_utility.set_location('Entering'||l_proc,5);
1629: hr_utility.set_location('p_pl_id'||p_pl_id,10);
1630: hr_utility.set_location('p_dml_operation'||p_dml_operation,11);
1631: hr_utility.set_location('p_effective_date'||p_effective_date,15);
1632: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
1633: hr_utility.set_location('p_pl_Typ_Id'||p_pl_Typ_Id,24);

Line 1630: hr_utility.set_location('p_dml_operation'||p_dml_operation,11);

1626: -- etc
1627: if g_debug then
1628: hr_utility.set_location('Entering'||l_proc,5);
1629: hr_utility.set_location('p_pl_id'||p_pl_id,10);
1630: hr_utility.set_location('p_dml_operation'||p_dml_operation,11);
1631: hr_utility.set_location('p_effective_date'||p_effective_date,15);
1632: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
1633: hr_utility.set_location('p_pl_Typ_Id'||p_pl_Typ_Id,24);
1634: hr_utility.set_location('p_Mapping_Table_PK_ID'||p_Mapping_Table_PK_ID,26);

Line 1631: hr_utility.set_location('p_effective_date'||p_effective_date,15);

1627: if g_debug then
1628: hr_utility.set_location('Entering'||l_proc,5);
1629: hr_utility.set_location('p_pl_id'||p_pl_id,10);
1630: hr_utility.set_location('p_dml_operation'||p_dml_operation,11);
1631: hr_utility.set_location('p_effective_date'||p_effective_date,15);
1632: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
1633: hr_utility.set_location('p_pl_Typ_Id'||p_pl_Typ_Id,24);
1634: hr_utility.set_location('p_Mapping_Table_PK_ID'||p_Mapping_Table_PK_ID,26);
1635: hr_utility.set_location('p_pl_stat_cd'||p_pl_stat_cd,28);

Line 1632: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);

1628: hr_utility.set_location('Entering'||l_proc,5);
1629: hr_utility.set_location('p_pl_id'||p_pl_id,10);
1630: hr_utility.set_location('p_dml_operation'||p_dml_operation,11);
1631: hr_utility.set_location('p_effective_date'||p_effective_date,15);
1632: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
1633: hr_utility.set_location('p_pl_Typ_Id'||p_pl_Typ_Id,24);
1634: hr_utility.set_location('p_Mapping_Table_PK_ID'||p_Mapping_Table_PK_ID,26);
1635: hr_utility.set_location('p_pl_stat_cd'||p_pl_stat_cd,28);
1636: end if;

Line 1633: hr_utility.set_location('p_pl_Typ_Id'||p_pl_Typ_Id,24);

1629: hr_utility.set_location('p_pl_id'||p_pl_id,10);
1630: hr_utility.set_location('p_dml_operation'||p_dml_operation,11);
1631: hr_utility.set_location('p_effective_date'||p_effective_date,15);
1632: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
1633: hr_utility.set_location('p_pl_Typ_Id'||p_pl_Typ_Id,24);
1634: hr_utility.set_location('p_Mapping_Table_PK_ID'||p_Mapping_Table_PK_ID,26);
1635: hr_utility.set_location('p_pl_stat_cd'||p_pl_stat_cd,28);
1636: end if;
1637:

Line 1634: hr_utility.set_location('p_Mapping_Table_PK_ID'||p_Mapping_Table_PK_ID,26);

1630: hr_utility.set_location('p_dml_operation'||p_dml_operation,11);
1631: hr_utility.set_location('p_effective_date'||p_effective_date,15);
1632: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
1633: hr_utility.set_location('p_pl_Typ_Id'||p_pl_Typ_Id,24);
1634: hr_utility.set_location('p_Mapping_Table_PK_ID'||p_Mapping_Table_PK_ID,26);
1635: hr_utility.set_location('p_pl_stat_cd'||p_pl_stat_cd,28);
1636: end if;
1637:
1638: If p_dml_operation = 'I' Then

Line 1635: hr_utility.set_location('p_pl_stat_cd'||p_pl_stat_cd,28);

1631: hr_utility.set_location('p_effective_date'||p_effective_date,15);
1632: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
1633: hr_utility.set_location('p_pl_Typ_Id'||p_pl_Typ_Id,24);
1634: hr_utility.set_location('p_Mapping_Table_PK_ID'||p_Mapping_Table_PK_ID,26);
1635: hr_utility.set_location('p_pl_stat_cd'||p_pl_stat_cd,28);
1636: end if;
1637:
1638: If p_dml_operation = 'I' Then
1639: if g_debug then

Line 1640: hr_utility.set_location('Plan Insert Validations',40);

1636: end if;
1637:
1638: If p_dml_operation = 'I' Then
1639: if g_debug then
1640: hr_utility.set_location('Plan Insert Validations',40);
1641: end if;
1642: pl_ins_val(p_pl_id => p_pl_id,
1643: p_effective_date => p_effective_date);
1644: end if;

Line 1648: hr_utility.set_location('Plan Update Validations',45);

1644: end if;
1645:
1646: If p_dml_operation = 'U' Then
1647: if g_debug then
1648: hr_utility.set_location('Plan Update Validations',45);
1649: end if;
1650: pl_upd_val(p_pl_id => p_pl_id,
1651: p_effective_date => p_effective_date,
1652: p_Business_Group_Id => p_Business_Group_Id,

Line 1660: hr_utility.set_location('Plan Delete Validations',50);

1656: end if;
1657:
1658: If p_dml_operation = 'D' Then
1659: if g_debug then
1660: hr_utility.set_location('Plan Delete Validations',50);
1661: end if;
1662: pl_del_val(p_pl_id => p_pl_id,
1663: p_effective_date => p_effective_date);
1664: end if;

Line 1667: hr_utility.set_location('Leaving'||l_proc,100);

1663: p_effective_date => p_effective_date);
1664: end if;
1665:
1666: if g_debug then
1667: hr_utility.set_location('Leaving'||l_proc,100);
1668: end if;
1669:
1670: end pl_validations;
1671:

Line 1685: hr_utility.set_location('Entering'||l_proc,5);

1681: */
1682: l_proc varchar2(72) := g_package||'plip_ins_val';
1683: Begin
1684: if g_debug then
1685: hr_utility.set_location('Entering'||l_proc,5);
1686: hr_utility.set_location('p_plip_id'||p_plip_id,10);
1687: hr_utility.set_location('p_effective_date'||p_effective_date,15);
1688: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
1689: end if;

Line 1686: hr_utility.set_location('p_plip_id'||p_plip_id,10);

1682: l_proc varchar2(72) := g_package||'plip_ins_val';
1683: Begin
1684: if g_debug then
1685: hr_utility.set_location('Entering'||l_proc,5);
1686: hr_utility.set_location('p_plip_id'||p_plip_id,10);
1687: hr_utility.set_location('p_effective_date'||p_effective_date,15);
1688: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
1689: end if;
1690:

Line 1687: hr_utility.set_location('p_effective_date'||p_effective_date,15);

1683: Begin
1684: if g_debug then
1685: hr_utility.set_location('Entering'||l_proc,5);
1686: hr_utility.set_location('p_plip_id'||p_plip_id,10);
1687: hr_utility.set_location('p_effective_date'||p_effective_date,15);
1688: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
1689: end if;
1690:
1691: if g_debug then

Line 1688: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);

1684: if g_debug then
1685: hr_utility.set_location('Entering'||l_proc,5);
1686: hr_utility.set_location('p_plip_id'||p_plip_id,10);
1687: hr_utility.set_location('p_effective_date'||p_effective_date,15);
1688: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
1689: end if;
1690:
1691: if g_debug then
1692: hr_utility.set_location('Leaving'||l_proc,100);

Line 1692: hr_utility.set_location('Leaving'||l_proc,100);

1688: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
1689: end if;
1690:
1691: if g_debug then
1692: hr_utility.set_location('Leaving'||l_proc,100);
1693: end if;
1694:
1695: end plip_ins_val;
1696:

Line 1718: hr_utility.set_location('Entering'||l_proc,5);

1714:
1715:
1716: Begin
1717: if g_debug then
1718: hr_utility.set_location('Entering'||l_proc,5);
1719: hr_utility.set_location('p_plip_id'||p_plip_id,10);
1720: hr_utility.set_location('p_effective_date'||p_effective_date,15);
1721: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
1722: hr_utility.set_location('p_Plip_Stat_Cd'||p_Plip_Stat_Cd,20);

Line 1719: hr_utility.set_location('p_plip_id'||p_plip_id,10);

1715:
1716: Begin
1717: if g_debug then
1718: hr_utility.set_location('Entering'||l_proc,5);
1719: hr_utility.set_location('p_plip_id'||p_plip_id,10);
1720: hr_utility.set_location('p_effective_date'||p_effective_date,15);
1721: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
1722: hr_utility.set_location('p_Plip_Stat_Cd'||p_Plip_Stat_Cd,20);
1723: hr_utility.set_location('Old Plip_Stat_Cd'||ben_cpp_shd.g_old_rec.PLIP_STAT_CD,25);

Line 1720: hr_utility.set_location('p_effective_date'||p_effective_date,15);

1716: Begin
1717: if g_debug then
1718: hr_utility.set_location('Entering'||l_proc,5);
1719: hr_utility.set_location('p_plip_id'||p_plip_id,10);
1720: hr_utility.set_location('p_effective_date'||p_effective_date,15);
1721: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
1722: hr_utility.set_location('p_Plip_Stat_Cd'||p_Plip_Stat_Cd,20);
1723: hr_utility.set_location('Old Plip_Stat_Cd'||ben_cpp_shd.g_old_rec.PLIP_STAT_CD,25);
1724: end if;

Line 1721: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);

1717: if g_debug then
1718: hr_utility.set_location('Entering'||l_proc,5);
1719: hr_utility.set_location('p_plip_id'||p_plip_id,10);
1720: hr_utility.set_location('p_effective_date'||p_effective_date,15);
1721: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
1722: hr_utility.set_location('p_Plip_Stat_Cd'||p_Plip_Stat_Cd,20);
1723: hr_utility.set_location('Old Plip_Stat_Cd'||ben_cpp_shd.g_old_rec.PLIP_STAT_CD,25);
1724: end if;
1725:

Line 1722: hr_utility.set_location('p_Plip_Stat_Cd'||p_Plip_Stat_Cd,20);

1718: hr_utility.set_location('Entering'||l_proc,5);
1719: hr_utility.set_location('p_plip_id'||p_plip_id,10);
1720: hr_utility.set_location('p_effective_date'||p_effective_date,15);
1721: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
1722: hr_utility.set_location('p_Plip_Stat_Cd'||p_Plip_Stat_Cd,20);
1723: hr_utility.set_location('Old Plip_Stat_Cd'||ben_cpp_shd.g_old_rec.PLIP_STAT_CD,25);
1724: end if;
1725:
1726: -- Check Emp Placements Exists on PLIP Rec

Line 1723: hr_utility.set_location('Old Plip_Stat_Cd'||ben_cpp_shd.g_old_rec.PLIP_STAT_CD,25);

1719: hr_utility.set_location('p_plip_id'||p_plip_id,10);
1720: hr_utility.set_location('p_effective_date'||p_effective_date,15);
1721: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
1722: hr_utility.set_location('p_Plip_Stat_Cd'||p_Plip_Stat_Cd,20);
1723: hr_utility.set_location('Old Plip_Stat_Cd'||ben_cpp_shd.g_old_rec.PLIP_STAT_CD,25);
1724: end if;
1725:
1726: -- Check Emp Placements Exists on PLIP Rec
1727:

Line 1734: hr_utility.set_location('Emp Placements Exists on PLIP Rec (Y/N) :'||l_exists,30);

1730: l_exists := chk_plip_emp_assign(p_plip_id => p_plip_id,
1731: p_effective_date => p_effective_date ,
1732: p_business_group_id => p_business_group_id);
1733: if g_debug then
1734: hr_utility.set_location('Emp Placements Exists on PLIP Rec (Y/N) :'||l_exists,30);
1735: end if;
1736: If l_exists = 'Y' Then
1737: --
1738:

Line 1741: hr_utility.set_location('Cannot Change Status ',55);

1737: --
1738:
1739:
1740: if (ben_cpp_shd.g_old_rec.PLIP_STAT_CD = 'A' And ben_cpp_shd.g_old_rec.PLIP_STAT_CD <> p_Plip_Stat_Cd) Then
1741: hr_utility.set_location('Cannot Change Status ',55);
1742: hr_utility.set_message(8302,'PQH_GSP_NOT_UPD_PLIP_STATUS');
1743: hr_utility.raise_error;
1744: end if;
1745:

Line 1742: hr_utility.set_message(8302,'PQH_GSP_NOT_UPD_PLIP_STATUS');

1738:
1739:
1740: if (ben_cpp_shd.g_old_rec.PLIP_STAT_CD = 'A' And ben_cpp_shd.g_old_rec.PLIP_STAT_CD <> p_Plip_Stat_Cd) Then
1741: hr_utility.set_location('Cannot Change Status ',55);
1742: hr_utility.set_message(8302,'PQH_GSP_NOT_UPD_PLIP_STATUS');
1743: hr_utility.raise_error;
1744: end if;
1745:
1746: End If;

Line 1743: hr_utility.raise_error;

1739:
1740: if (ben_cpp_shd.g_old_rec.PLIP_STAT_CD = 'A' And ben_cpp_shd.g_old_rec.PLIP_STAT_CD <> p_Plip_Stat_Cd) Then
1741: hr_utility.set_location('Cannot Change Status ',55);
1742: hr_utility.set_message(8302,'PQH_GSP_NOT_UPD_PLIP_STATUS');
1743: hr_utility.raise_error;
1744: end if;
1745:
1746: End If;
1747:

Line 1749: hr_utility.set_location('Leaving'||l_proc,100);

1745:
1746: End If;
1747:
1748: if g_debug then
1749: hr_utility.set_location('Leaving'||l_proc,100);
1750: end if;
1751:
1752: end plip_upd_val;
1753:

Line 1770: hr_utility.set_location('Entering'||l_proc,5);

1766: l_exists Varchar2(1) :='N';
1767:
1768: Begin
1769: if g_debug then
1770: hr_utility.set_location('Entering'||l_proc,5);
1771: hr_utility.set_location('p_plip_id'||p_plip_id,10);
1772: hr_utility.set_location('p_effective_date'||p_effective_date,15);
1773: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
1774: end if;

Line 1771: hr_utility.set_location('p_plip_id'||p_plip_id,10);

1767:
1768: Begin
1769: if g_debug then
1770: hr_utility.set_location('Entering'||l_proc,5);
1771: hr_utility.set_location('p_plip_id'||p_plip_id,10);
1772: hr_utility.set_location('p_effective_date'||p_effective_date,15);
1773: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
1774: end if;
1775:

Line 1772: hr_utility.set_location('p_effective_date'||p_effective_date,15);

1768: Begin
1769: if g_debug then
1770: hr_utility.set_location('Entering'||l_proc,5);
1771: hr_utility.set_location('p_plip_id'||p_plip_id,10);
1772: hr_utility.set_location('p_effective_date'||p_effective_date,15);
1773: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
1774: end if;
1775:
1776: -- Check Emp Placements Exists on PLIP Rec if Y then emp exists on PLIP Rec else Not Exists

Line 1773: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);

1769: if g_debug then
1770: hr_utility.set_location('Entering'||l_proc,5);
1771: hr_utility.set_location('p_plip_id'||p_plip_id,10);
1772: hr_utility.set_location('p_effective_date'||p_effective_date,15);
1773: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
1774: end if;
1775:
1776: -- Check Emp Placements Exists on PLIP Rec if Y then emp exists on PLIP Rec else Not Exists
1777:

Line 1783: hr_utility.set_location('Emp Placements Exists on PLIP Rec (Y/N) :'||l_exists,30);

1779: p_effective_date => p_effective_date ,
1780: p_business_group_id => p_business_group_id);
1781:
1782: if g_debug then
1783: hr_utility.set_location('Emp Placements Exists on PLIP Rec (Y/N) :'||l_exists,30);
1784: end if;
1785: If l_exists = 'Y' Then
1786:
1787: if g_debug then

Line 1788: hr_utility.set_location('Emp Placements are exists',50);

1784: end if;
1785: If l_exists = 'Y' Then
1786:
1787: if g_debug then
1788: hr_utility.set_location('Emp Placements are exists',50);
1789: end if;
1790: hr_utility.set_message(8302,'PQH_GSP_NOT_DEL_PLIP');
1791: hr_utility.raise_error;
1792: end if;

Line 1790: hr_utility.set_message(8302,'PQH_GSP_NOT_DEL_PLIP');

1786:
1787: if g_debug then
1788: hr_utility.set_location('Emp Placements are exists',50);
1789: end if;
1790: hr_utility.set_message(8302,'PQH_GSP_NOT_DEL_PLIP');
1791: hr_utility.raise_error;
1792: end if;
1793:
1794: if g_debug then

Line 1791: hr_utility.raise_error;

1787: if g_debug then
1788: hr_utility.set_location('Emp Placements are exists',50);
1789: end if;
1790: hr_utility.set_message(8302,'PQH_GSP_NOT_DEL_PLIP');
1791: hr_utility.raise_error;
1792: end if;
1793:
1794: if g_debug then
1795: hr_utility.set_location('Leaving'||l_proc,100);

Line 1795: hr_utility.set_location('Leaving'||l_proc,100);

1791: hr_utility.raise_error;
1792: end if;
1793:
1794: if g_debug then
1795: hr_utility.set_location('Leaving'||l_proc,100);
1796: end if;
1797: end plip_del_val;
1798:
1799:

Line 1819: hr_utility.set_location('Entering'||l_proc,10);

1815: -- validations to be performed in this routine are
1816: -- there should not be any assignment on the grade linked if getting deleted or
1817: -- disabled etc
1818: if g_debug then
1819: hr_utility.set_location('Entering'||l_proc,10);
1820: hr_utility.set_location('p_plip_id'||p_plip_id,10);
1821: hr_utility.set_location('p_effective_date'||p_effective_date,15);
1822: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
1823: hr_utility.set_location('p_Plip_Stat_Cd'||p_Plip_Stat_Cd,25);

Line 1820: hr_utility.set_location('p_plip_id'||p_plip_id,10);

1816: -- there should not be any assignment on the grade linked if getting deleted or
1817: -- disabled etc
1818: if g_debug then
1819: hr_utility.set_location('Entering'||l_proc,10);
1820: hr_utility.set_location('p_plip_id'||p_plip_id,10);
1821: hr_utility.set_location('p_effective_date'||p_effective_date,15);
1822: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
1823: hr_utility.set_location('p_Plip_Stat_Cd'||p_Plip_Stat_Cd,25);
1824: hr_utility.set_location('Old Plip_Stat_Cd'||ben_cpp_shd.g_old_rec.PLIP_STAT_CD,30);

Line 1821: hr_utility.set_location('p_effective_date'||p_effective_date,15);

1817: -- disabled etc
1818: if g_debug then
1819: hr_utility.set_location('Entering'||l_proc,10);
1820: hr_utility.set_location('p_plip_id'||p_plip_id,10);
1821: hr_utility.set_location('p_effective_date'||p_effective_date,15);
1822: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
1823: hr_utility.set_location('p_Plip_Stat_Cd'||p_Plip_Stat_Cd,25);
1824: hr_utility.set_location('Old Plip_Stat_Cd'||ben_cpp_shd.g_old_rec.PLIP_STAT_CD,30);
1825: hr_utility.set_location('p_dml_operation'||p_dml_operation,35);

Line 1822: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);

1818: if g_debug then
1819: hr_utility.set_location('Entering'||l_proc,10);
1820: hr_utility.set_location('p_plip_id'||p_plip_id,10);
1821: hr_utility.set_location('p_effective_date'||p_effective_date,15);
1822: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
1823: hr_utility.set_location('p_Plip_Stat_Cd'||p_Plip_Stat_Cd,25);
1824: hr_utility.set_location('Old Plip_Stat_Cd'||ben_cpp_shd.g_old_rec.PLIP_STAT_CD,30);
1825: hr_utility.set_location('p_dml_operation'||p_dml_operation,35);
1826: end if;

Line 1823: hr_utility.set_location('p_Plip_Stat_Cd'||p_Plip_Stat_Cd,25);

1819: hr_utility.set_location('Entering'||l_proc,10);
1820: hr_utility.set_location('p_plip_id'||p_plip_id,10);
1821: hr_utility.set_location('p_effective_date'||p_effective_date,15);
1822: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
1823: hr_utility.set_location('p_Plip_Stat_Cd'||p_Plip_Stat_Cd,25);
1824: hr_utility.set_location('Old Plip_Stat_Cd'||ben_cpp_shd.g_old_rec.PLIP_STAT_CD,30);
1825: hr_utility.set_location('p_dml_operation'||p_dml_operation,35);
1826: end if;
1827:

Line 1824: hr_utility.set_location('Old Plip_Stat_Cd'||ben_cpp_shd.g_old_rec.PLIP_STAT_CD,30);

1820: hr_utility.set_location('p_plip_id'||p_plip_id,10);
1821: hr_utility.set_location('p_effective_date'||p_effective_date,15);
1822: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
1823: hr_utility.set_location('p_Plip_Stat_Cd'||p_Plip_Stat_Cd,25);
1824: hr_utility.set_location('Old Plip_Stat_Cd'||ben_cpp_shd.g_old_rec.PLIP_STAT_CD,30);
1825: hr_utility.set_location('p_dml_operation'||p_dml_operation,35);
1826: end if;
1827:
1828:

Line 1825: hr_utility.set_location('p_dml_operation'||p_dml_operation,35);

1821: hr_utility.set_location('p_effective_date'||p_effective_date,15);
1822: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
1823: hr_utility.set_location('p_Plip_Stat_Cd'||p_Plip_Stat_Cd,25);
1824: hr_utility.set_location('Old Plip_Stat_Cd'||ben_cpp_shd.g_old_rec.PLIP_STAT_CD,30);
1825: hr_utility.set_location('p_dml_operation'||p_dml_operation,35);
1826: end if;
1827:
1828:
1829:

Line 1833: hr_utility.set_location('PLIP Insert Validations',45);

1829:
1830:
1831: If p_dml_operation = 'I' Then
1832: if g_debug then
1833: hr_utility.set_location('PLIP Insert Validations',45);
1834: end if;
1835:
1836: plip_ins_val( p_plip_id => p_plip_id,
1837: p_effective_date => p_effective_date,

Line 1843: hr_utility.set_location('PLIP Update Validations',55);

1839: end if;
1840:
1841: If p_dml_operation = 'U' Then
1842: if g_debug then
1843: hr_utility.set_location('PLIP Update Validations',55);
1844: end if;
1845: plip_upd_val( p_plip_id => p_plip_id,
1846: p_effective_date => p_effective_date,
1847: p_business_group_id => p_business_group_id,

Line 1854: hr_utility.set_location('PLIP Delete Validations',65);

1850: end if;
1851:
1852: If p_dml_operation = 'D' Then
1853: if g_debug then
1854: hr_utility.set_location('PLIP Delete Validations',65);
1855: end if;
1856: plip_del_val( p_plip_id => p_plip_id,
1857: p_effective_date => p_effective_date,
1858: p_business_group_id => p_business_group_id);

Line 1864: hr_utility.set_location('Leaving'||l_proc,100);

1860:
1861:
1862:
1863: if g_debug then
1864: hr_utility.set_location('Leaving'||l_proc,100);
1865: end if;
1866:
1867: end plip_validations;
1868:

Line 1883: hr_utility.set_location('Entering'||l_proc,5);

1879: */
1880: l_proc varchar2(72) := g_package||'opt_ins_val';
1881: Begin
1882: if g_debug then
1883: hr_utility.set_location('Entering'||l_proc,5);
1884: hr_utility.set_location('p_opt_id'||p_opt_id,10);
1885: hr_utility.set_location('p_effective_date'||p_effective_date,15);
1886: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
1887: end if;

Line 1884: hr_utility.set_location('p_opt_id'||p_opt_id,10);

1880: l_proc varchar2(72) := g_package||'opt_ins_val';
1881: Begin
1882: if g_debug then
1883: hr_utility.set_location('Entering'||l_proc,5);
1884: hr_utility.set_location('p_opt_id'||p_opt_id,10);
1885: hr_utility.set_location('p_effective_date'||p_effective_date,15);
1886: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
1887: end if;
1888:

Line 1885: hr_utility.set_location('p_effective_date'||p_effective_date,15);

1881: Begin
1882: if g_debug then
1883: hr_utility.set_location('Entering'||l_proc,5);
1884: hr_utility.set_location('p_opt_id'||p_opt_id,10);
1885: hr_utility.set_location('p_effective_date'||p_effective_date,15);
1886: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
1887: end if;
1888:
1889: if g_debug then

Line 1886: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);

1882: if g_debug then
1883: hr_utility.set_location('Entering'||l_proc,5);
1884: hr_utility.set_location('p_opt_id'||p_opt_id,10);
1885: hr_utility.set_location('p_effective_date'||p_effective_date,15);
1886: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
1887: end if;
1888:
1889: if g_debug then
1890: hr_utility.set_location('Leaving'||l_proc,100);

Line 1890: hr_utility.set_location('Leaving'||l_proc,100);

1886: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
1887: end if;
1888:
1889: if g_debug then
1890: hr_utility.set_location('Leaving'||l_proc,100);
1891: end if;
1892:
1893: end opt_ins_val;
1894:

Line 1932: hr_utility.set_location('Entering'||l_proc,5);

1928: And OIPL_STAT_CD = 'A';
1929:
1930: Begin
1931: if g_debug then
1932: hr_utility.set_location('Entering'||l_proc,5);
1933: hr_utility.set_location('p_opt_id'||p_opt_id,10);
1934: hr_utility.set_location('p_effective_date'||p_effective_date,15);
1935: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
1936: hr_utility.set_location('p_mapping_table_pk_id'||p_mapping_table_pk_id,25);

Line 1933: hr_utility.set_location('p_opt_id'||p_opt_id,10);

1929:
1930: Begin
1931: if g_debug then
1932: hr_utility.set_location('Entering'||l_proc,5);
1933: hr_utility.set_location('p_opt_id'||p_opt_id,10);
1934: hr_utility.set_location('p_effective_date'||p_effective_date,15);
1935: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
1936: hr_utility.set_location('p_mapping_table_pk_id'||p_mapping_table_pk_id,25);
1937: hr_utility.set_location('Old mapping_table_pk_id'||ben_opt_shd.g_old_rec.MAPPING_TABLE_PK_ID,30);

Line 1934: hr_utility.set_location('p_effective_date'||p_effective_date,15);

1930: Begin
1931: if g_debug then
1932: hr_utility.set_location('Entering'||l_proc,5);
1933: hr_utility.set_location('p_opt_id'||p_opt_id,10);
1934: hr_utility.set_location('p_effective_date'||p_effective_date,15);
1935: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
1936: hr_utility.set_location('p_mapping_table_pk_id'||p_mapping_table_pk_id,25);
1937: hr_utility.set_location('Old mapping_table_pk_id'||ben_opt_shd.g_old_rec.MAPPING_TABLE_PK_ID,30);
1938: end if;

Line 1935: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);

1931: if g_debug then
1932: hr_utility.set_location('Entering'||l_proc,5);
1933: hr_utility.set_location('p_opt_id'||p_opt_id,10);
1934: hr_utility.set_location('p_effective_date'||p_effective_date,15);
1935: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
1936: hr_utility.set_location('p_mapping_table_pk_id'||p_mapping_table_pk_id,25);
1937: hr_utility.set_location('Old mapping_table_pk_id'||ben_opt_shd.g_old_rec.MAPPING_TABLE_PK_ID,30);
1938: end if;
1939:

Line 1936: hr_utility.set_location('p_mapping_table_pk_id'||p_mapping_table_pk_id,25);

1932: hr_utility.set_location('Entering'||l_proc,5);
1933: hr_utility.set_location('p_opt_id'||p_opt_id,10);
1934: hr_utility.set_location('p_effective_date'||p_effective_date,15);
1935: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
1936: hr_utility.set_location('p_mapping_table_pk_id'||p_mapping_table_pk_id,25);
1937: hr_utility.set_location('Old mapping_table_pk_id'||ben_opt_shd.g_old_rec.MAPPING_TABLE_PK_ID,30);
1938: end if;
1939:
1940:

Line 1937: hr_utility.set_location('Old mapping_table_pk_id'||ben_opt_shd.g_old_rec.MAPPING_TABLE_PK_ID,30);

1933: hr_utility.set_location('p_opt_id'||p_opt_id,10);
1934: hr_utility.set_location('p_effective_date'||p_effective_date,15);
1935: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
1936: hr_utility.set_location('p_mapping_table_pk_id'||p_mapping_table_pk_id,25);
1937: hr_utility.set_location('Old mapping_table_pk_id'||ben_opt_shd.g_old_rec.MAPPING_TABLE_PK_ID,30);
1938: end if;
1939:
1940:
1941: -- Checks OPT has GSP Type and OPT exists in GSP Program

Line 1947: hr_utility.set_location('OPT exists in GSP Program (Y/N) :'||l_opt_exist_in_pgm,55);

1943: p_effective_date => p_effective_date,
1944: p_Business_Group_Id => p_business_group_id);
1945:
1946: if g_debug then
1947: hr_utility.set_location('OPT exists in GSP Program (Y/N) :'||l_opt_exist_in_pgm,55);
1948: end if;
1949:
1950: If (l_opt_exist_in_pgm = 'Y') Then
1951:

Line 1957: hr_utility.set_location('OIPL Id :'||l_oipl_id,60);

1953: Open csr_oipl_id;
1954: Fetch csr_oipl_id into l_oipl_id;
1955: Close csr_oipl_id;
1956: if g_debug then
1957: hr_utility.set_location('OIPL Id :'||l_oipl_id,60);
1958: end if;
1959:
1960: If l_oipl_id IS NOT NULL Then
1961:

Line 1967: hr_utility.set_location('OIPL has Emp Placements (Y/N) :'||l_oipl_has_emp_assign,70);

1963: l_oipl_has_emp_assign := chk_oipl_emp_assign(p_oipl_id => l_oipl_id,
1964: p_effective_date => p_effective_date,
1965: p_business_group_id => p_business_group_id);
1966: if g_debug then
1967: hr_utility.set_location('OIPL has Emp Placements (Y/N) :'||l_oipl_has_emp_assign,70);
1968: end if;
1969:
1970: If l_oipl_has_emp_assign = 'Y' Then
1971:

Line 1974: hr_utility.set_location('Old Point Id :'||ben_opt_shd.g_old_rec.MAPPING_TABLE_PK_ID,80);

1970: If l_oipl_has_emp_assign = 'Y' Then
1971:
1972:
1973: if g_debug then
1974: hr_utility.set_location('Old Point Id :'||ben_opt_shd.g_old_rec.MAPPING_TABLE_PK_ID,80);
1975: end if;
1976:
1977: -- Cannot change Step which is mapped to Option
1978: If (ben_opt_shd.g_old_rec.MAPPING_TABLE_PK_ID <> p_mapping_table_pk_id) Then

Line 1979: hr_utility.set_message(8302,'PQH_GSP_NOT_UPD_OPT_STEP_ID');

1975: end if;
1976:
1977: -- Cannot change Step which is mapped to Option
1978: If (ben_opt_shd.g_old_rec.MAPPING_TABLE_PK_ID <> p_mapping_table_pk_id) Then
1979: hr_utility.set_message(8302,'PQH_GSP_NOT_UPD_OPT_STEP_ID');
1980: hr_utility.raise_error;
1981: End if;
1982:
1983:

Line 1980: hr_utility.raise_error;

1976:
1977: -- Cannot change Step which is mapped to Option
1978: If (ben_opt_shd.g_old_rec.MAPPING_TABLE_PK_ID <> p_mapping_table_pk_id) Then
1979: hr_utility.set_message(8302,'PQH_GSP_NOT_UPD_OPT_STEP_ID');
1980: hr_utility.raise_error;
1981: End if;
1982:
1983:
1984: End if; -- l_oipl_has_emp_assign

Line 1992: hr_utility.set_location('Leaving'||l_proc,100);

1988:
1989: end if; --l_opt_exist_in_pgm
1990:
1991: if g_debug then
1992: hr_utility.set_location('Leaving'||l_proc,100);
1993: end if;
1994:
1995: end opt_upd_val;
1996:

Line 2010: hr_utility.set_location('Entering'||l_proc,5);

2006: */
2007: l_proc varchar2(72) := g_package||'opt_del_val';
2008: Begin
2009: if g_debug then
2010: hr_utility.set_location('Entering'||l_proc,5);
2011: hr_utility.set_location('p_opt_id'||p_opt_id,10);
2012: hr_utility.set_location('p_effective_date'||p_effective_date,15);
2013: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
2014: end if;

Line 2011: hr_utility.set_location('p_opt_id'||p_opt_id,10);

2007: l_proc varchar2(72) := g_package||'opt_del_val';
2008: Begin
2009: if g_debug then
2010: hr_utility.set_location('Entering'||l_proc,5);
2011: hr_utility.set_location('p_opt_id'||p_opt_id,10);
2012: hr_utility.set_location('p_effective_date'||p_effective_date,15);
2013: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
2014: end if;
2015:

Line 2012: hr_utility.set_location('p_effective_date'||p_effective_date,15);

2008: Begin
2009: if g_debug then
2010: hr_utility.set_location('Entering'||l_proc,5);
2011: hr_utility.set_location('p_opt_id'||p_opt_id,10);
2012: hr_utility.set_location('p_effective_date'||p_effective_date,15);
2013: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
2014: end if;
2015:
2016: if g_debug then

Line 2013: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);

2009: if g_debug then
2010: hr_utility.set_location('Entering'||l_proc,5);
2011: hr_utility.set_location('p_opt_id'||p_opt_id,10);
2012: hr_utility.set_location('p_effective_date'||p_effective_date,15);
2013: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
2014: end if;
2015:
2016: if g_debug then
2017: hr_utility.set_location('Leaving'||l_proc,100);

Line 2017: hr_utility.set_location('Leaving'||l_proc,100);

2013: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
2014: end if;
2015:
2016: if g_debug then
2017: hr_utility.set_location('Leaving'||l_proc,100);
2018: end if;
2019:
2020: end opt_del_val;
2021:

Line 2040: hr_utility.set_location('Entering'||l_proc,5);

2036: -- there should not be any assignment on the step linked if getting deleted or disabled
2037: -- this should be only option linked to the point
2038: -- etc
2039: if g_debug then
2040: hr_utility.set_location('Entering'||l_proc,5);
2041: hr_utility.set_location('p_opt_id'||p_opt_id,10);
2042: hr_utility.set_location('p_effective_date'||p_effective_date,15);
2043: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
2044: hr_utility.set_location('p_dml_operation'||p_dml_operation,25);

Line 2041: hr_utility.set_location('p_opt_id'||p_opt_id,10);

2037: -- this should be only option linked to the point
2038: -- etc
2039: if g_debug then
2040: hr_utility.set_location('Entering'||l_proc,5);
2041: hr_utility.set_location('p_opt_id'||p_opt_id,10);
2042: hr_utility.set_location('p_effective_date'||p_effective_date,15);
2043: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
2044: hr_utility.set_location('p_dml_operation'||p_dml_operation,25);
2045: hr_utility.set_location('p_mapping_table_pk_id'||p_mapping_table_pk_id,35);

Line 2042: hr_utility.set_location('p_effective_date'||p_effective_date,15);

2038: -- etc
2039: if g_debug then
2040: hr_utility.set_location('Entering'||l_proc,5);
2041: hr_utility.set_location('p_opt_id'||p_opt_id,10);
2042: hr_utility.set_location('p_effective_date'||p_effective_date,15);
2043: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
2044: hr_utility.set_location('p_dml_operation'||p_dml_operation,25);
2045: hr_utility.set_location('p_mapping_table_pk_id'||p_mapping_table_pk_id,35);
2046: hr_utility.set_location('Old mapping_table_pk_id'||ben_opt_shd.g_old_rec.MAPPING_TABLE_PK_ID,40);

Line 2043: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);

2039: if g_debug then
2040: hr_utility.set_location('Entering'||l_proc,5);
2041: hr_utility.set_location('p_opt_id'||p_opt_id,10);
2042: hr_utility.set_location('p_effective_date'||p_effective_date,15);
2043: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
2044: hr_utility.set_location('p_dml_operation'||p_dml_operation,25);
2045: hr_utility.set_location('p_mapping_table_pk_id'||p_mapping_table_pk_id,35);
2046: hr_utility.set_location('Old mapping_table_pk_id'||ben_opt_shd.g_old_rec.MAPPING_TABLE_PK_ID,40);
2047: end if;

Line 2044: hr_utility.set_location('p_dml_operation'||p_dml_operation,25);

2040: hr_utility.set_location('Entering'||l_proc,5);
2041: hr_utility.set_location('p_opt_id'||p_opt_id,10);
2042: hr_utility.set_location('p_effective_date'||p_effective_date,15);
2043: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
2044: hr_utility.set_location('p_dml_operation'||p_dml_operation,25);
2045: hr_utility.set_location('p_mapping_table_pk_id'||p_mapping_table_pk_id,35);
2046: hr_utility.set_location('Old mapping_table_pk_id'||ben_opt_shd.g_old_rec.MAPPING_TABLE_PK_ID,40);
2047: end if;
2048:

Line 2045: hr_utility.set_location('p_mapping_table_pk_id'||p_mapping_table_pk_id,35);

2041: hr_utility.set_location('p_opt_id'||p_opt_id,10);
2042: hr_utility.set_location('p_effective_date'||p_effective_date,15);
2043: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
2044: hr_utility.set_location('p_dml_operation'||p_dml_operation,25);
2045: hr_utility.set_location('p_mapping_table_pk_id'||p_mapping_table_pk_id,35);
2046: hr_utility.set_location('Old mapping_table_pk_id'||ben_opt_shd.g_old_rec.MAPPING_TABLE_PK_ID,40);
2047: end if;
2048:
2049:

Line 2046: hr_utility.set_location('Old mapping_table_pk_id'||ben_opt_shd.g_old_rec.MAPPING_TABLE_PK_ID,40);

2042: hr_utility.set_location('p_effective_date'||p_effective_date,15);
2043: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
2044: hr_utility.set_location('p_dml_operation'||p_dml_operation,25);
2045: hr_utility.set_location('p_mapping_table_pk_id'||p_mapping_table_pk_id,35);
2046: hr_utility.set_location('Old mapping_table_pk_id'||ben_opt_shd.g_old_rec.MAPPING_TABLE_PK_ID,40);
2047: end if;
2048:
2049:
2050: if p_dml_operation = 'I' Then

Line 2052: hr_utility.set_location('Perform OPT Insert Validations',45);

2048:
2049:
2050: if p_dml_operation = 'I' Then
2051: if g_debug then
2052: hr_utility.set_location('Perform OPT Insert Validations',45);
2053: end if;
2054:
2055: opt_ins_val(p_opt_id => p_opt_id,
2056: p_effective_date => p_effective_date,

Line 2063: hr_utility.set_location('Perform OPT Update Validations',50);

2059: end if;
2060:
2061: if p_dml_operation = 'U' Then
2062: if g_debug then
2063: hr_utility.set_location('Perform OPT Update Validations',50);
2064: end if;
2065:
2066: opt_upd_val(p_opt_id => p_opt_id,
2067: p_effective_date => p_effective_date,

Line 2075: hr_utility.set_location('Perform OPT Delete Validations',55);

2071: end if;
2072:
2073: if p_dml_operation = 'D' Then
2074: if g_debug then
2075: hr_utility.set_location('Perform OPT Delete Validations',55);
2076: end if;
2077:
2078: opt_del_val(p_opt_id => p_opt_id,
2079: p_effective_date => p_effective_date,

Line 2086: hr_utility.set_location('Leaving'||l_proc,100);

2082:
2083:
2084:
2085: if g_debug then
2086: hr_utility.set_location('Leaving'||l_proc,100);
2087: end if;
2088:
2089: end opt_validations;
2090:

Line 2103: hr_utility.set_location('Entering'||l_proc,10);

2099: */
2100: l_proc varchar2(72) := g_package||'oipl_ins_val';
2101: Begin
2102: if g_debug then
2103: hr_utility.set_location('Entering'||l_proc,10);
2104: end if;
2105:
2106: if g_debug then
2107: hr_utility.set_location('Leaving'||l_proc,100);

Line 2107: hr_utility.set_location('Leaving'||l_proc,100);

2103: hr_utility.set_location('Entering'||l_proc,10);
2104: end if;
2105:
2106: if g_debug then
2107: hr_utility.set_location('Leaving'||l_proc,100);
2108: end if;
2109:
2110: end oipl_ins_val;
2111:

Line 2133: hr_utility.set_location('Entering'||l_proc,5);

2129: l_oipl_has_gsp_type Varchar2(1) := 'N';
2130:
2131: Begin
2132: if g_debug then
2133: hr_utility.set_location('Entering'||l_proc,5);
2134: hr_utility.set_location('p_oipl_id'||p_oipl_id,10);
2135: hr_utility.set_location('p_effective_date'||p_effective_date,15);
2136: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
2137: hr_utility.set_location('p_oipl_stat_cd'||p_oipl_stat_cd,25);

Line 2134: hr_utility.set_location('p_oipl_id'||p_oipl_id,10);

2130:
2131: Begin
2132: if g_debug then
2133: hr_utility.set_location('Entering'||l_proc,5);
2134: hr_utility.set_location('p_oipl_id'||p_oipl_id,10);
2135: hr_utility.set_location('p_effective_date'||p_effective_date,15);
2136: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
2137: hr_utility.set_location('p_oipl_stat_cd'||p_oipl_stat_cd,25);
2138: end if;

Line 2135: hr_utility.set_location('p_effective_date'||p_effective_date,15);

2131: Begin
2132: if g_debug then
2133: hr_utility.set_location('Entering'||l_proc,5);
2134: hr_utility.set_location('p_oipl_id'||p_oipl_id,10);
2135: hr_utility.set_location('p_effective_date'||p_effective_date,15);
2136: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
2137: hr_utility.set_location('p_oipl_stat_cd'||p_oipl_stat_cd,25);
2138: end if;
2139:

Line 2136: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);

2132: if g_debug then
2133: hr_utility.set_location('Entering'||l_proc,5);
2134: hr_utility.set_location('p_oipl_id'||p_oipl_id,10);
2135: hr_utility.set_location('p_effective_date'||p_effective_date,15);
2136: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
2137: hr_utility.set_location('p_oipl_stat_cd'||p_oipl_stat_cd,25);
2138: end if;
2139:
2140:

Line 2137: hr_utility.set_location('p_oipl_stat_cd'||p_oipl_stat_cd,25);

2133: hr_utility.set_location('Entering'||l_proc,5);
2134: hr_utility.set_location('p_oipl_id'||p_oipl_id,10);
2135: hr_utility.set_location('p_effective_date'||p_effective_date,15);
2136: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
2137: hr_utility.set_location('p_oipl_stat_cd'||p_oipl_stat_cd,25);
2138: end if;
2139:
2140:
2141: l_emp_exists := chk_oipl_emp_assign(p_oipl_id => p_oipl_id,

Line 2146: hr_utility.set_location('Step Has Emp Placements (Y/N) : '||l_emp_exists ,30);

2142: p_effective_date => p_effective_date,
2143: p_business_group_id => p_business_group_id);
2144:
2145: if g_debug then
2146: hr_utility.set_location('Step Has Emp Placements (Y/N) : '||l_emp_exists ,30);
2147: end if;
2148:
2149: l_oipl_has_gsp_type := chk_oipl_has_gsp_type(p_oipl_id => p_oipl_id,
2150: p_effective_date => p_effective_date,

Line 2153: hr_utility.set_location('OIPL has GSP Type (Y/N) : '||l_oipl_has_gsp_type ,40);

2149: l_oipl_has_gsp_type := chk_oipl_has_gsp_type(p_oipl_id => p_oipl_id,
2150: p_effective_date => p_effective_date,
2151: p_business_group_id=> p_business_group_id);
2152: if g_debug then
2153: hr_utility.set_location('OIPL has GSP Type (Y/N) : '||l_oipl_has_gsp_type ,40);
2154: end if;
2155:
2156: if (l_oipl_has_gsp_type = 'Y' And l_emp_exists = 'Y') Then
2157:

Line 2160: hr_utility.set_location('Old OIPL Status : '||ben_cop_shd.g_old_rec.OIPL_STAT_CD,35);

2156: if (l_oipl_has_gsp_type = 'Y' And l_emp_exists = 'Y') Then
2157:
2158:
2159: if g_debug then
2160: hr_utility.set_location('Old OIPL Status : '||ben_cop_shd.g_old_rec.OIPL_STAT_CD,35);
2161: end if;
2162:
2163: if (ben_cop_shd.g_old_rec.OIPL_STAT_CD IS NOT NULL And
2164: (ben_cop_shd.g_old_rec.OIPL_STAT_CD = 'A' And l_status <> p_oipl_stat_cd)) Then

Line 2165: hr_utility.set_message(8302,'PQH_GSP_NOT_UPD_PLIP_STAT');

2161: end if;
2162:
2163: if (ben_cop_shd.g_old_rec.OIPL_STAT_CD IS NOT NULL And
2164: (ben_cop_shd.g_old_rec.OIPL_STAT_CD = 'A' And l_status <> p_oipl_stat_cd)) Then
2165: hr_utility.set_message(8302,'PQH_GSP_NOT_UPD_PLIP_STAT');
2166: hr_utility.raise_error;
2167: End if;
2168:
2169:

Line 2166: hr_utility.raise_error;

2162:
2163: if (ben_cop_shd.g_old_rec.OIPL_STAT_CD IS NOT NULL And
2164: (ben_cop_shd.g_old_rec.OIPL_STAT_CD = 'A' And l_status <> p_oipl_stat_cd)) Then
2165: hr_utility.set_message(8302,'PQH_GSP_NOT_UPD_PLIP_STAT');
2166: hr_utility.raise_error;
2167: End if;
2168:
2169:
2170: end if;

Line 2173: hr_utility.set_location('Leaving'||l_proc,100);

2169:
2170: end if;
2171:
2172: if g_debug then
2173: hr_utility.set_location('Leaving'||l_proc,100);
2174: end if;
2175:
2176: end oipl_upd_val;
2177:

Line 2195: hr_utility.set_location('Entering'||l_proc,5);

2191: l_oipl_has_gsp_type Varchar2(1):= 'N';
2192: Begin
2193:
2194: if g_debug then
2195: hr_utility.set_location('Entering'||l_proc,5);
2196: hr_utility.set_location('p_oipl_id'||p_oipl_id,10);
2197: hr_utility.set_location('p_effective_date'||p_effective_date,15);
2198: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
2199: end if;

Line 2196: hr_utility.set_location('p_oipl_id'||p_oipl_id,10);

2192: Begin
2193:
2194: if g_debug then
2195: hr_utility.set_location('Entering'||l_proc,5);
2196: hr_utility.set_location('p_oipl_id'||p_oipl_id,10);
2197: hr_utility.set_location('p_effective_date'||p_effective_date,15);
2198: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
2199: end if;
2200:

Line 2197: hr_utility.set_location('p_effective_date'||p_effective_date,15);

2193:
2194: if g_debug then
2195: hr_utility.set_location('Entering'||l_proc,5);
2196: hr_utility.set_location('p_oipl_id'||p_oipl_id,10);
2197: hr_utility.set_location('p_effective_date'||p_effective_date,15);
2198: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
2199: end if;
2200:
2201:

Line 2198: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);

2194: if g_debug then
2195: hr_utility.set_location('Entering'||l_proc,5);
2196: hr_utility.set_location('p_oipl_id'||p_oipl_id,10);
2197: hr_utility.set_location('p_effective_date'||p_effective_date,15);
2198: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
2199: end if;
2200:
2201:
2202: l_emp_exists := chk_oipl_emp_assign(p_oipl_id => p_oipl_id,

Line 2207: hr_utility.set_location('Step Has Emp Placements (Y/N) : '||l_emp_exists ,30);

2203: p_effective_date => p_effective_date,
2204: p_business_group_id => p_business_group_id);
2205:
2206: if g_debug then
2207: hr_utility.set_location('Step Has Emp Placements (Y/N) : '||l_emp_exists ,30);
2208: end if;
2209:
2210: l_oipl_has_gsp_type := chk_oipl_has_gsp_type(p_oipl_id => p_oipl_id,
2211: p_effective_date => p_effective_date,

Line 2214: hr_utility.set_location('OIPL has GSP Type (Y/N) : '||l_oipl_has_gsp_type ,40);

2210: l_oipl_has_gsp_type := chk_oipl_has_gsp_type(p_oipl_id => p_oipl_id,
2211: p_effective_date => p_effective_date,
2212: p_business_group_id=> p_business_group_id);
2213: if g_debug then
2214: hr_utility.set_location('OIPL has GSP Type (Y/N) : '||l_oipl_has_gsp_type ,40);
2215: end if;
2216:
2217: if (l_oipl_has_gsp_type = 'Y' AND l_emp_exists = 'Y') Then
2218: hr_utility.set_message(8302,'PQH_GSP_NOT_DEL_OIPL');

Line 2218: hr_utility.set_message(8302,'PQH_GSP_NOT_DEL_OIPL');

2214: hr_utility.set_location('OIPL has GSP Type (Y/N) : '||l_oipl_has_gsp_type ,40);
2215: end if;
2216:
2217: if (l_oipl_has_gsp_type = 'Y' AND l_emp_exists = 'Y') Then
2218: hr_utility.set_message(8302,'PQH_GSP_NOT_DEL_OIPL');
2219: hr_utility.raise_error;
2220: end if;
2221:
2222: if g_debug then

Line 2219: hr_utility.raise_error;

2215: end if;
2216:
2217: if (l_oipl_has_gsp_type = 'Y' AND l_emp_exists = 'Y') Then
2218: hr_utility.set_message(8302,'PQH_GSP_NOT_DEL_OIPL');
2219: hr_utility.raise_error;
2220: end if;
2221:
2222: if g_debug then
2223: hr_utility.set_location('Leaving'||l_proc,100);

Line 2223: hr_utility.set_location('Leaving'||l_proc,100);

2219: hr_utility.raise_error;
2220: end if;
2221:
2222: if g_debug then
2223: hr_utility.set_location('Leaving'||l_proc,100);
2224: end if;
2225:
2226: end oipl_del_val;
2227:

Line 2247: hr_utility.set_location('Entering'||l_proc,5);

2243: -- this should be only option linked to the point
2244: -- etc
2245:
2246: if g_debug then
2247: hr_utility.set_location('Entering'||l_proc,5);
2248: hr_utility.set_location('p_oipl_id'||p_oipl_id,10);
2249: hr_utility.set_location('p_effective_date'||p_effective_date,15);
2250: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
2251: hr_utility.set_location('p_oipl_stat_cd'||p_oipl_stat_cd,25);

Line 2248: hr_utility.set_location('p_oipl_id'||p_oipl_id,10);

2244: -- etc
2245:
2246: if g_debug then
2247: hr_utility.set_location('Entering'||l_proc,5);
2248: hr_utility.set_location('p_oipl_id'||p_oipl_id,10);
2249: hr_utility.set_location('p_effective_date'||p_effective_date,15);
2250: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
2251: hr_utility.set_location('p_oipl_stat_cd'||p_oipl_stat_cd,25);
2252: hr_utility.set_location('Old oipl_stat_cd'||ben_cop_shd.g_old_rec.OIPL_STAT_CD,30);

Line 2249: hr_utility.set_location('p_effective_date'||p_effective_date,15);

2245:
2246: if g_debug then
2247: hr_utility.set_location('Entering'||l_proc,5);
2248: hr_utility.set_location('p_oipl_id'||p_oipl_id,10);
2249: hr_utility.set_location('p_effective_date'||p_effective_date,15);
2250: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
2251: hr_utility.set_location('p_oipl_stat_cd'||p_oipl_stat_cd,25);
2252: hr_utility.set_location('Old oipl_stat_cd'||ben_cop_shd.g_old_rec.OIPL_STAT_CD,30);
2253: hr_utility.set_location('p_dml_operation'||p_dml_operation,45);

Line 2250: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);

2246: if g_debug then
2247: hr_utility.set_location('Entering'||l_proc,5);
2248: hr_utility.set_location('p_oipl_id'||p_oipl_id,10);
2249: hr_utility.set_location('p_effective_date'||p_effective_date,15);
2250: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
2251: hr_utility.set_location('p_oipl_stat_cd'||p_oipl_stat_cd,25);
2252: hr_utility.set_location('Old oipl_stat_cd'||ben_cop_shd.g_old_rec.OIPL_STAT_CD,30);
2253: hr_utility.set_location('p_dml_operation'||p_dml_operation,45);
2254: end if;

Line 2251: hr_utility.set_location('p_oipl_stat_cd'||p_oipl_stat_cd,25);

2247: hr_utility.set_location('Entering'||l_proc,5);
2248: hr_utility.set_location('p_oipl_id'||p_oipl_id,10);
2249: hr_utility.set_location('p_effective_date'||p_effective_date,15);
2250: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
2251: hr_utility.set_location('p_oipl_stat_cd'||p_oipl_stat_cd,25);
2252: hr_utility.set_location('Old oipl_stat_cd'||ben_cop_shd.g_old_rec.OIPL_STAT_CD,30);
2253: hr_utility.set_location('p_dml_operation'||p_dml_operation,45);
2254: end if;
2255:

Line 2252: hr_utility.set_location('Old oipl_stat_cd'||ben_cop_shd.g_old_rec.OIPL_STAT_CD,30);

2248: hr_utility.set_location('p_oipl_id'||p_oipl_id,10);
2249: hr_utility.set_location('p_effective_date'||p_effective_date,15);
2250: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
2251: hr_utility.set_location('p_oipl_stat_cd'||p_oipl_stat_cd,25);
2252: hr_utility.set_location('Old oipl_stat_cd'||ben_cop_shd.g_old_rec.OIPL_STAT_CD,30);
2253: hr_utility.set_location('p_dml_operation'||p_dml_operation,45);
2254: end if;
2255:
2256: If p_dml_operation = 'I' Then

Line 2253: hr_utility.set_location('p_dml_operation'||p_dml_operation,45);

2249: hr_utility.set_location('p_effective_date'||p_effective_date,15);
2250: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
2251: hr_utility.set_location('p_oipl_stat_cd'||p_oipl_stat_cd,25);
2252: hr_utility.set_location('Old oipl_stat_cd'||ben_cop_shd.g_old_rec.OIPL_STAT_CD,30);
2253: hr_utility.set_location('p_dml_operation'||p_dml_operation,45);
2254: end if;
2255:
2256: If p_dml_operation = 'I' Then
2257: if g_debug then

Line 2258: hr_utility.set_location('OIPL Insert Validations',55);

2254: end if;
2255:
2256: If p_dml_operation = 'I' Then
2257: if g_debug then
2258: hr_utility.set_location('OIPL Insert Validations',55);
2259: end if;
2260: oipl_ins_val(p_oipl_id => p_oipl_id,
2261: p_effective_date => p_effective_date);
2262: End if;

Line 2266: hr_utility.set_location('OIPL Update Validations',65);

2262: End if;
2263:
2264: If p_dml_operation = 'U' Then
2265: if g_debug then
2266: hr_utility.set_location('OIPL Update Validations',65);
2267: end if;
2268: oipl_upd_val(p_oipl_id => p_oipl_id,
2269: p_effective_date => p_effective_date,
2270: p_Business_Group_Id => p_Business_Group_Id,

Line 2276: hr_utility.set_location('OIPL Delete Validations',75);

2272: End if;
2273:
2274: If p_dml_operation = 'D' Then
2275: if g_debug then
2276: hr_utility.set_location('OIPL Delete Validations',75);
2277: end if;
2278: oipl_del_val(p_oipl_id => p_oipl_id,
2279: p_effective_date => p_effective_date,
2280: p_business_group_id => p_business_group_id);

Line 2284: hr_utility.set_location('Leaving'||l_proc,100);

2280: p_business_group_id => p_business_group_id);
2281: End if;
2282:
2283: if g_debug then
2284: hr_utility.set_location('Leaving'||l_proc,100);
2285: end if;
2286:
2287: end oipl_validations;
2288:

Line 2302: hr_utility.set_location('Entering'||l_proc,5);

2298: */
2299: l_proc varchar2(72) := g_package||'abr_ins_val';
2300: Begin
2301: if g_debug then
2302: hr_utility.set_location('Entering'||l_proc,5);
2303: hr_utility.set_location('p_abr_id'||p_abr_id,10);
2304: hr_utility.set_location('p_effective_date'||p_effective_date,15);
2305: hr_utility.set_location('p_business_group_id'||p_business_group_id,20);
2306: end if;

Line 2303: hr_utility.set_location('p_abr_id'||p_abr_id,10);

2299: l_proc varchar2(72) := g_package||'abr_ins_val';
2300: Begin
2301: if g_debug then
2302: hr_utility.set_location('Entering'||l_proc,5);
2303: hr_utility.set_location('p_abr_id'||p_abr_id,10);
2304: hr_utility.set_location('p_effective_date'||p_effective_date,15);
2305: hr_utility.set_location('p_business_group_id'||p_business_group_id,20);
2306: end if;
2307:

Line 2304: hr_utility.set_location('p_effective_date'||p_effective_date,15);

2300: Begin
2301: if g_debug then
2302: hr_utility.set_location('Entering'||l_proc,5);
2303: hr_utility.set_location('p_abr_id'||p_abr_id,10);
2304: hr_utility.set_location('p_effective_date'||p_effective_date,15);
2305: hr_utility.set_location('p_business_group_id'||p_business_group_id,20);
2306: end if;
2307:
2308:

Line 2305: hr_utility.set_location('p_business_group_id'||p_business_group_id,20);

2301: if g_debug then
2302: hr_utility.set_location('Entering'||l_proc,5);
2303: hr_utility.set_location('p_abr_id'||p_abr_id,10);
2304: hr_utility.set_location('p_effective_date'||p_effective_date,15);
2305: hr_utility.set_location('p_business_group_id'||p_business_group_id,20);
2306: end if;
2307:
2308:
2309:

Line 2311: hr_utility.set_location('Leaving'||l_proc,100);

2307:
2308:
2309:
2310: if g_debug then
2311: hr_utility.set_location('Leaving'||l_proc,100);
2312: end if;
2313:
2314: end abr_ins_val;
2315:

Line 2377: hr_utility.set_location('Entering'||l_proc,5);

2373:
2374:
2375: Begin
2376: if g_debug then
2377: hr_utility.set_location('Entering'||l_proc,5);
2378: hr_utility.set_location('p_abr_id'||p_abr_id,10);
2379: hr_utility.set_location('p_effective_date'||p_effective_date,15);
2380: hr_utility.set_location('p_business_group_id'||p_business_group_id,20);
2381: hr_utility.set_location('p_pl_id'||p_pl_id,35);

Line 2378: hr_utility.set_location('p_abr_id'||p_abr_id,10);

2374:
2375: Begin
2376: if g_debug then
2377: hr_utility.set_location('Entering'||l_proc,5);
2378: hr_utility.set_location('p_abr_id'||p_abr_id,10);
2379: hr_utility.set_location('p_effective_date'||p_effective_date,15);
2380: hr_utility.set_location('p_business_group_id'||p_business_group_id,20);
2381: hr_utility.set_location('p_pl_id'||p_pl_id,35);
2382: hr_utility.set_location('p_opt_id'||p_opt_id,40);

Line 2379: hr_utility.set_location('p_effective_date'||p_effective_date,15);

2375: Begin
2376: if g_debug then
2377: hr_utility.set_location('Entering'||l_proc,5);
2378: hr_utility.set_location('p_abr_id'||p_abr_id,10);
2379: hr_utility.set_location('p_effective_date'||p_effective_date,15);
2380: hr_utility.set_location('p_business_group_id'||p_business_group_id,20);
2381: hr_utility.set_location('p_pl_id'||p_pl_id,35);
2382: hr_utility.set_location('p_opt_id'||p_opt_id,40);
2383: hr_utility.set_location('p_acty_typ_cd'||p_acty_typ_cd,45);

Line 2380: hr_utility.set_location('p_business_group_id'||p_business_group_id,20);

2376: if g_debug then
2377: hr_utility.set_location('Entering'||l_proc,5);
2378: hr_utility.set_location('p_abr_id'||p_abr_id,10);
2379: hr_utility.set_location('p_effective_date'||p_effective_date,15);
2380: hr_utility.set_location('p_business_group_id'||p_business_group_id,20);
2381: hr_utility.set_location('p_pl_id'||p_pl_id,35);
2382: hr_utility.set_location('p_opt_id'||p_opt_id,40);
2383: hr_utility.set_location('p_acty_typ_cd'||p_acty_typ_cd,45);
2384: hr_utility.set_location('p_Acty_Base_RT_Stat_Cd'||p_Acty_Base_RT_Stat_Cd,55);

Line 2381: hr_utility.set_location('p_pl_id'||p_pl_id,35);

2377: hr_utility.set_location('Entering'||l_proc,5);
2378: hr_utility.set_location('p_abr_id'||p_abr_id,10);
2379: hr_utility.set_location('p_effective_date'||p_effective_date,15);
2380: hr_utility.set_location('p_business_group_id'||p_business_group_id,20);
2381: hr_utility.set_location('p_pl_id'||p_pl_id,35);
2382: hr_utility.set_location('p_opt_id'||p_opt_id,40);
2383: hr_utility.set_location('p_acty_typ_cd'||p_acty_typ_cd,45);
2384: hr_utility.set_location('p_Acty_Base_RT_Stat_Cd'||p_Acty_Base_RT_Stat_Cd,55);
2385: end if;

Line 2382: hr_utility.set_location('p_opt_id'||p_opt_id,40);

2378: hr_utility.set_location('p_abr_id'||p_abr_id,10);
2379: hr_utility.set_location('p_effective_date'||p_effective_date,15);
2380: hr_utility.set_location('p_business_group_id'||p_business_group_id,20);
2381: hr_utility.set_location('p_pl_id'||p_pl_id,35);
2382: hr_utility.set_location('p_opt_id'||p_opt_id,40);
2383: hr_utility.set_location('p_acty_typ_cd'||p_acty_typ_cd,45);
2384: hr_utility.set_location('p_Acty_Base_RT_Stat_Cd'||p_Acty_Base_RT_Stat_Cd,55);
2385: end if;
2386:

Line 2383: hr_utility.set_location('p_acty_typ_cd'||p_acty_typ_cd,45);

2379: hr_utility.set_location('p_effective_date'||p_effective_date,15);
2380: hr_utility.set_location('p_business_group_id'||p_business_group_id,20);
2381: hr_utility.set_location('p_pl_id'||p_pl_id,35);
2382: hr_utility.set_location('p_opt_id'||p_opt_id,40);
2383: hr_utility.set_location('p_acty_typ_cd'||p_acty_typ_cd,45);
2384: hr_utility.set_location('p_Acty_Base_RT_Stat_Cd'||p_Acty_Base_RT_Stat_Cd,55);
2385: end if;
2386:
2387: -- Check PL Type is GSP

Line 2384: hr_utility.set_location('p_Acty_Base_RT_Stat_Cd'||p_Acty_Base_RT_Stat_Cd,55);

2380: hr_utility.set_location('p_business_group_id'||p_business_group_id,20);
2381: hr_utility.set_location('p_pl_id'||p_pl_id,35);
2382: hr_utility.set_location('p_opt_id'||p_opt_id,40);
2383: hr_utility.set_location('p_acty_typ_cd'||p_acty_typ_cd,45);
2384: hr_utility.set_location('p_Acty_Base_RT_Stat_Cd'||p_Acty_Base_RT_Stat_Cd,55);
2385: end if;
2386:
2387: -- Check PL Type is GSP
2388: -- And PL exists in PGM through PLIP

Line 2398: hr_utility.set_location('PL exists in GSP Pgm (Y/N) '||l_pl_exists_in_grdldr,65);

2394: p_effective_date => p_effective_date,
2395: p_Business_Group_Id => p_business_group_id);
2396:
2397: if g_debug then
2398: hr_utility.set_location('PL exists in GSP Pgm (Y/N) '||l_pl_exists_in_grdldr,65);
2399: end if;
2400:
2401:
2402: Open csr_plip_id;

Line 2406: hr_utility.set_location('PLIP Id '||l_plip_id,75);

2402: Open csr_plip_id;
2403: Fetch csr_plip_id into l_plip_id;
2404: Close csr_plip_id;
2405: if g_debug then
2406: hr_utility.set_location('PLIP Id '||l_plip_id,75);
2407: end if;
2408:
2409: if l_pl_exists_in_grdldr = 'Y' And l_plip_id IS NOT NULL Then
2410:

Line 2417: hr_utility.set_location('PLIP has Emp Assignments (Y/N) '||l_plip_emp_assign,85);

2413: p_business_group_id => p_business_group_id);
2414: end if;
2415:
2416: if g_debug then
2417: hr_utility.set_location('PLIP has Emp Assignments (Y/N) '||l_plip_emp_assign,85);
2418: end if;
2419: End If;
2420: l_pl_exists := l_plip_emp_assign;
2421:

Line 2436: hr_utility.set_location('OPT exists in GSP Pgm (Y/N) '||l_opt_exists_in_gsp_pgm,95);

2432: p_effective_date => p_effective_date,
2433: p_Business_Group_Id => p_business_group_id);
2434:
2435: if g_debug then
2436: hr_utility.set_location('OPT exists in GSP Pgm (Y/N) '||l_opt_exists_in_gsp_pgm,95);
2437: end if;
2438:
2439:
2440: Open csr_oipl_id;

Line 2444: hr_utility.set_location('OIPL Id '||l_oipl_id,100);

2440: Open csr_oipl_id;
2441: Fetch csr_oipl_id into l_oipl_id;
2442: Close csr_oipl_id;
2443: if g_debug then
2444: hr_utility.set_location('OIPL Id '||l_oipl_id,100);
2445: end if;
2446:
2447: if l_opt_exists_in_gsp_pgm = 'Y' And l_plip_id IS NOT NULL Then
2448:

Line 2455: hr_utility.set_location('OIPL has Emp Assignments (Y/N) '||l_oipl_emp_assign,105);

2451: p_business_group_id => p_business_group_id);
2452: end if;
2453:
2454: if g_debug then
2455: hr_utility.set_location('OIPL has Emp Assignments (Y/N) '||l_oipl_emp_assign,105);
2456: end if;
2457:
2458: End If;
2459: l_opt_exists := l_oipl_emp_assign;

Line 2467: hr_utility.set_location('Old Status : '||ben_abr_shd.g_old_rec.ACTY_BASE_RT_STAT_CD,115);

2463:
2464:
2465:
2466: if g_debug then
2467: hr_utility.set_location('Old Status : '||ben_abr_shd.g_old_rec.ACTY_BASE_RT_STAT_CD,115);
2468: hr_utility.set_location('Old Activity : '||ben_abr_shd.g_old_rec.ACTY_TYP_CD,120);
2469: end if;
2470:
2471: -- Cannot Change Status

Line 2468: hr_utility.set_location('Old Activity : '||ben_abr_shd.g_old_rec.ACTY_TYP_CD,120);

2464:
2465:
2466: if g_debug then
2467: hr_utility.set_location('Old Status : '||ben_abr_shd.g_old_rec.ACTY_BASE_RT_STAT_CD,115);
2468: hr_utility.set_location('Old Activity : '||ben_abr_shd.g_old_rec.ACTY_TYP_CD,120);
2469: end if;
2470:
2471: -- Cannot Change Status
2472: if ( ben_abr_shd.g_old_rec.ACTY_BASE_RT_STAT_CD='A' And

Line 2474: hr_utility.set_message(8302,'PQH_GSP_NOT_UPD_ABR_STATUS');

2470:
2471: -- Cannot Change Status
2472: if ( ben_abr_shd.g_old_rec.ACTY_BASE_RT_STAT_CD='A' And
2473: ben_abr_shd.g_old_rec.ACTY_BASE_RT_STAT_CD <> p_Acty_Base_RT_Stat_Cd) Then
2474: hr_utility.set_message(8302,'PQH_GSP_NOT_UPD_ABR_STATUS');
2475: hr_utility.raise_error;
2476: end if;
2477:
2478: -- Cannot Change Activity

Line 2475: hr_utility.raise_error;

2471: -- Cannot Change Status
2472: if ( ben_abr_shd.g_old_rec.ACTY_BASE_RT_STAT_CD='A' And
2473: ben_abr_shd.g_old_rec.ACTY_BASE_RT_STAT_CD <> p_Acty_Base_RT_Stat_Cd) Then
2474: hr_utility.set_message(8302,'PQH_GSP_NOT_UPD_ABR_STATUS');
2475: hr_utility.raise_error;
2476: end if;
2477:
2478: -- Cannot Change Activity
2479: if ( ben_abr_shd.g_old_rec.ACTY_TYP_CD <> p_acty_typ_cd ) Then

Line 2480: hr_utility.set_message(8302,'PQH_GSP_NOT_UPD_ABR_ACTIVITY');

2476: end if;
2477:
2478: -- Cannot Change Activity
2479: if ( ben_abr_shd.g_old_rec.ACTY_TYP_CD <> p_acty_typ_cd ) Then
2480: hr_utility.set_message(8302,'PQH_GSP_NOT_UPD_ABR_ACTIVITY');
2481: hr_utility.raise_error;
2482: end if;
2483:
2484: End If;

Line 2481: hr_utility.raise_error;

2477:
2478: -- Cannot Change Activity
2479: if ( ben_abr_shd.g_old_rec.ACTY_TYP_CD <> p_acty_typ_cd ) Then
2480: hr_utility.set_message(8302,'PQH_GSP_NOT_UPD_ABR_ACTIVITY');
2481: hr_utility.raise_error;
2482: end if;
2483:
2484: End If;
2485:

Line 2487: hr_utility.set_location('Leaving'||l_proc,100);

2483:
2484: End If;
2485:
2486: if g_debug then
2487: hr_utility.set_location('Leaving'||l_proc,100);
2488: end if;
2489:
2490: end abr_upd_val;
2491:

Line 2505: hr_utility.set_location('Entering'||l_proc,5);

2501: */
2502: l_proc varchar2(72) := g_package||'abr_del_val';
2503: Begin
2504: if g_debug then
2505: hr_utility.set_location('Entering'||l_proc,5);
2506: hr_utility.set_location('p_abr_id'||p_abr_id,10);
2507: hr_utility.set_location('p_effective_date'||p_effective_date,15);
2508: hr_utility.set_location('p_business_group_id'||p_business_group_id,20);
2509: end if;

Line 2506: hr_utility.set_location('p_abr_id'||p_abr_id,10);

2502: l_proc varchar2(72) := g_package||'abr_del_val';
2503: Begin
2504: if g_debug then
2505: hr_utility.set_location('Entering'||l_proc,5);
2506: hr_utility.set_location('p_abr_id'||p_abr_id,10);
2507: hr_utility.set_location('p_effective_date'||p_effective_date,15);
2508: hr_utility.set_location('p_business_group_id'||p_business_group_id,20);
2509: end if;
2510:

Line 2507: hr_utility.set_location('p_effective_date'||p_effective_date,15);

2503: Begin
2504: if g_debug then
2505: hr_utility.set_location('Entering'||l_proc,5);
2506: hr_utility.set_location('p_abr_id'||p_abr_id,10);
2507: hr_utility.set_location('p_effective_date'||p_effective_date,15);
2508: hr_utility.set_location('p_business_group_id'||p_business_group_id,20);
2509: end if;
2510:
2511: if g_debug then

Line 2508: hr_utility.set_location('p_business_group_id'||p_business_group_id,20);

2504: if g_debug then
2505: hr_utility.set_location('Entering'||l_proc,5);
2506: hr_utility.set_location('p_abr_id'||p_abr_id,10);
2507: hr_utility.set_location('p_effective_date'||p_effective_date,15);
2508: hr_utility.set_location('p_business_group_id'||p_business_group_id,20);
2509: end if;
2510:
2511: if g_debug then
2512: hr_utility.set_location('Leaving'||l_proc,100);

Line 2512: hr_utility.set_location('Leaving'||l_proc,100);

2508: hr_utility.set_location('p_business_group_id'||p_business_group_id,20);
2509: end if;
2510:
2511: if g_debug then
2512: hr_utility.set_location('Leaving'||l_proc,100);
2513: end if;
2514:
2515: end abr_del_val;
2516:

Line 2551: hr_utility.set_location('Entering'||l_proc,5);

2547: -- validations to be performed in this routine are
2548: -- this should be only rate linked to the point or grade
2549: -- etc
2550: if g_debug then
2551: hr_utility.set_location('Entering'||l_proc,5);
2552: hr_utility.set_location('p_abr_id'||p_abr_id,10);
2553: hr_utility.set_location('p_effective_date'||p_effective_date,15);
2554: hr_utility.set_location('p_business_group_id'||p_business_group_id,20);
2555: hr_utility.set_location('p_dml_operation'||p_dml_operation,25);

Line 2552: hr_utility.set_location('p_abr_id'||p_abr_id,10);

2548: -- this should be only rate linked to the point or grade
2549: -- etc
2550: if g_debug then
2551: hr_utility.set_location('Entering'||l_proc,5);
2552: hr_utility.set_location('p_abr_id'||p_abr_id,10);
2553: hr_utility.set_location('p_effective_date'||p_effective_date,15);
2554: hr_utility.set_location('p_business_group_id'||p_business_group_id,20);
2555: hr_utility.set_location('p_dml_operation'||p_dml_operation,25);
2556: hr_utility.set_location('p_pl_id'||p_pl_id,35);

Line 2553: hr_utility.set_location('p_effective_date'||p_effective_date,15);

2549: -- etc
2550: if g_debug then
2551: hr_utility.set_location('Entering'||l_proc,5);
2552: hr_utility.set_location('p_abr_id'||p_abr_id,10);
2553: hr_utility.set_location('p_effective_date'||p_effective_date,15);
2554: hr_utility.set_location('p_business_group_id'||p_business_group_id,20);
2555: hr_utility.set_location('p_dml_operation'||p_dml_operation,25);
2556: hr_utility.set_location('p_pl_id'||p_pl_id,35);
2557: hr_utility.set_location('p_opt_id'||p_opt_id,40);

Line 2554: hr_utility.set_location('p_business_group_id'||p_business_group_id,20);

2550: if g_debug then
2551: hr_utility.set_location('Entering'||l_proc,5);
2552: hr_utility.set_location('p_abr_id'||p_abr_id,10);
2553: hr_utility.set_location('p_effective_date'||p_effective_date,15);
2554: hr_utility.set_location('p_business_group_id'||p_business_group_id,20);
2555: hr_utility.set_location('p_dml_operation'||p_dml_operation,25);
2556: hr_utility.set_location('p_pl_id'||p_pl_id,35);
2557: hr_utility.set_location('p_opt_id'||p_opt_id,40);
2558: hr_utility.set_location('p_acty_typ_cd'||p_acty_typ_cd,45);

Line 2555: hr_utility.set_location('p_dml_operation'||p_dml_operation,25);

2551: hr_utility.set_location('Entering'||l_proc,5);
2552: hr_utility.set_location('p_abr_id'||p_abr_id,10);
2553: hr_utility.set_location('p_effective_date'||p_effective_date,15);
2554: hr_utility.set_location('p_business_group_id'||p_business_group_id,20);
2555: hr_utility.set_location('p_dml_operation'||p_dml_operation,25);
2556: hr_utility.set_location('p_pl_id'||p_pl_id,35);
2557: hr_utility.set_location('p_opt_id'||p_opt_id,40);
2558: hr_utility.set_location('p_acty_typ_cd'||p_acty_typ_cd,45);
2559: hr_utility.set_location('Old acty_typ_cd'||ben_abr_shd.g_old_rec.ACTY_TYP_CD,46);

Line 2556: hr_utility.set_location('p_pl_id'||p_pl_id,35);

2552: hr_utility.set_location('p_abr_id'||p_abr_id,10);
2553: hr_utility.set_location('p_effective_date'||p_effective_date,15);
2554: hr_utility.set_location('p_business_group_id'||p_business_group_id,20);
2555: hr_utility.set_location('p_dml_operation'||p_dml_operation,25);
2556: hr_utility.set_location('p_pl_id'||p_pl_id,35);
2557: hr_utility.set_location('p_opt_id'||p_opt_id,40);
2558: hr_utility.set_location('p_acty_typ_cd'||p_acty_typ_cd,45);
2559: hr_utility.set_location('Old acty_typ_cd'||ben_abr_shd.g_old_rec.ACTY_TYP_CD,46);
2560: hr_utility.set_location('p_Acty_Base_RT_Stat_Cd'||p_Acty_Base_RT_Stat_Cd,55);

Line 2557: hr_utility.set_location('p_opt_id'||p_opt_id,40);

2553: hr_utility.set_location('p_effective_date'||p_effective_date,15);
2554: hr_utility.set_location('p_business_group_id'||p_business_group_id,20);
2555: hr_utility.set_location('p_dml_operation'||p_dml_operation,25);
2556: hr_utility.set_location('p_pl_id'||p_pl_id,35);
2557: hr_utility.set_location('p_opt_id'||p_opt_id,40);
2558: hr_utility.set_location('p_acty_typ_cd'||p_acty_typ_cd,45);
2559: hr_utility.set_location('Old acty_typ_cd'||ben_abr_shd.g_old_rec.ACTY_TYP_CD,46);
2560: hr_utility.set_location('p_Acty_Base_RT_Stat_Cd'||p_Acty_Base_RT_Stat_Cd,55);
2561: hr_utility.set_location('Old Acty_Base_RT_Stat_Cd'||ben_abr_shd.g_old_rec.ACTY_BASE_RT_STAT_CD,65);

Line 2558: hr_utility.set_location('p_acty_typ_cd'||p_acty_typ_cd,45);

2554: hr_utility.set_location('p_business_group_id'||p_business_group_id,20);
2555: hr_utility.set_location('p_dml_operation'||p_dml_operation,25);
2556: hr_utility.set_location('p_pl_id'||p_pl_id,35);
2557: hr_utility.set_location('p_opt_id'||p_opt_id,40);
2558: hr_utility.set_location('p_acty_typ_cd'||p_acty_typ_cd,45);
2559: hr_utility.set_location('Old acty_typ_cd'||ben_abr_shd.g_old_rec.ACTY_TYP_CD,46);
2560: hr_utility.set_location('p_Acty_Base_RT_Stat_Cd'||p_Acty_Base_RT_Stat_Cd,55);
2561: hr_utility.set_location('Old Acty_Base_RT_Stat_Cd'||ben_abr_shd.g_old_rec.ACTY_BASE_RT_STAT_CD,65);
2562: end if;

Line 2559: hr_utility.set_location('Old acty_typ_cd'||ben_abr_shd.g_old_rec.ACTY_TYP_CD,46);

2555: hr_utility.set_location('p_dml_operation'||p_dml_operation,25);
2556: hr_utility.set_location('p_pl_id'||p_pl_id,35);
2557: hr_utility.set_location('p_opt_id'||p_opt_id,40);
2558: hr_utility.set_location('p_acty_typ_cd'||p_acty_typ_cd,45);
2559: hr_utility.set_location('Old acty_typ_cd'||ben_abr_shd.g_old_rec.ACTY_TYP_CD,46);
2560: hr_utility.set_location('p_Acty_Base_RT_Stat_Cd'||p_Acty_Base_RT_Stat_Cd,55);
2561: hr_utility.set_location('Old Acty_Base_RT_Stat_Cd'||ben_abr_shd.g_old_rec.ACTY_BASE_RT_STAT_CD,65);
2562: end if;
2563:

Line 2560: hr_utility.set_location('p_Acty_Base_RT_Stat_Cd'||p_Acty_Base_RT_Stat_Cd,55);

2556: hr_utility.set_location('p_pl_id'||p_pl_id,35);
2557: hr_utility.set_location('p_opt_id'||p_opt_id,40);
2558: hr_utility.set_location('p_acty_typ_cd'||p_acty_typ_cd,45);
2559: hr_utility.set_location('Old acty_typ_cd'||ben_abr_shd.g_old_rec.ACTY_TYP_CD,46);
2560: hr_utility.set_location('p_Acty_Base_RT_Stat_Cd'||p_Acty_Base_RT_Stat_Cd,55);
2561: hr_utility.set_location('Old Acty_Base_RT_Stat_Cd'||ben_abr_shd.g_old_rec.ACTY_BASE_RT_STAT_CD,65);
2562: end if;
2563:
2564: -- Get Activity Type

Line 2561: hr_utility.set_location('Old Acty_Base_RT_Stat_Cd'||ben_abr_shd.g_old_rec.ACTY_BASE_RT_STAT_CD,65);

2557: hr_utility.set_location('p_opt_id'||p_opt_id,40);
2558: hr_utility.set_location('p_acty_typ_cd'||p_acty_typ_cd,45);
2559: hr_utility.set_location('Old acty_typ_cd'||ben_abr_shd.g_old_rec.ACTY_TYP_CD,46);
2560: hr_utility.set_location('p_Acty_Base_RT_Stat_Cd'||p_Acty_Base_RT_Stat_Cd,55);
2561: hr_utility.set_location('Old Acty_Base_RT_Stat_Cd'||ben_abr_shd.g_old_rec.ACTY_BASE_RT_STAT_CD,65);
2562: end if;
2563:
2564: -- Get Activity Type
2565: Open csr_activity_type;

Line 2569: hr_utility.set_location('Activity Type'||l_activity_type,55);

2565: Open csr_activity_type;
2566: Fetch csr_activity_type into l_activity_type;
2567: Close csr_activity_type;
2568: if g_debug then
2569: hr_utility.set_location('Activity Type'||l_activity_type,55);
2570: end if;
2571:
2572: if l_activity_type = 'GSPSA' Then
2573:

Line 2576: hr_utility.set_location('Perform ABR Insert Validations',60);

2572: if l_activity_type = 'GSPSA' Then
2573:
2574: if p_dml_operation = 'I' then
2575: if g_debug then
2576: hr_utility.set_location('Perform ABR Insert Validations',60);
2577: end if;
2578: abr_ins_val(p_abr_id => p_abr_id,
2579: p_effective_date => p_effective_date,
2580: p_business_group_id => p_business_group_id);

Line 2586: hr_utility.set_location('Perform ABR Update Validations',70);

2582:
2583:
2584: if p_dml_operation = 'U' then
2585: if g_debug then
2586: hr_utility.set_location('Perform ABR Update Validations',70);
2587: end if;
2588:
2589:
2590: abr_upd_val(p_abr_id => p_abr_id,

Line 2603: hr_utility.set_location('Perform ABR Delete Validations',80);

2599:
2600:
2601: if p_dml_operation = 'D' then
2602: if g_debug then
2603: hr_utility.set_location('Perform ABR Delete Validations',80);
2604: end if;
2605: abr_del_val(p_abr_id => p_abr_id,
2606: p_effective_date => p_effective_date,
2607: p_business_group_id => p_business_group_id);

Line 2612: hr_utility.set_location('Leaving'||l_proc,100);

2608: end if;
2609:
2610: end if;
2611: if g_debug then
2612: hr_utility.set_location('Leaving'||l_proc,100);
2613: end if;
2614:
2615: end abr_validations;
2616: end pqh_gsp_ben_validations;