620: FETCH csr_ctg_name INTO l_exists;
621: IF csr_ctg_name%FOUND THEN
622: CLOSE csr_ctg_name;
623: hr_utility.set_location(' Step:'|| l_proc, 10);
624: fnd_message.set_name('OTA', 'OTA_13100_LPS_CTG_UNIQUE_NAME');
625: fnd_message.raise_error;
626: ELSE
627: CLOSE csr_ctg_name;
628: hr_utility.set_location(' Step:'|| l_proc, 20);
621: IF csr_ctg_name%FOUND THEN
622: CLOSE csr_ctg_name;
623: hr_utility.set_location(' Step:'|| l_proc, 10);
624: fnd_message.set_name('OTA', 'OTA_13100_LPS_CTG_UNIQUE_NAME');
625: fnd_message.raise_error;
626: ELSE
627: CLOSE csr_ctg_name;
628: hr_utility.set_location(' Step:'|| l_proc, 20);
629: END IF;
634: FETCH csr_emp_name INTO l_exists;
635: IF csr_emp_name%FOUND THEN
636: CLOSE csr_emp_name;
637: hr_utility.set_location(' Step:'|| l_proc, 30);
638: fnd_message.set_name('OTA', 'OTA_443386_LPS_UNIQUE_NAME');
639: fnd_message.raise_error;
640: ELSE
641: CLOSE csr_emp_name;
642: hr_utility.set_location(' Step:'|| l_proc, 40);
635: IF csr_emp_name%FOUND THEN
636: CLOSE csr_emp_name;
637: hr_utility.set_location(' Step:'|| l_proc, 30);
638: fnd_message.set_name('OTA', 'OTA_443386_LPS_UNIQUE_NAME');
639: fnd_message.raise_error;
640: ELSE
641: CLOSE csr_emp_name;
642: hr_utility.set_location(' Step:'|| l_proc, 40);
643: END IF;
648: FETCH csr_ct_name INTO l_exists;
649: IF csr_ct_name%FOUND THEN
650: CLOSE csr_ct_name;
651: hr_utility.set_location(' Step:'|| l_proc, 50);
652: fnd_message.set_name('OTA', 'OTA_443386_LPS_UNIQUE_NAME');
653: fnd_message.raise_error;
654: ELSE
655: CLOSE csr_ct_name;
656: hr_utility.set_location(' Step:'|| l_proc, 60);
649: IF csr_ct_name%FOUND THEN
650: CLOSE csr_ct_name;
651: hr_utility.set_location(' Step:'|| l_proc, 50);
652: fnd_message.set_name('OTA', 'OTA_443386_LPS_UNIQUE_NAME');
653: fnd_message.raise_error;
654: ELSE
655: CLOSE csr_ct_name;
656: hr_utility.set_location(' Step:'|| l_proc, 60);
657: END IF;