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_BUR_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_bur_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_brgng_unit_rt_id => p_brgng_unit_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_brgng_unit_rt_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_bur_shd.api_updating
118: (p_brgng_unit_rt_id => p_brgng_unit_rt_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_brgng_unit_cd;
147:
148: --

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

202: and p_validation_end_date >= effective_start_date;
203: --
204: BEGIN
205: --
206: hr_utility.set_location('Entering:'||l_proc, 5);
207: --
208: l_api_updating := ben_bur_shd.api_updating
209: (p_brgng_unit_rt_id => p_brgng_unit_rt_id,
210: p_effective_date => p_effective_date,

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

229: end if;
230: close c_dup;
231: --
232: end if;
233: hr_utility.set_location('Leaving:'||l_proc,10);
234: --
235: END chk_dup_record;
236: --
237: -- ----------------------------------------------------------------------------

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

269: l_api_updating boolean;
270: --
271: Begin
272: --
273: hr_utility.set_location('Entering:'||l_proc, 5);
274: --
275: l_api_updating := ben_bur_shd.api_updating
276: (p_brgng_unit_rt_id => p_brgng_unit_rt_id,
277: p_effective_date => p_effective_date,

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

291: p_effective_date => p_effective_date) then
292: --
293: -- raise error as does not exist as lookup
294: --
295: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
296: hr_utility.raise_error;
297: --
298: end if;
299: --

Line 296: hr_utility.raise_error;

292: --
293: -- raise error as does not exist as lookup
294: --
295: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
296: hr_utility.raise_error;
297: --
298: end if;
299: --
300: end if;

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

298: end if;
299: --
300: end if;
301: --
302: hr_utility.set_location('Leaving:'||l_proc,10);
303: --
304: end chk_excld_flag;
305: --
306: -- ----------------------------------------------------------------------------

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

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

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

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

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

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

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

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

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

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

Line 402: hr_utility.raise_error;

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

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

480: and ordr_num = p_ordr_num
481: and (brgng_unit_rt_id <> p_brgng_unit_rt_id or p_brgng_unit_rt_id is null);
482: --
483: Begin
484: hr_utility.set_location('Entering:'||l_proc, 5);
485:
486: --
487: open c1;
488: fetch c1 into l_dummy;

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

492: fnd_message.raise_error;
493: end if;
494: close c1;
495: --
496: hr_utility.set_location('Leaving:'||l_proc, 15);
497: End chk_duplicate_ordr_num;
498:
499: -- ----------------------------------------------------------------------------
500: Procedure dt_delete_validate

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

507: l_rows_exist Exception;
508: l_table_name all_tables.table_name%TYPE;
509: --
510: Begin
511: hr_utility.set_location('Entering:'||l_proc, 5);
512: --
513: -- Ensure that the p_datetrack_mode argument is not null
514: --
515: hr_api.mandatory_arg_error

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

544: --
545: --
546: End If;
547: --
548: hr_utility.set_location(' Leaving:'||l_proc, 10);
549: Exception
550: When l_rows_exist Then
551: --
552: -- A referential integrity check was violated therefore

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

558: --
559: -- An unhandled or unexpected error has occurred which
560: -- we must report
561: --
562: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
563: hr_utility.set_message_token('PROCEDURE', l_proc);
564: hr_utility.set_message_token('STEP','15');
565: hr_utility.raise_error;
566: End dt_delete_validate;

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

559: -- An unhandled or unexpected error has occurred which
560: -- we must report
561: --
562: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
563: hr_utility.set_message_token('PROCEDURE', l_proc);
564: hr_utility.set_message_token('STEP','15');
565: hr_utility.raise_error;
566: End dt_delete_validate;
567: --

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

560: -- we must report
561: --
562: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
563: hr_utility.set_message_token('PROCEDURE', l_proc);
564: hr_utility.set_message_token('STEP','15');
565: hr_utility.raise_error;
566: End dt_delete_validate;
567: --
568: -- ----------------------------------------------------------------------------

Line 565: hr_utility.raise_error;

561: --
562: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
563: hr_utility.set_message_token('PROCEDURE', l_proc);
564: hr_utility.set_message_token('STEP','15');
565: hr_utility.raise_error;
566: End dt_delete_validate;
567: --
568: -- ----------------------------------------------------------------------------
569: -- |---------------------------< insert_validate >----------------------------|

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

577: --
578: l_proc varchar2(72) := g_package||'insert_validate';
579: --
580: Begin
581: hr_utility.set_location('Entering:'||l_proc, 5);
582: --
583: -- Call all supporting business operations
584: --
585: --

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

619: ,p_ordr_num => p_rec.ordr_num
620: ,p_effective_date => p_effective_date
621: ,p_business_group_id => p_rec.business_group_id);
622: --
623: hr_utility.set_location(' Leaving:'||l_proc,10);
624:
625:
626:
627: End insert_validate;

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

638: --
639: l_proc varchar2(72) := g_package||'update_validate';
640: --
641: Begin
642: hr_utility.set_location('Entering:'||l_proc, 5);
643: --
644: -- Call all supporting business operations
645: --
646: --

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

696: ,p_ordr_num => p_rec.ordr_num
697: ,p_effective_date => p_effective_date
698: ,p_business_group_id => p_rec.business_group_id);
699: --
700: hr_utility.set_location(' Leaving:'||l_proc, 10);
701: End update_validate;
702: --
703: -- ----------------------------------------------------------------------------
704: -- |---------------------------< delete_validate >----------------------------|

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

712: --
713: l_proc varchar2(72) := g_package||'delete_validate';
714: --
715: Begin
716: hr_utility.set_location('Entering:'||l_proc, 5);
717: --
718: -- Call all supporting business operations
719: --
720: dt_delete_validate

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

722: p_validation_start_date => p_validation_start_date,
723: p_validation_end_date => p_validation_end_date,
724: p_brgng_unit_rt_id => p_rec.brgng_unit_rt_id);
725: --
726: hr_utility.set_location(' Leaving:'||l_proc, 10);
727: End delete_validate;
728: --
729: --
730: -- ---------------------------------------------------------------------------

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

749: l_proc varchar2(72) := g_package||'return_legislation_code';
750: --
751: begin
752: --
753: hr_utility.set_location('Entering:'|| l_proc, 10);
754: --
755: -- Ensure that all the mandatory parameter are not null
756: --
757: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

767: close csr_leg_code;
768: --
769: -- The primary key is invalid therefore we must error
770: --
771: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
772: hr_utility.raise_error;
773: --
774: end if;
775: --

Line 772: hr_utility.raise_error;

768: --
769: -- The primary key is invalid therefore we must error
770: --
771: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
772: hr_utility.raise_error;
773: --
774: end if;
775: --
776: close csr_leg_code;

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

774: end if;
775: --
776: close csr_leg_code;
777: --
778: hr_utility.set_location(' Leaving:'|| l_proc, 20);
779: --
780: return l_legislation_code;
781: --
782: end return_legislation_code;