243:
244: -- free temporary memory and close the context
245: DBMS_LOB.FREETEMPORARY (l_xml_doc);
246:
247: l_success := FND_CONCURRENT.SET_COMPLETION_STATUS('NORMAL', 'Request Completed Successfully');
248:
249: -- Write the module name to fnd log file
250:
251: IF (l_pLog) THEN
287: p_msg_data => l_msg_data,
288: x_return_status => l_return_status);
289:
290: l_msg_data := SUBSTRB (SQLERRM,1,240);
291: l_success := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', l_msg_data);
292:
293: l_conc_request := fnd_concurrent.set_completion_status('ERROR',substr(fnd_message.get_string('BOM',l_error_message),1,240));
294:
295:
289:
290: l_msg_data := SUBSTRB (SQLERRM,1,240);
291: l_success := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', l_msg_data);
292:
293: l_conc_request := fnd_concurrent.set_completion_status('ERROR',substr(fnd_message.get_string('BOM',l_error_message),1,240));
294:
295:
296: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
297: FND_MSG_PUB.Count_And_Get
305: p_msg_data => l_msg_data,
306: x_return_status => l_return_status);
307:
308: l_msg_data := SUBSTRB (SQLERRM,1,240);
309: l_success := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', l_msg_data);
310:
311: WHEN OTHERS THEN
312: IF (l_uLog) THEN
313: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,
331: p_msg_data => l_msg_data,
332: x_return_status => l_return_status);
333:
334: l_msg_data := SUBSTRB (SQLERRM,1,240);
335: l_success := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', l_msg_data);
336:
337: END Generate_MiscReportXml;
338:
339: PROCEDURE Add_Parameters