[Home] [Help]
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
125: p_effective_date > TO_DATE('1993/09/30', 'YYYY/MM/DD') and
126: (p_tenure_group_code ='1' or p_tenure_group_code= '2' ) and
127: (p_education_level ='06' or p_education_level='10' ) and
128: (p_academic_discipline is null or p_year_degree_attained is null) then
129: hr_utility.set_message(8301, 'GHR_37106_ALL_PROCEDURE_FAIL');
130: hr_utility.set_message_token('EFF_DATE','and Effective Date is after 30-SEP-1993,');
131: hr_utility.raise_error;
132: end if;
133: ELSE
126: (p_tenure_group_code ='1' or p_tenure_group_code= '2' ) and
127: (p_education_level ='06' or p_education_level='10' ) and
128: (p_academic_discipline is null or p_year_degree_attained is null) then
129: hr_utility.set_message(8301, 'GHR_37106_ALL_PROCEDURE_FAIL');
130: hr_utility.set_message_token('EFF_DATE','and Effective Date is after 30-SEP-1993,');
131: hr_utility.raise_error;
132: end if;
133: ELSE
134: if substr(p_first_noac_lookup_code,1,1)='1' and
127: (p_education_level ='06' or p_education_level='10' ) and
128: (p_academic_discipline is null or p_year_degree_attained is null) then
129: hr_utility.set_message(8301, 'GHR_37106_ALL_PROCEDURE_FAIL');
130: hr_utility.set_message_token('EFF_DATE','and Effective Date is after 30-SEP-1993,');
131: hr_utility.raise_error;
132: end if;
133: ELSE
134: if substr(p_first_noac_lookup_code,1,1)='1' and
135: (p_tenure_group_code ='1' or p_tenure_group_code= '2' ) and
134: if substr(p_first_noac_lookup_code,1,1)='1' and
135: (p_tenure_group_code ='1' or p_tenure_group_code= '2' ) and
136: (p_education_level ='06' or p_education_level='10' ) and
137: (p_academic_discipline is null or p_year_degree_attained is null) then
138: hr_utility.set_message(8301, 'GHR_37106_ALL_PROCEDURE_FAIL');
139: hr_utility.set_message_token('EFF_DATE','');
140: hr_utility.raise_error;
141: end if;
142: END IF;
135: (p_tenure_group_code ='1' or p_tenure_group_code= '2' ) and
136: (p_education_level ='06' or p_education_level='10' ) and
137: (p_academic_discipline is null or p_year_degree_attained is null) then
138: hr_utility.set_message(8301, 'GHR_37106_ALL_PROCEDURE_FAIL');
139: hr_utility.set_message_token('EFF_DATE','');
140: hr_utility.raise_error;
141: end if;
142: END IF;
143:
136: (p_education_level ='06' or p_education_level='10' ) and
137: (p_academic_discipline is null or p_year_degree_attained is null) then
138: hr_utility.set_message(8301, 'GHR_37106_ALL_PROCEDURE_FAIL');
139: hr_utility.set_message_token('EFF_DATE','');
140: hr_utility.raise_error;
141: end if;
142: END IF;
143:
144: -- 005.20.2
148: p_effective_date > TO_DATE('1993/09/30', 'YYYY/MM/DD') and
149: p_to_pay_plan ='ES' and
150: (p_education_level ='06' or p_education_level='10' ) and
151: (p_academic_discipline is null or p_year_degree_attained is null) then
152: hr_utility.set_message(8301, 'GHR_37107_ALL_PROCEDURE_FAIL');
153: hr_utility.set_message_token('EFF_DATE','and Effective Date is after 30-SEP-1993,');
154: hr_utility.raise_error;
155: end if;
156: ELSE
149: p_to_pay_plan ='ES' and
150: (p_education_level ='06' or p_education_level='10' ) and
151: (p_academic_discipline is null or p_year_degree_attained is null) then
152: hr_utility.set_message(8301, 'GHR_37107_ALL_PROCEDURE_FAIL');
153: hr_utility.set_message_token('EFF_DATE','and Effective Date is after 30-SEP-1993,');
154: hr_utility.raise_error;
155: end if;
156: ELSE
157: if substr(p_first_noac_lookup_code,1,1)='1' and
150: (p_education_level ='06' or p_education_level='10' ) and
151: (p_academic_discipline is null or p_year_degree_attained is null) then
152: hr_utility.set_message(8301, 'GHR_37107_ALL_PROCEDURE_FAIL');
153: hr_utility.set_message_token('EFF_DATE','and Effective Date is after 30-SEP-1993,');
154: hr_utility.raise_error;
155: end if;
156: ELSE
157: if substr(p_first_noac_lookup_code,1,1)='1' and
158: p_to_pay_plan ='ES' and
157: if substr(p_first_noac_lookup_code,1,1)='1' and
158: p_to_pay_plan ='ES' and
159: (p_education_level ='06' or p_education_level='10' ) and
160: (p_academic_discipline is null or p_year_degree_attained is null) then
161: hr_utility.set_message(8301, 'GHR_37107_ALL_PROCEDURE_FAIL');
162: hr_utility.set_message_token('EFF_DATE','');
163: hr_utility.raise_error;
164: end if;
165: END IF;
158: p_to_pay_plan ='ES' and
159: (p_education_level ='06' or p_education_level='10' ) and
160: (p_academic_discipline is null or p_year_degree_attained is null) then
161: hr_utility.set_message(8301, 'GHR_37107_ALL_PROCEDURE_FAIL');
162: hr_utility.set_message_token('EFF_DATE','');
163: hr_utility.raise_error;
164: end if;
165: END IF;
166:
159: (p_education_level ='06' or p_education_level='10' ) and
160: (p_academic_discipline is null or p_year_degree_attained is null) then
161: hr_utility.set_message(8301, 'GHR_37107_ALL_PROCEDURE_FAIL');
162: hr_utility.set_message_token('EFF_DATE','');
163: hr_utility.raise_error;
164: end if;
165: END IF;
166:
167: end chk_instructional_pgm;
202: ) and
203: (p_One_Time_Payment_Amount <= 0 or
204: p_One_Time_Payment_Amount is null)
205: then
206: hr_utility.set_message(8301, 'GHR_37108_ALL_PROCEDURE_FAIL');
207: hr_utility.raise_error;
208: end if;
209: elsif p_effective_date < to_date('2006/10/01','yyyy/mm/dd') then
210:
203: (p_One_Time_Payment_Amount <= 0 or
204: p_One_Time_Payment_Amount is null)
205: then
206: hr_utility.set_message(8301, 'GHR_37108_ALL_PROCEDURE_FAIL');
207: hr_utility.raise_error;
208: end if;
209: elsif p_effective_date < to_date('2006/10/01','yyyy/mm/dd') then
210:
211: if (p_First_NOAC_Lookup_Code in ('817', '840','841','842','843',
215: ) and
216: (p_One_Time_Payment_Amount <= 0 or
217: p_One_Time_Payment_Amount is null)
218: then
219: hr_utility.set_message(8301, 'GHR_37414_ALL_PROCEDURE_FAIL');
220: hr_utility.set_message_token('NOA_CODE','815, 816, 817, 840 through 849, 878, or 879');
221: hr_utility.raise_error;
222: end if;
223: elsif p_effective_date < to_date('2007/01/01','yyyy/mm/dd') then
216: (p_One_Time_Payment_Amount <= 0 or
217: p_One_Time_Payment_Amount is null)
218: then
219: hr_utility.set_message(8301, 'GHR_37414_ALL_PROCEDURE_FAIL');
220: hr_utility.set_message_token('NOA_CODE','815, 816, 817, 840 through 849, 878, or 879');
221: hr_utility.raise_error;
222: end if;
223: elsif p_effective_date < to_date('2007/01/01','yyyy/mm/dd') then
224: if (p_First_NOAC_Lookup_Code in ('817', '840','841','842','843',
217: p_One_Time_Payment_Amount is null)
218: then
219: hr_utility.set_message(8301, 'GHR_37414_ALL_PROCEDURE_FAIL');
220: hr_utility.set_message_token('NOA_CODE','815, 816, 817, 840 through 849, 878, or 879');
221: hr_utility.raise_error;
222: end if;
223: elsif p_effective_date < to_date('2007/01/01','yyyy/mm/dd') then
224: if (p_First_NOAC_Lookup_Code in ('817', '840','841','842','843',
225: '844','845','846','847','848','878','879') OR
228: ) and
229: (p_One_Time_Payment_Amount <= 0 or
230: p_One_Time_Payment_Amount is null)
231: then
232: hr_utility.set_message(8301, 'GHR_37414_ALL_PROCEDURE_FAIL');
233: hr_utility.set_message_token('NOA_CODE','815, 816, 817, 840 through 848, 878, or 879');
234: hr_utility.raise_error;
235: end if;
236: else
229: (p_One_Time_Payment_Amount <= 0 or
230: p_One_Time_Payment_Amount is null)
231: then
232: hr_utility.set_message(8301, 'GHR_37414_ALL_PROCEDURE_FAIL');
233: hr_utility.set_message_token('NOA_CODE','815, 816, 817, 840 through 848, 878, or 879');
234: hr_utility.raise_error;
235: end if;
236: else
237: if (p_First_NOAC_Lookup_Code in ('817', '826', '840','841','842','843',
230: p_One_Time_Payment_Amount is null)
231: then
232: hr_utility.set_message(8301, 'GHR_37414_ALL_PROCEDURE_FAIL');
233: hr_utility.set_message_token('NOA_CODE','815, 816, 817, 840 through 848, 878, or 879');
234: hr_utility.raise_error;
235: end if;
236: else
237: if (p_First_NOAC_Lookup_Code in ('817', '826', '840','841','842','843',
238: '844','845','846','847','849','848','878','879','885','886','887','889') OR
241: ) and
242: (p_One_Time_Payment_Amount <= 0 or
243: p_One_Time_Payment_Amount is null)
244: then
245: hr_utility.set_message(8301, 'GHR_37414_ALL_PROCEDURE_FAIL');
246: hr_utility.set_message_token('NOA_CODE','815, 816, 817, 826, 840 through 849, 878, 879, 885, 886, 887 or 889');
247: hr_utility.raise_error;
248: end if;
249: end if;
242: (p_One_Time_Payment_Amount <= 0 or
243: p_One_Time_Payment_Amount is null)
244: then
245: hr_utility.set_message(8301, 'GHR_37414_ALL_PROCEDURE_FAIL');
246: hr_utility.set_message_token('NOA_CODE','815, 816, 817, 826, 840 through 849, 878, 879, 885, 886, 887 or 889');
247: hr_utility.raise_error;
248: end if;
249: end if;
250:
243: p_One_Time_Payment_Amount is null)
244: then
245: hr_utility.set_message(8301, 'GHR_37414_ALL_PROCEDURE_FAIL');
246: hr_utility.set_message_token('NOA_CODE','815, 816, 817, 826, 840 through 849, 878, 879, 885, 886, 887 or 889');
247: hr_utility.raise_error;
248: end if;
249: end if;
250:
251: -- 050.04.2
269: p_First_NOAC_Lookup_Code not in ('815','816','817','825','826','849',
270: '872','873','874','875',
271: '876','877','878','879','885','889')
272: then
273: hr_utility.set_message(8301, 'GHR_37109_ALL_PROCEDURE_FAIL');
274: hr_utility.raise_error;
275: end if;
276: -----elsif p_effective_date < to_date('2006/10/01','yyyy/mm/dd') then
277: elsif p_effective_date < to_date('2004/01/01','yyyy/mm/dd') then
270: '872','873','874','875',
271: '876','877','878','879','885','889')
272: then
273: hr_utility.set_message(8301, 'GHR_37109_ALL_PROCEDURE_FAIL');
274: hr_utility.raise_error;
275: end if;
276: -----elsif p_effective_date < to_date('2006/10/01','yyyy/mm/dd') then
277: elsif p_effective_date < to_date('2004/01/01','yyyy/mm/dd') then
278: if p_One_Time_Payment_Amount is not null
281: '842','843','844','845','846',
282: '847','848','849','878','879',
283: '885','886','887','889') --bug 5482191
284: then
285: hr_utility.set_message(8301, 'GHR_37415_ALL_PROCEDURE_FAIL');
286: hr_utility.set_message_token('NOA_CODE','815, 816, 817, 825, 840 through 849, 878, or 879');
287: hr_utility.raise_error;
288: end if;
289: else
282: '847','848','849','878','879',
283: '885','886','887','889') --bug 5482191
284: then
285: hr_utility.set_message(8301, 'GHR_37415_ALL_PROCEDURE_FAIL');
286: hr_utility.set_message_token('NOA_CODE','815, 816, 817, 825, 840 through 849, 878, or 879');
287: hr_utility.raise_error;
288: end if;
289: else
290: null;
283: '885','886','887','889') --bug 5482191
284: then
285: hr_utility.set_message(8301, 'GHR_37415_ALL_PROCEDURE_FAIL');
286: hr_utility.set_message_token('NOA_CODE','815, 816, 817, 825, 840 through 849, 878, or 879');
287: hr_utility.raise_error;
288: end if;
289: else
290: null;
291: /***** Commented by AVR for Bug 5911585
294: '842','843','844','845','846',
295: '847','848','878','879',
296: '885','886','887','889')
297: then
298: hr_utility.set_message(8301, 'GHR_37415_ALL_PROCEDURE_FAIL');
299: hr_utility.set_message_token('NOA_CODE','815, 816, 817, 825, 840 through 848, 878, or 879');
300: hr_utility.raise_error;
301: end if;
302: ************* AVR - Bug 5911585 end ******/
295: '847','848','878','879',
296: '885','886','887','889')
297: then
298: hr_utility.set_message(8301, 'GHR_37415_ALL_PROCEDURE_FAIL');
299: hr_utility.set_message_token('NOA_CODE','815, 816, 817, 825, 840 through 848, 878, or 879');
300: hr_utility.raise_error;
301: end if;
302: ************* AVR - Bug 5911585 end ******/
303: end if;
296: '885','886','887','889')
297: then
298: hr_utility.set_message(8301, 'GHR_37415_ALL_PROCEDURE_FAIL');
299: hr_utility.set_message_token('NOA_CODE','815, 816, 817, 825, 840 through 848, 878, or 879');
300: hr_utility.raise_error;
301: end if;
302: ************* AVR - Bug 5911585 end ******/
303: end if;
304: -------------------------------------------------------------------------
313: p_One_Time_Payment_Amount is not null
314: and
315: round(p_One_Time_Payment_Amount,0) > round(.25*(p_Adj_Base_Pay),0)
316: then
317: hr_utility.set_message(8301, 'GHR_37110_ALL_PROCEDURE_FAIL');
318: hr_utility.raise_error;
319: end if;
320:
321: --Commented as per EOY 2003 cpdf changes by Ashley
314: and
315: round(p_One_Time_Payment_Amount,0) > round(.25*(p_Adj_Base_Pay),0)
316: then
317: hr_utility.set_message(8301, 'GHR_37110_ALL_PROCEDURE_FAIL');
318: hr_utility.raise_error;
319: end if;
320:
321: --Commented as per EOY 2003 cpdf changes by Ashley
322: -- 050.07.2
327: p_To_Pay_Plan ='GM'
328: and
329: p_One_Time_Payment_Amount > (p_TO_Basic_Pay * .20)
330: then
331: hr_utility.set_message(8301, 'GHR_37111_ALL_PROCEDURE_FAIL');
332: hr_utility.raise_error;
333: end if;
334: end if;*/
335:
328: and
329: p_One_Time_Payment_Amount > (p_TO_Basic_Pay * .20)
330: then
331: hr_utility.set_message(8301, 'GHR_37111_ALL_PROCEDURE_FAIL');
332: hr_utility.raise_error;
333: end if;
334: end if;*/
335:
336: -- 050.10.2
342: p_One_Time_Payment_Amount between 10 and 25)
343: and
344: p_One_Time_Payment_Amount is not null
345: then
346: hr_utility.set_message(8301, 'GHR_37112_ALL_PROCEDURE_FAIL');
347: hr_utility.raise_error;
348: end if;
349:
350: -- 050.15.2
343: and
344: p_One_Time_Payment_Amount is not null
345: then
346: hr_utility.set_message(8301, 'GHR_37112_ALL_PROCEDURE_FAIL');
347: hr_utility.raise_error;
348: end if;
349:
350: -- 050.15.2
351: if p_First_NOAC_Lookup_Code ='818'
353: (substr(p_To_Pay_Plan,1,1) in ('B','W','X')
354: or
355: p_To_Pay_Plan ='ES')
356: then
357: hr_utility.set_message(8301, 'GHR_37113_ALL_PROCEDURE_FAIL');
358: hr_utility.raise_error;
359: end if;
360:
361: -- 050.20.2
354: or
355: p_To_Pay_Plan ='ES')
356: then
357: hr_utility.set_message(8301, 'GHR_37113_ALL_PROCEDURE_FAIL');
358: hr_utility.raise_error;
359: end if;
360:
361: -- 050.20.2
362: -- UPD 41(Bug 4567571) Raju 08-Nov-2005 Terminate from 01-May-2002
366: p_One_Time_Payment_Amount > .25 * p_TO_Basic_Pay
367: and
368: p_One_Time_Payment_Amount is not null
369: then
370: hr_utility.set_message(8301, 'GHR_37114_ALL_PROCEDURE_FAIL');
371: hr_utility.raise_error;
372: end if;
373: End if;
374:
367: and
368: p_One_Time_Payment_Amount is not null
369: then
370: hr_utility.set_message(8301, 'GHR_37114_ALL_PROCEDURE_FAIL');
371: hr_utility.raise_error;
372: end if;
373: End if;
374:
375:
380: if p_First_NOAC_Lookup_Code ='873'
381: and
382: p_One_Time_Payment_Amount > (.05* p_TO_Basic_Pay)
383: then
384: hr_utility.set_message(8301, 'GHR_37115_ALL_PROCEDURE_FAIL');
385: hr_utility.raise_error;
386: end if;
387: end if;*/
388:
381: and
382: p_One_Time_Payment_Amount > (.05* p_TO_Basic_Pay)
383: then
384: hr_utility.set_message(8301, 'GHR_37115_ALL_PROCEDURE_FAIL');
385: hr_utility.raise_error;
386: end if;
387: end if;*/
388:
389: -- 050.30.2
395: (p_First_Action_NOA_LA_Code1 <>'ZTY' or p_First_Action_NOA_LA_Code2 <> 'ZTY' )
396: and
397: p_One_Time_Payment_Amount > (.25* p_TO_Basic_Pay)
398: then
399: hr_utility.set_message(8301, 'GHR_37116_ALL_PROCEDURE_FAIL');
400: hr_utility.raise_error;
401: end if;
402: End if;
403:
396: and
397: p_One_Time_Payment_Amount > (.25* p_TO_Basic_Pay)
398: then
399: hr_utility.set_message(8301, 'GHR_37116_ALL_PROCEDURE_FAIL');
400: hr_utility.raise_error;
401: end if;
402: End if;
403:
404: -- 050.35.2
412: p_One_Time_Payment_Amount > (.25* p_TO_Basic_Pay)
413: and
414: p_One_Time_Payment_Amount > 15000
415: then
416: hr_utility.set_message(8301, 'GHR_37117_ALL_PROCEDURE_FAIL');
417: hr_utility.raise_error;
418: end if;
419: End if;
420: /*
413: and
414: p_One_Time_Payment_Amount > 15000
415: then
416: hr_utility.set_message(8301, 'GHR_37117_ALL_PROCEDURE_FAIL');
417: hr_utility.raise_error;
418: end if;
419: End if;
420: /*
421: -- 050.40.2
422: if p_First_NOAC_Lookup_Code ='825'
423: and
424: p_One_Time_Payment_Amount > 25000
425: then
426: hr_utility.set_message(8301, 'GHR_37118_ALL_PROCEDURE_FAIL');
427: hr_utility.raise_error;
428: end if;*/
429:
430: end chk_Award_Amount;
423: and
424: p_One_Time_Payment_Amount > 25000
425: then
426: hr_utility.set_message(8301, 'GHR_37118_ALL_PROCEDURE_FAIL');
427: hr_utility.raise_error;
428: end if;*/
429:
430: end chk_Award_Amount;
431:
447: if p_Benefit_Amount is not null
448: and
449: p_First_NOAC_Lookup_Code not in ('872','874','875','876','877')
450: then
451: hr_utility.set_message(8301, 'GHR_37165_ALL_PROCEDURE_FAIL');
452: hr_utility.raise_error;
453:
454: end if;
455: end if;*/
448: and
449: p_First_NOAC_Lookup_Code not in ('872','874','875','876','877')
450: then
451: hr_utility.set_message(8301, 'GHR_37165_ALL_PROCEDURE_FAIL');
452: hr_utility.raise_error;
453:
454: end if;
455: end if;*/
456: null;
491: )
492: and
493: p_Agency_Subelement <> 'TD03'
494: then
495: hr_utility.set_message(8301, 'GHR_37119_ALL_PROCEDURE_FAIL');
496: hr_utility.raise_error;
497: end if;
498:
499: /* Commented as per December 2000 cpdf changes -- vravikan
492: and
493: p_Agency_Subelement <> 'TD03'
494: then
495: hr_utility.set_message(8301, 'GHR_37119_ALL_PROCEDURE_FAIL');
496: hr_utility.raise_error;
497: end if;
498:
499: /* Commented as per December 2000 cpdf changes -- vravikan
500: --
504: if p_effective_date >= fnd_date.canonical_to_date('1998/09/01') then
505: if ( p_Cur_Appt_Auth_1= 'ZTA' or p_Cur_Appt_Auth_2='ZTA' ) and
506: p_Position_Occupied_Code = '1' and
507: p_Agency_Subelement <> 'DJ03' then
508: hr_utility.set_message(8301, 'GHR_37892_ALL_PROCEDURE_FAIL');
509: hr_utility.raise_error;
510: end if;
511: end if;
512:
505: if ( p_Cur_Appt_Auth_1= 'ZTA' or p_Cur_Appt_Auth_2='ZTA' ) and
506: p_Position_Occupied_Code = '1' and
507: p_Agency_Subelement <> 'DJ03' then
508: hr_utility.set_message(8301, 'GHR_37892_ALL_PROCEDURE_FAIL');
509: hr_utility.raise_error;
510: end if;
511: end if;
512:
513: */
524: substr(p_to_occ_code,3,2) <>'99'
525: and
526: p_to_occ_code is not null
527: then
528: hr_utility.set_message(8301, 'GHR_37120_ALL_PROCEDURE_FAIL');
529: hr_utility.raise_error;
530: end if;
531:
532: /* same as 100.04.1
525: and
526: p_to_occ_code is not null
527: then
528: hr_utility.set_message(8301, 'GHR_37120_ALL_PROCEDURE_FAIL');
529: hr_utility.raise_error;
530: end if;
531:
532: /* same as 100.04.1
533: -- 100.05.2
543: substr(p_To_OCC_Code,3,2) <> '99'
544: and
545: p_To_OCC_Code is not null
546: then
547: hr_utility.set_message(8301, 'GHR_37120_ALL_PROCEDURE_FAIL');
548: hr_utility.raise_error;
549: end if;
550: */
551: --100.06.3
544: and
545: p_To_OCC_Code is not null
546: then
547: hr_utility.set_message(8301, 'GHR_37120_ALL_PROCEDURE_FAIL');
548: hr_utility.raise_error;
549: end if;
550: */
551: --100.06.3
552: -- Updation Date Updated By Remarks
557: if p_effective_date >= fnd_date.canonical_to_date('20'||'00/10/01') then
558: if (p_Cur_Appt_Auth_1 = 'ZVC' OR p_Cur_Appt_Auth_2 = 'ZVC') AND
559: (p_agency_subelement NOT IN ('HSBC'))
560: then
561: hr_utility.set_message(8301, 'GHR_37925_ALL_PROCEDURE_FAIL');
562: hr_utility.raise_error;
563: end if;
564: end if;
565: -- 100.07.3
558: if (p_Cur_Appt_Auth_1 = 'ZVC' OR p_Cur_Appt_Auth_2 = 'ZVC') AND
559: (p_agency_subelement NOT IN ('HSBC'))
560: then
561: hr_utility.set_message(8301, 'GHR_37925_ALL_PROCEDURE_FAIL');
562: hr_utility.raise_error;
563: end if;
564: end if;
565: -- 100.07.3
566: if
574: p_Tenure_Goupe_Code <> '3'
575: and
576: p_Tenure_Goupe_Code is not null
577: then
578: hr_utility.set_message(8301, 'GHR_37121_ALL_PROCEDURE_FAIL');
579: hr_utility.raise_error;
580: end if;
581: -- Update Date By Effective Date Comment
582: -- 11 01/03/00 vravikan 11/01/99 Add Edit
575: and
576: p_Tenure_Goupe_Code is not null
577: then
578: hr_utility.set_message(8301, 'GHR_37121_ALL_PROCEDURE_FAIL');
579: hr_utility.raise_error;
580: end if;
581: -- Update Date By Effective Date Comment
582: -- 11 01/03/00 vravikan 11/01/99 Add Edit
583:
585: -- Then agency must be TR.
586: if p_effective_date >= fnd_date.canonical_to_date('19'||'99/11/01') then
587: if ( p_Cur_Appt_Auth_1= 'UDM' or p_Cur_Appt_Auth_2='UDM' ) and
588: substr(p_Agency_Subelement,1,2) <> 'TR' then
589: hr_utility.set_message(8301, 'GHR_37411_ALL_PROCEDURE_FAIL');
590: hr_utility.raise_error;
591: end if;
592: end if;
593:
586: if p_effective_date >= fnd_date.canonical_to_date('19'||'99/11/01') then
587: if ( p_Cur_Appt_Auth_1= 'UDM' or p_Cur_Appt_Auth_2='UDM' ) and
588: substr(p_Agency_Subelement,1,2) <> 'TR' then
589: hr_utility.set_message(8301, 'GHR_37411_ALL_PROCEDURE_FAIL');
590: hr_utility.raise_error;
591: end if;
592: end if;
593:
594:
610: p_position_occupied_code <>'2'
611: 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, JYM, UFM, V8K, VEM, VPE, W--, X--, Y--, ZVB or ZVC');
617: hr_utility.raise_error;
618: end if;
611: 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, JYM, UFM, V8K, VEM, VPE, W--, X--, Y--, ZVB or ZVC');
617: hr_utility.raise_error;
618: end if;
619: else
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, JYM, UFM, V8K, VEM, VPE, W--, X--, Y--, ZVB or ZVC');
617: hr_utility.raise_error;
618: end if;
619: else
620: if (p_Cur_Appt_Auth_1 in ('BPM','H2L','J8M',
621: 'UFM','V8K','VEM','VPE','ZVB','ZVC') or
626: ) and
627: p_position_occupied_code <>'2' and
628: p_position_occupied_code is not null
629: then
630: hr_utility.set_message(8301, 'GHR_37122_ALL_PROCEDURE_FAIL');
631: hr_utility.set_message_token('APP_AUTH',
632: 'BPM, H2L, J8M, UFM, V8K, VEM, VPE, W--, X--, Y--, ZVB or ZVC');
633: hr_utility.raise_error;
634: end if;
627: p_position_occupied_code <>'2' and
628: p_position_occupied_code is not null
629: then
630: hr_utility.set_message(8301, 'GHR_37122_ALL_PROCEDURE_FAIL');
631: hr_utility.set_message_token('APP_AUTH',
632: 'BPM, H2L, J8M, UFM, V8K, VEM, VPE, W--, X--, Y--, ZVB or ZVC');
633: hr_utility.raise_error;
634: end if;
635: end if;
629: then
630: hr_utility.set_message(8301, 'GHR_37122_ALL_PROCEDURE_FAIL');
631: hr_utility.set_message_token('APP_AUTH',
632: 'BPM, H2L, J8M, UFM, V8K, VEM, VPE, W--, X--, Y--, ZVB or ZVC');
633: hr_utility.raise_error;
634: end if;
635: end if;
636:
637: -- 100.11.2
649: ) and
650: p_Position_Occupied_Code <> '2' and
651: p_Position_Occupied_Code is not null
652: then
653: hr_utility.set_message(8301, 'GHR_37123_ALL_PROCEDURE_FAIL');
654: hr_utility.raise_error;
655: end if;
656: end if;
657:
650: p_Position_Occupied_Code <> '2' and
651: p_Position_Occupied_Code is not null
652: then
653: hr_utility.set_message(8301, 'GHR_37123_ALL_PROCEDURE_FAIL');
654: hr_utility.raise_error;
655: end if;
656: end if;
657:
658: --100.12.1
670: and
671: p_agency_subelement is not null
672: then
673: if p_effective_date < fnd_date.canonical_to_date('2006/07/01') then
674: hr_utility.set_message(8301, 'GHR_37055_ALL_PROCEDURE_FAIL');
675: hr_utility.raise_error;
676: else
677: hr_utility.set_message(8301, 'GHR_37691_ALL_PROCEDURE_FAIL');
678: hr_utility.raise_error;
671: p_agency_subelement is not null
672: then
673: if p_effective_date < fnd_date.canonical_to_date('2006/07/01') then
674: hr_utility.set_message(8301, 'GHR_37055_ALL_PROCEDURE_FAIL');
675: hr_utility.raise_error;
676: else
677: hr_utility.set_message(8301, 'GHR_37691_ALL_PROCEDURE_FAIL');
678: hr_utility.raise_error;
679: end if;
673: if p_effective_date < fnd_date.canonical_to_date('2006/07/01') then
674: hr_utility.set_message(8301, 'GHR_37055_ALL_PROCEDURE_FAIL');
675: hr_utility.raise_error;
676: else
677: hr_utility.set_message(8301, 'GHR_37691_ALL_PROCEDURE_FAIL');
678: hr_utility.raise_error;
679: end if;
680: end if;
681: end if;
674: hr_utility.set_message(8301, 'GHR_37055_ALL_PROCEDURE_FAIL');
675: hr_utility.raise_error;
676: else
677: hr_utility.set_message(8301, 'GHR_37691_ALL_PROCEDURE_FAIL');
678: hr_utility.raise_error;
679: end if;
680: end if;
681: end if;
682:
693: if p_To_Pay_Plan = 'ES' and
694: p_Cur_Appt_Auth_1 not in ('NRM','NSM','NTM','NVM','NWM','NXM','P2M','P3M','P5M','P7M',
695: 'V2M','VAG','VBJ','VCJ','V4L','V4M','V6M','V4P') and
696: p_Cur_Appt_Auth_1 is not null then
697: hr_utility.set_message(8301, 'GHR_37124_ALL_PROCEDURE_FAIL');
698: hr_utility.raise_error;
699: end if;
700: end if;
701:
694: p_Cur_Appt_Auth_1 not in ('NRM','NSM','NTM','NVM','NWM','NXM','P2M','P3M','P5M','P7M',
695: 'V2M','VAG','VBJ','VCJ','V4L','V4M','V6M','V4P') and
696: p_Cur_Appt_Auth_1 is not null then
697: hr_utility.set_message(8301, 'GHR_37124_ALL_PROCEDURE_FAIL');
698: hr_utility.raise_error;
699: end if;
700: end if;
701:
702: -- 100.13.3 -- 100.13.1 renumbered as 100.13.3
710: if p_To_Pay_Plan = 'ES' and
711: p_Cur_Appt_Auth_1 not in ('NRM','NSM','NTM','NVM','NWM','NXM','P2M','P3M','P5M','P7M',
712: 'V2M','VAG','VBJ','VCJ','V4L','V4M','V6M','V4P') and
713: p_Cur_Appt_Auth_1 is not null then
714: hr_utility.set_message(8301, 'GHR_37875_ALL_PROCEDURE_FAIL');
715: hr_utility.raise_error;
716: end if;
717: end if;
718:
711: p_Cur_Appt_Auth_1 not in ('NRM','NSM','NTM','NVM','NWM','NXM','P2M','P3M','P5M','P7M',
712: 'V2M','VAG','VBJ','VCJ','V4L','V4M','V6M','V4P') and
713: p_Cur_Appt_Auth_1 is not null then
714: hr_utility.set_message(8301, 'GHR_37875_ALL_PROCEDURE_FAIL');
715: hr_utility.raise_error;
716: end if;
717: end if;
718:
719: -- 100.14.3
724: p_Cur_Appt_Auth_2 not in ('AUM','AWM','BWM','HAM','ZLM')
725: and
726: p_Cur_Appt_Auth_2 is not null
727: then
728: hr_utility.set_message(8301, 'GHR_37125_ALL_PROCEDURE_FAIL');
729: hr_utility.raise_error;
730: end if;
731: else
732: if p_To_Pay_Plan = 'ES'
725: and
726: p_Cur_Appt_Auth_2 is not null
727: then
728: hr_utility.set_message(8301, 'GHR_37125_ALL_PROCEDURE_FAIL');
729: hr_utility.raise_error;
730: end if;
731: else
732: if p_To_Pay_Plan = 'ES'
733: and
734: p_Cur_Appt_Auth_2 not in ('AUM','AWM','BWM','HAM','ZLM')
735: and
736: p_Cur_Appt_Auth_2 is not null
737: then
738: hr_utility.set_message(8301, 'GHR_37125_ALL_PROCEDURE_FAIL');
739: hr_utility.raise_error;
740: end if;
741: end if;
742: -- 100.16.3
735: and
736: p_Cur_Appt_Auth_2 is not null
737: then
738: hr_utility.set_message(8301, 'GHR_37125_ALL_PROCEDURE_FAIL');
739: hr_utility.raise_error;
740: end if;
741: end if;
742: -- 100.16.3
743: -- Dec 01 Patch vravikan Delete YKM
747: p_Cur_Appt_Auth_2 in ('WTM','WUM')) and
748: p_Handicap <>'04' and
749: to_number(p_Handicap) not between 6 and 94 and
750: p_Handicap is not null then
751: hr_utility.set_message(8301, 'GHR_37126_ALL_PROCEDURE_FAIL');
752: hr_utility.set_message_token('APP_AUTH','WTM, WUM');
753: hr_utility.raise_error;
754: end if;
755: --Bug #11726461
748: p_Handicap <>'04' and
749: to_number(p_Handicap) not between 6 and 94 and
750: p_Handicap is not null then
751: hr_utility.set_message(8301, 'GHR_37126_ALL_PROCEDURE_FAIL');
752: hr_utility.set_message_token('APP_AUTH','WTM, WUM');
753: hr_utility.raise_error;
754: end if;
755: --Bug #11726461
756: ELSIF p_effective_date < fnd_date.canonical_to_date('2011/02/01') then
749: to_number(p_Handicap) not between 6 and 94 and
750: p_Handicap is not null then
751: hr_utility.set_message(8301, 'GHR_37126_ALL_PROCEDURE_FAIL');
752: hr_utility.set_message_token('APP_AUTH','WTM, WUM');
753: hr_utility.raise_error;
754: end if;
755: --Bug #11726461
756: ELSIF p_effective_date < fnd_date.canonical_to_date('2011/02/01') then
757: if (p_Cur_Appt_Auth_1 in ('WUM') or
758: p_Cur_Appt_Auth_2 in ('WUM')) and
759: p_Handicap <>'04' and
760: to_number(p_Handicap) not between 6 and 94 and
761: p_Handicap is not null then
762: hr_utility.set_message(8301, 'GHR_37126_ALL_PROCEDURE_FAIL');
763: hr_utility.set_message_token('APP_AUTH','WUM');
764: hr_utility.raise_error;
765: end if;
766: --Begin Bug #11726461
759: p_Handicap <>'04' and
760: to_number(p_Handicap) not between 6 and 94 and
761: p_Handicap is not null then
762: hr_utility.set_message(8301, 'GHR_37126_ALL_PROCEDURE_FAIL');
763: hr_utility.set_message_token('APP_AUTH','WUM');
764: hr_utility.raise_error;
765: end if;
766: --Begin Bug #11726461
767: ELSE
760: to_number(p_Handicap) not between 6 and 94 and
761: p_Handicap is not null then
762: hr_utility.set_message(8301, 'GHR_37126_ALL_PROCEDURE_FAIL');
763: hr_utility.set_message_token('APP_AUTH','WUM');
764: hr_utility.raise_error;
765: end if;
766: --Begin Bug #11726461
767: ELSE
768: if (p_Cur_Appt_Auth_1 in ('WUM') or
769: p_Cur_Appt_Auth_2 in ('WUM')) and
770: p_Handicap <>'01' and
771: to_number(p_Handicap) not between 6 and 98 and
772: p_Handicap is not null then
773: hr_utility.set_message(8301, 'GHR_38358_ALL_PROCEDURE_FAIL');
774: hr_utility.raise_error;
775: end if;
776: --End Bug #11726461
777: END IF;
770: p_Handicap <>'01' and
771: to_number(p_Handicap) not between 6 and 98 and
772: p_Handicap is not null then
773: hr_utility.set_message(8301, 'GHR_38358_ALL_PROCEDURE_FAIL');
774: hr_utility.raise_error;
775: end if;
776: --End Bug #11726461
777: END IF;
778:
784: if p_effective_date >= fnd_date.canonical_to_date('1998/09/01') then
785: if ( p_Cur_Appt_Auth_1 IN ('UAM','Z2U','Z2W','Z6L') or p_Cur_Appt_Auth_2 IN ('UAM','Z2U','Z2W','Z6L')) and
786: substr(p_Agency_Subelement,1,2) not in ('AF','AR','DD','NV')
787: then
788: hr_utility.set_message(8301, 'GHR_37893_ALL_PROCEDURE_FAIL');
789: hr_utility.raise_error;
790: end if;
791: end if;
792:
785: if ( p_Cur_Appt_Auth_1 IN ('UAM','Z2U','Z2W','Z6L') or p_Cur_Appt_Auth_2 IN ('UAM','Z2U','Z2W','Z6L')) and
786: substr(p_Agency_Subelement,1,2) not in ('AF','AR','DD','NV')
787: then
788: hr_utility.set_message(8301, 'GHR_37893_ALL_PROCEDURE_FAIL');
789: hr_utility.raise_error;
790: end if;
791: end if;
792:
793: -- 100.19.1
832: AND
833: p_position_occupied_code is not null
834: then
835:
836: hr_utility.set_message(8301, 'GHR_37127_ALL_PROCEDURE_FAIL');
837: hr_utility.raise_error;
838:
839: end if;
840: else
833: p_position_occupied_code is not null
834: then
835:
836: hr_utility.set_message(8301, 'GHR_37127_ALL_PROCEDURE_FAIL');
837: hr_utility.raise_error;
838:
839: end if;
840: else
841: if (p_Cur_Appt_Auth_1 in
867: AND
868: p_position_occupied_code is not null
869: then
870:
871: hr_utility.set_message(8301, 'GHR_37692_ALL_PROCEDURE_FAIL');
872: hr_utility.raise_error;
873:
874: end if;
875: end if;
868: p_position_occupied_code is not null
869: then
870:
871: hr_utility.set_message(8301, 'GHR_37692_ALL_PROCEDURE_FAIL');
872: hr_utility.raise_error;
873:
874: end if;
875: end if;
876:
921: p_Position_Occupied_Code <> '1'
922: and
923: p_Position_Occupied_Code is not null
924: then
925: hr_utility.set_message(8301, 'GHR_37128_ALL_PROCEDURE_FAIL');
926: hr_utility.raise_error;
927: end if;
928: END IF;
929: --
922: and
923: p_Position_Occupied_Code is not null
924: then
925: hr_utility.set_message(8301, 'GHR_37128_ALL_PROCEDURE_FAIL');
926: hr_utility.raise_error;
927: end if;
928: END IF;
929: --
930:
954: p_Tenure_Goupe_Code <> '3'
955: and
956: p_Tenure_Goupe_Code is not null
957: then
958: hr_utility.set_message(8301, 'GHR_37129_ALL_PROCEDURE_FAIL');
959: hr_utility.raise_error;
960: end if;
961:
962: -- 100.25.3
955: and
956: p_Tenure_Goupe_Code is not null
957: then
958: hr_utility.set_message(8301, 'GHR_37129_ALL_PROCEDURE_FAIL');
959: hr_utility.raise_error;
960: end if;
961:
962: -- 100.25.3
963: if ((
975: p_Tenure_Goupe_Code <>'1'
976: and
977: p_Tenure_Goupe_Code is not null
978: then
979: hr_utility.set_message(8301, 'GHR_37130_ALL_PROCEDURE_FAIL');
980: hr_utility.raise_error;
981: end if;
982:
983: -- 100.28.3
976: and
977: p_Tenure_Goupe_Code is not null
978: then
979: hr_utility.set_message(8301, 'GHR_37130_ALL_PROCEDURE_FAIL');
980: hr_utility.raise_error;
981: end if;
982:
983: -- 100.28.3
984: -- Dec 01 Patch 12/10/01 vravikan Add YCM
993: p_Tenure_Goupe_Code <>'1' and
994: p_Tenure_Goupe_Code <>'2' and
995: p_Tenure_Goupe_Code is not null
996: then
997: hr_utility.set_message(8301, 'GHR_37131_ALL_PROCEDURE_FAIL');
998: hr_utility.set_message_token('APP_ATRTY','YBM, YCM, YGM, Y1M, Y2M, or Y3M');
999: hr_utility.raise_error;
1000: end if;
1001: ELSIF p_effective_date < fnd_date.canonical_to_date('2009/03/01') THEN
994: p_Tenure_Goupe_Code <>'2' and
995: p_Tenure_Goupe_Code is not null
996: then
997: hr_utility.set_message(8301, 'GHR_37131_ALL_PROCEDURE_FAIL');
998: hr_utility.set_message_token('APP_ATRTY','YBM, YCM, YGM, Y1M, Y2M, or Y3M');
999: hr_utility.raise_error;
1000: end if;
1001: ELSIF p_effective_date < fnd_date.canonical_to_date('2009/03/01') THEN
1002: if ( p_Cur_Appt_Auth_1 in ('YBM','YCM','YGM','Y1M','Y2M','Y3M') or
995: p_Tenure_Goupe_Code is not null
996: then
997: hr_utility.set_message(8301, 'GHR_37131_ALL_PROCEDURE_FAIL');
998: hr_utility.set_message_token('APP_ATRTY','YBM, YCM, YGM, Y1M, Y2M, or Y3M');
999: hr_utility.raise_error;
1000: end if;
1001: ELSIF p_effective_date < fnd_date.canonical_to_date('2009/03/01') THEN
1002: if ( p_Cur_Appt_Auth_1 in ('YBM','YCM','YGM','Y1M','Y2M','Y3M') or
1003: p_Cur_Appt_Auth_2 in ('YBM','YCM','YGM','Y1M','Y2M','Y3M')) and
1004: substr(p_To_Pay_Plan,1,1)<>'Y' and
1005: p_Tenure_Goupe_Code <>'2' and
1006: p_Tenure_Goupe_Code is not null
1007: then
1008: hr_utility.set_message(8301, 'GHR_37131_ALL_PROCEDURE_FAIL');
1009: hr_utility.set_message_token('APP_ATRTY','YBM, YCM, YGM, Y1M, Y2M, or Y3M, And pay plan is other than Yx');
1010: hr_utility.raise_error;
1011: end if;
1012: ELSE
1005: p_Tenure_Goupe_Code <>'2' and
1006: p_Tenure_Goupe_Code is not null
1007: then
1008: hr_utility.set_message(8301, 'GHR_37131_ALL_PROCEDURE_FAIL');
1009: hr_utility.set_message_token('APP_ATRTY','YBM, YCM, YGM, Y1M, Y2M, or Y3M, And pay plan is other than Yx');
1010: hr_utility.raise_error;
1011: end if;
1012: ELSE
1013: if ( p_Cur_Appt_Auth_1 in ('YBM','YCM','YGM','Y1M','Y2M','Y3M') or
1006: p_Tenure_Goupe_Code is not null
1007: then
1008: hr_utility.set_message(8301, 'GHR_37131_ALL_PROCEDURE_FAIL');
1009: hr_utility.set_message_token('APP_ATRTY','YBM, YCM, YGM, Y1M, Y2M, or Y3M, And pay plan is other than Yx');
1010: hr_utility.raise_error;
1011: end if;
1012: ELSE
1013: if ( p_Cur_Appt_Auth_1 in ('YBM','YCM','YGM','Y1M','Y2M','Y3M') or
1014: p_Cur_Appt_Auth_2 in ('YBM','YCM','YGM','Y1M','Y2M','Y3M')) and
1014: p_Cur_Appt_Auth_2 in ('YBM','YCM','YGM','Y1M','Y2M','Y3M')) and
1015: p_Tenure_Goupe_Code <>'2' and
1016: p_Tenure_Goupe_Code is not null
1017: then
1018: hr_utility.set_message(8301, 'GHR_37131_ALL_PROCEDURE_FAIL');
1019: hr_utility.set_message_token('APP_ATRTY','YBM, YCM, YGM, Y1M, Y2M, or Y3M');
1020: hr_utility.raise_error;
1021: end if;
1022: END IF;
1015: p_Tenure_Goupe_Code <>'2' and
1016: p_Tenure_Goupe_Code is not null
1017: then
1018: hr_utility.set_message(8301, 'GHR_37131_ALL_PROCEDURE_FAIL');
1019: hr_utility.set_message_token('APP_ATRTY','YBM, YCM, YGM, Y1M, Y2M, or Y3M');
1020: hr_utility.raise_error;
1021: end if;
1022: END IF;
1023:
1016: p_Tenure_Goupe_Code is not null
1017: then
1018: hr_utility.set_message(8301, 'GHR_37131_ALL_PROCEDURE_FAIL');
1019: hr_utility.set_message_token('APP_ATRTY','YBM, YCM, YGM, Y1M, Y2M, or Y3M');
1020: hr_utility.raise_error;
1021: end if;
1022: END IF;
1023:
1024:
1033: p_Tenure_Goupe_Code <>'3'
1034: and
1035: p_Tenure_Goupe_Code is not null
1036: then
1037: hr_utility.set_message(8301, 'GHR_37132_ALL_PROCEDURE_FAIL');
1038: hr_utility.raise_error;
1039: end if;
1040:
1041: -- 100.35.3
1034: and
1035: p_Tenure_Goupe_Code is not null
1036: then
1037: hr_utility.set_message(8301, 'GHR_37132_ALL_PROCEDURE_FAIL');
1038: hr_utility.raise_error;
1039: end if;
1040:
1041: -- 100.35.3
1042: if (
1047: substr(p_Agency_Subelement,1,2) <>'VA'
1048: or p_Position_Occupied_Code <>'2'
1049: )
1050: then
1051: hr_utility.set_message(8301, 'GHR_37133_ALL_PROCEDURE_FAIL');
1052: hr_utility.raise_error;
1053: end if;
1054:
1055: -- 100.36.3
1048: or p_Position_Occupied_Code <>'2'
1049: )
1050: then
1051: hr_utility.set_message(8301, 'GHR_37133_ALL_PROCEDURE_FAIL');
1052: hr_utility.raise_error;
1053: end if;
1054:
1055: -- 100.36.3
1056: if p_To_Pay_Plan='GS'
1066: or
1067: p_Cur_Appt_Auth_2 = 'ZNM'
1068: )
1069: then
1070: hr_utility.set_message(8301, 'GHR_37134_ALL_PROCEDURE_FAIL');
1071: hr_utility.raise_error;
1072: end if;
1073:
1074: -- 100.37.3
1067: p_Cur_Appt_Auth_2 = 'ZNM'
1068: )
1069: then
1070: hr_utility.set_message(8301, 'GHR_37134_ALL_PROCEDURE_FAIL');
1071: hr_utility.raise_error;
1072: end if;
1073:
1074: -- 100.37.3
1075: if (
1081: p_Vet_Pref_Code = '1'
1082: or p_Vet_Pref_Code = '5'
1083: )
1084: then
1085: hr_utility.set_message(8301, 'GHR_37135_ALL_PROCEDURE_FAIL');
1086: hr_utility.raise_error;
1087: end if;
1088:
1089: -- 100.38.3
1082: or p_Vet_Pref_Code = '5'
1083: )
1084: then
1085: hr_utility.set_message(8301, 'GHR_37135_ALL_PROCEDURE_FAIL');
1086: hr_utility.raise_error;
1087: end if;
1088:
1089: -- 100.38.3
1090: --
1099: if p_effective_date < fnd_date.canonical_to_date('2009/03/01') then
1100: if (p_Cur_Appt_Auth_1 in ( 'Z2U','UAM') or
1101: p_Cur_Appt_Auth_2 in ('Z2U','UAM') ) and
1102: substr(p_Agency_Subelement,1,2) not in ('AF','AR','DD','NV') then
1103: hr_utility.set_message(8301, 'GHR_37876_ALL_PROCEDURE_FAIL');
1104: hr_utility.set_message_token('APP_ATRTY','Z2U or UAM');
1105: hr_utility.raise_error;
1106: end if;
1107: else
1100: if (p_Cur_Appt_Auth_1 in ( 'Z2U','UAM') or
1101: p_Cur_Appt_Auth_2 in ('Z2U','UAM') ) and
1102: substr(p_Agency_Subelement,1,2) not in ('AF','AR','DD','NV') then
1103: hr_utility.set_message(8301, 'GHR_37876_ALL_PROCEDURE_FAIL');
1104: hr_utility.set_message_token('APP_ATRTY','Z2U or UAM');
1105: hr_utility.raise_error;
1106: end if;
1107: else
1108: if (p_Cur_Appt_Auth_1 in ( 'Z2U','UAM','Z6L') or
1101: p_Cur_Appt_Auth_2 in ('Z2U','UAM') ) and
1102: substr(p_Agency_Subelement,1,2) not in ('AF','AR','DD','NV') then
1103: hr_utility.set_message(8301, 'GHR_37876_ALL_PROCEDURE_FAIL');
1104: hr_utility.set_message_token('APP_ATRTY','Z2U or UAM');
1105: hr_utility.raise_error;
1106: end if;
1107: else
1108: if (p_Cur_Appt_Auth_1 in ( 'Z2U','UAM','Z6L') or
1109: p_Cur_Appt_Auth_2 in ('Z2U','UAM','Z6L') ) and
1107: else
1108: if (p_Cur_Appt_Auth_1 in ( 'Z2U','UAM','Z6L') or
1109: p_Cur_Appt_Auth_2 in ('Z2U','UAM','Z6L') ) and
1110: substr(p_Agency_Subelement,1,2) not in ('AF','AR','DD','NV') then
1111: hr_utility.set_message(8301, 'GHR_37876_ALL_PROCEDURE_FAIL');
1112: hr_utility.set_message_token('APP_ATRTY','Z2U, UAM or Z6L');
1113: hr_utility.raise_error;
1114: end if;
1115: end if;
1108: if (p_Cur_Appt_Auth_1 in ( 'Z2U','UAM','Z6L') or
1109: p_Cur_Appt_Auth_2 in ('Z2U','UAM','Z6L') ) and
1110: substr(p_Agency_Subelement,1,2) not in ('AF','AR','DD','NV') then
1111: hr_utility.set_message(8301, 'GHR_37876_ALL_PROCEDURE_FAIL');
1112: hr_utility.set_message_token('APP_ATRTY','Z2U, UAM or Z6L');
1113: hr_utility.raise_error;
1114: end if;
1115: end if;
1116: end if;
1109: p_Cur_Appt_Auth_2 in ('Z2U','UAM','Z6L') ) and
1110: substr(p_Agency_Subelement,1,2) not in ('AF','AR','DD','NV') then
1111: hr_utility.set_message(8301, 'GHR_37876_ALL_PROCEDURE_FAIL');
1112: hr_utility.set_message_token('APP_ATRTY','Z2U, UAM or Z6L');
1113: hr_utility.raise_error;
1114: end if;
1115: end if;
1116: end if;
1117: end if;
1126: substr(p_Duty_Station_Lookup_Code,1,2) <> 'PM'
1127: and
1128: p_Duty_Station_Lookup_Code is not null
1129: then
1130: hr_utility.set_message(8301, 'GHR_37136_ALL_PROCEDURE_FAIL');
1131: hr_utility.raise_error;
1132: end if;
1133: */
1134:
1127: and
1128: p_Duty_Station_Lookup_Code is not null
1129: then
1130: hr_utility.set_message(8301, 'GHR_37136_ALL_PROCEDURE_FAIL');
1131: hr_utility.raise_error;
1132: end if;
1133: */
1134:
1135: -- 100.55.1
1143: p_to_pay_plan <> 'ES'
1144: and
1145: p_to_pay_plan is not null
1146: then
1147: hr_utility.set_message(8301, 'GHR_37137_ALL_PROCEDURE_FAIL');
1148: hr_utility.raise_error;
1149: end if;
1150:
1151: -- 100.56.2
1144: and
1145: p_to_pay_plan is not null
1146: then
1147: hr_utility.set_message(8301, 'GHR_37137_ALL_PROCEDURE_FAIL');
1148: hr_utility.raise_error;
1149: end if;
1150:
1151: -- 100.56.2
1152: if (
1160: p_To_Pay_Plan <>'ES'
1161: and
1162: p_To_Pay_Plan is not null
1163: then
1164: hr_utility.set_message(8301, 'GHR_37138_ALL_PROCEDURE_FAIL');
1165: hr_utility.raise_error;
1166: end if;
1167:
1168: -- 100.58.3
1161: and
1162: p_To_Pay_Plan is not null
1163: then
1164: hr_utility.set_message(8301, 'GHR_37138_ALL_PROCEDURE_FAIL');
1165: hr_utility.raise_error;
1166: end if;
1167:
1168: -- 100.58.3
1169: -- Raju 20-Apr-2007 UPD 53(Bug 5996938) Delete cur_appt_auth2 From Starting
1177: )or(p_Position_Occupied_Code <> '1' and
1178: p_Position_Occupied_Code is not null )
1179: )
1180: then
1181: hr_utility.set_message(8301, 'GHR_37139_ALL_PROCEDURE_FAIL');
1182: hr_utility.raise_error;
1183: end if;
1184:
1185: /*
1178: p_Position_Occupied_Code is not null )
1179: )
1180: then
1181: hr_utility.set_message(8301, 'GHR_37139_ALL_PROCEDURE_FAIL');
1182: hr_utility.raise_error;
1183: end if;
1184:
1185: /*
1186: -- 100.61.2
1197: or
1198: p_Cur_Appt_Auth_2 <>p_First_Action_NOA_LA_Code2
1199: )
1200: then
1201: hr_utility.set_message(8301, 'GHR_37140_ALL_PROCEDURE_FAIL');
1202: hr_utility.raise_error;
1203: end if;
1204: */
1205:
1198: p_Cur_Appt_Auth_2 <>p_First_Action_NOA_LA_Code2
1199: )
1200: then
1201: hr_utility.set_message(8301, 'GHR_37140_ALL_PROCEDURE_FAIL');
1202: hr_utility.raise_error;
1203: end if;
1204: */
1205:
1206: -- 100.64.3
1211: p_To_OCC_Code <> '0904'
1212: and
1213: p_To_OCC_Code is not null
1214: then
1215: hr_utility.set_message(8301, 'GHR_37141_ALL_PROCEDURE_FAIL');
1216: hr_utility.raise_error;
1217: end if;
1218:
1219: -- 100.70.3
1212: and
1213: p_To_OCC_Code is not null
1214: then
1215: hr_utility.set_message(8301, 'GHR_37141_ALL_PROCEDURE_FAIL');
1216: hr_utility.raise_error;
1217: end if;
1218:
1219: -- 100.70.3
1220: if (
1228: or
1229: p_To_OCC_Code is null
1230: )
1231: then
1232: hr_utility.set_message(8301, 'GHR_37142_ALL_PROCEDURE_FAIL');
1233: hr_utility.raise_error;
1234: end if;
1235:
1236: -- 100.73.3
1229: p_To_OCC_Code is null
1230: )
1231: then
1232: hr_utility.set_message(8301, 'GHR_37142_ALL_PROCEDURE_FAIL');
1233: hr_utility.raise_error;
1234: end if;
1235:
1236: -- 100.73.3
1237: if (
1244: and
1245: (p_To_OCC_Code = '0904' or p_To_OCC_Code = '0905')
1246:
1247: then
1248: hr_utility.set_message(8301, 'GHR_37143_ALL_PROCEDURE_FAIL');
1249: hr_utility.raise_error;
1250: end if;
1251:
1252: -- 100.76.3
1245: (p_To_OCC_Code = '0904' or p_To_OCC_Code = '0905')
1246:
1247: then
1248: hr_utility.set_message(8301, 'GHR_37143_ALL_PROCEDURE_FAIL');
1249: hr_utility.raise_error;
1250: end if;
1251:
1252: -- 100.76.3
1253: if (
1258: p_To_Pay_Plan not in ('ED','EF','EH')
1259: and
1260: p_To_Pay_Plan is not null
1261: then
1262: hr_utility.set_message(8301, 'GHR_37144_ALL_PROCEDURE_FAIL');
1263: hr_utility.raise_error;
1264: end if;
1265:
1266: -- 100.98.3
1259: and
1260: p_To_Pay_Plan is not null
1261: then
1262: hr_utility.set_message(8301, 'GHR_37144_ALL_PROCEDURE_FAIL');
1263: hr_utility.raise_error;
1264: end if;
1265:
1266: -- 100.98.3
1267: if p_Cur_Appt_Auth_1='ZZZ'
1269: p_Cur_Appt_Auth_2 <>'ZZZ'
1270: and
1271: p_Cur_Appt_Auth_2 is not null
1272: then
1273: hr_utility.set_message(8301, 'GHR_37145_ALL_PROCEDURE_FAIL');
1274: hr_utility.raise_error;
1275: end if;
1276:
1277: -- 100.99.3
1270: and
1271: p_Cur_Appt_Auth_2 is not null
1272: then
1273: hr_utility.set_message(8301, 'GHR_37145_ALL_PROCEDURE_FAIL');
1274: hr_utility.raise_error;
1275: end if;
1276:
1277: -- 100.99.3
1278: if p_Cur_Appt_Auth_2='ZZZ'
1280: p_Cur_Appt_Auth_1 <> 'ZZZ'
1281: and
1282: p_Cur_Appt_Auth_1 is not null
1283: then
1284: hr_utility.set_message(8301, 'GHR_37146_ALL_PROCEDURE_FAIL');
1285: hr_utility.raise_error;
1286: end if;
1287:
1288:
1281: and
1282: p_Cur_Appt_Auth_1 is not null
1283: then
1284: hr_utility.set_message(8301, 'GHR_37146_ALL_PROCEDURE_FAIL');
1285: hr_utility.raise_error;
1286: end if;
1287:
1288:
1289: end chk_Cur_Appt_Auth;
1306: and
1307: (to_number(substr(to_char(p_Effective_Date, 'MMDDYYYY'),5,4)) -
1308: to_number(substr(to_char(p_employee_date_of_birth, 'MMDDYYYY'),5,4)) ) < 50
1309: then
1310: hr_utility.set_message(8301, 'GHR_37147_ALL_PROCEDURE_FAIL');
1311: hr_utility.raise_error;
1312: end if;
1313:
1314: -- 110.05.2
1307: (to_number(substr(to_char(p_Effective_Date, 'MMDDYYYY'),5,4)) -
1308: to_number(substr(to_char(p_employee_date_of_birth, 'MMDDYYYY'),5,4)) ) < 50
1309: then
1310: hr_utility.set_message(8301, 'GHR_37147_ALL_PROCEDURE_FAIL');
1311: hr_utility.raise_error;
1312: end if;
1313:
1314: -- 110.05.2
1315: -- Date of birth must be at least 13 years less than the
1315: -- Date of birth must be at least 13 years less than the
1316: -- effective date of personnel action, or be asterisks.
1317:
1318: if (months_between(p_as_of_date, p_employee_date_of_birth) < 156 ) then
1319: hr_utility.set_message(8301, 'GHR_38412_ALL_PROCEDURE_FAIL');
1320: hr_utility.raise_error;
1321: end if;
1322:
1323: -- 110.07.2
1316: -- effective date of personnel action, or be asterisks.
1317:
1318: if (months_between(p_as_of_date, p_employee_date_of_birth) < 156 ) then
1319: hr_utility.set_message(8301, 'GHR_38412_ALL_PROCEDURE_FAIL');
1320: hr_utility.raise_error;
1321: end if;
1322:
1323: -- 110.07.2
1324: -- end dated this edit on 27-oct-98 for bug 745246
1335: and
1336: (to_number(substr(to_char(p_Effective_Date, 'MMDDYYYY'),5,4)) -
1337: to_number(substr(to_char(p_employee_date_of_birth, 'MMDDYYYY'),5,4)) ) < 15
1338: then
1339: hr_utility.set_message(8301, 'GHR_37149_ALL_PROCEDURE_FAIL');
1340: hr_utility.raise_error;
1341: end if;
1342: end if;
1343:
1336: (to_number(substr(to_char(p_Effective_Date, 'MMDDYYYY'),5,4)) -
1337: to_number(substr(to_char(p_employee_date_of_birth, 'MMDDYYYY'),5,4)) ) < 15
1338: then
1339: hr_utility.set_message(8301, 'GHR_37149_ALL_PROCEDURE_FAIL');
1340: hr_utility.raise_error;
1341: end if;
1342: end if;
1343:
1344: end chk_Date_of_Birth;
1363: and
1364: substr(p_duty_station_lookup,2,1) not in ('0','1','2','3','4','5','6','7','8','9')
1365: ) and
1366: substr(p_duty_station_lookup,-3,3) <> '000' then
1367: hr_utility.set_message(8301, 'GHR_37150_ALL_PROCEDURE_FAIL');
1368: hr_utility.raise_error;
1369: end if;
1370:
1371: /* Commented -- Dec 2001 Patch
1364: substr(p_duty_station_lookup,2,1) not in ('0','1','2','3','4','5','6','7','8','9')
1365: ) and
1366: substr(p_duty_station_lookup,-3,3) <> '000' then
1367: hr_utility.set_message(8301, 'GHR_37150_ALL_PROCEDURE_FAIL');
1368: hr_utility.raise_error;
1369: end if;
1370:
1371: /* Commented -- Dec 2001 Patch
1372: -- 120.02.3
1378: substr( p_duty_station_lookup,1,2) <> 'PM'
1379: and
1380: p_duty_station_lookup is not null
1381: then
1382: hr_utility.set_message(8301, 'GHR_37151_ALL_PROCEDURE_FAIL');
1383: hr_utility.raise_error;
1384: end if;
1385: */
1386:
1379: and
1380: p_duty_station_lookup is not null
1381: then
1382: hr_utility.set_message(8301, 'GHR_37151_ALL_PROCEDURE_FAIL');
1383: hr_utility.raise_error;
1384: end if;
1385: */
1386:
1387: -- 120.03.3
1394: substr( p_duty_station_lookup,1,2) not in ( '11','24','51' )
1395: and
1396: p_duty_station_lookup is not null
1397: then
1398: hr_utility.set_message(8301, 'GHR_37166_ALL_PROCEDURE_FAIL');
1399: hr_utility.raise_error;
1400: end if;
1401: end if; */
1402:
1395: and
1396: p_duty_station_lookup is not null
1397: then
1398: hr_utility.set_message(8301, 'GHR_37166_ALL_PROCEDURE_FAIL');
1399: hr_utility.raise_error;
1400: end if;
1401: end if; */
1402:
1403: -- 120.04.3
1415: substr(p_duty_station_lookup,1,2) <> 'RQ'
1416: and
1417: p_duty_station_lookup is not null
1418: then
1419: hr_utility.set_message(8301, 'GHR_37152_ALL_PROCEDURE_FAIL');
1420: hr_utility.raise_error;
1421: end if;
1422: else
1423: if substr(p_to_play_plan,1,2) in ('WQ','WR','WU')
1416: and
1417: p_duty_station_lookup is not null
1418: then
1419: hr_utility.set_message(8301, 'GHR_37152_ALL_PROCEDURE_FAIL');
1420: hr_utility.raise_error;
1421: end if;
1422: else
1423: if substr(p_to_play_plan,1,2) in ('WQ','WR','WU')
1424: and
1425: substr(p_duty_station_lookup,1,2) <> 'RQ'
1426: and
1427: p_duty_station_lookup is not null
1428: then
1429: hr_utility.set_message(8301, 'GHR_37600_ALL_PROCEDURE_FAIL');
1430: hr_utility.raise_error;
1431: end if;
1432: end if;
1433: end if;
1426: and
1427: p_duty_station_lookup is not null
1428: then
1429: hr_utility.set_message(8301, 'GHR_37600_ALL_PROCEDURE_FAIL');
1430: hr_utility.raise_error;
1431: end if;
1432: end if;
1433: end if;
1434:
1439: substr(p_First_Action_NOA_LA_Code2,1,1)='T') and
1440: substr(p_duty_station_lookup,1,2) <>'PM' and
1441: p_duty_station_lookup is not null
1442: then
1443: hr_utility.set_message(8301, 'GHR_37153_ALL_PROCEDURE_FAIL');
1444: hr_utility.raise_error;
1445: end if;
1446: end if;
1447:
1440: substr(p_duty_station_lookup,1,2) <>'PM' and
1441: p_duty_station_lookup is not null
1442: then
1443: hr_utility.set_message(8301, 'GHR_37153_ALL_PROCEDURE_FAIL');
1444: hr_utility.raise_error;
1445: end if;
1446: end if;
1447:
1448: /*
1451: if substr(p_duty_station_lookup,1,2) = 'US'
1452: and
1453: p_agency_sub_element <> 'DJ02'
1454: then
1455: hr_utility.set_message(8301, 'GHR_37154_ALL_PROCEDURE_FAIL');
1456: hr_utility.raise_error;
1457: end if;
1458: */
1459:
1452: and
1453: p_agency_sub_element <> 'DJ02'
1454: then
1455: hr_utility.set_message(8301, 'GHR_37154_ALL_PROCEDURE_FAIL');
1456: hr_utility.raise_error;
1457: end if;
1458: */
1459:
1460: end chk_duty_station;
1477: )
1478: and
1479: p_education_level is null
1480: then
1481: hr_utility.set_message(8301, 'GHR_37155_ALL_PROCEDURE_FAIL');
1482: hr_utility.raise_error;
1483: end if;
1484:
1485: -- 130.04.3
1478: and
1479: p_education_level is null
1480: then
1481: hr_utility.set_message(8301, 'GHR_37155_ALL_PROCEDURE_FAIL');
1482: hr_utility.raise_error;
1483: end if;
1484:
1485: -- 130.04.3
1486: if p_pay_plan = 'ES'
1486: if p_pay_plan = 'ES'
1487: and
1488: p_education_level is null
1489: then
1490: hr_utility.set_message(8301, 'GHR_37156_ALL_PROCEDURE_FAIL');
1491: hr_utility.raise_error;
1492: end if;
1493:
1494: end chk_Education_Level;
1487: and
1488: p_education_level is null
1489: then
1490: hr_utility.set_message(8301, 'GHR_37156_ALL_PROCEDURE_FAIL');
1491: hr_utility.raise_error;
1492: end if;
1493:
1494: end chk_Education_Level;
1495:
1517: and
1518: to_char(p_Effective_Date,'MMDD')<= '0930'
1519: )
1520: then
1521: hr_utility.set_message(8301, 'GHR_37157_ALL_PROCEDURE_FAIL');
1522: hr_utility.raise_error;
1523: end if;
1524: */
1525:
1518: to_char(p_Effective_Date,'MMDD')<= '0930'
1519: )
1520: then
1521: hr_utility.set_message(8301, 'GHR_37157_ALL_PROCEDURE_FAIL');
1522: hr_utility.raise_error;
1523: end if;
1524: */
1525:
1526:
1533:
1534: to_number(substr(to_char(p_Effective_Date, 'MMDDYYYY'),5,4)) -
1535: to_number(substr(to_char(p_Production_Date, 'MMDDYYYY'),5,4)) ) < -2
1536: then
1537: hr_utility.set_message(8301, 'GHR_37158_ALL_PROCEDURE_FAIL');
1538: hr_utility.raise_error;
1539: end if;
1540: */
1541: --Begin Bug# 10189715
1534: to_number(substr(to_char(p_Effective_Date, 'MMDDYYYY'),5,4)) -
1535: to_number(substr(to_char(p_Production_Date, 'MMDDYYYY'),5,4)) ) < -2
1536: then
1537: hr_utility.set_message(8301, 'GHR_37158_ALL_PROCEDURE_FAIL');
1538: hr_utility.raise_error;
1539: end if;
1540: */
1541: --Begin Bug# 10189715
1542: if p_effective_date >= fnd_date.canonical_to_date('2010/05/01') then
1540: */
1541: --Begin Bug# 10189715
1542: if p_effective_date >= fnd_date.canonical_to_date('2010/05/01') then
1543: if Months_Between(p_Effective_Date,p_Production_Date)>6 then
1544: hr_utility.set_message(8301, 'GHR_37158_ALL_PROCEDURE_FAIL');
1545: hr_utility.raise_error;
1546: end if;
1547: end if;
1548: --End Bug# 10189715
1541: --Begin Bug# 10189715
1542: if p_effective_date >= fnd_date.canonical_to_date('2010/05/01') then
1543: if Months_Between(p_Effective_Date,p_Production_Date)>6 then
1544: hr_utility.set_message(8301, 'GHR_37158_ALL_PROCEDURE_FAIL');
1545: hr_utility.raise_error;
1546: end if;
1547: end if;
1548: --End Bug# 10189715
1549: -- End of 140.08.2
1570: p_First_Action_NOA_Code2 in ('WTM','WUM')) and
1571: to_number(p_Handicap) not between 6 and 94 and
1572: p_Handicap <>'04' and
1573: p_Handicap is not null then
1574: hr_utility.set_message(8301, 'GHR_37159_ALL_PROCEDURE_FAIL');
1575: hr_utility.set_message_token('APP_AUTH','WTM, WUM');
1576: hr_utility.raise_error;
1577: end if;
1578: --bug 11726461
1571: to_number(p_Handicap) not between 6 and 94 and
1572: p_Handicap <>'04' and
1573: p_Handicap is not null then
1574: hr_utility.set_message(8301, 'GHR_37159_ALL_PROCEDURE_FAIL');
1575: hr_utility.set_message_token('APP_AUTH','WTM, WUM');
1576: hr_utility.raise_error;
1577: end if;
1578: --bug 11726461
1579: elsif p_effective_date < fnd_date.canonical_to_date('2011/02/01') then
1572: p_Handicap <>'04' and
1573: p_Handicap is not null then
1574: hr_utility.set_message(8301, 'GHR_37159_ALL_PROCEDURE_FAIL');
1575: hr_utility.set_message_token('APP_AUTH','WTM, WUM');
1576: hr_utility.raise_error;
1577: end if;
1578: --bug 11726461
1579: elsif p_effective_date < fnd_date.canonical_to_date('2011/02/01') then
1580: if ( p_First_Action_NOA_Code1 in ('WUM') or
1581: p_First_Action_NOA_Code2 in ('WUM')) and
1582: to_number(p_Handicap) not between 6 and 94 and
1583: p_Handicap <>'04' and
1584: p_Handicap is not null then
1585: hr_utility.set_message(8301, 'GHR_37159_ALL_PROCEDURE_FAIL');
1586: hr_utility.set_message_token('APP_AUTH','WUM');
1587: hr_utility.raise_error;
1588: end if;
1589: --Begin bug 11726461
1582: to_number(p_Handicap) not between 6 and 94 and
1583: p_Handicap <>'04' and
1584: p_Handicap is not null then
1585: hr_utility.set_message(8301, 'GHR_37159_ALL_PROCEDURE_FAIL');
1586: hr_utility.set_message_token('APP_AUTH','WUM');
1587: hr_utility.raise_error;
1588: end if;
1589: --Begin bug 11726461
1590: else
1583: p_Handicap <>'04' and
1584: p_Handicap is not null then
1585: hr_utility.set_message(8301, 'GHR_37159_ALL_PROCEDURE_FAIL');
1586: hr_utility.set_message_token('APP_AUTH','WUM');
1587: hr_utility.raise_error;
1588: end if;
1589: --Begin bug 11726461
1590: else
1591: if ( p_First_Action_NOA_Code1 in ('WUM') or
1592: p_First_Action_NOA_Code2 in ('WUM')) and
1593: to_number(p_Handicap) not between 6 and 98 and
1594: p_Handicap <>'01' and
1595: p_Handicap is not null then
1596: hr_utility.set_message(8301, 'GHR_38357_ALL_PROCEDURE_FAIL');
1597: hr_utility.raise_error;
1598: end if;
1599: --End bug 11726461
1600: end if;
1593: to_number(p_Handicap) not between 6 and 98 and
1594: p_Handicap <>'01' and
1595: p_Handicap is not null then
1596: hr_utility.set_message(8301, 'GHR_38357_ALL_PROCEDURE_FAIL');
1597: hr_utility.raise_error;
1598: end if;
1599: --End bug 11726461
1600: end if;
1601:
1604: if substr(p_First_NOAC_Lookup_Code,1,1)='1'
1605: and
1606: p_Handicap='04'
1607: then
1608: hr_utility.set_message(8301, 'GHR_37160_ALL_PROCEDURE_FAIL');
1609: hr_utility.raise_error;
1610: end if;
1611:
1612: end chk_Handicap;
1605: and
1606: p_Handicap='04'
1607: then
1608: hr_utility.set_message(8301, 'GHR_37160_ALL_PROCEDURE_FAIL');
1609: hr_utility.raise_error;
1610: end if;
1611:
1612: end chk_Handicap;
1613:
1629: if p_First_NOAC_Lookup_Code in ('874','875','876','877')
1630: and
1631: p_Indiv_Award is null
1632: then
1633: hr_utility.set_message(8301, 'GHR_37161_ALL_PROCEDURE_FAIL');
1634: hr_utility.raise_error;
1635: end if;
1636: end if;*/
1637: null;
1630: and
1631: p_Indiv_Award is null
1632: then
1633: hr_utility.set_message(8301, 'GHR_37161_ALL_PROCEDURE_FAIL');
1634: hr_utility.raise_error;
1635: end if;
1636: end if;*/
1637: null;
1638: end chk_indiv_Award;
1655: AND to_number(p_Handicap) between 45 and 49
1656: AND to_number(p_Handicap) between 62 and 68
1657: AND to_number(p_Handicap) between 71 and 78
1658: then
1659: hr_utility.set_message(8301, 'GHR_38356_ALL_PROCEDURE_FAIL');
1660: hr_utility.raise_error;
1661: end if;
1662:
1663: end chk_scd_handicap;
1656: AND to_number(p_Handicap) between 62 and 68
1657: AND to_number(p_Handicap) between 71 and 78
1658: then
1659: hr_utility.set_message(8301, 'GHR_38356_ALL_PROCEDURE_FAIL');
1660: hr_utility.raise_error;
1661: end if;
1662:
1663: end chk_scd_handicap;
1664: