423:
424: exception
425: when others then
426: hr_utility.set_location( 'except ' || substr(sqlerrm,1,100), 99 ) ;
427: fnd_file.put_line(fnd_file.log,
428: 'Error in Advanced Conditions while processing this dynamic sql statement: ');
429: fnd_file.put_line(fnd_file.log, l_dynamic_condition);
430: IF dbms_sql.is_open(l_cursor_name) THEN
431: dbms_sql.close_cursor(l_cursor_name);
425: when others then
426: hr_utility.set_location( 'except ' || substr(sqlerrm,1,100), 99 ) ;
427: fnd_file.put_line(fnd_file.log,
428: 'Error in Advanced Conditions while processing this dynamic sql statement: ');
429: fnd_file.put_line(fnd_file.log, l_dynamic_condition);
430: IF dbms_sql.is_open(l_cursor_name) THEN
431: dbms_sql.close_cursor(l_cursor_name);
432: end if ;
433:
747: dbms_sql.close_cursor(l_cursor_name);
748: exception
749: when others then
750: -- this needs replaced with a message for translation.
751: fnd_file.put_line(fnd_file.log,
752: 'Error in Advanced Conditions while processing this dynamic sql statement: ');
753: fnd_file.put_line(fnd_file.log, l_dynamic_condition);
754: If dbms_sql.is_open(l_cursor_name) THEN
755: dbms_sql.close_cursor(l_cursor_name);
749: when others then
750: -- this needs replaced with a message for translation.
751: fnd_file.put_line(fnd_file.log,
752: 'Error in Advanced Conditions while processing this dynamic sql statement: ');
753: fnd_file.put_line(fnd_file.log, l_dynamic_condition);
754: If dbms_sql.is_open(l_cursor_name) THEN
755: dbms_sql.close_cursor(l_cursor_name);
756: end if ;
757: raise; -- such that the error processing in ben_ext_thread occurs.