eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSF_SPATIAL_DATALOAD_PUB dependencies on CSF_SPATIAL_DATALOAD_PVT

Line 44: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'Data set name : ' || l_data_set_name) ;

40: ELSE
41: l_data_set_name := '_' || l_data_set_name;
42: END IF;
43:
44: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'Data set name : ' || l_data_set_name) ;
45: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'') ;
46:
47: -- Drop Map Display related indexes.
48: CSF_SPATIAL_DATALOAD_PVT.DROP_INDEXES(l_data_set_name, 'MD', errbuf, retcode);

Line 45: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'') ;

41: l_data_set_name := '_' || l_data_set_name;
42: END IF;
43:
44: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'Data set name : ' || l_data_set_name) ;
45: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'') ;
46:
47: -- Drop Map Display related indexes.
48: CSF_SPATIAL_DATALOAD_PVT.DROP_INDEXES(l_data_set_name, 'MD', errbuf, retcode);
49: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'Dropped the MD indexes successfully') ;

Line 48: CSF_SPATIAL_DATALOAD_PVT.DROP_INDEXES(l_data_set_name, 'MD', errbuf, retcode);

44: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'Data set name : ' || l_data_set_name) ;
45: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'') ;
46:
47: -- Drop Map Display related indexes.
48: CSF_SPATIAL_DATALOAD_PVT.DROP_INDEXES(l_data_set_name, 'MD', errbuf, retcode);
49: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'Dropped the MD indexes successfully') ;
50: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'') ;
51: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output,'Dropped the MD indexes successfully') ;
52:

Line 49: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'Dropped the MD indexes successfully') ;

45: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'') ;
46:
47: -- Drop Map Display related indexes.
48: CSF_SPATIAL_DATALOAD_PVT.DROP_INDEXES(l_data_set_name, 'MD', errbuf, retcode);
49: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'Dropped the MD indexes successfully') ;
50: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'') ;
51: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output,'Dropped the MD indexes successfully') ;
52:
53: -- Drop Location Finder related indexes.

Line 50: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'') ;

46:
47: -- Drop Map Display related indexes.
48: CSF_SPATIAL_DATALOAD_PVT.DROP_INDEXES(l_data_set_name, 'MD', errbuf, retcode);
49: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'Dropped the MD indexes successfully') ;
50: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'') ;
51: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output,'Dropped the MD indexes successfully') ;
52:
53: -- Drop Location Finder related indexes.
54: CSF_SPATIAL_DATALOAD_PVT.DROP_INDEXES(l_data_set_name, 'LF', errbuf, retcode);

Line 51: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output,'Dropped the MD indexes successfully') ;

47: -- Drop Map Display related indexes.
48: CSF_SPATIAL_DATALOAD_PVT.DROP_INDEXES(l_data_set_name, 'MD', errbuf, retcode);
49: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'Dropped the MD indexes successfully') ;
50: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'') ;
51: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output,'Dropped the MD indexes successfully') ;
52:
53: -- Drop Location Finder related indexes.
54: CSF_SPATIAL_DATALOAD_PVT.DROP_INDEXES(l_data_set_name, 'LF', errbuf, retcode);
55: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log, 'Dropped the LF indexes successfully') ;

Line 54: CSF_SPATIAL_DATALOAD_PVT.DROP_INDEXES(l_data_set_name, 'LF', errbuf, retcode);

50: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'') ;
51: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output,'Dropped the MD indexes successfully') ;
52:
53: -- Drop Location Finder related indexes.
54: CSF_SPATIAL_DATALOAD_PVT.DROP_INDEXES(l_data_set_name, 'LF', errbuf, retcode);
55: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log, 'Dropped the LF indexes successfully') ;
56: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'') ;
57: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output,'Dropped the LF indexes successfully') ;
58:

Line 55: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log, 'Dropped the LF indexes successfully') ;

51: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output,'Dropped the MD indexes successfully') ;
52:
53: -- Drop Location Finder related indexes.
54: CSF_SPATIAL_DATALOAD_PVT.DROP_INDEXES(l_data_set_name, 'LF', errbuf, retcode);
55: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log, 'Dropped the LF indexes successfully') ;
56: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'') ;
57: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output,'Dropped the LF indexes successfully') ;
58:
59: -- Drop Time Distance Server related indexes.

Line 56: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'') ;

52:
53: -- Drop Location Finder related indexes.
54: CSF_SPATIAL_DATALOAD_PVT.DROP_INDEXES(l_data_set_name, 'LF', errbuf, retcode);
55: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log, 'Dropped the LF indexes successfully') ;
56: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'') ;
57: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output,'Dropped the LF indexes successfully') ;
58:
59: -- Drop Time Distance Server related indexes.
60: CSF_SPATIAL_DATALOAD_PVT.DROP_INDEXES(l_data_set_name, 'TDS', errbuf, retcode);

Line 57: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output,'Dropped the LF indexes successfully') ;

53: -- Drop Location Finder related indexes.
54: CSF_SPATIAL_DATALOAD_PVT.DROP_INDEXES(l_data_set_name, 'LF', errbuf, retcode);
55: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log, 'Dropped the LF indexes successfully') ;
56: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'') ;
57: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output,'Dropped the LF indexes successfully') ;
58:
59: -- Drop Time Distance Server related indexes.
60: CSF_SPATIAL_DATALOAD_PVT.DROP_INDEXES(l_data_set_name, 'TDS', errbuf, retcode);
61: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'Dropped the TDS indexes successfully') ;

Line 60: CSF_SPATIAL_DATALOAD_PVT.DROP_INDEXES(l_data_set_name, 'TDS', errbuf, retcode);

56: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'') ;
57: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output,'Dropped the LF indexes successfully') ;
58:
59: -- Drop Time Distance Server related indexes.
60: CSF_SPATIAL_DATALOAD_PVT.DROP_INDEXES(l_data_set_name, 'TDS', errbuf, retcode);
61: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'Dropped the TDS indexes successfully') ;
62: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'') ;
63: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output,'Dropped the TDS indexes successfully') ;
64:

Line 61: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'Dropped the TDS indexes successfully') ;

57: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output,'Dropped the LF indexes successfully') ;
58:
59: -- Drop Time Distance Server related indexes.
60: CSF_SPATIAL_DATALOAD_PVT.DROP_INDEXES(l_data_set_name, 'TDS', errbuf, retcode);
61: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'Dropped the TDS indexes successfully') ;
62: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'') ;
63: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output,'Dropped the TDS indexes successfully') ;
64:
65: -- Drop World Overview Map related indexes.

Line 62: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'') ;

58:
59: -- Drop Time Distance Server related indexes.
60: CSF_SPATIAL_DATALOAD_PVT.DROP_INDEXES(l_data_set_name, 'TDS', errbuf, retcode);
61: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'Dropped the TDS indexes successfully') ;
62: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'') ;
63: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output,'Dropped the TDS indexes successfully') ;
64:
65: -- Drop World Overview Map related indexes.
66: IF ( p_WOM_flag IS NOT NULL AND p_WOM_flag = 'Y' ) THEN

Line 63: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output,'Dropped the TDS indexes successfully') ;

59: -- Drop Time Distance Server related indexes.
60: CSF_SPATIAL_DATALOAD_PVT.DROP_INDEXES(l_data_set_name, 'TDS', errbuf, retcode);
61: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'Dropped the TDS indexes successfully') ;
62: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'') ;
63: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output,'Dropped the TDS indexes successfully') ;
64:
65: -- Drop World Overview Map related indexes.
66: IF ( p_WOM_flag IS NOT NULL AND p_WOM_flag = 'Y' ) THEN
67: CSF_SPATIAL_DATALOAD_PVT.DROP_INDEXES(l_data_set_name, 'WOM', errbuf, retcode);

Line 67: CSF_SPATIAL_DATALOAD_PVT.DROP_INDEXES(l_data_set_name, 'WOM', errbuf, retcode);

63: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output,'Dropped the TDS indexes successfully') ;
64:
65: -- Drop World Overview Map related indexes.
66: IF ( p_WOM_flag IS NOT NULL AND p_WOM_flag = 'Y' ) THEN
67: CSF_SPATIAL_DATALOAD_PVT.DROP_INDEXES(l_data_set_name, 'WOM', errbuf, retcode);
68: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'Dropped the WOM indexes successfully') ;
69: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'') ;
70: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output,'Dropped the WOM indexes successfully') ;
71: END IF;

Line 68: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'Dropped the WOM indexes successfully') ;

64:
65: -- Drop World Overview Map related indexes.
66: IF ( p_WOM_flag IS NOT NULL AND p_WOM_flag = 'Y' ) THEN
67: CSF_SPATIAL_DATALOAD_PVT.DROP_INDEXES(l_data_set_name, 'WOM', errbuf, retcode);
68: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'Dropped the WOM indexes successfully') ;
69: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'') ;
70: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output,'Dropped the WOM indexes successfully') ;
71: END IF;
72:

Line 69: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'') ;

65: -- Drop World Overview Map related indexes.
66: IF ( p_WOM_flag IS NOT NULL AND p_WOM_flag = 'Y' ) THEN
67: CSF_SPATIAL_DATALOAD_PVT.DROP_INDEXES(l_data_set_name, 'WOM', errbuf, retcode);
68: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'Dropped the WOM indexes successfully') ;
69: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'') ;
70: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output,'Dropped the WOM indexes successfully') ;
71: END IF;
72:
73: -- Drop Materialized view based indexes.

Line 70: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output,'Dropped the WOM indexes successfully') ;

66: IF ( p_WOM_flag IS NOT NULL AND p_WOM_flag = 'Y' ) THEN
67: CSF_SPATIAL_DATALOAD_PVT.DROP_INDEXES(l_data_set_name, 'WOM', errbuf, retcode);
68: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'Dropped the WOM indexes successfully') ;
69: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'') ;
70: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output,'Dropped the WOM indexes successfully') ;
71: END IF;
72:
73: -- Drop Materialized view based indexes.
74: CSF_SPATIAL_DATALOAD_PVT.DROP_INDEXES(l_data_set_name, 'MAT', errbuf, retcode);

Line 74: CSF_SPATIAL_DATALOAD_PVT.DROP_INDEXES(l_data_set_name, 'MAT', errbuf, retcode);

70: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output,'Dropped the WOM indexes successfully') ;
71: END IF;
72:
73: -- Drop Materialized view based indexes.
74: CSF_SPATIAL_DATALOAD_PVT.DROP_INDEXES(l_data_set_name, 'MAT', errbuf, retcode);
75: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'Dropped the MAT View indexes successfully') ;
76: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'') ;
77: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output,'Dropped the MAT indexes successfully') ;
78:

Line 75: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'Dropped the MAT View indexes successfully') ;

71: END IF;
72:
73: -- Drop Materialized view based indexes.
74: CSF_SPATIAL_DATALOAD_PVT.DROP_INDEXES(l_data_set_name, 'MAT', errbuf, retcode);
75: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'Dropped the MAT View indexes successfully') ;
76: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'') ;
77: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output,'Dropped the MAT indexes successfully') ;
78:
79: IF retcode = l_rc_succ THEN

Line 76: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'') ;

72:
73: -- Drop Materialized view based indexes.
74: CSF_SPATIAL_DATALOAD_PVT.DROP_INDEXES(l_data_set_name, 'MAT', errbuf, retcode);
75: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'Dropped the MAT View indexes successfully') ;
76: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'') ;
77: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output,'Dropped the MAT indexes successfully') ;
78:
79: IF retcode = l_rc_succ THEN
80: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'Pre installations steps completed successfully') ;

Line 77: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output,'Dropped the MAT indexes successfully') ;

73: -- Drop Materialized view based indexes.
74: CSF_SPATIAL_DATALOAD_PVT.DROP_INDEXES(l_data_set_name, 'MAT', errbuf, retcode);
75: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'Dropped the MAT View indexes successfully') ;
76: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'') ;
77: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output,'Dropped the MAT indexes successfully') ;
78:
79: IF retcode = l_rc_succ THEN
80: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'Pre installations steps completed successfully') ;
81: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output,'Pre installations steps completed successfully') ;

Line 80: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'Pre installations steps completed successfully') ;

76: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'') ;
77: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output,'Dropped the MAT indexes successfully') ;
78:
79: IF retcode = l_rc_succ THEN
80: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'Pre installations steps completed successfully') ;
81: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output,'Pre installations steps completed successfully') ;
82: END IF;
83:
84: EXCEPTION

Line 81: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output,'Pre installations steps completed successfully') ;

77: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output,'Dropped the MAT indexes successfully') ;
78:
79: IF retcode = l_rc_succ THEN
80: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'Pre installations steps completed successfully') ;
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

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 140: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'Table space ''' || l_table_space ||''' exists.') ;

136: EXECUTE IMMEDIATE 'SELECT 1
137: FROM SYS.DBA_DATA_FILES
138: WHERE tablespace_name = :1'
139: USING l_table_space;
140: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'Table space ''' || l_table_space ||''' exists.') ;
141:
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.') ;

Line 144: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'Table space ''' || l_table_space ||''' does not exist.') ;

140: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'Table space ''' || l_table_space ||''' exists.') ;
141:
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

Line 145: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output,'Table space ''' || l_table_space ||''' does not exist.') ;

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

Line 149: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'SELECT FROM SYS.DBA_DATA_FILES is failed : '||SQLCODE||'-'|| SQLERRM) ;

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) ;
151: RAISE FND_API.G_EXC_ERROR;
152: END;
153:

Line 150: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output,'SELECT FROM SYS.DBA_DATA_FILES is failed : '||SQLCODE||'-'|| SQLERRM) ;

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) ;
151: RAISE FND_API.G_EXC_ERROR;
152: END;
153:
154: -- Get the Spatial Data set profile value

Line 166: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'Data set name : ' || l_data_set_name) ;

162: ELSE
163: l_data_set_name := '_' || l_data_set_name;
164: END IF;
165:
166: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'Data set name : ' || l_data_set_name) ;
167: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,' ');
168:
169: --l_enable_spatial_cps := fnd_profile.vlaue('CSF_ENABLE_SPATIAL_CPS');
170:

Line 167: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,' ');

163: l_data_set_name := '_' || l_data_set_name;
164: END IF;
165:
166: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'Data set name : ' || l_data_set_name) ;
167: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,' ');
168:
169: --l_enable_spatial_cps := fnd_profile.vlaue('CSF_ENABLE_SPATIAL_CPS');
170:
171: /* Step 1: Updating HZ_LOCATIONS table

Line 190: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'UPDATE hz_locations is successfull') ;

186: WHERE l.country = sp.hr_country_code
187: AND sp.spatial_dataset = :1 )' USING l_data_set_name;
188: COMMIT;
189: END IF;
190: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'UPDATE hz_locations is successfull') ;
191:
192: EXCEPTION
193: WHEN OTHERS THEN
194: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'UPDATE hz_locations is failed : ' || SQLERRM) ;

Line 194: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'UPDATE hz_locations is failed : ' || SQLERRM) ;

190: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'UPDATE hz_locations is successfull') ;
191:
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:

Line 195: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output,'UPDATE hz_locations is failed: ' || SQLERRM) ;

191:
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

Line 200: CSF_SPATIAL_DATALOAD_PVT.TRUNC_ROUTE_CAHCE_TABLE(l_data_set_name,errbuf, retcode);

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);
201:
202: -- Validate spatial tables row count
203: CSF_SPATIAL_DATALOAD_PVT.CHECK_TABLE_ROW_COUNT(l_data_set_name,errbuf, retcode);
204:

Line 203: CSF_SPATIAL_DATALOAD_PVT.CHECK_TABLE_ROW_COUNT(l_data_set_name,errbuf, retcode);

199: -- Truncate CSF_TDS_ROUTE_CACHE TABLE. Bug : 9019583
200: CSF_SPATIAL_DATALOAD_PVT.TRUNC_ROUTE_CAHCE_TABLE(l_data_set_name,errbuf, retcode);
201:
202: -- Validate spatial tables row count
203: CSF_SPATIAL_DATALOAD_PVT.CHECK_TABLE_ROW_COUNT(l_data_set_name,errbuf, retcode);
204:
205: --BLOB size validation
206: CSF_SPATIAL_DATALOAD_PVT.VALIDATE_BLOB_SIZE(l_data_set_name,errbuf, retcode);
207:

Line 206: CSF_SPATIAL_DATALOAD_PVT.VALIDATE_BLOB_SIZE(l_data_set_name,errbuf, retcode);

202: -- Validate spatial tables row count
203: CSF_SPATIAL_DATALOAD_PVT.CHECK_TABLE_ROW_COUNT(l_data_set_name,errbuf, retcode);
204:
205: --BLOB size validation
206: CSF_SPATIAL_DATALOAD_PVT.VALIDATE_BLOB_SIZE(l_data_set_name,errbuf, retcode);
207:
208: -- Step 2: Create Spatial Indexes
209: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log, ' ' );
210: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log, 'Creating the INDEXES' );

Line 209: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log, ' ' );

205: --BLOB size validation
206: CSF_SPATIAL_DATALOAD_PVT.VALIDATE_BLOB_SIZE(l_data_set_name,errbuf, retcode);
207:
208: -- Step 2: Create Spatial Indexes
209: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log, ' ' );
210: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log, 'Creating the INDEXES' );
211: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log, '================================================ ' );
212:
213: CSF_SPATIAL_DATALOAD_PVT.CREATE_INDEXES(l_data_set_name,l_table_space, 'MD', errbuf, retcode);

Line 210: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log, 'Creating the INDEXES' );

206: CSF_SPATIAL_DATALOAD_PVT.VALIDATE_BLOB_SIZE(l_data_set_name,errbuf, retcode);
207:
208: -- Step 2: Create Spatial Indexes
209: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log, ' ' );
210: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log, 'Creating the INDEXES' );
211: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log, '================================================ ' );
212:
213: CSF_SPATIAL_DATALOAD_PVT.CREATE_INDEXES(l_data_set_name,l_table_space, 'MD', errbuf, retcode);
214: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'========== Created the MD indexes successfully ==========') ;

Line 211: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log, '================================================ ' );

207:
208: -- Step 2: Create Spatial Indexes
209: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log, ' ' );
210: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log, 'Creating the INDEXES' );
211: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log, '================================================ ' );
212:
213: CSF_SPATIAL_DATALOAD_PVT.CREATE_INDEXES(l_data_set_name,l_table_space, 'MD', errbuf, retcode);
214: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'========== Created the MD indexes successfully ==========') ;
215:

Line 213: CSF_SPATIAL_DATALOAD_PVT.CREATE_INDEXES(l_data_set_name,l_table_space, 'MD', errbuf, retcode);

209: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log, ' ' );
210: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log, 'Creating the INDEXES' );
211: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log, '================================================ ' );
212:
213: CSF_SPATIAL_DATALOAD_PVT.CREATE_INDEXES(l_data_set_name,l_table_space, 'MD', errbuf, retcode);
214: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'========== Created the MD indexes successfully ==========') ;
215:
216: -- Create LF indexes
217: CSF_SPATIAL_DATALOAD_PVT.CREATE_INDEXES(l_data_set_name,l_table_space, 'LF', errbuf, retcode);

Line 214: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'========== Created the MD indexes successfully ==========') ;

210: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log, 'Creating the INDEXES' );
211: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log, '================================================ ' );
212:
213: CSF_SPATIAL_DATALOAD_PVT.CREATE_INDEXES(l_data_set_name,l_table_space, 'MD', errbuf, retcode);
214: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'========== Created the MD indexes successfully ==========') ;
215:
216: -- Create LF indexes
217: CSF_SPATIAL_DATALOAD_PVT.CREATE_INDEXES(l_data_set_name,l_table_space, 'LF', errbuf, retcode);
218: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'========== Created the LF indexes successfully ==========') ;

Line 217: CSF_SPATIAL_DATALOAD_PVT.CREATE_INDEXES(l_data_set_name,l_table_space, 'LF', errbuf, retcode);

213: CSF_SPATIAL_DATALOAD_PVT.CREATE_INDEXES(l_data_set_name,l_table_space, 'MD', errbuf, retcode);
214: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'========== Created the MD indexes successfully ==========') ;
215:
216: -- Create LF indexes
217: CSF_SPATIAL_DATALOAD_PVT.CREATE_INDEXES(l_data_set_name,l_table_space, 'LF', errbuf, retcode);
218: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'========== Created the LF indexes successfully ==========') ;
219: -- Create TDS indexes
220: CSF_SPATIAL_DATALOAD_PVT.CREATE_INDEXES(l_data_set_name,l_table_space, 'TDS', errbuf, retcode);
221: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'========== Created the TDS indexes successfully ==========') ;

Line 218: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'========== Created the LF indexes successfully ==========') ;

214: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'========== Created the MD indexes successfully ==========') ;
215:
216: -- Create LF indexes
217: CSF_SPATIAL_DATALOAD_PVT.CREATE_INDEXES(l_data_set_name,l_table_space, 'LF', errbuf, retcode);
218: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'========== Created the LF indexes successfully ==========') ;
219: -- Create TDS indexes
220: CSF_SPATIAL_DATALOAD_PVT.CREATE_INDEXES(l_data_set_name,l_table_space, 'TDS', errbuf, retcode);
221: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'========== Created the TDS indexes successfully ==========') ;
222:

Line 220: CSF_SPATIAL_DATALOAD_PVT.CREATE_INDEXES(l_data_set_name,l_table_space, 'TDS', errbuf, retcode);

216: -- Create LF indexes
217: CSF_SPATIAL_DATALOAD_PVT.CREATE_INDEXES(l_data_set_name,l_table_space, 'LF', errbuf, retcode);
218: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'========== Created the LF indexes successfully ==========') ;
219: -- Create TDS indexes
220: CSF_SPATIAL_DATALOAD_PVT.CREATE_INDEXES(l_data_set_name,l_table_space, 'TDS', errbuf, retcode);
221: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'========== Created the TDS indexes successfully ==========') ;
222:
223: -- Create WOM indexes
224: IF ( p_WOM_flag IS NOT NULL AND p_WOM_flag = 'Y' ) THEN

Line 221: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'========== Created the TDS indexes successfully ==========') ;

217: CSF_SPATIAL_DATALOAD_PVT.CREATE_INDEXES(l_data_set_name,l_table_space, 'LF', errbuf, retcode);
218: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'========== Created the LF indexes successfully ==========') ;
219: -- Create TDS indexes
220: CSF_SPATIAL_DATALOAD_PVT.CREATE_INDEXES(l_data_set_name,l_table_space, 'TDS', errbuf, retcode);
221: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'========== Created the TDS indexes successfully ==========') ;
222:
223: -- Create WOM indexes
224: IF ( p_WOM_flag IS NOT NULL AND p_WOM_flag = 'Y' ) THEN
225: CSF_SPATIAL_DATALOAD_PVT.CREATE_INDEXES(l_data_set_name,l_table_space, 'WOM', errbuf, retcode);

Line 225: CSF_SPATIAL_DATALOAD_PVT.CREATE_INDEXES(l_data_set_name,l_table_space, 'WOM', errbuf, retcode);

221: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'========== Created the TDS indexes successfully ==========') ;
222:
223: -- Create WOM indexes
224: IF ( p_WOM_flag IS NOT NULL AND p_WOM_flag = 'Y' ) THEN
225: CSF_SPATIAL_DATALOAD_PVT.CREATE_INDEXES(l_data_set_name,l_table_space, 'WOM', errbuf, retcode);
226: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'========== Created the WOM indexes successfully ==========') ;
227: END IF;
228:
229: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log, ' Index Creation is successfull ' );

Line 226: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'========== Created the WOM indexes successfully ==========') ;

222:
223: -- Create WOM indexes
224: IF ( p_WOM_flag IS NOT NULL AND p_WOM_flag = 'Y' ) THEN
225: CSF_SPATIAL_DATALOAD_PVT.CREATE_INDEXES(l_data_set_name,l_table_space, 'WOM', errbuf, retcode);
226: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'========== Created the WOM indexes successfully ==========') ;
227: END IF;
228:
229: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log, ' Index Creation is successfull ' );
230: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output, ' Index Creation is successfull ' );

Line 229: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log, ' Index Creation is successfull ' );

225: CSF_SPATIAL_DATALOAD_PVT.CREATE_INDEXES(l_data_set_name,l_table_space, 'WOM', errbuf, retcode);
226: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'========== Created the WOM indexes successfully ==========') ;
227: END IF;
228:
229: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log, ' Index Creation is successfull ' );
230: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output, ' Index Creation is successfull ' );
231: -- check the index status. Recreate if any index is invalid
232: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log, ' ' );
233: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log, 'checking the index status' );

Line 230: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output, ' Index Creation is successfull ' );

226: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'========== Created the WOM indexes successfully ==========') ;
227: END IF;
228:
229: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log, ' Index Creation is successfull ' );
230: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output, ' Index Creation is successfull ' );
231: -- check the index status. Recreate if any index is invalid
232: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log, ' ' );
233: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log, 'checking the index status' );
234: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log, '================================================ ' );

Line 232: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log, ' ' );

228:
229: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log, ' Index Creation is successfull ' );
230: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output, ' Index Creation is successfull ' );
231: -- check the index status. Recreate if any index is invalid
232: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log, ' ' );
233: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log, 'checking the index status' );
234: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log, '================================================ ' );
235:
236: CSF_SPATIAL_DATALOAD_PVT.CHECK_INDEX_VALIDITY(l_data_set_name,'MD',l_status, errbuf, retcode);

Line 233: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log, 'checking the index status' );

229: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log, ' Index Creation is successfull ' );
230: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output, ' Index Creation is successfull ' );
231: -- check the index status. Recreate if any index is invalid
232: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log, ' ' );
233: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log, 'checking the index status' );
234: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log, '================================================ ' );
235:
236: CSF_SPATIAL_DATALOAD_PVT.CHECK_INDEX_VALIDITY(l_data_set_name,'MD',l_status, errbuf, retcode);
237: IF (l_status <> 0) THEN

Line 234: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log, '================================================ ' );

230: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output, ' Index Creation is successfull ' );
231: -- check the index status. Recreate if any index is invalid
232: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log, ' ' );
233: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log, 'checking the index status' );
234: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log, '================================================ ' );
235:
236: CSF_SPATIAL_DATALOAD_PVT.CHECK_INDEX_VALIDITY(l_data_set_name,'MD',l_status, errbuf, retcode);
237: IF (l_status <> 0) THEN
238: CSF_SPATIAL_DATALOAD_PVT.RECREATE_INVALID_INDEXES(l_data_set_name,l_table_space,'MD', errbuf, retcode);

Line 236: CSF_SPATIAL_DATALOAD_PVT.CHECK_INDEX_VALIDITY(l_data_set_name,'MD',l_status, errbuf, retcode);

232: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log, ' ' );
233: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log, 'checking the index status' );
234: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log, '================================================ ' );
235:
236: CSF_SPATIAL_DATALOAD_PVT.CHECK_INDEX_VALIDITY(l_data_set_name,'MD',l_status, errbuf, retcode);
237: IF (l_status <> 0) THEN
238: CSF_SPATIAL_DATALOAD_PVT.RECREATE_INVALID_INDEXES(l_data_set_name,l_table_space,'MD', errbuf, retcode);
239: END IF;
240:

Line 238: CSF_SPATIAL_DATALOAD_PVT.RECREATE_INVALID_INDEXES(l_data_set_name,l_table_space,'MD', errbuf, retcode);

234: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log, '================================================ ' );
235:
236: CSF_SPATIAL_DATALOAD_PVT.CHECK_INDEX_VALIDITY(l_data_set_name,'MD',l_status, errbuf, retcode);
237: IF (l_status <> 0) THEN
238: CSF_SPATIAL_DATALOAD_PVT.RECREATE_INVALID_INDEXES(l_data_set_name,l_table_space,'MD', errbuf, retcode);
239: END IF;
240:
241: CSF_SPATIAL_DATALOAD_PVT.CHECK_INDEX_VALIDITY(l_data_set_name,'LF',l_status, errbuf, retcode);
242: IF (l_status <> 0) THEN

Line 241: CSF_SPATIAL_DATALOAD_PVT.CHECK_INDEX_VALIDITY(l_data_set_name,'LF',l_status, errbuf, retcode);

237: IF (l_status <> 0) THEN
238: CSF_SPATIAL_DATALOAD_PVT.RECREATE_INVALID_INDEXES(l_data_set_name,l_table_space,'MD', errbuf, retcode);
239: END IF;
240:
241: CSF_SPATIAL_DATALOAD_PVT.CHECK_INDEX_VALIDITY(l_data_set_name,'LF',l_status, errbuf, retcode);
242: IF (l_status <> 0) THEN
243: CSF_SPATIAL_DATALOAD_PVT.RECREATE_INVALID_INDEXES(l_data_set_name,l_table_space,'LF', errbuf, retcode);
244: END IF;
245:

Line 243: CSF_SPATIAL_DATALOAD_PVT.RECREATE_INVALID_INDEXES(l_data_set_name,l_table_space,'LF', errbuf, retcode);

239: END IF;
240:
241: CSF_SPATIAL_DATALOAD_PVT.CHECK_INDEX_VALIDITY(l_data_set_name,'LF',l_status, errbuf, retcode);
242: IF (l_status <> 0) THEN
243: CSF_SPATIAL_DATALOAD_PVT.RECREATE_INVALID_INDEXES(l_data_set_name,l_table_space,'LF', errbuf, retcode);
244: END IF;
245:
246: CSF_SPATIAL_DATALOAD_PVT.CHECK_INDEX_VALIDITY(l_data_set_name,'TDS', l_status, errbuf, retcode);
247: IF (l_status <> 0) THEN

Line 246: CSF_SPATIAL_DATALOAD_PVT.CHECK_INDEX_VALIDITY(l_data_set_name,'TDS', l_status, errbuf, retcode);

242: IF (l_status <> 0) THEN
243: CSF_SPATIAL_DATALOAD_PVT.RECREATE_INVALID_INDEXES(l_data_set_name,l_table_space,'LF', errbuf, retcode);
244: END IF;
245:
246: CSF_SPATIAL_DATALOAD_PVT.CHECK_INDEX_VALIDITY(l_data_set_name,'TDS', l_status, errbuf, retcode);
247: IF (l_status <> 0) THEN
248: CSF_SPATIAL_DATALOAD_PVT.RECREATE_INVALID_INDEXES(l_data_set_name,l_table_space,'TDS', errbuf, retcode);
249: END IF;
250:

Line 248: CSF_SPATIAL_DATALOAD_PVT.RECREATE_INVALID_INDEXES(l_data_set_name,l_table_space,'TDS', errbuf, retcode);

244: END IF;
245:
246: CSF_SPATIAL_DATALOAD_PVT.CHECK_INDEX_VALIDITY(l_data_set_name,'TDS', l_status, errbuf, retcode);
247: IF (l_status <> 0) THEN
248: CSF_SPATIAL_DATALOAD_PVT.RECREATE_INVALID_INDEXES(l_data_set_name,l_table_space,'TDS', errbuf, retcode);
249: END IF;
250:
251: IF ( p_WOM_flag IS NOT NULL AND p_WOM_flag = 'Y' ) THEN
252: CSF_SPATIAL_DATALOAD_PVT.CHECK_INDEX_VALIDITY(l_data_set_name,'WOM',l_status, errbuf, retcode);

Line 252: CSF_SPATIAL_DATALOAD_PVT.CHECK_INDEX_VALIDITY(l_data_set_name,'WOM',l_status, errbuf, retcode);

248: CSF_SPATIAL_DATALOAD_PVT.RECREATE_INVALID_INDEXES(l_data_set_name,l_table_space,'TDS', errbuf, retcode);
249: END IF;
250:
251: IF ( p_WOM_flag IS NOT NULL AND p_WOM_flag = 'Y' ) THEN
252: CSF_SPATIAL_DATALOAD_PVT.CHECK_INDEX_VALIDITY(l_data_set_name,'WOM',l_status, errbuf, retcode);
253: IF (l_status <> 0) THEN
254: CSF_SPATIAL_DATALOAD_PVT.RECREATE_INVALID_INDEXES(l_data_set_name,l_table_space,'WOM', errbuf, retcode);
255: END IF;
256: END IF;

Line 254: CSF_SPATIAL_DATALOAD_PVT.RECREATE_INVALID_INDEXES(l_data_set_name,l_table_space,'WOM', errbuf, retcode);

250:
251: IF ( p_WOM_flag IS NOT NULL AND p_WOM_flag = 'Y' ) THEN
252: CSF_SPATIAL_DATALOAD_PVT.CHECK_INDEX_VALIDITY(l_data_set_name,'WOM',l_status, errbuf, retcode);
253: IF (l_status <> 0) THEN
254: CSF_SPATIAL_DATALOAD_PVT.RECREATE_INVALID_INDEXES(l_data_set_name,l_table_space,'WOM', errbuf, retcode);
255: END IF;
256: END IF;
257:
258: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log, '========== checking the index status is successful ==========' );

Line 258: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log, '========== checking the index status is successful ==========' );

254: CSF_SPATIAL_DATALOAD_PVT.RECREATE_INVALID_INDEXES(l_data_set_name,l_table_space,'WOM', errbuf, retcode);
255: END IF;
256: END IF;
257:
258: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log, '========== checking the index status is successful ==========' );
259:
260: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'Post installtaion steps is successfull');
261: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output,'Post installtaion steps is successfull');
262: -- Step 3: Re-compute Statistics on the Spatial Tables

Line 260: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'Post installtaion steps is successfull');

256: END IF;
257:
258: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log, '========== checking the index status is successful ==========' );
259:
260: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'Post installtaion steps is successfull');
261: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output,'Post installtaion steps is successfull');
262: -- Step 3: Re-compute Statistics on the Spatial Tables
263: -- Refresh Materialized views
264: -- Loading Map Configuration data

Line 261: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output,'Post installtaion steps is successfull');

257:
258: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log, '========== checking the index status is successful ==========' );
259:
260: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'Post installtaion steps is successfull');
261: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output,'Post installtaion steps is successfull');
262: -- Step 3: Re-compute Statistics on the Spatial Tables
263: -- Refresh Materialized views
264: -- Loading Map Configuration data
265: -- This step is included in the procedure POST_INST_REFRESH_MVS.

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 323: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'Table space ''' || l_table_space ||''' exists.') ;

319: EXECUTE IMMEDIATE 'SELECT 1
320: FROM SYS.DBA_DATA_FILES
321: WHERE tablespace_name = :1'
322: USING l_table_space;
323: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'Table space ''' || l_table_space ||''' exists.') ;
324:
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.') ;

Line 327: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'Table space ''' || l_table_space ||''' does not exist.') ;

323: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'Table space ''' || l_table_space ||''' exists.') ;
324:
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

Line 328: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output,'Table space ''' || l_table_space ||''' does not exist.') ;

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

Line 332: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'SELECT FROM SYS.DBA_DATA_FILES is failed : '||SQLCODE||'-'|| SQLERRM) ;

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) ;
334: RAISE FND_API.G_EXC_ERROR;
335: END;
336:

Line 333: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output,'SELECT FROM SYS.DBA_DATA_FILES is failed : '||SQLCODE||'-'|| SQLERRM) ;

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) ;
334: RAISE FND_API.G_EXC_ERROR;
335: END;
336:
337: -- Get the Spatial Data set profile value

Line 349: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'Data set : ' || l_data_set_name) ;

345: ELSE
346: l_data_set_name := '_' || l_data_set_name;
347: END IF;
348:
349: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'Data set : ' || l_data_set_name) ;
350:
351: -- Drop all the materialized view indexes before refreshing the MVs.
352: IF p_referesh_mvs_flag = 'Y' THEN
353: CSF_SPATIAL_DATALOAD_PVT.DROP_INDEXES(l_data_set_name,'MAT', errbuf, retcode);

Line 353: CSF_SPATIAL_DATALOAD_PVT.DROP_INDEXES(l_data_set_name,'MAT', errbuf, retcode);

349: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'Data set : ' || l_data_set_name) ;
350:
351: -- Drop all the materialized view indexes before refreshing the MVs.
352: IF p_referesh_mvs_flag = 'Y' THEN
353: CSF_SPATIAL_DATALOAD_PVT.DROP_INDEXES(l_data_set_name,'MAT', errbuf, retcode);
354: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'Dropped the MAT indexes successfully') ;
355: END IF;
356:
357: -- Compute the statistics on Spatial tables.

Line 354: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'Dropped the MAT indexes successfully') ;

350:
351: -- Drop all the materialized view indexes before refreshing the MVs.
352: IF p_referesh_mvs_flag = 'Y' THEN
353: CSF_SPATIAL_DATALOAD_PVT.DROP_INDEXES(l_data_set_name,'MAT', errbuf, retcode);
354: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'Dropped the MAT indexes successfully') ;
355: END IF;
356:
357: -- Compute the statistics on Spatial tables.
358: IF p_compute_statistics_flag = 'Y' THEN

Line 359: CSF_SPATIAL_DATALOAD_PVT.COMPUTE_STATISTICS(l_data_set_name,errbuf, retcode);

355: END IF;
356:
357: -- Compute the statistics on Spatial tables.
358: IF p_compute_statistics_flag = 'Y' THEN
359: CSF_SPATIAL_DATALOAD_PVT.COMPUTE_STATISTICS(l_data_set_name,errbuf, retcode);
360: END IF;
361:
362: IF p_referesh_mvs_flag = 'Y' THEN
363: -- Refresh Materialized views

Line 364: CSF_SPATIAL_DATALOAD_PVT.REFRESH_MAT_VIEWS(l_data_set_name,errbuf, retcode);

360: END IF;
361:
362: IF p_referesh_mvs_flag = 'Y' THEN
363: -- Refresh Materialized views
364: CSF_SPATIAL_DATALOAD_PVT.REFRESH_MAT_VIEWS(l_data_set_name,errbuf, retcode);
365:
366: -- Create MAT indexes
367: CSF_SPATIAL_DATALOAD_PVT.CREATE_INDEXES(l_data_set_name,l_table_space, 'MAT', errbuf, retcode);
368: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'Created the MAT View indexes successfully') ;

Line 367: CSF_SPATIAL_DATALOAD_PVT.CREATE_INDEXES(l_data_set_name,l_table_space, 'MAT', errbuf, retcode);

363: -- Refresh Materialized views
364: CSF_SPATIAL_DATALOAD_PVT.REFRESH_MAT_VIEWS(l_data_set_name,errbuf, retcode);
365:
366: -- Create MAT indexes
367: CSF_SPATIAL_DATALOAD_PVT.CREATE_INDEXES(l_data_set_name,l_table_space, 'MAT', errbuf, retcode);
368: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'Created the MAT View indexes successfully') ;
369: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output,'Created the MAT View indexes successfully') ;
370:
371: -- check the index status of Materialized view indexes. Raise an error if any index is invalid

Line 368: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'Created the MAT View indexes successfully') ;

364: CSF_SPATIAL_DATALOAD_PVT.REFRESH_MAT_VIEWS(l_data_set_name,errbuf, retcode);
365:
366: -- Create MAT indexes
367: CSF_SPATIAL_DATALOAD_PVT.CREATE_INDEXES(l_data_set_name,l_table_space, 'MAT', errbuf, retcode);
368: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'Created the MAT View indexes successfully') ;
369: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output,'Created the MAT View indexes successfully') ;
370:
371: -- check the index status of Materialized view indexes. Raise an error if any index is invalid
372: CSF_SPATIAL_DATALOAD_PVT.CHECK_INDEX_VALIDITY(l_data_set_name,'MAT', l_status, errbuf, retcode);

Line 369: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output,'Created the MAT View indexes successfully') ;

365:
366: -- Create MAT indexes
367: CSF_SPATIAL_DATALOAD_PVT.CREATE_INDEXES(l_data_set_name,l_table_space, 'MAT', errbuf, retcode);
368: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'Created the MAT View indexes successfully') ;
369: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output,'Created the MAT View indexes successfully') ;
370:
371: -- check the index status of Materialized view indexes. Raise an error if any index is invalid
372: CSF_SPATIAL_DATALOAD_PVT.CHECK_INDEX_VALIDITY(l_data_set_name,'MAT', l_status, errbuf, retcode);
373:

Line 372: CSF_SPATIAL_DATALOAD_PVT.CHECK_INDEX_VALIDITY(l_data_set_name,'MAT', l_status, errbuf, retcode);

368: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'Created the MAT View indexes successfully') ;
369: CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output,'Created the MAT View indexes successfully') ;
370:
371: -- check the index status of Materialized view indexes. Raise an error if any index is invalid
372: CSF_SPATIAL_DATALOAD_PVT.CHECK_INDEX_VALIDITY(l_data_set_name,'MAT', l_status, errbuf, retcode);
373:
374: IF (l_status <> 0) THEN
375: CSF_SPATIAL_DATALOAD_PVT.RECREATE_INVALID_INDEXES(l_data_set_name,l_table_space,'MAT', errbuf, retcode);
376: END IF;

Line 375: CSF_SPATIAL_DATALOAD_PVT.RECREATE_INVALID_INDEXES(l_data_set_name,l_table_space,'MAT', errbuf, retcode);

371: -- check the index status of Materialized view indexes. Raise an error if any index is invalid
372: CSF_SPATIAL_DATALOAD_PVT.CHECK_INDEX_VALIDITY(l_data_set_name,'MAT', l_status, errbuf, retcode);
373:
374: IF (l_status <> 0) THEN
375: CSF_SPATIAL_DATALOAD_PVT.RECREATE_INVALID_INDEXES(l_data_set_name,l_table_space,'MAT', errbuf, retcode);
376: END IF;
377: END IF;
378:
379: EXCEPTION

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: