DBA Data[Home] [Help]

APPS.IGS_EN_ST_SNAPSHOT_PKG dependencies on APP_EXCEPTION

Line 75: App_Exception.Raise_Exception;

71: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
72: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
73: IGS_GE_MSG_STACK.ADD;
74: Close cur_old_ref_values;
75: App_Exception.Raise_Exception;
76: Return;
77: END IF;
78: Close cur_old_ref_values;
79:

Line 148: App_Exception.Raise_Exception;

144: new_references.snapshot_dt_time
145: ) THEN
146: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
147: IGS_GE_MSG_STACK.ADD;
148: App_Exception.Raise_Exception;
149:
150: END IF;
151: END IF;
152:

Line 174: App_Exception.Raise_Exception;

170: IF (cur_rowid%FOUND) THEN
171: Fnd_Message.Set_Name ('IGS', 'IGS_EN_ESS_ESSC_FK');
172: IGS_GE_MSG_STACK.ADD;
173: Close cur_rowid;
174: App_Exception.Raise_Exception;
175: Return;
176: END IF;
177: Close cur_rowid;
178:

Line 317: App_Exception.Raise_Exception;

313: ) THEN
314:
315: Fnd_message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
316: IGS_GE_MSG_STACK.ADD;
317: App_Exception.Raise_Exception;
318:
319: END IF;
320: Check_Parent_Existance;
321:

Line 334: App_Exception.Raise_Exception;

330: new_references.ESS_ID
331: ) THEN
332: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
333: IGS_GE_MSG_STACK.ADD;
334: App_Exception.Raise_Exception;
335: END IF;
336: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
337: null;
338: ELSIF (p_action = 'VALIDATE_DELETE') THEN

Line 448: app_exception.raise_exception;

444:
445: else
446: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
447: IGS_GE_MSG_STACK.ADD;
448: app_exception.raise_exception;
449: end if;
450:
451: SELECT IGS_EN_ST_SNAPSHOT_ESS_ID_S.Nextval
452: INTO X_ESS_ID

Line 714: app_exception.raise_exception;

710: if (c1%notfound) then
711: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
712: IGS_GE_MSG_STACK.ADD;
713: close c1;
714: app_exception.raise_exception;
715: return;
716: end if;
717: close c1;
718:

Line 777: app_exception.raise_exception;

773: null;
774: else
775: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
776: IGS_GE_MSG_STACK.ADD;
777: app_exception.raise_exception;
778: end if;
779: return;
780: end LOCK_ROW;
781:

Line 850: app_exception.raise_exception;

846: end if;
847: else
848: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
849: IGS_GE_MSG_STACK.ADD;
850: app_exception.raise_exception;
851: end if;
852:
853: Before_DML(
854: p_action=>'UPDATE',