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.MSC_CL_COLLECTION dependencies on MSC_CL_OTHER_ODS_LOAD

Line 1643: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_SUB_INVENTORY');

1639:
1640: ELSIF pTASKNUM= TASK_SUB_INVENTORY THEN
1641:
1642: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1643: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_SUB_INVENTORY');
1644: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1645: MSC_CL_OTHER_ODS_LOAD.LOAD_SUB_INVENTORY;
1646:
1647: ELSIF pTASKNUM= TASK_HARD_RESERVATION THEN

Line 1645: MSC_CL_OTHER_ODS_LOAD.LOAD_SUB_INVENTORY;

1641:
1642: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1643: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_SUB_INVENTORY');
1644: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1645: MSC_CL_OTHER_ODS_LOAD.LOAD_SUB_INVENTORY;
1646:
1647: ELSIF pTASKNUM= TASK_HARD_RESERVATION THEN
1648:
1649: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');

Line 1657: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_SOURCING');

1653:
1654: ELSIF pTASKNUM= TASK_SOURCING THEN
1655:
1656: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1657: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_SOURCING');
1658: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1659: MSC_CL_OTHER_ODS_LOAD.LOAD_SOURCING;
1660: /* commented as a part of bug fix 5233688*/
1661:

Line 1659: MSC_CL_OTHER_ODS_LOAD.LOAD_SOURCING;

1655:
1656: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1657: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_SOURCING');
1658: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1659: MSC_CL_OTHER_ODS_LOAD.LOAD_SOURCING;
1660: /* commented as a part of bug fix 5233688*/
1661:
1662: ELSIF pTASKNUM= TASK_SUPPLIER_CAPACITY THEN
1663:

Line 1769: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_UNIT_NUMBER');

1765:
1766: ELSIF pTASKNUM= TASK_UNIT_NUMBER THEN
1767:
1768: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1769: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_UNIT_NUMBER');
1770: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1771: MSC_CL_OTHER_ODS_LOAD.LOAD_UNIT_NUMBER;
1772:
1773: ELSIF pTASKNUM= TASK_SAFETY_STOCK THEN

Line 1771: MSC_CL_OTHER_ODS_LOAD.LOAD_UNIT_NUMBER;

1767:
1768: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1769: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_UNIT_NUMBER');
1770: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1771: MSC_CL_OTHER_ODS_LOAD.LOAD_UNIT_NUMBER;
1772:
1773: ELSIF pTASKNUM= TASK_SAFETY_STOCK THEN
1774:
1775: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');

Line 1776: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_SAFETY_STOCK');

1772:
1773: ELSIF pTASKNUM= TASK_SAFETY_STOCK THEN
1774:
1775: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1776: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_SAFETY_STOCK');
1777: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1778: MSC_CL_OTHER_ODS_LOAD.LOAD_SAFETY_STOCK;
1779:
1780: ELSIF pTASKNUM= TASK_PROJECT THEN

Line 1778: MSC_CL_OTHER_ODS_LOAD.LOAD_SAFETY_STOCK;

1774:
1775: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1776: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_SAFETY_STOCK');
1777: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1778: MSC_CL_OTHER_ODS_LOAD.LOAD_SAFETY_STOCK;
1779:
1780: ELSIF pTASKNUM= TASK_PROJECT THEN
1781:
1782: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');

Line 1783: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_PROJECT');

1779:
1780: ELSIF pTASKNUM= TASK_PROJECT THEN
1781:
1782: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1783: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_PROJECT');
1784: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1785: MSC_CL_OTHER_ODS_LOAD.LOAD_PROJECT;
1786:
1787: ELSIF pTASKNUM= TASK_PARAMETER THEN

Line 1785: MSC_CL_OTHER_ODS_LOAD.LOAD_PROJECT;

1781:
1782: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1783: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_PROJECT');
1784: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1785: MSC_CL_OTHER_ODS_LOAD.LOAD_PROJECT;
1786:
1787: ELSIF pTASKNUM= TASK_PARAMETER THEN
1788:
1789: NULL;

Line 1799: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_BIS_PFMC_MEASURES');

1795: ELSIF pTASKNUM= TASK_BIS_PFMC_MEASURES THEN
1796:
1797: IF v_apps_ver <> MSC_UTIL.G_APPS107 THEN
1798: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1799: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_BIS_PFMC_MEASURES');
1800: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1801: MSC_CL_OTHER_ODS_LOAD.LOAD_BIS_PFMC_MEASURES;
1802: END IF;
1803:

Line 1801: MSC_CL_OTHER_ODS_LOAD.LOAD_BIS_PFMC_MEASURES;

1797: IF v_apps_ver <> MSC_UTIL.G_APPS107 THEN
1798: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1799: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_BIS_PFMC_MEASURES');
1800: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1801: MSC_CL_OTHER_ODS_LOAD.LOAD_BIS_PFMC_MEASURES;
1802: END IF;
1803:
1804: ELSIF pTASKNUM= TASK_BIS_TARGET_LEVELS THEN
1805:

Line 1808: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_BIS_TARGET_LEVELS');

1804: ELSIF pTASKNUM= TASK_BIS_TARGET_LEVELS THEN
1805:
1806: IF v_apps_ver <> MSC_UTIL.G_APPS107 THEN
1807: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1808: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_BIS_TARGET_LEVELS');
1809: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1810: MSC_CL_OTHER_ODS_LOAD.LOAD_BIS_TARGET_LEVELS;
1811: END IF;
1812:

Line 1810: MSC_CL_OTHER_ODS_LOAD.LOAD_BIS_TARGET_LEVELS;

1806: IF v_apps_ver <> MSC_UTIL.G_APPS107 THEN
1807: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1808: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_BIS_TARGET_LEVELS');
1809: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1810: MSC_CL_OTHER_ODS_LOAD.LOAD_BIS_TARGET_LEVELS;
1811: END IF;
1812:
1813: ELSIF pTASKNUM= TASK_BIS_TARGETS THEN
1814:

Line 1817: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_BIS_TARGETS');

