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_SOP dependencies on MSD_DEM_COMMON_UTILITIES

Line 33: msd_dem_common_utilities.get_lookup_value ('MSD_DEM_TABLES', 'SUPPLY_PLAN') ||

29: x_plan_id NUMBER := NULL;
30: BEGIN
31:
32: EXECUTE IMMEDIATE 'SELECT plan_id FROM ' ||
33: msd_dem_common_utilities.get_lookup_value ('MSD_DEM_TABLES', 'SUPPLY_PLAN') ||
34: ' WHERE supply_plan_id = ' || p_member_id
35: INTO x_plan_id;
36:
37: RETURN x_plan_id;

Line 58: msd_dem_common_utilities.get_lookup_value ('MSD_DEM_TABLES', 'SUPPLY_PLAN') ||

54: x_plan_type NUMBER := NULL;
55: BEGIN
56:
57: EXECUTE IMMEDIATE 'SELECT plan_type FROM ' ||
58: msd_dem_common_utilities.get_lookup_value ('MSD_DEM_TABLES', 'SUPPLY_PLAN') ||
59: ' WHERE supply_plan_id = ' || p_member_id
60: INTO x_plan_type;
61:
62: RETURN x_plan_type;

Line 483: msd_dem_common_utilities.log_debug ('Calling API_NOTIFY_APS_INTEGRATION - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

479: execute immediate l_sql;
480:
481:
482: /* Calling API to notify the application server to refresh its engine */
483: msd_dem_common_utilities.log_debug ('Calling API_NOTIFY_APS_INTEGRATION - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
484:
485: l_sql := 'begin ' || g_schema|| '.API_NOTIFY_APS_INTEGRATION('||l_profile_id1 ||'); end;';
486: execute immediate l_sql;
487:

Line 498: msd_dem_common_utilities.log_debug ('Calling API_NOTIFY_APS_INTEGRATION - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

494: execute immediate l_sql;
495:
496:
497: /* Calling API to notify the application server to refresh its engine */
498: msd_dem_common_utilities.log_debug ('Calling API_NOTIFY_APS_INTEGRATION - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
499:
500: l_sql := 'begin ' || g_schema|| '.API_NOTIFY_APS_INTEGRATION('||l_profile_id2 ||'); end;';
501: execute immediate l_sql;
502: else

Line 503: msd_dem_common_utilities.log_message('Demantra Schema not set');

499:
500: l_sql := 'begin ' || g_schema|| '.API_NOTIFY_APS_INTEGRATION('||l_profile_id2 ||'); end;';
501: execute immediate l_sql;
502: else
503: msd_dem_common_utilities.log_message('Demantra Schema not set');
504: end if;
505:
506:
507:

Line 553: x_dm_time_bucket := msd_dem_common_utilities.dm_time_level;

549: BEGIN
550: log_debug ('Entering: msd_dem_sop.load_ascp_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
551:
552: /* Get the lowest time bucket */
553: x_dm_time_bucket := msd_dem_common_utilities.dm_time_level;
554: IF (x_dm_time_bucket IS NULL)
555: THEN
556: retcode := -1;
557: errbuf := 'Unable to get lowest time bucket';

Line 707: x_dm_table := msd_dem_common_utilities.get_lookup_value ('MSD_DEM_TABLES', 'DM_WIZ_DM_DEF');

703:
704: log_debug ('Deleting time data from msd_dem_dates');
705: EXECUTE IMMEDIATE 'DELETE FROM msd_dem_dates';
706:
707: x_dm_table := msd_dem_common_utilities.get_lookup_value ('MSD_DEM_TABLES', 'DM_WIZ_DM_DEF');
708:
709: /* Get the time level info for the active data model */
710: x_sql := 'SELECT time_bucket, first_day_of_week, aggregation_method ' ||
711: ' FROM ' || x_dm_table ||

Line 749: x_source_time_table := msd_dem_common_utilities.get_lookup_value ('MSD_DEM_TABLES', 'INPUTS');

745: END IF;
746:
747: x_end_date := 'trunc(' || x_end_date || ') + 86399/86400, ';
748:
749: x_source_time_table := msd_dem_common_utilities.get_lookup_value ('MSD_DEM_TABLES', 'INPUTS');
750:
751: log_debug ('Inserting time data into msd_dem_dates');
752: x_sql := 'INSERT INTO msd_dem_dates' ||
753: ' (datet, num_of_days, start_date, end_date, last_update_date, last_updated_by, creation_date, created_by, last_update_login) ' ||

Line 1114: l_end_date := msd_dem_common_utilities.get_sno_plan_cutoff_date (p_plan_id);

1110:
1111: if l_plan_type = 6 then
1112:
1113: /* Get the end date for the SNO plan */
1114: l_end_date := msd_dem_common_utilities.get_sno_plan_cutoff_date (p_plan_id);
1115:
1116: msd_dem_query_utilities.get_query(l_retcode, l_stmt, 'MSD_DEM_PLANS', l_instance_id);
1117:
1118: if l_stmt is null then

Line 1202: l_stmt := replace(l_stmt, 'C_RESOURCE_TABLE', msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'BIIO_RESOURCES'));

1198: if l_stmt is null then
1199: return;
1200: end if;
1201:
1202: l_stmt := replace(l_stmt, 'C_RESOURCE_TABLE', msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'BIIO_RESOURCES'));
1203: l_stmt := replace(l_stmt, 'C_PLAN_NAME', '''' || l_plan_name || '''');
1204: l_stmt := replace(l_stmt, 'C_PLAN_ID', p_plan_id);
1205: l_stmt := replace(l_stmt, 'C_SCHEMANAME', fnd_profile.value('MSD_DEM_SCHEMA'));
1206:

Line 1224: l_end_date := msd_dem_common_utilities.get_sno_plan_cutoff_date (p_plan_id);

1220:
1221: if l_plan_type = 6 then
1222:
1223: /* Get the end date for the SNO plan */
1224: l_end_date := msd_dem_common_utilities.get_sno_plan_cutoff_date (p_plan_id);
1225:
1226: msd_dem_query_utilities.get_query(l_retcode, l_stmt, 'MSD_DEM_SCENARIO_RESOURCES_SNO', l_instance_id);
1227:
1228: if l_stmt is null then

Line 1232: l_stmt := replace(l_stmt, 'C_TARGET_TABLE', msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'BIIO_RESOURCES'));

1228: if l_stmt is null then
1229: return;
1230: end if;
1231:
1232: l_stmt := replace(l_stmt, 'C_TARGET_TABLE', msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'BIIO_RESOURCES'));
1233: l_stmt := replace(l_stmt, 'C_SRC_TABLE', msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'BIIO_RESOURCE_CAPACITY'));
1234: l_stmt := replace(l_stmt, 'C_SCHEMANAME', fnd_profile.value('MSD_DEM_SCHEMA'));
1235:
1236: execute immediate l_stmt;

Line 1233: l_stmt := replace(l_stmt, 'C_SRC_TABLE', msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'BIIO_RESOURCE_CAPACITY'));

1229: return;
1230: end if;
1231:
1232: l_stmt := replace(l_stmt, 'C_TARGET_TABLE', msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'BIIO_RESOURCES'));
1233: l_stmt := replace(l_stmt, 'C_SRC_TABLE', msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'BIIO_RESOURCE_CAPACITY'));
1234: l_stmt := replace(l_stmt, 'C_SCHEMANAME', fnd_profile.value('MSD_DEM_SCHEMA'));
1235:
1236: execute immediate l_stmt;
1237:

Line 1244: l_stmt := replace(l_stmt, 'C_TARGET_TABLE', msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'BIIO_RESOURCES'));

1240: if l_stmt is null then
1241: return;
1242: end if;
1243:
1244: l_stmt := replace(l_stmt, 'C_TARGET_TABLE', msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'BIIO_RESOURCES'));
1245: l_stmt := replace(l_stmt, 'C_SRC_TABLE', msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'BIIO_RESOURCE_CAPACITY'));
1246: l_stmt := replace(l_stmt, 'C_SCHEMANAME', fnd_profile.value('MSD_DEM_SCHEMA'));
1247:
1248: execute immediate l_stmt;

Line 1245: l_stmt := replace(l_stmt, 'C_SRC_TABLE', msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'BIIO_RESOURCE_CAPACITY'));

1241: return;
1242: end if;
1243:
1244: l_stmt := replace(l_stmt, 'C_TARGET_TABLE', msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'BIIO_RESOURCES'));
1245: l_stmt := replace(l_stmt, 'C_SRC_TABLE', msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'BIIO_RESOURCE_CAPACITY'));
1246: l_stmt := replace(l_stmt, 'C_SCHEMANAME', fnd_profile.value('MSD_DEM_SCHEMA'));
1247:
1248: execute immediate l_stmt;
1249:

Line 1256: l_stmt := replace(l_stmt, 'C_TARGET_TABLE', msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'BIIO_RESOURCES'));

1252: if l_stmt is null then
1253: return;
1254: end if;
1255:
1256: l_stmt := replace(l_stmt, 'C_TARGET_TABLE', msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'BIIO_RESOURCES'));
1257: l_stmt := replace(l_stmt, 'C_SRC_TABLE', msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'BIIO_RESOURCE_CAPACITY'));
1258: l_stmt := replace(l_stmt, 'C_SCHEMANAME', fnd_profile.value('MSD_DEM_SCHEMA'));
1259: l_stmt := replace(l_stmt, 'C_PLAN_START_DATE', 'to_date(''' || to_char(l_start_date, 'dd-mm-yyyy') || ''',''dd-mm-yyyy'')');
1260: l_stmt := replace(l_stmt, 'C_PLAN_END_DATE', 'to_date(''' || to_char(l_end_date, 'dd-mm-yyyy') || ''',''dd-mm-yyyy'')');

Line 1257: l_stmt := replace(l_stmt, 'C_SRC_TABLE', msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'BIIO_RESOURCE_CAPACITY'));

1253: return;
1254: end if;
1255:
1256: l_stmt := replace(l_stmt, 'C_TARGET_TABLE', msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'BIIO_RESOURCES'));
1257: l_stmt := replace(l_stmt, 'C_SRC_TABLE', msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'BIIO_RESOURCE_CAPACITY'));
1258: l_stmt := replace(l_stmt, 'C_SCHEMANAME', fnd_profile.value('MSD_DEM_SCHEMA'));
1259: l_stmt := replace(l_stmt, 'C_PLAN_START_DATE', 'to_date(''' || to_char(l_start_date, 'dd-mm-yyyy') || ''',''dd-mm-yyyy'')');
1260: l_stmt := replace(l_stmt, 'C_PLAN_END_DATE', 'to_date(''' || to_char(l_end_date, 'dd-mm-yyyy') || ''',''dd-mm-yyyy'')');
1261:

Line 1742: msd_dem_common_utilities.log_message ('Entering: msd_dem_sop.collect_sci_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

1738: lv_request_id1 NUMBER := to_number(NULL);
1739: lv_request_id2 NUMBER := to_number(NULL);
1740:
1741: BEGIN
1742: msd_dem_common_utilities.log_message ('Entering: msd_dem_sop.collect_sci_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1743:
1744:
1745: /* Launching two Conc. Programs (for each Import Integration
1746: Interfact definde for SCI Data) to have the collection

Line 1768: msd_dem_common_utilities.log_message ('Error launching concurrent program for SCI BACKLOG Integration Interface ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

1764:
1765: --commit;
1766: EXCEPTION
1767: WHEN OTHERS THEN
1768: msd_dem_common_utilities.log_message ('Error launching concurrent program for SCI BACKLOG Integration Interface ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1769: msd_dem_common_utilities.log_message (errbuf);
1770: END;
1771:
1772: BEGIN

Line 1769: msd_dem_common_utilities.log_message (errbuf);

1765: --commit;
1766: EXCEPTION
1767: WHEN OTHERS THEN
1768: msd_dem_common_utilities.log_message ('Error launching concurrent program for SCI BACKLOG Integration Interface ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1769: msd_dem_common_utilities.log_message (errbuf);
1770: END;
1771:
1772: BEGIN
1773: lv_request_id2 := fnd_request.submit_request('MSD',

Line 1790: msd_dem_common_utilities.log_message ('Error launching concurrent program for SCI OTHER Integration Interface ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

1786:
1787: --commit;
1788: EXCEPTION
1789: WHEN OTHERS THEN
1790: msd_dem_common_utilities.log_message ('Error launching concurrent program for SCI OTHER Integration Interface ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1791: msd_dem_common_utilities.log_message (errbuf);
1792: END;
1793:
1794: IF ( lv_request_id1 <> 0 ) AND ( lv_request_id2 <> 0 ) THEN

Line 1791: msd_dem_common_utilities.log_message (errbuf);

1787: --commit;
1788: EXCEPTION
1789: WHEN OTHERS THEN
1790: msd_dem_common_utilities.log_message ('Error launching concurrent program for SCI OTHER Integration Interface ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1791: msd_dem_common_utilities.log_message (errbuf);
1792: END;
1793:
1794: IF ( lv_request_id1 <> 0 ) AND ( lv_request_id2 <> 0 ) THEN
1795:

Line 1796: msd_dem_common_utilities.log_message ('Successfully launched concurrent programs for SCI Integration Interfaces. Please see the following concurrent programs for the individual request logs. '

1792: END;
1793:
1794: IF ( lv_request_id1 <> 0 ) AND ( lv_request_id2 <> 0 ) THEN
1795:
1796: msd_dem_common_utilities.log_message ('Successfully launched concurrent programs for SCI Integration Interfaces. Please see the following concurrent programs for the individual request logs. '
1797: || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1798: msd_dem_common_utilities.log_message ('Request ID for the SCI BACKLOG Integration Interface concurrent program is - '|| lv_request_id1 ||' '|| TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1799: msd_dem_common_utilities.log_message ('Request ID for the SCI OTHER Integration Interface concurrent program is - '|| lv_request_id2 ||' '|| TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1800:

Line 1798: msd_dem_common_utilities.log_message ('Request ID for the SCI BACKLOG Integration Interface concurrent program is - '|| lv_request_id1 ||' '|| TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

1794: IF ( lv_request_id1 <> 0 ) AND ( lv_request_id2 <> 0 ) THEN
1795:
1796: msd_dem_common_utilities.log_message ('Successfully launched concurrent programs for SCI Integration Interfaces. Please see the following concurrent programs for the individual request logs. '
1797: || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1798: msd_dem_common_utilities.log_message ('Request ID for the SCI BACKLOG Integration Interface concurrent program is - '|| lv_request_id1 ||' '|| TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1799: msd_dem_common_utilities.log_message ('Request ID for the SCI OTHER Integration Interface concurrent program is - '|| lv_request_id2 ||' '|| TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1800:
1801: ELSE
1802:

Line 1799: msd_dem_common_utilities.log_message ('Request ID for the SCI OTHER Integration Interface concurrent program is - '|| lv_request_id2 ||' '|| TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

1795:
1796: msd_dem_common_utilities.log_message ('Successfully launched concurrent programs for SCI Integration Interfaces. Please see the following concurrent programs for the individual request logs. '
1797: || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1798: msd_dem_common_utilities.log_message ('Request ID for the SCI BACKLOG Integration Interface concurrent program is - '|| lv_request_id1 ||' '|| TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1799: msd_dem_common_utilities.log_message ('Request ID for the SCI OTHER Integration Interface concurrent program is - '|| lv_request_id2 ||' '|| TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1800:
1801: ELSE
1802:
1803: msd_dem_common_utilities.log_message ('Request ID for the SCI BACKLOG Integration Interface concurrent program is - '|| lv_request_id1 ||' '|| TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

Line 1803: msd_dem_common_utilities.log_message ('Request ID for the SCI BACKLOG Integration Interface concurrent program is - '|| lv_request_id1 ||' '|| TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

1799: msd_dem_common_utilities.log_message ('Request ID for the SCI OTHER Integration Interface concurrent program is - '|| lv_request_id2 ||' '|| TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1800:
1801: ELSE
1802:
1803: msd_dem_common_utilities.log_message ('Request ID for the SCI BACKLOG Integration Interface concurrent program is - '|| lv_request_id1 ||' '|| TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1804: msd_dem_common_utilities.log_message ('Request ID for the SCI OTHER Integration Interface concurrent program is - '|| lv_request_id2 ||' '|| TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1805: msd_dem_common_utilities.log_message ('Error launching concurrent programs for SCI Integration Interfaces. Please relaunch the SCI Collections. ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1806: retcode := -1 ;
1807:

Line 1804: msd_dem_common_utilities.log_message ('Request ID for the SCI OTHER Integration Interface concurrent program is - '|| lv_request_id2 ||' '|| TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

1800:
1801: ELSE
1802:
1803: msd_dem_common_utilities.log_message ('Request ID for the SCI BACKLOG Integration Interface concurrent program is - '|| lv_request_id1 ||' '|| TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1804: msd_dem_common_utilities.log_message ('Request ID for the SCI OTHER Integration Interface concurrent program is - '|| lv_request_id2 ||' '|| TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1805: msd_dem_common_utilities.log_message ('Error launching concurrent programs for SCI Integration Interfaces. Please relaunch the SCI Collections. ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1806: retcode := -1 ;
1807:
1808: END IF;

Line 1805: msd_dem_common_utilities.log_message ('Error launching concurrent programs for SCI Integration Interfaces. Please relaunch the SCI Collections. ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

1801: ELSE
1802:
1803: msd_dem_common_utilities.log_message ('Request ID for the SCI BACKLOG Integration Interface concurrent program is - '|| lv_request_id1 ||' '|| TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1804: msd_dem_common_utilities.log_message ('Request ID for the SCI OTHER Integration Interface concurrent program is - '|| lv_request_id2 ||' '|| TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1805: msd_dem_common_utilities.log_message ('Error launching concurrent programs for SCI Integration Interfaces. Please relaunch the SCI Collections. ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1806: retcode := -1 ;
1807:
1808: END IF;
1809:

Line 1812: msd_dem_common_utilities.log_message ('Exiting: msd_dem_sop.collect_sci_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

1808: END IF;
1809:
1810: COMMIT;
1811:
1812: msd_dem_common_utilities.log_message ('Exiting: msd_dem_sop.collect_sci_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1813: EXCEPTION
1814: WHEN OTHERS THEN
1815: retcode := -1 ;
1816: errbuf := substr(SQLERRM,1,150);

Line 1817: msd_dem_common_utilities.log_message ('Exception: msd_dem_sop.collect_sci_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

1813: EXCEPTION
1814: WHEN OTHERS THEN
1815: retcode := -1 ;
1816: errbuf := substr(SQLERRM,1,150);
1817: msd_dem_common_utilities.log_message ('Exception: msd_dem_sop.collect_sci_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1818: msd_dem_common_utilities.log_message (errbuf);
1819: RETURN;
1820:
1821: END COLLECT_SCI_DATA;

Line 1818: msd_dem_common_utilities.log_message (errbuf);

1814: WHEN OTHERS THEN
1815: retcode := -1 ;
1816: errbuf := substr(SQLERRM,1,150);
1817: msd_dem_common_utilities.log_message ('Exception: msd_dem_sop.collect_sci_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1818: msd_dem_common_utilities.log_message (errbuf);
1819: RETURN;
1820:
1821: END COLLECT_SCI_DATA;
1822:

Line 1861: msd_dem_common_utilities.log_message ('Entering: msd_dem_sop.launch_sci_data_loads - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

1857:
1858:
1859: BEGIN
1860:
1861: msd_dem_common_utilities.log_message ('Entering: msd_dem_sop.launch_sci_data_loads - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1862:
1863: retcode := 0;
1864:
1865: /* SCI BACKLOG */

Line 1892: msd_dem_common_utilities.log_message ('An Error occured in API call MSD_DEM_COLLECT_RETURN_HISTORY.COLLECT_RETURN_HISTORY_DATA,while inserting Total Backlog Data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

1888: IF l_retcode1 = -1
1889: THEN
1890: retcode := l_retcode1;
1891: errbuf := l_errbuff1;
1892: msd_dem_common_utilities.log_message ('An Error occured in API call MSD_DEM_COLLECT_RETURN_HISTORY.COLLECT_RETURN_HISTORY_DATA,while inserting Total Backlog Data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1893: RETURN;
1894: END IF;
1895:
1896: EXCEPTION

Line 1900: msd_dem_common_utilities.log_message ('Exception while inserting Total Backlog Data in the table BIIIO_SCI_BACKLOG - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

1896: EXCEPTION
1897: WHEN OTHERS THEN
1898: retcode := -1 ;
1899: errbuf := substr(SQLERRM,1,150);
1900: msd_dem_common_utilities.log_message ('Exception while inserting Total Backlog Data in the table BIIIO_SCI_BACKLOG - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1901: msd_dem_common_utilities.log_message (errbuf);
1902: RETURN;
1903: END;
1904:

Line 1901: msd_dem_common_utilities.log_message (errbuf);

1897: WHEN OTHERS THEN
1898: retcode := -1 ;
1899: errbuf := substr(SQLERRM,1,150);
1900: msd_dem_common_utilities.log_message ('Exception while inserting Total Backlog Data in the table BIIIO_SCI_BACKLOG - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1901: msd_dem_common_utilities.log_message (errbuf);
1902: RETURN;
1903: END;
1904:
1905: /* Past Due Backlog*/

Line 1928: msd_dem_common_utilities.log_message ('An Error occured in API call MSD_DEM_COLLECT_RETURN_HISTORY.COLLECT_RETURN_HISTORY_DATA,while merging Past Due Backlog Data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

1924: IF l_retcode2 = -1
1925: THEN
1926: retcode := l_retcode2;
1927: errbuf := l_errbuff2;
1928: msd_dem_common_utilities.log_message ('An Error occured in API call MSD_DEM_COLLECT_RETURN_HISTORY.COLLECT_RETURN_HISTORY_DATA,while merging Past Due Backlog Data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1929: RETURN;
1930: END IF;
1931:
1932:

Line 1937: msd_dem_common_utilities.log_message ('Exception while merging Past Due Backlog Data in the table BIIIO_SCI_BACKLOG - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

1933: EXCEPTION
1934: WHEN OTHERS THEN
1935: retcode := -1 ;
1936: errbuf := substr(SQLERRM,1,150);
1937: msd_dem_common_utilities.log_message ('Exception while merging Past Due Backlog Data in the table BIIIO_SCI_BACKLOG - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1938: msd_dem_common_utilities.log_message (errbuf);
1939: RETURN;
1940: END;
1941:

Line 1938: msd_dem_common_utilities.log_message (errbuf);

1934: WHEN OTHERS THEN
1935: retcode := -1 ;
1936: errbuf := substr(SQLERRM,1,150);
1937: msd_dem_common_utilities.log_message ('Exception while merging Past Due Backlog Data in the table BIIIO_SCI_BACKLOG - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1938: msd_dem_common_utilities.log_message (errbuf);
1939: RETURN;
1940: END;
1941:
1942: IF ( l_retcode1 = 1 ) OR ( l_retcode2 = 1)

Line 1945: msd_dem_common_utilities.log_message ('Warning Text for Total Backlog Insertion is - ' || l_errbuff1);

1941:
1942: IF ( l_retcode1 = 1 ) OR ( l_retcode2 = 1)
1943: THEN
1944: retcode := 1;
1945: msd_dem_common_utilities.log_message ('Warning Text for Total Backlog Insertion is - ' || l_errbuff1);
1946: msd_dem_common_utilities.log_message ('Warning Text for Past Due Backlog Merge is - ' || l_errbuff2);
1947: errbuf := l_errbuff1 || l_errbuff2 ;
1948: END IF;
1949:

Line 1946: msd_dem_common_utilities.log_message ('Warning Text for Past Due Backlog Merge is - ' || l_errbuff2);

1942: IF ( l_retcode1 = 1 ) OR ( l_retcode2 = 1)
1943: THEN
1944: retcode := 1;
1945: msd_dem_common_utilities.log_message ('Warning Text for Total Backlog Insertion is - ' || l_errbuff1);
1946: msd_dem_common_utilities.log_message ('Warning Text for Past Due Backlog Merge is - ' || l_errbuff2);
1947: errbuf := l_errbuff1 || l_errbuff2 ;
1948: END IF;
1949:
1950: /* Call - Level Code Generation Query */

Line 1974: msd_dem_common_utilities.log_message(l_sql_stmnt);

1970: ||' and mtil.partner_type = 2 '
1971: ||' and mtil.tp_id = mtp.partner_id '
1972: ||' )';
1973:
1974: msd_dem_common_utilities.log_message(l_sql_stmnt);
1975:
1976: begin
1977: execute immediate l_sql_stmnt;
1978: exception

Line 1987: msd_dem_common_utilities.log_message(l_sql_stmnt);

1983: l_sql_stmnt := ' UPDATE ' || x_dest_table
1984: || ' SET level3 = ''' || msd_dem_sr_util.get_null_code || ''' '
1985: || ' WHERE level3 IS NULL ';
1986:
1987: msd_dem_common_utilities.log_message(l_sql_stmnt);
1988:
1989: begin
1990: execute immediate l_sql_stmnt;
1991: exception

Line 2039: msd_dem_common_utilities.log_message ('An Error occured in API call MSD_DEM_COLLECT_RETURN_HISTORY.COLLECT_RETURN_HISTORY_DATA,while inserting On Hand Inventory Data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

2035: IF l_retcode1 = -1
2036: THEN
2037: retcode := l_retcode1;
2038: errbuf := l_errbuff1;
2039: msd_dem_common_utilities.log_message ('An Error occured in API call MSD_DEM_COLLECT_RETURN_HISTORY.COLLECT_RETURN_HISTORY_DATA,while inserting On Hand Inventory Data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
2040: RETURN;
2041: END IF;
2042: EXCEPTION
2043: WHEN OTHERS THEN

Line 2046: msd_dem_common_utilities.log_message ('Exception while inserting ON-Hand Inventory Data in the table BIIIO_SCI - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

2042: EXCEPTION
2043: WHEN OTHERS THEN
2044: retcode := -1 ;
2045: errbuf := substr(SQLERRM,1,150);
2046: msd_dem_common_utilities.log_message ('Exception while inserting ON-Hand Inventory Data in the table BIIIO_SCI - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
2047: msd_dem_common_utilities.log_message (errbuf);
2048: RETURN;
2049:
2050: END;

Line 2047: msd_dem_common_utilities.log_message (errbuf);

2043: WHEN OTHERS THEN
2044: retcode := -1 ;
2045: errbuf := substr(SQLERRM,1,150);
2046: msd_dem_common_utilities.log_message ('Exception while inserting ON-Hand Inventory Data in the table BIIIO_SCI - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
2047: msd_dem_common_utilities.log_message (errbuf);
2048: RETURN;
2049:
2050: END;
2051:

Line 2075: msd_dem_common_utilities.log_message ('An Error occured in API call MSD_DEM_COLLECT_RETURN_HISTORY.COLLECT_RETURN_HISTORY_DATA,while merging Actual Production Data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

2071: IF l_retcode2 = -1
2072: THEN
2073: retcode := l_retcode2;
2074: errbuf := l_errbuff2;
2075: msd_dem_common_utilities.log_message ('An Error occured in API call MSD_DEM_COLLECT_RETURN_HISTORY.COLLECT_RETURN_HISTORY_DATA,while merging Actual Production Data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
2076: RETURN;
2077: END IF;
2078:
2079:

Line 2084: msd_dem_common_utilities.log_message ('Exception while merging Actual Production Data in the table BIIIO_SCI - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

2080: EXCEPTION
2081: WHEN OTHERS THEN
2082: retcode := -1 ;
2083: errbuf := substr(SQLERRM,1,150);
2084: msd_dem_common_utilities.log_message ('Exception while merging Actual Production Data in the table BIIIO_SCI - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
2085: msd_dem_common_utilities.log_message (errbuf);
2086: RETURN;
2087: END;
2088:

Line 2085: msd_dem_common_utilities.log_message (errbuf);

2081: WHEN OTHERS THEN
2082: retcode := -1 ;
2083: errbuf := substr(SQLERRM,1,150);
2084: msd_dem_common_utilities.log_message ('Exception while merging Actual Production Data in the table BIIIO_SCI - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
2085: msd_dem_common_utilities.log_message (errbuf);
2086: RETURN;
2087: END;
2088:
2089: IF ( l_retcode1 = 1 ) OR ( l_retcode2 = 1)

Line 2092: msd_dem_common_utilities.log_message ('Warning Text for On-Hand Inventory Insertion is - ' || l_errbuff1);

2088:
2089: IF ( l_retcode1 = 1 ) OR ( l_retcode2 = 1)
2090: THEN
2091: retcode := 1;
2092: msd_dem_common_utilities.log_message ('Warning Text for On-Hand Inventory Insertion is - ' || l_errbuff1);
2093: msd_dem_common_utilities.log_message ('Warning Text for Actual Production Merge is - ' || l_errbuff2);
2094: errbuf := l_errbuff1 || l_errbuff2 ;
2095: END IF;
2096: END IF; -- IF ( p_entity = G_SCI_BACKLOG )

Line 2093: msd_dem_common_utilities.log_message ('Warning Text for Actual Production Merge is - ' || l_errbuff2);

2089: IF ( l_retcode1 = 1 ) OR ( l_retcode2 = 1)
2090: THEN
2091: retcode := 1;
2092: msd_dem_common_utilities.log_message ('Warning Text for On-Hand Inventory Insertion is - ' || l_errbuff1);
2093: msd_dem_common_utilities.log_message ('Warning Text for Actual Production Merge is - ' || l_errbuff2);
2094: errbuf := l_errbuff1 || l_errbuff2 ;
2095: END IF;
2096: END IF; -- IF ( p_entity = G_SCI_BACKLOG )
2097:

Line 2098: msd_dem_common_utilities.log_message ('Exiting: msd_dem_sop.launch_sci_data_loads - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

2094: errbuf := l_errbuff1 || l_errbuff2 ;
2095: END IF;
2096: END IF; -- IF ( p_entity = G_SCI_BACKLOG )
2097:
2098: msd_dem_common_utilities.log_message ('Exiting: msd_dem_sop.launch_sci_data_loads - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
2099:
2100: EXCEPTION
2101: WHEN OTHERS THEN
2102: retcode := -1 ;

Line 2104: msd_dem_common_utilities.log_message ('Exception: msd_dem_sop.launch_sci_data_loads- ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

2100: EXCEPTION
2101: WHEN OTHERS THEN
2102: retcode := -1 ;
2103: errbuf := substr(SQLERRM,1,150);
2104: msd_dem_common_utilities.log_message ('Exception: msd_dem_sop.launch_sci_data_loads- ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
2105: msd_dem_common_utilities.log_message (errbuf);
2106: RETURN;
2107:
2108: END LAUNCH_SCI_DATA_LOADS;

Line 2105: msd_dem_common_utilities.log_message (errbuf);

2101: WHEN OTHERS THEN
2102: retcode := -1 ;
2103: errbuf := substr(SQLERRM,1,150);
2104: msd_dem_common_utilities.log_message ('Exception: msd_dem_sop.launch_sci_data_loads- ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
2105: msd_dem_common_utilities.log_message (errbuf);
2106: RETURN;
2107:
2108: END LAUNCH_SCI_DATA_LOADS;
2109: