[Home] [Help]
42: OPEN cur_old_ref_values;
43: FETCH cur_old_ref_values INTO old_references;
44: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
45: CLOSE cur_old_ref_values;
46: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
47: igs_ge_msg_stack.add;
48: app_exception.raise_exception;
49: RETURN;
50: END IF;
87: new_references.rating_type_id,
88: new_references.rating_scale_id
89: )
90: ) THEN
91: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
92: igs_ge_msg_stack.add;
93: app_exception.raise_exception;
94: END IF;
95:
113: ELSIF NOT igs_ad_apl_rev_prf_pkg.get_pk_for_validation (
114: new_references.appl_rev_profile_id ,
115: 'N'
116: ) THEN
117: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
118: igs_ge_msg_stack.add;
119: app_exception.raise_exception;
120: END IF;
121:
126: new_references.rating_type_id ,
127: 'RATING_TYPE',
128: 'N'
129: ) THEN
130: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
131: igs_ge_msg_stack.add;
132: app_exception.raise_exception;
133: END IF;
134:
138: ELSIF NOT igs_ad_rating_scales_pkg.get_pk_for_validation (
139: new_references.rating_scale_id ,
140: 'N'
141: ) THEN
142: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
143: igs_ge_msg_stack.add;
144: app_exception.raise_exception;
145: END IF;
146:
172: IF c_rating_scale_closed%NOTFOUND THEN
173: null;
174: ELSE
175: IF lv_end_date IS NULL OR lv_end_date >= SYSDATE THEN
176: fnd_message.set_name ('IGS', 'IGS_AD_RAT_SCALE_NOT_END');
177: igs_ge_msg_stack.add;
178: app_exception.raise_exception;
179: RETURN;
180: ELSE
282: OPEN cur_rowid;
283: FETCH cur_rowid INTO lv_rowid;
284: IF (cur_rowid%FOUND) THEN
285: CLOSE cur_rowid;
286: fnd_message.set_name ('IGS', 'IGS_AD_APRSCL_ADAPR_FK');
287: igs_ge_msg_stack.add;
288: app_exception.raise_exception;
289: RETURN;
290: END IF;
317: OPEN cur_rowid;
318: FETCH cur_rowid INTO lv_rowid;
319: IF (cur_rowid%FOUND) THEN
320: CLOSE cur_rowid;
321: fnd_message.set_name ('IGS', 'IGS_AD_APRSCL_ADCC_FK');
322: igs_ge_msg_stack.add;
323: app_exception.raise_exception;
324: RETURN;
325: END IF;
352: OPEN cur_rowid;
353: FETCH cur_rowid INTO lv_rowid;
354: IF (cur_rowid%FOUND) THEN
355: CLOSE cur_rowid;
356: fnd_message.set_name ('IGS', 'IGS_AD_APRSCL_ARS_FK');
357: igs_ge_msg_stack.add;
358: app_exception.raise_exception;
359: RETURN;
360: END IF;
408: IF ( get_pk_for_validation(
409: new_references.appl_revprof_rtscale_id
410: )
411: ) THEN
412: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
413: igs_ge_msg_stack.add;
414: app_exception.raise_exception;
415: END IF;
416: check_uniqueness;
430: IF ( get_pk_for_validation (
431: new_references.appl_revprof_rtscale_id
432: )
433: ) THEN
434: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
435: igs_ge_msg_stack.add;
436: app_exception.raise_exception;
437: END IF;
438: check_uniqueness;
485: IF (x_last_update_login IS NULL) THEN
486: x_last_update_login := -1;
487: END IF;
488: ELSE
489: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
490: igs_ge_msg_stack.add;
491: app_exception.raise_exception;
492: END IF;
493:
570:
571: OPEN c1;
572: FETCH c1 INTO tlinfo;
573: IF (c1%notfound) THEN
574: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
575: igs_ge_msg_stack.add;
576: CLOSE c1;
577: app_exception.raise_exception;
578: RETURN;
585: AND (tlinfo.rating_scale_id = x_rating_scale_id)
586: ) THEN
587: NULL;
588: ELSE
589: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
590: igs_ge_msg_stack.add;
591: app_exception.raise_exception;
592: END IF;
593:
632: IF (x_last_update_login IS NULL) THEN
633: x_last_update_login := -1;
634: END IF;
635: ELSE
636: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
637: igs_ge_msg_stack.add;
638: app_exception.raise_exception;
639: END IF;
640: