DBA Data[Home] [Help]

APPS.IGS_AD_SS_LOOKUPS_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 94: app_exception.raise_exception;

90: new_references.admission_application_type
91: ) THEN
92: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
93: igs_ge_msg_stack.add;
94: app_exception.raise_exception;
95: END IF;
96:
97: END check_parent_existance;
98:

Line 166: app_exception.raise_exception;

162: IF (cur_rowid%FOUND) THEN
163: CLOSE cur_rowid;
164: fnd_message.set_name ('IGS', 'IGS_FOREIGN_KEY_REFERENCE');
165: igs_ge_msg_stack.add;
166: app_exception.raise_exception;
167: RETURN;
168: END IF;
169: CLOSE cur_rowid;
170:

Line 223: app_exception.raise_exception;

219: )
220: ) THEN
221: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
222: igs_ge_msg_stack.add;
223: app_exception.raise_exception;
224: END IF;
225: check_parent_existance;
226: ELSIF (p_action = 'UPDATE') THEN
227: -- Call all the procedures related to Before Update.

Line 239: app_exception.raise_exception;

235: )
236: ) THEN
237: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
238: igs_ge_msg_stack.add;
239: app_exception.raise_exception;
240: END IF;
241: END IF;
242:
243: END before_dml;

Line 287: app_exception.raise_exception;

283: ELSE
284: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
285: fnd_message.set_token ('ROUTINE', 'IGS_AD_SS_LOOKUPS_PKG.INSERT_ROW');
286: igs_ge_msg_stack.add;
287: app_exception.raise_exception;
288: END IF;
289:
290: before_dml(
291: p_action => 'INSERT',

Line 366: app_exception.raise_exception;

362: IF (c1%notfound) THEN
363: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
364: igs_ge_msg_stack.add;
365: CLOSE c1;
366: app_exception.raise_exception;
367: RETURN;
368: END IF;
369: CLOSE c1;
370:

Line 378: app_exception.raise_exception;

374: NULL;
375: ELSE
376: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
377: igs_ge_msg_stack.add;
378: app_exception.raise_exception;
379: END IF;
380:
381: RETURN;
382:

Line 426: app_exception.raise_exception;

422: ELSE
423: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
424: fnd_message.set_token ('ROUTINE', 'IGS_AD_SS_LOOKUPS_PKG.UPDATE_ROW');
425: igs_ge_msg_stack.add;
426: app_exception.raise_exception;
427: END IF;
428:
429: before_dml(
430: p_action => 'UPDATE',