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_FTR_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_ftr_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_fl_tm_pt_tm_rt_id => p_fl_tm_pt_tm_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_fl_tm_pt_tm_rt_id;
78: --
79:

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

113: l_api_updating boolean;
114: --
115: Begin
116: --
117: hr_utility.set_location('Entering:'||l_proc, 5);
118: --
119: l_api_updating := ben_ftr_shd.api_updating
120: (p_fl_tm_pt_tm_rt_id => p_fl_tm_pt_tm_rt_id,
121: p_effective_date => p_effective_date,

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

135: p_effective_date => p_effective_date) then
136: --
137: -- raise error as does not exist as lookup
138: --
139: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
140: hr_utility.raise_error;
141: --
142: end if;
143: --

Line 140: hr_utility.raise_error;

136: --
137: -- raise error as does not exist as lookup
138: --
139: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
140: hr_utility.raise_error;
141: --
142: end if;
143: --
144: end if;

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

142: end if;
143: --
144: end if;
145: --
146: hr_utility.set_location('Leaving:'||l_proc,10);
147: --
148: end chk_fl_tm_pt_tm_cd;
149:
150:

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

205: and p_validation_end_date >= effective_start_date;
206: --
207: BEGIN
208: --
209: hr_utility.set_location('Entering:'||l_proc, 5);
210: --
211: l_api_updating := ben_ftr_shd.api_updating
212: (p_fl_tm_pt_tm_rt_id => p_fl_tm_pt_tm_rt_id,
213: p_effective_date => p_effective_date,

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

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

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: --
287: open c1;
288: fetch c1 into l_dummy;

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

292: fnd_message.raise_error;
293: end if;
294: close c1;
295: --
296: hr_utility.set_location('Leaving:'||l_proc, 15);
297: End chk_duplicate_ordr_num;
298:
299:
300: -- ----------------------------------------------------------------------------

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

332: l_api_updating boolean;
333: --
334: Begin
335: --
336: hr_utility.set_location('Entering:'||l_proc, 5);
337: --
338: l_api_updating := ben_ftr_shd.api_updating
339: (p_fl_tm_pt_tm_rt_id => p_fl_tm_pt_tm_rt_id,
340: p_effective_date => p_effective_date,

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

354: p_effective_date => p_effective_date) then
355: --
356: -- raise error as does not exist as lookup
357: --
358: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
359: hr_utility.raise_error;
360: --
361: end if;
362: --

Line 359: hr_utility.raise_error;

355: --
356: -- raise error as does not exist as lookup
357: --
358: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
359: hr_utility.raise_error;
360: --
361: end if;
362: --
363: end if;

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

361: end if;
362: --
363: end if;
364: --
365: hr_utility.set_location('Leaving:'||l_proc,10);
366: --
367: end chk_excld_flag;
368: --
369: -- ----------------------------------------------------------------------------

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

405: l_integrity_error Exception;
406: l_table_name all_tables.table_name%TYPE;
407: --
408: Begin
409: hr_utility.set_location('Entering:'||l_proc, 5);
410: --
411: -- Ensure that the p_datetrack_mode argument is not null
412: --
413: hr_api.mandatory_arg_error

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

444: End If;
445: --
446: End If;
447: --
448: hr_utility.set_location(' Leaving:'||l_proc, 10);
449: Exception
450: When l_integrity_error Then
451: --
452: -- A referential integrity check was violated therefore

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

458: --
459: -- An unhandled or unexpected error has occurred which
460: -- we must report
461: --
462: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
463: hr_utility.set_message_token('PROCEDURE', l_proc);
464: hr_utility.set_message_token('STEP','15');
465: hr_utility.raise_error;
466: End dt_update_validate;

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

459: -- An unhandled or unexpected error has occurred which
460: -- we must report
461: --
462: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
463: hr_utility.set_message_token('PROCEDURE', l_proc);
464: hr_utility.set_message_token('STEP','15');
465: hr_utility.raise_error;
466: End dt_update_validate;
467: --

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

460: -- we must report
461: --
462: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
463: hr_utility.set_message_token('PROCEDURE', l_proc);
464: hr_utility.set_message_token('STEP','15');
465: hr_utility.raise_error;
466: End dt_update_validate;
467: --
468: -- ----------------------------------------------------------------------------

Line 465: hr_utility.raise_error;

461: --
462: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
463: hr_utility.set_message_token('PROCEDURE', l_proc);
464: hr_utility.set_message_token('STEP','15');
465: hr_utility.raise_error;
466: End dt_update_validate;
467: --
468: -- ----------------------------------------------------------------------------
469: -- |--------------------------< dt_delete_validate >--------------------------|

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

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

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

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

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

554: --
555: -- A referential integrity check was violated therefore
556: -- we must error
557: --
558: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
559: hr_utility.set_message_token('TABLE_NAME', l_table_name);
560: hr_utility.raise_error;
561: When Others Then
562: --

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

555: -- A referential integrity check was violated therefore
556: -- we must error
557: --
558: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
559: hr_utility.set_message_token('TABLE_NAME', l_table_name);
560: hr_utility.raise_error;
561: When Others Then
562: --
563: -- An unhandled or unexpected error has occurred which

Line 560: hr_utility.raise_error;

556: -- we must error
557: --
558: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
559: hr_utility.set_message_token('TABLE_NAME', l_table_name);
560: hr_utility.raise_error;
561: When Others Then
562: --
563: -- An unhandled or unexpected error has occurred which
564: -- we must report

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

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

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

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

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

564: -- we must report
565: --
566: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
567: hr_utility.set_message_token('PROCEDURE', l_proc);
568: hr_utility.set_message_token('STEP','15');
569: hr_utility.raise_error;
570: End dt_delete_validate;
571: --
572: -- ----------------------------------------------------------------------------

Line 569: hr_utility.raise_error;

565: --
566: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
567: hr_utility.set_message_token('PROCEDURE', l_proc);
568: hr_utility.set_message_token('STEP','15');
569: hr_utility.raise_error;
570: End dt_delete_validate;
571: --
572: -- ----------------------------------------------------------------------------
573: -- |---------------------------< insert_validate >----------------------------|

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

581: --
582: l_proc varchar2(72) := g_package||'insert_validate';
583: --
584: Begin
585: hr_utility.set_location('Entering:'||l_proc, 5);
586: --
587: -- Call all supporting business operations
588: --
589: --

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

622: ,p_effective_date => p_effective_date
623: ,p_business_group_id => p_rec.business_group_id
624: ,p_fl_tm_pt_tm_rt_id => p_rec.fl_tm_pt_tm_rt_id);
625: --
626: hr_utility.set_location(' Leaving:'||l_proc, 10);
627: End insert_validate;
628: --
629: -- ----------------------------------------------------------------------------
630: -- |---------------------------< update_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 691: hr_utility.set_location(' Leaving:'||l_proc, 10);

687: ,p_effective_date => p_effective_date
688: ,p_business_group_id => p_rec.business_group_id
689: ,p_fl_tm_pt_tm_rt_id => p_rec.fl_tm_pt_tm_rt_id);
690: --
691: hr_utility.set_location(' Leaving:'||l_proc, 10);
692: End update_validate;
693: --
694: -- ----------------------------------------------------------------------------
695: -- |---------------------------< delete_validate >----------------------------|

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

703: --
704: l_proc varchar2(72) := g_package||'delete_validate';
705: --
706: Begin
707: hr_utility.set_location('Entering:'||l_proc, 5);
708: --
709: -- Call all supporting business operations
710: --
711: dt_delete_validate

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

713: p_validation_start_date => p_validation_start_date,
714: p_validation_end_date => p_validation_end_date,
715: p_fl_tm_pt_tm_rt_id => p_rec.fl_tm_pt_tm_rt_id);
716: --
717: hr_utility.set_location(' Leaving:'||l_proc, 10);
718: End delete_validate;
719: --
720: --
721: -- ---------------------------------------------------------------------------

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

740: l_proc varchar2(72) := g_package||'return_legislation_code';
741: --
742: begin
743: --
744: hr_utility.set_location('Entering:'|| l_proc, 10);
745: --
746: -- Ensure that all the mandatory parameter are not null
747: --
748: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

758: close csr_leg_code;
759: --
760: -- The primary key is invalid therefore we must error
761: --
762: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
763: hr_utility.raise_error;
764: --
765: end if;
766: --

Line 763: hr_utility.raise_error;

759: --
760: -- The primary key is invalid therefore we must error
761: --
762: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
763: hr_utility.raise_error;
764: --
765: end if;
766: --
767: close csr_leg_code;

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

765: end if;
766: --
767: close csr_leg_code;
768: --
769: hr_utility.set_location(' Leaving:'|| l_proc, 20);
770: --
771: return l_legislation_code;
772: --
773: end return_legislation_code;