45: OPEN cur_old_ref_values;
46: FETCH cur_old_ref_values INTO old_references;
47: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
48: CLOSE cur_old_ref_values;
49: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
50: igs_ge_msg_stack.add;
51: app_exception.raise_exception;
52: RETURN;
53: END IF;
94: new_references.qual_type,
95: new_references.title
96: )
97: ) THEN
98: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
99: igs_ge_msg_stack.add;
100: app_exception.raise_exception;
101: END IF;
102:
120: NULL;
121: ELSIF NOT igs_uc_applicants_pkg.get_uk_For_validation (
122: new_references.app_no
123: ) THEN
124: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
125: igs_ge_msg_stack.add;
126: app_exception.raise_exception;
127: END IF;
128:
192: OPEN cur_rowid;
193: FETCH cur_rowid INTO lv_rowid;
194: IF (cur_rowid%FOUND) THEN
195: CLOSE cur_rowid;
196: fnd_message.set_name ('IGS', 'IGS_UC_UAFRQA_UCAP_FK');
197: igs_ge_msg_stack.add;
198: app_exception.raise_exception;
199: RETURN;
200: END IF;
306: IF (x_last_update_login IS NULL) THEN
307: x_last_update_login := -1;
308: END IF;
309: ELSE
310: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
311: fnd_message.set_token ('ROUTINE', 'IGS_UC_FORM_QUALS_PKG.INSERT_ROW');
312: igs_ge_msg_stack.add;
313: app_exception.raise_exception;
314: END IF;
307: x_last_update_login := -1;
308: END IF;
309: ELSE
310: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
311: fnd_message.set_token ('ROUTINE', 'IGS_UC_FORM_QUALS_PKG.INSERT_ROW');
312: igs_ge_msg_stack.add;
313: app_exception.raise_exception;
314: END IF;
315:
399:
400: OPEN c1;
401: FETCH c1 INTO tlinfo;
402: IF (c1%notfound) THEN
403: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
404: igs_ge_msg_stack.add;
405: CLOSE c1;
406: app_exception.raise_exception;
407: RETURN;
418: AND ((tlinfo.qual_date = x_qual_date) OR ((tlinfo.qual_date IS NULL) AND (X_qual_date IS NULL)))
419: ) THEN
420: NULL;
421: ELSE
422: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
423: igs_ge_msg_stack.add;
424: app_exception.raise_exception;
425: END IF;
426:
468: IF (x_last_update_login IS NULL) THEN
469: x_last_update_login := -1;
470: END IF;
471: ELSE
472: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
473: fnd_message.set_token ('ROUTINE', 'IGS_UC_FORM_QUALS_PKG.UPDATE_ROW');
474: igs_ge_msg_stack.add;
475: app_exception.raise_exception;
476: END IF;
469: x_last_update_login := -1;
470: END IF;
471: ELSE
472: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
473: fnd_message.set_token ('ROUTINE', 'IGS_UC_FORM_QUALS_PKG.UPDATE_ROW');
474: igs_ge_msg_stack.add;
475: app_exception.raise_exception;
476: END IF;
477: