DBA Data[Home] [Help]

APPS.PQH_RATE_MATRIX_RATES_API dependencies on HR_UTILITY

Line 40: hr_utility.set_location('Entering:'|| l_proc, 10);

36: l_effective_end_date pqh_rate_matrix_rates_f.effective_end_date%TYPE;
37: l_proc varchar2(72) := g_package||'create_rate_matrix_rate';
38: --
39: begin
40: hr_utility.set_location('Entering:'|| l_proc, 10);
41: --
42: -- Issue a savepoint
43: --
44: savepoint create_rate_matrix_rate;

Line 143: hr_utility.set_location(' Leaving:'||l_proc, 70);

139: p_effective_start_date := l_effective_start_date;
140: p_effective_end_date := l_effective_end_date;
141: p_object_version_number := l_object_version_number;
142: --
143: hr_utility.set_location(' Leaving:'||l_proc, 70);
144: exception
145: when hr_api.validate_enabled then
146: --
147: -- As the Validate_Enabled exception has been raised

Line 161: hr_utility.set_location(' Leaving:'||l_proc, 80);

157: p_effective_start_date := null;
158: p_effective_end_date := null;
159: p_object_version_number := null;
160:
161: hr_utility.set_location(' Leaving:'||l_proc, 80);
162: when others then
163: --
164: -- A validation or unexpected error has occured
165: --

Line 176: hr_utility.set_location(' Leaving:'||l_proc, 90);

172: p_effective_start_date := null;
173: p_effective_end_date := null;
174: p_object_version_number := null;
175:
176: hr_utility.set_location(' Leaving:'||l_proc, 90);
177: raise;
178: end create_rate_matrix_rate;
179: --
180: -- ----------------------------------------------------------------------------

Line 211: hr_utility.set_location('Entering:'|| l_proc, 10);

207: l_effective_start_date pqh_rate_matrix_rates_f.effective_start_date%TYPE;
208: l_effective_end_date pqh_rate_matrix_rates_f.effective_end_date%TYPE;
209: l_proc varchar2(72) := g_package||'update_rate_matrix_rate';
210: begin
211: hr_utility.set_location('Entering:'|| l_proc, 10);
212: --
213: -- Issue a savepoint
214: --
215: savepoint update_rate_matrix_rate;

Line 319: hr_utility.set_location(' Leaving:'||l_proc, 70);

315: p_object_version_number := l_object_version_number;
316: p_effective_start_date := l_effective_start_date;
317: p_effective_end_date := l_effective_end_date;
318: --
319: hr_utility.set_location(' Leaving:'||l_proc, 70);
320: exception
321: when hr_api.validate_enabled then
322: --
323: -- As the Validate_Enabled exception has been raised

Line 335: hr_utility.set_location(' Leaving:'||l_proc, 80);

331: --
332: p_object_version_number := l_object_version_number;
333: p_effective_start_date := null;
334: p_effective_end_date := null;
335: hr_utility.set_location(' Leaving:'||l_proc, 80);
336: when others then
337: --
338: -- A validation or unexpected error has occured
339: --

Line 349: hr_utility.set_location(' Leaving:'||l_proc, 90);

345: p_object_version_number := l_object_version_number;
346: p_effective_start_date := null;
347: p_effective_end_date := null;
348: --
349: hr_utility.set_location(' Leaving:'||l_proc, 90);
350: raise;
351: end update_rate_matrix_rate;
352: --
353: -- ----------------------------------------------------------------------------

Line 375: hr_utility.set_location('Entering:'|| l_proc, 10);

371: l_effective_start_date pqh_rate_matrix_rates_f.effective_start_date%TYPE;
372: l_effective_end_date pqh_rate_matrix_rates_f.effective_end_date%TYPE;
373: l_proc varchar2(72) := g_package||'delete_rate_matrix_rate';
374: begin
375: hr_utility.set_location('Entering:'|| l_proc, 10);
376: --
377: -- Issue a savepoint
378: --
379: savepoint delete_rate_matrix_rate;

Line 455: hr_utility.set_location(' Leaving:'||l_proc, 70);

451: --
452: -- Set all IN OUT and OUT parameters with out values
453: --
454: --
455: hr_utility.set_location(' Leaving:'||l_proc, 70);
456: exception
457: when hr_api.validate_enabled then
458: --
459: -- As the Validate_Enabled exception has been raised

Line 470: hr_utility.set_location(' Leaving:'||l_proc, 80);

466: -- when validation only mode is being used.)
467: --
468: p_effective_start_date := null;
469: p_effective_end_date := null;
470: hr_utility.set_location(' Leaving:'||l_proc, 80);
471: when others then
472: --
473: -- A validation or unexpected error has occured
474: --

Line 483: hr_utility.set_location(' Leaving:'||l_proc, 90);

479: --
480: p_object_version_number := l_object_version_number;
481: p_effective_start_date := null;
482: p_effective_end_date := null;
483: hr_utility.set_location(' Leaving:'||l_proc, 90);
484: raise;
485: end delete_rate_matrix_rate;
486: --
487: end PQH_RATE_MATRIX_RATES_API;