APPS.AS_SC_DENORM dependencies on FND_API

Line 129: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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');

Line 132: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR ;

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);

Line 506: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

502: ERRBUF := ERRBUF||sqlerrm;
503: RETCODE := '1';
504: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'Error in insert_scd: '||SQLCODE);
505: Write_Log(l_module, G_DEBUG_CONCURRENT, 1,substr(sqlerrm,1,700));
506: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
507: END insert_scd;
508:
509: PROCEDURE Bulk_update_sc_Denorm (ERRBUF OUT NOCOPY varchar2,
510: RETCODE OUT NOCOPY varchar2,

Line 558: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

554: ERRBUF := ERRBUF||sqlerrm;
555: RETCODE := '1';
556: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'Error in Update_Sc_Denorm: ' || SQLCODE);
557: Write_Log(l_module, G_DEBUG_CONCURRENT, 1,substr(sqlerrm,1,700));
558: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
559: END Bulk_update_sc_Denorm;
560:
561: PROCEDURE Refresh_SC_Denorm(ERRBUF OUT NOCOPY varchar2, RETCODE OUT NOCOPY varchar2) IS
562: CURSOR scd_columns IS

Line 717: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

713: COMMIT;
714: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'Number of rows processed in AS_SALES_CREDITS_DENORM: '||l_row_count);
715: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'Number of rows updated in AS_SALES_CREDITS_DENORM: ' || l_row_updated);
716: EXCEPTION
717: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
718: ERRBUF := ERRBUF||'Error in Refresh_SC_Denorm: '||to_char(sqlcode);
719: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;
720: Write_Log(l_module, G_DEBUG_CONCURRENT, 1,'Error in Refresh_SC_Denorm');
721: Write_Log(l_module, G_DEBUG_CONCURRENT, 1,sqlerrm);

Line 719: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;

715: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'Number of rows updated in AS_SALES_CREDITS_DENORM: ' || l_row_updated);
716: EXCEPTION
717: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
718: ERRBUF := ERRBUF||'Error in Refresh_SC_Denorm: '||to_char(sqlcode);
719: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;
720: Write_Log(l_module, G_DEBUG_CONCURRENT, 1,'Error in Refresh_SC_Denorm');
721: Write_Log(l_module, G_DEBUG_CONCURRENT, 1,sqlerrm);
722: ROLLBACK;
723: WHEN OTHERS THEN

Line 802: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

798: END IF;
799:
800: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'Process Completed @: '||to_char(sysdate,'DD-MON-RRRR:HH:MI:SS'));
801:
802: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
803: ERRBUF := ERRBUF||'Error in SC Denorm Main:'||to_char(sqlcode)||sqlerrm;
804: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR ;
805: Write_Log(l_module, G_DEBUG_CONCURRENT, 1,'Error in SC Denorm Main');
806: Write_Log(l_module, G_DEBUG_CONCURRENT, 1,sqlerrm);

Line 804: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR ;

800: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'Process Completed @: '||to_char(sysdate,'DD-MON-RRRR:HH:MI:SS'));
801:
802: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
803: ERRBUF := ERRBUF||'Error in SC Denorm Main:'||to_char(sqlcode)||sqlerrm;
804: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR ;
805: Write_Log(l_module, G_DEBUG_CONCURRENT, 1,'Error in SC Denorm Main');
806: Write_Log(l_module, G_DEBUG_CONCURRENT, 1,sqlerrm);
807: ROLLBACK;
808: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);