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_LBR_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_lbr_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_ler_bnft_rstrn_id => p_ler_bnft_rstrn_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_ler_bnft_rstrn_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_lbr_shd.api_updating
118: (p_ler_bnft_rstrn_id => p_ler_bnft_rstrn_id,
119: p_effective_date => p_effective_date,

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

142: end if;
143: --
144: end if;
145: --
146: hr_utility.set_location('Leaving:'||l_proc,10);
147: --
148: end chk_no_mx_cvg_incr_apls_flag;
149: --
150: -- ----------------------------------------------------------------------------

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

182: l_api_updating boolean;
183: --
184: Begin
185: --
186: hr_utility.set_location('Entering:'||l_proc, 5);
187: --
188: l_api_updating := ben_lbr_shd.api_updating
189: (p_ler_bnft_rstrn_id => p_ler_bnft_rstrn_id,
190: p_effective_date => p_effective_date,

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

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

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

253: l_api_updating boolean;
254: --
255: Begin
256: --
257: hr_utility.set_location('Entering:'||l_proc, 5);
258: --
259: l_api_updating := ben_lbr_shd.api_updating
260: (p_ler_bnft_rstrn_id => p_ler_bnft_rstrn_id,
261: p_effective_date => p_effective_date,

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

284: end if;
285: --
286: end if;
287: --
288: hr_utility.set_location('Leaving:'||l_proc,10);
289: --
290: end chk_no_mx_cvg_amt_apls_flag;
291: --
292: -- ----------------------------------------------------------------------------

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

324: l_api_updating boolean;
325: --
326: Begin
327: --
328: hr_utility.set_location('Entering:'||l_proc, 5);
329: --
330: l_api_updating := ben_lbr_shd.api_updating
331: (p_ler_bnft_rstrn_id => p_ler_bnft_rstrn_id,
332: p_effective_date => p_effective_date,

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

355: end if;
356: --
357: end if;
358: --
359: hr_utility.set_location('Leaving:'||l_proc,10);
360: --
361: end chk_cvg_incr_r_decr_only_cd;
362: --
363: -- ----------------------------------------------------------------------------

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

395: l_api_updating boolean;
396: --
397: Begin
398: --
399: hr_utility.set_location('Entering:'||l_proc, 5);
400: --
401: l_api_updating := ben_lbr_shd.api_updating
402: (p_ler_bnft_rstrn_id => p_ler_bnft_rstrn_id,
403: p_effective_date => p_effective_date,

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

426: end if;
427: --
428: end if;
429: --
430: hr_utility.set_location('Leaving:'||l_proc,10);
431: --
432: end chk_unsspnd_enrt_cd;
433: --
434: -- ----------------------------------------------------------------------------

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

466: l_api_updating boolean;
467: --
468: Begin
469: --
470: hr_utility.set_location('Entering:'||l_proc, 5);
471: --
472: l_api_updating := ben_lbr_shd.api_updating
473: (p_ler_bnft_rstrn_id => p_ler_bnft_rstrn_id,
474: p_effective_date => p_effective_date,

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

497: end if;
498: --
499: end if;
500: --
501: hr_utility.set_location('Leaving:'||l_proc,10);
502: --
503: end chk_dflt_to_asn_pndg_ctfn_cd;
504: --
505: -- ----------------------------------------------------------------------------

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

539: l_api_updating boolean;
540: --
541: Begin
542: --
543: hr_utility.set_location('Entering:'||l_proc, 5);
544: --
545: l_api_updating := ben_lbr_shd.api_updating
546: (p_ler_bnft_rstrn_id => p_ler_bnft_rstrn_id,
547: p_effective_date => p_effective_date,

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

571: end if;
572: --
573: end if;
574: --
575: hr_utility.set_location('Leaving:'||l_proc,10);
576: --
577: end chk_dflt_to_asn_pndg_ctfn_rl;
578: --
579: -- ----------------------------------------------------------------------------

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

612: l_api_updating boolean;
613: --
614: Begin
615: --
616: hr_utility.set_location('Entering:'||l_proc, 5);
617: --
618: l_api_updating := ben_lbr_shd.api_updating
619: (p_ler_bnft_rstrn_id => p_ler_bnft_rstrn_id,
620: p_effective_date => p_effective_date,

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

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

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

685: l_api_updating boolean;
686: --
687: Begin
688: --
689: hr_utility.set_location('Entering:'||l_proc, 5);
690: --
691: l_api_updating := ben_lbr_shd.api_updating
692: (p_ler_bnft_rstrn_id => p_ler_bnft_rstrn_id,
693: p_effective_date => p_effective_date,

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

717: end if;
718: --
719: end if;
720: --
721: hr_utility.set_location('Leaving:'||l_proc,10);
722: --
723: end chk_mx_cvg_rl;
724: --
725: -- ----------------------------------------------------------------------------

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

789: and p_effective_date between pln.effective_start_date and pln.effective_end_date;
790: --
791: Begin
792: --
793: hr_utility.set_location('Entering:'||l_proc, 5);
794: --
795: l_api_updating := ben_lbr_shd.api_updating
796: (p_effective_date => p_effective_date,
797: p_ler_bnft_rstrn_id => p_ler_bnft_rstrn_id,

Line 818: hr_utility.set_location('Inside :'||l_proc, 10);

814: fetch c1 into l_dummy;
815: if c1%found then
816: --
817: close c1;
818: hr_utility.set_location('Inside :'||l_proc, 10);
819: fnd_message.set_name('BEN', 'BEN_93113_CD_CANNOT_NEXTLOWER');
820: fnd_message.raise_error;
821: --
822: else

Line 835: hr_utility.set_location('Inside :'||l_proc, 15);

831: fetch c2 into l_dummy;
832: if c2%found then
833: --
834: close c2;
835: hr_utility.set_location('Inside :'||l_proc, 15);
836: fnd_message.set_name('BEN', 'BEN_93113_CD_CANNOT_NEXTLOWER');
837: fnd_message.raise_error;
838: --
839: else

Line 851: hr_utility.set_location('Leaving:'||l_proc, 30);

847: end if; -- End of instr end if
848: --
849: end if;
850: --
851: hr_utility.set_location('Leaving:'||l_proc, 30);
852: --
853: End chk_interim_cd_cvg_calc_mthd;
854: --
855: -- ----------------------------------------------------------------------------

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

892: l_integrity_error Exception;
893: l_table_name all_tables.table_name%TYPE;
894: --
895: Begin
896: hr_utility.set_location('Entering:'||l_proc, 5);
897: --
898: -- Ensure that the p_datetrack_mode argument is not null
899: --
900: hr_api.mandatory_arg_error

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

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

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

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

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

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

Line 954: hr_utility.raise_error;

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

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

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

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

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

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

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

Line 963: hr_utility.raise_error;

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

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

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

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

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

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

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

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

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

Line 1066: hr_utility.raise_error;

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

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

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

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

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

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

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

Line 1075: hr_utility.raise_error;

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

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

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

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

1171: p_object_version_number => p_rec.object_version_number);
1172: --
1173: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1174: --
1175: hr_utility.set_location(' Leaving:'||l_proc, 10);
1176: End insert_validate;
1177: --
1178: -- ----------------------------------------------------------------------------
1179: -- |---------------------------< update_validate >----------------------------|

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

1187: --
1188: l_proc varchar2(72) := g_package||'update_validate';
1189: --
1190: Begin
1191: hr_utility.set_location('Entering:'||l_proc, 5);
1192: --
1193: -- Call all supporting business operations
1194: --
1195: chk_ler_bnft_rstrn_id

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

1280: p_datetrack_mode => p_datetrack_mode,
1281: p_validation_start_date => p_validation_start_date,
1282: p_validation_end_date => p_validation_end_date);
1283: --
1284: hr_utility.set_location(' Leaving:'||l_proc, 10);
1285: End update_validate;
1286: --
1287: -- ----------------------------------------------------------------------------
1288: -- |---------------------------< delete_validate >----------------------------|

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

1296: --
1297: l_proc varchar2(72) := g_package||'delete_validate';
1298: --
1299: Begin
1300: hr_utility.set_location('Entering:'||l_proc, 5);
1301: --
1302: -- Call all supporting business operations
1303: --
1304: dt_delete_validate

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

1306: p_validation_start_date => p_validation_start_date,
1307: p_validation_end_date => p_validation_end_date,
1308: p_ler_bnft_rstrn_id => p_rec.ler_bnft_rstrn_id);
1309: --
1310: hr_utility.set_location(' Leaving:'||l_proc, 10);
1311: End delete_validate;
1312: --
1313: --
1314: -- ---------------------------------------------------------------------------

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

1333: l_proc varchar2(72) := g_package||'return_legislation_code';
1334: --
1335: begin
1336: --
1337: hr_utility.set_location('Entering:'|| l_proc, 10);
1338: --
1339: -- Ensure that all the mandatory parameter are not null
1340: --
1341: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

1351: close csr_leg_code;
1352: --
1353: -- The primary key is invalid therefore we must error
1354: --
1355: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
1356: hr_utility.raise_error;
1357: --
1358: end if;
1359: --

Line 1356: hr_utility.raise_error;

1352: --
1353: -- The primary key is invalid therefore we must error
1354: --
1355: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
1356: hr_utility.raise_error;
1357: --
1358: end if;
1359: --
1360: close csr_leg_code;

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

1358: end if;
1359: --
1360: close csr_leg_code;
1361: --
1362: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1363: --
1364: return l_legislation_code;
1365: --
1366: end return_legislation_code;