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.IBY_PAYMENT_ADAPTER_PUB dependencies on DBMS_OUTPUT

Line 106: --dbms_output.put_line('unpack::local nls: ' || l_local_nls);

102:
103: -- do URL decoding if on the output values if possible
104: --
105:
106: --dbms_output.put_line('unpack::local nls: ' || l_local_nls);
107: --dbms_output.put_line('unpack::remote nls: ' || l_remote_nls);
108:
109: /*
110: IF ((l_remote_nls IS NOT NULL) AND (l_local_nls IS NOT NULL)) THEN

Line 107: --dbms_output.put_line('unpack::remote nls: ' || l_remote_nls);

103: -- do URL decoding if on the output values if possible
104: --
105:
106: --dbms_output.put_line('unpack::local nls: ' || l_local_nls);
107: --dbms_output.put_line('unpack::remote nls: ' || l_remote_nls);
108:
109: /*
110: IF ((l_remote_nls IS NOT NULL) AND (l_local_nls IS NOT NULL)) THEN
111: FOR i in 1..x_values.COUNT LOOP

Line 124: --dbms_output.put_line('error in unpacking procedure');

120: EXCEPTION
121: WHEN OTHERS THEN
122: /* Return a status of -1 to the calling API to indicate
123: errors in unpacking html body results. */
124: --dbms_output.put_line('error in unpacking procedure');
125: x_status := -1;
126: x_errcode := to_char(SQLCODE);
127: x_errmessage := SQLERRM;
128: END unpack_results_url;

Line 293: --dbms_output.put_line('---------------------');

289: PROCEDURE show_input_debug (p_string IN VARCHAR2) IS
290: j NUMBER := 0;
291: BEGIN
292: -- Use For Debugging
293: --dbms_output.put_line('---------------------');
294: --dbms_output.put_line('FINAL INPUT URL IS : ');
295: --dbms_output.put_line('---------------------');
296: j := 0;
297: WHILE ( j < (length(p_string) + 1) )

Line 294: --dbms_output.put_line('FINAL INPUT URL IS : ');

290: j NUMBER := 0;
291: BEGIN
292: -- Use For Debugging
293: --dbms_output.put_line('---------------------');
294: --dbms_output.put_line('FINAL INPUT URL IS : ');
295: --dbms_output.put_line('---------------------');
296: j := 0;
297: WHILE ( j < (length(p_string) + 1) )
298: LOOP

Line 295: --dbms_output.put_line('---------------------');

291: BEGIN
292: -- Use For Debugging
293: --dbms_output.put_line('---------------------');
294: --dbms_output.put_line('FINAL INPUT URL IS : ');
295: --dbms_output.put_line('---------------------');
296: j := 0;
297: WHILE ( j < (length(p_string) + 1) )
298: LOOP
299: --dbms_output.put(' ');

Line 299: --dbms_output.put(' ');

295: --dbms_output.put_line('---------------------');
296: j := 0;
297: WHILE ( j < (length(p_string) + 1) )
298: LOOP
299: --dbms_output.put(' ');
300: --dbms_output.put(substr(p_string,1+(90*j),90) );
301: --dbms_output.new_line;
302: j := j+1;
303: END LOOP;

Line 300: --dbms_output.put(substr(p_string,1+(90*j),90) );

296: j := 0;
297: WHILE ( j < (length(p_string) + 1) )
298: LOOP
299: --dbms_output.put(' ');
300: --dbms_output.put(substr(p_string,1+(90*j),90) );
301: --dbms_output.new_line;
302: j := j+1;
303: END LOOP;
304: --dbms_output.put_line('---------------------');

Line 301: --dbms_output.new_line;

297: WHILE ( j < (length(p_string) + 1) )
298: LOOP
299: --dbms_output.put(' ');
300: --dbms_output.put(substr(p_string,1+(90*j),90) );
301: --dbms_output.new_line;
302: j := j+1;
303: END LOOP;
304: --dbms_output.put_line('---------------------');
305:

Line 304: --dbms_output.put_line('---------------------');

300: --dbms_output.put(substr(p_string,1+(90*j),90) );
301: --dbms_output.new_line;
302: j := j+1;
303: END LOOP;
304: --dbms_output.put_line('---------------------');
305:
306: EXCEPTION
307: WHEN OTHERS THEN
308: --dbms_output.put_line('Error in displaying debug strings output: procedure show_input_debug');

Line 308: --dbms_output.put_line('Error in displaying debug strings output: procedure show_input_debug');

304: --dbms_output.put_line('---------------------');
305:
306: EXCEPTION
307: WHEN OTHERS THEN
308: --dbms_output.put_line('Error in displaying debug strings output: procedure show_input_debug');
309: NULL;
310: END show_input_debug;
311: --------------------------------------------------------------------------------------------
312: /* UTILITY PROCEDURE #5: SHOW_OUTPUT_DEBUG

Line 321: -- dbms_output.put_line('---------------------');

317: PROCEDURE show_output_debug (p_string IN VARCHAR2) IS
318: j NUMBER := 0;
319: BEGIN
320: -- Use For Debugging
321: -- dbms_output.put_line('---------------------');
322: -- dbms_output.put_line('HTML BODY RESPONSE STRING IS : ');
323: -- dbms_output.put_line('---------------------');
324: j := 0;
325: WHILE ( j < (length(p_string) + 1) )

Line 322: -- dbms_output.put_line('HTML BODY RESPONSE STRING IS : ');

318: j NUMBER := 0;
319: BEGIN
320: -- Use For Debugging
321: -- dbms_output.put_line('---------------------');
322: -- dbms_output.put_line('HTML BODY RESPONSE STRING IS : ');
323: -- dbms_output.put_line('---------------------');
324: j := 0;
325: WHILE ( j < (length(p_string) + 1) )
326: LOOP

Line 323: -- dbms_output.put_line('---------------------');

319: BEGIN
320: -- Use For Debugging
321: -- dbms_output.put_line('---------------------');
322: -- dbms_output.put_line('HTML BODY RESPONSE STRING IS : ');
323: -- dbms_output.put_line('---------------------');
324: j := 0;
325: WHILE ( j < (length(p_string) + 1) )
326: LOOP
327: -- dbms_output.put(' ');

Line 327: -- dbms_output.put(' ');

323: -- dbms_output.put_line('---------------------');
324: j := 0;
325: WHILE ( j < (length(p_string) + 1) )
326: LOOP
327: -- dbms_output.put(' ');
328: -- dbms_output.put(substr(p_string,1+(90*j),90) );
329: -- dbms_output.new_line;
330: j := j+1;
331: END LOOP;

Line 328: -- dbms_output.put(substr(p_string,1+(90*j),90) );

324: j := 0;
325: WHILE ( j < (length(p_string) + 1) )
326: LOOP
327: -- dbms_output.put(' ');
328: -- dbms_output.put(substr(p_string,1+(90*j),90) );
329: -- dbms_output.new_line;
330: j := j+1;
331: END LOOP;
332: -- dbms_output.put_line('---------------------');

Line 329: -- dbms_output.new_line;

325: WHILE ( j < (length(p_string) + 1) )
326: LOOP
327: -- dbms_output.put(' ');
328: -- dbms_output.put(substr(p_string,1+(90*j),90) );
329: -- dbms_output.new_line;
330: j := j+1;
331: END LOOP;
332: -- dbms_output.put_line('---------------------');
333:

Line 332: -- dbms_output.put_line('---------------------');

328: -- dbms_output.put(substr(p_string,1+(90*j),90) );
329: -- dbms_output.new_line;
330: j := j+1;
331: END LOOP;
332: -- dbms_output.put_line('---------------------');
333:
334: EXCEPTION
335: WHEN OTHERS THEN
336: --dbms_output.put_line('Error in displaying input URL output: Procedure show_output_debug');

Line 336: --dbms_output.put_line('Error in displaying input URL output: Procedure show_output_debug');

332: -- dbms_output.put_line('---------------------');
333:
334: EXCEPTION
335: WHEN OTHERS THEN
336: --dbms_output.put_line('Error in displaying input URL output: Procedure show_output_debug');
337: NULL;
338: END show_output_debug;
339: --------------------------------------------------------------------------------------------
340: /* UTILITY PROCEDURE #5: SHOW_OUTPUT_DEBUG

Line 350: --dbms_output.put_line('Table Count = '||to_char(p_table.COUNT) );

346: PROCEDURE show_table_debug (p_table IN v240_tbl_type) IS
347: i NUMBER := 0;
348: BEGIN
349: --Use For Debugging
350: --dbms_output.put_line('Table Count = '||to_char(p_table.COUNT) );
351: FOR i IN 1..p_table.COUNT
352: LOOP
353: --dbms_output.put(' ');
354: --dbms_output.put_line('Element.'||to_char(i)||' = '||p_table(i) );

Line 353: --dbms_output.put(' ');

349: --Use For Debugging
350: --dbms_output.put_line('Table Count = '||to_char(p_table.COUNT) );
351: FOR i IN 1..p_table.COUNT
352: LOOP
353: --dbms_output.put(' ');
354: --dbms_output.put_line('Element.'||to_char(i)||' = '||p_table(i) );
355: NULL;
356: END LOOP;
357: --dbms_output.put_line('---------------------');

Line 354: --dbms_output.put_line('Element.'||to_char(i)||' = '||p_table(i) );

350: --dbms_output.put_line('Table Count = '||to_char(p_table.COUNT) );
351: FOR i IN 1..p_table.COUNT
352: LOOP
353: --dbms_output.put(' ');
354: --dbms_output.put_line('Element.'||to_char(i)||' = '||p_table(i) );
355: NULL;
356: END LOOP;
357: --dbms_output.put_line('---------------------');
358: EXCEPTION

Line 357: --dbms_output.put_line('---------------------');

353: --dbms_output.put(' ');
354: --dbms_output.put_line('Element.'||to_char(i)||' = '||p_table(i) );
355: NULL;
356: END LOOP;
357: --dbms_output.put_line('---------------------');
358: EXCEPTION
359: WHEN OTHERS THEN
360: --dbms_output.put_line('Error in displaying table output: Procedure show_table_debug');
361: NULL;

Line 360: --dbms_output.put_line('Error in displaying table output: Procedure show_table_debug');

356: END LOOP;
357: --dbms_output.put_line('---------------------');
358: EXCEPTION
359: WHEN OTHERS THEN
360: --dbms_output.put_line('Error in displaying table output: Procedure show_table_debug');
361: NULL;
362: END show_table_debug;
363: --------------------------------------------------------------------------------------------
364: /* UTILITY FUNCTION #1: IS_RISKINFO_REC_MISSING

Line 466: --dbms_output.put_line('x_return_status = '|| x_return_status);

462: module => G_DEBUG_MODULE || '.get_baseurl');
463:
464: iby_utility_pvt.get_property(iby_payment_adapter_pub.C_ECAPP_URL_PROP_NAME,x_baseurl);
465:
466: --dbms_output.put_line('x_return_status = '|| x_return_status);
467: --Raising Exception to handle errors if value is missing
468: IF ((x_baseurl IS NULL) OR (trim(x_baseurl) = '')) THEN
469: FND_MESSAGE.SET_NAME('IBY', 'IBY_204406');
470: FND_MSG_PUB.Add;

Line 618: --dbms_output.put_line('Input url = '|| x_url);

614: iby_debug_pub.add(debug_msg => 'Exit',
615: debug_level => FND_LOG.LEVEL_PROCEDURE,
616: module => G_DEBUG_MODULE || '.send_request');
617:
618: --dbms_output.put_line('Input url = '|| x_url);
619:
620: EXCEPTION
621: WHEN UTL_HTTP.REQUEST_FAILED THEN
622:

Line 755: -- dbms_output.put_line('l_get_baseurl= ' || l_get_baseurl);

751:
752: -- START OF BODY OF API
753:
754: get_baseurl(l_get_baseurl);
755: -- dbms_output.put_line('l_get_baseurl= ' || l_get_baseurl);
756: -- dbms_output.put_line('l_status_url= ' || l_status_url);
757: -- dbms_output.put_line('l_msg_count_url= ' || l_msg_count_url);
758: -- dbms_output.put_line('l_msg_data_url= ' || l_msg_data_url);
759:

Line 756: -- dbms_output.put_line('l_status_url= ' || l_status_url);

752: -- START OF BODY OF API
753:
754: get_baseurl(l_get_baseurl);
755: -- dbms_output.put_line('l_get_baseurl= ' || l_get_baseurl);
756: -- dbms_output.put_line('l_status_url= ' || l_status_url);
757: -- dbms_output.put_line('l_msg_count_url= ' || l_msg_count_url);
758: -- dbms_output.put_line('l_msg_data_url= ' || l_msg_data_url);
759:
760: -- Construct the full URL to send to the ECServlet.

Line 757: -- dbms_output.put_line('l_msg_count_url= ' || l_msg_count_url);

753:
754: get_baseurl(l_get_baseurl);
755: -- dbms_output.put_line('l_get_baseurl= ' || l_get_baseurl);
756: -- dbms_output.put_line('l_status_url= ' || l_status_url);
757: -- dbms_output.put_line('l_msg_count_url= ' || l_msg_count_url);
758: -- dbms_output.put_line('l_msg_data_url= ' || l_msg_data_url);
759:
760: -- Construct the full URL to send to the ECServlet.
761: l_url := l_get_baseurl;

Line 758: -- dbms_output.put_line('l_msg_data_url= ' || l_msg_data_url);

754: get_baseurl(l_get_baseurl);
755: -- dbms_output.put_line('l_get_baseurl= ' || l_get_baseurl);
756: -- dbms_output.put_line('l_status_url= ' || l_status_url);
757: -- dbms_output.put_line('l_msg_count_url= ' || l_msg_count_url);
758: -- dbms_output.put_line('l_msg_data_url= ' || l_msg_data_url);
759:
760: -- Construct the full URL to send to the ECServlet.
761: l_url := l_get_baseurl;
762:

Line 766: -- dbms_output.put_line('db NLS val is: ' || l_db_nls);

762:
763: l_db_nls := iby_utility_pvt.get_local_nls();
764: l_ecapp_nls := p_pmtreqtrxn_rec.NLS_LANG;
765:
766: -- dbms_output.put_line('db NLS val is: ' || l_db_nls);
767: -- dbms_output.put_line('ecapp NLS val is: ' || l_ecapp_nls);
768:
769: --MANDATORY INPUT PARAMETERS
770: check_mandatory('OapfAction', l_oapf_action, l_url, l_db_nls, l_ecapp_nls);

Line 767: -- dbms_output.put_line('ecapp NLS val is: ' || l_ecapp_nls);

763: l_db_nls := iby_utility_pvt.get_local_nls();
764: l_ecapp_nls := p_pmtreqtrxn_rec.NLS_LANG;
765:
766: -- dbms_output.put_line('db NLS val is: ' || l_db_nls);
767: -- dbms_output.put_line('ecapp NLS val is: ' || l_ecapp_nls);
768:
769: --MANDATORY INPUT PARAMETERS
770: check_mandatory('OapfAction', l_oapf_action, l_url, l_db_nls, l_ecapp_nls);
771: check_mandatory('OapfECAppId', to_char(p_ecapp_id), l_url, l_db_nls, l_ecapp_nls);

Line 949: --dbms_output.put_line('send request ');

945: --show_input_debug(l_url);
946:
947: -- Send http request to the payment server
948: --l_html := UTL_HTTP.REQUEST(l_url);
949: --dbms_output.put_line('send request ');
950: --dbms_output.put_line('l_url is:'||substr(l_url,1, 50));
951:
952: -- dbms_output.put_line('l_html is:'||substr(l_html, 1, 50));
953: SEND_REQUEST(l_url, l_html);

Line 950: --dbms_output.put_line('l_url is:'||substr(l_url,1, 50));

946:
947: -- Send http request to the payment server
948: --l_html := UTL_HTTP.REQUEST(l_url);
949: --dbms_output.put_line('send request ');
950: --dbms_output.put_line('l_url is:'||substr(l_url,1, 50));
951:
952: -- dbms_output.put_line('l_html is:'||substr(l_html, 1, 50));
953: SEND_REQUEST(l_url, l_html);
954: -- show_output_debug(l_html);

Line 952: -- dbms_output.put_line('l_html is:'||substr(l_html, 1, 50));

948: --l_html := UTL_HTTP.REQUEST(l_url);
949: --dbms_output.put_line('send request ');
950: --dbms_output.put_line('l_url is:'||substr(l_url,1, 50));
951:
952: -- dbms_output.put_line('l_html is:'||substr(l_html, 1, 50));
953: SEND_REQUEST(l_url, l_html);
954: -- show_output_debug(l_html);
955:
956: -- Unpack the results

Line 1101: --dbms_output.put_line('after successfully mapping results');

1097:
1098: -- END OF BODY OF API
1099:
1100: -- Use for Debugging
1101: --dbms_output.put_line('after successfully mapping results');
1102:
1103: -- Standard check of p_commit.
1104: /*
1105: IF FND_API.To_Boolean( p_commit ) THEN

Line 1230: --dbms_output.put_line(l_dbg_mod||': Enter');

1226: l_instrid VARCHAR2(30);
1227: l_pmtinstr_type iby_trxn_summaries_all.instrtype%TYPE;
1228:
1229: BEGIN
1230: --dbms_output.put_line(l_dbg_mod||': Enter');
1231: iby_debug_pub.add('Enter', FND_LOG.LEVEL_PROCEDURE,l_dbg_mod);
1232: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1233: p_api_version,
1234: l_api_name,

Line 1260: --dbms_output.put_line(l_dbg_mod||': l_get_baseurl = '|| l_get_baseurl);

1256:
1257: -- START OF BODY OF API
1258:
1259: get_baseurl(l_get_baseurl);
1260: --dbms_output.put_line(l_dbg_mod||': l_get_baseurl = '|| l_get_baseurl);
1261: -- Construct the full URL to send to the ECServlet.
1262: l_url := l_get_baseurl;
1263:
1264: l_db_nls := iby_utility_pvt.get_local_nls();

Line 1293: --dbms_output.put_line(l_dbg_mod||': l_url = '|| l_url);

1289: check_optional('OapfNlsLang', p_rev_trxn_rec.NLS_LANG, l_url, l_db_nls, l_ecapp_nls);
1290:
1291: -- Remove ampersand from the last input parameter.
1292: l_url := RTRIM(l_url,'&');
1293: --dbms_output.put_line(l_dbg_mod||': l_url = '|| l_url);
1294: SEND_REQUEST(l_url, l_html);
1295: UNPACK_RESULTS_URL(l_html,l_names,l_values, l_status, l_errcode, l_errmessage);
1296:
1297: --Raising Exception to handle errors in unpacking resulting html file.

Line 1832: --dbms_output.put_line('Before opening cursor');

1828:
1829: --Optional Input Parameters
1830: check_optional('OapfNlsLang', p_canctrxn_rec.NLS_LANG, l_url, l_db_nls, l_ecapp_nls);
1831:
1832: --dbms_output.put_line('Before opening cursor');
1833:
1834: --NOTE*: Query DB to get the PmtInstrType from TransactionID
1835: --to pass to ECServlet.
1836: OPEN pmtcanc_csr;

Line 1847: --dbms_output.put_line('after closing cursor');

1843: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1844: END IF;
1845:
1846: CLOSE pmtcanc_csr;
1847: --dbms_output.put_line('after closing cursor');
1848:
1849: check_mandatory('OapfPmtInstrType', l_pmtinstr_type, l_url, l_db_nls, l_ecapp_nls);
1850:
1851: -- Remove ampersand from the last input parameter.

Line 2084: --dbms_output.put_line('Before opening cursor');

2080:
2081: --For this API Mode has to be ONLINE only.
2082: check_mandatory('OapfMode', 'ONLINE', l_url, l_db_nls, l_ecapp_nls);
2083:
2084: --dbms_output.put_line('Before opening cursor');
2085:
2086: --NOTE*: Query DB to get the PmtInstrType from TransactionID
2087: --to pass to ECServlet.
2088:

Line 2100: --dbms_output.put_line('after closing cursor');

2096: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2097: END IF;
2098:
2099: CLOSE pmtqrytrxn_csr;
2100: --dbms_output.put_line('after closing cursor');
2101: --dbms_output.put_line('l_pmtinstrtyp = '|| l_pmtinstr_type);
2102:
2103: check_mandatory('OapfPmtInstrType', l_pmtinstr_type, l_url, l_db_nls, l_ecapp_nls);
2104:

Line 2101: --dbms_output.put_line('l_pmtinstrtyp = '|| l_pmtinstr_type);

2097: END IF;
2098:
2099: CLOSE pmtqrytrxn_csr;
2100: --dbms_output.put_line('after closing cursor');
2101: --dbms_output.put_line('l_pmtinstrtyp = '|| l_pmtinstr_type);
2102:
2103: check_mandatory('OapfPmtInstrType', l_pmtinstr_type, l_url, l_db_nls, l_ecapp_nls);
2104:
2105: --Optional Input Parameters

Line 2405: --dbms_output.put_line(l_url);

2401: -- ^^^ Replace blank characters with + sign. ^^^
2402: --l_url := REPLACE(l_url,' ','+');
2403:
2404: --show_input_debug(l_url);
2405: --dbms_output.put_line(l_url);
2406: -- Send HTTP request to ipayment servlet
2407: --l_html := UTL_HTTP.REQUEST(l_url);
2408: SEND_REQUEST(l_url, l_html);
2409:

Line 2410: --dbms_output.put_line(l_html);

2406: -- Send HTTP request to ipayment servlet
2407: --l_html := UTL_HTTP.REQUEST(l_url);
2408: SEND_REQUEST(l_url, l_html);
2409:
2410: --dbms_output.put_line(l_html);
2411:
2412: --show_output_debug(l_html);
2413:
2414: -- Parse the resulting HTML page body

Line 2899: --dbms_output.put_line('before utl_http call');

2895: --
2896: -- ^^^ Replace blank characters with + sign. ^^^
2897: -- l_url := REPLACE(l_url,' ','+');
2898:
2899: --dbms_output.put_line('before utl_http call');
2900: --show_input_debug(l_url);
2901:
2902: -- Send HTTP request to ipayment servlet
2903: -- l_html := UTL_HTTP.REQUEST(l_url);

Line 2906: --dbms_output.put_line('after utl_http call');

2902: -- Send HTTP request to ipayment servlet
2903: -- l_html := UTL_HTTP.REQUEST(l_url);
2904: SEND_REQUEST(l_url, l_html);
2905:
2906: --dbms_output.put_line('after utl_http call');
2907: --show_output_debug(l_html);
2908:
2909: -- Parse the resulting HTML page
2910: UNPACK_RESULTS_URL(l_html,l_names,l_values, l_status, l_errcode, l_errmessage);

Line 2929: --dbms_output.put_line('after successful unpacking');

2925: FND_MSG_PUB.Add;
2926: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2927: END IF;
2928:
2929: --dbms_output.put_line('after successful unpacking');
2930:
2931: -- Assign output parameters to output record x_retresp_rec
2932: FOR i IN 1..l_names.COUNT LOOP
2933:

Line 3425: --dbms_output.put_line('Before opening cursor');

3421: x_return_status := FND_API.G_RET_STS_SUCCESS;
3422:
3423: -- START OF BODY OF API
3424:
3425: --dbms_output.put_line('Before opening cursor');
3426:
3427: OPEN pmtinq_csr;
3428: FETCH pmtinq_csr
3429: INTO x_inqresp_rec.Payee.Payee_ID,

Line 3451: --dbms_output.put_line('after closing cursor');

3447: END IF;
3448:
3449: CLOSE pmtinq_csr;
3450:
3451: --dbms_output.put_line('after closing cursor');
3452:
3453: x_inqresp_rec.Response.Status := 0;
3454: -- END OF BODY OF API
3455:

Line 3649: --dbms_output.put_line('before utl_http call');

3645: --
3646: -- ^^^^ Replace blank characters with + sign. ^^^
3647: -- l_url := REPLACE(l_url,' ','+');
3648:
3649: --dbms_output.put_line('before utl_http call');
3650: --show_input_debug(l_url);
3651:
3652: -- Send http request to the payment server.
3653: -- l_html := UTL_HTTP.REQUEST(l_url);

Line 3656: --dbms_output.put_line('after utl_http call');

3652: -- Send http request to the payment server.
3653: -- l_html := UTL_HTTP.REQUEST(l_url);
3654: SEND_REQUEST(l_url, l_html);
3655:
3656: --dbms_output.put_line('after utl_http call');
3657: --show_output_debug(l_html);
3658:
3659: -- Unpack the results
3660: UNPACK_RESULTS_URL(l_html,l_names,l_values, l_status, l_errcode, l_errmessage);

Line 4810: --dbms_output.put_line('l_post_info = ' || l_post_info);

4806:
4807: --remove the port number from the URL
4808: l_post_info := SUBSTR(l_url,l_position);
4809: l_post_info := 'POST ' || l_post_info || ' HTTP/1.0';
4810: --dbms_output.put_line('l_post_info = ' || l_post_info);
4811:
4812: iby_debug_pub.add('l_host = ' || l_host,
4813: FND_LOG.LEVEL_STATEMENT,
4814: G_DEBUG_MODULE || '.OraCCBatchCapture');

Line 4908: --dbms_output.put_line('l_html body = ' || substr(l_html,1,200));

4904: -- read result
4905: l_html := substr(utl_tcp.get_line(l_conn,TRUE),1,3000);
4906: l_position := instr(l_html,'');
4907:
4908: --dbms_output.put_line('l_html body = ' || substr(l_html,1,200));
4909:
4910: --we only want the html body here
4911: IF ((l_position > 0) OR (l_http_body)) THEN
4912:

Line 5164: dbms_output.put_line('l_get_baseurl= ' || l_get_baseurl);

5160:
5161: -- START OF BODY OF API
5162:
5163: get_baseurl(l_get_baseurl);
5164: dbms_output.put_line('l_get_baseurl= ' || l_get_baseurl);
5165: --test_debug('OraSecureExtension=> l_get_baseurl= '|| l_get_baseurl);
5166: -- dbms_output.put_line('l_status_url= ' || l_status_url);
5167: -- dbms_output.put_line('l_msg_count_url= ' || l_msg_count_url);
5168: -- dbms_output.put_line('l_msg_data_url= ' || l_msg_data_url);

Line 5166: -- dbms_output.put_line('l_status_url= ' || l_status_url);

5162:
5163: get_baseurl(l_get_baseurl);
5164: dbms_output.put_line('l_get_baseurl= ' || l_get_baseurl);
5165: --test_debug('OraSecureExtension=> l_get_baseurl= '|| l_get_baseurl);
5166: -- dbms_output.put_line('l_status_url= ' || l_status_url);
5167: -- dbms_output.put_line('l_msg_count_url= ' || l_msg_count_url);
5168: -- dbms_output.put_line('l_msg_data_url= ' || l_msg_data_url);
5169:
5170: -- Construct the full URL to send to the ECServlet.

Line 5167: -- dbms_output.put_line('l_msg_count_url= ' || l_msg_count_url);

5163: get_baseurl(l_get_baseurl);
5164: dbms_output.put_line('l_get_baseurl= ' || l_get_baseurl);
5165: --test_debug('OraSecureExtension=> l_get_baseurl= '|| l_get_baseurl);
5166: -- dbms_output.put_line('l_status_url= ' || l_status_url);
5167: -- dbms_output.put_line('l_msg_count_url= ' || l_msg_count_url);
5168: -- dbms_output.put_line('l_msg_data_url= ' || l_msg_data_url);
5169:
5170: -- Construct the full URL to send to the ECServlet.
5171: l_url := l_get_baseurl;

Line 5168: -- dbms_output.put_line('l_msg_data_url= ' || l_msg_data_url);

5164: dbms_output.put_line('l_get_baseurl= ' || l_get_baseurl);
5165: --test_debug('OraSecureExtension=> l_get_baseurl= '|| l_get_baseurl);
5166: -- dbms_output.put_line('l_status_url= ' || l_status_url);
5167: -- dbms_output.put_line('l_msg_count_url= ' || l_msg_count_url);
5168: -- dbms_output.put_line('l_msg_data_url= ' || l_msg_data_url);
5169:
5170: -- Construct the full URL to send to the ECServlet.
5171: l_url := l_get_baseurl;
5172:

Line 5176: -- dbms_output.put_line('db NLS val is: ' || l_db_nls);

5172:
5173: --l_db_nls := iby_utility_pvt.get_local_nls();
5174: --l_ecapp_nls := p_pmtreqtrxn_rec.NLS_LANG;
5175:
5176: -- dbms_output.put_line('db NLS val is: ' || l_db_nls);
5177: -- dbms_output.put_line('ecapp NLS val is: ' || l_ecapp_nls);
5178:
5179: --MANDATORY INPUT PARAMETERS
5180: check_mandatory('OapfAction', l_oapf_action, l_url, null, null);

Line 5177: -- dbms_output.put_line('ecapp NLS val is: ' || l_ecapp_nls);

5173: --l_db_nls := iby_utility_pvt.get_local_nls();
5174: --l_ecapp_nls := p_pmtreqtrxn_rec.NLS_LANG;
5175:
5176: -- dbms_output.put_line('db NLS val is: ' || l_db_nls);
5177: -- dbms_output.put_line('ecapp NLS val is: ' || l_ecapp_nls);
5178:
5179: --MANDATORY INPUT PARAMETERS
5180: check_mandatory('OapfAction', l_oapf_action, l_url, null, null);
5181: check_mandatory('OapfSecCode', p_cvv, l_url, null, null);

Line 5186: --dbms_output.put_line('send request ');

5182:
5183:
5184: -- Remove ampersand from the last input parameter.
5185: l_url := RTRIM(l_url,'&');
5186: --dbms_output.put_line('send request ');
5187: --test_debug('OraSecureExtension=> send request ');
5188: --dbms_output.put_line('l_url is:'||substr(l_url,1, 50));
5189: --test_debug('OraSecureExtension=> l_url is: '|| substr(l_url,1, 150));
5190:

Line 5188: --dbms_output.put_line('l_url is:'||substr(l_url,1, 50));

5184: -- Remove ampersand from the last input parameter.
5185: l_url := RTRIM(l_url,'&');
5186: --dbms_output.put_line('send request ');
5187: --test_debug('OraSecureExtension=> send request ');
5188: --dbms_output.put_line('l_url is:'||substr(l_url,1, 50));
5189: --test_debug('OraSecureExtension=> l_url is: '|| substr(l_url,1, 150));
5190:
5191: --dbms_output.put_line('l_html is:'||substr(l_html, 1, 50));
5192: --test_debug('OraSecureExtension=> l_html is: '|| substr(l_html, 1, 100));

Line 5191: --dbms_output.put_line('l_html is:'||substr(l_html, 1, 50));

5187: --test_debug('OraSecureExtension=> send request ');
5188: --dbms_output.put_line('l_url is:'||substr(l_url,1, 50));
5189: --test_debug('OraSecureExtension=> l_url is: '|| substr(l_url,1, 150));
5190:
5191: --dbms_output.put_line('l_html is:'||substr(l_html, 1, 50));
5192: --test_debug('OraSecureExtension=> l_html is: '|| substr(l_html, 1, 100));
5193: SEND_REQUEST(l_url, l_html);
5194: -- show_output_debug(l_html);
5195:

Line 5265: --dbms_output.put_line('after successfully mapping results');

5261:
5262: END LOOP;
5263:
5264: -- Use for Debugging
5265: --dbms_output.put_line('after successfully mapping results');
5266:
5267: -- Standard check of p_commit.
5268: /*
5269: IF FND_API.To_Boolean( p_commit ) THEN