476: OPEN csr_check_legislation;
477: FETCH csr_check_legislation INTO l_legislation_code;
478: IF csr_check_legislation%NOTFOUND THEN
479: CLOSE csr_check_legislation;
480: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
481: hr_utility.set_message_token('LEG_CODE', 'NL');
482: hr_utility.raise_error;
483: END IF;
484: CLOSE csr_check_legislation;
477: FETCH csr_check_legislation INTO l_legislation_code;
478: IF csr_check_legislation%NOTFOUND THEN
479: CLOSE csr_check_legislation;
480: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
481: hr_utility.set_message_token('LEG_CODE', 'NL');
482: hr_utility.raise_error;
483: END IF;
484: CLOSE csr_check_legislation;
485: --
478: IF csr_check_legislation%NOTFOUND THEN
479: CLOSE csr_check_legislation;
480: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
481: hr_utility.set_message_token('LEG_CODE', 'NL');
482: hr_utility.raise_error;
483: END IF;
484: CLOSE csr_check_legislation;
485: --
486:
1136: OPEN csr_check_legislation(p_assignment_id, l_effective_date);
1137: FETCH csr_check_legislation INTO l_legislation_code;
1138: IF csr_check_legislation%NOTFOUND THEN
1139: CLOSE csr_check_legislation;
1140: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
1141: hr_utility.raise_error;
1142: END IF;
1143: CLOSE csr_check_legislation;
1144: --
1137: FETCH csr_check_legislation INTO l_legislation_code;
1138: IF csr_check_legislation%NOTFOUND THEN
1139: CLOSE csr_check_legislation;
1140: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
1141: hr_utility.raise_error;
1142: END IF;
1143: CLOSE csr_check_legislation;
1144: --
1145: -- Check that the legislation of the specified business group is 'NL'.
1144: --
1145: -- Check that the legislation of the specified business group is 'NL'.
1146: --
1147: IF l_legislation_code <> 'NL' then
1148: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
1149: hr_utility.set_message_token('LEG_CODE','NL');
1150: hr_utility.raise_error;
1151: END IF;
1152: --
1145: -- Check that the legislation of the specified business group is 'NL'.
1146: --
1147: IF l_legislation_code <> 'NL' then
1148: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
1149: hr_utility.set_message_token('LEG_CODE','NL');
1150: hr_utility.raise_error;
1151: END IF;
1152: --
1153:
1146: --
1147: IF l_legislation_code <> 'NL' then
1148: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
1149: hr_utility.set_message_token('LEG_CODE','NL');
1150: hr_utility.raise_error;
1151: END IF;
1152: --
1153:
1154: IF p_commencing_from IS NULL THEN