2273: END IF;
2274: IF c_suaai_an%ISOPEN THEN
2275: CLOSE c_suaai_an;
2276: END IF;
2277: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
2278: fnd_log.string (
2279: fnd_log.level_exception, 'igs_as_gen_004.assp_ins_suaai_dflt.exception_while_insert_update',
2280: 'SQLERRM:' || SQLERRM
2281: );
2274: IF c_suaai_an%ISOPEN THEN
2275: CLOSE c_suaai_an;
2276: END IF;
2277: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
2278: fnd_log.string (
2279: fnd_log.level_exception, 'igs_as_gen_004.assp_ins_suaai_dflt.exception_while_insert_update',
2280: 'SQLERRM:' || SQLERRM
2281: );
2282: END IF;
2275: CLOSE c_suaai_an;
2276: END IF;
2277: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
2278: fnd_log.string (
2279: fnd_log.level_exception, 'igs_as_gen_004.assp_ins_suaai_dflt.exception_while_insert_update',
2280: 'SQLERRM:' || SQLERRM
2281: );
2282: END IF;
2283: RETURN FALSE;
2285:
2286: RETURN TRUE;
2287: EXCEPTION
2288: WHEN OTHERS THEN
2289: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
2290: fnd_log.string (
2291: fnd_log.level_exception, 'igs_as_gen_004.assp_ins_suaai_dflt.final_exception_while_insert_update',
2292: 'SQLERRM:' || SQLERRM
2293: );
2286: RETURN TRUE;
2287: EXCEPTION
2288: WHEN OTHERS THEN
2289: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
2290: fnd_log.string (
2291: fnd_log.level_exception, 'igs_as_gen_004.assp_ins_suaai_dflt.final_exception_while_insert_update',
2292: 'SQLERRM:' || SQLERRM
2293: );
2294: END IF;
2287: EXCEPTION
2288: WHEN OTHERS THEN
2289: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
2290: fnd_log.string (
2291: fnd_log.level_exception, 'igs_as_gen_004.assp_ins_suaai_dflt.final_exception_while_insert_update',
2292: 'SQLERRM:' || SQLERRM
2293: );
2294: END IF;
2295: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXP');