203:
204: when others then
205:
206: if g_debug = 1 then
207: fnd_file.put_line(fnd_file.log, SQLCODE);
208: fnd_file.put_line(fnd_file.log,SQLERRM);
209: end if ;
210: --dbms_output.put_line(SQLCODE);
211: --dbms_output.put_line(SQLERRM);
204: when others then
205:
206: if g_debug = 1 then
207: fnd_file.put_line(fnd_file.log, SQLCODE);
208: fnd_file.put_line(fnd_file.log,SQLERRM);
209: end if ;
210: --dbms_output.put_line(SQLCODE);
211: --dbms_output.put_line(SQLERRM);
212: x_errnum := -1 ;
487:
488: when others then
489:
490: if g_debug = 1 then
491: fnd_file.put_line(fnd_file.log, SQLCODE);
492: fnd_file.put_line(fnd_file.log,SQLERRM);
493: end if ;
494: x_errnum := -1 ;
495: x_errmesg := substr(SQLERRM,1,150);
488: when others then
489:
490: if g_debug = 1 then
491: fnd_file.put_line(fnd_file.log, SQLCODE);
492: fnd_file.put_line(fnd_file.log,SQLERRM);
493: end if ;
494: x_errnum := -1 ;
495: x_errmesg := substr(SQLERRM,1,150);
496: commit ;