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.JTY_TAE_INDEX_CREATION_PVT dependencies on JTY_TAE_INDEX_CREATION_PVT

Line 1: PACKAGE BODY jty_tae_index_creation_pvt AS

1: PACKAGE BODY jty_tae_index_creation_pvt AS
2: /*$Header: jtfyaeib.pls 120.15.12020000.3 2012/12/13 06:37:45 swpoddar ship $*/
3: /* -- ---------------------------------------------------
4: -- Start of Comments
5: -- ---------------------------------------------------

Line 6: -- PACKAGE NAME: jty_tae_index_creation_pvt

2: /*$Header: jtfyaeib.pls 120.15.12020000.3 2012/12/13 06:37:45 swpoddar ship $*/
3: /* -- ---------------------------------------------------
4: -- Start of Comments
5: -- ---------------------------------------------------
6: -- PACKAGE NAME: jty_tae_index_creation_pvt
7: -- ---------------------------------------------------
8: -- PURPOSE
9: -- This package has public api to do the following :
10: -- a) return a list of column in order of selectivity

Line 72: 'jtf.plsql.jty_tae_index_creation_pvt.bubble_sort.start',

68:
69: BEGIN
70: -- debug message
71: jty_log(FND_LOG.LEVEL_PROCEDURE,
72: 'jtf.plsql.jty_tae_index_creation_pvt.bubble_sort.start',
73: 'Start of the procedure jty_tae_index_creation_pvt.bubble_sort ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
74:
75: x_return_status := FND_API.G_RET_STS_SUCCESS;
76:

Line 73: 'Start of the procedure jty_tae_index_creation_pvt.bubble_sort ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

69: BEGIN
70: -- debug message
71: jty_log(FND_LOG.LEVEL_PROCEDURE,
72: 'jtf.plsql.jty_tae_index_creation_pvt.bubble_sort.start',
73: 'Start of the procedure jty_tae_index_creation_pvt.bubble_sort ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
74:
75: x_return_status := FND_API.G_RET_STS_SUCCESS;
76:
77: -- bubble sort

Line 99: 'jtf.plsql.jty_tae_index_creation_pvt.bubble_sort.end',

95: END LOOP;
96:
97: -- debug message
98: jty_log(FND_LOG.LEVEL_PROCEDURE,
99: 'jtf.plsql.jty_tae_index_creation_pvt.bubble_sort.end',
100: 'End of the procedure jty_tae_index_creation_pvt.bubble_sort ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
101:
102: EXCEPTION
103: WHEN OTHERS THEN

Line 100: 'End of the procedure jty_tae_index_creation_pvt.bubble_sort ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

96:
97: -- debug message
98: jty_log(FND_LOG.LEVEL_PROCEDURE,
99: 'jtf.plsql.jty_tae_index_creation_pvt.bubble_sort.end',
100: 'End of the procedure jty_tae_index_creation_pvt.bubble_sort ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
101:
102: EXCEPTION
103: WHEN OTHERS THEN
104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 106: 'jtf.plsql.jty_tae_index_creation_pvt.bubble_sort.others',

102: EXCEPTION
103: WHEN OTHERS THEN
104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
105: jty_log(FND_LOG.LEVEL_EXCEPTION,
106: 'jtf.plsql.jty_tae_index_creation_pvt.bubble_sort.others',
107: substr(SQLCODE || ' : ' || SQLERRM, 1, 4000));
108:
109: END Bubble_SORT;
110:

Line 147: 'jtf.plsql.jty_tae_index_creation_pvt.cal_selectivity.start',

143:
144: BEGIN
145: -- debug message
146: jty_log(FND_LOG.LEVEL_PROCEDURE,
147: 'jtf.plsql.jty_tae_index_creation_pvt.cal_selectivity.start',
148: 'Start of the procedure jty_tae_index_creation_pvt.cal_selectivity ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
149:
150: x_return_status := FND_API.G_RET_STS_SUCCESS;
151:

Line 148: 'Start of the procedure jty_tae_index_creation_pvt.cal_selectivity ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

144: BEGIN
145: -- debug message
146: jty_log(FND_LOG.LEVEL_PROCEDURE,
147: 'jtf.plsql.jty_tae_index_creation_pvt.cal_selectivity.start',
148: 'Start of the procedure jty_tae_index_creation_pvt.cal_selectivity ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
149:
150: x_return_status := FND_API.G_RET_STS_SUCCESS;
151:
152: IF(FND_INSTALLATION.GET_APP_INFO('JTF', l_status, l_industry, l_jtf_schema)) THEN

Line 169: 'jtf.plsql.jty_tae_index_creation_pvt.cal_selectivity.cardinality',

165: AND dt.table_name = p_table_name;
166:
167: -- debug message
168: jty_log(FND_LOG.LEVEL_STATEMENT,
169: 'jtf.plsql.jty_tae_index_creation_pvt.cal_selectivity.cardinality',
170: 'Number of rows for table ' || p_table_name || ' : ' || v_cardinality);
171:
172: IF v_cardinality = 0 THEN
173: -- debug message

Line 175: 'jtf.plsql.jty_tae_index_creation_pvt.cal_selectivity.cardinality',

171:
172: IF v_cardinality = 0 THEN
173: -- debug message
174: jty_log(FND_LOG.LEVEL_EXCEPTION,
175: 'jtf.plsql.jty_tae_index_creation_pvt.cal_selectivity.cardinality',
176: 'API jty_tae_index_creation_pvt.cal_selectivity has failed as the number of rows in the table ' ||
177: p_table_name || ' is 0');
178:
179: RAISE FND_API.G_EXC_ERROR;

Line 176: 'API jty_tae_index_creation_pvt.cal_selectivity has failed as the number of rows in the table ' ||

172: IF v_cardinality = 0 THEN
173: -- debug message
174: jty_log(FND_LOG.LEVEL_EXCEPTION,
175: 'jtf.plsql.jty_tae_index_creation_pvt.cal_selectivity.cardinality',
176: 'API jty_tae_index_creation_pvt.cal_selectivity has failed as the number of rows in the table ' ||
177: p_table_name || ' is 0');
178:
179: RAISE FND_API.G_EXC_ERROR;
180: END IF;

Line 207: 'jtf.plsql.jty_tae_index_creation_pvt.cal_selectivity.bubble_sort',

203:
204: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
205: -- debug message
206: jty_log(FND_LOG.LEVEL_EXCEPTION,
207: 'jtf.plsql.jty_tae_index_creation_pvt.cal_selectivity.bubble_sort',
208: 'API jty_tae_index_creation_pvt.bubble_sort has failed');
209:
210: RAISE FND_API.G_EXC_ERROR;
211: END IF;

Line 208: 'API jty_tae_index_creation_pvt.bubble_sort has failed');

204: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
205: -- debug message
206: jty_log(FND_LOG.LEVEL_EXCEPTION,
207: 'jtf.plsql.jty_tae_index_creation_pvt.cal_selectivity.bubble_sort',
208: 'API jty_tae_index_creation_pvt.bubble_sort has failed');
209:
210: RAISE FND_API.G_EXC_ERROR;
211: END IF;
212:

Line 215: 'jtf.plsql.jty_tae_index_creation_pvt.cal_selectivity.end',

211: END IF;
212:
213: -- debug message
214: jty_log(FND_LOG.LEVEL_PROCEDURE,
215: 'jtf.plsql.jty_tae_index_creation_pvt.cal_selectivity.end',
216: 'End of the procedure jty_tae_index_creation_pvt.cal_selectivity ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
217:
218: EXCEPTION
219: WHEN L_SCHEMA_NOTFOUND THEN

Line 216: 'End of the procedure jty_tae_index_creation_pvt.cal_selectivity ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

212:
213: -- debug message
214: jty_log(FND_LOG.LEVEL_PROCEDURE,
215: 'jtf.plsql.jty_tae_index_creation_pvt.cal_selectivity.end',
216: 'End of the procedure jty_tae_index_creation_pvt.cal_selectivity ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
217:
218: EXCEPTION
219: WHEN L_SCHEMA_NOTFOUND THEN
220: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 222: 'jtf.plsql.jty_tae_index_creation_pvt.cal_selectivity.l_schema_notfound',

218: EXCEPTION
219: WHEN L_SCHEMA_NOTFOUND THEN
220: x_return_status := FND_API.G_RET_STS_ERROR ;
221: jty_log(FND_LOG.LEVEL_EXCEPTION,
222: 'jtf.plsql.jty_tae_index_creation_pvt.cal_selectivity.l_schema_notfound',
223: 'Schema name corresponding to JTF application not found');
224:
225: WHEN NO_DATA_FOUND THEN
226: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 228: 'jtf.plsql.jty_tae_index_creation_pvt.cal_selectivity.no_data_found',

224:
225: WHEN NO_DATA_FOUND THEN
226: x_return_status := FND_API.G_RET_STS_ERROR ;
227: jty_log(FND_LOG.LEVEL_EXCEPTION,
228: 'jtf.plsql.jty_tae_index_creation_pvt.cal_selectivity.no_data_found',
229: substr(SQLCODE || ' : ' || SQLERRM, 1, 4000));
230:
231: WHEN FND_API.G_EXC_ERROR THEN
232: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 234: 'jtf.plsql.jty_tae_index_creation_pvt.cal_selectivity.g_exc_error',

230:
231: WHEN FND_API.G_EXC_ERROR THEN
232: x_return_status := FND_API.G_RET_STS_ERROR ;
233: jty_log(FND_LOG.LEVEL_EXCEPTION,
234: 'jtf.plsql.jty_tae_index_creation_pvt.cal_selectivity.g_exc_error',
235: 'jty_tae_index_creation_pvt.cal_selectivity has failed with G_EXC_ERROR exception');
236:
237: WHEN OTHERS THEN
238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 235: 'jty_tae_index_creation_pvt.cal_selectivity has failed with G_EXC_ERROR exception');

231: WHEN FND_API.G_EXC_ERROR THEN
232: x_return_status := FND_API.G_RET_STS_ERROR ;
233: jty_log(FND_LOG.LEVEL_EXCEPTION,
234: 'jtf.plsql.jty_tae_index_creation_pvt.cal_selectivity.g_exc_error',
235: 'jty_tae_index_creation_pvt.cal_selectivity has failed with G_EXC_ERROR exception');
236:
237: WHEN OTHERS THEN
238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
239: jty_log(FND_LOG.LEVEL_EXCEPTION,

Line 240: 'jtf.plsql.jty_tae_index_creation_pvt.cal_selectivity.others',

236:
237: WHEN OTHERS THEN
238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
239: jty_log(FND_LOG.LEVEL_EXCEPTION,
240: 'jtf.plsql.jty_tae_index_creation_pvt.cal_selectivity.others',
241: substr(SQLCODE || ' : ' || SQLERRM, 1, 4000));
242:
243: END CAL_SELECTIVITY;
244:

Line 322: 'jtf.plsql.jty_tae_index_creation_pvt.dea_selectivity.start',

318: BEGIN
319:
320: -- debug message
321: jty_log(FND_LOG.LEVEL_PROCEDURE,
322: 'jtf.plsql.jty_tae_index_creation_pvt.dea_selectivity.start',
323: 'Start of the procedure jty_tae_index_creation_pvt.dea_selectivity ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
324:
325: x_return_status := FND_API.G_RET_STS_SUCCESS;
326:

Line 323: 'Start of the procedure jty_tae_index_creation_pvt.dea_selectivity ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

319:
320: -- debug message
321: jty_log(FND_LOG.LEVEL_PROCEDURE,
322: 'jtf.plsql.jty_tae_index_creation_pvt.dea_selectivity.start',
323: 'Start of the procedure jty_tae_index_creation_pvt.dea_selectivity ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
324:
325: x_return_status := FND_API.G_RET_STS_SUCCESS;
326:
327: i := 1;

Line 343: 'jtf.plsql.jty_tae_index_creation_pvt.dea_selectivity.col_name',

339: -- no valid column name, or all flag = No, return 1
340: IF (i=1 or j=0) THEN
341: -- debug message
342: jty_log(FND_LOG.LEVEL_EXCEPTION,
343: 'jtf.plsql.jty_tae_index_creation_pvt.dea_selectivity.col_name',
344: 'API jty_tae_index_creation_pvt.dea_selectivity has failed as there is no valid column name, or all flag = No');
345:
346: -- RAISE FND_API.G_EXC_ERROR;
347: --END IF;

Line 344: 'API jty_tae_index_creation_pvt.dea_selectivity has failed as there is no valid column name, or all flag = No');

340: IF (i=1 or j=0) THEN
341: -- debug message
342: jty_log(FND_LOG.LEVEL_EXCEPTION,
343: 'jtf.plsql.jty_tae_index_creation_pvt.dea_selectivity.col_name',
344: 'API jty_tae_index_creation_pvt.dea_selectivity has failed as there is no valid column name, or all flag = No');
345:
346: -- RAISE FND_API.G_EXC_ERROR;
347: --END IF;
348: ELSE

Line 361: 'jtf.plsql.jty_tae_index_creation_pvt.dea_selectivity.cal_selectivity',

357:
358: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
359: -- debug message
360: jty_log(FND_LOG.LEVEL_EXCEPTION,
361: 'jtf.plsql.jty_tae_index_creation_pvt.dea_selectivity.cal_selectivity',
362: 'API jty_tae_index_creation_pvt.cal_selectivity has failed');
363:
364: RAISE FND_API.G_EXC_ERROR;
365: END IF;

Line 362: 'API jty_tae_index_creation_pvt.cal_selectivity has failed');

358: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
359: -- debug message
360: jty_log(FND_LOG.LEVEL_EXCEPTION,
361: 'jtf.plsql.jty_tae_index_creation_pvt.dea_selectivity.cal_selectivity',
362: 'API jty_tae_index_creation_pvt.cal_selectivity has failed');
363:
364: RAISE FND_API.G_EXC_ERROR;
365: END IF;
366:

Line 380: 'jtf.plsql.jty_tae_index_creation_pvt.dea_selectivity.end',

376: COMMIT;
377: END IF;
378: -- debug message
379: jty_log(FND_LOG.LEVEL_PROCEDURE,
380: 'jtf.plsql.jty_tae_index_creation_pvt.dea_selectivity.end',
381: 'End of the procedure jty_tae_index_creation_pvt.dea_selectivity ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
382:
383: EXCEPTION
384: WHEN FND_API.G_EXC_ERROR THEN

Line 381: 'End of the procedure jty_tae_index_creation_pvt.dea_selectivity ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

377: END IF;
378: -- debug message
379: jty_log(FND_LOG.LEVEL_PROCEDURE,
380: 'jtf.plsql.jty_tae_index_creation_pvt.dea_selectivity.end',
381: 'End of the procedure jty_tae_index_creation_pvt.dea_selectivity ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
382:
383: EXCEPTION
384: WHEN FND_API.G_EXC_ERROR THEN
385: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 387: 'jtf.plsql.jty_tae_index_creation_pvt.dea_selectivity.g_exc_error',

383: EXCEPTION
384: WHEN FND_API.G_EXC_ERROR THEN
385: x_return_status := FND_API.G_RET_STS_ERROR ;
386: jty_log(FND_LOG.LEVEL_EXCEPTION,
387: 'jtf.plsql.jty_tae_index_creation_pvt.dea_selectivity.g_exc_error',
388: 'jty_tae_index_creation_pvt.dea_selectivity has failed with G_EXC_ERROR exception');
389:
390: WHEN OTHERS THEN
391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 388: 'jty_tae_index_creation_pvt.dea_selectivity has failed with G_EXC_ERROR exception');

384: WHEN FND_API.G_EXC_ERROR THEN
385: x_return_status := FND_API.G_RET_STS_ERROR ;
386: jty_log(FND_LOG.LEVEL_EXCEPTION,
387: 'jtf.plsql.jty_tae_index_creation_pvt.dea_selectivity.g_exc_error',
388: 'jty_tae_index_creation_pvt.dea_selectivity has failed with G_EXC_ERROR exception');
389:
390: WHEN OTHERS THEN
391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
392: jty_log(FND_LOG.LEVEL_EXCEPTION,

Line 393: 'jtf.plsql.jty_tae_index_creation_pvt.dea_selectivity.others',

389:
390: WHEN OTHERS THEN
391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
392: jty_log(FND_LOG.LEVEL_EXCEPTION,
393: 'jtf.plsql.jty_tae_index_creation_pvt.dea_selectivity.others',
394: substr(SQLCODE || ' : ' || SQLERRM, 1, 4000));
395:
396: END DEA_SELECTIVITY;
397:

Line 502: 'jtf.plsql.jty_tae_index_creation_pvt.selectivity.start',

498:
499: BEGIN
500: -- debug message
501: jty_log(FND_LOG.LEVEL_PROCEDURE,
502: 'jtf.plsql.jty_tae_index_creation_pvt.selectivity.start',
503: 'Start of the procedure jty_tae_index_creation_pvt.selectivity ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
504:
505: x_return_status := FND_API.G_RET_STS_SUCCESS;
506:

Line 503: 'Start of the procedure jty_tae_index_creation_pvt.selectivity ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

499: BEGIN
500: -- debug message
501: jty_log(FND_LOG.LEVEL_PROCEDURE,
502: 'jtf.plsql.jty_tae_index_creation_pvt.selectivity.start',
503: 'Start of the procedure jty_tae_index_creation_pvt.selectivity ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
504:
505: x_return_status := FND_API.G_RET_STS_SUCCESS;
506:
507: i := 1;

Line 545: 'jtf.plsql.jty_tae_index_creation_pvt.selectivity.col_name',

541: -- no valid column name, or all flag = No, return 1
542: IF (i=1 or j=0) THEN
543: -- debug message
544: jty_log(FND_LOG.LEVEL_EXCEPTION,
545: 'jtf.plsql.jty_tae_index_creation_pvt.selectivity.col_name',
546: 'API jty_tae_index_creation_pvt.selectivity has failed as there is no valid column name, or all flag = No');
547:
548: -- RAISE FND_API.G_EXC_ERROR;
549: --END IF;

Line 546: 'API jty_tae_index_creation_pvt.selectivity has failed as there is no valid column name, or all flag = No');

542: IF (i=1 or j=0) THEN
543: -- debug message
544: jty_log(FND_LOG.LEVEL_EXCEPTION,
545: 'jtf.plsql.jty_tae_index_creation_pvt.selectivity.col_name',
546: 'API jty_tae_index_creation_pvt.selectivity has failed as there is no valid column name, or all flag = No');
547:
548: -- RAISE FND_API.G_EXC_ERROR;
549: --END IF;
550: ELSE

Line 563: 'jtf.plsql.jty_tae_index_creation_pvt.selectivity.cal_selectivity',

559:
560: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
561: -- debug message
562: jty_log(FND_LOG.LEVEL_EXCEPTION,
563: 'jtf.plsql.jty_tae_index_creation_pvt.selectivity.cal_selectivity',
564: 'API jty_tae_index_creation_pvt.selectivity has failed');
565:
566: RAISE FND_API.G_EXC_ERROR;
567: END IF;

Line 564: 'API jty_tae_index_creation_pvt.selectivity has failed');

560: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
561: -- debug message
562: jty_log(FND_LOG.LEVEL_EXCEPTION,
563: 'jtf.plsql.jty_tae_index_creation_pvt.selectivity.cal_selectivity',
564: 'API jty_tae_index_creation_pvt.selectivity has failed');
565:
566: RAISE FND_API.G_EXC_ERROR;
567: END IF;
568:

Line 600: 'jtf.plsql.jty_tae_index_creation_pvt.selectivity.end',

596: COMMIT;
597: END IF;
598: -- debug message
599: jty_log(FND_LOG.LEVEL_PROCEDURE,
600: 'jtf.plsql.jty_tae_index_creation_pvt.selectivity.end',
601: 'End of the procedure jty_tae_index_creation_pvt.selectivity ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
602:
603: EXCEPTION
604: WHEN FND_API.G_EXC_ERROR THEN

Line 601: 'End of the procedure jty_tae_index_creation_pvt.selectivity ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

597: END IF;
598: -- debug message
599: jty_log(FND_LOG.LEVEL_PROCEDURE,
600: 'jtf.plsql.jty_tae_index_creation_pvt.selectivity.end',
601: 'End of the procedure jty_tae_index_creation_pvt.selectivity ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
602:
603: EXCEPTION
604: WHEN FND_API.G_EXC_ERROR THEN
605: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 607: 'jtf.plsql.jty_tae_index_creation_pvt.selectivity.g_exc_error',

603: EXCEPTION
604: WHEN FND_API.G_EXC_ERROR THEN
605: x_return_status := FND_API.G_RET_STS_ERROR ;
606: jty_log(FND_LOG.LEVEL_EXCEPTION,
607: 'jtf.plsql.jty_tae_index_creation_pvt.selectivity.g_exc_error',
608: 'jty_tae_index_creation_pvt.selectivity has failed with G_EXC_ERROR exception');
609:
610: WHEN OTHERS THEN
611: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 608: 'jty_tae_index_creation_pvt.selectivity has failed with G_EXC_ERROR exception');

604: WHEN FND_API.G_EXC_ERROR THEN
605: x_return_status := FND_API.G_RET_STS_ERROR ;
606: jty_log(FND_LOG.LEVEL_EXCEPTION,
607: 'jtf.plsql.jty_tae_index_creation_pvt.selectivity.g_exc_error',
608: 'jty_tae_index_creation_pvt.selectivity has failed with G_EXC_ERROR exception');
609:
610: WHEN OTHERS THEN
611: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
612: jty_log(FND_LOG.LEVEL_EXCEPTION,

Line 613: 'jtf.plsql.jty_tae_index_creation_pvt.selectivity.others',

609:
610: WHEN OTHERS THEN
611: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
612: jty_log(FND_LOG.LEVEL_EXCEPTION,
613: 'jtf.plsql.jty_tae_index_creation_pvt.selectivity.others',
614: substr(SQLCODE || ' : ' || SQLERRM, 1, 4000));
615:
616: END SELECTIVITY;
617:

Line 642: 'jtf.plsql.jty_tae_index_creation_pvt.get_qual_comb_index.begin',

638: BEGIN
639:
640: -- debug message
641: jty_log(FND_LOG.LEVEL_PROCEDURE,
642: 'jtf.plsql.jty_tae_index_creation_pvt.get_qual_comb_index.begin',
643: 'Start of the procedure jty_tae_index_creation_pvt.get_qual_comb_index ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
644:
645: x_return_status := FND_API.G_RET_STS_SUCCESS;
646:

Line 643: 'Start of the procedure jty_tae_index_creation_pvt.get_qual_comb_index ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

639:
640: -- debug message
641: jty_log(FND_LOG.LEVEL_PROCEDURE,
642: 'jtf.plsql.jty_tae_index_creation_pvt.get_qual_comb_index.begin',
643: 'Start of the procedure jty_tae_index_creation_pvt.get_qual_comb_index ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
644:
645: x_return_status := FND_API.G_RET_STS_SUCCESS;
646:
647: IF(FND_INSTALLATION.GET_APP_INFO('JTF', l_status, l_industry, l_jtf_schema)) THEN

Line 706: 'jtf.plsql.jty_tae_index_creation_pvt.get_qual_comb_index.index_stmt',

702: END IF;
703:
704: -- debug message
705: jty_log(FND_LOG.LEVEL_STATEMENT,
706: 'jtf.plsql.jty_tae_index_creation_pvt.get_qual_comb_index.index_stmt',
707: 'x_statement : ' || x_statement || ' alter_statement : ' || alter_statement);
708:
709: -- debug message
710: jty_log(FND_LOG.LEVEL_PROCEDURE,

Line 711: 'jtf.plsql.jty_tae_index_creation_pvt.get_qual_comb_index.end',

707: 'x_statement : ' || x_statement || ' alter_statement : ' || alter_statement);
708:
709: -- debug message
710: jty_log(FND_LOG.LEVEL_PROCEDURE,
711: 'jtf.plsql.jty_tae_index_creation_pvt.get_qual_comb_index.end',
712: 'End of the procedure jty_tae_index_creation_pvt.get_qual_comb_index ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
713:
714: EXCEPTION
715: WHEN L_SCHEMA_NOTFOUND THEN

Line 712: 'End of the procedure jty_tae_index_creation_pvt.get_qual_comb_index ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

708:
709: -- debug message
710: jty_log(FND_LOG.LEVEL_PROCEDURE,
711: 'jtf.plsql.jty_tae_index_creation_pvt.get_qual_comb_index.end',
712: 'End of the procedure jty_tae_index_creation_pvt.get_qual_comb_index ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
713:
714: EXCEPTION
715: WHEN L_SCHEMA_NOTFOUND THEN
716: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 718: 'jtf.plsql.jty_tae_index_creation_pvt.get_qual_comb_index.l_schema_notfound',

714: EXCEPTION
715: WHEN L_SCHEMA_NOTFOUND THEN
716: x_return_status := FND_API.G_RET_STS_ERROR ;
717: jty_log(FND_LOG.LEVEL_EXCEPTION,
718: 'jtf.plsql.jty_tae_index_creation_pvt.get_qual_comb_index.l_schema_notfound',
719: 'Schema name corresponding to JTF application not found');
720:
721: WHEN OTHERS THEN
722: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 724: 'jtf.plsql.jty_tae_index_creation_pvt.get_qual_comb_index.others',

720:
721: WHEN OTHERS THEN
722: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
723: jty_log(FND_LOG.LEVEL_EXCEPTION,
724: 'jtf.plsql.jty_tae_index_creation_pvt.get_qual_comb_index.others',
725: substr(SQLCODE || ' : ' || SQLERRM, 1, 4000));
726:
727: END get_qual_comb_index;
728:

Line 946: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.begin',

942:
943: BEGIN
944: -- debug message
945: jty_log(FND_LOG.LEVEL_PROCEDURE,
946: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.begin',
947: 'Start of the procedure jty_tae_index_creation_pvt.create_index ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
948:
949: x_return_status := FND_API.G_RET_STS_SUCCESS;
950:

Line 947: 'Start of the procedure jty_tae_index_creation_pvt.create_index ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

943: BEGIN
944: -- debug message
945: jty_log(FND_LOG.LEVEL_PROCEDURE,
946: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.begin',
947: 'Start of the procedure jty_tae_index_creation_pvt.create_index ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
948:
949: x_return_status := FND_API.G_RET_STS_SUCCESS;
950:
951: /* Initialize the flags */

Line 971: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.l_dop',

967: OR v.name = 'cpu_count';
968:
969: -- debug message
970: jty_log(FND_LOG.LEVEL_STATEMENT,
971: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.l_dop',
972: 'Default degree of parallelism : ' || l_dop);
973:
974: /* get tablespace information */
975: SELECT i.tablespace, i.index_tablespace, u.oracle_username

Line 984: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.tablespace',

980: AND u.oracle_id = i.oracle_id;
981:
982: -- debug message
983: jty_log(FND_LOG.LEVEL_STATEMENT,
984: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.tablespace',
985: 'Table tablespace : ' || l_table_tablespace || ' Index tablespace : ' || l_idx_tablespace ||
986: ' Schema Name : ' || l_ora_username);
987:
988: -- default INDEX STORAGE parameters

Line 1006: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.no_index_extn',

1002: AND program_name = p_program_name;
1003: EXCEPTION
1004: WHEN NO_DATA_FOUND THEN
1005: jty_log(FND_LOG.LEVEL_EXCEPTION,
1006: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.no_index_extn',
1007: 'No row in table jty_trans_usg_pgm_details corresponding to source : ' || p_source_id || ' transaction : ' ||
1008: p_trans_id || ' program name : ' || p_program_name);
1009: RAISE;
1010: END;

Line 1021: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.no_qual_type_usg_id',

1017: AND qual_type_id = p_trans_id;
1018: EXCEPTION
1019: WHEN NO_DATA_FOUND THEN
1020: jty_log(FND_LOG.LEVEL_EXCEPTION,
1021: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.no_qual_type_usg_id',
1022: 'No row in table jtf_qual_type_usgs_all corresponding to source : ' || p_source_id || ' and transaction : ' ||
1023: p_trans_id);
1024: RAISE;
1025: END;

Line 1029: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.l_index_extn',

1025: END;
1026:
1027: -- debug message
1028: jty_log(FND_LOG.LEVEL_STATEMENT,
1029: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.l_index_extn',
1030: 'Index extension for the usage : ' || l_index_extn ||
1031: ' qual_type-usg_id : ' || l_qual_type_usg_id);
1032:
1033: -- indexes for TRANS table

Line 1038: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.existing_index',

1034: IF (p_run_mode = 'TRANS') THEN
1035:
1036: -- debug message
1037: jty_log(FND_LOG.LEVEL_STATEMENT,
1038: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.existing_index',
1039: 'Existing Indexes');
1040: FOR c1 IN c_all_indexes(p_table_name, l_ora_username) LOOP
1041: jty_log(FND_LOG.LEVEL_STATEMENT,
1042: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.existing_index',

Line 1042: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.existing_index',

1038: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.existing_index',
1039: 'Existing Indexes');
1040: FOR c1 IN c_all_indexes(p_table_name, l_ora_username) LOOP
1041: jty_log(FND_LOG.LEVEL_STATEMENT,
1042: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.existing_index',
1043: 'Index Name : ' || c1.index_name);
1044: END LOOP;
1045:
1046: IF (p_mode = 'TOTAL') THEN

Line 1061: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.index_creation',

1057: v_statement := v_statement || s_statement;
1058:
1059: -- debug message
1060: jty_log(FND_LOG.LEVEL_STATEMENT,
1061: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.index_creation',
1062: '1Index created with the statement : ' || v_statement);
1063:
1064: EXECUTE IMMEDIATE v_statement;
1065:

Line 1108: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.4841',

1104:
1105: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1106: -- debug message
1107: jty_log(FND_LOG.LEVEL_EXCEPTION,
1108: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.4841',
1109: 'API jty_tae_index_creation_pvt.get_qual_comb_index has failed for qualifier comb 4841');
1110:
1111: RAISE FND_API.G_EXC_ERROR;
1112: END IF;

Line 1109: 'API jty_tae_index_creation_pvt.get_qual_comb_index has failed for qualifier comb 4841');

1105: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1106: -- debug message
1107: jty_log(FND_LOG.LEVEL_EXCEPTION,
1108: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.4841',
1109: 'API jty_tae_index_creation_pvt.get_qual_comb_index has failed for qualifier comb 4841');
1110:
1111: RAISE FND_API.G_EXC_ERROR;
1112: END IF;
1113:

Line 1136: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.324347',

1132:
1133: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1134: -- debug message
1135: jty_log(FND_LOG.LEVEL_EXCEPTION,
1136: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.324347',
1137: 'API jty_tae_index_creation_pvt.get_qual_comb_index has failed for qualifier comb 324347');
1138:
1139: RAISE FND_API.G_EXC_ERROR;
1140: END IF;

Line 1137: 'API jty_tae_index_creation_pvt.get_qual_comb_index has failed for qualifier comb 324347');

1133: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1134: -- debug message
1135: jty_log(FND_LOG.LEVEL_EXCEPTION,
1136: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.324347',
1137: 'API jty_tae_index_creation_pvt.get_qual_comb_index has failed for qualifier comb 324347');
1138:
1139: RAISE FND_API.G_EXC_ERROR;
1140: END IF;
1141:

Line 1187: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.index_creation',

1183:
1184: IF l_create_index_flag = 'Y' THEN
1185: -- debug message
1186: jty_log(FND_LOG.LEVEL_STATEMENT,
1187: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.index_creation',
1188: '2Index created with the statement : ' || prd.qual_product_id || v_statement);
1189:
1190: EXECUTE IMMEDIATE v_statement;
1191:

Line 1205: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.trans_index',

1201: END LOOP; /* end loop FOR prd IN getProductList */
1202:
1203: -- debug message
1204: jty_log(FND_LOG.LEVEL_STATEMENT,
1205: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.trans_index',
1206: 'Done creating index for TRANS table');
1207:
1208: -- Additional Indexes for TRANS table - eihsu 03/06/2002
1209: FOR idxCand in extraIndexCandidates(p_source_id, p_trans_id) LOOP

Line 1239: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.324347_reverse',

1235:
1236: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1237: -- debug message
1238: jty_log(FND_LOG.LEVEL_EXCEPTION,
1239: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.324347_reverse',
1240: 'API jty_tae_index_creation_pvt.get_qual_comb_index has failed for qualifier comb 324347_reverse');
1241:
1242: RAISE FND_API.G_EXC_ERROR;
1243: END IF;

Line 1240: 'API jty_tae_index_creation_pvt.get_qual_comb_index has failed for qualifier comb 324347_reverse');

1236: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1237: -- debug message
1238: jty_log(FND_LOG.LEVEL_EXCEPTION,
1239: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.324347_reverse',
1240: 'API jty_tae_index_creation_pvt.get_qual_comb_index has failed for qualifier comb 324347_reverse');
1241:
1242: RAISE FND_API.G_EXC_ERROR;
1243: END IF;
1244:

Line 1291: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.index_creation',

1287:
1288: IF l_create_index_flag = 'Y' THEN
1289: -- debug message
1290: jty_log(FND_LOG.LEVEL_STATEMENT,
1291: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.index_creation',
1292: '3Index created with the statement : ' || idxCand.qual_product_id || v_statement);
1293:
1294: EXECUTE IMMEDIATE v_statement;
1295:

Line 1309: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.trans_reverse_index',

1305: END LOOP; /* end loop FOR idxCand in extraIndexCandidates */
1306:
1307: -- debug message
1308: jty_log(FND_LOG.LEVEL_STATEMENT,
1309: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.trans_reverse_index',
1310: 'Done creating reverse index for TRANS table');
1311:
1312: -- indexes for DEA_TRANS table
1313: ELSIF (p_run_mode = 'DEA_TRANS') THEN

Line 1365: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.dea_4841',

1361:
1362: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1363: -- debug message
1364: jty_log(FND_LOG.LEVEL_EXCEPTION,
1365: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.dea_4841',
1366: 'API jty_tae_index_creation_pvt.get_qual_comb_index has failed for qualifier comb dea_4841');
1367:
1368: RAISE FND_API.G_EXC_ERROR;
1369: END IF;

Line 1366: 'API jty_tae_index_creation_pvt.get_qual_comb_index has failed for qualifier comb dea_4841');

1362: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1363: -- debug message
1364: jty_log(FND_LOG.LEVEL_EXCEPTION,
1365: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.dea_4841',
1366: 'API jty_tae_index_creation_pvt.get_qual_comb_index has failed for qualifier comb dea_4841');
1367:
1368: RAISE FND_API.G_EXC_ERROR;
1369: END IF;
1370:

Line 1393: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.dea_324347',

1389:
1390: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1391: -- debug message
1392: jty_log(FND_LOG.LEVEL_EXCEPTION,
1393: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.dea_324347',
1394: 'API jty_tae_index_creation_pvt.get_qual_comb_index has failed for qualifier comb dea_324347');
1395:
1396: RAISE FND_API.G_EXC_ERROR;
1397: END IF;

Line 1394: 'API jty_tae_index_creation_pvt.get_qual_comb_index has failed for qualifier comb dea_324347');

1390: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1391: -- debug message
1392: jty_log(FND_LOG.LEVEL_EXCEPTION,
1393: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.dea_324347',
1394: 'API jty_tae_index_creation_pvt.get_qual_comb_index has failed for qualifier comb dea_324347');
1395:
1396: RAISE FND_API.G_EXC_ERROR;
1397: END IF;
1398:

Line 1449: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.dea_trans_index',

1445: END LOOP; /* end loop FOR prd IN getProductList */
1446:
1447: -- debug message
1448: jty_log(FND_LOG.LEVEL_STATEMENT,
1449: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.dea_trans_index',
1450: 'Done creating index for DEA_TRANS table');
1451:
1452: FOR idxCand in dea_extraIndexCandidates(p_source_id, p_trans_id) LOOP
1453: l_create_index_flag := 'Y';

Line 1482: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.dea_324347_reverse',

1478:
1479: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1480: -- debug message
1481: jty_log(FND_LOG.LEVEL_EXCEPTION,
1482: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.dea_324347_reverse',
1483: 'API jty_tae_index_creation_pvt.get_qual_comb_index has failed for qualifier comb dea_324347_reverse');
1484:
1485: RAISE FND_API.G_EXC_ERROR;
1486: END IF;

Line 1483: 'API jty_tae_index_creation_pvt.get_qual_comb_index has failed for qualifier comb dea_324347_reverse');

1479: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1480: -- debug message
1481: jty_log(FND_LOG.LEVEL_EXCEPTION,
1482: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.dea_324347_reverse',
1483: 'API jty_tae_index_creation_pvt.get_qual_comb_index has failed for qualifier comb dea_324347_reverse');
1484:
1485: RAISE FND_API.G_EXC_ERROR;
1486: END IF;
1487:

Line 1534: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.dea_trans_reverse_index',

1530: END LOOP; /* end loop FOR idxCand in extraIndexCandidates */
1531:
1532: -- debug message
1533: jty_log(FND_LOG.LEVEL_STATEMENT,
1534: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.dea_trans_reverse_index',
1535: 'Done creating reverse index for DEA_TRANS table');
1536:
1537: /* no index is created on match table as the tables is always accessed with full table scan
1538: -- index for MATCHES table

Line 1551: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.match',

1547:
1548: -- debug message
1549: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1550: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1551: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.match',
1552: 'Done creating index for MATCH table');
1553: END IF;
1554: */
1555:

Line 1568: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.winner',

1564: EXECUTE IMMEDIATE v_statement;
1565:
1566: -- debug message
1567: jty_log(FND_LOG.LEVEL_STATEMENT,
1568: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.winner',
1569: 'Done creating index for WINNER table');
1570:
1571: /* no index is created on l1->5 and wt tables as these tables are always accessed with full table scan
1572: -- index for TEMP WINNER table

Line 1585: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.temp_winner',

1581:
1582: -- debug message
1583: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1584: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1585: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.temp_winner',
1586: 'Done creating index for TEMP WINNER table');
1587: END IF;
1588: */
1589:

Line 1594: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.end',

1590: END IF; /* end IF (p_run_mode = 'TRANS') */
1591:
1592: -- debug message
1593: jty_log(FND_LOG.LEVEL_PROCEDURE,
1594: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.end',
1595: 'End of the procedure jty_tae_index_creation_pvt.create_index ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
1596:
1597: EXCEPTION
1598: WHEN NO_DATA_FOUND THEN

Line 1595: 'End of the procedure jty_tae_index_creation_pvt.create_index ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

1591:
1592: -- debug message
1593: jty_log(FND_LOG.LEVEL_PROCEDURE,
1594: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.end',
1595: 'End of the procedure jty_tae_index_creation_pvt.create_index ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
1596:
1597: EXCEPTION
1598: WHEN NO_DATA_FOUND THEN
1599: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 1601: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.no_data_found',

1597: EXCEPTION
1598: WHEN NO_DATA_FOUND THEN
1599: x_return_status := FND_API.G_RET_STS_ERROR ;
1600: jty_log(FND_LOG.LEVEL_EXCEPTION,
1601: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.no_data_found',
1602: 'API jty_tae_index_creation_pvt.create_index has failed with no_data_found');
1603:
1604: WHEN FND_API.G_EXC_ERROR THEN
1605: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 1602: 'API jty_tae_index_creation_pvt.create_index has failed with no_data_found');

1598: WHEN NO_DATA_FOUND THEN
1599: x_return_status := FND_API.G_RET_STS_ERROR ;
1600: jty_log(FND_LOG.LEVEL_EXCEPTION,
1601: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.no_data_found',
1602: 'API jty_tae_index_creation_pvt.create_index has failed with no_data_found');
1603:
1604: WHEN FND_API.G_EXC_ERROR THEN
1605: x_return_status := FND_API.G_RET_STS_ERROR ;
1606: jty_log(FND_LOG.LEVEL_EXCEPTION,

Line 1607: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.g_exc_error',

1603:
1604: WHEN FND_API.G_EXC_ERROR THEN
1605: x_return_status := FND_API.G_RET_STS_ERROR ;
1606: jty_log(FND_LOG.LEVEL_EXCEPTION,
1607: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.g_exc_error',
1608: 'jty_tae_index_creation_pvt.create_index has failed with G_EXC_ERROR exception');
1609:
1610: WHEN OTHERS THEN
1611: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1608: 'jty_tae_index_creation_pvt.create_index has failed with G_EXC_ERROR exception');

1604: WHEN FND_API.G_EXC_ERROR THEN
1605: x_return_status := FND_API.G_RET_STS_ERROR ;
1606: jty_log(FND_LOG.LEVEL_EXCEPTION,
1607: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.g_exc_error',
1608: 'jty_tae_index_creation_pvt.create_index has failed with G_EXC_ERROR exception');
1609:
1610: WHEN OTHERS THEN
1611: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1612: jty_log(FND_LOG.LEVEL_EXCEPTION,

Line 1613: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.others',

1609:
1610: WHEN OTHERS THEN
1611: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1612: jty_log(FND_LOG.LEVEL_EXCEPTION,
1613: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.others',
1614: substr(SQLCODE || ' : ' || SQLERRM, 1, 4000));
1615:
1616: END CREATE_INDEX;
1617:

Line 1638: 'jtf.plsql.jty_tae_index_creation_pvt.drop_table_indexes.begin',

1634: L_SCHEMA_NOTFOUND EXCEPTION;
1635: BEGIN
1636: -- debug message
1637: jty_log(FND_LOG.LEVEL_PROCEDURE,
1638: 'jtf.plsql.jty_tae_index_creation_pvt.drop_table_indexes.begin',
1639: 'Start of the procedure jty_tae_index_creation_pvt.drop_table_indexes ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
1640:
1641: x_return_status := FND_API.G_RET_STS_SUCCESS;
1642:

Line 1639: 'Start of the procedure jty_tae_index_creation_pvt.drop_table_indexes ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

1635: BEGIN
1636: -- debug message
1637: jty_log(FND_LOG.LEVEL_PROCEDURE,
1638: 'jtf.plsql.jty_tae_index_creation_pvt.drop_table_indexes.begin',
1639: 'Start of the procedure jty_tae_index_creation_pvt.drop_table_indexes ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
1640:
1641: x_return_status := FND_API.G_RET_STS_SUCCESS;
1642:
1643: IF(FND_INSTALLATION.GET_APP_INFO('JTF', l_status, l_industry, l_jtf_schema)) THEN

Line 1662: 'jtf.plsql.jty_tae_index_creation_pvt.drop_table_indexes.end',

1658: END LOOP;
1659:
1660: -- debug message
1661: jty_log(FND_LOG.LEVEL_PROCEDURE,
1662: 'jtf.plsql.jty_tae_index_creation_pvt.drop_table_indexes.end',
1663: 'End of the procedure jty_tae_index_creation_pvt.drop_table_indexes ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
1664:
1665: EXCEPTION
1666: WHEN L_SCHEMA_NOTFOUND THEN

Line 1663: 'End of the procedure jty_tae_index_creation_pvt.drop_table_indexes ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

1659:
1660: -- debug message
1661: jty_log(FND_LOG.LEVEL_PROCEDURE,
1662: 'jtf.plsql.jty_tae_index_creation_pvt.drop_table_indexes.end',
1663: 'End of the procedure jty_tae_index_creation_pvt.drop_table_indexes ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
1664:
1665: EXCEPTION
1666: WHEN L_SCHEMA_NOTFOUND THEN
1667: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1669: 'jtf.plsql.jty_tae_index_creation_pvt.drop_table_indexes.l_schema_notfound',

1665: EXCEPTION
1666: WHEN L_SCHEMA_NOTFOUND THEN
1667: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1668: jty_log(FND_LOG.LEVEL_EXCEPTION,
1669: 'jtf.plsql.jty_tae_index_creation_pvt.drop_table_indexes.l_schema_notfound',
1670: 'Schema name corresponding to JTF application not found');
1671:
1672: WHEN OTHERS THEN
1673: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1675: 'jtf.plsql.jty_tae_index_creation_pvt.drop_table_indexes.others',

1671:
1672: WHEN OTHERS THEN
1673: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1674: jty_log(FND_LOG.LEVEL_EXCEPTION,
1675: 'jtf.plsql.jty_tae_index_creation_pvt.drop_table_indexes.others',
1676: substr(SQLCODE || ' : ' || SQLERRM, 1, 4000));
1677:
1678: END DROP_TABLE_INDEXES;
1679:

Line 1697: 'jtf.plsql.jty_tae_index_creation_pvt.truncate_table.start',

1693: BEGIN
1694:
1695: -- debug message
1696: jty_log(FND_LOG.LEVEL_PROCEDURE,
1697: 'jtf.plsql.jty_tae_index_creation_pvt.truncate_table.start',
1698: 'Start of the procedure jty_tae_index_creation_pvt.truncate_table ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
1699:
1700: x_return_status := FND_API.G_RET_STS_SUCCESS;
1701:

Line 1698: 'Start of the procedure jty_tae_index_creation_pvt.truncate_table ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

1694:
1695: -- debug message
1696: jty_log(FND_LOG.LEVEL_PROCEDURE,
1697: 'jtf.plsql.jty_tae_index_creation_pvt.truncate_table.start',
1698: 'Start of the procedure jty_tae_index_creation_pvt.truncate_table ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
1699:
1700: x_return_status := FND_API.G_RET_STS_SUCCESS;
1701:
1702: IF(FND_INSTALLATION.GET_APP_INFO('JTF', l_status, l_industry, l_jtf_schema)) THEN

Line 1715: 'jtf.plsql.jty_tae_index_creation_pvt.truncate_table.end',

1711: EXECUTE IMMEDIATE v_statement;
1712:
1713: -- debug message
1714: jty_log(FND_LOG.LEVEL_PROCEDURE,
1715: 'jtf.plsql.jty_tae_index_creation_pvt.truncate_table.end',
1716: 'End of the procedure jty_tae_index_creation_pvt.truncate_table ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
1717:
1718: EXCEPTION
1719: WHEN OTHERS THEN

Line 1716: 'End of the procedure jty_tae_index_creation_pvt.truncate_table ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

1712:
1713: -- debug message
1714: jty_log(FND_LOG.LEVEL_PROCEDURE,
1715: 'jtf.plsql.jty_tae_index_creation_pvt.truncate_table.end',
1716: 'End of the procedure jty_tae_index_creation_pvt.truncate_table ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
1717:
1718: EXCEPTION
1719: WHEN OTHERS THEN
1720: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1722: 'jtf.plsql.jty_tae_index_creation_pvt.truncate_table.other',

1718: EXCEPTION
1719: WHEN OTHERS THEN
1720: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1721: jty_log(FND_LOG.LEVEL_EXCEPTION,
1722: 'jtf.plsql.jty_tae_index_creation_pvt.truncate_table.other',
1723: substr(SQLCODE || ' : ' || SQLERRM, 1, 4000));
1724:
1725: END TRUNCATE_TABLE;
1726:

Line 1743: 'jtf.plsql.jty_tae_index_creation_pvt.analyze_table_index.start',

1739: BEGIN
1740:
1741: -- debug message
1742: jty_log(FND_LOG.LEVEL_PROCEDURE,
1743: 'jtf.plsql.jty_tae_index_creation_pvt.analyze_table_index.start',
1744: 'Start of the procedure jty_tae_index_creation_pvt.analyze_table_index ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
1745:
1746: x_return_status := FND_API.G_RET_STS_SUCCESS;
1747:

Line 1744: 'Start of the procedure jty_tae_index_creation_pvt.analyze_table_index ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

1740:
1741: -- debug message
1742: jty_log(FND_LOG.LEVEL_PROCEDURE,
1743: 'jtf.plsql.jty_tae_index_creation_pvt.analyze_table_index.start',
1744: 'Start of the procedure jty_tae_index_creation_pvt.analyze_table_index ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
1745:
1746: x_return_status := FND_API.G_RET_STS_SUCCESS;
1747:
1748: IF(FND_INSTALLATION.GET_APP_INFO('JTF', l_status, l_industry, l_jtf_schema)) THEN

Line 1770: 'jtf.plsql.jty_tae_index_creation_pvt.analyze_table_index.end',

1766: );
1767:
1768: -- debug message
1769: jty_log(FND_LOG.LEVEL_PROCEDURE,
1770: 'jtf.plsql.jty_tae_index_creation_pvt.analyze_table_index.end',
1771: 'End of the procedure jty_tae_index_creation_pvt.analyze_table_index ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
1772:
1773: EXCEPTION
1774: WHEN L_SCHEMA_NOTFOUND THEN

Line 1771: 'End of the procedure jty_tae_index_creation_pvt.analyze_table_index ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

1767:
1768: -- debug message
1769: jty_log(FND_LOG.LEVEL_PROCEDURE,
1770: 'jtf.plsql.jty_tae_index_creation_pvt.analyze_table_index.end',
1771: 'End of the procedure jty_tae_index_creation_pvt.analyze_table_index ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
1772:
1773: EXCEPTION
1774: WHEN L_SCHEMA_NOTFOUND THEN
1775: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1777: 'jtf.plsql.jty_tae_index_creation_pvt.analyze_table_index.l_schema_notfound',

1773: EXCEPTION
1774: WHEN L_SCHEMA_NOTFOUND THEN
1775: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1776: jty_log(FND_LOG.LEVEL_EXCEPTION,
1777: 'jtf.plsql.jty_tae_index_creation_pvt.analyze_table_index.l_schema_notfound',
1778: 'Schema name corresponding to JTF application not found');
1779:
1780: WHEN OTHERS THEN
1781: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1783: 'jtf.plsql.jty_tae_index_creation_pvt.analyze_table_index.other',

1779:
1780: WHEN OTHERS THEN
1781: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1782: jty_log(FND_LOG.LEVEL_EXCEPTION,
1783: 'jtf.plsql.jty_tae_index_creation_pvt.analyze_table_index.other',
1784: substr(SQLCODE || ' : ' || SQLERRM, 1, 4000));
1785:
1786: END ANALYZE_TABLE_INDEX;
1787:

Line 1789: END jty_tae_index_creation_pvt;

1785:
1786: END ANALYZE_TABLE_INDEX;
1787:
1788:
1789: END jty_tae_index_creation_pvt;