APPS.IGS_PE_PERSON_PKG dependencies on APP_EXCEPTION

Line 108: App_Exception.Raise_Exception;

104: CLOSE cur_old_ref_values;
105:
106: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
107: IGS_GE_MSG_STACK.ADD;
108: App_Exception.Raise_Exception;
109: RETURN;
110: END IF;
111: CLOSE cur_old_ref_values;
112: -- Populate New Values.

Line 476: App_Exception.Raise_Exception;

472: IF (p_action IN ('INSERT','UPDATE')) THEN
473: IF(x_birth_dt IS NOT NULL AND x_birth_dt > sysdate) THEN
474: FND_MESSAGE.SET_NAME('IGS','IGS_AD_BIRTH_DT');
475: IGS_GE_MSG_STACK.ADD;
476: App_Exception.Raise_Exception;
477: END IF;
478: IF(x_deceased_date IS NOT NULL AND x_deceased_date > sysdate) THEN
479: FND_MESSAGE.SET_NAME('IGS','IGS_AD_DEC_DT');
480: IGS_GE_MSG_STACK.ADD;

Line 481: App_Exception.Raise_Exception;

477: END IF;
478: IF(x_deceased_date IS NOT NULL AND x_deceased_date > sysdate) THEN
479: FND_MESSAGE.SET_NAME('IGS','IGS_AD_DEC_DT');
480: IGS_GE_MSG_STACK.ADD;
481: App_Exception.Raise_Exception;
482: END IF;
483: IF(x_deceased_date IS NOT NULL AND x_birth_dt IS NOT NULL AND x_deceased_date < x_birth_dt) THEN
484: Fnd_Message.Set_Name('IGS','IGS_AD_DEC_BIRTH_DT');
485: IGS_GE_MSG_STACK.ADD;

Line 486: App_Exception.Raise_Exception;

482: END IF;
483: IF(x_deceased_date IS NOT NULL AND x_birth_dt IS NOT NULL AND x_deceased_date < x_birth_dt) THEN
484: Fnd_Message.Set_Name('IGS','IGS_AD_DEC_BIRTH_DT');
485: IGS_GE_MSG_STACK.ADD;
486: App_Exception.Raise_Exception;
487: END IF;
488: END IF;
489: IF (p_action = 'INSERT') THEN
490: -- Call all the procedures related to Before Insert.

Line 495: App_Exception.Raise_Exception;

491: IF Get_PK_For_Validation (
492: new_references.person_id ) THEN
493: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
494: IGS_GE_MSG_STACK.ADD;
495: App_Exception.Raise_Exception;
496: END IF;
497: Check_Parent_Existance; -- if procedure present
498: ELSIF (p_action = 'UPDATE') THEN
499: -- Call all the procedures related to Before Update.

Line 509: App_Exception.Raise_Exception;

505: IF Get_PK_For_Validation (
506: new_references.person_id ) THEN
507: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
508: IGS_GE_MSG_STACK.ADD;
509: App_Exception.Raise_Exception;
510: END IF;
511: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
512: NULL;
513: ELSIF (p_action = 'VALIDATE_DELETE') THEN

Line 834: App_Exception.Raise_Exception;

830: IF c_pe_rowid%NOTFOUND THEN
831: CLOSE c_pe_rowid;
832: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
833: IGS_GE_MSG_STACK.ADD;
834: App_Exception.Raise_Exception;
835: END IF;
836: CLOSE c_pe_rowid;
837:
838: END IF;