APPS.IGS_RE_THS_PNL_MR_HS_PKG dependencies on APP_EXCEPTION

Line 51: App_Exception.Raise_Exception;

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

Line 111: App_Exception.Raise_Exception;

107: IF upper(Column_name) = 'THESIS_RESULT_CD' OR column_name is null then
108: IF new_references.thesis_result_cd <> UPPER(new_references.thesis_result_cd ) 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:
115: IF upper(Column_name) = 'ANONYMITY_IND' OR column_name is null then

Line 120: App_Exception.Raise_Exception;

116: IF new_references.anonymity_ind <> UPPER(new_references.anonymity_ind ) OR
117: new_references.anonymity_ind NOT IN ( 'Y' , 'N' ) then
118: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
119: IGS_GE_MSG_STACK.ADD;
120: App_Exception.Raise_Exception;
121: END IF;
122: END IF;
123:
124: IF upper(Column_name) = 'PANEL_MEMBER_TYPE' OR column_name is null then

Line 128: App_Exception.Raise_Exception;

124: IF upper(Column_name) = 'PANEL_MEMBER_TYPE' OR column_name is null then
125: IF new_references.panel_member_type <> UPPER(new_references.panel_member_type ) then
126: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
127: IGS_GE_MSG_STACK.ADD;
128: App_Exception.Raise_Exception;
129: END IF;
130: END IF;
131:
132: IF upper(Column_name) = 'THE_SEQUENCE_NUMBER' OR column_name is null then

Line 136: App_Exception.Raise_Exception;

132: IF upper(Column_name) = 'THE_SEQUENCE_NUMBER' OR column_name is null then
133: IF new_references.the_sequence_number < 1 OR new_references.the_sequence_number > 999999 THEN
134: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
135: IGS_GE_MSG_STACK.ADD;
136: App_Exception.Raise_Exception;
137: END IF;
138: END IF;
139:
140: IF upper(Column_name) = 'CA_SEQUENCE_NUMBER' OR column_name is null then

Line 144: App_Exception.Raise_Exception;

140: IF upper(Column_name) = 'CA_SEQUENCE_NUMBER' OR column_name is null then
141: IF new_references.ca_sequence_number < 1 OR new_references.ca_sequence_number > 999999 THEN
142: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
143: IGS_GE_MSG_STACK.ADD;
144: App_Exception.Raise_Exception;
145: END IF;
146: END IF;
147:
148: END Check_Constraints;

Line 255: App_Exception.Raise_Exception;

251: new_references.hist_start_dt
252: )THEN
253: Fnd_Message.Set_Name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
254: IGS_GE_MSG_STACK.ADD;
255: App_Exception.Raise_Exception;
256: END IF;
257: Check_Constraints;
258: ELSIF (p_action = 'UPDATE') THEN
259: -- Call all the procedures related to Before Update.

Line 272: App_Exception.Raise_Exception;

268: new_references.hist_start_dt
269: )THEN
270: Fnd_Message.Set_Name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
271: IGS_GE_MSG_STACK.ADD;
272: App_Exception.Raise_Exception;
273: END IF;
274: Check_Constraints;
275: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
276: Check_Constraints;

Line 329: app_exception.raise_exception;

325: end if;
326: else
327: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
328: IGS_GE_MSG_STACK.ADD;
329: app_exception.raise_exception;
330: end if;
331:
332: Before_DML (
333: p_action => 'INSERT',

Line 458: app_exception.raise_exception;

454: fetch c1 into tlinfo;
455: if (c1%notfound) then
456: close c1;
457: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
458: app_exception.raise_exception;
459: return;
460: end if;
461: close c1;
462:

Line 493: app_exception.raise_exception;

489: ) then
490: null;
491: else
492: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
493: app_exception.raise_exception;
494: end if;
495: return;
496: end LOCK_ROW;
497:

Line 538: app_exception.raise_exception;

534: end if;
535: else
536: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
537: IGS_GE_MSG_STACK.ADD;
538: app_exception.raise_exception;
539: end if;
540:
541: Before_DML (
542: p_action => 'UPDATE',