DBA Data[Home] [Help]

APPS.MSC_ATP_24X7 dependencies on MSC_SCH_WB

Line 1585: --msc_sch_wb.mrp_timing (buf);

1581: PROCEDURE conc_log (buf IN VARCHAR2)
1582: IS
1583: BEGIN
1584: msc_util.msc_log (buf);
1585: --msc_sch_wb.mrp_timing (buf);
1586: --dbms_output.put_line (buf);
1587:
1588: END conc_log;
1589: ---------------------------------------------------------------------------------

Line 1817: msc_sch_wb.atp_debug ('------Begin Parse_Sales_Order_string-----');

1813: l_char varchar2(1);
1814: l_num_char number;
1815:
1816: BEGIN
1817: msc_sch_wb.atp_debug ('------Begin Parse_Sales_Order_string-----');
1818: msc_sch_wb.atp_debug ('');
1819: msc_sch_wb.atp_debug ('String : ' || p_order_number_string);
1820: msc_sch_wb.atp_debug ('Number : ' || p_order_number);
1821:

Line 1818: msc_sch_wb.atp_debug ('');

1814: l_num_char number;
1815:
1816: BEGIN
1817: msc_sch_wb.atp_debug ('------Begin Parse_Sales_Order_string-----');
1818: msc_sch_wb.atp_debug ('');
1819: msc_sch_wb.atp_debug ('String : ' || p_order_number_string);
1820: msc_sch_wb.atp_debug ('Number : ' || p_order_number);
1821:
1822: BEGIN

Line 1819: msc_sch_wb.atp_debug ('String : ' || p_order_number_string);

1815:
1816: BEGIN
1817: msc_sch_wb.atp_debug ('------Begin Parse_Sales_Order_string-----');
1818: msc_sch_wb.atp_debug ('');
1819: msc_sch_wb.atp_debug ('String : ' || p_order_number_string);
1820: msc_sch_wb.atp_debug ('Number : ' || p_order_number);
1821:
1822: BEGIN
1823: p_order_number := to_number (p_order_number_string);

Line 1820: msc_sch_wb.atp_debug ('Number : ' || p_order_number);

1816: BEGIN
1817: msc_sch_wb.atp_debug ('------Begin Parse_Sales_Order_string-----');
1818: msc_sch_wb.atp_debug ('');
1819: msc_sch_wb.atp_debug ('String : ' || p_order_number_string);
1820: msc_sch_wb.atp_debug ('Number : ' || p_order_number);
1821:
1822: BEGIN
1823: p_order_number := to_number (p_order_number_string);
1824: msc_sch_wb.atp_debug ('Order number is : ' || p_order_number);

Line 1824: msc_sch_wb.atp_debug ('Order number is : ' || p_order_number);

1820: msc_sch_wb.atp_debug ('Number : ' || p_order_number);
1821:
1822: BEGIN
1823: p_order_number := to_number (p_order_number_string);
1824: msc_sch_wb.atp_debug ('Order number is : ' || p_order_number);
1825: return;
1826: EXCEPTION
1827: WHEN others then
1828: msc_sch_wb.atp_debug ('Order number has to be processed');

Line 1828: msc_sch_wb.atp_debug ('Order number has to be processed');

1824: msc_sch_wb.atp_debug ('Order number is : ' || p_order_number);
1825: return;
1826: EXCEPTION
1827: WHEN others then
1828: msc_sch_wb.atp_debug ('Order number has to be processed');
1829: END;
1830:
1831: l_end := 0;
1832: l_counter := 0;

Line 1835: msc_sch_wb.atp_debug ('Parse SO: Length of Order Number String : '|| l_max_counter);

1831: l_end := 0;
1832: l_counter := 0;
1833: l_max_counter := length(p_order_number_string);
1834:
1835: msc_sch_wb.atp_debug ('Parse SO: Length of Order Number String : '|| l_max_counter);
1836:
1837: if (l_max_counter = 0) then
1838: msc_sch_wb.atp_debug ('String is null' );
1839: return;

Line 1838: msc_sch_wb.atp_debug ('String is null' );

1834:
1835: msc_sch_wb.atp_debug ('Parse SO: Length of Order Number String : '|| l_max_counter);
1836:
1837: if (l_max_counter = 0) then
1838: msc_sch_wb.atp_debug ('String is null' );
1839: return;
1840: end if;
1841:
1842: while (l_end <> 1) loop

Line 1847: msc_sch_wb.atp_debug ('Parse SO: Max Length reached');

1843:
1844: l_counter := l_counter + 1;
1845: if (l_counter > l_max_counter ) then
1846: l_end := 1;
1847: msc_sch_wb.atp_debug ('Parse SO: Max Length reached');
1848: exit;
1849: end if;
1850:
1851: l_char := substr (p_order_number_string, l_counter, 1);

Line 1856: msc_sch_wb.atp_debug ('Parse SO: String end detected');

1852: BEGIN
1853: l_num_char := to_number (l_char);
1854: EXCEPTION
1855: WHEN OTHERS then
1856: msc_sch_wb.atp_debug ('Parse SO: String end detected');
1857: l_end := 1;
1858: END;
1859: end loop;
1860:

Line 1862: msc_sch_wb.atp_debug ('Order number string is a number');

1858: END;
1859: end loop;
1860:
1861: if (l_counter > l_max_counter) then
1862: msc_sch_wb.atp_debug ('Order number string is a number');
1863:
1864: BEGIN
1865: p_order_number := to_number (p_order_number_string);
1866: EXCEPTION

Line 1868: msc_sch_wb.atp_debug ('Parse SO: Something wrong. Should not be here');

1864: BEGIN
1865: p_order_number := to_number (p_order_number_string);
1866: EXCEPTION
1867: WHEN others then
1868: msc_sch_wb.atp_debug ('Parse SO: Something wrong. Should not be here');
1869: return;
1870: END;
1871:
1872: elsif (l_counter = 1) then

Line 1873: msc_sch_wb.atp_debug ('Order Number not properly formatted.');

1869: return;
1870: END;
1871:
1872: elsif (l_counter = 1) then
1873: msc_sch_wb.atp_debug ('Order Number not properly formatted.');
1874: else
1875: msc_sch_wb.atp_debug ('Parse SO: Counter is at ' || l_counter);
1876: BEGIN
1877: p_order_number := to_number (substr (p_order_number_string, 1,l_counter -1));

Line 1875: msc_sch_wb.atp_debug ('Parse SO: Counter is at ' || l_counter);

1871:
1872: elsif (l_counter = 1) then
1873: msc_sch_wb.atp_debug ('Order Number not properly formatted.');
1874: else
1875: msc_sch_wb.atp_debug ('Parse SO: Counter is at ' || l_counter);
1876: BEGIN
1877: p_order_number := to_number (substr (p_order_number_string, 1,l_counter -1));
1878: EXCEPTION
1879: WHEN others then

Line 1880: msc_sch_wb.atp_debug ('Parse SO: Something wrong. Should not be here');

1876: BEGIN
1877: p_order_number := to_number (substr (p_order_number_string, 1,l_counter -1));
1878: EXCEPTION
1879: WHEN others then
1880: msc_sch_wb.atp_debug ('Parse SO: Something wrong. Should not be here');
1881: return;
1882: END;
1883: end if;
1884:

Line 1885: msc_sch_wb.atp_debug ('Order number is : ' || p_order_number);

1881: return;
1882: END;
1883: end if;
1884:
1885: msc_sch_wb.atp_debug ('Order number is : ' || p_order_number);
1886:
1887: EXCEPTION
1888: WHEN others THEN
1889: msc_sch_wb.atp_debug ('Something wrong in Parse Sales Order');

Line 1889: msc_sch_wb.atp_debug ('Something wrong in Parse Sales Order');

1885: msc_sch_wb.atp_debug ('Order number is : ' || p_order_number);
1886:
1887: EXCEPTION
1888: WHEN others THEN
1889: msc_sch_wb.atp_debug ('Something wrong in Parse Sales Order');
1890:
1891: END Parse_Sales_Order_Number;
1892:
1893: -----------------------------------