[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_AORS.admp_val_saors_clsd(
76: new_references.s_adm_offer_resp_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:
113: END IF ;
114:
115: IF upper(Column_name) = 'CLOSED_IND' OR COLUMN_NAME IS NULL THEN
116: IF new_references.CLOSED_IND<> upper(new_references.CLOSED_IND) then
117: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
118: IGS_GE_MSG_STACK.ADD;
119: App_Exception.Raise_Exception ;
120: END IF;
121:
119: App_Exception.Raise_Exception ;
120: END IF;
121:
122: IF new_references.CLOSED_IND not in ('Y','N') then
123: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
124: IGS_GE_MSG_STACK.ADD;
125: App_Exception.Raise_Exception ;
126: END IF;
127:
128: END IF ;
129:
130: IF upper(Column_name) = 'ADM_OFFER_RESP_STATUS' OR COLUMN_NAME IS NULL THEN
131: IF new_references.ADM_OFFER_RESP_STATUS<> upper(new_references.ADM_OFFER_RESP_STATUS) then
132: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
133: IGS_GE_MSG_STACK.ADD;
134: App_Exception.Raise_Exception ;
135: END IF;
136:
138:
139:
140: IF upper(Column_name) = 'SYSTEM_DEFAULT_IND' OR COLUMN_NAME IS NULL THEN
141: IF new_references.SYSTEM_DEFAULT_IND<> upper(new_references.SYSTEM_DEFAULT_IND) then
142: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
143: IGS_GE_MSG_STACK.ADD;
144: App_Exception.Raise_Exception ;
145: END IF;
146:
144: App_Exception.Raise_Exception ;
145: END IF;
146:
147: IF new_references.SYSTEM_DEFAULT_IND not in ('Y','N') then
148: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
149: IGS_GE_MSG_STACK.ADD;
150: App_Exception.Raise_Exception ;
151: END IF;
152:
153: END IF ;
154:
155: IF upper(Column_name) = 'S_ADM_OFFER_RESP_STATUS' OR COLUMN_NAME IS NULL THEN
156: IF new_references.S_ADM_OFFER_RESP_STATUS<> upper(new_references.S_ADM_OFFER_RESP_STATUS) then
157: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
158: IGS_GE_MSG_STACK.ADD;
159: App_Exception.Raise_Exception ;
160: END IF;
161:
172: ELSE
173: IF NOT IGS_LOOKUPS_VIEW_PKG.Get_PK_For_Validation (
174: 'ADM_OFFER_RESP_STATUS',new_references.s_adm_offer_resp_status
175: ) THEN
176: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
177: IGS_GE_MSG_STACK.ADD;
178: App_Exception.Raise_Exception;
179: END IF;
180: END IF;
234: Open cur_rowid;
235: Fetch cur_rowid INTO lv_rowid;
236: IF (cur_rowid%FOUND) THEN
237: Close cur_rowid;
238: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AORS_SLV_FK');
239: IGS_GE_MSG_STACK.ADD;
240: App_Exception.Raise_Exception;
241: Return;
242: END IF;
280: BeforeRowInsertUpdate1 ( p_inserting => TRUE,p_updating => FALSE, p_deleting =>FALSE );
281:
282: IF Get_PK_For_Validation (
283: new_references.adm_offer_resp_status ) THEN
284: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
285: IGS_GE_MSG_STACK.ADD;
286: App_Exception.Raise_Exception;
287: END IF;
288: Check_Constraints;
299: ELSIF (p_action = 'VALIDATE_INSERT') THEN
300: IF Get_PK_For_Validation (
301: new_references.adm_offer_resp_status
302: ) THEN
303: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
304: IGS_GE_MSG_STACK.ADD;
305: App_Exception.Raise_Exception;
306: END IF;
307: Check_Constraints;
352: if X_LAST_UPDATE_LOGIN is NULL then
353: X_LAST_UPDATE_LOGIN := -1;
354: end if;
355: else
356: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
357: IGS_GE_MSG_STACK.ADD;
358: app_exception.raise_exception;
359: end if;
360:
435: open c1;
436: fetch c1 into tlinfo;
437: if (c1%notfound) then
438: close c1;
439: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
440: IGS_GE_MSG_STACK.ADD;
441: app_exception.raise_exception;
442: return;
443: end if;
449: AND (tlinfo.CLOSED_IND = X_CLOSED_IND)
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;
483: if X_LAST_UPDATE_LOGIN is NULL then
484: X_LAST_UPDATE_LOGIN := -1;
485: end if;
486: else
487: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
488: IGS_GE_MSG_STACK.ADD;
489: app_exception.raise_exception;
490: end if;
491: