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_SPINAL_POINTS_PKG dependencies on HR_UTILITY

Line 20: hr_utility.set_location('per_spinal_points_pkg.chk_unq_point',1);

16: or (p_rowid is not null and chartorowid(p_rowid) <> rowid));
17: --
18: begin
19: --
20: hr_utility.set_location('per_spinal_points_pkg.chk_unq_point',1);
21: --
22: open c1;
23: --
24: fetch c1 into l_exists;

Line 27: hr_utility.set_message(801, 'PER_7924_POINT_EXISTS');

23: --
24: fetch c1 into l_exists;
25: --
26: IF c1%found THEN
27: hr_utility.set_message(801, 'PER_7924_POINT_EXISTS');
28: close c1;
29: hr_utility.raise_error;
30: END IF;
31: --

Line 29: hr_utility.raise_error;

25: --
26: IF c1%found THEN
27: hr_utility.set_message(801, 'PER_7924_POINT_EXISTS');
28: close c1;
29: hr_utility.raise_error;
30: END IF;
31: --
32: close c1;
33:

Line 53: hr_utility.set_location('per_spinal_points_pkg.chk_unq_seq',1);

49: or (p_rowid is not null and chartorowid(p_rowid) <> rowid));
50: --
51: begin
52: --
53: hr_utility.set_location('per_spinal_points_pkg.chk_unq_seq',1);
54: --
55: open c2;
56: --
57: fetch c2 into l_exists;

Line 60: hr_utility.set_message(801, 'PER_7925_POINT_SEQ_EXISTS');

56: --
57: fetch c2 into l_exists;
58: --
59: IF c2%found THEN
60: hr_utility.set_message(801, 'PER_7925_POINT_SEQ_EXISTS');
61: close c2;
62: hr_utility.raise_error;
63: END IF;
64: --

Line 62: hr_utility.raise_error;

58: --
59: IF c2%found THEN
60: hr_utility.set_message(801, 'PER_7925_POINT_SEQ_EXISTS');
61: close c2;
62: hr_utility.raise_error;
63: END IF;
64: --
65: close c2;
66:

Line 105: hr_utility.set_location('per_spinal_points_pkg.get_id',1);

101: from sys.dual;
102: --
103: begin
104: --
105: hr_utility.set_location('per_spinal_points_pkg.get_id',1);
106: --
107: open c3;
108: --
109: fetch c3 into p_spoint_id;

Line 138: hr_utility.set_location('per_spinal_points_pkg.stb_del_validation',1);

134: and rate_type = 'SP';
135: --
136: begin
137: --
138: hr_utility.set_location('per_spinal_points_pkg.stb_del_validation',1);
139: --
140: open c4;
141: --
142: fetch c4 into l_exists1;

Line 144: hr_utility.set_message(801, 'PER_7926_DEL_POINT_STEP');

140: open c4;
141: --
142: fetch c4 into l_exists1;
143: IF c4%found THEN
144: hr_utility.set_message(801, 'PER_7926_DEL_POINT_STEP');
145: close c4;
146: hr_utility.raise_error;
147: END IF;
148: --

Line 146: hr_utility.raise_error;

142: fetch c4 into l_exists1;
143: IF c4%found THEN
144: hr_utility.set_message(801, 'PER_7926_DEL_POINT_STEP');
145: close c4;
146: hr_utility.raise_error;
147: END IF;
148: --
149: close c4;
150: --

Line 151: hr_utility.set_location('per_spinal_points_pkg.stb_del_validation',2);

147: END IF;
148: --
149: close c4;
150: --
151: hr_utility.set_location('per_spinal_points_pkg.stb_del_validation',2);
152: --
153: open c5;
154: --
155: fetch c5 into l_exists2;

Line 157: hr_utility.set_message(801, 'PER_7927_DEL_POINT_VALUE');

153: open c5;
154: --
155: fetch c5 into l_exists2;
156: IF c5%found THEN
157: hr_utility.set_message(801, 'PER_7927_DEL_POINT_VALUE');
158: close c5;
159: hr_utility.raise_error;
160: END IF;
161: --

Line 159: hr_utility.raise_error;

155: fetch c5 into l_exists2;
156: IF c5%found THEN
157: hr_utility.set_message(801, 'PER_7927_DEL_POINT_VALUE');
158: close c5;
159: hr_utility.raise_error;
160: END IF;
161: --
162: close c5;
163: --