DBA Data[Home] [Help]

APPS.CSF_SPATIAL_DATALOAD_PUB dependencies on CSF_SPATIAL_DATALOAD_PUB

Line 1: PACKAGE BODY CSF_SPATIAL_DATALOAD_PUB AS

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,

Line 88: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'CSF_SPATIAL_DATALOAD_PUB.PRE_INSTALLATION_STEPS PROCEDURE HAS FAILED '|| SQLCODE||'-'|| SQLERRM);

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;

Line 89: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output,'CSF_SPATIAL_DATALOAD_PUB.PRE_INSTALLATION_STEPS PROCEDURE HAS FAILED '|| SQLCODE||'-'|| SQLERRM);

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;

Line 94: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'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;
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:

Line 95: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output,'CSF_SPATIAL_DATALOAD_PUB.PRE_INSTALLATION_STEPS PROCEDURE HAS FAILED '|| SQLCODE||'-'|| SQLERRM);

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

Line 270: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'CSF_SPATIAL_DATALOAD_PUB.POST_INSTALLATION_STEPS PROCEDURE HAS FAILED '|| SQLERRM);

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;

Line 271: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output,'CSF_SPATIAL_DATALOAD_PUB.POST_INSTALLATION_STEPS PROCEDURE HAS FAILED '|| SQLERRM);

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

Line 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

Line 276: 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
280: -- Step 3: Re-compute Statistics on the Spatial Tables

Line 383: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'CSF_SPATIAL_DATALOAD_PUB.POST_INST_REFRESH_MVS PROCEDURE HAS FAILED '|| SQLERRM);

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;

Line 384: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output,'CSF_SPATIAL_DATALOAD_PUB.POST_INST_REFRESH_MVS PROCEDURE HAS FAILED '|| SQLERRM);

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;

Line 389: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'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;
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:

Line 390: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output,'CSF_SPATIAL_DATALOAD_PUB.POST_INST_REFRESH_MVS PROCEDURE HAS FAILED '|| SQLERRM);

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:

Line 395: End CSF_SPATIAL_DATALOAD_PUB;

391:
392: END POST_INST_REFRESH_MVS;
393:
394:
395: End CSF_SPATIAL_DATALOAD_PUB;
396: