DBA Data[Home] [Help]

APPS.IGS_HE_SUB_RTN_QUAL_PKG dependencies on APP_EXCEPTION

Line 56: app_exception.raise_exception;

52: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
53: CLOSE cur_old_ref_values;
54: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
55: igs_ge_msg_stack.add;
56: app_exception.raise_exception;
57: RETURN;
58: END IF;
59: CLOSE cur_old_ref_values;
60:

Line 116: app_exception.raise_exception;

112: new_references.return_name
113: ) THEN
114: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
115: igs_ge_msg_stack.add;
116: app_exception.raise_exception;
117: END IF;
118:
119: END check_parent_existance;
120:

Line 216: app_exception.raise_exception;

212: IF (cur_rowid%FOUND) THEN
213: CLOSE cur_rowid;
214: fnd_message.set_name ('IGS', 'IGS_HE_HSRQ_HSR_FK');
215: igs_ge_msg_stack.add;
216: app_exception.raise_exception;
217: RETURN;
218: END IF;
219: CLOSE cur_rowid;
220:

Line 290: app_exception.raise_exception;

286: )
287: ) THEN
288: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
289: igs_ge_msg_stack.add;
290: app_exception.raise_exception;
291: END IF;
292: check_parent_existance;
293: ELSIF (p_action = 'UPDATE') THEN
294: -- Call all the procedures related to Before Update.

Line 310: app_exception.raise_exception;

306: )
307: ) THEN
308: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
309: igs_ge_msg_stack.add;
310: app_exception.raise_exception;
311: END IF;
312: ELSIF (p_action = 'VALIDATE_DELETE') THEN
313: check_child_existance;
314: END IF;

Line 368: app_exception.raise_exception;

364: ELSE
365: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
366: fnd_message.set_token ('ROUTINE', 'IGS_HE_SUB_RTN_QUAL_PKG.INSERT_ROW');
367: igs_ge_msg_stack.add;
368: app_exception.raise_exception;
369: END IF;
370:
371: before_dml(
372: p_action => 'INSERT',

Line 482: app_exception.raise_exception;

478: IF (c1%notfound) THEN
479: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
480: igs_ge_msg_stack.add;
481: CLOSE c1;
482: app_exception.raise_exception;
483: RETURN;
484: END IF;
485: CLOSE c1;
486:

Line 501: app_exception.raise_exception;

497: NULL;
498: ELSE
499: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
500: igs_ge_msg_stack.add;
501: app_exception.raise_exception;
502: END IF;
503:
504: RETURN;
505:

Line 557: app_exception.raise_exception;

553: ELSE
554: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
555: fnd_message.set_token ('ROUTINE', 'IGS_HE_SUB_RTN_QUAL_PKG.UPDATE_ROW');
556: igs_ge_msg_stack.add;
557: app_exception.raise_exception;
558: END IF;
559:
560: before_dml(
561: p_action => 'UPDATE',