DBA Data[Home] [Help]

APPS.IGS_CA_DA_PKG dependencies on FND_MESSAGE

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

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

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

83: new_references.s_cal_cat:= column_value;
84: END IF;
85: if upper(column_name) = 'CLOSED_IND' or column_name is null Then
86: if new_references.closed_ind NOT IN ('Y', 'N') Then
87: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
88: IGS_GE_MSG_STACK.ADD;
89: App_Exception.Raise_Exception;
90: end if;
91: end if;

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

90: end if;
91: end if;
92: if upper(column_name) = 'ABBREVIATION' or column_name is null Then
93: if new_references.abbreviation <> UPPER( new_references.abbreviation) then
94: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
95: IGS_GE_MSG_STACK.ADD;
96: App_Exception.Raise_Exception;
97: end if;
98: end if;

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

97: end if;
98: end if;
99: if upper(column_name) = 'DT_ALIAS' or column_name is null Then
100: if new_references.dt_alias <> UPPER( new_references.dt_alias) then
101: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
102: IGS_GE_MSG_STACK.ADD;
103: App_Exception.Raise_Exception;
104: end if;
105: end if;

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

104: end if;
105: end if;
106: if upper(column_name) = 'DT_CAT' or column_name is null Then
107: if new_references.dt_cat <> UPPER( new_references.dt_cat) then
108: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
109: IGS_GE_MSG_STACK.ADD;
110: App_Exception.Raise_Exception;
111: end if;
112: end if;

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

111: end if;
112: end if;
113: if upper(column_name) = 'S_CAL_CAT' or column_name is null Then
114: if new_references.s_cal_cat <> UPPER( new_references.s_cal_cat) then
115: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
116: IGS_GE_MSG_STACK.ADD;
117: App_Exception.Raise_Exception;
118: end if;
119: end if;

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

128: ELSE
129: IF NOT IGS_CA_DA_CAT_PKG.Get_PK_For_Validation (
130: new_references.dt_cat
131: ) THEN
132: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
133: IGS_GE_MSG_STACK.ADD;
134: App_Exception.Raise_Exception;
135: END IF;
136:

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

143: IF NOT IGS_LOOKUPS_VIEW_PKG.Get_PK_For_Validation (
144: 'CAL_CAT',
145: new_references.s_cal_cat
146: )THEN
147: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
148: IGS_GE_MSG_STACK.ADD;
149: App_Exception.Raise_Exception;
150: END IF;
151:

Line 261: Fnd_Message.Set_Name ('IGS', 'IGS_CA_DA_DAC_FK');

257: Open cur_rowid;
258: Fetch cur_rowid INTO lv_rowid;
259: IF (cur_rowid%FOUND) THEN
260: Close cur_rowid;
261: Fnd_Message.Set_Name ('IGS', 'IGS_CA_DA_DAC_FK');
262: IGS_GE_MSG_STACK.ADD;
263: App_Exception.Raise_Exception;
264: Return;
265: END IF;

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

313: IF (p_action = 'INSERT') THEN
314: -- Call all the procedures related to Before Insert.
315: IF Get_PK_For_Validation (
316: new_references.dt_alias )THEN
317: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
318: IGS_GE_MSG_STACK.ADD;
319: App_Exception.Raise_Exception;
320: END IF;
321: Check_Constraints;

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

322: Check_Parent_Existance;
323: ELSIF (p_action = 'VALIDATE_INSERT') THEN
324: IF Get_PK_For_Validation (
325: new_references.dt_alias )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 378: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');

374: if X_LAST_UPDATE_LOGIN is NULL then
375: X_LAST_UPDATE_LOGIN := -1;
376: end if;
377: else
378: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
379: IGS_GE_MSG_STACK.ADD;
380: app_exception.raise_exception;
381: end if;
382: Before_DML (

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

460: open c1;
461: fetch c1 into tlinfo;
462: if (c1%notfound) then
463: close c1;
464: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
465: IGS_GE_MSG_STACK.ADD;
466: app_exception.raise_exception;
467: return;
468: end if;

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

482: AND (X_NOTES is null)))
483: ) then
484: null;
485: else
486: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
487: IGS_GE_MSG_STACK.ADD;
488: app_exception.raise_exception;
489: end if;
490: return;

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

518: if X_LAST_UPDATE_LOGIN is NULL then
519: X_LAST_UPDATE_LOGIN := -1;
520: end if;
521: else
522: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
523: IGS_GE_MSG_STACK.ADD;
524: app_exception.raise_exception;
525: end if;
526: