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_WCT_BUS dependencies on HR_UTILITY

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

43: l_api_updating boolean;
44: --
45: Begin
46: --
47: hr_utility.set_location('Entering:'||l_proc, 5);
48: --
49: l_api_updating := ben_wct_shd.api_updating
50: (p_effective_date => p_effective_date,
51: p_wv_prtn_rsn_ctfn_ptip_id => p_wv_prtn_rsn_ctfn_ptip_id,

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

72: end if;
73: --
74: end if;
75: --
76: hr_utility.set_location('Leaving:'||l_proc, 10);
77: --
78: End chk_wv_prtn_rsn_ctfn_ptip_id;
79: --
80: -- ----------------------------------------------------------------------------

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_wct_shd.api_updating
120: (p_wv_prtn_rsn_ctfn_ptip_id => p_wv_prtn_rsn_ctfn_ptip_id,
121: p_effective_date => p_effective_date,

Line 140: hr_utility.set_message(801,'WV_PRTN_CTFN_TYP_not_exist');

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

Line 141: hr_utility.raise_error;

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

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

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

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

183: l_api_updating boolean;
184: --
185: Begin
186: --
187: hr_utility.set_location('Entering:'||l_proc, 5);
188: --
189: l_api_updating := ben_wct_shd.api_updating
190: (p_wv_prtn_rsn_ctfn_ptip_id => p_wv_prtn_rsn_ctfn_ptip_id,
191: p_effective_date => p_effective_date,

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

205: p_effective_date => p_effective_date) then
206: --
207: -- raise error as does not exist as lookup
208: --
209: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
210: hr_utility.raise_error;
211: --
212: end if;
213: --

Line 210: hr_utility.raise_error;

206: --
207: -- raise error as does not exist as lookup
208: --
209: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
210: hr_utility.raise_error;
211: --
212: end if;
213: --
214: end if;

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

212: end if;
213: --
214: end if;
215: --
216: hr_utility.set_location('Leaving:'||l_proc,10);
217: --
218: end chk_pfd_flag;
219: --
220: -- ----------------------------------------------------------------------------

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

269: and ff.effective_end_date;
270: --
271: Begin
272: --
273: hr_utility.set_location('Entering:'||l_proc, 5);
274: --
275: l_api_updating := ben_wct_shd.api_updating
276: (p_wv_prtn_rsn_ctfn_ptip_id => p_wv_prtn_rsn_ctfn_ptip_id,
277: p_effective_date => p_effective_date,

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

307: close c1;
308: --
309: end if;
310: --
311: hr_utility.set_location('Leaving:'||l_proc,10);
312: --
313: end chk_ctfn_rqd_when_rl;
314: --
315: -- ----------------------------------------------------------------------------

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

348: l_api_updating boolean;
349: --
350: Begin
351: --
352: hr_utility.set_location('Entering:'||l_proc, 5);
353: --
354: l_api_updating := ben_wct_shd.api_updating
355: (p_wv_prtn_rsn_ctfn_ptip_id => p_wv_prtn_rsn_ctfn_ptip_id,
356: p_effective_date => p_effective_date,

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

370: p_effective_date => p_effective_date) then
371: --
372: -- raise error as does not exist as lookup
373: --
374: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
375: hr_utility.raise_error;
376: --
377: end if;
378: --

Line 375: hr_utility.raise_error;

371: --
372: -- raise error as does not exist as lookup
373: --
374: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
375: hr_utility.raise_error;
376: --
377: end if;
378: --
379: end if;

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

377: end if;
378: --
379: end if;
380: --
381: hr_utility.set_location('Leaving:'||l_proc,10);
382: --
383: end chk_lack_ctfn_sspnd_wvr_flag;
384: --
385: -- ----------------------------------------------------------------------------

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

418: l_api_updating boolean;
419: --
420: Begin
421: --
422: hr_utility.set_location('Entering:'||l_proc, 5);
423: --
424: l_api_updating := ben_wct_shd.api_updating
425: (p_wv_prtn_rsn_ctfn_ptip_id => p_wv_prtn_rsn_ctfn_ptip_id,
426: p_effective_date => p_effective_date,

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

440: p_effective_date => p_effective_date) then
441: --
442: -- raise error as does not exist as lookup
443: --
444: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
445: hr_utility.raise_error;
446: --
447: end if;
448: --

Line 445: hr_utility.raise_error;

441: --
442: -- raise error as does not exist as lookup
443: --
444: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
445: hr_utility.raise_error;
446: --
447: end if;
448: --
449: end if;

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

447: end if;
448: --
449: end if;
450: --
451: hr_utility.set_location('Leaving:'||l_proc,10);
452: --
453: end chk_wv_prtn_ctfn_cd;
454: --
455: -- ----------------------------------------------------------------------------

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

492: l_integrity_error Exception;
493: l_table_name all_tables.table_name%TYPE;
494: --
495: Begin
496: hr_utility.set_location('Entering:'||l_proc, 5);
497: --
498: -- Ensure that the p_datetrack_mode argument is not null
499: --
500: hr_api.mandatory_arg_error

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

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

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

548: --
549: -- A referential integrity check was violated therefore
550: -- we must error
551: --
552: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
553: hr_utility.set_message_token('TABLE_NAME', l_table_name);
554: hr_utility.raise_error;
555: When Others Then
556: --

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

549: -- A referential integrity check was violated therefore
550: -- we must error
551: --
552: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
553: hr_utility.set_message_token('TABLE_NAME', l_table_name);
554: hr_utility.raise_error;
555: When Others Then
556: --
557: -- An unhandled or unexpected error has occurred which

Line 554: hr_utility.raise_error;

550: -- we must error
551: --
552: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
553: hr_utility.set_message_token('TABLE_NAME', l_table_name);
554: hr_utility.raise_error;
555: When Others Then
556: --
557: -- An unhandled or unexpected error has occurred which
558: -- we must report

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

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

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

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

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

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

Line 563: hr_utility.raise_error;

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

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

608: l_rows_exist Exception;
609: l_table_name all_tables.table_name%TYPE;
610: --
611: Begin
612: hr_utility.set_location('Entering:'||l_proc, 5);
613: --
614: -- Ensure that the p_datetrack_mode argument is not null
615: --
616: hr_api.mandatory_arg_error

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

645: --
646: --
647: End If;
648: --
649: hr_utility.set_location(' Leaving:'||l_proc, 10);
650: Exception
651: When l_rows_exist Then
652: --
653: -- A referential integrity check was violated therefore

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

652: --
653: -- A referential integrity check was violated therefore
654: -- we must error
655: --
656: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
657: hr_utility.set_message_token('TABLE_NAME', l_table_name);
658: hr_utility.raise_error;
659: When Others Then
660: --

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

653: -- A referential integrity check was violated therefore
654: -- we must error
655: --
656: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
657: hr_utility.set_message_token('TABLE_NAME', l_table_name);
658: hr_utility.raise_error;
659: When Others Then
660: --
661: -- An unhandled or unexpected error has occurred which

Line 658: hr_utility.raise_error;

654: -- we must error
655: --
656: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
657: hr_utility.set_message_token('TABLE_NAME', l_table_name);
658: hr_utility.raise_error;
659: When Others Then
660: --
661: -- An unhandled or unexpected error has occurred which
662: -- we must report

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

660: --
661: -- An unhandled or unexpected error has occurred which
662: -- we must report
663: --
664: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
665: hr_utility.set_message_token('PROCEDURE', l_proc);
666: hr_utility.set_message_token('STEP','15');
667: hr_utility.raise_error;
668: End dt_delete_validate;

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

661: -- An unhandled or unexpected error has occurred which
662: -- we must report
663: --
664: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
665: hr_utility.set_message_token('PROCEDURE', l_proc);
666: hr_utility.set_message_token('STEP','15');
667: hr_utility.raise_error;
668: End dt_delete_validate;
669: --

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

662: -- we must report
663: --
664: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
665: hr_utility.set_message_token('PROCEDURE', l_proc);
666: hr_utility.set_message_token('STEP','15');
667: hr_utility.raise_error;
668: End dt_delete_validate;
669: --
670: -- ----------------------------------------------------------------------------

Line 667: hr_utility.raise_error;

663: --
664: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
665: hr_utility.set_message_token('PROCEDURE', l_proc);
666: hr_utility.set_message_token('STEP','15');
667: hr_utility.raise_error;
668: End dt_delete_validate;
669: --
670: -- ----------------------------------------------------------------------------
671: -- |---------------------------< insert_validate >----------------------------|

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

679: --
680: l_proc varchar2(72) := g_package||'insert_validate';
681: --
682: Begin
683: hr_utility.set_location('Entering:'||l_proc, 5);
684: --
685: -- Call all supporting business operations
686: --
687: --

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

722: p_wv_prtn_ctfn_cd => p_rec.wv_prtn_ctfn_cd,
723: p_effective_date => p_effective_date,
724: p_object_version_number => p_rec.object_version_number);
725: --
726: hr_utility.set_location(' Leaving:'||l_proc, 10);
727: End insert_validate;
728: --
729: -- ----------------------------------------------------------------------------
730: -- |---------------------------< update_validate >----------------------------|

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

738: --
739: l_proc varchar2(72) := g_package||'update_validate';
740: --
741: Begin
742: hr_utility.set_location('Entering:'||l_proc, 5);
743: --
744: -- Call all supporting business operations
745: --
746: --

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

790: p_datetrack_mode => p_datetrack_mode,
791: p_validation_start_date => p_validation_start_date,
792: p_validation_end_date => p_validation_end_date);
793: --
794: hr_utility.set_location(' Leaving:'||l_proc, 10);
795: End update_validate;
796: --
797: -- ----------------------------------------------------------------------------
798: -- |---------------------------< delete_validate >----------------------------|

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

806: --
807: l_proc varchar2(72) := g_package||'delete_validate';
808: --
809: Begin
810: hr_utility.set_location('Entering:'||l_proc, 5);
811: --
812: -- Call all supporting business operations
813: --
814: dt_delete_validate

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

816: p_validation_start_date => p_validation_start_date,
817: p_validation_end_date => p_validation_end_date,
818: p_wv_prtn_rsn_ctfn_ptip_id => p_rec.wv_prtn_rsn_ctfn_ptip_id);
819: --
820: hr_utility.set_location(' Leaving:'||l_proc, 10);
821: End delete_validate;
822: --
823: --
824: -- ---------------------------------------------------------------------------

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

843: l_proc varchar2(72) := g_package||'return_legislation_code';
844: --
845: begin
846: --
847: hr_utility.set_location('Entering:'|| l_proc, 10);
848: --
849: -- Ensure that all the mandatory parameter are not null
850: --
851: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

861: close csr_leg_code;
862: --
863: -- The primary key is invalid therefore we must error
864: --
865: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
866: hr_utility.raise_error;
867: --
868: end if;
869: --

Line 866: hr_utility.raise_error;

862: --
863: -- The primary key is invalid therefore we must error
864: --
865: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
866: hr_utility.raise_error;
867: --
868: end if;
869: --
870: close csr_leg_code;

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

868: end if;
869: --
870: close csr_leg_code;
871: --
872: hr_utility.set_location(' Leaving:'|| l_proc, 20);
873: --
874: return l_legislation_code;
875: --
876: end return_legislation_code;