eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_VALID_GRADES_PKG dependencies on HR_UTILITY

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

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

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

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

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

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

Line 24: hr_utility.set_location('PER_VALID_GRADES_PKG.get_grade', 1);

20: hr_utility.set_message_token('STEP','1');
21: end if;
22: close c1;
23: --
24: hr_utility.set_location('PER_VALID_GRADES_PKG.get_grade', 1);
25: --
26: end get_grade;
27: --
28: procedure get_next_sequence(p_valid_grade_id in out nocopy number) is

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

38: open c1;
39: fetch c1 into p_valid_grade_id;
40: if (C1%NOTFOUND) then
41: CLOSE C1;
42: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
43: hr_utility.set_message_token('PROCEDURE','get_next_sequence');
44: hr_utility.set_message_token('STEP','1');
45: end if;
46: close c1;

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

39: fetch c1 into p_valid_grade_id;
40: if (C1%NOTFOUND) then
41: CLOSE C1;
42: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
43: hr_utility.set_message_token('PROCEDURE','get_next_sequence');
44: hr_utility.set_message_token('STEP','1');
45: end if;
46: close c1;
47: end if;

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

40: if (C1%NOTFOUND) then
41: CLOSE C1;
42: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
43: hr_utility.set_message_token('PROCEDURE','get_next_sequence');
44: hr_utility.set_message_token('STEP','1');
45: end if;
46: close c1;
47: end if;
48: --

Line 49: hr_utility.set_location('PER_VALID_GRADES_PKG.get_next_sequence', 1);

45: end if;
46: close c1;
47: end if;
48: --
49: hr_utility.set_location('PER_VALID_GRADES_PKG.get_next_sequence', 1);
50: --
51: end get_next_sequence;
52: --
53: PROCEDURE check_unique_grade(

Line 92: hr_utility.set_message(801,'PER_7818_DEF_JOB_GRD_EXISTS');

88: v_not_unique := csr_grade%FOUND;
89: close csr_grade;
90: --
91: if v_not_unique then
92: hr_utility.set_message(801,'PER_7818_DEF_JOB_GRD_EXISTS');
93: hr_utility.raise_error;
94: end if;
95: --
96: hr_utility.set_location('PER_VALID_GRADES_PKG.check_unique_grade', 1);

Line 93: hr_utility.raise_error;

89: close csr_grade;
90: --
91: if v_not_unique then
92: hr_utility.set_message(801,'PER_7818_DEF_JOB_GRD_EXISTS');
93: hr_utility.raise_error;
94: end if;
95: --
96: hr_utility.set_location('PER_VALID_GRADES_PKG.check_unique_grade', 1);
97: --

Line 96: hr_utility.set_location('PER_VALID_GRADES_PKG.check_unique_grade', 1);

92: hr_utility.set_message(801,'PER_7818_DEF_JOB_GRD_EXISTS');
93: hr_utility.raise_error;
94: end if;
95: --
96: hr_utility.set_location('PER_VALID_GRADES_PKG.check_unique_grade', 1);
97: --
98: end check_unique_grade;
99: --
100: PROCEDURE check_date_from(p_grade_id number,

Line 122: hr_utility.set_message(801,'PER_7821_DEF_JOB_GRD_START_GRD');

118: v_date_greater := csr_grade_date%FOUND;
119: close csr_grade_date;
120: --
121: if v_date_greater then
122: hr_utility.set_message(801,'PER_7821_DEF_JOB_GRD_START_GRD');
123: hr_utility.set_message_token('DATE', g_dummy_date);
124: hr_utility.raise_error;
125: end if;
126: --

Line 123: hr_utility.set_message_token('DATE', g_dummy_date);

119: close csr_grade_date;
120: --
121: if v_date_greater then
122: hr_utility.set_message(801,'PER_7821_DEF_JOB_GRD_START_GRD');
123: hr_utility.set_message_token('DATE', g_dummy_date);
124: hr_utility.raise_error;
125: end if;
126: --
127: hr_utility.set_location('PER_VALID_GRADES_PKG.check_date_from', 1);

Line 124: hr_utility.raise_error;

120: --
121: if v_date_greater then
122: hr_utility.set_message(801,'PER_7821_DEF_JOB_GRD_START_GRD');
123: hr_utility.set_message_token('DATE', g_dummy_date);
124: hr_utility.raise_error;
125: end if;
126: --
127: hr_utility.set_location('PER_VALID_GRADES_PKG.check_date_from', 1);
128: --

Line 127: hr_utility.set_location('PER_VALID_GRADES_PKG.check_date_from', 1);

123: hr_utility.set_message_token('DATE', g_dummy_date);
124: hr_utility.raise_error;
125: end if;
126: --
127: hr_utility.set_location('PER_VALID_GRADES_PKG.check_date_from', 1);
128: --
129: end check_date_from;
130: --
131: PROCEDURE check_date_to(p_grade_id number,

Line 154: hr_utility.set_message(801,'PER_7872_DEF_GRD_POS_END_POS');

150: v_date_greater := csr_grade_date%FOUND;
151: close csr_grade_date;
152: --
153: if v_date_greater then
154: hr_utility.set_message(801,'PER_7872_DEF_GRD_POS_END_POS');
155: hr_utility.set_message_token('DATE', g_dummy_date);
156: hr_utility.raise_error;
157: end if;
158: --

Line 155: hr_utility.set_message_token('DATE', g_dummy_date);

151: close csr_grade_date;
152: --
153: if v_date_greater then
154: hr_utility.set_message(801,'PER_7872_DEF_GRD_POS_END_POS');
155: hr_utility.set_message_token('DATE', g_dummy_date);
156: hr_utility.raise_error;
157: end if;
158: --
159: hr_utility.set_location('PER_VALID_GRADES_PKG.check_date_to', 1);

Line 156: hr_utility.raise_error;

152: --
153: if v_date_greater then
154: hr_utility.set_message(801,'PER_7872_DEF_GRD_POS_END_POS');
155: hr_utility.set_message_token('DATE', g_dummy_date);
156: hr_utility.raise_error;
157: end if;
158: --
159: hr_utility.set_location('PER_VALID_GRADES_PKG.check_date_to', 1);
160: --

Line 159: hr_utility.set_location('PER_VALID_GRADES_PKG.check_date_to', 1);

155: hr_utility.set_message_token('DATE', g_dummy_date);
156: hr_utility.raise_error;
157: end if;
158: --
159: hr_utility.set_location('PER_VALID_GRADES_PKG.check_date_to', 1);
160: --
161: end check_date_to;
162: --
163: END PER_VALID_GRADES_PKG;