APPS.IGS_AD_OS_SEC_EDU_QF_PKG dependencies on APP_EXCEPTION

Line 40: App_Exception.Raise_Exception;

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

Line 83: App_Exception.Raise_Exception;

79: IF upper(Column_Name) = 'OS_SCNDRY_EDU_QUALIFICATION' OR Column_Name IS NULL THEN
80: IF new_references.os_scndry_edu_qualification <> UPPER(new_references.os_scndry_edu_qualification) THEN
81: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
82: IGS_GE_MSG_STACK.ADD;
83: App_Exception.Raise_Exception;
84: END IF;
85: END IF;
86: IF upper(Column_Name) = 'COUNTRY_CD' OR Column_Name IS NULL THEN
87: IF new_references.country_cd <> UPPER(new_references.country_cd) THEN

Line 90: App_Exception.Raise_Exception;

86: IF upper(Column_Name) = 'COUNTRY_CD' OR Column_Name IS NULL THEN
87: IF new_references.country_cd <> UPPER(new_references.country_cd) THEN
88: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
89: IGS_GE_MSG_STACK.ADD;
90: App_Exception.Raise_Exception;
91: END IF;
92: END IF;
93: IF upper(Column_Name) = 'CLOSED_IND' OR Column_Name IS NULL THEN
94: IF new_references.closed_ind NOT IN ('Y','N') THEN

Line 97: App_Exception.Raise_Exception;

93: IF upper(Column_Name) = 'CLOSED_IND' OR Column_Name IS NULL THEN
94: IF new_references.closed_ind NOT IN ('Y','N') THEN
95: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
96: IGS_GE_MSG_STACK.ADD;
97: App_Exception.Raise_Exception;
98: END IF;
99: END IF;
100:
101: END Check_Constraints;

Line 115: App_Exception.Raise_Exception;

111: new_references.country_cd
112: ) THEN
113: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
114: IGS_GE_MSG_STACK.ADD;
115: App_Exception.Raise_Exception;
116: END IF;
117: END IF;
118:
119: END Check_Parent_Existance;

Line 177: App_Exception.Raise_Exception;

173: IF (cur_rowid%FOUND) THEN
174: Close cur_rowid;
175: Fnd_Message.Set_Name ('IGS', 'IGS_AD_OSEQ_CNC_FK');
176: IGS_GE_MSG_STACK.ADD;
177: App_Exception.Raise_Exception;
178: Return;
179: END IF;
180: Close cur_rowid;
181:

Line 219: App_Exception.Raise_Exception;

215: new_references.os_scndry_edu_qualification
216: ) THEN
217: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
218: IGS_GE_MSG_STACK.ADD;
219: App_Exception.Raise_Exception;
220: END IF;
221: Check_Constraints;
222: Check_Parent_Existance;
223: ELSIF (p_action = 'UPDATE') THEN

Line 234: App_Exception.Raise_Exception;

230: new_references.os_scndry_edu_qualification
231: ) THEN
232: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
233: IGS_GE_MSG_STACK.ADD;
234: App_Exception.Raise_Exception;
235: END IF;
236: Check_Constraints;
237: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
238: Check_Constraints;

Line 286: app_exception.raise_exception;

282: end if;
283: else
284: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
285: IGS_GE_MSG_STACK.ADD;
286: app_exception.raise_exception;
287: end if;
288:
289: Before_DML(
290: p_action=>'INSERT' ,

Line 364: app_exception.raise_exception;

360: if (c1%notfound) then
361: close c1;
362: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
363: IGS_GE_MSG_STACK.ADD;
364: app_exception.raise_exception;
365: return;
366: end if;
367: close c1;
368:

Line 379: app_exception.raise_exception;

375: null;
376: else
377: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
378: IGS_GE_MSG_STACK.ADD;
379: app_exception.raise_exception;
380: end if;
381: return;
382: end LOCK_ROW;
383:

Line 412: app_exception.raise_exception;

408: end if;
409: else
410: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
411: IGS_GE_MSG_STACK.ADD;
412: app_exception.raise_exception;
413: end if;
414:
415: Before_DML(
416: p_action=>'UPDATE' ,