[Home] [Help]
27: Open cur_old_ref_values;
28: Fetch cur_old_ref_values INTO old_references;
29: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
30: Close cur_old_ref_values;
31: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
32: IGS_GE_MSG_STACK.ADD;
33: App_Exception.Raise_Exception;
34: Return;
35: END IF;
67: IF IGS_ST_VAL_GDHC.stap_val_gdhc_end_dt(
68: new_references.start_dt,
69: new_references.end_dt,
70: v_message_name) = FALSE THEN
71: Fnd_Message.Set_Name('IGS',v_message_name);
72: IGS_GE_MSG_STACK.ADD;
73: App_Exception.Raise_Exception;
74: END IF;
75: END IF;
75: END IF;
76: IF IGS_ST_VAL_GDHC.stap_val_gdhc_gd(
77: new_references.govt_discipline_group_cd,
78: v_message_name) = FALSE THEN
79: Fnd_Message.Set_Name('IGS',v_message_name);
80: IGS_GE_MSG_STACK.ADD;
81: App_Exception.Raise_Exception;
82: END IF;
83: END IF;
98: new_references.govt_discipline_group_cd,
99: new_references.start_dt,
100: new_references.end_dt,
101: v_message_name) = FALSE THEN
102: Fnd_Message.Set_Name('IGS',v_message_name);
103: IGS_GE_MSG_STACK.ADD;
104: App_Exception.Raise_Exception;
105: END IF;
106: IF new_references.end_dt IS NULL THEN
107: IF IGS_ST_VAL_GDHC.stap_val_gdhc_open (
108: new_references.govt_discipline_group_cd,
109: new_references.start_dt,
110: v_message_name) = FALSE THEN
111: Fnd_Message.Set_Name('IGS',v_message_name);
112: IGS_GE_MSG_STACK.ADD;
113: App_Exception.Raise_Exception;
114: END IF;
115: END IF;
126: new_references.govt_discipline_group_cd := column_value;
127: END IF;
128: IF ((UPPER (column_name) = 'GOVT_DISCIPLINE_GROUP_CD') OR (column_name IS NULL)) THEN
129: IF (new_references.govt_discipline_group_cd <> UPPER (new_references.govt_discipline_group_cd)) THEN
130: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
131: IGS_GE_MSG_STACK.ADD;
132: App_Exception.Raise_Exception;
133: END IF;
134: END IF;
138: IF (Get_UK1_For_Validation (
139: new_references.govt_discipline_group_cd,
140: new_references.start_dt
141: )) THEN
142: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
143: IGS_GE_MSG_STACK.ADD;
144: App_Exception.Raise_Exception;
145: END IF;
146: END Check_Uniqueness;
152: ELSE
153: IF NOT IGS_PS_GOVT_DSCP_PKG.Get_PK_For_Validation (
154: new_references.govt_discipline_group_cd
155: ) THEN
156: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
157: IGS_GE_MSG_STACK.ADD;
158: App_Exception.Raise_Exception;
159: END IF;
160: END IF;
164: ELSE
165: IF NOT IGS_FI_GOVT_HEC_CNTB_PKG.Get_PK_For_Validation (
166: new_references.govt_hecs_cntrbtn_band
167: ) THEN
168: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
169: IGS_GE_MSG_STACK.ADD;
170: App_Exception.Raise_Exception;
171: END IF;
172: END IF;
230: Open cur_rowid;
231: Fetch cur_rowid INTO lv_rowid;
232: IF (cur_rowid%FOUND) THEN
233: Close cur_rowid;
234: Fnd_Message.Set_Name ('IGS', 'IGS_FI_GDHC_GD_FK');
235: IGS_GE_MSG_STACK.ADD;
236: App_Exception.Raise_Exception;
237: Return;
238: END IF;
250: Open cur_rowid;
251: Fetch cur_rowid INTO lv_rowid;
252: IF (cur_rowid%FOUND) THEN
253: Close cur_rowid;
254: Fnd_Message.Set_Name ('IGS', 'IGS_FI_GDHC_GHC_FK');
255: IGS_GE_MSG_STACK.ADD;
256: App_Exception.Raise_Exception;
257: Return;
258: END IF;
292: new_references.govt_discipline_group_cd,
293: new_references.govt_hecs_cntrbtn_band,
294: new_references.start_dt
295: )) THEN
296: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
297: IGS_GE_MSG_STACK.ADD;
298: App_Exception.Raise_Exception;
299: END IF;
300: Check_Uniqueness;
314: new_references.govt_discipline_group_cd,
315: new_references.govt_hecs_cntrbtn_band,
316: new_references.start_dt
317: )) THEN
318: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
319: IGS_GE_MSG_STACK.ADD;
320: App_Exception.Raise_Exception;
321: END IF;
322: Check_Uniqueness;
369: if X_LAST_UPDATE_LOGIN is NULL then
370: X_LAST_UPDATE_LOGIN := -1;
371: end if;
372: else
373: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
374: IGS_GE_MSG_STACK.ADD;
375: app_exception.raise_exception;
376: end if;
377: Before_DML(
437: open c1;
438: fetch c1 into tlinfo;
439: if (c1%notfound) then
440: close c1;
441: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
442: IGS_GE_MSG_STACK.ADD;
443: app_exception.raise_exception;
444: return;
445: end if;
449: AND (X_END_DT is null)))
450: ) then
451: null;
452: else
453: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
454: IGS_GE_MSG_STACK.ADD;
455: app_exception.raise_exception;
456: end if;
457: return;
481: if X_LAST_UPDATE_LOGIN is NULL then
482: X_LAST_UPDATE_LOGIN := -1;
483: end if;
484: else
485: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
486: IGS_GE_MSG_STACK.ADD;
487: app_exception.raise_exception;
488: end if;
489: Before_DML(