APPS.IGS_AD_NOTE_TYPES_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 102: App_Exception.Raise_Exception;

98: IF Upper(Column_Name) = 'CLOSED_IND' OR Column_Name IS NULL THEN
99: IF new_references.closed_ind NOT IN ('Y','N') THEN
100: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
101: IGS_GE_MSG_STACK.ADD;
102: App_Exception.Raise_Exception;
103: END IF;
104: END IF;
105:
106: IF upper(Column_Name) = 'NOTE_TYPE' OR Column_Name IS NULL THEN

Line 110: App_Exception.Raise_Exception;

106: IF upper(Column_Name) = 'NOTE_TYPE' OR Column_Name IS NULL THEN
107: IF new_references.note_type <> UPPER(new_references.note_type) THEN
108: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
109: IGS_GE_MSG_STACK.ADD;
110: App_Exception.Raise_Exception;
111: END IF;
112: END IF;
113:
114: END Check_Constraints;

Line 134: app_exception.raise_exception;

130: new_references.note_type
131: ) THEN
132: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
133: IGS_GE_MSG_STACK.ADD;
134: app_exception.raise_exception;
135: END IF;
136: END Check_Uniqueness ;
137:
138: PROCEDURE Check_Parent_Existance IS

Line 155: App_Exception.Raise_Exception;

151: new_references.NOTES_CATEGORY
152: ) THEN
153: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
154: IGS_GE_MSG_STACK.ADD;
155: App_Exception.Raise_Exception;
156: END IF;
157: END Check_Parent_existance;
158:
159: PROCEDURE Check_Child_Existance IS

Line 326: App_Exception.Raise_Exception;

322: -- Call all the procedures related to Before Insert.
323: IF Get_Pk_For_Validation(new_references.notes_type_id) THEN
324: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
325: IGS_GE_MSG_STACK.ADD;
326: App_Exception.Raise_Exception;
327: END IF;
328: Check_Uniqueness;
329: Check_Constraints;
330: ELSIF (p_action = 'UPDATE') THEN

Line 342: App_Exception.Raise_Exception;

338: -- Call all the procedures related to Before Insert.
339: IF Get_PK_For_Validation (new_references.notes_type_id) THEN
340: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
341: IGS_GE_MSG_STACK.ADD;
342: App_Exception.Raise_Exception;
343: END IF;
344: Check_Uniqueness;
345: Check_Constraints;
346: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 399: app_exception.raise_exception;

395: end if;
396: else
397: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
398: IGS_GE_MSG_STACK.ADD;
399: app_exception.raise_exception;
400: end if;
401:
402: X_NOTES_TYPE_ID := -1;
403: Before_DML(

Line 482: app_exception.raise_exception;

478: if (c1%notfound) then
479: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
480: IGS_GE_MSG_STACK.ADD;
481: close c1;
482: app_exception.raise_exception;
483: return;
484: end if;
485: close c1;
486: if ( ( tlinfo.NOTES_CATEGORY = X_NOTES_CATEGORY)

Line 495: app_exception.raise_exception;

491: null;
492: else
493: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
494: IGS_GE_MSG_STACK.ADD;
495: app_exception.raise_exception;
496: end if;
497: return;
498: end LOCK_ROW;
499:

Line 541: app_exception.raise_exception;

537: end if;
538: else
539: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
540: IGS_GE_MSG_STACK.ADD;
541: app_exception.raise_exception;
542: end if;
543: Before_DML(
544: p_action=>'UPDATE',
545: x_rowid=>X_ROWID,