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 119: FND_FILE.PUT_LINE ( FND_FILE.LOG, 'In GMP_PLNG_DTL_REPORT_PKG ');

115: p_act_pdr_locale IN VARCHAR2
116: ) IS
117: BEGIN
118:
119: FND_FILE.PUT_LINE ( FND_FILE.LOG, 'In GMP_PLNG_DTL_REPORT_PKG ');
120:
121: retcode := 0;
122: G_inst_id := p_inst_id ;
123: G_org_id := p_org_id ;

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

163: G_act_pdr := NVL(p_act_pdr,2) ;
164: G_act_pdr_temp := p_act_pdr_temp ;
165: G_act_pdr_locale := p_act_pdr_locale ;
166:
167: FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Calling GMP_PLNG_DTL_REPORT_PKG with values ');
168: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_inst_id '||to_char(G_inst_id));
169: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_org_id '||to_char(G_org_id));
170: -- FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_name '||G_plan_name);
171: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_id '||to_char(G_plan_id));

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

164: G_act_pdr_temp := p_act_pdr_temp ;
165: G_act_pdr_locale := p_act_pdr_locale ;
166:
167: FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Calling GMP_PLNG_DTL_REPORT_PKG with values ');
168: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_inst_id '||to_char(G_inst_id));
169: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_org_id '||to_char(G_org_id));
170: -- FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_name '||G_plan_name);
171: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_id '||to_char(G_plan_id));
172: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_org '||to_char(G_plan_org));

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

165: G_act_pdr_locale := p_act_pdr_locale ;
166:
167: FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Calling GMP_PLNG_DTL_REPORT_PKG with values ');
168: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_inst_id '||to_char(G_inst_id));
169: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_org_id '||to_char(G_org_id));
170: -- FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_name '||G_plan_name);
171: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_id '||to_char(G_plan_id));
172: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_org '||to_char(G_plan_org));
173: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_start_date '||TO_CHAR(G_start_date,'DD-MON-YYYY'));

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

166:
167: FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Calling GMP_PLNG_DTL_REPORT_PKG with values ');
168: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_inst_id '||to_char(G_inst_id));
169: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_org_id '||to_char(G_org_id));
170: -- FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_name '||G_plan_name);
171: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_id '||to_char(G_plan_id));
172: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_org '||to_char(G_plan_org));
173: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_start_date '||TO_CHAR(G_start_date,'DD-MON-YYYY'));
174: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_day_bucket '||to_char(G_day_bucket));

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

167: FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Calling GMP_PLNG_DTL_REPORT_PKG with values ');
168: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_inst_id '||to_char(G_inst_id));
169: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_org_id '||to_char(G_org_id));
170: -- FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_name '||G_plan_name);
171: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_id '||to_char(G_plan_id));
172: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_org '||to_char(G_plan_org));
173: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_start_date '||TO_CHAR(G_start_date,'DD-MON-YYYY'));
174: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_day_bucket '||to_char(G_day_bucket));
175: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_day_bckt_cutoff_dt '||TO_CHAR(G_day_bckt_cutoff_dt,'DD-MON-YYYY'));

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

168: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_inst_id '||to_char(G_inst_id));
169: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_org_id '||to_char(G_org_id));
170: -- FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_name '||G_plan_name);
171: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_id '||to_char(G_plan_id));
172: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_org '||to_char(G_plan_org));
173: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_start_date '||TO_CHAR(G_start_date,'DD-MON-YYYY'));
174: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_day_bucket '||to_char(G_day_bucket));
175: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_day_bckt_cutoff_dt '||TO_CHAR(G_day_bckt_cutoff_dt,'DD-MON-YYYY'));
176: 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 173: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_start_date '||TO_CHAR(G_start_date,'DD-MON-YYYY'));

169: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_org_id '||to_char(G_org_id));
170: -- FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_name '||G_plan_name);
171: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_id '||to_char(G_plan_id));
172: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_org '||to_char(G_plan_org));
173: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_start_date '||TO_CHAR(G_start_date,'DD-MON-YYYY'));
174: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_day_bucket '||to_char(G_day_bucket));
175: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_day_bckt_cutoff_dt '||TO_CHAR(G_day_bckt_cutoff_dt,'DD-MON-YYYY'));
176: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_day_bckt_cutoff_dt '||TO_CHAR(G_plan_day_bckt_cutoff_dt,'DD-MON-YYYY'));
177: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_week_bucket '||to_char(G_week_bucket));

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

170: -- FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_name '||G_plan_name);
171: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_id '||to_char(G_plan_id));
172: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_org '||to_char(G_plan_org));
173: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_start_date '||TO_CHAR(G_start_date,'DD-MON-YYYY'));
174: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_day_bucket '||to_char(G_day_bucket));
175: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_day_bckt_cutoff_dt '||TO_CHAR(G_day_bckt_cutoff_dt,'DD-MON-YYYY'));
176: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_day_bckt_cutoff_dt '||TO_CHAR(G_plan_day_bckt_cutoff_dt,'DD-MON-YYYY'));
177: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_week_bucket '||to_char(G_week_bucket));
178: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_week_bckt_cutoff_dt '||TO_CHAR(G_week_bckt_cutoff_dt,'DD-MON-YYYY'));

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

171: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_id '||to_char(G_plan_id));
172: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_org '||to_char(G_plan_org));
173: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_start_date '||TO_CHAR(G_start_date,'DD-MON-YYYY'));
174: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_day_bucket '||to_char(G_day_bucket));
175: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_day_bckt_cutoff_dt '||TO_CHAR(G_day_bckt_cutoff_dt,'DD-MON-YYYY'));
176: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_day_bckt_cutoff_dt '||TO_CHAR(G_plan_day_bckt_cutoff_dt,'DD-MON-YYYY'));
177: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_week_bucket '||to_char(G_week_bucket));
178: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_week_bckt_cutoff_dt '||TO_CHAR(G_week_bckt_cutoff_dt,'DD-MON-YYYY'));
179: 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 176: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_day_bckt_cutoff_dt '||TO_CHAR(G_plan_day_bckt_cutoff_dt,'DD-MON-YYYY'));

172: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_org '||to_char(G_plan_org));
173: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_start_date '||TO_CHAR(G_start_date,'DD-MON-YYYY'));
174: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_day_bucket '||to_char(G_day_bucket));
175: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_day_bckt_cutoff_dt '||TO_CHAR(G_day_bckt_cutoff_dt,'DD-MON-YYYY'));
176: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_day_bckt_cutoff_dt '||TO_CHAR(G_plan_day_bckt_cutoff_dt,'DD-MON-YYYY'));
177: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_week_bucket '||to_char(G_week_bucket));
178: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_week_bckt_cutoff_dt '||TO_CHAR(G_week_bckt_cutoff_dt,'DD-MON-YYYY'));
179: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_week_bckt_cutoff_dt '||TO_CHAR(G_plan_week_bckt_cutoff_dt,'DD-MON-YYYY'));
180: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_period_bucket '||to_char(G_period_bucket));

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

173: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_start_date '||TO_CHAR(G_start_date,'DD-MON-YYYY'));
174: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_day_bucket '||to_char(G_day_bucket));
175: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_day_bckt_cutoff_dt '||TO_CHAR(G_day_bckt_cutoff_dt,'DD-MON-YYYY'));
176: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_day_bckt_cutoff_dt '||TO_CHAR(G_plan_day_bckt_cutoff_dt,'DD-MON-YYYY'));
177: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_week_bucket '||to_char(G_week_bucket));
178: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_week_bckt_cutoff_dt '||TO_CHAR(G_week_bckt_cutoff_dt,'DD-MON-YYYY'));
179: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_week_bckt_cutoff_dt '||TO_CHAR(G_plan_week_bckt_cutoff_dt,'DD-MON-YYYY'));
180: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_period_bucket '||to_char(G_period_bucket));
181: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_fsort '||to_char(G_fsort));

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

174: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_day_bucket '||to_char(G_day_bucket));
175: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_day_bckt_cutoff_dt '||TO_CHAR(G_day_bckt_cutoff_dt,'DD-MON-YYYY'));
176: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_day_bckt_cutoff_dt '||TO_CHAR(G_plan_day_bckt_cutoff_dt,'DD-MON-YYYY'));
177: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_week_bucket '||to_char(G_week_bucket));
178: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_week_bckt_cutoff_dt '||TO_CHAR(G_week_bckt_cutoff_dt,'DD-MON-YYYY'));
179: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_week_bckt_cutoff_dt '||TO_CHAR(G_plan_week_bckt_cutoff_dt,'DD-MON-YYYY'));
180: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_period_bucket '||to_char(G_period_bucket));
181: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_fsort '||to_char(G_fsort));
182: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_ssort '||to_char(G_ssort));

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

175: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_day_bckt_cutoff_dt '||TO_CHAR(G_day_bckt_cutoff_dt,'DD-MON-YYYY'));
176: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_day_bckt_cutoff_dt '||TO_CHAR(G_plan_day_bckt_cutoff_dt,'DD-MON-YYYY'));
177: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_week_bucket '||to_char(G_week_bucket));
178: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_week_bckt_cutoff_dt '||TO_CHAR(G_week_bckt_cutoff_dt,'DD-MON-YYYY'));
179: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_week_bckt_cutoff_dt '||TO_CHAR(G_plan_week_bckt_cutoff_dt,'DD-MON-YYYY'));
180: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_period_bucket '||to_char(G_period_bucket));
181: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_fsort '||to_char(G_fsort));
182: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_ssort '||to_char(G_ssort));
183: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_tsort '||to_char(G_tsort));

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

176: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_day_bckt_cutoff_dt '||TO_CHAR(G_plan_day_bckt_cutoff_dt,'DD-MON-YYYY'));
177: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_week_bucket '||to_char(G_week_bucket));
178: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_week_bckt_cutoff_dt '||TO_CHAR(G_week_bckt_cutoff_dt,'DD-MON-YYYY'));
179: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_week_bckt_cutoff_dt '||TO_CHAR(G_plan_week_bckt_cutoff_dt,'DD-MON-YYYY'));
180: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_period_bucket '||to_char(G_period_bucket));
181: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_fsort '||to_char(G_fsort));
182: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_ssort '||to_char(G_ssort));
183: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_tsort '||to_char(G_tsort));
184: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_ex_typ '||to_char(G_ex_typ));

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

177: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_week_bucket '||to_char(G_week_bucket));
178: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_week_bckt_cutoff_dt '||TO_CHAR(G_week_bckt_cutoff_dt,'DD-MON-YYYY'));
179: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_week_bckt_cutoff_dt '||TO_CHAR(G_plan_week_bckt_cutoff_dt,'DD-MON-YYYY'));
180: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_period_bucket '||to_char(G_period_bucket));
181: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_fsort '||to_char(G_fsort));
182: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_ssort '||to_char(G_ssort));
183: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_tsort '||to_char(G_tsort));
184: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_ex_typ '||to_char(G_ex_typ));
185: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plnr_low '||G_plnr_low);

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

178: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_week_bckt_cutoff_dt '||TO_CHAR(G_week_bckt_cutoff_dt,'DD-MON-YYYY'));
179: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_week_bckt_cutoff_dt '||TO_CHAR(G_plan_week_bckt_cutoff_dt,'DD-MON-YYYY'));
180: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_period_bucket '||to_char(G_period_bucket));
181: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_fsort '||to_char(G_fsort));
182: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_ssort '||to_char(G_ssort));
183: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_tsort '||to_char(G_tsort));
184: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_ex_typ '||to_char(G_ex_typ));
185: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plnr_low '||G_plnr_low);
186: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plnr_high '||G_plnr_high);

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

179: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_week_bckt_cutoff_dt '||TO_CHAR(G_plan_week_bckt_cutoff_dt,'DD-MON-YYYY'));
180: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_period_bucket '||to_char(G_period_bucket));
181: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_fsort '||to_char(G_fsort));
182: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_ssort '||to_char(G_ssort));
183: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_tsort '||to_char(G_tsort));
184: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_ex_typ '||to_char(G_ex_typ));
185: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plnr_low '||G_plnr_low);
186: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plnr_high '||G_plnr_high);
187: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_byr_low '||G_byr_low);

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

180: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_period_bucket '||to_char(G_period_bucket));
181: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_fsort '||to_char(G_fsort));
182: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_ssort '||to_char(G_ssort));
183: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_tsort '||to_char(G_tsort));
184: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_ex_typ '||to_char(G_ex_typ));
185: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plnr_low '||G_plnr_low);
186: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plnr_high '||G_plnr_high);
187: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_byr_low '||G_byr_low);
188: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_byr_high '||G_byr_high);

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

181: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_fsort '||to_char(G_fsort));
182: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_ssort '||to_char(G_ssort));
183: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_tsort '||to_char(G_tsort));
184: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_ex_typ '||to_char(G_ex_typ));
185: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plnr_low '||G_plnr_low);
186: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plnr_high '||G_plnr_high);
187: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_byr_low '||G_byr_low);
188: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_byr_high '||G_byr_high);
189: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_itm_low '||G_itm_low);

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

182: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_ssort '||to_char(G_ssort));
183: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_tsort '||to_char(G_tsort));
184: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_ex_typ '||to_char(G_ex_typ));
185: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plnr_low '||G_plnr_low);
186: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plnr_high '||G_plnr_high);
187: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_byr_low '||G_byr_low);
188: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_byr_high '||G_byr_high);
189: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_itm_low '||G_itm_low);
190: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_itm_high '||G_itm_high);

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

183: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_tsort '||to_char(G_tsort));
184: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_ex_typ '||to_char(G_ex_typ));
185: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plnr_low '||G_plnr_low);
186: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plnr_high '||G_plnr_high);
187: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_byr_low '||G_byr_low);
188: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_byr_high '||G_byr_high);
189: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_itm_low '||G_itm_low);
190: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_itm_high '||G_itm_high);
191: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_cat_set_id '||to_char(G_cat_set_id));

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

184: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_ex_typ '||to_char(G_ex_typ));
185: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plnr_low '||G_plnr_low);
186: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plnr_high '||G_plnr_high);
187: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_byr_low '||G_byr_low);
188: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_byr_high '||G_byr_high);
189: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_itm_low '||G_itm_low);
190: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_itm_high '||G_itm_high);
191: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_cat_set_id '||to_char(G_cat_set_id));
192: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_category_low '||G_category_low);

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

185: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plnr_low '||G_plnr_low);
186: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plnr_high '||G_plnr_high);
187: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_byr_low '||G_byr_low);
188: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_byr_high '||G_byr_high);
189: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_itm_low '||G_itm_low);
190: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_itm_high '||G_itm_high);
191: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_cat_set_id '||to_char(G_cat_set_id));
192: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_category_low '||G_category_low);
193: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_category_high '||G_category_high);

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

186: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plnr_high '||G_plnr_high);
187: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_byr_low '||G_byr_low);
188: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_byr_high '||G_byr_high);
189: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_itm_low '||G_itm_low);
190: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_itm_high '||G_itm_high);
191: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_cat_set_id '||to_char(G_cat_set_id));
192: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_category_low '||G_category_low);
193: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_category_high '||G_category_high);
194: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_abc_class_low '||G_abc_class_low);

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

187: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_byr_low '||G_byr_low);
188: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_byr_high '||G_byr_high);
189: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_itm_low '||G_itm_low);
190: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_itm_high '||G_itm_high);
191: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_cat_set_id '||to_char(G_cat_set_id));
192: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_category_low '||G_category_low);
193: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_category_high '||G_category_high);
194: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_abc_class_low '||G_abc_class_low);
195: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_abc_class_high '||G_abc_class_high);

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

188: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_byr_high '||G_byr_high);
189: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_itm_low '||G_itm_low);
190: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_itm_high '||G_itm_high);
191: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_cat_set_id '||to_char(G_cat_set_id));
192: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_category_low '||G_category_low);
193: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_category_high '||G_category_high);
194: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_abc_class_low '||G_abc_class_low);
195: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_abc_class_high '||G_abc_class_high);
196: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_cutoff_date '||TO_CHAR(G_cutoff_date,'DD-MON-YYYY'));

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

189: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_itm_low '||G_itm_low);
190: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_itm_high '||G_itm_high);
191: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_cat_set_id '||to_char(G_cat_set_id));
192: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_category_low '||G_category_low);
193: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_category_high '||G_category_high);
194: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_abc_class_low '||G_abc_class_low);
195: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_abc_class_high '||G_abc_class_high);
196: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_cutoff_date '||TO_CHAR(G_cutoff_date,'DD-MON-YYYY'));
197: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_comb_pdr '||to_char(G_comb_pdr));

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

190: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_itm_high '||G_itm_high);
191: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_cat_set_id '||to_char(G_cat_set_id));
192: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_category_low '||G_category_low);
193: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_category_high '||G_category_high);
194: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_abc_class_low '||G_abc_class_low);
195: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_abc_class_high '||G_abc_class_high);
196: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_cutoff_date '||TO_CHAR(G_cutoff_date,'DD-MON-YYYY'));
197: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_comb_pdr '||to_char(G_comb_pdr));
198: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_comb_pdr_temp '||G_comb_pdr_temp);

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

191: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_cat_set_id '||to_char(G_cat_set_id));
192: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_category_low '||G_category_low);
193: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_category_high '||G_category_high);
194: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_abc_class_low '||G_abc_class_low);
195: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_abc_class_high '||G_abc_class_high);
196: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_cutoff_date '||TO_CHAR(G_cutoff_date,'DD-MON-YYYY'));
197: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_comb_pdr '||to_char(G_comb_pdr));
198: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_comb_pdr_temp '||G_comb_pdr_temp);
199: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_comb_pdr_locale '||G_comb_pdr_locale);

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

192: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_category_low '||G_category_low);
193: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_category_high '||G_category_high);
194: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_abc_class_low '||G_abc_class_low);
195: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_abc_class_high '||G_abc_class_high);
196: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_cutoff_date '||TO_CHAR(G_cutoff_date,'DD-MON-YYYY'));
197: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_comb_pdr '||to_char(G_comb_pdr));
198: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_comb_pdr_temp '||G_comb_pdr_temp);
199: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_comb_pdr_locale '||G_comb_pdr_locale);
200: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_vert_pdr '||to_char(G_vert_pdr));

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

193: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_category_high '||G_category_high);
194: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_abc_class_low '||G_abc_class_low);
195: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_abc_class_high '||G_abc_class_high);
196: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_cutoff_date '||TO_CHAR(G_cutoff_date,'DD-MON-YYYY'));
197: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_comb_pdr '||to_char(G_comb_pdr));
198: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_comb_pdr_temp '||G_comb_pdr_temp);
199: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_comb_pdr_locale '||G_comb_pdr_locale);
200: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_vert_pdr '||to_char(G_vert_pdr));
201: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_vert_pdr_temp '||G_vert_pdr_temp);

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

194: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_abc_class_low '||G_abc_class_low);
195: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_abc_class_high '||G_abc_class_high);
196: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_cutoff_date '||TO_CHAR(G_cutoff_date,'DD-MON-YYYY'));
197: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_comb_pdr '||to_char(G_comb_pdr));
198: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_comb_pdr_temp '||G_comb_pdr_temp);
199: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_comb_pdr_locale '||G_comb_pdr_locale);
200: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_vert_pdr '||to_char(G_vert_pdr));
201: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_vert_pdr_temp '||G_vert_pdr_temp);
202: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_vert_pdr_locale '||G_vert_pdr_locale);

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

195: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_abc_class_high '||G_abc_class_high);
196: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_cutoff_date '||TO_CHAR(G_cutoff_date,'DD-MON-YYYY'));
197: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_comb_pdr '||to_char(G_comb_pdr));
198: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_comb_pdr_temp '||G_comb_pdr_temp);
199: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_comb_pdr_locale '||G_comb_pdr_locale);
200: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_vert_pdr '||to_char(G_vert_pdr));
201: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_vert_pdr_temp '||G_vert_pdr_temp);
202: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_vert_pdr_locale '||G_vert_pdr_locale);
203: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_horiz_pdr '||to_char(G_horiz_pdr));

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

196: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_cutoff_date '||TO_CHAR(G_cutoff_date,'DD-MON-YYYY'));
197: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_comb_pdr '||to_char(G_comb_pdr));
198: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_comb_pdr_temp '||G_comb_pdr_temp);
199: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_comb_pdr_locale '||G_comb_pdr_locale);
200: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_vert_pdr '||to_char(G_vert_pdr));
201: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_vert_pdr_temp '||G_vert_pdr_temp);
202: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_vert_pdr_locale '||G_vert_pdr_locale);
203: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_horiz_pdr '||to_char(G_horiz_pdr));
204: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_horiz_pdr_temp '||G_horiz_pdr_temp);

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

197: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_comb_pdr '||to_char(G_comb_pdr));
198: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_comb_pdr_temp '||G_comb_pdr_temp);
199: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_comb_pdr_locale '||G_comb_pdr_locale);
200: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_vert_pdr '||to_char(G_vert_pdr));
201: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_vert_pdr_temp '||G_vert_pdr_temp);
202: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_vert_pdr_locale '||G_vert_pdr_locale);
203: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_horiz_pdr '||to_char(G_horiz_pdr));
204: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_horiz_pdr_temp '||G_horiz_pdr_temp);
205: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_horiz_pdr_locale '||G_horiz_pdr_locale);

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

198: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_comb_pdr_temp '||G_comb_pdr_temp);
199: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_comb_pdr_locale '||G_comb_pdr_locale);
200: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_vert_pdr '||to_char(G_vert_pdr));
201: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_vert_pdr_temp '||G_vert_pdr_temp);
202: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_vert_pdr_locale '||G_vert_pdr_locale);
203: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_horiz_pdr '||to_char(G_horiz_pdr));
204: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_horiz_pdr_temp '||G_horiz_pdr_temp);
205: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_horiz_pdr_locale '||G_horiz_pdr_locale);
206: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_excep_pdr '||to_char(G_excep_pdr));

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

199: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_comb_pdr_locale '||G_comb_pdr_locale);
200: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_vert_pdr '||to_char(G_vert_pdr));
201: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_vert_pdr_temp '||G_vert_pdr_temp);
202: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_vert_pdr_locale '||G_vert_pdr_locale);
203: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_horiz_pdr '||to_char(G_horiz_pdr));
204: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_horiz_pdr_temp '||G_horiz_pdr_temp);
205: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_horiz_pdr_locale '||G_horiz_pdr_locale);
206: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_excep_pdr '||to_char(G_excep_pdr));
207: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_excep_pdr_temp '||G_excep_pdr_temp);

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

200: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_vert_pdr '||to_char(G_vert_pdr));
201: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_vert_pdr_temp '||G_vert_pdr_temp);
202: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_vert_pdr_locale '||G_vert_pdr_locale);
203: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_horiz_pdr '||to_char(G_horiz_pdr));
204: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_horiz_pdr_temp '||G_horiz_pdr_temp);
205: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_horiz_pdr_locale '||G_horiz_pdr_locale);
206: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_excep_pdr '||to_char(G_excep_pdr));
207: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_excep_pdr_temp '||G_excep_pdr_temp);
208: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_excep_pdr_locale '||G_excep_pdr_locale);

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

