APPS.JTF_TAE_INDEX_CREATION_PVT dependencies on FND_API

Line 538: x_return_status := FND_API.G_RET_STS_SUCCESS;

534: l_index_name.TRIM(l_no_of_indexes);
535: l_owner.TRIM(l_no_of_indexes);
536: end if;
537:
538: x_return_status := FND_API.G_RET_STS_SUCCESS;
539:
540: EXCEPTION
541: WHEN L_SCHEMA_NOTFOUND THEN
542:

Line 543: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

539:
540: EXCEPTION
541: WHEN L_SCHEMA_NOTFOUND THEN
542:
543: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
544:
545: ERRBUF := 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX_WO_WORKER_ID: [END] SCHEMA NAME FOUND CORRESPONDING TO JTF APPLICATION. ';
546:
547: If JTF_TAE_CONTROL_PVT.G_DEBUG Then

Line 553: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

549: End If;
550:
551: WHEN OTHERS THEN
552:
553: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
554:
555: ERRBUF := 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX_WO_WORKER_ID: [END] OTHERS: ' ||
556: p_table_name || ': ' || SQLERRM;
557:

Line 743: x_return_status := FND_API.G_RET_STS_SUCCESS;

739: s_statement := s_statement || ' COMPUTE STATISTICS ';
740:
741: s_statement := s_statement || ' NOLOGGING PARALLEL ' || l_dop;
742:
743: x_return_status := FND_API.G_RET_STS_SUCCESS;
744:
745:
746: -- indexes for TRANS table
747: IF ( UPPER(p_table_name) LIKE 'JTF_TAE%_TRANS') THEN

Line 1127: x_return_status := FND_API.G_RET_STS_ERROR ;

1123:
1124: EXCEPTION
1125: WHEN NO_DATA_FOUND THEN
1126:
1127: x_return_status := FND_API.G_RET_STS_ERROR ;
1128:
1129: ERRBUF := 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX: [END] NO_DATA_FOUND: ' ||
1130: p_table_name || ': ' || SQLERRM;
1131:

Line 1138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1134: End If;
1135:
1136: WHEN OTHERS THEN
1137:
1138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1139:
1140: ERRBUF := 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX: [END] OTHERS: ' ||
1141: p_table_name || ': ' || SQLERRM;
1142:

Line 1191: x_return_status := FND_API.G_RET_STS_SUCCESS;

1187: EXECUTE IMMEDIATE v_statement;
1188:
1189: END LOOP;
1190:
1191: x_return_status := FND_API.G_RET_STS_SUCCESS;
1192:
1193: EXCEPTION
1194: WHEN L_SCHEMA_NOTFOUND THEN
1195:

Line 1196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1192:
1193: EXCEPTION
1194: WHEN L_SCHEMA_NOTFOUND THEN
1195:
1196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1197: RETCODE := 2;
1198: ERRBUF := 'JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES: [END] SCHEMA NAME FOUND CORRESPONDING TO JTF APPLICATION. ';
1199:
1200: If JTF_TAE_CONTROL_PVT.G_DEBUG Then

Line 1206: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1202: End If;
1203:
1204: WHEN OTHERS THEN
1205:
1206: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1207: RETCODE := 2;
1208: ERRBUF := 'JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES: [END] OTHERS: ' ||
1209: p_table_name || ': ' || SQLERRM;
1210:

Line 1240: x_return_status := FND_API.G_RET_STS_SUCCESS;

1236: EXECUTE IMMEDIATE v_statement;
1237: commit;
1238:
1239: --dbms_output.put_line('TAE_INDEX_CREATION .truncate_tablee: v_statement = ' || v_statement);
1240: x_return_status := FND_API.G_RET_STS_SUCCESS;
1241:
1242: EXCEPTION
1243: WHEN OTHERS THEN
1244:

Line 1245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1241:
1242: EXCEPTION
1243: WHEN OTHERS THEN
1244:
1245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1246: RETCODE := 2;
1247: ERRBUF := 'JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE: [END] OTHERS: ' ||
1248: p_table_name || ': ' || SQLERRM;
1249:

Line 1291: x_return_status := FND_API.G_RET_STS_SUCCESS;

1287: hmode => 'FULL'
1288:
1289: );
1290:
1291: x_return_status := FND_API.G_RET_STS_SUCCESS;
1292:
1293: EXCEPTION
1294: WHEN OTHERS THEN
1295:

Line 1296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1292:
1293: EXCEPTION
1294: WHEN OTHERS THEN
1295:
1296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1297: RETCODE := 2;
1298: ERRBUF := 'JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX: [END] OTHERS: ' ||
1299: p_table_name || ': ' || SQLERRM;
1300: