DBA Data[Home] [Help]

APPS.PER_QP_REPORTS dependencies on HR_UTILITY

Line 28: hr_utility.set_location('per_qp_reports.get_formula_type',1);

24: from ff_formula_types
25: where upper(formula_type_name) = 'QUICKPAINT';
26: --
27: begin
28: hr_utility.set_location('per_qp_reports.get_formula_type',1);
29: open c;
30: fetch c into l_formula_type_id;
31: if c%notfound then
32: close c;

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

29: open c;
30: fetch c into l_formula_type_id;
31: if c%notfound then
32: close c;
33: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
34: hr_utility.set_message_token('PROCEDURE','GET_FORMULA_TYPE');
35: hr_utility.set_message_token('STEP','1');
36: hr_utility.raise_error;
37: end if;

Line 34: hr_utility.set_message_token('PROCEDURE','GET_FORMULA_TYPE');

30: fetch c into l_formula_type_id;
31: if c%notfound then
32: close c;
33: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
34: hr_utility.set_message_token('PROCEDURE','GET_FORMULA_TYPE');
35: hr_utility.set_message_token('STEP','1');
36: hr_utility.raise_error;
37: end if;
38: close c;

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

31: if c%notfound then
32: close c;
33: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
34: hr_utility.set_message_token('PROCEDURE','GET_FORMULA_TYPE');
35: hr_utility.set_message_token('STEP','1');
36: hr_utility.raise_error;
37: end if;
38: close c;
39: return(l_formula_type_id);

Line 36: hr_utility.raise_error;

32: close c;
33: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
34: hr_utility.set_message_token('PROCEDURE','GET_FORMULA_TYPE');
35: hr_utility.set_message_token('STEP','1');
36: hr_utility.raise_error;
37: end if;
38: close c;
39: return(l_formula_type_id);
40: end get_formula_type;

Line 49: hr_utility.set_location('per_qp_reports.get_sequence_id',1);

45: select ff_qp_reports_s.nextval
46: from sys.dual;
47: --
48: begin
49: hr_utility.set_location('per_qp_reports.get_sequence_id',1);
50: open c;
51: fetch c into l_sequence;
52: close c;
53: return(l_sequence);

Line 71: hr_utility.set_location('per_qp_reports.check_unique_name',1);

67: nvl(p_business_group_id, 0)
68: and nvl(legislation_code, nvl(p_legislation_code, ' ')) =
69: nvl(p_legislation_code, ' ');
70: begin
71: hr_utility.set_location('per_qp_reports.check_unique_name',1);
72: open c;
73: fetch c into l_exists;
74: if c%found then
75: close c;

Line 76: hr_utility.set_message(801,'FF00151_QP_REP_NAME_EXISTS');

72: open c;
73: fetch c into l_exists;
74: if c%found then
75: close c;
76: hr_utility.set_message(801,'FF00151_QP_REP_NAME_EXISTS');
77: hr_utility.raise_error;
78: end if;
79: close c;
80: end check_unique_name;

Line 77: hr_utility.raise_error;

73: fetch c into l_exists;
74: if c%found then
75: close c;
76: hr_utility.set_message(801,'FF00151_QP_REP_NAME_EXISTS');
77: hr_utility.raise_error;
78: end if;
79: close c;
80: end check_unique_name;
81: --