APPS.IGS_AS_INC_GRD_CPROF_PKG dependencies on APP_EXCEPTION

Line 55: app_exception.raise_exception;

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

Line 109: app_exception.raise_exception;

105: )
106: ) THEN
107: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
108: igs_ge_msg_stack.add;
109: app_exception.raise_exception;
110: END IF;
111:
112: END check_uniqueness;
113:

Line 141: app_exception.raise_exception;

137: new_references.default_grade
138: ) THEN
139: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
140: igs_ge_msg_stack.add;
141: app_exception.raise_exception;
142: END IF;
143:
144: IF (((old_references.grading_schema_cd = new_references.grading_schema_cd) AND
145: (old_references.version_number = new_references.version_number) AND

Line 158: app_exception.raise_exception;

154: new_references.incomplete_grade
155: ) THEN
156: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
157: igs_ge_msg_stack.add;
158: app_exception.raise_exception;
159: END IF;
160:
161: IF (((old_references.comp_after_dt_alias = new_references.comp_after_dt_alias)) OR
162: ((new_references.comp_after_dt_alias IS NULL))) THEN

Line 169: app_exception.raise_exception;

165: new_references.comp_after_dt_alias
166: ) THEN
167: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
168: igs_ge_msg_stack.add;
169: app_exception.raise_exception;
170: END IF;
171:
172: IF (((old_references.grading_schema_cd = new_references.grading_schema_cd) AND
173: (old_references.version_number = new_references.version_number)) OR

Line 183: app_exception.raise_exception;

179: new_references.version_number
180: ) THEN
181: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
182: igs_ge_msg_stack.add;
183: app_exception.raise_exception;
184: END IF;
185:
186: END check_parent_existance;
187:

Line 299: app_exception.raise_exception;

295: IF (cur_rowid%FOUND) THEN
296: CLOSE cur_rowid;
297: fnd_message.set_name ('IGS', 'IGS_AS_IGCP_CSG_FK');
298: igs_ge_msg_stack.add;
299: app_exception.raise_exception;
300: RETURN;
301: END IF;
302: CLOSE cur_rowid;
303:

Line 334: app_exception.raise_exception;

330: IF (cur_rowid%FOUND) THEN
331: CLOSE cur_rowid;
332: fnd_message.set_name ('IGS', 'IGS_AS_IGCP_DA_FK');
333: igs_ge_msg_stack.add;
334: app_exception.raise_exception;
335: RETURN;
336: END IF;
337: CLOSE cur_rowid;
338:

Line 371: app_exception.raise_exception;

367: IF (cur_rowid%FOUND) THEN
368: CLOSE cur_rowid;
369: fnd_message.set_name ('IGS', 'IGS_AS_IGCP_GS_FK');
370: igs_ge_msg_stack.add;
371: app_exception.raise_exception;
372: RETURN;
373: END IF;
374: CLOSE cur_rowid;
375:

Line 440: app_exception.raise_exception;

436: )
437: ) THEN
438: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
439: igs_ge_msg_stack.add;
440: app_exception.raise_exception;
441: END IF;
442: check_uniqueness;
443: check_parent_existance;
444: ELSIF (p_action = 'UPDATE') THEN

Line 456: app_exception.raise_exception;

452: )
453: ) THEN
454: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
455: igs_ge_msg_stack.add;
456: app_exception.raise_exception;
457: END IF;
458: check_uniqueness;
459: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
460: check_uniqueness;

Line 517: app_exception.raise_exception;

513: END IF;
514: ELSE
515: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
516: igs_ge_msg_stack.add;
517: app_exception.raise_exception;
518: END IF;
519:
520: SELECT igs_as_inc_grd_cprof_s.NEXTVAL
521: INTO x_inc_grd_cprof_id

Line 641: app_exception.raise_exception;

637: IF (c1%notfound) THEN
638: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
639: igs_ge_msg_stack.add;
640: CLOSE c1;
641: app_exception.raise_exception;
642: RETURN;
643: END IF;
644: CLOSE c1;
645:

Line 662: app_exception.raise_exception;

658: NULL;
659: ELSE
660: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
661: igs_ge_msg_stack.add;
662: app_exception.raise_exception;
663: END IF;
664:
665: RETURN;
666:

Line 716: app_exception.raise_exception;

712: END IF;
713: ELSE
714: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
715: igs_ge_msg_stack.add;
716: app_exception.raise_exception;
717: END IF;
718:
719: before_dml(
720: p_action => 'UPDATE',