DBA Data[Home] [Help]

APPS.BEN_WYP_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_wyp_shd.api_updating
47: (p_wthn_yr_perd_id => p_wthn_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_wthn_yr_perd_id;
75: --
76: -- ----------------------------------------------------------------------------

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

112: where a.yr_perd_id = p_yr_perd_id;
113: --
114: Begin
115: --
116: hr_utility.set_location('Entering:'||l_proc,5);
117: --
118: l_api_updating := ben_wyp_shd.api_updating
119: (p_wthn_yr_perd_id => p_wthn_yr_perd_id,
120: p_object_version_number => p_object_version_number);

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

144: close c1;
145: --
146: end if;
147: --
148: hr_utility.set_location('Leaving:'||l_proc,10);
149: --
150: End chk_yr_perd_id;
151: --
152: -- ----------------------------------------------------------------------------

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

200: and business_group_id = p_business_group_id;
201:
202: --
203: Begin
204: hr_utility.set_location('Entering:'||l_proc, 5);
205: --
206: open c1;
207: fetch c1 into strt_dd, strt_mm, end_dd, end_mm , l_perd_typ_cd;
208: close c1;

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

456: -- End of fix, Bug 1646921
457:
458: end if;
459:
460: hr_utility.set_location('Leaving:'||l_proc, 15);
461: End chk_day_and_month_validation;
462: --
463: -- ----------------------------------------------------------------------------
464: -- |---------------------< chk_no_overlapping >------------------------|

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

517: and business_group_id + 0 = p_business_group_id;
518: --
519: Begin
520: --
521: hr_utility.set_location('Entering:'||l_proc, 5);
522: --
523: -- check if this combination of dates overlaps within the same uom
524: --
525: open uom;

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

598: end loop;
599: --
600: close uom;
601: --
602: hr_utility.set_location('Leaving:'||l_proc, 20);
603: --
604: End chk_no_overlapping;
605: --
606: -- ----------------------------------------------------------------------------

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

663: and business_group_id + 0 = p_business_group_id;
664: --
665: Begin
666: --
667: hr_utility.set_location('Entering:'||l_proc, 5);
668: --
669: --
670: -- check if this combination already exists within the same uom
671: --

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

684: end if;
685: --
686: close c1;
687: --
688: hr_utility.set_location('Leaving:'||l_proc, 20);
689: --
690: End chk_unique_combination;
691: --
692: -- ----------------------------------------------------------------------------

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

724: l_api_updating boolean;
725: --
726: Begin
727: --
728: hr_utility.set_location('Entering:'||l_proc, 5);
729: --
730: l_api_updating := ben_wyp_shd.api_updating
731: (p_wthn_yr_perd_id => p_wthn_yr_perd_id,
732: p_object_version_number => p_object_version_number);

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

754: end if;
755: --
756: end if;
757: --
758: hr_utility.set_location('Leaving:'||l_proc,10);
759: --
760: end chk_tm_uom;
761: --
762:

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

820: and business_group_id = p_business_group_id;
821:
822: --
823: Begin
824: hr_utility.set_location('Entering:'||l_proc, 5);
825: --
826: open c1;
827: fetch c1 into l_strt_dd, l_strt_mm, l_strt_yy,l_end_dd, l_end_mm,l_end_yy;
828: close c1;

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

855: fnd_message.set_token('TYPE', p_type);
856: fnd_message.raise_error;
857: end;
858:
859: hr_utility.set_location('Leaving:'||l_proc, 15);
860: End chk_valid_date;
861: --
862: -- ----------------------------------------------------------------------------
863: -- |---------------------------< insert_validate >----------------------------|

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

867: --
868: l_proc varchar2(72) := g_package||'insert_validate';
869: --
870: Begin
871: hr_utility.set_location('Entering:'||l_proc, 5);
872: --
873: -- Call all supporting business operations
874: --
875: --

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

943: p_tm_uom => p_rec.tm_uom,
944: p_effective_date => p_effective_date,
945: p_object_version_number => p_rec.object_version_number);
946: --
947: hr_utility.set_location(' Leaving:'||l_proc, 10);
948: End insert_validate;
949: --
950: -- ----------------------------------------------------------------------------
951: -- |---------------------------< update_validate >----------------------------|

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

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

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

1029: p_tm_uom => p_rec.tm_uom,
1030: p_effective_date => p_effective_date,
1031: p_object_version_number => p_rec.object_version_number);
1032: --
1033: hr_utility.set_location(' Leaving:'||l_proc, 10);
1034: End update_validate;
1035: --
1036: -- ----------------------------------------------------------------------------
1037: -- |---------------------------< delete_validate >----------------------------|

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

1041: --
1042: l_proc varchar2(72) := g_package||'delete_validate';
1043: --
1044: Begin
1045: hr_utility.set_location('Entering:'||l_proc, 5);
1046: --
1047: -- Call all supporting business operations
1048: --
1049: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

1045: hr_utility.set_location('Entering:'||l_proc, 5);
1046: --
1047: -- Call all supporting business operations
1048: --
1049: hr_utility.set_location(' Leaving:'||l_proc, 10);
1050: End delete_validate;
1051: --
1052: --
1053: -- ---------------------------------------------------------------------------

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

1072: l_proc varchar2(72) := g_package||'return_legislation_code';
1073: --
1074: begin
1075: --
1076: hr_utility.set_location('Entering:'|| l_proc, 10);
1077: --
1078: -- Ensure that all the mandatory parameter are not null
1079: --
1080: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

1090: close csr_leg_code;
1091: --
1092: -- The primary key is invalid therefore we must error
1093: --
1094: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
1095: hr_utility.raise_error;
1096: --
1097: end if;
1098: --

Line 1095: hr_utility.raise_error;

1091: --
1092: -- The primary key is invalid therefore we must error
1093: --
1094: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
1095: hr_utility.raise_error;
1096: --
1097: end if;
1098: --
1099: close csr_leg_code;

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

1097: end if;
1098: --
1099: close csr_leg_code;
1100: --
1101: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1102: --
1103: return l_legislation_code;
1104: --
1105: end return_legislation_code;