DBA Data[Home] [Help]

APPS.HXC_ALIAS_TYPES_API dependencies on HR_UTILITY

Line 7: g_debug boolean :=hr_utility.debug_enabled;

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

Line 27: g_debug:=hr_utility.debug_enabled;

23: l_alias_type_id hxc_alias_types.alias_type_id%TYPE;
24: l_object_version_number hxc_alias_types.object_version_number%TYPE;
25: l_proc varchar2(72);
26: begin
27: g_debug:=hr_utility.debug_enabled;
28: if g_debug then
29: l_proc := g_package||'create_alias_types';
30: hr_utility.set_location('Entering:'|| l_proc, 10);
31: end if;

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

26: begin
27: g_debug:=hr_utility.debug_enabled;
28: if g_debug then
29: l_proc := g_package||'create_alias_types';
30: hr_utility.set_location('Entering:'|| l_proc, 10);
31: end if;
32: --
33: -- Issue a savepoint
34: --

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

100: p_alias_type_id := l_alias_type_id;
101: p_object_version_number := l_object_version_number;
102: --
103: if g_debug then
104: hr_utility.set_location(' Leaving:'||l_proc, 70);
105: end if;
106: exception
107: when hr_api.validate_enabled then
108: --

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

118: p_alias_type_id := null;
119: p_object_version_number := null;
120:
121: if g_debug then
122: hr_utility.set_location(' Leaving:'||l_proc, 80);
123: end if;
124: when others then
125: --
126: -- A validation or unexpected error has occured

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

126: -- A validation or unexpected error has occured
127: --
128: rollback to create_alias_types;
129: if g_debug then
130: hr_utility.set_location(' Leaving:'||l_proc, 90);
131: end if;
132: raise;
133: end create_alias_types;
134: --

Line 153: g_debug:=hr_utility.debug_enabled;

149: --
150: l_object_version_number hxc_alias_types.object_version_number%TYPE := p_object_version_number;
151: l_proc varchar2(72);
152: begin
153: g_debug:=hr_utility.debug_enabled;
154: if g_debug then
155: l_proc := g_package||'update_alias_types';
156: hr_utility.set_location('Entering:'|| l_proc, 10);
157: end if;

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

152: begin
153: g_debug:=hr_utility.debug_enabled;
154: if g_debug then
155: l_proc := g_package||'update_alias_types';
156: hr_utility.set_location('Entering:'|| l_proc, 10);
157: end if;
158: --
159: -- Issue a savepoint
160: --

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

221: --
222: p_object_version_number := l_object_version_number;
223: --
224: if g_debug then
225: hr_utility.set_location(' Leaving:'||l_proc, 70);
226: end if;
227: exception
228: when hr_api.validate_enabled then
229: --

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

236: -- (Any key or derived arguments must be set to null
237: -- when validation only mode is being used.)
238: --
239: if g_debug then
240: hr_utility.set_location(' Leaving:'||l_proc, 80);
241: end if;
242: when others then
243: --
244: -- A validation or unexpected error has occured

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

244: -- A validation or unexpected error has occured
245: --
246: rollback to update_alias_types;
247: if g_debug then
248: hr_utility.set_location(' Leaving:'||l_proc, 90);
249: end if;
250: raise;
251: end update_alias_types;
252: --

Line 269: g_debug:=hr_utility.debug_enabled;

265: --
266:
267: l_proc varchar2(72);
268: begin
269: g_debug:=hr_utility.debug_enabled;
270: if g_debug then
271: l_proc := g_package||'delete_alias_types';
272: hr_utility.set_location('Entering:'|| l_proc, 10);
273: end if;

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

268: begin
269: g_debug:=hr_utility.debug_enabled;
270: if g_debug then
271: l_proc := g_package||'delete_alias_types';
272: hr_utility.set_location('Entering:'|| l_proc, 10);
273: end if;
274: --
275: -- Issue a savepoint
276: --

Line 281: hr_utility.trace('Before calling Before User Hook');

277: savepoint delete_alias_types;
278: --
279: -- Truncate the time portion from all IN date parameters
280: if g_debug then
281: hr_utility.trace('Before calling Before User Hook');
282: end if;
283: --
284: --
285: -- Call Before Process User Hook

Line 307: hr_utility.trace ('Before Calling Row Handler');

303: -- Process Logic
304: --
305:
306: if g_debug then
307: hr_utility.trace ('Before Calling Row Handler');
308: end if;
309: hxc_hat_del.del (
310: p_alias_type_id => p_alias_type_id,
311: p_object_version_number => p_object_version_number

Line 315: hr_utility.trace('Before calling after user hook');

311: p_object_version_number => p_object_version_number
312: );
313:
314: if g_debug then
315: hr_utility.trace('Before calling after user hook');
316: end if;
317: --
318: -- Call After Process User Hook
319: --

Line 333: hr_utility.trace('After User hook');

329: ,p_hook_type => 'AP'
330: );
331: end;
332: if g_debug then
333: hr_utility.trace('After User hook');
334: end if;
335: --
336: -- When in validation only mode raise the Validate_Enabled exception
337: --

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

343: -- Set all output arguments
344: --
345: --
346: if g_debug then
347: hr_utility.set_location(' Leaving:'||l_proc, 70);
348: end if;
349: exception
350: when hr_api.validate_enabled then
351: --

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

358: -- (Any key or derived arguments must be set to null
359: -- when validation only mode is being used.)
360: --
361: if g_debug then
362: hr_utility.set_location(' Leaving:'||l_proc, 80);
363: end if;
364: when others then
365: --
366: -- A validation or unexpected error has occured

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

366: -- A validation or unexpected error has occured
367: --
368: rollback to delete_alias_types;
369: if g_debug then
370: hr_utility.set_location(' Leaving:'||l_proc, 90);
371: end if;
372: raise;
373: end delete_alias_types;
374: --