APPS.IGS_UC_PURGE_INT_DATA dependencies on FND_MESSAGE

Line 39: fnd_message.set_name('IGS','IGS_UC_BOTH_CANT_BE_NO');

35: --Checking if both the parameters p_del_obsolete_data and p_del_proc_data are 'NO'
36: --If both are 'NO' then logging a message "Both parameters cannot be NO"
37: IF p_del_obsolete_data = 'N' AND p_del_proc_data = 'N' THEN
38:
39: fnd_message.set_name('IGS','IGS_UC_BOTH_CANT_BE_NO');
40: fnd_file.put_line(fnd_file.log, fnd_message.get);
41: retcode := 2;
42: RETURN;
43:

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

36: --If both are 'NO' then logging a message "Both parameters cannot be NO"
37: IF p_del_obsolete_data = 'N' AND p_del_proc_data = 'N' THEN
38:
39: fnd_message.set_name('IGS','IGS_UC_BOTH_CANT_BE_NO');
40: fnd_file.put_line(fnd_file.log, fnd_message.get);
41: retcode := 2;
42: RETURN;
43:
44: END IF;

Line 109: fnd_message.set_name(''IGS'',''IGS_UC_DEL_OBSOL_INT_DATA'');

105: l_statement := 'DECLARE
106: BEGIN
107: DELETE FROM ' || InterfaceTables(j) || l_where || ' ; ' || '
108: IF SQL%ROWCOUNT > 0 THEN
109: fnd_message.set_name(''IGS'',''IGS_UC_DEL_OBSOL_INT_DATA'');
110: fnd_message.set_token(''TNAME'',''' || InterfaceTables(j) || ''');
111: fnd_file.put_line(fnd_file.log, fnd_message.get);
112: END IF;
113: EXCEPTION

Line 110: fnd_message.set_token(''TNAME'',''' || InterfaceTables(j) || ''');

106: BEGIN
107: DELETE FROM ' || InterfaceTables(j) || l_where || ' ; ' || '
108: IF SQL%ROWCOUNT > 0 THEN
109: fnd_message.set_name(''IGS'',''IGS_UC_DEL_OBSOL_INT_DATA'');
110: fnd_message.set_token(''TNAME'',''' || InterfaceTables(j) || ''');
111: fnd_file.put_line(fnd_file.log, fnd_message.get);
112: END IF;
113: EXCEPTION
114: WHEN OTHERS THEN

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

107: DELETE FROM ' || InterfaceTables(j) || l_where || ' ; ' || '
108: IF SQL%ROWCOUNT > 0 THEN
109: fnd_message.set_name(''IGS'',''IGS_UC_DEL_OBSOL_INT_DATA'');
110: fnd_message.set_token(''TNAME'',''' || InterfaceTables(j) || ''');
111: fnd_file.put_line(fnd_file.log, fnd_message.get);
112: END IF;
113: EXCEPTION
114: WHEN OTHERS THEN
115: ROLLBACK;

Line 125: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

121: END LOOP;
122:
123: EXCEPTION
124: WHEN OTHERS THEN
125: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
126: fnd_message.set_token('NAME','IGS_UC_PURGE_INT_DATA.purge_data');
127: fnd_file.put_line(fnd_file.log, fnd_message.get);
128: errbuf := fnd_message.get ;
129: retcode := 2;

Line 126: fnd_message.set_token('NAME','IGS_UC_PURGE_INT_DATA.purge_data');

122:
123: EXCEPTION
124: WHEN OTHERS THEN
125: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
126: fnd_message.set_token('NAME','IGS_UC_PURGE_INT_DATA.purge_data');
127: fnd_file.put_line(fnd_file.log, fnd_message.get);
128: errbuf := fnd_message.get ;
129: retcode := 2;
130:

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

123: EXCEPTION
124: WHEN OTHERS THEN
125: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
126: fnd_message.set_token('NAME','IGS_UC_PURGE_INT_DATA.purge_data');
127: fnd_file.put_line(fnd_file.log, fnd_message.get);
128: errbuf := fnd_message.get ;
129: retcode := 2;
130:
131: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;

Line 128: errbuf := fnd_message.get ;

124: WHEN OTHERS THEN
125: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
126: fnd_message.set_token('NAME','IGS_UC_PURGE_INT_DATA.purge_data');
127: fnd_file.put_line(fnd_file.log, fnd_message.get);
128: errbuf := fnd_message.get ;
129: retcode := 2;
130:
131: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
132: