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.XDP_PROC_CTL dependencies on DBMS_LOB

Line 1767: DBMS_LOB.createtemporary(l_TempLob, TRUE);

1763: l_ReturnChannelName := XDP_ADAPTER_CORE_PIPE.GetReturnChannelName
1764: (p_ChannelName => l_ApplChannelName);
1765:
1766: begin
1767: DBMS_LOB.createtemporary(l_TempLob, TRUE);
1768: xdp_adapter.pv_AdapterExitCode := null;
1769:
1770: -- dbms_output.put_line('Sending: ' || substr(l_ActualStr, 1, 200));
1771: -- dbms_output.put_line('Prompt: ' || substr(l_PromptValue, 1, 200));

Line 1809: dbms_lob.writeappend(l_TempLob, length(Response), Response);

1805: p_XMLMessage => l_RespXML);
1806:
1807: if Response is not null then
1808: -- dbms_output.put_line('After Reponse' || length(Response));
1809: dbms_lob.writeappend(l_TempLob, length(Response), Response);
1810: end if;
1811: -- dbms_output.put_line('After Logging..');
1812:
1813: while (l_MoreFlag is not null and l_MoreFlag = 'Y' ) loop

Line 1849: dbms_lob.writeappend(

1845: p_XMLMessage => l_RespXML);
1846:
1847: if l_TempResponse is not null then
1848: -- dbms_output.put_line('After Reponse (LOOP)' || length(l_TempResponse));
1849: dbms_lob.writeappend(
1850: l_TempLob, length(l_TempResponse), l_TempResponse);
1851: end if;
1852: -- dbms_output.put_line('After Logging(LOOP)..');
1853:

Line 1951: DBMS_LOB.freetemporary(l_TempLob);

1947: else
1948: RAISE e_UnhandledException;
1949: end if;
1950:
1951: DBMS_LOB.freetemporary(l_TempLob);
1952:
1953: exception
1954: when e_ParamValueException then
1955: ErrCode := -20001;

Line 1959: DBMS_LOB.freetemporary(l_TempLob);

1955: ErrCode := -20001;
1956: ErrStr := x_progress;
1957: sdp_internal_err_code := ErrCode;
1958: sdp_internal_err_str := ErrStr;
1959: DBMS_LOB.freetemporary(l_TempLob);
1960:
1961: RAISE_APPLICATION_ERROR(-20001, x_progress);
1962:
1963: when e_ProcExecException then

Line 1968: DBMS_LOB.freetemporary(l_TempLob);

1964: ErrCode := -20021;
1965: ErrStr := x_progress;
1966: sdp_internal_err_code := ErrCode;
1967: sdp_internal_err_str := ErrStr;
1968: DBMS_LOB.freetemporary(l_TempLob);
1969:
1970: RAISE_APPLICATION_ERROR(-20021, x_progress);
1971:
1972: when e_PipeSendAckException then

Line 1977: DBMS_LOB.freetemporary(l_TempLob);

1973: ErrCode := -20101;
1974: ErrStr := x_progress;
1975: sdp_internal_err_code := ErrCode;
1976: sdp_internal_err_str := ErrStr;
1977: DBMS_LOB.freetemporary(l_TempLob);
1978:
1979: RAISE_APPLICATION_ERROR(-20101, x_progress);
1980:
1981: when e_PipeWaitForAckException then

Line 1986: DBMS_LOB.freetemporary(l_TempLob);

1982: ErrCode := -20102;
1983: ErrStr := x_progress;
1984: sdp_internal_err_code := ErrCode;
1985: sdp_internal_err_str := ErrStr;
1986: DBMS_LOB.freetemporary(l_TempLob);
1987: RAISE_APPLICATION_ERROR(-20102, x_progress);
1988:
1989: when e_PipeWaitForMesgException then
1990: ErrCode := -20103;

Line 1994: DBMS_LOB.freetemporary(l_TempLob);

1990: ErrCode := -20103;
1991: ErrStr := x_progress;
1992: sdp_internal_err_code := ErrCode;
1993: sdp_internal_err_str := ErrStr;
1994: DBMS_LOB.freetemporary(l_TempLob);
1995:
1996: RAISE_APPLICATION_ERROR(-20103, x_progress);
1997:
1998: when e_PipeSendMesgException then

Line 2003: DBMS_LOB.freetemporary(l_TempLob);

1999: ErrCode := -20104;
2000: ErrStr := x_progress;
2001: sdp_internal_err_code := ErrCode;
2002: sdp_internal_err_str := ErrStr;
2003: DBMS_LOB.freetemporary(l_TempLob);
2004:
2005: RAISE_APPLICATION_ERROR(-20104, x_progress);
2006:
2007: when e_PipePackMesgException then

Line 2012: DBMS_LOB.freetemporary(l_TempLob);

2008: ErrCode := -20105;
2009: ErrStr := x_progress;
2010: sdp_internal_err_code := ErrCode;
2011: sdp_internal_err_str := ErrStr;
2012: DBMS_LOB.freetemporary(l_TempLob);
2013:
2014: RAISE_APPLICATION_ERROR(-20105, x_progress);
2015:
2016: when e_PipeUnpackMesgException then

Line 2021: DBMS_LOB.freetemporary(l_TempLob);

2017: ErrCode := -20106;
2018: ErrStr := x_progress;
2019: sdp_internal_err_code := ErrCode;
2020: sdp_internal_err_str := ErrStr;
2021: DBMS_LOB.freetemporary(l_TempLob);
2022:
2023: RAISE_APPLICATION_ERROR(-20106, x_progress);
2024:
2025: when e_PipeOutOfSyncException then

Line 2030: DBMS_LOB.freetemporary(l_TempLob);

2026: ErrCode := -20107;
2027: ErrStr := x_progress;
2028: sdp_internal_err_code := ErrCode;
2029: sdp_internal_err_str := ErrStr;
2030: DBMS_LOB.freetemporary(l_TempLob);
2031:
2032: RAISE_APPLICATION_ERROR(-20107, x_progress);
2033:
2034: when e_NeFailureException then

Line 2039: DBMS_LOB.freetemporary(l_TempLob);

2035: ErrCode := xdp_adapter.pv_AdapterFailure;
2036: ErrStr := x_progress;
2037: sdp_internal_err_code := ErrCode;
2038: sdp_internal_err_str := ErrStr;
2039: DBMS_LOB.freetemporary(l_TempLob);
2040:
2041: RAISE_APPLICATION_ERROR(-20300, x_progress);
2042:
2043: when e_NeWarningException then

Line 2048: DBMS_LOB.freetemporary(l_TempLob);

2044: ErrCode := xdp_adapter.pv_AdapterWarning;
2045: ErrStr := x_progress;
2046: sdp_internal_err_code := ErrCode;
2047: sdp_internal_err_str := ErrStr;
2048: DBMS_LOB.freetemporary(l_TempLob);
2049:
2050: -- RAISE_APPLICATION_ERROR(-20500, x_progress);
2051:
2052: when e_NeSessionLostException then

Line 2057: DBMS_LOB.freetemporary(l_TempLob);

2053: ErrCode := xdp_adapter.pv_AdapterSessionLost;
2054: ErrStr := x_progress;
2055: sdp_internal_err_code := ErrCode;
2056: sdp_internal_err_str := ErrStr;
2057: DBMS_LOB.freetemporary(l_TempLob);
2058:
2059: --Changed sacsharm 2/19/02 Use update API that is autonomous
2060: --update XDP_ADAPTER_REG
2061: --set adapter_status = 'SESSION_LOST',

Line 2075: DBMS_LOB.freetemporary(l_TempLob);

2071: ErrCode := xdp_adapter.pv_AdapterTimeout;
2072: ErrStr := x_progress;
2073: sdp_internal_err_code := ErrCode;
2074: sdp_internal_err_str := ErrStr;
2075: DBMS_LOB.freetemporary(l_TempLob);
2076:
2077: when others then
2078: x_progress := 'In XDP_PROC_CTL.Send Got Unhandeled Exception while sending ' || l_ActualStr || 'Error:' || SUBSTR(SQLERRM,1,400);
2079: ErrCode := -20400;

Line 2083: DBMS_LOB.freetemporary(l_TempLob);

2079: ErrCode := -20400;
2080: ErrStr := 'Unhandeled Exception in XDP_PROC_CTL.SEND. Error: ' || SUBSTR(x_progress,1,200);
2081: sdp_internal_err_code := ErrCode;
2082: sdp_internal_err_str := ErrStr;
2083: DBMS_LOB.freetemporary(l_TempLob);
2084:
2085: RAISE_APPLICATION_ERROR(-20400,x_progress);
2086: end SEND;
2087: