APPS.HR_QSA_BUS dependencies on HR_QSA_SHD

Line 155: hr_qsa_shd.constraint_error('HR_QUEST_ANSWERS_FK1');

151: fetch csr_id_exists into l_bus_grp_id;
152: if csr_id_exists%NOTFOUND then
153: -- questionnaire_template_id doesnt exist in hr_questionnaires
154: close csr_id_exists;
155: hr_qsa_shd.constraint_error('HR_QUEST_ANSWERS_FK1');
156: end if;
157: close csr_id_exists;
158: --
159: hr_utility.set_location(l_proc,30);

Line 234: hr_qsa_shd.constraint_error('HR_QUEST_ANS_TYPE_CHK');

230: ,p_lookup_type => 'QUEST_OBJECT_TYPE'
231: ,p_lookup_code => p_type
232: ) then
233: -- p_type does not exist in lookup
234: hr_qsa_shd.constraint_error('HR_QUEST_ANS_TYPE_CHK');
235: end if;
236: else
237: -- p_type is null
238: fnd_message.set_name('PER','PER_52432_QSA_MAND_TYPE');

Line 301: hr_qsa_shd.constraint_error('HR_QUEST_ANSWERS_UK1');

297: open csr_unique_id;
298: fetch csr_unique_id into l_exists;
299: if csr_unique_id%FOUND then
300: close csr_unique_id;
301: hr_qsa_shd.constraint_error('HR_QUEST_ANSWERS_UK1');
302: end if;
303: close csr_unique_id;
304: --
305: hr_utility.set_location(l_proc,20);

Line 429: Procedure insert_validate(p_rec in hr_qsa_shd.g_rec_type

425: --
426: -- ----------------------------------------------------------------------------
427: -- |---------------------------< insert_validate >----------------------------|
428: -- ----------------------------------------------------------------------------
429: Procedure insert_validate(p_rec in hr_qsa_shd.g_rec_type
430: ,p_effective_date in date
431: ) is
432: --
433: l_proc varchar2(72) := g_package||'insert_validate';

Line 464: Procedure update_validate(p_rec in hr_qsa_shd.g_rec_type

460: --
461: -- ----------------------------------------------------------------------------
462: -- |---------------------------< update_validate >----------------------------|
463: -- ----------------------------------------------------------------------------
464: Procedure update_validate(p_rec in hr_qsa_shd.g_rec_type
465: ,p_effective_date in date) is
466: --
467: l_proc varchar2(72) := g_package||'update_validate';
468: --

Line 482: Procedure delete_validate(p_rec in hr_qsa_shd.g_rec_type) is

478: --
479: -- ----------------------------------------------------------------------------
480: -- |---------------------------< delete_validate >----------------------------|
481: -- ----------------------------------------------------------------------------
482: Procedure delete_validate(p_rec in hr_qsa_shd.g_rec_type) is
483: --
484: l_proc varchar2(72) := g_package||'delete_validate';
485: --
486: Begin