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 1156: is_temp := dbms_lob.istemporary(l_xml_blob);

1152:
1153:
1154:
1155: hr_utility.trace('one set XML string ' ||l_xml_string);
1156: is_temp := dbms_lob.istemporary(l_xml_blob);
1157: hr_utility.trace('Istemporary(l_xml_blob) ' ||is_temp );
1158:
1159: IF is_temp = 1 THEN
1160: DBMS_LOB.FREETEMPORARY(l_xml_blob);

Line 1160: DBMS_LOB.FREETEMPORARY(l_xml_blob);

1156: is_temp := dbms_lob.istemporary(l_xml_blob);
1157: hr_utility.trace('Istemporary(l_xml_blob) ' ||is_temp );
1158:
1159: IF is_temp = 1 THEN
1160: DBMS_LOB.FREETEMPORARY(l_xml_blob);
1161: END IF;
1162:
1163: dbms_lob.createtemporary(l_xml_blob,false,DBMS_LOB.CALL);
1164: dbms_lob.open(l_xml_blob,dbms_lob.lob_readwrite);

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

1159: IF is_temp = 1 THEN
1160: DBMS_LOB.FREETEMPORARY(l_xml_blob);
1161: END IF;
1162:
1163: dbms_lob.createtemporary(l_xml_blob,false,DBMS_LOB.CALL);
1164: dbms_lob.open(l_xml_blob,dbms_lob.lob_readwrite);
1165: hr_utility.trace('OPENED l_xml_blob ' );
1166:
1167: raw_data:=utl_raw.cast_to_raw(l_xml_string);

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

1160: DBMS_LOB.FREETEMPORARY(l_xml_blob);
1161: END IF;
1162:
1163: dbms_lob.createtemporary(l_xml_blob,false,DBMS_LOB.CALL);
1164: dbms_lob.open(l_xml_blob,dbms_lob.lob_readwrite);
1165: hr_utility.trace('OPENED l_xml_blob ' );
1166:
1167: raw_data:=utl_raw.cast_to_raw(l_xml_string);
1168: text_size:=utl_raw.length(raw_data);

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

1166:
1167: raw_data:=utl_raw.cast_to_raw(l_xml_string);
1168: text_size:=utl_raw.length(raw_data);
1169:
1170: dbms_lob.writeappend(l_xml_blob,text_size,raw_data);
1171:
1172: hr_utility.trace('Get Length l_xml_clob ' ||dbms_lob.getlength(l_xml_blob) );
1173: dbms_lob.close(l_xml_blob);
1174: return l_xml_blob;

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

1168: text_size:=utl_raw.length(raw_data);
1169:
1170: dbms_lob.writeappend(l_xml_blob,text_size,raw_data);
1171:
1172: hr_utility.trace('Get Length l_xml_clob ' ||dbms_lob.getlength(l_xml_blob) );
1173: dbms_lob.close(l_xml_blob);
1174: return l_xml_blob;
1175: exception
1176: when OTHERS then

Line 1173: dbms_lob.close(l_xml_blob);

1169:
1170: dbms_lob.writeappend(l_xml_blob,text_size,raw_data);
1171:
1172: hr_utility.trace('Get Length l_xml_clob ' ||dbms_lob.getlength(l_xml_blob) );
1173: dbms_lob.close(l_xml_blob);
1174: return l_xml_blob;
1175: exception
1176: when OTHERS then
1177: dbms_lob.close(l_xml_blob);

Line 1177: dbms_lob.close(l_xml_blob);

1173: dbms_lob.close(l_xml_blob);
1174: return l_xml_blob;
1175: exception
1176: when OTHERS then
1177: dbms_lob.close(l_xml_blob);
1178: HR_UTILITY.TRACE('sqleerm ' || sqlerrm);
1179: HR_UTILITY.RAISE_ERROR;
1180:
1181: end create_xml_string;

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

1265: l_local_count_completed := 0;
1266: l_state_local_total_count := l_state_local_tab.count;
1267: l_state_local_count_completed := 0;
1268:
1269: l_is_temp_xml_string := dbms_lob.istemporary(l_xml_blob);
1270: hr_utility.trace('Istemporary(l_xml_blob) ' ||l_is_temp_xml_string );
1271:
1272: IF l_is_temp_xml_string = 1 THEN
1273: DBMS_LOB.FREETEMPORARY(l_xml_blob);

Line 1273: DBMS_LOB.FREETEMPORARY(l_xml_blob);

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

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

1272: IF l_is_temp_xml_string = 1 THEN
1273: DBMS_LOB.FREETEMPORARY(l_xml_blob);
1274: END IF;
1275:
1276: dbms_lob.createtemporary(l_xml_blob,false,DBMS_LOB.CALL);
1277: dbms_lob.open(l_xml_blob,dbms_lob.lob_readwrite);
1278:
1279: IF (l_b14_total_count = 0) AND
1280: (l_b12_total_count = 0) AND

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

1273: DBMS_LOB.FREETEMPORARY(l_xml_blob);
1274: END IF;
1275:
1276: dbms_lob.createtemporary(l_xml_blob,false,DBMS_LOB.CALL);
1277: dbms_lob.open(l_xml_blob,dbms_lob.lob_readwrite);
1278:
1279: IF (l_b14_total_count = 0) AND
1280: (l_b12_total_count = 0) AND
1281: --(l_sl_total_count = 0)

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

1281: --(l_sl_total_count = 0)
1282: (l_state_local_total_count = 0) THEN
1283:
1284: hr_utility.trace('In l_b14_total_count and other counts =0 ' );
1285: -- dbms_lob.append(l_final_xml,p_xml_string);
1286: l_xml_blob := create_xml_string(l_w2_fields,
1287: l_box14_codea,l_box14_meaninga,
1288: l_box14_codeb,l_box14_meaningb,
1289: l_box14_codec,l_box14_meaningc,

Line 1512: dbms_lob.getlength(l_out_create_xml));

1508: l_local2_wages,l_local2_tax,
1509: l_locality2,p_year);
1510:
1511: hr_utility.trace('After l_out_create_xml, length of LOB ' ||
1512: dbms_lob.getlength(l_out_create_xml));
1513: -- IF l_xml_string is not NULL and l_out_create_xml IS NOT NULL THEN
1514:
1515: dbms_lob.append(l_xml_blob,l_out_create_xml);
1516: hr_utility.trace('Length of l_xml_blob ' ||dbms_lob.getlength(l_xml_blob));

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

1511: hr_utility.trace('After l_out_create_xml, length of LOB ' ||
1512: dbms_lob.getlength(l_out_create_xml));
1513: -- IF l_xml_string is not NULL and l_out_create_xml IS NOT NULL THEN
1514:
1515: dbms_lob.append(l_xml_blob,l_out_create_xml);
1516: hr_utility.trace('Length of l_xml_blob ' ||dbms_lob.getlength(l_xml_blob));
1517:
1518: /* ELSE
1519: dbms_lob.writeappend(l_xml_string,dbms_lobamount,l_out_create_xml);;*/

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

1512: dbms_lob.getlength(l_out_create_xml));
1513: -- IF l_xml_string is not NULL and l_out_create_xml IS NOT NULL THEN
1514:
1515: dbms_lob.append(l_xml_blob,l_out_create_xml);
1516: hr_utility.trace('Length of l_xml_blob ' ||dbms_lob.getlength(l_xml_blob));
1517:
1518: /* ELSE
1519: dbms_lob.writeappend(l_xml_string,dbms_lobamount,l_out_create_xml);;*/
1520: -- END IF;

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

1515: dbms_lob.append(l_xml_blob,l_out_create_xml);
1516: hr_utility.trace('Length of l_xml_blob ' ||dbms_lob.getlength(l_xml_blob));
1517:
1518: /* ELSE
1519: dbms_lob.writeappend(l_xml_string,dbms_lobamount,l_out_create_xml);;*/
1520: -- END IF;
1521:
1522: END LOOP;
1523: END IF;

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

1524: --}
1525: END IF ; /* p_error_msg is null */
1526: hr_utility.trace('XML String is ');
1527:
1528: --hr_utility.trace(dbms_lob.substr(l_xml_string,,1));
1529:
1530: return l_xml_blob;
1531: EXCEPTION
1532: WHEN OTHERS then

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

1566: p_tax_unit_id ,
1567: p_year,
1568: p_error_msg , true);
1569:
1570: hr_utility.trace('dbms_lob.getlength(p_xml_blob) ' ||dbms_lob.getlength(p_xml_blob));
1571:
1572: IF p_error_msg IS NULL THEN
1573: hr_utility.trace('In final XML p_xml_string ');
1574: /* hr_utility.trace('XML String '||

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

1571:
1572: IF p_error_msg IS NULL THEN
1573: hr_utility.trace('In final XML p_xml_string ');
1574: /* hr_utility.trace('XML String '||
1575: dbms_lob.substr(p_xml_string,dbms_lob.getlength(p_xml_string),1));
1576: */
1577: l_final_xml_string :=
1578: ''|| EOL||
1579: ''||EOL||

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

1587: -- ''||EOL;
1588:
1589:
1590: hr_utility.trace('1. final 1. XML l_final_xml '||
1591: dbms_lob.substr(l_final_xml,dbms_lob.getlength(l_final_xml),1));
1592:
1593: l_last_xml_string := ''||EOL||
1594: -- ''||EOL||
1595: ''||EOL||

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

1599: ''||EOL||
1600: ''||EOL||
1601: '';
1602:
1603: l_is_temp_final_xml := dbms_lob.istemporary(l_final_xml);
1604: hr_utility.trace('Istemporary(l_xml_string) ' ||l_is_temp_final_xml );
1605:
1606: IF l_is_temp_final_xml = 1 THEN
1607: DBMS_LOB.FREETEMPORARY(l_final_xml);

Line 1607: DBMS_LOB.FREETEMPORARY(l_final_xml);

1603: l_is_temp_final_xml := dbms_lob.istemporary(l_final_xml);
1604: hr_utility.trace('Istemporary(l_xml_string) ' ||l_is_temp_final_xml );
1605:
1606: IF l_is_temp_final_xml = 1 THEN
1607: DBMS_LOB.FREETEMPORARY(l_final_xml);
1608: END IF;
1609:
1610: dbms_lob.createtemporary(l_final_xml,false,DBMS_LOB.CALL);
1611: dbms_lob.open(l_final_xml,dbms_lob.lob_readwrite);

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

1606: IF l_is_temp_final_xml = 1 THEN
1607: DBMS_LOB.FREETEMPORARY(l_final_xml);
1608: END IF;
1609:
1610: dbms_lob.createtemporary(l_final_xml,false,DBMS_LOB.CALL);
1611: dbms_lob.open(l_final_xml,dbms_lob.lob_readwrite);
1612: l_final_xml := append_to_lob(l_final_xml_string);
1613: --dbms_lob.writeappend(l_final_xml,length(l_final_xml_string),l_final_xml_string);
1614:

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

1607: DBMS_LOB.FREETEMPORARY(l_final_xml);
1608: END IF;
1609:
1610: dbms_lob.createtemporary(l_final_xml,false,DBMS_LOB.CALL);
1611: dbms_lob.open(l_final_xml,dbms_lob.lob_readwrite);
1612: l_final_xml := append_to_lob(l_final_xml_string);
1613: --dbms_lob.writeappend(l_final_xml,length(l_final_xml_string),l_final_xml_string);
1614:
1615: hr_utility.trace('Get Length l_final_xml ' ||dbms_lob.getlength(l_final_xml) );

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

1609:
1610: dbms_lob.createtemporary(l_final_xml,false,DBMS_LOB.CALL);
1611: dbms_lob.open(l_final_xml,dbms_lob.lob_readwrite);
1612: l_final_xml := append_to_lob(l_final_xml_string);
1613: --dbms_lob.writeappend(l_final_xml,length(l_final_xml_string),l_final_xml_string);
1614:
1615: hr_utility.trace('Get Length l_final_xml ' ||dbms_lob.getlength(l_final_xml) );
1616:
1617: dbms_lob.append(l_final_xml,p_xml_blob);

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

1611: dbms_lob.open(l_final_xml,dbms_lob.lob_readwrite);
1612: l_final_xml := append_to_lob(l_final_xml_string);
1613: --dbms_lob.writeappend(l_final_xml,length(l_final_xml_string),l_final_xml_string);
1614:
1615: hr_utility.trace('Get Length l_final_xml ' ||dbms_lob.getlength(l_final_xml) );
1616:
1617: dbms_lob.append(l_final_xml,p_xml_blob);
1618:
1619: --dbms_lob.writeappend(l_final_xml,length(l_last_xml_string),l_last_xml_string);

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

1613: --dbms_lob.writeappend(l_final_xml,length(l_final_xml_string),l_final_xml_string);
1614:
1615: hr_utility.trace('Get Length l_final_xml ' ||dbms_lob.getlength(l_final_xml) );
1616:
1617: dbms_lob.append(l_final_xml,p_xml_blob);
1618:
1619: --dbms_lob.writeappend(l_final_xml,length(l_last_xml_string),l_last_xml_string);
1620: dbms_lob.createtemporary(l_temp_blob,false,DBMS_LOB.CALL);
1621: dbms_lob.open(l_temp_blob,dbms_lob.lob_readwrite);

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

1615: hr_utility.trace('Get Length l_final_xml ' ||dbms_lob.getlength(l_final_xml) );
1616:
1617: dbms_lob.append(l_final_xml,p_xml_blob);
1618:
1619: --dbms_lob.writeappend(l_final_xml,length(l_last_xml_string),l_last_xml_string);
1620: dbms_lob.createtemporary(l_temp_blob,false,DBMS_LOB.CALL);
1621: dbms_lob.open(l_temp_blob,dbms_lob.lob_readwrite);
1622: l_temp_blob := append_to_lob(l_last_xml_string);
1623: dbms_lob.append(l_final_xml,l_temp_blob);

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

1616:
1617: dbms_lob.append(l_final_xml,p_xml_blob);
1618:
1619: --dbms_lob.writeappend(l_final_xml,length(l_last_xml_string),l_last_xml_string);
1620: dbms_lob.createtemporary(l_temp_blob,false,DBMS_LOB.CALL);
1621: dbms_lob.open(l_temp_blob,dbms_lob.lob_readwrite);
1622: l_temp_blob := append_to_lob(l_last_xml_string);
1623: dbms_lob.append(l_final_xml,l_temp_blob);
1624:

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

1617: dbms_lob.append(l_final_xml,p_xml_blob);
1618:
1619: --dbms_lob.writeappend(l_final_xml,length(l_last_xml_string),l_last_xml_string);
1620: dbms_lob.createtemporary(l_temp_blob,false,DBMS_LOB.CALL);
1621: dbms_lob.open(l_temp_blob,dbms_lob.lob_readwrite);
1622: l_temp_blob := append_to_lob(l_last_xml_string);
1623: dbms_lob.append(l_final_xml,l_temp_blob);
1624:
1625: /* Added ISOPEN condition for bug 3899583 */

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

1619: --dbms_lob.writeappend(l_final_xml,length(l_last_xml_string),l_last_xml_string);
1620: dbms_lob.createtemporary(l_temp_blob,false,DBMS_LOB.CALL);
1621: dbms_lob.open(l_temp_blob,dbms_lob.lob_readwrite);
1622: l_temp_blob := append_to_lob(l_last_xml_string);
1623: dbms_lob.append(l_final_xml,l_temp_blob);
1624:
1625: /* Added ISOPEN condition for bug 3899583 */
1626: IF DBMS_LOB.isopen(l_final_xml) = 1 THEN
1627: hr_utility.trace('Closing l_final_xml' );

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

1622: l_temp_blob := append_to_lob(l_last_xml_string);
1623: dbms_lob.append(l_final_xml,l_temp_blob);
1624:
1625: /* Added ISOPEN condition for bug 3899583 */
1626: IF DBMS_LOB.isopen(l_final_xml) = 1 THEN
1627: hr_utility.trace('Closing l_final_xml' );
1628: dbms_lob.close(l_final_xml);
1629: END IF;
1630: IF dbms_lob.ISOPEN(p_xml_blob)=1 THEN

Line 1628: dbms_lob.close(l_final_xml);

1624:
1625: /* Added ISOPEN condition for bug 3899583 */
1626: IF DBMS_LOB.isopen(l_final_xml) = 1 THEN
1627: hr_utility.trace('Closing l_final_xml' );
1628: dbms_lob.close(l_final_xml);
1629: END IF;
1630: IF dbms_lob.ISOPEN(p_xml_blob)=1 THEN
1631: hr_utility.trace('Closing p_xml_blob' );
1632: dbms_lob.close(p_xml_blob);

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

1626: IF DBMS_LOB.isopen(l_final_xml) = 1 THEN
1627: hr_utility.trace('Closing l_final_xml' );
1628: dbms_lob.close(l_final_xml);
1629: END IF;
1630: IF dbms_lob.ISOPEN(p_xml_blob)=1 THEN
1631: hr_utility.trace('Closing p_xml_blob' );
1632: dbms_lob.close(p_xml_blob);
1633: END IF;
1634: IF dbms_lob.ISOPEN(l_temp_blob)=1 THEN

Line 1632: dbms_lob.close(p_xml_blob);

1628: dbms_lob.close(l_final_xml);
1629: END IF;
1630: IF dbms_lob.ISOPEN(p_xml_blob)=1 THEN
1631: hr_utility.trace('Closing p_xml_blob' );
1632: dbms_lob.close(p_xml_blob);
1633: END IF;
1634: IF dbms_lob.ISOPEN(l_temp_blob)=1 THEN
1635: hr_utility.trace('Closing l_temp_blob' );
1636: dbms_lob.close(l_temp_blob);

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

1630: IF dbms_lob.ISOPEN(p_xml_blob)=1 THEN
1631: hr_utility.trace('Closing p_xml_blob' );
1632: dbms_lob.close(p_xml_blob);
1633: END IF;
1634: IF dbms_lob.ISOPEN(l_temp_blob)=1 THEN
1635: hr_utility.trace('Closing l_temp_blob' );
1636: dbms_lob.close(l_temp_blob);
1637: END IF;
1638: ELSE

Line 1636: dbms_lob.close(l_temp_blob);

1632: dbms_lob.close(p_xml_blob);
1633: END IF;
1634: IF dbms_lob.ISOPEN(l_temp_blob)=1 THEN
1635: hr_utility.trace('Closing l_temp_blob' );
1636: dbms_lob.close(l_temp_blob);
1637: END IF;
1638: ELSE
1639: dbms_lob.createtemporary(l_final_xml,false,DBMS_LOB.CALL);
1640: dbms_lob.open(l_final_xml,dbms_lob.lob_readwrite);

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

1635: hr_utility.trace('Closing l_temp_blob' );
1636: dbms_lob.close(l_temp_blob);
1637: END IF;
1638: ELSE
1639: dbms_lob.createtemporary(l_final_xml,false,DBMS_LOB.CALL);
1640: dbms_lob.open(l_final_xml,dbms_lob.lob_readwrite);
1641: l_final_xml := append_to_lob(p_error_msg);
1642:
1643: hr_utility.trace(' get final cml, p_error_msg '||p_error_msg);

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

1636: dbms_lob.close(l_temp_blob);
1637: END IF;
1638: ELSE
1639: dbms_lob.createtemporary(l_final_xml,false,DBMS_LOB.CALL);
1640: dbms_lob.open(l_final_xml,dbms_lob.lob_readwrite);
1641: l_final_xml := append_to_lob(p_error_msg);
1642:
1643: hr_utility.trace(' get final cml, p_error_msg '||p_error_msg);
1644:

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

1642:
1643: hr_utility.trace(' get final cml, p_error_msg '||p_error_msg);
1644:
1645: END IF ; /* p_error_msg is null */
1646: hr_utility.trace('dbms_lob.getlength(l_final_xml) ' ||dbms_lob.getlength(l_final_xml));
1647:
1648: return l_final_xml;
1649: EXCEPTION
1650: WHEN OTHERS then

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

1648: return l_final_xml;
1649: EXCEPTION
1650: WHEN OTHERS then
1651: /* Added ISOPEN condition for bug 3899583 */
1652: IF dbms_lob.ISOPEN(l_final_xml)=1 THEN
1653: hr_utility.trace('Raising exception and Closing l_final_xml' );
1654: dbms_lob.close(l_final_xml);
1655: END IF;
1656: IF dbms_lob.ISOPEN(p_xml_blob)=1 THEN

Line 1654: dbms_lob.close(l_final_xml);

1650: WHEN OTHERS then
1651: /* Added ISOPEN condition for bug 3899583 */
1652: IF dbms_lob.ISOPEN(l_final_xml)=1 THEN
1653: hr_utility.trace('Raising exception and Closing l_final_xml' );
1654: dbms_lob.close(l_final_xml);
1655: END IF;
1656: IF dbms_lob.ISOPEN(p_xml_blob)=1 THEN
1657: hr_utility.trace('Raising exception and Closing p_xml_string' );
1658: dbms_lob.close(p_xml_blob);

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

1652: IF dbms_lob.ISOPEN(l_final_xml)=1 THEN
1653: hr_utility.trace('Raising exception and Closing l_final_xml' );
1654: dbms_lob.close(l_final_xml);
1655: END IF;
1656: IF dbms_lob.ISOPEN(p_xml_blob)=1 THEN
1657: hr_utility.trace('Raising exception and Closing p_xml_string' );
1658: dbms_lob.close(p_xml_blob);
1659: END IF;
1660: IF dbms_lob.ISOPEN(l_temp_blob)=1 THEN

Line 1658: dbms_lob.close(p_xml_blob);

1654: dbms_lob.close(l_final_xml);
1655: END IF;
1656: IF dbms_lob.ISOPEN(p_xml_blob)=1 THEN
1657: hr_utility.trace('Raising exception and Closing p_xml_string' );
1658: dbms_lob.close(p_xml_blob);
1659: END IF;
1660: IF dbms_lob.ISOPEN(l_temp_blob)=1 THEN
1661: hr_utility.trace('Closing l_temp_blob' );
1662: dbms_lob.close(l_temp_blob);

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

1656: IF dbms_lob.ISOPEN(p_xml_blob)=1 THEN
1657: hr_utility.trace('Raising exception and Closing p_xml_string' );
1658: dbms_lob.close(p_xml_blob);
1659: END IF;
1660: IF dbms_lob.ISOPEN(l_temp_blob)=1 THEN
1661: hr_utility.trace('Closing l_temp_blob' );
1662: dbms_lob.close(l_temp_blob);
1663: END IF;
1664:

Line 1662: dbms_lob.close(l_temp_blob);

1658: dbms_lob.close(p_xml_blob);
1659: END IF;
1660: IF dbms_lob.ISOPEN(l_temp_blob)=1 THEN
1661: hr_utility.trace('Closing l_temp_blob' );
1662: dbms_lob.close(l_temp_blob);
1663: END IF;
1664:
1665:
1666: HR_UTILITY.TRACE('sqleerm ' || SQLERRM);

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

1747: l_tax_unit_id,
1748: l_year,
1749: l_error_msg, false);
1750: hr_utility.trace('XML String is ');
1751: IF ((dbms_lob.getlength(lc_emp_blob) >0) and (l_error_msg IS NULL) )THEN
1752:
1753: --hr_utility.trace(dbms_lob.substr(lc_emp_blob,dbms_lob.getlength(lc_emp_blob),1));
1754:
1755: l_final_xml_string :=

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

1749: l_error_msg, false);
1750: hr_utility.trace('XML String is ');
1751: IF ((dbms_lob.getlength(lc_emp_blob) >0) and (l_error_msg IS NULL) )THEN
1752:
1753: --hr_utility.trace(dbms_lob.substr(lc_emp_blob,dbms_lob.getlength(lc_emp_blob),1));
1754:
1755: l_final_xml_string :=
1756: ''|| EOL ||
1757: ''||EOL||

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

1776: ''||EOL||
1777: ''||EOL;
1778:
1779:
1780: l_is_temp_final_xml := dbms_lob.istemporary(l_final_xml);
1781: hr_utility.trace('Istemporary(l_xml_string) ' ||l_is_temp_final_xml );
1782:
1783: IF l_is_temp_final_xml = 1 THEN
1784: DBMS_LOB.FREETEMPORARY(l_final_xml);

Line 1784: DBMS_LOB.FREETEMPORARY(l_final_xml);

1780: l_is_temp_final_xml := dbms_lob.istemporary(l_final_xml);
1781: hr_utility.trace('Istemporary(l_xml_string) ' ||l_is_temp_final_xml );
1782:
1783: IF l_is_temp_final_xml = 1 THEN
1784: DBMS_LOB.FREETEMPORARY(l_final_xml);
1785: END IF;
1786:
1787: dbms_lob.createtemporary(l_final_xml,false,DBMS_LOB.CALL);
1788: dbms_lob.open(l_final_xml,dbms_lob.lob_readwrite);

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

1783: IF l_is_temp_final_xml = 1 THEN
1784: DBMS_LOB.FREETEMPORARY(l_final_xml);
1785: END IF;
1786:
1787: dbms_lob.createtemporary(l_final_xml,false,DBMS_LOB.CALL);
1788: dbms_lob.open(l_final_xml,dbms_lob.lob_readwrite);
1789:
1790: dbms_lob.createtemporary(l_temp_blob,false,DBMS_LOB.CALL);
1791: dbms_lob.open(l_temp_blob,dbms_lob.lob_readwrite);

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

1784: DBMS_LOB.FREETEMPORARY(l_final_xml);
1785: END IF;
1786:
1787: dbms_lob.createtemporary(l_final_xml,false,DBMS_LOB.CALL);
1788: dbms_lob.open(l_final_xml,dbms_lob.lob_readwrite);
1789:
1790: dbms_lob.createtemporary(l_temp_blob,false,DBMS_LOB.CALL);
1791: dbms_lob.open(l_temp_blob,dbms_lob.lob_readwrite);
1792:

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

1786:
1787: dbms_lob.createtemporary(l_final_xml,false,DBMS_LOB.CALL);
1788: dbms_lob.open(l_final_xml,dbms_lob.lob_readwrite);
1789:
1790: dbms_lob.createtemporary(l_temp_blob,false,DBMS_LOB.CALL);
1791: dbms_lob.open(l_temp_blob,dbms_lob.lob_readwrite);
1792:
1793: raw_data:=utl_raw.cast_to_raw(l_final_xml_string);
1794: text_size:=utl_raw.length(raw_data);

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

1787: dbms_lob.createtemporary(l_final_xml,false,DBMS_LOB.CALL);
1788: dbms_lob.open(l_final_xml,dbms_lob.lob_readwrite);
1789:
1790: dbms_lob.createtemporary(l_temp_blob,false,DBMS_LOB.CALL);
1791: dbms_lob.open(l_temp_blob,dbms_lob.lob_readwrite);
1792:
1793: raw_data:=utl_raw.cast_to_raw(l_final_xml_string);
1794: text_size:=utl_raw.length(raw_data);
1795:

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

1792:
1793: raw_data:=utl_raw.cast_to_raw(l_final_xml_string);
1794: text_size:=utl_raw.length(raw_data);
1795:
1796: -- dbms_lob.writeappend(l_final_xml,text_size,raw_data);
1797:
1798: /*dbms_lob.writeappend(l_final_xml,
1799: utl_raw.length(utl_raw.cast_to_raw(l_final_xml_string)),
1800: utl_raw.cast_to_raw(l_final_xml_string)

Line 1798: /*dbms_lob.writeappend(l_final_xml,

1794: text_size:=utl_raw.length(raw_data);
1795:
1796: -- dbms_lob.writeappend(l_final_xml,text_size,raw_data);
1797:
1798: /*dbms_lob.writeappend(l_final_xml,
1799: utl_raw.length(utl_raw.cast_to_raw(l_final_xml_string)),
1800: utl_raw.cast_to_raw(l_final_xml_string)
1801: );*/
1802: l_temp_blob := append_to_lob(l_final_xml_string);

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

1799: utl_raw.length(utl_raw.cast_to_raw(l_final_xml_string)),
1800: utl_raw.cast_to_raw(l_final_xml_string)
1801: );*/
1802: l_temp_blob := append_to_lob(l_final_xml_string);
1803: dbms_lob.append(l_final_xml,l_temp_blob);
1804:
1805: --dbms_lob.writeappend(l_final_xml,length(l_final_xml_string),l_final_xml_string);
1806:
1807: hr_utility.trace('Get Length l_final_xml ' ||dbms_lob.getlength(l_final_xml) );

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

1801: );*/
1802: l_temp_blob := append_to_lob(l_final_xml_string);
1803: dbms_lob.append(l_final_xml,l_temp_blob);
1804:
1805: --dbms_lob.writeappend(l_final_xml,length(l_final_xml_string),l_final_xml_string);
1806:
1807: hr_utility.trace('Get Length l_final_xml ' ||dbms_lob.getlength(l_final_xml) );
1808:
1809: dbms_lob.append(l_final_xml,lc_emp_blob);

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

1803: dbms_lob.append(l_final_xml,l_temp_blob);
1804:
1805: --dbms_lob.writeappend(l_final_xml,length(l_final_xml_string),l_final_xml_string);
1806:
1807: hr_utility.trace('Get Length l_final_xml ' ||dbms_lob.getlength(l_final_xml) );
1808:
1809: dbms_lob.append(l_final_xml,lc_emp_blob);
1810:
1811: raw_data:=utl_raw.cast_to_raw(l_last_xml_string);

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

1805: --dbms_lob.writeappend(l_final_xml,length(l_final_xml_string),l_final_xml_string);
1806:
1807: hr_utility.trace('Get Length l_final_xml ' ||dbms_lob.getlength(l_final_xml) );
1808:
1809: dbms_lob.append(l_final_xml,lc_emp_blob);
1810:
1811: raw_data:=utl_raw.cast_to_raw(l_last_xml_string);
1812: text_size:=utl_raw.length(raw_data);
1813:

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

1810:
1811: raw_data:=utl_raw.cast_to_raw(l_last_xml_string);
1812: text_size:=utl_raw.length(raw_data);
1813:
1814: --dbms_lob.writeappend(l_final_xml,text_size,raw_data);
1815:
1816: /*dbms_lob.writeappend(l_final_xml,
1817: utl_raw.length(utl_raw.cast_to_raw(l_last_xml_string)),
1818: utl_raw.cast_to_raw(l_last_xml_string)

Line 1816: /*dbms_lob.writeappend(l_final_xml,

1812: text_size:=utl_raw.length(raw_data);
1813:
1814: --dbms_lob.writeappend(l_final_xml,text_size,raw_data);
1815:
1816: /*dbms_lob.writeappend(l_final_xml,
1817: utl_raw.length(utl_raw.cast_to_raw(l_last_xml_string)),
1818: utl_raw.cast_to_raw(l_last_xml_string)
1819: );*/
1820:

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

1819: );*/
1820:
1821:
1822: l_temp_blob := append_to_lob(l_last_xml_string);
1823: dbms_lob.append(l_final_xml,l_temp_blob);
1824: --dbms_lob.writeappend(l_final_xml,length(l_last_xml_string),l_last_xml_string);
1825:
1826: IF DBMS_LOB.isopen(l_final_xml) = 1 THEN
1827: hr_utility.trace('Closing l_final_xml' );

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

1820:
1821:
1822: l_temp_blob := append_to_lob(l_last_xml_string);
1823: dbms_lob.append(l_final_xml,l_temp_blob);
1824: --dbms_lob.writeappend(l_final_xml,length(l_last_xml_string),l_last_xml_string);
1825:
1826: IF DBMS_LOB.isopen(l_final_xml) = 1 THEN
1827: hr_utility.trace('Closing l_final_xml' );
1828: dbms_lob.close(l_final_xml);

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

1822: l_temp_blob := append_to_lob(l_last_xml_string);
1823: dbms_lob.append(l_final_xml,l_temp_blob);
1824: --dbms_lob.writeappend(l_final_xml,length(l_last_xml_string),l_last_xml_string);
1825:
1826: IF DBMS_LOB.isopen(l_final_xml) = 1 THEN
1827: hr_utility.trace('Closing l_final_xml' );
1828: dbms_lob.close(l_final_xml);
1829: END IF;
1830: IF dbms_lob.ISOPEN(lc_emp_blob)=1 THEN

Line 1828: dbms_lob.close(l_final_xml);

1824: --dbms_lob.writeappend(l_final_xml,length(l_last_xml_string),l_last_xml_string);
1825:
1826: IF DBMS_LOB.isopen(l_final_xml) = 1 THEN
1827: hr_utility.trace('Closing l_final_xml' );
1828: dbms_lob.close(l_final_xml);
1829: END IF;
1830: IF dbms_lob.ISOPEN(lc_emp_blob)=1 THEN
1831: hr_utility.trace('Closing lc_emp_blob' );
1832: dbms_lob.close(lc_emp_blob);

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

1826: IF DBMS_LOB.isopen(l_final_xml) = 1 THEN
1827: hr_utility.trace('Closing l_final_xml' );
1828: dbms_lob.close(l_final_xml);
1829: END IF;
1830: IF dbms_lob.ISOPEN(lc_emp_blob)=1 THEN
1831: hr_utility.trace('Closing lc_emp_blob' );
1832: dbms_lob.close(lc_emp_blob);
1833: END IF;
1834: IF dbms_lob.ISOPEN(l_temp_blob)=1 THEN

Line 1832: dbms_lob.close(lc_emp_blob);

1828: dbms_lob.close(l_final_xml);
1829: END IF;
1830: IF dbms_lob.ISOPEN(lc_emp_blob)=1 THEN
1831: hr_utility.trace('Closing lc_emp_blob' );
1832: dbms_lob.close(lc_emp_blob);
1833: END IF;
1834: IF dbms_lob.ISOPEN(l_temp_blob)=1 THEN
1835: hr_utility.trace('Closing l_temp_blob' );
1836: dbms_lob.close(l_temp_blob);

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

1830: IF dbms_lob.ISOPEN(lc_emp_blob)=1 THEN
1831: hr_utility.trace('Closing lc_emp_blob' );
1832: dbms_lob.close(lc_emp_blob);
1833: END IF;
1834: IF dbms_lob.ISOPEN(l_temp_blob)=1 THEN
1835: hr_utility.trace('Closing l_temp_blob' );
1836: dbms_lob.close(l_temp_blob);
1837: END IF;
1838:

Line 1836: dbms_lob.close(l_temp_blob);

1832: dbms_lob.close(lc_emp_blob);
1833: END IF;
1834: IF dbms_lob.ISOPEN(l_temp_blob)=1 THEN
1835: hr_utility.trace('Closing l_temp_blob' );
1836: dbms_lob.close(l_temp_blob);
1837: END IF;
1838:
1839: hr_utility.trace('dbms_lob.getlength(l_final_xml) ' ||dbms_lob.getlength(l_final_xml));
1840:

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

1835: hr_utility.trace('Closing l_temp_blob' );
1836: dbms_lob.close(l_temp_blob);
1837: END IF;
1838:
1839: hr_utility.trace('dbms_lob.getlength(l_final_xml) ' ||dbms_lob.getlength(l_final_xml));
1840:
1841: pay_core_files.write_to_magtape_lob(l_final_xml);
1842: -- hr_utility.trace('Length of pay_mag_tape.g_clob_value ' ||dbms_lob.getlength(pay_mag_tape.g_clob_value));
1843:

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

1838:
1839: hr_utility.trace('dbms_lob.getlength(l_final_xml) ' ||dbms_lob.getlength(l_final_xml));
1840:
1841: pay_core_files.write_to_magtape_lob(l_final_xml);
1842: -- hr_utility.trace('Length of pay_mag_tape.g_clob_value ' ||dbms_lob.getlength(pay_mag_tape.g_clob_value));
1843:
1844: END IF; /*dbms_lob.getlength(lc_emp_blob) >0*/
1845: -- l_is_temp_xml_string := dbms_lob.istemporary(pay_mag_tape.g_clob_value);
1846:

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

1840:
1841: pay_core_files.write_to_magtape_lob(l_final_xml);
1842: -- hr_utility.trace('Length of pay_mag_tape.g_clob_value ' ||dbms_lob.getlength(pay_mag_tape.g_clob_value));
1843:
1844: END IF; /*dbms_lob.getlength(lc_emp_blob) >0*/
1845: -- l_is_temp_xml_string := dbms_lob.istemporary(pay_mag_tape.g_clob_value);
1846:
1847: EXCEPTION
1848: WHEN OTHERS then

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

1841: pay_core_files.write_to_magtape_lob(l_final_xml);
1842: -- hr_utility.trace('Length of pay_mag_tape.g_clob_value ' ||dbms_lob.getlength(pay_mag_tape.g_clob_value));
1843:
1844: END IF; /*dbms_lob.getlength(lc_emp_blob) >0*/
1845: -- l_is_temp_xml_string := dbms_lob.istemporary(pay_mag_tape.g_clob_value);
1846:
1847: EXCEPTION
1848: WHEN OTHERS then
1849: /* Added ISOPEN condition for bug 3899583 */

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

1846:
1847: EXCEPTION
1848: WHEN OTHERS then
1849: /* Added ISOPEN condition for bug 3899583 */
1850: IF dbms_lob.ISOPEN(l_final_xml)=1 THEN
1851: hr_utility.trace('Raising exception and Closing l_final_xml' ||sqlerrm);
1852: dbms_lob.close(l_final_xml);
1853: END IF;
1854: IF dbms_lob.ISOPEN(lc_emp_blob)=1 THEN

Line 1852: dbms_lob.close(l_final_xml);

1848: WHEN OTHERS then
1849: /* Added ISOPEN condition for bug 3899583 */
1850: IF dbms_lob.ISOPEN(l_final_xml)=1 THEN
1851: hr_utility.trace('Raising exception and Closing l_final_xml' ||sqlerrm);
1852: dbms_lob.close(l_final_xml);
1853: END IF;
1854: IF dbms_lob.ISOPEN(lc_emp_blob)=1 THEN
1855: hr_utility.trace('Raising exception and Closing p_xml_string' );
1856: dbms_lob.close(lc_emp_blob);

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

1850: IF dbms_lob.ISOPEN(l_final_xml)=1 THEN
1851: hr_utility.trace('Raising exception and Closing l_final_xml' ||sqlerrm);
1852: dbms_lob.close(l_final_xml);
1853: END IF;
1854: IF dbms_lob.ISOPEN(lc_emp_blob)=1 THEN
1855: hr_utility.trace('Raising exception and Closing p_xml_string' );
1856: dbms_lob.close(lc_emp_blob);
1857: END IF;
1858: IF dbms_lob.ISOPEN(l_temp_blob)=1 THEN

Line 1856: dbms_lob.close(lc_emp_blob);

1852: dbms_lob.close(l_final_xml);
1853: END IF;
1854: IF dbms_lob.ISOPEN(lc_emp_blob)=1 THEN
1855: hr_utility.trace('Raising exception and Closing p_xml_string' );
1856: dbms_lob.close(lc_emp_blob);
1857: END IF;
1858: IF dbms_lob.ISOPEN(l_temp_blob)=1 THEN
1859: hr_utility.trace('Closing l_temp_blob' );
1860: dbms_lob.close(l_temp_blob);

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

1854: IF dbms_lob.ISOPEN(lc_emp_blob)=1 THEN
1855: hr_utility.trace('Raising exception and Closing p_xml_string' );
1856: dbms_lob.close(lc_emp_blob);
1857: END IF;
1858: IF dbms_lob.ISOPEN(l_temp_blob)=1 THEN
1859: hr_utility.trace('Closing l_temp_blob' );
1860: dbms_lob.close(l_temp_blob);
1861: END IF;
1862:

Line 1860: dbms_lob.close(l_temp_blob);

1856: dbms_lob.close(lc_emp_blob);
1857: END IF;
1858: IF dbms_lob.ISOPEN(l_temp_blob)=1 THEN
1859: hr_utility.trace('Closing l_temp_blob' );
1860: dbms_lob.close(l_temp_blob);
1861: END IF;
1862:
1863: HR_UTILITY.TRACE('sqleerm ' || SQLERRM);
1864: raise;

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

1872: BEGIN
1873: EOL := fnd_global.local_chr(13)||fnd_global.local_chr(10);
1874: l_last_xml_string :=
1875: ''||EOL;
1876: l_is_temp_final_xml := dbms_lob.istemporary(l_footer_xml);
1877: hr_utility.trace('Istemporary(l_footer_xml) ' ||l_is_temp_final_xml );
1878:
1879: IF l_is_temp_final_xml = 1 THEN
1880: DBMS_LOB.FREETEMPORARY(l_footer_xml);

Line 1880: DBMS_LOB.FREETEMPORARY(l_footer_xml);

1876: l_is_temp_final_xml := dbms_lob.istemporary(l_footer_xml);
1877: hr_utility.trace('Istemporary(l_footer_xml) ' ||l_is_temp_final_xml );
1878:
1879: IF l_is_temp_final_xml = 1 THEN
1880: DBMS_LOB.FREETEMPORARY(l_footer_xml);
1881: END IF;
1882:
1883: dbms_lob.createtemporary(l_footer_xml,false,DBMS_LOB.CALL);
1884: dbms_lob.open(l_footer_xml,dbms_lob.lob_readwrite);

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

1879: IF l_is_temp_final_xml = 1 THEN
1880: DBMS_LOB.FREETEMPORARY(l_footer_xml);
1881: END IF;
1882:
1883: dbms_lob.createtemporary(l_footer_xml,false,DBMS_LOB.CALL);
1884: dbms_lob.open(l_footer_xml,dbms_lob.lob_readwrite);
1885: dbms_lob.writeappend(l_footer_xml,length(l_last_xml_string),l_last_xml_string);
1886:
1887: hr_utility.trace('In Get footers,Length of length(l_footer_xml) ' ||dbms_lob.getlength(l_footer_xml));

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

1880: DBMS_LOB.FREETEMPORARY(l_footer_xml);
1881: END IF;
1882:
1883: dbms_lob.createtemporary(l_footer_xml,false,DBMS_LOB.CALL);
1884: dbms_lob.open(l_footer_xml,dbms_lob.lob_readwrite);
1885: dbms_lob.writeappend(l_footer_xml,length(l_last_xml_string),l_last_xml_string);
1886:
1887: hr_utility.trace('In Get footers,Length of length(l_footer_xml) ' ||dbms_lob.getlength(l_footer_xml));
1888:

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

1881: END IF;
1882:
1883: dbms_lob.createtemporary(l_footer_xml,false,DBMS_LOB.CALL);
1884: dbms_lob.open(l_footer_xml,dbms_lob.lob_readwrite);
1885: dbms_lob.writeappend(l_footer_xml,length(l_last_xml_string),l_last_xml_string);
1886:
1887: hr_utility.trace('In Get footers,Length of length(l_footer_xml) ' ||dbms_lob.getlength(l_footer_xml));
1888:
1889: --dbms_lob.append(pay_mag_tape.g_clob_value,l_footer_xml);

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

1883: dbms_lob.createtemporary(l_footer_xml,false,DBMS_LOB.CALL);
1884: dbms_lob.open(l_footer_xml,dbms_lob.lob_readwrite);
1885: dbms_lob.writeappend(l_footer_xml,length(l_last_xml_string),l_last_xml_string);
1886:
1887: hr_utility.trace('In Get footers,Length of length(l_footer_xml) ' ||dbms_lob.getlength(l_footer_xml));
1888:
1889: --dbms_lob.append(pay_mag_tape.g_clob_value,l_footer_xml);
1890: pay_core_files.write_to_magtape_lob(l_last_xml_string);
1891: --pay_core_files.write_to_magtape_lob(dbms_lob.substr(l_footer_xml,dbms_lob.getlength(l_footer_xml),1));

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

1885: dbms_lob.writeappend(l_footer_xml,length(l_last_xml_string),l_last_xml_string);
1886:
1887: hr_utility.trace('In Get footers,Length of length(l_footer_xml) ' ||dbms_lob.getlength(l_footer_xml));
1888:
1889: --dbms_lob.append(pay_mag_tape.g_clob_value,l_footer_xml);
1890: pay_core_files.write_to_magtape_lob(l_last_xml_string);
1891: --pay_core_files.write_to_magtape_lob(dbms_lob.substr(l_footer_xml,dbms_lob.getlength(l_footer_xml),1));
1892:
1893: --hr_utility.trace('In Get footers,Length of pay_mag_tape.g_clob_value ' ||dbms_lob.getlength(pay_mag_tape.g_clob_value));

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

1887: hr_utility.trace('In Get footers,Length of length(l_footer_xml) ' ||dbms_lob.getlength(l_footer_xml));
1888:
1889: --dbms_lob.append(pay_mag_tape.g_clob_value,l_footer_xml);
1890: pay_core_files.write_to_magtape_lob(l_last_xml_string);
1891: --pay_core_files.write_to_magtape_lob(dbms_lob.substr(l_footer_xml,dbms_lob.getlength(l_footer_xml),1));
1892:
1893: --hr_utility.trace('In Get footers,Length of pay_mag_tape.g_clob_value ' ||dbms_lob.getlength(pay_mag_tape.g_clob_value));
1894: END;
1895:

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

1889: --dbms_lob.append(pay_mag_tape.g_clob_value,l_footer_xml);
1890: pay_core_files.write_to_magtape_lob(l_last_xml_string);
1891: --pay_core_files.write_to_magtape_lob(dbms_lob.substr(l_footer_xml,dbms_lob.getlength(l_footer_xml),1));
1892:
1893: --hr_utility.trace('In Get footers,Length of pay_mag_tape.g_clob_value ' ||dbms_lob.getlength(pay_mag_tape.g_clob_value));
1894: END;
1895:
1896: PROCEDURE get_headers IS
1897:

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

1903: l_final_xml_string :=
1904: ''|| EOL||
1905: ''||EOL;
1906:
1907: l_is_temp_final_xml := dbms_lob.istemporary(l_final_xml);
1908: hr_utility.trace('Istemporary(l_final_xml) ' ||l_is_temp_final_xml );
1909:
1910: IF l_is_temp_final_xml = 1 THEN
1911: DBMS_LOB.FREETEMPORARY(l_final_xml);

Line 1911: DBMS_LOB.FREETEMPORARY(l_final_xml);

1907: l_is_temp_final_xml := dbms_lob.istemporary(l_final_xml);
1908: hr_utility.trace('Istemporary(l_final_xml) ' ||l_is_temp_final_xml );
1909:
1910: IF l_is_temp_final_xml = 1 THEN
1911: DBMS_LOB.FREETEMPORARY(l_final_xml);
1912: END IF;
1913:
1914: dbms_lob.createtemporary(l_final_xml,false,DBMS_LOB.CALL);
1915: dbms_lob.open(l_final_xml,dbms_lob.lob_readwrite);

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

1910: IF l_is_temp_final_xml = 1 THEN
1911: DBMS_LOB.FREETEMPORARY(l_final_xml);
1912: END IF;
1913:
1914: dbms_lob.createtemporary(l_final_xml,false,DBMS_LOB.CALL);
1915: dbms_lob.open(l_final_xml,dbms_lob.lob_readwrite);
1916: dbms_lob.writeappend(l_final_xml,length(l_final_xml_string),l_final_xml_string);
1917: --dbms_lob.append(pay_mag_tape.g_clob_value,l_final_xml);
1918: pay_core_files.write_to_magtape_lob(l_final_xml_string);

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

1911: DBMS_LOB.FREETEMPORARY(l_final_xml);
1912: END IF;
1913:
1914: dbms_lob.createtemporary(l_final_xml,false,DBMS_LOB.CALL);
1915: dbms_lob.open(l_final_xml,dbms_lob.lob_readwrite);
1916: dbms_lob.writeappend(l_final_xml,length(l_final_xml_string),l_final_xml_string);
1917: --dbms_lob.append(pay_mag_tape.g_clob_value,l_final_xml);
1918: pay_core_files.write_to_magtape_lob(l_final_xml_string);
1919: --pay_core_files.write_to_magtape_lob(dbms_lob.substr(l_final_xml_string,dbms_lob.getlength(l_final_xml_string),1));

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

1912: END IF;
1913:
1914: dbms_lob.createtemporary(l_final_xml,false,DBMS_LOB.CALL);
1915: dbms_lob.open(l_final_xml,dbms_lob.lob_readwrite);
1916: dbms_lob.writeappend(l_final_xml,length(l_final_xml_string),l_final_xml_string);
1917: --dbms_lob.append(pay_mag_tape.g_clob_value,l_final_xml);
1918: pay_core_files.write_to_magtape_lob(l_final_xml_string);
1919: --pay_core_files.write_to_magtape_lob(dbms_lob.substr(l_final_xml_string,dbms_lob.getlength(l_final_xml_string),1));
1920: --hr_utility.trace('Length of pay_mag_tape.g_clob_value ' ||dbms_lob.getlength(pay_mag_tape.g_clob_value));

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

1913:
1914: dbms_lob.createtemporary(l_final_xml,false,DBMS_LOB.CALL);
1915: dbms_lob.open(l_final_xml,dbms_lob.lob_readwrite);
1916: dbms_lob.writeappend(l_final_xml,length(l_final_xml_string),l_final_xml_string);
1917: --dbms_lob.append(pay_mag_tape.g_clob_value,l_final_xml);
1918: pay_core_files.write_to_magtape_lob(l_final_xml_string);
1919: --pay_core_files.write_to_magtape_lob(dbms_lob.substr(l_final_xml_string,dbms_lob.getlength(l_final_xml_string),1));
1920: --hr_utility.trace('Length of pay_mag_tape.g_clob_value ' ||dbms_lob.getlength(pay_mag_tape.g_clob_value));
1921: END;

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

1915: dbms_lob.open(l_final_xml,dbms_lob.lob_readwrite);
1916: dbms_lob.writeappend(l_final_xml,length(l_final_xml_string),l_final_xml_string);
1917: --dbms_lob.append(pay_mag_tape.g_clob_value,l_final_xml);
1918: pay_core_files.write_to_magtape_lob(l_final_xml_string);
1919: --pay_core_files.write_to_magtape_lob(dbms_lob.substr(l_final_xml_string,dbms_lob.getlength(l_final_xml_string),1));
1920: --hr_utility.trace('Length of pay_mag_tape.g_clob_value ' ||dbms_lob.getlength(pay_mag_tape.g_clob_value));
1921: END;
1922:
1923: function get_outfile return VARCHAR2 is

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

1916: dbms_lob.writeappend(l_final_xml,length(l_final_xml_string),l_final_xml_string);
1917: --dbms_lob.append(pay_mag_tape.g_clob_value,l_final_xml);
1918: pay_core_files.write_to_magtape_lob(l_final_xml_string);
1919: --pay_core_files.write_to_magtape_lob(dbms_lob.substr(l_final_xml_string,dbms_lob.getlength(l_final_xml_string),1));
1920: --hr_utility.trace('Length of pay_mag_tape.g_clob_value ' ||dbms_lob.getlength(pay_mag_tape.g_clob_value));
1921: END;
1922:
1923: function get_outfile return VARCHAR2 is
1924: TEMP_UTL varchar2(512);