38: ,p_effective_date => l_effective_date);
39: hr_utility.set_location('Leaving : '||l_proc,10);
40: EXCEPTION
41: WHEN OTHERS THEN
42: fnd_file.put_line(fnd_file.log,Sqlerrm);
43: retcode := 2;
44: errbuf := SQLERRM;
45: RAISE;
46: END populate_plan_hierarchy_cp;
409: ,p_effective_date => l_effective_date);
410: hr_utility.set_location('Leaving:'||l_proc,100);
411: EXCEPTION
412: WHEN OTHERS THEN
413: fnd_file.put_line(fnd_file.log,Sqlerrm);
414: retcode := 2;
415: errbuf := SQLERRM;
416: hr_utility.set_location('Leaving:'||l_proc,110);
417: RAISE;
768: hr_utility.set_location('Entering:'||l_proc,10);
769: OPEN csr_appr_period_dtls(p_appraisal_period_id);
770: FETCH csr_appr_period_dtls INTO g_appr_period_rec;
771: IF csr_appr_period_dtls%NOTFOUND THEN
772: fnd_file.put_line(fnd_file.LOG,'Invalid Appraisal Period selected. Cannot Proceed.');
773: g_errmsg := 'Invalid Appraisal Period selected. Cannot Proceed.';--- New message to be created.
774: CLOSE csr_appr_period_dtls;
775: RETURN;
776: END IF;