DBA Data[Home] [Help]

APPS.HR_SG_PERSON_API dependencies on HR_UTILITY

Line 161: hr_utility.set_location('Entering:'|| l_proc, 5);

157: and c_effective_date
158: between per.effective_start_date and per.effective_end_date;
159: --
160: BEGIN
161: hr_utility.set_location('Entering:'|| l_proc, 5);
162: --
163: -- Initialise local variables
164: --
165: l_effective_date := trunc(p_effective_date);

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

171: OPEN check_legislation(p_person_id, l_effective_date);
172: FETCH check_legislation into l_legislation_code;
173: IF check_legislation%notfound THEN
174: CLOSE check_legislation;
175: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
176: hr_utility.raise_error;
177: END IF;
178: CLOSE check_legislation;
179: hr_utility.set_location(l_proc, 20);

Line 176: hr_utility.raise_error;

172: FETCH check_legislation into l_legislation_code;
173: IF check_legislation%notfound THEN
174: CLOSE check_legislation;
175: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
176: hr_utility.raise_error;
177: END IF;
178: CLOSE check_legislation;
179: hr_utility.set_location(l_proc, 20);
180: --

Line 179: hr_utility.set_location(l_proc, 20);

175: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
176: hr_utility.raise_error;
177: END IF;
178: CLOSE check_legislation;
179: hr_utility.set_location(l_proc, 20);
180: --
181: -- Check that the legislation of the specified business group is 'SG'.
182: --
183: IF l_legislation_code <> 'SG' THEN

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

180: --
181: -- Check that the legislation of the specified business group is 'SG'.
182: --
183: IF l_legislation_code <> 'SG' THEN
184: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
185: hr_utility.set_message_token('LEG_CODE','SG');
186: hr_utility.raise_error;
187: END IF;
188: hr_utility.set_location(l_proc, 30);

Line 185: hr_utility.set_message_token('LEG_CODE','SG');

181: -- Check that the legislation of the specified business group is 'SG'.
182: --
183: IF l_legislation_code <> 'SG' THEN
184: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
185: hr_utility.set_message_token('LEG_CODE','SG');
186: hr_utility.raise_error;
187: END IF;
188: hr_utility.set_location(l_proc, 30);
189: --

Line 186: hr_utility.raise_error;

182: --
183: IF l_legislation_code <> 'SG' THEN
184: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
185: hr_utility.set_message_token('LEG_CODE','SG');
186: hr_utility.raise_error;
187: END IF;
188: hr_utility.set_location(l_proc, 30);
189: --
190: -- Update the person record using the update_person BP

Line 188: hr_utility.set_location(l_proc, 30);

184: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
185: hr_utility.set_message_token('LEG_CODE','SG');
186: hr_utility.raise_error;
187: END IF;
188: hr_utility.set_location(l_proc, 30);
189: --
190: -- Update the person record using the update_person BP
191: --
192: hr_person_api.update_person

Line 324: hr_utility.set_location(' Leaving:'||l_proc, 7);

320: ,p_name_combination_warning => p_name_combination_warning
321: ,p_assign_payroll_warning => p_assign_payroll_warning
322: ,p_orig_hire_warning => p_orig_hire_warning);
323: --
324: hr_utility.set_location(' Leaving:'||l_proc, 7);
325: --
326: end update_sg_person;
327: end hr_sg_person_api;