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_OUTBOUND_INT dependencies on OE_DEBUG_PUB

Line 1865: oe_debug_pub.add('Entering Procedure Sync_Order');

1861: P_HDR_ACK_TBL_ OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_TBL_TYPE;
1862: P_LINE_ACK_TBL_ OE_ACKNOWLEDGMENT_PUB.LINE_ACK_TBL_TYPE;
1863: BEGIN
1864:
1865: oe_debug_pub.add('Entering Procedure Sync_Order');
1866:
1867: OE_SYNC_ORDER_PVT.PROCESS_ORDER_SYNC(
1868: P_HEADER_ID,
1869: P_HDR_REQ_ID,

Line 1882: oe_debug_pub.add('Before assigning P_HDR_ACK_TBL');

1878: X_MSG_COUNT,
1879: X_MSG_DATA);
1880:
1881: IF P_HDR_ACK_TBL_.count > 0 THEN
1882: oe_debug_pub.add('Before assigning P_HDR_ACK_TBL');
1883: P_HDR_ACK_TBL := BPEL_UPDATEORDEREBS11I10TOCOMS.PL_TO_SQL0(P_HDR_ACK_TBL_);
1884: oe_debug_pub.add('After assigning P_HDR_ACK_TBL');
1885: END IF;
1886:

Line 1884: oe_debug_pub.add('After assigning P_HDR_ACK_TBL');

1880:
1881: IF P_HDR_ACK_TBL_.count > 0 THEN
1882: oe_debug_pub.add('Before assigning P_HDR_ACK_TBL');
1883: P_HDR_ACK_TBL := BPEL_UPDATEORDEREBS11I10TOCOMS.PL_TO_SQL0(P_HDR_ACK_TBL_);
1884: oe_debug_pub.add('After assigning P_HDR_ACK_TBL');
1885: END IF;
1886:
1887: IF P_LINE_ACK_TBL_.count > 0 THEN
1888: oe_debug_pub.add('Before assigning P_LINE_ACK_TBL');

Line 1888: oe_debug_pub.add('Before assigning P_LINE_ACK_TBL');

1884: oe_debug_pub.add('After assigning P_HDR_ACK_TBL');
1885: END IF;
1886:
1887: IF P_LINE_ACK_TBL_.count > 0 THEN
1888: oe_debug_pub.add('Before assigning P_LINE_ACK_TBL');
1889: P_LINE_ACK_TBL := BPEL_UPDATEORDEREBS11I10TOCOMS.PL_TO_SQL1(P_LINE_ACK_TBL_);
1890: oe_debug_pub.add('After assigning P_LINE_ACK_TBL');
1891: END IF;
1892:

Line 1890: oe_debug_pub.add('After assigning P_LINE_ACK_TBL');

1886:
1887: IF P_LINE_ACK_TBL_.count > 0 THEN
1888: oe_debug_pub.add('Before assigning P_LINE_ACK_TBL');
1889: P_LINE_ACK_TBL := BPEL_UPDATEORDEREBS11I10TOCOMS.PL_TO_SQL1(P_LINE_ACK_TBL_);
1890: oe_debug_pub.add('After assigning P_LINE_ACK_TBL');
1891: END IF;
1892:
1893: oe_debug_pub.add('Exiting Procedure Sync_Order');
1894: END Sync_Order;

Line 1893: oe_debug_pub.add('Exiting Procedure Sync_Order');

1889: P_LINE_ACK_TBL := BPEL_UPDATEORDEREBS11I10TOCOMS.PL_TO_SQL1(P_LINE_ACK_TBL_);
1890: oe_debug_pub.add('After assigning P_LINE_ACK_TBL');
1891: END IF;
1892:
1893: oe_debug_pub.add('Exiting Procedure Sync_Order');
1894: END Sync_Order;
1895:
1896: ----- O2C25
1897: PROCEDURE Sync_Order_25

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

1911: IS
1912: P_HDR_ACK_TBL_ OE_SYNC_ORDER_PVT_HEADER_ACK_;
1913: P_LINE_ACK_TBL_ OE_SYNC_ORDER_PVT_LINE_ACK_TB;
1914:
1915: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1916: BEGIN
1917: IF l_debug_level > 0 THEN
1918: oe_debug_pub.add('Entering Procedure Sync_Order_25', 1);
1919: END IF;

Line 1918: oe_debug_pub.add('Entering Procedure Sync_Order_25', 1);

1914:
1915: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1916: BEGIN
1917: IF l_debug_level > 0 THEN
1918: oe_debug_pub.add('Entering Procedure Sync_Order_25', 1);
1919: END IF;
1920:
1921: IF l_debug_level > 0 THEN
1922: oe_debug_pub.ADD(' Before calling Oe_Inbound_Int.Sync_Order...', 1);

Line 1922: oe_debug_pub.ADD(' Before calling Oe_Inbound_Int.Sync_Order...', 1);

1918: oe_debug_pub.add('Entering Procedure Sync_Order_25', 1);
1919: END IF;
1920:
1921: IF l_debug_level > 0 THEN
1922: oe_debug_pub.ADD(' Before calling Oe_Inbound_Int.Sync_Order...', 1);
1923: END IF;
1924:
1925: Oe_Outbound_Int.Sync_Order(
1926: P_HEADER_ID,

Line 1941: oe_debug_pub.ADD(' After returning from Oe_Inbound_Int.Sync_Order...', 1);

1937: X_MSG_DATA
1938: );
1939:
1940: IF l_debug_level > 0 THEN
1941: oe_debug_pub.ADD(' After returning from Oe_Inbound_Int.Sync_Order...', 1);
1942: END IF;
1943:
1944: BEGIN
1945: IF P_HDR_ACK_TBL_.count > 0 THEN

Line 1947: oe_debug_pub.add('Before assigning P_HDR_ACK_TBL25', 1);

1943:
1944: BEGIN
1945: IF P_HDR_ACK_TBL_.count > 0 THEN
1946: IF l_debug_level > 0 THEN
1947: oe_debug_pub.add('Before assigning P_HDR_ACK_TBL25', 1);
1948: END IF;
1949: -- Write conversion logic between the PL/SQL record type and the
1950: -- PL/SQL object type.
1951: Oe_Genesis_Util.hdr_ack_tab_to_hdr_ack_tab25(

Line 1957: oe_debug_pub.add('After assigning P_HDR_ACK_TBL25', 1);

1953: x_hdr_ack_tab25 => P_HDR_ACK_TBL25
1954: );
1955:
1956: IF l_debug_level > 0 THEN
1957: oe_debug_pub.add('After assigning P_HDR_ACK_TBL25', 1);
1958: END IF;
1959: END IF;
1960: EXCEPTION
1961: WHEN Others THEN

Line 1963: oe_debug_pub.ADD(' Exception in deriving p_hdr_ack_tbl25 records.');

1959: END IF;
1960: EXCEPTION
1961: WHEN Others THEN
1962: IF l_debug_level > 0 THEN
1963: oe_debug_pub.ADD(' Exception in deriving p_hdr_ack_tbl25 records.');
1964: oe_debug_pub.ADD(' Error: ' || SQLERRM);
1965: END IF;
1966: END;
1967:

Line 1964: oe_debug_pub.ADD(' Error: ' || SQLERRM);

1960: EXCEPTION
1961: WHEN Others THEN
1962: IF l_debug_level > 0 THEN
1963: oe_debug_pub.ADD(' Exception in deriving p_hdr_ack_tbl25 records.');
1964: oe_debug_pub.ADD(' Error: ' || SQLERRM);
1965: END IF;
1966: END;
1967:
1968: BEGIN

Line 1973: oe_debug_pub.add('Before assigning P_LINE_ACK_TBL25', 1);

1969: IF P_LINE_ACK_TBL_.count > 0 THEN
1970: -- Write conversion logic between the PL/SQL record type and the
1971: -- PL/SQL object type.
1972: IF l_debug_level > 0 THEN
1973: oe_debug_pub.add('Before assigning P_LINE_ACK_TBL25', 1);
1974: END IF;
1975:
1976: Oe_Genesis_Util.line_ack_tab_to_line_ack_tab25(
1977: p_line_ack_tab => P_LINE_ACK_TBL_ ,

Line 1982: oe_debug_pub.add('After assigning P_LINE_ACK_TBL25', 1);

1978: x_line_ack_tab25 => P_LINE_ACK_TBL25
1979: );
1980:
1981: IF l_debug_level > 0 THEN
1982: oe_debug_pub.add('After assigning P_LINE_ACK_TBL25', 1);
1983: END IF;
1984: END IF;
1985: EXCEPTION
1986: -- This happens when only a header level action is performed e.g.,

Line 1990: oe_debug_pub.ADD(' Exception in deriving p_line_ack_tbl25 records.');

1986: -- This happens when only a header level action is performed e.g.,
1987: -- header level hold.
1988: WHEN Others THEN
1989: IF l_debug_level > 0 THEN
1990: oe_debug_pub.ADD(' Exception in deriving p_line_ack_tbl25 records.');
1991: oe_debug_pub.ADD(' Error: ' || SQLERRM);
1992: END IF;
1993: END;
1994:

Line 1991: oe_debug_pub.ADD(' Error: ' || SQLERRM);

1987: -- header level hold.
1988: WHEN Others THEN
1989: IF l_debug_level > 0 THEN
1990: oe_debug_pub.ADD(' Exception in deriving p_line_ack_tbl25 records.');
1991: oe_debug_pub.ADD(' Error: ' || SQLERRM);
1992: END IF;
1993: END;
1994:
1995:

Line 2005: oe_debug_pub.ADD(' Profile ONT_TAX_ROLLUP_HDR_AIA has a value: Y');

2001: IF Nvl(fnd_profile.Value('ONT_TAX_ROLLUP_HDR_AIA'), fnd_api.g_miss_char)
2002: = 'Y'
2003: THEN
2004: IF l_debug_level > 0 THEN
2005: oe_debug_pub.ADD(' Profile ONT_TAX_ROLLUP_HDR_AIA has a value: Y');
2006: END IF;
2007:
2008: BEGIN
2009: FOR i IN p_hdr_ack_tbl25.first..p_hdr_ack_tbl25.last

Line 2018: oe_debug_pub.ADD(' Exception in looping over p_hdr_ack_tbl25...');

2014: END LOOP;
2015: EXCEPTION
2016: WHEN Others THEN
2017: IF l_debug_level > 0 THEN
2018: oe_debug_pub.ADD(' Exception in looping over p_hdr_ack_tbl25...');
2019: oe_debug_pub.ADD(' Error: ' || SQLERRM);
2020: END IF;
2021: END;
2022: END IF; -- Check on ONT_TAX_ROLLUP_HDR_AIA profile option value.

Line 2019: oe_debug_pub.ADD(' Error: ' || SQLERRM);

2015: EXCEPTION
2016: WHEN Others THEN
2017: IF l_debug_level > 0 THEN
2018: oe_debug_pub.ADD(' Exception in looping over p_hdr_ack_tbl25...');
2019: oe_debug_pub.ADD(' Error: ' || SQLERRM);
2020: END IF;
2021: END;
2022: END IF; -- Check on ONT_TAX_ROLLUP_HDR_AIA profile option value.
2023:

Line 2029: oe_debug_pub.ADD(' Profile ONT_CHARGES_ROLLUP_HDR_AIA has a value: Y');

2025: IF Nvl(fnd_profile.Value('ONT_CHARGES_ROLLUP_HDR_AIA'), fnd_api.g_miss_char)
2026: = 'Y'
2027: THEN
2028: IF l_debug_level > 0 THEN
2029: oe_debug_pub.ADD(' Profile ONT_CHARGES_ROLLUP_HDR_AIA has a value: Y');
2030: END IF;
2031:
2032: BEGIN
2033: FOR i IN p_hdr_ack_tbl25.first..p_hdr_ack_tbl25.last

Line 2041: oe_debug_pub.ADD(' Exception in looping over p_hdr_ack_tbl25...');

2037: END LOOP;
2038: EXCEPTION
2039: WHEN Others THEN
2040: IF l_debug_level > 0 THEN
2041: oe_debug_pub.ADD(' Exception in looping over p_hdr_ack_tbl25...');
2042: oe_debug_pub.ADD(' Error: ' || SQLERRM);
2043: END IF;
2044: END;
2045: END IF; -- Check on ONT_CHARGES_ROLLUP_HDR_AIA profile option value.

Line 2042: oe_debug_pub.ADD(' Error: ' || SQLERRM);

2038: EXCEPTION
2039: WHEN Others THEN
2040: IF l_debug_level > 0 THEN
2041: oe_debug_pub.ADD(' Exception in looping over p_hdr_ack_tbl25...');
2042: oe_debug_pub.ADD(' Error: ' || SQLERRM);
2043: END IF;
2044: END;
2045: END IF; -- Check on ONT_CHARGES_ROLLUP_HDR_AIA profile option value.
2046:

Line 2052: oe_debug_pub.ADD(' Profile ONT_CHARGES_ROLLUP_HDR_AIA has a value: Y');

2048: IF Nvl(fnd_profile.Value('ONT_CHARGES_ROLLUP_LINE_AIA'), fnd_api.g_miss_char)
2049: = 'Y'
2050: THEN
2051: IF l_debug_level > 0 THEN
2052: oe_debug_pub.ADD(' Profile ONT_CHARGES_ROLLUP_HDR_AIA has a value: Y');
2053: END IF;
2054:
2055: BEGIN
2056: FOR i IN p_line_ack_tbl25.first..p_line_ack_tbl25.last

Line 2067: oe_debug_pub.ADD(' Exception in looping over p_hdr_ack_tbl25...');

2063: END LOOP;
2064: EXCEPTION
2065: WHEN Others THEN
2066: IF l_debug_level > 0 THEN
2067: oe_debug_pub.ADD(' Exception in looping over p_hdr_ack_tbl25...');
2068: oe_debug_pub.ADD(' Error: ' || SQLERRM);
2069: END IF;
2070: END;
2071: END IF; -- Check on ONT_CHARGES_ROLLUP_LINE_AIA profile option value.

Line 2068: oe_debug_pub.ADD(' Error: ' || SQLERRM);

2064: EXCEPTION
2065: WHEN Others THEN
2066: IF l_debug_level > 0 THEN
2067: oe_debug_pub.ADD(' Exception in looping over p_hdr_ack_tbl25...');
2068: oe_debug_pub.ADD(' Error: ' || SQLERRM);
2069: END IF;
2070: END;
2071: END IF; -- Check on ONT_CHARGES_ROLLUP_LINE_AIA profile option value.
2072:

Line 2074: oe_debug_pub.add('Exiting Procedure Sync_Order_25', 1);

2070: END;
2071: END IF; -- Check on ONT_CHARGES_ROLLUP_LINE_AIA profile option value.
2072:
2073: IF l_debug_level > 0 THEN
2074: oe_debug_pub.add('Exiting Procedure Sync_Order_25', 1);
2075: END IF;
2076:
2077: END;
2078: ----- O2C25