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

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

29: l_proc varchar2(72) := g_package||'set_security_group_id';
30: --
31: begin
32: --
33: hr_utility.set_location('Entering:'|| l_proc, 10);
34: --
35: -- Ensure that all the mandatory parameter are not null
36: --
37: hr_api.mandatory_arg_error

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

39: ,p_argument => 'vacancy_consideration_id'
40: ,p_argument_value => p_vacancy_consideration_id
41: );
42: --
43: hr_utility.set_location(' Leaving:'|| l_proc, 20);
44: --
45: end set_security_group_id;
46: --
47: -- ---------------------------------------------------------------------------

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

62: l_proc varchar2(72) := g_package||'return_legislation_code';
63: --
64: Begin
65: --
66: hr_utility.set_location('Entering:'|| l_proc, 10);
67: --
68: -- Ensure that all the mandatory parameter are not null
69: --
70: hr_api.mandatory_arg_error

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

73: ,p_argument_value => p_vacancy_consideration_id
74: );
75: --
76:
77: hr_utility.set_location(' Leaving:'|| l_proc, 40);
78: return l_legislation_code;
79: end return_legislation_code;
80: --
81: -- ----------------------------------------------------------------------------

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

207: --
208: --
209: Begin
210: --
211: hr_utility.set_location(' Entering:'||l_proc,10);
212: --
213: hr_api.mandatory_arg_error
214: (p_api_name => l_proc
215: ,p_argument => 'vacancy_id'

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

220: -- and display the appropriate error messages.
221: --
222: open csr_vacancy_dates;
223: fetch csr_vacancy_dates into l_date_from,l_date_to;
224: hr_utility.set_location(l_proc, 30);
225: if csr_vacancy_dates%notfound then
226: close csr_vacancy_dates;
227: fnd_message.set_name('PER','IRC_412032_RTM_INV_VACANCY_ID');
228: fnd_message.raise_error;

Line 231: hr_utility.set_location(l_proc, 35);

227: fnd_message.set_name('PER','IRC_412032_RTM_INV_VACANCY_ID');
228: fnd_message.raise_error;
229: --
230: elsif (p_effective_date > l_date_to) then
231: hr_utility.set_location(l_proc, 35);
232: close csr_vacancy_dates;
233: fnd_message.set_name('PER','IRC_412132_CLOSED_VACANCY_ID');
234: fnd_message.raise_error;
235: --

Line 238: hr_utility.set_location(l_proc, 37);

234: fnd_message.raise_error;
235: --
236: elsif (l_date_from > p_effective_date and p_consideration_status = 'PURSUE')
237: then
238: hr_utility.set_location(l_proc, 37);
239: close csr_vacancy_dates;
240: fnd_message.set_name('PER','IRC_FUTURE_VACANCY_ID');
241: fnd_message.raise_error;
242: --

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

242: --
243: end if;
244: close csr_vacancy_dates;
245: --
246: hr_utility.set_location(' Leaving:'||l_proc,40);
247: exception
248: when app_exception.application_exception then
249: if hr_multi_message.exception_add
250: (p_associated_column1 => 'IRC_VACANCY_CONSIDERATIONS.VACANCY_ID'

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

248: when app_exception.application_exception then
249: if hr_multi_message.exception_add
250: (p_associated_column1 => 'IRC_VACANCY_CONSIDERATIONS.VACANCY_ID'
251: ) then
252: hr_utility.set_location(' Leaving:'|| l_proc, 50);
253: raise;
254: end if;
255: hr_utility.set_location(' Leaving:'|| l_proc, 60);
256: --

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

251: ) then
252: hr_utility.set_location(' Leaving:'|| l_proc, 50);
253: raise;
254: end if;
255: hr_utility.set_location(' Leaving:'|| l_proc, 60);
256: --
257: End chk_vacancy_id;
258: --
259: -- ----------------------------------------------------------------------------

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

308: where person_id = p_person_id
309: and allow_access = 'Y';
310: Begin
311: --
312: hr_utility.set_location(' Entering:'||l_proc,10);
313: --
314: -- Check if the person_id exists in PER_ALL_PEOPLE_F.
315: --
316: open csr_person_id;

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

314: -- Check if the person_id exists in PER_ALL_PEOPLE_F.
315: --
316: open csr_person_id;
317: fetch csr_person_id into l_party_id;
318: hr_utility.set_location(l_proc, 30);
319: if csr_person_id%notfound then
320: close csr_person_id;
321: fnd_message.set_name('PER','IRC_412157_PARTY_PERS_MISMTCH');
322: fnd_message.raise_error;

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

334: -- Check if the person can be contacted
335: --
336: open csr_not_pref;
337: fetch csr_not_pref into l_var;
338: hr_utility.set_location(l_proc, 40);
339: if csr_not_pref%notfound then
340: close csr_not_pref;
341: fnd_message.set_name('PER','IRC_412047_IVC_NO_ALLOW_ACCESS');
342: fnd_message.raise_error;

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

342: fnd_message.raise_error;
343: end if;
344: close csr_not_pref;
345: --
346: hr_utility.set_location(' Leaving:'||l_proc,70);
347: exception
348: when app_exception.application_exception then
349: if hr_multi_message.exception_add
350: (p_associated_column1 => 'IRC_VACANCY_CONSIDERATIONS.PARTY_ID'

Line 352: hr_utility.set_location(' Leaving:'|| l_proc, 80);

348: when app_exception.application_exception then
349: if hr_multi_message.exception_add
350: (p_associated_column1 => 'IRC_VACANCY_CONSIDERATIONS.PARTY_ID'
351: ) then
352: hr_utility.set_location(' Leaving:'|| l_proc, 80);
353: raise;
354: end if;
355: hr_utility.set_location(' Leaving:'|| l_proc, 90);
356: --

Line 355: hr_utility.set_location(' Leaving:'|| l_proc, 90);

351: ) then
352: hr_utility.set_location(' Leaving:'|| l_proc, 80);
353: raise;
354: end if;
355: hr_utility.set_location(' Leaving:'|| l_proc, 90);
356: --
357: End chk_person_id;
358: --
359: -- ----------------------------------------------------------------------------

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

398: l_api_updating boolean;
399: --
400: Begin
401: --
402: hr_utility.set_location(' Entering:'||l_proc,10);
403: --
404: l_api_updating := irc_ivc_shd.api_updating(p_vacancy_consideration_id
405: ,p_object_version_number);
406: --

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

405: ,p_object_version_number);
406: --
407: -- Check to see if the consideration_status value has changed
408: --
409: hr_utility.set_location(l_proc, 20);
410: if ((l_api_updating
411: and (irc_ivc_shd.g_old_rec.consideration_status <>
412: p_consideration_status))
413: or (NOT l_api_updating)) then

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

418: (p_effective_date
419: ,'IRC_CONSIDERATION'
420: ,p_consideration_status
421: );
422: hr_utility.set_location(l_proc, 30);
423: if (l_var = true) then
424: fnd_message.set_name('PER','IRC_412048_IVC_INV_CONS_STATUS');
425: fnd_message.raise_error;
426: end if;

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

427: --
428: -- Check that the updated consideration status value is 'Pursue' if the
429: -- old value was 'Pursue'
430: --
431: hr_utility.set_location(l_proc, 40);
432: if(l_api_updating and irc_ivc_shd.g_old_rec.consideration_status = 'PURSUE'
433: and (p_consideration_status <> 'PURSUE')) then
434: fnd_message.set_name('PER','IRC_412049_IVC_INV_UPD_CONS_ST');
435: fnd_message.raise_error;

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

434: fnd_message.set_name('PER','IRC_412049_IVC_INV_UPD_CONS_ST');
435: fnd_message.raise_error;
436: end if;
437: end if;
438: hr_utility.set_location(' Leaving:'||l_proc,50);
439: --
440: exception
441: when app_exception.application_exception then
442: if hr_multi_message.exception_add

Line 446: hr_utility.set_location(' Leaving:'|| l_proc, 80);

442: if hr_multi_message.exception_add
443: (p_associated_column1 =>
444: irc_ivc_shd.g_tab_nam||'.CONSIDERATION_STATUS'
445: ) then
446: hr_utility.set_location(' Leaving:'|| l_proc, 80);
447: raise;
448: end if;
449: hr_utility.set_location(' Leaving:'|| l_proc, 90);
450: --

Line 449: hr_utility.set_location(' Leaving:'|| l_proc, 90);

445: ) then
446: hr_utility.set_location(' Leaving:'|| l_proc, 80);
447: raise;
448: end if;
449: hr_utility.set_location(' Leaving:'|| l_proc, 90);
450: --
451: End chk_consideration_status;
452: --
453: -- ----------------------------------------------------------------------------

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

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

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

464: hr_utility.set_location('Entering:'||l_proc, 5);
465: --
466: -- Call all supporting business operations
467: --
468: hr_utility.set_location(l_proc, 10);
469: chk_person_id
470: (p_person_id =>p_rec.person_id
471: ,p_party_id => p_rec.party_id
472: ,p_effective_date=>p_effective_date

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

471: ,p_party_id => p_rec.party_id
472: ,p_effective_date=>p_effective_date
473: );
474: --
475: hr_utility.set_location(l_proc, 20);
476: chk_vacancy_id
477: (p_vacancy_id => p_rec.vacancy_id
478: ,p_consideration_status => p_rec.consideration_status
479: ,p_effective_date => p_effective_date

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

478: ,p_consideration_status => p_rec.consideration_status
479: ,p_effective_date => p_effective_date
480: );
481: --
482: hr_utility.set_location(l_proc, 40);
483: chk_consideration_status
484: (p_consideration_status => p_rec.consideration_status
485: ,p_effective_date => p_effective_date
486: ,p_vacancy_consideration_id => p_rec.vacancy_consideration_id

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

486: ,p_vacancy_consideration_id => p_rec.vacancy_consideration_id
487: ,p_object_version_number => p_rec.object_version_number
488: );
489: --
490: hr_utility.set_location(' Leaving:'||l_proc, 60);
491: End insert_validate;
492: --
493: -- ----------------------------------------------------------------------------
494: -- |---------------------------< update_validate >----------------------------|

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

500: --
501: l_proc varchar2(72) := g_package||'update_validate';
502: --
503: Begin
504: hr_utility.set_location('Entering:'||l_proc, 5);
505: --
506: -- Call all supporting business operations
507: --
508: --

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

505: --
506: -- Call all supporting business operations
507: --
508: --
509: hr_utility.set_location(l_proc, 10);
510: --
511: chk_consideration_status
512: (p_consideration_status => p_rec.consideration_status
513: ,p_effective_date => p_effective_date

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

515: ,p_object_version_number => p_rec.object_version_number
516: );
517: --
518: --
519: hr_utility.set_location(l_proc, 30);
520: chk_non_updateable_args
521: (p_effective_date => p_effective_date
522: ,p_rec => p_rec
523: );

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

521: (p_effective_date => p_effective_date
522: ,p_rec => p_rec
523: );
524: --
525: hr_utility.set_location(' Leaving:'||l_proc, 40);
526: End update_validate;
527: --
528: -- ----------------------------------------------------------------------------
529: -- |---------------------------< delete_validate >----------------------------|

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

534: --
535: l_proc varchar2(72) := g_package||'delete_validate';
536: --
537: Begin
538: hr_utility.set_location('Entering:'||l_proc, 5);
539: --
540: -- Call all supporting business operations
541: --
542: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

538: hr_utility.set_location('Entering:'||l_proc, 5);
539: --
540: -- Call all supporting business operations
541: --
542: hr_utility.set_location(' Leaving:'||l_proc, 10);
543: End delete_validate;
544: --
545: end irc_ivc_bus;