DBA Data[Home] [Help]

APPS.BEN_PTY_BUS dependencies on FND_MESSAGE

Line 200: fnd_message.set_name('BEN','BEN_92593_DATA_NULL');

196: (p_pl_pcp_typ_id => p_pl_pcp_typ_id,
197: p_object_version_number => p_object_version_number);
198: --
199: if p_pcp_typ_cd is null then
200: fnd_message.set_name('BEN','BEN_92593_DATA_NULL');
201: fnd_message.set_token('FIELD', 'PCP Type');
202: fnd_message.raise_error;
203: end if;
204: if (l_api_updating

Line 201: fnd_message.set_token('FIELD', 'PCP Type');

197: p_object_version_number => p_object_version_number);
198: --
199: if p_pcp_typ_cd is null then
200: fnd_message.set_name('BEN','BEN_92593_DATA_NULL');
201: fnd_message.set_token('FIELD', 'PCP Type');
202: fnd_message.raise_error;
203: end if;
204: if (l_api_updating
205: and p_pcp_typ_cd <> nvl(ben_pty_shd.g_old_rec.pcp_typ_cd,hr_api.g_varchar2)

Line 202: fnd_message.raise_error;

198: --
199: if p_pcp_typ_cd is null then
200: fnd_message.set_name('BEN','BEN_92593_DATA_NULL');
201: fnd_message.set_token('FIELD', 'PCP Type');
202: fnd_message.raise_error;
203: end if;
204: if (l_api_updating
205: and p_pcp_typ_cd <> nvl(ben_pty_shd.g_old_rec.pcp_typ_cd,hr_api.g_varchar2)
206: or not l_api_updating)

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

214: p_effective_date => p_effective_date) then
215: --
216: -- raise error as does not exist as lookup
217: --
218: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
219: fnd_message.set_token('FIELD','p_pcp_typ_cd');
220: fnd_message.set_token('TYPE','BEN_PCP_TYP_CD');
221: fnd_message.raise_error;
222: --

Line 219: fnd_message.set_token('FIELD','p_pcp_typ_cd');

215: --
216: -- raise error as does not exist as lookup
217: --
218: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
219: fnd_message.set_token('FIELD','p_pcp_typ_cd');
220: fnd_message.set_token('TYPE','BEN_PCP_TYP_CD');
221: fnd_message.raise_error;
222: --
223: end if;

Line 220: fnd_message.set_token('TYPE','BEN_PCP_TYP_CD');

216: -- raise error as does not exist as lookup
217: --
218: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
219: fnd_message.set_token('FIELD','p_pcp_typ_cd');
220: fnd_message.set_token('TYPE','BEN_PCP_TYP_CD');
221: fnd_message.raise_error;
222: --
223: end if;
224: --

Line 221: fnd_message.raise_error;

217: --
218: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
219: fnd_message.set_token('FIELD','p_pcp_typ_cd');
220: fnd_message.set_token('TYPE','BEN_PCP_TYP_CD');
221: fnd_message.raise_error;
222: --
223: end if;
224: --
225: end if;

Line 278: fnd_message.set_name('BEN','BEN_92593_DATA_NULL');

274: p_object_version_number => p_object_version_number);
275: --
276: if p_gndr_alwd_cd is null and p_min_age is null and p_max_age is null
277: then
278: fnd_message.set_name('BEN','BEN_92593_DATA_NULL');
279: fnd_message.set_token('FIELD', 'Maximum Age or Minimum Age or Gender');
280: fnd_message.raise_error;
281: end if;
282: if (l_api_updating

Line 279: fnd_message.set_token('FIELD', 'Maximum Age or Minimum Age or Gender');

275: --
276: if p_gndr_alwd_cd is null and p_min_age is null and p_max_age is null
277: then
278: fnd_message.set_name('BEN','BEN_92593_DATA_NULL');
279: fnd_message.set_token('FIELD', 'Maximum Age or Minimum Age or Gender');
280: fnd_message.raise_error;
281: end if;
282: if (l_api_updating
283: and p_gndr_alwd_cd <> nvl(ben_pty_shd.g_old_rec.gndr_alwd_cd,hr_api.g_varchar2)

Line 280: fnd_message.raise_error;

276: if p_gndr_alwd_cd is null and p_min_age is null and p_max_age is null
277: then
278: fnd_message.set_name('BEN','BEN_92593_DATA_NULL');
279: fnd_message.set_token('FIELD', 'Maximum Age or Minimum Age or Gender');
280: fnd_message.raise_error;
281: end if;
282: if (l_api_updating
283: and p_gndr_alwd_cd <> nvl(ben_pty_shd.g_old_rec.gndr_alwd_cd,hr_api.g_varchar2)
284: or not l_api_updating)

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

292: p_effective_date => p_effective_date) then
293: --
294: -- raise error as does not exist as lookup
295: --
296: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
297: fnd_message.set_token('FIELD','p_gndr_alwd_cd');
298: fnd_message.set_token('TYPE','SEX');
299: fnd_message.raise_error;
300: --

Line 297: fnd_message.set_token('FIELD','p_gndr_alwd_cd');

293: --
294: -- raise error as does not exist as lookup
295: --
296: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
297: fnd_message.set_token('FIELD','p_gndr_alwd_cd');
298: fnd_message.set_token('TYPE','SEX');
299: fnd_message.raise_error;
300: --
301: end if;

Line 298: fnd_message.set_token('TYPE','SEX');

294: -- raise error as does not exist as lookup
295: --
296: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
297: fnd_message.set_token('FIELD','p_gndr_alwd_cd');
298: fnd_message.set_token('TYPE','SEX');
299: fnd_message.raise_error;
300: --
301: end if;
302: --

Line 299: fnd_message.raise_error;

295: --
296: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
297: fnd_message.set_token('FIELD','p_gndr_alwd_cd');
298: fnd_message.set_token('TYPE','SEX');
299: fnd_message.raise_error;
300: --
301: end if;
302: --
303: end if;

Line 354: fnd_message.set_name('BEN','BEN_92561_RPSTRY_FLG');

350: --- when the rate is imputing chek the plan in imputing
351: open c1;
352: fetch c1 into l_dummy;
353: if c1%found and l_dummy <> 'Y' then
354: fnd_message.set_name('BEN','BEN_92561_RPSTRY_FLG');
355: fnd_message.raise_error;
356: end if;
357: close c1;
358:

Line 355: fnd_message.raise_error;

351: open c1;
352: fetch c1 into l_dummy;
353: if c1%found and l_dummy <> 'Y' then
354: fnd_message.set_name('BEN','BEN_92561_RPSTRY_FLG');
355: fnd_message.raise_error;
356: end if;
357: close c1;
358:
359: hr_utility.set_location('Leaving:'||l_proc, 15);

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

401: close csr_sec_grp;
402: --
403: -- The primary key is invalid therefore we must error
404: --
405: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
406: fnd_message.raise_error;
407: --
408: end if;
409: close csr_sec_grp;

Line 406: fnd_message.raise_error;

402: --
403: -- The primary key is invalid therefore we must error
404: --
405: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
406: fnd_message.raise_error;
407: --
408: end if;
409: close csr_sec_grp;
410: --

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

474: --
475: -- The primary key is invalid therefore we must error
476: --
477: close csr_leg_code;
478: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
479: fnd_message.raise_error;
480: end if;
481: hr_utility.set_location(l_proc,30);
482: --

Line 479: fnd_message.raise_error;

475: -- The primary key is invalid therefore we must error
476: --
477: close csr_leg_code;
478: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
479: fnd_message.raise_error;
480: end if;
481: hr_utility.set_location(l_proc,30);
482: --
483: -- Set the global variables so the values are

Line 715: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

711: IF NOT ben_pty_shd.api_updating
712: (p_pl_pcp_typ_id => p_rec.pl_pcp_typ_id
713: ,p_object_version_number => p_rec.object_version_number
714: ) THEN
715: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
716: fnd_message.set_token('PROCEDURE ', l_proc);
717: fnd_message.set_token('STEP ', '5');
718: fnd_message.raise_error;
719: END IF;

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

712: (p_pl_pcp_typ_id => p_rec.pl_pcp_typ_id
713: ,p_object_version_number => p_rec.object_version_number
714: ) THEN
715: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
716: fnd_message.set_token('PROCEDURE ', l_proc);
717: fnd_message.set_token('STEP ', '5');
718: fnd_message.raise_error;
719: END IF;
720: --

Line 717: fnd_message.set_token('STEP ', '5');

713: ,p_object_version_number => p_rec.object_version_number
714: ) THEN
715: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
716: fnd_message.set_token('PROCEDURE ', l_proc);
717: fnd_message.set_token('STEP ', '5');
718: fnd_message.raise_error;
719: END IF;
720: --
721: -- EDIT_HERE: Add checks to ensure non-updateable args have

Line 718: fnd_message.raise_error;

714: ) THEN
715: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
716: fnd_message.set_token('PROCEDURE ', l_proc);
717: fnd_message.set_token('STEP ', '5');
718: fnd_message.raise_error;
719: END IF;
720: --
721: -- EDIT_HERE: Add checks to ensure non-updateable args have
722: -- not been updated.