DBA Data[Home] [Help]

APPS.CSF_SPATIAL_DATALOAD_PUB dependencies on FND_API

Line 85: WHEN FND_API.G_EXC_ERROR THEN

81: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output,'Pre installations steps completed successfully') ;
82: END IF;
83:
84: EXCEPTION
85: WHEN FND_API.G_EXC_ERROR THEN
86: retcode := l_rc_err;
87: errbuf := l_msg_err;
88: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'CSF_SPATIAL_DATALOAD_PUB.PRE_INSTALLATION_STEPS PROCEDURE HAS FAILED '|| SQLCODE||'-'|| SQLERRM);
89: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output,'CSF_SPATIAL_DATALOAD_PUB.PRE_INSTALLATION_STEPS PROCEDURE HAS FAILED '|| SQLCODE||'-'|| SQLERRM);

Line 146: RAISE FND_API.G_EXC_ERROR;

142: EXCEPTION
143: WHEN NO_DATA_FOUND THEN
144: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'Table space ''' || l_table_space ||''' does not exist.') ;
145: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output,'Table space ''' || l_table_space ||''' does not exist.') ;
146: RAISE FND_API.G_EXC_ERROR;
147:
148: WHEN OTHERS THEN
149: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'SELECT FROM SYS.DBA_DATA_FILES is failed : '||SQLCODE||'-'|| SQLERRM) ;
150: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output,'SELECT FROM SYS.DBA_DATA_FILES is failed : '||SQLCODE||'-'|| SQLERRM) ;

Line 151: RAISE FND_API.G_EXC_ERROR;

147:
148: WHEN OTHERS THEN
149: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'SELECT FROM SYS.DBA_DATA_FILES is failed : '||SQLCODE||'-'|| SQLERRM) ;
150: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output,'SELECT FROM SYS.DBA_DATA_FILES is failed : '||SQLCODE||'-'|| SQLERRM) ;
151: RAISE FND_API.G_EXC_ERROR;
152: END;
153:
154: -- Get the Spatial Data set profile value
155: l_data_set_name := p_dataset_name;

Line 196: RAISE FND_API.G_EXC_ERROR;

192: EXCEPTION
193: WHEN OTHERS THEN
194: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'UPDATE hz_locations is failed : ' || SQLERRM) ;
195: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output,'UPDATE hz_locations is failed: ' || SQLERRM) ;
196: RAISE FND_API.G_EXC_ERROR;
197: END;
198:
199: -- Truncate CSF_TDS_ROUTE_CACHE TABLE. Bug : 9019583
200: CSF_SPATIAL_DATALOAD_PVT.TRUNC_ROUTE_CAHCE_TABLE(l_data_set_name,errbuf, retcode);

Line 267: WHEN FND_API.G_EXC_ERROR THEN

263: -- Refresh Materialized views
264: -- Loading Map Configuration data
265: -- This step is included in the procedure POST_INST_REFRESH_MVS.
266: EXCEPTION
267: WHEN FND_API.G_EXC_ERROR THEN
268: retcode := l_rc_err;
269: errbuf := l_msg_err;
270: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'CSF_SPATIAL_DATALOAD_PUB.POST_INSTALLATION_STEPS PROCEDURE HAS FAILED '|| SQLERRM);
271: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output,'CSF_SPATIAL_DATALOAD_PUB.POST_INSTALLATION_STEPS PROCEDURE HAS FAILED '|| SQLERRM);

Line 329: RAISE FND_API.G_EXC_ERROR;

325: EXCEPTION
326: WHEN NO_DATA_FOUND THEN
327: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'Table space ''' || l_table_space ||''' does not exist.') ;
328: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output,'Table space ''' || l_table_space ||''' does not exist.') ;
329: RAISE FND_API.G_EXC_ERROR;
330:
331: WHEN OTHERS THEN
332: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'SELECT FROM SYS.DBA_DATA_FILES is failed : '||SQLCODE||'-'|| SQLERRM) ;
333: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output,'SELECT FROM SYS.DBA_DATA_FILES is failed : '||SQLCODE||'-'|| SQLERRM) ;

Line 334: RAISE FND_API.G_EXC_ERROR;

330:
331: WHEN OTHERS THEN
332: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'SELECT FROM SYS.DBA_DATA_FILES is failed : '||SQLCODE||'-'|| SQLERRM) ;
333: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output,'SELECT FROM SYS.DBA_DATA_FILES is failed : '||SQLCODE||'-'|| SQLERRM) ;
334: RAISE FND_API.G_EXC_ERROR;
335: END;
336:
337: -- Get the Spatial Data set profile value
338: l_data_set_name := p_dataset_name;

Line 380: WHEN FND_API.G_EXC_ERROR THEN

376: END IF;
377: END IF;
378:
379: EXCEPTION
380: WHEN FND_API.G_EXC_ERROR THEN
381: retcode := l_rc_err;
382: errbuf := l_msg_err;
383: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'CSF_SPATIAL_DATALOAD_PUB.POST_INST_REFRESH_MVS PROCEDURE HAS FAILED '|| SQLERRM);
384: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output,'CSF_SPATIAL_DATALOAD_PUB.POST_INST_REFRESH_MVS PROCEDURE HAS FAILED '|| SQLERRM);