56: --
57: IF l_proc_log.text <> ' : '
58: THEN
59: --
60: ben_batch_utils.WRITE (p_text => l_proc_log.text);
61: --
62: END IF;
63: --
64: l_count := l_count + 1;
119: open c_fff_rows;
120: fetch c_fff_rows into l_fff_rows;
121: if c_fff_rows%found then
122: --
123: ben_batch_utils.WRITE (p_text => ' # | Formula Name | Request ');
124: ben_batch_utils.WRITE (p_text => '-------------------------------------------------');
125: --
126: loop
127: begin
120: fetch c_fff_rows into l_fff_rows;
121: if c_fff_rows%found then
122: --
123: ben_batch_utils.WRITE (p_text => ' # | Formula Name | Request ');
124: ben_batch_utils.WRITE (p_text => '-------------------------------------------------');
125: --
126: loop
127: begin
128: --
139: ,argument1 => l_fff_rows.formula_type_name
140: ,argument2 => l_fff_rows.full_formula_name
141: );
142:
143: ben_batch_utils.WRITE (p_text => lpad(to_char(l_count),4)|| ' | '|| l_fff_rows.formula_name || ' | '|| l_request_id);
144: --
145: exception
146: when others then
147: --
144: --
145: exception
146: when others then
147: --
148: ben_batch_utils.WRITE (p_text => lpad(to_char(l_count),4)|| ' | '|| l_fff_rows.formula_name || l_request_id);
149: ben_batch_utils.WRITE (p_text => SQLERRM );
150: errbuf := SQLERRM;
151: --
152: end;
145: exception
146: when others then
147: --
148: ben_batch_utils.WRITE (p_text => lpad(to_char(l_count),4)|| ' | '|| l_fff_rows.formula_name || l_request_id);
149: ben_batch_utils.WRITE (p_text => SQLERRM );
150: errbuf := SQLERRM;
151: --
152: end;
153: --
156: --
157: end loop;
158: --
159: else
160: ben_batch_utils.WRITE (p_text => 'No Fast Formualas found for compilation.');
161: end if;
162: --
163: EXCEPTION
164: WHEN others THEN
161: end if;
162: --
163: EXCEPTION
164: WHEN others THEN
165: ben_batch_utils.WRITE (p_text => SQLERRM );
166: errbuf := SQLERRM;
167: --
168: END compile_modified_ff;
169: --
410: if l_row_typ_cd = 'ELP' then
411: raise;
412: end if;
413: --
414: ben_batch_utils.WRITE (p_text => SQLERRM);
415: --
416: BEGIN
417: --
418: SAVEPOINT update_cet;
441: THEN
442: --
443: ROLLBACK TO update_cet;
444: --
445: ben_batch_utils.WRITE (p_text => SQLERRM);
446: --
447: COMMIT;
448: --
449: END;