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

Line 199: fnd_file.put_line(fnd_file.log,'====================================');

195: val_count := val_log_tbl.COUNT;
196: err_count := err_log_tbl.COUNT;
197: pro_count := tot_count-(val_count+err_count);
198: -- loop through the message and write to CM log
199: fnd_file.put_line(fnd_file.log,'====================================');
200: fnd_file.put_line(fnd_file.log,'Termination Interface - LOG MESSAGES');
201: fnd_file.put_line(fnd_file.log,'====================================');
202: fnd_file.put_line(fnd_file.log,'Operating Unit :'||l_org_name);
203: fnd_file.put_line(fnd_file.log,'Run Date :'||SYSDATE);

Line 200: fnd_file.put_line(fnd_file.log,'Termination Interface - LOG MESSAGES');

196: err_count := err_log_tbl.COUNT;
197: pro_count := tot_count-(val_count+err_count);
198: -- loop through the message and write to CM log
199: fnd_file.put_line(fnd_file.log,'====================================');
200: fnd_file.put_line(fnd_file.log,'Termination Interface - LOG MESSAGES');
201: fnd_file.put_line(fnd_file.log,'====================================');
202: fnd_file.put_line(fnd_file.log,'Operating Unit :'||l_org_name);
203: fnd_file.put_line(fnd_file.log,'Run Date :'||SYSDATE);
204: fnd_file.new_line(fnd_file.log);

Line 201: fnd_file.put_line(fnd_file.log,'====================================');

197: pro_count := tot_count-(val_count+err_count);
198: -- loop through the message and write to CM log
199: fnd_file.put_line(fnd_file.log,'====================================');
200: fnd_file.put_line(fnd_file.log,'Termination Interface - LOG MESSAGES');
201: fnd_file.put_line(fnd_file.log,'====================================');
202: fnd_file.put_line(fnd_file.log,'Operating Unit :'||l_org_name);
203: fnd_file.put_line(fnd_file.log,'Run Date :'||SYSDATE);
204: fnd_file.new_line(fnd_file.log);
205: fnd_file.put_line(fnd_file.log,'-----------------------');

Line 202: fnd_file.put_line(fnd_file.log,'Operating Unit :'||l_org_name);

198: -- loop through the message and write to CM log
199: fnd_file.put_line(fnd_file.log,'====================================');
200: fnd_file.put_line(fnd_file.log,'Termination Interface - LOG MESSAGES');
201: fnd_file.put_line(fnd_file.log,'====================================');
202: fnd_file.put_line(fnd_file.log,'Operating Unit :'||l_org_name);
203: fnd_file.put_line(fnd_file.log,'Run Date :'||SYSDATE);
204: fnd_file.new_line(fnd_file.log);
205: fnd_file.put_line(fnd_file.log,'-----------------------');
206: fnd_file.put_line(fnd_file.log,'SUMMARY OF TRANSACTIONS');

Line 203: fnd_file.put_line(fnd_file.log,'Run Date :'||SYSDATE);

199: fnd_file.put_line(fnd_file.log,'====================================');
200: fnd_file.put_line(fnd_file.log,'Termination Interface - LOG MESSAGES');
201: fnd_file.put_line(fnd_file.log,'====================================');
202: fnd_file.put_line(fnd_file.log,'Operating Unit :'||l_org_name);
203: fnd_file.put_line(fnd_file.log,'Run Date :'||SYSDATE);
204: fnd_file.new_line(fnd_file.log);
205: fnd_file.put_line(fnd_file.log,'-----------------------');
206: fnd_file.put_line(fnd_file.log,'SUMMARY OF TRANSACTIONS');
207: fnd_file.put_line(fnd_file.log,'-----------------------');

Line 204: fnd_file.new_line(fnd_file.log);

200: fnd_file.put_line(fnd_file.log,'Termination Interface - LOG MESSAGES');
201: fnd_file.put_line(fnd_file.log,'====================================');
202: fnd_file.put_line(fnd_file.log,'Operating Unit :'||l_org_name);
203: fnd_file.put_line(fnd_file.log,'Run Date :'||SYSDATE);
204: fnd_file.new_line(fnd_file.log);
205: fnd_file.put_line(fnd_file.log,'-----------------------');
206: fnd_file.put_line(fnd_file.log,'SUMMARY OF TRANSACTIONS');
207: fnd_file.put_line(fnd_file.log,'-----------------------');
208: fnd_file.new_line(fnd_file.log);

Line 205: fnd_file.put_line(fnd_file.log,'-----------------------');

201: fnd_file.put_line(fnd_file.log,'====================================');
202: fnd_file.put_line(fnd_file.log,'Operating Unit :'||l_org_name);
203: fnd_file.put_line(fnd_file.log,'Run Date :'||SYSDATE);
204: fnd_file.new_line(fnd_file.log);
205: fnd_file.put_line(fnd_file.log,'-----------------------');
206: fnd_file.put_line(fnd_file.log,'SUMMARY OF TRANSACTIONS');
207: fnd_file.put_line(fnd_file.log,'-----------------------');
208: fnd_file.new_line(fnd_file.log);
209: fnd_file.put_line(fnd_file.log,'Processed Successfully : '||pro_count);

Line 206: fnd_file.put_line(fnd_file.log,'SUMMARY OF TRANSACTIONS');

202: fnd_file.put_line(fnd_file.log,'Operating Unit :'||l_org_name);
203: fnd_file.put_line(fnd_file.log,'Run Date :'||SYSDATE);
204: fnd_file.new_line(fnd_file.log);
205: fnd_file.put_line(fnd_file.log,'-----------------------');
206: fnd_file.put_line(fnd_file.log,'SUMMARY OF TRANSACTIONS');
207: fnd_file.put_line(fnd_file.log,'-----------------------');
208: fnd_file.new_line(fnd_file.log);
209: fnd_file.put_line(fnd_file.log,'Processed Successfully : '||pro_count);
210: fnd_file.put_line(fnd_file.log,'Not Processed Due To Errors : '||val_count);

Line 207: fnd_file.put_line(fnd_file.log,'-----------------------');

203: fnd_file.put_line(fnd_file.log,'Run Date :'||SYSDATE);
204: fnd_file.new_line(fnd_file.log);
205: fnd_file.put_line(fnd_file.log,'-----------------------');
206: fnd_file.put_line(fnd_file.log,'SUMMARY OF TRANSACTIONS');
207: fnd_file.put_line(fnd_file.log,'-----------------------');
208: fnd_file.new_line(fnd_file.log);
209: fnd_file.put_line(fnd_file.log,'Processed Successfully : '||pro_count);
210: fnd_file.put_line(fnd_file.log,'Not Processed Due To Errors : '||val_count);
211: fnd_file.put_line(fnd_file.log,'Processed with Errors : '||err_count);

Line 208: fnd_file.new_line(fnd_file.log);

204: fnd_file.new_line(fnd_file.log);
205: fnd_file.put_line(fnd_file.log,'-----------------------');
206: fnd_file.put_line(fnd_file.log,'SUMMARY OF TRANSACTIONS');
207: fnd_file.put_line(fnd_file.log,'-----------------------');
208: fnd_file.new_line(fnd_file.log);
209: fnd_file.put_line(fnd_file.log,'Processed Successfully : '||pro_count);
210: fnd_file.put_line(fnd_file.log,'Not Processed Due To Errors : '||val_count);
211: fnd_file.put_line(fnd_file.log,'Processed with Errors : '||err_count);
212: fnd_file.new_line(fnd_file.log);

Line 209: fnd_file.put_line(fnd_file.log,'Processed Successfully : '||pro_count);

205: fnd_file.put_line(fnd_file.log,'-----------------------');
206: fnd_file.put_line(fnd_file.log,'SUMMARY OF TRANSACTIONS');
207: fnd_file.put_line(fnd_file.log,'-----------------------');
208: fnd_file.new_line(fnd_file.log);
209: fnd_file.put_line(fnd_file.log,'Processed Successfully : '||pro_count);
210: fnd_file.put_line(fnd_file.log,'Not Processed Due To Errors : '||val_count);
211: fnd_file.put_line(fnd_file.log,'Processed with Errors : '||err_count);
212: fnd_file.new_line(fnd_file.log);
213: fnd_file.put_line(fnd_file.log,'Total Records : '||tot_count);

Line 210: fnd_file.put_line(fnd_file.log,'Not Processed Due To Errors : '||val_count);

206: fnd_file.put_line(fnd_file.log,'SUMMARY OF TRANSACTIONS');
207: fnd_file.put_line(fnd_file.log,'-----------------------');
208: fnd_file.new_line(fnd_file.log);
209: fnd_file.put_line(fnd_file.log,'Processed Successfully : '||pro_count);
210: fnd_file.put_line(fnd_file.log,'Not Processed Due To Errors : '||val_count);
211: fnd_file.put_line(fnd_file.log,'Processed with Errors : '||err_count);
212: fnd_file.new_line(fnd_file.log);
213: fnd_file.put_line(fnd_file.log,'Total Records : '||tot_count);
214: fnd_file.new_line(fnd_file.log);

Line 211: fnd_file.put_line(fnd_file.log,'Processed with Errors : '||err_count);

207: fnd_file.put_line(fnd_file.log,'-----------------------');
208: fnd_file.new_line(fnd_file.log);
209: fnd_file.put_line(fnd_file.log,'Processed Successfully : '||pro_count);
210: fnd_file.put_line(fnd_file.log,'Not Processed Due To Errors : '||val_count);
211: fnd_file.put_line(fnd_file.log,'Processed with Errors : '||err_count);
212: fnd_file.new_line(fnd_file.log);
213: fnd_file.put_line(fnd_file.log,'Total Records : '||tot_count);
214: fnd_file.new_line(fnd_file.log);
215: IF (val_log_tbl.COUNT > 0) THEN

Line 212: fnd_file.new_line(fnd_file.log);

208: fnd_file.new_line(fnd_file.log);
209: fnd_file.put_line(fnd_file.log,'Processed Successfully : '||pro_count);
210: fnd_file.put_line(fnd_file.log,'Not Processed Due To Errors : '||val_count);
211: fnd_file.put_line(fnd_file.log,'Processed with Errors : '||err_count);
212: fnd_file.new_line(fnd_file.log);
213: fnd_file.put_line(fnd_file.log,'Total Records : '||tot_count);
214: fnd_file.new_line(fnd_file.log);
215: IF (val_log_tbl.COUNT > 0) THEN
216: fnd_file.put_line(fnd_file.log,'----------------------------------------');

Line 213: fnd_file.put_line(fnd_file.log,'Total Records : '||tot_count);

209: fnd_file.put_line(fnd_file.log,'Processed Successfully : '||pro_count);
210: fnd_file.put_line(fnd_file.log,'Not Processed Due To Errors : '||val_count);
211: fnd_file.put_line(fnd_file.log,'Processed with Errors : '||err_count);
212: fnd_file.new_line(fnd_file.log);
213: fnd_file.put_line(fnd_file.log,'Total Records : '||tot_count);
214: fnd_file.new_line(fnd_file.log);
215: IF (val_log_tbl.COUNT > 0) THEN
216: fnd_file.put_line(fnd_file.log,'----------------------------------------');
217: fnd_file.put_line(fnd_file.log,'TRANSACTIONS NOT PROCESSED DUE TO ERRORS');

Line 214: fnd_file.new_line(fnd_file.log);

210: fnd_file.put_line(fnd_file.log,'Not Processed Due To Errors : '||val_count);
211: fnd_file.put_line(fnd_file.log,'Processed with Errors : '||err_count);
212: fnd_file.new_line(fnd_file.log);
213: fnd_file.put_line(fnd_file.log,'Total Records : '||tot_count);
214: fnd_file.new_line(fnd_file.log);
215: IF (val_log_tbl.COUNT > 0) THEN
216: fnd_file.put_line(fnd_file.log,'----------------------------------------');
217: fnd_file.put_line(fnd_file.log,'TRANSACTIONS NOT PROCESSED DUE TO ERRORS');
218: fnd_file.put_line(fnd_file.log,'----------------------------------------');

Line 216: fnd_file.put_line(fnd_file.log,'----------------------------------------');

212: fnd_file.new_line(fnd_file.log);
213: fnd_file.put_line(fnd_file.log,'Total Records : '||tot_count);
214: fnd_file.new_line(fnd_file.log);
215: IF (val_log_tbl.COUNT > 0) THEN
216: fnd_file.put_line(fnd_file.log,'----------------------------------------');
217: fnd_file.put_line(fnd_file.log,'TRANSACTIONS NOT PROCESSED DUE TO ERRORS');
218: fnd_file.put_line(fnd_file.log,'----------------------------------------');
219: FOR record_number in val_log_tbl.FIRST..val_log_tbl.LAST LOOP
220: fnd_file.new_line(fnd_file.log);

Line 217: fnd_file.put_line(fnd_file.log,'TRANSACTIONS NOT PROCESSED DUE TO ERRORS');

213: fnd_file.put_line(fnd_file.log,'Total Records : '||tot_count);
214: fnd_file.new_line(fnd_file.log);
215: IF (val_log_tbl.COUNT > 0) THEN
216: fnd_file.put_line(fnd_file.log,'----------------------------------------');
217: fnd_file.put_line(fnd_file.log,'TRANSACTIONS NOT PROCESSED DUE TO ERRORS');
218: fnd_file.put_line(fnd_file.log,'----------------------------------------');
219: FOR record_number in val_log_tbl.FIRST..val_log_tbl.LAST LOOP
220: fnd_file.new_line(fnd_file.log);
221: fnd_file.put_line(fnd_file.log,'Transaction Number : '||val_log_tbl(record_number).transaction_number);

Line 218: fnd_file.put_line(fnd_file.log,'----------------------------------------');

214: fnd_file.new_line(fnd_file.log);
215: IF (val_log_tbl.COUNT > 0) THEN
216: fnd_file.put_line(fnd_file.log,'----------------------------------------');
217: fnd_file.put_line(fnd_file.log,'TRANSACTIONS NOT PROCESSED DUE TO ERRORS');
218: fnd_file.put_line(fnd_file.log,'----------------------------------------');
219: FOR record_number in val_log_tbl.FIRST..val_log_tbl.LAST LOOP
220: fnd_file.new_line(fnd_file.log);
221: fnd_file.put_line(fnd_file.log,'Transaction Number : '||val_log_tbl(record_number).transaction_number);
222: fnd_file.put_line(fnd_file.log,'Contract Number : '||val_log_tbl(record_number).contract_number);

Line 220: fnd_file.new_line(fnd_file.log);

216: fnd_file.put_line(fnd_file.log,'----------------------------------------');
217: fnd_file.put_line(fnd_file.log,'TRANSACTIONS NOT PROCESSED DUE TO ERRORS');
218: fnd_file.put_line(fnd_file.log,'----------------------------------------');
219: FOR record_number in val_log_tbl.FIRST..val_log_tbl.LAST LOOP
220: fnd_file.new_line(fnd_file.log);
221: fnd_file.put_line(fnd_file.log,'Transaction Number : '||val_log_tbl(record_number).transaction_number);
222: fnd_file.put_line(fnd_file.log,'Contract Number : '||val_log_tbl(record_number).contract_number);
223: fnd_file.put_line(fnd_file.log,'Quote Effective From Date : '||val_log_tbl(record_number).date_effective_from);
224: -- to find the meaning of quote_type_code

Line 221: fnd_file.put_line(fnd_file.log,'Transaction Number : '||val_log_tbl(record_number).transaction_number);

217: fnd_file.put_line(fnd_file.log,'TRANSACTIONS NOT PROCESSED DUE TO ERRORS');
218: fnd_file.put_line(fnd_file.log,'----------------------------------------');
219: FOR record_number in val_log_tbl.FIRST..val_log_tbl.LAST LOOP
220: fnd_file.new_line(fnd_file.log);
221: fnd_file.put_line(fnd_file.log,'Transaction Number : '||val_log_tbl(record_number).transaction_number);
222: fnd_file.put_line(fnd_file.log,'Contract Number : '||val_log_tbl(record_number).contract_number);
223: fnd_file.put_line(fnd_file.log,'Quote Effective From Date : '||val_log_tbl(record_number).date_effective_from);
224: -- to find the meaning of quote_type_code
225: l_quote_type := NULL;

Line 222: fnd_file.put_line(fnd_file.log,'Contract Number : '||val_log_tbl(record_number).contract_number);

218: fnd_file.put_line(fnd_file.log,'----------------------------------------');
219: FOR record_number in val_log_tbl.FIRST..val_log_tbl.LAST LOOP
220: fnd_file.new_line(fnd_file.log);
221: fnd_file.put_line(fnd_file.log,'Transaction Number : '||val_log_tbl(record_number).transaction_number);
222: fnd_file.put_line(fnd_file.log,'Contract Number : '||val_log_tbl(record_number).contract_number);
223: fnd_file.put_line(fnd_file.log,'Quote Effective From Date : '||val_log_tbl(record_number).date_effective_from);
224: -- to find the meaning of quote_type_code
225: l_quote_type := NULL;
226: FOR get_type IN get_quote_type_meaning_csr(p_quote_type => val_log_tbl(record_number).quote_type)

Line 223: fnd_file.put_line(fnd_file.log,'Quote Effective From Date : '||val_log_tbl(record_number).date_effective_from);

219: FOR record_number in val_log_tbl.FIRST..val_log_tbl.LAST LOOP
220: fnd_file.new_line(fnd_file.log);
221: fnd_file.put_line(fnd_file.log,'Transaction Number : '||val_log_tbl(record_number).transaction_number);
222: fnd_file.put_line(fnd_file.log,'Contract Number : '||val_log_tbl(record_number).contract_number);
223: fnd_file.put_line(fnd_file.log,'Quote Effective From Date : '||val_log_tbl(record_number).date_effective_from);
224: -- to find the meaning of quote_type_code
225: l_quote_type := NULL;
226: FOR get_type IN get_quote_type_meaning_csr(p_quote_type => val_log_tbl(record_number).quote_type)
227: LOOP

Line 230: fnd_file.put(fnd_file.log,'Quote Type : ');

226: FOR get_type IN get_quote_type_meaning_csr(p_quote_type => val_log_tbl(record_number).quote_type)
227: LOOP
228: l_quote_type := get_type.meaning;
229: END LOOP;
230: fnd_file.put(fnd_file.log,'Quote Type : ');
231: IF(l_quote_type IS NOT NULL) THEN
232: fnd_file.put(fnd_file.log,l_quote_type);
233: END IF;
234: fnd_file.put_line(fnd_file.log,'( '||val_log_tbl(record_number).quote_type||' )');

Line 232: fnd_file.put(fnd_file.log,l_quote_type);

228: l_quote_type := get_type.meaning;
229: END LOOP;
230: fnd_file.put(fnd_file.log,'Quote Type : ');
231: IF(l_quote_type IS NOT NULL) THEN
232: fnd_file.put(fnd_file.log,l_quote_type);
233: END IF;
234: fnd_file.put_line(fnd_file.log,'( '||val_log_tbl(record_number).quote_type||' )');
235: -- to find the meaning of quote_reason_code
236: l_quote_reason := NULL;

Line 234: fnd_file.put_line(fnd_file.log,'( '||val_log_tbl(record_number).quote_type||' )');

230: fnd_file.put(fnd_file.log,'Quote Type : ');
231: IF(l_quote_type IS NOT NULL) THEN
232: fnd_file.put(fnd_file.log,l_quote_type);
233: END IF;
234: fnd_file.put_line(fnd_file.log,'( '||val_log_tbl(record_number).quote_type||' )');
235: -- to find the meaning of quote_reason_code
236: l_quote_reason := NULL;
237: FOR get_reason IN get_quote_reason_meaning_csr(p_quote_reason => val_log_tbl(record_number).quote_reason)
238: LOOP

Line 241: fnd_file.put(fnd_file.log,'Quote Reason : ');

237: FOR get_reason IN get_quote_reason_meaning_csr(p_quote_reason => val_log_tbl(record_number).quote_reason)
238: LOOP
239: l_quote_reason := get_reason.meaning;
240: END LOOP;
241: fnd_file.put(fnd_file.log,'Quote Reason : ');
242: IF(l_quote_reason IS NOT NULL) THEN
243: fnd_file.put(fnd_file.log,l_quote_reason);
244: END IF;
245: fnd_file.put_line(fnd_file.log,'( '||val_log_tbl(record_number).quote_reason||' )');

Line 243: fnd_file.put(fnd_file.log,l_quote_reason);

239: l_quote_reason := get_reason.meaning;
240: END LOOP;
241: fnd_file.put(fnd_file.log,'Quote Reason : ');
242: IF(l_quote_reason IS NOT NULL) THEN
243: fnd_file.put(fnd_file.log,l_quote_reason);
244: END IF;
245: fnd_file.put_line(fnd_file.log,'( '||val_log_tbl(record_number).quote_reason||' )');
246: fnd_file.put_line(fnd_file.log,'Asset Number : '||val_log_tbl(record_number).asset_number);
247: fnd_file.put_line(fnd_file.log,'Messages ');

Line 245: fnd_file.put_line(fnd_file.log,'( '||val_log_tbl(record_number).quote_reason||' )');

241: fnd_file.put(fnd_file.log,'Quote Reason : ');
242: IF(l_quote_reason IS NOT NULL) THEN
243: fnd_file.put(fnd_file.log,l_quote_reason);
244: END IF;
245: fnd_file.put_line(fnd_file.log,'( '||val_log_tbl(record_number).quote_reason||' )');
246: fnd_file.put_line(fnd_file.log,'Asset Number : '||val_log_tbl(record_number).asset_number);
247: fnd_file.put_line(fnd_file.log,'Messages ');
248: count_msg := 1;
249: -- modified for BUG#3062867

Line 246: fnd_file.put_line(fnd_file.log,'Asset Number : '||val_log_tbl(record_number).asset_number);

242: IF(l_quote_reason IS NOT NULL) THEN
243: fnd_file.put(fnd_file.log,l_quote_reason);
244: END IF;
245: fnd_file.put_line(fnd_file.log,'( '||val_log_tbl(record_number).quote_reason||' )');
246: fnd_file.put_line(fnd_file.log,'Asset Number : '||val_log_tbl(record_number).asset_number);
247: fnd_file.put_line(fnd_file.log,'Messages ');
248: count_msg := 1;
249: -- modified for BUG#3062867
250: IF(val_msg_tbl.COUNT>0) THEN

Line 247: fnd_file.put_line(fnd_file.log,'Messages ');

243: fnd_file.put(fnd_file.log,l_quote_reason);
244: END IF;
245: fnd_file.put_line(fnd_file.log,'( '||val_log_tbl(record_number).quote_reason||' )');
246: fnd_file.put_line(fnd_file.log,'Asset Number : '||val_log_tbl(record_number).asset_number);
247: fnd_file.put_line(fnd_file.log,'Messages ');
248: count_msg := 1;
249: -- modified for BUG#3062867
250: IF(val_msg_tbl.COUNT>0) THEN
251: FOR i IN val_msg_tbl.FIRST..val_msg_tbl.LAST

Line 254: fnd_file.put_line(fnd_file.log,count_msg||': '||val_msg_tbl(i).msg_text);

250: IF(val_msg_tbl.COUNT>0) THEN
251: FOR i IN val_msg_tbl.FIRST..val_msg_tbl.LAST
252: LOOP
253: IF(val_msg_tbl(i).transaction_number = val_log_tbl(record_number).transaction_number) THEN
254: fnd_file.put_line(fnd_file.log,count_msg||': '||val_msg_tbl(i).msg_text);
255: count_msg := count_msg+1;
256: END IF;
257: END LOOP;
258: END IF;

Line 260: fnd_file.new_line(fnd_file.log);

256: END IF;
257: END LOOP;
258: END IF;
259:
260: fnd_file.new_line(fnd_file.log);
261: END LOOP;
262: END IF; -- val_log_tbl COUNT > 0
263: IF (err_log_tbl.COUNT > 0) THEN
264: fnd_file.put_line(fnd_file.log,'----------------------------------');

Line 264: fnd_file.put_line(fnd_file.log,'----------------------------------');

260: fnd_file.new_line(fnd_file.log);
261: END LOOP;
262: END IF; -- val_log_tbl COUNT > 0
263: IF (err_log_tbl.COUNT > 0) THEN
264: fnd_file.put_line(fnd_file.log,'----------------------------------');
265: fnd_file.put_line(fnd_file.log,'TRANSACTIONS PROCESSED WITH ERRORS');
266: fnd_file.put_line(fnd_file.log,'----------------------------------');
267: FOR record_number in err_log_tbl.FIRST..err_log_tbl.LAST LOOP
268: fnd_file.new_line(fnd_file.log);

Line 265: fnd_file.put_line(fnd_file.log,'TRANSACTIONS PROCESSED WITH ERRORS');

261: END LOOP;
262: END IF; -- val_log_tbl COUNT > 0
263: IF (err_log_tbl.COUNT > 0) THEN
264: fnd_file.put_line(fnd_file.log,'----------------------------------');
265: fnd_file.put_line(fnd_file.log,'TRANSACTIONS PROCESSED WITH ERRORS');
266: fnd_file.put_line(fnd_file.log,'----------------------------------');
267: FOR record_number in err_log_tbl.FIRST..err_log_tbl.LAST LOOP
268: fnd_file.new_line(fnd_file.log);
269: fnd_file.put_line(fnd_file.log,'Transaction Number : '||err_log_tbl(record_number).transaction_number);

Line 266: fnd_file.put_line(fnd_file.log,'----------------------------------');

262: END IF; -- val_log_tbl COUNT > 0
263: IF (err_log_tbl.COUNT > 0) THEN
264: fnd_file.put_line(fnd_file.log,'----------------------------------');
265: fnd_file.put_line(fnd_file.log,'TRANSACTIONS PROCESSED WITH ERRORS');
266: fnd_file.put_line(fnd_file.log,'----------------------------------');
267: FOR record_number in err_log_tbl.FIRST..err_log_tbl.LAST LOOP
268: fnd_file.new_line(fnd_file.log);
269: fnd_file.put_line(fnd_file.log,'Transaction Number : '||err_log_tbl(record_number).transaction_number);
270: fnd_file.put_line(fnd_file.log,'Contract Number : '||err_log_tbl(record_number).contract_number);

Line 268: fnd_file.new_line(fnd_file.log);

264: fnd_file.put_line(fnd_file.log,'----------------------------------');
265: fnd_file.put_line(fnd_file.log,'TRANSACTIONS PROCESSED WITH ERRORS');
266: fnd_file.put_line(fnd_file.log,'----------------------------------');
267: FOR record_number in err_log_tbl.FIRST..err_log_tbl.LAST LOOP
268: fnd_file.new_line(fnd_file.log);
269: fnd_file.put_line(fnd_file.log,'Transaction Number : '||err_log_tbl(record_number).transaction_number);
270: fnd_file.put_line(fnd_file.log,'Contract Number : '||err_log_tbl(record_number).contract_number);
271: fnd_file.put_line(fnd_file.log,'Quote Effective From Date : '||err_log_tbl(record_number).date_effective_from);
272: -- to find the meaning of quote_type_code

Line 269: fnd_file.put_line(fnd_file.log,'Transaction Number : '||err_log_tbl(record_number).transaction_number);

265: fnd_file.put_line(fnd_file.log,'TRANSACTIONS PROCESSED WITH ERRORS');
266: fnd_file.put_line(fnd_file.log,'----------------------------------');
267: FOR record_number in err_log_tbl.FIRST..err_log_tbl.LAST LOOP
268: fnd_file.new_line(fnd_file.log);
269: fnd_file.put_line(fnd_file.log,'Transaction Number : '||err_log_tbl(record_number).transaction_number);
270: fnd_file.put_line(fnd_file.log,'Contract Number : '||err_log_tbl(record_number).contract_number);
271: fnd_file.put_line(fnd_file.log,'Quote Effective From Date : '||err_log_tbl(record_number).date_effective_from);
272: -- to find the meaning of quote_type_code
273: l_quote_type := NULL;

Line 270: fnd_file.put_line(fnd_file.log,'Contract Number : '||err_log_tbl(record_number).contract_number);

266: fnd_file.put_line(fnd_file.log,'----------------------------------');
267: FOR record_number in err_log_tbl.FIRST..err_log_tbl.LAST LOOP
268: fnd_file.new_line(fnd_file.log);
269: fnd_file.put_line(fnd_file.log,'Transaction Number : '||err_log_tbl(record_number).transaction_number);
270: fnd_file.put_line(fnd_file.log,'Contract Number : '||err_log_tbl(record_number).contract_number);
271: fnd_file.put_line(fnd_file.log,'Quote Effective From Date : '||err_log_tbl(record_number).date_effective_from);
272: -- to find the meaning of quote_type_code
273: l_quote_type := NULL;
274: FOR get_type IN get_quote_type_meaning_csr(p_quote_type => err_log_tbl(record_number).quote_type)

Line 271: fnd_file.put_line(fnd_file.log,'Quote Effective From Date : '||err_log_tbl(record_number).date_effective_from);

267: FOR record_number in err_log_tbl.FIRST..err_log_tbl.LAST LOOP
268: fnd_file.new_line(fnd_file.log);
269: fnd_file.put_line(fnd_file.log,'Transaction Number : '||err_log_tbl(record_number).transaction_number);
270: fnd_file.put_line(fnd_file.log,'Contract Number : '||err_log_tbl(record_number).contract_number);
271: fnd_file.put_line(fnd_file.log,'Quote Effective From Date : '||err_log_tbl(record_number).date_effective_from);
272: -- to find the meaning of quote_type_code
273: l_quote_type := NULL;
274: FOR get_type IN get_quote_type_meaning_csr(p_quote_type => err_log_tbl(record_number).quote_type)
275: LOOP

Line 278: fnd_file.put(fnd_file.log,'Quote Type : ');

274: FOR get_type IN get_quote_type_meaning_csr(p_quote_type => err_log_tbl(record_number).quote_type)
275: LOOP
276: l_quote_type := get_type.meaning;
277: END LOOP;
278: fnd_file.put(fnd_file.log,'Quote Type : ');
279: IF(l_quote_type IS NOT NULL) THEN
280: fnd_file.put(fnd_file.log,l_quote_type);
281: END IF;
282: fnd_file.put_line(fnd_file.log,'( '||err_log_tbl(record_number).quote_type||' )');

Line 280: fnd_file.put(fnd_file.log,l_quote_type);

276: l_quote_type := get_type.meaning;
277: END LOOP;
278: fnd_file.put(fnd_file.log,'Quote Type : ');
279: IF(l_quote_type IS NOT NULL) THEN
280: fnd_file.put(fnd_file.log,l_quote_type);
281: END IF;
282: fnd_file.put_line(fnd_file.log,'( '||err_log_tbl(record_number).quote_type||' )');
283: -- to find the meaning of quote_reason_code
284: l_quote_reason := NULL;

Line 282: fnd_file.put_line(fnd_file.log,'( '||err_log_tbl(record_number).quote_type||' )');

278: fnd_file.put(fnd_file.log,'Quote Type : ');
279: IF(l_quote_type IS NOT NULL) THEN
280: fnd_file.put(fnd_file.log,l_quote_type);
281: END IF;
282: fnd_file.put_line(fnd_file.log,'( '||err_log_tbl(record_number).quote_type||' )');
283: -- to find the meaning of quote_reason_code
284: l_quote_reason := NULL;
285: FOR get_reason IN get_quote_reason_meaning_csr(p_quote_reason => err_log_tbl(record_number).quote_reason)
286: LOOP

Line 289: fnd_file.put(fnd_file.log,'Quote Reason : ');

285: FOR get_reason IN get_quote_reason_meaning_csr(p_quote_reason => err_log_tbl(record_number).quote_reason)
286: LOOP
287: l_quote_reason := get_reason.meaning;
288: END LOOP;
289: fnd_file.put(fnd_file.log,'Quote Reason : ');
290: IF(l_quote_reason IS NOT NULL) THEN
291: fnd_file.put(fnd_file.log,l_quote_reason);
292: END IF;
293: fnd_file.put_line(fnd_file.log,'( '||err_log_tbl(record_number).quote_reason||' )');

Line 291: fnd_file.put(fnd_file.log,l_quote_reason);

287: l_quote_reason := get_reason.meaning;
288: END LOOP;
289: fnd_file.put(fnd_file.log,'Quote Reason : ');
290: IF(l_quote_reason IS NOT NULL) THEN
291: fnd_file.put(fnd_file.log,l_quote_reason);
292: END IF;
293: fnd_file.put_line(fnd_file.log,'( '||err_log_tbl(record_number).quote_reason||' )');
294: fnd_file.put_line(fnd_file.log,'Asset Number : '||err_log_tbl(record_number).asset_number);
295: fnd_file.put_line(fnd_file.log,'Quote Number : '||err_log_tbl(record_number).quote_number);

Line 293: fnd_file.put_line(fnd_file.log,'( '||err_log_tbl(record_number).quote_reason||' )');

289: fnd_file.put(fnd_file.log,'Quote Reason : ');
290: IF(l_quote_reason IS NOT NULL) THEN
291: fnd_file.put(fnd_file.log,l_quote_reason);
292: END IF;
293: fnd_file.put_line(fnd_file.log,'( '||err_log_tbl(record_number).quote_reason||' )');
294: fnd_file.put_line(fnd_file.log,'Asset Number : '||err_log_tbl(record_number).asset_number);
295: fnd_file.put_line(fnd_file.log,'Quote Number : '||err_log_tbl(record_number).quote_number);
296: fnd_file.put_line(fnd_file.log,'Messages ');
297: count_msg := 1;

Line 294: fnd_file.put_line(fnd_file.log,'Asset Number : '||err_log_tbl(record_number).asset_number);

290: IF(l_quote_reason IS NOT NULL) THEN
291: fnd_file.put(fnd_file.log,l_quote_reason);
292: END IF;
293: fnd_file.put_line(fnd_file.log,'( '||err_log_tbl(record_number).quote_reason||' )');
294: fnd_file.put_line(fnd_file.log,'Asset Number : '||err_log_tbl(record_number).asset_number);
295: fnd_file.put_line(fnd_file.log,'Quote Number : '||err_log_tbl(record_number).quote_number);
296: fnd_file.put_line(fnd_file.log,'Messages ');
297: count_msg := 1;
298:

Line 295: fnd_file.put_line(fnd_file.log,'Quote Number : '||err_log_tbl(record_number).quote_number);

291: fnd_file.put(fnd_file.log,l_quote_reason);
292: END IF;
293: fnd_file.put_line(fnd_file.log,'( '||err_log_tbl(record_number).quote_reason||' )');
294: fnd_file.put_line(fnd_file.log,'Asset Number : '||err_log_tbl(record_number).asset_number);
295: fnd_file.put_line(fnd_file.log,'Quote Number : '||err_log_tbl(record_number).quote_number);
296: fnd_file.put_line(fnd_file.log,'Messages ');
297: count_msg := 1;
298:
299: -- modified for BUG#3062867

Line 296: fnd_file.put_line(fnd_file.log,'Messages ');

292: END IF;
293: fnd_file.put_line(fnd_file.log,'( '||err_log_tbl(record_number).quote_reason||' )');
294: fnd_file.put_line(fnd_file.log,'Asset Number : '||err_log_tbl(record_number).asset_number);
295: fnd_file.put_line(fnd_file.log,'Quote Number : '||err_log_tbl(record_number).quote_number);
296: fnd_file.put_line(fnd_file.log,'Messages ');
297: count_msg := 1;
298:
299: -- modified for BUG#3062867
300: IF(err_msg_tbl.COUNT>0) THEN

Line 304: fnd_file.put_line(fnd_file.log,count_msg||': '||err_msg_tbl(i).msg_text);

300: IF(err_msg_tbl.COUNT>0) THEN
301: FOR i IN err_msg_tbl.FIRST..err_msg_tbl.LAST
302: LOOP
303: IF(err_msg_tbl(i).transaction_number = err_log_tbl(record_number).transaction_number) THEN
304: fnd_file.put_line(fnd_file.log,count_msg||': '||err_msg_tbl(i).msg_text);
305: count_msg := count_msg+1;
306: END IF;
307: END LOOP;
308: END IF;

Line 310: fnd_file.new_line(fnd_file.log);

306: END IF;
307: END LOOP;
308: END IF;
309:
310: fnd_file.new_line(fnd_file.log);
311: END LOOP;
312: END IF; -- err_log_tbl COUNT > 0
313: count_msg := 1;
314: -- statement came along with flag 'Y'

Line 318: fnd_file.put_line(fnd_file.log,count_msg ||': '||msg_tbl(i).msg_text);

314: -- statement came along with flag 'Y'
315: IF(msg_tbl.COUNT>0) THEN
316: FOR i IN msg_tbl.FIRST..msg_tbl.LAST
317: LOOP
318: fnd_file.put_line(fnd_file.log,count_msg ||': '||msg_tbl(i).msg_text);
319: count_msg := count_msg+1;
320: END LOOP;
321: END IF;
322: fnd_file.put_line(fnd_file.log,'=======================================');

Line 322: fnd_file.put_line(fnd_file.log,'=======================================');

318: fnd_file.put_line(fnd_file.log,count_msg ||': '||msg_tbl(i).msg_text);
319: count_msg := count_msg+1;
320: END LOOP;
321: END IF;
322: fnd_file.put_line(fnd_file.log,'=======================================');
323: END IF;
324: -- enter the messages in to OUTPUT
325: IF(log_msg_flag = 'O') THEN
326: tot_count := p_quote_number;

Line 335: fnd_file.put_line(fnd_file.output,'=======================================');

331: FOR org_rec IN org_csr (l_org_id) LOOP
332: l_org_name := org_rec.name;
333: END LOOP;
334: -- loop through the message and write to CM log
335: fnd_file.put_line(fnd_file.output,'=======================================');
336: fnd_file.put_line(fnd_file.output,'Termination Interface - OUTPUT MESSAGES');
337: fnd_file.put_line(fnd_file.output,'=======================================');
338: fnd_file.put_line(fnd_file.output,'Operating Unit :'||l_org_name);
339: fnd_file.put_line(fnd_file.output,'Run Date :'||SYSDATE);

Line 336: fnd_file.put_line(fnd_file.output,'Termination Interface - OUTPUT MESSAGES');

332: l_org_name := org_rec.name;
333: END LOOP;
334: -- loop through the message and write to CM log
335: fnd_file.put_line(fnd_file.output,'=======================================');
336: fnd_file.put_line(fnd_file.output,'Termination Interface - OUTPUT MESSAGES');
337: fnd_file.put_line(fnd_file.output,'=======================================');
338: fnd_file.put_line(fnd_file.output,'Operating Unit :'||l_org_name);
339: fnd_file.put_line(fnd_file.output,'Run Date :'||SYSDATE);
340: fnd_file.new_line(fnd_file.output);

Line 337: fnd_file.put_line(fnd_file.output,'=======================================');

333: END LOOP;
334: -- loop through the message and write to CM log
335: fnd_file.put_line(fnd_file.output,'=======================================');
336: fnd_file.put_line(fnd_file.output,'Termination Interface - OUTPUT MESSAGES');
337: fnd_file.put_line(fnd_file.output,'=======================================');
338: fnd_file.put_line(fnd_file.output,'Operating Unit :'||l_org_name);
339: fnd_file.put_line(fnd_file.output,'Run Date :'||SYSDATE);
340: fnd_file.new_line(fnd_file.output);
341: fnd_file.put_line(fnd_file.output,'-----------------------');

Line 338: fnd_file.put_line(fnd_file.output,'Operating Unit :'||l_org_name);

334: -- loop through the message and write to CM log
335: fnd_file.put_line(fnd_file.output,'=======================================');
336: fnd_file.put_line(fnd_file.output,'Termination Interface - OUTPUT MESSAGES');
337: fnd_file.put_line(fnd_file.output,'=======================================');
338: fnd_file.put_line(fnd_file.output,'Operating Unit :'||l_org_name);
339: fnd_file.put_line(fnd_file.output,'Run Date :'||SYSDATE);
340: fnd_file.new_line(fnd_file.output);
341: fnd_file.put_line(fnd_file.output,'-----------------------');
342: fnd_file.put_line(fnd_file.output,'SUMMARY OF TRANSACTIONS');

Line 339: fnd_file.put_line(fnd_file.output,'Run Date :'||SYSDATE);

335: fnd_file.put_line(fnd_file.output,'=======================================');
336: fnd_file.put_line(fnd_file.output,'Termination Interface - OUTPUT MESSAGES');
337: fnd_file.put_line(fnd_file.output,'=======================================');
338: fnd_file.put_line(fnd_file.output,'Operating Unit :'||l_org_name);
339: fnd_file.put_line(fnd_file.output,'Run Date :'||SYSDATE);
340: fnd_file.new_line(fnd_file.output);
341: fnd_file.put_line(fnd_file.output,'-----------------------');
342: fnd_file.put_line(fnd_file.output,'SUMMARY OF TRANSACTIONS');
343: fnd_file.put_line(fnd_file.output,'-----------------------');

Line 340: fnd_file.new_line(fnd_file.output);

336: fnd_file.put_line(fnd_file.output,'Termination Interface - OUTPUT MESSAGES');
337: fnd_file.put_line(fnd_file.output,'=======================================');
338: fnd_file.put_line(fnd_file.output,'Operating Unit :'||l_org_name);
339: fnd_file.put_line(fnd_file.output,'Run Date :'||SYSDATE);
340: fnd_file.new_line(fnd_file.output);
341: fnd_file.put_line(fnd_file.output,'-----------------------');
342: fnd_file.put_line(fnd_file.output,'SUMMARY OF TRANSACTIONS');
343: fnd_file.put_line(fnd_file.output,'-----------------------');
344: fnd_file.new_line(fnd_file.output);

Line 341: fnd_file.put_line(fnd_file.output,'-----------------------');

337: fnd_file.put_line(fnd_file.output,'=======================================');
338: fnd_file.put_line(fnd_file.output,'Operating Unit :'||l_org_name);
339: fnd_file.put_line(fnd_file.output,'Run Date :'||SYSDATE);
340: fnd_file.new_line(fnd_file.output);
341: fnd_file.put_line(fnd_file.output,'-----------------------');
342: fnd_file.put_line(fnd_file.output,'SUMMARY OF TRANSACTIONS');
343: fnd_file.put_line(fnd_file.output,'-----------------------');
344: fnd_file.new_line(fnd_file.output);
345: fnd_file.put_line(fnd_file.output,'Processed Successfully : '||pro_count);

Line 342: fnd_file.put_line(fnd_file.output,'SUMMARY OF TRANSACTIONS');

338: fnd_file.put_line(fnd_file.output,'Operating Unit :'||l_org_name);
339: fnd_file.put_line(fnd_file.output,'Run Date :'||SYSDATE);
340: fnd_file.new_line(fnd_file.output);
341: fnd_file.put_line(fnd_file.output,'-----------------------');
342: fnd_file.put_line(fnd_file.output,'SUMMARY OF TRANSACTIONS');
343: fnd_file.put_line(fnd_file.output,'-----------------------');
344: fnd_file.new_line(fnd_file.output);
345: fnd_file.put_line(fnd_file.output,'Processed Successfully : '||pro_count);
346: fnd_file.put_line(fnd_file.output,'Not Processed Due To Errors : '||val_count);

Line 343: fnd_file.put_line(fnd_file.output,'-----------------------');

339: fnd_file.put_line(fnd_file.output,'Run Date :'||SYSDATE);
340: fnd_file.new_line(fnd_file.output);
341: fnd_file.put_line(fnd_file.output,'-----------------------');
342: fnd_file.put_line(fnd_file.output,'SUMMARY OF TRANSACTIONS');
343: fnd_file.put_line(fnd_file.output,'-----------------------');
344: fnd_file.new_line(fnd_file.output);
345: fnd_file.put_line(fnd_file.output,'Processed Successfully : '||pro_count);
346: fnd_file.put_line(fnd_file.output,'Not Processed Due To Errors : '||val_count);
347: fnd_file.put_line(fnd_file.output,'Processed with Errors : '||err_count);

Line 344: fnd_file.new_line(fnd_file.output);

340: fnd_file.new_line(fnd_file.output);
341: fnd_file.put_line(fnd_file.output,'-----------------------');
342: fnd_file.put_line(fnd_file.output,'SUMMARY OF TRANSACTIONS');
343: fnd_file.put_line(fnd_file.output,'-----------------------');
344: fnd_file.new_line(fnd_file.output);
345: fnd_file.put_line(fnd_file.output,'Processed Successfully : '||pro_count);
346: fnd_file.put_line(fnd_file.output,'Not Processed Due To Errors : '||val_count);
347: fnd_file.put_line(fnd_file.output,'Processed with Errors : '||err_count);
348: fnd_file.new_line(fnd_file.output);

Line 345: fnd_file.put_line(fnd_file.output,'Processed Successfully : '||pro_count);

341: fnd_file.put_line(fnd_file.output,'-----------------------');
342: fnd_file.put_line(fnd_file.output,'SUMMARY OF TRANSACTIONS');
343: fnd_file.put_line(fnd_file.output,'-----------------------');
344: fnd_file.new_line(fnd_file.output);
345: fnd_file.put_line(fnd_file.output,'Processed Successfully : '||pro_count);
346: fnd_file.put_line(fnd_file.output,'Not Processed Due To Errors : '||val_count);
347: fnd_file.put_line(fnd_file.output,'Processed with Errors : '||err_count);
348: fnd_file.new_line(fnd_file.output);
349: --pro_count := pro_log_tbl.COUNT+val_log_tbl.COUNT+err_log_tbl.COUNT;

Line 346: fnd_file.put_line(fnd_file.output,'Not Processed Due To Errors : '||val_count);

342: fnd_file.put_line(fnd_file.output,'SUMMARY OF TRANSACTIONS');
343: fnd_file.put_line(fnd_file.output,'-----------------------');
344: fnd_file.new_line(fnd_file.output);
345: fnd_file.put_line(fnd_file.output,'Processed Successfully : '||pro_count);
346: fnd_file.put_line(fnd_file.output,'Not Processed Due To Errors : '||val_count);
347: fnd_file.put_line(fnd_file.output,'Processed with Errors : '||err_count);
348: fnd_file.new_line(fnd_file.output);
349: --pro_count := pro_log_tbl.COUNT+val_log_tbl.COUNT+err_log_tbl.COUNT;
350: fnd_file.put_line(fnd_file.output,'Total Records : '||tot_count);

Line 347: fnd_file.put_line(fnd_file.output,'Processed with Errors : '||err_count);

