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_LBC_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_lbc_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_ler_bnft_rstrn_ctfn_id => p_ler_bnft_rstrn_ctfn_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_ler_bnft_rstrn_ctfn_id;
78: --
79: -- ----------------------------------------------------------------------------

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

111: l_api_updating boolean;
112: --
113: Begin
114: --
115: hr_utility.set_location('Entering:'||l_proc, 5);
116: --
117: l_api_updating := ben_lbc_shd.api_updating
118: (p_ler_bnft_rstrn_ctfn_id => p_ler_bnft_rstrn_ctfn_id,
119: p_effective_date => p_effective_date,

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

142: end if;
143: --
144: end if;
145: --
146: hr_utility.set_location('Leaving:'||l_proc,10);
147: --
148: end chk_rqd_flag;
149: --
150: -- ----------------------------------------------------------------------------

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

183: l_api_updating boolean;
184: --
185: Begin
186: --
187: hr_utility.set_location('Entering:'||l_proc, 5);
188: --
189: l_api_updating := ben_lbc_shd.api_updating
190: (p_ler_bnft_rstrn_ctfn_id => p_ler_bnft_rstrn_ctfn_id,
191: p_effective_date => p_effective_date,

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

215: end if;
216: --
217: end if;
218: --
219: hr_utility.set_location('Leaving:'||l_proc,10);
220: --
221: end chk_ctfn_rqd_when_rl;
222: --
223: -- ----------------------------------------------------------------------------

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

255: l_api_updating boolean;
256: --
257: Begin
258: --
259: hr_utility.set_location('Entering:'||l_proc, 5);
260: --
261: l_api_updating := ben_lbc_shd.api_updating
262: (p_ler_bnft_rstrn_ctfn_id => p_ler_bnft_rstrn_ctfn_id,
263: p_effective_date => p_effective_date,

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

286: end if;
287: --
288: end if;
289: --
290: hr_utility.set_location('Leaving:'||l_proc,10);
291: --
292: end chk_enrt_ctfn_typ_cd;
293: --
294: -- ----------------------------------------------------------------------------

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

342: and p_validation_start_date <= effective_end_date
343: and p_validation_end_date >= effective_start_date;
344: --
345: Begin
346: hr_utility.set_location('Entering:'||l_proc, 5);
347: --
348: open c1;
349: fetch c1 into l_dummy;
350: if c1%found then

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

352: fnd_message.set_name('BEN','BEN_92338_CD_AND_RL_UNIQUE');
353: fnd_message.raise_error;
354: end if;
355: --
356: hr_utility.set_location('Leaving:'||l_proc, 15);
357: End chk_cd_and_rl_unique;
358: --
359: -- ----------------------------------------------------------------------------
360: -- |--------------------------< dt_update_validate >--------------------------|

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

395: l_integrity_error Exception;
396: l_table_name all_tables.table_name%TYPE;
397: --
398: Begin
399: hr_utility.set_location('Entering:'||l_proc, 5);
400: --
401: -- Ensure that the p_datetrack_mode argument is not null
402: --
403: hr_api.mandatory_arg_error

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

434: End If;
435: --
436: End If;
437: --
438: hr_utility.set_location(' Leaving:'||l_proc, 10);
439: Exception
440: When l_integrity_error Then
441: --
442: -- A referential integrity check was violated therefore

Line 445: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');

441: --
442: -- A referential integrity check was violated therefore
443: -- we must error
444: --
445: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
446: hr_utility.set_message_token('TABLE_NAME', l_table_name);
447: hr_utility.raise_error;
448: When Others Then
449: --

Line 446: hr_utility.set_message_token('TABLE_NAME', l_table_name);

442: -- A referential integrity check was violated therefore
443: -- we must error
444: --
445: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
446: hr_utility.set_message_token('TABLE_NAME', l_table_name);
447: hr_utility.raise_error;
448: When Others Then
449: --
450: -- An unhandled or unexpected error has occurred which

Line 447: hr_utility.raise_error;

443: -- we must error
444: --
445: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
446: hr_utility.set_message_token('TABLE_NAME', l_table_name);
447: hr_utility.raise_error;
448: When Others Then
449: --
450: -- An unhandled or unexpected error has occurred which
451: -- we must report

Line 453: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

449: --
450: -- An unhandled or unexpected error has occurred which
451: -- we must report
452: --
453: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
454: hr_utility.set_message_token('PROCEDURE', l_proc);
455: hr_utility.set_message_token('STEP','15');
456: hr_utility.raise_error;
457: End dt_update_validate;

Line 454: hr_utility.set_message_token('PROCEDURE', l_proc);

450: -- An unhandled or unexpected error has occurred which
451: -- we must report
452: --
453: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
454: hr_utility.set_message_token('PROCEDURE', l_proc);
455: hr_utility.set_message_token('STEP','15');
456: hr_utility.raise_error;
457: End dt_update_validate;
458: --

Line 455: hr_utility.set_message_token('STEP','15');

451: -- we must report
452: --
453: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
454: hr_utility.set_message_token('PROCEDURE', l_proc);
455: hr_utility.set_message_token('STEP','15');
456: hr_utility.raise_error;
457: End dt_update_validate;
458: --
459: -- ----------------------------------------------------------------------------

Line 456: hr_utility.raise_error;

452: --
453: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
454: hr_utility.set_message_token('PROCEDURE', l_proc);
455: hr_utility.set_message_token('STEP','15');
456: hr_utility.raise_error;
457: End dt_update_validate;
458: --
459: -- ----------------------------------------------------------------------------
460: -- |--------------------------< dt_delete_validate >--------------------------|

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

501: l_rows_exist Exception;
502: l_table_name all_tables.table_name%TYPE;
503: --
504: Begin
505: hr_utility.set_location('Entering:'||l_proc, 5);
506: --
507: -- Ensure that the p_datetrack_mode argument is not null
508: --
509: hr_api.mandatory_arg_error

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

538: --
539: --
540: End If;
541: --
542: hr_utility.set_location(' Leaving:'||l_proc, 10);
543: Exception
544: When l_rows_exist Then
545: --
546: -- A referential integrity check was violated therefore

Line 549: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');

545: --
546: -- A referential integrity check was violated therefore
547: -- we must error
548: --
549: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
550: hr_utility.set_message_token('TABLE_NAME', l_table_name);
551: hr_utility.raise_error;
552: When Others Then
553: --

Line 550: hr_utility.set_message_token('TABLE_NAME', l_table_name);

546: -- A referential integrity check was violated therefore
547: -- we must error
548: --
549: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
550: hr_utility.set_message_token('TABLE_NAME', l_table_name);
551: hr_utility.raise_error;
552: When Others Then
553: --
554: -- An unhandled or unexpected error has occurred which

Line 551: hr_utility.raise_error;

547: -- we must error
548: --
549: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
550: hr_utility.set_message_token('TABLE_NAME', l_table_name);
551: hr_utility.raise_error;
552: When Others Then
553: --
554: -- An unhandled or unexpected error has occurred which
555: -- we must report

Line 557: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

553: --
554: -- An unhandled or unexpected error has occurred which
555: -- we must report
556: --
557: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
558: hr_utility.set_message_token('PROCEDURE', l_proc);
559: hr_utility.set_message_token('STEP','15');
560: hr_utility.raise_error;
561: End dt_delete_validate;

Line 558: hr_utility.set_message_token('PROCEDURE', l_proc);

554: -- An unhandled or unexpected error has occurred which
555: -- we must report
556: --
557: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
558: hr_utility.set_message_token('PROCEDURE', l_proc);
559: hr_utility.set_message_token('STEP','15');
560: hr_utility.raise_error;
561: End dt_delete_validate;
562: --

Line 559: hr_utility.set_message_token('STEP','15');

555: -- we must report
556: --
557: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
558: hr_utility.set_message_token('PROCEDURE', l_proc);
559: hr_utility.set_message_token('STEP','15');
560: hr_utility.raise_error;
561: End dt_delete_validate;
562: --
563: -- ----------------------------------------------------------------------------

Line 560: hr_utility.raise_error;

556: --
557: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
558: hr_utility.set_message_token('PROCEDURE', l_proc);
559: hr_utility.set_message_token('STEP','15');
560: hr_utility.raise_error;
561: End dt_delete_validate;
562: --
563: -- ----------------------------------------------------------------------------
564: -- |---------------------------< insert_validate >----------------------------|

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

572: --
573: l_proc varchar2(72) := g_package||'insert_validate';
574: --
575: Begin
576: hr_utility.set_location('Entering:'||l_proc, 5);
577: --
578: -- Call all supporting business operations
579: --
580: --

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

612: p_enrt_ctfn_typ_cd => p_rec.enrt_ctfn_typ_cd,
613: p_ctfn_rqd_when_rl => p_rec.ctfn_rqd_when_rl,
614: p_business_group_id => p_rec.business_group_id);
615: --
616: hr_utility.set_location(' Leaving:'||l_proc, 10);
617: End insert_validate;
618: --
619: -- ----------------------------------------------------------------------------
620: -- |---------------------------< update_validate >----------------------------|

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

628: --
629: l_proc varchar2(72) := g_package||'update_validate';
630: --
631: Begin
632: hr_utility.set_location('Entering:'||l_proc, 5);
633: --
634: -- Call all supporting business operations
635: --
636: --

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

676: p_datetrack_mode => p_datetrack_mode,
677: p_validation_start_date => p_validation_start_date,
678: p_validation_end_date => p_validation_end_date);
679: --
680: hr_utility.set_location(' Leaving:'||l_proc, 10);
681: End update_validate;
682: --
683: -- ----------------------------------------------------------------------------
684: -- |---------------------------< delete_validate >----------------------------|

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

692: --
693: l_proc varchar2(72) := g_package||'delete_validate';
694: --
695: Begin
696: hr_utility.set_location('Entering:'||l_proc, 5);
697: --
698: -- Call all supporting business operations
699: --
700: dt_delete_validate

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

702: p_validation_start_date => p_validation_start_date,
703: p_validation_end_date => p_validation_end_date,
704: p_ler_bnft_rstrn_ctfn_id => p_rec.ler_bnft_rstrn_ctfn_id);
705: --
706: hr_utility.set_location(' Leaving:'||l_proc, 10);
707: End delete_validate;
708: --
709: --
710: -- ---------------------------------------------------------------------------

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

729: l_proc varchar2(72) := g_package||'return_legislation_code';
730: --
731: begin
732: --
733: hr_utility.set_location('Entering:'|| l_proc, 10);
734: --
735: -- Ensure that all the mandatory parameter are not null
736: --
737: hr_api.mandatory_arg_error(p_api_name => l_proc,

Line 751: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');

747: close csr_leg_code;
748: --
749: -- The primary key is invalid therefore we must error
750: --
751: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
752: hr_utility.raise_error;
753: --
754: end if;
755: --

Line 752: hr_utility.raise_error;

748: --
749: -- The primary key is invalid therefore we must error
750: --
751: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
752: hr_utility.raise_error;
753: --
754: end if;
755: --
756: close csr_leg_code;

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

754: end if;
755: --
756: close csr_leg_code;
757: --
758: hr_utility.set_location(' Leaving:'|| l_proc, 20);
759: --
760: return l_legislation_code;
761: --
762: end return_legislation_code;