350:
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;
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;
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:
406: PROCEDURE generate_faculty_list(itemtype in varchar2,
555: l_n_exp_wl
556: )THEN
557:
558: IF l_n_exp_wl = 0 THEN
559: fnd_message.set_name('IGS', 'IGS_PS_NO_SETUP_FAC_EXCEED');
560: l_c_document := l_c_document||'
556: )THEN
557:
558: IF l_n_exp_wl = 0 THEN
559: fnd_message.set_name('IGS', 'IGS_PS_NO_SETUP_FAC_EXCEED');
560: l_c_document := l_c_document||' ';'||l_c_person_name ||' '||fnd_message.get||'
561: ELSE
562: l_c_document := l_c_document||'
617:
618: /* If no records exist, then print No data found message */
619:
620: IF l_n_cntr = 0 THEN
621: fnd_message.set_name('IGS','IGS_GE_NO_DATA_FOUND');
622: l_c_document := '
618: /* If no records exist, then print No data found message */
619:
620: IF l_n_cntr = 0 THEN
621: fnd_message.set_name('IGS','IGS_GE_NO_DATA_FOUND');
622: l_c_document := ' ';'||fnd_message.get||'
623: END IF;
624:
625: l_c_document := l_c_document||'';
626: WF_NOTIFICATION.WriteToClob(document, l_c_document);