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.

[Home] [Help]

APPS.HR_PAY_SCALE_VALUE_API dependencies on HR_UTILITY

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

32: and p_effective_date between grr.effective_start_date
33: and grr.effective_end_date;
34: --
35: begin
36: hr_utility.set_location('Entering:'|| l_proc, 5);
37: --
38: -- Check that the Grade Rule identified is for a Grade Rate.
39: --
40: open csr_get_rate_type;

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

43: if csr_get_rate_type%notfound then
44: --
45: close csr_get_rate_type;
46: --
47: hr_utility.set_location(l_proc, 7);
48: --
49: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
50: hr_utility.raise_error;
51: --

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

45: close csr_get_rate_type;
46: --
47: hr_utility.set_location(l_proc, 7);
48: --
49: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
50: hr_utility.raise_error;
51: --
52: else
53: --

Line 50: hr_utility.raise_error;

46: --
47: hr_utility.set_location(l_proc, 7);
48: --
49: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
50: hr_utility.raise_error;
51: --
52: else
53: --
54: close csr_get_rate_type;

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

54: close csr_get_rate_type;
55: --
56: if l_rate_type <> 'SP' then
57: --
58: hr_utility.set_location(l_proc, 8);
59: --
60: hr_utility.set_message(801, 'HR_7855_GRR_INV_NOT_SP_RATE_TY');
61: hr_utility.raise_error;
62: --

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

56: if l_rate_type <> 'SP' then
57: --
58: hr_utility.set_location(l_proc, 8);
59: --
60: hr_utility.set_message(801, 'HR_7855_GRR_INV_NOT_SP_RATE_TY');
61: hr_utility.raise_error;
62: --
63: end if;
64: end if;

Line 61: hr_utility.raise_error;

57: --
58: hr_utility.set_location(l_proc, 8);
59: --
60: hr_utility.set_message(801, 'HR_7855_GRR_INV_NOT_SP_RATE_TY');
61: hr_utility.raise_error;
62: --
63: end if;
64: end if;
65: --

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

62: --
63: end if;
64: end if;
65: --
66: hr_utility.set_location(' Leaving:'||l_proc, 11);
67: end;
68: --
69: -- ----------------------------------------------------------------------------
70: -- |-------------------------< create_pay_scale_value >-----------------------|

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

105: -- Set l_effective_date equal to truncated version of p_effective_date for
106: -- API work. Stops dates being passed to row handlers with time portion.
107: --
108: l_effective_date := trunc(p_effective_date);
109: hr_utility.set_location('Entering:'|| l_proc, 5);
110: --
111: -- Issue a savepoint.
112: --
113: savepoint create_pay_scale_value;

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

110: --
111: -- Issue a savepoint.
112: --
113: savepoint create_pay_scale_value;
114: hr_utility.set_location(l_proc, 6);
115: --
116: -- Check that p_spinal_point_id is not null as it is used in the cursor.
117: --
118: hr_api.mandatory_arg_error

Line 132: hr_utility.set_message(801, 'HR_7312_GRR_INVALID_SPNL_POINT');

128: l_sequence;
129: --
130: if csr_get_der_args%notfound then
131: close csr_get_der_args;
132: hr_utility.set_message(801, 'HR_7312_GRR_INVALID_SPNL_POINT');
133: hr_utility.raise_error;
134: end if;
135: --
136: close csr_get_der_args;

Line 133: hr_utility.raise_error;

129: --
130: if csr_get_der_args%notfound then
131: close csr_get_der_args;
132: hr_utility.set_message(801, 'HR_7312_GRR_INVALID_SPNL_POINT');
133: hr_utility.raise_error;
134: end if;
135: --
136: close csr_get_der_args;
137: --

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

136: close csr_get_der_args;
137: --
138: --
139: --
140: hr_utility.set_location(l_proc, 7);
141: --
142: -- Insert Progression Point Value.
143: --
144: hr_rate_values_api.create_rate_value(

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

155: ,p_effective_start_date => l_effective_start_date
156: ,p_effective_end_date => l_effective_end_date
157: );
158: --
159: hr_utility.set_location(l_proc, 8);
160: --
161: -- When in validation only mode raise the Validate_Enabled exception
162: --
163: if p_validate then

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

170: p_object_version_number := l_object_version_number;
171: p_effective_start_date := l_effective_start_date;
172: p_effective_end_date := l_effective_end_date;
173: --
174: hr_utility.set_location(' Leaving:'||l_proc, 11);
175: exception
176: when hr_api.validate_enabled then
177: --
178: -- As the Validate_Enabled exception has been raised

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

244: -- Set l_effective_date equal to truncated version of p_effective_date for
245: -- API work. Stops dates being passed to row handlers with time portion.
246: --
247: l_effective_date := trunc(p_effective_date);
248: hr_utility.set_location('Entering:'|| l_proc, 5);
249: --
250: -- Issue a savepoint.
251: --
252: savepoint update_pay_scale_value;

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

250: -- Issue a savepoint.
251: --
252: savepoint update_pay_scale_value;
253: --
254: hr_utility.set_location(l_proc, 6);
255: --
256: -- Check that the Grade Rule identified is for a Pay Scale.
257: --
258: --

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

260: (p_grade_rule_id => p_grade_rule_id
261: ,p_effective_date => l_effective_date
262: );
263: --
264: hr_utility.set_location(l_proc, 9);
265: --
266: --
267: l_object_version_number_temp := p_object_version_number;
268: l_object_version_number := p_object_version_number;

Line 287: hr_utility.set_location(l_proc, 10);

283: ,p_effective_end_date => l_effective_end_date
284: );
285: --
286: --
287: hr_utility.set_location(l_proc, 10);
288: --
289: -- When in validation only mode raise the Validate_Enabled exception
290: --
291: if p_validate then

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

297: p_object_version_number := l_object_version_number;
298: p_effective_start_date := l_effective_start_date;
299: p_effective_end_date := l_effective_end_date;
300: --
301: hr_utility.set_location(' Leaving:'||l_proc, 11);
302: exception
303: when hr_api.validate_enabled then
304: --
305: -- As the Validate_Enabled exception has been raised

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

364: -- Set l_effective_date equal to truncated version of p_effective_date for
365: -- API work. Stops dates being passed to row handlers with time portion.
366: --
367: l_effective_date := trunc(p_effective_date);
368: hr_utility.set_location('Entering:'|| l_proc, 5);
369: --
370: -- Issue a savepoint.
371: --
372: savepoint delete_pay_scale_value;

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

370: -- Issue a savepoint.
371: --
372: savepoint delete_pay_scale_value;
373: --
374: hr_utility.set_location(l_proc, 6);
375: --
376: -- Check that the Grade Rule identified is for a Pay Scale.
377: --
378: --

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

380: (p_grade_rule_id => p_grade_rule_id
381: ,p_effective_date => l_effective_date
382: );
383: --
384: hr_utility.set_location(l_proc, 9);
385: --
386: --
387: l_object_version_number_temp := p_object_version_number;
388: l_object_version_number := p_object_version_number;

Line 401: hr_utility.set_location(l_proc, 10);

397: ,p_effective_start_date => l_effective_start_date
398: ,p_effective_end_date => l_effective_end_date
399: );
400: --
401: hr_utility.set_location(l_proc, 10);
402: --
403: -- When in validation only mode raise the Validate_Enabled exception
404: --
405: if p_validate then

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

409: p_object_version_number := l_object_version_number;
410: p_effective_start_date := l_effective_start_date;
411: p_effective_end_date := l_effective_end_date;
412: --
413: hr_utility.set_location(' Leaving:'||l_proc, 11);
414: exception
415: when hr_api.validate_enabled then
416: --
417: -- As the Validate_Enabled exception has been raised