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

Line 30: hr_utility.set_location('before call to get basic pay',1);

26: ) is
27:
28: l_table_pay pay_user_column_instances_f.value%type;
29: begin
30: hr_utility.set_location('before call to get basic pay',1);
31: hr_utility.set_location('eff date '|| p_prior_effective_date,1);
32: hr_utility.set_location('grade '|| p_prior_grade_or_level,1);
33: hr_utility.set_location('Step '|| p_prior_step_or_rate,1);
34: l_table_pay := GHR_CPDF_CHECK.get_basic_pay(

Line 31: hr_utility.set_location('eff date '|| p_prior_effective_date,1);

27:
28: l_table_pay pay_user_column_instances_f.value%type;
29: begin
30: hr_utility.set_location('before call to get basic pay',1);
31: hr_utility.set_location('eff date '|| p_prior_effective_date,1);
32: hr_utility.set_location('grade '|| p_prior_grade_or_level,1);
33: hr_utility.set_location('Step '|| p_prior_step_or_rate,1);
34: l_table_pay := GHR_CPDF_CHECK.get_basic_pay(
35: '0000 Oracle Federal Standard Pay Table (AL, ES, EX, GS, GG) No. 0000',

Line 32: hr_utility.set_location('grade '|| p_prior_grade_or_level,1);

28: l_table_pay pay_user_column_instances_f.value%type;
29: begin
30: hr_utility.set_location('before call to get basic pay',1);
31: hr_utility.set_location('eff date '|| p_prior_effective_date,1);
32: hr_utility.set_location('grade '|| p_prior_grade_or_level,1);
33: hr_utility.set_location('Step '|| p_prior_step_or_rate,1);
34: l_table_pay := GHR_CPDF_CHECK.get_basic_pay(
35: '0000 Oracle Federal Standard Pay Table (AL, ES, EX, GS, GG) No. 0000',
36: 'GS' || '-' || p_prior_grade_or_level,

Line 33: hr_utility.set_location('Step '|| p_prior_step_or_rate,1);

29: begin
30: hr_utility.set_location('before call to get basic pay',1);
31: hr_utility.set_location('eff date '|| p_prior_effective_date,1);
32: hr_utility.set_location('grade '|| p_prior_grade_or_level,1);
33: hr_utility.set_location('Step '|| p_prior_step_or_rate,1);
34: l_table_pay := GHR_CPDF_CHECK.get_basic_pay(
35: '0000 Oracle Federal Standard Pay Table (AL, ES, EX, GS, GG) No. 0000',
36: 'GS' || '-' || p_prior_grade_or_level,
37: p_prior_step_or_rate,

Line 39: hr_utility.set_location('after call to get basic pay',1);

35: '0000 Oracle Federal Standard Pay Table (AL, ES, EX, GS, GG) No. 0000',
36: 'GS' || '-' || p_prior_grade_or_level,
37: p_prior_step_or_rate,
38: p_prior_effective_date);
39: hr_utility.set_location('after call to get basic pay',1);
40:
41: -- 570.02.2
42: -- Venkat 06/08/03
43: -- This edit bypassed when the 866 action and Temporary Promotion Step is not null

Line 61: hr_utility.set_message(8301,'GHR_37746_ALL_PROCEDURE_FAIL');

57: (l_table_pay = to_number(p_prior_basic_pay)) or
58: (p_prior_basic_pay is null or to_number(p_prior_basic_pay) = 0)
59: ) then
60: GHR_GHRWS52L.CPDF_Parameter_Check;
61: hr_utility.set_message(8301,'GHR_37746_ALL_PROCEDURE_FAIL');
62: hr_utility.raise_error;
63: end if;
64: end if;
65: END IF;

Line 62: hr_utility.raise_error;

58: (p_prior_basic_pay is null or to_number(p_prior_basic_pay) = 0)
59: ) then
60: GHR_GHRWS52L.CPDF_Parameter_Check;
61: hr_utility.set_message(8301,'GHR_37746_ALL_PROCEDURE_FAIL');
62: hr_utility.raise_error;
63: end if;
64: end if;
65: END IF;
66:

Line 80: hr_utility.set_message(8301,'GHR_37708_ALL_PROCEDURE_FAIL');

76: ) then
77: if not (l_table_pay = to_number(p_prior_basic_pay) or
78: (p_prior_basic_pay is null or to_number(p_prior_basic_pay) = 0)) then
79: GHR_GHRWS52L.CPDF_Parameter_Check;
80: hr_utility.set_message(8301,'GHR_37708_ALL_PROCEDURE_FAIL');
81: hr_utility.raise_error;
82: end if;
83: end if;
84:

Line 81: hr_utility.raise_error;

77: if not (l_table_pay = to_number(p_prior_basic_pay) or
78: (p_prior_basic_pay is null or to_number(p_prior_basic_pay) = 0)) then
79: GHR_GHRWS52L.CPDF_Parameter_Check;
80: hr_utility.set_message(8301,'GHR_37708_ALL_PROCEDURE_FAIL');
81: hr_utility.raise_error;
82: end if;
83: end if;
84:
85: -- 570.28.2

Line 113: hr_utility.set_message(8301,'GHR_37713_ALL_PROCEDURE_FAIL');

109: (p_prior_pay_basis = p_to_pay_basis) ) and
110: to_number(p_prior_basic_pay) <> to_number(p_to_basic_pay))
111: ) then
112: GHR_GHRWS52L.CPDF_Parameter_Check;
113: hr_utility.set_message(8301,'GHR_37713_ALL_PROCEDURE_FAIL');
114: hr_utility.set_message_token('NOA_CODE','702, 703, 713, 721, 740, 741, 815-817, 825, 840-849, 855, 866-868, 871,878-879, 891-894');
115: hr_utility.raise_error;
116: end if;
117: ELSif p_effective_date < fnd_date.canonical_to_date('2007/01/01') then

Line 114: hr_utility.set_message_token('NOA_CODE','702, 703, 713, 721, 740, 741, 815-817, 825, 840-849, 855, 866-868, 871,878-879, 891-894');

110: to_number(p_prior_basic_pay) <> to_number(p_to_basic_pay))
111: ) then
112: GHR_GHRWS52L.CPDF_Parameter_Check;
113: hr_utility.set_message(8301,'GHR_37713_ALL_PROCEDURE_FAIL');
114: hr_utility.set_message_token('NOA_CODE','702, 703, 713, 721, 740, 741, 815-817, 825, 840-849, 855, 866-868, 871,878-879, 891-894');
115: hr_utility.raise_error;
116: end if;
117: ELSif p_effective_date < fnd_date.canonical_to_date('2007/01/01') then
118: if (

Line 115: hr_utility.raise_error;

111: ) then
112: GHR_GHRWS52L.CPDF_Parameter_Check;
113: hr_utility.set_message(8301,'GHR_37713_ALL_PROCEDURE_FAIL');
114: hr_utility.set_message_token('NOA_CODE','702, 703, 713, 721, 740, 741, 815-817, 825, 840-849, 855, 866-868, 871,878-879, 891-894');
115: hr_utility.raise_error;
116: end if;
117: ELSif p_effective_date < fnd_date.canonical_to_date('2007/01/01') then
118: if (
119: (substr(p_first_noac_lookup_code,1,1) in ('7','8') and

Line 133: hr_utility.set_message(8301,'GHR_37713_ALL_PROCEDURE_FAIL');

129: (p_prior_pay_basis = p_to_pay_basis) ) and
130: to_number(p_prior_basic_pay) <> to_number(p_to_basic_pay))
131: ) then
132: GHR_GHRWS52L.CPDF_Parameter_Check;
133: hr_utility.set_message(8301,'GHR_37713_ALL_PROCEDURE_FAIL');
134: hr_utility.set_message_token('NOA_CODE','702, 703, 713, 721, 740, 741, 815-817, 825, 840-848, 855, 866-868, 871,878-879, 891-894');
135: hr_utility.raise_error;
136: end if;
137: ELSE

Line 134: hr_utility.set_message_token('NOA_CODE','702, 703, 713, 721, 740, 741, 815-817, 825, 840-848, 855, 866-868, 871,878-879, 891-894');

130: to_number(p_prior_basic_pay) <> to_number(p_to_basic_pay))
131: ) then
132: GHR_GHRWS52L.CPDF_Parameter_Check;
133: hr_utility.set_message(8301,'GHR_37713_ALL_PROCEDURE_FAIL');
134: hr_utility.set_message_token('NOA_CODE','702, 703, 713, 721, 740, 741, 815-817, 825, 840-848, 855, 866-868, 871,878-879, 891-894');
135: hr_utility.raise_error;
136: end if;
137: ELSE
138: if (

Line 135: hr_utility.raise_error;

131: ) then
132: GHR_GHRWS52L.CPDF_Parameter_Check;
133: hr_utility.set_message(8301,'GHR_37713_ALL_PROCEDURE_FAIL');
134: hr_utility.set_message_token('NOA_CODE','702, 703, 713, 721, 740, 741, 815-817, 825, 840-848, 855, 866-868, 871,878-879, 891-894');
135: hr_utility.raise_error;
136: end if;
137: ELSE
138: if (
139: (substr(p_first_noac_lookup_code,1,1) in ('7','8') and

Line 153: hr_utility.set_message(8301,'GHR_37625_ALL_PROCEDURE_FAIL');

149: (p_prior_pay_basis = p_to_pay_basis) ) and
150: to_number(p_prior_basic_pay) <> to_number(p_to_basic_pay))
151: ) then
152: GHR_GHRWS52L.CPDF_Parameter_Check;
153: hr_utility.set_message(8301,'GHR_37625_ALL_PROCEDURE_FAIL');
154: hr_utility.raise_error;
155: end if;
156: END IF;
157:

Line 154: hr_utility.raise_error;

150: to_number(p_prior_basic_pay) <> to_number(p_to_basic_pay))
151: ) then
152: GHR_GHRWS52L.CPDF_Parameter_Check;
153: hr_utility.set_message(8301,'GHR_37625_ALL_PROCEDURE_FAIL');
154: hr_utility.raise_error;
155: end if;
156: END IF;
157:
158: -- 570.50.2

Line 171: hr_utility.set_message(8301,'GHR_37719_ALL_PROCEDURE_FAIL');

167: if ((to_number(p_prior_basic_pay) < to_number(l_table_pay)) and
168: (p_prior_basic_pay is not null and to_number(p_prior_basic_pay) <> 0)
169: ) then
170: GHR_GHRWS52L.CPDF_Parameter_Check;
171: hr_utility.set_message(8301,'GHR_37719_ALL_PROCEDURE_FAIL');
172: hr_utility.raise_error;
173: end if;
174: end if;
175: END IF;

Line 172: hr_utility.raise_error;

168: (p_prior_basic_pay is not null and to_number(p_prior_basic_pay) <> 0)
169: ) then
170: GHR_GHRWS52L.CPDF_Parameter_Check;
171: hr_utility.set_message(8301,'GHR_37719_ALL_PROCEDURE_FAIL');
172: hr_utility.raise_error;
173: end if;
174: end if;
175: END IF;
176:

Line 195: hr_utility.set_message(8301,'GHR_37726_ALL_PROCEDURE_FAIL');

191: if not (
192: p_prior_basic_pay = l_table_pay or (p_prior_basic_pay is null or to_number(p_prior_basic_pay) = 0)
193: ) then
194: GHR_GHRWS52L.CPDF_Parameter_Check;
195: hr_utility.set_message(8301,'GHR_37726_ALL_PROCEDURE_FAIL');
196: hr_utility.raise_error;
197: end if;
198: end if;
199:

Line 196: hr_utility.raise_error;

192: p_prior_basic_pay = l_table_pay or (p_prior_basic_pay is null or to_number(p_prior_basic_pay) = 0)
193: ) then
194: GHR_GHRWS52L.CPDF_Parameter_Check;
195: hr_utility.set_message(8301,'GHR_37726_ALL_PROCEDURE_FAIL');
196: hr_utility.raise_error;
197: end if;
198: end if;
199:
200: /* Commenting the edit as per Sept.2000 patch -- refer to doc cpdf_edits_00_sep.doc

Line 230: hr_utility.set_message(8301,'GHR_37865_ALL_PROCEDURE_FAIL');

226: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay )
227: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
228: then
229: GHR_GHRWS52L.CPDF_Parameter_Check;
230: hr_utility.set_message(8301,'GHR_37865_ALL_PROCEDURE_FAIL');
231: hr_utility.raise_error;
232: end if;
233: end if;
234: */

Line 231: hr_utility.raise_error;

227: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
228: then
229: GHR_GHRWS52L.CPDF_Parameter_Check;
230: hr_utility.set_message(8301,'GHR_37865_ALL_PROCEDURE_FAIL');
231: hr_utility.raise_error;
232: end if;
233: end if;
234: */
235:

Line 258: hr_utility.set_message(8301,'GHR_37701_ALL_PROCEDURE_FAIL');

254: (not(to_number(p_prior_basic_pay) >= min_basic_pay)
255: or p_prior_basic_pay is null)
256: then
257: GHR_GHRWS52L.CPDF_Parameter_Check;
258: hr_utility.set_message(8301,'GHR_37701_ALL_PROCEDURE_FAIL');
259: hr_utility.raise_error;
260: end if;
261: end if;
262: end if;

Line 259: hr_utility.raise_error;

255: or p_prior_basic_pay is null)
256: then
257: GHR_GHRWS52L.CPDF_Parameter_Check;
258: hr_utility.set_message(8301,'GHR_37701_ALL_PROCEDURE_FAIL');
259: hr_utility.raise_error;
260: end if;
261: end if;
262: end if;
263:

Line 294: hr_utility.set_message(8301,'GHR_37866_ALL_PROCEDURE_FAIL');

290: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay )
291: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
292: then
293: GHR_GHRWS52L.CPDF_Parameter_Check;
294: hr_utility.set_message(8301,'GHR_37866_ALL_PROCEDURE_FAIL');
295: hr_utility.raise_error;
296: end if;
297: end if;
298: */

Line 295: hr_utility.raise_error;

291: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
292: then
293: GHR_GHRWS52L.CPDF_Parameter_Check;
294: hr_utility.set_message(8301,'GHR_37866_ALL_PROCEDURE_FAIL');
295: hr_utility.raise_error;
296: end if;
297: end if;
298: */
299:

Line 330: hr_utility.set_message(8301,'GHR_37867_ALL_PROCEDURE_FAIL');

326: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay )
327: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
328: then
329: GHR_GHRWS52L.CPDF_Parameter_Check;
330: hr_utility.set_message(8301,'GHR_37867_ALL_PROCEDURE_FAIL');
331: hr_utility.raise_error;
332: end if;
333: end if;
334: */

Line 331: hr_utility.raise_error;

