APPS.IGS_TR_STEP_NOTE_PKG dependencies on APP_EXCEPTION

Line 39: app_exception.raise_exception;

35:
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 78: app_exception.raise_exception;

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

Line 92: app_exception.raise_exception;

88: new_references.trk_note_type
89: )THEN
90: fnd_message.set_name('FND','FORM_RECORD_DELETED');
91: igs_ge_msg_stack.add;
92: app_exception.raise_exception;
93: END IF;
94: END IF;
95:
96: IF (((old_references.tracking_id = new_references.tracking_id) AND

Line 108: app_exception.raise_exception;

104: new_references.tracking_step_id
105: )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: END check_parent_existance;

Line 164: app_exception.raise_exception;

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

Line 191: app_exception.raise_exception;

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

Line 219: app_exception.raise_exception;

215: IF (cur_rowid%FOUND) THEN
216: CLOSE cur_rowid;
217: fnd_message.set_name ('IGS', 'IGS_TR_TSN_TRST_FK');
218: igs_ge_msg_stack.add;
219: app_exception.raise_exception;
220: RETURN;
221: END IF;
222: CLOSE cur_rowid;
223:

Line 243: app_exception.raise_exception;

239: IF UPPER(column_name) = 'TRK_NOTE_TYPE' OR column_name IS NULL THEN
240: IF new_references.trk_note_type <> UPPER(new_references.trk_note_type) THEN
241: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
242: igs_ge_msg_stack.add;
243: app_exception.raise_exception;
244: END IF;
245: END IF;
246:
247: END check_constraints;

Line 289: app_exception.raise_exception;

285: new_references.reference_number
286: )THEN
287: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
288: igs_ge_msg_stack.add;
289: app_exception.raise_exception;
290: END IF;
291: check_constraints;
292: check_parent_existance;
293:

Line 313: app_exception.raise_exception;

309: new_references.reference_number
310: )THEN
311: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
312: igs_ge_msg_stack.add;
313: app_exception.raise_exception;
314: END IF;
315: check_constraints;
316:
317: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 379: app_exception.raise_exception;

375: END IF;
376: ELSE
377: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
378: igs_ge_msg_stack.add;
379: app_exception.raise_exception;
380: END IF;
381:
382: before_dml(p_action =>'INSERT',
383: x_rowid =>x_rowid,

Line 455: app_exception.raise_exception;

451: FETCH c1 INTO tlinfo;
452: IF (c1%NOTFOUND) THEN
453: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
454: igs_ge_msg_stack.add;
455: app_exception.raise_exception;
456: CLOSE c1;
457: RETURN;
458: END IF;
459: CLOSE c1;

Line 466: app_exception.raise_exception;

462: NULL;
463: ELSE
464: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
465: igs_ge_msg_stack.add;
466: app_exception.raise_exception;
467: END IF;
468: RETURN;
469:
470: END lock_row;

Line 504: app_exception.raise_exception;

500:
501: ELSE
502: fnd_message.set_name('FND', 'SYSTEM-INVALID ARGS');
503: igs_ge_msg_stack.add;
504: app_exception.raise_exception;
505: END IF;
506:
507: before_dml(p_action =>'UPDATE',
508: x_rowid =>x_rowid,