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 IGS_GE_MSG_STACK

Line 53: IGS_GE_MSG_STACK.ADD;

49: Open cur_old_ref_values;
50: Fetch cur_old_ref_values INTO old_references;
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;

Line 202: IGS_GE_MSG_STACK.ADD;

198: NEW_REFERENCES.sequence_number,
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

Line 218: IGS_GE_MSG_STACK.ADD;

214: NEW_REFERENCES.unit_set_cd,
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

Line 282: IGS_GE_MSG_STACK.ADD;

278: X_LAST_UPDATE_LOGIN := -1;
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(

Line 443: IGS_GE_MSG_STACK.ADD;

439: open c1;
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;

Line 503: IGS_GE_MSG_STACK.ADD;

499: ) then
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;

Line 554: IGS_GE_MSG_STACK.ADD;

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: --
558: Before_DML(

Line 783: IGS_GE_MSG_STACK.ADD;

779: IF upper(column_name) = 'SEQUENCE_NUMBER' OR
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

Line 791: IGS_GE_MSG_STACK.ADD;

787: IF upper(column_name) = 'STUDENT_CONFIRMED_IND' OR
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

Line 799: IGS_GE_MSG_STACK.ADD;

795: IF upper(column_name) = 'PARENT_SEQUENCE_NUMBER' OR
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

Line 807: IGS_GE_MSG_STACK.ADD;

803: IF upper(column_name) = 'PRIMARY_SET_IND' OR
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

Line 815: IGS_GE_MSG_STACK.ADD;

811: IF upper(column_name) = 'OVERRIDE_TITLE' OR
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

Line 823: IGS_GE_MSG_STACK.ADD;

819: IF upper(column_name) = 'PARENT_UNIT_SET_CD' OR
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

Line 831: IGS_GE_MSG_STACK.ADD;

827: IF upper(column_name) = 'PRIMARY_SET_IND' OR
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

Line 839: IGS_GE_MSG_STACK.ADD;

835: IF upper(column_name) = 'RQRMNTS_COMPLETE_IND' OR
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

Line 847: IGS_GE_MSG_STACK.ADD;

843: IF upper(column_name) = 'STUDENT_CONFIRMED_IND' OR
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

Line 855: IGS_GE_MSG_STACK.ADD;

851: IF upper(column_name) = 'COURSE_CD' OR
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

Line 863: IGS_GE_MSG_STACK.ADD;

859: IF upper(column_name) = 'UNIT_SET_CD' OR
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

Line 871: IGS_GE_MSG_STACK.ADD;

867: IF upper(column_name) = 'S_COMPLETED_SOURCE_TYPE' OR
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:

Line 880: IGS_GE_MSG_STACK.ADD;

876: IF upper(column_name) = 'VOLUNTARY_END_IND' OR
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

Line 888: IGS_GE_MSG_STACK.ADD;

884: IF upper(column_name) = 'VOLUNTARY_END_IND' OR
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;

Line 897: IGS_GE_MSG_STACK.ADD;

893: IF upper(column_name) = 'AUTHORISED_PERSON_ID' OR
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

Line 905: IGS_GE_MSG_STACK.ADD;

901: IF upper(column_name) = 'RQRMNTS_COMPLETE_IND' OR
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

Line 913: IGS_GE_MSG_STACK.ADD;

909: IF upper(column_name) = 'S_COMPLETED_SOURCE_TYPE' OR
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;