DBA Data[Home] [Help]

APPS.BEN_SHR_BUS dependencies on FND_MESSAGE

Line 201: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');

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

Line 202: fnd_message.raise_error;

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

Line 295: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');

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

Line 296: fnd_message.set_token('VAR1','Scheduled Hours',TRUE);

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;

Line 297: fnd_message.set_token('VAR2','Variable Rate Profile',TRUE);

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;

Line 298: fnd_message.raise_error;

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

Line 638: fnd_message.set_name('BEN', 'BEN_93220_MIN_MAX_HRS_OR_RULE');

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

Line 639: fnd_message.raise_error;

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

Line 644: fnd_message.set_name('BEN','BEN_93222_MIN_MAX_HRS_NOT_NULL');

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;

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

Line 647: fnd_message.set_name('BEN', 'BEN_93220_MIN_MAX_HRS_OR_RULE');

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

Line 648: fnd_message.raise_error;

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;

Line 651: fnd_message.set_name('BEN','BEN_91069_INVALID_MIN_MAX');

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;

Line 652: fnd_message.raise_error;

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

Line 779: fnd_message.set_name('BEN', 'BEN_93221_SCH_HRS_RL_INVALID');

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

Line 780: fnd_message.raise_error;

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;

Line 842: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');

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;

Line 843: fnd_message.raise_error;

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:

Line 903: fnd_message.set_name('BEN','BEN_91098_LOS_DET_RL_NULL');

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,

Line 904: fnd_message.raise_error;

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,

Line 910: fnd_message.set_name('BEN','BEN_91066_INVLD_LOS_DET_RL');

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

Line 911: fnd_message.raise_error;

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

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

Line 916: 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;
920: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 976: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');

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;

Line 977: fnd_message.raise_error;

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:

Line 1036: fnd_message.set_name('BEN','BEN_91733_RNDG_RULE');

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,

Line 1037: fnd_message.raise_error;

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,

Line 1043: fnd_message.set_name('BEN','BEN_91042_INVALID_RNDG_RL');

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

Line 1044: fnd_message.raise_error;

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

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

Line 1049: 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;
1053: --