[Home] [Help]
52:
53: IF (cur_old_ref_values%NOTFOUND)
54: AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
55: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
56: igs_ge_msg_stack.ADD;
57: CLOSE cur_old_ref_values;
58: app_exception.raise_exception;
59: RETURN;
60: END IF;
219: new_references.hist_start_dt,
220: new_references.uoo_id
221: ) THEN
222: fnd_message.set_name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
223: igs_ge_msg_stack.ADD;
224: app_exception.raise_exception;
225: END IF;
226: check_constraints;
227: ELSIF (p_action = 'UPDATE') THEN
235: new_references.hist_start_dt,
236: new_references.uoo_id
237: ) THEN
238: fnd_message.set_name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
239: igs_ge_msg_stack.ADD;
240: app_exception.raise_exception;
241: END IF;
242: check_constraints;
243: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
306: x_last_update_login := -1;
307: END IF;
308: ELSE
309: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
310: igs_ge_msg_stack.ADD;
311: app_exception.raise_exception;
312: END IF;
313:
314: before_dml (
437: FETCH c1 INTO tlinfo;
438:
439: IF (c1%NOTFOUND) THEN
440: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
441: igs_ge_msg_stack.ADD;
442: app_exception.raise_exception;
443: CLOSE c1;
444: RETURN;
445: END IF;
526: ) THEN
527: NULL;
528: ELSE
529: fnd_message.set_name ('FND', 'FORM_RECORD_CHANGED');
530: igs_ge_msg_stack.ADD;
531: app_exception.raise_exception;
532: END IF;
533:
534: RETURN;
585: x_last_update_login := -1;
586: END IF;
587: ELSE
588: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
589: igs_ge_msg_stack.ADD;
590: app_exception.raise_exception;
591: END IF;
592:
593: before_dml (
805: IF UPPER (column_name) = 'FINALISED_OUTCOME_IND'
806: OR column_name IS NULL THEN
807: IF new_references.finalised_outcome_ind NOT IN ('Y', 'N') THEN
808: fnd_message.set_name ('IGS', 'IGS_GE_INVALID_VALUE');
809: igs_ge_msg_stack.ADD;
810: app_exception.raise_exception;
811: END IF;
812: END IF;
813:
814: IF UPPER (column_name) = 'CAL_TYPE'
815: OR column_name IS NULL THEN
816: IF new_references.cal_type <> UPPER (new_references.cal_type) THEN
817: fnd_message.set_name ('IGS', 'IGS_GE_INVALID_VALUE');
818: igs_ge_msg_stack.ADD;
819: app_exception.raise_exception;
820: END IF;
821: END IF;
822:
823: IF UPPER (column_name) = 'COURSE_CD'
824: OR column_name IS NULL THEN
825: IF new_references.course_cd <> UPPER (new_references.course_cd) THEN
826: fnd_message.set_name ('IGS', 'IGS_GE_INVALID_VALUE');
827: igs_ge_msg_stack.ADD;
828: app_exception.raise_exception;
829: END IF;
830: END IF;
831:
832: IF UPPER (column_name) = 'FINALISED_OUTCOME_IND'
833: OR column_name IS NULL THEN
834: IF new_references.finalised_outcome_ind <> UPPER (new_references.finalised_outcome_ind) THEN
835: fnd_message.set_name ('IGS', 'IGS_GE_INVALID_VALUE');
836: igs_ge_msg_stack.ADD;
837: app_exception.raise_exception;
838: END IF;
839: END IF;
840:
841: IF UPPER (column_name) = 'GRADE'
842: OR column_name IS NULL THEN
843: IF new_references.grade <> UPPER (new_references.grade) THEN
844: fnd_message.set_name ('IGS', 'IGS_GE_INVALID_VALUE');
845: igs_ge_msg_stack.ADD;
846: app_exception.raise_exception;
847: END IF;
848: END IF;
849:
850: IF UPPER (column_name) = 'GRADING_SCHEMA_CD'
851: OR column_name IS NULL THEN
852: IF new_references.grading_schema_cd <> UPPER (new_references.grading_schema_cd) THEN
853: fnd_message.set_name ('IGS', 'IGS_GE_INVALID_VALUE');
854: igs_ge_msg_stack.ADD;
855: app_exception.raise_exception;
856: END IF;
857: END IF;
858:
859: IF UPPER (column_name) = 'S_GRADE_CREATION_METHOD_TYPE'
860: OR column_name IS NULL THEN
861: IF new_references.s_grade_creation_method_type <> UPPER (new_references.s_grade_creation_method_type) THEN
862: fnd_message.set_name ('IGS', 'IGS_GE_INVALID_VALUE');
863: igs_ge_msg_stack.ADD;
864: app_exception.raise_exception;
865: END IF;
866: END IF;
867:
868: IF UPPER (column_name) = 'TRANSLATED_GRADING_SCHEMA_CD'
869: OR column_name IS NULL THEN
870: IF new_references.translated_grading_schema_cd <> UPPER (new_references.translated_grading_schema_cd) THEN
871: fnd_message.set_name ('IGS', 'IGS_GE_INVALID_VALUE');
872: igs_ge_msg_stack.ADD;
873: app_exception.raise_exception;
874: END IF;
875: END IF;
876:
877: IF UPPER (column_name) = 'UNIT_CD'
878: OR column_name IS NULL THEN
879: IF new_references.unit_cd <> UPPER (new_references.unit_cd) THEN
880: fnd_message.set_name ('IGS', 'IGS_GE_INVALID_VALUE');
881: igs_ge_msg_stack.ADD;
882: app_exception.raise_exception;
883: END IF;
884: END IF;
885:
886: IF UPPER (column_name) = 'TRANSLATED_GRADE'
887: OR column_name IS NULL THEN
888: IF new_references.translated_grade <> UPPER (new_references.translated_grade) THEN
889: fnd_message.set_name ('IGS', 'IGS_GE_INVALID_VALUE');
890: igs_ge_msg_stack.ADD;
891: app_exception.raise_exception;
892: END IF;
893: END IF;
894:
896: OR column_name IS NULL THEN
897: IF new_references.ci_sequence_number < 1
898: OR new_references.ci_sequence_number > 99999 THEN
899: fnd_message.set_name ('IGS', 'IGS_GE_INVALID_VALUE');
900: igs_ge_msg_stack.ADD;
901: app_exception.raise_exception;
902: END IF;
903: END IF;
904: END check_constraints;