DBA Data[Home] [Help]

APPS.IGS_DA_CNFG_STAT_PKG dependencies on APP_EXCEPTION

Line 47: app_exception.raise_exception;

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

Line 92: app_exception.raise_exception;

88: new_references.request_type_id
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:
95: IF (((old_references.stat_type = new_references.stat_type)) OR
96: ((new_references.stat_type IS NULL))) THEN

Line 103: app_exception.raise_exception;

99: new_references.stat_type
100: ) THEN
101: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
102: igs_ge_msg_stack.add;
103: app_exception.raise_exception;
104: END IF;
105:
106: END check_parent_existance;
107:

Line 173: app_exception.raise_exception;

169: IF (cur_rowid%FOUND) THEN
170: CLOSE cur_rowid;
171: fnd_message.set_name ('IGS', 'IGS_DA_CNFG_STAT_FK');
172: igs_ge_msg_stack.add;
173: app_exception.raise_exception;
174: RETURN;
175: END IF;
176: CLOSE cur_rowid;
177:

Line 208: app_exception.raise_exception;

204: IF (cur_rowid%FOUND) THEN
205: CLOSE cur_rowid;
206: fnd_message.set_name ('IGS', 'IGS_DA_PSTAT_STAT_FK');
207: igs_ge_msg_stack.add;
208: app_exception.raise_exception;
209: RETURN;
210: END IF;
211: CLOSE cur_rowid;
212:

Line 262: app_exception.raise_exception;

258: )
259: ) THEN
260: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
261: igs_ge_msg_stack.add;
262: app_exception.raise_exception;
263: END IF;
264: check_parent_existance;
265: ELSIF (p_action = 'UPDATE') THEN
266: -- Call all the procedures related to Before Update.

Line 277: app_exception.raise_exception;

273: )
274: ) THEN
275: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
276: igs_ge_msg_stack.add;
277: app_exception.raise_exception;
278: END IF;
279: END IF;
280:
281: END before_dml;

Line 324: app_exception.raise_exception;

320: ELSE
321: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
322: fnd_message.set_token ('ROUTINE', 'IGS_DA_CNFG_STAT_PKG.INSERT_ROW');
323: igs_ge_msg_stack.add;
324: app_exception.raise_exception;
325: END IF;
326:
327: before_dml(
328: p_action => 'INSERT',

Line 395: app_exception.raise_exception;

391: IF (c1%notfound) THEN
392: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
393: igs_ge_msg_stack.add;
394: CLOSE c1;
395: app_exception.raise_exception;
396: RETURN;
397: END IF;
398: CLOSE c1;
399:

Line 407: app_exception.raise_exception;

403: NULL;
404: ELSE
405: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
406: igs_ge_msg_stack.add;
407: app_exception.raise_exception;
408: END IF;
409:
410: RETURN;
411:

Line 454: app_exception.raise_exception;

450: ELSE
451: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
452: fnd_message.set_token ('ROUTINE', 'IGS_DA_CNFG_STAT_PKG.UPDATE_ROW');
453: igs_ge_msg_stack.add;
454: app_exception.raise_exception;
455: END IF;
456:
457: before_dml(
458: p_action => 'UPDATE',