351: OPEN c_emp_cat_setup;
352: FETCH c_emp_cat_setup INTO l_c_emp_cat_setup;
353: IF c_emp_cat_setup%NOTFOUND THEN
354: fnd_message.set_name('IGS','IGS_PS_NO_EMP_CAT_SETUP');
355: fnd_file.put_line(fnd_file.log,fnd_message.get);
356: close c_emp_cat_setup;
357: RETURN;
358: END IF;
359: close c_emp_cat_setup;
397: EXCEPTION
398: WHEN OTHERS THEN
399: ROLLBACK;
400: retcode:=2;
401: fnd_file.put_line(fnd_file.log,sqlerrm);
402: errbuf := fnd_message.get_string('IGS','IGS_GE_UNHANDLED_EXCEPTION') ;
403: igs_ge_msg_stack.conc_exception_hndl;
404: END fac_exceed_wl_event;
405: