eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSD_DEM_UPLOAD_FORECAST dependencies on MSD_DEM_COMMON_UTILITIES

Line 98: x_group_table_id := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID',

94: RETURN NULL;
95: END IF;
96:
97: --syenamar Bug#7199587 /* Bug#8224935 - APP ID */ -- nallkuma
98: x_group_table_id := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID',
99: x_level_id_lkup_code,
100: 1,
101: 'group_table_id'));
102: /*

Line 112: x_table_name := msd_dem_common_utilities.get_lookup_value ('MSD_DEM_TABLES', 'TRANSFER_QUERY_LEVELS');

108: RETURN NULL;
109: END IF;
110: --syenamar
111:
112: x_table_name := msd_dem_common_utilities.get_lookup_value ('MSD_DEM_TABLES', 'TRANSFER_QUERY_LEVELS');
113: x_sql := 'SELECT tql.lorder ' ||
114: ' FROM ' || x_table_name || ' tql, ';
115:
116: x_table_name := NULL;

Line 117: x_table_name := msd_dem_common_utilities.get_lookup_value ('MSD_DEM_TABLES', 'GROUP_TABLES');

113: x_sql := 'SELECT tql.lorder ' ||
114: ' FROM ' || x_table_name || ' tql, ';
115:
116: x_table_name := NULL;
117: x_table_name := msd_dem_common_utilities.get_lookup_value ('MSD_DEM_TABLES', 'GROUP_TABLES');
118: x_sql := x_sql || x_table_name || ' gt ' ||
119: ' WHERE gt.group_table_id = ' || x_group_table_id ||
120: ' AND gt.status = ''ACTIVE'' ' ||
121: ' AND gt.group_table_id = tql.level_id ' ||

Line 173: x_table_name := msd_dem_common_utilities.get_lookup_value ('MSD_DEM_TABLES', 'TRANSFER_QUERY_SERIES');

169: ELSE
170: RETURN NULL;
171: END IF;
172:
173: x_table_name := msd_dem_common_utilities.get_lookup_value ('MSD_DEM_TABLES', 'TRANSFER_QUERY_SERIES');
174: x_sql := 'SELECT cf.computed_name ' ||
175: ' FROM ' || x_table_name || ' tqs, ';
176:
177: x_table_name := NULL;

Line 178: x_table_name := msd_dem_common_utilities.get_lookup_value ('MSD_DEM_TABLES', 'COMPUTED_FIELDS');

174: x_sql := 'SELECT cf.computed_name ' ||
175: ' FROM ' || x_table_name || ' tqs, ';
176:
177: x_table_name := NULL;
178: x_table_name := msd_dem_common_utilities.get_lookup_value ('MSD_DEM_TABLES', 'COMPUTED_FIELDS');
179: x_sql := x_sql || x_table_name || ' cf ' ||
180: ' WHERE tqs.id = ' || p_data_profile_id ||
181: ' AND cf.forecast_type_id = tqs.series_id ' ||
182: ' AND ( upper(cf.computed_name) like ''' || x_series_prefix || '%'' ' ||

Line 234: x_tgroup_res := msd_dem_common_utilities.get_lookup_value ('MSD_DEM_TABLES', 'TGROUP_RES');

230: x_bucket_size NUMBER := NULL;
231:
232: BEGIN
233:
234: x_tgroup_res := msd_dem_common_utilities.get_lookup_value ('MSD_DEM_TABLES', 'TGROUP_RES');
235:
236: IF (x_tgroup_res IS NULL) THEN
237: RETURN;
238: END IF;

Line 250: x_dm_wiz_dm_def := msd_dem_common_utilities.get_lookup_value ('MSD_DEM_TABLES', 'DM_WIZ_DM_DEF');

246: x_months_number,
247: x_inputs_column,
248: x_is_default;
249:
250: x_dm_wiz_dm_def := msd_dem_common_utilities.get_lookup_value ('MSD_DEM_TABLES', 'DM_WIZ_DM_DEF');
251: IF (x_dm_wiz_dm_def IS NULL) THEN
252: RETURN;
253: END IF;
254:

Line 347: x_inputs := msd_dem_common_utilities.get_lookup_value ('MSD_DEM_TABLES', 'INPUTS');

343: RETURN;
344: END IF;
345:
346: /* Time Resolution Bucket Size is not fixed, availabe in INPUTS */
347: x_inputs := msd_dem_common_utilities.get_lookup_value ('MSD_DEM_TABLES', 'INPUTS');
348: IF (x_inputs IS NULL OR x_inputs_column IS NULL) THEN
349: RETURN;
350: END IF;
351:

Line 656: IF (msd_dem_common_utilities.is_use_new_site_format = 0)

652: x_account_number VARCHAR2(255) := NULL;
653:
654: BEGIN
655:
656: IF (msd_dem_common_utilities.is_use_new_site_format = 0)
657: THEN
658: x_account_number := to_char(substr (p_tp_zone,
659: instr(p_tp_zone, ':', 1) + 1,
660: instr(p_tp_zone, ':', 1, 2) - instr(p_tp_zone, ':', 1) - 1));

Line 703: IF (msd_dem_common_utilities.is_use_new_site_format = 0)

699: x_sr_zone_pk NUMBER := NULL;
700:
701: BEGIN
702:
703: IF (msd_dem_common_utilities.is_use_new_site_format = 0)
704: THEN
705: x_zone := substr (p_tp_zone,
706: instr(p_tp_zone, ':', 1, 2) + 1);
707: ELSE

Line 870: x_table_name := msd_dem_common_utilities.get_lookup_value ('MSD_DEM_TABLES', 'TRANSFER_QUERY');

866: x_export_data_profile := upper(p_export_data_profile);
867: END IF;
868:
869: /* Get the export data profile info */
870: x_table_name := msd_dem_common_utilities.get_lookup_value ('MSD_DEM_TABLES', 'TRANSFER_QUERY');
871: x_sql := 'SELECT id, presentation_type, view_name, ' ||
872: ' time_res_id, unit_id, index_id, data_scale, ' ||
873: ' integration_type, export_type, last_export_date ' ||
874: ' FROM ' || x_table_name ||

Line 1076: x_uom_code := msd_dem_common_utilities.get_uom_code (x_unit_id);

1072: x_select_clause := x_select_clause || x_sr_demand_class || ' , ' ||
1073: ' msi.inventory_item_id, ';
1074:
1075:
1076: x_uom_code := msd_dem_common_utilities.get_uom_code (x_unit_id);
1077: x_select_clause := x_select_clause || '''' || x_uom_code || ''', ' ||
1078: ' msi.uom_code, ';
1079:
1080: /* SINCE AMOUNT IS NOT AVAILABLE USE ASCP's LIST PRICE VALUE */

Line 1119: ' msd_dem_common_utilities.uom_convert(msi.inventory_item_id, ' ||

1115: ELSE
1116: x_quantity := ' round (' || x_fcst_column ||
1117: ' * ' || x_data_scale ||
1118: ' * decode ( ''' || x_uom_code || ''', msi.uom_code, 1, ' ||
1119: ' msd_dem_common_utilities.uom_convert(msi.inventory_item_id, ' ||
1120: ' null, ' ||
1121: '''' || x_uom_code || ''' , ' ||
1122: ' msi.uom_code)), ' ||
1123: C_ROUNDOFF_PLACES || ' ) ';

Line 1240: IF (msd_dem_common_utilities.is_use_new_site_format <> 0)

1236: END IF;
1237:
1238: IF (x_cust_level IS NOT NULL)
1239: THEN
1240: IF (msd_dem_common_utilities.is_use_new_site_format <> 0)
1241: THEN
1242: x_where_clause := x_where_clause ||
1243: ' AND mtil.sr_cust_account_number (+) = to_char(substr(exp.' || x_cust_level || ',instr(exp.' || x_cust_level || ', ''::'', -1) + 2)) ' ||
1244: ' AND mtil.partner_type (+) = 2 ' ||

Line 1842: x_table_name := msd_dem_common_utilities.get_lookup_value ('MSD_DEM_TABLES', 'TRANSFER_QUERY');

1838: x_publish_variant := 0;
1839: END IF;
1840:
1841: /* Get the export data profile info */
1842: x_table_name := msd_dem_common_utilities.get_lookup_value ('MSD_DEM_TABLES', 'TRANSFER_QUERY');
1843: x_sql := 'SELECT id, presentation_type, view_name, ' ||
1844: ' time_res_id, unit_id, index_id, data_scale, ' ||
1845: ' integration_type, export_type ' ||
1846: ' FROM ' || x_table_name ||

Line 1868: x_uom_code := msd_dem_common_utilities.get_uom_code (x_unit_id);

1864: ' AND object_type IN (''VIEW'', ''MATERIALIZED VIEW'') ' ||
1865: ' AND object_name = upper(''' || x_view_name || ''')';
1866: EXECUTE IMMEDIATE x_sql INTO x_is_view_present;
1867:
1868: x_uom_code := msd_dem_common_utilities.get_uom_code (x_unit_id);
1869:
1870: /* Get the id of the forecast profile */
1871: x_sql := 'SELECT id ' ||
1872: ' FROM ' || x_table_name ||

Line 2636: x_uom_code := msd_dem_common_utilities.get_uom_code (x_unit_id);

2632: ' AND object_type IN (''VIEW'', ''MATERIALIZED VIEW'') ' ||
2633: ' AND object_name = upper(''' || x_view_name || ''')';
2634: EXECUTE IMMEDIATE x_sql INTO x_is_view_present;
2635:
2636: x_uom_code := msd_dem_common_utilities.get_uom_code (x_unit_id);
2637:
2638: /* Get the id of the forecast profile */
2639: x_sql := 'SELECT id ' ||
2640: ' FROM ' || x_schema || '.transfer_query ' ||

Line 2727: msd_dem_common_utilities.GET_SCHEMA_NAME(x_errbuf,x_retcode,x_msd_schema,'MSD');

2723:
2724: /* Get Time Info - END */
2725:
2726:
2727: msd_dem_common_utilities.GET_SCHEMA_NAME(x_errbuf,x_retcode,x_msd_schema,'MSD');
2728:
2729: IF(p_upload_pct_by_base_model = 'Y') THEN
2730: x_exclude_pto_model := 1;
2731: ELSE

Line 3433: x_table_name := msd_dem_common_utilities.get_lookup_value ('MSD_DEM_TABLES', 'TRANSFER_QUERY');

3429: x_dp_final_forecast_appid := upper(p_dp_final_forecast_appid);
3430: END IF;
3431:
3432: /* Get the metrics export data profile info */
3433: x_table_name := msd_dem_common_utilities.get_lookup_value ('MSD_DEM_TABLES', 'TRANSFER_QUERY');
3434: x_sql := 'SELECT id, presentation_type, view_name, query_name, ' ||
3435: ' time_res_id, unit_id, index_id, data_scale, ' ||
3436: ' integration_type, export_type, last_export_date ' ||
3437: ' FROM ' || x_table_name ||

Line 3763: x_table_name := msd_dem_common_utilities.get_lookup_value ('MSD_DEM_TABLES', 'TRANSFER_QUERY');

3759: x_dp_final_forecast_appid := upper(p_dp_final_forecast_appid);
3760: END IF;
3761:
3762: /* Get the 'SPF Upload Metrics' export data profile info */
3763: x_table_name := msd_dem_common_utilities.get_lookup_value ('MSD_DEM_TABLES', 'TRANSFER_QUERY');
3764: x_sql := 'SELECT id, presentation_type, view_name, query_name, ' ||
3765: ' time_res_id, unit_id, index_id, data_scale, ' ||
3766: ' integration_type, export_type, last_export_date ' ||
3767: ' FROM ' || x_table_name ||

Line 4343: msd_dem_common_utilities.log_debug ('Entering msd_spf_collect_history_data.check_requests_completion...' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

4339: var_elapsed_seconds NUMBER DEFAULT NULL;
4340:
4341: BEGIN
4342:
4343: msd_dem_common_utilities.log_debug ('Entering msd_spf_collect_history_data.check_requests_completion...' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
4344:
4345: var_start_date := TO_NUMBER(TO_CHAR(p_run_time, 'J'));
4346: var_start_date_seconds := TO_NUMBER(TO_CHAR(p_run_time, 'SSSSS'));
4347:

Line 4395: msd_dem_common_utilities.log_message('Concurrent Request - ' || to_char(p_req_table(I).request_id) || ' completed ' || var_stat_message);

4391: p_req_table(I).status := -5;
4392: var_stat_message := 'unknown status.';
4393: END IF;
4394:
4395: msd_dem_common_utilities.log_message('Concurrent Request - ' || to_char(p_req_table(I).request_id) || ' completed ' || var_stat_message);
4396:
4397: END IF;
4398:
4399: <>

Line 4414: msd_dem_common_utilities.log_message ('msd_spf_collect_history_data.check_requests_completion - ERROR ...' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

4410: THEN
4411:
4412: retcode := -1;
4413: errbuf := 'Timeout occured while waiting for requests to finish.';
4414: msd_dem_common_utilities.log_message ('msd_spf_collect_history_data.check_requests_completion - ERROR ...' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
4415: msd_dem_common_utilities.log_message (errbuf);
4416: RETURN;
4417:
4418: END IF;

Line 4415: msd_dem_common_utilities.log_message (errbuf);

4411:
4412: retcode := -1;
4413: errbuf := 'Timeout occured while waiting for requests to finish.';
4414: msd_dem_common_utilities.log_message ('msd_spf_collect_history_data.check_requests_completion - ERROR ...' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
4415: msd_dem_common_utilities.log_message (errbuf);
4416: RETURN;
4417:
4418: END IF;
4419:

Line 4426: msd_dem_common_utilities.log_message ('msd_spf_collect_history_data.check_requests_completion - WARNING ...' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

4422: IF (var_num_warning > 0)
4423: THEN
4424: retcode := 1;
4425: errbuf := 'Some requests completed with warnings';
4426: msd_dem_common_utilities.log_message ('msd_spf_collect_history_data.check_requests_completion - WARNING ...' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
4427: msd_dem_common_utilities.log_message (errbuf);
4428: END IF;
4429:
4430: IF (var_num_error > 0)

Line 4427: msd_dem_common_utilities.log_message (errbuf);

4423: THEN
4424: retcode := 1;
4425: errbuf := 'Some requests completed with warnings';
4426: msd_dem_common_utilities.log_message ('msd_spf_collect_history_data.check_requests_completion - WARNING ...' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
4427: msd_dem_common_utilities.log_message (errbuf);
4428: END IF;
4429:
4430: IF (var_num_error > 0)
4431: THEN

Line 4434: msd_dem_common_utilities.log_message ('msd_spf_collect_history_data.check_requests_completion - ERROR ...' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

4430: IF (var_num_error > 0)
4431: THEN
4432: retcode := -1;
4433: errbuf := 'Some requests completed with errors';
4434: msd_dem_common_utilities.log_message ('msd_spf_collect_history_data.check_requests_completion - ERROR ...' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
4435: msd_dem_common_utilities.log_message (errbuf);
4436: END IF;
4437:
4438: IF (var_num_complete <> (var_num_success + var_num_warning + var_num_error))

Line 4435: msd_dem_common_utilities.log_message (errbuf);

4431: THEN
4432: retcode := -1;
4433: errbuf := 'Some requests completed with errors';
4434: msd_dem_common_utilities.log_message ('msd_spf_collect_history_data.check_requests_completion - ERROR ...' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
4435: msd_dem_common_utilities.log_message (errbuf);
4436: END IF;
4437:
4438: IF (var_num_complete <> (var_num_success + var_num_warning + var_num_error))
4439: THEN

Line 4442: msd_dem_common_utilities.log_message ('msd_spf_collect_history_data.check_requests_completion - ERROR ...' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

4438: IF (var_num_complete <> (var_num_success + var_num_warning + var_num_error))
4439: THEN
4440: retcode := -1;
4441: errbuf := 'Some requests completed with unknown status';
4442: msd_dem_common_utilities.log_message ('msd_spf_collect_history_data.check_requests_completion - ERROR ...' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
4443: msd_dem_common_utilities.log_message (errbuf);
4444: END IF;
4445:
4446: msd_dem_common_utilities.log_debug ('Exiting msd_spf_collect_history_data.check_requests_completion...' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

Line 4443: msd_dem_common_utilities.log_message (errbuf);

4439: THEN
4440: retcode := -1;
4441: errbuf := 'Some requests completed with unknown status';
4442: msd_dem_common_utilities.log_message ('msd_spf_collect_history_data.check_requests_completion - ERROR ...' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
4443: msd_dem_common_utilities.log_message (errbuf);
4444: END IF;
4445:
4446: msd_dem_common_utilities.log_debug ('Exiting msd_spf_collect_history_data.check_requests_completion...' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
4447:

Line 4446: msd_dem_common_utilities.log_debug ('Exiting msd_spf_collect_history_data.check_requests_completion...' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

4442: msd_dem_common_utilities.log_message ('msd_spf_collect_history_data.check_requests_completion - ERROR ...' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
4443: msd_dem_common_utilities.log_message (errbuf);
4444: END IF;
4445:
4446: msd_dem_common_utilities.log_debug ('Exiting msd_spf_collect_history_data.check_requests_completion...' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
4447:
4448: EXCEPTION
4449: WHEN OTHERS THEN
4450: retcode := -1;

Line 4452: msd_dem_common_utilities.log_message ('msd_spf_collect_history_data.check_requests_completion - ERROR ...' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

4448: EXCEPTION
4449: WHEN OTHERS THEN
4450: retcode := -1;
4451: errbuf := substr(SQLERRM,1,150);
4452: msd_dem_common_utilities.log_message ('msd_spf_collect_history_data.check_requests_completion - ERROR ...' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
4453: msd_dem_common_utilities.log_message (errbuf);
4454: RETURN;
4455:
4456: END CHECK_REQUESTS_COMPLETION;

Line 4453: msd_dem_common_utilities.log_message (errbuf);

4449: WHEN OTHERS THEN
4450: retcode := -1;
4451: errbuf := substr(SQLERRM,1,150);
4452: msd_dem_common_utilities.log_message ('msd_spf_collect_history_data.check_requests_completion - ERROR ...' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
4453: msd_dem_common_utilities.log_message (errbuf);
4454: RETURN;
4455:
4456: END CHECK_REQUESTS_COMPLETION;
4457:

Line 4516: x_wo_item VARCHAR2(50) := MSD_DEM_COMMON_UTILITIES.GET_WORKORDER_ITEM();

4512: x_lvl_count NUMBER := 0;
4513: x_dem_schema VARCHAR2(100) := fnd_profile.value('MSD_DEM_SCHEMA');
4514: x_table_name VARCHAR2(100) := NULL ;
4515: x_fnd_user_id NUMBER := FND_GLOBAL.USER_ID();
4516: x_wo_item VARCHAR2(50) := MSD_DEM_COMMON_UTILITIES.GET_WORKORDER_ITEM();
4517: x_spf_master_org NUMBER := NULL;
4518: x_series_name VARCHAR2(50) := NULL ;
4519: x_count NUMBER := 0;
4520:

Line 4549: msd_dem_common_utilities.log_debug ('Entering: msd_dem_upload_forecast.upload_cmro_pln_fctrs - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

4545:
4546:
4547: BEGIN
4548:
4549: msd_dem_common_utilities.log_debug ('Entering: msd_dem_upload_forecast.upload_cmro_pln_fctrs - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
4550: msd_dem_common_utilities.log_debug (' ');
4551:
4552: /* Log the input parameters to the log file */
4553: msd_dem_common_utilities.log_message('----------------------------------Input Parameters - Begin------------------------------------------');

Line 4550: msd_dem_common_utilities.log_debug (' ');

4546:
4547: BEGIN
4548:
4549: msd_dem_common_utilities.log_debug ('Entering: msd_dem_upload_forecast.upload_cmro_pln_fctrs - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
4550: msd_dem_common_utilities.log_debug (' ');
4551:
4552: /* Log the input parameters to the log file */
4553: msd_dem_common_utilities.log_message('----------------------------------Input Parameters - Begin------------------------------------------');
4554:

Line 4553: msd_dem_common_utilities.log_message('----------------------------------Input Parameters - Begin------------------------------------------');

4549: msd_dem_common_utilities.log_debug ('Entering: msd_dem_upload_forecast.upload_cmro_pln_fctrs - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
4550: msd_dem_common_utilities.log_debug (' ');
4551:
4552: /* Log the input parameters to the log file */
4553: msd_dem_common_utilities.log_message('----------------------------------Input Parameters - Begin------------------------------------------');
4554:
4555: msd_dem_common_utilities.log_message(' ' || rpad('Instance Id', 30) || ' - ' || to_char(p_sr_instance_id));
4556: msd_dem_common_utilities.log_message(' ' || rpad('Data Profile Appl Id', 30) || ' - ' || to_char(p_export_data_profile));
4557: msd_dem_common_utilities.log_message(' ' || rpad('Workflow Lookup Name', 30) || ' - ' || to_char(p_workflow_lookup_code));

Line 4555: msd_dem_common_utilities.log_message(' ' || rpad('Instance Id', 30) || ' - ' || to_char(p_sr_instance_id));

4551:
4552: /* Log the input parameters to the log file */
4553: msd_dem_common_utilities.log_message('----------------------------------Input Parameters - Begin------------------------------------------');
4554:
4555: msd_dem_common_utilities.log_message(' ' || rpad('Instance Id', 30) || ' - ' || to_char(p_sr_instance_id));
4556: msd_dem_common_utilities.log_message(' ' || rpad('Data Profile Appl Id', 30) || ' - ' || to_char(p_export_data_profile));
4557: msd_dem_common_utilities.log_message(' ' || rpad('Workflow Lookup Name', 30) || ' - ' || to_char(p_workflow_lookup_code));
4558:
4559:

Line 4556: msd_dem_common_utilities.log_message(' ' || rpad('Data Profile Appl Id', 30) || ' - ' || to_char(p_export_data_profile));

4552: /* Log the input parameters to the log file */
4553: msd_dem_common_utilities.log_message('----------------------------------Input Parameters - Begin------------------------------------------');
4554:
4555: msd_dem_common_utilities.log_message(' ' || rpad('Instance Id', 30) || ' - ' || to_char(p_sr_instance_id));
4556: msd_dem_common_utilities.log_message(' ' || rpad('Data Profile Appl Id', 30) || ' - ' || to_char(p_export_data_profile));
4557: msd_dem_common_utilities.log_message(' ' || rpad('Workflow Lookup Name', 30) || ' - ' || to_char(p_workflow_lookup_code));
4558:
4559:
4560: msd_dem_common_utilities.log_message('-----------------------------------Input Parameters - End-------------------------------------------');

Line 4557: msd_dem_common_utilities.log_message(' ' || rpad('Workflow Lookup Name', 30) || ' - ' || to_char(p_workflow_lookup_code));

4553: msd_dem_common_utilities.log_message('----------------------------------Input Parameters - Begin------------------------------------------');
4554:
4555: msd_dem_common_utilities.log_message(' ' || rpad('Instance Id', 30) || ' - ' || to_char(p_sr_instance_id));
4556: msd_dem_common_utilities.log_message(' ' || rpad('Data Profile Appl Id', 30) || ' - ' || to_char(p_export_data_profile));
4557: msd_dem_common_utilities.log_message(' ' || rpad('Workflow Lookup Name', 30) || ' - ' || to_char(p_workflow_lookup_code));
4558:
4559:
4560: msd_dem_common_utilities.log_message('-----------------------------------Input Parameters - End-------------------------------------------');
4561: msd_dem_common_utilities.log_message ('');

Line 4560: msd_dem_common_utilities.log_message('-----------------------------------Input Parameters - End-------------------------------------------');

4556: msd_dem_common_utilities.log_message(' ' || rpad('Data Profile Appl Id', 30) || ' - ' || to_char(p_export_data_profile));
4557: msd_dem_common_utilities.log_message(' ' || rpad('Workflow Lookup Name', 30) || ' - ' || to_char(p_workflow_lookup_code));
4558:
4559:
4560: msd_dem_common_utilities.log_message('-----------------------------------Input Parameters - End-------------------------------------------');
4561: msd_dem_common_utilities.log_message ('');
4562: msd_dem_common_utilities.log_message ('');
4563:
4564: IF (x_dem_schema IS NULL)

Line 4561: msd_dem_common_utilities.log_message ('');

4557: msd_dem_common_utilities.log_message(' ' || rpad('Workflow Lookup Name', 30) || ' - ' || to_char(p_workflow_lookup_code));
4558:
4559:
4560: msd_dem_common_utilities.log_message('-----------------------------------Input Parameters - End-------------------------------------------');
4561: msd_dem_common_utilities.log_message ('');
4562: msd_dem_common_utilities.log_message ('');
4563:
4564: IF (x_dem_schema IS NULL)
4565: THEN

Line 4562: msd_dem_common_utilities.log_message ('');

4558:
4559:
4560: msd_dem_common_utilities.log_message('-----------------------------------Input Parameters - End-------------------------------------------');
4561: msd_dem_common_utilities.log_message ('');
4562: msd_dem_common_utilities.log_message ('');
4563:
4564: IF (x_dem_schema IS NULL)
4565: THEN
4566: raise_application_error (-20001, 'Error: msd_dem_upload_forecast.upload_cmro_pln_fctrs - Unable to find schema name');

Line 4581: msd_dem_common_utilities.get_dblink (

4577: END IF;
4578:
4579:
4580: /*------- START - Get Desination to Source DBlink -------*/
4581: msd_dem_common_utilities.get_dblink (
4582: var_errbuf,
4583: var_retcode,
4584: p_sr_instance_id,
4585: var_D2S_dblink);

Line 4591: msd_dem_common_utilities.log_message ('ERROR(1) - msd_dem_upload_forecast.upload_cmro_pln_fctrs - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

4587: IF (var_retcode = -1)
4588: THEN
4589: retcode := -1;
4590: errbuf := substr(SQLERRM,1,150);
4591: msd_dem_common_utilities.log_message ('ERROR(1) - msd_dem_upload_forecast.upload_cmro_pln_fctrs - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
4592: msd_dem_common_utilities.log_message ('Error in call to msd_dem_common_utilities.get_dblink');
4593: msd_dem_common_utilities.log_message (errbuf);
4594: RETURN;
4595: END IF;

Line 4592: msd_dem_common_utilities.log_message ('Error in call to msd_dem_common_utilities.get_dblink');

4588: THEN
4589: retcode := -1;
4590: errbuf := substr(SQLERRM,1,150);
4591: msd_dem_common_utilities.log_message ('ERROR(1) - msd_dem_upload_forecast.upload_cmro_pln_fctrs - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
4592: msd_dem_common_utilities.log_message ('Error in call to msd_dem_common_utilities.get_dblink');
4593: msd_dem_common_utilities.log_message (errbuf);
4594: RETURN;
4595: END IF;
4596:

Line 4593: msd_dem_common_utilities.log_message (errbuf);

4589: retcode := -1;
4590: errbuf := substr(SQLERRM,1,150);
4591: msd_dem_common_utilities.log_message ('ERROR(1) - msd_dem_upload_forecast.upload_cmro_pln_fctrs - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
4592: msd_dem_common_utilities.log_message ('Error in call to msd_dem_common_utilities.get_dblink');
4593: msd_dem_common_utilities.log_message (errbuf);
4594: RETURN;
4595: END IF;
4596:
4597: msd_dem_common_utilities.log_debug ('Desination to Source DBlink is - '|| var_D2S_dblink );

Line 4597: msd_dem_common_utilities.log_debug ('Desination to Source DBlink is - '|| var_D2S_dblink );

4593: msd_dem_common_utilities.log_message (errbuf);
4594: RETURN;
4595: END IF;
4596:
4597: msd_dem_common_utilities.log_debug ('Desination to Source DBlink is - '|| var_D2S_dblink );
4598: msd_dem_common_utilities.log_debug (' ');
4599:
4600: /*------- END - Get Desination to Source DBlink -------*/
4601:

Line 4598: msd_dem_common_utilities.log_debug (' ');

4594: RETURN;
4595: END IF;
4596:
4597: msd_dem_common_utilities.log_debug ('Desination to Source DBlink is - '|| var_D2S_dblink );
4598: msd_dem_common_utilities.log_debug (' ');
4599:
4600: /*------- END - Get Desination to Source DBlink -------*/
4601:
4602:

Line 4607: msd_dem_common_utilities.log_message ('Launching workflow - ' || p_workflow_lookup_code );

4603: /* START - Launch workflow "Export SPF Planning factors" */
4604:
4605: BEGIN
4606:
4607: msd_dem_common_utilities.log_message ('Launching workflow - ' || p_workflow_lookup_code );
4608:
4609: BEGIN
4610: var_request_id := null;
4611: var_request_id := fnd_request.submit_request ('MSD', 'MSDDEMLDW', NULL, NULL, FALSE,

Line 4615: msd_dem_common_utilities.log_message ('Request Id for "Launch Demantra Workflow" concurrent program - ' || var_request_id);

4611: var_request_id := fnd_request.submit_request ('MSD', 'MSDDEMLDW', NULL, NULL, FALSE,
4612: 'WF_EXP_SPF_PLANNING_FACTORS',
4613: p_synchronous, p_check_interval, p_time_out);
4614:
4615: msd_dem_common_utilities.log_message ('Request Id for "Launch Demantra Workflow" concurrent program - ' || var_request_id);
4616:
4617: EXCEPTION
4618: WHEN OTHERS THEN
4619: retcode := -1;

Line 4621: msd_dem_common_utilities.log_message ('ERROR(2): msd_spf_collect_history_data.upload_cmro_pln_fctrs - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

4617: EXCEPTION
4618: WHEN OTHERS THEN
4619: retcode := -1;
4620: errbuf := substr(SQLERRM,1,150);
4621: msd_dem_common_utilities.log_message ('ERROR(2): msd_spf_collect_history_data.upload_cmro_pln_fctrs - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
4622: msd_dem_common_utilities.log_message ('Error while submitting request for "Launch Demantra Workflow" concurrent program.');
4623: msd_dem_common_utilities.log_message (errbuf);
4624: msd_dem_common_utilities.log_message (' ');
4625: RETURN;

Line 4622: msd_dem_common_utilities.log_message ('Error while submitting request for "Launch Demantra Workflow" concurrent program.');

4618: WHEN OTHERS THEN
4619: retcode := -1;
4620: errbuf := substr(SQLERRM,1,150);
4621: msd_dem_common_utilities.log_message ('ERROR(2): msd_spf_collect_history_data.upload_cmro_pln_fctrs - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
4622: msd_dem_common_utilities.log_message ('Error while submitting request for "Launch Demantra Workflow" concurrent program.');
4623: msd_dem_common_utilities.log_message (errbuf);
4624: msd_dem_common_utilities.log_message (' ');
4625: RETURN;
4626: END;

Line 4623: msd_dem_common_utilities.log_message (errbuf);

4619: retcode := -1;
4620: errbuf := substr(SQLERRM,1,150);
4621: msd_dem_common_utilities.log_message ('ERROR(2): msd_spf_collect_history_data.upload_cmro_pln_fctrs - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
4622: msd_dem_common_utilities.log_message ('Error while submitting request for "Launch Demantra Workflow" concurrent program.');
4623: msd_dem_common_utilities.log_message (errbuf);
4624: msd_dem_common_utilities.log_message (' ');
4625: RETURN;
4626: END;
4627:

Line 4624: msd_dem_common_utilities.log_message (' ');

4620: errbuf := substr(SQLERRM,1,150);
4621: msd_dem_common_utilities.log_message ('ERROR(2): msd_spf_collect_history_data.upload_cmro_pln_fctrs - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
4622: msd_dem_common_utilities.log_message ('Error while submitting request for "Launch Demantra Workflow" concurrent program.');
4623: msd_dem_common_utilities.log_message (errbuf);
4624: msd_dem_common_utilities.log_message (' ');
4625: RETURN;
4626: END;
4627:
4628: var_request_num := 0 ;

Line 4645: msd_dem_common_utilities.log_message ('ERROR(3) - msd_dem_upload_forecast.upload_cmro_pln_fctrs - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

4641:
4642: IF (var_retcode = -1) THEN
4643: retcode := -1;
4644: errbuf := var_errbuf;
4645: msd_dem_common_utilities.log_message ('ERROR(3) - msd_dem_upload_forecast.upload_cmro_pln_fctrs - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
4646: msd_dem_common_utilities.log_message (errbuf);
4647: RETURN;
4648: END IF;
4649:

Line 4646: msd_dem_common_utilities.log_message (errbuf);

4642: IF (var_retcode = -1) THEN
4643: retcode := -1;
4644: errbuf := var_errbuf;
4645: msd_dem_common_utilities.log_message ('ERROR(3) - msd_dem_upload_forecast.upload_cmro_pln_fctrs - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
4646: msd_dem_common_utilities.log_message (errbuf);
4647: RETURN;
4648: END IF;
4649:
4650: IF (var_retcode = 1) THEN

Line 4653: msd_dem_common_utilities.log_message ('WARNING(1) - msd_dem_upload_forecast.upload_cmro_pln_fctrs - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

4649:
4650: IF (var_retcode = 1) THEN
4651: retcode := 1;
4652: errbuf := var_errbuf;
4653: msd_dem_common_utilities.log_message ('WARNING(1) - msd_dem_upload_forecast.upload_cmro_pln_fctrs - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
4654: msd_dem_common_utilities.log_message (errbuf);
4655: END IF;
4656:
4657: EXCEPTION

Line 4654: msd_dem_common_utilities.log_message (errbuf);

4650: IF (var_retcode = 1) THEN
4651: retcode := 1;
4652: errbuf := var_errbuf;
4653: msd_dem_common_utilities.log_message ('WARNING(1) - msd_dem_upload_forecast.upload_cmro_pln_fctrs - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
4654: msd_dem_common_utilities.log_message (errbuf);
4655: END IF;
4656:
4657: EXCEPTION
4658: WHEN OTHERS THEN

Line 4661: msd_dem_common_utilities.log_message ('ERROR(4): msd_dem_upload_forecast.upload_cmro_pln_fctrs - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

4657: EXCEPTION
4658: WHEN OTHERS THEN
4659: retcode := -1;
4660: errbuf := substr(SQLERRM,1,150);
4661: msd_dem_common_utilities.log_message ('ERROR(4): msd_dem_upload_forecast.upload_cmro_pln_fctrs - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
4662: msd_dem_common_utilities.log_message ('Error while launching Demantra Workflow - '|| p_workflow_lookup_code );
4663: msd_dem_common_utilities.log_message (errbuf);
4664: msd_dem_common_utilities.log_message (' ');
4665: RETURN;

Line 4662: msd_dem_common_utilities.log_message ('Error while launching Demantra Workflow - '|| p_workflow_lookup_code );

4658: WHEN OTHERS THEN
4659: retcode := -1;
4660: errbuf := substr(SQLERRM,1,150);
4661: msd_dem_common_utilities.log_message ('ERROR(4): msd_dem_upload_forecast.upload_cmro_pln_fctrs - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
4662: msd_dem_common_utilities.log_message ('Error while launching Demantra Workflow - '|| p_workflow_lookup_code );
4663: msd_dem_common_utilities.log_message (errbuf);
4664: msd_dem_common_utilities.log_message (' ');
4665: RETURN;
4666: END;

Line 4663: msd_dem_common_utilities.log_message (errbuf);

4659: retcode := -1;
4660: errbuf := substr(SQLERRM,1,150);
4661: msd_dem_common_utilities.log_message ('ERROR(4): msd_dem_upload_forecast.upload_cmro_pln_fctrs - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
4662: msd_dem_common_utilities.log_message ('Error while launching Demantra Workflow - '|| p_workflow_lookup_code );
4663: msd_dem_common_utilities.log_message (errbuf);
4664: msd_dem_common_utilities.log_message (' ');
4665: RETURN;
4666: END;
4667:

Line 4664: msd_dem_common_utilities.log_message (' ');

4660: errbuf := substr(SQLERRM,1,150);
4661: msd_dem_common_utilities.log_message ('ERROR(4): msd_dem_upload_forecast.upload_cmro_pln_fctrs - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
4662: msd_dem_common_utilities.log_message ('Error while launching Demantra Workflow - '|| p_workflow_lookup_code );
4663: msd_dem_common_utilities.log_message (errbuf);
4664: msd_dem_common_utilities.log_message (' ');
4665: RETURN;
4666: END;
4667:
4668: /* END - Launch workflow "Export SPF Planning factors" */

Line 4677: msd_dem_common_utilities.log_debug ('SQL stmt for data profile presence - ');

4673: l_sql := 'SELECT NVL(SUM(id),0) FROM ' || x_dem_schema|| '.transfer_query WHERE '
4674: || 'upper(application_id) = upper(''' || p_export_data_profile || ''') ' ;
4675: EXECUTE IMMEDIATE l_sql INTO x_count;
4676:
4677: msd_dem_common_utilities.log_debug ('SQL stmt for data profile presence - ');
4678: msd_dem_common_utilities.log_debug (l_sql);
4679: msd_dem_common_utilities.log_debug (' ');
4680:
4681: IF (x_count = 0) THEN

Line 4678: msd_dem_common_utilities.log_debug (l_sql);

4674: || 'upper(application_id) = upper(''' || p_export_data_profile || ''') ' ;
4675: EXECUTE IMMEDIATE l_sql INTO x_count;
4676:
4677: msd_dem_common_utilities.log_debug ('SQL stmt for data profile presence - ');
4678: msd_dem_common_utilities.log_debug (l_sql);
4679: msd_dem_common_utilities.log_debug (' ');
4680:
4681: IF (x_count = 0) THEN
4682: raise_application_error (-20013, 'Error: msd_dem_upload_forecast.upload_cmro_pln_fctrs - Invalid/Non-existing application id for the data profile.');

Line 4679: msd_dem_common_utilities.log_debug (' ');

4675: EXECUTE IMMEDIATE l_sql INTO x_count;
4676:
4677: msd_dem_common_utilities.log_debug ('SQL stmt for data profile presence - ');
4678: msd_dem_common_utilities.log_debug (l_sql);
4679: msd_dem_common_utilities.log_debug (' ');
4680:
4681: IF (x_count = 0) THEN
4682: raise_application_error (-20013, 'Error: msd_dem_upload_forecast.upload_cmro_pln_fctrs - Invalid/Non-existing application id for the data profile.');
4683: ELSE

Line 4696: msd_dem_common_utilities.log_debug ('SQL stmt for fetching levels - ');

4692: || 'upper(tq.application_id) = upper(''' || p_export_data_profile || ''') '
4693: || 'AND tql.id = tq.id '
4694: || 'AND gt.group_table_id = tql.level_id order by lorder ' ;
4695:
4696: msd_dem_common_utilities.log_debug ('SQL stmt for fetching levels - ');
4697: msd_dem_common_utilities.log_debug (l_sql);
4698: msd_dem_common_utilities.log_debug (' ');
4699:
4700: OPEN x_lvl_ref_cursor FOR l_sql ;

Line 4697: msd_dem_common_utilities.log_debug (l_sql);

4693: || 'AND tql.id = tq.id '
4694: || 'AND gt.group_table_id = tql.level_id order by lorder ' ;
4695:
4696: msd_dem_common_utilities.log_debug ('SQL stmt for fetching levels - ');
4697: msd_dem_common_utilities.log_debug (l_sql);
4698: msd_dem_common_utilities.log_debug (' ');
4699:
4700: OPEN x_lvl_ref_cursor FOR l_sql ;
4701: FETCH x_lvl_ref_cursor BULK COLLECT INTO x_lvl_table ;

Line 4698: msd_dem_common_utilities.log_debug (' ');

4694: || 'AND gt.group_table_id = tql.level_id order by lorder ' ;
4695:
4696: msd_dem_common_utilities.log_debug ('SQL stmt for fetching levels - ');
4697: msd_dem_common_utilities.log_debug (l_sql);
4698: msd_dem_common_utilities.log_debug (' ');
4699:
4700: OPEN x_lvl_ref_cursor FOR l_sql ;
4701: FETCH x_lvl_ref_cursor BULK COLLECT INTO x_lvl_table ;
4702: x_lvl_count := x_lvl_ref_cursor%rowcount ;

Line 4705: msd_dem_common_utilities.log_debug ('Levels selected in Data Profile.');

4701: FETCH x_lvl_ref_cursor BULK COLLECT INTO x_lvl_table ;
4702: x_lvl_count := x_lvl_ref_cursor%rowcount ;
4703: CLOSE x_lvl_ref_cursor;
4704:
4705: msd_dem_common_utilities.log_debug ('Levels selected in Data Profile.');
4706: FOR i IN 1..x_lvl_count
4707: LOOP
4708: msd_dem_common_utilities.log_debug (i || '. ' || x_lvl_table(i).level_name);
4709: END LOOP;

Line 4708: msd_dem_common_utilities.log_debug (i || '. ' || x_lvl_table(i).level_name);

4704:
4705: msd_dem_common_utilities.log_debug ('Levels selected in Data Profile.');
4706: FOR i IN 1..x_lvl_count
4707: LOOP
4708: msd_dem_common_utilities.log_debug (i || '. ' || x_lvl_table(i).level_name);
4709: END LOOP;
4710: msd_dem_common_utilities.log_debug (' ');
4711:
4712: /* Get the export data profile info */

Line 4710: msd_dem_common_utilities.log_debug (' ');

4706: FOR i IN 1..x_lvl_count
4707: LOOP
4708: msd_dem_common_utilities.log_debug (i || '. ' || x_lvl_table(i).level_name);
4709: END LOOP;
4710: msd_dem_common_utilities.log_debug (' ');
4711:
4712: /* Get the export data profile info */
4713: x_table_name := msd_dem_common_utilities.get_lookup_value ('MSD_DEM_TABLES', 'TRANSFER_QUERY');
4714: l_sql := 'SELECT id, presentation_type, view_name, query_name, ' ||

Line 4713: x_table_name := msd_dem_common_utilities.get_lookup_value ('MSD_DEM_TABLES', 'TRANSFER_QUERY');

4709: END LOOP;
4710: msd_dem_common_utilities.log_debug (' ');
4711:
4712: /* Get the export data profile info */
4713: x_table_name := msd_dem_common_utilities.get_lookup_value ('MSD_DEM_TABLES', 'TRANSFER_QUERY');
4714: l_sql := 'SELECT id, presentation_type, view_name, query_name, ' ||
4715: ' time_res_id, unit_id, index_id, data_scale, ' ||
4716: ' integration_type, export_type, last_export_date ' ||
4717: ' FROM ' || x_table_name ||

Line 4786: msd_dem_common_utilities.log_debug(l_sql);

4782: /*** END - Check basic error conditions ***/
4783:
4784: l_sql := 'select to_number(parameter_value) from msd_dem_setup_parameters where parameter_name like ''MSD_SPF_MASTER_ORG''';
4785: EXECUTE IMMEDIATE l_sql INTO x_spf_master_org;
4786: msd_dem_common_utilities.log_debug(l_sql);
4787: msd_dem_common_utilities.log_debug (' ');
4788:
4789:
4790:

Line 4787: msd_dem_common_utilities.log_debug (' ');

4783:
4784: l_sql := 'select to_number(parameter_value) from msd_dem_setup_parameters where parameter_name like ''MSD_SPF_MASTER_ORG''';
4785: EXECUTE IMMEDIATE l_sql INTO x_spf_master_org;
4786: msd_dem_common_utilities.log_debug(l_sql);
4787: msd_dem_common_utilities.log_debug (' ');
4788:
4789:
4790:
4791: -- Bug#14621568/13995563 add (''0'',NULL,''-777'' ) below if stmts

Line 4949: msd_dem_common_utilities.log_debug ('Delete sql - ' || x_small_sql);

4945: x_small_sql := 'Delete from AHL_PLANNING_FACTORS' || var_D2S_dblink ;
4946: EXECUTE IMMEDIATE x_small_sql;
4947: COMMIT;
4948:
4949: msd_dem_common_utilities.log_debug ('Delete sql - ' || x_small_sql);
4950: msd_dem_common_utilities.log_debug (' ');
4951: /* END - Delete from AHL_PLANNING_FACTORS table */
4952:
4953: /* To bypass ORA-02069 error */

Line 4950: msd_dem_common_utilities.log_debug (' ');

4946: EXECUTE IMMEDIATE x_small_sql;
4947: COMMIT;
4948:
4949: msd_dem_common_utilities.log_debug ('Delete sql - ' || x_small_sql);
4950: msd_dem_common_utilities.log_debug (' ');
4951: /* END - Delete from AHL_PLANNING_FACTORS table */
4952:
4953: /* To bypass ORA-02069 error */
4954: x_small_sql := 'ALTER SESSION SET GLOBAL_NAMES = TRUE';

Line 4957: msd_dem_common_utilities.log_debug ('Alter sql - ' || x_small_sql);

4953: /* To bypass ORA-02069 error */
4954: x_small_sql := 'ALTER SESSION SET GLOBAL_NAMES = TRUE';
4955: EXECUTE IMMEDIATE x_small_sql;
4956: COMMIT;
4957: msd_dem_common_utilities.log_debug ('Alter sql - ' || x_small_sql);
4958: msd_dem_common_utilities.log_debug (' ');
4959:
4960:
4961: /* START - Inserting into AHL_PLANNING_FACTORS table */

Line 4958: msd_dem_common_utilities.log_debug (' ');

4954: x_small_sql := 'ALTER SESSION SET GLOBAL_NAMES = TRUE';
4955: EXECUTE IMMEDIATE x_small_sql;
4956: COMMIT;
4957: msd_dem_common_utilities.log_debug ('Alter sql - ' || x_small_sql);
4958: msd_dem_common_utilities.log_debug (' ');
4959:
4960:
4961: /* START - Inserting into AHL_PLANNING_FACTORS table */
4962: msd_dem_common_utilities.log_debug (' ');

Line 4962: msd_dem_common_utilities.log_debug (' ');

4958: msd_dem_common_utilities.log_debug (' ');
4959:
4960:
4961: /* START - Inserting into AHL_PLANNING_FACTORS table */
4962: msd_dem_common_utilities.log_debug (' ');
4963: msd_dem_common_utilities.log_debug ('Executing insert sql - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
4964: msd_dem_common_utilities.log_debug (l_large_sql);
4965:
4966: EXECUTE IMMEDIATE l_large_sql;

Line 4963: msd_dem_common_utilities.log_debug ('Executing insert sql - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

4959:
4960:
4961: /* START - Inserting into AHL_PLANNING_FACTORS table */
4962: msd_dem_common_utilities.log_debug (' ');
4963: msd_dem_common_utilities.log_debug ('Executing insert sql - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
4964: msd_dem_common_utilities.log_debug (l_large_sql);
4965:
4966: EXECUTE IMMEDIATE l_large_sql;
4967:

Line 4964: msd_dem_common_utilities.log_debug (l_large_sql);

4960:
4961: /* START - Inserting into AHL_PLANNING_FACTORS table */
4962: msd_dem_common_utilities.log_debug (' ');
4963: msd_dem_common_utilities.log_debug ('Executing insert sql - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
4964: msd_dem_common_utilities.log_debug (l_large_sql);
4965:
4966: EXECUTE IMMEDIATE l_large_sql;
4967:
4968: msd_dem_common_utilities.log_debug ('Executed insert sql - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

Line 4968: msd_dem_common_utilities.log_debug ('Executed insert sql - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

4964: msd_dem_common_utilities.log_debug (l_large_sql);
4965:
4966: EXECUTE IMMEDIATE l_large_sql;
4967:
4968: msd_dem_common_utilities.log_debug ('Executed insert sql - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
4969: msd_dem_common_utilities.log_debug (' ');
4970: /* END - Inserting into AHL_PLANNING_FACTORS table */
4971:
4972: msd_dem_common_utilities.log_debug ('Exiting: msd_dem_upload_forecast.upload_cmro_pln_fctrs - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

Line 4969: msd_dem_common_utilities.log_debug (' ');

4965:
4966: EXECUTE IMMEDIATE l_large_sql;
4967:
4968: msd_dem_common_utilities.log_debug ('Executed insert sql - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
4969: msd_dem_common_utilities.log_debug (' ');
4970: /* END - Inserting into AHL_PLANNING_FACTORS table */
4971:
4972: msd_dem_common_utilities.log_debug ('Exiting: msd_dem_upload_forecast.upload_cmro_pln_fctrs - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
4973:

Line 4972: msd_dem_common_utilities.log_debug ('Exiting: msd_dem_upload_forecast.upload_cmro_pln_fctrs - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

4968: msd_dem_common_utilities.log_debug ('Executed insert sql - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
4969: msd_dem_common_utilities.log_debug (' ');
4970: /* END - Inserting into AHL_PLANNING_FACTORS table */
4971:
4972: msd_dem_common_utilities.log_debug ('Exiting: msd_dem_upload_forecast.upload_cmro_pln_fctrs - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
4973:
4974: EXCEPTION
4975: WHEN OTHERS THEN
4976: errbuf := substr(SQLERRM,1,150);

Line 4978: msd_dem_common_utilities.log_message ('Exception: msd_dem_upload_forecast.upload_cmro_pln_fctrs - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

4974: EXCEPTION
4975: WHEN OTHERS THEN
4976: errbuf := substr(SQLERRM,1,150);
4977: retcode := -1 ;
4978: msd_dem_common_utilities.log_message ('Exception: msd_dem_upload_forecast.upload_cmro_pln_fctrs - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
4979: msd_dem_common_utilities.log_message (errbuf);
4980: msd_dem_common_utilities.log_message (' ');
4981:
4982: END UPLOAD_CMRO_PLN_FCTRS;

Line 4979: msd_dem_common_utilities.log_message (errbuf);

4975: WHEN OTHERS THEN
4976: errbuf := substr(SQLERRM,1,150);
4977: retcode := -1 ;
4978: msd_dem_common_utilities.log_message ('Exception: msd_dem_upload_forecast.upload_cmro_pln_fctrs - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
4979: msd_dem_common_utilities.log_message (errbuf);
4980: msd_dem_common_utilities.log_message (' ');
4981:
4982: END UPLOAD_CMRO_PLN_FCTRS;
4983:

Line 4980: msd_dem_common_utilities.log_message (' ');

4976: errbuf := substr(SQLERRM,1,150);
4977: retcode := -1 ;
4978: msd_dem_common_utilities.log_message ('Exception: msd_dem_upload_forecast.upload_cmro_pln_fctrs - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
4979: msd_dem_common_utilities.log_message (errbuf);
4980: msd_dem_common_utilities.log_message (' ');
4981:
4982: END UPLOAD_CMRO_PLN_FCTRS;
4983:
4984: