APPS.IGS_HE_USR_RT_CL_FLD_PKG dependencies on APP_EXCEPTION

Line 51: app_exception.raise_exception;

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

Line 96: app_exception.raise_exception;

92: BEGIN
93: IF get_uk_for_validation(new_references.user_return_subclass, new_references.field_number) 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: END check_uniqueness;
99:
100: /* added by rgopalan for checking uniqueness for unique keys end(2) */

Line 123: app_exception.raise_exception;

119: new_references.user_return_subclass
120: ) THEN
121: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
122: igs_ge_msg_stack.add;
123: app_exception.raise_exception;
124: END IF;
125:
126: END check_parent_existance;
127:

Line 233: app_exception.raise_exception;

229: IF (cur_rowid%FOUND) THEN
230: CLOSE cur_rowid;
231: fnd_message.set_name ('IGS', 'IGS_HE_HEURCFD_HEURCD_FK');
232: igs_ge_msg_stack.add;
233: app_exception.raise_exception;
234: RETURN;
235: END IF;
236: CLOSE cur_rowid;
237:

Line 295: app_exception.raise_exception;

291: )
292: ) THEN
293: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
294: igs_ge_msg_stack.add;
295: app_exception.raise_exception;
296: END IF;
297: check_uniqueness;
298: check_parent_existance;
299: 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 369: app_exception.raise_exception;

365: END IF;
366: ELSE
367: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
368: igs_ge_msg_stack.add;
369: app_exception.raise_exception;
370: END IF;
371:
372: SELECT igs_he_usr_rt_cl_fld_s.NEXTVAL
373: INTO x_usr_rt_cl_fld_id

Line 472: app_exception.raise_exception;

468: IF (c1%notfound) THEN
469: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
470: igs_ge_msg_stack.add;
471: CLOSE c1;
472: app_exception.raise_exception;
473: RETURN;
474: END IF;
475: CLOSE c1;
476:

Line 488: app_exception.raise_exception;

484: NULL;
485: ELSE
486: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
487: igs_ge_msg_stack.add;
488: app_exception.raise_exception;
489: END IF;
490:
491: RETURN;
492:

Line 538: app_exception.raise_exception;

534: END IF;
535: ELSE
536: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
537: igs_ge_msg_stack.add;
538: app_exception.raise_exception;
539: END IF;
540:
541: before_dml(
542: p_action => 'UPDATE',