APPS.IGS_RE_SCHL_TYPE_PKG dependencies on APP_EXCEPTION

Line 42: App_Exception.Raise_Exception;

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;
46:

Line 89: App_Exception.Raise_Exception ;

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
93: IF new_references.SCHOLARSHIP_TYPE <> upper(NEW_REFERENCES.SCHOLARSHIP_TYPE) THEN

Line 96: App_Exception.Raise_Exception ;

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
100: IF new_references.PERSON_ID_FROM < 1 OR new_references.PERSON_ID_FROM > 9999999999 THEN

Line 103: App_Exception.Raise_Exception ;

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 ;
107:

Line 124: App_Exception.Raise_Exception;

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:
128: IF (((old_references.person_id_from = new_references.person_id_from)) OR

Line 137: App_Exception.Raise_Exception;

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:
141: END Check_Parent_Existance;

Line 199: App_Exception.Raise_Exception;

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;
203:

Line 225: App_Exception.Raise_Exception;

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;
229:

Line 274: App_Exception.Raise_Exception;

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;
278: ELSIF (p_action = 'UPDATE') THEN

Line 291: App_Exception.Raise_Exception;

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
295: Check_Constraints;

Line 334: app_exception.raise_exception;

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 (
338: p_action => 'INSERT',

Line 418: app_exception.raise_exception;

414: fetch c1 into tlinfo;
415: if (c1%notfound) then
416: close c1;
417: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
418: app_exception.raise_exception;
419: return;
420: end if;
421: close c1;
422:

Line 440: app_exception.raise_exception;

436: ) then
437: null;
438: else
439: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
440: app_exception.raise_exception;
441: end if;
442: return;
443: end LOCK_ROW;
444:

Line 475: app_exception.raise_exception;

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 (
479: p_action => 'UPDATE',