DBA Data[Home] [Help]

APPS.IGS_PR_S_OU_PRG_CONF_PKG dependencies on FND_MESSAGE

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

45: -- Populate Old Values.
46: Open cur_old_ref_values;
47: Fetch cur_old_ref_values INTO old_references;
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:

Line 109: Fnd_Message.Set_Name('IGS',v_message_name);

105: IF IGS_PR_VAL_SOPC.prgp_val_ou_active (
106: new_references.org_unit_cd,
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;

Line 120: Fnd_Message.Set_Name('IGS',v_message_name);

116: new_references.apply_start_dt_alias <> old_references.apply_start_dt_alias) THEN
117: IF igs_pr_val_scpc.prgp_val_da_closed (
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;

Line 131: Fnd_Message.Set_Name('IGS',v_message_name);

127: new_references.apply_end_dt_alias <> old_references.apply_end_dt_alias) THEN
128: IF igs_pr_val_scpc.prgp_val_da_closed (
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;

Line 142: Fnd_Message.Set_Name('IGS',v_message_name);

138: new_references.end_benefit_dt_alias <> old_references.end_benefit_dt_alias) THEN
139: IF igs_pr_val_scpc.prgp_val_da_closed (
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;

Line 153: Fnd_Message.Set_Name('IGS',v_message_name);

149: new_references.end_penalty_dt_alias <> old_references.end_penalty_dt_alias) THEN
150: IF igs_pr_val_scpc.prgp_val_da_closed (
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;

Line 164: Fnd_Message.Set_Name('IGS',v_message_name);

160: new_references.show_cause_ind <> old_references.show_cause_ind) THEN
161: IF IGS_PR_VAL_SOPC.prgp_val_cause_ind (
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;

Line 175: Fnd_Message.Set_Name('IGS',v_message_name);

171: new_references.appeal_ind <> old_references.appeal_ind) THEN
172: IF IGS_PR_VAL_SOPC.prgp_val_cause_ind (
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;

Line 187: Fnd_Message.Set_Name('IGS',v_message_name);

183: IF igs_pr_val_scpc.prgp_val_cause_da (
184: new_references.show_cause_ind,
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;

Line 199: Fnd_Message.Set_Name('IGS',v_message_name);

195: IF igs_pr_val_scpc.prgp_val_appeal_da (
196: new_references.appeal_ind,
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;

Line 212: Fnd_Message.Set_Name('IGS',v_message_name);

208: new_references.org_unit_cd,
209: new_references.ou_start_dt,
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;

Line 225: Fnd_Message.Set_Name('IGS',v_message_name);

221: new_references.org_unit_cd,
222: new_references.ou_start_dt,
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;

Line 237: Fnd_Message.Set_Name('IGS',v_message_name);

233: NVL(old_references.show_cause_cutoff_dt_alias, 'NULL')) THEN
234: IF igs_pr_val_scpc.prgp_val_da_closed (
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;

Line 249: Fnd_Message.Set_Name('IGS',v_message_name);

245: NVL(old_references.appeal_cutoff_dt_alias, 'NULL')) THEN
246: IF igs_pr_val_scpc.prgp_val_da_closed (
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;

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

265: ELSE
266: IF NOT IGS_CA_DA_PKG.Get_PK_For_Validation (
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;

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

278: ELSE
279: IF NOT IGS_CA_DA_PKG.Get_PK_For_Validation (
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;

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

291: ELSE
292: IF NOT IGS_CA_DA_PKG.Get_PK_For_Validation (
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;

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

304: ELSE
305: IF NOT IGS_CA_DA_PKG.Get_PK_For_Validation (
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;

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

317: ELSE
318: IF NOT IGS_CA_DA_PKG.Get_PK_For_Validation (
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;

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

333: IF NOT IGS_OR_UNIT_PKG.Get_PK_For_Validation (
334: new_references.org_unit_cd,
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;

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

346: ELSE
347: IF NOT IGS_CA_DA_PKG.Get_PK_For_Validation (
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;

Line 418: Fnd_Message.Set_Name ('IGS', 'IGS_PR_SOPC_DA_APPEAL_FK');

414:
415: Open cur_rowid;
416: Fetch cur_rowid INTO lv_rowid;
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:

Line 447: Fnd_Message.Set_Name ('IGS', 'IGS_PR_SOPC_OU_FK');

443:
444: Open cur_rowid;
445: Fetch cur_rowid INTO lv_rowid;
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:

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

516: IF Get_PK_For_Validation (
517: new_references.org_unit_cd,
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;

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

536: IF Get_PK_For_Validation (
537: new_references.org_unit_cd ,
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;

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

593: if X_LAST_UPDATE_LOGIN is NULL then
594: X_LAST_UPDATE_LOGIN := -1;
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:

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

728: begin
729: open c1;
730: fetch c1 into tlinfo;
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:

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

761: AND (X_OUTCOME_CHECK_TYPE is null)))
762: ) then
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;

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

807: if X_LAST_UPDATE_LOGIN is NULL then
808: X_LAST_UPDATE_LOGIN := -1;
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:

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

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

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

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

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

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');
1038: IGS_GE_MSG_STACK.ADD;
1039: App_Exception.Raise_Exception ;
1040: END IF;
1041:

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

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

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

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');
1053: IGS_GE_MSG_STACK.ADD;
1054: App_Exception.Raise_Exception ;
1055: END IF;
1056:

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

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

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

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');
1068: IGS_GE_MSG_STACK.ADD;
1069: App_Exception.Raise_Exception ;
1070: END IF;
1071:

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

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

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

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

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

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

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

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

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

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');
1111: IGS_GE_MSG_STACK.ADD;
1112: App_Exception.Raise_Exception ;
1113: END IF;
1114:

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

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

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

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');
1126: IGS_GE_MSG_STACK.ADD;
1127: App_Exception.Raise_Exception ;
1128: END IF;
1129:

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

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

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

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');
1141: IGS_GE_MSG_STACK.ADD;
1142: App_Exception.Raise_Exception ;
1143: END IF;
1144:

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

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

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

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');
1156: IGS_GE_MSG_STACK.ADD;
1157: App_Exception.Raise_Exception ;
1158: END IF;
1159:

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

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

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

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

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

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

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

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

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

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');
1199: IGS_GE_MSG_STACK.ADD;
1200: App_Exception.Raise_Exception ;
1201: END IF;
1202: