[Home] [Help]
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;
43: Close cur_old_ref_values;
44:
79: new_references.ceremony_number
80: ) THEN
81: FND_MESSAGE.SET_NAME ('FND', 'FORM_RECORD_DELETED');
82: IGS_GE_MSG_STACK.ADD;
83: APP_EXCEPTION.RAISE_EXCEPTION;
84: END IF;
85:
86: END IF;
87:
93: new_references.grd_note_type
94: ) THEN
95: FND_MESSAGE.SET_NAME ('FND', 'FORM_RECORD_DELETED');
96: IGS_GE_MSG_STACK.ADD;
97: APP_EXCEPTION.RAISE_EXCEPTION;
98: END IF;
99:
100: END IF;
101:
107: new_references.reference_number
108: ) THEN
109: FND_MESSAGE.SET_NAME ('FND', 'FORM_RECORD_DELETED');
110: IGS_GE_MSG_STACK.ADD;
111: APP_EXCEPTION.RAISE_EXCEPTION;
112: END IF;
113:
114: END IF;
115:
136: IF upper(Column_name) = 'GRD_CI_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
137: IF new_references.GRD_CI_SEQUENCE_NUMBER <1 OR NEW_REFERENCES.GRD_CI_SEQUENCE_NUMBER > 999999 then
138: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
139: IGS_GE_MSG_STACK.ADD;
140: App_Exception.Raise_Exception ;
141: END IF;
142: END IF ;
143:
144: IF upper(Column_name) = 'GRD_CAL_TYPE' OR COLUMN_NAME IS NULL THEN
144: IF upper(Column_name) = 'GRD_CAL_TYPE' OR COLUMN_NAME IS NULL THEN
145: IF new_references.GRD_CAL_TYPE<> upper(NEW_REFERENCES.GRD_CAL_TYPE) then
146: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
147: IGS_GE_MSG_STACK.ADD;
148: App_Exception.Raise_Exception ;
149: END IF;
150:
151: END IF ;
152:
153: IF upper(Column_name) = 'GRD_NOTE_TYPE' OR COLUMN_NAME IS NULL THEN
154: IF new_references.GRD_NOTE_TYPE<> upper(NEW_REFERENCES.GRD_NOTE_TYPE) then
155: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
156: IGS_GE_MSG_STACK.ADD;
157: App_Exception.Raise_Exception ;
158: END IF;
159:
160: END IF ;
161: END;
213: IF (cur_rowid%FOUND) THEN
214: Close cur_rowid;
215: Fnd_Message.Set_Name ('IGS', 'IGS_GR_GCN_GC_FK');
216: IGS_GE_MSG_STACK.ADD;
217: App_Exception.Raise_Exception;
218: Return;
219: END IF;
220: Close cur_rowid;
221:
239: IF (cur_rowid%FOUND) THEN
240: Close cur_rowid;
241: Fnd_Message.Set_Name ('IGS', 'IGS_GR_GCN_GNT_FK');
242: IGS_GE_MSG_STACK.ADD;
243: App_Exception.Raise_Exception;
244: Return;
245: END IF;
246: Close cur_rowid;
247:
265: IF (cur_rowid%FOUND) THEN
266: Close cur_rowid;
267: Fnd_Message.Set_Name ('IGS', 'IGS_GR_GCN_NOTE_FK');
268: IGS_GE_MSG_STACK.ADD;
269: App_Exception.Raise_Exception;
270: Return;
271: END IF;
272: Close cur_rowid;
273:
315: NEW_REFERENCES.reference_number
316: ) THEN
317: Fnd_Message.Set_Name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
318: IGS_GE_MSG_STACK.ADD;
319: App_Exception.Raise_Exception;
320: END IF;
321:
322: check_constraints;
323: Check_Parent_Existance;
334: NEW_REFERENCES.reference_number
335: ) THEN
336: Fnd_Message.Set_Name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
337: IGS_GE_MSG_STACK.ADD;
338: App_Exception.Raise_Exception;
339: END IF;
340:
341: check_constraints;
342: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
380: end if;
381: else
382: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
383: IGS_GE_MSG_STACK.ADD;
384: app_exception.raise_exception;
385: end if;
386:
387: Before_DML (
388: p_action => 'INSERT',
455: fetch c1 into tlinfo;
456: if (c1%notfound) then
457: close c1;
458: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
459: app_exception.raise_exception;
460: return;
461: end if;
462: close c1;
463:
466: ) then
467: null;
468: else
469: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
470: app_exception.raise_exception;
471: end if;
472: return;
473: end LOCK_ROW;
474:
500: end if;
501: else
502: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
503: IGS_GE_MSG_STACK.ADD;
504: app_exception.raise_exception;
505: end if;
506:
507: Before_DML (
508: p_action => 'UPDATE',