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_EBN_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_ebn_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_elig_benfts_grp_prte_id => p_elig_benfts_grp_prte_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_elig_benfts_grp_prte_id;
78: --
79: -- ----------------------------------------------------------------------------

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

136: ;
137: --
138: Begin
139: --
140: hr_utility.set_location('Entering:'||l_proc,5);
141: --
142: l_api_updating := ben_ebn_shd.api_updating
143: (p_elig_benfts_grp_prte_id => p_elig_benfts_grp_prte_id,
144: p_effective_date => p_effective_date,

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

183: close c3;
184: --
185: end if;
186: --
187: hr_utility.set_location('Leaving:'||l_proc,10);
188: --
189: End chk_benfts_grp_id;
190: --
191: -- ----------------------------------------------------------------------------

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

223: l_api_updating boolean;
224: --
225: Begin
226: --
227: hr_utility.set_location('Entering:'||l_proc, 5);
228: --
229: l_api_updating := ben_ebn_shd.api_updating
230: (p_elig_benfts_grp_prte_id => p_elig_benfts_grp_prte_id,
231: p_effective_date => p_effective_date,

Line 249: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');

245: p_effective_date => p_effective_date) then
246: --
247: -- raise error as does not exist as lookup
248: --
249: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
250: hr_utility.raise_error;
251: --
252: end if;
253: --

Line 250: hr_utility.raise_error;

246: --
247: -- raise error as does not exist as lookup
248: --
249: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
250: hr_utility.raise_error;
251: --
252: end if;
253: --
254: end if;

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

252: end if;
253: --
254: end if;
255: --
256: hr_utility.set_location('Leaving:'||l_proc,10);
257: --
258: end chk_excld_flag;
259: --
260: --Bug:5054189

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

301: and ordr_num = p_ordr_num
302: and business_group_id = p_business_group_id;
303: --
304: Begin
305: hr_utility.set_location('Entering:'||l_proc, 5);
306: --
307: open c1;
308: fetch c1 into l_dummy;
309: if c1%found then

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

312: fnd_message.raise_error;
313: end if;
314: close c1;
315: --
316: hr_utility.set_location('Leaving:'||l_proc, 15);
317: End chk_duplicate_ordr_num;
318: -- ----------------------------------------------------------------------------
319: -- |--------------------------< dt_update_validate >--------------------------|
320: -- ----------------------------------------------------------------------------

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

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

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

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

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

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

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

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

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

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

Line 414: hr_utility.raise_error;

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

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

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

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

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

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

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

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

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

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

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

Line 517: hr_utility.raise_error;

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

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

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

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

563: ,p_eligy_prfl_id => p_rec.eligy_prfl_id
564: ,p_ordr_num => p_rec.ordr_num
565: ,p_business_group_id => p_rec.business_group_id);
566: --
567: hr_utility.set_location(' Leaving:'||l_proc, 10);
568: End insert_validate;
569: --
570: -- ----------------------------------------------------------------------------
571: -- |---------------------------< update_validate >----------------------------|

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

579: --
580: l_proc varchar2(72) := g_package||'update_validate';
581: --
582: Begin
583: hr_utility.set_location('Entering:'||l_proc, 5);
584: --
585: -- Call all supporting business operations
586: --
587: --

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

620: p_datetrack_mode => p_datetrack_mode,
621: p_validation_start_date => p_validation_start_date,
622: p_validation_end_date => p_validation_end_date);
623: --
624: hr_utility.set_location(' Leaving:'||l_proc, 10);
625: End update_validate;
626: --
627: -- ----------------------------------------------------------------------------
628: -- |---------------------------< delete_validate >----------------------------|

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

636: --
637: l_proc varchar2(72) := g_package||'delete_validate';
638: --
639: Begin
640: hr_utility.set_location('Entering:'||l_proc, 5);
641: --
642: -- Call all supporting business operations
643: --
644: dt_delete_validate

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

646: p_validation_start_date => p_validation_start_date,
647: p_validation_end_date => p_validation_end_date,
648: p_elig_benfts_grp_prte_id => p_rec.elig_benfts_grp_prte_id);
649: --
650: hr_utility.set_location(' Leaving:'||l_proc, 10);
651: End delete_validate;
652: --
653: --
654: -- ---------------------------------------------------------------------------

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

673: l_proc varchar2(72) := g_package||'return_legislation_code';
674: --
675: begin
676: --
677: hr_utility.set_location('Entering:'|| l_proc, 10);
678: --
679: -- Ensure that all the mandatory parameter are not null
680: --
681: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

691: close csr_leg_code;
692: --
693: -- The primary key is invalid therefore we must error
694: --
695: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
696: hr_utility.raise_error;
697: --
698: end if;
699: --

Line 696: hr_utility.raise_error;

692: --
693: -- The primary key is invalid therefore we must error
694: --
695: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
696: hr_utility.raise_error;
697: --
698: end if;
699: --
700: close csr_leg_code;

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

698: end if;
699: --
700: close csr_leg_code;
701: --
702: hr_utility.set_location(' Leaving:'|| l_proc, 20);
703: --
704: return l_legislation_code;
705: --
706: end return_legislation_code;