APPS.IGS_TR_GROUP_NOTE_PKG dependencies on APP_EXCEPTION

Line 39: app_exception.raise_exception;

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

Line 81: app_exception.raise_exception ;

77: IF UPPER(column_name) = 'TRK_NOTE_TYPE' OR column_name IS NULL THEN
78: IF new_references.trk_note_type<> UPPER(new_references.trk_note_type) THEN
79: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
80: igs_ge_msg_stack.add;
81: app_exception.raise_exception ;
82: END IF;
83: END IF ;
84:
85: END check_constraints;

Line 98: app_exception.raise_exception;

94: ELSE
95: IF NOT igs_ge_note_pkg.get_pk_for_validation ( new_references.reference_number ) THEN
96: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
97: igs_ge_msg_stack.add;
98: app_exception.raise_exception;
99: END IF;
100: END IF;
101:
102: IF (((old_references.tracking_group_id = new_references.tracking_group_id)) OR

Line 110: app_exception.raise_exception;

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

Line 121: app_exception.raise_exception;

117: ELSE
118: IF NOT igs_tr_note_type_pkg.get_pk_for_validation ( new_references.trk_note_type ) THEN
119: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
120: igs_ge_msg_stack.add;
121: app_exception.raise_exception;
122: END IF;
123: END IF;
124:
125: END check_parent_existance;

Line 176: app_exception.raise_exception;

172: IF (cur_rowid%FOUND) THEN
173: CLOSE cur_rowid;
174: fnd_message.set_name ('IGS', 'IGS_TR_TGN_NOTE_FK');
175: igs_ge_msg_stack.add;
176: app_exception.raise_exception;
177: RETURN;
178: END IF;
179: CLOSE cur_rowid;
180:

Line 202: app_exception.raise_exception;

198: IF (cur_rowid%FOUND) THEN
199: CLOSE cur_rowid;
200: fnd_message.set_name ('IGS', 'IGS_TR_TGN_TG_FK');
201: igs_ge_msg_stack.add;
202: app_exception.raise_exception;
203: RETURN;
204: END IF;
205: CLOSE cur_rowid;
206:

Line 228: app_exception.raise_exception;

224: IF (cur_rowid%FOUND) THEN
225: CLOSE cur_rowid;
226: fnd_message.set_name ('IGS', 'IGS_TR_TGN_TNT_FK');
227: igs_ge_msg_stack.add;
228: app_exception.raise_exception;
229: RETURN;
230: END IF;
231: CLOSE cur_rowid;
232:

Line 266: app_exception.raise_exception;

262: IF (p_action = 'INSERT') THEN
263: IF get_pk_for_validation ( new_references.tracking_group_id, new_references.reference_number) THEN
264: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
265: igs_ge_msg_stack.add;
266: app_exception.raise_exception;
267: END IF;
268: check_constraints;
269: check_parent_existance;
270:

Line 279: app_exception.raise_exception;

275: ELSIF (p_action = 'VALIDATE_INSERT') THEN
276: IF get_pk_for_validation ( new_references.tracking_group_id, new_references.reference_number) THEN
277: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
278: igs_ge_msg_stack.add;
279: app_exception.raise_exception;
280: END IF;
281: check_constraints;
282:
283: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 337: app_exception.raise_exception;

333: END IF;
334: ELSE
335: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
336: igs_ge_msg_stack.add;
337: app_exception.raise_exception;
338: END IF;
339:
340: before_dml(p_action =>'INSERT',
341: x_rowid =>x_rowid,

Line 410: app_exception.raise_exception;

406: IF (c1%NOTFOUND) THEN
407: CLOSE c1;
408: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
409: igs_ge_msg_stack.add;
410: app_exception.raise_exception;
411: RETURN;
412: END IF;
413: CLOSE c1;
414:

Line 420: app_exception.raise_exception;

416: NULL;
417: ELSE
418: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
419: igs_ge_msg_stack.add;
420: app_exception.raise_exception;
421: END IF;
422: RETURN;
423:
424: END lock_row;

Line 459: app_exception.raise_exception;

455:
456: ELSE
457: fnd_message.set_name('FND', 'SYSTEM-INVALID ARGS');
458: igs_ge_msg_stack.add;
459: app_exception.raise_exception;
460: END IF;
461: before_dml(p_action =>'UPDATE',
462: x_rowid =>x_rowid,
463: x_tracking_group_id => x_tracking_group_id,