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 FND_LOG

Line 2368: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

2364: l_communication varchar2(1);
2365: l_api_name CONSTANT VARCHAR2(25) := 'launch_communicate';
2366:
2367: BEGIN
2368: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2369: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name || '.begin', 'launch_communicate');
2370: END IF;
2371: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2372: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name || 'Communication method ', p_mode);

Line 2369: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name || '.begin', 'launch_communicate');

2365: l_api_name CONSTANT VARCHAR2(25) := 'launch_communicate';
2366:
2367: BEGIN
2368: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2369: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name || '.begin', 'launch_communicate');
2370: END IF;
2371: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2372: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name || 'Communication method ', p_mode);
2373: END IF;

Line 2371: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

2367: BEGIN
2368: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2369: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name || '.begin', 'launch_communicate');
2370: END IF;
2371: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2372: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name || 'Communication method ', p_mode);
2373: END IF;
2374: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2375: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name || 'Document Type ', p_document_type);

Line 2372: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name || 'Communication method ', p_mode);

2368: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2369: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name || '.begin', 'launch_communicate');
2370: END IF;
2371: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2372: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name || 'Communication method ', p_mode);
2373: END IF;
2374: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2375: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name || 'Document Type ', p_document_type);
2376: END IF;

Line 2374: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

2370: END IF;
2371: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2372: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name || 'Communication method ', p_mode);
2373: END IF;
2374: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2375: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name || 'Document Type ', p_document_type);
2376: END IF;
2377:
2378: if p_mode = 'PRINT' then

Line 2375: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name || 'Document Type ', p_document_type);

2371: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2372: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name || 'Communication method ', p_mode);
2373: END IF;
2374: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2375: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name || 'Document Type ', p_document_type);
2376: END IF;
2377:
2378: if p_mode = 'PRINT' then
2379:

Line 2603: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

2599:
2600: end if;
2601:
2602: end if;
2603: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2604: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name || 'After launching the Dispatch Purchase order CP.', 0);
2605: END IF;
2606:
2607: EXCEPTION

Line 2604: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name || 'After launching the Dispatch Purchase order CP.', 0);

2600: end if;
2601:
2602: end if;
2603: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2604: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name || 'After launching the Dispatch Purchase order CP.', 0);
2605: END IF;
2606:
2607: EXCEPTION
2608: when others then

Line 2609: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

2605: END IF;
2606:
2607: EXCEPTION
2608: when others then
2609: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
2610: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, g_log_head || l_api_name || '.EXCEPTION',
2611: 'launch_communicate: Inside exception :'|| '000' || sqlcode);
2612: END IF;
2613:

Line 2610: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, g_log_head || l_api_name || '.EXCEPTION',

2606:
2607: EXCEPTION
2608: when others then
2609: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
2610: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, g_log_head || l_api_name || '.EXCEPTION',
2611: 'launch_communicate: Inside exception :'|| '000' || sqlcode);
2612: END IF;
2613:
2614:

Line 4901: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

4897: l_tax_name_query VARCHAR2(6000);
4898:
4899: l_custom_xml clob; --: clob to hold xml from custom code
4900: BEGIN
4901: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4902: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name ||'Document Id:', p_document_id);
4903: END IF;
4904: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4905: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name ||'Document Type:', p_document_type);

Line 4902: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name ||'Document Id:', p_document_id);

4898:
4899: l_custom_xml clob; --: clob to hold xml from custom code
4900: BEGIN
4901: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4902: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name ||'Document Id:', p_document_id);
4903: END IF;
4904: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4905: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name ||'Document Type:', p_document_type);
4906: END IF;

Line 4904: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

4900: BEGIN
4901: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4902: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name ||'Document Id:', p_document_id);
4903: END IF;
4904: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4905: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name ||'Document Type:', p_document_type);
4906: END IF;
4907: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4908: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name ||'Document SubType:', p_document_subtype);

Line 4905: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name ||'Document Type:', p_document_type);

4901: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4902: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name ||'Document Id:', p_document_id);
4903: END IF;
4904: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4905: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name ||'Document Type:', p_document_type);
4906: END IF;
4907: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4908: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name ||'Document SubType:', p_document_subtype);
4909: END IF;

Line 4907: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

4903: END IF;
4904: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4905: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name ||'Document Type:', p_document_type);
4906: END IF;
4907: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4908: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name ||'Document SubType:', p_document_subtype);
4909: END IF;
4910: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4911: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name ||'Table Type:', p_which_tables);

Line 4908: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name ||'Document SubType:', p_document_subtype);

4904: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4905: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name ||'Document Type:', p_document_type);
4906: END IF;
4907: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4908: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name ||'Document SubType:', p_document_subtype);
4909: END IF;
4910: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4911: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name ||'Table Type:', p_which_tables);
4912: END IF;

Line 4910: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

4906: END IF;
4907: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4908: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name ||'Document SubType:', p_document_subtype);
4909: END IF;
4910: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4911: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name ||'Table Type:', p_which_tables);
4912: END IF;
4913:
4914: /* Check the package name and version. IF wrong package or version raise the exception and exit */

Line 4911: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name ||'Table Type:', p_which_tables);

4907: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4908: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name ||'Document SubType:', p_document_subtype);
4909: END IF;
4910: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4911: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name ||'Table Type:', p_which_tables);
4912: END IF;
4913:
4914: /* Check the package name and version. IF wrong package or version raise the exception and exit */
4915: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,

Line 5088: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

5084: l_po_number := null;
5085: l_change_summary := null;
5086: l_vendor_id := null;
5087: END;
5088: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5089: /*
5090: To find the version of the database. If the db version is >8 AND <9
5091: XMLQUERY is used to generate the XML AND IF the version is 9 XMLGEN is used.
5092: */

Line 5096: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name || 'POXMLGEN', 'Executing DB Version');

5092: */
5093:
5094:
5095:
5096: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name || 'POXMLGEN', 'Executing DB Version');
5097: END IF;
5098:
5099: DBMS_UTILITY.DB_VERSION(l_version, l_compatibility);
5100: l_majorVersion := to_number(substr(l_version, 1, instr(l_version, '.') - 1));

Line 5101: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

5097: END IF;
5098:
5099: DBMS_UTILITY.DB_VERSION(l_version, l_compatibility);
5100: l_majorVersion := to_number(substr(l_version, 1, instr(l_version, '.') - 1));
5101: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5102: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name , 'DB Version'|| l_majorVersion);
5103: END IF;
5104:
5105: /*Bug 6692126 Call the procedure gettandc which in turn calls

Line 5102: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name , 'DB Version'|| l_majorVersion);

5098:
5099: DBMS_UTILITY.DB_VERSION(l_version, l_compatibility);
5100: l_majorVersion := to_number(substr(l_version, 1, instr(l_version, '.') - 1));
5101: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5102: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name , 'DB Version'|| l_majorVersion);
5103: END IF;
5104:
5105: /*Bug 6692126 Call the procedure gettandc which in turn calls
5106: the procedure get_preparer_profile which gets the profile option values

Line 5111: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

5107: in preparers context */
5108: /* get terms and conditions message*/
5109: /*IF FND_PROFILE.VALUE('PO_EMAIL_TERMS_FILE_NAME') IS NOT NULL THEN
5110: PO_XML_UTILS_GRP.getTandC(fnd_global.user_id(), fnd_global.resp_id(), fnd_global.resp_appl_id(), l_fileClob );
5111: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5112: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name , 'After getting the fileClob');
5113: END IF;
5114: END IF; */
5115:

Line 5112: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name , 'After getting the fileClob');

5108: /* get terms and conditions message*/
5109: /*IF FND_PROFILE.VALUE('PO_EMAIL_TERMS_FILE_NAME') IS NOT NULL THEN
5110: PO_XML_UTILS_GRP.getTandC(fnd_global.user_id(), fnd_global.resp_id(), fnd_global.resp_appl_id(), l_fileClob );
5111: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5112: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name , 'After getting the fileClob');
5113: END IF;
5114: END IF; */
5115:
5116: PO_XML_UTILS_GRP.getTandC(p_document_id, p_document_type, l_fileClob); --Bug 6692126

Line 5117: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

5113: END IF;
5114: END IF; */
5115:
5116: PO_XML_UTILS_GRP.getTandC(p_document_id, p_document_type, l_fileClob); --Bug 6692126
5117: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5118: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name , 'After getting the fileClob');
5119: end if;
5120:
5121: --

Line 5118: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name , 'After getting the fileClob');

5114: END IF; */
5115:
5116: PO_XML_UTILS_GRP.getTandC(p_document_id, p_document_type, l_fileClob); --Bug 6692126
5117: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5118: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name , 'After getting the fileClob');
5119: end if;
5120:
5121: --
5122: l_okc_doc_type := PO_CONTERMS_UTL_GRP.get_po_contract_doctype(p_document_subtype);

Line 5202: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

5198: l_timezone_id := get_preparer_profile(p_document_id, p_document_type, 'SERVER_TIMEZONE_ID'); --Bug 6692126
5199: SELECT name, gmt_deviation_hours into l_timezone, l_offset from HZ_TIMEZONES_VL where timezone_id = to_number(l_timezone_id);
5200: EXCEPTION
5201: WHEN OTHERS THEN
5202: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5203: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name ||'Timezone: ','Inside Timezone Exception Handler');
5204: END IF;
5205: RAISE;
5206: END;

Line 5203: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name ||'Timezone: ','Inside Timezone Exception Handler');

5199: SELECT name, gmt_deviation_hours into l_timezone, l_offset from HZ_TIMEZONES_VL where timezone_id = to_number(l_timezone_id);
5200: EXCEPTION
5201: WHEN OTHERS THEN
5202: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5203: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name ||'Timezone: ','Inside Timezone Exception Handler');
5204: END IF;
5205: RAISE;
5206: END;
5207: FND_MESSAGE.SET_NAME('PO', 'PO_FO_TIMEZONE');

Line 5788: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

5784:
5785: -- : Modify queries below to include complex work information
5786:
5787: IF(p_document_type in ('PO', 'PA')) THEN
5788: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5789: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name ||'NON Release:','Entered into Non Release Query Loop');
5790: END IF;
5791:
5792: PO_COMMUNICATION_PVT.g_release_header_id := p_document_id; -- For documents other than Releases join is based on header id for getting the attachments.

Line 5789: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name ||'NON Release:','Entered into Non Release Query Loop');

5785: -- : Modify queries below to include complex work information
5786:
5787: IF(p_document_type in ('PO', 'PA')) THEN
5788: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5789: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name ||'NON Release:','Entered into Non Release Query Loop');
5790: END IF;
5791:
5792: PO_COMMUNICATION_PVT.g_release_header_id := p_document_id; -- For documents other than Releases join is based on header id for getting the attachments.
5793: IF p_which_tables = 'MAIN' THEN

Line 6054: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

6050: /* Bug#3698674: In 8i db, the functions used to retrieve revision number and release id are not working
6051: properly. Created a global temporary table po_communication_pvt and retrieved the values from the
6052: global temporary table in both main and archive queries.*/
6053: IF p_which_tables = 'MAIN' THEN
6054: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
6055: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name || 'Releases:','Entered into Release loop');
6056: END IF;
6057:
6058: l_xml_query := 'SELECT phx.*, PO_COMMUNICATION_PVT.getDocumentType() document_type, PO_COMMUNICATION_PVT.getCoverMessage() cover_message,

Line 6055: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name || 'Releases:','Entered into Release loop');

6051: properly. Created a global temporary table po_communication_pvt and retrieved the values from the
6052: global temporary table in both main and archive queries.*/
6053: IF p_which_tables = 'MAIN' THEN
6054: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
6055: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name || 'Releases:','Entered into Release loop');
6056: END IF;
6057:
6058: l_xml_query := 'SELECT phx.*, PO_COMMUNICATION_PVT.getDocumentType() document_type, PO_COMMUNICATION_PVT.getCoverMessage() cover_message,
6059: PO_COMMUNICATION_PVT.getTimezone() timezone,PO_COMMUNICATION_PVT.getAmendmentMessage() ammendment_message,PO_COMMUNICATION_PVT.getTestFlag() test_flag,

Line 6070: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

6066:
6067: SELECT count(*) into l_count FROM po_line_locations_all WHERE po_release_id = p_document_id ;
6068:
6069: IF l_count >0 THEN
6070: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
6071: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name || 'Releases:','Assigning Releases line/line locations query');
6072: END IF;
6073: -- Added release id in condition
6074: --Bug 5506417: Added order by pllx.shipment_num and order by plx.line_num clauses

Line 6071: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name || 'Releases:','Assigning Releases line/line locations query');

6067: SELECT count(*) into l_count FROM po_line_locations_all WHERE po_release_id = p_document_id ;
6068:
6069: IF l_count >0 THEN
6070: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
6071: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name || 'Releases:','Assigning Releases line/line locations query');
6072: END IF;
6073: -- Added release id in condition
6074: --Bug 5506417: Added order by pllx.shipment_num and order by plx.line_num clauses
6075: /* Bug 8886244 .

Line 6109: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

6105:
6106:
6107:
6108: ELSIF p_which_tables = 'ARCHIVE' THEN
6109: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
6110: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name ||'Release Archive:','Assigning Releases Archive Query');
6111: END IF;
6112:
6113: /* The following query gets the release details, the outermost cursor selects headers information,

Line 6110: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name ||'Release Archive:','Assigning Releases Archive Query');

6106:
6107:
6108: ELSIF p_which_tables = 'ARCHIVE' THEN
6109: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
6110: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name ||'Release Archive:','Assigning Releases Archive Query');
6111: END IF;
6112:
6113: /* The following query gets the release details, the outermost cursor selects headers information,
6114: and we move to the details (line, shipments, distributions) as we move inside each cursor. The

Line 6434: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

6430: End If;
6431: -- End Bug16076162
6432:
6433: select TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') into l_time from dual;
6434: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
6435: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name ||'Start of executing queries', l_time);
6436: END IF;
6437:
6438:

Line 6435: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name ||'Start of executing queries', l_time);

6431: -- End Bug16076162
6432:
6433: select TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') into l_time from dual;
6434: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
6435: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name ||'Start of executing queries', l_time);
6436: END IF;
6437:
6438:
6439: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 6439: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

6435: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name ||'Start of executing queries', l_time);
6436: END IF;
6437:
6438:
6439: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
6440: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name || 'POXMLGEN','Generating XML using XMLGEN');
6441: END IF;
6442: l_xml9_stmt := 'declare
6443: context DBMS_XMLGEN.ctxHandle;

Line 6440: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name || 'POXMLGEN','Generating XML using XMLGEN');

6436: END IF;
6437:
6438:
6439: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
6440: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name || 'POXMLGEN','Generating XML using XMLGEN');
6441: END IF;
6442: l_xml9_stmt := 'declare
6443: context DBMS_XMLGEN.ctxHandle;
6444: l_xml_query varchar2(15000) ;

Line 6463: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

6459: l_disAttach_query := :4;
6460: l_fileClob := :5;
6461:
6462: select TO_CHAR(SYSDATE, ''DD-MON-YYYY HH24:MI:SS'') into l_time from dual;
6463: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
6464: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||''Before Executing the Main Query'', l_time);
6465: END IF;
6466:
6467: context := dbms_xmlgen.newContext(l_xml_query);

Line 6464: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||''Before Executing the Main Query'', l_time);

6460: l_fileClob := :5;
6461:
6462: select TO_CHAR(SYSDATE, ''DD-MON-YYYY HH24:MI:SS'') into l_time from dual;
6463: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
6464: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||''Before Executing the Main Query'', l_time);
6465: END IF;
6466:
6467: context := dbms_xmlgen.newContext(l_xml_query);
6468: dbms_xmlgen.setRowsetTag(context,''PO_DATA'');

Line 6475: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

6471: :xresult := dbms_xmlgen.getXML(context,DBMS_XMLGEN.NONE);
6472: dbms_xmlgen.closeContext(context);
6473:
6474: select TO_CHAR(SYSDATE, ''DD-MON-YYYY HH24:MI:SS'') into l_time from dual;
6475: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
6476: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||''After Executing the Main Query'', l_time);
6477: END IF;
6478:
6479: context := dbms_xmlgen.newContext(l_headerAttach_query);

Line 6476: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||''After Executing the Main Query'', l_time);

6472: dbms_xmlgen.closeContext(context);
6473:
6474: select TO_CHAR(SYSDATE, ''DD-MON-YYYY HH24:MI:SS'') into l_time from dual;
6475: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
6476: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||''After Executing the Main Query'', l_time);
6477: END IF;
6478:
6479: context := dbms_xmlgen.newContext(l_headerAttach_query);
6480: dbms_xmlgen.setRowsetTag(context,''HEADER_ATTACHMENTS'');

Line 6487: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

6483: :xheaderAttach := dbms_xmlgen.getXML(context,DBMS_XMLGEN.NONE);
6484: dbms_xmlgen.closeContext(context);
6485:
6486: select TO_CHAR(SYSDATE, ''DD-MON-YYYY HH24:MI:SS'') into l_time from dual;
6487: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
6488: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||''After Executing the header attachment Query'', l_time);
6489: END IF;
6490:
6491: context := dbms_xmlgen.newContext(l_lineAttach_query);

Line 6488: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||''After Executing the header attachment Query'', l_time);

6484: dbms_xmlgen.closeContext(context);
6485:
6486: select TO_CHAR(SYSDATE, ''DD-MON-YYYY HH24:MI:SS'') into l_time from dual;
6487: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
6488: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||''After Executing the header attachment Query'', l_time);
6489: END IF;
6490:
6491: context := dbms_xmlgen.newContext(l_lineAttach_query);
6492: dbms_xmlgen.setRowsetTag(context,''LINE_ATTACHMENTS'');

Line 6499: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

6495: :xlineAttach := dbms_xmlgen.getXML(context,DBMS_XMLGEN.NONE);
6496: dbms_xmlgen.closeContext(context);
6497:
6498: select TO_CHAR(SYSDATE, ''DD-MON-YYYY HH24:MI:SS'') into l_time from dual;
6499: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
6500: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||''After Executing the line attachment Query'', l_time);
6501: END IF;
6502:
6503: context := dbms_xmlgen.newContext(l_disAttach_query);

Line 6500: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||''After Executing the line attachment Query'', l_time);

6496: dbms_xmlgen.closeContext(context);
6497:
6498: select TO_CHAR(SYSDATE, ''DD-MON-YYYY HH24:MI:SS'') into l_time from dual;
6499: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
6500: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||''After Executing the line attachment Query'', l_time);
6501: END IF;
6502:
6503: context := dbms_xmlgen.newContext(l_disAttach_query);
6504: dbms_xmlgen.setRowsetTag(context,''SHIPMENT_ATTACHMENTS'');

Line 6511: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

6507: :xdisAttach := dbms_xmlgen.getXML(context,DBMS_XMLGEN.NONE);
6508: dbms_xmlgen.closeContext(context);
6509:
6510: select TO_CHAR(SYSDATE, ''DD-MON-YYYY HH24:MI:SS'') into l_time from dual;
6511: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
6512: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||''After Executing the shipment attachment Query'', l_time);
6513: END IF;
6514:
6515: IF l_fileClob is not null THEN

Line 6512: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||''After Executing the shipment attachment Query'', l_time);

6508: dbms_xmlgen.closeContext(context);
6509:
6510: select TO_CHAR(SYSDATE, ''DD-MON-YYYY HH24:MI:SS'') into l_time from dual;
6511: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
6512: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||''After Executing the shipment attachment Query'', l_time);
6513: END IF;
6514:
6515: IF l_fileClob is not null THEN
6516:

Line 6524: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

6520: DBMS_XMLGEN.setRowSetTag(context,NULL);
6521: :xfileClob := DBMS_XMLGEN.getXML(context,DBMS_XMLGEN.NONE);
6522: DBMS_XMLGEN.closeContext(context);
6523: close refcur;
6524: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
6525: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name , ''After executing the file clob'');
6526: END IF;
6527: ELSE
6528: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 6525: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name , ''After executing the file clob'');

6521: :xfileClob := DBMS_XMLGEN.getXML(context,DBMS_XMLGEN.NONE);
6522: DBMS_XMLGEN.closeContext(context);
6523: close refcur;
6524: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
6525: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name , ''After executing the file clob'');
6526: END IF;
6527: ELSE
6528: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
6529: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name , ''Value of File clob is null'');

Line 6528: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

6524: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
6525: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name , ''After executing the file clob'');
6526: END IF;
6527: ELSE
6528: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
6529: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name , ''Value of File clob is null'');
6530: END IF;
6531: :xfileClob := null;
6532: END IF;

Line 6529: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name , ''Value of File clob is null'');

6525: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name , ''After executing the file clob'');
6526: END IF;
6527: ELSE
6528: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
6529: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name , ''Value of File clob is null'');
6530: END IF;
6531: :xfileClob := null;
6532: END IF;
6533:

Line 6537: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

6533:
6534: -- bug#3580225 Start --
6535:
6536: select TO_CHAR(SYSDATE, ''DD-MON-YYYY HH24:MI:SS'') into l_time from dual;
6537: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
6538: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||''Before calling PO_HR_LOCATION.populate_gt'', l_time);
6539: END IF;
6540:
6541: /* Call PO_HR_LOCATION.populate_gt procedure to insert address values into global temp table from PL/SQL table*/

Line 6538: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||''Before calling PO_HR_LOCATION.populate_gt'', l_time);

6534: -- bug#3580225 Start --
6535:
6536: select TO_CHAR(SYSDATE, ''DD-MON-YYYY HH24:MI:SS'') into l_time from dual;
6537: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
6538: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||''Before calling PO_HR_LOCATION.populate_gt'', l_time);
6539: END IF;
6540:
6541: /* Call PO_HR_LOCATION.populate_gt procedure to insert address values into global temp table from PL/SQL table*/
6542: PO_HR_LOCATION.populate_gt();

Line 6564: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

6560: OUT l_xml_result, OUT l_headerAttachments, OUT l_line_Attachments, OUT l_disAttachments, OUT l_fileClob, OUT l_address_details;
6561:
6562:
6563: select TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') into l_time from dual;
6564: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
6565: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name ||'End of executing queries', l_time);
6566: END IF;
6567:
6568: /*Delete the records from global temp table*/

Line 6565: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name ||'End of executing queries', l_time);

6561:
6562:
6563: select TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') into l_time from dual;
6564: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
6565: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name ||'End of executing queries', l_time);
6566: END IF;
6567:
6568: /*Delete the records from global temp table*/
6569: DELETE po_address_details_gt;

Line 6576: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

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.
6580: l_resultOffset := DBMS_LOB.INSTR(l_xml_result, '>');

Line 6577: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name , 'inside manuplating l_xml_result');

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.
6580: l_resultOffset := DBMS_LOB.INSTR(l_xml_result, '>');
6581: l_tempXMLResult := l_xml_result;

Line 6589: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

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:
6593: END IF;

Line 6590: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name ,'Added header attachments to XML');

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:
6593: END IF;
6594:

Line 6604: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) 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;
6607:
6608:

Line 6605: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name ,'Added line attachments to XML');

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;
6607:
6608:
6609: END IF;

Line 6619: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) 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;
6622:
6623: END IF;

Line 6620: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name ,'Added distribution attachments to XML');

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;
6622:
6623: END IF;
6624:

Line 6633: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) 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;
6636:
6637:

Line 6634: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name ,'Added file to XML');

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;
6636:
6637:
6638: END IF;

Line 6650: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) 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;
6653:
6654:

Line 6651: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name ,'Added Address details to XML');

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;
6653:
6654:
6655: END IF; -- bug#3580225 end --

Line 6658: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

6654:
6655: END IF; -- bug#3580225 end --
6656:
6657: --
6658: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
6659: FND_LOG.string
6660: (FND_LOG.LEVEL_STATEMENT
6661: , g_log_head || l_api_name
6662: , 'Calling custom hook PO_CUSTOM_XMLGEN_PKG.generate_xml_fragment'

Line 6659: FND_LOG.string

6655: END IF; -- bug#3580225 end --
6656:
6657: --
6658: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
6659: FND_LOG.string
6660: (FND_LOG.LEVEL_STATEMENT
6661: , g_log_head || l_api_name
6662: , 'Calling custom hook PO_CUSTOM_XMLGEN_PKG.generate_xml_fragment'
6663: );

Line 6660: (FND_LOG.LEVEL_STATEMENT

6656:
6657: --
6658: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
6659: FND_LOG.string
6660: (FND_LOG.LEVEL_STATEMENT
6661: , g_log_head || l_api_name
6662: , 'Calling custom hook PO_CUSTOM_XMLGEN_PKG.generate_xml_fragment'
6663: );
6664: END IF;

Line 6692: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

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
6693: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
6694: , g_log_head || l_api_name
6695: , 'Added Custom XML');
6696: END IF;

Line 6693: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

6689: , l_variablePosition + 1
6690: );
6691: END IF;
6692: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
6693: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
6694: , g_log_head || l_api_name
6695: , 'Added Custom XML');
6696: END IF;
6697:

Line 6717: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

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');
6719: END IF;
6720:
6721:

Line 6718: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name ,'END OF POXMLGEN');

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');
6719: END IF;
6720:
6721:
6722: RETURN l_xml_result;

Line 6726: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

6722: RETURN l_xml_result;
6723: EXCEPTION
6724:
6725: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6726: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
6727: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name , SQLERRM);
6728: END IF;
6729: RAISE;
6730: WHEN OTHERS THEN

Line 6727: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name , SQLERRM);

6723: EXCEPTION
6724:
6725: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6726: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
6727: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name , SQLERRM);
6728: END IF;
6729: RAISE;
6730: WHEN OTHERS THEN
6731: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 6731: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

6727: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name , SQLERRM);
6728: END IF;
6729: RAISE;
6730: WHEN OTHERS THEN
6731: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
6732: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name , SQLERRM);
6733: END IF;
6734: RAISE;
6735:

Line 6732: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name , SQLERRM);

6728: END IF;
6729: RAISE;
6730: WHEN OTHERS THEN
6731: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
6732: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name , SQLERRM);
6733: END IF;
6734: RAISE;
6735:
6736: END;