125: END LOOP;
126: COMMIT;
127:
128: EXCEPTION
129: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
130: ERRBUF := ERRBUF||'Error in Populate_as_period_days:'
131: || to_char(sqlcode) || sqlerrm;
132: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR ;
133: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'Error in Populate_as_period_days');
128: EXCEPTION
129: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
130: ERRBUF := ERRBUF||'Error in Populate_as_period_days:'
131: || to_char(sqlcode) || sqlerrm;
132: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR ;
133: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'Error in Populate_as_period_days');
134: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, sqlerrm);
135: Rollback;
136: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);
666: ERRBUF := ERRBUF||sqlerrm;
667: RETCODE := '1';
668: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'Error in insert_scd: '||SQLCODE);
669: Write_Log(l_module, G_DEBUG_CONCURRENT, 1,substr(sqlerrm,1,700));
670: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
671: END insert_scd;
672:
673: PROCEDURE Bulk_update_sc_Denorm (ERRBUF OUT NOCOPY varchar2,
674: RETCODE OUT NOCOPY varchar2,
718: ERRBUF := ERRBUF||sqlerrm;
719: RETCODE := '1';
720: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'Error in Update_Sc_Denorm: ' || SQLCODE);
721: Write_Log(l_module, G_DEBUG_CONCURRENT, 1,substr(sqlerrm,1,700));
722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
723: END Bulk_update_sc_Denorm;
724:
725: PROCEDURE Refresh_SC_Denorm(ERRBUF OUT NOCOPY varchar2, RETCODE OUT NOCOPY varchar2) IS
726: CURSOR scd_columns IS
877: COMMIT;
878: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'Number of rows processed in AS_SALES_CREDITS_DENORM: '||l_row_count);
879: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'Number of rows updated in AS_SALES_CREDITS_DENORM: ' || l_row_updated);
880: EXCEPTION
881: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
882: ERRBUF := ERRBUF||'Error in Refresh_SC_Denorm: '||to_char(sqlcode);
883: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;
884: Write_Log(l_module, G_DEBUG_CONCURRENT, 1,'Error in Refresh_SC_Denorm');
885: Write_Log(l_module, G_DEBUG_CONCURRENT, 1,sqlerrm);
879: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'Number of rows updated in AS_SALES_CREDITS_DENORM: ' || l_row_updated);
880: EXCEPTION
881: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
882: ERRBUF := ERRBUF||'Error in Refresh_SC_Denorm: '||to_char(sqlcode);
883: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;
884: Write_Log(l_module, G_DEBUG_CONCURRENT, 1,'Error in Refresh_SC_Denorm');
885: Write_Log(l_module, G_DEBUG_CONCURRENT, 1,sqlerrm);
886: ROLLBACK;
887: WHEN OTHERS THEN
962: END IF;
963:
964: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'Process Completed @: '||to_char(sysdate,'DD-MON-RRRR:HH:MI:SS'));
965:
966: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
967: ERRBUF := ERRBUF||'Error in SC Denorm Main:'||to_char(sqlcode)||sqlerrm;
968: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR ;
969: Write_Log(l_module, G_DEBUG_CONCURRENT, 1,'Error in SC Denorm Main');
970: Write_Log(l_module, G_DEBUG_CONCURRENT, 1,sqlerrm);
964: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'Process Completed @: '||to_char(sysdate,'DD-MON-RRRR:HH:MI:SS'));
965:
966: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
967: ERRBUF := ERRBUF||'Error in SC Denorm Main:'||to_char(sqlcode)||sqlerrm;
968: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR ;
969: Write_Log(l_module, G_DEBUG_CONCURRENT, 1,'Error in SC Denorm Main');
970: Write_Log(l_module, G_DEBUG_CONCURRENT, 1,sqlerrm);
971: ROLLBACK;
972: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);