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 1979: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1975: l_api_name CONSTANT VARCHAR2(25):= 'launch_communicate';
1976:
1977:
1978: BEGIN
1979: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1980: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name || '.begin','launch_communicate');
1981: END IF;
1982: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1983: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name || 'Communication method ' ,p_mode);

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

1976:
1977:
1978: BEGIN
1979: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1980: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name || '.begin','launch_communicate');
1981: END IF;
1982: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1983: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name || 'Communication method ' ,p_mode);
1984: END IF;

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

1978: BEGIN
1979: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1980: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name || '.begin','launch_communicate');
1981: END IF;
1982: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1983: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name || 'Communication method ' ,p_mode);
1984: END IF;
1985: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1986: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name || 'Document Type ' ,p_document_type);

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

1979: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1980: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name || '.begin','launch_communicate');
1981: END IF;
1982: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1983: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name || 'Communication method ' ,p_mode);
1984: END IF;
1985: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1986: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name || 'Document Type ' ,p_document_type);
1987: END IF;

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

1981: END IF;
1982: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1983: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name || 'Communication method ' ,p_mode);
1984: END IF;
1985: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1986: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name || 'Document Type ' ,p_document_type);
1987: END IF;
1988:
1989: if p_mode = 'PRINT' then

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

1982: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1983: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name || 'Communication method ' ,p_mode);
1984: END IF;
1985: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1986: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name || 'Document Type ' ,p_document_type);
1987: END IF;
1988:
1989: if p_mode = 'PRINT' then
1990:

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

2211:
2212: end if;
2213:
2214: end if;
2215: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2216: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name || 'After launching the Dispatch Purchase order CP.' , 0);
2217: END IF;
2218:
2219: EXCEPTION

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

2212: end if;
2213:
2214: end if;
2215: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2216: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name || 'After launching the Dispatch Purchase order CP.' , 0);
2217: END IF;
2218:
2219: EXCEPTION
2220: when others then

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

2217: END IF;
2218:
2219: EXCEPTION
2220: when others then
2221: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
2222: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,g_log_head || l_api_name ||'.EXCEPTION',
2223: 'launch_communicate: Inside exception :'|| '000' ||sqlcode);
2224: END IF;
2225:

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

2218:
2219: EXCEPTION
2220: when others then
2221: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
2222: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,g_log_head || l_api_name ||'.EXCEPTION',
2223: 'launch_communicate: Inside exception :'|| '000' ||sqlcode);
2224: END IF;
2225:
2226:

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

4149: l_org_id number;
4150: /*Bug 5983107*/
4151:
4152: BEGIN
4153: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4154: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||'Document Id:',p_document_id);
4155: END IF;
4156: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4157: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||'Document Type:',p_document_type);

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

4150: /*Bug 5983107*/
4151:
4152: BEGIN
4153: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4154: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||'Document Id:',p_document_id);
4155: END IF;
4156: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4157: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||'Document Type:',p_document_type);
4158: END IF;

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

4152: BEGIN
4153: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4154: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||'Document Id:',p_document_id);
4155: END IF;
4156: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4157: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||'Document Type:',p_document_type);
4158: END IF;
4159: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4160: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||'Document SubType:',p_document_subtype);

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

4153: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4154: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||'Document Id:',p_document_id);
4155: END IF;
4156: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4157: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||'Document Type:',p_document_type);
4158: END IF;
4159: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4160: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||'Document SubType:',p_document_subtype);
4161: END IF;

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

4155: END IF;
4156: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4157: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||'Document Type:',p_document_type);
4158: END IF;
4159: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4160: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||'Document SubType:',p_document_subtype);
4161: END IF;
4162: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4163: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||'Table Type:',p_which_tables);

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

4156: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4157: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||'Document Type:',p_document_type);
4158: END IF;
4159: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4160: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||'Document SubType:',p_document_subtype);
4161: END IF;
4162: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4163: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||'Table Type:',p_which_tables);
4164: END IF;

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

4158: END IF;
4159: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4160: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||'Document SubType:',p_document_subtype);
4161: END IF;
4162: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4163: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||'Table Type:',p_which_tables);
4164: END IF;
4165:
4166: /* Check the package name and version. IF wrong package or version raise the exception and exit */

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

4159: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4160: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||'Document SubType:',p_document_subtype);
4161: END IF;
4162: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4163: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||'Table Type:',p_which_tables);
4164: END IF;
4165:
4166: /* Check the package name and version. IF wrong package or version raise the exception and exit */
4167: IF NOT FND_API.COMPATIBLE_API_CALL( l_api_version,

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

4326: l_po_number := null;
4327: l_change_summary := null;
4328: l_vendor_id := null;
4329: END;
4330: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4331: /*
4332: To find the version of the database. If the db version is >8 AND <9
4333: XMLQUERY is used to generate the XML AND IF the version is 9 XMLGEN is used.
4334: */

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

4334: */
4335:
4336:
4337:
4338: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||'POXMLGEN', 'Executing DB Version');
4339: END IF;
4340:
4341: DBMS_UTILITY.DB_VERSION(l_version, l_compatibility);
4342: l_majorVersion := to_number(substr(l_version, 1, instr(l_version,'.')-1));

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

4339: END IF;
4340:
4341: DBMS_UTILITY.DB_VERSION(l_version, l_compatibility);
4342: l_majorVersion := to_number(substr(l_version, 1, instr(l_version,'.')-1));
4343: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4344: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name , 'DB Version'||l_majorVersion);
4345: END IF;
4346:
4347: /*Bug 6692126 Call the procedure gettandc which in turn calls

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

4340:
4341: DBMS_UTILITY.DB_VERSION(l_version, l_compatibility);
4342: l_majorVersion := to_number(substr(l_version, 1, instr(l_version,'.')-1));
4343: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4344: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name , 'DB Version'||l_majorVersion);
4345: END IF;
4346:
4347: /*Bug 6692126 Call the procedure gettandc which in turn calls
4348: the procedure get_preparer_profile which gets the profile option values

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

4349: in preparers context */
4350: /* get terms and conditions message*/
4351: /*IF FND_PROFILE.VALUE('PO_EMAIL_TERMS_FILE_NAME') IS NOT NULL THEN
4352: PO_XML_UTILS_GRP.getTandC(fnd_global.user_id(), fnd_global.resp_id(), fnd_global.resp_appl_id(), l_fileClob );
4353: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4354: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name , 'After getting the fileClob');
4355: END IF;
4356: END IF; */
4357:

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

4350: /* get terms and conditions message*/
4351: /*IF FND_PROFILE.VALUE('PO_EMAIL_TERMS_FILE_NAME') IS NOT NULL THEN
4352: PO_XML_UTILS_GRP.getTandC(fnd_global.user_id(), fnd_global.resp_id(), fnd_global.resp_appl_id(), l_fileClob );
4353: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4354: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name , 'After getting the fileClob');
4355: END IF;
4356: END IF; */
4357:
4358: PO_XML_UTILS_GRP.getTandC(p_document_id, p_document_type,l_fileClob); --Bug 6692126

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

4355: END IF;
4356: END IF; */
4357:
4358: PO_XML_UTILS_GRP.getTandC(p_document_id, p_document_type,l_fileClob); --Bug 6692126
4359: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4360: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name , 'After getting the fileClob');
4361: end if;
4362:
4363: --

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

4356: END IF; */
4357:
4358: PO_XML_UTILS_GRP.getTandC(p_document_id, p_document_type,l_fileClob); --Bug 6692126
4359: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4360: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name , 'After getting the fileClob');
4361: end if;
4362:
4363: --
4364: l_okc_doc_type := PO_CONTERMS_UTL_GRP.get_po_contract_doctype(p_document_subtype);

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

4440: l_timezone_id := get_preparer_profile(p_document_id,p_document_type,'SERVER_TIMEZONE_ID'); --Bug 6692126
4441: SELECT name, gmt_deviation_hours into l_timezone, l_offset from HZ_TIMEZONES_VL where timezone_id=to_number(l_timezone_id);
4442: EXCEPTION
4443: WHEN OTHERS THEN
4444: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4445: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||'Timezone: ','Inside Timezone Exception Handler');
4446: END IF;
4447: RAISE;
4448: END;

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

4441: SELECT name, gmt_deviation_hours into l_timezone, l_offset from HZ_TIMEZONES_VL where timezone_id=to_number(l_timezone_id);
4442: EXCEPTION
4443: WHEN OTHERS THEN
4444: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4445: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||'Timezone: ','Inside Timezone Exception Handler');
4446: END IF;
4447: RAISE;
4448: END;
4449: FND_MESSAGE.SET_NAME('PO','PO_FO_TIMEZONE');

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

4944:
4945: -- : Modify queries below to include complex work information
4946:
4947: IF(p_document_type in ('PO','PA')) THEN
4948: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4949: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||'NON Release:','Entered into Non Release Query Loop');
4950: END IF;
4951:
4952: 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 4949: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||'NON Release:','Entered into Non Release Query Loop');

4945: -- : Modify queries below to include complex work information
4946:
4947: IF(p_document_type in ('PO','PA')) THEN
4948: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4949: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||'NON Release:','Entered into Non Release Query Loop');
4950: END IF;
4951:
4952: 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.
4953: IF p_which_tables = 'MAIN' THEN

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

5179: /* Bug#3698674: In 8i db, the functions used to retrieve revision number and release id are not working
5180: properly. Created a global temporary table po_communication_pvt and retrieved the values from the
5181: global temporary table in both main and archive queries.*/
5182: IF p_which_tables = 'MAIN' THEN
5183: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5184: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||'Releases:','Entered into Release loop');
5185: END IF;
5186:
5187: l_xml_query := 'SELECT phx.*, PO_COMMUNICATION_PVT.getDocumentType() document_type, PO_COMMUNICATION_PVT.getCoverMessage() cover_message,

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

5180: properly. Created a global temporary table po_communication_pvt and retrieved the values from the
5181: global temporary table in both main and archive queries.*/
5182: IF p_which_tables = 'MAIN' THEN
5183: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5184: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||'Releases:','Entered into Release loop');
5185: END IF;
5186:
5187: l_xml_query := 'SELECT phx.*, PO_COMMUNICATION_PVT.getDocumentType() document_type, PO_COMMUNICATION_PVT.getCoverMessage() cover_message,
5188: PO_COMMUNICATION_PVT.getTimezone() timezone,PO_COMMUNICATION_PVT.getAmendmentMessage() ammendment_message,PO_COMMUNICATION_PVT.getTestFlag() test_flag,

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

5195:
5196: SELECT count(*) into l_count FROM po_line_locations_all WHERE po_release_id = p_document_id ;
5197:
5198: IF l_count >0 THEN
5199: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5200: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||'Releases:','Assigning Releases line/line locations query');
5201: END IF;
5202: -- Added release id in condition
5203: --Bug 5506417: Added order by pllx.shipment_num and order by plx.line_num clauses

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

5196: SELECT count(*) into l_count FROM po_line_locations_all WHERE po_release_id = p_document_id ;
5197:
5198: IF l_count >0 THEN
5199: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5200: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||'Releases:','Assigning Releases line/line locations query');
5201: END IF;
5202: -- Added release id in condition
5203: --Bug 5506417: Added order by pllx.shipment_num and order by plx.line_num clauses
5204: l_xml_query := 'SELECT phx.*, PO_COMMUNICATION_PVT.getDocumentType() document_type, PO_COMMUNICATION_PVT.getCoverMessage() cover_message,

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

5227:
5228:
5229:
5230: ELSIF p_which_tables = 'ARCHIVE' THEN
5231: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5232: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||'Release Archive:','Assigning Releases Archive Query');
5233: END IF;
5234:
5235: /* The following query gets the release details, the outermost cursor selects headers information,

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

5228:
5229:
5230: ELSIF p_which_tables = 'ARCHIVE' THEN
5231: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5232: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||'Release Archive:','Assigning Releases Archive Query');
5233: END IF;
5234:
5235: /* The following query gets the release details, the outermost cursor selects headers information,
5236: and we move to the details (line, shipments, distributions) as we move inside each cursor. The

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

5389: AND pllx.po_header_id = PO_COMMUNICATION_PVT.getReleaseHeaderId()
5390: order by seq_num'; --bug6133951
5391:
5392: select TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') into l_time from dual;
5393: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5394: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||'Start of executing queries', l_time);
5395: END IF;
5396:
5397:

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

5390: order by seq_num'; --bug6133951
5391:
5392: select TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') into l_time from dual;
5393: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5394: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||'Start of executing queries', l_time);
5395: END IF;
5396:
5397:
5398: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

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

5394: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||'Start of executing queries', l_time);
5395: END IF;
5396:
5397:
5398: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5399: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||'POXMLGEN','Generating XML using XMLGEN');
5400: END IF;
5401: l_xml9_stmt := 'declare
5402: context DBMS_XMLGEN.ctxHandle;

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

5395: END IF;
5396:
5397:
5398: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5399: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||'POXMLGEN','Generating XML using XMLGEN');
5400: END IF;
5401: l_xml9_stmt := 'declare
5402: context DBMS_XMLGEN.ctxHandle;
5403: l_xml_query varchar2(15000) ;

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

5418: l_disAttach_query := :4;
5419: l_fileClob := :5;
5420:
5421: select TO_CHAR(SYSDATE, ''DD-MON-YYYY HH24:MI:SS'') into l_time from dual;
5422: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5423: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||''Before Executing the Main Query'', l_time);
5424: END IF;
5425:
5426: context := dbms_xmlgen.newContext(l_xml_query);

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

5419: l_fileClob := :5;
5420:
5421: select TO_CHAR(SYSDATE, ''DD-MON-YYYY HH24:MI:SS'') into l_time from dual;
5422: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5423: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||''Before Executing the Main Query'', l_time);
5424: END IF;
5425:
5426: context := dbms_xmlgen.newContext(l_xml_query);
5427: dbms_xmlgen.setRowsetTag(context,''PO_DATA'');

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

5430: :xresult := dbms_xmlgen.getXML(context,DBMS_XMLGEN.NONE);
5431: dbms_xmlgen.closeContext(context);
5432:
5433: select TO_CHAR(SYSDATE, ''DD-MON-YYYY HH24:MI:SS'') into l_time from dual;
5434: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5435: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||''After Executing the Main Query'', l_time);
5436: END IF;
5437:
5438: context := dbms_xmlgen.newContext(l_headerAttach_query);

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

5431: dbms_xmlgen.closeContext(context);
5432:
5433: select TO_CHAR(SYSDATE, ''DD-MON-YYYY HH24:MI:SS'') into l_time from dual;
5434: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5435: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||''After Executing the Main Query'', l_time);
5436: END IF;
5437:
5438: context := dbms_xmlgen.newContext(l_headerAttach_query);
5439: dbms_xmlgen.setRowsetTag(context,''HEADER_ATTACHMENTS'');

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

5442: :xheaderAttach := dbms_xmlgen.getXML(context,DBMS_XMLGEN.NONE);
5443: dbms_xmlgen.closeContext(context);
5444:
5445: select TO_CHAR(SYSDATE, ''DD-MON-YYYY HH24:MI:SS'') into l_time from dual;
5446: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5447: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||''After Executing the header attachment Query'', l_time);
5448: END IF;
5449:
5450: context := dbms_xmlgen.newContext(l_lineAttach_query);

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

5443: dbms_xmlgen.closeContext(context);
5444:
5445: select TO_CHAR(SYSDATE, ''DD-MON-YYYY HH24:MI:SS'') into l_time from dual;
5446: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5447: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||''After Executing the header attachment Query'', l_time);
5448: END IF;
5449:
5450: context := dbms_xmlgen.newContext(l_lineAttach_query);
5451: dbms_xmlgen.setRowsetTag(context,''LINE_ATTACHMENTS'');

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

5454: :xlineAttach := dbms_xmlgen.getXML(context,DBMS_XMLGEN.NONE);
5455: dbms_xmlgen.closeContext(context);
5456:
5457: select TO_CHAR(SYSDATE, ''DD-MON-YYYY HH24:MI:SS'') into l_time from dual;
5458: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5459: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||''After Executing the line attachment Query'', l_time);
5460: END IF;
5461:
5462: context := dbms_xmlgen.newContext(l_disAttach_query);

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

5455: dbms_xmlgen.closeContext(context);
5456:
5457: select TO_CHAR(SYSDATE, ''DD-MON-YYYY HH24:MI:SS'') into l_time from dual;
5458: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5459: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||''After Executing the line attachment Query'', l_time);
5460: END IF;
5461:
5462: context := dbms_xmlgen.newContext(l_disAttach_query);
5463: dbms_xmlgen.setRowsetTag(context,''SHIPMENT_ATTACHMENTS'');

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

5466: :xdisAttach := dbms_xmlgen.getXML(context,DBMS_XMLGEN.NONE);
5467: dbms_xmlgen.closeContext(context);
5468:
5469: select TO_CHAR(SYSDATE, ''DD-MON-YYYY HH24:MI:SS'') into l_time from dual;
5470: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5471: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||''After Executing the shipment attachment Query'', l_time);
5472: END IF;
5473:
5474: IF l_fileClob is not null THEN

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

5467: dbms_xmlgen.closeContext(context);
5468:
5469: select TO_CHAR(SYSDATE, ''DD-MON-YYYY HH24:MI:SS'') into l_time from dual;
5470: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5471: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||''After Executing the shipment attachment Query'', l_time);
5472: END IF;
5473:
5474: IF l_fileClob is not null THEN
5475:

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

5479: DBMS_XMLGEN.setRowSetTag(context,NULL);
5480: :xfileClob := DBMS_XMLGEN.getXML(context,DBMS_XMLGEN.NONE);
5481: DBMS_XMLGEN.closeContext(context);
5482: close refcur;
5483: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5484: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name , ''After executing the file clob'');
5485: END IF;
5486: ELSE
5487: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

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

5480: :xfileClob := DBMS_XMLGEN.getXML(context,DBMS_XMLGEN.NONE);
5481: DBMS_XMLGEN.closeContext(context);
5482: close refcur;
5483: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5484: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name , ''After executing the file clob'');
5485: END IF;
5486: ELSE
5487: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5488: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name , ''Value of File clob is null'');

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

5483: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5484: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name , ''After executing the file clob'');
5485: END IF;
5486: ELSE
5487: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5488: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name , ''Value of File clob is null'');
5489: END IF;
5490: :xfileClob := null;
5491: END IF;

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

5484: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name , ''After executing the file clob'');
5485: END IF;
5486: ELSE
5487: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5488: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name , ''Value of File clob is null'');
5489: END IF;
5490: :xfileClob := null;
5491: END IF;
5492:

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

5492:
5493: -- bug#3580225 Start --
5494:
5495: select TO_CHAR(SYSDATE, ''DD-MON-YYYY HH24:MI:SS'') into l_time from dual;
5496: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5497: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||''Before calling PO_HR_LOCATION.populate_gt'', l_time);
5498: END IF;
5499:
5500: /* Call PO_HR_LOCATION.populate_gt procedure to insert address values into global temp table from PL/SQL table*/

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

