[Home] [Help]
35: Open cur_old_ref_values;
36: Fetch cur_old_ref_values INTO old_references;
37: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
38: Close cur_old_ref_values;
39: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
40: IGS_GE_MSG_STACK.ADD;
41: App_Exception.Raise_Exception;
42: Return;
43: END IF;
71: BEGIN
72: IF (p_inserting OR (p_updating AND (old_references.tracking_type <> new_references.tracking_type))) THEN
73: IF NOT IGS_TR_VAL_TRI.TRKP_VAL_TRI_TYPE (new_references.tracking_type,
74: v_message_name) THEN
75: Fnd_Message.Set_Name('IGS', v_message_name);
76: IGS_GE_MSG_STACK.ADD;
77: App_Exception.Raise_Exception;
78: END IF;
79: END IF;
97: END IF;
98:
99: IF upper(Column_name) = 'PANEL_MEMBER_TYPE' OR column_name is null then
100: IF new_references.panel_member_type <> UPPER(new_references.panel_member_type ) then
101: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
102: IGS_GE_MSG_STACK.ADD;
103: App_Exception.Raise_Exception;
104: END IF;
105: END IF;
105: END IF;
106:
107: IF upper(Column_name) = 'TRACKING_TYPE' OR column_name is null then
108: IF new_references.tracking_type <> UPPER(new_references.tracking_type ) then
109: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
110: IGS_GE_MSG_STACK.ADD;
111: App_Exception.Raise_Exception;
112: END IF;
113: END IF;
114:
115: IF upper(Column_name) = 'PANEL_CHAIR_IND' OR column_name is null then
116: IF new_references.panel_chair_ind <> UPPER(new_references.panel_chair_ind) OR
117: new_references.panel_chair_ind NOT IN ( 'Y' , 'N' ) 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: END IF;
123:
124: IF upper(Column_name) = 'CLOSED_IND' OR column_name is null THEN
125: IF new_references.closed_ind <> UPPER(new_references.closed_ind ) OR
126: new_references.closed_ind NOT IN ( 'Y' , 'N' ) 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: END IF;
141: ELSE
142: IF NOT IGS_TR_TYPE_PKG.Get_PK_For_Validation (
143: new_references.tracking_type
144: ) THEN
145: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
146: IGS_GE_MSG_STACK.ADD;
147: App_Exception.Raise_Exception;
148: END IF;
149: END IF;
221: BeforeRowInsertUpdate ( p_inserting => TRUE );
222: IF Get_PK_For_Validation(
223: new_references.panel_member_type
224: )THEN
225: Fnd_Message.Set_Name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
226: IGS_GE_MSG_STACK.ADD;
227: App_Exception.Raise_Exception;
228: END IF;
229: Check_Constraints;
239: ELSIF (p_action = 'VALIDATE_INSERT') THEN
240: IF Get_PK_For_Validation(
241: new_references.panel_member_type
242: )THEN
243: Fnd_Message.Set_Name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
244: IGS_GE_MSG_STACK.ADD;
245: App_Exception.Raise_Exception;
246: END IF;
247: Check_Constraints;
282: if X_LAST_UPDATE_LOGIN is NULL then
283: X_LAST_UPDATE_LOGIN := -1;
284: end if;
285: else
286: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
287: IGS_GE_MSG_STACK.ADD;
288: app_exception.raise_exception;
289: end if;
290:
362: open c1;
363: fetch c1 into tlinfo;
364: if (c1%notfound) then
365: close c1;
366: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
367: app_exception.raise_exception;
368: return;
369: end if;
370: close c1;
377: AND (X_TRACKING_TYPE is null)))
378: ) then
379: null;
380: else
381: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
382: app_exception.raise_exception;
383: end if;
384: return;
385: end LOCK_ROW;
410: if X_LAST_UPDATE_LOGIN is NULL then
411: X_LAST_UPDATE_LOGIN := -1;
412: end if;
413: else
414: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
415: IGS_GE_MSG_STACK.ADD;
416: app_exception.raise_exception;
417: end if;
418: