eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_SG_ASSIGNMENT_API dependencies on HR_UTILITY

Line 139: hr_utility.set_location('Entering:'|| l_proc, 10);

135: AND pbg.legislation_code = 'SG';
136: --
137: --
138: Begin
139: hr_utility.set_location('Entering:'|| l_proc, 10);
140: --
141: -- Initialise local variable
142: --
143: l_effective_date := trunc(p_effective_date);

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

150: FETCH csr_legislation
151: INTO l_legislation_code;
152: IF csr_legislation%notfound THEN
153: CLOSE csr_legislation;
154: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
155: hr_utility.set_message_token('LEG_CODE', 'SG');
156: hr_utility.raise_error;
157: END IF;
158: CLOSE csr_legislation;

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

151: INTO l_legislation_code;
152: IF csr_legislation%notfound THEN
153: CLOSE csr_legislation;
154: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
155: hr_utility.set_message_token('LEG_CODE', 'SG');
156: hr_utility.raise_error;
157: END IF;
158: CLOSE csr_legislation;
159: --

Line 156: hr_utility.raise_error;

152: IF csr_legislation%notfound THEN
153: CLOSE csr_legislation;
154: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
155: hr_utility.set_message_token('LEG_CODE', 'SG');
156: hr_utility.raise_error;
157: END IF;
158: CLOSE csr_legislation;
159: --
160: --

Line 246: hr_utility.set_location(' Leaving:'||l_proc, 30);

242: ,p_assignment_sequence => p_assignment_sequence
243: ,p_comment_id => p_comment_id
244: ,p_other_manager_warning => p_other_manager_warning);
245:
246: hr_utility.set_location(' Leaving:'||l_proc, 30);
247:
248: End create_sg_secondary_emp_asg;
249:
250: -- ----------------------------------------------------------------------------

Line 349: hr_utility.set_location('Entering:'|| l_proc, 10);

345: AND asg.assignment_id = c_assignment_id
346: AND c_effective_date BETWEEN effective_start_date AND effective_end_date;
347:
348: Begin
349: hr_utility.set_location('Entering:'|| l_proc, 10);
350: --
351: -- Truncate DATE variables
352: --
353: l_effective_date := trunc(p_effective_date);

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

359: OPEN check_legislation(p_assignment_id, l_effective_date);
360: FETCH check_legislation into l_legislation_code;
361: IF check_legislation%notfound THEN
362: CLOSE check_legislation;
363: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
364: hr_utility.raise_error;
365: END IF;
366: CLOSE check_legislation;
367: hr_utility.set_location(l_proc, 20);

Line 364: hr_utility.raise_error;

360: FETCH check_legislation into l_legislation_code;
361: IF check_legislation%notfound THEN
362: CLOSE check_legislation;
363: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
364: hr_utility.raise_error;
365: END IF;
366: CLOSE check_legislation;
367: hr_utility.set_location(l_proc, 20);
368: --

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

363: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
364: hr_utility.raise_error;
365: END IF;
366: CLOSE check_legislation;
367: hr_utility.set_location(l_proc, 20);
368: --
369: -- Check that the legislation of the specified business group IS 'SG'.
370: --
371: IF l_legislation_code <> 'SG' THEN

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

368: --
369: -- Check that the legislation of the specified business group IS 'SG'.
370: --
371: IF l_legislation_code <> 'SG' THEN
372: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
373: hr_utility.set_message_token('LEG_CODE','SG');
374: hr_utility.raise_error;
375: END IF;
376: hr_utility.set_location(l_proc, 30);

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

369: -- Check that the legislation of the specified business group IS 'SG'.
370: --
371: IF l_legislation_code <> 'SG' THEN
372: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
373: hr_utility.set_message_token('LEG_CODE','SG');
374: hr_utility.raise_error;
375: END IF;
376: hr_utility.set_location(l_proc, 30);
377: --

Line 374: hr_utility.raise_error;

370: --
371: IF l_legislation_code <> 'SG' THEN
372: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
373: hr_utility.set_message_token('LEG_CODE','SG');
374: hr_utility.raise_error;
375: END IF;
376: hr_utility.set_location(l_proc, 30);
377: --
378: -- Call update_emp_asg business process

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

372: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
373: hr_utility.set_message_token('LEG_CODE','SG');
374: hr_utility.raise_error;
375: END IF;
376: hr_utility.set_location(l_proc, 30);
377: --
378: -- Call update_emp_asg business process
379: -- --
380: hr_assignment_api.update_emp_asg

Line 452: hr_utility.set_location(' Leaving:'||l_proc, 40);

448: ,p_effective_end_date => p_effective_end_date
449: ,p_no_managers_warning => p_no_managers_warning
450: ,p_other_manager_warning => p_other_manager_warning);
451:
452: hr_utility.set_location(' Leaving:'||l_proc, 40);
453: --
454: End update_sg_emp_asg;
455:
456: END hr_sg_assignment_api;