[Home] [Help]
36: Open cur_old_ref_values;
37: Fetch cur_old_ref_values INTO old_references;
38: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
39: Close cur_old_ref_values;
40: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
41: IGS_GE_MSG_STACK.ADD;
42: App_Exception.Raise_Exception;
43: Return;
44: END IF;
83: END IF;
84:
85: IF upper(column_name) = 'CLOSED_IND' OR COLUMN_NAME IS NULL THEN
86: IF new_references.closed_ind <> upper(NEW_REFERENCES.closed_ind) OR new_references.closed_ind NOT IN ('Y', 'N') THEN
87: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
88: IGS_GE_MSG_STACK.ADD;
89: App_Exception.Raise_Exception ;
90: END IF;
91: END IF;
90: END IF;
91: END IF;
92: IF upper(column_name) = 'SCHOLARSHIP_TYPE' OR COLUMN_NAME IS NULL THEN
93: IF new_references.SCHOLARSHIP_TYPE <> upper(NEW_REFERENCES.SCHOLARSHIP_TYPE) THEN
94: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
95: IGS_GE_MSG_STACK.ADD;
96: App_Exception.Raise_Exception ;
97: END IF;
98: END IF;
97: END IF;
98: END IF;
99: IF upper(column_name) = 'PERSON_ID_FROM' OR COLUMN_NAME IS NULL THEN
100: IF new_references.PERSON_ID_FROM < 1 OR new_references.PERSON_ID_FROM > 9999999999 THEN
101: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
102: IGS_GE_MSG_STACK.ADD;
103: App_Exception.Raise_Exception ;
104: END IF;
105: END IF;
118: IF NOT IGS_OR_UNIT_PKG.Get_PK_For_Validation (
119: new_references.org_unit_cd_from,
120: new_references.ou_start_dt_from
121: ) THEN
122: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
123: IGS_GE_MSG_STACK.ADD;
124: App_Exception.Raise_Exception;
125: END IF;
126: END IF;
131: ELSE
132: IF NOT IGS_PE_PERSON_PKG.Get_PK_For_Validation (
133: new_references.person_id_from
134: ) THEN
135: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
136: IGS_GE_MSG_STACK.ADD;
137: App_Exception.Raise_Exception;
138: END IF;
139: END IF;
193: Open cur_rowid;
194: Fetch cur_rowid INTO lv_rowid;
195: IF (cur_rowid%FOUND) THEN
196: Close cur_rowid;
197: Fnd_Message.Set_Name ('IGS', 'IGS_RE_SCT_OU_FK');
198: IGS_GE_MSG_STACK.ADD;
199: App_Exception.Raise_Exception;
200: Return;
201: END IF;
219: Open cur_rowid;
220: Fetch cur_rowid INTO lv_rowid;
221: IF (cur_rowid%FOUND) THEN
222: Close cur_rowid;
223: Fnd_Message.Set_Name ('IGS', 'IGS_RE_SCT_PE_FK');
224: IGS_GE_MSG_STACK.ADD;
225: App_Exception.Raise_Exception;
226: Return;
227: END IF;
268: IF Get_PK_For_Validation (
269: new_references.scholarship_type
270: ) THEN
271:
272: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
273: IGS_GE_MSG_STACK.ADD;
274: App_Exception.Raise_Exception;
275: END IF;
276: Check_Constraints;
285: ELSIF (p_action = 'VALIDATE_INSERT') THEN
286: IF Get_PK_For_Validation (
287: new_references.scholarship_type
288: ) THEN
289: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
290: IGS_GE_MSG_STACK.ADD;
291: App_Exception.Raise_Exception;
292: END IF;
293: Check_Constraints;
328: if X_LAST_UPDATE_LOGIN is NULL then
329: X_LAST_UPDATE_LOGIN := -1;
330: end if;
331: else
332: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
333: IGS_GE_MSG_STACK.ADD;
334: app_exception.raise_exception;
335: end if;
336:
413: open c1;
414: fetch c1 into tlinfo;
415: if (c1%notfound) then
416: close c1;
417: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
418: app_exception.raise_exception;
419: return;
420: end if;
421: close c1;
435:
436: ) then
437: null;
438: else
439: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
440: app_exception.raise_exception;
441: end if;
442: return;
443: end LOCK_ROW;
469: if X_LAST_UPDATE_LOGIN is NULL then
470: X_LAST_UPDATE_LOGIN := -1;
471: end if;
472: else
473: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
474: IGS_GE_MSG_STACK.ADD;
475: app_exception.raise_exception;
476: end if;
477: