APPS.IGI_DOS_TRX_DEST_PKG dependencies on APP_EXCEPTION

Line 128: app_exception.raise_exception;

124: IF (l_unexp_level >= l_debug_level) THEN
125: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_trx_dest_pkg.set_column_values.Msg1',FALSE);
126: END IF;
127: -- bug 3199481, end block
128: app_exception.raise_exception;
129: RETURN;
130: END IF;
131: CLOSE cur_old_ref_values;
132:

Line 245: app_exception.raise_exception;

241: IF (l_unexp_level >= l_debug_level) THEN
242: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_trx_dest_pkg.check_parent_existance.Msg1',FALSE);
243: END IF;
244: -- bug 3199481, end block
245: app_exception.raise_exception;
246: END IF;
247:
248: IF (((old_references.trx_id = new_references.trx_id)) OR
249: ((new_references.trx_id IS NULL))) THEN

Line 260: app_exception.raise_exception;

256: IF (l_unexp_level >= l_debug_level) THEN
257: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_trx_dest_pkg.check_parent_existance.Msg2',FALSE);
258: END IF;
259: -- bug 3199481, end block
260: app_exception.raise_exception;
261: END IF;
262:
263: IF (((old_references.dossier_id = new_references.dossier_id)) OR
264: ((new_references.dossier_id IS NULL))) THEN

Line 275: app_exception.raise_exception;

271: IF (l_unexp_level >= l_debug_level) THEN
272: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_trx_dest_pkg.check_parent_existance.Msg3',FALSE);
273: END IF;
274: -- bug 3199481, end block
275: app_exception.raise_exception;
276: END IF;
277:
278: END check_parent_existance;
279:

Line 371: app_exception.raise_exception;

367: IF (l_unexp_level >= l_debug_level) THEN
368: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_trx_dest_pkg.get_fk_igi_dos_trx_sources.Msg1',FALSE);
369: END IF;
370: -- bug 3199481, end block
371: app_exception.raise_exception;
372: RETURN;
373: END IF;
374: CLOSE cur_rowid;
375:

Line 410: app_exception.raise_exception;

406: IF (l_unexp_level >= l_debug_level) THEN
407: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_trx_dest_pkg.get_fk_igi_dos_trx_headers.Msg1',FALSE);
408: END IF;
409: -- bug 3199481, end block
410: app_exception.raise_exception;
411: RETURN;
412: END IF;
413: CLOSE cur_rowid;
414:

Line 449: app_exception.raise_exception;

445: IF (l_unexp_level >= l_debug_level) THEN
446: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_trx_dest_pkg.get_fk_igi_dos_doc_types.Msg1',FALSE);
447: END IF;
448: -- bug 3199481, end block
449: app_exception.raise_exception;
450: RETURN;
451: END IF;
452: CLOSE cur_rowid;
453:

Line 642: app_exception.raise_exception;

638: IF (l_unexp_level >= l_debug_level) THEN
639: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_trx_dest_pkg.before_dml.Msg1',FALSE);
640: END IF;
641: -- bug 3199481, end block
642: app_exception.raise_exception;
643: END IF;
644: check_parent_existance;
645: ELSIF (p_action = 'UPDATE') THEN
646: -- Call all the procedures related to Before Update.

Line 664: app_exception.raise_exception;

660: IF (l_unexp_level >= l_debug_level) THEN
661: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_trx_dest_pkg.before_dml.Msg2',FALSE);
662: END IF;
663: -- bug 3199481, end block
664: app_exception.raise_exception;
665: END IF;
666: ELSIF (p_action = 'VALIDATE_DELETE') THEN
667: check_child_existance;
668: END IF;

Line 794: app_exception.raise_exception;

790: IF (l_unexp_level >= l_debug_level) THEN
791: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_trx_dest_pkg.insert_row.Msg1',FALSE);
792: END IF;
793: -- bug 3199481, end block
794: app_exception.raise_exception;
795: END IF;
796:
797: SELECT igi_dos_trx_dest_s.NEXTVAL
798: INTO x_dest_trx_id

Line 1222: app_exception.raise_exception;

1218: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_trx_dest_pkg.lock_row.Msg1',FALSE);
1219: END IF;
1220: -- bug 3199481, end block
1221: CLOSE c1;
1222: app_exception.raise_exception;
1223: RETURN;
1224: END IF;
1225: CLOSE c1;
1226:

Line 1307: app_exception.raise_exception;

1303: IF (l_unexp_level >= l_debug_level) THEN
1304: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_trx_dest_pkg.lock_row.Msg2',FALSE);
1305: END IF;
1306: -- bug 3199481, end block
1307: app_exception.raise_exception;
1308: END IF;
1309:
1310: RETURN;
1311:

Line 1431: app_exception.raise_exception;

1427: IF (l_unexp_level >= l_debug_level) THEN
1428: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_trx_dest_pkg.update_row.Msg1',FALSE);
1429: END IF;
1430: -- bug 3199481, end block
1431: app_exception.raise_exception;
1432: END IF;
1433:
1434: before_dml(
1435: p_action => 'UPDATE',