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_HAV_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_hav_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_hav_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_hav_bus.g_alias_value_id := p_alias_value_id;
169: hxc_hav_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 212: g_debug:=hr_utility.debug_enabled;

208: --
209: l_proc varchar2(72);
210: --
211: begin
212: g_debug:=hr_utility.debug_enabled;
213: if g_debug then
214: l_proc := g_package || 'chk_df';
215: hr_utility.set_location('Entering:'||l_proc,10);
216: end if;

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

211: begin
212: g_debug:=hr_utility.debug_enabled;
213: if g_debug then
214: l_proc := g_package || 'chk_df';
215: hr_utility.set_location('Entering:'||l_proc,10);
216: end if;
217: --
218: if ((p_rec.alias_value_id is not null) and (
219: nvl(hxc_hav_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

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

352: );
353: end if;
354: --
355: if g_debug then
356: hr_utility.set_location(' Leaving:'||l_proc,20);
357: end if;
358: end chk_df;
359: --
360: -- ----------------------------------------------------------------------------

Line 487: g_debug:=hr_utility.debug_enabled;

483: --
484: l_dup_name varchar2(5) := NULL;
485: --
486: BEGIN
487: g_debug:=hr_utility.debug_enabled;
488: if g_debug then
489: l_proc := g_package||'chk_name';
490: hr_utility.set_location('Entering:'||l_proc, 5);
491: end if;

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

486: BEGIN
487: g_debug:=hr_utility.debug_enabled;
488: if g_debug then
489: l_proc := g_package||'chk_name';
490: hr_utility.set_location('Entering:'||l_proc, 5);
491: end if;
492: --
493: -- check that the name has been entered
494: --

Line 498: hr_utility.set_message(809, 'HXC_ALIAS_NAME_VALUE_MAND');

494: --
495: IF p_name IS NULL
496: THEN
497: --
498: hr_utility.set_message(809, 'HXC_ALIAS_NAME_VALUE_MAND');
499: hr_utility.raise_error;
500: --
501: END IF;
502: --

Line 499: hr_utility.raise_error;

495: IF p_name IS NULL
496: THEN
497: --
498: hr_utility.set_message(809, 'HXC_ALIAS_NAME_VALUE_MAND');
499: hr_utility.raise_error;
500: --
501: END IF;
502: --
503: IF p_date_from IS NULL

Line 506: hr_utility.set_message(809, 'HXC_0056_DAR_START_DATE_MAND');

502: --
503: IF p_date_from IS NULL
504: THEN
505: --
506: hr_utility.set_message(809, 'HXC_0056_DAR_START_DATE_MAND');
507: hr_utility.raise_error;
508: --
509: END IF;
510: --

Line 507: hr_utility.raise_error;

503: IF p_date_from IS NULL
504: THEN
505: --
506: hr_utility.set_message(809, 'HXC_0056_DAR_START_DATE_MAND');
507: hr_utility.raise_error;
508: --
509: END IF;
510: --
511: IF p_date_to is not null AND p_date_from > p_date_to THEN

Line 512: hr_utility.set_message(809,'HXC_0059_DAR_TO_LESS_THAN_FROM');

508: --
509: END IF;
510: --
511: IF p_date_to is not null AND p_date_from > p_date_to THEN
512: hr_utility.set_message(809,'HXC_0059_DAR_TO_LESS_THAN_FROM');
513: hr_utility.raise_error;
514: END IF;
515: --
516: if g_debug then

Line 513: hr_utility.raise_error;

509: END IF;
510: --
511: IF p_date_to is not null AND p_date_from > p_date_to THEN
512: hr_utility.set_message(809,'HXC_0059_DAR_TO_LESS_THAN_FROM');
513: hr_utility.raise_error;
514: END IF;
515: --
516: if g_debug then
517: hr_utility.set_location('Processing:'||l_proc, 10);

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

513: hr_utility.raise_error;
514: END IF;
515: --
516: if g_debug then
517: hr_utility.set_location('Processing:'||l_proc, 10);
518: end if;
519: --
520: -- check that the name is unique
521: --

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

535: --
536: IF l_dup_name IS NOT NULL
537: THEN
538: --
539: hr_utility.set_message(809, 'HXC_ALIAS_NAME_VALUE_UNIQUE');
540: hr_utility.raise_error;
541: --
542: END IF;
543: --

Line 540: hr_utility.raise_error;

536: IF l_dup_name IS NOT NULL
537: THEN
538: --
539: hr_utility.set_message(809, 'HXC_ALIAS_NAME_VALUE_UNIQUE');
540: hr_utility.raise_error;
541: --
542: END IF;
543: --
544: if g_debug then

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

541: --
542: END IF;
543: --
544: if g_debug then
545: hr_utility.set_location('Leaving:'||l_proc, 20);
546: end if;
547: --
548: END chk_name;
549: --

Line 672: g_debug:=hr_utility.debug_enabled;

668: --
669: l_dup_value varchar2(5) := NULL;
670: --
671: BEGIN
672: g_debug:=hr_utility.debug_enabled;
673: if g_debug then
674: l_proc := g_package||'chk_duplicate_values';
675: hr_utility.set_location('Entering:'||l_proc, 5);
676: end if;

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

671: BEGIN
672: g_debug:=hr_utility.debug_enabled;
673: if g_debug then
674: l_proc := g_package||'chk_duplicate_values';
675: hr_utility.set_location('Entering:'||l_proc, 5);
676: end if;
677: --
678: IF p_date_from IS NULL
679: THEN

Line 681: hr_utility.set_message(809, 'HXC_0056_DAR_START_DATE_MAND');

677: --
678: IF p_date_from IS NULL
679: THEN
680: --
681: hr_utility.set_message(809, 'HXC_0056_DAR_START_DATE_MAND');
682: hr_utility.raise_error;
683: --
684: END IF;
685: --

Line 682: hr_utility.raise_error;

678: IF p_date_from IS NULL
679: THEN
680: --
681: hr_utility.set_message(809, 'HXC_0056_DAR_START_DATE_MAND');
682: hr_utility.raise_error;
683: --
684: END IF;
685: --
686: IF p_date_to is not null AND p_date_from > p_date_to THEN

Line 687: hr_utility.set_message(809,'HXC_0059_DAR_TO_LESS_THAN_FROM');

683: --
684: END IF;
685: --
686: IF p_date_to is not null AND p_date_from > p_date_to THEN
687: hr_utility.set_message(809,'HXC_0059_DAR_TO_LESS_THAN_FROM');
688: hr_utility.raise_error;
689: END IF;
690: --
691: if g_debug then

Line 688: hr_utility.raise_error;

684: END IF;
685: --
686: IF p_date_to is not null AND p_date_from > p_date_to THEN
687: hr_utility.set_message(809,'HXC_0059_DAR_TO_LESS_THAN_FROM');
688: hr_utility.raise_error;
689: END IF;
690: --
691: if g_debug then
692: hr_utility.set_location('Processing:'||l_proc, 10);

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

688: hr_utility.raise_error;
689: END IF;
690: --
691: if g_debug then
692: hr_utility.set_location('Processing:'||l_proc, 10);
693: end if;
694: --
695: -- check that the value is unique
696: --

Line 747: hr_utility.set_message(809, 'HXC_ALIAS_VALUE_UNIQUE');

743: --
744: IF csr_chk_duplicate%FOUND
745: THEN
746: --
747: hr_utility.set_message(809, 'HXC_ALIAS_VALUE_UNIQUE');
748: hr_utility.raise_error;
749: --
750: END IF;
751: --

Line 748: hr_utility.raise_error;

744: IF csr_chk_duplicate%FOUND
745: THEN
746: --
747: hr_utility.set_message(809, 'HXC_ALIAS_VALUE_UNIQUE');
748: hr_utility.raise_error;
749: --
750: END IF;
751: --
752: CLOSE csr_chk_duplicate;

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

751: --
752: CLOSE csr_chk_duplicate;
753: --
754: if g_debug then
755: hr_utility.set_location('Leaving:'||l_proc, 20);
756: end if;
757: --
758: END chk_duplicate_values;
759: --

Line 771: g_debug:=hr_utility.debug_enabled;

767: --
768: l_proc varchar2(72);
769: --
770: Begin
771: g_debug:=hr_utility.debug_enabled;
772: if g_debug then
773: l_proc := g_package||'insert_validate';
774: hr_utility.set_location('Entering:'||l_proc, 5);
775: end if;

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

770: Begin
771: g_debug:=hr_utility.debug_enabled;
772: if g_debug then
773: l_proc := g_package||'insert_validate';
774: hr_utility.set_location('Entering:'||l_proc, 5);
775: end if;
776: --
777: -- Call all supporting business operations
778: --

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

835: --
836: hxc_hav_bus.chk_df(p_rec);
837: --
838: if g_debug then
839: hr_utility.set_location(' Leaving:'||l_proc, 10);
840: end if;
841: End insert_validate;
842: --
843: -- ----------------------------------------------------------------------------

Line 853: g_debug:=hr_utility.debug_enabled;

849: --
850: l_proc varchar2(72);
851: --
852: Begin
853: g_debug:=hr_utility.debug_enabled;
854: if g_debug then
855: l_proc := g_package||'update_validate';
856: hr_utility.set_location('Entering:'||l_proc, 5);
857: end if;

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

852: Begin
853: g_debug:=hr_utility.debug_enabled;
854: if g_debug then
855: l_proc := g_package||'update_validate';
856: hr_utility.set_location('Entering:'||l_proc, 5);
857: end if;
858: --
859: -- Call all supporting business operations
860: --

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

925: --
926: hxc_hav_bus.chk_df(p_rec);
927: --
928: if g_debug then
929: hr_utility.set_location(' Leaving:'||l_proc, 10);
930: end if;
931: End update_validate;
932: --
933: -- ----------------------------------------------------------------------------

Line 943: g_debug:=hr_utility.debug_enabled;

939: --
940: l_proc varchar2(72);
941: --
942: Begin
943: g_debug:=hr_utility.debug_enabled;
944: if g_debug then
945: l_proc := g_package||'delete_validate';
946: hr_utility.set_location('Entering:'||l_proc, 5);
947: end if;

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

942: Begin
943: g_debug:=hr_utility.debug_enabled;
944: if g_debug then
945: l_proc := g_package||'delete_validate';
946: hr_utility.set_location('Entering:'||l_proc, 5);
947: end if;
948: --
949: -- Call all supporting business operations
950: --

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

948: --
949: -- Call all supporting business operations
950: --
951: if g_debug then
952: hr_utility.set_location(' Leaving:'||l_proc, 10);
953: end if;
954: End delete_validate;
955: --
956: end hxc_hav_bus;