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.HR_GRADE_RATE_VALUE_API dependencies on HR_UTILITY

Line 26: hr_utility.set_location('Entering:'|| l_proc, 5);

22: and p_effective_date between grr.effective_start_date
23: and grr.effective_end_date;
24: --
25: begin
26: hr_utility.set_location('Entering:'|| l_proc, 5);
27: --
28: -- Check that the Grade Rule identified is for a Grade Rate.
29: --
30: open csr_get_rate_type;

Line 37: hr_utility.set_location(l_proc, 7);

33: if csr_get_rate_type%notfound then
34: --
35: close csr_get_rate_type;
36: --
37: hr_utility.set_location(l_proc, 7);
38: --
39: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
40: hr_utility.raise_error;
41: --

Line 39: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');

35: close csr_get_rate_type;
36: --
37: hr_utility.set_location(l_proc, 7);
38: --
39: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
40: hr_utility.raise_error;
41: --
42: else
43: --

Line 40: hr_utility.raise_error;

36: --
37: hr_utility.set_location(l_proc, 7);
38: --
39: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
40: hr_utility.raise_error;
41: --
42: else
43: --
44: close csr_get_rate_type;

Line 48: hr_utility.set_location(l_proc, 8);

44: close csr_get_rate_type;
45: --
46: if l_rate_type <> 'G' then
47: --
48: hr_utility.set_location(l_proc, 8);
49: --
50: hr_utility.set_message(801, 'HR_7854_GRR_INV_NOT_G_RATE_TYP');
51: hr_utility.raise_error;
52: --

Line 50: hr_utility.set_message(801, 'HR_7854_GRR_INV_NOT_G_RATE_TYP');

46: if l_rate_type <> 'G' then
47: --
48: hr_utility.set_location(l_proc, 8);
49: --
50: hr_utility.set_message(801, 'HR_7854_GRR_INV_NOT_G_RATE_TYP');
51: hr_utility.raise_error;
52: --
53: end if;
54: end if;

Line 51: hr_utility.raise_error;

47: --
48: hr_utility.set_location(l_proc, 8);
49: --
50: hr_utility.set_message(801, 'HR_7854_GRR_INV_NOT_G_RATE_TYP');
51: hr_utility.raise_error;
52: --
53: end if;
54: end if;
55: --

Line 56: hr_utility.set_location(' Leaving:'||l_proc, 11);

52: --
53: end if;
54: end if;
55: --
56: hr_utility.set_location(' Leaving:'||l_proc, 11);
57: end;
58: --
59: -- ----------------------------------------------------------------------------
60: -- |------------------------< create_grade_rate_value >----------------------|

Line 103: hr_utility.set_location('Entering:'|| l_proc, 5);

99: -- Set l_effective_date equal to truncated version of p_effective date for
100: -- API work. Stops dates being passed to row handlers with a time portion.
101: --
102: l_effective_date := trunc(p_effective_date);
103: hr_utility.set_location('Entering:'|| l_proc, 5);
104: --
105: -- Issue a savepoint.
106: --
107: savepoint create_grade_rate_value;

Line 108: hr_utility.set_location(l_proc, 6);

104: --
105: -- Issue a savepoint.
106: --
107: savepoint create_grade_rate_value;
108: hr_utility.set_location(l_proc, 6);
109: --
110: -- Check that p_grade_id is not null as it is used in the cursor.
111: --
112: hr_api.mandatory_arg_error

Line 126: hr_utility.set_message(801, 'HR_7311_GRR_INVALID_GRADE');

122: l_sequence;
123: --
124: if csr_get_der_args%notfound then
125: close csr_get_der_args;
126: hr_utility.set_message(801, 'HR_7311_GRR_INVALID_GRADE');
127: hr_utility.raise_error;
128: end if;
129: --
130: close csr_get_der_args;

Line 127: hr_utility.raise_error;

123: --
124: if csr_get_der_args%notfound then
125: close csr_get_der_args;
126: hr_utility.set_message(801, 'HR_7311_GRR_INVALID_GRADE');
127: hr_utility.raise_error;
128: end if;
129: --
130: close csr_get_der_args;
131: --

Line 132: hr_utility.set_location(l_proc, 7);

128: end if;
129: --
130: close csr_get_der_args;
131: --
132: hr_utility.set_location(l_proc, 7);
133: --
134: -- Insert Grade Rule details.
135: hr_rate_values_api.create_rate_value(
136: p_validate => FALSE

Line 154: hr_utility.set_location(l_proc, 8);

150: ,p_effective_start_date => l_effective_start_date
151: ,p_effective_end_date => l_effective_end_date
152: );
153: --
154: hr_utility.set_location(l_proc, 8);
155: --
156: -- When in validation only mode raise the Validate_Enabled exception
157: --
158: if p_validate then

Line 169: hr_utility.set_location(' Leaving:'||l_proc, 11);

165: p_object_version_number := l_object_version_number;
166: p_effective_start_date := l_effective_start_date;
167: p_effective_end_date := l_effective_end_date;
168: --
169: hr_utility.set_location(' Leaving:'||l_proc, 11);
170: exception
171: when hr_api.validate_enabled then
172: --
173: -- As the Validate_Enabled exception has been raised

Line 242: hr_utility.set_location('Entering:'|| l_proc, 5);

238: -- Set l_effective_date equal to truncated version of p_effective_date for
239: -- API work. Stops dates being passed to row handlers with time portion.
240: --
241: l_effective_date := trunc(p_effective_date);
242: hr_utility.set_location('Entering:'|| l_proc, 5);
243: --
244: -- Issue a savepoint.
245: --
246: savepoint update_grade_rate_value;

Line 248: hr_utility.set_location(l_proc, 6);

244: -- Issue a savepoint.
245: --
246: savepoint update_grade_rate_value;
247: --
248: hr_utility.set_location(l_proc, 6);
249: --
250: check_rate_type
251: (p_grade_rule_id => p_grade_rule_id
252: ,p_effective_date => l_effective_date

Line 255: hr_utility.set_location(l_proc, 9);

251: (p_grade_rule_id => p_grade_rule_id
252: ,p_effective_date => l_effective_date
253: );
254: --
255: hr_utility.set_location(l_proc, 9);
256: --
257: --
258: l_object_version_number_temp := p_object_version_number;
259: l_object_version_number := p_object_version_number;

Line 278: hr_utility.set_location(l_proc, 8);

274: ,p_effective_start_date => l_effective_start_date
275: ,p_effective_end_date => l_effective_end_date
276: );
277: --
278: hr_utility.set_location(l_proc, 8);
279: --
280: -- When in validation only mode raise the Validate_Enabled exception
281: --
282: if p_validate then

Line 292: hr_utility.set_location(' Leaving:'||l_proc, 11);

288: p_object_version_number := l_object_version_number;
289: p_effective_start_date := l_effective_start_date;
290: p_effective_end_date := l_effective_end_date;
291: --
292: hr_utility.set_location(' Leaving:'||l_proc, 11);
293: exception
294: when hr_api.validate_enabled then
295: --
296: -- As the Validate_Enabled exception has been raised

Line 358: hr_utility.set_location('Entering:'|| l_proc, 5);

354: -- Set l_effective_date to truncated version of p_effective_date for API work
355: -- Stops dates being passed to row handlers with time portion.
356: --
357: l_effective_date := trunc(p_effective_date);
358: hr_utility.set_location('Entering:'|| l_proc, 5);
359: --
360: -- Issue a savepoint.
361: --
362: savepoint delete_grade_rate_value;

Line 364: hr_utility.set_location(l_proc, 6);

360: -- Issue a savepoint.
361: --
362: savepoint delete_grade_rate_value;
363: --
364: hr_utility.set_location(l_proc, 6);
365: --
366: -- Check that the Grade Rule identified is for a Grade Rate.
367: --
368: check_rate_type

Line 389: hr_utility.set_location(l_proc, 8);

385: ,p_effective_start_date => l_effective_start_date
386: ,p_effective_end_date => l_effective_end_date
387: );
388: --
389: hr_utility.set_location(l_proc, 8);
390: --
391: -- When in validation only mode raise the Validate_Enabled exception
392: --
393: if p_validate then

Line 404: hr_utility.set_location(' Leaving:'||l_proc, 11);

400: p_object_version_number := l_object_version_number;
401: p_effective_start_date := l_effective_start_date;
402: p_effective_end_date := l_effective_end_date;
403: --
404: hr_utility.set_location(' Leaving:'||l_proc, 11);
405: exception
406: when hr_api.validate_enabled then
407: --
408: -- As the Validate_Enabled exception has been raised