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_AVR_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_avr_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_acty_vrbl_rt_id => p_acty_vrbl_rt_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_acty_vrbl_rt_id;
78: --
79: -- ----------------------------------------------------------------------------

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

122: and p_validation_end_date >= effective_start_date;
123: --
124: Begin
125: --
126: hr_utility.set_location('Entering:'||l_proc, 5);
127: --
128: if p_acty_base_rt_id is not null then
129: open c1;
130: fetch c1 into l_dummy;

Line 139: hr_utility.set_location('Leaving:'||l_proc, 15);

135: end if;
136: close c1;
137: end if;
138: --
139: hr_utility.set_location('Leaving:'||l_proc, 15);
140: --
141: End chk_vrbl_rt_not_allowed;
142: --
143: -- ----------------------------------------------------------------------------

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

181: and effective_end_date;
182: --
183: Begin
184: --
185: hr_utility.set_location('Entering:'||l_proc, 5);
186: --
187: if p_acty_base_rt_id is not null then
188: open c1;
189: fetch c1 into l_dummy;

Line 198: hr_utility.set_location('Leaving:'||l_proc, 15);

194: end if;
195: close c1;
196: end if;
197: --
198: hr_utility.set_location('Leaving:'||l_proc, 15);
199: --
200: End chk_vrbl_rl_rt_profile;
201:
202:

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

240:
241:
242: Begin
243: --
244: hr_utility.set_location('Entering:'||l_proc,5);
245: --
246: l_api_updating := ben_avr_shd.api_updating
247: (p_acty_vrbl_rt_id => p_acty_vrbl_rt_id ,
248: p_effective_date => p_effective_date,

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

260:
261: --
262: end if;
263: --
264: hr_utility.set_location('Leaving:'||l_proc,10);
265: --
266: End chk_vrbl_rt_prfl_id;
267:
268:

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

310: and ordr_num = p_ordr_num
311: and business_group_id = p_business_group_id;
312: --
313: Begin
314: hr_utility.set_location('Entering:'||l_proc, 5);
315: --
316: open c1;
317: fetch c1 into l_dummy;
318: if c1%found then

Line 324: hr_utility.set_location('Leaving:'||l_proc, 15);

320: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
321: fnd_message.raise_error;
322: end if;
323: --
324: hr_utility.set_location('Leaving:'||l_proc, 15);
325: End chk_ordr_num_unique;
326: --
327: -- ----------------------------------------------------------------------------
328: -- |------------------------------------------------|

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

374: and mlt_cd in ('FLFX' , 'RL' ) and VRBL_RT_TRTMT_CD ='RPLC';
375: --
376: Begin
377: --
378: hr_utility.set_location('Entering:'||l_proc, 5);
379: --
380: if p_acty_base_rt_id is not null then
381: open c1;
382: fetch c1 into l_dummy;

Line 384: hr_utility.set_location(' Inside:'||l_proc, 15);

380: if p_acty_base_rt_id is not null then
381: open c1;
382: fetch c1 into l_dummy;
383: if c1%found then
384: hr_utility.set_location(' Inside:'||l_proc, 15);
385:
386: open c2;
387: fetch c2 into l_dummy;
388: if c2%notfound then

Line 402: hr_utility.set_location('Leaving:'||l_proc, 15);

398: end if;
399: close c1;
400: end if;
401: --
402: hr_utility.set_location('Leaving:'||l_proc, 15);
403: --
404: End chk_vrbl_rt_cd_for_imput_pln;
405: --
406: -- ----------------------------------------------------------------------------

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

447: and p_effective_date between avr.effective_start_date and avr.effective_end_date;
448: --
449: Begin
450: --
451: hr_utility.set_location('Entering:'||l_proc, 5);
452: --
453: -- check if the same variable rate profile is entered more than once
454: -- for the same acty_base_rt_id
455: --

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

467: end if;
468: --
469: close c_dup_vrbl_rt_prfl;
470: --
471: hr_utility.set_location('Leaving:'||l_proc,15);
472: --
473: end chk_dup_vrbl_rt_prfl;
474: --
475: -- ----------------------------------------------------------------------------

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

512: l_integrity_error Exception;
513: l_table_name all_tables.table_name%TYPE;
514: --
515: Begin
516: hr_utility.set_location('Entering:'||l_proc, 5);
517: --
518: -- Ensure that the p_datetrack_mode argument is not null
519: --
520: hr_api.mandatory_arg_error

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

561: End If;
562: --
563: End If;
564: --
565: hr_utility.set_location(' Leaving:'||l_proc, 10);
566: Exception
567: When l_integrity_error Then
568: --
569: -- A referential integrity check was violated therefore

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

629: l_rows_exist Exception;
630: l_table_name all_tables.table_name%TYPE;
631: --
632: Begin
633: hr_utility.set_location('Entering:'||l_proc, 5);
634: --
635: -- Ensure that the p_datetrack_mode argument is not null
636: --
637: hr_api.mandatory_arg_error

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

666: --
667: --
668: End If;
669: --
670: hr_utility.set_location(' Leaving:'||l_proc, 10);
671: Exception
672: When l_rows_exist Then
673: --
674: -- A referential integrity check was violated therefore

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

701: --
702: l_proc varchar2(72) := g_package||'insert_validate';
703: --
704: Begin
705: hr_utility.set_location('Entering:'||l_proc, 5);
706: --
707: -- Call all supporting business operations
708: --
709: --

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

754: p_business_group_id => p_rec.business_group_id,
755: p_effective_date => p_effective_date);
756:
757: --
758: hr_utility.set_location(' Leaving:'||l_proc, 10);
759: End insert_validate;
760: --
761: -- ----------------------------------------------------------------------------
762: -- |---------------------------< update_validate >----------------------------|

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

770: --
771: l_proc varchar2(72) := g_package||'update_validate';
772: --
773: Begin
774: hr_utility.set_location('Entering:'||l_proc, 5);
775: --
776: -- Call all supporting business operations
777: --
778: --

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

827: p_datetrack_mode => p_datetrack_mode,
828: p_validation_start_date => p_validation_start_date,
829: p_validation_end_date => p_validation_end_date);
830: --
831: hr_utility.set_location(' Leaving:'||l_proc, 10);
832: End update_validate;
833: --
834: -- ----------------------------------------------------------------------------
835: -- |---------------------------< delete_validate >----------------------------|

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

843: --
844: l_proc varchar2(72) := g_package||'delete_validate';
845: --
846: Begin
847: hr_utility.set_location('Entering:'||l_proc, 5);
848: --
849: -- Call all supporting business operations
850: --
851: dt_delete_validate

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

853: p_validation_start_date => p_validation_start_date,
854: p_validation_end_date => p_validation_end_date,
855: p_acty_vrbl_rt_id => p_rec.acty_vrbl_rt_id);
856: --
857: hr_utility.set_location(' Leaving:'||l_proc, 10);
858: End delete_validate;
859: --
860: --
861: -- ---------------------------------------------------------------------------

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

880: l_proc varchar2(72) := g_package||'return_legislation_code';
881: --
882: begin
883: --
884: hr_utility.set_location('Entering:'|| l_proc, 10);
885: --
886: -- Ensure that all the mandatory parameter are not null
887: --
888: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

905: end if;
906: --
907: close csr_leg_code;
908: --
909: hr_utility.set_location(' Leaving:'|| l_proc, 20);
910: --
911: return l_legislation_code;
912: --
913: end return_legislation_code;