APPS.IGS_PS_DSCP_HIST_PKG dependencies on APP_EXCEPTION

Line 46: App_Exception.Raise_Exception;

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

Line 97: App_Exception.Raise_Exception;

93: 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: IF upper(column_name) = 'DISCIPLINE_GROUP_CD' OR

Line 106: App_Exception.Raise_Exception;

102: column_name is null Then
103: IF new_references.discipline_group_cd <> UPPER(new_references.discipline_group_cd) 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:
110: IF upper(column_name) = 'GOVT_DISCIPLINE_GROUP_CD' OR

Line 115: App_Exception.Raise_Exception;

111: column_name is null Then
112: IF new_references.govt_discipline_group_cd <> UPPER(new_references.govt_discipline_group_cd) Then
113: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
114: IGS_GE_MSG_STACK.ADD;
115: App_Exception.Raise_Exception;
116: END IF;
117: END IF;
118: END check_constraints;
119:

Line 198: App_Exception.Raise_Exception;

194: new_references.hist_start_dt
195: ) THEN
196: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
197: IGS_GE_MSG_STACK.ADD;
198: App_Exception.Raise_Exception;
199: END IF;
200: Check_Constraints;
201: ELSIF (p_action = 'UPDATE') THEN
202: -- Call all the procedures related to Before Update.

Line 212: App_Exception.Raise_Exception;

208: new_references.hist_start_dt
209: ) THEN
210: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
211: IGS_GE_MSG_STACK.ADD;
212: App_Exception.Raise_Exception;
213: END IF;
214: Check_Constraints;
215: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
216: Check_Constraints;

Line 271: app_exception.raise_exception;

267: end if;
268: else
269: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
270: IGS_GE_MSG_STACK.ADD;
271: app_exception.raise_exception;
272: end if;
273:
274: Before_DML( p_action => 'INSERT',
275: x_rowid => X_ROWID,

Line 378: app_exception.raise_exception;

374: if (c1%notfound) then
375: close c1;
376: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
377: IGS_GE_MSG_STACK.ADD;
378: app_exception.raise_exception;
379: return;
380: end if;
381: close c1;
382:

Line 409: app_exception.raise_exception;

405: null;
406: else
407: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
408: IGS_GE_MSG_STACK.ADD;
409: app_exception.raise_exception;
410: end if;
411: return;
412: end LOCK_ROW;
413:

Line 449: app_exception.raise_exception;

445: end if;
446: else
447: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
448: IGS_GE_MSG_STACK.ADD;
449: app_exception.raise_exception;
450: end if;
451:
452: Before_DML( p_action => 'UPDATE',
453: x_rowid => X_ROWID,