[Home] [Help]
81: ) ;
82: if not (l_table_pay = to_number(p_to_basic_pay) or
83: p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
84: then
85: GHR_GHRWS52L.CPDF_Parameter_Check;
86: hr_utility.set_message(8301,'GHR_37801_ALL_PROCEDURE_FAIL');
87: hr_utility.raise_error;
88: end if;
89: end if;
108: ) ;
109: if (l_table_pay <> to_number(p_to_basic_pay) and
110: p_to_basic_pay is not null and
111: to_number(p_to_basic_pay) <> 0) then
112: GHR_GHRWS52L.CPDF_Parameter_Check;
113: hr_utility.set_message(8301,'GHR_37804_ALL_PROCEDURE_FAIL');
114: hr_utility.raise_error;
115: end if;
116: end if;
129: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 43',
130: p_to_pay_plan,'Maximum Basic Pay',p_effective_date);
131: if not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
132: then
133: GHR_GHRWS52L.CPDF_Parameter_Check;
134: hr_utility.set_message(8301,'GHR_37057_ALL_PROCEDURE_FAIL');
135: hr_utility.raise_error;
136: end if;
137: end if;
158: , p_step_or_rate => p_to_step_or_rate
159: ) ;
160: if not (nvl(l_table_pay,0) = to_number(p_to_basic_pay) or
161: (p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)) then
162: GHR_GHRWS52L.CPDF_Parameter_Check;
163: hr_utility.set_message(8301,'GHR_37811_ALL_PROCEDURE_FAIL');
164: hr_utility.raise_error;
165: end if;
166: end if;
179: , p_step_or_rate => p_retained_step
180: ) ;
181: if not (l_table_pay = to_number(p_to_basic_pay) or
182: (p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)) then
183: GHR_GHRWS52L.CPDF_Parameter_Check;
184: hr_utility.set_message(8301,'GHR_37811_ALL_PROCEDURE_FAIL');
185: hr_utility.raise_error;
186: end if;
187: end if;
201: p_to_grade_or_level ,
202: 'Maximum Basic Pay',
203: p_effective_date);
204: IF NVL(to_number(p_to_basic_pay), 0) <> max_basic_pay THEN
205: GHR_GHRWS52L.CPDF_Parameter_Check;
206: hr_utility.set_message(8301,'GHR_37816_ALL_PROCEDURE_FAIL');
207: hr_utility.raise_error;
208: END IF;
209: END IF;
223: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 52',
224: p_to_grade_or_level,'Maximum Basic Pay',p_effective_date);
225: if not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
226: then
227: GHR_GHRWS52L.CPDF_Parameter_Check;
228: hr_utility.set_message(8301,'GHR_37425_ALL_PROCEDURE_FAIL');
229: hr_utility.raise_error;
230: end if;
231: end if;
248: 'Maximum Basic Pay',
249: p_effective_date);
250: if not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
251: then
252: GHR_GHRWS52L.CPDF_Parameter_Check;
253: hr_utility.set_message(8301,'GHR_37425_ALL_PROCEDURE_FAIL');
254: hr_utility.raise_error;
255: end if;
256: end if;
274: , p_grade_or_level => '00'
275: , p_step_or_rate => p_to_step_or_rate
276: ) ;
277: IF nvl(to_number(p_to_basic_pay), 0) <> l_table_pay THEN
278: GHR_GHRWS52L.CPDF_Parameter_Check;
279: hr_utility.set_message(8301,'GHR_37817_ALL_PROCEDURE_FAIL');
280: hr_utility.raise_error;
281: end if;
282: ELSIF ( p_effective_date >= to_date('2004/01/11', 'yyyy/mm/dd') and
292: 'Maximum Basic Pay',
293: p_effective_date);
294: if not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
295: then
296: GHR_GHRWS52L.CPDF_Parameter_Check;
297: hr_utility.set_message(8301,'GHR_38884_ALL_PROCEDURE_FAIL');
298: -- NEED TO ADD A NEW MESSAGE HERE
299: hr_utility.raise_error;
300: end if;
320: , p_step_or_rate => p_to_step_or_rate
321: ) ;
322: if not (to_number(p_to_basic_pay) = l_table_pay or
323: (p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)) then
324: GHR_GHRWS52L.CPDF_Parameter_Check;
325: hr_utility.set_message(8301,'GHR_37818_ALL_PROCEDURE_FAIL');
326: hr_utility.raise_error;
327: end if;
328: end if;
347: , p_step_or_rate => p_to_step_or_rate
348: ) ;
349: if not (to_number(p_to_basic_pay) > l_table_pay or
350: (p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)) then
351: GHR_GHRWS52L.CPDF_Parameter_Check;
352: hr_utility.set_message(8301,'GHR_37819_ALL_PROCEDURE_FAIL');
353: hr_utility.set_message_token('COND','exceed');
354: hr_utility.set_message_token('PRD_LIST','5,6 or M');
355: hr_utility.raise_error;
372: , p_step_or_rate => p_to_step_or_rate
373: ) ;
374: if not (to_number(p_to_basic_pay) >= l_table_pay or
375: (p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)) then
376: GHR_GHRWS52L.CPDF_Parameter_Check;
377: hr_utility.set_message(8301,'GHR_37819_ALL_PROCEDURE_FAIL');
378: hr_utility.set_message_token('COND','equal or exceed');
379: hr_utility.set_message_token('PRD_LIST','5 or 6');
380: hr_utility.raise_error;
403: if (
404: (l_table_pay > to_number(p_to_basic_pay)) and
405: (p_to_basic_pay is not null or to_number(p_to_basic_pay) <> '0')
406: ) then
407: GHR_GHRWS52L.CPDF_Parameter_Check;
408: hr_utility.set_message(8301,'GHR_38983_ALL_PROCEDURE_FAIL');
409: hr_utility.raise_error;
410: end if;
411: end if;
430: 'Maximum Basic Pay',
431: p_effective_date);
432: if not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
433: then
434: GHR_GHRWS52L.CPDF_Parameter_Check;
435: hr_utility.set_message(8301,'GHR_37427_ALL_PROCEDURE_FAIL');
436: hr_utility.raise_error;
437: end if;
438: end if;
457: 'Maximum Basic Pay',
458: p_effective_date);
459: if not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
460: then
461: GHR_GHRWS52L.CPDF_Parameter_Check;
462: hr_utility.set_message(8301,'GHR_37428_ALL_PROCEDURE_FAIL');
463: hr_utility.raise_error;
464: end if;
465: end if;
480: , p_pay_plan => 'GS'
481: , p_grade_or_level => '11'
482: , p_step_or_rate => '10') ;
483: if l_table_pay < to_number(p_to_basic_pay) then
484: GHR_GHRWS52L.CPDF_Parameter_Check;
485: hr_utility.set_message(8301,'GHR_37852_ALL_PROCEDURE_FAIL');
486: hr_utility.raise_error;
487: end if;
488: end if;
516: if not (
517: (nvl(l_table_pay,0) < to_number(p_to_basic_pay)) or
518: (p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
519: ) then
520: GHR_GHRWS52L.CPDF_Parameter_Check;
521: hr_utility.set_message(8301,'GHR_37844_ALL_PROCEDURE_FAIL');
522: hr_utility.set_message_token('COND','exceed');
523: hr_utility.set_message_token('PRD_LIST','E, F or M');
524: hr_utility.raise_error;
541: if not (
542: (nvl(l_table_pay,0) <= to_number(p_to_basic_pay)) or
543: (p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
544: ) then
545: GHR_GHRWS52L.CPDF_Parameter_Check;
546: hr_utility.set_message(8301,'GHR_37844_ALL_PROCEDURE_FAIL');
547: hr_utility.set_message_token('COND','equal or exceed');
548: hr_utility.set_message_token('PRD_LIST','E or F');
549: hr_utility.raise_error;
571: ) ;
572: if not (
573: (l_table_pay = to_number(p_to_basic_pay)) or (p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
574: ) then
575: GHR_GHRWS52L.CPDF_Parameter_Check;
576: hr_utility.set_message(8301,'GHR_37837_ALL_PROCEDURE_FAIL');
577: hr_utility.raise_error;
578: end if;
579: end if;
598: if not (
599: (nvl(l_table_pay,0) < to_number(p_to_basic_pay)) or
600: (p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
601: ) then
602: GHR_GHRWS52L.CPDF_Parameter_Check;
603: hr_utility.set_message(8301,'GHR_37838_ALL_PROCEDURE_FAIL');
604: hr_utility.raise_error;
605: end if;
606: end if;
622: if not (
623: (nvl(l_table_pay,0) <= to_number(p_to_basic_pay)) or
624: (p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
625: ) then
626: GHR_GHRWS52L.CPDF_Parameter_Check;
627: hr_utility.set_message(8301,'GHR_37838_ALL_PROCEDURE_FAIL');
628: hr_utility.raise_error;
629: end if;
630: end if;
650: if not (
651: (l_table_pay < to_number(p_to_basic_pay)) or
652: (p_to_basic_pay is null or to_number(p_to_basic_pay) = '0')
653: ) then
654: GHR_GHRWS52L.CPDF_Parameter_Check;
655: hr_utility.set_message(8301,'GHR_37839_ALL_PROCEDURE_FAIL');
656: hr_utility.set_message_token('COND','exceed');
657: hr_utility.set_message_token('PRD_LIST','5,6 or M');
658: hr_utility.raise_error;
671: if not (
672: (l_table_pay <= to_number(p_to_basic_pay)) or
673: (p_to_basic_pay is null or to_number(p_to_basic_pay) = '0')
674: ) then
675: GHR_GHRWS52L.CPDF_Parameter_Check;
676: hr_utility.set_message(8301,'GHR_37839_ALL_PROCEDURE_FAIL');
677: hr_utility.set_message_token('COND','equal or exceed');
678: hr_utility.set_message_token('PRD_LIST','5 or 6');
679: hr_utility.raise_error;
701: if (
702: (l_table_pay > to_number(p_to_basic_pay)) or
703: (p_to_basic_pay is not null or to_number(p_to_basic_pay) <> '0')
704: ) then
705: GHR_GHRWS52L.CPDF_Parameter_Check;
706: hr_utility.set_message(8301,'GHR_38984_ALL_PROCEDURE_FAIL');
707: hr_utility.raise_error;
708: end if;
709: end if;
737: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and
738: (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
739: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
740: then
741: GHR_GHRWS52L.CPDF_Parameter_Check;
742: hr_utility.set_message(8301,'GHR_37886_ALL_PROCEDURE_FAIL');
743: hr_utility.raise_error;
744: end if;
745: end if;
763: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and
764: (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
765: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
766: then
767: GHR_GHRWS52L.CPDF_Parameter_Check;
768: hr_utility.set_message(8301,'GHR_37802_ALL_PROCEDURE_FAIL');
769: hr_utility.raise_error;
770: end if;
771: end if;
789: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and
790: (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
791: or p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
792: then
793: GHR_GHRWS52L.CPDF_Parameter_Check;
794: hr_utility.set_message(8301,'GHR_37803_ALL_PROCEDURE_FAIL');
795: hr_utility.raise_error;
796: end if;
797: end if;
824: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and
825: (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
826: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
827: then
828: GHR_GHRWS52L.CPDF_Parameter_Check;
829: hr_utility.set_message(8301,'GHR_37863_ALL_PROCEDURE_FAIL');
830: hr_utility.raise_error;
831: end if;
832: end if;
860: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and
861: (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
862: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
863: then
864: GHR_GHRWS52L.CPDF_Parameter_Check;
865: hr_utility.set_message(8301,'GHR_37864_ALL_PROCEDURE_FAIL');
866: hr_utility.raise_error;
867: end if;
868: end if;
890: if min_basic_pay IS NOT NULL and
891: (not(to_number(p_to_basic_pay) >= min_basic_pay)
892: or (p_to_basic_pay is null and p_first_noac_lookup_code <> '817' ))
893: then
894: GHR_GHRWS52L.CPDF_Parameter_Check;
895: hr_utility.set_message(8301,'GHR_37805_ALL_PROCEDURE_FAIL');
896: hr_utility.raise_error;
897: end if;
898: end if;
917: if min_basic_pay IS NOT NULL and
918: (not(to_number(p_to_basic_pay) >= min_basic_pay)
919: or p_to_basic_pay is null)
920: then
921: GHR_GHRWS52L.CPDF_Parameter_Check;
922: hr_utility.set_message(8301,'GHR_37806_ALL_PROCEDURE_FAIL');
923: hr_utility.raise_error;
924: end if;
925: end if;
946: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL
947: and (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay)
948: or p_to_basic_pay is null)
949: then
950: GHR_GHRWS52L.CPDF_Parameter_Check;
951: hr_utility.set_message(8301,'GHR_37807_ALL_PROCEDURE_FAIL');
952: hr_utility.raise_error;
953: end if;
954: end if;
974: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL
975: and (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay)
976: or p_to_basic_pay is null)
977: then
978: GHR_GHRWS52L.CPDF_Parameter_Check;
979: hr_utility.set_message(8301,'GHR_37429_ALL_PROCEDURE_FAIL');
980: hr_utility.raise_error;
981: end if;
982: end if;
1000: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and
1001: (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay)
1002: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
1003: then
1004: GHR_GHRWS52L.CPDF_Parameter_Check;
1005: hr_utility.set_message(8301,'GHR_37808_ALL_PROCEDURE_FAIL');
1006: hr_utility.raise_error;
1007: end if;
1008: end if;*/
1036: (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay)
1037: or p_to_basic_pay is null
1038: or to_number(p_to_basic_pay) = 0)
1039: then
1040: GHR_GHRWS52L.CPDF_Parameter_Check;
1041: hr_utility.set_message(8301,'GHR_37433_ALL_PROCEDURE_FAIL');
1042: hr_utility.raise_error;
1043: end if;
1044: end if;
1061: (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay)
1062: or p_to_basic_pay is null
1063: or to_number(p_to_basic_pay) = 0)
1064: then
1065: GHR_GHRWS52L.CPDF_Parameter_Check;
1066: hr_utility.set_message(8301,'GHR_37809_ALL_PROCEDURE_FAIL');
1067: hr_utility.raise_error;
1068: end if;
1069: end if;
1089: if min_basic_pay IS NOT NULL and
1090: (not(to_number(p_to_basic_pay) >= min_basic_pay)
1091: or p_to_basic_pay is null)
1092: then
1093: GHR_GHRWS52L.CPDF_Parameter_Check;
1094: hr_utility.set_message(8301,'GHR_37810_ALL_PROCEDURE_FAIL');
1095: hr_utility.raise_error;
1096: end if;
1097: end if;
1119: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL then
1120: if (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay)
1121: or p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
1122: then
1123: GHR_GHRWS52L.CPDF_Parameter_Check;
1124: hr_utility.set_message(8301,'GHR_37812_ALL_PROCEDURE_FAIL');
1125: hr_utility.raise_error;
1126: end if;
1127: end if;
1146: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL then
1147: if (not (to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
1148: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
1149: then
1150: GHR_GHRWS52L.CPDF_Parameter_Check;
1151: hr_utility.set_message(8301,'GHR_37813_ALL_PROCEDURE_FAIL');
1152: hr_utility.raise_error;
1153: end if;
1154: end if;
1178: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL then
1179: if (not (to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
1180: or p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
1181: then
1182: GHR_GHRWS52L.CPDF_Parameter_Check;
1183: hr_utility.set_message(8301,'GHR_37814_ALL_PROCEDURE_FAIL');
1184: hr_utility.raise_error;
1185: end if;
1186: end if;
1208: if p_rate_determinant_code in ('0','7')
1209: and (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
1210: or p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
1211: then
1212: GHR_GHRWS52L.CPDF_Parameter_Check;
1213: hr_utility.set_message(8301,'GHR_37435_ALL_PROCEDURE_FAIL');
1214: hr_utility.raise_error;
1215: end if;
1216: end if;
1229: if p_rate_determinant_code in ('0','7')
1230: and (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
1231: or p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
1232: then
1233: GHR_GHRWS52L.CPDF_Parameter_Check;
1234: hr_utility.set_message(8301,'GHR_37815_ALL_PROCEDURE_FAIL');
1235: hr_utility.raise_error;
1236: end if;
1237: end if;
1259: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and
1260: (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
1261: or p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
1262: then
1263: GHR_GHRWS52L.CPDF_Parameter_Check;
1264: hr_utility.set_message(8301,'GHR_37854_ALL_PROCEDURE_FAIL');
1265: hr_utility.raise_error;
1266: end if;
1267: end if;
1289: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and
1290: (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
1291: or p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
1292: then
1293: GHR_GHRWS52L.CPDF_Parameter_Check;
1294: hr_utility.set_message(8301,'GHR_37855_ALL_PROCEDURE_FAIL');
1295: hr_utility.raise_error;
1296: end if;
1297: end if;
1315: if max_basic_pay IS NOT NULL and
1316: (not(to_number(p_to_basic_pay) < max_basic_pay)
1317: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
1318: then
1319: GHR_GHRWS52L.CPDF_Parameter_Check;
1320: hr_utility.set_message(8301,'GHR_37820_ALL_PROCEDURE_FAIL');
1321: hr_utility.raise_error;
1322: end if;
1323: end if;
1340: if min_basic_pay IS NOT NULL
1341: and (not(to_number(p_to_basic_pay) >= min_basic_pay)
1342: or p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
1343: then
1344: GHR_GHRWS52L.CPDF_Parameter_Check;
1345: hr_utility.set_message(8301,'GHR_37821_ALL_PROCEDURE_FAIL');
1346: hr_utility.raise_error;
1347: end if;
1348: end if;
1367: if max_basic_pay IS NOT NULL
1368: and (to_number(p_to_basic_pay) <> max_basic_pay
1369: or p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
1370: then
1371: GHR_GHRWS52L.CPDF_Parameter_Check;
1372: hr_utility.set_message(8301,'GHR_37928_ALL_PROCEDURE_FAIL');
1373: hr_utility.raise_error;
1374: end if;
1375: end if;
1403: if max_basic_pay IS NOT NULL
1404: and (to_number(p_to_basic_pay) <> max_basic_pay
1405: or p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
1406: then
1407: GHR_GHRWS52L.CPDF_Parameter_Check;
1408: hr_utility.set_message(8301,'GHR_37822_ALL_PROCEDURE_FAIL');
1409: hr_utility.raise_error;
1410: end if;
1411: end if;
1431: and (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay)
1432: or p_to_basic_pay is null
1433: or to_number(p_to_basic_pay) = 0)
1434: then
1435: GHR_GHRWS52L.CPDF_Parameter_Check;
1436: hr_utility.set_message(8301,'GHR_37823_ALL_PROCEDURE_FAIL');
1437: hr_utility.raise_error;
1438: end if;
1439: end if;
1460: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL
1461: and (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay)
1462: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
1463: then
1464: GHR_GHRWS52L.CPDF_Parameter_Check;
1465: hr_utility.set_message(8301,'GHR_37824_ALL_PROCEDURE_FAIL');
1466: hr_utility.raise_error;
1467: end if;
1468: end if;*/
1490: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and
1491: (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
1492: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
1493: then
1494: GHR_GHRWS52L.CPDF_Parameter_Check;
1495: hr_utility.set_message(8301,'GHR_37825_ALL_PROCEDURE_FAIL');
1496: hr_utility.raise_error;
1497: end if;
1498: end if;
1521: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and
1522: (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
1523: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
1524: then
1525: GHR_GHRWS52L.CPDF_Parameter_Check;
1526: hr_utility.set_message(8301,'GHR_37826_ALL_PROCEDURE_FAIL');
1527: hr_utility.raise_error;
1528: end if;
1529: end if;
1549: if max_basic_pay IS NOT NULL and min_basic_pay is not null and
1550: (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay)
1551: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
1552: then
1553: GHR_GHRWS52L.CPDF_Parameter_Check;
1554: hr_utility.set_message(8301,'GHR_37827_ALL_PROCEDURE_FAIL');
1555: hr_utility.raise_error;
1556: end if;
1557: end if;
1580: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL
1581: and not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay)
1582: or p_to_basic_pay is null
1583: then
1584: GHR_GHRWS52L.CPDF_Parameter_Check;
1585: hr_utility.set_message(8301,'GHR_37856_ALL_PROCEDURE_FAIL');
1586: hr_utility.raise_error;
1587: end if;
1588: end if;
1612: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL
1613: and (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay)
1614: or p_to_basic_pay is null)
1615: then
1616: GHR_GHRWS52L.CPDF_Parameter_Check;
1617: hr_utility.set_message(8301,'GHR_37858_ALL_PROCEDURE_FAIL');
1618: hr_utility.raise_error;
1619: end if;
1620: end if;
1644: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL
1645: and (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay)
1646: or p_to_basic_pay is null)
1647: then
1648: GHR_GHRWS52L.CPDF_Parameter_Check;
1649: hr_utility.set_message(8301,'GHR_37860_ALL_PROCEDURE_FAIL');
1650: hr_utility.raise_error;
1651: end if;
1652: end if;
1672: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and
1673: (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
1674: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
1675: then
1676: GHR_GHRWS52L.CPDF_Parameter_Check;
1677: hr_utility.set_message(8301,'GHR_37828_ALL_PROCEDURE_FAIL');
1678: hr_utility.raise_error;
1679: end if;
1680: end if;
1724: if max_basic_pay is not null and
1725: (not(to_number(p_to_basic_pay) between nvl(min_basic_pay,0) and nvl(max_basic_pay,0))
1726: or p_to_basic_pay is null)
1727: then
1728: GHR_GHRWS52L.CPDF_Parameter_Check;
1729: hr_utility.set_message(8301,'GHR_37829_ALL_PROCEDURE_FAIL');
1730: hr_utility.raise_error;
1731: end if;
1732: end if; */
1761: if max_basic_pay IS NOT NULL then
1762: if (not(to_number(p_to_basic_pay) between nvl(min_basic_pay,0) and nvl(max_basic_pay,0))
1763: or p_to_basic_pay is null)
1764: then
1765: GHR_GHRWS52L.CPDF_Parameter_Check;
1766: hr_utility.set_message(8301,'GHR_37830_ALL_PROCEDURE_FAIL');
1767: hr_utility.raise_error;
1768: end if;
1769: end if;
1794: if max_basic_pay IS NOT NULL then
1795: if (not(to_number(p_to_basic_pay) between nvl(min_basic_pay,0) and nvl(max_basic_pay,0))
1796: or p_to_basic_pay is null)
1797: then
1798: GHR_GHRWS52L.CPDF_Parameter_Check;
1799: hr_utility.set_message(8301,'GHR_37861_ALL_PROCEDURE_FAIL');
1800: hr_utility.raise_error;
1801: end if;
1802: end if;
1824: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL
1825: and (not(to_number(p_to_basic_pay) between nvl(min_basic_pay,0) and nvl(max_basic_pay,0))
1826: or p_to_basic_pay is null)
1827: then
1828: GHR_GHRWS52L.CPDF_Parameter_Check;
1829: hr_utility.set_message(8301,'GHR_37831_ALL_PROCEDURE_FAIL');
1830: hr_utility.raise_error;
1831: end if;
1832: end if;
1853: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and
1854: (not(to_number(p_to_basic_pay) between nvl(min_basic_pay,0) and nvl(max_basic_pay,0))
1855: or p_to_basic_pay is null)
1856: then
1857: GHR_GHRWS52L.CPDF_Parameter_Check;
1858: hr_utility.set_message(8301,'GHR_37832_ALL_PROCEDURE_FAIL');
1859: hr_utility.raise_error;
1860: end if;
1861: end if; */
1878: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL
1879: and (not(to_number(p_to_basic_pay) between nvl(min_basic_pay,0) and nvl(max_basic_pay,0))
1880: or p_to_basic_pay is null)
1881: then
1882: GHR_GHRWS52L.CPDF_Parameter_Check;
1883: hr_utility.set_message(8301,'GHR_37833_ALL_PROCEDURE_FAIL');
1884: hr_utility.raise_error;
1885: end if;
1886: end if;
1909: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL
1910: and (not(to_number(p_to_basic_pay) between nvl(min_basic_pay,0) and nvl(max_basic_pay,0))
1911: or p_to_basic_pay is null)
1912: then
1913: GHR_GHRWS52L.CPDF_Parameter_Check;
1914: hr_utility.set_message(8301,'GHR_37834_ALL_PROCEDURE_FAIL');
1915: hr_utility.raise_error;
1916: end if;
1917: end if;
1944: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL
1945: and (not(to_number(p_to_basic_pay) between nvl(min_basic_pay,0) and nvl(max_basic_pay,0))
1946: or p_to_basic_pay is null)
1947: then
1948: GHR_GHRWS52L.CPDF_Parameter_Check;
1949: hr_utility.set_message(8301,'GHR_37081_ALL_PROCEDURE_FAIL');
1950: hr_utility.raise_error;
1951: end if;
1952: end if;
1980: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL
1981: and (not(to_number(p_to_basic_pay) between nvl(min_basic_pay,0) and nvl(max_basic_pay,0))
1982: or p_to_basic_pay is null)
1983: then
1984: GHR_GHRWS52L.CPDF_Parameter_Check;
1985: hr_utility.set_message(8301,'GHR_37078_ALL_PROCEDURE_FAIL');
1986: hr_utility.raise_error;
1987: end if;
1988: end if;
2017: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL
2018: and (not(to_number(p_to_basic_pay) between nvl(min_basic_pay,0) and nvl(max_basic_pay,0))
2019: or p_to_basic_pay is null)
2020: then
2021: GHR_GHRWS52L.CPDF_Parameter_Check;
2022: hr_utility.set_message(8301,'GHR_37079_ALL_PROCEDURE_FAIL');
2023: hr_utility.raise_error;
2024: end if;
2025: end if;
2053: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL
2054: and (not(to_number(p_to_basic_pay) between nvl(min_basic_pay,0) and nvl(max_basic_pay,0))
2055: or p_to_basic_pay is null)
2056: then
2057: GHR_GHRWS52L.CPDF_Parameter_Check;
2058: hr_utility.set_message(8301,'GHR_37080_ALL_PROCEDURE_FAIL');
2059: hr_utility.raise_error;
2060: end if;
2061: end if;
2084: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL then
2085: if (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay)
2086: or p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
2087: then
2088: GHR_GHRWS52L.CPDF_Parameter_Check;
2089: hr_utility.set_message(8301,'GHR_37835_ALL_PROCEDURE_FAIL');
2090: hr_utility.raise_error;
2091: end if;
2092: end if;
2120: if max_basic_pay IS NOT NULL and
2121: (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay)
2122: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
2123: then
2124: GHR_GHRWS52L.CPDF_Parameter_Check;
2125: hr_utility.set_message(8301,'GHR_37836_ALL_PROCEDURE_FAIL');
2126: hr_utility.set_message_token('TABLE_NUMBER','24');
2127: hr_utility.raise_error;
2128: end if;
2143: if max_basic_pay IS NOT NULL and
2144: (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay)
2145: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
2146: then
2147: GHR_GHRWS52L.CPDF_Parameter_Check;
2148: hr_utility.set_message(8301,'GHR_37836_ALL_PROCEDURE_FAIL');
2149: hr_utility.set_message_token('TABLE_NUMBER','54');
2150: hr_utility.raise_error;
2151: end if;
2177: if max_basic_pay IS NOT NULL and
2178: (not(to_number(p_to_basic_pay) < max_basic_pay)
2179: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
2180: then
2181: GHR_GHRWS52L.CPDF_Parameter_Check;
2182: hr_utility.set_message(8301,'GHR_37840_ALL_PROCEDURE_FAIL');
2183: hr_utility.raise_error;
2184: end if;
2185: end if;
2212: (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay)
2213: or p_to_basic_pay is null
2214: or to_number(p_to_basic_pay) = 0)
2215: then
2216: GHR_GHRWS52L.CPDF_Parameter_Check;
2217: hr_utility.set_message(8301,'GHR_37841_ALL_PROCEDURE_FAIL');
2218: hr_utility.raise_error;
2219: end if;
2220: end if;
2241: if max_basic_pay IS NOT NULL
2242: and (not(to_number(p_to_basic_pay) <= max_basic_pay)
2243: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
2244: then
2245: GHR_GHRWS52L.CPDF_Parameter_Check;
2246: hr_utility.set_message(8301,'GHR_37842_ALL_PROCEDURE_FAIL');
2247: hr_utility.raise_error;
2248: end if;
2249: end if;
2274: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL
2275: and (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay)
2276: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
2277: then
2278: GHR_GHRWS52L.CPDF_Parameter_Check;
2279: hr_utility.set_message(8301,'GHR_37843_ALL_PROCEDURE_FAIL');
2280: hr_utility.raise_error;
2281: end if;
2282: end if;
2306: and p_retained_grade >= p_to_grade_or_level
2307: and (not(to_number(p_to_basic_pay) < max_basic_pay)
2308: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
2309: then
2310: GHR_GHRWS52L.CPDF_Parameter_Check;
2311: hr_utility.set_message(8301,'GHR_37845_ALL_PROCEDURE_FAIL');
2312: hr_utility.raise_error;
2313: end if;
2314: end if;
2338: and p_retained_grade >= p_to_grade_or_level
2339: and (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay)
2340: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
2341: then
2342: GHR_GHRWS52L.CPDF_Parameter_Check;
2343: hr_utility.set_message(8301,'GHR_37846_ALL_PROCEDURE_FAIL');
2344: hr_utility.raise_error;
2345: end if;
2346: end if;
2371: if max_basic_pay IS NOT NULL
2372: and (to_number(p_to_basic_pay) <> max_basic_pay
2373: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
2374: then
2375: GHR_GHRWS52L.CPDF_Parameter_Check;
2376: hr_utility.set_message(8301,'GHR_37847_ALL_PROCEDURE_FAIL');
2377: hr_utility.raise_error;
2378: end if;
2379: end if;
2396: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL
2397: and (to_number(p_to_basic_pay) <> max_basic_pay
2398: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
2399: then
2400: GHR_GHRWS52L.CPDF_Parameter_Check;
2401: hr_utility.set_message(8301,'GHR_37848_ALL_PROCEDURE_FAIL');
2402: hr_utility.raise_error;
2403: end if;
2404: end if;
2426: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL
2427: and (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay)
2428: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
2429: then
2430: GHR_GHRWS52L.CPDF_Parameter_Check;
2431: hr_utility.set_message(8301,'GHR_37849_ALL_PROCEDURE_FAIL');
2432: hr_utility.raise_error;
2433: end if;
2434: end if;
2450: if max_basic_pay IS NOT NULL and
2451: (not(to_number(p_to_basic_pay) <> max_basic_pay)
2452: or p_to_basic_pay is null)
2453: then
2454: GHR_GHRWS52L.CPDF_Parameter_Check;
2455: hr_utility.set_message(8301,'GHR_38551_ALL_PROCEDURE_FAIL');
2456: hr_utility.raise_error;
2457: end if;
2458: end if;
2477: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL
2478: and (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
2479: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
2480: then
2481: GHR_GHRWS52L.CPDF_Parameter_Check;
2482: hr_utility.set_message(8301,'GHR_37850_ALL_PROCEDURE_FAIL');
2483: hr_utility.raise_error;
2484: end if;
2485: end if;
2523: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL then
2524: if (not(to_number(p_to_basic_pay) between nvl(min_basic_pay,0) and nvl(max_basic_pay,0))
2525: or p_to_basic_pay is null)
2526: then
2527: GHR_GHRWS52L.CPDF_Parameter_Check;
2528: hr_utility.set_message(8301,'GHR_37851_ALL_PROCEDURE_FAIL');
2529: hr_utility.raise_error;
2530: end if;
2531: end if;
2554: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL
2555: and (not(to_number(p_to_basic_pay) between nvl(min_basic_pay,0) and nvl(max_basic_pay,0))
2556: or p_to_basic_pay is null)
2557: then
2558: GHR_GHRWS52L.CPDF_Parameter_Check;
2559: hr_utility.set_message(8301,'GHR_37853_ALL_PROCEDURE_FAIL');
2560: hr_utility.raise_error;
2561: end if;
2562: end if;