[Home] [Help]
38: OPEN cur_old_ref_values;
39: FETCH cur_old_ref_values INTO old_references;
40: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
41: CLOSE cur_old_ref_values;
42: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
43: igs_ge_msg_stack.add;
44: app_exception.raise_exception;
45: RETURN;
46: END IF;
93: IF igs_ps_val_crs.crsp_val_iud_crv_dtl (
94: v_course_cd,
95: v_version_number,
96: v_message_name) = FALSE THEN
97: fnd_message.set_name('IGS',v_message_name);
98: igs_ge_msg_stack.add;
99: app_exception.raise_exception;
100: END IF;
101: -- Validate reference code type.
104: (old_references.reference_cd_type <> new_references.reference_cd_type)) THEN
105: IF igs_ps_val_crfc.crsp_val_ref_cd_type(
106: new_references.reference_cd_type,
107: v_message_name) = FALSE THEN
108: fnd_message.set_name('IGS',v_message_name);
109: igs_ge_msg_stack.add;
110: app_exception.raise_exception;
111: END IF;
112: END IF;
131: END IF;
132: END IF;
133: IF p_deleting THEN
134: IF igs_ps_val_atl.chk_mandatory_ref_cd(old_references.reference_cd_type) THEN
135: fnd_message.set_name ('IGS', 'IGS_PS_REF_CD_MANDATORY');
136: igs_ge_msg_stack.add;
137: app_exception.raise_exception;
138: END IF;
139: -- Create history record for deletion
181: new_references.course_cd,
182: new_references.version_number,
183: new_references.reference_cd_type
184: )THEN
185: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
186: igs_ge_msg_stack.add;
187: app_exception.raise_exception;
188: END IF;
189: END check_uniqueness;
205: END IF;
206: IF UPPER(column_name)= 'COURSE_CD' OR
207: column_name IS NULL THEN
208: IF new_references.course_cd <> UPPER(new_references.course_cd) THEN
209: fnd_message.set_name ('IGS', 'IGS_GE_INVALID_VALUE');
210: igs_ge_msg_stack.add;
211: app_exception.raise_exception;
212: END IF;
213: END IF;
214:
215: IF UPPER(column_name)= 'REFERENCE_CD' OR
216: column_name IS NULL THEN
217: IF new_references.reference_cd <> UPPER(new_references.reference_cd) THEN
218: fnd_message.set_name ('IGS', 'IGS_GE_INVALID_VALUE');
219: igs_ge_msg_stack.add;
220: app_exception.raise_exception;
221: END IF;
222: END IF;
223:
224: IF UPPER(column_name)= 'REFERENCE_CD_TYPE' OR
225: column_name IS NULL THEN
226: IF new_references.reference_cd_type <> UPPER(new_references.reference_cd_type) THEN
227: fnd_message.set_name ('IGS', 'IGS_GE_INVALID_VALUE');
228: igs_ge_msg_stack.add;
229: app_exception.raise_exception;
230: END IF;
231: END IF;
244: IF NOT igs_ps_ver_pkg.get_pk_for_validation (
245: new_references.course_cd,
246: new_references.version_number
247: )THEN
248: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
249: igs_ge_msg_stack.add;
250: app_exception.raise_exception;
251: END IF;
252: END IF;
256: NULL;
257: ELSE
258: IF NOT igs_ge_ref_cd_type_pkg.get_pk_for_validation (
259: new_references.reference_cd_type )THEN
260: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
261: igs_ge_msg_stack.add;
262: app_exception.raise_exception;
263: END IF;
264: END IF;
345: OPEN cur_rowid;
346: FETCH cur_rowid INTO lv_rowid;
347: IF (cur_rowid%FOUND) THEN
348: CLOSE cur_rowid;
349: fnd_message.set_name ('IGS', 'IGS_PS_CRFC_CRV_FK');
350: igs_ge_msg_stack.add;
351: app_exception.raise_exception;
352: RETURN;
353: END IF;
371: OPEN cur_rowid;
372: FETCH cur_rowid INTO lv_rowid;
373: IF (cur_rowid%FOUND) THEN
374: CLOSE cur_rowid;
375: fnd_message.set_name ('IGS', 'IGS_PS_CRFC_RCT_FK');
376: igs_ge_msg_stack.add;
377: app_exception.raise_exception;
378: RETURN;
379: END IF;
410: OPEN cur_rowid;
411: FETCH cur_rowid INTO lv_rowid;
412: IF (cur_rowid%FOUND) THEN
413: CLOSE cur_rowid;
414: fnd_message.set_name ('IGS', 'IGS_PS_CRFC_RC_FK');
415: igs_ge_msg_stack.add;
416: app_exception.raise_exception;
417: RETURN;
418: END IF;
460: new_references.version_number ,
461: new_references.reference_cd_type ,
462: new_references.reference_cd
463: ) THEN
464: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
465: igs_ge_msg_stack.add;
466: app_exception.raise_exception;
467: END IF;
468: check_uniqueness;
482: new_references.course_cd ,
483: new_references.version_number ,
484: new_references.reference_cd_type ,
485: new_references.reference_cd ) THEN
486: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
487: igs_ge_msg_stack.add;
488: app_exception.raise_exception;
489: END IF;
490: check_uniqueness;
549: IF x_last_update_login IS NULL THEN
550: x_last_update_login := -1;
551: END IF;
552: ELSE
553: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
554: igs_ge_msg_stack.add;
555: app_exception.raise_exception;
556: END IF;
557: before_dml (
624: OPEN c1;
625: FETCH c1 INTO tlinfo;
626: IF (c1%NOTFOUND) THEN
627: CLOSE c1;
628: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
629: igs_ge_msg_stack.add;
630: app_exception.raise_exception;
631: RETURN;
632: END IF;
637: AND (x_description IS NULL)))
638: ) THEN
639: NULL;
640: ELSE
641: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
642: igs_ge_msg_stack.add;
643: app_exception.raise_exception;
644: END IF;
645: RETURN;
671: IF x_last_update_login IS NULL THEN
672: x_last_update_login := -1;
673: END IF;
674: ELSE
675: fnd_message.set_name('FND', 'SYSTEM-INVALID ARGS');
676: igs_ge_msg_stack.add;
677: app_exception.raise_exception;
678: END IF;
679: before_dml (