56: -- Declare cursors and local variables
57: l_proc VARCHAR2(72) := g_package||'create_no_qualification';
58: --
59: BEGIN
60: hr_utility.set_location('Entering:'|| l_proc, 10);
61:
62: -- Check if information category is NO.
63:
64: IF p_information_category <> 'NO' THEN
61:
62: -- Check if information category is NO.
63:
64: IF p_information_category <> 'NO' THEN
65: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
66: hr_utility.set_message_token('LEG_CODE','NO');
67: hr_utility.raise_error;
68: END IF;
69:
62: -- Check if information category is NO.
63:
64: IF p_information_category <> 'NO' THEN
65: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
66: hr_utility.set_message_token('LEG_CODE','NO');
67: hr_utility.raise_error;
68: END IF;
69:
70: hr_utility.set_location(l_proc, 30);
63:
64: IF p_information_category <> 'NO' THEN
65: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
66: hr_utility.set_message_token('LEG_CODE','NO');
67: hr_utility.raise_error;
68: END IF;
69:
70: hr_utility.set_location(l_proc, 30);
71:
66: hr_utility.set_message_token('LEG_CODE','NO');
67: hr_utility.raise_error;
68: END IF;
69:
70: hr_utility.set_location(l_proc, 30);
71:
72: --
73: -- Call the qualification business process
74: --
168: l_proc VARCHAR2(72) := g_package||'create_no_qualification';
169: --
170: BEGIN
171:
172: hr_utility.set_location('Entering:'|| l_proc, 10);
173:
174: -- Check if information category is NO --
175:
176: IF p_information_category <> 'NO' THEN
173:
174: -- Check if information category is NO --
175:
176: IF p_information_category <> 'NO' THEN
177: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
178: hr_utility.set_message_token('LEG_CODE','NO');
179: hr_utility.raise_error;
180: END IF;
181:
174: -- Check if information category is NO --
175:
176: IF p_information_category <> 'NO' THEN
177: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
178: hr_utility.set_message_token('LEG_CODE','NO');
179: hr_utility.raise_error;
180: END IF;
181:
182: hr_utility.set_location(l_proc, 30);
175:
176: IF p_information_category <> 'NO' THEN
177: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
178: hr_utility.set_message_token('LEG_CODE','NO');
179: hr_utility.raise_error;
180: END IF;
181:
182: hr_utility.set_location(l_proc, 30);
183:
178: hr_utility.set_message_token('LEG_CODE','NO');
179: hr_utility.raise_error;
180: END IF;
181:
182: hr_utility.set_location(l_proc, 30);
183:
184: --
185: -- Call the qualification business process
186: --
228: ,p_provider => p_provider
229: ,p_qa_organization => p_qa_organization
230: ,p_object_version_number => p_object_version_number
231: );
232: hr_utility.set_location(' Leaving:'||l_proc, 40);
233: end update_no_qualification_type;
234: --
235: end hr_no_qualification_type_api;