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 82: hr_utility.set_message(8301,'GHR_37708_ALL_PROCEDURE_FAIL');

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

Line 83: hr_utility.raise_error;

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

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

112: (p_prior_pay_basis = p_to_pay_basis) ) and
113: to_number(p_prior_basic_pay) <> to_number(p_to_basic_pay))
114: ) then
115: GHR_GHRWS52L.CPDF_Parameter_Check;
116: hr_utility.set_message(8301,'GHR_37713_ALL_PROCEDURE_FAIL');
117: 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');
118: hr_utility.raise_error;
119: end if;
120: ELSif p_effective_date < fnd_date.canonical_to_date('2007/01/01') then

Line 117: 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');

113: to_number(p_prior_basic_pay) <> to_number(p_to_basic_pay))
114: ) then
115: GHR_GHRWS52L.CPDF_Parameter_Check;
116: hr_utility.set_message(8301,'GHR_37713_ALL_PROCEDURE_FAIL');
117: 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');
118: hr_utility.raise_error;
119: end if;
120: ELSif p_effective_date < fnd_date.canonical_to_date('2007/01/01') then
121: if (

Line 118: hr_utility.raise_error;

114: ) then
115: GHR_GHRWS52L.CPDF_Parameter_Check;
116: hr_utility.set_message(8301,'GHR_37713_ALL_PROCEDURE_FAIL');
117: 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');
118: hr_utility.raise_error;
119: end if;
120: ELSif p_effective_date < fnd_date.canonical_to_date('2007/01/01') then
121: if (
122: (substr(p_first_noac_lookup_code,1,1) in ('7','8') and

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

132: (p_prior_pay_basis = p_to_pay_basis) ) and
133: to_number(p_prior_basic_pay) <> to_number(p_to_basic_pay))
134: ) then
135: GHR_GHRWS52L.CPDF_Parameter_Check;
136: hr_utility.set_message(8301,'GHR_37713_ALL_PROCEDURE_FAIL');
137: 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');
138: hr_utility.raise_error;
139: end if;
140: ELSE

Line 137: 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');

133: to_number(p_prior_basic_pay) <> to_number(p_to_basic_pay))
134: ) then
135: GHR_GHRWS52L.CPDF_Parameter_Check;
136: hr_utility.set_message(8301,'GHR_37713_ALL_PROCEDURE_FAIL');
137: 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');
138: hr_utility.raise_error;
139: end if;
140: ELSE
141: if (

Line 138: hr_utility.raise_error;

134: ) then
135: GHR_GHRWS52L.CPDF_Parameter_Check;
136: hr_utility.set_message(8301,'GHR_37713_ALL_PROCEDURE_FAIL');
137: 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');
138: hr_utility.raise_error;
139: end if;
140: ELSE
141: if (
142: (substr(p_first_noac_lookup_code,1,1) in ('7','8') and

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

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

Line 157: hr_utility.raise_error;

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

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

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

Line 175: hr_utility.raise_error;

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

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

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

Line 199: hr_utility.raise_error;

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

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

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

Line 234: hr_utility.raise_error;

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

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

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

Line 262: hr_utility.raise_error;

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

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

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

Line 298: hr_utility.raise_error;

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

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

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

Line 334: hr_utility.raise_error;

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

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

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

Line 368: hr_utility.raise_error;

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

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

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

Line 391: hr_utility.raise_error;

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

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

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

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

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

Line 422: hr_utility.raise_error;

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

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

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

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

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

Line 439: hr_utility.raise_error;

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

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

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

Line 464: hr_utility.raise_error;

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

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

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

Line 495: hr_utility.raise_error;

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

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

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

Line 526: hr_utility.raise_error;

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

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

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

Line 583: hr_utility.raise_error;

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

Line 609: hr_utility.set_message(8301,'GHR_37750_ALL_PROCEDURE_FAIL');

605: if not (
606: p_prior_basic_pay = l_table_pay or (p_prior_basic_pay is null or to_number(p_prior_basic_pay) = 0)
607: ) then
608: GHR_GHRWS52L.CPDF_Parameter_Check;
609: hr_utility.set_message(8301,'GHR_37750_ALL_PROCEDURE_FAIL');
610: hr_utility.raise_error;
611: end if;
612: END IF;
613:

Line 610: hr_utility.raise_error;

606: p_prior_basic_pay = l_table_pay or (p_prior_basic_pay is null or to_number(p_prior_basic_pay) = 0)
607: ) then
608: GHR_GHRWS52L.CPDF_Parameter_Check;
609: hr_utility.set_message(8301,'GHR_37750_ALL_PROCEDURE_FAIL');
610: hr_utility.raise_error;
611: end if;
612: END IF;
613:
614: END IF;

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

637: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL then
638: if (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay) or
639: p_prior_basic_pay is null or to_number(p_prior_basic_pay) = 0) then
640: GHR_GHRWS52L.CPDF_Parameter_Check;
641: hr_utility.set_message(8301,'GHR_37707_ALL_PROCEDURE_FAIL');
642: hr_utility.raise_error;
643: end if;
644: end if;
645: end if;

Line 642: hr_utility.raise_error;

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

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

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

Line 675: hr_utility.raise_error;

671: p_prior_basic_pay is null or to_number(p_prior_basic_pay) = 0)
672: then
673: GHR_GHRWS52L.CPDF_Parameter_Check;
674: hr_utility.set_message(8301,'GHR_37709_ALL_PROCEDURE_FAIL');
675: hr_utility.raise_error;
676: end if;
677: end if;
678: end if;
679: END IF;

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

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

Line 704: hr_utility.raise_error;

700: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
701: then
702: GHR_GHRWS52L.CPDF_Parameter_Check;
703: hr_utility.set_message(8301,'GHR_37710_ALL_PROCEDURE_FAIL');
704: hr_utility.raise_error;
705: end if;
706: end if;
707: end if;
708: end if;

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

731: if (not (to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay )
732: or p_prior_basic_pay is null or to_number(p_prior_basic_pay) = 0)
733: then
734: GHR_GHRWS52L.CPDF_Parameter_Check;
735: hr_utility.set_message(8301,'GHR_37711_ALL_PROCEDURE_FAIL');
736: hr_utility.raise_error;
737: end if;
738: end if;
739: end if; */

Line 736: hr_utility.raise_error;

732: or p_prior_basic_pay is null or to_number(p_prior_basic_pay) = 0)
733: then
734: GHR_GHRWS52L.CPDF_Parameter_Check;
735: hr_utility.set_message(8301,'GHR_37711_ALL_PROCEDURE_FAIL');
736: hr_utility.raise_error;
737: end if;
738: end if;
739: end if; */
740: -----------------------------------------------------------------------------------------------------------

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

763: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay )
764: or p_prior_basic_pay is null or to_number(p_prior_basic_pay) = 0)
765: then
766: GHR_GHRWS52L.CPDF_Parameter_Check;
767: hr_utility.set_message(8301,'GHR_37712_ALL_PROCEDURE_FAIL');
768: hr_utility.raise_error;
769: end if;
770: end if;
771: else

Line 768: hr_utility.raise_error;

764: or p_prior_basic_pay is null or to_number(p_prior_basic_pay) = 0)
765: then
766: GHR_GHRWS52L.CPDF_Parameter_Check;
767: hr_utility.set_message(8301,'GHR_37712_ALL_PROCEDURE_FAIL');
768: hr_utility.raise_error;
769: end if;
770: end if;
771: else
772: if p_prior_pay_plan = 'FM' and

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

782: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay )
783: or p_prior_basic_pay is null or to_number(p_prior_basic_pay) = 0)
784: then
785: GHR_GHRWS52L.CPDF_Parameter_Check;
786: hr_utility.set_message(8301,'GHR_37712_ALL_PROCEDURE_FAIL');
787: hr_utility.raise_error;
788: end if;
789: end if;
790: end if;

Line 787: hr_utility.raise_error;

783: or p_prior_basic_pay is null or to_number(p_prior_basic_pay) = 0)
784: then
785: GHR_GHRWS52L.CPDF_Parameter_Check;
786: hr_utility.set_message(8301,'GHR_37712_ALL_PROCEDURE_FAIL');
787: hr_utility.raise_error;
788: end if;
789: end if;
790: end if;
791: end if;

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

812: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay )
813: or p_prior_basic_pay is null or to_number(p_prior_basic_pay) = 0)
814: then
815: GHR_GHRWS52L.CPDF_Parameter_Check;
816: hr_utility.set_message(8301,'GHR_38405_ALL_PROCEDURE_FAIL');
817: hr_utility.raise_error;
818: end if;
819: end if;
820: */

Line 817: hr_utility.raise_error;

813: or p_prior_basic_pay is null or to_number(p_prior_basic_pay) = 0)
814: then
815: GHR_GHRWS52L.CPDF_Parameter_Check;
816: hr_utility.set_message(8301,'GHR_38405_ALL_PROCEDURE_FAIL');
817: hr_utility.raise_error;
818: end if;
819: end if;
820: */
821:

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

841: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay )
842: or p_prior_basic_pay is null or to_number(p_prior_basic_pay) = 0)
843: then
844: GHR_GHRWS52L.CPDF_Parameter_Check;
845: hr_utility.set_message(8301,'GHR_38406_ALL_PROCEDURE_FAIL');
846: hr_utility.raise_error;
847: end if;
848: end if;
849: */

Line 846: hr_utility.raise_error;

842: or p_prior_basic_pay is null or to_number(p_prior_basic_pay) = 0)
843: then
844: GHR_GHRWS52L.CPDF_Parameter_Check;
845: hr_utility.set_message(8301,'GHR_38406_ALL_PROCEDURE_FAIL');
846: hr_utility.raise_error;
847: end if;
848: end if;
849: */
850:

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

867: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay )
868: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
869: then
870: GHR_GHRWS52L.CPDF_Parameter_Check;
871: hr_utility.set_message(8301,'GHR_37714_ALL_PROCEDURE_FAIL');
872: hr_utility.raise_error;
873: end if;
874: end if;
875: end if;

Line 872: hr_utility.raise_error;

868: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
869: then
870: GHR_GHRWS52L.CPDF_Parameter_Check;
871: hr_utility.set_message(8301,'GHR_37714_ALL_PROCEDURE_FAIL');
872: hr_utility.raise_error;
873: end if;
874: end if;
875: end if;
876: /*570.32.2 If prior pay plan is NX,

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

894: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay )
895: or p_prior_basic_pay is null or to_number(p_prior_basic_pay) = 0)
896: then
897: GHR_GHRWS52L.CPDF_Parameter_Check;
898: hr_utility.set_message(8301,'GHR_37715_ALL_PROCEDURE_FAIL');
899: hr_utility.raise_error;
900: end if;
901: end if;
902: end if;

Line 899: hr_utility.raise_error;

895: or p_prior_basic_pay is null or to_number(p_prior_basic_pay) = 0)
896: then
897: GHR_GHRWS52L.CPDF_Parameter_Check;
898: hr_utility.set_message(8301,'GHR_37715_ALL_PROCEDURE_FAIL');
899: hr_utility.raise_error;
900: end if;
901: end if;
902: end if;
903:

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

930: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay )
931: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
932: then
933: GHR_GHRWS52L.CPDF_Parameter_Check;
934: hr_utility.set_message(8301,'GHR_37716_ALL_PROCEDURE_FAIL');
935: hr_utility.raise_error;
936: end if;
937: end if;
938: end if;

Line 935: hr_utility.raise_error;

931: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
932: then
933: GHR_GHRWS52L.CPDF_Parameter_Check;
934: hr_utility.set_message(8301,'GHR_37716_ALL_PROCEDURE_FAIL');
935: hr_utility.raise_error;
936: end if;
937: end if;
938: end if;
939: /*570.43.2 If prior pay plan is AF, FO, or FP,

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

955: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay )
956: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
957: then
958: GHR_GHRWS52L.CPDF_Parameter_Check;
959: hr_utility.set_message(8301,'GHR_37717_ALL_PROCEDURE_FAIL');
960: hr_utility.raise_error;
961: end if;
962: end if;
963:

Line 960: hr_utility.raise_error;

956: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
957: then
958: GHR_GHRWS52L.CPDF_Parameter_Check;
959: hr_utility.set_message(8301,'GHR_37717_ALL_PROCEDURE_FAIL');
960: hr_utility.raise_error;
961: end if;
962: end if;
963:
964: -- 570.45.2 If prior pay plan is FA,

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

993: (to_number(p_prior_basic_pay) <> max_basic_pay
994: or p_prior_basic_pay is null or to_number(p_prior_basic_pay) = 0)
995: then
996: GHR_GHRWS52L.CPDF_Parameter_Check;
997: hr_utility.set_message(8301,'GHR_37718_ALL_PROCEDURE_FAIL');
998: hr_utility.raise_error;
999: end if;
1000: end if;
1001: end if;

Line 998: hr_utility.raise_error;

994: or p_prior_basic_pay is null or to_number(p_prior_basic_pay) = 0)
995: then
996: GHR_GHRWS52L.CPDF_Parameter_Check;
997: hr_utility.set_message(8301,'GHR_37718_ALL_PROCEDURE_FAIL');
998: hr_utility.raise_error;
999: end if;
1000: end if;
1001: end if;
1002:

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

1020: (not(to_number(p_prior_basic_pay) <= max_basic_pay)
1021: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
1022: then
1023: GHR_GHRWS52L.CPDF_Parameter_Check;
1024: hr_utility.set_message(8301,'GHR_37720_ALL_PROCEDURE_FAIL');
1025: hr_utility.raise_error;
1026: end if;
1027: end if;
1028: */

Line 1025: hr_utility.raise_error;

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

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

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

Line 1068: hr_utility.raise_error;

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

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

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

Line 1111: hr_utility.raise_error;

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

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

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

Line 1154: hr_utility.raise_error;

1150: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
1151: then
1152: GHR_GHRWS52L.CPDF_Parameter_Check;
1153: hr_utility.set_message(8301,'GHR_37076_ALL_PROCEDURE_FAIL');
1154: hr_utility.raise_error;
1155: end if;
1156: end if;
1157: */
1158: /* Commenting the edit as per Sept.2000 patch -- refer to doc cpdf_edits_00_sep.doc

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

1193: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay)
1194: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
1195: then
1196: GHR_GHRWS52L.CPDF_Parameter_Check;
1197: hr_utility.set_message(8301,'GHR_37077_ALL_PROCEDURE_FAIL');
1198: hr_utility.raise_error;
1199: end if;
1200: end if;
1201: */

Line 1198: hr_utility.raise_error;

1194: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
1195: then
1196: GHR_GHRWS52L.CPDF_Parameter_Check;
1197: hr_utility.set_message(8301,'GHR_37077_ALL_PROCEDURE_FAIL');
1198: hr_utility.raise_error;
1199: end if;
1200: end if;
1201: */
1202: /*570.56.2 If prior pay plan is GM,

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

1222: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay)
1223: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
1224: then
1225: GHR_GHRWS52L.CPDF_Parameter_Check;
1226: hr_utility.set_message(8301,'GHR_37721_ALL_PROCEDURE_FAIL');
1227: hr_utility.raise_error;
1228: end if;
1229: end if;
1230: */

Line 1227: hr_utility.raise_error;

1223: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
1224: then
1225: GHR_GHRWS52L.CPDF_Parameter_Check;
1226: hr_utility.set_message(8301,'GHR_37721_ALL_PROCEDURE_FAIL');
1227: hr_utility.raise_error;
1228: end if;
1229: end if;
1230: */
1231: /*570.60.2 If prior pay plan is AL,

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

1257: (to_number(p_prior_basic_pay) <> max_basic_pay
1258: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
1259: then
1260: GHR_GHRWS52L.CPDF_Parameter_Check;
1261: hr_utility.set_message(8301,'GHR_37722_ALL_PROCEDURE_FAIL');
1262: hr_utility.raise_error;
1263: end if;
1264: end if;
1265:

Line 1262: hr_utility.raise_error;

1258: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
1259: then
1260: GHR_GHRWS52L.CPDF_Parameter_Check;
1261: hr_utility.set_message(8301,'GHR_37722_ALL_PROCEDURE_FAIL');
1262: hr_utility.raise_error;
1263: end if;
1264: end if;
1265:
1266: /*570.65.2 If prior pay plan is CA,

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

1283: (to_number(p_prior_basic_pay) <> max_basic_pay
1284: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
1285: then
1286: GHR_GHRWS52L.CPDF_Parameter_Check;
1287: hr_utility.set_message(8301,'GHR_37723_ALL_PROCEDURE_FAIL');
1288: hr_utility.raise_error;
1289: end if;
1290: end if;
1291:

Line 1288: hr_utility.raise_error;

1284: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
1285: then
1286: GHR_GHRWS52L.CPDF_Parameter_Check;
1287: hr_utility.set_message(8301,'GHR_37723_ALL_PROCEDURE_FAIL');
1288: hr_utility.raise_error;
1289: end if;
1290: end if;
1291:
1292: /*570.70.2 If prior pay plan is SL or ST,

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

1316: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay)
1317: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
1318: then
1319: GHR_GHRWS52L.CPDF_Parameter_Check;
1320: hr_utility.set_message(8301,'GHR_37724_ALL_PROCEDURE_FAIL');
1321: hr_utility.set_message_token('PRD','not C or D');
1322: hr_utility.raise_error;
1323: end if;
1324: end if;

Line 1321: hr_utility.set_message_token('PRD','not C or D');

1317: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
1318: then
1319: GHR_GHRWS52L.CPDF_Parameter_Check;
1320: hr_utility.set_message(8301,'GHR_37724_ALL_PROCEDURE_FAIL');
1321: hr_utility.set_message_token('PRD','not C or D');
1322: hr_utility.raise_error;
1323: end if;
1324: end if;
1325: ELSE

Line 1322: hr_utility.raise_error;

1318: then
1319: GHR_GHRWS52L.CPDF_Parameter_Check;
1320: hr_utility.set_message(8301,'GHR_37724_ALL_PROCEDURE_FAIL');
1321: hr_utility.set_message_token('PRD','not C or D');
1322: hr_utility.raise_error;
1323: end if;
1324: end if;
1325: ELSE
1326: if p_prior_pay_plan in ('ST', 'SL') and

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

1338: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay)
1339: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
1340: then
1341: GHR_GHRWS52L.CPDF_Parameter_Check;
1342: hr_utility.set_message(8301,'GHR_37724_ALL_PROCEDURE_FAIL');
1343: hr_utility.set_message_token('PRD','not C');
1344: hr_utility.raise_error;
1345: end if;
1346: end if;

Line 1343: hr_utility.set_message_token('PRD','not C');

1339: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
1340: then
1341: GHR_GHRWS52L.CPDF_Parameter_Check;
1342: hr_utility.set_message(8301,'GHR_37724_ALL_PROCEDURE_FAIL');
1343: hr_utility.set_message_token('PRD','not C');
1344: hr_utility.raise_error;
1345: end if;
1346: end if;
1347: end if;

Line 1344: hr_utility.raise_error;

1340: then
1341: GHR_GHRWS52L.CPDF_Parameter_Check;
1342: hr_utility.set_message(8301,'GHR_37724_ALL_PROCEDURE_FAIL');
1343: hr_utility.set_message_token('PRD','not C');
1344: hr_utility.raise_error;
1345: end if;
1346: end if;
1347: end if;
1348:

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

1383: if not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay)
1384: or p_prior_basic_pay is null
1385: then
1386: GHR_GHRWS52L.CPDF_Parameter_Check;
1387: hr_utility.set_message(8301,'GHR_38407_ALL_PROCEDURE_FAIL');
1388: hr_utility.raise_error;
1389: end if;
1390: end if;
1391: end if;

Line 1388: hr_utility.raise_error;

1384: or p_prior_basic_pay is null
1385: then
1386: GHR_GHRWS52L.CPDF_Parameter_Check;
1387: hr_utility.set_message(8301,'GHR_38407_ALL_PROCEDURE_FAIL');
1388: hr_utility.raise_error;
1389: end if;
1390: end if;
1391: end if;
1392: */

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

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

Line 1433: hr_utility.raise_error;

1429: or p_prior_basic_pay is null)
1430: then
1431: GHR_GHRWS52L.CPDF_Parameter_Check;
1432: hr_utility.set_message(8301,'GHR_38408_ALL_PROCEDURE_FAIL');
1433: hr_utility.raise_error;
1434: end if;
1435: end if;
1436: end if;
1437: */

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

1464: if (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay)
1465: or p_prior_basic_pay is null)
1466: then
1467: GHR_GHRWS52L.CPDF_Parameter_Check;
1468: hr_utility.set_message(8301,'GHR_38409_ALL_PROCEDURE_FAIL');
1469: hr_utility.raise_error;
1470: end if;
1471: end if;
1472: end if;

Line 1469: hr_utility.raise_error;

1465: or p_prior_basic_pay is null)
1466: then
1467: GHR_GHRWS52L.CPDF_Parameter_Check;
1468: hr_utility.set_message(8301,'GHR_38409_ALL_PROCEDURE_FAIL');
1469: hr_utility.raise_error;
1470: end if;
1471: end if;
1472: end if;
1473: */

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

1495: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay)
1496: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
1497: then
1498: GHR_GHRWS52L.CPDF_Parameter_Check;
1499: hr_utility.set_message(8301,'GHR_37725_ALL_PROCEDURE_FAIL');
1500: hr_utility.raise_error;
1501: end if;
1502: end if;
1503: */

Line 1500: hr_utility.raise_error;

1496: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
1497: then
1498: GHR_GHRWS52L.CPDF_Parameter_Check;
1499: hr_utility.set_message(8301,'GHR_37725_ALL_PROCEDURE_FAIL');
1500: hr_utility.raise_error;
1501: end if;
1502: end if;
1503: */
1504:

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

1527: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay)
1528: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
1529: then
1530: GHR_GHRWS52L.CPDF_Parameter_Check;
1531: hr_utility.set_message(8301,'GHR_37727_ALL_PROCEDURE_FAIL');
1532: hr_utility.raise_error;
1533: end if;
1534: end if;
1535:

Line 1532: hr_utility.raise_error;

1528: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
1529: then
1530: GHR_GHRWS52L.CPDF_Parameter_Check;
1531: hr_utility.set_message(8301,'GHR_37727_ALL_PROCEDURE_FAIL');
1532: hr_utility.raise_error;
1533: end if;
1534: end if;
1535:
1536: /*570.83.2 If prior pay plan is IJ,

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

1553: (not(to_number(p_prior_basic_pay) <> max_basic_pay)
1554: or p_prior_basic_pay is null)
1555: then
1556: GHR_GHRWS52L.CPDF_Parameter_Check;
1557: hr_utility.set_message(8301,'GHR_38410_ALL_PROCEDURE_FAIL');
1558: hr_utility.raise_error;
1559: end if;
1560: end if;
1561: end if;

Line 1558: hr_utility.raise_error;

1554: or p_prior_basic_pay is null)
1555: then
1556: GHR_GHRWS52L.CPDF_Parameter_Check;
1557: hr_utility.set_message(8301,'GHR_38410_ALL_PROCEDURE_FAIL');
1558: hr_utility.raise_error;
1559: end if;
1560: end if;
1561: end if;
1562:

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

1582: (not(to_number(p_prior_basic_pay) >= min_basic_pay)
1583: or p_prior_basic_pay is null or to_number(p_prior_basic_pay) = 0)
1584: then
1585: GHR_GHRWS52L.CPDF_Parameter_Check;
1586: hr_utility.set_message(8301,'GHR_37728_ALL_PROCEDURE_FAIL');
1587: hr_utility.raise_error;
1588: end if;
1589: end if;
1590:

Line 1587: hr_utility.raise_error;

1583: or p_prior_basic_pay is null or to_number(p_prior_basic_pay) = 0)
1584: then
1585: GHR_GHRWS52L.CPDF_Parameter_Check;
1586: hr_utility.set_message(8301,'GHR_37728_ALL_PROCEDURE_FAIL');
1587: hr_utility.raise_error;
1588: end if;
1589: end if;
1590:
1591: /*570.86.2 If prior pay plan is GH,

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

1614: or p_prior_basic_pay is null
1615: or to_number(p_prior_basic_pay) = 0)
1616: then
1617: GHR_GHRWS52L.CPDF_Parameter_Check;
1618: hr_utility.set_message(8301,'GHR_37729_ALL_PROCEDURE_FAIL');
1619: hr_utility.raise_error;
1620: end if;
1621: end if;
1622: end if;

Line 1619: hr_utility.raise_error;

1615: or to_number(p_prior_basic_pay) = 0)
1616: then
1617: GHR_GHRWS52L.CPDF_Parameter_Check;
1618: hr_utility.set_message(8301,'GHR_37729_ALL_PROCEDURE_FAIL');
1619: hr_utility.raise_error;
1620: end if;
1621: end if;
1622: end if;
1623: end chk_prior_basic_pay;

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

1700: if ((trunc(p_effective_date) not between l_lpa_effective_start_date and
1701: nvl(l_lpa_effective_end_date, p_effective_date)) and
1702: (p_to_locality_adj is not null and to_number(p_to_locality_adj) <> 0)) then
1703: GHR_GHRWS52L.CPDF_Parameter_Check;
1704: hr_utility.set_message(8301,'GHR_37730_ALL_PROCEDURE_FAIL');
1705: hr_utility.raise_error;
1706: end if;
1707: end if;
1708: */

Line 1705: hr_utility.raise_error;

1701: nvl(l_lpa_effective_end_date, p_effective_date)) and
1702: (p_to_locality_adj is not null and to_number(p_to_locality_adj) <> 0)) then
1703: GHR_GHRWS52L.CPDF_Parameter_Check;
1704: hr_utility.set_message(8301,'GHR_37730_ALL_PROCEDURE_FAIL');
1705: hr_utility.raise_error;
1706: end if;
1707: end if;
1708: */
1709:

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

1732: l_lpa_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2) and
1733: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
1734: ) then
1735: GHR_GHRWS52L.CPDF_Parameter_Check;
1736: hr_utility.set_message(8301,'GHR_37731_ALL_PROCEDURE_FAIL');
1737: --hr_utility.set_message_token('LOC_PAY','02 through 88');
1738: hr_utility.raise_error;
1739: end if;
1740: end if;

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

1733: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
1734: ) then
1735: GHR_GHRWS52L.CPDF_Parameter_Check;
1736: hr_utility.set_message(8301,'GHR_37731_ALL_PROCEDURE_FAIL');
1737: --hr_utility.set_message_token('LOC_PAY','02 through 88');
1738: hr_utility.raise_error;
1739: end if;
1740: end if;
1741: ELSIF ( p_effective_date < to_date('01/05/2005', 'dd/mm/yyyy')) THEN

Line 1738: hr_utility.raise_error;

1734: ) then
1735: GHR_GHRWS52L.CPDF_Parameter_Check;
1736: hr_utility.set_message(8301,'GHR_37731_ALL_PROCEDURE_FAIL');
1737: --hr_utility.set_message_token('LOC_PAY','02 through 88');
1738: hr_utility.raise_error;
1739: end if;
1740: end if;
1741: ELSIF ( p_effective_date < to_date('01/05/2005', 'dd/mm/yyyy')) THEN
1742: if (

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

1750: l_lpa_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2) and
1751: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
1752: ) then
1753: GHR_GHRWS52L.CPDF_Parameter_Check;
1754: hr_utility.set_message(8301,'GHR_38928_ALL_PROCEDURE_FAIL ');
1755: hr_utility.set_message_token('PRD_LIST','0, 3, 7, J, or K');
1756: hr_utility.raise_error;
1757: end if;
1758: end if;

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

1751: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
1752: ) then
1753: GHR_GHRWS52L.CPDF_Parameter_Check;
1754: hr_utility.set_message(8301,'GHR_38928_ALL_PROCEDURE_FAIL ');
1755: hr_utility.set_message_token('PRD_LIST','0, 3, 7, J, or K');
1756: hr_utility.raise_error;
1757: end if;
1758: end if;
1759:

Line 1756: hr_utility.raise_error;

1752: ) then
1753: GHR_GHRWS52L.CPDF_Parameter_Check;
1754: hr_utility.set_message(8301,'GHR_38928_ALL_PROCEDURE_FAIL ');
1755: hr_utility.set_message_token('PRD_LIST','0, 3, 7, J, or K');
1756: hr_utility.raise_error;
1757: end if;
1758: end if;
1759:
1760: ELSIF (( p_effective_date >= to_date('01/05/2005', 'dd/mm/yyyy'))

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

1773: l_lpa_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2) and
1774: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
1775: ) then
1776: GHR_GHRWS52L.CPDF_Parameter_Check;
1777: hr_utility.set_message(8301,'GHR_38928_ALL_PROCEDURE_FAIL');
1778: hr_utility.set_message_token('PRD_LIST','0, or 7');
1779: hr_utility.raise_error;
1780: end if;
1781: end if;

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

1774: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
1775: ) then
1776: GHR_GHRWS52L.CPDF_Parameter_Check;
1777: hr_utility.set_message(8301,'GHR_38928_ALL_PROCEDURE_FAIL');
1778: hr_utility.set_message_token('PRD_LIST','0, or 7');
1779: hr_utility.raise_error;
1780: end if;
1781: end if;
1782:

Line 1779: hr_utility.raise_error;

1775: ) then
1776: GHR_GHRWS52L.CPDF_Parameter_Check;
1777: hr_utility.set_message(8301,'GHR_38928_ALL_PROCEDURE_FAIL');
1778: hr_utility.set_message_token('PRD_LIST','0, or 7');
1779: hr_utility.raise_error;
1780: end if;
1781: end if;
1782:
1783: ELSIF ( p_effective_date >= to_date('01/07/2005', 'dd/mm/yyyy'))

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

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

Line 1800: hr_utility.raise_error;

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

Line 1818: hr_utility.set_message(8301,'GHR_37456_ALL_PROCEDURE_FAIL');

1814: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2) ) OR
1815: (round(to_number(p_to_locality_adj)+to_number(p_to_basic_pay)) > l_table5_value)
1816: ) then
1817: GHR_GHRWS52L.CPDF_Parameter_Check;
1818: hr_utility.set_message(8301,'GHR_37456_ALL_PROCEDURE_FAIL');
1819: hr_utility.raise_error;
1820: end if;
1821: end if;
1822:

Line 1819: hr_utility.raise_error;

1815: (round(to_number(p_to_locality_adj)+to_number(p_to_basic_pay)) > l_table5_value)
1816: ) then
1817: GHR_GHRWS52L.CPDF_Parameter_Check;
1818: hr_utility.set_message(8301,'GHR_37456_ALL_PROCEDURE_FAIL');
1819: hr_utility.raise_error;
1820: end if;
1821: end if;
1822:
1823: END IF;

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

1847: if (l_lpa_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2) and
1848: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
1849: ) then
1850: GHR_GHRWS52L.CPDF_Parameter_Check;
1851: hr_utility.set_message(8301,'GHR_37747_ALL_PROCEDURE_FAIL');
1852: hr_utility.raise_error;
1853: end if;
1854: end if;
1855: ELSIF ( p_effective_date < to_date('01/05/2005', 'dd/mm/yyyy')) THEN

Line 1852: hr_utility.raise_error;

1848: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
1849: ) then
1850: GHR_GHRWS52L.CPDF_Parameter_Check;
1851: hr_utility.set_message(8301,'GHR_37747_ALL_PROCEDURE_FAIL');
1852: hr_utility.raise_error;
1853: end if;
1854: end if;
1855: ELSIF ( p_effective_date < to_date('01/05/2005', 'dd/mm/yyyy')) THEN
1856: if (

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

1863: if (l_lpa_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2) and
1864: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
1865: ) then
1866: GHR_GHRWS52L.CPDF_Parameter_Check;
1867: hr_utility.set_message(8301,'GHR_38929_ALL_PROCEDURE_FAIL');
1868: hr_utility.set_message_token('PRD_LIST','0, 3, 7, J, or K');
1869: hr_utility.raise_error;
1870: end if;
1871: end if;

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

1864: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
1865: ) then
1866: GHR_GHRWS52L.CPDF_Parameter_Check;
1867: hr_utility.set_message(8301,'GHR_38929_ALL_PROCEDURE_FAIL');
1868: hr_utility.set_message_token('PRD_LIST','0, 3, 7, J, or K');
1869: hr_utility.raise_error;
1870: end if;
1871: end if;
1872:

Line 1869: hr_utility.raise_error;

1865: ) then
1866: GHR_GHRWS52L.CPDF_Parameter_Check;
1867: hr_utility.set_message(8301,'GHR_38929_ALL_PROCEDURE_FAIL');
1868: hr_utility.set_message_token('PRD_LIST','0, 3, 7, J, or K');
1869: hr_utility.raise_error;
1870: end if;
1871: end if;
1872:
1873: ELSIF (( p_effective_date >= to_date('01/05/2005', 'dd/mm/yyyy'))

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

1885: if (l_lpa_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2) and
1886: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
1887: ) then
1888: GHR_GHRWS52L.CPDF_Parameter_Check;
1889: hr_utility.set_message(8301,'GHR_38929_ALL_PROCEDURE_FAIL');
1890: hr_utility.set_message_token('PRD_LIST','0, or 7');
1891: hr_utility.raise_error;
1892: end if;
1893: end if;

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

1886: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
1887: ) then
1888: GHR_GHRWS52L.CPDF_Parameter_Check;
1889: hr_utility.set_message(8301,'GHR_38929_ALL_PROCEDURE_FAIL');
1890: hr_utility.set_message_token('PRD_LIST','0, or 7');
1891: hr_utility.raise_error;
1892: end if;
1893: end if;
1894:

Line 1891: hr_utility.raise_error;

1887: ) then
1888: GHR_GHRWS52L.CPDF_Parameter_Check;
1889: hr_utility.set_message(8301,'GHR_38929_ALL_PROCEDURE_FAIL');
1890: hr_utility.set_message_token('PRD_LIST','0, or 7');
1891: hr_utility.raise_error;
1892: end if;
1893: end if;
1894:
1895: ELSIF ( p_effective_date >= to_date('01/07/2006', 'dd/mm/yyyy'))

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

1904: if (l_lpa_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2) and
1905: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
1906: ) then
1907: GHR_GHRWS52L.CPDF_Parameter_Check;
1908: hr_utility.set_message(8301,'GHR_37695_ALL_PROCEDURE_FAIL');
1909: hr_utility.raise_error;
1910: end if;
1911: end if;
1912: ELSIF p_effective_date < fnd_date.canonical_to_date('2010/01/01') THEN

Line 1909: hr_utility.raise_error;

1905: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
1906: ) then
1907: GHR_GHRWS52L.CPDF_Parameter_Check;
1908: hr_utility.set_message(8301,'GHR_37695_ALL_PROCEDURE_FAIL');
1909: hr_utility.raise_error;
1910: end if;
1911: end if;
1912: ELSIF p_effective_date < fnd_date.canonical_to_date('2010/01/01') THEN
1913: if (p_to_pay_plan in ('GS','GM','GG','GL','GH','FO','FP') and

Line 1924: hr_utility.set_message(8301,'GHR_37457_ALL_PROCEDURE_FAIL');

1920: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2) ) OR
1921: (round(to_number(p_to_locality_adj)+to_number(p_to_basic_pay)) > l_table5_value)
1922: ) then
1923: GHR_GHRWS52L.CPDF_Parameter_Check;
1924: hr_utility.set_message(8301,'GHR_37457_ALL_PROCEDURE_FAIL');
1925: hr_utility.set_message_token('LOC_AREA','ZZ');
1926: hr_utility.raise_error;
1927: end if;
1928: end if;

Line 1925: hr_utility.set_message_token('LOC_AREA','ZZ');

1921: (round(to_number(p_to_locality_adj)+to_number(p_to_basic_pay)) > l_table5_value)
1922: ) then
1923: GHR_GHRWS52L.CPDF_Parameter_Check;
1924: hr_utility.set_message(8301,'GHR_37457_ALL_PROCEDURE_FAIL');
1925: hr_utility.set_message_token('LOC_AREA','ZZ');
1926: hr_utility.raise_error;
1927: end if;
1928: end if;
1929: ELSE

Line 1926: hr_utility.raise_error;

1922: ) then
1923: GHR_GHRWS52L.CPDF_Parameter_Check;
1924: hr_utility.set_message(8301,'GHR_37457_ALL_PROCEDURE_FAIL');
1925: hr_utility.set_message_token('LOC_AREA','ZZ');
1926: hr_utility.raise_error;
1927: end if;
1928: end if;
1929: ELSE
1930: if (p_to_pay_plan in ('GS','GM','GG','GL','GH','FO','FP') and

Line 1941: hr_utility.set_message(8301,'GHR_37457_ALL_PROCEDURE_FAIL');

1937: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2) ) OR
1938: (round(to_number(p_to_locality_adj)+to_number(p_to_basic_pay)) > l_table5_value)
1939: ) then
1940: GHR_GHRWS52L.CPDF_Parameter_Check;
1941: hr_utility.set_message(8301,'GHR_37457_ALL_PROCEDURE_FAIL');
1942: hr_utility.set_message_token('LOC_AREA','AK, HI, ON, ZZ');
1943: hr_utility.raise_error;
1944: end if;
1945: end if;

Line 1942: hr_utility.set_message_token('LOC_AREA','AK, HI, ON, ZZ');

1938: (round(to_number(p_to_locality_adj)+to_number(p_to_basic_pay)) > l_table5_value)
1939: ) then
1940: GHR_GHRWS52L.CPDF_Parameter_Check;
1941: hr_utility.set_message(8301,'GHR_37457_ALL_PROCEDURE_FAIL');
1942: hr_utility.set_message_token('LOC_AREA','AK, HI, ON, ZZ');
1943: hr_utility.raise_error;
1944: end if;
1945: end if;
1946: END IF;

Line 1943: hr_utility.raise_error;

1939: ) then
1940: GHR_GHRWS52L.CPDF_Parameter_Check;
1941: hr_utility.set_message(8301,'GHR_37457_ALL_PROCEDURE_FAIL');
1942: hr_utility.set_message_token('LOC_AREA','AK, HI, ON, ZZ');
1943: hr_utility.raise_error;
1944: end if;
1945: end if;
1946: END IF;
1947: -------------------------------------------------------------------------------

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

1980: l_lpa_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2) and
1981: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
1982: ) then
1983: GHR_GHRWS52L.CPDF_Parameter_Check;
1984: hr_utility.set_message(8301,'GHR_37732_ALL_PROCEDURE_FAIL');
1985: hr_utility.raise_error;
1986: end if;
1987: end if;
1988: ELSE --- meaning effective_date is greater than '1998/03/01'

Line 1985: hr_utility.raise_error;

1981: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
1982: ) then
1983: GHR_GHRWS52L.CPDF_Parameter_Check;
1984: hr_utility.set_message(8301,'GHR_37732_ALL_PROCEDURE_FAIL');
1985: hr_utility.raise_error;
1986: end if;
1987: end if;
1988: ELSE --- meaning effective_date is greater than '1998/03/01'
1989: -- this check is for dates from 01-MAR-1998 to 08-JAN-2005

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

1999: l_lpa_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2) and
2000: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
2001: ) then
2002: GHR_GHRWS52L.CPDF_Parameter_Check;
2003: hr_utility.set_message(8301,'GHR_37868_ALL_PROCEDURE_FAIL');
2004: hr_utility.raise_error;
2005: end if;
2006: end if;
2007: -- FWFA Changes

Line 2004: hr_utility.raise_error;

2000: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
2001: ) then
2002: GHR_GHRWS52L.CPDF_Parameter_Check;
2003: hr_utility.set_message(8301,'GHR_37868_ALL_PROCEDURE_FAIL');
2004: hr_utility.raise_error;
2005: end if;
2006: end if;
2007: -- FWFA Changes
2008: ELSIF ( p_effective_date < to_date('01/05/2005', 'dd/mm/yyyy') ) THEN

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

2018: l_lpa_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2) and
2019: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
2020: ) then
2021: GHR_GHRWS52L.CPDF_Parameter_Check;
2022: hr_utility.set_message(8301,'GHR_38930_ALL_PROCEDURE_FAIL');
2023: hr_utility.raise_error;
2024: end if;
2025: end if;
2026: -- Begin Bug# 4999292 and 4917098

Line 2023: hr_utility.raise_error;

2019: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
2020: ) then
2021: GHR_GHRWS52L.CPDF_Parameter_Check;
2022: hr_utility.set_message(8301,'GHR_38930_ALL_PROCEDURE_FAIL');
2023: hr_utility.raise_error;
2024: end if;
2025: end if;
2026: -- Begin Bug# 4999292 and 4917098
2027: /*ELSE

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

2030: ) then
2031:
2032: if to_number(p_to_locality_adj) <= 0 then
2033: GHR_GHRWS52L.CPDF_Parameter_Check;
2034: hr_utility.set_message(8301,'GHR_38981_ALL_PROCEDURE_FAIL');
2035: hr_utility.raise_error;
2036: end if;
2037: end if;*/
2038: -- End Bug# 4999292 and 4917098

Line 2035: hr_utility.raise_error;

2031:
2032: if to_number(p_to_locality_adj) <= 0 then
2033: GHR_GHRWS52L.CPDF_Parameter_Check;
2034: hr_utility.set_message(8301,'GHR_38981_ALL_PROCEDURE_FAIL');
2035: hr_utility.raise_error;
2036: end if;
2037: end if;*/
2038: -- End Bug# 4999292 and 4917098
2039: -- FWFA Changes

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

2045: ) then
2046:
2047: if to_number(p_to_locality_adj) <= 0 then
2048: GHR_GHRWS52L.CPDF_Parameter_Check;
2049: hr_utility.set_message(8301,'GHR_38981_ALL_PROCEDURE_FAIL');
2050: hr_utility.raise_error;
2051: end if;
2052: end if;
2053:

Line 2050: hr_utility.raise_error;

2046:
2047: if to_number(p_to_locality_adj) <= 0 then
2048: GHR_GHRWS52L.CPDF_Parameter_Check;
2049: hr_utility.set_message(8301,'GHR_38981_ALL_PROCEDURE_FAIL');
2050: hr_utility.raise_error;
2051: end if;
2052: end if;
2053:
2054: END IF; -- less or greater then 09-JAN-05 check

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

2087: l_lpa_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2) and
2088: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
2089: ) then
2090: GHR_GHRWS52L.CPDF_Parameter_Check;
2091: hr_utility.set_message(8301,'GHR_37748_ALL_PROCEDURE_FAIL');
2092: hr_utility.raise_error;
2093: end if;
2094: end if;
2095: -- FWFA Changes

Line 2092: hr_utility.raise_error;

2088: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
2089: ) then
2090: GHR_GHRWS52L.CPDF_Parameter_Check;
2091: hr_utility.set_message(8301,'GHR_37748_ALL_PROCEDURE_FAIL');
2092: hr_utility.raise_error;
2093: end if;
2094: end if;
2095: -- FWFA Changes
2096: ELSIF ( p_effective_date < to_date('01/05/2005', 'dd/mm/yyyy') ) THEN

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

2105: l_lpa_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2) and
2106: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
2107: ) then
2108: GHR_GHRWS52L.CPDF_Parameter_Check;
2109: hr_utility.set_message(8301,'GHR_38931_ALL_PROCEDURE_FAIL');
2110: hr_utility.raise_error;
2111: end if;
2112: end if;
2113: -- Begin Bug# 4999292

Line 2110: hr_utility.raise_error;

2106: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
2107: ) then
2108: GHR_GHRWS52L.CPDF_Parameter_Check;
2109: hr_utility.set_message(8301,'GHR_38931_ALL_PROCEDURE_FAIL');
2110: hr_utility.raise_error;
2111: end if;
2112: end if;
2113: -- Begin Bug# 4999292
2114: /*ELSIF ( p_effective_date >= to_date('01/05/2005', 'dd/mm/yyyy') ) THEN

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

2116: p_to_pay_plan in ('GS','GM','GG','GH') and
2117: p_pay_rate_determinant_code in ('6','5') ) then
2118: if (to_number(p_to_locality_adj) <= 0 ) then
2119: GHR_GHRWS52L.CPDF_Parameter_Check;
2120: hr_utility.set_message(8301,'GHR_38982_ALL_PROCEDURE_FAIL');
2121: hr_utility.raise_error;
2122: end if;
2123: end if;*/
2124: -- End Bug# 4999292

Line 2121: hr_utility.raise_error;

2117: p_pay_rate_determinant_code in ('6','5') ) then
2118: if (to_number(p_to_locality_adj) <= 0 ) then
2119: GHR_GHRWS52L.CPDF_Parameter_Check;
2120: hr_utility.set_message(8301,'GHR_38982_ALL_PROCEDURE_FAIL');
2121: hr_utility.raise_error;
2122: end if;
2123: end if;*/
2124: -- End Bug# 4999292
2125: -- FWFA Changes

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

2142: IF p_effective_date < fnd_date.canonical_to_date('1998/09/01') then
2143: if (p_locality_pay_area = '99' and
2144: (p_to_locality_adj is not null and to_number(p_to_locality_adj) <> 0)) then
2145: GHR_GHRWS52L.CPDF_Parameter_Check;
2146: hr_utility.set_message(8301,'GHR_37733_ALL_PROCEDURE_FAIL');
2147: hr_utility.raise_error;
2148: end if;
2149: ELSE -- meaning bet 01-SEP-1998 to 01-JAN-2005
2150: IF ( p_effective_date < to_date('09/01/2005', 'dd/mm/yyyy') ) THEN

Line 2147: hr_utility.raise_error;

2143: if (p_locality_pay_area = '99' and
2144: (p_to_locality_adj is not null and to_number(p_to_locality_adj) <> 0)) then
2145: GHR_GHRWS52L.CPDF_Parameter_Check;
2146: hr_utility.set_message(8301,'GHR_37733_ALL_PROCEDURE_FAIL');
2147: hr_utility.raise_error;
2148: end if;
2149: ELSE -- meaning bet 01-SEP-1998 to 01-JAN-2005
2150: IF ( p_effective_date < to_date('09/01/2005', 'dd/mm/yyyy') ) THEN
2151: -- If locality pay area is 99, And agency is other than AM, GY, HS, IB, or ST

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

2152: -- Then locality adjustment must be spaces or asterisks.
2153: if p_locality_pay_area = '99' and
2154: p_to_locality_adj is not null and to_number(p_to_locality_adj) <> 0
2155: then
2156: hr_utility.set_message(8301,'GHR_37896_ALL_PROCEDURE_FAIL');
2157: hr_utility.raise_error;
2158: end if;
2159: --FWFA Changes
2160: ELSIF p_effective_date < to_date('2005/05/01','YYYY/MM/DD') THEN

Line 2157: hr_utility.raise_error;

2153: if p_locality_pay_area = '99' and
2154: p_to_locality_adj is not null and to_number(p_to_locality_adj) <> 0
2155: then
2156: hr_utility.set_message(8301,'GHR_37896_ALL_PROCEDURE_FAIL');
2157: hr_utility.raise_error;
2158: end if;
2159: --FWFA Changes
2160: ELSIF p_effective_date < to_date('2005/05/01','YYYY/MM/DD') THEN
2161: -- If locality pay area is 99, And agency is other than AM, GY, HS, IB, or ST

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

2163: if p_locality_pay_area = 'ZZ' and
2164: p_to_locality_adj is not null and to_number(p_to_locality_adj) <> 0 and
2165: p_pay_rate_determinant_code NOT IN ('6','E','F')
2166: then
2167: hr_utility.set_message(8301,'GHR_38932_ALL_PROCEDURE_FAIL');
2168: hr_utility.raise_error;
2169: end if;
2170: ELSIF p_effective_date < to_date('2006/01/01','YYYY/MM/DD') THEN --Modified for Bug# 5073313
2171: if p_locality_pay_area = 'ZZ' and p_pay_rate_determinant_code NOT in ('6','5','E','F')

Line 2168: hr_utility.raise_error;

2164: p_to_locality_adj is not null and to_number(p_to_locality_adj) <> 0 and
2165: p_pay_rate_determinant_code NOT IN ('6','E','F')
2166: then
2167: hr_utility.set_message(8301,'GHR_38932_ALL_PROCEDURE_FAIL');
2168: hr_utility.raise_error;
2169: end if;
2170: ELSIF p_effective_date < to_date('2006/01/01','YYYY/MM/DD') THEN --Modified for Bug# 5073313
2171: if p_locality_pay_area = 'ZZ' and p_pay_rate_determinant_code NOT in ('6','5','E','F')
2172: AND p_to_locality_adj is not null and to_number(p_to_locality_adj) <> 0

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

2170: ELSIF p_effective_date < to_date('2006/01/01','YYYY/MM/DD') THEN --Modified for Bug# 5073313
2171: if p_locality_pay_area = 'ZZ' and p_pay_rate_determinant_code NOT in ('6','5','E','F')
2172: AND p_to_locality_adj is not null and to_number(p_to_locality_adj) <> 0
2173: then
2174: hr_utility.set_message(8301,'GHR_38978_ALL_PROCEDURE_FAIL');
2175: hr_utility.raise_error;
2176: end if;
2177: -- Begin Bug# 5073313
2178: elsif p_effective_date < fnd_date.canonical_to_date('2006/04/01') then

Line 2175: hr_utility.raise_error;

2171: if p_locality_pay_area = 'ZZ' and p_pay_rate_determinant_code NOT in ('6','5','E','F')
2172: AND p_to_locality_adj is not null and to_number(p_to_locality_adj) <> 0
2173: then
2174: hr_utility.set_message(8301,'GHR_38978_ALL_PROCEDURE_FAIL');
2175: hr_utility.raise_error;
2176: end if;
2177: -- Begin Bug# 5073313
2178: elsif p_effective_date < fnd_date.canonical_to_date('2006/04/01') then
2179: if substr(p_agency_subelement,1,2) not in ('HS') and p_locality_pay_area = 'ZZ' and

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

2179: if substr(p_agency_subelement,1,2) not in ('HS') and p_locality_pay_area = 'ZZ' and
2180: p_pay_rate_determinant_code NOT in ('6','5','E','F')
2181: AND p_to_locality_adj is not null and to_number(p_to_locality_adj) <> 0
2182: then
2183: hr_utility.set_message(8301,'GHR_37065_ALL_PROCEDURE_FAIL');
2184: hr_utility.set_message_token('PAY_PLAN','5, 6, E, or F');
2185: hr_utility.raise_error;
2186: end if;
2187: else

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

2180: p_pay_rate_determinant_code NOT in ('6','5','E','F')
2181: AND p_to_locality_adj is not null and to_number(p_to_locality_adj) <> 0
2182: then
2183: hr_utility.set_message(8301,'GHR_37065_ALL_PROCEDURE_FAIL');
2184: hr_utility.set_message_token('PAY_PLAN','5, 6, E, or F');
2185: hr_utility.raise_error;
2186: end if;
2187: else
2188: if substr(p_agency_subelement,1,2) not in ('HS') and p_locality_pay_area = 'ZZ' and

Line 2185: hr_utility.raise_error;

2181: AND p_to_locality_adj is not null and to_number(p_to_locality_adj) <> 0
2182: then
2183: hr_utility.set_message(8301,'GHR_37065_ALL_PROCEDURE_FAIL');
2184: hr_utility.set_message_token('PAY_PLAN','5, 6, E, or F');
2185: hr_utility.raise_error;
2186: end if;
2187: else
2188: if substr(p_agency_subelement,1,2) not in ('HS') and p_locality_pay_area = 'ZZ' and
2189: p_pay_rate_determinant_code NOT in ('6','5','E','F')and

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

2189: p_pay_rate_determinant_code NOT in ('6','5','E','F')and
2190: p_to_pay_plan in ('GM','GS')
2191: AND p_to_locality_adj is not null and to_number(p_to_locality_adj) <> 0
2192: then
2193: hr_utility.set_message(8301,'GHR_37065_ALL_PROCEDURE_FAIL');
2194: hr_utility.set_message_token('PAY_PLAN','5, 6, E, or F, and pay plan is GM or GS');
2195: hr_utility.raise_error;
2196: end if;
2197: -- End Bug# 5073313

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

2190: p_to_pay_plan in ('GM','GS')
2191: AND p_to_locality_adj is not null and to_number(p_to_locality_adj) <> 0
2192: then
2193: hr_utility.set_message(8301,'GHR_37065_ALL_PROCEDURE_FAIL');
2194: hr_utility.set_message_token('PAY_PLAN','5, 6, E, or F, and pay plan is GM or GS');
2195: hr_utility.raise_error;
2196: end if;
2197: -- End Bug# 5073313
2198: END IF;

Line 2195: hr_utility.raise_error;

2191: AND p_to_locality_adj is not null and to_number(p_to_locality_adj) <> 0
2192: then
2193: hr_utility.set_message(8301,'GHR_37065_ALL_PROCEDURE_FAIL');
2194: hr_utility.set_message_token('PAY_PLAN','5, 6, E, or F, and pay plan is GM or GS');
2195: hr_utility.raise_error;
2196: end if;
2197: -- End Bug# 5073313
2198: END IF;
2199: -- FWFA Changes

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

2219: substr(p_duty_station_code,1,2) not in ('CA','MX') or
2220: p_to_pay_plan in ('FO','FP')
2221: ) and
2222: (p_to_locality_adj is not null and to_number(p_to_locality_adj) <> 0) then
2223: hr_utility.set_message(8301,'GHR_37897_ALL_PROCEDURE_FAIL');
2224: hr_utility.raise_error;
2225: end if;
2226: end if;*/
2227:

Line 2224: hr_utility.raise_error;

2220: p_to_pay_plan in ('FO','FP')
2221: ) and
2222: (p_to_locality_adj is not null and to_number(p_to_locality_adj) <> 0) then
2223: hr_utility.set_message(8301,'GHR_37897_ALL_PROCEDURE_FAIL');
2224: hr_utility.raise_error;
2225: end if;
2226: end if;*/
2227:
2228:

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

2245: p_pay_rate_determinant_code not in ('A','B','E','F','S','U','V') and
2246: (p_to_locality_adj is not null and to_number(p_to_locality_adj) <> 0)
2247: ) then
2248: GHR_GHRWS52L.CPDF_Parameter_Check;
2249: hr_utility.set_message(8301,'GHR_37734_ALL_PROCEDURE_FAIL');
2250: hr_utility.set_message_token('PRD_LIST','A, B, E, F, S, U, or V');
2251: hr_utility.set_message_token('PP_LIST','EX, ES, FE or ZZ');
2252: hr_utility.raise_error;
2253: end if;

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

2246: (p_to_locality_adj is not null and to_number(p_to_locality_adj) <> 0)
2247: ) then
2248: GHR_GHRWS52L.CPDF_Parameter_Check;
2249: hr_utility.set_message(8301,'GHR_37734_ALL_PROCEDURE_FAIL');
2250: hr_utility.set_message_token('PRD_LIST','A, B, E, F, S, U, or V');
2251: hr_utility.set_message_token('PP_LIST','EX, ES, FE or ZZ');
2252: hr_utility.raise_error;
2253: end if;
2254: ELSIF ( p_effective_date < to_date('12/04/2009', 'dd/mm/yyyy') ) THEN

Line 2251: hr_utility.set_message_token('PP_LIST','EX, ES, FE or ZZ');

2247: ) then
2248: GHR_GHRWS52L.CPDF_Parameter_Check;
2249: hr_utility.set_message(8301,'GHR_37734_ALL_PROCEDURE_FAIL');
2250: hr_utility.set_message_token('PRD_LIST','A, B, E, F, S, U, or V');
2251: hr_utility.set_message_token('PP_LIST','EX, ES, FE or ZZ');
2252: hr_utility.raise_error;
2253: end if;
2254: ELSIF ( p_effective_date < to_date('12/04/2009', 'dd/mm/yyyy') ) THEN
2255: if (

Line 2252: hr_utility.raise_error;

2248: GHR_GHRWS52L.CPDF_Parameter_Check;
2249: hr_utility.set_message(8301,'GHR_37734_ALL_PROCEDURE_FAIL');
2250: hr_utility.set_message_token('PRD_LIST','A, B, E, F, S, U, or V');
2251: hr_utility.set_message_token('PP_LIST','EX, ES, FE or ZZ');
2252: hr_utility.raise_error;
2253: end if;
2254: ELSIF ( p_effective_date < to_date('12/04/2009', 'dd/mm/yyyy') ) THEN
2255: if (
2256: ( p_to_pay_plan in ('EX','ZZ','ES','FE') or

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

2260: p_pay_rate_determinant_code not in ('A','B','E','F','S') and
2261: (p_to_locality_adj is not null and to_number(p_to_locality_adj) <> 0)
2262: ) then
2263: GHR_GHRWS52L.CPDF_Parameter_Check;
2264: hr_utility.set_message(8301,'GHR_37734_ALL_PROCEDURE_FAIL');
2265: hr_utility.set_message_token('PRD_LIST','A, B, E, F, or S');
2266: hr_utility.set_message_token('PP_LIST','EX, ES, FE or ZZ');
2267: hr_utility.raise_error;
2268: end if;

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

2261: (p_to_locality_adj is not null and to_number(p_to_locality_adj) <> 0)
2262: ) then
2263: GHR_GHRWS52L.CPDF_Parameter_Check;
2264: hr_utility.set_message(8301,'GHR_37734_ALL_PROCEDURE_FAIL');
2265: hr_utility.set_message_token('PRD_LIST','A, B, E, F, or S');
2266: hr_utility.set_message_token('PP_LIST','EX, ES, FE or ZZ');
2267: hr_utility.raise_error;
2268: end if;
2269: ELSIF p_effective_date < fnd_date.canonical_to_date('2010/01/01') THEN

Line 2266: hr_utility.set_message_token('PP_LIST','EX, ES, FE or ZZ');

2262: ) then
2263: GHR_GHRWS52L.CPDF_Parameter_Check;
2264: hr_utility.set_message(8301,'GHR_37734_ALL_PROCEDURE_FAIL');
2265: hr_utility.set_message_token('PRD_LIST','A, B, E, F, or S');
2266: hr_utility.set_message_token('PP_LIST','EX, ES, FE or ZZ');
2267: hr_utility.raise_error;
2268: end if;
2269: ELSIF p_effective_date < fnd_date.canonical_to_date('2010/01/01') THEN
2270: if (

Line 2267: hr_utility.raise_error;

2263: GHR_GHRWS52L.CPDF_Parameter_Check;
2264: hr_utility.set_message(8301,'GHR_37734_ALL_PROCEDURE_FAIL');
2265: hr_utility.set_message_token('PRD_LIST','A, B, E, F, or S');
2266: hr_utility.set_message_token('PP_LIST','EX, ES, FE or ZZ');
2267: hr_utility.raise_error;
2268: end if;
2269: ELSIF p_effective_date < fnd_date.canonical_to_date('2010/01/01') THEN
2270: if (
2271: ( p_to_pay_plan in ('EX','ZZ','ES','FE','SL','ST') or

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

2275: p_pay_rate_determinant_code not in ('A','B','E','F','S') and
2276: (p_to_locality_adj is not null and to_number(p_to_locality_adj) <> 0)
2277: ) then
2278: GHR_GHRWS52L.CPDF_Parameter_Check;
2279: hr_utility.set_message(8301,'GHR_37734_ALL_PROCEDURE_FAIL');
2280: hr_utility.set_message_token('PRD_LIST','A, B, E, F, or S');
2281: hr_utility.set_message_token('PP_LIST','EX, ES, FE, SL, ST or ZZ');
2282: hr_utility.raise_error;
2283: end if;

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

2276: (p_to_locality_adj is not null and to_number(p_to_locality_adj) <> 0)
2277: ) then
2278: GHR_GHRWS52L.CPDF_Parameter_Check;
2279: hr_utility.set_message(8301,'GHR_37734_ALL_PROCEDURE_FAIL');
2280: hr_utility.set_message_token('PRD_LIST','A, B, E, F, or S');
2281: hr_utility.set_message_token('PP_LIST','EX, ES, FE, SL, ST or ZZ');
2282: hr_utility.raise_error;
2283: end if;
2284: ELSE

Line 2281: hr_utility.set_message_token('PP_LIST','EX, ES, FE, SL, ST or ZZ');

2277: ) then
2278: GHR_GHRWS52L.CPDF_Parameter_Check;
2279: hr_utility.set_message(8301,'GHR_37734_ALL_PROCEDURE_FAIL');
2280: hr_utility.set_message_token('PRD_LIST','A, B, E, F, or S');
2281: hr_utility.set_message_token('PP_LIST','EX, ES, FE, SL, ST or ZZ');
2282: hr_utility.raise_error;
2283: end if;
2284: ELSE
2285: if (

Line 2282: hr_utility.raise_error;

2278: GHR_GHRWS52L.CPDF_Parameter_Check;
2279: hr_utility.set_message(8301,'GHR_37734_ALL_PROCEDURE_FAIL');
2280: hr_utility.set_message_token('PRD_LIST','A, B, E, F, or S');
2281: hr_utility.set_message_token('PP_LIST','EX, ES, FE, SL, ST or ZZ');
2282: hr_utility.raise_error;
2283: end if;
2284: ELSE
2285: if (
2286: ( p_to_pay_plan in ('EX','ZZ','ES','FE','SL','ST') or

Line 2294: hr_utility.set_message(8301,'GHR_37760_ALL_PROCEDURE_FAIL');

2290: p_locality_pay_area NOT IN ('AK','HI','ON') AND
2291: (p_to_locality_adj is not null and to_number(p_to_locality_adj) <> 0)
2292: ) then
2293: GHR_GHRWS52L.CPDF_Parameter_Check;
2294: hr_utility.set_message(8301,'GHR_37760_ALL_PROCEDURE_FAIL');
2295: hr_utility.set_message_token('PRD_LIST','A, B, E, F, or S');
2296: hr_utility.set_message_token('PP_LIST','EX, ES, FE, SL, ST or ZZ');
2297: hr_utility.raise_error;
2298: end if;

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

2291: (p_to_locality_adj is not null and to_number(p_to_locality_adj) <> 0)
2292: ) then
2293: GHR_GHRWS52L.CPDF_Parameter_Check;
2294: hr_utility.set_message(8301,'GHR_37760_ALL_PROCEDURE_FAIL');
2295: hr_utility.set_message_token('PRD_LIST','A, B, E, F, or S');
2296: hr_utility.set_message_token('PP_LIST','EX, ES, FE, SL, ST or ZZ');
2297: hr_utility.raise_error;
2298: end if;
2299: END IF;

Line 2296: hr_utility.set_message_token('PP_LIST','EX, ES, FE, SL, ST or ZZ');

2292: ) then
2293: GHR_GHRWS52L.CPDF_Parameter_Check;
2294: hr_utility.set_message(8301,'GHR_37760_ALL_PROCEDURE_FAIL');
2295: hr_utility.set_message_token('PRD_LIST','A, B, E, F, or S');
2296: hr_utility.set_message_token('PP_LIST','EX, ES, FE, SL, ST or ZZ');
2297: hr_utility.raise_error;
2298: end if;
2299: END IF;
2300:

Line 2297: hr_utility.raise_error;

2293: GHR_GHRWS52L.CPDF_Parameter_Check;
2294: hr_utility.set_message(8301,'GHR_37760_ALL_PROCEDURE_FAIL');
2295: hr_utility.set_message_token('PRD_LIST','A, B, E, F, or S');
2296: hr_utility.set_message_token('PP_LIST','EX, ES, FE, SL, ST or ZZ');
2297: hr_utility.raise_error;
2298: end if;
2299: END IF;
2300:
2301: -- 652.35.3

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

2305: p_pay_rate_determinant_code = 'C' and
2306: (p_to_locality_adj is not null and to_number(p_to_locality_adj) <> 0)
2307: ) then
2308: GHR_GHRWS52L.CPDF_Parameter_Check;
2309: hr_utility.set_message(8301,'GHR_37735_ALL_PROCEDURE_FAIL');
2310: hr_utility.raise_error;
2311: end if;
2312: END IF;
2313: -- 652.45.1

Line 2310: hr_utility.raise_error;

2306: (p_to_locality_adj is not null and to_number(p_to_locality_adj) <> 0)
2307: ) then
2308: GHR_GHRWS52L.CPDF_Parameter_Check;
2309: hr_utility.set_message(8301,'GHR_37735_ALL_PROCEDURE_FAIL');
2310: hr_utility.raise_error;
2311: end if;
2312: END IF;
2313: -- 652.45.1
2314: -- 12/8/00 vravikan From the Start Remove GH and GM

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

2336: (p_to_locality_adj is null) ) and
2337: ( p_first_noac_lookup_code <> '817' )
2338: then
2339: GHR_GHRWS52L.CPDF_Parameter_Check;
2340: hr_utility.set_message(8301,'GHR_37736_ALL_PROCEDURE_FAIL');
2341: hr_utility.raise_error;
2342: end if;
2343:
2344: ELSIF ( p_effective_date < to_date('01/05/2005', 'dd/mm/yyyy') ) THEN

Line 2341: hr_utility.raise_error;

2337: ( p_first_noac_lookup_code <> '817' )
2338: then
2339: GHR_GHRWS52L.CPDF_Parameter_Check;
2340: hr_utility.set_message(8301,'GHR_37736_ALL_PROCEDURE_FAIL');
2341: hr_utility.raise_error;
2342: end if;
2343:
2344: ELSIF ( p_effective_date < to_date('01/05/2005', 'dd/mm/yyyy') ) THEN
2345: if (p_retained_pay_plan in ('GS','GG') and

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

2348: (p_to_locality_adj is null)) and
2349: ( p_first_noac_lookup_code <> '817' )
2350: then
2351: GHR_GHRWS52L.CPDF_Parameter_Check;
2352: hr_utility.set_message(8301,'GHR_38933_ALL_PROCEDURE_FAIL');
2353: hr_utility.set_message_token('PRD_LIST','A, B, U, or V');
2354: hr_utility.raise_error;
2355: end if;
2356:

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

2349: ( p_first_noac_lookup_code <> '817' )
2350: then
2351: GHR_GHRWS52L.CPDF_Parameter_Check;
2352: hr_utility.set_message(8301,'GHR_38933_ALL_PROCEDURE_FAIL');
2353: hr_utility.set_message_token('PRD_LIST','A, B, U, or V');
2354: hr_utility.raise_error;
2355: end if;
2356:
2357: ELSIF ( p_effective_date >= to_date('01/05/2005', 'dd/mm/yyyy') ) AND

Line 2354: hr_utility.raise_error;

2350: then
2351: GHR_GHRWS52L.CPDF_Parameter_Check;
2352: hr_utility.set_message(8301,'GHR_38933_ALL_PROCEDURE_FAIL');
2353: hr_utility.set_message_token('PRD_LIST','A, B, U, or V');
2354: hr_utility.raise_error;
2355: end if;
2356:
2357: ELSIF ( p_effective_date >= to_date('01/05/2005', 'dd/mm/yyyy') ) AND
2358: ( p_effective_date < to_date('01/07/2006', 'dd/mm/yyyy') ) THEN

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

2361: p_locality_pay_area NOT IN ('ZY','ZZ') and
2362: (p_to_locality_adj is null))
2363: and ( p_first_noac_lookup_code <> '817' ) then
2364: GHR_GHRWS52L.CPDF_Parameter_Check;
2365: hr_utility.set_message(8301,'GHR_38933_ALL_PROCEDURE_FAIL');
2366: hr_utility.set_message_token('PRD_LIST','A or B');
2367: hr_utility.raise_error;
2368: end if;
2369:

Line 2366: hr_utility.set_message_token('PRD_LIST','A or B');

2362: (p_to_locality_adj is null))
2363: and ( p_first_noac_lookup_code <> '817' ) then
2364: GHR_GHRWS52L.CPDF_Parameter_Check;
2365: hr_utility.set_message(8301,'GHR_38933_ALL_PROCEDURE_FAIL');
2366: hr_utility.set_message_token('PRD_LIST','A or B');
2367: hr_utility.raise_error;
2368: end if;
2369:
2370: ELSIF ( p_effective_date >= to_date('01/07/2006', 'dd/mm/yyyy') ) AND

Line 2367: hr_utility.raise_error;

2363: and ( p_first_noac_lookup_code <> '817' ) then
2364: GHR_GHRWS52L.CPDF_Parameter_Check;
2365: hr_utility.set_message(8301,'GHR_38933_ALL_PROCEDURE_FAIL');
2366: hr_utility.set_message_token('PRD_LIST','A or B');
2367: hr_utility.raise_error;
2368: end if;
2369:
2370: ELSIF ( p_effective_date >= to_date('01/07/2006', 'dd/mm/yyyy') ) AND
2371: p_effective_date < fnd_date.canonical_to_date('2010/01/01') THEN

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

2376: ( p_first_noac_lookup_code <> '817' )
2377: then
2378: GHR_GHRWS52L.CPDF_Parameter_Check;
2379: if ( p_effective_date < to_date('01/09/2006', 'dd/mm/yyyy') ) THEN
2380: hr_utility.set_message(8301,'GHR_37696_ALL_PROCEDURE_FAIL');
2381: hr_utility.raise_error;
2382: else
2383: hr_utility.set_message(8301,'GHR_37434_ALL_PROCEDURE_FAIL');
2384: hr_utility.set_message_token('LOC_AREA','ZZ');

Line 2381: hr_utility.raise_error;

2377: then
2378: GHR_GHRWS52L.CPDF_Parameter_Check;
2379: if ( p_effective_date < to_date('01/09/2006', 'dd/mm/yyyy') ) THEN
2380: hr_utility.set_message(8301,'GHR_37696_ALL_PROCEDURE_FAIL');
2381: hr_utility.raise_error;
2382: else
2383: hr_utility.set_message(8301,'GHR_37434_ALL_PROCEDURE_FAIL');
2384: hr_utility.set_message_token('LOC_AREA','ZZ');
2385: hr_utility.raise_error;

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

2379: if ( p_effective_date < to_date('01/09/2006', 'dd/mm/yyyy') ) THEN
2380: hr_utility.set_message(8301,'GHR_37696_ALL_PROCEDURE_FAIL');
2381: hr_utility.raise_error;
2382: else
2383: hr_utility.set_message(8301,'GHR_37434_ALL_PROCEDURE_FAIL');
2384: hr_utility.set_message_token('LOC_AREA','ZZ');
2385: hr_utility.raise_error;
2386: end if;
2387: end if;

Line 2384: hr_utility.set_message_token('LOC_AREA','ZZ');

2380: hr_utility.set_message(8301,'GHR_37696_ALL_PROCEDURE_FAIL');
2381: hr_utility.raise_error;
2382: else
2383: hr_utility.set_message(8301,'GHR_37434_ALL_PROCEDURE_FAIL');
2384: hr_utility.set_message_token('LOC_AREA','ZZ');
2385: hr_utility.raise_error;
2386: end if;
2387: end if;
2388: ELSE

Line 2385: hr_utility.raise_error;

2381: hr_utility.raise_error;
2382: else
2383: hr_utility.set_message(8301,'GHR_37434_ALL_PROCEDURE_FAIL');
2384: hr_utility.set_message_token('LOC_AREA','ZZ');
2385: hr_utility.raise_error;
2386: end if;
2387: end if;
2388: ELSE
2389: if ( p_retained_pay_plan in ('GS','GG') and

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

2392: (p_to_locality_adj is null)) and
2393: ( p_first_noac_lookup_code <> '817' )
2394: then
2395: GHR_GHRWS52L.CPDF_Parameter_Check;
2396: hr_utility.set_message(8301,'GHR_37434_ALL_PROCEDURE_FAIL');
2397: hr_utility.set_message_token('LOC_AREA','AK, HI, ON, ZZ');
2398: hr_utility.raise_error;
2399: end if;
2400: END IF;

Line 2397: hr_utility.set_message_token('LOC_AREA','AK, HI, ON, ZZ');

2393: ( p_first_noac_lookup_code <> '817' )
2394: then
2395: GHR_GHRWS52L.CPDF_Parameter_Check;
2396: hr_utility.set_message(8301,'GHR_37434_ALL_PROCEDURE_FAIL');
2397: hr_utility.set_message_token('LOC_AREA','AK, HI, ON, ZZ');
2398: hr_utility.raise_error;
2399: end if;
2400: END IF;
2401: -------------------------------------------------------------------------------

Line 2398: hr_utility.raise_error;

2394: then
2395: GHR_GHRWS52L.CPDF_Parameter_Check;
2396: hr_utility.set_message(8301,'GHR_37434_ALL_PROCEDURE_FAIL');
2397: hr_utility.set_message_token('LOC_AREA','AK, HI, ON, ZZ');
2398: hr_utility.raise_error;
2399: end if;
2400: END IF;
2401: -------------------------------------------------------------------------------
2402:

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

2428: l_lpa_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2) and
2429: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
2430: ) then
2431: GHR_GHRWS52L.CPDF_Parameter_Check;
2432: hr_utility.set_message(8301,'GHR_37737_ALL_PROCEDURE_FAIL');
2433: hr_utility.raise_error;
2434: end if;
2435: end if;
2436: -------------------------------------------------------------------------------

Line 2433: hr_utility.raise_error;

2429: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
2430: ) then
2431: GHR_GHRWS52L.CPDF_Parameter_Check;
2432: hr_utility.set_message(8301,'GHR_37737_ALL_PROCEDURE_FAIL');
2433: hr_utility.raise_error;
2434: end if;
2435: end if;
2436: -------------------------------------------------------------------------------
2437:

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

2461: l_lpa_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2) and
2462: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
2463: ) then
2464: GHR_GHRWS52L.CPDF_Parameter_Check;
2465: hr_utility.set_message(8301,'GHR_37749_ALL_PROCEDURE_FAIL');
2466: hr_utility.raise_error;
2467: end if;
2468: end if;
2469: -------------------------------------------------------------------------------

Line 2466: hr_utility.raise_error;

2462: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
2463: ) then
2464: GHR_GHRWS52L.CPDF_Parameter_Check;
2465: hr_utility.set_message(8301,'GHR_37749_ALL_PROCEDURE_FAIL');
2466: hr_utility.raise_error;
2467: end if;
2468: end if;
2469: -------------------------------------------------------------------------------
2470: -- 652.75.1

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

2486: l_lpa_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2) and
2487: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
2488: ) then
2489: GHR_GHRWS52L.CPDF_Parameter_Check;
2490: hr_utility.set_message(8301,'GHR_37738_ALL_PROCEDURE_FAIL');
2491: hr_utility.raise_error;
2492: end if;
2493: end if;
2494: */

Line 2491: hr_utility.raise_error;

2487: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
2488: ) then
2489: GHR_GHRWS52L.CPDF_Parameter_Check;
2490: hr_utility.set_message(8301,'GHR_37738_ALL_PROCEDURE_FAIL');
2491: hr_utility.raise_error;
2492: end if;
2493: end if;
2494: */
2495:

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

2514: round(((nvl(to_number(p_to_locality_adj),0)/to_number(p_to_basic_pay))*100),2)
2515: not between l_lpa_pct and l_leo_pct
2516: ) then
2517: GHR_GHRWS52L.CPDF_Parameter_Check;
2518: hr_utility.set_message(8301,'GHR_37759_ALL_PROCEDURE_FAIL');
2519: hr_utility.raise_error;
2520: end if;
2521: end if;
2522: ELSIF ( p_effective_date < to_date('01/05/2005', 'dd/mm/yyyy') ) THEN

Line 2519: hr_utility.raise_error;

2515: not between l_lpa_pct and l_leo_pct
2516: ) then
2517: GHR_GHRWS52L.CPDF_Parameter_Check;
2518: hr_utility.set_message(8301,'GHR_37759_ALL_PROCEDURE_FAIL');
2519: hr_utility.raise_error;
2520: end if;
2521: end if;
2522: ELSIF ( p_effective_date < to_date('01/05/2005', 'dd/mm/yyyy') ) THEN
2523: if (

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

2529: round(((nvl(to_number(p_to_locality_adj),0)/to_number(p_to_basic_pay))*100),2)
2530: not between l_lpa_pct and l_leo_pct
2531: ) then
2532: GHR_GHRWS52L.CPDF_Parameter_Check;
2533: hr_utility.set_message(8301,'GHR_38934_ALL_PROCEDURE_FAIL');
2534: hr_utility.set_message_token('PRD_LIST','0, 3, 7, J, or K');
2535: hr_utility.raise_error;
2536: end if;
2537: end if;

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

2530: not between l_lpa_pct and l_leo_pct
2531: ) then
2532: GHR_GHRWS52L.CPDF_Parameter_Check;
2533: hr_utility.set_message(8301,'GHR_38934_ALL_PROCEDURE_FAIL');
2534: hr_utility.set_message_token('PRD_LIST','0, 3, 7, J, or K');
2535: hr_utility.raise_error;
2536: end if;
2537: end if;
2538:

Line 2535: hr_utility.raise_error;

2531: ) then
2532: GHR_GHRWS52L.CPDF_Parameter_Check;
2533: hr_utility.set_message(8301,'GHR_38934_ALL_PROCEDURE_FAIL');
2534: hr_utility.set_message_token('PRD_LIST','0, 3, 7, J, or K');
2535: hr_utility.raise_error;
2536: end if;
2537: end if;
2538:
2539: ELSIF ( p_effective_date >= to_date('01/05/2005', 'dd/mm/yyyy') )

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

2549: round(((nvl(to_number(p_to_locality_adj),0)/to_number(p_to_basic_pay))*100),2)
2550: not between l_lpa_pct and l_leo_pct
2551: ) then
2552: GHR_GHRWS52L.CPDF_Parameter_Check;
2553: hr_utility.set_message(8301,'GHR_38934_ALL_PROCEDURE_FAIL');
2554: hr_utility.set_message_token('PRD_LIST','0, or 7');
2555: hr_utility.raise_error;
2556: end if;
2557: end if;

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

2550: not between l_lpa_pct and l_leo_pct
2551: ) then
2552: GHR_GHRWS52L.CPDF_Parameter_Check;
2553: hr_utility.set_message(8301,'GHR_38934_ALL_PROCEDURE_FAIL');
2554: hr_utility.set_message_token('PRD_LIST','0, or 7');
2555: hr_utility.raise_error;
2556: end if;
2557: end if;
2558: END IF;

Line 2555: hr_utility.raise_error;

2551: ) then
2552: GHR_GHRWS52L.CPDF_Parameter_Check;
2553: hr_utility.set_message(8301,'GHR_38934_ALL_PROCEDURE_FAIL');
2554: hr_utility.set_message_token('PRD_LIST','0, or 7');
2555: hr_utility.raise_error;
2556: end if;
2557: end if;
2558: END IF;
2559: -------------------------------------------------------------------------------

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

2570: and
2571: (p_to_locality_adj is null)
2572: ) then
2573: GHR_GHRWS52L.CPDF_Parameter_Check;
2574: hr_utility.set_message(8301,'GHR_37739_ALL_PROCEDURE_FAIL');
2575: hr_utility.raise_error;
2576: end if;
2577: */
2578: end chk_locality_adj;

Line 2575: hr_utility.raise_error;

2571: (p_to_locality_adj is null)
2572: ) then
2573: GHR_GHRWS52L.CPDF_Parameter_Check;
2574: hr_utility.set_message(8301,'GHR_37739_ALL_PROCEDURE_FAIL');
2575: hr_utility.raise_error;
2576: end if;
2577: */
2578: end chk_locality_adj;
2579: /* Name:

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

2650: l_lpa_pct < round((nvl(to_number(p_prior_locality_adj),0)/to_number(p_prior_basic_pay))*100,2) and
2651: l_leo_pct < round((nvl(to_number(p_prior_locality_adj),0)/to_number(p_prior_basic_pay))*100,2)
2652: ) then
2653: GHR_GHRWS52L.CPDF_Parameter_Check;
2654: hr_utility.set_message(8301,'GHR_37741_ALL_PROCEDURE_FAIL');
2655: hr_utility.raise_error;
2656: end if;
2657: end if;
2658: end if;

Line 2655: hr_utility.raise_error;

2651: l_leo_pct < round((nvl(to_number(p_prior_locality_adj),0)/to_number(p_prior_basic_pay))*100,2)
2652: ) then
2653: GHR_GHRWS52L.CPDF_Parameter_Check;
2654: hr_utility.set_message(8301,'GHR_37741_ALL_PROCEDURE_FAIL');
2655: hr_utility.raise_error;
2656: end if;
2657: end if;
2658: end if;
2659: */

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

2693: l_lpa_pct < round((to_number(p_prior_locality_adj)/to_number(p_prior_basic_pay)*100),2) and
2694: l_leo_pct < round((to_number(p_prior_locality_adj)/to_number(p_prior_basic_pay)*100),2)
2695: ) then
2696: GHR_GHRWS52L.CPDF_Parameter_Check;
2697: hr_utility.set_message(8301,'GHR_37742_ALL_PROCEDURE_FAIL');
2698: hr_utility.raise_error;
2699: end if;
2700: end if;
2701: ELSIF ( p_effective_date < to_date('01/05/2005', 'dd/mm/yyyy') ) THEN

Line 2698: hr_utility.raise_error;

2694: l_leo_pct < round((to_number(p_prior_locality_adj)/to_number(p_prior_basic_pay)*100),2)
2695: ) then
2696: GHR_GHRWS52L.CPDF_Parameter_Check;
2697: hr_utility.set_message(8301,'GHR_37742_ALL_PROCEDURE_FAIL');
2698: hr_utility.raise_error;
2699: end if;
2700: end if;
2701: ELSIF ( p_effective_date < to_date('01/05/2005', 'dd/mm/yyyy') ) THEN
2702: if (

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

2710: l_lpa_pct < round((to_number(p_prior_locality_adj)/to_number(p_prior_basic_pay)*100),2) and
2711: l_leo_pct < round((to_number(p_prior_locality_adj)/to_number(p_prior_basic_pay)*100),2)
2712: ) then
2713: GHR_GHRWS52L.CPDF_Parameter_Check;
2714: hr_utility.set_message(8301,'GHR_38935_ALL_PROCEDURE_FAIL'); -- NEW MESG TOKEN REQD
2715: hr_utility.set_message_token('PRD_LIST','0, 3, 7, J, or K');
2716: hr_utility.raise_error;
2717: end if;
2718: end if;

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

2711: l_leo_pct < round((to_number(p_prior_locality_adj)/to_number(p_prior_basic_pay)*100),2)
2712: ) then
2713: GHR_GHRWS52L.CPDF_Parameter_Check;
2714: hr_utility.set_message(8301,'GHR_38935_ALL_PROCEDURE_FAIL'); -- NEW MESG TOKEN REQD
2715: hr_utility.set_message_token('PRD_LIST','0, 3, 7, J, or K');
2716: hr_utility.raise_error;
2717: end if;
2718: end if;
2719:

Line 2716: hr_utility.raise_error;

2712: ) then
2713: GHR_GHRWS52L.CPDF_Parameter_Check;
2714: hr_utility.set_message(8301,'GHR_38935_ALL_PROCEDURE_FAIL'); -- NEW MESG TOKEN REQD
2715: hr_utility.set_message_token('PRD_LIST','0, 3, 7, J, or K');
2716: hr_utility.raise_error;
2717: end if;
2718: end if;
2719:
2720: ELSIF ( p_effective_date >= to_date('01/05/2005', 'dd/mm/yyyy')

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

2732: l_lpa_pct < round((to_number(p_prior_locality_adj)/to_number(p_prior_basic_pay)*100),2) and
2733: l_leo_pct < round((to_number(p_prior_locality_adj)/to_number(p_prior_basic_pay)*100),2)
2734: ) then
2735: GHR_GHRWS52L.CPDF_Parameter_Check;
2736: hr_utility.set_message(8301,'GHR_38935_ALL_PROCEDURE_FAIL');
2737: hr_utility.set_message_token('PRD_LIST','0, or 7');
2738: hr_utility.raise_error;
2739: end if;
2740: end if;

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

2733: l_leo_pct < round((to_number(p_prior_locality_adj)/to_number(p_prior_basic_pay)*100),2)
2734: ) then
2735: GHR_GHRWS52L.CPDF_Parameter_Check;
2736: hr_utility.set_message(8301,'GHR_38935_ALL_PROCEDURE_FAIL');
2737: hr_utility.set_message_token('PRD_LIST','0, or 7');
2738: hr_utility.raise_error;
2739: end if;
2740: end if;
2741:

Line 2738: hr_utility.raise_error;

2734: ) then
2735: GHR_GHRWS52L.CPDF_Parameter_Check;
2736: hr_utility.set_message(8301,'GHR_38935_ALL_PROCEDURE_FAIL');
2737: hr_utility.set_message_token('PRD_LIST','0, or 7');
2738: hr_utility.raise_error;
2739: end if;
2740: end if;
2741:
2742: ELSIF ( p_effective_date >= to_date('01/07/2006', 'dd/mm/yyyy') )

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

2752: l_lpa_pct < round((to_number(p_prior_locality_adj)/to_number(p_prior_basic_pay)*100),2) and
2753: l_leo_pct < round((to_number(p_prior_locality_adj)/to_number(p_prior_basic_pay)*100),2)
2754: ) then
2755: GHR_GHRWS52L.CPDF_Parameter_Check;
2756: hr_utility.set_message(8301,'GHR_37697_ALL_PROCEDURE_FAIL');
2757: hr_utility.raise_error;
2758: end if;
2759: end if;
2760: ELSIF p_effective_date < fnd_date.canonical_to_date('2010/01/01') THEN

Line 2757: hr_utility.raise_error;

2753: l_leo_pct < round((to_number(p_prior_locality_adj)/to_number(p_prior_basic_pay)*100),2)
2754: ) then
2755: GHR_GHRWS52L.CPDF_Parameter_Check;
2756: hr_utility.set_message(8301,'GHR_37697_ALL_PROCEDURE_FAIL');
2757: hr_utility.raise_error;
2758: end if;
2759: end if;
2760: ELSIF p_effective_date < fnd_date.canonical_to_date('2010/01/01') THEN
2761: if (nvl(p_prior_pay_plan,hr_api.g_varchar2) in ('GS','GM','GG','GH','GL','FO','FP') and

Line 2775: hr_utility.set_message(8301,'GHR_37458_ALL_PROCEDURE_FAIL');

2771: --Bug 8490941 need to consider the prior locality and basic for comparison with EX04 rate of Table5
2772: (round(to_number(p_prior_locality_adj)+to_number(p_prior_basic_pay)) > l_table5_value)
2773: ) then
2774: GHR_GHRWS52L.CPDF_Parameter_Check;
2775: hr_utility.set_message(8301,'GHR_37458_ALL_PROCEDURE_FAIL');
2776: hr_utility.set_message_token('LOC_AREA','ZZ');
2777: hr_utility.raise_error;
2778: end if;
2779: end if;

Line 2776: hr_utility.set_message_token('LOC_AREA','ZZ');

2772: (round(to_number(p_prior_locality_adj)+to_number(p_prior_basic_pay)) > l_table5_value)
2773: ) then
2774: GHR_GHRWS52L.CPDF_Parameter_Check;
2775: hr_utility.set_message(8301,'GHR_37458_ALL_PROCEDURE_FAIL');
2776: hr_utility.set_message_token('LOC_AREA','ZZ');
2777: hr_utility.raise_error;
2778: end if;
2779: end if;
2780: ELSE

Line 2777: hr_utility.raise_error;

2773: ) then
2774: GHR_GHRWS52L.CPDF_Parameter_Check;
2775: hr_utility.set_message(8301,'GHR_37458_ALL_PROCEDURE_FAIL');
2776: hr_utility.set_message_token('LOC_AREA','ZZ');
2777: hr_utility.raise_error;
2778: end if;
2779: end if;
2780: ELSE
2781: if (nvl(p_prior_pay_plan,hr_api.g_varchar2) in ('GS','GM','GG','GH','GL','FO','FP') and

Line 2795: hr_utility.set_message(8301,'GHR_37458_ALL_PROCEDURE_FAIL');

2791: --Bug 8490941 need to consider the prior locality and basic for comparison with EX04 rate of Table5
2792: (round(to_number(p_prior_locality_adj)+to_number(p_prior_basic_pay)) > l_table5_value)
2793: ) then
2794: GHR_GHRWS52L.CPDF_Parameter_Check;
2795: hr_utility.set_message(8301,'GHR_37458_ALL_PROCEDURE_FAIL');
2796: hr_utility.set_message_token('LOC_AREA','AK, HI, ON, ZZ');
2797: hr_utility.raise_error;
2798: end if;
2799: end if;

Line 2796: hr_utility.set_message_token('LOC_AREA','AK, HI, ON, ZZ');

2792: (round(to_number(p_prior_locality_adj)+to_number(p_prior_basic_pay)) > l_table5_value)
2793: ) then
2794: GHR_GHRWS52L.CPDF_Parameter_Check;
2795: hr_utility.set_message(8301,'GHR_37458_ALL_PROCEDURE_FAIL');
2796: hr_utility.set_message_token('LOC_AREA','AK, HI, ON, ZZ');
2797: hr_utility.raise_error;
2798: end if;
2799: end if;
2800: END IF;

Line 2797: hr_utility.raise_error;

2793: ) then
2794: GHR_GHRWS52L.CPDF_Parameter_Check;
2795: hr_utility.set_message(8301,'GHR_37458_ALL_PROCEDURE_FAIL');
2796: hr_utility.set_message_token('LOC_AREA','AK, HI, ON, ZZ');
2797: hr_utility.raise_error;
2798: end if;
2799: end if;
2800: END IF;
2801: -------------------------------------------------------------------------------

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

2836: l_lpa_pct < round((to_number(p_prior_locality_adj)/to_number(p_prior_basic_pay)*100),2) and
2837: l_leo_pct < round((to_number(p_prior_locality_adj)/to_number(p_prior_basic_pay)*100),2)
2838: ) then
2839: GHR_GHRWS52L.CPDF_Parameter_Check;
2840: hr_utility.set_message(8301,'GHR_37680_ALL_PROCEDURE_FAIL');
2841: hr_utility.raise_error;
2842: end if;
2843: end if;
2844: -- FWFA Changes Bug#4444609

Line 2841: hr_utility.raise_error;

2837: l_leo_pct < round((to_number(p_prior_locality_adj)/to_number(p_prior_basic_pay)*100),2)
2838: ) then
2839: GHR_GHRWS52L.CPDF_Parameter_Check;
2840: hr_utility.set_message(8301,'GHR_37680_ALL_PROCEDURE_FAIL');
2841: hr_utility.raise_error;
2842: end if;
2843: end if;
2844: -- FWFA Changes Bug#4444609
2845: ELSIF p_effective_date < to_date('2005/05/01','yyyy/mm/dd') THEN

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

2854: l_lpa_pct < round((to_number(p_prior_locality_adj)/to_number(p_prior_basic_pay)*100),2) and
2855: l_leo_pct < round((to_number(p_prior_locality_adj)/to_number(p_prior_basic_pay)*100),2)
2856: ) then
2857: GHR_GHRWS52L.CPDF_Parameter_Check;
2858: hr_utility.set_message(8301,'GHR_38936_ALL_PROCEDURE_FAIL');
2859: hr_utility.raise_error;
2860: end if;
2861: end if;
2862: ELSE

Line 2859: hr_utility.raise_error;

2855: l_leo_pct < round((to_number(p_prior_locality_adj)/to_number(p_prior_basic_pay)*100),2)
2856: ) then
2857: GHR_GHRWS52L.CPDF_Parameter_Check;
2858: hr_utility.set_message(8301,'GHR_38936_ALL_PROCEDURE_FAIL');
2859: hr_utility.raise_error;
2860: end if;
2861: end if;
2862: ELSE
2863: if ( nvl(p_prior_pay_plan,hr_api.g_varchar2) in ('GS','GM','GG','GH') and

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

2864: nvl(p_prior_pay_rate_det_code,hr_api.g_varchar2) in ('5','6')
2865: ) then
2866: if to_number(p_prior_locality_adj) <= 0 then
2867: GHR_GHRWS52L.CPDF_Parameter_Check;
2868: hr_utility.set_message(8301,'GHR_38979_ALL_PROCEDURE_FAIL');
2869: hr_utility.raise_error;
2870: end if;
2871: end if;
2872: END IF; -- check for 09-JAN-05 ends here

Line 2869: hr_utility.raise_error;

2865: ) then
2866: if to_number(p_prior_locality_adj) <= 0 then
2867: GHR_GHRWS52L.CPDF_Parameter_Check;
2868: hr_utility.set_message(8301,'GHR_38979_ALL_PROCEDURE_FAIL');
2869: hr_utility.raise_error;
2870: end if;
2871: end if;
2872: END IF; -- check for 09-JAN-05 ends here
2873:

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

2891: IF p_effective_date < fnd_date.canonical_to_date('1998/09/01') THEN
2892: if (p_prior_locality_pay_area = '99' and
2893: (p_prior_locality_adj is not null and to_number(p_prior_locality_adj) <> 0)) then
2894: GHR_GHRWS52L.CPDF_Parameter_Check;
2895: hr_utility.set_message(8301,'GHR_37743_ALL_PROCEDURE_FAIL');
2896: hr_utility.raise_error;
2897: end if;
2898: ELSE
2899: -- between 01-SEP-98 to 09-JAN-05

Line 2896: hr_utility.raise_error;

2892: if (p_prior_locality_pay_area = '99' and
2893: (p_prior_locality_adj is not null and to_number(p_prior_locality_adj) <> 0)) then
2894: GHR_GHRWS52L.CPDF_Parameter_Check;
2895: hr_utility.set_message(8301,'GHR_37743_ALL_PROCEDURE_FAIL');
2896: hr_utility.raise_error;
2897: end if;
2898: ELSE
2899: -- between 01-SEP-98 to 09-JAN-05
2900: IF ( p_effective_date < to_date('09/01/2005', 'dd/mm/yyyy') ) THEN

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

2905: p_prior_locality_adj is not null and
2906: to_number(p_prior_locality_adj) <> 0
2907: then
2908: GHR_GHRWS52L.CPDF_Parameter_Check;
2909: hr_utility.set_message(8301,'GHR_37898_ALL_PROCEDURE_FAIL');
2910: hr_utility.raise_error;
2911: end if;
2912: -- FWFA Changes
2913: ELSIF p_effective_date < to_date('2005/05/01','YYYY/MM/DD') THEN

Line 2910: hr_utility.raise_error;

2906: to_number(p_prior_locality_adj) <> 0
2907: then
2908: GHR_GHRWS52L.CPDF_Parameter_Check;
2909: hr_utility.set_message(8301,'GHR_37898_ALL_PROCEDURE_FAIL');
2910: hr_utility.raise_error;
2911: end if;
2912: -- FWFA Changes
2913: ELSIF p_effective_date < to_date('2005/05/01','YYYY/MM/DD') THEN
2914: -- If prior locality pay area is 99,

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

2918: p_prior_locality_adj is not null and
2919: to_number(p_prior_locality_adj) <> 0
2920: then
2921: GHR_GHRWS52L.CPDF_Parameter_Check;
2922: hr_utility.set_message(8301,'GHR_38937_ALL_PROCEDURE_FAIL');
2923: hr_utility.raise_error;
2924: end if;
2925: ELSif p_effective_date < fnd_date.canonical_to_date('2006/04/01') then
2926: if p_prior_locality_pay_area = 'ZZ' and

Line 2923: hr_utility.raise_error;

2919: to_number(p_prior_locality_adj) <> 0
2920: then
2921: GHR_GHRWS52L.CPDF_Parameter_Check;
2922: hr_utility.set_message(8301,'GHR_38937_ALL_PROCEDURE_FAIL');
2923: hr_utility.raise_error;
2924: end if;
2925: ELSif p_effective_date < fnd_date.canonical_to_date('2006/04/01') then
2926: if p_prior_locality_pay_area = 'ZZ' and
2927: p_prior_pay_rate_det_code not in ('5','6','E','F') and

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

2928: p_prior_locality_adj is not null and
2929: to_number(p_prior_locality_adj) <> 0
2930: then
2931: GHR_GHRWS52L.CPDF_Parameter_Check;
2932: hr_utility.set_message(8301,'GHR_38980_ALL_PROCEDURE_FAIL');
2933: hr_utility.raise_error;
2934: end if;
2935: ELSE
2936: if substr(p_agency_subelement,1,2) <> 'HS' and

Line 2933: hr_utility.raise_error;

2929: to_number(p_prior_locality_adj) <> 0
2930: then
2931: GHR_GHRWS52L.CPDF_Parameter_Check;
2932: hr_utility.set_message(8301,'GHR_38980_ALL_PROCEDURE_FAIL');
2933: hr_utility.raise_error;
2934: end if;
2935: ELSE
2936: if substr(p_agency_subelement,1,2) <> 'HS' and
2937: p_prior_locality_pay_area = 'ZZ' and

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

2940: p_prior_locality_adj is not null and
2941: to_number(p_prior_locality_adj) <> 0
2942: then
2943: GHR_GHRWS52L.CPDF_Parameter_Check;
2944: hr_utility.set_message(8301,'GHR_37162_ALL_PROCEDURE_FAIL');
2945: hr_utility.raise_error;
2946: end if;
2947: END IF;
2948: -- FWFA Changes

Line 2945: hr_utility.raise_error;

2941: to_number(p_prior_locality_adj) <> 0
2942: then
2943: GHR_GHRWS52L.CPDF_Parameter_Check;
2944: hr_utility.set_message(8301,'GHR_37162_ALL_PROCEDURE_FAIL');
2945: hr_utility.raise_error;
2946: end if;
2947: END IF;
2948: -- FWFA Changes
2949: END IF;

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

2968: substr(p_prior_duty_station,1,2) not in ('CA','MX') or
2969: p_prior_pay_plan in ('FO','FP')
2970: ) and
2971: (p_prior_locality_adj is not null and to_number(p_prior_locality_adj) <> 0) then
2972: hr_utility.set_message(8301,'GHR_37899_ALL_PROCEDURE_FAIL');
2973: hr_utility.raise_error;
2974: end if;
2975: end if;
2976: */

Line 2973: hr_utility.raise_error;

2969: p_prior_pay_plan in ('FO','FP')
2970: ) and
2971: (p_prior_locality_adj is not null and to_number(p_prior_locality_adj) <> 0) then
2972: hr_utility.set_message(8301,'GHR_37899_ALL_PROCEDURE_FAIL');
2973: hr_utility.raise_error;
2974: end if;
2975: end if;
2976: */
2977:

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

2994: p_prior_pay_rate_det_code not in ('A','B','E','F','S','U','V') and
2995: (p_prior_locality_adj is not null and to_number(p_prior_locality_adj) <> 0)
2996: ) then
2997: GHR_GHRWS52L.CPDF_Parameter_Check;
2998: hr_utility.set_message(8301,'GHR_37744_ALL_PROCEDURE_FAIL');
2999: hr_utility.set_message_token('PRD_LIST','A, B, E, F, S, U, or V');
3000: hr_utility.raise_error;
3001: end if;
3002: -- Begin Fix for Bug#4879781

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

2995: (p_prior_locality_adj is not null and to_number(p_prior_locality_adj) <> 0)
2996: ) then
2997: GHR_GHRWS52L.CPDF_Parameter_Check;
2998: hr_utility.set_message(8301,'GHR_37744_ALL_PROCEDURE_FAIL');
2999: hr_utility.set_message_token('PRD_LIST','A, B, E, F, S, U, or V');
3000: hr_utility.raise_error;
3001: end if;
3002: -- Begin Fix for Bug#4879781
3003: /*ELSIF p_effective_date >= to_date('2005/05/01','YYYY/MM/DD') THEN

Line 3000: hr_utility.raise_error;

2996: ) then
2997: GHR_GHRWS52L.CPDF_Parameter_Check;
2998: hr_utility.set_message(8301,'GHR_37744_ALL_PROCEDURE_FAIL');
2999: hr_utility.set_message_token('PRD_LIST','A, B, E, F, S, U, or V');
3000: hr_utility.raise_error;
3001: end if;
3002: -- Begin Fix for Bug#4879781
3003: /*ELSIF p_effective_date >= to_date('2005/05/01','YYYY/MM/DD') THEN
3004: if (

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

3008: p_prior_pay_rate_det_code not in ('A','B','E','F','S') and
3009: (p_prior_locality_adj is not null and to_number(p_prior_locality_adj) <> 0)
3010: ) then
3011: GHR_GHRWS52L.CPDF_Parameter_Check;
3012: hr_utility.set_message(8301,'GHR_37744_ALL_PROCEDURE_FAIL');
3013: hr_utility.set_message_token('PRD_LIST','A, B, E, F, or S');
3014: hr_utility.raise_error;
3015: end if;
3016: END IF;*/

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

3009: (p_prior_locality_adj is not null and to_number(p_prior_locality_adj) <> 0)
3010: ) then
3011: GHR_GHRWS52L.CPDF_Parameter_Check;
3012: hr_utility.set_message(8301,'GHR_37744_ALL_PROCEDURE_FAIL');
3013: hr_utility.set_message_token('PRD_LIST','A, B, E, F, or S');
3014: hr_utility.raise_error;
3015: end if;
3016: END IF;*/
3017: --FWFA Changes

Line 3014: hr_utility.raise_error;

3010: ) then
3011: GHR_GHRWS52L.CPDF_Parameter_Check;
3012: hr_utility.set_message(8301,'GHR_37744_ALL_PROCEDURE_FAIL');
3013: hr_utility.set_message_token('PRD_LIST','A, B, E, F, or S');
3014: hr_utility.raise_error;
3015: end if;
3016: END IF;*/
3017: --FWFA Changes
3018: -- End Fix for Bug#4879781

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

3025: (p_prior_locality_adj is not null and to_number(p_prior_locality_adj) <> 0)
3026:
3027: ) then
3028: GHR_GHRWS52L.CPDF_Parameter_Check;
3029: hr_utility.set_message(8301,'GHR_37745_ALL_PROCEDURE_FAIL');
3030: hr_utility.raise_error;
3031: end if;
3032:
3033: -- 653.50.2

Line 3030: hr_utility.raise_error;

3026:
3027: ) then
3028: GHR_GHRWS52L.CPDF_Parameter_Check;
3029: hr_utility.set_message(8301,'GHR_37745_ALL_PROCEDURE_FAIL');
3030: hr_utility.raise_error;
3031: end if;
3032:
3033: -- 653.50.2
3034:

Line 3045: hr_utility.set_message(8301,'GHR_37757_ALL_PROCEDURE_FAIL');

3041: p_prior_locality_pay_area NOT IN ('AK','HI','ON') AND
3042: (p_prior_locality_adj is not null and to_number(p_prior_locality_adj) <> 0)) then
3043:
3044: GHR_GHRWS52L.CPDF_Parameter_Check;
3045: hr_utility.set_message(8301,'GHR_37757_ALL_PROCEDURE_FAIL');
3046: hr_utility.raise_error;
3047: end if;
3048: END IF;
3049: hr_utility.set_location('Leaving CPDF 7 ',1);

Line 3046: hr_utility.raise_error;

3042: (p_prior_locality_adj is not null and to_number(p_prior_locality_adj) <> 0)) then
3043:
3044: GHR_GHRWS52L.CPDF_Parameter_Check;
3045: hr_utility.set_message(8301,'GHR_37757_ALL_PROCEDURE_FAIL');
3046: hr_utility.raise_error;
3047: end if;
3048: END IF;
3049: hr_utility.set_location('Leaving CPDF 7 ',1);
3050: end chk_prior_locality_adj;

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

3045: hr_utility.set_message(8301,'GHR_37757_ALL_PROCEDURE_FAIL');
3046: hr_utility.raise_error;
3047: end if;
3048: END IF;
3049: hr_utility.set_location('Leaving CPDF 7 ',1);
3050: end chk_prior_locality_adj;
3051: end GHR_CPDF_CHECK7;