DBA Data[Home] [Help]

APPS.HR_NO_QUALIFICATION_API dependencies on HR_UTILITY

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

78: FROM per_business_groups pbg
79: WHERE pbg.business_group_id = p_business_group_id;
80: --
81: BEGIN
82: hr_utility.set_location('Entering:'|| l_proc, 10);
83: --
84: -- Validation IN addition to Row Handlers
85: --
86: -- Check that the specified business group is valid.

Line 93: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');

89: FETCH csr_leg_code
90: INTO l_legislation_code;
91: IF csr_leg_code%notfound THEN
92: CLOSE csr_leg_code;
93: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
94: hr_utility.raise_error;
95: END IF;
96: CLOSE csr_leg_code;
97: hr_utility.set_location(l_proc, 20);

Line 94: hr_utility.raise_error;

90: INTO l_legislation_code;
91: IF csr_leg_code%notfound THEN
92: CLOSE csr_leg_code;
93: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
94: hr_utility.raise_error;
95: END IF;
96: CLOSE csr_leg_code;
97: hr_utility.set_location(l_proc, 20);
98: --

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

93: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
94: hr_utility.raise_error;
95: END IF;
96: CLOSE csr_leg_code;
97: hr_utility.set_location(l_proc, 20);
98: --
99: -- Check that the legislation of the specified business group is 'NO'.
100: --
101: IF l_legislation_code <> 'NO' THEN

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

98: --
99: -- Check that the legislation of the specified business group is 'NO'.
100: --
101: IF l_legislation_code <> 'NO' THEN
102: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
103: hr_utility.set_message_token('LEG_CODE','NO');
104: hr_utility.raise_error;
105: END IF;
106: hr_utility.set_location(l_proc, 30);

Line 103: hr_utility.set_message_token('LEG_CODE','NO');

99: -- Check that the legislation of the specified business group is 'NO'.
100: --
101: IF l_legislation_code <> 'NO' THEN
102: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
103: hr_utility.set_message_token('LEG_CODE','NO');
104: hr_utility.raise_error;
105: END IF;
106: hr_utility.set_location(l_proc, 30);
107: --

Line 104: hr_utility.raise_error;

100: --
101: IF l_legislation_code <> 'NO' THEN
102: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
103: hr_utility.set_message_token('LEG_CODE','NO');
104: hr_utility.raise_error;
105: END IF;
106: hr_utility.set_location(l_proc, 30);
107: --
108: -- Call the person business process

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

102: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
103: hr_utility.set_message_token('LEG_CODE','NO');
104: hr_utility.raise_error;
105: END IF;
106: hr_utility.set_location(l_proc, 30);
107: --
108: -- Call the person business process
109: --
110: per_qualifications_api.create_qualification

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

169: ,p_qualification_id => p_qualification_id
170: ,p_object_version_number => p_object_version_number
171: );
172: --
173: hr_utility.set_location(' Leaving:'||l_proc, 40);
174: --
175: end create_no_qualification;
176: --
177: -- ----------------------------------------------------------------------------

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

249: and pbg.business_group_id (+) = qua.business_group_id;
250:
251: --
252: BEGIN
253: hr_utility.set_location('Entering:'|| l_proc, 10);
254: --
255: -- Validation IN addition to Row Handlers
256: --
257: -- Check that the specified business group is valid.

Line 264: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');

260: FETCH csr_leg_code
261: INTO l_legislation_code;
262: IF csr_leg_code%notfound THEN
263: CLOSE csr_leg_code;
264: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
265: hr_utility.raise_error;
266: END IF;
267: CLOSE csr_leg_code;
268: hr_utility.set_location(l_proc, 20);

Line 265: hr_utility.raise_error;

261: INTO l_legislation_code;
262: IF csr_leg_code%notfound THEN
263: CLOSE csr_leg_code;
264: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
265: hr_utility.raise_error;
266: END IF;
267: CLOSE csr_leg_code;
268: hr_utility.set_location(l_proc, 20);
269: --

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

264: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
265: hr_utility.raise_error;
266: END IF;
267: CLOSE csr_leg_code;
268: hr_utility.set_location(l_proc, 20);
269: --
270: -- Check that the legislation of the specified business group is 'NO'.
271: --
272: IF l_legislation_code <> 'NO' THEN

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

269: --
270: -- Check that the legislation of the specified business group is 'NO'.
271: --
272: IF l_legislation_code <> 'NO' THEN
273: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
274: hr_utility.set_message_token('LEG_CODE','NO');
275: hr_utility.raise_error;
276: END IF;
277: hr_utility.set_location(l_proc, 30);

Line 274: hr_utility.set_message_token('LEG_CODE','NO');

270: -- Check that the legislation of the specified business group is 'NO'.
271: --
272: IF l_legislation_code <> 'NO' THEN
273: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
274: hr_utility.set_message_token('LEG_CODE','NO');
275: hr_utility.raise_error;
276: END IF;
277: hr_utility.set_location(l_proc, 30);
278: --

Line 275: hr_utility.raise_error;

271: --
272: IF l_legislation_code <> 'NO' THEN
273: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
274: hr_utility.set_message_token('LEG_CODE','NO');
275: hr_utility.raise_error;
276: END IF;
277: hr_utility.set_location(l_proc, 30);
278: --
279: -- Call the person business process

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

273: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
274: hr_utility.set_message_token('LEG_CODE','NO');
275: hr_utility.raise_error;
276: END IF;
277: hr_utility.set_location(l_proc, 30);
278: --
279: -- Call the person business process
280: --
281: per_qualifications_api.update_qualification

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

337: ,p_subscription_payment_method => p_subscription_payment_method
338: ,p_object_version_number => p_object_version_number
339: );
340: --
341: hr_utility.set_location(' Leaving:'||l_proc, 40);
342: --
343: end update_no_qualification;
344:
345: