27: l_proc varchar2(72) := g_package||'set_security_group_id';
28: --
29: begin
30: --
31: hr_utility.set_location('Entering:'|| l_proc, 10);
32: --
33: -- Ensure that all the mandatory parameter are not null
34: --
35: hr_api.mandatory_arg_error
37: ,p_argument => 'location_criteria_value_id'
38: ,p_argument_value => p_location_criteria_value_id
39: );
40: --
41: hr_utility.set_location(' Leaving:'|| l_proc, 20);
42: --
43: end set_security_group_id;
44: --
45: -- ---------------------------------------------------------------------------
57: l_proc varchar2(72) := g_package||'return_legislation_code';
58: --
59: Begin
60: --
61: hr_utility.set_location('Entering:'|| l_proc, 10);
62: --
63: -- Ensure that all the mandatory parameter are not null
64: --
65: hr_api.mandatory_arg_error
67: ,p_argument => 'location_criteria_value_id'
68: ,p_argument_value => p_location_criteria_value_id
69: );
70: --
71: hr_utility.set_location(' Leaving:'|| l_proc, 40);
72: return l_legislation_code;
73: end return_legislation_code;
74: --
75: -- ----------------------------------------------------------------------------
167: select null from irc_search_criteria isc
168: where isc.search_criteria_id = p_search_criteria_id;
169: --
170: begin
171: hr_utility.set_location('Entering:'||l_proc,10);
172: -- Check that search_criteria_id is not null.
173: hr_api.mandatory_arg_error
174: (p_api_name => l_proc
175: ,p_argument => 'SEARCH_CRITERIA_ID'
175: ,p_argument => 'SEARCH_CRITERIA_ID'
176: ,p_argument_value => p_search_criteria_id
177: );
178: -- Check that search_criteria_id exists in irc_search_criteria.
179: hr_utility.set_location(l_proc,20);
180: if p_search_criteria_id is not null then
181: -- Check that search_criteria_id exists in irc_search_criteria.
182: hr_utility.set_location(l_proc,30);
183: open csr_search_criteria;
178: -- Check that search_criteria_id exists in irc_search_criteria.
179: hr_utility.set_location(l_proc,20);
180: if p_search_criteria_id is not null then
181: -- Check that search_criteria_id exists in irc_search_criteria.
182: hr_utility.set_location(l_proc,30);
183: open csr_search_criteria;
184: fetch csr_search_criteria into l_search_criteria_id;
185: hr_utility.set_location(l_proc,40);
186: if csr_search_criteria%NOTFOUND then
181: -- Check that search_criteria_id exists in irc_search_criteria.
182: hr_utility.set_location(l_proc,30);
183: open csr_search_criteria;
184: fetch csr_search_criteria into l_search_criteria_id;
185: hr_utility.set_location(l_proc,40);
186: if csr_search_criteria%NOTFOUND then
187: close csr_search_criteria;
188: fnd_message.set_name('PER','IRC_412226_INV_SRCH_CRITERIA');
189: fnd_message.raise_error;
190: end if;
191: end if;
192: close csr_search_criteria;
193: --
194: hr_utility.set_location(' Leaving:'||l_proc,50);
195: exception
196: when app_exception.application_exception then
197: if hr_multi_message.exception_add
198: (p_associated_column1 =>
197: if hr_multi_message.exception_add
198: (p_associated_column1 =>
199: 'IRC_LOCATION_CRITERIA_VALUES.SEARCH_CRITERIA_ID'
200: ) then
201: hr_utility.set_location(' Leaving:'||l_proc,60);
202: raise;
203: end if;
204: hr_utility.set_location(' Leaving:'||l_proc,70);
205: end chk_search_criteria_id;
200: ) then
201: hr_utility.set_location(' Leaving:'||l_proc,60);
202: raise;
203: end if;
204: hr_utility.set_location(' Leaving:'||l_proc,70);
205: end chk_search_criteria_id;
206: --
207: -- ----------------------------------------------------------------------------
208: -- |---------------------------< insert_validate >----------------------------|
213: --
214: l_proc varchar2(72) := g_package||'insert_validate';
215: --
216: Begin
217: hr_utility.set_location('Entering:'||l_proc, 5);
218: --
219: -- Call all supporting business operations
220: --
221: --
226: chk_search_criteria_id
227: (p_search_criteria_id => p_rec.search_criteria_id
228: );
229: --
230: hr_utility.set_location(l_proc, 20);
231: hr_api.mandatory_arg_error
232: (p_api_name => l_proc
233: ,p_argument => 'DERIVED_LOCALE'
234: ,p_argument_value => p_rec.derived_locale
233: ,p_argument => 'DERIVED_LOCALE'
234: ,p_argument_value => p_rec.derived_locale
235: );
236: --
237: hr_utility.set_location(' Leaving:'||l_proc, 10);
238: End insert_validate;
239: --
240: -- ----------------------------------------------------------------------------
241: -- |---------------------------< update_validate >----------------------------|
246: --
247: l_proc varchar2(72) := g_package||'update_validate';
248: --
249: Begin
250: hr_utility.set_location('Entering:'||l_proc, 5);
251: --
252: -- Call all supporting business operations
253: --
254: --
259: chk_non_updateable_args
260: (p_rec => p_rec
261: );
262: --
263: hr_utility.set_location(' Leaving:'||l_proc, 10);
264: End update_validate;
265: --
266: -- ----------------------------------------------------------------------------
267: -- |---------------------------< delete_validate >----------------------------|
272: --
273: l_proc varchar2(72) := g_package||'delete_validate';
274: --
275: Begin
276: hr_utility.set_location('Entering:'||l_proc, 5);
277: --
278: -- Call all supporting business operations
279: --
280: hr_utility.set_location(' Leaving:'||l_proc, 10);
276: hr_utility.set_location('Entering:'||l_proc, 5);
277: --
278: -- Call all supporting business operations
279: --
280: hr_utility.set_location(' Leaving:'||l_proc, 10);
281: End delete_validate;
282: --
283: end irc_lcv_bus;