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 65: x_return_status := FND_API.G_RET_STS_SUCCESS;

61: 'jtf.plsql.jty_tae_index_creation_pvt.bubble_sort.start',
62: 'Start of the procedure jty_tae_index_creation_pvt.bubble_sort');
63: END IF;
64:
65: x_return_status := FND_API.G_RET_STS_SUCCESS;
66:
67: -- bubble sort
68: FOR j in 1..numcol LOOP
69: FOR i in 1..numcol-1 LOOP

Line 96: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

92: END IF;
93:
94: EXCEPTION
95: WHEN OTHERS THEN
96: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
97: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
98: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
99: 'jtf.plsql.jty_tae_index_creation_pvt.bubble_sort.others',
100: substr(SQLCODE || ' : ' || SQLERRM, 1, 4000));

Line 146: x_return_status := FND_API.G_RET_STS_SUCCESS;

142: 'jtf.plsql.jty_tae_index_creation_pvt.cal_selectivity.start',
143: 'Start of the procedure jty_tae_index_creation_pvt.cal_selectivity');
144: END IF;
145:
146: x_return_status := FND_API.G_RET_STS_SUCCESS;
147:
148: IF(FND_INSTALLATION.GET_APP_INFO('JTF', l_status, l_industry, l_jtf_schema)) THEN
149: NULL;
150: END IF;

Line 179: RAISE FND_API.G_EXC_ERROR;

175: 'API jty_tae_index_creation_pvt.cal_selectivity has failed as the number of rows in the table ' ||
176: p_table_name || ' is 0');
177: END IF;
178:
179: RAISE FND_API.G_EXC_ERROR;
180: END IF;
181:
182: FOR i IN 1 ..numcol LOOP
183:

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

199:
200: -- sort
201: Bubble_SORT(o_sel, v_colname, std_dev ,flag, numcol, x_return_status);
202:
203: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
204: -- debug message
205: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
206: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
207: 'jtf.plsql.jty_tae_index_creation_pvt.cal_selectivity.bubble_sort',

Line 211: RAISE FND_API.G_EXC_ERROR;

207: 'jtf.plsql.jty_tae_index_creation_pvt.cal_selectivity.bubble_sort',
208: 'API jty_tae_index_creation_pvt.bubble_sort has failed');
209: END IF;
210:
211: RAISE FND_API.G_EXC_ERROR;
212: END IF;
213:
214: -- debug message
215: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 223: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 231: x_return_status := FND_API.G_RET_STS_ERROR ;

227: 'Schema name corresponding to JTF application not found');
228: END IF;
229:
230: WHEN NO_DATA_FOUND THEN
231: x_return_status := FND_API.G_RET_STS_ERROR ;
232: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
233: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
234: 'jtf.plsql.jty_tae_index_creation_pvt.cal_selectivity.no_data_found',
235: substr(SQLCODE || ' : ' || SQLERRM, 1, 4000));

Line 238: WHEN FND_API.G_EXC_ERROR THEN

234: 'jtf.plsql.jty_tae_index_creation_pvt.cal_selectivity.no_data_found',
235: substr(SQLCODE || ' : ' || SQLERRM, 1, 4000));
236: END IF;
237:
238: WHEN FND_API.G_EXC_ERROR THEN
239: x_return_status := FND_API.G_RET_STS_ERROR ;
240: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
241: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
242: 'jtf.plsql.jty_tae_index_creation_pvt.cal_selectivity.g_exc_error',

Line 239: x_return_status := FND_API.G_RET_STS_ERROR ;

235: substr(SQLCODE || ' : ' || SQLERRM, 1, 4000));
236: END IF;
237:
238: WHEN FND_API.G_EXC_ERROR THEN
239: x_return_status := FND_API.G_RET_STS_ERROR ;
240: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
241: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
242: 'jtf.plsql.jty_tae_index_creation_pvt.cal_selectivity.g_exc_error',
243: 'jty_tae_index_creation_pvt.cal_selectivity has failed with G_EXC_ERROR exception');

Line 247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

243: 'jty_tae_index_creation_pvt.cal_selectivity has failed with G_EXC_ERROR exception');
244: END IF;
245:
246: WHEN OTHERS THEN
247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
248: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
249: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
250: 'jtf.plsql.jty_tae_index_creation_pvt.cal_selectivity.others',
251: substr(SQLCODE || ' : ' || SQLERRM, 1, 4000));

Line 338: x_return_status := FND_API.G_RET_STS_SUCCESS;

334: 'jtf.plsql.jty_tae_index_creation_pvt.dea_selectivity.start',
335: 'Start of the procedure jty_tae_index_creation_pvt.dea_selectivity');
336: END IF;
337:
338: x_return_status := FND_API.G_RET_STS_SUCCESS;
339:
340: i := 1;
341: j := 0;
342:

Line 361: RAISE FND_API.G_EXC_ERROR;

357: 'jtf.plsql.jty_tae_index_creation_pvt.dea_selectivity.col_name',
358: 'API jty_tae_index_creation_pvt.dea_selectivity has failed as there is no valid column name, or all flag = No');
359: END IF;
360:
361: RAISE FND_API.G_EXC_ERROR;
362: END IF;
363:
364: CAL_SELECTIVITY(
365: p_table_name => p_table_name,

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

369: flag => flag,
370: numcol => i-1,
371: x_return_status => x_return_status);
372:
373: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
374: -- debug message
375: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
376: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
377: 'jtf.plsql.jty_tae_index_creation_pvt.dea_selectivity.cal_selectivity',

Line 381: RAISE FND_API.G_EXC_ERROR;

377: 'jtf.plsql.jty_tae_index_creation_pvt.dea_selectivity.cal_selectivity',
378: 'API jty_tae_index_creation_pvt.cal_selectivity has failed');
379: END IF;
380:
381: RAISE FND_API.G_EXC_ERROR;
382: END IF;
383:
384: -- update JTY_DEA_ATTR_FACTORS
385: FOR i IN 1..col_name.count LOOP

Line 403: WHEN FND_API.G_EXC_ERROR THEN

399: 'End of the procedure jty_tae_index_creation_pvt.dea_selectivity');
400: END IF;
401:
402: EXCEPTION
403: WHEN FND_API.G_EXC_ERROR THEN
404: x_return_status := FND_API.G_RET_STS_ERROR ;
405: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
406: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
407: 'jtf.plsql.jty_tae_index_creation_pvt.dea_selectivity.g_exc_error',

Line 404: x_return_status := FND_API.G_RET_STS_ERROR ;

400: END IF;
401:
402: EXCEPTION
403: WHEN FND_API.G_EXC_ERROR THEN
404: x_return_status := FND_API.G_RET_STS_ERROR ;
405: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
406: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
407: 'jtf.plsql.jty_tae_index_creation_pvt.dea_selectivity.g_exc_error',
408: 'jty_tae_index_creation_pvt.dea_selectivity has failed with G_EXC_ERROR exception');

Line 412: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

408: 'jty_tae_index_creation_pvt.dea_selectivity has failed with G_EXC_ERROR exception');
409: END IF;
410:
411: WHEN OTHERS THEN
412: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
413: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
414: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
415: 'jtf.plsql.jty_tae_index_creation_pvt.dea_selectivity.others',
416: substr(SQLCODE || ' : ' || SQLERRM, 1, 4000));

Line 530: x_return_status := FND_API.G_RET_STS_SUCCESS;

526: 'jtf.plsql.jty_tae_index_creation_pvt.selectivity.start',
527: 'Start of the procedure jty_tae_index_creation_pvt.selectivity');
528: END IF;
529:
530: x_return_status := FND_API.G_RET_STS_SUCCESS;
531:
532: i := 1;
533: j := 0;
534:

Line 575: RAISE FND_API.G_EXC_ERROR;

571: 'jtf.plsql.jty_tae_index_creation_pvt.selectivity.col_name',
572: 'API jty_tae_index_creation_pvt.selectivity has failed as there is no valid column name, or all flag = No');
573: END IF;
574:
575: RAISE FND_API.G_EXC_ERROR;
576: END IF;
577:
578: CAL_SELECTIVITY(
579: p_table_name => p_table_name,

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

583: flag => flag,
584: numcol => i-1,
585: x_return_status => x_return_status);
586:
587: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
588: -- debug message
589: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
590: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
591: 'jtf.plsql.jty_tae_index_creation_pvt.selectivity.cal_selectivity',

Line 595: RAISE FND_API.G_EXC_ERROR;

591: 'jtf.plsql.jty_tae_index_creation_pvt.selectivity.cal_selectivity',
592: 'API jty_tae_index_creation_pvt.selectivity has failed');
593: END IF;
594:
595: RAISE FND_API.G_EXC_ERROR;
596: END IF;
597:
598: IF (p_source_id IS NULL) THEN
599: -- update JTF_TAE_QUAL_FACTORS

Line 635: WHEN FND_API.G_EXC_ERROR THEN

631: 'End of the procedure jty_tae_index_creation_pvt.selectivity');
632: END IF;
633:
634: EXCEPTION
635: WHEN FND_API.G_EXC_ERROR THEN
636: x_return_status := FND_API.G_RET_STS_ERROR ;
637: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
638: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
639: 'jtf.plsql.jty_tae_index_creation_pvt.selectivity.g_exc_error',

Line 636: x_return_status := FND_API.G_RET_STS_ERROR ;

632: END IF;
633:
634: EXCEPTION
635: WHEN FND_API.G_EXC_ERROR THEN
636: x_return_status := FND_API.G_RET_STS_ERROR ;
637: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
638: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
639: 'jtf.plsql.jty_tae_index_creation_pvt.selectivity.g_exc_error',
640: 'jty_tae_index_creation_pvt.selectivity has failed with G_EXC_ERROR exception');

Line 644: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

640: 'jty_tae_index_creation_pvt.selectivity has failed with G_EXC_ERROR exception');
641: END IF;
642:
643: WHEN OTHERS THEN
644: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
645: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
646: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
647: 'jtf.plsql.jty_tae_index_creation_pvt.selectivity.others',
648: substr(SQLCODE || ' : ' || SQLERRM, 1, 4000));

Line 682: x_return_status := FND_API.G_RET_STS_SUCCESS;

678: 'jtf.plsql.jty_tae_index_creation_pvt.get_qual_comb_index.begin',
679: 'Start of the procedure jty_tae_index_creation_pvt.get_qual_comb_index');
680: END IF;
681:
682: x_return_status := FND_API.G_RET_STS_SUCCESS;
683:
684: IF(FND_INSTALLATION.GET_APP_INFO('JTF', l_status, l_industry, l_jtf_schema)) THEN
685: NULL;
686: END IF;

Line 757: x_return_status := FND_API.G_RET_STS_ERROR ;

753: END IF;
754:
755: EXCEPTION
756: WHEN L_SCHEMA_NOTFOUND THEN
757: x_return_status := FND_API.G_RET_STS_ERROR ;
758: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
759: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
760: 'jtf.plsql.jty_tae_index_creation_pvt.get_qual_comb_index.l_schema_notfound',
761: 'Schema name corresponding to JTF application not found');

Line 765: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

761: 'Schema name corresponding to JTF application not found');
762: END IF;
763:
764: WHEN OTHERS THEN
765: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
766: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
767: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
768: 'jtf.plsql.jty_tae_index_creation_pvt.get_qual_comb_index.others',
769: substr(SQLCODE || ' : ' || SQLERRM, 1, 4000));

Line 996: x_return_status := FND_API.G_RET_STS_SUCCESS;

992: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.begin',
993: 'Start of the procedure jty_tae_index_creation_pvt.create_index');
994: END IF;
995:
996: x_return_status := FND_API.G_RET_STS_SUCCESS;
997:
998: /* Initialize the flags */
999: lx_4841_idx_created := 'N';
1000: lx_324347_idx_created := 'N';

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

1162: x_return_status => x_return_status,
1163: x_statement => V_STATEMENT,
1164: alter_statement => ALTER_STATEMENT );
1165:
1166: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1167: -- debug message
1168: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1169: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1170: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.4841',

Line 1174: RAISE FND_API.G_EXC_ERROR;

1170: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.4841',
1171: 'API jty_tae_index_creation_pvt.get_qual_comb_index has failed for qualifier comb 4841');
1172: END IF;
1173:
1174: RAISE FND_API.G_EXC_ERROR;
1175: END IF;
1176:
1177: lx_4841_idx_created := 'Y';
1178: ELSE

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

1192: x_return_status => x_return_status,
1193: x_statement => V_STATEMENT,
1194: alter_statement => ALTER_STATEMENT );
1195:
1196: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1197: -- debug message
1198: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1199: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1200: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.324347',

Line 1204: RAISE FND_API.G_EXC_ERROR;

1200: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.324347',
1201: 'API jty_tae_index_creation_pvt.get_qual_comb_index has failed for qualifier comb 324347');
1202: END IF;
1203:
1204: RAISE FND_API.G_EXC_ERROR;
1205: END IF;
1206:
1207: lx_324347_idx_created := 'Y';
1208: ELSE

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

1301: x_return_status => x_return_status,
1302: x_statement => V_STATEMENT,
1303: alter_statement => ALTER_STATEMENT );
1304:
1305: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1306: -- debug message
1307: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1308: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1309: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.324347_reverse',

Line 1313: RAISE FND_API.G_EXC_ERROR;

1309: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.324347_reverse',
1310: 'API jty_tae_index_creation_pvt.get_qual_comb_index has failed for qualifier comb 324347_reverse');
1311: END IF;
1312:
1313: RAISE FND_API.G_EXC_ERROR;
1314: END IF;
1315:
1316: lx_rev_324347_idx_created := 'Y';
1317: ELSE

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

1433: x_return_status => x_return_status,
1434: x_statement => V_STATEMENT,
1435: alter_statement => ALTER_STATEMENT );
1436:
1437: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1438: -- debug message
1439: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1440: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1441: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.dea_4841',

Line 1445: RAISE FND_API.G_EXC_ERROR;

1441: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.dea_4841',
1442: 'API jty_tae_index_creation_pvt.get_qual_comb_index has failed for qualifier comb dea_4841');
1443: END IF;
1444:
1445: RAISE FND_API.G_EXC_ERROR;
1446: END IF;
1447:
1448: lx_4841_idx_created := 'Y';
1449: ELSE

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

1463: x_return_status => x_return_status,
1464: x_statement => V_STATEMENT,
1465: alter_statement => ALTER_STATEMENT );
1466:
1467: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1468: -- debug message
1469: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1470: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1471: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.dea_324347',

Line 1475: RAISE FND_API.G_EXC_ERROR;

1471: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.dea_324347',
1472: 'API jty_tae_index_creation_pvt.get_qual_comb_index has failed for qualifier comb dea_324347');
1473: END IF;
1474:
1475: RAISE FND_API.G_EXC_ERROR;
1476: END IF;
1477:
1478: lx_324347_idx_created := 'Y';
1479: ELSE

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

1556: x_return_status => x_return_status,
1557: x_statement => V_STATEMENT,
1558: alter_statement => ALTER_STATEMENT );
1559:
1560: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1561: -- debug message
1562: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1563: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1564: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.dea_324347_reverse',

Line 1568: RAISE FND_API.G_EXC_ERROR;

1564: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.dea_324347_reverse',
1565: 'API jty_tae_index_creation_pvt.get_qual_comb_index has failed for qualifier comb dea_324347_reverse');
1566: END IF;
1567:
1568: RAISE FND_API.G_EXC_ERROR;
1569: END IF;
1570:
1571: lx_rev_324347_idx_created := 'Y';
1572: ELSE

Line 1688: x_return_status := FND_API.G_RET_STS_ERROR ;

1684: END IF;
1685:
1686: EXCEPTION
1687: WHEN NO_DATA_FOUND THEN
1688: x_return_status := FND_API.G_RET_STS_ERROR ;
1689: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1690: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1691: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.no_data_found',
1692: 'API jty_tae_index_creation_pvt.create_index has failed with no_data_found');

Line 1695: WHEN FND_API.G_EXC_ERROR THEN

1691: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.no_data_found',
1692: 'API jty_tae_index_creation_pvt.create_index has failed with no_data_found');
1693: END IF;
1694:
1695: WHEN FND_API.G_EXC_ERROR THEN
1696: x_return_status := FND_API.G_RET_STS_ERROR ;
1697: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1698: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1699: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.g_exc_error',

Line 1696: x_return_status := FND_API.G_RET_STS_ERROR ;

1692: 'API jty_tae_index_creation_pvt.create_index has failed with no_data_found');
1693: END IF;
1694:
1695: WHEN FND_API.G_EXC_ERROR THEN
1696: x_return_status := FND_API.G_RET_STS_ERROR ;
1697: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1698: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1699: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.g_exc_error',
1700: 'jty_tae_index_creation_pvt.create_index has failed with G_EXC_ERROR exception');

Line 1704: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1700: 'jty_tae_index_creation_pvt.create_index has failed with G_EXC_ERROR exception');
1701: END IF;
1702:
1703: WHEN OTHERS THEN
1704: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1705: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1706: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1707: 'jtf.plsql.jty_tae_index_creation_pvt.create_index.others',
1708: substr(SQLCODE || ' : ' || SQLERRM, 1, 4000));

Line 1738: x_return_status := FND_API.G_RET_STS_SUCCESS;

1734: 'jtf.plsql.jty_tae_index_creation_pvt.drop_table_indexes.begin',
1735: 'Start of the procedure jty_tae_index_creation_pvt.drop_table_indexes');
1736: END IF;
1737:
1738: x_return_status := FND_API.G_RET_STS_SUCCESS;
1739:
1740: IF(FND_INSTALLATION.GET_APP_INFO('JTF', l_status, l_industry, l_jtf_schema)) THEN
1741: NULL;
1742: END IF;

Line 1766: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1762: END IF;
1763:
1764: EXCEPTION
1765: WHEN L_SCHEMA_NOTFOUND THEN
1766: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1767: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1768: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1769: 'jtf.plsql.jty_tae_index_creation_pvt.drop_table_indexes.l_schema_notfound',
1770: 'Schema name corresponding to JTF application not found');

Line 1774: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1770: 'Schema name corresponding to JTF application not found');
1771: END IF;
1772:
1773: WHEN OTHERS THEN
1774: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1775: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1776: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1777: 'jtf.plsql.jty_tae_index_creation_pvt.drop_table_indexes.others',
1778: substr(SQLCODE || ' : ' || SQLERRM, 1, 4000));

Line 1805: x_return_status := FND_API.G_RET_STS_SUCCESS;

1801: 'jtf.plsql.jty_tae_index_creation_pvt.truncate_table.start',
1802: 'Start of the procedure jty_tae_index_creation_pvt.truncate_table');
1803: END IF;
1804:
1805: x_return_status := FND_API.G_RET_STS_SUCCESS;
1806:
1807: IF(FND_INSTALLATION.GET_APP_INFO('JTF', l_status, l_industry, l_jtf_schema)) THEN
1808: NULL;
1809: END IF;

Line 1827: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1823: END IF;
1824:
1825: EXCEPTION
1826: WHEN OTHERS THEN
1827: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1828: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1829: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1830: 'jtf.plsql.jty_tae_index_creation_pvt.truncate_table.other',
1831: substr(SQLCODE || ' : ' || SQLERRM, 1, 4000));

Line 1857: x_return_status := FND_API.G_RET_STS_SUCCESS;

1853: 'jtf.plsql.jty_tae_index_creation_pvt.analyze_table_index.start',
1854: 'Start of the procedure jty_tae_index_creation_pvt.analyze_table_index');
1855: END IF;
1856:
1857: x_return_status := FND_API.G_RET_STS_SUCCESS;
1858:
1859: IF(FND_INSTALLATION.GET_APP_INFO('JTF', l_status, l_industry, l_jtf_schema)) THEN
1860: NULL;
1861: END IF;

Line 1888: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1884: END IF;
1885:
1886: EXCEPTION
1887: WHEN L_SCHEMA_NOTFOUND THEN
1888: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1889: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1890: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1891: 'jtf.plsql.jty_tae_index_creation_pvt.analyze_table_index.l_schema_notfound',
1892: 'Schema name corresponding to JTF application not found');

Line 1896: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1892: 'Schema name corresponding to JTF application not found');
1893: END IF;
1894:
1895: WHEN OTHERS THEN
1896: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1897: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1898: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1899: 'jtf.plsql.jty_tae_index_creation_pvt.analyze_table_index.other',
1900: substr(SQLCODE || ' : ' || SQLERRM, 1, 4000));