[Home] [Help]
37: Open cur_old_ref_values;
38: Fetch cur_old_ref_values INTO old_references;
39: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
40: Close cur_old_ref_values;
41: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
42: IGS_GE_MSG_STACK.ADD;
43: App_Exception.Raise_Exception;
44: Return;
45: END IF;
82: END IF;
83:
84: IF Upper(Column_Name)='DISCIPLINE_GROUP_CD' OR Column_Name IS NULL Then
85: IF New_References.Discipline_Group_Cd <> UPPER(New_References.Discipline_Group_Cd) Then
86: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
87: IGS_GE_MSG_STACK.ADD;
88: App_Exception.Raise_Exception;
89: END IF;
90: END IF;
90: END IF;
91:
92: IF Upper(Column_Name)='UNIT_CD' OR Column_Name IS NULL Then
93: IF New_References.Unit_Cd <> UPPER(New_References.Unit_CD) Then
94: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
95: IGS_GE_MSG_STACK.ADD;
96: App_Exception.Raise_Exception;
97: END IF;
98: END IF;
107: NULL;
108: ELSE
109: IF NOT IGS_PS_DSCP_PKG.Get_PK_For_Validation (
110: new_references.discipline_group_cd) THEN
111: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
112: IGS_GE_MSG_STACK.ADD;
113: App_Exception.Raise_Exception;
114: END IF;
115:
123: ELSE
124: IF NOT IGS_PS_UNIT_VER_PKG.Get_PK_For_Validation (
125: new_references.unit_cd,
126: new_references.version_number) THEN
127: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
128: IGS_GE_MSG_STACK.ADD;
129: App_Exception.Raise_Exception;
130: END IF;
131:
181: Open cur_rowid;
182: Fetch cur_rowid INTO lv_rowid;
183: IF (cur_rowid%FOUND) THEN
184: Close cur_rowid;
185: Fnd_Message.Set_Name ('IGS', 'IGS_PS_UDH_DI_FK');
186: IGS_GE_MSG_STACK.ADD;
187: App_Exception.Raise_Exception;
188: Return;
189: END IF;
209: Open cur_rowid;
210: Fetch cur_rowid INTO lv_rowid;
211: IF (cur_rowid%FOUND) THEN
212: Close cur_rowid;
213: Fnd_Message.Set_Name ('IGS', 'IGS_PS_UDH_UV_FK');
214: IGS_GE_MSG_STACK.ADD;
215: App_Exception.Raise_Exception;
216: Return;
217: END IF;
261: IF Get_PK_For_Validation (New_References.unit_cd,
262: New_References.version_number,
263: New_References.discipline_group_cd,
264: New_References.hist_start_dt) THEN
265: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
266: IGS_GE_MSG_STACK.ADD;
267: App_Exception.Raise_Exception;
268: END IF;
269: Check_Constraints;
277: IF Get_PK_For_Validation (New_References.unit_cd,
278: New_References.version_number,
279: New_References.discipline_group_cd,
280: New_References.hist_start_dt) THEN
281: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
282: IGS_GE_MSG_STACK.ADD;
283: App_Exception.Raise_Exception;
284: END IF;
285: Check_Constraints;
335: if X_LAST_UPDATE_LOGIN is NULL then
336: X_LAST_UPDATE_LOGIN := -1;
337: end if;
338: else
339: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
340: IGS_GE_MSG_STACK.ADD;
341: app_exception.raise_exception;
342: end if;
343:
426: open c1;
427: fetch c1 into tlinfo;
428: if (c1%notfound) then
429: close c1;
430: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
431: IGS_GE_MSG_STACK.ADD;
432: app_exception.raise_exception;
433: return;
434: end if;
441: AND (X_PERCENTAGE is null)))
442: ) then
443: null;
444: else
445: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
446: IGS_GE_MSG_STACK.ADD;
447: app_exception.raise_exception;
448: end if;
449: return;
477: if X_LAST_UPDATE_LOGIN is NULL then
478: X_LAST_UPDATE_LOGIN := -1;
479: end if;
480: else
481: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
482: IGS_GE_MSG_STACK.ADD;
483: app_exception.raise_exception;
484: end if;
485: