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_PND_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_pnd_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_pl_dpnt_cvg_ctfn_id => p_pl_dpnt_cvg_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_dpnt_cvg_ctfn_id;
78: --
79: -- ----------------------------------------------------------------------------

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

128: or (p_validation_end_date between
129: effective_start_date and effective_end_date)) ;
130: --
131: Begin
132: hr_utility.set_location('Entering:'||l_proc, 5);
133: --
134: open c1;
135: fetch c1 into l_dummy;
136: if c1%found then

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

138: fnd_message.set_name('BEN','BEN_92122_CTFN_TYP_UNIQUE');
139: fnd_message.raise_error;
140: end if;
141: --
142: hr_utility.set_location('Leaving:'||l_proc, 15);
143: End chk_dpnt_cvg_ctfn_typ_unique;
144: --
145: -- ----------------------------------------------------------------------------
146: -- |------< chk_rlshp_typ_cd >------|

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

177: l_api_updating boolean;
178: --
179: Begin
180: --
181: hr_utility.set_location('Entering:'||l_proc, 5);
182: --
183: l_api_updating := ben_pnd_shd.api_updating
184: (p_pl_dpnt_cvg_ctfn_id => p_pl_dpnt_cvg_ctfn_id,
185: p_effective_date => p_effective_date,

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

199: p_effective_date => p_effective_date) then
200: --
201: -- raise error as does not exist as lookup
202: --
203: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
204: hr_utility.raise_error;
205: --
206: end if;
207: --

Line 204: hr_utility.raise_error;

200: --
201: -- raise error as does not exist as lookup
202: --
203: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
204: hr_utility.raise_error;
205: --
206: end if;
207: --
208: end if;

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

206: end if;
207: --
208: end if;
209: --
210: hr_utility.set_location('Leaving:'||l_proc,10);
211: --
212: end chk_rlshp_typ_cd;
213: --
214: -- ----------------------------------------------------------------------------

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

246: l_api_updating boolean;
247: --
248: Begin
249: --
250: hr_utility.set_location('Entering:'||l_proc, 5);
251: --
252: l_api_updating := ben_pnd_shd.api_updating
253: (p_pl_dpnt_cvg_ctfn_id => p_pl_dpnt_cvg_ctfn_id,
254: p_effective_date => p_effective_date,

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

268: p_effective_date => p_effective_date) then
269: --
270: -- raise error as does not exist as lookup
271: --
272: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
273: hr_utility.raise_error;
274: --
275: end if;
276: --

Line 273: hr_utility.raise_error;

269: --
270: -- raise error as does not exist as lookup
271: --
272: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
273: hr_utility.raise_error;
274: --
275: end if;
276: --
277: end if;

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

275: end if;
276: --
277: end if;
278: --
279: hr_utility.set_location('Leaving:'||l_proc,10);
280: --
281: end chk_rqd_flag;
282: --
283: -- ----------------------------------------------------------------------------

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

315: l_api_updating boolean;
316: --
317: Begin
318: --
319: hr_utility.set_location('Entering:'||l_proc, 5);
320: --
321: l_api_updating := ben_pnd_shd.api_updating
322: (p_pl_dpnt_cvg_ctfn_id => p_pl_dpnt_cvg_ctfn_id,
323: p_effective_date => p_effective_date,

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

337: p_effective_date => p_effective_date) then
338: --
339: -- raise error as does not exist as lookup
340: --
341: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
342: hr_utility.raise_error;
343: --
344: end if;
345: --

Line 342: hr_utility.raise_error;

338: --
339: -- raise error as does not exist as lookup
340: --
341: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
342: hr_utility.raise_error;
343: --
344: end if;
345: --
346: end if;

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

344: end if;
345: --
346: end if;
347: --
348: hr_utility.set_location('Leaving:'||l_proc,10);
349: --
350: end chk_dpnt_cvg_ctfn_typ_cd;
351: --
352: -- ----------------------------------------------------------------------------

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

384: l_api_updating boolean;
385: --
386: Begin
387: --
388: hr_utility.set_location('Entering:'||l_proc, 5);
389: --
390: l_api_updating := ben_pnd_shd.api_updating
391: (p_pl_dpnt_cvg_ctfn_id => p_pl_dpnt_cvg_ctfn_id,
392: p_effective_date => p_effective_date,

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

406: p_effective_date => p_effective_date) then
407: --
408: -- raise error as does not exist as lookup
409: --
410: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
411: hr_utility.raise_error;
412: --
413: end if;
414: --

Line 411: hr_utility.raise_error;

407: --
408: -- raise error as does not exist as lookup
409: --
410: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
411: hr_utility.raise_error;
412: --
413: end if;
414: --
415: end if;

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

413: end if;
414: --
415: end if;
416: --
417: hr_utility.set_location('Leaving:'||l_proc,10);
418: --
419: end chk_lack_ctfn_sspnd_enrt_flag;
420: --
421: -- ----------------------------------------------------------------------------

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

470: and ff.effective_end_date;
471: --
472: Begin
473: --
474: hr_utility.set_location('Entering:'||l_proc, 5);
475: --
476: l_api_updating := ben_pnd_shd.api_updating
477: (p_pl_dpnt_cvg_ctfn_id => p_pl_dpnt_cvg_ctfn_id,
478: p_effective_date => p_effective_date,

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

509: close c1;
510: --
511: end if;
512: --
513: hr_utility.set_location('Leaving:'||l_proc,10);
514: --
515: end chk_ctfn_rqd_when_rl;
516: --
517: -- ----------------------------------------------------------------------------

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

549: l_api_updating boolean;
550: --
551: Begin
552: --
553: hr_utility.set_location('Entering:'||l_proc, 5);
554: --
555: l_api_updating := ben_pnd_shd.api_updating
556: (p_pl_dpnt_cvg_ctfn_id => p_pl_dpnt_cvg_ctfn_id,
557: p_effective_date => p_effective_date,

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

571: p_effective_date => p_effective_date) then
572: --
573: -- raise error as does not exist as lookup
574: --
575: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
576: hr_utility.raise_error;
577: --
578: end if;
579: --

Line 576: hr_utility.raise_error;

572: --
573: -- raise error as does not exist as lookup
574: --
575: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
576: hr_utility.raise_error;
577: --
578: end if;
579: --
580: end if;

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

578: end if;
579: --
580: end if;
581: --
582: hr_utility.set_location('Leaving:'||l_proc,10);
583: --
584: end chk_pfd_flag;
585: --
586: -- ----------------------------------------------------------------------------

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

622: l_integrity_error Exception;
623: l_table_name all_tables.table_name%TYPE;
624: --
625: Begin
626: hr_utility.set_location('Entering:'||l_proc, 5);
627: --
628: -- Ensure that the p_datetrack_mode argument is not null
629: --
630: hr_api.mandatory_arg_error

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

661: End If;
662: --
663: End If;
664: --
665: hr_utility.set_location(' Leaving:'||l_proc, 10);
666: Exception
667: When l_integrity_error Then
668: --
669: -- A referential integrity check was violated therefore

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

668: --
669: -- A referential integrity check was violated therefore
670: -- we must error
671: --
672: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
673: hr_utility.set_message_token('TABLE_NAME', l_table_name);
674: hr_utility.raise_error;
675: When Others Then
676: --

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

669: -- A referential integrity check was violated therefore
670: -- we must error
671: --
672: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
673: hr_utility.set_message_token('TABLE_NAME', l_table_name);
674: hr_utility.raise_error;
675: When Others Then
676: --
677: -- An unhandled or unexpected error has occurred which

Line 674: hr_utility.raise_error;

670: -- we must error
671: --
672: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
673: hr_utility.set_message_token('TABLE_NAME', l_table_name);
674: hr_utility.raise_error;
675: When Others Then
676: --
677: -- An unhandled or unexpected error has occurred which
678: -- we must report

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

676: --
677: -- An unhandled or unexpected error has occurred which
678: -- we must report
679: --
680: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
681: hr_utility.set_message_token('PROCEDURE', l_proc);
682: hr_utility.set_message_token('STEP','15');
683: hr_utility.raise_error;
684: End dt_update_validate;

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

677: -- An unhandled or unexpected error has occurred which
678: -- we must report
679: --
680: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
681: hr_utility.set_message_token('PROCEDURE', l_proc);
682: hr_utility.set_message_token('STEP','15');
683: hr_utility.raise_error;
684: End dt_update_validate;
685: --

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

678: -- we must report
679: --
680: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
681: hr_utility.set_message_token('PROCEDURE', l_proc);
682: hr_utility.set_message_token('STEP','15');
683: hr_utility.raise_error;
684: End dt_update_validate;
685: --
686: -- ----------------------------------------------------------------------------

Line 683: hr_utility.raise_error;

679: --
680: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
681: hr_utility.set_message_token('PROCEDURE', l_proc);
682: hr_utility.set_message_token('STEP','15');
683: hr_utility.raise_error;
684: End dt_update_validate;
685: --
686: -- ----------------------------------------------------------------------------
687: -- |--------------------------< dt_delete_validate >--------------------------|

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

728: l_rows_exist Exception;
729: l_table_name all_tables.table_name%TYPE;
730: --
731: Begin
732: hr_utility.set_location('Entering:'||l_proc, 5);
733: --
734: -- Ensure that the p_datetrack_mode argument is not null
735: --
736: hr_api.mandatory_arg_error

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

765: --
766: --
767: End If;
768: --
769: hr_utility.set_location(' Leaving:'||l_proc, 10);
770: Exception
771: When l_rows_exist Then
772: --
773: -- A referential integrity check was violated therefore

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

772: --
773: -- A referential integrity check was violated therefore
774: -- we must error
775: --
776: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
777: hr_utility.set_message_token('TABLE_NAME', l_table_name);
778: hr_utility.raise_error;
779: When Others Then
780: --

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

773: -- A referential integrity check was violated therefore
774: -- we must error
775: --
776: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
777: hr_utility.set_message_token('TABLE_NAME', l_table_name);
778: hr_utility.raise_error;
779: When Others Then
780: --
781: -- An unhandled or unexpected error has occurred which

Line 778: hr_utility.raise_error;

774: -- we must error
775: --
776: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
777: hr_utility.set_message_token('TABLE_NAME', l_table_name);
778: hr_utility.raise_error;
779: When Others Then
780: --
781: -- An unhandled or unexpected error has occurred which
782: -- we must report

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

780: --
781: -- An unhandled or unexpected error has occurred which
782: -- we must report
783: --
784: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
785: hr_utility.set_message_token('PROCEDURE', l_proc);
786: hr_utility.set_message_token('STEP','15');
787: hr_utility.raise_error;
788: End dt_delete_validate;

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

781: -- An unhandled or unexpected error has occurred which
782: -- we must report
783: --
784: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
785: hr_utility.set_message_token('PROCEDURE', l_proc);
786: hr_utility.set_message_token('STEP','15');
787: hr_utility.raise_error;
788: End dt_delete_validate;
789: --

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

782: -- we must report
783: --
784: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
785: hr_utility.set_message_token('PROCEDURE', l_proc);
786: hr_utility.set_message_token('STEP','15');
787: hr_utility.raise_error;
788: End dt_delete_validate;
789: --
790: -- ----------------------------------------------------------------------------

Line 787: hr_utility.raise_error;

783: --
784: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
785: hr_utility.set_message_token('PROCEDURE', l_proc);
786: hr_utility.set_message_token('STEP','15');
787: hr_utility.raise_error;
788: End dt_delete_validate;
789: --
790: -- ----------------------------------------------------------------------------
791: -- |---------------------------< insert_validate >----------------------------|

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

799: --
800: l_proc varchar2(72) := g_package||'insert_validate';
801: --
802: Begin
803: hr_utility.set_location('Entering:'||l_proc, 5);
804: --
805: -- Call all supporting business operations
806: --
807: --

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

857: p_pfd_flag => p_rec.pfd_flag,
858: p_effective_date => p_effective_date,
859: p_object_version_number => p_rec.object_version_number);
860: --
861: hr_utility.set_location(' Leaving:'||l_proc, 10);
862: End insert_validate;
863: --
864: -- ----------------------------------------------------------------------------
865: -- |---------------------------< update_validate >----------------------------|

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

873: --
874: l_proc varchar2(72) := g_package||'update_validate';
875: --
876: Begin
877: hr_utility.set_location('Entering:'||l_proc, 5);
878: --
879: -- Call all supporting business operations
880: --
881: --

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

939: p_datetrack_mode => p_datetrack_mode,
940: p_validation_start_date => p_validation_start_date,
941: p_validation_end_date => p_validation_end_date);
942: --
943: hr_utility.set_location(' Leaving:'||l_proc, 10);
944: End update_validate;
945: --
946: -- ----------------------------------------------------------------------------
947: -- |---------------------------< delete_validate >----------------------------|

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

955: --
956: l_proc varchar2(72) := g_package||'delete_validate';
957: --
958: Begin
959: hr_utility.set_location('Entering:'||l_proc, 5);
960: --
961: -- Call all supporting business operations
962: --
963: dt_delete_validate

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

965: p_validation_start_date => p_validation_start_date,
966: p_validation_end_date => p_validation_end_date,
967: p_pl_dpnt_cvg_ctfn_id => p_rec.pl_dpnt_cvg_ctfn_id);
968: --
969: hr_utility.set_location(' Leaving:'||l_proc, 10);
970: End delete_validate;
971: --
972: --
973: -- ---------------------------------------------------------------------------

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

992: l_proc varchar2(72) := g_package||'return_legislation_code';
993: --
994: begin
995: --
996: hr_utility.set_location('Entering:'|| l_proc, 10);
997: --
998: -- Ensure that all the mandatory parameter are not null
999: --
1000: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

1010: close csr_leg_code;
1011: --
1012: -- The primary key is invalid therefore we must error
1013: --
1014: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
1015: hr_utility.raise_error;
1016: --
1017: end if;
1018: --

Line 1015: hr_utility.raise_error;

1011: --
1012: -- The primary key is invalid therefore we must error
1013: --
1014: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
1015: hr_utility.raise_error;
1016: --
1017: end if;
1018: --
1019: close csr_leg_code;

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

1017: end if;
1018: --
1019: close csr_leg_code;
1020: --
1021: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1022: --
1023: return l_legislation_code;
1024: --
1025: end return_legislation_code;