DBA Data[Home] [Help]

APPS.HXC_ALIAS_TYPE_COMP_API dependencies on HR_UTILITY

Line 7: g_debug boolean := hr_utility.debug_enabled;

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

Line 31: g_debug:=hr_utility.debug_enabled;

27: l_alias_type_component_id hxc_alias_type_components.alias_type_component_id%TYPE;
28: l_object_version_number hxc_alias_type_components.object_version_number%TYPE;
29:
30: begin
31: g_debug:=hr_utility.debug_enabled;
32: if g_debug then
33: l_proc := g_package||'create_alias_type_comp';
34: hr_utility.set_location('Entering:'|| l_proc, 10);
35: end if;

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

30: begin
31: g_debug:=hr_utility.debug_enabled;
32: if g_debug then
33: l_proc := g_package||'create_alias_type_comp';
34: hr_utility.set_location('Entering:'|| l_proc, 10);
35: end if;
36: --
37: -- Issue a savepoint
38: --

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

107: p_object_version_number := l_object_version_number;
108:
109: --
110: if g_debug then
111: hr_utility.set_location(' Leaving:'||l_proc, 70);
112: end if;
113: exception
114: when hr_api.validate_enabled then
115: --

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

125: p_alias_type_component_id:= null;
126: p_object_version_number := null;
127:
128: if g_debug then
129: hr_utility.set_location(' Leaving:'||l_proc, 80);
130: end if;
131: when others then
132: --
133: -- A validation or unexpected error has occured

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

133: -- A validation or unexpected error has occured
134: --
135: rollback to create_alias_type_comp;
136: if g_debug then
137: hr_utility.set_location(' Leaving:'||l_proc, 90);
138: end if;
139: raise;
140: end create_alias_type_comp;
141: --

Line 165: g_debug:=hr_utility.debug_enabled;

161: l_proc varchar2(72);
162: l_object_version_number hxc_alias_type_components.object_version_number%TYPE := p_object_version_number;
163:
164: begin
165: g_debug:=hr_utility.debug_enabled;
166: if g_debug then
167: l_proc:= g_package||'update_alias_type_comp';
168: hr_utility.set_location('Entering:'|| l_proc, 10);
169: end if;

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

164: begin
165: g_debug:=hr_utility.debug_enabled;
166: if g_debug then
167: l_proc:= g_package||'update_alias_type_comp';
168: hr_utility.set_location('Entering:'|| l_proc, 10);
169: end if;
170: --
171: -- Issue a savepoint
172: --

Line 197: hr_utility.trace('After Before User Hook');

193: (p_module_name => 'update_alias_type_comp'
194: ,p_hook_type => 'BP'
195: );
196: if g_debug then
197: hr_utility.trace('After Before User Hook');
198: end if;
199: end;
200: --
201: -- Validation in addition to Row Handlers

Line 207: hr_utility.trace('Before calling Row Handler');

203: --
204: -- Process Logic
205: --
206: if g_debug then
207: hr_utility.trace('Before calling Row Handler');
208: end if;
209: hxc_atc_upd.upd (
210: p_component_name => p_component_name
211: ,p_component_type => p_component_type

Line 218: hr_utility.trace('After Calling Row Handler');

214: ,p_alias_type_component_id => p_alias_type_component_id
215: ,p_object_version_number => l_object_version_number
216: );
217: if g_debug then
218: hr_utility.trace('After Calling Row Handler');
219: end if;
220: --
221: -- Call After Process User Hook
222: --

Line 225: hr_utility.trace('Before After user hook');

221: -- Call After Process User Hook
222: --
223: begin
224: if g_debug then
225: hr_utility.trace('Before After user hook');
226: end if;
227: hxc_alias_type_comp_bk1.update_alias_type_comp_a
228: (p_component_name => p_component_name
229: ,p_component_type => p_component_type

Line 242: hr_utility.trace('After After user hook');

238: (p_module_name => 'update_alias_type_comp'
239: ,p_hook_type => 'AP'
240: );
241: if g_debug then
242: hr_utility.trace('After After user hook');
243: end if;
244: end;
245: --
246: -- When in validation only mode raise the Validate_Enabled exception

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

254: p_object_version_number := l_object_version_number;
255:
256: --
257: if g_debug then
258: hr_utility.set_location(' Leaving:'||l_proc, 70);
259: end if;
260: exception
261: when hr_api.validate_enabled then
262: --

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

271: --
272: p_object_version_number := null;
273:
274: if g_debug then
275: hr_utility.set_location(' Leaving:'||l_proc, 80);
276: end if;
277: when others then
278: --
279: -- A validation or unexpected error has occured

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

279: -- A validation or unexpected error has occured
280: --
281: rollback to update_alias_type_comp;
282: if g_debug then
283: hr_utility.set_location(' Leaving:'||l_proc, 90);
284: end if;
285: raise;
286: end update_alias_type_comp;
287: --

Line 307: g_debug:=hr_utility.debug_enabled;

303: l_proc varchar2(72);
304:
305:
306: begin
307: g_debug:=hr_utility.debug_enabled;
308: if g_debug then
309: l_proc:= g_package||'delete_alias_type_comp';
310: hr_utility.set_location('Entering:'|| l_proc, 10);
311: end if;

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

306: begin
307: g_debug:=hr_utility.debug_enabled;
308: if g_debug then
309: l_proc:= g_package||'delete_alias_type_comp';
310: hr_utility.set_location('Entering:'|| l_proc, 10);
311: end if;
312: --
313: -- Issue a savepoint
314: --

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

368: -- Set all output arguments
369: --
370: --
371: if g_debug then
372: hr_utility.set_location(' Leaving:'||l_proc, 70);
373: end if;
374: exception
375: when hr_api.validate_enabled then
376: --

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

384: -- when validation only mode is being used.)
385: --
386:
387: if g_debug then
388: hr_utility.set_location(' Leaving:'||l_proc, 80);
389: end if;
390: when others then
391: --
392: -- A validation or unexpected error has occured

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

392: -- A validation or unexpected error has occured
393: --
394: rollback to delete_alias_type_comp;
395: if g_debug then
396: hr_utility.set_location(' Leaving:'||l_proc, 90);
397: end if;
398: raise;
399: end delete_alias_type_comp;
400: --