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

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

45: l_api_updating boolean;
46: --
47: Begin
48: --
49: hr_utility.set_location('Entering:'||l_proc, 5);
50: --
51: l_api_updating := ben_ecv_shd.api_updating
52: (p_effective_date => p_effective_date,
53: p_eligy_crit_values_id => p_eligy_crit_values_id,

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

75: end if;
76: --
77: end if;
78: --
79: hr_utility.set_location('Leaving:'||l_proc, 10);
80: --
81: End chk_eligy_crit_values_id;
82: --
83: -- ----------------------------------------------------------------------------

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

121: from ben_eligy_criteria
122: where eligy_criteria_id = p_eligy_criteria_id;
123: begin
124: --
125: hr_utility.set_location('Entering:'||l_proc, 5);
126: --
127: l_api_updating := ben_ecv_shd.api_updating(
128: p_eligy_crit_values_id => p_eligy_crit_values_id,
129: p_effective_date => p_effective_date,

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

152: close csr_eligy_criteria_id;
153: --
154: end if;
155: --
156: hr_utility.set_location('Leaving:'||l_proc, 10);
157: --
158: end chk_eligy_criteria_id;
159: --
160: -- ----------------------------------------------------------------------------

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

198: from ben_eligy_prfl_f
199: where eligy_prfl_id = p_eligy_prfl_id;
200: begin
201: --
202: hr_utility.set_location('Entering:'||l_proc, 5);
203: --
204: l_api_updating := ben_ecv_shd.api_updating(
205: p_eligy_crit_values_id => p_eligy_crit_values_id,
206: p_effective_date => p_effective_date,

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

227: --
228: close csr_eligy_prfl_id;
229: end if;
230: --
231: hr_utility.set_location('Leaving:'||l_proc, 10);
232: --
233: end chk_eligy_prfl_id;
234: --
235: -- ----------------------------------------------------------------------------

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

287: and ecv.business_group_id = p_business_group_id;
288: --
289: begin
290: --
291: hr_utility.set_location('Entering:'||l_proc, 5);
292:
293: --
294: open c_eligy_prfl;
295: --

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

305: end if;
306: --
307: close c_eligy_prfl;
308: --
309: hr_utility.set_location('Leaving:'||l_proc, 10);
310: --
311: end chk_duplicate_eligy_criteria;
312: --
313: -- ---------------------------------------------------------------------------

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

362: and effective_end_date >= p_validation_start_date;
363: --
364: Begin
365: --
366: hr_utility.set_location('Entering:'||l_proc, 5);
367: --
368: open c1;
369: --
370: fetch c1 into l_dummy;

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

379: end if;
380: --
381: close c1;
382: --
383: hr_utility.set_location('Leaving:'||l_proc, 15);
384: --
385: End chk_duplicate_ordr_num;
386: --
387: -- ----------------------------------------------------------------------------

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

502: );
503: --
504: begin
505: --
506: hr_utility.set_location('Entering:'||l_proc, 5);
507: --
508: open c_eligy_criteria;
509: --
510: fetch c_eligy_criteria into l_crit_col1_val_type_cd,

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

865: end if;
866: --
867: close c_eligy_criteria;
868: --
869: hr_utility.set_location('Leaving:'||l_proc, 10);
870: --
871: end chk_required_fields;
872: --
873: -- ----------------------------------------------------------------------------

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

911: l_integrity_error Exception;
912: l_table_name all_tables.table_name%TYPE;
913: --
914: Begin
915: hr_utility.set_location('Entering:'||l_proc, 5);
916: --
917: -- Ensure that the p_datetrack_mode argument is not null
918: --
919: hr_api.mandatory_arg_error

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

961: End If;
962: --
963: end if;
964: --
965: hr_utility.set_location(' Leaving:'||l_proc, 10);
966: Exception
967: When l_integrity_error Then
968: --
969: -- A referential integrity check was violated therefore

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

974: --
975: -- An unhandled or unexpected error has occurred which
976: -- we must report
977: --
978: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
979: hr_utility.set_message_token('PROCEDURE', l_proc);
980: hr_utility.set_message_token('STEP','15');
981: hr_utility.raise_error;
982: end dt_update_validate;

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

975: -- An unhandled or unexpected error has occurred which
976: -- we must report
977: --
978: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
979: hr_utility.set_message_token('PROCEDURE', l_proc);
980: hr_utility.set_message_token('STEP','15');
981: hr_utility.raise_error;
982: end dt_update_validate;
983: -- ----------------------------------------------------------------------------

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

976: -- we must report
977: --
978: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
979: hr_utility.set_message_token('PROCEDURE', l_proc);
980: hr_utility.set_message_token('STEP','15');
981: hr_utility.raise_error;
982: end dt_update_validate;
983: -- ----------------------------------------------------------------------------
984: -- |--------------------------< dt_delete_validate >--------------------------|

Line 981: hr_utility.raise_error;

977: --
978: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
979: hr_utility.set_message_token('PROCEDURE', l_proc);
980: hr_utility.set_message_token('STEP','15');
981: hr_utility.raise_error;
982: end dt_update_validate;
983: -- ----------------------------------------------------------------------------
984: -- |--------------------------< dt_delete_validate >--------------------------|
985: -- ----------------------------------------------------------------------------

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

1025: l_rows_exist Exception;
1026: l_table_name all_tables.table_name%TYPE;
1027: --
1028: Begin
1029: hr_utility.set_location('Entering:'||l_proc, 5);
1030: --
1031: -- Ensure that the p_datetrack_mode argument is not null
1032: --
1033: hr_api.mandatory_arg_error

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

1075: --
1076: l_proc varchar2(72) := g_package||'insert_validate';
1077: --
1078: begin
1079: hr_utility.set_location('Entering:'||l_proc, 5);
1080: --
1081: -- Call all supporting business operations
1082: --
1083: --

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

1142: p_date_Value4 => p_rec.date_Value4,
1143: p_business_group_id => p_rec.business_group_id,
1144: p_effective_date => p_effective_date) ;
1145: --
1146: hr_utility.set_location(' Leaving:'||l_proc, 10);
1147: --
1148: end insert_validate;
1149: --
1150: -- ----------------------------------------------------------------------------

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

1159: --
1160: l_proc varchar2(72) := g_package||'update_validate';
1161: begin
1162: --
1163: hr_utility.set_location('Entering:'||l_proc, 5);
1164: --
1165: -- Call all supporting business operations
1166: --
1167: --

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

1237: p_validation_start_date => p_validation_start_date,
1238: p_validation_end_date => p_validation_end_date );
1239: --
1240: --
1241: hr_utility.set_location(' Leaving:'||l_proc, 10);
1242: --
1243: end update_validate;
1244: --
1245: -- ----------------------------------------------------------------------------

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

1253: p_validation_end_date in date) is
1254: --
1255: l_proc varchar2(72) := g_package||'delete_validate';
1256: Begin
1257: hr_utility.set_location('Entering:'||l_proc, 5);
1258: --
1259: -- Call all supporting business operations
1260: --
1261: chk_eligy_crit_values_id

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

1295: l_proc varchar2(72) := g_package||'return_legislation_code';
1296: --
1297: begin
1298: --
1299: hr_utility.set_location('Entering:'|| l_proc, 10);
1300: --
1301: -- Ensure that all the mandatory parameter are not null
1302: --
1303: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

1314: close csr_leg_code;
1315: --
1316: -- The primary key is invalid therefore we must error
1317: --
1318: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
1319: hr_utility.raise_error;
1320: --
1321: end if;
1322: --

Line 1319: hr_utility.raise_error;

1315: --
1316: -- The primary key is invalid therefore we must error
1317: --
1318: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
1319: hr_utility.raise_error;
1320: --
1321: end if;
1322: --
1323: close csr_leg_code;

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

1321: end if;
1322: --
1323: close csr_leg_code;
1324: --
1325: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1326: --
1327: return l_legislation_code;
1328:
1329: --