DBA Data[Home] [Help]

APPS.IGS_PS_CATALOG_ROLLOVER dependencies on FND_MESSAGE

Line 107: fnd_message.set_name('IGS','IGS_PS_NO_CAT_VER');

103: OPEN cur_sel_catalog_vers(p_old_catalog_version);
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:

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 129: fnd_message.set_name('IGS','IGS_PS_NEW_CTLG_VERSION');

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

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 174: fnd_message.set_name('IGS','IGS_PS_NEW_CTLG_NOTES');

170: x_org_id => p_org_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);

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 196: fnd_message.set_name('IGS','IGS_PS_UPD_CTLG_NOTES');

192: x_note_text => cur_sel_old_ctlg_notes.note_text,
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);

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;

Line 210: ERRBUF:=FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION');

206: CLOSE cur_sel_old_catalog_notes ;
207: EXCEPTION
208: WHEN OTHERS THEN
209: RETCODE:=2;
210: ERRBUF:=FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION');
211: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
212: END catalog_rollover;
213: END Igs_Ps_Catalog_Rollover;