DBA Data[Home] [Help]

APPS.HR_NL_ASSIGNMENT_API dependencies on HR_UTILITY

Line 480: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');

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;

Line 481: hr_utility.set_message_token('LEG_CODE', 'NL');

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: --

Line 482: hr_utility.raise_error;

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:

Line 1140: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');

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: --

Line 1141: hr_utility.raise_error;

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'.

Line 1148: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');

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: --

Line 1149: hr_utility.set_message_token('LEG_CODE','NL');

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:

Line 1150: hr_utility.raise_error;

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