13: if (p_consolidation_set_id is null) then
14: open c1;
15: fetch c1 into p_consolidation_set_id;
16: if (C1%NOTFOUND) then
17: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
18: hr_utility.set_message_token('PROCEDURE','get_next_sequence');
19: end if;
20: close c1;
21: end if;
14: open c1;
15: fetch c1 into p_consolidation_set_id;
16: if (C1%NOTFOUND) then
17: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
18: hr_utility.set_message_token('PROCEDURE','get_next_sequence');
19: end if;
20: close c1;
21: end if;
22: --
19: end if;
20: close c1;
21: end if;
22: --
23: hr_utility.set_location('PER_JOBS_PKG.get_next_sequence', 1);
24: --
25: end get_next_sequence;
26: --
27: PROCEDURE check_unique_name(p_consolidation_set_name in varchar2,
48: fetch csr_name into g_dummy_number;
49: consolidation_exists := csr_name%FOUND;
50: close csr_name;
51: if consolidation_exists then
52: hr_utility.set_message (801,'HR_6395_SETUP_SET_EXISTS');
53: hr_utility.raise_error;
54: end if;
55: --
56: end check_unique_name;
49: consolidation_exists := csr_name%FOUND;
50: close csr_name;
51: if consolidation_exists then
52: hr_utility.set_message (801,'HR_6395_SETUP_SET_EXISTS');
53: hr_utility.raise_error;
54: end if;
55: --
56: end check_unique_name;
57: --
82: payroll_exists := csr_pay%FOUND;
83: close csr_pay;
84: --
85: if payroll_exists then
86: hr_utility.set_message (801,'HR_6396_SETUP_SET_FOR_PAYROLL');
87: hr_utility.raise_error;
88: end if;
89: --
90: open csr_payact;
83: close csr_pay;
84: --
85: if payroll_exists then
86: hr_utility.set_message (801,'HR_6396_SETUP_SET_FOR_PAYROLL');
87: hr_utility.raise_error;
88: end if;
89: --
90: open csr_payact;
91: fetch csr_payact into g_dummy_number;
92: pay_action_exists := csr_payact%FOUND;
93: close csr_payact;
94: --
95: if pay_action_exists then
96: hr_utility.set_message (801,'HR_6397_SETUP_SET_ACTION_EXIST');
97: hr_utility.raise_error;
98: end if;
99: --
100: end check_delete;
93: close csr_payact;
94: --
95: if pay_action_exists then
96: hr_utility.set_message (801,'HR_6397_SETUP_SET_ACTION_EXIST');
97: hr_utility.raise_error;
98: end if;
99: --
100: end check_delete;
101: --