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_ERP_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_erp_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_enrt_perd_for_pl_id => p_enrt_perd_for_pl_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_enrt_perd_for_pl_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_erp_shd.api_updating
119: (p_enrt_perd_for_pl_id => p_enrt_perd_for_pl_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_rt_end_dt_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_erp_shd.api_updating
191: (p_enrt_perd_for_pl_id => p_enrt_perd_for_pl_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_rt_end_dt_cd;
222: --
223: -- ----------------------------------------------------------------------------

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

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

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

288: end if;
289: --
290: end if;
291: --
292: hr_utility.set_location('Leaving:'||l_proc,10);
293: --
294: end chk_rt_strt_dt_rl;
295: --
296: -- ----------------------------------------------------------------------------

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

328: l_api_updating boolean;
329: --
330: Begin
331: --
332: hr_utility.set_location('Entering:'||l_proc, 5);
333: --
334: l_api_updating := ben_erp_shd.api_updating
335: (p_enrt_perd_for_pl_id => p_enrt_perd_for_pl_id,
336: p_effective_date => p_effective_date,

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

359: end if;
360: --
361: end if;
362: --
363: hr_utility.set_location('Leaving:'||l_proc,10);
364: --
365: end chk_rt_strt_dt_cd;
366: --
367: -- ----------------------------------------------------------------------------

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

400: l_api_updating boolean;
401: --
402: Begin
403: --
404: hr_utility.set_location('Entering:'||l_proc, 5);
405: --
406: l_api_updating := ben_erp_shd.api_updating
407: (p_enrt_perd_for_pl_id => p_enrt_perd_for_pl_id,
408: p_effective_date => p_effective_date,

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

432: end if;
433: --
434: end if;
435: --
436: hr_utility.set_location('Leaving:'||l_proc,10);
437: --
438: end chk_enrt_cvg_end_dt_rl;
439: --
440: -- ----------------------------------------------------------------------------

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

472: l_api_updating boolean;
473: --
474: Begin
475: --
476: hr_utility.set_location('Entering:'||l_proc, 5);
477: --
478: l_api_updating := ben_erp_shd.api_updating
479: (p_enrt_perd_for_pl_id => p_enrt_perd_for_pl_id,
480: p_effective_date => p_effective_date,

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

503: end if;
504: --
505: end if;
506: --
507: hr_utility.set_location('Leaving:'||l_proc,10);
508: --
509: end chk_enrt_cvg_end_dt_cd;
510: --
511: -- ----------------------------------------------------------------------------

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

544: l_api_updating boolean;
545: --
546: Begin
547: --
548: hr_utility.set_location('Entering:'||l_proc, 5);
549: --
550: l_api_updating := ben_erp_shd.api_updating
551: (p_enrt_perd_for_pl_id => p_enrt_perd_for_pl_id,
552: p_effective_date => p_effective_date,

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

576: end if;
577: --
578: end if;
579: --
580: hr_utility.set_location('Leaving:'||l_proc,10);
581: --
582: end chk_enrt_cvg_strt_dt_rl;
583: --
584: -- ----------------------------------------------------------------------------

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

616: l_api_updating boolean;
617: --
618: Begin
619: --
620: hr_utility.set_location('Entering:'||l_proc, 5);
621: --
622: l_api_updating := ben_erp_shd.api_updating
623: (p_enrt_perd_for_pl_id => p_enrt_perd_for_pl_id,
624: p_effective_date => p_effective_date,

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

647: end if;
648: --
649: end if;
650: --
651: hr_utility.set_location('Leaving:'||l_proc,10);
652: --
653: end chk_enrt_cvg_strt_dt_cd;
654: --
655: -- ----------------------------------------------------------------------------

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

692: l_integrity_error Exception;
693: l_table_name all_tables.table_name%TYPE;
694: --
695: Begin
696: hr_utility.set_location('Entering:'||l_proc, 5);
697: --
698: -- Ensure that the p_datetrack_mode argument is not null
699: --
700: hr_api.mandatory_arg_error

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

741: End If;
742: --
743: End If;
744: --
745: hr_utility.set_location(' Leaving:'||l_proc, 10);
746: Exception
747: When l_integrity_error Then
748: --
749: -- A referential integrity check was violated therefore

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

748: --
749: -- A referential integrity check was violated therefore
750: -- we must error
751: --
752: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
753: hr_utility.set_message_token('TABLE_NAME', l_table_name);
754: hr_utility.raise_error;
755: When Others Then
756: --

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

749: -- A referential integrity check was violated therefore
750: -- we must error
751: --
752: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
753: hr_utility.set_message_token('TABLE_NAME', l_table_name);
754: hr_utility.raise_error;
755: When Others Then
756: --
757: -- An unhandled or unexpected error has occurred which

Line 754: hr_utility.raise_error;

750: -- we must error
751: --
752: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
753: hr_utility.set_message_token('TABLE_NAME', l_table_name);
754: hr_utility.raise_error;
755: When Others Then
756: --
757: -- An unhandled or unexpected error has occurred which
758: -- we must report

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

756: --
757: -- An unhandled or unexpected error has occurred which
758: -- we must report
759: --
760: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
761: hr_utility.set_message_token('PROCEDURE', l_proc);
762: hr_utility.set_message_token('STEP','15');
763: hr_utility.raise_error;
764: End dt_update_validate;

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

757: -- An unhandled or unexpected error has occurred which
758: -- we must report
759: --
760: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
761: hr_utility.set_message_token('PROCEDURE', l_proc);
762: hr_utility.set_message_token('STEP','15');
763: hr_utility.raise_error;
764: End dt_update_validate;
765: --

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

758: -- we must report
759: --
760: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
761: hr_utility.set_message_token('PROCEDURE', l_proc);
762: hr_utility.set_message_token('STEP','15');
763: hr_utility.raise_error;
764: End dt_update_validate;
765: --
766: -- ----------------------------------------------------------------------------

Line 763: hr_utility.raise_error;

759: --
760: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
761: hr_utility.set_message_token('PROCEDURE', l_proc);
762: hr_utility.set_message_token('STEP','15');
763: hr_utility.raise_error;
764: End dt_update_validate;
765: --
766: -- ----------------------------------------------------------------------------
767: -- |--------------------------< dt_delete_validate >--------------------------|

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

808: l_rows_exist Exception;
809: l_table_name all_tables.table_name%TYPE;
810: --
811: Begin
812: hr_utility.set_location('Entering:'||l_proc, 5);
813: --
814: -- Ensure that the p_datetrack_mode argument is not null
815: --
816: hr_api.mandatory_arg_error

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

845: --
846: --
847: End If;
848: --
849: hr_utility.set_location(' Leaving:'||l_proc, 10);
850: Exception
851: When l_rows_exist Then
852: --
853: -- A referential integrity check was violated therefore

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

852: --
853: -- A referential integrity check was violated therefore
854: -- we must error
855: --
856: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
857: hr_utility.set_message_token('TABLE_NAME', l_table_name);
858: hr_utility.raise_error;
859: When Others Then
860: --

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

853: -- A referential integrity check was violated therefore
854: -- we must error
855: --
856: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
857: hr_utility.set_message_token('TABLE_NAME', l_table_name);
858: hr_utility.raise_error;
859: When Others Then
860: --
861: -- An unhandled or unexpected error has occurred which

Line 858: hr_utility.raise_error;

854: -- we must error
855: --
856: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
857: hr_utility.set_message_token('TABLE_NAME', l_table_name);
858: hr_utility.raise_error;
859: When Others Then
860: --
861: -- An unhandled or unexpected error has occurred which
862: -- we must report

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

860: --
861: -- An unhandled or unexpected error has occurred which
862: -- we must report
863: --
864: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
865: hr_utility.set_message_token('PROCEDURE', l_proc);
866: hr_utility.set_message_token('STEP','15');
867: hr_utility.raise_error;
868: End dt_delete_validate;

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

861: -- An unhandled or unexpected error has occurred which
862: -- we must report
863: --
864: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
865: hr_utility.set_message_token('PROCEDURE', l_proc);
866: hr_utility.set_message_token('STEP','15');
867: hr_utility.raise_error;
868: End dt_delete_validate;
869: --

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

862: -- we must report
863: --
864: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
865: hr_utility.set_message_token('PROCEDURE', l_proc);
866: hr_utility.set_message_token('STEP','15');
867: hr_utility.raise_error;
868: End dt_delete_validate;
869: --
870: -- ----------------------------------------------------------------------------

Line 867: hr_utility.raise_error;

863: --
864: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
865: hr_utility.set_message_token('PROCEDURE', l_proc);
866: hr_utility.set_message_token('STEP','15');
867: hr_utility.raise_error;
868: End dt_delete_validate;
869: --
870: -- ----------------------------------------------------------------------------
871: -- |---------------------------< insert_validate >----------------------------|

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

879: --
880: l_proc varchar2(72) := g_package||'insert_validate';
881: --
882: Begin
883: hr_utility.set_location('Entering:'||l_proc, 5);
884: --
885: -- Call all supporting business operations
886: --
887: --

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

943: p_enrt_cvg_strt_dt_cd => p_rec.enrt_cvg_strt_dt_cd,
944: p_effective_date => p_effective_date,
945: p_object_version_number => p_rec.object_version_number);
946: --
947: hr_utility.set_location(' Leaving:'||l_proc, 10);
948: End insert_validate;
949: --
950: -- ----------------------------------------------------------------------------
951: -- |---------------------------< update_validate >----------------------------|

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

959: --
960: l_proc varchar2(72) := g_package||'update_validate';
961: --
962: Begin
963: hr_utility.set_location('Entering:'||l_proc, 5);
964: --
965: -- Call all supporting business operations
966: --
967: --

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

1032: p_datetrack_mode => p_datetrack_mode,
1033: p_validation_start_date => p_validation_start_date,
1034: p_validation_end_date => p_validation_end_date);
1035: --
1036: hr_utility.set_location(' Leaving:'||l_proc, 10);
1037: End update_validate;
1038: --
1039: -- ----------------------------------------------------------------------------
1040: -- |---------------------------< delete_validate >----------------------------|

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

1048: --
1049: l_proc varchar2(72) := g_package||'delete_validate';
1050: --
1051: Begin
1052: hr_utility.set_location('Entering:'||l_proc, 5);
1053: --
1054: -- Call all supporting business operations
1055: --
1056: dt_delete_validate

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

1058: p_validation_start_date => p_validation_start_date,
1059: p_validation_end_date => p_validation_end_date,
1060: p_enrt_perd_for_pl_id => p_rec.enrt_perd_for_pl_id);
1061: --
1062: hr_utility.set_location(' Leaving:'||l_proc, 10);
1063: End delete_validate;
1064: --
1065: --
1066: -- ---------------------------------------------------------------------------

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

1085: l_proc varchar2(72) := g_package||'return_legislation_code';
1086: --
1087: begin
1088: --
1089: hr_utility.set_location('Entering:'|| l_proc, 10);
1090: --
1091: -- Ensure that all the mandatory parameter are not null
1092: --
1093: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

1103: close csr_leg_code;
1104: --
1105: -- The primary key is invalid therefore we must error
1106: --
1107: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
1108: hr_utility.raise_error;
1109: --
1110: end if;
1111: --

Line 1108: hr_utility.raise_error;

1104: --
1105: -- The primary key is invalid therefore we must error
1106: --
1107: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
1108: hr_utility.raise_error;
1109: --
1110: end if;
1111: --
1112: close csr_leg_code;

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

1110: end if;
1111: --
1112: close csr_leg_code;
1113: --
1114: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1115: --
1116: return l_legislation_code;
1117: --
1118: end return_legislation_code;