eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_CPDF_CHECK4 dependencies on HR_UTILITY

Line 28: hr_utility.set_message(8301, 'GHR_37301_ALL_PROCEDURE_FAIL');

24: )
25: and
26: p_agency_sub_element <>'TD03'
27: then
28: hr_utility.set_message(8301, 'GHR_37301_ALL_PROCEDURE_FAIL');
29: hr_utility.raise_error;
30: end if;
31:
32: -- 250.03.2

Line 29: hr_utility.raise_error;

25: and
26: p_agency_sub_element <>'TD03'
27: then
28: hr_utility.set_message(8301, 'GHR_37301_ALL_PROCEDURE_FAIL');
29: hr_utility.raise_error;
30: end if;
31:
32: -- 250.03.2
33: --

Line 41: hr_utility.set_message(8301, 'GHR_37883_ALL_PROCEDURE_FAIL');

37: if p_effective_date > fnd_date.canonical_to_date('1998/03/01') then
38: if (p_First_Action_NOA_LA_Code1 in ('Z2U','UAM') or
39: p_First_Action_NOA_LA_Code2 in ('Z2U','UAM') ) and
40: substr(p_agency_sub_element,1,2) not in ('AF','AR','DD','NV') then
41: hr_utility.set_message(8301, 'GHR_37883_ALL_PROCEDURE_FAIL');
42: hr_utility.raise_error;
43: end if;
44: end if;
45:

Line 42: hr_utility.raise_error;

38: if (p_First_Action_NOA_LA_Code1 in ('Z2U','UAM') or
39: p_First_Action_NOA_LA_Code2 in ('Z2U','UAM') ) and
40: substr(p_agency_sub_element,1,2) not in ('AF','AR','DD','NV') then
41: hr_utility.set_message(8301, 'GHR_37883_ALL_PROCEDURE_FAIL');
42: hr_utility.raise_error;
43: end if;
44: end if;
45:
46: /* Commented -- Dec 2001 Patch

Line 56: hr_utility.set_message(8301, 'GHR_37885_ALL_PROCEDURE_FAIL');

52: if p_effective_date > fnd_date.canonical_to_date('1998/03/01') then
53: if (p_First_Action_NOA_LA_Code1 = 'ZPK' or
54: p_First_Action_NOA_LA_Code2 = 'ZPK' ) and
55: substr(p_agency_sub_element,1,2) <> 'PC' then
56: hr_utility.set_message(8301, 'GHR_37885_ALL_PROCEDURE_FAIL');
57: hr_utility.raise_error;
58: end if;
59: end if;
60: */

Line 57: hr_utility.raise_error;

53: if (p_First_Action_NOA_LA_Code1 = 'ZPK' or
54: p_First_Action_NOA_LA_Code2 = 'ZPK' ) and
55: substr(p_agency_sub_element,1,2) <> 'PC' then
56: hr_utility.set_message(8301, 'GHR_37885_ALL_PROCEDURE_FAIL');
57: hr_utility.raise_error;
58: end if;
59: end if;
60: */
61: -- Begin Bug 4567571

Line 65: hr_utility.set_message(8301, 'GHR_38985_ALL_PROCEDURE_FAIL');

61: -- Begin Bug 4567571
62: if (p_First_Action_NOA_LA_Code1 = 'BAE' or
63: p_First_Action_NOA_LA_Code2 = 'BAE' ) and
64: substr(p_agency_sub_element,1,2) IN('AF','AR','DD','NV') then
65: hr_utility.set_message(8301, 'GHR_38985_ALL_PROCEDURE_FAIL');
66: hr_utility.raise_error;
67: end if;
68: -- End Bug 4567571
69:

Line 66: hr_utility.raise_error;

62: if (p_First_Action_NOA_LA_Code1 = 'BAE' or
63: p_First_Action_NOA_LA_Code2 = 'BAE' ) and
64: substr(p_agency_sub_element,1,2) IN('AF','AR','DD','NV') then
65: hr_utility.set_message(8301, 'GHR_38985_ALL_PROCEDURE_FAIL');
66: hr_utility.raise_error;
67: end if;
68: -- End Bug 4567571
69:
70: --

Line 78: hr_utility.set_message(8301, 'GHR_37894_ALL_PROCEDURE_FAIL');

74: if p_effective_date >= fnd_date.canonical_to_date('1998/09/01') then
75: if (p_First_Action_NOA_LA_Code1 = 'Z2W' or
76: p_First_Action_NOA_LA_Code2 = 'Z2W' ) and
77: substr(p_agency_sub_element,1,2) not in ('AF','AR','DD','NV') then
78: hr_utility.set_message(8301, 'GHR_37894_ALL_PROCEDURE_FAIL');
79: hr_utility.raise_error;
80: end if;
81: end if;
82: /* Commented as per December 2000 cpdf changes -- vravikan

Line 79: hr_utility.raise_error;

75: if (p_First_Action_NOA_LA_Code1 = 'Z2W' or
76: p_First_Action_NOA_LA_Code2 = 'Z2W' ) and
77: substr(p_agency_sub_element,1,2) not in ('AF','AR','DD','NV') then
78: hr_utility.set_message(8301, 'GHR_37894_ALL_PROCEDURE_FAIL');
79: hr_utility.raise_error;
80: end if;
81: end if;
82: /* Commented as per December 2000 cpdf changes -- vravikan
83: --

Line 93: hr_utility.set_message(8301, 'GHR_37895_ALL_PROCEDURE_FAIL');

89: if (p_First_Action_NOA_LA_Code1 = 'ZTA' or
90: p_First_Action_NOA_LA_Code2 = 'ZTA' ) and
91: p_position_occupied_code = '1' and
92: p_agency_sub_element <> 'DJ03' then
93: hr_utility.set_message(8301, 'GHR_37895_ALL_PROCEDURE_FAIL');
94: hr_utility.raise_error;
95: end if;
96: end if;
97:

Line 94: hr_utility.raise_error;

90: p_First_Action_NOA_LA_Code2 = 'ZTA' ) and
91: p_position_occupied_code = '1' and
92: p_agency_sub_element <> 'DJ03' then
93: hr_utility.set_message(8301, 'GHR_37895_ALL_PROCEDURE_FAIL');
94: hr_utility.raise_error;
95: end if;
96: end if;
97:
98:

Line 111: hr_utility.set_message(8301, 'GHR_37926_ALL_PROCEDURE_FAIL');

107: if p_effective_date >= fnd_date.canonical_to_date('2000/10/01') then
108: if (p_First_Action_NOA_LA_Code1 = 'ZVC' or
109: p_First_Action_NOA_LA_Code2 = 'ZVC' ) and
110: p_agency_sub_element NOT IN ('HSBC') then
111: hr_utility.set_message(8301, 'GHR_37926_ALL_PROCEDURE_FAIL');
112: hr_utility.raise_error;
113: end if;
114: end if;
115: -- 250.08.2

Line 112: hr_utility.raise_error;

108: if (p_First_Action_NOA_LA_Code1 = 'ZVC' or
109: p_First_Action_NOA_LA_Code2 = 'ZVC' ) and
110: p_agency_sub_element NOT IN ('HSBC') then
111: hr_utility.set_message(8301, 'GHR_37926_ALL_PROCEDURE_FAIL');
112: hr_utility.raise_error;
113: end if;
114: end if;
115: -- 250.08.2
116: -- deleted legal authority M4M and nature of action 117,517,761

Line 125: hr_utility.set_message(8301, 'GHR_37302_ALL_PROCEDURE_FAIL');

121: )
122: and
123: p_First_NOAC_Lookup_Code not in ('115','190','515','590','760')
124: then
125: hr_utility.set_message(8301, 'GHR_37302_ALL_PROCEDURE_FAIL');
126: hr_utility.raise_error;
127: end if;
128:
129: --250.09.2

Line 126: hr_utility.raise_error;

122: and
123: p_First_NOAC_Lookup_Code not in ('115','190','515','590','760')
124: then
125: hr_utility.set_message(8301, 'GHR_37302_ALL_PROCEDURE_FAIL');
126: hr_utility.raise_error;
127: end if;
128:
129: --250.09.2
130: -- If either (first or second) Legal

Line 144: hr_utility.set_message(8301, 'GHR_37418_ALL_PROCEDURE_FAIL');

140: substr(p_agency_sub_element,1,2) <> 'TR'
141: and
142: p_agency_sub_element is not null
143: then
144: hr_utility.set_message(8301, 'GHR_37418_ALL_PROCEDURE_FAIL');
145: hr_utility.raise_error;
146: end if;
147: end if;
148: --250.09.3

Line 145: hr_utility.raise_error;

141: and
142: p_agency_sub_element is not null
143: then
144: hr_utility.set_message(8301, 'GHR_37418_ALL_PROCEDURE_FAIL');
145: hr_utility.raise_error;
146: end if;
147: end if;
148: --250.09.3
149: -- If either (first or second) Legal

Line 163: hr_utility.set_message(8301, 'GHR_37060_ALL_PROCEDURE_FAIL');

159: substr(p_agency_sub_element,1,2) <> 'TR'
160: and
161: p_agency_sub_element is not null
162: then
163: hr_utility.set_message(8301, 'GHR_37060_ALL_PROCEDURE_FAIL');
164: hr_utility.raise_error;
165: end if;
166: end if;
167: --250.13.2

Line 164: hr_utility.raise_error;

160: and
161: p_agency_sub_element is not null
162: then
163: hr_utility.set_message(8301, 'GHR_37060_ALL_PROCEDURE_FAIL');
164: hr_utility.raise_error;
165: end if;
166: end if;
167: --250.13.2
168: -- upd50 06-Feb-07 Raju From 01-Oct-2006 Bug#5745356 delete Pay plan FZ

Line 176: hr_utility.set_message(8301, 'GHR_37303_ALL_PROCEDURE_FAIL');

172: ) and
173: p_to_play_plan not in ('FA','FE','FO','FP','FZ','GG') and
174: p_to_play_plan is not null
175: then
176: hr_utility.set_message(8301, 'GHR_37303_ALL_PROCEDURE_FAIL');
177: hr_utility.set_message_token('PAY_PLAN','FA, FE, FO, FP, FZ or GG');
178: hr_utility.raise_error;
179: end if;
180: else

Line 177: hr_utility.set_message_token('PAY_PLAN','FA, FE, FO, FP, FZ or GG');

173: p_to_play_plan not in ('FA','FE','FO','FP','FZ','GG') and
174: p_to_play_plan is not null
175: then
176: hr_utility.set_message(8301, 'GHR_37303_ALL_PROCEDURE_FAIL');
177: hr_utility.set_message_token('PAY_PLAN','FA, FE, FO, FP, FZ or GG');
178: hr_utility.raise_error;
179: end if;
180: else
181: if ( p_First_Action_NOA_LA_Code1 = 'UFM' or

Line 178: hr_utility.raise_error;

174: p_to_play_plan is not null
175: then
176: hr_utility.set_message(8301, 'GHR_37303_ALL_PROCEDURE_FAIL');
177: hr_utility.set_message_token('PAY_PLAN','FA, FE, FO, FP, FZ or GG');
178: hr_utility.raise_error;
179: end if;
180: else
181: if ( p_First_Action_NOA_LA_Code1 = 'UFM' or
182: p_First_Action_NOA_LA_Code2 = 'UFM'

Line 187: hr_utility.set_message(8301, 'GHR_37303_ALL_PROCEDURE_FAIL');

183: ) and
184: p_to_play_plan not in ('FA','FE','FO','FP','GG') and
185: p_to_play_plan is not null
186: then
187: hr_utility.set_message(8301, 'GHR_37303_ALL_PROCEDURE_FAIL');
188: hr_utility.set_message_token('PAY_PLAN','FA, FE, FO, FP or GG');
189: hr_utility.raise_error;
190: end if;
191: end if;

Line 188: hr_utility.set_message_token('PAY_PLAN','FA, FE, FO, FP or GG');

184: p_to_play_plan not in ('FA','FE','FO','FP','GG') and
185: p_to_play_plan is not null
186: then
187: hr_utility.set_message(8301, 'GHR_37303_ALL_PROCEDURE_FAIL');
188: hr_utility.set_message_token('PAY_PLAN','FA, FE, FO, FP or GG');
189: hr_utility.raise_error;
190: end if;
191: end if;
192: -- 250.16.2

Line 189: hr_utility.raise_error;

185: p_to_play_plan is not null
186: then
187: hr_utility.set_message(8301, 'GHR_37303_ALL_PROCEDURE_FAIL');
188: hr_utility.set_message_token('PAY_PLAN','FA, FE, FO, FP or GG');
189: hr_utility.raise_error;
190: end if;
191: end if;
192: -- 250.16.2
193: if (

Line 205: hr_utility.set_message(8301, 'GHR_37304_ALL_PROCEDURE_FAIL');

201: )
202: and
203: p_agency_sub_element not in ('AFNG','AFZG','ARNG')
204: then
205: hr_utility.set_message(8301, 'GHR_37304_ALL_PROCEDURE_FAIL');
206: hr_utility.raise_error;
207: end if;
208:
209: --Begin Bug# 5745356

Line 206: hr_utility.raise_error;

202: and
203: p_agency_sub_element not in ('AFNG','AFZG','ARNG')
204: then
205: hr_utility.set_message(8301, 'GHR_37304_ALL_PROCEDURE_FAIL');
206: hr_utility.raise_error;
207: end if;
208:
209: --Begin Bug# 5745356
210: -- 250.17.2

Line 214: hr_utility.set_message(8301, 'GHR_37000_ALL_PROCEDURE_FAIL');

210: -- 250.17.2
211: if p_effective_date >= to_date('2007/01/01','yyyy/mm/dd') then
212: if (p_First_Action_NOA_LA_Code1 = 'Z6H' or p_First_Action_NOA_LA_Code2 = 'Z6H')
213: and substr(p_agency_sub_element,1,2) not in ('AF','AR','DD','NV') then
214: hr_utility.set_message(8301, 'GHR_37000_ALL_PROCEDURE_FAIL');
215: hr_utility.raise_error;
216: end if;
217: end if;
218: -- 250.18.2

Line 215: hr_utility.raise_error;

211: if p_effective_date >= to_date('2007/01/01','yyyy/mm/dd') then
212: if (p_First_Action_NOA_LA_Code1 = 'Z6H' or p_First_Action_NOA_LA_Code2 = 'Z6H')
213: and substr(p_agency_sub_element,1,2) not in ('AF','AR','DD','NV') then
214: hr_utility.set_message(8301, 'GHR_37000_ALL_PROCEDURE_FAIL');
215: hr_utility.raise_error;
216: end if;
217: end if;
218: -- 250.18.2
219: if p_effective_date >= to_date('2007/01/01','yyyy/mm/dd') then

Line 222: hr_utility.set_message(8301, 'GHR_37148_ALL_PROCEDURE_FAIL');

218: -- 250.18.2
219: if p_effective_date >= to_date('2007/01/01','yyyy/mm/dd') then
220: if (p_First_Action_NOA_LA_Code1 = 'Z6J' or p_First_Action_NOA_LA_Code2 = 'Z6J')
221: and substr(p_agency_sub_element,1,2) not in ('AF','AR','DD','NV') then
222: hr_utility.set_message(8301, 'GHR_37148_ALL_PROCEDURE_FAIL');
223: hr_utility.raise_error;
224: end if;
225: end if;
226: --End Bug# 5745356

Line 223: hr_utility.raise_error;

219: if p_effective_date >= to_date('2007/01/01','yyyy/mm/dd') then
220: if (p_First_Action_NOA_LA_Code1 = 'Z6J' or p_First_Action_NOA_LA_Code2 = 'Z6J')
221: and substr(p_agency_sub_element,1,2) not in ('AF','AR','DD','NV') then
222: hr_utility.set_message(8301, 'GHR_37148_ALL_PROCEDURE_FAIL');
223: hr_utility.raise_error;
224: end if;
225: end if;
226: --End Bug# 5745356
227:

Line 240: hr_utility.set_message(8301, 'GHR_37305_ALL_PROCEDURE_FAIL');

236: p_First_NOAC_Lookup_Code <> '355' ) and
237: ( p_First_Action_NOA_LA_Code1 is null and
238: p_First_Action_NOA_LA_Code2 is null)
239: then
240: hr_utility.set_message(8301, 'GHR_37305_ALL_PROCEDURE_FAIL');
241: hr_utility.raise_error;
242: end if;
243: elsif p_effective_date < to_date('2007/01/01','yyyy/mm/dd') then
244: if p_First_NOAC_Lookup_Code not in ('350','355','817','840','841','842','843',

Line 241: hr_utility.raise_error;

237: ( p_First_Action_NOA_LA_Code1 is null and
238: p_First_Action_NOA_LA_Code2 is null)
239: then
240: hr_utility.set_message(8301, 'GHR_37305_ALL_PROCEDURE_FAIL');
241: hr_utility.raise_error;
242: end if;
243: elsif p_effective_date < to_date('2007/01/01','yyyy/mm/dd') then
244: if p_First_NOAC_Lookup_Code not in ('350','355','817','840','841','842','843',
245: '844','845','846','847','848','887','889') and

Line 249: hr_utility.set_message(8301, 'GHR_37419_ALL_PROCEDURE_FAIL');

245: '844','845','846','847','848','887','889') and
246: ( p_First_Action_NOA_LA_Code1 is null and
247: p_First_Action_NOA_LA_Code2 is null)
248: then
249: hr_utility.set_message(8301, 'GHR_37419_ALL_PROCEDURE_FAIL');
250: hr_utility.raise_error;
251: end if;
252: else
253: if p_First_NOAC_Lookup_Code not in ('350','355','817','840','841','842','843',

Line 250: hr_utility.raise_error;

246: ( p_First_Action_NOA_LA_Code1 is null and
247: p_First_Action_NOA_LA_Code2 is null)
248: then
249: hr_utility.set_message(8301, 'GHR_37419_ALL_PROCEDURE_FAIL');
250: hr_utility.raise_error;
251: end if;
252: else
253: if p_First_NOAC_Lookup_Code not in ('350','355','817','840','841','842','843',
254: '844','845','846','847','848','849','886','887','889') and

Line 259: hr_utility.set_message(8301, 'GHR_38157_ALL_PROCEDURE_FAIL');

255: ( p_First_Action_NOA_LA_Code1 is null and
256: p_First_Action_NOA_LA_Code2 is null)
257: then
258: --Bug# 6959477 message number 38591 is duplicated, so created new message with #38157
259: hr_utility.set_message(8301, 'GHR_38157_ALL_PROCEDURE_FAIL');
260: hr_utility.raise_error;
261: end if;
262: end if;
263:

Line 260: hr_utility.raise_error;

256: p_First_Action_NOA_LA_Code2 is null)
257: then
258: --Bug# 6959477 message number 38591 is duplicated, so created new message with #38157
259: hr_utility.set_message(8301, 'GHR_38157_ALL_PROCEDURE_FAIL');
260: hr_utility.raise_error;
261: end if;
262: end if;
263:
264: --250.20.2

Line 277: hr_utility.set_message(8301, 'GHR_37306_ALL_PROCEDURE_FAIL');

273: p_to_play_plan <> 'ES'
274: and
275: p_to_play_plan is not null
276: then
277: hr_utility.set_message(8301, 'GHR_37306_ALL_PROCEDURE_FAIL');
278: hr_utility.raise_error;
279: end if;
280:
281: --250.25.2

Line 278: hr_utility.raise_error;

274: and
275: p_to_play_plan is not null
276: then
277: hr_utility.set_message(8301, 'GHR_37306_ALL_PROCEDURE_FAIL');
278: hr_utility.raise_error;
279: end if;
280:
281: --250.25.2
282: -- deleted nature of action 117,517

Line 291: hr_utility.set_message(8301, 'GHR_37307_ALL_PROCEDURE_FAIL');

287: )
288: and
289: p_First_NOAC_Lookup_Code not in ('171','571')
290: then
291: hr_utility.set_message(8301, 'GHR_37307_ALL_PROCEDURE_FAIL');
292: hr_utility.raise_error;
293: end if;
294:
295: --250.30.2

Line 292: hr_utility.raise_error;

288: and
289: p_First_NOAC_Lookup_Code not in ('171','571')
290: then
291: hr_utility.set_message(8301, 'GHR_37307_ALL_PROCEDURE_FAIL');
292: hr_utility.raise_error;
293: end if;
294:
295: --250.30.2
296: if (

Line 304: hr_utility.set_message(8301, 'GHR_37308_ALL_PROCEDURE_FAIL');

300: )
301: and
302: p_First_NOAC_Lookup_Code <>'CM57'
303: then
304: hr_utility.set_message(8301, 'GHR_37308_ALL_PROCEDURE_FAIL');
305: hr_utility.raise_error;
306: end if;
307:
308: --250.35.2

Line 305: hr_utility.raise_error;

301: and
302: p_First_NOAC_Lookup_Code <>'CM57'
303: then
304: hr_utility.set_message(8301, 'GHR_37308_ALL_PROCEDURE_FAIL');
305: hr_utility.raise_error;
306: end if;
307:
308: --250.35.2
309: if (

Line 325: hr_utility.set_message(8301, 'GHR_37309_ALL_PROCEDURE_FAIL');

321: and
322: p_agency_sub_element <> 'AG11'
323: )
324: then
325: hr_utility.set_message(8301, 'GHR_37309_ALL_PROCEDURE_FAIL');
326: hr_utility.raise_error;
327: end if;
328:
329: --250.38.2

Line 326: hr_utility.raise_error;

322: p_agency_sub_element <> 'AG11'
323: )
324: then
325: hr_utility.set_message(8301, 'GHR_37309_ALL_PROCEDURE_FAIL');
326: hr_utility.raise_error;
327: end if;
328:
329: --250.38.2
330: if (

Line 338: hr_utility.set_message(8301, 'GHR_37310_ALL_PROCEDURE_FAIL');

334: )
335: and
336: substr(p_agency_sub_element,1,2) <> 'VA'
337: then
338: hr_utility.set_message(8301, 'GHR_37310_ALL_PROCEDURE_FAIL');
339: hr_utility.raise_error;
340: end if;
341:
342: --250.39.2

Line 339: hr_utility.raise_error;

335: and
336: substr(p_agency_sub_element,1,2) <> 'VA'
337: then
338: hr_utility.set_message(8301, 'GHR_37310_ALL_PROCEDURE_FAIL');
339: hr_utility.raise_error;
340: end if;
341:
342: --250.39.2
343: -- Update Date By Effective Date Comment

Line 355: hr_utility.set_message(8301, 'GHR_37420_ALL_PROCEDURE_FAIL');

351: )
352: and
353: p_agency_sub_element <> 'TR93'
354: then
355: hr_utility.set_message(8301, 'GHR_37420_ALL_PROCEDURE_FAIL');
356: hr_utility.raise_error;
357: end if;
358: end if;
359:

Line 356: hr_utility.raise_error;

352: and
353: p_agency_sub_element <> 'TR93'
354: then
355: hr_utility.set_message(8301, 'GHR_37420_ALL_PROCEDURE_FAIL');
356: hr_utility.raise_error;
357: end if;
358: end if;
359:
360: -- START OF 255.02.2

Line 408: hr_utility.set_message(8301, 'GHR_37191_ALL_PROCEDURE_FAIL');

404: 'QBK','QCK','UDM','VGL','VJM','V1P','V8L','V8N','Z2U','Z2W','ZGM',
405: 'ZBA','ZJK','ZJM','ZJR','ZLM','ZQM','ZRM','ZSK','ZSP','ZTU','Z5B','Z5C')
406: )
407: then
408: hr_utility.set_message(8301, 'GHR_37191_ALL_PROCEDURE_FAIL');
409: hr_utility.raise_error;
410: end if;
411: elsif p_effective_date >= to_date('19'||'99/11/01','yyyy/mm/dd') then
412: if p_First_NOAC_Lookup_Code= '100'

Line 409: hr_utility.raise_error;

405: 'ZBA','ZJK','ZJM','ZJR','ZLM','ZQM','ZRM','ZSK','ZSP','ZTU','Z5B','Z5C')
406: )
407: then
408: hr_utility.set_message(8301, 'GHR_37191_ALL_PROCEDURE_FAIL');
409: hr_utility.raise_error;
410: end if;
411: elsif p_effective_date >= to_date('19'||'99/11/01','yyyy/mm/dd') then
412: if p_First_NOAC_Lookup_Code= '100'
413: and

Line 438: hr_utility.set_message(8301, 'GHR_37190_ALL_PROCEDURE_FAIL');

434: 'QBK','QCK','UDM','VGL','VJM','V1P','V8L','V8N','Z2U','Z2W','ZGM',
435: 'ZBA','ZJK','ZJM','ZJR','ZLM','ZQM','ZRM','ZSK','ZSP','ZTU','Z5B','Z5C')
436: )
437: then
438: hr_utility.set_message(8301, 'GHR_37190_ALL_PROCEDURE_FAIL');
439: hr_utility.raise_error;
440: end if;
441: elsif p_effective_date > to_date('19'||'99/01/31','yyyy/mm/dd') then
442: if p_First_NOAC_Lookup_Code= '100'

Line 439: hr_utility.raise_error;

435: 'ZBA','ZJK','ZJM','ZJR','ZLM','ZQM','ZRM','ZSK','ZSP','ZTU','Z5B','Z5C')
436: )
437: then
438: hr_utility.set_message(8301, 'GHR_37190_ALL_PROCEDURE_FAIL');
439: hr_utility.raise_error;
440: end if;
441: elsif p_effective_date > to_date('19'||'99/01/31','yyyy/mm/dd') then
442: if p_First_NOAC_Lookup_Code= '100'
443: and

Line 468: hr_utility.set_message(8301, 'GHR_37039_ALL_PROCEDURE_FAIL');

464: 'QBK','QCK','VGL','VJM','V1P','V8L','V8N','Z2U','Z2W','ZGM',
465: 'ZBA','ZJK','ZJM','ZJR','ZLM','ZQM','ZRM','ZSK','ZSP','ZTU','Z5B','Z5C')
466: )
467: then
468: hr_utility.set_message(8301, 'GHR_37039_ALL_PROCEDURE_FAIL');
469: hr_utility.raise_error;
470: end if;
471: elsif p_effective_date >= to_date('19'||'99/01/01','yyyy/mm/dd') then
472: if p_First_NOAC_Lookup_Code= '100'

Line 469: hr_utility.raise_error;

465: 'ZBA','ZJK','ZJM','ZJR','ZLM','ZQM','ZRM','ZSK','ZSP','ZTU','Z5B','Z5C')
466: )
467: then
468: hr_utility.set_message(8301, 'GHR_37039_ALL_PROCEDURE_FAIL');
469: hr_utility.raise_error;
470: end if;
471: elsif p_effective_date >= to_date('19'||'99/01/01','yyyy/mm/dd') then
472: if p_First_NOAC_Lookup_Code= '100'
473: and

Line 498: hr_utility.set_message(8301, 'GHR_37085_ALL_PROCEDURE_FAIL');

494: 'QBK','QCK','VGL','VJM','V1P','V8L','V8N','Z2U','Z2W','ZGM',
495: 'ZBA','ZJK','ZJM','ZJR','ZLM','ZQM','ZRM','ZSK','ZSP','ZTU','Z5B','Z5C')
496: )
497: then
498: hr_utility.set_message(8301, 'GHR_37085_ALL_PROCEDURE_FAIL');
499: hr_utility.raise_error;
500: end if;
501: else
502: if p_First_NOAC_Lookup_Code= '100'

Line 499: hr_utility.raise_error;

495: 'ZBA','ZJK','ZJM','ZJR','ZLM','ZQM','ZRM','ZSK','ZSP','ZTU','Z5B','Z5C')
496: )
497: then
498: hr_utility.set_message(8301, 'GHR_37085_ALL_PROCEDURE_FAIL');
499: hr_utility.raise_error;
500: end if;
501: else
502: if p_First_NOAC_Lookup_Code= '100'
503: and

Line 528: hr_utility.set_message(8301, 'GHR_37311_ALL_PROCEDURE_FAIL');

524: 'QBK','QCK','VJM','V1P','V8L','V8N','Z2U','Z2W','ZGM',
525: 'ZBA','ZJK','ZJM','ZJR','ZLM','ZQM','ZRM','ZSK','ZSP','ZTU','Z5B','Z5C')
526: )
527: then
528: hr_utility.set_message(8301, 'GHR_37311_ALL_PROCEDURE_FAIL');
529: hr_utility.raise_error;
530: end if;
531: end if;
532: -- END IF 255.02.2

Line 529: hr_utility.raise_error;

525: 'ZBA','ZJK','ZJM','ZJR','ZLM','ZQM','ZRM','ZSK','ZSP','ZTU','Z5B','Z5C')
526: )
527: then
528: hr_utility.set_message(8301, 'GHR_37311_ALL_PROCEDURE_FAIL');
529: hr_utility.raise_error;
530: end if;
531: end if;
532: -- END IF 255.02.2
533: --

Line 581: hr_utility.set_message(8301, 'GHR_37193_ALL_PROCEDURE_FAIL');

577: 'ZBA','ZGM','ZJK','ZJM',
578: 'ZJR','ZLM','ZQM','ZRM','ZSK','ZSP','ZTU')
579: )
580: then
581: hr_utility.set_message(8301, 'GHR_37193_ALL_PROCEDURE_FAIL');
582: hr_utility.raise_error;
583: end if;
584: elsif p_effective_date >= to_date('19'||'99/11/01','yyyy/mm/dd') then
585: if p_First_NOAC_Lookup_Code= '101'

Line 582: hr_utility.raise_error;

578: 'ZJR','ZLM','ZQM','ZRM','ZSK','ZSP','ZTU')
579: )
580: then
581: hr_utility.set_message(8301, 'GHR_37193_ALL_PROCEDURE_FAIL');
582: hr_utility.raise_error;
583: end if;
584: elsif p_effective_date >= to_date('19'||'99/11/01','yyyy/mm/dd') then
585: if p_First_NOAC_Lookup_Code= '101'
586: and

Line 613: hr_utility.set_message(8301, 'GHR_37192_ALL_PROCEDURE_FAIL');

609: 'ZBA','ZGM','ZJK','ZJM',
610: 'ZJR','ZLM','ZQM','ZRM','ZSK','ZSP','ZTU')
611: )
612: then
613: hr_utility.set_message(8301, 'GHR_37192_ALL_PROCEDURE_FAIL');
614: hr_utility.raise_error;
615: end if;
616: elsif p_effective_date > to_date('19'||'99/01/31','yyyy/mm/dd') then
617: if p_First_NOAC_Lookup_Code= '101'

Line 614: hr_utility.raise_error;

610: 'ZJR','ZLM','ZQM','ZRM','ZSK','ZSP','ZTU')
611: )
612: then
613: hr_utility.set_message(8301, 'GHR_37192_ALL_PROCEDURE_FAIL');
614: hr_utility.raise_error;
615: end if;
616: elsif p_effective_date > to_date('19'||'99/01/31','yyyy/mm/dd') then
617: if p_First_NOAC_Lookup_Code= '101'
618: and

Line 643: hr_utility.set_message(8301, 'GHR_37040_ALL_PROCEDURE_FAIL');

639: 'QBK','QCK','VGL','V1P','V8L','V8N','Z2U','Z2W','ZGM','ZJK','ZJM',
640: 'ZBA','ZJR','ZLM','ZQM','ZRM','ZSK','ZSP','ZTU')
641: )
642: then
643: hr_utility.set_message(8301, 'GHR_37040_ALL_PROCEDURE_FAIL');
644: hr_utility.raise_error;
645: end if;
646: elsif p_effective_date >= to_date('19'||'99/01/01','yyyy/mm/dd') then
647: if p_First_NOAC_Lookup_Code= '101'

Line 644: hr_utility.raise_error;

640: 'ZBA','ZJR','ZLM','ZQM','ZRM','ZSK','ZSP','ZTU')
641: )
642: then
643: hr_utility.set_message(8301, 'GHR_37040_ALL_PROCEDURE_FAIL');
644: hr_utility.raise_error;
645: end if;
646: elsif p_effective_date >= to_date('19'||'99/01/01','yyyy/mm/dd') then
647: if p_First_NOAC_Lookup_Code= '101'
648: and

Line 673: hr_utility.set_message(8301, 'GHR_37087_ALL_PROCEDURE_FAIL');

669: 'QBK','QCK','VGL','V1P','V8L','V8N','Z2U','Z2W','ZGM','ZJK','ZJM',
670: 'ZBA','ZJR','ZLM','ZQM','ZRM','ZSK','ZSP','ZTU')
671: )
672: then
673: hr_utility.set_message(8301, 'GHR_37087_ALL_PROCEDURE_FAIL');
674: hr_utility.raise_error;
675: end if;
676: else
677: if p_First_NOAC_Lookup_Code= '101'

Line 674: hr_utility.raise_error;

670: 'ZBA','ZJR','ZLM','ZQM','ZRM','ZSK','ZSP','ZTU')
671: )
672: then
673: hr_utility.set_message(8301, 'GHR_37087_ALL_PROCEDURE_FAIL');
674: hr_utility.raise_error;
675: end if;
676: else
677: if p_First_NOAC_Lookup_Code= '101'
678: and

Line 703: hr_utility.set_message(8301, 'GHR_37312_ALL_PROCEDURE_FAIL');

699: 'QBK','QCK','V1P','V8L','V8N','Z2U','Z2W','ZGM','ZJK','ZJM',
700: 'ZBA','ZJR','ZLM','ZQM','ZRM','ZSK','ZSP','ZTU')
701: )
702: then
703: hr_utility.set_message(8301, 'GHR_37312_ALL_PROCEDURE_FAIL');
704: hr_utility.raise_error;
705: end if;
706: end if;
707: -- END OF 255.04.2

Line 704: hr_utility.raise_error;

700: 'ZBA','ZJR','ZLM','ZQM','ZRM','ZSK','ZSP','ZTU')
701: )
702: then
703: hr_utility.set_message(8301, 'GHR_37312_ALL_PROCEDURE_FAIL');
704: hr_utility.raise_error;
705: end if;
706: end if;
707: -- END OF 255.04.2
708: --

Line 732: hr_utility.set_message(8301, 'GHR_37313_ALL_PROCEDURE_FAIL');

728: 'BWM','HAM','HDM','HGM','HJM','HLM','NUM',
729: 'QBK','V1P','V8N','Z2U','ZLM','ZRM','ZSK')
730: )
731: THEN
732: hr_utility.set_message(8301, 'GHR_37313_ALL_PROCEDURE_FAIL');
733: hr_utility.raise_error;
734: end if;
735: else
736: if p_First_NOAC_Lookup_Code= '107'

Line 733: hr_utility.raise_error;

729: 'QBK','V1P','V8N','Z2U','ZLM','ZRM','ZSK')
730: )
731: THEN
732: hr_utility.set_message(8301, 'GHR_37313_ALL_PROCEDURE_FAIL');
733: hr_utility.raise_error;
734: end if;
735: else
736: if p_First_NOAC_Lookup_Code= '107'
737: and

Line 750: hr_utility.set_message(8301, 'GHR_37049_ALL_PROCEDURE_FAIL');

746: 'BWM','HAM','HDM','HGM','HJM','HLM','NUM',
747: 'QBK','V1P','V8N','Z2U','ZLM','ZRM','ZSK')
748: )
749: THEN
750: hr_utility.set_message(8301, 'GHR_37049_ALL_PROCEDURE_FAIL');
751: hr_utility.raise_error;
752: end if;
753: end if;
754:

Line 751: hr_utility.raise_error;

747: 'QBK','V1P','V8N','Z2U','ZLM','ZRM','ZSK')
748: )
749: THEN
750: hr_utility.set_message(8301, 'GHR_37049_ALL_PROCEDURE_FAIL');
751: hr_utility.raise_error;
752: end if;
753: end if;
754:
755: --265.04.2

Line 788: hr_utility.set_message(8301, 'GHR_37194_ALL_PROCEDURE_FAIL');

784: 'BWA','BWM','HAM','MEM','MGM','MJM',
785: 'MLK','MLM','MMM','NUM','QAK','UDM','VGL','VJM',
786: 'V1P','V8L','V8N','Z2U','Z2W','ZJK','ZLM',
787: 'ZQM','ZRM','ZSK','ZSP','ZTM','ZTU','ZJM','Z5B', 'Z5C', 'Z5F', 'Z5H', 'Z5J') ) THEN
788: hr_utility.set_message(8301, 'GHR_37194_ALL_PROCEDURE_FAIL');
789: hr_utility.raise_error;
790: end if;
791: elsif p_effective_date >= to_date('19'||'99/02/27','yyyy/mm/dd') then
792: if p_First_NOAC_Lookup_Code= '108'

Line 789: hr_utility.raise_error;

785: 'MLK','MLM','MMM','NUM','QAK','UDM','VGL','VJM',
786: 'V1P','V8L','V8N','Z2U','Z2W','ZJK','ZLM',
787: 'ZQM','ZRM','ZSK','ZSP','ZTM','ZTU','ZJM','Z5B', 'Z5C', 'Z5F', 'Z5H', 'Z5J') ) THEN
788: hr_utility.set_message(8301, 'GHR_37194_ALL_PROCEDURE_FAIL');
789: hr_utility.raise_error;
790: end if;
791: elsif p_effective_date >= to_date('19'||'99/02/27','yyyy/mm/dd') then
792: if p_First_NOAC_Lookup_Code= '108'
793: and

Line 808: hr_utility.set_message(8301, 'GHR_37050_ALL_PROCEDURE_FAIL');

804: 'BWA','BWM','HAM','MEM','MGM','MJM',
805: 'MLK','MLM','MMM','NUM','QAK','VGL','VJM',
806: 'V1P','V8L','V8N','Z2U','Z2W','ZJK','ZLM',
807: 'ZQM','ZRM','ZSK','ZSP','ZTM','ZTU','ZJM','Z5B', 'Z5C', 'Z5F', 'Z5H', 'Z5J') ) THEN
808: hr_utility.set_message(8301, 'GHR_37050_ALL_PROCEDURE_FAIL');
809: hr_utility.raise_error;
810: end if;
811: elsif p_effective_date > to_date('19'||'99/01/31','yyyy/mm/dd') then
812: if p_First_NOAC_Lookup_Code= '108'

Line 809: hr_utility.raise_error;

805: 'MLK','MLM','MMM','NUM','QAK','VGL','VJM',
806: 'V1P','V8L','V8N','Z2U','Z2W','ZJK','ZLM',
807: 'ZQM','ZRM','ZSK','ZSP','ZTM','ZTU','ZJM','Z5B', 'Z5C', 'Z5F', 'Z5H', 'Z5J') ) THEN
808: hr_utility.set_message(8301, 'GHR_37050_ALL_PROCEDURE_FAIL');
809: hr_utility.raise_error;
810: end if;
811: elsif p_effective_date > to_date('19'||'99/01/31','yyyy/mm/dd') then
812: if p_First_NOAC_Lookup_Code= '108'
813: and

Line 828: hr_utility.set_message(8301, 'GHR_37041_ALL_PROCEDURE_FAIL');

824: 'BWA','BWM','HAM','MCM','MEM','MGM','MJM',
825: 'MLK','MLL','MLM','MMM','NUM','QAK','VGL','VJM',
826: 'V1P','V8L','V8N','Z2U','Z2W','ZJK','ZLM',
827: 'ZQM','ZRM','ZSK','ZSP','ZTM','ZTU','ZJM','Z5B', 'Z5C', 'Z5F', 'Z5H', 'Z5J') ) THEN
828: hr_utility.set_message(8301, 'GHR_37041_ALL_PROCEDURE_FAIL');
829: hr_utility.raise_error;
830: end if;
831: elsif p_effective_date >= to_date('19'||'99/01/01','yyyy/mm/dd') then
832: if p_First_NOAC_Lookup_Code= '108'

Line 829: hr_utility.raise_error;

825: 'MLK','MLL','MLM','MMM','NUM','QAK','VGL','VJM',
826: 'V1P','V8L','V8N','Z2U','Z2W','ZJK','ZLM',
827: 'ZQM','ZRM','ZSK','ZSP','ZTM','ZTU','ZJM','Z5B', 'Z5C', 'Z5F', 'Z5H', 'Z5J') ) THEN
828: hr_utility.set_message(8301, 'GHR_37041_ALL_PROCEDURE_FAIL');
829: hr_utility.raise_error;
830: end if;
831: elsif p_effective_date >= to_date('19'||'99/01/01','yyyy/mm/dd') then
832: if p_First_NOAC_Lookup_Code= '108'
833: and

Line 850: hr_utility.set_message(8301, 'GHR_37086_ALL_PROCEDURE_FAIL');

846: 'BWA','BWM','HAM','MCM','MEM','MGM','MJM',
847: 'MLK','MLL','MLM','MMM','NUM','QAK','VGL','VJM',
848: 'V1P','V8L','V8N','Z2U','Z2W','ZJK','ZLM',
849: 'ZQM','ZRM','ZSK','ZSP','ZTM','ZTU','ZJM','Z5B', 'Z5C', 'Z5F', 'Z5H', 'Z5J') ) THEN
850: hr_utility.set_message(8301, 'GHR_37086_ALL_PROCEDURE_FAIL');
851: hr_utility.raise_error;
852: end if;
853: else
854: if p_First_NOAC_Lookup_Code= '108'

Line 851: hr_utility.raise_error;

847: 'MLK','MLL','MLM','MMM','NUM','QAK','VGL','VJM',
848: 'V1P','V8L','V8N','Z2U','Z2W','ZJK','ZLM',
849: 'ZQM','ZRM','ZSK','ZSP','ZTM','ZTU','ZJM','Z5B', 'Z5C', 'Z5F', 'Z5H', 'Z5J') ) THEN
850: hr_utility.set_message(8301, 'GHR_37086_ALL_PROCEDURE_FAIL');
851: hr_utility.raise_error;
852: end if;
853: else
854: if p_First_NOAC_Lookup_Code= '108'
855: and

Line 872: hr_utility.set_message(8301, 'GHR_37314_ALL_PROCEDURE_FAIL');

868: 'BWA','BWM','HAM','MCM','MEM','MGM','MJM',
869: 'MLK','MLL','MLM','MMM','NUM','QAK','VJM',
870: 'V1P','V8L','V8N','Z2U','Z2W','ZJK','ZLM',
871: 'ZQM','ZRM','ZSK','ZSP','ZTM','ZTU','ZJM','Z5B', 'Z5C', 'Z5F', 'Z5H', 'Z5J') ) THEN
872: hr_utility.set_message(8301, 'GHR_37314_ALL_PROCEDURE_FAIL');
873: hr_utility.raise_error;
874: end if;
875: end if;
876:

Line 873: hr_utility.raise_error;

869: 'MLK','MLL','MLM','MMM','NUM','QAK','VJM',
870: 'V1P','V8L','V8N','Z2U','Z2W','ZJK','ZLM',
871: 'ZQM','ZRM','ZSK','ZSP','ZTM','ZTU','ZJM','Z5B', 'Z5C', 'Z5F', 'Z5H', 'Z5J') ) THEN
872: hr_utility.set_message(8301, 'GHR_37314_ALL_PROCEDURE_FAIL');
873: hr_utility.raise_error;
874: end if;
875: end if;
876:
877: --265.10.2

Line 915: hr_utility.set_message(8301, 'GHR_37195_ALL_PROCEDURE_FAIL');

911: 'NUM','QAK','SZX','UDM','VGL','VJM','V1P','V8L','V8N',
912: 'WTA', 'WTB','WUM',
913: 'Z2U','Z2W','ZJK','ZLM','ZQM','ZRM','ZSK',
914: 'ZSP','ZTM','ZTU','Z5B','Z5C','Z5F','Z5G','Z5H') ) THEN
915: hr_utility.set_message(8301, 'GHR_37195_ALL_PROCEDURE_FAIL');
916: hr_utility.raise_error;
917: end if;
918: elsif p_effective_date > to_date('19'||'99/02/28','yyyy/mm/dd') then
919: if p_First_NOAC_Lookup_Code= '115'

Line 916: hr_utility.raise_error;

912: 'WTA', 'WTB','WUM',
913: 'Z2U','Z2W','ZJK','ZLM','ZQM','ZRM','ZSK',
914: 'ZSP','ZTM','ZTU','Z5B','Z5C','Z5F','Z5G','Z5H') ) THEN
915: hr_utility.set_message(8301, 'GHR_37195_ALL_PROCEDURE_FAIL');
916: hr_utility.raise_error;
917: end if;
918: elsif p_effective_date > to_date('19'||'99/02/28','yyyy/mm/dd') then
919: if p_First_NOAC_Lookup_Code= '115'
920: and

Line 939: hr_utility.set_message(8301, 'GHR_37051_ALL_PROCEDURE_FAIL');

935: 'NUM','QAK','SZX','VGL','VJM','V1P','V8L','V8N',
936: 'WTA', 'WTB','WUM',
937: 'Z2U','Z2W','ZJK','ZLM','ZQM','ZRM','ZSK',
938: 'ZSP','ZTM','ZTU','Z5B','Z5C','Z5F','Z5G','Z5H') ) THEN
939: hr_utility.set_message(8301, 'GHR_37051_ALL_PROCEDURE_FAIL');
940: hr_utility.raise_error;
941: end if;
942: elsif p_effective_date > to_date('19'||'99/01/31','yyyy/mm/dd') then
943: if p_First_NOAC_Lookup_Code= '115'

Line 940: hr_utility.raise_error;

936: 'WTA', 'WTB','WUM',
937: 'Z2U','Z2W','ZJK','ZLM','ZQM','ZRM','ZSK',
938: 'ZSP','ZTM','ZTU','Z5B','Z5C','Z5F','Z5G','Z5H') ) THEN
939: hr_utility.set_message(8301, 'GHR_37051_ALL_PROCEDURE_FAIL');
940: hr_utility.raise_error;
941: end if;
942: elsif p_effective_date > to_date('19'||'99/01/31','yyyy/mm/dd') then
943: if p_First_NOAC_Lookup_Code= '115'
944: and

Line 963: hr_utility.set_message(8301, 'GHR_37042_ALL_PROCEDURE_FAIL');

959: 'NUM','QAK','SZX','VGL','VJM','V1P','V8L','V8N',
960: 'WTA', 'WTB','WUM',
961: 'Z2U','Z2W','ZJK','ZLM','ZQM','ZRM','ZSK',
962: 'ZSP','ZTM','ZTU','Z5B','Z5C','Z5F','Z5G','Z5H') ) THEN
963: hr_utility.set_message(8301, 'GHR_37042_ALL_PROCEDURE_FAIL');
964: hr_utility.raise_error;
965: end if;
966: elsif p_effective_date >= to_date('19'||'99/01/01','yyyy/mm/dd') then
967: if p_First_NOAC_Lookup_Code= '115'

Line 964: hr_utility.raise_error;

960: 'WTA', 'WTB','WUM',
961: 'Z2U','Z2W','ZJK','ZLM','ZQM','ZRM','ZSK',
962: 'ZSP','ZTM','ZTU','Z5B','Z5C','Z5F','Z5G','Z5H') ) THEN
963: hr_utility.set_message(8301, 'GHR_37042_ALL_PROCEDURE_FAIL');
964: hr_utility.raise_error;
965: end if;
966: elsif p_effective_date >= to_date('19'||'99/01/01','yyyy/mm/dd') then
967: if p_First_NOAC_Lookup_Code= '115'
968: and

Line 989: hr_utility.set_message(8301, 'GHR_37089_ALL_PROCEDURE_FAIL');

985: 'NUM','QAK','SZX','VGL','VJM','V1P','V8L','V8N',
986: 'WTA', 'WTB','WUM',
987: 'Z2U','Z2W','ZJK','ZLM','ZQM','ZRM','ZSK',
988: 'ZSP','ZTM','ZTU','Z5B','Z5C','Z5F','Z5G','Z5H') ) THEN
989: hr_utility.set_message(8301, 'GHR_37089_ALL_PROCEDURE_FAIL');
990: hr_utility.raise_error;
991: end if;
992: else
993: if p_First_NOAC_Lookup_Code= '115'

Line 990: hr_utility.raise_error;

986: 'WTA', 'WTB','WUM',
987: 'Z2U','Z2W','ZJK','ZLM','ZQM','ZRM','ZSK',
988: 'ZSP','ZTM','ZTU','Z5B','Z5C','Z5F','Z5G','Z5H') ) THEN
989: hr_utility.set_message(8301, 'GHR_37089_ALL_PROCEDURE_FAIL');
990: hr_utility.raise_error;
991: end if;
992: else
993: if p_First_NOAC_Lookup_Code= '115'
994: and

Line 1015: hr_utility.set_message(8301, 'GHR_37316_ALL_PROCEDURE_FAIL');

1011: 'NUM','QAK','SZX','VJM','V1P','V8L','V8N',
1012: 'WTA', 'WTB','WUM',
1013: 'Z2U','Z2W','ZJK','ZLM','ZQM','ZRM','ZSK',
1014: 'ZSP','ZTM','ZTU','Z5B','Z5C','Z5F','Z5G','Z5H') ) THEN
1015: hr_utility.set_message(8301, 'GHR_37316_ALL_PROCEDURE_FAIL');
1016: hr_utility.raise_error;
1017: end if;
1018: end if;
1019:

Line 1016: hr_utility.raise_error;

1012: 'WTA', 'WTB','WUM',
1013: 'Z2U','Z2W','ZJK','ZLM','ZQM','ZRM','ZSK',
1014: 'ZSP','ZTM','ZTU','Z5B','Z5C','Z5F','Z5G','Z5H') ) THEN
1015: hr_utility.set_message(8301, 'GHR_37316_ALL_PROCEDURE_FAIL');
1016: hr_utility.raise_error;
1017: end if;
1018: end if;
1019:
1020: --265.07.2

Line 1047: hr_utility.set_message(8301, 'GHR_37088_ALL_PROCEDURE_FAIL');

1043: 'ZRM','ZSK','ZSP','ZTM','ZTU') OR
1044: (SUBSTR(p_First_Action_NOA_LA_Code1,1,1) = 'X' AND
1045: LENGTH(p_First_Action_NOA_LA_Code1) =3 )))
1046: THEN
1047: hr_utility.set_message(8301, 'GHR_37088_ALL_PROCEDURE_FAIL');
1048: hr_utility.raise_error;
1049: END IF;
1050: ELSE
1051: if p_First_NOAC_Lookup_Code= '112'

Line 1048: hr_utility.raise_error;

1044: (SUBSTR(p_First_Action_NOA_LA_Code1,1,1) = 'X' AND
1045: LENGTH(p_First_Action_NOA_LA_Code1) =3 )))
1046: THEN
1047: hr_utility.set_message(8301, 'GHR_37088_ALL_PROCEDURE_FAIL');
1048: hr_utility.raise_error;
1049: END IF;
1050: ELSE
1051: if p_First_NOAC_Lookup_Code= '112'
1052: and

Line 1067: hr_utility.set_message(8301, 'GHR_37315_ALL_PROCEDURE_FAIL');

1063: 'ZRM','ZSK','ZSP','ZTM','ZTU') OR
1064: (SUBSTR(p_First_Action_NOA_LA_Code1,1,1) = 'X' AND
1065: LENGTH(p_First_Action_NOA_LA_Code1) =3 )))
1066: THEN
1067: hr_utility.set_message(8301, 'GHR_37315_ALL_PROCEDURE_FAIL');
1068: hr_utility.raise_error;
1069: end if;
1070: END IF;
1071: END IF; -- CHECK for end date

Line 1068: hr_utility.raise_error;

1064: (SUBSTR(p_First_Action_NOA_LA_Code1,1,1) = 'X' AND
1065: LENGTH(p_First_Action_NOA_LA_Code1) =3 )))
1066: THEN
1067: hr_utility.set_message(8301, 'GHR_37315_ALL_PROCEDURE_FAIL');
1068: hr_utility.raise_error;
1069: end if;
1070: END IF;
1071: END IF; -- CHECK for end date
1072:

Line 1083: hr_utility.set_message(8301, 'GHR_37318_ALL_PROCEDURE_FAIL');

1079: AND p_First_Action_NOA_LA_Code2 in
1080: ('ABM','ALM','AQM','AYM','BWM','HAM','HNM','HRM',
1081: 'QAK','QBK','QCK','V1P','ZLM','ZRM','ZSK','Z5C')
1082: ) THEN
1083: hr_utility.set_message(8301, 'GHR_37318_ALL_PROCEDURE_FAIL');
1084: hr_utility.raise_error;
1085: end if;
1086:
1087: --270.07.2

Line 1084: hr_utility.raise_error;

1080: ('ABM','ALM','AQM','AYM','BWM','HAM','HNM','HRM',
1081: 'QAK','QBK','QCK','V1P','ZLM','ZRM','ZSK','Z5C')
1082: ) THEN
1083: hr_utility.set_message(8301, 'GHR_37318_ALL_PROCEDURE_FAIL');
1084: hr_utility.raise_error;
1085: end if;
1086:
1087: --270.07.2
1088: if p_First_NOAC_Lookup_Code= '122'

Line 1096: hr_utility.set_message(8301, 'GHR_37319_ALL_PROCEDURE_FAIL');

1092: 'H3M','QAK','V1P','ZLM','ZRM','ZSK') AND
1093: p_First_Action_NOA_LA_Code2 in
1094: ('ABM','ALM','BWM','HAM','HNM','HRM',
1095: 'H3M','QAK','V1P','ZLM','ZRM','ZSK') ) THEN
1096: hr_utility.set_message(8301, 'GHR_37319_ALL_PROCEDURE_FAIL');
1097: hr_utility.raise_error;
1098: end if;
1099:
1100: --270.10.2

Line 1097: hr_utility.raise_error;

1093: p_First_Action_NOA_LA_Code2 in
1094: ('ABM','ALM','BWM','HAM','HNM','HRM',
1095: 'H3M','QAK','V1P','ZLM','ZRM','ZSK') ) THEN
1096: hr_utility.set_message(8301, 'GHR_37319_ALL_PROCEDURE_FAIL');
1097: hr_utility.raise_error;
1098: end if;
1099:
1100: --270.10.2
1101: if p_First_NOAC_Lookup_Code= '124'

Line 1109: hr_utility.set_message(8301, 'GHR_37320_ALL_PROCEDURE_FAIL');

1105: 'NJM','NMM','QAK','QBK','QCK','V1P','ZLM','ZRM','ZSK') AND
1106: p_First_Action_NOA_LA_Code2 in
1107: ('ABM','ALM','AQM','A7M','BWM','HAM','LBM','NFM',
1108: 'NJM','NMM','QAK','QBK','QCK','V1P','ZLM','ZRM','ZSK') ) THEN
1109: hr_utility.set_message(8301, 'GHR_37320_ALL_PROCEDURE_FAIL');
1110: hr_utility.raise_error;
1111: end if;
1112:
1113: --275.01.2

Line 1110: hr_utility.raise_error;

1106: p_First_Action_NOA_LA_Code2 in
1107: ('ABM','ALM','AQM','A7M','BWM','HAM','LBM','NFM',
1108: 'NJM','NMM','QAK','QBK','QCK','V1P','ZLM','ZRM','ZSK') ) THEN
1109: hr_utility.set_message(8301, 'GHR_37320_ALL_PROCEDURE_FAIL');
1110: hr_utility.raise_error;
1111: end if;
1112:
1113: --275.01.2
1114: -- added effective date

Line 1125: hr_utility.set_message(8301, 'GHR_37321_ALL_PROCEDURE_FAIL');

1121: 'V1P','V8N','Z2U','ZSK','ZSP') AND
1122: p_First_Action_NOA_LA_Code2 in
1123: ('ABS','ABT','J8M','KTM','KVM','KXM','SZT',
1124: 'V1P','V8N','Z2U','ZSK','ZSP') ) THEN
1125: hr_utility.set_message(8301, 'GHR_37321_ALL_PROCEDURE_FAIL');
1126: hr_utility.raise_error;
1127: end if;
1128: end if;
1129:

Line 1126: hr_utility.raise_error;

1122: p_First_Action_NOA_LA_Code2 in
1123: ('ABS','ABT','J8M','KTM','KVM','KXM','SZT',
1124: 'V1P','V8N','Z2U','ZSK','ZSP') ) THEN
1125: hr_utility.set_message(8301, 'GHR_37321_ALL_PROCEDURE_FAIL');
1126: hr_utility.raise_error;
1127: end if;
1128: end if;
1129:
1130: --275.02.2

Line 1147: hr_utility.set_message(8301, 'GHR_37196_ALL_PROCEDURE_FAIL');

1143: 'UDM','V1P','V8N','VGL','Z2U','ZSK','ZSP') AND
1144: p_First_Action_NOA_LA_Code2 in
1145: ('ABR','ABS','ABT','J8M','KTM','KVM','KXM','SZT',
1146: 'UDM','V1P','V8N','VGL','Z2U','ZSK','ZSP') ) THEN
1147: hr_utility.set_message(8301, 'GHR_37196_ALL_PROCEDURE_FAIL');
1148: hr_utility.raise_error;
1149: end if;
1150: elsif p_effective_date >= to_date('19'||'99/01/01','yyyy/mm/dd') then
1151: if p_First_NOAC_Lookup_Code= '130'

Line 1148: hr_utility.raise_error;

1144: p_First_Action_NOA_LA_Code2 in
1145: ('ABR','ABS','ABT','J8M','KTM','KVM','KXM','SZT',
1146: 'UDM','V1P','V8N','VGL','Z2U','ZSK','ZSP') ) THEN
1147: hr_utility.set_message(8301, 'GHR_37196_ALL_PROCEDURE_FAIL');
1148: hr_utility.raise_error;
1149: end if;
1150: elsif p_effective_date >= to_date('19'||'99/01/01','yyyy/mm/dd') then
1151: if p_First_NOAC_Lookup_Code= '130'
1152: and

Line 1159: hr_utility.set_message(8301, 'GHR_37090_ALL_PROCEDURE_FAIL');

1155: 'V1P','V8N','VGL','Z2U','ZSK','ZSP') AND
1156: p_First_Action_NOA_LA_Code2 in
1157: ('ABR','ABS','ABT','J8M','KTM','KVM','KXM','SZT',
1158: 'V1P','V8N','VGL','Z2U','ZSK','ZSP') ) THEN
1159: hr_utility.set_message(8301, 'GHR_37090_ALL_PROCEDURE_FAIL');
1160: hr_utility.raise_error;
1161: end if;
1162: elsif p_effective_date >= to_date('1998/03/01','yyyy/mm/dd') then
1163: if p_First_NOAC_Lookup_Code= '130'

Line 1160: hr_utility.raise_error;

1156: p_First_Action_NOA_LA_Code2 in
1157: ('ABR','ABS','ABT','J8M','KTM','KVM','KXM','SZT',
1158: 'V1P','V8N','VGL','Z2U','ZSK','ZSP') ) THEN
1159: hr_utility.set_message(8301, 'GHR_37090_ALL_PROCEDURE_FAIL');
1160: hr_utility.raise_error;
1161: end if;
1162: elsif p_effective_date >= to_date('1998/03/01','yyyy/mm/dd') then
1163: if p_First_NOAC_Lookup_Code= '130'
1164: and

Line 1171: hr_utility.set_message(8301, 'GHR_37884_ALL_PROCEDURE_FAIL');

1167: 'V1P','V8N','Z2U','ZSK','ZSP') AND
1168: p_First_Action_NOA_LA_Code2 in
1169: ('ABR','ABS','ABT','J8M','KTM','KVM','KXM','SZT',
1170: 'V1P','V8N','Z2U','ZSK','ZSP') ) THEN
1171: hr_utility.set_message(8301, 'GHR_37884_ALL_PROCEDURE_FAIL');
1172: hr_utility.raise_error;
1173: end if;
1174: end if;
1175:

Line 1172: hr_utility.raise_error;

1168: p_First_Action_NOA_LA_Code2 in
1169: ('ABR','ABS','ABT','J8M','KTM','KVM','KXM','SZT',
1170: 'V1P','V8N','Z2U','ZSK','ZSP') ) THEN
1171: hr_utility.set_message(8301, 'GHR_37884_ALL_PROCEDURE_FAIL');
1172: hr_utility.raise_error;
1173: end if;
1174: end if;
1175:
1176: --275.04.2

Line 1183: hr_utility.set_message(8301, 'GHR_37322_ALL_PROCEDURE_FAIL');

1179: NOT ( p_First_Action_NOA_LA_Code1 in
1180: ('V1P','V6M','ZLM') AND
1181: p_First_Action_NOA_LA_Code2 in
1182: ('V1P','V6M','ZLM') ) THEN
1183: hr_utility.set_message(8301, 'GHR_37322_ALL_PROCEDURE_FAIL');
1184: hr_utility.raise_error;
1185: end if;
1186:
1187: --280.02.2

Line 1184: hr_utility.raise_error;

1180: ('V1P','V6M','ZLM') AND
1181: p_First_Action_NOA_LA_Code2 in
1182: ('V1P','V6M','ZLM') ) THEN
1183: hr_utility.set_message(8301, 'GHR_37322_ALL_PROCEDURE_FAIL');
1184: hr_utility.raise_error;
1185: end if;
1186:
1187: --280.02.2
1188: -- 10/4 08/13/99 vravikan 01-Jan-99 Add VGL

Line 1202: hr_utility.set_message(8301, 'GHR_37197_ALL_PROCEDURE_FAIL');

1198: 'NUM','SZW','UDM','V1P','V8N','VGL','Z2U','ZLM','ZSK','ZSP') AND
1199: p_First_Action_NOA_LA_Code2 in
1200: ('ABL','ABM','ABR','ABS','BWM','HAM','KQM',
1201: 'NUM','SZW','UDM','V1P','V8N','VGL','Z2U','ZLM','ZSK','ZSP') ) THEN
1202: hr_utility.set_message(8301, 'GHR_37197_ALL_PROCEDURE_FAIL');
1203: hr_utility.raise_error;
1204: end if;
1205: elsif p_effective_date >= to_date('19'||'99/01/01','yyyy/mm/dd') then
1206: if p_First_NOAC_Lookup_Code= '140'

Line 1203: hr_utility.raise_error;

1199: p_First_Action_NOA_LA_Code2 in
1200: ('ABL','ABM','ABR','ABS','BWM','HAM','KQM',
1201: 'NUM','SZW','UDM','V1P','V8N','VGL','Z2U','ZLM','ZSK','ZSP') ) THEN
1202: hr_utility.set_message(8301, 'GHR_37197_ALL_PROCEDURE_FAIL');
1203: hr_utility.raise_error;
1204: end if;
1205: elsif p_effective_date >= to_date('19'||'99/01/01','yyyy/mm/dd') then
1206: if p_First_NOAC_Lookup_Code= '140'
1207: and

Line 1214: hr_utility.set_message(8301, 'GHR_37091_ALL_PROCEDURE_FAIL');

1210: 'NUM','SZW','V1P','V8N','VGL','Z2U','ZLM','ZSK','ZSP') AND
1211: p_First_Action_NOA_LA_Code2 in
1212: ('ABL','ABM','ABR','ABS','BWM','HAM','KQM',
1213: 'NUM','SZW','V1P','V8N','VGL','Z2U','ZLM','ZSK','ZSP') ) THEN
1214: hr_utility.set_message(8301, 'GHR_37091_ALL_PROCEDURE_FAIL');
1215: hr_utility.raise_error;
1216: end if;
1217: else
1218: if p_First_NOAC_Lookup_Code= '140'

Line 1215: hr_utility.raise_error;

1211: p_First_Action_NOA_LA_Code2 in
1212: ('ABL','ABM','ABR','ABS','BWM','HAM','KQM',
1213: 'NUM','SZW','V1P','V8N','VGL','Z2U','ZLM','ZSK','ZSP') ) THEN
1214: hr_utility.set_message(8301, 'GHR_37091_ALL_PROCEDURE_FAIL');
1215: hr_utility.raise_error;
1216: end if;
1217: else
1218: if p_First_NOAC_Lookup_Code= '140'
1219: and

Line 1226: hr_utility.set_message(8301, 'GHR_37323_ALL_PROCEDURE_FAIL');

1222: 'NUM','SZW','V1P','V8N','Z2U','ZLM','ZSK','ZSP') AND
1223: p_First_Action_NOA_LA_Code2 in
1224: ('ABL','ABM','ABR','ABS','BWM','HAM','KQM',
1225: 'NUM','SZW','V1P','V8N','Z2U','ZLM','ZSK','ZSP') ) THEN
1226: hr_utility.set_message(8301, 'GHR_37323_ALL_PROCEDURE_FAIL');
1227: hr_utility.raise_error;
1228: end if;
1229: end if;
1230:

Line 1227: hr_utility.raise_error;

1223: p_First_Action_NOA_LA_Code2 in
1224: ('ABL','ABM','ABR','ABS','BWM','HAM','KQM',
1225: 'NUM','SZW','V1P','V8N','Z2U','ZLM','ZSK','ZSP') ) THEN
1226: hr_utility.set_message(8301, 'GHR_37323_ALL_PROCEDURE_FAIL');
1227: hr_utility.raise_error;
1228: end if;
1229: end if;
1230:
1231: --280.04.2

Line 1245: hr_utility.set_message(8301, 'GHR_37198_ALL_PROCEDURE_FAIL');

1241: 'NUM','UDM','V1P','V8N','VGL','Z2U','ZLM','ZSK','ZSP') AND
1242: p_First_Action_NOA_LA_Code2 in
1243: ('ABL','ABM','ABR','ABS','BWM','HAM','KQM',
1244: 'NUM','UDM','V1P','V8N','VGL','Z2U','ZLM','ZSK','ZSP') ) THEN
1245: hr_utility.set_message(8301, 'GHR_37198_ALL_PROCEDURE_FAIL');
1246: hr_utility.raise_error;
1247: end if;
1248: elsif p_effective_date >= to_date('19'||'99/01/01','yyyy/mm/dd') then
1249: if p_First_NOAC_Lookup_Code= '141'

Line 1246: hr_utility.raise_error;

1242: p_First_Action_NOA_LA_Code2 in
1243: ('ABL','ABM','ABR','ABS','BWM','HAM','KQM',
1244: 'NUM','UDM','V1P','V8N','VGL','Z2U','ZLM','ZSK','ZSP') ) THEN
1245: hr_utility.set_message(8301, 'GHR_37198_ALL_PROCEDURE_FAIL');
1246: hr_utility.raise_error;
1247: end if;
1248: elsif p_effective_date >= to_date('19'||'99/01/01','yyyy/mm/dd') then
1249: if p_First_NOAC_Lookup_Code= '141'
1250: and

Line 1257: hr_utility.set_message(8301, 'GHR_37092_ALL_PROCEDURE_FAIL');

1253: 'NUM','V1P','V8N','VGL','Z2U','ZLM','ZSK','ZSP') AND
1254: p_First_Action_NOA_LA_Code2 in
1255: ('ABL','ABM','ABR','ABS','BWM','HAM','KQM',
1256: 'NUM','V1P','V8N','VGL','Z2U','ZLM','ZSK','ZSP') ) THEN
1257: hr_utility.set_message(8301, 'GHR_37092_ALL_PROCEDURE_FAIL');
1258: hr_utility.raise_error;
1259: end if;
1260: else
1261: if p_First_NOAC_Lookup_Code= '141'

Line 1258: hr_utility.raise_error;

1254: p_First_Action_NOA_LA_Code2 in
1255: ('ABL','ABM','ABR','ABS','BWM','HAM','KQM',
1256: 'NUM','V1P','V8N','VGL','Z2U','ZLM','ZSK','ZSP') ) THEN
1257: hr_utility.set_message(8301, 'GHR_37092_ALL_PROCEDURE_FAIL');
1258: hr_utility.raise_error;
1259: end if;
1260: else
1261: if p_First_NOAC_Lookup_Code= '141'
1262: and

Line 1269: hr_utility.set_message(8301, 'GHR_37324_ALL_PROCEDURE_FAIL');

1265: 'NUM','V1P','V8N','Z2U','ZLM','ZSK','ZSP') AND
1266: p_First_Action_NOA_LA_Code2 in
1267: ('ABL','ABM','ABR','ABS','BWM','HAM','KQM',
1268: 'NUM','V1P','V8N','Z2U','ZLM','ZSK','ZSP') ) THEN
1269: hr_utility.set_message(8301, 'GHR_37324_ALL_PROCEDURE_FAIL');
1270: hr_utility.raise_error;
1271: end if;
1272: end if;
1273:

Line 1270: hr_utility.raise_error;

1266: p_First_Action_NOA_LA_Code2 in
1267: ('ABL','ABM','ABR','ABS','BWM','HAM','KQM',
1268: 'NUM','V1P','V8N','Z2U','ZLM','ZSK','ZSP') ) THEN
1269: hr_utility.set_message(8301, 'GHR_37324_ALL_PROCEDURE_FAIL');
1270: hr_utility.raise_error;
1271: end if;
1272: end if;
1273:
1274: --280.07.2

Line 1287: hr_utility.set_message(8301, 'GHR_37325_ALL_PROCEDURE_FAIL');

1283: 'ZLM','ZSK','ZVB','ZVC') AND
1284: p_First_Action_NOA_LA_Code2 in
1285: ('HAM','P3M','P5M','UFM','V2M','ZJR',
1286: 'ZLM','ZSK','ZVB','ZVC') ) THEN
1287: hr_utility.set_message(8301, 'GHR_37325_ALL_PROCEDURE_FAIL');
1288: hr_utility.raise_error;
1289: end if;
1290: elsif p_effective_date < to_date('2001/11/01','yyyy/mm/dd') then
1291: if p_First_NOAC_Lookup_Code= '142'

Line 1288: hr_utility.raise_error;

1284: p_First_Action_NOA_LA_Code2 in
1285: ('HAM','P3M','P5M','UFM','V2M','ZJR',
1286: 'ZLM','ZSK','ZVB','ZVC') ) THEN
1287: hr_utility.set_message(8301, 'GHR_37325_ALL_PROCEDURE_FAIL');
1288: hr_utility.raise_error;
1289: end if;
1290: elsif p_effective_date < to_date('2001/11/01','yyyy/mm/dd') then
1291: if p_First_NOAC_Lookup_Code= '142'
1292: and

Line 1299: hr_utility.set_message(8301, 'GHR_37036_ALL_PROCEDURE_FAIL');

1295: 'ZLM','ZSK','ZVB','ZVC') AND
1296: p_First_Action_NOA_LA_Code2 in
1297: ('HAM','P2M','P3M','P5M','P7M','UFM','V2M','ZJR',
1298: 'ZLM','ZSK','ZVB','ZVC') ) THEN
1299: hr_utility.set_message(8301, 'GHR_37036_ALL_PROCEDURE_FAIL');
1300: hr_utility.raise_error;
1301: end if;
1302: else
1303: if p_First_NOAC_Lookup_Code= '142'

Line 1300: hr_utility.raise_error;

1296: p_First_Action_NOA_LA_Code2 in
1297: ('HAM','P2M','P3M','P5M','P7M','UFM','V2M','ZJR',
1298: 'ZLM','ZSK','ZVB','ZVC') ) THEN
1299: hr_utility.set_message(8301, 'GHR_37036_ALL_PROCEDURE_FAIL');
1300: hr_utility.raise_error;
1301: end if;
1302: else
1303: if p_First_NOAC_Lookup_Code= '142'
1304: and

Line 1311: hr_utility.set_message(8301, 'GHR_37906_ALL_PROCEDURE_FAIL');

1307: 'ZLM','ZSK','ZVB','ZVC') AND
1308: p_First_Action_NOA_LA_Code2 in
1309: ('HAM','P2M','P3M','P5M','P7M','UFM','V2M','ZJR',
1310: 'ZLM','ZSK','ZVB','ZVC') ) THEN
1311: hr_utility.set_message(8301, 'GHR_37906_ALL_PROCEDURE_FAIL');
1312: hr_utility.raise_error;
1313: end if;
1314: end if;
1315:

Line 1312: hr_utility.raise_error;

1308: p_First_Action_NOA_LA_Code2 in
1309: ('HAM','P2M','P3M','P5M','P7M','UFM','V2M','ZJR',
1310: 'ZLM','ZSK','ZVB','ZVC') ) THEN
1311: hr_utility.set_message(8301, 'GHR_37906_ALL_PROCEDURE_FAIL');
1312: hr_utility.raise_error;
1313: end if;
1314: end if;
1315:
1316: --280.10.2

Line 1327: hr_utility.set_message(8301, 'GHR_37326_ALL_PROCEDURE_FAIL');

1323: 'ZLM','ZSK','ZVB','ZVC') AND
1324: p_First_Action_NOA_LA_Code2 in
1325: ('HAM','UFM','VBJ','VCJ',
1326: 'ZLM','ZSK','ZVB','ZVC') ) THEN
1327: hr_utility.set_message(8301, 'GHR_37326_ALL_PROCEDURE_FAIL');
1328: hr_utility.raise_error;
1329: end if;
1330: else
1331: if p_First_NOAC_Lookup_Code= '143'

Line 1328: hr_utility.raise_error;

1324: p_First_Action_NOA_LA_Code2 in
1325: ('HAM','UFM','VBJ','VCJ',
1326: 'ZLM','ZSK','ZVB','ZVC') ) THEN
1327: hr_utility.set_message(8301, 'GHR_37326_ALL_PROCEDURE_FAIL');
1328: hr_utility.raise_error;
1329: end if;
1330: else
1331: if p_First_NOAC_Lookup_Code= '143'
1332: and

Line 1339: hr_utility.set_message(8301, 'GHR_37905_ALL_PROCEDURE_FAIL');

1335: 'ZLM','ZSK','ZVB','ZVC') AND
1336: p_First_Action_NOA_LA_Code2 in
1337: ('HAM','UFM','VBJ','VCJ',
1338: 'ZLM','ZSK','ZVB','ZVC') ) THEN
1339: hr_utility.set_message(8301, 'GHR_37905_ALL_PROCEDURE_FAIL');
1340: hr_utility.raise_error;
1341: end if;
1342: end if;
1343:

Line 1340: hr_utility.raise_error;

1336: p_First_Action_NOA_LA_Code2 in
1337: ('HAM','UFM','VBJ','VCJ',
1338: 'ZLM','ZSK','ZVB','ZVC') ) THEN
1339: hr_utility.set_message(8301, 'GHR_37905_ALL_PROCEDURE_FAIL');
1340: hr_utility.raise_error;
1341: end if;
1342: end if;
1343:
1344: --280.13.2

Line 1355: hr_utility.set_message(8301, 'GHR_37327_ALL_PROCEDURE_FAIL');

1351: 'ZLM','ZSK','ZVB','ZVC') AND
1352: p_First_Action_NOA_LA_Code2 in
1353: ('HAM','UFM','V6M',
1354: 'ZLM','ZSK','ZVB','ZVC') ) THEN
1355: hr_utility.set_message(8301, 'GHR_37327_ALL_PROCEDURE_FAIL');
1356: hr_utility.raise_error;
1357: end if;
1358: else
1359: if p_First_NOAC_Lookup_Code= '145'

Line 1356: hr_utility.raise_error;

1352: p_First_Action_NOA_LA_Code2 in
1353: ('HAM','UFM','V6M',
1354: 'ZLM','ZSK','ZVB','ZVC') ) THEN
1355: hr_utility.set_message(8301, 'GHR_37327_ALL_PROCEDURE_FAIL');
1356: hr_utility.raise_error;
1357: end if;
1358: else
1359: if p_First_NOAC_Lookup_Code= '145'
1360: and

Line 1367: hr_utility.set_message(8301, 'GHR_37904_ALL_PROCEDURE_FAIL');

1363: 'ZLM','ZSK','ZVB','ZVC') AND
1364: p_First_Action_NOA_LA_Code2 in
1365: ('HAM','UFM','V6M',
1366: 'ZLM','ZSK','ZVB','ZVC') ) THEN
1367: hr_utility.set_message(8301, 'GHR_37904_ALL_PROCEDURE_FAIL');
1368: hr_utility.raise_error;
1369: end if;
1370: end if;
1371:

Line 1368: hr_utility.raise_error;

1364: p_First_Action_NOA_LA_Code2 in
1365: ('HAM','UFM','V6M',
1366: 'ZLM','ZSK','ZVB','ZVC') ) THEN
1367: hr_utility.set_message(8301, 'GHR_37904_ALL_PROCEDURE_FAIL');
1368: hr_utility.raise_error;
1369: end if;
1370: end if;
1371:
1372: -- 07/10/02 vravikan From the Start Added ZVC

Line 1382: hr_utility.set_message(8301, 'GHR_37328_ALL_PROCEDURE_FAIL');

1378: 'ZLM','ZSK','ZVB','ZVC') AND
1379: p_First_Action_NOA_LA_Code2 in
1380: ('AWM','HAM','UFM','V4L','ZJR',
1381: 'ZLM','ZSK','ZVB','ZVC') ) THEN
1382: hr_utility.set_message(8301, 'GHR_37328_ALL_PROCEDURE_FAIL');
1383: hr_utility.raise_error;
1384: end if;
1385:
1386: --280.19.2

Line 1383: hr_utility.raise_error;

1379: p_First_Action_NOA_LA_Code2 in
1380: ('AWM','HAM','UFM','V4L','ZJR',
1381: 'ZLM','ZSK','ZVB','ZVC') ) THEN
1382: hr_utility.set_message(8301, 'GHR_37328_ALL_PROCEDURE_FAIL');
1383: hr_utility.raise_error;
1384: end if;
1385:
1386: --280.19.2
1387: if p_First_NOAC_Lookup_Code= '147'

Line 1395: hr_utility.set_message(8301, 'GHR_37329_ALL_PROCEDURE_FAIL');

1391: 'ZLM','ZSK','ZVB','ZVC') AND
1392: p_First_Action_NOA_LA_Code2 in
1393: ('AWM','HAM','UFM','VAG',
1394: 'ZLM','ZSK','ZVB','ZVC') ) THEN
1395: hr_utility.set_message(8301, 'GHR_37329_ALL_PROCEDURE_FAIL');
1396: hr_utility.raise_error;
1397: end if;
1398:
1399: --280.22.2

Line 1396: hr_utility.raise_error;

1392: p_First_Action_NOA_LA_Code2 in
1393: ('AWM','HAM','UFM','VAG',
1394: 'ZLM','ZSK','ZVB','ZVC') ) THEN
1395: hr_utility.set_message(8301, 'GHR_37329_ALL_PROCEDURE_FAIL');
1396: hr_utility.raise_error;
1397: end if;
1398:
1399: --280.22.2
1400: if p_First_NOAC_Lookup_Code= '148'

Line 1408: hr_utility.set_message(8301, 'GHR_37330_ALL_PROCEDURE_FAIL');

1404: 'ZLM','ZSK','ZVB','ZVC') AND
1405: p_First_Action_NOA_LA_Code2 in
1406: ('AWM','HAM','UFM','V4M',
1407: 'ZLM','ZSK','ZVB','ZVC') ) THEN
1408: hr_utility.set_message(8301, 'GHR_37330_ALL_PROCEDURE_FAIL');
1409: hr_utility.raise_error;
1410: end if;
1411:
1412: --280.25.2

Line 1409: hr_utility.raise_error;

1405: p_First_Action_NOA_LA_Code2 in
1406: ('AWM','HAM','UFM','V4M',
1407: 'ZLM','ZSK','ZVB','ZVC') ) THEN
1408: hr_utility.set_message(8301, 'GHR_37330_ALL_PROCEDURE_FAIL');
1409: hr_utility.raise_error;
1410: end if;
1411:
1412: --280.25.2
1413: if p_First_NOAC_Lookup_Code= '149'

Line 1421: hr_utility.set_message(8301, 'GHR_37331_ALL_PROCEDURE_FAIL');

1417: 'ZLM','ZSK','ZVB','ZVC') AND
1418: p_First_Action_NOA_LA_Code2 in
1419: ('AWM','HAM','UFM','V4P',
1420: 'ZLM','ZSK','ZVB','ZVC') ) THEN
1421: hr_utility.set_message(8301, 'GHR_37331_ALL_PROCEDURE_FAIL');
1422: hr_utility.raise_error;
1423: end if;
1424:
1425: /* Commented -- Dec 2001 Patch

Line 1422: hr_utility.raise_error;

1418: p_First_Action_NOA_LA_Code2 in
1419: ('AWM','HAM','UFM','V4P',
1420: 'ZLM','ZSK','ZVB','ZVC') ) THEN
1421: hr_utility.set_message(8301, 'GHR_37331_ALL_PROCEDURE_FAIL');
1422: hr_utility.raise_error;
1423: end if;
1424:
1425: /* Commented -- Dec 2001 Patch
1426: --285.02.2

Line 1436: hr_utility.set_message(8301, 'GHR_37332_ALL_PROCEDURE_FAIL');

1432: 'ZLM','ZRM','ZSK') AND
1433: p_First_Action_NOA_LA_Code2 in
1434: ('ALM','AQM','HAM','PWM','P3M','P5M','QAK','QBK','QCK','TJK','TRK','ZJR',
1435: 'ZLM','ZRM','ZSK') ) THEN
1436: hr_utility.set_message(8301, 'GHR_37332_ALL_PROCEDURE_FAIL');
1437: hr_utility.raise_error;
1438: end if;
1439: */
1440:

Line 1437: hr_utility.raise_error;

1433: p_First_Action_NOA_LA_Code2 in
1434: ('ALM','AQM','HAM','PWM','P3M','P5M','QAK','QBK','QCK','TJK','TRK','ZJR',
1435: 'ZLM','ZRM','ZSK') ) THEN
1436: hr_utility.set_message(8301, 'GHR_37332_ALL_PROCEDURE_FAIL');
1437: hr_utility.raise_error;
1438: end if;
1439: */
1440:
1441: /* Commented -- Dec 2001 Patch

Line 1451: hr_utility.set_message(8301, 'GHR_37333_ALL_PROCEDURE_FAIL');

1447: 'ZRM','ZSK') AND
1448: p_First_Action_NOA_LA_Code2 in
1449: ('ALM','AQM','HAM','PWM','P3M','P5M','QAK','QBK','QCK','TJK','ZJR',
1450: 'ZRM','ZSK') ) THEN
1451: hr_utility.set_message(8301, 'GHR_37333_ALL_PROCEDURE_FAIL');
1452: hr_utility.raise_error;
1453: end if;
1454: */
1455: /* Commented -- Dec 2001 Patch

Line 1452: hr_utility.raise_error;

1448: p_First_Action_NOA_LA_Code2 in
1449: ('ALM','AQM','HAM','PWM','P3M','P5M','QAK','QBK','QCK','TJK','ZJR',
1450: 'ZRM','ZSK') ) THEN
1451: hr_utility.set_message(8301, 'GHR_37333_ALL_PROCEDURE_FAIL');
1452: hr_utility.raise_error;
1453: end if;
1454: */
1455: /* Commented -- Dec 2001 Patch
1456:

Line 1464: hr_utility.set_message(8301, 'GHR_37334_ALL_PROCEDURE_FAIL');

1460: NOT ( p_First_Action_NOA_LA_Code1 in
1461: ('HAM','TNM','TMK','TNK','ZLM','ZSK') AND
1462: p_First_Action_NOA_LA_Code2 in
1463: ('HAM','TNM','TMK','TNK','ZLM','ZSK') ) THEN
1464: hr_utility.set_message(8301, 'GHR_37334_ALL_PROCEDURE_FAIL');
1465: hr_utility.raise_error;
1466: end if;
1467: */
1468: /* Commented -- Dec 2001 Patch

Line 1465: hr_utility.raise_error;

1461: ('HAM','TNM','TMK','TNK','ZLM','ZSK') AND
1462: p_First_Action_NOA_LA_Code2 in
1463: ('HAM','TNM','TMK','TNK','ZLM','ZSK') ) THEN
1464: hr_utility.set_message(8301, 'GHR_37334_ALL_PROCEDURE_FAIL');
1465: hr_utility.raise_error;
1466: end if;
1467: */
1468: /* Commented -- Dec 2001 Patch
1469:

Line 1477: hr_utility.set_message(8301, 'GHR_37335_ALL_PROCEDURE_FAIL');

1473: NOT ( p_First_Action_NOA_LA_Code1 in
1474: ('HAM','TMK','TNK','ZLM','ZRM','ZSK') AND
1475: p_First_Action_NOA_LA_Code2 in
1476: ('HAM','TMK','TNK','ZLM','ZRM','ZSK') ) THEN
1477: hr_utility.set_message(8301, 'GHR_37335_ALL_PROCEDURE_FAIL');
1478: hr_utility.raise_error;
1479: end if;
1480: */
1481:

Line 1478: hr_utility.raise_error;

1474: ('HAM','TMK','TNK','ZLM','ZRM','ZSK') AND
1475: p_First_Action_NOA_LA_Code2 in
1476: ('HAM','TMK','TNK','ZLM','ZRM','ZSK') ) THEN
1477: hr_utility.set_message(8301, 'GHR_37335_ALL_PROCEDURE_FAIL');
1478: hr_utility.raise_error;
1479: end if;
1480: */
1481:
1482: /* Commented -- Dec 2001 Patch

Line 1490: hr_utility.set_message(8301, 'GHR_37336_ALL_PROCEDURE_FAIL');

1486: NOT ( p_First_Action_NOA_LA_Code1 in
1487: ('HAM','TPK''ZLM','ZSK') AND
1488: p_First_Action_NOA_LA_Code2 in
1489: ('HAM','TPK''ZLM','ZSK') ) THEN
1490: hr_utility.set_message(8301, 'GHR_37336_ALL_PROCEDURE_FAIL');
1491: hr_utility.raise_error;
1492: end if;
1493: */
1494: /* Commented -- Dec 2001 Patch

Line 1491: hr_utility.raise_error;

1487: ('HAM','TPK''ZLM','ZSK') AND
1488: p_First_Action_NOA_LA_Code2 in
1489: ('HAM','TPK''ZLM','ZSK') ) THEN
1490: hr_utility.set_message(8301, 'GHR_37336_ALL_PROCEDURE_FAIL');
1491: hr_utility.raise_error;
1492: end if;
1493: */
1494: /* Commented -- Dec 2001 Patch
1495:

Line 1503: hr_utility.set_message(8301, 'GHR_37337_ALL_PROCEDURE_FAIL');

1499: NOT ( p_First_Action_NOA_LA_Code1 in
1500: ('HAM','TVK''ZLM','ZSK') AND
1501: p_First_Action_NOA_LA_Code2 in
1502: ('HAM','TVK''ZLM','ZSK') ) THEN
1503: hr_utility.set_message(8301, 'GHR_37337_ALL_PROCEDURE_FAIL');
1504: hr_utility.raise_error;
1505: end if;
1506: */
1507:

Line 1504: hr_utility.raise_error;

1500: ('HAM','TVK''ZLM','ZSK') AND
1501: p_First_Action_NOA_LA_Code2 in
1502: ('HAM','TVK''ZLM','ZSK') ) THEN
1503: hr_utility.set_message(8301, 'GHR_37337_ALL_PROCEDURE_FAIL');
1504: hr_utility.raise_error;
1505: end if;
1506: */
1507:
1508:

Line 1553: hr_utility.set_message(8301, 'GHR_37199_ALL_PROCEDURE_FAIL');

1549: p_First_Action_NOA_LA_Code2 <> 'YKB' )
1550: )
1551: )
1552: THEN
1553: hr_utility.set_message(8301, 'GHR_37199_ALL_PROCEDURE_FAIL');
1554: hr_utility.raise_error;
1555: end if;
1556: elsif p_effective_date >= to_date('19'||'99/01/01','yyyy/mm/dd') then
1557: if p_First_NOAC_Lookup_Code= '170'

Line 1554: hr_utility.raise_error;

1550: )
1551: )
1552: THEN
1553: hr_utility.set_message(8301, 'GHR_37199_ALL_PROCEDURE_FAIL');
1554: hr_utility.raise_error;
1555: end if;
1556: elsif p_effective_date >= to_date('19'||'99/01/01','yyyy/mm/dd') then
1557: if p_First_NOAC_Lookup_Code= '170'
1558: and

Line 1587: hr_utility.set_message(8301, 'GHR_37037_ALL_PROCEDURE_FAIL');

1583: p_First_Action_NOA_LA_Code2 <> 'YKB' )
1584: )
1585: )
1586: THEN
1587: hr_utility.set_message(8301, 'GHR_37037_ALL_PROCEDURE_FAIL');
1588: hr_utility.raise_error;
1589: end if;
1590: else
1591: if p_First_NOAC_Lookup_Code= '170'

Line 1588: hr_utility.raise_error;

1584: )
1585: )
1586: THEN
1587: hr_utility.set_message(8301, 'GHR_37037_ALL_PROCEDURE_FAIL');
1588: hr_utility.raise_error;
1589: end if;
1590: else
1591: if p_First_NOAC_Lookup_Code= '170'
1592: and

Line 1622: hr_utility.set_message(8301, 'GHR_37338_ALL_PROCEDURE_FAIL');

1618: p_First_Action_NOA_LA_Code2 <> 'YKB' )
1619: )
1620: )
1621: THEN
1622: hr_utility.set_message(8301, 'GHR_37338_ALL_PROCEDURE_FAIL');
1623: hr_utility.raise_error;
1624: end if;
1625: end if;
1626:

Line 1623: hr_utility.raise_error;

1619: )
1620: )
1621: THEN
1622: hr_utility.set_message(8301, 'GHR_37338_ALL_PROCEDURE_FAIL');
1623: hr_utility.raise_error;
1624: end if;
1625: end if;
1626:
1627: --290.04.2

Line 1662: hr_utility.set_message(8301, 'GHR_37168_ALL_PROCEDURE_FAIL');

1658: AND p_First_Action_NOA_LA_Code2 <> 'YKB' )
1659: )
1660: )
1661: THEN
1662: hr_utility.set_message(8301, 'GHR_37168_ALL_PROCEDURE_FAIL');
1663: hr_utility.raise_error;
1664: end if;
1665: elsif p_effective_date >= to_date('19'||'99/01/01','yyyy/mm/dd') then
1666: if p_First_NOAC_Lookup_Code= '171'

Line 1663: hr_utility.raise_error;

1659: )
1660: )
1661: THEN
1662: hr_utility.set_message(8301, 'GHR_37168_ALL_PROCEDURE_FAIL');
1663: hr_utility.raise_error;
1664: end if;
1665: elsif p_effective_date >= to_date('19'||'99/01/01','yyyy/mm/dd') then
1666: if p_First_NOAC_Lookup_Code= '171'
1667: and

Line 1691: hr_utility.set_message(8301, 'GHR_37094_ALL_PROCEDURE_FAIL');

1687: AND p_First_Action_NOA_LA_Code2 <> 'YKB' )
1688: )
1689: )
1690: THEN
1691: hr_utility.set_message(8301, 'GHR_37094_ALL_PROCEDURE_FAIL');
1692: hr_utility.raise_error;
1693: end if;
1694: else
1695: if p_First_NOAC_Lookup_Code= '171'

Line 1692: hr_utility.raise_error;

1688: )
1689: )
1690: THEN
1691: hr_utility.set_message(8301, 'GHR_37094_ALL_PROCEDURE_FAIL');
1692: hr_utility.raise_error;
1693: end if;
1694: else
1695: if p_First_NOAC_Lookup_Code= '171'
1696: and

Line 1722: hr_utility.set_message(8301, 'GHR_37339_ALL_PROCEDURE_FAIL');

1718: p_First_Action_NOA_LA_Code2 <> 'YKB' )
1719: )
1720: )
1721: THEN
1722: hr_utility.set_message(8301, 'GHR_37339_ALL_PROCEDURE_FAIL');
1723: hr_utility.raise_error;
1724: end if;
1725: end if;
1726:

Line 1723: hr_utility.raise_error;

1719: )
1720: )
1721: THEN
1722: hr_utility.set_message(8301, 'GHR_37339_ALL_PROCEDURE_FAIL');
1723: hr_utility.raise_error;
1724: end if;
1725: end if;
1726:
1727: --290.20.2

Line 1763: hr_utility.set_message(8301, 'GHR_37922_ALL_PROCEDURE_FAIL');

1759: SUBSTR(p_First_Action_NOA_LA_Code2,1,1) IN ('W','X','Y')
1760: )
1761: )
1762: THEN
1763: hr_utility.set_message(8301, 'GHR_37922_ALL_PROCEDURE_FAIL');
1764: hr_utility.raise_error;
1765: end if;
1766: elsif p_effective_date >= to_date('1999/02/28','yyyy/mm/dd') then
1767: if p_First_NOAC_Lookup_Code= '190'

Line 1764: hr_utility.raise_error;

1760: )
1761: )
1762: THEN
1763: hr_utility.set_message(8301, 'GHR_37922_ALL_PROCEDURE_FAIL');
1764: hr_utility.raise_error;
1765: end if;
1766: elsif p_effective_date >= to_date('1999/02/28','yyyy/mm/dd') then
1767: if p_First_NOAC_Lookup_Code= '190'
1768: and

Line 1795: hr_utility.set_message(8301, 'GHR_37188_ALL_PROCEDURE_FAIL');

1791: SUBSTR(p_First_Action_NOA_LA_Code2,1,1) IN ('W','X','Y')
1792: )
1793: )
1794: THEN
1795: hr_utility.set_message(8301, 'GHR_37188_ALL_PROCEDURE_FAIL');
1796: hr_utility.raise_error;
1797: end if;
1798: elsif p_effective_date > to_date('1999/01/31','yyyy/mm/dd') then
1799: if p_First_NOAC_Lookup_Code= '190'

Line 1796: hr_utility.raise_error;

1792: )
1793: )
1794: THEN
1795: hr_utility.set_message(8301, 'GHR_37188_ALL_PROCEDURE_FAIL');
1796: hr_utility.raise_error;
1797: end if;
1798: elsif p_effective_date > to_date('1999/01/31','yyyy/mm/dd') then
1799: if p_First_NOAC_Lookup_Code= '190'
1800: and

Line 1827: hr_utility.set_message(8301, 'GHR_37043_ALL_PROCEDURE_FAIL');

1823: SUBSTR(p_First_Action_NOA_LA_Code2,1,1) IN ('W','X','Y')
1824: )
1825: )
1826: THEN
1827: hr_utility.set_message(8301, 'GHR_37043_ALL_PROCEDURE_FAIL');
1828: hr_utility.raise_error;
1829: end if;
1830: elsif p_effective_date >= to_date('1999/01/01','yyyy/mm/dd') then
1831: if p_First_NOAC_Lookup_Code= '190'

Line 1828: hr_utility.raise_error;

1824: )
1825: )
1826: THEN
1827: hr_utility.set_message(8301, 'GHR_37043_ALL_PROCEDURE_FAIL');
1828: hr_utility.raise_error;
1829: end if;
1830: elsif p_effective_date >= to_date('1999/01/01','yyyy/mm/dd') then
1831: if p_First_NOAC_Lookup_Code= '190'
1832: and

Line 1859: hr_utility.set_message(8301, 'GHR_37093_ALL_PROCEDURE_FAIL');

1855: SUBSTR(p_First_Action_NOA_LA_Code2,1,1) IN ('W','X','Y')
1856: )
1857: )
1858: THEN
1859: hr_utility.set_message(8301, 'GHR_37093_ALL_PROCEDURE_FAIL');
1860: hr_utility.raise_error;
1861: end if;
1862: else
1863: if p_First_NOAC_Lookup_Code= '190'

Line 1860: hr_utility.raise_error;

1856: )
1857: )
1858: THEN
1859: hr_utility.set_message(8301, 'GHR_37093_ALL_PROCEDURE_FAIL');
1860: hr_utility.raise_error;
1861: end if;
1862: else
1863: if p_First_NOAC_Lookup_Code= '190'
1864: and

Line 1891: hr_utility.set_message(8301, 'GHR_37340_ALL_PROCEDURE_FAIL');

1887: SUBSTR(p_First_Action_NOA_LA_Code2,1,1) IN ('W','X','Y')
1888: )
1889: )
1890: THEN
1891: hr_utility.set_message(8301, 'GHR_37340_ALL_PROCEDURE_FAIL');
1892: hr_utility.raise_error;
1893: end if;
1894:
1895: end if;

Line 1892: hr_utility.raise_error;

1888: )
1889: )
1890: THEN
1891: hr_utility.set_message(8301, 'GHR_37340_ALL_PROCEDURE_FAIL');
1892: hr_utility.raise_error;
1893: end if;
1894:
1895: end if;
1896: --290.30.2

Line 1903: hr_utility.set_message(8301, 'GHR_37341_ALL_PROCEDURE_FAIL');

1899: NOT ( p_First_Action_NOA_LA_Code1 in
1900: ('R9R','V1P','ZVB','ZVC') AND
1901: p_First_Action_NOA_LA_Code2 in
1902: ('R9R','V1P','ZVB','ZVC') ) THEN
1903: hr_utility.set_message(8301, 'GHR_37341_ALL_PROCEDURE_FAIL');
1904: hr_utility.raise_error;
1905: end if;
1906:
1907: --290.35.2

Line 1904: hr_utility.raise_error;

1900: ('R9R','V1P','ZVB','ZVC') AND
1901: p_First_Action_NOA_LA_Code2 in
1902: ('R9R','V1P','ZVB','ZVC') ) THEN
1903: hr_utility.set_message(8301, 'GHR_37341_ALL_PROCEDURE_FAIL');
1904: hr_utility.raise_error;
1905: end if;
1906:
1907: --290.35.2
1908: if p_First_NOAC_Lookup_Code= '199'

Line 1914: hr_utility.set_message(8301, 'GHR_37342_ALL_PROCEDURE_FAIL');

1910: NOT ( p_First_Action_NOA_LA_Code1 in
1911: ('R9N','V1P','ZVB','ZVC') AND
1912: p_First_Action_NOA_LA_Code2 in
1913: ('R9N','V1P','ZVB','ZVC') ) THEN
1914: hr_utility.set_message(8301, 'GHR_37342_ALL_PROCEDURE_FAIL');
1915: hr_utility.raise_error;
1916: end if;
1917:
1918: --295.02.2

Line 1915: hr_utility.raise_error;

1911: ('R9N','V1P','ZVB','ZVC') AND
1912: p_First_Action_NOA_LA_Code2 in
1913: ('R9N','V1P','ZVB','ZVC') ) THEN
1914: hr_utility.set_message(8301, 'GHR_37342_ALL_PROCEDURE_FAIL');
1915: hr_utility.raise_error;
1916: end if;
1917:
1918: --295.02.2
1919: --Renumbered from 295.01.2 for the april release

Line 1926: hr_utility.set_message(8301, 'GHR_37343_ALL_PROCEDURE_FAIL');

1922: NOT ( p_First_Action_NOA_LA_Code1 in
1923: ('CUL','ZVB','ZVC') AND
1924: p_First_Action_NOA_LA_Code2 in
1925: ('CUL','ZVB','ZVC') ) THEN
1926: hr_utility.set_message(8301, 'GHR_37343_ALL_PROCEDURE_FAIL');
1927: hr_utility.raise_error;
1928: end if;
1929:
1930: --295.04.2

Line 1927: hr_utility.raise_error;

1923: ('CUL','ZVB','ZVC') AND
1924: p_First_Action_NOA_LA_Code2 in
1925: ('CUL','ZVB','ZVC') ) THEN
1926: hr_utility.set_message(8301, 'GHR_37343_ALL_PROCEDURE_FAIL');
1927: hr_utility.raise_error;
1928: end if;
1929:
1930: --295.04.2
1931: -- Update/Change Date By Effective Date Comment

Line 1944: hr_utility.set_message(8301, 'GHR_37064_ALL_PROCEDURE_FAIL');

1940: 'R9N','UAM','UFM','V8V','ZJR','ZJT','ZJU','ZJV','ZJW','ZVB','ZVC') AND
1941: p_First_Action_NOA_LA_Code2 in
1942: ('ALM','AQM','CGM','DAM','NYM','PSM','Q3K',
1943: 'R9N','UAM','UFM','V8V','ZJR','ZJT','ZJU','ZJV','ZJW','ZVB','ZVC') ) THEN
1944: hr_utility.set_message(8301, 'GHR_37064_ALL_PROCEDURE_FAIL');
1945: hr_utility.raise_error;
1946: end if;
1947: else
1948: if p_First_NOAC_Lookup_Code= '292'

Line 1945: hr_utility.raise_error;

1941: p_First_Action_NOA_LA_Code2 in
1942: ('ALM','AQM','CGM','DAM','NYM','PSM','Q3K',
1943: 'R9N','UAM','UFM','V8V','ZJR','ZJT','ZJU','ZJV','ZJW','ZVB','ZVC') ) THEN
1944: hr_utility.set_message(8301, 'GHR_37064_ALL_PROCEDURE_FAIL');
1945: hr_utility.raise_error;
1946: end if;
1947: else
1948: if p_First_NOAC_Lookup_Code= '292'
1949: and NOT ( p_First_Action_NOA_LA_Code1 in

Line 1955: hr_utility.set_message(8301, 'GHR_37344_ALL_PROCEDURE_FAIL');

1951: 'R9N','UAM','UFM','V8V','ZJR','ZJT','ZJU','ZJW','ZVB','ZVC') AND
1952: p_First_Action_NOA_LA_Code2 in
1953: ('ALM','AQM','CGM','DAM','NYM','PSM','Q3K',
1954: 'R9N','UAM','UFM','V8V','ZJR','ZJT','ZJU','ZJW','ZVB','ZVC') ) THEN
1955: hr_utility.set_message(8301, 'GHR_37344_ALL_PROCEDURE_FAIL');
1956: hr_utility.raise_error;
1957: end if;
1958:
1959: end if;

Line 1956: hr_utility.raise_error;

1952: p_First_Action_NOA_LA_Code2 in
1953: ('ALM','AQM','CGM','DAM','NYM','PSM','Q3K',
1954: 'R9N','UAM','UFM','V8V','ZJR','ZJT','ZJU','ZJW','ZVB','ZVC') ) THEN
1955: hr_utility.set_message(8301, 'GHR_37344_ALL_PROCEDURE_FAIL');
1956: hr_utility.raise_error;
1957: end if;
1958:
1959: end if;
1960:

Line 1969: hr_utility.set_message(8301, 'GHR_37345_ALL_PROCEDURE_FAIL');

1965: p_First_Action_NOA_LA_Code1 in ('R9R','ZVB','ZVC')
1966: and
1967: p_First_Action_NOA_LA_Code2 in ('R9R','ZVB','ZVC')
1968: ) THEN
1969: hr_utility.set_message(8301, 'GHR_37345_ALL_PROCEDURE_FAIL');
1970: hr_utility.raise_error;
1971: end if;
1972:
1973: --300.02.2

Line 1970: hr_utility.raise_error;

1966: and
1967: p_First_Action_NOA_LA_Code2 in ('R9R','ZVB','ZVC')
1968: ) THEN
1969: hr_utility.set_message(8301, 'GHR_37345_ALL_PROCEDURE_FAIL');
1970: hr_utility.raise_error;
1971: end if;
1972:
1973: --300.02.2
1974: -- Renumbered from 300.01.2

Line 1981: hr_utility.set_message(8301, 'GHR_37346_ALL_PROCEDURE_FAIL');

1977: NOT ( p_First_Action_NOA_LA_Code1 in
1978: ('SWM','UFM','USM','V8V') AND
1979: p_First_Action_NOA_LA_Code2 in
1980: ('SWM','UFM','USM','V8V') ) THEN
1981: hr_utility.set_message(8301, 'GHR_37346_ALL_PROCEDURE_FAIL');
1982: hr_utility.raise_error;
1983: end if;
1984:
1985: --300.04.2

Line 1982: hr_utility.raise_error;

1978: ('SWM','UFM','USM','V8V') AND
1979: p_First_Action_NOA_LA_Code2 in
1980: ('SWM','UFM','USM','V8V') ) THEN
1981: hr_utility.set_message(8301, 'GHR_37346_ALL_PROCEDURE_FAIL');
1982: hr_utility.raise_error;
1983: end if;
1984:
1985: --300.04.2
1986: if p_First_NOAC_Lookup_Code= '301'

Line 1992: hr_utility.set_message(8301, 'GHR_37347_ALL_PROCEDURE_FAIL');

1988: NOT ( p_First_Action_NOA_LA_Code1 in
1989: ('SUM','UFM','USM','V8V') AND
1990: p_First_Action_NOA_LA_Code2 in
1991: ('SUM','UFM','USM','V8V') ) THEN
1992: hr_utility.set_message(8301, 'GHR_37347_ALL_PROCEDURE_FAIL');
1993: hr_utility.raise_error;
1994: end if;
1995:
1996: GHR_CPDF_CHECK4A.chk_Legal_Authority_a

Line 1993: hr_utility.raise_error;

1989: ('SUM','UFM','USM','V8V') AND
1990: p_First_Action_NOA_LA_Code2 in
1991: ('SUM','UFM','USM','V8V') ) THEN
1992: hr_utility.set_message(8301, 'GHR_37347_ALL_PROCEDURE_FAIL');
1993: hr_utility.raise_error;
1994: end if;
1995:
1996: GHR_CPDF_CHECK4A.chk_Legal_Authority_a
1997: (p_To_Play_Plan