1813: ELSIF pTASKNUM= TASK_BIS_TARGETS THEN
1814:
1815: IF v_apps_ver <> MSC_UTIL.G_APPS107 THEN
1816: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1817: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_BIS_TARGETS');
1818: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1819: MSC_CL_OTHER_ODS_LOAD.LOAD_BIS_TARGETS;
1820: END IF;
1821:

Line 1819: MSC_CL_OTHER_ODS_LOAD.LOAD_BIS_TARGETS;

1815: IF v_apps_ver <> MSC_UTIL.G_APPS107 THEN
1816: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1817: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_BIS_TARGETS');
1818: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1819: MSC_CL_OTHER_ODS_LOAD.LOAD_BIS_TARGETS;
1820: END IF;
1821:
1822: ELSIF pTASKNUM= TASK_BIS_BUSINESS_PLANS THEN
1823:

Line 1826: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_BIS_BUSINESS_PLANS');

1822: ELSIF pTASKNUM= TASK_BIS_BUSINESS_PLANS THEN
1823:
1824: IF v_apps_ver <> MSC_UTIL.G_APPS107 THEN
1825: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1826: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_BIS_BUSINESS_PLANS');
1827: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1828: MSC_CL_OTHER_ODS_LOAD.LOAD_BIS_BUSINESS_PLANS;
1829: END IF;
1830:

Line 1828: MSC_CL_OTHER_ODS_LOAD.LOAD_BIS_BUSINESS_PLANS;

1824: IF v_apps_ver <> MSC_UTIL.G_APPS107 THEN
1825: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1826: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_BIS_BUSINESS_PLANS');
1827: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1828: MSC_CL_OTHER_ODS_LOAD.LOAD_BIS_BUSINESS_PLANS;
1829: END IF;
1830:
1831: ELSIF pTASKNUM= TASK_BIS_PERIODS THEN
1832:

Line 1834: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_BIS_PERIODS');

1830:
1831: ELSIF pTASKNUM= TASK_BIS_PERIODS THEN
1832:
1833: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1834: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_BIS_PERIODS');
1835: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1836: MSC_CL_OTHER_ODS_LOAD.LOAD_BIS_PERIODS;
1837:
1838: ELSIF pTASKNUM= TASK_ATP_RULES THEN

Line 1836: MSC_CL_OTHER_ODS_LOAD.LOAD_BIS_PERIODS;

1832:
1833: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1834: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_BIS_PERIODS');
1835: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1836: MSC_CL_OTHER_ODS_LOAD.LOAD_BIS_PERIODS;
1837:
1838: ELSIF pTASKNUM= TASK_ATP_RULES THEN
1839:
1840: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');

Line 1841: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_ATP_RULES');

1837:
1838: ELSIF pTASKNUM= TASK_ATP_RULES THEN
1839:
1840: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1841: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_ATP_RULES');
1842: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1843: MSC_CL_OTHER_ODS_LOAD.LOAD_ATP_RULES;
1844:
1845: ELSIF pTASKNUM= TASK_NET_RESOURCE_AVAIL THEN

Line 1843: MSC_CL_OTHER_ODS_LOAD.LOAD_ATP_RULES;

1839:
1840: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1841: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_ATP_RULES');
1842: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1843: MSC_CL_OTHER_ODS_LOAD.LOAD_ATP_RULES;
1844:
1845: ELSIF pTASKNUM= TASK_NET_RESOURCE_AVAIL THEN
1846:
1847: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');

Line 1855: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_PLANNERS');

1851:
1852: ELSIF pTASKNUM= TASK_PLANNERS THEN
1853:
1854: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1855: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_PLANNERS');
1856: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1857: MSC_CL_OTHER_ODS_LOAD.LOAD_PLANNERS;
1858:
1859: ELSIF pTASKNUM= TASK_DEMAND_CLASS THEN

Line 1857: MSC_CL_OTHER_ODS_LOAD.LOAD_PLANNERS;

1853:
1854: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1855: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_PLANNERS');
1856: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1857: MSC_CL_OTHER_ODS_LOAD.LOAD_PLANNERS;
1858:
1859: ELSIF pTASKNUM= TASK_DEMAND_CLASS THEN
1860:
1861: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');

Line 1862: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_DEMAND_CLASS');

1858:
1859: ELSIF pTASKNUM= TASK_DEMAND_CLASS THEN
1860:
1861: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1862: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_DEMAND_CLASS');
1863: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1864: MSC_CL_OTHER_ODS_LOAD.LOAD_DEMAND_CLASS;
1865:
1866: ELSIF pTASKNUM = TASK_ITEM_SUBSTITUTES THEN

Line 1864: MSC_CL_OTHER_ODS_LOAD.LOAD_DEMAND_CLASS;

1860:
1861: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1862: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_DEMAND_CLASS');
1863: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1864: MSC_CL_OTHER_ODS_LOAD.LOAD_DEMAND_CLASS;
1865:
1866: ELSIF pTASKNUM = TASK_ITEM_SUBSTITUTES THEN
1867:
1868: IF (v_apps_ver >= MSC_UTIL.G_APPS115) OR v_is_legacy_refresh THEN

Line 1882: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_TRIP');

1878:
1879: IF (v_apps_ver >= MSC_UTIL.G_APPS115) OR v_is_legacy_refresh THEN
1880:
1881: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1882: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_TRIP');
1883: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1884: MSC_CL_OTHER_ODS_LOAD.LOAD_TRIP;
1885:
1886: END IF;

Line 1884: MSC_CL_OTHER_ODS_LOAD.LOAD_TRIP;

1880:
1881: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1882: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_TRIP');
1883: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1884: MSC_CL_OTHER_ODS_LOAD.LOAD_TRIP;
1885:
1886: END IF;
1887: /* ds change start */
1888: ELSIF pTASKNUM= TASK_RES_INST_REQ THEN

Line 1922: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_SALES_CHANNEL');

1918: END IF;
1919: /* ds change end */
1920: ELSIF pTASKNUM= TASK_SALES_CHANNEL THEN
1921: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1922: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_SALES_CHANNEL');
1923: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1924: -- LOG_MESSAGE(FND_MESSAGE.GET);
1925: MSC_CL_OTHER_ODS_LOAD.LOAD_SALES_CHANNEL;
1926: ELSIF pTASKNUM= TASK_FISCAL_CALENDAR THEN

Line 1925: MSC_CL_OTHER_ODS_LOAD.LOAD_SALES_CHANNEL;

1921: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1922: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_SALES_CHANNEL');
1923: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1924: -- LOG_MESSAGE(FND_MESSAGE.GET);
1925: MSC_CL_OTHER_ODS_LOAD.LOAD_SALES_CHANNEL;
1926: ELSIF pTASKNUM= TASK_FISCAL_CALENDAR THEN
1927: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1928: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_FISCAL_CALENDAR');
1929: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);

Line 1928: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_FISCAL_CALENDAR');

1924: -- LOG_MESSAGE(FND_MESSAGE.GET);
1925: MSC_CL_OTHER_ODS_LOAD.LOAD_SALES_CHANNEL;
1926: ELSIF pTASKNUM= TASK_FISCAL_CALENDAR THEN
1927: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1928: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_FISCAL_CALENDAR');
1929: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1930: -- LOG_MESSAGE(FND_MESSAGE.GET);
1931: MSC_CL_OTHER_ODS_LOAD.LOAD_FISCAL_CALENDAR;
1932:

Line 1931: MSC_CL_OTHER_ODS_LOAD.LOAD_FISCAL_CALENDAR;

1927: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1928: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_FISCAL_CALENDAR');
1929: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1930: -- LOG_MESSAGE(FND_MESSAGE.GET);
1931: MSC_CL_OTHER_ODS_LOAD.LOAD_FISCAL_CALENDAR;
1932:
1933: ELSIF pTASKNUM= TASK_PAYBACK_DEMAND_SUPPLY THEN
1934: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1935: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LOAD_PAYBACK_DEMANDS');

Line 1946: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_CURRENCY_CONVERSION');

1942: MSC_CL_SUPPLY_ODS_LOAD.LOAD_PAYBACK_SUPPLIES;
1943:
1944: ELSIF pTASKNUM= TASK_CURRENCY_CONVERSION THEN ---- for bug # 6469722
1945: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1946: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_CURRENCY_CONVERSION');
1947: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1948: IF (MSC_CL_OTHER_PULL.G_MSC_HUB_CURR_CODE IS NOT NULL) AND (v_apps_ver >= MSC_UTIL.G_APPS115) THEN
1949: MSC_CL_OTHER_ODS_LOAD.LOAD_CURRENCY_CONVERSION;
1950: ELSE

Line 1949: MSC_CL_OTHER_ODS_LOAD.LOAD_CURRENCY_CONVERSION;

1945: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1946: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_CURRENCY_CONVERSION');
1947: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1948: IF (MSC_CL_OTHER_PULL.G_MSC_HUB_CURR_CODE IS NOT NULL) AND (v_apps_ver >= MSC_UTIL.G_APPS115) THEN
1949: MSC_CL_OTHER_ODS_LOAD.LOAD_CURRENCY_CONVERSION;
1950: ELSE
1951: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Currency Data is not collected as MSC:Planning Hub Currency Code Profile is NULL or source is not 11i or greater.');
1952: END IF;
1953:

Line 1956: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_DELIVERY_DETAILS');

1952: END IF;
1953:
1954: ELSIF pTASKNUM= TASK_DELIVERY_DETAILS THEN ---- for bug # 6730983
1955: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1956: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_DELIVERY_DETAILS');
1957: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1958: -- LOG_MESSAGE(FND_MESSAGE.GET);
1959: MSC_CL_OTHER_ODS_LOAD.LOAD_DELIVERY_DETAILS;
1960:

Line 1959: MSC_CL_OTHER_ODS_LOAD.LOAD_DELIVERY_DETAILS;

1955: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1956: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_DELIVERY_DETAILS');
1957: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1958: -- LOG_MESSAGE(FND_MESSAGE.GET);
1959: MSC_CL_OTHER_ODS_LOAD.LOAD_DELIVERY_DETAILS;
1960:
1961: ELSIF pTASKNUM= TASK_IRO_DEMAND THEN -- Changed For bug 5909379 SRP Additions
1962:
1963:

Line 1991: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_VISITS');

1987: ELSIF pTASKNUM= TASK_CMRO THEN
1988:
1989: IF (v_apps_ver >= MSC_UTIL.G_APPS121) AND v_is_legacy_refresh THEN
1990: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
1991: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_VISITS');
1992: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1993: MSC_CL_OTHER_ODS_LOAD.LOAD_VISITS;
1994: MSC_CL_OTHER_ODS_LOAD.LOAD_MILESTONES;
1995: MSC_CL_OTHER_ODS_LOAD.LOAD_WBS;

Line 1993: MSC_CL_OTHER_ODS_LOAD.LOAD_VISITS;

1989: IF (v_apps_ver >= MSC_UTIL.G_APPS121) AND v_is_legacy_refresh THEN
1990: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
1991: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_VISITS');
1992: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1993: MSC_CL_OTHER_ODS_LOAD.LOAD_VISITS;
1994: MSC_CL_OTHER_ODS_LOAD.LOAD_MILESTONES;
1995: MSC_CL_OTHER_ODS_LOAD.LOAD_WBS;
1996: MSC_CL_OTHER_ODS_LOAD.LOAD_WOATTRIBUTES;
1997: MSC_CL_OTHER_ODS_LOAD.LOAD_WO_TASK_HIERARCHY;

Line 1994: MSC_CL_OTHER_ODS_LOAD.LOAD_MILESTONES;

1990: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
1991: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_VISITS');
1992: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1993: MSC_CL_OTHER_ODS_LOAD.LOAD_VISITS;
1994: MSC_CL_OTHER_ODS_LOAD.LOAD_MILESTONES;
1995: MSC_CL_OTHER_ODS_LOAD.LOAD_WBS;
1996: MSC_CL_OTHER_ODS_LOAD.LOAD_WOATTRIBUTES;
1997: MSC_CL_OTHER_ODS_LOAD.LOAD_WO_TASK_HIERARCHY;
1998: MSC_CL_OTHER_ODS_LOAD.LOAD_WO_OPERATION_REL;

Line 1995: MSC_CL_OTHER_ODS_LOAD.LOAD_WBS;

1991: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_VISITS');
1992: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1993: MSC_CL_OTHER_ODS_LOAD.LOAD_VISITS;
1994: MSC_CL_OTHER_ODS_LOAD.LOAD_MILESTONES;
1995: MSC_CL_OTHER_ODS_LOAD.LOAD_WBS;
1996: MSC_CL_OTHER_ODS_LOAD.LOAD_WOATTRIBUTES;
1997: MSC_CL_OTHER_ODS_LOAD.LOAD_WO_TASK_HIERARCHY;
1998: MSC_CL_OTHER_ODS_LOAD.LOAD_WO_OPERATION_REL;
1999: END IF;

Line 1996: MSC_CL_OTHER_ODS_LOAD.LOAD_WOATTRIBUTES;

1992: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1993: MSC_CL_OTHER_ODS_LOAD.LOAD_VISITS;
1994: MSC_CL_OTHER_ODS_LOAD.LOAD_MILESTONES;
1995: MSC_CL_OTHER_ODS_LOAD.LOAD_WBS;
1996: MSC_CL_OTHER_ODS_LOAD.LOAD_WOATTRIBUTES;
1997: MSC_CL_OTHER_ODS_LOAD.LOAD_WO_TASK_HIERARCHY;
1998: MSC_CL_OTHER_ODS_LOAD.LOAD_WO_OPERATION_REL;
1999: END IF;
2000:

Line 1997: MSC_CL_OTHER_ODS_LOAD.LOAD_WO_TASK_HIERARCHY;

1993: MSC_CL_OTHER_ODS_LOAD.LOAD_VISITS;
1994: MSC_CL_OTHER_ODS_LOAD.LOAD_MILESTONES;
1995: MSC_CL_OTHER_ODS_LOAD.LOAD_WBS;
1996: MSC_CL_OTHER_ODS_LOAD.LOAD_WOATTRIBUTES;
1997: MSC_CL_OTHER_ODS_LOAD.LOAD_WO_TASK_HIERARCHY;
1998: MSC_CL_OTHER_ODS_LOAD.LOAD_WO_OPERATION_REL;
1999: END IF;
2000:
2001: /* usaf */

Line 1998: MSC_CL_OTHER_ODS_LOAD.LOAD_WO_OPERATION_REL;

1994: MSC_CL_OTHER_ODS_LOAD.LOAD_MILESTONES;
1995: MSC_CL_OTHER_ODS_LOAD.LOAD_WBS;
1996: MSC_CL_OTHER_ODS_LOAD.LOAD_WOATTRIBUTES;
1997: MSC_CL_OTHER_ODS_LOAD.LOAD_WO_TASK_HIERARCHY;
1998: MSC_CL_OTHER_ODS_LOAD.LOAD_WO_OPERATION_REL;
1999: END IF;
2000:
2001: /* usaf */
2002:

Line 2228: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_IB_CONTRACTS');

2224: END IF;
2225:
2226: ELSIF pTASKNUM= TASK_IBUC_HISTORY THEN
2227: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
2228: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_IB_CONTRACTS');
2229: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2230: MSC_CL_OTHER_ODS_LOAD.LOAD_IB_CONTRACTS;
2231:
2232: ELSIF pTASKNUM= TASK_SHORT_TEXT THEN

Line 2230: MSC_CL_OTHER_ODS_LOAD.LOAD_IB_CONTRACTS;

2226: ELSIF pTASKNUM= TASK_IBUC_HISTORY THEN
2227: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
2228: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_IB_CONTRACTS');
2229: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2230: MSC_CL_OTHER_ODS_LOAD.LOAD_IB_CONTRACTS;
2231:
2232: ELSIF pTASKNUM= TASK_SHORT_TEXT THEN
2233: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
2234: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_SHORT_TEXT');

Line 2234: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_SHORT_TEXT');

2230: MSC_CL_OTHER_ODS_LOAD.LOAD_IB_CONTRACTS;
2231:
2232: ELSIF pTASKNUM= TASK_SHORT_TEXT THEN
2233: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
2234: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_SHORT_TEXT');
2235: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2236: MSC_CL_OTHER_ODS_LOAD.LOAD_SHORT_TEXT;
2237:
2238: ELSIF pTASKNUM= TASK_LONG_TEXT THEN

Line 2236: MSC_CL_OTHER_ODS_LOAD.LOAD_SHORT_TEXT;

2232: ELSIF pTASKNUM= TASK_SHORT_TEXT THEN
2233: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
2234: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_SHORT_TEXT');
2235: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2236: MSC_CL_OTHER_ODS_LOAD.LOAD_SHORT_TEXT;
2237:
2238: ELSIF pTASKNUM= TASK_LONG_TEXT THEN
2239: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
2240: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_LONG_TEXT');

Line 2240: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_LONG_TEXT');

2236: MSC_CL_OTHER_ODS_LOAD.LOAD_SHORT_TEXT;
2237:
2238: ELSIF pTASKNUM= TASK_LONG_TEXT THEN
2239: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
2240: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_LONG_TEXT');
2241: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2242: MSC_CL_OTHER_ODS_LOAD.LOAD_LONG_TEXT;
2243: ELSE
2244: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Unhandled taskNum '||pTASKNUM);

Line 2242: MSC_CL_OTHER_ODS_LOAD.LOAD_LONG_TEXT;

2238: ELSIF pTASKNUM= TASK_LONG_TEXT THEN
2239: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
2240: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_LONG_TEXT');
2241: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2242: MSC_CL_OTHER_ODS_LOAD.LOAD_LONG_TEXT;
2243: ELSE
2244: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Unhandled taskNum '||pTASKNUM);
2245: RAISE SUPPLIES_LOAD_FAIL;
2246:

Line 2503: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_SOURCING');

2499:
2500: ELSIF pTASKNUM= PTASK_SOURCING THEN
2501:
2502: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2503: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_SOURCING');
2504: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2505: MSC_CL_OTHER_ODS_LOAD.LOAD_SOURCING;
2506:
2507: ELSIF pTASKNUM= PTASK_SAFETY_STOCK THEN

Line 2505: MSC_CL_OTHER_ODS_LOAD.LOAD_SOURCING;

2501:
2502: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2503: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_SOURCING');
2504: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2505: MSC_CL_OTHER_ODS_LOAD.LOAD_SOURCING;
2506:
2507: ELSIF pTASKNUM= PTASK_SAFETY_STOCK THEN
2508:
2509: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');

Line 2510: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_SAFETY_STOCK');

2506:
2507: ELSIF pTASKNUM= PTASK_SAFETY_STOCK THEN
2508:
2509: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2510: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_SAFETY_STOCK');
2511: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2512: MSC_CL_OTHER_ODS_LOAD.LOAD_SAFETY_STOCK;
2513:
2514: ELSIF pTASKNUM= PTASK_MDS_DEMAND THEN

Line 2512: MSC_CL_OTHER_ODS_LOAD.LOAD_SAFETY_STOCK;

2508:
2509: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2510: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_SAFETY_STOCK');
2511: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2512: MSC_CL_OTHER_ODS_LOAD.LOAD_SAFETY_STOCK;
2513:
2514: ELSIF pTASKNUM= PTASK_MDS_DEMAND THEN
2515:
2516: -- If any of the supply flags are enabled then wait for the supplies to be completed

Line 3001: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_ATP_RULES');

2997:
2998: ELSIF pTASKNUM= PTASK_ATP_RULES THEN
2999:
3000: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
3001: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_ATP_RULES');
3002: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3003: MSC_CL_OTHER_ODS_LOAD.LOAD_ATP_RULES;
3004:
3005: ELSIF pTASKNUM= PTASK_BOR THEN

Line 3003: MSC_CL_OTHER_ODS_LOAD.LOAD_ATP_RULES;

2999:
3000: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
3001: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_ATP_RULES');
3002: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3003: MSC_CL_OTHER_ODS_LOAD.LOAD_ATP_RULES;
3004:
3005: ELSIF pTASKNUM= PTASK_BOR THEN
3006:
3007: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');

Line 3022: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_DEMAND_CLASS');

3018:
3019: ELSIF pTASKNUM= PTASK_DEMAND_CLASS THEN
3020:
3021: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
3022: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_DEMAND_CLASS');
3023: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3024: MSC_CL_OTHER_ODS_LOAD.LOAD_DEMAND_CLASS;
3025:
3026: ELSIF pTASKNUM= PTASK_DESIGNATOR THEN

Line 3024: MSC_CL_OTHER_ODS_LOAD.LOAD_DEMAND_CLASS;

3020:
3021: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
3022: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_DEMAND_CLASS');
3023: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3024: MSC_CL_OTHER_ODS_LOAD.LOAD_DEMAND_CLASS;
3025:
3026: ELSIF pTASKNUM= PTASK_DESIGNATOR THEN
3027:
3028: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');

Line 3037: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_BIS_PFMC_MEASURES');

3033: ELSIF pTASKNUM= PTASK_BIS_PFMC_MEASURES THEN
3034:
3035: IF v_apps_ver <> MSC_UTIL.G_APPS107 THEN
3036: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
3037: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_BIS_PFMC_MEASURES');
3038: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3039: MSC_CL_OTHER_ODS_LOAD.LOAD_BIS_PFMC_MEASURES;
3040: END IF;
3041:

Line 3039: MSC_CL_OTHER_ODS_LOAD.LOAD_BIS_PFMC_MEASURES;

3035: IF v_apps_ver <> MSC_UTIL.G_APPS107 THEN
3036: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
3037: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_BIS_PFMC_MEASURES');
3038: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3039: MSC_CL_OTHER_ODS_LOAD.LOAD_BIS_PFMC_MEASURES;
3040: END IF;
3041:
3042: ELSIF pTASKNUM= PTASK_BIS_TARGET_LEVELS THEN
3043:

Line 3046: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_BIS_TARGET_LEVELS');

3042: ELSIF pTASKNUM= PTASK_BIS_TARGET_LEVELS THEN
3043:
3044: IF v_apps_ver <> MSC_UTIL.G_APPS107 THEN
3045: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
3046: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_BIS_TARGET_LEVELS');
3047: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3048: MSC_CL_OTHER_ODS_LOAD.LOAD_BIS_TARGET_LEVELS;
3049: END IF;
3050:

Line 3048: MSC_CL_OTHER_ODS_LOAD.LOAD_BIS_TARGET_LEVELS;

3044: IF v_apps_ver <> MSC_UTIL.G_APPS107 THEN
3045: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
3046: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_BIS_TARGET_LEVELS');
3047: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3048: MSC_CL_OTHER_ODS_LOAD.LOAD_BIS_TARGET_LEVELS;
3049: END IF;
3050:
3051: ELSIF pTASKNUM= PTASK_BIS_TARGETS THEN
3052:

Line 3055: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_BIS_TARGETS');

3051: ELSIF pTASKNUM= PTASK_BIS_TARGETS THEN
3052:
3053: IF v_apps_ver <> MSC_UTIL.G_APPS107 THEN
3054: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
3055: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_BIS_TARGETS');
3056: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3057: MSC_CL_OTHER_ODS_LOAD.LOAD_BIS_TARGETS;
3058: END IF;
3059:

Line 3057: MSC_CL_OTHER_ODS_LOAD.LOAD_BIS_TARGETS;

3053: IF v_apps_ver <> MSC_UTIL.G_APPS107 THEN
3054: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
3055: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_BIS_TARGETS');
3056: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3057: MSC_CL_OTHER_ODS_LOAD.LOAD_BIS_TARGETS;
3058: END IF;
3059:
3060: ELSIF pTASKNUM= PTASK_BIS_BUSINESS_PLANS THEN
3061:

Line 3064: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_BIS_BUSINESS_PLANS');

3060: ELSIF pTASKNUM= PTASK_BIS_BUSINESS_PLANS THEN
3061:
3062: IF v_apps_ver <> MSC_UTIL.G_APPS107 THEN
3063: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
3064: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_BIS_BUSINESS_PLANS');
3065: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3066: MSC_CL_OTHER_ODS_LOAD.LOAD_BIS_BUSINESS_PLANS;
3067: END IF;
3068:

Line 3066: MSC_CL_OTHER_ODS_LOAD.LOAD_BIS_BUSINESS_PLANS;

3062: IF v_apps_ver <> MSC_UTIL.G_APPS107 THEN
3063: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
3064: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_BIS_BUSINESS_PLANS');
3065: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3066: MSC_CL_OTHER_ODS_LOAD.LOAD_BIS_BUSINESS_PLANS;
3067: END IF;
3068:
3069: ELSIF pTASKNUM= PTASK_BIS_PERIODS THEN
3070:

Line 3072: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_BIS_PERIODS');

3068:
3069: ELSIF pTASKNUM= PTASK_BIS_PERIODS THEN
3070:
3071: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
3072: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_BIS_PERIODS');
3073: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3074: MSC_CL_OTHER_ODS_LOAD.LOAD_BIS_PERIODS;
3075:
3076: ELSIF pTASKNUM= PTASK_PARAMETER THEN

Line 3074: MSC_CL_OTHER_ODS_LOAD.LOAD_BIS_PERIODS;

3070:
3071: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
3072: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_BIS_PERIODS');
3073: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3074: MSC_CL_OTHER_ODS_LOAD.LOAD_BIS_PERIODS;
3075:
3076: ELSIF pTASKNUM= PTASK_PARAMETER THEN
3077:
3078: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');

Line 3086: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_PLANNERS');

3082:
3083: ELSIF pTASKNUM= PTASK_PLANNERS THEN
3084:
3085: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
3086: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_PLANNERS');
3087: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3088: MSC_CL_OTHER_ODS_LOAD.LOAD_PLANNERS;
3089:
3090: ELSIF pTASKNUM= PTASK_PROJECT THEN

Line 3088: MSC_CL_OTHER_ODS_LOAD.LOAD_PLANNERS;

3084:
3085: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
3086: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_PLANNERS');
3087: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3088: MSC_CL_OTHER_ODS_LOAD.LOAD_PLANNERS;
3089:
3090: ELSIF pTASKNUM= PTASK_PROJECT THEN
3091:
3092: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');

Line 3093: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_PROJECT');

3089:
3090: ELSIF pTASKNUM= PTASK_PROJECT THEN
3091:
3092: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
3093: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_PROJECT');
3094: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3095: MSC_CL_OTHER_ODS_LOAD.LOAD_PROJECT;
3096:
3097: ELSIF pTASKNUM= PTASK_SUB_INVENTORY THEN

Line 3095: MSC_CL_OTHER_ODS_LOAD.LOAD_PROJECT;

3091:
3092: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
3093: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_PROJECT');
3094: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3095: MSC_CL_OTHER_ODS_LOAD.LOAD_PROJECT;
3096:
3097: ELSIF pTASKNUM= PTASK_SUB_INVENTORY THEN
3098:
3099: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');

Line 3100: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_SUB_INVENTORY');

3096:
3097: ELSIF pTASKNUM= PTASK_SUB_INVENTORY THEN
3098:
3099: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
3100: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_SUB_INVENTORY');
3101: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3102: MSC_CL_OTHER_ODS_LOAD.LOAD_SUB_INVENTORY;
3103:
3104: ELSIF pTASKNUM= PTASK_UNIT_NUMBER THEN

Line 3102: MSC_CL_OTHER_ODS_LOAD.LOAD_SUB_INVENTORY;

3098:
3099: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
3100: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_SUB_INVENTORY');
3101: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3102: MSC_CL_OTHER_ODS_LOAD.LOAD_SUB_INVENTORY;
3103:
3104: ELSIF pTASKNUM= PTASK_UNIT_NUMBER THEN
3105:
3106: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');

Line 3107: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_UNIT_NUMBER');

3103:
3104: ELSIF pTASKNUM= PTASK_UNIT_NUMBER THEN
3105:
3106: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
3107: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_UNIT_NUMBER');
3108: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3109: MSC_CL_OTHER_ODS_LOAD.LOAD_UNIT_NUMBER;
3110:
3111: ELSIF pTASKNUM = PTASK_ITEM_SUBSTITUTES THEN

Line 3109: MSC_CL_OTHER_ODS_LOAD.LOAD_UNIT_NUMBER;

3105:
3106: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
3107: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_UNIT_NUMBER');
3108: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3109: MSC_CL_OTHER_ODS_LOAD.LOAD_UNIT_NUMBER;
3110:
3111: ELSIF pTASKNUM = PTASK_ITEM_SUBSTITUTES THEN
3112:
3113: IF v_apps_ver <> MSC_UTIL.G_APPS107 THEN

Line 3147: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_TRIP');

3143:
3144: IF (v_apps_ver >= MSC_UTIL.G_APPS115) OR v_is_legacy_refresh THEN
3145:
3146: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
3147: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_TRIP');
3148: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3149: MSC_CL_OTHER_ODS_LOAD.LOAD_TRIP;
3150:
3151: END IF;

Line 3149: MSC_CL_OTHER_ODS_LOAD.LOAD_TRIP;

3145:
3146: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
3147: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_TRIP');
3148: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3149: MSC_CL_OTHER_ODS_LOAD.LOAD_TRIP;
3150:
3151: END IF;
3152:
3153: /*ds change start */

Line 3201: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_SALES_CHANNEL');

3197: ELSIF pTASKNUM= PTASK_SALES_CHANNEL THEN
3198:
3199: IF (v_apps_ver >= MSC_UTIL.G_APPS115) OR v_is_legacy_refresh THEN -- 7704614
3200: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
3201: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_SALES_CHANNEL');
3202: -- LOG_MESSAGE(FND_MESSAGE.GET);
3203: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3204: MSC_CL_OTHER_ODS_LOAD.LOAD_SALES_CHANNEL;
3205: END IF;

Line 3204: MSC_CL_OTHER_ODS_LOAD.LOAD_SALES_CHANNEL;

3200: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
3201: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_SALES_CHANNEL');
3202: -- LOG_MESSAGE(FND_MESSAGE.GET);
3203: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3204: MSC_CL_OTHER_ODS_LOAD.LOAD_SALES_CHANNEL;
3205: END IF;
3206: ELSIF pTASKNUM= PTASK_FISCAL_CALENDAR THEN
3207:
3208: IF (v_apps_ver >= MSC_UTIL.G_APPS115) OR v_is_legacy_refresh THEN -- 7704614

Line 3210: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_FISCAL_CALENDAR');

3206: ELSIF pTASKNUM= PTASK_FISCAL_CALENDAR THEN
3207:
3208: IF (v_apps_ver >= MSC_UTIL.G_APPS115) OR v_is_legacy_refresh THEN -- 7704614
3209: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
3210: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_FISCAL_CALENDAR');
3211: -- LOG_MESSAGE(FND_MESSAGE.GET);
3212: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3213: MSC_CL_OTHER_ODS_LOAD.LOAD_FISCAL_CALENDAR;
3214: END IF;

Line 3213: MSC_CL_OTHER_ODS_LOAD.LOAD_FISCAL_CALENDAR;

3209: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
3210: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_FISCAL_CALENDAR');
3211: -- LOG_MESSAGE(FND_MESSAGE.GET);
3212: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3213: MSC_CL_OTHER_ODS_LOAD.LOAD_FISCAL_CALENDAR;
3214: END IF;
3215: ELSIF pTASKNUM= PTASK_PAYBACK_DEMAND_SUPPLY THEN --bug 5861050
3216:
3217: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');

Line 3230: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_DELIVERY_DETAILS');

3226:
3227: ELSIF pTASKNUM= PTASK_DELIVERY_DETAILS THEN
3228: IF (v_apps_ver >= MSC_UTIL.G_APPS120) THEN
3229: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
3230: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_DELIVERY_DETAILS');
3231: -- LOG_MESSAGE(FND_MESSAGE.GET);
3232: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3233: MSC_CL_OTHER_ODS_LOAD.LOAD_DELIVERY_DETAILS;
3234: END IF;

Line 3233: MSC_CL_OTHER_ODS_LOAD.LOAD_DELIVERY_DETAILS;

3229: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
3230: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_DELIVERY_DETAILS');
3231: -- LOG_MESSAGE(FND_MESSAGE.GET);
3232: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3233: MSC_CL_OTHER_ODS_LOAD.LOAD_DELIVERY_DETAILS;
3234: END IF;
3235:
3236: ELSIF pTASKNUM= PTASK_CURRENCY_CONVERSION THEN -- for bug # 6469722
3237: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');

Line 3238: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_CURRENCY_CONVERSION');

3234: END IF;
3235:
3236: ELSIF pTASKNUM= PTASK_CURRENCY_CONVERSION THEN -- for bug # 6469722
3237: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
3238: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_CURRENCY_CONVERSION');
3239: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3240:
3241: IF (MSC_CL_OTHER_PULL.G_MSC_HUB_CURR_CODE IS NOT NULL) AND (v_apps_ver >= MSC_UTIL.G_APPS115) THEN
3242: MSC_CL_OTHER_ODS_LOAD.LOAD_CURRENCY_CONVERSION;

Line 3242: MSC_CL_OTHER_ODS_LOAD.LOAD_CURRENCY_CONVERSION;

3238: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_CURRENCY_CONVERSION');
3239: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3240:
3241: IF (MSC_CL_OTHER_PULL.G_MSC_HUB_CURR_CODE IS NOT NULL) AND (v_apps_ver >= MSC_UTIL.G_APPS115) THEN
3242: MSC_CL_OTHER_ODS_LOAD.LOAD_CURRENCY_CONVERSION;
3243: ELSE
3244: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Currency Data is not collected as MSC:Planning Hub Currency Code Profile is NULL or source is not 11i or greater.');
3245: END IF;
3246:

Line 3269: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_VISITS');

3265: ELSIF pTASKNUM= PTASK_CMRO THEN
3266:
3267: IF (v_apps_ver >= MSC_UTIL.G_APPS121) AND v_is_legacy_refresh THEN
3268: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
3269: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_VISITS');
3270: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3271: MSC_CL_OTHER_ODS_LOAD.LOAD_VISITS;
3272: MSC_CL_OTHER_ODS_LOAD.LOAD_MILESTONES;
3273: MSC_CL_OTHER_ODS_LOAD.LOAD_WBS;

Line 3271: MSC_CL_OTHER_ODS_LOAD.LOAD_VISITS;

3267: IF (v_apps_ver >= MSC_UTIL.G_APPS121) AND v_is_legacy_refresh THEN
3268: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
3269: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_VISITS');
3270: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3271: MSC_CL_OTHER_ODS_LOAD.LOAD_VISITS;
3272: MSC_CL_OTHER_ODS_LOAD.LOAD_MILESTONES;
3273: MSC_CL_OTHER_ODS_LOAD.LOAD_WBS;
3274: MSC_CL_OTHER_ODS_LOAD.LOAD_WOATTRIBUTES;
3275: MSC_CL_OTHER_ODS_LOAD.LOAD_WO_TASK_HIERARCHY;

Line 3272: MSC_CL_OTHER_ODS_LOAD.LOAD_MILESTONES;

3268: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
3269: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_VISITS');
3270: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3271: MSC_CL_OTHER_ODS_LOAD.LOAD_VISITS;
3272: MSC_CL_OTHER_ODS_LOAD.LOAD_MILESTONES;
3273: MSC_CL_OTHER_ODS_LOAD.LOAD_WBS;
3274: MSC_CL_OTHER_ODS_LOAD.LOAD_WOATTRIBUTES;
3275: MSC_CL_OTHER_ODS_LOAD.LOAD_WO_TASK_HIERARCHY;
3276: MSC_CL_OTHER_ODS_LOAD.LOAD_WO_OPERATION_REL;

Line 3273: MSC_CL_OTHER_ODS_LOAD.LOAD_WBS;

3269: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_VISITS');
3270: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3271: MSC_CL_OTHER_ODS_LOAD.LOAD_VISITS;
3272: MSC_CL_OTHER_ODS_LOAD.LOAD_MILESTONES;
3273: MSC_CL_OTHER_ODS_LOAD.LOAD_WBS;
3274: MSC_CL_OTHER_ODS_LOAD.LOAD_WOATTRIBUTES;
3275: MSC_CL_OTHER_ODS_LOAD.LOAD_WO_TASK_HIERARCHY;
3276: MSC_CL_OTHER_ODS_LOAD.LOAD_WO_OPERATION_REL;
3277: END IF;

Line 3274: MSC_CL_OTHER_ODS_LOAD.LOAD_WOATTRIBUTES;

3270: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3271: MSC_CL_OTHER_ODS_LOAD.LOAD_VISITS;
3272: MSC_CL_OTHER_ODS_LOAD.LOAD_MILESTONES;
3273: MSC_CL_OTHER_ODS_LOAD.LOAD_WBS;
3274: MSC_CL_OTHER_ODS_LOAD.LOAD_WOATTRIBUTES;
3275: MSC_CL_OTHER_ODS_LOAD.LOAD_WO_TASK_HIERARCHY;
3276: MSC_CL_OTHER_ODS_LOAD.LOAD_WO_OPERATION_REL;
3277: END IF;
3278:

Line 3275: MSC_CL_OTHER_ODS_LOAD.LOAD_WO_TASK_HIERARCHY;

3271: MSC_CL_OTHER_ODS_LOAD.LOAD_VISITS;
3272: MSC_CL_OTHER_ODS_LOAD.LOAD_MILESTONES;
3273: MSC_CL_OTHER_ODS_LOAD.LOAD_WBS;
3274: MSC_CL_OTHER_ODS_LOAD.LOAD_WOATTRIBUTES;
3275: MSC_CL_OTHER_ODS_LOAD.LOAD_WO_TASK_HIERARCHY;
3276: MSC_CL_OTHER_ODS_LOAD.LOAD_WO_OPERATION_REL;
3277: END IF;
3278:
3279:

Line 3276: MSC_CL_OTHER_ODS_LOAD.LOAD_WO_OPERATION_REL;

3272: MSC_CL_OTHER_ODS_LOAD.LOAD_MILESTONES;
3273: MSC_CL_OTHER_ODS_LOAD.LOAD_WBS;
3274: MSC_CL_OTHER_ODS_LOAD.LOAD_WOATTRIBUTES;
3275: MSC_CL_OTHER_ODS_LOAD.LOAD_WO_TASK_HIERARCHY;
3276: MSC_CL_OTHER_ODS_LOAD.LOAD_WO_OPERATION_REL;
3277: END IF;
3278:
3279:
3280: /* usaf */

Line 3487: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_IB_CONTRACTS');

3483: ELSIF pTASKNUM= PTASK_IBUC_HISTORY THEN
3484:
3485: IF (v_apps_ver >= MSC_UTIL.G_APPS121 AND MSC_UTIL.G_COLLECT_SRP_PH2_ENABLE = 'Y') THEN
3486: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
3487: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_IB_CONTRACTS');
3488: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3489: MSC_CL_OTHER_ODS_LOAD.LOAD_IB_CONTRACTS;
3490: END IF;
3491:

Line 3489: MSC_CL_OTHER_ODS_LOAD.LOAD_IB_CONTRACTS;

3485: IF (v_apps_ver >= MSC_UTIL.G_APPS121 AND MSC_UTIL.G_COLLECT_SRP_PH2_ENABLE = 'Y') THEN
3486: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
3487: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_IB_CONTRACTS');
3488: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3489: MSC_CL_OTHER_ODS_LOAD.LOAD_IB_CONTRACTS;
3490: END IF;
3491:
3492: ELSIF pTASKNUM= PTASK_SHORT_TEXT THEN
3493:

Line 3496: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_SHORT_TEXT');

3492: ELSIF pTASKNUM= PTASK_SHORT_TEXT THEN
3493:
3494: IF (v_apps_ver >= MSC_UTIL.G_APPS121 AND MSC_UTIL.G_COLLECT_SRP_PH2_ENABLE = 'Y') THEN
3495: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
3496: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_SHORT_TEXT');
3497: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3498: MSC_CL_OTHER_ODS_LOAD.LOAD_SHORT_TEXT;
3499: END IF;
3500:

Line 3498: MSC_CL_OTHER_ODS_LOAD.LOAD_SHORT_TEXT;

3494: IF (v_apps_ver >= MSC_UTIL.G_APPS121 AND MSC_UTIL.G_COLLECT_SRP_PH2_ENABLE = 'Y') THEN
3495: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
3496: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_SHORT_TEXT');
3497: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3498: MSC_CL_OTHER_ODS_LOAD.LOAD_SHORT_TEXT;
3499: END IF;
3500:
3501: ELSIF pTASKNUM= PTASK_LONG_TEXT THEN
3502: IF (v_apps_ver >= MSC_UTIL.G_APPS121 AND MSC_UTIL.G_COLLECT_SRP_PH2_ENABLE = 'Y') THEN

Line 3504: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_LONG_TEXT');

3500:
3501: ELSIF pTASKNUM= PTASK_LONG_TEXT THEN
3502: IF (v_apps_ver >= MSC_UTIL.G_APPS121 AND MSC_UTIL.G_COLLECT_SRP_PH2_ENABLE = 'Y') THEN
3503: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
3504: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_LONG_TEXT');
3505: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3506: MSC_CL_OTHER_ODS_LOAD.LOAD_LONG_TEXT;
3507: END IF;
3508: ELSE

Line 3506: MSC_CL_OTHER_ODS_LOAD.LOAD_LONG_TEXT;

3502: IF (v_apps_ver >= MSC_UTIL.G_APPS121 AND MSC_UTIL.G_COLLECT_SRP_PH2_ENABLE = 'Y') THEN
3503: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
3504: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_LONG_TEXT');
3505: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3506: MSC_CL_OTHER_ODS_LOAD.LOAD_LONG_TEXT;
3507: END IF;
3508: ELSE
3509: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Loading of Supplies failed.TASK_WIP_COMP_DEMAND');
3510: RAISE SUPPLIES_LOAD_FAIL;