[Home] [Help]
46: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
47: Close cur_old_ref_values;
48: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
49: IGS_GE_MSG_STACK.ADD;
50: App_Exception.Raise_Exception;
51: Return;
52: END IF;
53: Close cur_old_ref_values;
54:
100: v_message_name,
101: new_references.uoo_id) = FALSE THEN
102: Fnd_Message.Set_Name('IGS', v_message_name);
103: IGS_GE_MSG_STACK.ADD;
104: App_Exception.Raise_Exception;
105: END IF;
106: END IF;
107: --Delete validation
108: IF p_deleting THEN
115: v_message_name,
116: old_references.uoo_id) = FALSE THEN
117: Fnd_Message.Set_Name('IGS', v_message_name);
118: IGS_GE_MSG_STACK.ADD;
119: App_Exception.Raise_Exception;
120: END IF;
121: END IF;
122: END IF;
123:
147: column_name is null Then
148: IF new_references.course_cd <> UPPER(new_references.course_cd) Then
149: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
150: IGS_GE_MSG_STACK.ADD;
151: App_Exception.Raise_Exception;
152: END IF;
153: END IF;
154:
155: IF upper(column_name) = 'TRANSFER_COURSE_CD' OR
156: column_name is null Then
157: IF new_references.transfer_course_cd <> UPPER(new_references.transfer_course_cd) 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:
164: IF upper(column_name) = 'UNIT_CD' OR
165: column_name is null Then
166: IF new_references.unit_cd <> UPPER(new_references.unit_cd) Then
167: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
168: IGS_GE_MSG_STACK.ADD;
169: App_Exception.Raise_Exception;
170: END IF;
171: END IF;
172:
173: IF upper(column_name) = 'CAL_TYPE' OR
174: column_name is null Then
175: IF new_references.cal_type <> UPPER(new_references.cal_type) Then
176: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
177: IGS_GE_MSG_STACK.ADD;
178: App_Exception.Raise_Exception;
179: END IF;
180: END IF;
181: END check_constraints;
182:
207: new_references.transfer_dt
208: ) THEN
209: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
210: IGS_GE_MSG_STACK.ADD;
211: App_Exception.Raise_Exception;
212: END IF;
213:
214: END IF;
215:
227: new_references.uoo_id
228: ) THEN
229: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
230: IGS_GE_MSG_STACK.ADD;
231: App_Exception.Raise_Exception;
232: END IF;
233:
234: END IF;
235:
296: IF (cur_rowid%FOUND) THEN
297: Close cur_rowid;
298: Fnd_Message.Set_Name ('IGS', 'IGS_PS_SUT_SCT_FK');
299: IGS_GE_MSG_STACK.ADD;
300: App_Exception.Raise_Exception;
301: Return;
302: END IF;
303: Close cur_rowid;
304:
327: IF (cur_rowid%FOUND) THEN
328: Close cur_rowid;
329: Fnd_Message.Set_Name ('IGS', 'IGS_PS_SUT_SUA_TRANSFER_FK');
330: IGS_GE_MSG_STACK.ADD;
331: App_Exception.Raise_Exception;
332: Return;
333: END IF;
334: Close cur_rowid;
335:
383: new_references.uoo_id
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_Constraints;
390: Check_Parent_Existance;
391: ELSIF (p_action = 'UPDATE') THEN
404: new_references.uoo_id
405: ) THEN
406: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
407: IGS_GE_MSG_STACK.ADD;
408: App_Exception.Raise_Exception;
409: END IF;
410: Check_Constraints;
411: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
412: Check_Constraints;
462: end if;
463: else
464: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
465: IGS_GE_MSG_STACK.ADD;
466: app_exception.raise_exception;
467: end if;
468:
469: Before_DML(
470: p_action => 'INSERT',
551: if (c1%notfound) then
552: close c1;
553: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
554: IGS_GE_MSG_STACK.ADD;
555: app_exception.raise_exception;
556: return;
557: end if;
558: close c1;
559: