DBA Data[Home] [Help]

APPS.IGS_FI_SUB_ER_RT_PKG dependencies on APP_EXCEPTION

Line 49: app_exception.raise_exception;

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

Line 96: app_exception.raise_exception;

92: )
93: ) THEN
94: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
95: igs_ge_msg_stack.add;
96: app_exception.raise_exception;
97: END IF;
98:
99: END check_uniqueness;
100:

Line 122: app_exception.raise_exception;

118: new_references.sub_er_id
119: ) THEN
120: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
121: igs_ge_msg_stack.add;
122: app_exception.raise_exception;
123: END IF;
124:
125: IF (((old_references.far_id = new_references.far_id)) OR
126: ((new_references.far_id IS NULL))) THEN

Line 133: app_exception.raise_exception;

129: new_references.far_id
130: ) THEN
131: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
132: igs_ge_msg_stack.add;
133: app_exception.raise_exception;
134: END IF;
135:
136: END check_parent_existance;
137:

Line 239: app_exception.raise_exception;

235: IF (cur_rowid%FOUND) THEN
236: CLOSE cur_rowid;
237: fnd_message.set_name ('IGS', 'IGS_FI_FSERT_FAR_FK');
238: igs_ge_msg_stack.add;
239: app_exception.raise_exception;
240: RETURN;
241: END IF;
242: CLOSE cur_rowid;
243:

Line 296: app_exception.raise_exception;

292: )
293: ) THEN
294: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
295: igs_ge_msg_stack.add;
296: app_exception.raise_exception;
297: END IF;
298: check_uniqueness;
299: check_parent_existance;
300: ELSIF (p_action = 'UPDATE') THEN

Line 312: app_exception.raise_exception;

308: )
309: ) THEN
310: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
311: igs_ge_msg_stack.add;
312: app_exception.raise_exception;
313: END IF;
314: check_uniqueness;
315: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
316: check_uniqueness;

Line 364: app_exception.raise_exception;

360: ELSE
361: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
362: fnd_message.set_token ('ROUTINE', 'IGS_FI_SUB_ER_RT_PKG.INSERT_ROW');
363: igs_ge_msg_stack.add;
364: app_exception.raise_exception;
365: END IF;
366:
367: x_sub_err_id := NULL;
368:

Line 448: app_exception.raise_exception;

444: IF (c1%notfound) THEN
445: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
446: igs_ge_msg_stack.add;
447: CLOSE c1;
448: app_exception.raise_exception;
449: RETURN;
450: END IF;
451: CLOSE c1;
452:

Line 463: app_exception.raise_exception;

459: NULL;
460: ELSE
461: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
462: igs_ge_msg_stack.add;
463: app_exception.raise_exception;
464: END IF;
465:
466: RETURN;
467:

Line 512: app_exception.raise_exception;

508: ELSE
509: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
510: fnd_message.set_token ('ROUTINE', 'IGS_FI_SUB_ER_RT_PKG.UPDATE_ROW');
511: igs_ge_msg_stack.add;
512: app_exception.raise_exception;
513: END IF;
514:
515: before_dml(
516: p_action => 'UPDATE',