eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_US_W2_INFO_PKG dependencies on DBMS_LOB

Line 30: dbms_lob.createtemporary(temp_blob,false,DBMS_LOB.CALL);

26:
27: raw_data:=utl_raw.cast_to_raw(p_text);
28: text_size:=utl_raw.length(raw_data);
29:
30: dbms_lob.createtemporary(temp_blob,false,DBMS_LOB.CALL);
31: dbms_lob.open(temp_blob,dbms_lob.lob_readwrite);
32:
33: dbms_lob.writeappend(temp_blob,
34: text_size,

Line 31: dbms_lob.open(temp_blob,dbms_lob.lob_readwrite);

27: raw_data:=utl_raw.cast_to_raw(p_text);
28: text_size:=utl_raw.length(raw_data);
29:
30: dbms_lob.createtemporary(temp_blob,false,DBMS_LOB.CALL);
31: dbms_lob.open(temp_blob,dbms_lob.lob_readwrite);
32:
33: dbms_lob.writeappend(temp_blob,
34: text_size,
35: raw_data

Line 33: dbms_lob.writeappend(temp_blob,

29:
30: dbms_lob.createtemporary(temp_blob,false,DBMS_LOB.CALL);
31: dbms_lob.open(temp_blob,dbms_lob.lob_readwrite);
32:
33: dbms_lob.writeappend(temp_blob,
34: text_size,
35: raw_data
36: );
37:

Line 38: IF dbms_lob.ISOPEN(temp_blob)=1 THEN

34: text_size,
35: raw_data
36: );
37:
38: IF dbms_lob.ISOPEN(temp_blob)=1 THEN
39: hr_utility.trace('Closing temp_lob' );
40: dbms_lob.close(temp_blob);
41: END IF;
42:

Line 40: dbms_lob.close(temp_blob);

36: );
37:
38: IF dbms_lob.ISOPEN(temp_blob)=1 THEN
39: hr_utility.trace('Closing temp_lob' );
40: dbms_lob.close(temp_blob);
41: END IF;
42:
43: return temp_blob;
44: END;

Line 1266: is_temp := dbms_lob.istemporary(l_xml_blob);

1262:
1263:
1264:
1265: hr_utility.trace('one set XML string ' ||l_xml_string);
1266: is_temp := dbms_lob.istemporary(l_xml_blob);
1267: hr_utility.trace('Istemporary(l_xml_blob) ' ||is_temp );
1268:
1269: IF is_temp = 1 THEN
1270: DBMS_LOB.FREETEMPORARY(l_xml_blob);

Line 1270: DBMS_LOB.FREETEMPORARY(l_xml_blob);

1266: is_temp := dbms_lob.istemporary(l_xml_blob);
1267: hr_utility.trace('Istemporary(l_xml_blob) ' ||is_temp );
1268:
1269: IF is_temp = 1 THEN
1270: DBMS_LOB.FREETEMPORARY(l_xml_blob);
1271: END IF;
1272:
1273: dbms_lob.createtemporary(l_xml_blob,false,DBMS_LOB.CALL);
1274: dbms_lob.open(l_xml_blob,dbms_lob.lob_readwrite);

Line 1273: dbms_lob.createtemporary(l_xml_blob,false,DBMS_LOB.CALL);

1269: IF is_temp = 1 THEN
1270: DBMS_LOB.FREETEMPORARY(l_xml_blob);
1271: END IF;
1272:
1273: dbms_lob.createtemporary(l_xml_blob,false,DBMS_LOB.CALL);
1274: dbms_lob.open(l_xml_blob,dbms_lob.lob_readwrite);
1275: hr_utility.trace('OPENED l_xml_blob ' );
1276:
1277: raw_data:=utl_raw.cast_to_raw(l_xml_string);

Line 1274: dbms_lob.open(l_xml_blob,dbms_lob.lob_readwrite);

1270: DBMS_LOB.FREETEMPORARY(l_xml_blob);
1271: END IF;
1272:
1273: dbms_lob.createtemporary(l_xml_blob,false,DBMS_LOB.CALL);
1274: dbms_lob.open(l_xml_blob,dbms_lob.lob_readwrite);
1275: hr_utility.trace('OPENED l_xml_blob ' );
1276:
1277: raw_data:=utl_raw.cast_to_raw(l_xml_string);
1278: text_size:=utl_raw.length(raw_data);

Line 1280: dbms_lob.writeappend(l_xml_blob,text_size,raw_data);

1276:
1277: raw_data:=utl_raw.cast_to_raw(l_xml_string);
1278: text_size:=utl_raw.length(raw_data);
1279:
1280: dbms_lob.writeappend(l_xml_blob,text_size,raw_data);
1281:
1282: hr_utility.trace('Get Length l_xml_clob ' ||dbms_lob.getlength(l_xml_blob) );
1283: dbms_lob.close(l_xml_blob);
1284: return l_xml_blob;

Line 1282: hr_utility.trace('Get Length l_xml_clob ' ||dbms_lob.getlength(l_xml_blob) );

1278: text_size:=utl_raw.length(raw_data);
1279:
1280: dbms_lob.writeappend(l_xml_blob,text_size,raw_data);
1281:
1282: hr_utility.trace('Get Length l_xml_clob ' ||dbms_lob.getlength(l_xml_blob) );
1283: dbms_lob.close(l_xml_blob);
1284: return l_xml_blob;
1285: exception
1286: when OTHERS then

Line 1283: dbms_lob.close(l_xml_blob);

1279:
1280: dbms_lob.writeappend(l_xml_blob,text_size,raw_data);
1281:
1282: hr_utility.trace('Get Length l_xml_clob ' ||dbms_lob.getlength(l_xml_blob) );
1283: dbms_lob.close(l_xml_blob);
1284: return l_xml_blob;
1285: exception
1286: when OTHERS then
1287: dbms_lob.close(l_xml_blob);

Line 1287: dbms_lob.close(l_xml_blob);

1283: dbms_lob.close(l_xml_blob);
1284: return l_xml_blob;
1285: exception
1286: when OTHERS then
1287: dbms_lob.close(l_xml_blob);
1288: HR_UTILITY.TRACE('sqleerm ' || sqlerrm);
1289: HR_UTILITY.RAISE_ERROR;
1290:
1291: end create_xml_string;

Line 1379: l_is_temp_xml_string := dbms_lob.istemporary(l_xml_blob);

1375: l_local_count_completed := 0;
1376: l_state_local_total_count := l_state_local_tab.count;
1377: l_state_local_count_completed := 0;
1378:
1379: l_is_temp_xml_string := dbms_lob.istemporary(l_xml_blob);
1380: hr_utility.trace('Istemporary(l_xml_blob) ' ||l_is_temp_xml_string );
1381:
1382: IF l_is_temp_xml_string = 1 THEN
1383: DBMS_LOB.FREETEMPORARY(l_xml_blob);

Line 1383: DBMS_LOB.FREETEMPORARY(l_xml_blob);

1379: l_is_temp_xml_string := dbms_lob.istemporary(l_xml_blob);
1380: hr_utility.trace('Istemporary(l_xml_blob) ' ||l_is_temp_xml_string );
1381:
1382: IF l_is_temp_xml_string = 1 THEN
1383: DBMS_LOB.FREETEMPORARY(l_xml_blob);
1384: END IF;
1385:
1386: dbms_lob.createtemporary(l_xml_blob,false,DBMS_LOB.CALL);
1387: dbms_lob.open(l_xml_blob,dbms_lob.lob_readwrite);

Line 1386: dbms_lob.createtemporary(l_xml_blob,false,DBMS_LOB.CALL);

1382: IF l_is_temp_xml_string = 1 THEN
1383: DBMS_LOB.FREETEMPORARY(l_xml_blob);
1384: END IF;
1385:
1386: dbms_lob.createtemporary(l_xml_blob,false,DBMS_LOB.CALL);
1387: dbms_lob.open(l_xml_blob,dbms_lob.lob_readwrite);
1388:
1389: IF (l_b14_total_count = 0) AND
1390: (l_b12_total_count = 0) AND

Line 1387: dbms_lob.open(l_xml_blob,dbms_lob.lob_readwrite);

1383: DBMS_LOB.FREETEMPORARY(l_xml_blob);
1384: END IF;
1385:
1386: dbms_lob.createtemporary(l_xml_blob,false,DBMS_LOB.CALL);
1387: dbms_lob.open(l_xml_blob,dbms_lob.lob_readwrite);
1388:
1389: IF (l_b14_total_count = 0) AND
1390: (l_b12_total_count = 0) AND
1391: --(l_sl_total_count = 0)

Line 1395: -- dbms_lob.append(l_final_xml,p_xml_string);

1391: --(l_sl_total_count = 0)
1392: (l_state_local_total_count = 0) THEN
1393:
1394: hr_utility.trace('In l_b14_total_count and other counts =0 ' );
1395: -- dbms_lob.append(l_final_xml,p_xml_string);
1396: l_xml_blob := create_xml_string(l_w2_fields,
1397: l_box14_codea,l_box14_meaninga,
1398: l_box14_codeb,l_box14_meaningb,
1399: l_box14_codec,l_box14_meaningc,

Line 1621: dbms_lob.getlength(l_out_create_xml));

1617: l_local2_wages,l_local2_tax,
1618: l_locality2,p_year);
1619:
1620: hr_utility.trace('After l_out_create_xml, length of LOB ' ||
1621: dbms_lob.getlength(l_out_create_xml));
1622: -- IF l_xml_string is not NULL and l_out_create_xml IS NOT NULL THEN
1623:
1624: dbms_lob.append(l_xml_blob,l_out_create_xml);
1625: hr_utility.trace('Length of l_xml_blob ' ||dbms_lob.getlength(l_xml_blob));

Line 1624: dbms_lob.append(l_xml_blob,l_out_create_xml);

1620: hr_utility.trace('After l_out_create_xml, length of LOB ' ||
1621: dbms_lob.getlength(l_out_create_xml));
1622: -- IF l_xml_string is not NULL and l_out_create_xml IS NOT NULL THEN
1623:
1624: dbms_lob.append(l_xml_blob,l_out_create_xml);
1625: hr_utility.trace('Length of l_xml_blob ' ||dbms_lob.getlength(l_xml_blob));
1626:
1627: /* ELSE
1628: dbms_lob.writeappend(l_xml_string,dbms_lobamount,l_out_create_xml);;*/

Line 1625: hr_utility.trace('Length of l_xml_blob ' ||dbms_lob.getlength(l_xml_blob));

1621: dbms_lob.getlength(l_out_create_xml));
1622: -- IF l_xml_string is not NULL and l_out_create_xml IS NOT NULL THEN
1623:
1624: dbms_lob.append(l_xml_blob,l_out_create_xml);
1625: hr_utility.trace('Length of l_xml_blob ' ||dbms_lob.getlength(l_xml_blob));
1626:
1627: /* ELSE
1628: dbms_lob.writeappend(l_xml_string,dbms_lobamount,l_out_create_xml);;*/
1629: -- END IF;

Line 1628: dbms_lob.writeappend(l_xml_string,dbms_lobamount,l_out_create_xml);;*/

1624: dbms_lob.append(l_xml_blob,l_out_create_xml);
1625: hr_utility.trace('Length of l_xml_blob ' ||dbms_lob.getlength(l_xml_blob));
1626:
1627: /* ELSE
1628: dbms_lob.writeappend(l_xml_string,dbms_lobamount,l_out_create_xml);;*/
1629: -- END IF;
1630:
1631: END LOOP;
1632: END IF;

Line 1637: --hr_utility.trace(dbms_lob.substr(l_xml_string,,1));

1633: --}
1634: END IF ; /* p_error_msg is null */
1635: hr_utility.trace('XML String is ');
1636:
1637: --hr_utility.trace(dbms_lob.substr(l_xml_string,,1));
1638:
1639: return l_xml_blob;
1640: EXCEPTION
1641: WHEN OTHERS then

Line 1679: hr_utility.trace('dbms_lob.getlength(p_xml_blob) ' ||dbms_lob.getlength(p_xml_blob));

1675: p_tax_unit_id ,
1676: p_year,
1677: p_error_msg , true);
1678:
1679: hr_utility.trace('dbms_lob.getlength(p_xml_blob) ' ||dbms_lob.getlength(p_xml_blob));
1680:
1681: IF p_error_msg IS NULL THEN
1682: hr_utility.trace('In final XML p_xml_string ');
1683: /* hr_utility.trace('XML String '||

Line 1684: dbms_lob.substr(p_xml_string,dbms_lob.getlength(p_xml_string),1));

1680:
1681: IF p_error_msg IS NULL THEN
1682: hr_utility.trace('In final XML p_xml_string ');
1683: /* hr_utility.trace('XML String '||
1684: dbms_lob.substr(p_xml_string,dbms_lob.getlength(p_xml_string),1));
1685: */
1686: l_final_xml_string :=
1687: -- ''|| EOL|| Bug 6712851
1688: ''||EOL||

Line 1700: dbms_lob.substr(l_final_xml,dbms_lob.getlength(l_final_xml),1));

1696: -- ''||EOL;
1697:
1698:
1699: hr_utility.trace('1. final 1. XML l_final_xml '||
1700: dbms_lob.substr(l_final_xml,dbms_lob.getlength(l_final_xml),1));
1701:
1702: l_last_xml_string := ''||EOL||
1703: -- ''||EOL||
1704: ''||EOL||

Line 1712: l_is_temp_final_xml := dbms_lob.istemporary(l_final_xml);

1708: ''||EOL||
1709: ''||EOL||
1710: '';
1711:
1712: l_is_temp_final_xml := dbms_lob.istemporary(l_final_xml);
1713: hr_utility.trace('Istemporary(l_xml_string) ' ||l_is_temp_final_xml );
1714:
1715: IF l_is_temp_final_xml = 1 THEN
1716: DBMS_LOB.FREETEMPORARY(l_final_xml);

Line 1716: DBMS_LOB.FREETEMPORARY(l_final_xml);

1712: l_is_temp_final_xml := dbms_lob.istemporary(l_final_xml);
1713: hr_utility.trace('Istemporary(l_xml_string) ' ||l_is_temp_final_xml );
1714:
1715: IF l_is_temp_final_xml = 1 THEN
1716: DBMS_LOB.FREETEMPORARY(l_final_xml);
1717: END IF;
1718:
1719: dbms_lob.createtemporary(l_final_xml,false,DBMS_LOB.CALL);
1720: dbms_lob.open(l_final_xml,dbms_lob.lob_readwrite);

Line 1719: dbms_lob.createtemporary(l_final_xml,false,DBMS_LOB.CALL);

1715: IF l_is_temp_final_xml = 1 THEN
1716: DBMS_LOB.FREETEMPORARY(l_final_xml);
1717: END IF;
1718:
1719: dbms_lob.createtemporary(l_final_xml,false,DBMS_LOB.CALL);
1720: dbms_lob.open(l_final_xml,dbms_lob.lob_readwrite);
1721: l_final_xml := append_to_lob(l_final_xml_string);
1722: --dbms_lob.writeappend(l_final_xml,length(l_final_xml_string),l_final_xml_string);
1723:

Line 1720: dbms_lob.open(l_final_xml,dbms_lob.lob_readwrite);

1716: DBMS_LOB.FREETEMPORARY(l_final_xml);
1717: END IF;
1718:
1719: dbms_lob.createtemporary(l_final_xml,false,DBMS_LOB.CALL);
1720: dbms_lob.open(l_final_xml,dbms_lob.lob_readwrite);
1721: l_final_xml := append_to_lob(l_final_xml_string);
1722: --dbms_lob.writeappend(l_final_xml,length(l_final_xml_string),l_final_xml_string);
1723:
1724: hr_utility.trace('Get Length l_final_xml ' ||dbms_lob.getlength(l_final_xml) );

Line 1722: --dbms_lob.writeappend(l_final_xml,length(l_final_xml_string),l_final_xml_string);

1718:
1719: dbms_lob.createtemporary(l_final_xml,false,DBMS_LOB.CALL);
1720: dbms_lob.open(l_final_xml,dbms_lob.lob_readwrite);
1721: l_final_xml := append_to_lob(l_final_xml_string);
1722: --dbms_lob.writeappend(l_final_xml,length(l_final_xml_string),l_final_xml_string);
1723:
1724: hr_utility.trace('Get Length l_final_xml ' ||dbms_lob.getlength(l_final_xml) );
1725:
1726: dbms_lob.append(l_final_xml,p_xml_blob);

Line 1724: hr_utility.trace('Get Length l_final_xml ' ||dbms_lob.getlength(l_final_xml) );

1720: dbms_lob.open(l_final_xml,dbms_lob.lob_readwrite);
1721: l_final_xml := append_to_lob(l_final_xml_string);
1722: --dbms_lob.writeappend(l_final_xml,length(l_final_xml_string),l_final_xml_string);
1723:
1724: hr_utility.trace('Get Length l_final_xml ' ||dbms_lob.getlength(l_final_xml) );
1725:
1726: dbms_lob.append(l_final_xml,p_xml_blob);
1727:
1728: --dbms_lob.writeappend(l_final_xml,length(l_last_xml_string),l_last_xml_string);

Line 1726: dbms_lob.append(l_final_xml,p_xml_blob);

1722: --dbms_lob.writeappend(l_final_xml,length(l_final_xml_string),l_final_xml_string);
1723:
1724: hr_utility.trace('Get Length l_final_xml ' ||dbms_lob.getlength(l_final_xml) );
1725:
1726: dbms_lob.append(l_final_xml,p_xml_blob);
1727:
1728: --dbms_lob.writeappend(l_final_xml,length(l_last_xml_string),l_last_xml_string);
1729: dbms_lob.createtemporary(l_temp_blob,false,DBMS_LOB.CALL);
1730: dbms_lob.open(l_temp_blob,dbms_lob.lob_readwrite);

Line 1728: --dbms_lob.writeappend(l_final_xml,length(l_last_xml_string),l_last_xml_string);

1724: hr_utility.trace('Get Length l_final_xml ' ||dbms_lob.getlength(l_final_xml) );
1725:
1726: dbms_lob.append(l_final_xml,p_xml_blob);
1727:
1728: --dbms_lob.writeappend(l_final_xml,length(l_last_xml_string),l_last_xml_string);
1729: dbms_lob.createtemporary(l_temp_blob,false,DBMS_LOB.CALL);
1730: dbms_lob.open(l_temp_blob,dbms_lob.lob_readwrite);
1731: l_temp_blob := append_to_lob(l_last_xml_string);
1732: dbms_lob.append(l_final_xml,l_temp_blob);

Line 1729: dbms_lob.createtemporary(l_temp_blob,false,DBMS_LOB.CALL);

1725:
1726: dbms_lob.append(l_final_xml,p_xml_blob);
1727:
1728: --dbms_lob.writeappend(l_final_xml,length(l_last_xml_string),l_last_xml_string);
1729: dbms_lob.createtemporary(l_temp_blob,false,DBMS_LOB.CALL);
1730: dbms_lob.open(l_temp_blob,dbms_lob.lob_readwrite);
1731: l_temp_blob := append_to_lob(l_last_xml_string);
1732: dbms_lob.append(l_final_xml,l_temp_blob);
1733:

Line 1730: dbms_lob.open(l_temp_blob,dbms_lob.lob_readwrite);

1726: dbms_lob.append(l_final_xml,p_xml_blob);
1727:
1728: --dbms_lob.writeappend(l_final_xml,length(l_last_xml_string),l_last_xml_string);
1729: dbms_lob.createtemporary(l_temp_blob,false,DBMS_LOB.CALL);
1730: dbms_lob.open(l_temp_blob,dbms_lob.lob_readwrite);
1731: l_temp_blob := append_to_lob(l_last_xml_string);
1732: dbms_lob.append(l_final_xml,l_temp_blob);
1733:
1734: /* Added ISOPEN condition for bug 3899583 */

Line 1732: dbms_lob.append(l_final_xml,l_temp_blob);

1728: --dbms_lob.writeappend(l_final_xml,length(l_last_xml_string),l_last_xml_string);
1729: dbms_lob.createtemporary(l_temp_blob,false,DBMS_LOB.CALL);
1730: dbms_lob.open(l_temp_blob,dbms_lob.lob_readwrite);
1731: l_temp_blob := append_to_lob(l_last_xml_string);
1732: dbms_lob.append(l_final_xml,l_temp_blob);
1733:
1734: /* Added ISOPEN condition for bug 3899583 */
1735: IF DBMS_LOB.isopen(l_final_xml) = 1 THEN
1736: hr_utility.trace('Closing l_final_xml' );

Line 1735: IF DBMS_LOB.isopen(l_final_xml) = 1 THEN

1731: l_temp_blob := append_to_lob(l_last_xml_string);
1732: dbms_lob.append(l_final_xml,l_temp_blob);
1733:
1734: /* Added ISOPEN condition for bug 3899583 */
1735: IF DBMS_LOB.isopen(l_final_xml) = 1 THEN
1736: hr_utility.trace('Closing l_final_xml' );
1737: dbms_lob.close(l_final_xml);
1738: END IF;
1739: IF dbms_lob.ISOPEN(p_xml_blob)=1 THEN

Line 1737: dbms_lob.close(l_final_xml);

1733:
1734: /* Added ISOPEN condition for bug 3899583 */
1735: IF DBMS_LOB.isopen(l_final_xml) = 1 THEN
1736: hr_utility.trace('Closing l_final_xml' );
1737: dbms_lob.close(l_final_xml);
1738: END IF;
1739: IF dbms_lob.ISOPEN(p_xml_blob)=1 THEN
1740: hr_utility.trace('Closing p_xml_blob' );
1741: dbms_lob.close(p_xml_blob);

Line 1739: IF dbms_lob.ISOPEN(p_xml_blob)=1 THEN

1735: IF DBMS_LOB.isopen(l_final_xml) = 1 THEN
1736: hr_utility.trace('Closing l_final_xml' );
1737: dbms_lob.close(l_final_xml);
1738: END IF;
1739: IF dbms_lob.ISOPEN(p_xml_blob)=1 THEN
1740: hr_utility.trace('Closing p_xml_blob' );
1741: dbms_lob.close(p_xml_blob);
1742: END IF;
1743: IF dbms_lob.ISOPEN(l_temp_blob)=1 THEN

Line 1741: dbms_lob.close(p_xml_blob);

1737: dbms_lob.close(l_final_xml);
1738: END IF;
1739: IF dbms_lob.ISOPEN(p_xml_blob)=1 THEN
1740: hr_utility.trace('Closing p_xml_blob' );
1741: dbms_lob.close(p_xml_blob);
1742: END IF;
1743: IF dbms_lob.ISOPEN(l_temp_blob)=1 THEN
1744: hr_utility.trace('Closing l_temp_blob' );
1745: dbms_lob.close(l_temp_blob);

Line 1743: IF dbms_lob.ISOPEN(l_temp_blob)=1 THEN

1739: IF dbms_lob.ISOPEN(p_xml_blob)=1 THEN
1740: hr_utility.trace('Closing p_xml_blob' );
1741: dbms_lob.close(p_xml_blob);
1742: END IF;
1743: IF dbms_lob.ISOPEN(l_temp_blob)=1 THEN
1744: hr_utility.trace('Closing l_temp_blob' );
1745: dbms_lob.close(l_temp_blob);
1746: END IF;
1747: ELSE

Line 1745: dbms_lob.close(l_temp_blob);

1741: dbms_lob.close(p_xml_blob);
1742: END IF;
1743: IF dbms_lob.ISOPEN(l_temp_blob)=1 THEN
1744: hr_utility.trace('Closing l_temp_blob' );
1745: dbms_lob.close(l_temp_blob);
1746: END IF;
1747: ELSE
1748: dbms_lob.createtemporary(l_final_xml,false,DBMS_LOB.CALL);
1749: dbms_lob.open(l_final_xml,dbms_lob.lob_readwrite);

Line 1748: dbms_lob.createtemporary(l_final_xml,false,DBMS_LOB.CALL);

1744: hr_utility.trace('Closing l_temp_blob' );
1745: dbms_lob.close(l_temp_blob);
1746: END IF;
1747: ELSE
1748: dbms_lob.createtemporary(l_final_xml,false,DBMS_LOB.CALL);
1749: dbms_lob.open(l_final_xml,dbms_lob.lob_readwrite);
1750: l_final_xml := append_to_lob(p_error_msg);
1751:
1752: hr_utility.trace(' get final cml, p_error_msg '||p_error_msg);

Line 1749: dbms_lob.open(l_final_xml,dbms_lob.lob_readwrite);

1745: dbms_lob.close(l_temp_blob);
1746: END IF;
1747: ELSE
1748: dbms_lob.createtemporary(l_final_xml,false,DBMS_LOB.CALL);
1749: dbms_lob.open(l_final_xml,dbms_lob.lob_readwrite);
1750: l_final_xml := append_to_lob(p_error_msg);
1751:
1752: hr_utility.trace(' get final cml, p_error_msg '||p_error_msg);
1753:

Line 1755: hr_utility.trace('dbms_lob.getlength(l_final_xml) ' ||dbms_lob.getlength(l_final_xml));

1751:
1752: hr_utility.trace(' get final cml, p_error_msg '||p_error_msg);
1753:
1754: END IF ; /* p_error_msg is null */
1755: hr_utility.trace('dbms_lob.getlength(l_final_xml) ' ||dbms_lob.getlength(l_final_xml));
1756:
1757: return l_final_xml;
1758: EXCEPTION
1759: WHEN OTHERS then

Line 1761: IF dbms_lob.ISOPEN(l_final_xml)=1 THEN

1757: return l_final_xml;
1758: EXCEPTION
1759: WHEN OTHERS then
1760: /* Added ISOPEN condition for bug 3899583 */
1761: IF dbms_lob.ISOPEN(l_final_xml)=1 THEN
1762: hr_utility.trace('Raising exception and Closing l_final_xml' );
1763: dbms_lob.close(l_final_xml);
1764: END IF;
1765: IF dbms_lob.ISOPEN(p_xml_blob)=1 THEN

Line 1763: dbms_lob.close(l_final_xml);

1759: WHEN OTHERS then
1760: /* Added ISOPEN condition for bug 3899583 */
1761: IF dbms_lob.ISOPEN(l_final_xml)=1 THEN
1762: hr_utility.trace('Raising exception and Closing l_final_xml' );
1763: dbms_lob.close(l_final_xml);
1764: END IF;
1765: IF dbms_lob.ISOPEN(p_xml_blob)=1 THEN
1766: hr_utility.trace('Raising exception and Closing p_xml_string' );
1767: dbms_lob.close(p_xml_blob);

Line 1765: IF dbms_lob.ISOPEN(p_xml_blob)=1 THEN

1761: IF dbms_lob.ISOPEN(l_final_xml)=1 THEN
1762: hr_utility.trace('Raising exception and Closing l_final_xml' );
1763: dbms_lob.close(l_final_xml);
1764: END IF;
1765: IF dbms_lob.ISOPEN(p_xml_blob)=1 THEN
1766: hr_utility.trace('Raising exception and Closing p_xml_string' );
1767: dbms_lob.close(p_xml_blob);
1768: END IF;
1769: IF dbms_lob.ISOPEN(l_temp_blob)=1 THEN

Line 1767: dbms_lob.close(p_xml_blob);

1763: dbms_lob.close(l_final_xml);
1764: END IF;
1765: IF dbms_lob.ISOPEN(p_xml_blob)=1 THEN
1766: hr_utility.trace('Raising exception and Closing p_xml_string' );
1767: dbms_lob.close(p_xml_blob);
1768: END IF;
1769: IF dbms_lob.ISOPEN(l_temp_blob)=1 THEN
1770: hr_utility.trace('Closing l_temp_blob' );
1771: dbms_lob.close(l_temp_blob);

Line 1769: IF dbms_lob.ISOPEN(l_temp_blob)=1 THEN

1765: IF dbms_lob.ISOPEN(p_xml_blob)=1 THEN
1766: hr_utility.trace('Raising exception and Closing p_xml_string' );
1767: dbms_lob.close(p_xml_blob);
1768: END IF;
1769: IF dbms_lob.ISOPEN(l_temp_blob)=1 THEN
1770: hr_utility.trace('Closing l_temp_blob' );
1771: dbms_lob.close(l_temp_blob);
1772: END IF;
1773:

Line 1771: dbms_lob.close(l_temp_blob);

1767: dbms_lob.close(p_xml_blob);
1768: END IF;
1769: IF dbms_lob.ISOPEN(l_temp_blob)=1 THEN
1770: hr_utility.trace('Closing l_temp_blob' );
1771: dbms_lob.close(l_temp_blob);
1772: END IF;
1773:
1774:
1775: HR_UTILITY.TRACE('sqleerm ' || SQLERRM);

Line 1860: IF ((dbms_lob.getlength(lc_emp_blob) >0) and (l_error_msg IS NULL) )THEN

1856: l_tax_unit_id,
1857: l_year,
1858: l_error_msg, false);
1859: hr_utility.trace('XML String is ');
1860: IF ((dbms_lob.getlength(lc_emp_blob) >0) and (l_error_msg IS NULL) )THEN
1861:
1862: --hr_utility.trace(dbms_lob.substr(lc_emp_blob,dbms_lob.getlength(lc_emp_blob),1));
1863:
1864: l_final_xml_string := /* 6712851 ''|| EOL|| */

Line 1862: --hr_utility.trace(dbms_lob.substr(lc_emp_blob,dbms_lob.getlength(lc_emp_blob),1));

1858: l_error_msg, false);
1859: hr_utility.trace('XML String is ');
1860: IF ((dbms_lob.getlength(lc_emp_blob) >0) and (l_error_msg IS NULL) )THEN
1861:
1862: --hr_utility.trace(dbms_lob.substr(lc_emp_blob,dbms_lob.getlength(lc_emp_blob),1));
1863:
1864: l_final_xml_string := /* 6712851 ''|| EOL|| */
1865: ''||EOL||
1866: ''||EOL||

Line 1888: l_is_temp_final_xml := dbms_lob.istemporary(l_final_xml);

1884: ''||EOL||
1885: ''||EOL;
1886:
1887:
1888: l_is_temp_final_xml := dbms_lob.istemporary(l_final_xml);
1889: hr_utility.trace('Istemporary(l_xml_string) ' ||l_is_temp_final_xml );
1890:
1891: IF l_is_temp_final_xml = 1 THEN
1892: DBMS_LOB.FREETEMPORARY(l_final_xml);

Line 1892: DBMS_LOB.FREETEMPORARY(l_final_xml);

1888: l_is_temp_final_xml := dbms_lob.istemporary(l_final_xml);
1889: hr_utility.trace('Istemporary(l_xml_string) ' ||l_is_temp_final_xml );
1890:
1891: IF l_is_temp_final_xml = 1 THEN
1892: DBMS_LOB.FREETEMPORARY(l_final_xml);
1893: END IF;
1894:
1895: dbms_lob.createtemporary(l_final_xml,false,DBMS_LOB.CALL);
1896: dbms_lob.open(l_final_xml,dbms_lob.lob_readwrite);

Line 1895: dbms_lob.createtemporary(l_final_xml,false,DBMS_LOB.CALL);

1891: IF l_is_temp_final_xml = 1 THEN
1892: DBMS_LOB.FREETEMPORARY(l_final_xml);
1893: END IF;
1894:
1895: dbms_lob.createtemporary(l_final_xml,false,DBMS_LOB.CALL);
1896: dbms_lob.open(l_final_xml,dbms_lob.lob_readwrite);
1897:
1898: dbms_lob.createtemporary(l_temp_blob,false,DBMS_LOB.CALL);
1899: dbms_lob.open(l_temp_blob,dbms_lob.lob_readwrite);

Line 1896: dbms_lob.open(l_final_xml,dbms_lob.lob_readwrite);

1892: DBMS_LOB.FREETEMPORARY(l_final_xml);
1893: END IF;
1894:
1895: dbms_lob.createtemporary(l_final_xml,false,DBMS_LOB.CALL);
1896: dbms_lob.open(l_final_xml,dbms_lob.lob_readwrite);
1897:
1898: dbms_lob.createtemporary(l_temp_blob,false,DBMS_LOB.CALL);
1899: dbms_lob.open(l_temp_blob,dbms_lob.lob_readwrite);
1900:

Line 1898: dbms_lob.createtemporary(l_temp_blob,false,DBMS_LOB.CALL);

1894:
1895: dbms_lob.createtemporary(l_final_xml,false,DBMS_LOB.CALL);
1896: dbms_lob.open(l_final_xml,dbms_lob.lob_readwrite);
1897:
1898: dbms_lob.createtemporary(l_temp_blob,false,DBMS_LOB.CALL);
1899: dbms_lob.open(l_temp_blob,dbms_lob.lob_readwrite);
1900:
1901: raw_data:=utl_raw.cast_to_raw(l_final_xml_string);
1902: text_size:=utl_raw.length(raw_data);

Line 1899: dbms_lob.open(l_temp_blob,dbms_lob.lob_readwrite);

1895: dbms_lob.createtemporary(l_final_xml,false,DBMS_LOB.CALL);
1896: dbms_lob.open(l_final_xml,dbms_lob.lob_readwrite);
1897:
1898: dbms_lob.createtemporary(l_temp_blob,false,DBMS_LOB.CALL);
1899: dbms_lob.open(l_temp_blob,dbms_lob.lob_readwrite);
1900:
1901: raw_data:=utl_raw.cast_to_raw(l_final_xml_string);
1902: text_size:=utl_raw.length(raw_data);
1903:

Line 1904: -- dbms_lob.writeappend(l_final_xml,text_size,raw_data);

1900:
1901: raw_data:=utl_raw.cast_to_raw(l_final_xml_string);
1902: text_size:=utl_raw.length(raw_data);
1903:
1904: -- dbms_lob.writeappend(l_final_xml,text_size,raw_data);
1905:
1906: /*dbms_lob.writeappend(l_final_xml,
1907: utl_raw.length(utl_raw.cast_to_raw(l_final_xml_string)),
1908: utl_raw.cast_to_raw(l_final_xml_string)

Line 1906: /*dbms_lob.writeappend(l_final_xml,

1902: text_size:=utl_raw.length(raw_data);
1903:
1904: -- dbms_lob.writeappend(l_final_xml,text_size,raw_data);
1905:
1906: /*dbms_lob.writeappend(l_final_xml,
1907: utl_raw.length(utl_raw.cast_to_raw(l_final_xml_string)),
1908: utl_raw.cast_to_raw(l_final_xml_string)
1909: );*/
1910: l_temp_blob := append_to_lob(l_final_xml_string);

Line 1911: dbms_lob.append(l_final_xml,l_temp_blob);

1907: utl_raw.length(utl_raw.cast_to_raw(l_final_xml_string)),
1908: utl_raw.cast_to_raw(l_final_xml_string)
1909: );*/
1910: l_temp_blob := append_to_lob(l_final_xml_string);
1911: dbms_lob.append(l_final_xml,l_temp_blob);
1912:
1913: --dbms_lob.writeappend(l_final_xml,length(l_final_xml_string),l_final_xml_string);
1914:
1915: hr_utility.trace('Get Length l_final_xml ' ||dbms_lob.getlength(l_final_xml) );

Line 1913: --dbms_lob.writeappend(l_final_xml,length(l_final_xml_string),l_final_xml_string);

1909: );*/
1910: l_temp_blob := append_to_lob(l_final_xml_string);
1911: dbms_lob.append(l_final_xml,l_temp_blob);
1912:
1913: --dbms_lob.writeappend(l_final_xml,length(l_final_xml_string),l_final_xml_string);
1914:
1915: hr_utility.trace('Get Length l_final_xml ' ||dbms_lob.getlength(l_final_xml) );
1916:
1917: dbms_lob.append(l_final_xml,lc_emp_blob);

Line 1915: hr_utility.trace('Get Length l_final_xml ' ||dbms_lob.getlength(l_final_xml) );

1911: dbms_lob.append(l_final_xml,l_temp_blob);
1912:
1913: --dbms_lob.writeappend(l_final_xml,length(l_final_xml_string),l_final_xml_string);
1914:
1915: hr_utility.trace('Get Length l_final_xml ' ||dbms_lob.getlength(l_final_xml) );
1916:
1917: dbms_lob.append(l_final_xml,lc_emp_blob);
1918:
1919: raw_data:=utl_raw.cast_to_raw(l_last_xml_string);

Line 1917: dbms_lob.append(l_final_xml,lc_emp_blob);

1913: --dbms_lob.writeappend(l_final_xml,length(l_final_xml_string),l_final_xml_string);
1914:
1915: hr_utility.trace('Get Length l_final_xml ' ||dbms_lob.getlength(l_final_xml) );
1916:
1917: dbms_lob.append(l_final_xml,lc_emp_blob);
1918:
1919: raw_data:=utl_raw.cast_to_raw(l_last_xml_string);
1920: text_size:=utl_raw.length(raw_data);
1921:

Line 1922: --dbms_lob.writeappend(l_final_xml,text_size,raw_data);

1918:
1919: raw_data:=utl_raw.cast_to_raw(l_last_xml_string);
1920: text_size:=utl_raw.length(raw_data);
1921:
1922: --dbms_lob.writeappend(l_final_xml,text_size,raw_data);
1923:
1924: /*dbms_lob.writeappend(l_final_xml,
1925: utl_raw.length(utl_raw.cast_to_raw(l_last_xml_string)),
1926: utl_raw.cast_to_raw(l_last_xml_string)

Line 1924: /*dbms_lob.writeappend(l_final_xml,

1920: text_size:=utl_raw.length(raw_data);
1921:
1922: --dbms_lob.writeappend(l_final_xml,text_size,raw_data);
1923:
1924: /*dbms_lob.writeappend(l_final_xml,
1925: utl_raw.length(utl_raw.cast_to_raw(l_last_xml_string)),
1926: utl_raw.cast_to_raw(l_last_xml_string)
1927: );*/
1928:

Line 1931: dbms_lob.append(l_final_xml,l_temp_blob);

1927: );*/
1928:
1929:
1930: l_temp_blob := append_to_lob(l_last_xml_string);
1931: dbms_lob.append(l_final_xml,l_temp_blob);
1932: --dbms_lob.writeappend(l_final_xml,length(l_last_xml_string),l_last_xml_string);
1933:
1934: IF DBMS_LOB.isopen(l_final_xml) = 1 THEN
1935: hr_utility.trace('Closing l_final_xml' );

Line 1932: --dbms_lob.writeappend(l_final_xml,length(l_last_xml_string),l_last_xml_string);

1928:
1929:
1930: l_temp_blob := append_to_lob(l_last_xml_string);
1931: dbms_lob.append(l_final_xml,l_temp_blob);
1932: --dbms_lob.writeappend(l_final_xml,length(l_last_xml_string),l_last_xml_string);
1933:
1934: IF DBMS_LOB.isopen(l_final_xml) = 1 THEN
1935: hr_utility.trace('Closing l_final_xml' );
1936: dbms_lob.close(l_final_xml);

Line 1934: IF DBMS_LOB.isopen(l_final_xml) = 1 THEN

1930: l_temp_blob := append_to_lob(l_last_xml_string);
1931: dbms_lob.append(l_final_xml,l_temp_blob);
1932: --dbms_lob.writeappend(l_final_xml,length(l_last_xml_string),l_last_xml_string);
1933:
1934: IF DBMS_LOB.isopen(l_final_xml) = 1 THEN
1935: hr_utility.trace('Closing l_final_xml' );
1936: dbms_lob.close(l_final_xml);
1937: END IF;
1938: IF dbms_lob.ISOPEN(lc_emp_blob)=1 THEN

Line 1936: dbms_lob.close(l_final_xml);

1932: --dbms_lob.writeappend(l_final_xml,length(l_last_xml_string),l_last_xml_string);
1933:
1934: IF DBMS_LOB.isopen(l_final_xml) = 1 THEN
1935: hr_utility.trace('Closing l_final_xml' );
1936: dbms_lob.close(l_final_xml);
1937: END IF;
1938: IF dbms_lob.ISOPEN(lc_emp_blob)=1 THEN
1939: hr_utility.trace('Closing lc_emp_blob' );
1940: dbms_lob.close(lc_emp_blob);

Line 1938: IF dbms_lob.ISOPEN(lc_emp_blob)=1 THEN

1934: IF DBMS_LOB.isopen(l_final_xml) = 1 THEN
1935: hr_utility.trace('Closing l_final_xml' );
1936: dbms_lob.close(l_final_xml);
1937: END IF;
1938: IF dbms_lob.ISOPEN(lc_emp_blob)=1 THEN
1939: hr_utility.trace('Closing lc_emp_blob' );
1940: dbms_lob.close(lc_emp_blob);
1941: END IF;
1942: IF dbms_lob.ISOPEN(l_temp_blob)=1 THEN

Line 1940: dbms_lob.close(lc_emp_blob);

1936: dbms_lob.close(l_final_xml);
1937: END IF;
1938: IF dbms_lob.ISOPEN(lc_emp_blob)=1 THEN
1939: hr_utility.trace('Closing lc_emp_blob' );
1940: dbms_lob.close(lc_emp_blob);
1941: END IF;
1942: IF dbms_lob.ISOPEN(l_temp_blob)=1 THEN
1943: hr_utility.trace('Closing l_temp_blob' );
1944: dbms_lob.close(l_temp_blob);

Line 1942: IF dbms_lob.ISOPEN(l_temp_blob)=1 THEN

1938: IF dbms_lob.ISOPEN(lc_emp_blob)=1 THEN
1939: hr_utility.trace('Closing lc_emp_blob' );
1940: dbms_lob.close(lc_emp_blob);
1941: END IF;
1942: IF dbms_lob.ISOPEN(l_temp_blob)=1 THEN
1943: hr_utility.trace('Closing l_temp_blob' );
1944: dbms_lob.close(l_temp_blob);
1945: END IF;
1946:

Line 1944: dbms_lob.close(l_temp_blob);

1940: dbms_lob.close(lc_emp_blob);
1941: END IF;
1942: IF dbms_lob.ISOPEN(l_temp_blob)=1 THEN
1943: hr_utility.trace('Closing l_temp_blob' );
1944: dbms_lob.close(l_temp_blob);
1945: END IF;
1946:
1947: hr_utility.trace('dbms_lob.getlength(l_final_xml) ' ||dbms_lob.getlength(l_final_xml));
1948:

Line 1947: hr_utility.trace('dbms_lob.getlength(l_final_xml) ' ||dbms_lob.getlength(l_final_xml));

1943: hr_utility.trace('Closing l_temp_blob' );
1944: dbms_lob.close(l_temp_blob);
1945: END IF;
1946:
1947: hr_utility.trace('dbms_lob.getlength(l_final_xml) ' ||dbms_lob.getlength(l_final_xml));
1948:
1949: pay_core_files.write_to_magtape_lob(l_final_xml);
1950: -- hr_utility.trace('Length of pay_mag_tape.g_clob_value ' ||dbms_lob.getlength(pay_mag_tape.g_clob_value));
1951:

Line 1950: -- hr_utility.trace('Length of pay_mag_tape.g_clob_value ' ||dbms_lob.getlength(pay_mag_tape.g_clob_value));

1946:
1947: hr_utility.trace('dbms_lob.getlength(l_final_xml) ' ||dbms_lob.getlength(l_final_xml));
1948:
1949: pay_core_files.write_to_magtape_lob(l_final_xml);
1950: -- hr_utility.trace('Length of pay_mag_tape.g_clob_value ' ||dbms_lob.getlength(pay_mag_tape.g_clob_value));
1951:
1952: END IF; /*dbms_lob.getlength(lc_emp_blob) >0*/
1953: -- l_is_temp_xml_string := dbms_lob.istemporary(pay_mag_tape.g_clob_value);
1954:

Line 1952: END IF; /dbms_lob.getlength(lc_emp_blob) >0/

1948:
1949: pay_core_files.write_to_magtape_lob(l_final_xml);
1950: -- hr_utility.trace('Length of pay_mag_tape.g_clob_value ' ||dbms_lob.getlength(pay_mag_tape.g_clob_value));
1951:
1952: END IF; /*dbms_lob.getlength(lc_emp_blob) >0*/
1953: -- l_is_temp_xml_string := dbms_lob.istemporary(pay_mag_tape.g_clob_value);
1954:
1955:
1956:

Line 1953: -- l_is_temp_xml_string := dbms_lob.istemporary(pay_mag_tape.g_clob_value);

1949: pay_core_files.write_to_magtape_lob(l_final_xml);
1950: -- hr_utility.trace('Length of pay_mag_tape.g_clob_value ' ||dbms_lob.getlength(pay_mag_tape.g_clob_value));
1951:
1952: END IF; /*dbms_lob.getlength(lc_emp_blob) >0*/
1953: -- l_is_temp_xml_string := dbms_lob.istemporary(pay_mag_tape.g_clob_value);
1954:
1955:
1956:
1957: EXCEPTION

Line 1960: IF dbms_lob.ISOPEN(l_final_xml)=1 THEN

1956:
1957: EXCEPTION
1958: WHEN OTHERS then
1959: /* Added ISOPEN condition for bug 3899583 */
1960: IF dbms_lob.ISOPEN(l_final_xml)=1 THEN
1961: hr_utility.trace('Raising exception and Closing l_final_xml' ||sqlerrm);
1962: dbms_lob.close(l_final_xml);
1963: END IF;
1964: IF dbms_lob.ISOPEN(lc_emp_blob)=1 THEN

Line 1962: dbms_lob.close(l_final_xml);

1958: WHEN OTHERS then
1959: /* Added ISOPEN condition for bug 3899583 */
1960: IF dbms_lob.ISOPEN(l_final_xml)=1 THEN
1961: hr_utility.trace('Raising exception and Closing l_final_xml' ||sqlerrm);
1962: dbms_lob.close(l_final_xml);
1963: END IF;
1964: IF dbms_lob.ISOPEN(lc_emp_blob)=1 THEN
1965: hr_utility.trace('Raising exception and Closing p_xml_string' );
1966: dbms_lob.close(lc_emp_blob);

Line 1964: IF dbms_lob.ISOPEN(lc_emp_blob)=1 THEN

1960: IF dbms_lob.ISOPEN(l_final_xml)=1 THEN
1961: hr_utility.trace('Raising exception and Closing l_final_xml' ||sqlerrm);
1962: dbms_lob.close(l_final_xml);
1963: END IF;
1964: IF dbms_lob.ISOPEN(lc_emp_blob)=1 THEN
1965: hr_utility.trace('Raising exception and Closing p_xml_string' );
1966: dbms_lob.close(lc_emp_blob);
1967: END IF;
1968: IF dbms_lob.ISOPEN(l_temp_blob)=1 THEN

Line 1966: dbms_lob.close(lc_emp_blob);

1962: dbms_lob.close(l_final_xml);
1963: END IF;
1964: IF dbms_lob.ISOPEN(lc_emp_blob)=1 THEN
1965: hr_utility.trace('Raising exception and Closing p_xml_string' );
1966: dbms_lob.close(lc_emp_blob);
1967: END IF;
1968: IF dbms_lob.ISOPEN(l_temp_blob)=1 THEN
1969: hr_utility.trace('Closing l_temp_blob' );
1970: dbms_lob.close(l_temp_blob);

Line 1968: IF dbms_lob.ISOPEN(l_temp_blob)=1 THEN

1964: IF dbms_lob.ISOPEN(lc_emp_blob)=1 THEN
1965: hr_utility.trace('Raising exception and Closing p_xml_string' );
1966: dbms_lob.close(lc_emp_blob);
1967: END IF;
1968: IF dbms_lob.ISOPEN(l_temp_blob)=1 THEN
1969: hr_utility.trace('Closing l_temp_blob' );
1970: dbms_lob.close(l_temp_blob);
1971: END IF;
1972:

Line 1970: dbms_lob.close(l_temp_blob);

1966: dbms_lob.close(lc_emp_blob);
1967: END IF;
1968: IF dbms_lob.ISOPEN(l_temp_blob)=1 THEN
1969: hr_utility.trace('Closing l_temp_blob' );
1970: dbms_lob.close(l_temp_blob);
1971: END IF;
1972:
1973: HR_UTILITY.TRACE('sqleerm ' || SQLERRM);
1974:

Line 1988: l_is_temp_final_xml := dbms_lob.istemporary(l_footer_xml);

1984: BEGIN
1985: EOL := fnd_global.local_chr(13)||fnd_global.local_chr(10);
1986: l_last_xml_string :=
1987: ''||EOL;
1988: l_is_temp_final_xml := dbms_lob.istemporary(l_footer_xml);
1989: hr_utility.trace('Istemporary(l_footer_xml) ' ||l_is_temp_final_xml );
1990:
1991: IF l_is_temp_final_xml = 1 THEN
1992: DBMS_LOB.FREETEMPORARY(l_footer_xml);

Line 1992: DBMS_LOB.FREETEMPORARY(l_footer_xml);

1988: l_is_temp_final_xml := dbms_lob.istemporary(l_footer_xml);
1989: hr_utility.trace('Istemporary(l_footer_xml) ' ||l_is_temp_final_xml );
1990:
1991: IF l_is_temp_final_xml = 1 THEN
1992: DBMS_LOB.FREETEMPORARY(l_footer_xml);
1993: END IF;
1994:
1995: dbms_lob.createtemporary(l_footer_xml,false,DBMS_LOB.CALL);
1996: dbms_lob.open(l_footer_xml,dbms_lob.lob_readwrite);

Line 1995: dbms_lob.createtemporary(l_footer_xml,false,DBMS_LOB.CALL);

1991: IF l_is_temp_final_xml = 1 THEN
1992: DBMS_LOB.FREETEMPORARY(l_footer_xml);
1993: END IF;
1994:
1995: dbms_lob.createtemporary(l_footer_xml,false,DBMS_LOB.CALL);
1996: dbms_lob.open(l_footer_xml,dbms_lob.lob_readwrite);
1997: dbms_lob.writeappend(l_footer_xml,length(l_last_xml_string),l_last_xml_string);
1998:
1999: hr_utility.trace('In Get footers,Length of length(l_footer_xml) ' ||dbms_lob.getlength(l_footer_xml));

Line 1996: dbms_lob.open(l_footer_xml,dbms_lob.lob_readwrite);

1992: DBMS_LOB.FREETEMPORARY(l_footer_xml);
1993: END IF;
1994:
1995: dbms_lob.createtemporary(l_footer_xml,false,DBMS_LOB.CALL);
1996: dbms_lob.open(l_footer_xml,dbms_lob.lob_readwrite);
1997: dbms_lob.writeappend(l_footer_xml,length(l_last_xml_string),l_last_xml_string);
1998:
1999: hr_utility.trace('In Get footers,Length of length(l_footer_xml) ' ||dbms_lob.getlength(l_footer_xml));
2000:

Line 1997: dbms_lob.writeappend(l_footer_xml,length(l_last_xml_string),l_last_xml_string);

1993: END IF;
1994:
1995: dbms_lob.createtemporary(l_footer_xml,false,DBMS_LOB.CALL);
1996: dbms_lob.open(l_footer_xml,dbms_lob.lob_readwrite);
1997: dbms_lob.writeappend(l_footer_xml,length(l_last_xml_string),l_last_xml_string);
1998:
1999: hr_utility.trace('In Get footers,Length of length(l_footer_xml) ' ||dbms_lob.getlength(l_footer_xml));
2000:
2001: --dbms_lob.append(pay_mag_tape.g_clob_value,l_footer_xml);

Line 1999: hr_utility.trace('In Get footers,Length of length(l_footer_xml) ' ||dbms_lob.getlength(l_footer_xml));

1995: dbms_lob.createtemporary(l_footer_xml,false,DBMS_LOB.CALL);
1996: dbms_lob.open(l_footer_xml,dbms_lob.lob_readwrite);
1997: dbms_lob.writeappend(l_footer_xml,length(l_last_xml_string),l_last_xml_string);
1998:
1999: hr_utility.trace('In Get footers,Length of length(l_footer_xml) ' ||dbms_lob.getlength(l_footer_xml));
2000:
2001: --dbms_lob.append(pay_mag_tape.g_clob_value,l_footer_xml);
2002: pay_core_files.write_to_magtape_lob(l_last_xml_string);
2003: --pay_core_files.write_to_magtape_lob(dbms_lob.substr(l_footer_xml,dbms_lob.getlength(l_footer_xml),1));

Line 2001: --dbms_lob.append(pay_mag_tape.g_clob_value,l_footer_xml);

1997: dbms_lob.writeappend(l_footer_xml,length(l_last_xml_string),l_last_xml_string);
1998:
1999: hr_utility.trace('In Get footers,Length of length(l_footer_xml) ' ||dbms_lob.getlength(l_footer_xml));
2000:
2001: --dbms_lob.append(pay_mag_tape.g_clob_value,l_footer_xml);
2002: pay_core_files.write_to_magtape_lob(l_last_xml_string);
2003: --pay_core_files.write_to_magtape_lob(dbms_lob.substr(l_footer_xml,dbms_lob.getlength(l_footer_xml),1));
2004:
2005: --hr_utility.trace('In Get footers,Length of pay_mag_tape.g_clob_value ' ||dbms_lob.getlength(pay_mag_tape.g_clob_value));

Line 2003: --pay_core_files.write_to_magtape_lob(dbms_lob.substr(l_footer_xml,dbms_lob.getlength(l_footer_xml),1));

