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_RGR_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_rgr_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_popl_rptg_grp_id => p_popl_rptg_grp_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_popl_rptg_grp_id;
78: --
79: -- ----------------------------------------------------------------------------

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

120: and nvl(bnr.business_group_id,p_business_group_id) <> p_business_group_id ;
121: --
122: Begin
123: --
124: hr_utility.set_location('Entering:'||l_proc,5);
125: --
126: -- check if rptg_grp_id value exists in ben_rptg_grp table
127: --
128: open c1;

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

140: --
141: close c1;
142: --
143: --
144: hr_utility.set_location('Leaving:'||l_proc,10);
145: --
146: End chk_parent_rec_exists;
147: --
148:

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

187: where a.rptg_grp_id = p_rptg_grp_id;
188: --
189: Begin
190: --
191: hr_utility.set_location('Entering:'||l_proc,5);
192: --
193: l_api_updating := ben_rgr_shd.api_updating
194: (p_popl_rptg_grp_id => p_popl_rptg_grp_id,
195: p_effective_date => p_effective_date,

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

230: end if;
231: --
232: end if;
233: --
234: hr_utility.set_location('Leaving:'||l_proc,10);
235: --
236: End chk_rptg_grp_id;
237:
238: -- --------------------------------------------------------------------------

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

309: --iRec
310: --
311: Begin
312: --
313: hr_utility.set_location('Entering:'||l_proc, 5);
314: --
315: l_api_updating := ben_rgr_shd.api_updating
316: (p_effective_date => p_effective_date,
317: p_popl_rptg_grp_id => p_popl_rptg_grp_id,

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

320: if (l_api_updating
321: and p_pl_id <> ben_rgr_shd.g_old_rec.pl_id) or
322: not l_api_updating then
323: --
324: hr_utility.set_location('Entering:'||l_proc, 10);
325: --
326: -- check if this name already exist
327: --
328: open crs_pl_id;

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

371: close crs_rptg_prps;
372: --iRec
373: end if;
374: --
375: hr_utility.set_location('Leaving:'||l_proc, 20);
376: --
377: End chk_pl_id;
378: --
379: -- --------------------------------------------------------------------------

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

430: and p_validate_end_date >= effective_start_date;
431: --
432: Begin
433: --
434: hr_utility.set_location('Entering:'||l_proc, 5);
435: --
436: l_api_updating := ben_rgr_shd.api_updating
437: (p_effective_date => p_effective_date,
438: p_popl_rptg_grp_id => p_popl_rptg_grp_id,

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

441: if (l_api_updating
442: and p_pgm_id <> ben_rgr_shd.g_old_rec.pgm_id) or
443: not l_api_updating then
444: --
445: hr_utility.set_location('Entering:'||l_proc, 10);
446: --
447: -- check if this name already exist
448: --
449: open csr_pgm_id;

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

462: close csr_pgm_id;
463: --
464: end if;
465: --
466: hr_utility.set_location('Leaving:'||l_proc, 20);
467: --
468: End chk_pgm_id;
469: --
470: -- ----------------------------------------------------------------------------

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

498: l_dummy varchar2(1);
499: --
500: Begin
501: --
502: hr_utility.set_location('Entering:'||l_proc,5);
503: --
504: If p_pgm_id is null and p_pl_id is null then
505: --
506: -- raise error as both pl_id and pgm_id can't be null

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

517: --
518: --
519: end if;
520: --
521: hr_utility.set_location('Leaving:'||l_proc,10);
522: --
523: End chk_pgm_pl_id;
524: --
525: -- ----------------------------------------------------------------------------

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

562: l_integrity_error Exception;
563: l_table_name all_tables.table_name%TYPE;
564: --
565: Begin
566: hr_utility.set_location('Entering:'||l_proc, 5);
567: --
568: -- Ensure that the p_datetrack_mode argument is not null
569: --
570: hr_api.mandatory_arg_error

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

611: End If;
612: --
613: End If;
614: --
615: hr_utility.set_location(' Leaving:'||l_proc, 10);
616: Exception
617: When l_integrity_error Then
618: --
619: -- A referential integrity check was violated therefore

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

679: l_rows_exist Exception;
680: l_table_name all_tables.table_name%TYPE;
681: --
682: Begin
683: hr_utility.set_location('Entering:'||l_proc, 5);
684: --
685: -- Ensure that the p_datetrack_mode argument is not null
686: --
687: hr_api.mandatory_arg_error

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

716: --
717: --
718: End If;
719: --
720: hr_utility.set_location(' Leaving:'||l_proc, 10);
721: Exception
722: When l_rows_exist Then
723: --
724: -- A referential integrity check was violated therefore

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

751: --
752: l_proc varchar2(72) := g_package||'insert_validate';
753: --
754: Begin
755: hr_utility.set_location('Entering:'||l_proc, 5);
756: --
757: -- Call all supporting business operations
758: --
759: -- CWB Changes

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

802: p_business_group_id => p_rec.business_group_id,
803: p_effective_date => p_effective_date,
804: p_object_version_number => p_rec.object_version_number);
805: --
806: hr_utility.set_location(' Leaving:'||l_proc, 10);
807: End insert_validate;
808: --
809: -- ----------------------------------------------------------------------------
810: -- |---------------------------< update_validate >----------------------------|

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

818: --
819: l_proc varchar2(72) := g_package||'update_validate';
820: --
821: Begin
822: hr_utility.set_location('Entering:'||l_proc, 5);
823: --
824: -- Call all supporting business operations
825: --
826: -- CWB Changes

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

880: p_business_group_id => p_rec.business_group_id,
881: p_effective_date => p_effective_date,
882: p_object_version_number => p_rec.object_version_number);
883: --
884: hr_utility.set_location(' Leaving:'||l_proc, 10);
885: End update_validate;
886: --
887: -- ----------------------------------------------------------------------------
888: -- |---------------------------< delete_validate >----------------------------|

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

896: --
897: l_proc varchar2(72) := g_package||'delete_validate';
898: --
899: Begin
900: hr_utility.set_location('Entering:'||l_proc, 5);
901: --
902: -- Call all supporting business operations
903: --
904: dt_delete_validate

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

906: p_validation_start_date => p_validation_start_date,
907: p_validation_end_date => p_validation_end_date,
908: p_popl_rptg_grp_id => p_rec.popl_rptg_grp_id);
909: --
910: hr_utility.set_location(' Leaving:'||l_proc, 10);
911: End delete_validate;
912: --
913: --
914: -- ---------------------------------------------------------------------------

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

933: l_proc varchar2(72) := g_package||'return_legislation_code';
934: --
935: begin
936: --
937: hr_utility.set_location('Entering:'|| l_proc, 10);
938: --
939: -- Ensure that all the mandatory parameter are not null
940: --
941: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

960: */
961: --
962: close csr_leg_code;
963: --
964: hr_utility.set_location(' Leaving:'|| l_proc, 20);
965: --
966: return l_legislation_code;
967: --
968: end return_legislation_code;