APPS.IGS_CA_DA_CAT_PKG dependencies on IGS_GE_MSG_STACK

Line 35: IGS_GE_MSG_STACK.ADD;

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

Line 70: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');IGS_GE_MSG_STACK.ADD;

66: new_references.dt_cat:= column_value;
67: end if;
68: if upper(column_name) = 'DT_CAT' or column_name is null Then
69: if new_references.dt_cat <> UPPER( new_references.dt_cat) then
70: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');IGS_GE_MSG_STACK.ADD;
71: IGS_GE_MSG_STACK.ADD;
72: App_Exception.Raise_Exception;
73: end if;
74: end if;

Line 71: IGS_GE_MSG_STACK.ADD;

67: end if;
68: if upper(column_name) = 'DT_CAT' or column_name is null Then
69: if new_references.dt_cat <> UPPER( new_references.dt_cat) then
70: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');IGS_GE_MSG_STACK.ADD;
71: IGS_GE_MSG_STACK.ADD;
72: App_Exception.Raise_Exception;
73: end if;
74: end if;
75:

Line 144: IGS_GE_MSG_STACK.ADD;

140: Null;
141: IF Get_PK_For_Validation (
142: new_references.dt_cat) THEN
143: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
144: IGS_GE_MSG_STACK.ADD;
145: App_Exception.Raise_Exception;
146: END IF;
147: Check_Constraints;
148: ELSIF (p_action = 'VALIDATE_INSERT') THEN

Line 152: IGS_GE_MSG_STACK.ADD;

148: ELSIF (p_action = 'VALIDATE_INSERT') THEN
149: IF Get_PK_For_Validation (
150: new_references.dt_cat) THEN
151: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
152: IGS_GE_MSG_STACK.ADD;
153: App_Exception.Raise_Exception;
154: END IF;
155: Check_Constraints;
156: ELSIF (p_action = 'UPDATE') THEN

Line 197: IGS_GE_MSG_STACK.ADD;

193: X_LAST_UPDATE_LOGIN := -1;
194: end if;
195: else
196: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
197: IGS_GE_MSG_STACK.ADD;
198: app_exception.raise_exception;
199: end if;
200: Before_DML (
201: p_action =>'INSERT',

Line 257: IGS_GE_MSG_STACK.ADD;

253: fetch c1 into tlinfo;
254: if (c1%notfound) then
255: close c1;
256: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
257: IGS_GE_MSG_STACK.ADD;
258: app_exception.raise_exception;
259: return;
260: end if;
261: close c1;

Line 268: IGS_GE_MSG_STACK.ADD;

264: ) then
265: null;
266: else
267: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
268: IGS_GE_MSG_STACK.ADD;
269: app_exception.raise_exception;
270:
271: end if;
272: return;

Line 300: IGS_GE_MSG_STACK.ADD;

296: X_LAST_UPDATE_LOGIN := -1;
297: end if;
298: else
299: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
300: IGS_GE_MSG_STACK.ADD;
301: app_exception.raise_exception;
302: end if;
303: Before_DML (
304: p_action =>'UPDATE',