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 210: fnd_file.put_line(fnd_file.log,'====================================');

206: val_count := val_log_tbl.COUNT;
207: err_count := err_log_tbl.COUNT;
208: pro_count := tot_count-(val_count+err_count);
209: -- loop through the message and write to CM log
210: fnd_file.put_line(fnd_file.log,'====================================');
211: fnd_file.put_line(fnd_file.log,'Termination Interface - LOG MESSAGES');
212: fnd_file.put_line(fnd_file.log,'====================================');
213: fnd_file.put_line(fnd_file.log,'Operating Unit :'||l_org_name);
214: fnd_file.put_line(fnd_file.log,'Run Date :'||SYSDATE);

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

207: err_count := err_log_tbl.COUNT;
208: pro_count := tot_count-(val_count+err_count);
209: -- loop through the message and write to CM log
210: fnd_file.put_line(fnd_file.log,'====================================');
211: fnd_file.put_line(fnd_file.log,'Termination Interface - LOG MESSAGES');
212: fnd_file.put_line(fnd_file.log,'====================================');
213: fnd_file.put_line(fnd_file.log,'Operating Unit :'||l_org_name);
214: fnd_file.put_line(fnd_file.log,'Run Date :'||SYSDATE);
215: fnd_file.new_line(fnd_file.log);

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

208: pro_count := tot_count-(val_count+err_count);
209: -- loop through the message and write to CM log
210: fnd_file.put_line(fnd_file.log,'====================================');
211: fnd_file.put_line(fnd_file.log,'Termination Interface - LOG MESSAGES');
212: fnd_file.put_line(fnd_file.log,'====================================');
213: fnd_file.put_line(fnd_file.log,'Operating Unit :'||l_org_name);
214: fnd_file.put_line(fnd_file.log,'Run Date :'||SYSDATE);
215: fnd_file.new_line(fnd_file.log);
216: fnd_file.put_line(fnd_file.log,'-----------------------');

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

209: -- loop through the message and write to CM log
210: fnd_file.put_line(fnd_file.log,'====================================');
211: fnd_file.put_line(fnd_file.log,'Termination Interface - LOG MESSAGES');
212: fnd_file.put_line(fnd_file.log,'====================================');
213: fnd_file.put_line(fnd_file.log,'Operating Unit :'||l_org_name);
214: fnd_file.put_line(fnd_file.log,'Run Date :'||SYSDATE);
215: fnd_file.new_line(fnd_file.log);
216: fnd_file.put_line(fnd_file.log,'-----------------------');
217: fnd_file.put_line(fnd_file.log,'SUMMARY OF TRANSACTIONS');

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

210: fnd_file.put_line(fnd_file.log,'====================================');
211: fnd_file.put_line(fnd_file.log,'Termination Interface - LOG MESSAGES');
212: fnd_file.put_line(fnd_file.log,'====================================');
213: fnd_file.put_line(fnd_file.log,'Operating Unit :'||l_org_name);
214: fnd_file.put_line(fnd_file.log,'Run Date :'||SYSDATE);
215: fnd_file.new_line(fnd_file.log);
216: fnd_file.put_line(fnd_file.log,'-----------------------');
217: fnd_file.put_line(fnd_file.log,'SUMMARY OF TRANSACTIONS');
218: fnd_file.put_line(fnd_file.log,'-----------------------');

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

211: fnd_file.put_line(fnd_file.log,'Termination Interface - LOG MESSAGES');
212: fnd_file.put_line(fnd_file.log,'====================================');
213: fnd_file.put_line(fnd_file.log,'Operating Unit :'||l_org_name);
214: fnd_file.put_line(fnd_file.log,'Run Date :'||SYSDATE);
215: fnd_file.new_line(fnd_file.log);
216: fnd_file.put_line(fnd_file.log,'-----------------------');
217: fnd_file.put_line(fnd_file.log,'SUMMARY OF TRANSACTIONS');
218: fnd_file.put_line(fnd_file.log,'-----------------------');
219: fnd_file.new_line(fnd_file.log);

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

212: fnd_file.put_line(fnd_file.log,'====================================');
213: fnd_file.put_line(fnd_file.log,'Operating Unit :'||l_org_name);
214: fnd_file.put_line(fnd_file.log,'Run Date :'||SYSDATE);
215: fnd_file.new_line(fnd_file.log);
216: fnd_file.put_line(fnd_file.log,'-----------------------');
217: fnd_file.put_line(fnd_file.log,'SUMMARY OF TRANSACTIONS');
218: fnd_file.put_line(fnd_file.log,'-----------------------');
219: fnd_file.new_line(fnd_file.log);
220: fnd_file.put_line(fnd_file.log,'Processed Successfully : '||pro_count);

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

213: fnd_file.put_line(fnd_file.log,'Operating Unit :'||l_org_name);
214: fnd_file.put_line(fnd_file.log,'Run Date :'||SYSDATE);
215: fnd_file.new_line(fnd_file.log);
216: fnd_file.put_line(fnd_file.log,'-----------------------');
217: fnd_file.put_line(fnd_file.log,'SUMMARY OF TRANSACTIONS');
218: fnd_file.put_line(fnd_file.log,'-----------------------');
219: fnd_file.new_line(fnd_file.log);
220: fnd_file.put_line(fnd_file.log,'Processed Successfully : '||pro_count);
221: fnd_file.put_line(fnd_file.log,'Not Processed Due To Errors : '||val_count);

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

214: fnd_file.put_line(fnd_file.log,'Run Date :'||SYSDATE);
215: fnd_file.new_line(fnd_file.log);
216: fnd_file.put_line(fnd_file.log,'-----------------------');
217: fnd_file.put_line(fnd_file.log,'SUMMARY OF TRANSACTIONS');
218: fnd_file.put_line(fnd_file.log,'-----------------------');
219: fnd_file.new_line(fnd_file.log);
220: fnd_file.put_line(fnd_file.log,'Processed Successfully : '||pro_count);
221: fnd_file.put_line(fnd_file.log,'Not Processed Due To Errors : '||val_count);
222: fnd_file.put_line(fnd_file.log,'Processed with Errors : '||err_count);

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

215: fnd_file.new_line(fnd_file.log);
216: fnd_file.put_line(fnd_file.log,'-----------------------');
217: fnd_file.put_line(fnd_file.log,'SUMMARY OF TRANSACTIONS');
218: fnd_file.put_line(fnd_file.log,'-----------------------');
219: fnd_file.new_line(fnd_file.log);
220: fnd_file.put_line(fnd_file.log,'Processed Successfully : '||pro_count);
221: fnd_file.put_line(fnd_file.log,'Not Processed Due To Errors : '||val_count);
222: fnd_file.put_line(fnd_file.log,'Processed with Errors : '||err_count);
223: fnd_file.new_line(fnd_file.log);

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

216: fnd_file.put_line(fnd_file.log,'-----------------------');
217: fnd_file.put_line(fnd_file.log,'SUMMARY OF TRANSACTIONS');
218: fnd_file.put_line(fnd_file.log,'-----------------------');
219: fnd_file.new_line(fnd_file.log);
220: fnd_file.put_line(fnd_file.log,'Processed Successfully : '||pro_count);
221: fnd_file.put_line(fnd_file.log,'Not Processed Due To Errors : '||val_count);
222: fnd_file.put_line(fnd_file.log,'Processed with Errors : '||err_count);
223: fnd_file.new_line(fnd_file.log);
224: fnd_file.put_line(fnd_file.log,'Total Records : '||tot_count);

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

217: fnd_file.put_line(fnd_file.log,'SUMMARY OF TRANSACTIONS');
218: fnd_file.put_line(fnd_file.log,'-----------------------');
219: fnd_file.new_line(fnd_file.log);
220: fnd_file.put_line(fnd_file.log,'Processed Successfully : '||pro_count);
221: fnd_file.put_line(fnd_file.log,'Not Processed Due To Errors : '||val_count);
222: fnd_file.put_line(fnd_file.log,'Processed with Errors : '||err_count);
223: fnd_file.new_line(fnd_file.log);
224: fnd_file.put_line(fnd_file.log,'Total Records : '||tot_count);
225: fnd_file.new_line(fnd_file.log);

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

218: fnd_file.put_line(fnd_file.log,'-----------------------');
219: fnd_file.new_line(fnd_file.log);
220: fnd_file.put_line(fnd_file.log,'Processed Successfully : '||pro_count);
221: fnd_file.put_line(fnd_file.log,'Not Processed Due To Errors : '||val_count);
222: fnd_file.put_line(fnd_file.log,'Processed with Errors : '||err_count);
223: fnd_file.new_line(fnd_file.log);
224: fnd_file.put_line(fnd_file.log,'Total Records : '||tot_count);
225: fnd_file.new_line(fnd_file.log);
226: IF (val_log_tbl.COUNT > 0) THEN

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

219: fnd_file.new_line(fnd_file.log);
220: fnd_file.put_line(fnd_file.log,'Processed Successfully : '||pro_count);
221: fnd_file.put_line(fnd_file.log,'Not Processed Due To Errors : '||val_count);
222: fnd_file.put_line(fnd_file.log,'Processed with Errors : '||err_count);
223: fnd_file.new_line(fnd_file.log);
224: fnd_file.put_line(fnd_file.log,'Total Records : '||tot_count);
225: fnd_file.new_line(fnd_file.log);
226: IF (val_log_tbl.COUNT > 0) THEN
227: fnd_file.put_line(fnd_file.log,'----------------------------------------');

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

220: fnd_file.put_line(fnd_file.log,'Processed Successfully : '||pro_count);
221: fnd_file.put_line(fnd_file.log,'Not Processed Due To Errors : '||val_count);
222: fnd_file.put_line(fnd_file.log,'Processed with Errors : '||err_count);
223: fnd_file.new_line(fnd_file.log);
224: fnd_file.put_line(fnd_file.log,'Total Records : '||tot_count);
225: fnd_file.new_line(fnd_file.log);
226: IF (val_log_tbl.COUNT > 0) THEN
227: fnd_file.put_line(fnd_file.log,'----------------------------------------');
228: fnd_file.put_line(fnd_file.log,'TRANSACTIONS NOT PROCESSED DUE TO ERRORS');

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

221: fnd_file.put_line(fnd_file.log,'Not Processed Due To Errors : '||val_count);
222: fnd_file.put_line(fnd_file.log,'Processed with Errors : '||err_count);
223: fnd_file.new_line(fnd_file.log);
224: fnd_file.put_line(fnd_file.log,'Total Records : '||tot_count);
225: fnd_file.new_line(fnd_file.log);
226: IF (val_log_tbl.COUNT > 0) THEN
227: fnd_file.put_line(fnd_file.log,'----------------------------------------');
228: fnd_file.put_line(fnd_file.log,'TRANSACTIONS NOT PROCESSED DUE TO ERRORS');
229: fnd_file.put_line(fnd_file.log,'----------------------------------------');

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

223: fnd_file.new_line(fnd_file.log);
224: fnd_file.put_line(fnd_file.log,'Total Records : '||tot_count);
225: fnd_file.new_line(fnd_file.log);
226: IF (val_log_tbl.COUNT > 0) THEN
227: fnd_file.put_line(fnd_file.log,'----------------------------------------');
228: fnd_file.put_line(fnd_file.log,'TRANSACTIONS NOT PROCESSED DUE TO ERRORS');
229: fnd_file.put_line(fnd_file.log,'----------------------------------------');
230: FOR record_number in val_log_tbl.FIRST..val_log_tbl.LAST LOOP
231: fnd_file.new_line(fnd_file.log);

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

224: fnd_file.put_line(fnd_file.log,'Total Records : '||tot_count);
225: fnd_file.new_line(fnd_file.log);
226: IF (val_log_tbl.COUNT > 0) THEN
227: fnd_file.put_line(fnd_file.log,'----------------------------------------');
228: fnd_file.put_line(fnd_file.log,'TRANSACTIONS NOT PROCESSED DUE TO ERRORS');
229: fnd_file.put_line(fnd_file.log,'----------------------------------------');
230: FOR record_number in val_log_tbl.FIRST..val_log_tbl.LAST LOOP
231: fnd_file.new_line(fnd_file.log);
232: fnd_file.put_line(fnd_file.log,'Transaction Number : '||val_log_tbl(record_number).transaction_number);

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

225: fnd_file.new_line(fnd_file.log);
226: IF (val_log_tbl.COUNT > 0) THEN
227: fnd_file.put_line(fnd_file.log,'----------------------------------------');
228: fnd_file.put_line(fnd_file.log,'TRANSACTIONS NOT PROCESSED DUE TO ERRORS');
229: fnd_file.put_line(fnd_file.log,'----------------------------------------');
230: FOR record_number in val_log_tbl.FIRST..val_log_tbl.LAST LOOP
231: fnd_file.new_line(fnd_file.log);
232: fnd_file.put_line(fnd_file.log,'Transaction Number : '||val_log_tbl(record_number).transaction_number);
233: fnd_file.put_line(fnd_file.log,'Contract Number : '||val_log_tbl(record_number).contract_number);

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

227: fnd_file.put_line(fnd_file.log,'----------------------------------------');
228: fnd_file.put_line(fnd_file.log,'TRANSACTIONS NOT PROCESSED DUE TO ERRORS');
229: fnd_file.put_line(fnd_file.log,'----------------------------------------');
230: FOR record_number in val_log_tbl.FIRST..val_log_tbl.LAST LOOP
231: fnd_file.new_line(fnd_file.log);
232: fnd_file.put_line(fnd_file.log,'Transaction Number : '||val_log_tbl(record_number).transaction_number);
233: fnd_file.put_line(fnd_file.log,'Contract Number : '||val_log_tbl(record_number).contract_number);
234: fnd_file.put_line(fnd_file.log,'Quote Effective From Date : '||val_log_tbl(record_number).date_effective_from);
235: -- to find the meaning of quote_type_code

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

228: fnd_file.put_line(fnd_file.log,'TRANSACTIONS NOT PROCESSED DUE TO ERRORS');
229: fnd_file.put_line(fnd_file.log,'----------------------------------------');
230: FOR record_number in val_log_tbl.FIRST..val_log_tbl.LAST LOOP
231: fnd_file.new_line(fnd_file.log);
232: fnd_file.put_line(fnd_file.log,'Transaction Number : '||val_log_tbl(record_number).transaction_number);
233: fnd_file.put_line(fnd_file.log,'Contract Number : '||val_log_tbl(record_number).contract_number);
234: fnd_file.put_line(fnd_file.log,'Quote Effective From Date : '||val_log_tbl(record_number).date_effective_from);
235: -- to find the meaning of quote_type_code
236: l_quote_type := NULL;

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

229: fnd_file.put_line(fnd_file.log,'----------------------------------------');
230: FOR record_number in val_log_tbl.FIRST..val_log_tbl.LAST LOOP
231: fnd_file.new_line(fnd_file.log);
232: fnd_file.put_line(fnd_file.log,'Transaction Number : '||val_log_tbl(record_number).transaction_number);
233: fnd_file.put_line(fnd_file.log,'Contract Number : '||val_log_tbl(record_number).contract_number);
234: fnd_file.put_line(fnd_file.log,'Quote Effective From Date : '||val_log_tbl(record_number).date_effective_from);
235: -- to find the meaning of quote_type_code
236: l_quote_type := NULL;
237: FOR get_type IN get_quote_type_meaning_csr(p_quote_type => val_log_tbl(record_number).quote_type)

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

230: FOR record_number in val_log_tbl.FIRST..val_log_tbl.LAST LOOP
231: fnd_file.new_line(fnd_file.log);
232: fnd_file.put_line(fnd_file.log,'Transaction Number : '||val_log_tbl(record_number).transaction_number);
233: fnd_file.put_line(fnd_file.log,'Contract Number : '||val_log_tbl(record_number).contract_number);
234: fnd_file.put_line(fnd_file.log,'Quote Effective From Date : '||val_log_tbl(record_number).date_effective_from);
235: -- to find the meaning of quote_type_code
236: l_quote_type := NULL;
237: FOR get_type IN get_quote_type_meaning_csr(p_quote_type => val_log_tbl(record_number).quote_type)
238: LOOP

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

237: FOR get_type IN get_quote_type_meaning_csr(p_quote_type => val_log_tbl(record_number).quote_type)
238: LOOP
239: l_quote_type := get_type.meaning;
240: END LOOP;
241: fnd_file.put(fnd_file.log,'Quote Type : ');
242: IF(l_quote_type IS NOT NULL) THEN
243: fnd_file.put(fnd_file.log,l_quote_type);
244: END IF;
245: fnd_file.put_line(fnd_file.log,'( '||val_log_tbl(record_number).quote_type||' )');

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

239: l_quote_type := get_type.meaning;
240: END LOOP;
241: fnd_file.put(fnd_file.log,'Quote Type : ');
242: IF(l_quote_type IS NOT NULL) THEN
243: fnd_file.put(fnd_file.log,l_quote_type);
244: END IF;
245: fnd_file.put_line(fnd_file.log,'( '||val_log_tbl(record_number).quote_type||' )');
246: -- to find the meaning of quote_reason_code
247: l_quote_reason := NULL;

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

241: fnd_file.put(fnd_file.log,'Quote Type : ');
242: IF(l_quote_type IS NOT NULL) THEN
243: fnd_file.put(fnd_file.log,l_quote_type);
244: END IF;
245: fnd_file.put_line(fnd_file.log,'( '||val_log_tbl(record_number).quote_type||' )');
246: -- to find the meaning of quote_reason_code
247: l_quote_reason := NULL;
248: FOR get_reason IN get_quote_reason_meaning_csr(p_quote_reason => val_log_tbl(record_number).quote_reason)
249: LOOP

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

248: FOR get_reason IN get_quote_reason_meaning_csr(p_quote_reason => val_log_tbl(record_number).quote_reason)
249: LOOP
250: l_quote_reason := get_reason.meaning;
251: END LOOP;
252: fnd_file.put(fnd_file.log,'Quote Reason : ');
253: IF(l_quote_reason IS NOT NULL) THEN
254: fnd_file.put(fnd_file.log,l_quote_reason);
255: END IF;
256: fnd_file.put_line(fnd_file.log,'( '||val_log_tbl(record_number).quote_reason||' )');

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

250: l_quote_reason := get_reason.meaning;
251: END LOOP;
252: fnd_file.put(fnd_file.log,'Quote Reason : ');
253: IF(l_quote_reason IS NOT NULL) THEN
254: fnd_file.put(fnd_file.log,l_quote_reason);
255: END IF;
256: fnd_file.put_line(fnd_file.log,'( '||val_log_tbl(record_number).quote_reason||' )');
257: fnd_file.put_line(fnd_file.log,'Asset Number : '||val_log_tbl(record_number).asset_number);
258: fnd_file.put_line(fnd_file.log,'Messages ');

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

252: fnd_file.put(fnd_file.log,'Quote Reason : ');
253: IF(l_quote_reason IS NOT NULL) THEN
254: fnd_file.put(fnd_file.log,l_quote_reason);
255: END IF;
256: fnd_file.put_line(fnd_file.log,'( '||val_log_tbl(record_number).quote_reason||' )');
257: fnd_file.put_line(fnd_file.log,'Asset Number : '||val_log_tbl(record_number).asset_number);
258: fnd_file.put_line(fnd_file.log,'Messages ');
259: count_msg := 1;
260: -- modified for BUG#3062867

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

253: IF(l_quote_reason IS NOT NULL) THEN
254: fnd_file.put(fnd_file.log,l_quote_reason);
255: END IF;
256: fnd_file.put_line(fnd_file.log,'( '||val_log_tbl(record_number).quote_reason||' )');
257: fnd_file.put_line(fnd_file.log,'Asset Number : '||val_log_tbl(record_number).asset_number);
258: fnd_file.put_line(fnd_file.log,'Messages ');
259: count_msg := 1;
260: -- modified for BUG#3062867
261: IF(val_msg_tbl.COUNT>0) THEN

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

254: fnd_file.put(fnd_file.log,l_quote_reason);
255: END IF;
256: fnd_file.put_line(fnd_file.log,'( '||val_log_tbl(record_number).quote_reason||' )');
257: fnd_file.put_line(fnd_file.log,'Asset Number : '||val_log_tbl(record_number).asset_number);
258: fnd_file.put_line(fnd_file.log,'Messages ');
259: count_msg := 1;
260: -- modified for BUG#3062867
261: IF(val_msg_tbl.COUNT>0) THEN
262: FOR i IN val_msg_tbl.FIRST..val_msg_tbl.LAST

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

261: IF(val_msg_tbl.COUNT>0) THEN
262: FOR i IN val_msg_tbl.FIRST..val_msg_tbl.LAST
263: LOOP
264: IF(val_msg_tbl(i).transaction_number = val_log_tbl(record_number).transaction_number) THEN
265: fnd_file.put_line(fnd_file.log,count_msg||': '||val_msg_tbl(i).msg_text);
266: count_msg := count_msg+1;
267: END IF;
268: END LOOP;
269: END IF;

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

267: END IF;
268: END LOOP;
269: END IF;
270:
271: fnd_file.new_line(fnd_file.log);
272: END LOOP;
273: END IF; -- val_log_tbl COUNT > 0
274: IF (err_log_tbl.COUNT > 0) THEN
275: fnd_file.put_line(fnd_file.log,'----------------------------------');

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

271: fnd_file.new_line(fnd_file.log);
272: END LOOP;
273: END IF; -- val_log_tbl COUNT > 0
274: IF (err_log_tbl.COUNT > 0) THEN
275: fnd_file.put_line(fnd_file.log,'----------------------------------');
276: fnd_file.put_line(fnd_file.log,'TRANSACTIONS PROCESSED WITH ERRORS');
277: fnd_file.put_line(fnd_file.log,'----------------------------------');
278: FOR record_number in err_log_tbl.FIRST..err_log_tbl.LAST LOOP
279: fnd_file.new_line(fnd_file.log);

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

272: END LOOP;
273: END IF; -- val_log_tbl COUNT > 0
274: IF (err_log_tbl.COUNT > 0) THEN
275: fnd_file.put_line(fnd_file.log,'----------------------------------');
276: fnd_file.put_line(fnd_file.log,'TRANSACTIONS PROCESSED WITH ERRORS');
277: fnd_file.put_line(fnd_file.log,'----------------------------------');
278: FOR record_number in err_log_tbl.FIRST..err_log_tbl.LAST LOOP
279: fnd_file.new_line(fnd_file.log);
280: fnd_file.put_line(fnd_file.log,'Transaction Number : '||err_log_tbl(record_number).transaction_number);

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

273: END IF; -- val_log_tbl COUNT > 0
274: IF (err_log_tbl.COUNT > 0) THEN
275: fnd_file.put_line(fnd_file.log,'----------------------------------');
276: fnd_file.put_line(fnd_file.log,'TRANSACTIONS PROCESSED WITH ERRORS');
277: fnd_file.put_line(fnd_file.log,'----------------------------------');
278: FOR record_number in err_log_tbl.FIRST..err_log_tbl.LAST LOOP
279: fnd_file.new_line(fnd_file.log);
280: fnd_file.put_line(fnd_file.log,'Transaction Number : '||err_log_tbl(record_number).transaction_number);
281: fnd_file.put_line(fnd_file.log,'Contract Number : '||err_log_tbl(record_number).contract_number);

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

275: fnd_file.put_line(fnd_file.log,'----------------------------------');
276: fnd_file.put_line(fnd_file.log,'TRANSACTIONS PROCESSED WITH ERRORS');
277: fnd_file.put_line(fnd_file.log,'----------------------------------');
278: FOR record_number in err_log_tbl.FIRST..err_log_tbl.LAST LOOP
279: fnd_file.new_line(fnd_file.log);
280: fnd_file.put_line(fnd_file.log,'Transaction Number : '||err_log_tbl(record_number).transaction_number);
281: fnd_file.put_line(fnd_file.log,'Contract Number : '||err_log_tbl(record_number).contract_number);
282: fnd_file.put_line(fnd_file.log,'Quote Effective From Date : '||err_log_tbl(record_number).date_effective_from);
283: -- to find the meaning of quote_type_code

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

276: fnd_file.put_line(fnd_file.log,'TRANSACTIONS PROCESSED WITH ERRORS');
277: fnd_file.put_line(fnd_file.log,'----------------------------------');
278: FOR record_number in err_log_tbl.FIRST..err_log_tbl.LAST LOOP
279: fnd_file.new_line(fnd_file.log);
280: fnd_file.put_line(fnd_file.log,'Transaction Number : '||err_log_tbl(record_number).transaction_number);
281: fnd_file.put_line(fnd_file.log,'Contract Number : '||err_log_tbl(record_number).contract_number);
282: fnd_file.put_line(fnd_file.log,'Quote Effective From Date : '||err_log_tbl(record_number).date_effective_from);
283: -- to find the meaning of quote_type_code
284: l_quote_type := NULL;

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

277: fnd_file.put_line(fnd_file.log,'----------------------------------');
278: FOR record_number in err_log_tbl.FIRST..err_log_tbl.LAST LOOP
279: fnd_file.new_line(fnd_file.log);
280: fnd_file.put_line(fnd_file.log,'Transaction Number : '||err_log_tbl(record_number).transaction_number);
281: fnd_file.put_line(fnd_file.log,'Contract Number : '||err_log_tbl(record_number).contract_number);
282: fnd_file.put_line(fnd_file.log,'Quote Effective From Date : '||err_log_tbl(record_number).date_effective_from);
283: -- to find the meaning of quote_type_code
284: l_quote_type := NULL;
285: FOR get_type IN get_quote_type_meaning_csr(p_quote_type => err_log_tbl(record_number).quote_type)

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

278: FOR record_number in err_log_tbl.FIRST..err_log_tbl.LAST LOOP
279: fnd_file.new_line(fnd_file.log);
280: fnd_file.put_line(fnd_file.log,'Transaction Number : '||err_log_tbl(record_number).transaction_number);
281: fnd_file.put_line(fnd_file.log,'Contract Number : '||err_log_tbl(record_number).contract_number);
282: fnd_file.put_line(fnd_file.log,'Quote Effective From Date : '||err_log_tbl(record_number).date_effective_from);
283: -- to find the meaning of quote_type_code
284: l_quote_type := NULL;
285: FOR get_type IN get_quote_type_meaning_csr(p_quote_type => err_log_tbl(record_number).quote_type)
286: LOOP

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

285: FOR get_type IN get_quote_type_meaning_csr(p_quote_type => err_log_tbl(record_number).quote_type)
286: LOOP
287: l_quote_type := get_type.meaning;
288: END LOOP;
289: fnd_file.put(fnd_file.log,'Quote Type : ');
290: IF(l_quote_type IS NOT NULL) THEN
291: fnd_file.put(fnd_file.log,l_quote_type);
292: END IF;
293: fnd_file.put_line(fnd_file.log,'( '||err_log_tbl(record_number).quote_type||' )');

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

287: l_quote_type := get_type.meaning;
288: END LOOP;
289: fnd_file.put(fnd_file.log,'Quote Type : ');
290: IF(l_quote_type IS NOT NULL) THEN
291: fnd_file.put(fnd_file.log,l_quote_type);
292: END IF;
293: fnd_file.put_line(fnd_file.log,'( '||err_log_tbl(record_number).quote_type||' )');
294: -- to find the meaning of quote_reason_code
295: l_quote_reason := NULL;

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

289: fnd_file.put(fnd_file.log,'Quote Type : ');
290: IF(l_quote_type IS NOT NULL) THEN
291: fnd_file.put(fnd_file.log,l_quote_type);
292: END IF;
293: fnd_file.put_line(fnd_file.log,'( '||err_log_tbl(record_number).quote_type||' )');
294: -- to find the meaning of quote_reason_code
295: l_quote_reason := NULL;
296: FOR get_reason IN get_quote_reason_meaning_csr(p_quote_reason => err_log_tbl(record_number).quote_reason)
297: LOOP

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

296: FOR get_reason IN get_quote_reason_meaning_csr(p_quote_reason => err_log_tbl(record_number).quote_reason)
297: LOOP
298: l_quote_reason := get_reason.meaning;
299: END LOOP;
300: fnd_file.put(fnd_file.log,'Quote Reason : ');
301: IF(l_quote_reason IS NOT NULL) THEN
302: fnd_file.put(fnd_file.log,l_quote_reason);
303: END IF;
304: fnd_file.put_line(fnd_file.log,'( '||err_log_tbl(record_number).quote_reason||' )');

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

298: l_quote_reason := get_reason.meaning;
299: END LOOP;
300: fnd_file.put(fnd_file.log,'Quote Reason : ');
301: IF(l_quote_reason IS NOT NULL) THEN
302: fnd_file.put(fnd_file.log,l_quote_reason);
303: END IF;
304: fnd_file.put_line(fnd_file.log,'( '||err_log_tbl(record_number).quote_reason||' )');
305: fnd_file.put_line(fnd_file.log,'Asset Number : '||err_log_tbl(record_number).asset_number);
306: fnd_file.put_line(fnd_file.log,'Quote Number : '||err_log_tbl(record_number).quote_number);

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

300: fnd_file.put(fnd_file.log,'Quote Reason : ');
301: IF(l_quote_reason IS NOT NULL) THEN
302: fnd_file.put(fnd_file.log,l_quote_reason);
303: END IF;
304: fnd_file.put_line(fnd_file.log,'( '||err_log_tbl(record_number).quote_reason||' )');
305: fnd_file.put_line(fnd_file.log,'Asset Number : '||err_log_tbl(record_number).asset_number);
306: fnd_file.put_line(fnd_file.log,'Quote Number : '||err_log_tbl(record_number).quote_number);
307: fnd_file.put_line(fnd_file.log,'Messages ');
308: count_msg := 1;

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

301: IF(l_quote_reason IS NOT NULL) THEN
302: fnd_file.put(fnd_file.log,l_quote_reason);
303: END IF;
304: fnd_file.put_line(fnd_file.log,'( '||err_log_tbl(record_number).quote_reason||' )');
305: fnd_file.put_line(fnd_file.log,'Asset Number : '||err_log_tbl(record_number).asset_number);
306: fnd_file.put_line(fnd_file.log,'Quote Number : '||err_log_tbl(record_number).quote_number);
307: fnd_file.put_line(fnd_file.log,'Messages ');
308: count_msg := 1;
309:

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

302: fnd_file.put(fnd_file.log,l_quote_reason);
303: END IF;
304: fnd_file.put_line(fnd_file.log,'( '||err_log_tbl(record_number).quote_reason||' )');
305: fnd_file.put_line(fnd_file.log,'Asset Number : '||err_log_tbl(record_number).asset_number);
306: fnd_file.put_line(fnd_file.log,'Quote Number : '||err_log_tbl(record_number).quote_number);
307: fnd_file.put_line(fnd_file.log,'Messages ');
308: count_msg := 1;
309:
310: -- modified for BUG#3062867

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

303: END IF;
304: fnd_file.put_line(fnd_file.log,'( '||err_log_tbl(record_number).quote_reason||' )');
305: fnd_file.put_line(fnd_file.log,'Asset Number : '||err_log_tbl(record_number).asset_number);
306: fnd_file.put_line(fnd_file.log,'Quote Number : '||err_log_tbl(record_number).quote_number);
307: fnd_file.put_line(fnd_file.log,'Messages ');
308: count_msg := 1;
309:
310: -- modified for BUG#3062867
311: IF(err_msg_tbl.COUNT>0) THEN

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

311: IF(err_msg_tbl.COUNT>0) THEN
312: FOR i IN err_msg_tbl.FIRST..err_msg_tbl.LAST
313: LOOP
314: IF(err_msg_tbl(i).transaction_number = err_log_tbl(record_number).transaction_number) THEN
315: fnd_file.put_line(fnd_file.log,count_msg||': '||err_msg_tbl(i).msg_text);
316: count_msg := count_msg+1;
317: END IF;
318: END LOOP;
319: END IF;

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

317: END IF;
318: END LOOP;
319: END IF;
320:
321: fnd_file.new_line(fnd_file.log);
322: END LOOP;
323: END IF; -- err_log_tbl COUNT > 0
324: count_msg := 1;
325: -- statement came along with flag 'Y'

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

325: -- statement came along with flag 'Y'
326: IF(msg_tbl.COUNT>0) THEN
327: FOR i IN msg_tbl.FIRST..msg_tbl.LAST
328: LOOP
329: fnd_file.put_line(fnd_file.log,count_msg ||': '||msg_tbl(i).msg_text);
330: count_msg := count_msg+1;
331: END LOOP;
332: END IF;
333: fnd_file.put_line(fnd_file.log,'=======================================');

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

329: fnd_file.put_line(fnd_file.log,count_msg ||': '||msg_tbl(i).msg_text);
330: count_msg := count_msg+1;
331: END LOOP;
332: END IF;
333: fnd_file.put_line(fnd_file.log,'=======================================');
334: END IF;
335: -- enter the messages in to OUTPUT
336: IF(log_msg_flag = 'O') THEN
337: tot_count := p_quote_number;

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

342: FOR org_rec IN org_csr (l_org_id) LOOP
343: l_org_name := org_rec.name;
344: END LOOP;
345: -- loop through the message and write to CM log
346: fnd_file.put_line(fnd_file.output,'=======================================');
347: fnd_file.put_line(fnd_file.output,'Termination Interface - OUTPUT MESSAGES');
348: fnd_file.put_line(fnd_file.output,'=======================================');
349: fnd_file.put_line(fnd_file.output,'Operating Unit :'||l_org_name);
350: fnd_file.put_line(fnd_file.output,'Run Date :'||SYSDATE);

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

343: l_org_name := org_rec.name;
344: END LOOP;
345: -- loop through the message and write to CM log
346: fnd_file.put_line(fnd_file.output,'=======================================');
347: fnd_file.put_line(fnd_file.output,'Termination Interface - OUTPUT MESSAGES');
348: fnd_file.put_line(fnd_file.output,'=======================================');
349: fnd_file.put_line(fnd_file.output,'Operating Unit :'||l_org_name);
350: fnd_file.put_line(fnd_file.output,'Run Date :'||SYSDATE);
351: fnd_file.new_line(fnd_file.output);

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

344: END LOOP;
345: -- loop through the message and write to CM log
346: fnd_file.put_line(fnd_file.output,'=======================================');
347: fnd_file.put_line(fnd_file.output,'Termination Interface - OUTPUT MESSAGES');
348: fnd_file.put_line(fnd_file.output,'=======================================');
349: fnd_file.put_line(fnd_file.output,'Operating Unit :'||l_org_name);
350: fnd_file.put_line(fnd_file.output,'Run Date :'||SYSDATE);
351: fnd_file.new_line(fnd_file.output);
352: fnd_file.put_line(fnd_file.output,'-----------------------');

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

345: -- loop through the message and write to CM log
346: fnd_file.put_line(fnd_file.output,'=======================================');
347: fnd_file.put_line(fnd_file.output,'Termination Interface - OUTPUT MESSAGES');
348: fnd_file.put_line(fnd_file.output,'=======================================');
349: fnd_file.put_line(fnd_file.output,'Operating Unit :'||l_org_name);
350: fnd_file.put_line(fnd_file.output,'Run Date :'||SYSDATE);
351: fnd_file.new_line(fnd_file.output);
352: fnd_file.put_line(fnd_file.output,'-----------------------');
353: fnd_file.put_line(fnd_file.output,'SUMMARY OF TRANSACTIONS');

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

346: fnd_file.put_line(fnd_file.output,'=======================================');
347: fnd_file.put_line(fnd_file.output,'Termination Interface - OUTPUT MESSAGES');
348: fnd_file.put_line(fnd_file.output,'=======================================');
349: fnd_file.put_line(fnd_file.output,'Operating Unit :'||l_org_name);
350: fnd_file.put_line(fnd_file.output,'Run Date :'||SYSDATE);
351: fnd_file.new_line(fnd_file.output);
352: fnd_file.put_line(fnd_file.output,'-----------------------');
353: fnd_file.put_line(fnd_file.output,'SUMMARY OF TRANSACTIONS');
354: fnd_file.put_line(fnd_file.output,'-----------------------');

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

347: fnd_file.put_line(fnd_file.output,'Termination Interface - OUTPUT MESSAGES');
348: fnd_file.put_line(fnd_file.output,'=======================================');
349: fnd_file.put_line(fnd_file.output,'Operating Unit :'||l_org_name);
350: fnd_file.put_line(fnd_file.output,'Run Date :'||SYSDATE);
351: fnd_file.new_line(fnd_file.output);
352: fnd_file.put_line(fnd_file.output,'-----------------------');
353: fnd_file.put_line(fnd_file.output,'SUMMARY OF TRANSACTIONS');
354: fnd_file.put_line(fnd_file.output,'-----------------------');
355: fnd_file.new_line(fnd_file.output);

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

348: fnd_file.put_line(fnd_file.output,'=======================================');
349: fnd_file.put_line(fnd_file.output,'Operating Unit :'||l_org_name);
350: fnd_file.put_line(fnd_file.output,'Run Date :'||SYSDATE);
351: fnd_file.new_line(fnd_file.output);
352: fnd_file.put_line(fnd_file.output,'-----------------------');
353: fnd_file.put_line(fnd_file.output,'SUMMARY OF TRANSACTIONS');
354: fnd_file.put_line(fnd_file.output,'-----------------------');
355: fnd_file.new_line(fnd_file.output);
356: fnd_file.put_line(fnd_file.output,'Processed Successfully : '||pro_count);

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

349: fnd_file.put_line(fnd_file.output,'Operating Unit :'||l_org_name);
350: fnd_file.put_line(fnd_file.output,'Run Date :'||SYSDATE);
351: fnd_file.new_line(fnd_file.output);
352: fnd_file.put_line(fnd_file.output,'-----------------------');
353: fnd_file.put_line(fnd_file.output,'SUMMARY OF TRANSACTIONS');
354: fnd_file.put_line(fnd_file.output,'-----------------------');
355: fnd_file.new_line(fnd_file.output);
356: fnd_file.put_line(fnd_file.output,'Processed Successfully : '||pro_count);
357: fnd_file.put_line(fnd_file.output,'Not Processed Due To Errors : '||val_count);

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

350: fnd_file.put_line(fnd_file.output,'Run Date :'||SYSDATE);
351: fnd_file.new_line(fnd_file.output);
352: fnd_file.put_line(fnd_file.output,'-----------------------');
353: fnd_file.put_line(fnd_file.output,'SUMMARY OF TRANSACTIONS');
354: fnd_file.put_line(fnd_file.output,'-----------------------');
355: fnd_file.new_line(fnd_file.output);
356: fnd_file.put_line(fnd_file.output,'Processed Successfully : '||pro_count);
357: fnd_file.put_line(fnd_file.output,'Not Processed Due To Errors : '||val_count);
358: fnd_file.put_line(fnd_file.output,'Processed with Errors : '||err_count);

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

351: fnd_file.new_line(fnd_file.output);
352: fnd_file.put_line(fnd_file.output,'-----------------------');
353: fnd_file.put_line(fnd_file.output,'SUMMARY OF TRANSACTIONS');
354: fnd_file.put_line(fnd_file.output,'-----------------------');
355: fnd_file.new_line(fnd_file.output);
356: fnd_file.put_line(fnd_file.output,'Processed Successfully : '||pro_count);
357: fnd_file.put_line(fnd_file.output,'Not Processed Due To Errors : '||val_count);
358: fnd_file.put_line(fnd_file.output,'Processed with Errors : '||err_count);
359: fnd_file.new_line(fnd_file.output);

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

352: fnd_file.put_line(fnd_file.output,'-----------------------');
353: fnd_file.put_line(fnd_file.output,'SUMMARY OF TRANSACTIONS');
354: fnd_file.put_line(fnd_file.output,'-----------------------');
355: fnd_file.new_line(fnd_file.output);
356: fnd_file.put_line(fnd_file.output,'Processed Successfully : '||pro_count);
357: fnd_file.put_line(fnd_file.output,'Not Processed Due To Errors : '||val_count);
358: fnd_file.put_line(fnd_file.output,'Processed with Errors : '||err_count);
359: fnd_file.new_line(fnd_file.output);
360: --pro_count := pro_log_tbl.COUNT+val_log_tbl.COUNT+err_log_tbl.COUNT;

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

353: fnd_file.put_line(fnd_file.output,'SUMMARY OF TRANSACTIONS');
354: fnd_file.put_line(fnd_file.output,'-----------------------');
355: fnd_file.new_line(fnd_file.output);
356: fnd_file.put_line(fnd_file.output,'Processed Successfully : '||pro_count);
357: fnd_file.put_line(fnd_file.output,'Not Processed Due To Errors : '||val_count);
358: fnd_file.put_line(fnd_file.output,'Processed with Errors : '||err_count);
359: fnd_file.new_line(fnd_file.output);
360: --pro_count := pro_log_tbl.COUNT+val_log_tbl.COUNT+err_log_tbl.COUNT;
361: fnd_file.put_line(fnd_file.output,'Total Records : '||tot_count);

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

