[Home] [Help]
33: -- Populate Old Values.
34: Open cur_old_ref_values;
35: Fetch cur_old_ref_values INTO old_references;
36: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
37: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
38: IGS_GE_MSG_STACK.ADD;
39: App_Exception.Raise_Exception;
40: Close cur_old_ref_values;
41: Return;
73: (old_references.closed_ind = 'Y' AND new_references.closed_ind = 'N')) THEN
74: IF IGS_AD_VAL_ASES.admp_val_ssst_closed(
75: new_references.s_scndry_school_type,
76: v_message_name) = FALSE THEN
77: Fnd_Message.Set_Name('IGS',v_message_name);
78: IGS_GE_MSG_STACK.ADD;
79: App_Exception.Raise_Exception;
80: END IF;
81: END IF;
102: END IF;
103:
104: IF upper(Column_Name) = 'STATE_CD' OR Column_Name IS NULL THEN
105: IF new_references.state_cd <> UPPER(new_references.state_cd) THEN
106: Fnd_Message.Set_Name('IGS','IGS_INVALID_VALUE');
107: IGS_GE_MSG_STACK.ADD;
108: App_Exception.Raise_Exception;
109: END IF;
110: END IF;
109: END IF;
110: END IF;
111: IF upper(Column_Name) = 'S_SCNDRY_SCHOOL_TYPE' OR Column_Name IS NULL THEN
112: IF new_references.s_scndry_school_type <> UPPER(new_references.s_scndry_school_type) THEN
113: Fnd_Message.Set_Name('IGS','IGS_INVALID_VALUE');
114: IGS_GE_MSG_STACK.ADD;
115: App_Exception.Raise_Exception;
116: END IF;
117: END IF;
116: END IF;
117: END IF;
118: IF upper(Column_Name) = 'CLOSED_IND' OR Column_Name IS NULL THEN
119: IF new_references.closed_ind NOT IN ('Y','N') THEN
120: Fnd_Message.Set_Name('IGS','IGS_INVALID_VALUE');
121: IGS_GE_MSG_STACK.ADD;
122: App_Exception.Raise_Exception;
123: END IF;
124: END IF;
134: IF NOT IGS_LOOKUPS_VIEW_PKG.Get_PK_For_Validation(
135: 'SCNDRY_SCHOOL_TYPE',
136: new_references.s_scndry_school_type
137: ) THEN
138: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
139: IGS_GE_MSG_STACK.ADD;
140: App_Exception.Raise_Exception;
141: END IF;
142: END IF;
197: Open cur_rowid;
198: Fetch cur_rowid INTO lv_rowid;
199: IF (cur_rowid%FOUND) THEN
200: Close cur_rowid;
201: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ASES_SLV_FK');
202: IGS_GE_MSG_STACK.ADD;
203: App_Exception.Raise_Exception;
204: Return;
205: END IF;
242: BeforeRowInsertUpdate1 ( p_inserting => TRUE );
243: IF Get_PK_For_Validation (
244: new_references.secondary_school_cd
245: ) THEN
246: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
247: IGS_GE_MSG_STACK.ADD;
248: App_Exception.Raise_Exception;
249: END IF;
250: Check_Constraints;
258: ELSIF (p_action = 'VALIDATE_INSERT') THEN
259: IF Get_PK_For_Validation (
260: new_references.secondary_school_cd
261: ) THEN
262: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
263: IGS_GE_MSG_STACK.ADD;
264: App_Exception.Raise_Exception;
265: END IF;
266: Check_Constraints;
310: if X_LAST_UPDATE_LOGIN is NULL then
311: X_LAST_UPDATE_LOGIN := -1;
312: end if;
313: else
314: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
315: IGS_GE_MSG_STACK.ADD;
316: app_exception.raise_exception;
317: end if;
318:
389: begin
390: open c1;
391: fetch c1 into tlinfo;
392: if (c1%notfound) then
393: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
394: IGS_GE_MSG_STACK.ADD;
395: app_exception.raise_exception;
396: close c1;
397: return;
406: AND (tlinfo.CLOSED_IND = X_CLOSED_IND)
407: ) then
408: null;
409: else
410: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
411: IGS_GE_MSG_STACK.ADD;
412: app_exception.raise_exception;
413: end if;
414: return;
440: if X_LAST_UPDATE_LOGIN is NULL then
441: X_LAST_UPDATE_LOGIN := -1;
442: end if;
443: else
444: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
445: IGS_GE_MSG_STACK.ADD;
446: app_exception.raise_exception;
447: end if;
448: