APPS.IGS_RE_GV_FLD_OF_SDY_PKG dependencies on IGS_GE_MSG_STACK

Line 38: IGS_GE_MSG_STACK.ADD;

34: Fetch cur_old_ref_values INTO old_references;
35: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
36: Close cur_old_ref_values;
37: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
38: IGS_GE_MSG_STACK.ADD;
39: App_Exception.Raise_Exception;
40: Return;
41: END IF;
42: Close cur_old_ref_values;

Line 77: IGS_GE_MSG_STACK.ADD;

73: new_references.govt_field_of_study,
74: new_references.closed_ind,
75: v_message_name) = FALSE THEN
76: Fnd_Message.Set_Name ('IGS', v_message_name);
77: IGS_GE_MSG_STACK.ADD;
78: App_Exception.Raise_Exception;
79: END IF;
80: END IF;
81:

Line 103: IGS_GE_MSG_STACK.ADD;

99:
100: IF upper(column_name) = 'CLOSED_IND' OR COLUMN_NAME IS NULL THEN
101: IF new_references.closed_ind <> upper(NEW_REFERENCES.closed_ind) OR new_references.closed_ind NOT IN ('Y', 'N') THEN
102: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
103: IGS_GE_MSG_STACK.ADD;
104: App_Exception.Raise_Exception ;
105: END IF;
106: END IF;
107: IF upper(column_name) = 'GOVT_FIELD_OF_STUDY' OR COLUMN_NAME IS NULL THEN

Line 110: IGS_GE_MSG_STACK.ADD;

106: END IF;
107: IF upper(column_name) = 'GOVT_FIELD_OF_STUDY' OR COLUMN_NAME IS NULL THEN
108: IF new_references.GOVT_FIELD_OF_STUDY <> upper(NEW_REFERENCES.GOVT_FIELD_OF_STUDY) then
109: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
110: IGS_GE_MSG_STACK.ADD;
111: App_Exception.Raise_Exception ;
112: END IF;
113: END IF;
114: IF upper(column_name) = 'RES_FCD_CLASS_IND' OR COLUMN_NAME IS NULL THEN

Line 118: IGS_GE_MSG_STACK.ADD;

114: IF upper(column_name) = 'RES_FCD_CLASS_IND' OR COLUMN_NAME IS NULL THEN
115: IF new_references.RES_FCD_CLASS_IND <> upper(NEW_REFERENCES.RES_FCD_CLASS_IND) OR
116: new_references.RES_FCD_CLASS_IND NOT IN ('Y', 'N') THEN
117: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
118: IGS_GE_MSG_STACK.ADD;
119: App_Exception.Raise_Exception ;
120: END IF;
121: END IF;
122: END Check_Constraints ;

Line 198: IGS_GE_MSG_STACK.ADD;

194: new_references.govt_field_of_study
195: ) THEN
196:
197: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
198: IGS_GE_MSG_STACK.ADD;
199: App_Exception.Raise_Exception;
200: END IF;
201: Check_Constraints;
202: ELSIF (p_action = 'UPDATE') THEN

Line 214: IGS_GE_MSG_STACK.ADD;

210: IF Get_PK_For_Validation (
211: new_references.govt_field_of_study
212: ) THEN
213: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
214: IGS_GE_MSG_STACK.ADD;
215: App_Exception.Raise_Exception;
216: END IF;
217: Check_Constraints;
218: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 254: IGS_GE_MSG_STACK.ADD;

250: X_LAST_UPDATE_LOGIN := -1;
251: end if;
252: else
253: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
254: IGS_GE_MSG_STACK.ADD;
255: app_exception.raise_exception;
256: end if;
257:
258: Before_DML (

Line 370: IGS_GE_MSG_STACK.ADD;

366: X_LAST_UPDATE_LOGIN := -1;
367: end if;
368: else
369: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
370: IGS_GE_MSG_STACK.ADD;
371: app_exception.raise_exception;
372: end if;
373:
374: Before_DML (