[Home] [Help]
PACKAGE BODY: APPS.GHR_CPDF_CHECK4A
Source
1 package body GHR_CPDF_CHECK4A as
2 /* $Header: ghcpdf4a.pkb 120.15.12020000.11 2013/02/06 09:26:45 utokachi ship $ */
3
4 -- Legal Authority
5
6 procedure chk_Legal_Authority_a
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 begin
16
17 --300.07.2
18 if p_First_NOAC_Lookup_Code= '302'
19 and
20 NOT ( p_First_Action_NOA_LA_Code1 in
21 ('SQM','SRM','UFM','USM','V8V') AND
22 p_First_Action_NOA_LA_Code2 in
23 ('SQM','SRM','UFM','USM','V8V') ) THEN
24 hr_utility.set_message(8301, 'GHR_37348_ALL_PROCEDURE_FAIL');
25 hr_utility.raise_error;
26 end if;
27
28 --300.10.2
29 if p_First_NOAC_Lookup_Code= '303'
30 and
31 NOT ( p_First_Action_NOA_LA_Code1 in
32 ('AZM','USM','V3P','V8V','ZLM') AND
33 p_First_Action_NOA_LA_Code2 in
34 ('AZM','USM','V3P','V8V','ZLM') ) THEN
35 hr_utility.set_message(8301, 'GHR_37349_ALL_PROCEDURE_FAIL');
36 hr_utility.raise_error;
37 end if;
38
39 --300.13.2
40 if p_First_NOAC_Lookup_Code= '304'
41 and
42 NOT ( p_First_Action_NOA_LA_Code1 in
43 ('SQM','USM','V8V') AND
44 p_First_Action_NOA_LA_Code2 in
45 ('SQM','USM','V8V') ) THEN
46 hr_utility.set_message(8301, 'GHR_37350_ALL_PROCEDURE_FAIL');
47 hr_utility.raise_error;
48 end if;
49
50 --300.16.2
51 -- added 'Z2U' on 22-jul-1998
52 -- Update/Change Date By Effective Date Comment
53 -- 10/2 08/13/99 vravikan 01-Aug-1999 Change R5M to R6M
54 if p_effective_date >= fnd_date.canonical_to_date('19'||'99/08/01') then
55 if p_First_NOAC_Lookup_Code= '312'
56 and
57 NOT ( p_First_Action_NOA_LA_Code1 in
58 ('RPM','RPR','RQM','RRM','RSM','RTM','RTR','RUM','RWM',
59 'RXM','R6M','R7M','R8M','R9M','V8V','Z2U','ZVB','ZVC') AND
60 p_First_Action_NOA_LA_Code2 in
61 ('RPM','RPR','RQM','RRM','RSM','RTM','RTR','RUM','RWM',
62 'RXM','R6M','R7M','R8M','R9M','V8V','Z2U','ZVB','ZVC') ) THEN
63 hr_utility.set_message(8301, 'GHR_37082_ALL_PROCEDURE_FAIL');
64 hr_utility.raise_error;
65 end if;
66 else
67 if p_First_NOAC_Lookup_Code= '312'
68 and
69 NOT ( p_First_Action_NOA_LA_Code1 in
70 ('RPM','RPR','RQM','RRM','RSM','RTM','RTR','RUM','RWM',
71 'RXM','R5M','R7M','R8M','R9M','V8V','Z2U','ZVB','ZVC') AND
72 p_First_Action_NOA_LA_Code2 in
73 ('RPM','RPR','RQM','RRM','RSM','RTM','RTR','RUM','RWM',
74 'RXM','R5M','R7M','R8M','R9M','V8V','Z2U','ZVB','ZVC') ) THEN
75 hr_utility.set_message(8301, 'GHR_37351_ALL_PROCEDURE_FAIL');
76 hr_utility.raise_error;
77 end if;
78 end if;
79
80 --300.19.2
81 -- Update/Change Date By Effective Date Comment
82 -- 10/2 08/13/99 vravikan 01-Aug-1999 Change R5M to R6M
83 -- 30/12/08 Raju Added UFM, removed R7M,R8M,R9M
84 if p_effective_date >= fnd_date.canonical_to_date('19'||'99/08/01') then
85 if p_First_NOAC_Lookup_Code= '317'
86 and
87 NOT ( p_First_Action_NOA_LA_Code1 in
88 ('RPM','RQM','RRM','RSM','RUM','R6M','UFM','V8V','ZVB','ZVC') AND
89 p_First_Action_NOA_LA_Code2 in
90 ('RPM','RQM','RRM','RSM','RUM','R6M','UFM','V8V','ZVB','ZVC') ) THEN
91 hr_utility.set_message(8301, 'GHR_37083_ALL_PROCEDURE_FAIL');
92 hr_utility.raise_error;
93 end if;
94 else
95 if p_First_NOAC_Lookup_Code= '317'
96 and
97 NOT ( p_First_Action_NOA_LA_Code1 in
98 ('RPM','RQM','RRM','RSM','RUM','R5M','UFM','V8V','ZVB','ZVC') AND
99 p_First_Action_NOA_LA_Code2 in
100 ('RPM','RQM','RRM','RSM','RUM','R5M','UFM','V8V','ZVB','ZVC') ) THEN
101 hr_utility.set_message(8301, 'GHR_37352_ALL_PROCEDURE_FAIL');
102 hr_utility.raise_error;
103 end if;
104 end if;
105
106 --305.02.2
107 -- added 'Z2U' on 22-jul-1998
108 -- added 'Z2W' on 9-oct-98
109 -- Upd 47 23-Jun-06 Raju From Begining Added VAA
110 if p_First_NOAC_Lookup_Code= '330'
111 and
112 NOT ( p_First_Action_NOA_LA_Code1 in
113 ('HAM','LTM','LUM','QGM','QHM','RYM','UAM','UFM','VAA','VAJ','VHJ','VJJ','VWP',
114 'VWR','V2J','V4J','V5J','V6J','V7J','V8J','V8K','V8V','V9A','V9B','Z2U',
115 'Z2W','ZEM','ZLM','ZVB','ZVC') AND
116 p_First_Action_NOA_LA_Code2 in
117 ('HAM','LTM','LUM','QGM','QHM','RYM','UAM','UFM','VAA','VAJ','VHJ','VJJ','VWP',
118 'VWR','V2J','V4J','V5J','V6J','V7J','V8J','V8K','V8V','V9A','V9B','Z2U',
119 'Z2W','ZEM','ZLM','ZVB','ZVC') ) THEN
120 hr_utility.set_message(8301, 'GHR_37353_ALL_PROCEDURE_FAIL');
121 hr_utility.raise_error;
122 end if;
123
124 --307.02.2
125 -- Renumbered from 307.01.2
126 if p_First_NOAC_Lookup_Code= '351'
127 and
128 NOT ( p_First_Action_NOA_LA_Code1 ='RPM' AND
129 p_First_Action_NOA_LA_Code2 ='RPM' ) THEN
130 hr_utility.set_message(8301, 'GHR_37354_ALL_PROCEDURE_FAIL');
131 hr_utility.raise_error;
132 end if;
133
134 --310.02.2
135 -- added 'Z2U' on 22-jul-1998
136 if p_First_NOAC_Lookup_Code= '352'
137 and
138 NOT ( p_First_Action_NOA_LA_Code1 in
139 ('DBM','DFM','DKM','HAM','PDM','PZM','VCR','VCS','VCT',
140 'VCW','VDJ','V8V','Z2U','ZPM','ZVB','ZVC') AND
141 p_First_Action_NOA_LA_Code2 in
142 ('DBM','DFM','DKM','HAM','PDM','PZM','VCR','VCS','VCT',
143 'VCW','VDJ','V8V','Z2U','ZPM','ZVB','ZVC') ) THEN
144 hr_utility.set_message(8301, 'GHR_37355_ALL_PROCEDURE_FAIL');
145 hr_utility.raise_error;
146 end if;
147
148 --310.05.2
149 -- Update/Change Date By Effective Date Comment
150 -- 9/5 08/12/99 vravikan 01-Apr-1999 Add ZJV
151 -- 2038423 10/08/01 vravikan Add ZJW
152
153 if p_effective_date >= to_date('1999/04/01','yyyy/mm/dd') then
154
155 if p_First_NOAC_Lookup_Code= '353'
156 and
157 NOT ( p_First_Action_NOA_LA_Code1 in
158 ('Q3K','UFM','V8V','ZJR','ZJS','ZJT','ZJU','ZJV','ZJW','ZVB','ZVC') AND
159 p_First_Action_NOA_LA_Code2 in
160 ('Q3K','UFM','V8V','ZJR','ZJS','ZJT','ZJU','ZJV','ZJW','ZVB','ZVC') ) THEN
161 hr_utility.set_message(8301, 'GHR_37167_ALL_PROCEDURE_FAIL');
162 hr_utility.raise_error;
163 end if;
164 else
165 if p_First_NOAC_Lookup_Code= '353'
166 and
167 NOT ( p_First_Action_NOA_LA_Code1 in
168 ('Q3K','UFM','V8V','ZJR','ZJS','ZJT','ZJU','ZJW','ZVB','ZVC') AND
169 p_First_Action_NOA_LA_Code2 in
170 ('Q3K','UFM','V8V','ZJR','ZJS','ZJT','ZJU','ZJW','ZVB','ZVC') ) THEN
171 hr_utility.set_message(8301, 'GHR_37356_ALL_PROCEDURE_FAIL');
172 hr_utility.raise_error;
173 end if;
174 end if;
175 --310.11.2
176 -- added legal authority Z2W on 9-oct-98
177 --upd47 26-Jun-06 Raju From Beginning Added Z5N
178 --upd57 27-Jul-09 Mani From 01-MAR-2009 Removed Z5N
179
180 if p_effective_date >= to_date('2009/03/01','yyyy/mm/dd') then
181 if p_First_NOAC_Lookup_Code= '356' and
182 NOT ( p_First_Action_NOA_LA_Code1 in
183 ('HAM','PNM','PNR','UAM','UFM','VDK','VGL','V8K','V8V','Z2W','ZVB','ZVC') AND
184 p_First_Action_NOA_LA_Code2 in
185 ('HAM','PNM','PNR','UAM','UFM','VDK','VGL','V8K','V8V','Z2W','ZVB','ZVC') ) THEN
186 hr_utility.set_message(8301, 'GHR_37357_ALL_PROCEDURE_FAIL');
187 hr_utility.set_message_token('LAC_CODE','HAM, PNM, PNR, UAM, UFM, VDK, VGL, V8K, V8V, Z2W, ZVB,ZVC.');
188 hr_utility.raise_error;
189 end if;
190 else
191 if p_First_NOAC_Lookup_Code= '356' and
192 NOT ( p_First_Action_NOA_LA_Code1 in
193 ('HAM','PNM','PNR','UAM','UFM','VDK','VGL','V8K','V8V','Z2W','ZVB','ZVC','Z5N') AND
194 p_First_Action_NOA_LA_Code2 in
195 ('HAM','PNM','PNR','UAM','UFM','VDK','VGL','V8K','V8V','Z2W','ZVB','ZVC','Z5N') ) THEN
196 hr_utility.set_message(8301, 'GHR_37357_ALL_PROCEDURE_FAIL');
197 hr_utility.set_message_token('LAC_CODE','HAM, PNM, PNR, UAM, UFM, VDK, VGL, V8K, V8V, Z2W, ZVB,ZVC,Z5N.');
198 hr_utility.raise_error;
199 end if;
200 end if;
201
202 --310.14.2
203 -- added 'Z2U' on 22-jul-1998
204 if p_First_NOAC_Lookup_Code= '357'
205 and
206 NOT ( p_First_Action_NOA_LA_Code1 in
207 ('A3M','C7M','HAM','LTM','LUM','MUM','R9Q','UAM','UFM',
208 'USM','UTM','UXM','UYM','VAA','VCM','V8K','V8N','V8V',
209 'Z2U','ZLJ','ZLK','ZLL','ZLM','ZVB','ZVC') AND
210 p_First_Action_NOA_LA_Code2 in
211 ('A3M','C7M','HAM','LTM','LUM','MUM','R9Q','UAM','UFM',
212 'USM','UTM','UXM','UYM','VAA','VCM','V8K','V8N','V8V',
213 'Z2U','ZLJ','ZLK','ZLL','ZLM','ZVB','ZVC') ) THEN
214 hr_utility.set_message(8301, 'GHR_37358_ALL_PROCEDURE_FAIL');
215 hr_utility.raise_error;
216 end if;
217
218 --315.02.2
219 -- 10/4 08/13/99 vravikan 01-Jan-99 Add VGL
220 -- added 'Z2U' on 22-jul-1998
221 if p_effective_date >= fnd_date.canonical_to_date('19'||'99/01/01') then
222 if p_First_NOAC_Lookup_Code= '385'
223 and
224 NOT ( p_First_Action_NOA_LA_Code1 in
225 ( 'HAM','L2M','L4M','L5M','L6M','L8M','LXM','UFM','VGL',
226 'VUM','VYM','V2M','V8V','Z2U','ZSP','ZVB','ZVC') AND
227 p_First_Action_NOA_LA_Code2 in
228 ('HAM','L2M','L4M','L5M','L6M','L8M','LXM','UFM','VGL',
229 'VUM','VYM','V2M','V8V','Z2U','ZSP','ZVB','ZVC') ) THEN
230 hr_utility.set_message(8301, 'GHR_37095_ALL_PROCEDURE_FAIL');
231 hr_utility.raise_error;
232 end if;
233
234 else
235 if p_First_NOAC_Lookup_Code= '385'
236 and
237 NOT ( p_First_Action_NOA_LA_Code1 in
238 ( 'HAM','L2M','L4M','L5M','L6M','L8M','LXM','UFM',
239 'VUM','VYM','V2M','V8V','Z2U','ZSP','ZVB','ZVC') AND
240 p_First_Action_NOA_LA_Code2 in
241 ('HAM','L2M','L4M','L5M','L6M','L8M','LXM','UFM',
242 'VUM','VYM','V2M','V8V','Z2U','ZSP','ZVB','ZVC') ) THEN
243 hr_utility.set_message(8301, 'GHR_37359_ALL_PROCEDURE_FAIL');
244 hr_utility.raise_error;
245 end if;
246 end if;
247 --320.02.2
248 if p_First_NOAC_Lookup_Code= '430' then
249 if p_First_Action_NOA_LA_Code1 not in ('CUL','ZVB','ZVC') or
250 NVL(p_First_Action_NOA_LA_Code2, 'CUL') not in ('CUL','ZVB','ZVC') then
251 hr_utility.set_message(8301, 'GHR_37360_ALL_PROCEDURE_FAIL');
252 hr_utility.raise_error;
253 end if;
254 end if;
255
256 --320.05.2
257 --Bug# 14104221 Added LAC VDS
258 if p_First_NOAC_Lookup_Code= '450'
259 and
260 NOT ( p_First_Action_NOA_LA_Code1 in
261 ( 'UAM','UFM','USP','USR','VAA','VAB','VAC','VAD','VAE','VAV','VDS', 'V4J',
262 'V8V','VWJ','ZEM','ZVB','ZVC') AND
263 p_First_Action_NOA_LA_Code2 in
264 ('UAM','UFM','USP','USR','VAA','VAB','VAC','VAD','VAE','VAV','VDS', 'V4J',
265 'V8V','VWJ','ZEM','ZVB','ZVC') ) THEN
266 hr_utility.set_message(8301, 'GHR_37361_ALL_PROCEDURE_FAIL');
267 hr_utility.raise_error;
268 end if;
269
270
271 --320.08.2
272 if p_First_NOAC_Lookup_Code= '452'
273 and
274 NOT ( p_First_Action_NOA_LA_Code1 in
275 ( 'UAM','UFM','USM','VAJ', 'VHJ','V8V','ZVB','ZVC') AND
276 p_First_Action_NOA_LA_Code2 in
277 ('UAM','UFM','USM','VAJ', 'VHJ','V8V','ZVB','ZVC') ) THEN
278 hr_utility.set_message(8301, 'GHR_37362_ALL_PROCEDURE_FAIL');
279 hr_utility.raise_error;
280 end if;
281
282 --320.11.2
283 if p_First_NOAC_Lookup_Code= '460'
284 and
285 NOT ( p_First_Action_NOA_LA_Code1 in
286 ( 'DAK','DAM','L9K','NYM','Q3K','UFM','V8V','ZJR','ZJT','ZVB','ZVC') AND
287 p_First_Action_NOA_LA_Code2 in
288 ('DAK','DAM','L9K','NYM','Q3K','UFM','V8V','ZJR','ZJT','ZVB','ZVC') ) THEN
289 hr_utility.set_message(8301, 'GHR_37363_ALL_PROCEDURE_FAIL');
290 hr_utility.raise_error;
291 end if;
292
293 --320.14.2
294 -- Update Date By Effective Date Comment
295 -- 8 01/28/99 vravikan 01/01/99 End date
296 if p_effective_date < fnd_date.canonical_to_date('19'||'99/01/01') then
297 if p_First_NOAC_Lookup_Code= '462'
298 and
299 NOT ( p_First_Action_NOA_LA_Code1 in
300 ( 'GFM','R4M','UFM','V8V','ZVB') AND
301 p_First_Action_NOA_LA_Code2 in
302 ('GFM','R4M','UFM','V8V','ZVB') ) THEN
303 hr_utility.set_message(8301, 'GHR_37364_ALL_PROCEDURE_FAIL');
304 hr_utility.raise_error;
305 end if;
306 end if;
307
308 --320.17.2
309 if p_First_NOAC_Lookup_Code= '471'
310 and
311 NOT ( p_First_Action_NOA_LA_Code1 in
312 ( 'L9K','PNM','UFM','USM','VAJ','VDR','V8V','ZVB','ZVC') AND
313 p_First_Action_NOA_LA_Code2 in
314 ('L9K','PNM','UFM','USM','VAJ','VDR','V8V','ZVB','ZVC') ) THEN
315 hr_utility.set_message(8301, 'GHR_37365_ALL_PROCEDURE_FAIL');
316 hr_utility.raise_error;
317 end if;
318
319 --320.20.2
320 if p_First_NOAC_Lookup_Code= '472'
321 and
322 NOT ( p_First_Action_NOA_LA_Code1 in
323 ( 'L9K','PNM','UFM','USM','VAJ','VDR','V8V','ZVB','ZVC') AND
324 p_First_Action_NOA_LA_Code2 in
325 ('L9K','PNM','UFM','USM','VAJ','VDR','V8V','ZVB','ZVC') ) THEN
326 hr_utility.set_message(8301, 'GHR_37366_ALL_PROCEDURE_FAIL');
327 hr_utility.raise_error;
328 end if;
329
330
331 --320.23.2
332 -- Update/Change Date By Effective Date Comment
333 -- 9/5 08/12/99 vravikan 01-Apr-1999 Add ZJV
334 -- 2038423 10/08/01 vravikan Add ZJW
335 -- 9379166 28/03/10 Raju Add QRD
336 -- 10189715 28/03/10 Raju Removed V8V and ZVB
337
338 if p_effective_date >= to_date('2010/03/28','yyyy/mm/dd') then
339
340 if p_First_NOAC_Lookup_Code= '473'
341 and
342 NOT ( p_First_Action_NOA_LA_Code1 in
343 ( 'Q3K','QRD','ZJU','ZJV','ZJW','ZVC') AND
344 p_First_Action_NOA_LA_Code2 in
345 ('Q3K','QRD','ZJU','ZJV','ZJW','ZVC') ) THEN
346 hr_utility.set_message(8301, 'GHR_37066_ALL_PROCEDURE_FAIL');
347 hr_utility.set_message_token('LA_CODE','Q3K, QRD, ZJU, ZJV, ZJW, ZVC.');
348 hr_utility.raise_error;
349 end if;
350 elsif p_effective_date >= to_date('1999/04/01','yyyy/mm/dd') then
351
352 if p_First_NOAC_Lookup_Code= '473'
353 and
354 NOT ( p_First_Action_NOA_LA_Code1 in
355 ( 'Q3K','V8V','ZJU','ZJV','ZJW','ZVB','ZVC') AND
356 p_First_Action_NOA_LA_Code2 in
357 ('Q3K','V8V','ZJU','ZJV','ZJW','ZVB','ZVC') ) THEN
358 hr_utility.set_message(8301, 'GHR_37066_ALL_PROCEDURE_FAIL');
359 hr_utility.set_message_token('LA_CODE','Q3K, V8V, ZJU, ZJV, ZJW, ZVB, ZVC.');
360 hr_utility.raise_error;
361 end if;
362 else
363 if p_First_NOAC_Lookup_Code= '473'
364 and
365 NOT ( p_First_Action_NOA_LA_Code1 in
366 ( 'Q3K','V8V','ZJU','ZJW','ZVB','ZVC') AND
367 p_First_Action_NOA_LA_Code2 in
368 ('Q3K','V8V','ZJU','ZJW','ZVB','ZVC') ) THEN
369 hr_utility.set_message(8301, 'GHR_37367_ALL_PROCEDURE_FAIL');
370 hr_utility.raise_error;
371 end if;
372
373 end if;
374
375 --320.26.2
376 -- 10/4 08/13/99 vravikan 01-Jan-99 Add VGL
377
378 -- added legal authority Z2W on 9-oct-98
379 if p_effective_date >= fnd_date.canonical_to_date('19'||'99/01/01') then
380 if p_First_NOAC_Lookup_Code= '480'
381 and
382 NOT ( p_First_Action_NOA_LA_Code1 in
383 ('UFM','V3M','VGL','Z2W','ZSP','ZVB','ZVC') AND
384 p_First_Action_NOA_LA_Code2 in
385 ('UFM','V3M','VGL','Z2W','ZSP','ZVB','ZVC') ) THEN
389 else
386 hr_utility.set_message(8301, 'GHR_37096_ALL_PROCEDURE_FAIL');
387 hr_utility.raise_error;
388 end if;
390 if p_First_NOAC_Lookup_Code= '480'
391 and
392 NOT ( p_First_Action_NOA_LA_Code1 in
393 ('UFM','V3M','Z2W','ZSP','ZVB','ZVC') AND
394 p_First_Action_NOA_LA_Code2 in
395 ('UFM','V3M','Z2W','ZSP','ZVB','ZVC') ) THEN
396 hr_utility.set_message(8301, 'GHR_37368_ALL_PROCEDURE_FAIL');
397 hr_utility.raise_error;
398 end if;
399 end if;
400
401 --
402 -- START OF 325.02.2
403 -- added 'BNK' and deleted 'VHM' for the april 98 release
404 -- added 'Z2U' on 22-jul-1998
405 -- added 'ZTA','Z2W' on 9-oct-98
406 -- Update Date By Effective Date Comment
407 -- 8 03/09/99 vravikan 01/31/99 Delete BEA,BMC,BNE
408 -- ,BNW,BRM
409 -- 10/4 08/13/99 vravikan 01-Jan-99 Add VGL
410 -- 11/1 12/13/99 vravikan 01-Dec-99 Add ZBA
411 -- 11/9 12/14/99 vravikan 01-Nov-1999 Add UDM
412 -- 17-Aug-00 vravikan From Begining Add ZBA
413 -- 08-Dec-00 vravikan From Begining Delete ZTA
414 -- 30-Oct-03 Ashley From Begining Added BAB,BAC,BAD,BYO
415 -- 30-APR-04 Madhuri From Beginning Added LYP for 500
416 -- Upd 37 09-NOV-04 Madhuri From beginning Added LAC's - BNR, BNT
417 -- Upd 43 09-NOV-05 Raju From beginning Added BAE
418 -- Upd 39 07-MAR-06 vnarasim From beginning Added BNY
419 -- Upd 47 23-Jun-06 Raju From Begining Added ZJK, Z5B, Z5C, Z5D, Z5E
420 -- upd49 19-Jan-07 Raju From 01-Feb-2005 Bug#5619873 delete BNT
421 -- upd49 19-Jan-07 Raju From Beginning Bug#5619873 add BAF
422 -- Upd 54 12-Jun-07 vmididho From Begining delete BAF
423 --- Upd 56 13-Mar-09 Manish 01-Jan-2009 Added LA code BAG
424 --- Upd 56 13-Mar-09 Manish 17-Feb-2009 Added LA code ZEA
425 --- Upd 57 30-Jul-09 Mani From Begining Added ZVB
426 -- GPPA U59 31-Jul-12 Mani 10-Jul-12 Added LA Codes LAE, LAG, LAH, LAK, LAL, LAP, LAR, LAS
427 -- GPPA U59 01-Oct-12 Mani 10-Jul-12 Added LA Codes LAM
428 -- GPPA U60 22-Nov-12 Raju 10-Jul-12 Added LA Codes LAT, bug# 15853224
429 -- GPPA U60 05-Feb-13 Raju 06-Jan-13 removed LA Codes LAR,LAS,LAT, bug# 16217492
430
431 if p_effective_date >= to_date('19'||'99/12/01','yyyy/mm/dd') then
432 if p_effective_date < fnd_date.canonical_to_date('2005/02/01') then --Bug#5619873
433 if p_First_NOAC_Lookup_Code= '500' and
434 NOT ( p_First_Action_NOA_LA_Code1 in
435 ('ABK','ABL','ABM','ACA','ACM','AYM','A2M',
436 'BAB','BAC','BAD','BAE','BYO',
437 'BBM','BDN','BLM','BNK','BNR', 'BNT','BNY',
438 'BNM','BNN','BWA','BWM',
439 'BYM','HAM','K1M','K7M','K8M','K9M','LBM',
440 'LEM','LHM','LJM','LKM','LKP','LLM','LPM',
441 'LSM','LWM','LYM','LZM','L1M','L2K','L3M','LYP',
442 'PNR','P5M','UDM','VJM','V1P','V8N','VGL','Z2U','Z2W',
443 'ZBA', 'ZGM','ZGY','ZHK','ZJK','ZJM','ZLM','ZMM','ZQM',
444 'ZRM','ZSK','ZSP','ZTR','ZTU','ZTZ','ZVB','Z5B','Z5C','Z5D','Z5E') AND
445 p_First_Action_NOA_LA_Code2 in
446 ('ABK','ABL','ABM','ACA','ACM','AYM','A2M',
447 'BAB','BAC','BAD','BAE','BYO',
448 'BBM','BDN','BLM','BNK','BNR', 'BNT','BNY',
449 'BNM','BNN','BWA','BWM',
450 'BYM','HAM','K1M','K7M','K8M','K9M','LBM',
451 'LEM','LHM','LJM','LKM','LKP','LLM','LPM',
452 'LSM','LWM','LYM','LZM','L1M','L2K','L3M','LYP',
453 'PNR','P5M','UDM','VJM','V1P','V8N','VGL','Z2U','Z2W',
454 'ZBA',
455 'ZGM','ZGY','ZHK','ZJK','ZJM','ZLM','ZMM','ZQM',
456 'ZRM','ZSK','ZSP','ZTR','ZTU','ZTZ','ZVB','Z5B','Z5C','Z5D','Z5E') ) THEN
457 hr_utility.set_message(8301, 'GHR_37299_ALL_PROCEDURE_FAIL');
458 hr_utility.raise_error;
459 end if;
460 elsif p_effective_date < fnd_date.canonical_to_date('2009/01/01') then --Begin Bug#5619873
461 if p_First_NOAC_Lookup_Code= '500' and
462 NOT ( p_First_Action_NOA_LA_Code1 in
463 ('ABK','ABL','ABM','ACA','ACM','AYM','A2M',
464 'BAB','BAC','BAD','BAE','BYO',
465 'BBM','BDN','BLM','BNK','BNR','BNY',
466 'BNM','BNN','BWA','BWM',
467 'BYM','HAM','K1M','K7M','K8M','K9M','LBM',
468 'LEM','LHM','LJM','LKM','LKP','LLM','LPM',
469 'LSM','LWM','LYM','LZM','L1M','L2K','L3M','LYP',
470 'PNR','P5M','UDM','VJM','V1P','V8N','VGL','Z2U','Z2W',
471 'ZBA', 'ZGM','ZGY','ZHK','ZJK','ZJM','ZLM','ZMM','ZQM',
472 'ZRM','ZSK','ZSP','ZTR','ZTU','ZTZ','ZVB','Z5B','Z5C','Z5D','Z5E') AND
473 p_First_Action_NOA_LA_Code2 in
474 ('ABK','ABL','ABM','ACA','ACM','AYM','A2M',
475 'BAB','BAC','BAD','BAE','BYO',
476 'BBM','BDN','BLM','BNK','BNR','BNY',
477 'BNM','BNN','BWA','BWM',
478 'BYM','HAM','K1M','K7M','K8M','K9M','LBM',
479 'LEM','LHM','LJM','LKM','LKP','LLM','LPM',
480 'LSM','LWM','LYM','LZM','L1M','L2K','L3M','LYP',
481 'PNR','P5M','UDM','VJM','V1P','V8N','VGL','Z2U','Z2W',
482 'ZBA',
483 'ZGM','ZGY','ZHK','ZJK','ZJM','ZLM','ZMM','ZQM',
484 'ZRM','ZSK','ZSP','ZTR','ZTU','ZTZ','ZVB','Z5B','Z5C','Z5D','Z5E') ) THEN
485 hr_utility.set_message(8301, 'GHR_37862_ALL_PROCEDURE_FAIL');
486 hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ACA, ACM, AYM, A2M, BWM, BAB, BAC, BAD, BAE,
490 Z5E.');
487 BYO, BBM, BDN, BLM, BNK, BNM, BNN, BNR, BNY, BWA, BWM, BYM, HAM, K1M, K7M, K8M, K9M, LBM, LEM, LHM,
488 LJM, LKM, LKP, LLM, LPM, LSM, LWM, LYM, LYP, LZM, L1M, L2K, L3M, PNR, P5M, UDM,VJM, V1P, V8N, VGL,
489 Z2U, Z2W, ZBA, ZGM, ZGY, ZHK, ZJK, ZJM, ZLM, ZMM, ZQM, ZRM, ZSK, ZSP, ZTR, ZTU, ZTZ, ZVB, Z5B, Z5C, Z5D,
491 hr_utility.raise_error;
492 end if;
493 --End Bug#5619873
494 --Bug# 8329793
495 elsif p_effective_date < fnd_date.canonical_to_date('2009/02/17') then
496 if p_First_NOAC_Lookup_Code= '500' and
497 NOT ( p_First_Action_NOA_LA_Code1 in
498 ('ABK','ABL','ABM','ACA','ACM','AYM','A2M',
499 'BAB','BAC','BAD','BAE','BAG','BYO',
500 'BBM','BDN','BLM','BNK','BNR','BNY',
501 'BNM','BNN','BWA','BWM',
502 'BYM','HAM','K1M','K7M','K8M','K9M','LBM',
503 'LEM','LHM','LJM','LKM','LKP','LLM','LPM',
504 'LSM','LWM','LYM','LZM','L1M','L2K','L3M','LYP',
505 'PNR','P5M','UDM','VJM','V1P','V8N','VGL','Z2U','Z2W',
506 'ZBA', 'ZGM','ZGY','ZHK','ZJK','ZJM','ZLM','ZMM','ZQM',
507 'ZRM','ZSK','ZSP','ZTR','ZTU','ZTZ','ZVB','Z5B','Z5C','Z5D','Z5E') AND
508 p_First_Action_NOA_LA_Code2 in
509 ('ABK','ABL','ABM','ACA','ACM','AYM','A2M',
510 'BAB','BAC','BAD','BAE','BAG','BYO',
511 'BBM','BDN','BLM','BNK','BNR','BNY',
512 'BNM','BNN','BWA','BWM',
513 'BYM','HAM','K1M','K7M','K8M','K9M','LBM',
514 'LEM','LHM','LJM','LKM','LKP','LLM','LPM',
515 'LSM','LWM','LYM','LZM','L1M','L2K','L3M','LYP',
516 'PNR','P5M','UDM','VJM','V1P','V8N','VGL','Z2U','Z2W',
517 'ZBA',
518 'ZGM','ZGY','ZHK','ZJK','ZJM','ZLM','ZMM','ZQM',
519 'ZRM','ZSK','ZSP','ZTR','ZTU','ZTZ','ZVB','Z5B','Z5C','Z5D','Z5E') ) THEN
520 hr_utility.set_message(8301, 'GHR_37862_ALL_PROCEDURE_FAIL');
521 hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ACA, ACM, AYM, A2M, BWM, BAB, BAC, BAD, BAE,
522 BAG, BYO, BBM, BDN, BLM, BNK, BNM, BNN, BNR, BNY, BWA, BWM, BYM, HAM, K1M, K7M, K8M, K9M, LBM, LEM,
523 LHM, LJM, LKM, LKP, LLM, LPM, LSM, LWM, LYM, LYP, LZM, L1M, L2K, L3M, PNR, P5M, UDM,VJM, V1P, V8N,
524 VGL, Z2U, Z2W, ZBA, ZGM, ZGY, ZHK, ZJK, ZJM, ZLM, ZMM, ZQM, ZRM, ZSK, ZSP, ZTR, ZTU, ZTZ, ZVB, Z5B, Z5C,
525 Z5D, Z5E.');
526 hr_utility.raise_error;
527 end if;
528 elsif p_effective_date < fnd_date.canonical_to_date('2012/07/09') then
529 if p_First_NOAC_Lookup_Code= '500' and
530 NOT ( p_First_Action_NOA_LA_Code1 in
531 ('ABK','ABL','ABM','ACA','ACM','AYM','A2M',
532 'BAB','BAC','BAD','BAE','BAG','BYO',
533 'BBM','BDN','BLM','BNK','BNR','BNY',
534 'BNM','BNN','BWA','BWM',
535 'BYM','HAM','K1M','K7M','K8M','K9M','LBM',
536 'LEM','LHM','LJM','LKM','LKP','LLM','LPM',
537 'LSM','LWM','LYM','LZM','L1M','L2K','L3M','LYP',
538 'PNR','P5M','UDM','VJM','V1P','V8N','VGL','Z2U','Z2W',
539 'ZBA', 'ZGM','ZGY','ZHK','ZJK','ZJM','ZLM','ZMM','ZQM',
540 'ZRM','ZSK','ZSP','ZTR','ZTU','ZTZ','ZVB','Z5B','Z5C','Z5D','Z5E','ZEA') AND
541 p_First_Action_NOA_LA_Code2 in
542 ('ABK','ABL','ABM','ACA','ACM','AYM','A2M',
543 'BAB','BAC','BAD','BAE','BAG','BYO',
544 'BBM','BDN','BLM','BNK','BNR','BNY',
545 'BNM','BNN','BWA','BWM',
546 'BYM','HAM','K1M','K7M','K8M','K9M','LBM',
547 'LEM','LHM','LJM','LKM','LKP','LLM','LPM',
548 'LSM','LWM','LYM','LZM','L1M','L2K','L3M','LYP',
549 'PNR','P5M','UDM','VJM','V1P','V8N','VGL','Z2U','Z2W',
550 'ZBA',
551 'ZGM','ZGY','ZHK','ZJK','ZJM','ZLM','ZMM','ZQM',
552 'ZRM','ZSK','ZSP','ZTR','ZTU','ZTZ','ZVB','Z5B','Z5C','Z5D','Z5E','ZEA') ) THEN
553 hr_utility.set_message(8301, 'GHR_37862_ALL_PROCEDURE_FAIL');
554 hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ACA, ACM, AYM, A2M, BWM, BAB, BAC, BAD, BAE, BAG,
555 BYO, BBM, BDN, BLM, BNK, BNM, BNN, BNR, BNY, BWA, BWM, BYM, HAM, K1M, K7M, K8M, K9M, LBM, LEM, LHM, LJM,
556 LKM, LKP, LLM, LPM, LSM, LWM, LYM, LYP, LZM, L1M, L2K, L3M, PNR, P5M, UDM,VJM, V1P, V8N, VGL, Z2U, Z2W,
557 ZBA, ZEA, ZGM, ZGY, ZHK, ZJK, ZJM, ZLM, ZMM, ZQM, ZRM, ZSK, ZSP, ZTR, ZTU, ZTZ, ZVB, Z5B, Z5C, Z5D, Z5E.');
558 hr_utility.raise_error;
559 end if;
560 --BUG # 14395108, 14686025
561 --Bug# 16217492
562 elsif p_effective_date <= fnd_date.canonical_to_date('2013/01/06') then
563 if p_First_NOAC_Lookup_Code= '500' and
564 NOT ( p_First_Action_NOA_LA_Code1 in
565 ('ABK','ABL','ABM','ACA','ACM','AYM','A2M',
566 'BAB','BAC','BAD','BAE','BAG','BYO',
567 'BBM','BDN','BLM','BNK','BNR','BNY',
568 'BNM','BNN','BWA','BWM',
569 'BYM','HAM','K1M','K7M','K8M','K9M','LAE','LAG','LAH','LAK','LAL','LAM','LAP','LAR','LAS','LAT','LBM',
570 'LEM','LHM','LJM','LKM','LKP','LLM','LPM',
571 'LSM','LWM','LYM','LZM','L1M','L2K','L3M','LYP',
572 'PNR','P5M','UDM','VJM','V1P','V8N','VGL','Z2U','Z2W',
573 'ZBA', 'ZGM','ZGY','ZHK','ZJK','ZJM','ZLM','ZMM','ZQM',
574 'ZRM','ZSK','ZSP','ZTR','ZTU','ZTZ','ZVB','Z5B','Z5C','Z5D','Z5E','ZEA') AND
575 p_First_Action_NOA_LA_Code2 in
576 ('ABK','ABL','ABM','ACA','ACM','AYM','A2M',
577 'BAB','BAC','BAD','BAE','BAG','BYO',
578 'BBM','BDN','BLM','BNK','BNR','BNY',
579 'BNM','BNN','BWA','BWM',
580 'BYM','HAM','K1M','K7M','K8M','K9M','LAE','LAG','LAH','LAK','LAL','LAM','LAP','LAR','LAS','LAT','LBM',
581 'LEM','LHM','LJM','LKM','LKP','LLM','LPM',
582 'LSM','LWM','LYM','LZM','L1M','L2K','L3M','LYP',
583 'PNR','P5M','UDM','VJM','V1P','V8N','VGL','Z2U','Z2W',
587 hr_utility.set_message(8301, 'GHR_37862_ALL_PROCEDURE_FAIL');
584 'ZBA',
585 'ZGM','ZGY','ZHK','ZJK','ZJM','ZLM','ZMM','ZQM',
586 'ZRM','ZSK','ZSP','ZTR','ZTU','ZTZ','ZVB','Z5B','Z5C','Z5D','Z5E','ZEA') ) THEN
588 hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ACA, ACM, AYM, A2M, BWM, BAB, BAC, BAD, BAE, BAG,
589 BYO, BBM, BDN, BLM, BNK, BNM, BNN, BNR, BNY, BWA, BWM, BYM, HAM, K1M, K7M, K8M, K9M, LAE, LAG, LAH, LAK, LAL, LAM, LAP,
590 LAR, LAS, LAT, LBM, LEM, LHM, LJM, LKM, LKP, LLM, LPM, LSM, LWM, LYM, LYP, LZM, L1M, L2K, L3M, PNR, P5M, UDM, VJM, V1P, V8N,
591 VGL, Z2U, Z2W, ZBA, ZEA, ZGM, ZGY, ZHK, ZJK, ZJM, ZLM, ZMM, ZQM, ZRM, ZSK, ZSP, ZTR, ZTU, ZTZ, ZVB, Z5B, Z5C, Z5D, Z5E.');
592 hr_utility.raise_error;
593 end if;
594 --BUG # 14395108, 14686025
595 --Begin Bug# 16217492
596 else
597 if p_First_NOAC_Lookup_Code= '500' and
598 NOT ( p_First_Action_NOA_LA_Code1 in
599 ('ABK','ABL','ABM','ACA','ACM','AYM','A2M',
600 'BAB','BAC','BAD','BAE','BAG','BYO',
601 'BBM','BDN','BLM','BNK','BNR','BNY',
602 'BNM','BNN','BWA','BWM',
603 'BYM','HAM','K1M','K7M','K8M','K9M','LAE','LAG','LAH','LAK','LAL','LAM','LAP','LBM',
604 'LEM','LHM','LJM','LKM','LKP','LLM','LPM',
605 'LSM','LWM','LYM','LZM','L1M','L2K','L3M','LYP',
606 'PNR','P5M','UDM','VJM','V1P','V8N','VGL','Z2U','Z2W',
607 'ZBA', 'ZGM','ZGY','ZHK','ZJK','ZJM','ZLM','ZMM','ZQM',
608 'ZRM','ZSK','ZSP','ZTR','ZTU','ZTZ','ZVB','Z5B','Z5C','Z5D','Z5E','ZEA') AND
609 p_First_Action_NOA_LA_Code2 in
610 ('ABK','ABL','ABM','ACA','ACM','AYM','A2M',
611 'BAB','BAC','BAD','BAE','BAG','BYO',
612 'BBM','BDN','BLM','BNK','BNR','BNY',
613 'BNM','BNN','BWA','BWM',
614 'BYM','HAM','K1M','K7M','K8M','K9M','LAE','LAG','LAH','LAK','LAL','LAM','LAP','LBM',
615 'LEM','LHM','LJM','LKM','LKP','LLM','LPM',
616 'LSM','LWM','LYM','LZM','L1M','L2K','L3M','LYP',
617 'PNR','P5M','UDM','VJM','V1P','V8N','VGL','Z2U','Z2W',
618 'ZBA',
619 'ZGM','ZGY','ZHK','ZJK','ZJM','ZLM','ZMM','ZQM',
620 'ZRM','ZSK','ZSP','ZTR','ZTU','ZTZ','ZVB','Z5B','Z5C','Z5D','Z5E','ZEA') ) THEN
621 hr_utility.set_message(8301, 'GHR_37862_ALL_PROCEDURE_FAIL');
622 hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ACA, ACM, AYM, A2M, BWM, BAB, BAC, BAD, BAE, BAG,
623 BYO, BBM, BDN, BLM, BNK, BNM, BNN, BNR, BNY, BWA, BWM, BYM, HAM, K1M, K7M, K8M, K9M, LAE, LAG, LAH, LAK, LAL, LAM, LAP,
624 LBM, LEM, LHM, LJM, LKM, LKP, LLM, LPM, LSM, LWM, LYM, LYP, LZM, L1M, L2K, L3M, PNR, P5M, UDM, VJM, V1P, V8N,
625 VGL, Z2U, Z2W, ZBA, ZEA, ZGM, ZGY, ZHK, ZJK, ZJM, ZLM, ZMM, ZQM, ZRM, ZSK, ZSP, ZTR, ZTU, ZTZ, ZVB, Z5B, Z5C, Z5D, Z5E.');
626 hr_utility.raise_error;
627 end if;
628 end if;
629 --end Bug# 16217492
630 --Bug# 8329793
631 elsif p_effective_date > to_date('19'||'99/11/01','yyyy/mm/dd') then
632
633 if p_First_NOAC_Lookup_Code= '500'
634 and
635 NOT ( p_First_Action_NOA_LA_Code1 in
636 ('ABK','ABL','ABM','ACA','ACM','AYM','A2M',
637 'BAB','BAC','BAD','BAE','BYO',
638 'BBM','BDN','BLM','BNK','BNR', 'BNT','BNY',
639 'BNM','BNN','BWA','BWM',
640 'BYM','HAM','K1M','K7M','K8M','K9M','LBM',
641 'LEM','LHM','LJM','LKM','LKP','LLM','LPM',
642 'LSM','LWM','LYM','LZM','L1M','L2K','L3M','LYP',
643 'PNR','P5M','UDM','VJM','V1P','V8N','VGL','Z2U','Z2W',
644 'ZBA','ZGM','ZGY','ZHK','ZJK','ZJM','ZLM','ZMM','ZQM',
645 'ZRM','ZSK','ZSP','ZTR','ZTU','ZTZ','ZVB','Z5B','Z5C','Z5D','Z5E') AND
646 p_First_Action_NOA_LA_Code2 in
647 ('ABK','ABL','ABM','ACA','ACM','AYM','A2M',
648 'BAB','BAC','BAD','BAE','BYO',
649 'BBM','BDN','BLM','BNK','BNR', 'BNT','BNY',
650 'BNM','BNN','BWA','BWM',
651 'BYM','HAM','K1M','K7M','K8M','K9M','LBM',
652 'LEM','LHM','LJM','LKM','LKP','LLM','LPM',
653 'LSM','LWM','LYM','LZM','L1M','L2K','L3M','LYP',
654 'PNR','P5M','UDM','VJM','V1P','V8N','VGL','Z2U','Z2W',
655 'ZBA','ZGM','ZGY','ZHK','ZJK','ZJM','ZLM','ZMM','ZQM',
656 'ZRM','ZSK','ZSP','ZTR','ZTU','ZTZ','ZVB','Z5B','Z5C','Z5D','Z5E') ) THEN
657 hr_utility.set_message(8301, 'GHR_37169_ALL_PROCEDURE_FAIL');
658 hr_utility.raise_error;
659 end if;
660 elsif p_effective_date > to_date('19'||'99/01/31','yyyy/mm/dd') then
661
662 if p_First_NOAC_Lookup_Code= '500'
663 and
664 NOT ( p_First_Action_NOA_LA_Code1 in
665 ('ABK','ABL','ABM','ACA','ACM','AYM','A2M',
666 'BAB','BAC','BAD','BAE','BYO',
667 'BBM','BDN','BLM','BNK','BNR', 'BNT','BNY',
668 'BNM','BNN','BWA','BWM',
669 'BYM','HAM','K1M','K7M','K8M','K9M','LBM',
670 'LEM','LHM','LJM','LKM','LKP','LLM','LPM',
671 'LSM','LWM','LYM','LZM','L1M','L2K','L3M','LYP',
672 'PNR','P5M','VJM','V1P','V8N','VGL','Z2U','Z2W',
673 'ZBA','ZGM','ZGY','ZHK','ZJK','ZJM','ZLM','ZMM','ZQM',
674 'ZRM','ZSK','ZSP','ZTR','ZTU','ZTZ','ZVB','Z5B','Z5C','Z5D','Z5E') AND
675 p_First_Action_NOA_LA_Code2 in
676 ('ABK','ABL','ABM','ACA','ACM','AYM','A2M',
677 'BAB','BAC','BAD','BAE','BYO',
678 'BBM','BDN','BLM','BNK','BNR', 'BNT','BNY',
679 'BNM','BNN','BWA','BWM',
680 'BYM','HAM','K1M','K7M','K8M','K9M','LBM',
681 'LEM','LHM','LJM','LKM','LKP','LLM','LPM',
682 'LSM','LWM','LYM','LZM','L1M','L2K','L3M','LYP',
683 'PNR','P5M','VJM','V1P','V8N','VGL','Z2U','Z2W',
684 'ZBA','ZGM','ZGY','ZHK','ZJK','ZJM','ZLM','ZMM','ZQM',
685 'ZRM','ZSK','ZSP','ZTR','ZTU','ZTZ','ZVB','Z5B','Z5C','Z5D','Z5E') ) THEN
686 hr_utility.set_message(8301, 'GHR_37044_ALL_PROCEDURE_FAIL');
687 hr_utility.raise_error;
688 end if;
689 elsif p_effective_date >= to_date('19'||'99/01/01','yyyy/mm/dd') then
693 ('ABK','ABL','ABM','ACA','ACM','AYM','A2M',
690 if p_First_NOAC_Lookup_Code= '500'
691 and
692 NOT ( p_First_Action_NOA_LA_Code1 in
694 'BAB','BAC','BAD','BAE','BYO',
695 'BBM','BDN','BEA','BLM','BMC','BNE','BNK','BNR', 'BNT','BNY',
696 'BNM','BNN','BNW','BRM','BWA','BWM',
697 'BYM','HAM','K1M','K7M','K8M','K9M','LBM',
698 'LEM','LHM','LJM','LKM','LKP','LLM','LPM',
699 'LSM','LWM','LYM','LZM','L1M','L2K','L3M','LYP',
700 'PNR','P5M','VJM','V1P','V8N','VGL','Z2U','Z2W',
701 'ZBA','ZGM','ZGY','ZHK','ZJK','ZJM','ZLM','ZMM','ZQM',
702 'ZRM','ZSK','ZSP','ZTR','ZTU','ZTZ','ZVB','Z5B','Z5C','Z5D','Z5E') AND
703 p_First_Action_NOA_LA_Code2 in
704 ('ABK','ABL','ABM','ACA','ACM','AYM','A2M',
705 'BAB','BAC','BAD','BAE','BYO',
706 'BBM','BDN','BEA','BLM','BMC','BNE','BNK','BNR', 'BNT','BNY',
707 'BNM','BNN','BNW','BRM','BWA','BWM',
708 'BYM','HAM','K1M','K7M','K8M','K9M','LBM',
709 'LEM','LHM','LJM','LKM','LKP','LLM','LPM',
710 'LSM','LWM','LYM','LZM','L1M','L2K','L3M','LYP',
711 'PNR','P5M','VJM','V1P','V8N','VGL','Z2U','Z2W',
712 'ZBA','ZGM','ZGY','ZHK','ZJK','ZJM','ZLM','ZMM','ZQM',
713 'ZRM','ZSK','ZSP','ZTR','ZTU','ZTZ','ZVB','Z5B','Z5C','Z5D','Z5E') ) THEN
714 hr_utility.set_message(8301, 'GHR_37098_ALL_PROCEDURE_FAIL');
715 hr_utility.raise_error;
716 end if;
717 else
718 if p_First_NOAC_Lookup_Code= '500'
719 and
720 NOT ( p_First_Action_NOA_LA_Code1 in
721 ('ABK','ABL','ABM','ACA','ACM','AYM','A2M',
722 'BAB','BAC','BAD','BAE','BYO',
723 'BBM','BDN','BEA','BLM','BMC','BNE','BNK','BNR', 'BNT','BNY',
724 'BNM','BNN','BNW','BRM','BWA','BWM',
725 'BYM','HAM','K1M','K7M','K8M','K9M','LBM',
726 'LEM','LHM','LJM','LKM','LKP','LLM','LPM',
727 'LSM','LWM','LYM','LZM','L1M','L2K','L3M','LYP',
728 'PNR','P5M','VJM','V1P','V8N','Z2U','Z2W',
729 'ZBA','ZGM','ZGY','ZHK','ZJK','ZJM','ZLM','ZMM','ZQM',
730 'ZRM','ZSK','ZSP','ZTR','ZTU','ZTZ','ZVB','Z5B','Z5C','Z5D','Z5E') AND
731 p_First_Action_NOA_LA_Code2 in
732 ('ABK','ABL','ABM','ACA','ACM','AYM','A2M',
733 'BAB','BAC','BAD','BAE','BYO',
734 'BBM','BDN','BEA','BLM','BMC','BNE','BNK','BNR', 'BNT','BNY',
735 'BNM','BNN','BNW','BRM','BWA','BWM',
736 'BYM','HAM','K1M','K7M','K8M','K9M','LBM',
737 'LEM','LHM','LJM','LKM','LKP','LLM','LPM',
738 'LSM','LWM','LYM','LZM','L1M','L2K','L3M','LYP',
739 'PNR','P5M','VJM','V1P','V8N','Z2U','Z2W',
740 'ZBA','ZGM','ZGY','ZHK','ZJK','ZJM','ZLM','ZMM','ZQM',
741 'ZRM','ZSK','ZSP','ZTR','ZTU','ZTZ','ZVB','Z5B','Z5C','Z5D','Z5E') ) THEN
742 hr_utility.set_message(8301, 'GHR_37369_ALL_PROCEDURE_FAIL');
743 hr_utility.raise_error;
744 end if;
745
746 end if;
747 -- END OF 325.02.2
748 --
749 -- START OF 325.05.2
750 -- added 'BNK' for the april 98 release
751 -- added 'Z2U' on 22-jul-1998
752 -- added 'ZTA','Z2W' on 9-oct-98
753 -- Update Date By Effective Date Comment
754 -- 8 03/09/99 vravikan 01/31/99 Delete BEA,BMC
755 -- ,BNE,BNW,BRM
756 -- 10/4 08/13/99 vravikan 01-Jan-99 Add VGL
757 -- 11/1 12/13/99 vravikan 01-Dec-99 Add ZBA
758 -- 11/9 12/14/99 vravikan 01-Nov-1999 Add UDM
759 -- 17-Aug-00 vravikan From Begining Add ZBA,Delete BNP
760 -- 08-Dec-00 vravikan From Begining Delete ZTA
761 -- 30-Oct-03 Ashley From Begining Added BAB,BAC,BAD,BYO
762 -- 30-APR-04 Madhuri From Beginning Added LYP for 501
763 -- Upd 37 09-NOV-04 Madhuri From beginning Added LAC's - BNR, BNT
764 -- Upd 43 09-NOV-05 Raju From beginning Added BAE
765 -- upd49 19-Jan-07 Raju From beginning Bug#5619873 delete BNT,add BAF
766 -- Upd 54 12-Jun-07 vmididho From Begining delete BAF
767 --- Upd 56 13-Mar-09 Manish 01-Jan-2009 Added LA code BAG
768 --- Upd 56 13-Mar-09 Manish 17-Feb-2009 Added LA code ZEA
769 --- Upd 57 30-Jul-09 Mani From Begining Added Z5B, Z5C, Z5D, Z5E
770 -- GPPA U51 14-Aug-09 Raju 11-Sep-2009 Added LAM(8799026)
771 -- GPPA U59 31-Jul-12 Mani 10-Jul-12 Added LA Codes LAE, LAG, LAH, LAK, LAL, LAP, LAR, LAS
772 -- GPPA U60 22-Nov-12 Raju 10-Jul-12 Added LA Codes LAT,bug# 15853224
773 -- GPPA U60 05-Feb-13 Raju 06-Jan-13 removed LA Codes LAR,LAS,LAT, bug# 16217492
774 --BUG # 16217492
775 if p_effective_date > to_date('2013/01/06','yyyy/mm/dd') then
776 if p_First_NOAC_Lookup_Code= '501'
777 and
778 NOT ( p_First_Action_NOA_LA_Code1 in
779 ('ABK','ABL','ABM','ACA','ACM','AYM','A2M',
780 'BAB','BAC','BAD','BAE','BAG','BYO',
781 'BBM','BDN','BLM','BNK','BNR','BNY',
782 'BNM','BNN','BWA','BWM',
783 'BYM','HAM','K1M','K7M','K8M','K9M','LAM','LAE','LAG','LAH','LAK','LAL','LAP','LBM',
784 'LEM','LHM','LJM','LKM','LKP','LLM','LPM',
785 'LSM','LYM','LZM','L1M','L2K','L3M','LYP','PNR',
786 'P5M','UDM','V1P','V8M','V8N','VGL','Z2U','Z2W','ZGM',
787 'ZBA','ZHK','ZJK','ZJM',
788 'ZLM','ZQM','ZRM','ZSK','ZSP','ZTU','ZTZ','ZEA','Z5B','Z5C','Z5D','Z5E') AND
789 p_First_Action_NOA_LA_Code2 in
790 ('ABK','ABL','ABM','ACA','ACM','AYM','A2M',
791 'BAB','BAC','BAD','BAE','BAG','BYO',
792 'BBM','BDN','BLM','BNK','BNR', 'BNY',
793 'BNM','BNN','BWA','BWM',
794 'BYM','HAM','K1M','K7M','K8M','K9M','LAM','LAE','LAG','LAH','LAK','LAL','LAP','LBM',
795 'LEM','LHM','LJM','LKM','LKP','LLM','LPM',
796 'LSM','LYM','LZM','L1M','L2K','L3M','LYP','PNR',
800 hr_utility.set_message(8301, 'GHR_37300_ALL_PROCEDURE_FAIL');
797 'P5M','UDM','V1P','V8M','V8N','VGL','Z2U','Z2W','ZGM',
798 'ZBA','ZHK','ZJK','ZJM',
799 'ZLM','ZQM','ZRM','ZSK','ZSP','ZTU','ZTZ','ZEA','Z5B','Z5C','Z5D','Z5E') ) THEN
801 hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ACA, ACM, AYM, A2M, BAG, BBM, BDN, BLM, BNK, BNM,
802 BNR, BNY, BWM, BAB, BAC, BAD, BAE, BYO, BNN, BWA, BWM, BYM, HAM, K1M, K7M, K8M, K9M, LAE, LAG, LAH, LAK, LAL, LAP,
803 LAM, LBM, LEM, LHM, LJM, LKM, LKP, LLM, LPM, LSM, LYM, LYP, LZM, L1M, L2K, L3M, PNR, P5M, UDM, V1P, V8M,
804 V8N, VGL, Z2U, Z2W, ZBA, ZEA, ZGM, ZHK, ZJK, ZJM, ZLM, ZQM, ZRM, ZSK, ZSP, ZTU, ZTZ, Z5B, Z5C, Z5D, Z5E.');
805 hr_utility.raise_error;
806 end if;
807 --BUG # 16217492
808
809 --BUG # 14395108
810 elsif p_effective_date >= to_date('2012/07/10','yyyy/mm/dd') then
811 if p_First_NOAC_Lookup_Code= '501'
812 and
813 NOT ( p_First_Action_NOA_LA_Code1 in
814 ('ABK','ABL','ABM','ACA','ACM','AYM','A2M',
815 'BAB','BAC','BAD','BAE','BAG','BYO',
816 'BBM','BDN','BLM','BNK','BNR','BNY',
817 'BNM','BNN','BWA','BWM',
818 'BYM','HAM','K1M','K7M','K8M','K9M','LAM','LAE','LAG','LAH','LAK','LAL','LAP','LAR','LAS','LAT','LBM',
819 'LEM','LHM','LJM','LKM','LKP','LLM','LPM',
820 'LSM','LYM','LZM','L1M','L2K','L3M','LYP','PNR',
821 'P5M','UDM','V1P','V8M','V8N','VGL','Z2U','Z2W','ZGM',
822 'ZBA','ZHK','ZJK','ZJM',
823 'ZLM','ZQM','ZRM','ZSK','ZSP','ZTU','ZTZ','ZEA','Z5B','Z5C','Z5D','Z5E') AND
824 p_First_Action_NOA_LA_Code2 in
825 ('ABK','ABL','ABM','ACA','ACM','AYM','A2M',
826 'BAB','BAC','BAD','BAE','BAG','BYO',
827 'BBM','BDN','BLM','BNK','BNR', 'BNY',
828 'BNM','BNN','BWA','BWM',
829 'BYM','HAM','K1M','K7M','K8M','K9M','LAM','LAE','LAG','LAH','LAK','LAL','LAP','LAR','LAS','LAT','LBM',
830 'LEM','LHM','LJM','LKM','LKP','LLM','LPM',
831 'LSM','LYM','LZM','L1M','L2K','L3M','LYP','PNR',
832 'P5M','UDM','V1P','V8M','V8N','VGL','Z2U','Z2W','ZGM',
833 'ZBA','ZHK','ZJK','ZJM',
834 'ZLM','ZQM','ZRM','ZSK','ZSP','ZTU','ZTZ','ZEA','Z5B','Z5C','Z5D','Z5E') ) THEN
835 hr_utility.set_message(8301, 'GHR_37300_ALL_PROCEDURE_FAIL');
836 hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ACA, ACM, AYM, A2M, BAG, BBM, BDN, BLM, BNK, BNM,
837 BNR, BNY, BWM, BAB, BAC, BAD, BAE, BYO, BNN, BWA, BWM, BYM, HAM, K1M, K7M, K8M, K9M, LAE, LAG, LAH, LAK, LAL, LAP,
838 LAR, LAS, LAT, LAM, LBM, LEM, LHM, LJM, LKM, LKP, LLM, LPM, LSM, LYM, LYP, LZM, L1M, L2K, L3M, PNR, P5M, UDM, V1P, V8M,
839 V8N, VGL, Z2U, Z2W, ZBA, ZEA, ZGM, ZHK, ZJK, ZJM, ZLM, ZQM, ZRM, ZSK, ZSP, ZTU, ZTZ, Z5B, Z5C, Z5D, Z5E.');
840 hr_utility.raise_error;
841 end if;
842 --BUG # 14395108
843 --Begin Bug# 8799026
844 elsif p_effective_date >= to_date('2009/09/11','yyyy/mm/dd') then
845 if p_First_NOAC_Lookup_Code= '501'
846 and
847 NOT ( p_First_Action_NOA_LA_Code1 in
848 ('ABK','ABL','ABM','ACA','ACM','AYM','A2M',
849 'BAB','BAC','BAD','BAE','BAG','BYO',
850 'BBM','BDN','BLM','BNK','BNR','BNY',
851 'BNM','BNN','BWA','BWM',
852 'BYM','HAM','K1M','K7M','K8M','K9M','LAM','LBM',
853 'LEM','LHM','LJM','LKM','LKP','LLM','LPM',
854 'LSM','LYM','LZM','L1M','L2K','L3M','LYP','PNR',
855 'P5M','UDM','V1P','V8M','V8N','VGL','Z2U','Z2W','ZGM',
856 'ZBA','ZHK','ZJK','ZJM',
857 'ZLM','ZQM','ZRM','ZSK','ZSP','ZTU','ZTZ','ZEA','Z5B','Z5C','Z5D','Z5E') AND
858 p_First_Action_NOA_LA_Code2 in
859 ('ABK','ABL','ABM','ACA','ACM','AYM','A2M',
860 'BAB','BAC','BAD','BAE','BAG','BYO',
861 'BBM','BDN','BLM','BNK','BNR', 'BNY',
862 'BNM','BNN','BWA','BWM',
863 'BYM','HAM','K1M','K7M','K8M','K9M','LAM','LBM',
864 'LEM','LHM','LJM','LKM','LKP','LLM','LPM',
865 'LSM','LYM','LZM','L1M','L2K','L3M','LYP','PNR',
866 'P5M','UDM','V1P','V8M','V8N','VGL','Z2U','Z2W','ZGM',
867 'ZBA','ZHK','ZJK','ZJM',
868 'ZLM','ZQM','ZRM','ZSK','ZSP','ZTU','ZTZ','ZEA','Z5B','Z5C','Z5D','Z5E') ) THEN
869 hr_utility.set_message(8301, 'GHR_37300_ALL_PROCEDURE_FAIL');
870 hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ACA, ACM, AYM, A2M, BAG, BBM, BDN, BLM, BNK, BNM,
871 BNR, BNY, BWM, BAB, BAC, BAD, BAE, BYO, BNN, BWA, BWM, BYM, HAM, K1M, K7M, K8M, K9M, LAM, LBM, LEM, LHM, LJM,
872 LKM, LKP, LLM, LPM, LSM, LYM, LYP, LZM, L1M, L2K, L3M, PNR, P5M, UDM, V1P, V8M, V8N, VGL, Z2U, Z2W, ZBA,
873 ZEA, ZGM, ZHK, ZJK, ZJM, ZLM, ZQM, ZRM, ZSK, ZSP, ZTU, ZTZ, Z5B, Z5C, Z5D, Z5E.');
874 hr_utility.raise_error;
875 end if;
876 --End Bug# 8799026
877 elsif p_effective_date >= to_date('2009/02/17','yyyy/mm/dd') then
878 if p_First_NOAC_Lookup_Code= '501'
879 and
880 NOT ( p_First_Action_NOA_LA_Code1 in
881 ('ABK','ABL','ABM','ACA','ACM','AYM','A2M',
882 'BAB','BAC','BAD','BAE','BAG','BYO',
883 'BBM','BDN','BLM','BNK','BNR','BNY',
884 'BNM','BNN','BWA','BWM',
885 'BYM','HAM','K1M','K7M','K8M','K9M','LBM',
886 'LEM','LHM','LJM','LKM','LKP','LLM','LPM',
887 'LSM','LYM','LZM','L1M','L2K','L3M','LYP','PNR',
888 'P5M','UDM','V1P','V8M','V8N','VGL','Z2U','Z2W','ZGM',
889 'ZBA','ZHK','ZJK','ZJM',
890 'ZLM','ZQM','ZRM','ZSK','ZSP','ZTU','ZTZ','ZEA','Z5B','Z5C','Z5D','Z5E') AND
891 p_First_Action_NOA_LA_Code2 in
892 ('ABK','ABL','ABM','ACA','ACM','AYM','A2M',
893 'BAB','BAC','BAD','BAE','BAG','BYO',
894 'BBM','BDN','BLM','BNK','BNR', 'BNY',
895 'BNM','BNN','BWA','BWM',
896 'BYM','HAM','K1M','K7M','K8M','K9M','LBM',
897 'LEM','LHM','LJM','LKM','LKP','LLM','LPM',
898 'LSM','LYM','LZM','L1M','L2K','L3M','LYP','PNR',
899 'P5M','UDM','V1P','V8M','V8N','VGL','Z2U','Z2W','ZGM',
900 'ZBA','ZHK','ZJK','ZJM',
904 BNR, BNY, BWM, BAB, BAC, BAD, BAE, BYO, BNN, BWA, BWM, BYM, HAM, K1M, K7M, K8M, K9M, LBM, LEM, LHM, LJM,
901 'ZLM','ZQM','ZRM','ZSK','ZSP','ZTU','ZTZ','ZEA','Z5B','Z5C','Z5D','Z5E') ) THEN
902 hr_utility.set_message(8301, 'GHR_37300_ALL_PROCEDURE_FAIL');
903 hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ACA, ACM, AYM, A2M, BAG, BBM, BDN, BLM, BNK, BNM,
905 LKM, LKP, LLM, LPM, LSM, LYM, LYP, LZM, L1M, L2K, L3M, PNR, P5M, UDM, V1P, V8M, V8N, VGL, Z2U, Z2W, ZBA,
906 ZEA, ZGM, ZHK, ZJK, ZJM, ZLM, ZQM, ZRM, ZSK, ZSP, ZTU, ZTZ, Z5B, Z5C, Z5D, Z5E.');
907 hr_utility.raise_error;
908 end if;
909 elsif p_effective_date >= to_date('2009/01/01','yyyy/mm/dd') then
910 if p_First_NOAC_Lookup_Code= '501'
911 and
912 NOT ( p_First_Action_NOA_LA_Code1 in
913 ('ABK','ABL','ABM','ACA','ACM','AYM','A2M',
914 'BAB','BAC','BAD','BAE','BAG','BYO',
915 'BBM','BDN','BLM','BNK','BNR','BNY',
916 'BNM','BNN','BWA','BWM',
917 'BYM','HAM','K1M','K7M','K8M','K9M','LBM',
918 'LEM','LHM','LJM','LKM','LKP','LLM','LPM',
919 'LSM','LYM','LZM','L1M','L2K','L3M','LYP','PNR',
920 'P5M','UDM','V1P','V8M','V8N','VGL','Z2U','Z2W','ZGM',
921 'ZBA','ZHK','ZJK','ZJM',
922 'ZLM','ZQM','ZRM','ZSK','ZSP','ZTU','ZTZ','ZEA','Z5B','Z5C','Z5D','Z5E') AND
923 p_First_Action_NOA_LA_Code2 in
924 ('ABK','ABL','ABM','ACA','ACM','AYM','A2M',
925 'BAB','BAC','BAD','BAE','BAG','BYO',
926 'BBM','BDN','BLM','BNK','BNR', 'BNY',
927 'BNM','BNN','BWA','BWM',
928 'BYM','HAM','K1M','K7M','K8M','K9M','LBM',
929 'LEM','LHM','LJM','LKM','LKP','LLM','LPM',
930 'LSM','LYM','LZM','L1M','L2K','L3M','LYP','PNR',
931 'P5M','UDM','V1P','V8M','V8N','VGL','Z2U','Z2W','ZGM',
932 'ZBA','ZHK','ZJK','ZJM',
933 'ZLM','ZQM','ZRM','ZSK','ZSP','ZTU','ZTZ','ZEA','Z5B','Z5C','Z5D','Z5E') ) THEN
934 hr_utility.set_message(8301, 'GHR_37300_ALL_PROCEDURE_FAIL');
935 hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ACA, ACM, AYM, A2M, BAG, BBM, BDN, BLM, BNK, BNM,
936 BNR, BNY, BWM, BAB, BAC, BAD, BAE, BYO, BNN, BWA, BWM, BYM, HAM, K1M, K7M, K8M, K9M, LBM, LEM, LHM, LJM,
937 LKM, LKP, LLM, LPM, LSM, LYM, LYP, LZM, L1M, L2K, L3M, PNR, P5M, UDM, V1P, V8M, V8N, VGL, Z2U, Z2W, ZBA,
938 ZGM, ZHK, ZJK, ZJM, ZLM, ZQM, ZRM, ZSK, ZSP, ZTU, ZTZ, Z5B, Z5C, Z5D, Z5E.');
939 hr_utility.raise_error;
940 end if;
941 elsif p_effective_date >= to_date('19'||'99/12/01','yyyy/mm/dd') then
942 if p_First_NOAC_Lookup_Code= '501'
943 and
944 NOT ( p_First_Action_NOA_LA_Code1 in
945 ('ABK','ABL','ABM','ACA','ACM','AYM','A2M',
946 'BAB','BAC','BAD','BAE','BYO',
947 'BBM','BDN','BLM','BNK','BNR','BNY',
948 'BNM','BNN','BWA','BWM',
949 'BYM','HAM','K1M','K7M','K8M','K9M','LBM',
950 'LEM','LHM','LJM','LKM','LKP','LLM','LPM',
951 'LSM','LYM','LZM','L1M','L2K','L3M','LYP','PNR',
952 'P5M','UDM','V1P','V8M','V8N','VGL','Z2U','Z2W','ZGM',
953 'ZBA','ZHK','ZJK','ZJM',
954 'ZLM','ZQM','ZRM','ZSK','ZSP','ZTU','ZTZ','Z5B','Z5C','Z5D','Z5E') AND
955 p_First_Action_NOA_LA_Code2 in
956 ('ABK','ABL','ABM','ACA','ACM','AYM','A2M',
957 'BAB','BAC','BAD','BAE','BYO',
958 'BBM','BDN','BLM','BNK','BNR', 'BNY',
959 'BNM','BNN','BWA','BWM',
960 'BYM','HAM','K1M','K7M','K8M','K9M','LBM',
961 'LEM','LHM','LJM','LKM','LKP','LLM','LPM',
962 'LSM','LYM','LZM','L1M','L2K','L3M','LYP','PNR',
963 'P5M','UDM','V1P','V8M','V8N','VGL','Z2U','Z2W','ZGM',
964 'ZBA','ZHK','ZJK','ZJM',
965 'ZLM','ZQM','ZRM','ZSK','ZSP','ZTU','ZTZ','Z5B','Z5C','Z5D','Z5E') ) THEN
966 hr_utility.set_message(8301, 'GHR_37300_ALL_PROCEDURE_FAIL');
967 hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ACA, ACM, AYM, A2M, BBM, BDN, BLM, BNK, BNM, BNR,
968 BNY, BWM, BAB, BAC, BAD, BAE, BYO, BNN, BWA, BWM, BYM, HAM, K1M, K7M, K8M, K9M, LBM, LEM, LHM, LJM, LKM,
969 LKP, LLM, LPM, LSM, LYM, LYP, LZM, L1M, L2K, L3M, PNR, P5M, UDM, V1P, V8M, V8N, VGL, Z2U, Z2W, ZBA, ZGM,
970 ZHK, ZJK, ZJM, ZLM, ZQM, ZRM, ZSK, ZSP, ZTU, ZTZ, Z5B, Z5C, Z5D, Z5E.');
971 hr_utility.raise_error;
972 end if;
973 elsif p_effective_date > to_date('19'||'99/11/01','yyyy/mm/dd') then
974 if p_First_NOAC_Lookup_Code= '501'
975 and
976 NOT ( p_First_Action_NOA_LA_Code1 in
977 ('ABK','ABL','ABM','ACA','ACM','AYM','A2M',
978 'BAB','BAC','BAD','BAE','BYO',
979 'BBM','BDN','BLM','BNK','BNR', 'BNY',
980 'BNM','BNN','BWA','BWM',
981 'BYM','HAM','K1M','K7M','K8M','K9M','LBM',
982 'LEM','LHM','LJM','LKM','LKP','LLM','LPM',
983 'LSM','LYM','LZM','L1M','L2K','L3M','LYP','PNR',
984 'P5M','UDM','V1P','V8M','V8N','VGL','Z2U','Z2W',
985 'ZBA','ZGM','ZHK','ZJK','ZJM',
986 'ZLM','ZQM','ZRM','ZSK','ZSP','ZTU','ZTZ','Z5B','Z5C','Z5D','Z5E') AND
987 p_First_Action_NOA_LA_Code2 in
988 ('ABK','ABL','ABM','ACA','ACM','AYM','A2M',
989 'BAB','BAC','BAD','BAE','BYO',
990 'BBM','BDN','BLM','BNK','BNR', 'BNY',
991 'BNM','BNN','BWA','BWM',
992 'BYM','HAM','K1M','K7M','K8M','K9M','LBM',
993 'LEM','LHM','LJM','LKM','LKP','LLM','LPM',
994 'LSM','LYM','LZM','L1M','L2K','L3M','LYP','PNR',
995 'P5M','UDM','V1P','V8M','V8N','VGL','Z2U','Z2W',
996 'ZBA','ZGM','ZHK','ZJK','ZJM',
997 'ZLM','ZQM','ZRM','ZSK','ZSP','ZTU','ZTZ','Z5B','Z5C','Z5D','Z5E') ) THEN
998 hr_utility.set_message(8301, 'GHR_37289_ALL_PROCEDURE_FAIL');
999 hr_utility.raise_error;
1000 end if;
1001 elsif p_effective_date > to_date('19'||'99/01/31','yyyy/mm/dd') then
1002 if p_First_NOAC_Lookup_Code= '501'
1003 and
1004 NOT ( p_First_Action_NOA_LA_Code1 in
1005 ('ABK','ABL','ABM','ACA','ACM','AYM','A2M',
1006 'BAB','BAC','BAD','BAE','BYO',
1010 'LEM','LHM','LJM','LKM','LKP','LLM','LPM',
1007 'BBM','BDN','BLM','BNK','BNR', 'BNY',
1008 'BNM','BNN','BWA','BWM',
1009 'BYM','HAM','K1M','K7M','K8M','K9M','LBM',
1011 'LSM','LYM','LZM','L1M','L2K','L3M','LYP','PNR',
1012 'P5M','V1P','V8M','V8N','VGL','Z2U','Z2W','ZGM','ZHK','ZJK','ZJM',
1013 'ZBA','ZLM','ZQM','ZRM','ZSK','ZSP','ZTU','ZTZ','Z5B','Z5C','Z5D','Z5E') AND
1014 p_First_Action_NOA_LA_Code2 in
1015 ('ABK','ABL','ABM','ACA','ACM','AYM','A2M',
1016 'BAB','BAC','BAD','BAE','BYO',
1017 'BBM','BDN','BLM','BNK','BNR', 'BNY',
1018 'BNM','BNN','BWA','BWM',
1019 'BYM','HAM','K1M','K7M','K8M','K9M','LBM',
1020 'LEM','LHM','LJM','LKM','LKP','LLM','LPM',
1021 'LSM','LYM','LZM','L1M','L2K','L3M','LYP','PNR',
1022 'P5M','V1P','V8M','V8N','VGL','Z2U','Z2W','ZGM','ZHK','ZJK','ZJM',
1023 'ZBA','ZLM','ZQM','ZRM','ZSK','ZSP','ZTU','ZTZ','Z5B','Z5C','Z5D','Z5E') ) THEN
1024 hr_utility.set_message(8301, 'GHR_37045_ALL_PROCEDURE_FAIL');
1025 hr_utility.raise_error;
1026 end if;
1027 elsif p_effective_date >= to_date('19'||'99/01/01','yyyy/mm/dd') then
1028 if p_First_NOAC_Lookup_Code= '501'
1029 and
1030 NOT ( p_First_Action_NOA_LA_Code1 in
1031 ('ABK','ABL','ABM','ACA','ACM','AYM','A2M',
1032 'BAB','BAC','BAD','BAE','BYO',
1033 'BBM','BDN','BEA','BLM','BMC','BNE','BNK','BNR', 'BNY',
1034 'BNM','BNN','BNW','BRM','BWA','BWM',
1035 'BYM','HAM','K1M','K7M','K8M','K9M','LBM',
1036 'LEM','LHM','LJM','LKM','LKP','LLM','LPM',
1037 'LSM','LYM','LZM','L1M','L2K','L3M','LYP','PNR',
1038 'P5M','V1P','V8M','V8N','VGL','Z2U','Z2W','ZGM','ZHK','ZJK','ZJM',
1039 'ZBA','ZLM','ZQM','ZRM','ZSK','ZSP','ZTU','ZTZ','Z5B','Z5C','Z5D','Z5E') AND
1040 p_First_Action_NOA_LA_Code2 in
1041 ('ABK','ABL','ABM','ACA','ACM','AYM','A2M',
1042 'BAB','BAC','BAD','BAE','BYO',
1043 'BBM','BDN','BEA','BLM','BMC','BNE','BNK','BNR', 'BNY',
1044 'BNM','BNN','BNW','BRM','BWA','BWM',
1045 'BYM','HAM','K1M','K7M','K8M','K9M','LBM',
1046 'LEM','LHM','LJM','LKM','LKP','LLM','LPM',
1047 'LSM','LYM','LZM','L1M','L2K','L3M','LYP','PNR',
1048 'P5M','V1P','V8M','V8N','VGL','Z2U','Z2W','ZGM','ZHK','ZJK','ZJM',
1049 'ZBA','ZLM','ZQM','ZRM','ZSK','ZSP','ZTU','ZTZ','Z5B','Z5C','Z5D','Z5E') ) THEN
1050 hr_utility.set_message(8301, 'GHR_37084_ALL_PROCEDURE_FAIL');
1051 hr_utility.raise_error;
1052 end if;
1053 else
1054 if p_First_NOAC_Lookup_Code= '501'
1055 and
1056 NOT ( p_First_Action_NOA_LA_Code1 in
1057 ('ABK','ABL','ABM','ACA','ACM','AYM','A2M',
1058 'BAB','BAC','BAD','BAE','BYO',
1059 'BBM','BDN','BEA','BLM','BMC','BNE','BNK','BNR', 'BNY',
1060 'BNM','BNN','BNW','BRM','BWA','BWM',
1061 'BYM','HAM','K1M','K7M','K8M','K9M','LBM',
1062 'LEM','LHM','LJM','LKM','LKP','LLM','LPM',
1063 'LSM','LYM','LZM','L1M','L2K','L3M','LYP','PNR',
1064 'P5M','V1P','V8M','V8N','Z2U','Z2W','ZGM','ZHK','ZJK','ZJM',
1065 'ZBA','ZLM','ZQM','ZRM','ZSK','ZSP','ZTU','ZTZ','Z5B','Z5C','Z5D','Z5E') AND
1066 p_First_Action_NOA_LA_Code2 in
1067 ('ABK','ABL','ABM','ACA','ACM','AYM','A2M',
1068 'BAB','BAC','BAD','BAE','BYO',
1069 'BBM','BDN','BEA','BLM','BMC','BNE','BNK','BNR','BNY',
1070 'BNM','BNN','BNW','BRM','BWA','BWM',
1071 'BYM','HAM','K1M','K7M','K8M','K9M','LBM',
1072 'LEM','LHM','LJM','LKM','LKP','LLM','LPM',
1073 'LSM','LYM','LZM','L1M','L2K','L3M','LYP','PNR',
1074 'P5M','V1P','V8M','V8N','Z2U','Z2W','ZGM','ZHK','ZJK','ZJM',
1075 'ZBA','ZLM','ZQM','ZRM','ZSK','ZSP','ZTU','ZTZ','Z5B','Z5C','Z5D','Z5E') ) THEN
1076 hr_utility.set_message(8301, 'GHR_37370_ALL_PROCEDURE_FAIL');
1077 hr_utility.raise_error;
1078 end if;
1079
1080 end if;
1081
1082 -- END OF 325.05.2
1083 --
1084
1085 --325.17.2
1086 -- added 'Z2U' on 22-jul-1998
1087 -- Update/Change Date By Effective Date Comment
1088 -- 8/5 03/09/99 vravikan Add BWA
1089 -- 8/5 03/09/99 vravikan 02/27/99 Delete ACM
1090 --- Upd 56 13-Mar-09 Manish 17-Feb-2009 Added LA code ZEA
1091 --- Upd 57 30-Jul-09 Mani 01-Jan-2009 Added LA code BAG
1092
1093 if p_effective_date >= fnd_date.canonical_to_date('2009/02/17') then
1094 if p_First_NOAC_Lookup_Code= '507'
1095 and
1096 NOT ( p_First_Action_NOA_LA_Code1 in
1097 ('ABL','ABM','ABR','ABS','AYM','BAG','BWA','BWM',
1098 'HAM','HDM','HGM','HJM','HLM','NUM','PNR',
1099 'V1P','V8N','Z2U','ZLM','ZRM','ZSK','ZEA') AND
1100 p_First_Action_NOA_LA_Code2 in
1101 ('ABL','ABM','ABR','ABS','AYM','BAG','BWA','BWM',
1102 'HAM','HDM','HGM','HJM','HLM','NUM','PNR',
1103 'V1P','V8N','Z2U','ZLM','ZRM','ZSK','ZEA') ) THEN
1104 hr_utility.set_message(8301, 'GHR_37052_ALL_PROCEDURE_FAIL');
1105 hr_utility.set_message_token('LAC_CODE','ABL, ABM, ABR, ABS, BAG, BWM, BWA, HAM, HDM, HGM, HJM, HLM, NUM, PNR, V1P, V8N, Z2U, ZEA, ZLM, ZRM, ZSK.');
1106 hr_utility.raise_error;
1107 end if;
1108 elsif p_effective_date >= fnd_date.canonical_to_date('2009/01/01') then
1109 if p_First_NOAC_Lookup_Code= '507'
1110 and
1111 NOT ( p_First_Action_NOA_LA_Code1 in
1112 ('ABL','ABM','ABR','ABS','AYM','BAG','BWA','BWM',
1113 'HAM','HDM','HGM','HJM','HLM','NUM','PNR',
1114 'V1P','V8N','Z2U','ZLM','ZRM','ZSK') AND
1115 p_First_Action_NOA_LA_Code2 in
1116 ('ABL','ABM','ABR','ABS','AYM','BAG','BWA','BWM',
1117 'HAM','HDM','HGM','HJM','HLM','NUM','PNR',
1118 'V1P','V8N','Z2U','ZLM','ZRM','ZSK') ) THEN
1119 hr_utility.set_message(8301, 'GHR_37052_ALL_PROCEDURE_FAIL');
1123 elsif p_effective_date >= fnd_date.canonical_to_date('19'||'99/02/27') then
1120 hr_utility.set_message_token('LAC_CODE','ABL, ABM, ABR, ABS, BAG, BWM, BWA, HAM, HDM, HGM, HJM, HLM, NUM, PNR, V1P, V8N, Z2U, BAG, ZLM, ZRM, ZSK.');
1121 hr_utility.raise_error;
1122 end if;
1124 if p_First_NOAC_Lookup_Code= '507'
1125 and
1126 NOT ( p_First_Action_NOA_LA_Code1 in
1127 ('ABL','ABM','ABR','ABS','AYM','BWA','BWM',
1128 'HAM','HDM','HGM','HJM','HLM','NUM','PNR',
1129 'V1P','V8N','Z2U','ZLM','ZRM','ZSK') AND
1130 p_First_Action_NOA_LA_Code2 in
1131 ('ABL','ABM','ABR','ABS','AYM','BWA','BWM',
1132 'HAM','HDM','HGM','HJM','HLM','NUM','PNR',
1133 'V1P','V8N','Z2U','ZLM','ZRM','ZSK') ) THEN
1134 hr_utility.set_message(8301, 'GHR_37052_ALL_PROCEDURE_FAIL');
1135 hr_utility.set_message_token('LAC_CODE','ABL, ABM, ABR, ABS, BWM, BWA, HAM, HDM, HGM, HJM, HLM, NUM, PNR, V1P, V8N, Z2U, ZLM, ZRM, ZSK.');
1136 hr_utility.raise_error;
1137 end if;
1138 else
1139 if p_First_NOAC_Lookup_Code= '507'
1140 and
1141 NOT ( p_First_Action_NOA_LA_Code1 in
1142 ('ABL','ABM','ABR','ABS','ACM','AYM','BWA','BWM',
1143 'HAM','HDM','HGM','HJM','HLM','NUM','PNR',
1144 'V1P','V8N','Z2U','ZLM','ZRM','ZSK') AND
1145 p_First_Action_NOA_LA_Code2 in
1146 ('ABL','ABM','ABR','ABS','ACM','AYM','BWA','BWM',
1147 'HAM','HDM','HGM','HJM','HLM','NUM','PNR',
1148 'V1P','V8N','Z2U','ZLM','ZRM','ZSK') ) THEN
1149 hr_utility.set_message(8301, 'GHR_37371_ALL_PROCEDURE_FAIL');
1150 hr_utility.raise_error;
1151 end if;
1152 end if;
1153
1154
1155 --325.20.2
1156 -- added 'Z2U' on 22-jul-1998
1157 -- added 'Z2W' on 9-oct-98
1158 -- Update/Change Date By Effective Date Comment
1159 -- 8/5 03/09/99 vravikan 01/31/99 Delete BEA,BMC,BNE,BNW,BRM
1160 -- 8/5 03/09/99 vravikan Add ZTU
1161 -- 8/5 03/09/99 vravikan 02/27/99 Delete ACM,MLL,MCM
1162 -- 10/4 08/13/99 vravikan 01-Jan-99 Add VGL
1163 -- 11/9 12/14/99 vravikan 01-Nov-1999 Add UDM
1164 -- 10/30/03 Ashley From Begining Added BAB,BAC,BAD,BYO
1165 -- Upd 43 09-NOV-05 Raju From beginning Added BAE
1166 -- Upd 47 23-Jun-06 Raju From Begining Added Z5B, Z5C, Z5F, Z5H, Z5J
1167 -- upd49 19-Jan-07 Raju From Beginning Bug#5619873 add BAF
1168 -- Upd 54 12-Jun-07 vmididho From Begining delete BAF
1169 --- Upd 56 13-Mar-09 Manish 01-Jan-2009 Added LA code BAG
1170 --- Upd 56 13-Mar-09 Manish 17-Feb-2009 Added LA code ZEA
1171 -- Upd 57 30-Jul-09 Mani 01-Mar-2009 Removed Z5H
1172 -- Upd 57 30-Jul-09 Mani From Begining Added LA codde Z6L
1173 -- GPPA U51 14-Aug-09 Raju 11-Sep-2009 Added LDM(8799026)
1174 -- GPPA U59 31-Jul-12 Mani 10-Jul-12 Added LA Codes MAB, MAC, MAF, MAG
1175 -- GPPA U61 07-Feb-13 Raju 06-Jan-13 Removed LA Code MAG bug# 16217492
1176 --BUG # 16217492
1177 if p_effective_date > to_date('2013/01/06','yyyy/mm/dd') then
1178 if p_First_NOAC_Lookup_Code= '508' and
1179 NOT ( p_First_Action_NOA_LA_Code1 in
1180 ('ABK','ABL','ABM','ABR','ABS','AYM',
1181 'BAB','BAC','BAD','BAE','BAG','BYO',
1182 'BWA','BWM','HAM','LDM','MAB', 'MAC', 'MAF', 'MEM','MGM','MJM','MLK',
1183 'MLM','MMM','NMM','NUM','PNR','UDM','VJM',
1184 'V1P','V8N','VGL','Z2U','Z2W','ZJK','ZJM','ZLM',
1185 'ZQM','ZRM','ZSK','ZSP','ZTU','ZTZ','Z5B','Z5C','Z5F','Z5J','ZEA','Z6L') AND
1186 p_First_Action_NOA_LA_Code2 in
1187 ('ABK','ABL','ABM','ABR','ABS','AYM',
1188 'BAB','BAC','BAD','BAE','BAG','BYO',
1189 'BWA','BWM','HAM','LDM','MAB', 'MAC', 'MAF', 'MEM','MGM','MJM','MLK',
1190 'MLM','MMM','NMM','NUM','PNR','UDM','VJM',
1191 'V1P','V8N','VGL','Z2U','Z2W','ZJK','ZJM','ZLM',
1192 'ZQM','ZRM','ZSK','ZSP','ZTU','ZTZ','Z5B','Z5C','Z5F','Z5J','ZEA','Z6L') ) THEN
1193 hr_utility.set_message(8301, 'GHR_37290_ALL_PROCEDURE_FAIL');
1194 hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ABR, ABS, AYM, BWM, BAB, BAC, BAD, BAE, BAG, BYO,
1195 BWA, BWM, HAM, LDM, MAB, MAC, MAF, MEM, MGM, MJM, MLK, MLM, MMM, NMM, NUM, PNR, UDM, VJM, V1P, V8N, VGL, Z2U, Z2W,
1196 ZEA, ZJK, ZJM, ZLM, ZQM, ZRM, ZSK, ZSP, ZTU, ZTZ, Z5B, Z5C, Z5F, Z5J, Z6L.');
1197 hr_utility.raise_error;
1198 end if;
1199 --BUG # 16217492
1200 --BUG # 14395108
1201 elsif p_effective_date >= to_date('2012/07/10','yyyy/mm/dd') then
1202 if p_First_NOAC_Lookup_Code= '508' and
1203 NOT ( p_First_Action_NOA_LA_Code1 in
1204 ('ABK','ABL','ABM','ABR','ABS','AYM',
1205 'BAB','BAC','BAD','BAE','BAG','BYO',
1206 'BWA','BWM','HAM','LDM','MAB', 'MAC', 'MAF', 'MAG','MEM','MGM','MJM','MLK',
1207 'MLM','MMM','NMM','NUM','PNR','UDM','VJM',
1208 'V1P','V8N','VGL','Z2U','Z2W','ZJK','ZJM','ZLM',
1209 'ZQM','ZRM','ZSK','ZSP','ZTU','ZTZ','Z5B','Z5C','Z5F','Z5J','ZEA','Z6L') AND
1210 p_First_Action_NOA_LA_Code2 in
1211 ('ABK','ABL','ABM','ABR','ABS','AYM',
1212 'BAB','BAC','BAD','BAE','BAG','BYO',
1213 'BWA','BWM','HAM','LDM','MAB', 'MAC', 'MAF', 'MAG','MEM','MGM','MJM','MLK',
1214 'MLM','MMM','NMM','NUM','PNR','UDM','VJM',
1215 'V1P','V8N','VGL','Z2U','Z2W','ZJK','ZJM','ZLM',
1216 'ZQM','ZRM','ZSK','ZSP','ZTU','ZTZ','Z5B','Z5C','Z5F','Z5J','ZEA','Z6L') ) THEN
1217 hr_utility.set_message(8301, 'GHR_37290_ALL_PROCEDURE_FAIL');
1218 hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ABR, ABS, AYM, BWM, BAB, BAC, BAD, BAE, BAG, BYO,
1219 BWA, BWM, HAM, LDM, MAB, MAC, MAF, MAG, MEM, MGM, MJM, MLK, MLM, MMM, NMM, NUM, PNR, UDM, VJM, V1P, V8N, VGL, Z2U, Z2W,
1223 --BUG # 14395108
1220 ZEA, ZJK, ZJM, ZLM, ZQM, ZRM, ZSK, ZSP, ZTU, ZTZ, Z5B, Z5C, Z5F, Z5J, Z6L.');
1221 hr_utility.raise_error;
1222 end if;
1224 --Begin Bug# 8799026
1225 elsif p_effective_date >= to_date('2009/09/11','yyyy/mm/dd') then
1226 if p_First_NOAC_Lookup_Code= '508' and
1227 NOT ( p_First_Action_NOA_LA_Code1 in
1228 ('ABK','ABL','ABM','ABR','ABS','AYM',
1229 'BAB','BAC','BAD','BAE','BAG','BYO',
1230 'BWA','BWM','HAM','LDM','MEM','MGM','MJM','MLK',
1231 'MLM','MMM','NMM','NUM','PNR','UDM','VJM',
1232 'V1P','V8N','VGL','Z2U','Z2W','ZJK','ZJM','ZLM',
1233 'ZQM','ZRM','ZSK','ZSP','ZTU','ZTZ','Z5B','Z5C','Z5F','Z5J','ZEA','Z6L') AND
1234 p_First_Action_NOA_LA_Code2 in
1235 ('ABK','ABL','ABM','ABR','ABS','AYM',
1236 'BAB','BAC','BAD','BAE','BAG','BYO',
1237 'BWA','BWM','HAM','LDM','MEM','MGM','MJM','MLK',
1238 'MLM','MMM','NMM','NUM','PNR','UDM','VJM',
1239 'V1P','V8N','VGL','Z2U','Z2W','ZJK','ZJM','ZLM',
1240 'ZQM','ZRM','ZSK','ZSP','ZTU','ZTZ','Z5B','Z5C','Z5F','Z5J','ZEA','Z6L') ) THEN
1241 hr_utility.set_message(8301, 'GHR_37290_ALL_PROCEDURE_FAIL');
1242 hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ABR, ABS, AYM, BWM,BAB,BAC,BAD, BAE, BAG, BYO,
1243 BWA, BWM, HAM, LDM, MEM, MGM, MJM, MLK, MLM, MMM, NMM, NUM, PNR, UDM, VJM, V1P, V8N, VGL, Z2U, Z2W, ZEA, ZJK,
1244 ZJM, ZLM, ZQM, ZRM, ZSK, ZSP, ZTU, ZTZ,Z5B, Z5C, Z5F, Z5J, Z6L.');
1245 hr_utility.raise_error;
1246 end if;
1247 --End Bug# 8799026
1248 elsif p_effective_date >= to_date('2009/03/01','yyyy/mm/dd') then
1249 if p_First_NOAC_Lookup_Code= '508'
1250 and
1251 NOT ( p_First_Action_NOA_LA_Code1 in
1252 ('ABK','ABL','ABM','ABR','ABS','AYM',
1253 'BAB','BAC','BAD','BAE','BAG','BYO',
1254 'BWA','BWM','HAM','MEM','MGM','MJM','MLK',
1255 'MLM','MMM','NMM','NUM','PNR','UDM','VJM',
1256 'V1P','V8N','VGL','Z2U','Z2W','ZJK','ZJM','ZLM',
1257 'ZQM','ZRM','ZSK','ZSP','ZTU','ZTZ','Z5B','Z5C','Z5F','Z5J','ZEA','Z6L') AND
1258 p_First_Action_NOA_LA_Code2 in
1259 ('ABK','ABL','ABM','ABR','ABS','AYM',
1260 'BAB','BAC','BAD','BAE','BAG','BYO',
1261 'BWA','BWM','HAM','MEM','MGM','MJM','MLK',
1262 'MLM','MMM','NMM','NUM','PNR','UDM','VJM',
1263 'V1P','V8N','VGL','Z2U','Z2W','ZJK','ZJM','ZLM',
1264 'ZQM','ZRM','ZSK','ZSP','ZTU','ZTZ','Z5B','Z5C','Z5F','Z5J','ZEA','Z6L') ) THEN
1265 hr_utility.set_message(8301, 'GHR_37290_ALL_PROCEDURE_FAIL');
1266 hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ABR, ABS, AYM, BWM,BAB,BAC,BAD, BAE, BAG, BYO,
1267 BWA, BWM, HAM, MEM, MGM, MJM, MLK, MLM, MMM, NMM, NUM, PNR, UDM, VJM, V1P, V8N, VGL, Z2U, Z2W, ZEA, ZJK,
1268 ZJM, ZLM, ZQM, ZRM, ZSK, ZSP, ZTU, ZTZ,Z5B, Z5C, Z5F, Z5J, Z6L.');
1269 hr_utility.raise_error;
1270 end if;
1271 elsif p_effective_date >= to_date('2009/02/17','yyyy/mm/dd') then
1272 if p_First_NOAC_Lookup_Code= '508'
1273 and
1274 NOT ( p_First_Action_NOA_LA_Code1 in
1275 ('ABK','ABL','ABM','ABR','ABS','AYM',
1276 'BAB','BAC','BAD','BAE','BAG','BYO',
1277 'BWA','BWM','HAM','MEM','MGM','MJM','MLK',
1278 'MLM','MMM','NMM','NUM','PNR','UDM','VJM',
1279 'V1P','V8N','VGL','Z2U','Z2W','ZJK','ZJM','ZLM',
1280 'ZQM','ZRM','ZSK','ZSP','ZTU','ZTZ','Z5B','Z5C','Z5F','Z5H','Z5J','ZEA','Z6L') AND
1281 p_First_Action_NOA_LA_Code2 in
1282 ('ABK','ABL','ABM','ABR','ABS','AYM',
1283 'BAB','BAC','BAD','BAE','BAG','BYO',
1284 'BWA','BWM','HAM','MEM','MGM','MJM','MLK',
1285 'MLM','MMM','NMM','NUM','PNR','UDM','VJM',
1286 'V1P','V8N','VGL','Z2U','Z2W','ZJK','ZJM','ZLM',
1287 'ZQM','ZRM','ZSK','ZSP','ZTU','ZTZ','Z5B','Z5C','Z5F','Z5H','Z5J','ZEA','Z6L') ) THEN
1288 hr_utility.set_message(8301, 'GHR_37290_ALL_PROCEDURE_FAIL');
1289 hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ABR, ABS, AYM, BWM,BAB,BAC,BAD, BAE, BAG, BYO,
1290 BWA, BWM, HAM, MEM, MGM, MJM, MLK, MLM, MMM, NMM, NUM, PNR, UDM, VJM, V1P, V8N, VGL, Z2U, Z2W, ZEA, ZJK,
1291 ZJM, ZLM, ZQM, ZRM, ZSK, ZSP, ZTU, ZTZ,Z5B, Z5C, Z5F, Z5H, Z5J, Z6L.');
1292 hr_utility.raise_error;
1293 end if;
1294 elsif p_effective_date >= to_date('2009/01/01','yyyy/mm/dd') then
1295 if p_First_NOAC_Lookup_Code= '508'
1296 and
1297 NOT ( p_First_Action_NOA_LA_Code1 in
1298 ('ABK','ABL','ABM','ABR','ABS','AYM',
1299 'BAB','BAC','BAD','BAE','BAG','BYO',
1300 'BWA','BWM','HAM','MEM','MGM','MJM','MLK',
1301 'MLM','MMM','NMM','NUM','PNR','UDM','VJM',
1302 'V1P','V8N','VGL','Z2U','Z2W','ZJK','ZJM','ZLM',
1303 'ZQM','ZRM','ZSK','ZSP','ZTU','ZTZ','Z5B','Z5C','Z5F','Z5H','Z5J','Z6L') AND
1304 p_First_Action_NOA_LA_Code2 in
1305 ('ABK','ABL','ABM','ABR','ABS','AYM',
1306 'BAB','BAC','BAD','BAE','BAG','BYO',
1307 'BWA','BWM','HAM','MEM','MGM','MJM','MLK',
1308 'MLM','MMM','NMM','NUM','PNR','UDM','VJM',
1309 'V1P','V8N','VGL','Z2U','Z2W','ZJK','ZJM','ZLM',
1310 'ZQM','ZRM','ZSK','ZSP','ZTU','ZTZ','Z5B','Z5C','Z5F','Z5H','Z5J','Z6L') ) THEN
1311 hr_utility.set_message(8301, 'GHR_37290_ALL_PROCEDURE_FAIL');
1312 hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ABR, ABS, AYM, BWM,BAB,BAC,BAD, BAE, BAG, BYO,
1313 BWA, BWM, HAM, MEM, MGM, MJM, MLK, MLM, MMM, NMM, NUM, PNR, UDM, VJM, V1P, V8N, VGL, Z2U, Z2W, ZJK, ZJM,
1314 ZLM, ZQM, ZRM, ZSK, ZSP, ZTU, ZTZ,Z5B, Z5C, Z5F, Z5H, Z5J, Z6L.');
1315 hr_utility.raise_error;
1316 end if;
1317 elsif p_effective_date >= to_date('19'||'99/11/01','yyyy/mm/dd') then
1318 if p_First_NOAC_Lookup_Code= '508'
1319 and
1320 NOT ( p_First_Action_NOA_LA_Code1 in
1321 ('ABK','ABL','ABM','ABR','ABS','AYM',
1322 'BAB','BAC','BAD','BAE','BYO',
1323 'BWA','BWM','HAM','MEM','MGM','MJM','MLK',
1324 'MLM','MMM','NMM','NUM','PNR','UDM','VJM',
1328 ('ABK','ABL','ABM','ABR','ABS','AYM',
1325 'V1P','V8N','VGL','Z2U','Z2W','ZJK','ZJM','ZLM',
1326 'ZQM','ZRM','ZSK','ZSP','ZTU','ZTZ','Z5B','Z5C','Z5F','Z5H','Z5J','Z6L') AND
1327 p_First_Action_NOA_LA_Code2 in
1329 'BAB','BAC','BAD','BAE','BYO',
1330 'BWA','BWM','HAM','MEM','MGM','MJM','MLK',
1331 'MLM','MMM','NMM','NUM','PNR','UDM','VJM',
1332 'V1P','V8N','VGL','Z2U','Z2W','ZJK','ZJM','ZLM',
1333 'ZQM','ZRM','ZSK','ZSP','ZTU','ZTZ','Z5B','Z5C','Z5F','Z5H','Z5J','Z6L') ) THEN
1334 hr_utility.set_message(8301, 'GHR_37290_ALL_PROCEDURE_FAIL');
1335 hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ABR, ABS, AYM, BWM,BAB,BAC,BAD, BAE,BYO, BWA, BWM,
1336 HAM, MEM, MGM, MJM, MLK, MLM, MMM, NMM, NUM, PNR, UDM, VJM, V1P, V8N, VGL, Z2U, Z2W, ZJK, ZJM, ZLM, ZQM,
1337 ZRM, ZSK, ZSP, ZTU, ZTZ,Z5B, Z5C, Z5F, Z5H, Z5J, Z6L.');
1338 hr_utility.raise_error;
1339 end if;
1340 elsif p_effective_date >= to_date('19'||'99/02/27','yyyy/mm/dd') then
1341 if p_First_NOAC_Lookup_Code= '508'
1342 and
1343 NOT ( p_First_Action_NOA_LA_Code1 in
1344 ('ABK','ABL','ABM','ABR','ABS','AYM',
1345 'BAB','BAC','BAD','BAE','BYO',
1346 'BWA','BWM','HAM','MEM','MGM','MJM','MLK',
1347 'MLM','MMM','NMM','NUM','PNR','VJM',
1348 'V1P','V8N','VGL','Z2U','Z2W','ZJK','ZJM','ZLM',
1349 'ZQM','ZRM','ZSK','ZSP','ZTU','ZTZ','Z5B','Z5C','Z5F','Z5H','Z5J','Z6L') AND
1350 p_First_Action_NOA_LA_Code2 in
1351 ('ABK','ABL','ABM','ABR','ABS','AYM',
1352 'BAB','BAC','BAD','BAE','BYO',
1353 'BWA','BWM','HAM','MEM','MGM','MJM','MLK',
1354 'MLM','MMM','NMM','NUM','PNR','VJM',
1355 'V1P','V8N','VGL','Z2U','Z2W','ZJK','ZJM','ZLM',
1356 'ZQM','ZRM','ZSK','ZSP','ZTU','ZTZ','Z5B','Z5C','Z5F','Z5H','Z5J','Z6L') ) THEN
1357 hr_utility.set_message(8301, 'GHR_37053_ALL_PROCEDURE_FAIL');
1358 hr_utility.raise_error;
1359 end if;
1360 elsif p_effective_date > to_date('19'||'99/01/31','yyyy/mm/dd') then
1361 if p_First_NOAC_Lookup_Code= '508'
1362 and
1363 NOT ( p_First_Action_NOA_LA_Code1 in
1364 ('ABK','ABL','ABM','ABR','ABS','ACM','AYM',
1365 'BAB','BAC','BAD','BAE','BYO',
1366 'BWA','BWM','HAM','MCM','MEM','MGM','MJM','MLK',
1367 'MLL','MLM','MMM','NMM','NUM','PNR','VJM',
1368 'V1P','V8N','VGL','Z2U','Z2W','ZJK','ZJM','ZLM',
1369 'ZQM','ZRM','ZSK','ZSP','ZTU','ZTZ','Z5B','Z5C','Z5F','Z5H','Z5J','Z6L') AND
1370 p_First_Action_NOA_LA_Code2 in
1371 ('ABK','ABL','ABM','ABR','ABS','ACM','AYM',
1372 'BAB','BAC','BAD','BAE','BYO',
1373 'BWA','BWM','HAM','MCM','MEM','MGM','MJM','MLK',
1374 'MLL','MLM','MMM','NMM','NUM','PNR','VJM',
1375 'V1P','V8N','VGL','Z2U','Z2W','ZJK','ZJM','ZLM',
1376 'ZQM','ZRM','ZSK','ZSP','ZTU','ZTZ','Z5B','Z5C','Z5F','Z5H','Z5J','Z6L') ) THEN
1377 hr_utility.set_message(8301, 'GHR_37046_ALL_PROCEDURE_FAIL');
1378 hr_utility.raise_error;
1379 end if;
1380 elsif p_effective_date >= to_date('19'||'99/01/01','yyyy/mm/dd') then
1381 if p_First_NOAC_Lookup_Code= '508'
1382 and
1383 NOT ( p_First_Action_NOA_LA_Code1 in
1384 ('ABK','ABL','ABM','ABR','ABS','ACM','AYM',
1385 'BAB','BAC','BAD','BAE','BYO',
1386 'BEA','BMC','BNE','BNW','BRM','BWA',
1387 'BWM','HAM','MCM','MEM','MGM','MJM','MLK',
1388 'MLL','MLM','MMM','NMM','NUM','PNR','VJM',
1389 'V1P','V8N','VGL','Z2U','Z2W','ZJK','ZJM','ZLM',
1390 'ZQM','ZRM','ZSK','ZSP','ZTU','ZTZ','Z5B','Z5C','Z5F','Z5H','Z5J','Z6L') AND
1391 p_First_Action_NOA_LA_Code2 in
1392 ('ABK','ABL','ABM','ABR','ABS','ACM','AYM',
1393 'BAB','BAC','BAD','BAE','BYO',
1394 'BEA','BMC','BNE','BNW','BRM','BWA',
1395 'BWM','HAM','MCM','MEM','MGM','MJM','MLK',
1396 'MLL','MLM','MMM','NMM','NUM','PNR','VJM',
1397 'V1P','V8N','VGL','Z2U','Z2W','ZJK','ZJM','ZLM',
1398 'ZQM','ZRM','ZSK','ZSP','ZTU','ZTZ','Z5B','Z5C','Z5F','Z5H','Z5J','Z6L') ) THEN
1399 hr_utility.set_message(8301, 'GHR_37099_ALL_PROCEDURE_FAIL');
1400 hr_utility.raise_error;
1401 end if;
1402
1403 else
1404 if p_First_NOAC_Lookup_Code= '508'
1405 and
1406 NOT ( p_First_Action_NOA_LA_Code1 in
1407 ('ABK','ABL','ABM','ABR','ABS','ACM','AYM',
1408 'BAB','BAC','BAD','BAE','BYO',
1409 'BEA','BMC','BNE','BNW','BRM','BWA',
1410 'BWM','HAM','MCM','MEM','MGM','MJM','MLK',
1411 'MLL','MLM','MMM','NMM','NUM','PNR','VJM',
1412 'V1P','V8N','Z2U','Z2W','ZJK','ZJM','ZLM',
1413 'ZQM','ZRM','ZSK','ZSP','ZTU','ZTZ','Z5B','Z5C','Z5F','Z5H','Z5J','Z6L') AND
1414 p_First_Action_NOA_LA_Code2 in
1415 ('ABK','ABL','ABM','ABR','ABS','ACM','AYM',
1416 'BAB','BAC','BAD','BAE','BYO',
1417 'BEA','BMC','BNE','BNW','BRM','BWA',
1418 'BWM','HAM','MCM','MEM','MGM','MJM','MLK',
1419 'MLL','MLM','MMM','NMM','NUM','PNR','VJM',
1420 'V1P','V8N','Z2U','Z2W','ZJK','ZJM','ZLM',
1421 'ZQM','ZRM','ZSK','ZSP','ZTU','ZTZ','Z5B','Z5C','Z5F','Z5H','Z5J','Z6L') ) THEN
1422 hr_utility.set_message(8301, 'GHR_37372_ALL_PROCEDURE_FAIL');
1423 hr_utility.raise_error;
1424 end if;
1425 end if;
1426
1427 --325.23.2
1428 -- added 'Z2U' on 22-jul-1998
1429 -- UPDATE/CHANGE DATE UPDATED BY EFFECTIVE_DATE COMMENTS
1430 -------------------------------------------------------------------------------------
1431 -- 10/4 08/13/99 vravikan 01-Jan-99 Add VGL
1432 -- 14-SEP-2004 Madhuri
1433 -------------------------------------------------------------------------------------
1434 IF ( p_effective_date <= to_date('20'||'04/08/31','yyyy/mm/dd') ) THEN
1435
1436 IF p_effective_date >= fnd_date.canonical_to_date('19'||'99/01/01') then
1437 if p_First_NOAC_Lookup_Code= '512'
1438 and
1442 'Z2U','ZLM','ZRM','ZSK','ZSP','ZTU') AND
1439 NOT ( p_First_Action_NOA_LA_Code1 in
1440 ('ABL','ABM','AYM','BWM','HAM',
1441 'MAM','MBM','PNR','V1P','V8N','VGL',
1443 p_First_Action_NOA_LA_Code2 in
1444 ('ABL','ABM','AYM','BWM','HAM',
1445 'MAM','MBM','PNR','V1P','V8N','VGL',
1446 'Z2U','ZLM','ZRM','ZSK','ZSP','ZTU') ) THEN
1447 hr_utility.set_message(8301, 'GHR_37100_ALL_PROCEDURE_FAIL');
1448 hr_utility.raise_error;
1449 end if;
1450 ELSE
1451 if p_First_NOAC_Lookup_Code= '512'
1452 and
1453 NOT ( p_First_Action_NOA_LA_Code1 in
1454 ('ABL','ABM','AYM','BWM','HAM',
1455 'MAM','MBM','PNR','V1P','V8N',
1456 'Z2U','ZLM','ZRM','ZSK','ZSP','ZTU') AND
1457 p_First_Action_NOA_LA_Code2 in
1458 ('ABL','ABM','AYM','BWM','HAM',
1459 'MAM','MBM','PNR','V1P','V8N',
1460 'Z2U','ZLM','ZRM','ZSK','ZSP','ZTU') ) THEN
1461 hr_utility.set_message(8301, 'GHR_37373_ALL_PROCEDURE_FAIL');
1462 hr_utility.raise_error;
1463 end if;
1464 END IF;
1465
1466 END IF; -- END DATE CHECK
1467
1468 --325.26.2
1469 -- added 'Z2U' on 22-jul-1998
1470 -- added 'Z2W' on 12-oct-1998
1471 -- Update Date By Effective Date Bug Comment
1472 -- 8 03/09/99 vravikan 01/31/99 Delete BEA,BMC,BNE,BNW,BRM
1473 -- 8 03/09/99 vravikan 02/27/99 Delete ACM,NEL,MXM,CTM
1474 -- 8 04/22/99 vravikan 02/27/99 871385 Add CTM,MXM
1475 -- 10/4 08/13/99 vravikan 01-Jan-99 Add VGL
1476 -- 9/3 09/15/99 vravikan 27-Feb-99 992944 Delete CTM,MXM
1477 -- 11/17/99 AVR 27-Feb-99 1079338 Add MXM
1478 -- 11/9 12/14/99 vravikan 01-Nov-1999 Add UDM
1479 -- 10/30/03 Ashley From Begining Added BAB,BAC,BAD,BYO
1480 -- Upd 43 09-NOV-05 Raju From beginning Added BAE
1481 -- Upd 47 23-Jun-06 Raju From Begining Added Z5B, Z5C, Z5F, Z5G, Z5H
1482 -- upd49 19-Jan-07 Raju From Beginning Bug#5619873 add BAF,WTA,WTB,WUM
1483 -- Upd 54 12-Jun-07 vmididho From Begining delete BAF
1484 --- Upd 56 13-Mar-09 Manish 01-Jan-2009 Added LA code BAG
1485 --- Upd 56 13-Mar-09 Manish 17-Feb-2009 Added LA code ZEA
1486 -- GPPA U51 14-Aug-09 Raju 11-Sep-2009 Added LCM(8799026)
1487 -- GPPA U59 28-Oct-10 Raju 11-Sep-2009 Removed WTA,WTB,WUM(10189715)
1488
1489 --Begin Bug# 8799026
1490 if p_effective_date >= to_date('2009/09/11','yyyy/mm/dd') then
1491 if p_First_NOAC_Lookup_Code= '515'
1492 and
1493 NOT ( p_First_Action_NOA_LA_Code1 in
1494 ('ABL','ABM','ABR','ABS','AYM',
1495 'BAB','BAC','BAD','BAE','BAG','BYO','BNM','BWA','BWM',
1496 'HAM','KLM','LCM','MXM','M6M','M8M',
1497 'NAM','NCM','NEM','NMM','NUM','PNR',
1498 'SZX','UDM','VGL','VJM','V1P','V8L',
1499 'V8N','Z2U','Z2W','ZJK',
1500 'ZLM','ZQM','ZRM','ZSK','ZSP','ZTM','ZTU','Z5B','Z5C','Z5F','Z5G','Z5H','ZEA') AND
1501 p_First_Action_NOA_LA_Code2 in
1502 ('ABL','ABM','ABR','ABS','AYM',
1503 'BAB','BAC','BAD','BAE','BAG','BYO','BNM','BWA','BWM',
1504 'HAM','KLM','LCM','MXM','M6M','M8M',
1505 'NAM','NCM','NEM','NMM','NUM','PNR',
1506 'SZX','UDM','VGL','VJM','V1P','V8L',
1507 'V8N','Z2U','Z2W','ZJK',
1508 'ZLM','ZQM','ZRM','ZSK','ZSP','ZTM','ZTU','Z5B','Z5C','Z5F','Z5G','Z5H','ZEA') ) THEN
1509 hr_utility.set_message(8301, 'GHR_37291_ALL_PROCEDURE_FAIL');
1510 hr_utility.set_message_token('LAC_CODE','ABL, ABM, ABR, ABS, AYM, BWA, BWM, BAB, BAC, BAD, BAE, BAG, BYO,
1511 BWM, HAM, LCM, KLM, MXM, M6M,M8M, NAM, NCM, NEM, NMM, NUM, PNR, SZX, UDM, VJM, V1P, V8L, V8N, VGL,
1512 Z2U, Z2W, ZEA, ZJK, ZLM, ZQM, ZRM, ZSK, ZSP, ZTM, ZTU,Z5B, Z5C, Z5F, Z5G, Z5H.');
1513 hr_utility.raise_error;
1514 end if;
1515 --End Bug# 8799026
1516 elsif p_effective_date >= to_date('2009/02/17','yyyy/mm/dd') then
1517 if p_First_NOAC_Lookup_Code= '515'
1518 and
1519 NOT ( p_First_Action_NOA_LA_Code1 in
1520 ('ABL','ABM','ABR','ABS','AYM',
1521 'BAB','BAC','BAD','BAE','BAG','BYO','BNM','BWA','BWM',
1522 'HAM','KLM','MXM','M6M','M8M',
1523 'NAM','NCM','NEM','NMM','NUM','PNR',
1524 'SZX','UDM','VGL','VJM','V1P','V8L',
1525 'V8N','Z2U','Z2W','ZJK',
1526 'ZLM','ZQM','ZRM','ZSK','ZSP','ZTM','ZTU','Z5B','Z5C','Z5F','Z5G','Z5H','ZEA') AND
1527 p_First_Action_NOA_LA_Code2 in
1528 ('ABL','ABM','ABR','ABS','AYM',
1529 'BAB','BAC','BAD','BAE','BAG','BYO','BNM','BWA','BWM',
1530 'HAM','KLM','MXM','M6M','M8M',
1531 'NAM','NCM','NEM','NMM','NUM','PNR',
1532 'SZX','UDM','VGL','VJM','V1P','V8L',
1533 'V8N','Z2U','Z2W','ZJK',
1534 'ZLM','ZQM','ZRM','ZSK','ZSP','ZTM','ZTU','Z5B','Z5C','Z5F','Z5G','Z5H','ZEA') ) THEN
1535 hr_utility.set_message(8301, 'GHR_37291_ALL_PROCEDURE_FAIL');
1536 hr_utility.set_message_token('LAC_CODE','ABL, ABM, ABR, ABS, AYM, BWA, BWM, BAB, BAC, BAD, BAE, BAG, BYO,
1537 BWM, HAM, KLM, MXM, M6M,M8M, NAM, NCM, NEM, NMM, NUM, PNR, SZX, UDM, VJM, V1P, V8L, V8N, VGL,
1538 Z2U, Z2W, ZEA, ZJK, ZLM, ZQM, ZRM, ZSK, ZSP, ZTM, ZTU,Z5B, Z5C, Z5F, Z5G, Z5H.');
1539 hr_utility.raise_error;
1540 end if;
1541 elsif p_effective_date >= to_date('2009/01/01','yyyy/mm/dd') then
1542 if p_First_NOAC_Lookup_Code= '515'
1543 and
1544 NOT ( p_First_Action_NOA_LA_Code1 in
1545 ('ABL','ABM','ABR','ABS','AYM',
1546 'BAB','BAC','BAD','BAE','BAG','BYO','BNM','BWA','BWM',
1547 'HAM','KLM','MXM','M6M','M8M',
1548 'NAM','NCM','NEM','NMM','NUM','PNR',
1549 'SZX','UDM','VGL','VJM','V1P','V8L',
1550 'V8N','Z2U','Z2W','ZJK',
1554 'BAB','BAC','BAD','BAE','BAG','BYO','BNM','BWA','BWM',
1551 'ZLM','ZQM','ZRM','ZSK','ZSP','ZTM','ZTU','Z5B','Z5C','Z5F','Z5G','Z5H') AND
1552 p_First_Action_NOA_LA_Code2 in
1553 ('ABL','ABM','ABR','ABS','AYM',
1555 'HAM','KLM','MXM','M6M','M8M',
1556 'NAM','NCM','NEM','NMM','NUM','PNR',
1557 'SZX','UDM','VGL','VJM','V1P','V8L',
1558 'V8N','Z2U','Z2W','ZJK',
1559 'ZLM','ZQM','ZRM','ZSK','ZSP','ZTM','ZTU','Z5B','Z5C','Z5F','Z5G','Z5H') ) THEN
1560 hr_utility.set_message(8301, 'GHR_37291_ALL_PROCEDURE_FAIL');
1561 hr_utility.set_message_token('LAC_CODE','ABL, ABM, ABR, ABS, AYM, BWA, BWM, BAB, BAC, BAD, BAE, BAG, BYO,
1562 BWM, HAM, KLM, MXM, M6M,M8M, NAM, NCM, NEM, NMM, NUM, PNR, SZX, UDM, VJM, V1P, V8L, V8N, VGL,
1563 Z2U, Z2W, ZJK, ZLM, ZQM, ZRM, ZSK, ZSP, ZTM, ZTU,Z5B, Z5C, Z5F, Z5G, Z5H.');
1564 hr_utility.raise_error;
1565 end if;
1566 elsif p_effective_date >= to_date('19'||'99/11/01','yyyy/mm/dd') then
1567 if p_First_NOAC_Lookup_Code= '515'
1568 and
1569 NOT ( p_First_Action_NOA_LA_Code1 in
1570 ('ABL','ABM','ABR','ABS','AYM',
1571 'BAB','BAC','BAD','BAE','BYO','BNM','BWA','BWM',
1572 'HAM','KLM','MXM','M6M','M8M',
1573 'NAM','NCM','NEM','NMM','NUM','PNR',
1574 'SZX','UDM','VGL','VJM','V1P','V8L',
1575 'V8N','Z2U','Z2W','ZJK',
1576 'ZLM','ZQM','ZRM','ZSK','ZSP','ZTM','ZTU','Z5B','Z5C','Z5F','Z5G','Z5H') AND
1577 p_First_Action_NOA_LA_Code2 in
1578 ('ABL','ABM','ABR','ABS','AYM',
1579 'BAB','BAC','BAD','BAE','BYO','BNM','BWA','BWM',
1580 'HAM','KLM','MXM','M6M','M8M',
1581 'NAM','NCM','NEM','NMM','NUM','PNR',
1582 'SZX','UDM','VGL','VJM','V1P','V8L',
1583 'V8N','Z2U','Z2W','ZJK',
1584 'ZLM','ZQM','ZRM','ZSK','ZSP','ZTM','ZTU','Z5B','Z5C','Z5F','Z5G','Z5H') ) THEN
1585 hr_utility.set_message(8301, 'GHR_37291_ALL_PROCEDURE_FAIL');
1586 hr_utility.set_message_token('LAC_CODE','ABL, ABM, ABR, ABS, AYM, BWA, BWM, BAB, BAC, BAD, BAE, BYO, BWM,
1587 HAM, KLM, MXM, M6M,M8M, NAM, NCM, NEM, NMM, NUM, PNR, SZX, UDM, VJM, V1P, V8L, V8N, VGL,
1588 Z2U, Z2W, ZJK, ZLM, ZQM, ZRM, ZSK, ZSP, ZTM, ZTU,Z5B, Z5C, Z5F, Z5G, Z5H.');
1589 hr_utility.raise_error;
1590 end if;
1591 elsif p_effective_date > to_date('19'||'99/02/28','yyyy/mm/dd') then
1592 if p_First_NOAC_Lookup_Code= '515'
1593 and
1594 NOT ( p_First_Action_NOA_LA_Code1 in
1595 ('ABL','ABM','ABR','ABS','AYM',
1596 'BAB','BAC','BAD','BAE','BYO','BNM','BWA','BWM',
1597 'HAM','KLM','MXM','M6M','M8M',
1598 'NAM','NCM','NEM','NMM','NUM','PNR',
1599 'SZX','VGL','VJM','V1P','V8L','V8N','Z2U','Z2W','ZJK',
1600 'ZLM','ZQM','ZRM','ZSK','ZSP','ZTM','ZTU','Z5B','Z5C','Z5F','Z5G','Z5H') AND
1601 p_First_Action_NOA_LA_Code2 in
1602 ('ABL','ABM','ABR','ABS','AYM',
1603 'BAB','BAC','BAD','BAE','BYO','BNM','BWA','BWM',
1604 'HAM','KLM','MXM','M6M','M8M',
1605 'NAM','NCM','NEM','NMM','NUM','PNR',
1606 'SZX','VGL','VJM','V1P','V8L','V8N','Z2U','Z2W','ZJK',
1607 'ZLM','ZQM','ZRM','ZSK','ZSP','ZTM','ZTU','Z5B','Z5C','Z5F','Z5G','Z5H') ) THEN
1608 hr_utility.set_message(8301, 'GHR_37054_ALL_PROCEDURE_FAIL');
1609 hr_utility.raise_error;
1610 end if;
1611 elsif p_effective_date > to_date('19'||'99/01/31','yyyy/mm/dd') then
1612 if p_First_NOAC_Lookup_Code= '515'
1613 and
1614 NOT ( p_First_Action_NOA_LA_Code1 in
1615 ('ABL','ABM','ABR','ABS','ACM','AYM',
1616 'BAB','BAC','BAD','BAE','BYO','BNM','BWA','BWM',
1617 'CTM','HAM','KLM','MXM','M6M','M8M',
1618 'NAM','NCM','NEL','NEM','NMM','NUM','PNR',
1619 'SZX','VGL','VJM','V1P','V8L','V8N','Z2U','Z2W','ZJK',
1620 'ZLM','ZQM','ZRM','ZSK','ZSP','ZTM','ZTU','Z5B','Z5C','Z5F','Z5G','Z5H') AND
1621 p_First_Action_NOA_LA_Code2 in
1622 ('ABL','ABM','ABR','ABS','ACM','AYM',
1623 'BAB','BAC','BAD','BAE','BYO','BNM','BWA','BWM',
1624 'CTM','HAM','KLM','MXM','M6M','M8M',
1625 'NAM','NCM','NEL','NEM','NMM','NUM','PNR',
1626 'SZX','VGL','VJM','V1P','V8L','V8N','Z2U','Z2W','ZJK',
1627 'ZLM','ZQM','ZRM','ZSK','ZSP','ZTM','ZTU','Z5B','Z5C','Z5F','Z5G','Z5H') ) THEN
1628 hr_utility.set_message(8301, 'GHR_37047_ALL_PROCEDURE_FAIL');
1629 hr_utility.raise_error;
1630 end if;
1631 elsif p_effective_date >= to_date('19'||'99/01/01','yyyy/mm/dd') then
1632 if p_First_NOAC_Lookup_Code= '515'
1633 and
1634 NOT ( p_First_Action_NOA_LA_Code1 in
1635 ('ABL','ABM','ABR','ABS','ACM','AYM',
1636 'BAB','BAC','BAD','BAE','BYO',
1637 'BEA','BMC','BNE','BNM','BRM','BWA','BWM',
1638 'CTM','HAM','KLM','MXM','M6M','M8M',
1639 'NAM','NCM','NEL','NEM','NMM','NUM','PNR',
1640 'SZX','VJM','V1P','V8L','VGL','V8N','Z2U','Z2W','ZJK',
1641 'ZLM','ZQM','ZRM','ZSK','ZSP','ZTM','ZTU','Z5B','Z5C','Z5F','Z5G','Z5H') AND
1642 p_First_Action_NOA_LA_Code2 in
1643 ('ABL','ABM','ABR','ABS','ACM','AYM',
1644 'BAB','BAC','BAD','BAE','BYO',
1645 'BEA','BMC','BNE','BNM','BRM','BWA','BWM',
1646 'CTM','HAM','KLM','MXM','M6M','M8M',
1647 'NAM','NCM','NEL','NEM','NMM','NUM','PNR',
1648 'SZX','VGL','VJM','V1P','V8L','V8N','Z2U','Z2W','ZJK',
1649 'ZLM','ZQM','ZRM','ZSK','ZSP','ZTM','ZTU','Z5B','Z5C','Z5F','Z5G','Z5H') ) THEN
1650 hr_utility.set_message(8301, 'GHR_37170_ALL_PROCEDURE_FAIL');
1651 hr_utility.raise_error;
1652 end if;
1653
1654 else
1655 if p_First_NOAC_Lookup_Code= '515'
1656 and
1657 NOT ( p_First_Action_NOA_LA_Code1 in
1658 ('ABL','ABM','ABR','ABS','ACM','AYM',
1659 'BAB','BAC','BAD','BAE','BYO',
1660 'BEA','BMC','BNE','BNM','BRM','BWA','BWM',
1661 'CTM','HAM','KLM','MXM','M6M','M8M',
1662 'NAM','NCM','NEL','NEM','NMM','NUM','PNR',
1666 ('ABL','ABM','ABR','ABS','ACM','AYM',
1663 'SZX','VJM','V1P','V8L','V8N','Z2U','Z2W','ZJK',
1664 'ZLM','ZQM','ZRM','ZSK','ZSP','ZTM','ZTU','Z5B','Z5C','Z5F','Z5G','Z5H') AND
1665 p_First_Action_NOA_LA_Code2 in
1667 'BAB','BAC','BAD','BAE','BYO',
1668 'BEA','BMC','BNE','BNM','BRM','BWA','BWM',
1669 'CTM','HAM','KLM','MXM','M6M','M8M',
1670 'NAM','NCM','NEL','NEM','NMM','NUM','PNR',
1671 'SZX','VJM','V1P','V8L','V8N','Z2U','Z2W','ZJK',
1672 'ZLM','ZQM','ZRM','ZSK','ZSP','ZTM','ZTU','Z5B','Z5C','Z5F','Z5G','Z5H') ) THEN
1673 hr_utility.set_message(8301, 'GHR_37374_ALL_PROCEDURE_FAIL');
1674 hr_utility.raise_error;
1675 end if;
1676 end if;
1677 --325.29.2
1678 /* This is commented by skutteti on 8-apr-98 as this has to be deleted as per the
1679 update 6 of the edit manual for the april release.
1680
1681 if p_First_NOAC_Lookup_Code= '517'
1682 and
1683 NOT ((p_First_Action_NOA_LA_Code1 in
1684 ('ABL','ABM','ABR','ABS','BWM','HAM','MXM',
1685 'M2M','M4M','M6M','M8M','NCM','NEM','NUM',
1686 'PNR','UAM','UFM','V1P','V8N','V8V','ZLM',
1687 'ZSK','ZSP','ZVB','ZVM','Z2M') OR
1688 (SUBSTR(p_First_Action_NOA_LA_Code1,1,1) IN ('W','X','Y') AND
1689 LENGTH(p_First_Action_NOA_LA_Code1) =3 AND p_First_Action_NOA_LA_Code1 <>'WWM' ))
1690 AND
1691 (p_First_Action_NOA_LA_Code2 in
1692 ('ABL','ABM','ABR','ABS','BWM','HAM','MXM',
1693 'M2M','M4M','M6M','M8M','NCM','NEM','NUM',
1694 'PNR','UAM','UFM','V1P','V8N','V8V','ZLM',
1695 'ZSK','ZSP','ZVB','ZVM','Z2M') OR
1696 (SUBSTR(p_First_Action_NOA_LA_Code1,1,1) IN ('W','X','Y') AND
1697 LENGTH(p_First_Action_NOA_LA_Code1) =3 AND p_First_Action_NOA_LA_Code1 <>'WWM')))
1698 THEN
1699 hr_utility.set_message(8301, 'GHR_37375_ALL_PROCEDURE_FAIL');
1700 hr_utility.raise_error;
1701 end if;
1702 */
1703
1704 --325.32.2
1705 -- Upd 47 23-Jun-06 Raju From Begining Added AYM,Z5C
1706 --- Upd 56 13-Mar-09 Manish 17-Feb-2009 Added LA code ZEA
1707 --- Upd 57 30-Jul-09 Mani 01-Jan-2009 Added LA code BAG
1708
1709 IF ( p_effective_date >= to_date('2009/02/17','yyyy/mm/dd') ) THEN
1710 if p_First_NOAC_Lookup_Code= '520'
1711 and
1712 NOT ( p_First_Action_NOA_LA_Code1 in
1713 ('ABM','AYM','BAG','BWM','HAM','HNM','HRM','PNR','V1P','ZLM','ZRM','ZSK','Z5C','ZEA') AND
1714 p_First_Action_NOA_LA_Code2 in
1715 ('ABM','AYM','BAG','BWM','HAM','HNM','HRM','PNR','V1P','ZLM','ZRM','ZSK','Z5C','ZEA') ) THEN
1716 hr_utility.set_message(8301, 'GHR_37376_ALL_PROCEDURE_FAIL');
1717 hr_utility.set_message_token('LAC_CODE','ABM, AYM, BAG, BWM, HAM, HNM, HRM, PNR, V1P, ZEA, ZLM, ZRM, ZSK, Z5C.');
1718 hr_utility.raise_error;
1719 end if;
1720 ELSIF ( p_effective_date >= to_date('2009/01/01','yyyy/mm/dd') ) THEN
1721 if p_First_NOAC_Lookup_Code= '520'
1722 and
1723 NOT ( p_First_Action_NOA_LA_Code1 in
1724 ('ABM','AYM','BAG','BWM','HAM','HNM','HRM','PNR','V1P','ZLM','ZRM','ZSK','Z5C') AND
1725 p_First_Action_NOA_LA_Code2 in
1726 ('ABM','AYM','BAG','BWM','HAM','HNM','HRM','PNR','V1P','ZLM','ZRM','ZSK','Z5C') ) THEN
1727 hr_utility.set_message(8301, 'GHR_37376_ALL_PROCEDURE_FAIL');
1728 hr_utility.set_message_token('LAC_CODE','ABM, AYM, BAG, BWM, HAM, HNM, HRM, PNR, V1P, ZLM, ZRM, ZSK, Z5C.');
1729 hr_utility.raise_error;
1730 end if;
1731 ELSE
1732 if p_First_NOAC_Lookup_Code= '520'
1733 and
1734 NOT ( p_First_Action_NOA_LA_Code1 in
1735 ('ABM','AYM','BWM','HAM','HNM','HRM','PNR','V1P','ZLM','ZRM','ZSK','Z5C') AND
1736 p_First_Action_NOA_LA_Code2 in
1737 ('ABM','AYM','BWM','HAM','HNM','HRM','PNR','V1P','ZLM','ZRM','ZSK','Z5C') ) THEN
1738 hr_utility.set_message(8301, 'GHR_37376_ALL_PROCEDURE_FAIL');
1739 hr_utility.set_message_token('LAC_CODE','ABM, AYM, BWM, HAM, HNM, HRM, PNR, V1P, ZLM, ZRM, ZSK, Z5C.');
1740 hr_utility.raise_error;
1741 end if;
1742 END IF;
1743
1744 --325.35.2
1745 --- Upd 56 13-Mar-09 Manish 17-Feb-2009 Added LA code ZEA
1746
1747 IF ( p_effective_date >= to_date('2009/02/17','yyyy/mm/dd') ) THEN
1748 if p_First_NOAC_Lookup_Code= '522'
1749 and
1750 NOT ( p_First_Action_NOA_LA_Code1 in
1751 ('ABM','BWM','HAM','HNM','HRM','H3M','PNR','V1P','ZLM','ZRM','ZSK','ZEA') AND
1752 p_First_Action_NOA_LA_Code2 in
1753 ('ABM','BWM','HAM','HNM','HRM','H3M','PNR','V1P','ZLM','ZRM','ZSK','ZEA') ) THEN
1754 hr_utility.set_message(8301, 'GHR_37377_ALL_PROCEDURE_FAIL');
1755 hr_utility.set_message_token('LAC_CODE','ABM, BWM, HAM, HNM, HRM, H3M, PNR, V1P, ZEA, ZLM, ZRM, ZSK.');
1756 hr_utility.raise_error;
1757 end if;
1758 ELSE
1759 if p_First_NOAC_Lookup_Code= '522'
1760 and
1761 NOT ( p_First_Action_NOA_LA_Code1 in
1762 ('ABM','BWM','HAM','HNM','HRM','H3M','PNR','V1P','ZLM','ZRM','ZSK') AND
1763 p_First_Action_NOA_LA_Code2 in
1764 ('ABM','BWM','HAM','HNM','HRM','H3M','PNR','V1P','ZLM','ZRM','ZSK') ) THEN
1765 hr_utility.set_message(8301, 'GHR_37377_ALL_PROCEDURE_FAIL');
1766 hr_utility.set_message_token('LAC_CODE','ABM, BWM, HAM, HNM, HRM, H3M, PNR, V1P, ZLM, ZRM, ZSK.');
1767 hr_utility.raise_error;
1768 end if;
1769 END IF;
1770
1771 --325.38.2
1772 --- Upd 56 13-Mar-09 Manish 17-Feb-2009 Added LA code ZEA
1773
1774 IF ( p_effective_date >= to_date('2009/02/17','yyyy/mm/dd') ) THEN
1775 if p_First_NOAC_Lookup_Code= '524'
1776 and
1777 NOT ( p_First_Action_NOA_LA_Code1 in
1778 ('ABM','A7M','BWM','HAM','HNM','LBM','NFM','NMM','PNR','V1P','ZLM','ZRM','ZSK','ZEA') AND
1779 p_First_Action_NOA_LA_Code2 in
1783 hr_utility.raise_error;
1780 ('ABM','A7M','BWM','HAM','HNM','LBM','NFM','NMM','PNR','V1P','ZLM','ZRM','ZSK','ZEA') ) THEN
1781 hr_utility.set_message(8301, 'GHR_37378_ALL_PROCEDURE_FAIL');
1782 hr_utility.set_message_token('LAC_CODE','ABM, A7M, BWM, HAM, LBM, NFM, NMM, PNR, V1P, ZEA, ZLM, ZRM, ZSK.');
1784 end if;
1785 ELSE
1786 if p_First_NOAC_Lookup_Code= '524'
1787 and
1788 NOT ( p_First_Action_NOA_LA_Code1 in
1789 ('ABM','A7M','BWM','HAM','HNM','LBM','NFM','NMM','PNR','V1P','ZLM','ZRM','ZSK') AND
1790 p_First_Action_NOA_LA_Code2 in
1791 ('ABM','A7M','BWM','HAM','HNM','LBM','NFM','NMM','PNR','V1P','ZLM','ZRM','ZSK') ) THEN
1792 hr_utility.set_message(8301, 'GHR_37378_ALL_PROCEDURE_FAIL');
1793 hr_utility.set_message_token('LAC_CODE','ABM, A7M, BWM, HAM, LBM, NFM, NMM, PNR, V1P, ZLM, ZRM, ZSK.');
1794 hr_utility.raise_error;
1795 end if;
1796 END IF;
1797
1798 --325.44.2
1799 -- added 'Z2U' on 22-jul-1998
1800 -- 10/4 08/13/99 vravikan 01-Jan-99 Add VGL
1801 -- 11/2 12/14/99 vravikan From the Start Add ABR
1802 -- 11/9 12/14/99 vravikan 01-Nov-1999 Add UDM
1803 --- Upd 56 13-Mar-09 Manish 17-Feb-2009 Added LA code ZEA
1804 --- Upd 57 30-Jul-09 Mani 01-Mar-2009 Remove U2M
1805 --- Upd 57 30-Jul-09 Mani From Begining Add V2M
1806 -- GPPA U59 31-Jul-12 Mani 10-Jul-12 Added LA Codes LAB, LAD
1807 --BUG # 14395108
1808 if p_effective_date >= to_date('2012/07/10','yyyy/mm/dd') then
1809
1810 if p_First_NOAC_Lookup_Code= '540'
1811 and
1812 NOT ( p_First_Action_NOA_LA_Code1 in
1813 ('ABL','ABM','ABR','ABS','BWM','HAM','KQM','LAB', 'LAD','NUM',
1814 'PNR','QGM','QHM','UDM','USM','VAJ','VCS',
1815 'VCT','VCW','VDJ','VFJ','VGJ','VGL','VHJ','V1P','V2M',
1816 'V8N','Z2U','ZLM','ZSK','ZSP','ZEA') AND
1817 p_First_Action_NOA_LA_Code2 in
1818 ('ABL','ABM','ABR','ABS','BWM','HAM','KQM','LAB', 'LAD','NUM',
1819 'PNR','QGM','QHM','UDM','USM','VAJ','VCS',
1820 'VCT','VCW','VDJ','VFJ','VGJ','VGL','VHJ','V1P','V2M',
1821 'V8N','Z2U','ZLM','ZSK','ZSP','ZEA') ) THEN
1822 hr_utility.set_message(8301, 'GHR_37292_ALL_PROCEDURE_FAIL');
1823 hr_utility.set_message_token('LAC_CODE','ABL, ABM, ABR, ABS, BWM, HAM, KQM, LAB, LAD, NUM, PNR, QGM, QHM, UDM, USM, VAJ, VCS, VCT, VCW, VDJ, VFJ, VGJ, VGL, VHJ, V1P, V2M, V8N, Z2U, ZEA, ZLM, ZSK, ZSP.');
1824 hr_utility.raise_error;
1825 end if;
1826 --BUG # 14395108
1827 elsif p_effective_date >= to_date('2009/03/01','yyyy/mm/dd') then
1828
1829 if p_First_NOAC_Lookup_Code= '540'
1830 and
1831 NOT ( p_First_Action_NOA_LA_Code1 in
1832 ('ABL','ABM','ABR','ABS','BWM','HAM','KQM','NUM',
1833 'PNR','QGM','QHM','UDM','USM','VAJ','VCS',
1834 'VCT','VCW','VDJ','VFJ','VGJ','VGL','VHJ','V1P','V2M',
1835 'V8N','Z2U','ZLM','ZSK','ZSP','ZEA') AND
1836 p_First_Action_NOA_LA_Code2 in
1837 ('ABL','ABM','ABR','ABS','BWM','HAM','KQM','NUM',
1838 'PNR','QGM','QHM','UDM','USM','VAJ','VCS',
1839 'VCT','VCW','VDJ','VFJ','VGJ','VGL','VHJ','V1P','V2M',
1840 'V8N','Z2U','ZLM','ZSK','ZSP','ZEA') ) THEN
1841 hr_utility.set_message(8301, 'GHR_37292_ALL_PROCEDURE_FAIL');
1842 hr_utility.set_message_token('LAC_CODE','ABL, ABM, ABR, ABS, BWM, HAM, KQM, NUM, PNR, QGM, QHM, UDM, USM, VAJ, VCS, VCT, VCW, VDJ, VFJ, VGJ, VGL, VHJ, V1P, V2M, V8N, Z2U, ZEA, ZLM, ZSK, ZSP.');
1843 hr_utility.raise_error;
1844 end if;
1845 elsif p_effective_date >= to_date('2009/02/17','yyyy/mm/dd') then
1846
1847 if p_First_NOAC_Lookup_Code= '540'
1848 and
1849 NOT ( p_First_Action_NOA_LA_Code1 in
1850 ('ABL','ABM','ABR','ABS','BWM','HAM','KQM','NUM',
1851 'PNR','QGM','QHM','UDM','USM','U2M','VAJ','VCS',
1852 'VCT','VCW','VDJ','VFJ','VGJ','VGL','VHJ','V1P','V2M',
1853 'V8N','Z2U','ZLM','ZSK','ZSP','ZEA') AND
1854 p_First_Action_NOA_LA_Code2 in
1855 ('ABL','ABM','ABR','ABS','BWM','HAM','KQM','NUM',
1856 'PNR','QGM','QHM','UDM','USM','U2M','VAJ','VCS',
1857 'VCT','VCW','VDJ','VFJ','VGJ','VGL','VHJ','V1P','V2M',
1858 'V8N','Z2U','ZLM','ZSK','ZSP','ZEA') ) THEN
1859 hr_utility.set_message(8301, 'GHR_37292_ALL_PROCEDURE_FAIL');
1860 hr_utility.set_message_token('LAC_CODE','ABL, ABM, ABR, ABS, BWM, HAM, KQM, NUM, PNR, QGM, QHM, U2M, UDM, USM, VAJ, VCS, VCT, VCW, VDJ, VFJ, VGJ, VGL, VHJ, V1P, V2M, V8N, Z2U, ZEA, ZLM, ZSK, ZSP.');
1861 hr_utility.raise_error;
1862 end if;
1863 elsif p_effective_date >= to_date('19'||'99/11/01','yyyy/mm/dd') then
1864
1865 if p_First_NOAC_Lookup_Code= '540'
1866 and
1867 NOT ( p_First_Action_NOA_LA_Code1 in
1868 ('ABL','ABM','ABR','ABS','BWM','HAM','KQM','NUM',
1869 'PNR','QGM','QHM','UDM','USM','U2M','VAJ','VCS',
1870 'VCT','VCW','VDJ','VFJ','VGJ','VGL','VHJ','V1P','V2M',
1871 'V8N','Z2U','ZLM','ZSK','ZSP') AND
1872 p_First_Action_NOA_LA_Code2 in
1873 ('ABL','ABM','ABR','ABS','BWM','HAM','KQM','NUM',
1874 'PNR','QGM','QHM','UDM','USM','U2M','VAJ','VCS',
1875 'VCT','VCW','VDJ','VFJ','VGJ','VGL','VHJ','V1P','V2M',
1876 'V8N','Z2U','ZLM','ZSK','ZSP') ) THEN
1877 hr_utility.set_message(8301, 'GHR_37292_ALL_PROCEDURE_FAIL');
1878 hr_utility.set_message_token('LAC_CODE','ABL, ABM, ABR, ABS, BWM, HAM, KQM, NUM, PNR, QGM, QHM, U2M, UDM, USM, VAJ, VCS, VCT, VCW, VDJ, VFJ, VGJ, VGL, VHJ, V1P, V2M, V8N, Z2U, ZLM, ZSK, ZSP.');
1879 hr_utility.raise_error;
1880 end if;
1881 elsif p_effective_date >= to_date('19'||'99/01/01','yyyy/mm/dd') then
1882
1883 if p_First_NOAC_Lookup_Code= '540'
1884 and
1885 NOT ( p_First_Action_NOA_LA_Code1 in
1886 ('ABL','ABM','ABR','ABS','BWM','HAM','KQM','NUM',
1887 'PNR','QGM','QHM','USM','U2M','VAJ','VCS',
1891 ('ABL','ABM','ABR','ABS','BWM','HAM','KQM','NUM',
1888 'VCT','VCW','VDJ','VFJ','VGJ','VGL','VHJ','V1P','V2M',
1889 'V8N','Z2U','ZLM','ZSK','ZSP') AND
1890 p_First_Action_NOA_LA_Code2 in
1892 'PNR','QGM','QHM','USM','U2M','VAJ','VCS',
1893 'VCT','VCW','VDJ','VFJ','VGJ','VGL','VHJ','V1P','V2M',
1894 'V8N','Z2U','ZLM','ZSK','ZSP') ) THEN
1895 hr_utility.set_message(8301, 'GHR_37171_ALL_PROCEDURE_FAIL');
1896 hr_utility.raise_error;
1897 end if;
1898 else
1899 if p_First_NOAC_Lookup_Code= '540'
1900 and
1901 NOT ( p_First_Action_NOA_LA_Code1 in
1902 ('ABL','ABM','ABR','ABS','BWM','HAM','KQM','NUM',
1903 'PNR','QGM','QHM','USM','U2M','VAJ','VCS',
1904 'VCT','VCW','VDJ','VFJ','VGJ','VHJ','V1P','V2M',
1905 'V8N','Z2U','ZLM','ZSK','ZSP') AND
1906 p_First_Action_NOA_LA_Code2 in
1907 ('ABL','ABM','ABR','ABS','BWM','HAM','KQM','NUM',
1908 'PNR','QGM','QHM','USM','U2M','VAJ','VCS',
1909 'VCT','VCW','VDJ','VFJ','VGJ','VHJ','V1P','V2M',
1910 'V8N','Z2U','ZLM','ZSK','ZSP') ) THEN
1911 hr_utility.set_message(8301, 'GHR_37379_ALL_PROCEDURE_FAIL');
1912 hr_utility.raise_error;
1913 end if;
1914
1915 end if;
1916 --325.47.2
1917 -- added 'Z2U' on 22-jul-1998
1918 -- Update/Change Date By Effective Date Comment
1919 -- 8/5 03/09/99 vravikan Add ABR
1920 -- 10/4 08/13/99 vravikan 01-Jan-99 Add VGL
1921 -- 11/9 12/14/99 vravikan 01-Nov-1999 Add UDM
1922 --- Upd 56 13-Mar-09 Manish 17-Feb-2009 Added LA code ZEA
1923 --- Upd 57 30-Jul-09 Mani 01-Mar-2009 Remove U2M
1924 --- Upd 57 30-Jul-09 Mani From Begining Add V2M
1925 -- GPPA U59 31-Jul-12 Mani 10-Jul-12 Added LA Codes LAB, LAD
1926
1927 --BUG # 14395108
1928 if p_effective_date >= to_date('2012/07/10','yyyy/mm/dd') then
1929
1930 if p_First_NOAC_Lookup_Code= '541'
1931 and
1932 NOT ( p_First_Action_NOA_LA_Code1 in
1933 ('ABL','ABM','ABR','ABS','BWM','HAM','KQM','LAB','LAD','NUM',
1934 'PNR','QGM','QHM','UDM','USM','VAJ','VCS',
1935 'VCT','VCW','VDJ','VFJ','VGJ','VGL','VHJ','V1P', 'V2M',
1936 'V8N','Z2U','ZLM','ZSK','ZSP','ZEA') AND
1937 p_First_Action_NOA_LA_Code2 in
1938 ('ABL','ABM','ABR','ABS','BWM','HAM','KQM','LAB','LAD','NUM',
1939 'PNR','QGM','QHM','UDM','USM','VAJ','VCS',
1940 'VCT','VCW','VDJ','VFJ','VGJ','VHJ','VGL','V1P', 'V2M',
1941 'V8N','Z2U','ZLM','ZSK','ZSP','ZEA') ) THEN
1942 hr_utility.set_message(8301, 'GHR_37293_ALL_PROCEDURE_FAIL');
1943 hr_utility.set_message_token('LAC_CODE','ABL, ABM, ABR, ABS, BWM, HAM, KQM, LAB, LAD, NUM, PNR, QGM, QHM, UDM, USM, VAJ, VCS, VCT, VCW, VDJ, VFJ, VGJ, VGL, VHJ, V1P, V2M, V8N, ZEA, Z2U, ZLM, ZSK, ZSP.');
1944 hr_utility.raise_error;
1945 end if;
1946 --BUG # 14395108
1947 elsif p_effective_date >= to_date('2009/03/01','yyyy/mm/dd') then
1948
1949 if p_First_NOAC_Lookup_Code= '541'
1950 and
1951 NOT ( p_First_Action_NOA_LA_Code1 in
1952 ('ABL','ABM','ABR','ABS','BWM','HAM','KQM','NUM',
1953 'PNR','QGM','QHM','UDM','USM','VAJ','VCS',
1954 'VCT','VCW','VDJ','VFJ','VGJ','VGL','VHJ','V1P', 'V2M',
1955 'V8N','Z2U','ZLM','ZSK','ZSP','ZEA') AND
1956 p_First_Action_NOA_LA_Code2 in
1957 ('ABL','ABM','ABR','ABS','BWM','HAM','KQM','NUM',
1958 'PNR','QGM','QHM','UDM','USM','VAJ','VCS',
1959 'VCT','VCW','VDJ','VFJ','VGJ','VHJ','VGL','V1P', 'V2M',
1960 'V8N','Z2U','ZLM','ZSK','ZSP','ZEA') ) THEN
1961 hr_utility.set_message(8301, 'GHR_37293_ALL_PROCEDURE_FAIL');
1962 hr_utility.set_message_token('LAC_CODE','ABL, ABM, ABR, ABS, BWM, HAM, KQM, NUM, PNR, QGM, QHM, UDM, USM, VAJ, VCS, VCT, VCW, VDJ, VFJ, VGJ, VGL, VHJ, V1P, V2M, V8N, ZEA, Z2U, ZLM, ZSK, ZSP.');
1963 hr_utility.raise_error;
1964 end if;
1965 elsif p_effective_date >= to_date('2009/02/17','yyyy/mm/dd') then
1966
1967 if p_First_NOAC_Lookup_Code= '541'
1968 and
1969 NOT ( p_First_Action_NOA_LA_Code1 in
1970 ('ABL','ABM','ABR','ABS','BWM','HAM','KQM','NUM',
1971 'PNR','QGM','QHM','UDM','USM','U2M','VAJ','VCS',
1972 'VCT','VCW','VDJ','VFJ','VGJ','VGL','VHJ','V1P', 'V2M',
1973 'V8N','Z2U','ZLM','ZSK','ZSP','ZEA') AND
1974 p_First_Action_NOA_LA_Code2 in
1975 ('ABL','ABM','ABR','ABS','BWM','HAM','KQM','NUM',
1976 'PNR','QGM','QHM','UDM','USM','U2M','VAJ','VCS',
1977 'VCT','VCW','VDJ','VFJ','VGJ','VHJ','VGL','V1P', 'V2M',
1978 'V8N','Z2U','ZLM','ZSK','ZSP','ZEA') ) THEN
1979 hr_utility.set_message(8301, 'GHR_37293_ALL_PROCEDURE_FAIL');
1980 hr_utility.set_message_token('LAC_CODE','ABL, ABM, ABR, ABS, BWM, HAM, KQM, NUM, PNR, QGM, QHM, UDM, USM, U2M, VAJ, VCS, VCT, VCW, VDJ, VFJ, VGJ, VGL, VHJ, V1P, V2M, V8N, ZEA, Z2U, ZLM, ZSK, ZSP.');
1981 hr_utility.raise_error;
1982 end if;
1983 elsif p_effective_date >= to_date('19'||'99/11/01','yyyy/mm/dd') then
1984
1985 if p_First_NOAC_Lookup_Code= '541'
1986 and
1987 NOT ( p_First_Action_NOA_LA_Code1 in
1988 ('ABL','ABM','ABR','ABS','BWM','HAM','KQM','NUM',
1989 'PNR','QGM','QHM','UDM','USM','U2M','VAJ','VCS',
1990 'VCT','VCW','VDJ','VFJ','VGJ','VGL','VHJ','V1P', 'V2M',
1991 'V8N','Z2U','ZLM','ZSK','ZSP') AND
1992 p_First_Action_NOA_LA_Code2 in
1993 ('ABL','ABM','ABR','ABS','BWM','HAM','KQM','NUM',
1994 'PNR','QGM','QHM','UDM','USM','U2M','VAJ','VCS',
1995 'VCT','VCW','VDJ','VFJ','VGJ','VHJ','VGL','V1P', 'V2M',
1996 'V8N','Z2U','ZLM','ZSK','ZSP') ) THEN
1997 hr_utility.set_message(8301, 'GHR_37293_ALL_PROCEDURE_FAIL');
2001 elsif p_effective_date >= to_date('19'||'99/01/01','yyyy/mm/dd') then
1998 hr_utility.set_message_token('LAC_CODE','ABL, ABM, ABR, ABS, BWM, HAM, KQM, NUM, PNR, QGM, QHM, UDM, USM, U2M, VAJ, VCS, VCT, VCW, VDJ, VFJ, VGJ, VGL, VHJ, V1P, V2M, V8N, Z2U, ZLM, ZSK, ZSP.');
1999 hr_utility.raise_error;
2000 end if;
2002
2003 if p_First_NOAC_Lookup_Code= '541'
2004 and
2005 NOT ( p_First_Action_NOA_LA_Code1 in
2006 ('ABL','ABM','ABR','ABS','BWM','HAM','KQM','NUM',
2007 'PNR','QGM','QHM','USM','U2M','VAJ','VCS',
2008 'VCT','VCW','VDJ','VFJ','VGJ','VGL','VHJ','V1P', 'V2M',
2009 'V8N','Z2U','ZLM','ZSK','ZSP') AND
2010 p_First_Action_NOA_LA_Code2 in
2011 ('ABL','ABM','ABR','ABS','BWM','HAM','KQM','NUM',
2012 'PNR','QGM','QHM','USM','U2M','VAJ','VCS',
2013 'VCT','VCW','VDJ','VFJ','VGJ','VHJ','VGL','V1P','V2M',
2014 'V8N','Z2U','ZLM','ZSK','ZSP') ) THEN
2015 hr_utility.set_message(8301, 'GHR_37172_ALL_PROCEDURE_FAIL');
2016 hr_utility.raise_error;
2017 end if;
2018 else
2019 if p_First_NOAC_Lookup_Code= '541'
2020 and
2021 NOT ( p_First_Action_NOA_LA_Code1 in
2022 ('ABL','ABM','ABR','ABS','BWM','HAM','KQM','NUM',
2023 'PNR','QGM','QHM','USM','U2M','VAJ','VCS',
2024 'VCT','VCW','VDJ','VFJ','VGJ','VHJ','V1P','V2M',
2025 'V8N','Z2U','ZLM','ZSK','ZSP') AND
2026 p_First_Action_NOA_LA_Code2 in
2027 ('ABL','ABM','ABR','ABS','BWM','HAM','KQM','NUM',
2028 'PNR','QGM','QHM','USM','U2M','VAJ','VCS',
2029 'VCT','VCW','VDJ','VFJ','VGJ','VHJ','V1P','V2M',
2030 'V8N','Z2U','ZLM','ZSK','ZSP') ) THEN
2031 hr_utility.set_message(8301, 'GHR_37380_ALL_PROCEDURE_FAIL');
2032 hr_utility.raise_error;
2033 end if;
2034
2035 end if;
2036 --325.50.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= '542'
2042 and
2043 NOT ( p_First_Action_NOA_LA_Code1 in
2044 ('BWM','HAM','HRM','NRM','NTM','PNR',
2045 'P3M','P5M','UFM','V2M','ZLM','ZSK','ZVB','ZVC') AND
2046 p_First_Action_NOA_LA_Code2 in
2047 ('BWM','HAM','HRM','NRM','NTM','PNR',
2048 'P3M','P5M','UFM','V2M','ZLM','ZSK','ZVB','ZVC') ) THEN
2049 hr_utility.set_message(8301, 'GHR_37381_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= '542'
2054 and
2055 NOT ( p_First_Action_NOA_LA_Code1 in
2056 ('BWM','HAM','HRM','NRM','NTM','PNR',
2057 'P3M','P5M','UFM','V2M','ZLM','ZSK','ZVB','ZVC') AND
2058 p_First_Action_NOA_LA_Code2 in
2059 ('BWM','HAM','HRM','NRM','NTM','PNR',
2060 'P3M','P5M','UFM','V2M','ZLM','ZSK','ZVB','ZVC') ) THEN
2061 hr_utility.set_message(8301, 'GHR_37903_ALL_PROCEDURE_FAIL');
2062 hr_utility.set_message_token('LAC_CODE','BWM, HAM, NRM, NTM, NXM, PNR, P3M, P5M, UFM, V2M, ZLM, ZSK, ZVB,ZVC.');
2063 hr_utility.raise_error;
2064 end if;
2065 else
2066 if p_First_NOAC_Lookup_Code= '542'
2067 and
2068 NOT ( p_First_Action_NOA_LA_Code1 in
2069 ('BWM','HAM','HRM','NRM','NTM','PNR',
2070 'P3M','P5M','UFM','V2M','ZLM','ZSK','ZVB','ZVC','ZEA') AND
2071 p_First_Action_NOA_LA_Code2 in
2072 ('BWM','HAM','HRM','NRM','NTM','PNR',
2073 'P3M','P5M','UFM','V2M','ZLM','ZSK','ZVB','ZVC','ZEA') ) THEN
2074 hr_utility.set_message(8301, 'GHR_37903_ALL_PROCEDURE_FAIL');
2075 hr_utility.set_message_token('LAC_CODE','BWM, HAM, NRM, NTM, NXM, PNR, P3M, P5M, UFM, V2M, ZEA, ZLM, ZSK, ZVB,ZVC.');
2076 hr_utility.raise_error;
2077 end if;
2078 end if;
2079
2080 --325.53.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
2084 if p_effective_date < to_date('2001/11/01','yyyy/mm/dd') then
2085 if p_First_NOAC_Lookup_Code= '543'
2086 and
2087 NOT ( p_First_Action_NOA_LA_Code1 in
2088 ('BWM','HAM','PNR',
2089 'UFM','VBJ','VCJ','ZLM','ZSK','ZVB','ZVC') AND
2090 p_First_Action_NOA_LA_Code2 in
2091 ('BWM','HAM','PNR',
2092 'UFM','VBJ','VCJ','ZLM','ZSK','ZVB','ZVC') ) THEN
2093 hr_utility.set_message(8301, 'GHR_37382_ALL_PROCEDURE_FAIL');
2094 hr_utility.raise_error;
2095 end if;
2096 elsif p_effective_date < to_date('2009/02/17','yyyy/mm/dd') then
2097 if p_First_NOAC_Lookup_Code= '543'
2098 and
2099 NOT ( p_First_Action_NOA_LA_Code1 in
2100 ('BWM','HAM','PNR',
2101 'UFM','VBJ','VCJ','ZLM','ZSK','ZVB','ZVC') AND
2102 p_First_Action_NOA_LA_Code2 in
2103 ('BWM','HAM','PNR',
2104 'UFM','VBJ','VCJ','ZLM','ZSK','ZVB','ZVC') ) THEN
2105 hr_utility.set_message(8301, 'GHR_37902_ALL_PROCEDURE_FAIL');
2106 hr_utility.set_message_token('LAC_CODE','BWM, HAM, PNR, UFM, VBJ, VCJ, ZLM, ZSK, ZVB,ZVC.');
2107 hr_utility.raise_error;
2108 end if;
2109 else
2110 if p_First_NOAC_Lookup_Code= '543'
2111 and
2112 NOT ( p_First_Action_NOA_LA_Code1 in
2113 ('BWM','HAM','PNR',
2114 'UFM','VBJ','VCJ','ZLM','ZSK','ZVB','ZVC','ZEA') AND
2115 p_First_Action_NOA_LA_Code2 in
2116 ('BWM','HAM','PNR',
2117 'UFM','VBJ','VCJ','ZLM','ZSK','ZVB','ZVC','ZEA') ) THEN
2118 hr_utility.set_message(8301, 'GHR_37902_ALL_PROCEDURE_FAIL');
2119 hr_utility.set_message_token('LAC_CODE','BWM, HAM, PNR, UFM, VBJ, VCJ, ZEA, ZLM, ZSK, ZVB,ZVC.');
2120 hr_utility.raise_error;
2121 end if;
2125 -- Dec 2001 Patch 1-Nov-01 Add AUM
2122 end if;
2123
2124 --325.57.2
2126 --- Upd 56 13-Mar-09 Manish 17-Feb-2009 Added LA code ZEA
2127
2128 if p_effective_date < to_date('2001/11/01','yyyy/mm/dd') then
2129 if p_First_NOAC_Lookup_Code= '546'
2130 and
2131 NOT ( p_First_Action_NOA_LA_Code1 in
2132 ('AUM','AWM','BWM','HAM','NSM','NWM','PNR',
2133 'UFM','V4L','ZLM','ZSK','ZVB','ZVC') AND
2134 p_First_Action_NOA_LA_Code2 in
2135 ('AUM','AWM','BWM','HAM','NSM','NWM','PNR',
2136 'UFM','V4L','ZLM','ZSK','ZVB','ZVC') ) THEN
2137 hr_utility.set_message(8301, 'GHR_37383_ALL_PROCEDURE_FAIL');
2138 hr_utility.raise_error;
2139 end if;
2140 elsif p_effective_date < to_date('2009/02/17','yyyy/mm/dd') then
2141 if p_First_NOAC_Lookup_Code= '546'
2142 and
2143 NOT ( p_First_Action_NOA_LA_Code1 in
2144 ('AUM','AWM','BWM','HAM','NSM','NWM','PNR',
2145 'UFM','V4L','ZLM','ZSK','ZVB','ZVC') AND
2146 p_First_Action_NOA_LA_Code2 in
2147 ('AUM','AWM','BWM','HAM','NSM','NWM','PNR',
2148 'UFM','V4L','ZLM','ZSK','ZVB','ZVC') ) THEN
2149 hr_utility.set_message(8301, 'GHR_37901_ALL_PROCEDURE_FAIL');
2150 hr_utility.set_message_token('LAC_CODE','AUM, AWM, BWM, HAM, NSM, NWM, PNR, UFM, V4L, ZLM, ZSK, ZVB,ZVC.');
2151 hr_utility.raise_error;
2152 end if;
2153 else
2154 if p_First_NOAC_Lookup_Code= '546'
2155 and
2156 NOT ( p_First_Action_NOA_LA_Code1 in
2157 ('AUM','AWM','BWM','HAM','NSM','NWM','PNR',
2158 'UFM','V4L','ZLM','ZSK','ZVB','ZVC','ZEA') AND
2159 p_First_Action_NOA_LA_Code2 in
2160 ('AUM','AWM','BWM','HAM','NSM','NWM','PNR',
2161 'UFM','V4L','ZLM','ZSK','ZVB','ZVC','ZEA') ) THEN
2162 hr_utility.set_message(8301, 'GHR_37901_ALL_PROCEDURE_FAIL');
2163 hr_utility.set_message_token('LAC_CODE','AUM, AWM, BWM, HAM, NSM, NWM, PNR, UFM, V4L, ZEA, ZLM, ZSK, ZVB,ZVC.');
2164 hr_utility.raise_error;
2165 end if;
2166 end if;
2167
2168 --325.60.2
2169 --- Upd 56 13-Mar-09 Manish 17-Feb-2009 Added LA code ZEA
2170 IF ( p_effective_date >= to_date('2009/02/17','yyyy/mm/dd') ) THEN
2171 if p_First_NOAC_Lookup_Code= '548'
2172 and
2173 NOT ( p_First_Action_NOA_LA_Code1 in
2174 ('AWM','BWM','HAM','NVM','PNR',
2175 'UFM','V4M','ZLM','ZSK','ZVB','ZVC','ZEA') AND
2176 p_First_Action_NOA_LA_Code2 in
2177 ('AWM','BWM','HAM','NVM','PNR',
2178 'UFM','V4M','ZLM','ZSK','ZVB','ZVC','ZEA') ) THEN
2179 hr_utility.set_message(8301, 'GHR_37384_ALL_PROCEDURE_FAIL');
2180 hr_utility.set_message_token('LAC_CODE','AWM, BWM, HAM, NVM, PNR, UFM, V4M, ZEA, ZLM, ZSK, ZVB, ZVC.');
2181 hr_utility.raise_error;
2182 end if;
2183 ELSE
2184 if p_First_NOAC_Lookup_Code= '548'
2185 and
2186 NOT ( p_First_Action_NOA_LA_Code1 in
2187 ('AWM','BWM','HAM','NVM','PNR',
2188 'UFM','V4M','ZLM','ZSK','ZVB','ZVC') AND
2189 p_First_Action_NOA_LA_Code2 in
2190 ('AWM','BWM','HAM','NVM','PNR',
2191 'UFM','V4M','ZLM','ZSK','ZVB','ZVC') ) THEN
2192 hr_utility.set_message(8301, 'GHR_37384_ALL_PROCEDURE_FAIL');
2193 hr_utility.set_message_token('LAC_CODE','AWM, BWM, HAM, NVM, PNR, UFM, V4M, ZLM, ZSK, ZVB, ZVC.');
2194 hr_utility.raise_error;
2195 end if;
2196 END IF;
2197
2198 --325.63.2
2199 --- Upd 56 13-Mar-09 Manish 17-Feb-2009 Added LA code ZEA
2200 IF ( p_effective_date >= to_date('2009/02/17','yyyy/mm/dd') ) THEN
2201 if p_First_NOAC_Lookup_Code= '549'
2202 and
2203 NOT ( p_First_Action_NOA_LA_Code1 in
2204 ('AWM','BWM','HAM','PNR',
2205 'UFM','V4P','ZLM','ZSK','ZVB','ZVC','ZEA') AND
2206 p_First_Action_NOA_LA_Code2 in
2207 ('AWM','BWM','HAM','PNR',
2208 'UFM','V4P','ZLM','ZSK','ZVB','ZVC','ZEA') ) THEN
2209 hr_utility.set_message(8301, 'GHR_37385_ALL_PROCEDURE_FAIL');
2210 hr_utility.set_message_token('LAC_CODE','AWM, BWM, HAM, PNR, UFM, V4P, ZEA, ZLM ZSK, ZVB,ZVC.');
2211 hr_utility.raise_error;
2212 end if;
2213 ELSE
2214 if p_First_NOAC_Lookup_Code= '549'
2215 and
2216 NOT ( p_First_Action_NOA_LA_Code1 in
2217 ('AWM','BWM','HAM','PNR',
2218 'UFM','V4P','ZLM','ZSK','ZVB','ZVC') AND
2219 p_First_Action_NOA_LA_Code2 in
2220 ('AWM','BWM','HAM','PNR',
2221 'UFM','V4P','ZLM','ZSK','ZVB','ZVC') ) THEN
2222 hr_utility.set_message(8301, 'GHR_37385_ALL_PROCEDURE_FAIL');
2223 hr_utility.set_message_token('LAC_CODE','AWM, BWM, HAM, PNR, UFM, V4P, ZLM ZSK, ZVB,ZVC.');
2224 hr_utility.raise_error;
2225 end if;
2226 END IF;
2227
2228 /* Commented -- Dec 2001 Patch
2229 --325.66.2
2230 if p_First_NOAC_Lookup_Code= '550'
2231 and
2232 NOT ( p_First_Action_NOA_LA_Code1 in
2233 ('HAM','PNR','P5M','TJK','TRK','TRL','TTK','TXK',
2234 'ZLM','ZSK','ZRM') AND
2235 p_First_Action_NOA_LA_Code2 in
2236 ('HAM','PNR','P5M','TJK','TRK','TRL','TTK','TXK',
2237 'ZLM','ZSK','ZRM') ) THEN
2238 hr_utility.set_message(8301, 'GHR_37386_ALL_PROCEDURE_FAIL');
2239 hr_utility.raise_error;
2240 end if;
2241 */
2242 /* Commented -- Dec 2001 Patch
2243
2244 --325.69.2
2245 if p_First_NOAC_Lookup_Code= '551'
2246 and
2247 NOT ( p_First_Action_NOA_LA_Code1 in
2248 ('HAM','PNR','P5M','TJK','TRL','TTK','TXK',
2249 'ZLM','ZSK','ZRM') AND
2250 p_First_Action_NOA_LA_Code2 in
2251 ('HAM','PNR','P5M','TJK','TRL','TTK','TXK',
2252 'ZLM','ZSK','ZRM') ) THEN
2253 hr_utility.set_message(8301, 'GHR_37387_ALL_PROCEDURE_FAIL');
2254 hr_utility.raise_error;
2255 end if;
2259 --325.72.2
2256 */
2257 /* Commented -- Dec 2001 Patch
2258
2260 if p_First_NOAC_Lookup_Code= '553'
2261 and
2262 NOT ( p_First_Action_NOA_LA_Code1 in
2263 ('HAM','PNR','TMK','TNK','TNM',
2264 'ZLM','ZSK') AND
2265 p_First_Action_NOA_LA_Code2 in
2266 ('HAM','PNR','TMK','TNK','TNM',
2267 'ZLM','ZSK') ) THEN
2268 hr_utility.set_message(8301, 'GHR_37388_ALL_PROCEDURE_FAIL');
2269 hr_utility.raise_error;
2270 end if;
2271 */
2272 /* Commented -- Dec 2001 Patch
2273
2274 --325.75.2
2275 if p_First_NOAC_Lookup_Code= '554'
2276 and
2277 NOT ( p_First_Action_NOA_LA_Code1 in
2278 ('HAM','PNR','TMK','TNK',
2279 'ZRM','ZSK') AND
2280 p_First_Action_NOA_LA_Code2 in
2281 ('HAM','PNR','TMK','TNK',
2282 'ZRM','ZSK') ) THEN
2283 hr_utility.set_message(8301, 'GHR_37389_ALL_PROCEDURE_FAIL');
2284 hr_utility.raise_error;
2285 end if;
2286 */
2287 /* Commented -- Dec 2001 Patch
2288
2289 --325.78.2
2290 if p_First_NOAC_Lookup_Code= '555'
2291 and
2292 NOT ( p_First_Action_NOA_LA_Code1 in
2293 ('HAM','PNR','TPK','ZLM','ZSK') AND
2294 p_First_Action_NOA_LA_Code2 in
2295 ('HAM','PNR','TPK','ZLM','ZSK') ) THEN
2296 hr_utility.set_message(8301, 'GHR_37390_ALL_PROCEDURE_FAIL');
2297 hr_utility.raise_error;
2298 end if;
2299 */
2300
2301 --325.81.2
2302 -- 10/4 08/13/99 vravikan 01-Jan-1999 Add VGL
2303 -- 11/9 12/14/99 vravikan 01-Nov-1999 Add UDM
2304 -- 11/11 12/20/99 vravikan 01-Jan-1999 Change legal authorities "Y--" to "Y-- (except 'YKB')
2305 -- 21-Sep-00 vravikan From Begining Change legal authorities "Y--" to "Y-- (except 'YKB')
2306 -- 08-Dec-00 vravikan From Begining Delete ZTA
2307 -- added 'ZTA' on 12-oct-1998
2308 -- upd51 06-Feb-07 Raju From Begining Bug#5745356 add Legal autority Z6J
2309 --- Upd 56 13-Mar-09 Manish 17-Feb-2009 Added LA code ZEA
2310
2311 if p_effective_date >= to_date('2009/02/17','yyyy/mm/dd') then
2312 if p_First_NOAC_Lookup_Code= '570'
2313 and
2314 NOT ((p_First_Action_NOA_LA_Code1 in
2315 ('ABK','ABL','ABM','ABR','BPM',
2316 'BWM','H2L','HAM','J8M','PNR','QGM','QHM','UAM',
2317 'UDM','UFM',
2318 'USM','U2M','VAJ','VCS', 'VCT', 'VCW','VDJ',
2319 'VFJ','VGJ','VGL','VHJ','V1P','V8K','Z2U','ZKM','ZLM','ZNM',
2320 'ZRM','ZSK','ZSP','ZTZ','ZVB','ZVC','Z2M','Z6J','ZEA') OR
2321 ((SUBSTR(p_First_Action_NOA_LA_Code1,1,1) IN ('W','X'))
2322 OR
2323 (SUBSTR(p_First_Action_NOA_LA_Code1,1,1) IN ('Y') AND
2324 p_First_Action_NOA_LA_Code1 <> 'YKB' )
2325 AND
2326 LENGTH(p_First_Action_NOA_LA_Code1) =3 )
2327 )
2328 AND
2329 (p_First_Action_NOA_LA_Code2 in
2330 ('ABK','ABL','ABM','ABR','BPM',
2331 'BWM','H2L','HAM','J8M','PNR','QGM','QHM','UAM',
2332 'UDM','UFM',
2333 'USM','U2M','VAJ','VCS', 'VCT', 'VCW','VDJ',
2334 'VFJ','VGJ','VGL','VHJ','V1P','V8K','Z2U','ZKM','ZLM','ZNM',
2335 'ZRM','ZSK','ZSP','ZTZ','ZVB','ZVC','Z2M','Z6J','ZEA') OR
2336 ((SUBSTR(p_First_Action_NOA_LA_Code2,1,1) IN ('W','X'))
2337 OR
2338 (SUBSTR(p_First_Action_NOA_LA_Code2,1,1) IN ('Y') AND
2339 p_First_Action_NOA_LA_Code2 <> 'YKB'
2340 ) AND
2341 LENGTH(p_First_Action_NOA_LA_Code2) =3 )))
2342 THEN
2343 hr_utility.set_message(8301, 'GHR_37294_ALL_PROCEDURE_FAIL');
2344 hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ABR, BPM, BWM, HAM, H2L, J8M, PNR, P5M, QGM, QHM,
2345 UAM, UDM, UFM, USM, U2M, VAJ, VCS, VCT, VCW, VDJ, VFJ, VGJ, VHJ, V1P, V8K, V8V, VGL, W--, X--, Y--
2346 (other than YKB), ZEA, ZKM, ZLM, ZNM, ZRM, ZSK, ZSP, ZTZ, ZVB, ZVC, Z2M, Z2U,Z6J.');
2347 hr_utility.raise_error;
2348 end if;
2349 elsif p_effective_date >= to_date('19'||'99/11/01','yyyy/mm/dd') then
2350 if p_First_NOAC_Lookup_Code= '570'
2351 and
2352 NOT ((p_First_Action_NOA_LA_Code1 in
2353 ('ABK','ABL','ABM','ABR','BPM',
2354 'BWM','H2L','HAM','J8M','PNR','QGM','QHM','UAM',
2355 'UDM','UFM',
2356 'USM','U2M','VAJ','VCS', 'VCT', 'VCW','VDJ',
2357 'VFJ','VGJ','VGL','VHJ','V1P','V8K','Z2U','ZKM','ZLM','ZNM',
2358 'ZRM','ZSK','ZSP','ZTZ','ZVB','ZVC','Z2M','Z6J') OR
2359 ((SUBSTR(p_First_Action_NOA_LA_Code1,1,1) IN ('W','X'))
2360 OR
2361 (SUBSTR(p_First_Action_NOA_LA_Code1,1,1) IN ('Y') AND
2362 p_First_Action_NOA_LA_Code1 <> 'YKB' )
2363 AND
2364 LENGTH(p_First_Action_NOA_LA_Code1) =3 )
2365 )
2366 AND
2367 (p_First_Action_NOA_LA_Code2 in
2368 ('ABK','ABL','ABM','ABR','BPM',
2369 'BWM','H2L','HAM','J8M','PNR','QGM','QHM','UAM',
2370 'UDM','UFM',
2371 'USM','U2M','VAJ','VCS', 'VCT', 'VCW','VDJ',
2372 'VFJ','VGJ','VGL','VHJ','V1P','V8K','Z2U','ZKM','ZLM','ZNM',
2373 'ZRM','ZSK','ZSP','ZTZ','ZVB','ZVC','Z2M','Z6J') OR
2374 ((SUBSTR(p_First_Action_NOA_LA_Code2,1,1) IN ('W','X'))
2375 OR
2376 (SUBSTR(p_First_Action_NOA_LA_Code2,1,1) IN ('Y') AND
2377 p_First_Action_NOA_LA_Code2 <> 'YKB'
2378 ) AND
2379 LENGTH(p_First_Action_NOA_LA_Code2) =3 )))
2380 THEN
2381 hr_utility.set_message(8301, 'GHR_37294_ALL_PROCEDURE_FAIL');
2382 hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ABR, BPM, BWM, HAM, H2L, J8M, PNR, P5M, QGM, QHM,
2386 end if;
2383 UAM, UDM, UFM, USM, U2M, VAJ, VCS, VCT, VCW, VDJ, VFJ, VGJ, VHJ, V1P, V8K, V8V, VGL, W--, X--, Y--
2384 (other than YKB), ZKM, ZLM, ZNM, ZRM, ZSK, ZSP, ZTZ, ZVB, ZVC, Z2M, Z2U,Z6J.');
2385 hr_utility.raise_error;
2387 elsif p_effective_date >= to_date('19'||'99/01/01','yyyy/mm/dd') then
2388 if p_First_NOAC_Lookup_Code= '570'
2389 and
2390 NOT ((p_First_Action_NOA_LA_Code1 in
2391 ('ABK','ABL','ABM','ABR','BPM',
2392 'BWM','H2L','HAM','J8M','PNR','QGM','QHM','UAM','UFM',
2393 'USM','U2M','VAJ','VCS', 'VCT', 'VCW','VDJ',
2394 'VFJ','VGJ','VGL','VHJ','V1P','V8K','Z2U','ZKM','ZLM','ZNM',
2395 'ZRM','ZSK','ZSP','ZTZ','ZVB','ZVC','Z2M','Z6J') OR
2396 ((SUBSTR(p_First_Action_NOA_LA_Code1,1,1) IN ('W','X'))
2397 OR
2398 (SUBSTR(p_First_Action_NOA_LA_Code1,1,1) IN ('Y') AND
2399 p_First_Action_NOA_LA_Code1 <> 'YKB' )
2400 AND
2401 LENGTH(p_First_Action_NOA_LA_Code1) =3 )
2402 )
2403 AND
2404 (p_First_Action_NOA_LA_Code2 in
2405 ('ABK','ABL','ABM','ABR','BPM',
2406 'BWM','H2L','HAM','J8M','PNR','QGM','QHM','UAM','UFM',
2407 'USM','U2M','VAJ','VCS', 'VCT', 'VCW','VDJ',
2408 'VFJ','VGJ','VGL','VHJ','V1P','V8K','Z2U','ZKM','ZLM','ZNM',
2409 'ZRM','ZSK','ZSP','ZTZ','ZVB','ZVC','Z2M','Z6J') OR
2410 ((SUBSTR(p_First_Action_NOA_LA_Code2,1,1) IN ('W','X'))
2411 OR
2412 (SUBSTR(p_First_Action_NOA_LA_Code2,1,1) IN ('Y') AND
2413 p_First_Action_NOA_LA_Code2 <> 'YKB'
2414 ) AND
2415 LENGTH(p_First_Action_NOA_LA_Code2) =3 )))
2416 THEN
2417 hr_utility.set_message(8301, 'GHR_37173_ALL_PROCEDURE_FAIL');
2418 hr_utility.raise_error;
2419 end if;
2420 else
2421 if p_First_NOAC_Lookup_Code= '570'
2422 and
2423 NOT ((p_First_Action_NOA_LA_Code1 in
2424 ('ABK','ABL','ABM','ABR','BPM',
2425 'BWM','H2L','HAM','J8M','PNR','QGM','QHM','UAM','UFM',
2426 'USM','U2M','VAJ','VCS', 'VCT', 'VCW','VDJ',
2427 'VFJ','VGJ','VHJ','V1P','V8K','Z2U','ZKM','ZLM','ZNM',
2428 'ZRM','ZSK','ZSP','ZTZ','ZVB','ZVC','Z2M','Z6J') OR
2429 SUBSTR(p_First_Action_NOA_LA_Code1,1,1) IN ('W','X') OR
2430 (SUBSTR(p_First_Action_NOA_LA_Code1,1,1) IN ('Y') AND
2431 p_First_Action_NOA_LA_Code1 <> 'YKB' )
2432 )
2433 AND
2434 (p_First_Action_NOA_LA_Code2 in
2435 ('ABK','ABL','ABM','ABR','BPM',
2436 'BWM','H2L','HAM','J8M','PNR','QGM','QHM','UAM','UFM',
2437 'USM','U2M','VAJ','VCS', 'VCT', 'VCW','VDJ',
2438 'VFJ','VGJ','VHJ','V1P','V8K','Z2U','ZKM','ZLM','ZNM',
2439 'ZRM','ZSK','ZSP','ZTZ','ZVB','ZVC','Z2M','Z6J') OR
2440 SUBSTR(p_First_Action_NOA_LA_Code2,1,1) IN ('W','X') OR
2441 (SUBSTR(p_First_Action_NOA_LA_Code2,1,1) IN ('Y') AND
2442 p_First_Action_NOA_LA_Code2 <> 'YKB' )
2443 )
2444 )
2445 THEN
2446 hr_utility.set_message(8301, 'GHR_37391_ALL_PROCEDURE_FAIL');
2447 hr_utility.raise_error;
2448 end if;
2449
2450 end if;
2451
2452 --325.84.2
2453 -- added 'ZTA' on 12-oct-1998
2454 -- 10/4 08/13/99 vravikan 01-Jan-99 Add VGL
2455 -- 11/9 12/14/99 vravikan 01-Nov-1999 Add UDM
2456 -- upd51 06-Feb-07 Raju From Begining Bug#5745356 add Legal autority Z6J
2457 -- Upd 56 13-Mar-09 Manish 17-Feb-2009 Added LA code ZEA
2458 -- Upd 11-Sep-12 Raju 01-oct-2012 Added LA code ZVG
2459
2460 --Begin Bug# 14595787
2461 if p_effective_date >= to_date('2012/10/01','yyyy/mm/dd') then
2462 if p_First_NOAC_Lookup_Code= '571' and
2463 NOT ((p_First_Action_NOA_LA_Code1 in
2464 ('ABK','ABL','ABM','ABR','BPM',
2465 'BWM','H2L','HAM','J8M','PNR','UAM','UDM','UFM',
2466 'V1P','V8K','V8V','VGL','Z2M','ZKM','ZLM','ZNM',
2467 'ZSK','ZSP','ZTA','ZVB','ZVC','ZWM','Z6J','ZEA','ZVG') OR
2468 (SUBSTR(p_First_Action_NOA_LA_Code1,1,1) IN ('W','X','Y') AND
2469 LENGTH(p_First_Action_NOA_LA_Code1) =3 ))
2470 AND
2471 (p_First_Action_NOA_LA_Code2 in
2472 ('ABK','ABL','ABM','ABR','BPM',
2473 'BWM','H2L','HAM','J8M','PNR','UAM','UDM','UFM',
2474 'V1P','V8K','V8V','VGL','Z2M','ZKM','ZLM','ZNM',
2475 'ZSK','ZSP','ZTA','ZVB','ZVC','ZWM','Z6J','ZEA','ZVG') OR
2476 (SUBSTR(p_First_Action_NOA_LA_Code1,1,1) IN ('W','X','Y') AND
2477 LENGTH(p_First_Action_NOA_LA_Code1) =3 )))
2478 THEN
2479 hr_utility.set_message(8301, 'GHR_37295_ALL_PROCEDURE_FAIL');
2480 hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ABR, BPM, BWM, HAM, H2L, J8M, PNR, UAM, UDM, UFM, V1P, V8K, V8V, VGL, W--, X--, Y--, Z2M, ZEA, ZKM, ZLM, ZNM, ZSK, ZSP, ZVB,ZVC, ZWM,Z6J,ZVG.');
2481 hr_utility.raise_error;
2482 end if;
2483 --End Bug# 14595787
2484 elsif p_effective_date >= to_date('2009/02/17','yyyy/mm/dd') then
2485 if p_First_NOAC_Lookup_Code= '571'
2486 and
2487 NOT ((p_First_Action_NOA_LA_Code1 in
2488 ('ABK','ABL','ABM','ABR','BPM',
2489 'BWM','H2L','HAM','J8M','PNR','UAM','UDM','UFM',
2490 'V1P','V8K','V8V','VGL','Z2M','ZKM','ZLM','ZNM',
2491 'ZSK','ZSP','ZTA','ZVB','ZVC','ZWM','Z6J','ZEA') OR
2492 (SUBSTR(p_First_Action_NOA_LA_Code1,1,1) IN ('W','X','Y') AND
2493 LENGTH(p_First_Action_NOA_LA_Code1) =3 ))
2494 AND
2495 (p_First_Action_NOA_LA_Code2 in
2496 ('ABK','ABL','ABM','ABR','BPM',
2497 'BWM','H2L','HAM','J8M','PNR','UAM','UDM','UFM',
2498 'V1P','V8K','V8V','VGL','Z2M','ZKM','ZLM','ZNM',
2502 THEN
2499 'ZSK','ZSP','ZTA','ZVB','ZVC','ZWM','Z6J','ZEA') OR
2500 (SUBSTR(p_First_Action_NOA_LA_Code1,1,1) IN ('W','X','Y') AND
2501 LENGTH(p_First_Action_NOA_LA_Code1) =3 )))
2503 hr_utility.set_message(8301, 'GHR_37295_ALL_PROCEDURE_FAIL');
2504 hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ABR, BPM, BWM, HAM, H2L, J8M, PNR, UAM, UDM, UFM, V1P, V8K, V8V, VGL, W--, X--, Y--, Z2M, ZEA, ZKM, ZLM, ZNM, ZSK, ZSP, ZVB,ZVC, ZWM,Z6J.');
2505 hr_utility.raise_error;
2506 end if;
2507 elsif p_effective_date >= to_date('19'||'99/11/01','yyyy/mm/dd') then
2508 if p_First_NOAC_Lookup_Code= '571'
2509 and
2510 NOT ((p_First_Action_NOA_LA_Code1 in
2511 ('ABK','ABL','ABM','ABR','BPM',
2512 'BWM','H2L','HAM','J8M','PNR','UAM','UDM','UFM',
2513 'V1P','V8K','V8V','VGL','Z2M','ZKM','ZLM','ZNM',
2514 'ZSK','ZSP','ZTA','ZVB','ZVC','ZWM','Z6J') OR
2515 (SUBSTR(p_First_Action_NOA_LA_Code1,1,1) IN ('W','X','Y') AND
2516 LENGTH(p_First_Action_NOA_LA_Code1) =3 ))
2517 AND
2518 (p_First_Action_NOA_LA_Code2 in
2519 ('ABK','ABL','ABM','ABR','BPM',
2520 'BWM','H2L','HAM','J8M','PNR','UAM','UDM','UFM',
2521 'V1P','V8K','V8V','VGL','Z2M','ZKM','ZLM','ZNM',
2522 'ZSK','ZSP','ZTA','ZVB','ZVC','ZWM','Z6J') OR
2523 (SUBSTR(p_First_Action_NOA_LA_Code1,1,1) IN ('W','X','Y') AND
2524 LENGTH(p_First_Action_NOA_LA_Code1) =3 )))
2525 THEN
2526 hr_utility.set_message(8301, 'GHR_37295_ALL_PROCEDURE_FAIL');
2527 hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ABR, BPM, BWM, HAM, H2L, J8M, PNR, UAM, UDM, UFM, V1P, V8K, V8V, VGL, W--, X--, Y--, Z2M, ZKM, ZLM, ZNM, ZSK, ZSP, ZVB,ZVC, ZWM,Z6J.');
2528 hr_utility.raise_error;
2529 end if;
2530 elsif p_effective_date >= to_date('19'||'99/01/01','yyyy/mm/dd') then
2531 if p_First_NOAC_Lookup_Code= '571'
2532 and
2533 NOT ((p_First_Action_NOA_LA_Code1 in
2534 ('ABK','ABL','ABM','ABR','BPM',
2535 'BWM','H2L','HAM','J8M','PNR','UAM','UFM',
2536 'V1P','V8K','V8V','VGL','Z2M','ZKM','ZLM','ZNM',
2537 'ZSK','ZSP','ZTA','ZVB','ZVC','ZWM','Z6J') OR
2538 (SUBSTR(p_First_Action_NOA_LA_Code1,1,1) IN ('W','X','Y') AND
2539 LENGTH(p_First_Action_NOA_LA_Code1) =3 ))
2540 AND
2541 (p_First_Action_NOA_LA_Code2 in
2542 ('ABK','ABL','ABM','ABR','BPM',
2543 'BWM','H2L','HAM','J8M','PNR','UAM','UFM',
2544 'V1P','V8K','V8V','VGL','Z2M','ZKM','ZLM','ZNM',
2545 'ZSK','ZSP','ZTA','ZVB','ZVC','ZWM','Z6J') OR
2546 (SUBSTR(p_First_Action_NOA_LA_Code1,1,1) IN ('W','X','Y') AND
2547 LENGTH(p_First_Action_NOA_LA_Code1) =3 )))
2548 THEN
2549 hr_utility.set_message(8301, 'GHR_37174_ALL_PROCEDURE_FAIL');
2550 hr_utility.raise_error;
2551 end if;
2552 else
2553 if p_First_NOAC_Lookup_Code= '571'
2554 and
2555 NOT ((p_First_Action_NOA_LA_Code1 in
2556 ('ABK','ABL','ABM','ABR','BPM',
2557 'BWM','H2L','HAM','J8M','PNR','UAM','UFM',
2558 'V1P','V8K','V8V','Z2M','ZKM','ZLM','ZNM',
2559 'ZSK','ZSP','ZTA','ZVB','ZVC','ZWM','Z6J') OR
2560 (SUBSTR(p_First_Action_NOA_LA_Code1,1,1) IN ('W','X','Y') AND
2561 LENGTH(p_First_Action_NOA_LA_Code1) =3 ))
2562 AND
2563 (p_First_Action_NOA_LA_Code2 in
2564 ('ABK','ABL','ABM','ABR','BPM',
2565 'BWM','H2L','HAM','J8M','PNR','UAM','UFM',
2566 'V1P','V8K','V8V','Z2M','ZKM','ZLM','ZNM',
2567 'ZSK','ZSP','ZTA','ZVB','ZVC','ZWM','Z6J') OR
2568 (SUBSTR(p_First_Action_NOA_LA_Code1,1,1) IN ('W','X','Y') AND
2569 LENGTH(p_First_Action_NOA_LA_Code1) =3 )))
2570 THEN
2571 hr_utility.set_message(8301, 'GHR_37392_ALL_PROCEDURE_FAIL');
2572 hr_utility.raise_error;
2573 end if;
2574 end if;
2575
2576 --325.90.2
2577 -- added 'Z2U' on 22-jul-1998
2578 -- Update Date By Effective Date Comment
2579 -- 8 03/09/99 vravikan 01/31/99 Delete BEA,BMC,BNE, BNW,BRM
2580 -- 10/4 08/13/99 vravikan 01-Jan-99 Add VGL
2581 -- 9/3 09/14/99 vravikan 28-Feb-99 Delete CTM,NEL
2582 -- Dec 2001 Patch vravikan 01-Oct-01 Delete BFS,MYM, MZM
2583 --- Upd 56 13-Mar-09 Manish 17-Feb-2009 Added LA code ZEA
2584
2585 if p_effective_date >= to_date('2009/02/17','yyyy/mm/dd') then
2586 if p_First_NOAC_Lookup_Code= '590'
2587 and
2588 NOT ((p_First_Action_NOA_LA_Code1 in
2589 ('ABK','ABL','ABM','ABR','ABS','ACM','AWM','AYM',
2590 'BPM','BWA',
2591 'BWM','CRK','CRL','CRN','C1K','C2K',
2592 'C3K','C4K','C1L','C2L','C3L','C4L','C1N',
2593 'C2N','C3N','C4N','H2L','HAM','J8M','KLM',
2594 'MXM','M6M','M8M','NAM','NCM',
2595 'NEM','NUM','NVM','PNR','UAM','UFM',
2596 'VJM','V1P','V4M','V4P','V8K','V8L','VGL',
2597 'V8N','V8V','Z2U','ZJK','ZKM','ZLM',
2598 'ZNM','ZQM','ZRM','ZSK','ZSP','ZTM','ZEA') OR
2599 (SUBSTR(p_First_Action_NOA_LA_Code1,1,1) IN ('W','X','Y') AND
2600 LENGTH(p_First_Action_NOA_LA_Code1) =3 ))
2601 AND
2602 (p_First_Action_NOA_LA_Code2 in
2603 ('ABK','ABL','ABM','ABR','ABS','ACM','AWM','AYM',
2604 'BPM','BWA',
2605 'BWM','CRK','CRL','CRN','C1K','C2K',
2606 'C3K','C4K','C1L','C2L','C3L','C4L','C1N',
2607 'C2N','C3N','C4N','H2L','HAM','J8M','KLM',
2608 'MXM','M6M','M8M','NAM','NCM',
2609 'NEM','NUM','NVM','PNR','UAM','UFM',
2610 'VJM','V1P','V4M','V4P','V8K','V8L','VGL',
2611 'V8N','V8V','Z2U','ZJK','ZKM','ZLM',
2612 'ZNM','ZQM','ZRM','ZSK','ZSP','ZTM','ZEA') OR
2616 hr_utility.set_message(8301, 'GHR_37921_ALL_PROCEDURE_FAIL');
2613 (SUBSTR(p_First_Action_NOA_LA_Code2,1,1) IN ('W','X','Y') AND
2614 LENGTH(p_First_Action_NOA_LA_Code2) =3 )))
2615 THEN
2617 hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ACM, AWM, AYM, BPM, BWA, BWM, CRK, CRL, CRN, C1K,
2618 C2K, C3K, C4K, C1L, C2L, C3L, C4L, C1N, C2N, C3N, C4N, HAM, H2L, J8M, KLM, MXM, M6M, M8M, NAM, NCM, NEM,
2619 NUM, NVM, PNR, UAM, UFM, VJM, V1P, V4M, V4P, V8K, V8L, V8N, V8V, VGL, W--, X--, Y--, Z2U, ZEA, ZJK, ZKM,
2620 ZLM, ZNM, ZQM, ZRM, ZSK, ZSP, ZTM.');
2621 hr_utility.raise_error;
2622 end if;
2623 elsif p_effective_date >= to_date('2001/10/01','yyyy/mm/dd') then
2624 if p_First_NOAC_Lookup_Code= '590'
2625 and
2626 NOT ((p_First_Action_NOA_LA_Code1 in
2627 ('ABK','ABL','ABM','ABR','ABS','ACM','AWM','AYM',
2628 'BPM','BWA',
2629 'BWM','CRK','CRL','CRN','C1K','C2K',
2630 'C3K','C4K','C1L','C2L','C3L','C4L','C1N',
2631 'C2N','C3N','C4N','H2L','HAM','J8M','KLM',
2632 'MXM','M6M','M8M','NAM','NCM',
2633 'NEM','NUM','NVM','PNR','UAM','UFM',
2634 'VJM','V1P','V4M','V4P','V8K','V8L','VGL',
2635 'V8N','V8V','Z2U','ZJK','ZKM','ZLM',
2636 'ZNM','ZQM','ZRM','ZSK','ZSP','ZTM') OR
2637 (SUBSTR(p_First_Action_NOA_LA_Code1,1,1) IN ('W','X','Y') AND
2638 LENGTH(p_First_Action_NOA_LA_Code1) =3 ))
2639 AND
2640 (p_First_Action_NOA_LA_Code2 in
2641 ('ABK','ABL','ABM','ABR','ABS','ACM','AWM','AYM',
2642 'BPM','BWA',
2643 'BWM','CRK','CRL','CRN','C1K','C2K',
2644 'C3K','C4K','C1L','C2L','C3L','C4L','C1N',
2645 'C2N','C3N','C4N','H2L','HAM','J8M','KLM',
2646 'MXM','M6M','M8M','NAM','NCM',
2647 'NEM','NUM','NVM','PNR','UAM','UFM',
2648 'VJM','V1P','V4M','V4P','V8K','V8L','VGL',
2649 'V8N','V8V','Z2U','ZJK','ZKM','ZLM',
2650 'ZNM','ZQM','ZRM','ZSK','ZSP','ZTM') OR
2651 (SUBSTR(p_First_Action_NOA_LA_Code2,1,1) IN ('W','X','Y') AND
2652 LENGTH(p_First_Action_NOA_LA_Code2) =3 )))
2653 THEN
2654 hr_utility.set_message(8301, 'GHR_37921_ALL_PROCEDURE_FAIL');
2655 hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ACM, AWM, AYM, BPM, BWA, BWM, CRK, CRL, CRN, C1K,
2656 C2K, C3K, C4K, C1L, C2L, C3L, C4L, C1N, C2N, C3N, C4N, HAM, H2L, J8M, KLM, MXM, M6M, M8M, NAM, NCM, NEM,
2657 NUM, NVM, PNR, UAM, UFM, VJM, V1P, V4M, V4P, V8K, V8L, V8N, V8V, VGL, W--, X--, Y--, Z2U, ZJK, ZKM, ZLM,
2658 ZNM, ZQM, ZRM, ZSK, ZSP, ZTM.');
2659 hr_utility.raise_error;
2660 end if;
2661 elsif p_effective_date >= to_date('1999/02/28','yyyy/mm/dd') then
2662 if p_First_NOAC_Lookup_Code= '590'
2663 and
2664 NOT ((p_First_Action_NOA_LA_Code1 in
2665 ('ABK','ABL','ABM','ABR','ABS','ACM','AWM','AYM',
2666 'BPM','BWA',
2667 'BWM','CRK','CRL','CRN','C1K','C2K',
2668 'C3K','C4K','C1L','C2L','C3L','C4L','C1N',
2669 'C2N','C3N','C4N','H2L','HAM','J8M','KLM',
2670 'MXM','MYM','MZM','M6M','M8M','NAM','NCM',
2671 'NEM','NUM','NVM','PNR','UAM','UFM',
2672 'VJM','V1P','V4M','V4P','V8K','V8L','VGL',
2673 'V8N','V8V','Z2U','ZJK','ZKM','ZLM',
2674 'ZNM','ZQM','ZRM','ZSK','ZSP','ZTM') OR
2675 (SUBSTR(p_First_Action_NOA_LA_Code1,1,1) IN ('W','X','Y') AND
2676 LENGTH(p_First_Action_NOA_LA_Code1) =3 ))
2677 AND
2678 (p_First_Action_NOA_LA_Code2 in
2679 ('ABK','ABL','ABM','ABR','ABS','ACM','AWM','AYM',
2680 'BPM','BWA',
2681 'BWM','CRK','CRL','CRN','C1K','C2K',
2682 'C3K','C4K','C1L','C2L','C3L','C4L','C1N',
2683 'C2N','C3N','C4N','H2L','HAM','J8M','KLM',
2684 'MXM','MYM','MZM','M6M','M8M','NAM','NCM',
2685 'NEM','NUM','NVM','PNR','UAM','UFM',
2686 'VJM','V1P','V4M','V4P','V8K','V8L','VGL',
2687 'V8N','V8V','Z2U','ZJK','ZKM','ZLM',
2688 'ZNM','ZQM','ZRM','ZSK','ZSP','ZTM') OR
2689 (SUBSTR(p_First_Action_NOA_LA_Code2,1,1) IN ('W','X','Y') AND
2690 LENGTH(p_First_Action_NOA_LA_Code2) =3 )))
2691 THEN
2692 hr_utility.set_message(8301, 'GHR_37189_ALL_PROCEDURE_FAIL');
2693 hr_utility.raise_error;
2694 end if;
2695 elsif p_effective_date > to_date('1999/01/31','yyyy/mm/dd') then
2696 if p_First_NOAC_Lookup_Code= '590'
2697 and
2698 NOT ((p_First_Action_NOA_LA_Code1 in
2699 ('ABK','ABL','ABM','ABR','ABS','ACM','AWM','AYM',
2700 'BPM','BWA',
2701 'BWM','CRK','CRL','CRN','CTM','C1K','C2K',
2702 'C3K','C4K','C1L','C2L','C3L','C4L','C1N',
2703 'C2N','C3N','C4N','H2L','HAM','J8M','KLM',
2704 'MXM','MYM','MZM','M6M','M8M','NAM','NCM',
2705 'NEL','NEM','NUM','NVM','PNR','UAM','UFM',
2706 'VJM','V1P','V4M','V4P','V8K','V8L','VGL',
2707 'V8N','V8V','Z2U','ZJK','ZKM','ZLM',
2708 'ZNM','ZQM','ZRM','ZSK','ZSP','ZTM') OR
2709 (SUBSTR(p_First_Action_NOA_LA_Code1,1,1) IN ('W','X','Y') AND
2710 LENGTH(p_First_Action_NOA_LA_Code1) =3 ))
2711 AND
2712 (p_First_Action_NOA_LA_Code2 in
2713 ('ABK','ABL','ABM','ABR','ABS','ACM','AWM','AYM',
2714 'BPM','BWA',
2715 'BWM','CRK','CRL','CRN','CTM','C1K','C2K',
2716 'C3K','C4K','C1L','C2L','C3L','C4L','C1N',
2717 'C2N','C3N','C4N','H2L','HAM','J8M','KLM',
2718 'MXM','MYM','MZM','M6M','M8M','NAM','NCM',
2719 'NEL','NEM','NUM','NVM','PNR','UAM','UFM',
2720 'VJM','V1P','V4M','V4P','V8K','V8L','VGL',
2721 'V8N','V8V','Z2U','ZJK','ZKM','ZLM',
2722 'ZNM','ZQM','ZRM','ZSK','ZSP','ZTM') OR
2726 hr_utility.set_message(8301, 'GHR_37048_ALL_PROCEDURE_FAIL');
2723 (SUBSTR(p_First_Action_NOA_LA_Code2,1,1) IN ('W','X','Y') AND
2724 LENGTH(p_First_Action_NOA_LA_Code2) =3 )))
2725 THEN
2727 hr_utility.raise_error;
2728 end if;
2729 elsif p_effective_date >= to_date('1999/01/01','yyyy/mm/dd') then
2730 if p_First_NOAC_Lookup_Code= '590'
2731 and
2732 NOT ((p_First_Action_NOA_LA_Code1 in
2733 ('ABK','ABL','ABM','ABR','ABS','ACM','AWM','AYM',
2734 'BEA','BMC','BNE','BNW','BPM','BRM','BWA',
2735 'BWM','CRK','CRL','CRN','CTM','C1K','C2K',
2736 'C3K','C4K','C1L','C2L','C3L','C4L','C1N',
2737 'C2N','C3N','C4N','H2L','HAM','J8M','KLM',
2738 'MXM','MYM','MZM','M6M','M8M','NAM','NCM',
2739 'NEL','NEM','NUM','NVM','PNR','UAM','UFM',
2740 'VJM','V1P','V4M','V4P','V8K','V8L','VGL',
2741 'V8N','V8V','Z2U','ZJK','ZKM','ZLM',
2742 'ZNM','ZQM','ZRM','ZSK','ZSP','ZTM') OR
2743 (SUBSTR(p_First_Action_NOA_LA_Code1,1,1) IN ('W','X','Y') AND
2744 LENGTH(p_First_Action_NOA_LA_Code1) =3 ))
2745 AND
2746 (p_First_Action_NOA_LA_Code2 in
2747 ('ABK','ABL','ABM','ABR','ABS','ACM','AWM','AYM',
2748 'BEA','BMC','BNE','BNW','BPM','BRM','BWA',
2749 'BWM','CRK','CRL','CRN','CTM','C1K','C2K',
2750 'C3K','C4K','C1L','C2L','C3L','C4L','C1N',
2751 'C2N','C3N','C4N','H2L','HAM','J8M','KLM',
2752 'MXM','MYM','MZM','M6M','M8M','NAM','NCM',
2753 'NEL','NEM','NUM','NVM','PNR','UAM','UFM',
2754 'VJM','V1P','V4M','V4P','V8K','V8L','VGL',
2755 'V8N','V8V','Z2U','ZJK','ZKM','ZLM',
2756 'ZNM','ZQM','ZRM','ZSK','ZSP','ZTM') OR
2757 (SUBSTR(p_First_Action_NOA_LA_Code2,1,1) IN ('W','X','Y') AND
2758 LENGTH(p_First_Action_NOA_LA_Code2) =3 )))
2759 THEN
2760 hr_utility.set_message(8301, 'GHR_37175_ALL_PROCEDURE_FAIL');
2761 hr_utility.raise_error;
2762 end if;
2763 else
2764 if p_First_NOAC_Lookup_Code= '590'
2765 and
2766 NOT ((p_First_Action_NOA_LA_Code1 in
2767 ('ABK','ABL','ABM','ABR','ABS','ACM','AWM','AYM',
2768 'BEA','BMC','BNE','BNW','BPM','BRM','BWA',
2769 'BWM','CRK','CRL','CRN','CTM','C1K','C2K',
2770 'C3K','C4K','C1L','C2L','C3L','C4L','C1N',
2771 'C2N','C3N','C4N','H2L','HAM','J8M','KLM',
2772 'MXM','MYM','MZM','M6M','M8M','NAM','NCM',
2773 'NEL','NEM','NUM','NVM','PNR','UAM','UFM',
2774 'VJM','V1P','V4M','V4P','V8K','V8L',
2775 'V8N','V8V','Z2U','ZJK','ZKM','ZLM',
2776 'ZNM','ZQM','ZRM','ZSK','ZSP','ZTM') OR
2777 (SUBSTR(p_First_Action_NOA_LA_Code1,1,1) IN ('W','X','Y') AND
2778 LENGTH(p_First_Action_NOA_LA_Code1) =3 ))
2779 AND
2780 (p_First_Action_NOA_LA_Code2 in
2781 ('ABK','ABL','ABM','ABR','ABS','ACM','AWM','AYM',
2782 'BEA','BMC','BNE','BNW','BPM','BRM','BWA',
2783 'BWM','CRK','CRL','CRN','CTM','C1K','C2K',
2784 'C3K','C4K','C1L','C2L','C3L','C4L','C1N',
2785 'C2N','C3N','C4N','H2L','HAM','J8M','KLM',
2786 'MXM','MYM','MZM','M6M','M8M','NAM','NCM',
2787 'NEL','NEM','NUM','NVM','PNR','UAM','UFM',
2788 'VJM','V1P','V4M','V4P','V8K','V8L',
2789 'V8N','V8V','Z2U','ZJK','ZKM','ZLM',
2790 'ZNM','ZQM','ZRM','ZSK','ZSP','ZTM') OR
2791 (SUBSTR(p_First_Action_NOA_LA_Code2,1,1) IN ('W','X','Y') AND
2792 LENGTH(p_First_Action_NOA_LA_Code2) =3 )))
2793 THEN
2794 hr_utility.set_message(8301, 'GHR_37393_ALL_PROCEDURE_FAIL');
2795 hr_utility.raise_error;
2796 end if;
2797 end if;
2798 --328.02.2
2799 -- added LA code ZSE on 23-jul-98
2800 --upd47 26-Jun-06 Raju From Beginning Added ZSL
2801 if p_First_NOAC_Lookup_Code= '803'
2802 and
2803 NOT ( p_First_Action_NOA_LA_Code1 in
2804 ('CGM','ZLM','ZSM','ZSE','ZSL') AND
2805 p_First_Action_NOA_LA_Code2 in
2806 ('CGM','ZLM','ZSM','ZSE','ZSL') ) THEN
2807 hr_utility.set_message(8301, 'GHR_37394_ALL_PROCEDURE_FAIL');
2808 hr_utility.raise_error;
2809 end if;
2810
2811 --328.10.2
2812 -- 11/9 12/14/99 vravikan 01-Nov-1999 Add UDM
2813 -- 17-Aug-00 vravikan From the Start Add V7R
2814 -- 17-Aug-00 vravikan From the Start Delete ZTS
2815 -- 25-May-02 vnarasim From the Start Modified date,
2816 -- added ZTS in else
2817 -- part.
2818 -- UPD 56 8309414 Raju From the Start Add Z2U
2819 -- UPD 59 10189715 Raju From the Start Removed VPG
2820 if p_effective_date >= to_date('2010/05/01','yyyy/mm/dd') then
2821 if p_First_NOAC_Lookup_Code= '810'
2822 and
2823 NOT ( p_First_Action_NOA_LA_Code1 in
2824 ('UDM','UFM','VPH','VXK','V8K',
2825 'V8N','V8V','ZLM','V7R','Z2U','ZTZ','ZVB','ZVC') AND
2826 p_First_Action_NOA_LA_Code2 in
2827 ('UDM','UFM','VPH','VXK','V8K',
2828 'V8N','V8V','ZLM','V7R','Z2U','ZTZ','ZVB','ZVC') ) THEN
2829 hr_utility.set_message(8301, 'GHR_37296_ALL_PROCEDURE_FAIL');
2830 hr_utility.set_message_token('LA_CODE','UDM, UFM, VPH, VXK, V7R, V8K, V8N, V8V, Z2U, ZLM, ZTZ, ZVB,ZVC.');
2831 hr_utility.raise_error;
2832 end if;
2833 elsif p_effective_date >= to_date('20'||'00/08/01','yyyy/mm/dd') then
2834 if p_First_NOAC_Lookup_Code= '810'
2835 and
2836 NOT ( p_First_Action_NOA_LA_Code1 in
2837 ('UDM','UFM','VPG','VPH','VXK','V8K',
2838 'V8N','V8V','ZLM','V7R','Z2U','ZTZ','ZVB','ZVC') AND
2839 p_First_Action_NOA_LA_Code2 in
2843 hr_utility.set_message_token('LA_CODE','UDM, UFM, VPG, VPH, VXK, V7R, V8K, V8N, V8V, Z2U, ZLM, ZTZ, ZVB,ZVC.');
2840 ('UDM','UFM','VPG','VPH','VXK','V8K',
2841 'V8N','V8V','ZLM','V7R','Z2U','ZTZ','ZVB','ZVC') ) THEN
2842 hr_utility.set_message(8301, 'GHR_37296_ALL_PROCEDURE_FAIL');
2844 hr_utility.raise_error;
2845 end if;
2846 else
2847 if p_First_NOAC_Lookup_Code= '810'
2848 and
2849 NOT ( p_First_Action_NOA_LA_Code1 in
2850 ('UFM','VPG','VPH','VXK','V8K','V8N','V8V','ZLM','V7R','Z2U','ZTS','ZTZ','ZVB','ZVC') AND
2851 p_First_Action_NOA_LA_Code2 in
2852 ('UFM','VPG','VPH','VXK','V8K','V8N','V8V','ZLM','V7R','Z2U','ZTS','ZTZ','ZVB','ZVC') ) THEN
2853 hr_utility.set_message(8301, 'GHR_37395_ALL_PROCEDURE_FAIL');
2854 hr_utility.raise_error;
2855 end if;
2856 end if;
2857
2858 --329.05.2
2859 -- added ZPK on 23-jul-1998
2860 -- 11/9 12/14/99 vravikan 01-Nov-1999 Add UDM
2861 -- 17-Aug-00 vravikan From the Start Add V7R
2862 -- Dec 2001 Patch vravikan 01-Oct-2001 Delete ZPK
2863 -- UPD 41(Bug 4567571) Raju 08-Nov-2005 Add VPO and VPT
2864
2865 if p_effective_date >= to_date('2001/10/01','yyyy/mm/dd') then
2866 if p_First_NOAC_Lookup_Code= '815'
2867 and
2868 NOT ( p_First_Action_NOA_LA_Code1 in
2869 ('UAM','UDM','UFM','VPF','V7R','V8K','V8N','V8V','ZLM','ZVB','ZVC','VPO','VPT') AND
2870 p_First_Action_NOA_LA_Code2 in
2871 ('UAM','UDM','UFM','VPF','V7R','V8K','V8N','V8V','ZLM','ZVB','ZVC','VPO','VPT') ) THEN
2872 hr_utility.set_message(8301, 'GHR_37920_ALL_PROCEDURE_FAIL');
2873 hr_utility.raise_error;
2874 end if;
2875 elsif p_effective_date >= to_date('1999/11/01','yyyy/mm/dd') then
2876 if p_First_NOAC_Lookup_Code= '815'
2877 and
2878 NOT ( p_First_Action_NOA_LA_Code1 in
2879 ('UAM','UDM','UFM','VPF','V7R','V8K','V8N','V8V','ZPK','ZLM','ZVB','ZVC','VPO','VPT') AND
2880 p_First_Action_NOA_LA_Code2 in
2881 ('UAM','UDM','UFM','VPF','V7R','V8K','V8N','V8V','ZPK','ZLM','ZVB','ZVC','VPO','VPT') ) THEN
2882 hr_utility.set_message(8301, 'GHR_37297_ALL_PROCEDURE_FAIL');
2883 hr_utility.raise_error;
2884 end if;
2885 else
2886 if p_First_NOAC_Lookup_Code= '815'
2887 and
2888 NOT ( p_First_Action_NOA_LA_Code1 in
2889 ('UAM','UFM','VPF','V7R','V8K','V8N','V8V','ZPK','ZLM','ZVB','ZVC','VPO','VPT') AND
2890 p_First_Action_NOA_LA_Code2 in
2891 ('UAM','UFM','VPF','V7R','V8K','V8N','V8V','ZPK','ZLM','ZVB','ZVC','VPO','VPT') ) THEN
2892 hr_utility.set_message(8301, 'GHR_37396_ALL_PROCEDURE_FAIL');
2893 hr_utility.raise_error;
2894 end if;
2895 end if;
2896 --329.07.2
2897 -- 11/9 12/14/99 vravikan 01-Nov-1999 Add UDM
2898 -- 17-Aug-00 vravikan From the Start Add V7R
2899 -- UPD 41(Bug 4567571) Raju 08-Nov-2005 Add VPO and VPW
2900 if p_effective_date >= to_date('19'||'99/11/01','yyyy/mm/dd') then
2901 if p_First_NOAC_Lookup_Code= '816'
2902 and
2903 NOT ( p_First_Action_NOA_LA_Code1 in
2904 ('UAM','UDM','UFM','VPF','V7R','V8K','V8N','V8V','ZLM','ZTY','ZVB','ZVC','VPO','VPW') AND
2905 p_First_Action_NOA_LA_Code2 in
2906 ('UAM','UDM','UFM','VPF','V7R','V8K','V8N','V8V','ZLM','ZTY','ZVB','ZVC','VPO','VPW') ) THEN
2907 hr_utility.set_message(8301, 'GHR_37298_ALL_PROCEDURE_FAIL');
2908 hr_utility.raise_error;
2909 end if;
2910 else
2911 if p_First_NOAC_Lookup_Code= '816'
2912 and
2913 NOT ( p_First_Action_NOA_LA_Code1 in
2914 ('UAM','UFM','VPF','V7R','V8K','V8N','V8V','ZLM','ZTY','ZVB','ZVC','VPO','VPW') AND
2915 p_First_Action_NOA_LA_Code2 in
2916 ('UAM','UFM','VPF','V7R','V8K','V8N','V8V','ZLM','ZTY','ZVB','ZVC','VPO','VPW') ) THEN
2917 hr_utility.set_message(8301, 'GHR_37397_ALL_PROCEDURE_FAIL');
2918 hr_utility.raise_error;
2919 end if;
2920 end if;
2921 --329.09.2
2922 if p_First_NOAC_Lookup_Code= '818'
2923 and
2924 NOT ( p_First_Action_NOA_LA_Code1 in
2925 ('RMM','UFM','V8K','V8N','V8V','ZLM','ZVB','ZVC') AND
2926 p_First_Action_NOA_LA_Code2 in
2927 ('RMM','UFM','V8K','V8N','V8V','ZLM','ZVB','ZVC') ) THEN
2928 hr_utility.set_message(8301, 'GHR_37398_ALL_PROCEDURE_FAIL');
2929 hr_utility.raise_error;
2930 end if;
2931 -- 329.18.2
2932 -- 10-Nov-2005 Raju Created the edit
2933 -- 14-Apr-2008 Raju added VPA,VPB, VPC
2934 -- If Nature of Action is 827, the Legal Authority must be VPN, VPR, VPS, VPX, VPY, Z4G, Z4H
2935 if p_First_NOAC_Lookup_Code= '827' and
2936 NOT ( p_First_Action_NOA_LA_Code1 in
2937 ('VPA','VPB','VPC','VPN', 'VPR', 'VPS', 'VPX', 'VPY', 'Z4G', 'Z4H') AND
2938 p_First_Action_NOA_LA_Code2 in
2939 ('VPA','VPB','VPC','VPN', 'VPR', 'VPS', 'VPX', 'VPY', 'Z4G', 'Z4H') ) THEN
2940 hr_utility.set_message(8301, 'GHR_38987_ALL_PROCEDURE_FAIL');
2941 hr_utility.raise_error;
2942 end if;
2943
2944 --329.30.2
2945 -- Update Date By Effective Date Comment
2946 -- 05-NOV-03 ajose From the begining Added the Edit as a part of EOY03 changes
2947 --upd47 26-Jun-06 Raju From 01-May-2006 Terminate the edit
2948 if p_effective_date < fnd_date.canonical_to_date('2006/05/01') then
2949 IF p_First_NOAC_Lookup_Code= '849' AND
2950 NOT ( p_First_Action_NOA_LA_Code1 IN
2951 ('V9N','V9P') AND
2952 p_First_Action_NOA_LA_Code2 IN
2953 ('V9N','V9P') ) THEN
2954 hr_utility.set_message(8301, 'GHR_38840_ALL_PROCEDURE_FAIL');
2955 hr_utility.raise_error;
2956 END IF;
2957 end if;
2958
2959 --329.50.2
2960 if p_First_NOAC_Lookup_Code= '867'
2961 and
2962 NOT ( p_First_Action_NOA_LA_Code1 in
2963 ('Q9K','ZVB','ZVC') AND
2967 hr_utility.raise_error;
2964 p_First_Action_NOA_LA_Code2 in
2965 ('Q9K','ZVB','ZVC') ) THEN
2966 hr_utility.set_message(8301, 'GHR_37399_ALL_PROCEDURE_FAIL');
2968 end if;
2969
2970 --329.55.2
2971 if p_First_NOAC_Lookup_Code= '868'
2972 and
2973 NOT ( p_First_Action_NOA_LA_Code1 in
2974 ('Q9M','ZVB','ZVC') AND
2975 p_First_Action_NOA_LA_Code2 in
2976 ('Q9M','ZVB','ZVC') ) THEN
2977 hr_utility.set_message(8301, 'GHR_37400_ALL_PROCEDURE_FAIL');
2978 hr_utility.raise_error;
2979 end if;
2980
2981 --329.58.2
2982 -- 11/9 12/14/99 vravikan 01-Nov-1999 New Edit
2983 -- If nature of action is 871, then legal authority must be UAM
2984 if p_effective_date >= to_date('19'||'99/11/01','yyyy/mm/dd') then
2985 if p_First_NOAC_Lookup_Code= '871'
2986 and
2987 NOT ( p_First_Action_NOA_LA_Code1 in
2988 ('UAM') AND
2989 p_First_Action_NOA_LA_Code2 in
2990 ('UAM') ) THEN
2991 hr_utility.set_message(8301, 'GHR_37407_ALL_PROCEDURE_FAIL');
2992 hr_utility.raise_error;
2993 end if;
2994 end if;
2995 --Commented as per EOY 2003 cpdf changes by Ashley
2996 --330.02.2
2997 -- Award Req 8/15/00 vravikan 30-sep-2000 End date
2998 -- 17-Aug-00 vravikan From the Start Add V7R
2999 /* if p_effective_date <= to_date('2000/09/30','yyyy/mm/dd') then
3000 if p_First_NOAC_Lookup_Code= '875'
3001 and
3002 NOT ( p_First_Action_NOA_LA_Code1 in
3003 ('UFM','V3G','V4G','V7R','V8V','ZVB') AND
3004 p_First_Action_NOA_LA_Code2 in
3005 ('UFM','V3G','V4G','V7R','V8V','ZVB') ) THEN
3006 hr_utility.set_message(8301, 'GHR_37401_ALL_PROCEDURE_FAIL');
3007 hr_utility.raise_error;
3008 end if;
3009 end if;*/
3010
3011 --Commented as per EOY 2003 cpdf changes by Ashley
3012 --330.05.2
3013 -- Award Req 8/15/00 vravikan 30-sep-2000 End date
3014 -- 17-Aug-00 vravikan From the Start Add V7R
3015 /* if p_effective_date <= to_date('2000/09/30','yyyy/mm/dd') then
3016 if p_First_NOAC_Lookup_Code= '876'
3017 and
3018 NOT ( p_First_Action_NOA_LA_Code1 in
3019 ('UFM','V3G','V4G','V7R','V8V','ZVB') AND
3020 p_First_Action_NOA_LA_Code2 in
3021 ('UFM','V3G','V4G','V7R','V8V','ZVB') ) THEN
3022 hr_utility.set_message(8301, 'GHR_37402_ALL_PROCEDURE_FAIL');
3023 hr_utility.raise_error;
3024 end if;
3025 end if;*/
3026
3027 --Commented as per EOY 2003 cpdf changes by Ashley
3028 --330.08.2
3029 -- Award Req 8/15/00 vravikan 30-sep-2000 End date
3030 -- 17-Aug-00 vravikan From the Start Add V7R
3031 /* if p_effective_date <= to_date('2000/09/30','yyyy/mm/dd') then
3032 if p_First_NOAC_Lookup_Code= '877'
3033 and
3034 NOT ( p_First_Action_NOA_LA_Code1 in
3035 ('UFM','VGL','V3F','V3G','V4G','V7R','V8V','ZVB') AND
3036 p_First_Action_NOA_LA_Code2 in
3037 ('UFM','VGL','V3F','V3G','V4G','V7R','V8V','ZVB') ) THEN
3038 hr_utility.set_message(8301, 'GHR_37403_ALL_PROCEDURE_FAIL');
3039 hr_utility.raise_error;
3040 end if;
3041 end if;
3042 */
3043
3044 --330.11.2
3045 -- 11/3 12/14/99 vravikan 01-Nov-1999 Add UBM
3046 -- Upd 47 23-Jun-06 Raju From Begining Added V9N,V9P
3047 if p_effective_date >= to_date('19'||'99/11/01','yyyy/mm/dd') then
3048 if p_First_NOAC_Lookup_Code= '878'
3049 and
3050 NOT ( p_First_Action_NOA_LA_Code1 in
3051 ('UBM','UFM','V8G','V7G','V9N','V9P','ZVB','ZVC') AND
3052 p_First_Action_NOA_LA_Code2 in
3053 ('UBM','UFM','V8G','V7G','V9N','V9P','ZVB','ZVC') ) THEN
3054 hr_utility.set_message(8301, 'GHR_37408_ALL_PROCEDURE_FAIL');
3055 hr_utility.raise_error;
3056 end if;
3057 else
3058 if p_First_NOAC_Lookup_Code= '878'
3059 and
3060 NOT ( p_First_Action_NOA_LA_Code1 in
3061 ('UFM','V8G','V7G','V9N','V9P','ZVB','ZVC') AND
3062 p_First_Action_NOA_LA_Code2 in
3063 ('UFM','V8G','V7G','V9N','V9P','ZVB','ZVC') ) THEN
3064 hr_utility.set_message(8301, 'GHR_37404_ALL_PROCEDURE_FAIL');
3065 hr_utility.raise_error;
3066 end if;
3067 end if;
3068
3069 --330.12.2
3070 -- 11/3 12/14/99 vravikan 01-Nov-1999 Add UBM
3071 if p_effective_date >= to_date('19'||'99/11/01','yyyy/mm/dd') then
3072 if p_First_NOAC_Lookup_Code= '879'
3073 and
3074 NOT ( p_First_Action_NOA_LA_Code1 in
3075 ('UBM','UFM','VWK','ZLM','ZVB','ZVC') AND
3076 p_First_Action_NOA_LA_Code2 in
3077 ('UBM','UFM','VWK','ZLM','ZVB','ZVC') ) THEN
3078 hr_utility.set_message(8301, 'GHR_37409_ALL_PROCEDURE_FAIL');
3079 hr_utility.raise_error;
3080 end if;
3081 else
3082 if p_First_NOAC_Lookup_Code= '879'
3083 and
3084 NOT ( p_First_Action_NOA_LA_Code1 in
3085 ('UFM','VWK','ZLM','ZVB','ZVC') AND
3086 p_First_Action_NOA_LA_Code2 in
3087 ('UFM','VWK','ZLM','ZVB','ZVC') ) THEN
3088 hr_utility.set_message(8301, 'GHR_37405_ALL_PROCEDURE_FAIL');
3089 hr_utility.raise_error;
3090 end if;
3091 end if;
3092 --Commented as per EOY 2003 cpdf changes by Ashley
3093 --330.14.2
3094 -- added 'Z2W' on 12-oct-1998
3095 -- Award Req 8/15/00 vravikan 30-sep-2000 End date
3096 -- 17-Aug-00 vravikan From the Start Add V7R
3097 /* if p_effective_date <= to_date('2000/09/30','yyyy/mm/dd') then
3098 if p_First_NOAC_Lookup_Code= '885'
3099 and
3100 NOT ( p_First_Action_NOA_LA_Code1 in
3101 ('Q4M','UAM','UFM','VGL','V4R','V7R','V8V',
3102 'Z2W','ZLM','ZSR','Z2M','ZVB') AND
3106 hr_utility.set_message(8301, 'GHR_37406_ALL_PROCEDURE_FAIL');
3103 p_First_Action_NOA_LA_Code2 in
3104 ('Q4M','UAM','UFM','VGL','V4R','V7R','V8V',
3105 'Z2W','ZLM','ZSR','Z2M','ZVB') ) THEN
3107 hr_utility.raise_error;
3108 end if;
3109 end if;
3110 */
3111
3112 end chk_Legal_Authority_a;
3113
3114 end GHR_CPDF_CHECK4A;