DBA Data[Home] [Help]

APPS.BEN_LDC_BUS dependencies on FND_MESSAGE

Line 156: fnd_message.set_name('PAY','VALUE IS NOT UNIQUE');

152: close chk_unique;
153: --
154: -- raise error as UK1 is violated
155: --
156: fnd_message.set_name('PAY','VALUE IS NOT UNIQUE');
157: fnd_message.raise_error;
158: --
159: end if;
160: --

Line 157: fnd_message.raise_error;

153: --
154: -- raise error as UK1 is violated
155: --
156: fnd_message.set_name('PAY','VALUE IS NOT UNIQUE');
157: fnd_message.raise_error;
158: --
159: end if;
160: --
161: close chk_unique;

Line 250: fnd_message.set_name('PAY','FORMULA_DOES_NOT_EXIST');

246: close c1;
247: --
248: -- raise error
249: --
250: fnd_message.set_name('PAY','FORMULA_DOES_NOT_EXIST');
251: fnd_message.raise_error;
252: --
253: end if;
254: --

Line 251: fnd_message.raise_error;

247: --
248: -- raise error
249: --
250: fnd_message.set_name('PAY','FORMULA_DOES_NOT_EXIST');
251: fnd_message.raise_error;
252: --
253: end if;
254: --
255: close c1;

Line 343: fnd_message.set_name('PAY','FORMULA_DOES_NOT_EXIST');

339: close c1;
340: --
341: -- raise error
342: --
343: fnd_message.set_name('PAY','FORMULA_DOES_NOT_EXIST');
344: fnd_message.raise_error;
345: --
346: end if;
347: --

Line 344: fnd_message.raise_error;

340: --
341: -- raise error
342: --
343: fnd_message.set_name('PAY','FORMULA_DOES_NOT_EXIST');
344: fnd_message.raise_error;
345: --
346: end if;
347: --
348: close c1;

Line 436: fnd_message.set_name('PAY','FORMULA_DOES_NOT_EXIST');

432: close c1;
433: --
434: -- raise error
435: --
436: fnd_message.set_name('PAY','FORMULA_DOES_NOT_EXIST');
437: fnd_message.raise_error;
438: --
439: end if;
440: --

Line 437: fnd_message.raise_error;

433: --
434: -- raise error
435: --
436: fnd_message.set_name('PAY','FORMULA_DOES_NOT_EXIST');
437: fnd_message.raise_error;
438: --
439: end if;
440: --
441: close c1;

Line 507: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');

503: p_effective_date => p_effective_date) then
504: --
505: -- raise error as does not exist as lookup
506: --
507: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
508: fnd_message.set_token('FIELD','p_cvg_eff_strt_cd');
509: fnd_message.set_token('TYPE','BEN_DPNT_CVG_STRT');
510: fnd_message.raise_error;
511: --

Line 508: fnd_message.set_token('FIELD','p_cvg_eff_strt_cd');

504: --
505: -- raise error as does not exist as lookup
506: --
507: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
508: fnd_message.set_token('FIELD','p_cvg_eff_strt_cd');
509: fnd_message.set_token('TYPE','BEN_DPNT_CVG_STRT');
510: fnd_message.raise_error;
511: --
512: end if;

Line 509: fnd_message.set_token('TYPE','BEN_DPNT_CVG_STRT');

505: -- raise error as does not exist as lookup
506: --
507: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
508: fnd_message.set_token('FIELD','p_cvg_eff_strt_cd');
509: fnd_message.set_token('TYPE','BEN_DPNT_CVG_STRT');
510: fnd_message.raise_error;
511: --
512: end if;
513: --

Line 510: fnd_message.raise_error;

506: --
507: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
508: fnd_message.set_token('FIELD','p_cvg_eff_strt_cd');
509: fnd_message.set_token('TYPE','BEN_DPNT_CVG_STRT');
510: fnd_message.raise_error;
511: --
512: end if;
513: --
514: end if;

Line 578: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');

574: p_effective_date => p_effective_date) then
575: --
576: -- raise error as does not exist as lookup
577: --
578: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
579: fnd_message.set_token('FIELD','p_cvg_eff_end_cd');
580: fnd_message.set_token('TYPE','BEN_DPNT_CVG_END');
581: fnd_message.raise_error;
582: --

Line 579: fnd_message.set_token('FIELD','p_cvg_eff_end_cd');

575: --
576: -- raise error as does not exist as lookup
577: --
578: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
579: fnd_message.set_token('FIELD','p_cvg_eff_end_cd');
580: fnd_message.set_token('TYPE','BEN_DPNT_CVG_END');
581: fnd_message.raise_error;
582: --
583: end if;

Line 580: fnd_message.set_token('TYPE','BEN_DPNT_CVG_END');

576: -- raise error as does not exist as lookup
577: --
578: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
579: fnd_message.set_token('FIELD','p_cvg_eff_end_cd');
580: fnd_message.set_token('TYPE','BEN_DPNT_CVG_END');
581: fnd_message.raise_error;
582: --
583: end if;
584: --

Line 581: fnd_message.raise_error;

577: --
578: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
579: fnd_message.set_token('FIELD','p_cvg_eff_end_cd');
580: fnd_message.set_token('TYPE','BEN_DPNT_CVG_END');
581: fnd_message.raise_error;
582: --
583: end if;
584: --
585: end if;

Line 649: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');

645: p_effective_date => p_effective_date) then
646: --
647: -- raise error as does not exist as lookup
648: --
649: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
650: fnd_message.set_token('FIELD','p_add_rmv_cvg_cd');
651: fnd_message.set_token('TYPE','BEN_ADD_RMV');
652: fnd_message.raise_error;
653: --

Line 650: fnd_message.set_token('FIELD','p_add_rmv_cvg_cd');

646: --
647: -- raise error as does not exist as lookup
648: --
649: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
650: fnd_message.set_token('FIELD','p_add_rmv_cvg_cd');
651: fnd_message.set_token('TYPE','BEN_ADD_RMV');
652: fnd_message.raise_error;
653: --
654: end if;

Line 651: fnd_message.set_token('TYPE','BEN_ADD_RMV');

647: -- raise error as does not exist as lookup
648: --
649: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
650: fnd_message.set_token('FIELD','p_add_rmv_cvg_cd');
651: fnd_message.set_token('TYPE','BEN_ADD_RMV');
652: fnd_message.raise_error;
653: --
654: end if;
655: --

Line 652: fnd_message.raise_error;

648: --
649: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
650: fnd_message.set_token('FIELD','p_add_rmv_cvg_cd');
651: fnd_message.set_token('TYPE','BEN_ADD_RMV');
652: fnd_message.raise_error;
653: --
654: end if;
655: --
656: end if;

Line 728: fnd_message.set_name('PAY','PGM_DPNT_DSGN_NOT_O_R');

724: close chk_dpnt_dsgn;
725: --
726: -- raise error
727: --
728: fnd_message.set_name('PAY','PGM_DPNT_DSGN_NOT_O_R');
729: fnd_message.raise_error;
730: --
731: end if;
732: --

Line 729: fnd_message.raise_error;

725: --
726: -- raise error
727: --
728: fnd_message.set_name('PAY','PGM_DPNT_DSGN_NOT_O_R');
729: fnd_message.raise_error;
730: --
731: end if;
732: --
733: close chk_dpnt_dsgn;

Line 806: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');

802: p_effective_date => p_effective_date) then
803: --
804: -- raise error as does not exist as lookup
805: --
806: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
807: fnd_message.set_token('FIELD','p_ler_chg_dpnt_cvg_cd');
808: fnd_message.set_token('TYPE','BEN_LER_CHG_DPNT_CVG');
809: fnd_message.raise_error;
810: --

Line 807: fnd_message.set_token('FIELD','p_ler_chg_dpnt_cvg_cd');

803: --
804: -- raise error as does not exist as lookup
805: --
806: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
807: fnd_message.set_token('FIELD','p_ler_chg_dpnt_cvg_cd');
808: fnd_message.set_token('TYPE','BEN_LER_CHG_DPNT_CVG');
809: fnd_message.raise_error;
810: --
811: end if;

Line 808: fnd_message.set_token('TYPE','BEN_LER_CHG_DPNT_CVG');

804: -- raise error as does not exist as lookup
805: --
806: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
807: fnd_message.set_token('FIELD','p_ler_chg_dpnt_cvg_cd');
808: fnd_message.set_token('TYPE','BEN_LER_CHG_DPNT_CVG');
809: fnd_message.raise_error;
810: --
811: end if;
812: --

Line 809: fnd_message.raise_error;

805: --
806: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
807: fnd_message.set_token('FIELD','p_ler_chg_dpnt_cvg_cd');
808: fnd_message.set_token('TYPE','BEN_LER_CHG_DPNT_CVG');
809: fnd_message.raise_error;
810: --
811: end if;
812: --
813: end if;

Line 820: fnd_message.set_name('BEN','BEN_92513_DPNDNT_CVRG_DT_NULL');

816: /*
817: if (p_ler_chg_dpnt_cvg_cd is not null) and
818: (p_cvg_eff_strt_cd is null or p_cvg_eff_end_cd is null) then
819:
820: fnd_message.set_name('BEN','BEN_92513_DPNDNT_CVRG_DT_NULL');
821: fnd_message.raise_error;
822: end if;
823: */
824: --

Line 821: fnd_message.raise_error;

817: if (p_ler_chg_dpnt_cvg_cd is not null) and
818: (p_cvg_eff_strt_cd is null or p_cvg_eff_end_cd is null) then
819:
820: fnd_message.set_name('BEN','BEN_92513_DPNDNT_CVRG_DT_NULL');
821: fnd_message.raise_error;
822: end if;
823: */
824: --
825: if (p_ler_chg_dpnt_cvg_cd is null) and

Line 828: fnd_message.set_name('BEN','BEN_92514_CHNG_DPNDNT_CVG_RQD');

824: --
825: if (p_ler_chg_dpnt_cvg_cd is null) and
826: (p_cvg_eff_strt_cd is not null or p_cvg_eff_end_cd is not null) then
827: --null;
828: fnd_message.set_name('BEN','BEN_92514_CHNG_DPNDNT_CVG_RQD');
829: fnd_message.raise_error;
830: end if;
831:
832: --

Line 829: fnd_message.raise_error;

825: if (p_ler_chg_dpnt_cvg_cd is null) and
826: (p_cvg_eff_strt_cd is not null or p_cvg_eff_end_cd is not null) then
827: --null;
828: fnd_message.set_name('BEN','BEN_92514_CHNG_DPNDNT_CVG_RQD');
829: fnd_message.raise_error;
830: end if;
831:
832: --
833: hr_utility.set_location('Leaving:'||l_proc,10);

Line 894: fnd_message.set_name('BEN','BEN_91623_CD_RL_1');

890: or not l_api_updating) then
891: --
892: if (p_cvg_eff_strt_cd = 'RL' and p_cvg_eff_strt_rl is null) then
893: --
894: fnd_message.set_name('BEN','BEN_91623_CD_RL_1');
895: fnd_message.raise_error;
896: -- please word this message like 'If you choose a Coverage Start Code of "Rule",
897: -- you must choose a Coverage Start Rule.'
898: end if;

Line 895: fnd_message.raise_error;

891: --
892: if (p_cvg_eff_strt_cd = 'RL' and p_cvg_eff_strt_rl is null) then
893: --
894: fnd_message.set_name('BEN','BEN_91623_CD_RL_1');
895: fnd_message.raise_error;
896: -- please word this message like 'If you choose a Coverage Start Code of "Rule",
897: -- you must choose a Coverage Start Rule.'
898: end if;
899: --

Line 902: fnd_message.set_name('BEN','BEN_91624_CD_RL_2');

