[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;
159: , p_step_or_rate => p_to_step_or_rate
160: ) ;
161: if not (nvl(l_table_pay,0) = to_number(p_to_basic_pay) or
162: (p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)) then
163: GHR_GHRWS52L.CPDF_Parameter_Check;
164: hr_utility.set_message(8301,'GHR_37811_ALL_PROCEDURE_FAIL');
165: hr_utility.raise_error;
166: end if;
167: end if;
180: , p_step_or_rate => p_retained_step
181: ) ;
182: if not (l_table_pay = to_number(p_to_basic_pay) or
183: (p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)) then
184: GHR_GHRWS52L.CPDF_Parameter_Check;
185: hr_utility.set_message(8301,'GHR_37811_ALL_PROCEDURE_FAIL');
186: hr_utility.raise_error;
187: end if;
188: end if;
202: p_to_grade_or_level ,
203: 'Maximum Basic Pay',
204: p_effective_date);
205: IF NVL(to_number(p_to_basic_pay), 0) <> max_basic_pay THEN
206: GHR_GHRWS52L.CPDF_Parameter_Check;
207: hr_utility.set_message(8301,'GHR_37816_ALL_PROCEDURE_FAIL');
208: hr_utility.raise_error;
209: END IF;
210: END IF;
224: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 52',
225: p_to_grade_or_level,'Maximum Basic Pay',p_effective_date);
226: if not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
227: then
228: GHR_GHRWS52L.CPDF_Parameter_Check;
229: hr_utility.set_message(8301,'GHR_37425_ALL_PROCEDURE_FAIL');
230: hr_utility.raise_error;
231: end if;
232: end if;
249: 'Maximum Basic Pay',
250: p_effective_date);
251: if not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
252: then
253: GHR_GHRWS52L.CPDF_Parameter_Check;
254: hr_utility.set_message(8301,'GHR_37425_ALL_PROCEDURE_FAIL');
255: hr_utility.raise_error;
256: end if;
257: end if;
275: , p_grade_or_level => '00'
276: , p_step_or_rate => p_to_step_or_rate
277: ) ;
278: IF nvl(to_number(p_to_basic_pay), 0) <> l_table_pay THEN
279: GHR_GHRWS52L.CPDF_Parameter_Check;
280: hr_utility.set_message(8301,'GHR_37817_ALL_PROCEDURE_FAIL');
281: hr_utility.raise_error;
282: end if;
283: ELSIF ( p_effective_date >= to_date('2004/01/11', 'yyyy/mm/dd') and
293: 'Maximum Basic Pay',
294: p_effective_date);
295: if not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
296: then
297: GHR_GHRWS52L.CPDF_Parameter_Check;
298: hr_utility.set_message(8301,'GHR_38884_ALL_PROCEDURE_FAIL');
299: -- NEED TO ADD A NEW MESSAGE HERE
300: hr_utility.raise_error;
301: end if;
321: , p_step_or_rate => p_to_step_or_rate
322: ) ;
323: if not (to_number(p_to_basic_pay) = l_table_pay or
324: (p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)) then
325: GHR_GHRWS52L.CPDF_Parameter_Check;
326: hr_utility.set_message(8301,'GHR_37818_ALL_PROCEDURE_FAIL');
327: hr_utility.raise_error;
328: end if;
329: end if;
348: , p_step_or_rate => p_to_step_or_rate
349: ) ;
350: if not (to_number(p_to_basic_pay) > l_table_pay or
351: (p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)) then
352: GHR_GHRWS52L.CPDF_Parameter_Check;
353: hr_utility.set_message(8301,'GHR_37819_ALL_PROCEDURE_FAIL');
354: hr_utility.set_message_token('COND','exceed');
355: hr_utility.set_message_token('PRD_LIST','5,6 or M');
356: hr_utility.raise_error;
373: , p_step_or_rate => p_to_step_or_rate
374: ) ;
375: if not (to_number(p_to_basic_pay) >= l_table_pay or
376: (p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)) then
377: GHR_GHRWS52L.CPDF_Parameter_Check;
378: hr_utility.set_message(8301,'GHR_37819_ALL_PROCEDURE_FAIL');
379: hr_utility.set_message_token('COND','equal or exceed');
380: hr_utility.set_message_token('PRD_LIST','5 or 6');
381: hr_utility.raise_error;
404: if (
405: (l_table_pay > to_number(p_to_basic_pay)) and
406: (p_to_basic_pay is not null or to_number(p_to_basic_pay) <> '0')
407: ) then
408: GHR_GHRWS52L.CPDF_Parameter_Check;
409: hr_utility.set_message(8301,'GHR_38983_ALL_PROCEDURE_FAIL');
410: hr_utility.raise_error;
411: end if;
412: end if;
431: 'Maximum Basic Pay',
432: p_effective_date);
433: if not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
434: then
435: GHR_GHRWS52L.CPDF_Parameter_Check;
436: hr_utility.set_message(8301,'GHR_37427_ALL_PROCEDURE_FAIL');
437: hr_utility.raise_error;
438: end if;
439: end if;
460: 'Maximum Basic Pay',
461: p_effective_date);
462: if not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
463: then
464: GHR_GHRWS52L.CPDF_Parameter_Check;
465: hr_utility.set_message(8301,'GHR_37428_ALL_PROCEDURE_FAIL');
466: hr_utility.raise_error;
467: end if;
468: end if;
484: , p_pay_plan => 'GS'
485: , p_grade_or_level => '11'
486: , p_step_or_rate => '10') ;
487: if l_table_pay < to_number(p_to_basic_pay) then
488: GHR_GHRWS52L.CPDF_Parameter_Check;
489: hr_utility.set_message(8301,'GHR_37852_ALL_PROCEDURE_FAIL');
490: hr_utility.raise_error;
491: end if;
492: end if;
520: if not (
521: (nvl(l_table_pay,0) < to_number(p_to_basic_pay)) or
522: (p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
523: ) then
524: GHR_GHRWS52L.CPDF_Parameter_Check;
525: hr_utility.set_message(8301,'GHR_37844_ALL_PROCEDURE_FAIL');
526: hr_utility.set_message_token('COND','exceed');
527: hr_utility.set_message_token('PRD_LIST','E, F or M');
528: hr_utility.raise_error;
545: if not (
546: (nvl(l_table_pay,0) <= to_number(p_to_basic_pay)) or
547: (p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
548: ) then
549: GHR_GHRWS52L.CPDF_Parameter_Check;
550: hr_utility.set_message(8301,'GHR_37844_ALL_PROCEDURE_FAIL');
551: hr_utility.set_message_token('COND','equal or exceed');
552: hr_utility.set_message_token('PRD_LIST','E or F');
553: hr_utility.raise_error;
575: ) ;
576: if not (
577: (l_table_pay = to_number(p_to_basic_pay)) or (p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
578: ) then
579: GHR_GHRWS52L.CPDF_Parameter_Check;
580: hr_utility.set_message(8301,'GHR_37837_ALL_PROCEDURE_FAIL');
581: hr_utility.raise_error;
582: end if;
583: end if;
602: if not (
603: (nvl(l_table_pay,0) < to_number(p_to_basic_pay)) or
604: (p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
605: ) then
606: GHR_GHRWS52L.CPDF_Parameter_Check;
607: hr_utility.set_message(8301,'GHR_37838_ALL_PROCEDURE_FAIL');
608: hr_utility.raise_error;
609: end if;
610: end if;
626: if not (
627: (nvl(l_table_pay,0) <= to_number(p_to_basic_pay)) or
628: (p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
629: ) then
630: GHR_GHRWS52L.CPDF_Parameter_Check;
631: hr_utility.set_message(8301,'GHR_37838_ALL_PROCEDURE_FAIL');
632: hr_utility.raise_error;
633: end if;
634: end if;
654: if not (
655: (l_table_pay < to_number(p_to_basic_pay)) or
656: (p_to_basic_pay is null or to_number(p_to_basic_pay) = '0')
657: ) then
658: GHR_GHRWS52L.CPDF_Parameter_Check;
659: hr_utility.set_message(8301,'GHR_37839_ALL_PROCEDURE_FAIL');
660: hr_utility.set_message_token('COND','exceed');
661: hr_utility.set_message_token('PRD_LIST','5,6 or M');
662: hr_utility.raise_error;
675: if not (
676: (l_table_pay <= to_number(p_to_basic_pay)) or
677: (p_to_basic_pay is null or to_number(p_to_basic_pay) = '0')
678: ) then
679: GHR_GHRWS52L.CPDF_Parameter_Check;
680: hr_utility.set_message(8301,'GHR_37839_ALL_PROCEDURE_FAIL');
681: hr_utility.set_message_token('COND','equal or exceed');
682: hr_utility.set_message_token('PRD_LIST','5 or 6');
683: hr_utility.raise_error;
705: if (
706: (l_table_pay > to_number(p_to_basic_pay)) or
707: (p_to_basic_pay is not null or to_number(p_to_basic_pay) <> '0')
708: ) then
709: GHR_GHRWS52L.CPDF_Parameter_Check;
710: hr_utility.set_message(8301,'GHR_38984_ALL_PROCEDURE_FAIL');
711: hr_utility.raise_error;
712: end if;
713: end if;
741: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and
742: (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
743: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
744: then
745: GHR_GHRWS52L.CPDF_Parameter_Check;
746: hr_utility.set_message(8301,'GHR_37886_ALL_PROCEDURE_FAIL');
747: hr_utility.raise_error;
748: end if;
749: end if;
769: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and
770: (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
771: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
772: then
773: GHR_GHRWS52L.CPDF_Parameter_Check;
774: hr_utility.set_message(8301,'GHR_37802_ALL_PROCEDURE_FAIL');
775: hr_utility.raise_error;
776: end if;
777: end if;
797: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and
798: (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
799: or p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
800: then
801: GHR_GHRWS52L.CPDF_Parameter_Check;
802: hr_utility.set_message(8301,'GHR_37803_ALL_PROCEDURE_FAIL');
803: hr_utility.raise_error;
804: end if;
805: end if;
833: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and
834: (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
835: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
836: then
837: GHR_GHRWS52L.CPDF_Parameter_Check;
838: hr_utility.set_message(8301,'GHR_37863_ALL_PROCEDURE_FAIL');
839: hr_utility.raise_error;
840: end if;
841: end if;
869: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and
870: (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
871: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
872: then
873: GHR_GHRWS52L.CPDF_Parameter_Check;
874: hr_utility.set_message(8301,'GHR_37864_ALL_PROCEDURE_FAIL');
875: hr_utility.raise_error;
876: end if;
877: end if;
900: if min_basic_pay IS NOT NULL and
901: (not(to_number(p_to_basic_pay) >= min_basic_pay)
902: or (p_to_basic_pay is null and p_first_noac_lookup_code <> '817' ))
903: then
904: GHR_GHRWS52L.CPDF_Parameter_Check;
905: hr_utility.set_message(8301,'GHR_37805_ALL_PROCEDURE_FAIL');
906: hr_utility.raise_error;
907: end if;
908: end if;
927: if min_basic_pay IS NOT NULL and
928: (not(to_number(p_to_basic_pay) >= min_basic_pay)
929: or p_to_basic_pay is null)
930: then
931: GHR_GHRWS52L.CPDF_Parameter_Check;
932: hr_utility.set_message(8301,'GHR_37806_ALL_PROCEDURE_FAIL');
933: hr_utility.raise_error;
934: end if;
935: end if;
956: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL
957: and (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay)
958: or p_to_basic_pay is null)
959: then
960: GHR_GHRWS52L.CPDF_Parameter_Check;
961: hr_utility.set_message(8301,'GHR_37807_ALL_PROCEDURE_FAIL');
962: hr_utility.raise_error;
963: end if;
964: end if;
984: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL
985: and (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay)
986: or p_to_basic_pay is null)
987: then
988: GHR_GHRWS52L.CPDF_Parameter_Check;
989: hr_utility.set_message(8301,'GHR_37429_ALL_PROCEDURE_FAIL');
990: hr_utility.raise_error;
991: end if;
992: end if;
1010: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and
1011: (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay)
1012: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
1013: then
1014: GHR_GHRWS52L.CPDF_Parameter_Check;
1015: hr_utility.set_message(8301,'GHR_37808_ALL_PROCEDURE_FAIL');
1016: hr_utility.raise_error;
1017: end if;
1018: end if;*/
1036: p_effective_date);
1037:
1038: if not (nvl(l_table_pay,0) = to_number(p_to_basic_pay) or
1039: (p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)) THEN
1040: GHR_GHRWS52L.CPDF_Parameter_Check;
1041: hr_utility.set_message(8301,'GHR_37751_ALL_PROCEDURE_FAIL');
1042: hr_utility.raise_error;
1043: end if;
1044: end if;
1074: (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay)
1075: or p_to_basic_pay is null
1076: or to_number(p_to_basic_pay) = 0)
1077: then
1078: GHR_GHRWS52L.CPDF_Parameter_Check;
1079: hr_utility.set_message(8301,'GHR_37433_ALL_PROCEDURE_FAIL');
1080: hr_utility.raise_error;
1081: end if;
1082: end if;
1099: (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay)
1100: or p_to_basic_pay is null
1101: or to_number(p_to_basic_pay) = 0)
1102: then
1103: GHR_GHRWS52L.CPDF_Parameter_Check;
1104: hr_utility.set_message(8301,'GHR_37809_ALL_PROCEDURE_FAIL');
1105: hr_utility.raise_error;
1106: end if;
1107: end if;
1128: if min_basic_pay IS NOT NULL and
1129: (not(to_number(p_to_basic_pay) >= min_basic_pay)
1130: or p_to_basic_pay is null)
1131: then
1132: GHR_GHRWS52L.CPDF_Parameter_Check;
1133: hr_utility.set_message(8301,'GHR_37810_ALL_PROCEDURE_FAIL');
1134: hr_utility.raise_error;
1135: end if;
1136: end if;
1152: if min_basic_pay IS NOT NULL and
1153: (not(to_number(p_to_basic_pay) >= min_basic_pay)
1154: or p_to_basic_pay is null)
1155: then
1156: GHR_GHRWS52L.CPDF_Parameter_Check;
1157: hr_utility.set_message(8301,'GHR_38381_ALL_PROCEDURE_FAIL');
1158: hr_utility.raise_error;
1159: end if;
1160: end if;
1183: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL then
1184: if (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay)
1185: or p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
1186: then
1187: GHR_GHRWS52L.CPDF_Parameter_Check;
1188: hr_utility.set_message(8301,'GHR_37812_ALL_PROCEDURE_FAIL');
1189: hr_utility.raise_error;
1190: end if;
1191: end if;
1211: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL then
1212: if (not (to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
1213: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
1214: then
1215: GHR_GHRWS52L.CPDF_Parameter_Check;
1216: hr_utility.set_message(8301,'GHR_37813_ALL_PROCEDURE_FAIL');
1217: hr_utility.raise_error;
1218: end if;
1219: end if;
1243: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL then
1244: if (not (to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
1245: or p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
1246: then
1247: GHR_GHRWS52L.CPDF_Parameter_Check;
1248: hr_utility.set_message(8301,'GHR_37814_ALL_PROCEDURE_FAIL');
1249: hr_utility.raise_error;
1250: end if;
1251: end if;
1275: if p_rate_determinant_code in ('0','7')
1276: and (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
1277: or p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
1278: then
1279: GHR_GHRWS52L.CPDF_Parameter_Check;
1280: hr_utility.set_message(8301,'GHR_37435_ALL_PROCEDURE_FAIL');
1281: hr_utility.raise_error;
1282: end if;
1283: end if;
1296: if p_rate_determinant_code in ('0','7')
1297: and (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
1298: or p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
1299: then
1300: GHR_GHRWS52L.CPDF_Parameter_Check;
1301: hr_utility.set_message(8301,'GHR_37815_ALL_PROCEDURE_FAIL');
1302: hr_utility.raise_error;
1303: end if;
1304: end if;
1327: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and
1328: (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
1329: or p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
1330: then
1331: GHR_GHRWS52L.CPDF_Parameter_Check;
1332: hr_utility.set_message(8301,'GHR_37854_ALL_PROCEDURE_FAIL');
1333: hr_utility.raise_error;
1334: end if;
1335: end if;
1357: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and
1358: (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
1359: or p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
1360: then
1361: GHR_GHRWS52L.CPDF_Parameter_Check;
1362: hr_utility.set_message(8301,'GHR_37855_ALL_PROCEDURE_FAIL');
1363: hr_utility.raise_error;
1364: end if;
1365: end if;
1383: if max_basic_pay IS NOT NULL and
1384: (not(to_number(p_to_basic_pay) < max_basic_pay)
1385: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
1386: then
1387: GHR_GHRWS52L.CPDF_Parameter_Check;
1388: hr_utility.set_message(8301,'GHR_37820_ALL_PROCEDURE_FAIL');
1389: hr_utility.raise_error;
1390: end if;
1391: end if;
1409: if min_basic_pay IS NOT NULL
1410: and (not(to_number(p_to_basic_pay) >= min_basic_pay)
1411: or p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
1412: then
1413: GHR_GHRWS52L.CPDF_Parameter_Check;
1414: hr_utility.set_message(8301,'GHR_37821_ALL_PROCEDURE_FAIL');
1415: hr_utility.raise_error;
1416: end if;
1417: end if;
1436: if max_basic_pay IS NOT NULL
1437: and (to_number(p_to_basic_pay) <> max_basic_pay
1438: or p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
1439: then
1440: GHR_GHRWS52L.CPDF_Parameter_Check;
1441: hr_utility.set_message(8301,'GHR_37928_ALL_PROCEDURE_FAIL');
1442: hr_utility.raise_error;
1443: end if;
1444: end if;
1472: if max_basic_pay IS NOT NULL
1473: and (to_number(p_to_basic_pay) <> max_basic_pay
1474: or p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
1475: then
1476: GHR_GHRWS52L.CPDF_Parameter_Check;
1477: hr_utility.set_message(8301,'GHR_37822_ALL_PROCEDURE_FAIL');
1478: hr_utility.raise_error;
1479: end if;
1480: end if;
1500: and (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay)
1501: or p_to_basic_pay is null
1502: or to_number(p_to_basic_pay) = 0)
1503: then
1504: GHR_GHRWS52L.CPDF_Parameter_Check;
1505: hr_utility.set_message(8301,'GHR_37823_ALL_PROCEDURE_FAIL');
1506: hr_utility.raise_error;
1507: end if;
1508: end if;
1529: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL
1530: and (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay)
1531: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
1532: then
1533: GHR_GHRWS52L.CPDF_Parameter_Check;
1534: hr_utility.set_message(8301,'GHR_37824_ALL_PROCEDURE_FAIL');
1535: hr_utility.raise_error;
1536: end if;
1537: end if;*/
1559: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and
1560: (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
1561: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
1562: then
1563: GHR_GHRWS52L.CPDF_Parameter_Check;
1564: hr_utility.set_message(8301,'GHR_37825_ALL_PROCEDURE_FAIL');
1565: hr_utility.raise_error;
1566: end if;
1567: end if;
1591: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and
1592: (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
1593: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
1594: then
1595: GHR_GHRWS52L.CPDF_Parameter_Check;
1596: hr_utility.set_message(8301,'GHR_37826_ALL_PROCEDURE_FAIL');
1597: hr_utility.raise_error;
1598: end if;
1599: end if;
1620: if max_basic_pay IS NOT NULL and min_basic_pay is not null and
1621: (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay)
1622: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
1623: then
1624: GHR_GHRWS52L.CPDF_Parameter_Check;
1625: hr_utility.set_message(8301,'GHR_37827_ALL_PROCEDURE_FAIL');
1626: hr_utility.raise_error;
1627: end if;
1628: end if;
1651: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL
1652: and not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay)
1653: or p_to_basic_pay is null
1654: then
1655: GHR_GHRWS52L.CPDF_Parameter_Check;
1656: hr_utility.set_message(8301,'GHR_37856_ALL_PROCEDURE_FAIL');
1657: hr_utility.raise_error;
1658: end if;
1659: end if;
1683: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL
1684: and (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay)
1685: or p_to_basic_pay is null)
1686: then
1687: GHR_GHRWS52L.CPDF_Parameter_Check;
1688: hr_utility.set_message(8301,'GHR_37858_ALL_PROCEDURE_FAIL');
1689: hr_utility.raise_error;
1690: end if;
1691: end if;
1715: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL
1716: and (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay)
1717: or p_to_basic_pay is null)
1718: then
1719: GHR_GHRWS52L.CPDF_Parameter_Check;
1720: hr_utility.set_message(8301,'GHR_37860_ALL_PROCEDURE_FAIL');
1721: hr_utility.raise_error;
1722: end if;
1723: end if;
1743: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and
1744: (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
1745: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
1746: then
1747: GHR_GHRWS52L.CPDF_Parameter_Check;
1748: hr_utility.set_message(8301,'GHR_37828_ALL_PROCEDURE_FAIL');
1749: hr_utility.raise_error;
1750: end if;
1751: end if;
1795: if max_basic_pay is not null and
1796: (not(to_number(p_to_basic_pay) between nvl(min_basic_pay,0) and nvl(max_basic_pay,0))
1797: or p_to_basic_pay is null)
1798: then
1799: GHR_GHRWS52L.CPDF_Parameter_Check;
1800: hr_utility.set_message(8301,'GHR_37829_ALL_PROCEDURE_FAIL');
1801: hr_utility.raise_error;
1802: end if;
1803: end if; */
1832: if max_basic_pay IS NOT NULL then
1833: if (not(to_number(p_to_basic_pay) between nvl(min_basic_pay,0) and nvl(max_basic_pay,0))
1834: or p_to_basic_pay is null)
1835: then
1836: GHR_GHRWS52L.CPDF_Parameter_Check;
1837: hr_utility.set_message(8301,'GHR_37830_ALL_PROCEDURE_FAIL');
1838: hr_utility.raise_error;
1839: end if;
1840: end if;
1865: if max_basic_pay IS NOT NULL then
1866: if (not(to_number(p_to_basic_pay) between nvl(min_basic_pay,0) and nvl(max_basic_pay,0))
1867: or p_to_basic_pay is null)
1868: then
1869: GHR_GHRWS52L.CPDF_Parameter_Check;
1870: hr_utility.set_message(8301,'GHR_37861_ALL_PROCEDURE_FAIL');
1871: hr_utility.raise_error;
1872: end if;
1873: end if;
1895: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL
1896: and (not(to_number(p_to_basic_pay) between nvl(min_basic_pay,0) and nvl(max_basic_pay,0))
1897: or p_to_basic_pay is null)
1898: then
1899: GHR_GHRWS52L.CPDF_Parameter_Check;
1900: hr_utility.set_message(8301,'GHR_37831_ALL_PROCEDURE_FAIL');
1901: hr_utility.raise_error;
1902: end if;
1903: end if;
1924: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and
1925: (not(to_number(p_to_basic_pay) between nvl(min_basic_pay,0) and nvl(max_basic_pay,0))
1926: or p_to_basic_pay is null)
1927: then
1928: GHR_GHRWS52L.CPDF_Parameter_Check;
1929: hr_utility.set_message(8301,'GHR_37832_ALL_PROCEDURE_FAIL');
1930: hr_utility.raise_error;
1931: end if;
1932: end if; */
1949: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL
1950: and (not(to_number(p_to_basic_pay) between nvl(min_basic_pay,0) and nvl(max_basic_pay,0))
1951: or p_to_basic_pay is null)
1952: then
1953: GHR_GHRWS52L.CPDF_Parameter_Check;
1954: hr_utility.set_message(8301,'GHR_37833_ALL_PROCEDURE_FAIL');
1955: hr_utility.raise_error;
1956: end if;
1957: end if;
1982: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL
1983: and (not(to_number(p_to_basic_pay) between nvl(min_basic_pay,0) and nvl(max_basic_pay,0))
1984: or p_to_basic_pay is null)
1985: then
1986: GHR_GHRWS52L.CPDF_Parameter_Check;
1987: hr_utility.set_message(8301,'GHR_37834_ALL_PROCEDURE_FAIL');
1988: hr_utility.raise_error;
1989: end if;
1990: 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_37081_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_37078_ALL_PROCEDURE_FAIL');
2059: hr_utility.raise_error;
2060: end if;
2061: end if;
2090: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL
2091: and (not(to_number(p_to_basic_pay) between nvl(min_basic_pay,0) and nvl(max_basic_pay,0))
2092: or p_to_basic_pay is null)
2093: then
2094: GHR_GHRWS52L.CPDF_Parameter_Check;
2095: hr_utility.set_message(8301,'GHR_37079_ALL_PROCEDURE_FAIL');
2096: hr_utility.raise_error;
2097: end if;
2098: end if;
2126: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL
2127: and (not(to_number(p_to_basic_pay) between nvl(min_basic_pay,0) and nvl(max_basic_pay,0))
2128: or p_to_basic_pay is null)
2129: then
2130: GHR_GHRWS52L.CPDF_Parameter_Check;
2131: hr_utility.set_message(8301,'GHR_37080_ALL_PROCEDURE_FAIL');
2132: hr_utility.raise_error;
2133: end if;
2134: end if;
2157: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL then
2158: if (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay)
2159: or p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
2160: then
2161: GHR_GHRWS52L.CPDF_Parameter_Check;
2162: hr_utility.set_message(8301,'GHR_37835_ALL_PROCEDURE_FAIL');
2163: hr_utility.raise_error;
2164: end if;
2165: end if;
2193: if max_basic_pay IS NOT NULL and
2194: (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay)
2195: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
2196: then
2197: GHR_GHRWS52L.CPDF_Parameter_Check;
2198: hr_utility.set_message(8301,'GHR_37836_ALL_PROCEDURE_FAIL');
2199: hr_utility.set_message_token('TABLE_NUMBER','24');
2200: hr_utility.raise_error;
2201: end if;
2216: if max_basic_pay IS NOT NULL and
2217: (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay)
2218: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
2219: then
2220: GHR_GHRWS52L.CPDF_Parameter_Check;
2221: hr_utility.set_message(8301,'GHR_37836_ALL_PROCEDURE_FAIL');
2222: hr_utility.set_message_token('TABLE_NUMBER','54');
2223: hr_utility.raise_error;
2224: end if;
2250: if max_basic_pay IS NOT NULL and
2251: (not(to_number(p_to_basic_pay) < max_basic_pay)
2252: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
2253: then
2254: GHR_GHRWS52L.CPDF_Parameter_Check;
2255: hr_utility.set_message(8301,'GHR_37840_ALL_PROCEDURE_FAIL');
2256: hr_utility.raise_error;
2257: end if;
2258: end if;
2285: (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay)
2286: or p_to_basic_pay is null
2287: or to_number(p_to_basic_pay) = 0)
2288: then
2289: GHR_GHRWS52L.CPDF_Parameter_Check;
2290: hr_utility.set_message(8301,'GHR_37841_ALL_PROCEDURE_FAIL');
2291: hr_utility.raise_error;
2292: end if;
2293: end if;
2314: if max_basic_pay IS NOT NULL
2315: and (not(to_number(p_to_basic_pay) <= max_basic_pay)
2316: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
2317: then
2318: GHR_GHRWS52L.CPDF_Parameter_Check;
2319: hr_utility.set_message(8301,'GHR_37842_ALL_PROCEDURE_FAIL');
2320: hr_utility.raise_error;
2321: end if;
2322: end if;
2347: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL
2348: and (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay)
2349: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
2350: then
2351: GHR_GHRWS52L.CPDF_Parameter_Check;
2352: hr_utility.set_message(8301,'GHR_37843_ALL_PROCEDURE_FAIL');
2353: hr_utility.raise_error;
2354: end if;
2355: end if;
2379: and p_retained_grade >= p_to_grade_or_level
2380: and (not(to_number(p_to_basic_pay) < max_basic_pay)
2381: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
2382: then
2383: GHR_GHRWS52L.CPDF_Parameter_Check;
2384: hr_utility.set_message(8301,'GHR_37845_ALL_PROCEDURE_FAIL');
2385: hr_utility.raise_error;
2386: end if;
2387: end if;
2411: and p_retained_grade >= p_to_grade_or_level
2412: and (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay)
2413: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
2414: then
2415: GHR_GHRWS52L.CPDF_Parameter_Check;
2416: hr_utility.set_message(8301,'GHR_37846_ALL_PROCEDURE_FAIL');
2417: hr_utility.raise_error;
2418: end if;
2419: end if;
2444: if max_basic_pay IS NOT NULL
2445: and (to_number(p_to_basic_pay) <> max_basic_pay
2446: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
2447: then
2448: GHR_GHRWS52L.CPDF_Parameter_Check;
2449: hr_utility.set_message(8301,'GHR_37847_ALL_PROCEDURE_FAIL');
2450: hr_utility.raise_error;
2451: end if;
2452: end if;
2469: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL
2470: and (to_number(p_to_basic_pay) <> max_basic_pay
2471: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
2472: then
2473: GHR_GHRWS52L.CPDF_Parameter_Check;
2474: hr_utility.set_message(8301,'GHR_37848_ALL_PROCEDURE_FAIL');
2475: hr_utility.raise_error;
2476: end if;
2477: end if;
2501: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL
2502: and (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay)
2503: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
2504: then
2505: GHR_GHRWS52L.CPDF_Parameter_Check;
2506: hr_utility.set_message(8301,'GHR_37849_ALL_PROCEDURE_FAIL');
2507: hr_utility.set_message_token('PRD','not C');
2508: hr_utility.raise_error;
2509: end if;
2523: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL
2524: and (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay)
2525: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
2526: then
2527: GHR_GHRWS52L.CPDF_Parameter_Check;
2528: hr_utility.set_message(8301,'GHR_37849_ALL_PROCEDURE_FAIL');
2529: hr_utility.set_message_token('PRD','not C or D');
2530: hr_utility.raise_error;
2531: end if;
2551: if max_basic_pay IS NOT NULL and
2552: (not(to_number(p_to_basic_pay) <> max_basic_pay)
2553: or p_to_basic_pay is null)
2554: then
2555: GHR_GHRWS52L.CPDF_Parameter_Check;
2556: hr_utility.set_message(8301,'GHR_38551_ALL_PROCEDURE_FAIL');
2557: hr_utility.raise_error;
2558: end if;
2559: end if;
2580: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL
2581: and (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
2582: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
2583: then
2584: GHR_GHRWS52L.CPDF_Parameter_Check;
2585: hr_utility.set_message(8301,'GHR_37850_ALL_PROCEDURE_FAIL');
2586: hr_utility.raise_error;
2587: end if;
2588: end if;
2627: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL then
2628: if (not(to_number(p_to_basic_pay) between nvl(min_basic_pay,0) and nvl(max_basic_pay,0))
2629: or p_to_basic_pay is null)
2630: then
2631: GHR_GHRWS52L.CPDF_Parameter_Check;
2632: hr_utility.set_message(8301,'GHR_37851_ALL_PROCEDURE_FAIL');
2633: hr_utility.raise_error;
2634: end if;
2635: end if;
2659: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL
2660: and (not(to_number(p_to_basic_pay) between nvl(min_basic_pay,0) and nvl(max_basic_pay,0))
2661: or p_to_basic_pay is null)
2662: then
2663: GHR_GHRWS52L.CPDF_Parameter_Check;
2664: hr_utility.set_message(8301,'GHR_37853_ALL_PROCEDURE_FAIL');
2665: hr_utility.raise_error;
2666: end if;
2667: end if;