DBA Data[Home] [Help]

APPS.MSC_ATP_24X7 dependencies on MSC_SCH_WB

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

1527: PROCEDURE conc_log (buf IN VARCHAR2)
1528: IS
1529: BEGIN
1530: msc_util.msc_log (buf);
1531: --msc_sch_wb.mrp_timing (buf);
1532: --dbms_output.put_line (buf);
1533:
1534: END conc_log;
1535: ---------------------------------------------------------------------------------

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

1759: l_char varchar2(1);
1760: l_num_char number;
1761:
1762: BEGIN
1763: msc_sch_wb.atp_debug ('------Begin Parse_Sales_Order_string-----');
1764: msc_sch_wb.atp_debug ('');
1765: msc_sch_wb.atp_debug ('String : ' || p_order_number_string);
1766: msc_sch_wb.atp_debug ('Number : ' || p_order_number);
1767:

Line 1764: msc_sch_wb.atp_debug ('');

1760: l_num_char number;
1761:
1762: BEGIN
1763: msc_sch_wb.atp_debug ('------Begin Parse_Sales_Order_string-----');
1764: msc_sch_wb.atp_debug ('');
1765: msc_sch_wb.atp_debug ('String : ' || p_order_number_string);
1766: msc_sch_wb.atp_debug ('Number : ' || p_order_number);
1767:
1768: BEGIN

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

1761:
1762: BEGIN
1763: msc_sch_wb.atp_debug ('------Begin Parse_Sales_Order_string-----');
1764: msc_sch_wb.atp_debug ('');
1765: msc_sch_wb.atp_debug ('String : ' || p_order_number_string);
1766: msc_sch_wb.atp_debug ('Number : ' || p_order_number);
1767:
1768: BEGIN
1769: p_order_number := to_number (p_order_number_string);

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

1762: BEGIN
1763: msc_sch_wb.atp_debug ('------Begin Parse_Sales_Order_string-----');
1764: msc_sch_wb.atp_debug ('');
1765: msc_sch_wb.atp_debug ('String : ' || p_order_number_string);
1766: msc_sch_wb.atp_debug ('Number : ' || p_order_number);
1767:
1768: BEGIN
1769: p_order_number := to_number (p_order_number_string);
1770: msc_sch_wb.atp_debug ('Order number is : ' || p_order_number);

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

1766: msc_sch_wb.atp_debug ('Number : ' || p_order_number);
1767:
1768: BEGIN
1769: p_order_number := to_number (p_order_number_string);
1770: msc_sch_wb.atp_debug ('Order number is : ' || p_order_number);
1771: return;
1772: EXCEPTION
1773: WHEN others then
1774: msc_sch_wb.atp_debug ('Order number has to be processed');

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

1770: msc_sch_wb.atp_debug ('Order number is : ' || p_order_number);
1771: return;
1772: EXCEPTION
1773: WHEN others then
1774: msc_sch_wb.atp_debug ('Order number has to be processed');
1775: END;
1776:
1777: l_end := 0;
1778: l_counter := 0;

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

1777: l_end := 0;
1778: l_counter := 0;
1779: l_max_counter := length(p_order_number_string);
1780:
1781: msc_sch_wb.atp_debug ('Parse SO: Length of Order Number String : '|| l_max_counter);
1782:
1783: if (l_max_counter = 0) then
1784: msc_sch_wb.atp_debug ('String is null' );
1785: return;

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

1780:
1781: msc_sch_wb.atp_debug ('Parse SO: Length of Order Number String : '|| l_max_counter);
1782:
1783: if (l_max_counter = 0) then
1784: msc_sch_wb.atp_debug ('String is null' );
1785: return;
1786: end if;
1787:
1788: while (l_end <> 1) loop

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

1789:
1790: l_counter := l_counter + 1;
1791: if (l_counter > l_max_counter ) then
1792: l_end := 1;
1793: msc_sch_wb.atp_debug ('Parse SO: Max Length reached');
1794: exit;
1795: end if;
1796:
1797: l_char := substr (p_order_number_string, l_counter, 1);

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

1798: BEGIN
1799: l_num_char := to_number (l_char);
1800: EXCEPTION
1801: WHEN OTHERS then
1802: msc_sch_wb.atp_debug ('Parse SO: String end detected');
1803: l_end := 1;
1804: END;
1805: end loop;
1806:

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

1804: END;
1805: end loop;
1806:
1807: if (l_counter > l_max_counter) then
1808: msc_sch_wb.atp_debug ('Order number string is a number');
1809:
1810: BEGIN
1811: p_order_number := to_number (p_order_number_string);
1812: EXCEPTION

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

1810: BEGIN
1811: p_order_number := to_number (p_order_number_string);
1812: EXCEPTION
1813: WHEN others then
1814: msc_sch_wb.atp_debug ('Parse SO: Something wrong. Should not be here');
1815: return;
1816: END;
1817:
1818: elsif (l_counter = 1) then

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

1815: return;
1816: END;
1817:
1818: elsif (l_counter = 1) then
1819: msc_sch_wb.atp_debug ('Order Number not properly formatted.');
1820: else
1821: msc_sch_wb.atp_debug ('Parse SO: Counter is at ' || l_counter);
1822: BEGIN
1823: p_order_number := to_number (substr (p_order_number_string, 1,l_counter -1));

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

1817:
1818: elsif (l_counter = 1) then
1819: msc_sch_wb.atp_debug ('Order Number not properly formatted.');
1820: else
1821: msc_sch_wb.atp_debug ('Parse SO: Counter is at ' || l_counter);
1822: BEGIN
1823: p_order_number := to_number (substr (p_order_number_string, 1,l_counter -1));
1824: EXCEPTION
1825: WHEN others then

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

1822: BEGIN
1823: p_order_number := to_number (substr (p_order_number_string, 1,l_counter -1));
1824: EXCEPTION
1825: WHEN others then
1826: msc_sch_wb.atp_debug ('Parse SO: Something wrong. Should not be here');
1827: return;
1828: END;
1829: end if;
1830:

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

1827: return;
1828: END;
1829: end if;
1830:
1831: msc_sch_wb.atp_debug ('Order number is : ' || p_order_number);
1832:
1833: EXCEPTION
1834: WHEN others THEN
1835: msc_sch_wb.atp_debug ('Something wrong in Parse Sales Order');

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

1831: msc_sch_wb.atp_debug ('Order number is : ' || p_order_number);
1832:
1833: EXCEPTION
1834: WHEN others THEN
1835: msc_sch_wb.atp_debug ('Something wrong in Parse Sales Order');
1836:
1837: END Parse_Sales_Order_Number;
1838:
1839: -----------------------------------