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_PCT_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_pct_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_pl_gd_r_svc_ctfn_id => p_pl_gd_r_svc_ctfn_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_pl_gd_r_svc_ctfn_id;
78: --
79: -- ----------------------------------------------------------------------------

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

128: and ff.effective_end_date;
129: --
130: Begin
131: --
132: hr_utility.set_location('Entering:'||l_proc, 5);
133: --
134: l_api_updating := ben_pct_shd.api_updating
135: (p_pl_gd_r_svc_ctfn_id => p_pl_gd_r_svc_ctfn_id,
136: p_effective_date => p_effective_date,

Line 159: hr_utility.set_message(801,'FORMULA_DOES_NOT_EXIST');

155: close c1;
156: --
157: -- raise error
158: --
159: hr_utility.set_message(801,'FORMULA_DOES_NOT_EXIST');
160: hr_utility.raise_error;
161: --
162: end if;
163: --

Line 160: hr_utility.raise_error;

156: --
157: -- raise error
158: --
159: hr_utility.set_message(801,'FORMULA_DOES_NOT_EXIST');
160: hr_utility.raise_error;
161: --
162: end if;
163: --
164: close c1;

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

164: close c1;
165: --
166: end if;
167: --
168: hr_utility.set_location('Leaving:'||l_proc,10);
169: --
170: end chk_ctfn_rqd_when_rl;
171: --
172: -- ----------------------------------------------------------------------------

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

204: l_api_updating boolean;
205: --
206: Begin
207: --
208: hr_utility.set_location('Entering:'||l_proc, 5);
209: --
210: l_api_updating := ben_pct_shd.api_updating
211: (p_pl_gd_r_svc_ctfn_id => p_pl_gd_r_svc_ctfn_id,
212: p_effective_date => p_effective_date,

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

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

Line 231: hr_utility.raise_error;

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

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

233: end if;
234: --
235: end if;
236: --
237: hr_utility.set_location('Leaving:'||l_proc,10);
238: --
239: end chk_rmbmt_ctfn_typ_cd;
240: --
241: -- ----------------------------------------------------------------------------

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

273: l_api_updating boolean;
274: --
275: Begin
276: --
277: hr_utility.set_location('Entering:'||l_proc, 5);
278: --
279: l_api_updating := ben_pct_shd.api_updating
280: (p_pl_gd_r_svc_ctfn_id => p_pl_gd_r_svc_ctfn_id,
281: p_effective_date => p_effective_date,

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

295: p_effective_date => p_effective_date) then
296: --
297: -- raise error as does not exist as lookup
298: --
299: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
300: hr_utility.raise_error;
301: --
302: end if;
303: --

Line 300: hr_utility.raise_error;

296: --
297: -- raise error as does not exist as lookup
298: --
299: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
300: hr_utility.raise_error;
301: --
302: end if;
303: --
304: end if;

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

302: end if;
303: --
304: end if;
305: --
306: hr_utility.set_location('Leaving:'||l_proc,10);
307: --
308: end chk_rqd_flag;
309: --
310: -- ----------------------------------------------------------------------------

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

342: l_api_updating boolean;
343: --
344: Begin
345: --
346: hr_utility.set_location('Entering:'||l_proc, 5);
347: --
348: l_api_updating := ben_pct_shd.api_updating
349: (p_pl_gd_r_svc_ctfn_id => p_pl_gd_r_svc_ctfn_id,
350: p_effective_date => p_effective_date,

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

364: p_effective_date => p_effective_date) then
365: --
366: -- raise error as does not exist as lookup
367: --
368: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
369: hr_utility.raise_error;
370: --
371: end if;
372: --

Line 369: hr_utility.raise_error;

365: --
366: -- raise error as does not exist as lookup
367: --
368: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
369: hr_utility.raise_error;
370: --
371: end if;
372: --
373: end if;

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

371: end if;
372: --
373: end if;
374: --
375: hr_utility.set_location('Leaving:'||l_proc,10);
376: --
377: end chk_pfd_flag;
378: --
379: -- ----------------------------------------------------------------------------

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

416: l_integrity_error Exception;
417: l_table_name all_tables.table_name%TYPE;
418: --
419: Begin
420: hr_utility.set_location('Entering:'||l_proc, 5);
421: --
422: -- Ensure that the p_datetrack_mode argument is not null
423: --
424: hr_api.mandatory_arg_error

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

475: End If;*/
476: --
477: End If;
478: --
479: hr_utility.set_location(' Leaving:'||l_proc, 10);
480: Exception
481: When l_integrity_error Then
482: --
483: -- A referential integrity check was violated therefore

Line 486: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');

482: --
483: -- A referential integrity check was violated therefore
484: -- we must error
485: --
486: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
487: hr_utility.set_message_token('TABLE_NAME', l_table_name);
488: hr_utility.raise_error;
489: When Others Then
490: --

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

483: -- A referential integrity check was violated therefore
484: -- we must error
485: --
486: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
487: hr_utility.set_message_token('TABLE_NAME', l_table_name);
488: hr_utility.raise_error;
489: When Others Then
490: --
491: -- An unhandled or unexpected error has occurred which

Line 488: hr_utility.raise_error;

484: -- we must error
485: --
486: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
487: hr_utility.set_message_token('TABLE_NAME', l_table_name);
488: hr_utility.raise_error;
489: When Others Then
490: --
491: -- An unhandled or unexpected error has occurred which
492: -- we must report

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

490: --
491: -- An unhandled or unexpected error has occurred which
492: -- we must report
493: --
494: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
495: hr_utility.set_message_token('PROCEDURE', l_proc);
496: hr_utility.set_message_token('STEP','15');
497: hr_utility.raise_error;
498: End dt_update_validate;

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

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

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

492: -- we must report
493: --
494: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
495: hr_utility.set_message_token('PROCEDURE', l_proc);
496: hr_utility.set_message_token('STEP','15');
497: hr_utility.raise_error;
498: End dt_update_validate;
499: --
500: -- ----------------------------------------------------------------------------

Line 497: hr_utility.raise_error;

493: --
494: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
495: hr_utility.set_message_token('PROCEDURE', l_proc);
496: hr_utility.set_message_token('STEP','15');
497: hr_utility.raise_error;
498: End dt_update_validate;
499: --
500: -- ----------------------------------------------------------------------------
501: -- |--------------------------< dt_delete_validate >--------------------------|

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

542: l_rows_exist Exception;
543: l_table_name all_tables.table_name%TYPE;
544: --
545: Begin
546: hr_utility.set_location('Entering:'||l_proc, 5);
547: --
548: -- Ensure that the p_datetrack_mode argument is not null
549: --
550: hr_api.mandatory_arg_error

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

579: --
580: --
581: End If;
582: --
583: hr_utility.set_location(' Leaving:'||l_proc, 10);
584: Exception
585: When l_rows_exist Then
586: --
587: -- A referential integrity check was violated therefore

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

586: --
587: -- A referential integrity check was violated therefore
588: -- we must error
589: --
590: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
591: hr_utility.set_message_token('TABLE_NAME', l_table_name);
592: hr_utility.raise_error;
593: When Others Then
594: --

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

587: -- A referential integrity check was violated therefore
588: -- we must error
589: --
590: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
591: hr_utility.set_message_token('TABLE_NAME', l_table_name);
592: hr_utility.raise_error;
593: When Others Then
594: --
595: -- An unhandled or unexpected error has occurred which

Line 592: hr_utility.raise_error;

588: -- we must error
589: --
590: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
591: hr_utility.set_message_token('TABLE_NAME', l_table_name);
592: hr_utility.raise_error;
593: When Others Then
594: --
595: -- An unhandled or unexpected error has occurred which
596: -- we must report

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

594: --
595: -- An unhandled or unexpected error has occurred which
596: -- we must report
597: --
598: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
599: hr_utility.set_message_token('PROCEDURE', l_proc);
600: hr_utility.set_message_token('STEP','15');
601: hr_utility.raise_error;
602: End dt_delete_validate;

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

595: -- An unhandled or unexpected error has occurred which
596: -- we must report
597: --
598: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
599: hr_utility.set_message_token('PROCEDURE', l_proc);
600: hr_utility.set_message_token('STEP','15');
601: hr_utility.raise_error;
602: End dt_delete_validate;
603: --

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

596: -- we must report
597: --
598: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
599: hr_utility.set_message_token('PROCEDURE', l_proc);
600: hr_utility.set_message_token('STEP','15');
601: hr_utility.raise_error;
602: End dt_delete_validate;
603: --
604: -- ----------------------------------------------------------------------------

Line 601: hr_utility.raise_error;

597: --
598: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
599: hr_utility.set_message_token('PROCEDURE', l_proc);
600: hr_utility.set_message_token('STEP','15');
601: hr_utility.raise_error;
602: End dt_delete_validate;
603: --
604: -- ----------------------------------------------------------------------------
605: -- |---------------------------< insert_validate >----------------------------|

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

613: --
614: l_proc varchar2(72) := g_package||'insert_validate';
615: --
616: Begin
617: hr_utility.set_location('Entering:'||l_proc, 5);
618: --
619: -- Call all supporting business operations
620: --
621: --

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

650: p_pfd_flag => p_rec.pfd_flag,
651: p_effective_date => p_effective_date,
652: p_object_version_number => p_rec.object_version_number);
653: --
654: hr_utility.set_location(' Leaving:'||l_proc, 10);
655: End insert_validate;
656: --
657: -- ----------------------------------------------------------------------------
658: -- |---------------------------< update_validate >----------------------------|

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

666: --
667: l_proc varchar2(72) := g_package||'update_validate';
668: --
669: Begin
670: hr_utility.set_location('Entering:'||l_proc, 5);
671: --
672: -- Call all supporting business operations
673: --
674: --

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

712: p_datetrack_mode => p_datetrack_mode,
713: p_validation_start_date => p_validation_start_date,
714: p_validation_end_date => p_validation_end_date);
715: --
716: hr_utility.set_location(' Leaving:'||l_proc, 10);
717: End update_validate;
718: --
719: -- ----------------------------------------------------------------------------
720: -- |---------------------------< delete_validate >----------------------------|

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

728: --
729: l_proc varchar2(72) := g_package||'delete_validate';
730: --
731: Begin
732: hr_utility.set_location('Entering:'||l_proc, 5);
733: --
734: -- Call all supporting business operations
735: --
736: dt_delete_validate

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

738: p_validation_start_date => p_validation_start_date,
739: p_validation_end_date => p_validation_end_date,
740: p_pl_gd_r_svc_ctfn_id => p_rec.pl_gd_r_svc_ctfn_id);
741: --
742: hr_utility.set_location(' Leaving:'||l_proc, 10);
743: End delete_validate;
744: --
745: -- ---------------------------------------------------------------------------
746: -- |---------------------< return_legislation_code >-------------------------|

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

764: l_proc varchar2(72) := g_package||'return_legislation_code';
765: --
766: begin
767: --
768: hr_utility.set_location('Entering:'|| l_proc, 10);
769: --
770: -- Ensure that all the mandatory parameter are not null
771: --
772: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

782: close csr_leg_code;
783: --
784: -- The primary key is invalid therefore we must error
785: --
786: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
787: hr_utility.raise_error;
788: --
789: end if;
790: --

Line 787: hr_utility.raise_error;

783: --
784: -- The primary key is invalid therefore we must error
785: --
786: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
787: hr_utility.raise_error;
788: --
789: end if;
790: --
791: close csr_leg_code;

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

789: end if;
790: --
791: close csr_leg_code;
792: --
793: hr_utility.set_location(' Leaving:'|| l_proc, 20);
794: --
795: return l_legislation_code;
796: --
797: end return_legislation_code;