DBA Data[Home] [Help]

APPS.IGS_PR_RU_OU_PKG dependencies on FND_MESSAGE

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

47: -- Populate Old Values.
48: Open cur_old_ref_values;
49: Fetch cur_old_ref_values INTO old_references;
50: IF (cur_old_ref_values%NOTFOUND) AND (p_action not in ('INSERT','VALIDATE_INSERT')) THEN
51: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
52: IGS_GE_MSG_STACK.ADD;
53: Close cur_old_ref_values;
54: App_Exception.Raise_Exception;
55:

Line 103: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

99: NEW_REFERENCES.number_of_failures,
100: NEW_REFERENCES.prg_rule_repeat_fail_type,
101: NEW_REFERENCES.rank)
102: THEN
103: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
104: IGS_GE_MSG_STACK.ADD;
105: App_Exception.Raise_Exception;
106:
107: END IF;

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

117: ELSE
118: IF NOT IGS_EN_ATD_TYPE_PKG.Get_PK_For_Validation (
119: new_references.restricted_attendance_type
120: ) THEN
121: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
122: IGS_GE_MSG_STACK.ADD;
123: App_Exception.Raise_Exception;
124: END IF;
125:

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

131: ELSE
132: IF NOT IGS_PS_GRP_PKG.Get_PK_For_Validation (
133: new_references.encmb_course_group_cd
134: ) THEN
135: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
136: IGS_GE_MSG_STACK.ADD;
137: App_Exception.Raise_Exception;
138: END IF;
139:

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

145: ELSE
146: IF NOT IGS_PR_OU_TYPE_PKG.Get_PK_For_Validation (
147: new_references.progression_outcome_type
148: ) THEN
149: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
150: IGS_GE_MSG_STACK.ADD;
151: App_Exception.Raise_Exception;
152: END IF;
153:

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

162: IF NOT IGS_PR_RU_APPL_PKG.Get_PK_For_Validation (
163: new_references.progression_rule_cat,
164: new_references.pra_sequence_number
165: ) THEN
166: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
167: IGS_GE_MSG_STACK.ADD;
168: App_Exception.Raise_Exception;
169: END IF;
170:

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

177: IF NOT IGS_LOOKUPS_VIEW_PKG.Get_PK_For_Validation (
178: 'PRG_RULE_REPEAT_FAIL_TYPE',
179: new_references.prg_rule_repeat_fail_type
180: ) THEN
181: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
182: IGS_GE_MSG_STACK.ADD;
183: App_Exception.Raise_Exception;
184: END IF;
185:

Line 282: Fnd_Message.Set_Name ('IGS', 'IGS_PR_PRO_ATT_FK');

278:
279: Open cur_rowid;
280: Fetch cur_rowid INTO lv_rowid;
281: IF (cur_rowid%FOUND) THEN
282: Fnd_Message.Set_Name ('IGS', 'IGS_PR_PRO_ATT_FK');
283: IGS_GE_MSG_STACK.ADD;
284: Close cur_rowid;
285: App_Exception.Raise_Exception;
286:

Line 309: Fnd_Message.Set_Name ('IGS', 'IGS_PR_PRO_POT_FK');

305:
306: Open cur_rowid;
307: Fetch cur_rowid INTO lv_rowid;
308: IF (cur_rowid%FOUND) THEN
309: Fnd_Message.Set_Name ('IGS', 'IGS_PR_PRO_POT_FK');
310: IGS_GE_MSG_STACK.ADD;
311: Close cur_rowid;
312: App_Exception.Raise_Exception;
313:

Line 338: Fnd_Message.Set_Name ('IGS', 'IGS_PR_PRO_PRA_FK');

334:
335: Open cur_rowid;
336: Fetch cur_rowid INTO lv_rowid;
337: IF (cur_rowid%FOUND) THEN
338: Fnd_Message.Set_Name ('IGS', 'IGS_PR_PRO_PRA_FK');
339: IGS_GE_MSG_STACK.ADD;
340: Close cur_rowid;
341: App_Exception.Raise_Exception;
342:

Line 365: Fnd_Message.Set_Name ('IGS', 'IGS_PR_PRO_SPRRFT_FK');

361:
362: Open cur_rowid;
363: Fetch cur_rowid INTO lv_rowid;
364: IF (cur_rowid%FOUND) THEN
365: Fnd_Message.Set_Name ('IGS', 'IGS_PR_PRO_SPRRFT_FK');
366: IGS_GE_MSG_STACK.ADD;
367: Close cur_rowid;
368: App_Exception.Raise_Exception;
369:

Line 442: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

438: IF Get_PK_For_Validation (
439: new_references.progression_rule_cat,
440: new_references.pra_sequence_number,
441: new_references.sequence_number) THEN
442: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
443: IGS_GE_MSG_STACK.ADD;
444: App_Exception.Raise_Exception;
445:
446: END IF;

Line 464: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

460: IF Get_PK_For_Validation (
461: new_references.progression_rule_cat,
462: new_references.pra_sequence_number,
463: new_references.sequence_number) THEN
464: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
465: IGS_GE_MSG_STACK.ADD;
466: App_Exception.Raise_Exception;
467:
468: END IF;

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

554: if X_LAST_UPDATE_LOGIN is NULL then
555: X_LAST_UPDATE_LOGIN := -1;
556: end if;
557: else
558: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
559: IGS_GE_MSG_STACK.ADD;
560: app_exception.raise_exception;
561: end if;
562: Before_DML (

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

697: begin
698: open c1;
699: fetch c1 into tlinfo;
700: if (c1%notfound) then
701: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
702: IGS_GE_MSG_STACK.ADD;
703: close c1;
704: app_exception.raise_exception;
705:

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

747: AND (X_LOGICAL_DELETE_DT is null)))
748: ) then
749: null;
750: else
751: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
752: IGS_GE_MSG_STACK.ADD;
753: app_exception.raise_exception;
754: end if;
755: return;

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

794: if X_LAST_UPDATE_LOGIN is NULL then
795: X_LAST_UPDATE_LOGIN := -1;
796: end if;
797: else
798: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
799: IGS_GE_MSG_STACK.ADD;
800: app_exception.raise_exception;
801: end if;
802: Before_DML (

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

1026: END IF ;
1027:
1028: IF upper(Column_name) = 'PRA_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
1029: IF new_references.PRA_SEQUENCE_NUMBER < 1 or new_references.PRA_SEQUENCE_NUMBER > 999999 then
1030: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1031: IGS_GE_MSG_STACK.ADD;
1032: App_Exception.Raise_Exception ;
1033: END IF;
1034:

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

1035: END IF ;
1036:
1037: IF upper(Column_name) = 'SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
1038: IF new_references.SEQUENCE_NUMBER < 1 or new_references.SEQUENCE_NUMBER > 999999 then
1039: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1040: IGS_GE_MSG_STACK.ADD;
1041: App_Exception.Raise_Exception ;
1042: END IF;
1043:

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

1044: END IF ;
1045:
1046: IF upper(Column_name) = 'APPLY_AUTOMATICALLY_IND' OR COLUMN_NAME IS NULL THEN
1047: IF new_references.APPLY_AUTOMATICALLY_IND<> upper(new_references.APPLY_AUTOMATICALLY_IND) then
1048: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1049: IGS_GE_MSG_STACK.ADD;
1050: App_Exception.Raise_Exception ;
1051: END IF;
1052:

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

1050: App_Exception.Raise_Exception ;
1051: END IF;
1052:
1053: IF new_references.APPLY_AUTOMATICALLY_IND not in ('Y','N') then
1054: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1055: IGS_GE_MSG_STACK.ADD;
1056: App_Exception.Raise_Exception ;
1057: END IF;
1058:

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

1059: END IF ;
1060:
1061: IF upper(Column_name) = 'OVERRIDE_SHOW_CAUSE_IND' OR COLUMN_NAME IS NULL THEN
1062: IF new_references.OVERRIDE_SHOW_CAUSE_IND<> upper(new_references.OVERRIDE_SHOW_CAUSE_IND) then
1063: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1064: IGS_GE_MSG_STACK.ADD;
1065: App_Exception.Raise_Exception ;
1066: END IF;
1067:

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

1065: App_Exception.Raise_Exception ;
1066: END IF;
1067:
1068: IF new_references.OVERRIDE_SHOW_CAUSE_IND not in ('Y','N') then
1069: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1070: IGS_GE_MSG_STACK.ADD;
1071: App_Exception.Raise_Exception ;
1072: END IF;
1073:

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

1074: END IF ;
1075:
1076: IF upper(Column_name) = 'OVERRIDE_APPEAL_IND' OR COLUMN_NAME IS NULL THEN
1077: IF new_references.OVERRIDE_APPEAL_IND<> upper(new_references.OVERRIDE_APPEAL_IND) then
1078: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1079: IGS_GE_MSG_STACK.ADD;
1080: App_Exception.Raise_Exception ;
1081: END IF;
1082:

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

1080: App_Exception.Raise_Exception ;
1081: END IF;
1082:
1083: IF new_references.OVERRIDE_APPEAL_IND not in ('Y','N') then
1084: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1085: IGS_GE_MSG_STACK.ADD;
1086: App_Exception.Raise_Exception ;
1087: END IF;
1088:

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

1089: END IF ;
1090:
1091: IF upper(Column_name) = 'DURATION' OR COLUMN_NAME IS NULL THEN
1092: IF new_references.DURATION < 1 or new_references.DURATION > 999 then
1093: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1094: IGS_GE_MSG_STACK.ADD;
1095: App_Exception.Raise_Exception ;
1096: END IF;
1097:

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

1098: END IF ;
1099:
1100: IF upper(Column_name) = 'DURATION_TYPE' OR COLUMN_NAME IS NULL THEN
1101: IF new_references.DURATION_TYPE<> upper(new_references.DURATION_TYPE) then
1102: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1103: IGS_GE_MSG_STACK.ADD;
1104: App_Exception.Raise_Exception ;
1105: END IF;
1106:

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

1104: App_Exception.Raise_Exception ;
1105: END IF;
1106:
1107: IF new_references.DURATION_TYPE not in ( 'NORMAL' , 'EFFECTIVE' ) then
1108: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1109: IGS_GE_MSG_STACK.ADD;
1110: App_Exception.Raise_Exception ;
1111: END IF;
1112:

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

1113: END IF ;
1114:
1115: IF upper(Column_name) = 'ENCMB_COURSE_GROUP_CD' OR COLUMN_NAME IS NULL THEN
1116: IF new_references.ENCMB_COURSE_GROUP_CD<> upper(new_references.ENCMB_COURSE_GROUP_CD) then
1117: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1118: IGS_GE_MSG_STACK.ADD;
1119: App_Exception.Raise_Exception ;
1120: END IF;
1121:

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

1122: END IF ;
1123:
1124: IF upper(Column_name) = 'PRG_RULE_REPEAT_FAIL_TYPE' OR COLUMN_NAME IS NULL THEN
1125: IF new_references.PRG_RULE_REPEAT_FAIL_TYPE<> upper(new_references.PRG_RULE_REPEAT_FAIL_TYPE) then
1126: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1127: IGS_GE_MSG_STACK.ADD;
1128: App_Exception.Raise_Exception ;
1129: END IF;
1130:

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

1131: END IF ;
1132:
1133: IF upper(Column_name) = 'PROGRESSION_OUTCOME_TYPE' OR COLUMN_NAME IS NULL THEN
1134: IF new_references.PROGRESSION_OUTCOME_TYPE<> upper(new_references.PROGRESSION_OUTCOME_TYPE) then
1135: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1136: IGS_GE_MSG_STACK.ADD;
1137: App_Exception.Raise_Exception ;
1138: END IF;
1139:

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

1140: END IF ;
1141:
1142: IF upper(Column_name) = 'PROGRESSION_RULE_CAT' OR COLUMN_NAME IS NULL THEN
1143: IF new_references.PROGRESSION_RULE_CAT<> upper(new_references.PROGRESSION_RULE_CAT) then
1144: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1145: IGS_GE_MSG_STACK.ADD;
1146: App_Exception.Raise_Exception ;
1147: END IF;
1148:

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

1149: END IF ;
1150:
1151: IF upper(Column_name) = 'RESTRICTED_ATTENDANCE_TYPE' OR COLUMN_NAME IS NULL THEN
1152: IF new_references.RESTRICTED_ATTENDANCE_TYPE<> upper(new_references.RESTRICTED_ATTENDANCE_TYPE) then
1153: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1154: IGS_GE_MSG_STACK.ADD;
1155: App_Exception.Raise_Exception ;
1156: END IF;
1157:

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

1158: END IF ;
1159:
1160: IF upper(Column_name) = 'RANK' OR COLUMN_NAME IS NULL THEN
1161: IF new_references.RANK < 0 or new_references.RANK > 99 then
1162: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1163: IGS_GE_MSG_STACK.ADD;
1164: App_Exception.Raise_Exception ;
1165: END IF;
1166:

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

1167: END IF ;
1168:
1169: IF upper(Column_name) = 'RESTRICTED_ENROLMENT_CP' OR COLUMN_NAME IS NULL THEN
1170: IF new_references.RESTRICTED_ENROLMENT_CP < 0 or new_references.RESTRICTED_ENROLMENT_CP > 999.999 then
1171: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1172: IGS_GE_MSG_STACK.ADD;
1173: App_Exception.Raise_Exception ;
1174: END IF;
1175: