DBA Data[Home] [Help]

APPS.BEN_PRTT_RT_VAL_API dependencies on FND_MESSAGE

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

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

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

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

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

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

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

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

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

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

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

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

Line 58: fnd_message.raise_error;

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

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

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

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

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

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

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

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

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

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

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

Line 196: fnd_message.raise_error;

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

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

975: if c_old_prv%notfound then
976: --
977: -- The primary key is invalid therefore we must error
978: --
979: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
980: fnd_message.raise_error;
981: end if;
982: close c_old_prv;
983: --

Line 980: fnd_message.raise_error;

976: --
977: -- The primary key is invalid therefore we must error
978: --
979: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
980: fnd_message.raise_error;
981: end if;
982: close c_old_prv;
983: --
984: if nvl(p_rt_strt_dt,hr_api.g_date) = hr_api.g_date then

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

1051: l_rt_strt_dt), 1,1) ;
1052: --
1053: if l_processed_flag = 'Y' then
1054: --
1055: fnd_message.set_name ('BEN','BEN_93341_PRCCSD_IN_PAYROLL');
1056: fnd_message.raise_error;
1057: --
1058: end if;
1059: --

Line 1056: fnd_message.raise_error;

1052: --
1053: if l_processed_flag = 'Y' then
1054: --
1055: fnd_message.set_name ('BEN','BEN_93341_PRCCSD_IN_PAYROLL');
1056: fnd_message.raise_error;
1057: --
1058: end if;
1059: --
1060: end if;

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

1603: if c_old_prv%notfound then
1604: --
1605: -- The primary key is invalid therefore we must error
1606: --
1607: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
1608: fnd_message.raise_error;
1609: end if;
1610: close c_old_prv;
1611: if g_debug then

Line 1608: fnd_message.raise_error;

1604: --
1605: -- The primary key is invalid therefore we must error
1606: --
1607: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
1608: fnd_message.raise_error;
1609: end if;
1610: close c_old_prv;
1611: if g_debug then
1612: hr_utility.set_location(l_proc, 22);