59: close csr_sec_grp;
60: --
61: -- The primary key is invalid therefore we must error
62: --
63: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
64: hr_multi_message.add
65: (p_associated_column1
66: => nvl(p_associated_column1,'TIME_DEFINITION_ID')
67: );
140: --
141: -- The primary key is invalid therefore we must error
142: --
143: close csr_leg_code;
144: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
145: fnd_message.raise_error;
146: end if;
147: hr_utility.set_location(l_proc,30);
148: --
141: -- The primary key is invalid therefore we must error
142: --
143: close csr_leg_code;
144: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
145: fnd_message.raise_error;
146: end if;
147: hr_utility.set_location(l_proc,30);
148: --
149: -- Set the global variables so the values are
202: IF NOT pay_tdf_shd.api_updating
203: (p_time_definition_id => p_rec.time_definition_id
204: ,p_object_version_number => p_rec.object_version_number
205: ) THEN
206: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
207: fnd_message.set_token('PROCEDURE ', l_proc);
208: fnd_message.set_token('STEP ', '5');
209: fnd_message.raise_error;
210: END IF;
203: (p_time_definition_id => p_rec.time_definition_id
204: ,p_object_version_number => p_rec.object_version_number
205: ) THEN
206: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
207: fnd_message.set_token('PROCEDURE ', l_proc);
208: fnd_message.set_token('STEP ', '5');
209: fnd_message.raise_error;
210: END IF;
211: --
204: ,p_object_version_number => p_rec.object_version_number
205: ) THEN
206: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
207: fnd_message.set_token('PROCEDURE ', l_proc);
208: fnd_message.set_token('STEP ', '5');
209: fnd_message.raise_error;
210: END IF;
211: --
212: if nvl(p_rec.business_group_id, hr_api.g_number) <>
205: ) THEN
206: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
207: fnd_message.set_token('PROCEDURE ', l_proc);
208: fnd_message.set_token('STEP ', '5');
209: fnd_message.raise_error;
210: END IF;
211: --
212: if nvl(p_rec.business_group_id, hr_api.g_number) <>
213: nvl(pay_tdf_shd.g_old_rec.business_group_id, hr_api.g_number) then
262:
263: p_regenerate_periods := false;
264: p_delete_periods := false;
265:
266: fnd_message.set_name('PAY', 'PAY_34057_FLSA_CROSS_VAL1');
267: fnd_message.raise_error;
268:
269: else
270:
263: p_regenerate_periods := false;
264: p_delete_periods := false;
265:
266: fnd_message.set_name('PAY', 'PAY_34057_FLSA_CROSS_VAL1');
267: fnd_message.raise_error;
268:
269: else
270:
271: p_regenerate_periods := true;
305: IF (p_insert) THEN
306:
307: if p_business_group_id is not null and p_legislation_code is not null then
308:
309: fnd_message.set_name('PAY', 'PAY_34057_FLSA_CROSS_VAL1');
310: fnd_message.set_token('ARGUMENT1', 'Business Group');
311: fnd_message.set_token('ARGUMENT2', 'Legislation Code');
312: fnd_message.raise_error;
313:
306:
307: if p_business_group_id is not null and p_legislation_code is not null then
308:
309: fnd_message.set_name('PAY', 'PAY_34057_FLSA_CROSS_VAL1');
310: fnd_message.set_token('ARGUMENT1', 'Business Group');
311: fnd_message.set_token('ARGUMENT2', 'Legislation Code');
312: fnd_message.raise_error;
313:
314: end if;
307: if p_business_group_id is not null and p_legislation_code is not null then
308:
309: fnd_message.set_name('PAY', 'PAY_34057_FLSA_CROSS_VAL1');
310: fnd_message.set_token('ARGUMENT1', 'Business Group');
311: fnd_message.set_token('ARGUMENT2', 'Legislation Code');
312: fnd_message.raise_error;
313:
314: end if;
315:
308:
309: fnd_message.set_name('PAY', 'PAY_34057_FLSA_CROSS_VAL1');
310: fnd_message.set_token('ARGUMENT1', 'Business Group');
311: fnd_message.set_token('ARGUMENT2', 'Legislation Code');
312: fnd_message.raise_error;
313:
314: end if;
315:
316: hr_startup_data_api_support.chk_startup_action
550:
551: if p_definition_type in ('P','E','C')
552: and p_number_of_years is not null then
553:
554: fnd_message.set_name('PAY', 'PAY_34052_FLSA_ARG_NOT_NULL');
555: fnd_message.set_token('ARGUMENT', 'Years');
556: fnd_message.raise_error;
557:
558: end if;
551: if p_definition_type in ('P','E','C')
552: and p_number_of_years is not null then
553:
554: fnd_message.set_name('PAY', 'PAY_34052_FLSA_ARG_NOT_NULL');
555: fnd_message.set_token('ARGUMENT', 'Years');
556: fnd_message.raise_error;
557:
558: end if;
559:
552: and p_number_of_years is not null then
553:
554: fnd_message.set_name('PAY', 'PAY_34052_FLSA_ARG_NOT_NULL');
555: fnd_message.set_token('ARGUMENT', 'Years');
556: fnd_message.raise_error;
557:
558: end if;
559:
560: if p_definition_type = 'S' and p_number_of_years is null then
558: end if;
559:
560: if p_definition_type = 'S' and p_number_of_years is null then
561:
562: fnd_message.set_name('PAY', 'PAY_34053_FLSA_ARG_NULL');
563: fnd_message.set_token('ARGUMENT', 'Years');
564: fnd_message.raise_error;
565:
566: end if;
559:
560: if p_definition_type = 'S' and p_number_of_years is null then
561:
562: fnd_message.set_name('PAY', 'PAY_34053_FLSA_ARG_NULL');
563: fnd_message.set_token('ARGUMENT', 'Years');
564: fnd_message.raise_error;
565:
566: end if;
567:
560: if p_definition_type = 'S' and p_number_of_years is null then
561:
562: fnd_message.set_name('PAY', 'PAY_34053_FLSA_ARG_NULL');
563: fnd_message.set_token('ARGUMENT', 'Years');
564: fnd_message.raise_error;
565:
566: end if;
567:
568: if p_definition_type = 'S' and p_number_of_years <= 0 then
566: end if;
567:
568: if p_definition_type = 'S' and p_number_of_years <= 0 then
569:
570: fnd_message.set_name('PAY', 'PAY_34054_FLSA_ARG_ZERO');
571: fnd_message.set_token('ARGUMENT', 'Years');
572: fnd_message.raise_error;
573:
574: end if;
567:
568: if p_definition_type = 'S' and p_number_of_years <= 0 then
569:
570: fnd_message.set_name('PAY', 'PAY_34054_FLSA_ARG_ZERO');
571: fnd_message.set_token('ARGUMENT', 'Years');
572: fnd_message.raise_error;
573:
574: end if;
575:
568: if p_definition_type = 'S' and p_number_of_years <= 0 then
569:
570: fnd_message.set_name('PAY', 'PAY_34054_FLSA_ARG_ZERO');
571: fnd_message.set_token('ARGUMENT', 'Years');
572: fnd_message.raise_error;
573:
574: end if;
575:
576: if l_api_updating and p_definition_type = 'S' and
575:
576: if l_api_updating and p_definition_type = 'S' and
577: p_number_of_years < nvl(pay_tdf_shd.g_old_rec.number_of_years,0) then
578:
579: fnd_message.set_name('PAY', 'PAY_34055_FLSA_YEARS_INV_UPD');
580: fnd_message.raise_error;
581:
582: end if;
583:
576: if l_api_updating and p_definition_type = 'S' and
577: p_number_of_years < nvl(pay_tdf_shd.g_old_rec.number_of_years,0) then
578:
579: fnd_message.set_name('PAY', 'PAY_34055_FLSA_YEARS_INV_UPD');
580: fnd_message.raise_error;
581:
582: end if;
583:
584: end if;
665: if p_definition_type = 'S' then
666:
667: if p_period_type is not null and p_period_time_definition_id is not null then
668:
669: fnd_message.set_name('PAY', 'PAY_34057_FLSA_CROSS_VAL1');
670: fnd_message.set_token('ARGUMENT1', 'Period Type');
671: fnd_message.set_token('ARGUMENT2', 'Definition for Next Start Date');
672: fnd_message.raise_error;
673:
666:
667: if p_period_type is not null and p_period_time_definition_id is not null then
668:
669: fnd_message.set_name('PAY', 'PAY_34057_FLSA_CROSS_VAL1');
670: fnd_message.set_token('ARGUMENT1', 'Period Type');
671: fnd_message.set_token('ARGUMENT2', 'Definition for Next Start Date');
672: fnd_message.raise_error;
673:
674: elsif p_period_type is null and p_period_time_definition_id is null then
667: if p_period_type is not null and p_period_time_definition_id is not null then
668:
669: fnd_message.set_name('PAY', 'PAY_34057_FLSA_CROSS_VAL1');
670: fnd_message.set_token('ARGUMENT1', 'Period Type');
671: fnd_message.set_token('ARGUMENT2', 'Definition for Next Start Date');
672: fnd_message.raise_error;
673:
674: elsif p_period_type is null and p_period_time_definition_id is null then
675:
668:
669: fnd_message.set_name('PAY', 'PAY_34057_FLSA_CROSS_VAL1');
670: fnd_message.set_token('ARGUMENT1', 'Period Type');
671: fnd_message.set_token('ARGUMENT2', 'Definition for Next Start Date');
672: fnd_message.raise_error;
673:
674: elsif p_period_type is null and p_period_time_definition_id is null then
675:
676: fnd_message.set_name('PAY', 'PAY_34058_FLSA_CROSS_VAL2');
672: fnd_message.raise_error;
673:
674: elsif p_period_type is null and p_period_time_definition_id is null then
675:
676: fnd_message.set_name('PAY', 'PAY_34058_FLSA_CROSS_VAL2');
677: fnd_message.set_token('ARGUMENT1', 'Period Type');
678: fnd_message.set_token('ARGUMENT2', 'Definition for Next Start Date');
679: fnd_message.raise_error;
680:
673:
674: elsif p_period_type is null and p_period_time_definition_id is null then
675:
676: fnd_message.set_name('PAY', 'PAY_34058_FLSA_CROSS_VAL2');
677: fnd_message.set_token('ARGUMENT1', 'Period Type');
678: fnd_message.set_token('ARGUMENT2', 'Definition for Next Start Date');
679: fnd_message.raise_error;
680:
681: end if;
674: elsif p_period_type is null and p_period_time_definition_id is null then
675:
676: fnd_message.set_name('PAY', 'PAY_34058_FLSA_CROSS_VAL2');
677: fnd_message.set_token('ARGUMENT1', 'Period Type');
678: fnd_message.set_token('ARGUMENT2', 'Definition for Next Start Date');
679: fnd_message.raise_error;
680:
681: end if;
682:
675:
676: fnd_message.set_name('PAY', 'PAY_34058_FLSA_CROSS_VAL2');
677: fnd_message.set_token('ARGUMENT1', 'Period Type');
678: fnd_message.set_token('ARGUMENT2', 'Definition for Next Start Date');
679: fnd_message.raise_error;
680:
681: end if;
682:
683: end if;
685: if p_definition_type = 'P' then
686: if p_period_type is null and p_period_unit is null
687: and p_day_adjustment is null then
688:
689: fnd_message.set_name('PAY', 'PAY_34060_FLSA_CROSS_VAL3');
690: fnd_message.raise_error;
691:
692: elsif p_period_type is null and p_period_unit is not null then
693:
686: if p_period_type is null and p_period_unit is null
687: and p_day_adjustment is null then
688:
689: fnd_message.set_name('PAY', 'PAY_34060_FLSA_CROSS_VAL3');
690: fnd_message.raise_error;
691:
692: elsif p_period_type is null and p_period_unit is not null then
693:
694: fnd_message.set_name('PAY', 'PAY_34053_FLSA_ARG_NULL');
690: fnd_message.raise_error;
691:
692: elsif p_period_type is null and p_period_unit is not null then
693:
694: fnd_message.set_name('PAY', 'PAY_34053_FLSA_ARG_NULL');
695: fnd_message.set_token('ARGUMENT', 'Period Type');
696: fnd_message.raise_error;
697:
698: elsif p_period_type is not null and p_period_unit is null then
691:
692: elsif p_period_type is null and p_period_unit is not null then
693:
694: fnd_message.set_name('PAY', 'PAY_34053_FLSA_ARG_NULL');
695: fnd_message.set_token('ARGUMENT', 'Period Type');
696: fnd_message.raise_error;
697:
698: elsif p_period_type is not null and p_period_unit is null then
699: open csr_pit_period_type;
692: elsif p_period_type is null and p_period_unit is not null then
693:
694: fnd_message.set_name('PAY', 'PAY_34053_FLSA_ARG_NULL');
695: fnd_message.set_token('ARGUMENT', 'Period Type');
696: fnd_message.raise_error;
697:
698: elsif p_period_type is not null and p_period_unit is null then
699: open csr_pit_period_type;
700: fetch csr_pit_period_type into l_exists;
698: elsif p_period_type is not null and p_period_unit is null then
699: open csr_pit_period_type;
700: fetch csr_pit_period_type into l_exists;
701: if csr_pit_period_type%found then
702: fnd_message.set_name('PAY', 'PAY_34053_FLSA_ARG_NULL');
703: fnd_message.set_token('ARGUMENT', 'Period Unit');
704: fnd_message.raise_error;
705: end if;
706: close csr_pit_period_type;
699: open csr_pit_period_type;
700: fetch csr_pit_period_type into l_exists;
701: if csr_pit_period_type%found then
702: fnd_message.set_name('PAY', 'PAY_34053_FLSA_ARG_NULL');
703: fnd_message.set_token('ARGUMENT', 'Period Unit');
704: fnd_message.raise_error;
705: end if;
706: close csr_pit_period_type;
707: end if;
700: fetch csr_pit_period_type into l_exists;
701: if csr_pit_period_type%found then
702: fnd_message.set_name('PAY', 'PAY_34053_FLSA_ARG_NULL');
703: fnd_message.set_token('ARGUMENT', 'Period Unit');
704: fnd_message.raise_error;
705: end if;
706: close csr_pit_period_type;
707: end if;
708:
795:
796: if p_definition_type in ('E','C')
797: and p_period_type is not null then
798:
799: fnd_message.set_name('PAY', 'PAY_34052_FLSA_ARG_NOT_NULL');
800: fnd_message.set_token('ARGUMENT', 'Period Type');
801: fnd_message.raise_error;
802:
803: end if;
796: if p_definition_type in ('E','C')
797: and p_period_type is not null then
798:
799: fnd_message.set_name('PAY', 'PAY_34052_FLSA_ARG_NOT_NULL');
800: fnd_message.set_token('ARGUMENT', 'Period Type');
801: fnd_message.raise_error;
802:
803: end if;
804:
797: and p_period_type is not null then
798:
799: fnd_message.set_name('PAY', 'PAY_34052_FLSA_ARG_NOT_NULL');
800: fnd_message.set_token('ARGUMENT', 'Period Type');
801: fnd_message.raise_error;
802:
803: end if;
804:
805: if p_period_type is not null then
807: open csr_pit_period_type;
808: fetch csr_pit_period_type into l_exists;
809: if csr_pit_period_type%notfound then
810: close csr_pit_period_type;
811: fnd_message.set_name('PAY', 'PAY_34059_FLSA_ARG_INVALID');
812: fnd_message.set_token('ARGUMENT', 'Period Type');
813: fnd_message.raise_error;
814: end if;
815: close csr_pit_period_type;
808: fetch csr_pit_period_type into l_exists;
809: if csr_pit_period_type%notfound then
810: close csr_pit_period_type;
811: fnd_message.set_name('PAY', 'PAY_34059_FLSA_ARG_INVALID');
812: fnd_message.set_token('ARGUMENT', 'Period Type');
813: fnd_message.raise_error;
814: end if;
815: close csr_pit_period_type;
816: else
809: if csr_pit_period_type%notfound then
810: close csr_pit_period_type;
811: fnd_message.set_name('PAY', 'PAY_34059_FLSA_ARG_INVALID');
812: fnd_message.set_token('ARGUMENT', 'Period Type');
813: fnd_message.raise_error;
814: end if;
815: close csr_pit_period_type;
816: else
817: open csr_period_type;
818: fetch csr_period_type into l_exists;
819:
820: if csr_period_type%notfound then
821: close csr_period_type;
822: fnd_message.set_name('PAY', 'PAY_34059_FLSA_ARG_INVALID');
823: fnd_message.set_token('ARGUMENT', 'Period Type');
824: fnd_message.raise_error;
825: end if;
826: close csr_period_type;
819:
820: if csr_period_type%notfound then
821: close csr_period_type;
822: fnd_message.set_name('PAY', 'PAY_34059_FLSA_ARG_INVALID');
823: fnd_message.set_token('ARGUMENT', 'Period Type');
824: fnd_message.raise_error;
825: end if;
826: close csr_period_type;
827: end if;
820: if csr_period_type%notfound then
821: close csr_period_type;
822: fnd_message.set_name('PAY', 'PAY_34059_FLSA_ARG_INVALID');
823: fnd_message.set_token('ARGUMENT', 'Period Type');
824: fnd_message.raise_error;
825: end if;
826: close csr_period_type;
827: end if;
828: end if;
902:
903: if p_definition_type in ('S','E','C')
904: and p_period_unit is not null then
905:
906: fnd_message.set_name('PAY', 'PAY_34052_FLSA_ARG_NOT_NULL');
907: fnd_message.set_token('ARGUMENT', 'Period Unit');
908: fnd_message.raise_error;
909:
910: end if;
903: if p_definition_type in ('S','E','C')
904: and p_period_unit is not null then
905:
906: fnd_message.set_name('PAY', 'PAY_34052_FLSA_ARG_NOT_NULL');
907: fnd_message.set_token('ARGUMENT', 'Period Unit');
908: fnd_message.raise_error;
909:
910: end if;
911:
904: and p_period_unit is not null then
905:
906: fnd_message.set_name('PAY', 'PAY_34052_FLSA_ARG_NOT_NULL');
907: fnd_message.set_token('ARGUMENT', 'Period Unit');
908: fnd_message.raise_error;
909:
910: end if;
911:
912: end if;
982:
983: if p_definition_type in ('S','E','C')
984: and p_day_adjustment is not null then
985:
986: fnd_message.set_name('PAY', 'PAY_34052_FLSA_ARG_NOT_NULL');
987: fnd_message.set_token('ARGUMENT', 'Day Adjustment');
988: fnd_message.raise_error;
989:
990: end if;
983: if p_definition_type in ('S','E','C')
984: and p_day_adjustment is not null then
985:
986: fnd_message.set_name('PAY', 'PAY_34052_FLSA_ARG_NOT_NULL');
987: fnd_message.set_token('ARGUMENT', 'Day Adjustment');
988: fnd_message.raise_error;
989:
990: end if;
991: end if;
984: and p_day_adjustment is not null then
985:
986: fnd_message.set_name('PAY', 'PAY_34052_FLSA_ARG_NOT_NULL');
987: fnd_message.set_token('ARGUMENT', 'Day Adjustment');
988: fnd_message.raise_error;
989:
990: end if;
991: end if;
992: --
1061:
1062: if p_definition_type in ('P','E','C')
1063: and p_start_date is not null then
1064:
1065: fnd_message.set_name('PAY', 'PAY_34052_FLSA_ARG_NOT_NULL');
1066: fnd_message.set_token('ARGUMENT', 'Start Date');
1067: fnd_message.raise_error;
1068:
1069: end if;
1062: if p_definition_type in ('P','E','C')
1063: and p_start_date is not null then
1064:
1065: fnd_message.set_name('PAY', 'PAY_34052_FLSA_ARG_NOT_NULL');
1066: fnd_message.set_token('ARGUMENT', 'Start Date');
1067: fnd_message.raise_error;
1068:
1069: end if;
1070:
1063: and p_start_date is not null then
1064:
1065: fnd_message.set_name('PAY', 'PAY_34052_FLSA_ARG_NOT_NULL');
1066: fnd_message.set_token('ARGUMENT', 'Start Date');
1067: fnd_message.raise_error;
1068:
1069: end if;
1070:
1071: if p_definition_type = 'S' and p_start_date is null then
1069: end if;
1070:
1071: if p_definition_type = 'S' and p_start_date is null then
1072:
1073: fnd_message.set_name('PAY', 'PAY_34053_FLSA_ARG_NULL');
1074: fnd_message.set_token('ARGUMENT', 'Start Date');
1075: fnd_message.raise_error;
1076:
1077: end if;
1070:
1071: if p_definition_type = 'S' and p_start_date is null then
1072:
1073: fnd_message.set_name('PAY', 'PAY_34053_FLSA_ARG_NULL');
1074: fnd_message.set_token('ARGUMENT', 'Start Date');
1075: fnd_message.raise_error;
1076:
1077: end if;
1078:
1071: if p_definition_type = 'S' and p_start_date is null then
1072:
1073: fnd_message.set_name('PAY', 'PAY_34053_FLSA_ARG_NULL');
1074: fnd_message.set_token('ARGUMENT', 'Start Date');
1075: fnd_message.raise_error;
1076:
1077: end if;
1078:
1079: end if;
1180:
1181: if p_definition_type in ('P','E','C')
1182: and p_period_time_definition_id is not null then
1183:
1184: fnd_message.set_name('PAY', 'PAY_34052_FLSA_ARG_NOT_NULL');
1185: fnd_message.set_token('ARGUMENT', 'Period Time Definition Id');
1186: fnd_message.raise_error;
1187:
1188: end if;
1181: if p_definition_type in ('P','E','C')
1182: and p_period_time_definition_id is not null then
1183:
1184: fnd_message.set_name('PAY', 'PAY_34052_FLSA_ARG_NOT_NULL');
1185: fnd_message.set_token('ARGUMENT', 'Period Time Definition Id');
1186: fnd_message.raise_error;
1187:
1188: end if;
1189:
1182: and p_period_time_definition_id is not null then
1183:
1184: fnd_message.set_name('PAY', 'PAY_34052_FLSA_ARG_NOT_NULL');
1185: fnd_message.set_token('ARGUMENT', 'Period Time Definition Id');
1186: fnd_message.raise_error;
1187:
1188: end if;
1189:
1190: if p_period_time_definition_id is not null then
1194:
1195: if csr_period_time_definition_id%notfound then
1196:
1197: close csr_period_time_definition_id;
1198: fnd_message.set_name('PAY', 'PAY_34059_FLSA_ARG_INVALID');
1199: fnd_message.set_token('ARGUMENT', 'Period Time Definition');
1200: fnd_message.raise_error;
1201:
1202: end if;
1195: if csr_period_time_definition_id%notfound then
1196:
1197: close csr_period_time_definition_id;
1198: fnd_message.set_name('PAY', 'PAY_34059_FLSA_ARG_INVALID');
1199: fnd_message.set_token('ARGUMENT', 'Period Time Definition');
1200: fnd_message.raise_error;
1201:
1202: end if;
1203:
1196:
1197: close csr_period_time_definition_id;
1198: fnd_message.set_name('PAY', 'PAY_34059_FLSA_ARG_INVALID');
1199: fnd_message.set_token('ARGUMENT', 'Period Time Definition');
1200: fnd_message.raise_error;
1201:
1202: end if;
1203:
1204: close csr_period_time_definition_id;
1315: if csr_definition_name%found then
1316:
1317: close csr_definition_name;
1318:
1319: fnd_message.set_name('PAY','PAY_34061_FLSA_DUP_NAME');
1320: fnd_message.raise_error;
1321:
1322: end if;
1323:
1316:
1317: close csr_definition_name;
1318:
1319: fnd_message.set_name('PAY','PAY_34061_FLSA_DUP_NAME');
1320: fnd_message.raise_error;
1321:
1322: end if;
1323:
1324: close csr_definition_name;
1402: if csr_short_name%found then
1403:
1404: close csr_short_name;
1405:
1406: fnd_message.set_name('PAY','PAY_34062_FLSA_DUP_SHORT_NAME');
1407: fnd_message.raise_error;
1408:
1409: end if;
1410:
1403:
1404: close csr_short_name;
1405:
1406: fnd_message.set_name('PAY','PAY_34062_FLSA_DUP_SHORT_NAME');
1407: fnd_message.raise_error;
1408:
1409: end if;
1410:
1411: close csr_short_name;
1489: if csr_definition_type%notfound then
1490:
1491: close csr_definition_type;
1492:
1493: fnd_message.set_name('PAY','PAY_34059_FLSA_ARG_INVALID');
1494: fnd_message.set_token('ARGUMENT', 'Definition Type');
1495: fnd_message.raise_error;
1496:
1497: end if;
1490:
1491: close csr_definition_type;
1492:
1493: fnd_message.set_name('PAY','PAY_34059_FLSA_ARG_INVALID');
1494: fnd_message.set_token('ARGUMENT', 'Definition Type');
1495: fnd_message.raise_error;
1496:
1497: end if;
1498:
1491: close csr_definition_type;
1492:
1493: fnd_message.set_name('PAY','PAY_34059_FLSA_ARG_INVALID');
1494: fnd_message.set_token('ARGUMENT', 'Definition Type');
1495: fnd_message.raise_error;
1496:
1497: end if;
1498:
1499: close csr_definition_type;
1561: fetch csr_legislation_code into l_exists ;
1562:
1563: if csr_legislation_code%notfound then
1564: close csr_legislation_code;
1565: fnd_message.set_name('PAY', 'PAY_34059_FLSA_ARG_INVALID');
1566: fnd_message.set_token('ARGUMENT', 'Legislation Code');
1567: fnd_message.raise_error;
1568: end if;
1569: close csr_legislation_code;
1562:
1563: if csr_legislation_code%notfound then
1564: close csr_legislation_code;
1565: fnd_message.set_name('PAY', 'PAY_34059_FLSA_ARG_INVALID');
1566: fnd_message.set_token('ARGUMENT', 'Legislation Code');
1567: fnd_message.raise_error;
1568: end if;
1569: close csr_legislation_code;
1570:
1563: if csr_legislation_code%notfound then
1564: close csr_legislation_code;
1565: fnd_message.set_name('PAY', 'PAY_34059_FLSA_ARG_INVALID');
1566: fnd_message.set_token('ARGUMENT', 'Legislation Code');
1567: fnd_message.raise_error;
1568: end if;
1569: close csr_legislation_code;
1570:
1571: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1875: );
1876:
1877: if l_time_def_usage then
1878:
1879: fnd_message.set_name('PAY', 'PAY_34064_FLSA_INV_DELETE');
1880: fnd_message.raise_error;
1881:
1882: end if;
1883:
1876:
1877: if l_time_def_usage then
1878:
1879: fnd_message.set_name('PAY', 'PAY_34064_FLSA_INV_DELETE');
1880: fnd_message.raise_error;
1881:
1882: end if;
1883:
1884: hr_utility.set_location(' Leaving:'||l_proc, 10);