DBA Data[Home] [Help]

APPS.BEN_PDP_BUS dependencies on FND_MESSAGE

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

127: p_effective_date => p_effective_date) then
128: --
129: -- raise error as does not exist as lookup
130: --
131: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
132: fnd_message.set_token('FIELD', p_ovrdn_flag);
133: fnd_message.set_token('TYPE','YES_NO');
134: fnd_message.raise_error;
135: --

Line 132: fnd_message.set_token('FIELD', p_ovrdn_flag);

128: --
129: -- raise error as does not exist as lookup
130: --
131: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
132: fnd_message.set_token('FIELD', p_ovrdn_flag);
133: fnd_message.set_token('TYPE','YES_NO');
134: fnd_message.raise_error;
135: --
136: end if;

Line 133: fnd_message.set_token('TYPE','YES_NO');

129: -- raise error as does not exist as lookup
130: --
131: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
132: fnd_message.set_token('FIELD', p_ovrdn_flag);
133: fnd_message.set_token('TYPE','YES_NO');
134: fnd_message.raise_error;
135: --
136: end if;
137: --

Line 134: fnd_message.raise_error;

130: --
131: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
132: fnd_message.set_token('FIELD', p_ovrdn_flag);
133: fnd_message.set_token('TYPE','YES_NO');
134: fnd_message.raise_error;
135: --
136: end if;
137: --
138: end if;

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

191: p_effective_date => p_effective_date) then
192: --
193: -- raise error as does not exist as lookup
194: --
195: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
196: fnd_message.set_token('FIELD', p_cvg_pndg_flag);
197: fnd_message.set_token('TYPE','YES_NO');
198: fnd_message.raise_error;
199: --

Line 196: fnd_message.set_token('FIELD', p_cvg_pndg_flag);

192: --
193: -- raise error as does not exist as lookup
194: --
195: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
196: fnd_message.set_token('FIELD', p_cvg_pndg_flag);
197: fnd_message.set_token('TYPE','YES_NO');
198: fnd_message.raise_error;
199: --
200: end if;

Line 197: fnd_message.set_token('TYPE','YES_NO');

193: -- raise error as does not exist as lookup
194: --
195: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
196: fnd_message.set_token('FIELD', p_cvg_pndg_flag);
197: fnd_message.set_token('TYPE','YES_NO');
198: fnd_message.raise_error;
199: --
200: end if;
201: --

Line 198: fnd_message.raise_error;

194: --
195: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
196: fnd_message.set_token('FIELD', p_cvg_pndg_flag);
197: fnd_message.set_token('TYPE','YES_NO');
198: fnd_message.raise_error;
199: --
200: end if;
201: --
202: end if;

Line 247: fnd_message.set_name('BEN', 'BEN_91649_CVG_STRT_THRU_DT');

243: p_cvg_strt_dt > p_cvg_thru_dt then
244: --
245: -- raise error as dates are out of seq
246: --
247: fnd_message.set_name('BEN', 'BEN_91649_CVG_STRT_THRU_DT');
248: fnd_message.raise_error;
249: --
250: --
251: end if;

Line 248: fnd_message.raise_error;

244: --
245: -- raise error as dates are out of seq
246: --
247: fnd_message.set_name('BEN', 'BEN_91649_CVG_STRT_THRU_DT');
248: fnd_message.raise_error;
249: --
250: --
251: end if;
252: --

Line 365: fnd_message.set_name('BEN', 'BEN_91651_DUP_CVRD_DPNT');

361: close c3;
362: --
363: -- raise error as this dependent already exists for this enrt rslt
364: --
365: fnd_message.set_name('BEN', 'BEN_91651_DUP_CVRD_DPNT');
366: fnd_message.raise_error;
367: --
368: end if;
369: close c3;

Line 366: fnd_message.raise_error;

362: --
363: -- raise error as this dependent already exists for this enrt rslt
364: --
365: fnd_message.set_name('BEN', 'BEN_91651_DUP_CVRD_DPNT');
366: fnd_message.raise_error;
367: --
368: end if;
369: close c3;
370: end if;

Line 706: fnd_message.set_name('BEN', 'BEN_91652_NO_CNTCT_RLSHP');

702: close info2_c;
703: --
704: -- raise error as there are no contact relationship
705: --
706: fnd_message.set_name('BEN', 'BEN_91652_NO_CNTCT_RLSHP');
707: fnd_message.raise_error;
708: --
709: else
710: -- Check if there are any requirements at all

Line 707: fnd_message.raise_error;

703: --
704: -- raise error as there are no contact relationship
705: --
706: fnd_message.set_name('BEN', 'BEN_91652_NO_CNTCT_RLSHP');
707: fnd_message.raise_error;
708: --
709: else
710: -- Check if there are any requirements at all
711: -- Check total max requirement is done as part of post-forms-commit

Line 789: fnd_message.set_name('BEN','BEN_92093_DPNT_ACTV_CRTORDR'); fnd_message.raise_error;

785: close c1;
786: --
787: -- raise error
788: --
789: fnd_message.set_name('BEN','BEN_92093_DPNT_ACTV_CRTORDR'); fnd_message.raise_error;
790: --
791: end if;
792: --
793: close c1;

Line 1076: fnd_message.set_name ('BEN', 'BEN_91470_PGM_NOT_FOUND');

1072: THEN
1073: --
1074: CLOSE c_pgm;
1075:
1076: fnd_message.set_name ('BEN', 'BEN_91470_PGM_NOT_FOUND');
1077: fnd_message.raise_error;
1078: --
1079: END IF;
1080: --

Line 1077: fnd_message.raise_error;

1073: --
1074: CLOSE c_pgm;
1075:
1076: fnd_message.set_name ('BEN', 'BEN_91470_PGM_NOT_FOUND');
1077: fnd_message.raise_error;
1078: --
1079: END IF;
1080: --
1081: CLOSE c_pgm;

Line 1121: fnd_message.set_name ('BEN', 'BEN_91471_MISSING_PLAN_TYPE');

1117: THEN
1118: --
1119: CLOSE c_ptip;
1120:
1121: fnd_message.set_name ('BEN', 'BEN_91471_MISSING_PLAN_TYPE');
1122: fnd_message.raise_error;
1123: --
1124: END IF;
1125: --

Line 1122: fnd_message.raise_error;

1118: --
1119: CLOSE c_ptip;
1120:
1121: fnd_message.set_name ('BEN', 'BEN_91471_MISSING_PLAN_TYPE');
1122: fnd_message.raise_error;
1123: --
1124: END IF;
1125: --
1126: CLOSE c_ptip;

Line 1142: fnd_message.set_name ('BEN', 'BEN_91472_PLAN_NOT_FOUND');

1138: THEN
1139: --
1140: CLOSE c_plan;
1141: --
1142: fnd_message.set_name ('BEN', 'BEN_91472_PLAN_NOT_FOUND');
1143: fnd_message.raise_error;
1144: --
1145: END IF;
1146: --

Line 1143: fnd_message.raise_error;

1139: --
1140: CLOSE c_plan;
1141: --
1142: fnd_message.set_name ('BEN', 'BEN_91472_PLAN_NOT_FOUND');
1143: fnd_message.raise_error;
1144: --
1145: END IF;
1146: --
1147: CLOSE c_plan;

Line 1174: fnd_message.set_name ('BEN', 'BEN_91472_PLAN_NOT_FOUND');

1170: THEN
1171: --
1172: CLOSE c_plan_flag;
1173: --
1174: fnd_message.set_name ('BEN', 'BEN_91472_PLAN_NOT_FOUND');
1175: fnd_message.raise_error;
1176: --
1177: END IF;
1178: --

Line 1175: fnd_message.raise_error;

