DBA Data[Home] [Help]

APPS.IGS_AS_SU_SETATMPT_H_PKG dependencies on FND_MESSAGE

Line 52: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');

48: -- Populate Old Values.
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:

Line 201: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');

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

Line 217: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');

213: NEW_REFERENCES.course_cd ,
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;

Line 281: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');

277: if X_LAST_UPDATE_LOGIN is NULL then
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: --

Line 442: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

438: begin
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;

Line 502: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');

498: AND (X_CATALOG_SEQ_NUM is null)))
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;

Line 553: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');

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

Line 782: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');

778: END IF;
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;

Line 790: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');

786: END IF;
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;

Line 798: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');

794: END IF;
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;

Line 806: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');

802: END IF;
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;

Line 814: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');

810: END IF;
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;

Line 822: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');

818: END IF;
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;

Line 830: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');

826: END IF;
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;

Line 838: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');

834: END IF;
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;

Line 846: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');

842: END IF;
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;

Line 854: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');

850: END IF;
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;

Line 862: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');

858: END IF;
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;

Line 870: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');

866: END IF;
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;

Line 879: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');

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

Line 887: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');

883: END IF;
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;

Line 896: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');

892: END IF;
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;

Line 904: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');

900: END IF;
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;

Line 912: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');

908: END IF;
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;