354: fnd_file.put_line(fnd_file.output,'-----------------------');
355: fnd_file.new_line(fnd_file.output);
356: fnd_file.put_line(fnd_file.output,'Processed Successfully : '||pro_count);
357: fnd_file.put_line(fnd_file.output,'Not Processed Due To Errors : '||val_count);
358: fnd_file.put_line(fnd_file.output,'Processed with Errors : '||err_count);
359: fnd_file.new_line(fnd_file.output);
360: --pro_count := pro_log_tbl.COUNT+val_log_tbl.COUNT+err_log_tbl.COUNT;
361: fnd_file.put_line(fnd_file.output,'Total Records : '||tot_count);
362: fnd_file.new_line(fnd_file.output);

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

355: fnd_file.new_line(fnd_file.output);
356: fnd_file.put_line(fnd_file.output,'Processed Successfully : '||pro_count);
357: fnd_file.put_line(fnd_file.output,'Not Processed Due To Errors : '||val_count);
358: fnd_file.put_line(fnd_file.output,'Processed with Errors : '||err_count);
359: fnd_file.new_line(fnd_file.output);
360: --pro_count := pro_log_tbl.COUNT+val_log_tbl.COUNT+err_log_tbl.COUNT;
361: fnd_file.put_line(fnd_file.output,'Total Records : '||tot_count);
362: fnd_file.new_line(fnd_file.output);
363: IF (val_log_tbl.COUNT > 0) THEN

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

357: fnd_file.put_line(fnd_file.output,'Not Processed Due To Errors : '||val_count);
358: fnd_file.put_line(fnd_file.output,'Processed with Errors : '||err_count);
359: fnd_file.new_line(fnd_file.output);
360: --pro_count := pro_log_tbl.COUNT+val_log_tbl.COUNT+err_log_tbl.COUNT;
361: fnd_file.put_line(fnd_file.output,'Total Records : '||tot_count);
362: fnd_file.new_line(fnd_file.output);
363: IF (val_log_tbl.COUNT > 0) THEN
364: fnd_file.put_line(fnd_file.output,'----------------------------------------');
365: fnd_file.put_line(fnd_file.output,'TRANSACTIONS NOT PROCESSED DUE TO ERRORS');

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

358: fnd_file.put_line(fnd_file.output,'Processed with Errors : '||err_count);
359: fnd_file.new_line(fnd_file.output);
360: --pro_count := pro_log_tbl.COUNT+val_log_tbl.COUNT+err_log_tbl.COUNT;
361: fnd_file.put_line(fnd_file.output,'Total Records : '||tot_count);
362: fnd_file.new_line(fnd_file.output);
363: IF (val_log_tbl.COUNT > 0) THEN
364: fnd_file.put_line(fnd_file.output,'----------------------------------------');
365: fnd_file.put_line(fnd_file.output,'TRANSACTIONS NOT PROCESSED DUE TO ERRORS');
366: fnd_file.put_line(fnd_file.output,'----------------------------------------');

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

360: --pro_count := pro_log_tbl.COUNT+val_log_tbl.COUNT+err_log_tbl.COUNT;
361: fnd_file.put_line(fnd_file.output,'Total Records : '||tot_count);
362: fnd_file.new_line(fnd_file.output);
363: IF (val_log_tbl.COUNT > 0) THEN
364: fnd_file.put_line(fnd_file.output,'----------------------------------------');
365: fnd_file.put_line(fnd_file.output,'TRANSACTIONS NOT PROCESSED DUE TO ERRORS');
366: fnd_file.put_line(fnd_file.output,'----------------------------------------');
367: FOR record_number in val_log_tbl.FIRST..val_log_tbl.LAST LOOP
368: fnd_file.new_line(fnd_file.output);

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

361: fnd_file.put_line(fnd_file.output,'Total Records : '||tot_count);
362: fnd_file.new_line(fnd_file.output);
363: IF (val_log_tbl.COUNT > 0) THEN
364: fnd_file.put_line(fnd_file.output,'----------------------------------------');
365: fnd_file.put_line(fnd_file.output,'TRANSACTIONS NOT PROCESSED DUE TO ERRORS');
366: fnd_file.put_line(fnd_file.output,'----------------------------------------');
367: FOR record_number in val_log_tbl.FIRST..val_log_tbl.LAST LOOP
368: fnd_file.new_line(fnd_file.output);
369: fnd_file.put_line(fnd_file.output,'Transaction Number : '||val_log_tbl(record_number).transaction_number);

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

362: fnd_file.new_line(fnd_file.output);
363: IF (val_log_tbl.COUNT > 0) THEN
364: fnd_file.put_line(fnd_file.output,'----------------------------------------');
365: fnd_file.put_line(fnd_file.output,'TRANSACTIONS NOT PROCESSED DUE TO ERRORS');
366: fnd_file.put_line(fnd_file.output,'----------------------------------------');
367: FOR record_number in val_log_tbl.FIRST..val_log_tbl.LAST LOOP
368: fnd_file.new_line(fnd_file.output);
369: fnd_file.put_line(fnd_file.output,'Transaction Number : '||val_log_tbl(record_number).transaction_number);
370: fnd_file.put_line(fnd_file.output,'Contract Number : '||val_log_tbl(record_number).contract_number);

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

364: fnd_file.put_line(fnd_file.output,'----------------------------------------');
365: fnd_file.put_line(fnd_file.output,'TRANSACTIONS NOT PROCESSED DUE TO ERRORS');
366: fnd_file.put_line(fnd_file.output,'----------------------------------------');
367: FOR record_number in val_log_tbl.FIRST..val_log_tbl.LAST LOOP
368: fnd_file.new_line(fnd_file.output);
369: fnd_file.put_line(fnd_file.output,'Transaction Number : '||val_log_tbl(record_number).transaction_number);
370: fnd_file.put_line(fnd_file.output,'Contract Number : '||val_log_tbl(record_number).contract_number);
371: fnd_file.put_line(fnd_file.output,'Quote Effective From Date : '||val_log_tbl(record_number).date_effective_from);
372:

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

365: fnd_file.put_line(fnd_file.output,'TRANSACTIONS NOT PROCESSED DUE TO ERRORS');
366: fnd_file.put_line(fnd_file.output,'----------------------------------------');
367: FOR record_number in val_log_tbl.FIRST..val_log_tbl.LAST LOOP
368: fnd_file.new_line(fnd_file.output);
369: fnd_file.put_line(fnd_file.output,'Transaction Number : '||val_log_tbl(record_number).transaction_number);
370: fnd_file.put_line(fnd_file.output,'Contract Number : '||val_log_tbl(record_number).contract_number);
371: fnd_file.put_line(fnd_file.output,'Quote Effective From Date : '||val_log_tbl(record_number).date_effective_from);
372:
373: -- to find the meaning of quote_type_code

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

366: fnd_file.put_line(fnd_file.output,'----------------------------------------');
367: FOR record_number in val_log_tbl.FIRST..val_log_tbl.LAST LOOP
368: fnd_file.new_line(fnd_file.output);
369: fnd_file.put_line(fnd_file.output,'Transaction Number : '||val_log_tbl(record_number).transaction_number);
370: fnd_file.put_line(fnd_file.output,'Contract Number : '||val_log_tbl(record_number).contract_number);
371: fnd_file.put_line(fnd_file.output,'Quote Effective From Date : '||val_log_tbl(record_number).date_effective_from);
372:
373: -- to find the meaning of quote_type_code
374: l_quote_type := NULL;

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

367: FOR record_number in val_log_tbl.FIRST..val_log_tbl.LAST LOOP
368: fnd_file.new_line(fnd_file.output);
369: fnd_file.put_line(fnd_file.output,'Transaction Number : '||val_log_tbl(record_number).transaction_number);
370: fnd_file.put_line(fnd_file.output,'Contract Number : '||val_log_tbl(record_number).contract_number);
371: fnd_file.put_line(fnd_file.output,'Quote Effective From Date : '||val_log_tbl(record_number).date_effective_from);
372:
373: -- to find the meaning of quote_type_code
374: l_quote_type := NULL;
375: FOR get_type IN get_quote_type_meaning_csr(p_quote_type => val_log_tbl(record_number).quote_type)

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

375: FOR get_type IN get_quote_type_meaning_csr(p_quote_type => val_log_tbl(record_number).quote_type)
376: LOOP
377: l_quote_type := get_type.meaning;
378: END LOOP;
379: fnd_file.put(fnd_file.output,'Quote Type : ');
380: IF(l_quote_type IS NOT NULL) THEN
381: fnd_file.put(fnd_file.output,l_quote_type);
382: END IF;
383: fnd_file.put_line(fnd_file.output,'( '||val_log_tbl(record_number).quote_type||' )');

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

377: l_quote_type := get_type.meaning;
378: END LOOP;
379: fnd_file.put(fnd_file.output,'Quote Type : ');
380: IF(l_quote_type IS NOT NULL) THEN
381: fnd_file.put(fnd_file.output,l_quote_type);
382: END IF;
383: fnd_file.put_line(fnd_file.output,'( '||val_log_tbl(record_number).quote_type||' )');
384: -- to find the meaning of quote_reason_code
385: l_quote_reason := NULL;

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

379: fnd_file.put(fnd_file.output,'Quote Type : ');
380: IF(l_quote_type IS NOT NULL) THEN
381: fnd_file.put(fnd_file.output,l_quote_type);
382: END IF;
383: fnd_file.put_line(fnd_file.output,'( '||val_log_tbl(record_number).quote_type||' )');
384: -- to find the meaning of quote_reason_code
385: l_quote_reason := NULL;
386: FOR get_reason IN get_quote_reason_meaning_csr(p_quote_reason => val_log_tbl(record_number).quote_reason)
387: LOOP

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

386: FOR get_reason IN get_quote_reason_meaning_csr(p_quote_reason => val_log_tbl(record_number).quote_reason)
387: LOOP
388: l_quote_reason := get_reason.meaning;
389: END LOOP;
390: fnd_file.put(fnd_file.output,'Quote Reason : ');
391: IF(l_quote_reason IS NOT NULL) THEN
392: fnd_file.put(fnd_file.output,l_quote_reason);
393: END IF;
394: fnd_file.put_line(fnd_file.output,'( '||val_log_tbl(record_number).quote_reason||' )');

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

388: l_quote_reason := get_reason.meaning;
389: END LOOP;
390: fnd_file.put(fnd_file.output,'Quote Reason : ');
391: IF(l_quote_reason IS NOT NULL) THEN
392: fnd_file.put(fnd_file.output,l_quote_reason);
393: END IF;
394: fnd_file.put_line(fnd_file.output,'( '||val_log_tbl(record_number).quote_reason||' )');
395: fnd_file.put_line(fnd_file.output,'Asset Number : '||val_log_tbl(record_number).asset_number);
396: fnd_file.put_line(fnd_file.output,'Messages ');

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

390: fnd_file.put(fnd_file.output,'Quote Reason : ');
391: IF(l_quote_reason IS NOT NULL) THEN
392: fnd_file.put(fnd_file.output,l_quote_reason);
393: END IF;
394: fnd_file.put_line(fnd_file.output,'( '||val_log_tbl(record_number).quote_reason||' )');
395: fnd_file.put_line(fnd_file.output,'Asset Number : '||val_log_tbl(record_number).asset_number);
396: fnd_file.put_line(fnd_file.output,'Messages ');
397: count_msg := 1;
398:

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

391: IF(l_quote_reason IS NOT NULL) THEN
392: fnd_file.put(fnd_file.output,l_quote_reason);
393: END IF;
394: fnd_file.put_line(fnd_file.output,'( '||val_log_tbl(record_number).quote_reason||' )');
395: fnd_file.put_line(fnd_file.output,'Asset Number : '||val_log_tbl(record_number).asset_number);
396: fnd_file.put_line(fnd_file.output,'Messages ');
397: count_msg := 1;
398:
399: -- modified for BUG#3062867

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

392: fnd_file.put(fnd_file.output,l_quote_reason);
393: END IF;
394: fnd_file.put_line(fnd_file.output,'( '||val_log_tbl(record_number).quote_reason||' )');
395: fnd_file.put_line(fnd_file.output,'Asset Number : '||val_log_tbl(record_number).asset_number);
396: fnd_file.put_line(fnd_file.output,'Messages ');
397: count_msg := 1;
398:
399: -- modified for BUG#3062867
400: IF(val_msg_tbl.COUNT>0) THEN

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

400: IF(val_msg_tbl.COUNT>0) THEN
401: FOR i IN val_msg_tbl.FIRST..val_msg_tbl.LAST
402: LOOP
403: IF(val_msg_tbl(i).transaction_number = val_log_tbl(record_number).transaction_number) THEN
404: fnd_file.put_line(fnd_file.output,count_msg||': '||val_msg_tbl(i).msg_text);
405: count_msg := count_msg+1;
406: END IF;
407: END LOOP;
408: END IF;

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

406: END IF;
407: END LOOP;
408: END IF;
409:
410: fnd_file.new_line(fnd_file.output);
411: END LOOP;
412: END IF; -- val_msg_tbl COUNT > 0
413: IF (err_log_tbl.COUNT > 0) THEN
414: fnd_file.put_line(fnd_file.output,'----------------------------------');

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

410: fnd_file.new_line(fnd_file.output);
411: END LOOP;
412: END IF; -- val_msg_tbl COUNT > 0
413: IF (err_log_tbl.COUNT > 0) THEN
414: fnd_file.put_line(fnd_file.output,'----------------------------------');
415: fnd_file.put_line(fnd_file.output,'TRANSACTIONS PROCESSED WITH ERRORS');
416: fnd_file.put_line(fnd_file.output,'----------------------------------');
417: FOR record_number in err_log_tbl.FIRST..err_log_tbl.LAST LOOP
418: fnd_file.new_line(fnd_file.output);

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

411: END LOOP;
412: END IF; -- val_msg_tbl COUNT > 0
413: IF (err_log_tbl.COUNT > 0) THEN
414: fnd_file.put_line(fnd_file.output,'----------------------------------');
415: fnd_file.put_line(fnd_file.output,'TRANSACTIONS PROCESSED WITH ERRORS');
416: fnd_file.put_line(fnd_file.output,'----------------------------------');
417: FOR record_number in err_log_tbl.FIRST..err_log_tbl.LAST LOOP
418: fnd_file.new_line(fnd_file.output);
419: fnd_file.put_line(fnd_file.output,'Transaction Number : '||err_log_tbl(record_number).transaction_number);

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

412: END IF; -- val_msg_tbl COUNT > 0
413: IF (err_log_tbl.COUNT > 0) THEN
414: fnd_file.put_line(fnd_file.output,'----------------------------------');
415: fnd_file.put_line(fnd_file.output,'TRANSACTIONS PROCESSED WITH ERRORS');
416: fnd_file.put_line(fnd_file.output,'----------------------------------');
417: FOR record_number in err_log_tbl.FIRST..err_log_tbl.LAST LOOP
418: fnd_file.new_line(fnd_file.output);
419: fnd_file.put_line(fnd_file.output,'Transaction Number : '||err_log_tbl(record_number).transaction_number);
420: fnd_file.put_line(fnd_file.output,'Contract Number : '||err_log_tbl(record_number).contract_number);

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

414: fnd_file.put_line(fnd_file.output,'----------------------------------');
415: fnd_file.put_line(fnd_file.output,'TRANSACTIONS PROCESSED WITH ERRORS');
416: fnd_file.put_line(fnd_file.output,'----------------------------------');
417: FOR record_number in err_log_tbl.FIRST..err_log_tbl.LAST LOOP
418: fnd_file.new_line(fnd_file.output);
419: fnd_file.put_line(fnd_file.output,'Transaction Number : '||err_log_tbl(record_number).transaction_number);
420: fnd_file.put_line(fnd_file.output,'Contract Number : '||err_log_tbl(record_number).contract_number);
421: fnd_file.put_line(fnd_file.output,'Quote Effective From Date : '||err_log_tbl(record_number).date_effective_from);
422: -- to find the meaning of quote_type_code

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

415: fnd_file.put_line(fnd_file.output,'TRANSACTIONS PROCESSED WITH ERRORS');
416: fnd_file.put_line(fnd_file.output,'----------------------------------');
417: FOR record_number in err_log_tbl.FIRST..err_log_tbl.LAST LOOP
418: fnd_file.new_line(fnd_file.output);
419: fnd_file.put_line(fnd_file.output,'Transaction Number : '||err_log_tbl(record_number).transaction_number);
420: fnd_file.put_line(fnd_file.output,'Contract Number : '||err_log_tbl(record_number).contract_number);
421: fnd_file.put_line(fnd_file.output,'Quote Effective From Date : '||err_log_tbl(record_number).date_effective_from);
422: -- to find the meaning of quote_type_code
423: l_quote_type := NULL;

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

416: fnd_file.put_line(fnd_file.output,'----------------------------------');
417: FOR record_number in err_log_tbl.FIRST..err_log_tbl.LAST LOOP
418: fnd_file.new_line(fnd_file.output);
419: fnd_file.put_line(fnd_file.output,'Transaction Number : '||err_log_tbl(record_number).transaction_number);
420: fnd_file.put_line(fnd_file.output,'Contract Number : '||err_log_tbl(record_number).contract_number);
421: fnd_file.put_line(fnd_file.output,'Quote Effective From Date : '||err_log_tbl(record_number).date_effective_from);
422: -- to find the meaning of quote_type_code
423: l_quote_type := NULL;
424: FOR get_type IN get_quote_type_meaning_csr(p_quote_type => err_log_tbl(record_number).quote_type)

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

417: FOR record_number in err_log_tbl.FIRST..err_log_tbl.LAST LOOP
418: fnd_file.new_line(fnd_file.output);
419: fnd_file.put_line(fnd_file.output,'Transaction Number : '||err_log_tbl(record_number).transaction_number);
420: fnd_file.put_line(fnd_file.output,'Contract Number : '||err_log_tbl(record_number).contract_number);
421: fnd_file.put_line(fnd_file.output,'Quote Effective From Date : '||err_log_tbl(record_number).date_effective_from);
422: -- to find the meaning of quote_type_code
423: l_quote_type := NULL;
424: FOR get_type IN get_quote_type_meaning_csr(p_quote_type => err_log_tbl(record_number).quote_type)
425: LOOP

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

424: FOR get_type IN get_quote_type_meaning_csr(p_quote_type => err_log_tbl(record_number).quote_type)
425: LOOP
426: l_quote_type := get_type.meaning;
427: END LOOP;
428: fnd_file.put(fnd_file.output,'Quote Type : ');
429: IF(l_quote_type IS NOT NULL) THEN
430: fnd_file.put(fnd_file.output,l_quote_type);
431: END IF;
432: fnd_file.put_line(fnd_file.output,'( '||err_log_tbl(record_number).quote_type||' )');

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

426: l_quote_type := get_type.meaning;
427: END LOOP;
428: fnd_file.put(fnd_file.output,'Quote Type : ');
429: IF(l_quote_type IS NOT NULL) THEN
430: fnd_file.put(fnd_file.output,l_quote_type);
431: END IF;
432: fnd_file.put_line(fnd_file.output,'( '||err_log_tbl(record_number).quote_type||' )');
433: -- to find the meaning of quote_reason_code
434: l_quote_reason := NULL;

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

428: fnd_file.put(fnd_file.output,'Quote Type : ');
429: IF(l_quote_type IS NOT NULL) THEN
430: fnd_file.put(fnd_file.output,l_quote_type);
431: END IF;
432: fnd_file.put_line(fnd_file.output,'( '||err_log_tbl(record_number).quote_type||' )');
433: -- to find the meaning of quote_reason_code
434: l_quote_reason := NULL;
435: FOR get_reason IN get_quote_reason_meaning_csr(p_quote_reason => err_log_tbl(record_number).quote_reason)
436: LOOP

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

435: FOR get_reason IN get_quote_reason_meaning_csr(p_quote_reason => err_log_tbl(record_number).quote_reason)
436: LOOP
437: l_quote_reason := get_reason.meaning;
438: END LOOP;
439: fnd_file.put(fnd_file.output,'Quote Reason : ');
440: IF(l_quote_reason IS NOT NULL) THEN
441: fnd_file.put(fnd_file.output,l_quote_reason);
442: END IF;
443: fnd_file.put_line(fnd_file.output,'( '||err_log_tbl(record_number).quote_reason||' )');

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

437: l_quote_reason := get_reason.meaning;
438: END LOOP;
439: fnd_file.put(fnd_file.output,'Quote Reason : ');
440: IF(l_quote_reason IS NOT NULL) THEN
441: fnd_file.put(fnd_file.output,l_quote_reason);
442: END IF;
443: fnd_file.put_line(fnd_file.output,'( '||err_log_tbl(record_number).quote_reason||' )');
444: fnd_file.put_line(fnd_file.output,'Asset Number : '||err_log_tbl(record_number).asset_number);
445: fnd_file.put_line(fnd_file.output,'Quote Number : '||err_log_tbl(record_number).quote_number);

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

439: fnd_file.put(fnd_file.output,'Quote Reason : ');
440: IF(l_quote_reason IS NOT NULL) THEN
441: fnd_file.put(fnd_file.output,l_quote_reason);
442: END IF;
443: fnd_file.put_line(fnd_file.output,'( '||err_log_tbl(record_number).quote_reason||' )');
444: fnd_file.put_line(fnd_file.output,'Asset Number : '||err_log_tbl(record_number).asset_number);
445: fnd_file.put_line(fnd_file.output,'Quote Number : '||err_log_tbl(record_number).quote_number);
446: fnd_file.put_line(fnd_file.output,'Messages ');
447: count_msg := 1;

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

440: IF(l_quote_reason IS NOT NULL) THEN
441: fnd_file.put(fnd_file.output,l_quote_reason);
442: END IF;
443: fnd_file.put_line(fnd_file.output,'( '||err_log_tbl(record_number).quote_reason||' )');
444: fnd_file.put_line(fnd_file.output,'Asset Number : '||err_log_tbl(record_number).asset_number);
445: fnd_file.put_line(fnd_file.output,'Quote Number : '||err_log_tbl(record_number).quote_number);
446: fnd_file.put_line(fnd_file.output,'Messages ');
447: count_msg := 1;
448:

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

441: fnd_file.put(fnd_file.output,l_quote_reason);
442: END IF;
443: fnd_file.put_line(fnd_file.output,'( '||err_log_tbl(record_number).quote_reason||' )');
444: fnd_file.put_line(fnd_file.output,'Asset Number : '||err_log_tbl(record_number).asset_number);
445: fnd_file.put_line(fnd_file.output,'Quote Number : '||err_log_tbl(record_number).quote_number);
446: fnd_file.put_line(fnd_file.output,'Messages ');
447: count_msg := 1;
448:
449: -- modified for BUG#3062867

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

442: END IF;
443: fnd_file.put_line(fnd_file.output,'( '||err_log_tbl(record_number).quote_reason||' )');
444: fnd_file.put_line(fnd_file.output,'Asset Number : '||err_log_tbl(record_number).asset_number);
445: fnd_file.put_line(fnd_file.output,'Quote Number : '||err_log_tbl(record_number).quote_number);
446: fnd_file.put_line(fnd_file.output,'Messages ');
447: count_msg := 1;
448:
449: -- modified for BUG#3062867
450: IF(err_msg_tbl.COUNT>0) THEN

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

450: IF(err_msg_tbl.COUNT>0) THEN
451: FOR i IN err_msg_tbl.FIRST..err_msg_tbl.LAST
452: LOOP
453: IF(err_msg_tbl(i).transaction_number = err_log_tbl(record_number).transaction_number) THEN
454: fnd_file.put_line(fnd_file.output,count_msg||': '||err_msg_tbl(i).msg_text);
455: count_msg := count_msg+1;
456: END IF;
457: END LOOP;
458: END IF;

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

456: END IF;
457: END LOOP;
458: END IF;
459:
460: fnd_file.new_line(fnd_file.output);
461: END LOOP;
462: END IF; -- err_log_tbl COUNT > 0
463: count_msg := 1;
464: IF(msg_tbl.COUNT>0) THEN

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

463: count_msg := 1;
464: IF(msg_tbl.COUNT>0) THEN
465: FOR i IN msg_tbl.FIRST..msg_tbl.LAST
466: LOOP
467: fnd_file.put_line(fnd_file.output,count_msg ||': '||msg_tbl(i).msg_text);
468: count_msg := count_msg+1;
469: END LOOP;
470: END IF;
471: fnd_file.put_line(fnd_file.output,'=======================================');

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

467: fnd_file.put_line(fnd_file.output,count_msg ||': '||msg_tbl(i).msg_text);
468: count_msg := count_msg+1;
469: END LOOP;
470: END IF;
471: fnd_file.put_line(fnd_file.output,'=======================================');
472: END IF;
473: EXCEPTION
474: WHEN OTHERS THEN
475: -- store SQL error message on message stack for caller