893: WHEN OTHERS THEN
894:
895: IF SQLCODE IN (-12000) THEN
896: /*Snapshot Log already EXISTS*/
897: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Snapshot Log on ' ||p_table||' already exists...');
898:
899: ELSIF SQLCODE IN (-00942) THEN
900: /*Base Table does not exist*/
901: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Table '||p_table||' does not exist...');
897: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Snapshot Log on ' ||p_table||' already exists...');
898:
899: ELSIF SQLCODE IN (-00942) THEN
900: /*Base Table does not exist*/
901: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Table '||p_table||' does not exist...');
902: ELSE
903: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM);
904: END IF;
905: END CREATE_SNAP_LOG; --create_snap Log
899: ELSIF SQLCODE IN (-00942) THEN
900: /*Base Table does not exist*/
901: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Table '||p_table||' does not exist...');
902: ELSE
903: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM);
904: END IF;
905: END CREATE_SNAP_LOG; --create_snap Log
906:
907:
933:
934:
935: EXCEPTION
936: WHEN OTHERS THEN
937: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM);
938: RAISE;
939: end create_csp_index;
940:
941: