APPS.IGS_GR_HONOURS_LEVEL_PKG dependencies on APP_EXCEPTION

Line 39: App_Exception.Raise_Exception;

35: Fetch cur_old_ref_values INTO old_references;
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: App_Exception.Raise_Exception;
40: Return;
41: END IF;
42: Close cur_old_ref_values;
43:

Line 85: App_Exception.Raise_Exception;

81: IF IGS_GR_VAL_GHL.grdp_val_ghl_closed(
82: new_references.govt_honours_level,
83: v_message_name) = FALSE THEN
84: Fnd_Message.Set_Name('IGS', v_message_name);
85: App_Exception.Raise_Exception;
86: END IF;
87: END IF;
88:
89:

Line 103: APP_EXCEPTION.RAISE_EXCEPTION;

99: IF NOT IGS_GR_GOVT_HNS_LVL_PKG.Get_PK_For_Validation (
100: new_references.govt_honours_level
101: ) THEN
102: FND_MESSAGE.SET_NAME ('FND', 'FORM_RECORD_DELETED');
103: APP_EXCEPTION.RAISE_EXCEPTION;
104: END IF;
105:
106: END IF;
107:

Line 131: App_Exception.Raise_Exception ;

127:
128: IF upper(Column_name) = 'CLOSED_IND' OR COLUMN_NAME IS NULL THEN
129: IF new_references.CLOSED_IND<> upper(new_references.CLOSED_IND) then
130: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
131: App_Exception.Raise_Exception ;
132: END IF;
133:
134: END IF ;
135:

Line 139: App_Exception.Raise_Exception ;

135:
136: IF upper(Column_name) = 'GOVT_HONOURS_LEVEL' OR COLUMN_NAME IS NULL THEN
137: IF new_references.GOVT_HONOURS_LEVEL<> upper(new_references.GOVT_HONOURS_LEVEL) then
138: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
139: App_Exception.Raise_Exception ;
140: END IF;
141:
142: END IF ;
143:

Line 147: App_Exception.Raise_Exception ;

143:
144: IF upper(Column_name) = 'HONOURS_LEVEL' OR COLUMN_NAME IS NULL THEN
145: IF new_references.HONOURS_LEVEL<> upper(new_references.HONOURS_LEVEL) then
146: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
147: App_Exception.Raise_Exception ;
148: END IF;
149:
150: END IF ;
151: END CHECK_CONSTRAINTS;

Line 213: App_Exception.Raise_Exception;

209: Fetch cur_rowid INTO lv_rowid;
210: IF (cur_rowid%FOUND) THEN
211: Close cur_rowid;
212: Fnd_Message.Set_Name ('IGS', 'IGS_GR_HL_GHL_FK');
213: App_Exception.Raise_Exception;
214: Return;
215: END IF;
216: Close cur_rowid;
217:

Line 264: App_Exception.Raise_Exception;

260: IF GET_PK_FOR_VALIDATION(
261: NEW_REFERENCES.honours_level
262: ) THEN
263: Fnd_Message.Set_Name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
264: App_Exception.Raise_Exception;
265: END IF;
266:
267: check_constraints;
268: Check_Parent_Existance;

Line 285: App_Exception.Raise_Exception;

281: IF GET_PK_FOR_VALIDATION(
282: NEW_REFERENCES.honours_level
283: ) THEN
284: Fnd_Message.Set_Name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
285: App_Exception.Raise_Exception;
286: END IF;
287:
288: check_constraints;
289: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 330: app_exception.raise_exception;

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

Line 408: app_exception.raise_exception;

404: fetch c1 into tlinfo;
405: if (c1%notfound) then
406: close c1;
407: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
408: app_exception.raise_exception;
409: return;
410: end if;
411: close c1;
412:

Line 424: app_exception.raise_exception;

420: ) then
421: null;
422: else
423: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
424: app_exception.raise_exception;
425: end if;
426: return;
427: end LOCK_ROW;
428:

Line 457: app_exception.raise_exception;

453: X_LAST_UPDATE_LOGIN := -1;
454: end if;
455: else
456: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
457: app_exception.raise_exception;
458: end if;
459:
460: Before_DML (
461: p_action => 'UPDATE',