APPS.IGF_AP_HOUSING_MAP_PKG dependencies on APP_EXCEPTION

Line 48: app_exception.raise_exception;

44: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
45: CLOSE cur_old_ref_values;
46: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
47: igs_ge_msg_stack.add;
48: app_exception.raise_exception;
49: RETURN;
50: END IF;
51: CLOSE cur_old_ref_values;
52:

Line 118: app_exception.raise_exception;

114: -- Call all the procedures related to Before Insert.
115: IF ( get_pk_for_validation(x_ci_cal_type, x_ci_sequence_number, x_housing_stat_code))THEN
116: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
117: igs_ge_msg_stack.add;
118: app_exception.raise_exception;
119: END IF;
120: ELSIF (p_action = 'VALIDATE_INSERT') THEN
121: -- Call all the procedures related to Before Insert.
122: IF ( get_pk_for_validation(x_ci_cal_type, x_ci_sequence_number, x_housing_stat_code))THEN

Line 125: app_exception.raise_exception;

121: -- Call all the procedures related to Before Insert.
122: IF ( get_pk_for_validation(x_ci_cal_type, x_ci_sequence_number, x_housing_stat_code))THEN
123: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
124: igs_ge_msg_stack.add;
125: app_exception.raise_exception;
126: END IF;
127: END IF;
128:
129: END before_dml;

Line 173: app_exception.raise_exception;

169: ELSE
170: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
171: fnd_message.set_token ('ROUTINE', 'IGF_AP_HOUSING_MAP_PKG.INSERT_ROW');
172: igs_ge_msg_stack.add;
173: app_exception.raise_exception;
174: END IF;
175:
176: before_dml(
177: p_action => 'INSERT',

Line 251: app_exception.raise_exception;

247: IF (c1%notfound) THEN
248: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
249: igs_ge_msg_stack.add;
250: CLOSE c1;
251: app_exception.raise_exception;
252: RETURN;
253: END IF;
254: CLOSE c1;
255:

Line 266: app_exception.raise_exception;

262: NULL;
263: ELSE
264: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
265: igs_ge_msg_stack.add;
266: app_exception.raise_exception;
267: END IF;
268:
269: RETURN;
270:

Line 314: app_exception.raise_exception;

310: ELSE
311: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
312: fnd_message.set_token ('ROUTINE', 'IGF_AP_HOUSING_MAP_PKG.UPDATE_ROW');
313: igs_ge_msg_stack.add;
314: app_exception.raise_exception;
315: END IF;
316:
317: before_dml(
318: p_action => 'UPDATE',