1171: --
1172: CLOSE c_plan_flag;
1173: --
1174: fnd_message.set_name ('BEN', 'BEN_91472_PLAN_NOT_FOUND');
1175: fnd_message.raise_error;
1176: --
1177: END IF;
1178: --
1179: CLOSE c_plan_flag;

Line 1356: benutils.write(p_text=>fnd_message.get);

1352: fetch c_person_id into l_person_id;
1353: close c_person_id;
1354: --
1355: if p_cvg_strt_dt > p_cvg_thru_dt then
1356: benutils.write(p_text=>fnd_message.get);
1357: ben_warnings.load_warning
1358: (p_application_short_name => 'BEN'
1359: ,p_message_name => l_message_name
1360: ,p_parma => 'Dependent Coverage End Date' || ' ' || fnd_date.date_to_displaydate(p_cvg_thru_dt)

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

1464: --
1465: -- An unhandled or unexpected error has occurred which
1466: -- we must report
1467: --
1468: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1469: fnd_message.set_token('PROCEDURE', l_proc);
1470: fnd_message.set_token('STEP','15');
1471: fnd_message.raise_error;
1472: End dt_update_validate;

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

1465: -- An unhandled or unexpected error has occurred which
1466: -- we must report
1467: --
1468: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1469: fnd_message.set_token('PROCEDURE', l_proc);
1470: fnd_message.set_token('STEP','15');
1471: fnd_message.raise_error;
1472: End dt_update_validate;
1473: --

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

1466: -- we must report
1467: --
1468: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1469: fnd_message.set_token('PROCEDURE', l_proc);
1470: fnd_message.set_token('STEP','15');
1471: fnd_message.raise_error;
1472: End dt_update_validate;
1473: --
1474: -- ----------------------------------------------------------------------------

Line 1471: fnd_message.raise_error;

1467: --
1468: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1469: fnd_message.set_token('PROCEDURE', l_proc);
1470: fnd_message.set_token('STEP','15');
1471: fnd_message.raise_error;
1472: End dt_update_validate;
1473: --
1474: -- ----------------------------------------------------------------------------
1475: -- |--------------------------< dt_delete_validate >--------------------------|

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

1576: --
1577: -- An unhandled or unexpected error has occurred which
1578: -- we must report
1579: --
1580: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1581: fnd_message.set_token('PROCEDURE', l_proc);
1582: fnd_message.set_token('STEP','15');
1583: fnd_message.raise_error;
1584: End dt_delete_validate;

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

1577: -- An unhandled or unexpected error has occurred which
1578: -- we must report
1579: --
1580: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1581: fnd_message.set_token('PROCEDURE', l_proc);
1582: fnd_message.set_token('STEP','15');
1583: fnd_message.raise_error;
1584: End dt_delete_validate;
1585: --

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

1578: -- we must report
1579: --
1580: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1581: fnd_message.set_token('PROCEDURE', l_proc);
1582: fnd_message.set_token('STEP','15');
1583: fnd_message.raise_error;
1584: End dt_delete_validate;
1585: --
1586: -- ----------------------------------------------------------------------------

Line 1583: fnd_message.raise_error;

1579: --
1580: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1581: fnd_message.set_token('PROCEDURE', l_proc);
1582: fnd_message.set_token('STEP','15');
1583: fnd_message.raise_error;
1584: End dt_delete_validate;
1585: --
1586: -- ----------------------------------------------------------------------------
1587: -- |---------------------------< insert_validate >----------------------------|

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

1852: close csr_leg_code;
1853: --
1854: -- The primary key is invalid therefore we must error
1855: --
1856: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1857: fnd_message.raise_error;
1858: --
1859: end if;
1860: --

Line 1857: fnd_message.raise_error;

1853: --
1854: -- The primary key is invalid therefore we must error
1855: --
1856: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1857: fnd_message.raise_error;
1858: --
1859: end if;
1860: --
1861: close csr_leg_code;