42: OPEN cur_old_ref_values;
43: FETCH cur_old_ref_values INTO old_references;
44: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
45: CLOSE cur_old_ref_values;
46: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
47: igs_ge_msg_stack.add;
48: app_exception.raise_exception;
49: RETURN;
50: END IF;
174: IF ( get_pk_for_validation(
175: new_references.item_code
176: )
177: ) THEN
178: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
179: igs_ge_msg_stack.add;
180: app_exception.raise_exception;
181: END IF;
182: ELSIF (p_action = 'DELETE') THEN
187: IF ( get_pk_for_validation (
188: new_references.item_code
189: )
190: ) THEN
191: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
192: igs_ge_msg_stack.add;
193: app_exception.raise_exception;
194: END IF;
195: ELSIF (p_action = 'VALIDATE_DELETE') THEN
240: IF (x_last_update_login IS NULL) THEN
241: x_last_update_login := -1;
242: END IF;
243: ELSE
244: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
245: igs_ge_msg_stack.add;
246: app_exception.raise_exception;
247: END IF;
248:
324:
325: OPEN c1;
326: FETCH c1 INTO tlinfo;
327: IF (c1%notfound) THEN
328: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
329: igs_ge_msg_stack.add;
330: CLOSE c1;
331: app_exception.raise_exception;
332: RETURN;
339: AND ((tlinfo.item_category_code = x_item_category_code) OR ((tlinfo.item_category_code IS NULL) AND (x_item_category_code IS NULL)))
340: ) THEN
341: NULL;
342: ELSE
343: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
344: igs_ge_msg_stack.add;
345: app_exception.raise_exception;
346: END IF;
347:
386: IF (x_last_update_login IS NULL) THEN
387: x_last_update_login := -1;
388: END IF;
389: ELSE
390: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
391: igs_ge_msg_stack.add;
392: app_exception.raise_exception;
393: END IF;
394: