DBA Data[Home] [Help]

APPS.PER_JOB_REQUIREMENTS_PKG dependencies on HR_UTILITY

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

14: open c1;
15: fetch c1 into p_job_requirement_id;
16: if (C1%NOTFOUND) then
17: CLOSE C1;
18: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
19: hr_utility.set_message_token('PROCEDURE','get_next_sequence');
20: hr_utility.set_message_token('STEP','1');
21: end if;
22: close c1;

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

15: fetch c1 into p_job_requirement_id;
16: if (C1%NOTFOUND) then
17: CLOSE C1;
18: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
19: hr_utility.set_message_token('PROCEDURE','get_next_sequence');
20: hr_utility.set_message_token('STEP','1');
21: end if;
22: close c1;
23: end if;

Line 20: hr_utility.set_message_token('STEP','1');

16: if (C1%NOTFOUND) then
17: CLOSE C1;
18: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
19: hr_utility.set_message_token('PROCEDURE','get_next_sequence');
20: hr_utility.set_message_token('STEP','1');
21: end if;
22: close c1;
23: end if;
24: --

Line 25: hr_utility.set_location('PER_JOB_REQUIREMENTS_PKG.get_next_sequence', 1);

21: end if;
22: close c1;
23: end if;
24: --
25: hr_utility.set_location('PER_JOB_REQUIREMENTS_PKG.get_next_sequence', 1);
26: --
27: end get_next_sequence;
28: --
29: procedure check_unique_requirement(p_job_id in number,

Line 54: hr_utility.set_message(801,'HR_6644_JOB_REQ_DUP');

50: v_not_unique := csr_requirement%FOUND;
51: close csr_requirement;
52: --
53: if v_not_unique then
54: hr_utility.set_message(801,'HR_6644_JOB_REQ_DUP');
55: hr_utility.raise_error;
56: end if;
57: --
58: hr_utility.set_location('PER_JOB_REQUIREMENTS_PKG.check_unique_requirement', 1);

Line 55: hr_utility.raise_error;

51: close csr_requirement;
52: --
53: if v_not_unique then
54: hr_utility.set_message(801,'HR_6644_JOB_REQ_DUP');
55: hr_utility.raise_error;
56: end if;
57: --
58: hr_utility.set_location('PER_JOB_REQUIREMENTS_PKG.check_unique_requirement', 1);
59: --

Line 58: hr_utility.set_location('PER_JOB_REQUIREMENTS_PKG.check_unique_requirement', 1);

54: hr_utility.set_message(801,'HR_6644_JOB_REQ_DUP');
55: hr_utility.raise_error;
56: end if;
57: --
58: hr_utility.set_location('PER_JOB_REQUIREMENTS_PKG.check_unique_requirement', 1);
59: --
60: end check_unique_requirement;
61: --
62: END PER_JOB_REQUIREMENTS_PKG;