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_CEP_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_CEP_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_prtn_elig_prfl_id => p_prtn_elig_prfl_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_prtn_elig_prfl_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_CEP_shd.api_updating
118: (p_prtn_elig_prfl_id => p_prtn_elig_prfl_id,
119: p_effective_date => p_effective_date,

Line 143: --hr_utility.set_message(801,'MNDTRY_FLAG_NOT_EXIST');

139: fnd_message.set_token('VALUE', p_mndtry_flag);
140: fnd_message.set_token('TYPE', 'YES_NO');
141: fnd_message.raise_error;
142:
143: --hr_utility.set_message(801,'MNDTRY_FLAG_NOT_EXIST');
144: --hr_utility.raise_error;
145: --
146: end if;
147: --

Line 144: --hr_utility.raise_error;

140: fnd_message.set_token('TYPE', 'YES_NO');
141: fnd_message.raise_error;
142:
143: --hr_utility.set_message(801,'MNDTRY_FLAG_NOT_EXIST');
144: --hr_utility.raise_error;
145: --
146: end if;
147: --
148: end if;

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

146: end if;
147: --
148: end if;
149: --
150: hr_utility.set_location('Leaving:'||l_proc,10);
151: --
152: end chk_mndtry_flag;
153: --
154: --

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

187: l_api_updating boolean;
188: --
189: Begin
190: --
191: hr_utility.set_location('Entering:'||l_proc, 5);
192: --
193: l_api_updating := ben_CEP_shd.api_updating
194: (p_prtn_elig_prfl_id => p_prtn_elig_prfl_id,
195: p_effective_date => p_effective_date,

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

219: end if;
220: --
221: end if;
222: --
223: hr_utility.set_location('Leaving:'||l_proc,10);
224: --
225: end chk_cmpscore_flag;
226: --
227: --

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

278: --
279: --
280: Begin
281: --
282: hr_utility.set_location('Entering:'||l_proc,5);
283: --
284: l_api_updating := ben_cep_shd.api_updating
285: (p_prtn_elig_prfl_id => p_prtn_elig_prfl_id,
286: 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_eligy_prfl_id;
313: --
314: -- bug 3876692

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

373: and plip.effective_end_date;
374: --
375: Begin
376: --
377: hr_utility.set_location('Entering:'||l_proc,5);
378: --
379: open c1;
380: fetch c1 into l_exists;
381: if c1%found then

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

405: close c2;
406: --
407: end if;
408: --
409: hr_utility.set_location('Leaving:'||l_proc,10);
410: --
411: End chk_flx_impt_extnce;
412: --
413: --

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

451: l_integrity_error Exception;
452: l_table_name all_tables.table_name%TYPE;
453: --
454: Begin
455: hr_utility.set_location('Entering:'||l_proc, 5);
456: --
457: -- Ensure that the p_datetrack_mode argument is not null
458: --
459: hr_api.mandatory_arg_error

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

500: End If;
501: --
502: End If;
503: --
504: hr_utility.set_location(' Leaving:'||l_proc, 10);
505: Exception
506: When l_integrity_error Then
507: --
508: -- A referential integrity check was violated therefore

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

507: --
508: -- A referential integrity check was violated therefore
509: -- we must error
510: --
511: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
512: hr_utility.set_message_token('TABLE_NAME', l_table_name);
513: hr_utility.raise_error;
514: When Others Then
515: --

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

508: -- A referential integrity check was violated therefore
509: -- we must error
510: --
511: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
512: hr_utility.set_message_token('TABLE_NAME', l_table_name);
513: hr_utility.raise_error;
514: When Others Then
515: --
516: -- An unhandled or unexpected error has occurred which

Line 513: hr_utility.raise_error;

509: -- we must error
510: --
511: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
512: hr_utility.set_message_token('TABLE_NAME', l_table_name);
513: hr_utility.raise_error;
514: When Others Then
515: --
516: -- An unhandled or unexpected error has occurred which
517: -- we must report

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

515: --
516: -- An unhandled or unexpected error has occurred which
517: -- we must report
518: --
519: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
520: hr_utility.set_message_token('PROCEDURE', l_proc);
521: hr_utility.set_message_token('STEP','15');
522: hr_utility.raise_error;
523: End dt_update_validate;

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

516: -- An unhandled or unexpected error has occurred which
517: -- we must report
518: --
519: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
520: hr_utility.set_message_token('PROCEDURE', l_proc);
521: hr_utility.set_message_token('STEP','15');
522: hr_utility.raise_error;
523: End dt_update_validate;
524: --

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

517: -- we must report
518: --
519: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
520: hr_utility.set_message_token('PROCEDURE', l_proc);
521: hr_utility.set_message_token('STEP','15');
522: hr_utility.raise_error;
523: End dt_update_validate;
524: --
525: -- ----------------------------------------------------------------------------

Line 522: hr_utility.raise_error;

518: --
519: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
520: hr_utility.set_message_token('PROCEDURE', l_proc);
521: hr_utility.set_message_token('STEP','15');
522: hr_utility.raise_error;
523: End dt_update_validate;
524: --
525: -- ----------------------------------------------------------------------------
526: -- |--------------------------< dt_delete_validate >--------------------------|

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

567: l_rows_exist Exception;
568: l_table_name all_tables.table_name%TYPE;
569: --
570: Begin
571: hr_utility.set_location('Entering:'||l_proc, 5);
572: --
573: -- Ensure that the p_datetrack_mode argument is not null
574: --
575: hr_api.mandatory_arg_error

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

618: */
619: --
620: End If;
621: --
622: hr_utility.set_location(' Leaving:'||l_proc, 10);
623: Exception
624: When l_rows_exist Then
625: --
626: -- A referential integrity check was violated therefore

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

625: --
626: -- A referential integrity check was violated therefore
627: -- we must error
628: --
629: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
630: hr_utility.set_message_token('TABLE_NAME', l_table_name);
631: hr_utility.raise_error;
632: When Others Then
633: --

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

626: -- A referential integrity check was violated therefore
627: -- we must error
628: --
629: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
630: hr_utility.set_message_token('TABLE_NAME', l_table_name);
631: hr_utility.raise_error;
632: When Others Then
633: --
634: -- An unhandled or unexpected error has occurred which

Line 631: hr_utility.raise_error;

627: -- we must error
628: --
629: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
630: hr_utility.set_message_token('TABLE_NAME', l_table_name);
631: hr_utility.raise_error;
632: When Others Then
633: --
634: -- An unhandled or unexpected error has occurred which
635: -- we must report

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

633: --
634: -- An unhandled or unexpected error has occurred which
635: -- we must report
636: --
637: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
638: hr_utility.set_message_token('PROCEDURE', l_proc);
639: hr_utility.set_message_token('STEP','15');
640: hr_utility.raise_error;
641: End dt_delete_validate;

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

634: -- An unhandled or unexpected error has occurred which
635: -- we must report
636: --
637: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
638: hr_utility.set_message_token('PROCEDURE', l_proc);
639: hr_utility.set_message_token('STEP','15');
640: hr_utility.raise_error;
641: End dt_delete_validate;
642: --

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

635: -- we must report
636: --
637: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
638: hr_utility.set_message_token('PROCEDURE', l_proc);
639: hr_utility.set_message_token('STEP','15');
640: hr_utility.raise_error;
641: End dt_delete_validate;
642: --
643: -- ----------------------------------------------------------------------------

Line 640: hr_utility.raise_error;

636: --
637: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
638: hr_utility.set_message_token('PROCEDURE', l_proc);
639: hr_utility.set_message_token('STEP','15');
640: hr_utility.raise_error;
641: End dt_delete_validate;
642: --
643: -- ----------------------------------------------------------------------------
644: -- |---------------------------< insert_validate >----------------------------|

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

652: --
653: l_proc varchar2(72) := g_package||'insert_validate';
654: --
655: Begin
656: hr_utility.set_location('Entering:'||l_proc, 5);
657: --
658: -- Call all supporting business operations
659: --
660: --

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

691: --
692: chk_flx_impt_extnce(p_prtn_elig_id => p_rec.prtn_elig_id,
693: p_effective_date => p_effective_date);
694: --
695: hr_utility.set_location(' Leaving:'||l_proc, 10);
696: End insert_validate;
697: --
698: -- ----------------------------------------------------------------------------
699: -- |---------------------------< update_validate >----------------------------|

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

707: --
708: l_proc varchar2(72) := g_package||'update_validate';
709: --
710: Begin
711: hr_utility.set_location('Entering:'||l_proc, 5);
712: --
713: -- Call all supporting business operations
714: --
715: --

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

755: --
756: chk_flx_impt_extnce(p_prtn_elig_id => p_rec.prtn_elig_id,
757: p_effective_date => p_effective_date);
758: --
759: hr_utility.set_location(' Leaving:'||l_proc, 10);
760: End update_validate;
761: --
762: -- ----------------------------------------------------------------------------
763: -- |---------------------------< delete_validate >----------------------------|

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

771: --
772: l_proc varchar2(72) := g_package||'delete_validate';
773: --
774: Begin
775: hr_utility.set_location('Entering:'||l_proc, 5);
776: --
777: -- Call all supporting business operations
778: --
779: dt_delete_validate

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

781: p_validation_start_date => p_validation_start_date,
782: p_validation_end_date => p_validation_end_date,
783: p_prtn_elig_prfl_id => p_rec.prtn_elig_prfl_id);
784: --
785: hr_utility.set_location(' Leaving:'||l_proc, 10);
786: End delete_validate;
787: --
788: --
789: -- ---------------------------------------------------------------------------

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

808: l_proc varchar2(72) := g_package||'return_legislation_code';
809: --
810: begin
811: --
812: hr_utility.set_location('Entering:'|| l_proc, 10);
813: --
814: -- Ensure that all the mandatory parameter are not null
815: --
816: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

826: close csr_leg_code;
827: --
828: -- The primary key is invalid therefore we must error
829: --
830: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
831: hr_utility.raise_error;
832: --
833: end if;
834: --

Line 831: hr_utility.raise_error;

827: --
828: -- The primary key is invalid therefore we must error
829: --
830: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
831: hr_utility.raise_error;
832: --
833: end if;
834: --
835: close csr_leg_code;

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

833: end if;
834: --
835: close csr_leg_code;
836: --
837: hr_utility.set_location(' Leaving:'|| l_proc, 20);
838: --
839: return l_legislation_code;
840: --
841: end return_legislation_code;