APPS.IGS_PS_TCH_RESP_HIST_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 88: IGS_GE_MSG_STACK.ADD;

84: IF upper(column_name) = 'UNIT_CD' OR
85: column_name is null Then
86: IF new_references.unit_cd <> UPPER(new_references.unit_cd) 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;
92:

Line 109: IGS_GE_MSG_STACK.ADD;

105: new_references.org_unit_cd,
106: new_references.ou_start_dt
107: ) THEN
108: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
109: IGS_GE_MSG_STACK.ADD;
110: App_Exception.Raise_Exception;
111: END IF;
112: END IF;
113:

Line 125: IGS_GE_MSG_STACK.ADD;

121: new_references.unit_cd,
122: new_references.version_number
123: ) THEN
124: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
125: IGS_GE_MSG_STACK.ADD;
126: App_Exception.Raise_Exception;
127: END IF;
128: END IF;
129: END Check_Parent_Existance;

Line 184: IGS_GE_MSG_STACK.ADD;

180: Fetch cur_rowid INTO lv_rowid;
181: IF (cur_rowid%FOUND) THEN
182: Close cur_rowid;
183: Fnd_Message.Set_Name ('IGS', 'IGS_PS_TRH_OU_FK');
184: IGS_GE_MSG_STACK.ADD;
185: App_Exception.Raise_Exception;
186: Return;
187: END IF;
188: Close cur_rowid;

Line 212: IGS_GE_MSG_STACK.ADD;

208: Fetch cur_rowid INTO lv_rowid;
209: IF (cur_rowid%FOUND) THEN
210: Close cur_rowid;
211: Fnd_Message.Set_Name ('IGS', 'IGS_PS_TRH_UV_FK');
212: IGS_GE_MSG_STACK.ADD;
213: App_Exception.Raise_Exception;
214: Return;
215: END IF;
216: Close cur_rowid;

Line 270: IGS_GE_MSG_STACK.ADD;

266: new_references.ou_start_dt,
267: new_references.hist_start_dt
268: ) THEN
269: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
270: IGS_GE_MSG_STACK.ADD;
271: App_Exception.Raise_Exception;
272: END IF;
273: Check_Constraints;
274: Check_Parent_Existance;

Line 290: IGS_GE_MSG_STACK.ADD;

286: new_references.ou_start_dt,
287: new_references.hist_start_dt
288: ) THEN
289: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
290: IGS_GE_MSG_STACK.ADD;
291: App_Exception.Raise_Exception;
292: END IF;
293: Check_Constraints;
294: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 348: IGS_GE_MSG_STACK.ADD;

344: X_LAST_UPDATE_LOGIN := -1;
345: end if;
346: else
347: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
348: IGS_GE_MSG_STACK.ADD;
349: app_exception.raise_exception;
350: end if;
351:
352: Before_DML(

Line 441: IGS_GE_MSG_STACK.ADD;

437: fetch c1 into tlinfo;
438: if (c1%notfound) then
439: close c1;
440: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
441: IGS_GE_MSG_STACK.ADD;
442: app_exception.raise_exception;
443: return;
444: end if;
445: close c1;

Line 456: IGS_GE_MSG_STACK.ADD;

452: ) then
453: null;
454: else
455: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
456: IGS_GE_MSG_STACK.ADD;
457: app_exception.raise_exception;
458: end if;
459: return;
460: end LOCK_ROW;

Line 493: IGS_GE_MSG_STACK.ADD;

489: X_LAST_UPDATE_LOGIN := -1;
490: end if;
491: else
492: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
493: IGS_GE_MSG_STACK.ADD;
494: app_exception.raise_exception;
495: end if;
496:
497: Before_DML(