DBA Data[Home] [Help]

APPS.PAY_TDF_BUS dependencies on FND_MESSAGE

Line 63: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');

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: );

Line 144: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');

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: --

Line 145: fnd_message.raise_error;

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

Line 206: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

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;

Line 207: fnd_message.set_token('PROCEDURE ', l_proc);

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: --

Line 208: fnd_message.set_token('STEP ', '5');

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) <>

Line 209: fnd_message.raise_error;

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

Line 266: fnd_message.set_name('PAY', 'PAY_34057_FLSA_CROSS_VAL1');

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:

Line 267: fnd_message.raise_error;

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;

Line 309: fnd_message.set_name('PAY', 'PAY_34057_FLSA_CROSS_VAL1');

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:

Line 310: fnd_message.set_token('ARGUMENT1', 'Business Group');

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;

Line 311: fnd_message.set_token('ARGUMENT2', 'Legislation Code');

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:

Line 312: fnd_message.raise_error;

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

Line 554: fnd_message.set_name('PAY', 'PAY_34052_FLSA_ARG_NOT_NULL');

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;

Line 555: fnd_message.set_token('ARGUMENT', 'Years');

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:

Line 556: fnd_message.raise_error;

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

Line 562: fnd_message.set_name('PAY', 'PAY_34053_FLSA_ARG_NULL');

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;

Line 563: fnd_message.set_token('ARGUMENT', 'Years');

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:

Line 564: fnd_message.raise_error;

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

Line 570: fnd_message.set_name('PAY', 'PAY_34054_FLSA_ARG_ZERO');

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;

Line 571: fnd_message.set_token('ARGUMENT', 'Years');

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:

Line 572: fnd_message.raise_error;

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

Line 579: fnd_message.set_name('PAY', 'PAY_34055_FLSA_YEARS_INV_UPD');

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:

Line 580: fnd_message.raise_error;

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;

Line 669: fnd_message.set_name('PAY', 'PAY_34057_FLSA_CROSS_VAL1');

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:

Line 670: fnd_message.set_token('ARGUMENT1', 'Period Type');

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

Line 671: fnd_message.set_token('ARGUMENT2', 'Definition for Next Start Date');

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:

Line 672: fnd_message.raise_error;

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');

Line 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:

Line 677: fnd_message.set_token('ARGUMENT1', 'Period Type');

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;

Line 678: fnd_message.set_token('ARGUMENT2', 'Definition for Next Start Date');

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:

Line 679: fnd_message.raise_error;

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;

Line 689: fnd_message.set_name('PAY', 'PAY_34060_FLSA_CROSS_VAL3');

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:

Line 690: fnd_message.raise_error;

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');

Line 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

Line 695: fnd_message.set_token('ARGUMENT', 'Period Type');

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;

Line 696: fnd_message.raise_error;

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;

Line 702: fnd_message.set_name('PAY', 'PAY_34053_FLSA_ARG_NULL');

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;

Line 703: fnd_message.set_token('ARGUMENT', 'Period Unit');

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;

Line 704: fnd_message.raise_error;

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:

Line 799: fnd_message.set_name('PAY', 'PAY_34052_FLSA_ARG_NOT_NULL');

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;

Line 800: fnd_message.set_token('ARGUMENT', 'Period Type');

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:

Line 801: fnd_message.raise_error;

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

Line 811: fnd_message.set_name('PAY', 'PAY_34059_FLSA_ARG_INVALID');

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;

Line 812: fnd_message.set_token('ARGUMENT', '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

Line 813: fnd_message.raise_error;

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;

Line 822: fnd_message.set_name('PAY', 'PAY_34059_FLSA_ARG_INVALID');

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;

Line 823: fnd_message.set_token('ARGUMENT', '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;

Line 824: fnd_message.raise_error;

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;

Line 906: fnd_message.set_name('PAY', 'PAY_34052_FLSA_ARG_NOT_NULL');

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;

Line 907: fnd_message.set_token('ARGUMENT', 'Period Unit');

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:

Line 908: fnd_message.raise_error;

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;

Line 986: fnd_message.set_name('PAY', 'PAY_34052_FLSA_ARG_NOT_NULL');

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;

Line 987: fnd_message.set_token('ARGUMENT', 'Day Adjustment');

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;

Line 988: fnd_message.raise_error;

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: --

Line 1065: fnd_message.set_name('PAY', 'PAY_34052_FLSA_ARG_NOT_NULL');

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;

Line 1066: fnd_message.set_token('ARGUMENT', 'Start Date');

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:

Line 1067: fnd_message.raise_error;

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

Line 1073: fnd_message.set_name('PAY', 'PAY_34053_FLSA_ARG_NULL');

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;

Line 1074: fnd_message.set_token('ARGUMENT', 'Start Date');

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:

Line 1075: fnd_message.raise_error;

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;

Line 1184: fnd_message.set_name('PAY', 'PAY_34052_FLSA_ARG_NOT_NULL');

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;

Line 1185: fnd_message.set_token('ARGUMENT', 'Period Time Definition Id');

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:

Line 1186: fnd_message.raise_error;

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

Line 1198: fnd_message.set_name('PAY', 'PAY_34059_FLSA_ARG_INVALID');

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;

Line 1199: fnd_message.set_token('ARGUMENT', 'Period Time Definition');

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:

Line 1200: fnd_message.raise_error;

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;

Line 1319: fnd_message.set_name('PAY','PAY_34061_FLSA_DUP_NAME');

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:

Line 1320: fnd_message.raise_error;

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;

Line 1406: fnd_message.set_name('PAY','PAY_34062_FLSA_DUP_SHORT_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:

Line 1407: fnd_message.raise_error;

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;

Line 1493: fnd_message.set_name('PAY','PAY_34059_FLSA_ARG_INVALID');

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;

Line 1494: fnd_message.set_token('ARGUMENT', 'Definition Type');

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:

Line 1495: fnd_message.raise_error;

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;

Line 1565: fnd_message.set_name('PAY', 'PAY_34059_FLSA_ARG_INVALID');

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;

Line 1566: fnd_message.set_token('ARGUMENT', '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:

Line 1567: fnd_message.raise_error;

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);

Line 1879: fnd_message.set_name('PAY', 'PAY_34064_FLSA_INV_DELETE');

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:

Line 1880: fnd_message.raise_error;

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);