eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HXC_APPLICATION_SET_API dependencies on HR_UTILITY

Line 9: g_debug boolean :=hr_utility.debug_enabled;

5: --
6: g_package varchar2(33) := ' hxc_application_set_api.';
7:
8: g_entity_type varchar2(16) := 'TIME_RECIPIENTS';
9: g_debug boolean :=hr_utility.debug_enabled;
10: --
11: -- ----------------------------------------------------------------------------
12: -- |-----------------------< create_application_set >------------------------|
13: -- ----------------------------------------------------------------------------

Line 30: g_debug:=hr_utility.debug_enabled;

26: l_application_set_id hxc_entity_groups.entity_group_id%TYPE;
27: --
28: begin
29: --
30: g_debug:=hr_utility.debug_enabled;
31: --
32: if g_debug then
33: l_proc := g_package||' create_application_set';
34: hr_utility.set_location('Entering:'|| l_proc, 10);

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

30: g_debug:=hr_utility.debug_enabled;
31: --
32: if g_debug then
33: l_proc := g_package||' create_application_set';
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 46: hr_utility.set_location(l_proc, 20);

42: ( p_name => p_name
43: , p_entity_group_id => p_application_set_id );
44:
45: if g_debug then
46: hr_utility.set_location(l_proc, 20);
47: end if;
48: --
49: -- Call Before Process User Hook
50: --

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

62: );
63: end;
64: --
65: if g_debug then
66: hr_utility.set_location(l_proc, 30);
67: end if;
68: --
69: -- Process Logic
70: --

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

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

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

81: ,p_entity_group_id => l_application_set_id
82: ,p_object_version_number => l_object_version_number );
83: --
84: if g_debug then
85: hr_utility.set_location(l_proc, 50);
86: end if;
87: --
88: -- Call After Process User Hook
89: --

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

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

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

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

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

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

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

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

Line 172: g_debug:=hr_utility.debug_enabled;

168: l_proc varchar2(72);
169: l_object_version_number hxc_entity_groups.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_application_set';
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_application_set';
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 188: hr_utility.set_location(l_proc, 20);

184: ( p_name => p_name
185: , p_entity_group_id => p_application_set_id );
186:
187: if g_debug then
188: hr_utility.set_location(l_proc, 20);
189: end if;
190: --
191: -- Call Before Process User Hook
192: --

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

204: );
205: end;
206: --
207: if g_debug then
208: hr_utility.set_location(l_proc, 30);
209: end if;
210: --
211: -- Process Logic
212: --

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

219: ,p_object_version_number => l_object_version_number );
220: --
221: --
222: if g_debug then
223: hr_utility.set_location(l_proc, 40);
224: end if;
225: --
226: -- Call After Process User Hook
227: --

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

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

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

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

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

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

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

280: --
281: -- A validation or unexpected error has occured
282: --
283: if g_debug then
284: hr_utility.trace('In exeception');
285: end if;
286: ROLLBACK TO update_application_set;
287: raise;
288: --

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

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

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

317: p_entity_group_id => p_application_set_id
318: , p_entity_type => g_entity_type );
319:
320: if g_debug then
321: hr_utility.set_location(l_proc, 20);
322: end if;
323: --
324: -- Call Before Process User Hook
325: --

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

337: );
338: end;
339: --
340: if g_debug then
341: hr_utility.set_location(l_proc, 30);
342: end if;
343: --
344: -- Process Logic
345: --

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

349: ,p_object_version_number => p_object_version_number
350: );
351: --
352: if g_debug then
353: hr_utility.set_location(l_proc, 40);
354: end if;
355: --
356: -- Call After Process User Hook
357: --

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

375: raise hr_api.validate_enabled;
376: end if;
377: --
378: if g_debug then
379: hr_utility.set_location(' Leaving:'||l_proc, 50);
380: end if;
381: --
382: exception
383: --

Line 437: g_debug:=hr_utility.debug_enabled;

433: --
434: l_dup_name varchar2(5) := NULL;
435: --
436: BEGIN
437: g_debug:=hr_utility.debug_enabled;
438: if g_debug then
439: l_proc:= g_package||'chk_name';
440: hr_utility.set_location('Entering:'||l_proc, 5);
441: end if;

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

