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: igs_ge_msg_stack.add;
52: app_exception.raise_exception;
53: RETURN;
54: END IF;
166: IF ( get_pk_for_validation(
167: new_references.document_id_txt
168: )
169: ) THEN
170: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
171: igs_ge_msg_stack.add;
172: app_exception.raise_exception;
173: END IF;
174: ELSIF (p_action = 'VALIDATE_INSERT') THEN
176: IF ( get_pk_for_validation (
177: new_references.document_id_txt
178: )
179: ) THEN
180: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
181: igs_ge_msg_stack.add;
182: app_exception.raise_exception;
183: END IF;
184: END IF;
247: ELSE
248: x_program_update_date := SYSDATE;
249: END IF;
250: ELSE
251: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
252: fnd_message.set_token ('ROUTINE', 'IGF_SL_COD_DOC_DTLS_PKG.INSERT_ROW');
253: igs_ge_msg_stack.add;
254: app_exception.raise_exception;
255: END IF;
248: x_program_update_date := SYSDATE;
249: END IF;
250: ELSE
251: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
252: fnd_message.set_token ('ROUTINE', 'IGF_SL_COD_DOC_DTLS_PKG.INSERT_ROW');
253: igs_ge_msg_stack.add;
254: app_exception.raise_exception;
255: END IF;
256:
360:
361: OPEN c1;
362: FETCH c1 INTO tlinfo;
363: IF (c1%notfound) THEN
364: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
365: igs_ge_msg_stack.add;
366: CLOSE c1;
367: app_exception.raise_exception;
368: RETURN;
377: AND ((tlinfo.full_resp_code = x_full_resp_code) OR ((tlinfo.full_resp_code IS NULL) AND (X_full_resp_code IS NULL)))
378: ) THEN
379: NULL;
380: ELSE
381: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
382: igs_ge_msg_stack.add;
383: app_exception.raise_exception;
384: END IF;
385:
432: IF (x_last_update_login IS NULL) THEN
433: x_last_update_login := -1;
434: END IF;
435: ELSE
436: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
437: fnd_message.set_token ('ROUTINE', 'IGF_SL_COD_DOC_DTLS_PKG.UPDATE_ROW');
438: igs_ge_msg_stack.add;
439: app_exception.raise_exception;
440: END IF;
433: x_last_update_login := -1;
434: END IF;
435: ELSE
436: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
437: fnd_message.set_token ('ROUTINE', 'IGF_SL_COD_DOC_DTLS_PKG.UPDATE_ROW');
438: igs_ge_msg_stack.add;
439: app_exception.raise_exception;
440: END IF;
441: