APPS.IGS_TR_NOTE_TYPE_PKG dependencies on APP_EXCEPTION

Line 37: app_exception.raise_exception;

33: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
34: CLOSE cur_old_ref_values;
35: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
36: igs_ge_msg_stack.add;
37: app_exception.raise_exception;
38: RETURN;
39: END IF;
40: CLOSE cur_old_ref_values;
41:

Line 74: app_exception.raise_exception ;

70: IF UPPER(column_name) = 'TRK_NOTE_TYPE' OR column_name IS NULL THEN
71: IF new_references.trk_note_type<> UPPER(new_references.trk_note_type) THEN
72: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
73: igs_ge_msg_stack.add;
74: app_exception.raise_exception ;
75: END IF;
76: END IF ;
77:
78: END check_constraints;

Line 158: app_exception.raise_exception;

154: new_references.trk_note_type
155: ) THEN
156: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
157: igs_ge_msg_stack.add;
158: app_exception.raise_exception;
159: END IF;
160: check_constraints;
161:
162: ELSIF (p_action = 'UPDATE') THEN

Line 172: app_exception.raise_exception;

168: ELSIF (p_action = 'VALIDATE_INSERT') THEN
169: IF get_pk_for_validation ( new_references.trk_note_type) THEN
170: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
171: igs_ge_msg_stack.add;
172: app_exception.raise_exception;
173: END IF;
174: check_constraints;
175:
176: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 231: app_exception.raise_exception;

227:
228: ELSE
229: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
230: igs_ge_msg_stack.add;
231: app_exception.raise_exception;
232: END IF;
233:
234: before_dml(p_action =>'INSERT',
235: x_rowid =>x_rowid,

Line 300: app_exception.raise_exception;

296: IF (c1%NOTFOUND) THEN
297: CLOSE c1;
298: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
299: igs_ge_msg_stack.add;
300: app_exception.raise_exception;
301: RETURN;
302: END IF;
303: CLOSE c1;
304:

Line 310: app_exception.raise_exception;

306: NULL;
307: ELSE
308: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
309: igs_ge_msg_stack.add;
310: app_exception.raise_exception;
311: END IF;
312: RETURN;
313:
314: END lock_row;

Line 348: app_exception.raise_exception;

344:
345: ELSE
346: fnd_message.set_name('FND', 'SYSTEM-INVALID ARGS');
347: igs_ge_msg_stack.add;
348: app_exception.raise_exception;
349: END IF;
350:
351: before_dml(p_action =>'UPDATE',
352: x_rowid =>x_rowid,