898: end if;
899: --
900: if nvl(p_cvg_eff_strt_cd,hr_api.g_varchar2) <> 'RL' and p_cvg_eff_strt_rl is not null then
901: --
902: fnd_message.set_name('BEN','BEN_91624_CD_RL_2');
903: fnd_message.raise_error;
904: end if;
905: --
906: end if;

Line 903: fnd_message.raise_error;

899: --
900: if nvl(p_cvg_eff_strt_cd,hr_api.g_varchar2) <> 'RL' and p_cvg_eff_strt_rl is not null then
901: --
902: fnd_message.set_name('BEN','BEN_91624_CD_RL_2');
903: fnd_message.raise_error;
904: end if;
905: --
906: end if;
907: --

Line 969: fnd_message.set_name('BEN','BEN_91623_CD_RL_1');

965: or not l_api_updating) then
966: --
967: if (p_cvg_eff_end_cd = 'RL' and p_cvg_eff_end_rl is null) then
968: --
969: fnd_message.set_name('BEN','BEN_91623_CD_RL_1');
970: fnd_message.raise_error;
971: -- please word this message like 'If you choose a Coverage Start Code of "Rule",
972: -- you must choose a Coverage Start Rule.'
973: end if;

Line 970: fnd_message.raise_error;

966: --
967: if (p_cvg_eff_end_cd = 'RL' and p_cvg_eff_end_rl is null) then
968: --
969: fnd_message.set_name('BEN','BEN_91623_CD_RL_1');
970: fnd_message.raise_error;
971: -- please word this message like 'If you choose a Coverage Start Code of "Rule",
972: -- you must choose a Coverage Start Rule.'
973: end if;
974: --

Line 977: fnd_message.set_name('BEN','BEN_91624_CD_RL_2');

973: end if;
974: --
975: if nvl(p_cvg_eff_end_cd,hr_api.g_varchar2) <> 'RL' and p_cvg_eff_end_rl is not null then
976: --
977: fnd_message.set_name('BEN','BEN_91624_CD_RL_2');
978: fnd_message.raise_error;
979: -- please word this message like 'If you choose a Coverage Start Rule,
980: -- you must choose a Coverage Start Code of "Rule".'
981: end if;

Line 978: fnd_message.raise_error;

974: --
975: if nvl(p_cvg_eff_end_cd,hr_api.g_varchar2) <> 'RL' and p_cvg_eff_end_rl is not null then
976: --
977: fnd_message.set_name('BEN','BEN_91624_CD_RL_2');
978: fnd_message.raise_error;
979: -- please word this message like 'If you choose a Coverage Start Rule,
980: -- you must choose a Coverage Start Code of "Rule".'
981: end if;
982: --

Line 1046: fnd_message.set_name('BEN','BEN_91623_CD_RL_1');

1042: or not l_api_updating) then
1043: --
1044: if (p_ler_chg_dpnt_cvg_cd = 'RL' and p_ler_chg_dpnt_cvg_rl is null) then
1045: --
1046: fnd_message.set_name('BEN','BEN_91623_CD_RL_1');
1047: fnd_message.raise_error;
1048: -- please word this message like 'If you choose a Coverage Start Code of "Rule",
1049: -- you must choose a Coverage Start Rule.'
1050: end if;

Line 1047: fnd_message.raise_error;

1043: --
1044: if (p_ler_chg_dpnt_cvg_cd = 'RL' and p_ler_chg_dpnt_cvg_rl is null) then
1045: --
1046: fnd_message.set_name('BEN','BEN_91623_CD_RL_1');
1047: fnd_message.raise_error;
1048: -- please word this message like 'If you choose a Coverage Start Code of "Rule",
1049: -- you must choose a Coverage Start Rule.'
1050: end if;
1051: --

Line 1054: fnd_message.set_name('BEN','BEN_91624_CD_RL_2');

1050: end if;
1051: --
1052: if nvl(p_ler_chg_dpnt_cvg_cd,hr_api.g_varchar2) <> 'RL' and p_ler_chg_dpnt_cvg_rl is not null then
1053: --
1054: fnd_message.set_name('BEN','BEN_91624_CD_RL_2');
1055: fnd_message.raise_error;
1056: -- please word this message like 'If you choose a Coverage Start Rule,
1057: -- you must choose a Coverage Start Code of "Rule".'
1058: end if;

Line 1055: fnd_message.raise_error;

1051: --
1052: if nvl(p_ler_chg_dpnt_cvg_cd,hr_api.g_varchar2) <> 'RL' and p_ler_chg_dpnt_cvg_rl is not null then
1053: --
1054: fnd_message.set_name('BEN','BEN_91624_CD_RL_2');
1055: fnd_message.raise_error;
1056: -- please word this message like 'If you choose a Coverage Start Rule,
1057: -- you must choose a Coverage Start Code of "Rule".'
1058: end if;
1059: --

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

1220: --
1221: -- An unhandled or unexpected error has occurred which
1222: -- we must report
1223: --
1224: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1225: fnd_message.set_token('PROCEDURE', l_proc);
1226: fnd_message.set_token('STEP','15');
1227: fnd_message.raise_error;
1228: End dt_update_validate;

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

1221: -- An unhandled or unexpected error has occurred which
1222: -- we must report
1223: --
1224: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1225: fnd_message.set_token('PROCEDURE', l_proc);
1226: fnd_message.set_token('STEP','15');
1227: fnd_message.raise_error;
1228: End dt_update_validate;
1229: --

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

1222: -- we must report
1223: --
1224: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1225: fnd_message.set_token('PROCEDURE', l_proc);
1226: fnd_message.set_token('STEP','15');
1227: fnd_message.raise_error;
1228: End dt_update_validate;
1229: --
1230: -- ----------------------------------------------------------------------------

Line 1227: fnd_message.raise_error;

1223: --
1224: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1225: fnd_message.set_token('PROCEDURE', l_proc);
1226: fnd_message.set_token('STEP','15');
1227: fnd_message.raise_error;
1228: End dt_update_validate;
1229: --
1230: -- ----------------------------------------------------------------------------
1231: -- |--------------------------< dt_delete_validate >--------------------------|

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

1330: --
1331: -- An unhandled or unexpected error has occurred which
1332: -- we must report
1333: --
1334: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1335: fnd_message.set_token('PROCEDURE', l_proc);
1336: fnd_message.set_token('STEP','15');
1337: fnd_message.raise_error;
1338: End dt_delete_validate;

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

1331: -- An unhandled or unexpected error has occurred which
1332: -- we must report
1333: --
1334: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1335: fnd_message.set_token('PROCEDURE', l_proc);
1336: fnd_message.set_token('STEP','15');
1337: fnd_message.raise_error;
1338: End dt_delete_validate;
1339: --

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

1332: -- we must report
1333: --
1334: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1335: fnd_message.set_token('PROCEDURE', l_proc);
1336: fnd_message.set_token('STEP','15');
1337: fnd_message.raise_error;
1338: End dt_delete_validate;
1339: --
1340: -- ----------------------------------------------------------------------------

Line 1337: fnd_message.raise_error;

1333: --
1334: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1335: fnd_message.set_token('PROCEDURE', l_proc);
1336: fnd_message.set_token('STEP','15');
1337: fnd_message.raise_error;
1338: End dt_delete_validate;
1339: --
1340: -- ----------------------------------------------------------------------------
1341: -- |---------------------------< insert_validate >----------------------------|

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

1654: close csr_leg_code;
1655: --
1656: -- The primary key is invalid therefore we must error
1657: --
1658: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1659: fnd_message.raise_error;
1660: --
1661: end if;
1662: --

Line 1659: fnd_message.raise_error;

1655: --
1656: -- The primary key is invalid therefore we must error
1657: --
1658: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1659: fnd_message.raise_error;
1660: --
1661: end if;
1662: --
1663: close csr_leg_code;