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_TUR_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_tur_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_tbco_use_rt_id => p_tbco_use_rt_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_tbco_use_rt_id;
78: --
79: -- |--------------------< chk_duplicate_ordr_num >----------------------------|

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

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

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: -- ----------------------------------------------------------------------------

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

170: l_api_updating boolean;
171: --
172: Begin
173: --
174: hr_utility.set_location('Entering:'||l_proc, 5);
175: --
176: l_api_updating := ben_tur_shd.api_updating
177: (p_tbco_use_rt_id => p_tbco_use_rt_id,
178: p_effective_date => p_effective_date,

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

192: p_effective_date => p_effective_date) then
193: --
194: -- raise error as does not exist as lookup
195: --
196: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
197: hr_utility.raise_error;
198: --
199: end if;
200: --

Line 197: hr_utility.raise_error;

193: --
194: -- raise error as does not exist as lookup
195: --
196: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
197: hr_utility.raise_error;
198: --
199: end if;
200: --
201: end if;

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

199: end if;
200: --
201: end if;
202: --
203: hr_utility.set_location('Leaving:'||l_proc,10);
204: --
205: end chk_excld_flag;
206: --
207: -- ----------------------------------------------------------------------------

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

255: and p_validation_end_date >= effective_start_date;
256: -- end bug # 2452735
257: Begin
258: --
259: hr_utility.set_location('Entering:'||l_proc, 5);
260: --
261: l_api_updating := ben_tur_shd.api_updating
262: (p_tbco_use_rt_id => p_tbco_use_rt_id,
263: p_effective_date => p_effective_date,

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

277: p_effective_date => p_effective_date) then
278: --
279: -- raise error as does not exist as lookup
280: --
281: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
282: hr_utility.raise_error;
283: --
284: end if;
285: --

Line 282: hr_utility.raise_error;

278: --
279: -- raise error as does not exist as lookup
280: --
281: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
282: hr_utility.raise_error;
283: --
284: end if;
285: --
286: -- begin bug # 2452735

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

300: close c_dup;
301: -- end bug # 2452735
302: end if;
303: --
304: hr_utility.set_location('Leaving:'||l_proc,10);
305: --
306: end chk_uses_tbco_flag;
307: --
308: -- ----------------------------------------------------------------------------

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

344: l_integrity_error Exception;
345: l_table_name all_tables.table_name%TYPE;
346: --
347: Begin
348: hr_utility.set_location('Entering:'||l_proc, 5);
349: --
350: -- Ensure that the p_datetrack_mode argument is not null
351: --
352: hr_api.mandatory_arg_error

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

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

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

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

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

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

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

399: -- we must report
400: --
401: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
402: hr_utility.set_message_token('PROCEDURE', l_proc);
403: hr_utility.set_message_token('STEP','15');
404: hr_utility.raise_error;
405: End dt_update_validate;
406: --
407: -- ----------------------------------------------------------------------------

Line 404: hr_utility.raise_error;

400: --
401: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
402: hr_utility.set_message_token('PROCEDURE', l_proc);
403: hr_utility.set_message_token('STEP','15');
404: hr_utility.raise_error;
405: End dt_update_validate;
406: --
407: -- ----------------------------------------------------------------------------
408: -- |--------------------------< dt_delete_validate >--------------------------|

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

449: l_rows_exist Exception;
450: l_table_name all_tables.table_name%TYPE;
451: --
452: Begin
453: hr_utility.set_location('Entering:'||l_proc, 5);
454: --
455: -- Ensure that the p_datetrack_mode argument is not null
456: --
457: hr_api.mandatory_arg_error

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

486: --
487: --
488: End If;
489: --
490: hr_utility.set_location(' Leaving:'||l_proc, 10);
491: Exception
492: When l_rows_exist Then
493: --
494: -- A referential integrity check was violated therefore

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

493: --
494: -- A referential integrity check was violated therefore
495: -- we must error
496: --
497: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
498: hr_utility.set_message_token('TABLE_NAME', l_table_name);
499: hr_utility.raise_error;
500: When Others Then
501: --

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

494: -- A referential integrity check was violated therefore
495: -- we must error
496: --
497: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
498: hr_utility.set_message_token('TABLE_NAME', l_table_name);
499: hr_utility.raise_error;
500: When Others Then
501: --
502: -- An unhandled or unexpected error has occurred which

Line 499: hr_utility.raise_error;

495: -- we must error
496: --
497: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
498: hr_utility.set_message_token('TABLE_NAME', l_table_name);
499: hr_utility.raise_error;
500: When Others Then
501: --
502: -- An unhandled or unexpected error has occurred which
503: -- we must report

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

501: --
502: -- An unhandled or unexpected error has occurred which
503: -- we must report
504: --
505: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
506: hr_utility.set_message_token('PROCEDURE', l_proc);
507: hr_utility.set_message_token('STEP','15');
508: hr_utility.raise_error;
509: End dt_delete_validate;

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

502: -- An unhandled or unexpected error has occurred which
503: -- we must report
504: --
505: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
506: hr_utility.set_message_token('PROCEDURE', l_proc);
507: hr_utility.set_message_token('STEP','15');
508: hr_utility.raise_error;
509: End dt_delete_validate;
510: --

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

503: -- we must report
504: --
505: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
506: hr_utility.set_message_token('PROCEDURE', l_proc);
507: hr_utility.set_message_token('STEP','15');
508: hr_utility.raise_error;
509: End dt_delete_validate;
510: --
511: -- ----------------------------------------------------------------------------

Line 508: hr_utility.raise_error;

504: --
505: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
506: hr_utility.set_message_token('PROCEDURE', l_proc);
507: hr_utility.set_message_token('STEP','15');
508: hr_utility.raise_error;
509: End dt_delete_validate;
510: --
511: -- ----------------------------------------------------------------------------
512: -- |---------------------------< insert_validate >----------------------------|

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

520: --
521: l_proc varchar2(72) := g_package||'insert_validate';
522: --
523: Begin
524: hr_utility.set_location('Entering:'||l_proc, 5);
525: --
526: -- Call all supporting business operations
527: --
528: --

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

555: ,p_effective_date => p_effective_date
556: ,p_business_group_id => p_rec.business_group_id
557: ,p_tbco_use_rt_id => p_rec.tbco_use_rt_id);
558: --
559: hr_utility.set_location(' Leaving:'||l_proc, 10);
560: End insert_validate;
561: --
562: -- ----------------------------------------------------------------------------
563: -- |---------------------------< update_validate >----------------------------|

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

571: --
572: l_proc varchar2(72) := g_package||'update_validate';
573: --
574: Begin
575: hr_utility.set_location('Entering:'||l_proc, 5);
576: --
577: -- Call all supporting business operations
578: --
579: --

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

614: ,p_effective_date => p_effective_date
615: ,p_business_group_id => p_rec.business_group_id
616: ,p_tbco_use_rt_id => p_rec.tbco_use_rt_id);
617: --
618: hr_utility.set_location(' Leaving:'||l_proc, 10);
619: End update_validate;
620: --
621: -- ----------------------------------------------------------------------------
622: -- |---------------------------< delete_validate >----------------------------|

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

630: --
631: l_proc varchar2(72) := g_package||'delete_validate';
632: --
633: Begin
634: hr_utility.set_location('Entering:'||l_proc, 5);
635: --
636: -- Call all supporting business operations
637: --
638: dt_delete_validate

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

640: p_validation_start_date => p_validation_start_date,
641: p_validation_end_date => p_validation_end_date,
642: p_tbco_use_rt_id => p_rec.tbco_use_rt_id);
643: --
644: hr_utility.set_location(' Leaving:'||l_proc, 10);
645: End delete_validate;
646: --
647: --
648: -- ---------------------------------------------------------------------------

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

667: l_proc varchar2(72) := g_package||'return_legislation_code';
668: --
669: begin
670: --
671: hr_utility.set_location('Entering:'|| l_proc, 10);
672: --
673: -- Ensure that all the mandatory parameter are not null
674: --
675: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

685: close csr_leg_code;
686: --
687: -- The primary key is invalid therefore we must error
688: --
689: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
690: hr_utility.raise_error;
691: --
692: end if;
693: --

Line 690: hr_utility.raise_error;

686: --
687: -- The primary key is invalid therefore we must error
688: --
689: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
690: hr_utility.raise_error;
691: --
692: end if;
693: --
694: close csr_leg_code;

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

692: end if;
693: --
694: close csr_leg_code;
695: --
696: hr_utility.set_location(' Leaving:'|| l_proc, 20);
697: --
698: return l_legislation_code;
699: --
700: end return_legislation_code;