5493: -- bug#3580225 Start --
5494:
5495: select TO_CHAR(SYSDATE, ''DD-MON-YYYY HH24:MI:SS'') into l_time from dual;
5496: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5497: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||''Before calling PO_HR_LOCATION.populate_gt'', l_time);
5498: END IF;
5499:
5500: /* Call PO_HR_LOCATION.populate_gt procedure to insert address values into global temp table from PL/SQL table*/
5501: PO_HR_LOCATION.populate_gt();

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

5519: OUT l_xml_result, OUT l_headerAttachments, OUT l_line_Attachments, OUT l_disAttachments, OUT l_fileClob, OUT l_address_details;
5520:
5521:
5522: select TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') into l_time from dual;
5523: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5524: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||'End of executing queries', l_time);
5525: END IF;
5526:
5527: /*Delete the records from global temp table*/

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

5520:
5521:
5522: select TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') into l_time from dual;
5523: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5524: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||'End of executing queries', l_time);
5525: END IF;
5526:
5527: /*Delete the records from global temp table*/
5528: DELETE po_address_details_gt;

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

5531:
5532:
5533:
5534: IF dbms_lob.getlength(l_xml_result) >0 THEN
5535: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5536: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name , 'inside manuplating l_xml_result');
5537: END IF;
5538: -- add charset.
5539: l_resultOffset := DBMS_LOB.INSTR(l_xml_result,'>');

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

5532:
5533:
5534: IF dbms_lob.getlength(l_xml_result) >0 THEN
5535: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5536: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name , 'inside manuplating l_xml_result');
5537: END IF;
5538: -- add charset.
5539: l_resultOffset := DBMS_LOB.INSTR(l_xml_result,'>');
5540: l_tempXMLResult := l_xml_result;

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

5544: IF dbms_lob.getlength(l_headerAttachments) >0 THEN
5545:
5546: l_variablePosition := DBMS_LOB.INSTR(l_headerAttachments,'>');
5547: 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);
5548: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5549: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ,'Added header attachments to XML');
5550: END IF;
5551:
5552: END IF;

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

5545:
5546: l_variablePosition := DBMS_LOB.INSTR(l_headerAttachments,'>');
5547: 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);
5548: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5549: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ,'Added header attachments to XML');
5550: END IF;
5551:
5552: END IF;
5553:

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

5559: 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);
5560: ELSE
5561: 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);
5562: END IF;
5563: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5564: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ,'Added line attachments to XML');
5565: END IF;
5566:
5567:

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

5560: ELSE
5561: 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);
5562: END IF;
5563: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5564: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ,'Added line attachments to XML');
5565: END IF;
5566:
5567:
5568: END IF;

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

5574: 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);
5575: ELSE
5576: dbms_lob.copy(l_xml_result, l_disAttachments, dbms_lob.getlength(l_disAttachments)- l_variablePosition, dbms_lob.getlength(l_xml_result), l_variablePosition+1);
5577: END IF;
5578: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5579: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ,'Added distribution attachments to XML');
5580: END IF;
5581:
5582: END IF;

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

5575: ELSE
5576: dbms_lob.copy(l_xml_result, l_disAttachments, dbms_lob.getlength(l_disAttachments)- l_variablePosition, dbms_lob.getlength(l_xml_result), l_variablePosition+1);
5577: END IF;
5578: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5579: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ,'Added distribution attachments to XML');
5580: END IF;
5581:
5582: END IF;
5583:

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

5588: 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);
5589: ELSE
5590: dbms_lob.copy(l_xml_result, l_fileClob, dbms_lob.getlength(l_fileClob)- l_variablePosition, dbms_lob.getlength(l_xml_result), l_variablePosition+1);
5591: END IF;
5592: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5593: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ,'Added file to XML');
5594: END IF;
5595:
5596:

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

5589: ELSE
5590: dbms_lob.copy(l_xml_result, l_fileClob, dbms_lob.getlength(l_fileClob)- l_variablePosition, dbms_lob.getlength(l_xml_result), l_variablePosition+1);
5591: END IF;
5592: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5593: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ,'Added file to XML');
5594: END IF;
5595:
5596:
5597: END IF;

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

5605: 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);
5606: ELSE
5607: 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);
5608: END IF;
5609: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5610: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ,'Added Address details to XML');
5611: END IF;
5612:
5613:

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

5606: ELSE
5607: 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);
5608: END IF;
5609: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5610: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ,'Added Address details to XML');
5611: END IF;
5612:
5613:
5614: END IF; -- bug#3580225 end --

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

5628: dbms_lob.write(l_xml_result,11,dbms_lob.getlength(l_xml_result)-9,'');
5629: dbms_lob.write(l_xml_result,length(l_xml_query||' '),dbms_lob.getlength(l_xml_result)+1,l_xml_query||' ');
5630:
5631: END IF;
5632: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5633: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ,'END OF POXMLGEN');
5634: END IF;
5635:
5636:

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

5629: dbms_lob.write(l_xml_result,length(l_xml_query||' '),dbms_lob.getlength(l_xml_result)+1,l_xml_query||' ');
5630:
5631: END IF;
5632: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5633: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ,'END OF POXMLGEN');
5634: END IF;
5635:
5636:
5637: RETURN l_xml_result;

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

5637: RETURN l_xml_result;
5638: EXCEPTION
5639:
5640: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5641: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5642: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name , SQLERRM);
5643: END IF;
5644: RAISE;
5645: WHEN OTHERS THEN

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

5638: EXCEPTION
5639:
5640: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5641: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5642: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name , SQLERRM);
5643: END IF;
5644: RAISE;
5645: WHEN OTHERS THEN
5646: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

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

5642: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name , SQLERRM);
5643: END IF;
5644: RAISE;
5645: WHEN OTHERS THEN
5646: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5647: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name , SQLERRM);
5648: END IF;
5649: RAISE;
5650:

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

5643: END IF;
5644: RAISE;
5645: WHEN OTHERS THEN
5646: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5647: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name , SQLERRM);
5648: END IF;
5649: RAISE;
5650:
5651: END;