DBA Data[Home] [Help]

APPS.IGS_AD_APTYP_PESTAT_PKG dependencies on APP_EXCEPTION

Line 48: app_exception.raise_exception;

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

Line 95: app_exception.raise_exception;

91: 'N'
92: ) THEN
93: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
94: igs_ge_msg_stack.add;
95: app_exception.raise_exception;
96: END IF;
97:
98: IF (((old_references.admission_application_type = new_references.admission_application_type)) OR
99: ((new_references.admission_application_type IS NULL))) THEN

Line 107: app_exception.raise_exception;

103: 'N'
104: ) THEN
105: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
106: igs_ge_msg_stack.add;
107: app_exception.raise_exception;
108: END IF;
109:
110: END check_parent_existance;
111:

Line 177: app_exception.raise_exception;

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

Line 212: app_exception.raise_exception;

208: IF (cur_rowid%FOUND) THEN
209: CLOSE cur_rowid;
210: fnd_message.set_name ('IGS', 'IGS_AD_TPS_AT_FK');
211: igs_ge_msg_stack.add;
212: app_exception.raise_exception;
213: RETURN;
214: END IF;
215: CLOSE cur_rowid;
216:

Line 268: app_exception.raise_exception;

264: )
265: ) THEN
266: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
267: igs_ge_msg_stack.add;
268: app_exception.raise_exception;
269: END IF;
270: check_parent_existance;
271: ELSIF (p_action = 'UPDATE') THEN
272: -- Call all the procedures related to Before Update.

Line 283: app_exception.raise_exception;

279: )
280: ) THEN
281: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
282: igs_ge_msg_stack.add;
283: app_exception.raise_exception;
284: END IF;
285: END IF;
286:
287: END before_dml;

Line 335: app_exception.raise_exception;

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

Line 419: app_exception.raise_exception;

415: IF (c1%notfound) THEN
416: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
417: igs_ge_msg_stack.add;
418: CLOSE c1;
419: app_exception.raise_exception;
420: RETURN;
421: END IF;
422: CLOSE c1;
423:

Line 432: app_exception.raise_exception;

428: NULL;
429: ELSE
430: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
431: igs_ge_msg_stack.add;
432: app_exception.raise_exception;
433: END IF;
434:
435: RETURN;
436:

Line 479: app_exception.raise_exception;

475: END IF;
476: ELSE
477: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
478: igs_ge_msg_stack.add;
479: app_exception.raise_exception;
480: END IF;
481:
482: before_dml(
483: p_action => 'UPDATE',