DBA Data[Home] [Help]

APPS.HR_NAME_FORMAT_API dependencies on HR_UTILITY

Line 7: g_debug boolean := hr_utility.debug_enabled;

3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' hr_name_format_api.';
7: g_debug boolean := hr_utility.debug_enabled;
8: --
9: -- ----------------------------------------------------------------------------
10: -- |--------------------------< create_name_format >--------------------------|
11: -- ----------------------------------------------------------------------------

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

27: l_object_version_number hr_name_formats.object_version_number%TYPE;
28: l_effective_date date;
29: l_proc varchar2(72) := g_package||'create_name_format';
30: begin
31: hr_utility.set_location('Entering:'|| l_proc, 10);
32: --
33: -- Issue a savepoint
34: --
35: savepoint create_name_format;

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

99: --
100: p_name_format_id := l_name_format_id;
101: p_object_version_number := l_object_version_number;
102: --
103: hr_utility.set_location(' Leaving:'||l_proc, 70);
104: exception
105: when hr_api.validate_enabled then
106: --
107: -- As the Validate_Enabled exception has been raised

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

115: --
116: p_name_format_id := null;
117: p_object_version_number := null;
118:
119: hr_utility.set_location(' Leaving:'||l_proc, 80);
120: when others then
121: --
122: -- A validation or unexpected error has occured
123: --

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

127: --
128: p_name_format_id := null;
129: p_object_version_number := null;
130: --
131: hr_utility.set_location(' Leaving:'||l_proc, 90);
132: raise;
133: end create_name_format;
134: --
135: -- ----------------------------------------------------------------------------

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

149: l_object_version_number hr_name_formats.object_version_number%TYPE;
150: l_effective_date date;
151: l_proc varchar2(72) := g_package||'update_name_format';
152: begin
153: hr_utility.set_location('Entering:'|| l_proc, 10);
154: --
155: -- Issue a savepoint
156: --
157: savepoint update_name_format;

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

214: -- Set all OUT parameters with out values
215: --
216: p_object_version_number := l_object_version_number;
217: --
218: hr_utility.set_location(' Leaving:'||l_proc, 70);
219: exception
220: when hr_api.validate_enabled then
221: --
222: -- As the Validate_Enabled exception has been raised

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

223: -- we must rollback to the savepoint
224: --
225: rollback to update_name_format;
226:
227: hr_utility.set_location(' Leaving:'||l_proc, 80);
228:
229: end update_name_format;
230: --
231: -- ----------------------------------------------------------------------------

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

243: l_object_version_number hr_name_formats.object_version_number%TYPE;
244: l_effective_date date;
245: l_proc varchar2(72) := g_package||'delete_name_format';
246: begin
247: hr_utility.set_location('Entering:'|| l_proc, 10);
248: --
249: -- Issue a savepoint
250: --
251: savepoint delete_name_format;

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

298: -- Set all OUT parameters with out values
299: --
300: p_object_version_number := l_object_version_number;
301: --
302: hr_utility.set_location(' Leaving:'||l_proc, 70);
303: exception
304: when hr_api.validate_enabled then
305: --
306: -- As the Validate_Enabled exception has been raised

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

307: -- we must rollback to the savepoint
308: --
309: rollback to delete_name_format;
310:
311: hr_utility.set_location(' Leaving:'||l_proc, 80);
312:
313: end delete_name_format;
314: --
315: --