DBA Data[Home] [Help]

APPS.IGS_ST_GVT_STDNT_LBL_PKG dependencies on APP_EXCEPTION

Line 56: App_Exception.Raise_Exception;

52: IF (cur_old_ref_values%NOTFOUND) AND p_action NOT IN ('INSERT','VALIDATE_INSERT') THEN
53: Close cur_old_ref_values;
54: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
55: IGS_GE_MSG_STACK.ADD;
56: App_Exception.Raise_Exception;
57: Return;
58: END IF;
59: Close cur_old_ref_values;
60:

Line 126: App_Exception.Raise_Exception;

122: v_transaction_type,
123: v_message_name) = FALSE THEN
124: Fnd_Message.Set_Name('IGS', v_message_name);
125: IGS_GE_MSG_STACK.ADD;
126: App_Exception.Raise_Exception;
127: END IF;
128:
129: END BeforeRowInsertUpdateDelete1;
130:

Line 159: App_Exception.Raise_Exception;

155: IF upper(Column_Name) = 'TOTAL_EFTSU' OR Column_Name IS NULL THEN
156: IF new_references.total_eftsu < 0000.000 OR new_references.total_eftsu > 9999.999 THEN
157: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
158: IGS_GE_MSG_STACK.ADD;
159: App_Exception.Raise_Exception;
160: END IF;
161: END IF;
162: IF upper(Column_Name) = 'HECS_PREXMT_EXIE' OR Column_Name IS NULL THEN
163: IF new_references.hecs_prexmt_exie < 0000 OR new_references.hecs_prexmt_exie > 9999 THEN

Line 166: App_Exception.Raise_Exception;

162: IF upper(Column_Name) = 'HECS_PREXMT_EXIE' OR Column_Name IS NULL THEN
163: IF new_references.hecs_prexmt_exie < 0000 OR new_references.hecs_prexmt_exie > 9999 THEN
164: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
165: IGS_GE_MSG_STACK.ADD;
166: App_Exception.Raise_Exception;
167: END IF;
168: END IF;
169:
170: IF upper(Column_Name) = 'TUITION_FEE' OR Column_Name IS NULL THEN

Line 174: App_Exception.Raise_Exception;

170: IF upper(Column_Name) = 'TUITION_FEE' OR Column_Name IS NULL THEN
171: IF new_references.tuition_fee < 00000 OR new_references.tuition_fee > 99999 THEN
172: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
173: IGS_GE_MSG_STACK.ADD;
174: App_Exception.Raise_Exception;
175: END IF;
176: END IF;
177: IF upper(Column_Name) = 'HECS_AMOUNT_PAID' OR Column_Name IS NULL THEN
178: IF new_references.hecs_amount_paid < 0000 OR new_references.hecs_amount_paid > 9999 THEN

Line 181: App_Exception.Raise_Exception;

177: IF upper(Column_Name) = 'HECS_AMOUNT_PAID' OR Column_Name IS NULL THEN
178: IF new_references.hecs_amount_paid < 0000 OR new_references.hecs_amount_paid > 9999 THEN
179: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
180: IGS_GE_MSG_STACK.ADD;
181: App_Exception.Raise_Exception;
182: END IF;
183: END IF;
184: IF upper(Column_Name) = 'INDUSTRIAL_EFTSU' OR Column_Name IS NULL THEN
185: IF new_references.industrial_eftsu < 0000.000 OR new_references.industrial_eftsu > 9999.999 THEN

Line 188: App_Exception.Raise_Exception;

184: IF upper(Column_Name) = 'INDUSTRIAL_EFTSU' OR Column_Name IS NULL THEN
185: IF new_references.industrial_eftsu < 0000.000 OR new_references.industrial_eftsu > 9999.999 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: END IF;
191: IF upper(Column_Name) = 'SUBMISSION_YR' OR Column_Name IS NULL THEN
192: IF new_references.submission_yr < 0000 OR new_references.submission_yr > 9999 THEN

Line 195: App_Exception.Raise_Exception;

191: IF upper(Column_Name) = 'SUBMISSION_YR' OR Column_Name IS NULL THEN
192: IF new_references.submission_yr < 0000 OR new_references.submission_yr > 9999 THEN
193: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
194: IGS_GE_MSG_STACK.ADD;
195: App_Exception.Raise_Exception;
196: END IF;
197: END IF;
198: IF upper(Column_Name) = 'DIFFERENTIAL_HECS_IND' OR Column_Name IS NULL THEN
199: IF new_references.differential_hecs_ind NOT IN ('Y','N') THEN

Line 202: App_Exception.Raise_Exception;

198: IF upper(Column_Name) = 'DIFFERENTIAL_HECS_IND' OR Column_Name IS NULL THEN
199: IF new_references.differential_hecs_ind NOT IN ('Y','N') THEN
200: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
201: IGS_GE_MSG_STACK.ADD;
202: App_Exception.Raise_Exception;
203: END IF;
204: END IF;
205:
206: END Check_Constraints;

Line 226: App_Exception.Raise_Exception;

222: new_references.govt_semester
223: ) THEN
224: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
225: IGS_GE_MSG_STACK.ADD;
226: App_Exception.Raise_Exception;
227: END IF;
228: END IF;
229:
230: END Check_Parent_Existance;

Line 289: App_Exception.Raise_Exception;

285: IF (cur_rowid%FOUND) THEN
286: Close cur_rowid;
287: Fnd_Message.Set_Name ('IGS', 'IGS_ST_GSLI_GSEM_FK');
288: IGS_GE_MSG_STACK.ADD;
289: App_Exception.Raise_Exception;
290: Return;
291: END IF;
292: Close cur_rowid;
293:

Line 370: App_Exception.Raise_Exception;

366: new_references.govt_semester
367: ) THEN
368: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
369: IGS_GE_MSG_STACK.ADD;
370: App_Exception.Raise_Exception;
371: END IF;
372: Check_Constraints;
373: Check_Parent_Existance;
374: ELSIF (p_action = 'UPDATE') THEN

Line 390: App_Exception.Raise_Exception;

386: new_references.govt_semester
387: ) THEN
388: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
389: IGS_GE_MSG_STACK.ADD;
390: App_Exception.Raise_Exception;
391: END IF;
392: Check_Constraints;
393: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
394: Check_Constraints;

Line 476: app_exception.raise_exception;

472: end if;
473: else
474: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
475: IGS_GE_MSG_STACK.ADD;
476: app_exception.raise_exception;
477: end if;
478: Before_DML (
479: p_action => 'INSERT',
480: x_rowid => X_ROWID,

Line 639: app_exception.raise_exception;

635: if (c1%notfound) then
636: close c1;
637: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
638: IGS_GE_MSG_STACK.ADD;
639: app_exception.raise_exception;
640: return;
641: end if;
642: close c1;
643:

Line 667: app_exception.raise_exception;

663: null;
664: else
665: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
666: IGS_GE_MSG_STACK.ADD;
667: app_exception.raise_exception;
668: end if;
669: return;
670: end LOCK_ROW;
671:

Line 722: app_exception.raise_exception;

718: end if;
719: else
720: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
721: IGS_GE_MSG_STACK.ADD;
722: app_exception.raise_exception;
723: end if;
724: Before_DML (
725: p_action => 'UPDATE',
726: x_rowid => X_ROWID,