APPS.IGS_GR_TESTAMUR_TYPE_PKG dependencies on APP_EXCEPTION

Line 37: App_Exception.Raise_Exception;

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

Line 90: APP_EXCEPTION.RAISE_EXCEPTION;

86: IF NOT IGS_CO_TYPE_PKG.Get_PK_For_Validation (
87: new_references.correspondence_type
88: ) THEN
89: FND_MESSAGE.SET_NAME ('FND', 'FORM_RECORD_DELETED');
90: APP_EXCEPTION.RAISE_EXCEPTION;
91: END IF; commented for correspondence related changes
92: */
93:
94: END IF;

Line 154: App_Exception.Raise_Exception ;

150:
151: IF upper(Column_name) = 'CLOSED_IND' OR COLUMN_NAME IS NULL THEN
152: IF new_references.CLOSED_IND not in ('Y','N') then
153: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
154: App_Exception.Raise_Exception ;
155: END IF;
156:
157: END IF ;
158:

Line 162: App_Exception.Raise_Exception ;

158:
159: IF upper(Column_name) = 'CORRESPONDENCE_TYPE' OR COLUMN_NAME IS NULL THEN
160: IF new_references.CORRESPONDENCE_TYPE<> upper(new_references.CORRESPONDENCE_TYPE) then
161: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
162: App_Exception.Raise_Exception ;
163: END IF;
164:
165: END IF ;
166:

Line 170: App_Exception.Raise_Exception ;

166:
167: IF upper(Column_name) = 'TESTAMUR_TYPE' OR COLUMN_NAME IS NULL THEN
168: IF new_references.TESTAMUR_TYPE<> upper(new_references.TESTAMUR_TYPE) then
169: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
170: App_Exception.Raise_Exception ;
171: END IF;
172:
173: END IF ;
174: END CHECK_CONSTRAINTS;

Line 195: App_Exception.Raise_Exception;

191: Fetch cur_rowid INTO lv_rowid;
192: IF (cur_rowid%FOUND) THEN
193: Close cur_rowid;
194: Fnd_Message.Set_Name ('IGS', 'IGS_GR_TT_CORT_FK');
195: App_Exception.Raise_Exception;
196: Return;
197: END IF;
198: Close cur_rowid;
199:

Line 236: App_Exception.Raise_Exception;

232: -- Call all the procedures related to Before Insert.
233: BeforeRowInsertUpdate1 ( p_inserting => TRUE );
234: IF GET_PK_FOR_VALIDATION(NEW_REFERENCES.testamur_type) THEN
235: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
236: App_Exception.Raise_Exception;
237: END IF;
238:
239: check_constraints;
240: Check_Parent_Existance;

Line 253: App_Exception.Raise_Exception;

249: Check_Child_Existance;
250: ELSIF (p_action = 'VALIDATE_INSERT') THEN
251: IF GET_PK_FOR_VALIDATION(NEW_REFERENCES.testamur_type) THEN
252: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
253: App_Exception.Raise_Exception;
254: END IF;
255:
256: check_constraints;
257: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 302: app_exception.raise_exception;

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

Line 372: app_exception.raise_exception;

368: fetch c1 into tlinfo;
369: if (c1%notfound) then
370: close c1;
371: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
372: app_exception.raise_exception;
373: return;
374: end if;
375: close c1;
376:

Line 384: app_exception.raise_exception;

380: ) then
381: null;
382: else
383: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
384: app_exception.raise_exception;
385: end if;
386: return;
387: end LOCK_ROW;
388:

Line 416: app_exception.raise_exception;

412: X_LAST_UPDATE_LOGIN := -1;
413: end if;
414: else
415: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
416: app_exception.raise_exception;
417: end if;
418:
419: Before_DML (
420: p_action => 'UPDATE',