DBA Data[Home] [Help]

APPS.PAY_CONSOLIDATION_SETS_PKG dependencies on HR_UTILITY

Line 17: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

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;

Line 18: hr_utility.set_message_token('PROCEDURE','get_next_sequence');

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: --

Line 23: hr_utility.set_location('PER_JOBS_PKG.get_next_sequence', 1);

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,

Line 52: hr_utility.set_message (801,'HR_6395_SETUP_SET_EXISTS');

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;

Line 53: hr_utility.raise_error;

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: --

Line 86: hr_utility.set_message (801,'HR_6396_SETUP_SET_FOR_PAYROLL');

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;

Line 87: hr_utility.raise_error;

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;

Line 96: hr_utility.set_message (801,'HR_6397_SETUP_SET_ACTION_EXIST');

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;

Line 97: hr_utility.raise_error;

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: --