APPS.IGS_AD_SS_PERSON_PKG dependencies on APP_EXCEPTION

Line 95: App_Exception.Raise_Exception;

91: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
92: CLOSE cur_old_ref_values;
93: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
94: IGS_GE_MSG_STACK.ADD;
95: App_Exception.Raise_Exception;
96: RETURN;
97: END IF;
98: CLOSE cur_old_ref_values;
99: -- Populate New Values.

Line 245: App_Exception.Raise_Exception;

241: IF (cur_rowid%NOTFOUND) THEN
242: Close cur_rowid;
243: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
244: IGS_GE_MSG_STACK.ADD;
245: App_Exception.Raise_Exception;
246: END IF;
247: IF (cur_rowid%ISOPEN) THEN
248: Close cur_rowid;
249: END IF;

Line 477: App_Exception.Raise_Exception;

473: IF Get_PK_For_Validation (
474: new_references.person_id ) THEN
475: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
476: IGS_GE_MSG_STACK.ADD;
477: App_Exception.Raise_Exception;
478: END IF;
479: Check_Parent_Existance; -- if procedure present
480: ELSIF (p_action = 'UPDATE') THEN
481: -- Call all the procedures related to Before Update.

Line 491: App_Exception.Raise_Exception;

487: IF Get_PK_For_Validation (
488: new_references.person_id ) THEN
489: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
490: IGS_GE_MSG_STACK.ADD;
491: App_Exception.Raise_Exception;
492: END IF;
493: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
494: NULL;
495: ELSIF (p_action = 'VALIDATE_DELETE') THEN

Line 775: App_Exception.Raise_Exception;

771: IF c_pe_rowid%NOTFOUND THEN
772: CLOSE c_pe_rowid;
773: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
774: IGS_GE_MSG_STACK.ADD;
775: App_Exception.Raise_Exception;
776: END IF;
777: CLOSE c_pe_rowid;
778:
779: ELSE