APPS.IGS_PR_COHINST_RANK_PKG dependencies on APP_EXCEPTION

Line 53: app_exception.raise_exception;

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

Line 109: app_exception.raise_exception;

105: new_references.load_ci_sequence_number
106: ) THEN
107: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
108: igs_ge_msg_stack.add;
109: app_exception.raise_exception;
110: END IF;
111:
112: IF (((old_references.person_id = new_references.person_id) AND
113: (old_references.course_cd = new_references.course_cd)) OR

Line 123: app_exception.raise_exception;

119: new_references.course_cd
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 202: app_exception.raise_exception;

198: IF (cur_rowid%FOUND) THEN
199: CLOSE cur_rowid;
200: fnd_message.set_name ('IGS', 'IGS_PR_COHI_COHIR_FK');
201: igs_ge_msg_stack.add;
202: app_exception.raise_exception;
203: RETURN;
204: END IF;
205: CLOSE cur_rowid;
206:

Line 239: app_exception.raise_exception;

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

Line 308: app_exception.raise_exception;

304: )
305: ) THEN
306: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
307: igs_ge_msg_stack.add;
308: app_exception.raise_exception;
309: END IF;
310: check_parent_existance;
311: ELSIF (p_action = 'UPDATE') THEN
312: -- Call all the procedures related to Before Update.

Line 326: app_exception.raise_exception;

322: )
323: ) THEN
324: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
325: igs_ge_msg_stack.add;
326: app_exception.raise_exception;
327: END IF;
328: END IF;
329:
330: END before_dml;

Line 394: app_exception.raise_exception;

390: END IF;
391: ELSE
392: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
393: igs_ge_msg_stack.add;
394: app_exception.raise_exception;
395: END IF;
396:
397: before_dml(
398: p_action => 'INSERT',

Line 500: app_exception.raise_exception;

496: IF (c1%notfound) THEN
497: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
498: igs_ge_msg_stack.add;
499: CLOSE c1;
500: app_exception.raise_exception;
501: RETURN;
502: END IF;
503: CLOSE c1;
504:

Line 515: app_exception.raise_exception;

511: NULL;
512: ELSE
513: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
514: igs_ge_msg_stack.add;
515: app_exception.raise_exception;
516: END IF;
517:
518: RETURN;
519:

Line 571: app_exception.raise_exception;

567: END IF;
568: ELSE
569: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
570: igs_ge_msg_stack.add;
571: app_exception.raise_exception;
572: END IF;
573:
574: before_dml(
575: p_action => 'UPDATE',