DBA Data[Home] [Help]

APPS.IRC_LCV_BUS dependencies on HR_UTILITY

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

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

Line 41: hr_utility.set_location(' Leaving:'|| l_proc, 20);

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: -- ---------------------------------------------------------------------------

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

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

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

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: -- ----------------------------------------------------------------------------

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

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'

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

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;

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

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

Line 185: hr_utility.set_location(l_proc,40);

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;

Line 194: hr_utility.set_location(' Leaving:'||l_proc,50);

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 =>

Line 201: hr_utility.set_location(' Leaving:'||l_proc,60);

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;

Line 204: hr_utility.set_location(' Leaving:'||l_proc,70);

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 >----------------------------|

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

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: --

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

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

Line 237: hr_utility.set_location(' Leaving:'||l_proc, 10);

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 >----------------------------|

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

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: --

Line 263: hr_utility.set_location(' Leaving:'||l_proc, 10);

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 >----------------------------|

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

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);

Line 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;