[Home] [Help]
41: OPEN cur_old_ref_values;
42: FETCH cur_old_ref_values INTO old_references;
43: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
44: CLOSE cur_old_ref_values;
45: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
46: igs_ge_msg_stack.add;
47: app_exception.raise_exception;
48: RETURN;
49: END IF;
169: IF ( get_pk_for_validation(
170: new_references.system_return_class_type
171: )
172: ) THEN
173: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
174: igs_ge_msg_stack.add;
175: app_exception.raise_exception;
176: END IF;
177: ELSIF (p_action = 'DELETE') THEN
182: IF ( get_pk_for_validation (
183: new_references.system_return_class_type
184: )
185: ) THEN
186: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
187: igs_ge_msg_stack.add;
188: app_exception.raise_exception;
189: END IF;
190: ELSIF (p_action = 'VALIDATE_DELETE') THEN
234: IF (x_last_update_login IS NULL) THEN
235: x_last_update_login := -1;
236: END IF;
237: ELSE
238: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
239: igs_ge_msg_stack.add;
240: app_exception.raise_exception;
241: END IF;
242:
313:
314: OPEN c1;
315: FETCH c1 INTO tlinfo;
316: IF (c1%notfound) THEN
317: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
318: igs_ge_msg_stack.add;
319: CLOSE c1;
320: app_exception.raise_exception;
321: RETURN;
327: AND (tlinfo.description = x_description)
328: ) THEN
329: NULL;
330: ELSE
331: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
332: igs_ge_msg_stack.add;
333: app_exception.raise_exception;
334: END IF;
335:
373: IF (x_last_update_login IS NULL) THEN
374: x_last_update_login := -1;
375: END IF;
376: ELSE
377: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
378: igs_ge_msg_stack.add;
379: app_exception.raise_exception;
380: END IF;
381: