DBA Data[Home] [Help]

APPS.BEN_PRTT_RT_VAL_API dependencies on FND_MESSAGE

Line 53: fnd_message.set_name('BEN','BEN_91711_ENRT_RSLT_NOT_FND');

49: --
50: open c_result;
51: fetch c_result into l_result;
52: if c_result%notfound then
53: fnd_message.set_name('BEN','BEN_91711_ENRT_RSLT_NOT_FND');
54: fnd_message.set_token('PROC',l_proc);
55: fnd_message.set_token('ID', to_char(p_prtt_enrt_rslt_id));
56: fnd_message.set_token('PERSON_ID', to_char(p_person_id));
57: fnd_message.set_token('LER_ID', null);

Line 54: fnd_message.set_token('PROC',l_proc);

50: open c_result;
51: fetch c_result into l_result;
52: if c_result%notfound then
53: fnd_message.set_name('BEN','BEN_91711_ENRT_RSLT_NOT_FND');
54: fnd_message.set_token('PROC',l_proc);
55: fnd_message.set_token('ID', to_char(p_prtt_enrt_rslt_id));
56: fnd_message.set_token('PERSON_ID', to_char(p_person_id));
57: fnd_message.set_token('LER_ID', null);
58: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));

Line 55: fnd_message.set_token('ID', to_char(p_prtt_enrt_rslt_id));

51: fetch c_result into l_result;
52: if c_result%notfound then
53: fnd_message.set_name('BEN','BEN_91711_ENRT_RSLT_NOT_FND');
54: fnd_message.set_token('PROC',l_proc);
55: fnd_message.set_token('ID', to_char(p_prtt_enrt_rslt_id));
56: fnd_message.set_token('PERSON_ID', to_char(p_person_id));
57: fnd_message.set_token('LER_ID', null);
58: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
59: fnd_message.raise_error;

Line 56: fnd_message.set_token('PERSON_ID', to_char(p_person_id));

52: if c_result%notfound then
53: fnd_message.set_name('BEN','BEN_91711_ENRT_RSLT_NOT_FND');
54: fnd_message.set_token('PROC',l_proc);
55: fnd_message.set_token('ID', to_char(p_prtt_enrt_rslt_id));
56: fnd_message.set_token('PERSON_ID', to_char(p_person_id));
57: fnd_message.set_token('LER_ID', null);
58: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
59: fnd_message.raise_error;
60: end if;

Line 57: fnd_message.set_token('LER_ID', null);

53: fnd_message.set_name('BEN','BEN_91711_ENRT_RSLT_NOT_FND');
54: fnd_message.set_token('PROC',l_proc);
55: fnd_message.set_token('ID', to_char(p_prtt_enrt_rslt_id));
56: fnd_message.set_token('PERSON_ID', to_char(p_person_id));
57: fnd_message.set_token('LER_ID', null);
58: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
59: fnd_message.raise_error;
60: end if;
61: close c_result;

Line 58: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));

54: fnd_message.set_token('PROC',l_proc);
55: fnd_message.set_token('ID', to_char(p_prtt_enrt_rslt_id));
56: fnd_message.set_token('PERSON_ID', to_char(p_person_id));
57: fnd_message.set_token('LER_ID', null);
58: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
59: fnd_message.raise_error;
60: end if;
61: close c_result;
62: --

Line 59: fnd_message.raise_error;

55: fnd_message.set_token('ID', to_char(p_prtt_enrt_rslt_id));
56: fnd_message.set_token('PERSON_ID', to_char(p_person_id));
57: fnd_message.set_token('LER_ID', null);
58: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
59: fnd_message.raise_error;
60: end if;
61: close c_result;
62: --
63: if g_debug then

Line 192: fnd_message.set_name('BEN','BEN_93811_OVERLAPPING_RATES');

188: l_rt_end_dt;
189: close c_overlap_rt;
190:
191: if l_rt_strt_dt is not null then
192: fnd_message.set_name('BEN','BEN_93811_OVERLAPPING_RATES');
193: fnd_message.set_token('PROC',l_proc);
194: fnd_message.set_token('ABR', g_abr_name);
195: fnd_message.set_token('RSLT_ID', to_char(p_prtt_enrt_rslt_id));
196: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_new_rt_strt_dt));

Line 193: fnd_message.set_token('PROC',l_proc);

189: close c_overlap_rt;
190:
191: if l_rt_strt_dt is not null then
192: fnd_message.set_name('BEN','BEN_93811_OVERLAPPING_RATES');
193: fnd_message.set_token('PROC',l_proc);
194: fnd_message.set_token('ABR', g_abr_name);
195: fnd_message.set_token('RSLT_ID', to_char(p_prtt_enrt_rslt_id));
196: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_new_rt_strt_dt));
197: fnd_message.raise_error;

Line 194: fnd_message.set_token('ABR', g_abr_name);

190:
191: if l_rt_strt_dt is not null then
192: fnd_message.set_name('BEN','BEN_93811_OVERLAPPING_RATES');
193: fnd_message.set_token('PROC',l_proc);
194: fnd_message.set_token('ABR', g_abr_name);
195: fnd_message.set_token('RSLT_ID', to_char(p_prtt_enrt_rslt_id));
196: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_new_rt_strt_dt));
197: fnd_message.raise_error;
198: end if;

Line 195: fnd_message.set_token('RSLT_ID', to_char(p_prtt_enrt_rslt_id));

191: if l_rt_strt_dt is not null then
192: fnd_message.set_name('BEN','BEN_93811_OVERLAPPING_RATES');
193: fnd_message.set_token('PROC',l_proc);
194: fnd_message.set_token('ABR', g_abr_name);
195: fnd_message.set_token('RSLT_ID', to_char(p_prtt_enrt_rslt_id));
196: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_new_rt_strt_dt));
197: fnd_message.raise_error;
198: end if;
199:

Line 196: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_new_rt_strt_dt));

192: fnd_message.set_name('BEN','BEN_93811_OVERLAPPING_RATES');
193: fnd_message.set_token('PROC',l_proc);
194: fnd_message.set_token('ABR', g_abr_name);
195: fnd_message.set_token('RSLT_ID', to_char(p_prtt_enrt_rslt_id));
196: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_new_rt_strt_dt));
197: fnd_message.raise_error;
198: end if;
199:
200: if g_debug then

Line 197: fnd_message.raise_error;

193: fnd_message.set_token('PROC',l_proc);
194: fnd_message.set_token('ABR', g_abr_name);
195: fnd_message.set_token('RSLT_ID', to_char(p_prtt_enrt_rslt_id));
196: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_new_rt_strt_dt));
197: fnd_message.raise_error;
198: end if;
199:
200: if g_debug then
201: hr_utility.set_location('Leaving:'|| l_proc, 10);

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

991: if c_old_prv%notfound then
992: --
993: -- The primary key is invalid therefore we must error
994: --
995: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
996: fnd_message.raise_error;
997: end if;
998: close c_old_prv;
999: --

Line 996: fnd_message.raise_error;

992: --
993: -- The primary key is invalid therefore we must error
994: --
995: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
996: fnd_message.raise_error;
997: end if;
998: close c_old_prv;
999: --
1000: if nvl(p_rt_strt_dt,hr_api.g_date) = hr_api.g_date then

Line 1071: fnd_message.set_name ('BEN','BEN_93341_PRCCSD_IN_PAYROLL');

1067: l_rt_strt_dt), 1,1) ;
1068: --
1069: if l_processed_flag = 'Y' then
1070: --
1071: fnd_message.set_name ('BEN','BEN_93341_PRCCSD_IN_PAYROLL');
1072: fnd_message.raise_error;
1073: --
1074: end if;
1075: --

Line 1072: fnd_message.raise_error;

1068: --
1069: if l_processed_flag = 'Y' then
1070: --
1071: fnd_message.set_name ('BEN','BEN_93341_PRCCSD_IN_PAYROLL');
1072: fnd_message.raise_error;
1073: --
1074: end if;
1075: --
1076: end if;

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

1654: if c_old_prv%notfound then
1655: --
1656: -- The primary key is invalid therefore we must error
1657: --
1658: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
1659: fnd_message.raise_error;
1660: end if;
1661: close c_old_prv;
1662: if g_debug then

Line 1659: fnd_message.raise_error;

1655: --
1656: -- The primary key is invalid therefore we must error
1657: --
1658: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
1659: fnd_message.raise_error;
1660: end if;
1661: close c_old_prv;
1662: if g_debug then
1663: hr_utility.set_location(l_proc, 22);