[Home] [Help]
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;
45: Close cur_old_ref_values;
46:
96: v_version_number,
97: v_message_name) = FALSE THEN
98: Fnd_Message.Set_Name('IGS',v_message_name);
99: IGS_GE_MSG_STACK.ADD;
100: App_Exception.Raise_Exception;
101: END IF;
102: -- Validate the org IGS_PS_UNIT. Org IGS_PS_UNIT is not updateable.
103: IF p_inserting THEN
104: -- As part of the bug# 1956374 changed to the below call from IGS_PS_VAL_CAO.crsp_val_ou_sys_sts
107: new_references.ou_start_dt,
108: v_message_name) = FALSE THEN
109: Fnd_Message.Set_Name('IGS',v_message_name);
110: IGS_GE_MSG_STACK.ADD;
111: App_Exception.Raise_Exception;
112: END IF;
113: END IF;
114:
115:
133: CLOSE c_closed_ind;
134: IF l_c_closed_ind = 'Y' THEN
135: fnd_message.set_name('IGS','IGS_PS_AWD_CD_CLOSED');
136: igs_ge_msg_stack.add;
137: app_exception.raise_exception;
138: END IF;
139: END IF;
140: END before_insert_update;
141:
160: column_name is null Then
161: IF ( new_references.percentage < 0 OR new_references.percentage > 100 ) Then
162: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
163: IGS_GE_MSG_STACK.ADD;
164: App_Exception.Raise_Exception;
165: END IF;
166: END IF;
167:
168: IF upper(column_name) = 'AWARD_CD' OR
169: column_name is null Then
170: IF ( new_references.award_cd <> UPPER(new_references.award_cd) ) Then
171: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
172: IGS_GE_MSG_STACK.ADD;
173: App_Exception.Raise_Exception;
174: END IF;
175: END IF;
176:
177: IF upper(column_name) = 'COURSE_CD' OR
178: column_name is null Then
179: IF ( new_references.course_cd <> UPPER(new_references.course_cd) ) Then
180: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
181: IGS_GE_MSG_STACK.ADD;
182: App_Exception.Raise_Exception;
183: END IF;
184: END IF;
185:
186: END Check_Constraints;
202: new_references.award_cd
203: ) THEN
204: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
205: IGS_GE_MSG_STACK.ADD;
206: App_Exception.Raise_Exception;
207: END IF;
208: END IF;
209:
210: IF (((old_references.org_unit_cd = new_references.org_unit_cd) AND
218: new_references.ou_start_dt
219: ) THEN
220: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
221: IGS_GE_MSG_STACK.ADD;
222: App_Exception.Raise_Exception;
223: END IF;
224: END IF;
225:
226: END Check_Parent_Existance;
280: IF (cur_rowid%FOUND) THEN
281: Close cur_rowid;
282: Fnd_Message.Set_Name ('IGS', 'IGS_PS_CAO_OU_FK');
283: IGS_GE_MSG_STACK.ADD;
284: App_Exception.Raise_Exception;
285: Return;
286: END IF;
287: Close cur_rowid;
288:
332: new_references.org_unit_cd ,
333: new_references.ou_start_dt) THEN
334: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
335: IGS_GE_MSG_STACK.ADD;
336: App_Exception.Raise_Exception;
337: END IF;
338: Check_Constraints;
339: Check_Parent_Existance;
340: ELSIF (p_action = 'UPDATE') THEN
354: new_references.org_unit_cd ,
355: new_references.ou_start_dt) THEN
356: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
357: IGS_GE_MSG_STACK.ADD;
358: App_Exception.Raise_Exception;
359: END IF;
360: Check_Constraints;
361: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
362: Check_Constraints;
410: end if;
411: else
412: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
413: IGS_GE_MSG_STACK.ADD;
414: app_exception.raise_exception;
415: end if;
416:
417: Before_DML (
418: p_action => 'INSERT',
493: if (c1%notfound) then
494: close c1;
495: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
496: IGS_GE_MSG_STACK.ADD;
497: app_exception.raise_exception;
498: return;
499: end if;
500: close c1;
501:
504: null;
505: else
506: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
507: IGS_GE_MSG_STACK.ADD;
508: app_exception.raise_exception;
509: end if;
510: return;
511: end LOCK_ROW;
512:
539: end if;
540: else
541: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
542: IGS_GE_MSG_STACK.ADD;
543: app_exception.raise_exception;
544: end if;
545:
546: Before_DML (
547: p_action => 'UPDATE',