[Home] [Help]
35: IF (cur_old_ref_values%NOTFOUND) AND p_action NOT IN ('INSERT','VALIDATE_INSERT') THEN
36: Close cur_old_ref_values;
37: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
38: IGS_GE_MSG_STACK.ADD;
39: App_Exception.Raise_Exception;
40: Return;
41: END IF;
42: Close cur_old_ref_values;
43:
73: new_references.tac_level_of_qual,
74: v_message_name) = FALSE THEN
75: Fnd_Message.Set_Name('IGS', v_message_name);
76: IGS_GE_MSG_STACK.ADD;
77: App_Exception.Raise_Exception;
78: END IF;
79: END IF;
80:
81:
100: IF upper(Column_Name) = 'CLOSED_IND' OR Column_Name IS NULL THEN
101: IF new_references.closed_ind NOT IN ('Y','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: IF upper(Column_Name) = 'TAC_LEVEL_OF_QUAL' OR Column_Name IS NULL THEN
108: IF new_references.tac_level_of_qual <> UPPER(new_references.tac_level_of_qual) THEN
107: IF upper(Column_Name) = 'TAC_LEVEL_OF_QUAL' OR Column_Name IS NULL THEN
108: IF new_references.tac_level_of_qual <> UPPER(new_references.tac_level_of_qual) THEN
109: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
110: IGS_GE_MSG_STACK.ADD;
111: App_Exception.Raise_Exception;
112: END IF;
113: END IF;
114: IF upper(Column_Name) = 'TERTIARY_EDU_LVL_QUAL' OR Column_Name IS NULL THEN
115: IF new_references.tertiary_edu_lvl_qual <> UPPER(new_references.tertiary_edu_lvl_qual) THEN
114: IF upper(Column_Name) = 'TERTIARY_EDU_LVL_QUAL' OR Column_Name IS NULL THEN
115: IF new_references.tertiary_edu_lvl_qual <> UPPER(new_references.tertiary_edu_lvl_qual) THEN
116: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
117: IGS_GE_MSG_STACK.ADD;
118: App_Exception.Raise_Exception;
119: END IF;
120: END IF;
121:
122: END Check_Constraints;
132: new_references.tac_level_of_qual ,
133: 'N') THEN
134: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
135: IGS_GE_MSG_STACK.ADD;
136: App_Exception.Raise_Exception;
137: END IF;
138: END IF;
139:
140: END Check_Parent_Existance;
194: IF (cur_rowid%FOUND) THEN
195: Close cur_rowid;
196: Fnd_Message.Set_Name ('IGS', 'IGS_AD_TELOQ_TLOQ_FK');
197: IGS_GE_MSG_STACK.ADD;
198: App_Exception.Raise_Exception;
199: Return;
200: END IF;
201: Close cur_rowid;
202:
237: new_references.tertiary_edu_lvl_qual
238: ) THEN
239: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
240: IGS_GE_MSG_STACK.ADD;
241: App_Exception.Raise_Exception;
242: END IF;
243: Check_Constraints;
244: Check_Parent_Existance;
245: ELSIF (p_action = 'UPDATE') THEN
254: new_references.tertiary_edu_lvl_qual
255: ) THEN
256: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
257: IGS_GE_MSG_STACK.ADD;
258: App_Exception.Raise_Exception;
259: END IF;
260: Check_Constraints;
261: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
262: Check_Constraints;
303: end if;
304: else
305: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
306: IGS_GE_MSG_STACK.ADD;
307: app_exception.raise_exception;
308: end if;
309: Before_DML (
310: p_action => 'INSERT',
311: x_rowid => X_ROWID,
376: if (c1%notfound) then
377: close c1;
378: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
379: IGS_GE_MSG_STACK.ADD;
380: app_exception.raise_exception;
381: return;
382: end if;
383: close c1;
384:
391: null;
392: else
393: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
394: IGS_GE_MSG_STACK.ADD;
395: app_exception.raise_exception;
396: end if;
397: return;
398: end LOCK_ROW;
399:
424: end if;
425: else
426: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
427: IGS_GE_MSG_STACK.ADD;
428: app_exception.raise_exception;
429: end if;
430: Before_DML (
431: p_action => 'UPDATE',
432: x_rowid => X_ROWID,