[Home] [Help]
1: PACKAGE BODY xla_event_class_grps_f_pkg AS
2: /* $Header: xlathecg.pkb 120.8.12010000.1 2008/07/29 10:09:23 appldev ship $ */
3: /*======================================================================+
4: | Copyright (c) 2001-2002 Oracle Corporation |
5: | Redwood Shores, CA, USA |
26: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
27: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
28:
29: C_LEVEL_LOG_DISABLED CONSTANT NUMBER := 99;
30: C_DEFAULT_MODULE CONSTANT VARCHAR2(240) := 'xla.plsql.xla_event_class_grps_f_pkg';
31:
32: g_debug_flag VARCHAR2(1) :=
33: NVL(fnd_profile.value('XLA_DEBUG_TRACE'),'N');
34:
54: RAISE;
55:
56: WHEN OTHERS THEN
57: xla_exceptions_pkg.raise_message
58: (p_location => 'xla_event_class_grps_f_pkg.trace');
59: END trace;
60:
61:
62:
544: WHERE application_id = l_application_id
545: AND event_class_group_code = p_event_class_group_code;
546:
547: IF (fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate, NULL)) THEN
548: xla_event_class_grps_f_pkg.update_row
549: (x_application_id => l_application_id
550: ,x_event_class_group_code => p_event_class_group_code
551: ,x_enabled_flag => p_enabled_flag
552: ,x_name => p_name
558: END IF;
559:
560: EXCEPTION
561: WHEN NO_DATA_FOUND THEN
562: xla_event_class_grps_f_pkg.insert_row
563: (x_rowid => l_rowid
564: ,x_application_id => l_application_id
565: ,x_event_class_group_code => p_event_class_group_code
566: ,x_enabled_flag => p_enabled_flag
584: WHEN NO_DATA_FOUND THEN
585: null;
586: WHEN OTHERS THEN
587: xla_exceptions_pkg.raise_message
588: (p_location => 'xla_event_class_grps_f_pkg.load_row');
589:
590: END load_row;
591:
592: --=============================================================================
692: g_log_level := C_LEVEL_LOG_DISABLED;
693: END IF;
694:
695:
696: end xla_event_class_grps_f_PKG;