2373: close csr_get_asg;
2374: --
2375: -- The primary key is invalid therefore we must error
2376: --
2377: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
2378: hr_utility.raise_error;
2379: --
2380: else
2381: close csr_get_asg;
2374: --
2375: -- The primary key is invalid therefore we must error
2376: --
2377: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
2378: hr_utility.raise_error;
2379: --
2380: else
2381: close csr_get_asg;
2382: end if;
2402: close csr_get_pgp;
2403: --
2404: -- The primary key is invalid therefore we must error
2405: --
2406: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
2407: hr_utility.raise_error;
2408: --
2409: else
2410: close csr_get_pgp;
2403: --
2404: -- The primary key is invalid therefore we must error
2405: --
2406: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
2407: hr_utility.raise_error;
2408: --
2409: else
2410: close csr_get_pgp;
2411: end if;
2431: close csr_get_scl;
2432: --
2433: -- The primary key is invalid therefore we must error
2434: --
2435: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
2436: hr_utility.raise_error;
2437: --
2438: else
2439: close csr_get_scl;
2432: --
2433: -- The primary key is invalid therefore we must error
2434: --
2435: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
2436: hr_utility.raise_error;
2437: --
2438: else
2439: close csr_get_scl;
2440: end if;