DBA Data[Home] [Help]

APPS.HXC_MAPPING_COMP_USAGE_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_mapping_comp_usage_api.';
7: g_debug boolean := hr_utility.debug_enabled;
8: --
9: -- ----------------------------------------------------------------------------
10: -- |------------------------< create_mapping_comp_usage>----------------------|
11: -- ----------------------------------------------------------------------------

Line 28: g_debug := hr_utility.debug_enabled;

24: l_object_version_number hxc_mapping_comp_usages.object_version_number%TYPE;
25: l_mapping_comp_usage_id hxc_mapping_comp_usages.mapping_comp_usage_id%TYPE;
26: --
27: begin
28: g_debug := hr_utility.debug_enabled;
29: --
30:
31: --
32: if g_debug then

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

30:
31: --
32: if g_debug then
33: l_proc := g_package||' create_mapping_comp_usage';
34: hr_utility.set_location('Entering:'|| l_proc, 10);
35: end if;
36: --
37: -- Issue a savepoint if operating in validation only mode
38: --

Line 42: hr_utility.set_location(l_proc, 20);

38: --
39: savepoint create_mapping_comp_usage;
40: --
41: if g_debug then
42: hr_utility.set_location(l_proc, 20);
43: end if;
44: --
45: -- Call Before Process User Hook
46: --

Line 63: hr_utility.set_location(l_proc, 30);

59: );
60: end;
61: --
62: if g_debug then
63: hr_utility.set_location(l_proc, 30);
64: end if;
65: --
66: -- Process Logic
67: --

Line 70: hr_utility.set_location(l_proc, 40);

66: -- Process Logic
67: --
68: --
69: if g_debug then
70: hr_utility.set_location(l_proc, 40);
71: end if;
72: --
73: -- call row handler
74: --

Line 82: hr_utility.set_location(l_proc, 50);

78: ,p_mapping_comp_usage_id => l_mapping_comp_usage_id
79: ,p_object_version_number => l_object_version_number );
80: --
81: if g_debug then
82: hr_utility.set_location(l_proc, 50);
83: end if;
84: --
85: -- Call After Process User Hook
86: --

Line 103: hr_utility.set_location(l_proc, 60);

99: );
100: end;
101: --
102: if g_debug then
103: hr_utility.set_location(l_proc, 60);
104: end if;
105: --
106: -- When in validation only mode raise the Validate_Enabled exception
107: --

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

109: raise hr_api.validate_enabled;
110: end if;
111: --
112: if g_debug then
113: hr_utility.set_location(' Leaving:'||l_proc, 70);
114: end if;
115: --
116: -- Set all output arguments
117: --

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

134: p_mapping_comp_usage_id := null;
135: p_object_version_number := null;
136: --
137: if g_debug then
138: hr_utility.set_location(' Leaving:'||l_proc, 80);
139: end if;
140: --
141: when others then
142: --

Line 146: hr_utility.trace('In exeception');

142: --
143: -- A validation or unexpected error has occured
144: --
145: if g_debug then
146: hr_utility.trace('In exeception');
147: end if;
148: ROLLBACK TO create_mapping_comp_usage;
149: raise;
150: --

Line 172: g_debug := hr_utility.debug_enabled;

168: l_proc varchar2(72);
169: l_object_version_number hxc_mapping_comp_usages.object_version_number%TYPE := p_object_version_number;
170: --
171: begin
172: g_debug := hr_utility.debug_enabled;
173: --
174: if g_debug then
175: l_proc := g_package||' update_mapping_comp_usage';
176: hr_utility.set_location('Entering:'|| l_proc, 10);

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

172: g_debug := hr_utility.debug_enabled;
173: --
174: if g_debug then
175: l_proc := g_package||' update_mapping_comp_usage';
176: hr_utility.set_location('Entering:'|| l_proc, 10);
177: end if;
178: --
179: -- Issue a savepoint if operating in validation only mode
180: --

Line 184: hr_utility.set_location(l_proc, 20);

180: --
181: savepoint update_mapping_comp_usage;
182: --
183: if g_debug then
184: hr_utility.set_location(l_proc, 20);
185: end if;
186: --
187: -- Call Before Process User Hook
188: --

Line 205: hr_utility.set_location(l_proc, 30);

201: );
202: end;
203: --
204: if g_debug then
205: hr_utility.set_location(l_proc, 30);
206: end if;
207: --
208: -- Process Logic
209: --

Line 219: hr_utility.set_location(l_proc, 40);

215: ,p_object_version_number => l_object_version_number );
216: --
217: --
218: if g_debug then
219: hr_utility.set_location(l_proc, 40);
220: end if;
221: --
222: -- Call After Process User Hook
223: --

Line 240: hr_utility.set_location(l_proc, 50);

236: );
237: end;
238: --
239: if g_debug then
240: hr_utility.set_location(l_proc, 50);
241: end if;
242: --
243: -- When in validation only mode raise the Validate_Enabled exception
244: --

Line 250: hr_utility.set_location(' Leaving:'||l_proc, 60);

246: raise hr_api.validate_enabled;
247: end if;
248: --
249: if g_debug then
250: hr_utility.set_location(' Leaving:'||l_proc, 60);
251: end if;
252: --
253: -- Set all output arguments
254: --

Line 273: hr_utility.set_location(' Leaving:'||l_proc, 60);

269: --
270: p_object_version_number := null;
271: --
272: if g_debug then
273: hr_utility.set_location(' Leaving:'||l_proc, 60);
274: end if;
275: --
276: when others then
277: --

Line 281: hr_utility.trace('In exeception');

277: --
278: -- A validation or unexpected error has occured
279: --
280: if g_debug then
281: hr_utility.trace('In exeception');
282: end if;
283: ROLLBACK TO update_mapping_comp_usage;
284: raise;
285: --

Line 304: g_debug := hr_utility.debug_enabled;

300: --
301: l_proc varchar2(72);
302: --
303: begin
304: g_debug := hr_utility.debug_enabled;
305: --
306: if g_debug then
307: l_proc := g_package||'delete_mapping_comp_usage';
308: hr_utility.set_location('Entering:'|| l_proc, 10);

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

304: g_debug := hr_utility.debug_enabled;
305: --
306: if g_debug then
307: l_proc := g_package||'delete_mapping_comp_usage';
308: hr_utility.set_location('Entering:'|| l_proc, 10);
309: end if;
310: --
311: -- Issue a savepoint if operating in validation only mode
312: --

Line 316: hr_utility.set_location(l_proc, 20);

312: --
313: savepoint delete_mapping_comp_usage;
314: --
315: if g_debug then
316: hr_utility.set_location(l_proc, 20);
317: end if;
318: --
319: -- Call Before Process User Hook
320: --

Line 336: hr_utility.set_location(l_proc, 30);

332: );
333: end;
334: --
335: if g_debug then
336: hr_utility.set_location(l_proc, 30);
337: end if;
338: --
339: -- Process Logic
340: --

Line 348: hr_utility.set_location(l_proc, 40);

344: ,p_object_version_number => p_object_version_number
345: );
346: --
347: if g_debug then
348: hr_utility.set_location(l_proc, 40);
349: end if;
350: --
351: -- Call After Process User Hook
352: --

Line 374: hr_utility.set_location(' Leaving:'||l_proc, 50);

370: raise hr_api.validate_enabled;
371: end if;
372: --
373: if g_debug then
374: hr_utility.set_location(' Leaving:'||l_proc, 50);
375: end if;
376: --
377: exception
378: --