197: open c1;
198: fetch c1 into l_dummy;
199: if c1%found then
200: close c1;
201: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
202: fnd_message.raise_error;
203: end if;
204: close c1;
205: --
198: fetch c1 into l_dummy;
199: if c1%found then
200: close c1;
201: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
202: fnd_message.raise_error;
203: end if;
204: close c1;
205: --
206: hr_utility.set_location('Leaving:'||l_proc, 15);
291: close c_dup;
292: --
293: -- raise error as this Scheduled Hours criteria already exists for this profile
294: --
295: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
296: fnd_message.set_token('VAR1','Scheduled Hours',TRUE);
297: fnd_message.set_token('VAR2','Variable Rate Profile',TRUE);
298: fnd_message.raise_error;
299: --
292: --
293: -- raise error as this Scheduled Hours criteria already exists for this profile
294: --
295: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
296: fnd_message.set_token('VAR1','Scheduled Hours',TRUE);
297: fnd_message.set_token('VAR2','Variable Rate Profile',TRUE);
298: fnd_message.raise_error;
299: --
300: end if;
293: -- raise error as this Scheduled Hours criteria already exists for this profile
294: --
295: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
296: fnd_message.set_token('VAR1','Scheduled Hours',TRUE);
297: fnd_message.set_token('VAR2','Variable Rate Profile',TRUE);
298: fnd_message.raise_error;
299: --
300: end if;
301: close c_dup;
294: --
295: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
296: fnd_message.set_token('VAR1','Scheduled Hours',TRUE);
297: fnd_message.set_token('VAR2','Variable Rate Profile',TRUE);
298: fnd_message.raise_error;
299: --
300: end if;
301: close c_dup;
302: --
634: or not l_api_updating) then
635: --
636: if (p_schedd_hrs_rl is not null) then
637: if (p_hrs_num is not null) or (p_max_hrs_num is not null) then
638: fnd_message.set_name('BEN', 'BEN_93220_MIN_MAX_HRS_OR_RULE');
639: fnd_message.raise_error;
640: end if;
641: else
642: if (p_hrs_num is null) and (p_max_hrs_num is null) then
635: --
636: if (p_schedd_hrs_rl is not null) then
637: if (p_hrs_num is not null) or (p_max_hrs_num is not null) then
638: fnd_message.set_name('BEN', 'BEN_93220_MIN_MAX_HRS_OR_RULE');
639: fnd_message.raise_error;
640: end if;
641: else
642: if (p_hrs_num is null) and (p_max_hrs_num is null) then
643: if (p_freq_cd is not null) then
640: end if;
641: else
642: if (p_hrs_num is null) and (p_max_hrs_num is null) then
643: if (p_freq_cd is not null) then
644: fnd_message.set_name('BEN','BEN_93222_MIN_MAX_HRS_NOT_NULL');
645: fnd_message.raise_error;
646: else
647: fnd_message.set_name('BEN', 'BEN_93220_MIN_MAX_HRS_OR_RULE');
648: fnd_message.raise_error;
641: else
642: if (p_hrs_num is null) and (p_max_hrs_num is null) then
643: if (p_freq_cd is not null) then
644: fnd_message.set_name('BEN','BEN_93222_MIN_MAX_HRS_NOT_NULL');
645: fnd_message.raise_error;
646: else
647: fnd_message.set_name('BEN', 'BEN_93220_MIN_MAX_HRS_OR_RULE');
648: fnd_message.raise_error;
649: end if;
643: if (p_freq_cd is not null) then
644: fnd_message.set_name('BEN','BEN_93222_MIN_MAX_HRS_NOT_NULL');
645: fnd_message.raise_error;
646: else
647: fnd_message.set_name('BEN', 'BEN_93220_MIN_MAX_HRS_OR_RULE');
648: fnd_message.raise_error;
649: end if;
650: elsif (nvl(p_hrs_num,-99999999999) > nvl(p_max_hrs_num,9999999999999999999999)) then
651: fnd_message.set_name('BEN','BEN_91069_INVALID_MIN_MAX');
644: fnd_message.set_name('BEN','BEN_93222_MIN_MAX_HRS_NOT_NULL');
645: fnd_message.raise_error;
646: else
647: fnd_message.set_name('BEN', 'BEN_93220_MIN_MAX_HRS_OR_RULE');
648: fnd_message.raise_error;
649: end if;
650: elsif (nvl(p_hrs_num,-99999999999) > nvl(p_max_hrs_num,9999999999999999999999)) then
651: fnd_message.set_name('BEN','BEN_91069_INVALID_MIN_MAX');
652: fnd_message.raise_error;
647: fnd_message.set_name('BEN', 'BEN_93220_MIN_MAX_HRS_OR_RULE');
648: fnd_message.raise_error;
649: end if;
650: elsif (nvl(p_hrs_num,-99999999999) > nvl(p_max_hrs_num,9999999999999999999999)) then
651: fnd_message.set_name('BEN','BEN_91069_INVALID_MIN_MAX');
652: fnd_message.raise_error;
653: end if;
654: end if;
655: end if;
648: fnd_message.raise_error;
649: end if;
650: elsif (nvl(p_hrs_num,-99999999999) > nvl(p_max_hrs_num,9999999999999999999999)) then
651: fnd_message.set_name('BEN','BEN_91069_INVALID_MIN_MAX');
652: fnd_message.raise_error;
653: end if;
654: end if;
655: end if;
656: --
775: (p_rl => p_schedd_hrs_rl,
776: p_formula_type_id => -548,
777: p_business_group_id => p_business_group_id,
778: p_effective_date => p_effective_date) ) then /*HARDCODE THE RULE-TYPE HERE */
779: fnd_message.set_name('BEN', 'BEN_93221_SCH_HRS_RL_INVALID');
780: fnd_message.raise_error;
781: End if;
782: End If;
783: --
776: p_formula_type_id => -548,
777: p_business_group_id => p_business_group_id,
778: p_effective_date => p_effective_date) ) then /*HARDCODE THE RULE-TYPE HERE */
779: fnd_message.set_name('BEN', 'BEN_93221_SCH_HRS_RL_INVALID');
780: fnd_message.raise_error;
781: End if;
782: End If;
783: --
784: End If;
838: p_effective_date => p_effective_date) then
839: --
840: -- raise error as does not exist as lookup
841: --
842: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
843: fnd_message.raise_error;
844: end if;
845: end if;
846: end if;
839: --
840: -- raise error as does not exist as lookup
841: --
842: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
843: fnd_message.raise_error;
844: end if;
845: end if;
846: end if;
847:
899: or not l_api_updating) then
900: --
901: If (p_determination_cd = 'RL') then
902: If (p_determination_rl is null) then
903: fnd_message.set_name('BEN','BEN_91098_LOS_DET_RL_NULL');
904: fnd_message.raise_error;
905: elsif (not match_formula_type
906: (p_rl => p_determination_rl,
907: p_formula_type_id => -170,
900: --
901: If (p_determination_cd = 'RL') then
902: If (p_determination_rl is null) then
903: fnd_message.set_name('BEN','BEN_91098_LOS_DET_RL_NULL');
904: fnd_message.raise_error;
905: elsif (not match_formula_type
906: (p_rl => p_determination_rl,
907: p_formula_type_id => -170,
908: p_business_group_id => p_business_group_id,
906: (p_rl => p_determination_rl,
907: p_formula_type_id => -170,
908: p_business_group_id => p_business_group_id,
909: p_effective_date => p_effective_date) ) then /*HARDCODE THE RULE-TYPE HERE */
910: fnd_message.set_name('BEN','BEN_91066_INVLD_LOS_DET_RL');
911: fnd_message.raise_error;
912: End if;
913: Else
914: if (p_determination_rl is not null) then
907: p_formula_type_id => -170,
908: p_business_group_id => p_business_group_id,
909: p_effective_date => p_effective_date) ) then /*HARDCODE THE RULE-TYPE HERE */
910: fnd_message.set_name('BEN','BEN_91066_INVLD_LOS_DET_RL');
911: fnd_message.raise_error;
912: End if;
913: Else
914: if (p_determination_rl is not null) then
915: fnd_message.set_name('BEN','BEN_91071_LOS_DET_RL_NOT_NULL');
911: fnd_message.raise_error;
912: End if;
913: Else
914: if (p_determination_rl is not null) then
915: fnd_message.set_name('BEN','BEN_91071_LOS_DET_RL_NOT_NULL');
916: fnd_message.raise_error;
917: end if;
918: End if;
919: End if;
912: End if;
913: Else
914: if (p_determination_rl is not null) then
915: fnd_message.set_name('BEN','BEN_91071_LOS_DET_RL_NOT_NULL');
916: fnd_message.raise_error;
917: end if;
918: End if;
919: End if;
920: hr_utility.set_location(' Leaving:'||l_proc, 10);
972: p_effective_date => p_effective_date) then
973: --
974: -- raise error as does not exist as lookup
975: --
976: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
977: fnd_message.raise_error;
978: end if;
979: end if;
980: End if;
973: --
974: -- raise error as does not exist as lookup
975: --
976: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
977: fnd_message.raise_error;
978: end if;
979: end if;
980: End if;
981:
1032: or not l_api_updating) then
1033:
1034: If (p_rounding_cd = 'RL') then
1035: If (p_rounding_rl is null) then
1036: fnd_message.set_name('BEN','BEN_91733_RNDG_RULE');
1037: fnd_message.raise_error;
1038: Elsif (not match_formula_type
1039: (p_rl => p_rounding_rl,
1040: p_formula_type_id => -169,
1033:
1034: If (p_rounding_cd = 'RL') then
1035: If (p_rounding_rl is null) then
1036: fnd_message.set_name('BEN','BEN_91733_RNDG_RULE');
1037: fnd_message.raise_error;
1038: Elsif (not match_formula_type
1039: (p_rl => p_rounding_rl,
1040: p_formula_type_id => -169,
1041: p_business_group_id => p_business_group_id,
1039: (p_rl => p_rounding_rl,
1040: p_formula_type_id => -169,
1041: p_business_group_id => p_business_group_id,
1042: p_effective_date => p_effective_date) ) then /*HARDCODE THE RULE-TYPE HERE */
1043: fnd_message.set_name('BEN','BEN_91042_INVALID_RNDG_RL');
1044: fnd_message.raise_error;
1045: End if;
1046: Else
1047: if (p_rounding_rl is not null) then
1040: p_formula_type_id => -169,
1041: p_business_group_id => p_business_group_id,
1042: p_effective_date => p_effective_date) ) then /*HARDCODE THE RULE-TYPE HERE */
1043: fnd_message.set_name('BEN','BEN_91042_INVALID_RNDG_RL');
1044: fnd_message.raise_error;
1045: End if;
1046: Else
1047: if (p_rounding_rl is not null) then
1048: fnd_message.set_name('BEN','BEN_91043_RNDG_RL_NOT_NULL');
1044: fnd_message.raise_error;
1045: End if;
1046: Else
1047: if (p_rounding_rl is not null) then
1048: fnd_message.set_name('BEN','BEN_91043_RNDG_RL_NOT_NULL');
1049: fnd_message.raise_error;
1050: end if;
1051: End if;
1052: End if;
1045: End if;
1046: Else
1047: if (p_rounding_rl is not null) then
1048: fnd_message.set_name('BEN','BEN_91043_RNDG_RL_NOT_NULL');
1049: fnd_message.raise_error;
1050: end if;
1051: End if;
1052: End if;
1053: --