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_ASR_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_asr_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_asnt_set_rt_id => p_asnt_set_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_asnt_set_rt_id;
78:
79:

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

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

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

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

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

202: l_api_updating boolean;
203: --
204: Begin
205: --
206: hr_utility.set_location('Entering:'||l_proc, 5);
207: --
208: l_api_updating := ben_asr_shd.api_updating
209: (p_asnt_set_rt_id => p_asnt_set_rt_id,
210: p_effective_date => p_effective_date,

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

224: p_effective_date => p_effective_date) then
225: --
226: -- raise error as does not exist as lookup
227: --
228: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
229: hr_utility.raise_error;
230: --
231: end if;
232: --

Line 229: hr_utility.raise_error;

225: --
226: -- raise error as does not exist as lookup
227: --
228: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
229: hr_utility.raise_error;
230: --
231: end if;
232: --
233: end if;

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

231: end if;
232: --
233: end if;
234: --
235: hr_utility.set_location('Leaving:'||l_proc,10);
236: --
237: end chk_excld_flag;
238: --
239: --

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

280: and business_group_id + 0 = p_business_group_id
281: and ordr_num = p_ordr_num;
282: --
283: Begin
284: hr_utility.set_location('Entering:'||l_proc, 5);
285: --
286: open c1;
287: fetch c1 into l_dummy;
288: --

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

296: null;
297: end if;
298: close c1;
299: --
300: hr_utility.set_location('Leaving:'||l_proc, 15);
301: End chk_duplicate_ordr_num;
302: --
303: -- ----------------------------------------------------------------------------
304: -- |--------------------------< dt_update_validate >--------------------------|

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

339: l_integrity_error Exception;
340: l_table_name all_tables.table_name%TYPE;
341: --
342: Begin
343: hr_utility.set_location('Entering:'||l_proc, 5);
344: --
345: -- Ensure that the p_datetrack_mode argument is not null
346: --
347: hr_api.mandatory_arg_error

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

378: End If;
379: --
380: End If;
381: --
382: hr_utility.set_location(' Leaving:'||l_proc, 10);
383: Exception
384: When l_integrity_error Then
385: --
386: -- A referential integrity check was violated therefore

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

391: --
392: -- An unhandled or unexpected error has occurred which
393: -- we must report
394: --
395: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
396: hr_utility.set_message_token('PROCEDURE', l_proc);
397: hr_utility.set_message_token('STEP','15');
398: hr_utility.raise_error;
399: End dt_update_validate;

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

392: -- An unhandled or unexpected error has occurred which
393: -- we must report
394: --
395: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
396: hr_utility.set_message_token('PROCEDURE', l_proc);
397: hr_utility.set_message_token('STEP','15');
398: hr_utility.raise_error;
399: End dt_update_validate;
400: --

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

393: -- we must report
394: --
395: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
396: hr_utility.set_message_token('PROCEDURE', l_proc);
397: hr_utility.set_message_token('STEP','15');
398: hr_utility.raise_error;
399: End dt_update_validate;
400: --
401: -- ----------------------------------------------------------------------------

Line 398: hr_utility.raise_error;

394: --
395: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
396: hr_utility.set_message_token('PROCEDURE', l_proc);
397: hr_utility.set_message_token('STEP','15');
398: hr_utility.raise_error;
399: End dt_update_validate;
400: --
401: -- ----------------------------------------------------------------------------
402: -- |--------------------------< dt_delete_validate >--------------------------|

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

443: l_rows_exist Exception;
444: l_table_name all_tables.table_name%TYPE;
445: --
446: Begin
447: hr_utility.set_location('Entering:'||l_proc, 5);
448: --
449: -- Ensure that the p_datetrack_mode argument is not null
450: --
451: hr_api.mandatory_arg_error

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

480: --
481: --
482: End If;
483: --
484: hr_utility.set_location(' Leaving:'||l_proc, 10);
485: Exception
486: When l_rows_exist Then
487: --
488: -- A referential integrity check was violated therefore

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

494: --
495: -- An unhandled or unexpected error has occurred which
496: -- we must report
497: --
498: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
499: hr_utility.set_message_token('PROCEDURE', l_proc);
500: hr_utility.set_message_token('STEP','15');
501: hr_utility.raise_error;
502: End dt_delete_validate;

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

495: -- An unhandled or unexpected error has occurred which
496: -- we must report
497: --
498: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
499: hr_utility.set_message_token('PROCEDURE', l_proc);
500: hr_utility.set_message_token('STEP','15');
501: hr_utility.raise_error;
502: End dt_delete_validate;
503: --

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

496: -- we must report
497: --
498: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
499: hr_utility.set_message_token('PROCEDURE', l_proc);
500: hr_utility.set_message_token('STEP','15');
501: hr_utility.raise_error;
502: End dt_delete_validate;
503: --
504: -- ----------------------------------------------------------------------------

Line 501: hr_utility.raise_error;

497: --
498: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
499: hr_utility.set_message_token('PROCEDURE', l_proc);
500: hr_utility.set_message_token('STEP','15');
501: hr_utility.raise_error;
502: End dt_delete_validate;
503: --
504: -- ----------------------------------------------------------------------------
505: -- |---------------------------< insert_validate >----------------------------|

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

513: --
514: l_proc varchar2(72) := g_package||'insert_validate';
515: --
516: Begin
517: hr_utility.set_location('Entering:'||l_proc, 5);
518: --
519: -- Call all supporting business operations
520: --
521: --

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

548: ,p_ordr_num => p_rec.ordr_num
549: ,p_effective_date => p_effective_date
550: ,p_business_group_id => p_rec.business_group_id);
551: --
552: hr_utility.set_location(' Leaving:'||l_proc, 10);
553: End insert_validate;
554: --
555: -- ----------------------------------------------------------------------------
556: -- |---------------------------< update_validate >----------------------------|

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

564: --
565: l_proc varchar2(72) := g_package||'update_validate';
566: --
567: Begin
568: hr_utility.set_location('Entering:'||l_proc, 5);
569: --
570: -- Call all supporting business operations
571: --
572: --

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

607: p_datetrack_mode => p_datetrack_mode,
608: p_validation_start_date => p_validation_start_date,
609: p_validation_end_date => p_validation_end_date);
610: --
611: hr_utility.set_location(' Leaving:'||l_proc, 10);
612: End update_validate;
613: --
614: -- ----------------------------------------------------------------------------
615: -- |---------------------------< delete_validate >----------------------------|

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

623: --
624: l_proc varchar2(72) := g_package||'delete_validate';
625: --
626: Begin
627: hr_utility.set_location('Entering:'||l_proc, 5);
628: --
629: -- Call all supporting business operations
630: --
631: dt_delete_validate

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

633: p_validation_start_date => p_validation_start_date,
634: p_validation_end_date => p_validation_end_date,
635: p_asnt_set_rt_id => p_rec.asnt_set_rt_id);
636: --
637: hr_utility.set_location(' Leaving:'||l_proc, 10);
638: End delete_validate;
639: --
640: --
641: -- ---------------------------------------------------------------------------

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

660: l_proc varchar2(72) := g_package||'return_legislation_code';
661: --
662: begin
663: --
664: hr_utility.set_location('Entering:'|| l_proc, 10);
665: --
666: -- Ensure that all the mandatory parameter are not null
667: --
668: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

678: close csr_leg_code;
679: --
680: -- The primary key is invalid therefore we must error
681: --
682: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
683: hr_utility.raise_error;
684: --
685: end if;
686: --

Line 683: hr_utility.raise_error;

679: --
680: -- The primary key is invalid therefore we must error
681: --
682: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
683: hr_utility.raise_error;
684: --
685: end if;
686: --
687: close csr_leg_code;

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

685: end if;
686: --
687: close csr_leg_code;
688: --
689: hr_utility.set_location(' Leaving:'|| l_proc, 20);
690: --
691: return l_legislation_code;
692: --
693: end return_legislation_code;