46: OPEN cur_old_ref_values;
47: FETCH cur_old_ref_values INTO old_references;
48: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
49: CLOSE cur_old_ref_values;
50: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
51:
52: app_exception.raise_exception;
53: RETURN;
54: END IF;
168: IF ( get_pk_for_validation(
169: new_references.num_scheme_id
170: )
171: ) THEN
172: fnd_message.set_name('IGI','IGI_EXP_DUP_ROW');
173:
174: app_exception.raise_exception;
175: END IF;
176: ELSIF (p_action = 'VALIDATE_INSERT') THEN
178: IF ( get_pk_for_validation (
179: new_references.num_scheme_id
180: )
181: ) THEN
182: fnd_message.set_name('IGI','IGI_EXP_DUP_ROW');
183:
184: app_exception.raise_exception;
185: END IF;
186: 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:
239: app_exception.raise_exception;
240: END IF;
241:
346:
347: OPEN c1;
348: FETCH c1 INTO tlinfo;
349: IF (c1%notfound) THEN
350: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
351:
352: CLOSE c1;
353: app_exception.raise_exception;
354: RETURN;
366: AND ((tlinfo.org_id = x_org_id) OR ((tlinfo.org_id IS NULL) AND (X_org_id IS NULL)))
367: ) THEN
368: NULL;
369: ELSE
370: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
371:
372: app_exception.raise_exception;
373: END IF;
374:
417: IF (x_last_update_login IS NULL) THEN
418: x_last_update_login := -1;
419: END IF;
420: ELSE
421: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
422:
423: app_exception.raise_exception;
424: END IF;
425: