DBA Data[Home] [Help]

APPS.PER_APT_BUS dependencies on FND_MESSAGE

Line 665: fnd_message.set_name('PER','PER_52470_APT_TEMP_NOT_IN_BG');

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:

Line 666: fnd_message.raise_error;

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;

Line 696: fnd_message.set_name('PER','PER_52471_APT_TEMPLATE_IN_USE');

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:

Line 697: fnd_message.raise_error;

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;

Line 705: fnd_message.set_name('PER','PER_52471_APT_TEMPLATE_IN_USE');

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:

Line 706: fnd_message.raise_error;

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:

Line 848: fnd_message.set_name('PER','PER_52470_APT_TEMP_NOT_IN_BG');

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:

Line 849: fnd_message.raise_error;

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;

Line 880: fnd_message.set_name('PER','PER_52471_APT_TEMPLATE_IN_USE');

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:

Line 881: fnd_message.raise_error;

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;

Line 889: fnd_message.set_name('PER','PER_52471_APT_TEMPLATE_IN_USE');

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:

Line 890: fnd_message.raise_error;

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: