191:
192: EXCEPTION
193: WHEN fnd_api.g_exc_error
194: THEN
195: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);
196: WHEN fnd_api.g_exc_unexpected_error
197: THEN
198: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);
199: WHEN OTHERS
194: THEN
195: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);
196: WHEN fnd_api.g_exc_unexpected_error
197: THEN
198: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);
199: WHEN OTHERS
200: THEN
201: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);
202: END;
197: THEN
198: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);
199: WHEN OTHERS
200: THEN
201: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);
202: END;
203:
204: END LOOP;
205:
234:
235: EXCEPTION
236: WHEN fnd_api.g_exc_error
237: THEN
238: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);
239: WHEN fnd_api.g_exc_unexpected_error
240: THEN
241: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);
242: WHEN OTHERS
237: THEN
238: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);
239: WHEN fnd_api.g_exc_unexpected_error
240: THEN
241: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);
242: WHEN OTHERS
243: THEN
244: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);
245: END;
240: THEN
241: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);
242: WHEN OTHERS
243: THEN
244: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);
245: END;
246:
247: END LOOP;
248:
275:
276: EXCEPTION
277: WHEN fnd_api.g_exc_error
278: THEN
279: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);
280: WHEN fnd_api.g_exc_unexpected_error
281: THEN
282: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);
283: WHEN OTHERS
278: THEN
279: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);
280: WHEN fnd_api.g_exc_unexpected_error
281: THEN
282: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);
283: WHEN OTHERS
284: THEN
285: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);
286: END;
281: THEN
282: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);
283: WHEN OTHERS
284: THEN
285: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);
286: END;
287:
288: END LOOP;
289:
292:
293: EXCEPTION
294: WHEN fnd_api.g_exc_error
295: THEN
296: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
297: WHEN fnd_api.g_exc_unexpected_error
298: THEN
299: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
300: WHEN OTHERS
295: THEN
296: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
297: WHEN fnd_api.g_exc_unexpected_error
298: THEN
299: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
300: WHEN OTHERS
301: THEN
302: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
303:
298: THEN
299: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
300: WHEN OTHERS
301: THEN
302: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
303:
304:
305: END DELETE_NO_ACCESS_CONTACTS;
306: