[Home] [Help]
47: Open cur_old_ref_values;
48: Fetch cur_old_ref_values INTO old_references;
49: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
50: Close cur_old_ref_values;
51: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
52: IGS_GE_MSG_STACK.ADD;
53: App_Exception.Raise_Exception;
54: Return;
55: END IF;
111: -- The following code checks for check constraints on the Columns.
112: IF Upper(Column_Name) = 'CLOSED_IND' OR
113: Column_Name IS NULL THEN
114: IF NOT (new_references.closed_ind IN ('Y', 'N')) THEN
115: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
116: IGS_GE_MSG_STACK.ADD;
117: App_Exception.Raise_Exception;
118: END IF;
119: END IF;
122: -- The following code checks for check constraints on the Columns.
123: IF Upper(Column_Name) = 'PARTIAL_IF_NULL' OR
124: Column_Name IS NULL THEN
125: IF NOT (new_references.partial_if_null IN ('Y', 'N')) THEN
126: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
127: IGS_GE_MSG_STACK.ADD;
128: App_Exception.Raise_Exception;
129: END IF;
130: END IF;
193: OPEN cur_rowid;
194: FETCH cur_rowid INTO lv_rowid;
195: IF (cur_rowid%FOUND) THEN
196: CLOSE cur_rowid;
197: Fnd_Message.Set_Name ('IGS', 'IGS_PE_MTCH_SETS_SRC_TYP_FK');
198: IGS_GE_MSG_STACK.ADD;
199: App_Exception.Raise_Exception;
200: RETURN;
201: END IF;
228: OPEN cur_rowid;
229: FETCH cur_rowid INTO lv_rowid;
230: IF (cur_rowid%FOUND) THEN
231: CLOSE cur_rowid;
232: Fnd_Message.Set_Name ('IGS', 'IGS_PE_MTCH_SETS_DUP_PAIRS_FK');
233: IGS_GE_MSG_STACK.ADD;
234: App_Exception.Raise_Exception;
235: RETURN;
236: END IF;
398: BEGIN
399: IF Get_UK1_For_Validation (
400: new_references.match_set_name
401: ) THEN
402: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
403: IGS_GE_MSG_STACK.ADD;
404: App_Exception.Raise_Exception;
405: END IF;
406:
465: -- Call all the procedures related to Before Insert.
466: Null;
467: IF Get_Pk_For_Validation(
468: new_references.match_set_id) THEN
469: Fnd_Message.Set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
470: IGS_GE_MSG_STACK.ADD;
471: App_Exception.Raise_Exception;
472: END IF;
473: Check_Constraints;
484: ELSIF (p_action = 'VALIDATE_INSERT') THEN
485: -- Call all the procedures related to Before Insert.
486: IF Get_PK_For_Validation (
487: new_references.match_set_id) THEN
488: Fnd_Message.Set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
489: IGS_GE_MSG_STACK.ADD;
490: App_Exception.Raise_Exception;
491: END IF;
492: Check_Constraints;
581: if X_LAST_UPDATE_LOGIN is NULL then
582: X_LAST_UPDATE_LOGIN := -1;
583: end if;
584: else
585: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
586: IGS_GE_MSG_STACK.ADD;
587: app_exception.raise_exception;
588: end if;
589:
690: begin
691: open c1;
692: fetch c1 into tlinfo;
693: if (c1%notfound) then
694: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
695: IGS_GE_MSG_STACK.ADD;
696: close c1;
697: app_exception.raise_exception;
698: return;
712: OR ((tlinfo.exclude_inactive_ind is null) and (X_exclude_inactive_ind is null)))
713: ) then
714: null;
715: else
716: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
717: IGS_GE_MSG_STACK.ADD;
718: app_exception.raise_exception;
719: end if;
720: return;
758: if X_LAST_UPDATE_LOGIN is NULL then
759: X_LAST_UPDATE_LOGIN := -1;
760: end if;
761: else
762: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
763: IGS_GE_MSG_STACK.ADD;
764: app_exception.raise_exception;
765: end if;
766: Before_DML(