eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AS_SU_SETATMPT_H_PKG dependencies on APP_EXCEPTION

Line 55: APP_EXCEPTION.RAISE_EXCEPTION;

51: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
52: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
53: IGS_GE_MSG_STACK.ADD;
54: Close cur_old_ref_values;
55: APP_EXCEPTION.RAISE_EXCEPTION;
56:
57: Return;
58: END IF;
59: Close cur_old_ref_values;

Line 203: APP_EXCEPTION.RAISE_EXCEPTION;

199: NEW_REFERENCES.hist_start_dt
200: ) THEN
201: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
202: IGS_GE_MSG_STACK.ADD;
203: APP_EXCEPTION.RAISE_EXCEPTION;
204: END IF;
205: Check_Constraints;
206: ELSIF (p_action = 'UPDATE') THEN
207: -- Call all the procedures related to Before Update.

Line 219: APP_EXCEPTION.RAISE_EXCEPTION;

215: NEW_REFERENCES.sequence_number,
216: NEW_REFERENCES.hist_start_dt ) THEN
217: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
218: IGS_GE_MSG_STACK.ADD;
219: APP_EXCEPTION.RAISE_EXCEPTION;
220: END IF;
221: Check_Constraints;
222: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
223: Check_Constraints;

Line 283: APP_EXCEPTION.RAISE_EXCEPTION;

279: end if;
280: else
281: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
282: IGS_GE_MSG_STACK.ADD;
283: APP_EXCEPTION.RAISE_EXCEPTION;
284: end if;
285: --
286: Before_DML(
287: p_action=>'INSERT',

Line 444: APP_EXCEPTION.RAISE_EXCEPTION;

440: fetch c1 into tlinfo;
441: if (c1%notfound) then
442: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
443: IGS_GE_MSG_STACK.ADD;
444: APP_EXCEPTION.RAISE_EXCEPTION;
445: close c1;
446: return;
447: end if;
448: close c1;

Line 504: APP_EXCEPTION.RAISE_EXCEPTION;

500: null;
501: else
502: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
503: IGS_GE_MSG_STACK.ADD;
504: APP_EXCEPTION.RAISE_EXCEPTION;
505: end if;
506: return;
507: end LOCK_ROW;
508: procedure UPDATE_ROW (

Line 555: APP_EXCEPTION.RAISE_EXCEPTION;

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: --
558: Before_DML(
559: p_action=>'UPDATE',

Line 784: APP_EXCEPTION.RAISE_EXCEPTION;

780: column_name is null Then
781: IF new_references.SEQUENCE_NUMBER < 1 OR new_references.SEQUENCE_NUMBER > 999999 Then
782: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
783: IGS_GE_MSG_STACK.ADD;
784: APP_EXCEPTION.RAISE_EXCEPTION;
785: END IF;
786: END IF;
787: IF upper(column_name) = 'STUDENT_CONFIRMED_IND' OR
788: column_name is null Then

Line 792: APP_EXCEPTION.RAISE_EXCEPTION;

788: column_name is null Then
789: IF new_references.STUDENT_CONFIRMED_IND NOT IN ('Y','N') Then
790: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
791: IGS_GE_MSG_STACK.ADD;
792: APP_EXCEPTION.RAISE_EXCEPTION;
793: END IF;
794: END IF;
795: IF upper(column_name) = 'PARENT_SEQUENCE_NUMBER' OR
796: column_name is null Then

Line 800: APP_EXCEPTION.RAISE_EXCEPTION;

796: column_name is null Then
797: IF new_references.PARENT_SEQUENCE_NUMBER < 1 OR new_references.PARENT_SEQUENCE_NUMBER > 999999 Then
798: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
799: IGS_GE_MSG_STACK.ADD;
800: APP_EXCEPTION.RAISE_EXCEPTION;
801: END IF;
802: END IF;
803: IF upper(column_name) = 'PRIMARY_SET_IND' OR
804: column_name is null Then

Line 808: APP_EXCEPTION.RAISE_EXCEPTION;

804: column_name is null Then
805: IF new_references.PRIMARY_SET_IND NOT IN ('Y','N') Then
806: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
807: IGS_GE_MSG_STACK.ADD;
808: APP_EXCEPTION.RAISE_EXCEPTION;
809: END IF;
810: END IF;
811: IF upper(column_name) = 'OVERRIDE_TITLE' OR
812: column_name is null Then

Line 816: APP_EXCEPTION.RAISE_EXCEPTION;

812: column_name is null Then
813: IF new_references.OVERRIDE_TITLE <> UPPER(new_references.OVERRIDE_TITLE) Then
814: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
815: IGS_GE_MSG_STACK.ADD;
816: APP_EXCEPTION.RAISE_EXCEPTION;
817: END IF;
818: END IF;
819: IF upper(column_name) = 'PARENT_UNIT_SET_CD' OR
820: column_name is null Then

Line 824: APP_EXCEPTION.RAISE_EXCEPTION;

820: column_name is null Then
821: IF new_references.PARENT_UNIT_SET_CD <> UPPER(new_references.PARENT_UNIT_SET_CD) Then
822: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
823: IGS_GE_MSG_STACK.ADD;
824: APP_EXCEPTION.RAISE_EXCEPTION;
825: END IF;
826: END IF;
827: IF upper(column_name) = 'PRIMARY_SET_IND' OR
828: column_name is null Then

Line 832: APP_EXCEPTION.RAISE_EXCEPTION;

828: column_name is null Then
829: IF new_references.PRIMARY_SET_IND<> UPPER(new_references.PRIMARY_SET_IND) Then
830: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
831: IGS_GE_MSG_STACK.ADD;
832: APP_EXCEPTION.RAISE_EXCEPTION;
833: END IF;
834: END IF;
835: IF upper(column_name) = 'RQRMNTS_COMPLETE_IND' OR
836: column_name is null Then

Line 840: APP_EXCEPTION.RAISE_EXCEPTION;

836: column_name is null Then
837: IF new_references.RQRMNTS_COMPLETE_IND <> UPPER(new_references.RQRMNTS_COMPLETE_IND) Then
838: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
839: IGS_GE_MSG_STACK.ADD;
840: APP_EXCEPTION.RAISE_EXCEPTION;
841: END IF;
842: END IF;
843: IF upper(column_name) = 'STUDENT_CONFIRMED_IND' OR
844: column_name is null Then

Line 848: APP_EXCEPTION.RAISE_EXCEPTION;

844: column_name is null Then
845: IF new_references.STUDENT_CONFIRMED_IND <> UPPER(new_references.STUDENT_CONFIRMED_IND) Then
846: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
847: IGS_GE_MSG_STACK.ADD;
848: APP_EXCEPTION.RAISE_EXCEPTION;
849: END IF;
850: END IF;
851: IF upper(column_name) = 'COURSE_CD' OR
852: column_name is null Then

Line 856: APP_EXCEPTION.RAISE_EXCEPTION;

852: column_name is null Then
853: IF new_references.COURSE_CD <> UPPER(new_references.COURSE_CD) Then
854: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
855: IGS_GE_MSG_STACK.ADD;
856: APP_EXCEPTION.RAISE_EXCEPTION;
857: END IF;
858: END IF;
859: IF upper(column_name) = 'UNIT_SET_CD' OR
860: column_name is null Then

Line 864: APP_EXCEPTION.RAISE_EXCEPTION;

860: column_name is null Then
861: IF new_references.UNIT_SET_CD <> UPPER(new_references.UNIT_SET_CD) 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: IF upper(column_name) = 'S_COMPLETED_SOURCE_TYPE' OR
868: column_name is null Then

Line 872: APP_EXCEPTION.RAISE_EXCEPTION;

868: column_name is null Then
869: IF new_references.S_COMPLETED_SOURCE_TYPE <> UPPER(new_references.S_COMPLETED_SOURCE_TYPE) Then
870: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
871: IGS_GE_MSG_STACK.ADD;
872: APP_EXCEPTION.RAISE_EXCEPTION;
873: END IF;
874: END IF;
875:
876: IF upper(column_name) = 'VOLUNTARY_END_IND' OR

Line 881: APP_EXCEPTION.RAISE_EXCEPTION;

877: column_name is null Then
878: IF new_references.VOLUNTARY_END_IND <> UPPER(new_references.VOLUNTARY_END_IND) Then
879: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
880: IGS_GE_MSG_STACK.ADD;
881: APP_EXCEPTION.RAISE_EXCEPTION;
882: END IF;
883: END IF;
884: IF upper(column_name) = 'VOLUNTARY_END_IND' OR
885: column_name is null Then

Line 889: APP_EXCEPTION.RAISE_EXCEPTION;

885: column_name is null Then
886: IF new_references.VOLUNTARY_END_IND NOT IN ('Y','N') Then
887: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
888: IGS_GE_MSG_STACK.ADD;
889: APP_EXCEPTION.RAISE_EXCEPTION;
890:
891: END IF;
892: END IF;
893: IF upper(column_name) = 'AUTHORISED_PERSON_ID' OR

Line 898: APP_EXCEPTION.RAISE_EXCEPTION;

894: column_name is null Then
895: IF new_references.AUTHORISED_PERSON_ID < 0 OR new_references.AUTHORISED_PERSON_ID > 9999999999 Then
896: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
897: IGS_GE_MSG_STACK.ADD;
898: APP_EXCEPTION.RAISE_EXCEPTION;
899: END IF;
900: END IF;
901: IF upper(column_name) = 'RQRMNTS_COMPLETE_IND' OR
902: column_name is null Then

Line 906: APP_EXCEPTION.RAISE_EXCEPTION;

902: column_name is null Then
903: IF new_references.RQRMNTS_COMPLETE_IND NOT IN ('Y','N') Then
904: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
905: IGS_GE_MSG_STACK.ADD;
906: APP_EXCEPTION.RAISE_EXCEPTION;
907: END IF;
908: END IF;
909: IF upper(column_name) = 'S_COMPLETED_SOURCE_TYPE' OR
910: column_name is null Then

Line 914: APP_EXCEPTION.RAISE_EXCEPTION;

910: column_name is null Then
911: IF new_references.S_COMPLETED_SOURCE_TYPE NOT IN ('SYSTEM','MANUAL') Then
912: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
913: IGS_GE_MSG_STACK.ADD;
914: APP_EXCEPTION.RAISE_EXCEPTION;
915: END IF;
916: END IF;
917: END Check_Constraints;
918: end IGS_AS_SU_SETATMPT_H_PKG;