DBA Data[Home] [Help]

APPS.GME_LAB_BATCH_LOTS_DBL dependencies on GME_LAB_BATCH_LOTS_DBL

Line 1: PACKAGE BODY gme_lab_batch_lots_dbl AS

1: PACKAGE BODY gme_lab_batch_lots_dbl AS
2: /* $Header: GMEVGLBB.pls 120.2 2006/02/03 07:23:27 svgonugu noship $ */
3:
4: /* Global Variables */
5: g_table_name VARCHAR2 (80) DEFAULT 'GME_LAB_BATCH_LOTS_DBL';

Line 5: g_table_name VARCHAR2 (80) DEFAULT 'GME_LAB_BATCH_LOTS_DBL';

1: PACKAGE BODY gme_lab_batch_lots_dbl AS
2: /* $Header: GMEVGLBB.pls 120.2 2006/02/03 07:23:27 svgonugu noship $ */
3:
4: /* Global Variables */
5: g_table_name VARCHAR2 (80) DEFAULT 'GME_LAB_BATCH_LOTS_DBL';
6: g_debug VARCHAR2 (5) := fnd_profile.VALUE ('AFLOG_LEVEL');
7:
8: /*============================================================================
9: | Copyright (c) 2001 Oracle Corporation

Line 667: IF NOT gme_lab_batch_lots_dbl.delete_row

663: INTO l_lab_lots;
664:
665: EXIT WHEN get_lots%NOTFOUND;
666:
667: IF NOT gme_lab_batch_lots_dbl.delete_row
668: (p_lab_batch_lots => l_lab_lots) THEN
669: RAISE fnd_api.g_exc_error;
670: END IF;
671: END LOOP;

Line 679: fnd_msg_pub.add_exc_msg ('GME_LAB_BATCH_LOTS_DBL'

675: WHEN fnd_api.g_exc_error THEN
676: x_return_status := fnd_api.g_ret_sts_error;
677: WHEN OTHERS THEN
678: x_return_status := fnd_api.g_ret_sts_unexp_error;
679: fnd_msg_pub.add_exc_msg ('GME_LAB_BATCH_LOTS_DBL'
680: ,'DELETE_LAB_LOTS');
681:
682: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
683: gme_debug.put_line ('IN OTHERS ' || SQLERRM);

Line 686: END gme_lab_batch_lots_dbl;

682: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
683: gme_debug.put_line ('IN OTHERS ' || SQLERRM);
684: END IF;
685: END delete_lab_lots;
686: END gme_lab_batch_lots_dbl;