APPS.IGS_PE_HOLD_REL_OVR_PKG dependencies on APP_EXCEPTION

Line 51: app_exception.raise_exception;

47: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
48: CLOSE cur_old_ref_values;
49: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
50: igs_ge_msg_stack.add;
51: app_exception.raise_exception;
52: RETURN;
53: END IF;
54: CLOSE cur_old_ref_values;
55:

Line 100: app_exception.raise_exception;

96: )
97: ) THEN
98: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
99: igs_ge_msg_stack.add;
100: app_exception.raise_exception;
101: END IF;
102:
103: END check_uniqueness;
104:

Line 126: app_exception.raise_exception;

122: new_references.elgb_override_id
123: ) THEN
124: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
125: igs_ge_msg_stack.add;
126: app_exception.raise_exception;
127: END IF;
128:
129: IF (((old_references.hold_type = new_references.hold_type)) OR
130: ((new_references.hold_type IS NULL))) THEN

Line 137: app_exception.raise_exception;

133: new_references.hold_type
134: ) THEN
135: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
136: igs_ge_msg_stack.add;
137: app_exception.raise_exception;
138: END IF;
139:
140: END check_parent_existance;
141:

Line 204: app_exception.raise_exception;

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

Line 279: app_exception.raise_exception;

275: IF (cur_rowid%FOUND) THEN
276: CLOSE cur_rowid;
277: fnd_message.set_name ('IGS', 'IGS_EN_HRO_EOA_FK');
278: igs_ge_msg_stack.add;
279: app_exception.raise_exception;
280: RETURN;
281: END IF;
282: CLOSE cur_rowid;
283:

Line 293: App_Exception.Raise_Exception;

289: IF ( p_inserting = TRUE OR (p_updating = TRUE AND new_references.hold_type <> old_references.hold_type) ) THEN
290: IF NOT igs_en_val_etde.enrp_val_et_closed(new_references.hold_type,p_message_name) THEN
291: Fnd_Message.Set_Name('IGS', p_message_name);
292: IGS_GE_MSG_STACK.ADD;
293: App_Exception.Raise_Exception;
294: END IF;
295: END IF;
296: END BeforeInsertUpdate;
297:

Line 352: app_exception.raise_exception;

348: )
349: ) THEN
350: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
351: igs_ge_msg_stack.add;
352: app_exception.raise_exception;
353: END IF;
354: check_uniqueness;
355: check_parent_existance;
356: ELSIF (p_action = 'UPDATE') THEN

Line 370: app_exception.raise_exception;

366: )
367: ) THEN
368: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
369: igs_ge_msg_stack.add;
370: app_exception.raise_exception;
371: END IF;
372: check_uniqueness;
373: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
374: check_uniqueness;

Line 427: app_exception.raise_exception;

423: END IF;
424: ELSE
425: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
426: igs_ge_msg_stack.add;
427: app_exception.raise_exception;
428: END IF;
429:
430: SELECT igs_pe_hold_rel_ovr_s.NEXTVAL
431: INTO x_hold_rel_ovr_id

Line 531: app_exception.raise_exception;

527: IF (c1%notfound) THEN
528: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
529: igs_ge_msg_stack.add;
530: CLOSE c1;
531: app_exception.raise_exception;
532: RETURN;
533: END IF;
534: CLOSE c1;
535:

Line 548: app_exception.raise_exception;

544: NULL;
545: ELSE
546: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
547: igs_ge_msg_stack.add;
548: app_exception.raise_exception;
549: END IF;
550:
551: RETURN;
552:

Line 598: app_exception.raise_exception;

594: END IF;
595: ELSE
596: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
597: igs_ge_msg_stack.add;
598: app_exception.raise_exception;
599: END IF;
600:
601: before_dml(
602: p_action => 'UPDATE',