DBA Data[Home] [Help]

APPS.IGS_CA_DA_INST_OFCNT_PKG dependencies on FND_MESSAGE

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

39: Open cur_old_ref_values;
40: Fetch cur_old_ref_values INTO old_references;
41: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
42: Close cur_old_ref_values;
43: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
44: IGS_GE_MSG_STACK.ADD;
45: App_Exception.Raise_Exception;
46: Return;
47: END IF;

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

91: IF IGS_CA_VAL_DAIOC.calp_val_sdoct_clsd(
92: new_references.s_dt_offset_constraint_type,
93: v_message_name) = FALSE
94: THEN
95: Fnd_Message.Set_Name('IGS',v_message_name);
96: IGS_GE_MSG_STACK.ADD;
97: APP_EXCEPTION.RAISE_EXCEPTION;
98: END IF;
99:

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

126: new_references.s_dt_offset_constraint_type,
127: new_references.constraint_condition,
128: new_references.constraint_resolution,
129: v_message_name) = FALSE THEN
130: Fnd_Message.Set_Name('IGS',v_message_name);
131: IGS_GE_MSG_STACK.ADD;
132: APP_EXCEPTION.RAISE_EXCEPTION;
133: END IF;
134: END IF;

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

167: end if;
168: If upper(column_name) = 'DAI_SEQUENCE_NUMBER' or column_name is null Then
169: if NEW_REFERENCES.dai_sequence_number <1 OR
170: NEW_REFERENCES.dai_sequence_number > 999999 then
171: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
172: IGS_GE_MSG_STACK.ADD;
173: App_Exception.Raise_Exception;
174: end if;
175: end if;

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

174: end if;
175: end if;
176: if upper(column_name) = 'CAL_TYPE' or column_name is null Then
177: if NEW_REFERENCES.cal_type <> UPPER(NEW_REFERENCES.cal_type )THEN
178: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
179: IGS_GE_MSG_STACK.ADD;
180: App_Exception.Raise_Exception;
181: end if;
182: end if;

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

181: end if;
182: end if;
183: if upper(column_name) = 'DT_ALIAS' or column_name is null Then
184: if NEW_REFERENCES.dt_alias <> UPPER(NEW_REFERENCES.dt_alias)THEN
185: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
186: IGS_GE_MSG_STACK.ADD;
187: App_Exception.Raise_Exception;
188: end if;
189: end if;

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

189: end if;
190:
191: if upper(column_name) = 'OFFSET_CAL_TYPE' or column_name is null Then
192: if NEW_REFERENCES.offset_cal_type <> UPPER(NEW_REFERENCES.offset_cal_type)THEN
193: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
194: IGS_GE_MSG_STACK.ADD;
195: App_Exception.Raise_Exception;
196: end if;
197: end if;

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

196: end if;
197: end if;
198: if upper(column_name) = 'OFFSET_DT_ALIAS' or column_name is null Then
199: if NEW_REFERENCES.offset_dt_alias <> UPPER( NEW_REFERENCES.offset_dt_alias) then
200: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
201: IGS_GE_MSG_STACK.ADD;
202: App_Exception.Raise_Exception;
203: end if;
204: end if;

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

203: end if;
204: end if;
205: if upper(column_name) = 'S_DT_OFFSET_CONSTRAINT_TYPE' or column_name is null Then
206: if NEW_REFERENCES.s_dt_offset_constraint_type <> UPPER( NEW_REFERENCES.s_dt_offset_constraint_type ) then
207: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
208: IGS_GE_MSG_STACK.ADD;
209: App_Exception.Raise_Exception;
210: end if;
211: end if;

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

210: end if;
211: end if;
212: if upper(column_name) = 'CONSTRAINT_CONDITION' or column_name is null Then
213: if NEW_REFERENCES.constraint_condition NOT IN ('MUST' , 'MUST NOT') then
214: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
215: IGS_GE_MSG_STACK.ADD;
216: App_Exception.Raise_Exception;
217: end if;
218: end if;

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

218: end if;
219: If upper(column_name) = 'CONSTRAINT_RESOLUTION' or column_name is null Then
220: if NEW_REFERENCES.constraint_resolution < -9 OR
221: NEW_REFERENCES.constraint_resolution > 9 then
222: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
223: IGS_GE_MSG_STACK.ADD;
224: App_Exception.Raise_Exception;
225: end if;
226: end if;

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

226: end if;
227: If upper(column_name) = 'OFFSET_CI_SEQUENCE_NUMBER ' or column_name is null Then
228: if NEW_REFERENCES.offset_ci_sequence_number < 1 OR
229: NEW_REFERENCES.offset_ci_sequence_number > 999999 then
230: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
231: IGS_GE_MSG_STACK.ADD;
232: App_Exception.Raise_Exception;
233: end if;
234: end if;

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

234: end if;
235: If upper(column_name) = 'OFFSET_DAI_SEQUENCE_NUMBER' or column_name is null Then
236: if NEW_REFERENCES.offset_dai_sequence_number < 1 OR
237: NEW_REFERENCES.offset_dai_sequence_number > 999999 then
238: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
239: IGS_GE_MSG_STACK.ADD;
240: App_Exception.Raise_Exception;
241: end if;
242: end if;

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

242: end if;
243: If upper(column_name) = 'CI_SEQUENCE_NUMBER' or column_name is null Then
244: if NEW_REFERENCES.ci_sequence_number < 1 OR
245: NEW_REFERENCES.ci_sequence_number > 999999 then
246: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
247: IGS_GE_MSG_STACK.ADD;
248: App_Exception.Raise_Exception;
249: end if;
250: end if;

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

282: new_references.offset_dai_sequence_number,
283: new_references.offset_cal_type,
284: new_references.offset_ci_sequence_number
285: ) THEN
286: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
287: IGS_GE_MSG_STACK.ADD;
288: App_Exception.Raise_Exception;
289: END IF;
290:

Line 375: Fnd_Message.Set_Name ('IGS', 'IGS_CA_DAIOC_DAIO_FK');

371: Open cur_rowid;
372: Fetch cur_rowid INTO lv_rowid;
373: IF (cur_rowid%FOUND) THEN
374: Close cur_rowid;
375: Fnd_Message.Set_Name ('IGS', 'IGS_CA_DAIOC_DAIO_FK');
376: IGS_GE_MSG_STACK.ADD;
377: App_Exception.Raise_Exception;
378: Return;
379: END IF;

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

444: new_references.offset_ci_sequence_number ,
445: new_references.offset_dt_alias ,
446: new_references.offset_dai_sequence_number ,
447: new_references.s_dt_offset_constraint_type ) Then
448: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
449: IGS_GE_MSG_STACK.ADD;
450: App_Exception.Raise_Exception;
451: END IF;
452: CHECK_CONSTRAINTS;

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

469: new_references.offset_ci_sequence_number ,
470: new_references.offset_dt_alias ,
471: new_references.offset_dai_sequence_number ,
472: new_references.s_dt_offset_constraint_type ) Then
473: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
474: IGS_GE_MSG_STACK.ADD;
475: App_Exception.Raise_Exception;
476: END IF;
477: CHECK_CONSTRAINTS;

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

545: if X_LAST_UPDATE_LOGIN is NULL then
546: X_LAST_UPDATE_LOGIN := -1;
547: end if;
548: else
549: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
550: IGS_GE_MSG_STACK.ADD;
551: app_exception.raise_exception;
552: end if;
553: Before_DML (

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

645: open c1;
646: fetch c1 into tlinfo;
647: if (c1%notfound) then
648: close c1;
649: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
650: IGS_GE_MSG_STACK.ADD;
651: app_exception.raise_exception;
652: return;
653: end if;

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

657: AND (tlinfo.CONSTRAINT_RESOLUTION = X_CONSTRAINT_RESOLUTION)
658: ) then
659: null;
660: else
661: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
662: IGS_GE_MSG_STACK.ADD;
663: app_exception.raise_exception;
664: end if;
665: return;

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

697: if X_LAST_UPDATE_LOGIN is NULL then
698: X_LAST_UPDATE_LOGIN := -1;
699: end if;
700: else
701: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
702: IGS_GE_MSG_STACK.ADD;
703: app_exception.raise_exception;
704: end if;
705: Before_DML (