APPS.IGS_RE_THS_PNL_MR_HS_PKG dependencies on IGS_GE_MSG_STACK

Line 50: IGS_GE_MSG_STACK.ADD;

46: Fetch cur_old_ref_values INTO old_references;
47: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
48: Close cur_old_ref_values;
49: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
50: IGS_GE_MSG_STACK.ADD;
51: App_Exception.Raise_Exception;
52: Return;
53: END IF;
54: Close cur_old_ref_values;

Line 110: IGS_GE_MSG_STACK.ADD;

106:
107: IF upper(Column_name) = 'THESIS_RESULT_CD' OR column_name is null then
108: IF new_references.thesis_result_cd <> UPPER(new_references.thesis_result_cd ) then
109: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
110: IGS_GE_MSG_STACK.ADD;
111: App_Exception.Raise_Exception;
112: END IF;
113: END IF;
114:

Line 119: IGS_GE_MSG_STACK.ADD;

115: IF upper(Column_name) = 'ANONYMITY_IND' OR column_name is null then
116: IF new_references.anonymity_ind <> UPPER(new_references.anonymity_ind ) OR
117: new_references.anonymity_ind NOT IN ( 'Y' , 'N' ) then
118: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
119: IGS_GE_MSG_STACK.ADD;
120: App_Exception.Raise_Exception;
121: END IF;
122: END IF;
123:

Line 127: IGS_GE_MSG_STACK.ADD;

123:
124: IF upper(Column_name) = 'PANEL_MEMBER_TYPE' OR column_name is null then
125: IF new_references.panel_member_type <> UPPER(new_references.panel_member_type ) then
126: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
127: IGS_GE_MSG_STACK.ADD;
128: App_Exception.Raise_Exception;
129: END IF;
130: END IF;
131:

Line 135: IGS_GE_MSG_STACK.ADD;

131:
132: IF upper(Column_name) = 'THE_SEQUENCE_NUMBER' OR column_name is null then
133: IF new_references.the_sequence_number < 1 OR new_references.the_sequence_number > 999999 THEN
134: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
135: IGS_GE_MSG_STACK.ADD;
136: App_Exception.Raise_Exception;
137: END IF;
138: END IF;
139:

Line 143: IGS_GE_MSG_STACK.ADD;

139:
140: IF upper(Column_name) = 'CA_SEQUENCE_NUMBER' OR column_name is null then
141: IF new_references.ca_sequence_number < 1 OR new_references.ca_sequence_number > 999999 THEN
142: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
143: IGS_GE_MSG_STACK.ADD;
144: App_Exception.Raise_Exception;
145: END IF;
146: END IF;
147:

Line 254: IGS_GE_MSG_STACK.ADD;

250: new_references.person_id,
251: new_references.hist_start_dt
252: )THEN
253: Fnd_Message.Set_Name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
254: IGS_GE_MSG_STACK.ADD;
255: App_Exception.Raise_Exception;
256: END IF;
257: Check_Constraints;
258: ELSIF (p_action = 'UPDATE') THEN

Line 271: IGS_GE_MSG_STACK.ADD;

267: new_references.person_id,
268: new_references.hist_start_dt
269: )THEN
270: Fnd_Message.Set_Name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
271: IGS_GE_MSG_STACK.ADD;
272: App_Exception.Raise_Exception;
273: END IF;
274: Check_Constraints;
275: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 328: IGS_GE_MSG_STACK.ADD;

324: X_LAST_UPDATE_LOGIN := -1;
325: end if;
326: else
327: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
328: IGS_GE_MSG_STACK.ADD;
329: app_exception.raise_exception;
330: end if;
331:
332: Before_DML (

Line 537: IGS_GE_MSG_STACK.ADD;

533: X_LAST_UPDATE_LOGIN := -1;
534: end if;
535: else
536: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
537: IGS_GE_MSG_STACK.ADD;
538: app_exception.raise_exception;
539: end if;
540:
541: Before_DML (