APPS.GME_LAB_BATCH_LOTS_DBL dependencies on FND_API

Line 617: x_return_status := fnd_api.g_ret_sts_success;

613: l_cursor NUMBER (5);
614: l_lab_lots gme_lab_batch_lots%ROWTYPE;
615: BEGIN
616: /* Initialize API return status to sucess */
617: x_return_status := fnd_api.g_ret_sts_success;
618:
619: -- Determine if any of the key values are present
620: IF ( (p_lab_batch_lots.lot_id IS NOT NULL)
621: AND (p_lab_batch_lots.material_detail_id IS NOT NULL) ) THEN

Line 636: RAISE fnd_api.g_exc_error;

632: ELSE
633: gme_common_pvt.log_message ('GME_NO_KEYS'
634: ,'TABLE_NAME'
635: ,'GME_LAB_BATCH_LOTS');
636: RAISE fnd_api.g_exc_error;
637: END IF;
638:
639: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
640: gme_debug.put_line ('Where Clause = ' || l_where);

Line 669: RAISE fnd_api.g_exc_error;

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;
672:
673: CLOSE get_lots;

Line 675: WHEN fnd_api.g_exc_error THEN

671: END LOOP;
672:
673: CLOSE get_lots;
674: EXCEPTION
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'

Line 676: x_return_status := fnd_api.g_ret_sts_error;

672:
673: CLOSE get_lots;
674: EXCEPTION
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');

Line 678: x_return_status := fnd_api.g_ret_sts_unexp_error;

674: EXCEPTION
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