[Home] [Help]
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;
118:
119: IF (UPPER(column_name) = 'REFERENCE_NUMBER' OR column_name IS NULL) THEN
120: IF NOT (new_references.reference_number BETWEEN 1
121: AND 999999) THEN
122: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
123: igs_ge_msg_stack.add;
124: app_exception.raise_exception;
125: END IF;
126: END IF;
127:
128: IF (UPPER(column_name) = 'SEQUENCE_NUMBER' OR column_name IS NULL) THEN
129: IF NOT (new_references.sequence_number BETWEEN 1
130: AND 999999) THEN
131: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
132: igs_ge_msg_stack.add;
133: app_exception.raise_exception;
134: END IF;
135: END IF;
136:
137: IF (UPPER(column_name) = 'CI_SEQUENCE_NUMBER' OR column_name IS NULL) THEN
138: IF NOT (new_references.ci_sequence_number BETWEEN 1
139: AND 999999) THEN
140: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
141: igs_ge_msg_stack.add;
142: app_exception.raise_exception;
143: END IF;
144: END IF;
166: ELSIF NOT igs_ca_inst_pkg.get_pk_for_validation (
167: new_references.cal_type,
168: new_references.ci_sequence_number
169: ) THEN
170: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
171: igs_ge_msg_stack.add;
172: app_exception.raise_exception;
173: END IF;
174:
180: ELSIF NOT igs_ps_unit_ver_pkg.get_pk_for_validation (
181: new_references.unit_cd,
182: new_references.uv_version_number
183: ) THEN
184: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
185: igs_ge_msg_stack.add;
186: app_exception.raise_exception;
187: END IF;
188:
194: ELSIF NOT igs_ps_ver_pkg.get_pk_for_validation (
195: new_references.course_cd,
196: new_references.cv_version_number
197: ) THEN
198: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
199: igs_ge_msg_stack.add;
200: app_exception.raise_exception;
201: END IF;
202:
214: new_references.correspondence_type,
215: new_references.reference_number,
216: new_references.issue_dt
217: ) THEN
218: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
219: igs_ge_msg_stack.add;
220: app_exception.raise_exception;
221: END IF;
222:
292: OPEN cur_rowid;
293: FETCH cur_rowid INTO lv_rowid;
294: IF (cur_rowid%FOUND) THEN
295: CLOSE cur_rowid;
296: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
297: igs_ge_msg_stack.add;
298: app_exception.raise_exception;
299: RETURN;
300: END IF;
329: OPEN cur_rowid;
330: FETCH cur_rowid INTO lv_rowid;
331: IF (cur_rowid%FOUND) THEN
332: CLOSE cur_rowid;
333: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
334: igs_ge_msg_stack.add;
335: app_exception.raise_exception;
336: RETURN;
337: END IF;
366: OPEN cur_rowid;
367: FETCH cur_rowid INTO lv_rowid;
368: IF (cur_rowid%FOUND) THEN
369: CLOSE cur_rowid;
370: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
371: igs_ge_msg_stack.add;
372: app_exception.raise_exception;
373: RETURN;
374: END IF;
407: OPEN cur_rowid;
408: FETCH cur_rowid INTO lv_rowid;
409: IF (cur_rowid%FOUND) THEN
410: CLOSE cur_rowid;
411: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
412: igs_ge_msg_stack.add;
413: app_exception.raise_exception;
414: RETURN;
415: END IF;
486: new_references.issue_dt,
487: new_references.sequence_number
488: )
489: ) THEN
490: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
491: igs_ge_msg_stack.add;
492: app_exception.raise_exception;
493: END IF;
494: check_constraints;
506: new_references.issue_dt,
507: new_references.sequence_number
508: )
509: ) THEN
510: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
511: igs_ge_msg_stack.add;
512: app_exception.raise_exception;
513: END IF;
514: check_constraints;
590: ELSE
591: x_program_update_date := SYSDATE;
592: END IF;
593: ELSE
594: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
595: igs_ge_msg_stack.add;
596: app_exception.raise_exception;
597: END IF;
598:
726:
727: OPEN c1;
728: FETCH c1 INTO tlinfo;
729: IF (c1%notfound) THEN
730: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
731: igs_ge_msg_stack.add;
732: CLOSE c1;
733: app_exception.raise_exception;
734: RETURN;
746: AND ((tlinfo.other_reference = x_other_reference) OR ((tlinfo.other_reference IS NULL) AND (X_other_reference IS NULL)))
747: ) THEN
748: NULL;
749: ELSE
750: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
751: igs_ge_msg_stack.add;
752: app_exception.raise_exception;
753: END IF;
754:
806: IF (x_last_update_login IS NULL) THEN
807: x_last_update_login := -1;
808: END IF;
809: ELSE
810: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
811: igs_ge_msg_stack.add;
812: app_exception.raise_exception;
813: END IF;
814: