APPS.IGS_PS_UNIT_GRD_SCHM_PKG dependencies on APP_EXCEPTION

Line 51: App_Exception.Raise_Exception;

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

Line 103: app_exception.raise_exception;

99: IF UPPER( column_name )='DEFAULT_FLAG' OR column_name IS NULL THEN
100: IF new_references.default_flag NOT IN ( 'Y', 'N' ) THEN
101: fnd_message.set_name ( 'IGS', 'IGS_GE_INVALID_VALUE' );
102: IGS_GE_MSG_STACK.ADD;
103: app_exception.raise_exception;
104: END IF;
105: END IF;
106:
107: END Check_Constraints;

Line 130: app_exception.raise_exception;

126: ,new_references.unit_code
127: ) THEN
128: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
129: IGS_GE_MSG_STACK.ADD;
130: app_exception.raise_exception;
131: END IF;
132: END Check_Uniqueness ;
133:
134: PROCEDURE Check_Parent_Existance AS

Line 159: App_Exception.Raise_Exception;

155: new_references.unit_version_number
156: ) THEN
157: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
158: IGS_GE_MSG_STACK.ADD;
159: App_Exception.Raise_Exception;
160: END IF;
161:
162: IF (((old_references.grading_schema_code = new_references.grading_schema_code) AND
163: (old_references.grd_schm_version_number = new_references.grd_schm_version_number)) OR

Line 173: App_Exception.Raise_Exception;

169: new_references.grd_schm_version_number
170: ) THEN
171: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
172: IGS_GE_MSG_STACK.ADD;
173: App_Exception.Raise_Exception;
174: END IF;
175:
176: END Check_Parent_Existance;
177:

Line 300: App_Exception.Raise_Exception;

296: IF (cur_rowid%FOUND) THEN
297: Close cur_rowid;
298: Fnd_Message.Set_Name ('IGS', 'IGS_PS_UGS_UV_FK');
299: IGS_GE_MSG_STACK.ADD;
300: App_Exception.Raise_Exception;
301: Return;
302: END IF;
303: Close cur_rowid;
304:

Line 339: App_Exception.Raise_Exception;

335: IF (cur_rowid%FOUND) THEN
336: Close cur_rowid;
337: Fnd_Message.Set_Name ('IGS', 'IGS_PS_UGS_GS_FK');
338: IGS_GE_MSG_STACK.ADD;
339: App_Exception.Raise_Exception;
340: Return;
341: END IF;
342: Close cur_rowid;
343:

Line 397: App_Exception.Raise_Exception;

393: IF Get_Pk_For_Validation(
394: new_references.unit_grading_schema_id) THEN
395: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
396: IGS_GE_MSG_STACK.ADD;
397: App_Exception.Raise_Exception;
398: END IF;
399: Check_Uniqueness;
400: Check_Constraints;
401: Check_Parent_Existance;

Line 416: App_Exception.Raise_Exception;

412: IF Get_PK_For_Validation (
413: new_references.unit_grading_schema_id) THEN
414: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
415: IGS_GE_MSG_STACK.ADD;
416: App_Exception.Raise_Exception;
417: END IF;
418: Check_Uniqueness;
419: Check_Constraints;
420: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 505: app_exception.raise_exception;

501: end if;
502: else
503: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
504: IGS_GE_MSG_STACK.ADD;
505: app_exception.raise_exception;
506: end if;
507: select igs_ps_unit_grd_schm_s.nextval
508: into x_unit_grading_schema_id
509: from dual;

Line 596: app_exception.raise_exception;

592: if (c1%notfound) then
593: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
594: IGS_GE_MSG_STACK.ADD;
595: close c1;
596: app_exception.raise_exception;
597: return;
598: end if;
599: close c1;
600: if ( ( tlinfo.UNIT_CODE = X_UNIT_CODE)

Line 610: app_exception.raise_exception;

606: null;
607: else
608: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
609: IGS_GE_MSG_STACK.ADD;
610: app_exception.raise_exception;
611: end if;
612: return;
613: end LOCK_ROW;
614: Procedure UPDATE_ROW (

Line 655: app_exception.raise_exception;

651: end if;
652: else
653: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
654: IGS_GE_MSG_STACK.ADD;
655: app_exception.raise_exception;
656: end if;
657: Before_DML(
658: p_action=>'UPDATE',
659: x_rowid=>X_ROWID,