DBA Data[Home] [Help]

APPS.IRC_IID_BUS dependencies on HR_UTILITY

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

49: exception
50: when app_exception.application_exception then
51: if hr_multi_message.exception_add
52: (p_associated_column1 => 'ATTRIBUTE_ID') then
53: hr_utility.set_location(' Leaving:'|| l_proc, 50);
54: raise;
55: end if;
56: hr_utility.set_location(' Leaving:'|| l_proc, 60);
57: end chk_delete;

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

52: (p_associated_column1 => 'ATTRIBUTE_ID') then
53: hr_utility.set_location(' Leaving:'|| l_proc, 50);
54: raise;
55: end if;
56: hr_utility.set_location(' Leaving:'|| l_proc, 60);
57: end chk_delete;
58: --
59: -- ----------------------------------------------------------------------------
60: -- |------------------------------< chk_ddf >----------------------------------|

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

90: --
91: l_proc varchar2(72) := g_package || 'chk_ddf';
92: --
93: begin
94: hr_utility.set_location('Entering:'||l_proc,10);
95: --
96: if ((p_rec.interview_details_id is not null) and (
97: nvl(irc_iid_shd.g_old_rec.iid_information_category, hr_api.g_varchar2) <>
98: nvl(p_rec.iid_information_category, hr_api.g_varchar2) or

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

189: ,p_attribute20_value => p_rec.iid_information20
190: );
191: end if;
192: --
193: hr_utility.set_location(' Leaving:'||l_proc,20);
194: end chk_ddf;
195: --
196: -- ----------------------------------------------------------------------------
197: -- |-----------------------< chk_non_updateable_args >------------------------|

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

228: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
229: --
230: Begin
231: --
232: hr_utility.set_location(' Leaving:'||l_proc,10);
233: --
234: -- Only proceed with the validation if a row exists for the current
235: -- record in the HR Schema.
236: --

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

256: ,p_base_table => irc_iid_shd.g_tab_name
257: );
258: end if;
259: --
260: hr_utility.set_location(' Leaving:'||l_proc,20);
261: End chk_non_updateable_args;
262: --
263: -- ----------------------------------------------------------------------------
264: -- |--------------------------< dt_update_validate >--------------------------|

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

444: --
445: l_proc varchar2(72) := g_package||'chk_status';
446: l_not_exists boolean;
447: Begin
448: hr_utility.set_location('Entering:'||l_proc, 5);
449: --
450: l_not_exists := hr_api.not_exists_in_hr_lookups
451: (p_effective_date
452: ,'IRC_INTERVIEW_STATUS'

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

451: (p_effective_date
452: ,'IRC_INTERVIEW_STATUS'
453: ,p_rec.status
454: );
455: hr_utility.set_location(l_proc, 10);
456: if (l_not_exists = true) then
457: -- RAISE ERROR SAYING THAT THE STATUS IS INVALID
458: fnd_message.set_name('PER','IRC_412471_INV_INT_STATUS');
459: fnd_message.raise_error;

Line 461: hr_utility.set_location('leaving:'||l_proc, 15);

457: -- RAISE ERROR SAYING THAT THE STATUS IS INVALID
458: fnd_message.set_name('PER','IRC_412471_INV_INT_STATUS');
459: fnd_message.raise_error;
460: end if;
461: hr_utility.set_location('leaving:'||l_proc, 15);
462: end chk_status;
463: --
464: --
465: -- ----------------------------------------------------------------------------

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

473: l_proc varchar2(72) := g_package||'chk_result';
474: l_not_exists boolean;
475: --
476: Begin
477: hr_utility.set_location('Entering:'||l_proc, 5);
478: --
479: l_not_exists := hr_api.not_exists_in_hr_lookups
480: (p_effective_date
481: ,'IRC_INTERVIEW_RESULTS'

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

480: (p_effective_date
481: ,'IRC_INTERVIEW_RESULTS'
482: ,p_rec.result
483: );
484: hr_utility.set_location(l_proc, 10);
485: if (l_not_exists = true) then
486: -- RAISE ERROR SAYING INVALID RESULT
487: fnd_message.set_name('PER','IRC_412472_INV_INT_RESULT');
488: fnd_message.raise_error;

Line 490: hr_utility.set_location('leaving:'||l_proc, 15);

486: -- RAISE ERROR SAYING INVALID RESULT
487: fnd_message.set_name('PER','IRC_412472_INV_INT_RESULT');
488: fnd_message.raise_error;
489: end if;
490: hr_utility.set_location('leaving:'||l_proc, 15);
491: end chk_result;
492: --
493: ---- ----------------------------------------------------------------------------
494: -- |---------------------------< chk_completed >--------------------------------|

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

501: l_proc varchar2(72) := g_package||'chk_completed';
502: l_result_not_eists boolean;
503: --
504: Begin
505: hr_utility.set_location('Entering:'||l_proc, 5);
506: --
507: if p_rec.status = 'COMPLETED' then
508: if p_rec.feedback is null then
509: -- raise error saying feedback is mandatory when status is complete

Line 539: hr_utility.set_location('leaving:'||l_proc, 10);

535: fnd_message.set_name('PER','IRC_412476_FEEDBACK_NOT_NULL');
536: fnd_message.raise_error;
537: end if;
538: end if;
539: hr_utility.set_location('leaving:'||l_proc, 10);
540: end chk_completed;
541: ---
542: ----------------------------------------------------------------------------
543: -- |---------------------------< chk_updated_status >--------------------------------|

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

549: --
550: l_proc varchar2(72) := g_package||'chk_updated_status';
551: --
552: Begin
553: hr_utility.set_location('Entering:'||l_proc, 5);
554: --
555: if (p_old_status <> p_new_status) then
556: if p_old_status = 'PLANNED' then
557: if (p_new_status = 'RESCHEDULED' or p_new_status = 'COMPLETED') then

Line 593: hr_utility.set_location('leaving:'||l_proc, 10);

589: end if;
590: end if;
591: end if;
592: --
593: hr_utility.set_location('leaving:'||l_proc, 10);
594: end chk_updated_status;
595: --
596: -- ----------------------------------------------------------------------------
597: -- |---------------------------< chk_event_id >-------------------------------|

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

629: --
630: l_proc varchar2(72) := g_package||'insert_validate';
631: --
632: Begin
633: hr_utility.set_location('Entering:'||l_proc, 5);
634: --
635: -- irc_iid_bus.chk_event_id (p_rec => p_rec); -- commented for fixing the issue
636: irc_iid_bus.chk_status(p_rec => p_rec
637: ,p_effective_date => p_effective_date);

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

639: ,p_effective_date => p_effective_date
640: );
641: irc_iid_bus.chk_ddf(p_rec);
642: --
643: hr_utility.set_location(' Leaving:'||l_proc, 10);
644: End insert_validate;
645: --
646: -- ----------------------------------------------------------------------------
647: -- |---------------------------< update_validate >----------------------------|

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

662: where interview_details_id = p_rec.interview_details_id
663: and sysdate between start_date and nvl(end_date,hr_general.end_of_time);
664: --
665: Begin
666: hr_utility.set_location('Entering:'||l_proc, 5);
667: --
668: irc_iid_bus.chk_event_id (p_rec => p_rec);
669: irc_iid_bus.chk_status(p_rec => p_rec
670: ,p_effective_date => p_effective_date);

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

702: );
703: --
704: irc_iid_bus.chk_ddf(p_rec);
705: --
706: hr_utility.set_location(' Leaving:'||l_proc, 10);
707: End update_validate;
708: --
709: end irc_iid_bus;