DBA Data[Home] [Help]

APPS.IGS_EN_PIG_S_SETUP_PKG dependencies on APP_EXCEPTION

Line 47: app_exception.raise_exception;

43: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
44: CLOSE cur_old_ref_values;
45: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
46: igs_ge_msg_stack.ADD;
47: app_exception.raise_exception;
48: RETURN;
49: END IF;
50: CLOSE cur_old_ref_values;
51:

Line 93: app_exception.raise_exception;

89: new_references.group_id
90: ) THEN
91: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
92: igs_ge_msg_stack.ADD;
93: app_exception.raise_exception;
94: END IF;
95:
96: END check_parent_existance;
97:

Line 162: app_exception.raise_exception;

158: IF (cur_rowid%FOUND) THEN
159: CLOSE cur_rowid;
160: fnd_message.set_name ('IGS', 'IGS_EN_PIGES_PIG_FK');
161: igs_ge_msg_stack.ADD;
162: app_exception.raise_exception;
163: RETURN;
164: END IF;
165: CLOSE cur_rowid;
166:

Line 176: App_Exception.Raise_Exception;

172: IF ( p_inserting = TRUE OR (p_updating = TRUE AND new_references.group_id <> old_references.group_id ) ) THEN
173: IF NOT IGS_PE_PERSID_GROUP_PKG.val_persid_group(new_references.group_id,p_message_name) THEN
174: Fnd_Message.Set_Name('IGS', p_message_name);
175: IGS_GE_MSG_STACK.ADD;
176: App_Exception.Raise_Exception;
177: END IF;
178: END IF;
179: END BeforeInsertUpdate;
180:

Line 228: app_exception.raise_exception;

224: )
225: ) THEN
226: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
227: igs_ge_msg_stack.ADD;
228: app_exception.raise_exception;
229: END IF;
230: check_parent_existance;
231: ELSIF (p_action = 'UPDATE') THEN
232: -- Call all the procedures related to Before Update.

Line 245: app_exception.raise_exception;

241: )
242: ) THEN
243: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
244: igs_ge_msg_stack.ADD;
245: app_exception.raise_exception;
246: END IF;
247: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
248: BeforeInsertUpdate(FALSE,TRUE);
249: END IF;

Line 293: app_exception.raise_exception;

289: END IF;
290: ELSE
291: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
292: igs_ge_msg_stack.ADD;
293: app_exception.raise_exception;
294: END IF;
295:
296: before_dml(
297: p_action => 'INSERT',

Line 366: app_exception.raise_exception;

362: IF (c1%NOTFOUND) THEN
363: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
364: igs_ge_msg_stack.ADD;
365: CLOSE c1;
366: app_exception.raise_exception;
367: RETURN;
368: END IF;
369: CLOSE c1;
370:

Line 380: app_exception.raise_exception;

376: NULL;
377: ELSE
378: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
379: igs_ge_msg_stack.ADD;
380: app_exception.raise_exception;
381: END IF;
382:
383: RETURN;
384:

Line 426: app_exception.raise_exception;

422: END IF;
423: ELSE
424: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
425: igs_ge_msg_stack.ADD;
426: app_exception.raise_exception;
427: END IF;
428:
429: before_dml(
430: p_action => 'UPDATE',