DBA Data[Home] [Help]

APPS.HXC_RECURRING_PERIODS_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_recurring_periods_api.';
7: g_debug boolean :=hr_utility.debug_enabled;
8: --
9: -- ----------------------------------------------------------------------------
10: -- |--------------------------< create_recurring_periods >--------------------|
11: -- ----------------------------------------------------------------------------

Line 35: g_debug:=hr_utility.debug_enabled;

31: --
32: Begin
33: --
34:
35: g_debug:=hr_utility.debug_enabled;
36: if g_debug then
37: l_proc := g_package||'create_recurring_periods';
38: hr_utility.set_location('Entering:'|| l_proc, 10);
39: end if;

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

34:
35: g_debug:=hr_utility.debug_enabled;
36: if g_debug then
37: l_proc := g_package||'create_recurring_periods';
38: hr_utility.set_location('Entering:'|| l_proc, 10);
39: end if;
40: --
41: -- Issue a savepoint
42: --

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

42: --
43: savepoint create_recurring_periods;
44: --
45: if g_debug then
46: hr_utility.set_location(l_proc, 20);
47: end if;
48: --
49: -- Truncate the time portion from all IN date parameters
50: --

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

71: );
72: end;
73: --
74: if g_debug then
75: hr_utility.set_location(l_proc, 30);
76: end if;
77: --
78:
79: --

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

85: --
86: -- Process Logic
87: --
88: if g_debug then
89: hr_utility.set_location(l_proc, 40);
90: end if;
91: --
92: -- call row handler
93: --

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

102: ,p_object_version_number => l_object_version_number
103: );
104: --
105: if g_debug then
106: hr_utility.set_location(l_proc, 50);
107: end if;
108: --
109: -- Call After Process User Hook
110: --

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

127: );
128: end;
129: --
130: if g_debug then
131: hr_utility.set_location(l_proc, 60);
132: end if;
133: --
134: --
135: -- When in validation only mode raise the Validate_Enabled exception

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

138: raise hr_api.validate_enabled;
139: end if;
140: --
141: --if g_debug then
142: --hr_utility.set_location(' Leaving:'||l_proc, 70);
143: --end if;
144: --
145: --
146: -- Set all output arguments

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

148: p_recurring_period_id := l_recurring_period_id;
149: p_object_version_number := l_object_version_number;
150: --
151: if g_debug then
152: hr_utility.set_location(' Leaving:'||l_proc, 70);
153: end if;
154: exception
155: when hr_api.validate_enabled then
156: --

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

165: --
166: p_recurring_period_id := null;
167: p_object_version_number := null;
168: if g_debug then
169: hr_utility.set_location(' Leaving:'||l_proc, 80);
170: end if;
171: when others then
172: --
173: -- A validation or unexpected error has occured

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

173: -- A validation or unexpected error has occured
174: --
175: rollback to create_recurring_periods;
176: if g_debug then
177: hr_utility.set_location(' Leaving:'||l_proc, 90);
178: end if;
179: raise;
180: --
181:

Line 208: g_debug:=hr_utility.debug_enabled;

204: l_object_version_number hxc_recurring_periods.object_version_number%TYPE := p_object_version_number;
205: --
206: Begin
207: --
208: g_debug:=hr_utility.debug_enabled;
209: if g_debug then
210: l_proc := g_package||' update_recurring_periods';
211: hr_utility.set_location('Entering:'|| l_proc, 10);
212: end if;

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

207: --
208: g_debug:=hr_utility.debug_enabled;
209: if g_debug then
210: l_proc := g_package||' update_recurring_periods';
211: hr_utility.set_location('Entering:'|| l_proc, 10);
212: end if;
213: --
214: -- Issue a savepoint if operating in validation only mode
215: --

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

215: --
216: savepoint update_recurring_periods;
217: --
218: if g_debug then
219: hr_utility.set_location(l_proc, 20);
220: end if;
221: --
222: -- Call Before Process User Hook
223: --

Line 246: --hr_utility.set_location(l_proc, 30);

242: --
243: --insert into mtemp values('out of comp_b');
244: --commit;
245: --if g_debug then
246: --hr_utility.set_location(l_proc, 30);
247: --end if;
248: --
249: -- Process Logic
250: --

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

269: --insert into mtemp values('out of hax_hac_upd');
270: --commit;
271:
272: if g_debug then
273: hr_utility.set_location(l_proc, 40);
274: end if;
275: --
276: -- Call After Process User Hook
277: --

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

297: --insert into mtemp values('out of comp_a');
298: --commit;
299:
300: if g_debug then
301: hr_utility.set_location(l_proc, 50);
302: end if;
303: --
304: -- When in validation only mode raise the Validate_Enabled exception
305: --

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

307: raise hr_api.validate_enabled;
308: end if;
309: --
310: if g_debug then
311: hr_utility.set_location(' Leaving:'||l_proc, 60);
312: end if;
313: --
314: -- Set all output arguments
315: --

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

339: --insert into mtemp values('OVN set to null');
340: --commit;
341:
342: if g_debug then
343: hr_utility.set_location(' Leaving:'||l_proc, 60);
344: end if;
345: --
346: when others then
347: --

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

348: -- A validation or unexpected error has occured
349: --
350: ROLLBACK TO update_recurring_periods;
351: if g_debug then
352: hr_utility.set_location(' Leaving:'||l_proc, 70);
353: end if;
354: raise;
355: --
356: END update_recurring_periods;

Line 374: g_debug:=hr_utility.debug_enabled;

370: l_proc varchar2(72);
371: --
372: begin
373: --
374: g_debug:=hr_utility.debug_enabled;
375: if g_debug then
376: l_proc := g_package||'delete_recurring_periods';
377: hr_utility.set_location('Entering:'|| l_proc, 10);
378: end if;

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

373: --
374: g_debug:=hr_utility.debug_enabled;
375: if g_debug then
376: l_proc := g_package||'delete_recurring_periods';
377: hr_utility.set_location('Entering:'|| l_proc, 10);
378: end if;
379: --
380: -- Issue a savepoint if operating in validation only mode
381: --

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

381: --
382: savepoint delete_recurring_periods;
383: --
384: if g_debug then
385: hr_utility.set_location(l_proc, 20);
386: end if;
387: --
388: -- Call Before Process User Hook
389: --

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

401: );
402: end;
403: --
404: if g_debug then
405: hr_utility.set_location(l_proc, 30);
406: end if;
407: --
408: -- Process Logic
409: --

Line 410: hr_utility.set_message(809, 'HXC_REC_PERIOD_DEL_NOT_ALLOWED');

406: end if;
407: --
408: -- Process Logic
409: --
410: hr_utility.set_message(809, 'HXC_REC_PERIOD_DEL_NOT_ALLOWED');
411: hr_utility.raise_error;
412:
413: /* hxc_hrp_del.del
414: (

Line 411: hr_utility.raise_error;

407: --
408: -- Process Logic
409: --
410: hr_utility.set_message(809, 'HXC_REC_PERIOD_DEL_NOT_ALLOWED');
411: hr_utility.raise_error;
412:
413: /* hxc_hrp_del.del
414: (
415: p_recurring_period_id => p_recurring_period_id

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

419: */
420:
421: --
422: if g_debug then
423: hr_utility.set_location(l_proc, 40);
424: end if;
425: --
426: -- Call After Process User Hook
427: --

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

445: raise hr_api.validate_enabled;
446: end if;
447: --
448: if g_debug then
449: hr_utility.set_location(' Leaving:'||l_proc, 50);
450: end if;
451: --
452: exception
453: --