APPS.IGS_PS_USEC_PRV_GRAD_PKG dependencies on APP_EXCEPTION

Line 50: App_Exception.Raise_Exception;

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

Line 121: app_exception.raise_exception;

117: ,new_references.grading_schema_code
118: ) THEN
119: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
120: IGS_GE_MSG_STACK.ADD;
121: app_exception.raise_exception;
122: END IF;
123: END Check_Uniqueness ;
124: PROCEDURE Check_Parent_Existance AS
125: /*************************************************************

Line 146: App_Exception.Raise_Exception;

142: new_references.uoo_id
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:
149: IF (((old_references.grading_schema_code = new_references.grading_schema_code) AND
150: (old_references.grading_schema_version_number = new_references.grading_schema_version_number) AND

Line 163: App_Exception.Raise_Exception;

159: new_references.grading_schema_value
160: ) THEN
161: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
162: IGS_GE_MSG_STACK.ADD;
163: App_Exception.Raise_Exception;
164: END IF;
165:
166: END Check_Parent_Existance;
167:

Line 275: App_Exception.Raise_Exception;

271: IF (cur_rowid%FOUND) THEN
272: Close cur_rowid;
273: Fnd_Message.Set_Name ('IGS', 'IGS_PS_USPG_UOO_FK');
274: IGS_GE_MSG_STACK.ADD;
275: App_Exception.Raise_Exception;
276: Return;
277: END IF;
278: Close cur_rowid;
279:

Line 316: App_Exception.Raise_Exception;

312: IF (cur_rowid%FOUND) THEN
313: Close cur_rowid;
314: Fnd_Message.Set_Name ('IGS', 'IGS_PS_USPG_GSG_FK');
315: IGS_GE_MSG_STACK.ADD;
316: App_Exception.Raise_Exception;
317: Return;
318: END IF;
319: Close cur_rowid;
320:

Line 372: App_Exception.Raise_Exception;

368: IF Get_Pk_For_Validation(
369: new_references.unit_section_prev_grade_id) THEN
370: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
371: IGS_GE_MSG_STACK.ADD;
372: App_Exception.Raise_Exception;
373: END IF;
374: Check_Uniqueness;
375: Check_Constraints;
376: Check_Parent_Existance;

Line 392: App_Exception.Raise_Exception;

388: IF Get_PK_For_Validation (
389: new_references.unit_section_prev_grade_id) THEN
390: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
391: IGS_GE_MSG_STACK.ADD;
392: App_Exception.Raise_Exception;
393: END IF;
394: Check_Uniqueness;
395: Check_Constraints;
396: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 480: app_exception.raise_exception;

476: end if;
477: else
478: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
479: IGS_GE_MSG_STACK.ADD;
480: app_exception.raise_exception;
481: end if;
482: select igs_ps_usec_prv_grad_s.nextval into x_unit_section_prev_grade_id from dual;
483: Before_DML(
484: p_action=>'INSERT',

Line 564: app_exception.raise_exception;

560: if (c1%notfound) then
561: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
562: IGS_GE_MSG_STACK.ADD;
563: close c1;
564: app_exception.raise_exception;
565: return;
566: end if;
567: close c1;
568: if ( ( tlinfo.UOO_ID = X_UOO_ID)

Line 577: app_exception.raise_exception;

573: null;
574: else
575: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
576: IGS_GE_MSG_STACK.ADD;
577: app_exception.raise_exception;
578: end if;
579: return;
580: end LOCK_ROW;
581: Procedure UPDATE_ROW (

Line 621: app_exception.raise_exception;

617: end if;
618: else
619: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
620: IGS_GE_MSG_STACK.ADD;
621: app_exception.raise_exception;
622: end if;
623: Before_DML(
624: p_action=>'UPDATE',
625: x_rowid=>X_ROWID,