[Home] [Help]
44: OPEN cur_old_ref_values;
45: FETCH cur_old_ref_values INTO old_references;
46: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
47: CLOSE cur_old_ref_values;
48: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
49: igs_ge_msg_stack.add;
50: app_exception.raise_exception;
51: RETURN;
52: END IF;
92: new_references.non_std_usec_dls_id,
93: new_references.deadline_type
94: )
95: ) THEN
96: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
97: igs_ge_msg_stack.add;
98: app_exception.raise_exception;
99: END IF;
100:
117:
118: IF l_c_col_name = 'DEADLINE_TYPE' OR Column_Name IS NULL THEN
119:
120: IF new_references.deadline_type NOT IN ( 'E' , 'R' ) THEN
121: fnd_message.set_name('IGS', 'IGS_GE_INVALID_VALUE');
122: IGS_GE_MSG_STACK.ADD;
123: app_exception.raise_exception;
124: END IF;
125:
128: IF l_c_col_name='CONSTRAINT_RESOLUTION' OR Column_Name IS NULL THEN
129: IF new_references.constraint_resolution < -7 OR
130: new_references.constraint_resolution > 7 OR
131: new_references.constraint_resolution = 0 THEN
132: fnd_message.set_name('IGS', 'IGS_GE_INVALID_VALUE');
133: IGS_GE_MSG_STACK.ADD;
134: app_exception.raise_exception;
135: END IF;
136: END IF;
155: NULL;
156: ELSIF (new_references.deadline_type='E' AND (NOT igs_en_nsu_dlstp_pkg.get_pk_for_validation (
157: new_references.non_std_usec_dls_id
158: ))) THEN
159: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
160: igs_ge_msg_stack.add;
161: app_exception.raise_exception;
162: ELSIF (new_references.deadline_type='R' AND (NOT igs_ps_nsus_rtn_pkg.get_pk_for_validation (
163: new_references.non_std_usec_dls_id
161: app_exception.raise_exception;
162: ELSIF (new_references.deadline_type='R' AND (NOT igs_ps_nsus_rtn_pkg.get_pk_for_validation (
163: new_references.non_std_usec_dls_id
164: ))) THEN
165: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
166: igs_ge_msg_stack.add;
167: app_exception.raise_exception;
168: END IF;
169: END check_parent_existance;
268: OPEN cur_rowid;
269: FETCH cur_rowid INTO lv_rowid;
270: IF (cur_rowid%FOUND) THEN
271: CLOSE cur_rowid;
272: fnd_message.set_name ('IGS', 'IGS_EN_DOSC_NSUD_FK');
273: igs_ge_msg_stack.add;
274: app_exception.raise_exception;
275: RETURN;
276: END IF;
302: OPEN cur_rowid;
303: FETCH cur_rowid INTO lv_rowid;
304: IF (cur_rowid%FOUND) THEN
305: CLOSE cur_rowid;
306: fnd_message.set_name ('IGS', 'IGS_EN_DOSC_NR_FK');
307: igs_ge_msg_stack.add;
308: app_exception.raise_exception;
309: RETURN;
310: END IF;
360: IF ( get_pk_for_validation(
361: new_references.enr_dl_offset_cons_id
362: )
363: ) THEN
364: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
365: igs_ge_msg_stack.add;
366: app_exception.raise_exception;
367: END IF;
368: check_uniqueness;
378: IF ( get_pk_for_validation (
379: new_references.enr_dl_offset_cons_id
380: )
381: ) THEN
382: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
383: igs_ge_msg_stack.add;
384: app_exception.raise_exception;
385: END IF;
386: check_uniqueness;
436: IF (x_last_update_login IS NULL) THEN
437: x_last_update_login := -1;
438: END IF;
439: ELSE
440: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
441: igs_ge_msg_stack.add;
442: app_exception.raise_exception;
443: END IF;
444:
534:
535: OPEN c1;
536: FETCH c1 INTO tlinfo;
537: IF (c1%notfound) THEN
538: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
539: igs_ge_msg_stack.add;
540: CLOSE c1;
541: app_exception.raise_exception;
542: RETURN;
551: AND (tlinfo.deadline_type = x_deadline_type)
552: ) THEN
553: NULL;
554: ELSE
555: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
556: igs_ge_msg_stack.add;
557: app_exception.raise_exception;
558: END IF;
559:
600: IF (x_last_update_login IS NULL) THEN
601: x_last_update_login := -1;
602: END IF;
603: ELSE
604: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
605: igs_ge_msg_stack.add;
606: app_exception.raise_exception;
607: END IF;
608: