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_BRR_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_brr_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_bnft_vrbl_rt_rl_id => p_bnft_vrbl_rt_rl_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_vrbl_rt_rl_id;
78: --
79: -- ---------------------------------------------------------------------------

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

118: and ordr_to_aply_num = p_ordr_to_aply_num
119: and business_group_id = p_business_group_id;
120: --
121: Begin
122: hr_utility.set_location('Entering:'||l_proc, 5);
123: --
124: open c1;
125: fetch c1 into l_dummy;
126: if c1%found then

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

128: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
129: fnd_message.raise_error;
130: end if;
131: --
132: hr_utility.set_location('Leaving:'||l_proc, 15);
133: End chk_ordr_to_aply_num_unique;
134: --
135: -- ----------------------------------------------------------------------------
136: -- |------------------------< chk_brr_bvr_mutexcl >--------------------------|

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

182: and a.effective_end_date;
183: --
184: Begin
185: --
186: hr_utility.set_location('Entering:'||l_proc, 5);
187: --
188: l_api_updating := ben_brr_shd.api_updating
189: (p_effective_date => p_effective_date,
190: p_bnft_vrbl_rt_rl_id => p_bnft_vrbl_rt_rl_id,

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

213: close c1;
214: --
215: end if;
216: --
217: hr_utility.set_location('Leaving:'||l_proc, 10);
218: --
219: End chk_brr_bvr_mutexcl;
220: --
221: -- ----------------------------------------------------------------------------

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

270: and ff.effective_end_date;
271: --
272: Begin
273: --
274: hr_utility.set_location('Entering:'||l_proc, 5);
275: --
276: l_api_updating := ben_brr_shd.api_updating
277: (p_bnft_vrbl_rt_rl_id => p_bnft_vrbl_rt_rl_id,
278: p_effective_date => p_effective_date,

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

306: close c1;
307: --
308: end if;
309: --
310: hr_utility.set_location('Leaving:'||l_proc,10);
311: --
312: end chk_formula_id;
313: --
314: -- ----------------------------------------------------------------------------

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

350: l_integrity_error Exception;
351: l_table_name all_tables.table_name%TYPE;
352: --
353: Begin
354: hr_utility.set_location('Entering:'||l_proc, 5);
355: --
356: -- Ensure that the p_datetrack_mode argument is not null
357: --
358: hr_api.mandatory_arg_error

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

389: End If;
390: --
391: End If;
392: --
393: hr_utility.set_location(' Leaving:'||l_proc, 10);
394: Exception
395: When l_integrity_error Then
396: --
397: -- A referential integrity check was violated therefore

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

396: --
397: -- A referential integrity check was violated therefore
398: -- we must error
399: --
400: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
401: hr_utility.set_message_token('TABLE_NAME', l_table_name);
402: hr_utility.raise_error;
403: When Others Then
404: --

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

397: -- A referential integrity check was violated therefore
398: -- we must error
399: --
400: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
401: hr_utility.set_message_token('TABLE_NAME', l_table_name);
402: hr_utility.raise_error;
403: When Others Then
404: --
405: -- An unhandled or unexpected error has occurred which

Line 402: hr_utility.raise_error;

398: -- we must error
399: --
400: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
401: hr_utility.set_message_token('TABLE_NAME', l_table_name);
402: hr_utility.raise_error;
403: When Others Then
404: --
405: -- An unhandled or unexpected error has occurred which
406: -- we must report

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

404: --
405: -- An unhandled or unexpected error has occurred which
406: -- we must report
407: --
408: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
409: hr_utility.set_message_token('PROCEDURE', l_proc);
410: hr_utility.set_message_token('STEP','15');
411: hr_utility.raise_error;
412: End dt_update_validate;

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

405: -- An unhandled or unexpected error has occurred which
406: -- we must report
407: --
408: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
409: hr_utility.set_message_token('PROCEDURE', l_proc);
410: hr_utility.set_message_token('STEP','15');
411: hr_utility.raise_error;
412: End dt_update_validate;
413: --

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

406: -- we must report
407: --
408: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
409: hr_utility.set_message_token('PROCEDURE', l_proc);
410: hr_utility.set_message_token('STEP','15');
411: hr_utility.raise_error;
412: End dt_update_validate;
413: --
414: -- ----------------------------------------------------------------------------

Line 411: hr_utility.raise_error;

407: --
408: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
409: hr_utility.set_message_token('PROCEDURE', l_proc);
410: hr_utility.set_message_token('STEP','15');
411: hr_utility.raise_error;
412: End dt_update_validate;
413: --
414: -- ----------------------------------------------------------------------------
415: -- |--------------------------< dt_delete_validate >--------------------------|

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

456: l_rows_exist Exception;
457: l_table_name all_tables.table_name%TYPE;
458: --
459: Begin
460: hr_utility.set_location('Entering:'||l_proc, 5);
461: --
462: -- Ensure that the p_datetrack_mode argument is not null
463: --
464: hr_api.mandatory_arg_error

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

493: --
494: --
495: End If;
496: --
497: hr_utility.set_location(' Leaving:'||l_proc, 10);
498: Exception
499: When l_rows_exist Then
500: --
501: -- A referential integrity check was violated therefore

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

500: --
501: -- A referential integrity check was violated therefore
502: -- we must error
503: --
504: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
505: hr_utility.set_message_token('TABLE_NAME', l_table_name);
506: hr_utility.raise_error;
507: When Others Then
508: --

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

501: -- A referential integrity check was violated therefore
502: -- we must error
503: --
504: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
505: hr_utility.set_message_token('TABLE_NAME', l_table_name);
506: hr_utility.raise_error;
507: When Others Then
508: --
509: -- An unhandled or unexpected error has occurred which

Line 506: hr_utility.raise_error;

502: -- we must error
503: --
504: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
505: hr_utility.set_message_token('TABLE_NAME', l_table_name);
506: hr_utility.raise_error;
507: When Others Then
508: --
509: -- An unhandled or unexpected error has occurred which
510: -- we must report

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

508: --
509: -- An unhandled or unexpected error has occurred which
510: -- we must report
511: --
512: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
513: hr_utility.set_message_token('PROCEDURE', l_proc);
514: hr_utility.set_message_token('STEP','15');
515: hr_utility.raise_error;
516: End dt_delete_validate;

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

509: -- An unhandled or unexpected error has occurred which
510: -- we must report
511: --
512: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
513: hr_utility.set_message_token('PROCEDURE', l_proc);
514: hr_utility.set_message_token('STEP','15');
515: hr_utility.raise_error;
516: End dt_delete_validate;
517: --

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

510: -- we must report
511: --
512: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
513: hr_utility.set_message_token('PROCEDURE', l_proc);
514: hr_utility.set_message_token('STEP','15');
515: hr_utility.raise_error;
516: End dt_delete_validate;
517: --
518: -- ----------------------------------------------------------------------------

Line 515: hr_utility.raise_error;

511: --
512: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
513: hr_utility.set_message_token('PROCEDURE', l_proc);
514: hr_utility.set_message_token('STEP','15');
515: hr_utility.raise_error;
516: End dt_delete_validate;
517: --
518: -- ----------------------------------------------------------------------------
519: -- |---------------------------< insert_validate >----------------------------|

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

527: --
528: l_proc varchar2(72) := g_package||'insert_validate';
529: --
530: Begin
531: hr_utility.set_location('Entering:'||l_proc, 5);
532: --
533: -- Call all supporting business operations
534: --
535: --

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

559: p_business_group_id => p_rec.business_group_id,
560: p_effective_date => p_effective_date,
561: p_object_version_number => p_rec.object_version_number);
562: --
563: hr_utility.set_location(' Leaving:'||l_proc, 10);
564: End insert_validate;
565: --
566: -- ----------------------------------------------------------------------------
567: -- |---------------------------< update_validate >----------------------------|

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

575: --
576: l_proc varchar2(72) := g_package||'update_validate';
577: --
578: Begin
579: hr_utility.set_location('Entering:'||l_proc, 5);
580: --
581: -- Call all supporting business operations
582: --
583: --

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

615: p_datetrack_mode => p_datetrack_mode,
616: p_validation_start_date => p_validation_start_date,
617: p_validation_end_date => p_validation_end_date);
618: --
619: hr_utility.set_location(' Leaving:'||l_proc, 10);
620: End update_validate;
621: --
622: -- ----------------------------------------------------------------------------
623: -- |---------------------------< delete_validate >----------------------------|

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

631: --
632: l_proc varchar2(72) := g_package||'delete_validate';
633: --
634: Begin
635: hr_utility.set_location('Entering:'||l_proc, 5);
636: --
637: -- Call all supporting business operations
638: --
639: dt_delete_validate

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

641: p_validation_start_date => p_validation_start_date,
642: p_validation_end_date => p_validation_end_date,
643: p_bnft_vrbl_rt_rl_id => p_rec.bnft_vrbl_rt_rl_id);
644: --
645: hr_utility.set_location(' Leaving:'||l_proc, 10);
646: End delete_validate;
647: --
648: --
649: -- ---------------------------------------------------------------------------

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

668: l_proc varchar2(72) := g_package||'return_legislation_code';
669: --
670: begin
671: --
672: hr_utility.set_location('Entering:'|| l_proc, 10);
673: --
674: -- Ensure that all the mandatory parameter are not null
675: --
676: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

686: close csr_leg_code;
687: --
688: -- The primary key is invalid therefore we must error
689: --
690: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
691: hr_utility.raise_error;
692: --
693: end if;
694: --

Line 691: hr_utility.raise_error;

687: --
688: -- The primary key is invalid therefore we must error
689: --
690: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
691: hr_utility.raise_error;
692: --
693: end if;
694: --
695: close csr_leg_code;

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

693: end if;
694: --
695: close csr_leg_code;
696: --
697: hr_utility.set_location(' Leaving:'|| l_proc, 20);
698: --
699: return l_legislation_code;
700: --
701: end return_legislation_code;