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.CSF_SPATIAL_DATALOAD_PVT dependencies on FND_API

Line 167: RAISE FND_API.G_EXC_ERROR;

163: retcode := 1;
164: errbuf := SQLERRM;
165: put_stream(g_log, 'Index Creation for ' || p_index || ' failed : ' ||SQLCODE||'-'|| SQLERRM );
166: put_stream(g_output, 'Index Creation for ' || p_index || ' failed : ' ||SQLCODE||'-'|| SQLERRM );
167: RAISE FND_API.G_EXC_ERROR;
168: --dbms_output.put_line( 'Index Creation for ' || p_index || ' failed : ' || SQLERRM );
169: END IF ;
170:
171: END CREATE_INDEX;

Line 237: RAISE FND_API.G_EXC_ERROR;

233: retcode := 1;
234: errbuf := SQLERRM;
235: put_stream(g_log,'DROP_INDEXES PROCEDURE HAS FAILED FOR '|| p_index_type || 'TYPE INDEXES' || SQLERRM);
236: put_stream(g_output,'DROP_INDEXES PROCEDURE HAS FAILED FOR '|| p_index_type || 'TYPE INDEXES' || SQLERRM);
237: RAISE FND_API.G_EXC_ERROR;
238:
239: WHEN OTHERS
240: THEN
241: retcode := 1;

Line 245: RAISE FND_API.G_EXC_ERROR;

241: retcode := 1;
242: errbuf := SQLERRM;
243: put_stream(g_log,'DROP_INDEXES PROCEDURE HAS FAILED '||SQLCODE||'-'|| SQLERRM);
244: CLOSE CSF_GET_SPATIAL_INDEXES;
245: RAISE FND_API.G_EXC_ERROR;
246:
247: END DROP_INDEXES;
248:
249:

Line 266: RAISE FND_API.G_EXC_ERROR;

262: retcode := 1;
263: errbuf := SQLERRM;
264: put_stream(g_output, 'Refresh of ' || p_mv_name || ' failed : ' ||SQLCODE||'-'|| SQLERRM );
265: put_stream(g_log, 'Refresh of ' || p_mv_name || ' failed : ' || SQLCODE||'-'||SQLERRM );
266: RAISE FND_API.G_EXC_ERROR;
267: END REFRESH_MAT_VIEW;
268:
269: PROCEDURE REFRESH_MAT_VIEWS(
270: p_data_set_name IN VARCHAR2,

Line 305: RAISE FND_API.G_EXC_ERROR;

301: put_stream(g_output,'REFRESH_MAT_VIEW PROCEDURE HAS FAILED' ||SQLCODE||'-'|| SQLERRM );
302: put_stream(g_log, 'REFRESH_MAT_VIEW PROCEDURE HAS FAILED' || SQLCODE||'-'||SQLERRM);
303: retcode := 1;
304: errbuf := SQLERRM;
305: RAISE FND_API.G_EXC_ERROR;
306: --RETURN ;
307: END REFRESH_MAT_VIEWS;
308:
309: PROCEDURE COMPUTE_STATISTICS(

Line 419: RAISE FND_API.G_EXC_ERROR;

415: retcode := 1;
416: errbuf := SQLERRM;
417: put_stream(g_output, 'COMPUTE_STATISTICS PROCEDURE HAS FAILED' ||SQLCODE||'-'|| SQLERRM);
418: put_stream(g_log, 'COMPUTE_STATISTICS PROCEDURE HAS FAILED' || SQLCODE||'-'||SQLERRM);
419: RAISE FND_API.G_EXC_ERROR;
420:
421: END COMPUTE_STATISTICS;
422:
423: PROCEDURE CHECK_TABLE_ROW_COUNT(

Line 499: RAISE FND_API.G_EXC_ERROR;

495: --dbms_output.put_line('NO MISMATCH IN TABLE ROW COUNT -- ALL THE TABLES HAVE BEEN LOADED PROPERLY ');
496: ELSE
497: put_stream(g_log, 'FOUND MISMATCH IN TABLE ROW COUNT');
498: put_stream(g_output, 'FOUND MISMATCH IN TABLE ROW COUNT');
499: RAISE FND_API.G_EXC_ERROR;
500: END IF;
501:
502: put_stream(g_log, 'The procedure CHECK_TABLE_ROW_COUNT has completed successfully');
503: --dbms_output.put_line('The procedure CHECK_TABLE_ROW_COUNT has completed successfully');

Line 512: RAISE FND_API.G_EXC_ERROR;

508: retcode := 1;
509: errbuf := SQLERRM;
510: put_stream(g_log,'CHECK_TABLE_ROW_COUNT PROCEDURE HAS FAILED '|| SQLCODE||'-'||SQLERRM);
511: put_stream(g_output,'CHECK_TABLE_ROW_COUNT PROCEDURE HAS FAILED '|| SQLCODE||'-'||SQLERRM);
512: RAISE FND_API.G_EXC_ERROR;
513:
514: WHEN OTHERS
515: THEN
516: CLOSE csf_spatial_stat_m_cur;

Line 521: RAISE FND_API.G_EXC_ERROR;

517: retcode := 1;
518: errbuf := SQLERRM;
519: put_stream(g_log,'CHECK_TABLE_ROW_COUNT PROCEDURE HAS FAILED '||SQLCODE||'-'|| SQLERRM);
520: put_stream(g_output,'CHECK_TABLE_ROW_COUNT PROCEDURE HAS FAILED '||SQLCODE||'-'|| SQLERRM);
521: RAISE FND_API.G_EXC_ERROR;
522:
523: END CHECK_TABLE_ROW_COUNT;
524:
525: PROCEDURE VALIDATE_BLOB_SIZE(

Line 598: RAISE FND_API.G_EXC_ERROR;

594: --dbms_output.put_line(' NO MISMATCH FOR SEGMENT ');
595: ELSE
596: put_stream(g_log, 'FOUND MISMATCH FOR SEGMENT ');
597: put_stream(g_log, 'FOUND MISMATCH FOR SEGMENT ');
598: RAISE FND_API.G_EXC_ERROR;
599: END IF;
600:
601: IF flagNode = 0 THEN
602: put_stream(g_log, ' NO MISMATCH FOR NODE ');

Line 608: RAISE FND_API.G_EXC_ERROR;

604: --dbms_output.put_line(' NO MISMATCH FOR NODE ');
605: ELSE
606: put_stream(g_log, 'FOUND MISMATCH FOR NODE ');
607: put_stream(g_log, 'FOUND MISMATCH FOR NODE ');
608: RAISE FND_API.G_EXC_ERROR;
609: END IF;
610:
611: CLOSE CSF_SPATIAL_STAT_LENGTH_CHECK;
612:

Line 624: RAISE FND_API.G_EXC_ERROR;

620: retcode := 1;
621: errbuf := SQLERRM;
622: put_stream(g_log,'VALIDATE_BLOB_SIZE PROCEDURE HAS FAILED '||SQLCODE||'-'|| SQLERRM);
623: put_stream(g_output,'VALIDATE_BLOB_SIZE PROCEDURE HAS FAILED '||SQLCODE||'-'|| SQLERRM);
624: RAISE FND_API.G_EXC_ERROR;
625:
626: WHEN OTHERS
627: THEN
628: CLOSE CSF_SPATIAL_STAT_LENGTH_CHECK;

Line 634: RAISE FND_API.G_EXC_ERROR;

630: retcode := 1;
631: errbuf := SQLERRM;
632: put_stream(g_log,'VALIDATE_BLOB_SIZE PROCEDURE HAS FAILED '||SQLCODE||'-'|| SQLERRM);
633: put_stream(g_output,'VALIDATE_BLOB_SIZE PROCEDURE HAS FAILED '||SQLCODE||'-'|| SQLERRM);
634: RAISE FND_API.G_EXC_ERROR;
635:
636: END VALIDATE_BLOB_SIZE;
637:
638: PROCEDURE CHECK_INDEX_VALIDITY(

Line 729: RAISE FND_API.G_EXC_ERROR;

725: CLOSE CSF_GET_SPATIAL_INDEXES;
726: retcode := 1;
727: errbuf := SQLERRM;
728: put_stream(g_log,'CHECK_INDEX_VALIDIDTY PROCEDURE HAS FAILED FOR ' || p_index_type || ' INDEXES' ||SQLCODE||'-'|| SQLERRM);
729: RAISE FND_API.G_EXC_ERROR;
730:
731: WHEN OTHERS
732: THEN
733: retcode := 1;

Line 738: RAISE FND_API.G_EXC_ERROR;

734: errbuf := SQLERRM;
735: put_stream(g_log,'CHECK_INDEX_VALIDIDTY PROCEDURE HAS FAILED '||SQLCODE||'-'|| SQLERRM);
736: CLOSE CSF_INDEX_STAT_VALIDITY_CHECK;
737: CLOSE CSF_GET_SPATIAL_INDEXES;
738: RAISE FND_API.G_EXC_ERROR;
739:
740: END CHECK_INDEX_VALIDITY;
741:
742: PROCEDURE RECREATE_INVALID_INDEXES(

Line 836: RAISE FND_API.G_EXC_ERROR;

832: retcode := 1;
833: errbuf := SQLERRM;
834: put_stream(g_log,'RECREATE_INVALID_INDEXES PROCEDURE HAS FAILED FOR ' || p_index_type || ' INDEXES' ||SQLCODE||'-'|| SQLERRM);
835: put_stream(g_output,'RECREATE_INVALID_INDEXES PROCEDURE HAS FAILED FOR ' || p_index_type || ' INDEXES' ||SQLCODE||'-'|| SQLERRM);
836: RAISE FND_API.G_EXC_ERROR;
837:
838: WHEN OTHERS
839: THEN
840: retcode := 1;

Line 846: RAISE FND_API.G_EXC_ERROR;

842: put_stream(g_log,'RECREATE_INVALID_INDEXES PROCEDURE HAS FAILED '||SQLCODE||'-'|| SQLERRM);
843: put_stream(g_output,'RECREATE_INVALID_INDEXES PROCEDURE HAS FAILED '||SQLCODE||'-'|| SQLERRM);
844: CLOSE CSF_INDEX_STAT_VALIDITY_CHECK;
845: CLOSE CSF_GET_SPATIAL_INDEXES;
846: RAISE FND_API.G_EXC_ERROR;
847:
848: END RECREATE_INVALID_INDEXES;
849:
850:

Line 955: RAISE FND_API.G_EXC_ERROR;

951: retcode := 1;
952: errbuf := SQLERRM;
953: put_stream(g_log,'CREATE_INDEX PROCEDURE HAS FAILED '||SQLCODE||'-'|| SQLERRM);
954: put_stream(g_output,'CREATE_INDEX PROCEDURE HAS FAILED '||SQLCODE||'-'|| SQLERRM);
955: RAISE FND_API.G_EXC_ERROR;
956:
957: WHEN OTHERS
958: THEN
959: retcode := 1;

Line 964: RAISE FND_API.G_EXC_ERROR;

960: errbuf := SQLERRM;
961: put_stream(g_log,'CREATE_INDEX PROCEDURE HAS FAILED '||SQLCODE||'-'|| SQLERRM);
962: put_stream(g_output,'CREATE_INDEX PROCEDURE HAS FAILED '||SQLCODE||'-'|| SQLERRM);
963: CLOSE CSF_GET_SPATIAL_INDEXES;
964: RAISE FND_API.G_EXC_ERROR;
965:
966: END CREATE_INDEXES;
967:
968: PROCEDURE RECREATE_INDEX (

Line 1060: RAISE FND_API.G_EXC_ERROR;

1056: retcode := 1;
1057: errbuf := SQLERRM;
1058: put_stream(g_output, 'RECREATE_INDEX PROCEDURE HAS FAILED' ||SQLCODE ||'-'|| SQLERRM);
1059: put_stream(g_log, 'RECREATE_INDEX PROCEDURE HAS FAILED' ||SQLCODE ||'-'|| SQLERRM);
1060: RAISE FND_API.G_EXC_ERROR;
1061:
1062: END RECREATE_INDEX;
1063:
1064: /* Procedure to drop route cache table. Fix for bug : 9019583

Line 1099: RAISE FND_API.G_EXC_ERROR;

1095: put_stream(g_output,'TRUNC_ROUTE_CAHCE_TABLE PROCEDURE HAS FAILED' ||SQLCODE||'-'|| SQLERRM );
1096: put_stream(g_log, 'TRUNC_ROUTE_CAHCE_TABLE PROCEDURE HAS FAILED' || SQLCODE||'-'||SQLERRM);
1097: retcode := 1;
1098: errbuf := SQLERRM;
1099: RAISE FND_API.G_EXC_ERROR;
1100: --RETURN ;
1101: END TRUNC_ROUTE_CAHCE_TABLE;
1102:
1103: END CSF_SPATIAL_DATALOAD_PVT;