21: if to_number(p_education_level) > 12
22: and
23: p_academic_discipline is null
24: then
25: hr_utility.set_message(8301, 'GHR_37101_ALL_PROCEDURE_FAIL');
26: hr_utility.raise_error;
27: end if;
28: ------
29:
22: and
23: p_academic_discipline is null
24: then
25: hr_utility.set_message(8301, 'GHR_37101_ALL_PROCEDURE_FAIL');
26: hr_utility.raise_error;
27: end if;
28: ------
29:
30: -- 780.04.3
36: p_year_degree_attained is null
37: and
38: to_number(p_education_level) not in (14,16,18,20,22)
39: then
40: hr_utility.set_message(8301, 'GHR_37102_ALL_PROCEDURE_FAIL');
41: hr_utility.raise_error;
42: end if;
43:
44: -- 005.07.1
37: and
38: to_number(p_education_level) not in (14,16,18,20,22)
39: then
40: hr_utility.set_message(8301, 'GHR_37102_ALL_PROCEDURE_FAIL');
41: hr_utility.raise_error;
42: end if;
43:
44: -- 005.07.1
45: -- 28-NOV-02 Madhuri End dated the edit with 31-July-2002
51: to_number(p_education_level) < 13
52: ) and
53: (p_academic_discipline is not null or p_year_degree_attained is not null )
54: then
55: hr_utility.set_message(8301, 'GHR_37103_ALL_PROCEDURE_FAIL');
56: hr_utility.raise_error;
57: end if;
58: end if;
59:
52: ) and
53: (p_academic_discipline is not null or p_year_degree_attained is not null )
54: then
55: hr_utility.set_message(8301, 'GHR_37103_ALL_PROCEDURE_FAIL');
56: hr_utility.raise_error;
57: end if;
58: end if;
59:
60: -- 780.05.1
67: to_number(p_year_degree_attained) <
68: (to_number(to_char(p_employee_date_of_birth,'YYYY'))+17)
69: )
70: then
71: hr_utility.set_message(8301, 'GHR_37104_ALL_PROCEDURE_FAIL');
72: hr_utility.raise_error;
73: end if;
74:
75: -- 005.13.2
68: (to_number(to_char(p_employee_date_of_birth,'YYYY'))+17)
69: )
70: then
71: hr_utility.set_message(8301, 'GHR_37104_ALL_PROCEDURE_FAIL');
72: hr_utility.raise_error;
73: end if;
74:
75: -- 005.13.2
76:
89: or
90: p_year_degree_attained is not null
91: )
92: then
93: hr_utility.set_message(8301, 'GHR_37105_ALL_PROCEDURE_FAIL');
94: hr_utility.raise_error;
95: end if;
96: end if;
97:
90: p_year_degree_attained is not null
91: )
92: then
93: hr_utility.set_message(8301, 'GHR_37105_ALL_PROCEDURE_FAIL');
94: hr_utility.raise_error;
95: end if;
96: end if;
97:
98: -- 005.13.3
112: or
113: p_year_degree_attained is not null
114: )
115: then
116: hr_utility.set_message(8301, 'GHR_37927_ALL_PROCEDURE_FAIL');
117: hr_utility.raise_error;
118: end if;
119: end if;
120:
113: p_year_degree_attained is not null
114: )
115: then
116: hr_utility.set_message(8301, 'GHR_37927_ALL_PROCEDURE_FAIL');
117: hr_utility.raise_error;
118: end if;
119: end if;
120:
121: -- 005.15.2
128: (p_education_level ='06' or p_education_level='10' )
129: and
130: (p_academic_discipline is null or p_year_degree_attained is null)
131: then
132: hr_utility.set_message(8301, 'GHR_37106_ALL_PROCEDURE_FAIL');
133: hr_utility.raise_error;
134: end if;
135:
136: -- 005.20.2
129: and
130: (p_academic_discipline is null or p_year_degree_attained is null)
131: then
132: hr_utility.set_message(8301, 'GHR_37106_ALL_PROCEDURE_FAIL');
133: hr_utility.raise_error;
134: end if;
135:
136: -- 005.20.2
137: if substr(p_first_noac_lookup_code,1,1)='1'
143: (p_education_level ='06' or p_education_level='10' )
144: and
145: (p_academic_discipline is null or p_year_degree_attained is null)
146: then
147: hr_utility.set_message(8301, 'GHR_37107_ALL_PROCEDURE_FAIL');
148: hr_utility.raise_error;
149: end if;
150:
151: end chk_instructional_pgm;
144: and
145: (p_academic_discipline is null or p_year_degree_attained is null)
146: then
147: hr_utility.set_message(8301, 'GHR_37107_ALL_PROCEDURE_FAIL');
148: hr_utility.raise_error;
149: end if;
150:
151: end chk_instructional_pgm;
152:
186: ) and
187: (p_One_Time_Payment_Amount <= 0 or
188: p_One_Time_Payment_Amount is null)
189: then
190: hr_utility.set_message(8301, 'GHR_37108_ALL_PROCEDURE_FAIL');
191: hr_utility.raise_error;
192: end if;
193: elsif p_effective_date < to_date('2006/10/01','yyyy/mm/dd') then
194:
187: (p_One_Time_Payment_Amount <= 0 or
188: p_One_Time_Payment_Amount is null)
189: then
190: hr_utility.set_message(8301, 'GHR_37108_ALL_PROCEDURE_FAIL');
191: hr_utility.raise_error;
192: end if;
193: elsif p_effective_date < to_date('2006/10/01','yyyy/mm/dd') then
194:
195: if (p_First_NOAC_Lookup_Code in ('817', '840','841','842','843',
199: ) and
200: (p_One_Time_Payment_Amount <= 0 or
201: p_One_Time_Payment_Amount is null)
202: then
203: hr_utility.set_message(8301, 'GHR_37414_ALL_PROCEDURE_FAIL');
204: hr_utility.set_message_token('NOA_CODE','815, 816, 817, 840 through 849, 878, or 879');
205: hr_utility.raise_error;
206: end if;
207: elsif p_effective_date < to_date('2007/01/01','yyyy/mm/dd') then
200: (p_One_Time_Payment_Amount <= 0 or
201: p_One_Time_Payment_Amount is null)
202: then
203: hr_utility.set_message(8301, 'GHR_37414_ALL_PROCEDURE_FAIL');
204: hr_utility.set_message_token('NOA_CODE','815, 816, 817, 840 through 849, 878, or 879');
205: hr_utility.raise_error;
206: end if;
207: elsif p_effective_date < to_date('2007/01/01','yyyy/mm/dd') then
208: if (p_First_NOAC_Lookup_Code in ('817', '840','841','842','843',
201: p_One_Time_Payment_Amount is null)
202: then
203: hr_utility.set_message(8301, 'GHR_37414_ALL_PROCEDURE_FAIL');
204: hr_utility.set_message_token('NOA_CODE','815, 816, 817, 840 through 849, 878, or 879');
205: hr_utility.raise_error;
206: end if;
207: elsif p_effective_date < to_date('2007/01/01','yyyy/mm/dd') then
208: if (p_First_NOAC_Lookup_Code in ('817', '840','841','842','843',
209: '844','845','846','847','848','878','879') OR
212: ) and
213: (p_One_Time_Payment_Amount <= 0 or
214: p_One_Time_Payment_Amount is null)
215: then
216: hr_utility.set_message(8301, 'GHR_37414_ALL_PROCEDURE_FAIL');
217: hr_utility.set_message_token('NOA_CODE','815, 816, 817, 840 through 848, 878, or 879');
218: hr_utility.raise_error;
219: end if;
220: else
213: (p_One_Time_Payment_Amount <= 0 or
214: p_One_Time_Payment_Amount is null)
215: then
216: hr_utility.set_message(8301, 'GHR_37414_ALL_PROCEDURE_FAIL');
217: hr_utility.set_message_token('NOA_CODE','815, 816, 817, 840 through 848, 878, or 879');
218: hr_utility.raise_error;
219: end if;
220: else
221: if (p_First_NOAC_Lookup_Code in ('817', '826', '840','841','842','843',
214: p_One_Time_Payment_Amount is null)
215: then
216: hr_utility.set_message(8301, 'GHR_37414_ALL_PROCEDURE_FAIL');
217: hr_utility.set_message_token('NOA_CODE','815, 816, 817, 840 through 848, 878, or 879');
218: hr_utility.raise_error;
219: end if;
220: else
221: if (p_First_NOAC_Lookup_Code in ('817', '826', '840','841','842','843',
222: '844','845','846','847','849','848','878','879','885','886','887','889') OR
225: ) and
226: (p_One_Time_Payment_Amount <= 0 or
227: p_One_Time_Payment_Amount is null)
228: then
229: hr_utility.set_message(8301, 'GHR_37414_ALL_PROCEDURE_FAIL');
230: hr_utility.set_message_token('NOA_CODE','815, 816, 817, 826, 840 through 849, 878, 879, 885, 886, 887 or 889');
231: hr_utility.raise_error;
232: end if;
233: end if;
226: (p_One_Time_Payment_Amount <= 0 or
227: p_One_Time_Payment_Amount is null)
228: then
229: hr_utility.set_message(8301, 'GHR_37414_ALL_PROCEDURE_FAIL');
230: hr_utility.set_message_token('NOA_CODE','815, 816, 817, 826, 840 through 849, 878, 879, 885, 886, 887 or 889');
231: hr_utility.raise_error;
232: end if;
233: end if;
234:
227: p_One_Time_Payment_Amount is null)
228: then
229: hr_utility.set_message(8301, 'GHR_37414_ALL_PROCEDURE_FAIL');
230: hr_utility.set_message_token('NOA_CODE','815, 816, 817, 826, 840 through 849, 878, 879, 885, 886, 887 or 889');
231: hr_utility.raise_error;
232: end if;
233: end if;
234:
235: -- 050.04.2
253: p_First_NOAC_Lookup_Code not in ('815','816','817','825','826','849',
254: '872','873','874','875',
255: '876','877','878','879','885','889')
256: then
257: hr_utility.set_message(8301, 'GHR_37109_ALL_PROCEDURE_FAIL');
258: hr_utility.raise_error;
259: end if;
260: -----elsif p_effective_date < to_date('2006/10/01','yyyy/mm/dd') then
261: elsif p_effective_date < to_date('2004/01/01','yyyy/mm/dd') then
254: '872','873','874','875',
255: '876','877','878','879','885','889')
256: then
257: hr_utility.set_message(8301, 'GHR_37109_ALL_PROCEDURE_FAIL');
258: hr_utility.raise_error;
259: end if;
260: -----elsif p_effective_date < to_date('2006/10/01','yyyy/mm/dd') then
261: elsif p_effective_date < to_date('2004/01/01','yyyy/mm/dd') then
262: if p_One_Time_Payment_Amount is not null
265: '842','843','844','845','846',
266: '847','848','849','878','879',
267: '885','886','887','889') --bug 5482191
268: then
269: hr_utility.set_message(8301, 'GHR_37415_ALL_PROCEDURE_FAIL');
270: hr_utility.set_message_token('NOA_CODE','815, 816, 817, 825, 840 through 849, 878, or 879');
271: hr_utility.raise_error;
272: end if;
273: else
266: '847','848','849','878','879',
267: '885','886','887','889') --bug 5482191
268: then
269: hr_utility.set_message(8301, 'GHR_37415_ALL_PROCEDURE_FAIL');
270: hr_utility.set_message_token('NOA_CODE','815, 816, 817, 825, 840 through 849, 878, or 879');
271: hr_utility.raise_error;
272: end if;
273: else
274: null;
267: '885','886','887','889') --bug 5482191
268: then
269: hr_utility.set_message(8301, 'GHR_37415_ALL_PROCEDURE_FAIL');
270: hr_utility.set_message_token('NOA_CODE','815, 816, 817, 825, 840 through 849, 878, or 879');
271: hr_utility.raise_error;
272: end if;
273: else
274: null;
275: /***** Commented by AVR for Bug 5911585
278: '842','843','844','845','846',
279: '847','848','878','879',
280: '885','886','887','889')
281: then
282: hr_utility.set_message(8301, 'GHR_37415_ALL_PROCEDURE_FAIL');
283: hr_utility.set_message_token('NOA_CODE','815, 816, 817, 825, 840 through 848, 878, or 879');
284: hr_utility.raise_error;
285: end if;
286: ************* AVR - Bug 5911585 end ******/
279: '847','848','878','879',
280: '885','886','887','889')
281: then
282: hr_utility.set_message(8301, 'GHR_37415_ALL_PROCEDURE_FAIL');
283: hr_utility.set_message_token('NOA_CODE','815, 816, 817, 825, 840 through 848, 878, or 879');
284: hr_utility.raise_error;
285: end if;
286: ************* AVR - Bug 5911585 end ******/
287: end if;
280: '885','886','887','889')
281: then
282: hr_utility.set_message(8301, 'GHR_37415_ALL_PROCEDURE_FAIL');
283: hr_utility.set_message_token('NOA_CODE','815, 816, 817, 825, 840 through 848, 878, or 879');
284: hr_utility.raise_error;
285: end if;
286: ************* AVR - Bug 5911585 end ******/
287: end if;
288: -------------------------------------------------------------------------
297: p_One_Time_Payment_Amount is not null
298: and
299: round(p_One_Time_Payment_Amount,0) > round(.25*(p_Adj_Base_Pay),0)
300: then
301: hr_utility.set_message(8301, 'GHR_37110_ALL_PROCEDURE_FAIL');
302: hr_utility.raise_error;
303: end if;
304:
305: --Commented as per EOY 2003 cpdf changes by Ashley
298: and
299: round(p_One_Time_Payment_Amount,0) > round(.25*(p_Adj_Base_Pay),0)
300: then
301: hr_utility.set_message(8301, 'GHR_37110_ALL_PROCEDURE_FAIL');
302: hr_utility.raise_error;
303: end if;
304:
305: --Commented as per EOY 2003 cpdf changes by Ashley
306: -- 050.07.2
311: p_To_Pay_Plan ='GM'
312: and
313: p_One_Time_Payment_Amount > (p_TO_Basic_Pay * .20)
314: then
315: hr_utility.set_message(8301, 'GHR_37111_ALL_PROCEDURE_FAIL');
316: hr_utility.raise_error;
317: end if;
318: end if;*/
319:
312: and
313: p_One_Time_Payment_Amount > (p_TO_Basic_Pay * .20)
314: then
315: hr_utility.set_message(8301, 'GHR_37111_ALL_PROCEDURE_FAIL');
316: hr_utility.raise_error;
317: end if;
318: end if;*/
319:
320: -- 050.10.2
326: p_One_Time_Payment_Amount between 10 and 25)
327: and
328: p_One_Time_Payment_Amount is not null
329: then
330: hr_utility.set_message(8301, 'GHR_37112_ALL_PROCEDURE_FAIL');
331: hr_utility.raise_error;
332: end if;
333:
334: -- 050.15.2
327: and
328: p_One_Time_Payment_Amount is not null
329: then
330: hr_utility.set_message(8301, 'GHR_37112_ALL_PROCEDURE_FAIL');
331: hr_utility.raise_error;
332: end if;
333:
334: -- 050.15.2
335: if p_First_NOAC_Lookup_Code ='818'
337: (substr(p_To_Pay_Plan,1,1) in ('B','W','X')
338: or
339: p_To_Pay_Plan ='ES')
340: then
341: hr_utility.set_message(8301, 'GHR_37113_ALL_PROCEDURE_FAIL');
342: hr_utility.raise_error;
343: end if;
344:
345: -- 050.20.2
338: or
339: p_To_Pay_Plan ='ES')
340: then
341: hr_utility.set_message(8301, 'GHR_37113_ALL_PROCEDURE_FAIL');
342: hr_utility.raise_error;
343: end if;
344:
345: -- 050.20.2
346: -- UPD 41(Bug 4567571) Raju 08-Nov-2005 Terminate from 01-May-2002
350: p_One_Time_Payment_Amount > .25 * p_TO_Basic_Pay
351: and
352: p_One_Time_Payment_Amount is not null
353: then
354: hr_utility.set_message(8301, 'GHR_37114_ALL_PROCEDURE_FAIL');
355: hr_utility.raise_error;
356: end if;
357: End if;
358:
351: and
352: p_One_Time_Payment_Amount is not null
353: then
354: hr_utility.set_message(8301, 'GHR_37114_ALL_PROCEDURE_FAIL');
355: hr_utility.raise_error;
356: end if;
357: End if;
358:
359:
364: if p_First_NOAC_Lookup_Code ='873'
365: and
366: p_One_Time_Payment_Amount > (.05* p_TO_Basic_Pay)
367: then
368: hr_utility.set_message(8301, 'GHR_37115_ALL_PROCEDURE_FAIL');
369: hr_utility.raise_error;
370: end if;
371: end if;*/
372:
365: and
366: p_One_Time_Payment_Amount > (.05* p_TO_Basic_Pay)
367: then
368: hr_utility.set_message(8301, 'GHR_37115_ALL_PROCEDURE_FAIL');
369: hr_utility.raise_error;
370: end if;
371: end if;*/
372:
373: -- 050.30.2
379: (p_First_Action_NOA_LA_Code1 <>'ZTY' or p_First_Action_NOA_LA_Code2 <> 'ZTY' )
380: and
381: p_One_Time_Payment_Amount > (.25* p_TO_Basic_Pay)
382: then
383: hr_utility.set_message(8301, 'GHR_37116_ALL_PROCEDURE_FAIL');
384: hr_utility.raise_error;
385: end if;
386: End if;
387:
380: and
381: p_One_Time_Payment_Amount > (.25* p_TO_Basic_Pay)
382: then
383: hr_utility.set_message(8301, 'GHR_37116_ALL_PROCEDURE_FAIL');
384: hr_utility.raise_error;
385: end if;
386: End if;
387:
388: -- 050.35.2
396: p_One_Time_Payment_Amount > (.25* p_TO_Basic_Pay)
397: and
398: p_One_Time_Payment_Amount > 15000
399: then
400: hr_utility.set_message(8301, 'GHR_37117_ALL_PROCEDURE_FAIL');
401: hr_utility.raise_error;
402: end if;
403: End if;
404: /*
397: and
398: p_One_Time_Payment_Amount > 15000
399: then
400: hr_utility.set_message(8301, 'GHR_37117_ALL_PROCEDURE_FAIL');
401: hr_utility.raise_error;
402: end if;
403: End if;
404: /*
405: -- 050.40.2
406: if p_First_NOAC_Lookup_Code ='825'
407: and
408: p_One_Time_Payment_Amount > 25000
409: then
410: hr_utility.set_message(8301, 'GHR_37118_ALL_PROCEDURE_FAIL');
411: hr_utility.raise_error;
412: end if;*/
413:
414: end chk_Award_Amount;
407: and
408: p_One_Time_Payment_Amount > 25000
409: then
410: hr_utility.set_message(8301, 'GHR_37118_ALL_PROCEDURE_FAIL');
411: hr_utility.raise_error;
412: end if;*/
413:
414: end chk_Award_Amount;
415:
431: if p_Benefit_Amount is not null
432: and
433: p_First_NOAC_Lookup_Code not in ('872','874','875','876','877')
434: then
435: hr_utility.set_message(8301, 'GHR_37165_ALL_PROCEDURE_FAIL');
436: hr_utility.raise_error;
437:
438: end if;
439: end if;*/
432: and
433: p_First_NOAC_Lookup_Code not in ('872','874','875','876','877')
434: then
435: hr_utility.set_message(8301, 'GHR_37165_ALL_PROCEDURE_FAIL');
436: hr_utility.raise_error;
437:
438: end if;
439: end if;*/
440: null;
475: )
476: and
477: p_Agency_Subelement <> 'TD03'
478: then
479: hr_utility.set_message(8301, 'GHR_37119_ALL_PROCEDURE_FAIL');
480: hr_utility.raise_error;
481: end if;
482:
483: /* Commented as per December 2000 cpdf changes -- vravikan
476: and
477: p_Agency_Subelement <> 'TD03'
478: then
479: hr_utility.set_message(8301, 'GHR_37119_ALL_PROCEDURE_FAIL');
480: hr_utility.raise_error;
481: end if;
482:
483: /* Commented as per December 2000 cpdf changes -- vravikan
484: --
488: if p_effective_date >= fnd_date.canonical_to_date('1998/09/01') then
489: if ( p_Cur_Appt_Auth_1= 'ZTA' or p_Cur_Appt_Auth_2='ZTA' ) and
490: p_Position_Occupied_Code = '1' and
491: p_Agency_Subelement <> 'DJ03' then
492: hr_utility.set_message(8301, 'GHR_37892_ALL_PROCEDURE_FAIL');
493: hr_utility.raise_error;
494: end if;
495: end if;
496:
489: if ( p_Cur_Appt_Auth_1= 'ZTA' or p_Cur_Appt_Auth_2='ZTA' ) and
490: p_Position_Occupied_Code = '1' and
491: p_Agency_Subelement <> 'DJ03' then
492: hr_utility.set_message(8301, 'GHR_37892_ALL_PROCEDURE_FAIL');
493: hr_utility.raise_error;
494: end if;
495: end if;
496:
497: */
508: substr(p_to_occ_code,3,2) <>'99'
509: and
510: p_to_occ_code is not null
511: then
512: hr_utility.set_message(8301, 'GHR_37120_ALL_PROCEDURE_FAIL');
513: hr_utility.raise_error;
514: end if;
515:
516: /* same as 100.04.1
509: and
510: p_to_occ_code is not null
511: then
512: hr_utility.set_message(8301, 'GHR_37120_ALL_PROCEDURE_FAIL');
513: hr_utility.raise_error;
514: end if;
515:
516: /* same as 100.04.1
517: -- 100.05.2
527: substr(p_To_OCC_Code,3,2) <> '99'
528: and
529: p_To_OCC_Code is not null
530: then
531: hr_utility.set_message(8301, 'GHR_37120_ALL_PROCEDURE_FAIL');
532: hr_utility.raise_error;
533: end if;
534: */
535: --100.06.3
528: and
529: p_To_OCC_Code is not null
530: then
531: hr_utility.set_message(8301, 'GHR_37120_ALL_PROCEDURE_FAIL');
532: hr_utility.raise_error;
533: end if;
534: */
535: --100.06.3
536: -- Updation Date Updated By Remarks
541: if p_effective_date >= fnd_date.canonical_to_date('20'||'00/10/01') then
542: if (p_Cur_Appt_Auth_1 = 'ZVC' OR p_Cur_Appt_Auth_2 = 'ZVC') AND
543: (p_agency_subelement NOT IN ('HSBC'))
544: then
545: hr_utility.set_message(8301, 'GHR_37925_ALL_PROCEDURE_FAIL');
546: hr_utility.raise_error;
547: end if;
548: end if;
549: -- 100.07.3
542: if (p_Cur_Appt_Auth_1 = 'ZVC' OR p_Cur_Appt_Auth_2 = 'ZVC') AND
543: (p_agency_subelement NOT IN ('HSBC'))
544: then
545: hr_utility.set_message(8301, 'GHR_37925_ALL_PROCEDURE_FAIL');
546: hr_utility.raise_error;
547: end if;
548: end if;
549: -- 100.07.3
550: if
558: p_Tenure_Goupe_Code <> '3'
559: and
560: p_Tenure_Goupe_Code is not null
561: then
562: hr_utility.set_message(8301, 'GHR_37121_ALL_PROCEDURE_FAIL');
563: hr_utility.raise_error;
564: end if;
565: -- Update Date By Effective Date Comment
566: -- 11 01/03/00 vravikan 11/01/99 Add Edit
559: and
560: p_Tenure_Goupe_Code is not null
561: then
562: hr_utility.set_message(8301, 'GHR_37121_ALL_PROCEDURE_FAIL');
563: hr_utility.raise_error;
564: end if;
565: -- Update Date By Effective Date Comment
566: -- 11 01/03/00 vravikan 11/01/99 Add Edit
567:
569: -- Then agency must be TR.
570: if p_effective_date >= fnd_date.canonical_to_date('19'||'99/11/01') then
571: if ( p_Cur_Appt_Auth_1= 'UDM' or p_Cur_Appt_Auth_2='UDM' ) and
572: substr(p_Agency_Subelement,1,2) <> 'TR' then
573: hr_utility.set_message(8301, 'GHR_37411_ALL_PROCEDURE_FAIL');
574: hr_utility.raise_error;
575: end if;
576: end if;
577:
570: if p_effective_date >= fnd_date.canonical_to_date('19'||'99/11/01') then
571: if ( p_Cur_Appt_Auth_1= 'UDM' or p_Cur_Appt_Auth_2='UDM' ) and
572: substr(p_Agency_Subelement,1,2) <> 'TR' then
573: hr_utility.set_message(8301, 'GHR_37411_ALL_PROCEDURE_FAIL');
574: hr_utility.raise_error;
575: end if;
576: end if;
577:
578:
594: p_position_occupied_code <>'2'
595: and
596: p_position_occupied_code is not null
597: then
598: hr_utility.set_message(8301, 'GHR_37122_ALL_PROCEDURE_FAIL');
599: hr_utility.set_message_token('APP_AUTH',
600: 'BPM, H2L, J8M, JYM, UFM, V8K, VEM, VPE, W--, X--, Y--, ZVB or ZVC');
601: hr_utility.raise_error;
602: end if;
595: and
596: p_position_occupied_code is not null
597: then
598: hr_utility.set_message(8301, 'GHR_37122_ALL_PROCEDURE_FAIL');
599: hr_utility.set_message_token('APP_AUTH',
600: 'BPM, H2L, J8M, JYM, UFM, V8K, VEM, VPE, W--, X--, Y--, ZVB or ZVC');
601: hr_utility.raise_error;
602: end if;
603: else
597: then
598: hr_utility.set_message(8301, 'GHR_37122_ALL_PROCEDURE_FAIL');
599: hr_utility.set_message_token('APP_AUTH',
600: 'BPM, H2L, J8M, JYM, UFM, V8K, VEM, VPE, W--, X--, Y--, ZVB or ZVC');
601: hr_utility.raise_error;
602: end if;
603: else
604: if (p_Cur_Appt_Auth_1 in ('BPM','H2L','J8M',
605: 'UFM','V8K','VEM','VPE','ZVB','ZVC') or
610: ) and
611: p_position_occupied_code <>'2' and
612: p_position_occupied_code is not null
613: then
614: hr_utility.set_message(8301, 'GHR_37122_ALL_PROCEDURE_FAIL');
615: hr_utility.set_message_token('APP_AUTH',
616: 'BPM, H2L, J8M, UFM, V8K, VEM, VPE, W--, X--, Y--, ZVB or ZVC');
617: hr_utility.raise_error;
618: end if;
611: p_position_occupied_code <>'2' and
612: p_position_occupied_code is not null
613: then
614: hr_utility.set_message(8301, 'GHR_37122_ALL_PROCEDURE_FAIL');
615: hr_utility.set_message_token('APP_AUTH',
616: 'BPM, H2L, J8M, UFM, V8K, VEM, VPE, W--, X--, Y--, ZVB or ZVC');
617: hr_utility.raise_error;
618: end if;
619: end if;
613: then
614: hr_utility.set_message(8301, 'GHR_37122_ALL_PROCEDURE_FAIL');
615: hr_utility.set_message_token('APP_AUTH',
616: 'BPM, H2L, J8M, UFM, V8K, VEM, VPE, W--, X--, Y--, ZVB or ZVC');
617: hr_utility.raise_error;
618: end if;
619: end if;
620:
621: -- 100.11.2
633: ) and
634: p_Position_Occupied_Code <> '2' and
635: p_Position_Occupied_Code is not null
636: then
637: hr_utility.set_message(8301, 'GHR_37123_ALL_PROCEDURE_FAIL');
638: hr_utility.raise_error;
639: end if;
640: end if;
641:
634: p_Position_Occupied_Code <> '2' and
635: p_Position_Occupied_Code is not null
636: then
637: hr_utility.set_message(8301, 'GHR_37123_ALL_PROCEDURE_FAIL');
638: hr_utility.raise_error;
639: end if;
640: end if;
641:
642: --100.12.1
654: and
655: p_agency_subelement is not null
656: then
657: if p_effective_date < fnd_date.canonical_to_date('2006/07/01') then
658: hr_utility.set_message(8301, 'GHR_37055_ALL_PROCEDURE_FAIL');
659: hr_utility.raise_error;
660: else
661: hr_utility.set_message(8301, 'GHR_37691_ALL_PROCEDURE_FAIL');
662: hr_utility.raise_error;
655: p_agency_subelement is not null
656: then
657: if p_effective_date < fnd_date.canonical_to_date('2006/07/01') then
658: hr_utility.set_message(8301, 'GHR_37055_ALL_PROCEDURE_FAIL');
659: hr_utility.raise_error;
660: else
661: hr_utility.set_message(8301, 'GHR_37691_ALL_PROCEDURE_FAIL');
662: hr_utility.raise_error;
663: end if;
657: if p_effective_date < fnd_date.canonical_to_date('2006/07/01') then
658: hr_utility.set_message(8301, 'GHR_37055_ALL_PROCEDURE_FAIL');
659: hr_utility.raise_error;
660: else
661: hr_utility.set_message(8301, 'GHR_37691_ALL_PROCEDURE_FAIL');
662: hr_utility.raise_error;
663: end if;
664: end if;
665: end if;
658: hr_utility.set_message(8301, 'GHR_37055_ALL_PROCEDURE_FAIL');
659: hr_utility.raise_error;
660: else
661: hr_utility.set_message(8301, 'GHR_37691_ALL_PROCEDURE_FAIL');
662: hr_utility.raise_error;
663: end if;
664: end if;
665: end if;
666:
677: if p_To_Pay_Plan = 'ES' and
678: p_Cur_Appt_Auth_1 not in ('NRM','NSM','NTM','NVM','NWM','NXM','P2M','P3M','P5M','P7M',
679: 'V2M','VAG','VBJ','VCJ','V4L','V4M','V6M','V4P') and
680: p_Cur_Appt_Auth_1 is not null then
681: hr_utility.set_message(8301, 'GHR_37124_ALL_PROCEDURE_FAIL');
682: hr_utility.raise_error;
683: end if;
684: end if;
685:
678: p_Cur_Appt_Auth_1 not in ('NRM','NSM','NTM','NVM','NWM','NXM','P2M','P3M','P5M','P7M',
679: 'V2M','VAG','VBJ','VCJ','V4L','V4M','V6M','V4P') and
680: p_Cur_Appt_Auth_1 is not null then
681: hr_utility.set_message(8301, 'GHR_37124_ALL_PROCEDURE_FAIL');
682: hr_utility.raise_error;
683: end if;
684: end if;
685:
686: -- 100.13.3 -- 100.13.1 renumbered as 100.13.3
694: if p_To_Pay_Plan = 'ES' and
695: p_Cur_Appt_Auth_1 not in ('NRM','NSM','NTM','NVM','NWM','NXM','P2M','P3M','P5M','P7M',
696: 'V2M','VAG','VBJ','VCJ','V4L','V4M','V6M','V4P') and
697: p_Cur_Appt_Auth_1 is not null then
698: hr_utility.set_message(8301, 'GHR_37875_ALL_PROCEDURE_FAIL');
699: hr_utility.raise_error;
700: end if;
701: end if;
702:
695: p_Cur_Appt_Auth_1 not in ('NRM','NSM','NTM','NVM','NWM','NXM','P2M','P3M','P5M','P7M',
696: 'V2M','VAG','VBJ','VCJ','V4L','V4M','V6M','V4P') and
697: p_Cur_Appt_Auth_1 is not null then
698: hr_utility.set_message(8301, 'GHR_37875_ALL_PROCEDURE_FAIL');
699: hr_utility.raise_error;
700: end if;
701: end if;
702:
703: -- 100.14.3
708: p_Cur_Appt_Auth_2 not in ('AUM','AWM','BWM','HAM','ZLM')
709: and
710: p_Cur_Appt_Auth_2 is not null
711: then
712: hr_utility.set_message(8301, 'GHR_37125_ALL_PROCEDURE_FAIL');
713: hr_utility.raise_error;
714: end if;
715: else
716: if p_To_Pay_Plan = 'ES'
709: and
710: p_Cur_Appt_Auth_2 is not null
711: then
712: hr_utility.set_message(8301, 'GHR_37125_ALL_PROCEDURE_FAIL');
713: hr_utility.raise_error;
714: end if;
715: else
716: if p_To_Pay_Plan = 'ES'
717: and
718: p_Cur_Appt_Auth_2 not in ('AUM','AWM','BWM','HAM','ZLM')
719: and
720: p_Cur_Appt_Auth_2 is not null
721: then
722: hr_utility.set_message(8301, 'GHR_37125_ALL_PROCEDURE_FAIL');
723: hr_utility.raise_error;
724: end if;
725: end if;
726: -- 100.16.3
719: and
720: p_Cur_Appt_Auth_2 is not null
721: then
722: hr_utility.set_message(8301, 'GHR_37125_ALL_PROCEDURE_FAIL');
723: hr_utility.raise_error;
724: end if;
725: end if;
726: -- 100.16.3
727: -- Dec 01 Patch vravikan Delete YKM
731: p_Cur_Appt_Auth_2 in ('WTM','WUM')) and
732: p_Handicap <>'04' and
733: to_number(p_Handicap) not between 6 and 94 and
734: p_Handicap is not null then
735: hr_utility.set_message(8301, 'GHR_37126_ALL_PROCEDURE_FAIL');
736: hr_utility.set_message_token('APP_AUTH','WTM, WUM');
737: hr_utility.raise_error;
738: end if;
739: ELSE
732: p_Handicap <>'04' and
733: to_number(p_Handicap) not between 6 and 94 and
734: p_Handicap is not null then
735: hr_utility.set_message(8301, 'GHR_37126_ALL_PROCEDURE_FAIL');
736: hr_utility.set_message_token('APP_AUTH','WTM, WUM');
737: hr_utility.raise_error;
738: end if;
739: ELSE
740: if (p_Cur_Appt_Auth_1 in ('WUM') or
733: to_number(p_Handicap) not between 6 and 94 and
734: p_Handicap is not null then
735: hr_utility.set_message(8301, 'GHR_37126_ALL_PROCEDURE_FAIL');
736: hr_utility.set_message_token('APP_AUTH','WTM, WUM');
737: hr_utility.raise_error;
738: end if;
739: ELSE
740: if (p_Cur_Appt_Auth_1 in ('WUM') or
741: p_Cur_Appt_Auth_2 in ('WUM')) and
741: p_Cur_Appt_Auth_2 in ('WUM')) and
742: p_Handicap <>'04' and
743: to_number(p_Handicap) not between 6 and 94 and
744: p_Handicap is not null then
745: hr_utility.set_message(8301, 'GHR_37126_ALL_PROCEDURE_FAIL');
746: hr_utility.set_message_token('APP_AUTH','WUM');
747: hr_utility.raise_error;
748: end if;
749: END IF;
742: p_Handicap <>'04' and
743: to_number(p_Handicap) not between 6 and 94 and
744: p_Handicap is not null then
745: hr_utility.set_message(8301, 'GHR_37126_ALL_PROCEDURE_FAIL');
746: hr_utility.set_message_token('APP_AUTH','WUM');
747: hr_utility.raise_error;
748: end if;
749: END IF;
750:
743: to_number(p_Handicap) not between 6 and 94 and
744: p_Handicap is not null then
745: hr_utility.set_message(8301, 'GHR_37126_ALL_PROCEDURE_FAIL');
746: hr_utility.set_message_token('APP_AUTH','WUM');
747: hr_utility.raise_error;
748: end if;
749: END IF;
750:
751: --
755: if p_effective_date >= fnd_date.canonical_to_date('1998/09/01') then
756: if ( p_Cur_Appt_Auth_1 = 'Z2W' or p_Cur_Appt_Auth_2 = 'Z2W') and
757: substr(p_Agency_Subelement,1,2) not in ('AF','AR','DD','NV')
758: then
759: hr_utility.set_message(8301, 'GHR_37893_ALL_PROCEDURE_FAIL');
760: hr_utility.raise_error;
761: end if;
762: end if;
763:
756: if ( p_Cur_Appt_Auth_1 = 'Z2W' or p_Cur_Appt_Auth_2 = 'Z2W') and
757: substr(p_Agency_Subelement,1,2) not in ('AF','AR','DD','NV')
758: then
759: hr_utility.set_message(8301, 'GHR_37893_ALL_PROCEDURE_FAIL');
760: hr_utility.raise_error;
761: end if;
762: end if;
763:
764: -- 100.19.1
803: AND
804: p_position_occupied_code is not null
805: then
806:
807: hr_utility.set_message(8301, 'GHR_37127_ALL_PROCEDURE_FAIL');
808: hr_utility.raise_error;
809:
810: end if;
811: else
804: p_position_occupied_code is not null
805: then
806:
807: hr_utility.set_message(8301, 'GHR_37127_ALL_PROCEDURE_FAIL');
808: hr_utility.raise_error;
809:
810: end if;
811: else
812: if (p_Cur_Appt_Auth_1 in
838: AND
839: p_position_occupied_code is not null
840: then
841:
842: hr_utility.set_message(8301, 'GHR_37692_ALL_PROCEDURE_FAIL');
843: hr_utility.raise_error;
844:
845: end if;
846: end if;
839: p_position_occupied_code is not null
840: then
841:
842: hr_utility.set_message(8301, 'GHR_37692_ALL_PROCEDURE_FAIL');
843: hr_utility.raise_error;
844:
845: end if;
846: end if;
847:
892: p_Position_Occupied_Code <> '1'
893: and
894: p_Position_Occupied_Code is not null
895: then
896: hr_utility.set_message(8301, 'GHR_37128_ALL_PROCEDURE_FAIL');
897: hr_utility.raise_error;
898: end if;
899: END IF;
900: --
893: and
894: p_Position_Occupied_Code is not null
895: then
896: hr_utility.set_message(8301, 'GHR_37128_ALL_PROCEDURE_FAIL');
897: hr_utility.raise_error;
898: end if;
899: END IF;
900: --
901:
925: p_Tenure_Goupe_Code <> '3'
926: and
927: p_Tenure_Goupe_Code is not null
928: then
929: hr_utility.set_message(8301, 'GHR_37129_ALL_PROCEDURE_FAIL');
930: hr_utility.raise_error;
931: end if;
932:
933: -- 100.25.3
926: and
927: p_Tenure_Goupe_Code is not null
928: then
929: hr_utility.set_message(8301, 'GHR_37129_ALL_PROCEDURE_FAIL');
930: hr_utility.raise_error;
931: end if;
932:
933: -- 100.25.3
934: if ((
946: p_Tenure_Goupe_Code <>'1'
947: and
948: p_Tenure_Goupe_Code is not null
949: then
950: hr_utility.set_message(8301, 'GHR_37130_ALL_PROCEDURE_FAIL');
951: hr_utility.raise_error;
952: end if;
953:
954: -- 100.28.3
947: and
948: p_Tenure_Goupe_Code is not null
949: then
950: hr_utility.set_message(8301, 'GHR_37130_ALL_PROCEDURE_FAIL');
951: hr_utility.raise_error;
952: end if;
953:
954: -- 100.28.3
955: -- Dec 01 Patch 12/10/01 vravikan Add YCM
963: p_Tenure_Goupe_Code <>'1' and
964: p_Tenure_Goupe_Code <>'2' and
965: p_Tenure_Goupe_Code is not null
966: then
967: hr_utility.set_message(8301, 'GHR_37131_ALL_PROCEDURE_FAIL');
968: hr_utility.set_message_token('APP_ATRTY','YBM, YCM, YGM, Y1M, Y2M, or Y3M');
969: hr_utility.raise_error;
970: end if;
971: ELSE
964: p_Tenure_Goupe_Code <>'2' and
965: p_Tenure_Goupe_Code is not null
966: then
967: hr_utility.set_message(8301, 'GHR_37131_ALL_PROCEDURE_FAIL');
968: hr_utility.set_message_token('APP_ATRTY','YBM, YCM, YGM, Y1M, Y2M, or Y3M');
969: hr_utility.raise_error;
970: end if;
971: ELSE
972: if ( p_Cur_Appt_Auth_1 in ('YBM','YCM','YGM','Y1M','Y2M','Y3M') or
965: p_Tenure_Goupe_Code is not null
966: then
967: hr_utility.set_message(8301, 'GHR_37131_ALL_PROCEDURE_FAIL');
968: hr_utility.set_message_token('APP_ATRTY','YBM, YCM, YGM, Y1M, Y2M, or Y3M');
969: hr_utility.raise_error;
970: end if;
971: ELSE
972: if ( p_Cur_Appt_Auth_1 in ('YBM','YCM','YGM','Y1M','Y2M','Y3M') or
973: p_Cur_Appt_Auth_2 in ('YBM','YCM','YGM','Y1M','Y2M','Y3M')) and
974: substr(p_To_Pay_Plan,1,1)<>'Y' and
975: p_Tenure_Goupe_Code <>'2' and
976: p_Tenure_Goupe_Code is not null
977: then
978: hr_utility.set_message(8301, 'GHR_37131_ALL_PROCEDURE_FAIL');
979: hr_utility.set_message_token('APP_ATRTY','YBM, YCM, YGM, Y1M, Y2M, or Y3M, And pay plan is other than Yx');
980: hr_utility.raise_error;
981: end if;
982: END IF;
975: p_Tenure_Goupe_Code <>'2' and
976: p_Tenure_Goupe_Code is not null
977: then
978: hr_utility.set_message(8301, 'GHR_37131_ALL_PROCEDURE_FAIL');
979: hr_utility.set_message_token('APP_ATRTY','YBM, YCM, YGM, Y1M, Y2M, or Y3M, And pay plan is other than Yx');
980: hr_utility.raise_error;
981: end if;
982: END IF;
983:
976: p_Tenure_Goupe_Code is not null
977: then
978: hr_utility.set_message(8301, 'GHR_37131_ALL_PROCEDURE_FAIL');
979: hr_utility.set_message_token('APP_ATRTY','YBM, YCM, YGM, Y1M, Y2M, or Y3M, And pay plan is other than Yx');
980: hr_utility.raise_error;
981: end if;
982: END IF;
983:
984: -- 100.31.3
992: p_Tenure_Goupe_Code <>'3'
993: and
994: p_Tenure_Goupe_Code is not null
995: then
996: hr_utility.set_message(8301, 'GHR_37132_ALL_PROCEDURE_FAIL');
997: hr_utility.raise_error;
998: end if;
999:
1000: -- 100.35.3
993: and
994: p_Tenure_Goupe_Code is not null
995: then
996: hr_utility.set_message(8301, 'GHR_37132_ALL_PROCEDURE_FAIL');
997: hr_utility.raise_error;
998: end if;
999:
1000: -- 100.35.3
1001: if (
1006: substr(p_Agency_Subelement,1,2) <>'VA'
1007: or p_Position_Occupied_Code <>'2'
1008: )
1009: then
1010: hr_utility.set_message(8301, 'GHR_37133_ALL_PROCEDURE_FAIL');
1011: hr_utility.raise_error;
1012: end if;
1013:
1014: -- 100.36.3
1007: or p_Position_Occupied_Code <>'2'
1008: )
1009: then
1010: hr_utility.set_message(8301, 'GHR_37133_ALL_PROCEDURE_FAIL');
1011: hr_utility.raise_error;
1012: end if;
1013:
1014: -- 100.36.3
1015: if p_To_Pay_Plan='GS'
1025: or
1026: p_Cur_Appt_Auth_2 = 'ZNM'
1027: )
1028: then
1029: hr_utility.set_message(8301, 'GHR_37134_ALL_PROCEDURE_FAIL');
1030: hr_utility.raise_error;
1031: end if;
1032:
1033: -- 100.37.3
1026: p_Cur_Appt_Auth_2 = 'ZNM'
1027: )
1028: then
1029: hr_utility.set_message(8301, 'GHR_37134_ALL_PROCEDURE_FAIL');
1030: hr_utility.raise_error;
1031: end if;
1032:
1033: -- 100.37.3
1034: if (
1040: p_Vet_Pref_Code = '1'
1041: or p_Vet_Pref_Code = '5'
1042: )
1043: then
1044: hr_utility.set_message(8301, 'GHR_37135_ALL_PROCEDURE_FAIL');
1045: hr_utility.raise_error;
1046: end if;
1047:
1048: -- 100.38.3
1041: or p_Vet_Pref_Code = '5'
1042: )
1043: then
1044: hr_utility.set_message(8301, 'GHR_37135_ALL_PROCEDURE_FAIL');
1045: hr_utility.raise_error;
1046: end if;
1047:
1048: -- 100.38.3
1049: --
1054: if p_effective_date >= fnd_date.canonical_to_date('1998/03/01') then
1055: if (p_Cur_Appt_Auth_1 in ( 'Z2U','UAM') or
1056: p_Cur_Appt_Auth_2 in ('Z2U','UAM') ) and
1057: substr(p_Agency_Subelement,1,2) not in ('AF','AR','DD','NV') then
1058: hr_utility.set_message(8301, 'GHR_37876_ALL_PROCEDURE_FAIL');
1059: hr_utility.raise_error;
1060: end if;
1061: end if;
1062:
1055: if (p_Cur_Appt_Auth_1 in ( 'Z2U','UAM') or
1056: p_Cur_Appt_Auth_2 in ('Z2U','UAM') ) and
1057: substr(p_Agency_Subelement,1,2) not in ('AF','AR','DD','NV') then
1058: hr_utility.set_message(8301, 'GHR_37876_ALL_PROCEDURE_FAIL');
1059: hr_utility.raise_error;
1060: end if;
1061: end if;
1062:
1063: /* Commented -- Dec 2001 Patch
1071: substr(p_Duty_Station_Lookup_Code,1,2) <> 'PM'
1072: and
1073: p_Duty_Station_Lookup_Code is not null
1074: then
1075: hr_utility.set_message(8301, 'GHR_37136_ALL_PROCEDURE_FAIL');
1076: hr_utility.raise_error;
1077: end if;
1078: */
1079:
1072: and
1073: p_Duty_Station_Lookup_Code is not null
1074: then
1075: hr_utility.set_message(8301, 'GHR_37136_ALL_PROCEDURE_FAIL');
1076: hr_utility.raise_error;
1077: end if;
1078: */
1079:
1080: -- 100.55.1
1088: p_to_pay_plan <> 'ES'
1089: and
1090: p_to_pay_plan is not null
1091: then
1092: hr_utility.set_message(8301, 'GHR_37137_ALL_PROCEDURE_FAIL');
1093: hr_utility.raise_error;
1094: end if;
1095:
1096: -- 100.56.2
1089: and
1090: p_to_pay_plan is not null
1091: then
1092: hr_utility.set_message(8301, 'GHR_37137_ALL_PROCEDURE_FAIL');
1093: hr_utility.raise_error;
1094: end if;
1095:
1096: -- 100.56.2
1097: if (
1105: p_To_Pay_Plan <>'ES'
1106: and
1107: p_To_Pay_Plan is not null
1108: then
1109: hr_utility.set_message(8301, 'GHR_37138_ALL_PROCEDURE_FAIL');
1110: hr_utility.raise_error;
1111: end if;
1112:
1113: -- 100.58.3
1106: and
1107: p_To_Pay_Plan is not null
1108: then
1109: hr_utility.set_message(8301, 'GHR_37138_ALL_PROCEDURE_FAIL');
1110: hr_utility.raise_error;
1111: end if;
1112:
1113: -- 100.58.3
1114: -- Raju 20-Apr-2007 UPD 53(Bug 5996938) Delete cur_appt_auth2 From Starting
1122: )or(p_Position_Occupied_Code <> '1' and
1123: p_Position_Occupied_Code is not null )
1124: )
1125: then
1126: hr_utility.set_message(8301, 'GHR_37139_ALL_PROCEDURE_FAIL');
1127: hr_utility.raise_error;
1128: end if;
1129:
1130: /*
1123: p_Position_Occupied_Code is not null )
1124: )
1125: then
1126: hr_utility.set_message(8301, 'GHR_37139_ALL_PROCEDURE_FAIL');
1127: hr_utility.raise_error;
1128: end if;
1129:
1130: /*
1131: -- 100.61.2
1142: or
1143: p_Cur_Appt_Auth_2 <>p_First_Action_NOA_LA_Code2
1144: )
1145: then
1146: hr_utility.set_message(8301, 'GHR_37140_ALL_PROCEDURE_FAIL');
1147: hr_utility.raise_error;
1148: end if;
1149: */
1150:
1143: p_Cur_Appt_Auth_2 <>p_First_Action_NOA_LA_Code2
1144: )
1145: then
1146: hr_utility.set_message(8301, 'GHR_37140_ALL_PROCEDURE_FAIL');
1147: hr_utility.raise_error;
1148: end if;
1149: */
1150:
1151: -- 100.64.3
1156: p_To_OCC_Code <> '0904'
1157: and
1158: p_To_OCC_Code is not null
1159: then
1160: hr_utility.set_message(8301, 'GHR_37141_ALL_PROCEDURE_FAIL');
1161: hr_utility.raise_error;
1162: end if;
1163:
1164: -- 100.70.3
1157: and
1158: p_To_OCC_Code is not null
1159: then
1160: hr_utility.set_message(8301, 'GHR_37141_ALL_PROCEDURE_FAIL');
1161: hr_utility.raise_error;
1162: end if;
1163:
1164: -- 100.70.3
1165: if (
1173: or
1174: p_To_OCC_Code is null
1175: )
1176: then
1177: hr_utility.set_message(8301, 'GHR_37142_ALL_PROCEDURE_FAIL');
1178: hr_utility.raise_error;
1179: end if;
1180:
1181: -- 100.73.3
1174: p_To_OCC_Code is null
1175: )
1176: then
1177: hr_utility.set_message(8301, 'GHR_37142_ALL_PROCEDURE_FAIL');
1178: hr_utility.raise_error;
1179: end if;
1180:
1181: -- 100.73.3
1182: if (
1189: and
1190: (p_To_OCC_Code = '0904' or p_To_OCC_Code = '0905')
1191:
1192: then
1193: hr_utility.set_message(8301, 'GHR_37143_ALL_PROCEDURE_FAIL');
1194: hr_utility.raise_error;
1195: end if;
1196:
1197: -- 100.76.3
1190: (p_To_OCC_Code = '0904' or p_To_OCC_Code = '0905')
1191:
1192: then
1193: hr_utility.set_message(8301, 'GHR_37143_ALL_PROCEDURE_FAIL');
1194: hr_utility.raise_error;
1195: end if;
1196:
1197: -- 100.76.3
1198: if (
1203: p_To_Pay_Plan not in ('ED','EF','EH')
1204: and
1205: p_To_Pay_Plan is not null
1206: then
1207: hr_utility.set_message(8301, 'GHR_37144_ALL_PROCEDURE_FAIL');
1208: hr_utility.raise_error;
1209: end if;
1210:
1211: -- 100.98.3
1204: and
1205: p_To_Pay_Plan is not null
1206: then
1207: hr_utility.set_message(8301, 'GHR_37144_ALL_PROCEDURE_FAIL');
1208: hr_utility.raise_error;
1209: end if;
1210:
1211: -- 100.98.3
1212: if p_Cur_Appt_Auth_1='ZZZ'
1214: p_Cur_Appt_Auth_2 <>'ZZZ'
1215: and
1216: p_Cur_Appt_Auth_2 is not null
1217: then
1218: hr_utility.set_message(8301, 'GHR_37145_ALL_PROCEDURE_FAIL');
1219: hr_utility.raise_error;
1220: end if;
1221:
1222: -- 100.99.3
1215: and
1216: p_Cur_Appt_Auth_2 is not null
1217: then
1218: hr_utility.set_message(8301, 'GHR_37145_ALL_PROCEDURE_FAIL');
1219: hr_utility.raise_error;
1220: end if;
1221:
1222: -- 100.99.3
1223: if p_Cur_Appt_Auth_2='ZZZ'
1225: p_Cur_Appt_Auth_1 <> 'ZZZ'
1226: and
1227: p_Cur_Appt_Auth_1 is not null
1228: then
1229: hr_utility.set_message(8301, 'GHR_37146_ALL_PROCEDURE_FAIL');
1230: hr_utility.raise_error;
1231: end if;
1232:
1233:
1226: and
1227: p_Cur_Appt_Auth_1 is not null
1228: then
1229: hr_utility.set_message(8301, 'GHR_37146_ALL_PROCEDURE_FAIL');
1230: hr_utility.raise_error;
1231: end if;
1232:
1233:
1234: end chk_Cur_Appt_Auth;
1251: and
1252: (to_number(substr(to_char(p_Effective_Date, 'MMDDYYYY'),5,4)) -
1253: to_number(substr(to_char(p_employee_date_of_birth, 'MMDDYYYY'),5,4)) ) < 50
1254: then
1255: hr_utility.set_message(8301, 'GHR_37147_ALL_PROCEDURE_FAIL');
1256: hr_utility.raise_error;
1257: end if;
1258:
1259: -- 110.05.2
1252: (to_number(substr(to_char(p_Effective_Date, 'MMDDYYYY'),5,4)) -
1253: to_number(substr(to_char(p_employee_date_of_birth, 'MMDDYYYY'),5,4)) ) < 50
1254: then
1255: hr_utility.set_message(8301, 'GHR_37147_ALL_PROCEDURE_FAIL');
1256: hr_utility.raise_error;
1257: end if;
1258:
1259: -- 110.05.2
1260: -- Date of birth must be at least 13 years less than the
1260: -- Date of birth must be at least 13 years less than the
1261: -- effective date of personnel action, or be asterisks.
1262:
1263: if (months_between(p_as_of_date, p_employee_date_of_birth) < 156 ) then
1264: hr_utility.set_message(8301, 'GHR_38412_ALL_PROCEDURE_FAIL');
1265: hr_utility.raise_error;
1266: end if;
1267:
1268: -- 110.07.2
1261: -- effective date of personnel action, or be asterisks.
1262:
1263: if (months_between(p_as_of_date, p_employee_date_of_birth) < 156 ) then
1264: hr_utility.set_message(8301, 'GHR_38412_ALL_PROCEDURE_FAIL');
1265: hr_utility.raise_error;
1266: end if;
1267:
1268: -- 110.07.2
1269: -- end dated this edit on 27-oct-98 for bug 745246
1280: and
1281: (to_number(substr(to_char(p_Effective_Date, 'MMDDYYYY'),5,4)) -
1282: to_number(substr(to_char(p_employee_date_of_birth, 'MMDDYYYY'),5,4)) ) < 15
1283: then
1284: hr_utility.set_message(8301, 'GHR_37149_ALL_PROCEDURE_FAIL');
1285: hr_utility.raise_error;
1286: end if;
1287: end if;
1288:
1281: (to_number(substr(to_char(p_Effective_Date, 'MMDDYYYY'),5,4)) -
1282: to_number(substr(to_char(p_employee_date_of_birth, 'MMDDYYYY'),5,4)) ) < 15
1283: then
1284: hr_utility.set_message(8301, 'GHR_37149_ALL_PROCEDURE_FAIL');
1285: hr_utility.raise_error;
1286: end if;
1287: end if;
1288:
1289: end chk_Date_of_Birth;
1308: and
1309: substr(p_duty_station_lookup,2,1) not in ('0','1','2','3','4','5','6','7','8','9')
1310: ) and
1311: substr(p_duty_station_lookup,-3,3) <> '000' then
1312: hr_utility.set_message(8301, 'GHR_37150_ALL_PROCEDURE_FAIL');
1313: hr_utility.raise_error;
1314: end if;
1315:
1316: /* Commented -- Dec 2001 Patch
1309: substr(p_duty_station_lookup,2,1) not in ('0','1','2','3','4','5','6','7','8','9')
1310: ) and
1311: substr(p_duty_station_lookup,-3,3) <> '000' then
1312: hr_utility.set_message(8301, 'GHR_37150_ALL_PROCEDURE_FAIL');
1313: hr_utility.raise_error;
1314: end if;
1315:
1316: /* Commented -- Dec 2001 Patch
1317: -- 120.02.3
1323: substr( p_duty_station_lookup,1,2) <> 'PM'
1324: and
1325: p_duty_station_lookup is not null
1326: then
1327: hr_utility.set_message(8301, 'GHR_37151_ALL_PROCEDURE_FAIL');
1328: hr_utility.raise_error;
1329: end if;
1330: */
1331:
1324: and
1325: p_duty_station_lookup is not null
1326: then
1327: hr_utility.set_message(8301, 'GHR_37151_ALL_PROCEDURE_FAIL');
1328: hr_utility.raise_error;
1329: end if;
1330: */
1331:
1332: -- 120.03.3
1339: substr( p_duty_station_lookup,1,2) not in ( '11','24','51' )
1340: and
1341: p_duty_station_lookup is not null
1342: then
1343: hr_utility.set_message(8301, 'GHR_37166_ALL_PROCEDURE_FAIL');
1344: hr_utility.raise_error;
1345: end if;
1346: end if; */
1347:
1340: and
1341: p_duty_station_lookup is not null
1342: then
1343: hr_utility.set_message(8301, 'GHR_37166_ALL_PROCEDURE_FAIL');
1344: hr_utility.raise_error;
1345: end if;
1346: end if; */
1347:
1348: -- 120.04.3
1359: substr(p_duty_station_lookup,1,2) <> 'RQ'
1360: and
1361: p_duty_station_lookup is not null
1362: then
1363: hr_utility.set_message(8301, 'GHR_37152_ALL_PROCEDURE_FAIL');
1364: hr_utility.raise_error;
1365: end if;
1366: else
1367: if substr(p_to_play_plan,1,2) in ('WQ','WR','WU')
1360: and
1361: p_duty_station_lookup is not null
1362: then
1363: hr_utility.set_message(8301, 'GHR_37152_ALL_PROCEDURE_FAIL');
1364: hr_utility.raise_error;
1365: end if;
1366: else
1367: if substr(p_to_play_plan,1,2) in ('WQ','WR','WU')
1368: and
1369: substr(p_duty_station_lookup,1,2) <> 'RQ'
1370: and
1371: p_duty_station_lookup is not null
1372: then
1373: hr_utility.set_message(8301, 'GHR_37600_ALL_PROCEDURE_FAIL');
1374: hr_utility.raise_error;
1375: end if;
1376: end if;
1377:
1370: and
1371: p_duty_station_lookup is not null
1372: then
1373: hr_utility.set_message(8301, 'GHR_37600_ALL_PROCEDURE_FAIL');
1374: hr_utility.raise_error;
1375: end if;
1376: end if;
1377:
1378:
1383: substr(p_First_Action_NOA_LA_Code2,1,1)='T') and
1384: substr(p_duty_station_lookup,1,2) <>'PM' and
1385: p_duty_station_lookup is not null
1386: then
1387: hr_utility.set_message(8301, 'GHR_37153_ALL_PROCEDURE_FAIL');
1388: hr_utility.raise_error;
1389: end if;
1390: end if;
1391:
1384: substr(p_duty_station_lookup,1,2) <>'PM' and
1385: p_duty_station_lookup is not null
1386: then
1387: hr_utility.set_message(8301, 'GHR_37153_ALL_PROCEDURE_FAIL');
1388: hr_utility.raise_error;
1389: end if;
1390: end if;
1391:
1392: /*
1395: if substr(p_duty_station_lookup,1,2) = 'US'
1396: and
1397: p_agency_sub_element <> 'DJ02'
1398: then
1399: hr_utility.set_message(8301, 'GHR_37154_ALL_PROCEDURE_FAIL');
1400: hr_utility.raise_error;
1401: end if;
1402: */
1403:
1396: and
1397: p_agency_sub_element <> 'DJ02'
1398: then
1399: hr_utility.set_message(8301, 'GHR_37154_ALL_PROCEDURE_FAIL');
1400: hr_utility.raise_error;
1401: end if;
1402: */
1403:
1404: end chk_duty_station;
1421: )
1422: and
1423: p_education_level is null
1424: then
1425: hr_utility.set_message(8301, 'GHR_37155_ALL_PROCEDURE_FAIL');
1426: hr_utility.raise_error;
1427: end if;
1428:
1429: -- 130.04.3
1422: and
1423: p_education_level is null
1424: then
1425: hr_utility.set_message(8301, 'GHR_37155_ALL_PROCEDURE_FAIL');
1426: hr_utility.raise_error;
1427: end if;
1428:
1429: -- 130.04.3
1430: if p_pay_plan = 'ES'
1430: if p_pay_plan = 'ES'
1431: and
1432: p_education_level is null
1433: then
1434: hr_utility.set_message(8301, 'GHR_37156_ALL_PROCEDURE_FAIL');
1435: hr_utility.raise_error;
1436: end if;
1437:
1438: end chk_Education_Level;
1431: and
1432: p_education_level is null
1433: then
1434: hr_utility.set_message(8301, 'GHR_37156_ALL_PROCEDURE_FAIL');
1435: hr_utility.raise_error;
1436: end if;
1437:
1438: end chk_Education_Level;
1439:
1461: and
1462: to_char(p_Effective_Date,'MMDD')<= '0930'
1463: )
1464: then
1465: hr_utility.set_message(8301, 'GHR_37157_ALL_PROCEDURE_FAIL');
1466: hr_utility.raise_error;
1467: end if;
1468: */
1469:
1462: to_char(p_Effective_Date,'MMDD')<= '0930'
1463: )
1464: then
1465: hr_utility.set_message(8301, 'GHR_37157_ALL_PROCEDURE_FAIL');
1466: hr_utility.raise_error;
1467: end if;
1468: */
1469:
1470:
1477:
1478: to_number(substr(to_char(p_Effective_Date, 'MMDDYYYY'),5,4)) -
1479: to_number(substr(to_char(p_Production_Date, 'MMDDYYYY'),5,4)) ) < -2
1480: then
1481: hr_utility.set_message(8301, 'GHR_37158_ALL_PROCEDURE_FAIL');
1482: hr_utility.raise_error;
1483: end if;
1484: */
1485:
1478: to_number(substr(to_char(p_Effective_Date, 'MMDDYYYY'),5,4)) -
1479: to_number(substr(to_char(p_Production_Date, 'MMDDYYYY'),5,4)) ) < -2
1480: then
1481: hr_utility.set_message(8301, 'GHR_37158_ALL_PROCEDURE_FAIL');
1482: hr_utility.raise_error;
1483: end if;
1484: */
1485:
1486: end chk_effective_date;
1506: p_First_Action_NOA_Code2 in ('WTM','WUM')) and
1507: to_number(p_Handicap) not between 6 and 94 and
1508: p_Handicap <>'04' and
1509: p_Handicap is not null then
1510: hr_utility.set_message(8301, 'GHR_37159_ALL_PROCEDURE_FAIL');
1511: hr_utility.set_message_token('APP_AUTH','WTM, WUM');
1512: hr_utility.raise_error;
1513: end if;
1514: else
1507: to_number(p_Handicap) not between 6 and 94 and
1508: p_Handicap <>'04' and
1509: p_Handicap is not null then
1510: hr_utility.set_message(8301, 'GHR_37159_ALL_PROCEDURE_FAIL');
1511: hr_utility.set_message_token('APP_AUTH','WTM, WUM');
1512: hr_utility.raise_error;
1513: end if;
1514: else
1515: if ( p_First_Action_NOA_Code1 in ('WUM') or
1508: p_Handicap <>'04' and
1509: p_Handicap is not null then
1510: hr_utility.set_message(8301, 'GHR_37159_ALL_PROCEDURE_FAIL');
1511: hr_utility.set_message_token('APP_AUTH','WTM, WUM');
1512: hr_utility.raise_error;
1513: end if;
1514: else
1515: if ( p_First_Action_NOA_Code1 in ('WUM') or
1516: p_First_Action_NOA_Code2 in ('WUM')) and
1516: p_First_Action_NOA_Code2 in ('WUM')) and
1517: to_number(p_Handicap) not between 6 and 94 and
1518: p_Handicap <>'04' and
1519: p_Handicap is not null then
1520: hr_utility.set_message(8301, 'GHR_37159_ALL_PROCEDURE_FAIL');
1521: hr_utility.set_message_token('APP_AUTH','WUM');
1522: hr_utility.raise_error;
1523: end if;
1524: end if;
1517: to_number(p_Handicap) not between 6 and 94 and
1518: p_Handicap <>'04' and
1519: p_Handicap is not null then
1520: hr_utility.set_message(8301, 'GHR_37159_ALL_PROCEDURE_FAIL');
1521: hr_utility.set_message_token('APP_AUTH','WUM');
1522: hr_utility.raise_error;
1523: end if;
1524: end if;
1525:
1518: p_Handicap <>'04' and
1519: p_Handicap is not null then
1520: hr_utility.set_message(8301, 'GHR_37159_ALL_PROCEDURE_FAIL');
1521: hr_utility.set_message_token('APP_AUTH','WUM');
1522: hr_utility.raise_error;
1523: end if;
1524: end if;
1525:
1526:
1528: if substr(p_First_NOAC_Lookup_Code,1,1)='1'
1529: and
1530: p_Handicap='04'
1531: then
1532: hr_utility.set_message(8301, 'GHR_37160_ALL_PROCEDURE_FAIL');
1533: hr_utility.raise_error;
1534: end if;
1535:
1536: end chk_Handicap;
1529: and
1530: p_Handicap='04'
1531: then
1532: hr_utility.set_message(8301, 'GHR_37160_ALL_PROCEDURE_FAIL');
1533: hr_utility.raise_error;
1534: end if;
1535:
1536: end chk_Handicap;
1537:
1553: if p_First_NOAC_Lookup_Code in ('874','875','876','877')
1554: and
1555: p_Indiv_Award is null
1556: then
1557: hr_utility.set_message(8301, 'GHR_37161_ALL_PROCEDURE_FAIL');
1558: hr_utility.raise_error;
1559: end if;
1560: end if;*/
1561: null;
1554: and
1555: p_Indiv_Award is null
1556: then
1557: hr_utility.set_message(8301, 'GHR_37161_ALL_PROCEDURE_FAIL');
1558: hr_utility.raise_error;
1559: end if;
1560: end if;*/
1561: null;
1562: end chk_indiv_Award;