64: p_analysis_cycle_id IN NUMBER)
65: IS
66: l_cal_period_end_date VARCHAR2(30);
67: l_end_date_attribute_id NUMBER :=
68: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE').attribute_id;
69: l_end_date_version_id NUMBER :=
70: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE').version_id;
71: BEGIN
72:
66: l_cal_period_end_date VARCHAR2(30);
67: l_end_date_attribute_id NUMBER :=
68: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE').attribute_id;
69: l_end_date_version_id NUMBER :=
70: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE').version_id;
71: BEGIN
72:
73: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
74: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.RAISE_EXECUTE_ENG_EVENT.begin', '<
148: l_event_key VARCHAR2(200);
149: l_cal_period_end_date VARCHAR2(30);
150: l_threshold NUMBER;
151: l_end_date_attribute_id NUMBER :=
152: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE').attribute_id;
153: l_end_date_version_id NUMBER :=
154: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE').version_id;
155: BEGIN
156:
150: l_threshold NUMBER;
151: l_end_date_attribute_id NUMBER :=
152: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE').attribute_id;
153: l_end_date_version_id NUMBER :=
154: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE').version_id;
155: BEGIN
156:
157: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
158: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.RAISE_EXECUTE_ENG_EVENT.begin', '<
262: l_event_key VARCHAR2(200);
263: l_cal_period_end_date VARCHAR2(30);
264: l_threshold NUMBER;
265: l_end_date_attribute_id NUMBER :=
266: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE').attribute_id;
267: l_end_date_version_id NUMBER :=
268: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE').version_id;
269: l_source_dataset_code NUMBER;
270: l_hierarchy_dataset_code NUMBER;
264: l_threshold NUMBER;
265: l_end_date_attribute_id NUMBER :=
266: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE').attribute_id;
267: l_end_date_version_id NUMBER :=
268: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE').version_id;
269: l_source_dataset_code NUMBER;
270: l_hierarchy_dataset_code NUMBER;
271:
272: --Bugfix 5505707: Add variables to store information required for default member setup
269: l_source_dataset_code NUMBER;
270: l_hierarchy_dataset_code NUMBER;
271:
272: --Bugfix 5505707: Add variables to store information required for default member setup
273: l_dimension_info gcs_utility_pkg.t_hash_gcs_dimension_info;
274: l_column_name VARCHAR2(30);
275: l_value_set_tokens VARCHAR2(4000);
276: l_value_set_name VARCHAR2(150);
277: l_error_message VARCHAR2(32767);
315: fnd_file.put_line(fnd_file.log, '<
316:
317: --Bugfix 5505707: Validating Default Member Setup
318: fnd_file.put_line(fnd_file.log, '<
319: l_dimension_info := gcs_utility_pkg.g_gcs_dimension_info;
320: l_column_name := l_dimension_info.FIRST;
321:
322: WHILE (l_column_name <= l_dimension_info.LAST) LOOP
323: