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.CLN_RN_UTILS dependencies on DBMS_LOB

Line 844: l_ini_pos := dbms_lob.instr(l_xmlDoc, '!DOCTYPE ');

840: END IF;
841: l_eventmsg := wf_engine.getActivityAttrEvent(p_itemtype, p_itemkey, p_actid, 'CLN_EVENT_MESSAGE');
842: l_xmlDoc := l_eventmsg.getEventData;
843: l_ini_pos := -1;
844: l_ini_pos := dbms_lob.instr(l_xmlDoc, '!DOCTYPE ');
845: IF (l_Debug_Level <= 1) THEN
846: cln_debug_pub.Add('Init Position:' || l_ini_pos, 1);
847: END IF;
848: IF (l_ini_pos > 0) THEN

Line 849: l_fin_pos := dbms_lob.instr(l_xmlDoc, '>', l_ini_pos);

845: IF (l_Debug_Level <= 1) THEN
846: cln_debug_pub.Add('Init Position:' || l_ini_pos, 1);
847: END IF;
848: IF (l_ini_pos > 0) THEN
849: l_fin_pos := dbms_lob.instr(l_xmlDoc, '>', l_ini_pos);
850: l_fin_pos := l_fin_pos + 1;
851: l_amount := dbms_lob.getlength(l_xmlDoc);
852: IF (l_Debug_Level <= 1) THEN
853: cln_debug_pub.Add('Final Position:' || l_fin_pos, 1);

Line 851: l_amount := dbms_lob.getlength(l_xmlDoc);

847: END IF;
848: IF (l_ini_pos > 0) THEN
849: l_fin_pos := dbms_lob.instr(l_xmlDoc, '>', l_ini_pos);
850: l_fin_pos := l_fin_pos + 1;
851: l_amount := dbms_lob.getlength(l_xmlDoc);
852: IF (l_Debug_Level <= 1) THEN
853: cln_debug_pub.Add('Final Position:' || l_fin_pos, 1);
854: cln_debug_pub.Add('Length:' || l_amount, 1);
855: END IF;

Line 856: DBMS_LOB.CREATETEMPORARY(l_payload, TRUE, DBMS_LOB.SESSION);

852: IF (l_Debug_Level <= 1) THEN
853: cln_debug_pub.Add('Final Position:' || l_fin_pos, 1);
854: cln_debug_pub.Add('Length:' || l_amount, 1);
855: END IF;
856: DBMS_LOB.CREATETEMPORARY(l_payload, TRUE, DBMS_LOB.SESSION);
857: dbms_lob.copy(l_payload, l_xmlDoc, l_amount - l_fin_pos + 10, 1, l_fin_pos);
858: END IF;
859: l_parser := xmlparser.newparser;
860: xmlparser.setValidationMode(l_parser,FALSE);

Line 857: dbms_lob.copy(l_payload, l_xmlDoc, l_amount - l_fin_pos + 10, 1, l_fin_pos);

853: cln_debug_pub.Add('Final Position:' || l_fin_pos, 1);
854: cln_debug_pub.Add('Length:' || l_amount, 1);
855: END IF;
856: DBMS_LOB.CREATETEMPORARY(l_payload, TRUE, DBMS_LOB.SESSION);
857: dbms_lob.copy(l_payload, l_xmlDoc, l_amount - l_fin_pos + 10, 1, l_fin_pos);
858: END IF;
859: l_parser := xmlparser.newparser;
860: xmlparser.setValidationMode(l_parser,FALSE);
861: xmlparser.showWarnings(l_parser,FALSE);

Line 956: DBMS_LOB.FREETEMPORARY(l_payload);

952: END IF;
953: l_error_message := l_msg_data;
954: END;
955: IF (l_ini_pos > 0) THEN
956: DBMS_LOB.FREETEMPORARY(l_payload);
957: END IF;
958: xmlparser.freeparser(l_parser);
959: IF (l_Debug_Level <= 2) THEN
960: cln_debug_pub.Add('EXITING VALIDATE_XML normally', 2);

Line 1280: l_ini_pos := dbms_lob.instr(l_xmlDoc, '!DOCTYPE ');

1276:
1277: SELECT payload into l_xmlDoc FROM ecx_doclogs WHERE internal_control_number = p_internal_control_num;
1278:
1279: l_ini_pos := -1;
1280: l_ini_pos := dbms_lob.instr(l_xmlDoc, '!DOCTYPE ');
1281: IF (l_Debug_Level <= 2) THEN
1282: cln_debug_pub.Add('Init Position:' || l_ini_pos, 1);
1283: END IF;
1284:

Line 1286: l_fin_pos := dbms_lob.instr(l_xmlDoc, '>', l_ini_pos);

1282: cln_debug_pub.Add('Init Position:' || l_ini_pos, 1);
1283: END IF;
1284:
1285: IF (l_ini_pos > 0) THEN
1286: l_fin_pos := dbms_lob.instr(l_xmlDoc, '>', l_ini_pos);
1287: l_fin_pos := l_fin_pos + 1;
1288: l_amount := dbms_lob.getlength(l_xmlDoc);
1289:
1290: IF (l_Debug_Level <= 2) THEN

Line 1288: l_amount := dbms_lob.getlength(l_xmlDoc);

1284:
1285: IF (l_ini_pos > 0) THEN
1286: l_fin_pos := dbms_lob.instr(l_xmlDoc, '>', l_ini_pos);
1287: l_fin_pos := l_fin_pos + 1;
1288: l_amount := dbms_lob.getlength(l_xmlDoc);
1289:
1290: IF (l_Debug_Level <= 2) THEN
1291: cln_debug_pub.Add('Final Position:' || l_fin_pos, 1);
1292: cln_debug_pub.Add('Length:' || l_amount, 1);

Line 1295: DBMS_LOB.CREATETEMPORARY(l_payload, TRUE, DBMS_LOB.SESSION);

1291: cln_debug_pub.Add('Final Position:' || l_fin_pos, 1);
1292: cln_debug_pub.Add('Length:' || l_amount, 1);
1293: END IF;
1294:
1295: DBMS_LOB.CREATETEMPORARY(l_payload, TRUE, DBMS_LOB.SESSION);
1296:
1297: dbms_lob.copy(l_payload, l_xmlDoc, l_amount - l_fin_pos + 10, 1, l_fin_pos);
1298:
1299: END IF;

Line 1297: dbms_lob.copy(l_payload, l_xmlDoc, l_amount - l_fin_pos + 10, 1, l_fin_pos);

1293: END IF;
1294:
1295: DBMS_LOB.CREATETEMPORARY(l_payload, TRUE, DBMS_LOB.SESSION);
1296:
1297: dbms_lob.copy(l_payload, l_xmlDoc, l_amount - l_fin_pos + 10, 1, l_fin_pos);
1298:
1299: END IF;
1300:
1301: l_parser := xmlparser.newparser;

Line 1363: DBMS_LOB.FREETEMPORARY(l_payload);

1359: END IF;
1360: END;
1361:
1362: IF (l_ini_pos > 0) THEN
1363: DBMS_LOB.FREETEMPORARY(l_payload);
1364: END IF;
1365: xmlparser.freeparser(l_parser);
1366:
1367: IF (l_Debug_Level <= 5) THEN