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_LPE_BUS dependencies on HR_UTILITY

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

43: l_api_updating boolean;
44: --
45: Begin
46: --
47: hr_utility.set_location('Entering:'||l_proc, 5);
48: --
49: l_api_updating := ben_lpe_shd.api_updating
50: (p_effective_date => p_effective_date,
51: p_ler_chg_pl_nip_enrt_id => p_ler_chg_pl_nip_enrt_id,

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

72: end if;
73: --
74: end if;
75: --
76: hr_utility.set_location('Leaving:'||l_proc, 10);
77: --
78: End chk_ler_chg_pl_nip_enrt_id;
79: --
80: -- ----------------------------------------------------------------------------

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

129: and ff.effective_end_date;
130: --
131: Begin
132: --
133: hr_utility.set_location('Entering:'||l_proc, 5);
134: --
135: l_api_updating := ben_lpe_shd.api_updating
136: (p_ler_chg_pl_nip_enrt_id => p_ler_chg_pl_nip_enrt_id,
137: p_effective_date => p_effective_date,

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

167: close c1;
168: --
169: end if;
170: --
171: hr_utility.set_location('Leaving:'||l_proc,10);
172: --
173: end chk_auto_enrt_mthd_rl;
174: --
175: -- ----------------------------------------------------------------------------

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

207: l_api_updating boolean;
208: --
209: Begin
210: --
211: hr_utility.set_location('Entering:'||l_proc, 5);
212: --
213: l_api_updating := ben_lpe_shd.api_updating
214: (p_ler_chg_pl_nip_enrt_id => p_ler_chg_pl_nip_enrt_id,
215: p_effective_date => p_effective_date,

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

238: end if;
239: --
240: end if;
241: --
242: hr_utility.set_location('Leaving:'||l_proc,10);
243: --
244: end chk_enrt_mthd_cd;
245: --
246: -- ----------------------------------------------------------------------------

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

278: l_api_updating boolean;
279: --
280: Begin
281: --
282: hr_utility.set_location('Entering:'||l_proc, 5);
283: --
284: l_api_updating := ben_lpe_shd.api_updating
285: (p_ler_chg_pl_nip_enrt_id => p_ler_chg_pl_nip_enrt_id,
286: p_effective_date => p_effective_date,

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

309: end if;
310: --
311: end if;
312: --
313: hr_utility.set_location('Leaving:'||l_proc,10);
314: --
315: end chk_stl_elig_cant_chg_flag;
316: --
317: -- ----------------------------------------------------------------------------

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

349: l_api_updating boolean;
350: --
351: Begin
352: --
353: hr_utility.set_location('Entering:'||l_proc, 5);
354: --
355: l_api_updating := ben_lpe_shd.api_updating
356: (p_ler_chg_pl_nip_enrt_id => p_ler_chg_pl_nip_enrt_id,
357: p_effective_date => p_effective_date,

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

380: end if;
381: --
382: end if;
383: --
384: hr_utility.set_location('Leaving:'||l_proc,10);
385: --
386: end chk_enrt_cd;
387: --
388: -- ----------------------------------------------------------------------------

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

438: and ff.effective_end_date;
439: --
440: Begin
441: --
442: hr_utility.set_location('Entering:'||l_proc, 5);
443: --
444: l_api_updating := ben_lpe_shd.api_updating
445: (p_ler_chg_pl_nip_enrt_id => p_ler_chg_pl_nip_enrt_id,
446: p_effective_date => p_effective_date,

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

476: close c1;
477: --
478: end if;
479: --
480: hr_utility.set_location('Leaving:'||l_proc,10);
481: --
482: end chk_enrt_rl;
483: --
484: -- ----------------------------------------------------------------------------

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

516: l_api_updating boolean;
517: --
518: Begin
519: --
520: hr_utility.set_location('Entering:'||l_proc, 5);
521: --
522: l_api_updating := ben_lpe_shd.api_updating
523: (p_ler_chg_pl_nip_enrt_id => p_ler_chg_pl_nip_enrt_id,
524: p_effective_date => p_effective_date,

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

547: end if;
548: --
549: end if;
550: --
551: hr_utility.set_location('Leaving:'||l_proc,10);
552: --
553: end chk_dflt_flag;
554: --
555: -- ----------------------------------------------------------------------------

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

605: and ff.effective_end_date;
606: --
607: Begin
608: --
609: hr_utility.set_location('Entering:'||l_proc, 5);
610: --
611: l_api_updating := ben_lpe_shd.api_updating
612: (p_ler_chg_pl_nip_enrt_id => p_ler_chg_pl_nip_enrt_id,
613: p_effective_date => p_effective_date,

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

643: close c1;
644: --
645: end if;
646: --
647: hr_utility.set_location('Leaving:'||l_proc,10);
648: --
649: end chk_dflt_enrt_rl;
650: --
651: -- ----------------------------------------------------------------------------

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

683: l_api_updating boolean;
684: --
685: Begin
686: --
687: hr_utility.set_location('Entering:'||l_proc, 5);
688: --
689: l_api_updating := ben_lpe_shd.api_updating
690: (p_ler_chg_pl_nip_enrt_id => p_ler_chg_pl_nip_enrt_id,
691: p_effective_date => p_effective_date,

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

714: end if;
715: --
716: end if;
717: --
718: hr_utility.set_location('Leaving:'||l_proc,10);
719: --
720: end chk_dflt_enrt_cd;
721: --
722: -- ----------------------------------------------------------------------------

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

754: l_api_updating boolean;
755: --
756: Begin
757: --
758: hr_utility.set_location('Entering:'||l_proc, 5);
759: --
760: l_api_updating := ben_lpe_shd.api_updating
761: (p_ler_chg_pl_nip_enrt_id => p_ler_chg_pl_nip_enrt_id,
762: p_effective_date => p_effective_date,

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

785: end if;
786: --
787: end if;
788: --
789: hr_utility.set_location('Leaving:'||l_proc,10);
790: --
791: end chk_crnt_enrt_prclds_chg_flag;
792: --
793: -- ----------------------------------------------------------------------------

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

825: l_api_updating boolean;
826: --
827: Begin
828: --
829: hr_utility.set_location('Entering:'||l_proc, 5);
830: --
831: l_api_updating := ben_lpe_shd.api_updating
832: (p_ler_chg_pl_nip_enrt_id => p_ler_chg_pl_nip_enrt_id,
833: p_effective_date => p_effective_date,

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

857: end if;
858: --
859: end if;
860: --
861: hr_utility.set_location('Leaving:'||l_proc,10);
862: --
863: end chk_tco_chg_enrt_cd;
864: --
865: -- ----------------------------------------------------------------------------

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

901: l_integrity_error Exception;
902: l_table_name all_tables.table_name%TYPE;
903: --
904: Begin
905: hr_utility.set_location('Entering:'||l_proc, 5);
906: --
907: -- Ensure that the p_datetrack_mode argument is not null
908: --
909: hr_api.mandatory_arg_error

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

940: End If;
941: --
942: End If;
943: --
944: hr_utility.set_location(' Leaving:'||l_proc, 10);
945: Exception
946: When l_integrity_error Then
947: --
948: -- A referential integrity check was violated therefore

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

947: --
948: -- A referential integrity check was violated therefore
949: -- we must error
950: --
951: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
952: hr_utility.set_message_token('TABLE_NAME', l_table_name);
953: hr_utility.raise_error;
954: When Others Then
955: --

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

948: -- A referential integrity check was violated therefore
949: -- we must error
950: --
951: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
952: hr_utility.set_message_token('TABLE_NAME', l_table_name);
953: hr_utility.raise_error;
954: When Others Then
955: --
956: -- An unhandled or unexpected error has occurred which

Line 953: hr_utility.raise_error;

949: -- we must error
950: --
951: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
952: hr_utility.set_message_token('TABLE_NAME', l_table_name);
953: hr_utility.raise_error;
954: When Others Then
955: --
956: -- An unhandled or unexpected error has occurred which
957: -- we must report

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

955: --
956: -- An unhandled or unexpected error has occurred which
957: -- we must report
958: --
959: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
960: hr_utility.set_message_token('PROCEDURE', l_proc);
961: hr_utility.set_message_token('STEP','15');
962: hr_utility.raise_error;
963: End dt_update_validate;

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

956: -- An unhandled or unexpected error has occurred which
957: -- we must report
958: --
959: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
960: hr_utility.set_message_token('PROCEDURE', l_proc);
961: hr_utility.set_message_token('STEP','15');
962: hr_utility.raise_error;
963: End dt_update_validate;
964: --

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

957: -- we must report
958: --
959: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
960: hr_utility.set_message_token('PROCEDURE', l_proc);
961: hr_utility.set_message_token('STEP','15');
962: hr_utility.raise_error;
963: End dt_update_validate;
964: --
965: -- ----------------------------------------------------------------------------

Line 962: hr_utility.raise_error;

958: --
959: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
960: hr_utility.set_message_token('PROCEDURE', l_proc);
961: hr_utility.set_message_token('STEP','15');
962: hr_utility.raise_error;
963: End dt_update_validate;
964: --
965: -- ----------------------------------------------------------------------------
966: -- |--------------------------< dt_delete_validate >--------------------------|

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

1007: l_rows_exist Exception;
1008: l_table_name all_tables.table_name%TYPE;
1009: --
1010: Begin
1011: hr_utility.set_location('Entering:'||l_proc, 5);
1012: --
1013: -- Ensure that the p_datetrack_mode argument is not null
1014: --
1015: hr_api.mandatory_arg_error

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

1052: End If;
1053: --
1054: End If;
1055: --
1056: hr_utility.set_location(' Leaving:'||l_proc, 10);
1057: Exception
1058: When l_rows_exist Then
1059: --
1060: -- A referential integrity check was violated therefore

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

1059: --
1060: -- A referential integrity check was violated therefore
1061: -- we must error
1062: --
1063: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
1064: hr_utility.set_message_token('TABLE_NAME', l_table_name);
1065: hr_utility.raise_error;
1066: When Others Then
1067: --

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

1060: -- A referential integrity check was violated therefore
1061: -- we must error
1062: --
1063: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
1064: hr_utility.set_message_token('TABLE_NAME', l_table_name);
1065: hr_utility.raise_error;
1066: When Others Then
1067: --
1068: -- An unhandled or unexpected error has occurred which

Line 1065: hr_utility.raise_error;

1061: -- we must error
1062: --
1063: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
1064: hr_utility.set_message_token('TABLE_NAME', l_table_name);
1065: hr_utility.raise_error;
1066: When Others Then
1067: --
1068: -- An unhandled or unexpected error has occurred which
1069: -- we must report

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

1067: --
1068: -- An unhandled or unexpected error has occurred which
1069: -- we must report
1070: --
1071: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1072: hr_utility.set_message_token('PROCEDURE', l_proc);
1073: hr_utility.set_message_token('STEP','15');
1074: hr_utility.raise_error;
1075: End dt_delete_validate;

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

1068: -- An unhandled or unexpected error has occurred which
1069: -- we must report
1070: --
1071: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1072: hr_utility.set_message_token('PROCEDURE', l_proc);
1073: hr_utility.set_message_token('STEP','15');
1074: hr_utility.raise_error;
1075: End dt_delete_validate;
1076: --

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

1069: -- we must report
1070: --
1071: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1072: hr_utility.set_message_token('PROCEDURE', l_proc);
1073: hr_utility.set_message_token('STEP','15');
1074: hr_utility.raise_error;
1075: End dt_delete_validate;
1076: --
1077: -- ----------------------------------------------------------------------------

Line 1074: hr_utility.raise_error;

1070: --
1071: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1072: hr_utility.set_message_token('PROCEDURE', l_proc);
1073: hr_utility.set_message_token('STEP','15');
1074: hr_utility.raise_error;
1075: End dt_delete_validate;
1076: --
1077: -- ----------------------------------------------------------------------------
1078: -- |---------------------------< insert_validate >----------------------------|

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

1086: --
1087: l_proc varchar2(72) := g_package||'insert_validate';
1088: --
1089: Begin
1090: hr_utility.set_location('Entering:'||l_proc, 5);
1091: --
1092: -- Call all supporting business operations
1093: --
1094: --

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

1161: p_tco_chg_enrt_cd => p_rec.tco_chg_enrt_cd,
1162: p_effective_date => p_effective_date,
1163: p_object_version_number => p_rec.object_version_number);
1164: --
1165: hr_utility.set_location(' Leaving:'||l_proc, 10);
1166: End insert_validate;
1167: --
1168: -- ----------------------------------------------------------------------------
1169: -- |---------------------------< update_validate >----------------------------|

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

1177: --
1178: l_proc varchar2(72) := g_package||'update_validate';
1179: --
1180: Begin
1181: hr_utility.set_location('Entering:'||l_proc, 5);
1182: --
1183: -- Call all supporting business operations
1184: --
1185: --

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

1260: p_datetrack_mode => p_datetrack_mode,
1261: p_validation_start_date => p_validation_start_date,
1262: p_validation_end_date => p_validation_end_date);
1263: --
1264: hr_utility.set_location(' Leaving:'||l_proc, 10);
1265: End update_validate;
1266: --
1267: -- ----------------------------------------------------------------------------
1268: -- |---------------------------< delete_validate >----------------------------|

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

1276: --
1277: l_proc varchar2(72) := g_package||'delete_validate';
1278: --
1279: Begin
1280: hr_utility.set_location('Entering:'||l_proc, 5);
1281: --
1282: -- Call all supporting business operations
1283: --
1284: dt_delete_validate

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

1286: p_validation_start_date => p_validation_start_date,
1287: p_validation_end_date => p_validation_end_date,
1288: p_ler_chg_pl_nip_enrt_id => p_rec.ler_chg_pl_nip_enrt_id);
1289: --
1290: hr_utility.set_location(' Leaving:'||l_proc, 10);
1291: End delete_validate;
1292: --
1293: --
1294: -- ---------------------------------------------------------------------------

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

1313: l_proc varchar2(72) := g_package||'return_legislation_code';
1314: --
1315: begin
1316: --
1317: hr_utility.set_location('Entering:'|| l_proc, 10);
1318: --
1319: -- Ensure that all the mandatory parameter are not null
1320: --
1321: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

1331: close csr_leg_code;
1332: --
1333: -- The primary key is invalid therefore we must error
1334: --
1335: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
1336: hr_utility.raise_error;
1337: --
1338: end if;
1339: --

Line 1336: hr_utility.raise_error;

1332: --
1333: -- The primary key is invalid therefore we must error
1334: --
1335: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
1336: hr_utility.raise_error;
1337: --
1338: end if;
1339: --
1340: close csr_leg_code;

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

1338: end if;
1339: --
1340: close csr_leg_code;
1341: --
1342: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1343: --
1344: return l_legislation_code;
1345: --
1346: end return_legislation_code;