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_LOG

Line 36: IF (p_log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

32: ,p_message IN VARCHAR2)
33: IS
34: pragma autonomous_transaction;
35: BEGIN
36: IF (p_log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
37: FND_LOG.string(p_log_level, p_module, p_message);
38: commit;
39: END IF;
40: END;

Line 37: FND_LOG.string(p_log_level, p_module, p_message);

33: IS
34: pragma autonomous_transaction;
35: BEGIN
36: IF (p_log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
37: FND_LOG.string(p_log_level, p_module, p_message);
38: commit;
39: END IF;
40: END;
41:

Line 71: jty_log(FND_LOG.LEVEL_PROCEDURE,

67: ch VARCHAR2(30);
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;

Line 98: jty_log(FND_LOG.LEVEL_PROCEDURE,

94: END LOOP;
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

Line 105: jty_log(FND_LOG.LEVEL_EXCEPTION,

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:
109: END Bubble_SORT;

Line 146: jty_log(FND_LOG.LEVEL_PROCEDURE,

142: i integer;
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;

Line 168: jty_log(FND_LOG.LEVEL_STATEMENT,

164: WHERE dt.owner = l_jtf_schema
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

Line 174: jty_log(FND_LOG.LEVEL_EXCEPTION,

170: 'Number of rows for table ' || p_table_name || ' : ' || v_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:

Line 206: jty_log(FND_LOG.LEVEL_EXCEPTION,

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');
209:
210: RAISE FND_API.G_EXC_ERROR;

Line 214: jty_log(FND_LOG.LEVEL_PROCEDURE,

210: RAISE FND_API.G_EXC_ERROR;
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

Line 221: jty_log(FND_LOG.LEVEL_EXCEPTION,

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:
225: WHEN NO_DATA_FOUND THEN

Line 227: jty_log(FND_LOG.LEVEL_EXCEPTION,

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:
231: WHEN FND_API.G_EXC_ERROR THEN

Line 233: jty_log(FND_LOG.LEVEL_EXCEPTION,

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:
237: WHEN OTHERS THEN

Line 239: jty_log(FND_LOG.LEVEL_EXCEPTION,

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:
243: END CAL_SELECTIVITY;

Line 321: jty_log(FND_LOG.LEVEL_PROCEDURE,

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

Line 342: jty_log(FND_LOG.LEVEL_EXCEPTION,

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

Line 360: jty_log(FND_LOG.LEVEL_EXCEPTION,

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');
363:
364: RAISE FND_API.G_EXC_ERROR;

Line 379: jty_log(FND_LOG.LEVEL_PROCEDURE,

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

Line 386: jty_log(FND_LOG.LEVEL_EXCEPTION,

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:
390: WHEN OTHERS THEN

Line 392: jty_log(FND_LOG.LEVEL_EXCEPTION,

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:
396: END DEA_SELECTIVITY;

Line 501: jty_log(FND_LOG.LEVEL_PROCEDURE,

497: AND B.source_id = cl_source_id;
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;

Line 544: jty_log(FND_LOG.LEVEL_EXCEPTION,

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

Line 562: jty_log(FND_LOG.LEVEL_EXCEPTION,

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');
565:
566: RAISE FND_API.G_EXC_ERROR;

Line 599: jty_log(FND_LOG.LEVEL_PROCEDURE,

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

Line 606: jty_log(FND_LOG.LEVEL_EXCEPTION,

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:
610: WHEN OTHERS THEN

Line 612: jty_log(FND_LOG.LEVEL_EXCEPTION,

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:
616: END SELECTIVITY;

Line 641: jty_log(FND_LOG.LEVEL_PROCEDURE,

637: L_SCHEMA_NOTFOUND EXCEPTION;
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;

Line 705: jty_log(FND_LOG.LEVEL_STATEMENT,

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

Line 710: jty_log(FND_LOG.LEVEL_PROCEDURE,

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

Line 717: jty_log(FND_LOG.LEVEL_EXCEPTION,

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:
721: WHEN OTHERS THEN

Line 723: jty_log(FND_LOG.LEVEL_EXCEPTION,

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:
727: END get_qual_comb_index;

Line 945: jty_log(FND_LOG.LEVEL_PROCEDURE,

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

Line 970: jty_log(FND_LOG.LEVEL_STATEMENT,

966: WHERE v.name = 'parallel_max_servers'
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 */

Line 983: jty_log(FND_LOG.LEVEL_STATEMENT,

979: AND a.application_id = i.application_id
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:

Line 1005: jty_log(FND_LOG.LEVEL_EXCEPTION,

1001: AND trans_type_id = p_trans_id
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;

Line 1020: jty_log(FND_LOG.LEVEL_EXCEPTION,

1016: WHERE source_id = p_source_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;

Line 1028: jty_log(FND_LOG.LEVEL_STATEMENT,

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

Line 1037: jty_log(FND_LOG.LEVEL_STATEMENT,

1033: -- indexes for TRANS table
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,

Line 1041: jty_log(FND_LOG.LEVEL_STATEMENT,

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',
1043: 'Index Name : ' || c1.index_name);
1044: END LOOP;
1045:

Line 1060: jty_log(FND_LOG.LEVEL_STATEMENT,

1056: END IF;
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;

Line 1107: jty_log(FND_LOG.LEVEL_EXCEPTION,

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');
1110:
1111: RAISE FND_API.G_EXC_ERROR;

Line 1135: jty_log(FND_LOG.LEVEL_EXCEPTION,

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');
1138:
1139: RAISE FND_API.G_EXC_ERROR;

Line 1186: jty_log(FND_LOG.LEVEL_STATEMENT,

1182: v_statement := v_statement || s_statement;
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;

Line 1204: jty_log(FND_LOG.LEVEL_STATEMENT,

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

Line 1238: jty_log(FND_LOG.LEVEL_EXCEPTION,

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');
1241:
1242: RAISE FND_API.G_EXC_ERROR;

Line 1290: jty_log(FND_LOG.LEVEL_STATEMENT,

1286: v_statement := v_statement || s_statement;
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;

Line 1308: jty_log(FND_LOG.LEVEL_STATEMENT,

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

Line 1364: jty_log(FND_LOG.LEVEL_EXCEPTION,

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');
1367:
1368: RAISE FND_API.G_EXC_ERROR;

Line 1392: jty_log(FND_LOG.LEVEL_EXCEPTION,

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');
1395:
1396: RAISE FND_API.G_EXC_ERROR;

Line 1448: jty_log(FND_LOG.LEVEL_STATEMENT,

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

Line 1481: jty_log(FND_LOG.LEVEL_EXCEPTION,

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');
1484:
1485: RAISE FND_API.G_EXC_ERROR;

Line 1533: jty_log(FND_LOG.LEVEL_STATEMENT,

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

Line 1549: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1545:
1546: EXECUTE IMMEDIATE v_statement;
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;

Line 1550: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1546: EXECUTE IMMEDIATE v_statement;
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: */

Line 1567: jty_log(FND_LOG.LEVEL_STATEMENT,

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

Line 1583: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1579:
1580: EXECUTE IMMEDIATE v_statement;
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;

Line 1584: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1580: EXECUTE IMMEDIATE v_statement;
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: */

Line 1593: jty_log(FND_LOG.LEVEL_PROCEDURE,

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

Line 1600: jty_log(FND_LOG.LEVEL_EXCEPTION,

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:
1604: WHEN FND_API.G_EXC_ERROR THEN

Line 1606: jty_log(FND_LOG.LEVEL_EXCEPTION,

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:
1610: WHEN OTHERS THEN

Line 1612: jty_log(FND_LOG.LEVEL_EXCEPTION,

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:
1616: END CREATE_INDEX;

Line 1637: jty_log(FND_LOG.LEVEL_PROCEDURE,

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

Line 1661: jty_log(FND_LOG.LEVEL_PROCEDURE,

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

Line 1668: jty_log(FND_LOG.LEVEL_EXCEPTION,

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:
1672: WHEN OTHERS THEN

Line 1674: jty_log(FND_LOG.LEVEL_EXCEPTION,

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:
1678: END DROP_TABLE_INDEXES;

Line 1696: jty_log(FND_LOG.LEVEL_PROCEDURE,

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

Line 1714: jty_log(FND_LOG.LEVEL_PROCEDURE,

1710: v_statement := 'TRUNCATE TABLE ' || l_jtf_schema || '.' || p_TABLE_NAME || ' DROP STORAGE';
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

Line 1721: jty_log(FND_LOG.LEVEL_EXCEPTION,

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:
1725: END TRUNCATE_TABLE;

Line 1742: jty_log(FND_LOG.LEVEL_PROCEDURE,

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

Line 1769: jty_log(FND_LOG.LEVEL_PROCEDURE,

1765: hmode => 'FULL'
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

Line 1776: jty_log(FND_LOG.LEVEL_EXCEPTION,

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:
1780: WHEN OTHERS THEN

Line 1782: jty_log(FND_LOG.LEVEL_EXCEPTION,

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:
1786: END ANALYZE_TABLE_INDEX;