239: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
240: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_log_module,
241: 'Exception occured while deleting CSFW_MSESSION_COOKIE sqlerrm = ' || sqlerrm);
242: end if;
243: fnd_message.set_name('CSF', 'CSF_CP_DONE_ERROR');
244: errbuf := fnd_message.get;
245: retcode := 2;
246: return;
247: end;
240: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_log_module,
241: 'Exception occured while deleting CSFW_MSESSION_COOKIE sqlerrm = ' || sqlerrm);
242: end if;
243: fnd_message.set_name('CSF', 'CSF_CP_DONE_ERROR');
244: errbuf := fnd_message.get;
245: retcode := 2;
246: return;
247: end;
248: -- end block for CSFW_MSESSION_COOKIE
271: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
272: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_log_module,
273: 'Exception occured while deleting CSFW_MSESSION_URL sqlerrm = ' || sqlerrm);
274: end if;
275: fnd_message.set_name('CSF', 'CSF_CP_DONE_ERROR');
276: errbuf := fnd_message.get;
277: retcode := 2;
278: return;
279: end;
272: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_log_module,
273: 'Exception occured while deleting CSFW_MSESSION_URL sqlerrm = ' || sqlerrm);
274: end if;
275: fnd_message.set_name('CSF', 'CSF_CP_DONE_ERROR');
276: errbuf := fnd_message.get;
277: retcode := 2;
278: return;
279: end;
280: -- end block for CSFW_MSESSION_URL
300: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
301: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_log_module,
302: 'Exception occured while deleting CSFW_MSESSION sqlerrm = ' || sqlerrm);
303: end if;
304: fnd_message.set_name('CSF', 'CSF_CP_DONE_ERROR');
305: errbuf := fnd_message.get;
306: retcode := 2;
307: return;
308: end;
301: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_log_module,
302: 'Exception occured while deleting CSFW_MSESSION sqlerrm = ' || sqlerrm);
303: end if;
304: fnd_message.set_name('CSF', 'CSF_CP_DONE_ERROR');
305: errbuf := fnd_message.get;
306: retcode := 2;
307: return;
308: end;
309: -- end block for CSFW_MSESSION
334:
335: -- now we can commit
336: commit;
337:
338: fnd_message.set_name('CSF', 'CSF_CP_DONE_SUCCESS');
339: errbuf := fnd_message.get;
340: retcode := 0;
341:
342: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
335: -- now we can commit
336: commit;
337:
338: fnd_message.set_name('CSF', 'CSF_CP_DONE_SUCCESS');
339: errbuf := fnd_message.get;
340: retcode := 0;
341:
342: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
343: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_log_module,