APPS.IGS_RE_SCHL_TYPE_PKG dependencies on IGS_GE_MSG_STACK

Line 41: IGS_GE_MSG_STACK.ADD;

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

Line 88: IGS_GE_MSG_STACK.ADD;

84:
85: IF upper(column_name) = 'CLOSED_IND' OR COLUMN_NAME IS NULL THEN
86: IF new_references.closed_ind <> upper(NEW_REFERENCES.closed_ind) OR new_references.closed_ind NOT IN ('Y', 'N') THEN
87: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
88: IGS_GE_MSG_STACK.ADD;
89: App_Exception.Raise_Exception ;
90: END IF;
91: END IF;
92: IF upper(column_name) = 'SCHOLARSHIP_TYPE' OR COLUMN_NAME IS NULL THEN

Line 95: IGS_GE_MSG_STACK.ADD;

91: END IF;
92: IF upper(column_name) = 'SCHOLARSHIP_TYPE' OR COLUMN_NAME IS NULL THEN
93: IF new_references.SCHOLARSHIP_TYPE <> upper(NEW_REFERENCES.SCHOLARSHIP_TYPE) THEN
94: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
95: IGS_GE_MSG_STACK.ADD;
96: App_Exception.Raise_Exception ;
97: END IF;
98: END IF;
99: IF upper(column_name) = 'PERSON_ID_FROM' OR COLUMN_NAME IS NULL THEN

Line 102: IGS_GE_MSG_STACK.ADD;

98: END IF;
99: IF upper(column_name) = 'PERSON_ID_FROM' OR COLUMN_NAME IS NULL THEN
100: IF new_references.PERSON_ID_FROM < 1 OR new_references.PERSON_ID_FROM > 9999999999 THEN
101: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
102: IGS_GE_MSG_STACK.ADD;
103: App_Exception.Raise_Exception ;
104: END IF;
105: END IF;
106: END Check_Constraints ;

Line 123: IGS_GE_MSG_STACK.ADD;

119: new_references.org_unit_cd_from,
120: new_references.ou_start_dt_from
121: ) THEN
122: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
123: IGS_GE_MSG_STACK.ADD;
124: App_Exception.Raise_Exception;
125: END IF;
126: END IF;
127:

Line 136: IGS_GE_MSG_STACK.ADD;

132: IF NOT IGS_PE_PERSON_PKG.Get_PK_For_Validation (
133: new_references.person_id_from
134: ) THEN
135: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
136: IGS_GE_MSG_STACK.ADD;
137: App_Exception.Raise_Exception;
138: END IF;
139: END IF;
140:

Line 198: IGS_GE_MSG_STACK.ADD;

194: Fetch cur_rowid INTO lv_rowid;
195: IF (cur_rowid%FOUND) THEN
196: Close cur_rowid;
197: Fnd_Message.Set_Name ('IGS', 'IGS_RE_SCT_OU_FK');
198: IGS_GE_MSG_STACK.ADD;
199: App_Exception.Raise_Exception;
200: Return;
201: END IF;
202: Close cur_rowid;

Line 224: IGS_GE_MSG_STACK.ADD;

220: Fetch cur_rowid INTO lv_rowid;
221: IF (cur_rowid%FOUND) THEN
222: Close cur_rowid;
223: Fnd_Message.Set_Name ('IGS', 'IGS_RE_SCT_PE_FK');
224: IGS_GE_MSG_STACK.ADD;
225: App_Exception.Raise_Exception;
226: Return;
227: END IF;
228: Close cur_rowid;

Line 273: IGS_GE_MSG_STACK.ADD;

269: new_references.scholarship_type
270: ) THEN
271:
272: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
273: IGS_GE_MSG_STACK.ADD;
274: App_Exception.Raise_Exception;
275: END IF;
276: Check_Constraints;
277: Check_Parent_Existance;

Line 290: IGS_GE_MSG_STACK.ADD;

286: IF Get_PK_For_Validation (
287: new_references.scholarship_type
288: ) THEN
289: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
290: IGS_GE_MSG_STACK.ADD;
291: App_Exception.Raise_Exception;
292: END IF;
293: Check_Constraints;
294: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 333: IGS_GE_MSG_STACK.ADD;

329: X_LAST_UPDATE_LOGIN := -1;
330: end if;
331: else
332: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
333: IGS_GE_MSG_STACK.ADD;
334: app_exception.raise_exception;
335: end if;
336:
337: Before_DML (

Line 474: IGS_GE_MSG_STACK.ADD;

470: X_LAST_UPDATE_LOGIN := -1;
471: end if;
472: else
473: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
474: IGS_GE_MSG_STACK.ADD;
475: app_exception.raise_exception;
476: end if;
477:
478: Before_DML (