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 102: --dbms_output.put_line('unpack::local nls: ' || l_local_nls);

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

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

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

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

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

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

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

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

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

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

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

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

291: --dbms_output.put_line('---------------------');
292: j := 0;
293: WHILE ( j < (length(p_string) + 1) )
294: LOOP
295: --dbms_output.put(' ');
296: --dbms_output.put(substr(p_string,1+(90*j),90) );
297: --dbms_output.new_line;
298: j := j+1;
299: END LOOP;

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

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

Line 297: --dbms_output.new_line;

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

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

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

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

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

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

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

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

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

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

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

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

319: -- dbms_output.put_line('---------------------');
320: j := 0;
321: WHILE ( j < (length(p_string) + 1) )
322: LOOP
323: -- dbms_output.put(' ');
324: -- dbms_output.put(substr(p_string,1+(90*j),90) );
325: -- dbms_output.new_line;
326: j := j+1;
327: END LOOP;

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

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

Line 325: -- dbms_output.new_line;

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

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

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

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

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

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

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

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

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

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

346: --dbms_output.put_line('Table Count = '||to_char(p_table.COUNT) );
347: FOR i IN 1..p_table.COUNT
348: LOOP
349: --dbms_output.put(' ');
350: --dbms_output.put_line('Element.'||to_char(i)||' = '||p_table(i) );
351: NULL;
352: END LOOP;
353: --dbms_output.put_line('---------------------');
354: EXCEPTION

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

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

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

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

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

428: module => G_DEBUG_MODULE || '.get_baseurl');
429:
430: iby_utility_pvt.get_property(iby_payment_adapter_pub.C_ECAPP_URL_PROP_NAME,x_baseurl);
431:
432: --dbms_output.put_line('x_return_status = '|| x_return_status);
433: --Raising Exception to handle errors if value is missing
434: IF ((x_baseurl IS NULL) OR (trim(x_baseurl) = '')) THEN
435: FND_MESSAGE.SET_NAME('IBY', 'IBY_204406');
436: FND_MSG_PUB.Add;

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

580: iby_debug_pub.add(debug_msg => 'Exit',
581: debug_level => FND_LOG.LEVEL_PROCEDURE,
582: module => G_DEBUG_MODULE || '.send_request');
583:
584: --dbms_output.put_line('Input url = '|| x_url);
585:
586: EXCEPTION
587: WHEN UTL_HTTP.REQUEST_FAILED THEN
588:

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

715:
716: -- START OF BODY OF API
717:
718: get_baseurl(l_get_baseurl);
719: -- dbms_output.put_line('l_get_baseurl= ' || l_get_baseurl);
720: -- dbms_output.put_line('l_status_url= ' || l_status_url);
721: -- dbms_output.put_line('l_msg_count_url= ' || l_msg_count_url);
722: -- dbms_output.put_line('l_msg_data_url= ' || l_msg_data_url);
723:

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

716: -- START OF BODY OF API
717:
718: get_baseurl(l_get_baseurl);
719: -- dbms_output.put_line('l_get_baseurl= ' || l_get_baseurl);
720: -- dbms_output.put_line('l_status_url= ' || l_status_url);
721: -- dbms_output.put_line('l_msg_count_url= ' || l_msg_count_url);
722: -- dbms_output.put_line('l_msg_data_url= ' || l_msg_data_url);
723:
724: -- Construct the full URL to send to the ECServlet.

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

717:
718: get_baseurl(l_get_baseurl);
719: -- dbms_output.put_line('l_get_baseurl= ' || l_get_baseurl);
720: -- dbms_output.put_line('l_status_url= ' || l_status_url);
721: -- dbms_output.put_line('l_msg_count_url= ' || l_msg_count_url);
722: -- dbms_output.put_line('l_msg_data_url= ' || l_msg_data_url);
723:
724: -- Construct the full URL to send to the ECServlet.
725: l_url := l_get_baseurl;

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

718: get_baseurl(l_get_baseurl);
719: -- dbms_output.put_line('l_get_baseurl= ' || l_get_baseurl);
720: -- dbms_output.put_line('l_status_url= ' || l_status_url);
721: -- dbms_output.put_line('l_msg_count_url= ' || l_msg_count_url);
722: -- dbms_output.put_line('l_msg_data_url= ' || l_msg_data_url);
723:
724: -- Construct the full URL to send to the ECServlet.
725: l_url := l_get_baseurl;
726:

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

726:
727: l_db_nls := iby_utility_pvt.get_local_nls();
728: l_ecapp_nls := p_pmtreqtrxn_rec.NLS_LANG;
729:
730: -- dbms_output.put_line('db NLS val is: ' || l_db_nls);
731: -- dbms_output.put_line('ecapp NLS val is: ' || l_ecapp_nls);
732:
733: --MANDATORY INPUT PARAMETERS
734: check_mandatory('OapfAction', l_oapf_action, l_url, l_db_nls, l_ecapp_nls);

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

727: l_db_nls := iby_utility_pvt.get_local_nls();
728: l_ecapp_nls := p_pmtreqtrxn_rec.NLS_LANG;
729:
730: -- dbms_output.put_line('db NLS val is: ' || l_db_nls);
731: -- dbms_output.put_line('ecapp NLS val is: ' || l_ecapp_nls);
732:
733: --MANDATORY INPUT PARAMETERS
734: check_mandatory('OapfAction', l_oapf_action, l_url, l_db_nls, l_ecapp_nls);
735: check_mandatory('OapfECAppId', to_char(p_ecapp_id), l_url, l_db_nls, l_ecapp_nls);

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

890: --show_input_debug(l_url);
891:
892: -- Send http request to the payment server
893: --l_html := UTL_HTTP.REQUEST(l_url);
894: --dbms_output.put_line('send request ');
895: --dbms_output.put_line('l_url is:'||substr(l_url,1, 50));
896:
897: -- dbms_output.put_line('l_html is:'||substr(l_html, 1, 50));
898: SEND_REQUEST(l_url, l_html);

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

891:
892: -- Send http request to the payment server
893: --l_html := UTL_HTTP.REQUEST(l_url);
894: --dbms_output.put_line('send request ');
895: --dbms_output.put_line('l_url is:'||substr(l_url,1, 50));
896:
897: -- dbms_output.put_line('l_html is:'||substr(l_html, 1, 50));
898: SEND_REQUEST(l_url, l_html);
899: -- show_output_debug(l_html);

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

893: --l_html := UTL_HTTP.REQUEST(l_url);
894: --dbms_output.put_line('send request ');
895: --dbms_output.put_line('l_url is:'||substr(l_url,1, 50));
896:
897: -- dbms_output.put_line('l_html is:'||substr(l_html, 1, 50));
898: SEND_REQUEST(l_url, l_html);
899: -- show_output_debug(l_html);
900:
901: -- Unpack the results

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

1042:
1043: -- END OF BODY OF API
1044:
1045: -- Use for Debugging
1046: --dbms_output.put_line('after successfully mapping results');
1047:
1048: -- Standard check of p_commit.
1049: /*
1050: IF FND_API.To_Boolean( p_commit ) THEN

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

1509:
1510: --Optional Input Parameters
1511: check_optional('OapfNlsLang', p_canctrxn_rec.NLS_LANG, l_url, l_db_nls, l_ecapp_nls);
1512:
1513: --dbms_output.put_line('Before opening cursor');
1514:
1515: --NOTE*: Query DB to get the PmtInstrType from TransactionID
1516: --to pass to ECServlet.
1517: OPEN pmtcanc_csr;

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

1524: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1525: END IF;
1526:
1527: CLOSE pmtcanc_csr;
1528: --dbms_output.put_line('after closing cursor');
1529:
1530: check_mandatory('OapfPmtInstrType', l_pmtinstr_type, l_url, l_db_nls, l_ecapp_nls);
1531:
1532: -- Remove ampersand from the last input parameter.

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

1761:
1762: --For this API Mode has to be ONLINE only.
1763: check_mandatory('OapfMode', 'ONLINE', l_url, l_db_nls, l_ecapp_nls);
1764:
1765: --dbms_output.put_line('Before opening cursor');
1766:
1767: --NOTE*: Query DB to get the PmtInstrType from TransactionID
1768: --to pass to ECServlet.
1769:

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

1777: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1778: END IF;
1779:
1780: CLOSE pmtqrytrxn_csr;
1781: --dbms_output.put_line('after closing cursor');
1782: --dbms_output.put_line('l_pmtinstrtyp = '|| l_pmtinstr_type);
1783:
1784: check_mandatory('OapfPmtInstrType', l_pmtinstr_type, l_url, l_db_nls, l_ecapp_nls);
1785:

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

1778: END IF;
1779:
1780: CLOSE pmtqrytrxn_csr;
1781: --dbms_output.put_line('after closing cursor');
1782: --dbms_output.put_line('l_pmtinstrtyp = '|| l_pmtinstr_type);
1783:
1784: check_mandatory('OapfPmtInstrType', l_pmtinstr_type, l_url, l_db_nls, l_ecapp_nls);
1785:
1786: --Optional Input Parameters

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

2082: -- ^^^ Replace blank characters with + sign. ^^^
2083: --l_url := REPLACE(l_url,' ','+');
2084:
2085: --show_input_debug(l_url);
2086: --dbms_output.put_line(l_url);
2087: -- Send HTTP request to ipayment servlet
2088: --l_html := UTL_HTTP.REQUEST(l_url);
2089: SEND_REQUEST(l_url, l_html);
2090:

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

2087: -- Send HTTP request to ipayment servlet
2088: --l_html := UTL_HTTP.REQUEST(l_url);
2089: SEND_REQUEST(l_url, l_html);
2090:
2091: --dbms_output.put_line(l_html);
2092:
2093: --show_output_debug(l_html);
2094:
2095: -- Parse the resulting HTML page body

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

2576: --
2577: -- ^^^ Replace blank characters with + sign. ^^^
2578: -- l_url := REPLACE(l_url,' ','+');
2579:
2580: --dbms_output.put_line('before utl_http call');
2581: --show_input_debug(l_url);
2582:
2583: -- Send HTTP request to ipayment servlet
2584: -- l_html := UTL_HTTP.REQUEST(l_url);

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

2583: -- Send HTTP request to ipayment servlet
2584: -- l_html := UTL_HTTP.REQUEST(l_url);
2585: SEND_REQUEST(l_url, l_html);
2586:
2587: --dbms_output.put_line('after utl_http call');
2588: --show_output_debug(l_html);
2589:
2590: -- Parse the resulting HTML page
2591: UNPACK_RESULTS_URL(l_html,l_names,l_values, l_status, l_errcode, l_errmessage);

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

2606: FND_MSG_PUB.Add;
2607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2608: END IF;
2609:
2610: --dbms_output.put_line('after successful unpacking');
2611:
2612: -- Assign output parameters to output record x_retresp_rec
2613: FOR i IN 1..l_names.COUNT LOOP
2614:

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

3100: x_return_status := FND_API.G_RET_STS_SUCCESS;
3101:
3102: -- START OF BODY OF API
3103:
3104: --dbms_output.put_line('Before opening cursor');
3105:
3106: OPEN pmtinq_csr;
3107: FETCH pmtinq_csr
3108: INTO x_inqresp_rec.Payee.Payee_ID,

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

3126: END IF;
3127:
3128: CLOSE pmtinq_csr;
3129:
3130: --dbms_output.put_line('after closing cursor');
3131:
3132: x_inqresp_rec.Response.Status := 0;
3133: -- END OF BODY OF API
3134:

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

3324: --
3325: -- ^^^^ Replace blank characters with + sign. ^^^
3326: -- l_url := REPLACE(l_url,' ','+');
3327:
3328: --dbms_output.put_line('before utl_http call');
3329: --show_input_debug(l_url);
3330:
3331: -- Send http request to the payment server.
3332: -- l_html := UTL_HTTP.REQUEST(l_url);

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

3331: -- Send http request to the payment server.
3332: -- l_html := UTL_HTTP.REQUEST(l_url);
3333: SEND_REQUEST(l_url, l_html);
3334:
3335: --dbms_output.put_line('after utl_http call');
3336: --show_output_debug(l_html);
3337:
3338: -- Unpack the results
3339: UNPACK_RESULTS_URL(l_html,l_names,l_values, l_status, l_errcode, l_errmessage);

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

4485:
4486: --remove the port number from the URL
4487: l_post_info := SUBSTR(l_url,l_position);
4488: l_post_info := 'POST ' || l_post_info || ' HTTP/1.0';
4489: --dbms_output.put_line('l_post_info = ' || l_post_info);
4490:
4491: iby_debug_pub.add('l_host = ' || l_host,
4492: FND_LOG.LEVEL_STATEMENT,
4493: G_DEBUG_MODULE || '.OraCCBatchCapture');

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

4583: -- read result
4584: l_html := substr(utl_tcp.get_line(l_conn,TRUE),1,3000);
4585: l_position := instr(l_html,'');
4586:
4587: --dbms_output.put_line('l_html body = ' || substr(l_html,1,200));
4588:
4589: --we only want the html body here
4590: IF ((l_position > 0) OR (l_http_body)) THEN
4591:

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

4839:
4840: -- START OF BODY OF API
4841:
4842: get_baseurl(l_get_baseurl);
4843: dbms_output.put_line('l_get_baseurl= ' || l_get_baseurl);
4844: --test_debug('OraSecureExtension=> l_get_baseurl= '|| l_get_baseurl);
4845: -- dbms_output.put_line('l_status_url= ' || l_status_url);
4846: -- dbms_output.put_line('l_msg_count_url= ' || l_msg_count_url);
4847: -- dbms_output.put_line('l_msg_data_url= ' || l_msg_data_url);

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

4841:
4842: get_baseurl(l_get_baseurl);
4843: dbms_output.put_line('l_get_baseurl= ' || l_get_baseurl);
4844: --test_debug('OraSecureExtension=> l_get_baseurl= '|| l_get_baseurl);
4845: -- dbms_output.put_line('l_status_url= ' || l_status_url);
4846: -- dbms_output.put_line('l_msg_count_url= ' || l_msg_count_url);
4847: -- dbms_output.put_line('l_msg_data_url= ' || l_msg_data_url);
4848:
4849: -- Construct the full URL to send to the ECServlet.

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

4842: get_baseurl(l_get_baseurl);
4843: dbms_output.put_line('l_get_baseurl= ' || l_get_baseurl);
4844: --test_debug('OraSecureExtension=> l_get_baseurl= '|| l_get_baseurl);
4845: -- dbms_output.put_line('l_status_url= ' || l_status_url);
4846: -- dbms_output.put_line('l_msg_count_url= ' || l_msg_count_url);
4847: -- dbms_output.put_line('l_msg_data_url= ' || l_msg_data_url);
4848:
4849: -- Construct the full URL to send to the ECServlet.
4850: l_url := l_get_baseurl;

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

4843: dbms_output.put_line('l_get_baseurl= ' || l_get_baseurl);
4844: --test_debug('OraSecureExtension=> l_get_baseurl= '|| l_get_baseurl);
4845: -- dbms_output.put_line('l_status_url= ' || l_status_url);
4846: -- dbms_output.put_line('l_msg_count_url= ' || l_msg_count_url);
4847: -- dbms_output.put_line('l_msg_data_url= ' || l_msg_data_url);
4848:
4849: -- Construct the full URL to send to the ECServlet.
4850: l_url := l_get_baseurl;
4851:

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

4851:
4852: --l_db_nls := iby_utility_pvt.get_local_nls();
4853: --l_ecapp_nls := p_pmtreqtrxn_rec.NLS_LANG;
4854:
4855: -- dbms_output.put_line('db NLS val is: ' || l_db_nls);
4856: -- dbms_output.put_line('ecapp NLS val is: ' || l_ecapp_nls);
4857:
4858: --MANDATORY INPUT PARAMETERS
4859: check_mandatory('OapfAction', l_oapf_action, l_url, null, null);

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

4852: --l_db_nls := iby_utility_pvt.get_local_nls();
4853: --l_ecapp_nls := p_pmtreqtrxn_rec.NLS_LANG;
4854:
4855: -- dbms_output.put_line('db NLS val is: ' || l_db_nls);
4856: -- dbms_output.put_line('ecapp NLS val is: ' || l_ecapp_nls);
4857:
4858: --MANDATORY INPUT PARAMETERS
4859: check_mandatory('OapfAction', l_oapf_action, l_url, null, null);
4860: check_mandatory('OapfSecCode', p_cvv, l_url, null, null);

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

4861:
4862:
4863: -- Remove ampersand from the last input parameter.
4864: l_url := RTRIM(l_url,'&');
4865: --dbms_output.put_line('send request ');
4866: --test_debug('OraSecureExtension=> send request ');
4867: --dbms_output.put_line('l_url is:'||substr(l_url,1, 50));
4868: --test_debug('OraSecureExtension=> l_url is: '|| substr(l_url,1, 150));
4869:

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

4863: -- Remove ampersand from the last input parameter.
4864: l_url := RTRIM(l_url,'&');
4865: --dbms_output.put_line('send request ');
4866: --test_debug('OraSecureExtension=> send request ');
4867: --dbms_output.put_line('l_url is:'||substr(l_url,1, 50));
4868: --test_debug('OraSecureExtension=> l_url is: '|| substr(l_url,1, 150));
4869:
4870: --dbms_output.put_line('l_html is:'||substr(l_html, 1, 50));
4871: --test_debug('OraSecureExtension=> l_html is: '|| substr(l_html, 1, 100));

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

4866: --test_debug('OraSecureExtension=> send request ');
4867: --dbms_output.put_line('l_url is:'||substr(l_url,1, 50));
4868: --test_debug('OraSecureExtension=> l_url is: '|| substr(l_url,1, 150));
4869:
4870: --dbms_output.put_line('l_html is:'||substr(l_html, 1, 50));
4871: --test_debug('OraSecureExtension=> l_html is: '|| substr(l_html, 1, 100));
4872: SEND_REQUEST(l_url, l_html);
4873: -- show_output_debug(l_html);
4874:

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

4940:
4941: END LOOP;
4942:
4943: -- Use for Debugging
4944: --dbms_output.put_line('after successfully mapping results');
4945:
4946: -- Standard check of p_commit.
4947: /*
4948: IF FND_API.To_Boolean( p_commit ) THEN