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

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

40: l_api_updating boolean;
41: --
42: Begin
43: --
44: hr_utility.set_location('Entering:'||l_proc, 5);
45: --
46: l_api_updating := ben_cpy_shd.api_updating
47: (p_popl_yr_perd_id => p_popl_yr_perd_id,
48: p_object_version_number => p_object_version_number);

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

68: end if;
69: --
70: end if;
71: --
72: hr_utility.set_location('Leaving:'||l_proc, 10);
73: --
74: End chk_popl_yr_perd_id;
75: --
76: -- ----------------------------------------------------------------------------

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

163: and cpy.business_group_id+0 = p_business_group_id;
164: --
165: Begin
166: --
167: hr_utility.set_location('Entering:'||l_proc, 5);
168: --
169: l_api_updating := ben_cpy_shd.api_updating
170: (p_popl_yr_perd_id => p_popl_yr_perd_id,
171: p_object_version_number => p_object_version_number);

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

229: close c_duplicate;
230: --
231: end if;
232: --
233: hr_utility.set_location('Leaving:'||l_proc, 10);
234: --
235: End chk_pgm_pl_yr_perd_id;
236: -- ----------------------------------------------------------------------------
237: -- |----------------------------< chk_pl_id >---------------------------------|

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

277: and a.effective_end_date;
278: --
279: Begin
280: --
281: hr_utility.set_location('Entering:'||l_proc,5);
282: --
283: l_api_updating := ben_cpy_shd.api_updating
284: (p_popl_yr_perd_id => p_popl_yr_perd_id,
285: p_object_version_number => p_object_version_number);

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

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

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

357: and a.effective_end_date;
358: --
359: Begin
360: --
361: hr_utility.set_location('Entering:'||l_proc,5);
362: --
363: l_api_updating := ben_cpy_shd.api_updating
364: (p_popl_yr_perd_id => p_popl_yr_perd_id,
365: p_object_version_number => p_object_version_number);

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

388: close c1;
389: --
390: end if;
391: --
392: hr_utility.set_location('Leaving:'||l_proc,10);
393: --
394: End chk_pgm_id;
395: --
396: -- ----------------------------------------------------------------------------

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

434: where a.yr_perd_id = p_yr_perd_id;
435: --
436: Begin
437: --
438: hr_utility.set_location('Entering:'||l_proc,5);
439: --
440: l_api_updating := ben_cpy_shd.api_updating
441: (p_popl_yr_perd_id => p_popl_yr_perd_id,
442: p_object_version_number => p_object_version_number);

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

471: close c1;
472: --
473: end if;
474: --
475: hr_utility.set_location('Leaving:'||l_proc,10);
476: --
477: End chk_yr_perd_id;
478: --
479: -- ----------------------------------------------------------------------------

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

506: l_proc varchar2(72) := g_package||'chk_pgm_pl_id';
507: --
508: Begin
509: --
510: hr_utility.set_location('Entering:'||l_proc,5);
511: --
512: -- check that only one of the foreign keys is populated.
513: --
514: if p_pgm_id is not null and

Line 517: hr_utility.set_message(801,'PGM_OR_PL_ID_SET');

513: --
514: if p_pgm_id is not null and
515: p_pl_id is not null then
516: --
517: hr_utility.set_message(801,'PGM_OR_PL_ID_SET');
518: hr_utility.raise_error;
519: --
520: elsif p_pgm_id is null and
521: p_pl_id is null then

Line 518: hr_utility.raise_error;

514: if p_pgm_id is not null and
515: p_pl_id is not null then
516: --
517: hr_utility.set_message(801,'PGM_OR_PL_ID_SET');
518: hr_utility.raise_error;
519: --
520: elsif p_pgm_id is null and
521: p_pl_id is null then
522: --

Line 523: hr_utility.set_message(801,'PGM_OR_PL_ID_SET');

519: --
520: elsif p_pgm_id is null and
521: p_pl_id is null then
522: --
523: hr_utility.set_message(801,'PGM_OR_PL_ID_SET');
524: hr_utility.raise_error;
525: --
526: end if;
527: --

Line 524: hr_utility.raise_error;

520: elsif p_pgm_id is null and
521: p_pl_id is null then
522: --
523: hr_utility.set_message(801,'PGM_OR_PL_ID_SET');
524: hr_utility.raise_error;
525: --
526: end if;
527: --
528: hr_utility.set_location('Leaving:'||l_proc,10);

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

524: hr_utility.raise_error;
525: --
526: end if;
527: --
528: hr_utility.set_location('Leaving:'||l_proc,10);
529: --
530: End chk_pgm_pl_id;
531: -- ----------------------------------------------------------------------------
532: -- |---------------------------< chk_acpt_clm_rqsts_thru_dt >-----------------|

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

573: where a.yr_perd_id = p_yr_perd_id;
574: --
575: Begin
576: --
577: hr_utility.set_location('Entering:'||l_proc,5);
578: --
579: l_api_updating := ben_cpy_shd.api_updating
580: (p_popl_yr_perd_id => p_popl_yr_perd_id,
581: p_object_version_number => p_object_version_number);

Line 608: hr_utility.set_message(805,'BEN_91317_PY_CLMS_OR_ACPT_NULL');

604: then
605: --
606: -- error py_clms_thru_dt or acpt_rqsts_clm_thru_dt are null
607: --
608: hr_utility.set_message(805,'BEN_91317_PY_CLMS_OR_ACPT_NULL');
609: hr_utility.raise_error;
610: --
611: end if;
612:

Line 609: hr_utility.raise_error;

605: --
606: -- error py_clms_thru_dt or acpt_rqsts_clm_thru_dt are null
607: --
608: hr_utility.set_message(805,'BEN_91317_PY_CLMS_OR_ACPT_NULL');
609: hr_utility.raise_error;
610: --
611: end if;
612:
613: if (p_py_clms_thru_dt is null and p_acpt_clm_rqsts_thru_dt is not null)

Line 615: hr_utility.set_message(805,'BEN_92696_RQST_DT_TO_INCRD_DT');

611: end if;
612:
613: if (p_py_clms_thru_dt is null and p_acpt_clm_rqsts_thru_dt is not null)
614: and ( p_py_clms_thru_dt > p_acpt_clm_rqsts_thru_dt) then
615: hr_utility.set_message(805,'BEN_92696_RQST_DT_TO_INCRD_DT');
616: hr_utility.raise_error;
617: end if ;
618: --
619: -- check if yr_perd_id yields a start and end for a comparison

Line 616: hr_utility.raise_error;

612:
613: if (p_py_clms_thru_dt is null and p_acpt_clm_rqsts_thru_dt is not null)
614: and ( p_py_clms_thru_dt > p_acpt_clm_rqsts_thru_dt) then
615: hr_utility.set_message(805,'BEN_92696_RQST_DT_TO_INCRD_DT');
616: hr_utility.raise_error;
617: end if ;
618: --
619: -- check if yr_perd_id yields a start and end for a comparison
620: --

Line 642: hr_utility.set_message(805,'BEN_91318_ACPT_LT_YR_PERD');

638: if (p_acpt_clm_rqsts_thru_dt < l_end) then
639: --
640: -- error acpt_clm_rqsts_thru_dt less than yr_perd end_date
641: --
642: hr_utility.set_message(805,'BEN_91318_ACPT_LT_YR_PERD');
643: hr_utility.raise_error;
644: --
645: end if;
646: --

Line 643: hr_utility.raise_error;

639: --
640: -- error acpt_clm_rqsts_thru_dt less than yr_perd end_date
641: --
642: hr_utility.set_message(805,'BEN_91318_ACPT_LT_YR_PERD');
643: hr_utility.raise_error;
644: --
645: end if;
646: --
647: close c1;

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

647: close c1;
648: --
649: end if;
650: --
651: hr_utility.set_location('Leaving:'||l_proc,10);
652: --
653: End chk_acpt_clm_rqsts_thru_dt;
654: --
655: -- ----------------------------------------------------------------------------

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

708: l_Claims varchar2(1);
709: --
710: Begin
711: --
712: hr_utility.set_location('Entering:'||l_proc,5);
713: --
714: l_api_updating := ben_cpy_shd.api_updating
715: (p_popl_yr_perd_id => p_popl_yr_perd_id,
716: p_object_version_number => p_object_version_number);

Line 762: hr_utility.set_message(805,'BEN_91319_PY_CLMS_GT_YR_END');

758: if (p_py_clms_thru_dt > l_end) then
759: --
760: -- error py_clms_thru_dt is greater than yr_perd end_date
761: --
762: hr_utility.set_message(805,'BEN_91319_PY_CLMS_GT_YR_END');
763: hr_utility.raise_error;
764: --
765: end if;
766: */

Line 763: hr_utility.raise_error;

759: --
760: -- error py_clms_thru_dt is greater than yr_perd end_date
761: --
762: hr_utility.set_message(805,'BEN_91319_PY_CLMS_GT_YR_END');
763: hr_utility.raise_error;
764: --
765: end if;
766: */
767: --

Line 779: hr_utility.set_message(805,'BEN_91316_PY_CLMS_LT_ACPT');

775: p_acpt_clm_rqsts_thru_dt is not null then
776: --
777: -- error py_clms_thru_dt must be less than acpt_rqsts_clm_thru_dt
778: --
779: hr_utility.set_message(805,'BEN_91316_PY_CLMS_LT_ACPT');
780: hr_utility.raise_error;
781: --
782: end if;
783: --

Line 780: hr_utility.raise_error;

776: --
777: -- error py_clms_thru_dt must be less than acpt_rqsts_clm_thru_dt
778: --
779: hr_utility.set_message(805,'BEN_91316_PY_CLMS_LT_ACPT');
780: hr_utility.raise_error;
781: --
782: end if;
783: --
784: end if;

Line 795: hr_utility.set_message(805,'BEN_91316_PY_CLMS_LT_ACPT');

791: fetch c_claims into l_claims;
792: if c_claims%found then
793: --
794: close c_claims;
795: hr_utility.set_message(805,'BEN_91316_PY_CLMS_LT_ACPT');
796: hr_utility.raise_error;
797: else
798: --
799: close c_claims;

Line 796: hr_utility.raise_error;

792: if c_claims%found then
793: --
794: close c_claims;
795: hr_utility.set_message(805,'BEN_91316_PY_CLMS_LT_ACPT');
796: hr_utility.raise_error;
797: else
798: --
799: close c_claims;
800: --

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

801: end if;
802: --
803: end if;
804:
805: hr_utility.set_location('Leaving:'||l_proc,10);
806: --
807: End chk_py_clms_thru_dt;
808: --
809: -- ---------------------------------------------------------------------------

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

855: and ordr_num = p_ordr_num
856: and business_group_id = p_business_group_id;
857: --
858: Begin
859: hr_utility.set_location('Entering:'||l_proc, 5);
860: --
861: open c1;
862: fetch c1 into l_dummy;
863: if c1%found then

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

865: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
866: fnd_message.raise_error;
867: end if;
868: --
869: hr_utility.set_location('Leaving:'||l_proc, 15);
870: End chk_ordr_num_unique;
871: --
872: -- ----------------------------------------------------------------------------
873: -- |---------------------------< insert_validate >----------------------------|

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

876: --
877: l_proc varchar2(72) := g_package||'insert_validate';
878: --
879: Begin
880: hr_utility.set_location('Entering:'||l_proc, 5);
881: --
882: -- Call all supporting business operations
883: --
884: --

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

928: p_pgm_id => p_rec.pgm_id,
929: p_ordr_num => p_rec.ordr_num,
930: p_business_group_id => p_rec.business_group_id);
931: --
932: hr_utility.set_location(' Leaving:'||l_proc, 10);
933: End insert_validate;
934: --
935: -- ----------------------------------------------------------------------------
936: -- |---------------------------< update_validate >----------------------------|

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

939: --
940: l_proc varchar2(72) := g_package||'update_validate';
941: --
942: Begin
943: hr_utility.set_location('Entering:'||l_proc, 5);
944: --
945: -- Call all supporting business operations
946: --
947: --

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

991: p_pgm_id => p_rec.pgm_id,
992: p_ordr_num => p_rec.ordr_num,
993: p_business_group_id => p_rec.business_group_id);
994: --
995: hr_utility.set_location(' Leaving:'||l_proc, 10);
996: End update_validate;
997: --
998: -- ----------------------------------------------------------------------------
999: -- |---------------------------< delete_validate >----------------------------|

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

1002: --
1003: l_proc varchar2(72) := g_package||'delete_validate';
1004: --
1005: Begin
1006: hr_utility.set_location('Entering:'||l_proc, 5);
1007: --
1008: -- Call all supporting business operations
1009: --
1010: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

1006: hr_utility.set_location('Entering:'||l_proc, 5);
1007: --
1008: -- Call all supporting business operations
1009: --
1010: hr_utility.set_location(' Leaving:'||l_proc, 10);
1011: End delete_validate;
1012: --
1013: -- ---------------------------------------------------------------------------
1014: -- |---------------------< return_legislation_code >-------------------------|

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

1032: l_proc varchar2(72) := g_package||'return_legislation_code';
1033: --
1034: begin
1035: --
1036: hr_utility.set_location('Entering:'|| l_proc, 10);
1037: --
1038: -- Ensure that all the mandatory parameter are not null
1039: --
1040: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

1050: close csr_leg_code;
1051: --
1052: -- The primary key is invalid therefore we must error
1053: --
1054: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
1055: hr_utility.raise_error;
1056: --
1057: end if;
1058: --

Line 1055: hr_utility.raise_error;

1051: --
1052: -- The primary key is invalid therefore we must error
1053: --
1054: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
1055: hr_utility.raise_error;
1056: --
1057: end if;
1058: --
1059: close csr_leg_code;

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

1057: end if;
1058: --
1059: close csr_leg_code;
1060: --
1061: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1062: --
1063: return l_legislation_code;
1064: --
1065: end return_legislation_code;