[Home] [Help]
140: CURSOR csr_db_logs IS
141: SELECT logtime,
142: caller,
143: message
144: FROM cz_db_logs
145: WHERE run_id = p_run_id
146: ORDER BY logtime;
147:
148: CURSOR csr_xfr_run_results IS
182: ELSIF p_model_type = 'R' THEN
183: l_model := 'Rules';
184: END IF;
185:
186: -- Check the cz_db_logs table for any messages and write to log file
187: fnd_file.put_line(FND_FILE.LOG,' ');
188: fnd_file.put_line(FND_FILE.LOG,'Import Summary for '||l_model||' Run Id : '||p_run_id);
189: fnd_file.put_line(FND_FILE.LOG,' ');
190:
201: G_MODULE||l_api_name,
202: '110: Run Id : '||p_run_id);
203: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
204: G_MODULE||l_api_name,
205: '110:---------- CZ_DB_LOGS ----------------------------- ');
206: fnd_file.put_line(FND_FILE.LOG,'---------- CZ_DB_LOGS ----------------------------- ');
207:
208: FOR csr_db_logs_rec IN csr_db_logs
209: LOOP
202: '110: Run Id : '||p_run_id);
203: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
204: G_MODULE||l_api_name,
205: '110:---------- CZ_DB_LOGS ----------------------------- ');
206: fnd_file.put_line(FND_FILE.LOG,'---------- CZ_DB_LOGS ----------------------------- ');
207:
208: FOR csr_db_logs_rec IN csr_db_logs
209: LOOP
210: l_rec_number := l_rec_number +1;