[Home] [Help]
36: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
37: Close cur_old_ref_values;
38: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
39: IGS_GE_MSG_STACK.ADD;
40: App_Exception.Raise_Exception;
41: Return;
42: END IF;
43: Close cur_old_ref_values;
44:
88: v_message_name) = FALSE THEN
89: --raise_application_error(-20000, IGS_GE_GEN_002.GENP_GET_MESSAGE(2029));
90: Fnd_Message.Set_Name('IGS','IGS_EN_PRSN_NOTHAVE_APP_GOVT');
91: IGS_GE_MSG_STACK.ADD;
92: App_Exception.Raise_Exception;
93: END IF;
94: -- Validate the calendar.
95: IF p_inserting OR
96: (p_updating AND
101: new_references.ci_sequence_number,
102: v_message_name) = FALSE THEN
103: Fnd_Message.Set_Name('IGS',v_message_name);
104: IGS_GE_MSG_STACK.ADD;
105: App_Exception.Raise_Exception;
106: END IF;
107: END IF;
108:
109:
131: IF upper(Column_name) = 'CAL_TYPE' OR COLUMN_NAME IS NULL THEN
132: IF new_references.CAL_TYPE<> upper(new_references.CAL_TYPE) then
133: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
134: IGS_GE_MSG_STACK.ADD;
135: App_Exception.Raise_Exception ;
136: END IF;
137:
138: END IF ;
139:
140: IF upper(Column_name) = 'CI_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
141: IF new_references.CI_SEQUENCE_NUMBER < 1 or new_references.CI_SEQUENCE_NUMBER > 999999 then
142: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
143: IGS_GE_MSG_STACK.ADD;
144: App_Exception.Raise_Exception ;
145: END IF;
146:
147: END IF ;
148:
149: IF upper(Column_name) = 'SUBMISSION_YR' OR COLUMN_NAME IS NULL THEN
150: IF new_references.SUBMISSION_YR < 0 or new_references.SUBMISSION_YR > 9999 then
151: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
152: IGS_GE_MSG_STACK.ADD;
153: App_Exception.Raise_Exception ;
154: END IF;
155:
156: END IF ;
157:
174: new_references.ci_sequence_number
175: ) THEN
176: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
177: IGS_GE_MSG_STACK.ADD;
178: App_Exception.Raise_Exception;
179: END IF;
180:
181: IF (((old_references.submission_yr = new_references.submission_yr) AND
182: (old_references.submission_number = new_references.submission_number) AND
192: new_references.govt_semester
193: ) THEN
194: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
195: IGS_GE_MSG_STACK.ADD;
196: App_Exception.Raise_Exception;
197: END IF;
198: END IF;
199: END IF;
200: END Check_Parent_Existance;
209: new_references.ci_sequence_number
210: ) THEN
211: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
212: IGS_GE_MSG_STACK.ADD;
213: App_Exception.Raise_Exception;
214: END IF;
215: End CHECK_UNIQUENESS ;
216:
217:
270: IF (cur_rowid%FOUND) THEN
271: Close cur_rowid;
272: Fnd_Message.Set_Name ('IGS', 'IGS_ST_GSLC_CI_FK');
273: IGS_GE_MSG_STACK.ADD;
274: App_Exception.Raise_Exception;
275: Return;
276: END IF;
277: Close cur_rowid;
278:
300: IF (cur_rowid%FOUND) THEN
301: Close cur_rowid;
302: Fnd_Message.Set_Name ('IGS', 'IGS_ST_GSLC_GSEM_FK');
303: IGS_GE_MSG_STACK.ADD;
304: App_Exception.Raise_Exception;
305: Return;
306: END IF;
307: Close cur_rowid;
308:
383: new_references.ci_sequence_number
384: ) THEN
385: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
386: IGS_GE_MSG_STACK.ADD;
387: App_Exception.Raise_Exception;
388: END IF;
389: Check_Uniqueness;
390: Check_Constraints;
391: Check_Parent_Existance;
407: new_references.ci_sequence_number
408: ) THEN
409: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
410: IGS_GE_MSG_STACK.ADD;
411: App_Exception.Raise_Exception;
412: END IF;
413: Check_Uniqueness;
414: Check_Constraints;
415: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
465: end if;
466: else
467: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
468: IGS_GE_MSG_STACK.ADD;
469: app_exception.raise_exception;
470: end if;
471: Before_DML (
472: p_action => 'INSERT',
473: x_rowid => X_ROWID,
540: if (c1%notfound) then
541: close c1;
542: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
543: IGS_GE_MSG_STACK.ADD;
544: app_exception.raise_exception;
545: return;
546: end if;
547: close c1;
548: