DBA Data[Home] [Help]

APPS.BEN_PTP_BUS dependencies on FND_MESSAGE

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

133: p_effective_date => p_effective_date) then
134: --
135: -- raise error as does not exist as lookup
136: --
137: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
138: fnd_message.raise_error;
139: --
140: end if;
141: --

Line 138: fnd_message.raise_error;

134: --
135: -- raise error as does not exist as lookup
136: --
137: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
138: fnd_message.raise_error;
139: --
140: end if;
141: --
142: end if;

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

202: p_effective_date => p_effective_date) then
203: --
204: -- raise error as does not exist as lookup
205: --
206: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
207: fnd_message.raise_error;
208: --
209: end if;
210: --

Line 207: fnd_message.raise_error;

203: --
204: -- raise error as does not exist as lookup
205: --
206: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
207: fnd_message.raise_error;
208: --
209: end if;
210: --
211: end if;

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

271: p_effective_date => p_effective_date) then
272: --
273: -- raise error as does not exist as lookup
274: --
275: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
276: fnd_message.raise_error;
277: --
278: end if;
279: --

Line 276: fnd_message.raise_error;

272: --
273: -- raise error as does not exist as lookup
274: --
275: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
276: fnd_message.raise_error;
277: --
278: end if;
279: --
280: end if;

Line 370: fnd_message.set_name('BEN','BEN_93922_PTP_PL_RPTG_GRP_IREC');

366: --
367: -- Raise error : as there is plan associated with the plan type being updated - which
368: -- is also associated to iRecruitment Reporting Group
369: --
370: fnd_message.set_name('BEN','BEN_93922_PTP_PL_RPTG_GRP_IREC');
371: fnd_message.raise_error;
372: --
373: end if;
374: --

Line 371: fnd_message.raise_error;

367: -- Raise error : as there is plan associated with the plan type being updated - which
368: -- is also associated to iRecruitment Reporting Group
369: --
370: fnd_message.set_name('BEN','BEN_93922_PTP_PL_RPTG_GRP_IREC');
371: fnd_message.raise_error;
372: --
373: end if;
374: --
375: close c1;

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

440: p_effective_date => p_effective_date) then
441: --
442: -- raise error as does not exist as lookup
443: --
444: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
445: fnd_message.raise_error;
446: --
447: end if;
448:

Line 445: fnd_message.raise_error;

441: --
442: -- raise error as does not exist as lookup
443: --
444: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
445: fnd_message.raise_error;
446: --
447: end if;
448:
449: --iRec

Line 464: fnd_message.set_name('BEN','BEN_93923_OPTYP_SSDISP_INVALID');

460: then
461: --
462: -- Raise error as Self Service Display code does not match Option Type code
463: --
464: fnd_message.set_name('BEN','BEN_93923_OPTYP_SSDISP_INVALID');
465: fnd_message.raise_error;
466: --
467: end if;
468: */

Line 465: fnd_message.raise_error;

461: --
462: -- Raise error as Self Service Display code does not match Option Type code
463: --
464: fnd_message.set_name('BEN','BEN_93923_OPTYP_SSDISP_INVALID');
465: fnd_message.raise_error;
466: --
467: end if;
468: */
469: --

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

533: p_effective_date => p_effective_date) then
534: --
535: -- raise error as does not exist as lookup
536: --
537: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
538: fnd_message.raise_error;
539: --
540: end if;
541: --

Line 538: fnd_message.raise_error;

534: --
535: -- raise error as does not exist as lookup
536: --
537: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
538: fnd_message.raise_error;
539: --
540: end if;
541: --
542: end if;

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

602: p_effective_date => p_effective_date) then
603: --
604: -- raise error as does not exist as lookup
605: --
606: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
607: fnd_message.raise_error;
608: --
609: end if;
610: --

Line 607: fnd_message.raise_error;

603: --
604: -- raise error as does not exist as lookup
605: --
606: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
607: fnd_message.raise_error;
608: --
609: end if;
610: --
611: end if;

Line 697: fnd_message.set_name('BEN', 'BEN_91009_NAME_NOT_UNIQUE');

693: close csr_name;
694: --
695: -- raise error as UK1 is violated
696: --
697: fnd_message.set_name('BEN', 'BEN_91009_NAME_NOT_UNIQUE');
698: fnd_message.raise_error;
699: -- ben_reg_shd.constraint_error('BEN_PL_TYP_F_UK1');
700: --
701: end if;

Line 698: fnd_message.raise_error;

694: --
695: -- raise error as UK1 is violated
696: --
697: fnd_message.set_name('BEN', 'BEN_91009_NAME_NOT_UNIQUE');
698: fnd_message.raise_error;
699: -- ben_reg_shd.constraint_error('BEN_PL_TYP_F_UK1');
700: --
701: end if;
702: --

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

765: --
766: -- raise error if max value not greater than or equal to min value
767: --
768: if (p_mx_enrl_alwd_num < p_mn_enrl_rqd_num) then
769: fnd_message.set_name('BEN','BEN_91069_INVALID_MIN_MAX');
770: fnd_message.raise_error;
771: end if;
772: --
773: --

Line 770: fnd_message.raise_error;

766: -- raise error if max value not greater than or equal to min value
767: --
768: if (p_mx_enrl_alwd_num < p_mn_enrl_rqd_num) then
769: fnd_message.set_name('BEN','BEN_91069_INVALID_MIN_MAX');
770: fnd_message.raise_error;
771: end if;
772: --
773: --
774: end if;

Line 781: fnd_message.set_name('BEN','BEN_91056_MIN_VAL_NOT_NULL');

777: -- then maximum enroll allowed number must be 0.
778: --
779: if nvl( p_no_mx_enrl_num_dfnd_flag, hr_api.g_varchar2) <> 'N'
780: and (nvl(p_mx_enrl_alwd_num, 0) <> 0) then
781: fnd_message.set_name('BEN','BEN_91056_MIN_VAL_NOT_NULL');
782: fnd_message.raise_error;
783: end if;
784: --
785: if nvl( p_no_mn_enrl_num_dfnd_flag, hr_api.g_varchar2) <> 'N'

Line 782: fnd_message.raise_error;

778: --
779: if nvl( p_no_mx_enrl_num_dfnd_flag, hr_api.g_varchar2) <> 'N'
780: and (nvl(p_mx_enrl_alwd_num, 0) <> 0) then
781: fnd_message.set_name('BEN','BEN_91056_MIN_VAL_NOT_NULL');
782: fnd_message.raise_error;
783: end if;
784: --
785: if nvl( p_no_mn_enrl_num_dfnd_flag, hr_api.g_varchar2) <> 'N'
786: and (nvl(p_mn_enrl_rqd_num, 0) <> 0) then

Line 787: fnd_message.set_name('BEN','BEN_91054_MIN_VAL_NOT_NULL');

783: end if;
784: --
785: if nvl( p_no_mn_enrl_num_dfnd_flag, hr_api.g_varchar2) <> 'N'
786: and (nvl(p_mn_enrl_rqd_num, 0) <> 0) then
787: fnd_message.set_name('BEN','BEN_91054_MIN_VAL_NOT_NULL');
788: fnd_message.raise_error;
789: end if;
790: --
791: --

Line 788: fnd_message.raise_error;

784: --
785: if nvl( p_no_mn_enrl_num_dfnd_flag, hr_api.g_varchar2) <> 'N'
786: and (nvl(p_mn_enrl_rqd_num, 0) <> 0) then
787: fnd_message.set_name('BEN','BEN_91054_MIN_VAL_NOT_NULL');
788: fnd_message.raise_error;
789: end if;
790: --
791: --
792: hr_utility.set_location('Leaving:'||l_proc,10);

Line 876: --fnd_message.set_name('BEN', 'BEN_91009_NAME_NOT_UNIQUE');

872: close c_opt_typ_cd;
873: --
874: -- raise error there's already a GSP pln type
875: --
876: --fnd_message.set_name('BEN', 'BEN_91009_NAME_NOT_UNIQUE');
877: fnd_message.set_name('BEN', 'BEN_93528_GSP_PLN_TYP');
878: fnd_message.raise_error;
879: --
880: end if;

Line 877: fnd_message.set_name('BEN', 'BEN_93528_GSP_PLN_TYP');

873: --
874: -- raise error there's already a GSP pln type
875: --
876: --fnd_message.set_name('BEN', 'BEN_91009_NAME_NOT_UNIQUE');
877: fnd_message.set_name('BEN', 'BEN_93528_GSP_PLN_TYP');
878: fnd_message.raise_error;
879: --
880: end if;
881: --

Line 878: fnd_message.raise_error;

874: -- raise error there's already a GSP pln type
875: --
876: --fnd_message.set_name('BEN', 'BEN_91009_NAME_NOT_UNIQUE');
877: fnd_message.set_name('BEN', 'BEN_93528_GSP_PLN_TYP');
878: fnd_message.raise_error;
879: --
880: end if;
881: --
882: close c_opt_typ_cd;

Line 969: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');

965: --
966: -- A referential integrity check was violated therefore
967: -- we must error
968: --
969: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
970: fnd_message.set_token('TABLE_NAME', l_table_name);
971: fnd_message.raise_error;
972: When Others Then
973: --

Line 970: fnd_message.set_token('TABLE_NAME', l_table_name);

966: -- A referential integrity check was violated therefore
967: -- we must error
968: --
969: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
970: fnd_message.set_token('TABLE_NAME', l_table_name);
971: fnd_message.raise_error;
972: When Others Then
973: --
974: -- An unhandled or unexpected error has occurred which

Line 971: fnd_message.raise_error;

967: -- we must error
968: --
969: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
970: fnd_message.set_token('TABLE_NAME', l_table_name);
971: fnd_message.raise_error;
972: When Others Then
973: --
974: -- An unhandled or unexpected error has occurred which
975: -- we must report

Line 977: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

973: --
974: -- An unhandled or unexpected error has occurred which
975: -- we must report
976: --
977: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
978: fnd_message.set_token('PROCEDURE', l_proc);
979: fnd_message.set_token('STEP','15');
980: fnd_message.raise_error;
981: End dt_update_validate;

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

974: -- An unhandled or unexpected error has occurred which
975: -- we must report
976: --
977: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
978: fnd_message.set_token('PROCEDURE', l_proc);
979: fnd_message.set_token('STEP','15');
980: fnd_message.raise_error;
981: End dt_update_validate;
982: --

Line 979: fnd_message.set_token('STEP','15');

975: -- we must report
976: --
977: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
978: fnd_message.set_token('PROCEDURE', l_proc);
979: fnd_message.set_token('STEP','15');
980: fnd_message.raise_error;
981: End dt_update_validate;
982: --
983: -- ----------------------------------------------------------------------------

Line 980: fnd_message.raise_error;

976: --
977: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
978: fnd_message.set_token('PROCEDURE', l_proc);
979: fnd_message.set_token('STEP','15');
980: fnd_message.raise_error;
981: End dt_update_validate;
982: --
983: -- ----------------------------------------------------------------------------
984: -- |--------------------------< dt_delete_validate >--------------------------|

Line 1108: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

1104: --
1105: -- An unhandled or unexpected error has occurred which
1106: -- we must report
1107: --
1108: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1109: fnd_message.set_token('PROCEDURE', l_proc);
1110: fnd_message.set_token('STEP','15');
1111: fnd_message.raise_error;
1112: End dt_delete_validate;

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

1105: -- An unhandled or unexpected error has occurred which
1106: -- we must report
1107: --
1108: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1109: fnd_message.set_token('PROCEDURE', l_proc);
1110: fnd_message.set_token('STEP','15');
1111: fnd_message.raise_error;
1112: End dt_delete_validate;
1113: --

Line 1110: fnd_message.set_token('STEP','15');

1106: -- we must report
1107: --
1108: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1109: fnd_message.set_token('PROCEDURE', l_proc);
1110: fnd_message.set_token('STEP','15');
1111: fnd_message.raise_error;
1112: End dt_delete_validate;
1113: --
1114: -- ----------------------------------------------------------------------------

Line 1111: fnd_message.raise_error;

1107: --
1108: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1109: fnd_message.set_token('PROCEDURE', l_proc);
1110: fnd_message.set_token('STEP','15');
1111: fnd_message.raise_error;
1112: End dt_delete_validate;
1113: --
1114: -- ----------------------------------------------------------------------------
1115: -- |---------------------------< insert_validate >----------------------------|

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

1382: close csr_leg_code;
1383: --
1384: -- The primary key is invalid therefore we must error
1385: --
1386: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1387: fnd_message.raise_error;
1388: --
1389: end if;
1390: --

Line 1387: fnd_message.raise_error;

1383: --
1384: -- The primary key is invalid therefore we must error
1385: --
1386: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1387: fnd_message.raise_error;
1388: --
1389: end if;
1390: --
1391: close csr_leg_code;