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_ESR_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_esr_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_ee_stat_rt_id => p_ee_stat_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_ee_stat_rt_id;
78:
79: --

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

133: and p_validation_end_date >= effective_start_date;
134: --
135: BEGIN
136: --
137: hr_utility.set_location('Entering:'||l_proc, 5);
138: --
139: l_api_updating := ben_esr_shd.api_updating
140: (p_ee_stat_rt_id => p_ee_stat_rt_id,
141: p_effective_date => p_effective_date,

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

160: end if;
161: close c_dup;
162: --
163: end if;
164: hr_utility.set_location('Leaving:'||l_proc,10);
165: --
166: END chk_dup_record;
167:
168: --

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

209: and business_group_id + 0 = p_business_group_id
210: and ordr_num = p_ordr_num;
211: --
212: Begin
213: hr_utility.set_location('Entering:'||l_proc, 5);
214:
215: --
216: open c1;
217: fetch c1 into l_dummy;

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

221: fnd_message.raise_error;
222: end if;
223: close c1;
224: --
225: hr_utility.set_location('Leaving:'||l_proc, 15);
226: End chk_duplicate_ordr_num;
227: -- ----------------------------------------------------------------------------
228: -- |------< chk_excld_flag >------|
229: -- ----------------------------------------------------------------------------

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

259: l_api_updating boolean;
260: --
261: Begin
262: --
263: hr_utility.set_location('Entering:'||l_proc, 5);
264: --
265: l_api_updating := ben_esr_shd.api_updating
266: (p_ee_stat_rt_id => p_ee_stat_rt_id,
267: p_effective_date => p_effective_date,

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

281: p_effective_date => p_effective_date) then
282: --
283: -- raise error as does not exist as lookup
284: --
285: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
286: hr_utility.raise_error;
287: --
288: end if;
289: --

Line 286: hr_utility.raise_error;

282: --
283: -- raise error as does not exist as lookup
284: --
285: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
286: hr_utility.raise_error;
287: --
288: end if;
289: --
290: end if;

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

288: end if;
289: --
290: end if;
291: --
292: hr_utility.set_location('Leaving:'||l_proc,10);
293: --
294: end chk_excld_flag;
295: --
296: -- ----------------------------------------------------------------------------

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

333: l_integrity_error Exception;
334: l_table_name all_tables.table_name%TYPE;
335: --
336: Begin
337: hr_utility.set_location('Entering:'||l_proc, 5);
338: --
339: -- Ensure that the p_datetrack_mode argument is not null
340: --
341: 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 504: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

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

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

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

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

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

Line 507: hr_utility.raise_error;

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

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

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

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

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

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

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

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_ee_stat_rt_id => p_rec.ee_stat_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_ee_stat_rt_id => p_rec.ee_stat_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;