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_EPP_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_epp_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_elig_prtt_anthr_pl_prte_id => p_elig_prtt_anthr_pl_prte_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_elig_prtt_anthr_pl_prte_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_epp_shd.api_updating
118: (p_elig_prtt_anthr_pl_prte_id => p_elig_prtt_anthr_pl_prte_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_excld_flag;
147: --
148: --Bug No:5054189

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

189: and ordr_num = p_ordr_num
190: and business_group_id = p_business_group_id;
191: --
192: Begin
193: hr_utility.set_location('Entering:'||l_proc, 5);
194: --
195: open c1;
196: fetch c1 into l_dummy;
197: if c1%found then

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

200: fnd_message.raise_error;
201: end if;
202: close c1;
203: --
204: hr_utility.set_location('Leaving:'||l_proc, 15);
205: End chk_duplicate_ordr_num;
206:
207: -- ----------------------------------------------------------------------------
208: -- |--------------------------< dt_update_validate >--------------------------|

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

243: l_integrity_error Exception;
244: l_table_name all_tables.table_name%TYPE;
245: --
246: Begin
247: hr_utility.set_location('Entering:'||l_proc, 5);
248: --
249: -- Ensure that the p_datetrack_mode argument is not null
250: --
251: hr_api.mandatory_arg_error

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

282: End If;
283: --
284: End If;
285: --
286: hr_utility.set_location(' Leaving:'||l_proc, 10);
287: Exception
288: When l_integrity_error Then
289: --
290: -- A referential integrity check was violated therefore

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

289: --
290: -- A referential integrity check was violated therefore
291: -- we must error
292: --
293: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
294: hr_utility.set_message_token('TABLE_NAME', l_table_name);
295: hr_utility.raise_error;
296: When Others Then
297: --

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

290: -- A referential integrity check was violated therefore
291: -- we must error
292: --
293: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
294: hr_utility.set_message_token('TABLE_NAME', l_table_name);
295: hr_utility.raise_error;
296: When Others Then
297: --
298: -- An unhandled or unexpected error has occurred which

Line 295: hr_utility.raise_error;

291: -- we must error
292: --
293: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
294: hr_utility.set_message_token('TABLE_NAME', l_table_name);
295: hr_utility.raise_error;
296: When Others Then
297: --
298: -- An unhandled or unexpected error has occurred which
299: -- we must report

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

297: --
298: -- An unhandled or unexpected error has occurred which
299: -- we must report
300: --
301: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
302: hr_utility.set_message_token('PROCEDURE', l_proc);
303: hr_utility.set_message_token('STEP','15');
304: hr_utility.raise_error;
305: End dt_update_validate;

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

298: -- An unhandled or unexpected error has occurred which
299: -- we must report
300: --
301: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
302: hr_utility.set_message_token('PROCEDURE', l_proc);
303: hr_utility.set_message_token('STEP','15');
304: hr_utility.raise_error;
305: End dt_update_validate;
306: --

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

299: -- we must report
300: --
301: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
302: hr_utility.set_message_token('PROCEDURE', l_proc);
303: hr_utility.set_message_token('STEP','15');
304: hr_utility.raise_error;
305: End dt_update_validate;
306: --
307: -- ----------------------------------------------------------------------------

Line 304: hr_utility.raise_error;

300: --
301: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
302: hr_utility.set_message_token('PROCEDURE', l_proc);
303: hr_utility.set_message_token('STEP','15');
304: hr_utility.raise_error;
305: End dt_update_validate;
306: --
307: -- ----------------------------------------------------------------------------
308: -- |--------------------------< dt_delete_validate >--------------------------|

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

349: l_rows_exist Exception;
350: l_table_name all_tables.table_name%TYPE;
351: --
352: Begin
353: hr_utility.set_location('Entering:'||l_proc, 5);
354: --
355: -- Ensure that the p_datetrack_mode argument is not null
356: --
357: hr_api.mandatory_arg_error

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

386: --
387: --
388: End If;
389: --
390: hr_utility.set_location(' Leaving:'||l_proc, 10);
391: Exception
392: When l_rows_exist Then
393: --
394: -- A referential integrity check was violated therefore

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

393: --
394: -- A referential integrity check was violated therefore
395: -- we must error
396: --
397: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
398: hr_utility.set_message_token('TABLE_NAME', l_table_name);
399: hr_utility.raise_error;
400: When Others Then
401: --

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

394: -- A referential integrity check was violated therefore
395: -- we must error
396: --
397: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
398: hr_utility.set_message_token('TABLE_NAME', l_table_name);
399: hr_utility.raise_error;
400: When Others Then
401: --
402: -- An unhandled or unexpected error has occurred which

Line 399: hr_utility.raise_error;

395: -- we must error
396: --
397: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
398: hr_utility.set_message_token('TABLE_NAME', l_table_name);
399: hr_utility.raise_error;
400: When Others Then
401: --
402: -- An unhandled or unexpected error has occurred which
403: -- we must report

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

401: --
402: -- An unhandled or unexpected error has occurred which
403: -- we must report
404: --
405: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
406: hr_utility.set_message_token('PROCEDURE', l_proc);
407: hr_utility.set_message_token('STEP','15');
408: hr_utility.raise_error;
409: End dt_delete_validate;

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

402: -- An unhandled or unexpected error has occurred which
403: -- we must report
404: --
405: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
406: hr_utility.set_message_token('PROCEDURE', l_proc);
407: hr_utility.set_message_token('STEP','15');
408: hr_utility.raise_error;
409: End dt_delete_validate;
410: --

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

403: -- we must report
404: --
405: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
406: hr_utility.set_message_token('PROCEDURE', l_proc);
407: hr_utility.set_message_token('STEP','15');
408: hr_utility.raise_error;
409: End dt_delete_validate;
410: --
411: -- ----------------------------------------------------------------------------

Line 408: hr_utility.raise_error;

404: --
405: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
406: hr_utility.set_message_token('PROCEDURE', l_proc);
407: hr_utility.set_message_token('STEP','15');
408: hr_utility.raise_error;
409: End dt_delete_validate;
410: --
411: -- ----------------------------------------------------------------------------
412: -- |---------------------------< insert_validate >----------------------------|

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

420: --
421: l_proc varchar2(72) := g_package||'insert_validate';
422: --
423: Begin
424: hr_utility.set_location('Entering:'||l_proc, 5);
425: --
426: -- Call all supporting business operations
427: --
428: --

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

444: p_eligy_prfl_id => p_rec.eligy_prfl_id,
445: p_ordr_num => p_rec.ordr_num,
446: p_business_group_id => p_rec.business_group_id);
447: --
448: hr_utility.set_location(' Leaving:'||l_proc, 10);
449: End insert_validate;
450: --
451: -- ----------------------------------------------------------------------------
452: -- |---------------------------< update_validate >----------------------------|

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

460: --
461: l_proc varchar2(72) := g_package||'update_validate';
462: --
463: Begin
464: hr_utility.set_location('Entering:'||l_proc, 5);
465: --
466: -- Call all supporting business operations
467: --
468: --

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

492: p_datetrack_mode => p_datetrack_mode,
493: p_validation_start_date => p_validation_start_date,
494: p_validation_end_date => p_validation_end_date);
495: --
496: hr_utility.set_location(' Leaving:'||l_proc, 10);
497: End update_validate;
498: --
499: -- ----------------------------------------------------------------------------
500: -- |---------------------------< delete_validate >----------------------------|

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

508: --
509: l_proc varchar2(72) := g_package||'delete_validate';
510: --
511: Begin
512: hr_utility.set_location('Entering:'||l_proc, 5);
513: --
514: -- Call all supporting business operations
515: --
516: dt_delete_validate

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

518: p_validation_start_date => p_validation_start_date,
519: p_validation_end_date => p_validation_end_date,
520: p_elig_prtt_anthr_pl_prte_id => p_rec.elig_prtt_anthr_pl_prte_id);
521: --
522: hr_utility.set_location(' Leaving:'||l_proc, 10);
523: End delete_validate;
524: --
525: --
526: -- ---------------------------------------------------------------------------

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

545: l_proc varchar2(72) := g_package||'return_legislation_code';
546: --
547: begin
548: --
549: hr_utility.set_location('Entering:'|| l_proc, 10);
550: --
551: -- Ensure that all the mandatory parameter are not null
552: --
553: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

563: close csr_leg_code;
564: --
565: -- The primary key is invalid therefore we must error
566: --
567: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
568: hr_utility.raise_error;
569: --
570: end if;
571: --

Line 568: hr_utility.raise_error;

564: --
565: -- The primary key is invalid therefore we must error
566: --
567: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
568: hr_utility.raise_error;
569: --
570: end if;
571: --
572: close csr_leg_code;

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

570: end if;
571: --
572: close csr_leg_code;
573: --
574: hr_utility.set_location(' Leaving:'|| l_proc, 20);
575: --
576: return l_legislation_code;
577: --
578: end return_legislation_code;