[Home] [Help]
34: Open cur_old_ref_values;
35: Fetch cur_old_ref_values INTO old_references;
36: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
37: Close cur_old_ref_values;
38: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
39: IGS_GE_MSG_STACK.ADD;
40: App_Exception.Raise_Exception;
41: Return;
42: END IF;
80: IF IGS_CA_VAL_DAIOC.calp_val_sdoct_clsd(
81: new_references.s_dt_offset_constraint_type,
82: v_message_name) = FALSE
83: THEN
84: Fnd_Message.Set_Name('IGS',v_message_name);
85: IGS_GE_MSG_STACK.ADD;
86: APP_EXCEPTION.RAISE_EXCEPTION;
87: END IF;
88: END IF;
108: new_references.s_dt_offset_constraint_type,
109: new_references.constraint_condition,
110: new_references.constraint_resolution,
111: v_message_name) = FALSE THEN
112: Fnd_Message.Set_Name('IGS',v_message_name);
113: IGS_GE_MSG_STACK.ADD;
114: APP_EXCEPTION.RAISE_EXCEPTION;
115: END IF;
116: END IF;
135: End if;
136:
137: If upper(Column_name)= 'CONSTRAINT_CONDITION' Or column_name is null then
138: if new_references.constraint_condition NOT IN ( 'MUST' , 'MUST NOT' )Then
139: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
140: IGS_GE_MSG_STACK.ADD;
141: App_Exception.Raise_Exception;
142: End if;
143: End if;
143: End if;
144:
145: If upper(Column_name)= 'CONSTRAINT_RESOLUTION' Or column_name is null then
146: If new_references.constraint_resolution < -9 or new_references.constraint_resolution > 9 Then
147: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
148: IGS_GE_MSG_STACK.ADD;
149: App_Exception.Raise_Exception;
150: End if;
151: End if;
151: End if;
152:
153: If upper(Column_name)= 'DT_ALIAS' Or column_name is null then
154: If UPPER(new_references.dt_alias) <> new_references.dt_alias Then
155: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
156: IGS_GE_MSG_STACK.ADD;
157: App_Exception.Raise_Exception;
158: End if;
159: End if;
159: End if;
160:
161: If upper(Column_name)= 'OFFSET_DT_ALIAS' Or column_name is null then
162: If UPPER(new_references.offset_dt_alias) <> new_references.offset_dt_alias Then
163: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
164: IGS_GE_MSG_STACK.ADD;
165: App_Exception.Raise_Exception;
166: End if;
167: End if;
167: End if;
168:
169: If upper(Column_name)= 'S_DT_OFFSET_CONSTRAINT_TYPE' Or column_name is null then
170: If UPPER(new_references.s_dt_offset_constraint_type) <> new_references.s_dt_offset_constraint_type 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;
188: If NOT IGS_CA_DA_OFST_PKG.Get_PK_For_Validation (
189: new_references.dt_alias,
190: new_references.offset_dt_alias
191: ) Then
192: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
193: IGS_GE_MSG_STACK.ADD;
194: app_exception.raise_exception;
195: END IF;
196: END IF;
201: If NOT IGS_LOOKUPS_VIEW_PKG.Get_PK_For_Validation (
202: 'DT_OFFSET_CONSTRAINT_TYPE',
203: new_references.s_dt_offset_constraint_type
204: ) Then
205: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
206: IGS_GE_MSG_STACK.ADD;
207: app_exception.raise_exception;
208: END IF;
209: END IF;
267: Open cur_rowid;
268: Fetch cur_rowid INTO lv_rowid;
269: IF (cur_rowid%FOUND) THEN
270: Close cur_rowid;
271: Fnd_Message.Set_Name ('IGS', 'IGS_CA_DAOC_DAO_FK');
272: IGS_GE_MSG_STACK.ADD;
273: App_Exception.Raise_Exception;
274: Return;
275: END IF;
316: new_references.dt_alias ,
317: new_references.offset_dt_alias ,
318: new_references.s_dt_offset_constraint_type
319: ) Then
320: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
321: IGS_GE_MSG_STACK.ADD;
322: app_exception.raise_exception;
323: end if;
324: check_constraints;
336: new_references.dt_alias ,
337: new_references.offset_dt_alias ,
338: new_references.s_dt_offset_constraint_type
339: ) Then
340: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
341: IGS_GE_MSG_STACK.ADD;
342: app_exception.raise_exception;
343: end if;
344: check_constraints;
401: if X_LAST_UPDATE_LOGIN is NULL then
402: X_LAST_UPDATE_LOGIN := -1;
403: end if;
404: else
405: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
406: IGS_GE_MSG_STACK.ADD;
407: app_exception.raise_exception;
408: end if;
409: Before_DML (
481: open c1;
482: fetch c1 into tlinfo;
483: if (c1%notfound) then
484: close c1;
485: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
486: IGS_GE_MSG_STACK.ADD;
487: app_exception.raise_exception;
488: return;
489: end if;
496: AND (tlinfo.CONSTRAINT_RESOLUTION = X_CONSTRAINT_RESOLUTION)
497: ) then
498: null;
499: else
500: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
501: IGS_GE_MSG_STACK.ADD;
502: app_exception.raise_exception;
503: end if;
504: return;
530: if X_LAST_UPDATE_LOGIN is NULL then
531: X_LAST_UPDATE_LOGIN := -1;
532: end if;
533: else
534: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
535: IGS_GE_MSG_STACK.ADD;
536: app_exception.raise_exception;
537: end if;
538: Before_DML (