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_ETU_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_etu_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_elig_tbco_use_prte_id => p_elig_tbco_use_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_tbco_use_prte_id;
78: --
79: -- ---------------------------------------------------------------------------

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

119: and ordr_num = p_ordr_num
120: and business_group_id = p_business_group_id;
121: --
122: Begin
123: hr_utility.set_location('Entering:'||l_proc, 5);
124: --
125: open c1;
126: fetch c1 into l_dummy;
127: if c1%found then

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

130: fnd_message.raise_error;
131: end if;
132: close c1;
133: --
134: hr_utility.set_location('Leaving:'||l_proc, 15);
135: End chk_duplicate_ordr_num;
136: --
137: -- ----------------------------------------------------------------------------
138: -- |------< chk_dup_elig_criteria >------|

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

177: and etu.elig_tbco_use_prte_id <> nvl(p_elig_tbco_use_prte_id, hr_api.g_number) ;
178: --
179: Begin
180: --
181: hr_utility.set_location('Entering:'||l_proc, 5);
182: --
183: l_api_updating := ben_etu_shd.api_updating
184: (p_elig_tbco_use_prte_id => p_elig_tbco_use_prte_id,
185: p_effective_date => p_effective_date,

Line 195: hr_utility.set_location(l_proc, 7);

191: fetch c_elig_tbco_use_prte into l_dummy;
192: if c_elig_tbco_use_prte%found then
193: --
194: close c_elig_tbco_use_prte;
195: hr_utility.set_location(l_proc, 7);
196: --
197: -- raise error as duplicate criteria has been entered
198: --
199: fnd_message.set_name('BEN','BEN_91349_DUP_ELIG_CRITERIA');

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

202: end if;
203: --
204: close c_elig_tbco_use_prte;
205: --
206: hr_utility.set_location('Leaving:'||l_proc,10);
207: --
208: end chk_dup_elig_criteria;
209: --
210: -- ----------------------------------------------------------------------------

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

242: l_api_updating boolean;
243: --
244: Begin
245: --
246: hr_utility.set_location('Entering:'||l_proc, 5);
247: --
248: l_api_updating := ben_etu_shd.api_updating
249: (p_elig_tbco_use_prte_id => p_elig_tbco_use_prte_id,
250: p_effective_date => p_effective_date,

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

264: p_effective_date => p_effective_date) then
265: --
266: -- raise error as does not exist as lookup
267: --
268: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
269: hr_utility.raise_error;
270: --
271: end if;
272: --

Line 269: hr_utility.raise_error;

265: --
266: -- raise error as does not exist as lookup
267: --
268: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
269: hr_utility.raise_error;
270: --
271: end if;
272: --
273: end if;

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

271: end if;
272: --
273: end if;
274: --
275: hr_utility.set_location('Leaving:'||l_proc,10);
276: --
277: end chk_excld_flag;
278: --
279: -- ----------------------------------------------------------------------------

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

311: l_api_updating boolean;
312: --
313: Begin
314: --
315: hr_utility.set_location('Entering:'||l_proc, 5);
316: --
317: l_api_updating := ben_etu_shd.api_updating
318: (p_elig_tbco_use_prte_id => p_elig_tbco_use_prte_id,
319: p_effective_date => p_effective_date,

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

333: p_effective_date => p_effective_date) then
334: --
335: -- raise error as does not exist as lookup
336: --
337: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
338: hr_utility.raise_error;
339: --
340: end if;
341: --

Line 338: hr_utility.raise_error;

334: --
335: -- raise error as does not exist as lookup
336: --
337: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
338: hr_utility.raise_error;
339: --
340: end if;
341: --
342: end if;

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

340: end if;
341: --
342: end if;
343: --
344: hr_utility.set_location('Leaving:'||l_proc,10);
345: --
346: end chk_uses_tbco_flag;
347: --
348: -- ----------------------------------------------------------------------------

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

384: l_integrity_error Exception;
385: l_table_name all_tables.table_name%TYPE;
386: --
387: Begin
388: hr_utility.set_location('Entering:'||l_proc, 5);
389: --
390: -- Ensure that the p_datetrack_mode argument is not null
391: --
392: hr_api.mandatory_arg_error

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

423: End If;
424: --
425: End If;
426: --
427: hr_utility.set_location(' Leaving:'||l_proc, 10);
428: Exception
429: When l_integrity_error Then
430: --
431: -- A referential integrity check was violated therefore

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

437: --
438: -- An unhandled or unexpected error has occurred which
439: -- we must report
440: --
441: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
442: hr_utility.set_message_token('PROCEDURE', l_proc);
443: hr_utility.set_message_token('STEP','15');
444: hr_utility.raise_error;
445: End dt_update_validate;

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

438: -- An unhandled or unexpected error has occurred which
439: -- we must report
440: --
441: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
442: hr_utility.set_message_token('PROCEDURE', l_proc);
443: hr_utility.set_message_token('STEP','15');
444: hr_utility.raise_error;
445: End dt_update_validate;
446: --

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

439: -- we must report
440: --
441: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
442: hr_utility.set_message_token('PROCEDURE', l_proc);
443: hr_utility.set_message_token('STEP','15');
444: hr_utility.raise_error;
445: End dt_update_validate;
446: --
447: -- ----------------------------------------------------------------------------

Line 444: hr_utility.raise_error;

440: --
441: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
442: hr_utility.set_message_token('PROCEDURE', l_proc);
443: hr_utility.set_message_token('STEP','15');
444: hr_utility.raise_error;
445: End dt_update_validate;
446: --
447: -- ----------------------------------------------------------------------------
448: -- |--------------------------< dt_delete_validate >--------------------------|

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

489: l_rows_exist Exception;
490: l_table_name all_tables.table_name%TYPE;
491: --
492: Begin
493: hr_utility.set_location('Entering:'||l_proc, 5);
494: --
495: -- Ensure that the p_datetrack_mode argument is not null
496: --
497: hr_api.mandatory_arg_error

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

526: --
527: --
528: End If;
529: --
530: hr_utility.set_location(' Leaving:'||l_proc, 10);
531: Exception
532: When l_rows_exist Then
533: --
534: -- A referential integrity check was violated therefore

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

533: --
534: -- A referential integrity check was violated therefore
535: -- we must error
536: --
537: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
538: hr_utility.set_message_token('TABLE_NAME', l_table_name);
539: hr_utility.raise_error;
540: When Others Then
541: --

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

534: -- A referential integrity check was violated therefore
535: -- we must error
536: --
537: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
538: hr_utility.set_message_token('TABLE_NAME', l_table_name);
539: hr_utility.raise_error;
540: When Others Then
541: --
542: -- An unhandled or unexpected error has occurred which

Line 539: hr_utility.raise_error;

535: -- we must error
536: --
537: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
538: hr_utility.set_message_token('TABLE_NAME', l_table_name);
539: hr_utility.raise_error;
540: When Others Then
541: --
542: -- An unhandled or unexpected error has occurred which
543: -- we must report

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

541: --
542: -- An unhandled or unexpected error has occurred which
543: -- we must report
544: --
545: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
546: hr_utility.set_message_token('PROCEDURE', l_proc);
547: hr_utility.set_message_token('STEP','15');
548: hr_utility.raise_error;
549: End dt_delete_validate;

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

542: -- An unhandled or unexpected error has occurred which
543: -- we must report
544: --
545: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
546: hr_utility.set_message_token('PROCEDURE', l_proc);
547: hr_utility.set_message_token('STEP','15');
548: hr_utility.raise_error;
549: End dt_delete_validate;
550: --

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

543: -- we must report
544: --
545: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
546: hr_utility.set_message_token('PROCEDURE', l_proc);
547: hr_utility.set_message_token('STEP','15');
548: hr_utility.raise_error;
549: End dt_delete_validate;
550: --
551: -- ----------------------------------------------------------------------------

Line 548: hr_utility.raise_error;

544: --
545: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
546: hr_utility.set_message_token('PROCEDURE', l_proc);
547: hr_utility.set_message_token('STEP','15');
548: hr_utility.raise_error;
549: End dt_delete_validate;
550: --
551: -- ----------------------------------------------------------------------------
552: -- |---------------------------< insert_validate >----------------------------|

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

560: --
561: l_proc varchar2(72) := g_package||'insert_validate';
562: --
563: Begin
564: hr_utility.set_location('Entering:'||l_proc, 5);
565: --
566: -- Call all supporting business operations
567: --
568: --

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

597: p_uses_tbco_flag => p_rec.uses_tbco_flag,
598: p_effective_date => p_effective_date,
599: p_object_version_number => p_rec.object_version_number);
600: --
601: hr_utility.set_location(' Leaving:'||l_proc, 10);
602: End insert_validate;
603: --
604: -- ----------------------------------------------------------------------------
605: -- |---------------------------< update_validate >----------------------------|

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

