1: PACKAGE BODY CSF_SPATIAL_DATALOAD_PUB AS
2: /* $Header: CSFPSDLB.pls 120.4 2009/10/28 06:03:24 vpalle noship $ */
3:
4: PROCEDURE PRE_INSTALLATION_STEPS (
5: errbuf OUT NOCOPY VARCHAR2,
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);
90:
91: WHEN OTHERS THEN
92: retcode := l_rc_err;
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);
90:
91: WHEN OTHERS THEN
92: retcode := l_rc_err;
93: errbuf := l_msg_err;
90:
91: WHEN OTHERS THEN
92: retcode := l_rc_err;
93: errbuf := l_msg_err;
94: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'CSF_SPATIAL_DATALOAD_PUB.PRE_INSTALLATION_STEPS PROCEDURE HAS FAILED '|| SQLCODE||'-'|| SQLERRM);
95: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output,'CSF_SPATIAL_DATALOAD_PUB.PRE_INSTALLATION_STEPS PROCEDURE HAS FAILED '|| SQLCODE||'-'|| SQLERRM);
96:
97: END PRE_INSTALLATION_STEPS;
98:
91: WHEN OTHERS THEN
92: retcode := l_rc_err;
93: errbuf := l_msg_err;
94: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'CSF_SPATIAL_DATALOAD_PUB.PRE_INSTALLATION_STEPS PROCEDURE HAS FAILED '|| SQLCODE||'-'|| SQLERRM);
95: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output,'CSF_SPATIAL_DATALOAD_PUB.PRE_INSTALLATION_STEPS PROCEDURE HAS FAILED '|| SQLCODE||'-'|| SQLERRM);
96:
97: END PRE_INSTALLATION_STEPS;
98:
99: -- Navteq Spatial Dataset - Post Installation Steps
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);
272: WHEN OTHERS THEN
273: retcode := l_rc_err;
274: errbuf := l_msg_err;
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);
272: WHEN OTHERS THEN
273: retcode := l_rc_err;
274: errbuf := l_msg_err;
275: 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);
272: WHEN OTHERS THEN
273: retcode := l_rc_err;
274: errbuf := l_msg_err;
275: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'CSF_SPATIAL_DATALOAD_PUB.POST_INSTALLATION_STEPS PROCEDURE HAS FAILED '|| SQLERRM);
276: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output,'CSF_SPATIAL_DATALOAD_PUB.POST_INSTALLATION_STEPS PROCEDURE HAS FAILED '|| SQLERRM);
277: END POST_INSTALLATION_STEPS;
278:
279: -- Navteq Spatial Dataset - Post Installation Steps
272: WHEN OTHERS THEN
273: retcode := l_rc_err;
274: errbuf := l_msg_err;
275: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'CSF_SPATIAL_DATALOAD_PUB.POST_INSTALLATION_STEPS PROCEDURE HAS FAILED '|| SQLERRM);
276: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output,'CSF_SPATIAL_DATALOAD_PUB.POST_INSTALLATION_STEPS PROCEDURE HAS FAILED '|| SQLERRM);
277: END POST_INSTALLATION_STEPS;
278:
279: -- Navteq Spatial Dataset - Post Installation Steps
280: -- Step 3: Re-compute Statistics on the Spatial Tables
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);
385:
386: WHEN OTHERS THEN
387: retcode := l_rc_err;
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);
385:
386: WHEN OTHERS THEN
387: retcode := l_rc_err;
388: errbuf := l_msg_err;
385:
386: WHEN OTHERS THEN
387: retcode := l_rc_err;
388: errbuf := l_msg_err;
389: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'CSF_SPATIAL_DATALOAD_PUB.POST_INST_REFRESH_MVS PROCEDURE HAS FAILED '|| SQLERRM);
390: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output,'CSF_SPATIAL_DATALOAD_PUB.POST_INST_REFRESH_MVS PROCEDURE HAS FAILED '|| SQLERRM);
391:
392: END POST_INST_REFRESH_MVS;
393:
386: WHEN OTHERS THEN
387: retcode := l_rc_err;
388: errbuf := l_msg_err;
389: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'CSF_SPATIAL_DATALOAD_PUB.POST_INST_REFRESH_MVS PROCEDURE HAS FAILED '|| SQLERRM);
390: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output,'CSF_SPATIAL_DATALOAD_PUB.POST_INST_REFRESH_MVS PROCEDURE HAS FAILED '|| SQLERRM);
391:
392: END POST_INST_REFRESH_MVS;
393:
394:
391:
392: END POST_INST_REFRESH_MVS;
393:
394:
395: End CSF_SPATIAL_DATALOAD_PUB;
396: