APPS.IGS_TR_ITEM_NOTE_PKG dependencies on APP_EXCEPTION

Line 38: app_exception.raise_exception;

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

Line 92: app_exception.raise_exception ;

88: IF UPPER(column_name) = 'TRK_NOTE_TYPE' OR column_name IS NULL THEN
89: IF new_references.trk_note_type <> UPPER(new_references.trk_note_type) THEN
90: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
91: igs_ge_msg_stack.add;
92: app_exception.raise_exception ;
93: END IF;
94: END IF ;
95:
96: END check_constraints;

Line 108: app_exception.raise_exception;

104: ELSE
105: IF NOT igs_ge_note_pkg.get_pk_for_validation (new_references.reference_number) THEN
106: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
107: igs_ge_msg_stack.add;
108: app_exception.raise_exception;
109: END IF;
110: END IF;
111:
112: IF (((old_references.trk_note_type = new_references.trk_note_type)) OR

Line 119: app_exception.raise_exception;

115: ELSE
116: IF NOT igs_tr_note_type_pkg.get_pk_for_validation (new_references.trk_note_type) THEN
117: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
118: igs_ge_msg_stack.add;
119: app_exception.raise_exception;
120: END IF;
121: END IF;
122:
123: IF (((old_references.tracking_id = new_references.tracking_id)) OR

Line 130: app_exception.raise_exception;

126: ELSE
127: IF NOT igs_tr_item_pkg.get_pk_for_validation ( new_references.tracking_id ) THEN
128: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
129: igs_ge_msg_stack.add;
130: app_exception.raise_exception;
131: END IF;
132: END IF;
133:
134: END check_parent_existance;

Line 183: app_exception.raise_exception;

179: IF (cur_rowid%FOUND) THEN
180: CLOSE cur_rowid;
181: fnd_message.set_name ('IGS', 'IGS_TR_TIN_NOTE_FK');
182: igs_ge_msg_stack.add;
183: app_exception.raise_exception;
184: RETURN;
185: END IF;
186: CLOSE cur_rowid;
187:

Line 209: app_exception.raise_exception;

205: IF (cur_rowid%FOUND) THEN
206: CLOSE cur_rowid;
207: fnd_message.set_name ('IGS', 'IGS_TR_TIN_TNT_FK');
208: igs_ge_msg_stack.add;
209: app_exception.raise_exception;
210: RETURN;
211: END IF;
212: CLOSE cur_rowid;
213:

Line 235: app_exception.raise_exception;

231: IF (cur_rowid%FOUND) THEN
232: CLOSE cur_rowid;
233: fnd_message.set_name ('IGS', 'IGS_TR_TIN_TRI_FK');
234: igs_ge_msg_stack.add;
235: app_exception.raise_exception;
236: RETURN;
237: END IF;
238: CLOSE cur_rowid;
239:

Line 277: app_exception.raise_exception;

273: new_references.reference_number
274: ) THEN
275: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
276: igs_ge_msg_stack.add;
277: app_exception.raise_exception;
278: END IF;
279: check_constraints;
280: check_parent_existance;
281: ELSIF (p_action = 'UPDATE') THEN

Line 294: app_exception.raise_exception;

290: new_references.reference_number
291: ) THEN
292: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
293: igs_ge_msg_stack.add;
294: app_exception.raise_exception;
295: END IF;
296: check_constraints;
297: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
298: check_constraints;

Line 352: app_exception.raise_exception;

348: END IF;
349: ELSE
350: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
351: igs_ge_msg_stack.add;
352: app_exception.raise_exception;
353: END IF;
354:
355: before_dml(
356: p_action =>'INSERT',

Line 426: app_exception.raise_exception;

422: IF (c1%NOTFOUND) THEN
423: CLOSE c1;
424: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
425: igs_ge_msg_stack.add;
426: app_exception.raise_exception;
427: RETURN;
428: END IF;
429: CLOSE c1;
430:

Line 436: app_exception.raise_exception;

432: NULL;
433: ELSE
434: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
435: igs_ge_msg_stack.add;
436: app_exception.raise_exception;
437: END IF;
438: RETURN;
439:
440: END lock_row;

Line 473: app_exception.raise_exception;

469: END IF;
470: ELSE
471: fnd_message.set_name('FND', 'SYSTEM-INVALID ARGS');
472: igs_ge_msg_stack.add;
473: app_exception.raise_exception;
474: END IF;
475:
476: before_dml(
477: p_action =>'UPDATE',