APPS.IGS_GE_S_GEN_CAL_CON_PKG dependencies on APP_EXCEPTION

Line 37: App_Exception.Raise_Exception;

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

Line 101: App_Exception.Raise_Exception;

97: IF upper(Column_name) = 'CENSUS_DT_ALIAS' OR column_name is null then
98: IF new_references.census_dt_alias<> UPPER(new_references.census_dt_alias) then
99: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
100: IGS_GE_MSG_STACK.ADD;
101: App_Exception.Raise_Exception;
102: END IF;
103: END IF;
104: IF upper(Column_name) = 'CRS_COMPLETION_CUTOFF_DT_ALIAS' OR column_name is null then
105: IF new_references.CRS_COMPLETION_CUTOFF_DT_ALIAS<> UPPER(new_references.CRS_COMPLETION_CUTOFF_DT_ALIAS) then

Line 108: App_Exception.Raise_Exception;

104: IF upper(Column_name) = 'CRS_COMPLETION_CUTOFF_DT_ALIAS' OR column_name is null then
105: IF new_references.CRS_COMPLETION_CUTOFF_DT_ALIAS<> UPPER(new_references.CRS_COMPLETION_CUTOFF_DT_ALIAS) then
106: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
107: IGS_GE_MSG_STACK.ADD;
108: App_Exception.Raise_Exception;
109: END IF;
110: END IF;
111: IF upper(Column_name) = 'S_CONTROL_NUM' OR column_name is null then
112: IF new_references.s_control_num <> 1 THEN

Line 115: App_Exception.Raise_Exception;

111: IF upper(Column_name) = 'S_CONTROL_NUM' OR column_name is null then
112: IF new_references.s_control_num <> 1 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 133: App_Exception.Raise_Exception;

129: new_references.census_dt_alias
130: ) THEN
131: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
132: IGS_GE_MSG_STACK.ADD;
133: App_Exception.Raise_Exception;
134: END IF;
135: END IF;
136:
137: IF (((old_references.crs_completion_cutoff_dt_alias = new_references.crs_completion_cutoff_dt_alias)) OR

Line 146: App_Exception.Raise_Exception;

142: new_references.crs_completion_cutoff_dt_alias
143: ) THEN
144: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
145: IGS_GE_MSG_STACK.ADD;
146: App_Exception.Raise_Exception;
147: END IF;
148: END IF;
149:
150: END Check_Parent_Existance;

Line 198: App_Exception.Raise_Exception;

194: IF (cur_rowid%FOUND) THEN
195: Close cur_rowid;
196: Fnd_Message.Set_Name ('IGS', 'IGS_GE_SGCC_DA_CENSUS_FK');
197: IGS_GE_MSG_STACK.ADD;
198: App_Exception.Raise_Exception;
199: Return;
200: END IF;
201: Close cur_rowid;
202:

Line 238: App_Exception.Raise_Exception;

234: BeforeRowInsertUpdate1 ( p_inserting => TRUE );
235: IF Get_PK_For_Validation(new_references.s_control_num)THEN
236: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
237: IGS_GE_MSG_STACK.ADD;
238: App_Exception.Raise_Exception;
239: END IF;
240: Check_Constraints;
241: Check_Parent_Existance;
242: ELSIF (p_action = 'UPDATE') THEN

Line 254: App_Exception.Raise_Exception;

250: ELSIF (p_action = 'VALIDATE_INSERT') THEN
251: IF Get_PK_For_Validation(new_references.s_control_num)THEN
252: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
253: IGS_GE_MSG_STACK.ADD;
254: App_Exception.Raise_Exception;
255: END IF;
256: Check_Constraints;
257: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
258: Check_Constraints;

Line 317: app_exception.raise_exception;

313: end if;
314: else
315: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
316: IGS_GE_MSG_STACK.ADD;
317: app_exception.raise_exception;
318: end if;
319: Before_DML (
320: p_action => 'INSERT',
321: x_rowid => X_ROWID,

Line 387: app_exception.raise_exception;

383: if (c1%notfound) then
384: close c1;
385: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
386: IGS_GE_MSG_STACK.ADD;
387: app_exception.raise_exception;
388: return;
389: end if;
390: close c1;
391:

Line 401: app_exception.raise_exception;

397: null;
398: else
399: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
400: IGS_GE_MSG_STACK.ADD;
401: app_exception.raise_exception;
402: end if;
403: return;
404: end LOCK_ROW;
405:

Line 433: app_exception.raise_exception;

429: end if;
430: else
431: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
432: IGS_GE_MSG_STACK.ADD;
433: app_exception.raise_exception;
434: end if;
435: Before_DML (
436: p_action => 'UPDATE',
437: x_rowid => X_ROWID,