[Home] [Help]
PACKAGE BODY: APPS.GHR_CPDF_CHECK4
Source
1 package body GHR_CPDF_CHECK4 as
2 /* $Header: ghcpdf04.pkb 120.24.12020000.10 2013/02/05 10:24:16 utokachi ship $ */
3
4 -- Legal Authority
5
6 procedure chk_Legal_Authority
7 (p_To_Play_Plan in varchar2
8 ,p_Agency_Sub_Element in varchar2
9 ,p_First_Action_NOA_LA_Code1 in varchar2
10 ,p_First_Action_NOA_LA_Code2 in varchar2
11 ,p_First_NOAC_Lookup_Code in varchar2
12 ,p_effective_date in date
13 ,p_position_occupied_code in varchar2
14 ) is
15
16 begin
17
18 -- 250.02.2
19 -- renamed this edit from 250.01.2 for the april release
20 if (
21 p_First_Action_NOA_LA_Code1 = 'ZVB'
22 or
23 p_First_Action_NOA_LA_Code2 = 'ZVB'
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
33 --
34 -- 12/8/00 vravikan From the start Add UAM
35 -- If either legal authority is Z2U, then agency must be AF,AR,DD or NV
36 -- U58 Raju Start Bug 9503972
37 -- U59 Raju Start Bug 9978991 removed LAC BAE
38 --
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
48 /* Commented -- Dec 2001 Patch
49 -- 250.04.2
50 -- Raju 09-Nov-2005 UPD 43(Bug 4567571) Add Edit
51 --
52 -- If either legal authority is ZPK, then agency must be PC
53 --
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 */
63 -- 250.04.2
64 -- Begin Bug 4567571
65 -- U58 Raju 31-Dec-2009 Bug 9503972 Terminate the Edit
66 -- U59 Raju Start Bug 9978991 Remove the End date
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
76
77 --
78 -- 250.05.2 If either legal authority is Z2W,
79 -- Then agency must be AF, AR, DD, or NV.
80 --
81 -- U58 Raju 31-Dec-2009 Bug 9503972 Terminate the Edit
82 if p_effective_date < fnd_date.canonical_to_date('2009/12/31') then
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;
92 /* Commented as per December 2000 cpdf changes -- vravikan
93 --
94 -- 250.06.2 If either legal authority is ZTA,
95 -- And position occupied is 1,
96 -- Then agency/subelement must be DJ03.
97 --
98 if p_effective_date >= fnd_date.canonical_to_date('1998/09/01') then
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
108
109 */
110 -- 250.07.2 If either legal authority is ZVC,
111 -- Then agency/subelement must be TD19.
112 -- Updation Date Updated By Remarks
113 -- ============================================
114 -- 19-MAR-2003 vnarasim Added agency/subelement HSBC.
115 -- 30-OCT-2003 Ashley Deleted agency/subelement TD19
116 --
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
126 -- deleted legal authority M4M and nature of action 117,517,761
127 if (
128 p_First_Action_NOA_LA_Code1 in ('M6M','M8M')
129 or
130 p_First_Action_NOA_LA_Code2 in ('M6M','M8M')
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
140 -- If either (first or second) Legal
141 -- Authority is UDM, then Agency must be TR.
142 -- 18-Aug-00 vravikan 01-Jan-2000 New Edit
143 if p_effective_date >= to_date('2000/01/01','yyyy/mm/dd') then
144 if (
145 p_First_Action_NOA_LA_Code1 = 'UDM'
146 or
147 p_First_Action_NOA_LA_Code2 = 'UDM'
148 )
149 and
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
159 -- If either (first or second) Legal
160 -- Authority is UDM, then Agency must be TR.
161 -- 11/8 12/14/99 vravikan 01-Nov-1999 New Edit
162 if p_effective_date >= to_date('19'||'99/11/01','yyyy/mm/dd') then
163 if (
164 p_First_Action_NOA_LA_Code1 = 'UDM'
165 or
166 p_First_Action_NOA_LA_Code2 = 'UDM'
167 )
168 and
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
178 -- upd50 06-Feb-07 Raju From 01-Oct-2006 Bug#5745356 delete Pay plan FZ
179 if p_effective_date < to_date('2006/10/01','yyyy/mm/dd') then
180 if ( p_First_Action_NOA_LA_Code1 = 'UFM' or
181 p_First_Action_NOA_LA_Code2 = 'UFM'
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
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;
202 -- 250.16.2
203 if (
204 p_First_Action_NOA_LA_Code1 = 'V8K'
205 or
206 p_First_Action_NOA_LA_Code1 = 'V8N'
207 or
208 p_First_Action_NOA_LA_Code2 = 'V8K'
209 or
210 p_First_Action_NOA_LA_Code2 = 'V8N'
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
220 -- 250.17.2
221 -- U58 Raju 31-Dec-2009 Bug 9503972 Terminate the Edit
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;
231 -- 250.18.2
232 -- U58 Raju 31-Dec-2009 Bug 9503972 Terminate the Edit
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;
242 --End Bug# 5745356
243
244 --Begin Bug# 8653515
245 --250.50.2
246 --8775796 added =
247 if p_effective_date >= to_date('2009/07/01','yyyy/mm/dd') then
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
257
258 -- 250.19.2
259 -- Award Req 8/15/00 vravikan 30-sep-2000 End date
260 -- Add 840-847
261 -- vnarasim 10-MAR-2003 Added 848
262 -- upd51 06-Feb-07 Raju From 01-Jan-2007 Bug#5745356 add NOAs
263 -- 849,886,887,889
264 -- bug# 8653508 930,931,932 to skip the LAC check
265 -- bug# 9972543 added 993 to skip the LAC check
266 if p_effective_date <= to_date('2000/09/30','yyyy/mm/dd') then
267 if ( p_First_NOAC_Lookup_Code <> '350' and
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',
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',
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
296 --250.20.2
297 if p_First_NOAC_Lookup_Code <> '356'
298 and
299 (
300 p_First_Action_NOA_LA_Code1 ='VDK'
301 or
302 p_First_Action_NOA_LA_Code2 ='VDK'
303 )
304 and
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
314 -- deleted nature of action 117,517
315 if (
316 p_First_Action_NOA_LA_Code1 = 'WXM'
317 or
318 p_First_Action_NOA_LA_Code2 = 'WXM'
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
328 if (
329 p_First_Action_NOA_LA_Code1 = 'ZSP'
330 or
331 p_First_Action_NOA_LA_Code2 = 'ZSP'
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
341 if (
342 p_First_Action_NOA_LA_Code1 = 'BDN'
343 or
344 p_First_Action_NOA_LA_Code1 = 'BYM'
345 or
346 p_First_Action_NOA_LA_Code2 = 'BDN'
347 or
348 p_First_Action_NOA_LA_Code2 = 'BYM'
349 )
350 and
351 (
352 p_agency_sub_element <> 'AG03'
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
362 if (
363 p_First_Action_NOA_LA_Code1 = 'V8V'
364 or
365 p_First_Action_NOA_LA_Code2 = 'V8V'
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
375 -- Update Date By Effective Date Comment
376 -- 18-Aug-00 vravikan 01-Jun-2000 New Edit
377 /* If either legal authority is V7R,
378 Then agency/subelement must be TR93 */
379 if p_effective_date >= to_date('2000/06/01','yyyy/mm/dd') then
380 if (
381 p_First_Action_NOA_LA_Code1 = 'V7R' or
382 p_First_Action_NOA_LA_Code2 = 'V7R'
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
392 -- START OF 255.02.2
393 -- added 'BNK' and deleted 'VHM' for the april 98 release
394 -- added 'Z2U' on 22-jul-1998
395 -- added 'ZTA','Z2W' on 9-oct-1998 update 8
396 -- Update/Change Date By Effective Date Comment
397 -- 8 03/09/99 vravikan 01/31/99 Delete BEA,BMC,BNE,BNW,BRM
398 -- 10/4 08/15/99 vravikan 01-Jan-99 Add VGL
399 -- 11/9 12/13/99 vravikan 01-Nov-99 Add UDM
400 -- 11/1 12/13/99 vravikan 01-Dec-99 Add ZBA
401 -- 17-Aug-00 vravikan From Begining Add ZBA,Delete BNP
402 -- 08-Dec-00 vravikan From Begining Delete ZTA
403 -- 30-Oct-03 Ashley From Begining Added BAB,BAC,BAD,BYO
404 -- 30-APR-04 Madhuri From Beginning Added LYP for 100
405 -- Upd 37 09-NOV-04 Madhuri From beginning Added LAC's - BNR, BNT
406 -- Upd 43 09-NOV-05 Raju From beginning Added BAE
407 -- Upd 39 vnarasim From Begining Added BNY
408 -- Upd 47 23-Jun-06 Raju From Begining Added BNZ,ZJK, Z5B, Z5C
409 -- upd 49 19-Jan-07 Raju From Begining Bug#5619873 add LAC BAF
410 -- delete BNT
411 -- Upd 54 12-Jun-07 vmididho From Begining delete BAF
412 --- 3-Dec-08 Raju From Begining Added V8N Bug# 7611040
413 --- Upd 56 13-Mar-09 Manish 01-Jan-2009 Added LA code BAG
414 --- Upd 56 13-Mar-09 Manish 17-Feb-2009 Added LA code ZEA
415 --- Upd 59 31-Jul-12 Mani 10-Jul-2012 Added LA codes LAE, LAK
416 --- Upd 59 01-Oct-12 Mani 10-Jul-2012 Added LA code LAM
417 --BUG # 14395108
418 --Bug # 14686025
419 if p_effective_date >= to_date('2012/07/10','yyyy/mm/dd') then
420 if p_First_NOAC_Lookup_Code= '100'
421 and
422 NOT(
423 p_First_Action_NOA_LA_Code1 in
424 ('ABK','ABL','ABM','ACA','ACM','ALM','AQM',
425 'AYM','A2M','BAB','BAC','BAD','BAE','BYO',
426 'BBM','BDN','BKM','BAG',
427 'BLM','BNK','BNM','BNN','BNR','BNY','BNZ',
428 'BWA','BWM','BYM','HAM','K1M','K4M',
429 'K7M','K8M','K9M','LAE','LAK','LAM','LEM','LHM','LJM','LKM',
430 'LKP','L3M','LYP','PWM','P3M','P5M','P7M','QAK',
431 'QBK','QCK','UDM','VGL','VJM','V1P','V8L','V8N','Z2U','Z2W','ZGM',
432 'ZBA','ZJK','ZJM','ZJR','ZLM','ZQM','ZRM','ZSK','ZSP','ZTU','Z5B','Z5C','ZEA')
433 and
434 p_First_Action_NOA_LA_Code2 in
435 ('ABK','ABL','ABM','ACA','ACM','ALM','AQM',
436 'AYM','A2M','BAB','BAC','BAD','BAE','BYO',
437 'BBM','BDN','BKM','BAG',
438 'BLM','BNK','BNM','BNN','BNR','BNY','BNZ',
439 'BWA','BWM','BYM','HAM','K1M','K4M',
440 'K7M','K8M','K9M','LAE','LAK','LAM','LEM','LHM','LJM','LKM',
441 'LKP','L3M','LYP','PWM','P3M','P5M','P7M','QAK',
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.');
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'
456 and
457 NOT(
458 p_First_Action_NOA_LA_Code1 in
459 ('ABK','ABL','ABM','ACA','ACM','ALM','AQM',
460 'AYM','A2M','BAB','BAC','BAD','BAE','BYO',
461 'BBM','BDN','BKM','BAG',
462 'BLM','BNK','BNM','BNN','BNR','BNY','BNZ',
463 'BWA','BWM','BYM','HAM','K1M','K4M',
464 'K7M','K8M','K9M','LEM','LHM','LJM','LKM',
465 'LKP','L3M','LYP','PWM','P3M','P5M','P7M','QAK',
466 'QBK','QCK','UDM','VGL','VJM','V1P','V8L','V8N','Z2U','Z2W','ZGM',
467 'ZBA','ZJK','ZJM','ZJR','ZLM','ZQM','ZRM','ZSK','ZSP','ZTU','Z5B','Z5C','ZEA')
468 and
469 p_First_Action_NOA_LA_Code2 in
470 ('ABK','ABL','ABM','ACA','ACM','ALM','AQM',
471 'AYM','A2M','BAB','BAC','BAD','BAE','BYO',
472 'BBM','BDN','BKM','BAG',
473 'BLM','BNK','BNM','BNN','BNR','BNY','BNZ',
474 'BWA','BWM','BYM','HAM','K1M','K4M',
475 'K7M','K8M','K9M','LEM','LHM','LJM','LKM',
476 'LKP','L3M','LYP','PWM','P3M','P5M','P7M','QAK',
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.');
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
491 NOT(
492 p_First_Action_NOA_LA_Code1 in
493 ('ABK','ABL','ABM','ACA','ACM','ALM','AQM',
494 'AYM','A2M','BAB','BAC','BAD','BAE','BYO',
495 'BBM','BDN','BKM','BAG',
496 'BLM','BNK','BNM','BNN','BNR','BNY','BNZ',
497 'BWA','BWM','BYM','HAM','K1M','K4M',
498 'K7M','K8M','K9M','LEM','LHM','LJM','LKM',
499 'LKP','L3M','LYP','PWM','P3M','P5M','P7M','QAK',
500 'QBK','QCK','UDM','VGL','VJM','V1P','V8L','V8N','Z2U','Z2W','ZGM',
501 'ZBA','ZJK','ZJM','ZJR','ZLM','ZQM','ZRM','ZSK','ZSP','ZTU','Z5B','Z5C')
502 and
503 p_First_Action_NOA_LA_Code2 in
504 ('ABK','ABL','ABM','ACA','ACM','ALM','AQM',
505 'AYM','A2M','BAB','BAC','BAD','BAE','BYO',
506 'BBM','BDN','BKM','BAG',
507 'BLM','BNK','BNM','BNN','BNR','BNY','BNZ',
508 'BWA','BWM','BYM','HAM','K1M','K4M',
509 'K7M','K8M','K9M','LEM','LHM','LJM','LKM',
510 'LKP','L3M','LYP','PWM','P3M','P5M','P7M','QAK',
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.');
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
525 NOT(
526 p_First_Action_NOA_LA_Code1 in
527 ('ABK','ABL','ABM','ACA','ACM','ALM','AQM',
528 'AYM','A2M','BAB','BAC','BAD','BAE','BYO',
529 'BBM','BDN','BKM',
530 'BLM','BNK','BNM','BNN','BNR','BNY','BNZ',
531 'BWA','BWM','BYM','HAM','K1M','K4M',
532 'K7M','K8M','K9M','LEM','LHM','LJM','LKM',
533 'LKP','L3M','LYP','PWM','P3M','P5M','P7M','QAK',
534 'QBK','QCK','UDM','VGL','VJM','V1P','V8L','V8N','Z2U','Z2W','ZGM',
535 'ZBA','ZJK','ZJM','ZJR','ZLM','ZQM','ZRM','ZSK','ZSP','ZTU','Z5B','Z5C')
536 and
537 p_First_Action_NOA_LA_Code2 in
538 ('ABK','ABL','ABM','ACA','ACM','ALM','AQM',
539 'AYM','A2M','BAB','BAC','BAD','BAE','BYO',
540 'BBM','BDN','BKM',
541 'BLM','BNK','BNM','BNN','BNR','BNY','BNZ',
542 'BWA','BWM','BYM','HAM','K1M','K4M',
543 'K7M','K8M','K9M','LEM','LHM','LJM','LKM',
544 'LKP','L3M','LYP','PWM','P3M','P5M','P7M','QAK',
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.');
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
559 NOT(
560 p_First_Action_NOA_LA_Code1 in
561 ('ABK','ABL','ABM','ACA','ACM','ALM','AQM',
562 'AYM','A2M','BBM','BDN','BKM',
563 'BLM','BNK','BNM','BNN','BNR','BNY','BNZ',
564 'BAB','BAC','BAD','BAE','BYO',
565 'BWA','BWM','BYM','HAM','K1M','K4M',
566 'K7M','K8M','K9M','LEM','LHM','LJM','LKM',
567 'LKP','L3M','LYP','PWM','P3M','P5M','P7M','QAK',
568 'QBK','QCK','UDM','VGL','VJM','V1P','V8L','V8N','Z2U','Z2W','ZGM',
569 'ZBA','ZJK','ZJM','ZJR','ZLM','ZQM','ZRM','ZSK','ZSP','ZTU','Z5B','Z5C')
570 and
571 p_First_Action_NOA_LA_Code2 in
572 ('ABK','ABL','ABM','ACA','ACM','ALM','AQM',
573 'AYM','A2M','BAB','BAC','BAD','BAE','BYO',
574 'BBM','BDN','BKM',
575 'BLM','BNK','BNM','BNN','BNR','BNY','BNZ',
576 'BWA','BWM','BYM','HAM','K1M','K4M',
577 'K7M','K8M','K9M','LEM','LHM','LJM','LKM',
578 'LKP','L3M','LYP','PWM','P3M','P5M','P7M','QAK',
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'
588 and
589 NOT(
590 p_First_Action_NOA_LA_Code1 in
591 ('ABK','ABL','ABM','ACA','ACM','ALM','AQM',
592 'AYM','A2M','BAB','BAC','BAD','BAE','BYO',
593 'BBM','BDN','BKM',
594 'BLM','BNK','BNM','BNN','BNR','BNY','BNZ',
595 'BWA','BWM','BYM','HAM','K1M','K4M',
596 'K7M','K8M','K9M','LEM','LHM','LJM','LKM',
597 'LKP','L3M','LYP','PWM','P3M','P5M','P7M','QAK',
598 'QBK','QCK','VGL','VJM','V1P','V8L','V8N','Z2U','Z2W','ZGM',
599 'ZBA','ZJK','ZJM','ZJR','ZLM','ZQM','ZRM','ZSK','ZSP','ZTU','Z5B','Z5C')
600 and
601 p_First_Action_NOA_LA_Code2 in
602 ('ABK','ABL','ABM','ACA','ACM','ALM','AQM',
603 'AYM','A2M','BAB','BAC','BAD','BAE','BYO',
604 'BBM','BDN','BKM',
605 'BLM','BNK','BNM','BNN','BNR','BNY','BNZ',
606 'BWA','BWM','BYM','HAM','K1M','K4M',
607 'K7M','K8M','K9M','LEM','LHM','LJM','LKM',
608 'LKP','L3M','LYP','PWM','P3M','P5M','P7M','QAK',
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'
618 and
619 NOT(
620 p_First_Action_NOA_LA_Code1 in
621 ('ABK','ABL','ABM','ACA','ACM','ALM','AQM',
622 'AYM','A2M','BAB','BAC','BAD','BAE','BYO',
623 'BBM','BDN','BEA','BKM',
624 'BLM','BMC','BNE','BNK','BNM','BNN','BNW','BNR','BNY','BNZ',
625 'BRM','BWA','BWM','BYM','HAM','K1M','K4M',
626 'K7M','K8M','K9M','LEM','LHM','LJM','LKM',
627 'LKP','L3M','LYP','PWM','P3M','P5M','P7M','QAK',
628 'QBK','QCK','VGL','VJM','V1P','V8L','V8N','Z2U','Z2W','ZGM',
629 'ZBA','ZJK','ZJM','ZJR','ZLM','ZQM','ZRM','ZSK','ZSP','ZTU','Z5B','Z5C')
630 and
631 p_First_Action_NOA_LA_Code2 in
632 ('ABK','ABL','ABM','ACA','ACM','ALM','AQM',
633 'AYM','A2M','BAB','BAC','BAD','BAE','BYO',
634 'BBM','BDN','BEA','BKM',
635 'BLM','BMC','BNE','BNK','BNM','BNN','BNW','BNR','BNY','BNZ',
636 'BRM','BWA','BWM','BYM','HAM','K1M','K4M',
637 'K7M','K8M','K9M','LEM','LHM','LJM','LKM',
638 'LKP','L3M','LYP','PWM','P3M','P5M','P7M','QAK',
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'
648 and
649 NOT(
650 p_First_Action_NOA_LA_Code1 in
651 ('ABK','ABL','ABM','ACA','ACM','ALM','AQM',
652 'AYM','A2M','BAB','BAC','BAD','BAE','BYO',
653 'BBM','BDN','BEA','BKM',
654 'BLM','BMC','BNE','BNK','BNM','BNN','BNW','BNR','BNY','BNZ',
655 'BRM','BWA','BWM','BYM','HAM','K1M','K4M',
656 'K7M','K8M','K9M','LEM','LHM','LJM','LKM',
657 'LKP','L3M','LYP','PWM','P3M','P5M','P7M','QAK',
658 'QBK','QCK','VJM','V1P','V8L','V8N','Z2U','Z2W','ZGM',
659 'ZBA','ZJK','ZJM','ZJR','ZLM','ZQM','ZRM','ZSK','ZSP','ZTU','Z5B','Z5C')
660 and
661 p_First_Action_NOA_LA_Code2 in
662 ('ABK','ABL','ABM','ACA','ACM','ALM','AQM',
663 'AYM','A2M','BAB','BAC','BAD','BAE','BYO',
664 'BBM','BDN','BEA','BKM',
665 'BLM','BMC','BNE','BNK','BNM','BNN','BNW','BNR','BNY','BNZ',
666 'BRM','BWA','BWM','BYM','HAM','K1M','K4M',
667 'K7M','K8M','K9M','LEM','LHM','LJM','LKM',
668 'LKP','L3M','LYP','PWM','P3M','P5M','P7M','QAK',
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
678 --
679 -- START OF 255.04.2
680 -- added 'BNK' for the april 98 release
681 -- added 'Z2U' on 22-jul-1998
682 -- added 'ZTA','Z2W' on 9-oct-1998 update 8
683 -- Update Date By Effective Date Comment
684 -- 8 03/09/99 vravikan 01/31/99 Delete BEA,BMC,BNE,BNW,BRM
685 -- 10/4 08/13/99 vravikan 01-Jan-99 Add VGL
686 -- 11/1 12/13/99 vravikan 01-Dec-99 Add ZBA
687 -- 11/9 12/13/99 vravikan 01-Nov-99 Add UDM
688 -- 17-Aug-00 vravikan From Begining Add ZBA,Delete BNP
689 -- 08-Dec-00 vravikan From Begining Delete ZTA
690 -- 30-Oct-03 Ashley From Begining Added BAB,BAC,BAD,BYO
691 -- 30-APR-04 Madhuri From Beginning Added LYP for 101
692 -- Upd 37 09-NOV-04 Madhuri From beginning Added LAC's - BNR, BNT
693 -- Upd 43 09-NOV-05 Raju From beginning Added BAE
694 -- Upd 39 vnarasim From Begining Added BNY, V8N
695 --upd49 19-Jan-07 Raju From Begining Bug#5619873 add BAF , delete BNT
696 -- Upd 54 12-Jun-07 vmididho From Begining delete BAF
697 -- Upd 56 13-Mar-09 Manish 01-Jan-2009 Added LA code BAG
698 -- Upd 56 13-Mar-09 Manish 17-Feb-2009 Added LA code ZEA
699 -- GPPA U51 14-Aug-09 Raju 11-Sep-2009 Added LAM(8799026)
700 -- GPPA U59 28-Oct-10 Raju Beginning Added Z5B, Z5C(10189715)
701 -- GPPA U59 31-Jul-12 Mani 10-Jul-12 Added LA Codes LAE, LAK
702 --BUG # 14395108
703 if p_effective_date >= to_date('2012/07/10','yyyy/mm/dd') then
704 if p_First_NOAC_Lookup_Code= '101'
705 and
706 NOT (
707 p_First_Action_NOA_LA_Code1 in
708 ('ABK','ABL','ABM','ACA','ACM','ALM','AQM',
709 'AYM','A2M','BAB','BAC','BAD','BAE','BYO',
710 'BBM','BDN','BKM','BAG',
711 'BLM','BNK','BNM','BNN','BNR','BNY',
712 'BWA','BWM','BYM','HAM','K1M','K4M',
713 'K7M','K8M','K9M','LAE','LAK','LAM','LEM','LHM','LJM','LKM',
714 'LKP','L3M','LYP','PWM','P3M','P5M','P7M','QAK',
715 'QBK','QCK','UDM','VGL','V1P','V8L','V8N','Z2U','Z2W',
716 'ZBA','ZGM','ZJK','ZJM',
717 'ZJR','ZLM','ZQM','ZRM','ZSK','ZSP','ZTU','ZEA','Z5B','Z5C')
718 and
719 p_First_Action_NOA_LA_Code2 in
720 ('ABK','ABL','ABM','ACA','ACM','ALM','AQM',
721 'AYM','A2M','BAB','BAC','BAD','BAE','BYO',
722 'BBM','BDN','BKM','BAG',
723 'BLM','BNK','BNM','BNN','BNR','BNY',
724 'BWA','BWM','BYM','HAM','K1M','K4M',
725 'K7M','K8M','K9M','LAE','LAK','LAM','LEM','LHM','LJM','LKM',
726 'LKP','L3M','LYP','PWM','P3M','P5M','P7M','QAK',
727 'QBK','QCK','UDM','VGL','V1P','V8L','V8N','Z2U','Z2W',
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.');
737 hr_utility.raise_error;
738 end if;
739 --BUG # 14395108
740 --End Bug# 8799026
741 --Begin Bug# 8799026
742 elsif p_effective_date >= to_date('2009/09/11','yyyy/mm/dd') then
743 if p_First_NOAC_Lookup_Code= '101'
744 and
745 NOT (
746 p_First_Action_NOA_LA_Code1 in
747 ('ABK','ABL','ABM','ACA','ACM','ALM','AQM',
748 'AYM','A2M','BAB','BAC','BAD','BAE','BYO',
749 'BBM','BDN','BKM','BAG',
750 'BLM','BNK','BNM','BNN','BNR','BNY',
751 'BWA','BWM','BYM','HAM','K1M','K4M',
752 'K7M','K8M','K9M','LAM','LEM','LHM','LJM','LKM',
753 'LKP','L3M','LYP','PWM','P3M','P5M','P7M','QAK',
754 'QBK','QCK','UDM','VGL','V1P','V8L','V8N','Z2U','Z2W',
755 'ZBA','ZGM','ZJK','ZJM',
756 'ZJR','ZLM','ZQM','ZRM','ZSK','ZSP','ZTU','ZEA','Z5B','Z5C')
757 and
758 p_First_Action_NOA_LA_Code2 in
759 ('ABK','ABL','ABM','ACA','ACM','ALM','AQM',
760 'AYM','A2M','BAB','BAC','BAD','BAE','BYO',
761 'BBM','BDN','BKM','BAG',
762 'BLM','BNK','BNM','BNN','BNR','BNY',
763 'BWA','BWM','BYM','HAM','K1M','K4M',
764 'K7M','K8M','K9M','LAM','LEM','LHM','LJM','LKM',
765 'LKP','L3M','LYP','PWM','P3M','P5M','P7M','QAK',
766 'QBK','QCK','UDM','VGL','V1P','V8L','V8N','Z2U','Z2W',
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.');
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'
781 and
782 NOT (
783 p_First_Action_NOA_LA_Code1 in
784 ('ABK','ABL','ABM','ACA','ACM','ALM','AQM',
785 'AYM','A2M','BAB','BAC','BAD','BAE','BYO',
786 'BBM','BDN','BKM','BAG',
787 'BLM','BNK','BNM','BNN','BNR','BNY',
788 'BWA','BWM','BYM','HAM','K1M','K4M',
789 'K7M','K8M','K9M','LEM','LHM','LJM','LKM',
790 'LKP','L3M','LYP','PWM','P3M','P5M','P7M','QAK',
791 'QBK','QCK','UDM','VGL','V1P','V8L','V8N','Z2U','Z2W',
792 'ZBA','ZGM','ZJK','ZJM',
793 'ZJR','ZLM','ZQM','ZRM','ZSK','ZSP','ZTU','ZEA','Z5B','Z5C')
794 and
795 p_First_Action_NOA_LA_Code2 in
796 ('ABK','ABL','ABM','ACA','ACM','ALM','AQM',
797 'AYM','A2M','BAB','BAC','BAD','BAE','BYO',
798 'BBM','BDN','BKM','BAG',
799 'BLM','BNK','BNM','BNN','BNR','BNY',
800 'BWA','BWM','BYM','HAM','K1M','K4M',
801 'K7M','K8M','K9M','LEM','LHM','LJM','LKM',
802 'LKP','L3M','LYP','PWM','P3M','P5M','P7M','QAK',
803 'QBK','QCK','UDM','VGL','V1P','V8L','V8N','Z2U','Z2W',
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.');
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
818 NOT (
819 p_First_Action_NOA_LA_Code1 in
820 ('ABK','ABL','ABM','ACA','ACM','ALM','AQM',
821 'AYM','A2M','BAB','BAC','BAD','BAE','BYO',
822 'BBM','BDN','BKM','BAG',
823 'BLM','BNK','BNM','BNN','BNR','BNY',
824 'BWA','BWM','BYM','HAM','K1M','K4M',
825 'K7M','K8M','K9M','LEM','LHM','LJM','LKM',
826 'LKP','L3M','LYP','PWM','P3M','P5M','P7M','QAK',
827 'QBK','QCK','UDM','VGL','V1P','V8L','V8N','Z2U','Z2W',
828 'ZBA','ZGM','ZJK','ZJM',
829 'ZJR','ZLM','ZQM','ZRM','ZSK','ZSP','ZTU','Z5B','Z5C')
830 and
831 p_First_Action_NOA_LA_Code2 in
832 ('ABK','ABL','ABM','ACA','ACM','ALM','AQM',
833 'AYM','A2M','BAB','BAC','BAD','BAE','BYO',
834 'BBM','BDN','BKM','BAG',
835 'BLM','BNK','BNM','BNN','BNR','BNY',
836 'BWA','BWM','BYM','HAM','K1M','K4M',
837 'K7M','K8M','K9M','LEM','LHM','LJM','LKM',
838 'LKP','L3M','LYP','PWM','P3M','P5M','P7M','QAK',
839 'QBK','QCK','UDM','VGL','V1P','V8L','V8N','Z2U','Z2W',
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.');
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
854 NOT (
855 p_First_Action_NOA_LA_Code1 in
856 ('ABK','ABL','ABM','ACA','ACM','ALM','AQM',
857 'AYM','A2M','BAB','BAC','BAD','BAE','BYO',
858 'BBM','BDN','BKM',
859 'BLM','BNK','BNM','BNN','BNR','BNY',
860 'BWA','BWM','BYM','HAM','K1M','K4M',
861 'K7M','K8M','K9M','LEM','LHM','LJM','LKM',
862 'LKP','L3M','LYP','PWM','P3M','P5M','P7M','QAK',
863 'QBK','QCK','UDM','VGL','V1P','V8L','V8N','Z2U','Z2W',
864 'ZBA','ZGM','ZJK','ZJM',
865 'ZJR','ZLM','ZQM','ZRM','ZSK','ZSP','ZTU','Z5B','Z5C')
866 and
867 p_First_Action_NOA_LA_Code2 in
868 ('ABK','ABL','ABM','ACA','ACM','ALM','AQM',
869 'AYM','A2M','BAB','BAC','BAD','BAE','BYO',
870 'BBM','BDN','BKM',
871 'BLM','BNK','BNM','BNN','BNR','BNY',
872 'BWA','BWM','BYM','HAM','K1M','K4M',
873 'K7M','K8M','K9M','LEM','LHM','LJM','LKM',
874 'LKP','L3M','LYP','PWM','P3M','P5M','P7M','QAK',
875 'QBK','QCK','UDM','VGL','V1P','V8L','V8N','Z2U','Z2W',
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.');
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
890 NOT (
891 p_First_Action_NOA_LA_Code1 in
892 ('ABK','ABL','ABM','ACA','ACM','ALM','AQM',
893 'AYM','A2M','BAB','BAC','BAD','BAE','BYO',
894 'BBM','BDN','BKM',
895 'BLM','BNK','BNM','BNN','BNR','BNY',
896 'BWA','BWM','BYM','HAM','K1M','K4M',
897 'K7M','K8M','K9M','LEM','LHM','LJM','LKM',
898 'LKP','L3M','LYP','PWM','P3M','P5M','P7M','QAK',
899 'QBK','QCK','UDM','VGL','V1P','V8L','V8N','Z2U','Z2W',
900 'ZBA','ZGM','ZJK','ZJM',
901 'ZJR','ZLM','ZQM','ZRM','ZSK','ZSP','ZTU','Z5B','Z5C')
902 and
903 p_First_Action_NOA_LA_Code2 in
904 ('ABK','ABL','ABM','ACA','ACM','ALM','AQM',
905 'AYM','A2M','BAB','BAC','BAD','BAE','BYO',
906 'BBM','BDN','BKM',
907 'BLM','BNK','BNM','BNN','BNR','BNY',
908 'BWA','BWM','BYM','HAM','K1M','K4M',
909 'K7M','K8M','K9M','LEM','LHM','LJM','LKM',
910 'LKP','L3M','LYP','PWM','P3M','P5M','P7M','QAK',
911 'QBK','QCK','UDM','VGL','V1P','V8L','V8N','Z2U','Z2W',
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'
921 and
922 NOT (
923 p_First_Action_NOA_LA_Code1 in
924 ('ABK','ABL','ABM','ACA','ACM','ALM','AQM',
925 'AYM','A2M','BAB','BAC','BAD','BAE','BYO',
926 'BBM','BDN','BKM',
927 'BLM','BNK','BNM','BNN','BNR','BNY',
928 'BWA','BWM','BYM','HAM','K1M','K4M',
929 'K7M','K8M','K9M','LEM','LHM','LJM','LKM',
930 'LKP','L3M','LYP','PWM','P3M','P5M','P7M','QAK',
931 'QBK','QCK','VGL','V1P','V8L','V8N','Z2U','Z2W','ZGM','ZJK','ZJM',
932 'ZBA','ZJR','ZLM','ZQM','ZRM','ZSK','ZSP','ZTU','Z5B','Z5C')
933 and
934 p_First_Action_NOA_LA_Code2 in
935 ('ABK','ABL','ABM','ACA','ACM','ALM','AQM',
936 'AYM','A2M','BAB','BAC','BAD','BAE','BYO',
937 'BBM','BDN','BKM',
938 'BLM','BNK','BNM','BNN','BNR','BNY',
939 'BWA','BWM','BYM','HAM','K1M','K4M',
940 'K7M','K8M','K9M','LEM','LHM','LJM','LKM',
941 'LKP','L3M','LYP','PWM','P3M','P5M','P7M','QAK',
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'
951 and
952 NOT (
953 p_First_Action_NOA_LA_Code1 in
954 ('ABK','ABL','ABM','ACA','ACM','ALM','AQM',
955 'AYM','A2M','BAB','BAC','BAD','BAE','BYO',
956 'BBM','BDN','BEA','BKM',
957 'BLM','BMC','BNE','BNK','BNM','BNN','BNW','BNR','BNY',
958 'BRM','BWA','BWM','BYM','HAM','K1M','K4M',
959 'K7M','K8M','K9M','LEM','LHM','LJM','LKM',
960 'LKP','L3M','LYP','PWM','P3M','P5M','P7M','QAK',
961 'QBK','QCK','VGL','V1P','V8L','V8N','Z2U','Z2W','ZGM','ZJK','ZJM',
962 'ZBA','ZJR','ZLM','ZQM','ZRM','ZSK','ZSP','ZTU','Z5B','Z5C')
963 and
964 p_First_Action_NOA_LA_Code2 in
965 ('ABK','ABL','ABM','ACA','ACM','ALM','AQM',
966 'AYM','A2M','BAB','BAC','BAD','BAE','BYO',
967 'BBM','BDN','BEA','BKM',
968 'BLM','BMC','BNE','BNK','BNM','BNN','BNW','BNR','BNY',
969 'BRM','BWA','BWM','BYM','HAM','K1M','K4M',
970 'K7M','K8M','K9M','LEM','LHM','LJM','LKM',
971 'LKP','L3M','LYP','PWM','P3M','P5M','P7M','QAK',
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'
981 and
982 NOT (
983 p_First_Action_NOA_LA_Code1 in
984 ('ABK','ABL','ABM','ACA','ACM','ALM','AQM',
985 'AYM','A2M','BAB','BAC','BAD','BAE','BYO',
986 'BBM','BDN','BEA','BKM',
987 'BLM','BMC','BNE','BNK','BNM','BNN','BNW','BNR','BNY',
988 'BRM','BWA','BWM','BYM','HAM','K1M','K4M',
989 'K7M','K8M','K9M','LEM','LHM','LJM','LKM',
990 'LKP','L3M','LYP','PWM','P3M','P5M','P7M','QAK',
991 'QBK','QCK','V1P','V8L','V8N','Z2U','Z2W','ZGM','ZJK','ZJM',
992 'ZBA','ZJR','ZLM','ZQM','ZRM','ZSK','ZSP','ZTU','Z5B','Z5C')
993 and
994 p_First_Action_NOA_LA_Code2 in
995 ('ABK','ABL','ABM','ACA','ACM','ALM','AQM',
996 'AYM','A2M','BAB','BAC','BAD','BAE','BYO',
997 'BBM','BDN','BEA','BKM',
998 'BLM','BMC','BNE','BNK','BNM','BNN','BNW','BNR','BNY',
999 'BRM','BWA','BWM','BYM','HAM','K1M','K4M',
1000 'K7M','K8M','K9M','LEM','LHM','LJM','LKM',
1001 'LKP','L3M','LYP','PWM','P3M','P5M','P7M','QAK',
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
1011 --
1012 --
1013 --265.02.2
1014 -- the edit is renumbered from 265.01.2 for the april release
1015 -- added 'Z2U' on 22-jul-1998
1016 -- Update/Change Date By Effective Date Comment
1017 -- 8/5 03/09/99 vravikan From the Start Add BWA
1018 -- 8/5 03/09/99 vravikan 02/27/99 Delete ACM
1019 --- Upd 56 13-Mar-09 Manish 17-Feb-2009 Added LA code ZEA
1020 --- Upd 57 29-Jul-09 Mani 01-Jan-2009 Added LA code BAG
1021
1022 if p_effective_date < fnd_date.canonical_to_date('19'||'99/02/27') then
1023 if p_First_NOAC_Lookup_Code= '107'
1024 and
1025 NOT(
1026 p_First_Action_NOA_LA_Code1 in
1027 ('ABL','ABM','ABR','ABS','ACM','ALM','AQM','BWA',
1028 'BWM','HAM','HDM','HGM','HJM','HLM','NUM',
1029 'QBK','V1P','V8N','Z2U','ZLM','ZRM','ZSK')
1030 AND
1031 p_First_Action_NOA_LA_Code2 in
1032 ('ABL','ABM','ABR','ABS','ACM','ALM','AQM','BWA',
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'
1042 and
1043 NOT(
1044 p_First_Action_NOA_LA_Code1 in
1045 ('ABL','ABM','ABR','ABS','ALM','AQM','BWA',
1046 'BWM','HAM','HDM','HGM','HJM','HLM','NUM',
1047 'QBK','V1P','V8N','Z2U','ZLM','ZRM','ZSK')
1048 AND
1049 p_First_Action_NOA_LA_Code2 in
1050 ('ABL','ABM','ABR','ABS','ALM','AQM','BWA',
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
1060 if p_First_NOAC_Lookup_Code= '107'
1061 and
1062 NOT(
1063 p_First_Action_NOA_LA_Code1 in
1064 ('ABL','ABM','ABR','ABS','ALM','AQM','BWA',
1065 'BWM','BAG','HAM','HDM','HGM','HJM','HLM','NUM',
1066 'QBK','V1P','V8N','Z2U','ZLM','ZRM','ZSK')
1067 AND
1068 p_First_Action_NOA_LA_Code2 in
1069 ('ABL','ABM','ABR','ABS','ALM','AQM','BWA',
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
1079 if p_First_NOAC_Lookup_Code= '107'
1080 and
1081 NOT(
1082 p_First_Action_NOA_LA_Code1 in
1083 ('ABL','ABM','ABR','ABS','ALM','AQM','BWA',
1084 'BWM','BAG','HAM','HDM','HGM','HJM','HLM','NUM',
1085 'QBK','V1P','V8N','Z2U','ZLM','ZRM','ZSK','ZEA')
1086 AND
1087 p_First_Action_NOA_LA_Code2 in
1088 ('ABL','ABM','ABR','ABS','ALM','AQM','BWA',
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;
1098
1099 --265.04.2
1100 -- added 'Z2U' on 22-jul-1998
1101 -- added 'Z2W' on 9-oct-1998 update 8
1102 -- fixed bug 738789 by changing HCM to MCM
1103 -- Update Date By Effective Date Comment
1104 -- 8 03/09/99 vravikan 01/31/99 Delete BEA,BMC,BNE,BNW,BRM
1105 -- 8 03/09/99 vravikan Add ZTU
1106 -- 8 03/09/99 vravikan 02/27/99 Delete ACM,MLL,MCM
1107 -- 10/4 08/13/99 vravikan 01-Jan-99 Add VGL
1108 -- 11/9 12/14/99 vravikan 01-Nov-1999 Add UDM
1109 -- 08-Dec-00 vravikan From Begining Add ZJM
1110 -- 10/30/03 Ashley From Begining Added BAB,BAC,BAD,BYO
1111 -- Upd 43 09-NOV-05 Raju From beginning Added BAE
1112 -- Upd 47 23-Jun-06 Raju From beginning Added BNZ,Z5B, Z5C, Z5F, Z5H, Z5J
1113 -- upd49 19-Jan-07 Raju From beginning Bug#5619873 add BAF
1114 -- Upd 54 12-Jun-07 vmididho From Begining delete BAF
1115 --- Upd 56 13-Mar-09 Manish 01-Jan-2009 Added LA code BAG
1116 --- Upd 56 13-Mar-09 Manish 17-Feb-2009 Added LA code ZEA
1117 --- Upd 57 29-Jul-09 Mani 01-Mar-2009 Removed BNZ, Z5H
1118 --- Upd 57 29-Jul-09 Mani From Begining Added Z6L
1119 -- GPPA U51 14-Aug-09 Raju 11-Sep-2009 Added LDM(8799026)
1120 -- GPPA U59 31-Jul-12 Mani 10-Jul-12 Added LA Codes MAB, MAC, MAF, MAG
1121 -- GPPA U61 07-Feb-13 Raju 06-Jan-13 Removed LA Code MAG bug# 16217492
1122 --BUG # 16217492
1123 if p_effective_date > to_date('2013/01/06','yyyy/mm/dd') then
1124 if p_First_NOAC_Lookup_Code= '108'
1125 and
1126 NOT ( p_First_Action_NOA_LA_Code1 in
1127 ('ABK','ABL','ABM','ABR','ABS','ALM',
1128 'AYM','BAB','BAC','BAD','BAE', 'BAG', 'BYO',
1129 'BWA','BWM','HAM','LDM','MAB', 'MAC', 'MAF', 'MEM','MGM','MJM',
1130 'MLK','MLM','MMM','NUM','QAK','UDM','VGL','VJM',
1131 'V1P','V8L','V8N','Z2U','Z2W','ZJK','ZLM',
1132 'ZQM','ZRM','ZSK','ZSP','ZTM','ZTU','ZJM','Z5B', 'Z5C', 'Z5F', 'Z5J','ZEA','Z6L') AND
1133 p_First_Action_NOA_LA_Code2 in
1134 ('ABK','ABL','ABM','ABR','ABS','ALM',
1135 'AYM','BAB','BAC','BAD','BAE','BAG','BYO',
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;
1145 end if;
1146 --BUG # 16217492
1147
1148 --BUG # 14395108
1149 elsif p_effective_date >= to_date('2012/07/10','yyyy/mm/dd') then
1150 if p_First_NOAC_Lookup_Code= '108'
1151 and
1152 NOT ( p_First_Action_NOA_LA_Code1 in
1153 ('ABK','ABL','ABM','ABR','ABS','ALM',
1154 'AYM','BAB','BAC','BAD','BAE', 'BAG', 'BYO',
1155 'BWA','BWM','HAM','LDM','MAB', 'MAC', 'MAF', 'MAG','MEM','MGM','MJM',
1156 'MLK','MLM','MMM','NUM','QAK','UDM','VGL','VJM',
1157 'V1P','V8L','V8N','Z2U','Z2W','ZJK','ZLM',
1158 'ZQM','ZRM','ZSK','ZSP','ZTM','ZTU','ZJM','Z5B', 'Z5C', 'Z5F', 'Z5J','ZEA','Z6L') AND
1159 p_First_Action_NOA_LA_Code2 in
1160 ('ABK','ABL','ABM','ABR','ABS','ALM',
1161 'AYM','BAB','BAC','BAD','BAE','BAG','BYO',
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;
1171 end if;
1172 --BUG # 14395108
1173 --Begin Bug# 8799026
1174 elsif p_effective_date >= to_date('2009/09/11','yyyy/mm/dd') then
1175 if p_First_NOAC_Lookup_Code= '108'
1176 and
1177 NOT ( p_First_Action_NOA_LA_Code1 in
1178 ('ABK','ABL','ABM','ABR','ABS','ALM',
1179 'AYM','BAB','BAC','BAD','BAE', 'BAG', 'BYO',
1180 'BWA','BWM','HAM','LDM','MEM','MGM','MJM',
1181 'MLK','MLM','MMM','NUM','QAK','UDM','VGL','VJM',
1182 'V1P','V8L','V8N','Z2U','Z2W','ZJK','ZLM',
1183 'ZQM','ZRM','ZSK','ZSP','ZTM','ZTU','ZJM','Z5B', 'Z5C', 'Z5F', 'Z5J','ZEA','Z6L') AND
1184 p_First_Action_NOA_LA_Code2 in
1185 ('ABK','ABL','ABM','ABR','ABS','ALM',
1186 'AYM','BAB','BAC','BAD','BAE','BAG','BYO',
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;
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'
1200 and
1201 NOT ( p_First_Action_NOA_LA_Code1 in
1202 ('ABK','ABL','ABM','ABR','ABS','ALM',
1203 'AYM','BAB','BAC','BAD','BAE', 'BAG', 'BYO',
1204 'BWA','BWM','HAM','MEM','MGM','MJM',
1205 'MLK','MLM','MMM','NUM','QAK','UDM','VGL','VJM',
1206 'V1P','V8L','V8N','Z2U','Z2W','ZJK','ZLM',
1207 'ZQM','ZRM','ZSK','ZSP','ZTM','ZTU','ZJM','Z5B', 'Z5C', 'Z5F', 'Z5J','ZEA','Z6L') AND
1208 p_First_Action_NOA_LA_Code2 in
1209 ('ABK','ABL','ABM','ABR','ABS','ALM',
1210 'AYM','BAB','BAC','BAD','BAE','BAG','BYO',
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;
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
1224 NOT ( p_First_Action_NOA_LA_Code1 in
1225 ('ABK','ABL','ABM','ABR','ABS','ALM',
1226 'AYM','BAB','BAC','BAD','BAE', 'BAG', 'BNZ','BYO',
1227 'BWA','BWM','HAM','MEM','MGM','MJM',
1228 'MLK','MLM','MMM','NUM','QAK','UDM','VGL','VJM',
1229 'V1P','V8L','V8N','Z2U','Z2W','ZJK','ZLM',
1230 'ZQM','ZRM','ZSK','ZSP','ZTM','ZTU','ZJM','Z5B', 'Z5C', 'Z5F', 'Z5H', 'Z5J','ZEA','Z6L') AND
1231 p_First_Action_NOA_LA_Code2 in
1232 ('ABK','ABL','ABM','ABR','ABS','ALM',
1233 'AYM','BAB','BAC','BAD','BAE','BAG','BNZ','BYO',
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;
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
1247 NOT ( p_First_Action_NOA_LA_Code1 in
1248 ('ABK','ABL','ABM','ABR','ABS','ALM',
1249 'AYM','BAB','BAC','BAD','BAE', 'BAG', 'BNZ','BYO',
1250 'BWA','BWM','HAM','MEM','MGM','MJM',
1251 'MLK','MLM','MMM','NUM','QAK','UDM','VGL','VJM',
1252 'V1P','V8L','V8N','Z2U','Z2W','ZJK','ZLM',
1253 'ZQM','ZRM','ZSK','ZSP','ZTM','ZTU','ZJM','Z5B', 'Z5C', 'Z5F', 'Z5H', 'Z5J','Z6L') AND
1254 p_First_Action_NOA_LA_Code2 in
1255 ('ABK','ABL','ABM','ABR','ABS','ALM',
1256 'AYM','BAB','BAC','BAD','BAE','BAG','BNZ','BYO',
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;
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
1270 NOT ( p_First_Action_NOA_LA_Code1 in
1271 ('ABK','ABL','ABM','ABR','ABS','ALM',
1272 'AYM','BAB','BAC','BAD','BAE','BNZ','BYO',
1273 'BWA','BWM','HAM','MEM','MGM','MJM',
1274 'MLK','MLM','MMM','NUM','QAK','UDM','VGL','VJM',
1275 'V1P','V8L','V8N','Z2U','Z2W','ZJK','ZLM',
1276 'ZQM','ZRM','ZSK','ZSP','ZTM','ZTU','ZJM','Z5B', 'Z5C', 'Z5F', 'Z5H', 'Z5J','Z6L') AND
1277 p_First_Action_NOA_LA_Code2 in
1278 ('ABK','ABL','ABM','ABR','ABS','ALM',
1279 'AYM','BAB','BAC','BAD','BAE','BNZ','BYO',
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;
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
1293 NOT ( p_First_Action_NOA_LA_Code1 in
1294 ('ABK','ABL','ABM','ABR','ABS','ALM',
1295 'AYM','BAB','BAC','BAD','BAE','BNZ','BYO',
1296 'BWA','BWM','HAM','MEM','MGM','MJM',
1297 'MLK','MLM','MMM','NUM','QAK','VGL','VJM',
1298 'V1P','V8L','V8N','Z2U','Z2W','ZJK','ZLM',
1299 'ZQM','ZRM','ZSK','ZSP','ZTM','ZTU','ZJM','Z5B', 'Z5C', 'Z5F', 'Z5H', 'Z5J','Z6L') AND
1300 p_First_Action_NOA_LA_Code2 in
1301 ('ABK','ABL','ABM','ABR','ABS','ALM',
1302 'AYM','BAB','BAC','BAD','BAE','BNZ','BYO',
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'
1312 and
1313 NOT ( p_First_Action_NOA_LA_Code1 in
1314 ('ABK','ABL','ABM','ABR','ABS','ACM','ALM',
1315 'AYM','BAB','BAC','BAD','BAE','BNZ','BYO',
1316 'BWA','BWM','HAM','MCM','MEM','MGM','MJM',
1317 'MLK','MLL','MLM','MMM','NUM','QAK','VGL','VJM',
1318 'V1P','V8L','V8N','Z2U','Z2W','ZJK','ZLM',
1319 'ZQM','ZRM','ZSK','ZSP','ZTM','ZTU','ZJM','Z5B', 'Z5C', 'Z5F', 'Z5H', 'Z5J','Z6L') AND
1320 p_First_Action_NOA_LA_Code2 in
1321 ('ABK','ABL','ABM','ABR','ABS','ACM','ALM',
1322 'AYM','BAB','BAC','BAD','BAE','BNZ','BYO',
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'
1332 and
1333 NOT ( p_First_Action_NOA_LA_Code1 in
1334 ('ABK','ABL','ABM','ABR','ABS','ACM','ALM',
1335 'AYM','BEA','BMC','BNE','BNW','BNZ','BRM',
1336 'BAB','BAC','BAD','BAE','BYO',
1337 'BWA','BWM','HAM','MCM','MEM','MGM','MJM',
1338 'MLK','MLL','MLM','MMM','NUM','QAK','VJM',
1339 'V1P','V8L','V8N','Z2U','Z2W','ZJK','VGL','ZLM',
1340 'ZQM','ZRM','ZSK','ZSP','ZTM','ZTU','ZJM','Z5B', 'Z5C', 'Z5F', 'Z5H', 'Z5J','Z6L') AND
1341 p_First_Action_NOA_LA_Code2 in
1342 ('ABK','ABL','ABM','ABR','ABS','ACM','ALM',
1343 'AYM','BEA','BMC','BNE','BNW','BNZ','BRM',
1344 'BAB','BAC','BAD','BAE','BYO',
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'
1354 and
1355 NOT ( p_First_Action_NOA_LA_Code1 in
1356 ('ABK','ABL','ABM','ABR','ABS','ACM','ALM',
1357 'AYM','BEA','BMC','BNE','BNW','BNZ','BRM',
1358 'BAB','BAC','BAD','BAE','BYO',
1359 'BWA','BWM','HAM','MCM','MEM','MGM','MJM',
1360 'MLK','MLL','MLM','MMM','NUM','QAK','VJM',
1361 'V1P','V8L','V8N','Z2U','Z2W','ZJK','ZLM',
1362 'ZQM','ZRM','ZSK','ZSP','ZTM','ZTU','ZJM','Z5B', 'Z5C', 'Z5F', 'Z5H', 'Z5J','Z6L') AND
1363 p_First_Action_NOA_LA_Code2 in
1364 ('ABK','ABL','ABM','ABR','ABS','ACM','ALM',
1365 'AYM','BEA','BMC','BNE','BNW','BNZ','BRM',
1366 'BAB','BAC','BAD','BAE','BYO',
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
1376 --265.10.2
1377 -- added 'Z2U' on 22-jul-1998
1378 -- added 'Z2W' on 9-oct-1998 update 8
1379 -- Update Date By Effective Date Bug Comment
1380 -- 8 03/09/99 vravikan 01/31/99 Delete BEA,BMC,BNE,BNW,BRM
1381 -- 8 03/09/99 vravikan 02/27/99 Delete ACM,NEL,MXM,CTM
1382 -- 8 04/22/99 vravikan 02/27/99 871385 Add MXM,CTM
1383 -- 10/4 08/13/99 vravikan 01-Jan-99 Add VGL
1384 -- 9/3 09/15/99 vravikan 27-Feb-99 992944 Delete MXM,CTM
1385 -- 11/17/99 AVR 27-Feb-99 1079338 Add MXM
1386 -- 11/9 12/14/99 vravikan 01-Nov-1999 Add UDM
1387 -- 10/30/03 Ashley From Begining Added BAB,BAC,BAD,BYO
1388 -- Upd 43 09-NOV-05 Raju From beginning Added BAE
1389 -- Upd 47 23-Jun-06 Raju From beginning Added Z5B, Z5C, Z5F, Z5G, Z5H
1390 -- upd49 19-Jan-07 Raju From Beginning Bug#5619873 Add WTA, WTB,BAF and WUM
1391 -- Upd 54 12-Jun-07 vmididho From Begining delete BAF
1392 --- Upd 56 13-Mar-09 Manish 01-Jan-2009 Added LA code BAG
1393 --- Upd 56 13-Mar-09 Manish 17-Feb-2009 Added LA code ZEA
1394 -- GPPA U51 14-Aug-09 Raju 11-Sep-2009 Added LCM(8799026)
1395 -- U59 10189715 Raju From Begining Removed WTA, WTB,WUM
1396 --Begin Bug# 8799026
1397 if p_effective_date >= to_date('2009/09/11','yyyy/mm/dd') then
1398 if p_First_NOAC_Lookup_Code= '115'
1399 and
1400 NOT ( p_First_Action_NOA_LA_Code1 in
1401 ('ABK','ABL','ABM','ABR','ABS','ALM',
1402 'AYM','BAB','BAC','BAD','BAE','BAG','BYO',
1403 'BWA','BWM','HAM','KLM','LCM','MXM',
1404 'M6M','M8M','NAM','NCM','NEM','NJM',
1405 'NUM','QAK','SZX','UDM','VGL','VJM','V1P','V8L','V8N',
1406 'Z2U','Z2W','ZJK','ZLM','ZQM','ZRM','ZSK',
1407 'ZSP','ZTM','ZTU','Z5B','Z5C','Z5F','Z5G','Z5H','ZEA') AND
1408 p_First_Action_NOA_LA_Code2 in
1409 ('ABK','ABL','ABM','ABR','ABS','ALM',
1410 'AYM','BAB','BAC','BAD','BAE','BAG','BYO',
1411 'BWA','BWM','HAM','KLM','LCM','MXM',
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;
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'
1425 and
1426 NOT ( p_First_Action_NOA_LA_Code1 in
1427 ('ABK','ABL','ABM','ABR','ABS','ALM',
1428 'AYM','BAB','BAC','BAD','BAE','BAG','BYO',
1429 'BWA','BWM','HAM','KLM','MXM',
1430 'M6M','M8M','NAM','NCM','NEM','NJM',
1431 'NUM','QAK','SZX','UDM','VGL','VJM','V1P','V8L','V8N',
1432 'Z2U','Z2W','ZJK','ZLM','ZQM','ZRM','ZSK',
1433 'ZSP','ZTM','ZTU','Z5B','Z5C','Z5F','Z5G','Z5H','ZEA') AND
1434 p_First_Action_NOA_LA_Code2 in
1435 ('ABK','ABL','ABM','ABR','ABS','ALM',
1436 'AYM','BAB','BAC','BAD','BAE','BAG','BYO',
1437 'BWA','BWM','HAM','KLM','MXM',
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;
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
1451 NOT ( p_First_Action_NOA_LA_Code1 in
1452 ('ABK','ABL','ABM','ABR','ABS','ALM',
1453 'AYM','BAB','BAC','BAD','BAE','BAG','BYO',
1454 'BWA','BWM','HAM','KLM','MXM',
1455 'M6M','M8M','NAM','NCM','NEM','NJM',
1456 'NUM','QAK','SZX','UDM','VGL','VJM','V1P','V8L','V8N',
1457 'Z2U','Z2W','ZJK','ZLM','ZQM','ZRM','ZSK',
1458 'ZSP','ZTM','ZTU','Z5B','Z5C','Z5F','Z5G','Z5H') AND
1459 p_First_Action_NOA_LA_Code2 in
1460 ('ABK','ABL','ABM','ABR','ABS','ALM',
1461 'AYM','BAB','BAC','BAD','BAE','BAG','BYO',
1462 'BWA','BWM','HAM','KLM','MXM',
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;
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
1476 NOT ( p_First_Action_NOA_LA_Code1 in
1477 ('ABK','ABL','ABM','ABR','ABS','ALM',
1478 'AYM','BAB','BAC','BAD','BAE','BYO',
1479 'BWA','BWM','HAM','KLM','MXM',
1480 'M6M','M8M','NAM','NCM','NEM','NJM',
1481 'NUM','QAK','SZX','UDM','VGL','VJM','V1P','V8L','V8N',
1482 'Z2U','Z2W','ZJK','ZLM','ZQM','ZRM','ZSK',
1483 'ZSP','ZTM','ZTU','Z5B','Z5C','Z5F','Z5G','Z5H') AND
1484 p_First_Action_NOA_LA_Code2 in
1485 ('ABK','ABL','ABM','ABR','ABS','ALM',
1486 'AYM','BAB','BAC','BAD','BAE','BYO',
1487 'BWA','BWM','HAM','KLM','MXM',
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;
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
1501 NOT ( p_First_Action_NOA_LA_Code1 in
1502 ('ABK','ABL','ABM','ABR','ABS','ALM',
1503 'AYM','BAB','BAC','BAD','BAE','BYO',
1504 'BWA','BWM','HAM','KLM','MXM',
1505 'M6M','M8M','NAM','NCM','NEM','NJM',
1506 'NUM','QAK','SZX','VGL','VJM','V1P','V8L','V8N',
1507 'Z2U','Z2W','ZJK','ZLM','ZQM','ZRM','ZSK',
1508 'ZSP','ZTM','ZTU','Z5B','Z5C','Z5F','Z5G','Z5H') AND
1509 p_First_Action_NOA_LA_Code2 in
1510 ('ABK','ABL','ABM','ABR','ABS','ALM',
1511 'AYM','BAB','BAC','BAD','BAE','BYO',
1512 'BWA','BWM','HAM','KLM','MXM',
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'
1522 and
1523 NOT ( p_First_Action_NOA_LA_Code1 in
1524 ('ABK','ABL','ABM','ABR','ABS','ACM','ALM',
1525 'AYM','BAB','BAC','BAD','BAE','BYO',
1526 'BWA','BWM','CTM','HAM','KLM','MXM',
1527 'M6M','M8M','NAM','NCM','NEL','NEM','NJM',
1528 'NUM','QAK','SZX','VGL','VJM','V1P','V8L','V8N',
1529 'Z2U','Z2W','ZJK','ZLM','ZQM','ZRM','ZSK',
1530 'ZSP','ZTM','ZTU','Z5B','Z5C','Z5F','Z5G','Z5H') AND
1531 p_First_Action_NOA_LA_Code2 in
1532 ('ABK','ABL','ABM','ABR','ABS','ACM','ALM',
1533 'AYM','BAB','BAC','BAD','BAE','BYO',
1534 'BWA','BWM','CTM','HAM','KLM','MXM',
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'
1544 and
1545 NOT ( p_First_Action_NOA_LA_Code1 in
1546 ('ABK','ABL','ABM','ABR','ABS','ACM','ALM',
1547 'AYM','BAB','BAC','BAD','BAE','BYO',
1548 'BEA','BMC','BNE','BNW','BRM',
1549 'BWA','BWM','CTM','HAM','KLM','MXM',
1550 'M6M','M8M','NAM','NCM','NEL','NEM','NJM',
1551 'NUM','QAK','SZX','VGL','VJM','V1P','V8L','V8N',
1552 'Z2U','Z2W','ZJK','ZLM','ZQM','ZRM','ZSK',
1553 'ZSP','ZTM','ZTU','Z5B','Z5C','Z5F','Z5G','Z5H') AND
1554 p_First_Action_NOA_LA_Code2 in
1555 ('ABK','ABL','ABM','ABR','ABS','ACM','ALM',
1556 'AYM','BAB','BAC','BAD','BAE','BYO',
1557 'BEA','BMC','BNE','BNW','BRM',
1558 'BWA','BWM','CTM','HAM','KLM','MXM',
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'
1568 and
1569 NOT ( p_First_Action_NOA_LA_Code1 in
1570 ('ABK','ABL','ABM','ABR','ABS','ACM','ALM',
1571 'AYM','BAB','BAC','BAD','BAE','BYO',
1572 'BEA','BMC','BNE','BNW','BRM',
1573 'BWA','BWM','CTM','HAM','KLM','MXM',
1574 'M6M','M8M','NAM','NCM','NEL','NEM','NJM',
1575 'NUM','QAK','SZX','VJM','V1P','V8L','V8N',
1576 'Z2U','Z2W','ZJK','ZLM','ZQM','ZRM','ZSK',
1577 'ZSP','ZTM','ZTU','Z5B','Z5C','Z5F','Z5G','Z5H') AND
1578 p_First_Action_NOA_LA_Code2 in
1579 ('ABK','ABL','ABM','ABR','ABS','ACM','ALM',
1580 'AYM','BAB','BAC','BAD','BAE','BYO',
1581 'BEA','BMC','BNE','BNW','BRM',
1582 'BWA','BWM','CTM','HAM','KLM','MXM',
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
1592 --265.07.2
1593 -- added 'Z2U' on 22-jul-1998
1594 -- UPDATE/CHANGE DATE UPDATED BY EFFECTIVE_DATE COMMENTS
1595 --------------------------------------------------------------------------------------------------------
1596 -- 10/4 08/13/99 vravikan 01-Jan-1999 Add VGL
1597 -- 14-SEP-2004 Madhuri Edit to be terminated as of 31 AUG 2004.
1598 -- (End Date to 31st Aug 2004)
1599 --------------------------------------------------------------------------------------------------------
1600 IF ( p_effective_date <= to_date('20'||'04/08/31','yyyy/mm/dd') ) THEN
1601
1602 IF ( p_effective_date >= to_date('19'||'99/01/01','yyyy/mm/dd') ) THEN
1603
1604 IF p_First_NOAC_Lookup_Code= '112' AND
1605 NOT ((p_First_Action_NOA_LA_Code1 in
1606 ('ABL','ABM','ALM','AQM','AYM','BWM','HAM',
1607 'MAM','MBM','QDK','V1P','V8N','VGL','Z2U','ZJR','ZLM',
1608 'ZRM','ZSK','ZSP','ZTM','ZTU') OR
1609 (SUBSTR(p_First_Action_NOA_LA_Code1,1,1) = 'X' AND
1610 LENGTH(p_First_Action_NOA_LA_Code1) =3 ))
1611 AND
1612 (p_First_Action_NOA_LA_Code2 in
1613 ('ABL','ABM','ALM','AQM','AYM','BWM','HAM',
1614 'MAM','MBM','QDK','V1P','V8N','VGL','Z2U','ZJR','ZLM',
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'
1624 and
1625 NOT ((p_First_Action_NOA_LA_Code1 in
1626 ('ABL','ABM','ALM','AQM','AYM','BWM','HAM',
1627 'MAM','MBM','QDK','V1P','V8N','Z2U','ZJR','ZLM',
1628 'ZRM','ZSK','ZSP','ZTM','ZTU') OR
1629 (SUBSTR(p_First_Action_NOA_LA_Code1,1,1) = 'X' AND
1630 LENGTH(p_First_Action_NOA_LA_Code1) =3 ))
1631 AND
1632 (p_First_Action_NOA_LA_Code2 in
1633 ('ABL','ABM','ALM','AQM','AYM','BWM','HAM',
1634 'MAM','MBM','QDK','V1P','V8N','Z2U','ZJR','ZLM',
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
1644
1645 --270.04.2
1646 -- Upd 47 23-Jun-06 Raju From beginning Added AYM, Z5C
1647 --- Upd 56 13-Mar-09 Manish 17-Feb-2009 Added LA code ZEA
1648 --- Upd 57 01-Jan-09 Mani 01-Jan-2009 Added LA code BAG
1649
1650 IF ( p_effective_date >= to_date('2009/02/17','yyyy/mm/dd') ) THEN
1651 if p_First_NOAC_Lookup_Code= '120' and
1652 NOT ( p_First_Action_NOA_LA_Code1 in
1653 ('ABM','ALM','AQM','AYM','BAG','BWM','HAM','HNM','HRM',
1654 'QAK','QBK','QCK','V1P','ZLM','ZRM','ZSK','Z5C','ZEA')
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
1664 if p_First_NOAC_Lookup_Code= '120' and
1665 NOT ( p_First_Action_NOA_LA_Code1 in
1666 ('ABM','ALM','AQM','AYM','BAG','BWM','HAM','HNM','HRM',
1667 'QAK','QBK','QCK','V1P','ZLM','ZRM','ZSK','Z5C')
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
1677 if p_First_NOAC_Lookup_Code= '120' and
1678 NOT ( p_First_Action_NOA_LA_Code1 in
1679 ('ABM','ALM','AQM','AYM','BWM','HAM','HNM','HRM',
1680 'QAK','QBK','QCK','V1P','ZLM','ZRM','ZSK','Z5C')
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;
1690
1691 --270.07.2
1692 --- Upd 56 13-Mar-09 Manish 17-Feb-2009 Added LA code ZEA
1693
1694 IF ( p_effective_date >= to_date('2009/02/17','yyyy/mm/dd') ) THEN
1695 if p_First_NOAC_Lookup_Code= '122'
1696 and
1697 NOT ( p_First_Action_NOA_LA_Code1 in
1698 ('ABM','ALM','BWM','HAM','HNM','HRM',
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
1708 if p_First_NOAC_Lookup_Code= '122'
1709 and
1710 NOT ( p_First_Action_NOA_LA_Code1 in
1711 ('ABM','ALM','BWM','HAM','HNM','HRM',
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;
1721
1722 --270.10.2
1723 --- Upd 56 13-Mar-09 Manish 17-Feb-2009 Added LA code ZEA
1724 IF ( p_effective_date >= to_date('2009/02/17','yyyy/mm/dd') ) THEN
1725 if p_First_NOAC_Lookup_Code= '124'
1726 and
1727 NOT ( p_First_Action_NOA_LA_Code1 in
1728 ('ABM','ALM','AQM','A7M','BWM','HAM','LBM','NFM',
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
1738 if p_First_NOAC_Lookup_Code= '124'
1739 and
1740 NOT ( p_First_Action_NOA_LA_Code1 in
1741 ('ABM','ALM','AQM','A7M','BWM','HAM','LBM','NFM',
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;
1751
1752 --275.01.2
1753 -- added effective date
1754 -- added la code Z2U on 23-jul-98
1755 if p_effective_date < fnd_date.canonical_to_date('1998/03/01') then
1756 if p_First_NOAC_Lookup_Code= '130'
1757 and
1758 NOT ( p_First_Action_NOA_LA_Code1 in
1759 ('ABS','ABT','J8M','KTM','KVM','KXM','SZT',
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
1769 --275.02.2
1770 -- Update/Change Date By Effective Date Comment
1771 -- 10/2 08/13/99 vravikan 01-Jan-1999 Add VGL
1772 -- 11/2 12/14/99 vravikan From the Start Add ABR
1773 -- 11/9 12/14/99 vravikan 01-Nov-1999 Add UDM
1774 -- 29/07/09 Mani 17-Feb-2009 Add ZEA
1775 -- 14093936 25/05/12 Raju 17-Feb-2009 Add LYP
1776 --
1777 -- The edit 275.01.2 was renamed as 275.02.2 effective 01-mar-1998
1778 --
1779 if (p_effective_date >= to_date('2009/02/17','yyyy/mm/dd')) then
1780 if p_First_NOAC_Lookup_Code= '130'
1781 and
1782 NOT ( p_First_Action_NOA_LA_Code1 in
1783 ('ABR','ABS','ABT','J8M','KTM','KVM','KXM','LYP','SZT',
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
1793 if p_First_NOAC_Lookup_Code= '130'
1794 and
1795 NOT ( p_First_Action_NOA_LA_Code1 in
1796 ('ABR','ABS','ABT','J8M','KTM','KVM','KXM','SZT',
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
1806 if p_First_NOAC_Lookup_Code= '130'
1807 and
1808 NOT ( p_First_Action_NOA_LA_Code1 in
1809 ('ABR','ABS','ABT','J8M','KTM','KVM','KXM','SZT',
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'
1819 and
1820 NOT ( p_First_Action_NOA_LA_Code1 in
1821 ('ABR','ABS','ABT','J8M','KTM','KVM','KXM','SZT',
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
1831 --275.04.2
1832 --- Upd 56 13-Mar-09 Manish 17-Feb-2009 Added LA code ZEA
1833 -- 14093936 25/05/12 Raju 17-Feb-2009 Add LYP
1834 IF ( p_effective_date >= to_date('2009/02/17','yyyy/mm/dd') ) THEN
1835 if p_First_NOAC_Lookup_Code= '132'
1836 and
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
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;
1857
1858 --280.02.2
1859 -- 10/4 08/13/99 vravikan 01-Jan-99 Add VGL
1860 -- 11/2 12/14/99 vravikan From the start Add ABR
1861 -- 11/9 12/14/99 vravikan 01-Nov-1999 Add UDM
1862 -- renumbered from 280.01.2 for the april release
1863 -- added 'Z2U' on 22-jul-1998
1864 --- Upd 56 13-Mar-09 Manish 17-Feb-2009 Added LA code ZEA
1865
1866 if p_effective_date >= to_date('2009/02/17','yyyy/mm/dd') then
1867 if p_First_NOAC_Lookup_Code= '140'
1868 and
1869 NOT ( p_First_Action_NOA_LA_Code1 in
1870 ('ABL','ABM','ABR','ABS','BWM','HAM','KQM',
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
1880 if p_First_NOAC_Lookup_Code= '140'
1881 and
1882 NOT ( p_First_Action_NOA_LA_Code1 in
1883 ('ABL','ABM','ABR','ABS','BWM','HAM','KQM',
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
1893 if p_First_NOAC_Lookup_Code= '140'
1894 and
1895 NOT ( p_First_Action_NOA_LA_Code1 in
1896 ('ABL','ABM','ABR','ABS','BWM','HAM','KQM',
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'
1906 and
1907 NOT ( p_First_Action_NOA_LA_Code1 in
1908 ('ABL','ABM','ABR','ABS','BWM','HAM','KQM',
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
1918 --280.04.2
1919 -- 10/4 08/13/99 vravikan 01-Jan-99 Add VGL
1920 -- 11/2 12/14/99 vravikan From the start Add ABR
1921 -- 11/9 12/14/99 vravikan 01-Nov-1999 Add UDM
1922 -- added 'Z2U' on 22-jul-1998
1923 --- Upd 56 13-Mar-09 Manish 17-Feb-2009 Added LA code ZEA
1924
1925 if p_effective_date >= to_date('2009/02/17','yyyy/mm/dd') then
1926 if p_First_NOAC_Lookup_Code= '141'
1927 and
1928 NOT ( p_First_Action_NOA_LA_Code1 in
1929 ('ABL','ABM','ABR','ABS','BWM','HAM','KQM',
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
1939 if p_First_NOAC_Lookup_Code= '141'
1940 and
1941 NOT ( p_First_Action_NOA_LA_Code1 in
1942 ('ABL','ABM','ABR','ABS','BWM','HAM','KQM',
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
1952 if p_First_NOAC_Lookup_Code= '141'
1953 and
1954 NOT ( p_First_Action_NOA_LA_Code1 in
1955 ('ABL','ABM','ABR','ABS','BWM','HAM','KQM',
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'
1965 and
1966 NOT ( p_First_Action_NOA_LA_Code1 in
1967 ('ABL','ABM','ABR','ABS','BWM','HAM','KQM',
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
1977 --280.07.2
1978 -- Update Date By Effective Date Comment
1979 -- 8 01/28/99 vravikan 01/01/99 Add Legal Authorities P2M and P7M
1980 -- Dec 2001 Patch 1-Nov-01 Delete AWM
1981 --- Upd 56 13-Mar-09 Manish 17-Feb-2009 Added LA code ZEA
1982 --- Upd 57 27-Jul-09 Mani From Start Added QAK
1983
1984 if p_effective_date < to_date('1999/01/01','yyyy/mm/dd') then
1985 if p_First_NOAC_Lookup_Code= '142'
1986 and
1987 NOT ( p_First_Action_NOA_LA_Code1 in
1988 ('HAM','P3M','P5M','QAK','UFM','V2M','ZJR',
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'
1998 and
1999 NOT ( p_First_Action_NOA_LA_Code1 in
2000 ('HAM','P2M','P3M','P5M','P7M','QAK','UFM','V2M','ZJR',
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'
2010 and
2011 NOT ( p_First_Action_NOA_LA_Code1 in
2012 ('HAM','P2M','P3M','P5M','P7M','QAK','UFM','V2M','ZJR',
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
2022 if p_First_NOAC_Lookup_Code= '142'
2023 and
2024 NOT ( p_First_Action_NOA_LA_Code1 in
2025 ('HAM','P2M','P3M','P5M','P7M','QAK','UFM','V2M','ZJR',
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;
2035
2036 --280.10.2
2037 -- Dec 2001 Patch 1-Nov-01 Delete AWM
2038 --- Upd 56 13-Mar-09 Manish 17-Feb-2009 Added LA code ZEA
2039
2040 if p_effective_date < to_date('2001/11/01','yyyy/mm/dd') then
2041 if p_First_NOAC_Lookup_Code= '143'
2042 and
2043 NOT ( p_First_Action_NOA_LA_Code1 in
2044 ('HAM','UFM','VBJ','VCJ',
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'
2054 and
2055 NOT ( p_First_Action_NOA_LA_Code1 in
2056 ('HAM','UFM','VBJ','VCJ',
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
2066 if p_First_NOAC_Lookup_Code= '143'
2067 and
2068 NOT ( p_First_Action_NOA_LA_Code1 in
2069 ('HAM','UFM','VBJ','VCJ',
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;
2079
2080 --280.13.2
2081 -- Dec 2001 Patch 1-Nov-01 Delete AWM
2082 --- Upd 56 13-Mar-09 Manish 17-Feb-2009 Added LA code ZEA
2083 if p_effective_date < to_date('2001/11/01','yyyy/mm/dd') then
2084 if p_First_NOAC_Lookup_Code= '145'
2085 and
2086 NOT ( p_First_Action_NOA_LA_Code1 in
2087 ('HAM','UFM','V6M',
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'
2097 and
2098 NOT ( p_First_Action_NOA_LA_Code1 in
2099 ('HAM','UFM','V6M',
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
2109 if p_First_NOAC_Lookup_Code= '145'
2110 and
2111 NOT ( p_First_Action_NOA_LA_Code1 in
2112 ('HAM','UFM','V6M',
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;
2122
2123
2124 --280.16.2
2125 -- 07/10/02 vravikan From the Start Added ZVC
2126 --- Upd 56 13-Mar-09 Manish 17-Feb-2009 Added LA code ZEA
2127 --- Upd 57 27-Jul-09 Mani From the start Add QAK
2128
2129 IF ( p_effective_date >= to_date('2009/02/17','yyyy/mm/dd') ) THEN
2130 if p_First_NOAC_Lookup_Code= '146'
2131 and
2132 NOT ( p_First_Action_NOA_LA_Code1 in
2133 ('AWM','HAM','QAK','UFM','V4L','ZJR',
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
2143 if p_First_NOAC_Lookup_Code= '146'
2144 and
2145 NOT ( p_First_Action_NOA_LA_Code1 in
2146 ('AWM','HAM','QAK','UFM','V4L','ZJR',
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;
2156
2157 --280.19.2
2158 --- Upd 56 13-Mar-09 Manish 17-Feb-2009 Added LA code ZEA
2159
2160 IF ( p_effective_date >= to_date('2009/02/17','yyyy/mm/dd') ) THEN
2161 if p_First_NOAC_Lookup_Code= '147'
2162 and
2163 NOT ( p_First_Action_NOA_LA_Code1 in
2164 ('AWM','HAM','UFM','VAG',
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
2174 if p_First_NOAC_Lookup_Code= '147'
2175 and
2176 NOT ( p_First_Action_NOA_LA_Code1 in
2177 ('AWM','HAM','UFM','VAG',
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;
2187
2188 --280.22.2
2189 --- Upd 56 13-Mar-09 Manish 17-Feb-2009 Added LA code ZEA
2190 --- Upd 57 27-Jul-09 Mani From Start Added QAK
2191
2192
2193 IF ( p_effective_date >= to_date('2009/02/17','yyyy/mm/dd') ) THEN
2194 if p_First_NOAC_Lookup_Code= '148'
2195 and
2196 NOT ( p_First_Action_NOA_LA_Code1 in
2197 ('AWM','HAM','QAK','UFM','V4M',
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
2207 if p_First_NOAC_Lookup_Code= '148'
2208 and
2209 NOT ( p_First_Action_NOA_LA_Code1 in
2210 ('AWM','HAM','QAK','UFM','V4M',
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;
2220
2221 --280.25.2
2222
2223 --- Upd 56 13-Mar-09 Manish 17-Feb-2009 Added LA code ZEA
2224
2225 IF ( p_effective_date >= to_date('2009/02/17','yyyy/mm/dd') ) THEN
2226 if p_First_NOAC_Lookup_Code= '149'
2227 and
2228 NOT ( p_First_Action_NOA_LA_Code1 in
2229 ('AWM','HAM','UFM','V4P',
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
2239 if p_First_NOAC_Lookup_Code= '149'
2240 and
2241 NOT ( p_First_Action_NOA_LA_Code1 in
2242 ('AWM','HAM','UFM','V4P',
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;
2252
2253 /* Commented -- Dec 2001 Patch
2254 --285.02.2
2255 --renumbered from 285.01.2 for the april release
2256 if p_First_NOAC_Lookup_Code= '150'
2257 and
2258 NOT ( p_First_Action_NOA_LA_Code1 in
2259 ('ALM','AQM','HAM','PWM','P3M','P5M','QAK','QBK','QCK','TJK','TRK','ZJR',
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
2269 /* Commented -- Dec 2001 Patch
2270 --285.04.2
2271 if p_First_NOAC_Lookup_Code= '151'
2272 and
2273 NOT ( p_First_Action_NOA_LA_Code1 in
2274 ('ALM','AQM','HAM','PWM','P3M','P5M','QAK','QBK','QCK','TJK','ZJR',
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
2284
2285 --285.07.2
2286 if p_First_NOAC_Lookup_Code= '153'
2287 and
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
2297
2298 --285.10.2
2299 if p_First_NOAC_Lookup_Code= '154'
2300 and
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
2310 /* Commented -- Dec 2001 Patch
2311 --285.13.2
2312 if p_First_NOAC_Lookup_Code= '155'
2313 and
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
2323
2324 --285.16.2
2325 if p_First_NOAC_Lookup_Code= '157'
2326 and
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
2336
2337 --290.02.2
2338
2339 -- renumbered from 290.01.2 for the april release
2340 -- added legal authority ZTA on 9-oct-98
2341 -- Update Date By Effective Date Comment
2342 -- 8 01/28/99 vravikan 01/01/99 Add Legal Authority P7M
2343 -- 10/4 08/13/99 vravikan 01-Jan-99 Add VGL
2344 -- 11/9 12/14/99 vravikan 01-Nov-1999 Add UDM
2345 -- 11/11 12/14/99 vravikan 01-Jan-99 Change legal authorities "Y--" to "Y-- (except 'YKB')
2346 -- 17-Aug-00 vravikan From Begining Change legal authorities "Y--" to "Y-- (except 'YKB')
2347 -- 08-Dec-00 vravikan From Begining Delete ZTA
2348 -- upd51 06-Feb-07 Raju From Begining Bug#5745356 add legal authority Z6J
2349 --- Upd 56 13-Mar-09 Manish 17-Feb-2009 Added LA code ZEA
2350 --- Upd 57 30-Jul-09 Mani From Begining Added ABR only in the message list
2351
2352 if p_effective_date >= to_date('2009/02/17','yyyy/mm/dd') then
2353 if p_First_NOAC_Lookup_Code= '170'
2354 and
2355 NOT (
2356 (p_First_Action_NOA_LA_Code1 in
2357 ('ABK','ABL','ABM','ABR','ALM','AQM','BPM','BWM','H2L',
2358 'HAM','J8M','PWM','P3M','P5M','QAK','QBK',
2359 'QCK','UAM','UDM','UFM','VGL','V1P','V8K','V8V','Z2M','Z2U',
2360 'ZJR','ZKM','ZLM','ZNM','ZRM','ZSK','ZSP','ZVB','ZVC','Z6J','ZEA')
2361 OR
2362 (SUBSTR(p_First_Action_NOA_LA_Code1,1,1) IN ('W','X'))
2363 OR
2364 (SUBSTR(p_First_Action_NOA_LA_Code1,1,1) IN ('Y')
2365 and
2366 p_First_Action_NOA_LA_Code1 <> 'YKB' )
2367 )
2368 AND
2369 (p_First_Action_NOA_LA_Code2 in
2370 ('ABK','ABL','ABM','ABR','ALM','AQM','BPM','BWM','H2L',
2371 'HAM','J8M','PWM','P3M','P5M','P7M','QAK','QBK',
2372 'QCK','UAM','UDM','UFM','VGL','V1P','V8K','V8V','Z2M','Z2U',
2373 'ZJR','ZKM','ZLM','ZNM','ZRM','ZSK','ZSP','ZVB','ZVC','Z6J','ZEA')
2374 OR
2375 (SUBSTR(p_First_Action_NOA_LA_Code2,1,1) IN ('W','X'))
2376 OR
2377 (SUBSTR(p_First_Action_NOA_LA_Code2,1,1) IN ('Y')
2378 and
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;
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
2392 NOT (
2393 (p_First_Action_NOA_LA_Code1 in
2394 ('ABK','ABL','ABM','ABR','ALM','AQM','BPM','BWM','H2L',
2395 'HAM','J8M','PWM','P3M','P5M','QAK','QBK',
2396 'QCK','UAM','UDM','UFM','VGL','V1P','V8K','V8V','Z2M','Z2U',
2397 'ZJR','ZKM','ZLM','ZNM','ZRM','ZSK','ZSP','ZVB','ZVC','Z6J')
2398 OR
2399 (SUBSTR(p_First_Action_NOA_LA_Code1,1,1) IN ('W','X'))
2400 OR
2401 (SUBSTR(p_First_Action_NOA_LA_Code1,1,1) IN ('Y')
2402 and
2403 p_First_Action_NOA_LA_Code1 <> 'YKB' )
2404 )
2405 AND
2406 (p_First_Action_NOA_LA_Code2 in
2407 ('ABK','ABL','ABM','ABR','ALM','AQM','BPM','BWM','H2L',
2408 'HAM','J8M','PWM','P3M','P5M','P7M','QAK','QBK',
2409 'QCK','UAM','UDM','UFM','VGL','V1P','V8K','V8V','Z2M','Z2U',
2410 'ZJR','ZKM','ZLM','ZNM','ZRM','ZSK','ZSP','ZVB','ZVC','Z6J')
2411 OR
2412 (SUBSTR(p_First_Action_NOA_LA_Code2,1,1) IN ('W','X'))
2413 OR
2414 (SUBSTR(p_First_Action_NOA_LA_Code2,1,1) IN ('Y')
2415 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;
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
2429 NOT (
2430 (p_First_Action_NOA_LA_Code1 in
2431 ('ABK','ABL','ABM','ABR','ALM','AQM','BPM','BWM','H2L',
2432 'HAM','J8M','PWM','P3M','P5M','P7M','QAK','QBK',
2433 'QCK','UAM','UFM','VGL','V1P','V8K','V8V','Z2M','Z2U',
2434 'ZJR','ZKM','ZLM','ZNM','ZRM','ZSK','ZSP','ZVB','ZVC','Z6J')
2435 OR
2436 (SUBSTR(p_First_Action_NOA_LA_Code1,1,1) IN ('W','X'))
2437 OR
2438 (SUBSTR(p_First_Action_NOA_LA_Code1,1,1) IN ('Y')
2439 and
2440 p_First_Action_NOA_LA_Code1 <> 'YKB' )
2441 )
2442 AND
2443 (p_First_Action_NOA_LA_Code2 in
2444 ('ABK','ABL','ABM','ABR','ALM','AQM','BPM','BWM','H2L',
2445 'HAM','J8M','PWM','P3M','P5M','P7M','QAK','QBK',
2446 'QCK','UAM','UFM','VGL','V1P','V8K','V8V','Z2M','Z2U',
2447 'ZJR','ZKM','ZLM','ZNM','ZRM','ZSK','ZSP','ZVB','ZVC','Z6J')
2448 OR
2449 (SUBSTR(p_First_Action_NOA_LA_Code2,1,1) IN ('W','X'))
2450 OR
2451 (SUBSTR(p_First_Action_NOA_LA_Code2,1,1) IN ('Y')
2452 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'
2462 and
2463 NOT (
2464 (p_First_Action_NOA_LA_Code1 in
2465 ('ABK','ABL','ABM','ABR','ALM','AQM','BPM','BWM','H2L',
2466 'HAM','J8M','PWM','P3M','P5M','QAK','QBK',
2467 'QCK','UAM','UFM','V1P','V8K','V8V','Z2M','Z2U',
2468 'ZJR','ZKM','ZLM','ZNM','ZRM','ZSK','ZSP','ZVB','ZVC','Z6J')
2469 OR
2470 (SUBSTR(p_First_Action_NOA_LA_Code1,1,1) IN ('W','X'))
2471 OR
2472 (SUBSTR(p_First_Action_NOA_LA_Code1,1,1) IN ('Y')
2473 and
2474 p_First_Action_NOA_LA_Code1 <> 'YKB' )
2475 )
2476 AND
2477 (p_First_Action_NOA_LA_Code2 in
2478 ('ABK','ABL','ABM','ABR','ALM','AQM','BPM','BWM','H2L',
2479 'HAM','J8M','PWM','P3M','P5M','QAK','QBK',
2480 'QCK','UAM','UFM','V1P','V8K','V8V','Z2M','Z2U',
2481 'ZJR','ZKM','ZLM','ZNM','ZRM','ZSK','ZSP','ZVB','ZVC','Z6J'
2482 )
2483 OR
2484 (SUBSTR(p_First_Action_NOA_LA_Code2,1,1) IN ('W','X'))
2485 OR
2486 (SUBSTR(p_First_Action_NOA_LA_Code2,1,1) IN ('Y')
2487 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
2497 --290.04.2
2498 -- added legal authority 'ZTA' on 9-oct-98
2499 -- 10/4 08/13/99 vravikan 01-Jan-99 Add VGL
2500 -- 11/9 12/14/99 vravikan 01-Nov-1999 Add UDM
2501 -- 11/11 12/20/99 vravikan 01-Jan-1999 Change legal authorities "Y--" to "Y-- (except 'YKB')
2502 -- 11/11 21-Sep-00 vravikan From Begining Change legal authorities "Y--" to "Y-- (except 'YKB')
2503 -- 08-Dec-00 vravikan From Begining Delete ZTA
2504 -- upd51 06-Feb-07 Raju From Begining Bug#5745356 add legal authority Z6J
2505 -- Upd 56 13-Mar-09 Manish 17-Feb-2009 Added LA code ZEA
2506 -- Upd 11-Sep-12 Raju 01-oct-2012 Added LA code ZVG
2507
2508 --Begin Bug# 14595787
2509 if p_effective_date >= to_date('2012/10/01','yyyy/mm/dd') then
2510 if p_First_NOAC_Lookup_Code= '171'
2511 and
2512 NOT (
2513 (p_First_Action_NOA_LA_Code1 in
2514 ('ABK','ABL','ABM','ABR','ALM','AQM','BPM','BWM','H2L',
2515 'HAM','J8M','P3M','QAK','UAM','UDM','UFM','V1P','VEM','V8V',
2516 'ZKM','ZLM','ZNM','VGL','VPE','V8K','ZWM','ZSK','ZSP','ZVB','Z2M','ZVC','Z6J','ZEA','ZVG')
2517 OR
2518 SUBSTR(p_First_Action_NOA_LA_Code1,1,1) IN ('W','X')
2519 OR
2520 (SUBSTR(p_First_Action_NOA_LA_Code1,1,1) IN ('Y')
2521 AND p_First_Action_NOA_LA_Code1 <> 'YKB' )
2522 )
2523 AND
2524 (p_First_Action_NOA_LA_Code2 in
2525 ('ABK','ABL','ABM','ABR','ALM','AQM','BPM','BWM','H2L',
2526 'HAM','J8M','P3M','QAK','UAM','UDM','UFM','V1P','VEM','V8V',
2527 'ZKM','ZLM','ZNM','VGL','VPE','V8K','ZWM','ZSK','ZSP','ZVB','Z2M','ZVC','Z6J','ZEA','ZVG') OR
2528 SUBSTR(p_First_Action_NOA_LA_Code2,1,1) IN ('W','X')
2529 OR
2530 (SUBSTR(p_First_Action_NOA_LA_Code2,1,1) IN ('Y')
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;
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'
2543 and
2544 NOT (
2545 (p_First_Action_NOA_LA_Code1 in
2546 ('ABK','ABL','ABM','ABR','ALM','AQM','BPM','BWM','H2L',
2547 'HAM','J8M','P3M','QAK','UAM','UDM','UFM','V1P','VEM','V8V',
2548 'ZKM','ZLM','ZNM','VGL','VPE','V8K','ZWM','ZSK','ZSP','ZVB','Z2M','ZVC','Z6J','ZEA')
2549 OR
2550 SUBSTR(p_First_Action_NOA_LA_Code1,1,1) IN ('W','X')
2551 OR
2552 (SUBSTR(p_First_Action_NOA_LA_Code1,1,1) IN ('Y')
2553 AND p_First_Action_NOA_LA_Code1 <> 'YKB' )
2554 )
2555 AND
2556 (p_First_Action_NOA_LA_Code2 in
2557 ('ABK','ABL','ABM','ABR','ALM','AQM','BPM','BWM','H2L',
2558 'HAM','J8M','P3M','QAK','UAM','UDM','UFM','V1P','VEM','V8V',
2559 'ZKM','ZLM','ZNM','VGL','VPE','V8K','ZWM','ZSK','ZSP','ZVB','Z2M','ZVC','Z6J','ZEA') OR
2560 SUBSTR(p_First_Action_NOA_LA_Code2,1,1) IN ('W','X')
2561 OR
2562 (SUBSTR(p_First_Action_NOA_LA_Code2,1,1) IN ('Y')
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;
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
2575 NOT (
2576 (p_First_Action_NOA_LA_Code1 in
2577 ('ABK','ABL','ABM','ABR','ALM','AQM','BPM','BWM','H2L',
2578 'HAM','J8M','P3M','QAK','UAM','UDM','UFM','V1P','VEM','V8V',
2579 'ZKM','ZLM','ZNM','VGL','VPE','V8K','ZWM','ZSK','ZSP','ZVB','Z2M','ZVC','Z6J')
2580 OR
2581 SUBSTR(p_First_Action_NOA_LA_Code1,1,1) IN ('W','X')
2582 OR
2583 (SUBSTR(p_First_Action_NOA_LA_Code1,1,1) IN ('Y')
2584 AND p_First_Action_NOA_LA_Code1 <> 'YKB' )
2585 )
2586 AND
2587 (p_First_Action_NOA_LA_Code2 in
2588 ('ABK','ABL','ABM','ABR','ALM','AQM','BPM','BWM','H2L',
2589 'HAM','J8M','P3M','QAK','UAM','UDM','UFM','V1P','VEM','V8V',
2590 'ZKM','ZLM','ZNM','VGL','VPE','V8K','ZWM','ZSK','ZSP','ZVB','Z2M','ZVC','Z6J') OR
2591 SUBSTR(p_First_Action_NOA_LA_Code2,1,1) IN ('W','X')
2592 OR
2593 (SUBSTR(p_First_Action_NOA_LA_Code2,1,1) IN ('Y')
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;
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
2606 NOT (
2607 (p_First_Action_NOA_LA_Code1 in
2608 ('ABK','ABL','ABM','ABR','ALM','AQM','BPM','BWM','H2L',
2609 'HAM','J8M','P3M','QAK','UAM','UFM','V1P','VEM','V8V',
2610 'ZKM','ZLM','ZNM','VGL','VPE','V8K','ZWM','ZSK','ZSP','ZVB','Z2M','ZVC','Z6J')
2611 OR
2612 SUBSTR(p_First_Action_NOA_LA_Code1,1,1) IN ('W','X')
2613 OR
2614 (SUBSTR(p_First_Action_NOA_LA_Code1,1,1) IN ('Y')
2615 AND p_First_Action_NOA_LA_Code1 <> 'YKB' )
2616 )
2617 AND
2618 (p_First_Action_NOA_LA_Code2 in
2619 ('ABK','ABL','ABM','ABR','ALM','AQM','BPM','BWM','H2L',
2620 'HAM','J8M','P3M','QAK','UAM','UFM','V1P','VEM','V8V',
2621 'ZKM','ZLM','ZNM','VGL','VPE','V8K','ZWM','ZSK','ZSP','ZVB','Z2M','ZVC','Z6J') OR
2622 SUBSTR(p_First_Action_NOA_LA_Code2,1,1) IN ('W','X')
2623 OR
2624 (SUBSTR(p_First_Action_NOA_LA_Code2,1,1) IN ('Y')
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'
2634 and
2635 NOT (
2636 (p_First_Action_NOA_LA_Code1 in
2637 ('ABK','ABL','ABM','ABR','ALM','AQM','BPM','BWM','H2L',
2638 'HAM','J8M','P3M','QAK','UAM','UFM','V1P','VEM','V8V',
2639 'ZKM','ZLM','ZNM','VPE','V8K','ZWM','ZSK','ZSP','ZVB','Z2M','ZVC','Z6J')
2640 OR
2641 SUBSTR(p_First_Action_NOA_LA_Code1,1,1) IN ('W','X')
2642 OR
2643 (SUBSTR(p_First_Action_NOA_LA_Code1,1,1) IN ('Y')
2644 AND p_First_Action_NOA_LA_Code1 <> 'YKB'
2645 )
2646 )
2647 AND
2648 (p_First_Action_NOA_LA_Code2 in
2649 ('ABK','ABL','ABM','ABR','ALM','AQM','BPM','BWM','H2L',
2650 'HAM','J8M','P3M','QAK','UAM','UFM','V1P','VEM','V8V',
2651 'ZKM','ZLM','ZNM','VPE','V8K','ZWM','ZSK','ZSP','ZVB','Z2M','ZVC','Z6J') OR
2652 (SUBSTR(p_First_Action_NOA_LA_Code2,1,1) IN ('W','X'))
2653 OR
2654 (SUBSTR(p_First_Action_NOA_LA_Code2,1,1) IN ('Y')
2655 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
2665 --290.20.2
2666 -- added 'Z2U' on 22-jul-1998
2667 -- Update Date By Effective Date Comment
2668 -- 8 03/09/99 vravikan 01/31/99 Delete BEA,BMC,BNE,BNW,BRM
2669 -- 10/4 08/13/99 vravikan 01-Jan-99 Add VGL
2670 -- 9/3 09/14/99 vravikan 28-Feb-99 Delete CTM,NEL
2671 -- Dec 2001 Patch vravikan 01-Oct-01 Delete BFS,MYM, and MZM
2672 --- Upd 56 13-Mar-09 Manish 17-Feb-2009 Added LA code ZEA
2673
2674 if p_effective_date >= to_date('2009/02/17','yyyy/mm/dd') then
2675 if p_First_NOAC_Lookup_Code= '190'
2676 and
2677 NOT (
2678 (p_First_Action_NOA_LA_Code1 in
2679 ('ABK','ABL','ABM','ABR','ABS','ACM','AWM','AYM',
2680 'BPM','BWA',
2681 'BWM','H2L','HAM','J8M','KLM','MXM',
2682 'M6M','M8M','NAM','NCM',
2683 'NEM','NJM','NUM','SZX','UAM','UFM','VGL',
2684 'VJM','VPE','V1P','V4M','V4P','V8K','V8L',
2685 'V8N','V8V','ZJK','ZKM','V8V','Z2U','ZLM','ZNM',
2686 'ZQM','ZRM','ZSK','ZSP','ZTM','ZEA') OR
2687 SUBSTR(p_First_Action_NOA_LA_Code1,1,1) IN ('W','X','Y')
2688 )
2689 AND
2690 (p_First_Action_NOA_LA_Code2 in
2691 ('ABK','ABL','ABM','ABR','ABS','ACM','AWM','AYM',
2692 'BPM','BWA',
2693 'BWM','H2L','HAM','J8M','KLM','MXM',
2694 'M6M','M8M','NAM','NCM',
2695 'NEM','NJM','NUM','SZX','UAM','UFM','VGL',
2696 'VJM','VPE','V1P','V4M','V4P','V8K','V8L',
2697 'V8N','V8V','ZJK','ZKM','V8V','Z2U','ZLM','ZNM',
2698 'ZQM','ZRM','ZSK','ZSP','ZTM','ZEA') OR
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;
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
2712 NOT (
2713 (p_First_Action_NOA_LA_Code1 in
2714 ('ABK','ABL','ABM','ABR','ABS','ACM','AWM','AYM',
2715 'BPM','BWA',
2716 'BWM','H2L','HAM','J8M','KLM','MXM',
2717 'M6M','M8M','NAM','NCM',
2718 'NEM','NJM','NUM','SZX','UAM','UFM','VGL',
2719 'VJM','VPE','V1P','V4M','V4P','V8K','V8L',
2720 'V8N','V8V','ZJK','ZKM','V8V','Z2U','ZLM','ZNM',
2721 'ZQM','ZRM','ZSK','ZSP','ZTM') OR
2722 SUBSTR(p_First_Action_NOA_LA_Code1,1,1) IN ('W','X','Y')
2723 )
2724 AND
2725 (p_First_Action_NOA_LA_Code2 in
2726 ('ABK','ABL','ABM','ABR','ABS','ACM','AWM','AYM',
2727 'BPM','BWA',
2728 'BWM','H2L','HAM','J8M','KLM','MXM',
2729 'M6M','M8M','NAM','NCM',
2730 'NEM','NJM','NUM','SZX','UAM','UFM','VGL',
2731 'VJM','VPE','V1P','V4M','V4P','V8K','V8L',
2732 'V8N','V8V','ZJK','ZKM','V8V','Z2U','ZLM','ZNM',
2733 'ZQM','ZRM','ZSK','ZSP','ZTM') OR
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;
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
2747 NOT (
2748 (p_First_Action_NOA_LA_Code1 in
2749 ('ABK','ABL','ABM','ABR','ABS','ACM','AWM','AYM',
2750 'BPM','BWA',
2751 'BWM','H2L','HAM','J8M','KLM','MXM','MYM',
2752 'MZM','M6M','M8M','NAM','NCM',
2753 'NEM','NJM','NUM','SZX','UAM','UFM','VGL',
2754 'VJM','VPE','V1P','V4M','V4P','V8K','V8L',
2755 'V8N','V8V','ZJK','ZKM','V8V','Z2U','ZLM','ZNM',
2756 'ZQM','ZRM','ZSK','ZSP','ZTM') OR
2757 SUBSTR(p_First_Action_NOA_LA_Code1,1,1) IN ('W','X','Y')
2758 )
2759 AND
2760 (p_First_Action_NOA_LA_Code2 in
2761 ('ABK','ABL','ABM','ABR','ABS','ACM','AWM','AYM',
2762 'BPM','BWA',
2763 'BWM','H2L','HAM','J8M','KLM','MXM','MYM',
2764 'MZM','M6M','M8M','NAM','NCM',
2765 'NEM','NJM','NUM','SZX','UAM','UFM','VGL',
2766 'VJM','VPE','V1P','V4M','V4P','V8K','V8L',
2767 'V8N','V8V','ZJK','ZKM','V8V','Z2U','ZLM','ZNM',
2768 'ZQM','ZRM','ZSK','ZSP','ZTM') OR
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'
2778 and
2779 NOT (
2780 (p_First_Action_NOA_LA_Code1 in
2781 ('ABK','ABL','ABM','ABR','ABS','ACM','AWM','AYM',
2782 'BPM','BWA',
2783 'BWM','CTM','H2L','HAM','J8M','KLM','MXM','MYM',
2784 'MZM','M6M','M8M','NAM','NCM','NEL',
2785 'NEM','NJM','NUM','SZX','UAM','UFM','VGL',
2786 'VJM','VPE','V1P','V4M','V4P','V8K','V8L',
2787 'V8N','V8V','ZJK','ZKM','V8V','Z2U','ZLM','ZNM',
2788 'ZQM','ZRM','ZSK','ZSP','ZTM') OR
2789 SUBSTR(p_First_Action_NOA_LA_Code1,1,1) IN ('W','X','Y')
2790 )
2791 AND
2792 (p_First_Action_NOA_LA_Code2 in
2793 ('ABK','ABL','ABM','ABR','ABS','ACM','AWM','AYM',
2794 'BPM','BWA',
2795 'BWM','CTM','H2L','HAM','J8M','KLM','MXM','MYM',
2796 'MZM','M6M','M8M','NAM','NCM','NEL',
2797 'NEM','NJM','NUM','SZX','UAM','UFM','VGL',
2798 'VJM','VPE','V1P','V4M','V4P','V8K','V8L',
2799 'V8N','V8V','ZJK','ZKM','V8V','Z2U','ZLM','ZNM',
2800 'ZQM','ZRM','ZSK','ZSP','ZTM') OR
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'
2810 and
2811 NOT (
2812 (p_First_Action_NOA_LA_Code1 in
2813 ('ABK','ABL','ABM','ABR','ABS','ACM','AWM','AYM','BEA',
2814 'BMC','BNE','BNW','BPM','BRM','BWA',
2815 'BWM','CTM','H2L','HAM','J8M','KLM','MXM','MYM',
2816 'MZM','M6M','M8M','NAM','NCM','NEL',
2817 'NEM','NJM','NUM','SZX','UAM','UFM','VGL',
2818 'VJM','VPE','V1P','V4M','V4P','V8K','V8L',
2819 'V8N','V8V','ZJK','ZKM','V8V','Z2U','ZLM','ZNM',
2820 'ZQM','ZRM','ZSK','ZSP','ZTM') OR
2821 SUBSTR(p_First_Action_NOA_LA_Code1,1,1) IN ('W','X','Y')
2822 )
2823 AND
2824 (p_First_Action_NOA_LA_Code2 in
2825 ('ABK','ABL','ABM','ABR','ABS','ACM','AWM','AYM','BEA',
2826 'BMC','BNE','BNW','BPM','BRM','BWA',
2827 'BWM','CTM','H2L','HAM','J8M','KLM','MXM','MYM',
2828 'MZM','M6M','M8M','NAM','NCM','NEL',
2829 'NEM','NJM','NUM','SZX','UAM','UFM','VGL',
2830 'VJM','VPE','V1P','V4M','V4P','V8K','V8L',
2831 'V8N','V8V','ZJK','ZKM','V8V','Z2U','ZLM','ZNM',
2832 'ZQM','ZRM','ZSK','ZSP','ZTM') OR
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'
2842 and
2843 NOT (
2844 (p_First_Action_NOA_LA_Code1 in
2845 ('ABK','ABL','ABM','ABR','ABS','ACM','AWM','AYM','BEA',
2846 'BMC','BNE','BNW','BPM','BRM','BWA',
2847 'BWM','CTM','H2L','HAM','J8M','KLM','MXM','MYM',
2848 'MZM','M6M','M8M','NAM','NCM','NEL',
2849 'NEM','NJM','NUM','SZX','UAM','UFM',
2850 'VJM','VPE','V1P','V4M','V4P','V8K','V8L',
2851 'V8N','V8V','ZJK','ZKM','V8V','Z2U','ZLM','ZNM',
2852 'ZQM','ZRM','ZSK','ZSP','ZTM') OR
2853 SUBSTR(p_First_Action_NOA_LA_Code1,1,1) IN ('W','X','Y')
2854 )
2855 AND
2856 (p_First_Action_NOA_LA_Code2 in
2857 ('ABK','ABL','ABM','ABR','ABS','ACM','AWM','AYM','BEA',
2858 'BMC','BNE','BNW','BPM','BRM','BWA',
2859 'BWM','CTM','H2L','HAM','J8M','KLM','MXM','MYM',
2860 'MZM','M6M','M8M','NAM','NCM','NEL',
2861 'NEM','NJM','NUM','SZX','UAM','UFM',
2862 'VJM','VPE','V1P','V4M','V4P','V8K','V8L',
2863 'V8N','V8V','ZJK','ZKM','V8V','Z2U','ZLM','ZNM',
2864 'ZQM','ZRM','ZSK','ZSP','ZTM') OR
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;
2874 --290.30.2
2875 --- Upd 56 13-Mar-09 Manish 17-Feb-2009 Added LA code ZEA
2876
2877 IF ( p_effective_date >= to_date('2009/02/17','yyyy/mm/dd') ) THEN
2878 if p_First_NOAC_Lookup_Code= '198'
2879 and
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
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;
2900
2901 --290.35.2
2902 --- Upd 56 13-Mar-09 Manish 17-Feb-2009 Added LA code ZEA
2903
2904 IF ( p_effective_date >= to_date('2009/02/17','yyyy/mm/dd') ) THEN
2905 if p_First_NOAC_Lookup_Code= '199'
2906 and
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
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;
2927
2928 --295.02.2
2929 --Renumbered from 295.01.2 for the april release
2930 if p_First_NOAC_Lookup_Code= '280'
2931 and
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
2941 -- Update/Change Date By Effective Date Comment
2942 -- 9/5 08/12/99 vravikan 01-Apr-1999 Add ZJV
2943 -- 2038423 10/08/01 vravikan Add ZJW
2944 -- 7556102 25/12/08 Raju Add UAM
2945 -- 9379166 23/02/10 Raju Add UAM
2946 -- 10189715 28/03/10 Raju Removed V8V and ZVB
2947 if p_effective_date >= to_date('2010/03/28','yyyy/mm/dd') then
2948 if p_First_NOAC_Lookup_Code= '292' and
2949 NOT ( p_First_Action_NOA_LA_Code1 in
2950 ('ALM','AQM','CGM','DAM','NYM','PSM','Q3K','QRD',
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
2960 if p_First_NOAC_Lookup_Code= '292' and
2961 NOT ( p_First_Action_NOA_LA_Code1 in
2962 ('ALM','AQM','CGM','DAM','NYM','PSM','Q3K',
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
2972 if p_First_NOAC_Lookup_Code= '292'
2973 and NOT ( p_First_Action_NOA_LA_Code1 in
2974 ('ALM','AQM','CGM','DAM','NYM','PSM','Q3K',
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;
2984
2985 --295.10.2
2986 if p_First_NOAC_Lookup_Code= '293'
2987 and
2988 Not(
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
2998 -- Renumbered from 300.01.2
2999 if p_First_NOAC_Lookup_Code= '300'
3000 and
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
3010 if p_First_NOAC_Lookup_Code= '301'
3011 and
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
3021 (p_To_Play_Plan
3022 ,p_Agency_Sub_Element
3023 ,p_First_Action_NOA_LA_Code1
3024 ,p_First_Action_NOA_LA_Code2
3025 ,p_First_NOAC_Lookup_Code
3026 ,p_effective_date
3027 ,p_position_occupied_code
3028 ) ;
3029 end chk_Legal_Authority;
3030
3031 end GHR_CPDF_CHECK4;