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

Line 1363: select fl.file_name, dbms_lob.getlength(fl.file_data)

1359: /*End Changes by Akyanama Bug # 12969112*/
1360: -- bug4931216
1361: -- Join directly to the base table to improve performance
1362: cursor l_get_po_attachments_csr(l_po_header_id number) is
1363: select fl.file_name, dbms_lob.getlength(fl.file_data)
1364: from fnd_documents d,
1365: fnd_attached_documents ad,
1366: fnd_doc_category_usages dcu,
1367: fnd_attachment_functions af,

Line 1406: group by fl.file_name, dbms_lob.getlength(fl.file_data)

1402: and d.datatype_id = 6
1403: and af.function_name = 'PO_PRINTPO'
1404: and d.media_id = fl.file_id
1405: and dcu.enabled_flag = 'Y'
1406: group by fl.file_name, dbms_lob.getlength(fl.file_data)
1407: order by fl.file_name;
1408:
1409: -- bug4931216
1410: -- Join directly to the base table to improve performance

Line 1412: select fl.file_name, dbms_lob.getlength(fl.file_data)

1408:
1409: -- bug4931216
1410: -- Join directly to the base table to improve performance
1411: cursor l_get_release_attachments_csr(l_po_release_id number) is
1412: select fl.file_name, dbms_lob.getlength(fl.file_data)
1413: from fnd_documents d,
1414: fnd_attached_documents ad,
1415: fnd_doc_category_usages dcu,
1416: fnd_attachment_functions af,

Line 1456: group by fl.file_name, dbms_lob.getlength(fl.file_data)

1452: and d.datatype_id = 6
1453: and af.function_name = 'PO_PRINTPO'
1454: and d.media_id = fl.file_id
1455: and dcu.enabled_flag = 'Y'
1456: group by fl.file_name, dbms_lob.getlength(fl.file_data)
1457: order by fl.file_name;
1458: --
1459:
1460: begin

Line 3651: l_document_length := dbms_lob.GetLength(l_document);

3647: and fad.entity_name = 'OKC_CONTRACT_DOCS'
3648: and fdl.language = l_language
3649: and fl.file_name = l_filename ;
3650: END;
3651: l_document_length := dbms_lob.GetLength(l_document);
3652: IF (g_po_wf_debug = 'Y') THEN
3653: PO_WF_DEBUG_PKG.INSERT_DEBUG(l_itemtype, l_itemkey, 'Document Length : '||l_document_length);
3654: END IF;
3655: dbms_lob.copy(document, l_document, l_document_length, 1, 1);

Line 3655: dbms_lob.copy(document, l_document, l_document_length, 1, 1);

3651: l_document_length := dbms_lob.GetLength(l_document);
3652: IF (g_po_wf_debug = 'Y') THEN
3653: PO_WF_DEBUG_PKG.INSERT_DEBUG(l_itemtype, l_itemkey, 'Document Length : '||l_document_length);
3654: END IF;
3655: dbms_lob.copy(document, l_document, l_document_length, 1, 1);
3656:
3657: document_type :='application/pdf; name='|| l_filename;
3658:
3659: EXCEPTION

Line 3672: DBMS_LOB.write(document, lengthb(l_message), 1, UTL_RAW.cast_to_raw(l_message));

3668:
3669: --Bug#3274081 Display the message to the user incase the pdf fails.
3670: document_type :='text/html; name='|| l_filename;
3671: l_message := fnd_message.get_string('PO', 'PO_PDF_FAILED');
3672: DBMS_LOB.write(document, lengthb(l_message), 1, UTL_RAW.cast_to_raw(l_message));
3673:
3674: END pdf_attach_app;
3675:
3676: -- Bug 3823799. Recoded following procedure. This procedure is to

Line 3774: l_document_length := dbms_lob.GetLength(l_document);

3770: and fad.entity_name = l_entity_name and fl.file_name = l_filename and fdl.language = l_language and rownum = 1;
3771: -- Bug 10410956 ;
3772: END IF;
3773:
3774: l_document_length := dbms_lob.GetLength(l_document);
3775: dbms_lob.copy(document, l_document, l_document_length, 1, 1);
3776: document_type :='application/pdf; name='|| l_filename;
3777:
3778: EXCEPTION

Line 3775: dbms_lob.copy(document, l_document, l_document_length, 1, 1);

3771: -- Bug 10410956 ;
3772: END IF;
3773:
3774: l_document_length := dbms_lob.GetLength(l_document);
3775: dbms_lob.copy(document, l_document, l_document_length, 1, 1);
3776: document_type :='application/pdf; name='|| l_filename;
3777:
3778: EXCEPTION
3779: WHEN OTHERS THEN

Line 3791: DBMS_LOB.write(document, lengthb(l_message), 1, UTL_RAW.cast_to_raw(l_message));

3787: -- Bug 4047688
3788: -- Removed concatenation of l_filename from document_type
3789: document_type := 'text/html';
3790: l_message := fnd_message.get_string('PO', 'PO_PDF_FAILED');
3791: DBMS_LOB.write(document, lengthb(l_message), 1, UTL_RAW.cast_to_raw(l_message));
3792: END pdf_attach_supp;
3793:
3794:
3795: procedure pdf_attach(document_id in varchar2,

Line 3989: l_document_length := dbms_lob.GetLength(l_document);

3985: and fl.file_name = l_filename ;
3986: END;
3987: END IF;
3988:
3989: l_document_length := dbms_lob.GetLength(l_document);
3990: IF (g_po_wf_debug = 'Y') THEN
3991: PO_WF_DEBUG_PKG.INSERT_DEBUG(l_itemtype, l_itemkey, 'Document Length : '||l_document_length);
3992: END IF;
3993: dbms_lob.copy(document, l_document, l_document_length, 1, 1);

Line 3993: dbms_lob.copy(document, l_document, l_document_length, 1, 1);

3989: l_document_length := dbms_lob.GetLength(l_document);
3990: IF (g_po_wf_debug = 'Y') THEN
3991: PO_WF_DEBUG_PKG.INSERT_DEBUG(l_itemtype, l_itemkey, 'Document Length : '||l_document_length);
3992: END IF;
3993: dbms_lob.copy(document, l_document, l_document_length, 1, 1);
3994:
3995: document_type :='application/pdf; name='|| l_filename;
3996:
3997: EXCEPTION

Line 4011: DBMS_LOB.write(document, lengthb(l_message), 1, UTL_RAW.cast_to_raw(l_message));

4007: --Bug#3274081 Display the message to the user incase the pdf fails.
4008: --Bug 4047688: Removed concatenation of l_filename from document_type
4009: document_type := 'text/html';
4010: l_message := fnd_message.get_string('PO', 'PO_PDF_FAILED');
4011: DBMS_LOB.write(document, lengthb(l_message), 1, UTL_RAW.cast_to_raw(l_message));
4012:
4013: END pdf_attach;
4014:
4015:

Line 4155: -- l_okc_file_data first and then use dbms_lob.copy

4151: IF (l_okc_file_id > 0)
4152: THEN
4153:
4154: -- Bug 4173198: Select file_data from fnd_lobs into local variable
4155: -- l_okc_file_data first and then use dbms_lob.copy
4156:
4157: SELECT fl.file_name, fl.file_content_type, fl.file_data
4158: INTO l_okc_file_name, l_okc_file_content_type, l_okc_file_data
4159: FROM fnd_lobs fl

Line 4164: l_okc_doc_length := dbms_lob.GetLength(l_okc_file_data);

4160: WHERE fl.file_id = l_okc_file_id;
4161:
4162: document_type := l_okc_file_content_type || '; name=' || l_okc_file_name;
4163:
4164: l_okc_doc_length := dbms_lob.GetLength(l_okc_file_data);
4165: dbms_lob.copy(document, l_okc_file_data, l_okc_doc_length, 1, 1);
4166:
4167: ELSE
4168:

Line 4165: dbms_lob.copy(document, l_okc_file_data, l_okc_doc_length, 1, 1);

4161:
4162: document_type := l_okc_file_content_type || '; name=' || l_okc_file_name;
4163:
4164: l_okc_doc_length := dbms_lob.GetLength(l_okc_file_data);
4165: dbms_lob.copy(document, l_okc_file_data, l_okc_doc_length, 1, 1);
4166:
4167: ELSE
4168:
4169: /* file does not exist; return a null */

Line 4193: DBMS_LOB.write(document, lengthb(l_message), 1, UTL_RAW.cast_to_raw(l_message));

4189: END IF;
4190:
4191: document_type :='text/html; name='|| l_okc_file_name;
4192: l_message := fnd_message.get_string('PO', 'PO_OKC_DOC_FAILED');
4193: DBMS_LOB.write(document, lengthb(l_message), 1, UTL_RAW.cast_to_raw(l_message));
4194:
4195: END okc_doc_attach;
4196:
4197:

Line 4323: l_document_length := dbms_lob.GetLength(l_document);

4319: raise;
4320: End;
4321:
4322: l_progress := 'PO_COMMUNICATION_PVT.zip_attach : Get blob length';
4323: l_document_length := dbms_lob.GetLength(l_document);
4324:
4325: l_progress := 'PO_COMMUNICATION_PVT.zip_attach : Copy zip blob';
4326: dbms_lob.copy(document, l_document, l_document_length, 1, 1);
4327:

Line 4326: dbms_lob.copy(document, l_document, l_document_length, 1, 1);

4322: l_progress := 'PO_COMMUNICATION_PVT.zip_attach : Get blob length';
4323: l_document_length := dbms_lob.GetLength(l_document);
4324:
4325: l_progress := 'PO_COMMUNICATION_PVT.zip_attach : Copy zip blob';
4326: dbms_lob.copy(document, l_document, l_document_length, 1, 1);
4327:
4328: l_progress := 'PO_COMMUNICATION_PVT.zip_attach : Set document type';
4329: document_type := l_filecontent_type ||'; name='|| l_filename;
4330:

Line 4341: DBMS_LOB.write(document, lengthb(l_message), 1, UTL_RAW.cast_to_raw(l_message));

4337: END IF;
4338:
4339: document_type :='text/html; name='|| l_filename;
4340: l_message := fnd_message.get_string('PO', 'PO_ZIP_FAILED');
4341: DBMS_LOB.write(document, lengthb(l_message), 1, UTL_RAW.cast_to_raw(l_message));
4342:
4343: END zip_attach;
4344:
4345: -------------------------------------------------------------------------------

Line 6575: IF dbms_lob.getlength(l_xml_result) >0 THEN

6571:
6572:
6573:
6574:
6575: IF dbms_lob.getlength(l_xml_result) >0 THEN
6576: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
6577: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name , 'inside manuplating l_xml_result');
6578: END IF;
6579: -- add charset.

