APPS.IGS_PS_TCH_RESP_HIST_PKG dependencies on APP_EXCEPTION

Line 43: App_Exception.Raise_Exception;

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;
47:

Line 89: App_Exception.Raise_Exception;

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:
93: END check_constraints;

Line 110: App_Exception.Raise_Exception;

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:
114: IF (((old_references.unit_cd = new_references.unit_cd) AND

Line 126: App_Exception.Raise_Exception;

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;
130:

Line 185: App_Exception.Raise_Exception;

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;
189:

Line 213: App_Exception.Raise_Exception;

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;
217:

Line 271: App_Exception.Raise_Exception;

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;
275: ELSIF (p_action = 'UPDATE') THEN

Line 291: App_Exception.Raise_Exception;

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
295: Check_Constraints;

Line 349: app_exception.raise_exception;

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(
353: p_action => 'INSERT',

Line 442: app_exception.raise_exception;

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;
446:

Line 457: app_exception.raise_exception;

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;
461:

Line 494: app_exception.raise_exception;

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(
498: p_action => 'INSERT',