177:
178:
179: if ((p_rept_perd_strt_dt is not null) and (p_rept_perd_end_dt is null))
180: or ((p_rept_perd_strt_dt is null) and (p_rept_perd_end_dt is not null)) then
181: fnd_message.set_name('BEN','BEN_93336_LES_STRT_END_DT_NULL');
182: fnd_message.set_token('PARAM','Reporting',TRUE);
183: p_error := fnd_message.get;
184: p_run_report:='N';
185: end if;
178:
179: if ((p_rept_perd_strt_dt is not null) and (p_rept_perd_end_dt is null))
180: or ((p_rept_perd_strt_dt is null) and (p_rept_perd_end_dt is not null)) then
181: fnd_message.set_name('BEN','BEN_93336_LES_STRT_END_DT_NULL');
182: fnd_message.set_token('PARAM','Reporting',TRUE);
183: p_error := fnd_message.get;
184: p_run_report:='N';
185: end if;
186:
179: if ((p_rept_perd_strt_dt is not null) and (p_rept_perd_end_dt is null))
180: or ((p_rept_perd_strt_dt is null) and (p_rept_perd_end_dt is not null)) then
181: fnd_message.set_name('BEN','BEN_93336_LES_STRT_END_DT_NULL');
182: fnd_message.set_token('PARAM','Reporting',TRUE);
183: p_error := fnd_message.get;
184: p_run_report:='N';
185: end if;
186:
187: if ((p_comp_perd_strt_dt is not null) and (p_comp_perd_end_dt is null))
186:
187: if ((p_comp_perd_strt_dt is not null) and (p_comp_perd_end_dt is null))
188: or ((p_comp_perd_strt_dt is null) and (p_comp_perd_end_dt is not null)) then
189:
190: fnd_message.set_name('BEN','BEN_93336_LES_STRT_END_DT_NULL');
191: fnd_message.set_token('PARAM','Comparison',TRUE);
192: p_run_report:='N';
193: p_error := fnd_message.get;
194: end if;
187: if ((p_comp_perd_strt_dt is not null) and (p_comp_perd_end_dt is null))
188: or ((p_comp_perd_strt_dt is null) and (p_comp_perd_end_dt is not null)) then
189:
190: fnd_message.set_name('BEN','BEN_93336_LES_STRT_END_DT_NULL');
191: fnd_message.set_token('PARAM','Comparison',TRUE);
192: p_run_report:='N';
193: p_error := fnd_message.get;
194: end if;
195:
189:
190: fnd_message.set_name('BEN','BEN_93336_LES_STRT_END_DT_NULL');
191: fnd_message.set_token('PARAM','Comparison',TRUE);
192: p_run_report:='N';
193: p_error := fnd_message.get;
194: end if;
195:
196:
197: if (p_pl_id is not null and p_reporting_group_id is not null) then
215: fetch c_pl into l_dummy;
216: if c_pl%found then
217: close c_pl;
218: else
219: fnd_message.set_name('BEN','BEN_93334_PL_NOT_IN_RPTG_GRP');
220: fnd_message.set_token('PL_NAME',ben_batch_utils.get_pl_name(p_pl_id, p_business_group_id,p_run_date));
221: fnd_message.set_token('RPTG_GRP',l_rpt_grp_name);
222: p_run_report:='N';
223: p_error := fnd_message.get;
216: if c_pl%found then
217: close c_pl;
218: else
219: fnd_message.set_name('BEN','BEN_93334_PL_NOT_IN_RPTG_GRP');
220: fnd_message.set_token('PL_NAME',ben_batch_utils.get_pl_name(p_pl_id, p_business_group_id,p_run_date));
221: fnd_message.set_token('RPTG_GRP',l_rpt_grp_name);
222: p_run_report:='N';
223: p_error := fnd_message.get;
224: close c_pl;
217: close c_pl;
218: else
219: fnd_message.set_name('BEN','BEN_93334_PL_NOT_IN_RPTG_GRP');
220: fnd_message.set_token('PL_NAME',ben_batch_utils.get_pl_name(p_pl_id, p_business_group_id,p_run_date));
221: fnd_message.set_token('RPTG_GRP',l_rpt_grp_name);
222: p_run_report:='N';
223: p_error := fnd_message.get;
224: close c_pl;
225: end if;
219: fnd_message.set_name('BEN','BEN_93334_PL_NOT_IN_RPTG_GRP');
220: fnd_message.set_token('PL_NAME',ben_batch_utils.get_pl_name(p_pl_id, p_business_group_id,p_run_date));
221: fnd_message.set_token('RPTG_GRP',l_rpt_grp_name);
222: p_run_report:='N';
223: p_error := fnd_message.get;
224: close c_pl;
225: end if;
226: end;
227:
230:
231:
232: if ((p_rept_perd_strt_dt is not null) and (p_rept_perd_end_dt is not null)) then
233: if p_rept_perd_strt_dt > p_rept_perd_end_dt then
234: fnd_message.set_name('BEN','BEN_93335_LES_STRT_GRT_END_DT');
235: fnd_message.set_token('PARAM','Reporting',TRUE);
236: p_run_report:='N';
237: p_error := fnd_message.get;
238: end if;
231:
232: if ((p_rept_perd_strt_dt is not null) and (p_rept_perd_end_dt is not null)) then
233: if p_rept_perd_strt_dt > p_rept_perd_end_dt then
234: fnd_message.set_name('BEN','BEN_93335_LES_STRT_GRT_END_DT');
235: fnd_message.set_token('PARAM','Reporting',TRUE);
236: p_run_report:='N';
237: p_error := fnd_message.get;
238: end if;
239: end if;
233: if p_rept_perd_strt_dt > p_rept_perd_end_dt then
234: fnd_message.set_name('BEN','BEN_93335_LES_STRT_GRT_END_DT');
235: fnd_message.set_token('PARAM','Reporting',TRUE);
236: p_run_report:='N';
237: p_error := fnd_message.get;
238: end if;
239: end if;
240:
241:
240:
241:
242: if ((p_comp_perd_strt_dt is not null) and (p_comp_perd_end_dt is not null)) then
243: if p_comp_perd_strt_dt > p_comp_perd_end_dt then
244: fnd_message.set_name('BEN','BEN_93335_LES_STRT_GRT_END_DT');
245: fnd_message.set_token('PARAM','Comparison',TRUE);
246: p_run_report:='N';
247: p_error := fnd_message.get;
248: end if;
241:
242: if ((p_comp_perd_strt_dt is not null) and (p_comp_perd_end_dt is not null)) then
243: if p_comp_perd_strt_dt > p_comp_perd_end_dt then
244: fnd_message.set_name('BEN','BEN_93335_LES_STRT_GRT_END_DT');
245: fnd_message.set_token('PARAM','Comparison',TRUE);
246: p_run_report:='N';
247: p_error := fnd_message.get;
248: end if;
249: end if;
243: if p_comp_perd_strt_dt > p_comp_perd_end_dt then
244: fnd_message.set_name('BEN','BEN_93335_LES_STRT_GRT_END_DT');
245: fnd_message.set_token('PARAM','Comparison',TRUE);
246: p_run_report:='N';
247: p_error := fnd_message.get;
248: end if;
249: end if;
250:
251: