62: Fetch cur_old_ref_values INTO old_references;
63:
64: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
65:
66: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
67: IGS_GE_MSG_STACK.ADD;
68:
69:
70: Close cur_old_ref_values;
142: new_references.closed_ind,
143:
144: v_message_name ) = FALSE THEN
145:
146: Fnd_Message.Set_Name('IGS', v_message_name);
147: IGS_GE_MSG_STACK.ADD;
148: App_Exception.Raise_Exception;
149: END IF;
150:
173:
174: IF upper(column_name) = 'CLOSED_IND' OR
175: column_name is null Then
176: IF new_references.closed_ind NOT IN ( 'Y' , 'N' ) Then
177: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
178: IGS_GE_MSG_STACK.ADD;
179: App_Exception.Raise_Exception;
180: END IF;
181: END IF;
183: IF upper(column_name) = 'GOVT_CITIZENSHIP_CD' OR
184: column_name is null Then
185: IF new_references.govt_citizenship_cd < 0 OR
186: new_references.govt_citizenship_cd > 9 Then
187: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
188: IGS_GE_MSG_STACK.ADD;
189: App_Exception.Raise_Exception;
190: END IF;
191: END IF;
301: -- Call all the procedures related to Before Insert.
302: BeforeRowInsertUpdate1 ( p_inserting => TRUE );
303: IF Get_PK_For_Validation (
304: new_references.govt_citizenship_cd ) THEN
305: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
306: IGS_GE_MSG_STACK.ADD;
307: App_Exception.Raise_Exception;
308: END IF;
309:
322: Check_Child_Existance; -- if procedure present
323: ELSIF (p_action = 'VALIDATE_INSERT') THEN
324: IF Get_PK_For_Validation (
325: new_references.govt_citizenship_cd ) THEN
326: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
327: IGS_GE_MSG_STACK.ADD;
328: App_Exception.Raise_Exception;
329: END IF;
330:
409: if X_LAST_UPDATE_LOGIN is NULL then
410: X_LAST_UPDATE_LOGIN := -1;
411: end if;
412: else
413: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
414: IGS_GE_MSG_STACK.ADD;
415: app_exception.raise_exception;
416: end if;
417:
494: begin
495: open c1;
496: fetch c1 into tlinfo;
497: if (c1%notfound) then
498: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
499:
500: close c1;
501: App_Exception.Raise_Exception;
502: return;
507: AND (tlinfo.CLOSED_IND = X_CLOSED_IND)
508: ) then
509: null;
510: else
511: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
512: app_exception.raise_exception;
513: end if;
514: return;
515: end LOCK_ROW;
539: if X_LAST_UPDATE_LOGIN is NULL then
540: X_LAST_UPDATE_LOGIN := -1;
541: end if;
542: else
543: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
544: IGS_GE_MSG_STACK.ADD;
545: app_exception.raise_exception;
546: end if;
547: