[Home] [Help]
16: if p_first_noac_lookup_code = '781' and
17: p_prior_work_schedule is not null and
18: p_work_schedule_code is not null and
19: p_prior_work_schedule = p_work_schedule_code then
20: hr_utility.set_message(8301, 'GHR_37601_ALL_PROCEDURE_FAIL');
21: hr_utility.raise_error;
22: end if;
23:
24: -- 590.04.2
17: p_prior_work_schedule is not null and
18: p_work_schedule_code is not null and
19: p_prior_work_schedule = p_work_schedule_code then
20: hr_utility.set_message(8301, 'GHR_37601_ALL_PROCEDURE_FAIL');
21: hr_utility.raise_error;
22: end if;
23:
24: -- 590.04.2
25: if p_first_noac_lookup_code = '430' and
24: -- 590.04.2
25: if p_first_noac_lookup_code = '430' and
26: p_prior_work_schedule not in ('G','J','Q','T') and
27: p_prior_work_schedule is not null then
28: hr_utility.set_message(8301, 'GHR_37602_ALL_PROCEDURE_FAIL');
29: hr_utility.raise_error;
30: end if;
31:
32: end chk_prior_work_schedule;
25: if p_first_noac_lookup_code = '430' and
26: p_prior_work_schedule not in ('G','J','Q','T') and
27: p_prior_work_schedule is not null then
28: hr_utility.set_message(8301, 'GHR_37602_ALL_PROCEDURE_FAIL');
29: hr_utility.raise_error;
30: end if;
31:
32: end chk_prior_work_schedule;
33:
54: IF p_effective_date >= to_date('01/01/2006','MM/DD/RRRR') THEN
55: --IF p_effective_date >= to_date('10/01/2005','MM/DD/RRRR') THEN
56: IF p_ethnic_race_info is not null THEN
57: IF INSTR(p_ethnic_race_info,'1')<1 THEN
58: hr_utility.set_message(8301, 'GHR_38988_ALL_PROCEDURE_FAIL');
59: hr_utility.raise_error;
60: END IF;
61:
62: IF INSTR(p_ethnic_race_info,' ')> 0 THEN
55: --IF p_effective_date >= to_date('10/01/2005','MM/DD/RRRR') THEN
56: IF p_ethnic_race_info is not null THEN
57: IF INSTR(p_ethnic_race_info,'1')<1 THEN
58: hr_utility.set_message(8301, 'GHR_38988_ALL_PROCEDURE_FAIL');
59: hr_utility.raise_error;
60: END IF;
61:
62: IF INSTR(p_ethnic_race_info,' ')> 0 THEN
63: hr_utility.set_message(8301, 'GHR_38988_ALL_PROCEDURE_FAIL');
59: hr_utility.raise_error;
60: END IF;
61:
62: IF INSTR(p_ethnic_race_info,' ')> 0 THEN
63: hr_utility.set_message(8301, 'GHR_38988_ALL_PROCEDURE_FAIL');
64: hr_utility.raise_error;
65: END IF;
66: END IF;
67: END IF;
60: END IF;
61:
62: IF INSTR(p_ethnic_race_info,' ')> 0 THEN
63: hr_utility.set_message(8301, 'GHR_38988_ALL_PROCEDURE_FAIL');
64: hr_utility.raise_error;
65: END IF;
66: END IF;
67: END IF;
68:
72: -- 17-Nov-2005 Raju Bug# 4567571 Added this Edit for UPD44.
73:
74: IF p_effective_date >= to_date('07/01/2006','MM/DD/RRRR') THEN
75: --IF p_effective_date >= to_date('11/01/2005','MM/DD/RRRR') THEN
76: hr_utility.set_location('p_first_action_noa_la_code1 ' || p_first_action_noa_la_code1,111);
77: hr_utility.set_location('p_ethnic_race_info ' || p_ethnic_race_info,111);
78:
79: IF (substr(p_first_action_noa_la_code1, 1, 1) = '1' or substr(p_first_action_noa_la_code2, 1, 1) = '1') and
80: p_ethnic_race_info is null THEN
73:
74: IF p_effective_date >= to_date('07/01/2006','MM/DD/RRRR') THEN
75: --IF p_effective_date >= to_date('11/01/2005','MM/DD/RRRR') THEN
76: hr_utility.set_location('p_first_action_noa_la_code1 ' || p_first_action_noa_la_code1,111);
77: hr_utility.set_location('p_ethnic_race_info ' || p_ethnic_race_info,111);
78:
79: IF (substr(p_first_action_noa_la_code1, 1, 1) = '1' or substr(p_first_action_noa_la_code2, 1, 1) = '1') and
80: p_ethnic_race_info is null THEN
81: hr_utility.set_message(8301, 'GHR_38991_ALL_PROCEDURE_FAIL');
77: hr_utility.set_location('p_ethnic_race_info ' || p_ethnic_race_info,111);
78:
79: IF (substr(p_first_action_noa_la_code1, 1, 1) = '1' or substr(p_first_action_noa_la_code2, 1, 1) = '1') and
80: p_ethnic_race_info is null THEN
81: hr_utility.set_message(8301, 'GHR_38991_ALL_PROCEDURE_FAIL');
82: hr_utility.raise_error;
83: end if;
84: END IF;
85:
78:
79: IF (substr(p_first_action_noa_la_code1, 1, 1) = '1' or substr(p_first_action_noa_la_code2, 1, 1) = '1') and
80: p_ethnic_race_info is null THEN
81: hr_utility.set_message(8301, 'GHR_38991_ALL_PROCEDURE_FAIL');
82: hr_utility.raise_error;
83: end if;
84: END IF;
85:
86: -- 165.11.2
87: -- 17-Nov-2005 Raju Bug# 4567571 Added this Edit for UPD44.
88:
89: IF p_effective_date >= to_date('07/01/2006','MM/DD/RRRR') THEN
90: --IF p_effective_date >= to_date('11/01/2005','MM/DD/RRRR') THEN
91: hr_utility.set_location('p_first_action_noa_la_code1 ' || p_first_action_noa_la_code1,111);
92: hr_utility.set_location('p_race_or_natnl_origin ' || p_race_or_natnl_origin,111);
93:
94: IF (substr(p_first_action_noa_la_code1, 1, 1) = '1' or substr(p_first_action_noa_la_code2, 1, 1) = '1') and
95: p_race_or_natnl_origin is not null THEN
88:
89: IF p_effective_date >= to_date('07/01/2006','MM/DD/RRRR') THEN
90: --IF p_effective_date >= to_date('11/01/2005','MM/DD/RRRR') THEN
91: hr_utility.set_location('p_first_action_noa_la_code1 ' || p_first_action_noa_la_code1,111);
92: hr_utility.set_location('p_race_or_natnl_origin ' || p_race_or_natnl_origin,111);
93:
94: IF (substr(p_first_action_noa_la_code1, 1, 1) = '1' or substr(p_first_action_noa_la_code2, 1, 1) = '1') and
95: p_race_or_natnl_origin is not null THEN
96: hr_utility.set_message(8301, 'GHR_38992_ALL_PROCEDURE_FAIL');
92: hr_utility.set_location('p_race_or_natnl_origin ' || p_race_or_natnl_origin,111);
93:
94: IF (substr(p_first_action_noa_la_code1, 1, 1) = '1' or substr(p_first_action_noa_la_code2, 1, 1) = '1') and
95: p_race_or_natnl_origin is not null THEN
96: hr_utility.set_message(8301, 'GHR_38992_ALL_PROCEDURE_FAIL');
97: hr_utility.raise_error;
98: end if;
99: END IF;
100: -- End Bug# 4567571
93:
94: IF (substr(p_first_action_noa_la_code1, 1, 1) = '1' or substr(p_first_action_noa_la_code2, 1, 1) = '1') and
95: p_race_or_natnl_origin is not null THEN
96: hr_utility.set_message(8301, 'GHR_38992_ALL_PROCEDURE_FAIL');
97: hr_utility.raise_error;
98: end if;
99: END IF;
100: -- End Bug# 4567571
101:
109: IF (p_first_action_noa_la_code1 <> '817' or p_first_action_noa_la_code2 <> '817') and
110: p_ethnic_race_info is null and
111: p_race_or_natnl_origin IS NULL THEN
112: --Bug# 6959477 message number 38822 is duplicated, so created new message with #38160
113: hr_utility.set_message(8301, 'GHR_38160_ALL_PROCEDURE_FAIL');
114: hr_utility.raise_error;
115: end if;
116: ELSE
117: IF p_ethnic_race_info is null and
110: p_ethnic_race_info is null and
111: p_race_or_natnl_origin IS NULL THEN
112: --Bug# 6959477 message number 38822 is duplicated, so created new message with #38160
113: hr_utility.set_message(8301, 'GHR_38160_ALL_PROCEDURE_FAIL');
114: hr_utility.raise_error;
115: end if;
116: ELSE
117: IF p_ethnic_race_info is null and
118: p_race_or_natnl_origin IS NULL THEN
115: end if;
116: ELSE
117: IF p_ethnic_race_info is null and
118: p_race_or_natnl_origin IS NULL THEN
119: hr_utility.set_message(8301, 'GHR_38989_ALL_PROCEDURE_FAIL');
120: hr_utility.raise_error;
121: end if;
122: END IF;
123: END IF;
116: ELSE
117: IF p_ethnic_race_info is null and
118: p_race_or_natnl_origin IS NULL THEN
119: hr_utility.set_message(8301, 'GHR_38989_ALL_PROCEDURE_FAIL');
120: hr_utility.raise_error;
121: end if;
122: END IF;
123: END IF;
124:
129: substr(p_duty_station_lookup_code, 1, 2) <> 'RQ'
130: and
131: p_duty_station_lookup_code is not null
132: then
133: hr_utility.set_message(8301, 'GHR_37603_ALL_PROCEDURE_FAIL');
134: hr_utility.raise_error;
135: end if;
136:
137: -- 600.04.3
130: and
131: p_duty_station_lookup_code is not null
132: then
133: hr_utility.set_message(8301, 'GHR_37603_ALL_PROCEDURE_FAIL');
134: hr_utility.raise_error;
135: end if;
136:
137: -- 600.04.3
138: if p_race_or_natnl_origin in ('F','G','H','J','K','L','M','N','P','Q') and
139: substr(p_duty_station_lookup_code, 1, 2) <> '15'
140: and
141: p_duty_station_lookup_code is not null
142: then
143: hr_utility.set_message(8301, 'GHR_37604_ALL_PROCEDURE_FAIL');
144: hr_utility.raise_error;
145: end if;
146:
147: -- 600.07.3
140: and
141: p_duty_station_lookup_code is not null
142: then
143: hr_utility.set_message(8301, 'GHR_37604_ALL_PROCEDURE_FAIL');
144: hr_utility.raise_error;
145: end if;
146:
147: -- 600.07.3
148: if substr(p_duty_station_lookup_code, 1, 2) = 'RQ' and
151: p_race_or_natnl_origin <> 'Y')
152: and
153: p_race_or_natnl_origin is not null
154: then
155: hr_utility.set_message(8301, 'GHR_37605_ALL_PROCEDURE_FAIL');
156: hr_utility.raise_error;
157: end if;
158:
159: -- 600.10.3
152: and
153: p_race_or_natnl_origin is not null
154: then
155: hr_utility.set_message(8301, 'GHR_37605_ALL_PROCEDURE_FAIL');
156: hr_utility.raise_error;
157: end if;
158:
159: -- 600.10.3
160: if substr(p_duty_station_lookup_code, 1, 2) = '15' and
162: 'K','L','M','N','O','P','Q')
163: and
164: p_race_or_natnl_origin is not null
165: then
166: hr_utility.set_message(8301, 'GHR_37606_ALL_PROCEDURE_FAIL');
167: hr_utility.raise_error;
168: end if;
169:
170: end chk_race_or_natnl_origin;
163: and
164: p_race_or_natnl_origin is not null
165: then
166: hr_utility.set_message(8301, 'GHR_37606_ALL_PROCEDURE_FAIL');
167: hr_utility.raise_error;
168: end if;
169:
170: end chk_race_or_natnl_origin;
171:
183: null;
184: /* This is not required according to the update6 summary of the edit manual.
185: if substr(p_prior_duty_station, 1, 2) = 'US' and
186: p_agency_subelement <> 'DJ02' then
187: hr_utility.set_message(8301, 'GHR_37607_ALL_PROCEDURE_FAIL');
188: hr_utility.raise_error;
189: end if;
190: */
191:
184: /* This is not required according to the update6 summary of the edit manual.
185: if substr(p_prior_duty_station, 1, 2) = 'US' and
186: p_agency_subelement <> 'DJ02' then
187: hr_utility.set_message(8301, 'GHR_37607_ALL_PROCEDURE_FAIL');
188: hr_utility.raise_error;
189: end if;
190: */
191:
192: end chk_prior_duty_station;
209: /* Commented -- August 2001 10.7 Patch
210: -- 655.02.1
211: if p_retention_allowance is not null and
212: to_number(p_retention_allowance) <= 0 then
213: hr_utility.set_message(8301, 'GHR_37666_ALL_PROCEDURE_FAIL');
214: hr_utility.raise_error;
215: end if;
216: */
217:
210: -- 655.02.1
211: if p_retention_allowance is not null and
212: to_number(p_retention_allowance) <= 0 then
213: hr_utility.set_message(8301, 'GHR_37666_ALL_PROCEDURE_FAIL');
214: hr_utility.raise_error;
215: end if;
216: */
217:
218: -- 655.10.3
227: and
228: p_retention_allowance is not null
229: and
230: to_number(p_retention_allowance) > (to_number(p_to_basic_pay) * .25) then
231: hr_utility.set_message(8301, 'GHR_37667_ALL_PROCEDURE_FAIL');
232: hr_utility.raise_error;
233: end if;
234: --
235: -- 655.15.2
228: p_retention_allowance is not null
229: and
230: to_number(p_retention_allowance) > (to_number(p_to_basic_pay) * .25) then
231: hr_utility.set_message(8301, 'GHR_37667_ALL_PROCEDURE_FAIL');
232: hr_utility.raise_error;
233: end if;
234: --
235: -- 655.15.2
236: /* The following edits were commented out to allow null values to be used to
239: (p_first_action_noa_la_code1 = 'VPG' or p_first_action_noa_la_code2 = 'VPG')
240: and
241: p_retention_allowance is null
242: then
243: hr_utility.set_message(8301, 'GHR_37668_ALL_PROCEDURE_FAIL');
244: hr_utility.raise_error;
245: end if;
246: */
247: /* Commented -- August 2001 10.7 Patch
240: and
241: p_retention_allowance is null
242: then
243: hr_utility.set_message(8301, 'GHR_37668_ALL_PROCEDURE_FAIL');
244: hr_utility.raise_error;
245: end if;
246: */
247: /* Commented -- August 2001 10.7 Patch
248: -- 655.20.2
248: -- 655.20.2
249: if p_first_noac_lookup_code <> 810 and
250: p_retention_allowance is not null and
251: to_number(p_retention_allowance) <= 0 then
252: hr_utility.set_message(8301, 'GHR_37669_ALL_PROCEDURE_FAIL');
253: hr_utility.raise_error;
254: end if;
255: */
256:
249: if p_first_noac_lookup_code <> 810 and
250: p_retention_allowance is not null and
251: to_number(p_retention_allowance) <= 0 then
252: hr_utility.set_message(8301, 'GHR_37669_ALL_PROCEDURE_FAIL');
253: hr_utility.raise_error;
254: end if;
255: */
256:
257: end chk_retention_allowance;
273: /* Commenting the edit as per Sept.2000 patch -- refer to doc cpdf_edits_00_sep.doc
274: -- 656.10.1
275: if p_staffing_differential is not null and
276: to_number(p_staffing_differential) <= 0 then
277: hr_utility.set_message(8301, 'GHR_37670_ALL_PROCEDURE_FAIL');
278: hr_utility.raise_error;
279: end if;
280: */
281:
274: -- 656.10.1
275: if p_staffing_differential is not null and
276: to_number(p_staffing_differential) <= 0 then
277: hr_utility.set_message(8301, 'GHR_37670_ALL_PROCEDURE_FAIL');
278: hr_utility.raise_error;
279: end if;
280: */
281:
282: -- 656.15.2
284: end other pay elements: Staffing Differential, Retention Allowance and Supervisory Differential.
285: if p_first_noac_lookup_code = '810' and
286: (p_first_action_noa_la_code1 = 'ZTS' or p_first_action_noa_la_code2= 'ZTS') and
287: p_staffing_differential is null then
288: hr_utility.set_message(8301, 'GHR_37671_ALL_PROCEDURE_FAIL');
289: hr_utility.raise_error;
290: end if;
291: */
292: /* Commenting the edit as per Sept.2000 patch -- refer to doc cpdf_edits_00_sep.doc
285: if p_first_noac_lookup_code = '810' and
286: (p_first_action_noa_la_code1 = 'ZTS' or p_first_action_noa_la_code2= 'ZTS') and
287: p_staffing_differential is null then
288: hr_utility.set_message(8301, 'GHR_37671_ALL_PROCEDURE_FAIL');
289: hr_utility.raise_error;
290: end if;
291: */
292: /* Commenting the edit as per Sept.2000 patch -- refer to doc cpdf_edits_00_sep.doc
293: -- 656.20.2
293: -- 656.20.2
294: if p_first_noac_lookup_code <> '810' and
295: p_staffing_differential is not null and
296: to_number(p_staffing_differential) <= 0 then
297: hr_utility.set_message(8301, 'GHR_37672_ALL_PROCEDURE_FAIL');
298: hr_utility.raise_error;
299: end if;
300: */
301: null;
294: if p_first_noac_lookup_code <> '810' and
295: p_staffing_differential is not null and
296: to_number(p_staffing_differential) <= 0 then
297: hr_utility.set_message(8301, 'GHR_37672_ALL_PROCEDURE_FAIL');
298: hr_utility.raise_error;
299: end if;
300: */
301: null;
302: end chk_staffing_differential;
318: -- 657.15.1
319: -- Commented by Ashley for bug 3251402 (EOY 03)
320: /* if p_supervisory_differential is not null and
321: to_number(p_supervisory_differential) <= 0 then
322: hr_utility.set_message(8301, 'GHR_37673_ALL_PROCEDURE_FAIL');
323: hr_utility.raise_error;
324: end if;
325: */
326:
319: -- Commented by Ashley for bug 3251402 (EOY 03)
320: /* if p_supervisory_differential is not null and
321: to_number(p_supervisory_differential) <= 0 then
322: hr_utility.set_message(8301, 'GHR_37673_ALL_PROCEDURE_FAIL');
323: hr_utility.raise_error;
324: end if;
325: */
326:
327: -- 657.20.2
329: end other pay elements: Staffing Differential, Retention Allowance and Supervisory Differential.
330: if p_first_noac_lookup_code = '810' and
331: (p_first_action_noa_la_code1 = 'VPH' or p_first_action_noa_la_code2 = 'VPH') and
332: p_supervisory_differential is null then
333: hr_utility.set_message(8301, 'GHR_37674_ALL_PROCEDURE_FAIL');
334: hr_utility.raise_error;
335: end if;
336: */
337: -- 657.25.2
330: if p_first_noac_lookup_code = '810' and
331: (p_first_action_noa_la_code1 = 'VPH' or p_first_action_noa_la_code2 = 'VPH') and
332: p_supervisory_differential is null then
333: hr_utility.set_message(8301, 'GHR_37674_ALL_PROCEDURE_FAIL');
334: hr_utility.raise_error;
335: end if;
336: */
337: -- 657.25.2
338: -- EOY'02 Patch 13-NOV-02 vnarasim End dated the Edit as of 31-MAY-2001
340: if p_effective_date <= to_date('31/05/2001','dd/mm/yyyy') then
341: if p_first_noac_lookup_code <> '810' and
342: p_supervisory_differential is not null and
343: to_number(p_supervisory_differential) <= 0 then
344: hr_utility.set_message(8301, 'GHR_37675_ALL_PROCEDURE_FAIL');
345: hr_utility.raise_error;
346: end if;
347: end if;
348: end chk_supervisory_differential;
341: if p_first_noac_lookup_code <> '810' and
342: p_supervisory_differential is not null and
343: to_number(p_supervisory_differential) <= 0 then
344: hr_utility.set_message(8301, 'GHR_37675_ALL_PROCEDURE_FAIL');
345: hr_utility.raise_error;
346: end if;
347: end if;
348: end chk_supervisory_differential;
349:
370: if p_service_computation_date > p_submission_date
371: and
372: p_service_computation_date is not null
373: then
374: hr_utility.set_message(8301, 'GHR_37608_ALL_PROCEDURE_FAIL');
375: hr_utility.raise_error;
376: end if;
377:
378: -- 660.02.3
371: and
372: p_service_computation_date is not null
373: then
374: hr_utility.set_message(8301, 'GHR_37608_ALL_PROCEDURE_FAIL');
375: hr_utility.raise_error;
376: end if;
377:
378: -- 660.02.3
379: if
383:
384: and
385: p_service_computation_date is not null
386: then
387: hr_utility.set_message(8301, 'GHR_37609_ALL_PROCEDURE_FAIL');
388: hr_utility.raise_error;
389: end if;
390:
391: -- 660.04.3
384: and
385: p_service_computation_date is not null
386: then
387: hr_utility.set_message(8301, 'GHR_37609_ALL_PROCEDURE_FAIL');
388: hr_utility.raise_error;
389: end if;
390:
391: -- 660.04.3
392: -- end dated this edit on 27-oct-98 for bug 745246
406: to_number(substr(to_char(p_employee_date_of_birth, 'MMDDYYYY'),5,4)) ) < 15
407: and
408: p_service_computation_date is not null
409: then
410: hr_utility.set_message(8301, 'GHR_37610_ALL_PROCEDURE_FAIL');
411: hr_utility.raise_error;
412: end if;
413: end if;
414:
407: and
408: p_service_computation_date is not null
409: then
410: hr_utility.set_message(8301, 'GHR_37610_ALL_PROCEDURE_FAIL');
411: hr_utility.raise_error;
412: end if;
413: end if;
414:
415: -- 660.07.2
416: if p_service_computation_date > p_effective_date
417: and
418: p_service_computation_date is not null
419: then
420: hr_utility.set_message(8301, 'GHR_37611_ALL_PROCEDURE_FAIL');
421: hr_utility.raise_error;
422: end if;
423:
424: -- 660.10.2
417: and
418: p_service_computation_date is not null
419: then
420: hr_utility.set_message(8301, 'GHR_37611_ALL_PROCEDURE_FAIL');
421: hr_utility.raise_error;
422: end if;
423:
424: -- 660.10.2
425: if substr(p_first_noac_lookup_code, 1, 1) = '1'
423:
424: -- 660.10.2
425: if substr(p_first_noac_lookup_code, 1, 1) = '1'
426: -- and
427: -- hr_utility.is_numeric(p_credit_mil_svc)
428: and
429: to_number(p_credit_mil_svc) > 0 and
430: p_service_computation_date >= p_effective_date then
431: hr_utility.set_message(8301, 'GHR_37612_ALL_PROCEDURE_FAIL');
427: -- hr_utility.is_numeric(p_credit_mil_svc)
428: and
429: to_number(p_credit_mil_svc) > 0 and
430: p_service_computation_date >= p_effective_date then
431: hr_utility.set_message(8301, 'GHR_37612_ALL_PROCEDURE_FAIL');
432: hr_utility.raise_error;
433: end if;
434:
435: end chk_service_comp_date;
428: and
429: to_number(p_credit_mil_svc) > 0 and
430: p_service_computation_date >= p_effective_date then
431: hr_utility.set_message(8301, 'GHR_37612_ALL_PROCEDURE_FAIL');
432: hr_utility.raise_error;
433: end if;
434:
435: end chk_service_comp_date;
436:
470: open c_found_poi;
471: fetch c_found_poi into l_dummy;
472: if c_found_poi%notfound then
473:
474: hr_utility.set_message(8301, 'GHR_37613_ALL_PROCEDURE_FAIL');
475: hr_utility.raise_error;
476: end if;
477: close c_found_poi;
478: end;
471: fetch c_found_poi into l_dummy;
472: if c_found_poi%notfound then
473:
474: hr_utility.set_message(8301, 'GHR_37613_ALL_PROCEDURE_FAIL');
475: hr_utility.raise_error;
476: end if;
477: close c_found_poi;
478: end;
479: end if;
485: Begin
486: open c_found_poi;
487: fetch c_found_poi into l_dummy;
488: if c_found_poi%notfound then
489: hr_utility.set_message(8301, 'GHR_37698_ALL_PROCEDURE_FAIL');
490: hr_utility.raise_error;
491: end if;
492: close c_found_poi;
493: end;
486: open c_found_poi;
487: fetch c_found_poi into l_dummy;
488: if c_found_poi%notfound then
489: hr_utility.set_message(8301, 'GHR_37698_ALL_PROCEDURE_FAIL');
490: hr_utility.raise_error;
491: end if;
492: close c_found_poi;
493: end;
494: end if;
509: open c_found_poi;
510: fetch c_found_poi into l_dummy;
511: if c_found_poi%notfound then
512: if p_effective_date < to_date('01/07/2006','dd/mm/yyyy') then
513: hr_utility.set_message(8301, 'GHR_37614_ALL_PROCEDURE_FAIL');
514: hr_utility.raise_error;
515: else
516: hr_utility.set_message(8301, 'GHR_37699_ALL_PROCEDURE_FAIL');
517: hr_utility.raise_error;
510: fetch c_found_poi into l_dummy;
511: if c_found_poi%notfound then
512: if p_effective_date < to_date('01/07/2006','dd/mm/yyyy') then
513: hr_utility.set_message(8301, 'GHR_37614_ALL_PROCEDURE_FAIL');
514: hr_utility.raise_error;
515: else
516: hr_utility.set_message(8301, 'GHR_37699_ALL_PROCEDURE_FAIL');
517: hr_utility.raise_error;
518: end if;
512: if p_effective_date < to_date('01/07/2006','dd/mm/yyyy') then
513: hr_utility.set_message(8301, 'GHR_37614_ALL_PROCEDURE_FAIL');
514: hr_utility.raise_error;
515: else
516: hr_utility.set_message(8301, 'GHR_37699_ALL_PROCEDURE_FAIL');
517: hr_utility.raise_error;
518: end if;
519: end if;
520: close c_found_poi;
513: hr_utility.set_message(8301, 'GHR_37614_ALL_PROCEDURE_FAIL');
514: hr_utility.raise_error;
515: else
516: hr_utility.set_message(8301, 'GHR_37699_ALL_PROCEDURE_FAIL');
517: hr_utility.raise_error;
518: end if;
519: end if;
520: close c_found_poi;
521: end;
527: ) and
528: substr(p_employee_National_ID,1,3) not between '000' and '800'
529: then
530: if p_effective_date < to_date('01/07/2006','dd/mm/yyyy') then
531: hr_utility.set_message(8301, 'GHR_37615_ALL_PROCEDURE_FAIL');
532: hr_utility.raise_error;
533: else
534: hr_utility.set_message(8301, 'GHR_38478_ALL_PROCEDURE_FAIL');
535: hr_utility.raise_error;
528: substr(p_employee_National_ID,1,3) not between '000' and '800'
529: then
530: if p_effective_date < to_date('01/07/2006','dd/mm/yyyy') then
531: hr_utility.set_message(8301, 'GHR_37615_ALL_PROCEDURE_FAIL');
532: hr_utility.raise_error;
533: else
534: hr_utility.set_message(8301, 'GHR_38478_ALL_PROCEDURE_FAIL');
535: hr_utility.raise_error;
536: end if;
530: if p_effective_date < to_date('01/07/2006','dd/mm/yyyy') then
531: hr_utility.set_message(8301, 'GHR_37615_ALL_PROCEDURE_FAIL');
532: hr_utility.raise_error;
533: else
534: hr_utility.set_message(8301, 'GHR_38478_ALL_PROCEDURE_FAIL');
535: hr_utility.raise_error;
536: end if;
537: end if;
538:
531: hr_utility.set_message(8301, 'GHR_37615_ALL_PROCEDURE_FAIL');
532: hr_utility.raise_error;
533: else
534: hr_utility.set_message(8301, 'GHR_38478_ALL_PROCEDURE_FAIL');
535: hr_utility.raise_error;
536: end if;
537: end if;
538:
539: end chk_Social_Security;
580: p_rpa_step_or_rate <> '00'
581: and
582: p_rpa_step_or_rate is not null
583: then
584: hr_utility.set_message(8301, 'GHR_37186_ALL_PROCEDURE_FAIL');
585: hr_utility.raise_error;
586: end if;
587: else
588: if (
581: and
582: p_rpa_step_or_rate is not null
583: then
584: hr_utility.set_message(8301, 'GHR_37186_ALL_PROCEDURE_FAIL');
585: hr_utility.raise_error;
586: end if;
587: else
588: if (
589: p_pay_rate_determinant in ('0','6','2','3','4','A','B','C','E','F','G','H','I','J','K','L','N','O',
594: p_rpa_step_or_rate <> '00'
595: and
596: p_rpa_step_or_rate is not null
597: then
598: hr_utility.set_message(8301, 'GHR_37616_ALL_PROCEDURE_FAIL');
599: hr_utility.raise_error;
600: end if;
601: end if;
602: ELSE
595: and
596: p_rpa_step_or_rate is not null
597: then
598: hr_utility.set_message(8301, 'GHR_37616_ALL_PROCEDURE_FAIL');
599: hr_utility.raise_error;
600: end if;
601: end if;
602: ELSE
603: if p_effective_date >= fnd_date.canonical_to_date('1999/03/01') then
611: p_step_or_rate <> '00'
612: and
613: p_step_or_rate is not null
614: then
615: hr_utility.set_message(8301, 'GHR_37186_ALL_PROCEDURE_FAIL');
616: hr_utility.raise_error;
617: end if;
618: else
619: if (
612: and
613: p_step_or_rate is not null
614: then
615: hr_utility.set_message(8301, 'GHR_37186_ALL_PROCEDURE_FAIL');
616: hr_utility.raise_error;
617: end if;
618: else
619: if (
620: p_pay_rate_determinant in ('2','3','4','A','B','C','E','F','G','H','I','J','K','L','N','O',
625: p_step_or_rate <> '00'
626: and
627: p_step_or_rate is not null
628: then
629: hr_utility.set_message(8301, 'GHR_37616_ALL_PROCEDURE_FAIL');
630: hr_utility.raise_error;
631: end if;
632: end if;
633: END IF;
626: and
627: p_step_or_rate is not null
628: then
629: hr_utility.set_message(8301, 'GHR_37616_ALL_PROCEDURE_FAIL');
630: hr_utility.raise_error;
631: end if;
632: end if;
633: END IF;
634:
649: '09','10','11','12','13','14','15')
650: and
651: p_step_or_rate is not null
652: then
653: hr_utility.set_message(8301, 'GHR_37617_ALL_PROCEDURE_FAIL');
654: hr_utility.raise_error;
655: end if;
656:
657: -- 700.07.3
650: and
651: p_step_or_rate is not null
652: then
653: hr_utility.set_message(8301, 'GHR_37617_ALL_PROCEDURE_FAIL');
654: hr_utility.raise_error;
655: end if;
656:
657: -- 700.07.3
658: -- Madhuri 19-MAY-2004 Removed VP from the list
664: p_step_or_rate not in ('01','02','03','04','05','06',
665: '07','08','09','10') and
666: p_step_or_rate is not null
667: then
668: hr_utility.set_message(8301, 'GHR_37618_ALL_PROCEDURE_FAIL');
669: hr_utility.raise_error;
670: end if;
671: END IF;
672:
665: '07','08','09','10') and
666: p_step_or_rate is not null
667: then
668: hr_utility.set_message(8301, 'GHR_37618_ALL_PROCEDURE_FAIL');
669: hr_utility.raise_error;
670: end if;
671: END IF;
672:
673: -- 700.10.3
678: p_step_or_rate not in ('01','02','03','04','05','06',
679: '07','08','09') and
680: p_step_or_rate is not null
681: then
682: hr_utility.set_message(8301, 'GHR_37619_ALL_PROCEDURE_FAIL');
683: hr_utility.raise_error;
684: end if;
685: END IF;
686:
679: '07','08','09') and
680: p_step_or_rate is not null
681: then
682: hr_utility.set_message(8301, 'GHR_37619_ALL_PROCEDURE_FAIL');
683: hr_utility.raise_error;
684: end if;
685: END IF;
686:
687: -- 700.12.3
692: '24','25','26','27','28')
693: and
694: p_step_or_rate is not null
695: then
696: hr_utility.set_message(8301, 'GHR_37620_ALL_PROCEDURE_FAIL');
697: hr_utility.raise_error;
698: end if;
699:
700: -- 700.14.3
693: and
694: p_step_or_rate is not null
695: then
696: hr_utility.set_message(8301, 'GHR_37620_ALL_PROCEDURE_FAIL');
697: hr_utility.raise_error;
698: end if;
699:
700: -- 700.14.3
701: -- Update 7 on 16 jun 98. Added 00 to step or rate
703: if p_effective_date < fnd_date.canonical_to_date('2006/04/01') then
704: if p_to_pay_plan = 'XE' and
705: p_step_or_rate not in ('00','01','02','03') and
706: p_step_or_rate is not null then
707: hr_utility.set_message(8301, 'GHR_37621_ALL_PROCEDURE_FAIL');
708: hr_utility.set_message_token('STEP_RATE','00 through 03');
709: hr_utility.raise_error;
710: end if;
711: else
704: if p_to_pay_plan = 'XE' and
705: p_step_or_rate not in ('00','01','02','03') and
706: p_step_or_rate is not null then
707: hr_utility.set_message(8301, 'GHR_37621_ALL_PROCEDURE_FAIL');
708: hr_utility.set_message_token('STEP_RATE','00 through 03');
709: hr_utility.raise_error;
710: end if;
711: else
712: if p_to_pay_plan = 'XE' and
705: p_step_or_rate not in ('00','01','02','03') and
706: p_step_or_rate is not null then
707: hr_utility.set_message(8301, 'GHR_37621_ALL_PROCEDURE_FAIL');
708: hr_utility.set_message_token('STEP_RATE','00 through 03');
709: hr_utility.raise_error;
710: end if;
711: else
712: if p_to_pay_plan = 'XE' and
713: p_step_or_rate not in ('01','02','03') and
711: else
712: if p_to_pay_plan = 'XE' and
713: p_step_or_rate not in ('01','02','03') and
714: p_step_or_rate is not null then
715: hr_utility.set_message(8301, 'GHR_37621_ALL_PROCEDURE_FAIL');
716: hr_utility.set_message_token('STEP_RATE','01 through 03');
717: hr_utility.raise_error;
718: end if;
719: end if;
712: if p_to_pay_plan = 'XE' and
713: p_step_or_rate not in ('01','02','03') and
714: p_step_or_rate is not null then
715: hr_utility.set_message(8301, 'GHR_37621_ALL_PROCEDURE_FAIL');
716: hr_utility.set_message_token('STEP_RATE','01 through 03');
717: hr_utility.raise_error;
718: end if;
719: end if;
720:
713: p_step_or_rate not in ('01','02','03') and
714: p_step_or_rate is not null then
715: hr_utility.set_message(8301, 'GHR_37621_ALL_PROCEDURE_FAIL');
716: hr_utility.set_message_token('STEP_RATE','01 through 03');
717: hr_utility.raise_error;
718: end if;
719: end if;
720:
721: -- 700.16.3
725: '16','17','18','19','20','21')
726: and
727: p_step_or_rate is not null
728: then
729: hr_utility.set_message(8301, 'GHR_37622_ALL_PROCEDURE_FAIL');
730: hr_utility.raise_error;
731: end if;
732:
733: -- 700.19.3
726: and
727: p_step_or_rate is not null
728: then
729: hr_utility.set_message(8301, 'GHR_37622_ALL_PROCEDURE_FAIL');
730: hr_utility.raise_error;
731: end if;
732:
733: -- 700.19.3
734: -- 17-Aug-00 vravikan 01-jan-2000 Delete 99
736: if p_effective_date >= to_date('1999/01/01','yyyy/mm/dd') then
737: if p_to_pay_plan in ('GR','GM') and p_step_or_rate <> '00' and
738: p_step_or_rate is not null
739: then
740: hr_utility.set_message(8301, 'GHR_37436_ALL_PROCEDURE_FAIL');
741: hr_utility.set_message_token('PAY_PLAN',p_to_pay_plan);--Bug# 6341069
742: hr_utility.raise_error;
743: end if;
744: else
737: if p_to_pay_plan in ('GR','GM') and p_step_or_rate <> '00' and
738: p_step_or_rate is not null
739: then
740: hr_utility.set_message(8301, 'GHR_37436_ALL_PROCEDURE_FAIL');
741: hr_utility.set_message_token('PAY_PLAN',p_to_pay_plan);--Bug# 6341069
742: hr_utility.raise_error;
743: end if;
744: else
745: if p_to_pay_plan = 'GM' and
738: p_step_or_rate is not null
739: then
740: hr_utility.set_message(8301, 'GHR_37436_ALL_PROCEDURE_FAIL');
741: hr_utility.set_message_token('PAY_PLAN',p_to_pay_plan);--Bug# 6341069
742: hr_utility.raise_error;
743: end if;
744: else
745: if p_to_pay_plan = 'GM' and
746: (p_step_or_rate <> '00' and p_step_or_rate <> '99')
746: (p_step_or_rate <> '00' and p_step_or_rate <> '99')
747: and
748: p_step_or_rate is not null
749: then
750: hr_utility.set_message(8301, 'GHR_37623_ALL_PROCEDURE_FAIL');
751: hr_utility.raise_error;
752: end if;
753: end if;
754:
747: and
748: p_step_or_rate is not null
749: then
750: hr_utility.set_message(8301, 'GHR_37623_ALL_PROCEDURE_FAIL');
751: hr_utility.raise_error;
752: end if;
753: end if;
754:
755: -- 700.22.2
758: if p_effective_date <= to_date('31/05/2001','dd/mm/yyyy') then
759: if (p_to_pay_plan ='ES' or p_to_pay_plan ='FE') and
760: p_step_or_rate not in ('01','02','03','04','05','06') and
761: p_step_or_rate is not null then
762: hr_utility.set_message(8301, 'GHR_37624_ALL_PROCEDURE_FAIL');
763: hr_utility.raise_error;
764: end if;
765: end if;
766:
759: if (p_to_pay_plan ='ES' or p_to_pay_plan ='FE') and
760: p_step_or_rate not in ('01','02','03','04','05','06') and
761: p_step_or_rate is not null then
762: hr_utility.set_message(8301, 'GHR_37624_ALL_PROCEDURE_FAIL');
763: hr_utility.raise_error;
764: end if;
765: end if;
766:
767: -- 700.31.3
770: '09','10','11','12','13','14')
771: and
772: p_step_or_rate is not null
773: then
774: hr_utility.set_message(8301, 'GHR_376_ALL_PROCEDURE_FAIL');
775: hr_utility.raise_error;
776: end if;
777:
778: -- 700.34.3
771: and
772: p_step_or_rate is not null
773: then
774: hr_utility.set_message(8301, 'GHR_376_ALL_PROCEDURE_FAIL');
775: hr_utility.raise_error;
776: end if;
777:
778: -- 700.34.3
779: if p_to_pay_plan = 'FP' and
782: '09','10','11','12','13','14')
783: and
784: p_step_or_rate is not null
785: then
786: hr_utility.set_message(8301, 'GHR_37626_ALL_PROCEDURE_FAIL');
787: hr_utility.raise_error;
788: end if;
789:
790: -- 700.35.3
783: and
784: p_step_or_rate is not null
785: then
786: hr_utility.set_message(8301, 'GHR_37626_ALL_PROCEDURE_FAIL');
787: hr_utility.raise_error;
788: end if;
789:
790: -- 700.35.3
791: if p_to_pay_plan = 'FP' and
793: p_step_or_rate not in ('01','02','03','04','05')
794: and
795: p_step_or_rate is not null
796: then
797: hr_utility.set_message(8301, 'GHR_37627_ALL_PROCEDURE_FAIL');
798: hr_utility.raise_error;
799: end if;
800:
801: -- 700.37.3
794: and
795: p_step_or_rate is not null
796: then
797: hr_utility.set_message(8301, 'GHR_37627_ALL_PROCEDURE_FAIL');
798: hr_utility.raise_error;
799: end if;
800:
801: -- 700.37.3
802: if p_to_pay_plan = 'AF' and
803: p_step_or_rate not in ('01','02','03','04','05')
804: and
805: p_step_or_rate is not null
806: then
807: hr_utility.set_message(8301, 'GHR_37628_ALL_PROCEDURE_FAIL');
808: hr_utility.raise_error;
809: end if;
810:
811: -- 700.40.3
804: and
805: p_step_or_rate is not null
806: then
807: hr_utility.set_message(8301, 'GHR_37628_ALL_PROCEDURE_FAIL');
808: hr_utility.raise_error;
809: end if;
810:
811: -- 700.40.3
812: if p_to_pay_plan = 'FC' and
816: '07','08','09','10')
817: and
818: p_step_or_rate is not null
819: then
820: hr_utility.set_message(8301, 'GHR_37629_ALL_PROCEDURE_FAIL');
821: hr_utility.raise_error;
822: end if;
823:
824: -- 700.43.3
817: and
818: p_step_or_rate is not null
819: then
820: hr_utility.set_message(8301, 'GHR_37629_ALL_PROCEDURE_FAIL');
821: hr_utility.raise_error;
822: end if;
823:
824: -- 700.43.3
825: if p_to_pay_plan = 'FC' and p_to_grade_or_level = '13' and
827: '06','07','08','09')
828: and
829: p_step_or_rate is not null
830: then
831: hr_utility.set_message(8301, 'GHR_37630_ALL_PROCEDURE_FAIL');
832: hr_utility.raise_error;
833: end if;
834:
835: -- 700.47.3
828: and
829: p_step_or_rate is not null
830: then
831: hr_utility.set_message(8301, 'GHR_37630_ALL_PROCEDURE_FAIL');
832: hr_utility.raise_error;
833: end if;
834:
835: -- 700.47.3
836: if p_to_pay_plan = 'FC' and p_to_grade_or_level = '14' and
837: p_step_or_rate not in ('01','02','03','04','05')
838: and
839: p_step_or_rate is not null
840: then
841: hr_utility.set_message(8301, 'GHR_37631_ALL_PROCEDURE_FAIL');
842: hr_utility.raise_error;
843: end if;
844:
845: -- 700.50.3
838: and
839: p_step_or_rate is not null
840: then
841: hr_utility.set_message(8301, 'GHR_37631_ALL_PROCEDURE_FAIL');
842: hr_utility.raise_error;
843: end if;
844:
845: -- 700.50.3
846: if p_to_pay_plan in ('CA','SL','ST') and
848: and
849: p_step_or_rate is not null
850: then
851:
852: hr_utility.set_message(8301, 'GHR_37632_ALL_PROCEDURE_FAIL');
853: hr_utility.raise_error;
854: end if;
855:
856: -- 700.55.3
849: p_step_or_rate is not null
850: then
851:
852: hr_utility.set_message(8301, 'GHR_37632_ALL_PROCEDURE_FAIL');
853: hr_utility.raise_error;
854: end if;
855:
856: -- 700.55.3
857: if p_to_pay_plan = 'AL' and
859: (p_step_or_rate <> '00'
860: and
861: p_step_or_rate is not null)
862: then
863: hr_utility.set_message(8301, 'GHR_37633_ALL_PROCEDURE_FAIL');
864: hr_utility.raise_error;
865: end if;
866:
867: -- 700.60.3
860: and
861: p_step_or_rate is not null)
862: then
863: hr_utility.set_message(8301, 'GHR_37633_ALL_PROCEDURE_FAIL');
864: hr_utility.raise_error;
865: end if;
866:
867: -- 700.60.3
868: if p_to_pay_plan = 'AL' and p_to_grade_or_level = '03' and
870: p_step_or_rate not in ('01','02','03','04','05','06')
871: and
872: p_step_or_rate is not null
873: then
874: hr_utility.set_message(8301, 'GHR_37634_ALL_PROCEDURE_FAIL');
875: hr_utility.raise_error;
876: end if;
877:
878: -- 700.62.3
871: and
872: p_step_or_rate is not null
873: then
874: hr_utility.set_message(8301, 'GHR_37634_ALL_PROCEDURE_FAIL');
875: hr_utility.raise_error;
876: end if;
877:
878: -- 700.62.3
879: if p_to_pay_plan = 'GG' and p_to_grade_or_level = 'SL' and
880: p_step_or_rate <>'00'
881: and
882: p_step_or_rate is not null
883: then
884: hr_utility.set_message(8301, 'GHR_37635_ALL_PROCEDURE_FAIL');
885: hr_utility.raise_error;
886: end if;
887:
888: -- 700.65.3
881: and
882: p_step_or_rate is not null
883: then
884: hr_utility.set_message(8301, 'GHR_37635_ALL_PROCEDURE_FAIL');
885: hr_utility.raise_error;
886: end if;
887:
888: -- 700.65.3
889: if p_to_pay_plan = 'GG' and
896: '07','08','09','10','11','12')
897: and
898: p_step_or_rate is not null
899: then
900: hr_utility.set_message(8301, 'GHR_37636_ALL_PROCEDURE_FAIL');
901: hr_utility.raise_error;
902: end if;
903:
904: -- 700.67.3
897: and
898: p_step_or_rate is not null
899: then
900: hr_utility.set_message(8301, 'GHR_37636_ALL_PROCEDURE_FAIL');
901: hr_utility.raise_error;
902: end if;
903:
904: -- 700.67.3
905: if p_to_pay_plan = 'FG'
908: '07','08','09','10', '00')
909: and
910: p_step_or_rate is not null
911: then
912: hr_utility.set_message(8301, 'GHR_37637_ALL_PROCEDURE_FAIL');
913: hr_utility.raise_error;
914: end if;
915:
916: -- 700.69.3
909: and
910: p_step_or_rate is not null
911: then
912: hr_utility.set_message(8301, 'GHR_37637_ALL_PROCEDURE_FAIL');
913: hr_utility.raise_error;
914: end if;
915:
916: -- 700.69.3
917: /* If pay plan is IJ,
922: if p_to_pay_plan = 'IJ' and
923: p_pay_rate_determinant in ('0','7') and
924: p_step_or_rate not in ('01','02','03','04') and
925: p_step_or_rate is not null then
926: hr_utility.set_message(8301, 'GHR_38552_ALL_PROCEDURE_FAIL');
927: hr_utility.raise_error;
928: end if;
929:
930:
923: p_pay_rate_determinant in ('0','7') and
924: p_step_or_rate not in ('01','02','03','04') and
925: p_step_or_rate is not null then
926: hr_utility.set_message(8301, 'GHR_38552_ALL_PROCEDURE_FAIL');
927: hr_utility.raise_error;
928: end if;
929:
930:
931: end chk_step_or_rate;
949: p_supervisory_status_code <>'2'
950: and
951: p_supervisory_status_code is not null
952: then
953: hr_utility.set_message(8301, 'GHR_37638_ALL_PROCEDURE_FAIL');
954: hr_utility.raise_error;
955: end if;
956:
957: -- 710.10.3
950: and
951: p_supervisory_status_code is not null
952: then
953: hr_utility.set_message(8301, 'GHR_37638_ALL_PROCEDURE_FAIL');
954: hr_utility.raise_error;
955: end if;
956:
957: -- 710.10.3
958: if p_to_pay_plan = 'FA' and
959: p_supervisory_status_code <>'2'
960: and
961: p_supervisory_status_code is not null
962: then
963: hr_utility.set_message(8301, 'GHR_37639_ALL_PROCEDURE_FAIL');
964: hr_utility.raise_error;
965: end if;
966:
967: -- 710.13.3
960: and
961: p_supervisory_status_code is not null
962: then
963: hr_utility.set_message(8301, 'GHR_37639_ALL_PROCEDURE_FAIL');
964: hr_utility.raise_error;
965: end if;
966:
967: -- 710.13.3
968: if p_to_pay_plan in ('ES','EX','FE') and
969: (p_supervisory_status_code <>'2' and p_supervisory_status_code <>'8')
970: and
971: p_supervisory_status_code is not null
972: then
973: hr_utility.set_message(8301, 'GHR_37640_ALL_PROCEDURE_FAIL');
974: hr_utility.raise_error;
975: end if;
976:
977: -- 710.16.3
970: and
971: p_supervisory_status_code is not null
972: then
973: hr_utility.set_message(8301, 'GHR_37640_ALL_PROCEDURE_FAIL');
974: hr_utility.raise_error;
975: end if;
976:
977: -- 710.16.3
978: if p_to_pay_plan = 'GM' and
979: p_supervisory_status_code not in ('2','4','5','7')
980: and
981: p_supervisory_status_code is not null
982: then
983: hr_utility.set_message(8301, 'GHR_37641_ALL_PROCEDURE_FAIL');
984: hr_utility.raise_error;
985: end if;
986:
987: -- 710.19.3
980: and
981: p_supervisory_status_code is not null
982: then
983: hr_utility.set_message(8301, 'GHR_37641_ALL_PROCEDURE_FAIL');
984: hr_utility.raise_error;
985: end if;
986:
987: -- 710.19.3
988: if p_to_pay_plan in ('BL','JL','JQ','KL','NL',
990: (p_supervisory_status_code <>'6')
991: and
992: p_supervisory_status_code is not null
993: then
994: hr_utility.set_message(8301, 'GHR_37642_ALL_PROCEDURE_FAIL');
995: hr_utility.raise_error;
996: end if;
997:
998: -- 710.22.3
991: and
992: p_supervisory_status_code is not null
993: then
994: hr_utility.set_message(8301, 'GHR_37642_ALL_PROCEDURE_FAIL');
995: hr_utility.raise_error;
996: end if;
997:
998: -- 710.22.3
999: if p_to_pay_plan in ('BB','ED','EE','EF','EG',
1003: (p_supervisory_status_code <> '4' and p_supervisory_status_code <> '8')
1004: and
1005: p_supervisory_status_code is not null
1006: then
1007: hr_utility.set_message(8301, 'GHR_37643_ALL_PROCEDURE_FAIL');
1008: hr_utility.raise_error;
1009: end if;
1010: -- 710.25.3
1011: -- Dec 2001 Patch 1-Sep-2001 Delete WZ
1004: and
1005: p_supervisory_status_code is not null
1006: then
1007: hr_utility.set_message(8301, 'GHR_37643_ALL_PROCEDURE_FAIL');
1008: hr_utility.raise_error;
1009: end if;
1010: -- 710.25.3
1011: -- Dec 2001 Patch 1-Sep-2001 Delete WZ
1012: if p_effective_date <= to_date('2000/08/31','yyyy/mm/dd') THEN
1012: if p_effective_date <= to_date('2000/08/31','yyyy/mm/dd') THEN
1013: if p_to_pay_plan in ('BP','WB','WE','WM','WZ') and
1014: p_supervisory_status_code not in ('2','6','8') and
1015: p_supervisory_status_code is not null then
1016: hr_utility.set_message(8301, 'GHR_37644_ALL_PROCEDURE_FAIL');
1017: hr_utility.raise_error;
1018: end if;
1019: else
1020: if p_to_pay_plan in ('BP','WB','WE','WM') and
1013: if p_to_pay_plan in ('BP','WB','WE','WM','WZ') and
1014: p_supervisory_status_code not in ('2','6','8') and
1015: p_supervisory_status_code is not null then
1016: hr_utility.set_message(8301, 'GHR_37644_ALL_PROCEDURE_FAIL');
1017: hr_utility.raise_error;
1018: end if;
1019: else
1020: if p_to_pay_plan in ('BP','WB','WE','WM') and
1021: p_supervisory_status_code not in ('2','6','8') and
1019: else
1020: if p_to_pay_plan in ('BP','WB','WE','WM') and
1021: p_supervisory_status_code not in ('2','6','8') and
1022: p_supervisory_status_code is not null then
1023: hr_utility.set_message(8301, 'GHR_37923_ALL_PROCEDURE_FAIL');
1024: hr_utility.raise_error;
1025: end if;
1026: end if;
1027:
1020: if p_to_pay_plan in ('BP','WB','WE','WM') and
1021: p_supervisory_status_code not in ('2','6','8') and
1022: p_supervisory_status_code is not null then
1023: hr_utility.set_message(8301, 'GHR_37923_ALL_PROCEDURE_FAIL');
1024: hr_utility.raise_error;
1025: end if;
1026: end if;
1027:
1028: end chk_supervisory_status;
1045: begin
1046:
1047: -- 720.02.3
1048: if p_to_pay_plan ='ES' and p_tenure_group_code <> 0 then
1049: hr_utility.set_message(8301, 'GHR_37645_ALL_PROCEDURE_FAIL');
1050: hr_utility.raise_error;
1051: end if;
1052:
1053: -- 720.04.3
1046:
1047: -- 720.02.3
1048: if p_to_pay_plan ='ES' and p_tenure_group_code <> 0 then
1049: hr_utility.set_message(8301, 'GHR_37645_ALL_PROCEDURE_FAIL');
1050: hr_utility.raise_error;
1051: end if;
1052:
1053: -- 720.04.3
1054: if p_to_pay_plan in ('VM','VN','VP')
1056: p_tenure_group_code <>'1'
1057: and
1058: p_tenure_group_code is not null
1059: then
1060: hr_utility.set_message(8301, 'GHR_37646_ALL_PROCEDURE_FAIL');
1061: hr_utility.raise_error;
1062: end if;
1063:
1064: -- 720.08.3
1057: and
1058: p_tenure_group_code is not null
1059: then
1060: hr_utility.set_message(8301, 'GHR_37646_ALL_PROCEDURE_FAIL');
1061: hr_utility.raise_error;
1062: end if;
1063:
1064: -- 720.08.3
1065: if (p_Cur_Appt_Auth_1 in ('Y7M', 'Y8M', 'Y9K', 'Y9M') or
1066: p_Cur_Appt_Auth_2 in ('Y7M', 'Y8M', 'Y9K', 'Y9M')) and
1067: p_tenure_group_code not in ('0', '3' ) and
1068: p_tenure_group_code is not null
1069: then
1070: hr_utility.set_message(8301, 'GHR_37647_ALL_PROCEDURE_FAIL');
1071: hr_utility.raise_error;
1072: end if;
1073:
1074: -- 720.13.2
1067: p_tenure_group_code not in ('0', '3' ) and
1068: p_tenure_group_code is not null
1069: then
1070: hr_utility.set_message(8301, 'GHR_37647_ALL_PROCEDURE_FAIL');
1071: hr_utility.raise_error;
1072: end if;
1073:
1074: -- 720.13.2
1075: -- Updated_by Updated_on Effective_Date Description
1081: p_tenure_group_code <> '1' and
1082: p_tenure_group_code <> '2' and
1083: p_tenure_group_code is not null
1084: then
1085: hr_utility.set_message(8301, 'GHR_37648_ALL_PROCEDURE_FAIL');
1086: hr_utility.raise_error;
1087: end if;
1088: else
1089: if p_first_noac_lookup_code in ('100','130','140','500','540') and
1082: p_tenure_group_code <> '2' and
1083: p_tenure_group_code is not null
1084: then
1085: hr_utility.set_message(8301, 'GHR_37648_ALL_PROCEDURE_FAIL');
1086: hr_utility.raise_error;
1087: end if;
1088: else
1089: if p_first_noac_lookup_code in ('100','130','140','500','540') and
1090: p_tenure_group_code <> '1' and
1090: p_tenure_group_code <> '1' and
1091: p_tenure_group_code <> '2' and
1092: p_tenure_group_code is not null
1093: then
1094: hr_utility.set_message(8301, 'GHR_37700_ALL_PROCEDURE_FAIL');
1095: hr_utility.raise_error;
1096: end if;
1097: end if;
1098:
1091: p_tenure_group_code <> '2' and
1092: p_tenure_group_code is not null
1093: then
1094: hr_utility.set_message(8301, 'GHR_37700_ALL_PROCEDURE_FAIL');
1095: hr_utility.raise_error;
1096: end if;
1097: end if;
1098:
1099: -- 720.16.2
1103: if p_effective_date < to_date('2003/07/01','yyyy/mm/dd') THEN
1104: if p_first_noac_lookup_code in ('101','141','150','501','541','550') and
1105: p_tenure_group_code <>'2' and
1106: p_tenure_group_code is not null then
1107: hr_utility.set_message(8301, 'GHR_37649_ALL_PROCEDURE_FAIL');
1108: hr_utility.raise_error;
1109: end if;
1110: else
1111: if p_first_noac_lookup_code in ('101','141','501','541') and
1104: if p_first_noac_lookup_code in ('101','141','150','501','541','550') and
1105: p_tenure_group_code <>'2' and
1106: p_tenure_group_code is not null then
1107: hr_utility.set_message(8301, 'GHR_37649_ALL_PROCEDURE_FAIL');
1108: hr_utility.raise_error;
1109: end if;
1110: else
1111: if p_first_noac_lookup_code in ('101','141','501','541') and
1112: p_tenure_group_code <>'2' and
1110: else
1111: if p_first_noac_lookup_code in ('101','141','501','541') and
1112: p_tenure_group_code <>'2' and
1113: p_tenure_group_code is not null then
1114: hr_utility.set_message(8301, 'GHR_37587_ALL_PROCEDURE_FAIL');
1115: hr_utility.raise_error;
1116: end if;
1117: end if;
1118:
1111: if p_first_noac_lookup_code in ('101','141','501','541') and
1112: p_tenure_group_code <>'2' and
1113: p_tenure_group_code is not null then
1114: hr_utility.set_message(8301, 'GHR_37587_ALL_PROCEDURE_FAIL');
1115: hr_utility.raise_error;
1116: end if;
1117: end if;
1118:
1119: --UPDATED_BY DATE COMMENTS
1131: '522','524','553','554','571','590') and
1132: p_tenure_group_code <> '0' and
1133: p_tenure_group_code <> '3' and
1134: p_tenure_group_code is not null then
1135: hr_utility.set_message(8301, 'GHR_37650_ALL_PROCEDURE_FAIL');
1136: hr_utility.raise_error;
1137: end if;
1138: elsif p_effective_date < to_date('2003/07/01','yyyy/mm/dd') THEN
1139: -- removed noac 117 and 517 as per update 7
1132: p_tenure_group_code <> '0' and
1133: p_tenure_group_code <> '3' and
1134: p_tenure_group_code is not null then
1135: hr_utility.set_message(8301, 'GHR_37650_ALL_PROCEDURE_FAIL');
1136: hr_utility.raise_error;
1137: end if;
1138: elsif p_effective_date < to_date('2003/07/01','yyyy/mm/dd') THEN
1139: -- removed noac 117 and 517 as per update 7
1140: -- removed noacs 112, 512 for EOY I
1144: '522','524','553','554','571','590') and
1145: p_tenure_group_code <> '0' and
1146: p_tenure_group_code <> '3' and
1147: p_tenure_group_code is not null then
1148: hr_utility.set_message(8301, 'GHR_37870_ALL_PROCEDURE_FAIL');
1149: hr_utility.raise_error;
1150: end if;
1151: elsif p_effective_date < to_date('2007/05/01','RRRR/MM/DD') THEN -- Bug#6469079
1152: if p_first_noac_lookup_code in ('107','108','115','120',
1145: p_tenure_group_code <> '0' and
1146: p_tenure_group_code <> '3' and
1147: p_tenure_group_code is not null then
1148: hr_utility.set_message(8301, 'GHR_37870_ALL_PROCEDURE_FAIL');
1149: hr_utility.raise_error;
1150: end if;
1151: elsif p_effective_date < to_date('2007/05/01','RRRR/MM/DD') THEN -- Bug#6469079
1152: if p_first_noac_lookup_code in ('107','108','115','120',
1153: '122','124','171','190',
1155: '522','524','571','590') and
1156: p_tenure_group_code <> '0' and
1157: p_tenure_group_code <> '3' and
1158: p_tenure_group_code is not null then
1159: hr_utility.set_message(8301, 'GHR_37588_ALL_PROCEDURE_FAIL');
1160: hr_utility.set_message_token('NOAC','107, 108, 115, 120, 122, 124, 171, 190, 507, 508, 515, 520, 522, 524, 571, or 590');
1161: hr_utility.raise_error;
1162: end if;
1163: ELSE--Begin Bug#6469079
1156: p_tenure_group_code <> '0' and
1157: p_tenure_group_code <> '3' and
1158: p_tenure_group_code is not null then
1159: hr_utility.set_message(8301, 'GHR_37588_ALL_PROCEDURE_FAIL');
1160: hr_utility.set_message_token('NOAC','107, 108, 115, 120, 122, 124, 171, 190, 507, 508, 515, 520, 522, 524, 571, or 590');
1161: hr_utility.raise_error;
1162: end if;
1163: ELSE--Begin Bug#6469079
1164: if p_first_noac_lookup_code in ('107','108','115','120',
1157: p_tenure_group_code <> '3' and
1158: p_tenure_group_code is not null then
1159: hr_utility.set_message(8301, 'GHR_37588_ALL_PROCEDURE_FAIL');
1160: hr_utility.set_message_token('NOAC','107, 108, 115, 120, 122, 124, 171, 190, 507, 508, 515, 520, 522, 524, 571, or 590');
1161: hr_utility.raise_error;
1162: end if;
1163: ELSE--Begin Bug#6469079
1164: if p_first_noac_lookup_code in ('107','108','115','120',
1165: '122','124','190',
1167: '522','524','590') and
1168: p_tenure_group_code <> '0' and
1169: p_tenure_group_code <> '3' and
1170: p_tenure_group_code is not null then
1171: hr_utility.set_message(8301, 'GHR_37588_ALL_PROCEDURE_FAIL');
1172: hr_utility.set_message_token('NOAC','107, 108, 115, 120, 122, 124, 190, 507, 508, 515, 520, 522, 524, or 590');
1173: hr_utility.raise_error;
1174: end if;--End Bug#6469079
1175: end if;
1168: p_tenure_group_code <> '0' and
1169: p_tenure_group_code <> '3' and
1170: p_tenure_group_code is not null then
1171: hr_utility.set_message(8301, 'GHR_37588_ALL_PROCEDURE_FAIL');
1172: hr_utility.set_message_token('NOAC','107, 108, 115, 120, 122, 124, 190, 507, 508, 515, 520, 522, 524, or 590');
1173: hr_utility.raise_error;
1174: end if;--End Bug#6469079
1175: end if;
1176:
1169: p_tenure_group_code <> '3' and
1170: p_tenure_group_code is not null then
1171: hr_utility.set_message(8301, 'GHR_37588_ALL_PROCEDURE_FAIL');
1172: hr_utility.set_message_token('NOAC','107, 108, 115, 120, 122, 124, 190, 507, 508, 515, 520, 522, 524, or 590');
1173: hr_utility.raise_error;
1174: end if;--End Bug#6469079
1175: end if;
1176:
1177:
1184: if p_first_action_noa_la_code1 in ('YBM','YCM','YGM',
1185: 'Y1M','Y2M','Y3M') and
1186: p_tenure_group_code <>'2' and
1187: p_tenure_group_code is not null then
1188: hr_utility.set_message(8301, 'GHR_37919_ALL_PROCEDURE_FAIL');
1189: hr_utility.raise_error;
1190: end if;
1191: else
1192: if p_first_action_noa_la_code1 in ('YAM','YBM','YCM','YGM',
1185: 'Y1M','Y2M','Y3M') and
1186: p_tenure_group_code <>'2' and
1187: p_tenure_group_code is not null then
1188: hr_utility.set_message(8301, 'GHR_37919_ALL_PROCEDURE_FAIL');
1189: hr_utility.raise_error;
1190: end if;
1191: else
1192: if p_first_action_noa_la_code1 in ('YAM','YBM','YCM','YGM',
1193: 'Y1M','Y2M','Y3M','Y4M') and
1192: if p_first_action_noa_la_code1 in ('YAM','YBM','YCM','YGM',
1193: 'Y1M','Y2M','Y3M','Y4M') and
1194: p_tenure_group_code <>'2' and
1195: p_tenure_group_code is not null then
1196: hr_utility.set_message(8301, 'GHR_37651_ALL_PROCEDURE_FAIL');
1197: hr_utility.raise_error;
1198: end if;
1199: end if;
1200: else
1193: 'Y1M','Y2M','Y3M','Y4M') and
1194: p_tenure_group_code <>'2' and
1195: p_tenure_group_code is not null then
1196: hr_utility.set_message(8301, 'GHR_37651_ALL_PROCEDURE_FAIL');
1197: hr_utility.raise_error;
1198: end if;
1199: end if;
1200: else
1201: if p_first_action_noa_la_code1 in ('YAM','YBM','YCM','YGM',
1202: 'Y1M','Y2M','Y3M','Y4M') and
1203: substr(p_to_pay_plan,1,1) in ('Y') and
1204: p_tenure_group_code <>'2' and
1205: p_tenure_group_code is not null then
1206: hr_utility.set_message(8301, 'GHR_37187_ALL_PROCEDURE_FAIL');
1207: hr_utility.raise_error;
1208: end if;
1209: end if;
1210:
1203: substr(p_to_pay_plan,1,1) in ('Y') and
1204: p_tenure_group_code <>'2' and
1205: p_tenure_group_code is not null then
1206: hr_utility.set_message(8301, 'GHR_37187_ALL_PROCEDURE_FAIL');
1207: hr_utility.raise_error;
1208: end if;
1209: end if;
1210:
1211: -- 720.25.2
1212: if p_first_noac_lookup_code in ('170', '570') and
1213: p_first_action_noa_la_code1 not in ('ZKM','ZNM') and
1214: p_first_action_noa_la_code2 not in ('ZKM','ZNM') and
1215: p_tenure_group_code = '0' then
1216: hr_utility.set_message(8301, 'GHR_37652_ALL_PROCEDURE_FAIL');
1217: hr_utility.raise_error;
1218: end if;
1219:
1220: -- 720.28.2
1213: p_first_action_noa_la_code1 not in ('ZKM','ZNM') and
1214: p_first_action_noa_la_code2 not in ('ZKM','ZNM') and
1215: p_tenure_group_code = '0' then
1216: hr_utility.set_message(8301, 'GHR_37652_ALL_PROCEDURE_FAIL');
1217: hr_utility.raise_error;
1218: end if;
1219:
1220: -- 720.28.2
1221: -- added effective dates on 16-jul-1998
1223: if (p_first_noac_lookup_code in ('760','761')) and
1224: p_tenure_group_code <> '0' and
1225: p_tenure_group_code <> '3' and
1226: p_tenure_group_code is not null then
1227: hr_utility.set_message(8301, 'GHR_37653_ALL_PROCEDURE_FAIL');
1228: hr_utility.raise_error;
1229: end if;
1230: else
1231: if (p_first_noac_lookup_code = '760') and
1224: p_tenure_group_code <> '0' and
1225: p_tenure_group_code <> '3' and
1226: p_tenure_group_code is not null then
1227: hr_utility.set_message(8301, 'GHR_37653_ALL_PROCEDURE_FAIL');
1228: hr_utility.raise_error;
1229: end if;
1230: else
1231: if (p_first_noac_lookup_code = '760') and
1232: p_tenure_group_code <> '0' and
1231: if (p_first_noac_lookup_code = '760') and
1232: p_tenure_group_code <> '0' and
1233: p_tenure_group_code <> '3' and
1234: p_tenure_group_code is not null then
1235: hr_utility.set_message(8301, 'GHR_37869_ALL_PROCEDURE_FAIL');
1236: hr_utility.raise_error;
1237: end if;
1238: end if;
1239:
1232: p_tenure_group_code <> '0' and
1233: p_tenure_group_code <> '3' and
1234: p_tenure_group_code is not null then
1235: hr_utility.set_message(8301, 'GHR_37869_ALL_PROCEDURE_FAIL');
1236: hr_utility.raise_error;
1237: end if;
1238: end if;
1239:
1240: -- 720.31.2
1240: -- 720.31.2
1241: if p_first_noac_lookup_code = '765' and
1242: p_tenure_group_code <>'3' and
1243: p_tenure_group_code is not null then
1244: hr_utility.set_message(8301, 'GHR_37654_ALL_PROCEDURE_FAIL');
1245: hr_utility.raise_error;
1246: end if;
1247:
1248: -- 720.34.2
1241: if p_first_noac_lookup_code = '765' and
1242: p_tenure_group_code <>'3' and
1243: p_tenure_group_code is not null then
1244: hr_utility.set_message(8301, 'GHR_37654_ALL_PROCEDURE_FAIL');
1245: hr_utility.raise_error;
1246: end if;
1247:
1248: -- 720.34.2
1249: if (p_first_noac_lookup_code = '892' or p_first_noac_lookup_code = '893')
1249: if (p_first_noac_lookup_code = '892' or p_first_noac_lookup_code = '893')
1250: and
1251: p_to_pay_plan = 'GS' and
1252: p_tenure_group_code = '0' then
1253: hr_utility.set_message(8301, 'GHR_37655_ALL_PROCEDURE_FAIL');
1254: hr_utility.raise_error;
1255: end if;
1256:
1257: -- 720.35.3
1250: and
1251: p_to_pay_plan = 'GS' and
1252: p_tenure_group_code = '0' then
1253: hr_utility.set_message(8301, 'GHR_37655_ALL_PROCEDURE_FAIL');
1254: hr_utility.raise_error;
1255: end if;
1256:
1257: -- 720.35.3
1258: --UPDATED_BY DATE COMMENTS
1264: if (p_Cur_Appt_Auth_1 = 'ZKM' or p_Cur_Appt_Auth_2 = 'ZKM') and
1265: (p_to_pay_plan ='AD' or p_to_pay_plan ='EX') and
1266: ( p_tenure_group_code <> '0' and p_tenure_group_code <> '3')
1267: then
1268: hr_utility.set_message(8301, 'GHR_37656_ALL_PROCEDURE_FAIL');
1269: hr_utility.raise_error;
1270: end if;
1271: else
1272: if (p_Cur_Appt_Auth_1 = 'ZKM' or p_Cur_Appt_Auth_2 = 'ZKM') and
1265: (p_to_pay_plan ='AD' or p_to_pay_plan ='EX') and
1266: ( p_tenure_group_code <> '0' and p_tenure_group_code <> '3')
1267: then
1268: hr_utility.set_message(8301, 'GHR_37656_ALL_PROCEDURE_FAIL');
1269: hr_utility.raise_error;
1270: end if;
1271: else
1272: if (p_Cur_Appt_Auth_1 = 'ZKM' or p_Cur_Appt_Auth_2 = 'ZKM') and
1273: (p_to_pay_plan ='AD' or p_to_pay_plan ='EX') and
1272: if (p_Cur_Appt_Auth_1 = 'ZKM' or p_Cur_Appt_Auth_2 = 'ZKM') and
1273: (p_to_pay_plan ='AD' or p_to_pay_plan ='EX') and
1274: p_tenure_group_code <> '0'
1275: then
1276: hr_utility.set_message(8301, 'GHR_37589_ALL_PROCEDURE_FAIL');
1277: hr_utility.raise_error;
1278: end if;
1279: end if;
1280:
1273: (p_to_pay_plan ='AD' or p_to_pay_plan ='EX') and
1274: p_tenure_group_code <> '0'
1275: then
1276: hr_utility.set_message(8301, 'GHR_37589_ALL_PROCEDURE_FAIL');
1277: hr_utility.raise_error;
1278: end if;
1279: end if;
1280:
1281: -- 720.40.3
1281: -- 720.40.3
1282: if (p_Cur_Appt_Auth_1 = 'ZNM' or p_Cur_Appt_Auth_2 = 'ZNM') and
1283: (p_to_pay_plan ='AD' or p_to_pay_plan ='EX') and
1284: p_tenure_group_code <> '0' then
1285: hr_utility.set_message(8301, 'GHR_37657_ALL_PROCEDURE_FAIL');
1286: hr_utility.raise_error;
1287: end if;
1288:
1289: end chk_tenure;
1282: if (p_Cur_Appt_Auth_1 = 'ZNM' or p_Cur_Appt_Auth_2 = 'ZNM') and
1283: (p_to_pay_plan ='AD' or p_to_pay_plan ='EX') and
1284: p_tenure_group_code <> '0' then
1285: hr_utility.set_message(8301, 'GHR_37657_ALL_PROCEDURE_FAIL');
1286: hr_utility.raise_error;
1287: end if;
1288:
1289: end chk_tenure;
1290:
1303: if (p_first_action_noa_la_code1 in ('LBM','LZM','NEM','MMM') or
1304: p_first_action_noa_la_code2 in ('LBM','LZM','NEM','MMM')) and
1305: p_veterans_preference_code not in ('2','3','4','6') and
1306: p_veterans_preference_code is not null then
1307: hr_utility.set_message(8301, 'GHR_37658_ALL_PROCEDURE_FAIL');
1308: hr_utility.raise_error;
1309: end if;
1310:
1311: end chk_veterans_pref;
1304: p_first_action_noa_la_code2 in ('LBM','LZM','NEM','MMM')) and
1305: p_veterans_preference_code not in ('2','3','4','6') and
1306: p_veterans_preference_code is not null then
1307: hr_utility.set_message(8301, 'GHR_37658_ALL_PROCEDURE_FAIL');
1308: hr_utility.raise_error;
1309: end if;
1310:
1311: end chk_veterans_pref;
1312:
1331: or
1332: (p_agency_sub = 'CM63' and p_first_action_noa_la_code1 = 'XZM')
1333: )
1334: then
1335: hr_utility.set_message(8301, 'GHR_37659_ALL_PROCEDURE_FAIL');
1336: hr_utility.raise_error;
1337: end if;
1338:
1339: -- 760.05.3
1332: (p_agency_sub = 'CM63' and p_first_action_noa_la_code1 = 'XZM')
1333: )
1334: then
1335: hr_utility.set_message(8301, 'GHR_37659_ALL_PROCEDURE_FAIL');
1336: hr_utility.raise_error;
1337: end if;
1338:
1339: -- 760.05.3
1340: if p_veterans_status_code = 'X' and
1338:
1339: -- 760.05.3
1340: if p_veterans_status_code = 'X' and
1341: p_veterans_preference_code in ('2','3','4','6') then
1342: hr_utility.set_message(8301, 'GHR_37660_ALL_PROCEDURE_FAIL');
1343: hr_utility.raise_error;
1344: end if;
1345:
1346: -- 760.10.2
1339: -- 760.05.3
1340: if p_veterans_status_code = 'X' and
1341: p_veterans_preference_code in ('2','3','4','6') then
1342: hr_utility.set_message(8301, 'GHR_37660_ALL_PROCEDURE_FAIL');
1343: hr_utility.raise_error;
1344: end if;
1345:
1346: -- 760.10.2
1347: -- Updation Date Updated By Remarks
1350:
1351: if substr(p_first_noac_lookup_code,1,1) = '1' and
1352: p_first_noac_lookup_code <> '132' and
1353: p_veterans_status_code = 'N' then
1354: hr_utility.set_message(8301, 'GHR_37661_ALL_PROCEDURE_FAIL');
1355: hr_utility.raise_error;
1356: end if;
1357:
1358: end chk_veterans_status;
1351: if substr(p_first_noac_lookup_code,1,1) = '1' and
1352: p_first_noac_lookup_code <> '132' and
1353: p_veterans_status_code = 'N' then
1354: hr_utility.set_message(8301, 'GHR_37661_ALL_PROCEDURE_FAIL');
1355: hr_utility.raise_error;
1356: end if;
1357:
1358: end chk_veterans_status;
1359:
1371: -- 28-Nov-2002 Madhuri removed NOA Code 430
1372: if (p_first_noac_lookup_code ='280') and
1373: -- or p_first_noac_lookup_code ='430')
1374: (NVL(p_work_schedule_code,'G') not in ('G','Q','J','T')) then
1375: hr_utility.set_message(8301, 'GHR_37662_ALL_PROCEDURE_FAIL');
1376: hr_utility.raise_error;
1377: end if;
1378:
1379: end chk_work_schedule;
1372: if (p_first_noac_lookup_code ='280') and
1373: -- or p_first_noac_lookup_code ='430')
1374: (NVL(p_work_schedule_code,'G') not in ('G','Q','J','T')) then
1375: hr_utility.set_message(8301, 'GHR_37662_ALL_PROCEDURE_FAIL');
1376: hr_utility.raise_error;
1377: end if;
1378:
1379: end chk_work_schedule;
1380: --
1389: -- 780.03.1
1390: /* as_of_date is the same as effective date.
1391: if p_year_degree_attained is not null then
1392: if NOT (p_year_degree_attained <= p_as_of_date) then
1393: hr_utility.set_message(8301, 'GHR_99997_ALL_PROCEDURE_FAIL');
1394: hr_utility.raise_error;
1395: end if;
1396: end if;
1397: */
1390: /* as_of_date is the same as effective date.
1391: if p_year_degree_attained is not null then
1392: if NOT (p_year_degree_attained <= p_as_of_date) then
1393: hr_utility.set_message(8301, 'GHR_99997_ALL_PROCEDURE_FAIL');
1394: hr_utility.raise_error;
1395: end if;
1396: end if;
1397: */
1398: -- 780.03.2
1398: -- 780.03.2
1399: if p_year_degree_attained is not null then
1400: if NOT (to_number(p_year_degree_attained) <=
1401: to_number(to_char(p_effective_date,'YYYY'))) then
1402: hr_utility.set_message(8301, 'GHR_38411_ALL_PROCEDURE_FAIL');
1403: hr_utility.raise_error;
1404: end if;
1405: end if;
1406:
1399: if p_year_degree_attained is not null then
1400: if NOT (to_number(p_year_degree_attained) <=
1401: to_number(to_char(p_effective_date,'YYYY'))) then
1402: hr_utility.set_message(8301, 'GHR_38411_ALL_PROCEDURE_FAIL');
1403: hr_utility.raise_error;
1404: end if;
1405: end if;
1406:
1407: