24: )
25: and
26: p_agency_sub_element <>'TD03'
27: then
28: hr_utility.set_message(8301, 'GHR_37301_ALL_PROCEDURE_FAIL');
29: hr_utility.raise_error;
30: end if;
31:
32: -- 250.03.2
25: and
26: p_agency_sub_element <>'TD03'
27: then
28: hr_utility.set_message(8301, 'GHR_37301_ALL_PROCEDURE_FAIL');
29: hr_utility.raise_error;
30: end if;
31:
32: -- 250.03.2
33: --
39: if p_effective_date > fnd_date.canonical_to_date('1998/03/01') then
40: if (p_First_Action_NOA_LA_Code1 in ('Z2U','UAM','Z2W','Z6H','Z6J') or
41: p_First_Action_NOA_LA_Code2 in ('Z2U','UAM','Z2W','Z6H','Z6J') ) and
42: substr(p_agency_sub_element,1,2) not in ('AF','AR','DD','NV') then
43: hr_utility.set_message(8301, 'GHR_37883_ALL_PROCEDURE_FAIL');
44: hr_utility.raise_error;
45: end if;
46: end if;
47:
40: if (p_First_Action_NOA_LA_Code1 in ('Z2U','UAM','Z2W','Z6H','Z6J') or
41: p_First_Action_NOA_LA_Code2 in ('Z2U','UAM','Z2W','Z6H','Z6J') ) and
42: substr(p_agency_sub_element,1,2) not in ('AF','AR','DD','NV') then
43: hr_utility.set_message(8301, 'GHR_37883_ALL_PROCEDURE_FAIL');
44: hr_utility.raise_error;
45: end if;
46: end if;
47:
48: /* Commented -- Dec 2001 Patch
54: if p_effective_date > fnd_date.canonical_to_date('1998/03/01') then
55: if (p_First_Action_NOA_LA_Code1 = 'ZPK' or
56: p_First_Action_NOA_LA_Code2 = 'ZPK' ) and
57: substr(p_agency_sub_element,1,2) <> 'PC' then
58: hr_utility.set_message(8301, 'GHR_37885_ALL_PROCEDURE_FAIL');
59: hr_utility.raise_error;
60: end if;
61: end if;
62: */
55: if (p_First_Action_NOA_LA_Code1 = 'ZPK' or
56: p_First_Action_NOA_LA_Code2 = 'ZPK' ) and
57: substr(p_agency_sub_element,1,2) <> 'PC' then
58: hr_utility.set_message(8301, 'GHR_37885_ALL_PROCEDURE_FAIL');
59: hr_utility.raise_error;
60: end if;
61: end if;
62: */
63: -- 250.04.2
67: --if p_effective_date < fnd_date.canonical_to_date('2009/12/31') then
68: if (p_First_Action_NOA_LA_Code1 = 'BAE' or
69: p_First_Action_NOA_LA_Code2 = 'BAE' ) and
70: substr(p_agency_sub_element,1,2) IN('AF','AR','DD','NV') then
71: hr_utility.set_message(8301, 'GHR_38985_ALL_PROCEDURE_FAIL');
72: hr_utility.raise_error;
73: end if;
74: --end if;
75: -- End Bug 4567571
68: if (p_First_Action_NOA_LA_Code1 = 'BAE' or
69: p_First_Action_NOA_LA_Code2 = 'BAE' ) and
70: substr(p_agency_sub_element,1,2) IN('AF','AR','DD','NV') then
71: hr_utility.set_message(8301, 'GHR_38985_ALL_PROCEDURE_FAIL');
72: hr_utility.raise_error;
73: end if;
74: --end if;
75: -- End Bug 4567571
76:
83: if p_effective_date >= fnd_date.canonical_to_date('1998/09/01') then
84: if (p_First_Action_NOA_LA_Code1 = 'Z2W' or
85: p_First_Action_NOA_LA_Code2 = 'Z2W' ) and
86: substr(p_agency_sub_element,1,2) not in ('AF','AR','DD','NV') then
87: hr_utility.set_message(8301, 'GHR_37894_ALL_PROCEDURE_FAIL');
88: hr_utility.raise_error;
89: end if;
90: end if;
91: end if;
84: if (p_First_Action_NOA_LA_Code1 = 'Z2W' or
85: p_First_Action_NOA_LA_Code2 = 'Z2W' ) and
86: substr(p_agency_sub_element,1,2) not in ('AF','AR','DD','NV') then
87: hr_utility.set_message(8301, 'GHR_37894_ALL_PROCEDURE_FAIL');
88: hr_utility.raise_error;
89: end if;
90: end if;
91: end if;
92: /* Commented as per December 2000 cpdf changes -- vravikan
99: if (p_First_Action_NOA_LA_Code1 = 'ZTA' or
100: p_First_Action_NOA_LA_Code2 = 'ZTA' ) and
101: p_position_occupied_code = '1' and
102: p_agency_sub_element <> 'DJ03' then
103: hr_utility.set_message(8301, 'GHR_37895_ALL_PROCEDURE_FAIL');
104: hr_utility.raise_error;
105: end if;
106: end if;
107:
100: p_First_Action_NOA_LA_Code2 = 'ZTA' ) and
101: p_position_occupied_code = '1' and
102: p_agency_sub_element <> 'DJ03' then
103: hr_utility.set_message(8301, 'GHR_37895_ALL_PROCEDURE_FAIL');
104: hr_utility.raise_error;
105: end if;
106: end if;
107:
108:
117: if p_effective_date >= fnd_date.canonical_to_date('2000/10/01') then
118: if (p_First_Action_NOA_LA_Code1 = 'ZVC' or
119: p_First_Action_NOA_LA_Code2 = 'ZVC' ) and
120: p_agency_sub_element NOT IN ('HSBC') then
121: hr_utility.set_message(8301, 'GHR_37926_ALL_PROCEDURE_FAIL');
122: hr_utility.raise_error;
123: end if;
124: end if;
125: -- 250.08.2
118: if (p_First_Action_NOA_LA_Code1 = 'ZVC' or
119: p_First_Action_NOA_LA_Code2 = 'ZVC' ) and
120: p_agency_sub_element NOT IN ('HSBC') then
121: hr_utility.set_message(8301, 'GHR_37926_ALL_PROCEDURE_FAIL');
122: hr_utility.raise_error;
123: end if;
124: end if;
125: -- 250.08.2
126: -- deleted legal authority M4M and nature of action 117,517,761
131: )
132: and
133: p_First_NOAC_Lookup_Code not in ('115','190','515','590','760')
134: then
135: hr_utility.set_message(8301, 'GHR_37302_ALL_PROCEDURE_FAIL');
136: hr_utility.raise_error;
137: end if;
138:
139: --250.09.2
132: and
133: p_First_NOAC_Lookup_Code not in ('115','190','515','590','760')
134: then
135: hr_utility.set_message(8301, 'GHR_37302_ALL_PROCEDURE_FAIL');
136: hr_utility.raise_error;
137: end if;
138:
139: --250.09.2
140: -- If either (first or second) Legal
150: substr(p_agency_sub_element,1,2) <> 'TR'
151: and
152: p_agency_sub_element is not null
153: then
154: hr_utility.set_message(8301, 'GHR_37418_ALL_PROCEDURE_FAIL');
155: hr_utility.raise_error;
156: end if;
157: end if;
158: --250.09.3
151: and
152: p_agency_sub_element is not null
153: then
154: hr_utility.set_message(8301, 'GHR_37418_ALL_PROCEDURE_FAIL');
155: hr_utility.raise_error;
156: end if;
157: end if;
158: --250.09.3
159: -- If either (first or second) Legal
169: substr(p_agency_sub_element,1,2) <> 'TR'
170: and
171: p_agency_sub_element is not null
172: then
173: hr_utility.set_message(8301, 'GHR_37060_ALL_PROCEDURE_FAIL');
174: hr_utility.raise_error;
175: end if;
176: end if;
177: --250.13.2
170: and
171: p_agency_sub_element is not null
172: then
173: hr_utility.set_message(8301, 'GHR_37060_ALL_PROCEDURE_FAIL');
174: hr_utility.raise_error;
175: end if;
176: end if;
177: --250.13.2
178: -- upd50 06-Feb-07 Raju From 01-Oct-2006 Bug#5745356 delete Pay plan FZ
182: ) and
183: p_to_play_plan not in ('FA','FE','FO','FP','FZ','GG') and
184: p_to_play_plan is not null
185: then
186: hr_utility.set_message(8301, 'GHR_37303_ALL_PROCEDURE_FAIL');
187: hr_utility.set_message_token('PAY_PLAN','FA, FE, FO, FP, FZ or GG');
188: hr_utility.raise_error;
189: end if;
190: else
183: p_to_play_plan not in ('FA','FE','FO','FP','FZ','GG') and
184: p_to_play_plan is not null
185: then
186: hr_utility.set_message(8301, 'GHR_37303_ALL_PROCEDURE_FAIL');
187: hr_utility.set_message_token('PAY_PLAN','FA, FE, FO, FP, FZ or GG');
188: hr_utility.raise_error;
189: end if;
190: else
191: if ( p_First_Action_NOA_LA_Code1 = 'UFM' or
184: p_to_play_plan is not null
185: then
186: hr_utility.set_message(8301, 'GHR_37303_ALL_PROCEDURE_FAIL');
187: hr_utility.set_message_token('PAY_PLAN','FA, FE, FO, FP, FZ or GG');
188: hr_utility.raise_error;
189: end if;
190: else
191: if ( p_First_Action_NOA_LA_Code1 = 'UFM' or
192: p_First_Action_NOA_LA_Code2 = 'UFM'
193: ) and
194: p_to_play_plan not in ('FA','FE','FO','FP','GG') and
195: p_to_play_plan is not null
196: then
197: hr_utility.set_message(8301, 'GHR_37303_ALL_PROCEDURE_FAIL');
198: hr_utility.set_message_token('PAY_PLAN','FA, FE, FO, FP or GG');
199: hr_utility.raise_error;
200: end if;
201: end if;
194: p_to_play_plan not in ('FA','FE','FO','FP','GG') and
195: p_to_play_plan is not null
196: then
197: hr_utility.set_message(8301, 'GHR_37303_ALL_PROCEDURE_FAIL');
198: hr_utility.set_message_token('PAY_PLAN','FA, FE, FO, FP or GG');
199: hr_utility.raise_error;
200: end if;
201: end if;
202: -- 250.16.2
195: p_to_play_plan is not null
196: then
197: hr_utility.set_message(8301, 'GHR_37303_ALL_PROCEDURE_FAIL');
198: hr_utility.set_message_token('PAY_PLAN','FA, FE, FO, FP or GG');
199: hr_utility.raise_error;
200: end if;
201: end if;
202: -- 250.16.2
203: if (
211: )
212: and
213: p_agency_sub_element not in ('AFNG','AFZG','ARNG')
214: then
215: hr_utility.set_message(8301, 'GHR_37304_ALL_PROCEDURE_FAIL');
216: hr_utility.raise_error;
217: end if;
218:
219: --Begin Bug# 5745356
212: and
213: p_agency_sub_element not in ('AFNG','AFZG','ARNG')
214: then
215: hr_utility.set_message(8301, 'GHR_37304_ALL_PROCEDURE_FAIL');
216: hr_utility.raise_error;
217: end if;
218:
219: --Begin Bug# 5745356
220: -- 250.17.2
222: if p_effective_date < fnd_date.canonical_to_date('2009/12/31') then
223: if p_effective_date >= to_date('2007/01/01','yyyy/mm/dd') then
224: if (p_First_Action_NOA_LA_Code1 = 'Z6H' or p_First_Action_NOA_LA_Code2 = 'Z6H')
225: and substr(p_agency_sub_element,1,2) not in ('AF','AR','DD','NV') then
226: hr_utility.set_message(8301, 'GHR_37000_ALL_PROCEDURE_FAIL');
227: hr_utility.raise_error;
228: end if;
229: end if;
230: end if;
223: if p_effective_date >= to_date('2007/01/01','yyyy/mm/dd') then
224: if (p_First_Action_NOA_LA_Code1 = 'Z6H' or p_First_Action_NOA_LA_Code2 = 'Z6H')
225: and substr(p_agency_sub_element,1,2) not in ('AF','AR','DD','NV') then
226: hr_utility.set_message(8301, 'GHR_37000_ALL_PROCEDURE_FAIL');
227: hr_utility.raise_error;
228: end if;
229: end if;
230: end if;
231: -- 250.18.2
233: if p_effective_date < fnd_date.canonical_to_date('2009/12/31') then
234: if p_effective_date >= to_date('2007/01/01','yyyy/mm/dd') then
235: if (p_First_Action_NOA_LA_Code1 = 'Z6J' or p_First_Action_NOA_LA_Code2 = 'Z6J')
236: and substr(p_agency_sub_element,1,2) not in ('AF','AR','DD','NV') then
237: hr_utility.set_message(8301, 'GHR_37148_ALL_PROCEDURE_FAIL');
238: hr_utility.raise_error;
239: end if;
240: end if;
241: end if;
234: if p_effective_date >= to_date('2007/01/01','yyyy/mm/dd') then
235: if (p_First_Action_NOA_LA_Code1 = 'Z6J' or p_First_Action_NOA_LA_Code2 = 'Z6J')
236: and substr(p_agency_sub_element,1,2) not in ('AF','AR','DD','NV') then
237: hr_utility.set_message(8301, 'GHR_37148_ALL_PROCEDURE_FAIL');
238: hr_utility.raise_error;
239: end if;
240: end if;
241: end if;
242: --End Bug# 5745356
248: if (p_First_Action_NOA_LA_Code1 in ('Z5Y','Z6M','Z6N') or
249: p_First_Action_NOA_LA_Code2 in ('Z5Y','Z6M','Z6N')) and
250: p_First_NOAC_Lookup_Code <> '713' and
251: substr(p_agency_sub_element,1,2) not in ('AF','AR','DD','NV') then
252: hr_utility.set_message(8301, 'GHR_38224_ALL_PROCEDURE_FAIL');
253: hr_utility.raise_error;
254: end if;
255: end if;
256: --8653515
249: p_First_Action_NOA_LA_Code2 in ('Z5Y','Z6M','Z6N')) and
250: p_First_NOAC_Lookup_Code <> '713' and
251: substr(p_agency_sub_element,1,2) not in ('AF','AR','DD','NV') then
252: hr_utility.set_message(8301, 'GHR_38224_ALL_PROCEDURE_FAIL');
253: hr_utility.raise_error;
254: end if;
255: end if;
256: --8653515
257:
268: p_First_NOAC_Lookup_Code <> '355' ) and
269: ( p_First_Action_NOA_LA_Code1 is null and
270: p_First_Action_NOA_LA_Code2 is null)
271: then
272: hr_utility.set_message(8301, 'GHR_37305_ALL_PROCEDURE_FAIL');
273: hr_utility.raise_error;
274: end if;
275: elsif p_effective_date < to_date('2007/01/01','yyyy/mm/dd') then
276: if p_First_NOAC_Lookup_Code not in ('350','355','817','840','841','842','843',
269: ( p_First_Action_NOA_LA_Code1 is null and
270: p_First_Action_NOA_LA_Code2 is null)
271: then
272: hr_utility.set_message(8301, 'GHR_37305_ALL_PROCEDURE_FAIL');
273: hr_utility.raise_error;
274: end if;
275: elsif p_effective_date < to_date('2007/01/01','yyyy/mm/dd') then
276: if p_First_NOAC_Lookup_Code not in ('350','355','817','840','841','842','843',
277: '844','845','846','847','848','887','889','930','931','932','993') and
277: '844','845','846','847','848','887','889','930','931','932','993') and
278: ( p_First_Action_NOA_LA_Code1 is null and
279: p_First_Action_NOA_LA_Code2 is null)
280: then
281: hr_utility.set_message(8301, 'GHR_37419_ALL_PROCEDURE_FAIL');
282: hr_utility.raise_error;
283: end if;
284: else
285: if p_First_NOAC_Lookup_Code not in ('350','355','817','840','841','842','843',
278: ( p_First_Action_NOA_LA_Code1 is null and
279: p_First_Action_NOA_LA_Code2 is null)
280: then
281: hr_utility.set_message(8301, 'GHR_37419_ALL_PROCEDURE_FAIL');
282: hr_utility.raise_error;
283: end if;
284: else
285: if p_First_NOAC_Lookup_Code not in ('350','355','817','840','841','842','843',
286: '844','845','846','847','848','849','886','887','889','930','931','932','993') and
287: ( p_First_Action_NOA_LA_Code1 is null and
288: p_First_Action_NOA_LA_Code2 is null)
289: then
290: --Bug# 6959477 message number 38591 is duplicated, so created new message with #38157
291: hr_utility.set_message(8301, 'GHR_38157_ALL_PROCEDURE_FAIL');
292: hr_utility.raise_error;
293: end if;
294: end if;
295:
288: p_First_Action_NOA_LA_Code2 is null)
289: then
290: --Bug# 6959477 message number 38591 is duplicated, so created new message with #38157
291: hr_utility.set_message(8301, 'GHR_38157_ALL_PROCEDURE_FAIL');
292: hr_utility.raise_error;
293: end if;
294: end if;
295:
296: --250.20.2
305: p_to_play_plan <> 'ES'
306: and
307: p_to_play_plan is not null
308: then
309: hr_utility.set_message(8301, 'GHR_37306_ALL_PROCEDURE_FAIL');
310: hr_utility.raise_error;
311: end if;
312:
313: --250.25.2
306: and
307: p_to_play_plan is not null
308: then
309: hr_utility.set_message(8301, 'GHR_37306_ALL_PROCEDURE_FAIL');
310: hr_utility.raise_error;
311: end if;
312:
313: --250.25.2
314: -- deleted nature of action 117,517
319: )
320: and
321: p_First_NOAC_Lookup_Code not in ('171','571')
322: then
323: hr_utility.set_message(8301, 'GHR_37307_ALL_PROCEDURE_FAIL');
324: hr_utility.raise_error;
325: end if;
326:
327: --250.30.2
320: and
321: p_First_NOAC_Lookup_Code not in ('171','571')
322: then
323: hr_utility.set_message(8301, 'GHR_37307_ALL_PROCEDURE_FAIL');
324: hr_utility.raise_error;
325: end if;
326:
327: --250.30.2
328: if (
332: )
333: and
334: p_First_NOAC_Lookup_Code <>'CM57'
335: then
336: hr_utility.set_message(8301, 'GHR_37308_ALL_PROCEDURE_FAIL');
337: hr_utility.raise_error;
338: end if;
339:
340: --250.35.2
333: and
334: p_First_NOAC_Lookup_Code <>'CM57'
335: then
336: hr_utility.set_message(8301, 'GHR_37308_ALL_PROCEDURE_FAIL');
337: hr_utility.raise_error;
338: end if;
339:
340: --250.35.2
341: if (
353: and
354: p_agency_sub_element <> 'AG11'
355: )
356: then
357: hr_utility.set_message(8301, 'GHR_37309_ALL_PROCEDURE_FAIL');
358: hr_utility.raise_error;
359: end if;
360:
361: --250.38.2
354: p_agency_sub_element <> 'AG11'
355: )
356: then
357: hr_utility.set_message(8301, 'GHR_37309_ALL_PROCEDURE_FAIL');
358: hr_utility.raise_error;
359: end if;
360:
361: --250.38.2
362: if (
366: )
367: and
368: substr(p_agency_sub_element,1,2) <> 'VA'
369: then
370: hr_utility.set_message(8301, 'GHR_37310_ALL_PROCEDURE_FAIL');
371: hr_utility.raise_error;
372: end if;
373:
374: --250.39.2
367: and
368: substr(p_agency_sub_element,1,2) <> 'VA'
369: then
370: hr_utility.set_message(8301, 'GHR_37310_ALL_PROCEDURE_FAIL');
371: hr_utility.raise_error;
372: end if;
373:
374: --250.39.2
375: -- Update Date By Effective Date Comment
383: )
384: and
385: p_agency_sub_element <> 'TR93'
386: then
387: hr_utility.set_message(8301, 'GHR_37420_ALL_PROCEDURE_FAIL');
388: hr_utility.raise_error;
389: end if;
390: end if;
391:
384: and
385: p_agency_sub_element <> 'TR93'
386: then
387: hr_utility.set_message(8301, 'GHR_37420_ALL_PROCEDURE_FAIL');
388: hr_utility.raise_error;
389: end if;
390: end if;
391:
392: -- START OF 255.02.2
442: 'QBK','QCK','UDM','VGL','VJM','V1P','V8L','V8N','Z2U','Z2W','ZGM',
443: 'ZBA','ZJK','ZJM','ZJR','ZLM','ZQM','ZRM','ZSK','ZSP','ZTU','Z5B','Z5C','ZEA')
444: )
445: then
446: hr_utility.set_message(8301, 'GHR_37191_ALL_PROCEDURE_FAIL');
447: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ACA, ACM, ALM, AQM, AYM, A2M, BAB, BAC, BAD, BAE, BAG,
448: BYO, BBM, BDN, BKM, BLM, BNK, BNM, BNN, BNR, BNY, BNZ, BWA, BWM, BYM, HAM, K1M, K4M, K7M, K8M, K9M, LAE, LAK, LAM
449: LEM, LHM, LJM, LKM, LKP, LYP, L3M, PWM, P3M, P5M, P7M, QAK, QBK, QCK, UDM, VJM, V1P, V8L, V8N, VGL, Z2U, Z2W, ZBA, ZEA,
450: ZGM, ZJK, ZJM, ZJR, ZLM, ZQM, ZRM, ZSK, ZSP, ZTU, Z5B, Z5C.');
443: 'ZBA','ZJK','ZJM','ZJR','ZLM','ZQM','ZRM','ZSK','ZSP','ZTU','Z5B','Z5C','ZEA')
444: )
445: then
446: hr_utility.set_message(8301, 'GHR_37191_ALL_PROCEDURE_FAIL');
447: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ACA, ACM, ALM, AQM, AYM, A2M, BAB, BAC, BAD, BAE, BAG,
448: BYO, BBM, BDN, BKM, BLM, BNK, BNM, BNN, BNR, BNY, BNZ, BWA, BWM, BYM, HAM, K1M, K4M, K7M, K8M, K9M, LAE, LAK, LAM
449: LEM, LHM, LJM, LKM, LKP, LYP, L3M, PWM, P3M, P5M, P7M, QAK, QBK, QCK, UDM, VJM, V1P, V8L, V8N, VGL, Z2U, Z2W, ZBA, ZEA,
450: ZGM, ZJK, ZJM, ZJR, ZLM, ZQM, ZRM, ZSK, ZSP, ZTU, Z5B, Z5C.');
451: hr_utility.raise_error;
447: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ACA, ACM, ALM, AQM, AYM, A2M, BAB, BAC, BAD, BAE, BAG,
448: BYO, BBM, BDN, BKM, BLM, BNK, BNM, BNN, BNR, BNY, BNZ, BWA, BWM, BYM, HAM, K1M, K4M, K7M, K8M, K9M, LAE, LAK, LAM
449: LEM, LHM, LJM, LKM, LKP, LYP, L3M, PWM, P3M, P5M, P7M, QAK, QBK, QCK, UDM, VJM, V1P, V8L, V8N, VGL, Z2U, Z2W, ZBA, ZEA,
450: ZGM, ZJK, ZJM, ZJR, ZLM, ZQM, ZRM, ZSK, ZSP, ZTU, Z5B, Z5C.');
451: hr_utility.raise_error;
452: end if;
453: --BUG # 14395108
454: elsif p_effective_date >= to_date('2009/02/17','yyyy/mm/dd') then
455: if p_First_NOAC_Lookup_Code= '100'
477: 'QBK','QCK','UDM','VGL','VJM','V1P','V8L','V8N','Z2U','Z2W','ZGM',
478: 'ZBA','ZJK','ZJM','ZJR','ZLM','ZQM','ZRM','ZSK','ZSP','ZTU','Z5B','Z5C','ZEA')
479: )
480: then
481: hr_utility.set_message(8301, 'GHR_37191_ALL_PROCEDURE_FAIL');
482: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ACA, ACM, ALM, AQM, AYM, A2M,BAB,BAC,BAD, BAE, BAG,
483: BYO, BBM, BDN, BKM, BLM, BNK, BNM, BNN, BNR, BNY, BNZ, BWA, BWM, BYM, HAM, K1M, K4M, K7M, K8M, K9M, LEM,
484: LHM, LJM, LKM, LKP, LYP, L3M, PWM, P3M, P5M, P7M, QAK, QBK, QCK, UDM, VJM, V1P, V8L, V8N, VGL, Z2U, Z2W,
485: ZBA, ZEA, ZGM, ZJK, ZJM, ZJR, ZLM, ZQM, ZRM, ZSK, ZSP, ZTU, Z5B, Z5C.');
478: 'ZBA','ZJK','ZJM','ZJR','ZLM','ZQM','ZRM','ZSK','ZSP','ZTU','Z5B','Z5C','ZEA')
479: )
480: then
481: hr_utility.set_message(8301, 'GHR_37191_ALL_PROCEDURE_FAIL');
482: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ACA, ACM, ALM, AQM, AYM, A2M,BAB,BAC,BAD, BAE, BAG,
483: BYO, BBM, BDN, BKM, BLM, BNK, BNM, BNN, BNR, BNY, BNZ, BWA, BWM, BYM, HAM, K1M, K4M, K7M, K8M, K9M, LEM,
484: LHM, LJM, LKM, LKP, LYP, L3M, PWM, P3M, P5M, P7M, QAK, QBK, QCK, UDM, VJM, V1P, V8L, V8N, VGL, Z2U, Z2W,
485: ZBA, ZEA, ZGM, ZJK, ZJM, ZJR, ZLM, ZQM, ZRM, ZSK, ZSP, ZTU, Z5B, Z5C.');
486: hr_utility.raise_error;
482: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ACA, ACM, ALM, AQM, AYM, A2M,BAB,BAC,BAD, BAE, BAG,
483: BYO, BBM, BDN, BKM, BLM, BNK, BNM, BNN, BNR, BNY, BNZ, BWA, BWM, BYM, HAM, K1M, K4M, K7M, K8M, K9M, LEM,
484: LHM, LJM, LKM, LKP, LYP, L3M, PWM, P3M, P5M, P7M, QAK, QBK, QCK, UDM, VJM, V1P, V8L, V8N, VGL, Z2U, Z2W,
485: ZBA, ZEA, ZGM, ZJK, ZJM, ZJR, ZLM, ZQM, ZRM, ZSK, ZSP, ZTU, Z5B, Z5C.');
486: hr_utility.raise_error;
487: end if;
488: elsif p_effective_date >= to_date('2009/01/01','yyyy/mm/dd') then
489: if p_First_NOAC_Lookup_Code= '100'
490: and
511: 'QBK','QCK','UDM','VGL','VJM','V1P','V8L','V8N','Z2U','Z2W','ZGM',
512: 'ZBA','ZJK','ZJM','ZJR','ZLM','ZQM','ZRM','ZSK','ZSP','ZTU','Z5B','Z5C')
513: )
514: then
515: hr_utility.set_message(8301, 'GHR_37191_ALL_PROCEDURE_FAIL');
516: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ACA, ACM, ALM, AQM, AYM, A2M,BAB,BAC,BAD, BAE, BAG,
517: BYO, BBM, BDN, BKM, BLM, BNK, BNM, BNN, BNR, BNY, BNZ, BWA, BWM, BYM, HAM, K1M, K4M, K7M, K8M, K9M, LEM,
518: LHM, LJM, LKM, LKP, LYP, L3M, PWM, P3M, P5M, P7M, QAK, QBK, QCK, UDM, VJM, V1P, V8L, V8N, VGL, Z2U, Z2W,
519: ZBA, ZGM, ZJK, ZJM, ZJR, ZLM, ZQM, ZRM, ZSK, ZSP, ZTU, Z5B, Z5C.');
512: 'ZBA','ZJK','ZJM','ZJR','ZLM','ZQM','ZRM','ZSK','ZSP','ZTU','Z5B','Z5C')
513: )
514: then
515: hr_utility.set_message(8301, 'GHR_37191_ALL_PROCEDURE_FAIL');
516: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ACA, ACM, ALM, AQM, AYM, A2M,BAB,BAC,BAD, BAE, BAG,
517: BYO, BBM, BDN, BKM, BLM, BNK, BNM, BNN, BNR, BNY, BNZ, BWA, BWM, BYM, HAM, K1M, K4M, K7M, K8M, K9M, LEM,
518: LHM, LJM, LKM, LKP, LYP, L3M, PWM, P3M, P5M, P7M, QAK, QBK, QCK, UDM, VJM, V1P, V8L, V8N, VGL, Z2U, Z2W,
519: ZBA, ZGM, ZJK, ZJM, ZJR, ZLM, ZQM, ZRM, ZSK, ZSP, ZTU, Z5B, Z5C.');
520: hr_utility.raise_error;
516: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ACA, ACM, ALM, AQM, AYM, A2M,BAB,BAC,BAD, BAE, BAG,
517: BYO, BBM, BDN, BKM, BLM, BNK, BNM, BNN, BNR, BNY, BNZ, BWA, BWM, BYM, HAM, K1M, K4M, K7M, K8M, K9M, LEM,
518: LHM, LJM, LKM, LKP, LYP, L3M, PWM, P3M, P5M, P7M, QAK, QBK, QCK, UDM, VJM, V1P, V8L, V8N, VGL, Z2U, Z2W,
519: ZBA, ZGM, ZJK, ZJM, ZJR, ZLM, ZQM, ZRM, ZSK, ZSP, ZTU, Z5B, Z5C.');
520: hr_utility.raise_error;
521: end if;
522: elsif p_effective_date >= to_date('19'||'99/12/01','yyyy/mm/dd') then
523: if p_First_NOAC_Lookup_Code= '100'
524: and
545: 'QBK','QCK','UDM','VGL','VJM','V1P','V8L','V8N','Z2U','Z2W','ZGM',
546: 'ZBA','ZJK','ZJM','ZJR','ZLM','ZQM','ZRM','ZSK','ZSP','ZTU','Z5B','Z5C')
547: )
548: then
549: hr_utility.set_message(8301, 'GHR_37191_ALL_PROCEDURE_FAIL');
550: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ACA, ACM, ALM, AQM, AYM, A2M,BAB,BAC,BAD, BAE, BYO,
551: BBM, BDN, BKM, BLM, BNK, BNM, BNN, BNR, BNY, BNZ, BWA, BWM, BYM, HAM, K1M, K4M, K7M, K8M, K9M, LEM, LHM,
552: LJM, LKM, LKP, LYP, L3M, PWM, P3M, P5M, P7M, QAK, QBK, QCK, UDM, VJM, V1P, V8L, V8N, VGL, Z2U, Z2W, ZBA,
553: ZGM, ZJK, ZJM, ZJR, ZLM, ZQM, ZRM, ZSK, ZSP, ZTU, Z5B, Z5C.');
546: 'ZBA','ZJK','ZJM','ZJR','ZLM','ZQM','ZRM','ZSK','ZSP','ZTU','Z5B','Z5C')
547: )
548: then
549: hr_utility.set_message(8301, 'GHR_37191_ALL_PROCEDURE_FAIL');
550: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ACA, ACM, ALM, AQM, AYM, A2M,BAB,BAC,BAD, BAE, BYO,
551: BBM, BDN, BKM, BLM, BNK, BNM, BNN, BNR, BNY, BNZ, BWA, BWM, BYM, HAM, K1M, K4M, K7M, K8M, K9M, LEM, LHM,
552: LJM, LKM, LKP, LYP, L3M, PWM, P3M, P5M, P7M, QAK, QBK, QCK, UDM, VJM, V1P, V8L, V8N, VGL, Z2U, Z2W, ZBA,
553: ZGM, ZJK, ZJM, ZJR, ZLM, ZQM, ZRM, ZSK, ZSP, ZTU, Z5B, Z5C.');
554: hr_utility.raise_error;
550: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ACA, ACM, ALM, AQM, AYM, A2M,BAB,BAC,BAD, BAE, BYO,
551: BBM, BDN, BKM, BLM, BNK, BNM, BNN, BNR, BNY, BNZ, BWA, BWM, BYM, HAM, K1M, K4M, K7M, K8M, K9M, LEM, LHM,
552: LJM, LKM, LKP, LYP, L3M, PWM, P3M, P5M, P7M, QAK, QBK, QCK, UDM, VJM, V1P, V8L, V8N, VGL, Z2U, Z2W, ZBA,
553: ZGM, ZJK, ZJM, ZJR, ZLM, ZQM, ZRM, ZSK, ZSP, ZTU, Z5B, Z5C.');
554: hr_utility.raise_error;
555: end if;
556: elsif p_effective_date >= to_date('19'||'99/11/01','yyyy/mm/dd') then
557: if p_First_NOAC_Lookup_Code= '100'
558: and
579: 'QBK','QCK','UDM','VGL','VJM','V1P','V8L','V8N','Z2U','Z2W','ZGM',
580: 'ZBA','ZJK','ZJM','ZJR','ZLM','ZQM','ZRM','ZSK','ZSP','ZTU','Z5B','Z5C')
581: )
582: then
583: hr_utility.set_message(8301, 'GHR_37190_ALL_PROCEDURE_FAIL');
584: hr_utility.raise_error;
585: end if;
586: elsif p_effective_date > to_date('19'||'99/01/31','yyyy/mm/dd') then
587: if p_First_NOAC_Lookup_Code= '100'
580: 'ZBA','ZJK','ZJM','ZJR','ZLM','ZQM','ZRM','ZSK','ZSP','ZTU','Z5B','Z5C')
581: )
582: then
583: hr_utility.set_message(8301, 'GHR_37190_ALL_PROCEDURE_FAIL');
584: hr_utility.raise_error;
585: end if;
586: elsif p_effective_date > to_date('19'||'99/01/31','yyyy/mm/dd') then
587: if p_First_NOAC_Lookup_Code= '100'
588: and
609: 'QBK','QCK','VGL','VJM','V1P','V8L','V8N','Z2U','Z2W','ZGM',
610: 'ZBA','ZJK','ZJM','ZJR','ZLM','ZQM','ZRM','ZSK','ZSP','ZTU','Z5B','Z5C')
611: )
612: then
613: hr_utility.set_message(8301, 'GHR_37039_ALL_PROCEDURE_FAIL');
614: hr_utility.raise_error;
615: end if;
616: elsif p_effective_date >= to_date('19'||'99/01/01','yyyy/mm/dd') then
617: if p_First_NOAC_Lookup_Code= '100'
610: 'ZBA','ZJK','ZJM','ZJR','ZLM','ZQM','ZRM','ZSK','ZSP','ZTU','Z5B','Z5C')
611: )
612: then
613: hr_utility.set_message(8301, 'GHR_37039_ALL_PROCEDURE_FAIL');
614: hr_utility.raise_error;
615: end if;
616: elsif p_effective_date >= to_date('19'||'99/01/01','yyyy/mm/dd') then
617: if p_First_NOAC_Lookup_Code= '100'
618: and
639: 'QBK','QCK','VGL','VJM','V1P','V8L','V8N','Z2U','Z2W','ZGM',
640: 'ZBA','ZJK','ZJM','ZJR','ZLM','ZQM','ZRM','ZSK','ZSP','ZTU','Z5B','Z5C')
641: )
642: then
643: hr_utility.set_message(8301, 'GHR_37085_ALL_PROCEDURE_FAIL');
644: hr_utility.raise_error;
645: end if;
646: else
647: if p_First_NOAC_Lookup_Code= '100'
640: 'ZBA','ZJK','ZJM','ZJR','ZLM','ZQM','ZRM','ZSK','ZSP','ZTU','Z5B','Z5C')
641: )
642: then
643: hr_utility.set_message(8301, 'GHR_37085_ALL_PROCEDURE_FAIL');
644: hr_utility.raise_error;
645: end if;
646: else
647: if p_First_NOAC_Lookup_Code= '100'
648: and
669: 'QBK','QCK','VJM','V1P','V8L','V8N','Z2U','Z2W','ZGM',
670: 'ZBA','ZJK','ZJM','ZJR','ZLM','ZQM','ZRM','ZSK','ZSP','ZTU','Z5B','Z5C')
671: )
672: then
673: hr_utility.set_message(8301, 'GHR_37311_ALL_PROCEDURE_FAIL');
674: hr_utility.raise_error;
675: end if;
676: end if;
677: -- END IF 255.02.2
670: 'ZBA','ZJK','ZJM','ZJR','ZLM','ZQM','ZRM','ZSK','ZSP','ZTU','Z5B','Z5C')
671: )
672: then
673: hr_utility.set_message(8301, 'GHR_37311_ALL_PROCEDURE_FAIL');
674: hr_utility.raise_error;
675: end if;
676: end if;
677: -- END IF 255.02.2
678: --
728: 'ZBA','ZGM','ZJK','ZJM',
729: 'ZJR','ZLM','ZQM','ZRM','ZSK','ZSP','ZTU','ZEA','Z5B','Z5C')
730: )
731: then
732: hr_utility.set_message(8301, 'GHR_37193_ALL_PROCEDURE_FAIL');
733: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ACA, ACM, ALM, AQM, AYM, A2M, BAB, BAC, BAD, BAE, BAG,
734: BYO, BBM, BDN, BKM, BLM, BNK, BNM, BNN, BNR, BNY, BWA, BWM, BYM, HAM, K1M, K4M, K7M, K8M, K9M, LAE, LAK, LAM, LEM, LHM,
735: LJM, LKM, LKP, LYP, L3M, PWM, P3M, P5M, P7M, QAK, QBK, QCK, UDM, V1P, V8L, V8N, VGL, Z2U, Z2W, ZBA, ZEA, ZGM, ZJK, ZJM,
736: ZJR, ZLM, ZQM, ZRM, ZSK, ZSP, ZTU, Z5B, Z5C.');
729: 'ZJR','ZLM','ZQM','ZRM','ZSK','ZSP','ZTU','ZEA','Z5B','Z5C')
730: )
731: then
732: hr_utility.set_message(8301, 'GHR_37193_ALL_PROCEDURE_FAIL');
733: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ACA, ACM, ALM, AQM, AYM, A2M, BAB, BAC, BAD, BAE, BAG,
734: BYO, BBM, BDN, BKM, BLM, BNK, BNM, BNN, BNR, BNY, BWA, BWM, BYM, HAM, K1M, K4M, K7M, K8M, K9M, LAE, LAK, LAM, LEM, LHM,
735: LJM, LKM, LKP, LYP, L3M, PWM, P3M, P5M, P7M, QAK, QBK, QCK, UDM, V1P, V8L, V8N, VGL, Z2U, Z2W, ZBA, ZEA, ZGM, ZJK, ZJM,
736: ZJR, ZLM, ZQM, ZRM, ZSK, ZSP, ZTU, Z5B, Z5C.');
737: hr_utility.raise_error;
733: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ACA, ACM, ALM, AQM, AYM, A2M, BAB, BAC, BAD, BAE, BAG,
734: BYO, BBM, BDN, BKM, BLM, BNK, BNM, BNN, BNR, BNY, BWA, BWM, BYM, HAM, K1M, K4M, K7M, K8M, K9M, LAE, LAK, LAM, LEM, LHM,
735: LJM, LKM, LKP, LYP, L3M, PWM, P3M, P5M, P7M, QAK, QBK, QCK, UDM, V1P, V8L, V8N, VGL, Z2U, Z2W, ZBA, ZEA, ZGM, ZJK, ZJM,
736: ZJR, ZLM, ZQM, ZRM, ZSK, ZSP, ZTU, Z5B, Z5C.');
737: hr_utility.raise_error;
738: end if;
739: --BUG # 14395108
740: --End Bug# 8799026
741: --Begin Bug# 8799026
767: 'ZBA','ZGM','ZJK','ZJM',
768: 'ZJR','ZLM','ZQM','ZRM','ZSK','ZSP','ZTU','ZEA','Z5B','Z5C')
769: )
770: then
771: hr_utility.set_message(8301, 'GHR_37193_ALL_PROCEDURE_FAIL');
772: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ACA, ACM, ALM, AQM, AYM, A2M, BAB,BAC,BAD, BAE, BAG,
773: BYO,BBM, BDN, BKM, BLM, BNK, BNM, BNN, BNR, BNY, BWA, BWM, BYM, HAM, K1M, K4M, K7M, K8M, K9M, LAM, LEM, LHM, LJM,
774: LKM, LKP, LYP, L3M, PWM, P3M, P5M, P7M, QAK, QBK, QCK, UDM, V1P, V8L, V8N, VGL, Z2U, Z2W, ZBA, ZEA, ZGM,
775: ZJK, ZJM, ZJR, ZLM, ZQM, ZRM, ZSK, ZSP, ZTU, Z5B, Z5C.');
768: 'ZJR','ZLM','ZQM','ZRM','ZSK','ZSP','ZTU','ZEA','Z5B','Z5C')
769: )
770: then
771: hr_utility.set_message(8301, 'GHR_37193_ALL_PROCEDURE_FAIL');
772: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ACA, ACM, ALM, AQM, AYM, A2M, BAB,BAC,BAD, BAE, BAG,
773: BYO,BBM, BDN, BKM, BLM, BNK, BNM, BNN, BNR, BNY, BWA, BWM, BYM, HAM, K1M, K4M, K7M, K8M, K9M, LAM, LEM, LHM, LJM,
774: LKM, LKP, LYP, L3M, PWM, P3M, P5M, P7M, QAK, QBK, QCK, UDM, V1P, V8L, V8N, VGL, Z2U, Z2W, ZBA, ZEA, ZGM,
775: ZJK, ZJM, ZJR, ZLM, ZQM, ZRM, ZSK, ZSP, ZTU, Z5B, Z5C.');
776: hr_utility.raise_error;
772: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ACA, ACM, ALM, AQM, AYM, A2M, BAB,BAC,BAD, BAE, BAG,
773: BYO,BBM, BDN, BKM, BLM, BNK, BNM, BNN, BNR, BNY, BWA, BWM, BYM, HAM, K1M, K4M, K7M, K8M, K9M, LAM, LEM, LHM, LJM,
774: LKM, LKP, LYP, L3M, PWM, P3M, P5M, P7M, QAK, QBK, QCK, UDM, V1P, V8L, V8N, VGL, Z2U, Z2W, ZBA, ZEA, ZGM,
775: ZJK, ZJM, ZJR, ZLM, ZQM, ZRM, ZSK, ZSP, ZTU, Z5B, Z5C.');
776: hr_utility.raise_error;
777: end if;
778: --End Bug# 8799026
779: elsif p_effective_date >= to_date('2009/02/17','yyyy/mm/dd') then
780: if p_First_NOAC_Lookup_Code= '101'
804: 'ZBA','ZGM','ZJK','ZJM',
805: 'ZJR','ZLM','ZQM','ZRM','ZSK','ZSP','ZTU','ZEA','Z5B','Z5C')
806: )
807: then
808: hr_utility.set_message(8301, 'GHR_37193_ALL_PROCEDURE_FAIL');
809: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ACA, ACM, ALM, AQM, AYM, A2M, BAB,BAC,BAD, BAE, BAG,
810: BYO,BBM, BDN, BKM, BLM, BNK, BNM, BNN, BNR, BNY, BWA, BWM, BYM, HAM, K1M, K4M, K7M, K8M, K9M, LEM, LHM, LJM,
811: LKM, LKP, LYP, L3M, PWM, P3M, P5M, P7M, QAK, QBK, QCK, UDM, V1P, V8L, V8N, VGL, Z2U, Z2W, ZBA, ZEA, ZGM,
812: ZJK, ZJM, ZJR, ZLM, ZQM, ZRM, ZSK, ZSP, ZTU, Z5B, Z5C.');
805: 'ZJR','ZLM','ZQM','ZRM','ZSK','ZSP','ZTU','ZEA','Z5B','Z5C')
806: )
807: then
808: hr_utility.set_message(8301, 'GHR_37193_ALL_PROCEDURE_FAIL');
809: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ACA, ACM, ALM, AQM, AYM, A2M, BAB,BAC,BAD, BAE, BAG,
810: BYO,BBM, BDN, BKM, BLM, BNK, BNM, BNN, BNR, BNY, BWA, BWM, BYM, HAM, K1M, K4M, K7M, K8M, K9M, LEM, LHM, LJM,
811: LKM, LKP, LYP, L3M, PWM, P3M, P5M, P7M, QAK, QBK, QCK, UDM, V1P, V8L, V8N, VGL, Z2U, Z2W, ZBA, ZEA, ZGM,
812: ZJK, ZJM, ZJR, ZLM, ZQM, ZRM, ZSK, ZSP, ZTU, Z5B, Z5C.');
813: hr_utility.raise_error;
809: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ACA, ACM, ALM, AQM, AYM, A2M, BAB,BAC,BAD, BAE, BAG,
810: BYO,BBM, BDN, BKM, BLM, BNK, BNM, BNN, BNR, BNY, BWA, BWM, BYM, HAM, K1M, K4M, K7M, K8M, K9M, LEM, LHM, LJM,
811: LKM, LKP, LYP, L3M, PWM, P3M, P5M, P7M, QAK, QBK, QCK, UDM, V1P, V8L, V8N, VGL, Z2U, Z2W, ZBA, ZEA, ZGM,
812: ZJK, ZJM, ZJR, ZLM, ZQM, ZRM, ZSK, ZSP, ZTU, Z5B, Z5C.');
813: hr_utility.raise_error;
814: end if;
815: elsif p_effective_date >= to_date('2009/01/01','yyyy/mm/dd') then
816: if p_First_NOAC_Lookup_Code= '101'
817: and
840: 'ZBA','ZGM','ZJK','ZJM',
841: 'ZJR','ZLM','ZQM','ZRM','ZSK','ZSP','ZTU','Z5B','Z5C')
842: )
843: then
844: hr_utility.set_message(8301, 'GHR_37193_ALL_PROCEDURE_FAIL');
845: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ACA, ACM, ALM, AQM, AYM, A2M, BAB,BAC,BAD, BAE, BAG,
846: BYO,BBM, BDN, BKM, BLM, BNK, BNM, BNN, BNR, BNY, BWA, BWM, BYM, HAM, K1M, K4M, K7M, K8M, K9M, LEM, LHM, LJM,
847: LKM, LKP, LYP, L3M, PWM, P3M, P5M, P7M, QAK, QBK, QCK, UDM, V1P, V8L, V8N, VGL, Z2U, Z2W, ZBA, ZGM, ZJK,
848: ZJM, ZJR, ZLM, ZQM, ZRM, ZSK, ZSP, ZTU, Z5B, Z5C.');
841: 'ZJR','ZLM','ZQM','ZRM','ZSK','ZSP','ZTU','Z5B','Z5C')
842: )
843: then
844: hr_utility.set_message(8301, 'GHR_37193_ALL_PROCEDURE_FAIL');
845: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ACA, ACM, ALM, AQM, AYM, A2M, BAB,BAC,BAD, BAE, BAG,
846: BYO,BBM, BDN, BKM, BLM, BNK, BNM, BNN, BNR, BNY, BWA, BWM, BYM, HAM, K1M, K4M, K7M, K8M, K9M, LEM, LHM, LJM,
847: LKM, LKP, LYP, L3M, PWM, P3M, P5M, P7M, QAK, QBK, QCK, UDM, V1P, V8L, V8N, VGL, Z2U, Z2W, ZBA, ZGM, ZJK,
848: ZJM, ZJR, ZLM, ZQM, ZRM, ZSK, ZSP, ZTU, Z5B, Z5C.');
849: hr_utility.raise_error;
845: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ACA, ACM, ALM, AQM, AYM, A2M, BAB,BAC,BAD, BAE, BAG,
846: BYO,BBM, BDN, BKM, BLM, BNK, BNM, BNN, BNR, BNY, BWA, BWM, BYM, HAM, K1M, K4M, K7M, K8M, K9M, LEM, LHM, LJM,
847: LKM, LKP, LYP, L3M, PWM, P3M, P5M, P7M, QAK, QBK, QCK, UDM, V1P, V8L, V8N, VGL, Z2U, Z2W, ZBA, ZGM, ZJK,
848: ZJM, ZJR, ZLM, ZQM, ZRM, ZSK, ZSP, ZTU, Z5B, Z5C.');
849: hr_utility.raise_error;
850: end if;
851: elsif p_effective_date >= to_date('19'||'99/12/01','yyyy/mm/dd') then
852: if p_First_NOAC_Lookup_Code= '101'
853: and
876: 'ZBA','ZGM','ZJK','ZJM',
877: 'ZJR','ZLM','ZQM','ZRM','ZSK','ZSP','ZTU','Z5B','Z5C')
878: )
879: then
880: hr_utility.set_message(8301, 'GHR_37193_ALL_PROCEDURE_FAIL');
881: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ACA, ACM, ALM, AQM, AYM, A2M, BAB,BAC,BAD, BAE,
882: BYO,BBM, BDN, BKM, BLM, BNK, BNM, BNN, BNR, BNY, BWA, BWM, BYM, HAM, K1M, K4M, K7M, K8M, K9M, LEM, LHM, LJM,
883: LKM, LKP, LYP, L3M, PWM, P3M, P5M, P7M, QAK, QBK, QCK, UDM, V1P, V8L, V8N, VGL, Z2U, Z2W, ZBA, ZGM, ZJK,
884: ZJM, ZJR, ZLM, ZQM, ZRM, ZSK, ZSP, ZTU, Z5B, Z5C.');
877: 'ZJR','ZLM','ZQM','ZRM','ZSK','ZSP','ZTU','Z5B','Z5C')
878: )
879: then
880: hr_utility.set_message(8301, 'GHR_37193_ALL_PROCEDURE_FAIL');
881: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ACA, ACM, ALM, AQM, AYM, A2M, BAB,BAC,BAD, BAE,
882: BYO,BBM, BDN, BKM, BLM, BNK, BNM, BNN, BNR, BNY, BWA, BWM, BYM, HAM, K1M, K4M, K7M, K8M, K9M, LEM, LHM, LJM,
883: LKM, LKP, LYP, L3M, PWM, P3M, P5M, P7M, QAK, QBK, QCK, UDM, V1P, V8L, V8N, VGL, Z2U, Z2W, ZBA, ZGM, ZJK,
884: ZJM, ZJR, ZLM, ZQM, ZRM, ZSK, ZSP, ZTU, Z5B, Z5C.');
885: hr_utility.raise_error;
881: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ACA, ACM, ALM, AQM, AYM, A2M, BAB,BAC,BAD, BAE,
882: BYO,BBM, BDN, BKM, BLM, BNK, BNM, BNN, BNR, BNY, BWA, BWM, BYM, HAM, K1M, K4M, K7M, K8M, K9M, LEM, LHM, LJM,
883: LKM, LKP, LYP, L3M, PWM, P3M, P5M, P7M, QAK, QBK, QCK, UDM, V1P, V8L, V8N, VGL, Z2U, Z2W, ZBA, ZGM, ZJK,
884: ZJM, ZJR, ZLM, ZQM, ZRM, ZSK, ZSP, ZTU, Z5B, Z5C.');
885: hr_utility.raise_error;
886: end if;
887: elsif p_effective_date >= to_date('19'||'99/11/01','yyyy/mm/dd') then
888: if p_First_NOAC_Lookup_Code= '101'
889: and
912: 'ZBA','ZGM','ZJK','ZJM',
913: 'ZJR','ZLM','ZQM','ZRM','ZSK','ZSP','ZTU','Z5B','Z5C')
914: )
915: then
916: hr_utility.set_message(8301, 'GHR_37192_ALL_PROCEDURE_FAIL');
917: hr_utility.raise_error;
918: end if;
919: elsif p_effective_date > to_date('19'||'99/01/31','yyyy/mm/dd') then
920: if p_First_NOAC_Lookup_Code= '101'
913: 'ZJR','ZLM','ZQM','ZRM','ZSK','ZSP','ZTU','Z5B','Z5C')
914: )
915: then
916: hr_utility.set_message(8301, 'GHR_37192_ALL_PROCEDURE_FAIL');
917: hr_utility.raise_error;
918: end if;
919: elsif p_effective_date > to_date('19'||'99/01/31','yyyy/mm/dd') then
920: if p_First_NOAC_Lookup_Code= '101'
921: and
942: 'QBK','QCK','VGL','V1P','V8L','V8N','Z2U','Z2W','ZGM','ZJK','ZJM',
943: 'ZBA','ZJR','ZLM','ZQM','ZRM','ZSK','ZSP','ZTU','Z5B','Z5C')
944: )
945: then
946: hr_utility.set_message(8301, 'GHR_37040_ALL_PROCEDURE_FAIL');
947: hr_utility.raise_error;
948: end if;
949: elsif p_effective_date >= to_date('19'||'99/01/01','yyyy/mm/dd') then
950: if p_First_NOAC_Lookup_Code= '101'
943: 'ZBA','ZJR','ZLM','ZQM','ZRM','ZSK','ZSP','ZTU','Z5B','Z5C')
944: )
945: then
946: hr_utility.set_message(8301, 'GHR_37040_ALL_PROCEDURE_FAIL');
947: hr_utility.raise_error;
948: end if;
949: elsif p_effective_date >= to_date('19'||'99/01/01','yyyy/mm/dd') then
950: if p_First_NOAC_Lookup_Code= '101'
951: and
972: 'QBK','QCK','VGL','V1P','V8L','V8N','Z2U','Z2W','ZGM','ZJK','ZJM',
973: 'ZBA','ZJR','ZLM','ZQM','ZRM','ZSK','ZSP','ZTU','Z5B','Z5C')
974: )
975: then
976: hr_utility.set_message(8301, 'GHR_37087_ALL_PROCEDURE_FAIL');
977: hr_utility.raise_error;
978: end if;
979: else
980: if p_First_NOAC_Lookup_Code= '101'
973: 'ZBA','ZJR','ZLM','ZQM','ZRM','ZSK','ZSP','ZTU','Z5B','Z5C')
974: )
975: then
976: hr_utility.set_message(8301, 'GHR_37087_ALL_PROCEDURE_FAIL');
977: hr_utility.raise_error;
978: end if;
979: else
980: if p_First_NOAC_Lookup_Code= '101'
981: and
1002: 'QBK','QCK','V1P','V8L','V8N','Z2U','Z2W','ZGM','ZJK','ZJM',
1003: 'ZBA','ZJR','ZLM','ZQM','ZRM','ZSK','ZSP','ZTU','Z5B','Z5C')
1004: )
1005: then
1006: hr_utility.set_message(8301, 'GHR_37312_ALL_PROCEDURE_FAIL');
1007: hr_utility.raise_error;
1008: end if;
1009: end if;
1010: -- END OF 255.04.2
1003: 'ZBA','ZJR','ZLM','ZQM','ZRM','ZSK','ZSP','ZTU','Z5B','Z5C')
1004: )
1005: then
1006: hr_utility.set_message(8301, 'GHR_37312_ALL_PROCEDURE_FAIL');
1007: hr_utility.raise_error;
1008: end if;
1009: end if;
1010: -- END OF 255.04.2
1011: --
1033: 'BWM','HAM','HDM','HGM','HJM','HLM','NUM',
1034: 'QBK','V1P','V8N','Z2U','ZLM','ZRM','ZSK')
1035: )
1036: THEN
1037: hr_utility.set_message(8301, 'GHR_37313_ALL_PROCEDURE_FAIL');
1038: hr_utility.raise_error;
1039: end if;
1040: elsif p_effective_date < fnd_date.canonical_to_date('2009/01/01') then
1041: if p_First_NOAC_Lookup_Code= '107'
1034: 'QBK','V1P','V8N','Z2U','ZLM','ZRM','ZSK')
1035: )
1036: THEN
1037: hr_utility.set_message(8301, 'GHR_37313_ALL_PROCEDURE_FAIL');
1038: hr_utility.raise_error;
1039: end if;
1040: elsif p_effective_date < fnd_date.canonical_to_date('2009/01/01') then
1041: if p_First_NOAC_Lookup_Code= '107'
1042: and
1051: 'BWM','HAM','HDM','HGM','HJM','HLM','NUM',
1052: 'QBK','V1P','V8N','Z2U','ZLM','ZRM','ZSK')
1053: )
1054: THEN
1055: hr_utility.set_message(8301, 'GHR_37049_ALL_PROCEDURE_FAIL');
1056: hr_utility.set_message_token('LAC_CODE','ABL, ABM, ABR, ABS, ALM, AQM, BWA BWM, HAM, HDM, HGM, HJM, HLM, NUM, QBK, V1P, V8N, Z2U, ZLM, ZRM, ZSK.');
1057: hr_utility.raise_error;
1058: end if;
1059: elsif p_effective_date < fnd_date.canonical_to_date('2009/02/17') then
1052: 'QBK','V1P','V8N','Z2U','ZLM','ZRM','ZSK')
1053: )
1054: THEN
1055: hr_utility.set_message(8301, 'GHR_37049_ALL_PROCEDURE_FAIL');
1056: hr_utility.set_message_token('LAC_CODE','ABL, ABM, ABR, ABS, ALM, AQM, BWA BWM, HAM, HDM, HGM, HJM, HLM, NUM, QBK, V1P, V8N, Z2U, ZLM, ZRM, ZSK.');
1057: hr_utility.raise_error;
1058: end if;
1059: elsif p_effective_date < fnd_date.canonical_to_date('2009/02/17') then
1060: if p_First_NOAC_Lookup_Code= '107'
1053: )
1054: THEN
1055: hr_utility.set_message(8301, 'GHR_37049_ALL_PROCEDURE_FAIL');
1056: hr_utility.set_message_token('LAC_CODE','ABL, ABM, ABR, ABS, ALM, AQM, BWA BWM, HAM, HDM, HGM, HJM, HLM, NUM, QBK, V1P, V8N, Z2U, ZLM, ZRM, ZSK.');
1057: hr_utility.raise_error;
1058: end if;
1059: elsif p_effective_date < fnd_date.canonical_to_date('2009/02/17') then
1060: if p_First_NOAC_Lookup_Code= '107'
1061: and
1070: 'BWM','BAG','HAM','HDM','HGM','HJM','HLM','NUM',
1071: 'QBK','V1P','V8N','Z2U','ZLM','ZRM','ZSK')
1072: )
1073: THEN
1074: hr_utility.set_message(8301, 'GHR_37049_ALL_PROCEDURE_FAIL');
1075: hr_utility.set_message_token('LAC_CODE','ABL, ABM, ABR, ABS, ALM, AQM, BWA BWM, BAG, HAM, HDM, HGM, HJM, HLM, NUM, QBK, V1P, V8N, Z2U, ZLM, ZRM, ZSK.');
1076: hr_utility.raise_error;
1077: end if;
1078: else
1071: 'QBK','V1P','V8N','Z2U','ZLM','ZRM','ZSK')
1072: )
1073: THEN
1074: hr_utility.set_message(8301, 'GHR_37049_ALL_PROCEDURE_FAIL');
1075: hr_utility.set_message_token('LAC_CODE','ABL, ABM, ABR, ABS, ALM, AQM, BWA BWM, BAG, HAM, HDM, HGM, HJM, HLM, NUM, QBK, V1P, V8N, Z2U, ZLM, ZRM, ZSK.');
1076: hr_utility.raise_error;
1077: end if;
1078: else
1079: if p_First_NOAC_Lookup_Code= '107'
1072: )
1073: THEN
1074: hr_utility.set_message(8301, 'GHR_37049_ALL_PROCEDURE_FAIL');
1075: hr_utility.set_message_token('LAC_CODE','ABL, ABM, ABR, ABS, ALM, AQM, BWA BWM, BAG, HAM, HDM, HGM, HJM, HLM, NUM, QBK, V1P, V8N, Z2U, ZLM, ZRM, ZSK.');
1076: hr_utility.raise_error;
1077: end if;
1078: else
1079: if p_First_NOAC_Lookup_Code= '107'
1080: and
1089: 'BWM','BAG','HAM','HDM','HGM','HJM','HLM','NUM',
1090: 'QBK','V1P','V8N','Z2U','ZLM','ZRM','ZSK','ZEA')
1091: )
1092: THEN
1093: hr_utility.set_message(8301, 'GHR_37049_ALL_PROCEDURE_FAIL');
1094: hr_utility.set_message_token('LAC_CODE','ABL, ABM, ABR, ABS, ALM, AQM, BWA BWM, BAG, HAM, HDM, HGM, HJM, HLM, NUM, QBK, V1P, V8N, Z2U, ZEA, ZLM, ZRM, ZSK.');
1095: hr_utility.raise_error;
1096: end if;
1097: end if;
1090: 'QBK','V1P','V8N','Z2U','ZLM','ZRM','ZSK','ZEA')
1091: )
1092: THEN
1093: hr_utility.set_message(8301, 'GHR_37049_ALL_PROCEDURE_FAIL');
1094: hr_utility.set_message_token('LAC_CODE','ABL, ABM, ABR, ABS, ALM, AQM, BWA BWM, BAG, HAM, HDM, HGM, HJM, HLM, NUM, QBK, V1P, V8N, Z2U, ZEA, ZLM, ZRM, ZSK.');
1095: hr_utility.raise_error;
1096: end if;
1097: end if;
1098:
1091: )
1092: THEN
1093: hr_utility.set_message(8301, 'GHR_37049_ALL_PROCEDURE_FAIL');
1094: hr_utility.set_message_token('LAC_CODE','ABL, ABM, ABR, ABS, ALM, AQM, BWA BWM, BAG, HAM, HDM, HGM, HJM, HLM, NUM, QBK, V1P, V8N, Z2U, ZEA, ZLM, ZRM, ZSK.');
1095: hr_utility.raise_error;
1096: end if;
1097: end if;
1098:
1099: --265.04.2
1136: 'BWA','BWM','HAM','LDM','MAB', 'MAC', 'MAF', 'MEM','MGM','MJM',
1137: 'MLK','MLM','MMM','NUM','QAK','UDM','VGL','VJM',
1138: 'V1P','V8L','V8N','Z2U','Z2W','ZJK','ZLM',
1139: 'ZQM','ZRM','ZSK','ZSP','ZTM','ZTU','ZJM','Z5B', 'Z5C', 'Z5F', 'Z5J','ZEA','Z6L') ) THEN
1140: hr_utility.set_message(8301, 'GHR_37194_ALL_PROCEDURE_FAIL');
1141: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ABR, ABS, ALM, AYM, BAB, BAC, BAD, BAE, BAG, BYO,
1142: BWA, BWM, HAM, LDM, MAB, MAC, MAF, MEM, MGM, MJM, MLK, MLM, MMM, NUM, QAK, UDM, VJM, V1P, V8L, V8N, VGL, Z2U,
1143: Z2W, ZEA, ZJK, ZJM, ZLM, ZQM, ZRM, ZSK, ZSP, ZTM, ZTU ,Z5B, Z5C, Z5F, Z5J, Z6L.');
1144: hr_utility.raise_error;
1137: 'MLK','MLM','MMM','NUM','QAK','UDM','VGL','VJM',
1138: 'V1P','V8L','V8N','Z2U','Z2W','ZJK','ZLM',
1139: 'ZQM','ZRM','ZSK','ZSP','ZTM','ZTU','ZJM','Z5B', 'Z5C', 'Z5F', 'Z5J','ZEA','Z6L') ) THEN
1140: hr_utility.set_message(8301, 'GHR_37194_ALL_PROCEDURE_FAIL');
1141: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ABR, ABS, ALM, AYM, BAB, BAC, BAD, BAE, BAG, BYO,
1142: BWA, BWM, HAM, LDM, MAB, MAC, MAF, MEM, MGM, MJM, MLK, MLM, MMM, NUM, QAK, UDM, VJM, V1P, V8L, V8N, VGL, Z2U,
1143: Z2W, ZEA, ZJK, ZJM, ZLM, ZQM, ZRM, ZSK, ZSP, ZTM, ZTU ,Z5B, Z5C, Z5F, Z5J, Z6L.');
1144: hr_utility.raise_error;
1145: end if;
1140: hr_utility.set_message(8301, 'GHR_37194_ALL_PROCEDURE_FAIL');
1141: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ABR, ABS, ALM, AYM, BAB, BAC, BAD, BAE, BAG, BYO,
1142: BWA, BWM, HAM, LDM, MAB, MAC, MAF, MEM, MGM, MJM, MLK, MLM, MMM, NUM, QAK, UDM, VJM, V1P, V8L, V8N, VGL, Z2U,
1143: Z2W, ZEA, ZJK, ZJM, ZLM, ZQM, ZRM, ZSK, ZSP, ZTM, ZTU ,Z5B, Z5C, Z5F, Z5J, Z6L.');
1144: hr_utility.raise_error;
1145: end if;
1146: --BUG # 16217492
1147:
1148: --BUG # 14395108
1162: 'BWA','BWM','HAM','LDM','MAB', 'MAC', 'MAF', 'MAG','MEM','MGM','MJM',
1163: 'MLK','MLM','MMM','NUM','QAK','UDM','VGL','VJM',
1164: 'V1P','V8L','V8N','Z2U','Z2W','ZJK','ZLM',
1165: 'ZQM','ZRM','ZSK','ZSP','ZTM','ZTU','ZJM','Z5B', 'Z5C', 'Z5F', 'Z5J','ZEA','Z6L') ) THEN
1166: hr_utility.set_message(8301, 'GHR_37194_ALL_PROCEDURE_FAIL');
1167: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ABR, ABS, ALM, AYM, BAB, BAC, BAD, BAE, BAG, BYO,
1168: BWA, BWM, HAM, LDM, MAB, MAC, MAF, MAG, MEM, MGM, MJM, MLK, MLM, MMM, NUM, QAK, UDM, VJM, V1P, V8L, V8N, VGL, Z2U,
1169: Z2W, ZEA, ZJK, ZJM, ZLM, ZQM, ZRM, ZSK, ZSP, ZTM, ZTU ,Z5B, Z5C, Z5F, Z5J, Z6L.');
1170: hr_utility.raise_error;
1163: 'MLK','MLM','MMM','NUM','QAK','UDM','VGL','VJM',
1164: 'V1P','V8L','V8N','Z2U','Z2W','ZJK','ZLM',
1165: 'ZQM','ZRM','ZSK','ZSP','ZTM','ZTU','ZJM','Z5B', 'Z5C', 'Z5F', 'Z5J','ZEA','Z6L') ) THEN
1166: hr_utility.set_message(8301, 'GHR_37194_ALL_PROCEDURE_FAIL');
1167: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ABR, ABS, ALM, AYM, BAB, BAC, BAD, BAE, BAG, BYO,
1168: BWA, BWM, HAM, LDM, MAB, MAC, MAF, MAG, MEM, MGM, MJM, MLK, MLM, MMM, NUM, QAK, UDM, VJM, V1P, V8L, V8N, VGL, Z2U,
1169: Z2W, ZEA, ZJK, ZJM, ZLM, ZQM, ZRM, ZSK, ZSP, ZTM, ZTU ,Z5B, Z5C, Z5F, Z5J, Z6L.');
1170: hr_utility.raise_error;
1171: end if;
1166: hr_utility.set_message(8301, 'GHR_37194_ALL_PROCEDURE_FAIL');
1167: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ABR, ABS, ALM, AYM, BAB, BAC, BAD, BAE, BAG, BYO,
1168: BWA, BWM, HAM, LDM, MAB, MAC, MAF, MAG, MEM, MGM, MJM, MLK, MLM, MMM, NUM, QAK, UDM, VJM, V1P, V8L, V8N, VGL, Z2U,
1169: Z2W, ZEA, ZJK, ZJM, ZLM, ZQM, ZRM, ZSK, ZSP, ZTM, ZTU ,Z5B, Z5C, Z5F, Z5J, Z6L.');
1170: hr_utility.raise_error;
1171: end if;
1172: --BUG # 14395108
1173: --Begin Bug# 8799026
1174: elsif p_effective_date >= to_date('2009/09/11','yyyy/mm/dd') then
1187: 'BWA','BWM','HAM','LDM','MEM','MGM','MJM',
1188: 'MLK','MLM','MMM','NUM','QAK','UDM','VGL','VJM',
1189: 'V1P','V8L','V8N','Z2U','Z2W','ZJK','ZLM',
1190: 'ZQM','ZRM','ZSK','ZSP','ZTM','ZTU','ZJM','Z5B', 'Z5C', 'Z5F', 'Z5J','ZEA','Z6L') ) THEN
1191: hr_utility.set_message(8301, 'GHR_37194_ALL_PROCEDURE_FAIL');
1192: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ABR, ABS, ALM, AYM,BAB,BAC, BAD, BAE, BAG, BYO,
1193: BWA, BWM, HAM, LDM, MEM, MGM, MJM, MLK, MLM, MMM, NUM, QAK, UDM, VJM, V1P, V8L, V8N, VGL, Z2U, Z2W, ZEA, ZJK,
1194: ZJM, ZLM, ZQM, ZRM, ZSK, ZSP, ZTM, ZTU ,Z5B, Z5C, Z5F, Z5J, Z6L.');
1195: hr_utility.raise_error;
1188: 'MLK','MLM','MMM','NUM','QAK','UDM','VGL','VJM',
1189: 'V1P','V8L','V8N','Z2U','Z2W','ZJK','ZLM',
1190: 'ZQM','ZRM','ZSK','ZSP','ZTM','ZTU','ZJM','Z5B', 'Z5C', 'Z5F', 'Z5J','ZEA','Z6L') ) THEN
1191: hr_utility.set_message(8301, 'GHR_37194_ALL_PROCEDURE_FAIL');
1192: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ABR, ABS, ALM, AYM,BAB,BAC, BAD, BAE, BAG, BYO,
1193: BWA, BWM, HAM, LDM, MEM, MGM, MJM, MLK, MLM, MMM, NUM, QAK, UDM, VJM, V1P, V8L, V8N, VGL, Z2U, Z2W, ZEA, ZJK,
1194: ZJM, ZLM, ZQM, ZRM, ZSK, ZSP, ZTM, ZTU ,Z5B, Z5C, Z5F, Z5J, Z6L.');
1195: hr_utility.raise_error;
1196: end if;
1191: hr_utility.set_message(8301, 'GHR_37194_ALL_PROCEDURE_FAIL');
1192: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ABR, ABS, ALM, AYM,BAB,BAC, BAD, BAE, BAG, BYO,
1193: BWA, BWM, HAM, LDM, MEM, MGM, MJM, MLK, MLM, MMM, NUM, QAK, UDM, VJM, V1P, V8L, V8N, VGL, Z2U, Z2W, ZEA, ZJK,
1194: ZJM, ZLM, ZQM, ZRM, ZSK, ZSP, ZTM, ZTU ,Z5B, Z5C, Z5F, Z5J, Z6L.');
1195: hr_utility.raise_error;
1196: end if;
1197: --End Bug# 8799026
1198: elsif p_effective_date >= to_date('2009/03/01','yyyy/mm/dd') then
1199: if p_First_NOAC_Lookup_Code= '108'
1211: 'BWA','BWM','HAM','MEM','MGM','MJM',
1212: 'MLK','MLM','MMM','NUM','QAK','UDM','VGL','VJM',
1213: 'V1P','V8L','V8N','Z2U','Z2W','ZJK','ZLM',
1214: 'ZQM','ZRM','ZSK','ZSP','ZTM','ZTU','ZJM','Z5B', 'Z5C', 'Z5F', 'Z5J','ZEA','Z6L') ) THEN
1215: hr_utility.set_message(8301, 'GHR_37194_ALL_PROCEDURE_FAIL');
1216: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ABR, ABS, ALM, AYM,BAB,BAC, BAD, BAE, BAG, BYO,
1217: BWA, BWM, HAM, MEM, MGM, MJM, MLK, MLM, MMM, NUM, QAK, UDM, VJM, V1P, V8L, V8N, VGL, Z2U, Z2W, ZEA, ZJK,
1218: ZJM, ZLM, ZQM, ZRM, ZSK, ZSP, ZTM, ZTU ,Z5B, Z5C, Z5F, Z5J, Z6L.');
1219: hr_utility.raise_error;
1212: 'MLK','MLM','MMM','NUM','QAK','UDM','VGL','VJM',
1213: 'V1P','V8L','V8N','Z2U','Z2W','ZJK','ZLM',
1214: 'ZQM','ZRM','ZSK','ZSP','ZTM','ZTU','ZJM','Z5B', 'Z5C', 'Z5F', 'Z5J','ZEA','Z6L') ) THEN
1215: hr_utility.set_message(8301, 'GHR_37194_ALL_PROCEDURE_FAIL');
1216: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ABR, ABS, ALM, AYM,BAB,BAC, BAD, BAE, BAG, BYO,
1217: BWA, BWM, HAM, MEM, MGM, MJM, MLK, MLM, MMM, NUM, QAK, UDM, VJM, V1P, V8L, V8N, VGL, Z2U, Z2W, ZEA, ZJK,
1218: ZJM, ZLM, ZQM, ZRM, ZSK, ZSP, ZTM, ZTU ,Z5B, Z5C, Z5F, Z5J, Z6L.');
1219: hr_utility.raise_error;
1220: end if;
1215: hr_utility.set_message(8301, 'GHR_37194_ALL_PROCEDURE_FAIL');
1216: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ABR, ABS, ALM, AYM,BAB,BAC, BAD, BAE, BAG, BYO,
1217: BWA, BWM, HAM, MEM, MGM, MJM, MLK, MLM, MMM, NUM, QAK, UDM, VJM, V1P, V8L, V8N, VGL, Z2U, Z2W, ZEA, ZJK,
1218: ZJM, ZLM, ZQM, ZRM, ZSK, ZSP, ZTM, ZTU ,Z5B, Z5C, Z5F, Z5J, Z6L.');
1219: hr_utility.raise_error;
1220: end if;
1221: elsif p_effective_date >= to_date('2009/02/17','yyyy/mm/dd') then
1222: if p_First_NOAC_Lookup_Code= '108'
1223: and
1234: 'BWA','BWM','HAM','MEM','MGM','MJM',
1235: 'MLK','MLM','MMM','NUM','QAK','UDM','VGL','VJM',
1236: 'V1P','V8L','V8N','Z2U','Z2W','ZJK','ZLM',
1237: 'ZQM','ZRM','ZSK','ZSP','ZTM','ZTU','ZJM','Z5B', 'Z5C', 'Z5F', 'Z5H', 'Z5J','ZEA','Z6L') ) THEN
1238: hr_utility.set_message(8301, 'GHR_37194_ALL_PROCEDURE_FAIL');
1239: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ABR, ABS, ALM, AYM,BAB,BAC, BAD, BAE, BAG, BNZ, BYO,
1240: BWA, BWM, HAM, MEM, MGM, MJM, MLK, MLM, MMM, NUM, QAK, UDM, VJM, V1P, V8L, V8N, VGL, Z2U, Z2W, ZEA, ZJK,
1241: ZJM, ZLM, ZQM, ZRM, ZSK, ZSP, ZTM, ZTU ,Z5B, Z5C, Z5F, Z5H, Z5J, Z6L.');
1242: hr_utility.raise_error;
1235: 'MLK','MLM','MMM','NUM','QAK','UDM','VGL','VJM',
1236: 'V1P','V8L','V8N','Z2U','Z2W','ZJK','ZLM',
1237: 'ZQM','ZRM','ZSK','ZSP','ZTM','ZTU','ZJM','Z5B', 'Z5C', 'Z5F', 'Z5H', 'Z5J','ZEA','Z6L') ) THEN
1238: hr_utility.set_message(8301, 'GHR_37194_ALL_PROCEDURE_FAIL');
1239: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ABR, ABS, ALM, AYM,BAB,BAC, BAD, BAE, BAG, BNZ, BYO,
1240: BWA, BWM, HAM, MEM, MGM, MJM, MLK, MLM, MMM, NUM, QAK, UDM, VJM, V1P, V8L, V8N, VGL, Z2U, Z2W, ZEA, ZJK,
1241: ZJM, ZLM, ZQM, ZRM, ZSK, ZSP, ZTM, ZTU ,Z5B, Z5C, Z5F, Z5H, Z5J, Z6L.');
1242: hr_utility.raise_error;
1243: end if;
1238: hr_utility.set_message(8301, 'GHR_37194_ALL_PROCEDURE_FAIL');
1239: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ABR, ABS, ALM, AYM,BAB,BAC, BAD, BAE, BAG, BNZ, BYO,
1240: BWA, BWM, HAM, MEM, MGM, MJM, MLK, MLM, MMM, NUM, QAK, UDM, VJM, V1P, V8L, V8N, VGL, Z2U, Z2W, ZEA, ZJK,
1241: ZJM, ZLM, ZQM, ZRM, ZSK, ZSP, ZTM, ZTU ,Z5B, Z5C, Z5F, Z5H, Z5J, Z6L.');
1242: hr_utility.raise_error;
1243: end if;
1244: elsif p_effective_date >= to_date('2009/01/01','yyyy/mm/dd') then
1245: if p_First_NOAC_Lookup_Code= '108'
1246: and
1257: 'BWA','BWM','HAM','MEM','MGM','MJM',
1258: 'MLK','MLM','MMM','NUM','QAK','UDM','VGL','VJM',
1259: 'V1P','V8L','V8N','Z2U','Z2W','ZJK','ZLM',
1260: 'ZQM','ZRM','ZSK','ZSP','ZTM','ZTU','ZJM','Z5B', 'Z5C', 'Z5F', 'Z5H', 'Z5J','Z6L') ) THEN
1261: hr_utility.set_message(8301, 'GHR_37194_ALL_PROCEDURE_FAIL');
1262: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ABR, ABS, ALM, AYM,BAB,BAC, BAD, BAE, BAG, BNZ, BYO,
1263: BWA, BWM, HAM, MEM, MGM, MJM, MLK, MLM, MMM, NUM, QAK, UDM, VJM, V1P, V8L, V8N, VGL, Z2U, Z2W, ZJK, ZJM,
1264: ZLM, ZQM, ZRM, ZSK, ZSP, ZTM, ZTU ,Z5B, Z5C, Z5F, Z5H, Z5J, Z6L.');
1265: hr_utility.raise_error;
1258: 'MLK','MLM','MMM','NUM','QAK','UDM','VGL','VJM',
1259: 'V1P','V8L','V8N','Z2U','Z2W','ZJK','ZLM',
1260: 'ZQM','ZRM','ZSK','ZSP','ZTM','ZTU','ZJM','Z5B', 'Z5C', 'Z5F', 'Z5H', 'Z5J','Z6L') ) THEN
1261: hr_utility.set_message(8301, 'GHR_37194_ALL_PROCEDURE_FAIL');
1262: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ABR, ABS, ALM, AYM,BAB,BAC, BAD, BAE, BAG, BNZ, BYO,
1263: BWA, BWM, HAM, MEM, MGM, MJM, MLK, MLM, MMM, NUM, QAK, UDM, VJM, V1P, V8L, V8N, VGL, Z2U, Z2W, ZJK, ZJM,
1264: ZLM, ZQM, ZRM, ZSK, ZSP, ZTM, ZTU ,Z5B, Z5C, Z5F, Z5H, Z5J, Z6L.');
1265: hr_utility.raise_error;
1266: end if;
1261: hr_utility.set_message(8301, 'GHR_37194_ALL_PROCEDURE_FAIL');
1262: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ABR, ABS, ALM, AYM,BAB,BAC, BAD, BAE, BAG, BNZ, BYO,
1263: BWA, BWM, HAM, MEM, MGM, MJM, MLK, MLM, MMM, NUM, QAK, UDM, VJM, V1P, V8L, V8N, VGL, Z2U, Z2W, ZJK, ZJM,
1264: ZLM, ZQM, ZRM, ZSK, ZSP, ZTM, ZTU ,Z5B, Z5C, Z5F, Z5H, Z5J, Z6L.');
1265: hr_utility.raise_error;
1266: end if;
1267: elsif p_effective_date >= to_date('19'||'99/11/01','yyyy/mm/dd') then
1268: if p_First_NOAC_Lookup_Code= '108'
1269: and
1280: 'BWA','BWM','HAM','MEM','MGM','MJM',
1281: 'MLK','MLM','MMM','NUM','QAK','UDM','VGL','VJM',
1282: 'V1P','V8L','V8N','Z2U','Z2W','ZJK','ZLM',
1283: 'ZQM','ZRM','ZSK','ZSP','ZTM','ZTU','ZJM','Z5B', 'Z5C', 'Z5F', 'Z5H', 'Z5J','Z6L') ) THEN
1284: hr_utility.set_message(8301, 'GHR_37194_ALL_PROCEDURE_FAIL');
1285: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ABR, ABS, ALM, AYM,BAB,BAC, BAD, BAE, BNZ, BYO, BWA
1286: , BWM, HAM, MEM, MGM, MJM, MLK, MLM, MMM, NUM, QAK, UDM, VJM, V1P, V8L, V8N, VGL, Z2U, Z2W, ZJK, ZJM, ZLM,
1287: ZQM, ZRM, ZSK, ZSP, ZTM, ZTU ,Z5B, Z5C, Z5F, Z5H, Z5J, Z6L.');
1288: hr_utility.raise_error;
1281: 'MLK','MLM','MMM','NUM','QAK','UDM','VGL','VJM',
1282: 'V1P','V8L','V8N','Z2U','Z2W','ZJK','ZLM',
1283: 'ZQM','ZRM','ZSK','ZSP','ZTM','ZTU','ZJM','Z5B', 'Z5C', 'Z5F', 'Z5H', 'Z5J','Z6L') ) THEN
1284: hr_utility.set_message(8301, 'GHR_37194_ALL_PROCEDURE_FAIL');
1285: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ABR, ABS, ALM, AYM,BAB,BAC, BAD, BAE, BNZ, BYO, BWA
1286: , BWM, HAM, MEM, MGM, MJM, MLK, MLM, MMM, NUM, QAK, UDM, VJM, V1P, V8L, V8N, VGL, Z2U, Z2W, ZJK, ZJM, ZLM,
1287: ZQM, ZRM, ZSK, ZSP, ZTM, ZTU ,Z5B, Z5C, Z5F, Z5H, Z5J, Z6L.');
1288: hr_utility.raise_error;
1289: end if;
1284: hr_utility.set_message(8301, 'GHR_37194_ALL_PROCEDURE_FAIL');
1285: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ABR, ABS, ALM, AYM,BAB,BAC, BAD, BAE, BNZ, BYO, BWA
1286: , BWM, HAM, MEM, MGM, MJM, MLK, MLM, MMM, NUM, QAK, UDM, VJM, V1P, V8L, V8N, VGL, Z2U, Z2W, ZJK, ZJM, ZLM,
1287: ZQM, ZRM, ZSK, ZSP, ZTM, ZTU ,Z5B, Z5C, Z5F, Z5H, Z5J, Z6L.');
1288: hr_utility.raise_error;
1289: end if;
1290: elsif p_effective_date >= to_date('19'||'99/02/27','yyyy/mm/dd') then
1291: if p_First_NOAC_Lookup_Code= '108'
1292: and
1303: 'BWA','BWM','HAM','MEM','MGM','MJM',
1304: 'MLK','MLM','MMM','NUM','QAK','VGL','VJM',
1305: 'V1P','V8L','V8N','Z2U','Z2W','ZJK','ZLM',
1306: 'ZQM','ZRM','ZSK','ZSP','ZTM','ZTU','ZJM','Z5B', 'Z5C', 'Z5F', 'Z5H', 'Z5J','Z6L') ) THEN
1307: hr_utility.set_message(8301, 'GHR_37050_ALL_PROCEDURE_FAIL');
1308: hr_utility.raise_error;
1309: end if;
1310: elsif p_effective_date > to_date('19'||'99/01/31','yyyy/mm/dd') then
1311: if p_First_NOAC_Lookup_Code= '108'
1304: 'MLK','MLM','MMM','NUM','QAK','VGL','VJM',
1305: 'V1P','V8L','V8N','Z2U','Z2W','ZJK','ZLM',
1306: 'ZQM','ZRM','ZSK','ZSP','ZTM','ZTU','ZJM','Z5B', 'Z5C', 'Z5F', 'Z5H', 'Z5J','Z6L') ) THEN
1307: hr_utility.set_message(8301, 'GHR_37050_ALL_PROCEDURE_FAIL');
1308: hr_utility.raise_error;
1309: end if;
1310: elsif p_effective_date > to_date('19'||'99/01/31','yyyy/mm/dd') then
1311: if p_First_NOAC_Lookup_Code= '108'
1312: and
1323: 'BWA','BWM','HAM','MCM','MEM','MGM','MJM',
1324: 'MLK','MLL','MLM','MMM','NUM','QAK','VGL','VJM',
1325: 'V1P','V8L','V8N','Z2U','Z2W','ZJK','ZLM',
1326: 'ZQM','ZRM','ZSK','ZSP','ZTM','ZTU','ZJM','Z5B', 'Z5C', 'Z5F', 'Z5H', 'Z5J','Z6L') ) THEN
1327: hr_utility.set_message(8301, 'GHR_37041_ALL_PROCEDURE_FAIL');
1328: hr_utility.raise_error;
1329: end if;
1330: elsif p_effective_date >= to_date('19'||'99/01/01','yyyy/mm/dd') then
1331: if p_First_NOAC_Lookup_Code= '108'
1324: 'MLK','MLL','MLM','MMM','NUM','QAK','VGL','VJM',
1325: 'V1P','V8L','V8N','Z2U','Z2W','ZJK','ZLM',
1326: 'ZQM','ZRM','ZSK','ZSP','ZTM','ZTU','ZJM','Z5B', 'Z5C', 'Z5F', 'Z5H', 'Z5J','Z6L') ) THEN
1327: hr_utility.set_message(8301, 'GHR_37041_ALL_PROCEDURE_FAIL');
1328: hr_utility.raise_error;
1329: end if;
1330: elsif p_effective_date >= to_date('19'||'99/01/01','yyyy/mm/dd') then
1331: if p_First_NOAC_Lookup_Code= '108'
1332: and
1345: 'BWA','BWM','HAM','MCM','MEM','MGM','MJM',
1346: 'MLK','MLL','MLM','MMM','NUM','QAK','VGL','VJM',
1347: 'V1P','V8L','V8N','Z2U','Z2W','ZJK','ZLM',
1348: 'ZQM','ZRM','ZSK','ZSP','ZTM','ZTU','ZJM','Z5B', 'Z5C', 'Z5F', 'Z5H', 'Z5J','Z6L') ) THEN
1349: hr_utility.set_message(8301, 'GHR_37086_ALL_PROCEDURE_FAIL');
1350: hr_utility.raise_error;
1351: end if;
1352: else
1353: if p_First_NOAC_Lookup_Code= '108'
1346: 'MLK','MLL','MLM','MMM','NUM','QAK','VGL','VJM',
1347: 'V1P','V8L','V8N','Z2U','Z2W','ZJK','ZLM',
1348: 'ZQM','ZRM','ZSK','ZSP','ZTM','ZTU','ZJM','Z5B', 'Z5C', 'Z5F', 'Z5H', 'Z5J','Z6L') ) THEN
1349: hr_utility.set_message(8301, 'GHR_37086_ALL_PROCEDURE_FAIL');
1350: hr_utility.raise_error;
1351: end if;
1352: else
1353: if p_First_NOAC_Lookup_Code= '108'
1354: and
1367: 'BWA','BWM','HAM','MCM','MEM','MGM','MJM',
1368: 'MLK','MLL','MLM','MMM','NUM','QAK','VJM',
1369: 'V1P','V8L','V8N','Z2U','Z2W','ZJK','ZLM',
1370: 'ZQM','ZRM','ZSK','ZSP','ZTM','ZTU','ZJM','Z5B', 'Z5C', 'Z5F', 'Z5H', 'Z5J','Z6L') ) THEN
1371: hr_utility.set_message(8301, 'GHR_37314_ALL_PROCEDURE_FAIL');
1372: hr_utility.raise_error;
1373: end if;
1374: end if;
1375:
1368: 'MLK','MLL','MLM','MMM','NUM','QAK','VJM',
1369: 'V1P','V8L','V8N','Z2U','Z2W','ZJK','ZLM',
1370: 'ZQM','ZRM','ZSK','ZSP','ZTM','ZTU','ZJM','Z5B', 'Z5C', 'Z5F', 'Z5H', 'Z5J','Z6L') ) THEN
1371: hr_utility.set_message(8301, 'GHR_37314_ALL_PROCEDURE_FAIL');
1372: hr_utility.raise_error;
1373: end if;
1374: end if;
1375:
1376: --265.10.2
1412: 'M6M','M8M','NAM','NCM','NEM','NJM',
1413: 'NUM','QAK','SZX','UDM','VGL','VJM','V1P','V8L','V8N',
1414: 'Z2U','Z2W','ZJK','ZLM','ZQM','ZRM','ZSK',
1415: 'ZSP','ZTM','ZTU','Z5B','Z5C','Z5F','Z5G','Z5H','ZEA') ) THEN
1416: hr_utility.set_message(8301, 'GHR_37195_ALL_PROCEDURE_FAIL');
1417: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ABR, ABS, ALM, AYM,BAB,BAC,BAD, BAE, BAG, BYO, BWA,
1418: BWM, HAM, KLM, LCM, MXM, M6M, M8M, NAM, NCM, NEM, NJM, NUM, QAK, SZX, UDM, VJM, V1P, V8L, V8N, VGL, Z2U, Z2W,
1419: ZEA, ZJK, ZLM, ZQM, ZRM, ZSK, ZSP, ZTM, ZTU, Z5B, Z5C, Z5F, Z5G, Z5H.');
1420: hr_utility.raise_error;
1413: 'NUM','QAK','SZX','UDM','VGL','VJM','V1P','V8L','V8N',
1414: 'Z2U','Z2W','ZJK','ZLM','ZQM','ZRM','ZSK',
1415: 'ZSP','ZTM','ZTU','Z5B','Z5C','Z5F','Z5G','Z5H','ZEA') ) THEN
1416: hr_utility.set_message(8301, 'GHR_37195_ALL_PROCEDURE_FAIL');
1417: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ABR, ABS, ALM, AYM,BAB,BAC,BAD, BAE, BAG, BYO, BWA,
1418: BWM, HAM, KLM, LCM, MXM, M6M, M8M, NAM, NCM, NEM, NJM, NUM, QAK, SZX, UDM, VJM, V1P, V8L, V8N, VGL, Z2U, Z2W,
1419: ZEA, ZJK, ZLM, ZQM, ZRM, ZSK, ZSP, ZTM, ZTU, Z5B, Z5C, Z5F, Z5G, Z5H.');
1420: hr_utility.raise_error;
1421: end if;
1416: hr_utility.set_message(8301, 'GHR_37195_ALL_PROCEDURE_FAIL');
1417: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ABR, ABS, ALM, AYM,BAB,BAC,BAD, BAE, BAG, BYO, BWA,
1418: BWM, HAM, KLM, LCM, MXM, M6M, M8M, NAM, NCM, NEM, NJM, NUM, QAK, SZX, UDM, VJM, V1P, V8L, V8N, VGL, Z2U, Z2W,
1419: ZEA, ZJK, ZLM, ZQM, ZRM, ZSK, ZSP, ZTM, ZTU, Z5B, Z5C, Z5F, Z5G, Z5H.');
1420: hr_utility.raise_error;
1421: end if;
1422: --End Bug# 8799026
1423: elsif p_effective_date >= to_date('2009/02/17','yyyy/mm/dd') then
1424: if p_First_NOAC_Lookup_Code= '115'
1438: 'M6M','M8M','NAM','NCM','NEM','NJM',
1439: 'NUM','QAK','SZX','UDM','VGL','VJM','V1P','V8L','V8N',
1440: 'Z2U','Z2W','ZJK','ZLM','ZQM','ZRM','ZSK',
1441: 'ZSP','ZTM','ZTU','Z5B','Z5C','Z5F','Z5G','Z5H','ZEA') ) THEN
1442: hr_utility.set_message(8301, 'GHR_37195_ALL_PROCEDURE_FAIL');
1443: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ABR, ABS, ALM, AYM,BAB,BAC,BAD, BAE, BAG, BYO, BWA,
1444: BWM, HAM, KLM, MXM, M6M, M8M, NAM, NCM, NEM, NJM, NUM, QAK, SZX, UDM, VJM, V1P, V8L, V8N, VGL,
1445: Z2U, Z2W, ZEA, ZJK, ZLM, ZQM, ZRM, ZSK, ZSP, ZTM, ZTU, Z5B, Z5C, Z5F, Z5G, Z5H.');
1446: hr_utility.raise_error;
1439: 'NUM','QAK','SZX','UDM','VGL','VJM','V1P','V8L','V8N',
1440: 'Z2U','Z2W','ZJK','ZLM','ZQM','ZRM','ZSK',
1441: 'ZSP','ZTM','ZTU','Z5B','Z5C','Z5F','Z5G','Z5H','ZEA') ) THEN
1442: hr_utility.set_message(8301, 'GHR_37195_ALL_PROCEDURE_FAIL');
1443: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ABR, ABS, ALM, AYM,BAB,BAC,BAD, BAE, BAG, BYO, BWA,
1444: BWM, HAM, KLM, MXM, M6M, M8M, NAM, NCM, NEM, NJM, NUM, QAK, SZX, UDM, VJM, V1P, V8L, V8N, VGL,
1445: Z2U, Z2W, ZEA, ZJK, ZLM, ZQM, ZRM, ZSK, ZSP, ZTM, ZTU, Z5B, Z5C, Z5F, Z5G, Z5H.');
1446: hr_utility.raise_error;
1447: end if;
1442: hr_utility.set_message(8301, 'GHR_37195_ALL_PROCEDURE_FAIL');
1443: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ABR, ABS, ALM, AYM,BAB,BAC,BAD, BAE, BAG, BYO, BWA,
1444: BWM, HAM, KLM, MXM, M6M, M8M, NAM, NCM, NEM, NJM, NUM, QAK, SZX, UDM, VJM, V1P, V8L, V8N, VGL,
1445: Z2U, Z2W, ZEA, ZJK, ZLM, ZQM, ZRM, ZSK, ZSP, ZTM, ZTU, Z5B, Z5C, Z5F, Z5G, Z5H.');
1446: hr_utility.raise_error;
1447: end if;
1448: elsif p_effective_date >= to_date('2009/01/01','yyyy/mm/dd') then
1449: if p_First_NOAC_Lookup_Code= '115'
1450: and
1463: 'M6M','M8M','NAM','NCM','NEM','NJM',
1464: 'NUM','QAK','SZX','UDM','VGL','VJM','V1P','V8L','V8N',
1465: 'Z2U','Z2W','ZJK','ZLM','ZQM','ZRM','ZSK',
1466: 'ZSP','ZTM','ZTU','Z5B','Z5C','Z5F','Z5G','Z5H') ) THEN
1467: hr_utility.set_message(8301, 'GHR_37195_ALL_PROCEDURE_FAIL');
1468: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ABR, ABS, ALM, AYM,BAB,BAC,BAD, BAE, BAG, BYO, BWA,
1469: BWM, HAM, KLM, MXM, M6M, M8M, NAM, NCM, NEM, NJM, NUM, QAK, SZX, UDM, VJM, V1P, V8L, V8N, VGL,
1470: Z2U, Z2W, ZJK, ZLM, ZQM, ZRM, ZSK, ZSP, ZTM, ZTU, Z5B, Z5C, Z5F, Z5G, Z5H.');
1471: hr_utility.raise_error;
1464: 'NUM','QAK','SZX','UDM','VGL','VJM','V1P','V8L','V8N',
1465: 'Z2U','Z2W','ZJK','ZLM','ZQM','ZRM','ZSK',
1466: 'ZSP','ZTM','ZTU','Z5B','Z5C','Z5F','Z5G','Z5H') ) THEN
1467: hr_utility.set_message(8301, 'GHR_37195_ALL_PROCEDURE_FAIL');
1468: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ABR, ABS, ALM, AYM,BAB,BAC,BAD, BAE, BAG, BYO, BWA,
1469: BWM, HAM, KLM, MXM, M6M, M8M, NAM, NCM, NEM, NJM, NUM, QAK, SZX, UDM, VJM, V1P, V8L, V8N, VGL,
1470: Z2U, Z2W, ZJK, ZLM, ZQM, ZRM, ZSK, ZSP, ZTM, ZTU, Z5B, Z5C, Z5F, Z5G, Z5H.');
1471: hr_utility.raise_error;
1472: end if;
1467: hr_utility.set_message(8301, 'GHR_37195_ALL_PROCEDURE_FAIL');
1468: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ABR, ABS, ALM, AYM,BAB,BAC,BAD, BAE, BAG, BYO, BWA,
1469: BWM, HAM, KLM, MXM, M6M, M8M, NAM, NCM, NEM, NJM, NUM, QAK, SZX, UDM, VJM, V1P, V8L, V8N, VGL,
1470: Z2U, Z2W, ZJK, ZLM, ZQM, ZRM, ZSK, ZSP, ZTM, ZTU, Z5B, Z5C, Z5F, Z5G, Z5H.');
1471: hr_utility.raise_error;
1472: end if;
1473: elsif p_effective_date >= to_date('19'||'99/11/01','yyyy/mm/dd') then
1474: if p_First_NOAC_Lookup_Code= '115'
1475: and
1488: 'M6M','M8M','NAM','NCM','NEM','NJM',
1489: 'NUM','QAK','SZX','UDM','VGL','VJM','V1P','V8L','V8N',
1490: 'Z2U','Z2W','ZJK','ZLM','ZQM','ZRM','ZSK',
1491: 'ZSP','ZTM','ZTU','Z5B','Z5C','Z5F','Z5G','Z5H') ) THEN
1492: hr_utility.set_message(8301, 'GHR_37195_ALL_PROCEDURE_FAIL');
1493: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ABR, ABS, ALM, AYM,BAB,BAC,BAD, BAE, BYO, BWA, BWM,
1494: HAM, KLM, MXM, M6M, M8M, NAM, NCM, NEM, NJM, NUM, QAK, SZX, UDM, VJM, V1P, V8L, V8N, VGL,
1495: Z2U, Z2W, ZJK, ZLM, ZQM, ZRM, ZSK, ZSP, ZTM, ZTU, Z5B, Z5C, Z5F, Z5G, Z5H.');
1496: hr_utility.raise_error;
1489: 'NUM','QAK','SZX','UDM','VGL','VJM','V1P','V8L','V8N',
1490: 'Z2U','Z2W','ZJK','ZLM','ZQM','ZRM','ZSK',
1491: 'ZSP','ZTM','ZTU','Z5B','Z5C','Z5F','Z5G','Z5H') ) THEN
1492: hr_utility.set_message(8301, 'GHR_37195_ALL_PROCEDURE_FAIL');
1493: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ABR, ABS, ALM, AYM,BAB,BAC,BAD, BAE, BYO, BWA, BWM,
1494: HAM, KLM, MXM, M6M, M8M, NAM, NCM, NEM, NJM, NUM, QAK, SZX, UDM, VJM, V1P, V8L, V8N, VGL,
1495: Z2U, Z2W, ZJK, ZLM, ZQM, ZRM, ZSK, ZSP, ZTM, ZTU, Z5B, Z5C, Z5F, Z5G, Z5H.');
1496: hr_utility.raise_error;
1497: end if;
1492: hr_utility.set_message(8301, 'GHR_37195_ALL_PROCEDURE_FAIL');
1493: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ABR, ABS, ALM, AYM,BAB,BAC,BAD, BAE, BYO, BWA, BWM,
1494: HAM, KLM, MXM, M6M, M8M, NAM, NCM, NEM, NJM, NUM, QAK, SZX, UDM, VJM, V1P, V8L, V8N, VGL,
1495: Z2U, Z2W, ZJK, ZLM, ZQM, ZRM, ZSK, ZSP, ZTM, ZTU, Z5B, Z5C, Z5F, Z5G, Z5H.');
1496: hr_utility.raise_error;
1497: end if;
1498: elsif p_effective_date > to_date('19'||'99/02/28','yyyy/mm/dd') then
1499: if p_First_NOAC_Lookup_Code= '115'
1500: and
1513: 'M6M','M8M','NAM','NCM','NEM','NJM',
1514: 'NUM','QAK','SZX','VGL','VJM','V1P','V8L','V8N',
1515: 'Z2U','Z2W','ZJK','ZLM','ZQM','ZRM','ZSK',
1516: 'ZSP','ZTM','ZTU','Z5B','Z5C','Z5F','Z5G','Z5H') ) THEN
1517: hr_utility.set_message(8301, 'GHR_37051_ALL_PROCEDURE_FAIL');
1518: hr_utility.raise_error;
1519: end if;
1520: elsif p_effective_date > to_date('19'||'99/01/31','yyyy/mm/dd') then
1521: if p_First_NOAC_Lookup_Code= '115'
1514: 'NUM','QAK','SZX','VGL','VJM','V1P','V8L','V8N',
1515: 'Z2U','Z2W','ZJK','ZLM','ZQM','ZRM','ZSK',
1516: 'ZSP','ZTM','ZTU','Z5B','Z5C','Z5F','Z5G','Z5H') ) THEN
1517: hr_utility.set_message(8301, 'GHR_37051_ALL_PROCEDURE_FAIL');
1518: hr_utility.raise_error;
1519: end if;
1520: elsif p_effective_date > to_date('19'||'99/01/31','yyyy/mm/dd') then
1521: if p_First_NOAC_Lookup_Code= '115'
1522: and
1535: 'M6M','M8M','NAM','NCM','NEL','NEM','NJM',
1536: 'NUM','QAK','SZX','VGL','VJM','V1P','V8L','V8N',
1537: 'Z2U','Z2W','ZJK','ZLM','ZQM','ZRM','ZSK',
1538: 'ZSP','ZTM','ZTU','Z5B','Z5C','Z5F','Z5G','Z5H') ) THEN
1539: hr_utility.set_message(8301, 'GHR_37042_ALL_PROCEDURE_FAIL');
1540: hr_utility.raise_error;
1541: end if;
1542: elsif p_effective_date >= to_date('19'||'99/01/01','yyyy/mm/dd') then
1543: if p_First_NOAC_Lookup_Code= '115'
1536: 'NUM','QAK','SZX','VGL','VJM','V1P','V8L','V8N',
1537: 'Z2U','Z2W','ZJK','ZLM','ZQM','ZRM','ZSK',
1538: 'ZSP','ZTM','ZTU','Z5B','Z5C','Z5F','Z5G','Z5H') ) THEN
1539: hr_utility.set_message(8301, 'GHR_37042_ALL_PROCEDURE_FAIL');
1540: hr_utility.raise_error;
1541: end if;
1542: elsif p_effective_date >= to_date('19'||'99/01/01','yyyy/mm/dd') then
1543: if p_First_NOAC_Lookup_Code= '115'
1544: and
1559: 'M6M','M8M','NAM','NCM','NEL','NEM','NJM',
1560: 'NUM','QAK','SZX','VGL','VJM','V1P','V8L','V8N',
1561: 'Z2U','Z2W','ZJK','ZLM','ZQM','ZRM','ZSK',
1562: 'ZSP','ZTM','ZTU','Z5B','Z5C','Z5F','Z5G','Z5H') ) THEN
1563: hr_utility.set_message(8301, 'GHR_37089_ALL_PROCEDURE_FAIL');
1564: hr_utility.raise_error;
1565: end if;
1566: else
1567: if p_First_NOAC_Lookup_Code= '115'
1560: 'NUM','QAK','SZX','VGL','VJM','V1P','V8L','V8N',
1561: 'Z2U','Z2W','ZJK','ZLM','ZQM','ZRM','ZSK',
1562: 'ZSP','ZTM','ZTU','Z5B','Z5C','Z5F','Z5G','Z5H') ) THEN
1563: hr_utility.set_message(8301, 'GHR_37089_ALL_PROCEDURE_FAIL');
1564: hr_utility.raise_error;
1565: end if;
1566: else
1567: if p_First_NOAC_Lookup_Code= '115'
1568: and
1583: 'M6M','M8M','NAM','NCM','NEL','NEM','NJM',
1584: 'NUM','QAK','SZX','VJM','V1P','V8L','V8N',
1585: 'Z2U','Z2W','ZJK','ZLM','ZQM','ZRM','ZSK',
1586: 'ZSP','ZTM','ZTU','Z5B','Z5C','Z5F','Z5G','Z5H') ) THEN
1587: hr_utility.set_message(8301, 'GHR_37316_ALL_PROCEDURE_FAIL');
1588: hr_utility.raise_error;
1589: end if;
1590: end if;
1591:
1584: 'NUM','QAK','SZX','VJM','V1P','V8L','V8N',
1585: 'Z2U','Z2W','ZJK','ZLM','ZQM','ZRM','ZSK',
1586: 'ZSP','ZTM','ZTU','Z5B','Z5C','Z5F','Z5G','Z5H') ) THEN
1587: hr_utility.set_message(8301, 'GHR_37316_ALL_PROCEDURE_FAIL');
1588: hr_utility.raise_error;
1589: end if;
1590: end if;
1591:
1592: --265.07.2
1615: 'ZRM','ZSK','ZSP','ZTM','ZTU') OR
1616: (SUBSTR(p_First_Action_NOA_LA_Code1,1,1) = 'X' AND
1617: LENGTH(p_First_Action_NOA_LA_Code1) =3 )))
1618: THEN
1619: hr_utility.set_message(8301, 'GHR_37088_ALL_PROCEDURE_FAIL');
1620: hr_utility.raise_error;
1621: END IF;
1622: ELSE
1623: if p_First_NOAC_Lookup_Code= '112'
1616: (SUBSTR(p_First_Action_NOA_LA_Code1,1,1) = 'X' AND
1617: LENGTH(p_First_Action_NOA_LA_Code1) =3 )))
1618: THEN
1619: hr_utility.set_message(8301, 'GHR_37088_ALL_PROCEDURE_FAIL');
1620: hr_utility.raise_error;
1621: END IF;
1622: ELSE
1623: if p_First_NOAC_Lookup_Code= '112'
1624: and
1635: 'ZRM','ZSK','ZSP','ZTM','ZTU') OR
1636: (SUBSTR(p_First_Action_NOA_LA_Code1,1,1) = 'X' AND
1637: LENGTH(p_First_Action_NOA_LA_Code1) =3 )))
1638: THEN
1639: hr_utility.set_message(8301, 'GHR_37315_ALL_PROCEDURE_FAIL');
1640: hr_utility.raise_error;
1641: end if;
1642: END IF;
1643: END IF; -- CHECK for end date
1636: (SUBSTR(p_First_Action_NOA_LA_Code1,1,1) = 'X' AND
1637: LENGTH(p_First_Action_NOA_LA_Code1) =3 )))
1638: THEN
1639: hr_utility.set_message(8301, 'GHR_37315_ALL_PROCEDURE_FAIL');
1640: hr_utility.raise_error;
1641: end if;
1642: END IF;
1643: END IF; -- CHECK for end date
1644:
1655: AND p_First_Action_NOA_LA_Code2 in
1656: ('ABM','ALM','AQM','AYM','BAG','BWM','HAM','HNM','HRM',
1657: 'QAK','QBK','QCK','V1P','ZLM','ZRM','ZSK','Z5C','ZEA')
1658: ) THEN
1659: hr_utility.set_message(8301, 'GHR_37318_ALL_PROCEDURE_FAIL');
1660: hr_utility.set_message_token('LAC_CODE',' ABM, ALM, AQM, AYM, BAG, BWM, HAM, HNM, HRM, QAK, QBK, QCK, V1P, ZEA, ZLM, ZRM, ZSK, Z5C.');
1661: hr_utility.raise_error;
1662: end if;
1663: ELSIF ( p_effective_date >= to_date('2009/01/01','yyyy/mm/dd') ) THEN
1656: ('ABM','ALM','AQM','AYM','BAG','BWM','HAM','HNM','HRM',
1657: 'QAK','QBK','QCK','V1P','ZLM','ZRM','ZSK','Z5C','ZEA')
1658: ) THEN
1659: hr_utility.set_message(8301, 'GHR_37318_ALL_PROCEDURE_FAIL');
1660: hr_utility.set_message_token('LAC_CODE',' ABM, ALM, AQM, AYM, BAG, BWM, HAM, HNM, HRM, QAK, QBK, QCK, V1P, ZEA, ZLM, ZRM, ZSK, Z5C.');
1661: hr_utility.raise_error;
1662: end if;
1663: ELSIF ( p_effective_date >= to_date('2009/01/01','yyyy/mm/dd') ) THEN
1664: if p_First_NOAC_Lookup_Code= '120' and
1657: 'QAK','QBK','QCK','V1P','ZLM','ZRM','ZSK','Z5C','ZEA')
1658: ) THEN
1659: hr_utility.set_message(8301, 'GHR_37318_ALL_PROCEDURE_FAIL');
1660: hr_utility.set_message_token('LAC_CODE',' ABM, ALM, AQM, AYM, BAG, BWM, HAM, HNM, HRM, QAK, QBK, QCK, V1P, ZEA, ZLM, ZRM, ZSK, Z5C.');
1661: hr_utility.raise_error;
1662: end if;
1663: ELSIF ( p_effective_date >= to_date('2009/01/01','yyyy/mm/dd') ) THEN
1664: if p_First_NOAC_Lookup_Code= '120' and
1665: NOT ( p_First_Action_NOA_LA_Code1 in
1668: AND p_First_Action_NOA_LA_Code2 in
1669: ('ABM','ALM','AQM','AYM','BAG','BWM','HAM','HNM','HRM',
1670: 'QAK','QBK','QCK','V1P','ZLM','ZRM','ZSK','Z5C')
1671: ) THEN
1672: hr_utility.set_message(8301, 'GHR_37318_ALL_PROCEDURE_FAIL');
1673: hr_utility.set_message_token('LAC_CODE',' ABM, ALM, AQM, AYM, BAG, BWM, HAM, HNM, HRM, QAK, QBK, QCK, V1P, ZLM, ZRM, ZSK, Z5C.');
1674: hr_utility.raise_error;
1675: end if;
1676: ELSE
1669: ('ABM','ALM','AQM','AYM','BAG','BWM','HAM','HNM','HRM',
1670: 'QAK','QBK','QCK','V1P','ZLM','ZRM','ZSK','Z5C')
1671: ) THEN
1672: hr_utility.set_message(8301, 'GHR_37318_ALL_PROCEDURE_FAIL');
1673: hr_utility.set_message_token('LAC_CODE',' ABM, ALM, AQM, AYM, BAG, BWM, HAM, HNM, HRM, QAK, QBK, QCK, V1P, ZLM, ZRM, ZSK, Z5C.');
1674: hr_utility.raise_error;
1675: end if;
1676: ELSE
1677: if p_First_NOAC_Lookup_Code= '120' and
1670: 'QAK','QBK','QCK','V1P','ZLM','ZRM','ZSK','Z5C')
1671: ) THEN
1672: hr_utility.set_message(8301, 'GHR_37318_ALL_PROCEDURE_FAIL');
1673: hr_utility.set_message_token('LAC_CODE',' ABM, ALM, AQM, AYM, BAG, BWM, HAM, HNM, HRM, QAK, QBK, QCK, V1P, ZLM, ZRM, ZSK, Z5C.');
1674: hr_utility.raise_error;
1675: end if;
1676: ELSE
1677: if p_First_NOAC_Lookup_Code= '120' and
1678: NOT ( p_First_Action_NOA_LA_Code1 in
1681: AND p_First_Action_NOA_LA_Code2 in
1682: ('ABM','ALM','AQM','AYM','BWM','HAM','HNM','HRM',
1683: 'QAK','QBK','QCK','V1P','ZLM','ZRM','ZSK','Z5C')
1684: ) THEN
1685: hr_utility.set_message(8301, 'GHR_37318_ALL_PROCEDURE_FAIL');
1686: hr_utility.set_message_token('LAC_CODE',' ABM, ALM, AQM, AYM, BWM, HAM, HNM, HRM, QAK, QBK, QCK, V1P, ZLM, ZRM, ZSK, Z5C.');
1687: hr_utility.raise_error;
1688: end if;
1689: END IF;
1682: ('ABM','ALM','AQM','AYM','BWM','HAM','HNM','HRM',
1683: 'QAK','QBK','QCK','V1P','ZLM','ZRM','ZSK','Z5C')
1684: ) THEN
1685: hr_utility.set_message(8301, 'GHR_37318_ALL_PROCEDURE_FAIL');
1686: hr_utility.set_message_token('LAC_CODE',' ABM, ALM, AQM, AYM, BWM, HAM, HNM, HRM, QAK, QBK, QCK, V1P, ZLM, ZRM, ZSK, Z5C.');
1687: hr_utility.raise_error;
1688: end if;
1689: END IF;
1690:
1683: 'QAK','QBK','QCK','V1P','ZLM','ZRM','ZSK','Z5C')
1684: ) THEN
1685: hr_utility.set_message(8301, 'GHR_37318_ALL_PROCEDURE_FAIL');
1686: hr_utility.set_message_token('LAC_CODE',' ABM, ALM, AQM, AYM, BWM, HAM, HNM, HRM, QAK, QBK, QCK, V1P, ZLM, ZRM, ZSK, Z5C.');
1687: hr_utility.raise_error;
1688: end if;
1689: END IF;
1690:
1691: --270.07.2
1699: 'H3M','QAK','V1P','ZLM','ZRM','ZSK','ZEA') AND
1700: p_First_Action_NOA_LA_Code2 in
1701: ('ABM','ALM','BWM','HAM','HNM','HRM',
1702: 'H3M','QAK','V1P','ZLM','ZRM','ZSK','ZEA') ) THEN
1703: hr_utility.set_message(8301, 'GHR_37319_ALL_PROCEDURE_FAIL');
1704: hr_utility.set_message_token('LAC_CODE','ABM, ALM, BWM, HAM, HNM, HRM, H3M, QAK, V1P, ZEA, ZLM, ZRM, ZSK.');
1705: hr_utility.raise_error;
1706: end if;
1707: ELSE
1700: p_First_Action_NOA_LA_Code2 in
1701: ('ABM','ALM','BWM','HAM','HNM','HRM',
1702: 'H3M','QAK','V1P','ZLM','ZRM','ZSK','ZEA') ) THEN
1703: hr_utility.set_message(8301, 'GHR_37319_ALL_PROCEDURE_FAIL');
1704: hr_utility.set_message_token('LAC_CODE','ABM, ALM, BWM, HAM, HNM, HRM, H3M, QAK, V1P, ZEA, ZLM, ZRM, ZSK.');
1705: hr_utility.raise_error;
1706: end if;
1707: ELSE
1708: if p_First_NOAC_Lookup_Code= '122'
1701: ('ABM','ALM','BWM','HAM','HNM','HRM',
1702: 'H3M','QAK','V1P','ZLM','ZRM','ZSK','ZEA') ) THEN
1703: hr_utility.set_message(8301, 'GHR_37319_ALL_PROCEDURE_FAIL');
1704: hr_utility.set_message_token('LAC_CODE','ABM, ALM, BWM, HAM, HNM, HRM, H3M, QAK, V1P, ZEA, ZLM, ZRM, ZSK.');
1705: hr_utility.raise_error;
1706: end if;
1707: ELSE
1708: if p_First_NOAC_Lookup_Code= '122'
1709: and
1712: 'H3M','QAK','V1P','ZLM','ZRM','ZSK') AND
1713: p_First_Action_NOA_LA_Code2 in
1714: ('ABM','ALM','BWM','HAM','HNM','HRM',
1715: 'H3M','QAK','V1P','ZLM','ZRM','ZSK') ) THEN
1716: hr_utility.set_message(8301, 'GHR_37319_ALL_PROCEDURE_FAIL');
1717: hr_utility.set_message_token('LAC_CODE','ABM, ALM, BWM, HAM, HNM, HRM, H3M, QAK, V1P, ZLM, ZRM, ZSK.');
1718: hr_utility.raise_error;
1719: end if;
1720: END IF;
1713: p_First_Action_NOA_LA_Code2 in
1714: ('ABM','ALM','BWM','HAM','HNM','HRM',
1715: 'H3M','QAK','V1P','ZLM','ZRM','ZSK') ) THEN
1716: hr_utility.set_message(8301, 'GHR_37319_ALL_PROCEDURE_FAIL');
1717: hr_utility.set_message_token('LAC_CODE','ABM, ALM, BWM, HAM, HNM, HRM, H3M, QAK, V1P, ZLM, ZRM, ZSK.');
1718: hr_utility.raise_error;
1719: end if;
1720: END IF;
1721:
1714: ('ABM','ALM','BWM','HAM','HNM','HRM',
1715: 'H3M','QAK','V1P','ZLM','ZRM','ZSK') ) THEN
1716: hr_utility.set_message(8301, 'GHR_37319_ALL_PROCEDURE_FAIL');
1717: hr_utility.set_message_token('LAC_CODE','ABM, ALM, BWM, HAM, HNM, HRM, H3M, QAK, V1P, ZLM, ZRM, ZSK.');
1718: hr_utility.raise_error;
1719: end if;
1720: END IF;
1721:
1722: --270.10.2
1729: 'NJM','NMM','QAK','QBK','QCK','V1P','ZLM','ZRM','ZSK','ZEA') AND
1730: p_First_Action_NOA_LA_Code2 in
1731: ('ABM','ALM','AQM','A7M','BWM','HAM','LBM','NFM',
1732: 'NJM','NMM','QAK','QBK','QCK','V1P','ZLM','ZRM','ZSK','ZEA') ) THEN
1733: hr_utility.set_message(8301, 'GHR_37320_ALL_PROCEDURE_FAIL');
1734: hr_utility.set_message_token('LAC_CODE','ABM, ALM, AQM, A7M, BWM, HAM, LBM, NFM, NJM, NMM, QAK, QBK, QCK, V1P, ZEA, ZLM, ZRM, ZSK.');
1735: hr_utility.raise_error;
1736: end if;
1737: ELSE
1730: p_First_Action_NOA_LA_Code2 in
1731: ('ABM','ALM','AQM','A7M','BWM','HAM','LBM','NFM',
1732: 'NJM','NMM','QAK','QBK','QCK','V1P','ZLM','ZRM','ZSK','ZEA') ) THEN
1733: hr_utility.set_message(8301, 'GHR_37320_ALL_PROCEDURE_FAIL');
1734: hr_utility.set_message_token('LAC_CODE','ABM, ALM, AQM, A7M, BWM, HAM, LBM, NFM, NJM, NMM, QAK, QBK, QCK, V1P, ZEA, ZLM, ZRM, ZSK.');
1735: hr_utility.raise_error;
1736: end if;
1737: ELSE
1738: if p_First_NOAC_Lookup_Code= '124'
1731: ('ABM','ALM','AQM','A7M','BWM','HAM','LBM','NFM',
1732: 'NJM','NMM','QAK','QBK','QCK','V1P','ZLM','ZRM','ZSK','ZEA') ) THEN
1733: hr_utility.set_message(8301, 'GHR_37320_ALL_PROCEDURE_FAIL');
1734: hr_utility.set_message_token('LAC_CODE','ABM, ALM, AQM, A7M, BWM, HAM, LBM, NFM, NJM, NMM, QAK, QBK, QCK, V1P, ZEA, ZLM, ZRM, ZSK.');
1735: hr_utility.raise_error;
1736: end if;
1737: ELSE
1738: if p_First_NOAC_Lookup_Code= '124'
1739: and
1742: 'NJM','NMM','QAK','QBK','QCK','V1P','ZLM','ZRM','ZSK') AND
1743: p_First_Action_NOA_LA_Code2 in
1744: ('ABM','ALM','AQM','A7M','BWM','HAM','LBM','NFM',
1745: 'NJM','NMM','QAK','QBK','QCK','V1P','ZLM','ZRM','ZSK') ) THEN
1746: hr_utility.set_message(8301, 'GHR_37320_ALL_PROCEDURE_FAIL');
1747: hr_utility.set_message_token('LAC_CODE','ABM, ALM, AQM, A7M, BWM, HAM, LBM, NFM, NJM, NMM, QAK, QBK, QCK, V1P, ZLM, ZRM, ZSK.');
1748: hr_utility.raise_error;
1749: end if;
1750: END IF;
1743: p_First_Action_NOA_LA_Code2 in
1744: ('ABM','ALM','AQM','A7M','BWM','HAM','LBM','NFM',
1745: 'NJM','NMM','QAK','QBK','QCK','V1P','ZLM','ZRM','ZSK') ) THEN
1746: hr_utility.set_message(8301, 'GHR_37320_ALL_PROCEDURE_FAIL');
1747: hr_utility.set_message_token('LAC_CODE','ABM, ALM, AQM, A7M, BWM, HAM, LBM, NFM, NJM, NMM, QAK, QBK, QCK, V1P, ZLM, ZRM, ZSK.');
1748: hr_utility.raise_error;
1749: end if;
1750: END IF;
1751:
1744: ('ABM','ALM','AQM','A7M','BWM','HAM','LBM','NFM',
1745: 'NJM','NMM','QAK','QBK','QCK','V1P','ZLM','ZRM','ZSK') ) THEN
1746: hr_utility.set_message(8301, 'GHR_37320_ALL_PROCEDURE_FAIL');
1747: hr_utility.set_message_token('LAC_CODE','ABM, ALM, AQM, A7M, BWM, HAM, LBM, NFM, NJM, NMM, QAK, QBK, QCK, V1P, ZLM, ZRM, ZSK.');
1748: hr_utility.raise_error;
1749: end if;
1750: END IF;
1751:
1752: --275.01.2
1760: 'V1P','V8N','Z2U','ZSK','ZSP') AND
1761: p_First_Action_NOA_LA_Code2 in
1762: ('ABS','ABT','J8M','KTM','KVM','KXM','SZT',
1763: 'V1P','V8N','Z2U','ZSK','ZSP') ) THEN
1764: hr_utility.set_message(8301, 'GHR_37321_ALL_PROCEDURE_FAIL');
1765: hr_utility.raise_error;
1766: end if;
1767: end if;
1768:
1761: p_First_Action_NOA_LA_Code2 in
1762: ('ABS','ABT','J8M','KTM','KVM','KXM','SZT',
1763: 'V1P','V8N','Z2U','ZSK','ZSP') ) THEN
1764: hr_utility.set_message(8301, 'GHR_37321_ALL_PROCEDURE_FAIL');
1765: hr_utility.raise_error;
1766: end if;
1767: end if;
1768:
1769: --275.02.2
1784: 'UDM','V1P','V8N','VGL','Z2U','ZEA','ZSK','ZSP') AND
1785: p_First_Action_NOA_LA_Code2 in
1786: ('ABR','ABS','ABT','J8M','KTM','KVM','KXM','LYP','SZT',
1787: 'UDM','V1P','V8N','VGL','Z2U','ZEA','ZSK','ZSP') ) THEN
1788: hr_utility.set_message(8301, 'GHR_37196_ALL_PROCEDURE_FAIL');
1789: hr_utility.set_message_token('LAC_CODE','ABR, ABS, ABT, J8M, KTM, KVM, KXM, LYP, SZT, UDM, V1P, V8N, VGL, Z2U, ZEA, ZSK, ZSP.');
1790: hr_utility.raise_error;
1791: end if;
1792: elsif p_effective_date >= to_date('19'||'99/11/01','yyyy/mm/dd') then
1785: p_First_Action_NOA_LA_Code2 in
1786: ('ABR','ABS','ABT','J8M','KTM','KVM','KXM','LYP','SZT',
1787: 'UDM','V1P','V8N','VGL','Z2U','ZEA','ZSK','ZSP') ) THEN
1788: hr_utility.set_message(8301, 'GHR_37196_ALL_PROCEDURE_FAIL');
1789: hr_utility.set_message_token('LAC_CODE','ABR, ABS, ABT, J8M, KTM, KVM, KXM, LYP, SZT, UDM, V1P, V8N, VGL, Z2U, ZEA, ZSK, ZSP.');
1790: hr_utility.raise_error;
1791: end if;
1792: elsif p_effective_date >= to_date('19'||'99/11/01','yyyy/mm/dd') then
1793: if p_First_NOAC_Lookup_Code= '130'
1786: ('ABR','ABS','ABT','J8M','KTM','KVM','KXM','LYP','SZT',
1787: 'UDM','V1P','V8N','VGL','Z2U','ZEA','ZSK','ZSP') ) THEN
1788: hr_utility.set_message(8301, 'GHR_37196_ALL_PROCEDURE_FAIL');
1789: hr_utility.set_message_token('LAC_CODE','ABR, ABS, ABT, J8M, KTM, KVM, KXM, LYP, SZT, UDM, V1P, V8N, VGL, Z2U, ZEA, ZSK, ZSP.');
1790: hr_utility.raise_error;
1791: end if;
1792: elsif p_effective_date >= to_date('19'||'99/11/01','yyyy/mm/dd') then
1793: if p_First_NOAC_Lookup_Code= '130'
1794: and
1797: 'UDM','V1P','V8N','VGL','Z2U','ZSK','ZSP') AND
1798: p_First_Action_NOA_LA_Code2 in
1799: ('ABR','ABS','ABT','J8M','KTM','KVM','KXM','SZT',
1800: 'UDM','V1P','V8N','VGL','Z2U','ZSK','ZSP') ) THEN
1801: hr_utility.set_message(8301, 'GHR_37196_ALL_PROCEDURE_FAIL');
1802: hr_utility.set_message_token('LAC_CODE','ABR, ABS, ABT, J8M, KTM, KVM, KXM, SZT, UDM, V1P, V8N, VGL, Z2U, ZSK, ZSP.');
1803: hr_utility.raise_error;
1804: end if;
1805: elsif p_effective_date >= to_date('19'||'99/01/01','yyyy/mm/dd') then
1798: p_First_Action_NOA_LA_Code2 in
1799: ('ABR','ABS','ABT','J8M','KTM','KVM','KXM','SZT',
1800: 'UDM','V1P','V8N','VGL','Z2U','ZSK','ZSP') ) THEN
1801: hr_utility.set_message(8301, 'GHR_37196_ALL_PROCEDURE_FAIL');
1802: hr_utility.set_message_token('LAC_CODE','ABR, ABS, ABT, J8M, KTM, KVM, KXM, SZT, UDM, V1P, V8N, VGL, Z2U, ZSK, ZSP.');
1803: hr_utility.raise_error;
1804: end if;
1805: elsif p_effective_date >= to_date('19'||'99/01/01','yyyy/mm/dd') then
1806: if p_First_NOAC_Lookup_Code= '130'
1799: ('ABR','ABS','ABT','J8M','KTM','KVM','KXM','SZT',
1800: 'UDM','V1P','V8N','VGL','Z2U','ZSK','ZSP') ) THEN
1801: hr_utility.set_message(8301, 'GHR_37196_ALL_PROCEDURE_FAIL');
1802: hr_utility.set_message_token('LAC_CODE','ABR, ABS, ABT, J8M, KTM, KVM, KXM, SZT, UDM, V1P, V8N, VGL, Z2U, ZSK, ZSP.');
1803: hr_utility.raise_error;
1804: end if;
1805: elsif p_effective_date >= to_date('19'||'99/01/01','yyyy/mm/dd') then
1806: if p_First_NOAC_Lookup_Code= '130'
1807: and
1810: 'V1P','V8N','VGL','Z2U','ZSK','ZSP') AND
1811: p_First_Action_NOA_LA_Code2 in
1812: ('ABR','ABS','ABT','J8M','KTM','KVM','KXM','SZT',
1813: 'V1P','V8N','VGL','Z2U','ZSK','ZSP') ) THEN
1814: hr_utility.set_message(8301, 'GHR_37090_ALL_PROCEDURE_FAIL');
1815: hr_utility.raise_error;
1816: end if;
1817: elsif p_effective_date >= to_date('1998/03/01','yyyy/mm/dd') then
1818: if p_First_NOAC_Lookup_Code= '130'
1811: p_First_Action_NOA_LA_Code2 in
1812: ('ABR','ABS','ABT','J8M','KTM','KVM','KXM','SZT',
1813: 'V1P','V8N','VGL','Z2U','ZSK','ZSP') ) THEN
1814: hr_utility.set_message(8301, 'GHR_37090_ALL_PROCEDURE_FAIL');
1815: hr_utility.raise_error;
1816: end if;
1817: elsif p_effective_date >= to_date('1998/03/01','yyyy/mm/dd') then
1818: if p_First_NOAC_Lookup_Code= '130'
1819: and
1822: 'V1P','V8N','Z2U','ZSK','ZSP') AND
1823: p_First_Action_NOA_LA_Code2 in
1824: ('ABR','ABS','ABT','J8M','KTM','KVM','KXM','SZT',
1825: 'V1P','V8N','Z2U','ZSK','ZSP') ) THEN
1826: hr_utility.set_message(8301, 'GHR_37884_ALL_PROCEDURE_FAIL');
1827: hr_utility.raise_error;
1828: end if;
1829: end if;
1830:
1823: p_First_Action_NOA_LA_Code2 in
1824: ('ABR','ABS','ABT','J8M','KTM','KVM','KXM','SZT',
1825: 'V1P','V8N','Z2U','ZSK','ZSP') ) THEN
1826: hr_utility.set_message(8301, 'GHR_37884_ALL_PROCEDURE_FAIL');
1827: hr_utility.raise_error;
1828: end if;
1829: end if;
1830:
1831: --275.04.2
1837: NOT ( p_First_Action_NOA_LA_Code1 in
1838: ('LYP','V1P','V6M','ZLM','ZEA') AND
1839: p_First_Action_NOA_LA_Code2 in
1840: ('LYP','V1P','V6M','ZLM','ZEA') ) THEN
1841: hr_utility.set_message(8301, 'GHR_37322_ALL_PROCEDURE_FAIL');
1842: hr_utility.set_message_token('LAC_CODE','LYP, V1P, V6M, ZEA, ZLM.');
1843: hr_utility.raise_error;
1844: end if;
1845: ELSE
1838: ('LYP','V1P','V6M','ZLM','ZEA') AND
1839: p_First_Action_NOA_LA_Code2 in
1840: ('LYP','V1P','V6M','ZLM','ZEA') ) THEN
1841: hr_utility.set_message(8301, 'GHR_37322_ALL_PROCEDURE_FAIL');
1842: hr_utility.set_message_token('LAC_CODE','LYP, V1P, V6M, ZEA, ZLM.');
1843: hr_utility.raise_error;
1844: end if;
1845: ELSE
1846: if p_First_NOAC_Lookup_Code= '132'
1839: p_First_Action_NOA_LA_Code2 in
1840: ('LYP','V1P','V6M','ZLM','ZEA') ) THEN
1841: hr_utility.set_message(8301, 'GHR_37322_ALL_PROCEDURE_FAIL');
1842: hr_utility.set_message_token('LAC_CODE','LYP, V1P, V6M, ZEA, ZLM.');
1843: hr_utility.raise_error;
1844: end if;
1845: ELSE
1846: if p_First_NOAC_Lookup_Code= '132'
1847: and
1848: NOT ( p_First_Action_NOA_LA_Code1 in
1849: ('V1P','V6M','ZLM') AND
1850: p_First_Action_NOA_LA_Code2 in
1851: ('V1P','V6M','ZLM') ) THEN
1852: hr_utility.set_message(8301, 'GHR_37322_ALL_PROCEDURE_FAIL');
1853: hr_utility.set_message_token('LAC_CODE','V1P, V6M, ZLM.');
1854: hr_utility.raise_error;
1855: end if;
1856: END IF;
1849: ('V1P','V6M','ZLM') AND
1850: p_First_Action_NOA_LA_Code2 in
1851: ('V1P','V6M','ZLM') ) THEN
1852: hr_utility.set_message(8301, 'GHR_37322_ALL_PROCEDURE_FAIL');
1853: hr_utility.set_message_token('LAC_CODE','V1P, V6M, ZLM.');
1854: hr_utility.raise_error;
1855: end if;
1856: END IF;
1857:
1850: p_First_Action_NOA_LA_Code2 in
1851: ('V1P','V6M','ZLM') ) THEN
1852: hr_utility.set_message(8301, 'GHR_37322_ALL_PROCEDURE_FAIL');
1853: hr_utility.set_message_token('LAC_CODE','V1P, V6M, ZLM.');
1854: hr_utility.raise_error;
1855: end if;
1856: END IF;
1857:
1858: --280.02.2
1871: 'NUM','SZW','UDM','V1P','V8N','VGL','Z2U','ZLM','ZSK','ZSP','ZEA') AND
1872: p_First_Action_NOA_LA_Code2 in
1873: ('ABL','ABM','ABR','ABS','BWM','HAM','KQM',
1874: 'NUM','SZW','UDM','V1P','V8N','VGL','Z2U','ZLM','ZSK','ZSP','ZEA') ) THEN
1875: hr_utility.set_message(8301, 'GHR_37197_ALL_PROCEDURE_FAIL');
1876: hr_utility.set_message_token('LAC_CODE','ABL, ABM, ABR, ABS, BWM, HAM, KQM, NUM, SZW, UDM, V1P, V8N, VGL, Z2U, ZEA, ZLM, ZSK, ZSP.');
1877: hr_utility.raise_error;
1878: end if;
1879: elsif p_effective_date >= to_date('19'||'99/11/01','yyyy/mm/dd') then
1872: p_First_Action_NOA_LA_Code2 in
1873: ('ABL','ABM','ABR','ABS','BWM','HAM','KQM',
1874: 'NUM','SZW','UDM','V1P','V8N','VGL','Z2U','ZLM','ZSK','ZSP','ZEA') ) THEN
1875: hr_utility.set_message(8301, 'GHR_37197_ALL_PROCEDURE_FAIL');
1876: hr_utility.set_message_token('LAC_CODE','ABL, ABM, ABR, ABS, BWM, HAM, KQM, NUM, SZW, UDM, V1P, V8N, VGL, Z2U, ZEA, ZLM, ZSK, ZSP.');
1877: hr_utility.raise_error;
1878: end if;
1879: elsif p_effective_date >= to_date('19'||'99/11/01','yyyy/mm/dd') then
1880: if p_First_NOAC_Lookup_Code= '140'
1873: ('ABL','ABM','ABR','ABS','BWM','HAM','KQM',
1874: 'NUM','SZW','UDM','V1P','V8N','VGL','Z2U','ZLM','ZSK','ZSP','ZEA') ) THEN
1875: hr_utility.set_message(8301, 'GHR_37197_ALL_PROCEDURE_FAIL');
1876: hr_utility.set_message_token('LAC_CODE','ABL, ABM, ABR, ABS, BWM, HAM, KQM, NUM, SZW, UDM, V1P, V8N, VGL, Z2U, ZEA, ZLM, ZSK, ZSP.');
1877: hr_utility.raise_error;
1878: end if;
1879: elsif p_effective_date >= to_date('19'||'99/11/01','yyyy/mm/dd') then
1880: if p_First_NOAC_Lookup_Code= '140'
1881: and
1884: 'NUM','SZW','UDM','V1P','V8N','VGL','Z2U','ZLM','ZSK','ZSP') AND
1885: p_First_Action_NOA_LA_Code2 in
1886: ('ABL','ABM','ABR','ABS','BWM','HAM','KQM',
1887: 'NUM','SZW','UDM','V1P','V8N','VGL','Z2U','ZLM','ZSK','ZSP') ) THEN
1888: hr_utility.set_message(8301, 'GHR_37197_ALL_PROCEDURE_FAIL');
1889: hr_utility.set_message_token('LAC_CODE','ABL, ABM, ABR, ABS, BWM, HAM, KQM, NUM, SZW, UDM, V1P, V8N, VGL, Z2U, ZLM, ZSK, ZSP.');
1890: hr_utility.raise_error;
1891: end if;
1892: elsif p_effective_date >= to_date('19'||'99/01/01','yyyy/mm/dd') then
1885: p_First_Action_NOA_LA_Code2 in
1886: ('ABL','ABM','ABR','ABS','BWM','HAM','KQM',
1887: 'NUM','SZW','UDM','V1P','V8N','VGL','Z2U','ZLM','ZSK','ZSP') ) THEN
1888: hr_utility.set_message(8301, 'GHR_37197_ALL_PROCEDURE_FAIL');
1889: hr_utility.set_message_token('LAC_CODE','ABL, ABM, ABR, ABS, BWM, HAM, KQM, NUM, SZW, UDM, V1P, V8N, VGL, Z2U, ZLM, ZSK, ZSP.');
1890: hr_utility.raise_error;
1891: end if;
1892: elsif p_effective_date >= to_date('19'||'99/01/01','yyyy/mm/dd') then
1893: if p_First_NOAC_Lookup_Code= '140'
1886: ('ABL','ABM','ABR','ABS','BWM','HAM','KQM',
1887: 'NUM','SZW','UDM','V1P','V8N','VGL','Z2U','ZLM','ZSK','ZSP') ) THEN
1888: hr_utility.set_message(8301, 'GHR_37197_ALL_PROCEDURE_FAIL');
1889: hr_utility.set_message_token('LAC_CODE','ABL, ABM, ABR, ABS, BWM, HAM, KQM, NUM, SZW, UDM, V1P, V8N, VGL, Z2U, ZLM, ZSK, ZSP.');
1890: hr_utility.raise_error;
1891: end if;
1892: elsif p_effective_date >= to_date('19'||'99/01/01','yyyy/mm/dd') then
1893: if p_First_NOAC_Lookup_Code= '140'
1894: and
1897: 'NUM','SZW','V1P','V8N','VGL','Z2U','ZLM','ZSK','ZSP') AND
1898: p_First_Action_NOA_LA_Code2 in
1899: ('ABL','ABM','ABR','ABS','BWM','HAM','KQM',
1900: 'NUM','SZW','V1P','V8N','VGL','Z2U','ZLM','ZSK','ZSP') ) THEN
1901: hr_utility.set_message(8301, 'GHR_37091_ALL_PROCEDURE_FAIL');
1902: hr_utility.raise_error;
1903: end if;
1904: else
1905: if p_First_NOAC_Lookup_Code= '140'
1898: p_First_Action_NOA_LA_Code2 in
1899: ('ABL','ABM','ABR','ABS','BWM','HAM','KQM',
1900: 'NUM','SZW','V1P','V8N','VGL','Z2U','ZLM','ZSK','ZSP') ) THEN
1901: hr_utility.set_message(8301, 'GHR_37091_ALL_PROCEDURE_FAIL');
1902: hr_utility.raise_error;
1903: end if;
1904: else
1905: if p_First_NOAC_Lookup_Code= '140'
1906: and
1909: 'NUM','SZW','V1P','V8N','Z2U','ZLM','ZSK','ZSP') AND
1910: p_First_Action_NOA_LA_Code2 in
1911: ('ABL','ABM','ABR','ABS','BWM','HAM','KQM',
1912: 'NUM','SZW','V1P','V8N','Z2U','ZLM','ZSK','ZSP') ) THEN
1913: hr_utility.set_message(8301, 'GHR_37323_ALL_PROCEDURE_FAIL');
1914: hr_utility.raise_error;
1915: end if;
1916: end if;
1917:
1910: p_First_Action_NOA_LA_Code2 in
1911: ('ABL','ABM','ABR','ABS','BWM','HAM','KQM',
1912: 'NUM','SZW','V1P','V8N','Z2U','ZLM','ZSK','ZSP') ) THEN
1913: hr_utility.set_message(8301, 'GHR_37323_ALL_PROCEDURE_FAIL');
1914: hr_utility.raise_error;
1915: end if;
1916: end if;
1917:
1918: --280.04.2
1930: 'NUM','UDM','V1P','V8N','VGL','Z2U','ZLM','ZSK','ZSP','ZEA') AND
1931: p_First_Action_NOA_LA_Code2 in
1932: ('ABL','ABM','ABR','ABS','BWM','HAM','KQM',
1933: 'NUM','UDM','V1P','V8N','VGL','Z2U','ZLM','ZSK','ZSP','ZEA') ) THEN
1934: hr_utility.set_message(8301, 'GHR_37198_ALL_PROCEDURE_FAIL');
1935: hr_utility.set_message_token('LAC_CODE','ABL, ABM, ABR, ABS, BWM, HAM, KQM, NUM, UDM, V1P, V8N, VGL, Z2U, ZEA, ZLM, ZSK, ZSP.');
1936: hr_utility.raise_error;
1937: end if;
1938: elsif p_effective_date >= to_date('19'||'99/11/01','yyyy/mm/dd') then
1931: p_First_Action_NOA_LA_Code2 in
1932: ('ABL','ABM','ABR','ABS','BWM','HAM','KQM',
1933: 'NUM','UDM','V1P','V8N','VGL','Z2U','ZLM','ZSK','ZSP','ZEA') ) THEN
1934: hr_utility.set_message(8301, 'GHR_37198_ALL_PROCEDURE_FAIL');
1935: hr_utility.set_message_token('LAC_CODE','ABL, ABM, ABR, ABS, BWM, HAM, KQM, NUM, UDM, V1P, V8N, VGL, Z2U, ZEA, ZLM, ZSK, ZSP.');
1936: hr_utility.raise_error;
1937: end if;
1938: elsif p_effective_date >= to_date('19'||'99/11/01','yyyy/mm/dd') then
1939: if p_First_NOAC_Lookup_Code= '141'
1932: ('ABL','ABM','ABR','ABS','BWM','HAM','KQM',
1933: 'NUM','UDM','V1P','V8N','VGL','Z2U','ZLM','ZSK','ZSP','ZEA') ) THEN
1934: hr_utility.set_message(8301, 'GHR_37198_ALL_PROCEDURE_FAIL');
1935: hr_utility.set_message_token('LAC_CODE','ABL, ABM, ABR, ABS, BWM, HAM, KQM, NUM, UDM, V1P, V8N, VGL, Z2U, ZEA, ZLM, ZSK, ZSP.');
1936: hr_utility.raise_error;
1937: end if;
1938: elsif p_effective_date >= to_date('19'||'99/11/01','yyyy/mm/dd') then
1939: if p_First_NOAC_Lookup_Code= '141'
1940: and
1943: 'NUM','UDM','V1P','V8N','VGL','Z2U','ZLM','ZSK','ZSP') AND
1944: p_First_Action_NOA_LA_Code2 in
1945: ('ABL','ABM','ABR','ABS','BWM','HAM','KQM',
1946: 'NUM','UDM','V1P','V8N','VGL','Z2U','ZLM','ZSK','ZSP') ) THEN
1947: hr_utility.set_message(8301, 'GHR_37198_ALL_PROCEDURE_FAIL');
1948: hr_utility.set_message_token('LAC_CODE','ABL, ABM, ABR, ABS, BWM, HAM, KQM, NUM, UDM, V1P, V8N, VGL, Z2U, ZLM, ZSK, ZSP.');
1949: hr_utility.raise_error;
1950: end if;
1951: elsif p_effective_date >= to_date('19'||'99/01/01','yyyy/mm/dd') then
1944: p_First_Action_NOA_LA_Code2 in
1945: ('ABL','ABM','ABR','ABS','BWM','HAM','KQM',
1946: 'NUM','UDM','V1P','V8N','VGL','Z2U','ZLM','ZSK','ZSP') ) THEN
1947: hr_utility.set_message(8301, 'GHR_37198_ALL_PROCEDURE_FAIL');
1948: hr_utility.set_message_token('LAC_CODE','ABL, ABM, ABR, ABS, BWM, HAM, KQM, NUM, UDM, V1P, V8N, VGL, Z2U, ZLM, ZSK, ZSP.');
1949: hr_utility.raise_error;
1950: end if;
1951: elsif p_effective_date >= to_date('19'||'99/01/01','yyyy/mm/dd') then
1952: if p_First_NOAC_Lookup_Code= '141'
1945: ('ABL','ABM','ABR','ABS','BWM','HAM','KQM',
1946: 'NUM','UDM','V1P','V8N','VGL','Z2U','ZLM','ZSK','ZSP') ) THEN
1947: hr_utility.set_message(8301, 'GHR_37198_ALL_PROCEDURE_FAIL');
1948: hr_utility.set_message_token('LAC_CODE','ABL, ABM, ABR, ABS, BWM, HAM, KQM, NUM, UDM, V1P, V8N, VGL, Z2U, ZLM, ZSK, ZSP.');
1949: hr_utility.raise_error;
1950: end if;
1951: elsif p_effective_date >= to_date('19'||'99/01/01','yyyy/mm/dd') then
1952: if p_First_NOAC_Lookup_Code= '141'
1953: and
1956: 'NUM','V1P','V8N','VGL','Z2U','ZLM','ZSK','ZSP') AND
1957: p_First_Action_NOA_LA_Code2 in
1958: ('ABL','ABM','ABR','ABS','BWM','HAM','KQM',
1959: 'NUM','V1P','V8N','VGL','Z2U','ZLM','ZSK','ZSP') ) THEN
1960: hr_utility.set_message(8301, 'GHR_37092_ALL_PROCEDURE_FAIL');
1961: hr_utility.raise_error;
1962: end if;
1963: else
1964: if p_First_NOAC_Lookup_Code= '141'
1957: p_First_Action_NOA_LA_Code2 in
1958: ('ABL','ABM','ABR','ABS','BWM','HAM','KQM',
1959: 'NUM','V1P','V8N','VGL','Z2U','ZLM','ZSK','ZSP') ) THEN
1960: hr_utility.set_message(8301, 'GHR_37092_ALL_PROCEDURE_FAIL');
1961: hr_utility.raise_error;
1962: end if;
1963: else
1964: if p_First_NOAC_Lookup_Code= '141'
1965: and
1968: 'NUM','V1P','V8N','Z2U','ZLM','ZSK','ZSP') AND
1969: p_First_Action_NOA_LA_Code2 in
1970: ('ABL','ABM','ABR','ABS','BWM','HAM','KQM',
1971: 'NUM','V1P','V8N','Z2U','ZLM','ZSK','ZSP') ) THEN
1972: hr_utility.set_message(8301, 'GHR_37324_ALL_PROCEDURE_FAIL');
1973: hr_utility.raise_error;
1974: end if;
1975: end if;
1976:
1969: p_First_Action_NOA_LA_Code2 in
1970: ('ABL','ABM','ABR','ABS','BWM','HAM','KQM',
1971: 'NUM','V1P','V8N','Z2U','ZLM','ZSK','ZSP') ) THEN
1972: hr_utility.set_message(8301, 'GHR_37324_ALL_PROCEDURE_FAIL');
1973: hr_utility.raise_error;
1974: end if;
1975: end if;
1976:
1977: --280.07.2
1989: 'ZLM','ZSK','ZVB','ZVC') AND
1990: p_First_Action_NOA_LA_Code2 in
1991: ('HAM','P3M','P5M','QAK','UFM','V2M','ZJR',
1992: 'ZLM','ZSK','ZVB','ZVC') ) THEN
1993: hr_utility.set_message(8301, 'GHR_37325_ALL_PROCEDURE_FAIL');
1994: hr_utility.raise_error;
1995: end if;
1996: elsif p_effective_date < to_date('2001/11/01','yyyy/mm/dd') then
1997: if p_First_NOAC_Lookup_Code= '142'
1990: p_First_Action_NOA_LA_Code2 in
1991: ('HAM','P3M','P5M','QAK','UFM','V2M','ZJR',
1992: 'ZLM','ZSK','ZVB','ZVC') ) THEN
1993: hr_utility.set_message(8301, 'GHR_37325_ALL_PROCEDURE_FAIL');
1994: hr_utility.raise_error;
1995: end if;
1996: elsif p_effective_date < to_date('2001/11/01','yyyy/mm/dd') then
1997: if p_First_NOAC_Lookup_Code= '142'
1998: and
2001: 'ZLM','ZSK','ZVB','ZVC') AND
2002: p_First_Action_NOA_LA_Code2 in
2003: ('HAM','P2M','P3M','P5M','P7M','QAK','UFM','V2M','ZJR',
2004: 'ZLM','ZSK','ZVB','ZVC','QAK') ) THEN
2005: hr_utility.set_message(8301, 'GHR_37036_ALL_PROCEDURE_FAIL');
2006: hr_utility.raise_error;
2007: end if;
2008: elsif p_effective_date < to_date('2009/02/17','yyyy/mm/dd') then
2009: if p_First_NOAC_Lookup_Code= '142'
2002: p_First_Action_NOA_LA_Code2 in
2003: ('HAM','P2M','P3M','P5M','P7M','QAK','UFM','V2M','ZJR',
2004: 'ZLM','ZSK','ZVB','ZVC','QAK') ) THEN
2005: hr_utility.set_message(8301, 'GHR_37036_ALL_PROCEDURE_FAIL');
2006: hr_utility.raise_error;
2007: end if;
2008: elsif p_effective_date < to_date('2009/02/17','yyyy/mm/dd') then
2009: if p_First_NOAC_Lookup_Code= '142'
2010: and
2013: 'ZLM','ZSK','ZVB','ZVC') AND
2014: p_First_Action_NOA_LA_Code2 in
2015: ('HAM','P2M','P3M','P5M','P7M','QAK','UFM','V2M','ZJR',
2016: 'ZLM','ZSK','ZVB','ZVC') ) THEN
2017: hr_utility.set_message(8301, 'GHR_37906_ALL_PROCEDURE_FAIL');
2018: hr_utility.set_message_token('LAC_CODE','HAM, P2M, P3M, P5M, P7M, QAK, UFM, V2M, ZJR, ZLM, ZSK, ZVB or ZVC.');
2019: hr_utility.raise_error;
2020: end if;
2021: else
2014: p_First_Action_NOA_LA_Code2 in
2015: ('HAM','P2M','P3M','P5M','P7M','QAK','UFM','V2M','ZJR',
2016: 'ZLM','ZSK','ZVB','ZVC') ) THEN
2017: hr_utility.set_message(8301, 'GHR_37906_ALL_PROCEDURE_FAIL');
2018: hr_utility.set_message_token('LAC_CODE','HAM, P2M, P3M, P5M, P7M, QAK, UFM, V2M, ZJR, ZLM, ZSK, ZVB or ZVC.');
2019: hr_utility.raise_error;
2020: end if;
2021: else
2022: if p_First_NOAC_Lookup_Code= '142'
2015: ('HAM','P2M','P3M','P5M','P7M','QAK','UFM','V2M','ZJR',
2016: 'ZLM','ZSK','ZVB','ZVC') ) THEN
2017: hr_utility.set_message(8301, 'GHR_37906_ALL_PROCEDURE_FAIL');
2018: hr_utility.set_message_token('LAC_CODE','HAM, P2M, P3M, P5M, P7M, QAK, UFM, V2M, ZJR, ZLM, ZSK, ZVB or ZVC.');
2019: hr_utility.raise_error;
2020: end if;
2021: else
2022: if p_First_NOAC_Lookup_Code= '142'
2023: and
2026: 'ZLM','ZSK','ZVB','ZVC','ZEA') AND
2027: p_First_Action_NOA_LA_Code2 in
2028: ('HAM','P2M','P3M','P5M','P7M','QAK','UFM','V2M','ZJR',
2029: 'ZLM','ZSK','ZVB','ZVC','ZEA') ) THEN
2030: hr_utility.set_message(8301, 'GHR_37906_ALL_PROCEDURE_FAIL');
2031: hr_utility.set_message_token('LAC_CODE','HAM, P2M, P3M, P5M, P7M, QAK, UFM, V2M, ZEA, ZJR, ZLM, ZSK, ZVB or ZVC.');
2032: hr_utility.raise_error;
2033: end if;
2034: end if;
2027: p_First_Action_NOA_LA_Code2 in
2028: ('HAM','P2M','P3M','P5M','P7M','QAK','UFM','V2M','ZJR',
2029: 'ZLM','ZSK','ZVB','ZVC','ZEA') ) THEN
2030: hr_utility.set_message(8301, 'GHR_37906_ALL_PROCEDURE_FAIL');
2031: hr_utility.set_message_token('LAC_CODE','HAM, P2M, P3M, P5M, P7M, QAK, UFM, V2M, ZEA, ZJR, ZLM, ZSK, ZVB or ZVC.');
2032: hr_utility.raise_error;
2033: end if;
2034: end if;
2035:
2028: ('HAM','P2M','P3M','P5M','P7M','QAK','UFM','V2M','ZJR',
2029: 'ZLM','ZSK','ZVB','ZVC','ZEA') ) THEN
2030: hr_utility.set_message(8301, 'GHR_37906_ALL_PROCEDURE_FAIL');
2031: hr_utility.set_message_token('LAC_CODE','HAM, P2M, P3M, P5M, P7M, QAK, UFM, V2M, ZEA, ZJR, ZLM, ZSK, ZVB or ZVC.');
2032: hr_utility.raise_error;
2033: end if;
2034: end if;
2035:
2036: --280.10.2
2045: 'ZLM','ZSK','ZVB','ZVC') AND
2046: p_First_Action_NOA_LA_Code2 in
2047: ('HAM','UFM','VBJ','VCJ',
2048: 'ZLM','ZSK','ZVB','ZVC') ) THEN
2049: hr_utility.set_message(8301, 'GHR_37326_ALL_PROCEDURE_FAIL');
2050: hr_utility.raise_error;
2051: end if;
2052: elsif p_effective_date < to_date('2009/02/17','yyyy/mm/dd') then
2053: if p_First_NOAC_Lookup_Code= '143'
2046: p_First_Action_NOA_LA_Code2 in
2047: ('HAM','UFM','VBJ','VCJ',
2048: 'ZLM','ZSK','ZVB','ZVC') ) THEN
2049: hr_utility.set_message(8301, 'GHR_37326_ALL_PROCEDURE_FAIL');
2050: hr_utility.raise_error;
2051: end if;
2052: elsif p_effective_date < to_date('2009/02/17','yyyy/mm/dd') then
2053: if p_First_NOAC_Lookup_Code= '143'
2054: and
2057: 'ZLM','ZSK','ZVB','ZVC') AND
2058: p_First_Action_NOA_LA_Code2 in
2059: ('HAM','UFM','VBJ','VCJ',
2060: 'ZLM','ZSK','ZVB','ZVC') ) THEN
2061: hr_utility.set_message(8301, 'GHR_37905_ALL_PROCEDURE_FAIL');
2062: hr_utility.set_message_token('LAC_CODE','HAM, UFM, VBJ, VCJ, ZLM, ZSK, ZVB, ZVC.');
2063: hr_utility.raise_error;
2064: end if;
2065: else
2058: p_First_Action_NOA_LA_Code2 in
2059: ('HAM','UFM','VBJ','VCJ',
2060: 'ZLM','ZSK','ZVB','ZVC') ) THEN
2061: hr_utility.set_message(8301, 'GHR_37905_ALL_PROCEDURE_FAIL');
2062: hr_utility.set_message_token('LAC_CODE','HAM, UFM, VBJ, VCJ, ZLM, ZSK, ZVB, ZVC.');
2063: hr_utility.raise_error;
2064: end if;
2065: else
2066: if p_First_NOAC_Lookup_Code= '143'
2059: ('HAM','UFM','VBJ','VCJ',
2060: 'ZLM','ZSK','ZVB','ZVC') ) THEN
2061: hr_utility.set_message(8301, 'GHR_37905_ALL_PROCEDURE_FAIL');
2062: hr_utility.set_message_token('LAC_CODE','HAM, UFM, VBJ, VCJ, ZLM, ZSK, ZVB, ZVC.');
2063: hr_utility.raise_error;
2064: end if;
2065: else
2066: if p_First_NOAC_Lookup_Code= '143'
2067: and
2070: 'ZLM','ZSK','ZVB','ZVC','ZEA') AND
2071: p_First_Action_NOA_LA_Code2 in
2072: ('HAM','UFM','VBJ','VCJ',
2073: 'ZLM','ZSK','ZVB','ZVC','ZEA') ) THEN
2074: hr_utility.set_message(8301, 'GHR_37905_ALL_PROCEDURE_FAIL');
2075: hr_utility.set_message_token('LAC_CODE','HAM, UFM, VBJ, VCJ, ZEA, ZLM, ZSK, ZVB, ZVC.');
2076: hr_utility.raise_error;
2077: end if;
2078: end if;
2071: p_First_Action_NOA_LA_Code2 in
2072: ('HAM','UFM','VBJ','VCJ',
2073: 'ZLM','ZSK','ZVB','ZVC','ZEA') ) THEN
2074: hr_utility.set_message(8301, 'GHR_37905_ALL_PROCEDURE_FAIL');
2075: hr_utility.set_message_token('LAC_CODE','HAM, UFM, VBJ, VCJ, ZEA, ZLM, ZSK, ZVB, ZVC.');
2076: hr_utility.raise_error;
2077: end if;
2078: end if;
2079:
2072: ('HAM','UFM','VBJ','VCJ',
2073: 'ZLM','ZSK','ZVB','ZVC','ZEA') ) THEN
2074: hr_utility.set_message(8301, 'GHR_37905_ALL_PROCEDURE_FAIL');
2075: hr_utility.set_message_token('LAC_CODE','HAM, UFM, VBJ, VCJ, ZEA, ZLM, ZSK, ZVB, ZVC.');
2076: hr_utility.raise_error;
2077: end if;
2078: end if;
2079:
2080: --280.13.2
2088: 'ZLM','ZSK','ZVB','ZVC') AND
2089: p_First_Action_NOA_LA_Code2 in
2090: ('HAM','UFM','V6M',
2091: 'ZLM','ZSK','ZVB','ZVC') ) THEN
2092: hr_utility.set_message(8301, 'GHR_37327_ALL_PROCEDURE_FAIL');
2093: hr_utility.raise_error;
2094: end if;
2095: elsif p_effective_date < to_date('2009/02/17','yyyy/mm/dd') then
2096: if p_First_NOAC_Lookup_Code= '145'
2089: p_First_Action_NOA_LA_Code2 in
2090: ('HAM','UFM','V6M',
2091: 'ZLM','ZSK','ZVB','ZVC') ) THEN
2092: hr_utility.set_message(8301, 'GHR_37327_ALL_PROCEDURE_FAIL');
2093: hr_utility.raise_error;
2094: end if;
2095: elsif p_effective_date < to_date('2009/02/17','yyyy/mm/dd') then
2096: if p_First_NOAC_Lookup_Code= '145'
2097: and
2100: 'ZLM','ZSK','ZVB','ZVC') AND
2101: p_First_Action_NOA_LA_Code2 in
2102: ('HAM','UFM','V6M',
2103: 'ZLM','ZSK','ZVB','ZVC') ) THEN
2104: hr_utility.set_message(8301, 'GHR_37904_ALL_PROCEDURE_FAIL');
2105: hr_utility.set_message_token('LAC_CODE','HAM, UFM, V6M, ZLM, ZSK, ZVB,ZVC.');
2106: hr_utility.raise_error;
2107: end if;
2108: else
2101: p_First_Action_NOA_LA_Code2 in
2102: ('HAM','UFM','V6M',
2103: 'ZLM','ZSK','ZVB','ZVC') ) THEN
2104: hr_utility.set_message(8301, 'GHR_37904_ALL_PROCEDURE_FAIL');
2105: hr_utility.set_message_token('LAC_CODE','HAM, UFM, V6M, ZLM, ZSK, ZVB,ZVC.');
2106: hr_utility.raise_error;
2107: end if;
2108: else
2109: if p_First_NOAC_Lookup_Code= '145'
2102: ('HAM','UFM','V6M',
2103: 'ZLM','ZSK','ZVB','ZVC') ) THEN
2104: hr_utility.set_message(8301, 'GHR_37904_ALL_PROCEDURE_FAIL');
2105: hr_utility.set_message_token('LAC_CODE','HAM, UFM, V6M, ZLM, ZSK, ZVB,ZVC.');
2106: hr_utility.raise_error;
2107: end if;
2108: else
2109: if p_First_NOAC_Lookup_Code= '145'
2110: and
2113: 'ZLM','ZSK','ZVB','ZVC','ZEA') AND
2114: p_First_Action_NOA_LA_Code2 in
2115: ('HAM','UFM','V6M',
2116: 'ZLM','ZSK','ZVB','ZVC','ZEA') ) THEN
2117: hr_utility.set_message(8301, 'GHR_37904_ALL_PROCEDURE_FAIL');
2118: hr_utility.set_message_token('LAC_CODE','HAM, UFM, V6M, ZEA, ZLM, ZSK, ZVB,ZVC.');
2119: hr_utility.raise_error;
2120: end if;
2121: end if;
2114: p_First_Action_NOA_LA_Code2 in
2115: ('HAM','UFM','V6M',
2116: 'ZLM','ZSK','ZVB','ZVC','ZEA') ) THEN
2117: hr_utility.set_message(8301, 'GHR_37904_ALL_PROCEDURE_FAIL');
2118: hr_utility.set_message_token('LAC_CODE','HAM, UFM, V6M, ZEA, ZLM, ZSK, ZVB,ZVC.');
2119: hr_utility.raise_error;
2120: end if;
2121: end if;
2122:
2115: ('HAM','UFM','V6M',
2116: 'ZLM','ZSK','ZVB','ZVC','ZEA') ) THEN
2117: hr_utility.set_message(8301, 'GHR_37904_ALL_PROCEDURE_FAIL');
2118: hr_utility.set_message_token('LAC_CODE','HAM, UFM, V6M, ZEA, ZLM, ZSK, ZVB,ZVC.');
2119: hr_utility.raise_error;
2120: end if;
2121: end if;
2122:
2123:
2134: 'ZLM','ZSK','ZVB','ZVC','ZEA') AND
2135: p_First_Action_NOA_LA_Code2 in
2136: ('AWM','HAM','QAK','UFM','V4L','ZJR',
2137: 'ZLM','ZSK','ZVB','ZVC','ZEA') ) THEN
2138: hr_utility.set_message(8301, 'GHR_37328_ALL_PROCEDURE_FAIL');
2139: hr_utility.set_message_token('LAC_CODE','AWM, HAM, QAK, UFM, V4L, ZEA, ZJR, ZLM, ZSK, ZVB, or ZVC.');
2140: hr_utility.raise_error;
2141: end if;
2142: ELSE
2135: p_First_Action_NOA_LA_Code2 in
2136: ('AWM','HAM','QAK','UFM','V4L','ZJR',
2137: 'ZLM','ZSK','ZVB','ZVC','ZEA') ) THEN
2138: hr_utility.set_message(8301, 'GHR_37328_ALL_PROCEDURE_FAIL');
2139: hr_utility.set_message_token('LAC_CODE','AWM, HAM, QAK, UFM, V4L, ZEA, ZJR, ZLM, ZSK, ZVB, or ZVC.');
2140: hr_utility.raise_error;
2141: end if;
2142: ELSE
2143: if p_First_NOAC_Lookup_Code= '146'
2136: ('AWM','HAM','QAK','UFM','V4L','ZJR',
2137: 'ZLM','ZSK','ZVB','ZVC','ZEA') ) THEN
2138: hr_utility.set_message(8301, 'GHR_37328_ALL_PROCEDURE_FAIL');
2139: hr_utility.set_message_token('LAC_CODE','AWM, HAM, QAK, UFM, V4L, ZEA, ZJR, ZLM, ZSK, ZVB, or ZVC.');
2140: hr_utility.raise_error;
2141: end if;
2142: ELSE
2143: if p_First_NOAC_Lookup_Code= '146'
2144: and
2147: 'ZLM','ZSK','ZVB','ZVC') AND
2148: p_First_Action_NOA_LA_Code2 in
2149: ('AWM','HAM','QAK','UFM','V4L','ZJR',
2150: 'ZLM','ZSK','ZVB','ZVC') ) THEN
2151: hr_utility.set_message(8301, 'GHR_37328_ALL_PROCEDURE_FAIL');
2152: hr_utility.set_message_token('LAC_CODE','AWM, HAM, QAK, UFM, V4L, ZJR, ZLM, ZSK, ZVB, or ZVC.');
2153: hr_utility.raise_error;
2154: end if;
2155: END IF;
2148: p_First_Action_NOA_LA_Code2 in
2149: ('AWM','HAM','QAK','UFM','V4L','ZJR',
2150: 'ZLM','ZSK','ZVB','ZVC') ) THEN
2151: hr_utility.set_message(8301, 'GHR_37328_ALL_PROCEDURE_FAIL');
2152: hr_utility.set_message_token('LAC_CODE','AWM, HAM, QAK, UFM, V4L, ZJR, ZLM, ZSK, ZVB, or ZVC.');
2153: hr_utility.raise_error;
2154: end if;
2155: END IF;
2156:
2149: ('AWM','HAM','QAK','UFM','V4L','ZJR',
2150: 'ZLM','ZSK','ZVB','ZVC') ) THEN
2151: hr_utility.set_message(8301, 'GHR_37328_ALL_PROCEDURE_FAIL');
2152: hr_utility.set_message_token('LAC_CODE','AWM, HAM, QAK, UFM, V4L, ZJR, ZLM, ZSK, ZVB, or ZVC.');
2153: hr_utility.raise_error;
2154: end if;
2155: END IF;
2156:
2157: --280.19.2
2165: 'ZLM','ZSK','ZVB','ZVC','ZEA') AND
2166: p_First_Action_NOA_LA_Code2 in
2167: ('AWM','HAM','UFM','VAG',
2168: 'ZLM','ZSK','ZVB','ZVC','ZEA') ) THEN
2169: hr_utility.set_message(8301, 'GHR_37329_ALL_PROCEDURE_FAIL');
2170: hr_utility.set_message_token('LAC_CODE','AWM, HAM, UFM, VAG, ZEA, ZLM, ZSK, ZVB,ZVC.');
2171: hr_utility.raise_error;
2172: end if;
2173: ELSE
2166: p_First_Action_NOA_LA_Code2 in
2167: ('AWM','HAM','UFM','VAG',
2168: 'ZLM','ZSK','ZVB','ZVC','ZEA') ) THEN
2169: hr_utility.set_message(8301, 'GHR_37329_ALL_PROCEDURE_FAIL');
2170: hr_utility.set_message_token('LAC_CODE','AWM, HAM, UFM, VAG, ZEA, ZLM, ZSK, ZVB,ZVC.');
2171: hr_utility.raise_error;
2172: end if;
2173: ELSE
2174: if p_First_NOAC_Lookup_Code= '147'
2167: ('AWM','HAM','UFM','VAG',
2168: 'ZLM','ZSK','ZVB','ZVC','ZEA') ) THEN
2169: hr_utility.set_message(8301, 'GHR_37329_ALL_PROCEDURE_FAIL');
2170: hr_utility.set_message_token('LAC_CODE','AWM, HAM, UFM, VAG, ZEA, ZLM, ZSK, ZVB,ZVC.');
2171: hr_utility.raise_error;
2172: end if;
2173: ELSE
2174: if p_First_NOAC_Lookup_Code= '147'
2175: and
2178: 'ZLM','ZSK','ZVB','ZVC') AND
2179: p_First_Action_NOA_LA_Code2 in
2180: ('AWM','HAM','UFM','VAG',
2181: 'ZLM','ZSK','ZVB','ZVC') ) THEN
2182: hr_utility.set_message(8301, 'GHR_37329_ALL_PROCEDURE_FAIL');
2183: hr_utility.set_message_token('LAC_CODE','AWM, HAM, UFM, VAG, ZLM, ZSK, ZVB,ZVC.');
2184: hr_utility.raise_error;
2185: end if;
2186: END IF;
2179: p_First_Action_NOA_LA_Code2 in
2180: ('AWM','HAM','UFM','VAG',
2181: 'ZLM','ZSK','ZVB','ZVC') ) THEN
2182: hr_utility.set_message(8301, 'GHR_37329_ALL_PROCEDURE_FAIL');
2183: hr_utility.set_message_token('LAC_CODE','AWM, HAM, UFM, VAG, ZLM, ZSK, ZVB,ZVC.');
2184: hr_utility.raise_error;
2185: end if;
2186: END IF;
2187:
2180: ('AWM','HAM','UFM','VAG',
2181: 'ZLM','ZSK','ZVB','ZVC') ) THEN
2182: hr_utility.set_message(8301, 'GHR_37329_ALL_PROCEDURE_FAIL');
2183: hr_utility.set_message_token('LAC_CODE','AWM, HAM, UFM, VAG, ZLM, ZSK, ZVB,ZVC.');
2184: hr_utility.raise_error;
2185: end if;
2186: END IF;
2187:
2188: --280.22.2
2198: 'ZLM','ZSK','ZVB','ZVC','ZEA') AND
2199: p_First_Action_NOA_LA_Code2 in
2200: ('AWM','HAM','QAK','UFM','V4M',
2201: 'ZLM','ZSK','ZVB','ZVC','ZEA') ) THEN
2202: hr_utility.set_message(8301, 'GHR_37330_ALL_PROCEDURE_FAIL');
2203: hr_utility.set_message_token('LAC_CODE','AWM, HAM, QAK, UFM, V4M, ZEA, ZLM, ZSK, ZVB,ZVC.');
2204: hr_utility.raise_error;
2205: end if;
2206: ELSE
2199: p_First_Action_NOA_LA_Code2 in
2200: ('AWM','HAM','QAK','UFM','V4M',
2201: 'ZLM','ZSK','ZVB','ZVC','ZEA') ) THEN
2202: hr_utility.set_message(8301, 'GHR_37330_ALL_PROCEDURE_FAIL');
2203: hr_utility.set_message_token('LAC_CODE','AWM, HAM, QAK, UFM, V4M, ZEA, ZLM, ZSK, ZVB,ZVC.');
2204: hr_utility.raise_error;
2205: end if;
2206: ELSE
2207: if p_First_NOAC_Lookup_Code= '148'
2200: ('AWM','HAM','QAK','UFM','V4M',
2201: 'ZLM','ZSK','ZVB','ZVC','ZEA') ) THEN
2202: hr_utility.set_message(8301, 'GHR_37330_ALL_PROCEDURE_FAIL');
2203: hr_utility.set_message_token('LAC_CODE','AWM, HAM, QAK, UFM, V4M, ZEA, ZLM, ZSK, ZVB,ZVC.');
2204: hr_utility.raise_error;
2205: end if;
2206: ELSE
2207: if p_First_NOAC_Lookup_Code= '148'
2208: and
2211: 'ZLM','ZSK','ZVB','ZVC') AND
2212: p_First_Action_NOA_LA_Code2 in
2213: ('AWM','HAM','QAK','UFM','V4M',
2214: 'ZLM','ZSK','ZVB','ZVC') ) THEN
2215: hr_utility.set_message(8301, 'GHR_37330_ALL_PROCEDURE_FAIL');
2216: hr_utility.set_message_token('LAC_CODE','AWM, HAM, QAK, UFM, V4M, ZLM, ZSK, ZVB,ZVC.');
2217: hr_utility.raise_error;
2218: end if;
2219: END IF;
2212: p_First_Action_NOA_LA_Code2 in
2213: ('AWM','HAM','QAK','UFM','V4M',
2214: 'ZLM','ZSK','ZVB','ZVC') ) THEN
2215: hr_utility.set_message(8301, 'GHR_37330_ALL_PROCEDURE_FAIL');
2216: hr_utility.set_message_token('LAC_CODE','AWM, HAM, QAK, UFM, V4M, ZLM, ZSK, ZVB,ZVC.');
2217: hr_utility.raise_error;
2218: end if;
2219: END IF;
2220:
2213: ('AWM','HAM','QAK','UFM','V4M',
2214: 'ZLM','ZSK','ZVB','ZVC') ) THEN
2215: hr_utility.set_message(8301, 'GHR_37330_ALL_PROCEDURE_FAIL');
2216: hr_utility.set_message_token('LAC_CODE','AWM, HAM, QAK, UFM, V4M, ZLM, ZSK, ZVB,ZVC.');
2217: hr_utility.raise_error;
2218: end if;
2219: END IF;
2220:
2221: --280.25.2
2230: 'ZLM','ZSK','ZVB','ZVC','ZEA') AND
2231: p_First_Action_NOA_LA_Code2 in
2232: ('AWM','HAM','UFM','V4P',
2233: 'ZLM','ZSK','ZVB','ZVC','ZEA') ) THEN
2234: hr_utility.set_message(8301, 'GHR_37331_ALL_PROCEDURE_FAIL');
2235: hr_utility.set_message_token('LAC_CODE','AWM, HAM, UFM, V4P, ZEA, ZLM, ZSK, ZVB,ZVC.');
2236: hr_utility.raise_error;
2237: end if;
2238: ELSE
2231: p_First_Action_NOA_LA_Code2 in
2232: ('AWM','HAM','UFM','V4P',
2233: 'ZLM','ZSK','ZVB','ZVC','ZEA') ) THEN
2234: hr_utility.set_message(8301, 'GHR_37331_ALL_PROCEDURE_FAIL');
2235: hr_utility.set_message_token('LAC_CODE','AWM, HAM, UFM, V4P, ZEA, ZLM, ZSK, ZVB,ZVC.');
2236: hr_utility.raise_error;
2237: end if;
2238: ELSE
2239: if p_First_NOAC_Lookup_Code= '149'
2232: ('AWM','HAM','UFM','V4P',
2233: 'ZLM','ZSK','ZVB','ZVC','ZEA') ) THEN
2234: hr_utility.set_message(8301, 'GHR_37331_ALL_PROCEDURE_FAIL');
2235: hr_utility.set_message_token('LAC_CODE','AWM, HAM, UFM, V4P, ZEA, ZLM, ZSK, ZVB,ZVC.');
2236: hr_utility.raise_error;
2237: end if;
2238: ELSE
2239: if p_First_NOAC_Lookup_Code= '149'
2240: and
2243: 'ZLM','ZSK','ZVB','ZVC') AND
2244: p_First_Action_NOA_LA_Code2 in
2245: ('AWM','HAM','UFM','V4P',
2246: 'ZLM','ZSK','ZVB','ZVC') ) THEN
2247: hr_utility.set_message(8301, 'GHR_37331_ALL_PROCEDURE_FAIL');
2248: hr_utility.set_message_token('LAC_CODE','AWM, HAM, UFM, V4P, ZLM, ZSK, ZVB,ZVC.');
2249: hr_utility.raise_error;
2250: end if;
2251: END IF;
2244: p_First_Action_NOA_LA_Code2 in
2245: ('AWM','HAM','UFM','V4P',
2246: 'ZLM','ZSK','ZVB','ZVC') ) THEN
2247: hr_utility.set_message(8301, 'GHR_37331_ALL_PROCEDURE_FAIL');
2248: hr_utility.set_message_token('LAC_CODE','AWM, HAM, UFM, V4P, ZLM, ZSK, ZVB,ZVC.');
2249: hr_utility.raise_error;
2250: end if;
2251: END IF;
2252:
2245: ('AWM','HAM','UFM','V4P',
2246: 'ZLM','ZSK','ZVB','ZVC') ) THEN
2247: hr_utility.set_message(8301, 'GHR_37331_ALL_PROCEDURE_FAIL');
2248: hr_utility.set_message_token('LAC_CODE','AWM, HAM, UFM, V4P, ZLM, ZSK, ZVB,ZVC.');
2249: hr_utility.raise_error;
2250: end if;
2251: END IF;
2252:
2253: /* Commented -- Dec 2001 Patch
2260: 'ZLM','ZRM','ZSK') AND
2261: p_First_Action_NOA_LA_Code2 in
2262: ('ALM','AQM','HAM','PWM','P3M','P5M','QAK','QBK','QCK','TJK','TRK','ZJR',
2263: 'ZLM','ZRM','ZSK') ) THEN
2264: hr_utility.set_message(8301, 'GHR_37332_ALL_PROCEDURE_FAIL');
2265: hr_utility.raise_error;
2266: end if;
2267: */
2268:
2261: p_First_Action_NOA_LA_Code2 in
2262: ('ALM','AQM','HAM','PWM','P3M','P5M','QAK','QBK','QCK','TJK','TRK','ZJR',
2263: 'ZLM','ZRM','ZSK') ) THEN
2264: hr_utility.set_message(8301, 'GHR_37332_ALL_PROCEDURE_FAIL');
2265: hr_utility.raise_error;
2266: end if;
2267: */
2268:
2269: /* Commented -- Dec 2001 Patch
2275: 'ZRM','ZSK') AND
2276: p_First_Action_NOA_LA_Code2 in
2277: ('ALM','AQM','HAM','PWM','P3M','P5M','QAK','QBK','QCK','TJK','ZJR',
2278: 'ZRM','ZSK') ) THEN
2279: hr_utility.set_message(8301, 'GHR_37333_ALL_PROCEDURE_FAIL');
2280: hr_utility.raise_error;
2281: end if;
2282: */
2283: /* Commented -- Dec 2001 Patch
2276: p_First_Action_NOA_LA_Code2 in
2277: ('ALM','AQM','HAM','PWM','P3M','P5M','QAK','QBK','QCK','TJK','ZJR',
2278: 'ZRM','ZSK') ) THEN
2279: hr_utility.set_message(8301, 'GHR_37333_ALL_PROCEDURE_FAIL');
2280: hr_utility.raise_error;
2281: end if;
2282: */
2283: /* Commented -- Dec 2001 Patch
2284:
2288: NOT ( p_First_Action_NOA_LA_Code1 in
2289: ('HAM','TNM','TMK','TNK','ZLM','ZSK') AND
2290: p_First_Action_NOA_LA_Code2 in
2291: ('HAM','TNM','TMK','TNK','ZLM','ZSK') ) THEN
2292: hr_utility.set_message(8301, 'GHR_37334_ALL_PROCEDURE_FAIL');
2293: hr_utility.raise_error;
2294: end if;
2295: */
2296: /* Commented -- Dec 2001 Patch
2289: ('HAM','TNM','TMK','TNK','ZLM','ZSK') AND
2290: p_First_Action_NOA_LA_Code2 in
2291: ('HAM','TNM','TMK','TNK','ZLM','ZSK') ) THEN
2292: hr_utility.set_message(8301, 'GHR_37334_ALL_PROCEDURE_FAIL');
2293: hr_utility.raise_error;
2294: end if;
2295: */
2296: /* Commented -- Dec 2001 Patch
2297:
2301: NOT ( p_First_Action_NOA_LA_Code1 in
2302: ('HAM','TMK','TNK','ZLM','ZRM','ZSK') AND
2303: p_First_Action_NOA_LA_Code2 in
2304: ('HAM','TMK','TNK','ZLM','ZRM','ZSK') ) THEN
2305: hr_utility.set_message(8301, 'GHR_37335_ALL_PROCEDURE_FAIL');
2306: hr_utility.raise_error;
2307: end if;
2308: */
2309:
2302: ('HAM','TMK','TNK','ZLM','ZRM','ZSK') AND
2303: p_First_Action_NOA_LA_Code2 in
2304: ('HAM','TMK','TNK','ZLM','ZRM','ZSK') ) THEN
2305: hr_utility.set_message(8301, 'GHR_37335_ALL_PROCEDURE_FAIL');
2306: hr_utility.raise_error;
2307: end if;
2308: */
2309:
2310: /* Commented -- Dec 2001 Patch
2314: NOT ( p_First_Action_NOA_LA_Code1 in
2315: ('HAM','TPK''ZLM','ZSK') AND
2316: p_First_Action_NOA_LA_Code2 in
2317: ('HAM','TPK''ZLM','ZSK') ) THEN
2318: hr_utility.set_message(8301, 'GHR_37336_ALL_PROCEDURE_FAIL');
2319: hr_utility.raise_error;
2320: end if;
2321: */
2322: /* Commented -- Dec 2001 Patch
2315: ('HAM','TPK''ZLM','ZSK') AND
2316: p_First_Action_NOA_LA_Code2 in
2317: ('HAM','TPK''ZLM','ZSK') ) THEN
2318: hr_utility.set_message(8301, 'GHR_37336_ALL_PROCEDURE_FAIL');
2319: hr_utility.raise_error;
2320: end if;
2321: */
2322: /* Commented -- Dec 2001 Patch
2323:
2327: NOT ( p_First_Action_NOA_LA_Code1 in
2328: ('HAM','TVK''ZLM','ZSK') AND
2329: p_First_Action_NOA_LA_Code2 in
2330: ('HAM','TVK''ZLM','ZSK') ) THEN
2331: hr_utility.set_message(8301, 'GHR_37337_ALL_PROCEDURE_FAIL');
2332: hr_utility.raise_error;
2333: end if;
2334: */
2335:
2328: ('HAM','TVK''ZLM','ZSK') AND
2329: p_First_Action_NOA_LA_Code2 in
2330: ('HAM','TVK''ZLM','ZSK') ) THEN
2331: hr_utility.set_message(8301, 'GHR_37337_ALL_PROCEDURE_FAIL');
2332: hr_utility.raise_error;
2333: end if;
2334: */
2335:
2336:
2379: p_First_Action_NOA_LA_Code2 <> 'YKB' )
2380: )
2381: )
2382: THEN
2383: hr_utility.set_message(8301, 'GHR_37199_ALL_PROCEDURE_FAIL');
2384: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ABR, ALM, AQM, BPM, BWM, HAM, H2L, J8M, PWM, P3M, P5M,
2385: QAK, QBK, QCK, UAM, UDM, UFM, V1P, V8K, V8V, VGL, W--, X--, Y--(other than YKB), Z2M, Z2U, ZEA, ZJR, ZKM,
2386: ZLM, ZNM, ZRM, ZSK, ZSP, ZVB,ZVC,Z6J.');
2387: hr_utility.raise_error;
2380: )
2381: )
2382: THEN
2383: hr_utility.set_message(8301, 'GHR_37199_ALL_PROCEDURE_FAIL');
2384: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ABR, ALM, AQM, BPM, BWM, HAM, H2L, J8M, PWM, P3M, P5M,
2385: QAK, QBK, QCK, UAM, UDM, UFM, V1P, V8K, V8V, VGL, W--, X--, Y--(other than YKB), Z2M, Z2U, ZEA, ZJR, ZKM,
2386: ZLM, ZNM, ZRM, ZSK, ZSP, ZVB,ZVC,Z6J.');
2387: hr_utility.raise_error;
2388: end if;
2383: hr_utility.set_message(8301, 'GHR_37199_ALL_PROCEDURE_FAIL');
2384: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ABR, ALM, AQM, BPM, BWM, HAM, H2L, J8M, PWM, P3M, P5M,
2385: QAK, QBK, QCK, UAM, UDM, UFM, V1P, V8K, V8V, VGL, W--, X--, Y--(other than YKB), Z2M, Z2U, ZEA, ZJR, ZKM,
2386: ZLM, ZNM, ZRM, ZSK, ZSP, ZVB,ZVC,Z6J.');
2387: hr_utility.raise_error;
2388: end if;
2389: elsif p_effective_date >= to_date('19'||'99/11/01','yyyy/mm/dd') then
2390: if p_First_NOAC_Lookup_Code= '170'
2391: and
2416: p_First_Action_NOA_LA_Code2 <> 'YKB' )
2417: )
2418: )
2419: THEN
2420: hr_utility.set_message(8301, 'GHR_37199_ALL_PROCEDURE_FAIL');
2421: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ABR, ALM, AQM, BPM, BWM, HAM, H2L, J8M, PWM, P3M, P5M,
2422: QAK, QBK, QCK, UAM, UDM, UFM, V1P, V8K, V8V, VGL, W--, X--, Y--(other than YKB), Z2M, Z2U, ZJR, ZKM, ZLM,
2423: ZNM, ZRM, ZSK, ZSP, ZVB,ZVC,Z6J.');
2424: hr_utility.raise_error;
2417: )
2418: )
2419: THEN
2420: hr_utility.set_message(8301, 'GHR_37199_ALL_PROCEDURE_FAIL');
2421: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ABR, ALM, AQM, BPM, BWM, HAM, H2L, J8M, PWM, P3M, P5M,
2422: QAK, QBK, QCK, UAM, UDM, UFM, V1P, V8K, V8V, VGL, W--, X--, Y--(other than YKB), Z2M, Z2U, ZJR, ZKM, ZLM,
2423: ZNM, ZRM, ZSK, ZSP, ZVB,ZVC,Z6J.');
2424: hr_utility.raise_error;
2425: end if;
2420: hr_utility.set_message(8301, 'GHR_37199_ALL_PROCEDURE_FAIL');
2421: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ABR, ALM, AQM, BPM, BWM, HAM, H2L, J8M, PWM, P3M, P5M,
2422: QAK, QBK, QCK, UAM, UDM, UFM, V1P, V8K, V8V, VGL, W--, X--, Y--(other than YKB), Z2M, Z2U, ZJR, ZKM, ZLM,
2423: ZNM, ZRM, ZSK, ZSP, ZVB,ZVC,Z6J.');
2424: hr_utility.raise_error;
2425: end if;
2426: elsif p_effective_date >= to_date('19'||'99/01/01','yyyy/mm/dd') then
2427: if p_First_NOAC_Lookup_Code= '170'
2428: and
2453: p_First_Action_NOA_LA_Code2 <> 'YKB' )
2454: )
2455: )
2456: THEN
2457: hr_utility.set_message(8301, 'GHR_37037_ALL_PROCEDURE_FAIL');
2458: hr_utility.raise_error;
2459: end if;
2460: else
2461: if p_First_NOAC_Lookup_Code= '170'
2454: )
2455: )
2456: THEN
2457: hr_utility.set_message(8301, 'GHR_37037_ALL_PROCEDURE_FAIL');
2458: hr_utility.raise_error;
2459: end if;
2460: else
2461: if p_First_NOAC_Lookup_Code= '170'
2462: and
2488: p_First_Action_NOA_LA_Code2 <> 'YKB' )
2489: )
2490: )
2491: THEN
2492: hr_utility.set_message(8301, 'GHR_37338_ALL_PROCEDURE_FAIL');
2493: hr_utility.raise_error;
2494: end if;
2495: end if;
2496:
2489: )
2490: )
2491: THEN
2492: hr_utility.set_message(8301, 'GHR_37338_ALL_PROCEDURE_FAIL');
2493: hr_utility.raise_error;
2494: end if;
2495: end if;
2496:
2497: --290.04.2
2531: AND p_First_Action_NOA_LA_Code2 <> 'YKB' )
2532: )
2533: )
2534: THEN
2535: hr_utility.set_message(8301, 'GHR_37168_ALL_PROCEDURE_FAIL');
2536: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ALM, BPM, BWM, HAM, H2L, J8M, P3M, QAK, UAM, UFM,
2537: V1P, V8V, VGL, W--, X--, Y--(other than YKB), Z2M, ZEA, ZKM, ZLM, ZNM, VPE, V8K, ZWM, ZSK, ZSP, ZVB, ZVC, Z6J, ZVG.');
2538: hr_utility.raise_error;
2539: end if;
2532: )
2533: )
2534: THEN
2535: hr_utility.set_message(8301, 'GHR_37168_ALL_PROCEDURE_FAIL');
2536: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ALM, BPM, BWM, HAM, H2L, J8M, P3M, QAK, UAM, UFM,
2537: V1P, V8V, VGL, W--, X--, Y--(other than YKB), Z2M, ZEA, ZKM, ZLM, ZNM, VPE, V8K, ZWM, ZSK, ZSP, ZVB, ZVC, Z6J, ZVG.');
2538: hr_utility.raise_error;
2539: end if;
2540: --End Bug# 14595787
2534: THEN
2535: hr_utility.set_message(8301, 'GHR_37168_ALL_PROCEDURE_FAIL');
2536: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ALM, BPM, BWM, HAM, H2L, J8M, P3M, QAK, UAM, UFM,
2537: V1P, V8V, VGL, W--, X--, Y--(other than YKB), Z2M, ZEA, ZKM, ZLM, ZNM, VPE, V8K, ZWM, ZSK, ZSP, ZVB, ZVC, Z6J, ZVG.');
2538: hr_utility.raise_error;
2539: end if;
2540: --End Bug# 14595787
2541: elsif p_effective_date >= to_date('2009/02/17','yyyy/mm/dd') then
2542: if p_First_NOAC_Lookup_Code= '171'
2563: AND p_First_Action_NOA_LA_Code2 <> 'YKB' )
2564: )
2565: )
2566: THEN
2567: hr_utility.set_message(8301, 'GHR_37168_ALL_PROCEDURE_FAIL');
2568: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ALM, BPM, BWM, HAM, H2L, J8M, P3M, QAK, UAM, UFM,
2569: V1P, V8V, VGL, W--, X--, Y--(other than YKB), Z2M, ZEA, ZKM, ZLM, ZNM, VPE, V8K, ZWM, ZSK, ZSP, ZVB, ZVC, Z6J.');
2570: hr_utility.raise_error;
2571: end if;
2564: )
2565: )
2566: THEN
2567: hr_utility.set_message(8301, 'GHR_37168_ALL_PROCEDURE_FAIL');
2568: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ALM, BPM, BWM, HAM, H2L, J8M, P3M, QAK, UAM, UFM,
2569: V1P, V8V, VGL, W--, X--, Y--(other than YKB), Z2M, ZEA, ZKM, ZLM, ZNM, VPE, V8K, ZWM, ZSK, ZSP, ZVB, ZVC, Z6J.');
2570: hr_utility.raise_error;
2571: end if;
2572: elsif p_effective_date >= to_date('19'||'99/11/01','yyyy/mm/dd') then
2566: THEN
2567: hr_utility.set_message(8301, 'GHR_37168_ALL_PROCEDURE_FAIL');
2568: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ALM, BPM, BWM, HAM, H2L, J8M, P3M, QAK, UAM, UFM,
2569: V1P, V8V, VGL, W--, X--, Y--(other than YKB), Z2M, ZEA, ZKM, ZLM, ZNM, VPE, V8K, ZWM, ZSK, ZSP, ZVB, ZVC, Z6J.');
2570: hr_utility.raise_error;
2571: end if;
2572: elsif p_effective_date >= to_date('19'||'99/11/01','yyyy/mm/dd') then
2573: if p_First_NOAC_Lookup_Code= '171'
2574: and
2594: AND p_First_Action_NOA_LA_Code2 <> 'YKB' )
2595: )
2596: )
2597: THEN
2598: hr_utility.set_message(8301, 'GHR_37168_ALL_PROCEDURE_FAIL');
2599: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ALM, BPM, BWM, HAM, H2L, J8M, P3M, QAK, UAM, UFM,
2600: V1P, V8V, VGL, W--, X--, Y--(other than YKB), Z2M, ZKM, ZLM, ZNM, VPE, V8K, ZWM, ZSK, ZSP, ZVB, ZVC, Z6J.');
2601: hr_utility.raise_error;
2602: end if;
2595: )
2596: )
2597: THEN
2598: hr_utility.set_message(8301, 'GHR_37168_ALL_PROCEDURE_FAIL');
2599: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ALM, BPM, BWM, HAM, H2L, J8M, P3M, QAK, UAM, UFM,
2600: V1P, V8V, VGL, W--, X--, Y--(other than YKB), Z2M, ZKM, ZLM, ZNM, VPE, V8K, ZWM, ZSK, ZSP, ZVB, ZVC, Z6J.');
2601: hr_utility.raise_error;
2602: end if;
2603: elsif p_effective_date >= to_date('19'||'99/01/01','yyyy/mm/dd') then
2597: THEN
2598: hr_utility.set_message(8301, 'GHR_37168_ALL_PROCEDURE_FAIL');
2599: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ALM, BPM, BWM, HAM, H2L, J8M, P3M, QAK, UAM, UFM,
2600: V1P, V8V, VGL, W--, X--, Y--(other than YKB), Z2M, ZKM, ZLM, ZNM, VPE, V8K, ZWM, ZSK, ZSP, ZVB, ZVC, Z6J.');
2601: hr_utility.raise_error;
2602: end if;
2603: elsif p_effective_date >= to_date('19'||'99/01/01','yyyy/mm/dd') then
2604: if p_First_NOAC_Lookup_Code= '171'
2605: and
2625: AND p_First_Action_NOA_LA_Code2 <> 'YKB' )
2626: )
2627: )
2628: THEN
2629: hr_utility.set_message(8301, 'GHR_37094_ALL_PROCEDURE_FAIL');
2630: hr_utility.raise_error;
2631: end if;
2632: else
2633: if p_First_NOAC_Lookup_Code= '171'
2626: )
2627: )
2628: THEN
2629: hr_utility.set_message(8301, 'GHR_37094_ALL_PROCEDURE_FAIL');
2630: hr_utility.raise_error;
2631: end if;
2632: else
2633: if p_First_NOAC_Lookup_Code= '171'
2634: and
2656: p_First_Action_NOA_LA_Code2 <> 'YKB' )
2657: )
2658: )
2659: THEN
2660: hr_utility.set_message(8301, 'GHR_37339_ALL_PROCEDURE_FAIL');
2661: hr_utility.raise_error;
2662: end if;
2663: end if;
2664:
2657: )
2658: )
2659: THEN
2660: hr_utility.set_message(8301, 'GHR_37339_ALL_PROCEDURE_FAIL');
2661: hr_utility.raise_error;
2662: end if;
2663: end if;
2664:
2665: --290.20.2
2699: SUBSTR(p_First_Action_NOA_LA_Code2,1,1) IN ('W','X','Y')
2700: )
2701: )
2702: THEN
2703: hr_utility.set_message(8301, 'GHR_37922_ALL_PROCEDURE_FAIL');
2704: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ACM, AWM, AYM, BPM, BWA, BWM, HAM, H2L, J8M, KLM,
2705: MXM, M6M, M8M, NAM, NCM, NEM, NJM, NUM, SZX, UAM, UFM, VJM, VPE, V1P, V4M, V4P, V8K, V8L, V8N, V8V, VGL,
2706: W--, X--, Y--, Z2U, ZEA, ZJK, ZKM, ZLM, ZNM, ZQM, ZRM, ZSK, ZSP, ZTM.');
2707: hr_utility.raise_error;
2700: )
2701: )
2702: THEN
2703: hr_utility.set_message(8301, 'GHR_37922_ALL_PROCEDURE_FAIL');
2704: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ACM, AWM, AYM, BPM, BWA, BWM, HAM, H2L, J8M, KLM,
2705: MXM, M6M, M8M, NAM, NCM, NEM, NJM, NUM, SZX, UAM, UFM, VJM, VPE, V1P, V4M, V4P, V8K, V8L, V8N, V8V, VGL,
2706: W--, X--, Y--, Z2U, ZEA, ZJK, ZKM, ZLM, ZNM, ZQM, ZRM, ZSK, ZSP, ZTM.');
2707: hr_utility.raise_error;
2708: end if;
2703: hr_utility.set_message(8301, 'GHR_37922_ALL_PROCEDURE_FAIL');
2704: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ACM, AWM, AYM, BPM, BWA, BWM, HAM, H2L, J8M, KLM,
2705: MXM, M6M, M8M, NAM, NCM, NEM, NJM, NUM, SZX, UAM, UFM, VJM, VPE, V1P, V4M, V4P, V8K, V8L, V8N, V8V, VGL,
2706: W--, X--, Y--, Z2U, ZEA, ZJK, ZKM, ZLM, ZNM, ZQM, ZRM, ZSK, ZSP, ZTM.');
2707: hr_utility.raise_error;
2708: end if;
2709: elsif p_effective_date >= to_date('2001/10/01','yyyy/mm/dd') then
2710: if p_First_NOAC_Lookup_Code= '190'
2711: and
2734: SUBSTR(p_First_Action_NOA_LA_Code2,1,1) IN ('W','X','Y')
2735: )
2736: )
2737: THEN
2738: hr_utility.set_message(8301, 'GHR_37922_ALL_PROCEDURE_FAIL');
2739: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ACM, AWM, AYM, BPM, BWA, BWM, HAM, H2L, J8M, KLM,
2740: MXM, M6M, M8M, NAM, NCM, NEM, NJM, NUM, SZX, UAM, UFM, VJM, VPE, V1P, V4M, V4P, V8K, V8L, V8N, V8V, VGL,
2741: W--, X--, Y--, Z2U, ZJK, ZKM, ZLM, ZNM, ZQM, ZRM, ZSK, ZSP, ZTM.');
2742: hr_utility.raise_error;
2735: )
2736: )
2737: THEN
2738: hr_utility.set_message(8301, 'GHR_37922_ALL_PROCEDURE_FAIL');
2739: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ACM, AWM, AYM, BPM, BWA, BWM, HAM, H2L, J8M, KLM,
2740: MXM, M6M, M8M, NAM, NCM, NEM, NJM, NUM, SZX, UAM, UFM, VJM, VPE, V1P, V4M, V4P, V8K, V8L, V8N, V8V, VGL,
2741: W--, X--, Y--, Z2U, ZJK, ZKM, ZLM, ZNM, ZQM, ZRM, ZSK, ZSP, ZTM.');
2742: hr_utility.raise_error;
2743: end if;
2738: hr_utility.set_message(8301, 'GHR_37922_ALL_PROCEDURE_FAIL');
2739: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ACM, AWM, AYM, BPM, BWA, BWM, HAM, H2L, J8M, KLM,
2740: MXM, M6M, M8M, NAM, NCM, NEM, NJM, NUM, SZX, UAM, UFM, VJM, VPE, V1P, V4M, V4P, V8K, V8L, V8N, V8V, VGL,
2741: W--, X--, Y--, Z2U, ZJK, ZKM, ZLM, ZNM, ZQM, ZRM, ZSK, ZSP, ZTM.');
2742: hr_utility.raise_error;
2743: end if;
2744: elsif p_effective_date >= to_date('1999/02/28','yyyy/mm/dd') then
2745: if p_First_NOAC_Lookup_Code= '190'
2746: and
2769: SUBSTR(p_First_Action_NOA_LA_Code2,1,1) IN ('W','X','Y')
2770: )
2771: )
2772: THEN
2773: hr_utility.set_message(8301, 'GHR_37188_ALL_PROCEDURE_FAIL');
2774: hr_utility.raise_error;
2775: end if;
2776: elsif p_effective_date > to_date('1999/01/31','yyyy/mm/dd') then
2777: if p_First_NOAC_Lookup_Code= '190'
2770: )
2771: )
2772: THEN
2773: hr_utility.set_message(8301, 'GHR_37188_ALL_PROCEDURE_FAIL');
2774: hr_utility.raise_error;
2775: end if;
2776: elsif p_effective_date > to_date('1999/01/31','yyyy/mm/dd') then
2777: if p_First_NOAC_Lookup_Code= '190'
2778: and
2801: SUBSTR(p_First_Action_NOA_LA_Code2,1,1) IN ('W','X','Y')
2802: )
2803: )
2804: THEN
2805: hr_utility.set_message(8301, 'GHR_37043_ALL_PROCEDURE_FAIL');
2806: hr_utility.raise_error;
2807: end if;
2808: elsif p_effective_date >= to_date('1999/01/01','yyyy/mm/dd') then
2809: if p_First_NOAC_Lookup_Code= '190'
2802: )
2803: )
2804: THEN
2805: hr_utility.set_message(8301, 'GHR_37043_ALL_PROCEDURE_FAIL');
2806: hr_utility.raise_error;
2807: end if;
2808: elsif p_effective_date >= to_date('1999/01/01','yyyy/mm/dd') then
2809: if p_First_NOAC_Lookup_Code= '190'
2810: and
2833: SUBSTR(p_First_Action_NOA_LA_Code2,1,1) IN ('W','X','Y')
2834: )
2835: )
2836: THEN
2837: hr_utility.set_message(8301, 'GHR_37093_ALL_PROCEDURE_FAIL');
2838: hr_utility.raise_error;
2839: end if;
2840: else
2841: if p_First_NOAC_Lookup_Code= '190'
2834: )
2835: )
2836: THEN
2837: hr_utility.set_message(8301, 'GHR_37093_ALL_PROCEDURE_FAIL');
2838: hr_utility.raise_error;
2839: end if;
2840: else
2841: if p_First_NOAC_Lookup_Code= '190'
2842: and
2865: SUBSTR(p_First_Action_NOA_LA_Code2,1,1) IN ('W','X','Y')
2866: )
2867: )
2868: THEN
2869: hr_utility.set_message(8301, 'GHR_37340_ALL_PROCEDURE_FAIL');
2870: hr_utility.raise_error;
2871: end if;
2872:
2873: end if;
2866: )
2867: )
2868: THEN
2869: hr_utility.set_message(8301, 'GHR_37340_ALL_PROCEDURE_FAIL');
2870: hr_utility.raise_error;
2871: end if;
2872:
2873: end if;
2874: --290.30.2
2880: NOT ( p_First_Action_NOA_LA_Code1 in
2881: ('R9R','V1P','ZVB','ZVC','ZEA') AND
2882: p_First_Action_NOA_LA_Code2 in
2883: ('R9R','V1P','ZVB','ZVC','ZEA') ) THEN
2884: hr_utility.set_message(8301, 'GHR_37341_ALL_PROCEDURE_FAIL');
2885: hr_utility.set_message_token('LAC_CODE','R9R, V1P, ZEA, ZVB,ZVC.');
2886: hr_utility.raise_error;
2887: end if;
2888: ELSE
2881: ('R9R','V1P','ZVB','ZVC','ZEA') AND
2882: p_First_Action_NOA_LA_Code2 in
2883: ('R9R','V1P','ZVB','ZVC','ZEA') ) THEN
2884: hr_utility.set_message(8301, 'GHR_37341_ALL_PROCEDURE_FAIL');
2885: hr_utility.set_message_token('LAC_CODE','R9R, V1P, ZEA, ZVB,ZVC.');
2886: hr_utility.raise_error;
2887: end if;
2888: ELSE
2889: if p_First_NOAC_Lookup_Code= '198'
2882: p_First_Action_NOA_LA_Code2 in
2883: ('R9R','V1P','ZVB','ZVC','ZEA') ) THEN
2884: hr_utility.set_message(8301, 'GHR_37341_ALL_PROCEDURE_FAIL');
2885: hr_utility.set_message_token('LAC_CODE','R9R, V1P, ZEA, ZVB,ZVC.');
2886: hr_utility.raise_error;
2887: end if;
2888: ELSE
2889: if p_First_NOAC_Lookup_Code= '198'
2890: and
2891: NOT ( p_First_Action_NOA_LA_Code1 in
2892: ('R9R','V1P','ZVB','ZVC') AND
2893: p_First_Action_NOA_LA_Code2 in
2894: ('R9R','V1P','ZVB','ZVC') ) THEN
2895: hr_utility.set_message(8301, 'GHR_37341_ALL_PROCEDURE_FAIL');
2896: hr_utility.set_message_token('LAC_CODE','R9R, V1P, ZVB,ZVC.');
2897: hr_utility.raise_error;
2898: end if;
2899: END IF;
2892: ('R9R','V1P','ZVB','ZVC') AND
2893: p_First_Action_NOA_LA_Code2 in
2894: ('R9R','V1P','ZVB','ZVC') ) THEN
2895: hr_utility.set_message(8301, 'GHR_37341_ALL_PROCEDURE_FAIL');
2896: hr_utility.set_message_token('LAC_CODE','R9R, V1P, ZVB,ZVC.');
2897: hr_utility.raise_error;
2898: end if;
2899: END IF;
2900:
2893: p_First_Action_NOA_LA_Code2 in
2894: ('R9R','V1P','ZVB','ZVC') ) THEN
2895: hr_utility.set_message(8301, 'GHR_37341_ALL_PROCEDURE_FAIL');
2896: hr_utility.set_message_token('LAC_CODE','R9R, V1P, ZVB,ZVC.');
2897: hr_utility.raise_error;
2898: end if;
2899: END IF;
2900:
2901: --290.35.2
2907: NOT ( p_First_Action_NOA_LA_Code1 in
2908: ('R9N','V1P','ZVB','ZVC','ZEA') AND
2909: p_First_Action_NOA_LA_Code2 in
2910: ('R9N','V1P','ZVB','ZVC','ZEA') ) THEN
2911: hr_utility.set_message(8301, 'GHR_37342_ALL_PROCEDURE_FAIL');
2912: hr_utility.set_message_token('LAC_CODE','R9N, V1P, ZEA, ZVB,ZVC.');
2913: hr_utility.raise_error;
2914: end if;
2915: ELSE
2908: ('R9N','V1P','ZVB','ZVC','ZEA') AND
2909: p_First_Action_NOA_LA_Code2 in
2910: ('R9N','V1P','ZVB','ZVC','ZEA') ) THEN
2911: hr_utility.set_message(8301, 'GHR_37342_ALL_PROCEDURE_FAIL');
2912: hr_utility.set_message_token('LAC_CODE','R9N, V1P, ZEA, ZVB,ZVC.');
2913: hr_utility.raise_error;
2914: end if;
2915: ELSE
2916: if p_First_NOAC_Lookup_Code= '199'
2909: p_First_Action_NOA_LA_Code2 in
2910: ('R9N','V1P','ZVB','ZVC','ZEA') ) THEN
2911: hr_utility.set_message(8301, 'GHR_37342_ALL_PROCEDURE_FAIL');
2912: hr_utility.set_message_token('LAC_CODE','R9N, V1P, ZEA, ZVB,ZVC.');
2913: hr_utility.raise_error;
2914: end if;
2915: ELSE
2916: if p_First_NOAC_Lookup_Code= '199'
2917: and
2918: NOT ( p_First_Action_NOA_LA_Code1 in
2919: ('R9N','V1P','ZVB','ZVC') AND
2920: p_First_Action_NOA_LA_Code2 in
2921: ('R9N','V1P','ZVB','ZVC') ) THEN
2922: hr_utility.set_message(8301, 'GHR_37342_ALL_PROCEDURE_FAIL');
2923: hr_utility.set_message_token('LAC_CODE','R9N, V1P, ZVB,ZVC.');
2924: hr_utility.raise_error;
2925: end if;
2926: END IF;
2919: ('R9N','V1P','ZVB','ZVC') AND
2920: p_First_Action_NOA_LA_Code2 in
2921: ('R9N','V1P','ZVB','ZVC') ) THEN
2922: hr_utility.set_message(8301, 'GHR_37342_ALL_PROCEDURE_FAIL');
2923: hr_utility.set_message_token('LAC_CODE','R9N, V1P, ZVB,ZVC.');
2924: hr_utility.raise_error;
2925: end if;
2926: END IF;
2927:
2920: p_First_Action_NOA_LA_Code2 in
2921: ('R9N','V1P','ZVB','ZVC') ) THEN
2922: hr_utility.set_message(8301, 'GHR_37342_ALL_PROCEDURE_FAIL');
2923: hr_utility.set_message_token('LAC_CODE','R9N, V1P, ZVB,ZVC.');
2924: hr_utility.raise_error;
2925: end if;
2926: END IF;
2927:
2928: --295.02.2
2932: NOT ( p_First_Action_NOA_LA_Code1 in
2933: ('CUL','ZVB','ZVC') AND
2934: p_First_Action_NOA_LA_Code2 in
2935: ('CUL','ZVB','ZVC') ) THEN
2936: hr_utility.set_message(8301, 'GHR_37343_ALL_PROCEDURE_FAIL');
2937: hr_utility.raise_error;
2938: end if;
2939:
2940: --295.04.2
2933: ('CUL','ZVB','ZVC') AND
2934: p_First_Action_NOA_LA_Code2 in
2935: ('CUL','ZVB','ZVC') ) THEN
2936: hr_utility.set_message(8301, 'GHR_37343_ALL_PROCEDURE_FAIL');
2937: hr_utility.raise_error;
2938: end if;
2939:
2940: --295.04.2
2941: -- Update/Change Date By Effective Date Comment
2951: 'R9N','UAM','UFM','ZJR','ZJT','ZJU','ZJV','ZJW','ZVC') AND
2952: p_First_Action_NOA_LA_Code2 in
2953: ('ALM','AQM','CGM','DAM','NYM','PSM','Q3K','QRD',
2954: 'R9N','UAM','UFM','ZJR','ZJT','ZJU','ZJV','ZJW','ZVC') ) THEN
2955: hr_utility.set_message(8301, 'GHR_37064_ALL_PROCEDURE_FAIL');
2956: hr_utility.set_message_token('LA_CODE','ALM, AQM, CGM, DAM, NYM, PSM, Q3K, QRD, R9N, UAM, UFM, ZJR, ZJT, ZJU, ZJV, ZJW, ZVC.');
2957: hr_utility.raise_error;
2958: end if;
2959: elsif p_effective_date >= to_date('1999/04/01','yyyy/mm/dd') then
2952: p_First_Action_NOA_LA_Code2 in
2953: ('ALM','AQM','CGM','DAM','NYM','PSM','Q3K','QRD',
2954: 'R9N','UAM','UFM','ZJR','ZJT','ZJU','ZJV','ZJW','ZVC') ) THEN
2955: hr_utility.set_message(8301, 'GHR_37064_ALL_PROCEDURE_FAIL');
2956: hr_utility.set_message_token('LA_CODE','ALM, AQM, CGM, DAM, NYM, PSM, Q3K, QRD, R9N, UAM, UFM, ZJR, ZJT, ZJU, ZJV, ZJW, ZVC.');
2957: hr_utility.raise_error;
2958: end if;
2959: elsif p_effective_date >= to_date('1999/04/01','yyyy/mm/dd') then
2960: if p_First_NOAC_Lookup_Code= '292' and
2953: ('ALM','AQM','CGM','DAM','NYM','PSM','Q3K','QRD',
2954: 'R9N','UAM','UFM','ZJR','ZJT','ZJU','ZJV','ZJW','ZVC') ) THEN
2955: hr_utility.set_message(8301, 'GHR_37064_ALL_PROCEDURE_FAIL');
2956: hr_utility.set_message_token('LA_CODE','ALM, AQM, CGM, DAM, NYM, PSM, Q3K, QRD, R9N, UAM, UFM, ZJR, ZJT, ZJU, ZJV, ZJW, ZVC.');
2957: hr_utility.raise_error;
2958: end if;
2959: elsif p_effective_date >= to_date('1999/04/01','yyyy/mm/dd') then
2960: if p_First_NOAC_Lookup_Code= '292' and
2961: NOT ( p_First_Action_NOA_LA_Code1 in
2963: 'R9N','UAM','UFM','V8V','ZJR','ZJT','ZJU','ZJV','ZJW','ZVB','ZVC') AND
2964: p_First_Action_NOA_LA_Code2 in
2965: ('ALM','AQM','CGM','DAM','NYM','PSM','Q3K',
2966: 'R9N','UAM','UFM','V8V','ZJR','ZJT','ZJU','ZJV','ZJW','ZVB','ZVC') ) THEN
2967: hr_utility.set_message(8301, 'GHR_37064_ALL_PROCEDURE_FAIL');
2968: hr_utility.set_message_token('LA_CODE','ALM, AQM, CGM, DAM, NYM, PSM, Q3K, R9N, UAM, UFM, V8V, ZJR, ZJT, ZJU, ZJV, ZJW, ZVB,ZVC.');
2969: hr_utility.raise_error;
2970: end if;
2971: else
2964: p_First_Action_NOA_LA_Code2 in
2965: ('ALM','AQM','CGM','DAM','NYM','PSM','Q3K',
2966: 'R9N','UAM','UFM','V8V','ZJR','ZJT','ZJU','ZJV','ZJW','ZVB','ZVC') ) THEN
2967: hr_utility.set_message(8301, 'GHR_37064_ALL_PROCEDURE_FAIL');
2968: hr_utility.set_message_token('LA_CODE','ALM, AQM, CGM, DAM, NYM, PSM, Q3K, R9N, UAM, UFM, V8V, ZJR, ZJT, ZJU, ZJV, ZJW, ZVB,ZVC.');
2969: hr_utility.raise_error;
2970: end if;
2971: else
2972: if p_First_NOAC_Lookup_Code= '292'
2965: ('ALM','AQM','CGM','DAM','NYM','PSM','Q3K',
2966: 'R9N','UAM','UFM','V8V','ZJR','ZJT','ZJU','ZJV','ZJW','ZVB','ZVC') ) THEN
2967: hr_utility.set_message(8301, 'GHR_37064_ALL_PROCEDURE_FAIL');
2968: hr_utility.set_message_token('LA_CODE','ALM, AQM, CGM, DAM, NYM, PSM, Q3K, R9N, UAM, UFM, V8V, ZJR, ZJT, ZJU, ZJV, ZJW, ZVB,ZVC.');
2969: hr_utility.raise_error;
2970: end if;
2971: else
2972: if p_First_NOAC_Lookup_Code= '292'
2973: and NOT ( p_First_Action_NOA_LA_Code1 in
2975: 'R9N','UAM','UFM','V8V','ZJR','ZJT','ZJU','ZJW','ZVB','ZVC') AND
2976: p_First_Action_NOA_LA_Code2 in
2977: ('ALM','AQM','CGM','DAM','NYM','PSM','Q3K',
2978: 'R9N','UAM','UFM','V8V','ZJR','ZJT','ZJU','ZJW','ZVB','ZVC') ) THEN
2979: hr_utility.set_message(8301, 'GHR_37344_ALL_PROCEDURE_FAIL');
2980: hr_utility.raise_error;
2981: end if;
2982:
2983: end if;
2976: p_First_Action_NOA_LA_Code2 in
2977: ('ALM','AQM','CGM','DAM','NYM','PSM','Q3K',
2978: 'R9N','UAM','UFM','V8V','ZJR','ZJT','ZJU','ZJW','ZVB','ZVC') ) THEN
2979: hr_utility.set_message(8301, 'GHR_37344_ALL_PROCEDURE_FAIL');
2980: hr_utility.raise_error;
2981: end if;
2982:
2983: end if;
2984:
2989: p_First_Action_NOA_LA_Code1 in ('R9R','ZVB','ZVC')
2990: and
2991: p_First_Action_NOA_LA_Code2 in ('R9R','ZVB','ZVC')
2992: ) THEN
2993: hr_utility.set_message(8301, 'GHR_37345_ALL_PROCEDURE_FAIL');
2994: hr_utility.raise_error;
2995: end if;
2996:
2997: --300.02.2
2990: and
2991: p_First_Action_NOA_LA_Code2 in ('R9R','ZVB','ZVC')
2992: ) THEN
2993: hr_utility.set_message(8301, 'GHR_37345_ALL_PROCEDURE_FAIL');
2994: hr_utility.raise_error;
2995: end if;
2996:
2997: --300.02.2
2998: -- Renumbered from 300.01.2
3001: NOT ( p_First_Action_NOA_LA_Code1 in
3002: ('SWM','UFM','USM','V8V') AND
3003: p_First_Action_NOA_LA_Code2 in
3004: ('SWM','UFM','USM','V8V') ) THEN
3005: hr_utility.set_message(8301, 'GHR_37346_ALL_PROCEDURE_FAIL');
3006: hr_utility.raise_error;
3007: end if;
3008:
3009: --300.04.2
3002: ('SWM','UFM','USM','V8V') AND
3003: p_First_Action_NOA_LA_Code2 in
3004: ('SWM','UFM','USM','V8V') ) THEN
3005: hr_utility.set_message(8301, 'GHR_37346_ALL_PROCEDURE_FAIL');
3006: hr_utility.raise_error;
3007: end if;
3008:
3009: --300.04.2
3010: if p_First_NOAC_Lookup_Code= '301'
3012: NOT ( p_First_Action_NOA_LA_Code1 in
3013: ('SUM','UFM','USM','V8V') AND
3014: p_First_Action_NOA_LA_Code2 in
3015: ('SUM','UFM','USM','V8V') ) THEN
3016: hr_utility.set_message(8301, 'GHR_37347_ALL_PROCEDURE_FAIL');
3017: hr_utility.raise_error;
3018: end if;
3019:
3020: GHR_CPDF_CHECK4A.chk_Legal_Authority_a
3013: ('SUM','UFM','USM','V8V') AND
3014: p_First_Action_NOA_LA_Code2 in
3015: ('SUM','UFM','USM','V8V') ) THEN
3016: hr_utility.set_message(8301, 'GHR_37347_ALL_PROCEDURE_FAIL');
3017: hr_utility.raise_error;
3018: end if;
3019:
3020: GHR_CPDF_CHECK4A.chk_Legal_Authority_a
3021: (p_To_Play_Plan