1999: hr_utility.trace('In Get footers,Length of length(l_footer_xml) ' ||dbms_lob.getlength(l_footer_xml));
2000:
2001: --dbms_lob.append(pay_mag_tape.g_clob_value,l_footer_xml);
2002: pay_core_files.write_to_magtape_lob(l_last_xml_string);
2003: --pay_core_files.write_to_magtape_lob(dbms_lob.substr(l_footer_xml,dbms_lob.getlength(l_footer_xml),1));
2004:
2005: --hr_utility.trace('In Get footers,Length of pay_mag_tape.g_clob_value ' ||dbms_lob.getlength(pay_mag_tape.g_clob_value));
2006: END;
2007:

Line 2005: --hr_utility.trace('In Get footers,Length of pay_mag_tape.g_clob_value ' ||dbms_lob.getlength(pay_mag_tape.g_clob_value));

2001: --dbms_lob.append(pay_mag_tape.g_clob_value,l_footer_xml);
2002: pay_core_files.write_to_magtape_lob(l_last_xml_string);
2003: --pay_core_files.write_to_magtape_lob(dbms_lob.substr(l_footer_xml,dbms_lob.getlength(l_footer_xml),1));
2004:
2005: --hr_utility.trace('In Get footers,Length of pay_mag_tape.g_clob_value ' ||dbms_lob.getlength(pay_mag_tape.g_clob_value));
2006: END;
2007:
2008: PROCEDURE get_headers IS
2009:

Line 2019: l_is_temp_final_xml := dbms_lob.istemporary(l_final_xml);

2015: l_final_xml_string :=
2016: -- ''|| EOL|| Bug 6712851
2017: ''||EOL;
2018:
2019: l_is_temp_final_xml := dbms_lob.istemporary(l_final_xml);
2020: hr_utility.trace('Istemporary(l_final_xml) ' ||l_is_temp_final_xml );
2021:
2022: IF l_is_temp_final_xml = 1 THEN
2023: DBMS_LOB.FREETEMPORARY(l_final_xml);

Line 2023: DBMS_LOB.FREETEMPORARY(l_final_xml);

2019: l_is_temp_final_xml := dbms_lob.istemporary(l_final_xml);
2020: hr_utility.trace('Istemporary(l_final_xml) ' ||l_is_temp_final_xml );
2021:
2022: IF l_is_temp_final_xml = 1 THEN
2023: DBMS_LOB.FREETEMPORARY(l_final_xml);
2024: END IF;
2025:
2026: dbms_lob.createtemporary(l_final_xml,false,DBMS_LOB.CALL);
2027: dbms_lob.open(l_final_xml,dbms_lob.lob_readwrite);

Line 2026: dbms_lob.createtemporary(l_final_xml,false,DBMS_LOB.CALL);

2022: IF l_is_temp_final_xml = 1 THEN
2023: DBMS_LOB.FREETEMPORARY(l_final_xml);
2024: END IF;
2025:
2026: dbms_lob.createtemporary(l_final_xml,false,DBMS_LOB.CALL);
2027: dbms_lob.open(l_final_xml,dbms_lob.lob_readwrite);
2028: dbms_lob.writeappend(l_final_xml,length(l_final_xml_string),l_final_xml_string);
2029: --dbms_lob.append(pay_mag_tape.g_clob_value,l_final_xml);
2030: pay_core_files.write_to_magtape_lob(l_final_xml_string);

Line 2027: dbms_lob.open(l_final_xml,dbms_lob.lob_readwrite);

2023: DBMS_LOB.FREETEMPORARY(l_final_xml);
2024: END IF;
2025:
2026: dbms_lob.createtemporary(l_final_xml,false,DBMS_LOB.CALL);
2027: dbms_lob.open(l_final_xml,dbms_lob.lob_readwrite);
2028: dbms_lob.writeappend(l_final_xml,length(l_final_xml_string),l_final_xml_string);
2029: --dbms_lob.append(pay_mag_tape.g_clob_value,l_final_xml);
2030: pay_core_files.write_to_magtape_lob(l_final_xml_string);
2031: --pay_core_files.write_to_magtape_lob(dbms_lob.substr(l_final_xml_string,dbms_lob.getlength(l_final_xml_string),1));

Line 2028: dbms_lob.writeappend(l_final_xml,length(l_final_xml_string),l_final_xml_string);

2024: END IF;
2025:
2026: dbms_lob.createtemporary(l_final_xml,false,DBMS_LOB.CALL);
2027: dbms_lob.open(l_final_xml,dbms_lob.lob_readwrite);
2028: dbms_lob.writeappend(l_final_xml,length(l_final_xml_string),l_final_xml_string);
2029: --dbms_lob.append(pay_mag_tape.g_clob_value,l_final_xml);
2030: pay_core_files.write_to_magtape_lob(l_final_xml_string);
2031: --pay_core_files.write_to_magtape_lob(dbms_lob.substr(l_final_xml_string,dbms_lob.getlength(l_final_xml_string),1));
2032: --hr_utility.trace('Length of pay_mag_tape.g_clob_value ' ||dbms_lob.getlength(pay_mag_tape.g_clob_value));

Line 2029: --dbms_lob.append(pay_mag_tape.g_clob_value,l_final_xml);

2025:
2026: dbms_lob.createtemporary(l_final_xml,false,DBMS_LOB.CALL);
2027: dbms_lob.open(l_final_xml,dbms_lob.lob_readwrite);
2028: dbms_lob.writeappend(l_final_xml,length(l_final_xml_string),l_final_xml_string);
2029: --dbms_lob.append(pay_mag_tape.g_clob_value,l_final_xml);
2030: pay_core_files.write_to_magtape_lob(l_final_xml_string);
2031: --pay_core_files.write_to_magtape_lob(dbms_lob.substr(l_final_xml_string,dbms_lob.getlength(l_final_xml_string),1));
2032: --hr_utility.trace('Length of pay_mag_tape.g_clob_value ' ||dbms_lob.getlength(pay_mag_tape.g_clob_value));
2033: END;

Line 2031: --pay_core_files.write_to_magtape_lob(dbms_lob.substr(l_final_xml_string,dbms_lob.getlength(l_final_xml_string),1));

2027: dbms_lob.open(l_final_xml,dbms_lob.lob_readwrite);
2028: dbms_lob.writeappend(l_final_xml,length(l_final_xml_string),l_final_xml_string);
2029: --dbms_lob.append(pay_mag_tape.g_clob_value,l_final_xml);
2030: pay_core_files.write_to_magtape_lob(l_final_xml_string);
2031: --pay_core_files.write_to_magtape_lob(dbms_lob.substr(l_final_xml_string,dbms_lob.getlength(l_final_xml_string),1));
2032: --hr_utility.trace('Length of pay_mag_tape.g_clob_value ' ||dbms_lob.getlength(pay_mag_tape.g_clob_value));
2033: END;
2034:
2035: function get_outfile return VARCHAR2 is

Line 2032: --hr_utility.trace('Length of pay_mag_tape.g_clob_value ' ||dbms_lob.getlength(pay_mag_tape.g_clob_value));

2028: dbms_lob.writeappend(l_final_xml,length(l_final_xml_string),l_final_xml_string);
2029: --dbms_lob.append(pay_mag_tape.g_clob_value,l_final_xml);
2030: pay_core_files.write_to_magtape_lob(l_final_xml_string);
2031: --pay_core_files.write_to_magtape_lob(dbms_lob.substr(l_final_xml_string,dbms_lob.getlength(l_final_xml_string),1));
2032: --hr_utility.trace('Length of pay_mag_tape.g_clob_value ' ||dbms_lob.getlength(pay_mag_tape.g_clob_value));
2033: END;
2034:
2035: function get_outfile return VARCHAR2 is
2036: TEMP_UTL varchar2(512);