DBA Data[Home] [Help]

APPS.IGS_EN_PIG_CP_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_PIGECP_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 227: app_exception.raise_exception;

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

Line 243: app_exception.raise_exception;

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

Line 291: app_exception.raise_exception;

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

Line 364: app_exception.raise_exception;

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

Line 378: app_exception.raise_exception;

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

Line 424: app_exception.raise_exception;

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