DBA Data[Home] [Help]

APPS.MSD_DEM_SOP dependencies on MSD_DEM_COLLECT_RETURN_HISTORY

Line 1872: MSD_DEM_COLLECT_RETURN_HISTORY.COLLECT_RETURN_HISTORY_DATA

1868:
1869: /* Total Backlog */
1870: BEGIN
1871:
1872: MSD_DEM_COLLECT_RETURN_HISTORY.COLLECT_RETURN_HISTORY_DATA
1873: (l_errbuff1,
1874: l_retcode1,
1875: p_sr_instance_id,
1876: p_collection_group,

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 1908: MSD_DEM_COLLECT_RETURN_HISTORY.COLLECT_RETURN_HISTORY_DATA

1904:
1905: /* Past Due Backlog*/
1906: BEGIN
1907:
1908: MSD_DEM_COLLECT_RETURN_HISTORY.COLLECT_RETURN_HISTORY_DATA
1909: (l_errbuff2,
1910: l_retcode2,
1911: p_sr_instance_id,
1912: p_collection_group,

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 2018: MSD_DEM_COLLECT_RETURN_HISTORY.COLLECT_RETURN_HISTORY_DATA

2014:
2015: -- On-Hand Inventory
2016:
2017: BEGIN
2018: MSD_DEM_COLLECT_RETURN_HISTORY.COLLECT_RETURN_HISTORY_DATA
2019: (l_errbuff1,
2020: l_retcode1,
2021: p_sr_instance_id,
2022: p_collection_group,

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 2055: MSD_DEM_COLLECT_RETURN_HISTORY.COLLECT_RETURN_HISTORY_DATA

2051:
2052: -- Actual Production
2053: BEGIN
2054:
2055: MSD_DEM_COLLECT_RETURN_HISTORY.COLLECT_RETURN_HISTORY_DATA
2056: (l_errbuff2,
2057: l_retcode2,
2058: p_sr_instance_id,
2059: p_collection_group,

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: