DBA Data[Home] [Help]

APPS.IGF_DB_YTD_SMR_PKG dependencies on APP_EXCEPTION

Line 63: app_exception.raise_exception;

59: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
60: CLOSE cur_old_ref_values;
61: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
62: igs_ge_msg_stack.add;
63: app_exception.raise_exception;
64: RETURN;
65: END IF;
66: CLOSE cur_old_ref_values;
67:

Line 216: app_exception.raise_exception;

212: )
213: ) THEN
214: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
215: igs_ge_msg_stack.add;
216: app_exception.raise_exception;
217: END IF;
218: ELSIF (p_action = 'VALIDATE_INSERT') THEN
219: -- Call all the procedures related to Before Insert.
220: IF ( get_pk_for_validation (

Line 226: app_exception.raise_exception;

222: )
223: ) THEN
224: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
225: igs_ge_msg_stack.add;
226: app_exception.raise_exception;
227: END IF;
228: END IF;
229:
230: END before_dml;

Line 308: app_exception.raise_exception;

304: END IF;
305: ELSE
306: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
307: igs_ge_msg_stack.add;
308: app_exception.raise_exception;
309: END IF;
310:
311: SELECT igf_db_ytd_smr_s.NEXTVAL
312: INTO x_ytds_id

Line 485: app_exception.raise_exception;

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

Line 514: app_exception.raise_exception;

510: NULL;
511: ELSE
512: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
513: igs_ge_msg_stack.add;
514: app_exception.raise_exception;
515: END IF;
516:
517: RETURN;
518:

Line 580: app_exception.raise_exception;

576: END IF;
577: ELSE
578: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
579: igs_ge_msg_stack.add;
580: app_exception.raise_exception;
581: END IF;
582:
583: before_dml(
584: p_action => 'UPDATE',