Line 6580: l_resultOffset := DBMS_LOB.INSTR(l_xml_result, '>');

6576: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
6577: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name , 'inside manuplating l_xml_result');
6578: END IF;
6579: -- add charset.
6580: l_resultOffset := DBMS_LOB.INSTR(l_xml_result, '>');
6581: l_tempXMLResult := l_xml_result;
6582: dbms_lob.write(l_xml_result, length(''), 1,'');
6583: dbms_lob.copy(l_xml_result, l_tempXMLResult, dbms_lob.getlength(l_tempXMLResult) - l_resultOffset, length(''), l_resultOffset);
6584:

Line 6582: dbms_lob.write(l_xml_result, length(''), 1,'');

6578: END IF;
6579: -- add charset.
6580: l_resultOffset := DBMS_LOB.INSTR(l_xml_result, '>');
6581: l_tempXMLResult := l_xml_result;
6582: dbms_lob.write(l_xml_result, length(''), 1,'');
6583: dbms_lob.copy(l_xml_result, l_tempXMLResult, dbms_lob.getlength(l_tempXMLResult) - l_resultOffset, length(''), l_resultOffset);
6584:
6585: IF dbms_lob.getlength(l_headerAttachments) >0 THEN
6586:

Line 6583: dbms_lob.copy(l_xml_result, l_tempXMLResult, dbms_lob.getlength(l_tempXMLResult) - l_resultOffset, length(''), l_resultOffset);

6579: -- add charset.
6580: l_resultOffset := DBMS_LOB.INSTR(l_xml_result, '>');
6581: l_tempXMLResult := l_xml_result;
6582: dbms_lob.write(l_xml_result, length(''), 1,'');
6583: dbms_lob.copy(l_xml_result, l_tempXMLResult, dbms_lob.getlength(l_tempXMLResult) - l_resultOffset, length(''), l_resultOffset);
6584:
6585: IF dbms_lob.getlength(l_headerAttachments) >0 THEN
6586:
6587: l_variablePosition := DBMS_LOB.INSTR(l_headerAttachments, '>');

Line 6585: IF dbms_lob.getlength(l_headerAttachments) >0 THEN

6581: l_tempXMLResult := l_xml_result;
6582: dbms_lob.write(l_xml_result, length(''), 1,'');
6583: dbms_lob.copy(l_xml_result, l_tempXMLResult, dbms_lob.getlength(l_tempXMLResult) - l_resultOffset, length(''), l_resultOffset);
6584:
6585: IF dbms_lob.getlength(l_headerAttachments) >0 THEN
6586:
6587: l_variablePosition := DBMS_LOB.INSTR(l_headerAttachments, '>');
6588: dbms_lob.copy(l_xml_result, l_headerAttachments, dbms_lob.getlength(l_headerAttachments) - l_variablePosition, (dbms_lob.getlength(l_xml_result) - length('') ), l_variablePosition + 1);
6589: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 6587: l_variablePosition := DBMS_LOB.INSTR(l_headerAttachments, '>');

6583: dbms_lob.copy(l_xml_result, l_tempXMLResult, dbms_lob.getlength(l_tempXMLResult) - l_resultOffset, length(''), l_resultOffset);
6584:
6585: IF dbms_lob.getlength(l_headerAttachments) >0 THEN
6586:
6587: l_variablePosition := DBMS_LOB.INSTR(l_headerAttachments, '>');
6588: dbms_lob.copy(l_xml_result, l_headerAttachments, dbms_lob.getlength(l_headerAttachments) - l_variablePosition, (dbms_lob.getlength(l_xml_result) - length('') ), l_variablePosition + 1);
6589: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
6590: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name ,'Added header attachments to XML');
6591: END IF;

Line 6588: dbms_lob.copy(l_xml_result, l_headerAttachments, dbms_lob.getlength(l_headerAttachments) - l_variablePosition, (dbms_lob.getlength(l_xml_result) - length('') ), l_variablePosition + 1);

6584:
6585: IF dbms_lob.getlength(l_headerAttachments) >0 THEN
6586:
6587: l_variablePosition := DBMS_LOB.INSTR(l_headerAttachments, '>');
6588: dbms_lob.copy(l_xml_result, l_headerAttachments, dbms_lob.getlength(l_headerAttachments) - l_variablePosition, (dbms_lob.getlength(l_xml_result) - length('') ), l_variablePosition + 1);
6589: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
6590: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name ,'Added header attachments to XML');
6591: END IF;
6592:

Line 6595: IF dbms_lob.getlength(l_line_Attachments) >0 THEN

6591: END IF;
6592:
6593: END IF;
6594:
6595: IF dbms_lob.getlength(l_line_Attachments) >0 THEN
6596:
6597: l_variablePosition := DBMS_LOB.INSTR(l_line_Attachments, '>');
6598:
6599: IF(DBMS_LOB.INSTR(l_xml_result, '') > 0) THEN

Line 6597: l_variablePosition := DBMS_LOB.INSTR(l_line_Attachments, '>');

6593: END IF;
6594:
6595: IF dbms_lob.getlength(l_line_Attachments) >0 THEN
6596:
6597: l_variablePosition := DBMS_LOB.INSTR(l_line_Attachments, '>');
6598:
6599: IF(DBMS_LOB.INSTR(l_xml_result, '') > 0) THEN
6600: dbms_lob.copy(l_xml_result, l_line_Attachments, dbms_lob.getlength(l_line_Attachments) - l_variablePosition, (dbms_lob.getlength(l_xml_result) - length('') ), l_variablePosition + 1);
6601: ELSE

Line 6599: IF(DBMS_LOB.INSTR(l_xml_result, '') > 0) THEN

6595: IF dbms_lob.getlength(l_line_Attachments) >0 THEN
6596:
6597: l_variablePosition := DBMS_LOB.INSTR(l_line_Attachments, '>');
6598:
6599: IF(DBMS_LOB.INSTR(l_xml_result, '') > 0) THEN
6600: dbms_lob.copy(l_xml_result, l_line_Attachments, dbms_lob.getlength(l_line_Attachments) - l_variablePosition, (dbms_lob.getlength(l_xml_result) - length('') ), l_variablePosition + 1);
6601: ELSE
6602: dbms_lob.copy(l_xml_result, l_line_Attachments, dbms_lob.getlength(l_line_Attachments) - l_variablePosition, dbms_lob.getlength(l_xml_result), l_variablePosition + 1);
6603: END IF;

Line 6600: dbms_lob.copy(l_xml_result, l_line_Attachments, dbms_lob.getlength(l_line_Attachments) - l_variablePosition, (dbms_lob.getlength(l_xml_result) - length('') ), l_variablePosition + 1);

6596:
6597: l_variablePosition := DBMS_LOB.INSTR(l_line_Attachments, '>');
6598:
6599: IF(DBMS_LOB.INSTR(l_xml_result, '') > 0) THEN
6600: dbms_lob.copy(l_xml_result, l_line_Attachments, dbms_lob.getlength(l_line_Attachments) - l_variablePosition, (dbms_lob.getlength(l_xml_result) - length('') ), l_variablePosition + 1);
6601: ELSE
6602: dbms_lob.copy(l_xml_result, l_line_Attachments, dbms_lob.getlength(l_line_Attachments) - l_variablePosition, dbms_lob.getlength(l_xml_result), l_variablePosition + 1);
6603: END IF;
6604: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 6602: dbms_lob.copy(l_xml_result, l_line_Attachments, dbms_lob.getlength(l_line_Attachments) - l_variablePosition, dbms_lob.getlength(l_xml_result), l_variablePosition + 1);

6598:
6599: IF(DBMS_LOB.INSTR(l_xml_result, '') > 0) THEN
6600: dbms_lob.copy(l_xml_result, l_line_Attachments, dbms_lob.getlength(l_line_Attachments) - l_variablePosition, (dbms_lob.getlength(l_xml_result) - length('') ), l_variablePosition + 1);
6601: ELSE
6602: dbms_lob.copy(l_xml_result, l_line_Attachments, dbms_lob.getlength(l_line_Attachments) - l_variablePosition, dbms_lob.getlength(l_xml_result), l_variablePosition + 1);
6603: END IF;
6604: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
6605: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name ,'Added line attachments to XML');
6606: END IF;

Line 6611: IF dbms_lob.getlength(l_disAttachments) >0 THEN

6607:
6608:
6609: END IF;
6610:
6611: IF dbms_lob.getlength(l_disAttachments) >0 THEN
6612:
6613: l_variablePosition := DBMS_LOB.INSTR(l_disAttachments, '>');
6614: IF(DBMS_LOB.INSTR(l_xml_result, '') > 0) THEN
6615: dbms_lob.copy(l_xml_result, l_disAttachments, dbms_lob.getlength(l_disAttachments) - l_variablePosition, (dbms_lob.getlength(l_xml_result) - length('') ), l_variablePosition + 1);

Line 6613: l_variablePosition := DBMS_LOB.INSTR(l_disAttachments, '>');

6609: END IF;
6610:
6611: IF dbms_lob.getlength(l_disAttachments) >0 THEN
6612:
6613: l_variablePosition := DBMS_LOB.INSTR(l_disAttachments, '>');
6614: IF(DBMS_LOB.INSTR(l_xml_result, '') > 0) THEN
6615: dbms_lob.copy(l_xml_result, l_disAttachments, dbms_lob.getlength(l_disAttachments) - l_variablePosition, (dbms_lob.getlength(l_xml_result) - length('') ), l_variablePosition + 1);
6616: ELSE
6617: dbms_lob.copy(l_xml_result, l_disAttachments, dbms_lob.getlength(l_disAttachments) - l_variablePosition, dbms_lob.getlength(l_xml_result), l_variablePosition + 1);

Line 6614: IF(DBMS_LOB.INSTR(l_xml_result, '') > 0) THEN

6610:
6611: IF dbms_lob.getlength(l_disAttachments) >0 THEN
6612:
6613: l_variablePosition := DBMS_LOB.INSTR(l_disAttachments, '>');
6614: IF(DBMS_LOB.INSTR(l_xml_result, '') > 0) THEN
6615: dbms_lob.copy(l_xml_result, l_disAttachments, dbms_lob.getlength(l_disAttachments) - l_variablePosition, (dbms_lob.getlength(l_xml_result) - length('') ), l_variablePosition + 1);
6616: ELSE
6617: dbms_lob.copy(l_xml_result, l_disAttachments, dbms_lob.getlength(l_disAttachments) - l_variablePosition, dbms_lob.getlength(l_xml_result), l_variablePosition + 1);
6618: END IF;

Line 6615: dbms_lob.copy(l_xml_result, l_disAttachments, dbms_lob.getlength(l_disAttachments) - l_variablePosition, (dbms_lob.getlength(l_xml_result) - length('') ), l_variablePosition + 1);

6611: IF dbms_lob.getlength(l_disAttachments) >0 THEN
6612:
6613: l_variablePosition := DBMS_LOB.INSTR(l_disAttachments, '>');
6614: IF(DBMS_LOB.INSTR(l_xml_result, '') > 0) THEN
6615: dbms_lob.copy(l_xml_result, l_disAttachments, dbms_lob.getlength(l_disAttachments) - l_variablePosition, (dbms_lob.getlength(l_xml_result) - length('') ), l_variablePosition + 1);
6616: ELSE
6617: dbms_lob.copy(l_xml_result, l_disAttachments, dbms_lob.getlength(l_disAttachments) - l_variablePosition, dbms_lob.getlength(l_xml_result), l_variablePosition + 1);
6618: END IF;
6619: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 6617: dbms_lob.copy(l_xml_result, l_disAttachments, dbms_lob.getlength(l_disAttachments) - l_variablePosition, dbms_lob.getlength(l_xml_result), l_variablePosition + 1);

6613: l_variablePosition := DBMS_LOB.INSTR(l_disAttachments, '>');
6614: IF(DBMS_LOB.INSTR(l_xml_result, '') > 0) THEN
6615: dbms_lob.copy(l_xml_result, l_disAttachments, dbms_lob.getlength(l_disAttachments) - l_variablePosition, (dbms_lob.getlength(l_xml_result) - length('') ), l_variablePosition + 1);
6616: ELSE
6617: dbms_lob.copy(l_xml_result, l_disAttachments, dbms_lob.getlength(l_disAttachments) - l_variablePosition, dbms_lob.getlength(l_xml_result), l_variablePosition + 1);
6618: END IF;
6619: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
6620: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name ,'Added distribution attachments to XML');
6621: END IF;

Line 6625: IF dbms_lob.getlength(l_fileClob) >0 THEN

6621: END IF;
6622:
6623: END IF;
6624:
6625: IF dbms_lob.getlength(l_fileClob) >0 THEN
6626:
6627: l_variablePosition := DBMS_LOB.INSTR(l_fileClob, '>');
6628: IF(DBMS_LOB.INSTR(l_xml_result, '') > 0) THEN
6629: dbms_lob.copy(l_xml_result, l_fileClob, dbms_lob.getlength(l_fileClob) - l_variablePosition, (dbms_lob.getlength(l_xml_result) - length('') ), l_variablePosition + 1);

Line 6627: l_variablePosition := DBMS_LOB.INSTR(l_fileClob, '>');

6623: END IF;
6624:
6625: IF dbms_lob.getlength(l_fileClob) >0 THEN
6626:
6627: l_variablePosition := DBMS_LOB.INSTR(l_fileClob, '>');
6628: IF(DBMS_LOB.INSTR(l_xml_result, '') > 0) THEN
6629: dbms_lob.copy(l_xml_result, l_fileClob, dbms_lob.getlength(l_fileClob) - l_variablePosition, (dbms_lob.getlength(l_xml_result) - length('') ), l_variablePosition + 1);
6630: ELSE
6631: dbms_lob.copy(l_xml_result, l_fileClob, dbms_lob.getlength(l_fileClob) - l_variablePosition, dbms_lob.getlength(l_xml_result), l_variablePosition + 1);

Line 6628: IF(DBMS_LOB.INSTR(l_xml_result, '') > 0) THEN

6624:
6625: IF dbms_lob.getlength(l_fileClob) >0 THEN
6626:
6627: l_variablePosition := DBMS_LOB.INSTR(l_fileClob, '>');
6628: IF(DBMS_LOB.INSTR(l_xml_result, '') > 0) THEN
6629: dbms_lob.copy(l_xml_result, l_fileClob, dbms_lob.getlength(l_fileClob) - l_variablePosition, (dbms_lob.getlength(l_xml_result) - length('') ), l_variablePosition + 1);
6630: ELSE
6631: dbms_lob.copy(l_xml_result, l_fileClob, dbms_lob.getlength(l_fileClob) - l_variablePosition, dbms_lob.getlength(l_xml_result), l_variablePosition + 1);
6632: END IF;

Line 6629: dbms_lob.copy(l_xml_result, l_fileClob, dbms_lob.getlength(l_fileClob) - l_variablePosition, (dbms_lob.getlength(l_xml_result) - length('') ), l_variablePosition + 1);

6625: IF dbms_lob.getlength(l_fileClob) >0 THEN
6626:
6627: l_variablePosition := DBMS_LOB.INSTR(l_fileClob, '>');
6628: IF(DBMS_LOB.INSTR(l_xml_result, '') > 0) THEN
6629: dbms_lob.copy(l_xml_result, l_fileClob, dbms_lob.getlength(l_fileClob) - l_variablePosition, (dbms_lob.getlength(l_xml_result) - length('') ), l_variablePosition + 1);
6630: ELSE
6631: dbms_lob.copy(l_xml_result, l_fileClob, dbms_lob.getlength(l_fileClob) - l_variablePosition, dbms_lob.getlength(l_xml_result), l_variablePosition + 1);
6632: END IF;
6633: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 6631: dbms_lob.copy(l_xml_result, l_fileClob, dbms_lob.getlength(l_fileClob) - l_variablePosition, dbms_lob.getlength(l_xml_result), l_variablePosition + 1);

6627: l_variablePosition := DBMS_LOB.INSTR(l_fileClob, '>');
6628: IF(DBMS_LOB.INSTR(l_xml_result, '') > 0) THEN
6629: dbms_lob.copy(l_xml_result, l_fileClob, dbms_lob.getlength(l_fileClob) - l_variablePosition, (dbms_lob.getlength(l_xml_result) - length('') ), l_variablePosition + 1);
6630: ELSE
6631: dbms_lob.copy(l_xml_result, l_fileClob, dbms_lob.getlength(l_fileClob) - l_variablePosition, dbms_lob.getlength(l_xml_result), l_variablePosition + 1);
6632: END IF;
6633: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
6634: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name ,'Added file to XML');
6635: END IF;

Line 6640: IF dbms_lob.getlength(l_address_details) >0 THEN -- bug#3580225 Start --

6636:
6637:
6638: END IF;
6639:
6640: IF dbms_lob.getlength(l_address_details) >0 THEN -- bug#3580225 Start --
6641:
6642: --Add l_address_details to final XML
6643:
6644: l_variablePosition := DBMS_LOB.INSTR(l_address_details, '>');

Line 6644: l_variablePosition := DBMS_LOB.INSTR(l_address_details, '>');

6640: IF dbms_lob.getlength(l_address_details) >0 THEN -- bug#3580225 Start --
6641:
6642: --Add l_address_details to final XML
6643:
6644: l_variablePosition := DBMS_LOB.INSTR(l_address_details, '>');
6645: IF(DBMS_LOB.INSTR(l_xml_result, '') > 0) THEN
6646: dbms_lob.copy(l_xml_result, l_address_details, dbms_lob.getlength(l_address_details) - l_variablePosition, (dbms_lob.getlength(l_xml_result) - length('') ), l_variablePosition + 1);
6647: ELSE
6648: dbms_lob.copy(l_xml_result, l_address_details, dbms_lob.getlength(l_address_details) - l_variablePosition, dbms_lob.getlength(l_xml_result), l_variablePosition + 1);

Line 6645: IF(DBMS_LOB.INSTR(l_xml_result, '') > 0) THEN

6641:
6642: --Add l_address_details to final XML
6643:
6644: l_variablePosition := DBMS_LOB.INSTR(l_address_details, '>');
6645: IF(DBMS_LOB.INSTR(l_xml_result, '') > 0) THEN
6646: dbms_lob.copy(l_xml_result, l_address_details, dbms_lob.getlength(l_address_details) - l_variablePosition, (dbms_lob.getlength(l_xml_result) - length('') ), l_variablePosition + 1);
6647: ELSE
6648: dbms_lob.copy(l_xml_result, l_address_details, dbms_lob.getlength(l_address_details) - l_variablePosition, dbms_lob.getlength(l_xml_result), l_variablePosition + 1);
6649: END IF;

Line 6646: dbms_lob.copy(l_xml_result, l_address_details, dbms_lob.getlength(l_address_details) - l_variablePosition, (dbms_lob.getlength(l_xml_result) - length('') ), l_variablePosition + 1);

6642: --Add l_address_details to final XML
6643:
6644: l_variablePosition := DBMS_LOB.INSTR(l_address_details, '>');
6645: IF(DBMS_LOB.INSTR(l_xml_result, '') > 0) THEN
6646: dbms_lob.copy(l_xml_result, l_address_details, dbms_lob.getlength(l_address_details) - l_variablePosition, (dbms_lob.getlength(l_xml_result) - length('') ), l_variablePosition + 1);
6647: ELSE
6648: dbms_lob.copy(l_xml_result, l_address_details, dbms_lob.getlength(l_address_details) - l_variablePosition, dbms_lob.getlength(l_xml_result), l_variablePosition + 1);
6649: END IF;
6650: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 6648: dbms_lob.copy(l_xml_result, l_address_details, dbms_lob.getlength(l_address_details) - l_variablePosition, dbms_lob.getlength(l_xml_result), l_variablePosition + 1);

6644: l_variablePosition := DBMS_LOB.INSTR(l_address_details, '>');
6645: IF(DBMS_LOB.INSTR(l_xml_result, '') > 0) THEN
6646: dbms_lob.copy(l_xml_result, l_address_details, dbms_lob.getlength(l_address_details) - l_variablePosition, (dbms_lob.getlength(l_xml_result) - length('') ), l_variablePosition + 1);
6647: ELSE
6648: dbms_lob.copy(l_xml_result, l_address_details, dbms_lob.getlength(l_address_details) - l_variablePosition, dbms_lob.getlength(l_xml_result), l_variablePosition + 1);
6649: END IF;
6650: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
6651: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name ,'Added Address details to XML');
6652: END IF;

Line 6672: IF dbms_lob.getlength(l_custom_xml) >0 THEN

6668: , p_document_type
6669: , p_document_subtype
6670: , l_custom_xml);
6671:
6672: IF dbms_lob.getlength(l_custom_xml) >0 THEN
6673:
6674: l_variablePosition := DBMS_LOB.INSTR(l_custom_xml, '>');
6675: IF(DBMS_LOB.INSTR(l_xml_result, '') > 0) THEN
6676: dbms_lob.copy

Line 6674: l_variablePosition := DBMS_LOB.INSTR(l_custom_xml, '>');

6670: , l_custom_xml);
6671:
6672: IF dbms_lob.getlength(l_custom_xml) >0 THEN
6673:
6674: l_variablePosition := DBMS_LOB.INSTR(l_custom_xml, '>');
6675: IF(DBMS_LOB.INSTR(l_xml_result, '') > 0) THEN
6676: dbms_lob.copy
6677: (l_xml_result
6678: , l_custom_xml

Line 6675: IF(DBMS_LOB.INSTR(l_xml_result, '') > 0) THEN

6671:
6672: IF dbms_lob.getlength(l_custom_xml) >0 THEN
6673:
6674: l_variablePosition := DBMS_LOB.INSTR(l_custom_xml, '>');
6675: IF(DBMS_LOB.INSTR(l_xml_result, '') > 0) THEN
6676: dbms_lob.copy
6677: (l_xml_result
6678: , l_custom_xml
6679: , dbms_lob.getlength(l_custom_xml) - l_variablePosition

Line 6676: dbms_lob.copy

6672: IF dbms_lob.getlength(l_custom_xml) >0 THEN
6673:
6674: l_variablePosition := DBMS_LOB.INSTR(l_custom_xml, '>');
6675: IF(DBMS_LOB.INSTR(l_xml_result, '') > 0) THEN
6676: dbms_lob.copy
6677: (l_xml_result
6678: , l_custom_xml
6679: , dbms_lob.getlength(l_custom_xml) - l_variablePosition
6680: , (dbms_lob.getlength(l_xml_result) - length(''))

Line 6679: , dbms_lob.getlength(l_custom_xml) - l_variablePosition

6675: IF(DBMS_LOB.INSTR(l_xml_result, '') > 0) THEN
6676: dbms_lob.copy
6677: (l_xml_result
6678: , l_custom_xml
6679: , dbms_lob.getlength(l_custom_xml) - l_variablePosition
6680: , (dbms_lob.getlength(l_xml_result) - length(''))
6681: , l_variablePosition + 1
6682: );
6683: ELSE

Line 6680: , (dbms_lob.getlength(l_xml_result) - length(''))

6676: dbms_lob.copy
6677: (l_xml_result
6678: , l_custom_xml
6679: , dbms_lob.getlength(l_custom_xml) - l_variablePosition
6680: , (dbms_lob.getlength(l_xml_result) - length(''))
6681: , l_variablePosition + 1
6682: );
6683: ELSE
6684: dbms_lob.copy

Line 6684: dbms_lob.copy

6680: , (dbms_lob.getlength(l_xml_result) - length(''))
6681: , l_variablePosition + 1
6682: );
6683: ELSE
6684: dbms_lob.copy
6685: (l_xml_result
6686: , l_custom_xml
6687: , dbms_lob.getlength(l_custom_xml) - l_variablePosition
6688: , dbms_lob.getlength(l_xml_result)

Line 6687: , dbms_lob.getlength(l_custom_xml) - l_variablePosition

6683: ELSE
6684: dbms_lob.copy
6685: (l_xml_result
6686: , l_custom_xml
6687: , dbms_lob.getlength(l_custom_xml) - l_variablePosition
6688: , dbms_lob.getlength(l_xml_result)
6689: , l_variablePosition + 1
6690: );
6691: END IF;

Line 6688: , dbms_lob.getlength(l_xml_result)

6684: dbms_lob.copy
6685: (l_xml_result
6686: , l_custom_xml
6687: , dbms_lob.getlength(l_custom_xml) - l_variablePosition
6688: , dbms_lob.getlength(l_xml_result)
6689: , l_variablePosition + 1
6690: );
6691: END IF;
6692: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 6701: IF(DBMS_LOB.INSTR(l_xml_result, '') = 0) THEN

6697:
6698: END IF;
6699: --
6700:
6701: IF(DBMS_LOB.INSTR(l_xml_result, '') = 0) THEN
6702: dbms_lob.write(l_xml_result, 10, dbms_lob.getlength(l_xml_result), '');
6703: END IF;
6704:
6705: END IF;

Line 6702: dbms_lob.write(l_xml_result, 10, dbms_lob.getlength(l_xml_result), '');

6698: END IF;
6699: --
6700:
6701: IF(DBMS_LOB.INSTR(l_xml_result, '') = 0) THEN
6702: dbms_lob.write(l_xml_result, 10, dbms_lob.getlength(l_xml_result), '');
6703: END IF;
6704:
6705: END IF;
6706:

Line 6713: dbms_lob.write(l_xml_result, 11, dbms_lob.getlength(l_xml_result) - 9, '');

6709: Add the final xml query in the clob.
6710: */
6711: IF(p_test_flag = 'D') then
6712:
6713: dbms_lob.write(l_xml_result, 11, dbms_lob.getlength(l_xml_result) - 9, '');
6714: dbms_lob.write(l_xml_result, length(l_xml_query ||' '), dbms_lob.getlength(l_xml_result) + 1, l_xml_query ||' ');
6715:
6716: END IF;
6717: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 6714: dbms_lob.write(l_xml_result, length(l_xml_query ||' '), dbms_lob.getlength(l_xml_result) + 1, l_xml_query ||' ');

6710: */
6711: IF(p_test_flag = 'D') then
6712:
6713: dbms_lob.write(l_xml_result, 11, dbms_lob.getlength(l_xml_result) - 9, '');
6714: dbms_lob.write(l_xml_result, length(l_xml_query ||' '), dbms_lob.getlength(l_xml_result) + 1, l_xml_query ||' ');
6715:
6716: END IF;
6717: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
6718: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name ,'END OF POXMLGEN');