APPS.IGF_SL_CL_SETUP_PKG dependencies on APP_EXCEPTION

Line 77: app_exception.raise_exception;

73: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
74: CLOSE cur_old_ref_values;
75: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
76: igs_ge_msg_stack.add;
77: app_exception.raise_exception;
78: RETURN;
79: END IF;
80: CLOSE cur_old_ref_values;
81:

Line 144: app_exception.raise_exception;

140: )
141: ) THEN
142: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
143: igs_ge_msg_stack.add;
144: app_exception.raise_exception;
145: END IF;
146:
147: END check_uniqueness;
148:

Line 173: app_exception.raise_exception;

169: new_references.ci_sequence_number
170: ) THEN
171: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
172: igs_ge_msg_stack.add;
173: app_exception.raise_exception;
174: END IF;
175: IF (((old_references.relationship_cd = new_references.relationship_cd )) OR
176: ((new_references.relationship_cd IS NULL))) THEN
177: NULL;

Line 183: app_exception.raise_exception;

179: new_references.relationship_cd
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 295: app_exception.raise_exception;

291: IF (cur_rowid%FOUND) THEN
292: CLOSE cur_rowid;
293: fnd_message.set_name ('IGF', 'IGF_SL_CLSET_CI_FK');
294: igs_ge_msg_stack.add;
295: app_exception.raise_exception;
296: RETURN;
297: END IF;
298: CLOSE cur_rowid;
299:

Line 331: app_exception.raise_exception;

327: IF (cur_rowid%FOUND) THEN
328: CLOSE cur_rowid;
329: fnd_message.set_name ('IGF', 'IGF_SL_CLSET_RECIP_FK');
330: igs_ge_msg_stack.add;
331: app_exception.raise_exception;
332: RETURN;
333: END IF;
334: CLOSE cur_rowid;
335:

Line 442: app_exception.raise_exception;

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

Line 458: app_exception.raise_exception;

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

Line 542: app_exception.raise_exception;

538: END IF;
539: ELSE
540: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
541: igs_ge_msg_stack.add;
542: app_exception.raise_exception;
543: END IF;
544:
545: SELECT igf_sl_cl_setup_s.nextval INTO x_clset_id FROM DUAL;
546:

Line 742: app_exception.raise_exception;

738: IF (c1%notfound) THEN
739: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
740: igs_ge_msg_stack.add;
741: CLOSE c1;
742: app_exception.raise_exception;
743: RETURN;
744: END IF;
745: CLOSE c1;
746: IF (

Line 771: app_exception.raise_exception;

767: NULL;
768: ELSE
769: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
770: igs_ge_msg_stack.add;
771: app_exception.raise_exception;
772: END IF;
773:
774: RETURN;
775:

Line 847: app_exception.raise_exception;

843: END IF;
844: ELSE
845: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
846: igs_ge_msg_stack.add;
847: app_exception.raise_exception;
848: END IF;
849:
850: before_dml(
851: p_action => 'UPDATE',