APPS.IGS_RE_THS_EXAM_HIST_PKG dependencies on APP_EXCEPTION

Line 48: App_Exception.Raise_Exception;

44: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
45: Close cur_old_ref_values;
46: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
47: IGS_GE_MSG_STACK.ADD;
48: App_Exception.Raise_Exception;
49: Return;
50: END IF;
51: Close cur_old_ref_values;
52:

Line 106: App_Exception.Raise_Exception ;

102: IF upper(column_name) = 'CA_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
103: IF new_references.CA_SEQUENCE_NUMBER < 1 OR new_references.CA_SEQUENCE_NUMBER > 999999 then
104: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
105: IGS_GE_MSG_STACK.ADD;
106: App_Exception.Raise_Exception ;
107: END IF;
108: END IF;
109: IF upper(column_name) = 'THE_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
110: IF new_references.THE_SEQUENCE_NUMBER < 1 OR new_references.THE_SEQUENCE_NUMBER > 999999 then

Line 113: App_Exception.Raise_Exception ;

109: IF upper(column_name) = 'THE_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
110: IF new_references.THE_SEQUENCE_NUMBER < 1 OR new_references.THE_SEQUENCE_NUMBER > 999999 then
111: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
112: IGS_GE_MSG_STACK.ADD;
113: App_Exception.Raise_Exception ;
114: END IF;
115: END IF;
116:
117: IF upper(column_name) = 'THESIS_EXAM_TYPE' OR COLUMN_NAME IS NULL THEN

Line 121: App_Exception.Raise_Exception ;

117: IF upper(column_name) = 'THESIS_EXAM_TYPE' OR COLUMN_NAME IS NULL THEN
118: IF new_references.THESIS_EXAM_TYPE <> upper(NEW_REFERENCES.THESIS_EXAM_TYPE) then
119: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
120: IGS_GE_MSG_STACK.ADD;
121: App_Exception.Raise_Exception ;
122: END IF;
123: END IF;
124:
125: IF upper(column_name) = 'THESIS_PANEL_TYPE' OR COLUMN_NAME IS NULL THEN

Line 129: App_Exception.Raise_Exception ;

125: IF upper(column_name) = 'THESIS_PANEL_TYPE' OR COLUMN_NAME IS NULL THEN
126: IF new_references.THESIS_PANEL_TYPE <> upper(NEW_REFERENCES.THESIS_PANEL_TYPE) then
127: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
128: IGS_GE_MSG_STACK.ADD;
129: App_Exception.Raise_Exception ;
130: END IF;
131: END IF;
132:
133: IF upper(column_name) = 'THESIS_RESULT_CD' OR COLUMN_NAME IS NULL THEN

Line 137: App_Exception.Raise_Exception ;

133: IF upper(column_name) = 'THESIS_RESULT_CD' OR COLUMN_NAME IS NULL THEN
134: IF new_references.THESIS_RESULT_CD <> upper(NEW_REFERENCES.THESIS_RESULT_CD) then
135: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
136: IGS_GE_MSG_STACK.ADD;
137: App_Exception.Raise_Exception ;
138: END IF;
139: END IF;
140: END Check_Constraints ;
141:

Line 236: App_Exception.Raise_Exception;

232: new_references.hist_start_dt
233: ) THEN
234: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
235: IGS_GE_MSG_STACK.ADD;
236: App_Exception.Raise_Exception;
237: END IF;
238: Check_Constraints;
239: ELSIF (p_action = 'UPDATE') THEN
240: -- Call all the procedures related to Before Update.

Line 252: App_Exception.Raise_Exception;

248: new_references.hist_start_dt
249: ) THEN
250: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
251: IGS_GE_MSG_STACK.ADD;
252: App_Exception.Raise_Exception;
253: END IF;
254: Check_Constraints;
255: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
256: Check_Constraints;

Line 303: app_exception.raise_exception;

299: end if;
300: else
301: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
302: IGS_GE_MSG_STACK.ADD;
303: app_exception.raise_exception;
304: end if;
305:
306: Before_DML (
307: p_action => 'INSERT',

Line 412: app_exception.raise_exception;

408: fetch c1 into tlinfo ;
409: if (c1%notfound) then
410: close c1;
411: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
412: app_exception.raise_exception;
413: return;
414: end if;
415: close c1;
416:

Line 438: app_exception.raise_exception;

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

Line 479: app_exception.raise_exception;

475: end if;
476: else
477: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
478: IGS_GE_MSG_STACK.ADD;
479: app_exception.raise_exception;
480: end if;
481:
482: Before_DML (
483: p_action => 'UPDATE',