[Home] [Help]
43: -- This edit bypassed when the 866 action and Temporary Promotion Step is not null
44: --
45: -- Madhuri 19-MAY-04 From the Start Including the Pay Plan VP in Prior Pay Plan list
46: --
47: IF GHR_GHRWS52L.g_temp_step is NULL
48: OR (GHR_GHRWS52L.g_temp_step is NOT NULL
49: AND p_first_noac_lookup_code <> '866' ) THEN
50: if (
51: p_prior_pay_plan in ('GS','VP') and (p_prior_pay_rate_det_code = '0' or
44: --
45: -- Madhuri 19-MAY-04 From the Start Including the Pay Plan VP in Prior Pay Plan list
46: --
47: IF GHR_GHRWS52L.g_temp_step is NULL
48: OR (GHR_GHRWS52L.g_temp_step is NOT NULL
49: AND p_first_noac_lookup_code <> '866' ) THEN
50: if (
51: p_prior_pay_plan in ('GS','VP') and (p_prior_pay_rate_det_code = '0' or
52: p_prior_pay_rate_det_code= '7') and
56: if not (
57: (l_table_pay = to_number(p_prior_basic_pay)) or
58: (p_prior_basic_pay is null or to_number(p_prior_basic_pay) = 0)
59: ) then
60: GHR_GHRWS52L.CPDF_Parameter_Check;
61: hr_utility.set_message(8301,'GHR_37746_ALL_PROCEDURE_FAIL');
62: hr_utility.raise_error;
63: end if;
64: end if;
75:
76: ) then
77: if not (l_table_pay = to_number(p_prior_basic_pay) or
78: (p_prior_basic_pay is null or to_number(p_prior_basic_pay) = 0)) then
79: GHR_GHRWS52L.CPDF_Parameter_Check;
80: hr_utility.set_message(8301,'GHR_37708_ALL_PROCEDURE_FAIL');
81: hr_utility.raise_error;
82: end if;
83: end if;
108: (p_to_basic_pay is not null and to_number(p_to_basic_pay) <> 0) and
109: (p_prior_pay_basis = p_to_pay_basis) ) and
110: to_number(p_prior_basic_pay) <> to_number(p_to_basic_pay))
111: ) then
112: GHR_GHRWS52L.CPDF_Parameter_Check;
113: hr_utility.set_message(8301,'GHR_37713_ALL_PROCEDURE_FAIL');
114: hr_utility.set_message_token('NOA_CODE','702, 703, 713, 721, 740, 741, 815-817, 825, 840-849, 855, 866-868, 871,878-879, 891-894');
115: hr_utility.raise_error;
116: end if;
128: (p_to_basic_pay is not null and to_number(p_to_basic_pay) <> 0) and
129: (p_prior_pay_basis = p_to_pay_basis) ) and
130: to_number(p_prior_basic_pay) <> to_number(p_to_basic_pay))
131: ) then
132: GHR_GHRWS52L.CPDF_Parameter_Check;
133: hr_utility.set_message(8301,'GHR_37713_ALL_PROCEDURE_FAIL');
134: hr_utility.set_message_token('NOA_CODE','702, 703, 713, 721, 740, 741, 815-817, 825, 840-848, 855, 866-868, 871,878-879, 891-894');
135: hr_utility.raise_error;
136: end if;
148: (p_to_basic_pay is not null and to_number(p_to_basic_pay) <> 0) and
149: (p_prior_pay_basis = p_to_pay_basis) ) and
150: to_number(p_prior_basic_pay) <> to_number(p_to_basic_pay))
151: ) then
152: GHR_GHRWS52L.CPDF_Parameter_Check;
153: hr_utility.set_message(8301,'GHR_37625_ALL_PROCEDURE_FAIL');
154: hr_utility.raise_error;
155: end if;
156: END IF;
166: ) then
167: if ((to_number(p_prior_basic_pay) < to_number(l_table_pay)) and
168: (p_prior_basic_pay is not null and to_number(p_prior_basic_pay) <> 0)
169: ) then
170: GHR_GHRWS52L.CPDF_Parameter_Check;
171: hr_utility.set_message(8301,'GHR_37719_ALL_PROCEDURE_FAIL');
172: hr_utility.raise_error;
173: end if;
174: end if;
190: p_prior_effective_date);
191: if not (
192: p_prior_basic_pay = l_table_pay or (p_prior_basic_pay is null or to_number(p_prior_basic_pay) = 0)
193: ) then
194: GHR_GHRWS52L.CPDF_Parameter_Check;
195: hr_utility.set_message(8301,'GHR_37726_ALL_PROCEDURE_FAIL');
196: hr_utility.raise_error;
197: end if;
198: end if;
225: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and
226: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay )
227: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
228: then
229: GHR_GHRWS52L.CPDF_Parameter_Check;
230: hr_utility.set_message(8301,'GHR_37865_ALL_PROCEDURE_FAIL');
231: hr_utility.raise_error;
232: end if;
233: end if;
253: if min_basic_pay IS NOT NULL and
254: (not(to_number(p_prior_basic_pay) >= min_basic_pay)
255: or p_prior_basic_pay is null)
256: then
257: GHR_GHRWS52L.CPDF_Parameter_Check;
258: hr_utility.set_message(8301,'GHR_37701_ALL_PROCEDURE_FAIL');
259: hr_utility.raise_error;
260: end if;
261: end if;
289: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and
290: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay )
291: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
292: then
293: GHR_GHRWS52L.CPDF_Parameter_Check;
294: hr_utility.set_message(8301,'GHR_37866_ALL_PROCEDURE_FAIL');
295: hr_utility.raise_error;
296: end if;
297: end if;
325: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and
326: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay )
327: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
328: then
329: GHR_GHRWS52L.CPDF_Parameter_Check;
330: hr_utility.set_message(8301,'GHR_37867_ALL_PROCEDURE_FAIL');
331: hr_utility.raise_error;
332: end if;
333: end if;
359: max_basic_pay IS NOT NULL and
360: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay)
361: or p_prior_basic_pay is null)
362: then
363: GHR_GHRWS52L.CPDF_Parameter_Check;
364: hr_utility.set_message(8301,'GHR_37702_ALL_PROCEDURE_FAIL');
365: hr_utility.raise_error;
366: end if;
367: end if;
382: max_basic_pay IS NOT NULL and
383: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay)
384: or p_prior_basic_pay is null)
385: then
386: GHR_GHRWS52L.CPDF_Parameter_Check;
387: hr_utility.set_message(8301,'GHR_37702_ALL_PROCEDURE_FAIL');
388: hr_utility.raise_error;
389: end if;
390: end if;
412: if min_basic_pay IS NOT NULL and
413: (not(to_number(p_prior_basic_pay) >= min_basic_pay)
414: or p_prior_basic_pay is null)
415: then
416: GHR_GHRWS52L.CPDF_Parameter_Check;
417: hr_utility.set_message(8301,'GHR_37703_ALL_PROCEDURE_FAIL');
418: hr_utility.set_message_token('PAY_PLAN','GM or GH');
419: hr_utility.raise_error;
420: end if;
429: if min_basic_pay IS NOT NULL and
430: (not(to_number(p_prior_basic_pay) >= min_basic_pay)
431: or p_prior_basic_pay is null)
432: then
433: GHR_GHRWS52L.CPDF_Parameter_Check;
434: hr_utility.set_message(8301,'GHR_37703_ALL_PROCEDURE_FAIL');
435: hr_utility.set_message_token('PAY_PLAN','GH, GM, or GS');
436: hr_utility.raise_error;
437: end if;
455: if max_basic_pay IS NOT NULL and
456: (to_number(p_prior_basic_pay) <> max_basic_pay
457: or p_prior_basic_pay is null or to_number(p_prior_basic_pay) = 0)
458: then
459: GHR_GHRWS52L.CPDF_Parameter_Check;
460: hr_utility.set_message(8301,'GHR_37704_ALL_PROCEDURE_FAIL');
461: hr_utility.raise_error;
462: end if;
463: end if;
486: if max_basic_pay IS NOT NULL and
487: (p_prior_basic_pay <> max_basic_pay
488: or p_prior_basic_pay is null or to_number(p_prior_basic_pay) = 0)
489: then
490: GHR_GHRWS52L.CPDF_Parameter_Check;
491: hr_utility.set_message(8301,'GHR_37705_ALL_PROCEDURE_FAIL');
492: hr_utility.raise_error;
493: end if;
494: end if;
516: p_effective_date);
517:
518: if not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay )
519: then
520: GHR_GHRWS52L.CPDF_Parameter_Check;
521: hr_utility.set_message(8301,'GHR_38885_ALL_PROCEDURE_FAIL');
522: -- NEED TO ADD A NEW MESSAGE HERE
523: hr_utility.raise_error;
524: end if;
574: if p_prior_pay_rate_det_code = '0'
575: and (not(to_number(p_prior_basic_pay) between nvl(min_basic_pay,0) and nvl(max_basic_pay,0))
576: or p_prior_basic_pay is null)
577: then
578: GHR_GHRWS52L.CPDF_Parameter_Check;
579: hr_utility.set_message(8301,'GHR_37706_ALL_PROCEDURE_FAIL');
580: hr_utility.raise_error;
581: end if;
582: end if;
606: p_prior_effective_date);
607: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL then
608: if (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay) or
609: p_prior_basic_pay is null or to_number(p_prior_basic_pay) = 0) then
610: GHR_GHRWS52L.CPDF_Parameter_Check;
611: hr_utility.set_message(8301,'GHR_37707_ALL_PROCEDURE_FAIL');
612: hr_utility.raise_error;
613: end if;
614: end if;
639: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL then
640: if (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay) or
641: p_prior_basic_pay is null or to_number(p_prior_basic_pay) = 0)
642: then
643: GHR_GHRWS52L.CPDF_Parameter_Check;
644: hr_utility.set_message(8301,'GHR_37709_ALL_PROCEDURE_FAIL');
645: hr_utility.raise_error;
646: end if;
647: end if;
666: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL then
667: if (not (to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay )
668: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
669: then
670: GHR_GHRWS52L.CPDF_Parameter_Check;
671: hr_utility.set_message(8301,'GHR_37710_ALL_PROCEDURE_FAIL');
672: hr_utility.raise_error;
673: end if;
674: end if;
697: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL then
698: if (not (to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay )
699: or p_prior_basic_pay is null or to_number(p_prior_basic_pay) = 0)
700: then
701: GHR_GHRWS52L.CPDF_Parameter_Check;
702: hr_utility.set_message(8301,'GHR_37711_ALL_PROCEDURE_FAIL');
703: hr_utility.raise_error;
704: end if;
705: end if;
727: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and
728: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay )
729: or p_prior_basic_pay is null or to_number(p_prior_basic_pay) = 0)
730: then
731: GHR_GHRWS52L.CPDF_Parameter_Check;
732: hr_utility.set_message(8301,'GHR_37712_ALL_PROCEDURE_FAIL');
733: hr_utility.raise_error;
734: end if;
735: end if;
746: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and
747: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay )
748: or p_prior_basic_pay is null or to_number(p_prior_basic_pay) = 0)
749: then
750: GHR_GHRWS52L.CPDF_Parameter_Check;
751: hr_utility.set_message(8301,'GHR_37712_ALL_PROCEDURE_FAIL');
752: hr_utility.raise_error;
753: end if;
754: end if;
776: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and
777: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay )
778: or p_prior_basic_pay is null or to_number(p_prior_basic_pay) = 0)
779: then
780: GHR_GHRWS52L.CPDF_Parameter_Check;
781: hr_utility.set_message(8301,'GHR_38405_ALL_PROCEDURE_FAIL');
782: hr_utility.raise_error;
783: end if;
784: end if;
805: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and
806: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay )
807: or p_prior_basic_pay is null or to_number(p_prior_basic_pay) = 0)
808: then
809: GHR_GHRWS52L.CPDF_Parameter_Check;
810: hr_utility.set_message(8301,'GHR_38406_ALL_PROCEDURE_FAIL');
811: hr_utility.raise_error;
812: end if;
813: end if;
829: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and
830: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay )
831: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
832: then
833: GHR_GHRWS52L.CPDF_Parameter_Check;
834: hr_utility.set_message(8301,'GHR_37714_ALL_PROCEDURE_FAIL');
835: hr_utility.raise_error;
836: end if;
837: end if;
854: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and
855: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay )
856: or p_prior_basic_pay is null or to_number(p_prior_basic_pay) = 0)
857: then
858: GHR_GHRWS52L.CPDF_Parameter_Check;
859: hr_utility.set_message(8301,'GHR_37715_ALL_PROCEDURE_FAIL');
860: hr_utility.raise_error;
861: end if;
862: end if;
888: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and
889: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay )
890: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
891: then
892: GHR_GHRWS52L.CPDF_Parameter_Check;
893: hr_utility.set_message(8301,'GHR_37716_ALL_PROCEDURE_FAIL');
894: hr_utility.raise_error;
895: end if;
896: end if;
913: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and
914: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay )
915: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
916: then
917: GHR_GHRWS52L.CPDF_Parameter_Check;
918: hr_utility.set_message(8301,'GHR_37717_ALL_PROCEDURE_FAIL');
919: hr_utility.raise_error;
920: end if;
921: end if;
951: if max_basic_pay IS NOT NULL and
952: (to_number(p_prior_basic_pay) <> max_basic_pay
953: or p_prior_basic_pay is null or to_number(p_prior_basic_pay) = 0)
954: then
955: GHR_GHRWS52L.CPDF_Parameter_Check;
956: hr_utility.set_message(8301,'GHR_37718_ALL_PROCEDURE_FAIL');
957: hr_utility.raise_error;
958: end if;
959: end if;
978: if max_basic_pay IS NOT NULL and
979: (not(to_number(p_prior_basic_pay) <= max_basic_pay)
980: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
981: then
982: GHR_GHRWS52L.CPDF_Parameter_Check;
983: hr_utility.set_message(8301,'GHR_37720_ALL_PROCEDURE_FAIL');
984: hr_utility.raise_error;
985: end if;
986: end if;
1021: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and
1022: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay)
1023: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
1024: then
1025: GHR_GHRWS52L.CPDF_Parameter_Check;
1026: hr_utility.set_message(8301,'GHR_37074_ALL_PROCEDURE_FAIL');
1027: hr_utility.raise_error;
1028: end if;
1029: end if;
1064: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and
1065: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay)
1066: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
1067: then
1068: GHR_GHRWS52L.CPDF_Parameter_Check;
1069: hr_utility.set_message(8301,'GHR_37075_ALL_PROCEDURE_FAIL');
1070: hr_utility.raise_error;
1071: end if;
1072: end if;
1107: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and
1108: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay)
1109: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
1110: then
1111: GHR_GHRWS52L.CPDF_Parameter_Check;
1112: hr_utility.set_message(8301,'GHR_37076_ALL_PROCEDURE_FAIL');
1113: hr_utility.raise_error;
1114: end if;
1115: end if;
1151: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and
1152: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay)
1153: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
1154: then
1155: GHR_GHRWS52L.CPDF_Parameter_Check;
1156: hr_utility.set_message(8301,'GHR_37077_ALL_PROCEDURE_FAIL');
1157: hr_utility.raise_error;
1158: end if;
1159: end if;
1180: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and
1181: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay)
1182: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
1183: then
1184: GHR_GHRWS52L.CPDF_Parameter_Check;
1185: hr_utility.set_message(8301,'GHR_37721_ALL_PROCEDURE_FAIL');
1186: hr_utility.raise_error;
1187: end if;
1188: end if;
1215: if max_basic_pay IS NOT NULL and
1216: (to_number(p_prior_basic_pay) <> max_basic_pay
1217: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
1218: then
1219: GHR_GHRWS52L.CPDF_Parameter_Check;
1220: hr_utility.set_message(8301,'GHR_37722_ALL_PROCEDURE_FAIL');
1221: hr_utility.raise_error;
1222: end if;
1223: end if;
1241: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and
1242: (to_number(p_prior_basic_pay) <> max_basic_pay
1243: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
1244: then
1245: GHR_GHRWS52L.CPDF_Parameter_Check;
1246: hr_utility.set_message(8301,'GHR_37723_ALL_PROCEDURE_FAIL');
1247: hr_utility.raise_error;
1248: end if;
1249: end if;
1271: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and
1272: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay)
1273: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
1274: then
1275: GHR_GHRWS52L.CPDF_Parameter_Check;
1276: hr_utility.set_message(8301,'GHR_37724_ALL_PROCEDURE_FAIL');
1277: hr_utility.raise_error;
1278: end if;
1279: end if;
1314: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL then
1315: if not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay)
1316: or p_prior_basic_pay is null
1317: then
1318: GHR_GHRWS52L.CPDF_Parameter_Check;
1319: hr_utility.set_message(8301,'GHR_38407_ALL_PROCEDURE_FAIL');
1320: hr_utility.raise_error;
1321: end if;
1322: end if;
1359: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL then
1360: if (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay)
1361: or p_prior_basic_pay is null)
1362: then
1363: GHR_GHRWS52L.CPDF_Parameter_Check;
1364: hr_utility.set_message(8301,'GHR_38408_ALL_PROCEDURE_FAIL');
1365: hr_utility.raise_error;
1366: end if;
1367: end if;
1395: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL then
1396: if (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay)
1397: or p_prior_basic_pay is null)
1398: then
1399: GHR_GHRWS52L.CPDF_Parameter_Check;
1400: hr_utility.set_message(8301,'GHR_38409_ALL_PROCEDURE_FAIL');
1401: hr_utility.raise_error;
1402: end if;
1403: end if;
1426: if max_basic_pay IS NOT NULL and
1427: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay)
1428: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
1429: then
1430: GHR_GHRWS52L.CPDF_Parameter_Check;
1431: hr_utility.set_message(8301,'GHR_37725_ALL_PROCEDURE_FAIL');
1432: hr_utility.raise_error;
1433: end if;
1434: end if;
1458: if max_basic_pay IS NOT NULL and min_basic_pay is not null and
1459: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay)
1460: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
1461: then
1462: GHR_GHRWS52L.CPDF_Parameter_Check;
1463: hr_utility.set_message(8301,'GHR_37727_ALL_PROCEDURE_FAIL');
1464: hr_utility.raise_error;
1465: end if;
1466: end if;
1482: if max_basic_pay IS NOT NULL and
1483: (not(to_number(p_prior_basic_pay) <> max_basic_pay)
1484: or p_prior_basic_pay is null)
1485: then
1486: GHR_GHRWS52L.CPDF_Parameter_Check;
1487: hr_utility.set_message(8301,'GHR_38410_ALL_PROCEDURE_FAIL');
1488: hr_utility.raise_error;
1489: end if;
1490: end if;
1509: if min_basic_pay IS NOT NULL and
1510: (not(to_number(p_prior_basic_pay) >= min_basic_pay)
1511: or p_prior_basic_pay is null or to_number(p_prior_basic_pay) = 0)
1512: then
1513: GHR_GHRWS52L.CPDF_Parameter_Check;
1514: hr_utility.set_message(8301,'GHR_37728_ALL_PROCEDURE_FAIL');
1515: hr_utility.raise_error;
1516: end if;
1517: end if;
1539: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay)
1540: or p_prior_basic_pay is null
1541: or to_number(p_prior_basic_pay) = 0)
1542: then
1543: GHR_GHRWS52L.CPDF_Parameter_Check;
1544: hr_utility.set_message(8301,'GHR_37729_ALL_PROCEDURE_FAIL');
1545: hr_utility.raise_error;
1546: end if;
1547: end if;
1618: '38','41','42','43','45','47','55','56','57','58','59','62','71','74','77','80','88','98')) then
1619: if ((trunc(p_effective_date) not between l_lpa_effective_start_date and
1620: nvl(l_lpa_effective_end_date, p_effective_date)) and
1621: (p_to_locality_adj is not null and to_number(p_to_locality_adj) <> 0)) then
1622: GHR_GHRWS52L.CPDF_Parameter_Check;
1623: hr_utility.set_message(8301,'GHR_37730_ALL_PROCEDURE_FAIL');
1624: hr_utility.raise_error;
1625: end if;
1626: end if;
1648: if (
1649: l_lpa_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2) and
1650: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
1651: ) then
1652: GHR_GHRWS52L.CPDF_Parameter_Check;
1653: hr_utility.set_message(8301,'GHR_37731_ALL_PROCEDURE_FAIL');
1654: --hr_utility.set_message_token('LOC_PAY','02 through 88');
1655: hr_utility.raise_error;
1656: end if;
1666: if (
1667: l_lpa_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2) and
1668: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
1669: ) then
1670: GHR_GHRWS52L.CPDF_Parameter_Check;
1671: hr_utility.set_message(8301,'GHR_38928_ALL_PROCEDURE_FAIL ');
1672: hr_utility.set_message_token('PRD_LIST','0, 3, 7, J, or K');
1673: hr_utility.raise_error;
1674: end if;
1689: if (
1690: l_lpa_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2) and
1691: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
1692: ) then
1693: GHR_GHRWS52L.CPDF_Parameter_Check;
1694: hr_utility.set_message(8301,'GHR_38928_ALL_PROCEDURE_FAIL');
1695: hr_utility.set_message_token('PRD_LIST','0, or 7');
1696: hr_utility.raise_error;
1697: end if;
1709: if (
1710: l_lpa_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2) and
1711: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
1712: ) then
1713: GHR_GHRWS52L.CPDF_Parameter_Check;
1714: hr_utility.set_message(8301,'GHR_37694_ALL_PROCEDURE_FAIL');
1715: hr_utility.raise_error;
1716: end if;
1717: end if;
1740: ) then
1741: if (l_lpa_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2) and
1742: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
1743: ) then
1744: GHR_GHRWS52L.CPDF_Parameter_Check;
1745: hr_utility.set_message(8301,'GHR_37747_ALL_PROCEDURE_FAIL');
1746: hr_utility.raise_error;
1747: end if;
1748: end if;
1756: ) then
1757: if (l_lpa_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2) and
1758: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
1759: ) then
1760: GHR_GHRWS52L.CPDF_Parameter_Check;
1761: hr_utility.set_message(8301,'GHR_38929_ALL_PROCEDURE_FAIL');
1762: hr_utility.set_message_token('PRD_LIST','0, 3, 7, J, or K');
1763: hr_utility.raise_error;
1764: end if;
1778: ) then
1779: if (l_lpa_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2) and
1780: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
1781: ) then
1782: GHR_GHRWS52L.CPDF_Parameter_Check;
1783: hr_utility.set_message(8301,'GHR_38929_ALL_PROCEDURE_FAIL');
1784: hr_utility.set_message_token('PRD_LIST','0, or 7');
1785: hr_utility.raise_error;
1786: end if;
1796: ) then
1797: if (l_lpa_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2) and
1798: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
1799: ) then
1800: GHR_GHRWS52L.CPDF_Parameter_Check;
1801: hr_utility.set_message(8301,'GHR_37695_ALL_PROCEDURE_FAIL');
1802: hr_utility.raise_error;
1803: end if;
1804: end if;
1837: if (
1838: l_lpa_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2) and
1839: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
1840: ) then
1841: GHR_GHRWS52L.CPDF_Parameter_Check;
1842: hr_utility.set_message(8301,'GHR_37732_ALL_PROCEDURE_FAIL');
1843: hr_utility.raise_error;
1844: end if;
1845: end if;
1856: if (
1857: l_lpa_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2) and
1858: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
1859: ) then
1860: GHR_GHRWS52L.CPDF_Parameter_Check;
1861: hr_utility.set_message(8301,'GHR_37868_ALL_PROCEDURE_FAIL');
1862: hr_utility.raise_error;
1863: end if;
1864: end if;
1875: if (
1876: l_lpa_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2) and
1877: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
1878: ) then
1879: GHR_GHRWS52L.CPDF_Parameter_Check;
1880: hr_utility.set_message(8301,'GHR_38930_ALL_PROCEDURE_FAIL');
1881: hr_utility.raise_error;
1882: end if;
1883: end if;
1887: p_pay_rate_determinant_code in ('6','5','E','F')
1888: ) then
1889:
1890: if to_number(p_to_locality_adj) <= 0 then
1891: GHR_GHRWS52L.CPDF_Parameter_Check;
1892: hr_utility.set_message(8301,'GHR_38981_ALL_PROCEDURE_FAIL');
1893: hr_utility.raise_error;
1894: end if;
1895: end if;*/
1902: l_pay_table <> '0491'
1903: ) then
1904:
1905: if to_number(p_to_locality_adj) <= 0 then
1906: GHR_GHRWS52L.CPDF_Parameter_Check;
1907: hr_utility.set_message(8301,'GHR_38981_ALL_PROCEDURE_FAIL');
1908: hr_utility.raise_error;
1909: end if;
1910: end if;
1944: if (
1945: l_lpa_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2) and
1946: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
1947: ) then
1948: GHR_GHRWS52L.CPDF_Parameter_Check;
1949: hr_utility.set_message(8301,'GHR_37748_ALL_PROCEDURE_FAIL');
1950: hr_utility.raise_error;
1951: end if;
1952: end if;
1962: if (
1963: l_lpa_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2) and
1964: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
1965: ) then
1966: GHR_GHRWS52L.CPDF_Parameter_Check;
1967: hr_utility.set_message(8301,'GHR_38931_ALL_PROCEDURE_FAIL');
1968: hr_utility.raise_error;
1969: end if;
1970: end if;
1973: if (
1974: p_to_pay_plan in ('GS','GM','GG','GH') and
1975: p_pay_rate_determinant_code in ('6','5') ) then
1976: if (to_number(p_to_locality_adj) <= 0 ) then
1977: GHR_GHRWS52L.CPDF_Parameter_Check;
1978: hr_utility.set_message(8301,'GHR_38982_ALL_PROCEDURE_FAIL');
1979: hr_utility.raise_error;
1980: end if;
1981: end if;*/
1999: -------------------------------------------------------------------------------
2000: IF p_effective_date < fnd_date.canonical_to_date('1998/09/01') then
2001: if (p_locality_pay_area = '99' and
2002: (p_to_locality_adj is not null and to_number(p_to_locality_adj) <> 0)) then
2003: GHR_GHRWS52L.CPDF_Parameter_Check;
2004: hr_utility.set_message(8301,'GHR_37733_ALL_PROCEDURE_FAIL');
2005: hr_utility.raise_error;
2006: end if;
2007: ELSE -- meaning bet 01-SEP-1998 to 01-JAN-2005
2101: ) and
2102: p_pay_rate_determinant_code not in ('A','B','E','F','S','U','V') and
2103: (p_to_locality_adj is not null and to_number(p_to_locality_adj) <> 0)
2104: ) then
2105: GHR_GHRWS52L.CPDF_Parameter_Check;
2106: hr_utility.set_message(8301,'GHR_37734_ALL_PROCEDURE_FAIL');
2107: hr_utility.set_message_token('PRD_LIST','A, B, E, F, S, U, or V');
2108: hr_utility.raise_error;
2109: end if;
2115: ) and
2116: p_pay_rate_determinant_code not in ('A','B','E','F','S') and
2117: (p_to_locality_adj is not null and to_number(p_to_locality_adj) <> 0)
2118: ) then
2119: GHR_GHRWS52L.CPDF_Parameter_Check;
2120: hr_utility.set_message(8301,'GHR_37734_ALL_PROCEDURE_FAIL');
2121: hr_utility.set_message_token('PRD_LIST','A, B, E, F, or S');
2122: hr_utility.raise_error;
2123: end if;
2129: if (
2130: p_pay_rate_determinant_code = 'C' and
2131: (p_to_locality_adj is not null and to_number(p_to_locality_adj) <> 0)
2132: ) then
2133: GHR_GHRWS52L.CPDF_Parameter_Check;
2134: hr_utility.set_message(8301,'GHR_37735_ALL_PROCEDURE_FAIL');
2135: hr_utility.raise_error;
2136: end if;
2137: END IF;
2158: p_locality_pay_area between '02' and '88' and
2159: (p_to_locality_adj is null) ) and
2160: ( p_first_noac_lookup_code <> '817' )
2161: then
2162: GHR_GHRWS52L.CPDF_Parameter_Check;
2163: hr_utility.set_message(8301,'GHR_37736_ALL_PROCEDURE_FAIL');
2164: hr_utility.raise_error;
2165: end if;
2166:
2170: p_locality_pay_area NOT IN ('ZY','ZZ') and
2171: (p_to_locality_adj is null)) and
2172: ( p_first_noac_lookup_code <> '817' )
2173: then
2174: GHR_GHRWS52L.CPDF_Parameter_Check;
2175: hr_utility.set_message(8301,'GHR_38933_ALL_PROCEDURE_FAIL');
2176: hr_utility.set_message_token('PRD_LIST','A, B, E, F, U, or V');
2177: hr_utility.raise_error;
2178: end if;
2183: p_pay_rate_determinant_code in ('A','B','E','F') and
2184: p_locality_pay_area NOT IN ('ZY','ZZ') and
2185: (p_to_locality_adj is null))
2186: and ( p_first_noac_lookup_code <> '817' ) then
2187: GHR_GHRWS52L.CPDF_Parameter_Check;
2188: hr_utility.set_message(8301,'GHR_38933_ALL_PROCEDURE_FAIL');
2189: hr_utility.set_message_token('PRD_LIST','A, B, E, or F');
2190: hr_utility.raise_error;
2191: end if;
2196: p_locality_pay_area NOT IN ('ZZ') and
2197: (p_to_locality_adj is null)) and
2198: ( p_first_noac_lookup_code <> '817' )
2199: then
2200: GHR_GHRWS52L.CPDF_Parameter_Check;
2201: if ( p_effective_date < to_date('01/09/2006', 'dd/mm/yyyy') ) THEN
2202: hr_utility.set_message(8301,'GHR_37696_ALL_PROCEDURE_FAIL');
2203: hr_utility.raise_error;
2204: else
2235: if (
2236: l_lpa_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2) and
2237: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
2238: ) then
2239: GHR_GHRWS52L.CPDF_Parameter_Check;
2240: hr_utility.set_message(8301,'GHR_37737_ALL_PROCEDURE_FAIL');
2241: hr_utility.raise_error;
2242: end if;
2243: end if;
2267: if (
2268: l_lpa_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2) and
2269: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
2270: ) then
2271: GHR_GHRWS52L.CPDF_Parameter_Check;
2272: hr_utility.set_message(8301,'GHR_37749_ALL_PROCEDURE_FAIL');
2273: hr_utility.raise_error;
2274: end if;
2275: end if;
2292: if (
2293: l_lpa_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2) and
2294: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
2295: ) then
2296: GHR_GHRWS52L.CPDF_Parameter_Check;
2297: hr_utility.set_message(8301,'GHR_37738_ALL_PROCEDURE_FAIL');
2298: hr_utility.raise_error;
2299: end if;
2300: end if;
2320: if (
2321: round(((nvl(to_number(p_to_locality_adj),0)/to_number(p_to_basic_pay))*100),2)
2322: not between l_lpa_pct and l_leo_pct
2323: ) then
2324: GHR_GHRWS52L.CPDF_Parameter_Check;
2325: hr_utility.set_message(8301,'GHR_37759_ALL_PROCEDURE_FAIL');
2326: hr_utility.raise_error;
2327: end if;
2328: end if;
2335: if (
2336: round(((nvl(to_number(p_to_locality_adj),0)/to_number(p_to_basic_pay))*100),2)
2337: not between l_lpa_pct and l_leo_pct
2338: ) then
2339: GHR_GHRWS52L.CPDF_Parameter_Check;
2340: hr_utility.set_message(8301,'GHR_38934_ALL_PROCEDURE_FAIL');
2341: hr_utility.set_message_token('PRD_LIST','0, 3, 7, J, or K');
2342: hr_utility.raise_error;
2343: end if;
2355: if (
2356: round(((nvl(to_number(p_to_locality_adj),0)/to_number(p_to_basic_pay))*100),2)
2357: not between l_lpa_pct and l_leo_pct
2358: ) then
2359: GHR_GHRWS52L.CPDF_Parameter_Check;
2360: hr_utility.set_message(8301,'GHR_38934_ALL_PROCEDURE_FAIL');
2361: hr_utility.set_message_token('PRD_LIST','0, or 7');
2362: hr_utility.raise_error;
2363: end if;
2376: )
2377: and
2378: (p_to_locality_adj is null)
2379: ) then
2380: GHR_GHRWS52L.CPDF_Parameter_Check;
2381: hr_utility.set_message(8301,'GHR_37739_ALL_PROCEDURE_FAIL');
2382: hr_utility.raise_error;
2383: end if;
2384: */
2452: if (
2453: l_lpa_pct < round((nvl(to_number(p_prior_locality_adj),0)/to_number(p_prior_basic_pay))*100,2) and
2454: l_leo_pct < round((nvl(to_number(p_prior_locality_adj),0)/to_number(p_prior_basic_pay))*100,2)
2455: ) then
2456: GHR_GHRWS52L.CPDF_Parameter_Check;
2457: hr_utility.set_message(8301,'GHR_37741_ALL_PROCEDURE_FAIL');
2458: hr_utility.raise_error;
2459: end if;
2460: end if;
2493: if (
2494: l_lpa_pct < round((to_number(p_prior_locality_adj)/to_number(p_prior_basic_pay)*100),2) and
2495: l_leo_pct < round((to_number(p_prior_locality_adj)/to_number(p_prior_basic_pay)*100),2)
2496: ) then
2497: GHR_GHRWS52L.CPDF_Parameter_Check;
2498: hr_utility.set_message(8301,'GHR_37742_ALL_PROCEDURE_FAIL');
2499: hr_utility.raise_error;
2500: end if;
2501: end if;
2510: if (
2511: l_lpa_pct < round((to_number(p_prior_locality_adj)/to_number(p_prior_basic_pay)*100),2) and
2512: l_leo_pct < round((to_number(p_prior_locality_adj)/to_number(p_prior_basic_pay)*100),2)
2513: ) then
2514: GHR_GHRWS52L.CPDF_Parameter_Check;
2515: hr_utility.set_message(8301,'GHR_38935_ALL_PROCEDURE_FAIL'); -- NEW MESG TOKEN REQD
2516: hr_utility.set_message_token('PRD_LIST','0, 3, 7, J, or K');
2517: hr_utility.raise_error;
2518: end if;
2532: if (
2533: l_lpa_pct < round((to_number(p_prior_locality_adj)/to_number(p_prior_basic_pay)*100),2) and
2534: l_leo_pct < round((to_number(p_prior_locality_adj)/to_number(p_prior_basic_pay)*100),2)
2535: ) then
2536: GHR_GHRWS52L.CPDF_Parameter_Check;
2537: hr_utility.set_message(8301,'GHR_38935_ALL_PROCEDURE_FAIL');
2538: hr_utility.set_message_token('PRD_LIST','0, or 7');
2539: hr_utility.raise_error;
2540: end if;
2551: if (
2552: l_lpa_pct < round((to_number(p_prior_locality_adj)/to_number(p_prior_basic_pay)*100),2) and
2553: l_leo_pct < round((to_number(p_prior_locality_adj)/to_number(p_prior_basic_pay)*100),2)
2554: ) then
2555: GHR_GHRWS52L.CPDF_Parameter_Check;
2556: hr_utility.set_message(8301,'GHR_37697_ALL_PROCEDURE_FAIL');
2557: hr_utility.raise_error;
2558: end if;
2559: end if;
2596: if (
2597: l_lpa_pct < round((to_number(p_prior_locality_adj)/to_number(p_prior_basic_pay)*100),2) and
2598: l_leo_pct < round((to_number(p_prior_locality_adj)/to_number(p_prior_basic_pay)*100),2)
2599: ) then
2600: GHR_GHRWS52L.CPDF_Parameter_Check;
2601: hr_utility.set_message(8301,'GHR_37680_ALL_PROCEDURE_FAIL');
2602: hr_utility.raise_error;
2603: end if;
2604: end if;
2614: if (
2615: l_lpa_pct < round((to_number(p_prior_locality_adj)/to_number(p_prior_basic_pay)*100),2) and
2616: l_leo_pct < round((to_number(p_prior_locality_adj)/to_number(p_prior_basic_pay)*100),2)
2617: ) then
2618: GHR_GHRWS52L.CPDF_Parameter_Check;
2619: hr_utility.set_message(8301,'GHR_38936_ALL_PROCEDURE_FAIL');
2620: hr_utility.raise_error;
2621: end if;
2622: end if;
2624: if ( nvl(p_prior_pay_plan,hr_api.g_varchar2) in ('GS','GM','GG','GH') and
2625: nvl(p_prior_pay_rate_det_code,hr_api.g_varchar2) in ('5','6')
2626: ) then
2627: if to_number(p_prior_locality_adj) <= 0 then
2628: GHR_GHRWS52L.CPDF_Parameter_Check;
2629: hr_utility.set_message(8301,'GHR_38979_ALL_PROCEDURE_FAIL');
2630: hr_utility.raise_error;
2631: end if;
2632: end if;
2651: -------------------------------------------------------------------------------
2652: IF p_effective_date < fnd_date.canonical_to_date('1998/09/01') THEN
2653: if (p_prior_locality_pay_area = '99' and
2654: (p_prior_locality_adj is not null and to_number(p_prior_locality_adj) <> 0)) then
2655: GHR_GHRWS52L.CPDF_Parameter_Check;
2656: hr_utility.set_message(8301,'GHR_37743_ALL_PROCEDURE_FAIL');
2657: hr_utility.raise_error;
2658: end if;
2659: ELSE
2665: if p_prior_locality_pay_area = '99' and
2666: p_prior_locality_adj is not null and
2667: to_number(p_prior_locality_adj) <> 0
2668: then
2669: GHR_GHRWS52L.CPDF_Parameter_Check;
2670: hr_utility.set_message(8301,'GHR_37898_ALL_PROCEDURE_FAIL');
2671: hr_utility.raise_error;
2672: end if;
2673: -- FWFA Changes
2678: if p_prior_locality_pay_area = 'ZZ' and
2679: p_prior_locality_adj is not null and
2680: to_number(p_prior_locality_adj) <> 0
2681: then
2682: GHR_GHRWS52L.CPDF_Parameter_Check;
2683: hr_utility.set_message(8301,'GHR_38937_ALL_PROCEDURE_FAIL');
2684: hr_utility.raise_error;
2685: end if;
2686: ELSif p_effective_date < fnd_date.canonical_to_date('2006/04/01') then
2688: p_prior_pay_rate_det_code not in ('5','6','E','F') and
2689: p_prior_locality_adj is not null and
2690: to_number(p_prior_locality_adj) <> 0
2691: then
2692: GHR_GHRWS52L.CPDF_Parameter_Check;
2693: hr_utility.set_message(8301,'GHR_38980_ALL_PROCEDURE_FAIL');
2694: hr_utility.raise_error;
2695: end if;
2696: ELSE
2700: p_prior_pay_plan in ('GM','GS') and
2701: p_prior_locality_adj is not null and
2702: to_number(p_prior_locality_adj) <> 0
2703: then
2704: GHR_GHRWS52L.CPDF_Parameter_Check;
2705: hr_utility.set_message(8301,'GHR_37162_ALL_PROCEDURE_FAIL');
2706: hr_utility.raise_error;
2707: end if;
2708: END IF;
2754: p_prior_pay_plan in ('EH','EI','EX','ZZ')) and
2755: p_prior_pay_rate_det_code not in ('A','B','E','F','S','U','V') and
2756: (p_prior_locality_adj is not null and to_number(p_prior_locality_adj) <> 0)
2757: ) then
2758: GHR_GHRWS52L.CPDF_Parameter_Check;
2759: hr_utility.set_message(8301,'GHR_37744_ALL_PROCEDURE_FAIL');
2760: hr_utility.set_message_token('PRD_LIST','A, B, E, F, S, U, or V');
2761: hr_utility.raise_error;
2762: end if;
2768: p_prior_pay_plan in ('EH','EI','EX','ZZ')) and
2769: p_prior_pay_rate_det_code not in ('A','B','E','F','S') and
2770: (p_prior_locality_adj is not null and to_number(p_prior_locality_adj) <> 0)
2771: ) then
2772: GHR_GHRWS52L.CPDF_Parameter_Check;
2773: hr_utility.set_message(8301,'GHR_37744_ALL_PROCEDURE_FAIL');
2774: hr_utility.set_message_token('PRD_LIST','A, B, E, F, or S');
2775: hr_utility.raise_error;
2776: end if;
2785: p_prior_pay_rate_det_code = 'C' and
2786: (p_prior_locality_adj is not null and to_number(p_prior_locality_adj) <> 0)
2787:
2788: ) then
2789: GHR_GHRWS52L.CPDF_Parameter_Check;
2790: hr_utility.set_message(8301,'GHR_37745_ALL_PROCEDURE_FAIL');
2791: hr_utility.raise_error;
2792: end if;
2793: