eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_PRTT_PREM_API dependencies on FND_MESSAGE

Line 169: fnd_message.set_name('BEN', 'BEN_91832_PACKAGE_PARAM_NULL');

165: then
166: if p_prtt_prem_id is null then
167: -- If we are calling this procedure prior to a create premium, we need all these
168: -- parms passed in.
169: fnd_message.set_name('BEN', 'BEN_91832_PACKAGE_PARAM_NULL');
170: fnd_message.set_token('PACKAGE', l_proc);
171: fnd_message.set_token('PARAM',
172: 'p_std_prem_val or p_actl_prem_id or p_prtt_enrt_rslt_id');
173: fnd_message.raise_error;

Line 170: fnd_message.set_token('PACKAGE', l_proc);

166: if p_prtt_prem_id is null then
167: -- If we are calling this procedure prior to a create premium, we need all these
168: -- parms passed in.
169: fnd_message.set_name('BEN', 'BEN_91832_PACKAGE_PARAM_NULL');
170: fnd_message.set_token('PACKAGE', l_proc);
171: fnd_message.set_token('PARAM',
172: 'p_std_prem_val or p_actl_prem_id or p_prtt_enrt_rslt_id');
173: fnd_message.raise_error;
174: else

Line 171: fnd_message.set_token('PARAM',

167: -- If we are calling this procedure prior to a create premium, we need all these
168: -- parms passed in.
169: fnd_message.set_name('BEN', 'BEN_91832_PACKAGE_PARAM_NULL');
170: fnd_message.set_token('PACKAGE', l_proc);
171: fnd_message.set_token('PARAM',
172: 'p_std_prem_val or p_actl_prem_id or p_prtt_enrt_rslt_id');
173: fnd_message.raise_error;
174: else
175: --- fonm parameter added

Line 173: fnd_message.raise_error;

169: fnd_message.set_name('BEN', 'BEN_91832_PACKAGE_PARAM_NULL');
170: fnd_message.set_token('PACKAGE', l_proc);
171: fnd_message.set_token('PARAM',
172: 'p_std_prem_val or p_actl_prem_id or p_prtt_enrt_rslt_id');
173: fnd_message.raise_error;
174: else
175: --- fonm parameter added
176: open c_prtt_prem(l_fonm_date);
177: fetch c_prtt_prem into l_prtt_prem;

Line 181: fnd_message.set_name('BEN', 'BEN_91563_BENVRBRT_APR_NF');

177: fetch c_prtt_prem into l_prtt_prem;
178: if c_prtt_prem%NOTFOUND or c_prtt_prem%NOTFOUND is null then
179: close c_prtt_prem;
180: hr_utility.set_location('BEN_91563_BENVRBRT_APR_NF', 11);
181: fnd_message.set_name('BEN', 'BEN_91563_BENVRBRT_APR_NF');
182: fnd_message.raise_error;
183: end if;
184: close c_prtt_prem;
185: p_std_prem_val := l_prtt_prem.std_prem_val; -- output parm

Line 182: fnd_message.raise_error;

178: if c_prtt_prem%NOTFOUND or c_prtt_prem%NOTFOUND is null then
179: close c_prtt_prem;
180: hr_utility.set_location('BEN_91563_BENVRBRT_APR_NF', 11);
181: fnd_message.set_name('BEN', 'BEN_91563_BENVRBRT_APR_NF');
182: fnd_message.raise_error;
183: end if;
184: close c_prtt_prem;
185: p_std_prem_val := l_prtt_prem.std_prem_val; -- output parm
186: end if;

Line 197: fnd_message.set_name('BEN', 'BEN_91577_BENACPRM_APR_NF');

193: fetch c_actl_prem into l_actl_prem;
194: if c_actl_prem%NOTFOUND or c_actl_prem%NOTFOUND is null then
195: close c_actl_prem;
196: hr_utility.set_location('BEN_91577_BENACPRM_APR_NF', 20);
197: fnd_message.set_name('BEN', 'BEN_91577_BENACPRM_APR_NF');
198: fnd_message.raise_error;
199: end if;
200: close c_actl_prem;
201:

Line 198: fnd_message.raise_error;

194: if c_actl_prem%NOTFOUND or c_actl_prem%NOTFOUND is null then
195: close c_actl_prem;
196: hr_utility.set_location('BEN_91577_BENACPRM_APR_NF', 20);
197: fnd_message.set_name('BEN', 'BEN_91577_BENACPRM_APR_NF');
198: fnd_message.raise_error;
199: end if;
200: close c_actl_prem;
201:
202: -- If the premium is a multiple of coverage and that coverage value is

Line 219: fnd_message.set_name('BEN', 'BEN_92492_COVERAGE_NF');

215: fetch c_cvg into l_cvg;
216: if c_cvg%NOTFOUND then
217: close c_cvg;
218: hr_utility.set_location('BEN_92494_COVERAGE_NF', 30);
219: fnd_message.set_name('BEN', 'BEN_92492_COVERAGE_NF');
220: fnd_message.set_token('ID', to_char(l_prtt_prem.actl_prem_id));
221: fnd_message.raise_error;
222: end if;
223: close c_cvg;

Line 220: fnd_message.set_token('ID', to_char(l_prtt_prem.actl_prem_id));

216: if c_cvg%NOTFOUND then
217: close c_cvg;
218: hr_utility.set_location('BEN_92494_COVERAGE_NF', 30);
219: fnd_message.set_name('BEN', 'BEN_92492_COVERAGE_NF');
220: fnd_message.set_token('ID', to_char(l_prtt_prem.actl_prem_id));
221: fnd_message.raise_error;
222: end if;
223: close c_cvg;
224: --

Line 221: fnd_message.raise_error;

217: close c_cvg;
218: hr_utility.set_location('BEN_92494_COVERAGE_NF', 30);
219: fnd_message.set_name('BEN', 'BEN_92492_COVERAGE_NF');
220: fnd_message.set_token('ID', to_char(l_prtt_prem.actl_prem_id));
221: fnd_message.raise_error;
222: end if;
223: close c_cvg;
224: --
225: if l_cvg.entr_val_at_enrt_flag = 'Y' or l_cvg.cvg_mlt_cd = 'ERL' then

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

244: fetch c_rslt into l_rslt;
245: if c_rslt%NOTFOUND or c_rslt%NOTFOUND is null then
246: close c_rslt;
247: hr_utility.set_location('BEN_91711_ENRT_RSLT_NOT_FND', 11);
248: fnd_message.set_name('BEN', 'BEN_91711_ENRT_RSLT_NOT_FND');
249: fnd_message.set_token('PROC',l_proc);
250: fnd_message.set_token('ID', to_char(l_prtt_prem.prtt_enrt_rslt_id));
251: fnd_message.set_token('PERSON_ID',null);
252: fnd_message.set_token('LER_ID', to_char(p_ler_id));

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

245: if c_rslt%NOTFOUND or c_rslt%NOTFOUND is null then
246: close c_rslt;
247: hr_utility.set_location('BEN_91711_ENRT_RSLT_NOT_FND', 11);
248: fnd_message.set_name('BEN', 'BEN_91711_ENRT_RSLT_NOT_FND');
249: fnd_message.set_token('PROC',l_proc);
250: fnd_message.set_token('ID', to_char(l_prtt_prem.prtt_enrt_rslt_id));
251: fnd_message.set_token('PERSON_ID',null);
252: fnd_message.set_token('LER_ID', to_char(p_ler_id));
253: fnd_message.set_token('EFFECTIVE_DATE', to_char(p_effective_date));

Line 250: fnd_message.set_token('ID', to_char(l_prtt_prem.prtt_enrt_rslt_id));

246: close c_rslt;
247: hr_utility.set_location('BEN_91711_ENRT_RSLT_NOT_FND', 11);
248: fnd_message.set_name('BEN', 'BEN_91711_ENRT_RSLT_NOT_FND');
249: fnd_message.set_token('PROC',l_proc);
250: fnd_message.set_token('ID', to_char(l_prtt_prem.prtt_enrt_rslt_id));
251: fnd_message.set_token('PERSON_ID',null);
252: fnd_message.set_token('LER_ID', to_char(p_ler_id));
253: fnd_message.set_token('EFFECTIVE_DATE', to_char(p_effective_date));
254: fnd_message.raise_error;

Line 251: fnd_message.set_token('PERSON_ID',null);

247: hr_utility.set_location('BEN_91711_ENRT_RSLT_NOT_FND', 11);
248: fnd_message.set_name('BEN', 'BEN_91711_ENRT_RSLT_NOT_FND');
249: fnd_message.set_token('PROC',l_proc);
250: fnd_message.set_token('ID', to_char(l_prtt_prem.prtt_enrt_rslt_id));
251: fnd_message.set_token('PERSON_ID',null);
252: fnd_message.set_token('LER_ID', to_char(p_ler_id));
253: fnd_message.set_token('EFFECTIVE_DATE', to_char(p_effective_date));
254: fnd_message.raise_error;
255: end if;

Line 252: fnd_message.set_token('LER_ID', to_char(p_ler_id));

248: fnd_message.set_name('BEN', 'BEN_91711_ENRT_RSLT_NOT_FND');
249: fnd_message.set_token('PROC',l_proc);
250: fnd_message.set_token('ID', to_char(l_prtt_prem.prtt_enrt_rslt_id));
251: fnd_message.set_token('PERSON_ID',null);
252: fnd_message.set_token('LER_ID', to_char(p_ler_id));
253: fnd_message.set_token('EFFECTIVE_DATE', to_char(p_effective_date));
254: fnd_message.raise_error;
255: end if;
256: close c_rslt;

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

249: fnd_message.set_token('PROC',l_proc);
250: fnd_message.set_token('ID', to_char(l_prtt_prem.prtt_enrt_rslt_id));
251: fnd_message.set_token('PERSON_ID',null);
252: fnd_message.set_token('LER_ID', to_char(p_ler_id));
253: fnd_message.set_token('EFFECTIVE_DATE', to_char(p_effective_date));
254: fnd_message.raise_error;
255: end if;
256: close c_rslt;
257: --

Line 254: fnd_message.raise_error;

250: fnd_message.set_token('ID', to_char(l_prtt_prem.prtt_enrt_rslt_id));
251: fnd_message.set_token('PERSON_ID',null);
252: fnd_message.set_token('LER_ID', to_char(p_ler_id));
253: fnd_message.set_token('EFFECTIVE_DATE', to_char(p_effective_date));
254: fnd_message.raise_error;
255: end if;
256: close c_rslt;
257: --
258: if l_rslt.oipl_id is not null then