APPS.IGS_AD_TAC_LV_OF_COM_PKG dependencies on IGS_GE_MSG_STACK

Line 37: IGS_GE_MSG_STACK.ADD;

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

Line 77: IGS_GE_MSG_STACK.ADD;

73:
74: IF upper(Column_Name) = 'CLOSED_IND' OR Column_Name IS NULL THEN
75: IF new_references.closed_ind NOT IN ('Y','N') THEN
76: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
77: IGS_GE_MSG_STACK.ADD;
78: App_Exception.Raise_Exception;
79: END IF;
80: END IF;
81: IF upper(Column_Name) = 'TAC_LEVEL_OF_COMP' OR Column_Name IS NULL THEN

Line 84: IGS_GE_MSG_STACK.ADD;

80: END IF;
81: IF upper(Column_Name) = 'TAC_LEVEL_OF_COMP' OR Column_Name IS NULL THEN
82: IF new_references.tac_level_of_comp <> UPPER(new_references.tac_level_of_comp) THEN
83: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
84: IGS_GE_MSG_STACK.ADD;
85: App_Exception.Raise_Exception;
86: END IF;
87: END IF;
88: END Check_Constraints;

Line 160: IGS_GE_MSG_STACK.ADD;

156: IF Get_PK_For_Validation (
157: new_references.tac_level_of_comp
158: ) THEN
159: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
160: IGS_GE_MSG_STACK.ADD;
161: App_Exception.Raise_Exception;
162: END IF;
163: Check_Constraints;
164: ELSIF (p_action = 'UPDATE') THEN

Line 174: IGS_GE_MSG_STACK.ADD;

170: IF Get_PK_For_Validation (
171: new_references.tac_level_of_comp
172: ) THEN
173: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
174: IGS_GE_MSG_STACK.ADD;
175: App_Exception.Raise_Exception;
176: END IF;
177: Check_Constraints;
178: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 222: IGS_GE_MSG_STACK.ADD;

218: X_LAST_UPDATE_LOGIN := -1;
219: end if;
220: else
221: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
222: IGS_GE_MSG_STACK.ADD;
223: app_exception.raise_exception;
224: end if;
225: Before_DML (
226: p_action => 'INSERT',

Line 291: IGS_GE_MSG_STACK.ADD;

287: fetch c1 into tlinfo;
288: if (c1%notfound) then
289: close c1;
290: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
291: IGS_GE_MSG_STACK.ADD;
292: app_exception.raise_exception;
293: return;
294: end if;
295: close c1;

Line 304: IGS_GE_MSG_STACK.ADD;

300: null;
301:
302: else
303: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
304: IGS_GE_MSG_STACK.ADD;
305: app_exception.raise_exception;
306: end if;
307: return;
308: end LOCK_ROW;

Line 336: IGS_GE_MSG_STACK.ADD;

332: X_LAST_UPDATE_LOGIN := -1;
333: end if;
334: else
335: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
336: IGS_GE_MSG_STACK.ADD;
337: app_exception.raise_exception;
338: end if;
339: Before_DML (
340: p_action => 'UPDATE',