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.BEN_DCE_BUS dependencies on HR_UTILITY

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

42: l_api_updating boolean;
43: --
44: Begin
45: --
46: hr_utility.set_location('Entering:'||l_proc, 5);
47: --
48: l_api_updating := ben_dce_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_dpnt_cvg_eligy_prfl_id => p_dpnt_cvg_eligy_prfl_id,

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

71: end if;
72: --
73: end if;
74: --
75: hr_utility.set_location('Leaving:'||l_proc, 10);
76: --
77: End chk_dpnt_cvg_eligy_prfl_id;
78: --
79: -- ----------------------------------------------------------------------------

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

128: and ff.effective_end_date;
129: --
130: Begin
131: --
132: hr_utility.set_location('Entering:'||l_proc, 5);
133: --
134: l_api_updating := ben_dce_shd.api_updating
135: (p_dpnt_cvg_eligy_prfl_id => p_dpnt_cvg_eligy_prfl_id,
136: p_effective_date => p_effective_date,

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

166: close c1;
167: --
168: end if;
169: --
170: hr_utility.set_location('Leaving:'||l_proc,10);
171: --
172: end chk_dpnt_cvg_elig_det_rl;
173: --
174: -- ----------------------------------------------------------------------------

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

206: l_api_updating boolean;
207: --
208: Begin
209: --
210: hr_utility.set_location('Entering:'||l_proc, 5);
211: --
212: l_api_updating := ben_dce_shd.api_updating
213: (p_dpnt_cvg_eligy_prfl_id => p_dpnt_cvg_eligy_prfl_id,
214: p_effective_date => p_effective_date,

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

235: end if;
236: --
237: end if;
238: --
239: hr_utility.set_location('Leaving:'||l_proc,10);
240: --
241: end chk_dpnt_cvg_eligy_prfl_stat;
242:
243: --

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

292: and p_validate_end_date >= effective_start_date;
293: --
294: Begin
295: --
296: hr_utility.set_location('Entering:'||l_proc, 5);
297: --
298: l_api_updating := ben_dce_shd.api_updating
299: (p_dpnt_cvg_eligy_prfl_id => p_dpnt_cvg_eligy_prfl_id,
300: p_effective_date => p_effective_date,

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

302: --
303: if (l_api_updating
304: and p_name <> ben_dce_shd.g_old_rec.name)
305: or not l_api_updating then
306: hr_utility.set_location('Entering:' || l_proc,10);
307: --
308: -- Check if this name already exists.
309: --
310: open csr_name;

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

319: close csr_name;
320: --
321: end if;
322: --
323: hr_utility.set_location('Leaving:'||l_proc,20);
324: --
325: end chk_name;
326:
327: --

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

373: l_api_updating boolean;
374: --
375: Begin
376: --
377: hr_utility.set_location('Entering:'||l_proc, 5);
378: --
379: --
380: if hr_api.not_exists_in_hr_lookups
381: (p_lookup_type => 'YES_NO',

Line 500: hr_utility.set_location(' Leaving:'||l_proc, 5);

496: fnd_message.raise_error;
497: --
498: end if;
499:
500: hr_utility.set_location(' Leaving:'||l_proc, 5);
501: End Chk_lookups;
502: -- |--------------------------< dt_update_validate >--------------------------|
503: -- ----------------------------------------------------------------------------
504: -- {Start Of Comments}

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

537: l_integrity_error Exception;
538: l_table_name all_tables.table_name%TYPE;
539: --
540: Begin
541: hr_utility.set_location('Entering:'||l_proc, 5);
542: --
543: -- Ensure that the p_datetrack_mode argument is not null
544: --
545: hr_api.mandatory_arg_error

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

576: End If;
577: --
578: End If;
579: --
580: hr_utility.set_location(' Leaving:'||l_proc, 10);
581: Exception
582: When l_integrity_error Then
583: --
584: -- A referential integrity check was violated therefore

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

642: l_rows_exist Exception;
643: l_table_name all_tables.table_name%TYPE;
644: --
645: Begin
646: hr_utility.set_location('Entering:'||l_proc, 5);
647: --
648: -- Ensure that the p_datetrack_mode argument is not null
649: --
650: hr_api.mandatory_arg_error

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

764: */
765: --
766: End If;
767: --
768: hr_utility.set_location(' Leaving:'||l_proc, 10);
769: Exception
770: When l_rows_exist Then
771: --
772: -- A referential integrity check was violated therefore

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

797: --
798: l_proc varchar2(72) := g_package||'insert_validate';
799: --
800: Begin
801: hr_utility.set_location('Entering:'||l_proc, 5);
802: --
803: -- Call all supporting business operations
804: --
805: --

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

844: p_dpnt_cvrd_in_anthr_pl_flag =>p_rec.dpnt_cvrd_in_anthr_pl_flag,
845: p_dpnt_dsgnt_crntly_enrld_flag =>p_rec.dpnt_dsgnt_crntly_enrld_flag,
846: p_effective_date =>p_effective_date);
847: --
848: hr_utility.set_location(' Leaving:'||l_proc, 10);
849: End insert_validate;
850: --
851: -- ----------------------------------------------------------------------------
852: -- |---------------------------< update_validate >----------------------------|

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

860: --
861: l_proc varchar2(72) := g_package||'update_validate';
862: --
863: Begin
864: hr_utility.set_location('Entering:'||l_proc, 5);
865: --
866: -- Call all supporting business operations
867: --
868: --

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

915: p_datetrack_mode => p_datetrack_mode,
916: p_validation_start_date => p_validation_start_date,
917: p_validation_end_date => p_validation_end_date);
918: --
919: hr_utility.set_location(' Leaving:'||l_proc, 10);
920: End update_validate;
921: --
922: -- ----------------------------------------------------------------------------
923: -- |---------------------------< delete_validate >----------------------------|

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

931: --
932: l_proc varchar2(72) := g_package||'delete_validate';
933: --
934: Begin
935: hr_utility.set_location('Entering:'||l_proc, 5);
936: --
937: -- Call all supporting business operations
938: --
939: dt_delete_validate

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

941: p_validation_start_date => p_validation_start_date,
942: p_validation_end_date => p_validation_end_date,
943: p_dpnt_cvg_eligy_prfl_id => p_rec.dpnt_cvg_eligy_prfl_id);
944: --
945: hr_utility.set_location(' Leaving:'||l_proc, 10);
946: End delete_validate;
947: --
948: --
949: -- ---------------------------------------------------------------------------

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

968: l_proc varchar2(72) := g_package||'return_legislation_code';
969: --
970: begin
971: --
972: hr_utility.set_location('Entering:'|| l_proc, 10);
973: --
974: -- Ensure that all the mandatory parameter are not null
975: --
976: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

993: end if;
994: --
995: close csr_leg_code;
996: --
997: hr_utility.set_location(' Leaving:'|| l_proc, 20);
998: --
999: return l_legislation_code;
1000: --
1001: end return_legislation_code;