661: -- Check if business_group_id is correct for the given questionnaire
662: -- template id.
663:
664: if nvl(l_bus_grp_id,-1) <> nvl(p_business_group_id,-1) then
665: fnd_message.set_name('PER','PER_52470_APT_TEMP_NOT_IN_BG');
666: fnd_message.raise_error;
667: end if;
668: end if;
669:
662: -- template id.
663:
664: if nvl(l_bus_grp_id,-1) <> nvl(p_business_group_id,-1) then
665: fnd_message.set_name('PER','PER_52470_APT_TEMP_NOT_IN_BG');
666: fnd_message.raise_error;
667: end if;
668: end if;
669:
670: end if;
692: open csr_question_update1;
693: fetch csr_question_update1 into l_exists;
694: if csr_question_update1%found then
695: close csr_question_update1;
696: fnd_message.set_name('PER','PER_52471_APT_TEMPLATE_IN_USE');
697: fnd_message.raise_error;
698: end if;
699: close csr_question_update1;
700:
693: fetch csr_question_update1 into l_exists;
694: if csr_question_update1%found then
695: close csr_question_update1;
696: fnd_message.set_name('PER','PER_52471_APT_TEMPLATE_IN_USE');
697: fnd_message.raise_error;
698: end if;
699: close csr_question_update1;
700:
701: open csr_question_update2;
701: open csr_question_update2;
702: fetch csr_question_update2 into l_exists;
703: if csr_question_update2%found then
704: close csr_question_update2;
705: fnd_message.set_name('PER','PER_52471_APT_TEMPLATE_IN_USE');
706: fnd_message.raise_error;
707: end if;
708: close csr_question_update2;
709:
702: fetch csr_question_update2 into l_exists;
703: if csr_question_update2%found then
704: close csr_question_update2;
705: fnd_message.set_name('PER','PER_52471_APT_TEMPLATE_IN_USE');
706: fnd_message.raise_error;
707: end if;
708: close csr_question_update2;
709:
710:
844: -- Check if business_group_id is correct for the given questionnaire
845: -- template id.
846:
847: if nvl(l_bus_grp_id,-1) <> nvl(p_business_group_id,-1) then
848: fnd_message.set_name('PER','PER_52470_APT_TEMP_NOT_IN_BG');
849: fnd_message.raise_error;
850: end if;
851: end if;
852:
845: -- template id.
846:
847: if nvl(l_bus_grp_id,-1) <> nvl(p_business_group_id,-1) then
848: fnd_message.set_name('PER','PER_52470_APT_TEMP_NOT_IN_BG');
849: fnd_message.raise_error;
850: end if;
851: end if;
852:
853: end if;
876: open csr_question_update1;
877: fetch csr_question_update1 into l_exists;
878: if csr_question_update1%found then
879: close csr_question_update1;
880: fnd_message.set_name('PER','PER_52471_APT_TEMPLATE_IN_USE');
881: fnd_message.raise_error;
882: end if;
883: close csr_question_update1;
884:
877: fetch csr_question_update1 into l_exists;
878: if csr_question_update1%found then
879: close csr_question_update1;
880: fnd_message.set_name('PER','PER_52471_APT_TEMPLATE_IN_USE');
881: fnd_message.raise_error;
882: end if;
883: close csr_question_update1;
884:
885: open csr_question_update2;
885: open csr_question_update2;
886: fetch csr_question_update2 into l_exists;
887: if csr_question_update2%found then
888: close csr_question_update2;
889: fnd_message.set_name('PER','PER_52471_APT_TEMPLATE_IN_USE');
890: fnd_message.raise_error;
891: end if;
892: close csr_question_update2;
893:
886: fetch csr_question_update2 into l_exists;
887: if csr_question_update2%found then
888: close csr_question_update2;
889: fnd_message.set_name('PER','PER_52471_APT_TEMPLATE_IN_USE');
890: fnd_message.raise_error;
891: end if;
892: close csr_question_update2;
893:
894: