185: --
186: -- {End Of Comments}
187: -- ----------------------------------------------------------------------------
188: Procedure chk_vacancy_id
189: (p_vacancy_id in irc_vacancy_considerations.vacancy_id%type
190: ,p_consideration_status in irc_vacancy_considerations.consideration_status%type
191: ,p_effective_date date
192: ) IS
193: --
186: -- {End Of Comments}
187: -- ----------------------------------------------------------------------------
188: Procedure chk_vacancy_id
189: (p_vacancy_id in irc_vacancy_considerations.vacancy_id%type
190: ,p_consideration_status in irc_vacancy_considerations.consideration_status%type
191: ,p_effective_date date
192: ) IS
193: --
194: l_proc varchar2(72) := g_package || 'chk_vacancy_id';
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'
251: ) then
252: hr_utility.set_location(' Leaving:'|| l_proc, 50);
253: raise;
254: end if;
281: --
282: -- {End Of Comments}
283: -- ----------------------------------------------------------------------------
284: Procedure chk_person_id
285: (p_person_id in irc_vacancy_considerations.person_id%type
286: ,p_party_id in out nocopy irc_vacancy_considerations.party_id%type
287: ,p_effective_date date
288: ) IS
289: --
282: -- {End Of Comments}
283: -- ----------------------------------------------------------------------------
284: Procedure chk_person_id
285: (p_person_id in irc_vacancy_considerations.person_id%type
286: ,p_party_id in out nocopy irc_vacancy_considerations.party_id%type
287: ,p_effective_date date
288: ) IS
289: --
290: l_proc varchar2(72) := g_package || 'chk_person_id';
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'
351: ) then
352: hr_utility.set_location(' Leaving:'|| l_proc, 80);
353: raise;
354: end if;
384: --
385: -- {End Of Comments}
386: -- ----------------------------------------------------------------------------
387: Procedure chk_consideration_status
388: (p_consideration_status in irc_vacancy_considerations.
389: consideration_status%type
390: ,p_vacancy_consideration_id in irc_vacancy_considerations.vacancy_consideration_id%type
391: ,p_object_version_number in irc_vacancy_considerations.
392: object_version_number%type
386: -- ----------------------------------------------------------------------------
387: Procedure chk_consideration_status
388: (p_consideration_status in irc_vacancy_considerations.
389: consideration_status%type
390: ,p_vacancy_consideration_id in irc_vacancy_considerations.vacancy_consideration_id%type
391: ,p_object_version_number in irc_vacancy_considerations.
392: object_version_number%type
393: ,p_effective_date in date
394: ) IS
387: Procedure chk_consideration_status
388: (p_consideration_status in irc_vacancy_considerations.
389: consideration_status%type
390: ,p_vacancy_consideration_id in irc_vacancy_considerations.vacancy_consideration_id%type
391: ,p_object_version_number in irc_vacancy_considerations.
392: object_version_number%type
393: ,p_effective_date in date
394: ) IS
395: --