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.IRC_PCV_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 => 'prof_area_criteria_value_id'
38: ,p_argument_value => p_prof_area_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 => 'prof_area_criteria_value_id'
68: ,p_argument_value => p_prof_area_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 181: hr_utility.set_location('Entering:'||l_proc,10);

177: select null from irc_search_criteria isc
178: where isc.search_criteria_id = p_search_criteria_id;
179: --
180: begin
181: hr_utility.set_location('Entering:'||l_proc,10);
182: -- Check that search_criteria_id is not null.
183: hr_api.mandatory_arg_error
184: (p_api_name => l_proc
185: ,p_argument => 'SEARCH_CRITERIA_ID'

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

185: ,p_argument => 'SEARCH_CRITERIA_ID'
186: ,p_argument_value => p_search_criteria_id
187: );
188: --
189: hr_utility.set_location(l_proc,20);
190: if p_search_criteria_id is not null then
191: -- Check that search_criteria_id exists in irc_search_criteria.
192: hr_utility.set_location(l_proc,30);
193: open csr_search_criteria;

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

188: --
189: hr_utility.set_location(l_proc,20);
190: if p_search_criteria_id is not null then
191: -- Check that search_criteria_id exists in irc_search_criteria.
192: hr_utility.set_location(l_proc,30);
193: open csr_search_criteria;
194: fetch csr_search_criteria into l_search_criteria_id;
195: hr_utility.set_location(l_proc,40);
196: if csr_search_criteria%NOTFOUND then

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

191: -- Check that search_criteria_id exists in irc_search_criteria.
192: hr_utility.set_location(l_proc,30);
193: open csr_search_criteria;
194: fetch csr_search_criteria into l_search_criteria_id;
195: hr_utility.set_location(l_proc,40);
196: if csr_search_criteria%NOTFOUND then
197: close csr_search_criteria;
198: fnd_message.set_name('PER','IRC_412226_INV_SRCH_CRITERIA');
199: fnd_message.raise_error;

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

200: end if;
201: end if;
202: close csr_search_criteria;
203: --
204: hr_utility.set_location(' Leaving:'||l_proc,50);
205: exception
206: when app_exception.application_exception then
207: if hr_multi_message.exception_add
208: (p_associated_column1 =>

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

207: if hr_multi_message.exception_add
208: (p_associated_column1 =>
209: 'IRC_PROF_AREA_CRITERIA_VALUES.SEARCH_CRITERIA_ID'
210: ) then
211: hr_utility.set_location(' Leaving:'||l_proc,60);
212: raise;
213: end if;
214: hr_utility.set_location(' Leaving:'||l_proc,70);
215: end chk_search_criteria_id;

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

210: ) then
211: hr_utility.set_location(' Leaving:'||l_proc,60);
212: raise;
213: end if;
214: hr_utility.set_location(' Leaving:'||l_proc,70);
215: end chk_search_criteria_id;
216: --
217: -- ----------------------------------------------------------------------------
218: -- |------------------------< chk_professional_area >-------------------------|

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

252: l_api_updating boolean;
253: l_ret boolean;
254: --
255: begin
256: hr_utility.set_location('Entering:'||l_proc,10);
257: --
258: hr_api.mandatory_arg_error
259: (p_api_name => l_proc
260: ,p_argument => 'PROFESSIONAL_AREA'

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

260: ,p_argument => 'PROFESSIONAL_AREA'
261: ,p_argument_value => p_professional_area
262: );
263: --
264: hr_utility.set_location(l_proc,20);
265: if p_professional_area is not null then
266: -- Check that professional_area exists in hr_lookups
267: hr_utility.set_location(l_proc,30);
268: l_ret := hr_api.not_exists_in_hr_lookups(

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

263: --
264: hr_utility.set_location(l_proc,20);
265: if p_professional_area is not null then
266: -- Check that professional_area exists in hr_lookups
267: hr_utility.set_location(l_proc,30);
268: l_ret := hr_api.not_exists_in_hr_lookups(
269: p_effective_date => p_effective_date
270: ,p_lookup_type => 'IRC_PROFESSIONAL_AREA'
271: ,p_lookup_code => p_professional_area);

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

274: fnd_message.raise_error;
275: end if;
276: end if;
277: --
278: hr_utility.set_location(' Leaving:'||l_proc,40);
279: exception
280: when app_exception.application_exception then
281: if hr_multi_message.exception_add
282: (p_associated_column1 => 'IRC_PROF_AREA_CRITERIA_VALUES.PROFESSIONAL_AREA'

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

280: when app_exception.application_exception then
281: if hr_multi_message.exception_add
282: (p_associated_column1 => 'IRC_PROF_AREA_CRITERIA_VALUES.PROFESSIONAL_AREA'
283: ) then
284: hr_utility.set_location(' Leaving:'||l_proc,50);
285: raise;
286: end if;
287: hr_utility.set_location(' Leaving:'||l_proc,60);
288: end chk_professional_area;

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

283: ) then
284: hr_utility.set_location(' Leaving:'||l_proc,50);
285: raise;
286: end if;
287: hr_utility.set_location(' Leaving:'||l_proc,60);
288: end chk_professional_area;
289: --
290: -- ----------------------------------------------------------------------------
291: -- |---------------------------< insert_validate >----------------------------|

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

297: --
298: l_proc varchar2(72) := g_package||'insert_validate';
299: --
300: Begin
301: hr_utility.set_location('Entering:'||l_proc, 5);
302: --
303: -- Call all supporting business operations
304: --
305: --

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

306: -- No business group context. HR_STANDARD_LOOKUPS used for validation.
307: --
308: -- Validate Dependent Attributes
309: --
310: hr_utility.set_location(l_proc, 20);
311: hr_api.mandatory_arg_error
312: (p_api_name => l_proc
313: ,p_argument => 'EFFECTIVE_DATE'
314: ,p_argument_value => p_effective_date

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

313: ,p_argument => 'EFFECTIVE_DATE'
314: ,p_argument_value => p_effective_date
315: );
316: --
317: hr_utility.set_location(l_proc, 30);
318: chk_search_criteria_id
319: (p_search_criteria_id => p_rec.search_criteria_id
320: );
321: --

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

318: chk_search_criteria_id
319: (p_search_criteria_id => p_rec.search_criteria_id
320: );
321: --
322: hr_utility.set_location(l_proc, 40);
323: irc_pcv_bus.chk_professional_area(
324: p_professional_area => p_rec.professional_area
325: ,p_effective_date => p_effective_date
326: ,p_prof_area_criteria_value_id => p_rec.prof_area_criteria_value_id

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

326: ,p_prof_area_criteria_value_id => p_rec.prof_area_criteria_value_id
327: ,p_object_version_number => p_rec.object_version_number
328: );
329: --
330: hr_utility.set_location(' Leaving:'||l_proc, 10);
331: End insert_validate;
332: --
333: -- ----------------------------------------------------------------------------
334: -- |---------------------------< update_validate >----------------------------|

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

340: --
341: l_proc varchar2(72) := g_package||'update_validate';
342: --
343: Begin
344: hr_utility.set_location('Entering:'||l_proc, 5);
345: --
346: -- Call all supporting business operations
347: --
348: --

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

354: (p_effective_date => p_effective_date
355: ,p_rec => p_rec
356: );
357: --
358: hr_utility.set_location(' Leaving:'||l_proc, 10);
359: End update_validate;
360: --
361: -- ----------------------------------------------------------------------------
362: -- |---------------------------< delete_validate >----------------------------|

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

367: --
368: l_proc varchar2(72) := g_package||'delete_validate';
369: --
370: Begin
371: hr_utility.set_location('Entering:'||l_proc, 5);
372: --
373: -- Call all supporting business operations
374: --
375: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

371: hr_utility.set_location('Entering:'||l_proc, 5);
372: --
373: -- Call all supporting business operations
374: --
375: hr_utility.set_location(' Leaving:'||l_proc, 10);
376: End delete_validate;
377: --
378: end irc_pcv_bus;