DBA Data[Home] [Help]

APPS.IGS_AS_SU_ATMPTOUT_H_PKG dependencies on APP_EXCEPTION

Line 58: app_exception.raise_exception;

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;
61:
62: CLOSE cur_old_ref_values;

Line 224: app_exception.raise_exception;

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
228: -- Call all the procedures related to Before Update.

Line 240: app_exception.raise_exception;

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
244: check_constraints;

Line 311: app_exception.raise_exception;

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 (
315: p_action => 'INSERT',

Line 442: app_exception.raise_exception;

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;
446:

Line 531: app_exception.raise_exception;

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;
535: END lock_row;

Line 590: app_exception.raise_exception;

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 (
594: p_action => 'UPDATE',

Line 810: app_exception.raise_exception;

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'

Line 819: app_exception.raise_exception;

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'

Line 828: app_exception.raise_exception;

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'

Line 837: app_exception.raise_exception;

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'

Line 846: app_exception.raise_exception;

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'

Line 855: app_exception.raise_exception;

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'

Line 864: app_exception.raise_exception;

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'

Line 873: app_exception.raise_exception;

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'

Line 882: app_exception.raise_exception;

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'

Line 891: app_exception.raise_exception;

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:
895: IF UPPER (column_name) = 'CI_SEQUENCE_NUMBER'

Line 901: app_exception.raise_exception;

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;
905: END igs_as_su_atmptout_h_pkg;