APPS.IGS_PS_DSCP_HIST_PKG dependencies on IGS_GE_MSG_STACK

Line 45: IGS_GE_MSG_STACK.ADD;

41: Fetch cur_old_ref_values INTO old_references;
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;

Line 96: IGS_GE_MSG_STACK.ADD;

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

Line 105: IGS_GE_MSG_STACK.ADD;

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

Line 114: IGS_GE_MSG_STACK.ADD;

110: IF upper(column_name) = 'GOVT_DISCIPLINE_GROUP_CD' OR
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;

Line 197: IGS_GE_MSG_STACK.ADD;

193: new_references.discipline_group_cd,
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

Line 211: IGS_GE_MSG_STACK.ADD;

207: new_references.discipline_group_cd,
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

Line 270: IGS_GE_MSG_STACK.ADD;

266: X_LAST_UPDATE_LOGIN := -1;
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',

Line 377: IGS_GE_MSG_STACK.ADD;

373: fetch c1 into tlinfo;
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;

Line 408: IGS_GE_MSG_STACK.ADD;

404: ) then
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;

Line 448: IGS_GE_MSG_STACK.ADD;

444: X_LAST_UPDATE_LOGIN := -1;
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',