188:
189: EXCEPTION
190: WHEN fnd_api.g_exc_error
191: THEN
192: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);
193: WHEN fnd_api.g_exc_unexpected_error
194: THEN
195: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);
196: WHEN OTHERS
191: THEN
192: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);
193: WHEN fnd_api.g_exc_unexpected_error
194: THEN
195: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);
196: WHEN OTHERS
197: THEN
198: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);
199: END;
194: THEN
195: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);
196: WHEN OTHERS
197: THEN
198: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);
199: END;
200:
201: END LOOP;
202:
229:
230: EXCEPTION
231: WHEN fnd_api.g_exc_error
232: THEN
233: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);
234: WHEN fnd_api.g_exc_unexpected_error
235: THEN
236: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);
237: WHEN OTHERS
232: THEN
233: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);
234: WHEN fnd_api.g_exc_unexpected_error
235: THEN
236: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);
237: WHEN OTHERS
238: THEN
239: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);
240: END;
235: THEN
236: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);
237: WHEN OTHERS
238: THEN
239: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);
240: END;
241:
242: END LOOP;
243:
270:
271: EXCEPTION
272: WHEN fnd_api.g_exc_error
273: THEN
274: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);
275: WHEN fnd_api.g_exc_unexpected_error
276: THEN
277: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);
278: WHEN OTHERS
273: THEN
274: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);
275: WHEN fnd_api.g_exc_unexpected_error
276: THEN
277: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);
278: WHEN OTHERS
279: THEN
280: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);
281: END;
276: THEN
277: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);
278: WHEN OTHERS
279: THEN
280: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);
281: END;
282:
283: END LOOP;
284:
286:
287: EXCEPTION
288: WHEN fnd_api.g_exc_error
289: THEN
290: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
291: WHEN fnd_api.g_exc_unexpected_error
292: THEN
293: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
294: WHEN OTHERS
289: THEN
290: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
291: WHEN fnd_api.g_exc_unexpected_error
292: THEN
293: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
294: WHEN OTHERS
295: THEN
296: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
297:
292: THEN
293: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
294: WHEN OTHERS
295: THEN
296: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
297:
298:
299: END DELETE_NO_ACCESS_CONTACTS;
300: