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.OE_INF_POPULATE_PUB dependencies on OE_DEBUG_PUB

Line 38: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

34: old_header_id_v number := 0;
35: l_sold_to_org_id number;
36:
37: --
38: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
39: --
40: BEGIN
41:
42: IF l_debug_level > 0 THEN

Line 43: oe_debug_pub.add( 'OEXPIFPB: ENTERING POPULATE_INTERFACE API' ) ;

39: --
40: BEGIN
41:
42: IF l_debug_level > 0 THEN
43: oe_debug_pub.add( 'OEXPIFPB: ENTERING POPULATE_INTERFACE API' ) ;
44: END IF;
45:
46: -- Select the header_id from the oe_order_headers_all table
47: -- for what ???

Line 56: oe_debug_pub.add( 'OEXPIFPB: HEADER ID => ' || TO_CHAR ( OLD_HEADER_ID_V ) ) ;

52: FROM oe_order_headers_all
53: WHERE order_number = order_number_v;
54:
55: IF l_debug_level > 0 THEN
56: oe_debug_pub.add( 'OEXPIFPB: HEADER ID => ' || TO_CHAR ( OLD_HEADER_ID_V ) ) ;
57: END IF;
58:
59: EXCEPTION
60: WHEN OTHERS THEN

Line 63: oe_debug_pub.add( 'OEXPIFPB: EXITING POPULATE_INTERFACE API' ) ;

59: EXCEPTION
60: WHEN OTHERS THEN
61: x_return_status := FND_API.G_RET_STS_ERROR;
62: IF l_debug_level > 0 THEN
63: oe_debug_pub.add( 'OEXPIFPB: EXITING POPULATE_INTERFACE API' ) ;
64: END IF;
65: END;
66:
67: IF old_header_id_v is not null THEN

Line 70: oe_debug_pub.add( 'OEXPIFPB: BEFORE INSERT TO OE_HEADERS_IFACE_ALL' ) ;

66:
67: IF old_header_id_v is not null THEN
68:
69: IF l_debug_level > 0 THEN
70: oe_debug_pub.add( 'OEXPIFPB: BEFORE INSERT TO OE_HEADERS_IFACE_ALL' ) ;
71: END IF;
72:
73: INSERT INTO oe_headers_iface_all (
74: order_source_id

Line 517: oe_debug_pub.add( 'OEXPIFPB: AFTER SUCCESSFUL INSERT TO OE_HEADERS_IFACE_ALL' ) ;

513: where order_number = order_number_v;
514:
515: IF SQL%ROWCOUNT > 0 THEN
516: IF l_debug_level > 0 THEN
517: oe_debug_pub.add( 'OEXPIFPB: AFTER SUCCESSFUL INSERT TO OE_HEADERS_IFACE_ALL' ) ;
518: END IF;
519: ELSE
520: IF l_debug_level > 0 THEN
521: oe_debug_pub.add( 'OEXPIFPB: AFTER UN-SUCCESSFUL INSERT TO OE_HEADERS_IFACE_ALL' ) ;

Line 521: oe_debug_pub.add( 'OEXPIFPB: AFTER UN-SUCCESSFUL INSERT TO OE_HEADERS_IFACE_ALL' ) ;

517: oe_debug_pub.add( 'OEXPIFPB: AFTER SUCCESSFUL INSERT TO OE_HEADERS_IFACE_ALL' ) ;
518: END IF;
519: ELSE
520: IF l_debug_level > 0 THEN
521: oe_debug_pub.add( 'OEXPIFPB: AFTER UN-SUCCESSFUL INSERT TO OE_HEADERS_IFACE_ALL' ) ;
522: END IF;
523: return;
524: END IF;
525:

Line 527: oe_debug_pub.add( 'OEXPIFPB: BEFORE INSERT TO OE_LINES_IFACE_ALL' ) ;

523: return;
524: END IF;
525:
526: IF l_debug_level > 0 THEN
527: oe_debug_pub.add( 'OEXPIFPB: BEFORE INSERT TO OE_LINES_IFACE_ALL' ) ;
528: END IF;
529:
530: INSERT INTO oe_lines_iface_all (
531: order_source_id /* number */

Line 1156: oe_debug_pub.add( 'OEXPIFPB: AFTER SUCCESSFUL INSERT TO OE_LINES_IFACE_ALL' ) ;

1152: where header_id = old_header_id_v;
1153:
1154: IF SQL%ROWCOUNT > 0 THEN
1155: IF l_debug_level > 0 THEN
1156: oe_debug_pub.add( 'OEXPIFPB: AFTER SUCCESSFUL INSERT TO OE_LINES_IFACE_ALL' ) ;
1157: END IF;
1158: ELSE
1159: IF l_debug_level > 0 THEN
1160: oe_debug_pub.add( 'OEXPIFPB: AFTER UN-SUCCESSFUL INSERT TO OE_LINES_IFACE_ALL' ) ;

Line 1160: oe_debug_pub.add( 'OEXPIFPB: AFTER UN-SUCCESSFUL INSERT TO OE_LINES_IFACE_ALL' ) ;

1156: oe_debug_pub.add( 'OEXPIFPB: AFTER SUCCESSFUL INSERT TO OE_LINES_IFACE_ALL' ) ;
1157: END IF;
1158: ELSE
1159: IF l_debug_level > 0 THEN
1160: oe_debug_pub.add( 'OEXPIFPB: AFTER UN-SUCCESSFUL INSERT TO OE_LINES_IFACE_ALL' ) ;
1161: END IF;
1162: END IF;
1163:
1164: IF l_debug_level > 0 THEN

Line 1165: oe_debug_pub.add( 'OEXPIFPB: BEFORE INSERT TO OE_PRICE_ADJS_IFACE_ALL' ) ;

1161: END IF;
1162: END IF;
1163:
1164: IF l_debug_level > 0 THEN
1165: oe_debug_pub.add( 'OEXPIFPB: BEFORE INSERT TO OE_PRICE_ADJS_IFACE_ALL' ) ;
1166: END IF;
1167:
1168: /* Header Level Price Adjustment */
1169: INSERT INTO OE_PRICE_ADJS_IFACE_ALL (

Line 1301: oe_debug_pub.add( 'OEXPIFPB: AFTER SUCCESSFUL INSERT TO OE_PRICE_ADJS_IFACE_ALL FOR HEADER' ) ;

1297: and applied_Flag = 'Y';
1298:
1299: IF SQL%ROWCOUNT > 0 THEN
1300: IF l_debug_level > 0 THEN
1301: oe_debug_pub.add( 'OEXPIFPB: AFTER SUCCESSFUL INSERT TO OE_PRICE_ADJS_IFACE_ALL FOR HEADER' ) ;
1302: END IF;
1303: ELSE
1304: IF l_debug_level > 0 THEN
1305: oe_debug_pub.add( 'OEXPIFPB: AFTER UN-SUCCESSFUL INSERT TO OE_PRICE_ADJS_IFACE_ALL FOR HEADER' ) ;

Line 1305: oe_debug_pub.add( 'OEXPIFPB: AFTER UN-SUCCESSFUL INSERT TO OE_PRICE_ADJS_IFACE_ALL FOR HEADER' ) ;

1301: oe_debug_pub.add( 'OEXPIFPB: AFTER SUCCESSFUL INSERT TO OE_PRICE_ADJS_IFACE_ALL FOR HEADER' ) ;
1302: END IF;
1303: ELSE
1304: IF l_debug_level > 0 THEN
1305: oe_debug_pub.add( 'OEXPIFPB: AFTER UN-SUCCESSFUL INSERT TO OE_PRICE_ADJS_IFACE_ALL FOR HEADER' ) ;
1306: END IF;
1307: END IF;
1308:
1309: IF l_debug_level > 0 THEN

Line 1310: oe_debug_pub.add( 'OEXPIFPB: BEFORE INSERT TO OE_PRICE_ADJS_IFACE_ALL FOR LINE' ) ;

1306: END IF;
1307: END IF;
1308:
1309: IF l_debug_level > 0 THEN
1310: oe_debug_pub.add( 'OEXPIFPB: BEFORE INSERT TO OE_PRICE_ADJS_IFACE_ALL FOR LINE' ) ;
1311: END IF;
1312:
1313:
1314: /* Line Level Payments */

Line 1421: oe_debug_pub.add( 'OEXPIFPB: AFTER SUCCESSFUL INSERT TO OE_PAYMENTS_INTERFACE FOR LINE' ) ;

1417: and line_id is not null;
1418:
1419: IF SQL%ROWCOUNT > 0 THEN
1420: IF l_debug_level > 0 THEN
1421: oe_debug_pub.add( 'OEXPIFPB: AFTER SUCCESSFUL INSERT TO OE_PAYMENTS_INTERFACE FOR LINE' ) ;
1422: END IF;
1423: ELSE
1424: IF l_debug_level > 0 THEN
1425: oe_debug_pub.add( 'OEXPIFPB: AFTER UN-SUCCESSFUL INSERT TO OE_PAYMENTS_INTERFACE FOR LINE' ) ;

Line 1425: oe_debug_pub.add( 'OEXPIFPB: AFTER UN-SUCCESSFUL INSERT TO OE_PAYMENTS_INTERFACE FOR LINE' ) ;

1421: oe_debug_pub.add( 'OEXPIFPB: AFTER SUCCESSFUL INSERT TO OE_PAYMENTS_INTERFACE FOR LINE' ) ;
1422: END IF;
1423: ELSE
1424: IF l_debug_level > 0 THEN
1425: oe_debug_pub.add( 'OEXPIFPB: AFTER UN-SUCCESSFUL INSERT TO OE_PAYMENTS_INTERFACE FOR LINE' ) ;
1426: END IF;
1427: END IF;
1428:
1429: /* Header Payments */

Line 1536: oe_debug_pub.add( 'OEXPIFPB: AFTER SUCCESSFUL INSERT TO OE_PAYMENTS_INTERFACE FOR HEADERS' ) ;

1532: and line_id is null;
1533:
1534: IF SQL%ROWCOUNT > 0 THEN
1535: IF l_debug_level > 0 THEN
1536: oe_debug_pub.add( 'OEXPIFPB: AFTER SUCCESSFUL INSERT TO OE_PAYMENTS_INTERFACE FOR HEADERS' ) ;
1537: END IF;
1538: ELSE
1539: IF l_debug_level > 0 THEN
1540: oe_debug_pub.add( 'OEXPIFPB: AFTER UN-SUCCESSFUL INSERT TO OE_PAYMENTS_INTERFACE FOR HEADERS' ) ;

Line 1540: oe_debug_pub.add( 'OEXPIFPB: AFTER UN-SUCCESSFUL INSERT TO OE_PAYMENTS_INTERFACE FOR HEADERS' ) ;

1536: oe_debug_pub.add( 'OEXPIFPB: AFTER SUCCESSFUL INSERT TO OE_PAYMENTS_INTERFACE FOR HEADERS' ) ;
1537: END IF;
1538: ELSE
1539: IF l_debug_level > 0 THEN
1540: oe_debug_pub.add( 'OEXPIFPB: AFTER UN-SUCCESSFUL INSERT TO OE_PAYMENTS_INTERFACE FOR HEADERS' ) ;
1541: END IF;
1542: END IF;
1543:
1544: /* Line Level Price Adjustment */

Line 1677: oe_debug_pub.add( 'OEXPIFPB: AFTER SUCCESSFUL INSERT TO OE_PRICE_ADJS_INTERFACE FOR LINE' ) ;

1673: and applied_Flag = 'Y';
1674:
1675: IF SQL%ROWCOUNT > 0 THEN
1676: IF l_debug_level > 0 THEN
1677: oe_debug_pub.add( 'OEXPIFPB: AFTER SUCCESSFUL INSERT TO OE_PRICE_ADJS_INTERFACE FOR LINE' ) ;
1678: END IF;
1679: ELSE
1680: IF l_debug_level > 0 THEN
1681: oe_debug_pub.add( 'OEXPIFPB: AFTER UN-SUCCESSFUL INSERT TO OE_PRICE_ADJS_INTERFACE FOR LINE' ) ;

Line 1681: oe_debug_pub.add( 'OEXPIFPB: AFTER UN-SUCCESSFUL INSERT TO OE_PRICE_ADJS_INTERFACE FOR LINE' ) ;

1677: oe_debug_pub.add( 'OEXPIFPB: AFTER SUCCESSFUL INSERT TO OE_PRICE_ADJS_INTERFACE FOR LINE' ) ;
1678: END IF;
1679: ELSE
1680: IF l_debug_level > 0 THEN
1681: oe_debug_pub.add( 'OEXPIFPB: AFTER UN-SUCCESSFUL INSERT TO OE_PRICE_ADJS_INTERFACE FOR LINE' ) ;
1682: END IF;
1683: END IF;
1684:
1685: IF l_debug_level > 0 THEN

Line 1686: oe_debug_pub.add( 'OEXPIFPB: BEFORE INSERT TO OE_CREDITS_IFACE_ALL' ) ;

1682: END IF;
1683: END IF;
1684:
1685: IF l_debug_level > 0 THEN
1686: oe_debug_pub.add( 'OEXPIFPB: BEFORE INSERT TO OE_CREDITS_IFACE_ALL' ) ;
1687: END IF;
1688: /* Header Level Sales Credits */
1689: INSERT INTO OE_CREDITS_IFACE_ALL (
1690: SALESREP /*VARCHAR2(30)*/

Line 1786: oe_debug_pub.add( 'OEXPIFPB: AFTER SUCCESSFUL INSERT TO OE_CREDITS_IFACE_ALL FOR HEADER' ) ;

1782: and line_id is null;
1783:
1784: IF SQL%ROWCOUNT > 0 THEN
1785: IF l_debug_level > 0 THEN
1786: oe_debug_pub.add( 'OEXPIFPB: AFTER SUCCESSFUL INSERT TO OE_CREDITS_IFACE_ALL FOR HEADER' ) ;
1787: END IF;
1788: ELSE
1789: IF l_debug_level > 0 THEN
1790: oe_debug_pub.add( 'OEXPIFPB: AFTER UN-SUCCESSFUL INSERT TO OE_CREDITS_IFACE_ALL FOR HEADER' ) ;

Line 1790: oe_debug_pub.add( 'OEXPIFPB: AFTER UN-SUCCESSFUL INSERT TO OE_CREDITS_IFACE_ALL FOR HEADER' ) ;

1786: oe_debug_pub.add( 'OEXPIFPB: AFTER SUCCESSFUL INSERT TO OE_CREDITS_IFACE_ALL FOR HEADER' ) ;
1787: END IF;
1788: ELSE
1789: IF l_debug_level > 0 THEN
1790: oe_debug_pub.add( 'OEXPIFPB: AFTER UN-SUCCESSFUL INSERT TO OE_CREDITS_IFACE_ALL FOR HEADER' ) ;
1791: END IF;
1792: END IF;
1793:
1794: IF l_debug_level > 0 THEN

Line 1795: oe_debug_pub.add( 'OEXPIFPB: BEFORE INSERT TO OE_CREDITS_IFACE_ALL' ) ;

1791: END IF;
1792: END IF;
1793:
1794: IF l_debug_level > 0 THEN
1795: oe_debug_pub.add( 'OEXPIFPB: BEFORE INSERT TO OE_CREDITS_IFACE_ALL' ) ;
1796: END IF;
1797:
1798: /* Line Level Sales Credits */
1799: INSERT INTO OE_CREDITS_IFACE_ALL (

Line 1896: oe_debug_pub.add( 'OEXPIFPB: AFTER SUCCESSFUL INSERT TO OE_CREDITS_IFACE_ALL FOR LINES' ) ;

1892: and line_id is not null;
1893:
1894: IF SQL%ROWCOUNT > 0 THEN
1895: IF l_debug_level > 0 THEN
1896: oe_debug_pub.add( 'OEXPIFPB: AFTER SUCCESSFUL INSERT TO OE_CREDITS_IFACE_ALL FOR LINES' ) ;
1897: END IF;
1898: ELSE
1899: IF l_debug_level > 0 THEN
1900: oe_debug_pub.add( 'OEXPIFPB: AFTER UN-SUCCESSFUL INSERT TO OE_CREDITS_IFACE_ALL FOR LINES' ) ;

Line 1900: oe_debug_pub.add( 'OEXPIFPB: AFTER UN-SUCCESSFUL INSERT TO OE_CREDITS_IFACE_ALL FOR LINES' ) ;

1896: oe_debug_pub.add( 'OEXPIFPB: AFTER SUCCESSFUL INSERT TO OE_CREDITS_IFACE_ALL FOR LINES' ) ;
1897: END IF;
1898: ELSE
1899: IF l_debug_level > 0 THEN
1900: oe_debug_pub.add( 'OEXPIFPB: AFTER UN-SUCCESSFUL INSERT TO OE_CREDITS_IFACE_ALL FOR LINES' ) ;
1901: END IF;
1902: END IF;
1903:
1904: IF l_debug_level > 0 THEN

Line 1905: oe_debug_pub.add( 'OEXPIFPB: BEFORE INSERT TO OE_LOTSERIALS_IFACE_ALL' ) ;

1901: END IF;
1902: END IF;
1903:
1904: IF l_debug_level > 0 THEN
1905: oe_debug_pub.add( 'OEXPIFPB: BEFORE INSERT TO OE_LOTSERIALS_IFACE_ALL' ) ;
1906: END IF;
1907:
1908: /* Line Level Lots Serial */
1909: INSERT INTO OE_LOTSERIALS_IFACE_ALL (

Line 2006: oe_debug_pub.add( 'OEXPIFPB: AFTER SUCCESSFUL INSERT TO OE_LOTSERIALS_IFACE_ALL FOR LINES' ) ;

2002: where header_id = old_header_id_v);
2003:
2004: IF SQL%ROWCOUNT > 0 THEN
2005: IF l_debug_level > 0 THEN
2006: oe_debug_pub.add( 'OEXPIFPB: AFTER SUCCESSFUL INSERT TO OE_LOTSERIALS_IFACE_ALL FOR LINES' ) ;
2007: END IF;
2008: ELSE
2009: IF l_debug_level > 0 THEN
2010: oe_debug_pub.add( 'OEXPIFPB: AFTER UN-SUCCESSFUL INSERT TO OE_LOTSERIALS_IFACE_ALL FOR LINES' ) ;

Line 2010: oe_debug_pub.add( 'OEXPIFPB: AFTER UN-SUCCESSFUL INSERT TO OE_LOTSERIALS_IFACE_ALL FOR LINES' ) ;

2006: oe_debug_pub.add( 'OEXPIFPB: AFTER SUCCESSFUL INSERT TO OE_LOTSERIALS_IFACE_ALL FOR LINES' ) ;
2007: END IF;
2008: ELSE
2009: IF l_debug_level > 0 THEN
2010: oe_debug_pub.add( 'OEXPIFPB: AFTER UN-SUCCESSFUL INSERT TO OE_LOTSERIALS_IFACE_ALL FOR LINES' ) ;
2011: END IF;
2012: END IF;
2013:
2014: IF l_debug_level > 0 THEN

Line 2015: oe_debug_pub.add( 'OEXPIFPB: BEFORE UPDATE OE_LINES_IFACE_ALL' ) ;

2011: END IF;
2012: END IF;
2013:
2014: IF l_debug_level > 0 THEN
2015: oe_debug_pub.add( 'OEXPIFPB: BEFORE UPDATE OE_LINES_IFACE_ALL' ) ;
2016: END IF;
2017: update oe_lines_iface_all
2018: set line_id = ''
2019: where orig_sys_document_ref = to_char(order_number_v);

Line 2023: oe_debug_pub.add( 'OEXPIFPB: AFTER SUCCESSFUL UPDATE OF OE_LINES_IFACE_ALL' ) ;

2019: where orig_sys_document_ref = to_char(order_number_v);
2020:
2021: IF SQL%ROWCOUNT > 0 THEN
2022: IF l_debug_level > 0 THEN
2023: oe_debug_pub.add( 'OEXPIFPB: AFTER SUCCESSFUL UPDATE OF OE_LINES_IFACE_ALL' ) ;
2024: END IF;
2025: ELSE
2026: IF l_debug_level > 0 THEN
2027: oe_debug_pub.add( 'OEXPIFPB: AFTER UN-SUCCESSFUL UPDATE OF OE_LINES_IFACE_ALL' ) ;

Line 2027: oe_debug_pub.add( 'OEXPIFPB: AFTER UN-SUCCESSFUL UPDATE OF OE_LINES_IFACE_ALL' ) ;

2023: oe_debug_pub.add( 'OEXPIFPB: AFTER SUCCESSFUL UPDATE OF OE_LINES_IFACE_ALL' ) ;
2024: END IF;
2025: ELSE
2026: IF l_debug_level > 0 THEN
2027: oe_debug_pub.add( 'OEXPIFPB: AFTER UN-SUCCESSFUL UPDATE OF OE_LINES_IFACE_ALL' ) ;
2028: END IF;
2029: END IF;
2030:
2031: END IF;

Line 2044: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

2040: l_link_to_line_id NUMBER;
2041: l_line_number NUMBER;
2042: l_option_number NUMBER;
2043: --
2044: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2045: --
2046: BEGIN
2047:
2048: IF l_debug_level > 0 THEN

Line 2049: oe_debug_pub.add( 'OEXPIFPB: ENTERING GET_LINK_TO_LINE_REF API' ) ;

2045: --
2046: BEGIN
2047:
2048: IF l_debug_level > 0 THEN
2049: oe_debug_pub.add( 'OEXPIFPB: ENTERING GET_LINK_TO_LINE_REF API' ) ;
2050: END IF;
2051:
2052: -- dbms_output.put_line('line id =>' || to_char(p_line_id));
2053: SELECT link_to_line_id, line_number, option_number

Line 2059: oe_debug_pub.add( 'OEXPIFPB: AFTER SELECTING LINK DATA' ) ;

2055: FROM oe_order_lines
2056: WHERE line_id = p_line_id;
2057:
2058: IF l_debug_level > 0 THEN
2059: oe_debug_pub.add( 'OEXPIFPB: AFTER SELECTING LINK DATA' ) ;
2060: END IF;
2061:
2062: IF l_link_to_line_id is null THEN
2063: -- dbms_output.put_line('link to line id is null');

Line 2065: oe_debug_pub.add( 'OEXPIFPB: LINK LINEID IS NULL' ) ;

2061:
2062: IF l_link_to_line_id is null THEN
2063: -- dbms_output.put_line('link to line id is null');
2064: IF l_debug_level > 0 THEN
2065: oe_debug_pub.add( 'OEXPIFPB: LINK LINEID IS NULL' ) ;
2066: END IF;
2067: return null;
2068: ELSIF l_link_to_line_id is not null THEN
2069: IF l_debug_level > 0 THEN

Line 2070: oe_debug_pub.add( 'OEXPIFPB: LINK LINEID IS NOT NULL' ) ;

2066: END IF;
2067: return null;
2068: ELSIF l_link_to_line_id is not null THEN
2069: IF l_debug_level > 0 THEN
2070: oe_debug_pub.add( 'OEXPIFPB: LINK LINEID IS NOT NULL' ) ;
2071: END IF;
2072: BEGIN
2073: SELECT line_number, option_number
2074: INTO l_line_number, l_option_number

Line 2081: oe_debug_pub.add( 'OEXPIFPB: BEFORE RETURN LINK DATA' ) ;

2077: END;
2078:
2079: -- dbms_output.put_line('link to line id is not null');
2080: IF l_debug_level > 0 THEN
2081: oe_debug_pub.add( 'OEXPIFPB: BEFORE RETURN LINK DATA' ) ;
2082: END IF;
2083: return to_char(l_line_number) || '-' || to_char(l_option_number);
2084:
2085: END IF;

Line 2091: oe_debug_pub.add( 'OEXPIFPB: LINK RETURNS OTHERS EXCEPTION' ) ;

2087: EXCEPTION
2088: WHEN OTHERS THEN
2089: -- dbms_output.put_line('link to line id exception');
2090: IF l_debug_level > 0 THEN
2091: oe_debug_pub.add( 'OEXPIFPB: LINK RETURNS OTHERS EXCEPTION' ) ;
2092: END IF;
2093:
2094: return null;
2095:

Line 2107: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

2103: l_top_model_line_id NUMBER;
2104: l_line_number NUMBER;
2105: l_option_number NUMBER;
2106: --
2107: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2108: --
2109: BEGIN
2110:
2111: IF l_debug_level > 0 THEN

Line 2112: oe_debug_pub.add( 'OEXPIFPB: ENTERING GET_TOP_MODEL_LINE_REF API' ) ;

2108: --
2109: BEGIN
2110:
2111: IF l_debug_level > 0 THEN
2112: oe_debug_pub.add( 'OEXPIFPB: ENTERING GET_TOP_MODEL_LINE_REF API' ) ;
2113: END IF;
2114:
2115: SELECT top_model_line_id, line_number, option_number
2116: INTO l_top_model_line_id, l_line_number,l_option_number

Line 2123: oe_debug_pub.add( 'OEXPIFPB: TOP MODEL LINEID IS NULL' ) ;

2119:
2120: IF l_top_model_line_id is null THEN
2121: -- dbms_output.put_line('top model is null');
2122: IF l_debug_level > 0 THEN
2123: oe_debug_pub.add( 'OEXPIFPB: TOP MODEL LINEID IS NULL' ) ;
2124: END IF;
2125: return null;
2126: ELSIF l_top_model_line_id is not null THEN
2127: -- dbms_output.put_line('top model is not null');

Line 2129: oe_debug_pub.add( 'OEXPIFPB: TOP MODEL LINEID IS NOT NULL' ) ;

2125: return null;
2126: ELSIF l_top_model_line_id is not null THEN
2127: -- dbms_output.put_line('top model is not null');
2128: IF l_debug_level > 0 THEN
2129: oe_debug_pub.add( 'OEXPIFPB: TOP MODEL LINEID IS NOT NULL' ) ;
2130: END IF;
2131: BEGIN
2132: SELECT line_number, option_number
2133: INTO l_line_number, l_option_number

Line 2140: oe_debug_pub.add( 'OEXPIFPB: BEFORE RETURN TOP MODEL DATA' ) ;

2136: END;
2137:
2138: -- dbms_output.put_line('top model is not null before retunr');
2139: IF l_debug_level > 0 THEN
2140: oe_debug_pub.add( 'OEXPIFPB: BEFORE RETURN TOP MODEL DATA' ) ;
2141: END IF;
2142: return to_char(l_line_number) || '-' || to_char(l_option_number);
2143:
2144: END IF;

Line 2150: oe_debug_pub.add( 'OEXPIFPB: TOP MODEL RETURNS OTHERS EXCEPTION' ) ;

2146: EXCEPTION
2147: WHEN OTHERS THEN
2148: -- dbms_output.put_line('top model exception');
2149: IF l_debug_level > 0 THEN
2150: oe_debug_pub.add( 'OEXPIFPB: TOP MODEL RETURNS OTHERS EXCEPTION' ) ;
2151: END IF;
2152: return null;
2153:
2154: END GET_TOP_MODEL_LINE_REF;

Line 2163: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

2159: RETURN VARCHAR2
2160: IS
2161: l_orig_sys_line_ref VARCHAR2(50);
2162: --
2163: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2164: --
2165: BEGIN
2166:
2167: IF l_debug_level > 0 THEN

Line 2168: oe_debug_pub.add( 'OEXPIFPB: ENTERING GET_LINE_REF_FROM_LINE_ID API' ) ;

2164: --
2165: BEGIN
2166:
2167: IF l_debug_level > 0 THEN
2168: oe_debug_pub.add( 'OEXPIFPB: ENTERING GET_LINE_REF_FROM_LINE_ID API' ) ;
2169: END IF;
2170: IF l_debug_level > 0 THEN
2171: oe_debug_pub.add( 'P_LINE_ID ==> ' || P_LINE_ID ) ;
2172: END IF;

Line 2171: oe_debug_pub.add( 'P_LINE_ID ==> ' || P_LINE_ID ) ;

2167: IF l_debug_level > 0 THEN
2168: oe_debug_pub.add( 'OEXPIFPB: ENTERING GET_LINE_REF_FROM_LINE_ID API' ) ;
2169: END IF;
2170: IF l_debug_level > 0 THEN
2171: oe_debug_pub.add( 'P_LINE_ID ==> ' || P_LINE_ID ) ;
2172: END IF;
2173:
2174: SELECT orig_sys_line_ref
2175: INTO l_orig_sys_line_ref

Line 2180: oe_debug_pub.add( 'OEXPIFPB: BEFORE RETURN LINE REF' ) ;

2176: FROM oe_lines_iface_all
2177: WHERE line_id = p_line_id;
2178:
2179: IF l_debug_level > 0 THEN
2180: oe_debug_pub.add( 'OEXPIFPB: BEFORE RETURN LINE REF' ) ;
2181: END IF;
2182: IF l_debug_level > 0 THEN
2183: oe_debug_pub.add( 'L_ORIG_SYS_LINE_REF ==> ' || L_ORIG_SYS_LINE_REF ) ;
2184: END IF;

Line 2183: oe_debug_pub.add( 'L_ORIG_SYS_LINE_REF ==> ' || L_ORIG_SYS_LINE_REF ) ;

2179: IF l_debug_level > 0 THEN
2180: oe_debug_pub.add( 'OEXPIFPB: BEFORE RETURN LINE REF' ) ;
2181: END IF;
2182: IF l_debug_level > 0 THEN
2183: oe_debug_pub.add( 'L_ORIG_SYS_LINE_REF ==> ' || L_ORIG_SYS_LINE_REF ) ;
2184: END IF;
2185: return l_orig_sys_line_ref;
2186:
2187: EXCEPTION

Line 2190: oe_debug_pub.add( 'OEXPIFPB: LINE REF RETURNS OTHERS EXCEPTION' ) ;

2186:
2187: EXCEPTION
2188: WHEN OTHERS THEN
2189: IF l_debug_level > 0 THEN
2190: oe_debug_pub.add( 'OEXPIFPB: LINE REF RETURNS OTHERS EXCEPTION' ) ;
2191: END IF;
2192: return null;
2193:
2194: END GET_LINE_REF_FROM_LINE_ID;