DBA Data[Home] [Help]

APPS.BEN_XCT_BUS dependencies on FND_MESSAGE

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

50: close csr_sec_grp;
51: --
52: -- The primary key is invalid therefore we must error
53: --
54: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
55: fnd_message.raise_error;
56: --
57: end if;
58: close csr_sec_grp;

Line 55: fnd_message.raise_error;

51: --
52: -- The primary key is invalid therefore we must error
53: --
54: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
55: fnd_message.raise_error;
56: --
57: end if;
58: close csr_sec_grp;
59: --

Line 304: fnd_message.set_name('BEN','BEN_91900_CRIT_CD_NULL');

300: (p_ext_crit_typ_id => p_ext_crit_typ_id,
301: p_object_version_number => p_object_version_number);
302: --
303: if p_crit_typ_cd is null then
304: fnd_message.set_name('BEN','BEN_91900_CRIT_CD_NULL');
305: fnd_message.raise_error;
306: end if;
307: --
308: if (l_api_updating

Line 305: fnd_message.raise_error;

301: p_object_version_number => p_object_version_number);
302: --
303: if p_crit_typ_cd is null then
304: fnd_message.set_name('BEN','BEN_91900_CRIT_CD_NULL');
305: fnd_message.raise_error;
306: end if;
307: --
308: if (l_api_updating
309: and p_crit_typ_cd

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

321: p_effective_date => p_effective_date) then
322: --
323: -- raise error as does not exist as lookup
324: --
325: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
326: fnd_message.set_token('FIELD','p_crit_typ_cd');
327: fnd_message.set_name('TYPE','BEN_EXT_CRIT_TYP');
328: fnd_message.raise_error;
329: --

Line 326: fnd_message.set_token('FIELD','p_crit_typ_cd');

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

Line 327: fnd_message.set_name('TYPE','BEN_EXT_CRIT_TYP');

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

Line 328: fnd_message.raise_error;

324: --
325: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
326: fnd_message.set_token('FIELD','p_crit_typ_cd');
327: fnd_message.set_name('TYPE','BEN_EXT_CRIT_TYP');
328: fnd_message.raise_error;
329: --
330: end if;
331: else
332: /* BG is null, so alternative call is required */

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

336: p_effective_date => p_effective_date) then
337: --
338: -- raise error as does not exist as lookup
339: --
340: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
341: fnd_message.set_token('FIELD','p_crit_typ_cd');
342: fnd_message.set_name('TYPE','BEN_EXT_CRIT_TYP');
343: fnd_message.raise_error;
344: --

Line 341: fnd_message.set_token('FIELD','p_crit_typ_cd');

337: --
338: -- raise error as does not exist as lookup
339: --
340: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
341: fnd_message.set_token('FIELD','p_crit_typ_cd');
342: fnd_message.set_name('TYPE','BEN_EXT_CRIT_TYP');
343: fnd_message.raise_error;
344: --
345: end if;

Line 342: fnd_message.set_name('TYPE','BEN_EXT_CRIT_TYP');

338: -- raise error as does not exist as lookup
339: --
340: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
341: fnd_message.set_token('FIELD','p_crit_typ_cd');
342: fnd_message.set_name('TYPE','BEN_EXT_CRIT_TYP');
343: fnd_message.raise_error;
344: --
345: end if;
346: --

Line 343: fnd_message.raise_error;

339: --
340: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
341: fnd_message.set_token('FIELD','p_crit_typ_cd');
342: fnd_message.set_name('TYPE','BEN_EXT_CRIT_TYP');
343: fnd_message.raise_error;
344: --
345: end if;
346: --
347: end if; /* p_business_group_id is not null */

Line 418: fnd_message.set_name('BEN','BEN_91898_EXT_CRIT_TYP_UPD');

414: open c1;
415: fetch c1 into l_dummy;
416: if c1%found then
417: close c1;
418: fnd_message.set_name('BEN','BEN_91898_EXT_CRIT_TYP_UPD');
419: fnd_message.raise_error;
420: end if;
421: --
422: end if;

Line 419: fnd_message.raise_error;

415: fetch c1 into l_dummy;
416: if c1%found then
417: close c1;
418: fnd_message.set_name('BEN','BEN_91898_EXT_CRIT_TYP_UPD');
419: fnd_message.raise_error;
420: end if;
421: --
422: end if;
423: --

Line 481: fnd_message.set_name('BEN','BEN_91899_EXT_CRIT_TYP_EXISTS');

477: open c1;
478: fetch c1 into l_dummy;
479: if c1%found then
480: close c1;
481: fnd_message.set_name('BEN','BEN_91899_EXT_CRIT_TYP_EXISTS');
482: fnd_message.raise_error;
483: end if;
484: --
485: hr_utility.set_location('Leaving:'||l_proc, 15);

Line 482: fnd_message.raise_error;

478: fetch c1 into l_dummy;
479: if c1%found then
480: close c1;
481: fnd_message.set_name('BEN','BEN_91899_EXT_CRIT_TYP_EXISTS');
482: fnd_message.raise_error;
483: end if;
484: --
485: hr_utility.set_location('Leaving:'||l_proc, 15);
486: End chk_crit_cd_unique;

Line 534: fnd_message.set_name('BEN','BEN_92123_EXCLD_FLAG_NULL');

530: --
531: -- ensure that excld_flag is not null
532: --
533: if p_excld_flag is null then
534: fnd_message.set_name('BEN','BEN_92123_EXCLD_FLAG_NULL');
535: fnd_message.raise_error;
536: end if;
537: --
538: -- ensure that the excld_flag has a valid value

Line 535: fnd_message.raise_error;

531: -- ensure that excld_flag is not null
532: --
533: if p_excld_flag is null then
534: fnd_message.set_name('BEN','BEN_92123_EXCLD_FLAG_NULL');
535: fnd_message.raise_error;
536: end if;
537: --
538: -- ensure that the excld_flag has a valid value
539: --

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

553: p_effective_date => p_effective_date) then
554: --
555: -- raise error message
556: --
557: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
558: fnd_message.set_token('FIELD', 'p_excld_flag');
559: fnd_message.set_token('TYPE', 'YES_NO');
560: fnd_message.raise_error;
561: --

Line 558: fnd_message.set_token('FIELD', 'p_excld_flag');

554: --
555: -- raise error message
556: --
557: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
558: fnd_message.set_token('FIELD', 'p_excld_flag');
559: fnd_message.set_token('TYPE', 'YES_NO');
560: fnd_message.raise_error;
561: --
562: end if;

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

555: -- raise error message
556: --
557: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
558: fnd_message.set_token('FIELD', 'p_excld_flag');
559: fnd_message.set_token('TYPE', 'YES_NO');
560: fnd_message.raise_error;
561: --
562: end if;
563: else

Line 560: fnd_message.raise_error;

556: --
557: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
558: fnd_message.set_token('FIELD', 'p_excld_flag');
559: fnd_message.set_token('TYPE', 'YES_NO');
560: fnd_message.raise_error;
561: --
562: end if;
563: else
564: /* BG is null, so alternative call is required */

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

568: p_effective_date => p_effective_date) then
569: --
570: -- raise error message
571: --
572: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
573: fnd_message.set_token('FIELD', 'p_excld_flag');
574: fnd_message.set_token('TYPE', 'YES_NO');
575: fnd_message.raise_error;
576: --

Line 573: fnd_message.set_token('FIELD', 'p_excld_flag');

569: --
570: -- raise error message
571: --
572: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
573: fnd_message.set_token('FIELD', 'p_excld_flag');
574: fnd_message.set_token('TYPE', 'YES_NO');
575: fnd_message.raise_error;
576: --
577: end if;

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

570: -- raise error message
571: --
572: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
573: fnd_message.set_token('FIELD', 'p_excld_flag');
574: fnd_message.set_token('TYPE', 'YES_NO');
575: fnd_message.raise_error;
576: --
577: end if;
578: --

Line 575: fnd_message.raise_error;

571: --
572: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
573: fnd_message.set_token('FIELD', 'p_excld_flag');
574: fnd_message.set_token('TYPE', 'YES_NO');
575: fnd_message.raise_error;
576: --
577: end if;
578: --
579: end if; /* p_business_group_id is not null */

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

757: close csr_leg_code;
758: --
759: -- The primary key is invalid therefore we must error
760: --
761: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
762: fnd_message.raise_error;
763: --
764: end if;
765: --

Line 762: fnd_message.raise_error;

758: --
759: -- The primary key is invalid therefore we must error
760: --
761: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
762: fnd_message.raise_error;
763: --
764: end if;
765: --
766: close csr_leg_code;