[Home] [Help]
165: -- END IF;
166: END LOOP;
167: END IF;
168: IF l_clob IS NOT NULL THEN
169: pay_core_files.write_to_magtape_lob(c2b(l_clob));
170: END IF;
171: hr_utility.trace('x====write_report==========================================x');
172: EXCEPTION
173: WHEN others THEN
1710:
1711: l_clob := l_clob||l_string;
1712: IF l_clob IS NOT NULL THEN
1713: l_blob := c2b(l_clob);
1714: pay_core_files.write_to_magtape_lob(l_blob);
1715: END IF;
1716: hr_utility.trace('X====gen_header_xml========================================X');
1717: EXCEPTION
1718: WHEN others THEN
1724: l_buf VARCHAR2(32767);
1725: BEGIN
1726: hr_utility.trace('+====gen_footer_xml========================================+');
1727: l_buf := l_buf || ''||EOL ;
1728: pay_core_files.write_to_magtape_lob(l_buf);
1729: hr_utility.trace('X====gen_footer_xml========================================X');
1730: EXCEPTION
1731: WHEN others THEN
1732: hr_utility.trace('Exception in gen_footer_xml SQL-ERRM : '||SQLERRM);