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

Line 9: g_debug boolean :=hr_utility.debug_enabled;

5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' hxc_had_bus.'; -- Global package name
9: g_debug boolean :=hr_utility.debug_enabled;
10: --
11: -- The following two global variables are only to be
12: -- used by the return_legislation_code function.
13: --

Line 47: g_debug:=hr_utility.debug_enabled;

43: l_proc varchar2(72);
44: --
45: begin
46: --
47: g_debug:=hr_utility.debug_enabled;
48: if g_debug then
49: l_proc := g_package||'set_security_group_id';
50: hr_utility.set_location('Entering:'|| l_proc, 10);
51: end if;

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

46: --
47: g_debug:=hr_utility.debug_enabled;
48: if g_debug then
49: l_proc := g_package||'set_security_group_id';
50: hr_utility.set_location('Entering:'|| l_proc, 10);
51: end if;
52: --
53: -- Ensure that all the mandatory parameter are not null
54: --

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

79: (p_security_group_id => l_security_group_id
80: );
81: --
82: if g_debug then
83: hr_utility.set_location(' Leaving:'|| l_proc, 20);
84: end if;
85: --
86: end set_security_group_id;
87: --

Line 119: g_debug:=hr_utility.debug_enabled;

115: l_proc varchar2(72) ;
116: --
117: Begin
118: --
119: g_debug:=hr_utility.debug_enabled;
120: if g_debug then
121: l_proc := g_package||'return_legislation_code';
122: hr_utility.set_location('Entering:'|| l_proc, 10);
123: end if;

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

118: --
119: g_debug:=hr_utility.debug_enabled;
120: if g_debug then
121: l_proc := g_package||'return_legislation_code';
122: hr_utility.set_location('Entering:'|| l_proc, 10);
123: end if;
124: --
125: -- Ensure that all the mandatory parameter are not null
126: --

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

138: -- variable.
139: --
140: l_legislation_code := hxc_had_bus.g_legislation_code;
141: if g_debug then
142: hr_utility.set_location(l_proc, 20);
143: end if;
144: else
145: --
146: -- The ID is different to the last call to this function

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

157: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
158: fnd_message.raise_error;
159: end if;
160: if g_debug then
161: hr_utility.set_location(l_proc,30);
162: end if;
163: --
164: -- Set the global variables so the values are
165: -- available for the next call to this function.

Line 172: hr_utility.set_location(' Leaving:'|| l_proc, 40);

168: hxc_had_bus.g_alias_definition_id := p_alias_definition_id;
169: hxc_had_bus.g_legislation_code := l_legislation_code;
170: end if;
171: if g_debug then
172: hr_utility.set_location(' Leaving:'|| l_proc, 40);
173: end if;
174: return l_legislation_code;
175: end return_legislation_code;
176: --

Line 290: g_debug:=hr_utility.debug_enabled;

286: --
287: l_dup_name varchar2(5) := NULL;
288: --
289: BEGIN
290: g_debug:=hr_utility.debug_enabled;
291: if g_debug then
292: l_proc := g_package||'chk_name';
293: hr_utility.set_location('Entering:'||l_proc, 5);
294: end if;

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

289: BEGIN
290: g_debug:=hr_utility.debug_enabled;
291: if g_debug then
292: l_proc := g_package||'chk_name';
293: hr_utility.set_location('Entering:'||l_proc, 5);
294: end if;
295: --
296: -- check that the name has been entered
297: --

Line 301: hr_utility.set_message(809, 'HXC_ALIAS_NAME_DEFN_MAND');

297: --
298: IF p_name IS NULL
299: THEN
300: --
301: hr_utility.set_message(809, 'HXC_ALIAS_NAME_DEFN_MAND');
302: hr_utility.raise_error;
303: --
304: END IF;
305: --

Line 302: hr_utility.raise_error;

298: IF p_name IS NULL
299: THEN
300: --
301: hr_utility.set_message(809, 'HXC_ALIAS_NAME_DEFN_MAND');
302: hr_utility.raise_error;
303: --
304: END IF;
305: --
306:

Line 310: -- hr_utility.set_message(809, 'HXC_ALIAS_TC_FIELD_MAND');

306:
307: --IF p_tc_field IS NULL
308: --THEN
309: --
310: -- hr_utility.set_message(809, 'HXC_ALIAS_TC_FIELD_MAND');
311: -- hr_utility.raise_error;
312: --
313: --END IF;
314:

Line 311: -- hr_utility.raise_error;

307: --IF p_tc_field IS NULL
308: --THEN
309: --
310: -- hr_utility.set_message(809, 'HXC_ALIAS_TC_FIELD_MAND');
311: -- hr_utility.raise_error;
312: --
313: --END IF;
314:
315: --

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

313: --END IF;
314:
315: --
316: if g_debug then
317: hr_utility.set_location('Processing:'||l_proc, 10);
318: end if;
319: --
320: -- check that the name is unique
321: --

Line 329: hr_utility.set_message(809, 'HXC_ALIAS_NAME_DEFN_UNIQUE');

325: --
326: IF l_dup_name IS NOT NULL
327: THEN
328: --
329: hr_utility.set_message(809, 'HXC_ALIAS_NAME_DEFN_UNIQUE');
330: hr_utility.raise_error;
331: --
332: END IF;
333: --

Line 330: hr_utility.raise_error;

326: IF l_dup_name IS NOT NULL
327: THEN
328: --
329: hr_utility.set_message(809, 'HXC_ALIAS_NAME_DEFN_UNIQUE');
330: hr_utility.raise_error;
331: --
332: END IF;
333: --
334: if g_debug then

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

331: --
332: END IF;
333: --
334: if g_debug then
335: hr_utility.set_location('Leaving:'||l_proc, 20);
336: end if;
337: --
338: END chk_name;
339: --

Line 373: g_debug:=hr_utility.debug_enabled;

369: l_exists_attribute1 VARCHAR2(6) := NULL;
370: l_exists_attribute2 VARCHAR2(6) := NULL;
371: --
372: BEGIN
373: g_debug:=hr_utility.debug_enabled;
374: if g_debug then
375: l_proc := g_package||'chk_delete';
376: hr_utility.set_location('Entering:'||l_proc, 5);
377: end if;

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

372: BEGIN
373: g_debug:=hr_utility.debug_enabled;
374: if g_debug then
375: l_proc := g_package||'chk_delete';
376: hr_utility.set_location('Entering:'||l_proc, 5);
377: end if;
378: --
379: --check that Timecard Alias is not being used
380: --

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

379: --check that Timecard Alias is not being used
380: --
381:
382: if g_debug then
383: hr_utility.set_location('Calling num_hierarchy_occurances: '||l_proc, 10);
384: end if;
385: l_exists_attribute1 := HXC_PREFERENCE_EVALUATION.num_hierarchy_occurances
386: ('TC_W_TCRD_ALIASES'
387: ,1

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

390: ('TC_W_TCRD_ALIASES'
391: ,2
392: ,TO_CHAR(p_alias_definition_id));
393: if g_debug then
394: hr_utility.set_location('After calling num_hierarchy_occurances:'||l_proc,20);
395: end if;
396:
397: --
398: IF l_exists_attribute1 <> 0 OR l_exists_attribute2 <> 0 THEN

Line 400: hr_utility.set_message(809, 'HXC_HEG_ALT_NAME_IN_USE');

396:
397: --
398: IF l_exists_attribute1 <> 0 OR l_exists_attribute2 <> 0 THEN
399: --
400: hr_utility.set_message(809, 'HXC_HEG_ALT_NAME_IN_USE');
401: hr_utility.raise_error;
402: --
403: END IF;
404:

Line 401: hr_utility.raise_error;

397: --
398: IF l_exists_attribute1 <> 0 OR l_exists_attribute2 <> 0 THEN
399: --
400: hr_utility.set_message(809, 'HXC_HEG_ALT_NAME_IN_USE');
401: hr_utility.raise_error;
402: --
403: END IF;
404:
405: hxc_time_category_utils_pkg.alias_definition_ref_int_chk ( p_alias_definition_id );

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

405: hxc_time_category_utils_pkg.alias_definition_ref_int_chk ( p_alias_definition_id );
406:
407: --
408: if g_debug then
409: hr_utility.set_location('Entering:'||l_proc, 5);
410: end if;
411: --
412: END chk_delete;
413:

Line 463: g_debug:=hr_utility.debug_enabled;

459:
460: --
461: --
462: begin
463: g_debug:=hr_utility.debug_enabled;
464: if g_debug then
465: l_proc := g_package||'chk_legislation_code';
466: hr_utility.set_location('Entering: '||l_proc,5);
467: end if;

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

462: begin
463: g_debug:=hr_utility.debug_enabled;
464: if g_debug then
465: l_proc := g_package||'chk_legislation_code';
466: hr_utility.set_location('Entering: '||l_proc,5);
467: end if;
468: --------------------------------
469: -- Check legislation code is valid --
470: --------------------------------

Line 477: hr_utility.set_message(800,'PER_52123_AMD_LEG_CODE_INV');

473: open csr_valid_legislation_code;
474: fetch csr_valid_legislation_code into l_territory_code;
475: if csr_valid_legislation_code%notfound then
476: close csr_valid_legislation_code;
477: hr_utility.set_message(800,'PER_52123_AMD_LEG_CODE_INV');
478: hr_utility.raise_error;
479: end if; -- End cursor if
480: close csr_valid_legislation_code;
481:

Line 478: hr_utility.raise_error;

474: fetch csr_valid_legislation_code into l_territory_code;
475: if csr_valid_legislation_code%notfound then
476: close csr_valid_legislation_code;
477: hr_utility.set_message(800,'PER_52123_AMD_LEG_CODE_INV');
478: hr_utility.raise_error;
479: end if; -- End cursor if
480: close csr_valid_legislation_code;
481:
482: if p_business_group_id is not null then

Line 487: hr_utility.set_message(800,'PER_52123_AMD_LEG_CODE_INV');

483: open csr_valid_bg_lc;
484: fetch csr_valid_bg_lc into l_lc;
485: if csr_valid_bg_lc%notfound then
486: close csr_valid_bg_lc;
487: hr_utility.set_message(800,'PER_52123_AMD_LEG_CODE_INV');
488: hr_utility.raise_error;
489: end if; -- End cursor if
490: close csr_valid_bg_lc;
491: end if;

Line 488: hr_utility.raise_error;

484: fetch csr_valid_bg_lc into l_lc;
485: if csr_valid_bg_lc%notfound then
486: close csr_valid_bg_lc;
487: hr_utility.set_message(800,'PER_52123_AMD_LEG_CODE_INV');
488: hr_utility.raise_error;
489: end if; -- End cursor if
490: close csr_valid_bg_lc;
491: end if;
492:

Line 496: hr_utility.set_location('Leaving: '||l_proc,10);

492:
493: end if; -- end check
494:
495: if g_debug then
496: hr_utility.set_location('Leaving: '||l_proc,10);
497: end if;
498: end chk_legislation_code;
499: --
500: --

Line 546: g_debug:=hr_utility.debug_enabled;

542: --
543: l_context_name varchar2(7) := NULL;
544: --
545: BEGIN
546: g_debug:=hr_utility.debug_enabled;
547: if g_debug then
548: l_proc := g_package||'chk_context';
549: hr_utility.set_location('Entering:'||l_proc, 5);
550: end if;

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

545: BEGIN
546: g_debug:=hr_utility.debug_enabled;
547: if g_debug then
548: l_proc := g_package||'chk_context';
549: hr_utility.set_location('Entering:'||l_proc, 5);
550: end if;
551: --
552: -- check that the name has been entered
553: --

Line 557: hr_utility.set_message(809, 'HXC_ALIAS_CONTEXT_MAND');

553: --
554: IF p_context_name IS NULL
555: THEN
556: --
557: hr_utility.set_message(809, 'HXC_ALIAS_CONTEXT_MAND');
558: hr_utility.raise_error;
559: --
560: END IF;
561: --

Line 558: hr_utility.raise_error;

554: IF p_context_name IS NULL
555: THEN
556: --
557: hr_utility.set_message(809, 'HXC_ALIAS_CONTEXT_MAND');
558: hr_utility.raise_error;
559: --
560: END IF;
561: --
562: if g_debug then

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

559: --
560: END IF;
561: --
562: if g_debug then
563: hr_utility.set_location('Processing:'||l_proc, 10);
564: end if;
565: --
566: -- check that the name is unique
567: --

Line 575: hr_utility.set_message(809, 'HXC_ALIAS_CONTEXT_INVALID');

571: --
572: IF l_context_name IS NULL
573: THEN
574: --
575: hr_utility.set_message(809, 'HXC_ALIAS_CONTEXT_INVALID');
576: hr_utility.raise_error;
577: --
578: END IF;
579: --

Line 576: hr_utility.raise_error;

572: IF l_context_name IS NULL
573: THEN
574: --
575: hr_utility.set_message(809, 'HXC_ALIAS_CONTEXT_INVALID');
576: hr_utility.raise_error;
577: --
578: END IF;
579: --
580: if g_debug then

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

577: --
578: END IF;
579: --
580: if g_debug then
581: hr_utility.set_location('Leaving:'||l_proc, 20);
582: end if;
583: --
584: END chk_context;
585: -- ----------------------------------------------------------------------------

Line 595: g_debug:=hr_utility.debug_enabled;

591: --
592: l_proc varchar2(72);
593: --
594: Begin
595: g_debug:=hr_utility.debug_enabled;
596: if g_debug then
597: l_proc := g_package||'insert_validate';
598: hr_utility.set_location('Entering:'||l_proc, 5);
599: end if;

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

594: Begin
595: g_debug:=hr_utility.debug_enabled;
596: if g_debug then
597: l_proc := g_package||'insert_validate';
598: hr_utility.set_location('Entering:'||l_proc, 5);
599: end if;
600: --
601: -- Call all supporting business operations
602: --

Line 633: hr_utility.set_location(' Leaving:'||l_proc, 10);

629: (p_business_group_id => p_rec.business_group_id,
630: p_legislation_code => p_rec.legislation_code);
631: --
632: if g_debug then
633: hr_utility.set_location(' Leaving:'||l_proc, 10);
634: end if;
635: End insert_validate;
636: --
637: -- ----------------------------------------------------------------------------

Line 647: g_debug:=hr_utility.debug_enabled;

643: --
644: l_proc varchar2(72);
645: --
646: Begin
647: g_debug:=hr_utility.debug_enabled;
648: if g_debug then
649: l_proc := g_package||'update_validate';
650: hr_utility.set_location('Entering:'||l_proc, 5);
651: end if;

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

646: Begin
647: g_debug:=hr_utility.debug_enabled;
648: if g_debug then
649: l_proc := g_package||'update_validate';
650: hr_utility.set_location('Entering:'||l_proc, 5);
651: end if;
652: --
653: -- Call all supporting business operations
654: --

Line 688: hr_utility.set_location(' Leaving:'||l_proc, 10);

684: p_legislation_code => p_rec.legislation_code);
685: --
686: --
687: if g_debug then
688: hr_utility.set_location(' Leaving:'||l_proc, 10);
689: end if;
690: End update_validate;
691: --
692: -- ----------------------------------------------------------------------------

Line 702: g_debug:=hr_utility.debug_enabled;

698: --
699: l_proc varchar2(72);
700: --
701: Begin
702: g_debug:=hr_utility.debug_enabled;
703: if g_debug then
704: l_proc := g_package||'delete_validate';
705: hr_utility.set_location('Entering:'||l_proc, 5);
706: end if;

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

701: Begin
702: g_debug:=hr_utility.debug_enabled;
703: if g_debug then
704: l_proc := g_package||'delete_validate';
705: hr_utility.set_location('Entering:'||l_proc, 5);
706: end if;
707: --
708: -- Call all supporting business operations
709: --

Line 714: hr_utility.set_location(' Leaving:'||l_proc, 10);

710: chk_delete
711: ( p_alias_definition_id => p_rec.alias_definition_id);
712: --
713: if g_debug then
714: hr_utility.set_location(' Leaving:'||l_proc, 10);
715: end if;
716: End delete_validate;
717: --
718: end hxc_had_bus;