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.GMP_PLNG_DTL_REPORT_PKG dependencies on FND_FILE

Line 211: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' Before msc_snapshot_pk.get_bucket_cutoff_dates ');

207: G_act_pdr_locale := p_act_pdr_locale ;
208:
209:
210: -- Bug: 8363786 Vpedarla
211: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' Before msc_snapshot_pk.get_bucket_cutoff_dates ');
212:
213: msc_snapshot_pk.get_bucket_cutoff_dates(
214: G_plan_id , -- p_plan_id IN NUMBER,
215: G_org_id , -- p_org_id IN NUMBER,

Line 232: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' After msc_snapshot_pk.get_bucket_cutoff_dates ');

228: v_period_cutoff_date, -- OUT DATE,
229: v_err_mesg -- OUT VARCHAR2
230: ) ;
231:
232: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' After msc_snapshot_pk.get_bucket_cutoff_dates ');
233: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' v_min_cutoff_date: '||TO_CHAR(v_min_cutoff_date,'DD-MON-YYYY'));
234: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' v_hour_cutoff_date: '||TO_CHAR(v_hour_cutoff_date,'DD-MON-YYYY'));
235: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' v_daily_cutoff_date: '||TO_CHAR(v_daily_cutoff_date,'DD-MON-YYYY'));
236: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' v_weekly_cutoff_date: '||TO_CHAR(v_weekly_cutoff_date,'DD-MON-YYYY'));

Line 233: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' v_min_cutoff_date: '||TO_CHAR(v_min_cutoff_date,'DD-MON-YYYY'));

229: v_err_mesg -- OUT VARCHAR2
230: ) ;
231:
232: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' After msc_snapshot_pk.get_bucket_cutoff_dates ');
233: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' v_min_cutoff_date: '||TO_CHAR(v_min_cutoff_date,'DD-MON-YYYY'));
234: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' v_hour_cutoff_date: '||TO_CHAR(v_hour_cutoff_date,'DD-MON-YYYY'));
235: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' v_daily_cutoff_date: '||TO_CHAR(v_daily_cutoff_date,'DD-MON-YYYY'));
236: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' v_weekly_cutoff_date: '||TO_CHAR(v_weekly_cutoff_date,'DD-MON-YYYY'));
237: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' v_period_cutoff_date: '||TO_CHAR(v_period_cutoff_date,'DD-MON-YYYY'));

Line 234: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' v_hour_cutoff_date: '||TO_CHAR(v_hour_cutoff_date,'DD-MON-YYYY'));

230: ) ;
231:
232: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' After msc_snapshot_pk.get_bucket_cutoff_dates ');
233: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' v_min_cutoff_date: '||TO_CHAR(v_min_cutoff_date,'DD-MON-YYYY'));
234: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' v_hour_cutoff_date: '||TO_CHAR(v_hour_cutoff_date,'DD-MON-YYYY'));
235: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' v_daily_cutoff_date: '||TO_CHAR(v_daily_cutoff_date,'DD-MON-YYYY'));
236: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' v_weekly_cutoff_date: '||TO_CHAR(v_weekly_cutoff_date,'DD-MON-YYYY'));
237: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' v_period_cutoff_date: '||TO_CHAR(v_period_cutoff_date,'DD-MON-YYYY'));
238: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' v_err_mesg: '||v_err_mesg);

Line 235: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' v_daily_cutoff_date: '||TO_CHAR(v_daily_cutoff_date,'DD-MON-YYYY'));

231:
232: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' After msc_snapshot_pk.get_bucket_cutoff_dates ');
233: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' v_min_cutoff_date: '||TO_CHAR(v_min_cutoff_date,'DD-MON-YYYY'));
234: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' v_hour_cutoff_date: '||TO_CHAR(v_hour_cutoff_date,'DD-MON-YYYY'));
235: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' v_daily_cutoff_date: '||TO_CHAR(v_daily_cutoff_date,'DD-MON-YYYY'));
236: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' v_weekly_cutoff_date: '||TO_CHAR(v_weekly_cutoff_date,'DD-MON-YYYY'));
237: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' v_period_cutoff_date: '||TO_CHAR(v_period_cutoff_date,'DD-MON-YYYY'));
238: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' v_err_mesg: '||v_err_mesg);
239:

Line 236: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' v_weekly_cutoff_date: '||TO_CHAR(v_weekly_cutoff_date,'DD-MON-YYYY'));

232: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' After msc_snapshot_pk.get_bucket_cutoff_dates ');
233: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' v_min_cutoff_date: '||TO_CHAR(v_min_cutoff_date,'DD-MON-YYYY'));
234: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' v_hour_cutoff_date: '||TO_CHAR(v_hour_cutoff_date,'DD-MON-YYYY'));
235: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' v_daily_cutoff_date: '||TO_CHAR(v_daily_cutoff_date,'DD-MON-YYYY'));
236: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' v_weekly_cutoff_date: '||TO_CHAR(v_weekly_cutoff_date,'DD-MON-YYYY'));
237: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' v_period_cutoff_date: '||TO_CHAR(v_period_cutoff_date,'DD-MON-YYYY'));
238: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' v_err_mesg: '||v_err_mesg);
239:
240: select min(cal.week_start_date)

Line 237: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' v_period_cutoff_date: '||TO_CHAR(v_period_cutoff_date,'DD-MON-YYYY'));

233: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' v_min_cutoff_date: '||TO_CHAR(v_min_cutoff_date,'DD-MON-YYYY'));
234: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' v_hour_cutoff_date: '||TO_CHAR(v_hour_cutoff_date,'DD-MON-YYYY'));
235: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' v_daily_cutoff_date: '||TO_CHAR(v_daily_cutoff_date,'DD-MON-YYYY'));
236: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' v_weekly_cutoff_date: '||TO_CHAR(v_weekly_cutoff_date,'DD-MON-YYYY'));
237: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' v_period_cutoff_date: '||TO_CHAR(v_period_cutoff_date,'DD-MON-YYYY'));
238: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' v_err_mesg: '||v_err_mesg);
239:
240: select min(cal.week_start_date)
241: into v_weekly_start_date

Line 238: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' v_err_mesg: '||v_err_mesg);

234: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' v_hour_cutoff_date: '||TO_CHAR(v_hour_cutoff_date,'DD-MON-YYYY'));
235: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' v_daily_cutoff_date: '||TO_CHAR(v_daily_cutoff_date,'DD-MON-YYYY'));
236: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' v_weekly_cutoff_date: '||TO_CHAR(v_weekly_cutoff_date,'DD-MON-YYYY'));
237: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' v_period_cutoff_date: '||TO_CHAR(v_period_cutoff_date,'DD-MON-YYYY'));
238: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' v_err_mesg: '||v_err_mesg);
239:
240: select min(cal.week_start_date)
241: into v_weekly_start_date
242: from msc_cal_week_start_dates cal , msc_trading_partners mtp

Line 251: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' v_weekly_start_date: '||TO_CHAR(v_weekly_start_date,'DD-MON-YYYY'));

247: and mtp.sr_tp_id = G_org_id
248: and mtp.partner_type = 3
249: and cal.sr_instance_id = mtp.sr_instance_id ;
250:
251: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' v_weekly_start_date: '||TO_CHAR(v_weekly_start_date,'DD-MON-YYYY'));
252:
253: select min(cal.period_start_date)
254: into v_period_start_date
255: from msc_period_start_dates cal , msc_trading_partners mtp

Line 264: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' v_period_start_date: '||TO_CHAR(v_period_start_date,'DD-MON-YYYY'));

260: and mtp.sr_tp_id = G_org_id
261: and mtp.partner_type = 3
262: and cal.sr_instance_id = mtp.sr_instance_id ;
263:
264: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' v_period_start_date: '||TO_CHAR(v_period_start_date,'DD-MON-YYYY'));
265:
266: if G_week_bucket = 0 and G_period_bucket = 0 and G_day_bucket = 0 then
267: G_day_bckt_cutoff_dt := G_start_date ;
268: G_week_bckt_cutoff_dt := NULL;

Line 292: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' Calling GMP_PLNG_DTL_REPORT_PKG with values ');

288: end if;
289: -- Bug: 8363786 Vpedarla end
290:
291:
292: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' Calling GMP_PLNG_DTL_REPORT_PKG with values ');
293: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_inst_id '||to_char(G_inst_id));
294: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_org_id '||to_char(G_org_id));
295: -- FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_name '||G_plan_name);
296: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_id '||to_char(G_plan_id));

Line 293: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_inst_id '||to_char(G_inst_id));

289: -- Bug: 8363786 Vpedarla end
290:
291:
292: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' Calling GMP_PLNG_DTL_REPORT_PKG with values ');
293: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_inst_id '||to_char(G_inst_id));
294: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_org_id '||to_char(G_org_id));
295: -- FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_name '||G_plan_name);
296: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_id '||to_char(G_plan_id));
297: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_org '||to_char(G_plan_org));

Line 294: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_org_id '||to_char(G_org_id));

290:
291:
292: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' Calling GMP_PLNG_DTL_REPORT_PKG with values ');
293: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_inst_id '||to_char(G_inst_id));
294: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_org_id '||to_char(G_org_id));
295: -- FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_name '||G_plan_name);
296: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_id '||to_char(G_plan_id));
297: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_org '||to_char(G_plan_org));
298: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_start_date '||TO_CHAR(G_start_date,'DD-MON-YYYY'));

Line 295: -- FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_name '||G_plan_name);

291:
292: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' Calling GMP_PLNG_DTL_REPORT_PKG with values ');
293: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_inst_id '||to_char(G_inst_id));
294: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_org_id '||to_char(G_org_id));
295: -- FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_name '||G_plan_name);
296: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_id '||to_char(G_plan_id));
297: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_org '||to_char(G_plan_org));
298: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_start_date '||TO_CHAR(G_start_date,'DD-MON-YYYY'));
299: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_day_bucket '||to_char(G_day_bucket));

Line 296: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_id '||to_char(G_plan_id));

292: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' Calling GMP_PLNG_DTL_REPORT_PKG with values ');
293: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_inst_id '||to_char(G_inst_id));
294: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_org_id '||to_char(G_org_id));
295: -- FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_name '||G_plan_name);
296: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_id '||to_char(G_plan_id));
297: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_org '||to_char(G_plan_org));
298: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_start_date '||TO_CHAR(G_start_date,'DD-MON-YYYY'));
299: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_day_bucket '||to_char(G_day_bucket));
300: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_day_bckt_cutoff_dt '||TO_CHAR(G_day_bckt_cutoff_dt,'DD-MON-YYYY'));

Line 297: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_org '||to_char(G_plan_org));

293: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_inst_id '||to_char(G_inst_id));
294: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_org_id '||to_char(G_org_id));
295: -- FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_name '||G_plan_name);
296: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_id '||to_char(G_plan_id));
297: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_org '||to_char(G_plan_org));
298: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_start_date '||TO_CHAR(G_start_date,'DD-MON-YYYY'));
299: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_day_bucket '||to_char(G_day_bucket));
300: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_day_bckt_cutoff_dt '||TO_CHAR(G_day_bckt_cutoff_dt,'DD-MON-YYYY'));
301: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_day_bckt_cutoff_dt '||TO_CHAR(G_plan_day_bckt_cutoff_dt,'DD-MON-YYYY'));

Line 298: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_start_date '||TO_CHAR(G_start_date,'DD-MON-YYYY'));

294: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_org_id '||to_char(G_org_id));
295: -- FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_name '||G_plan_name);
296: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_id '||to_char(G_plan_id));
297: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_org '||to_char(G_plan_org));
298: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_start_date '||TO_CHAR(G_start_date,'DD-MON-YYYY'));
299: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_day_bucket '||to_char(G_day_bucket));
300: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_day_bckt_cutoff_dt '||TO_CHAR(G_day_bckt_cutoff_dt,'DD-MON-YYYY'));
301: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_day_bckt_cutoff_dt '||TO_CHAR(G_plan_day_bckt_cutoff_dt,'DD-MON-YYYY'));
302: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_week_bucket '||to_char(G_week_bucket));

Line 299: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_day_bucket '||to_char(G_day_bucket));

295: -- FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_name '||G_plan_name);
296: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_id '||to_char(G_plan_id));
297: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_org '||to_char(G_plan_org));
298: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_start_date '||TO_CHAR(G_start_date,'DD-MON-YYYY'));
299: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_day_bucket '||to_char(G_day_bucket));
300: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_day_bckt_cutoff_dt '||TO_CHAR(G_day_bckt_cutoff_dt,'DD-MON-YYYY'));
301: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_day_bckt_cutoff_dt '||TO_CHAR(G_plan_day_bckt_cutoff_dt,'DD-MON-YYYY'));
302: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_week_bucket '||to_char(G_week_bucket));
303: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_week_bckt_cutoff_dt '||TO_CHAR(G_week_bckt_cutoff_dt,'DD-MON-YYYY'));

Line 300: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_day_bckt_cutoff_dt '||TO_CHAR(G_day_bckt_cutoff_dt,'DD-MON-YYYY'));

296: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_id '||to_char(G_plan_id));
297: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_org '||to_char(G_plan_org));
298: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_start_date '||TO_CHAR(G_start_date,'DD-MON-YYYY'));
299: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_day_bucket '||to_char(G_day_bucket));
300: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_day_bckt_cutoff_dt '||TO_CHAR(G_day_bckt_cutoff_dt,'DD-MON-YYYY'));
301: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_day_bckt_cutoff_dt '||TO_CHAR(G_plan_day_bckt_cutoff_dt,'DD-MON-YYYY'));
302: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_week_bucket '||to_char(G_week_bucket));
303: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_week_bckt_cutoff_dt '||TO_CHAR(G_week_bckt_cutoff_dt,'DD-MON-YYYY'));
304: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_week_bckt_cutoff_dt '||TO_CHAR(G_plan_week_bckt_cutoff_dt,'DD-MON-YYYY'));

Line 301: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_day_bckt_cutoff_dt '||TO_CHAR(G_plan_day_bckt_cutoff_dt,'DD-MON-YYYY'));

297: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_org '||to_char(G_plan_org));
298: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_start_date '||TO_CHAR(G_start_date,'DD-MON-YYYY'));
299: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_day_bucket '||to_char(G_day_bucket));
300: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_day_bckt_cutoff_dt '||TO_CHAR(G_day_bckt_cutoff_dt,'DD-MON-YYYY'));
301: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_day_bckt_cutoff_dt '||TO_CHAR(G_plan_day_bckt_cutoff_dt,'DD-MON-YYYY'));
302: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_week_bucket '||to_char(G_week_bucket));
303: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_week_bckt_cutoff_dt '||TO_CHAR(G_week_bckt_cutoff_dt,'DD-MON-YYYY'));
304: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_week_bckt_cutoff_dt '||TO_CHAR(G_plan_week_bckt_cutoff_dt,'DD-MON-YYYY'));
305: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_period_bucket '||to_char(G_period_bucket));

Line 302: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_week_bucket '||to_char(G_week_bucket));

298: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_start_date '||TO_CHAR(G_start_date,'DD-MON-YYYY'));
299: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_day_bucket '||to_char(G_day_bucket));
300: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_day_bckt_cutoff_dt '||TO_CHAR(G_day_bckt_cutoff_dt,'DD-MON-YYYY'));
301: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_day_bckt_cutoff_dt '||TO_CHAR(G_plan_day_bckt_cutoff_dt,'DD-MON-YYYY'));
302: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_week_bucket '||to_char(G_week_bucket));
303: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_week_bckt_cutoff_dt '||TO_CHAR(G_week_bckt_cutoff_dt,'DD-MON-YYYY'));
304: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_week_bckt_cutoff_dt '||TO_CHAR(G_plan_week_bckt_cutoff_dt,'DD-MON-YYYY'));
305: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_period_bucket '||to_char(G_period_bucket));
306: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_fsort '||to_char(G_fsort));

Line 303: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_week_bckt_cutoff_dt '||TO_CHAR(G_week_bckt_cutoff_dt,'DD-MON-YYYY'));

299: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_day_bucket '||to_char(G_day_bucket));
300: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_day_bckt_cutoff_dt '||TO_CHAR(G_day_bckt_cutoff_dt,'DD-MON-YYYY'));
301: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_day_bckt_cutoff_dt '||TO_CHAR(G_plan_day_bckt_cutoff_dt,'DD-MON-YYYY'));
302: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_week_bucket '||to_char(G_week_bucket));
303: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_week_bckt_cutoff_dt '||TO_CHAR(G_week_bckt_cutoff_dt,'DD-MON-YYYY'));
304: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_week_bckt_cutoff_dt '||TO_CHAR(G_plan_week_bckt_cutoff_dt,'DD-MON-YYYY'));
305: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_period_bucket '||to_char(G_period_bucket));
306: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_fsort '||to_char(G_fsort));
307: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_ssort '||to_char(G_ssort));

Line 304: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_week_bckt_cutoff_dt '||TO_CHAR(G_plan_week_bckt_cutoff_dt,'DD-MON-YYYY'));

300: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_day_bckt_cutoff_dt '||TO_CHAR(G_day_bckt_cutoff_dt,'DD-MON-YYYY'));
301: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_day_bckt_cutoff_dt '||TO_CHAR(G_plan_day_bckt_cutoff_dt,'DD-MON-YYYY'));
302: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_week_bucket '||to_char(G_week_bucket));
303: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_week_bckt_cutoff_dt '||TO_CHAR(G_week_bckt_cutoff_dt,'DD-MON-YYYY'));
304: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_week_bckt_cutoff_dt '||TO_CHAR(G_plan_week_bckt_cutoff_dt,'DD-MON-YYYY'));
305: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_period_bucket '||to_char(G_period_bucket));
306: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_fsort '||to_char(G_fsort));
307: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_ssort '||to_char(G_ssort));
308: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_tsort '||to_char(G_tsort));

Line 305: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_period_bucket '||to_char(G_period_bucket));

301: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_day_bckt_cutoff_dt '||TO_CHAR(G_plan_day_bckt_cutoff_dt,'DD-MON-YYYY'));
302: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_week_bucket '||to_char(G_week_bucket));
303: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_week_bckt_cutoff_dt '||TO_CHAR(G_week_bckt_cutoff_dt,'DD-MON-YYYY'));
304: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_week_bckt_cutoff_dt '||TO_CHAR(G_plan_week_bckt_cutoff_dt,'DD-MON-YYYY'));
305: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_period_bucket '||to_char(G_period_bucket));
306: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_fsort '||to_char(G_fsort));
307: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_ssort '||to_char(G_ssort));
308: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_tsort '||to_char(G_tsort));
309: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_ex_typ '||to_char(G_ex_typ));

Line 306: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_fsort '||to_char(G_fsort));

302: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_week_bucket '||to_char(G_week_bucket));
303: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_week_bckt_cutoff_dt '||TO_CHAR(G_week_bckt_cutoff_dt,'DD-MON-YYYY'));
304: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_week_bckt_cutoff_dt '||TO_CHAR(G_plan_week_bckt_cutoff_dt,'DD-MON-YYYY'));
305: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_period_bucket '||to_char(G_period_bucket));
306: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_fsort '||to_char(G_fsort));
307: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_ssort '||to_char(G_ssort));
308: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_tsort '||to_char(G_tsort));
309: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_ex_typ '||to_char(G_ex_typ));
310: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plnr_low '||G_plnr_low);

Line 307: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_ssort '||to_char(G_ssort));

303: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_week_bckt_cutoff_dt '||TO_CHAR(G_week_bckt_cutoff_dt,'DD-MON-YYYY'));
304: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_week_bckt_cutoff_dt '||TO_CHAR(G_plan_week_bckt_cutoff_dt,'DD-MON-YYYY'));
305: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_period_bucket '||to_char(G_period_bucket));
306: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_fsort '||to_char(G_fsort));
307: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_ssort '||to_char(G_ssort));
308: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_tsort '||to_char(G_tsort));
309: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_ex_typ '||to_char(G_ex_typ));
310: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plnr_low '||G_plnr_low);
311: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plnr_high '||G_plnr_high);

Line 308: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_tsort '||to_char(G_tsort));

304: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_week_bckt_cutoff_dt '||TO_CHAR(G_plan_week_bckt_cutoff_dt,'DD-MON-YYYY'));
305: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_period_bucket '||to_char(G_period_bucket));
306: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_fsort '||to_char(G_fsort));
307: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_ssort '||to_char(G_ssort));
308: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_tsort '||to_char(G_tsort));
309: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_ex_typ '||to_char(G_ex_typ));
310: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plnr_low '||G_plnr_low);
311: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plnr_high '||G_plnr_high);
312: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_byr_low '||G_byr_low);

Line 309: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_ex_typ '||to_char(G_ex_typ));

305: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_period_bucket '||to_char(G_period_bucket));
306: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_fsort '||to_char(G_fsort));
307: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_ssort '||to_char(G_ssort));
308: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_tsort '||to_char(G_tsort));
309: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_ex_typ '||to_char(G_ex_typ));
310: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plnr_low '||G_plnr_low);
311: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plnr_high '||G_plnr_high);
312: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_byr_low '||G_byr_low);
313: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_byr_high '||G_byr_high);

Line 310: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plnr_low '||G_plnr_low);

306: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_fsort '||to_char(G_fsort));
307: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_ssort '||to_char(G_ssort));
308: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_tsort '||to_char(G_tsort));
309: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_ex_typ '||to_char(G_ex_typ));
310: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plnr_low '||G_plnr_low);
311: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plnr_high '||G_plnr_high);
312: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_byr_low '||G_byr_low);
313: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_byr_high '||G_byr_high);
314: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_itm_low '||G_itm_low);

Line 311: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plnr_high '||G_plnr_high);

307: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_ssort '||to_char(G_ssort));
308: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_tsort '||to_char(G_tsort));
309: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_ex_typ '||to_char(G_ex_typ));
310: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plnr_low '||G_plnr_low);
311: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plnr_high '||G_plnr_high);
312: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_byr_low '||G_byr_low);
313: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_byr_high '||G_byr_high);
314: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_itm_low '||G_itm_low);
315: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_itm_high '||G_itm_high);

Line 312: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_byr_low '||G_byr_low);

308: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_tsort '||to_char(G_tsort));
309: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_ex_typ '||to_char(G_ex_typ));
310: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plnr_low '||G_plnr_low);
311: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plnr_high '||G_plnr_high);
312: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_byr_low '||G_byr_low);
313: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_byr_high '||G_byr_high);
314: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_itm_low '||G_itm_low);
315: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_itm_high '||G_itm_high);
316: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_cat_set_id '||to_char(G_cat_set_id));

Line 313: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_byr_high '||G_byr_high);

309: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_ex_typ '||to_char(G_ex_typ));
310: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plnr_low '||G_plnr_low);
311: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plnr_high '||G_plnr_high);
312: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_byr_low '||G_byr_low);
313: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_byr_high '||G_byr_high);
314: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_itm_low '||G_itm_low);
315: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_itm_high '||G_itm_high);
316: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_cat_set_id '||to_char(G_cat_set_id));
317: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_category_low '||G_category_low);

Line 314: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_itm_low '||G_itm_low);

310: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plnr_low '||G_plnr_low);
311: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plnr_high '||G_plnr_high);
312: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_byr_low '||G_byr_low);
313: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_byr_high '||G_byr_high);
314: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_itm_low '||G_itm_low);
315: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_itm_high '||G_itm_high);
316: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_cat_set_id '||to_char(G_cat_set_id));
317: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_category_low '||G_category_low);
318: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_category_high '||G_category_high);

Line 315: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_itm_high '||G_itm_high);

311: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plnr_high '||G_plnr_high);
312: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_byr_low '||G_byr_low);
313: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_byr_high '||G_byr_high);
314: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_itm_low '||G_itm_low);
315: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_itm_high '||G_itm_high);
316: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_cat_set_id '||to_char(G_cat_set_id));
317: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_category_low '||G_category_low);
318: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_category_high '||G_category_high);
319: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_abc_class_low '||G_abc_class_low);

Line 316: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_cat_set_id '||to_char(G_cat_set_id));

312: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_byr_low '||G_byr_low);
313: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_byr_high '||G_byr_high);
314: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_itm_low '||G_itm_low);
315: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_itm_high '||G_itm_high);
316: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_cat_set_id '||to_char(G_cat_set_id));
317: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_category_low '||G_category_low);
318: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_category_high '||G_category_high);
319: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_abc_class_low '||G_abc_class_low);
320: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_abc_class_high '||G_abc_class_high);

Line 317: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_category_low '||G_category_low);

313: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_byr_high '||G_byr_high);
314: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_itm_low '||G_itm_low);
315: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_itm_high '||G_itm_high);
316: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_cat_set_id '||to_char(G_cat_set_id));
317: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_category_low '||G_category_low);
318: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_category_high '||G_category_high);
319: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_abc_class_low '||G_abc_class_low);
320: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_abc_class_high '||G_abc_class_high);
321: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_cutoff_date '||TO_CHAR(G_cutoff_date,'DD-MON-YYYY'));

Line 318: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_category_high '||G_category_high);

314: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_itm_low '||G_itm_low);
315: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_itm_high '||G_itm_high);
316: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_cat_set_id '||to_char(G_cat_set_id));
317: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_category_low '||G_category_low);
318: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_category_high '||G_category_high);
319: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_abc_class_low '||G_abc_class_low);
320: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_abc_class_high '||G_abc_class_high);
321: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_cutoff_date '||TO_CHAR(G_cutoff_date,'DD-MON-YYYY'));
322: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_incl_items_no_activity '||G_incl_items_no_activity);

Line 319: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_abc_class_low '||G_abc_class_low);

315: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_itm_high '||G_itm_high);
316: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_cat_set_id '||to_char(G_cat_set_id));
317: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_category_low '||G_category_low);
318: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_category_high '||G_category_high);
319: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_abc_class_low '||G_abc_class_low);
320: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_abc_class_high '||G_abc_class_high);
321: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_cutoff_date '||TO_CHAR(G_cutoff_date,'DD-MON-YYYY'));
322: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_incl_items_no_activity '||G_incl_items_no_activity);
323: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_comb_pdr '||to_char(G_comb_pdr));

Line 320: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_abc_class_high '||G_abc_class_high);

316: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_cat_set_id '||to_char(G_cat_set_id));
317: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_category_low '||G_category_low);
318: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_category_high '||G_category_high);
319: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_abc_class_low '||G_abc_class_low);
320: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_abc_class_high '||G_abc_class_high);
321: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_cutoff_date '||TO_CHAR(G_cutoff_date,'DD-MON-YYYY'));
322: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_incl_items_no_activity '||G_incl_items_no_activity);
323: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_comb_pdr '||to_char(G_comb_pdr));
324: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_comb_pdr_temp '||G_comb_pdr_temp);

Line 321: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_cutoff_date '||TO_CHAR(G_cutoff_date,'DD-MON-YYYY'));

317: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_category_low '||G_category_low);
318: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_category_high '||G_category_high);
319: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_abc_class_low '||G_abc_class_low);
320: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_abc_class_high '||G_abc_class_high);
321: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_cutoff_date '||TO_CHAR(G_cutoff_date,'DD-MON-YYYY'));
322: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_incl_items_no_activity '||G_incl_items_no_activity);
323: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_comb_pdr '||to_char(G_comb_pdr));
324: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_comb_pdr_temp '||G_comb_pdr_temp);
325: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_comb_pdr_locale '||G_comb_pdr_locale);

Line 322: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_incl_items_no_activity '||G_incl_items_no_activity);

318: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_category_high '||G_category_high);
319: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_abc_class_low '||G_abc_class_low);
320: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_abc_class_high '||G_abc_class_high);
321: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_cutoff_date '||TO_CHAR(G_cutoff_date,'DD-MON-YYYY'));
322: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_incl_items_no_activity '||G_incl_items_no_activity);
323: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_comb_pdr '||to_char(G_comb_pdr));
324: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_comb_pdr_temp '||G_comb_pdr_temp);
325: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_comb_pdr_locale '||G_comb_pdr_locale);
326: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_vert_pdr '||to_char(G_vert_pdr));

Line 323: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_comb_pdr '||to_char(G_comb_pdr));

319: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_abc_class_low '||G_abc_class_low);
320: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_abc_class_high '||G_abc_class_high);
321: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_cutoff_date '||TO_CHAR(G_cutoff_date,'DD-MON-YYYY'));
322: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_incl_items_no_activity '||G_incl_items_no_activity);
323: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_comb_pdr '||to_char(G_comb_pdr));
324: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_comb_pdr_temp '||G_comb_pdr_temp);
325: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_comb_pdr_locale '||G_comb_pdr_locale);
326: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_vert_pdr '||to_char(G_vert_pdr));
327: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_vert_pdr_temp '||G_vert_pdr_temp);

Line 324: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_comb_pdr_temp '||G_comb_pdr_temp);

320: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_abc_class_high '||G_abc_class_high);
321: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_cutoff_date '||TO_CHAR(G_cutoff_date,'DD-MON-YYYY'));
322: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_incl_items_no_activity '||G_incl_items_no_activity);
323: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_comb_pdr '||to_char(G_comb_pdr));
324: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_comb_pdr_temp '||G_comb_pdr_temp);
325: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_comb_pdr_locale '||G_comb_pdr_locale);
326: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_vert_pdr '||to_char(G_vert_pdr));
327: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_vert_pdr_temp '||G_vert_pdr_temp);
328: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_vert_pdr_locale '||G_vert_pdr_locale);

Line 325: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_comb_pdr_locale '||G_comb_pdr_locale);

321: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_cutoff_date '||TO_CHAR(G_cutoff_date,'DD-MON-YYYY'));
322: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_incl_items_no_activity '||G_incl_items_no_activity);
323: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_comb_pdr '||to_char(G_comb_pdr));
324: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_comb_pdr_temp '||G_comb_pdr_temp);
325: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_comb_pdr_locale '||G_comb_pdr_locale);
326: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_vert_pdr '||to_char(G_vert_pdr));
327: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_vert_pdr_temp '||G_vert_pdr_temp);
328: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_vert_pdr_locale '||G_vert_pdr_locale);
329: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_horiz_pdr '||to_char(G_horiz_pdr));

Line 326: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_vert_pdr '||to_char(G_vert_pdr));

322: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_incl_items_no_activity '||G_incl_items_no_activity);
323: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_comb_pdr '||to_char(G_comb_pdr));
324: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_comb_pdr_temp '||G_comb_pdr_temp);
325: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_comb_pdr_locale '||G_comb_pdr_locale);
326: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_vert_pdr '||to_char(G_vert_pdr));
327: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_vert_pdr_temp '||G_vert_pdr_temp);
328: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_vert_pdr_locale '||G_vert_pdr_locale);
329: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_horiz_pdr '||to_char(G_horiz_pdr));
330: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_horiz_pdr_temp '||G_horiz_pdr_temp);

Line 327: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_vert_pdr_temp '||G_vert_pdr_temp);

323: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_comb_pdr '||to_char(G_comb_pdr));
324: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_comb_pdr_temp '||G_comb_pdr_temp);
325: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_comb_pdr_locale '||G_comb_pdr_locale);
326: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_vert_pdr '||to_char(G_vert_pdr));
327: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_vert_pdr_temp '||G_vert_pdr_temp);
328: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_vert_pdr_locale '||G_vert_pdr_locale);
329: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_horiz_pdr '||to_char(G_horiz_pdr));
330: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_horiz_pdr_temp '||G_horiz_pdr_temp);
331: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_horiz_pdr_locale '||G_horiz_pdr_locale);

Line 328: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_vert_pdr_locale '||G_vert_pdr_locale);

324: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_comb_pdr_temp '||G_comb_pdr_temp);
325: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_comb_pdr_locale '||G_comb_pdr_locale);
326: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_vert_pdr '||to_char(G_vert_pdr));
327: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_vert_pdr_temp '||G_vert_pdr_temp);
328: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_vert_pdr_locale '||G_vert_pdr_locale);
329: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_horiz_pdr '||to_char(G_horiz_pdr));
330: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_horiz_pdr_temp '||G_horiz_pdr_temp);
331: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_horiz_pdr_locale '||G_horiz_pdr_locale);
332: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_excep_pdr '||to_char(G_excep_pdr));

Line 329: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_horiz_pdr '||to_char(G_horiz_pdr));

325: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_comb_pdr_locale '||G_comb_pdr_locale);
326: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_vert_pdr '||to_char(G_vert_pdr));
327: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_vert_pdr_temp '||G_vert_pdr_temp);
328: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_vert_pdr_locale '||G_vert_pdr_locale);
329: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_horiz_pdr '||to_char(G_horiz_pdr));
330: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_horiz_pdr_temp '||G_horiz_pdr_temp);
331: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_horiz_pdr_locale '||G_horiz_pdr_locale);
332: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_excep_pdr '||to_char(G_excep_pdr));
333: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_excep_pdr_temp '||G_excep_pdr_temp);

Line 330: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_horiz_pdr_temp '||G_horiz_pdr_temp);

326: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_vert_pdr '||to_char(G_vert_pdr));
327: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_vert_pdr_temp '||G_vert_pdr_temp);
328: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_vert_pdr_locale '||G_vert_pdr_locale);
329: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_horiz_pdr '||to_char(G_horiz_pdr));
330: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_horiz_pdr_temp '||G_horiz_pdr_temp);
331: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_horiz_pdr_locale '||G_horiz_pdr_locale);
332: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_excep_pdr '||to_char(G_excep_pdr));
333: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_excep_pdr_temp '||G_excep_pdr_temp);
334: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_excep_pdr_locale '||G_excep_pdr_locale);

Line 331: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_horiz_pdr_locale '||G_horiz_pdr_locale);

327: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_vert_pdr_temp '||G_vert_pdr_temp);
328: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_vert_pdr_locale '||G_vert_pdr_locale);
329: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_horiz_pdr '||to_char(G_horiz_pdr));
330: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_horiz_pdr_temp '||G_horiz_pdr_temp);
331: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_horiz_pdr_locale '||G_horiz_pdr_locale);
332: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_excep_pdr '||to_char(G_excep_pdr));
333: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_excep_pdr_temp '||G_excep_pdr_temp);
334: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_excep_pdr_locale '||G_excep_pdr_locale);
335: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_act_pdr '||to_char(G_act_pdr));

Line 332: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_excep_pdr '||to_char(G_excep_pdr));

328: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_vert_pdr_locale '||G_vert_pdr_locale);
329: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_horiz_pdr '||to_char(G_horiz_pdr));
330: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_horiz_pdr_temp '||G_horiz_pdr_temp);
331: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_horiz_pdr_locale '||G_horiz_pdr_locale);
332: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_excep_pdr '||to_char(G_excep_pdr));
333: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_excep_pdr_temp '||G_excep_pdr_temp);
334: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_excep_pdr_locale '||G_excep_pdr_locale);
335: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_act_pdr '||to_char(G_act_pdr));
336: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_act_pdr_temp '||G_act_pdr_temp);

Line 333: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_excep_pdr_temp '||G_excep_pdr_temp);

329: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_horiz_pdr '||to_char(G_horiz_pdr));
330: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_horiz_pdr_temp '||G_horiz_pdr_temp);
331: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_horiz_pdr_locale '||G_horiz_pdr_locale);
332: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_excep_pdr '||to_char(G_excep_pdr));
333: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_excep_pdr_temp '||G_excep_pdr_temp);
334: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_excep_pdr_locale '||G_excep_pdr_locale);
335: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_act_pdr '||to_char(G_act_pdr));
336: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_act_pdr_temp '||G_act_pdr_temp);
337: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_act_pdr_locale '||G_act_pdr_locale);

Line 334: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_excep_pdr_locale '||G_excep_pdr_locale);

330: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_horiz_pdr_temp '||G_horiz_pdr_temp);
331: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_horiz_pdr_locale '||G_horiz_pdr_locale);
332: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_excep_pdr '||to_char(G_excep_pdr));
333: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_excep_pdr_temp '||G_excep_pdr_temp);
334: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_excep_pdr_locale '||G_excep_pdr_locale);
335: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_act_pdr '||to_char(G_act_pdr));
336: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_act_pdr_temp '||G_act_pdr_temp);
337: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_act_pdr_locale '||G_act_pdr_locale);
338:

Line 335: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_act_pdr '||to_char(G_act_pdr));

331: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_horiz_pdr_locale '||G_horiz_pdr_locale);
332: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_excep_pdr '||to_char(G_excep_pdr));
333: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_excep_pdr_temp '||G_excep_pdr_temp);
334: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_excep_pdr_locale '||G_excep_pdr_locale);
335: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_act_pdr '||to_char(G_act_pdr));
336: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_act_pdr_temp '||G_act_pdr_temp);
337: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_act_pdr_locale '||G_act_pdr_locale);
338:
339: /* Bug 5708728 with the new new parameters to the report when

Line 336: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_act_pdr_temp '||G_act_pdr_temp);

332: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_excep_pdr '||to_char(G_excep_pdr));
333: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_excep_pdr_temp '||G_excep_pdr_temp);
334: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_excep_pdr_locale '||G_excep_pdr_locale);
335: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_act_pdr '||to_char(G_act_pdr));
336: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_act_pdr_temp '||G_act_pdr_temp);
337: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_act_pdr_locale '||G_act_pdr_locale);
338:
339: /* Bug 5708728 with the new new parameters to the report when
340: combined pdr is submitted the four individual report indicators are either

Line 337: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_act_pdr_locale '||G_act_pdr_locale);

333: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_excep_pdr_temp '||G_excep_pdr_temp);
334: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_excep_pdr_locale '||G_excep_pdr_locale);
335: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_act_pdr '||to_char(G_act_pdr));
336: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_act_pdr_temp '||G_act_pdr_temp);
337: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_act_pdr_locale '||G_act_pdr_locale);
338:
339: /* Bug 5708728 with the new new parameters to the report when
340: combined pdr is submitted the four individual report indicators are either
341: NULL or 2 thereby not printing information

Line 355: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' Splitting the Planning detail report on Organization basis ');

351:
352: validate_parameters;
353:
354: IF split_report = 'Y' THEN
355: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' Splitting the Planning detail report on Organization basis ');
356: END IF;
357:
358: -- Bug: 9458217 Vpedarla setup
359: OPEN org_select(G_plan_id, G_inst_id, p_plan_org);

Line 367: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' Generating report for Org id '||G_plan_org);

363:
364: IF split_report <> 'Y' THEN
365: G_plan_org := p_plan_org ;
366: ELSE
367: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' Generating report for Org id '||G_plan_org);
368: END IF;
369:
370: insert_items;
371:

Line 372: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' After insert_items Items_count: '||Items_count);

368: END IF;
369:
370: insert_items;
371:
372: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' After insert_items Items_count: '||Items_count);
373:
374: -- INSERT INTO pdr_items_gtmp SELECT * FROM gmp_pdr_items_gtmp;
375:
376: -- Vpedarla bug: 9366921

Line 382: -- FND_FILE.PUT_LINE ( FND_FILE.LOG, ' Calling gmp_horizontal_pdr_pkg.populate_horizontal_plan '||

378:
379: -- Bug 9338193 Vpedarla Added the below condition.
380: IF G_horiz_pdr = 1 THEN
381:
382: -- FND_FILE.PUT_LINE ( FND_FILE.LOG, ' Calling gmp_horizontal_pdr_pkg.populate_horizontal_plan '||
383: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' Calling populate horizontal plan '||
384: ' with parameters : G_inst_id - '||to_char(G_inst_id)||' G_org_id - '||to_char(G_org_id)||
385: ' G_plan_id - '|| to_char(G_plan_id) ||
386: ' G_day_bckt_cutoff_dt - '||to_char(G_day_bckt_cutoff_dt, 'MM-DD-YYYY HH:MI:SS')||

Line 383: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' Calling populate horizontal plan '||

379: -- Bug 9338193 Vpedarla Added the below condition.
380: IF G_horiz_pdr = 1 THEN
381:
382: -- FND_FILE.PUT_LINE ( FND_FILE.LOG, ' Calling gmp_horizontal_pdr_pkg.populate_horizontal_plan '||
383: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' Calling populate horizontal plan '||
384: ' with parameters : G_inst_id - '||to_char(G_inst_id)||' G_org_id - '||to_char(G_org_id)||
385: ' G_plan_id - '|| to_char(G_plan_id) ||
386: ' G_day_bckt_cutoff_dt - '||to_char(G_day_bckt_cutoff_dt, 'MM-DD-YYYY HH:MI:SS')||
387: ' G_week_bckt_cutoff_dt - '||to_char(G_week_bckt_cutoff_dt, 'MM-DD-YYYY HH:MI:SS')||

Line 394: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' After gmp_horizontal_pdr_pkg.populate_horizontal_plan ');

390: -- Bug: 8486531 Vpedarla added new parameter G_incl_items_no_activity to populate_horizontal_plan procedure call.
391: gmp_horizontal_pdr_pkg.populate_horizontal_plan (G_inst_id, G_org_id, G_plan_id,
392: G_day_bckt_cutoff_dt, G_week_bckt_cutoff_dt, G_period_bucket, G_incl_items_no_activity);
393:
394: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' After gmp_horizontal_pdr_pkg.populate_horizontal_plan ');
395: -- INSERT INTO horizontal_pdr_gtmp SELECT * FROM gmp_horizontal_pdr_gtmp;
396:
397: SELECT count(*) into Horiz_details_count FROM gmp_horizontal_pdr_gtmp;
398: gmp_debug_message(' Horiz_details_count = '|| Horiz_details_count );

Line 402: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' Skipping populate horizontal plan ');

398: gmp_debug_message(' Horiz_details_count = '|| Horiz_details_count );
399:
400: ELSE
401:
402: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' Skipping populate horizontal plan ');
403:
404: END IF;
405: -- end of Bug 9338193.
406:

Line 409: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' After horiz plan stmt ');

405: -- end of Bug 9338193.
406:
407: IF G_horiz_pdr = 1 THEN
408: horiz_plan_stmt;
409: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' After horiz plan stmt ');
410: END IF;
411:
412: IF G_vert_pdr = 1 THEN
413: vert_plan_stmt;

Line 414: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' After vert plan stmt ');

410: END IF;
411:
412: IF G_vert_pdr = 1 THEN
413: vert_plan_stmt;
414: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' After vert plan stmt ');
415: END IF;
416:
417: IF G_excep_pdr = 1 THEN
418: item_exception_stmt;

Line 419: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' After item exception stmt ');

415: END IF;
416:
417: IF G_excep_pdr = 1 THEN
418: item_exception_stmt;
419: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' After item exception stmt ');
420: END IF ;
421:
422: IF G_act_pdr = 1 THEN
423: item_action_stmt;

Line 424: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' After item action stmt ');

420: END IF ;
421:
422: IF G_act_pdr = 1 THEN
423: item_action_stmt;
424: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' After item action stmt ');
425: END IF ;
426:
427: generate_xml;
428: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' After generate xml ');

Line 428: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' After generate xml ');

424: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' After item action stmt ');
425: END IF ;
426:
427: generate_xml;
428: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' After generate xml ');
429:
430: ELSE
431:
432: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' No Items are present for the given report parameters. ');

Line 432: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' No Items are present for the given report parameters. ');

428: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' After generate xml ');
429:
430: ELSE
431:
432: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' No Items are present for the given report parameters. ');
433:
434: END IF ;
435: -- Vpedarla end of bug: 9366921
436:

Line 448: FND_FILE.PUT_LINE ( FND_FILE.LOG,' Error in package GMP_PLNG_DTL_REPORT_PKG.CREATE_PDR - '|| sqlerrm);

444:
445:
446: EXCEPTION
447: WHEN OTHERS THEN
448: FND_FILE.PUT_LINE ( FND_FILE.LOG,' Error in package GMP_PLNG_DTL_REPORT_PKG.CREATE_PDR - '|| sqlerrm);
449: RAISE;
450: END create_pdr;
451:
452: PROCEDURE validate_parameters IS

Line 456: FND_FILE.PUT_LINE(FND_FILE.LOG,'Please specify the Template and Locale for Combined Planning Detail Report ');

452: PROCEDURE validate_parameters IS
453: BEGIN
454: IF G_comb_pdr = 1 THEN
455: IF G_comb_pdr_temp IS NULL OR G_comb_pdr_locale IS NULL THEN
456: FND_FILE.PUT_LINE(FND_FILE.LOG,'Please specify the Template and Locale for Combined Planning Detail Report ');
457: RAISE invalid_parameter;
458: END IF;
459: ELSIF G_comb_pdr = 2 THEN
460: IF G_horiz_pdr = 1 THEN

Line 462: FND_FILE.PUT_LINE(FND_FILE.LOG,'Please specify the Template and Locale for Horizontal Planning Detail Report ');

458: END IF;
459: ELSIF G_comb_pdr = 2 THEN
460: IF G_horiz_pdr = 1 THEN
461: IF G_horiz_pdr_temp IS NULL OR G_horiz_pdr_locale IS NULL THEN
462: FND_FILE.PUT_LINE(FND_FILE.LOG,'Please specify the Template and Locale for Horizontal Planning Detail Report ');
463: RAISE invalid_parameter;
464: END IF;
465: END IF;
466: IF G_vert_pdr = 1 THEN

Line 468: FND_FILE.PUT_LINE(FND_FILE.LOG,'Please specify the Template and Locale for Vertical Planning Detail Report ');

464: END IF;
465: END IF;
466: IF G_vert_pdr = 1 THEN
467: IF G_vert_pdr_temp IS NULL OR G_vert_pdr_locale IS NULL THEN
468: FND_FILE.PUT_LINE(FND_FILE.LOG,'Please specify the Template and Locale for Vertical Planning Detail Report ');
469: RAISE invalid_parameter;
470: END IF;
471: END IF;
472: IF G_excep_pdr = 1 THEN

Line 474: FND_FILE.PUT_LINE(FND_FILE.LOG,'Please specify the Template and Locale for Exception Planning Detail Report ');

470: END IF;
471: END IF;
472: IF G_excep_pdr = 1 THEN
473: IF G_excep_pdr_temp IS NULL OR G_excep_pdr_locale IS NULL THEN
474: FND_FILE.PUT_LINE(FND_FILE.LOG,'Please specify the Template and Locale for Exception Planning Detail Report ');
475: RAISE invalid_parameter;
476: END IF;
477: END IF;
478: IF G_act_pdr = 1 THEN

Line 480: FND_FILE.PUT_LINE(FND_FILE.LOG,'Please specify the Template and Locale for Action Planning Detail Report ');

476: END IF;
477: END IF;
478: IF G_act_pdr = 1 THEN
479: IF G_act_pdr_temp IS NULL OR G_act_pdr_locale IS NULL THEN
480: FND_FILE.PUT_LINE(FND_FILE.LOG,'Please specify the Template and Locale for Action Planning Detail Report ');
481: RAISE invalid_parameter;
482: END IF;
483: END IF;
484: END IF;

Line 487: FND_FILE.PUT_LINE ( FND_FILE.LOG,'Error in validate_parameters: Invalid Parameters submitted ');

483: END IF;
484: END IF;
485: EXCEPTION
486: WHEN invalid_parameter THEN
487: FND_FILE.PUT_LINE ( FND_FILE.LOG,'Error in validate_parameters: Invalid Parameters submitted ');
488: RAISE;
489: END validate_parameters;
490:
491: PROCEDURE insert_items IS

Line 663: FND_FILE.PUT_LINE(FND_FILE.LOG,' Item query - '||x_select );

659: dbms_sql.bind_variable(cur_item, ':third_sort', G_tsort);
660: END IF;
661: */
662:
663: FND_FILE.PUT_LINE(FND_FILE.LOG,' Item query - '||x_select );
664:
665: X_row_count := dbms_sql.EXECUTE (cur_item);
666:
667: -- Vpedarla bug: 9366921

Line 670: FND_FILE.PUT_LINE(FND_FILE.LOG,'Num of rows in gmp_pdr_items_gtmp '||to_char(X_row_count));

666:
667: -- Vpedarla bug: 9366921
668: Items_count := X_row_count ;
669:
670: FND_FILE.PUT_LINE(FND_FILE.LOG,'Num of rows in gmp_pdr_items_gtmp '||to_char(X_row_count));
671:
672: dbms_sql.close_cursor (cur_item);
673:
674: EXCEPTION

Line 676: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in package GMP_PLNG_DTL_REPORT_PKG '||sqlerrm);

672: dbms_sql.close_cursor (cur_item);
673:
674: EXCEPTION
675: WHEN OTHERS THEN
676: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in package GMP_PLNG_DTL_REPORT_PKG '||sqlerrm);
677: IF dbms_sql.is_open (cur_item) THEN
678: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION cur_item is Open');
679: dbms_sql.close_cursor (cur_item);
680: END IF;

Line 678: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION cur_item is Open');

674: EXCEPTION
675: WHEN OTHERS THEN
676: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in package GMP_PLNG_DTL_REPORT_PKG '||sqlerrm);
677: IF dbms_sql.is_open (cur_item) THEN
678: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION cur_item is Open');
679: dbms_sql.close_cursor (cur_item);
680: END IF;
681: END insert_items;
682:

Line 792: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in procedure item_exception_stmt '||sqlerrm);

788: ' gmp_horizontal_pdr_gtmp ghp ) ';
789:
790: EXCEPTION
791: WHEN OTHERS THEN
792: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in procedure item_exception_stmt '||sqlerrm);
793: END horiz_plan_stmt;
794:
795: PROCEDURE vert_plan_stmt IS
796:

Line 1024: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in procedure vert_plan_stmt '||sqlerrm);

1020: /* Global Var */
1021:
1022: EXCEPTION
1023: WHEN OTHERS THEN
1024: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in procedure vert_plan_stmt '||sqlerrm);
1025: END vert_plan_stmt;
1026:
1027: PROCEDURE item_exception_stmt IS
1028:

Line 1083: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in procedure item_exception_stmt '||sqlerrm);

1079: ' AND nvl(med.category_set_id, '||G_cat_set_id ||') = '|| G_cat_set_id ||
1080: ' AND med.organization_id = gpi.organization_id )' ;
1081: EXCEPTION
1082: WHEN OTHERS THEN
1083: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in procedure item_exception_stmt '||sqlerrm);
1084: END item_exception_stmt;
1085:
1086: PROCEDURE item_action_stmt IS
1087:

Line 1186: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in procedure item_action_stmt '||sqlerrm);

1182: ' AND TRUNC (cal.calendar_date) <= (NVL (TRUNC(TO_DATE('||''''||TO_CHAR(G_cutoff_date, 'YYYY/MM/DD HH24:MI:SS')||''''||', '||''''||'YYYY/MM/DD HH24:MI:SS'||''''||')), TRUNC (cal.calendar_date))) ) ';
1183:
1184: EXCEPTION
1185: WHEN OTHERS THEN
1186: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in procedure item_action_stmt '||sqlerrm);
1187: END item_action_stmt;
1188:
1189: PROCEDURE generate_xml IS
1190:

Line 1212: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_xml_header - '||l_xml_header);

1208: -- The following line of code ensures that XML data
1209: -- generated here uses the right encoding
1210: l_encoding := fnd_profile.value('ICX_CLIENT_IANA_ENCODING');
1211: l_xml_header := '';
1212: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_xml_header - '||l_xml_header);
1213: -- B7481907 Rajesh Patangya starts
1214:
1215: G_header_stmt := ' SELECT ' ||
1216: ' msc_get_name.org_code ('||G_org_id||', '||G_inst_id||' ) master_org, '||

Line 1297: FND_FILE.PUT_LINE(FND_FILE.LOG,'in combined PDR');

1293:
1294: G_common_pdr_stmt := NULL ;
1295:
1296: -- INSERT INTO ns_debug (LONGVAL) values ('in combined PDR');
1297: FND_FILE.PUT_LINE(FND_FILE.LOG,'in combined PDR');
1298:
1299: G_common_pdr_stmt := G_common_pdr_stmt || G_header_stmt;
1300:
1301: -- Vpedarla bug: 8273098 modified the order of columns based on order by clause from parameters.

Line 1313: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in horiz cursor stmt '||sqlerrm);

1309: ' WHERE gpi.inventory_item_id = horiz.inventory_item_id '||
1310: ' AND gpi.organization_id = horiz.organization_id ) horiz ';
1311: EXCEPTION
1312: when others then
1313: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in horiz cursor stmt '||sqlerrm);
1314: END ;
1315: END IF;
1316:
1317: IF G_vert_pdr = 1 THEN

Line 1325: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in vert cursor stmt '||sqlerrm);

1321: ' WHERE gpi.inventory_item_id = vert.inventory_item_id '||
1322: ' AND gpi.organization_id = vert.organization_id ) vert ';
1323: EXCEPTION
1324: when others then
1325: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in vert cursor stmt '||sqlerrm);
1326: END ;
1327: END IF;
1328:
1329: IF G_excep_pdr = 1 THEN

Line 1337: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in exc cursor stmt '||sqlerrm);

1333: ' WHERE gpi.inventory_item_id = exc.inventory_item_id '||
1334: ' AND gpi.organization_id = exc.organization_id ) exc ';
1335: EXCEPTION
1336: when others then
1337: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in exc cursor stmt '||sqlerrm);
1338: END ;
1339: END IF;
1340:
1341: IF G_act_pdr = 1 THEN

Line 1349: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in act cursor stmt '||sqlerrm);

1345: ' WHERE gpi.inventory_item_id = act.inventory_item_id '||
1346: ' AND gpi.organization_id = act.organization_id ) act ';
1347: EXCEPTION
1348: when others then
1349: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in act cursor stmt '||sqlerrm);
1350: END ;
1351: END IF;
1352:
1353: G_common_pdr_stmt := G_common_pdr_stmt || ' FROM gmp_pdr_items_gtmp gpi ';

Line 1385: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_offset - '||l_offset);

1381: l_offset := DBMS_LOB.INSTR (lob_loc => temp_clob,
1382: pattern => '>',
1383: offset => 1,
1384: nth => 1);
1385: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_offset - '||l_offset);
1386:
1387: -- Remove the header
1388: DBMS_LOB.erase (temp_clob, l_offset,1);
1389:

Line 1463: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_offset - '||l_offset);

1459: l_offset := DBMS_LOB.INSTR (lob_loc => temp_clob,
1460: pattern => '>',
1461: offset => 1,
1462: nth => 1);
1463: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_offset - '||l_offset);
1464:
1465: -- Remove the header
1466: DBMS_LOB.erase (temp_clob, l_offset,1);
1467:

Line 1535: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_offset - '||l_offset);

1531: l_offset := DBMS_LOB.INSTR (lob_loc => temp_clob,
1532: pattern => '>',
1533: offset => 1,
1534: nth => 1);
1535: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_offset - '||l_offset);
1536:
1537: -- Remove the header
1538: DBMS_LOB.erase (temp_clob, l_offset,1);
1539:

Line 1607: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_offset - '||l_offset);

1603: l_offset := DBMS_LOB.INSTR (lob_loc => temp_clob,
1604: pattern => '>',
1605: offset => 1,
1606: nth => 1);
1607: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_offset - '||l_offset);
1608:
1609: -- Remove the header
1610: DBMS_LOB.erase (temp_clob, l_offset,1);
1611:

Line 1680: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_offset - '||l_offset);

1676: l_offset := DBMS_LOB.INSTR (lob_loc => temp_clob,
1677: pattern => '>',
1678: offset => 1,
1679: nth => 1);
1680: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_offset - '||l_offset);
1681:
1682: -- Remove the header
1683: DBMS_LOB.erase (temp_clob, l_offset,1);
1684:

Line 1712: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in procedure generate_xml '||sqlerrm);

1708: END IF; /* Combined PDR */
1709:
1710: EXCEPTION
1711: WHEN OTHERS THEN
1712: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in procedure generate_xml '||sqlerrm);
1713:
1714: END generate_xml;
1715:
1716: FUNCTION plan_name RETURN VARCHAR2 IS

Line 1728: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in function plan_name '||sqlerrm);

1724:
1725: RETURN plan_name;
1726:
1727: EXCEPTION WHEN OTHERS THEN
1728: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in function plan_name '||sqlerrm);
1729: END plan_name;
1730:
1731: FUNCTION plan_org ( org_id IN NUMBER) RETURN VARCHAR2 IS
1732: org_code VARCHAR2(40);

Line 1756: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in function plan_org '||sqlerrm);

1752:
1753: RETURN org_code;
1754:
1755: EXCEPTION WHEN OTHERS THEN
1756: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in function plan_org '||sqlerrm);
1757: END plan_org;
1758:
1759: FUNCTION category_set_name ( cat_set_id IN NUMBER) RETURN VARCHAR2 IS
1760: cat_set_name VARCHAR2(35);

Line 1772: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in function category_set_name '||sqlerrm);

1768:
1769: RETURN cat_set_name;
1770:
1771: EXCEPTION WHEN OTHERS THEN
1772: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in function category_set_name '||sqlerrm);
1773: END category_set_name;
1774:
1775: FUNCTION lookup_meaning(l_lookup_type IN VARCHAR2,
1776: l_lookup_code IN NUMBER) RETURN VARCHAR2 IS

Line 1839: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in retrieving default output type '||sqlerrm);

1835: gmp_debug_message(' Default output type-- '||l_def_output_type);
1836:
1837:
1838: EXCEPTION WHEN OTHERS THEN
1839: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in retrieving default output type '||sqlerrm);
1840: END;
1841:
1842: gmp_debug_message(' ps_generate_output called with p_pdr_type '||p_pdr_type);
1843:

Line 1857: FND_FILE.PUT_LINE ( FND_FILE.LOG,l_log_text);

1853: '','','','','','','','','','');
1854:
1855: IF l_conc_id = 0 THEN
1856: l_log_text := FND_MESSAGE.GET;
1857: FND_FILE.PUT_LINE ( FND_FILE.LOG,l_log_text);
1858: ELSE
1859: COMMIT ;
1860: END IF;
1861:

Line 1862: -- FND_FILE.PUT_LINE ( FND_FILE.LOG, 'l_conc_id : '||to_char(l_conc_id));

1858: ELSE
1859: COMMIT ;
1860: END IF;
1861:
1862: -- FND_FILE.PUT_LINE ( FND_FILE.LOG, 'l_conc_id : '||to_char(l_conc_id));
1863: IF l_conc_id <> 0 THEN
1864:
1865: l_status := fnd_concurrent.WAIT_FOR_REQUEST
1866: (

Line 1884: -- FND_FILE.PUT_LINE ( FND_FILE.LOG, 'p_pdr_type = '||to_char(p_pdr_type));

1880: DELETE FROM gmp_pdr_xml_temp WHERE pdr_xml_id = p_sequence_num;
1881: COMMIT;
1882:
1883:
1884: -- FND_FILE.PUT_LINE ( FND_FILE.LOG, 'p_pdr_type = '||to_char(p_pdr_type));
1885:
1886: IF p_pdr_type = 1 THEN
1887:
1888: /* Bug: 6609251 Vpedarla added a NULL parameters for the submition of the FND request for XDOREPPB */

Line 1975: FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Exception in procedure ps_generate_output '||SQLERRM);

1971: END IF;
1972:
1973: EXCEPTION
1974: WHEN OTHERS THEN
1975: FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Exception in procedure ps_generate_output '||SQLERRM);
1976: END ps_generate_output;
1977:
1978: /* ***************************************************************
1979: * NAME

Line 2023: FND_FILE.PUT(FND_FILE.OUTPUT, file_varchar2);

2019: M_FILE := DBMS_LOB.SUBSTR (l_file,1024,l_limit);
2020: -- Vpedarla 8605434
2021: -- file_varchar2:=trim(M_FILE);
2022: file_varchar2:=M_FILE;
2023: FND_FILE.PUT(FND_FILE.OUTPUT, file_varchar2);
2024: FND_FILE.PUT(FND_FILE.LOG,file_varchar2);
2025: If l_limit < 1026 THEN
2026: gmp_debug_message(' l_limit '||l_limit||'**' || file_varchar2 );
2027: END IF;

Line 2024: FND_FILE.PUT(FND_FILE.LOG,file_varchar2);

2020: -- Vpedarla 8605434
2021: -- file_varchar2:=trim(M_FILE);
2022: file_varchar2:=M_FILE;
2023: FND_FILE.PUT(FND_FILE.OUTPUT, file_varchar2);
2024: FND_FILE.PUT(FND_FILE.LOG,file_varchar2);
2025: If l_limit < 1026 THEN
2026: gmp_debug_message(' l_limit '||l_limit||'**' || file_varchar2 );
2027: END IF;
2028: file_varchar2 := NULL;

Line 2037: FND_FILE.PUT(FND_FILE.OUTPUT, file_varchar2);

2033: M_FILE := DBMS_LOB.SUBSTR (l_file,1024,l_limit);
2034: -- Vpedarla 8605434
2035: -- file_varchar2:=trim(M_FILE);
2036: file_varchar2:=M_FILE;
2037: FND_FILE.PUT(FND_FILE.OUTPUT, file_varchar2);
2038: FND_FILE.PUT(FND_FILE.LOG,file_varchar2);
2039: file_varchar2 := NULL;
2040: m_file :=NULL;
2041: EXIT;

Line 2038: FND_FILE.PUT(FND_FILE.LOG,file_varchar2);

2034: -- Vpedarla 8605434
2035: -- file_varchar2:=trim(M_FILE);
2036: file_varchar2:=M_FILE;
2037: FND_FILE.PUT(FND_FILE.OUTPUT, file_varchar2);
2038: FND_FILE.PUT(FND_FILE.LOG,file_varchar2);
2039: file_varchar2 := NULL;
2040: m_file :=NULL;
2041: EXIT;
2042: END IF;

Line 2047: FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Exception in procedure gmp_plng_dtl_report_pkg.xml_transfer '||SQLERRM);

2043: END LOOP;
2044: gmp_debug_message(' xml_transfer end of loop '|| to_char(sysdate, 'hh24:mi:ss'));
2045: EXCEPTION
2046: WHEN OTHERS THEN
2047: FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Exception in procedure gmp_plng_dtl_report_pkg.xml_transfer '||SQLERRM);
2048: END;
2049:
2050: /*
2051: REM+=========================================================================+

Line 2063: FND_FILE.PUT_LINE ( FND_FILE.LOG,pBUFF);

2059: */
2060: PROCEDURE gmp_debug_message(pBUFF IN VARCHAR2) IS
2061: BEGIN
2062: IF (l_debug = 'Y') then
2063: FND_FILE.PUT_LINE ( FND_FILE.LOG,pBUFF);
2064: END IF;
2065: END gmp_debug_message;
2066:
2067: END GMP_PLNG_DTL_REPORT_PKG;