52: OPEN cur_old_ref_values;
53: FETCH cur_old_ref_values INTO old_references;
54: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
55: CLOSE cur_old_ref_values;
56: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
57: igs_ge_msg_stack.add;
58: app_exception.raise_exception;
59: RETURN;
60: END IF;
99: new_references.question_id,
100: new_references.application_code
101: )
102: ) THEN
103: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
104: igs_ge_msg_stack.add;
105: app_exception.raise_exception;
106: END IF;
107:
125: NULL;
126: ELSIF NOT igf_ap_appl_setup_pkg.get_pk_for_validation (
127: new_references.question_id
128: ) THEN
129: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
130: igs_ge_msg_stack.add;
131: app_exception.raise_exception;
132: END IF;
133:
136: NULL;
137: ELSIF NOT igf_ap_fa_base_rec_pkg.get_pk_for_validation (
138: new_references.base_id
139: ) THEN
140: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
141: igs_ge_msg_stack.add;
142: app_exception.raise_exception;
143: END IF;
144:
243: OPEN cur_rowid;
244: FETCH cur_rowid INTO lv_rowid;
245: IF (cur_rowid%FOUND) THEN
246: CLOSE cur_rowid;
247: fnd_message.set_name ('IGF', 'IGF_AP_SIA_IAS_FK');
248: igs_ge_msg_stack.add;
249: app_exception.raise_exception;
250: RETURN;
251: END IF;
278: OPEN cur_rowid;
279: FETCH cur_rowid INTO lv_rowid;
280: IF (cur_rowid%FOUND) THEN
281: CLOSE cur_rowid;
282: fnd_message.set_name ('IGF', 'IGF_AP_SIA_FA_DETAIL_FK');
283: igs_ge_msg_stack.add;
284: app_exception.raise_exception;
285: RETURN;
286: END IF;
314: OPEN cur_rowid;
315: FETCH cur_rowid INTO lv_rowid;
316: IF (cur_rowid%FOUND) THEN
317: CLOSE cur_rowid;
318: fnd_message.set_name ('IGF', 'IGF_AP_SIA_FA_DETAIL_FK');
319: igs_ge_msg_stack.add;
320: app_exception.raise_exception;
321: RETURN;
322: END IF;
371: IF ( get_pk_for_validation(
372: new_references.inst_app_id
373: )
374: ) THEN
375: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
376: igs_ge_msg_stack.add;
377: app_exception.raise_exception;
378: END IF;
379: check_uniqueness;
387: IF ( get_pk_for_validation (
388: new_references.inst_app_id
389: )
390: ) THEN
391: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
392: igs_ge_msg_stack.add;
393: app_exception.raise_exception;
394: END IF;
395: check_uniqueness;
444: IF (x_last_update_login IS NULL) THEN
445: x_last_update_login := -1;
446: END IF;
447: ELSE
448: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
449: igs_ge_msg_stack.add;
450: app_exception.raise_exception;
451: END IF;
452: SELECT igf_ap_st_inst_appl_s.nextval INTO x_inst_app_id FROM DUAL;
537:
538: OPEN c1;
539: FETCH c1 INTO tlinfo;
540: IF (c1%notfound) THEN
541: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
542: igs_ge_msg_stack.add;
543: CLOSE c1;
544: app_exception.raise_exception;
545: RETURN;
553: AND ((tlinfo.application_code = x_application_code) OR ((tlinfo.application_code IS NULL) AND (x_application_code IS NULL)))
554: ) THEN
555: NULL;
556: ELSE
557: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
558: igs_ge_msg_stack.add;
559: app_exception.raise_exception;
560: END IF;
561:
602: IF (x_last_update_login IS NULL) THEN
603: x_last_update_login := -1;
604: END IF;
605: ELSE
606: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
607: igs_ge_msg_stack.add;
608: app_exception.raise_exception;
609: END IF;
610: