37: ELSIF bmode = 'DR' THEN
38: -- logic to drop or create is taken in the individual api.
39: NULL;
40: ELSE
41: FND_FILE.PUT_LINE(FND_FILE.LOG,
42: fnd_message.get_string('ibc', 'IBC_SYNC_INDEX_INV_MODE'));
43: RAISE invalid_mode_error; -- let the exception populate back to the caller.
44: END IF;
45:
226: errbuf := fnd_message.get_string('IBC',
227: 'IBC_SYNC_INDEX_INV_MODE');
228: WHEN drop_index_error THEN
229: BEGIN
230: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);
231: EXCEPTION
232: WHEN others THEN
233: NULL;
234: END;
233: NULL;
234: END;
235: WHEN create_index_error THEN
236: BEGIN
237: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);
238: EXCEPTION
239: WHEN others THEN
240: NULL;
241: END;
242: WHEN others THEN
243: errbuf := 'Sync_Text_Index: '||
244: fnd_message.GET_STRING('IBC','IBC_UNEXPECTED_ERROR')||' '|| SQLERRM;
245: BEGIN
246: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);
247: EXCEPTION
248: WHEN others THEN
249: NULL;
250: END;