DBA Data[Home] [Help]

APPS.BEN_XRC_BUS dependencies on FND_MESSAGE

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

98: close csr_sec_grp;
99: --
100: -- The primary key is invalid therefore we must error
101: --
102: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
103: fnd_message.raise_error;
104: --
105: end if;
106: close csr_sec_grp;

Line 103: fnd_message.raise_error;

99: --
100: -- The primary key is invalid therefore we must error
101: --
102: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
103: fnd_message.raise_error;
104: --
105: end if;
106: close csr_sec_grp;
107: --

Line 235: fnd_message.set_name('BEN','BEN_91783_NAME_NULL');

231: Begin
232: hr_utility.set_location('Entering:'||l_proc, 5);
233: --
234: if p_name is null then
235: fnd_message.set_name('BEN','BEN_91783_NAME_NULL');
236: fnd_message.raise_error;
237: end if;
238: open c1;
239: fetch c1 into l_dummy;

Line 236: fnd_message.raise_error;

232: hr_utility.set_location('Entering:'||l_proc, 5);
233: --
234: if p_name is null then
235: fnd_message.set_name('BEN','BEN_91783_NAME_NULL');
236: fnd_message.raise_error;
237: end if;
238: open c1;
239: fetch c1 into l_dummy;
240: if c1%found then

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

238: open c1;
239: fetch c1 into l_dummy;
240: if c1%found then
241: close c1;
242: fnd_message.set_name('BEN','BEN_91009_NAME_NOT_UNIQUE');
243: fnd_message.raise_error;
244: end if;
245: --
246: hr_utility.set_location('Leaving:'||l_proc, 15);

Line 243: fnd_message.raise_error;

239: fetch c1 into l_dummy;
240: if c1%found then
241: close c1;
242: fnd_message.set_name('BEN','BEN_91009_NAME_NOT_UNIQUE');
243: fnd_message.raise_error;
244: end if;
245: --
246: hr_utility.set_location('Leaving:'||l_proc, 15);
247: End chk_name_unique;

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

306: --
307: -- raise error as does not exist as lookup
308: --
309: --
310: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
311: fnd_message.set_token('FIELD','p_rcd_type_cd');
312: fnd_message.set_token('TYPE','BEN_EXT_RCD_TYP');
313: fnd_message.raise_error;
314: --

Line 311: fnd_message.set_token('FIELD','p_rcd_type_cd');

307: -- raise error as does not exist as lookup
308: --
309: --
310: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
311: fnd_message.set_token('FIELD','p_rcd_type_cd');
312: fnd_message.set_token('TYPE','BEN_EXT_RCD_TYP');
313: fnd_message.raise_error;
314: --
315: end if;

Line 312: fnd_message.set_token('TYPE','BEN_EXT_RCD_TYP');

308: --
309: --
310: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
311: fnd_message.set_token('FIELD','p_rcd_type_cd');
312: fnd_message.set_token('TYPE','BEN_EXT_RCD_TYP');
313: fnd_message.raise_error;
314: --
315: end if;
316: else

Line 313: fnd_message.raise_error;

309: --
310: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
311: fnd_message.set_token('FIELD','p_rcd_type_cd');
312: fnd_message.set_token('TYPE','BEN_EXT_RCD_TYP');
313: fnd_message.raise_error;
314: --
315: end if;
316: else
317: /* BG is null, so alternative call is required */

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

322: --
323: -- raise error as does not exist as lookup
324: --
325: --
326: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
327: fnd_message.set_token('FIELD','p_rcd_type_cd');
328: fnd_message.set_token('TYPE','BEN_EXT_RCD_TYP');
329: fnd_message.raise_error;
330: --

Line 327: fnd_message.set_token('FIELD','p_rcd_type_cd');

323: -- raise error as does not exist as lookup
324: --
325: --
326: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
327: fnd_message.set_token('FIELD','p_rcd_type_cd');
328: fnd_message.set_token('TYPE','BEN_EXT_RCD_TYP');
329: fnd_message.raise_error;
330: --
331: end if;

Line 328: fnd_message.set_token('TYPE','BEN_EXT_RCD_TYP');

324: --
325: --
326: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
327: fnd_message.set_token('FIELD','p_rcd_type_cd');
328: fnd_message.set_token('TYPE','BEN_EXT_RCD_TYP');
329: fnd_message.raise_error;
330: --
331: end if;
332: end if;

Line 329: fnd_message.raise_error;

325: --
326: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
327: fnd_message.set_token('FIELD','p_rcd_type_cd');
328: fnd_message.set_token('TYPE','BEN_EXT_RCD_TYP');
329: fnd_message.raise_error;
330: --
331: end if;
332: end if;
333: --

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

397: --
398: -- raise error as does not exist as lookup
399: --
400: --
401: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
402: fnd_message.set_token('FIELD','p_low_lvl_cd');
403: fnd_message.set_token('TYPE','BEN_EXT_LVL');
404: fnd_message.raise_error;
405: --

Line 402: fnd_message.set_token('FIELD','p_low_lvl_cd');

398: -- raise error as does not exist as lookup
399: --
400: --
401: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
402: fnd_message.set_token('FIELD','p_low_lvl_cd');
403: fnd_message.set_token('TYPE','BEN_EXT_LVL');
404: fnd_message.raise_error;
405: --
406: end if;

Line 403: fnd_message.set_token('TYPE','BEN_EXT_LVL');

399: --
400: --
401: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
402: fnd_message.set_token('FIELD','p_low_lvl_cd');
403: fnd_message.set_token('TYPE','BEN_EXT_LVL');
404: fnd_message.raise_error;
405: --
406: end if;
407: else

Line 404: fnd_message.raise_error;

400: --
401: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
402: fnd_message.set_token('FIELD','p_low_lvl_cd');
403: fnd_message.set_token('TYPE','BEN_EXT_LVL');
404: fnd_message.raise_error;
405: --
406: end if;
407: else
408: /* BG is null, so alternative call is required */

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

413: --
414: -- raise error as does not exist as lookup
415: --
416: --
417: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
418: fnd_message.set_token('FIELD','p_low_lvl_cd');
419: fnd_message.set_token('TYPE','BEN_EXT_LVL');
420: fnd_message.raise_error;
421: --

Line 418: fnd_message.set_token('FIELD','p_low_lvl_cd');

414: -- raise error as does not exist as lookup
415: --
416: --
417: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
418: fnd_message.set_token('FIELD','p_low_lvl_cd');
419: fnd_message.set_token('TYPE','BEN_EXT_LVL');
420: fnd_message.raise_error;
421: --
422: end if;

Line 419: fnd_message.set_token('TYPE','BEN_EXT_LVL');

415: --
416: --
417: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
418: fnd_message.set_token('FIELD','p_low_lvl_cd');
419: fnd_message.set_token('TYPE','BEN_EXT_LVL');
420: fnd_message.raise_error;
421: --
422: end if;
423: end if;

Line 420: fnd_message.raise_error;

416: --
417: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
418: fnd_message.set_token('FIELD','p_low_lvl_cd');
419: fnd_message.set_token('TYPE','BEN_EXT_LVL');
420: fnd_message.raise_error;
421: --
422: end if;
423: end if;
424: --

Line 490: fnd_message.set_name('BEN','BEN_92198_CHK_RCD_TYP');

486: loop
487: if r1.data_elmt_typ_cd in ('D','F') then
488: if r1.alwd_in_rcd_cd in ('D','H','T') then
489: if p_rcd_type_cd <> r1.alwd_in_rcd_cd then
490: fnd_message.set_name('BEN','BEN_92198_CHK_RCD_TYP');
491: fnd_message.raise_error;
492: end if;
493: elsif r1.alwd_in_rcd_cd = 'B' then
494: if p_rcd_type_cd not in ('H','T','L') then

Line 491: fnd_message.raise_error;

487: if r1.data_elmt_typ_cd in ('D','F') then
488: if r1.alwd_in_rcd_cd in ('D','H','T') then
489: if p_rcd_type_cd <> r1.alwd_in_rcd_cd then
490: fnd_message.set_name('BEN','BEN_92198_CHK_RCD_TYP');
491: fnd_message.raise_error;
492: end if;
493: elsif r1.alwd_in_rcd_cd = 'B' then
494: if p_rcd_type_cd not in ('H','T','L') then
495: fnd_message.set_name('BEN','BEN_92198_CHK_RCD_TYP');

Line 495: fnd_message.set_name('BEN','BEN_92198_CHK_RCD_TYP');

491: fnd_message.raise_error;
492: end if;
493: elsif r1.alwd_in_rcd_cd = 'B' then
494: if p_rcd_type_cd not in ('H','T','L') then
495: fnd_message.set_name('BEN','BEN_92198_CHK_RCD_TYP');
496: fnd_message.raise_error;
497: end if;
498: end if;
499: elsif r1.data_elmt_typ_cd = 'R' then

Line 496: fnd_message.raise_error;

492: end if;
493: elsif r1.alwd_in_rcd_cd = 'B' then
494: if p_rcd_type_cd not in ('H','T','L') then
495: fnd_message.set_name('BEN','BEN_92198_CHK_RCD_TYP');
496: fnd_message.raise_error;
497: end if;
498: end if;
499: elsif r1.data_elmt_typ_cd = 'R' then
500: if p_rcd_type_cd <> 'D' then

Line 501: fnd_message.set_name('BEN','BEN_92198_CHK_RCD_TYP');

497: end if;
498: end if;
499: elsif r1.data_elmt_typ_cd = 'R' then
500: if p_rcd_type_cd <> 'D' then
501: fnd_message.set_name('BEN','BEN_92198_CHK_RCD_TYP');
502: fnd_message.raise_error;
503: end if;
504: elsif r1.data_elmt_typ_cd = 'T' then
505: if p_rcd_type_cd not in ('H','T', 'L') then

Line 502: fnd_message.raise_error;

498: end if;
499: elsif r1.data_elmt_typ_cd = 'R' then
500: if p_rcd_type_cd <> 'D' then
501: fnd_message.set_name('BEN','BEN_92198_CHK_RCD_TYP');
502: fnd_message.raise_error;
503: end if;
504: elsif r1.data_elmt_typ_cd = 'T' then
505: if p_rcd_type_cd not in ('H','T', 'L') then
506: fnd_message.set_name('BEN','BEN_92198_CHK_RCD_TYP');

Line 506: fnd_message.set_name('BEN','BEN_92198_CHK_RCD_TYP');

502: fnd_message.raise_error;
503: end if;
504: elsif r1.data_elmt_typ_cd = 'T' then
505: if p_rcd_type_cd not in ('H','T', 'L') then
506: fnd_message.set_name('BEN','BEN_92198_CHK_RCD_TYP');
507: fnd_message.raise_error;
508: end if;
509: end if;
510: end loop;

Line 507: fnd_message.raise_error;

503: end if;
504: elsif r1.data_elmt_typ_cd = 'T' then
505: if p_rcd_type_cd not in ('H','T', 'L') then
506: fnd_message.set_name('BEN','BEN_92198_CHK_RCD_TYP');
507: fnd_message.raise_error;
508: end if;
509: end if;
510: end loop;
511: --

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

677: close csr_leg_code;
678: --
679: -- The primary key is invalid therefore we must error
680: --
681: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
682: fnd_message.raise_error;
683: --
684: end if;
685: --

Line 682: fnd_message.raise_error;

678: --
679: -- The primary key is invalid therefore we must error
680: --
681: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
682: fnd_message.raise_error;
683: --
684: end if;
685: --
686: close csr_leg_code;