70: where a.lead_id not in ( select log.lead_id from AS_LEADS_LOG log);
71:
72: write_log(l_module, G_DEBUG_CONCURRENT, 1, 'Refresh of as_leads_log Process Completed @: '||to_char(sysdate,'DD-MON-RRRR:HH:MI:SS'));
73: COMMIT;
74: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
75: ERRBUF := ERRBUF||'Error in logging updation of AS_LEADS_LOG:'||to_char(sqlcode)||sqlerrm;
76: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR ;
77: write_log(l_module, G_DEBUG_CONCURRENT, 1,'Error in logging updation of AS_LEADS_LOG');
78: write_log(l_module, G_DEBUG_CONCURRENT, 1,sqlerrm);
72: write_log(l_module, G_DEBUG_CONCURRENT, 1, 'Refresh of as_leads_log Process Completed @: '||to_char(sysdate,'DD-MON-RRRR:HH:MI:SS'));
73: COMMIT;
74: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
75: ERRBUF := ERRBUF||'Error in logging updation of AS_LEADS_LOG:'||to_char(sqlcode)||sqlerrm;
76: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR ;
77: write_log(l_module, G_DEBUG_CONCURRENT, 1,'Error in logging updation of AS_LEADS_LOG');
78: write_log(l_module, G_DEBUG_CONCURRENT, 1,sqlerrm);
79: ROLLBACK;
80: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);
111: FROM AS_LEAD_LINES_ALL a
112: where a.lead_line_id not in ( select log.lead_line_id from AS_LEAD_LINES_LOG log);
113: write_log(l_module, G_DEBUG_CONCURRENT, 1, 'Refresh of as_lead_lines_log Process Completed @: '||to_char(sysdate,'DD-MON-RRRR:HH:MI:SS'));
114: COMMIT;
115: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
116: ERRBUF := ERRBUF||'Error in loging of AS_LEAD_LINES_LOG:'||to_char(sqlcode)||sqlerrm;
117: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR ;
118: write_log(l_module, G_DEBUG_CONCURRENT, 1,'Error in loging of AS_LEAD_LINES_LOG');
119: write_log(l_module, G_DEBUG_CONCURRENT, 1,sqlerrm);
113: write_log(l_module, G_DEBUG_CONCURRENT, 1, 'Refresh of as_lead_lines_log Process Completed @: '||to_char(sysdate,'DD-MON-RRRR:HH:MI:SS'));
114: COMMIT;
115: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
116: ERRBUF := ERRBUF||'Error in loging of AS_LEAD_LINES_LOG:'||to_char(sqlcode)||sqlerrm;
117: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR ;
118: write_log(l_module, G_DEBUG_CONCURRENT, 1,'Error in loging of AS_LEAD_LINES_LOG');
119: write_log(l_module, G_DEBUG_CONCURRENT, 1,sqlerrm);
120: ROLLBACK;
121: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);
150: where AS_SALES_CREDITS.sales_credit_id not in (select AS_SALES_CREDITS_LOG.sales_credit_id
151: FROM AS_SALES_CREDITS_LOG);
152: write_log(l_module, G_DEBUG_CONCURRENT, 1, 'Refresh of as_sales_credits_log Process Completed @: '||to_char(sysdate,'DD-MON-RRRR:HH:MI:SS'));
153: COMMIT;
154: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
155: ERRBUF := ERRBUF||'Error in login of AS_SALES_CREDITS_LOG:'||to_char(sqlcode)||sqlerrm;
156: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR ;
157: write_log(l_module, G_DEBUG_CONCURRENT, 1,'Error in login of AS_SALES_CREDITS_LOG');
158: write_log(l_module, G_DEBUG_CONCURRENT, 1,sqlerrm);
152: write_log(l_module, G_DEBUG_CONCURRENT, 1, 'Refresh of as_sales_credits_log Process Completed @: '||to_char(sysdate,'DD-MON-RRRR:HH:MI:SS'));
153: COMMIT;
154: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
155: ERRBUF := ERRBUF||'Error in login of AS_SALES_CREDITS_LOG:'||to_char(sqlcode)||sqlerrm;
156: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR ;
157: write_log(l_module, G_DEBUG_CONCURRENT, 1,'Error in login of AS_SALES_CREDITS_LOG');
158: write_log(l_module, G_DEBUG_CONCURRENT, 1,sqlerrm);
159: ROLLBACK;
160: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);