DBA Data[Home] [Help]

APPS.IGS_PS_WF_EVENT_PKG dependencies on FND_MESSAGE

Line 354: fnd_message.set_name('IGS','IGS_PS_NO_EMP_CAT_SETUP');

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;

Line 355: fnd_file.put_line(fnd_file.log,fnd_message.get);

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;

Line 402: errbuf := fnd_message.get_string('IGS','IGS_GE_UNHANDLED_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:
406: PROCEDURE generate_faculty_list(itemtype in varchar2,

Line 559: fnd_message.set_name('IGS', 'IGS_PS_NO_SETUP_FAC_EXCEED');

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||''||l_c_person_name ||''||fnd_message.get||'';
561: ELSE
562: l_c_document := l_c_document||''||l_c_person_name||''|| l_n_exp_wl ||''|| l_n_tot_fac_wl ||'';
563: END IF;

Line 560: l_c_document := l_c_document||''||l_c_person_name ||''||fnd_message.get||'';

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||''||l_c_person_name||''|| l_n_exp_wl ||''|| l_n_tot_fac_wl ||'';
563: END IF;
564: l_n_cntr := l_n_cntr + 1;

Line 621: fnd_message.set_name('IGS','IGS_GE_NO_DATA_FOUND');

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 := ''||fnd_message.get||'';
623: END IF;
624:
625: l_c_document := l_c_document||'';

Line 622: l_c_document := ''||fnd_message.get||'';

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);