DBA Data[Home] [Help]

APPS.HXC_RESOURCE_RULES_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_resource_rules_api.';
7: g_debug boolean :=hr_utility.debug_enabled;
8: --
9: -- ----------------------------------------------------------------------------
10: -- |--------------------------< create_resource_rules >-----------------------|
11: -- ----------------------------------------------------------------------------

Line 37: g_debug:=hr_utility.debug_enabled;

33: l_proc varchar2(72);
34: l_object_version_number hxc_resource_rules.object_version_number%TYPE;
35: l_resource_rule_id hxc_resource_rules.resource_rule_id%TYPE;
36: begin
37: g_debug:=hr_utility.debug_enabled;
38: if g_debug then
39: l_proc := g_package||'create_resource_rules';
40: hr_utility.set_location('Entering:'|| l_proc, 10);
41: end if;

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

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

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

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

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

79: );
80: end;
81: --
82: if g_debug then
83: hr_utility.set_location(l_proc, 30);
84: end if;
85: --
86: --
87: -- Validation in addition to Row Handlers

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

92: --
93: -- Process Logic
94: --
95: if g_debug then
96: hr_utility.set_location(l_proc, 40);
97: end if;
98: --
99: -- call row handler
100: --

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

114: ,p_object_version_number => l_object_version_number
115: );
116: --
117: if g_debug then
118: hr_utility.set_location(l_proc, 50);
119: end if;
120: --
121: -- Call After Process User Hook
122: --

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

144: );
145: end;
146: --
147: if g_debug then
148: hr_utility.set_location(l_proc, 60);
149: end if;
150: --
151: -- When in validation only mode raise the Validate_Enabled exception
152: --

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

154: raise hr_api.validate_enabled;
155: end if;
156: --
157: --if g_debug then
158: --hr_utility.set_location(' Leaving:'||l_proc, 70);
159: --end if;
160: --
161: --
162: -- Set all output arguments

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

164: p_resource_rule_id := l_resource_rule_id;
165: p_object_version_number := l_object_version_number;
166: --
167: if g_debug then
168: hr_utility.set_location(' Leaving:'||l_proc, 70);
169: end if;
170: exception
171: when hr_api.validate_enabled then
172: --

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

181: --
182: p_resource_rule_id := null;
183: p_object_version_number := null;
184: if g_debug then
185: hr_utility.set_location(' Leaving:'||l_proc, 80);
186: end if;
187: when others then
188: --
189: -- A validation or unexpected error has occured

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

189: -- A validation or unexpected error has occured
190: --
191: rollback to create_resource_rules;
192: if g_debug then
193: hr_utility.set_location(' Leaving:'||l_proc, 90);
194: end if;
195: raise;
196: --
197: end create_resource_rules;

Line 228: g_debug:=hr_utility.debug_enabled;

224: l_object_version_number hxc_resource_rules.object_version_number%TYPE := p_object_version_number;
225: --
226: Begin
227: --
228: g_debug:=hr_utility.debug_enabled;
229: if g_debug then
230: l_proc := g_package||' update_resource_rules';
231: hr_utility.set_location('Entering:'|| l_proc, 10);
232: end if;

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

227: --
228: g_debug:=hr_utility.debug_enabled;
229: if g_debug then
230: l_proc := g_package||' update_resource_rules';
231: hr_utility.set_location('Entering:'|| l_proc, 10);
232: end if;
233: --
234: -- Issue a savepoint if operating in validation only mode
235: --

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

235: --
236: savepoint update_resource_rules;
237: --
238: if g_debug then
239: hr_utility.set_location(l_proc, 20);
240: end if;
241: --
242: -- Call Before Process User Hook
243: --

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

267: --
268: --insert into mtemp values('out of comp_b');
269: --commit;
270: --if g_debug then
271: --hr_utility.set_location(l_proc, 30);
272: --end if;
273: --
274: -- Process Logic
275: --

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

297: --insert into mtemp values('out of hax_hac_upd');
298: --commit;
299:
300: if g_debug then
301: hr_utility.set_location(l_proc, 40);
302: end if;
303: --
304: -- Call After Process User Hook
305: --

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

330: --insert into mtemp values('out of comp_a');
331: --commit;
332:
333: if g_debug then
334: hr_utility.set_location(l_proc, 50);
335: end if;
336: --
337: -- When in validation only mode raise the Validate_Enabled exception
338: --

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

340: raise hr_api.validate_enabled;
341: end if;
342: --
343: if g_debug then
344: hr_utility.set_location(' Leaving:'||l_proc, 60);
345: end if;
346: --
347: -- Set all output arguments
348: --

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

373: --insert into mtemp values('OVN set to null');
374: --commit;
375:
376: if g_debug then
377: hr_utility.set_location(' Leaving:'||l_proc, 60);
378: end if;
379: --
380: when others then
381: --

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

382: -- A validation or unexpected error has occured
383: --
384: ROLLBACK TO update_resource_rules;
385: if g_debug then
386: hr_utility.set_location(' Leaving:'||l_proc, 70);
387: end if;
388: raise;
389: --
390: END update_resource_rules;

Line 409: g_debug:=hr_utility.debug_enabled;

405: --
406: begin
407: --
408: --
409: g_debug:=hr_utility.debug_enabled;
410: if g_debug then
411: l_proc := g_package||'delete_resource_rules';
412: hr_utility.set_location('Entering:'|| l_proc, 10);
413: end if;

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

408: --
409: g_debug:=hr_utility.debug_enabled;
410: if g_debug then
411: l_proc := g_package||'delete_resource_rules';
412: hr_utility.set_location('Entering:'|| l_proc, 10);
413: end if;
414: --
415: -- Issue a savepoint if operating in validation only mode
416: --

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

416: --
417: savepoint delete_resource_rules;
418: --
419: if g_debug then
420: hr_utility.set_location(l_proc, 20);
421: end if;
422: --
423: -- Call Before Process User Hook
424: --

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

436: );
437: end;
438: --
439: if g_debug then
440: hr_utility.set_location(l_proc, 30);
441: end if;
442: --
443: -- Process Logic
444: --

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

448: ,p_object_version_number => p_object_version_number
449: );
450: --
451: if g_debug then
452: hr_utility.set_location(l_proc, 40);
453: end if;
454: --
455: -- Call After Process User Hook
456: --

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

474: raise hr_api.validate_enabled;
475: end if;
476: --
477: if g_debug then
478: hr_utility.set_location(' Leaving:'||l_proc, 50);
479: end if;
480: --
481: exception
482: --