APPS.IGS_OR_LOC_REGION_PKG dependencies on APP_EXCEPTION

Line 46: app_exception.raise_exception;

42: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
43: CLOSE cur_old_ref_values;
44: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
45: igs_ge_msg_stack.add;
46: app_exception.raise_exception;
47: RETURN;
48: END IF;
49: CLOSE cur_old_ref_values;
50:

Line 91: app_exception.raise_exception;

87: 'N'
88: ) THEN
89: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
90: igs_ge_msg_stack.add;
91: app_exception.raise_exception;
92: END IF;
93:
94: END check_parent_existance;
95:

Line 198: app_exception.raise_exception;

194: IF (cur_rowid%FOUND) THEN
195: CLOSE cur_rowid;
196: fnd_message.set_name ('IGS', 'IGS_FOREIGN_KEY_REFERENCE');
197: igs_ge_msg_stack.add;
198: app_exception.raise_exception;
199: RETURN;
200: END IF;
201: CLOSE cur_rowid;
202:

Line 249: app_exception.raise_exception;

245: )
246: ) THEN
247: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
248: igs_ge_msg_stack.add;
249: app_exception.raise_exception;
250: END IF;
251: check_parent_existance;
252: ELSIF (p_action = 'UPDATE') THEN
253: -- Call all the procedures related to Before Update.

Line 262: app_exception.raise_exception;

258: old_references.region_cd
259: )) THEN
260: fnd_message.set_name('IGS','IGS_OR_PREF_REGION_EXISTS');
261: igs_ge_msg_stack.add;
262: app_exception.raise_exception;
263: END IF;
264: ELSIF (p_action = 'VALIDATE_INSERT') THEN
265: -- Call all the procedures related to Before Insert.
266: IF ( get_pk_for_validation (

Line 273: app_exception.raise_exception;

269: )
270: ) THEN
271: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
272: igs_ge_msg_stack.add;
273: app_exception.raise_exception;
274: END IF;
275: END IF;
276:
277: END before_dml;

Line 319: app_exception.raise_exception;

315: ELSE
316: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
317: fnd_message.set_token ('ROUTINE', 'IGS_OR_LOC_REGION_PKG.INSERT_ROW');
318: igs_ge_msg_stack.add;
319: app_exception.raise_exception;
320: END IF;
321:
322: before_dml(
323: p_action => 'INSERT',

Line 386: app_exception.raise_exception;

382: IF (c1%notfound) THEN
383: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
384: igs_ge_msg_stack.add;
385: CLOSE c1;
386: app_exception.raise_exception;
387: RETURN;
388: END IF;
389: CLOSE c1;
390: