APPS.IGS_PS_OWN_HIST_PKG dependencies on IGS_GE_MSG_STACK

Line 43: IGS_GE_MSG_STACK.ADD;

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

Line 89: IGS_GE_MSG_STACK.ADD;

85: column_name is null THEN
86: IF new_references.course_cd <> UPPER(new_references.course_cd)
87: THEN
88: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
89: IGS_GE_MSG_STACK.ADD;
90: App_Exception.Raise_Exception;
91: END IF;
92: END IF;
93:

Line 111: IGS_GE_MSG_STACK.ADD;

107: new_references.course_cd,
108: new_references.version_number
109: )THEN
110: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
111: IGS_GE_MSG_STACK.ADD;
112: App_Exception.Raise_Exception;
113: END IF;
114: END IF;
115:

Line 127: IGS_GE_MSG_STACK.ADD;

123: new_references.org_unit_cd,
124: new_references.ou_start_dt
125: )THEN
126: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
127: IGS_GE_MSG_STACK.ADD;
128: App_Exception.Raise_Exception;
129: END IF;
130: END IF;
131:

Line 188: IGS_GE_MSG_STACK.ADD;

184: Fetch cur_rowid INTO lv_rowid;
185: IF (cur_rowid%FOUND) THEN
186: Close cur_rowid;
187: Fnd_Message.Set_Name ('IGS', 'IGS_PS_COH_CV_FK');
188: IGS_GE_MSG_STACK.ADD;
189: App_Exception.Raise_Exception;
190: Return;
191: END IF;
192: Close cur_rowid;

Line 216: IGS_GE_MSG_STACK.ADD;

212: Fetch cur_rowid INTO lv_rowid;
213: IF (cur_rowid%FOUND) THEN
214: Close cur_rowid;
215: Fnd_Message.Set_Name ('IGS', 'IGS_PS_COH_OU_FK');
216: IGS_GE_MSG_STACK.ADD;
217: App_Exception.Raise_Exception;
218: Return;
219: END IF;
220: Close cur_rowid;

Line 273: IGS_GE_MSG_STACK.ADD;

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

Line 293: IGS_GE_MSG_STACK.ADD;

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

Line 352: IGS_GE_MSG_STACK.ADD;

348: X_LAST_UPDATE_LOGIN := -1;
349: end if;
350: else
351: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
352: IGS_GE_MSG_STACK.ADD;
353: app_exception.raise_exception;
354: end if;
355: Before_DML (
356: p_action => 'INSERT',

Line 444: IGS_GE_MSG_STACK.ADD;

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

Line 460: IGS_GE_MSG_STACK.ADD;

456: ) then
457: null;
458: else
459: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
460: IGS_GE_MSG_STACK.ADD;
461: app_exception.raise_exception;
462: end if;
463: return;
464: end LOCK_ROW;

Line 497: IGS_GE_MSG_STACK.ADD;

493: X_LAST_UPDATE_LOGIN := -1;
494: end if;
495: else
496: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
497: IGS_GE_MSG_STACK.ADD;
498: app_exception.raise_exception;
499: end if;
500: Before_DML (
501: p_action => 'UPDATE',