DBA Data[Home] [Help]

APPS.IGS_AD_ADM_UT_STA_GD_PKG dependencies on APP_EXCEPTION

Line 38: App_Exception.Raise_Exception;

34: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
35: Close cur_old_ref_values;
36: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
37: IGS_GE_MSG_STACK.ADD;
38: App_Exception.Raise_Exception;
39: Return;
40: END IF;
41: Close cur_old_ref_values;
42:

Line 74: App_Exception.Raise_Exception;

70: IF IGS_EN_VAL_UDDC.ENRP_VAL_AUS_CLOSED(new_references.administrative_unit_status
71: ,v_message_name) = FALSE THEN
72: Fnd_Message.Set_Name('IGS',v_message_name);
73: IGS_GE_MSG_STACK.ADD;
74: App_Exception.Raise_Exception;
75: END IF;
76: IF IGS_EN_VAL_UDDC.ENRP_VAL_AUS_DISCONT(new_references.administrative_unit_status
77: ,v_message_name) = FALSE THEN
78: Fnd_Message.Set_Name('IGS',v_message_name);

Line 80: App_Exception.Raise_Exception;

76: IF IGS_EN_VAL_UDDC.ENRP_VAL_AUS_DISCONT(new_references.administrative_unit_status
77: ,v_message_name) = FALSE THEN
78: Fnd_Message.Set_Name('IGS',v_message_name);
79: IGS_GE_MSG_STACK.ADD;
80: App_Exception.Raise_Exception;
81: END IF;
82: IF IGS_EN_VAL_AUSG.ENRP_VAL_AUSG_GS(new_references.grading_schema_cd
83: ,new_references.version_number
84: ,v_message_name) = FALSE THEN

Line 87: App_Exception.Raise_Exception;

83: ,new_references.version_number
84: ,v_message_name) = FALSE THEN
85: Fnd_Message.Set_Name('IGS',v_message_name);
86: IGS_GE_MSG_STACK.ADD;
87: App_Exception.Raise_Exception;
88: END IF;
89: END IF;
90:
91: END BeforeRowInsertUpdate1;

Line 104: App_Exception.Raise_Exception;

100: ELSE
101: IF NOT IGS_AD_ADM_UNIT_STAT_PKG.Get_PK_For_Validation (new_references.administrative_unit_status,'N') THEN
102: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
103: IGS_GE_MSG_STACK.ADD;
104: App_Exception.Raise_Exception;
105: END IF;
106: END IF;
107:
108: IF (((old_references.grading_schema_cd = new_references.grading_schema_cd) AND

Line 122: App_Exception.Raise_Exception;

118: new_references.version_number,
119: new_references.grade ) THEN
120: Fnd_Message.Set_Name ('IGS','IGS_GE_INVALID_VALUE');
121: IGS_GE_MSG_STACK.ADD;
122: App_Exception.Raise_Exception;
123: END IF;
124: END IF;
125:
126: END Check_Parent_Existance;

Line 152: App_Exception.Raise_Exception;

148: IF new_references.version_number < 0 OR
149: new_references.version_number > 999 THEN
150: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
151: IGS_GE_MSG_STACK.ADD;
152: App_Exception.Raise_Exception;
153: END IF;
154: END IF;
155: IF upper(Column_Name) = 'ADMINISTRATIVE_UNIT_STATUS' OR
156: Column_name IS NULL THEN

Line 160: App_Exception.Raise_Exception;

156: Column_name IS NULL THEN
157: IF new_references.administrative_unit_status <> upper(new_references.administrative_unit_status) THEN
158: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
159: IGS_GE_MSG_STACK.ADD;
160: App_Exception.Raise_Exception;
161: END IF;
162: END IF;
163: IF upper(Column_Name) = 'GRADE' OR
164: Column_name IS NULL THEN

Line 168: App_Exception.Raise_Exception;

164: Column_name IS NULL THEN
165: IF new_references.grade <> upper(new_references.grade) THEN
166: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
167: IGS_GE_MSG_STACK.ADD;
168: App_Exception.Raise_Exception;
169: END IF;
170: END IF;
171: IF upper(Column_Name) = 'GRADING_SCHEMA_CD' OR
172: Column_name IS NULL THEN

Line 176: App_Exception.Raise_Exception;

172: Column_name IS NULL THEN
173: IF new_references.grading_schema_cd <> upper(new_references.grading_schema_cd ) THEN
174: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
175: IGS_GE_MSG_STACK.ADD;
176: App_Exception.Raise_Exception;
177: END IF;
178: END IF;
179:
180: END Check_Constraints;

Line 236: App_Exception.Raise_Exception;

232: IF (cur_rowid%FOUND) THEN
233: Close cur_rowid;
234: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AUSG_GSG_FK');
235: IGS_GE_MSG_STACK.ADD;
236: App_Exception.Raise_Exception;
237: Return;
238: END IF;
239: Close cur_rowid;
240:

Line 283: App_Exception.Raise_Exception;

279: new_references.grade ) THEN
280:
281: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
282: IGS_GE_MSG_STACK.ADD;
283: App_Exception.Raise_Exception;
284: END IF;
285: Check_Constraints;
286: Check_Parent_Existance;
287:

Line 306: App_Exception.Raise_Exception;

302: new_references.grade ) THEN
303:
304: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
305: IGS_GE_MSG_STACK.ADD;
306: App_Exception.Raise_Exception;
307: END IF;
308: Check_Constraints;
309: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
310: Check_Constraints;

Line 358: app_exception.raise_exception;

354: end if;
355: else
356: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
357: IGS_GE_MSG_STACK.ADD;
358: app_exception.raise_exception;
359: end if;
360:
361: Before_DML (
362: p_action => 'INSERT',

Line 430: app_exception.raise_exception;

426: if (c1%notfound) then
427: close c1;
428: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
429: IGS_GE_MSG_STACK.ADD;
430: app_exception.raise_exception;
431: return;
432: end if;
433: close c1;
434: