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_VCE_BUS dependencies on HR_UTILITY

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

41: l_proc varchar2(72) := g_package||'set_security_group_id';
42: --
43: begin
44: --
45: hr_utility.set_location('Entering:'|| l_proc, 10);
46: --
47: -- Ensure that all the mandatory parameter are not null
48: --
49: hr_api.mandatory_arg_error

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

83: (p_security_group_id => l_security_group_id
84: );
85: end if;
86: --
87: hr_utility.set_location(' Leaving:'|| l_proc, 20);
88: --
89: end set_security_group_id;
90: --
91: -- ---------------------------------------------------------------------------

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

117: l_proc varchar2(72) := g_package||'return_legislation_code';
118: --
119: Begin
120: --
121: hr_utility.set_location('Entering:'|| l_proc, 10);
122: --
123: -- Ensure that all the mandatory parameter are not null
124: --
125: hr_api.mandatory_arg_error

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

142: -- call to this function. Just return the value in the global
143: -- variable.
144: --
145: l_legislation_code := irc_vce_bus.g_legislation_code;
146: hr_utility.set_location(l_proc, 20);
147: else
148: --
149: -- The ID is different to the last call to this function
150: -- or this is the first call to this function.

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

159: close csr_leg_code;
160: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
161: fnd_message.raise_error;
162: end if;
163: hr_utility.set_location(l_proc,30);
164: --
165: -- Set the global variables so the values are
166: -- available for the next call to this function.
167: --

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

169: irc_vce_bus.g_vacancy_id := p_vacancy_id;
170: irc_vce_bus.g_variable_comp_lookup := p_variable_comp_lookup;
171: irc_vce_bus.g_legislation_code := l_legislation_code;
172: end if;
173: hr_utility.set_location(' Leaving:'|| l_proc, 40);
174: return l_legislation_code;
175: end return_legislation_code;
176: --
177: -- ----------------------------------------------------------------------------

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

263: l_proc varchar2(72) := g_package || 'chk_variable_comp_lookup';
264: l_ret boolean;
265: --
266: begin
267: hr_utility.set_location('Entering:'||l_proc,10);
268: -- Checks that variable compensation lookup is passed as mandatory argument.
269: hr_api.mandatory_arg_error
270: (p_api_name => l_proc
271: ,p_argument => 'variable_comp_lookup'

Line 275: hr_utility.set_location(l_proc,15);

271: ,p_argument => 'variable_comp_lookup'
272: ,p_argument_value => p_variable_comp_lookup
273: );
274: -- Checks that variable compensation lookup is validated against hr_lookups.
275: hr_utility.set_location(l_proc,15);
276: l_ret := hr_api.not_exists_in_hr_lookups(
277: p_effective_date => p_effective_date
278: ,p_lookup_type => 'IRC_VARIABLE_COMP_ELEMENT'
279: ,p_lookup_code => p_variable_comp_lookup);

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

276: l_ret := hr_api.not_exists_in_hr_lookups(
277: p_effective_date => p_effective_date
278: ,p_lookup_type => 'IRC_VARIABLE_COMP_ELEMENT'
279: ,p_lookup_code => p_variable_comp_lookup);
280: hr_utility.set_location(l_proc,20);
281: if l_ret = true then
282: fnd_message.set_name('PER','IRC_412030_VCE_INV_VAR_COMP_LO');
283: fnd_message.raise_error;
284: end if;

Line 286: hr_utility.set_location(' Leaving:'||l_proc,25);

282: fnd_message.set_name('PER','IRC_412030_VCE_INV_VAR_COMP_LO');
283: fnd_message.raise_error;
284: end if;
285: --
286: hr_utility.set_location(' Leaving:'||l_proc,25);
287: exception
288: when app_exception.application_exception then
289: if hr_multi_message.exception_add
290: (p_associated_column1 =>

Line 293: hr_utility.set_location(' Leaving:'||l_proc,30);

289: if hr_multi_message.exception_add
290: (p_associated_column1 =>
291: 'IRC_VARIABLE_COMP_ELEMENTS.VARIABLE_COMP_LOOKUP'
292: ) then
293: hr_utility.set_location(' Leaving:'||l_proc,30);
294: raise;
295: end if;
296: hr_utility.set_location(' Leaving:'||l_proc,35);
297: end chk_variable_comp_lookup;

Line 296: hr_utility.set_location(' Leaving:'||l_proc,35);

292: ) then
293: hr_utility.set_location(' Leaving:'||l_proc,30);
294: raise;
295: end if;
296: hr_utility.set_location(' Leaving:'||l_proc,35);
297: end chk_variable_comp_lookup;
298: --
299: -- ----------------------------------------------------------------------------
300: -- |-----------------------------< chk_vacancy_id >---------------------------|

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

332: select null from per_all_vacancies pav where pav.vacancy_id = p_vacancy_id
333: and p_effective_date < NVL(pav.date_to,hr_api.g_eot);
334: --
335: begin
336: hr_utility.set_location('Entering:'||l_proc,10);
337: -- Checks that vacancy_id is passed as mandatory attribute
338: hr_api.mandatory_arg_error
339: (p_api_name => l_proc
340: ,p_argument => 'vacancy_id'

Line 344: hr_utility.set_location(l_proc,15);

340: ,p_argument => 'vacancy_id'
341: ,p_argument_value => p_vacancy_id
342: );
343: -- Checks that vacancy_id exists in PER_ALL_VACANCIES.
344: hr_utility.set_location(l_proc,15);
345: open csr_vacancy_id;
346: fetch csr_vacancy_id into l_vacancy_id;
347: if csr_vacancy_id%NOTFOUND then
348: close csr_vacancy_id;

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

350: fnd_message.raise_error;
351: end if;
352: close csr_vacancy_id;
353: --
354: hr_utility.set_location(' Leaving:'||l_proc,20);
355: exception
356: when app_exception.application_exception then
357: if hr_multi_message.exception_add
358: (p_associated_column1 =>

Line 361: hr_utility.set_location(' Leaving:'||l_proc,25);

357: if hr_multi_message.exception_add
358: (p_associated_column1 =>
359: 'IRC_VARIABLE_COMP_ELEMENTS.VACANCY_ID'
360: ) then
361: hr_utility.set_location(' Leaving:'||l_proc,25);
362: raise;
363: end if;
364: hr_utility.set_location(' Leaving:'||l_proc,30);
365: end chk_vacancy_id;

Line 364: hr_utility.set_location(' Leaving:'||l_proc,30);

360: ) then
361: hr_utility.set_location(' Leaving:'||l_proc,25);
362: raise;
363: end if;
364: hr_utility.set_location(' Leaving:'||l_proc,30);
365: end chk_vacancy_id;
366: --
367: -- ----------------------------------------------------------------------------
368: -- |---------------------------< insert_validate >----------------------------|

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

374: --
375: l_proc varchar2(72) := g_package||'insert_validate';
376: --
377: Begin
378: hr_utility.set_location('Entering:'||l_proc, 5);
379: --
380: -- Validate Important Attributes
381: --
382: -- As IRC_VARIABLE_COMP_ELEMENTS does not have a mandatory business_group_id

Line 385: hr_utility.set_location(l_proc,10);

381: --
382: -- As IRC_VARIABLE_COMP_ELEMENTS does not have a mandatory business_group_id
383: -- column, client_info is populated by calling
384: -- irc_vce_bus.set_security_group_id procedure.
385: hr_utility.set_location(l_proc,10);
386: irc_vce_bus.set_security_group_id(
387: p_vacancy_id => p_rec.vacancy_id
388: ,p_variable_comp_lookup => p_rec.variable_comp_lookup
389: );

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

394: -- one error has been found then abort further validation.
395: --
396: -- Validate Dependent Attributes
397: --
398: hr_utility.set_location(l_proc,20);
399: chk_variable_comp_lookup
400: (p_effective_date => p_effective_date
401: ,p_variable_comp_lookup => p_rec.variable_comp_lookup
402: );

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

401: ,p_variable_comp_lookup => p_rec.variable_comp_lookup
402: );
403: --
404: --
405: hr_utility.set_location(l_proc,30);
406: chk_vacancy_id
407: (p_effective_date => p_effective_date
408: ,p_vacancy_id => p_rec.vacancy_id
409: );

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

408: ,p_vacancy_id => p_rec.vacancy_id
409: );
410: --
411: --
412: hr_utility.set_location(' Leaving:'||l_proc, 40);
413: End insert_validate;
414: --
415: -- ----------------------------------------------------------------------------
416: -- |---------------------------< update_validate >----------------------------|

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

422: --
423: l_proc varchar2(72) := g_package||'update_validate';
424: --
425: Begin
426: hr_utility.set_location('Entering:'||l_proc, 5);
427: --
428: -- Validate Important Attributes
429: --
430: -- Call all supporting business operations

Line 438: hr_utility.set_location(l_proc,10);

434: -- one error has been found then abort further validation.
435: --
436: -- Validate Dependent Attributes
437: --
438: hr_utility.set_location(l_proc,10);
439: chk_non_updateable_args
440: (p_effective_date => p_effective_date
441: ,p_rec => p_rec
442: );

Line 447: hr_utility.set_location(l_proc,15);

443: --
444: -- As IRC_VARIABLE_COMP_ELEMENTS does not have a mandatory business_group_id
445: -- column, client_info is populated by calling
446: -- irc_vce_bus.set_security_group_id procedure.
447: hr_utility.set_location(l_proc,15);
448: irc_vce_bus.set_security_group_id(
449: p_vacancy_id => p_rec.vacancy_id
450: ,p_variable_comp_lookup => p_rec.variable_comp_lookup
451: );

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

449: p_vacancy_id => p_rec.vacancy_id
450: ,p_variable_comp_lookup => p_rec.variable_comp_lookup
451: );
452: --
453: hr_utility.set_location(' Leaving:'||l_proc, 20);
454: End update_validate;
455: --
456: -- ----------------------------------------------------------------------------
457: -- |---------------------------< delete_validate >----------------------------|

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

462: --
463: l_proc varchar2(72) := g_package||'delete_validate';
464: --
465: Begin
466: hr_utility.set_location('Entering:'||l_proc, 5);
467: --
468: -- Call all supporting business operations
469: --
470: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

466: hr_utility.set_location('Entering:'||l_proc, 5);
467: --
468: -- Call all supporting business operations
469: --
470: hr_utility.set_location(' Leaving:'||l_proc, 10);
471: End delete_validate;
472: --
473: end irc_vce_bus;