APPS.IGS_PS_CATALOG_ROLLOVER dependencies on FND_FILE

Line 108: fnd_file.put_line(fnd_file.LOG,fnd_message.get);

104: FETCH cur_sel_catalog_vers INTO cur_sel_ctlg_vers;
105: IF cur_sel_catalog_vers%NOTFOUND THEN
106:
107: fnd_message.set_name('IGS','IGS_PS_NO_CAT_VER');
108: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
109: app_exception.raise_exception;
110: ELSE
111:
112: DECLARE

Line 130: fnd_file.put_line(fnd_file.LOG, fnd_message.get ||': '||lv_new_catalog_version_id||' '||

126: END IF;
127:
128: IF p_debug_flag = 'Y' THEN
129: fnd_message.set_name('IGS','IGS_PS_NEW_CTLG_VERSION');
130: fnd_file.put_line(fnd_file.LOG, fnd_message.get ||': '||lv_new_catalog_version_id||' '||
131: p_new_catalog_version ||' '||cur_sel_ctlg_vers.description||' '||
132: cur_sel_ctlg_vers.closed_ind||' '||cur_sel_ctlg_vers.catalog_schedule||' '||
133: cur_sel_old_ctlg_notes.note_text);
134: END IF;

Line 175: fnd_file.put_line(fnd_file.LOG,fnd_message.get || ': '||lv_catalog_note_id||' '||lv_new_catalog_version_id

171: END;
172:
173: IF p_debug_flag = 'Y' THEN
174: fnd_message.set_name('IGS','IGS_PS_NEW_CTLG_NOTES');
175: fnd_file.put_line(fnd_file.LOG,fnd_message.get || ': '||lv_catalog_note_id||' '||lv_new_catalog_version_id
176: ||' '||cur_sel_old_ctlg_notes.note_type_id||' '||cur_sel_old_ctlg_notes.create_date||' '||
177: cur_sel_old_ctlg_notes.end_date||' '||cur_sel_old_ctlg_notes.SEQUENCE||' '||
178: cur_sel_old_ctlg_notes.note_text);
179: END IF;

Line 197: fnd_file.put_line(fnd_file.LOG, fnd_message.get || ': '||cur_sel_new_ctlg_notes.catalog_note_id||' '||

193: x_mode => 'R');
194:
195: IF p_debug_flag = 'Y' THEN
196: fnd_message.set_name('IGS','IGS_PS_UPD_CTLG_NOTES');
197: fnd_file.put_line(fnd_file.LOG, fnd_message.get || ': '||cur_sel_new_ctlg_notes.catalog_note_id||' '||
198: cur_sel_new_ctlg_notes.catalog_version_id||' '||cur_sel_new_ctlg_notes.note_type_id||' '||
199: cur_sel_new_ctlg_notes.create_date||' '|| cur_sel_new_ctlg_notes.end_date||' '||
200: cur_sel_new_ctlg_notes.SEQUENCE||' '|| cur_sel_new_ctlg_notes.note_text);
201: END IF;