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.

[Home] [Help]

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.13.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.13.1
157: if p_to_pay_plan in ('AL','CA','ES','EX','SL','ST')

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

159: p_flsa_category <> 'E'
160: and
161: p_flsa_category is not null
162: then
163: hr_utility.set_message(8301, 'GHR_37007_ALL_PROCEDURE_FAIL');
164: hr_utility.raise_error;
165: end if;
166:
167: end chk_fsla_category;

Line 164: hr_utility.raise_error;

160: and
161: p_flsa_category is not null
162: then
163: hr_utility.set_message(8301, 'GHR_37007_ALL_PROCEDURE_FAIL');
164: hr_utility.raise_error;
165: end if;
166:
167: end chk_fsla_category;
168:

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

207: or p_to_occ_code between '1510' and '1520')
208: and to_number(p_functional_class) <= 10
209: and p_functional_class is not null
210: then
211: hr_utility.set_message(8301, 'GHR_37008_ALL_PROCEDURE_FAIL');
212: hr_utility.raise_error;
213: end if;
214: else
215: if (p_to_occ_code in

Line 212: hr_utility.raise_error;

208: and to_number(p_functional_class) <= 10
209: and p_functional_class is not null
210: then
211: hr_utility.set_message(8301, 'GHR_37008_ALL_PROCEDURE_FAIL');
212: hr_utility.raise_error;
213: end if;
214: else
215: if (p_to_occ_code in
216: ('0020','0101','0110','0140','0150','0170','0180','0184'

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

236: or p_to_occ_code between '1510' and '1520')
237: and to_number(p_functional_class) <= 10
238: and p_functional_class is not null
239: then
240: hr_utility.set_message(8301, 'GHR_37008_ALL_PROCEDURE_FAIL');
241: hr_utility.raise_error;
242: end if;
243: end if;
244:

Line 241: hr_utility.raise_error;

237: and to_number(p_functional_class) <= 10
238: and p_functional_class is not null
239: then
240: hr_utility.set_message(8301, 'GHR_37008_ALL_PROCEDURE_FAIL');
241: hr_utility.raise_error;
242: end if;
243: end if;
244:
245: -- 200.07.1

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

270: and p_to_occ_code not between '1510' and '1520')
271: and p_functional_class <> '00'
272: and p_functional_class is not null
273: then
274: hr_utility.set_message(8301, 'GHR_37009_ALL_PROCEDURE_FAIL');
275: hr_utility.raise_error;
276: end if;
277: else
278: if (p_to_occ_code not in

Line 275: hr_utility.raise_error;

271: and p_functional_class <> '00'
272: and p_functional_class is not null
273: then
274: hr_utility.set_message(8301, 'GHR_37009_ALL_PROCEDURE_FAIL');
275: hr_utility.raise_error;
276: end if;
277: else
278: if (p_to_occ_code not in
279: ('0020','0101','0110','0140','0150','0170','0180','0184'

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

299: and p_to_occ_code not between '1510' and '1520')
300: and p_functional_class <> '00'
301: and p_functional_class is not null
302: then
303: hr_utility.set_message(8301, 'GHR_37009_ALL_PROCEDURE_FAIL');
304: hr_utility.raise_error;
305: end if;
306: end if;
307:

Line 304: hr_utility.raise_error;

300: and p_functional_class <> '00'
301: and p_functional_class is not null
302: then
303: hr_utility.set_message(8301, 'GHR_37009_ALL_PROCEDURE_FAIL');
304: hr_utility.raise_error;
305: end if;
306: end if;
307:
308: end chk_functional_classification;

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

331: to_char(p_submission_date,'MM') <> '03'
332: and
333: to_char(p_submission_date,'MM') <> '09'
334: then
335: hr_utility.set_message(8301, 'GHR_370_ALL_PROCEDURE_FAIL');
336: hr_utility.raise_error;
337: end if;
338: */
339:

Line 336: hr_utility.raise_error;

332: and
333: to_char(p_submission_date,'MM') <> '09'
334: then
335: hr_utility.set_message(8301, 'GHR_370_ALL_PROCEDURE_FAIL');
336: hr_utility.raise_error;
337: end if;
338: */
339:
340: -- 230.02.01

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

364: -- and
365: -- p_to_pay_status <> 'N'
366:
367: then
368: hr_utility.set_message(8301, 'GHR_37031_ALL_PROCEDURE_FAIL');
369: hr_utility.raise_error;
370: end if;
371:
372: end chk_health_plan;

Line 369: hr_utility.raise_error;

365: -- p_to_pay_status <> 'N'
366:
367: then
368: hr_utility.set_message(8301, 'GHR_37031_ALL_PROCEDURE_FAIL');
369: hr_utility.raise_error;
370: end if;
371:
372: end chk_health_plan;
373:

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

390: if p_retain_pay_plan = 'WL'
391: and
392: p_retain_grade not between '01' and '15'
393: then
394: hr_utility.set_message(8301, 'GHR_37029_ALL_PROCEDURE_FAIL');
395: hr_utility.raise_error;
396: end if;
397:
398: -- 610.04.1

Line 395: hr_utility.raise_error;

391: and
392: p_retain_grade not between '01' and '15'
393: then
394: hr_utility.set_message(8301, 'GHR_37029_ALL_PROCEDURE_FAIL');
395: hr_utility.raise_error;
396: end if;
397:
398: -- 610.04.1
399: if p_retain_pay_plan = 'WS'

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

399: if p_retain_pay_plan = 'WS'
400: and
401: p_retain_grade not between '01' and '19'
402: then
403: hr_utility.set_message(8301, 'GHR_37010_ALL_PROCEDURE_FAIL');
404: hr_utility.raise_error;
405: end if;
406:
407: /* Commented as per December 2000 cpdf changes -- vravikan

Line 404: hr_utility.raise_error;

400: and
401: p_retain_grade not between '01' and '19'
402: then
403: hr_utility.set_message(8301, 'GHR_37010_ALL_PROCEDURE_FAIL');
404: hr_utility.raise_error;
405: end if;
406:
407: /* Commented as per December 2000 cpdf changes -- vravikan
408: -- 610.07.1

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

409: if p_retain_pay_plan = 'GM'
410: and
411: p_retain_grade not between '14' and '15'
412: then
413: hr_utility.set_message(8301, 'GHR_37011_ALL_PROCEDURE_FAIL');
414: hr_utility.raise_error;
415: end if;
416: */
417:

Line 414: hr_utility.raise_error;

410: and
411: p_retain_grade not between '14' and '15'
412: then
413: hr_utility.set_message(8301, 'GHR_37011_ALL_PROCEDURE_FAIL');
414: hr_utility.raise_error;
415: end if;
416: */
417:
418: -- 610.10.1

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

419: if p_retain_pay_plan = 'GS'
420: and
421: p_retain_grade not between '01' and '15'
422: then
423: hr_utility.set_message(8301, 'GHR_37012_ALL_PROCEDURE_FAIL');
424: hr_utility.raise_error;
425: end if;
426:
427: -- 610.13.1

Line 424: hr_utility.raise_error;

420: and
421: p_retain_grade not between '01' and '15'
422: then
423: hr_utility.set_message(8301, 'GHR_37012_ALL_PROCEDURE_FAIL');
424: hr_utility.raise_error;
425: end if;
426:
427: -- 610.13.1
428: if p_retain_pay_plan = 'WG'

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

428: if p_retain_pay_plan = 'WG'
429: and
430: p_retain_grade not between '01' and '15'
431: then
432: hr_utility.set_message(8301, 'GHR_37013_ALL_PROCEDURE_FAIL');
433: hr_utility.raise_error;
434: end if;
435:
436:

Line 433: hr_utility.raise_error;

429: and
430: p_retain_grade not between '01' and '15'
431: then
432: hr_utility.set_message(8301, 'GHR_37013_ALL_PROCEDURE_FAIL');
433: hr_utility.raise_error;
434: end if;
435:
436:
437: -- 610.16.1

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

439: if p_effective_date < fnd_date.canonical_to_date('2005/05/01') then
440: if p_retain_grade is not null and
441: p_pay_rate_determinant_code not in ('A','B','E','F','M','U','V')
442: then
443: hr_utility.set_message(8301, 'GHR_37014_ALL_PROCEDURE_FAIL');
444: hr_utility.set_message_token('PRD_LIST','A, B, E, F, M, U, or V');
445: hr_utility.raise_error;
446: end if;
447: elsif p_effective_date >= fnd_date.canonical_to_date('2005/05/01') then

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

440: if p_retain_grade is not null and
441: p_pay_rate_determinant_code not in ('A','B','E','F','M','U','V')
442: then
443: hr_utility.set_message(8301, 'GHR_37014_ALL_PROCEDURE_FAIL');
444: hr_utility.set_message_token('PRD_LIST','A, B, E, F, M, U, or V');
445: hr_utility.raise_error;
446: end if;
447: elsif p_effective_date >= fnd_date.canonical_to_date('2005/05/01') then
448: if p_retain_grade is not null and

Line 445: hr_utility.raise_error;

441: p_pay_rate_determinant_code not in ('A','B','E','F','M','U','V')
442: then
443: hr_utility.set_message(8301, 'GHR_37014_ALL_PROCEDURE_FAIL');
444: hr_utility.set_message_token('PRD_LIST','A, B, E, F, M, U, or V');
445: hr_utility.raise_error;
446: end if;
447: elsif p_effective_date >= fnd_date.canonical_to_date('2005/05/01') then
448: if p_retain_grade is not null and
449: p_pay_rate_determinant_code not in ('A','B','E','F','U','V')

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

447: elsif p_effective_date >= fnd_date.canonical_to_date('2005/05/01') then
448: if p_retain_grade is not null and
449: p_pay_rate_determinant_code not in ('A','B','E','F','U','V')
450: then
451: hr_utility.set_message(8301, 'GHR_37014_ALL_PROCEDURE_FAIL');
452: hr_utility.set_message_token('PRD_LIST','A, B, E, F, U, or V');
453: hr_utility.raise_error;
454: end if;
455: end if;

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

448: if p_retain_grade is not null and
449: p_pay_rate_determinant_code not in ('A','B','E','F','U','V')
450: then
451: hr_utility.set_message(8301, 'GHR_37014_ALL_PROCEDURE_FAIL');
452: hr_utility.set_message_token('PRD_LIST','A, B, E, F, U, or V');
453: hr_utility.raise_error;
454: end if;
455: end if;
456:

Line 453: hr_utility.raise_error;

449: p_pay_rate_determinant_code not in ('A','B','E','F','U','V')
450: then
451: hr_utility.set_message(8301, 'GHR_37014_ALL_PROCEDURE_FAIL');
452: hr_utility.set_message_token('PRD_LIST','A, B, E, F, U, or V');
453: hr_utility.raise_error;
454: end if;
455: end if;
456:
457: -- 610.19.1

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

458: if p_pay_rate_determinant_code in ('A','B','E','F','U','V')
459: and
460: p_retain_grade is null
461: then
462: hr_utility.set_message(8301, 'GHR_37015_ALL_PROCEDURE_FAIL');
463: hr_utility.raise_error;
464: end if;
465:
466: /* Commented as per December 2000 cpdf changes -- vravikan

Line 463: hr_utility.raise_error;

459: and
460: p_retain_grade is null
461: then
462: hr_utility.set_message(8301, 'GHR_37015_ALL_PROCEDURE_FAIL');
463: hr_utility.raise_error;
464: end if;
465:
466: /* Commented as per December 2000 cpdf changes -- vravikan
467: -- 610.25.1

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

472: p_retain_grade <>'15'
473: and
474: p_retain_grade is not null
475: then
476: hr_utility.set_message(8301, 'GHR_37016_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 is not null
475: then
476: hr_utility.set_message(8301, 'GHR_37016_ALL_PROCEDURE_FAIL');
477: hr_utility.raise_error;
478: end if;
479: */
480:
481: -- 610.30.1

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

484: p_retain_grade not between '01' and '15'
485: and
486: p_retain_grade is not null
487: then
488: hr_utility.set_message(8301, 'GHR_37017_ALL_PROCEDURE_FAIL');
489: hr_utility.raise_error;
490: end if;
491:
492: end chk_retain_grade;

Line 489: hr_utility.raise_error;

485: and
486: p_retain_grade is not null
487: then
488: hr_utility.set_message(8301, 'GHR_37017_ALL_PROCEDURE_FAIL');
489: hr_utility.raise_error;
490: end if;
491:
492: end chk_retain_grade;
493:

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

512: if p_effective_date >= fnd_date.canonical_to_date('2000/10/01') then
513: if p_pay_rate_determinant_code is not null and
514: p_pay_rate_determinant_code in ('A','B','E','F','U','V') and
515: p_retain_pay_plan in ('GH','GM') then
516: hr_utility.set_message(8301, 'GHR_37663_ALL_PROCEDURE_FAIL');
517: hr_utility.raise_error;
518: end if;
519: end if;
520:

Line 517: hr_utility.raise_error;

513: if p_pay_rate_determinant_code is not null and
514: p_pay_rate_determinant_code in ('A','B','E','F','U','V') and
515: p_retain_pay_plan in ('GH','GM') then
516: hr_utility.set_message(8301, 'GHR_37663_ALL_PROCEDURE_FAIL');
517: hr_utility.raise_error;
518: end if;
519: end if;
520:
521:

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

525: (p_retain_pay_plan is null
526: or
527: p_retain_step is null )
528: then
529: hr_utility.set_message(8301, 'GHR_37018_ALL_PROCEDURE_FAIL');
530: hr_utility.raise_error;
531: end if;
532:
533: /* Commented as per December 2000 cpdf changes -- vravikan

Line 530: hr_utility.raise_error;

526: or
527: p_retain_step is null )
528: then
529: hr_utility.set_message(8301, 'GHR_37018_ALL_PROCEDURE_FAIL');
530: hr_utility.raise_error;
531: end if;
532:
533: /* Commented as per December 2000 cpdf changes -- vravikan
534: -- 620.10.1

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

535: if p_to_pay_plan = 'GS'
536: and
537: p_retain_pay_plan = 'GM'
538: then
539: hr_utility.set_message(8301, 'GHR_37019_ALL_PROCEDURE_FAIL');
540: hr_utility.raise_error;
541: end if;
542: */
543:

Line 540: hr_utility.raise_error;

536: and
537: p_retain_pay_plan = 'GM'
538: then
539: hr_utility.set_message(8301, 'GHR_37019_ALL_PROCEDURE_FAIL');
540: hr_utility.raise_error;
541: end if;
542: */
543:
544: /* Commented as per December 2000 cpdf changes -- vravikan

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

546: if p_to_pay_plan = 'GM'
547: and
548: p_retain_pay_plan = 'GS'
549: then
550: hr_utility.set_message(8301, 'GHR_37020_ALL_PROCEDURE_FAIL');
551: hr_utility.raise_error;
552: end if;
553:
554: */

Line 551: hr_utility.raise_error;

547: and
548: p_retain_pay_plan = 'GS'
549: then
550: hr_utility.set_message(8301, 'GHR_37020_ALL_PROCEDURE_FAIL');
551: hr_utility.raise_error;
552: end if;
553:
554: */
555: end chk_retain_pay_plan;

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

582: p_retain_grade between '01' and '15' and
583: p_retain_step not between '01' and '10' and
584: p_retain_step is not null
585: then
586: hr_utility.set_message(8301, 'GHR_37021_ALL_PROCEDURE_FAIL');
587: hr_utility.set_message_token('PRD_LIST','A, B, E, F, or M');
588: hr_utility.raise_error;
589: end if;
590: elsif p_effective_date >= to_date('2005/05/01','yyyy/mm/dd') then

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

583: p_retain_step not between '01' and '10' and
584: p_retain_step is not null
585: then
586: hr_utility.set_message(8301, 'GHR_37021_ALL_PROCEDURE_FAIL');
587: hr_utility.set_message_token('PRD_LIST','A, B, E, F, or M');
588: hr_utility.raise_error;
589: end if;
590: elsif p_effective_date >= to_date('2005/05/01','yyyy/mm/dd') then
591: if p_pay_rate_determinant_code in ('A','B','E','F') and

Line 588: hr_utility.raise_error;

584: p_retain_step is not null
585: then
586: hr_utility.set_message(8301, 'GHR_37021_ALL_PROCEDURE_FAIL');
587: hr_utility.set_message_token('PRD_LIST','A, B, E, F, or M');
588: hr_utility.raise_error;
589: end if;
590: elsif p_effective_date >= to_date('2005/05/01','yyyy/mm/dd') then
591: if p_pay_rate_determinant_code in ('A','B','E','F') and
592: p_Cur_Appt_Auth_1 <> 'UAM' and

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

596: p_retain_grade between '01' and '15' and
597: p_retain_step not between '01' and '10' and
598: p_retain_step is not null
599: then
600: hr_utility.set_message(8301, 'GHR_37021_ALL_PROCEDURE_FAIL');
601: hr_utility.set_message_token('PRD_LIST','A, B, E, or F');
602: hr_utility.raise_error;
603: end if;
604: end if;

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

597: p_retain_step not between '01' and '10' and
598: p_retain_step is not null
599: then
600: hr_utility.set_message(8301, 'GHR_37021_ALL_PROCEDURE_FAIL');
601: hr_utility.set_message_token('PRD_LIST','A, B, E, or F');
602: hr_utility.raise_error;
603: end if;
604: end if;
605:

Line 602: hr_utility.raise_error;

598: p_retain_step is not null
599: then
600: hr_utility.set_message(8301, 'GHR_37021_ALL_PROCEDURE_FAIL');
601: hr_utility.set_message_token('PRD_LIST','A, B, E, or F');
602: hr_utility.raise_error;
603: end if;
604: end if;
605:
606:

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

615: p_retain_step <> '00'
616: and
617: p_retain_step is not null
618: then
619: hr_utility.set_message(8301, 'GHR_37413_ALL_PROCEDURE_FAIL');
620: hr_utility.raise_error;
621: end if;
622: else
623: if p_pay_rate_determinant_code in ('A','B','E','F','M')

Line 620: hr_utility.raise_error;

616: and
617: p_retain_step is not null
618: then
619: hr_utility.set_message(8301, 'GHR_37413_ALL_PROCEDURE_FAIL');
620: hr_utility.raise_error;
621: end if;
622: else
623: if p_pay_rate_determinant_code in ('A','B','E','F','M')
624: and

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

629: p_retain_step <> '99'
630: and
631: p_retain_step is not null
632: then
633: hr_utility.set_message(8301, 'GHR_37022_ALL_PROCEDURE_FAIL');
634: hr_utility.raise_error;
635: end if;
636: end if;
637: */

Line 634: hr_utility.raise_error;

630: and
631: p_retain_step is not null
632: then
633: hr_utility.set_message(8301, 'GHR_37022_ALL_PROCEDURE_FAIL');
634: hr_utility.raise_error;
635: end if;
636: end if;
637: */
638:

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

646: p_retain_step <> '00'
647: and
648: p_retain_step is not null
649: then
650: hr_utility.set_message(8301, 'GHR_37023_ALL_PROCEDURE_FAIL');
651: hr_utility.raise_error;
652: end if;
653:
654: end chk_retain_step;

Line 651: hr_utility.raise_error;

647: and
648: p_retain_step is not null
649: then
650: hr_utility.set_message(8301, 'GHR_37023_ALL_PROCEDURE_FAIL');
651: hr_utility.raise_error;
652: end if;
653:
654: end chk_retain_step;
655:

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

672: p_fers_coverage <> 'E'
673: and
674: p_fers_coverage is not null
675: then
676: hr_utility.set_message(8301, 'GHR_37024_ALL_PROCEDURE_FAIL');
677: hr_utility.raise_error;
678: end if;
679:
680: -- 640.14.1

Line 677: hr_utility.raise_error;

673: and
674: p_fers_coverage is not null
675: then
676: hr_utility.set_message(8301, 'GHR_37024_ALL_PROCEDURE_FAIL');
677: hr_utility.raise_error;
678: end if;
679:
680: -- 640.14.1
681: if (p_fers_coverage = 'A'

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

685: p_retirement_plan_code not in ('K','L','M','N','P')
686: and
687: p_retirement_plan_code is not null
688: then
689: hr_utility.set_message(8301, 'GHR_37025_ALL_PROCEDURE_FAIL');
690: hr_utility.raise_error;
691: end if;
692: end chk_retirement_plan;
693:

Line 690: hr_utility.raise_error;

686: and
687: p_retirement_plan_code is not null
688: then
689: hr_utility.set_message(8301, 'GHR_37025_ALL_PROCEDURE_FAIL');
690: hr_utility.raise_error;
691: end if;
692: end chk_retirement_plan;
693:
694:

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

714: if p_pay_rate_determinant_code not in ('5','6','E','F','M')
715: and
716: p_special_pay_table_id is not null
717: then
718: hr_utility.set_message(8301, 'GHR_37026_ALL_PROCEDURE_FAIL');
719: hr_utility.raise_error;
720: end if;
721: */
722:

Line 719: hr_utility.raise_error;

715: and
716: p_special_pay_table_id is not null
717: then
718: hr_utility.set_message(8301, 'GHR_37026_ALL_PROCEDURE_FAIL');
719: hr_utility.raise_error;
720: end if;
721: */
722:
723: -- 695.10.1

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

733: p_pay_rate_determinant_code in ('5','6','E','F','M')
734: and
735: p_special_pay_table_id is null
736: then
737: hr_utility.set_message(8301, 'GHR_37027_ALL_PROCEDURE_FAIL');
738: hr_utility.set_message_token('PRD_LIST','5, 6, E, F, or M');
739: hr_utility.raise_error;
740: end if;
741: ELSIF p_effective_date >= to_date('2005/05/01','yyyy/mm/dd') THEN

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

734: and
735: p_special_pay_table_id is null
736: then
737: hr_utility.set_message(8301, 'GHR_37027_ALL_PROCEDURE_FAIL');
738: hr_utility.set_message_token('PRD_LIST','5, 6, E, F, or M');
739: hr_utility.raise_error;
740: end if;
741: ELSIF p_effective_date >= to_date('2005/05/01','yyyy/mm/dd') THEN
742: if p_to_pay_plan in ('GM','GS') and

Line 739: hr_utility.raise_error;

735: p_special_pay_table_id is null
736: then
737: hr_utility.set_message(8301, 'GHR_37027_ALL_PROCEDURE_FAIL');
738: hr_utility.set_message_token('PRD_LIST','5, 6, E, F, or M');
739: hr_utility.raise_error;
740: end if;
741: ELSIF p_effective_date >= to_date('2005/05/01','yyyy/mm/dd') THEN
742: if p_to_pay_plan in ('GM','GS') and
743: p_pay_rate_determinant_code in ('5','6','E','F') and

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

742: if p_to_pay_plan in ('GM','GS') and
743: p_pay_rate_determinant_code in ('5','6','E','F') and
744: p_special_pay_table_id is null
745: then
746: hr_utility.set_message(8301, 'GHR_37027_ALL_PROCEDURE_FAIL');
747: hr_utility.set_message_token('PRD_LIST','5, 6, E, or F');
748: hr_utility.raise_error;
749: end if;
750: END IF;

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

743: p_pay_rate_determinant_code in ('5','6','E','F') and
744: p_special_pay_table_id is null
745: then
746: hr_utility.set_message(8301, 'GHR_37027_ALL_PROCEDURE_FAIL');
747: hr_utility.set_message_token('PRD_LIST','5, 6, E, or F');
748: hr_utility.raise_error;
749: end if;
750: END IF;
751:

Line 748: hr_utility.raise_error;

744: p_special_pay_table_id is null
745: then
746: hr_utility.set_message(8301, 'GHR_37027_ALL_PROCEDURE_FAIL');
747: hr_utility.set_message_token('PRD_LIST','5, 6, E, or F');
748: hr_utility.raise_error;
749: end if;
750: END IF;
751:
752: -- FWFA Changes

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

779: substr(p_duty_station_lookup_code,2,1) not in ('1','2','3','4','5','6','7','8','9','0')
780: and
781: p_duty_station_lookup_code is not null
782: then
783: hr_utility.set_message(8301, 'GHR_37028_ALL_PROCEDURE_FAIL');
784: hr_utility.raise_error;
785: end if;*/
786:
787: end chk_us_citizenship;

Line 784: hr_utility.raise_error;

780: and
781: p_duty_station_lookup_code is not null
782: then
783: hr_utility.set_message(8301, 'GHR_37028_ALL_PROCEDURE_FAIL');
784: hr_utility.raise_error;
785: end if;*/
786:
787: end chk_us_citizenship;
788: --

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

800: -- Procedure added to check the century info.
801: --
802: -- 110.00.1
803: if to_number(to_char(p_date_of_birth, 'YYYY')) NOT BETWEEN 1900 and 2099 then
804: hr_utility.set_message(8301, 'GHR_37887_ALL_PROCEDURE_FAIL');
805: hr_utility.raise_error;
806: end if;
807:
808: -- 140.00.2

Line 805: hr_utility.raise_error;

801: --
802: -- 110.00.1
803: if to_number(to_char(p_date_of_birth, 'YYYY')) NOT BETWEEN 1900 and 2099 then
804: hr_utility.set_message(8301, 'GHR_37887_ALL_PROCEDURE_FAIL');
805: hr_utility.raise_error;
806: end if;
807:
808: -- 140.00.2
809: if to_number(to_char(p_effective_date, 'YYYY')) NOT BETWEEN 1900 and 2099 then

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

806: end if;
807:
808: -- 140.00.2
809: if to_number(to_char(p_effective_date, 'YYYY')) NOT BETWEEN 1900 and 2099 then
810: hr_utility.set_message(8301, 'GHR_37888_ALL_PROCEDURE_FAIL');
811: hr_utility.raise_error;
812: end if;
813:
814: -- 660.00.1

Line 811: hr_utility.raise_error;

807:
808: -- 140.00.2
809: if to_number(to_char(p_effective_date, 'YYYY')) NOT BETWEEN 1900 and 2099 then
810: hr_utility.set_message(8301, 'GHR_37888_ALL_PROCEDURE_FAIL');
811: hr_utility.raise_error;
812: end if;
813:
814: -- 660.00.1
815:

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

821: -- removed as both branchings refer to
822: -- same message
823: if to_number(to_char(p_service_computation_date, 'YYYY'))
824: NOT BETWEEN 1900 and 2099 then
825: hr_utility.set_message(8301, 'GHR_37889_ALL_PROCEDURE_FAIL');
826: hr_utility.raise_error;
827: end if;
828:
829: -- 780.00.3

Line 826: hr_utility.raise_error;

822: -- same message
823: if to_number(to_char(p_service_computation_date, 'YYYY'))
824: NOT BETWEEN 1900 and 2099 then
825: hr_utility.set_message(8301, 'GHR_37889_ALL_PROCEDURE_FAIL');
826: hr_utility.raise_error;
827: end if;
828:
829: -- 780.00.3
830: if to_number(p_year_degree_attained) NOT BETWEEN 1900 and 2099 then

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

827: end if;
828:
829: -- 780.00.3
830: if to_number(p_year_degree_attained) NOT BETWEEN 1900 and 2099 then
831: hr_utility.set_message(8301, 'GHR_37890_ALL_PROCEDURE_FAIL');
832: hr_utility.raise_error;
833: end if;
834:
835: -- 472.00.3

Line 832: hr_utility.raise_error;

828:
829: -- 780.00.3
830: if to_number(p_year_degree_attained) NOT BETWEEN 1900 and 2099 then
831: hr_utility.set_message(8301, 'GHR_37890_ALL_PROCEDURE_FAIL');
832: hr_utility.raise_error;
833: end if;
834:
835: -- 472.00.3
836: if to_number(to_char(fnd_date.canonical_to_date(p_rating_of_record_period), 'yyyy'))

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

834:
835: -- 472.00.3
836: if to_number(to_char(fnd_date.canonical_to_date(p_rating_of_record_period), 'yyyy'))
837: NOT BETWEEN 1900 and 2099 then
838: hr_utility.set_message(8301, 'GHR_37891_ALL_PROCEDURE_FAIL');
839: hr_utility.raise_error;
840: end if;
841: --Bug# 4753117 28-Feb-07 Veeramani adding edit for the Appraisal start date
842: if to_number(to_char(fnd_date.canonical_to_date(p_rating_of_record_per_starts), 'yyyy'))

Line 839: hr_utility.raise_error;

835: -- 472.00.3
836: if to_number(to_char(fnd_date.canonical_to_date(p_rating_of_record_period), 'yyyy'))
837: NOT BETWEEN 1900 and 2099 then
838: hr_utility.set_message(8301, 'GHR_37891_ALL_PROCEDURE_FAIL');
839: hr_utility.raise_error;
840: end if;
841: --Bug# 4753117 28-Feb-07 Veeramani adding edit for the Appraisal start date
842: if to_number(to_char(fnd_date.canonical_to_date(p_rating_of_record_per_starts), 'yyyy'))
843: NOT BETWEEN 1900 and 2099 then

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

840: end if;
841: --Bug# 4753117 28-Feb-07 Veeramani adding edit for the Appraisal start date
842: if to_number(to_char(fnd_date.canonical_to_date(p_rating_of_record_per_starts), 'yyyy'))
843: NOT BETWEEN 1900 and 2099 then
844: hr_utility.set_message(8301, 'GHR_37891_ALL_PROCEDURE_FAIL');
845: hr_utility.raise_error;
846: end if;
847:
848:

Line 845: hr_utility.raise_error;

841: --Bug# 4753117 28-Feb-07 Veeramani adding edit for the Appraisal start date
842: if to_number(to_char(fnd_date.canonical_to_date(p_rating_of_record_per_starts), 'yyyy'))
843: NOT BETWEEN 1900 and 2099 then
844: hr_utility.set_message(8301, 'GHR_37891_ALL_PROCEDURE_FAIL');
845: hr_utility.raise_error;
846: end if;
847:
848:
849: