APPS.JTF_TAE_INDEX_CREATION_PVT dependencies on FND_API

Line 537: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 742: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 1126: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 1137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1190: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 1195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1205: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1239: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 1244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1290: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 1295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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