[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;
74: (old_references.closed_ind = 'Y' AND new_references.closed_ind = 'N')) THEN
75: IF IGS_AD_VAL_AUOS.admp_val_saos_clsd(
76: new_references.s_adm_outcome_status,
77: v_message_name) = FALSE THEN
78: Fnd_Message.Set_Name('IGS',v_message_name);
79: IGS_GE_MSG_STACK.ADD;
80: App_Exception.Raise_Exception;
81: END IF;
82: END IF;
80: App_Exception.Raise_Exception;
81: END IF;
82: END IF;
83: IF (new_references.closed_ind = 'Y' AND new_references.system_default_ind = 'Y') THEN
84: Fnd_Message.Set_Name('IGS','IGS_AD_SYS_DFLT_IND_NOTSET_CLS');
85: IGS_GE_MSG_STACK.ADD;
86: App_Exception.Raise_Exception;
87: END IF;
88: END BeforeRowInsertUpdate1;
114: END IF ;
115:
116: IF upper(Column_name) = 'ADM_OUTCOME_STATUS' OR COLUMN_NAME IS NULL THEN
117: IF new_references.ADM_OUTCOME_STATUS<> upper(new_references.ADM_OUTCOME_STATUS) then
118: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
119: IGS_GE_MSG_STACK.ADD;
120: App_Exception.Raise_Exception ;
121: END IF;
122:
123: END IF ;
124:
125: IF upper(Column_name) = 'CLOSED_IND' OR COLUMN_NAME IS NULL THEN
126: IF new_references.CLOSED_IND<> upper(new_references.CLOSED_IND) then
127: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
128: IGS_GE_MSG_STACK.ADD;
129: App_Exception.Raise_Exception ;
130: END IF;
131:
129: App_Exception.Raise_Exception ;
130: END IF;
131:
132: IF new_references.CLOSED_IND not in ('Y','N') then
133: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
134: IGS_GE_MSG_STACK.ADD;
135: App_Exception.Raise_Exception ;
136: END IF;
137:
139:
140:
141: IF upper(Column_name) = 'SYSTEM_DEFAULT_IND' OR COLUMN_NAME IS NULL THEN
142: IF new_references.SYSTEM_DEFAULT_IND<> upper(new_references.SYSTEM_DEFAULT_IND) then
143: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
144: IGS_GE_MSG_STACK.ADD;
145: App_Exception.Raise_Exception ;
146: END IF;
147:
145: App_Exception.Raise_Exception ;
146: END IF;
147:
148: IF new_references.SYSTEM_DEFAULT_IND not in ('Y','N') then
149: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
150: IGS_GE_MSG_STACK.ADD;
151: App_Exception.Raise_Exception ;
152: END IF;
153:
154: END IF ;
155:
156: IF upper(Column_name) = 'S_ADM_OUTCOME_STATUS' OR COLUMN_NAME IS NULL THEN
157: IF new_references.S_ADM_OUTCOME_STATUS<> upper(new_references.S_ADM_OUTCOME_STATUS) then
158: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
159: IGS_GE_MSG_STACK.ADD;
160: App_Exception.Raise_Exception ;
161: END IF;
162:
174: ELSE
175: IF NOT IGS_LOOKUPS_VIEW_PKG.Get_PK_For_Validation (
176: 'ADM_OUTCOME_STATUS', new_references.s_adm_outcome_status
177: ) THEN
178: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
179: IGS_GE_MSG_STACK.ADD;
180: App_Exception.Raise_Exception;
181: END IF;
182: END IF;
248: Open cur_rowid;
249: Fetch cur_rowid INTO lv_rowid;
250: IF (cur_rowid%FOUND) THEN
251: Close cur_rowid;
252: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AOS_SLV_FK');
253: IGS_GE_MSG_STACK.ADD;
254: App_Exception.Raise_Exception;
255: Return;
256: END IF;
294: BeforeRowInsertUpdate1 ( p_inserting =>TRUE ,p_updating => FALSE , p_deleting => FALSE );
295:
296: IF Get_PK_For_Validation (
297: new_references.adm_outcome_status ) THEN
298: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
299: IGS_GE_MSG_STACK.ADD;
300: App_Exception.Raise_Exception;
301: END IF;
302: Check_Constraints;
312: ELSIF (p_action = 'VALIDATE_INSERT') THEN
313: IF Get_PK_For_Validation (
314: new_references.adm_outcome_status
315: ) THEN
316: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
317: IGS_GE_MSG_STACK.ADD;
318: App_Exception.Raise_Exception;
319: END IF;
320: Check_Constraints;
364: if X_LAST_UPDATE_LOGIN is NULL then
365: X_LAST_UPDATE_LOGIN := -1;
366: end if;
367: else
368: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
369: IGS_GE_MSG_STACK.ADD;
370: app_exception.raise_exception;
371: end if;
372:
447: open c1;
448: fetch c1 into tlinfo;
449: if (c1%notfound) then
450: close c1;
451: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
452: IGS_GE_MSG_STACK.ADD;
453: app_exception.raise_exception;
454: return;
455: end if;
461: AND (tlinfo.CLOSED_IND = X_CLOSED_IND)
462: ) then
463: null;
464: else
465: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
466: IGS_GE_MSG_STACK.ADD;
467: app_exception.raise_exception;
468: end if;
469: return;
495: if X_LAST_UPDATE_LOGIN is NULL then
496: X_LAST_UPDATE_LOGIN := -1;
497: end if;
498: else
499: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
500: IGS_GE_MSG_STACK.ADD;
501: app_exception.raise_exception;
502: end if;
503: