17: l_lookup_code varchar2(30);
18: begin
19:
20: l_proc:= g_package||'check_ro_disability';
21: hr_utility.set_location('Entering:'|| l_proc, 5);
22: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'RO') THEN
23: hr_utility.set_location('Leaving : '||l_proc,10);
24: return;
25: END IF;
18: begin
19:
20: l_proc:= g_package||'check_ro_disability';
21: hr_utility.set_location('Entering:'|| l_proc, 5);
22: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'RO') THEN
23: hr_utility.set_location('Leaving : '||l_proc,10);
24: return;
25: END IF;
26: open csr_get_lookup_code;
19:
20: l_proc:= g_package||'check_ro_disability';
21: hr_utility.set_location('Entering:'|| l_proc, 5);
22: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'RO') THEN
23: hr_utility.set_location('Leaving : '||l_proc,10);
24: return;
25: END IF;
26: open csr_get_lookup_code;
27: loop
35: END LOOP;
36: CLOSE csr_get_lookup_code;
37:
38: IF p_category not in ('RO_SLIGHT','RO_MEDIUM','RO_SEVERE','RO_ACCENTUATED') THEN
39: hr_utility.set_message(800, 'HR_520018_INVALID_CATEGORY');
40: hr_utility.set_message_token('DISABILITY_CATEGORY', l_lookup_codelist);
41: hr_utility.raise_error;
42: END IF;
43: hr_utility.set_location('Leaving : '||l_proc,20);
36: CLOSE csr_get_lookup_code;
37:
38: IF p_category not in ('RO_SLIGHT','RO_MEDIUM','RO_SEVERE','RO_ACCENTUATED') THEN
39: hr_utility.set_message(800, 'HR_520018_INVALID_CATEGORY');
40: hr_utility.set_message_token('DISABILITY_CATEGORY', l_lookup_codelist);
41: hr_utility.raise_error;
42: END IF;
43: hr_utility.set_location('Leaving : '||l_proc,20);
44: end check_ro_disability;
37:
38: IF p_category not in ('RO_SLIGHT','RO_MEDIUM','RO_SEVERE','RO_ACCENTUATED') THEN
39: hr_utility.set_message(800, 'HR_520018_INVALID_CATEGORY');
40: hr_utility.set_message_token('DISABILITY_CATEGORY', l_lookup_codelist);
41: hr_utility.raise_error;
42: END IF;
43: hr_utility.set_location('Leaving : '||l_proc,20);
44: end check_ro_disability;
45:
39: hr_utility.set_message(800, 'HR_520018_INVALID_CATEGORY');
40: hr_utility.set_message_token('DISABILITY_CATEGORY', l_lookup_codelist);
41: hr_utility.raise_error;
42: END IF;
43: hr_utility.set_location('Leaving : '||l_proc,20);
44: end check_ro_disability;
45:
46: END per_ro_disability;