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.

[Home] [Help]

APPS.BEN_BRC_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_brc_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_bnft_rstrn_ctfn_id => p_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_bnft_rstrn_ctfn_id;
78: --
79: -- ----------------------------------------------------------------------------

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

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

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

144: end if;
145: --
146: end if;
147: --
148: hr_utility.set_location('Leaving:'||l_proc,10);
149: --
150: end chk_ctfn_rqd_when_rl;
151: --
152: -- ----------------------------------------------------------------------------

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

184: l_api_updating boolean;
185: --
186: Begin
187: --
188: hr_utility.set_location('Entering:'||l_proc, 5);
189: --
190: l_api_updating := ben_brc_shd.api_updating
191: (p_bnft_rstrn_ctfn_id => p_bnft_rstrn_ctfn_id,
192: 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_enrt_ctfn_typ_cd;
222: --
223: -- ----------------------------------------------------------------------------

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

271: and p_validation_start_date <= effective_end_date
272: and p_validation_end_date >= effective_start_date;
273: --
274: Begin
275: hr_utility.set_location('Entering:'||l_proc, 5);
276: --
277: open c1;
278: fetch c1 into l_dummy;
279: if c1%found then

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

281: fnd_message.set_name('BEN','BEN_92338_CD_AND_RL_UNIQUE');
282: fnd_message.raise_error;
283: end if;
284: --
285: hr_utility.set_location('Leaving:'||l_proc, 15);
286: End chk_cd_and_rl_unique;
287: --
288: -- ----------------------------------------------------------------------------
289: -- |------< chk_rqd_flag >------|

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

320: l_api_updating boolean;
321: --
322: Begin
323: --
324: hr_utility.set_location('Entering:'||l_proc, 5);
325: --
326: l_api_updating := ben_brc_shd.api_updating
327: (p_bnft_rstrn_ctfn_id => p_bnft_rstrn_ctfn_id,
328: p_effective_date => p_effective_date,

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

351: end if;
352: --
353: end if;
354: --
355: hr_utility.set_location('Leaving:'||l_proc,10);
356: --
357: end chk_rqd_flag;
358: --
359: -- ----------------------------------------------------------------------------

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 451: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

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

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

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

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

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

Line 454: hr_utility.raise_error;

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

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

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

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

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

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

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

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

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

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

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

Line 557: hr_utility.raise_error;

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

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

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

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

609: p_rqd_flag => p_rec.rqd_flag,
610: p_effective_date => p_effective_date,
611: p_object_version_number => p_rec.object_version_number);
612: --
613: hr_utility.set_location(' Leaving:'||l_proc, 10);
614: End insert_validate;
615: --
616: -- ----------------------------------------------------------------------------
617: -- |---------------------------< update_validate >----------------------------|

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

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

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

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

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

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

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

699: p_validation_start_date => p_validation_start_date,
700: p_validation_end_date => p_validation_end_date,
701: p_bnft_rstrn_ctfn_id => p_rec.bnft_rstrn_ctfn_id);
702: --
703: hr_utility.set_location(' Leaving:'||l_proc, 10);
704: End delete_validate;
705: --
706: --
707: -- ---------------------------------------------------------------------------

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

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

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

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

Line 749: hr_utility.raise_error;

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

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

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