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
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'
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
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'
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
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
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'
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
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:
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
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'
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:
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
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
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
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
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
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
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'
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
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
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
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
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
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;
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:
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
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
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
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
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'
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
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
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:
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
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:
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
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
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'
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
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
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:
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
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
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'
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:
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
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
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:
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'
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
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'
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;
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:
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
386: hr_utility.set_message(8301, 'GHR_37096_ALL_PROCEDURE_FAIL');
387: hr_utility.raise_error;
388: end if;
389: else
390: if p_First_NOAC_Lookup_Code= '480'
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
386: hr_utility.set_message(8301, 'GHR_37096_ALL_PROCEDURE_FAIL');
387: hr_utility.raise_error;
388: end if;
389: else
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:
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: --
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
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
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,
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,
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,
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,
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,
490: Z5E.');
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
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,
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.');
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
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.');
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;
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
583: 'PNR','P5M','UDM','VJM','V1P','V8N','VGL','Z2U','Z2W',
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
587: hr_utility.set_message(8301, 'GHR_37862_ALL_PROCEDURE_FAIL');
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.');
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
587: hr_utility.set_message(8301, 'GHR_37862_ALL_PROCEDURE_FAIL');
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;
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
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.');
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;
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
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:
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'
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
690: if p_First_NOAC_Lookup_Code= '500'
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
690: if p_First_NOAC_Lookup_Code= '500'
691: and
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'
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
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;
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
796: 'LSM','LYM','LZM','L1M','L2K','L3M','LYP','PNR',
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
800: hr_utility.set_message(8301, 'GHR_37300_ALL_PROCEDURE_FAIL');
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.');
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
800: hr_utility.set_message(8301, 'GHR_37300_ALL_PROCEDURE_FAIL');
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;
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
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.');
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;
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
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.');
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;
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'
898: 'LSM','LYM','LZM','L1M','L2K','L3M','LYP','PNR',
899: 'P5M','UDM','V1P','V8M','V8N','VGL','Z2U','Z2W','ZGM',
900: 'ZBA','ZHK','ZJK','ZJM',
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,
904: BNR, BNY, BWM, BAB, BAC, BAD, BAE, BYO, BNN, BWA, BWM, BYM, HAM, K1M, K7M, K8M, K9M, LBM, LEM, LHM, LJM,
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.');
899: 'P5M','UDM','V1P','V8M','V8N','VGL','Z2U','Z2W','ZGM',
900: 'ZBA','ZHK','ZJK','ZJM',
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,
904: BNR, BNY, BWM, BAB, BAC, BAD, BAE, BYO, BNN, BWA, BWM, BYM, HAM, K1M, K7M, K8M, K9M, LBM, LEM, LHM, LJM,
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;
903: hr_utility.set_message_token('LAC_CODE','ABK, ABL, ABM, ACA, ACM, AYM, A2M, BAG, BBM, BDN, BLM, BNK, BNM,
904: BNR, BNY, BWM, BAB, BAC, BAD, BAE, BYO, BNN, BWA, BWM, BYM, HAM, K1M, K7M, K8M, K9M, LBM, LEM, LHM, LJM,
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
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.');
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;
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
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.');
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;
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
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'
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
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'
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
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'
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
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;
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:
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
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'
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
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');
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;
1123: elsif p_effective_date >= fnd_date.canonical_to_date('19'||'99/02/27') then
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');
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;
1123: elsif p_effective_date >= fnd_date.canonical_to_date('19'||'99/02/27') then
1124: if p_First_NOAC_Lookup_Code= '507'
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');
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;
1123: elsif p_effective_date >= fnd_date.canonical_to_date('19'||'99/02/27') then
1124: if p_First_NOAC_Lookup_Code= '507'
1125: 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
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'
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
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:
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:
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;
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;
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
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,
1220: ZEA, ZJK, ZJM, ZLM, ZQM, ZRM, ZSK, ZSP, ZTU, ZTZ, Z5B, Z5C, Z5F, Z5J, Z6L.');
1221: hr_utility.raise_error;
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,
1220: ZEA, ZJK, ZJM, ZLM, ZQM, ZRM, ZSK, ZSP, ZTU, ZTZ, Z5B, Z5C, Z5F, Z5J, Z6L.');
1221: hr_utility.raise_error;
1222: end if;
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,
1220: ZEA, ZJK, ZJM, ZLM, ZQM, ZRM, ZSK, ZSP, ZTU, ZTZ, Z5B, Z5C, Z5F, Z5J, Z6L.');
1221: hr_utility.raise_error;
1222: end if;
1223: --BUG # 14395108
1224: --Begin Bug# 8799026
1225: elsif p_effective_date >= to_date('2009/09/11','yyyy/mm/dd') then
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;
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;
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'
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;
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;
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
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;
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;
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
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;
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;
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
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;
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;
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
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'
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
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'
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
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
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'
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:
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
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'
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
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:
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
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;
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;
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'
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;
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;
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
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;
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;
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
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;
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;
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
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'
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
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'
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
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
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'
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
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
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:
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
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
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'
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
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'
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;
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:
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
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
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'
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;
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:
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
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
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.');
1783: hr_utility.raise_error;
1784: end if;
1785: ELSE
1778: ('ABM','A7M','BWM','HAM','HNM','LBM','NFM','NMM','PNR','V1P','ZLM','ZRM','ZSK','ZEA') AND
1779: p_First_Action_NOA_LA_Code2 in
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.');
1783: hr_utility.raise_error;
1784: end if;
1785: ELSE
1786: if p_First_NOAC_Lookup_Code= '524'
1779: p_First_Action_NOA_LA_Code2 in
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.');
1783: hr_utility.raise_error;
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;
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:
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
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
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
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:
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
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:
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'
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
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:
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'
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
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:
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'
1891: ('ABL','ABM','ABR','ABS','BWM','HAM','KQM','NUM',
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'
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
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;
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
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
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
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:
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
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:
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'
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
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:
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'
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');
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;
2001: elsif p_effective_date >= to_date('19'||'99/01/01','yyyy/mm/dd') then
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');
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;
2001: elsif p_effective_date >= to_date('19'||'99/01/01','yyyy/mm/dd') then
2002:
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');
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;
2001: elsif p_effective_date >= to_date('19'||'99/01/01','yyyy/mm/dd') then
2002:
2003: if p_First_NOAC_Lookup_Code= '541'
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'
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
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;
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
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'
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
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
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'
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
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;
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:
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
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'
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
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
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'
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
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;
2122: end if;
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;
2122: end if;
2123:
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;
2122: end if;
2123:
2124: --325.57.2
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'
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
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
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'
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
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;
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:
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
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
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'
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
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;
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:
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
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
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'
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
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;
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:
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
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
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:
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;
2256: */
2257: /* Commented -- Dec 2001 Patch
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;
2256: */
2257: /* Commented -- Dec 2001 Patch
2258:
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
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:
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
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:
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:
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
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;
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;
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
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,
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;
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,
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;
2386: end if;
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,
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;
2386: end if;
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
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'
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
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;
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:
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
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
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'
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 )))
2502: THEN
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
2500: (SUBSTR(p_First_Action_NOA_LA_Code1,1,1) IN ('W','X','Y') AND
2501: LENGTH(p_First_Action_NOA_LA_Code1) =3 )))
2502: THEN
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'
2501: LENGTH(p_First_Action_NOA_LA_Code1) =3 )))
2502: THEN
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
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
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'
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
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'
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
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:
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
2612: 'ZNM','ZQM','ZRM','ZSK','ZSP','ZTM','ZEA') OR
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
2616: hr_utility.set_message(8301, 'GHR_37921_ALL_PROCEDURE_FAIL');
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.');
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
2616: hr_utility.set_message(8301, 'GHR_37921_ALL_PROCEDURE_FAIL');
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;
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
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.');
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;
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
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'
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
2722: 'ZNM','ZQM','ZRM','ZSK','ZSP','ZTM') OR
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
2726: hr_utility.set_message(8301, 'GHR_37048_ALL_PROCEDURE_FAIL');
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'
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
2726: hr_utility.set_message(8301, 'GHR_37048_ALL_PROCEDURE_FAIL');
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
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'
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
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
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
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
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
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
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'
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
2838: 'V8N','V8V','ZLM','V7R','Z2U','ZTZ','ZVB','ZVC') AND
2839: p_First_Action_NOA_LA_Code2 in
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');
2843: hr_utility.set_message_token('LA_CODE','UDM, UFM, VPG, VPH, VXK, V7R, V8K, V8N, V8V, Z2U, ZLM, ZTZ, ZVB,ZVC.');
2844: hr_utility.raise_error;
2845: end if;
2846: else
2839: p_First_Action_NOA_LA_Code2 in
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');
2843: hr_utility.set_message_token('LA_CODE','UDM, UFM, VPG, VPH, VXK, V7R, V8K, V8N, V8V, Z2U, ZLM, ZTZ, ZVB,ZVC.');
2844: hr_utility.raise_error;
2845: end if;
2846: else
2847: if p_First_NOAC_Lookup_Code= '810'
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');
2843: hr_utility.set_message_token('LA_CODE','UDM, UFM, VPG, VPH, VXK, V7R, V8K, V8N, V8V, Z2U, ZLM, ZTZ, ZVB,ZVC.');
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:
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
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'
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'
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
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
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'
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
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'
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
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
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
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
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:
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
2962: NOT ( p_First_Action_NOA_LA_Code1 in
2963: ('Q9K','ZVB','ZVC') AND
2964: p_First_Action_NOA_LA_Code2 in
2965: ('Q9K','ZVB','ZVC') ) THEN
2966: hr_utility.set_message(8301, 'GHR_37399_ALL_PROCEDURE_FAIL');
2967: hr_utility.raise_error;
2968: end if;
2969:
2970: --329.55.2
2963: ('Q9K','ZVB','ZVC') AND
2964: p_First_Action_NOA_LA_Code2 in
2965: ('Q9K','ZVB','ZVC') ) THEN
2966: hr_utility.set_message(8301, 'GHR_37399_ALL_PROCEDURE_FAIL');
2967: hr_utility.raise_error;
2968: end if;
2969:
2970: --329.55.2
2971: if p_First_NOAC_Lookup_Code= '868'
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
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
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
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
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:
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
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:
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
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: */
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:
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'
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:
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
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'
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
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
3102: 'Z2W','ZLM','ZSR','Z2M','ZVB') AND
3103: p_First_Action_NOA_LA_Code2 in
3104: ('Q4M','UAM','UFM','VGL','V4R','V7R','V8V',
3105: 'Z2W','ZLM','ZSR','Z2M','ZVB') ) THEN
3106: hr_utility.set_message(8301, 'GHR_37406_ALL_PROCEDURE_FAIL');
3107: hr_utility.raise_error;
3108: end if;
3109: end if;
3110: */
3103: p_First_Action_NOA_LA_Code2 in
3104: ('Q4M','UAM','UFM','VGL','V4R','V7R','V8V',
3105: 'Z2W','ZLM','ZSR','Z2M','ZVB') ) THEN
3106: hr_utility.set_message(8301, 'GHR_37406_ALL_PROCEDURE_FAIL');
3107: hr_utility.raise_error;
3108: end if;
3109: end if;
3110: */
3111: