APPS.IGS_EN_MERGE_ID_LOG_PKG dependencies on IGS_GE_MSG_STACK

Line 42: IGS_GE_MSG_STACK.ADD;

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

Line 87: IGS_GE_MSG_STACK.ADD;

83: IF upper(column_name) = 'PERFORM_ACTION_IND' OR
84: Column_name is null THEN
85: IF new_references.perform_action_ind NOT IN ('Y','N') THEN
86: Fnd_Message.Set_Name ('IGS','IGS_GE_INVALID_VALUE');
87: IGS_GE_MSG_STACK.ADD;
88: App_Exception.Raise_Exception;
89: END IF;
90: END IF;
91:

Line 97: IGS_GE_MSG_STACK.ADD;

93: Column_name is null THEN
94: IF new_references.table_alias <>
95: upper(new_references.table_alias) THEN
96: Fnd_Message.Set_Name ('IGS','IGS_GE_INVALID_VALUE');
97: IGS_GE_MSG_STACK.ADD;
98: App_Exception.Raise_Exception;
99: END IF;
100: END IF;
101:

Line 144: IGS_GE_MSG_STACK.ADD;

140: new_references.table_alias,
141: new_references.action_id
142: )THEN
143: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
144: IGS_GE_MSG_STACK.ADD;
145: App_Exception.Raise_Exception;
146: END IF;
147:
148: END IF;

Line 172: IGS_GE_MSG_STACK.ADD;

168: Fetch cur_rowid INTO lv_rowid;
169: IF (cur_rowid%FOUND) THEN
170: Close cur_rowid;
171: Fnd_Message.Set_Name ('IGS', 'IGS_EN_SMIL_SMIA_FK');
172: IGS_GE_MSG_STACK.ADD;
173: App_Exception.Raise_Exception;
174: Return;
175: END IF;
176: Close cur_rowid;

Line 225: IGS_GE_MSG_STACK.ADD;

221: IF Get_PK_For_Validation (
222: new_references.SMIL_ID
223: ) THEN
224: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
225: IGS_GE_MSG_STACK.ADD;
226: App_Exception.Raise_Exception;
227: END IF;
228: Check_constraints;
229: Check_Parent_Existance;

Line 243: IGS_GE_MSG_STACK.ADD;

239: IF Get_PK_For_Validation (
240: new_references.SMIL_ID
241: ) THEN
242: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
243: IGS_GE_MSG_STACK.ADD;
244: App_Exception.Raise_Exception;
245: END IF;
246: Check_constraints;
247: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 309: IGS_GE_MSG_STACK.ADD;

305: X_LAST_UPDATE_LOGIN := -1;
306: end if;
307: else
308: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
309: IGS_GE_MSG_STACK.ADD;
310: app_exception.raise_exception;
311: end if;
312:
313: SELECT IGS_EN_MERGE_ID_LOG_SMIL_ID_S.Nextval

Line 408: IGS_GE_MSG_STACK.ADD;

404: fetch c1 into tlinfo;
405: if (c1%notfound) then
406: close c1;
407: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
408: IGS_GE_MSG_STACK.ADD;
409: app_exception.raise_exception;
410: return;
411: end if;
412: close c1;

Line 429: IGS_GE_MSG_STACK.ADD;

425: ) then
426: null;
427: else
428: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
429: IGS_GE_MSG_STACK.ADD;
430: app_exception.raise_exception;
431: end if;
432: return;
433: end LOCK_ROW;

Line 466: IGS_GE_MSG_STACK.ADD;

462: X_LAST_UPDATE_LOGIN := -1;
463: end if;
464: else
465: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
466: IGS_GE_MSG_STACK.ADD;
467: app_exception.raise_exception;
468: end if;
469:
470: Before_DML(