[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: (new_references.closed_ind = 'Y' AND new_references.closed_ind = 'N')) THEN
75: IF IGS_EN_VAL_CIC.enrp_val_cic_govt (
76: new_references.govt_citizenship_cd,
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;
100: END IF ;
101:
102: IF upper(Column_name) = 'CLOSED_IND' OR COLUMN_NAME IS NULL THEN
103: IF new_references.CLOSED_IND<> upper(new_references.CLOSED_IND) then
104: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
105: IGS_GE_MSG_STACK.ADD;
106: App_Exception.Raise_Exception ;
107: END IF;
108:
106: App_Exception.Raise_Exception ;
107: END IF;
108:
109: IF new_references.CLOSED_IND not in ('Y','N') then
110: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
111: IGS_GE_MSG_STACK.ADD;
112: App_Exception.Raise_Exception ;
113: END IF;
114:
115: END IF ;
116:
117: IF upper(Column_name) = 'CITIZENSHIP_CD' OR COLUMN_NAME IS NULL THEN
118: IF new_references.CITIZENSHIP_CD<> upper(new_references.CITIZENSHIP_CD) then
119: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
120: IGS_GE_MSG_STACK.ADD;
121: App_Exception.Raise_Exception ;
122: END IF;
123:
129: BEGIN
130:
131: IF Get_PK_For_Validation (
132: new_references.citizenship_cd ) THEN
133: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
134: IGS_GE_MSG_STACK.ADD;
135: App_Exception.Raise_Exception;
136: END IF;
137: END Check_Uniqueness ;
146: ELSE
147: IF NOT IGS_PE_GOVCITIZEN_CD_PKG.Get_PK_For_Validation (
148: new_references.govt_citizenship_cd
149: ) THEN
150: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
151: IGS_GE_MSG_STACK.ADD;
152: App_Exception.Raise_Exception;
153: END IF;
154: END IF ;
197: Open cur_rowid;
198: Fetch cur_rowid INTO lv_rowid;
199: IF (cur_rowid%FOUND) THEN
200: Close cur_rowid;
201: Fnd_Message.Set_Name ('IGS', 'IGS_ST_CIC_GCC_FK');
202: IGS_GE_MSG_STACK.ADD;
203: App_Exception.Raise_Exception;
204: Return;
205: END IF;
243: BeforeRowInsertUpdate1 ( p_inserting => TRUE );
244: IF Get_PK_For_Validation (
245: new_references.govt_citizenship_cd
246: ) THEN
247: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
248: IGS_GE_MSG_STACK.ADD;
249: App_Exception.Raise_Exception;
250: END IF;
251: Check_Constraints;
264: ELSIF (p_action = 'VALIDATE_INSERT') THEN
265: IF Get_PK_For_Validation (
266: new_references.govt_citizenship_cd
267: ) THEN
268: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
269: IGS_GE_MSG_STACK.ADD;
270: App_Exception.Raise_Exception;
271: END IF;
272: Check_Constraints;
318: if X_LAST_UPDATE_LOGIN is NULL then
319: X_LAST_UPDATE_LOGIN := -1;
320: end if;
321: else
322: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
323: IGS_GE_MSG_STACK.ADD;
324: app_exception.raise_exception;
325: end if;
326:
398: open c1;
399: fetch c1 into tlinfo;
400: if (c1%notfound) then
401: close c1;
402: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
403: IGS_GE_MSG_STACK.ADD;
404: app_exception.raise_exception;
405: return;
406: end if;
414: AND (X_NOTES is null)))
415: ) then
416: null;
417: else
418: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
419: IGS_GE_MSG_STACK.ADD;
420: app_exception.raise_exception;
421: end if;
422: return;
448: if X_LAST_UPDATE_LOGIN is NULL then
449: X_LAST_UPDATE_LOGIN := -1;
450: end if;
451: else
452: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
453: IGS_GE_MSG_STACK.ADD;
454: app_exception.raise_exception;
455: end if;
456: