DBA Data[Home] [Help]

APPS.BEN_CWG_BUS dependencies on FND_MESSAGE

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

59: close csr_sec_grp;
60: --
61: -- The primary key is invalid therefore we must error
62: --
63: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
64: hr_multi_message.add
65: (p_associated_column1
66: => nvl(p_associated_column1,'CWB_WKSHT_GRP_ID')
67: );

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

140: --
141: -- The primary key is invalid therefore we must error
142: --
143: close csr_leg_code;
144: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
145: fnd_message.raise_error;
146: end if;
147: hr_utility.set_location(l_proc,30);
148: --

Line 145: fnd_message.raise_error;

141: -- The primary key is invalid therefore we must error
142: --
143: close csr_leg_code;
144: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
145: fnd_message.raise_error;
146: end if;
147: hr_utility.set_location(l_proc,30);
148: --
149: -- Set the global variables so the values are

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

377: IF NOT ben_cwg_shd.api_updating
378: (p_cwb_wksht_grp_id => p_rec.cwb_wksht_grp_id
379: ,p_object_version_number => p_rec.object_version_number
380: ) THEN
381: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
382: fnd_message.set_token('PROCEDURE ', l_proc);
383: fnd_message.set_token('STEP ', '5');
384: fnd_message.raise_error;
385: END IF;

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

378: (p_cwb_wksht_grp_id => p_rec.cwb_wksht_grp_id
379: ,p_object_version_number => p_rec.object_version_number
380: ) THEN
381: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
382: fnd_message.set_token('PROCEDURE ', l_proc);
383: fnd_message.set_token('STEP ', '5');
384: fnd_message.raise_error;
385: END IF;
386: --

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

379: ,p_object_version_number => p_rec.object_version_number
380: ) THEN
381: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
382: fnd_message.set_token('PROCEDURE ', l_proc);
383: fnd_message.set_token('STEP ', '5');
384: fnd_message.raise_error;
385: END IF;
386: --
387: IF nvl(p_rec.business_group_id,hr_api.g_number) <>

Line 384: fnd_message.raise_error;

380: ) THEN
381: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
382: fnd_message.set_token('PROCEDURE ', l_proc);
383: fnd_message.set_token('STEP ', '5');
384: fnd_message.raise_error;
385: END IF;
386: --
387: IF nvl(p_rec.business_group_id,hr_api.g_number) <>
388: nvl(ben_cwg_shd.g_old_rec.business_group_id,hr_api.g_number) then

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

436: p_effective_date => p_effective_date) then
437: --
438: -- raise error as does not exist as lookup
439: --
440: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
441: fnd_message.set_token('FIELD', 'p_status_cd '||p_status_cd);
442: fnd_message.set_token('TYPE','BEN_CWG_STAT');
443: fnd_message.raise_error;
444: end if;

Line 441: fnd_message.set_token('FIELD', 'p_status_cd '||p_status_cd);

437: --
438: -- raise error as does not exist as lookup
439: --
440: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
441: fnd_message.set_token('FIELD', 'p_status_cd '||p_status_cd);
442: fnd_message.set_token('TYPE','BEN_CWG_STAT');
443: fnd_message.raise_error;
444: end if;
445: --

Line 442: fnd_message.set_token('TYPE','BEN_CWG_STAT');

438: -- raise error as does not exist as lookup
439: --
440: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
441: fnd_message.set_token('FIELD', 'p_status_cd '||p_status_cd);
442: fnd_message.set_token('TYPE','BEN_CWG_STAT');
443: fnd_message.raise_error;
444: end if;
445: --
446: end if;

Line 443: fnd_message.raise_error;

439: --
440: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
441: fnd_message.set_token('FIELD', 'p_status_cd '||p_status_cd);
442: fnd_message.set_token('TYPE','BEN_CWG_STAT');
443: fnd_message.raise_error;
444: end if;
445: --
446: end if;
447: --

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

481: p_effective_date => p_effective_date) then
482: --
483: -- raise error as does not exist as lookup
484: --
485: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
486: fnd_message.set_token('FIELD', 'p_hidden_cd');
487: fnd_message.set_token('VALUE', p_hidden_cd);
488: fnd_message.set_token('TYPE','BEN_WS_ACC');
489: fnd_message.raise_error;

Line 486: fnd_message.set_token('FIELD', 'p_hidden_cd');

482: --
483: -- raise error as does not exist as lookup
484: --
485: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
486: fnd_message.set_token('FIELD', 'p_hidden_cd');
487: fnd_message.set_token('VALUE', p_hidden_cd);
488: fnd_message.set_token('TYPE','BEN_WS_ACC');
489: fnd_message.raise_error;
490: --

Line 487: fnd_message.set_token('VALUE', p_hidden_cd);

483: -- raise error as does not exist as lookup
484: --
485: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
486: fnd_message.set_token('FIELD', 'p_hidden_cd');
487: fnd_message.set_token('VALUE', p_hidden_cd);
488: fnd_message.set_token('TYPE','BEN_WS_ACC');
489: fnd_message.raise_error;
490: --
491: end if;

Line 488: fnd_message.set_token('TYPE','BEN_WS_ACC');

484: --
485: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
486: fnd_message.set_token('FIELD', 'p_hidden_cd');
487: fnd_message.set_token('VALUE', p_hidden_cd);
488: fnd_message.set_token('TYPE','BEN_WS_ACC');
489: fnd_message.raise_error;
490: --
491: end if;
492: end if ;

Line 489: fnd_message.raise_error;

485: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
486: fnd_message.set_token('FIELD', 'p_hidden_cd');
487: fnd_message.set_token('VALUE', p_hidden_cd);
488: fnd_message.set_token('TYPE','BEN_WS_ACC');
489: fnd_message.raise_error;
490: --
491: end if;
492: end if ;
493: --

Line 568: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');

564: fetch c_cwg into l_dummy;
565: close c_cwg;
566:
567: if l_dummy = 1 then
568: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
569: fnd_message.raise_error;
570: end if;
571: end if;
572: end chk_ordr_num;

Line 569: fnd_message.raise_error;

565: close c_cwg;
566:
567: if l_dummy = 1 then
568: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
569: fnd_message.raise_error;
570: end if;
571: end if;
572: end chk_ordr_num;
573: --

Line 638: fnd_message.set_name('BEN','BEN_93316_LABEL_NOT_UNIQUE');

634: fetch c_cwg into l_dummy;
635: close c_cwg;
636:
637: if l_dummy = 1 then
638: fnd_message.set_name('BEN','BEN_93316_LABEL_NOT_UNIQUE');
639: fnd_message.raise_error;
640: end if;
641: end if;
642: end chk_uniq_label;

Line 639: fnd_message.raise_error;

635: close c_cwg;
636:
637: if l_dummy = 1 then
638: fnd_message.set_name('BEN','BEN_93316_LABEL_NOT_UNIQUE');
639: fnd_message.raise_error;
640: end if;
641: end if;
642: end chk_uniq_label;
643: --

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

700: p_effective_date => p_effective_date) then
701: --
702: -- raise error as does not exist as lookup
703: --
704: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
705: fnd_message.set_token('FIELD','p_wksht_grp_cd');
706: fnd_message.set_token('VALUE', p_wksht_grp_cd);
707: fnd_message.set_token('TYPE','BEN_WKSHT_GRP');
708: fnd_message.raise_error;

Line 705: fnd_message.set_token('FIELD','p_wksht_grp_cd');

701: --
702: -- raise error as does not exist as lookup
703: --
704: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
705: fnd_message.set_token('FIELD','p_wksht_grp_cd');
706: fnd_message.set_token('VALUE', p_wksht_grp_cd);
707: fnd_message.set_token('TYPE','BEN_WKSHT_GRP');
708: fnd_message.raise_error;
709: --

Line 706: fnd_message.set_token('VALUE', p_wksht_grp_cd);

702: -- raise error as does not exist as lookup
703: --
704: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
705: fnd_message.set_token('FIELD','p_wksht_grp_cd');
706: fnd_message.set_token('VALUE', p_wksht_grp_cd);
707: fnd_message.set_token('TYPE','BEN_WKSHT_GRP');
708: fnd_message.raise_error;
709: --
710: end if;

Line 707: fnd_message.set_token('TYPE','BEN_WKSHT_GRP');

703: --
704: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
705: fnd_message.set_token('FIELD','p_wksht_grp_cd');
706: fnd_message.set_token('VALUE', p_wksht_grp_cd);
707: fnd_message.set_token('TYPE','BEN_WKSHT_GRP');
708: fnd_message.raise_error;
709: --
710: end if;
711:

Line 708: fnd_message.raise_error;

704: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
705: fnd_message.set_token('FIELD','p_wksht_grp_cd');
706: fnd_message.set_token('VALUE', p_wksht_grp_cd);
707: fnd_message.set_token('TYPE','BEN_WKSHT_GRP');
708: fnd_message.raise_error;
709: --
710: end if;
711:
712: end if;