599: BEGIN
600: l_package_name := 'PAY_user_rowS_PKG.VALIDATE_TRANSLATION';
601: l_business_group_id := p_business_group_id;
602: l_legislation_code := p_legislation_code;
603: hr_utility.set_location (l_package_name,10);
604: OPEN c_translation(language, row_low_range_or_name,user_row_id,g_user_table_id,
605: l_business_group_id,l_legislation_code);
606: hr_utility.set_location (l_package_name,50);
607: FETCH c_translation INTO g_dummy;
602: l_legislation_code := p_legislation_code;
603: hr_utility.set_location (l_package_name,10);
604: OPEN c_translation(language, row_low_range_or_name,user_row_id,g_user_table_id,
605: l_business_group_id,l_legislation_code);
606: hr_utility.set_location (l_package_name,50);
607: FETCH c_translation INTO g_dummy;
608:
609: IF c_translation%NOTFOUND THEN
610: hr_utility.set_location (l_package_name,60);
606: hr_utility.set_location (l_package_name,50);
607: FETCH c_translation INTO g_dummy;
608:
609: IF c_translation%NOTFOUND THEN
610: hr_utility.set_location (l_package_name,60);
611: CLOSE c_translation;
612: ELSE
613: hr_utility.set_location (l_package_name,70);
614: CLOSE c_translation;
609: IF c_translation%NOTFOUND THEN
610: hr_utility.set_location (l_package_name,60);
611: CLOSE c_translation;
612: ELSE
613: hr_utility.set_location (l_package_name,70);
614: CLOSE c_translation;
615: fnd_message.set_name('PAY','HR_TRANSLATION_EXISTS');
616: fnd_message.raise_error;
617: END IF;
614: CLOSE c_translation;
615: fnd_message.set_name('PAY','HR_TRANSLATION_EXISTS');
616: fnd_message.raise_error;
617: END IF;
618: hr_utility.set_location ('Leaving:'||l_package_name,80);
619: END validate_translation;
620: --
621: --
622: