[Home] [Help]
47: OPEN cur_old_ref_values;
48: FETCH cur_old_ref_values INTO old_references;
49: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
50: CLOSE cur_old_ref_values;
51: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
52: igs_ge_msg_stack.add;
53: app_exception.raise_exception;
54: RETURN;
55: END IF;
167: IF ( get_pk_for_validation(
168: new_references.pocc
169: )
170: ) THEN
171: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
172: igs_ge_msg_stack.add;
173: app_exception.raise_exception;
174: END IF;
175: ELSIF (p_action = 'VALIDATE_INSERT') THEN
177: IF ( get_pk_for_validation (
178: new_references.pocc
179: )
180: ) THEN
181: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
182: igs_ge_msg_stack.add;
183: app_exception.raise_exception;
184: END IF;
185: END IF;
233: IF (x_last_update_login IS NULL) THEN
234: x_last_update_login := -1;
235: END IF;
236: ELSE
237: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
238: igs_ge_msg_stack.add;
239: app_exception.raise_exception;
240: END IF;
241:
342:
343: OPEN c1;
344: FETCH c1 INTO tlinfo;
345: IF (c1%notfound) THEN
346: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
347: igs_ge_msg_stack.add;
348: CLOSE c1;
349: app_exception.raise_exception;
350: RETURN;
361: AND ((tlinfo.socio_economic = x_socio_economic) OR ((tlinfo.socio_economic IS NULL) AND (x_socio_economic IS NULL)))
362: ) THEN
363: NULL;
364: ELSE
365: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
366: igs_ge_msg_stack.add;
367: app_exception.raise_exception;
368: END IF;
369:
413: IF (x_last_update_login IS NULL) THEN
414: x_last_update_login := -1;
415: END IF;
416: ELSE
417: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
418: igs_ge_msg_stack.add;
419: app_exception.raise_exception;
420: END IF;
421: