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_WCN_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_wcn_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_wv_prtn_rsn_ctfn_pl_id => p_wv_prtn_rsn_ctfn_pl_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_wv_prtn_rsn_ctfn_pl_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_wcn_shd.api_updating
118: (p_wv_prtn_rsn_ctfn_pl_id => p_wv_prtn_rsn_ctfn_pl_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_wv_prtn_ctfn_typ_cd;
147: --
148: -- ----------------------------------------------------------------------------

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

197: and ff.effective_end_date;
198: --
199: Begin
200: --
201: hr_utility.set_location('Entering:'||l_proc, 5);
202: --
203: l_api_updating := ben_wcn_shd.api_updating
204: (p_wv_prtn_rsn_ctfn_pl_id => p_wv_prtn_rsn_ctfn_pl_id,
205: p_effective_date => p_effective_date,

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

235: close c1;
236: --
237: end if;
238: --
239: hr_utility.set_location('Leaving:'||l_proc,10);
240: --
241: end chk_ctfn_rqd_when_rl;
242: --
243: -- ----------------------------------------------------------------------------

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

275: l_api_updating boolean;
276: --
277: Begin
278: --
279: hr_utility.set_location('Entering:'||l_proc, 5);
280: --
281: l_api_updating := ben_wcn_shd.api_updating
282: (p_wv_prtn_rsn_ctfn_pl_id => p_wv_prtn_rsn_ctfn_pl_id,
283: p_effective_date => p_effective_date,

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

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

Line 302: hr_utility.raise_error;

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

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

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

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

344: l_api_updating boolean;
345: --
346: Begin
347: --
348: hr_utility.set_location('Entering:'||l_proc, 5);
349: --
350: l_api_updating := ben_wcn_shd.api_updating
351: (p_wv_prtn_rsn_ctfn_pl_id => p_wv_prtn_rsn_ctfn_pl_id,
352: p_effective_date => p_effective_date,

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

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

Line 371: hr_utility.raise_error;

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

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

373: end if;
374: --
375: end if;
376: --
377: hr_utility.set_location('Leaving:'||l_proc,10);
378: --
379: end chk_lack_ctfn_sspnd_wvr_flag;
380: --
381: -- ----------------------------------------------------------------------------

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

413: l_api_updating boolean;
414: --
415: Begin
416: --
417: hr_utility.set_location('Entering:'||l_proc, 5);
418: --
419: l_api_updating := ben_wcn_shd.api_updating
420: (p_wv_prtn_rsn_ctfn_pl_id => p_wv_prtn_rsn_ctfn_pl_id,
421: p_effective_date => p_effective_date,

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

435: p_effective_date => p_effective_date) then
436: --
437: -- raise error as does not exist as lookup
438: --
439: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
440: hr_utility.raise_error;
441: --
442: end if;
443: --

Line 440: hr_utility.raise_error;

436: --
437: -- raise error as does not exist as lookup
438: --
439: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
440: hr_utility.raise_error;
441: --
442: end if;
443: --
444: end if;

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

442: end if;
443: --
444: end if;
445: --
446: hr_utility.set_location('Leaving:'||l_proc,10);
447: --
448: end chk_pfd_flag;
449: --
450: -- ----------------------------------------------------------------------------

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

486: l_integrity_error Exception;
487: l_table_name all_tables.table_name%TYPE;
488: --
489: Begin
490: hr_utility.set_location('Entering:'||l_proc, 5);
491: --
492: -- Ensure that the p_datetrack_mode argument is not null
493: --
494: hr_api.mandatory_arg_error

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

525: End If;
526: --
527: End If;
528: --
529: hr_utility.set_location(' Leaving:'||l_proc, 10);
530: Exception
531: When l_integrity_error Then
532: --
533: -- A referential integrity check was violated therefore

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

532: --
533: -- A referential integrity check was violated therefore
534: -- we must error
535: --
536: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
537: hr_utility.set_message_token('TABLE_NAME', l_table_name);
538: hr_utility.raise_error;
539: When Others Then
540: --

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

533: -- A referential integrity check was violated therefore
534: -- we must error
535: --
536: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
537: hr_utility.set_message_token('TABLE_NAME', l_table_name);
538: hr_utility.raise_error;
539: When Others Then
540: --
541: -- An unhandled or unexpected error has occurred which

Line 538: hr_utility.raise_error;

534: -- we must error
535: --
536: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
537: hr_utility.set_message_token('TABLE_NAME', l_table_name);
538: hr_utility.raise_error;
539: When Others Then
540: --
541: -- An unhandled or unexpected error has occurred which
542: -- we must report

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

540: --
541: -- An unhandled or unexpected error has occurred which
542: -- we must report
543: --
544: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
545: hr_utility.set_message_token('PROCEDURE', l_proc);
546: hr_utility.set_message_token('STEP','15');
547: hr_utility.raise_error;
548: End dt_update_validate;

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

541: -- An unhandled or unexpected error has occurred which
542: -- we must report
543: --
544: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
545: hr_utility.set_message_token('PROCEDURE', l_proc);
546: hr_utility.set_message_token('STEP','15');
547: hr_utility.raise_error;
548: End dt_update_validate;
549: --

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

542: -- we must report
543: --
544: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
545: hr_utility.set_message_token('PROCEDURE', l_proc);
546: hr_utility.set_message_token('STEP','15');
547: hr_utility.raise_error;
548: End dt_update_validate;
549: --
550: -- ----------------------------------------------------------------------------

Line 547: hr_utility.raise_error;

543: --
544: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
545: hr_utility.set_message_token('PROCEDURE', l_proc);
546: hr_utility.set_message_token('STEP','15');
547: hr_utility.raise_error;
548: End dt_update_validate;
549: --
550: -- ----------------------------------------------------------------------------
551: -- |--------------------------< dt_delete_validate >--------------------------|

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

592: l_rows_exist Exception;
593: l_table_name all_tables.table_name%TYPE;
594: --
595: Begin
596: hr_utility.set_location('Entering:'||l_proc, 5);
597: --
598: -- Ensure that the p_datetrack_mode argument is not null
599: --
600: hr_api.mandatory_arg_error

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

629: --
630: --
631: End If;
632: --
633: hr_utility.set_location(' Leaving:'||l_proc, 10);
634: Exception
635: When l_rows_exist Then
636: --
637: -- A referential integrity check was violated therefore

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

636: --
637: -- A referential integrity check was violated therefore
638: -- we must error
639: --
640: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
641: hr_utility.set_message_token('TABLE_NAME', l_table_name);
642: hr_utility.raise_error;
643: When Others Then
644: --

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

637: -- A referential integrity check was violated therefore
638: -- we must error
639: --
640: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
641: hr_utility.set_message_token('TABLE_NAME', l_table_name);
642: hr_utility.raise_error;
643: When Others Then
644: --
645: -- An unhandled or unexpected error has occurred which

Line 642: hr_utility.raise_error;

638: -- we must error
639: --
640: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
641: hr_utility.set_message_token('TABLE_NAME', l_table_name);
642: hr_utility.raise_error;
643: When Others Then
644: --
645: -- An unhandled or unexpected error has occurred which
646: -- we must report

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

644: --
645: -- An unhandled or unexpected error has occurred which
646: -- we must report
647: --
648: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
649: hr_utility.set_message_token('PROCEDURE', l_proc);
650: hr_utility.set_message_token('STEP','15');
651: hr_utility.raise_error;
652: End dt_delete_validate;

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

645: -- An unhandled or unexpected error has occurred which
646: -- we must report
647: --
648: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
649: hr_utility.set_message_token('PROCEDURE', l_proc);
650: hr_utility.set_message_token('STEP','15');
651: hr_utility.raise_error;
652: End dt_delete_validate;
653: --

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

646: -- we must report
647: --
648: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
649: hr_utility.set_message_token('PROCEDURE', l_proc);
650: hr_utility.set_message_token('STEP','15');
651: hr_utility.raise_error;
652: End dt_delete_validate;
653: --
654: -- ----------------------------------------------------------------------------

Line 651: hr_utility.raise_error;

647: --
648: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
649: hr_utility.set_message_token('PROCEDURE', l_proc);
650: hr_utility.set_message_token('STEP','15');
651: hr_utility.raise_error;
652: End dt_delete_validate;
653: --
654: -- ----------------------------------------------------------------------------
655: -- |---------------------------< insert_validate >----------------------------|

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

663: --
664: l_proc varchar2(72) := g_package||'insert_validate';
665: --
666: Begin
667: hr_utility.set_location('Entering:'||l_proc, 5);
668: --
669: -- Call all supporting business operations
670: --
671: --

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

706: p_pfd_flag => p_rec.pfd_flag,
707: p_effective_date => p_effective_date,
708: p_object_version_number => p_rec.object_version_number);
709: --
710: hr_utility.set_location(' Leaving:'||l_proc, 10);
711: End insert_validate;
712: --
713: -- ----------------------------------------------------------------------------
714: -- |---------------------------< update_validate >----------------------------|

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

722: --
723: l_proc varchar2(72) := g_package||'update_validate';
724: --
725: Begin
726: hr_utility.set_location('Entering:'||l_proc, 5);
727: --
728: -- Call all supporting business operations
729: --
730: --

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

773: p_datetrack_mode => p_datetrack_mode,
774: p_validation_start_date => p_validation_start_date,
775: p_validation_end_date => p_validation_end_date);
776: --
777: hr_utility.set_location(' Leaving:'||l_proc, 10);
778: End update_validate;
779: --
780: -- ----------------------------------------------------------------------------
781: -- |---------------------------< delete_validate >----------------------------|

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

789: --
790: l_proc varchar2(72) := g_package||'delete_validate';
791: --
792: Begin
793: hr_utility.set_location('Entering:'||l_proc, 5);
794: --
795: -- Call all supporting business operations
796: --
797: dt_delete_validate

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

799: p_validation_start_date => p_validation_start_date,
800: p_validation_end_date => p_validation_end_date,
801: p_wv_prtn_rsn_ctfn_pl_id => p_rec.wv_prtn_rsn_ctfn_pl_id);
802: --
803: hr_utility.set_location(' Leaving:'||l_proc, 10);
804: End delete_validate;
805: --
806: --
807: -- ---------------------------------------------------------------------------

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

826: l_proc varchar2(72) := g_package||'return_legislation_code';
827: --
828: begin
829: --
830: hr_utility.set_location('Entering:'|| l_proc, 10);
831: --
832: -- Ensure that all the mandatory parameter are not null
833: --
834: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

844: close csr_leg_code;
845: --
846: -- The primary key is invalid therefore we must error
847: --
848: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
849: hr_utility.raise_error;
850: --
851: end if;
852: --

Line 849: hr_utility.raise_error;

845: --
846: -- The primary key is invalid therefore we must error
847: --
848: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
849: hr_utility.raise_error;
850: --
851: end if;
852: --
853: close csr_leg_code;

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

851: end if;
852: --
853: close csr_leg_code;
854: --
855: hr_utility.set_location(' Leaving:'|| l_proc, 20);
856: --
857: return l_legislation_code;
858: --
859: end return_legislation_code;