APPS.IGS_AS_GRD_SCHEMA_PKG dependencies on APP_EXCEPTION

Line 62: APP_EXCEPTION.RAISE_EXCEPTION;

58: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
59: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
60: IGS_GE_MSG_STACK.ADD;
61: CLOSE cur_old_ref_values;
62: APP_EXCEPTION.RAISE_EXCEPTION;
63: RETURN;
64: END IF;
65: CLOSE cur_old_ref_values;
66:

Line 126: APP_EXCEPTION.RAISE_EXCEPTION;

122: new_references.end_dt,
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: END IF;
129: END IF;
130:

Line 157: APP_EXCEPTION.RAISE_EXCEPTION;

153: new_references.end_dt,
154: v_message_name) = FALSE THEN
155: FND_MESSAGE.SET_NAME('IGS',v_message_name);
156: IGS_GE_MSG_STACK.ADD;
157: APP_EXCEPTION.RAISE_EXCEPTION;
158: END IF;
159:
160:
161: END IF;

Line 188: APP_EXCEPTION.RAISE_EXCEPTION;

184: IF (cur_rowid%FOUND) THEN
185: Fnd_Message.Set_Name ('IGS', 'IGS_AS_GS_LOV_FK');
186: IGS_GE_MSG_STACK.ADD;
187: CLOSE cur_rowid;
188: APP_EXCEPTION.RAISE_EXCEPTION;
189:
190: RETURN;
191: END IF;
192: CLOSE cur_rowid;

Line 385: APP_EXCEPTION.RAISE_EXCEPTION;

381: new_references.grading_schema_cd ,
382: new_references.version_number) THEN
383: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
384: IGS_GE_MSG_STACK.ADD;
385: APP_EXCEPTION.RAISE_EXCEPTION;
386: END IF;
387:
388: Check_Constraints;
389:

Line 405: APP_EXCEPTION.RAISE_EXCEPTION;

401: new_references.grading_schema_cd ,
402: new_references.version_number) THEN
403: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
404: IGS_GE_MSG_STACK.ADD;
405: APP_EXCEPTION.RAISE_EXCEPTION;
406: END IF;
407:
408: Check_Constraints;
409: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 495: APP_EXCEPTION.RAISE_EXCEPTION;

491: END IF;
492: ELSE
493: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
494: IGS_GE_MSG_STACK.ADD;
495: APP_EXCEPTION.RAISE_EXCEPTION;
496: END IF;
497: Before_DML(
498: p_action=>'INSERT',
499: x_rowid=>X_ROWID,

Line 685: APP_EXCEPTION.RAISE_EXCEPTION;

681: FETCH c1 INTO tlinfo;
682: IF (c1%NOTFOUND) THEN
683: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
684: IGS_GE_MSG_STACK.ADD;
685: APP_EXCEPTION.RAISE_EXCEPTION;
686: CLOSE c1;
687: RETURN;
688: END IF;
689: CLOSE c1;

Line 771: APP_EXCEPTION.RAISE_EXCEPTION;

767: NULL;
768: ELSE
769: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
770: IGS_GE_MSG_STACK.ADD;
771: APP_EXCEPTION.RAISE_EXCEPTION;
772: END IF;
773: RETURN;
774: END LOCK_ROW;
775:

Line 829: APP_EXCEPTION.RAISE_EXCEPTION;

825: END IF;
826: ELSE
827: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
828: IGS_GE_MSG_STACK.ADD;
829: APP_EXCEPTION.RAISE_EXCEPTION;
830: END IF;
831: Before_DML(
832: p_action=>'UPDATE',
833: x_rowid=>X_ROWID,

Line 1037: APP_EXCEPTION.RAISE_EXCEPTION;

1033: column_name IS NULL THEN
1034: IF new_references.GRADING_SCHEMA_CD <> UPPER(new_references.GRADING_SCHEMA_CD) THEN
1035: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
1036: IGS_GE_MSG_STACK.ADD;
1037: APP_EXCEPTION.RAISE_EXCEPTION;
1038: END IF;
1039: END IF;
1040: IF UPPER(column_name) = 'VERSION_NUMBER' OR
1041: column_name IS NULL THEN

Line 1045: APP_EXCEPTION.RAISE_EXCEPTION;

1041: column_name IS NULL THEN
1042: IF new_references.VERSION_NUMBER < 0 OR new_references.VERSION_NUMBER > 999 THEN
1043: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
1044: IGS_GE_MSG_STACK.ADD;
1045: APP_EXCEPTION.RAISE_EXCEPTION;
1046: END IF;
1047: END IF;
1048:
1049: END Check_Constraints;