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

Line 20: hr_utility.set_location('per_parent_spines_pkg.chk_unique_name',1);

16: and business_group_id + 0 = p_bgroup_id;
17: --
18: begin
19: --
20: hr_utility.set_location('per_parent_spines_pkg.chk_unique_name',1);
21: --
22: open c1;
23: --
24: fetch c1 into l_exists;

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

23: --
24: fetch c1 into l_exists;
25: --
26: IF c1%found THEN
27: hr_utility.set_message(801, 'PER_7920_PAR_SPN_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_7920_PAR_SPN_EXISTS');
28: close c1;
29: hr_utility.raise_error;
30: END IF;
31: --
32: close c1;
33:

Line 60: hr_utility.set_location('per_parent_spines_pkg.stb_del_validation',1);

56: where parent_spine_id = p_pspine_id;
57: --
58: begin
59: --
60: hr_utility.set_location('per_parent_spines_pkg.stb_del_validation',1);
61: --
62: open c2;
63: --
64: fetch c2 into l_exists1;

Line 67: hr_utility.set_message(801, 'PER_7921_DEL_PAR_SPN_POINT');

63: --
64: fetch c2 into l_exists1;
65: --
66: IF c2%found THEN
67: hr_utility.set_message(801, 'PER_7921_DEL_PAR_SPN_POINT');
68: close c2;
69: hr_utility.raise_error;
70: END IF;
71: --

Line 69: hr_utility.raise_error;

65: --
66: IF c2%found THEN
67: hr_utility.set_message(801, 'PER_7921_DEL_PAR_SPN_POINT');
68: close c2;
69: hr_utility.raise_error;
70: END IF;
71: --
72: close c2;
73: --

Line 74: hr_utility.set_location('per_parent_spines_pkg.stb_del_validation',2);

70: END IF;
71: --
72: close c2;
73: --
74: hr_utility.set_location('per_parent_spines_pkg.stb_del_validation',2);
75: --
76: open c3;
77: --
78: fetch c3 into l_exists2;

Line 81: hr_utility.set_message(801, 'PER_7922_DEL_PAR_SPN_GRDSPN');

77: --
78: fetch c3 into l_exists2;
79: --
80: IF c3%found THEN
81: hr_utility.set_message(801, 'PER_7922_DEL_PAR_SPN_GRDSPN');
82: close c3;
83: hr_utility.raise_error;
84: END IF;
85: --

Line 83: hr_utility.raise_error;

79: --
80: IF c3%found THEN
81: hr_utility.set_message(801, 'PER_7922_DEL_PAR_SPN_GRDSPN');
82: close c3;
83: hr_utility.raise_error;
84: END IF;
85: --
86: close c3;
87: --

Line 88: hr_utility.set_location('per_parent_spines_pkg.stb_del_validation',3);

84: END IF;
85: --
86: close c3;
87: --
88: hr_utility.set_location('per_parent_spines_pkg.stb_del_validation',3);
89: --
90: open c4;
91: --
92: fetch c4 into l_exists3;

Line 95: hr_utility.set_message(801, 'PER_7923_DEL_PAR_SPN_RATE');

91: --
92: fetch c4 into l_exists3;
93: --
94: IF c4%found THEN
95: hr_utility.set_message(801, 'PER_7923_DEL_PAR_SPN_RATE');
96: close c4;
97: hr_utility.raise_error;
98: END IF;
99: --

Line 97: hr_utility.raise_error;

93: --
94: IF c4%found THEN
95: hr_utility.set_message(801, 'PER_7923_DEL_PAR_SPN_RATE');
96: close c4;
97: hr_utility.raise_error;
98: END IF;
99: --
100: close c4;
101: --

Line 114: hr_utility.set_location('per_parent_spines_pkg.get_id',1);

110: from sys.dual;
111: --
112: begin
113: --
114: hr_utility.set_location('per_parent_spines_pkg.get_id',1);
115: --
116: open c5;
117: --
118: fetch c5 into p_pspine_id;

Line 137: hr_utility.set_location('per_parent_spines_pkg.get_name',1);

133: and lookup_code = p_incp;
134: --
135: begin
136: --
137: hr_utility.set_location('per_parent_spines_pkg.get_name',1);
138: --
139: open c6;
140: --
141: fetch c6 into p_dinc;