613: --
614: l_proc varchar2(72) := g_package||'update_validate';
615: --
616: Begin
617: hr_utility.set_location('Entering:'||l_proc, 5);
618: --
619: -- Call all supporting business operations
620: --
621: --

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

658: p_datetrack_mode => p_datetrack_mode,
659: p_validation_start_date => p_validation_start_date,
660: p_validation_end_date => p_validation_end_date);
661: --
662: hr_utility.set_location(' Leaving:'||l_proc, 10);
663: End update_validate;
664: --
665: -- ----------------------------------------------------------------------------
666: -- |---------------------------< delete_validate >----------------------------|

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

674: --
675: l_proc varchar2(72) := g_package||'delete_validate';
676: --
677: Begin
678: hr_utility.set_location('Entering:'||l_proc, 5);
679: --
680: -- Call all supporting business operations
681: --
682: dt_delete_validate

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

684: p_validation_start_date => p_validation_start_date,
685: p_validation_end_date => p_validation_end_date,
686: p_elig_tbco_use_prte_id => p_rec.elig_tbco_use_prte_id);
687: --
688: hr_utility.set_location(' Leaving:'||l_proc, 10);
689: End delete_validate;
690: --
691: --
692: -- ---------------------------------------------------------------------------

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

711: l_proc varchar2(72) := g_package||'return_legislation_code';
712: --
713: begin
714: --
715: hr_utility.set_location('Entering:'|| l_proc, 10);
716: --
717: -- Ensure that all the mandatory parameter are not null
718: --
719: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

729: close csr_leg_code;
730: --
731: -- The primary key is invalid therefore we must error
732: --
733: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
734: hr_utility.raise_error;
735: --
736: end if;
737: --

Line 734: hr_utility.raise_error;

730: --
731: -- The primary key is invalid therefore we must error
732: --
733: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
734: hr_utility.raise_error;
735: --
736: end if;
737: --
738: close csr_leg_code;

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

736: end if;
737: --
738: close csr_leg_code;
739: --
740: hr_utility.set_location(' Leaving:'|| l_proc, 20);
741: --
742: return l_legislation_code;
743: --
744: end return_legislation_code;