DBA Data[Home] [Help]

APPS.IGS_CA_DA_OFST_PKG dependencies on FND_MESSAGE

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

34: Open cur_old_ref_values;
35: Fetch cur_old_ref_values INTO old_references;
36: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
37: Close cur_old_ref_values;
38: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
39: IGS_GE_MSG_STACK.ADD;
40: App_Exception.Raise_Exception;
41: Return;
42: END IF;

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

81: IF IGS_CA_VAL_DAO.calp_val_dao_ins(new_references.dt_alias,
82: new_references.offset_dt_alias,
83: v_message_name) = FALSE
84: THEN
85: Fnd_Message.Set_Name('IGS',v_message_name);
86: IGS_GE_MSG_STACK.ADD;
87: APP_EXCEPTION.RAISE_EXCEPTION;
88: END IF;
89: END IF;

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

112: End if;
113:
114: If upper(Column_name)= 'DAY_OFFSET' Or column_name is null then
115: If new_references.day_offset < -999 or new_references.day_offset > 999 Then
116: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
117: IGS_GE_MSG_STACK.ADD;
118: App_Exception.Raise_Exception;
119: End if;
120: End if;

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

120: End if;
121:
122: If upper(Column_name)= 'WEEK_OFFSET' Or column_name is null then
123: If new_references.week_offset < -99 or new_references.week_offset > 99 Then
124: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
125: IGS_GE_MSG_STACK.ADD;
126: App_Exception.Raise_Exception;
127: End if;
128: End if;

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

128: End if;
129:
130: If upper(Column_name)= 'MONTH_OFFSET' Or column_name is null then
131: If new_references.month_offset < -99 or new_references.month_offset > 99 Then
132: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
133: IGS_GE_MSG_STACK.ADD;
134: App_Exception.Raise_Exception;
135: End if;
136: End if;

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

136: End if;
137:
138: If upper(Column_name)= 'YEAR_OFFSET' Or column_name is null then
139: If new_references.year_offset < -99 or new_references.year_offset > 99 Then
140: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
141: IGS_GE_MSG_STACK.ADD;
142: App_Exception.Raise_Exception;
143: End if;
144: End if;

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

144: End if;
145:
146: If upper(Column_name)= 'DT_ALIAS' Or column_name is null then
147: If UPPER(new_references.dt_alias) <> new_references.dt_alias Then
148: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
149: IGS_GE_MSG_STACK.ADD;
150: App_Exception.Raise_Exception;
151: End if;
152: End if;

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

152: End if;
153:
154: If upper(Column_name)= 'OFFSET_DT_ALIAS' Or column_name is null then
155: If UPPER(new_references.offset_dt_alias) <> new_references.offset_dt_alias Then
156: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
157: IGS_GE_MSG_STACK.ADD;
158: App_Exception.Raise_Exception;
159: End if;
160: End if;

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

172:
173: IF NOT IGS_CA_DA_PKG.Get_PK_For_Validation (
174: new_references.dt_alias
175: ) Then
176: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
177: IGS_GE_MSG_STACK.ADD;
178: app_exception.raise_exception;
179: END IF;
180:

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

186: ELSE
187: IF NOT IGS_CA_DA_PKG.Get_PK_For_Validation (
188: new_references.offset_dt_alias
189: ) Then
190: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
191: IGS_GE_MSG_STACK.ADD;
192: app_exception.raise_exception;
193: END IF;
194: END IF;

Line 254: Fnd_Message.Set_Name ('IGS', 'IGS_CA_DAO_DA_FK');

250: Open cur_rowid;
251: Fetch cur_rowid INTO lv_rowid;
252: IF (cur_rowid%FOUND) THEN
253: Close cur_rowid;
254: Fnd_Message.Set_Name ('IGS', 'IGS_CA_DAO_DA_FK');
255: IGS_GE_MSG_STACK.ADD;
256: App_Exception.Raise_Exception;
257: Return;
258: END IF;

Line 302: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

298: if get_pk_for_validation(
299: x_dt_alias ,
300: x_offset_dt_alias
301: ) Then
302: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
303: IGS_GE_MSG_STACK.ADD;
304: app_exception.raise_exception;
305: end if;
306:

Line 326: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

322: if get_pk_for_validation(
323: x_dt_alias ,
324: x_offset_dt_alias
325: ) Then
326: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
327: IGS_GE_MSG_STACK.ADD;
328: app_exception.raise_exception;
329: end if;
330: check_constraints;

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

388: if X_LAST_UPDATE_LOGIN is NULL then
389: X_LAST_UPDATE_LOGIN := -1;
390: end if;
391: else
392: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
393: IGS_GE_MSG_STACK.ADD;
394: app_exception.raise_exception;
395: end if;
396: Before_DML (

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

472: open c1;
473: fetch c1 into tlinfo;
474: if (c1%notfound) then
475: close c1;
476: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
477: IGS_GE_MSG_STACK.ADD;
478: app_exception.raise_exception;
479: return;
480: end if;

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

494: AND (X_YEAR_OFFSET is null)))
495: ) then
496: null;
497: else
498: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
499: IGS_GE_MSG_STACK.ADD;
500: app_exception.raise_exception;
501: end if;
502: return;

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

529: if X_LAST_UPDATE_LOGIN is NULL then
530: X_LAST_UPDATE_LOGIN := -1;
531: end if;
532: else
533: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
534: IGS_GE_MSG_STACK.ADD;
535: app_exception.raise_exception;
536: end if;
537: Before_DML (