DBA Data[Home] [Help]

APPS.HXC_TIME_ENTRY_RULE_GROUP_API dependencies on HR_UTILITY

Line 10: g_debug boolean := hr_utility.debug_enabled;

6: g_package varchar2(33) := ' hxc_time_entry_rule_group_api.';
7:
8: g_entity_type varchar2(16) := 'TIME_ENTRY_RULES';
9:
10: g_debug boolean := hr_utility.debug_enabled;
11: --
12: -- ----------------------------------------------------------------------------
13: -- |-----------------------< create_time_entry_rule_group >------------------------|
14: -- ----------------------------------------------------------------------------

Line 30: g_debug := hr_utility.debug_enabled;

26: l_object_version_number hxc_entity_groups.object_version_number%TYPE;
27: l_time_entry_rule_group_id hxc_entity_groups.entity_group_id%TYPE;
28: --
29: begin
30: g_debug := hr_utility.debug_enabled;
31: --
32:
33: --
34: if g_debug then

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

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

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

45: , p_entity_type => g_entity_type
46: , p_entity_group_id => p_time_entry_rule_group_id );
47:
48: if g_debug then
49: hr_utility.set_location(l_proc, 20);
50: end if;
51: --
52: -- Call Before Process User Hook
53: --

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

65: );
66: end;
67: --
68: if g_debug then
69: hr_utility.set_location(l_proc, 30);
70: end if;
71: --
72: -- Process Logic
73: --

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

72: -- Process Logic
73: --
74: --
75: if g_debug then
76: hr_utility.set_location(l_proc, 40);
77: end if;
78: --
79: -- call row handler
80: --

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

84: ,p_entity_group_id => l_time_entry_rule_group_id
85: ,p_object_version_number => l_object_version_number );
86: --
87: if g_debug then
88: hr_utility.set_location(l_proc, 50);
89: end if;
90: --
91: -- Call After Process User Hook
92: --

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

104: );
105: end;
106: --
107: if g_debug then
108: hr_utility.set_location(l_proc, 60);
109: end if;
110: --
111: -- When in validation only mode raise the Validate_Enabled exception
112: --

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

114: raise hr_api.validate_enabled;
115: end if;
116: --
117: if g_debug then
118: hr_utility.set_location(' Leaving:'||l_proc, 70);
119: end if;
120: --
121: -- Set all output arguments
122: --

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

139: p_time_entry_rule_group_id := null;
140: p_object_version_number := null;
141: --
142: if g_debug then
143: hr_utility.set_location(' Leaving:'||l_proc, 80);
144: end if;
145: --
146: when others then
147: --

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

147: --
148: -- A validation or unexpected error has occured
149: --
150: if g_debug then
151: hr_utility.trace('In exeception');
152: end if;
153: ROLLBACK TO create_time_entry_rule_group;
154: raise;
155: --

Line 175: g_debug := hr_utility.debug_enabled;

171: l_proc varchar2(72);
172: l_object_version_number hxc_entity_groups.object_version_number%TYPE := p_object_version_number;
173: --
174: begin
175: g_debug := hr_utility.debug_enabled;
176: --
177: if g_debug then
178: l_proc := g_package||' update_time_entry_rule_group';
179: hr_utility.set_location('Entering:'|| l_proc, 10);

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

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

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

188: , p_entity_type => g_entity_type
189: , p_entity_group_id => p_time_entry_rule_group_id );
190:
191: if g_debug then
192: hr_utility.set_location(l_proc, 20);
193: end if;
194: --
195: -- Call Before Process User Hook
196: --

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

208: );
209: end;
210: --
211: if g_debug then
212: hr_utility.set_location(l_proc, 30);
213: end if;
214: --
215: -- Process Logic
216: --

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

223: ,p_object_version_number => l_object_version_number );
224: --
225: --
226: if g_debug then
227: hr_utility.set_location(l_proc, 40);
228: end if;
229: --
230: -- Call After Process User Hook
231: --

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

243: );
244: end;
245: --
246: if g_debug then
247: hr_utility.set_location(l_proc, 50);
248: end if;
249: --
250: -- When in validation only mode raise the Validate_Enabled exception
251: --

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

253: raise hr_api.validate_enabled;
254: end if;
255: --
256: if g_debug then
257: hr_utility.set_location(' Leaving:'||l_proc, 60);
258: end if;
259: --
260: -- Set all output arguments
261: --

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

276: --
277: p_object_version_number := null;
278: --
279: if g_debug then
280: hr_utility.set_location(' Leaving:'||l_proc, 60);
281: end if;
282: --
283: when others then
284: --

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

284: --
285: -- A validation or unexpected error has occured
286: --
287: if g_debug then
288: hr_utility.trace('In exeception');
289: end if;
290: ROLLBACK TO update_time_entry_rule_group;
291: raise;
292: --

Line 310: g_debug := hr_utility.debug_enabled;

306: --
307: l_proc varchar2(72);
308: --
309: begin
310: g_debug := hr_utility.debug_enabled;
311: --
312:
313: if g_debug then
314: l_proc := g_package||'delete_time_entry_rule_group';

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

311: --
312:
313: if g_debug then
314: l_proc := g_package||'delete_time_entry_rule_group';
315: hr_utility.set_location('Entering:'|| l_proc, 10);
316: end if;
317: --
318: -- Issue a savepoint if operating in validation only mode
319: --

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

323: p_entity_group_id => p_time_entry_rule_group_id
324: , p_entity_type => g_entity_type );
325:
326: if g_debug then
327: hr_utility.set_location(l_proc, 20);
328: end if;
329: --
330: -- Call Before Process User Hook
331: --

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

343: );
344: end;
345: --
346: if g_debug then
347: hr_utility.set_location(l_proc, 30);
348: end if;
349: --
350: -- Process Logic
351: --

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

355: ,p_object_version_number => p_object_version_number
356: );
357: --
358: if g_debug then
359: hr_utility.set_location(l_proc, 40);
360: end if;
361: --
362: -- Call After Process User Hook
363: --

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

381: raise hr_api.validate_enabled;
382: end if;
383: --
384: if g_debug then
385: hr_utility.set_location(' Leaving:'||l_proc, 50);
386: end if;
387: --
388: exception
389: --

Line 444: g_debug := hr_utility.debug_enabled;

440: --
441: l_dup_name varchar2(5) := NULL;
442: --
443: BEGIN
444: g_debug := hr_utility.debug_enabled;
445:
446: if g_debug then
447: l_proc := g_package||'chk_name';
448: hr_utility.set_location('Entering:'||l_proc, 5);

Line 448: hr_utility.set_location('Entering:'||l_proc, 5);

444: g_debug := hr_utility.debug_enabled;
445:
446: if g_debug then
447: l_proc := g_package||'chk_name';
448: hr_utility.set_location('Entering:'||l_proc, 5);
449: end if;
450: --
451: -- check that the name has been entered
452: --

Line 456: hr_utility.set_message(809, 'HXC_HEG_TER_NAME_MAND');

452: --
453: IF ( p_name IS NULL )
454: THEN
455: --
456: hr_utility.set_message(809, 'HXC_HEG_TER_NAME_MAND');
457: hr_utility.raise_error;
458: --
459: END IF;
460: if g_debug then

Line 457: hr_utility.raise_error;

453: IF ( p_name IS NULL )
454: THEN
455: --
456: hr_utility.set_message(809, 'HXC_HEG_TER_NAME_MAND');
457: hr_utility.raise_error;
458: --
459: END IF;
460: if g_debug then
461: hr_utility.set_location('Processing:'||l_proc, 10);

Line 461: hr_utility.set_location('Processing:'||l_proc, 10);

457: hr_utility.raise_error;
458: --
459: END IF;
460: if g_debug then
461: hr_utility.set_location('Processing:'||l_proc, 10);
462: end if;
463: --
464: -- check that the name is unique
465: --

Line 473: hr_utility.set_message(809, 'HXC_HEG_TER_NAME_DUP');

469: --
470: IF ( l_dup_name IS NOT NULL )
471: THEN
472: --
473: hr_utility.set_message(809, 'HXC_HEG_TER_NAME_DUP');
474: hr_utility.raise_error;
475: --
476: END IF;
477: --

Line 474: hr_utility.raise_error;

470: IF ( l_dup_name IS NOT NULL )
471: THEN
472: --
473: hr_utility.set_message(809, 'HXC_HEG_TER_NAME_DUP');
474: hr_utility.raise_error;
475: --
476: END IF;
477: --
478: hr_utility.set_location('Leaving:'||l_proc, 20);

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

474: hr_utility.raise_error;
475: --
476: END IF;
477: --
478: hr_utility.set_location('Leaving:'||l_proc, 20);
479: --
480: END chk_name;
481: --
482: -- ----------------------------------------------------------------------------

Line 513: g_debug := hr_utility.debug_enabled;

509: */
510: l_exists VARCHAR2(6) := NULL;
511:
512: BEGIN
513: g_debug := hr_utility.debug_enabled;
514:
515: if g_debug then
516: l_proc := g_package||'chk_delete';
517: hr_utility.set_location('Entering:'||l_proc, 5);

Line 517: hr_utility.set_location('Entering:'||l_proc, 5);

513: g_debug := hr_utility.debug_enabled;
514:
515: if g_debug then
516: l_proc := g_package||'chk_delete';
517: hr_utility.set_location('Entering:'||l_proc, 5);
518: end if;
519:
520: -- check that entity_group is not being used in the pref hierarchy
521:

Line 527: hr_utility.set_location('Calling num_hierarchy_occurances:'||l_proc,10);

523: FETCH csr_chk_pref INTO l_exists;
524: CLOSE csr_chk_pref;*/
525:
526: if g_debug then
527: hr_utility.set_location('Calling num_hierarchy_occurances:'||l_proc,10);
528: end if;
529: l_exists := HXC_PREFERENCE_EVALUATION.num_hierarchy_occurances
530: ('TS_PER_TIME_ENTRY_RULES'
531: ,1

Line 534: hr_utility.set_location('After calling num_hierarchy_occurances:'||l_proc,20);

530: ('TS_PER_TIME_ENTRY_RULES'
531: ,1
532: ,TO_CHAR(p_entity_group_id));
533: if g_debug then
534: hr_utility.set_location('After calling num_hierarchy_occurances:'||l_proc,20);
535: end if;
536:
537: IF l_exists <> 0 THEN
538: --

Line 539: hr_utility.set_message(809, 'HXC_HEG_TER_IN_USE');

535: end if;
536:
537: IF l_exists <> 0 THEN
538: --
539: hr_utility.set_message(809, 'HXC_HEG_TER_IN_USE');
540: hr_utility.raise_error;
541: --
542: END IF;
543: --

Line 540: hr_utility.raise_error;

536:
537: IF l_exists <> 0 THEN
538: --
539: hr_utility.set_message(809, 'HXC_HEG_TER_IN_USE');
540: hr_utility.raise_error;
541: --
542: END IF;
543: --
544: if g_debug then

Line 545: hr_utility.set_location('Processing: '||l_proc, 60);

541: --
542: END IF;
543: --
544: if g_debug then
545: hr_utility.set_location('Processing: '||l_proc, 60);
546: end if;
547: --
548: -- Start Fix for Bug No. 2873485
549: l_exists := null;

Line 556: hr_utility.set_message(809, 'HXC_HEG_TER_IN_USE');

552: ,1
553: ,TO_CHAR(p_entity_group_id));
554: IF l_exists <> 0 THEN
555:
556: hr_utility.set_message(809, 'HXC_HEG_TER_IN_USE');
557: hr_utility.raise_error;
558: --
559: END IF;
560: if g_debug then

Line 557: hr_utility.raise_error;

553: ,TO_CHAR(p_entity_group_id));
554: IF l_exists <> 0 THEN
555:
556: hr_utility.set_message(809, 'HXC_HEG_TER_IN_USE');
557: hr_utility.raise_error;
558: --
559: END IF;
560: if g_debug then
561: hr_utility.set_location('Processing: '||l_proc, 70);

Line 561: hr_utility.set_location('Processing: '||l_proc, 70);

557: hr_utility.raise_error;
558: --
559: END IF;
560: if g_debug then
561: hr_utility.set_location('Processing: '||l_proc, 70);
562: end if;
563: -- End Fix for Bug No. 2873485
564:
565: l_exists := null;

Line 572: hr_utility.set_message(809, 'HXC_HEG_TER_IN_USE');

568: ,1
569: ,TO_CHAR(p_entity_group_id));
570: IF l_exists <> 0 THEN
571:
572: hr_utility.set_message(809, 'HXC_HEG_TER_IN_USE');
573: hr_utility.raise_error;
574: --
575: END IF;
576: END chk_delete;

Line 573: hr_utility.raise_error;

569: ,TO_CHAR(p_entity_group_id));
570: IF l_exists <> 0 THEN
571:
572: hr_utility.set_message(809, 'HXC_HEG_TER_IN_USE');
573: hr_utility.raise_error;
574: --
575: END IF;
576: END chk_delete;
577: --