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_RETRIEVAL_RULE_GRP_API dependencies on HR_UTILITY

Line 10: g_debug boolean := hr_utility.debug_enabled;

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

Line 30: g_debug := hr_utility.debug_enabled;

26: l_object_version_number hxc_entity_groups.object_version_number%TYPE;
27: l_retrieval_rule_grp_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_retrieval_rule_grp';
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 48: hr_utility.set_location(l_proc, 20);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 174: g_debug := hr_utility.debug_enabled;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 308: g_debug := hr_utility.debug_enabled;

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

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

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

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

319: --
320: chk_delete ( p_entity_group_id => p_retrieval_rule_grp_id );
321:
322: if g_debug then
323: hr_utility.set_location(l_proc, 20);
324: end if;
325: --
326: -- Call Before Process User Hook
327: --

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

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

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

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

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

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

Line 439: g_debug := hr_utility.debug_enabled;

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

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

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

Line 451: hr_utility.set_message(809, 'HXC_HEG_RR_NAME_MAND');

447: --
448: IF ( p_name IS NULL )
449: THEN
450: --
451: hr_utility.set_message(809, 'HXC_HEG_RR_NAME_MAND');
452: hr_utility.raise_error;
453: --
454: END IF;
455: if g_debug then

Line 452: hr_utility.raise_error;

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

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

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

Line 468: hr_utility.set_message(809, 'HXC_HEG_RR_NAME_DUP');

464: --
465: IF ( l_dup_name IS NOT NULL )
466: THEN
467: --
468: hr_utility.set_message(809, 'HXC_HEG_RR_NAME_DUP');
469: hr_utility.raise_error;
470: --
471: END IF;
472: --

Line 469: hr_utility.raise_error;

465: IF ( l_dup_name IS NOT NULL )
466: THEN
467: --
468: hr_utility.set_message(809, 'HXC_HEG_RR_NAME_DUP');
469: hr_utility.raise_error;
470: --
471: END IF;
472: --
473: if g_debug then

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

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

Line 510: g_debug := hr_utility.debug_enabled;

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

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

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

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

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

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

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

Line 536: hr_utility.set_message(809, 'HXC_HEG_RR_IN_USE');

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

Line 537: hr_utility.raise_error;

533: end if;
534: IF l_exists <> 0 THEN
535: --
536: hr_utility.set_message(809, 'HXC_HEG_RR_IN_USE');
537: hr_utility.raise_error;
538: --
539: END IF;
540: --
541: if g_debug then

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

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