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_PR_S_OU_PRG_CONF_PKG dependencies on APP_EXCEPTION

Line 52: App_Exception.Raise_Exception;

48: IF (cur_old_ref_values%NOTFOUND) AND (p_action not in ('INSERT','VALIDATE_INSERT')) THEN
49: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
50: IGS_GE_MSG_STACK.ADD;
51: Close cur_old_ref_values;
52: App_Exception.Raise_Exception;
53:
54: Return;
55: END IF;
56: Close cur_old_ref_values;

Line 111: App_Exception.Raise_Exception;

107: new_references.ou_start_dt,
108: v_message_name) = FALSE THEN
109: Fnd_Message.Set_Name('IGS',v_message_name);
110: IGS_GE_MSG_STACK.ADD;
111: App_Exception.Raise_Exception;
112: END IF;
113: END IF;
114: -- Validate the application start date alias
115: IF p_inserting OR (p_updating AND

Line 122: App_Exception.Raise_Exception;

118: new_references.apply_start_dt_alias,
119: v_message_name) = FALSE THEN
120: Fnd_Message.Set_Name('IGS',v_message_name);
121: IGS_GE_MSG_STACK.ADD;
122: App_Exception.Raise_Exception;
123: END IF;
124: END IF;
125: -- Validate the application end date alias
126: IF p_inserting OR (p_updating AND

Line 133: App_Exception.Raise_Exception;

129: new_references.apply_end_dt_alias,
130: v_message_name) = FALSE THEN
131: Fnd_Message.Set_Name('IGS',v_message_name);
132: IGS_GE_MSG_STACK.ADD;
133: App_Exception.Raise_Exception;
134: END IF;
135: END IF;
136: -- Validate the end benefit date alias
137: IF p_inserting OR (p_updating AND

Line 144: App_Exception.Raise_Exception;

140: new_references.end_benefit_dt_alias,
141: v_message_name) = FALSE THEN
142: Fnd_Message.Set_Name('IGS',v_message_name);
143: IGS_GE_MSG_STACK.ADD;
144: App_Exception.Raise_Exception;
145: END IF;
146: END IF;
147: -- Validate the end penalty date alias
148: IF p_inserting OR (p_updating AND

Line 155: App_Exception.Raise_Exception;

151: new_references.end_penalty_dt_alias,
152: v_message_name) = FALSE THEN
153: Fnd_Message.Set_Name('IGS',v_message_name);
154: IGS_GE_MSG_STACK.ADD;
155: App_Exception.Raise_Exception;
156: END IF;
157: END IF;
158: -- Validate the show cause indicator
159: IF p_inserting OR (p_updating AND

Line 166: App_Exception.Raise_Exception;

162: new_references.show_cause_ind,
163: v_message_name) = FALSE THEN
164: Fnd_Message.Set_Name('IGS',v_message_name);
165: IGS_GE_MSG_STACK.ADD;
166: App_Exception.Raise_Exception;
167: END IF;
168: END IF;
169: -- Validate the appeal indicator
170: IF p_inserting OR (p_updating AND

Line 177: App_Exception.Raise_Exception;

173: new_references.appeal_ind,
174: v_message_name) = FALSE THEN
175: Fnd_Message.Set_Name('IGS',v_message_name);
176: IGS_GE_MSG_STACK.ADD;
177: App_Exception.Raise_Exception;
178: END IF;
179: END IF;
180: -- Validate the show cause cut off date alias can only be set when the
181: -- show cause ind indicator is set to Y

Line 189: App_Exception.Raise_Exception;

185: new_references.show_cause_cutoff_dt_alias,
186: v_message_name) = FALSE THEN
187: Fnd_Message.Set_Name('IGS',v_message_name);
188: IGS_GE_MSG_STACK.ADD;
189: App_Exception.Raise_Exception;
190: END IF;
191: END IF;
192: -- Validate the appeal cut off date alias can only be set when the
193: -- appeal ind indicator is set to Y

Line 201: App_Exception.Raise_Exception;

197: new_references.appeal_cutoff_dt_alias,
198: v_message_name) = FALSE THEN
199: Fnd_Message.Set_Name('IGS',v_message_name);
200: IGS_GE_MSG_STACK.ADD;
201: App_Exception.Raise_Exception;
202: END IF;
203: END IF;
204: -- Validate the show cause ind indicator cannot be set to N when there are
205: -- related progression calendar records with show cause length set.

Line 214: App_Exception.Raise_Exception;

210: new_references.show_cause_ind,
211: v_message_name) = FALSE THEN
212: Fnd_Message.Set_Name('IGS',v_message_name);
213: IGS_GE_MSG_STACK.ADD;
214: App_Exception.Raise_Exception;
215: END IF;
216: END IF;
217: -- Validate the appeal ind indicator cannot be set to N when there are
218: -- related progression calendar records with appeallength set.

Line 227: App_Exception.Raise_Exception;

223: new_references.appeal_ind,
224: v_message_name) = FALSE THEN
225: Fnd_Message.Set_Name('IGS',v_message_name);
226: IGS_GE_MSG_STACK.ADD;
227: App_Exception.Raise_Exception;
228: END IF;
229: END IF;
230: -- Validate the show cause cut off date alias
231: IF p_inserting OR (p_updating AND

Line 239: App_Exception.Raise_Exception;

235: new_references.show_cause_cutoff_dt_alias,
236: v_message_name) = FALSE THEN
237: Fnd_Message.Set_Name('IGS',v_message_name);
238: IGS_GE_MSG_STACK.ADD;
239: App_Exception.Raise_Exception;
240: END IF;
241: END IF;
242: -- Validate the appeal cut off date alias
243: IF p_inserting OR (p_updating AND

Line 251: App_Exception.Raise_Exception;

247: new_references.appeal_cutoff_dt_alias,
248: v_message_name) = FALSE THEN
249: Fnd_Message.Set_Name('IGS',v_message_name);
250: IGS_GE_MSG_STACK.ADD;
251: App_Exception.Raise_Exception;
252: END IF;
253: END IF;
254:
255:

Line 271: App_Exception.Raise_Exception;

267: new_references.end_benefit_dt_alias
268: ) THEN
269: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
270: IGS_GE_MSG_STACK.ADD;
271: App_Exception.Raise_Exception;
272: END IF;
273: END IF;
274:
275: IF (((old_references.apply_start_dt_alias = new_references.apply_start_dt_alias)) OR

Line 284: App_Exception.Raise_Exception;

280: new_references.apply_start_dt_alias
281: ) THEN
282: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
283: IGS_GE_MSG_STACK.ADD;
284: App_Exception.Raise_Exception;
285: END IF;
286: END IF;
287:
288: IF (((old_references.show_cause_cutoff_dt_alias = new_references.show_cause_cutoff_dt_alias)) OR

Line 297: App_Exception.Raise_Exception;

293: new_references.show_cause_cutoff_dt_alias
294: ) THEN
295: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
296: IGS_GE_MSG_STACK.ADD;
297: App_Exception.Raise_Exception;
298: END IF;
299: END IF;
300:
301: IF (((old_references.apply_end_dt_alias = new_references.apply_end_dt_alias)) OR

Line 310: App_Exception.Raise_Exception;

306: new_references.apply_end_dt_alias
307: ) THEN
308: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
309: IGS_GE_MSG_STACK.ADD;
310: App_Exception.Raise_Exception;
311: END IF;
312: END IF;
313:
314: IF (((old_references.end_penalty_dt_alias = new_references.end_penalty_dt_alias)) OR

Line 323: App_Exception.Raise_Exception;

319: new_references.end_penalty_dt_alias
320: ) THEN
321: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
322: IGS_GE_MSG_STACK.ADD;
323: App_Exception.Raise_Exception;
324: END IF;
325: END IF;
326:
327: IF (((old_references.org_unit_cd = new_references.org_unit_cd) AND

Line 339: App_Exception.Raise_Exception;

335: new_references.ou_start_dt
336: ) THEN
337: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
338: IGS_GE_MSG_STACK.ADD;
339: App_Exception.Raise_Exception;
340: END IF;
341: END IF;
342:
343: IF (((old_references.appeal_cutoff_dt_alias = new_references.appeal_cutoff_dt_alias)) OR

Line 352: App_Exception.Raise_Exception;

348: new_references.appeal_cutoff_dt_alias
349: ) THEN
350: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
351: IGS_GE_MSG_STACK.ADD;
352: App_Exception.Raise_Exception;
353: END IF;
354: END IF;
355:
356: END Check_Parent_Existance;

Line 421: App_Exception.Raise_Exception;

417: IF (cur_rowid%FOUND) THEN
418: Fnd_Message.Set_Name ('IGS', 'IGS_PR_SOPC_DA_APPEAL_FK');
419: IGS_GE_MSG_STACK.ADD;
420: Close cur_rowid;
421: App_Exception.Raise_Exception;
422:
423: Return;
424: END IF;
425: Close cur_rowid;

Line 450: App_Exception.Raise_Exception;

446: IF (cur_rowid%FOUND) THEN
447: Fnd_Message.Set_Name ('IGS', 'IGS_PR_SOPC_OU_FK');
448: IGS_GE_MSG_STACK.ADD;
449: Close cur_rowid;
450: App_Exception.Raise_Exception;
451:
452: Return;
453: END IF;
454: Close cur_rowid;

Line 522: App_Exception.Raise_Exception;

518: new_references.ou_start_dt
519: ) THEN
520: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
521: IGS_GE_MSG_STACK.ADD;
522: App_Exception.Raise_Exception;
523: END IF;
524: Check_Constraints;
525: Check_Parent_Existance;
526: ELSIF (p_action = 'UPDATE') THEN

Line 542: App_Exception.Raise_Exception;

538: new_references.ou_start_dt
539: ) THEN
540: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
541: IGS_GE_MSG_STACK.ADD;
542: App_Exception.Raise_Exception;
543: END IF;
544: Check_Constraints;
545: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
546: -- Call all the procedures related to Before Update.

Line 599: app_exception.raise_exception;

595: end if;
596: else
597: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
598: IGS_GE_MSG_STACK.ADD;
599: app_exception.raise_exception;
600: end if;
601:
602: Before_DML(
603: p_action => 'INSERT',

Line 735: app_exception.raise_exception;

731: if (c1%notfound) then
732: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
733: IGS_GE_MSG_STACK.ADD;
734: close c1;
735: app_exception.raise_exception;
736:
737: return;
738: end if;
739: close c1;

Line 767: app_exception.raise_exception;

763: null;
764: else
765: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
766: IGS_GE_MSG_STACK.ADD;
767: app_exception.raise_exception;
768: end if;
769: return;
770: end LOCK_ROW;
771:

Line 813: app_exception.raise_exception;

809: end if;
810: else
811: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
812: IGS_GE_MSG_STACK.ADD;
813: app_exception.raise_exception;
814: end if;
815:
816: Before_DML(
817: p_action => 'UPDATE',

Line 1024: App_Exception.Raise_Exception ;

1020: IF upper(Column_name) = 'APPEAL_CUTOFF_DT_ALIAS' OR COLUMN_NAME IS NULL THEN
1021: IF new_references.APPEAL_CUTOFF_DT_ALIAS<> upper(new_references.APPEAL_CUTOFF_DT_ALIAS) then
1022: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1023: IGS_GE_MSG_STACK.ADD;
1024: App_Exception.Raise_Exception ;
1025: END IF;
1026:
1027: END IF ;
1028:

Line 1033: App_Exception.Raise_Exception ;

1029: IF upper(Column_name) = 'APPEAL_IND' OR COLUMN_NAME IS NULL THEN
1030: IF new_references.APPEAL_IND<> upper(new_references.APPEAL_IND) then
1031: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1032: IGS_GE_MSG_STACK.ADD;
1033: App_Exception.Raise_Exception ;
1034: END IF;
1035:
1036: IF new_references.APPEAL_IND not in ('Y','N') then
1037: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

Line 1039: App_Exception.Raise_Exception ;

1035:
1036: IF new_references.APPEAL_IND not in ('Y','N') then
1037: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1038: IGS_GE_MSG_STACK.ADD;
1039: App_Exception.Raise_Exception ;
1040: END IF;
1041:
1042: END IF ;
1043:

Line 1048: App_Exception.Raise_Exception ;

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

Line 1054: App_Exception.Raise_Exception ;

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

Line 1063: App_Exception.Raise_Exception ;

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

Line 1069: App_Exception.Raise_Exception ;

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

Line 1078: App_Exception.Raise_Exception ;

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

Line 1087: App_Exception.Raise_Exception ;

1083: IF upper(Column_name) = 'OUTCOME_CHECK_TYPE' OR COLUMN_NAME IS NULL THEN
1084: IF new_references.OUTCOME_CHECk_TYPE<> upper(new_references.OUTCOME_CHECK_TYPE) then
1085: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1086: IGS_GE_MSG_STACK.ADD;
1087: App_Exception.Raise_Exception ;
1088: END IF;
1089:
1090: END IF ;
1091:

Line 1097: App_Exception.Raise_Exception ;

1093: IF upper(Column_name) = 'APPLY_START_DT_ALIAS' OR COLUMN_NAME IS NULL THEN
1094: IF new_references.APPLY_START_DT_ALIAS<> upper(new_references.APPLY_START_DT_ALIAS) then
1095: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1096: IGS_GE_MSG_STACK.ADD;
1097: App_Exception.Raise_Exception ;
1098: END IF;
1099:
1100: END IF ;
1101:

Line 1106: App_Exception.Raise_Exception ;

1102: IF upper(Column_name) = 'CALCULATE_GPA_IND' OR COLUMN_NAME IS NULL THEN
1103: IF new_references.CALCULATE_GPA_IND<> upper(new_references.CALCULATE_GPA_IND) then
1104: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1105: IGS_GE_MSG_STACK.ADD;
1106: App_Exception.Raise_Exception ;
1107: END IF;
1108:
1109: IF new_references.CALCULATE_GPA_IND not in ('Y','N') then
1110: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

Line 1112: App_Exception.Raise_Exception ;

1108:
1109: IF new_references.CALCULATE_GPA_IND not in ('Y','N') then
1110: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1111: IGS_GE_MSG_STACK.ADD;
1112: App_Exception.Raise_Exception ;
1113: END IF;
1114:
1115: END IF ;
1116:

Line 1121: App_Exception.Raise_Exception ;

1117: IF upper(Column_name) = 'CALCULATE_WAM_IND' OR COLUMN_NAME IS NULL THEN
1118: IF new_references.CALCULATE_WAM_IND<> upper(new_references.CALCULATE_WAM_IND) then
1119: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1120: IGS_GE_MSG_STACK.ADD;
1121: App_Exception.Raise_Exception ;
1122: END IF;
1123:
1124: IF new_references.CALCULATE_WAM_IND not in ('Y','N') then
1125: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

Line 1127: App_Exception.Raise_Exception ;

1123:
1124: IF new_references.CALCULATE_WAM_IND not in ('Y','N') then
1125: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1126: IGS_GE_MSG_STACK.ADD;
1127: App_Exception.Raise_Exception ;
1128: END IF;
1129:
1130: END IF ;
1131:

Line 1136: App_Exception.Raise_Exception ;

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

Line 1142: App_Exception.Raise_Exception ;

1138:
1139: IF new_references.COUNT_EXC_IN_TIME_IND not in ('Y','N') then
1140: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1141: IGS_GE_MSG_STACK.ADD;
1142: App_Exception.Raise_Exception ;
1143: END IF;
1144:
1145: END IF ;
1146:

Line 1151: App_Exception.Raise_Exception ;

1147: IF upper(Column_name) = 'COUNT_SUS_IN_TIME_IND' OR COLUMN_NAME IS NULL THEN
1148: IF new_references.COUNT_SUS_IN_TIME_IND<> upper(new_references.COUNT_SUS_IN_TIME_IND) then
1149: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1150: IGS_GE_MSG_STACK.ADD;
1151: App_Exception.Raise_Exception ;
1152: END IF;
1153:
1154: IF new_references.COUNT_SUS_IN_TIME_IND not in ('Y','N') then
1155: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

Line 1157: App_Exception.Raise_Exception ;

1153:
1154: IF new_references.COUNT_SUS_IN_TIME_IND not in ('Y','N') then
1155: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1156: IGS_GE_MSG_STACK.ADD;
1157: App_Exception.Raise_Exception ;
1158: END IF;
1159:
1160: END IF ;
1161:

Line 1166: App_Exception.Raise_Exception ;

1162: IF upper(Column_name) = 'END_BENEFIT_DT_ALIAS' OR COLUMN_NAME IS NULL THEN
1163: IF new_references.END_BENEFIT_DT_ALIAS<> upper(new_references.END_BENEFIT_DT_ALIAS) then
1164: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1165: IGS_GE_MSG_STACK.ADD;
1166: App_Exception.Raise_Exception ;
1167: END IF;
1168:
1169: END IF ;
1170:

Line 1175: App_Exception.Raise_Exception ;

1171: IF upper(Column_name) = 'END_PENALTY_DT_ALIAS' OR COLUMN_NAME IS NULL THEN
1172: IF new_references.END_PENALTY_DT_ALIAS<> upper(new_references.END_PENALTY_DT_ALIAS) then
1173: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1174: IGS_GE_MSG_STACK.ADD;
1175: App_Exception.Raise_Exception ;
1176: END IF;
1177:
1178: END IF ;
1179:

Line 1185: App_Exception.Raise_Exception ;

1181: IF upper(Column_name) = 'SHOW_CAUSE_CUTOFF_DT_ALIAS' OR COLUMN_NAME IS NULL THEN
1182: IF new_references.SHOW_CAUSE_CUTOFF_DT_ALIAS<> upper(new_references.SHOW_CAUSE_CUTOFF_DT_ALIAS) then
1183: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1184: IGS_GE_MSG_STACK.ADD;
1185: App_Exception.Raise_Exception ;
1186: END IF;
1187:
1188: END IF ;
1189:

Line 1194: App_Exception.Raise_Exception ;

1190: IF upper(Column_name) = 'SHOW_CAUSE_IND' OR COLUMN_NAME IS NULL THEN
1191: IF new_references.SHOW_CAUSE_IND<> upper(new_references.SHOW_CAUSE_IND) then
1192: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1193: IGS_GE_MSG_STACK.ADD;
1194: App_Exception.Raise_Exception ;
1195: END IF;
1196:
1197: IF new_references.SHOW_CAUSE_IND not in ('Y','N') then
1198: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

Line 1200: App_Exception.Raise_Exception ;

1196:
1197: IF new_references.SHOW_CAUSE_IND not in ('Y','N') then
1198: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1199: IGS_GE_MSG_STACK.ADD;
1200: App_Exception.Raise_Exception ;
1201: END IF;
1202:
1203: END IF ;
1204: END Check_Constraints;