[Home] [Help]
34: Fetch cur_old_ref_values INTO old_references;
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;
111: v_course_cd,
112: v_version_number,
113: v_message_name) = FALSE THEN
114: Fnd_Message.Set_Name('IGS',v_message_name);
115: IGS_GE_MSG_STACK.ADD;
116: App_Exception.Raise_Exception;
117: END IF;
118: -- Validate the org IGS_PS_UNIT. Org IGS_PS_UNIT is not updateable.
119: IF p_inserting THEN
122: new_references.org_unit_cd,
123: new_references.ou_start_dt,
124: v_message_name) = FALSE THEN
125: Fnd_Message.Set_Name('IGS',v_message_name);
126: IGS_GE_MSG_STACK.ADD;
127: App_Exception.Raise_Exception;
128: END IF;
129: END IF;
130: -- Insert history record on update.
182: column_name is null THEN
183: IF new_references.course_cd <> UPPER(new_references.course_cd)
184: THEN
185: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
186: IGS_GE_MSG_STACK.ADD;
187: App_Exception.Raise_Exception;
188: END IF;
189: END IF;
190:
192: column_name is null THEN
193: IF (new_references.percentage < 0 OR new_references.percentage > 100 )
194: THEN
195: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
196: IGS_GE_MSG_STACK.ADD;
197: App_Exception.Raise_Exception;
198: END IF;
199: END IF;
200: END Check_Constraints;
212: new_references.course_cd,
213: new_references.version_number
214: )THEN
215: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
216: IGS_GE_MSG_STACK.ADD;
217: App_Exception.Raise_Exception;
218: END IF;
219: END IF;
220:
229: new_references.org_unit_cd,
230: new_references.ou_start_dt
231: )THEN
232: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
233: IGS_GE_MSG_STACK.ADD;
234: App_Exception.Raise_Exception;
235: END IF;
236: END IF;
237:
326: Fetch cur_rowid INTO lv_rowid;
327: IF (cur_rowid%FOUND) THEN
328: Close cur_rowid;
329: Fnd_Message.Set_Name ('IGS', 'IGS_PS_COW_CRV_FK');
330: IGS_GE_MSG_STACK.ADD;
331: App_Exception.Raise_Exception;
332: Return;
333: END IF;
334: Close cur_rowid;
354: Fetch cur_rowid INTO lv_rowid;
355: IF (cur_rowid%FOUND) THEN
356: Close cur_rowid;
357: Fnd_Message.Set_Name ('IGS', 'IGS_PS_COW_OU_FK');
358: IGS_GE_MSG_STACK.ADD;
359: App_Exception.Raise_Exception;
360: Return;
361: END IF;
362: Close cur_rowid;
403: new_references.org_unit_cd ,
404: new_references.ou_start_dt
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: Check_Parent_Existance;
424: new_references.org_unit_cd ,
425: new_references.ou_start_dt
426: ) THEN
427: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
428: IGS_GE_MSG_STACK.ADD;
429: App_Exception.Raise_Exception;
430: END IF;
431: Check_Constraints;
432: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
480: X_LAST_UPDATE_LOGIN := -1;
481: end if;
482: else
483: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
484: IGS_GE_MSG_STACK.ADD;
485: app_exception.raise_exception;
486: end if;
487: Before_DML (
488: p_action => 'INSERT',
555: fetch c1 into tlinfo;
556: if (c1%notfound) then
557: close c1;
558: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
559: IGS_GE_MSG_STACK.ADD;
560: app_exception.raise_exception;
561: return;
562: end if;
563: close c1;
566: ) then
567: null;
568: else
569: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
570: IGS_GE_MSG_STACK.ADD;
571: app_exception.raise_exception;
572: end if;
573: return;
574: end LOCK_ROW;
600: X_LAST_UPDATE_LOGIN := -1;
601: end if;
602: else
603: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
604: IGS_GE_MSG_STACK.ADD;
605: app_exception.raise_exception;
606: end if;
607: Before_DML (
608: p_action => 'UPDATE',