343: fnd_file.put_line(fnd_file.output,'-----------------------');
344: fnd_file.new_line(fnd_file.output);
345: fnd_file.put_line(fnd_file.output,'Processed Successfully : '||pro_count);
346: fnd_file.put_line(fnd_file.output,'Not Processed Due To Errors : '||val_count);
347: fnd_file.put_line(fnd_file.output,'Processed with Errors : '||err_count);
348: fnd_file.new_line(fnd_file.output);
349: --pro_count := pro_log_tbl.COUNT+val_log_tbl.COUNT+err_log_tbl.COUNT;
350: fnd_file.put_line(fnd_file.output,'Total Records : '||tot_count);
351: fnd_file.new_line(fnd_file.output);

Line 348: fnd_file.new_line(fnd_file.output);

344: fnd_file.new_line(fnd_file.output);
345: fnd_file.put_line(fnd_file.output,'Processed Successfully : '||pro_count);
346: fnd_file.put_line(fnd_file.output,'Not Processed Due To Errors : '||val_count);
347: fnd_file.put_line(fnd_file.output,'Processed with Errors : '||err_count);
348: fnd_file.new_line(fnd_file.output);
349: --pro_count := pro_log_tbl.COUNT+val_log_tbl.COUNT+err_log_tbl.COUNT;
350: fnd_file.put_line(fnd_file.output,'Total Records : '||tot_count);
351: fnd_file.new_line(fnd_file.output);
352: IF (val_log_tbl.COUNT > 0) THEN

Line 350: fnd_file.put_line(fnd_file.output,'Total Records : '||tot_count);

346: fnd_file.put_line(fnd_file.output,'Not Processed Due To Errors : '||val_count);
347: fnd_file.put_line(fnd_file.output,'Processed with Errors : '||err_count);
348: fnd_file.new_line(fnd_file.output);
349: --pro_count := pro_log_tbl.COUNT+val_log_tbl.COUNT+err_log_tbl.COUNT;
350: fnd_file.put_line(fnd_file.output,'Total Records : '||tot_count);
351: fnd_file.new_line(fnd_file.output);
352: IF (val_log_tbl.COUNT > 0) THEN
353: fnd_file.put_line(fnd_file.output,'----------------------------------------');
354: fnd_file.put_line(fnd_file.output,'TRANSACTIONS NOT PROCESSED DUE TO ERRORS');

Line 351: fnd_file.new_line(fnd_file.output);

347: fnd_file.put_line(fnd_file.output,'Processed with Errors : '||err_count);
348: fnd_file.new_line(fnd_file.output);
349: --pro_count := pro_log_tbl.COUNT+val_log_tbl.COUNT+err_log_tbl.COUNT;
350: fnd_file.put_line(fnd_file.output,'Total Records : '||tot_count);
351: fnd_file.new_line(fnd_file.output);
352: IF (val_log_tbl.COUNT > 0) THEN
353: fnd_file.put_line(fnd_file.output,'----------------------------------------');
354: fnd_file.put_line(fnd_file.output,'TRANSACTIONS NOT PROCESSED DUE TO ERRORS');
355: fnd_file.put_line(fnd_file.output,'----------------------------------------');

Line 353: fnd_file.put_line(fnd_file.output,'----------------------------------------');

349: --pro_count := pro_log_tbl.COUNT+val_log_tbl.COUNT+err_log_tbl.COUNT;
350: fnd_file.put_line(fnd_file.output,'Total Records : '||tot_count);
351: fnd_file.new_line(fnd_file.output);
352: IF (val_log_tbl.COUNT > 0) THEN
353: fnd_file.put_line(fnd_file.output,'----------------------------------------');
354: fnd_file.put_line(fnd_file.output,'TRANSACTIONS NOT PROCESSED DUE TO ERRORS');
355: fnd_file.put_line(fnd_file.output,'----------------------------------------');
356: FOR record_number in val_log_tbl.FIRST..val_log_tbl.LAST LOOP
357: fnd_file.new_line(fnd_file.output);

Line 354: fnd_file.put_line(fnd_file.output,'TRANSACTIONS NOT PROCESSED DUE TO ERRORS');

350: fnd_file.put_line(fnd_file.output,'Total Records : '||tot_count);
351: fnd_file.new_line(fnd_file.output);
352: IF (val_log_tbl.COUNT > 0) THEN
353: fnd_file.put_line(fnd_file.output,'----------------------------------------');
354: fnd_file.put_line(fnd_file.output,'TRANSACTIONS NOT PROCESSED DUE TO ERRORS');
355: fnd_file.put_line(fnd_file.output,'----------------------------------------');
356: FOR record_number in val_log_tbl.FIRST..val_log_tbl.LAST LOOP
357: fnd_file.new_line(fnd_file.output);
358: fnd_file.put_line(fnd_file.output,'Transaction Number : '||val_log_tbl(record_number).transaction_number);

Line 355: fnd_file.put_line(fnd_file.output,'----------------------------------------');

351: fnd_file.new_line(fnd_file.output);
352: IF (val_log_tbl.COUNT > 0) THEN
353: fnd_file.put_line(fnd_file.output,'----------------------------------------');
354: fnd_file.put_line(fnd_file.output,'TRANSACTIONS NOT PROCESSED DUE TO ERRORS');
355: fnd_file.put_line(fnd_file.output,'----------------------------------------');
356: FOR record_number in val_log_tbl.FIRST..val_log_tbl.LAST LOOP
357: fnd_file.new_line(fnd_file.output);
358: fnd_file.put_line(fnd_file.output,'Transaction Number : '||val_log_tbl(record_number).transaction_number);
359: fnd_file.put_line(fnd_file.output,'Contract Number : '||val_log_tbl(record_number).contract_number);

Line 357: fnd_file.new_line(fnd_file.output);

353: fnd_file.put_line(fnd_file.output,'----------------------------------------');
354: fnd_file.put_line(fnd_file.output,'TRANSACTIONS NOT PROCESSED DUE TO ERRORS');
355: fnd_file.put_line(fnd_file.output,'----------------------------------------');
356: FOR record_number in val_log_tbl.FIRST..val_log_tbl.LAST LOOP
357: fnd_file.new_line(fnd_file.output);
358: fnd_file.put_line(fnd_file.output,'Transaction Number : '||val_log_tbl(record_number).transaction_number);
359: fnd_file.put_line(fnd_file.output,'Contract Number : '||val_log_tbl(record_number).contract_number);
360: fnd_file.put_line(fnd_file.output,'Quote Effective From Date : '||val_log_tbl(record_number).date_effective_from);
361:

Line 358: fnd_file.put_line(fnd_file.output,'Transaction Number : '||val_log_tbl(record_number).transaction_number);

354: fnd_file.put_line(fnd_file.output,'TRANSACTIONS NOT PROCESSED DUE TO ERRORS');
355: fnd_file.put_line(fnd_file.output,'----------------------------------------');
356: FOR record_number in val_log_tbl.FIRST..val_log_tbl.LAST LOOP
357: fnd_file.new_line(fnd_file.output);
358: fnd_file.put_line(fnd_file.output,'Transaction Number : '||val_log_tbl(record_number).transaction_number);
359: fnd_file.put_line(fnd_file.output,'Contract Number : '||val_log_tbl(record_number).contract_number);
360: fnd_file.put_line(fnd_file.output,'Quote Effective From Date : '||val_log_tbl(record_number).date_effective_from);
361:
362: -- to find the meaning of quote_type_code

Line 359: fnd_file.put_line(fnd_file.output,'Contract Number : '||val_log_tbl(record_number).contract_number);

355: fnd_file.put_line(fnd_file.output,'----------------------------------------');
356: FOR record_number in val_log_tbl.FIRST..val_log_tbl.LAST LOOP
357: fnd_file.new_line(fnd_file.output);
358: fnd_file.put_line(fnd_file.output,'Transaction Number : '||val_log_tbl(record_number).transaction_number);
359: fnd_file.put_line(fnd_file.output,'Contract Number : '||val_log_tbl(record_number).contract_number);
360: fnd_file.put_line(fnd_file.output,'Quote Effective From Date : '||val_log_tbl(record_number).date_effective_from);
361:
362: -- to find the meaning of quote_type_code
363: l_quote_type := NULL;

Line 360: fnd_file.put_line(fnd_file.output,'Quote Effective From Date : '||val_log_tbl(record_number).date_effective_from);

356: FOR record_number in val_log_tbl.FIRST..val_log_tbl.LAST LOOP
357: fnd_file.new_line(fnd_file.output);
358: fnd_file.put_line(fnd_file.output,'Transaction Number : '||val_log_tbl(record_number).transaction_number);
359: fnd_file.put_line(fnd_file.output,'Contract Number : '||val_log_tbl(record_number).contract_number);
360: fnd_file.put_line(fnd_file.output,'Quote Effective From Date : '||val_log_tbl(record_number).date_effective_from);
361:
362: -- to find the meaning of quote_type_code
363: l_quote_type := NULL;
364: FOR get_type IN get_quote_type_meaning_csr(p_quote_type => val_log_tbl(record_number).quote_type)

Line 368: fnd_file.put(fnd_file.output,'Quote Type : ');

364: FOR get_type IN get_quote_type_meaning_csr(p_quote_type => val_log_tbl(record_number).quote_type)
365: LOOP
366: l_quote_type := get_type.meaning;
367: END LOOP;
368: fnd_file.put(fnd_file.output,'Quote Type : ');
369: IF(l_quote_type IS NOT NULL) THEN
370: fnd_file.put(fnd_file.output,l_quote_type);
371: END IF;
372: fnd_file.put_line(fnd_file.output,'( '||val_log_tbl(record_number).quote_type||' )');

Line 370: fnd_file.put(fnd_file.output,l_quote_type);

366: l_quote_type := get_type.meaning;
367: END LOOP;
368: fnd_file.put(fnd_file.output,'Quote Type : ');
369: IF(l_quote_type IS NOT NULL) THEN
370: fnd_file.put(fnd_file.output,l_quote_type);
371: END IF;
372: fnd_file.put_line(fnd_file.output,'( '||val_log_tbl(record_number).quote_type||' )');
373: -- to find the meaning of quote_reason_code
374: l_quote_reason := NULL;

Line 372: fnd_file.put_line(fnd_file.output,'( '||val_log_tbl(record_number).quote_type||' )');

368: fnd_file.put(fnd_file.output,'Quote Type : ');
369: IF(l_quote_type IS NOT NULL) THEN
370: fnd_file.put(fnd_file.output,l_quote_type);
371: END IF;
372: fnd_file.put_line(fnd_file.output,'( '||val_log_tbl(record_number).quote_type||' )');
373: -- to find the meaning of quote_reason_code
374: l_quote_reason := NULL;
375: FOR get_reason IN get_quote_reason_meaning_csr(p_quote_reason => val_log_tbl(record_number).quote_reason)
376: LOOP

Line 379: fnd_file.put(fnd_file.output,'Quote Reason : ');

375: FOR get_reason IN get_quote_reason_meaning_csr(p_quote_reason => val_log_tbl(record_number).quote_reason)
376: LOOP
377: l_quote_reason := get_reason.meaning;
378: END LOOP;
379: fnd_file.put(fnd_file.output,'Quote Reason : ');
380: IF(l_quote_reason IS NOT NULL) THEN
381: fnd_file.put(fnd_file.output,l_quote_reason);
382: END IF;
383: fnd_file.put_line(fnd_file.output,'( '||val_log_tbl(record_number).quote_reason||' )');

Line 381: fnd_file.put(fnd_file.output,l_quote_reason);

377: l_quote_reason := get_reason.meaning;
378: END LOOP;
379: fnd_file.put(fnd_file.output,'Quote Reason : ');
380: IF(l_quote_reason IS NOT NULL) THEN
381: fnd_file.put(fnd_file.output,l_quote_reason);
382: END IF;
383: fnd_file.put_line(fnd_file.output,'( '||val_log_tbl(record_number).quote_reason||' )');
384: fnd_file.put_line(fnd_file.output,'Asset Number : '||val_log_tbl(record_number).asset_number);
385: fnd_file.put_line(fnd_file.output,'Messages ');

Line 383: fnd_file.put_line(fnd_file.output,'( '||val_log_tbl(record_number).quote_reason||' )');

379: fnd_file.put(fnd_file.output,'Quote Reason : ');
380: IF(l_quote_reason IS NOT NULL) THEN
381: fnd_file.put(fnd_file.output,l_quote_reason);
382: END IF;
383: fnd_file.put_line(fnd_file.output,'( '||val_log_tbl(record_number).quote_reason||' )');
384: fnd_file.put_line(fnd_file.output,'Asset Number : '||val_log_tbl(record_number).asset_number);
385: fnd_file.put_line(fnd_file.output,'Messages ');
386: count_msg := 1;
387:

Line 384: fnd_file.put_line(fnd_file.output,'Asset Number : '||val_log_tbl(record_number).asset_number);

380: IF(l_quote_reason IS NOT NULL) THEN
381: fnd_file.put(fnd_file.output,l_quote_reason);
382: END IF;
383: fnd_file.put_line(fnd_file.output,'( '||val_log_tbl(record_number).quote_reason||' )');
384: fnd_file.put_line(fnd_file.output,'Asset Number : '||val_log_tbl(record_number).asset_number);
385: fnd_file.put_line(fnd_file.output,'Messages ');
386: count_msg := 1;
387:
388: -- modified for BUG#3062867

Line 385: fnd_file.put_line(fnd_file.output,'Messages ');

381: fnd_file.put(fnd_file.output,l_quote_reason);
382: END IF;
383: fnd_file.put_line(fnd_file.output,'( '||val_log_tbl(record_number).quote_reason||' )');
384: fnd_file.put_line(fnd_file.output,'Asset Number : '||val_log_tbl(record_number).asset_number);
385: fnd_file.put_line(fnd_file.output,'Messages ');
386: count_msg := 1;
387:
388: -- modified for BUG#3062867
389: IF(val_msg_tbl.COUNT>0) THEN

Line 393: fnd_file.put_line(fnd_file.output,count_msg||': '||val_msg_tbl(i).msg_text);

389: IF(val_msg_tbl.COUNT>0) THEN
390: FOR i IN val_msg_tbl.FIRST..val_msg_tbl.LAST
391: LOOP
392: IF(val_msg_tbl(i).transaction_number = val_log_tbl(record_number).transaction_number) THEN
393: fnd_file.put_line(fnd_file.output,count_msg||': '||val_msg_tbl(i).msg_text);
394: count_msg := count_msg+1;
395: END IF;
396: END LOOP;
397: END IF;

Line 399: fnd_file.new_line(fnd_file.output);

395: END IF;
396: END LOOP;
397: END IF;
398:
399: fnd_file.new_line(fnd_file.output);
400: END LOOP;
401: END IF; -- val_msg_tbl COUNT > 0
402: IF (err_log_tbl.COUNT > 0) THEN
403: fnd_file.put_line(fnd_file.output,'----------------------------------');

Line 403: fnd_file.put_line(fnd_file.output,'----------------------------------');

399: fnd_file.new_line(fnd_file.output);
400: END LOOP;
401: END IF; -- val_msg_tbl COUNT > 0
402: IF (err_log_tbl.COUNT > 0) THEN
403: fnd_file.put_line(fnd_file.output,'----------------------------------');
404: fnd_file.put_line(fnd_file.output,'TRANSACTIONS PROCESSED WITH ERRORS');
405: fnd_file.put_line(fnd_file.output,'----------------------------------');
406: FOR record_number in err_log_tbl.FIRST..err_log_tbl.LAST LOOP
407: fnd_file.new_line(fnd_file.output);

Line 404: fnd_file.put_line(fnd_file.output,'TRANSACTIONS PROCESSED WITH ERRORS');

400: END LOOP;
401: END IF; -- val_msg_tbl COUNT > 0
402: IF (err_log_tbl.COUNT > 0) THEN
403: fnd_file.put_line(fnd_file.output,'----------------------------------');
404: fnd_file.put_line(fnd_file.output,'TRANSACTIONS PROCESSED WITH ERRORS');
405: fnd_file.put_line(fnd_file.output,'----------------------------------');
406: FOR record_number in err_log_tbl.FIRST..err_log_tbl.LAST LOOP
407: fnd_file.new_line(fnd_file.output);
408: fnd_file.put_line(fnd_file.output,'Transaction Number : '||err_log_tbl(record_number).transaction_number);

Line 405: fnd_file.put_line(fnd_file.output,'----------------------------------');

401: END IF; -- val_msg_tbl COUNT > 0
402: IF (err_log_tbl.COUNT > 0) THEN
403: fnd_file.put_line(fnd_file.output,'----------------------------------');
404: fnd_file.put_line(fnd_file.output,'TRANSACTIONS PROCESSED WITH ERRORS');
405: fnd_file.put_line(fnd_file.output,'----------------------------------');
406: FOR record_number in err_log_tbl.FIRST..err_log_tbl.LAST LOOP
407: fnd_file.new_line(fnd_file.output);
408: fnd_file.put_line(fnd_file.output,'Transaction Number : '||err_log_tbl(record_number).transaction_number);
409: fnd_file.put_line(fnd_file.output,'Contract Number : '||err_log_tbl(record_number).contract_number);

Line 407: fnd_file.new_line(fnd_file.output);

403: fnd_file.put_line(fnd_file.output,'----------------------------------');
404: fnd_file.put_line(fnd_file.output,'TRANSACTIONS PROCESSED WITH ERRORS');
405: fnd_file.put_line(fnd_file.output,'----------------------------------');
406: FOR record_number in err_log_tbl.FIRST..err_log_tbl.LAST LOOP
407: fnd_file.new_line(fnd_file.output);
408: fnd_file.put_line(fnd_file.output,'Transaction Number : '||err_log_tbl(record_number).transaction_number);
409: fnd_file.put_line(fnd_file.output,'Contract Number : '||err_log_tbl(record_number).contract_number);
410: fnd_file.put_line(fnd_file.output,'Quote Effective From Date : '||err_log_tbl(record_number).date_effective_from);
411: -- to find the meaning of quote_type_code

Line 408: fnd_file.put_line(fnd_file.output,'Transaction Number : '||err_log_tbl(record_number).transaction_number);

404: fnd_file.put_line(fnd_file.output,'TRANSACTIONS PROCESSED WITH ERRORS');
405: fnd_file.put_line(fnd_file.output,'----------------------------------');
406: FOR record_number in err_log_tbl.FIRST..err_log_tbl.LAST LOOP
407: fnd_file.new_line(fnd_file.output);
408: fnd_file.put_line(fnd_file.output,'Transaction Number : '||err_log_tbl(record_number).transaction_number);
409: fnd_file.put_line(fnd_file.output,'Contract Number : '||err_log_tbl(record_number).contract_number);
410: fnd_file.put_line(fnd_file.output,'Quote Effective From Date : '||err_log_tbl(record_number).date_effective_from);
411: -- to find the meaning of quote_type_code
412: l_quote_type := NULL;

Line 409: fnd_file.put_line(fnd_file.output,'Contract Number : '||err_log_tbl(record_number).contract_number);

405: fnd_file.put_line(fnd_file.output,'----------------------------------');
406: FOR record_number in err_log_tbl.FIRST..err_log_tbl.LAST LOOP
407: fnd_file.new_line(fnd_file.output);
408: fnd_file.put_line(fnd_file.output,'Transaction Number : '||err_log_tbl(record_number).transaction_number);
409: fnd_file.put_line(fnd_file.output,'Contract Number : '||err_log_tbl(record_number).contract_number);
410: fnd_file.put_line(fnd_file.output,'Quote Effective From Date : '||err_log_tbl(record_number).date_effective_from);
411: -- to find the meaning of quote_type_code
412: l_quote_type := NULL;
413: FOR get_type IN get_quote_type_meaning_csr(p_quote_type => err_log_tbl(record_number).quote_type)

Line 410: fnd_file.put_line(fnd_file.output,'Quote Effective From Date : '||err_log_tbl(record_number).date_effective_from);

406: FOR record_number in err_log_tbl.FIRST..err_log_tbl.LAST LOOP
407: fnd_file.new_line(fnd_file.output);
408: fnd_file.put_line(fnd_file.output,'Transaction Number : '||err_log_tbl(record_number).transaction_number);
409: fnd_file.put_line(fnd_file.output,'Contract Number : '||err_log_tbl(record_number).contract_number);
410: fnd_file.put_line(fnd_file.output,'Quote Effective From Date : '||err_log_tbl(record_number).date_effective_from);
411: -- to find the meaning of quote_type_code
412: l_quote_type := NULL;
413: FOR get_type IN get_quote_type_meaning_csr(p_quote_type => err_log_tbl(record_number).quote_type)
414: LOOP

Line 417: fnd_file.put(fnd_file.output,'Quote Type : ');

413: FOR get_type IN get_quote_type_meaning_csr(p_quote_type => err_log_tbl(record_number).quote_type)
414: LOOP
415: l_quote_type := get_type.meaning;
416: END LOOP;
417: fnd_file.put(fnd_file.output,'Quote Type : ');
418: IF(l_quote_type IS NOT NULL) THEN
419: fnd_file.put(fnd_file.output,l_quote_type);
420: END IF;
421: fnd_file.put_line(fnd_file.output,'( '||err_log_tbl(record_number).quote_type||' )');

Line 419: fnd_file.put(fnd_file.output,l_quote_type);

415: l_quote_type := get_type.meaning;
416: END LOOP;
417: fnd_file.put(fnd_file.output,'Quote Type : ');
418: IF(l_quote_type IS NOT NULL) THEN
419: fnd_file.put(fnd_file.output,l_quote_type);
420: END IF;
421: fnd_file.put_line(fnd_file.output,'( '||err_log_tbl(record_number).quote_type||' )');
422: -- to find the meaning of quote_reason_code
423: l_quote_reason := NULL;

Line 421: fnd_file.put_line(fnd_file.output,'( '||err_log_tbl(record_number).quote_type||' )');

417: fnd_file.put(fnd_file.output,'Quote Type : ');
418: IF(l_quote_type IS NOT NULL) THEN
419: fnd_file.put(fnd_file.output,l_quote_type);
420: END IF;
421: fnd_file.put_line(fnd_file.output,'( '||err_log_tbl(record_number).quote_type||' )');
422: -- to find the meaning of quote_reason_code
423: l_quote_reason := NULL;
424: FOR get_reason IN get_quote_reason_meaning_csr(p_quote_reason => err_log_tbl(record_number).quote_reason)
425: LOOP

Line 428: fnd_file.put(fnd_file.output,'Quote Reason : ');

424: FOR get_reason IN get_quote_reason_meaning_csr(p_quote_reason => err_log_tbl(record_number).quote_reason)
425: LOOP
426: l_quote_reason := get_reason.meaning;
427: END LOOP;
428: fnd_file.put(fnd_file.output,'Quote Reason : ');
429: IF(l_quote_reason IS NOT NULL) THEN
430: fnd_file.put(fnd_file.output,l_quote_reason);
431: END IF;
432: fnd_file.put_line(fnd_file.output,'( '||err_log_tbl(record_number).quote_reason||' )');

Line 430: fnd_file.put(fnd_file.output,l_quote_reason);

426: l_quote_reason := get_reason.meaning;
427: END LOOP;
428: fnd_file.put(fnd_file.output,'Quote Reason : ');
429: IF(l_quote_reason IS NOT NULL) THEN
430: fnd_file.put(fnd_file.output,l_quote_reason);
431: END IF;
432: fnd_file.put_line(fnd_file.output,'( '||err_log_tbl(record_number).quote_reason||' )');
433: fnd_file.put_line(fnd_file.output,'Asset Number : '||err_log_tbl(record_number).asset_number);
434: fnd_file.put_line(fnd_file.output,'Quote Number : '||err_log_tbl(record_number).quote_number);

Line 432: fnd_file.put_line(fnd_file.output,'( '||err_log_tbl(record_number).quote_reason||' )');

428: fnd_file.put(fnd_file.output,'Quote Reason : ');
429: IF(l_quote_reason IS NOT NULL) THEN
430: fnd_file.put(fnd_file.output,l_quote_reason);
431: END IF;
432: fnd_file.put_line(fnd_file.output,'( '||err_log_tbl(record_number).quote_reason||' )');
433: fnd_file.put_line(fnd_file.output,'Asset Number : '||err_log_tbl(record_number).asset_number);
434: fnd_file.put_line(fnd_file.output,'Quote Number : '||err_log_tbl(record_number).quote_number);
435: fnd_file.put_line(fnd_file.output,'Messages ');
436: count_msg := 1;

Line 433: fnd_file.put_line(fnd_file.output,'Asset Number : '||err_log_tbl(record_number).asset_number);

429: IF(l_quote_reason IS NOT NULL) THEN
430: fnd_file.put(fnd_file.output,l_quote_reason);
431: END IF;
432: fnd_file.put_line(fnd_file.output,'( '||err_log_tbl(record_number).quote_reason||' )');
433: fnd_file.put_line(fnd_file.output,'Asset Number : '||err_log_tbl(record_number).asset_number);
434: fnd_file.put_line(fnd_file.output,'Quote Number : '||err_log_tbl(record_number).quote_number);
435: fnd_file.put_line(fnd_file.output,'Messages ');
436: count_msg := 1;
437:

Line 434: fnd_file.put_line(fnd_file.output,'Quote Number : '||err_log_tbl(record_number).quote_number);

430: fnd_file.put(fnd_file.output,l_quote_reason);
431: END IF;
432: fnd_file.put_line(fnd_file.output,'( '||err_log_tbl(record_number).quote_reason||' )');
433: fnd_file.put_line(fnd_file.output,'Asset Number : '||err_log_tbl(record_number).asset_number);
434: fnd_file.put_line(fnd_file.output,'Quote Number : '||err_log_tbl(record_number).quote_number);
435: fnd_file.put_line(fnd_file.output,'Messages ');
436: count_msg := 1;
437:
438: -- modified for BUG#3062867

Line 435: fnd_file.put_line(fnd_file.output,'Messages ');

431: END IF;
432: fnd_file.put_line(fnd_file.output,'( '||err_log_tbl(record_number).quote_reason||' )');
433: fnd_file.put_line(fnd_file.output,'Asset Number : '||err_log_tbl(record_number).asset_number);
434: fnd_file.put_line(fnd_file.output,'Quote Number : '||err_log_tbl(record_number).quote_number);
435: fnd_file.put_line(fnd_file.output,'Messages ');
436: count_msg := 1;
437:
438: -- modified for BUG#3062867
439: IF(err_msg_tbl.COUNT>0) THEN

Line 443: fnd_file.put_line(fnd_file.output,count_msg||': '||err_msg_tbl(i).msg_text);

439: IF(err_msg_tbl.COUNT>0) THEN
440: FOR i IN err_msg_tbl.FIRST..err_msg_tbl.LAST
441: LOOP
442: IF(err_msg_tbl(i).transaction_number = err_log_tbl(record_number).transaction_number) THEN
443: fnd_file.put_line(fnd_file.output,count_msg||': '||err_msg_tbl(i).msg_text);
444: count_msg := count_msg+1;
445: END IF;
446: END LOOP;
447: END IF;

Line 449: fnd_file.new_line(fnd_file.output);

445: END IF;
446: END LOOP;
447: END IF;
448:
449: fnd_file.new_line(fnd_file.output);
450: END LOOP;
451: END IF; -- err_log_tbl COUNT > 0
452: count_msg := 1;
453: IF(msg_tbl.COUNT>0) THEN

Line 456: fnd_file.put_line(fnd_file.output,count_msg ||': '||msg_tbl(i).msg_text);

452: count_msg := 1;
453: IF(msg_tbl.COUNT>0) THEN
454: FOR i IN msg_tbl.FIRST..msg_tbl.LAST
455: LOOP
456: fnd_file.put_line(fnd_file.output,count_msg ||': '||msg_tbl(i).msg_text);
457: count_msg := count_msg+1;
458: END LOOP;
459: END IF;
460: fnd_file.put_line(fnd_file.output,'=======================================');

Line 460: fnd_file.put_line(fnd_file.output,'=======================================');

456: fnd_file.put_line(fnd_file.output,count_msg ||': '||msg_tbl(i).msg_text);
457: count_msg := count_msg+1;
458: END LOOP;
459: END IF;
460: fnd_file.put_line(fnd_file.output,'=======================================');
461: END IF;
462: EXCEPTION
463: WHEN OTHERS THEN
464: -- store SQL error message on message stack for caller