436: BEGIN
437: g_debug:=hr_utility.debug_enabled;
438: if g_debug then
439: l_proc:= g_package||'chk_name';
440: hr_utility.set_location('Entering:'||l_proc, 5);
441: end if;
442: --
443: -- check that the name has been entered
444: --

Line 448: hr_utility.set_message(809, 'HXC_HEG_AS_NAME_MAND');

444: --
445: IF ( p_name IS NULL )
446: THEN
447: --
448: hr_utility.set_message(809, 'HXC_HEG_AS_NAME_MAND');
449: hr_utility.raise_error;
450: --
451: END IF;
452: if g_debug then

Line 449: hr_utility.raise_error;

445: IF ( p_name IS NULL )
446: THEN
447: --
448: hr_utility.set_message(809, 'HXC_HEG_AS_NAME_MAND');
449: hr_utility.raise_error;
450: --
451: END IF;
452: if g_debug then
453: hr_utility.set_location('Processing:'||l_proc, 10);

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

449: hr_utility.raise_error;
450: --
451: END IF;
452: if g_debug then
453: hr_utility.set_location('Processing:'||l_proc, 10);
454: end if;
455: --
456: -- check that the name is unique
457: --

Line 465: hr_utility.set_message(809, 'HXC_HEG_AS_NAME_DUP');

461: --
462: IF ( l_dup_name IS NOT NULL )
463: THEN
464: --
465: hr_utility.set_message(809, 'HXC_HEG_AS_NAME_DUP');
466: hr_utility.raise_error;
467: --
468: END IF;
469: --

Line 466: hr_utility.raise_error;

462: IF ( l_dup_name IS NOT NULL )
463: THEN
464: --
465: hr_utility.set_message(809, 'HXC_HEG_AS_NAME_DUP');
466: hr_utility.raise_error;
467: --
468: END IF;
469: --
470: if g_debug then

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

467: --
468: END IF;
469: --
470: if g_debug then
471: hr_utility.set_location('Leaving:'||l_proc, 20);
472: end if;
473: --
474: END chk_name;
475: --

Line 508: g_debug:=hr_utility.debug_enabled;

504:
505: l_exists VARCHAR2(6) := NULL;
506:
507: BEGIN
508: g_debug:=hr_utility.debug_enabled;
509: if g_debug then
510: l_proc := g_package||'chk_delete';
511: hr_utility.set_location('Entering:'||l_proc, 5);
512: end if;

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

507: BEGIN
508: g_debug:=hr_utility.debug_enabled;
509: if g_debug then
510: l_proc := g_package||'chk_delete';
511: hr_utility.set_location('Entering:'||l_proc, 5);
512: end if;
513:
514: -- check that entity_group is not being used in the pref hierarchy
515: -- call function num_hierarchy_occurances to check for data integrity.

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

518: FETCH csr_chk_pref INTO l_exists;
519: CLOSE csr_chk_pref;*/
520:
521: if g_debug then
522: hr_utility.set_location('Calling num_hierarchy_occurances:'||l_proc,10);
523: end if;
524: l_exists := HXC_PREFERENCE_EVALUATION.num_hierarchy_occurances
525: ('TS_PER_APPLICATION_SET'
526: ,1

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

525: ('TS_PER_APPLICATION_SET'
526: ,1
527: ,TO_CHAR(p_entity_group_id));
528: if g_debug then
529: hr_utility.set_location('After calling num_hierarchy_occurances:'||l_proc,20);
530: end if;
531: IF l_exists <> 0 THEN
532: --
533: hr_utility.set_message(809, 'HXC_HEG_AS_IN_USE');

Line 533: hr_utility.set_message(809, 'HXC_HEG_AS_IN_USE');

529: hr_utility.set_location('After calling num_hierarchy_occurances:'||l_proc,20);
530: end if;
531: IF l_exists <> 0 THEN
532: --
533: hr_utility.set_message(809, 'HXC_HEG_AS_IN_USE');
534: hr_utility.raise_error;
535: --
536: END IF;
537: --

Line 534: hr_utility.raise_error;

530: end if;
531: IF l_exists <> 0 THEN
532: --
533: hr_utility.set_message(809, 'HXC_HEG_AS_IN_USE');
534: hr_utility.raise_error;
535: --
536: END IF;
537: --
538: if g_debug then

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

535: --
536: END IF;
537: --
538: if g_debug then
539: hr_utility.set_location('Processing: '||l_proc, 60);
540: end if;
541: --
542: END chk_delete;
543: --