201: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_vert_pdr_temp '||G_vert_pdr_temp);
202: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_vert_pdr_locale '||G_vert_pdr_locale);
203: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_horiz_pdr '||to_char(G_horiz_pdr));
204: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_horiz_pdr_temp '||G_horiz_pdr_temp);
205: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_horiz_pdr_locale '||G_horiz_pdr_locale);
206: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_excep_pdr '||to_char(G_excep_pdr));
207: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_excep_pdr_temp '||G_excep_pdr_temp);
208: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_excep_pdr_locale '||G_excep_pdr_locale);
209: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_act_pdr '||to_char(G_act_pdr));

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

202: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_vert_pdr_locale '||G_vert_pdr_locale);
203: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_horiz_pdr '||to_char(G_horiz_pdr));
204: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_horiz_pdr_temp '||G_horiz_pdr_temp);
205: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_horiz_pdr_locale '||G_horiz_pdr_locale);
206: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_excep_pdr '||to_char(G_excep_pdr));
207: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_excep_pdr_temp '||G_excep_pdr_temp);
208: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_excep_pdr_locale '||G_excep_pdr_locale);
209: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_act_pdr '||to_char(G_act_pdr));
210: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_act_pdr_temp '||G_act_pdr_temp);

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

203: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_horiz_pdr '||to_char(G_horiz_pdr));
204: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_horiz_pdr_temp '||G_horiz_pdr_temp);
205: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_horiz_pdr_locale '||G_horiz_pdr_locale);
206: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_excep_pdr '||to_char(G_excep_pdr));
207: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_excep_pdr_temp '||G_excep_pdr_temp);
208: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_excep_pdr_locale '||G_excep_pdr_locale);
209: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_act_pdr '||to_char(G_act_pdr));
210: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_act_pdr_temp '||G_act_pdr_temp);
211: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_act_pdr_locale '||G_act_pdr_locale);

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

204: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_horiz_pdr_temp '||G_horiz_pdr_temp);
205: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_horiz_pdr_locale '||G_horiz_pdr_locale);
206: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_excep_pdr '||to_char(G_excep_pdr));
207: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_excep_pdr_temp '||G_excep_pdr_temp);
208: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_excep_pdr_locale '||G_excep_pdr_locale);
209: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_act_pdr '||to_char(G_act_pdr));
210: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_act_pdr_temp '||G_act_pdr_temp);
211: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_act_pdr_locale '||G_act_pdr_locale);
212:

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

205: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_horiz_pdr_locale '||G_horiz_pdr_locale);
206: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_excep_pdr '||to_char(G_excep_pdr));
207: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_excep_pdr_temp '||G_excep_pdr_temp);
208: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_excep_pdr_locale '||G_excep_pdr_locale);
209: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_act_pdr '||to_char(G_act_pdr));
210: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_act_pdr_temp '||G_act_pdr_temp);
211: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_act_pdr_locale '||G_act_pdr_locale);
212:
213: /* Bug 5708728 with the new new parameters to the report when

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

206: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_excep_pdr '||to_char(G_excep_pdr));
207: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_excep_pdr_temp '||G_excep_pdr_temp);
208: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_excep_pdr_locale '||G_excep_pdr_locale);
209: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_act_pdr '||to_char(G_act_pdr));
210: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_act_pdr_temp '||G_act_pdr_temp);
211: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_act_pdr_locale '||G_act_pdr_locale);
212:
213: /* Bug 5708728 with the new new parameters to the report when
214: combined pdr is submitted the four individual report indicators are either

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

207: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_excep_pdr_temp '||G_excep_pdr_temp);
208: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_excep_pdr_locale '||G_excep_pdr_locale);
209: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_act_pdr '||to_char(G_act_pdr));
210: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_act_pdr_temp '||G_act_pdr_temp);
211: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_act_pdr_locale '||G_act_pdr_locale);
212:
213: /* Bug 5708728 with the new new parameters to the report when
214: combined pdr is submitted the four individual report indicators are either
215: NULL or 2 thereby not printing information

Line 230: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' After insert_items ');

226: validate_parameters;
227:
228: insert_items;
229:
230: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' After insert_items ');
231:
232: -- INSERT INTO temp_gmp_pdr_items_gtmp SELECT * FROM gmp_pdr_items_gtmp;
233:
234: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' Calling gmp_horizontal_pdr_pkg.populate_horizontal_plan '||

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

230: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' After insert_items ');
231:
232: -- INSERT INTO temp_gmp_pdr_items_gtmp SELECT * FROM gmp_pdr_items_gtmp;
233:
234: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' Calling gmp_horizontal_pdr_pkg.populate_horizontal_plan '||
235: ' with parameters : G_inst_id - '||to_char(G_inst_id)||' G_org_id - '||to_char(G_org_id)||
236: ' G_plan_id - '|| to_char(G_plan_id) ||
237: ' G_day_bckt_cutoff_dt - '||to_char(G_day_bckt_cutoff_dt, 'MM-DD-YYYY HH:MI:SS')||
238: ' G_week_bckt_cutoff_dt - '||to_char(G_week_bckt_cutoff_dt, 'MM-DD-YYYY HH:MI:SS')||

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

240:
241: gmp_horizontal_pdr_pkg.populate_horizontal_plan (G_inst_id, G_org_id, G_plan_id,
242: G_day_bckt_cutoff_dt, G_week_bckt_cutoff_dt, G_period_bucket);
243:
244: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' After gmp_horizontal_pdr_pkg.populate_horizontal_plan ');
245:
246: -- INSERT INTO temp_gmp_horizontal_pdr_gtmp SELECT * FROM gmp_horizontal_pdr_gtmp;
247:
248: horiz_plan_stmt;

Line 250: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' After horiz_plan_stmt ');

246: -- INSERT INTO temp_gmp_horizontal_pdr_gtmp SELECT * FROM gmp_horizontal_pdr_gtmp;
247:
248: horiz_plan_stmt;
249:
250: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' After horiz_plan_stmt ');
251:
252: vert_plan_stmt;
253: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' After vert_plan_stmt ');
254:

Line 253: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' After vert_plan_stmt ');

249:
250: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' After horiz_plan_stmt ');
251:
252: vert_plan_stmt;
253: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' After vert_plan_stmt ');
254:
255: item_exception_stmt;
256: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' After item_exception_stmt ');
257:

Line 256: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' After item_exception_stmt ');

252: vert_plan_stmt;
253: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' After vert_plan_stmt ');
254:
255: item_exception_stmt;
256: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' After item_exception_stmt ');
257:
258: item_action_stmt;
259: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' After item_action_stmt ');
260:

Line 259: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' After item_action_stmt ');

255: item_exception_stmt;
256: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' After item_exception_stmt ');
257:
258: item_action_stmt;
259: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' After item_action_stmt ');
260:
261: generate_xml;
262: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' After generate_xml ');
263: EXCEPTION

Line 262: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' After generate_xml ');

258: item_action_stmt;
259: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' After item_action_stmt ');
260:
261: generate_xml;
262: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' After generate_xml ');
263: EXCEPTION
264: WHEN OTHERS THEN
265: FND_FILE.PUT_LINE ( FND_FILE.LOG,' Error in package GMP_PLNG_DTL_REPORT_PKG.CREATE_PDR - '|| sqlerrm);
266: RAISE;

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

261: generate_xml;
262: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' After generate_xml ');
263: EXCEPTION
264: WHEN OTHERS THEN
265: FND_FILE.PUT_LINE ( FND_FILE.LOG,' Error in package GMP_PLNG_DTL_REPORT_PKG.CREATE_PDR - '|| sqlerrm);
266: RAISE;
267: END create_pdr;
268:
269: PROCEDURE validate_parameters IS

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

269: PROCEDURE validate_parameters IS
270: BEGIN
271: IF G_comb_pdr = 1 THEN
272: IF G_comb_pdr_temp IS NULL OR G_comb_pdr_locale IS NULL THEN
273: FND_FILE.PUT_LINE(FND_FILE.LOG,'Please specify the Template and Locale for Combined Planning Detail Report ');
274: RAISE invalid_parameter;
275: END IF;
276: ELSIF G_comb_pdr = 2 THEN
277: IF G_horiz_pdr = 1 THEN

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

275: END IF;
276: ELSIF G_comb_pdr = 2 THEN
277: IF G_horiz_pdr = 1 THEN
278: IF G_horiz_pdr_temp IS NULL OR G_horiz_pdr_locale IS NULL THEN
279: FND_FILE.PUT_LINE(FND_FILE.LOG,'Please specify the Template and Locale for Horizontal Planning Detail Report ');
280: RAISE invalid_parameter;
281: END IF;
282: END IF;
283: IF G_vert_pdr = 1 THEN

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

281: END IF;
282: END IF;
283: IF G_vert_pdr = 1 THEN
284: IF G_vert_pdr_temp IS NULL OR G_vert_pdr_locale IS NULL THEN
285: FND_FILE.PUT_LINE(FND_FILE.LOG,'Please specify the Template and Locale for Vertical Planning Detail Report ');
286: RAISE invalid_parameter;
287: END IF;
288: END IF;
289: IF G_excep_pdr = 1 THEN

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

287: END IF;
288: END IF;
289: IF G_excep_pdr = 1 THEN
290: IF G_excep_pdr_temp IS NULL OR G_excep_pdr_locale IS NULL THEN
291: FND_FILE.PUT_LINE(FND_FILE.LOG,'Please specify the Template and Locale for Exception Planning Detail Report ');
292: RAISE invalid_parameter;
293: END IF;
294: END IF;
295: IF G_act_pdr = 1 THEN

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

293: END IF;
294: END IF;
295: IF G_act_pdr = 1 THEN
296: IF G_act_pdr_temp IS NULL OR G_act_pdr_locale IS NULL THEN
297: FND_FILE.PUT_LINE(FND_FILE.LOG,'Please specify the Template and Locale for Action Planning Detail Report ');
298: RAISE invalid_parameter;
299: END IF;
300: END IF;
301: END IF;

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

473: END IF;
474: */
475: X_row_count := dbms_sql.EXECUTE (cur_item);
476:
477: FND_FILE.PUT_LINE(FND_FILE.LOG,'Num of rows in gmp_pdr_items_gtmp '||to_char(X_row_count));
478:
479: dbms_sql.close_cursor (cur_item);
480:
481: EXCEPTION

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

479: dbms_sql.close_cursor (cur_item);
480:
481: EXCEPTION
482: WHEN OTHERS THEN
483: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in package GMP_PLNG_DTL_REPORT_PKG '||sqlerrm);
484: IF dbms_sql.is_open (cur_item) THEN
485: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION cur_item is Open');
486: dbms_sql.close_cursor (cur_item);
487: END IF;

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

481: EXCEPTION
482: WHEN OTHERS THEN
483: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in package GMP_PLNG_DTL_REPORT_PKG '||sqlerrm);
484: IF dbms_sql.is_open (cur_item) THEN
485: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION cur_item is Open');
486: dbms_sql.close_cursor (cur_item);
487: END IF;
488: END insert_items;
489:

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

597: ' gmp_horizontal_pdr_gtmp ghp ) ';
598:
599: EXCEPTION
600: WHEN OTHERS THEN
601: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in procedure item_exception_stmt '||sqlerrm);
602: END horiz_plan_stmt;
603:
604: PROCEDURE vert_plan_stmt IS
605:

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

831: /* Global Var */
832:
833: EXCEPTION
834: WHEN OTHERS THEN
835: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in procedure vert_plan_stmt '||sqlerrm);
836: END vert_plan_stmt;
837:
838: PROCEDURE item_exception_stmt IS
839:

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

892: ' AND nvl(med.category_set_id, '||G_cat_set_id ||') = '|| G_cat_set_id ||
893: ' AND med.organization_id = gpi.organization_id )' ;
894: EXCEPTION
895: WHEN OTHERS THEN
896: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in procedure item_exception_stmt '||sqlerrm);
897: END item_exception_stmt;
898:
899: PROCEDURE item_action_stmt IS
900:

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

995: ' 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))) ) ';
996:
997: EXCEPTION
998: WHEN OTHERS THEN
999: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in procedure item_action_stmt '||sqlerrm);
1000: END item_action_stmt;
1001:
1002: PROCEDURE generate_xml IS
1003:

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

1086:
1087: IF G_comb_pdr = 1 THEN /*combined pdr report */
1088:
1089: -- INSERT INTO ns_debug (LONGVAL) values ('in combined PDR');
1090: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'in combined PDR');
1091:
1092: G_common_pdr_stmt := G_common_pdr_stmt || G_header_stmt;
1093:
1094: G_common_pdr_stmt := G_common_pdr_stmt || ' , CURSOR ( SELECT gpi.item_name item_name, gpi.organization_code organization_code, '||

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

1101: ' WHERE gpi.inventory_item_id = horiz.inventory_item_id '||
1102: ' AND gpi.organization_id = horiz.organization_id ) horiz ';
1103: EXCEPTION
1104: when others then
1105: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in horiz cursor stmt '||sqlerrm);
1106: END ;
1107: END IF;
1108:
1109: IF G_vert_pdr = 1 THEN

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

1113: ' WHERE gpi.inventory_item_id = vert.inventory_item_id '||
1114: ' AND gpi.organization_id = vert.organization_id ) vert ';
1115: EXCEPTION
1116: when others then
1117: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in vert cursor stmt '||sqlerrm);
1118: END ;
1119: END IF;
1120:
1121: IF G_excep_pdr = 1 THEN

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

1125: ' WHERE gpi.inventory_item_id = exc.inventory_item_id '||
1126: ' AND gpi.organization_id = exc.organization_id ) exc ';
1127: EXCEPTION
1128: when others then
1129: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in exc cursor stmt '||sqlerrm);
1130: END ;
1131: END IF;
1132:
1133: IF G_act_pdr = 1 THEN

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

1137: ' WHERE gpi.inventory_item_id = act.inventory_item_id '||
1138: ' AND gpi.organization_id = act.organization_id ) act ';
1139: EXCEPTION
1140: when others then
1141: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in act cursor stmt '||sqlerrm);
1142: END ;
1143: END IF;
1144:
1145: G_common_pdr_stmt := G_common_pdr_stmt || ' FROM gmp_pdr_items_gtmp gpi ';

Line 1166: -- FND_FILE.PUT_LINE(FND_FILE.LOG,G_common_pdr_stmt);

1162: END IF;
1163: G_common_pdr_stmt := G_common_pdr_stmt || ' FROM DUAL ';
1164:
1165: -- INSERT INTO ns_debug (LONGVAL) values (G_common_pdr_stmt);
1166: -- FND_FILE.PUT_LINE(FND_FILE.LOG,G_common_pdr_stmt);
1167:
1168: qryctx := dbms_xmlgen.newcontext(G_common_pdr_stmt);
1169: result := DBMS_XMLGEN.getXML(qryCtx);
1170: seq_stmt := 'select gmp_matl_rep_id_s.nextval from dual ';

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

1359: END IF; /* Combined PDR */
1360:
1361: EXCEPTION
1362: WHEN OTHERS THEN
1363: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in procedure generate_xml '||sqlerrm);
1364:
1365: END generate_xml;
1366:
1367: FUNCTION plan_name RETURN VARCHAR2 IS

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

1375:
1376: RETURN plan_name;
1377:
1378: EXCEPTION WHEN OTHERS THEN
1379: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in function plan_name '||sqlerrm);
1380: END plan_name;
1381:
1382: FUNCTION plan_org ( org_id IN NUMBER) RETURN VARCHAR2 IS
1383: org_code VARCHAR2(7);

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

1403:
1404: RETURN org_code;
1405:
1406: EXCEPTION WHEN OTHERS THEN
1407: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in function plan_org '||sqlerrm);
1408: END plan_org;
1409:
1410: FUNCTION category_set_name ( cat_set_id IN NUMBER) RETURN VARCHAR2 IS
1411: cat_set_name VARCHAR2(30);

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

1419:
1420: RETURN cat_set_name;
1421:
1422: EXCEPTION WHEN OTHERS THEN
1423: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in function category_set_name '||sqlerrm);
1424: END category_set_name;
1425:
1426: FUNCTION lookup_meaning(l_lookup_type IN VARCHAR2,
1427: l_lookup_code IN NUMBER) RETURN VARCHAR2 IS

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

1487: '','','','','','','','','','');
1488:
1489: IF l_conc_id = 0 THEN
1490: l_log_text := FND_MESSAGE.GET;
1491: FND_FILE.PUT_LINE ( FND_FILE.LOG,l_log_text);
1492: ELSE
1493: COMMIT ;
1494: END IF;
1495:

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

1492: ELSE
1493: COMMIT ;
1494: END IF;
1495:
1496: -- FND_FILE.PUT_LINE ( FND_FILE.LOG, 'l_conc_id : '||to_char(l_conc_id));
1497: IF l_conc_id <> 0 THEN
1498:
1499: l_status := fnd_concurrent.WAIT_FOR_REQUEST
1500: (

Line 1511: -- FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Wait completed for conc request '||to_char(l_conc_id));

1507: DEV_STATUS => l_dev_status,
1508: MESSAGE => l_message
1509: );
1510:
1511: -- FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Wait completed for conc request '||to_char(l_conc_id));
1512:
1513: DELETE FROM gmp_pdr_xml_temp WHERE pdr_xml_id = p_sequence_num;
1514: COMMIT;
1515:

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

1512:
1513: DELETE FROM gmp_pdr_xml_temp WHERE pdr_xml_id = p_sequence_num;
1514: COMMIT;
1515:
1516: -- FND_FILE.PUT_LINE ( FND_FILE.LOG, 'p_pdr_type = '||to_char(p_pdr_type));
1517:
1518: IF p_pdr_type = 1 THEN
1519:
1520: /* Bug: 6609251 Vpedarla added a NULL parameters for the submition of the FND request for XDOREPPB */

Line 1532: -- FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Submitted combined PDR with request id '||to_char(l_req_id));

1528: '','','','','','','','','','',
1529: '','','','','','','','','','',
1530: '','','','','','','','','','',
1531: '','','','','','','','','','');
1532: -- FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Submitted combined PDR with request id '||to_char(l_req_id));
1533:
1534: ELSIF p_pdr_type = 2 THEN
1535:
1536: /* Bug: 6609251 Vpedarla added a NULL parameters for the submition of the FND request for XDOREPPB */

Line 1549: -- FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Submitted Horizontal PDR with request id '||to_char(l_req_id));

1545: '','','','','','','','','','',
1546: '','','','','','','','','','',
1547: '','','','','','','','','','');
1548:
1549: -- FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Submitted Horizontal PDR with request id '||to_char(l_req_id));
1550:
1551: ELSIF p_pdr_type = 3 THEN
1552:
1553: /* Bug: 6609251 Vpedarla added a NULL parameters for the submition of the FND request for XDOREPPB */

Line 1566: -- FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Submitted Vertical PDR with request id '||to_char(l_req_id));

1562: '','','','','','','','','','',
1563: '','','','','','','','','','',
1564: '','','','','','','','','','');
1565:
1566: -- FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Submitted Vertical PDR with request id '||to_char(l_req_id));
1567:
1568: ELSIF p_pdr_type = 4 THEN
1569:
1570: /* Bug: 6609251 Vpedarla added a NULL parameters for the submition of the FND request for XDOREPPB */

Line 1583: -- FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Submitted Exception PDR with request id '||to_char(l_req_id));

1579: '','','','','','','','','','',
1580: '','','','','','','','','','',
1581: '','','','','','','','','','');
1582:
1583: -- FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Submitted Exception PDR with request id '||to_char(l_req_id));
1584:
1585: ELSIF p_pdr_type = 5 THEN
1586:
1587: /* Bug: 6609251 Vpedarla added a NULL parameters for the submition of the FND request for XDOREPPB */

Line 1600: -- FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Submitted Action PDR with request id '||to_char(l_req_id));

1596: '','','','','','','','','','',
1597: '','','','','','','','','','',
1598: '','','','','','','','','','');
1599:
1600: -- FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Submitted Action PDR with request id '||to_char(l_req_id));
1601:
1602: END IF;
1603: END IF;
1604:

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

1603: END IF;
1604:
1605: EXCEPTION
1606: WHEN OTHERS THEN
1607: FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Exception in procedure ps_generate_output '||SQLERRM);
1608: END ps_generate_output;
1609:
1610: /* ***************************************************************
1611: * NAME

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

1643: --Introduced another clob variable m_file and after trimming it assigned to the varchar type variable.
1644: -- file_varchar2 := DBMS_LOB.SUBSTR (l_file,10,l_limit);
1645: M_FILE := DBMS_LOB.SUBSTR (l_file,10,l_limit);
1646: file_varchar2:=trim(M_FILE);
1647: FND_FILE.PUT(FND_FILE.OUTPUT, file_varchar2);
1648: FND_FILE.PUT(FND_FILE.LOG,file_varchar2);
1649: file_varchar2 := NULL;
1650: m_file :=NULL;
1651: l_limit:= l_limit + 10;

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

1644: -- file_varchar2 := DBMS_LOB.SUBSTR (l_file,10,l_limit);
1645: M_FILE := DBMS_LOB.SUBSTR (l_file,10,l_limit);
1646: file_varchar2:=trim(M_FILE);
1647: FND_FILE.PUT(FND_FILE.OUTPUT, file_varchar2);
1648: FND_FILE.PUT(FND_FILE.LOG,file_varchar2);
1649: file_varchar2 := NULL;
1650: m_file :=NULL;
1651: l_limit:= l_limit + 10;
1652: ELSE

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

1652: ELSE
1653: -- file_varchar2 := DBMS_LOB.SUBSTR (l_file,10,l_limit);
1654: M_FILE := DBMS_LOB.SUBSTR (l_file,10,l_limit);
1655: file_varchar2:=trim(M_FILE);
1656: FND_FILE.PUT(FND_FILE.OUTPUT, file_varchar2);
1657: FND_FILE.PUT(FND_FILE.LOG,file_varchar2);
1658: file_varchar2 := NULL;
1659: m_file :=NULL;
1660: EXIT;

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

1653: -- file_varchar2 := DBMS_LOB.SUBSTR (l_file,10,l_limit);
1654: M_FILE := DBMS_LOB.SUBSTR (l_file,10,l_limit);
1655: file_varchar2:=trim(M_FILE);
1656: FND_FILE.PUT(FND_FILE.OUTPUT, file_varchar2);
1657: FND_FILE.PUT(FND_FILE.LOG,file_varchar2);
1658: file_varchar2 := NULL;
1659: m_file :=NULL;
1660: EXIT;
1661: END IF;

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

1661: END IF;
1662: END LOOP;
1663: EXCEPTION
1664: WHEN OTHERS THEN
1665: FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Exception in procedure gmp_plng_dtl_report_pkg.xml_transfer '||SQLERRM);
1666: END;
1667:
1668:
1669: END GMP_PLNG_DTL_REPORT_PKG;