APPS.IGS_TR_TYP_STEP_NOTE_PKG dependencies on APP_EXCEPTION

Line 39: app_exception.raise_exception;

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

Line 76: app_exception.raise_exception;

72: new_references.reference_number
73: )THEN
74: fnd_message.set_name('FND','FORM_RECORD_DELETED');
75: igs_ge_msg_stack.add;
76: app_exception.raise_exception;
77: END IF;
78: END IF;
79:
80: IF (((old_references.trk_note_type = new_references.trk_note_type)) OR

Line 89: app_exception.raise_exception;

85: new_references.trk_note_type
86: )THEN
87: fnd_message.set_name('FND','FORM_RECORD_DELETED');
88: igs_ge_msg_stack.add;
89: app_exception.raise_exception;
90: END IF;
91: END IF;
92:
93: IF (((old_references.tracking_type = new_references.tracking_type) AND

Line 105: app_exception.raise_exception;

101: new_references.tracking_type_step_id
102: )THEN
103: fnd_message.set_name('FND','FORM_RECORD_DELETED');
104: igs_ge_msg_stack.add;
105: app_exception.raise_exception;
106: END IF;
107: END IF;
108:
109: END check_parent_existance;

Line 165: app_exception.raise_exception;

161: IF (cur_rowid%FOUND) THEN
162: CLOSE cur_rowid;
163: fnd_message.set_name ('IGS', 'IGS_TR_TTSN_NOTE_FK');
164: igs_ge_msg_stack.add;
165: app_exception.raise_exception;
166: RETURN;
167: END IF;
168: CLOSE cur_rowid;
169:

Line 191: app_exception.raise_exception;

187: IF (cur_rowid%FOUND) THEN
188: CLOSE cur_rowid;
189: fnd_message.set_name ('IGS', 'IGS_TR_TTSN_TNT_FK');
190: igs_ge_msg_stack.add;
191: app_exception.raise_exception;
192: RETURN;
193: END IF;
194: CLOSE cur_rowid;
195:

Line 223: app_exception.raise_exception;

219: IF (cur_rowid%FOUND) THEN
220: CLOSE cur_rowid;
221: fnd_message.set_name ('IGS', 'IGS_TR_TTSN_TTS_FK');
222: igs_ge_msg_stack.add;
223: app_exception.raise_exception;
224: RETURN;
225: END IF;
226: CLOSE cur_rowid;
227:

Line 248: app_exception.raise_exception;

244: IF UPPER(column_name) = 'TRACKING_TYPE' OR column_name IS NULL THEN
245: IF new_references.tracking_type <> UPPER(new_references.tracking_type) THEN
246: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
247: igs_ge_msg_stack.add;
248: app_exception.raise_exception;
249: END IF;
250: END IF;
251:
252: IF UPPER(column_name) = 'TRK_NOTE_TYPE' OR column_name IS NULL THEN

Line 256: app_exception.raise_exception;

252: IF UPPER(column_name) = 'TRK_NOTE_TYPE' OR column_name IS NULL THEN
253: IF new_references.trk_note_type <> UPPER(new_references.trk_note_type) THEN
254: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
255: igs_ge_msg_stack.add;
256: app_exception.raise_exception;
257: END IF;
258: END IF;
259:
260: END check_constraints;

Line 306: app_exception.raise_exception;

302: new_references.org_id
303: )THEN
304: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
305: igs_ge_msg_stack.add;
306: app_exception.raise_exception;
307: END IF;
308:
309: check_constraints;
310: check_parent_existance;

Line 331: app_exception.raise_exception;

327: new_references.org_id
328: )THEN
329: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
330: igs_ge_msg_stack.add;
331: app_exception.raise_exception;
332: END IF;
333: check_constraints;
334: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
335: -- Call all the procedures related to Before Delete.

Line 393: app_exception.raise_exception;

389: END IF;
390: ELSE
391: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
392: igs_ge_msg_stack.add;
393: app_exception.raise_exception;
394: END IF;
395:
396: before_dml(p_action =>'INSERT',
397: x_rowid =>x_rowid,

Line 471: app_exception.raise_exception;

467: FETCH c1 INTO tlinfo;
468: IF (c1%NOTFOUND) THEN
469: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
470: igs_ge_msg_stack.add;
471: app_exception.raise_exception;
472: CLOSE c1;
473: RETURN;
474: END IF;
475: CLOSE c1;

Line 482: app_exception.raise_exception;

478: NULL;
479: ELSE
480: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
481: igs_ge_msg_stack.add;
482: app_exception.raise_exception;
483: END IF;
484: RETURN;
485:
486: END lock_row;

Line 522: app_exception.raise_exception;

518:
519: ELSE
520: fnd_message.set_name('FND', 'SYSTEM-INVALID ARGS');
521: igs_ge_msg_stack.add;
522: app_exception.raise_exception;
523: END IF;
524:
525: before_dml(p_action =>'UPDATE',
526: x_rowid =>x_rowid,