327: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
328: then
329: GHR_GHRWS52L.CPDF_Parameter_Check;
330: hr_utility.set_message(8301,'GHR_37867_ALL_PROCEDURE_FAIL');
331: hr_utility.raise_error;
332: end if;
333: end if;
334: */
335:

Line 364: hr_utility.set_message(8301,'GHR_37702_ALL_PROCEDURE_FAIL');

360: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay)
361: or p_prior_basic_pay is null)
362: then
363: GHR_GHRWS52L.CPDF_Parameter_Check;
364: hr_utility.set_message(8301,'GHR_37702_ALL_PROCEDURE_FAIL');
365: hr_utility.raise_error;
366: end if;
367: end if;
368: else

Line 365: hr_utility.raise_error;

361: or p_prior_basic_pay is null)
362: then
363: GHR_GHRWS52L.CPDF_Parameter_Check;
364: hr_utility.set_message(8301,'GHR_37702_ALL_PROCEDURE_FAIL');
365: hr_utility.raise_error;
366: end if;
367: end if;
368: else
369: if p_prior_pay_plan = 'GM' and

Line 387: hr_utility.set_message(8301,'GHR_37702_ALL_PROCEDURE_FAIL');

383: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay)
384: or p_prior_basic_pay is null)
385: then
386: GHR_GHRWS52L.CPDF_Parameter_Check;
387: hr_utility.set_message(8301,'GHR_37702_ALL_PROCEDURE_FAIL');
388: hr_utility.raise_error;
389: end if;
390: end if;
391: end if;

Line 388: hr_utility.raise_error;

384: or p_prior_basic_pay is null)
385: then
386: GHR_GHRWS52L.CPDF_Parameter_Check;
387: hr_utility.set_message(8301,'GHR_37702_ALL_PROCEDURE_FAIL');
388: hr_utility.raise_error;
389: end if;
390: end if;
391: end if;
392:

Line 417: hr_utility.set_message(8301,'GHR_37703_ALL_PROCEDURE_FAIL');

413: (not(to_number(p_prior_basic_pay) >= min_basic_pay)
414: or p_prior_basic_pay is null)
415: then
416: GHR_GHRWS52L.CPDF_Parameter_Check;
417: hr_utility.set_message(8301,'GHR_37703_ALL_PROCEDURE_FAIL');
418: hr_utility.set_message_token('PAY_PLAN','GM or GH');
419: hr_utility.raise_error;
420: end if;
421: end if;

Line 418: hr_utility.set_message_token('PAY_PLAN','GM or GH');

414: or p_prior_basic_pay is null)
415: then
416: GHR_GHRWS52L.CPDF_Parameter_Check;
417: hr_utility.set_message(8301,'GHR_37703_ALL_PROCEDURE_FAIL');
418: hr_utility.set_message_token('PAY_PLAN','GM or GH');
419: hr_utility.raise_error;
420: end if;
421: end if;
422: else

Line 419: hr_utility.raise_error;

415: then
416: GHR_GHRWS52L.CPDF_Parameter_Check;
417: hr_utility.set_message(8301,'GHR_37703_ALL_PROCEDURE_FAIL');
418: hr_utility.set_message_token('PAY_PLAN','GM or GH');
419: hr_utility.raise_error;
420: end if;
421: end if;
422: else
423: if p_prior_pay_plan in ('GH', 'GM','GS') and

Line 434: hr_utility.set_message(8301,'GHR_37703_ALL_PROCEDURE_FAIL');

430: (not(to_number(p_prior_basic_pay) >= min_basic_pay)
431: or p_prior_basic_pay is null)
432: then
433: GHR_GHRWS52L.CPDF_Parameter_Check;
434: hr_utility.set_message(8301,'GHR_37703_ALL_PROCEDURE_FAIL');
435: hr_utility.set_message_token('PAY_PLAN','GH, GM, or GS');
436: hr_utility.raise_error;
437: end if;
438: end if;

Line 435: hr_utility.set_message_token('PAY_PLAN','GH, GM, or GS');

431: or p_prior_basic_pay is null)
432: then
433: GHR_GHRWS52L.CPDF_Parameter_Check;
434: hr_utility.set_message(8301,'GHR_37703_ALL_PROCEDURE_FAIL');
435: hr_utility.set_message_token('PAY_PLAN','GH, GM, or GS');
436: hr_utility.raise_error;
437: end if;
438: end if;
439: end if;

Line 436: hr_utility.raise_error;

432: then
433: GHR_GHRWS52L.CPDF_Parameter_Check;
434: hr_utility.set_message(8301,'GHR_37703_ALL_PROCEDURE_FAIL');
435: hr_utility.set_message_token('PAY_PLAN','GH, GM, or GS');
436: hr_utility.raise_error;
437: end if;
438: end if;
439: end if;
440:

Line 460: hr_utility.set_message(8301,'GHR_37704_ALL_PROCEDURE_FAIL');

456: (to_number(p_prior_basic_pay) <> max_basic_pay
457: or p_prior_basic_pay is null or to_number(p_prior_basic_pay) = 0)
458: then
459: GHR_GHRWS52L.CPDF_Parameter_Check;
460: hr_utility.set_message(8301,'GHR_37704_ALL_PROCEDURE_FAIL');
461: hr_utility.raise_error;
462: end if;
463: end if;
464:

Line 461: hr_utility.raise_error;

457: or p_prior_basic_pay is null or to_number(p_prior_basic_pay) = 0)
458: then
459: GHR_GHRWS52L.CPDF_Parameter_Check;
460: hr_utility.set_message(8301,'GHR_37704_ALL_PROCEDURE_FAIL');
461: hr_utility.raise_error;
462: end if;
463: end if;
464:
465: /*570.16.2 If prior pay plan is ES or FE,

Line 491: hr_utility.set_message(8301,'GHR_37705_ALL_PROCEDURE_FAIL');

487: (p_prior_basic_pay <> max_basic_pay
488: or p_prior_basic_pay is null or to_number(p_prior_basic_pay) = 0)
489: then
490: GHR_GHRWS52L.CPDF_Parameter_Check;
491: hr_utility.set_message(8301,'GHR_37705_ALL_PROCEDURE_FAIL');
492: hr_utility.raise_error;
493: end if;
494: end if;
495: END IF; -- end dating the edit as on 10-JAN-2004

Line 492: hr_utility.raise_error;

488: or p_prior_basic_pay is null or to_number(p_prior_basic_pay) = 0)
489: then
490: GHR_GHRWS52L.CPDF_Parameter_Check;
491: hr_utility.set_message(8301,'GHR_37705_ALL_PROCEDURE_FAIL');
492: hr_utility.raise_error;
493: end if;
494: end if;
495: END IF; -- end dating the edit as on 10-JAN-2004
496:

Line 521: hr_utility.set_message(8301,'GHR_38885_ALL_PROCEDURE_FAIL');

517:
518: if not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay )
519: then
520: GHR_GHRWS52L.CPDF_Parameter_Check;
521: hr_utility.set_message(8301,'GHR_38885_ALL_PROCEDURE_FAIL');
522: -- NEED TO ADD A NEW MESSAGE HERE
523: hr_utility.raise_error;
524: end if;
525: END IF;

Line 523: hr_utility.raise_error;

519: then
520: GHR_GHRWS52L.CPDF_Parameter_Check;
521: hr_utility.set_message(8301,'GHR_38885_ALL_PROCEDURE_FAIL');
522: -- NEED TO ADD A NEW MESSAGE HERE
523: hr_utility.raise_error;
524: end if;
525: END IF;
526:
527: /*570.19.2 If prior pay plan is W-, XE, XF, XG, or XH,

Line 579: hr_utility.set_message(8301,'GHR_37706_ALL_PROCEDURE_FAIL');

575: and (not(to_number(p_prior_basic_pay) between nvl(min_basic_pay,0) and nvl(max_basic_pay,0))
576: or p_prior_basic_pay is null)
577: then
578: GHR_GHRWS52L.CPDF_Parameter_Check;
579: hr_utility.set_message(8301,'GHR_37706_ALL_PROCEDURE_FAIL');
580: hr_utility.raise_error;
581: end if;
582: end if;
583: end if; */

Line 580: hr_utility.raise_error;

576: or p_prior_basic_pay is null)
577: then
578: GHR_GHRWS52L.CPDF_Parameter_Check;
579: hr_utility.set_message(8301,'GHR_37706_ALL_PROCEDURE_FAIL');
580: hr_utility.raise_error;
581: end if;
582: end if;
583: end if; */
584: -------------------------------------------------------------------------------------------------------

Line 611: hr_utility.set_message(8301,'GHR_37707_ALL_PROCEDURE_FAIL');

607: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL then
608: if (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay) or
609: p_prior_basic_pay is null or to_number(p_prior_basic_pay) = 0) then
610: GHR_GHRWS52L.CPDF_Parameter_Check;
611: hr_utility.set_message(8301,'GHR_37707_ALL_PROCEDURE_FAIL');
612: hr_utility.raise_error;
613: end if;
614: end if;
615: end if;

Line 612: hr_utility.raise_error;

608: if (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay) or
609: p_prior_basic_pay is null or to_number(p_prior_basic_pay) = 0) then
610: GHR_GHRWS52L.CPDF_Parameter_Check;
611: hr_utility.set_message(8301,'GHR_37707_ALL_PROCEDURE_FAIL');
612: hr_utility.raise_error;
613: end if;
614: end if;
615: end if;
616: END IF;

Line 644: hr_utility.set_message(8301,'GHR_37709_ALL_PROCEDURE_FAIL');

640: if (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay) or
641: p_prior_basic_pay is null or to_number(p_prior_basic_pay) = 0)
642: then
643: GHR_GHRWS52L.CPDF_Parameter_Check;
644: hr_utility.set_message(8301,'GHR_37709_ALL_PROCEDURE_FAIL');
645: hr_utility.raise_error;
646: end if;
647: end if;
648: end if;

Line 645: hr_utility.raise_error;

641: p_prior_basic_pay is null or to_number(p_prior_basic_pay) = 0)
642: then
643: GHR_GHRWS52L.CPDF_Parameter_Check;
644: hr_utility.set_message(8301,'GHR_37709_ALL_PROCEDURE_FAIL');
645: hr_utility.raise_error;
646: end if;
647: end if;
648: end if;
649: END IF;

Line 671: hr_utility.set_message(8301,'GHR_37710_ALL_PROCEDURE_FAIL');

667: if (not (to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay )
668: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
669: then
670: GHR_GHRWS52L.CPDF_Parameter_Check;
671: hr_utility.set_message(8301,'GHR_37710_ALL_PROCEDURE_FAIL');
672: hr_utility.raise_error;
673: end if;
674: end if;
675: end if;

Line 672: hr_utility.raise_error;

668: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
669: then
670: GHR_GHRWS52L.CPDF_Parameter_Check;
671: hr_utility.set_message(8301,'GHR_37710_ALL_PROCEDURE_FAIL');
672: hr_utility.raise_error;
673: end if;
674: end if;
675: end if;
676:

Line 702: hr_utility.set_message(8301,'GHR_37711_ALL_PROCEDURE_FAIL');

698: if (not (to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay )
699: or p_prior_basic_pay is null or to_number(p_prior_basic_pay) = 0)
700: then
701: GHR_GHRWS52L.CPDF_Parameter_Check;
702: hr_utility.set_message(8301,'GHR_37711_ALL_PROCEDURE_FAIL');
703: hr_utility.raise_error;
704: end if;
705: end if;
706: end if; */

Line 703: hr_utility.raise_error;

699: or p_prior_basic_pay is null or to_number(p_prior_basic_pay) = 0)
700: then
701: GHR_GHRWS52L.CPDF_Parameter_Check;
702: hr_utility.set_message(8301,'GHR_37711_ALL_PROCEDURE_FAIL');
703: hr_utility.raise_error;
704: end if;
705: end if;
706: end if; */
707: -----------------------------------------------------------------------------------------------------------

Line 732: hr_utility.set_message(8301,'GHR_37712_ALL_PROCEDURE_FAIL');

728: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay )
729: or p_prior_basic_pay is null or to_number(p_prior_basic_pay) = 0)
730: then
731: GHR_GHRWS52L.CPDF_Parameter_Check;
732: hr_utility.set_message(8301,'GHR_37712_ALL_PROCEDURE_FAIL');
733: hr_utility.raise_error;
734: end if;
735: end if;
736: else

Line 733: hr_utility.raise_error;

729: or p_prior_basic_pay is null or to_number(p_prior_basic_pay) = 0)
730: then
731: GHR_GHRWS52L.CPDF_Parameter_Check;
732: hr_utility.set_message(8301,'GHR_37712_ALL_PROCEDURE_FAIL');
733: hr_utility.raise_error;
734: end if;
735: end if;
736: else
737: if p_prior_pay_plan = 'FM' and

Line 751: hr_utility.set_message(8301,'GHR_37712_ALL_PROCEDURE_FAIL');

747: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay )
748: or p_prior_basic_pay is null or to_number(p_prior_basic_pay) = 0)
749: then
750: GHR_GHRWS52L.CPDF_Parameter_Check;
751: hr_utility.set_message(8301,'GHR_37712_ALL_PROCEDURE_FAIL');
752: hr_utility.raise_error;
753: end if;
754: end if;
755: end if;

Line 752: hr_utility.raise_error;

748: or p_prior_basic_pay is null or to_number(p_prior_basic_pay) = 0)
749: then
750: GHR_GHRWS52L.CPDF_Parameter_Check;
751: hr_utility.set_message(8301,'GHR_37712_ALL_PROCEDURE_FAIL');
752: hr_utility.raise_error;
753: end if;
754: end if;
755: end if;
756:

Line 781: hr_utility.set_message(8301,'GHR_38405_ALL_PROCEDURE_FAIL');

777: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay )
778: or p_prior_basic_pay is null or to_number(p_prior_basic_pay) = 0)
779: then
780: GHR_GHRWS52L.CPDF_Parameter_Check;
781: hr_utility.set_message(8301,'GHR_38405_ALL_PROCEDURE_FAIL');
782: hr_utility.raise_error;
783: end if;
784: end if;
785: */

Line 782: hr_utility.raise_error;

778: or p_prior_basic_pay is null or to_number(p_prior_basic_pay) = 0)
779: then
780: GHR_GHRWS52L.CPDF_Parameter_Check;
781: hr_utility.set_message(8301,'GHR_38405_ALL_PROCEDURE_FAIL');
782: hr_utility.raise_error;
783: end if;
784: end if;
785: */
786:

Line 810: hr_utility.set_message(8301,'GHR_38406_ALL_PROCEDURE_FAIL');

806: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay )
807: or p_prior_basic_pay is null or to_number(p_prior_basic_pay) = 0)
808: then
809: GHR_GHRWS52L.CPDF_Parameter_Check;
810: hr_utility.set_message(8301,'GHR_38406_ALL_PROCEDURE_FAIL');
811: hr_utility.raise_error;
812: end if;
813: end if;
814: */

Line 811: hr_utility.raise_error;

807: or p_prior_basic_pay is null or to_number(p_prior_basic_pay) = 0)
808: then
809: GHR_GHRWS52L.CPDF_Parameter_Check;
810: hr_utility.set_message(8301,'GHR_38406_ALL_PROCEDURE_FAIL');
811: hr_utility.raise_error;
812: end if;
813: end if;
814: */
815:

Line 834: hr_utility.set_message(8301,'GHR_37714_ALL_PROCEDURE_FAIL');

830: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay )
831: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
832: then
833: GHR_GHRWS52L.CPDF_Parameter_Check;
834: hr_utility.set_message(8301,'GHR_37714_ALL_PROCEDURE_FAIL');
835: hr_utility.raise_error;
836: end if;
837: end if;
838:

Line 835: hr_utility.raise_error;

831: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
832: then
833: GHR_GHRWS52L.CPDF_Parameter_Check;
834: hr_utility.set_message(8301,'GHR_37714_ALL_PROCEDURE_FAIL');
835: hr_utility.raise_error;
836: end if;
837: end if;
838:
839: /*570.32.2 If prior pay plan is NX,

Line 859: hr_utility.set_message(8301,'GHR_37715_ALL_PROCEDURE_FAIL');

855: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay )
856: or p_prior_basic_pay is null or to_number(p_prior_basic_pay) = 0)
857: then
858: GHR_GHRWS52L.CPDF_Parameter_Check;
859: hr_utility.set_message(8301,'GHR_37715_ALL_PROCEDURE_FAIL');
860: hr_utility.raise_error;
861: end if;
862: end if;
863:

Line 860: hr_utility.raise_error;

856: or p_prior_basic_pay is null or to_number(p_prior_basic_pay) = 0)
857: then
858: GHR_GHRWS52L.CPDF_Parameter_Check;
859: hr_utility.set_message(8301,'GHR_37715_ALL_PROCEDURE_FAIL');
860: hr_utility.raise_error;
861: end if;
862: end if;
863:
864: /*570.37.2 If prior pay plan is FC,

Line 893: hr_utility.set_message(8301,'GHR_37716_ALL_PROCEDURE_FAIL');

889: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay )
890: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
891: then
892: GHR_GHRWS52L.CPDF_Parameter_Check;
893: hr_utility.set_message(8301,'GHR_37716_ALL_PROCEDURE_FAIL');
894: hr_utility.raise_error;
895: end if;
896: end if;
897:

Line 894: hr_utility.raise_error;

890: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
891: then
892: GHR_GHRWS52L.CPDF_Parameter_Check;
893: hr_utility.set_message(8301,'GHR_37716_ALL_PROCEDURE_FAIL');
894: hr_utility.raise_error;
895: end if;
896: end if;
897:
898: /*570.43.2 If prior pay plan is AF, FO, or FP,

Line 918: hr_utility.set_message(8301,'GHR_37717_ALL_PROCEDURE_FAIL');

914: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay )
915: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
916: then
917: GHR_GHRWS52L.CPDF_Parameter_Check;
918: hr_utility.set_message(8301,'GHR_37717_ALL_PROCEDURE_FAIL');
919: hr_utility.raise_error;
920: end if;
921: end if;
922:

Line 919: hr_utility.raise_error;

915: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
916: then
917: GHR_GHRWS52L.CPDF_Parameter_Check;
918: hr_utility.set_message(8301,'GHR_37717_ALL_PROCEDURE_FAIL');
919: hr_utility.raise_error;
920: end if;
921: end if;
922:
923: -- 570.45.2 If prior pay plan is FA,

Line 956: hr_utility.set_message(8301,'GHR_37718_ALL_PROCEDURE_FAIL');

952: (to_number(p_prior_basic_pay) <> max_basic_pay
953: or p_prior_basic_pay is null or to_number(p_prior_basic_pay) = 0)
954: then
955: GHR_GHRWS52L.CPDF_Parameter_Check;
956: hr_utility.set_message(8301,'GHR_37718_ALL_PROCEDURE_FAIL');
957: hr_utility.raise_error;
958: end if;
959: end if;
960: end if;

Line 957: hr_utility.raise_error;

953: or p_prior_basic_pay is null or to_number(p_prior_basic_pay) = 0)
954: then
955: GHR_GHRWS52L.CPDF_Parameter_Check;
956: hr_utility.set_message(8301,'GHR_37718_ALL_PROCEDURE_FAIL');
957: hr_utility.raise_error;
958: end if;
959: end if;
960: end if;
961:

Line 983: hr_utility.set_message(8301,'GHR_37720_ALL_PROCEDURE_FAIL');

979: (not(to_number(p_prior_basic_pay) <= max_basic_pay)
980: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
981: then
982: GHR_GHRWS52L.CPDF_Parameter_Check;
983: hr_utility.set_message(8301,'GHR_37720_ALL_PROCEDURE_FAIL');
984: hr_utility.raise_error;
985: end if;
986: end if;
987: */

Line 984: hr_utility.raise_error;

980: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
981: then
982: GHR_GHRWS52L.CPDF_Parameter_Check;
983: hr_utility.set_message(8301,'GHR_37720_ALL_PROCEDURE_FAIL');
984: hr_utility.raise_error;
985: end if;
986: end if;
987: */
988:

Line 1026: hr_utility.set_message(8301,'GHR_37074_ALL_PROCEDURE_FAIL');

1022: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay)
1023: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
1024: then
1025: GHR_GHRWS52L.CPDF_Parameter_Check;
1026: hr_utility.set_message(8301,'GHR_37074_ALL_PROCEDURE_FAIL');
1027: hr_utility.raise_error;
1028: end if;
1029: end if;
1030: */

Line 1027: hr_utility.raise_error;

1023: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
1024: then
1025: GHR_GHRWS52L.CPDF_Parameter_Check;
1026: hr_utility.set_message(8301,'GHR_37074_ALL_PROCEDURE_FAIL');
1027: hr_utility.raise_error;
1028: end if;
1029: end if;
1030: */
1031:

Line 1069: hr_utility.set_message(8301,'GHR_37075_ALL_PROCEDURE_FAIL');

1065: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay)
1066: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
1067: then
1068: GHR_GHRWS52L.CPDF_Parameter_Check;
1069: hr_utility.set_message(8301,'GHR_37075_ALL_PROCEDURE_FAIL');
1070: hr_utility.raise_error;
1071: end if;
1072: end if;
1073: */

Line 1070: hr_utility.raise_error;

1066: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
1067: then
1068: GHR_GHRWS52L.CPDF_Parameter_Check;
1069: hr_utility.set_message(8301,'GHR_37075_ALL_PROCEDURE_FAIL');
1070: hr_utility.raise_error;
1071: end if;
1072: end if;
1073: */
1074: /* Commenting the edit as per Sept.2000 patch -- refer to doc cpdf_edits_00_sep.doc

Line 1112: hr_utility.set_message(8301,'GHR_37076_ALL_PROCEDURE_FAIL');

1108: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay)
1109: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
1110: then
1111: GHR_GHRWS52L.CPDF_Parameter_Check;
1112: hr_utility.set_message(8301,'GHR_37076_ALL_PROCEDURE_FAIL');
1113: hr_utility.raise_error;
1114: end if;
1115: end if;
1116: */

Line 1113: hr_utility.raise_error;

1109: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
1110: then
1111: GHR_GHRWS52L.CPDF_Parameter_Check;
1112: hr_utility.set_message(8301,'GHR_37076_ALL_PROCEDURE_FAIL');
1113: hr_utility.raise_error;
1114: end if;
1115: end if;
1116: */
1117: /* Commenting the edit as per Sept.2000 patch -- refer to doc cpdf_edits_00_sep.doc

Line 1156: hr_utility.set_message(8301,'GHR_37077_ALL_PROCEDURE_FAIL');

1152: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay)
1153: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
1154: then
1155: GHR_GHRWS52L.CPDF_Parameter_Check;
1156: hr_utility.set_message(8301,'GHR_37077_ALL_PROCEDURE_FAIL');
1157: hr_utility.raise_error;
1158: end if;
1159: end if;
1160: */

Line 1157: hr_utility.raise_error;

1153: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
1154: then
1155: GHR_GHRWS52L.CPDF_Parameter_Check;
1156: hr_utility.set_message(8301,'GHR_37077_ALL_PROCEDURE_FAIL');
1157: hr_utility.raise_error;
1158: end if;
1159: end if;
1160: */
1161: /*570.56.2 If prior pay plan is GM,

Line 1185: hr_utility.set_message(8301,'GHR_37721_ALL_PROCEDURE_FAIL');

1181: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay)
1182: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
1183: then
1184: GHR_GHRWS52L.CPDF_Parameter_Check;
1185: hr_utility.set_message(8301,'GHR_37721_ALL_PROCEDURE_FAIL');
1186: hr_utility.raise_error;
1187: end if;
1188: end if;
1189: */

Line 1186: hr_utility.raise_error;

1182: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
1183: then
1184: GHR_GHRWS52L.CPDF_Parameter_Check;
1185: hr_utility.set_message(8301,'GHR_37721_ALL_PROCEDURE_FAIL');
1186: hr_utility.raise_error;
1187: end if;
1188: end if;
1189: */
1190: /*570.60.2 If prior pay plan is AL,

Line 1220: hr_utility.set_message(8301,'GHR_37722_ALL_PROCEDURE_FAIL');

1216: (to_number(p_prior_basic_pay) <> max_basic_pay
1217: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
1218: then
1219: GHR_GHRWS52L.CPDF_Parameter_Check;
1220: hr_utility.set_message(8301,'GHR_37722_ALL_PROCEDURE_FAIL');
1221: hr_utility.raise_error;
1222: end if;
1223: end if;
1224:

Line 1221: hr_utility.raise_error;

1217: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
1218: then
1219: GHR_GHRWS52L.CPDF_Parameter_Check;
1220: hr_utility.set_message(8301,'GHR_37722_ALL_PROCEDURE_FAIL');
1221: hr_utility.raise_error;
1222: end if;
1223: end if;
1224:
1225: /*570.65.2 If prior pay plan is CA,

Line 1246: hr_utility.set_message(8301,'GHR_37723_ALL_PROCEDURE_FAIL');

1242: (to_number(p_prior_basic_pay) <> max_basic_pay
1243: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
1244: then
1245: GHR_GHRWS52L.CPDF_Parameter_Check;
1246: hr_utility.set_message(8301,'GHR_37723_ALL_PROCEDURE_FAIL');
1247: hr_utility.raise_error;
1248: end if;
1249: end if;
1250:

Line 1247: hr_utility.raise_error;

1243: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
1244: then
1245: GHR_GHRWS52L.CPDF_Parameter_Check;
1246: hr_utility.set_message(8301,'GHR_37723_ALL_PROCEDURE_FAIL');
1247: hr_utility.raise_error;
1248: end if;
1249: end if;
1250:
1251: /*570.70.2 If prior pay plan is SL or ST,

Line 1276: hr_utility.set_message(8301,'GHR_37724_ALL_PROCEDURE_FAIL');

1272: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay)
1273: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
1274: then
1275: GHR_GHRWS52L.CPDF_Parameter_Check;
1276: hr_utility.set_message(8301,'GHR_37724_ALL_PROCEDURE_FAIL');
1277: hr_utility.raise_error;
1278: end if;
1279: end if;
1280:

Line 1277: hr_utility.raise_error;

1273: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
1274: then
1275: GHR_GHRWS52L.CPDF_Parameter_Check;
1276: hr_utility.set_message(8301,'GHR_37724_ALL_PROCEDURE_FAIL');
1277: hr_utility.raise_error;
1278: end if;
1279: end if;
1280:
1281: /* Commenting the edit as per Sept.2000 patch -- refer to doc cpdf_edits_00_sep.doc

Line 1319: hr_utility.set_message(8301,'GHR_38407_ALL_PROCEDURE_FAIL');

1315: if not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay)
1316: or p_prior_basic_pay is null
1317: then
1318: GHR_GHRWS52L.CPDF_Parameter_Check;
1319: hr_utility.set_message(8301,'GHR_38407_ALL_PROCEDURE_FAIL');
1320: hr_utility.raise_error;
1321: end if;
1322: end if;
1323: end if;

Line 1320: hr_utility.raise_error;

1316: or p_prior_basic_pay is null
1317: then
1318: GHR_GHRWS52L.CPDF_Parameter_Check;
1319: hr_utility.set_message(8301,'GHR_38407_ALL_PROCEDURE_FAIL');
1320: hr_utility.raise_error;
1321: end if;
1322: end if;
1323: end if;
1324: */

Line 1364: hr_utility.set_message(8301,'GHR_38408_ALL_PROCEDURE_FAIL');

1360: if (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay)
1361: or p_prior_basic_pay is null)
1362: then
1363: GHR_GHRWS52L.CPDF_Parameter_Check;
1364: hr_utility.set_message(8301,'GHR_38408_ALL_PROCEDURE_FAIL');
1365: hr_utility.raise_error;
1366: end if;
1367: end if;
1368: end if;

Line 1365: hr_utility.raise_error;

1361: or p_prior_basic_pay is null)
1362: then
1363: GHR_GHRWS52L.CPDF_Parameter_Check;
1364: hr_utility.set_message(8301,'GHR_38408_ALL_PROCEDURE_FAIL');
1365: hr_utility.raise_error;
1366: end if;
1367: end if;
1368: end if;
1369: */

Line 1400: hr_utility.set_message(8301,'GHR_38409_ALL_PROCEDURE_FAIL');

1396: if (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay)
1397: or p_prior_basic_pay is null)
1398: then
1399: GHR_GHRWS52L.CPDF_Parameter_Check;
1400: hr_utility.set_message(8301,'GHR_38409_ALL_PROCEDURE_FAIL');
1401: hr_utility.raise_error;
1402: end if;
1403: end if;
1404: end if;

Line 1401: hr_utility.raise_error;

1397: or p_prior_basic_pay is null)
1398: then
1399: GHR_GHRWS52L.CPDF_Parameter_Check;
1400: hr_utility.set_message(8301,'GHR_38409_ALL_PROCEDURE_FAIL');
1401: hr_utility.raise_error;
1402: end if;
1403: end if;
1404: end if;
1405: */

Line 1431: hr_utility.set_message(8301,'GHR_37725_ALL_PROCEDURE_FAIL');

1427: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay)
1428: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
1429: then
1430: GHR_GHRWS52L.CPDF_Parameter_Check;
1431: hr_utility.set_message(8301,'GHR_37725_ALL_PROCEDURE_FAIL');
1432: hr_utility.raise_error;
1433: end if;
1434: end if;
1435: */

Line 1432: hr_utility.raise_error;

1428: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
1429: then
1430: GHR_GHRWS52L.CPDF_Parameter_Check;
1431: hr_utility.set_message(8301,'GHR_37725_ALL_PROCEDURE_FAIL');
1432: hr_utility.raise_error;
1433: end if;
1434: end if;
1435: */
1436:

Line 1463: hr_utility.set_message(8301,'GHR_37727_ALL_PROCEDURE_FAIL');

1459: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay)
1460: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
1461: then
1462: GHR_GHRWS52L.CPDF_Parameter_Check;
1463: hr_utility.set_message(8301,'GHR_37727_ALL_PROCEDURE_FAIL');
1464: hr_utility.raise_error;
1465: end if;
1466: end if;
1467:

Line 1464: hr_utility.raise_error;

1460: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
1461: then
1462: GHR_GHRWS52L.CPDF_Parameter_Check;
1463: hr_utility.set_message(8301,'GHR_37727_ALL_PROCEDURE_FAIL');
1464: hr_utility.raise_error;
1465: end if;
1466: end if;
1467:
1468: /*570.83.2 If prior pay plan is IJ,

Line 1487: hr_utility.set_message(8301,'GHR_38410_ALL_PROCEDURE_FAIL');

1483: (not(to_number(p_prior_basic_pay) <> max_basic_pay)
1484: or p_prior_basic_pay is null)
1485: then
1486: GHR_GHRWS52L.CPDF_Parameter_Check;
1487: hr_utility.set_message(8301,'GHR_38410_ALL_PROCEDURE_FAIL');
1488: hr_utility.raise_error;
1489: end if;
1490: end if;
1491:

Line 1488: hr_utility.raise_error;

1484: or p_prior_basic_pay is null)
1485: then
1486: GHR_GHRWS52L.CPDF_Parameter_Check;
1487: hr_utility.set_message(8301,'GHR_38410_ALL_PROCEDURE_FAIL');
1488: hr_utility.raise_error;
1489: end if;
1490: end if;
1491:
1492: /*570.84.2 If prior pay plan is GG,

Line 1514: hr_utility.set_message(8301,'GHR_37728_ALL_PROCEDURE_FAIL');

1510: (not(to_number(p_prior_basic_pay) >= min_basic_pay)
1511: or p_prior_basic_pay is null or to_number(p_prior_basic_pay) = 0)
1512: then
1513: GHR_GHRWS52L.CPDF_Parameter_Check;
1514: hr_utility.set_message(8301,'GHR_37728_ALL_PROCEDURE_FAIL');
1515: hr_utility.raise_error;
1516: end if;
1517: end if;
1518:

Line 1515: hr_utility.raise_error;

1511: or p_prior_basic_pay is null or to_number(p_prior_basic_pay) = 0)
1512: then
1513: GHR_GHRWS52L.CPDF_Parameter_Check;
1514: hr_utility.set_message(8301,'GHR_37728_ALL_PROCEDURE_FAIL');
1515: hr_utility.raise_error;
1516: end if;
1517: end if;
1518:
1519: /*570.86.2 If prior pay plan is GH,

Line 1544: hr_utility.set_message(8301,'GHR_37729_ALL_PROCEDURE_FAIL');

1540: or p_prior_basic_pay is null
1541: or to_number(p_prior_basic_pay) = 0)
1542: then
1543: GHR_GHRWS52L.CPDF_Parameter_Check;
1544: hr_utility.set_message(8301,'GHR_37729_ALL_PROCEDURE_FAIL');
1545: hr_utility.raise_error;
1546: end if;
1547: end if;
1548: end chk_prior_basic_pay;

Line 1545: hr_utility.raise_error;

1541: or to_number(p_prior_basic_pay) = 0)
1542: then
1543: GHR_GHRWS52L.CPDF_Parameter_Check;
1544: hr_utility.set_message(8301,'GHR_37729_ALL_PROCEDURE_FAIL');
1545: hr_utility.raise_error;
1546: end if;
1547: end if;
1548: end chk_prior_basic_pay;
1549: --

Line 1623: hr_utility.set_message(8301,'GHR_37730_ALL_PROCEDURE_FAIL');

1619: if ((trunc(p_effective_date) not between l_lpa_effective_start_date and
1620: nvl(l_lpa_effective_end_date, p_effective_date)) and
1621: (p_to_locality_adj is not null and to_number(p_to_locality_adj) <> 0)) then
1622: GHR_GHRWS52L.CPDF_Parameter_Check;
1623: hr_utility.set_message(8301,'GHR_37730_ALL_PROCEDURE_FAIL');
1624: hr_utility.raise_error;
1625: end if;
1626: end if;
1627: */

Line 1624: hr_utility.raise_error;

1620: nvl(l_lpa_effective_end_date, p_effective_date)) and
1621: (p_to_locality_adj is not null and to_number(p_to_locality_adj) <> 0)) then
1622: GHR_GHRWS52L.CPDF_Parameter_Check;
1623: hr_utility.set_message(8301,'GHR_37730_ALL_PROCEDURE_FAIL');
1624: hr_utility.raise_error;
1625: end if;
1626: end if;
1627: */
1628:

Line 1653: hr_utility.set_message(8301,'GHR_37731_ALL_PROCEDURE_FAIL');

1649: l_lpa_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2) and
1650: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
1651: ) then
1652: GHR_GHRWS52L.CPDF_Parameter_Check;
1653: hr_utility.set_message(8301,'GHR_37731_ALL_PROCEDURE_FAIL');
1654: --hr_utility.set_message_token('LOC_PAY','02 through 88');
1655: hr_utility.raise_error;
1656: end if;
1657: end if;

Line 1654: --hr_utility.set_message_token('LOC_PAY','02 through 88');

1650: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
1651: ) then
1652: GHR_GHRWS52L.CPDF_Parameter_Check;
1653: hr_utility.set_message(8301,'GHR_37731_ALL_PROCEDURE_FAIL');
1654: --hr_utility.set_message_token('LOC_PAY','02 through 88');
1655: hr_utility.raise_error;
1656: end if;
1657: end if;
1658: ELSIF ( p_effective_date < to_date('01/05/2005', 'dd/mm/yyyy')) THEN

Line 1655: hr_utility.raise_error;

1651: ) then
1652: GHR_GHRWS52L.CPDF_Parameter_Check;
1653: hr_utility.set_message(8301,'GHR_37731_ALL_PROCEDURE_FAIL');
1654: --hr_utility.set_message_token('LOC_PAY','02 through 88');
1655: hr_utility.raise_error;
1656: end if;
1657: end if;
1658: ELSIF ( p_effective_date < to_date('01/05/2005', 'dd/mm/yyyy')) THEN
1659: if (

Line 1671: hr_utility.set_message(8301,'GHR_38928_ALL_PROCEDURE_FAIL ');

1667: l_lpa_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2) and
1668: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
1669: ) then
1670: GHR_GHRWS52L.CPDF_Parameter_Check;
1671: hr_utility.set_message(8301,'GHR_38928_ALL_PROCEDURE_FAIL ');
1672: hr_utility.set_message_token('PRD_LIST','0, 3, 7, J, or K');
1673: hr_utility.raise_error;
1674: end if;
1675: end if;

Line 1672: hr_utility.set_message_token('PRD_LIST','0, 3, 7, J, or K');

1668: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
1669: ) then
1670: GHR_GHRWS52L.CPDF_Parameter_Check;
1671: hr_utility.set_message(8301,'GHR_38928_ALL_PROCEDURE_FAIL ');
1672: hr_utility.set_message_token('PRD_LIST','0, 3, 7, J, or K');
1673: hr_utility.raise_error;
1674: end if;
1675: end if;
1676:

Line 1673: hr_utility.raise_error;

1669: ) then
1670: GHR_GHRWS52L.CPDF_Parameter_Check;
1671: hr_utility.set_message(8301,'GHR_38928_ALL_PROCEDURE_FAIL ');
1672: hr_utility.set_message_token('PRD_LIST','0, 3, 7, J, or K');
1673: hr_utility.raise_error;
1674: end if;
1675: end if;
1676:
1677: ELSIF (( p_effective_date >= to_date('01/05/2005', 'dd/mm/yyyy'))

Line 1694: hr_utility.set_message(8301,'GHR_38928_ALL_PROCEDURE_FAIL');

1690: l_lpa_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2) and
1691: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
1692: ) then
1693: GHR_GHRWS52L.CPDF_Parameter_Check;
1694: hr_utility.set_message(8301,'GHR_38928_ALL_PROCEDURE_FAIL');
1695: hr_utility.set_message_token('PRD_LIST','0, or 7');
1696: hr_utility.raise_error;
1697: end if;
1698: end if;

Line 1695: hr_utility.set_message_token('PRD_LIST','0, or 7');

1691: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
1692: ) then
1693: GHR_GHRWS52L.CPDF_Parameter_Check;
1694: hr_utility.set_message(8301,'GHR_38928_ALL_PROCEDURE_FAIL');
1695: hr_utility.set_message_token('PRD_LIST','0, or 7');
1696: hr_utility.raise_error;
1697: end if;
1698: end if;
1699:

Line 1696: hr_utility.raise_error;

1692: ) then
1693: GHR_GHRWS52L.CPDF_Parameter_Check;
1694: hr_utility.set_message(8301,'GHR_38928_ALL_PROCEDURE_FAIL');
1695: hr_utility.set_message_token('PRD_LIST','0, or 7');
1696: hr_utility.raise_error;
1697: end if;
1698: end if;
1699:
1700: ELSIF ( p_effective_date >= to_date('01/07/2005', 'dd/mm/yyyy')) THEN

Line 1714: hr_utility.set_message(8301,'GHR_37694_ALL_PROCEDURE_FAIL');

1710: l_lpa_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2) and
1711: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
1712: ) then
1713: GHR_GHRWS52L.CPDF_Parameter_Check;
1714: hr_utility.set_message(8301,'GHR_37694_ALL_PROCEDURE_FAIL');
1715: hr_utility.raise_error;
1716: end if;
1717: end if;
1718:

Line 1715: hr_utility.raise_error;

1711: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
1712: ) then
1713: GHR_GHRWS52L.CPDF_Parameter_Check;
1714: hr_utility.set_message(8301,'GHR_37694_ALL_PROCEDURE_FAIL');
1715: hr_utility.raise_error;
1716: end if;
1717: end if;
1718:
1719:

Line 1745: hr_utility.set_message(8301,'GHR_37747_ALL_PROCEDURE_FAIL');

1741: if (l_lpa_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2) and
1742: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
1743: ) then
1744: GHR_GHRWS52L.CPDF_Parameter_Check;
1745: hr_utility.set_message(8301,'GHR_37747_ALL_PROCEDURE_FAIL');
1746: hr_utility.raise_error;
1747: end if;
1748: end if;
1749: ELSIF ( p_effective_date < to_date('01/05/2005', 'dd/mm/yyyy')) THEN

Line 1746: hr_utility.raise_error;

1742: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
1743: ) then
1744: GHR_GHRWS52L.CPDF_Parameter_Check;
1745: hr_utility.set_message(8301,'GHR_37747_ALL_PROCEDURE_FAIL');
1746: hr_utility.raise_error;
1747: end if;
1748: end if;
1749: ELSIF ( p_effective_date < to_date('01/05/2005', 'dd/mm/yyyy')) THEN
1750: if (

Line 1761: hr_utility.set_message(8301,'GHR_38929_ALL_PROCEDURE_FAIL');

1757: if (l_lpa_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2) and
1758: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
1759: ) then
1760: GHR_GHRWS52L.CPDF_Parameter_Check;
1761: hr_utility.set_message(8301,'GHR_38929_ALL_PROCEDURE_FAIL');
1762: hr_utility.set_message_token('PRD_LIST','0, 3, 7, J, or K');
1763: hr_utility.raise_error;
1764: end if;
1765: end if;

Line 1762: hr_utility.set_message_token('PRD_LIST','0, 3, 7, J, or K');

1758: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
1759: ) then
1760: GHR_GHRWS52L.CPDF_Parameter_Check;
1761: hr_utility.set_message(8301,'GHR_38929_ALL_PROCEDURE_FAIL');
1762: hr_utility.set_message_token('PRD_LIST','0, 3, 7, J, or K');
1763: hr_utility.raise_error;
1764: end if;
1765: end if;
1766:

Line 1763: hr_utility.raise_error;

1759: ) then
1760: GHR_GHRWS52L.CPDF_Parameter_Check;
1761: hr_utility.set_message(8301,'GHR_38929_ALL_PROCEDURE_FAIL');
1762: hr_utility.set_message_token('PRD_LIST','0, 3, 7, J, or K');
1763: hr_utility.raise_error;
1764: end if;
1765: end if;
1766:
1767: ELSIF (( p_effective_date >= to_date('01/05/2005', 'dd/mm/yyyy'))

Line 1783: hr_utility.set_message(8301,'GHR_38929_ALL_PROCEDURE_FAIL');

1779: if (l_lpa_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2) and
1780: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
1781: ) then
1782: GHR_GHRWS52L.CPDF_Parameter_Check;
1783: hr_utility.set_message(8301,'GHR_38929_ALL_PROCEDURE_FAIL');
1784: hr_utility.set_message_token('PRD_LIST','0, or 7');
1785: hr_utility.raise_error;
1786: end if;
1787: end if;

Line 1784: hr_utility.set_message_token('PRD_LIST','0, or 7');

1780: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
1781: ) then
1782: GHR_GHRWS52L.CPDF_Parameter_Check;
1783: hr_utility.set_message(8301,'GHR_38929_ALL_PROCEDURE_FAIL');
1784: hr_utility.set_message_token('PRD_LIST','0, or 7');
1785: hr_utility.raise_error;
1786: end if;
1787: end if;
1788:

Line 1785: hr_utility.raise_error;

1781: ) then
1782: GHR_GHRWS52L.CPDF_Parameter_Check;
1783: hr_utility.set_message(8301,'GHR_38929_ALL_PROCEDURE_FAIL');
1784: hr_utility.set_message_token('PRD_LIST','0, or 7');
1785: hr_utility.raise_error;
1786: end if;
1787: end if;
1788:
1789: ELSIF ( p_effective_date >= to_date('01/07/2006', 'dd/mm/yyyy')) THEN

Line 1801: hr_utility.set_message(8301,'GHR_37695_ALL_PROCEDURE_FAIL');

1797: if (l_lpa_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2) and
1798: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
1799: ) then
1800: GHR_GHRWS52L.CPDF_Parameter_Check;
1801: hr_utility.set_message(8301,'GHR_37695_ALL_PROCEDURE_FAIL');
1802: hr_utility.raise_error;
1803: end if;
1804: end if;
1805:

Line 1802: hr_utility.raise_error;

1798: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
1799: ) then
1800: GHR_GHRWS52L.CPDF_Parameter_Check;
1801: hr_utility.set_message(8301,'GHR_37695_ALL_PROCEDURE_FAIL');
1802: hr_utility.raise_error;
1803: end if;
1804: end if;
1805:
1806: END IF;

Line 1842: hr_utility.set_message(8301,'GHR_37732_ALL_PROCEDURE_FAIL');

1838: l_lpa_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2) and
1839: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
1840: ) then
1841: GHR_GHRWS52L.CPDF_Parameter_Check;
1842: hr_utility.set_message(8301,'GHR_37732_ALL_PROCEDURE_FAIL');
1843: hr_utility.raise_error;
1844: end if;
1845: end if;
1846: ELSE --- meaning effective_date is greater than '1998/03/01'

Line 1843: hr_utility.raise_error;

1839: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
1840: ) then
1841: GHR_GHRWS52L.CPDF_Parameter_Check;
1842: hr_utility.set_message(8301,'GHR_37732_ALL_PROCEDURE_FAIL');
1843: hr_utility.raise_error;
1844: end if;
1845: end if;
1846: ELSE --- meaning effective_date is greater than '1998/03/01'
1847: -- this check is for dates from 01-MAR-1998 to 08-JAN-2005

Line 1861: hr_utility.set_message(8301,'GHR_37868_ALL_PROCEDURE_FAIL');

1857: l_lpa_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2) and
1858: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
1859: ) then
1860: GHR_GHRWS52L.CPDF_Parameter_Check;
1861: hr_utility.set_message(8301,'GHR_37868_ALL_PROCEDURE_FAIL');
1862: hr_utility.raise_error;
1863: end if;
1864: end if;
1865: -- FWFA Changes

Line 1862: hr_utility.raise_error;

1858: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
1859: ) then
1860: GHR_GHRWS52L.CPDF_Parameter_Check;
1861: hr_utility.set_message(8301,'GHR_37868_ALL_PROCEDURE_FAIL');
1862: hr_utility.raise_error;
1863: end if;
1864: end if;
1865: -- FWFA Changes
1866: ELSIF ( p_effective_date < to_date('01/05/2005', 'dd/mm/yyyy') ) THEN

Line 1880: hr_utility.set_message(8301,'GHR_38930_ALL_PROCEDURE_FAIL');

1876: l_lpa_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2) and
1877: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
1878: ) then
1879: GHR_GHRWS52L.CPDF_Parameter_Check;
1880: hr_utility.set_message(8301,'GHR_38930_ALL_PROCEDURE_FAIL');
1881: hr_utility.raise_error;
1882: end if;
1883: end if;
1884: -- Begin Bug# 4999292 and 4917098

Line 1881: hr_utility.raise_error;

1877: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
1878: ) then
1879: GHR_GHRWS52L.CPDF_Parameter_Check;
1880: hr_utility.set_message(8301,'GHR_38930_ALL_PROCEDURE_FAIL');
1881: hr_utility.raise_error;
1882: end if;
1883: end if;
1884: -- Begin Bug# 4999292 and 4917098
1885: /*ELSE

Line 1892: hr_utility.set_message(8301,'GHR_38981_ALL_PROCEDURE_FAIL');

1888: ) then
1889:
1890: if to_number(p_to_locality_adj) <= 0 then
1891: GHR_GHRWS52L.CPDF_Parameter_Check;
1892: hr_utility.set_message(8301,'GHR_38981_ALL_PROCEDURE_FAIL');
1893: hr_utility.raise_error;
1894: end if;
1895: end if;*/
1896: -- End Bug# 4999292 and 4917098

Line 1893: hr_utility.raise_error;

1889:
1890: if to_number(p_to_locality_adj) <= 0 then
1891: GHR_GHRWS52L.CPDF_Parameter_Check;
1892: hr_utility.set_message(8301,'GHR_38981_ALL_PROCEDURE_FAIL');
1893: hr_utility.raise_error;
1894: end if;
1895: end if;*/
1896: -- End Bug# 4999292 and 4917098
1897: -- FWFA Changes

Line 1907: hr_utility.set_message(8301,'GHR_38981_ALL_PROCEDURE_FAIL');

1903: ) then
1904:
1905: if to_number(p_to_locality_adj) <= 0 then
1906: GHR_GHRWS52L.CPDF_Parameter_Check;
1907: hr_utility.set_message(8301,'GHR_38981_ALL_PROCEDURE_FAIL');
1908: hr_utility.raise_error;
1909: end if;
1910: end if;
1911:

Line 1908: hr_utility.raise_error;

1904:
1905: if to_number(p_to_locality_adj) <= 0 then
1906: GHR_GHRWS52L.CPDF_Parameter_Check;
1907: hr_utility.set_message(8301,'GHR_38981_ALL_PROCEDURE_FAIL');
1908: hr_utility.raise_error;
1909: end if;
1910: end if;
1911:
1912: END IF; -- less or greater then 09-JAN-05 check

Line 1949: hr_utility.set_message(8301,'GHR_37748_ALL_PROCEDURE_FAIL');

1945: l_lpa_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2) and
1946: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
1947: ) then
1948: GHR_GHRWS52L.CPDF_Parameter_Check;
1949: hr_utility.set_message(8301,'GHR_37748_ALL_PROCEDURE_FAIL');
1950: hr_utility.raise_error;
1951: end if;
1952: end if;
1953: -- FWFA Changes

Line 1950: hr_utility.raise_error;

1946: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
1947: ) then
1948: GHR_GHRWS52L.CPDF_Parameter_Check;
1949: hr_utility.set_message(8301,'GHR_37748_ALL_PROCEDURE_FAIL');
1950: hr_utility.raise_error;
1951: end if;
1952: end if;
1953: -- FWFA Changes
1954: ELSIF ( p_effective_date < to_date('01/05/2005', 'dd/mm/yyyy') ) THEN

Line 1967: hr_utility.set_message(8301,'GHR_38931_ALL_PROCEDURE_FAIL');

1963: l_lpa_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2) and
1964: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
1965: ) then
1966: GHR_GHRWS52L.CPDF_Parameter_Check;
1967: hr_utility.set_message(8301,'GHR_38931_ALL_PROCEDURE_FAIL');
1968: hr_utility.raise_error;
1969: end if;
1970: end if;
1971: -- Begin Bug# 4999292

Line 1968: hr_utility.raise_error;

1964: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
1965: ) then
1966: GHR_GHRWS52L.CPDF_Parameter_Check;
1967: hr_utility.set_message(8301,'GHR_38931_ALL_PROCEDURE_FAIL');
1968: hr_utility.raise_error;
1969: end if;
1970: end if;
1971: -- Begin Bug# 4999292
1972: /*ELSIF ( p_effective_date >= to_date('01/05/2005', 'dd/mm/yyyy') ) THEN

Line 1978: hr_utility.set_message(8301,'GHR_38982_ALL_PROCEDURE_FAIL');

1974: p_to_pay_plan in ('GS','GM','GG','GH') and
1975: p_pay_rate_determinant_code in ('6','5') ) then
1976: if (to_number(p_to_locality_adj) <= 0 ) then
1977: GHR_GHRWS52L.CPDF_Parameter_Check;
1978: hr_utility.set_message(8301,'GHR_38982_ALL_PROCEDURE_FAIL');
1979: hr_utility.raise_error;
1980: end if;
1981: end if;*/
1982: -- End Bug# 4999292

Line 1979: hr_utility.raise_error;

1975: p_pay_rate_determinant_code in ('6','5') ) then
1976: if (to_number(p_to_locality_adj) <= 0 ) then
1977: GHR_GHRWS52L.CPDF_Parameter_Check;
1978: hr_utility.set_message(8301,'GHR_38982_ALL_PROCEDURE_FAIL');
1979: hr_utility.raise_error;
1980: end if;
1981: end if;*/
1982: -- End Bug# 4999292
1983: -- FWFA Changes

Line 2004: hr_utility.set_message(8301,'GHR_37733_ALL_PROCEDURE_FAIL');

2000: IF p_effective_date < fnd_date.canonical_to_date('1998/09/01') then
2001: if (p_locality_pay_area = '99' and
2002: (p_to_locality_adj is not null and to_number(p_to_locality_adj) <> 0)) then
2003: GHR_GHRWS52L.CPDF_Parameter_Check;
2004: hr_utility.set_message(8301,'GHR_37733_ALL_PROCEDURE_FAIL');
2005: hr_utility.raise_error;
2006: end if;
2007: ELSE -- meaning bet 01-SEP-1998 to 01-JAN-2005
2008: IF ( p_effective_date < to_date('09/01/2005', 'dd/mm/yyyy') ) THEN

Line 2005: hr_utility.raise_error;

2001: if (p_locality_pay_area = '99' and
2002: (p_to_locality_adj is not null and to_number(p_to_locality_adj) <> 0)) then
2003: GHR_GHRWS52L.CPDF_Parameter_Check;
2004: hr_utility.set_message(8301,'GHR_37733_ALL_PROCEDURE_FAIL');
2005: hr_utility.raise_error;
2006: end if;
2007: ELSE -- meaning bet 01-SEP-1998 to 01-JAN-2005
2008: IF ( p_effective_date < to_date('09/01/2005', 'dd/mm/yyyy') ) THEN
2009: -- If locality pay area is 99, And agency is other than AM, GY, HS, IB, or ST

Line 2014: hr_utility.set_message(8301,'GHR_37896_ALL_PROCEDURE_FAIL');

2010: -- Then locality adjustment must be spaces or asterisks.
2011: if p_locality_pay_area = '99' and
2012: p_to_locality_adj is not null and to_number(p_to_locality_adj) <> 0
2013: then
2014: hr_utility.set_message(8301,'GHR_37896_ALL_PROCEDURE_FAIL');
2015: hr_utility.raise_error;
2016: end if;
2017: --FWFA Changes
2018: ELSIF p_effective_date < to_date('2005/05/01','YYYY/MM/DD') THEN

Line 2015: hr_utility.raise_error;

2011: if p_locality_pay_area = '99' and
2012: p_to_locality_adj is not null and to_number(p_to_locality_adj) <> 0
2013: then
2014: hr_utility.set_message(8301,'GHR_37896_ALL_PROCEDURE_FAIL');
2015: hr_utility.raise_error;
2016: end if;
2017: --FWFA Changes
2018: ELSIF p_effective_date < to_date('2005/05/01','YYYY/MM/DD') THEN
2019: -- If locality pay area is 99, And agency is other than AM, GY, HS, IB, or ST

Line 2025: hr_utility.set_message(8301,'GHR_38932_ALL_PROCEDURE_FAIL');

2021: if p_locality_pay_area = 'ZZ' and
2022: p_to_locality_adj is not null and to_number(p_to_locality_adj) <> 0 and
2023: p_pay_rate_determinant_code NOT IN ('6','E','F')
2024: then
2025: hr_utility.set_message(8301,'GHR_38932_ALL_PROCEDURE_FAIL');
2026: hr_utility.raise_error;
2027: end if;
2028: ELSIF p_effective_date < to_date('2006/01/01','YYYY/MM/DD') THEN --Modified for Bug# 5073313
2029: if p_locality_pay_area = 'ZZ' and p_pay_rate_determinant_code NOT in ('6','5','E','F')

Line 2026: hr_utility.raise_error;

2022: p_to_locality_adj is not null and to_number(p_to_locality_adj) <> 0 and
2023: p_pay_rate_determinant_code NOT IN ('6','E','F')
2024: then
2025: hr_utility.set_message(8301,'GHR_38932_ALL_PROCEDURE_FAIL');
2026: hr_utility.raise_error;
2027: end if;
2028: ELSIF p_effective_date < to_date('2006/01/01','YYYY/MM/DD') THEN --Modified for Bug# 5073313
2029: if p_locality_pay_area = 'ZZ' and p_pay_rate_determinant_code NOT in ('6','5','E','F')
2030: AND p_to_locality_adj is not null and to_number(p_to_locality_adj) <> 0

Line 2032: hr_utility.set_message(8301,'GHR_38978_ALL_PROCEDURE_FAIL');

2028: ELSIF p_effective_date < to_date('2006/01/01','YYYY/MM/DD') THEN --Modified for Bug# 5073313
2029: if p_locality_pay_area = 'ZZ' and p_pay_rate_determinant_code NOT in ('6','5','E','F')
2030: AND p_to_locality_adj is not null and to_number(p_to_locality_adj) <> 0
2031: then
2032: hr_utility.set_message(8301,'GHR_38978_ALL_PROCEDURE_FAIL');
2033: hr_utility.raise_error;
2034: end if;
2035: -- Begin Bug# 5073313
2036: elsif p_effective_date < fnd_date.canonical_to_date('2006/04/01') then

Line 2033: hr_utility.raise_error;

2029: if p_locality_pay_area = 'ZZ' and p_pay_rate_determinant_code NOT in ('6','5','E','F')
2030: AND p_to_locality_adj is not null and to_number(p_to_locality_adj) <> 0
2031: then
2032: hr_utility.set_message(8301,'GHR_38978_ALL_PROCEDURE_FAIL');
2033: hr_utility.raise_error;
2034: end if;
2035: -- Begin Bug# 5073313
2036: elsif p_effective_date < fnd_date.canonical_to_date('2006/04/01') then
2037: if substr(p_agency_subelement,1,2) not in ('HS') and p_locality_pay_area = 'ZZ' and

Line 2041: hr_utility.set_message(8301,'GHR_37065_ALL_PROCEDURE_FAIL');

2037: if substr(p_agency_subelement,1,2) not in ('HS') and p_locality_pay_area = 'ZZ' and
2038: p_pay_rate_determinant_code NOT in ('6','5','E','F')
2039: AND p_to_locality_adj is not null and to_number(p_to_locality_adj) <> 0
2040: then
2041: hr_utility.set_message(8301,'GHR_37065_ALL_PROCEDURE_FAIL');
2042: hr_utility.set_message_token('PAY_PLAN','5, 6, E, or F');
2043: hr_utility.raise_error;
2044: end if;
2045: else

Line 2042: hr_utility.set_message_token('PAY_PLAN','5, 6, E, or F');

2038: p_pay_rate_determinant_code NOT in ('6','5','E','F')
2039: AND p_to_locality_adj is not null and to_number(p_to_locality_adj) <> 0
2040: then
2041: hr_utility.set_message(8301,'GHR_37065_ALL_PROCEDURE_FAIL');
2042: hr_utility.set_message_token('PAY_PLAN','5, 6, E, or F');
2043: hr_utility.raise_error;
2044: end if;
2045: else
2046: if substr(p_agency_subelement,1,2) not in ('HS') and p_locality_pay_area = 'ZZ' and

Line 2043: hr_utility.raise_error;

2039: AND p_to_locality_adj is not null and to_number(p_to_locality_adj) <> 0
2040: then
2041: hr_utility.set_message(8301,'GHR_37065_ALL_PROCEDURE_FAIL');
2042: hr_utility.set_message_token('PAY_PLAN','5, 6, E, or F');
2043: hr_utility.raise_error;
2044: end if;
2045: else
2046: if substr(p_agency_subelement,1,2) not in ('HS') and p_locality_pay_area = 'ZZ' and
2047: p_pay_rate_determinant_code NOT in ('6','5','E','F')and

Line 2051: hr_utility.set_message(8301,'GHR_37065_ALL_PROCEDURE_FAIL');

2047: p_pay_rate_determinant_code NOT in ('6','5','E','F')and
2048: p_to_pay_plan in ('GM','GS')
2049: AND p_to_locality_adj is not null and to_number(p_to_locality_adj) <> 0
2050: then
2051: hr_utility.set_message(8301,'GHR_37065_ALL_PROCEDURE_FAIL');
2052: hr_utility.set_message_token('PAY_PLAN','5, 6, E, or F, and pay plan is GM or GS');
2053: hr_utility.raise_error;
2054: end if;
2055: -- End Bug# 5073313

Line 2052: hr_utility.set_message_token('PAY_PLAN','5, 6, E, or F, and pay plan is GM or GS');

2048: p_to_pay_plan in ('GM','GS')
2049: AND p_to_locality_adj is not null and to_number(p_to_locality_adj) <> 0
2050: then
2051: hr_utility.set_message(8301,'GHR_37065_ALL_PROCEDURE_FAIL');
2052: hr_utility.set_message_token('PAY_PLAN','5, 6, E, or F, and pay plan is GM or GS');
2053: hr_utility.raise_error;
2054: end if;
2055: -- End Bug# 5073313
2056: END IF;

Line 2053: hr_utility.raise_error;

2049: AND p_to_locality_adj is not null and to_number(p_to_locality_adj) <> 0
2050: then
2051: hr_utility.set_message(8301,'GHR_37065_ALL_PROCEDURE_FAIL');
2052: hr_utility.set_message_token('PAY_PLAN','5, 6, E, or F, and pay plan is GM or GS');
2053: hr_utility.raise_error;
2054: end if;
2055: -- End Bug# 5073313
2056: END IF;
2057: -- FWFA Changes

Line 2081: hr_utility.set_message(8301,'GHR_37897_ALL_PROCEDURE_FAIL');

2077: substr(p_duty_station_code,1,2) not in ('CA','MX') or
2078: p_to_pay_plan in ('FO','FP')
2079: ) and
2080: (p_to_locality_adj is not null and to_number(p_to_locality_adj) <> 0) then
2081: hr_utility.set_message(8301,'GHR_37897_ALL_PROCEDURE_FAIL');
2082: hr_utility.raise_error;
2083: end if;
2084: end if;*/
2085:

Line 2082: hr_utility.raise_error;

2078: p_to_pay_plan in ('FO','FP')
2079: ) and
2080: (p_to_locality_adj is not null and to_number(p_to_locality_adj) <> 0) then
2081: hr_utility.set_message(8301,'GHR_37897_ALL_PROCEDURE_FAIL');
2082: hr_utility.raise_error;
2083: end if;
2084: end if;*/
2085:
2086:

Line 2106: hr_utility.set_message(8301,'GHR_37734_ALL_PROCEDURE_FAIL');

2102: p_pay_rate_determinant_code not in ('A','B','E','F','S','U','V') and
2103: (p_to_locality_adj is not null and to_number(p_to_locality_adj) <> 0)
2104: ) then
2105: GHR_GHRWS52L.CPDF_Parameter_Check;
2106: hr_utility.set_message(8301,'GHR_37734_ALL_PROCEDURE_FAIL');
2107: hr_utility.set_message_token('PRD_LIST','A, B, E, F, S, U, or V');
2108: hr_utility.raise_error;
2109: end if;
2110: ELSIF ( p_effective_date >= to_date('01/05/2005', 'dd/mm/yyyy') ) THEN

Line 2107: hr_utility.set_message_token('PRD_LIST','A, B, E, F, S, U, or V');

2103: (p_to_locality_adj is not null and to_number(p_to_locality_adj) <> 0)
2104: ) then
2105: GHR_GHRWS52L.CPDF_Parameter_Check;
2106: hr_utility.set_message(8301,'GHR_37734_ALL_PROCEDURE_FAIL');
2107: hr_utility.set_message_token('PRD_LIST','A, B, E, F, S, U, or V');
2108: hr_utility.raise_error;
2109: end if;
2110: ELSIF ( p_effective_date >= to_date('01/05/2005', 'dd/mm/yyyy') ) THEN
2111: if (

Line 2108: hr_utility.raise_error;

2104: ) then
2105: GHR_GHRWS52L.CPDF_Parameter_Check;
2106: hr_utility.set_message(8301,'GHR_37734_ALL_PROCEDURE_FAIL');
2107: hr_utility.set_message_token('PRD_LIST','A, B, E, F, S, U, or V');
2108: hr_utility.raise_error;
2109: end if;
2110: ELSIF ( p_effective_date >= to_date('01/05/2005', 'dd/mm/yyyy') ) THEN
2111: if (
2112: ( p_to_pay_plan in ('EX','ZZ','ES','FE') or

Line 2120: hr_utility.set_message(8301,'GHR_37734_ALL_PROCEDURE_FAIL');

2116: p_pay_rate_determinant_code not in ('A','B','E','F','S') and
2117: (p_to_locality_adj is not null and to_number(p_to_locality_adj) <> 0)
2118: ) then
2119: GHR_GHRWS52L.CPDF_Parameter_Check;
2120: hr_utility.set_message(8301,'GHR_37734_ALL_PROCEDURE_FAIL');
2121: hr_utility.set_message_token('PRD_LIST','A, B, E, F, or S');
2122: hr_utility.raise_error;
2123: end if;
2124: END IF;

Line 2121: hr_utility.set_message_token('PRD_LIST','A, B, E, F, or S');

2117: (p_to_locality_adj is not null and to_number(p_to_locality_adj) <> 0)
2118: ) then
2119: GHR_GHRWS52L.CPDF_Parameter_Check;
2120: hr_utility.set_message(8301,'GHR_37734_ALL_PROCEDURE_FAIL');
2121: hr_utility.set_message_token('PRD_LIST','A, B, E, F, or S');
2122: hr_utility.raise_error;
2123: end if;
2124: END IF;
2125:

Line 2122: hr_utility.raise_error;

2118: ) then
2119: GHR_GHRWS52L.CPDF_Parameter_Check;
2120: hr_utility.set_message(8301,'GHR_37734_ALL_PROCEDURE_FAIL');
2121: hr_utility.set_message_token('PRD_LIST','A, B, E, F, or S');
2122: hr_utility.raise_error;
2123: end if;
2124: END IF;
2125:
2126: -- 652.35.3

Line 2134: hr_utility.set_message(8301,'GHR_37735_ALL_PROCEDURE_FAIL');

2130: p_pay_rate_determinant_code = 'C' and
2131: (p_to_locality_adj is not null and to_number(p_to_locality_adj) <> 0)
2132: ) then
2133: GHR_GHRWS52L.CPDF_Parameter_Check;
2134: hr_utility.set_message(8301,'GHR_37735_ALL_PROCEDURE_FAIL');
2135: hr_utility.raise_error;
2136: end if;
2137: END IF;
2138: -- 652.45.1

Line 2135: hr_utility.raise_error;

2131: (p_to_locality_adj is not null and to_number(p_to_locality_adj) <> 0)
2132: ) then
2133: GHR_GHRWS52L.CPDF_Parameter_Check;
2134: hr_utility.set_message(8301,'GHR_37735_ALL_PROCEDURE_FAIL');
2135: hr_utility.raise_error;
2136: end if;
2137: END IF;
2138: -- 652.45.1
2139: -- 12/8/00 vravikan From the Start Remove GH and GM

Line 2163: hr_utility.set_message(8301,'GHR_37736_ALL_PROCEDURE_FAIL');

2159: (p_to_locality_adj is null) ) and
2160: ( p_first_noac_lookup_code <> '817' )
2161: then
2162: GHR_GHRWS52L.CPDF_Parameter_Check;
2163: hr_utility.set_message(8301,'GHR_37736_ALL_PROCEDURE_FAIL');
2164: hr_utility.raise_error;
2165: end if;
2166:
2167: ELSIF ( p_effective_date < to_date('01/05/2005', 'dd/mm/yyyy') ) THEN

Line 2164: hr_utility.raise_error;

2160: ( p_first_noac_lookup_code <> '817' )
2161: then
2162: GHR_GHRWS52L.CPDF_Parameter_Check;
2163: hr_utility.set_message(8301,'GHR_37736_ALL_PROCEDURE_FAIL');
2164: hr_utility.raise_error;
2165: end if;
2166:
2167: ELSIF ( p_effective_date < to_date('01/05/2005', 'dd/mm/yyyy') ) THEN
2168: if (p_retained_pay_plan in ('GS','GG') and

Line 2175: hr_utility.set_message(8301,'GHR_38933_ALL_PROCEDURE_FAIL');

2171: (p_to_locality_adj is null)) and
2172: ( p_first_noac_lookup_code <> '817' )
2173: then
2174: GHR_GHRWS52L.CPDF_Parameter_Check;
2175: hr_utility.set_message(8301,'GHR_38933_ALL_PROCEDURE_FAIL');
2176: hr_utility.set_message_token('PRD_LIST','A, B, E, F, U, or V');
2177: hr_utility.raise_error;
2178: end if;
2179:

Line 2176: hr_utility.set_message_token('PRD_LIST','A, B, E, F, U, or V');

2172: ( p_first_noac_lookup_code <> '817' )
2173: then
2174: GHR_GHRWS52L.CPDF_Parameter_Check;
2175: hr_utility.set_message(8301,'GHR_38933_ALL_PROCEDURE_FAIL');
2176: hr_utility.set_message_token('PRD_LIST','A, B, E, F, U, or V');
2177: hr_utility.raise_error;
2178: end if;
2179:
2180: ELSIF ( p_effective_date >= to_date('01/05/2005', 'dd/mm/yyyy') ) AND

Line 2177: hr_utility.raise_error;

2173: then
2174: GHR_GHRWS52L.CPDF_Parameter_Check;
2175: hr_utility.set_message(8301,'GHR_38933_ALL_PROCEDURE_FAIL');
2176: hr_utility.set_message_token('PRD_LIST','A, B, E, F, U, or V');
2177: hr_utility.raise_error;
2178: end if;
2179:
2180: ELSIF ( p_effective_date >= to_date('01/05/2005', 'dd/mm/yyyy') ) AND
2181: ( p_effective_date < to_date('01/07/2006', 'dd/mm/yyyy') ) THEN

Line 2188: hr_utility.set_message(8301,'GHR_38933_ALL_PROCEDURE_FAIL');

2184: p_locality_pay_area NOT IN ('ZY','ZZ') and
2185: (p_to_locality_adj is null))
2186: and ( p_first_noac_lookup_code <> '817' ) then
2187: GHR_GHRWS52L.CPDF_Parameter_Check;
2188: hr_utility.set_message(8301,'GHR_38933_ALL_PROCEDURE_FAIL');
2189: hr_utility.set_message_token('PRD_LIST','A, B, E, or F');
2190: hr_utility.raise_error;
2191: end if;
2192:

Line 2189: hr_utility.set_message_token('PRD_LIST','A, B, E, or F');

2185: (p_to_locality_adj is null))
2186: and ( p_first_noac_lookup_code <> '817' ) then
2187: GHR_GHRWS52L.CPDF_Parameter_Check;
2188: hr_utility.set_message(8301,'GHR_38933_ALL_PROCEDURE_FAIL');
2189: hr_utility.set_message_token('PRD_LIST','A, B, E, or F');
2190: hr_utility.raise_error;
2191: end if;
2192:
2193: ELSIF ( p_effective_date >= to_date('01/07/2006', 'dd/mm/yyyy') ) THEN

Line 2190: hr_utility.raise_error;

2186: and ( p_first_noac_lookup_code <> '817' ) then
2187: GHR_GHRWS52L.CPDF_Parameter_Check;
2188: hr_utility.set_message(8301,'GHR_38933_ALL_PROCEDURE_FAIL');
2189: hr_utility.set_message_token('PRD_LIST','A, B, E, or F');
2190: hr_utility.raise_error;
2191: end if;
2192:
2193: ELSIF ( p_effective_date >= to_date('01/07/2006', 'dd/mm/yyyy') ) THEN
2194: if ( p_retained_pay_plan in ('GS','GG') and

Line 2202: hr_utility.set_message(8301,'GHR_37696_ALL_PROCEDURE_FAIL');

2198: ( p_first_noac_lookup_code <> '817' )
2199: then
2200: GHR_GHRWS52L.CPDF_Parameter_Check;
2201: if ( p_effective_date < to_date('01/09/2006', 'dd/mm/yyyy') ) THEN
2202: hr_utility.set_message(8301,'GHR_37696_ALL_PROCEDURE_FAIL');
2203: hr_utility.raise_error;
2204: else
2205: hr_utility.set_message(8301,'GHR_37434_ALL_PROCEDURE_FAIL');
2206: hr_utility.raise_error;

Line 2203: hr_utility.raise_error;

2199: then
2200: GHR_GHRWS52L.CPDF_Parameter_Check;
2201: if ( p_effective_date < to_date('01/09/2006', 'dd/mm/yyyy') ) THEN
2202: hr_utility.set_message(8301,'GHR_37696_ALL_PROCEDURE_FAIL');
2203: hr_utility.raise_error;
2204: else
2205: hr_utility.set_message(8301,'GHR_37434_ALL_PROCEDURE_FAIL');
2206: hr_utility.raise_error;
2207: end if;

Line 2205: hr_utility.set_message(8301,'GHR_37434_ALL_PROCEDURE_FAIL');

2201: if ( p_effective_date < to_date('01/09/2006', 'dd/mm/yyyy') ) THEN
2202: hr_utility.set_message(8301,'GHR_37696_ALL_PROCEDURE_FAIL');
2203: hr_utility.raise_error;
2204: else
2205: hr_utility.set_message(8301,'GHR_37434_ALL_PROCEDURE_FAIL');
2206: hr_utility.raise_error;
2207: end if;
2208: end if;
2209:

Line 2206: hr_utility.raise_error;

2202: hr_utility.set_message(8301,'GHR_37696_ALL_PROCEDURE_FAIL');
2203: hr_utility.raise_error;
2204: else
2205: hr_utility.set_message(8301,'GHR_37434_ALL_PROCEDURE_FAIL');
2206: hr_utility.raise_error;
2207: end if;
2208: end if;
2209:
2210: END IF;

Line 2240: hr_utility.set_message(8301,'GHR_37737_ALL_PROCEDURE_FAIL');

2236: l_lpa_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2) and
2237: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
2238: ) then
2239: GHR_GHRWS52L.CPDF_Parameter_Check;
2240: hr_utility.set_message(8301,'GHR_37737_ALL_PROCEDURE_FAIL');
2241: hr_utility.raise_error;
2242: end if;
2243: end if;
2244: -------------------------------------------------------------------------------

Line 2241: hr_utility.raise_error;

2237: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
2238: ) then
2239: GHR_GHRWS52L.CPDF_Parameter_Check;
2240: hr_utility.set_message(8301,'GHR_37737_ALL_PROCEDURE_FAIL');
2241: hr_utility.raise_error;
2242: end if;
2243: end if;
2244: -------------------------------------------------------------------------------
2245:

Line 2272: hr_utility.set_message(8301,'GHR_37749_ALL_PROCEDURE_FAIL');

2268: l_lpa_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2) and
2269: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
2270: ) then
2271: GHR_GHRWS52L.CPDF_Parameter_Check;
2272: hr_utility.set_message(8301,'GHR_37749_ALL_PROCEDURE_FAIL');
2273: hr_utility.raise_error;
2274: end if;
2275: end if;
2276: -------------------------------------------------------------------------------

Line 2273: hr_utility.raise_error;

2269: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
2270: ) then
2271: GHR_GHRWS52L.CPDF_Parameter_Check;
2272: hr_utility.set_message(8301,'GHR_37749_ALL_PROCEDURE_FAIL');
2273: hr_utility.raise_error;
2274: end if;
2275: end if;
2276: -------------------------------------------------------------------------------
2277: -- 652.75.1

Line 2297: hr_utility.set_message(8301,'GHR_37738_ALL_PROCEDURE_FAIL');

2293: l_lpa_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2) and
2294: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
2295: ) then
2296: GHR_GHRWS52L.CPDF_Parameter_Check;
2297: hr_utility.set_message(8301,'GHR_37738_ALL_PROCEDURE_FAIL');
2298: hr_utility.raise_error;
2299: end if;
2300: end if;
2301: */

Line 2298: hr_utility.raise_error;

2294: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
2295: ) then
2296: GHR_GHRWS52L.CPDF_Parameter_Check;
2297: hr_utility.set_message(8301,'GHR_37738_ALL_PROCEDURE_FAIL');
2298: hr_utility.raise_error;
2299: end if;
2300: end if;
2301: */
2302:

Line 2325: hr_utility.set_message(8301,'GHR_37759_ALL_PROCEDURE_FAIL');

2321: round(((nvl(to_number(p_to_locality_adj),0)/to_number(p_to_basic_pay))*100),2)
2322: not between l_lpa_pct and l_leo_pct
2323: ) then
2324: GHR_GHRWS52L.CPDF_Parameter_Check;
2325: hr_utility.set_message(8301,'GHR_37759_ALL_PROCEDURE_FAIL');
2326: hr_utility.raise_error;
2327: end if;
2328: end if;
2329: ELSIF ( p_effective_date < to_date('01/05/2005', 'dd/mm/yyyy') ) THEN

Line 2326: hr_utility.raise_error;

2322: not between l_lpa_pct and l_leo_pct
2323: ) then
2324: GHR_GHRWS52L.CPDF_Parameter_Check;
2325: hr_utility.set_message(8301,'GHR_37759_ALL_PROCEDURE_FAIL');
2326: hr_utility.raise_error;
2327: end if;
2328: end if;
2329: ELSIF ( p_effective_date < to_date('01/05/2005', 'dd/mm/yyyy') ) THEN
2330: if (

Line 2340: hr_utility.set_message(8301,'GHR_38934_ALL_PROCEDURE_FAIL');

2336: round(((nvl(to_number(p_to_locality_adj),0)/to_number(p_to_basic_pay))*100),2)
2337: not between l_lpa_pct and l_leo_pct
2338: ) then
2339: GHR_GHRWS52L.CPDF_Parameter_Check;
2340: hr_utility.set_message(8301,'GHR_38934_ALL_PROCEDURE_FAIL');
2341: hr_utility.set_message_token('PRD_LIST','0, 3, 7, J, or K');
2342: hr_utility.raise_error;
2343: end if;
2344: end if;

Line 2341: hr_utility.set_message_token('PRD_LIST','0, 3, 7, J, or K');

2337: not between l_lpa_pct and l_leo_pct
2338: ) then
2339: GHR_GHRWS52L.CPDF_Parameter_Check;
2340: hr_utility.set_message(8301,'GHR_38934_ALL_PROCEDURE_FAIL');
2341: hr_utility.set_message_token('PRD_LIST','0, 3, 7, J, or K');
2342: hr_utility.raise_error;
2343: end if;
2344: end if;
2345:

Line 2342: hr_utility.raise_error;

2338: ) then
2339: GHR_GHRWS52L.CPDF_Parameter_Check;
2340: hr_utility.set_message(8301,'GHR_38934_ALL_PROCEDURE_FAIL');
2341: hr_utility.set_message_token('PRD_LIST','0, 3, 7, J, or K');
2342: hr_utility.raise_error;
2343: end if;
2344: end if;
2345:
2346: ELSIF ( p_effective_date >= to_date('01/05/2005', 'dd/mm/yyyy') )

Line 2360: hr_utility.set_message(8301,'GHR_38934_ALL_PROCEDURE_FAIL');

2356: round(((nvl(to_number(p_to_locality_adj),0)/to_number(p_to_basic_pay))*100),2)
2357: not between l_lpa_pct and l_leo_pct
2358: ) then
2359: GHR_GHRWS52L.CPDF_Parameter_Check;
2360: hr_utility.set_message(8301,'GHR_38934_ALL_PROCEDURE_FAIL');
2361: hr_utility.set_message_token('PRD_LIST','0, or 7');
2362: hr_utility.raise_error;
2363: end if;
2364: end if;

Line 2361: hr_utility.set_message_token('PRD_LIST','0, or 7');

2357: not between l_lpa_pct and l_leo_pct
2358: ) then
2359: GHR_GHRWS52L.CPDF_Parameter_Check;
2360: hr_utility.set_message(8301,'GHR_38934_ALL_PROCEDURE_FAIL');
2361: hr_utility.set_message_token('PRD_LIST','0, or 7');
2362: hr_utility.raise_error;
2363: end if;
2364: end if;
2365: END IF;

Line 2362: hr_utility.raise_error;

2358: ) then
2359: GHR_GHRWS52L.CPDF_Parameter_Check;
2360: hr_utility.set_message(8301,'GHR_38934_ALL_PROCEDURE_FAIL');
2361: hr_utility.set_message_token('PRD_LIST','0, or 7');
2362: hr_utility.raise_error;
2363: end if;
2364: end if;
2365: END IF;
2366: -------------------------------------------------------------------------------

Line 2381: hr_utility.set_message(8301,'GHR_37739_ALL_PROCEDURE_FAIL');

2377: and
2378: (p_to_locality_adj is null)
2379: ) then
2380: GHR_GHRWS52L.CPDF_Parameter_Check;
2381: hr_utility.set_message(8301,'GHR_37739_ALL_PROCEDURE_FAIL');
2382: hr_utility.raise_error;
2383: end if;
2384: */
2385: end chk_locality_adj;

Line 2382: hr_utility.raise_error;

2378: (p_to_locality_adj is null)
2379: ) then
2380: GHR_GHRWS52L.CPDF_Parameter_Check;
2381: hr_utility.set_message(8301,'GHR_37739_ALL_PROCEDURE_FAIL');
2382: hr_utility.raise_error;
2383: end if;
2384: */
2385: end chk_locality_adj;
2386: /* Name:

Line 2457: hr_utility.set_message(8301,'GHR_37741_ALL_PROCEDURE_FAIL');

2453: l_lpa_pct < round((nvl(to_number(p_prior_locality_adj),0)/to_number(p_prior_basic_pay))*100,2) and
2454: l_leo_pct < round((nvl(to_number(p_prior_locality_adj),0)/to_number(p_prior_basic_pay))*100,2)
2455: ) then
2456: GHR_GHRWS52L.CPDF_Parameter_Check;
2457: hr_utility.set_message(8301,'GHR_37741_ALL_PROCEDURE_FAIL');
2458: hr_utility.raise_error;
2459: end if;
2460: end if;
2461: end if;

Line 2458: hr_utility.raise_error;

2454: l_leo_pct < round((nvl(to_number(p_prior_locality_adj),0)/to_number(p_prior_basic_pay))*100,2)
2455: ) then
2456: GHR_GHRWS52L.CPDF_Parameter_Check;
2457: hr_utility.set_message(8301,'GHR_37741_ALL_PROCEDURE_FAIL');
2458: hr_utility.raise_error;
2459: end if;
2460: end if;
2461: end if;
2462: */

Line 2498: hr_utility.set_message(8301,'GHR_37742_ALL_PROCEDURE_FAIL');

2494: l_lpa_pct < round((to_number(p_prior_locality_adj)/to_number(p_prior_basic_pay)*100),2) and
2495: l_leo_pct < round((to_number(p_prior_locality_adj)/to_number(p_prior_basic_pay)*100),2)
2496: ) then
2497: GHR_GHRWS52L.CPDF_Parameter_Check;
2498: hr_utility.set_message(8301,'GHR_37742_ALL_PROCEDURE_FAIL');
2499: hr_utility.raise_error;
2500: end if;
2501: end if;
2502: ELSIF ( p_effective_date < to_date('01/05/2005', 'dd/mm/yyyy') ) THEN

Line 2499: hr_utility.raise_error;

2495: l_leo_pct < round((to_number(p_prior_locality_adj)/to_number(p_prior_basic_pay)*100),2)
2496: ) then
2497: GHR_GHRWS52L.CPDF_Parameter_Check;
2498: hr_utility.set_message(8301,'GHR_37742_ALL_PROCEDURE_FAIL');
2499: hr_utility.raise_error;
2500: end if;
2501: end if;
2502: ELSIF ( p_effective_date < to_date('01/05/2005', 'dd/mm/yyyy') ) THEN
2503: if (

Line 2515: hr_utility.set_message(8301,'GHR_38935_ALL_PROCEDURE_FAIL'); -- NEW MESG TOKEN REQD

2511: l_lpa_pct < round((to_number(p_prior_locality_adj)/to_number(p_prior_basic_pay)*100),2) and
2512: l_leo_pct < round((to_number(p_prior_locality_adj)/to_number(p_prior_basic_pay)*100),2)
2513: ) then
2514: GHR_GHRWS52L.CPDF_Parameter_Check;
2515: hr_utility.set_message(8301,'GHR_38935_ALL_PROCEDURE_FAIL'); -- NEW MESG TOKEN REQD
2516: hr_utility.set_message_token('PRD_LIST','0, 3, 7, J, or K');
2517: hr_utility.raise_error;
2518: end if;
2519: end if;

Line 2516: hr_utility.set_message_token('PRD_LIST','0, 3, 7, J, or K');

2512: l_leo_pct < round((to_number(p_prior_locality_adj)/to_number(p_prior_basic_pay)*100),2)
2513: ) then
2514: GHR_GHRWS52L.CPDF_Parameter_Check;
2515: hr_utility.set_message(8301,'GHR_38935_ALL_PROCEDURE_FAIL'); -- NEW MESG TOKEN REQD
2516: hr_utility.set_message_token('PRD_LIST','0, 3, 7, J, or K');
2517: hr_utility.raise_error;
2518: end if;
2519: end if;
2520:

Line 2517: hr_utility.raise_error;

2513: ) then
2514: GHR_GHRWS52L.CPDF_Parameter_Check;
2515: hr_utility.set_message(8301,'GHR_38935_ALL_PROCEDURE_FAIL'); -- NEW MESG TOKEN REQD
2516: hr_utility.set_message_token('PRD_LIST','0, 3, 7, J, or K');
2517: hr_utility.raise_error;
2518: end if;
2519: end if;
2520:
2521: ELSIF ( p_effective_date >= to_date('01/05/2005', 'dd/mm/yyyy')

Line 2537: hr_utility.set_message(8301,'GHR_38935_ALL_PROCEDURE_FAIL');

2533: l_lpa_pct < round((to_number(p_prior_locality_adj)/to_number(p_prior_basic_pay)*100),2) and
2534: l_leo_pct < round((to_number(p_prior_locality_adj)/to_number(p_prior_basic_pay)*100),2)
2535: ) then
2536: GHR_GHRWS52L.CPDF_Parameter_Check;
2537: hr_utility.set_message(8301,'GHR_38935_ALL_PROCEDURE_FAIL');
2538: hr_utility.set_message_token('PRD_LIST','0, or 7');
2539: hr_utility.raise_error;
2540: end if;
2541: end if;

Line 2538: hr_utility.set_message_token('PRD_LIST','0, or 7');

2534: l_leo_pct < round((to_number(p_prior_locality_adj)/to_number(p_prior_basic_pay)*100),2)
2535: ) then
2536: GHR_GHRWS52L.CPDF_Parameter_Check;
2537: hr_utility.set_message(8301,'GHR_38935_ALL_PROCEDURE_FAIL');
2538: hr_utility.set_message_token('PRD_LIST','0, or 7');
2539: hr_utility.raise_error;
2540: end if;
2541: end if;
2542:

Line 2539: hr_utility.raise_error;

2535: ) then
2536: GHR_GHRWS52L.CPDF_Parameter_Check;
2537: hr_utility.set_message(8301,'GHR_38935_ALL_PROCEDURE_FAIL');
2538: hr_utility.set_message_token('PRD_LIST','0, or 7');
2539: hr_utility.raise_error;
2540: end if;
2541: end if;
2542:
2543: ELSIF ( p_effective_date >= to_date('01/07/2006', 'dd/mm/yyyy') ) THEN

Line 2556: hr_utility.set_message(8301,'GHR_37697_ALL_PROCEDURE_FAIL');

2552: l_lpa_pct < round((to_number(p_prior_locality_adj)/to_number(p_prior_basic_pay)*100),2) and
2553: l_leo_pct < round((to_number(p_prior_locality_adj)/to_number(p_prior_basic_pay)*100),2)
2554: ) then
2555: GHR_GHRWS52L.CPDF_Parameter_Check;
2556: hr_utility.set_message(8301,'GHR_37697_ALL_PROCEDURE_FAIL');
2557: hr_utility.raise_error;
2558: end if;
2559: end if;
2560:

Line 2557: hr_utility.raise_error;

2553: l_leo_pct < round((to_number(p_prior_locality_adj)/to_number(p_prior_basic_pay)*100),2)
2554: ) then
2555: GHR_GHRWS52L.CPDF_Parameter_Check;
2556: hr_utility.set_message(8301,'GHR_37697_ALL_PROCEDURE_FAIL');
2557: hr_utility.raise_error;
2558: end if;
2559: end if;
2560:
2561: END IF;

Line 2601: hr_utility.set_message(8301,'GHR_37680_ALL_PROCEDURE_FAIL');

2597: l_lpa_pct < round((to_number(p_prior_locality_adj)/to_number(p_prior_basic_pay)*100),2) and
2598: l_leo_pct < round((to_number(p_prior_locality_adj)/to_number(p_prior_basic_pay)*100),2)
2599: ) then
2600: GHR_GHRWS52L.CPDF_Parameter_Check;
2601: hr_utility.set_message(8301,'GHR_37680_ALL_PROCEDURE_FAIL');
2602: hr_utility.raise_error;
2603: end if;
2604: end if;
2605: -- FWFA Changes Bug#4444609

Line 2602: hr_utility.raise_error;

2598: l_leo_pct < round((to_number(p_prior_locality_adj)/to_number(p_prior_basic_pay)*100),2)
2599: ) then
2600: GHR_GHRWS52L.CPDF_Parameter_Check;
2601: hr_utility.set_message(8301,'GHR_37680_ALL_PROCEDURE_FAIL');
2602: hr_utility.raise_error;
2603: end if;
2604: end if;
2605: -- FWFA Changes Bug#4444609
2606: ELSIF p_effective_date < to_date('2005/05/01','yyyy/mm/dd') THEN

Line 2619: hr_utility.set_message(8301,'GHR_38936_ALL_PROCEDURE_FAIL');

2615: l_lpa_pct < round((to_number(p_prior_locality_adj)/to_number(p_prior_basic_pay)*100),2) and
2616: l_leo_pct < round((to_number(p_prior_locality_adj)/to_number(p_prior_basic_pay)*100),2)
2617: ) then
2618: GHR_GHRWS52L.CPDF_Parameter_Check;
2619: hr_utility.set_message(8301,'GHR_38936_ALL_PROCEDURE_FAIL');
2620: hr_utility.raise_error;
2621: end if;
2622: end if;
2623: ELSE

Line 2620: hr_utility.raise_error;

2616: l_leo_pct < round((to_number(p_prior_locality_adj)/to_number(p_prior_basic_pay)*100),2)
2617: ) then
2618: GHR_GHRWS52L.CPDF_Parameter_Check;
2619: hr_utility.set_message(8301,'GHR_38936_ALL_PROCEDURE_FAIL');
2620: hr_utility.raise_error;
2621: end if;
2622: end if;
2623: ELSE
2624: if ( nvl(p_prior_pay_plan,hr_api.g_varchar2) in ('GS','GM','GG','GH') and

Line 2629: hr_utility.set_message(8301,'GHR_38979_ALL_PROCEDURE_FAIL');

2625: nvl(p_prior_pay_rate_det_code,hr_api.g_varchar2) in ('5','6')
2626: ) then
2627: if to_number(p_prior_locality_adj) <= 0 then
2628: GHR_GHRWS52L.CPDF_Parameter_Check;
2629: hr_utility.set_message(8301,'GHR_38979_ALL_PROCEDURE_FAIL');
2630: hr_utility.raise_error;
2631: end if;
2632: end if;
2633: END IF; -- check for 09-JAN-05 ends here

Line 2630: hr_utility.raise_error;

2626: ) then
2627: if to_number(p_prior_locality_adj) <= 0 then
2628: GHR_GHRWS52L.CPDF_Parameter_Check;
2629: hr_utility.set_message(8301,'GHR_38979_ALL_PROCEDURE_FAIL');
2630: hr_utility.raise_error;
2631: end if;
2632: end if;
2633: END IF; -- check for 09-JAN-05 ends here
2634:

Line 2656: hr_utility.set_message(8301,'GHR_37743_ALL_PROCEDURE_FAIL');

2652: IF p_effective_date < fnd_date.canonical_to_date('1998/09/01') THEN
2653: if (p_prior_locality_pay_area = '99' and
2654: (p_prior_locality_adj is not null and to_number(p_prior_locality_adj) <> 0)) then
2655: GHR_GHRWS52L.CPDF_Parameter_Check;
2656: hr_utility.set_message(8301,'GHR_37743_ALL_PROCEDURE_FAIL');
2657: hr_utility.raise_error;
2658: end if;
2659: ELSE
2660: -- between 01-SEP-98 to 09-JAN-05

Line 2657: hr_utility.raise_error;

2653: if (p_prior_locality_pay_area = '99' and
2654: (p_prior_locality_adj is not null and to_number(p_prior_locality_adj) <> 0)) then
2655: GHR_GHRWS52L.CPDF_Parameter_Check;
2656: hr_utility.set_message(8301,'GHR_37743_ALL_PROCEDURE_FAIL');
2657: hr_utility.raise_error;
2658: end if;
2659: ELSE
2660: -- between 01-SEP-98 to 09-JAN-05
2661: IF ( p_effective_date < to_date('09/01/2005', 'dd/mm/yyyy') ) THEN

Line 2670: hr_utility.set_message(8301,'GHR_37898_ALL_PROCEDURE_FAIL');

2666: p_prior_locality_adj is not null and
2667: to_number(p_prior_locality_adj) <> 0
2668: then
2669: GHR_GHRWS52L.CPDF_Parameter_Check;
2670: hr_utility.set_message(8301,'GHR_37898_ALL_PROCEDURE_FAIL');
2671: hr_utility.raise_error;
2672: end if;
2673: -- FWFA Changes
2674: ELSIF p_effective_date < to_date('2005/05/01','YYYY/MM/DD') THEN

Line 2671: hr_utility.raise_error;

2667: to_number(p_prior_locality_adj) <> 0
2668: then
2669: GHR_GHRWS52L.CPDF_Parameter_Check;
2670: hr_utility.set_message(8301,'GHR_37898_ALL_PROCEDURE_FAIL');
2671: hr_utility.raise_error;
2672: end if;
2673: -- FWFA Changes
2674: ELSIF p_effective_date < to_date('2005/05/01','YYYY/MM/DD') THEN
2675: -- If prior locality pay area is 99,

Line 2683: hr_utility.set_message(8301,'GHR_38937_ALL_PROCEDURE_FAIL');

2679: p_prior_locality_adj is not null and
2680: to_number(p_prior_locality_adj) <> 0
2681: then
2682: GHR_GHRWS52L.CPDF_Parameter_Check;
2683: hr_utility.set_message(8301,'GHR_38937_ALL_PROCEDURE_FAIL');
2684: hr_utility.raise_error;
2685: end if;
2686: ELSif p_effective_date < fnd_date.canonical_to_date('2006/04/01') then
2687: if p_prior_locality_pay_area = 'ZZ' and

Line 2684: hr_utility.raise_error;

2680: to_number(p_prior_locality_adj) <> 0
2681: then
2682: GHR_GHRWS52L.CPDF_Parameter_Check;
2683: hr_utility.set_message(8301,'GHR_38937_ALL_PROCEDURE_FAIL');
2684: hr_utility.raise_error;
2685: end if;
2686: ELSif p_effective_date < fnd_date.canonical_to_date('2006/04/01') then
2687: if p_prior_locality_pay_area = 'ZZ' and
2688: p_prior_pay_rate_det_code not in ('5','6','E','F') and

Line 2693: hr_utility.set_message(8301,'GHR_38980_ALL_PROCEDURE_FAIL');

2689: p_prior_locality_adj is not null and
2690: to_number(p_prior_locality_adj) <> 0
2691: then
2692: GHR_GHRWS52L.CPDF_Parameter_Check;
2693: hr_utility.set_message(8301,'GHR_38980_ALL_PROCEDURE_FAIL');
2694: hr_utility.raise_error;
2695: end if;
2696: ELSE
2697: if substr(p_agency_subelement,1,2) <> 'HS' and

Line 2694: hr_utility.raise_error;

2690: to_number(p_prior_locality_adj) <> 0
2691: then
2692: GHR_GHRWS52L.CPDF_Parameter_Check;
2693: hr_utility.set_message(8301,'GHR_38980_ALL_PROCEDURE_FAIL');
2694: hr_utility.raise_error;
2695: end if;
2696: ELSE
2697: if substr(p_agency_subelement,1,2) <> 'HS' and
2698: p_prior_locality_pay_area = 'ZZ' and

Line 2705: hr_utility.set_message(8301,'GHR_37162_ALL_PROCEDURE_FAIL');

2701: p_prior_locality_adj is not null and
2702: to_number(p_prior_locality_adj) <> 0
2703: then
2704: GHR_GHRWS52L.CPDF_Parameter_Check;
2705: hr_utility.set_message(8301,'GHR_37162_ALL_PROCEDURE_FAIL');
2706: hr_utility.raise_error;
2707: end if;
2708: END IF;
2709: -- FWFA Changes

Line 2706: hr_utility.raise_error;

2702: to_number(p_prior_locality_adj) <> 0
2703: then
2704: GHR_GHRWS52L.CPDF_Parameter_Check;
2705: hr_utility.set_message(8301,'GHR_37162_ALL_PROCEDURE_FAIL');
2706: hr_utility.raise_error;
2707: end if;
2708: END IF;
2709: -- FWFA Changes
2710: END IF;

Line 2733: hr_utility.set_message(8301,'GHR_37899_ALL_PROCEDURE_FAIL');

2729: substr(p_prior_duty_station,1,2) not in ('CA','MX') or
2730: p_prior_pay_plan in ('FO','FP')
2731: ) and
2732: (p_prior_locality_adj is not null and to_number(p_prior_locality_adj) <> 0) then
2733: hr_utility.set_message(8301,'GHR_37899_ALL_PROCEDURE_FAIL');
2734: hr_utility.raise_error;
2735: end if;
2736: end if;
2737: */

Line 2734: hr_utility.raise_error;

2730: p_prior_pay_plan in ('FO','FP')
2731: ) and
2732: (p_prior_locality_adj is not null and to_number(p_prior_locality_adj) <> 0) then
2733: hr_utility.set_message(8301,'GHR_37899_ALL_PROCEDURE_FAIL');
2734: hr_utility.raise_error;
2735: end if;
2736: end if;
2737: */
2738:

Line 2759: hr_utility.set_message(8301,'GHR_37744_ALL_PROCEDURE_FAIL');

2755: p_prior_pay_rate_det_code not in ('A','B','E','F','S','U','V') and
2756: (p_prior_locality_adj is not null and to_number(p_prior_locality_adj) <> 0)
2757: ) then
2758: GHR_GHRWS52L.CPDF_Parameter_Check;
2759: hr_utility.set_message(8301,'GHR_37744_ALL_PROCEDURE_FAIL');
2760: hr_utility.set_message_token('PRD_LIST','A, B, E, F, S, U, or V');
2761: hr_utility.raise_error;
2762: end if;
2763: -- Begin Fix for Bug#4879781

Line 2760: hr_utility.set_message_token('PRD_LIST','A, B, E, F, S, U, or V');

2756: (p_prior_locality_adj is not null and to_number(p_prior_locality_adj) <> 0)
2757: ) then
2758: GHR_GHRWS52L.CPDF_Parameter_Check;
2759: hr_utility.set_message(8301,'GHR_37744_ALL_PROCEDURE_FAIL');
2760: hr_utility.set_message_token('PRD_LIST','A, B, E, F, S, U, or V');
2761: hr_utility.raise_error;
2762: end if;
2763: -- Begin Fix for Bug#4879781
2764: /*ELSIF p_effective_date >= to_date('2005/05/01','YYYY/MM/DD') THEN

Line 2761: hr_utility.raise_error;

2757: ) then
2758: GHR_GHRWS52L.CPDF_Parameter_Check;
2759: hr_utility.set_message(8301,'GHR_37744_ALL_PROCEDURE_FAIL');
2760: hr_utility.set_message_token('PRD_LIST','A, B, E, F, S, U, or V');
2761: hr_utility.raise_error;
2762: end if;
2763: -- Begin Fix for Bug#4879781
2764: /*ELSIF p_effective_date >= to_date('2005/05/01','YYYY/MM/DD') THEN
2765: if (

Line 2773: hr_utility.set_message(8301,'GHR_37744_ALL_PROCEDURE_FAIL');

2769: p_prior_pay_rate_det_code not in ('A','B','E','F','S') and
2770: (p_prior_locality_adj is not null and to_number(p_prior_locality_adj) <> 0)
2771: ) then
2772: GHR_GHRWS52L.CPDF_Parameter_Check;
2773: hr_utility.set_message(8301,'GHR_37744_ALL_PROCEDURE_FAIL');
2774: hr_utility.set_message_token('PRD_LIST','A, B, E, F, or S');
2775: hr_utility.raise_error;
2776: end if;
2777: END IF;*/

Line 2774: hr_utility.set_message_token('PRD_LIST','A, B, E, F, or S');

2770: (p_prior_locality_adj is not null and to_number(p_prior_locality_adj) <> 0)
2771: ) then
2772: GHR_GHRWS52L.CPDF_Parameter_Check;
2773: hr_utility.set_message(8301,'GHR_37744_ALL_PROCEDURE_FAIL');
2774: hr_utility.set_message_token('PRD_LIST','A, B, E, F, or S');
2775: hr_utility.raise_error;
2776: end if;
2777: END IF;*/
2778: --FWFA Changes

Line 2775: hr_utility.raise_error;

2771: ) then
2772: GHR_GHRWS52L.CPDF_Parameter_Check;
2773: hr_utility.set_message(8301,'GHR_37744_ALL_PROCEDURE_FAIL');
2774: hr_utility.set_message_token('PRD_LIST','A, B, E, F, or S');
2775: hr_utility.raise_error;
2776: end if;
2777: END IF;*/
2778: --FWFA Changes
2779: -- End Fix for Bug#4879781

Line 2790: hr_utility.set_message(8301,'GHR_37745_ALL_PROCEDURE_FAIL');

2786: (p_prior_locality_adj is not null and to_number(p_prior_locality_adj) <> 0)
2787:
2788: ) then
2789: GHR_GHRWS52L.CPDF_Parameter_Check;
2790: hr_utility.set_message(8301,'GHR_37745_ALL_PROCEDURE_FAIL');
2791: hr_utility.raise_error;
2792: end if;
2793:
2794: hr_utility.set_location('Leaving CPDF 7 ',1);

Line 2791: hr_utility.raise_error;

2787:
2788: ) then
2789: GHR_GHRWS52L.CPDF_Parameter_Check;
2790: hr_utility.set_message(8301,'GHR_37745_ALL_PROCEDURE_FAIL');
2791: hr_utility.raise_error;
2792: end if;
2793:
2794: hr_utility.set_location('Leaving CPDF 7 ',1);
2795: end chk_prior_locality_adj;

Line 2794: hr_utility.set_location('Leaving CPDF 7 ',1);

2790: hr_utility.set_message(8301,'GHR_37745_ALL_PROCEDURE_FAIL');
2791: hr_utility.raise_error;
2792: end if;
2793:
2794: hr_utility.set_location('Leaving CPDF 7 ',1);
2795: end chk_prior_locality_adj;
2796: end GHR_CPDF_CHECK7;