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 FND_API

Line 75: x_return_status := FND_API.G_RET_STS_SUCCESS;

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
78: FOR j in 1..numcol LOOP
79: FOR i in 1..numcol-1 LOOP

Line 104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 150: x_return_status := FND_API.G_RET_STS_SUCCESS;

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
153: NULL;
154: END IF;

Line 179: RAISE FND_API.G_EXC_ERROR;

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;
181:
182: FOR i IN 1 ..numcol LOOP
183:

Line 204: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

200:
201: -- sort
202: Bubble_SORT(o_sel, v_colname, std_dev ,flag, numcol, x_return_status);
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');

Line 210: RAISE FND_API.G_EXC_ERROR;

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:
213: -- debug message
214: jty_log(FND_LOG.LEVEL_PROCEDURE,

Line 220: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 226: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 231: WHEN FND_API.G_EXC_ERROR THEN

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

Line 232: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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,
240: 'jtf.plsql.jty_tae_index_creation_pvt.cal_selectivity.others',
241: substr(SQLCODE || ' : ' || SQLERRM, 1, 4000));
242:

Line 325: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
328: j := 0;
329:

Line 346: -- RAISE FND_API.G_EXC_ERROR;

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
349: CAL_SELECTIVITY(
350: p_table_name => p_table_name,

Line 358: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

354: flag => flag,
355: numcol => i-1,
356: x_return_status => x_return_status);
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');

Line 364: RAISE FND_API.G_EXC_ERROR;

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:
367: -- update JTY_DEA_ATTR_FACTORS
368: FOR i IN 1..col_name.count LOOP

Line 384: WHEN FND_API.G_EXC_ERROR THEN

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

Line 385: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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,
393: 'jtf.plsql.jty_tae_index_creation_pvt.dea_selectivity.others',
394: substr(SQLCODE || ' : ' || SQLERRM, 1, 4000));
395:

Line 505: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
508: j := 0;
509:

Line 548: -- RAISE FND_API.G_EXC_ERROR;

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
551: CAL_SELECTIVITY(
552: p_table_name => p_table_name,

Line 560: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

556: flag => flag,
557: numcol => i-1,
558: x_return_status => x_return_status);
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');

Line 566: RAISE FND_API.G_EXC_ERROR;

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:
569: IF (p_source_id IS NULL) THEN
570: -- update JTF_TAE_QUAL_FACTORS

Line 604: WHEN FND_API.G_EXC_ERROR THEN

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

Line 605: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 611: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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,
613: 'jtf.plsql.jty_tae_index_creation_pvt.selectivity.others',
614: substr(SQLCODE || ' : ' || SQLERRM, 1, 4000));
615:

Line 645: x_return_status := FND_API.G_RET_STS_SUCCESS;

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
648: NULL;
649: END IF;

Line 716: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 722: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 949: x_return_status := FND_API.G_RET_STS_SUCCESS;

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 */
952: lx_4841_idx_created := 'N';
953: lx_324347_idx_created := 'N';

Line 1105: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1101: x_return_status => x_return_status,
1102: x_statement => V_STATEMENT,
1103: alter_statement => ALTER_STATEMENT );
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');

Line 1111: RAISE FND_API.G_EXC_ERROR;

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:
1114: lx_4841_idx_created := 'Y';
1115: ELSE

Line 1133: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1129: x_return_status => x_return_status,
1130: x_statement => V_STATEMENT,
1131: alter_statement => ALTER_STATEMENT );
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');

Line 1139: RAISE FND_API.G_EXC_ERROR;

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:
1142: lx_324347_idx_created := 'Y';
1143: ELSE

Line 1236: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1232: x_return_status => x_return_status,
1233: x_statement => V_STATEMENT,
1234: alter_statement => ALTER_STATEMENT );
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');

Line 1242: RAISE FND_API.G_EXC_ERROR;

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:
1245: lx_rev_324347_idx_created := 'Y';
1246: ELSE

Line 1362: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1358: x_return_status => x_return_status,
1359: x_statement => V_STATEMENT,
1360: alter_statement => ALTER_STATEMENT );
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');

Line 1368: RAISE FND_API.G_EXC_ERROR;

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:
1371: lx_4841_idx_created := 'Y';
1372: ELSE

Line 1390: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1386: x_return_status => x_return_status,
1387: x_statement => V_STATEMENT,
1388: alter_statement => ALTER_STATEMENT );
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');

Line 1396: RAISE FND_API.G_EXC_ERROR;

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:
1399: lx_324347_idx_created := 'Y';
1400: ELSE

Line 1479: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1475: x_return_status => x_return_status,
1476: x_statement => V_STATEMENT,
1477: alter_statement => ALTER_STATEMENT );
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');

Line 1485: RAISE FND_API.G_EXC_ERROR;

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:
1488: lx_rev_324347_idx_created := 'Y';
1489: ELSE

Line 1599: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 1604: WHEN FND_API.G_EXC_ERROR THEN

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

Line 1605: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 1611: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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,
1613: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.others',
1614: substr(SQLCODE || ' : ' || SQLERRM, 1, 4000));
1615:

Line 1641: x_return_status := FND_API.G_RET_STS_SUCCESS;

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
1644: NULL;
1645: END IF;

Line 1667: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1673: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1700: x_return_status := FND_API.G_RET_STS_SUCCESS;

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
1703: NULL;
1704: END IF;

Line 1720: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1746: x_return_status := FND_API.G_RET_STS_SUCCESS;

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
1749: NULL;
1750: END IF;

Line 1775: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1781: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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