[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;
77:
78: ) then
79: if not (l_table_pay = to_number(p_prior_basic_pay) or
80: (p_prior_basic_pay is null or to_number(p_prior_basic_pay) = 0)) then
81: GHR_GHRWS52L.CPDF_Parameter_Check;
82: hr_utility.set_message(8301,'GHR_37708_ALL_PROCEDURE_FAIL');
83: hr_utility.raise_error;
84: end if;
85: end if;
111: (p_to_basic_pay is not null and to_number(p_to_basic_pay) <> 0) and
112: (p_prior_pay_basis = p_to_pay_basis) ) and
113: to_number(p_prior_basic_pay) <> to_number(p_to_basic_pay))
114: ) then
115: GHR_GHRWS52L.CPDF_Parameter_Check;
116: hr_utility.set_message(8301,'GHR_37713_ALL_PROCEDURE_FAIL');
117: 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');
118: hr_utility.raise_error;
119: end if;
131: (p_to_basic_pay is not null and to_number(p_to_basic_pay) <> 0) and
132: (p_prior_pay_basis = p_to_pay_basis) ) and
133: to_number(p_prior_basic_pay) <> to_number(p_to_basic_pay))
134: ) then
135: GHR_GHRWS52L.CPDF_Parameter_Check;
136: hr_utility.set_message(8301,'GHR_37713_ALL_PROCEDURE_FAIL');
137: 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');
138: hr_utility.raise_error;
139: end if;
151: (p_to_basic_pay is not null and to_number(p_to_basic_pay) <> 0) and
152: (p_prior_pay_basis = p_to_pay_basis) ) and
153: to_number(p_prior_basic_pay) <> to_number(p_to_basic_pay))
154: ) then
155: GHR_GHRWS52L.CPDF_Parameter_Check;
156: hr_utility.set_message(8301,'GHR_37625_ALL_PROCEDURE_FAIL');
157: hr_utility.raise_error;
158: end if;
159: END IF;
169: ) then
170: if ((to_number(p_prior_basic_pay) < to_number(l_table_pay)) and
171: (p_prior_basic_pay is not null and to_number(p_prior_basic_pay) <> 0)
172: ) then
173: GHR_GHRWS52L.CPDF_Parameter_Check;
174: hr_utility.set_message(8301,'GHR_37719_ALL_PROCEDURE_FAIL');
175: hr_utility.raise_error;
176: end if;
177: end if;
193: p_prior_effective_date);
194: if not (
195: p_prior_basic_pay = l_table_pay or (p_prior_basic_pay is null or to_number(p_prior_basic_pay) = 0)
196: ) then
197: GHR_GHRWS52L.CPDF_Parameter_Check;
198: hr_utility.set_message(8301,'GHR_37726_ALL_PROCEDURE_FAIL');
199: hr_utility.raise_error;
200: end if;
201: end if;
228: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and
229: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay )
230: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
231: then
232: GHR_GHRWS52L.CPDF_Parameter_Check;
233: hr_utility.set_message(8301,'GHR_37865_ALL_PROCEDURE_FAIL');
234: hr_utility.raise_error;
235: end if;
236: end if;
256: if min_basic_pay IS NOT NULL and
257: (not(to_number(p_prior_basic_pay) >= min_basic_pay)
258: or p_prior_basic_pay is null)
259: then
260: GHR_GHRWS52L.CPDF_Parameter_Check;
261: hr_utility.set_message(8301,'GHR_37701_ALL_PROCEDURE_FAIL');
262: hr_utility.raise_error;
263: end if;
264: end if;
292: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and
293: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay )
294: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
295: then
296: GHR_GHRWS52L.CPDF_Parameter_Check;
297: hr_utility.set_message(8301,'GHR_37866_ALL_PROCEDURE_FAIL');
298: hr_utility.raise_error;
299: end if;
300: end if;
328: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and
329: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay )
330: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
331: then
332: GHR_GHRWS52L.CPDF_Parameter_Check;
333: hr_utility.set_message(8301,'GHR_37867_ALL_PROCEDURE_FAIL');
334: hr_utility.raise_error;
335: end if;
336: end if;
362: max_basic_pay IS NOT NULL and
363: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay)
364: or p_prior_basic_pay is null)
365: then
366: GHR_GHRWS52L.CPDF_Parameter_Check;
367: hr_utility.set_message(8301,'GHR_37702_ALL_PROCEDURE_FAIL');
368: hr_utility.raise_error;
369: end if;
370: end if;
385: max_basic_pay IS NOT NULL and
386: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay)
387: or p_prior_basic_pay is null)
388: then
389: GHR_GHRWS52L.CPDF_Parameter_Check;
390: hr_utility.set_message(8301,'GHR_37702_ALL_PROCEDURE_FAIL');
391: hr_utility.raise_error;
392: end if;
393: end if;
415: if min_basic_pay IS NOT NULL and
416: (not(to_number(p_prior_basic_pay) >= min_basic_pay)
417: or p_prior_basic_pay is null)
418: then
419: GHR_GHRWS52L.CPDF_Parameter_Check;
420: hr_utility.set_message(8301,'GHR_37703_ALL_PROCEDURE_FAIL');
421: hr_utility.set_message_token('PAY_PLAN','GM or GH');
422: hr_utility.raise_error;
423: end if;
432: if min_basic_pay IS NOT NULL and
433: (not(to_number(p_prior_basic_pay) >= min_basic_pay)
434: or p_prior_basic_pay is null)
435: then
436: GHR_GHRWS52L.CPDF_Parameter_Check;
437: hr_utility.set_message(8301,'GHR_37703_ALL_PROCEDURE_FAIL');
438: hr_utility.set_message_token('PAY_PLAN','GH, GM, or GS');
439: hr_utility.raise_error;
440: end if;
458: if max_basic_pay IS NOT NULL and
459: (to_number(p_prior_basic_pay) <> max_basic_pay
460: or p_prior_basic_pay is null or to_number(p_prior_basic_pay) = 0)
461: then
462: GHR_GHRWS52L.CPDF_Parameter_Check;
463: hr_utility.set_message(8301,'GHR_37704_ALL_PROCEDURE_FAIL');
464: hr_utility.raise_error;
465: end if;
466: end if;
489: if max_basic_pay IS NOT NULL and
490: (p_prior_basic_pay <> max_basic_pay
491: or p_prior_basic_pay is null or to_number(p_prior_basic_pay) = 0)
492: then
493: GHR_GHRWS52L.CPDF_Parameter_Check;
494: hr_utility.set_message(8301,'GHR_37705_ALL_PROCEDURE_FAIL');
495: hr_utility.raise_error;
496: end if;
497: end if;
519: p_effective_date);
520:
521: if not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay )
522: then
523: GHR_GHRWS52L.CPDF_Parameter_Check;
524: hr_utility.set_message(8301,'GHR_38885_ALL_PROCEDURE_FAIL');
525: -- NEED TO ADD A NEW MESSAGE HERE
526: hr_utility.raise_error;
527: end if;
577: if p_prior_pay_rate_det_code = '0'
578: and (not(to_number(p_prior_basic_pay) between nvl(min_basic_pay,0) and nvl(max_basic_pay,0))
579: or p_prior_basic_pay is null)
580: then
581: GHR_GHRWS52L.CPDF_Parameter_Check;
582: hr_utility.set_message(8301,'GHR_37706_ALL_PROCEDURE_FAIL');
583: hr_utility.raise_error;
584: end if;
585: end if;
604: p_prior_effective_date);
605: if not (
606: p_prior_basic_pay = l_table_pay or (p_prior_basic_pay is null or to_number(p_prior_basic_pay) = 0)
607: ) then
608: GHR_GHRWS52L.CPDF_Parameter_Check;
609: hr_utility.set_message(8301,'GHR_37750_ALL_PROCEDURE_FAIL');
610: hr_utility.raise_error;
611: end if;
612: END IF;
636: p_prior_effective_date);
637: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL then
638: if (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay) or
639: p_prior_basic_pay is null or to_number(p_prior_basic_pay) = 0) then
640: GHR_GHRWS52L.CPDF_Parameter_Check;
641: hr_utility.set_message(8301,'GHR_37707_ALL_PROCEDURE_FAIL');
642: hr_utility.raise_error;
643: end if;
644: end if;
669: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL then
670: if (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay) or
671: p_prior_basic_pay is null or to_number(p_prior_basic_pay) = 0)
672: then
673: GHR_GHRWS52L.CPDF_Parameter_Check;
674: hr_utility.set_message(8301,'GHR_37709_ALL_PROCEDURE_FAIL');
675: hr_utility.raise_error;
676: end if;
677: end if;
698: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL then
699: if (not (to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay )
700: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
701: then
702: GHR_GHRWS52L.CPDF_Parameter_Check;
703: hr_utility.set_message(8301,'GHR_37710_ALL_PROCEDURE_FAIL');
704: hr_utility.raise_error;
705: end if;
706: end if;
730: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL then
731: if (not (to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay )
732: or p_prior_basic_pay is null or to_number(p_prior_basic_pay) = 0)
733: then
734: GHR_GHRWS52L.CPDF_Parameter_Check;
735: hr_utility.set_message(8301,'GHR_37711_ALL_PROCEDURE_FAIL');
736: hr_utility.raise_error;
737: end if;
738: end if;
762: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and
763: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay )
764: or p_prior_basic_pay is null or to_number(p_prior_basic_pay) = 0)
765: then
766: GHR_GHRWS52L.CPDF_Parameter_Check;
767: hr_utility.set_message(8301,'GHR_37712_ALL_PROCEDURE_FAIL');
768: hr_utility.raise_error;
769: end if;
770: end if;
781: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and
782: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay )
783: or p_prior_basic_pay is null or to_number(p_prior_basic_pay) = 0)
784: then
785: GHR_GHRWS52L.CPDF_Parameter_Check;
786: hr_utility.set_message(8301,'GHR_37712_ALL_PROCEDURE_FAIL');
787: hr_utility.raise_error;
788: end if;
789: end if;
811: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and
812: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay )
813: or p_prior_basic_pay is null or to_number(p_prior_basic_pay) = 0)
814: then
815: GHR_GHRWS52L.CPDF_Parameter_Check;
816: hr_utility.set_message(8301,'GHR_38405_ALL_PROCEDURE_FAIL');
817: hr_utility.raise_error;
818: end if;
819: end if;
840: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and
841: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay )
842: or p_prior_basic_pay is null or to_number(p_prior_basic_pay) = 0)
843: then
844: GHR_GHRWS52L.CPDF_Parameter_Check;
845: hr_utility.set_message(8301,'GHR_38406_ALL_PROCEDURE_FAIL');
846: hr_utility.raise_error;
847: end if;
848: end if;
866: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and
867: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay )
868: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
869: then
870: GHR_GHRWS52L.CPDF_Parameter_Check;
871: hr_utility.set_message(8301,'GHR_37714_ALL_PROCEDURE_FAIL');
872: hr_utility.raise_error;
873: end if;
874: end if;
893: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and
894: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay )
895: or p_prior_basic_pay is null or to_number(p_prior_basic_pay) = 0)
896: then
897: GHR_GHRWS52L.CPDF_Parameter_Check;
898: hr_utility.set_message(8301,'GHR_37715_ALL_PROCEDURE_FAIL');
899: hr_utility.raise_error;
900: end if;
901: end if;
929: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and
930: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay )
931: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
932: then
933: GHR_GHRWS52L.CPDF_Parameter_Check;
934: hr_utility.set_message(8301,'GHR_37716_ALL_PROCEDURE_FAIL');
935: hr_utility.raise_error;
936: end if;
937: end if;
954: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and
955: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay )
956: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
957: then
958: GHR_GHRWS52L.CPDF_Parameter_Check;
959: hr_utility.set_message(8301,'GHR_37717_ALL_PROCEDURE_FAIL');
960: hr_utility.raise_error;
961: end if;
962: end if;
992: if max_basic_pay IS NOT NULL and
993: (to_number(p_prior_basic_pay) <> max_basic_pay
994: or p_prior_basic_pay is null or to_number(p_prior_basic_pay) = 0)
995: then
996: GHR_GHRWS52L.CPDF_Parameter_Check;
997: hr_utility.set_message(8301,'GHR_37718_ALL_PROCEDURE_FAIL');
998: hr_utility.raise_error;
999: end if;
1000: end if;
1019: if max_basic_pay IS NOT NULL and
1020: (not(to_number(p_prior_basic_pay) <= max_basic_pay)
1021: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
1022: then
1023: GHR_GHRWS52L.CPDF_Parameter_Check;
1024: hr_utility.set_message(8301,'GHR_37720_ALL_PROCEDURE_FAIL');
1025: hr_utility.raise_error;
1026: end if;
1027: end if;
1062: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and
1063: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay)
1064: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
1065: then
1066: GHR_GHRWS52L.CPDF_Parameter_Check;
1067: hr_utility.set_message(8301,'GHR_37074_ALL_PROCEDURE_FAIL');
1068: hr_utility.raise_error;
1069: end if;
1070: end if;
1105: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and
1106: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay)
1107: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
1108: then
1109: GHR_GHRWS52L.CPDF_Parameter_Check;
1110: hr_utility.set_message(8301,'GHR_37075_ALL_PROCEDURE_FAIL');
1111: hr_utility.raise_error;
1112: end if;
1113: end if;
1148: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and
1149: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay)
1150: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
1151: then
1152: GHR_GHRWS52L.CPDF_Parameter_Check;
1153: hr_utility.set_message(8301,'GHR_37076_ALL_PROCEDURE_FAIL');
1154: hr_utility.raise_error;
1155: end if;
1156: end if;
1192: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and
1193: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay)
1194: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
1195: then
1196: GHR_GHRWS52L.CPDF_Parameter_Check;
1197: hr_utility.set_message(8301,'GHR_37077_ALL_PROCEDURE_FAIL');
1198: hr_utility.raise_error;
1199: end if;
1200: end if;
1221: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and
1222: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay)
1223: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
1224: then
1225: GHR_GHRWS52L.CPDF_Parameter_Check;
1226: hr_utility.set_message(8301,'GHR_37721_ALL_PROCEDURE_FAIL');
1227: hr_utility.raise_error;
1228: end if;
1229: end if;
1256: if max_basic_pay IS NOT NULL and
1257: (to_number(p_prior_basic_pay) <> max_basic_pay
1258: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
1259: then
1260: GHR_GHRWS52L.CPDF_Parameter_Check;
1261: hr_utility.set_message(8301,'GHR_37722_ALL_PROCEDURE_FAIL');
1262: hr_utility.raise_error;
1263: end if;
1264: end if;
1282: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and
1283: (to_number(p_prior_basic_pay) <> max_basic_pay
1284: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
1285: then
1286: GHR_GHRWS52L.CPDF_Parameter_Check;
1287: hr_utility.set_message(8301,'GHR_37723_ALL_PROCEDURE_FAIL');
1288: hr_utility.raise_error;
1289: end if;
1290: end if;
1315: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and
1316: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay)
1317: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
1318: then
1319: GHR_GHRWS52L.CPDF_Parameter_Check;
1320: hr_utility.set_message(8301,'GHR_37724_ALL_PROCEDURE_FAIL');
1321: hr_utility.set_message_token('PRD','not C or D');
1322: hr_utility.raise_error;
1323: end if;
1337: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and
1338: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay)
1339: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
1340: then
1341: GHR_GHRWS52L.CPDF_Parameter_Check;
1342: hr_utility.set_message(8301,'GHR_37724_ALL_PROCEDURE_FAIL');
1343: hr_utility.set_message_token('PRD','not C');
1344: hr_utility.raise_error;
1345: end if;
1382: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL then
1383: if not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay)
1384: or p_prior_basic_pay is null
1385: then
1386: GHR_GHRWS52L.CPDF_Parameter_Check;
1387: hr_utility.set_message(8301,'GHR_38407_ALL_PROCEDURE_FAIL');
1388: hr_utility.raise_error;
1389: end if;
1390: end if;
1427: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL then
1428: if (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay)
1429: or p_prior_basic_pay is null)
1430: then
1431: GHR_GHRWS52L.CPDF_Parameter_Check;
1432: hr_utility.set_message(8301,'GHR_38408_ALL_PROCEDURE_FAIL');
1433: hr_utility.raise_error;
1434: end if;
1435: end if;
1463: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL then
1464: if (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay)
1465: or p_prior_basic_pay is null)
1466: then
1467: GHR_GHRWS52L.CPDF_Parameter_Check;
1468: hr_utility.set_message(8301,'GHR_38409_ALL_PROCEDURE_FAIL');
1469: hr_utility.raise_error;
1470: end if;
1471: end if;
1494: if max_basic_pay IS NOT NULL and
1495: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay)
1496: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
1497: then
1498: GHR_GHRWS52L.CPDF_Parameter_Check;
1499: hr_utility.set_message(8301,'GHR_37725_ALL_PROCEDURE_FAIL');
1500: hr_utility.raise_error;
1501: end if;
1502: end if;
1526: if max_basic_pay IS NOT NULL and min_basic_pay is not null and
1527: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay)
1528: or p_prior_basic_pay is null and to_number(p_prior_basic_pay) = 0)
1529: then
1530: GHR_GHRWS52L.CPDF_Parameter_Check;
1531: hr_utility.set_message(8301,'GHR_37727_ALL_PROCEDURE_FAIL');
1532: hr_utility.raise_error;
1533: end if;
1534: end if;
1552: if max_basic_pay IS NOT NULL and
1553: (not(to_number(p_prior_basic_pay) <> max_basic_pay)
1554: or p_prior_basic_pay is null)
1555: then
1556: GHR_GHRWS52L.CPDF_Parameter_Check;
1557: hr_utility.set_message(8301,'GHR_38410_ALL_PROCEDURE_FAIL');
1558: hr_utility.raise_error;
1559: end if;
1560: end if;
1581: if min_basic_pay IS NOT NULL and
1582: (not(to_number(p_prior_basic_pay) >= min_basic_pay)
1583: or p_prior_basic_pay is null or to_number(p_prior_basic_pay) = 0)
1584: then
1585: GHR_GHRWS52L.CPDF_Parameter_Check;
1586: hr_utility.set_message(8301,'GHR_37728_ALL_PROCEDURE_FAIL');
1587: hr_utility.raise_error;
1588: end if;
1589: end if;
1613: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay)
1614: or p_prior_basic_pay is null
1615: or to_number(p_prior_basic_pay) = 0)
1616: then
1617: GHR_GHRWS52L.CPDF_Parameter_Check;
1618: hr_utility.set_message(8301,'GHR_37729_ALL_PROCEDURE_FAIL');
1619: hr_utility.raise_error;
1620: end if;
1621: end if;
1699: '38','41','42','43','45','47','55','56','57','58','59','62','71','74','77','80','88','98')) then
1700: if ((trunc(p_effective_date) not between l_lpa_effective_start_date and
1701: nvl(l_lpa_effective_end_date, p_effective_date)) and
1702: (p_to_locality_adj is not null and to_number(p_to_locality_adj) <> 0)) then
1703: GHR_GHRWS52L.CPDF_Parameter_Check;
1704: hr_utility.set_message(8301,'GHR_37730_ALL_PROCEDURE_FAIL');
1705: hr_utility.raise_error;
1706: end if;
1707: end if;
1731: if (
1732: l_lpa_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2) and
1733: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
1734: ) then
1735: GHR_GHRWS52L.CPDF_Parameter_Check;
1736: hr_utility.set_message(8301,'GHR_37731_ALL_PROCEDURE_FAIL');
1737: --hr_utility.set_message_token('LOC_PAY','02 through 88');
1738: hr_utility.raise_error;
1739: end if;
1749: if (
1750: l_lpa_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2) and
1751: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
1752: ) then
1753: GHR_GHRWS52L.CPDF_Parameter_Check;
1754: hr_utility.set_message(8301,'GHR_38928_ALL_PROCEDURE_FAIL ');
1755: hr_utility.set_message_token('PRD_LIST','0, 3, 7, J, or K');
1756: hr_utility.raise_error;
1757: end if;
1772: if (
1773: l_lpa_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2) and
1774: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
1775: ) then
1776: GHR_GHRWS52L.CPDF_Parameter_Check;
1777: hr_utility.set_message(8301,'GHR_38928_ALL_PROCEDURE_FAIL');
1778: hr_utility.set_message_token('PRD_LIST','0, or 7');
1779: hr_utility.raise_error;
1780: end if;
1794: if (
1795: l_lpa_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2) and
1796: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
1797: ) then
1798: GHR_GHRWS52L.CPDF_Parameter_Check;
1799: hr_utility.set_message(8301,'GHR_37694_ALL_PROCEDURE_FAIL');
1800: hr_utility.raise_error;
1801: end if;
1802: end if;
1813: (l_lpa_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2) and
1814: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2) ) OR
1815: (round(to_number(p_to_locality_adj)+to_number(p_to_basic_pay)) > l_table5_value)
1816: ) then
1817: GHR_GHRWS52L.CPDF_Parameter_Check;
1818: hr_utility.set_message(8301,'GHR_37456_ALL_PROCEDURE_FAIL');
1819: hr_utility.raise_error;
1820: end if;
1821: end if;
1846: ) then
1847: if (l_lpa_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2) and
1848: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
1849: ) then
1850: GHR_GHRWS52L.CPDF_Parameter_Check;
1851: hr_utility.set_message(8301,'GHR_37747_ALL_PROCEDURE_FAIL');
1852: hr_utility.raise_error;
1853: end if;
1854: end if;
1862: ) then
1863: if (l_lpa_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2) and
1864: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
1865: ) then
1866: GHR_GHRWS52L.CPDF_Parameter_Check;
1867: hr_utility.set_message(8301,'GHR_38929_ALL_PROCEDURE_FAIL');
1868: hr_utility.set_message_token('PRD_LIST','0, 3, 7, J, or K');
1869: hr_utility.raise_error;
1870: end if;
1884: ) then
1885: if (l_lpa_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2) and
1886: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
1887: ) then
1888: GHR_GHRWS52L.CPDF_Parameter_Check;
1889: hr_utility.set_message(8301,'GHR_38929_ALL_PROCEDURE_FAIL');
1890: hr_utility.set_message_token('PRD_LIST','0, or 7');
1891: hr_utility.raise_error;
1892: end if;
1903: ) then
1904: if (l_lpa_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2) and
1905: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
1906: ) then
1907: GHR_GHRWS52L.CPDF_Parameter_Check;
1908: hr_utility.set_message(8301,'GHR_37695_ALL_PROCEDURE_FAIL');
1909: hr_utility.raise_error;
1910: end if;
1911: end if;
1919: if ((l_lpa_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2) and
1920: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2) ) OR
1921: (round(to_number(p_to_locality_adj)+to_number(p_to_basic_pay)) > l_table5_value)
1922: ) then
1923: GHR_GHRWS52L.CPDF_Parameter_Check;
1924: hr_utility.set_message(8301,'GHR_37457_ALL_PROCEDURE_FAIL');
1925: hr_utility.set_message_token('LOC_AREA','ZZ');
1926: hr_utility.raise_error;
1927: end if;
1936: if ((l_lpa_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2) and
1937: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2) ) OR
1938: (round(to_number(p_to_locality_adj)+to_number(p_to_basic_pay)) > l_table5_value)
1939: ) then
1940: GHR_GHRWS52L.CPDF_Parameter_Check;
1941: hr_utility.set_message(8301,'GHR_37457_ALL_PROCEDURE_FAIL');
1942: hr_utility.set_message_token('LOC_AREA','AK, HI, ON, ZZ');
1943: hr_utility.raise_error;
1944: end if;
1979: if (
1980: l_lpa_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2) and
1981: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
1982: ) then
1983: GHR_GHRWS52L.CPDF_Parameter_Check;
1984: hr_utility.set_message(8301,'GHR_37732_ALL_PROCEDURE_FAIL');
1985: hr_utility.raise_error;
1986: end if;
1987: end if;
1998: if (
1999: l_lpa_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2) and
2000: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
2001: ) then
2002: GHR_GHRWS52L.CPDF_Parameter_Check;
2003: hr_utility.set_message(8301,'GHR_37868_ALL_PROCEDURE_FAIL');
2004: hr_utility.raise_error;
2005: end if;
2006: end if;
2017: if (
2018: l_lpa_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2) and
2019: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
2020: ) then
2021: GHR_GHRWS52L.CPDF_Parameter_Check;
2022: hr_utility.set_message(8301,'GHR_38930_ALL_PROCEDURE_FAIL');
2023: hr_utility.raise_error;
2024: end if;
2025: end if;
2029: p_pay_rate_determinant_code in ('6','5','E','F')
2030: ) then
2031:
2032: if to_number(p_to_locality_adj) <= 0 then
2033: GHR_GHRWS52L.CPDF_Parameter_Check;
2034: hr_utility.set_message(8301,'GHR_38981_ALL_PROCEDURE_FAIL');
2035: hr_utility.raise_error;
2036: end if;
2037: end if;*/
2044: l_pay_table <> '0491'
2045: ) then
2046:
2047: if to_number(p_to_locality_adj) <= 0 then
2048: GHR_GHRWS52L.CPDF_Parameter_Check;
2049: hr_utility.set_message(8301,'GHR_38981_ALL_PROCEDURE_FAIL');
2050: hr_utility.raise_error;
2051: end if;
2052: end if;
2086: if (
2087: l_lpa_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2) and
2088: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
2089: ) then
2090: GHR_GHRWS52L.CPDF_Parameter_Check;
2091: hr_utility.set_message(8301,'GHR_37748_ALL_PROCEDURE_FAIL');
2092: hr_utility.raise_error;
2093: end if;
2094: end if;
2104: if (
2105: l_lpa_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2) and
2106: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
2107: ) then
2108: GHR_GHRWS52L.CPDF_Parameter_Check;
2109: hr_utility.set_message(8301,'GHR_38931_ALL_PROCEDURE_FAIL');
2110: hr_utility.raise_error;
2111: end if;
2112: end if;
2115: if (
2116: p_to_pay_plan in ('GS','GM','GG','GH') and
2117: p_pay_rate_determinant_code in ('6','5') ) then
2118: if (to_number(p_to_locality_adj) <= 0 ) then
2119: GHR_GHRWS52L.CPDF_Parameter_Check;
2120: hr_utility.set_message(8301,'GHR_38982_ALL_PROCEDURE_FAIL');
2121: hr_utility.raise_error;
2122: end if;
2123: end if;*/
2141: -------------------------------------------------------------------------------
2142: IF p_effective_date < fnd_date.canonical_to_date('1998/09/01') then
2143: if (p_locality_pay_area = '99' and
2144: (p_to_locality_adj is not null and to_number(p_to_locality_adj) <> 0)) then
2145: GHR_GHRWS52L.CPDF_Parameter_Check;
2146: hr_utility.set_message(8301,'GHR_37733_ALL_PROCEDURE_FAIL');
2147: hr_utility.raise_error;
2148: end if;
2149: ELSE -- meaning bet 01-SEP-1998 to 01-JAN-2005
2244: ) and
2245: p_pay_rate_determinant_code not in ('A','B','E','F','S','U','V') and
2246: (p_to_locality_adj is not null and to_number(p_to_locality_adj) <> 0)
2247: ) then
2248: GHR_GHRWS52L.CPDF_Parameter_Check;
2249: hr_utility.set_message(8301,'GHR_37734_ALL_PROCEDURE_FAIL');
2250: hr_utility.set_message_token('PRD_LIST','A, B, E, F, S, U, or V');
2251: hr_utility.set_message_token('PP_LIST','EX, ES, FE or ZZ');
2252: hr_utility.raise_error;
2259: ) and
2260: p_pay_rate_determinant_code not in ('A','B','E','F','S') and
2261: (p_to_locality_adj is not null and to_number(p_to_locality_adj) <> 0)
2262: ) then
2263: GHR_GHRWS52L.CPDF_Parameter_Check;
2264: hr_utility.set_message(8301,'GHR_37734_ALL_PROCEDURE_FAIL');
2265: hr_utility.set_message_token('PRD_LIST','A, B, E, F, or S');
2266: hr_utility.set_message_token('PP_LIST','EX, ES, FE or ZZ');
2267: hr_utility.raise_error;
2274: ) and
2275: p_pay_rate_determinant_code not in ('A','B','E','F','S') and
2276: (p_to_locality_adj is not null and to_number(p_to_locality_adj) <> 0)
2277: ) then
2278: GHR_GHRWS52L.CPDF_Parameter_Check;
2279: hr_utility.set_message(8301,'GHR_37734_ALL_PROCEDURE_FAIL');
2280: hr_utility.set_message_token('PRD_LIST','A, B, E, F, or S');
2281: hr_utility.set_message_token('PP_LIST','EX, ES, FE, SL, ST or ZZ');
2282: hr_utility.raise_error;
2289: p_pay_rate_determinant_code not in ('A','B','E','F','S') and
2290: p_locality_pay_area NOT IN ('AK','HI','ON') AND
2291: (p_to_locality_adj is not null and to_number(p_to_locality_adj) <> 0)
2292: ) then
2293: GHR_GHRWS52L.CPDF_Parameter_Check;
2294: hr_utility.set_message(8301,'GHR_37760_ALL_PROCEDURE_FAIL');
2295: hr_utility.set_message_token('PRD_LIST','A, B, E, F, or S');
2296: hr_utility.set_message_token('PP_LIST','EX, ES, FE, SL, ST or ZZ');
2297: hr_utility.raise_error;
2304: if (
2305: p_pay_rate_determinant_code = 'C' and
2306: (p_to_locality_adj is not null and to_number(p_to_locality_adj) <> 0)
2307: ) then
2308: GHR_GHRWS52L.CPDF_Parameter_Check;
2309: hr_utility.set_message(8301,'GHR_37735_ALL_PROCEDURE_FAIL');
2310: hr_utility.raise_error;
2311: end if;
2312: END IF;
2335: p_locality_pay_area between '02' and '88' and
2336: (p_to_locality_adj is null) ) and
2337: ( p_first_noac_lookup_code <> '817' )
2338: then
2339: GHR_GHRWS52L.CPDF_Parameter_Check;
2340: hr_utility.set_message(8301,'GHR_37736_ALL_PROCEDURE_FAIL');
2341: hr_utility.raise_error;
2342: end if;
2343:
2347: p_locality_pay_area NOT IN ('ZY','ZZ') and
2348: (p_to_locality_adj is null)) and
2349: ( p_first_noac_lookup_code <> '817' )
2350: then
2351: GHR_GHRWS52L.CPDF_Parameter_Check;
2352: hr_utility.set_message(8301,'GHR_38933_ALL_PROCEDURE_FAIL');
2353: hr_utility.set_message_token('PRD_LIST','A, B, U, or V');
2354: hr_utility.raise_error;
2355: end if;
2360: p_pay_rate_determinant_code in ('A','B') and
2361: p_locality_pay_area NOT IN ('ZY','ZZ') and
2362: (p_to_locality_adj is null))
2363: and ( p_first_noac_lookup_code <> '817' ) then
2364: GHR_GHRWS52L.CPDF_Parameter_Check;
2365: hr_utility.set_message(8301,'GHR_38933_ALL_PROCEDURE_FAIL');
2366: hr_utility.set_message_token('PRD_LIST','A or B');
2367: hr_utility.raise_error;
2368: end if;
2374: p_locality_pay_area NOT IN ('ZZ') and
2375: (p_to_locality_adj is null)) and
2376: ( p_first_noac_lookup_code <> '817' )
2377: then
2378: GHR_GHRWS52L.CPDF_Parameter_Check;
2379: if ( p_effective_date < to_date('01/09/2006', 'dd/mm/yyyy') ) THEN
2380: hr_utility.set_message(8301,'GHR_37696_ALL_PROCEDURE_FAIL');
2381: hr_utility.raise_error;
2382: else
2391: p_locality_pay_area NOT IN ('AK','HI','ON','ZZ') and
2392: (p_to_locality_adj is null)) and
2393: ( p_first_noac_lookup_code <> '817' )
2394: then
2395: GHR_GHRWS52L.CPDF_Parameter_Check;
2396: hr_utility.set_message(8301,'GHR_37434_ALL_PROCEDURE_FAIL');
2397: hr_utility.set_message_token('LOC_AREA','AK, HI, ON, ZZ');
2398: hr_utility.raise_error;
2399: end if;
2427: if (
2428: l_lpa_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2) and
2429: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
2430: ) then
2431: GHR_GHRWS52L.CPDF_Parameter_Check;
2432: hr_utility.set_message(8301,'GHR_37737_ALL_PROCEDURE_FAIL');
2433: hr_utility.raise_error;
2434: end if;
2435: end if;
2460: if (
2461: l_lpa_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2) and
2462: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
2463: ) then
2464: GHR_GHRWS52L.CPDF_Parameter_Check;
2465: hr_utility.set_message(8301,'GHR_37749_ALL_PROCEDURE_FAIL');
2466: hr_utility.raise_error;
2467: end if;
2468: end if;
2485: if (
2486: l_lpa_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2) and
2487: l_leo_pct < round((to_number(p_to_locality_adj)/to_number(p_to_basic_pay)*100),2)
2488: ) then
2489: GHR_GHRWS52L.CPDF_Parameter_Check;
2490: hr_utility.set_message(8301,'GHR_37738_ALL_PROCEDURE_FAIL');
2491: hr_utility.raise_error;
2492: end if;
2493: end if;
2513: if (
2514: round(((nvl(to_number(p_to_locality_adj),0)/to_number(p_to_basic_pay))*100),2)
2515: not between l_lpa_pct and l_leo_pct
2516: ) then
2517: GHR_GHRWS52L.CPDF_Parameter_Check;
2518: hr_utility.set_message(8301,'GHR_37759_ALL_PROCEDURE_FAIL');
2519: hr_utility.raise_error;
2520: end if;
2521: end if;
2528: if (
2529: round(((nvl(to_number(p_to_locality_adj),0)/to_number(p_to_basic_pay))*100),2)
2530: not between l_lpa_pct and l_leo_pct
2531: ) then
2532: GHR_GHRWS52L.CPDF_Parameter_Check;
2533: hr_utility.set_message(8301,'GHR_38934_ALL_PROCEDURE_FAIL');
2534: hr_utility.set_message_token('PRD_LIST','0, 3, 7, J, or K');
2535: hr_utility.raise_error;
2536: end if;
2548: if (
2549: round(((nvl(to_number(p_to_locality_adj),0)/to_number(p_to_basic_pay))*100),2)
2550: not between l_lpa_pct and l_leo_pct
2551: ) then
2552: GHR_GHRWS52L.CPDF_Parameter_Check;
2553: hr_utility.set_message(8301,'GHR_38934_ALL_PROCEDURE_FAIL');
2554: hr_utility.set_message_token('PRD_LIST','0, or 7');
2555: hr_utility.raise_error;
2556: end if;
2569: )
2570: and
2571: (p_to_locality_adj is null)
2572: ) then
2573: GHR_GHRWS52L.CPDF_Parameter_Check;
2574: hr_utility.set_message(8301,'GHR_37739_ALL_PROCEDURE_FAIL');
2575: hr_utility.raise_error;
2576: end if;
2577: */
2649: if (
2650: l_lpa_pct < round((nvl(to_number(p_prior_locality_adj),0)/to_number(p_prior_basic_pay))*100,2) and
2651: l_leo_pct < round((nvl(to_number(p_prior_locality_adj),0)/to_number(p_prior_basic_pay))*100,2)
2652: ) then
2653: GHR_GHRWS52L.CPDF_Parameter_Check;
2654: hr_utility.set_message(8301,'GHR_37741_ALL_PROCEDURE_FAIL');
2655: hr_utility.raise_error;
2656: end if;
2657: end if;
2692: if (
2693: l_lpa_pct < round((to_number(p_prior_locality_adj)/to_number(p_prior_basic_pay)*100),2) and
2694: l_leo_pct < round((to_number(p_prior_locality_adj)/to_number(p_prior_basic_pay)*100),2)
2695: ) then
2696: GHR_GHRWS52L.CPDF_Parameter_Check;
2697: hr_utility.set_message(8301,'GHR_37742_ALL_PROCEDURE_FAIL');
2698: hr_utility.raise_error;
2699: end if;
2700: end if;
2709: if (
2710: l_lpa_pct < round((to_number(p_prior_locality_adj)/to_number(p_prior_basic_pay)*100),2) and
2711: l_leo_pct < round((to_number(p_prior_locality_adj)/to_number(p_prior_basic_pay)*100),2)
2712: ) then
2713: GHR_GHRWS52L.CPDF_Parameter_Check;
2714: hr_utility.set_message(8301,'GHR_38935_ALL_PROCEDURE_FAIL'); -- NEW MESG TOKEN REQD
2715: hr_utility.set_message_token('PRD_LIST','0, 3, 7, J, or K');
2716: hr_utility.raise_error;
2717: end if;
2731: if (
2732: l_lpa_pct < round((to_number(p_prior_locality_adj)/to_number(p_prior_basic_pay)*100),2) and
2733: l_leo_pct < round((to_number(p_prior_locality_adj)/to_number(p_prior_basic_pay)*100),2)
2734: ) then
2735: GHR_GHRWS52L.CPDF_Parameter_Check;
2736: hr_utility.set_message(8301,'GHR_38935_ALL_PROCEDURE_FAIL');
2737: hr_utility.set_message_token('PRD_LIST','0, or 7');
2738: hr_utility.raise_error;
2739: end if;
2751: if (
2752: l_lpa_pct < round((to_number(p_prior_locality_adj)/to_number(p_prior_basic_pay)*100),2) and
2753: l_leo_pct < round((to_number(p_prior_locality_adj)/to_number(p_prior_basic_pay)*100),2)
2754: ) then
2755: GHR_GHRWS52L.CPDF_Parameter_Check;
2756: hr_utility.set_message(8301,'GHR_37697_ALL_PROCEDURE_FAIL');
2757: hr_utility.raise_error;
2758: end if;
2759: end if;
2770: -- (round(to_number(p_to_locality_adj)+to_number(p_to_basic_pay)) > l_table5_value)
2771: --Bug 8490941 need to consider the prior locality and basic for comparison with EX04 rate of Table5
2772: (round(to_number(p_prior_locality_adj)+to_number(p_prior_basic_pay)) > l_table5_value)
2773: ) then
2774: GHR_GHRWS52L.CPDF_Parameter_Check;
2775: hr_utility.set_message(8301,'GHR_37458_ALL_PROCEDURE_FAIL');
2776: hr_utility.set_message_token('LOC_AREA','ZZ');
2777: hr_utility.raise_error;
2778: end if;
2790: -- (round(to_number(p_to_locality_adj)+to_number(p_to_basic_pay)) > l_table5_value)
2791: --Bug 8490941 need to consider the prior locality and basic for comparison with EX04 rate of Table5
2792: (round(to_number(p_prior_locality_adj)+to_number(p_prior_basic_pay)) > l_table5_value)
2793: ) then
2794: GHR_GHRWS52L.CPDF_Parameter_Check;
2795: hr_utility.set_message(8301,'GHR_37458_ALL_PROCEDURE_FAIL');
2796: hr_utility.set_message_token('LOC_AREA','AK, HI, ON, ZZ');
2797: hr_utility.raise_error;
2798: end if;
2835: if (
2836: l_lpa_pct < round((to_number(p_prior_locality_adj)/to_number(p_prior_basic_pay)*100),2) and
2837: l_leo_pct < round((to_number(p_prior_locality_adj)/to_number(p_prior_basic_pay)*100),2)
2838: ) then
2839: GHR_GHRWS52L.CPDF_Parameter_Check;
2840: hr_utility.set_message(8301,'GHR_37680_ALL_PROCEDURE_FAIL');
2841: hr_utility.raise_error;
2842: end if;
2843: end if;
2853: if (
2854: l_lpa_pct < round((to_number(p_prior_locality_adj)/to_number(p_prior_basic_pay)*100),2) and
2855: l_leo_pct < round((to_number(p_prior_locality_adj)/to_number(p_prior_basic_pay)*100),2)
2856: ) then
2857: GHR_GHRWS52L.CPDF_Parameter_Check;
2858: hr_utility.set_message(8301,'GHR_38936_ALL_PROCEDURE_FAIL');
2859: hr_utility.raise_error;
2860: end if;
2861: end if;
2863: if ( nvl(p_prior_pay_plan,hr_api.g_varchar2) in ('GS','GM','GG','GH') and
2864: nvl(p_prior_pay_rate_det_code,hr_api.g_varchar2) in ('5','6')
2865: ) then
2866: if to_number(p_prior_locality_adj) <= 0 then
2867: GHR_GHRWS52L.CPDF_Parameter_Check;
2868: hr_utility.set_message(8301,'GHR_38979_ALL_PROCEDURE_FAIL');
2869: hr_utility.raise_error;
2870: end if;
2871: end if;
2890: -------------------------------------------------------------------------------
2891: IF p_effective_date < fnd_date.canonical_to_date('1998/09/01') THEN
2892: if (p_prior_locality_pay_area = '99' and
2893: (p_prior_locality_adj is not null and to_number(p_prior_locality_adj) <> 0)) then
2894: GHR_GHRWS52L.CPDF_Parameter_Check;
2895: hr_utility.set_message(8301,'GHR_37743_ALL_PROCEDURE_FAIL');
2896: hr_utility.raise_error;
2897: end if;
2898: ELSE
2904: if p_prior_locality_pay_area = '99' and
2905: p_prior_locality_adj is not null and
2906: to_number(p_prior_locality_adj) <> 0
2907: then
2908: GHR_GHRWS52L.CPDF_Parameter_Check;
2909: hr_utility.set_message(8301,'GHR_37898_ALL_PROCEDURE_FAIL');
2910: hr_utility.raise_error;
2911: end if;
2912: -- FWFA Changes
2917: if p_prior_locality_pay_area = 'ZZ' and
2918: p_prior_locality_adj is not null and
2919: to_number(p_prior_locality_adj) <> 0
2920: then
2921: GHR_GHRWS52L.CPDF_Parameter_Check;
2922: hr_utility.set_message(8301,'GHR_38937_ALL_PROCEDURE_FAIL');
2923: hr_utility.raise_error;
2924: end if;
2925: ELSif p_effective_date < fnd_date.canonical_to_date('2006/04/01') then
2927: p_prior_pay_rate_det_code not in ('5','6','E','F') and
2928: p_prior_locality_adj is not null and
2929: to_number(p_prior_locality_adj) <> 0
2930: then
2931: GHR_GHRWS52L.CPDF_Parameter_Check;
2932: hr_utility.set_message(8301,'GHR_38980_ALL_PROCEDURE_FAIL');
2933: hr_utility.raise_error;
2934: end if;
2935: ELSE
2939: p_prior_pay_plan in ('GM','GS') and
2940: p_prior_locality_adj is not null and
2941: to_number(p_prior_locality_adj) <> 0
2942: then
2943: GHR_GHRWS52L.CPDF_Parameter_Check;
2944: hr_utility.set_message(8301,'GHR_37162_ALL_PROCEDURE_FAIL');
2945: hr_utility.raise_error;
2946: end if;
2947: END IF;
2993: p_prior_pay_plan in ('EH','EI','EX','ZZ')) and
2994: p_prior_pay_rate_det_code not in ('A','B','E','F','S','U','V') and
2995: (p_prior_locality_adj is not null and to_number(p_prior_locality_adj) <> 0)
2996: ) then
2997: GHR_GHRWS52L.CPDF_Parameter_Check;
2998: hr_utility.set_message(8301,'GHR_37744_ALL_PROCEDURE_FAIL');
2999: hr_utility.set_message_token('PRD_LIST','A, B, E, F, S, U, or V');
3000: hr_utility.raise_error;
3001: end if;
3007: p_prior_pay_plan in ('EH','EI','EX','ZZ')) and
3008: p_prior_pay_rate_det_code not in ('A','B','E','F','S') and
3009: (p_prior_locality_adj is not null and to_number(p_prior_locality_adj) <> 0)
3010: ) then
3011: GHR_GHRWS52L.CPDF_Parameter_Check;
3012: hr_utility.set_message(8301,'GHR_37744_ALL_PROCEDURE_FAIL');
3013: hr_utility.set_message_token('PRD_LIST','A, B, E, F, or S');
3014: hr_utility.raise_error;
3015: end if;
3024: p_prior_pay_rate_det_code = 'C' and
3025: (p_prior_locality_adj is not null and to_number(p_prior_locality_adj) <> 0)
3026:
3027: ) then
3028: GHR_GHRWS52L.CPDF_Parameter_Check;
3029: hr_utility.set_message(8301,'GHR_37745_ALL_PROCEDURE_FAIL');
3030: hr_utility.raise_error;
3031: end if;
3032:
3040: p_prior_pay_rate_det_code NOT IN ('A','B','E','F','S') and
3041: p_prior_locality_pay_area NOT IN ('AK','HI','ON') AND
3042: (p_prior_locality_adj is not null and to_number(p_prior_locality_adj) <> 0)) then
3043:
3044: GHR_GHRWS52L.CPDF_Parameter_Check;
3045: hr_utility.set_message(8301,'GHR_37757_ALL_PROCEDURE_FAIL');
3046: hr_utility.raise_error;
3047: end if;
3048: END IF;