APPS.IGS_GR_CRM_ROUND_PRD_PKG dependencies on APP_EXCEPTION

Line 38: App_Exception.Raise_Exception;

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;
42:

Line 82: App_Exception.Raise_Exception;

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:
86:

Line 107: APP_EXCEPTION.RAISE_EXCEPTION;

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;
111:

Line 123: APP_EXCEPTION.RAISE_EXCEPTION;

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;
127:

Line 162: App_Exception.Raise_Exception ;

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:
166: IF upper(Column_name) = 'COMPLETION_YEAR' OR COLUMN_NAME IS NULL THEN

Line 170: App_Exception.Raise_Exception ;

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:
174: IF upper(Column_name) = 'COMPLETION_PERIOD' OR COLUMN_NAME IS NULL THEN

Line 180: App_Exception.Raise_Exception ;

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:
184: IF upper(Column_name) = 'GRD_CAL_TYPE' OR COLUMN_NAME IS NULL THEN

Line 188: App_Exception.Raise_Exception ;

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 ;
192: END;

Line 247: App_Exception.Raise_Exception;

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;
251:

Line 296: App_Exception.Raise_Exception;

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;
300: Check_Parent_Existance;

Line 316: App_Exception.Raise_Exception;

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
320: check_constraints;

Line 358: app_exception.raise_exception;

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 (
362: p_action => 'INSERT',

Line 426: app_exception.raise_exception;

422: fetch c1 into tlinfo;
423: if (c1%notfound) then
424: close c1;
425: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
426: app_exception.raise_exception;
427: return;
428: end if;
429: close c1;
430: