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

Line 23: hr_utility.set_message(8301, 'GHR_37001_ALL_PROCEDURE_FAIL');

19: p_bargaining_unit_status_code <> '8888'
20: and
21: p_bargaining_unit_status_code is not null
22: then
23: hr_utility.set_message(8301, 'GHR_37001_ALL_PROCEDURE_FAIL');
24: hr_utility.raise_error;
25: end if;
26:
27: /* Commented as per December 2000 cpdf changes -- vravikan

Line 24: hr_utility.raise_error;

20: and
21: p_bargaining_unit_status_code is not null
22: then
23: hr_utility.set_message(8301, 'GHR_37001_ALL_PROCEDURE_FAIL');
24: hr_utility.raise_error;
25: end if;
26:
27: /* Commented as per December 2000 cpdf changes -- vravikan
28: -- 060.04.1

Line 35: hr_utility.set_message(8301, 'GHR_37002_ALL_PROCEDURE_FAIL');

31: p_bargaining_unit_status_code <> '8888'
32: and
33: p_bargaining_unit_status_code is not null
34: then
35: hr_utility.set_message(8301, 'GHR_37002_ALL_PROCEDURE_FAIL');
36: hr_utility.raise_error;
37: end if;
38: */
39: end chk_bargaining_unit ;

Line 36: hr_utility.raise_error;

32: and
33: p_bargaining_unit_status_code is not null
34: then
35: hr_utility.set_message(8301, 'GHR_37002_ALL_PROCEDURE_FAIL');
36: hr_utility.raise_error;
37: end if;
38: */
39: end chk_bargaining_unit ;
40:

Line 65: hr_utility.set_message(8301, 'GHR_37038_ALL_PROCEDURE_FAIL');

61: p_fegli_code <> 'A0'
62: and
63: p_fegli_code is not null
64: then
65: hr_utility.set_message(8301, 'GHR_37038_ALL_PROCEDURE_FAIL');
66: hr_utility.raise_error;
67: end if;
68: else
69: if p_to_basic_pay = '0'

Line 66: hr_utility.raise_error;

62: and
63: p_fegli_code is not null
64: then
65: hr_utility.set_message(8301, 'GHR_37038_ALL_PROCEDURE_FAIL');
66: hr_utility.raise_error;
67: end if;
68: else
69: if p_to_basic_pay = '0'
70: and

Line 77: hr_utility.set_message(8301, 'GHR_37003_ALL_PROCEDURE_FAIL');

73: p_fegli_code <> 'A'
74: and
75: p_fegli_code is not null
76: then
77: hr_utility.set_message(8301, 'GHR_37003_ALL_PROCEDURE_FAIL');
78: hr_utility.raise_error;
79: end if;
80: end if;
81: end chk_fegli;

Line 78: hr_utility.raise_error;

74: and
75: p_fegli_code is not null
76: then
77: hr_utility.set_message(8301, 'GHR_37003_ALL_PROCEDURE_FAIL');
78: hr_utility.raise_error;
79: end if;
80: end if;
81: end chk_fegli;
82:

Line 108: hr_utility.set_message(8301, 'GHR_37004_ALL_PROCEDURE_FAIL');

104: substr(p_duty_station_lookup_code,2,1)<>'Q' )
105: and p_flsa_category <> 'E'
106: and p_flsa_category is not null
107: then
108: hr_utility.set_message(8301, 'GHR_37004_ALL_PROCEDURE_FAIL');
109: hr_utility.raise_error;
110: end if;
111: end if;
112: -- 180.04.1

Line 109: hr_utility.raise_error;

105: and p_flsa_category <> 'E'
106: and p_flsa_category is not null
107: then
108: hr_utility.set_message(8301, 'GHR_37004_ALL_PROCEDURE_FAIL');
109: hr_utility.raise_error;
110: end if;
111: end if;
112: -- 180.04.1
113: --upd49 08-Jan-07 Raju Bug#5619873 From 01-Sep-2006 Terminate the edit

Line 129: hr_utility.set_message(8301, 'GHR_37005_ALL_PROCEDURE_FAIL');

125: p_flsa_category <> 'N'
126: and
127: p_flsa_category is not null
128: then
129: hr_utility.set_message(8301, 'GHR_37005_ALL_PROCEDURE_FAIL');
130: hr_utility.raise_error;
131: end if;
132: end if;
133: -- 180.07.1

Line 130: hr_utility.raise_error;

126: and
127: p_flsa_category is not null
128: then
129: hr_utility.set_message(8301, 'GHR_37005_ALL_PROCEDURE_FAIL');
130: hr_utility.raise_error;
131: end if;
132: end if;
133: -- 180.07.1
134: --upd49 08-Jan-07 Raju Bug#5619873 From 01-Sep-2006 Terminate the edit

Line 152: hr_utility.set_message(8301, 'GHR_37006_ALL_PROCEDURE_FAIL');

148: p_flsa_category <>'N'
149: and
150: p_flsa_category is not null
151: then
152: hr_utility.set_message(8301, 'GHR_37006_ALL_PROCEDURE_FAIL');
153: hr_utility.raise_error;
154: end if;
155: end if;
156: -- 180.09.1

Line 153: hr_utility.raise_error;

149: and
150: p_flsa_category is not null
151: then
152: hr_utility.set_message(8301, 'GHR_37006_ALL_PROCEDURE_FAIL');
153: hr_utility.raise_error;
154: end if;
155: end if;
156: -- 180.09.1
157: -- UPD 56 (Bug# 8309414) edit adding eff 07-sep-2007

Line 162: hr_utility.set_message(8301, 'GHR_37452_ALL_PROCEDURE_FAIL');

158: if p_effective_date > fnd_date.canonical_to_date('2007/09/06') then
159: IF (NOT(substr(p_duty_station_lookup_code,1,2) between '00' and '99') AND
160: substr(p_duty_station_lookup_code,1,2) NOT IN ('AQ','CQ','GQ','JQ','LQ','MQ','RQ','VQ','WQ') )
161: AND p_flsa_category <>'E' THEN
162: hr_utility.set_message(8301, 'GHR_37452_ALL_PROCEDURE_FAIL');
163: hr_utility.raise_error;
164: END IF;
165: END IF;
166:

Line 163: hr_utility.raise_error;

159: IF (NOT(substr(p_duty_station_lookup_code,1,2) between '00' and '99') AND
160: substr(p_duty_station_lookup_code,1,2) NOT IN ('AQ','CQ','GQ','JQ','LQ','MQ','RQ','VQ','WQ') )
161: AND p_flsa_category <>'E' THEN
162: hr_utility.set_message(8301, 'GHR_37452_ALL_PROCEDURE_FAIL');
163: hr_utility.raise_error;
164: END IF;
165: END IF;
166:
167: -- 180.13.1

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

170: p_flsa_category <> 'E'
171: and
172: p_flsa_category is not null
173: then
174: hr_utility.set_message(8301, 'GHR_37007_ALL_PROCEDURE_FAIL');
175: hr_utility.raise_error;
176: end if;
177:
178: end chk_fsla_category;

Line 175: hr_utility.raise_error;

171: and
172: p_flsa_category is not null
173: then
174: hr_utility.set_message(8301, 'GHR_37007_ALL_PROCEDURE_FAIL');
175: hr_utility.raise_error;
176: end if;
177:
178: end chk_fsla_category;
179:

Line 224: hr_utility.set_message(8301, 'GHR_37008_ALL_PROCEDURE_FAIL');

220: or p_to_occ_code between '1510' and '1520')
221: and to_number(p_functional_class) <= 10
222: and p_functional_class is not null
223: then
224: hr_utility.set_message(8301, 'GHR_37008_ALL_PROCEDURE_FAIL');
225: hr_utility.raise_error;
226: end if;
227: elsif p_effective_date < fnd_date.canonical_to_date('2010/01/01') then
228: if (p_to_occ_code in

Line 225: hr_utility.raise_error;

221: and to_number(p_functional_class) <= 10
222: and p_functional_class is not null
223: then
224: hr_utility.set_message(8301, 'GHR_37008_ALL_PROCEDURE_FAIL');
225: hr_utility.raise_error;
226: end if;
227: elsif p_effective_date < fnd_date.canonical_to_date('2010/01/01') then
228: if (p_to_occ_code in
229: ('0020','0101','0110','0140','0150','0170','0180','0184'

Line 253: hr_utility.set_message(8301, 'GHR_37008_ALL_PROCEDURE_FAIL');

249: or p_to_occ_code between '1510' and '1520')
250: and to_number(p_functional_class) <= 10
251: and p_functional_class is not null
252: then
253: hr_utility.set_message(8301, 'GHR_37008_ALL_PROCEDURE_FAIL');
254: hr_utility.raise_error;
255: end if;
256: else
257: if (p_to_occ_code in

Line 254: hr_utility.raise_error;

250: and to_number(p_functional_class) <= 10
251: and p_functional_class is not null
252: then
253: hr_utility.set_message(8301, 'GHR_37008_ALL_PROCEDURE_FAIL');
254: hr_utility.raise_error;
255: end if;
256: else
257: if (p_to_occ_code in
258: ('0020','0101','0110','0140','0150','0170','0180','0184'

Line 283: hr_utility.set_message(8301, 'GHR_37008_ALL_PROCEDURE_FAIL');

279: or p_to_occ_code between '1510' and '1520')
280: and to_number(p_functional_class) <= 10
281: and p_functional_class is not null
282: then
283: hr_utility.set_message(8301, 'GHR_37008_ALL_PROCEDURE_FAIL');
284: hr_utility.raise_error;
285: end if;
286: end if;
287:

Line 284: hr_utility.raise_error;

280: and to_number(p_functional_class) <= 10
281: and p_functional_class is not null
282: then
283: hr_utility.set_message(8301, 'GHR_37008_ALL_PROCEDURE_FAIL');
284: hr_utility.raise_error;
285: end if;
286: end if;
287:
288: -- 200.07.1

Line 318: hr_utility.set_message(8301, 'GHR_37009_ALL_PROCEDURE_FAIL');

314: and p_to_occ_code not between '1510' and '1520')
315: and p_functional_class <> '00'
316: and p_functional_class is not null
317: then
318: hr_utility.set_message(8301, 'GHR_37009_ALL_PROCEDURE_FAIL');
319: hr_utility.raise_error;
320: end if;
321: else
322: if (p_to_occ_code not in

Line 319: hr_utility.raise_error;

315: and p_functional_class <> '00'
316: and p_functional_class is not null
317: then
318: hr_utility.set_message(8301, 'GHR_37009_ALL_PROCEDURE_FAIL');
319: hr_utility.raise_error;
320: end if;
321: else
322: if (p_to_occ_code not in
323: ('0020','0101','0110','0140','0150','0170','0180','0184'

Line 347: hr_utility.set_message(8301, 'GHR_37009_ALL_PROCEDURE_FAIL');

343: and p_to_occ_code not between '1510' and '1520')
344: and p_functional_class <> '00'
345: and p_functional_class is not null
346: then
347: hr_utility.set_message(8301, 'GHR_37009_ALL_PROCEDURE_FAIL');
348: hr_utility.raise_error;
349: end if;
350: end if;
351:

Line 348: hr_utility.raise_error;

344: and p_functional_class <> '00'
345: and p_functional_class is not null
346: then
347: hr_utility.set_message(8301, 'GHR_37009_ALL_PROCEDURE_FAIL');
348: hr_utility.raise_error;
349: end if;
350: end if;
351:
352: end chk_functional_classification;

Line 379: hr_utility.set_message(8301, 'GHR_370_ALL_PROCEDURE_FAIL');

375: to_char(p_submission_date,'MM') <> '03'
376: and
377: to_char(p_submission_date,'MM') <> '09'
378: then
379: hr_utility.set_message(8301, 'GHR_370_ALL_PROCEDURE_FAIL');
380: hr_utility.raise_error;
381: end if;
382: */
383:

Line 380: hr_utility.raise_error;

376: and
377: to_char(p_submission_date,'MM') <> '09'
378: then
379: hr_utility.set_message(8301, 'GHR_370_ALL_PROCEDURE_FAIL');
380: hr_utility.raise_error;
381: end if;
382: */
383:
384: -- 230.02.01

Line 412: hr_utility.set_message(8301, 'GHR_37031_ALL_PROCEDURE_FAIL');

408: -- and
409: -- p_to_pay_status <> 'N'
410:
411: then
412: hr_utility.set_message(8301, 'GHR_37031_ALL_PROCEDURE_FAIL');
413: hr_utility.raise_error;
414: end if;
415:
416: end chk_health_plan;

Line 413: hr_utility.raise_error;

409: -- p_to_pay_status <> 'N'
410:
411: then
412: hr_utility.set_message(8301, 'GHR_37031_ALL_PROCEDURE_FAIL');
413: hr_utility.raise_error;
414: end if;
415:
416: end chk_health_plan;
417:

Line 438: hr_utility.set_message(8301, 'GHR_37029_ALL_PROCEDURE_FAIL');

434: if p_retain_pay_plan = 'WL'
435: and
436: p_retain_grade not between '01' and '15'
437: then
438: hr_utility.set_message(8301, 'GHR_37029_ALL_PROCEDURE_FAIL');
439: hr_utility.raise_error;
440: end if;
441:
442: -- 610.04.1

Line 439: hr_utility.raise_error;

435: and
436: p_retain_grade not between '01' and '15'
437: then
438: hr_utility.set_message(8301, 'GHR_37029_ALL_PROCEDURE_FAIL');
439: hr_utility.raise_error;
440: end if;
441:
442: -- 610.04.1
443: if p_retain_pay_plan = 'WS'

Line 447: hr_utility.set_message(8301, 'GHR_37010_ALL_PROCEDURE_FAIL');

443: if p_retain_pay_plan = 'WS'
444: and
445: p_retain_grade not between '01' and '19'
446: then
447: hr_utility.set_message(8301, 'GHR_37010_ALL_PROCEDURE_FAIL');
448: hr_utility.raise_error;
449: end if;
450:
451: /* Commented as per December 2000 cpdf changes -- vravikan

Line 448: hr_utility.raise_error;

444: and
445: p_retain_grade not between '01' and '19'
446: then
447: hr_utility.set_message(8301, 'GHR_37010_ALL_PROCEDURE_FAIL');
448: hr_utility.raise_error;
449: end if;
450:
451: /* Commented as per December 2000 cpdf changes -- vravikan
452: -- 610.07.1

Line 457: hr_utility.set_message(8301, 'GHR_37011_ALL_PROCEDURE_FAIL');

453: if p_retain_pay_plan = 'GM'
454: and
455: p_retain_grade not between '14' and '15'
456: then
457: hr_utility.set_message(8301, 'GHR_37011_ALL_PROCEDURE_FAIL');
458: hr_utility.raise_error;
459: end if;
460: */
461:

Line 458: hr_utility.raise_error;

454: and
455: p_retain_grade not between '14' and '15'
456: then
457: hr_utility.set_message(8301, 'GHR_37011_ALL_PROCEDURE_FAIL');
458: hr_utility.raise_error;
459: end if;
460: */
461:
462: -- 610.10.1

Line 467: hr_utility.set_message(8301, 'GHR_37012_ALL_PROCEDURE_FAIL');

463: if p_retain_pay_plan = 'GS'
464: and
465: p_retain_grade not between '01' and '15'
466: then
467: hr_utility.set_message(8301, 'GHR_37012_ALL_PROCEDURE_FAIL');
468: hr_utility.raise_error;
469: end if;
470:
471: -- 610.13.1

Line 468: hr_utility.raise_error;

464: and
465: p_retain_grade not between '01' and '15'
466: then
467: hr_utility.set_message(8301, 'GHR_37012_ALL_PROCEDURE_FAIL');
468: hr_utility.raise_error;
469: end if;
470:
471: -- 610.13.1
472: if p_retain_pay_plan = 'WG'

Line 476: hr_utility.set_message(8301, 'GHR_37013_ALL_PROCEDURE_FAIL');

472: if p_retain_pay_plan = 'WG'
473: and
474: p_retain_grade not between '01' and '15'
475: then
476: hr_utility.set_message(8301, 'GHR_37013_ALL_PROCEDURE_FAIL');
477: hr_utility.raise_error;
478: end if;
479:
480:

Line 477: hr_utility.raise_error;

473: and
474: p_retain_grade not between '01' and '15'
475: then
476: hr_utility.set_message(8301, 'GHR_37013_ALL_PROCEDURE_FAIL');
477: hr_utility.raise_error;
478: end if;
479:
480:
481: -- 610.16.1

Line 489: hr_utility.set_message(8301, 'GHR_37014_ALL_PROCEDURE_FAIL');

485: if p_effective_date < fnd_date.canonical_to_date('2005/05/01') then
486: if p_retain_grade is not null and
487: p_pay_rate_determinant_code not in ('A','B','E','F','M','U','V')
488: then
489: hr_utility.set_message(8301, 'GHR_37014_ALL_PROCEDURE_FAIL');
490: hr_utility.set_message_token('PRD_LIST','A, B, E, F, M, U, or V');
491: hr_utility.raise_error;
492: end if;
493: elsif p_effective_date >= fnd_date.canonical_to_date('2005/05/01') then

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

486: if p_retain_grade is not null and
487: p_pay_rate_determinant_code not in ('A','B','E','F','M','U','V')
488: then
489: hr_utility.set_message(8301, 'GHR_37014_ALL_PROCEDURE_FAIL');
490: hr_utility.set_message_token('PRD_LIST','A, B, E, F, M, U, or V');
491: hr_utility.raise_error;
492: end if;
493: elsif p_effective_date >= fnd_date.canonical_to_date('2005/05/01') then
494: if p_retain_grade is not null and

Line 491: hr_utility.raise_error;

487: p_pay_rate_determinant_code not in ('A','B','E','F','M','U','V')
488: then
489: hr_utility.set_message(8301, 'GHR_37014_ALL_PROCEDURE_FAIL');
490: hr_utility.set_message_token('PRD_LIST','A, B, E, F, M, U, or V');
491: hr_utility.raise_error;
492: end if;
493: elsif p_effective_date >= fnd_date.canonical_to_date('2005/05/01') then
494: if p_retain_grade is not null and
495: p_pay_rate_determinant_code not in ('A','B','E','F','U','V')

Line 497: hr_utility.set_message(8301, 'GHR_37014_ALL_PROCEDURE_FAIL');

493: elsif p_effective_date >= fnd_date.canonical_to_date('2005/05/01') then
494: if p_retain_grade is not null and
495: p_pay_rate_determinant_code not in ('A','B','E','F','U','V')
496: then
497: hr_utility.set_message(8301, 'GHR_37014_ALL_PROCEDURE_FAIL');
498: hr_utility.set_message_token('PRD_LIST','A, B, E, F, U, or V');
499: hr_utility.raise_error;
500: end if;
501: end if;

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

494: if p_retain_grade is not null and
495: p_pay_rate_determinant_code not in ('A','B','E','F','U','V')
496: then
497: hr_utility.set_message(8301, 'GHR_37014_ALL_PROCEDURE_FAIL');
498: hr_utility.set_message_token('PRD_LIST','A, B, E, F, U, or V');
499: hr_utility.raise_error;
500: end if;
501: end if;
502: end if;

Line 499: hr_utility.raise_error;

495: p_pay_rate_determinant_code not in ('A','B','E','F','U','V')
496: then
497: hr_utility.set_message(8301, 'GHR_37014_ALL_PROCEDURE_FAIL');
498: hr_utility.set_message_token('PRD_LIST','A, B, E, F, U, or V');
499: hr_utility.raise_error;
500: end if;
501: end if;
502: end if;
503: -- 610.19.1

Line 508: hr_utility.set_message(8301, 'GHR_37015_ALL_PROCEDURE_FAIL');

504: if p_pay_rate_determinant_code in ('A','B','E','F','U','V')
505: and
506: p_retain_grade is null
507: then
508: hr_utility.set_message(8301, 'GHR_37015_ALL_PROCEDURE_FAIL');
509: hr_utility.raise_error;
510: end if;
511:
512: /* Commented as per December 2000 cpdf changes -- vravikan

Line 509: hr_utility.raise_error;

505: and
506: p_retain_grade is null
507: then
508: hr_utility.set_message(8301, 'GHR_37015_ALL_PROCEDURE_FAIL');
509: hr_utility.raise_error;
510: end if;
511:
512: /* Commented as per December 2000 cpdf changes -- vravikan
513: -- 610.25.1

Line 522: hr_utility.set_message(8301, 'GHR_37016_ALL_PROCEDURE_FAIL');

518: p_retain_grade <>'15'
519: and
520: p_retain_grade is not null
521: then
522: hr_utility.set_message(8301, 'GHR_37016_ALL_PROCEDURE_FAIL');
523: hr_utility.raise_error;
524: end if;
525: */
526:

Line 523: hr_utility.raise_error;

519: and
520: p_retain_grade is not null
521: then
522: hr_utility.set_message(8301, 'GHR_37016_ALL_PROCEDURE_FAIL');
523: hr_utility.raise_error;
524: end if;
525: */
526:
527: -- 610.30.1

Line 534: hr_utility.set_message(8301, 'GHR_37017_ALL_PROCEDURE_FAIL');

530: p_retain_grade not between '01' and '15'
531: and
532: p_retain_grade is not null
533: then
534: hr_utility.set_message(8301, 'GHR_37017_ALL_PROCEDURE_FAIL');
535: hr_utility.raise_error;
536: end if;
537:
538: end chk_retain_grade;

Line 535: hr_utility.raise_error;

531: and
532: p_retain_grade is not null
533: then
534: hr_utility.set_message(8301, 'GHR_37017_ALL_PROCEDURE_FAIL');
535: hr_utility.raise_error;
536: end if;
537:
538: end chk_retain_grade;
539:

Line 562: hr_utility.set_message(8301, 'GHR_37663_ALL_PROCEDURE_FAIL');

558: if p_effective_date >= fnd_date.canonical_to_date('2000/10/01') then
559: if p_pay_rate_determinant_code is not null and
560: p_pay_rate_determinant_code in ('A','B','E','F','U','V') and
561: p_retain_pay_plan in ('GH','GM') then
562: hr_utility.set_message(8301, 'GHR_37663_ALL_PROCEDURE_FAIL');
563: hr_utility.raise_error;
564: end if;
565: end if;
566:

Line 563: hr_utility.raise_error;

559: if p_pay_rate_determinant_code is not null and
560: p_pay_rate_determinant_code in ('A','B','E','F','U','V') and
561: p_retain_pay_plan in ('GH','GM') then
562: hr_utility.set_message(8301, 'GHR_37663_ALL_PROCEDURE_FAIL');
563: hr_utility.raise_error;
564: end if;
565: end if;
566:
567:

Line 575: hr_utility.set_message(8301, 'GHR_37018_ALL_PROCEDURE_FAIL');

571: (p_retain_pay_plan is null
572: or
573: p_retain_step is null )
574: then
575: hr_utility.set_message(8301, 'GHR_37018_ALL_PROCEDURE_FAIL');
576: hr_utility.raise_error;
577: end if;
578:
579: /* Commented as per December 2000 cpdf changes -- vravikan

Line 576: hr_utility.raise_error;

572: or
573: p_retain_step is null )
574: then
575: hr_utility.set_message(8301, 'GHR_37018_ALL_PROCEDURE_FAIL');
576: hr_utility.raise_error;
577: end if;
578:
579: /* Commented as per December 2000 cpdf changes -- vravikan
580: -- 620.10.1

Line 585: hr_utility.set_message(8301, 'GHR_37019_ALL_PROCEDURE_FAIL');

581: if p_to_pay_plan = 'GS'
582: and
583: p_retain_pay_plan = 'GM'
584: then
585: hr_utility.set_message(8301, 'GHR_37019_ALL_PROCEDURE_FAIL');
586: hr_utility.raise_error;
587: end if;
588: */
589:

Line 586: hr_utility.raise_error;

582: and
583: p_retain_pay_plan = 'GM'
584: then
585: hr_utility.set_message(8301, 'GHR_37019_ALL_PROCEDURE_FAIL');
586: hr_utility.raise_error;
587: end if;
588: */
589:
590: /* Commented as per December 2000 cpdf changes -- vravikan

Line 596: hr_utility.set_message(8301, 'GHR_37020_ALL_PROCEDURE_FAIL');

592: if p_to_pay_plan = 'GM'
593: and
594: p_retain_pay_plan = 'GS'
595: then
596: hr_utility.set_message(8301, 'GHR_37020_ALL_PROCEDURE_FAIL');
597: hr_utility.raise_error;
598: end if;
599:
600: */

Line 597: hr_utility.raise_error;

593: and
594: p_retain_pay_plan = 'GS'
595: then
596: hr_utility.set_message(8301, 'GHR_37020_ALL_PROCEDURE_FAIL');
597: hr_utility.raise_error;
598: end if;
599:
600: */
601: end chk_retain_pay_plan;

Line 632: hr_utility.set_message(8301, 'GHR_37021_ALL_PROCEDURE_FAIL');

628: p_retain_grade between '01' and '15' and
629: p_retain_step not between '01' and '10' and
630: p_retain_step is not null
631: then
632: hr_utility.set_message(8301, 'GHR_37021_ALL_PROCEDURE_FAIL');
633: hr_utility.set_message_token('PRD_LIST','A, B, E, F, or M');
634: hr_utility.raise_error;
635: end if;
636: elsif p_effective_date >= to_date('2005/05/01','yyyy/mm/dd') then

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

629: p_retain_step not between '01' and '10' and
630: p_retain_step is not null
631: then
632: hr_utility.set_message(8301, 'GHR_37021_ALL_PROCEDURE_FAIL');
633: hr_utility.set_message_token('PRD_LIST','A, B, E, F, or M');
634: hr_utility.raise_error;
635: end if;
636: elsif p_effective_date >= to_date('2005/05/01','yyyy/mm/dd') then
637: if p_pay_rate_determinant_code in ('A','B','E','F') and

Line 634: hr_utility.raise_error;

630: p_retain_step is not null
631: then
632: hr_utility.set_message(8301, 'GHR_37021_ALL_PROCEDURE_FAIL');
633: hr_utility.set_message_token('PRD_LIST','A, B, E, F, or M');
634: hr_utility.raise_error;
635: end if;
636: elsif p_effective_date >= to_date('2005/05/01','yyyy/mm/dd') then
637: if p_pay_rate_determinant_code in ('A','B','E','F') and
638: p_Cur_Appt_Auth_1 <> 'UAM' and

Line 646: hr_utility.set_message(8301, 'GHR_37021_ALL_PROCEDURE_FAIL');

642: p_retain_grade between '01' and '15' and
643: p_retain_step not between '01' and '10' and
644: p_retain_step is not null
645: then
646: hr_utility.set_message(8301, 'GHR_37021_ALL_PROCEDURE_FAIL');
647: hr_utility.set_message_token('PRD_LIST','A, B, E, or F');
648: hr_utility.raise_error;
649: end if;
650: end if;

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

643: p_retain_step not between '01' and '10' and
644: p_retain_step is not null
645: then
646: hr_utility.set_message(8301, 'GHR_37021_ALL_PROCEDURE_FAIL');
647: hr_utility.set_message_token('PRD_LIST','A, B, E, or F');
648: hr_utility.raise_error;
649: end if;
650: end if;
651:

Line 648: hr_utility.raise_error;

644: p_retain_step is not null
645: then
646: hr_utility.set_message(8301, 'GHR_37021_ALL_PROCEDURE_FAIL');
647: hr_utility.set_message_token('PRD_LIST','A, B, E, or F');
648: hr_utility.raise_error;
649: end if;
650: end if;
651:
652:

Line 665: hr_utility.set_message(8301, 'GHR_37413_ALL_PROCEDURE_FAIL');

661: p_retain_step <> '00'
662: and
663: p_retain_step is not null
664: then
665: hr_utility.set_message(8301, 'GHR_37413_ALL_PROCEDURE_FAIL');
666: hr_utility.raise_error;
667: end if;
668: else
669: if p_pay_rate_determinant_code in ('A','B','E','F','M')

Line 666: hr_utility.raise_error;

662: and
663: p_retain_step is not null
664: then
665: hr_utility.set_message(8301, 'GHR_37413_ALL_PROCEDURE_FAIL');
666: hr_utility.raise_error;
667: end if;
668: else
669: if p_pay_rate_determinant_code in ('A','B','E','F','M')
670: and

Line 679: hr_utility.set_message(8301, 'GHR_37022_ALL_PROCEDURE_FAIL');

675: p_retain_step <> '99'
676: and
677: p_retain_step is not null
678: then
679: hr_utility.set_message(8301, 'GHR_37022_ALL_PROCEDURE_FAIL');
680: hr_utility.raise_error;
681: end if;
682: end if;
683: */

Line 680: hr_utility.raise_error;

676: and
677: p_retain_step is not null
678: then
679: hr_utility.set_message(8301, 'GHR_37022_ALL_PROCEDURE_FAIL');
680: hr_utility.raise_error;
681: end if;
682: end if;
683: */
684:

Line 698: hr_utility.set_message(8301, 'GHR_37023_ALL_PROCEDURE_FAIL');

694: p_retain_step <> '00'
695: and
696: p_retain_step is not null
697: then
698: hr_utility.set_message(8301, 'GHR_37023_ALL_PROCEDURE_FAIL');
699: hr_utility.raise_error;
700: end if;
701: end if;
702: end chk_retain_step;

Line 699: hr_utility.raise_error;

695: and
696: p_retain_step is not null
697: then
698: hr_utility.set_message(8301, 'GHR_37023_ALL_PROCEDURE_FAIL');
699: hr_utility.raise_error;
700: end if;
701: end if;
702: end chk_retain_step;
703:

Line 725: hr_utility.set_message(8301, 'GHR_37024_ALL_PROCEDURE_FAIL');

721: IF p_effective_date < fnd_date.canonical_to_date('2013/01/01') THEN
722: if p_retirement_plan_code in ('K','L','M','N','O','P')
723: and NVL(p_fers_coverage,'#') NOT IN ( 'A', 'E' )
724: then
725: hr_utility.set_message(8301, 'GHR_37024_ALL_PROCEDURE_FAIL');
726: hr_utility.set_message_token('RET_PLAN','K, L, M, N, O or P');
727: hr_utility.raise_error;
728: end if;
729: --Begin Bug# 15941036

Line 726: hr_utility.set_message_token('RET_PLAN','K, L, M, N, O or P');

722: if p_retirement_plan_code in ('K','L','M','N','O','P')
723: and NVL(p_fers_coverage,'#') NOT IN ( 'A', 'E' )
724: then
725: hr_utility.set_message(8301, 'GHR_37024_ALL_PROCEDURE_FAIL');
726: hr_utility.set_message_token('RET_PLAN','K, L, M, N, O or P');
727: hr_utility.raise_error;
728: end if;
729: --Begin Bug# 15941036
730: ELSE

Line 727: hr_utility.raise_error;

723: and NVL(p_fers_coverage,'#') NOT IN ( 'A', 'E' )
724: then
725: hr_utility.set_message(8301, 'GHR_37024_ALL_PROCEDURE_FAIL');
726: hr_utility.set_message_token('RET_PLAN','K, L, M, N, O or P');
727: hr_utility.raise_error;
728: end if;
729: --Begin Bug# 15941036
730: ELSE
731: IF p_retirement_plan_code in ('K','L','M','N','O','P','KR','LR','MR','NR','OR','PR')

Line 733: hr_utility.set_message(8301, 'GHR_37024_ALL_PROCEDURE_FAIL');

729: --Begin Bug# 15941036
730: ELSE
731: IF p_retirement_plan_code in ('K','L','M','N','O','P','KR','LR','MR','NR','OR','PR')
732: AND NVL(p_fers_coverage,'#') NOT IN ( 'A', 'E' ) THEN
733: hr_utility.set_message(8301, 'GHR_37024_ALL_PROCEDURE_FAIL');
734: hr_utility.set_message_token('RET_PLAN','K, KR, L, LR, M, MR, N, NR, O, OR, P or PR');
735: hr_utility.raise_error;
736: END IF;
737: END IF;

Line 734: hr_utility.set_message_token('RET_PLAN','K, KR, L, LR, M, MR, N, NR, O, OR, P or PR');

730: ELSE
731: IF p_retirement_plan_code in ('K','L','M','N','O','P','KR','LR','MR','NR','OR','PR')
732: AND NVL(p_fers_coverage,'#') NOT IN ( 'A', 'E' ) THEN
733: hr_utility.set_message(8301, 'GHR_37024_ALL_PROCEDURE_FAIL');
734: hr_utility.set_message_token('RET_PLAN','K, KR, L, LR, M, MR, N, NR, O, OR, P or PR');
735: hr_utility.raise_error;
736: END IF;
737: END IF;
738: --End Bug# 15941036

Line 735: hr_utility.raise_error;

731: IF p_retirement_plan_code in ('K','L','M','N','O','P','KR','LR','MR','NR','OR','PR')
732: AND NVL(p_fers_coverage,'#') NOT IN ( 'A', 'E' ) THEN
733: hr_utility.set_message(8301, 'GHR_37024_ALL_PROCEDURE_FAIL');
734: hr_utility.set_message_token('RET_PLAN','K, KR, L, LR, M, MR, N, NR, O, OR, P or PR');
735: hr_utility.raise_error;
736: END IF;
737: END IF;
738: --End Bug# 15941036
739: -- 640.14.1

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

747: p_retirement_plan_code not in ('K','L','M','N','O','P')
748: and
749: p_retirement_plan_code is not null
750: then
751: hr_utility.set_message(8301, 'GHR_37025_ALL_PROCEDURE_FAIL');
752: hr_utility.set_message_token('RET_PLAN','K, L, M, N, O or P');
753: hr_utility.raise_error;
754: end if;
755: --Begin Bug# 15941036

Line 752: hr_utility.set_message_token('RET_PLAN','K, L, M, N, O or P');

748: and
749: p_retirement_plan_code is not null
750: then
751: hr_utility.set_message(8301, 'GHR_37025_ALL_PROCEDURE_FAIL');
752: hr_utility.set_message_token('RET_PLAN','K, L, M, N, O or P');
753: hr_utility.raise_error;
754: end if;
755: --Begin Bug# 15941036
756: ELSE

Line 753: hr_utility.raise_error;

749: p_retirement_plan_code is not null
750: then
751: hr_utility.set_message(8301, 'GHR_37025_ALL_PROCEDURE_FAIL');
752: hr_utility.set_message_token('RET_PLAN','K, L, M, N, O or P');
753: hr_utility.raise_error;
754: end if;
755: --Begin Bug# 15941036
756: ELSE
757: IF p_fers_coverage IN ('A','E')

Line 760: hr_utility.set_message(8301, 'GHR_37025_ALL_PROCEDURE_FAIL');

756: ELSE
757: IF p_fers_coverage IN ('A','E')
758: AND p_retirement_plan_code NOT IN ('K','L','M','N','O','P','KR','LR','MR','NR','OR','PR')
759: AND p_retirement_plan_code IS NOT NULL THEN
760: hr_utility.set_message(8301, 'GHR_37025_ALL_PROCEDURE_FAIL');
761: hr_utility.set_message_token('RET_PLAN','K, KR, L, LR, M, MR, N, NR, O, OR, P or PR');
762: hr_utility.raise_error;
763: END IF;
764: END IF;

Line 761: hr_utility.set_message_token('RET_PLAN','K, KR, L, LR, M, MR, N, NR, O, OR, P or PR');

757: IF p_fers_coverage IN ('A','E')
758: AND p_retirement_plan_code NOT IN ('K','L','M','N','O','P','KR','LR','MR','NR','OR','PR')
759: AND p_retirement_plan_code IS NOT NULL THEN
760: hr_utility.set_message(8301, 'GHR_37025_ALL_PROCEDURE_FAIL');
761: hr_utility.set_message_token('RET_PLAN','K, KR, L, LR, M, MR, N, NR, O, OR, P or PR');
762: hr_utility.raise_error;
763: END IF;
764: END IF;
765: --End Bug# 15941036

Line 762: hr_utility.raise_error;

758: AND p_retirement_plan_code NOT IN ('K','L','M','N','O','P','KR','LR','MR','NR','OR','PR')
759: AND p_retirement_plan_code IS NOT NULL THEN
760: hr_utility.set_message(8301, 'GHR_37025_ALL_PROCEDURE_FAIL');
761: hr_utility.set_message_token('RET_PLAN','K, KR, L, LR, M, MR, N, NR, O, OR, P or PR');
762: hr_utility.raise_error;
763: END IF;
764: END IF;
765: --End Bug# 15941036
766: end chk_retirement_plan;

Line 792: hr_utility.set_message(8301, 'GHR_37026_ALL_PROCEDURE_FAIL');

788: if p_pay_rate_determinant_code not in ('5','6','E','F','M')
789: and
790: p_special_pay_table_id is not null
791: then
792: hr_utility.set_message(8301, 'GHR_37026_ALL_PROCEDURE_FAIL');
793: hr_utility.raise_error;
794: end if;
795: */
796:

Line 793: hr_utility.raise_error;

789: and
790: p_special_pay_table_id is not null
791: then
792: hr_utility.set_message(8301, 'GHR_37026_ALL_PROCEDURE_FAIL');
793: hr_utility.raise_error;
794: end if;
795: */
796:
797: -- 695.10.1

Line 811: hr_utility.set_message(8301, 'GHR_37027_ALL_PROCEDURE_FAIL');

807: p_pay_rate_determinant_code in ('5','6','E','F','M')
808: and
809: p_special_pay_table_id is null
810: then
811: hr_utility.set_message(8301, 'GHR_37027_ALL_PROCEDURE_FAIL');
812: hr_utility.set_message_token('PRD_LIST','5, 6, E, F, or M');
813: hr_utility.raise_error;
814: end if;
815: ELSIF p_effective_date >= to_date('2005/05/01','yyyy/mm/dd') THEN

Line 812: hr_utility.set_message_token('PRD_LIST','5, 6, E, F, or M');

808: and
809: p_special_pay_table_id is null
810: then
811: hr_utility.set_message(8301, 'GHR_37027_ALL_PROCEDURE_FAIL');
812: hr_utility.set_message_token('PRD_LIST','5, 6, E, F, or M');
813: hr_utility.raise_error;
814: end if;
815: ELSIF p_effective_date >= to_date('2005/05/01','yyyy/mm/dd') THEN
816: if p_to_pay_plan in ('GM','GS') and

Line 813: hr_utility.raise_error;

809: p_special_pay_table_id is null
810: then
811: hr_utility.set_message(8301, 'GHR_37027_ALL_PROCEDURE_FAIL');
812: hr_utility.set_message_token('PRD_LIST','5, 6, E, F, or M');
813: hr_utility.raise_error;
814: end if;
815: ELSIF p_effective_date >= to_date('2005/05/01','yyyy/mm/dd') THEN
816: if p_to_pay_plan in ('GM','GS') and
817: p_pay_rate_determinant_code in ('5','6','E','F') and

Line 820: hr_utility.set_message(8301, 'GHR_37027_ALL_PROCEDURE_FAIL');

816: if p_to_pay_plan in ('GM','GS') and
817: p_pay_rate_determinant_code in ('5','6','E','F') and
818: p_special_pay_table_id is null
819: then
820: hr_utility.set_message(8301, 'GHR_37027_ALL_PROCEDURE_FAIL');
821: hr_utility.set_message_token('PRD_LIST','5, 6, E, or F');
822: hr_utility.raise_error;
823: end if;
824: END IF;

Line 821: hr_utility.set_message_token('PRD_LIST','5, 6, E, or F');

817: p_pay_rate_determinant_code in ('5','6','E','F') and
818: p_special_pay_table_id is null
819: then
820: hr_utility.set_message(8301, 'GHR_37027_ALL_PROCEDURE_FAIL');
821: hr_utility.set_message_token('PRD_LIST','5, 6, E, or F');
822: hr_utility.raise_error;
823: end if;
824: END IF;
825:

Line 822: hr_utility.raise_error;

818: p_special_pay_table_id is null
819: then
820: hr_utility.set_message(8301, 'GHR_37027_ALL_PROCEDURE_FAIL');
821: hr_utility.set_message_token('PRD_LIST','5, 6, E, or F');
822: hr_utility.raise_error;
823: end if;
824: END IF;
825:
826: -- FWFA Changes

Line 857: hr_utility.set_message(8301, 'GHR_37028_ALL_PROCEDURE_FAIL');

853: substr(p_duty_station_lookup_code,2,1) not in ('1','2','3','4','5','6','7','8','9','0')
854: and
855: p_duty_station_lookup_code is not null
856: then
857: hr_utility.set_message(8301, 'GHR_37028_ALL_PROCEDURE_FAIL');
858: hr_utility.raise_error;
859: end if;*/
860:
861: end chk_us_citizenship;

Line 858: hr_utility.raise_error;

854: and
855: p_duty_station_lookup_code is not null
856: then
857: hr_utility.set_message(8301, 'GHR_37028_ALL_PROCEDURE_FAIL');
858: hr_utility.raise_error;
859: end if;*/
860:
861: end chk_us_citizenship;
862: --

Line 878: hr_utility.set_message(8301, 'GHR_37887_ALL_PROCEDURE_FAIL');

874: -- Procedure added to check the century info.
875: --
876: -- 110.00.1
877: if to_number(to_char(p_date_of_birth, 'YYYY')) NOT BETWEEN 1900 and 2099 then
878: hr_utility.set_message(8301, 'GHR_37887_ALL_PROCEDURE_FAIL');
879: hr_utility.raise_error;
880: end if;
881:
882: -- 140.00.2

Line 879: hr_utility.raise_error;

875: --
876: -- 110.00.1
877: if to_number(to_char(p_date_of_birth, 'YYYY')) NOT BETWEEN 1900 and 2099 then
878: hr_utility.set_message(8301, 'GHR_37887_ALL_PROCEDURE_FAIL');
879: hr_utility.raise_error;
880: end if;
881:
882: -- 140.00.2
883: if to_number(to_char(p_effective_date, 'YYYY')) NOT BETWEEN 1900 and 2099 then

Line 884: hr_utility.set_message(8301, 'GHR_37888_ALL_PROCEDURE_FAIL');

880: end if;
881:
882: -- 140.00.2
883: if to_number(to_char(p_effective_date, 'YYYY')) NOT BETWEEN 1900 and 2099 then
884: hr_utility.set_message(8301, 'GHR_37888_ALL_PROCEDURE_FAIL');
885: hr_utility.raise_error;
886: end if;
887:
888: -- 660.00.1

Line 885: hr_utility.raise_error;

881:
882: -- 140.00.2
883: if to_number(to_char(p_effective_date, 'YYYY')) NOT BETWEEN 1900 and 2099 then
884: hr_utility.set_message(8301, 'GHR_37888_ALL_PROCEDURE_FAIL');
885: hr_utility.raise_error;
886: end if;
887:
888: -- 660.00.1
889:

Line 899: hr_utility.set_message(8301, 'GHR_37889_ALL_PROCEDURE_FAIL');

895: -- removed as both branchings refer to
896: -- same message
897: if to_number(to_char(p_service_computation_date, 'YYYY'))
898: NOT BETWEEN 1900 and 2099 then
899: hr_utility.set_message(8301, 'GHR_37889_ALL_PROCEDURE_FAIL');
900: hr_utility.raise_error;
901: end if;
902:
903: -- 780.00.3

Line 900: hr_utility.raise_error;

896: -- same message
897: if to_number(to_char(p_service_computation_date, 'YYYY'))
898: NOT BETWEEN 1900 and 2099 then
899: hr_utility.set_message(8301, 'GHR_37889_ALL_PROCEDURE_FAIL');
900: hr_utility.raise_error;
901: end if;
902:
903: -- 780.00.3
904: if to_number(p_year_degree_attained) NOT BETWEEN 1900 and 2099 then

Line 905: hr_utility.set_message(8301, 'GHR_37890_ALL_PROCEDURE_FAIL');

901: end if;
902:
903: -- 780.00.3
904: if to_number(p_year_degree_attained) NOT BETWEEN 1900 and 2099 then
905: hr_utility.set_message(8301, 'GHR_37890_ALL_PROCEDURE_FAIL');
906: hr_utility.raise_error;
907: end if;
908:
909: -- 472.00.3

Line 906: hr_utility.raise_error;

902:
903: -- 780.00.3
904: if to_number(p_year_degree_attained) NOT BETWEEN 1900 and 2099 then
905: hr_utility.set_message(8301, 'GHR_37890_ALL_PROCEDURE_FAIL');
906: hr_utility.raise_error;
907: end if;
908:
909: -- 472.00.3
910: if to_number(to_char(fnd_date.canonical_to_date(p_rating_of_record_period), 'yyyy'))

Line 912: hr_utility.set_message(8301, 'GHR_37891_ALL_PROCEDURE_FAIL');

908:
909: -- 472.00.3
910: if to_number(to_char(fnd_date.canonical_to_date(p_rating_of_record_period), 'yyyy'))
911: NOT BETWEEN 1900 and 2099 then
912: hr_utility.set_message(8301, 'GHR_37891_ALL_PROCEDURE_FAIL');
913: hr_utility.raise_error;
914: end if;
915: --Bug# 4753117 28-Feb-07 Veeramani adding edit for the Appraisal start date
916: if to_number(to_char(fnd_date.canonical_to_date(p_rating_of_record_per_starts), 'yyyy'))

Line 913: hr_utility.raise_error;

909: -- 472.00.3
910: if to_number(to_char(fnd_date.canonical_to_date(p_rating_of_record_period), 'yyyy'))
911: NOT BETWEEN 1900 and 2099 then
912: hr_utility.set_message(8301, 'GHR_37891_ALL_PROCEDURE_FAIL');
913: hr_utility.raise_error;
914: end if;
915: --Bug# 4753117 28-Feb-07 Veeramani adding edit for the Appraisal start date
916: if to_number(to_char(fnd_date.canonical_to_date(p_rating_of_record_per_starts), 'yyyy'))
917: NOT BETWEEN 1900 and 2099 then

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

914: end if;
915: --Bug# 4753117 28-Feb-07 Veeramani adding edit for the Appraisal start date
916: if to_number(to_char(fnd_date.canonical_to_date(p_rating_of_record_per_starts), 'yyyy'))
917: NOT BETWEEN 1900 and 2099 then
918: hr_utility.set_message(8301, 'GHR_37891_ALL_PROCEDURE_FAIL');
919: hr_utility.raise_error;
920: end if;
921:
922:

Line 919: hr_utility.raise_error;

915: --Bug# 4753117 28-Feb-07 Veeramani adding edit for the Appraisal start date
916: if to_number(to_char(fnd_date.canonical_to_date(p_rating_of_record_per_starts), 'yyyy'))
917: NOT BETWEEN 1900 and 2099 then
918: hr_utility.set_message(8301, 'GHR_37891_ALL_PROCEDURE_FAIL');
919: hr_utility.raise_error;
920: end if;
921:
922:
923: