APPS.IGS_GR_CRM_ROUND_PRD_PKG dependencies on IGS_GE_MSG_STACK

Line 37: IGS_GE_MSG_STACK.ADD;

33: Fetch cur_old_ref_values INTO old_references;
34: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
35: Close cur_old_ref_values;
36: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
37: IGS_GE_MSG_STACK.ADD;
38: App_Exception.Raise_Exception;
39: Return;
40: END IF;
41: Close cur_old_ref_values;

Line 81: IGS_GE_MSG_STACK.ADD;

77: new_references.grd_cal_type,
78: new_references.grd_ci_sequence_number,
79: v_message_name) = FALSE THEN
80: Fnd_Message.Set_Name('IGS', v_message_name);
81: IGS_GE_MSG_STACK.ADD;
82: App_Exception.Raise_Exception;
83: END IF;
84: END IF;
85:

Line 106: IGS_GE_MSG_STACK.ADD;

102: new_references.grd_cal_type,
103: new_references.grd_ci_sequence_number
104: ) THEN
105: FND_MESSAGE.SET_NAME ('FND', 'FORM_RECORD_DELETED');
106: IGS_GE_MSG_STACK.ADD;
107: APP_EXCEPTION.RAISE_EXCEPTION;
108: END IF;
109:
110: END IF;

Line 122: IGS_GE_MSG_STACK.ADD;

118: IF NOT IGS_EN_NOM_CMPL_PRD_PKG.Get_PK_For_Validation (
119: new_references.completion_period
120: ) THEN
121: FND_MESSAGE.SET_NAME ('FND', 'FORM_RECORD_DELETED');
122: IGS_GE_MSG_STACK.ADD;
123: APP_EXCEPTION.RAISE_EXCEPTION;
124: END IF;
125:
126: END IF;

Line 161: IGS_GE_MSG_STACK.ADD;

157:
158: IF upper(Column_name) = 'GRD_CI_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
159: IF new_references.GRD_CI_SEQUENCE_NUMBER < 1 OR new_references.GRD_CI_SEQUENCE_NUMBER > 999999 then
160: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
161: IGS_GE_MSG_STACK.ADD;
162: App_Exception.Raise_Exception ;
163: END IF;
164: END IF ;
165:

Line 169: IGS_GE_MSG_STACK.ADD;

165:
166: IF upper(Column_name) = 'COMPLETION_YEAR' OR COLUMN_NAME IS NULL THEN
167: IF new_references.COMPLETION_YEAR < 1000 OR new_references.COMPLETION_YEAR > 9999 then
168: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
169: IGS_GE_MSG_STACK.ADD;
170: App_Exception.Raise_Exception ;
171: END IF;
172: END IF ;
173:

Line 179: IGS_GE_MSG_STACK.ADD;

175: --smaddali removed a constraint to check values in list ('E','S','M')
176: --for bug # 2237194 ARCR043 ccr
177: IF new_references.COMPLETION_PERIOD<> upper(NEW_REFERENCES.COMPLETION_PERIOD) then
178: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
179: IGS_GE_MSG_STACK.ADD;
180: App_Exception.Raise_Exception ;
181: END IF;
182: END IF ;
183:

Line 187: IGS_GE_MSG_STACK.ADD;

183:
184: IF upper(Column_name) = 'GRD_CAL_TYPE' OR COLUMN_NAME IS NULL THEN
185: IF new_references.GRD_CAL_TYPE<> upper(NEW_REFERENCES.GRD_CAL_TYPE) then
186: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
187: IGS_GE_MSG_STACK.ADD;
188: App_Exception.Raise_Exception ;
189: END IF;
190:
191: END IF ;

Line 246: IGS_GE_MSG_STACK.ADD;

242: Fetch cur_rowid INTO lv_rowid;
243: IF (cur_rowid%FOUND) THEN
244: Close cur_rowid;
245: Fnd_Message.Set_Name ('IGS', 'IGS_GR_CRDP_CRD_FK');
246: IGS_GE_MSG_STACK.ADD;
247: App_Exception.Raise_Exception;
248: Return;
249: END IF;
250: Close cur_rowid;

Line 295: IGS_GE_MSG_STACK.ADD;

291: NEW_REFERENCES.completion_year,
292: NEW_REFERENCES.completion_period
293: ) THEN
294: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
295: IGS_GE_MSG_STACK.ADD;
296: App_Exception.Raise_Exception;
297: END IF;
298:
299: check_constraints;

Line 315: IGS_GE_MSG_STACK.ADD;

311: NEW_REFERENCES.completion_year,
312: NEW_REFERENCES.completion_period
313: ) THEN
314: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
315: IGS_GE_MSG_STACK.ADD;
316: App_Exception.Raise_Exception;
317: END IF;
318: check_constraints;
319: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 357: IGS_GE_MSG_STACK.ADD;

353: X_LAST_UPDATE_LOGIN := -1;
354: end if;
355: else
356: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
357: IGS_GE_MSG_STACK.ADD;
358: app_exception.raise_exception;
359: end if;
360:
361: Before_DML (