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_EPG_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_epg_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_elig_ppl_grp_prte_id => p_elig_ppl_grp_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_ppl_grp_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_epg_shd.api_updating
118: (p_elig_ppl_grp_prte_id => p_elig_ppl_grp_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: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: -- |--------------------------< dt_update_validate >--------------------------|
208: -- ----------------------------------------------------------------------------

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

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

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

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

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

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

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

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

Line 294: hr_utility.raise_error;

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

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

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

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

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

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

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

Line 303: hr_utility.raise_error;

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

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

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

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

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

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

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

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

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

Line 398: hr_utility.raise_error;

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

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

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

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

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

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

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

Line 407: hr_utility.raise_error;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 567: hr_utility.raise_error;

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

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

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