[Home] [Help]
64: Open cur_old_ref_values;
65: Fetch cur_old_ref_values INTO old_references;
66: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
67: Close cur_old_ref_values;
68: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
69: IGS_GE_MSG_STACK.ADD;
70: App_Exception.Raise_Exception;
71: Return;
72: END IF;
149: -- Validate that updates are allowed
150: IF IGS_PS_VAL_CRS.CRSP_VAL_IUD_CRV_DTL(v_course_cd,
151: v_version_number,
152: v_message_name) = FALSE THEN
153: Fnd_Message.Set_Name('IGS',v_message_name);
154: IGS_GE_MSG_STACK.ADD;
155: App_Exception.Raise_Exception;
156: END IF;
157: -- Validate calendar type.
159: (p_updating AND old_references.cal_type <> new_references.cal_type) THEN
160: IF IGS_PS_VAL_CO.crsp_val_co_cal_type (
161: new_references.cal_type,
162: v_message_name) = FALSE THEN
163: Fnd_Message.Set_Name('IGS',v_message_name);
164: IGS_GE_MSG_STACK.ADD;
165: App_Exception.Raise_Exception;
166: END IF;
167: END IF;
193:
194: IF upper(column_name) = 'CAL_TYPE' OR
195: column_name is null Then
196: IF ( new_references.cal_type <> UPPER(new_references.cal_type) ) Then
197: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
198: IGS_GE_MSG_STACK.ADD;
199: App_Exception.Raise_Exception;
200: END IF;
201: END IF;
202:
203: IF upper(column_name) = 'COURSE_CD' OR
204: column_name is null Then
205: IF ( new_references.course_cd <> UPPER(new_references.course_cd) ) Then
206: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
207: IGS_GE_MSG_STACK.ADD;
208: App_Exception.Raise_Exception;
209: END IF;
210: END IF;
229: ELSE
230: IF NOT IGS_CA_TYPE_PKG.Get_PK_For_Validation (
231: new_references.cal_type
232: ) THEN
233: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
234: IGS_GE_MSG_STACK.ADD;
235: App_Exception.Raise_Exception;
236: END IF;
237: END IF;
245: IF NOT IGS_PS_VER_PKG.Get_PK_For_Validation (
246: new_references.course_cd,
247: new_references.version_number
248: ) THEN
249: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
250: IGS_GE_MSG_STACK.ADD;
251: App_Exception.Raise_Exception;
252: END IF;
253: END IF;
375: Open cur_rowid;
376: Fetch cur_rowid INTO lv_rowid;
377: IF (cur_rowid%FOUND) THEN
378: Close cur_rowid;
379: Fnd_Message.Set_Name ('IGS', 'IGS_PS_CO_CAT_FK');
380: IGS_GE_MSG_STACK.ADD;
381: App_Exception.Raise_Exception;
382: Return;
383: END IF;
411: Open cur_rowid;
412: Fetch cur_rowid INTO lv_rowid;
413: IF (cur_rowid%FOUND) THEN
414: Close cur_rowid;
415: Fnd_Message.Set_Name ('IGS', 'IGS_PS_CO_CRV_FK');
416: IGS_GE_MSG_STACK.ADD;
417: App_Exception.Raise_Exception;
418: Return;
419: END IF;
508: IF Get_PK_For_Validation (
509: new_references.course_cd,
510: new_references.version_number,
511: new_references.cal_type) THEN
512: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
513: IGS_GE_MSG_STACK.ADD;
514: App_Exception.Raise_Exception;
515: END IF;
516: Check_Constraints;
528: IF Get_PK_For_Validation (
529: new_references.course_cd,
530: new_references.version_number,
531: new_references.cal_type) THEN
532: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
533: IGS_GE_MSG_STACK.ADD;
534: App_Exception.Raise_Exception;
535: END IF;
536: Check_Constraints;
613: if X_LAST_UPDATE_LOGIN is NULL then
614: X_LAST_UPDATE_LOGIN := -1;
615: end if;
616: else
617: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
618: IGS_GE_MSG_STACK.ADD;
619: app_exception.raise_exception;
620: end if;
621: Before_DML (
778: open c1;
779: fetch c1 into tlinfo;
780: if (c1%notfound) then
781: close c1;
782: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
783: IGS_GE_MSG_STACK.ADD;
784: app_exception.raise_exception;
785: return;
786: end if;