29: p_message_name := NULL;
30: RETURN TRUE;
31: EXCEPTION
32: WHEN OTHERS THEN
33: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXCEPTION');
34: Fnd_Message.Set_Token('NAME','IGS_PS_VAL_CAO.crsp_val_cao_exists');
35: IGS_GE_MSG_STACK.ADD;
36: App_Exception.Raise_Exception;
37: END crsp_val_cao_exists;
30: RETURN TRUE;
31: EXCEPTION
32: WHEN OTHERS THEN
33: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXCEPTION');
34: Fnd_Message.Set_Token('NAME','IGS_PS_VAL_CAO.crsp_val_cao_exists');
35: IGS_GE_MSG_STACK.ADD;
36: App_Exception.Raise_Exception;
37: END crsp_val_cao_exists;
38: --
112: END IF;
113: WHEN OTHERS THEN
114: IF gc_percent%ISOPEN THEN
115: CLOSE gc_percent;
116: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXCEPTION');
117: Fnd_Message.Set_Token('NAME','IGS_PS_VAL_CAO.crsp_val_cao_perc');
118: IGS_GE_MSG_STACK.ADD;
119: App_Exception.Raise_Exception;
120: END IF;
113: WHEN OTHERS THEN
114: IF gc_percent%ISOPEN THEN
115: CLOSE gc_percent;
116: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXCEPTION');
117: Fnd_Message.Set_Token('NAME','IGS_PS_VAL_CAO.crsp_val_cao_perc');
118: IGS_GE_MSG_STACK.ADD;
119: App_Exception.Raise_Exception;
120: END IF;
121: END crsp_val_cao_perc;