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_VRP_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_vrp_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_vald_rlshp_for_reimb_id => p_vald_rlshp_for_reimb_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_vald_rlshp_for_reimb_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_vrp_shd.api_updating
118: (p_vald_rlshp_for_reimb_id => p_vald_rlshp_for_reimb_id,
119: p_effective_date => p_effective_date,

Line 137: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');

133: p_effective_date => p_effective_date) then
134: --
135: -- raise error as does not exist as lookup
136: --
137: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
138: hr_utility.raise_error;
139: --
140: end if;
141: --

Line 138: hr_utility.raise_error;

134: --
135: -- raise error as does not exist as lookup
136: --
137: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
138: hr_utility.raise_error;
139: --
140: end if;
141: --
142: end if;

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

140: end if;
141: --
142: end if;
143: --
144: hr_utility.set_location('Leaving:'||l_proc,10);
145: --
146: end chk_rlshp_typ_cd;
147: --
148: -- ----------------------------------------------------------------------------

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

184: l_integrity_error Exception;
185: l_table_name all_tables.table_name%TYPE;
186: --
187: Begin
188: hr_utility.set_location('Entering:'||l_proc, 5);
189: --
190: -- Ensure that the p_datetrack_mode argument is not null
191: --
192: hr_api.mandatory_arg_error

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

223: End If;
224: --
225: End If;
226: --
227: hr_utility.set_location(' Leaving:'||l_proc, 10);
228: Exception
229: When l_integrity_error Then
230: --
231: -- A referential integrity check was violated therefore

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

230: --
231: -- A referential integrity check was violated therefore
232: -- we must error
233: --
234: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
235: hr_utility.set_message_token('TABLE_NAME', l_table_name);
236: hr_utility.raise_error;
237: When Others Then
238: --

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

231: -- A referential integrity check was violated therefore
232: -- we must error
233: --
234: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
235: hr_utility.set_message_token('TABLE_NAME', l_table_name);
236: hr_utility.raise_error;
237: When Others Then
238: --
239: -- An unhandled or unexpected error has occurred which

Line 236: hr_utility.raise_error;

232: -- we must error
233: --
234: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
235: hr_utility.set_message_token('TABLE_NAME', l_table_name);
236: hr_utility.raise_error;
237: When Others Then
238: --
239: -- An unhandled or unexpected error has occurred which
240: -- we must report

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

238: --
239: -- An unhandled or unexpected error has occurred which
240: -- we must report
241: --
242: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
243: hr_utility.set_message_token('PROCEDURE', l_proc);
244: hr_utility.set_message_token('STEP','15');
245: hr_utility.raise_error;
246: End dt_update_validate;

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

239: -- An unhandled or unexpected error has occurred which
240: -- we must report
241: --
242: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
243: hr_utility.set_message_token('PROCEDURE', l_proc);
244: hr_utility.set_message_token('STEP','15');
245: hr_utility.raise_error;
246: End dt_update_validate;
247: --

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

240: -- we must report
241: --
242: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
243: hr_utility.set_message_token('PROCEDURE', l_proc);
244: hr_utility.set_message_token('STEP','15');
245: hr_utility.raise_error;
246: End dt_update_validate;
247: --
248: -- ----------------------------------------------------------------------------

Line 245: hr_utility.raise_error;

241: --
242: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
243: hr_utility.set_message_token('PROCEDURE', l_proc);
244: hr_utility.set_message_token('STEP','15');
245: hr_utility.raise_error;
246: End dt_update_validate;
247: --
248: -- ----------------------------------------------------------------------------
249: -- |--------------------------< dt_delete_validate >--------------------------|

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

290: l_rows_exist Exception;
291: l_table_name all_tables.table_name%TYPE;
292: --
293: Begin
294: hr_utility.set_location('Entering:'||l_proc, 5);
295: --
296: -- Ensure that the p_datetrack_mode argument is not null
297: --
298: hr_api.mandatory_arg_error

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

327: --
328: --
329: End If;
330: --
331: hr_utility.set_location(' Leaving:'||l_proc, 10);
332: Exception
333: When l_rows_exist Then
334: --
335: -- A referential integrity check was violated therefore

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

334: --
335: -- A referential integrity check was violated therefore
336: -- we must error
337: --
338: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
339: hr_utility.set_message_token('TABLE_NAME', l_table_name);
340: hr_utility.raise_error;
341: When Others Then
342: --

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

335: -- A referential integrity check was violated therefore
336: -- we must error
337: --
338: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
339: hr_utility.set_message_token('TABLE_NAME', l_table_name);
340: hr_utility.raise_error;
341: When Others Then
342: --
343: -- An unhandled or unexpected error has occurred which

Line 340: hr_utility.raise_error;

336: -- we must error
337: --
338: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
339: hr_utility.set_message_token('TABLE_NAME', l_table_name);
340: hr_utility.raise_error;
341: When Others Then
342: --
343: -- An unhandled or unexpected error has occurred which
344: -- we must report

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

342: --
343: -- An unhandled or unexpected error has occurred which
344: -- we must report
345: --
346: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
347: hr_utility.set_message_token('PROCEDURE', l_proc);
348: hr_utility.set_message_token('STEP','15');
349: hr_utility.raise_error;
350: End dt_delete_validate;

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

343: -- An unhandled or unexpected error has occurred which
344: -- we must report
345: --
346: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
347: hr_utility.set_message_token('PROCEDURE', l_proc);
348: hr_utility.set_message_token('STEP','15');
349: hr_utility.raise_error;
350: End dt_delete_validate;
351: --

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

344: -- we must report
345: --
346: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
347: hr_utility.set_message_token('PROCEDURE', l_proc);
348: hr_utility.set_message_token('STEP','15');
349: hr_utility.raise_error;
350: End dt_delete_validate;
351: --
352: -- ----------------------------------------------------------------------------

Line 349: hr_utility.raise_error;

345: --
346: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
347: hr_utility.set_message_token('PROCEDURE', l_proc);
348: hr_utility.set_message_token('STEP','15');
349: hr_utility.raise_error;
350: End dt_delete_validate;
351: --
352: -- ----------------------------------------------------------------------------
353: -- |---------------------------< insert_validate >----------------------------|

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

361: --
362: l_proc varchar2(72) := g_package||'insert_validate';
363: --
364: Begin
365: hr_utility.set_location('Entering:'||l_proc, 5);
366: --
367: -- Call all supporting business operations
368: --
369: --

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

379: p_rlshp_typ_cd => p_rec.rlshp_typ_cd,
380: p_effective_date => p_effective_date,
381: p_object_version_number => p_rec.object_version_number);
382: --
383: hr_utility.set_location(' Leaving:'||l_proc, 10);
384: End insert_validate;
385: --
386: -- ----------------------------------------------------------------------------
387: -- |---------------------------< update_validate >----------------------------|

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

395: --
396: l_proc varchar2(72) := g_package||'update_validate';
397: --
398: Begin
399: hr_utility.set_location('Entering:'||l_proc, 5);
400: --
401: -- Call all supporting business operations
402: --
403: --

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

421: p_datetrack_mode => p_datetrack_mode,
422: p_validation_start_date => p_validation_start_date,
423: p_validation_end_date => p_validation_end_date);
424: --
425: hr_utility.set_location(' Leaving:'||l_proc, 10);
426: End update_validate;
427: --
428: -- ----------------------------------------------------------------------------
429: -- |---------------------------< delete_validate >----------------------------|

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

437: --
438: l_proc varchar2(72) := g_package||'delete_validate';
439: --
440: Begin
441: hr_utility.set_location('Entering:'||l_proc, 5);
442: --
443: -- Call all supporting business operations
444: --
445: dt_delete_validate

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

447: p_validation_start_date => p_validation_start_date,
448: p_validation_end_date => p_validation_end_date,
449: p_vald_rlshp_for_reimb_id => p_rec.vald_rlshp_for_reimb_id);
450: --
451: hr_utility.set_location(' Leaving:'||l_proc, 10);
452: End delete_validate;
453: --
454: --
455: -- ---------------------------------------------------------------------------

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

474: l_proc varchar2(72) := g_package||'return_legislation_code';
475: --
476: begin
477: --
478: hr_utility.set_location('Entering:'|| l_proc, 10);
479: --
480: -- Ensure that all the mandatory parameter are not null
481: --
482: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

492: close csr_leg_code;
493: --
494: -- The primary key is invalid therefore we must error
495: --
496: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
497: hr_utility.raise_error;
498: --
499: end if;
500: --

Line 497: hr_utility.raise_error;

493: --
494: -- The primary key is invalid therefore we must error
495: --
496: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
497: hr_utility.raise_error;
498: --
499: end if;
500: --
501: close csr_leg_code;

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

499: end if;
500: --
501: close csr_leg_code;
502: --
503: hr_utility.set_location(' Leaving:'|| l_proc, 20);
504: --
505: return l_legislation_code;
506: --
507: end return_legislation_code;