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.IEX_DUNNING_PVT dependencies on DBMS_XMLQUERY

Line 17819: ctx DBMS_XMLQUERY.ctxType;

17815: x_no_of_succ_rec OUT NOCOPY NUMBER,
17816: x_no_of_fail_rec OUT NOCOPY NUMBER)
17817: is
17818: l_api_version CONSTANT NUMBER := 1.0;
17819: ctx DBMS_XMLQUERY.ctxType;
17820: result CLOB;
17821: qryCtx DBMS_XMLGEN.ctxHandle;
17822: l_result CLOB;
17823: tempResult CLOB;

Line 17833: queryCtx DBMS_XMLquery.ctxType;

17829: l_xml_header varchar2(4000);
17830: l_xml_header_length number;
17831: l_errNo NUMBER;
17832: l_errMsg VARCHAR2(200);
17833: queryCtx DBMS_XMLquery.ctxType;
17834: l_xml_query VARCHAR2(32767);
17835: TYPE ref_cur IS REF CURSOR;
17836: l_xml_stmt ref_cur;
17837: l_rows_processed NUMBER;

Line 18023: ctx := DBMS_XMLQUERY.newContext(l_query_party);

18019: fetch c_calculate_no_rec into l_no_of_rec_prc, l_no_of_succ_rec, l_no_of_fail_rec;
18020: close c_calculate_no_rec;
18021:
18022: if p_running_level = 'PARTY' then
18023: ctx := DBMS_XMLQUERY.newContext(l_query_party);
18024: FND_FILE.put_line( FND_FILE.LOG,'l_query_party ==> ' || l_query_party);
18025: elsif p_running_level = 'ACCOUNT' then
18026: ctx := DBMS_XMLQUERY.newContext(l_query_account);
18027: FND_FILE.put_line( FND_FILE.LOG,'l_query_party ==> ' || l_query_account);

Line 18026: ctx := DBMS_XMLQUERY.newContext(l_query_account);

18022: if p_running_level = 'PARTY' then
18023: ctx := DBMS_XMLQUERY.newContext(l_query_party);
18024: FND_FILE.put_line( FND_FILE.LOG,'l_query_party ==> ' || l_query_party);
18025: elsif p_running_level = 'ACCOUNT' then
18026: ctx := DBMS_XMLQUERY.newContext(l_query_account);
18027: FND_FILE.put_line( FND_FILE.LOG,'l_query_party ==> ' || l_query_account);
18028: elsif p_running_level = 'BILL_TO' then
18029: ctx := DBMS_XMLQUERY.newContext(l_query_bill_to);
18030: FND_FILE.put_line( FND_FILE.LOG,'l_query_party ==> ' || l_query_bill_to);

Line 18029: ctx := DBMS_XMLQUERY.newContext(l_query_bill_to);

18025: elsif p_running_level = 'ACCOUNT' then
18026: ctx := DBMS_XMLQUERY.newContext(l_query_account);
18027: FND_FILE.put_line( FND_FILE.LOG,'l_query_party ==> ' || l_query_account);
18028: elsif p_running_level = 'BILL_TO' then
18029: ctx := DBMS_XMLQUERY.newContext(l_query_bill_to);
18030: FND_FILE.put_line( FND_FILE.LOG,'l_query_party ==> ' || l_query_bill_to);
18031: elsif p_running_level = 'DELINQUENCY' then
18032: ctx := DBMS_XMLQUERY.newContext(l_query_delinquency);
18033: FND_FILE.put_line( FND_FILE.LOG,'l_query_party ==> ' || l_query_delinquency);

Line 18032: ctx := DBMS_XMLQUERY.newContext(l_query_delinquency);

18028: elsif p_running_level = 'BILL_TO' then
18029: ctx := DBMS_XMLQUERY.newContext(l_query_bill_to);
18030: FND_FILE.put_line( FND_FILE.LOG,'l_query_party ==> ' || l_query_bill_to);
18031: elsif p_running_level = 'DELINQUENCY' then
18032: ctx := DBMS_XMLQUERY.newContext(l_query_delinquency);
18033: FND_FILE.put_line( FND_FILE.LOG,'l_query_party ==> ' || l_query_delinquency);
18034: else
18035: ctx := DBMS_XMLQUERY.newContext(l_query_party);
18036: FND_FILE.put_line( FND_FILE.LOG,'l_query_party ==> ' || l_query_party);

Line 18035: ctx := DBMS_XMLQUERY.newContext(l_query_party);

18031: elsif p_running_level = 'DELINQUENCY' then
18032: ctx := DBMS_XMLQUERY.newContext(l_query_delinquency);
18033: FND_FILE.put_line( FND_FILE.LOG,'l_query_party ==> ' || l_query_delinquency);
18034: else
18035: ctx := DBMS_XMLQUERY.newContext(l_query_party);
18036: FND_FILE.put_line( FND_FILE.LOG,'l_query_party ==> ' || l_query_party);
18037: end if;
18038:
18039: DBMS_XMLQuery.setRaiseNoRowsException(ctx,TRUE);

Line 18039: DBMS_XMLQuery.setRaiseNoRowsException(ctx,TRUE);

18035: ctx := DBMS_XMLQUERY.newContext(l_query_party);
18036: FND_FILE.put_line( FND_FILE.LOG,'l_query_party ==> ' || l_query_party);
18037: end if;
18038:
18039: DBMS_XMLQuery.setRaiseNoRowsException(ctx,TRUE);
18040: -- Bind Mandatory Variables
18041: DBMS_XMLQuery.setBindValue(ctx, 'l_request_id', l_req_id);
18042:
18043: --get the result

Line 18041: DBMS_XMLQuery.setBindValue(ctx, 'l_request_id', l_req_id);

18037: end if;
18038:
18039: DBMS_XMLQuery.setRaiseNoRowsException(ctx,TRUE);
18040: -- Bind Mandatory Variables
18041: DBMS_XMLQuery.setBindValue(ctx, 'l_request_id', l_req_id);
18042:
18043: --get the result
18044:
18045: BEGIN

Line 18046: l_result := DBMS_XMLQUERY.getXML(ctx);

18042:
18043: --get the result
18044:
18045: BEGIN
18046: l_result := DBMS_XMLQUERY.getXML(ctx);
18047: DBMS_XMLQuery.closeContext(ctx);
18048: l_rows_processed := 1;
18049: EXCEPTION
18050: WHEN OTHERS THEN

Line 18047: DBMS_XMLQuery.closeContext(ctx);

18043: --get the result
18044:
18045: BEGIN
18046: l_result := DBMS_XMLQUERY.getXML(ctx);
18047: DBMS_XMLQuery.closeContext(ctx);
18048: l_rows_processed := 1;
18049: EXCEPTION
18050: WHEN OTHERS THEN
18051: FND_FILE.put_line( FND_FILE.LOG,'In excepition, Error is: '||sqlerrm);

Line 18052: DBMS_XMLQuery.getExceptionContent(ctx,l_errNo,l_errMsg);

18048: l_rows_processed := 1;
18049: EXCEPTION
18050: WHEN OTHERS THEN
18051: FND_FILE.put_line( FND_FILE.LOG,'In excepition, Error is: '||sqlerrm);
18052: DBMS_XMLQuery.getExceptionContent(ctx,l_errNo,l_errMsg);
18053: IF l_errNo = 1403 THEN
18054: FND_FILE.put_line( FND_FILE.LOG,'Query not returned any rows');
18055: l_rows_processed := 0;
18056: END IF;

Line 18057: DBMS_XMLQuery.closeContext(ctx);

18053: IF l_errNo = 1403 THEN
18054: FND_FILE.put_line( FND_FILE.LOG,'Query not returned any rows');
18055: l_rows_processed := 0;
18056: END IF;
18057: DBMS_XMLQuery.closeContext(ctx);
18058: END;
18059:
18060: IF l_rows_processed <> 0 THEN
18061: l_resultOffset := DBMS_LOB.INSTR(l_result,'>');