DBA Data[Home] [Help]

APPS.IBY_PAYMENT_ADAPTER_PUB dependencies on FND_LOG

Line 40: iby_debug_pub.add(debug_msg => 'Enter', debug_level => FND_LOG.LEVEL_PROCEDURE,

36: l_local_nls VARCHAR2(200);
37: l_remote_nls VARCHAR2(200);
38: BEGIN
39:
40: iby_debug_pub.add(debug_msg => 'Enter', debug_level => FND_LOG.LEVEL_PROCEDURE,
41: module => G_DEBUG_MODULE || '.unpack_results');
42:
43: -- Initialize status, errcode, errmessage to Success.
44: x_status := 0;

Line 113: iby_debug_pub.add(debug_msg => 'Exit', debug_level => FND_LOG.LEVEL_PROCEDURE,

109: END LOOP;
110: END IF;
111: */
112:
113: iby_debug_pub.add(debug_msg => 'Exit', debug_level => FND_LOG.LEVEL_PROCEDURE,
114: module => G_DEBUG_MODULE || '.unpack_results');
115:
116: EXCEPTION
117: WHEN OTHERS THEN

Line 139: debug_level => FND_LOG.LEVEL_UNEXPECTED,

135: IS
136: BEGIN
137: IF (p_trxn_status IS NULL) THEN
138: iby_debug_pub.add(debug_msg => 'ECApp servlet trxn status is NULL!',
139: debug_level => FND_LOG.LEVEL_UNEXPECTED,
140: module => G_DEBUG_MODULE || '.trxn_status_success');
141: RETURN FALSE;
142: ELSIF ((IBY_PAYMENT_ADAPTER_PUB.C_TRXN_STATUS_SUCCESS = p_trxn_status) OR
143: (IBY_PAYMENT_ADAPTER_PUB.C_TRXN_STATUS_INFO = p_trxn_status) OR

Line 427: iby_debug_pub.add(debug_msg => 'Enter', debug_level => FND_LOG.LEVEL_PROCEDURE,

423: p_temp_var VARCHAR2(2);
424:
425: BEGIN
426:
427: iby_debug_pub.add(debug_msg => 'Enter', debug_level => FND_LOG.LEVEL_PROCEDURE,
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:

Line 448: debug_level => FND_LOG.LEVEL_STATEMENT,

444: x_baseurl := x_baseurl || '?';
445: END IF;
446:
447: iby_debug_pub.add(debug_msg => 'base url=' || x_baseurl,
448: debug_level => FND_LOG.LEVEL_STATEMENT,
449: module => G_DEBUG_MODULE || '.get_baseurl');
450:
451: iby_debug_pub.add(debug_msg => 'Exit',
452: debug_level => FND_LOG.LEVEL_PROCEDURE,

Line 452: debug_level => FND_LOG.LEVEL_PROCEDURE,

448: debug_level => FND_LOG.LEVEL_STATEMENT,
449: module => G_DEBUG_MODULE || '.get_baseurl');
450:
451: iby_debug_pub.add(debug_msg => 'Exit',
452: debug_level => FND_LOG.LEVEL_PROCEDURE,
453: module => G_DEBUG_MODULE || '.get_baseurl');
454:
455: END get_baseurl;
456:

Line 479: debug_level => FND_LOG.LEVEL_PROCEDURE,

475:
476: BEGIN
477: -- Send http request to the payment server.
478: iby_debug_pub.add(debug_msg => 'Enter',
479: debug_level => FND_LOG.LEVEL_PROCEDURE,
480: module => G_DEBUG_MODULE || '.send_request');
481:
482: iby_utility_pvt.get_property(iby_security_pkg.C_SHARED_WALLET_LOC_PROP_NAME,l_wallet_location);
483:

Line 499: debug_level => FND_LOG.LEVEL_STATEMENT,

495: iby_utility_pvt.get_property('IBY_NETWORK_TIMEOUT', l_timeout);
496:
497: iby_debug_pub.add(debug_msg => 'Timeout setting at profile level = '
498: || l_timeout,
499: debug_level => FND_LOG.LEVEL_STATEMENT,
500: module => G_DEBUG_MODULE || '.send_request');
501:
502: BEGIN
503:

Line 525: debug_level => FND_LOG.LEVEL_STATEMENT,

521: UTL_HTTP.SET_TRANSFER_TIMEOUT(l_num_val);
522:
523: iby_debug_pub.add(debug_msg => 'UTL_HTTP timeout set to '
524: || l_num_val || ' seconds.',
525: debug_level => FND_LOG.LEVEL_STATEMENT,
526: module => G_DEBUG_MODULE || '.send_request');
527:
528: END IF;
529:

Line 541: debug_level => FND_LOG.LEVEL_STATEMENT,

537: *
538: * So, swallow the exception and move on.
539: */
540: iby_debug_pub.add(debug_msg => 'Ignoring timeout setting',
541: debug_level => FND_LOG.LEVEL_STATEMENT,
542: module => G_DEBUG_MODULE || '.send_request');
543:
544: END;
545:

Line 547: debug_level => FND_LOG.LEVEL_STATEMENT,

543:
544: END;
545:
546: iby_debug_pub.add(debug_msg => 'Continuing after setting timeout ..',
547: debug_level => FND_LOG.LEVEL_STATEMENT,
548: module => G_DEBUG_MODULE || '.send_request');
549:
550: --
551: -- using a SSO password-less wallet

Line 559: debug_level => FND_LOG.LEVEL_STATEMENT,

555: l_wallet_location := iby_netutils_pvt.path_to_url(l_wallet_location);
556: END IF;
557:
558: iby_debug_pub.add(debug_msg => 'Input url = '|| cipher_url(x_url),
559: debug_level => FND_LOG.LEVEL_STATEMENT,
560: module => G_DEBUG_MODULE || '.send_request');
561:
562: --show_input_debug(cipher_url(x_url));
563:

Line 581: debug_level => FND_LOG.LEVEL_PROCEDURE,

577: ( SUBSTR(x_url,1,l_index-1), l_post_body, x_htmldoc );
578:
579:
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:

Line 681: debug_level => FND_LOG.LEVEL_PROCEDURE,

677:
678: BEGIN
679:
680: iby_debug_pub.add(debug_msg => 'Enter',
681: debug_level => FND_LOG.LEVEL_PROCEDURE,
682: module => G_DEBUG_MODULE || '.OraPmtReq');
683:
684: -- Standard Start of API savepoint
685: --SAVEPOINT OraPmtReq_PUB;

Line 910: debug_level => FND_LOG.LEVEL_UNEXPECTED,

906:
907: --Raising Exception to handle errors in unpacking resulting html file.
908: IF (l_status = -1) THEN
909: iby_debug_pub.add(debug_msg => 'Unpack status error; HTML resp. invalid!',
910: debug_level => FND_LOG.LEVEL_UNEXPECTED,
911: module => G_DEBUG_MODULE || '.OraPmtReq');
912: FND_MESSAGE.SET_NAME('IBY', 'IBY_204403_HTML_UNPACK_ERROR');
913: FND_MSG_PUB.Add;
914: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 920: debug_level => FND_LOG.LEVEL_UNEXPECTED,

916:
917: --Raising Exception to handle Servlet related errors.
918: IF (l_names.COUNT = 0) THEN
919: iby_debug_pub.add(debug_msg => 'HTML response names count=0',
920: debug_level => FND_LOG.LEVEL_UNEXPECTED,
921: module => G_DEBUG_MODULE || '.OraPmtReq');
922: FND_MESSAGE.SET_NAME('IBY', 'IBY_204402_JSERVLET_ERROR');
923: FND_MSG_PUB.Add;
924: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 932: debug_level => FND_LOG.LEVEL_STATEMENT,

928: them to the output record: x_reqresp_rec.
929: */
930:
931: iby_debug_pub.add(debug_msg => 'Setting fields from unpacked response',
932: debug_level => FND_LOG.LEVEL_STATEMENT,
933: module => G_DEBUG_MODULE || '.OraPmtReq');
934:
935:
936: FOR i IN 1..l_names.COUNT LOOP

Line 941: debug_level => FND_LOG.LEVEL_STATEMENT,

937: --Payment Server Related Generic Response
938: IF l_names(i) = 'OapfStatus' THEN
939: x_reqresp_rec.Response.Status := TO_NUMBER(l_values(i));
940: iby_debug_pub.add(debug_msg => 'Response status=' || x_reqresp_rec.Response.Status,
941: debug_level => FND_LOG.LEVEL_STATEMENT,
942: module => G_DEBUG_MODULE || '.OraPmtReq');
943: ELSIF l_names(i) = 'OapfCode' THEN
944: x_reqresp_rec.Response.ErrCode := l_values(i);
945: iby_debug_pub.add(debug_msg => 'Response code=' || x_reqresp_rec.Response.ErrCode,

Line 946: debug_level => FND_LOG.LEVEL_STATEMENT,

942: module => G_DEBUG_MODULE || '.OraPmtReq');
943: ELSIF l_names(i) = 'OapfCode' THEN
944: x_reqresp_rec.Response.ErrCode := l_values(i);
945: iby_debug_pub.add(debug_msg => 'Response code=' || x_reqresp_rec.Response.ErrCode,
946: debug_level => FND_LOG.LEVEL_STATEMENT,
947: module => G_DEBUG_MODULE || '.OraPmtReq');
948: ELSIF l_names(i) = 'OapfCause' THEN
949: x_reqresp_rec.Response.ErrMessage := l_values(i);
950: iby_debug_pub.add(debug_msg => 'Response message=' || x_reqresp_rec.Response.ErrMessage,

Line 951: debug_level => FND_LOG.LEVEL_STATEMENT,

947: module => G_DEBUG_MODULE || '.OraPmtReq');
948: ELSIF l_names(i) = 'OapfCause' THEN
949: x_reqresp_rec.Response.ErrMessage := l_values(i);
950: iby_debug_pub.add(debug_msg => 'Response message=' || x_reqresp_rec.Response.ErrMessage,
951: debug_level => FND_LOG.LEVEL_STATEMENT,
952: module => G_DEBUG_MODULE || '.OraPmtReq');
953: ELSIF l_names(i) = 'OapfNlsLang' THEN
954: x_reqresp_rec.Response.NLS_LANG := l_values(i);
955:

Line 1061: debug_level => FND_LOG.LEVEL_STATEMENT,

1057: p_data => x_msg_data
1058: );
1059:
1060: iby_debug_pub.add(debug_msg => 'x_return_status=' || x_return_status,
1061: debug_level => FND_LOG.LEVEL_STATEMENT,
1062: module => G_DEBUG_MODULE || '.OraPmtReq');
1063: iby_debug_pub.add(debug_msg => 'req response status=' || x_reqresp_rec.Response.Status,
1064: debug_level => FND_LOG.LEVEL_STATEMENT,
1065: module => G_DEBUG_MODULE || '.OraPmtReq');

Line 1064: debug_level => FND_LOG.LEVEL_STATEMENT,

1060: iby_debug_pub.add(debug_msg => 'x_return_status=' || x_return_status,
1061: debug_level => FND_LOG.LEVEL_STATEMENT,
1062: module => G_DEBUG_MODULE || '.OraPmtReq');
1063: iby_debug_pub.add(debug_msg => 'req response status=' || x_reqresp_rec.Response.Status,
1064: debug_level => FND_LOG.LEVEL_STATEMENT,
1065: module => G_DEBUG_MODULE || '.OraPmtReq');
1066:
1067: iby_debug_pub.add(debug_msg => 'Exit',
1068: debug_level => FND_LOG.LEVEL_PROCEDURE,

Line 1068: debug_level => FND_LOG.LEVEL_PROCEDURE,

1064: debug_level => FND_LOG.LEVEL_STATEMENT,
1065: module => G_DEBUG_MODULE || '.OraPmtReq');
1066:
1067: iby_debug_pub.add(debug_msg => 'Exit',
1068: debug_level => FND_LOG.LEVEL_PROCEDURE,
1069: module => G_DEBUG_MODULE || '.OraPmtReq');
1070:
1071: EXCEPTION
1072:

Line 1076: debug_level => FND_LOG.LEVEL_ERROR,

1072:
1073: WHEN FND_API.G_EXC_ERROR THEN
1074:
1075: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
1076: debug_level => FND_LOG.LEVEL_ERROR,
1077: module => G_DEBUG_MODULE || '.OraPmtReq');
1078: --ROLLBACK TO OraPmtReq_PUB;
1079: x_return_status := FND_API.G_RET_STS_ERROR ;
1080: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 1086: debug_level => FND_LOG.LEVEL_UNEXPECTED,

1082: );
1083: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1084:
1085: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
1086: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1087: module => G_DEBUG_MODULE || '.OraPmtReq');
1088: --ROLLBACK TO OraPmtReq_PUB;
1089: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1090: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 1096: debug_level => FND_LOG.LEVEL_UNEXPECTED,

1092: );
1093: WHEN OTHERS THEN
1094:
1095: iby_debug_pub.add(debug_msg => 'In OTHERS Exception',
1096: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1097: module => G_DEBUG_MODULE || '.OraPmtReq');
1098: --ROLLBACK TO OraPmtReq_PUB;
1099: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1100: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 1109: debug_level => FND_LOG.LEVEL_UNEXPECTED,

1105: p_data => x_msg_data
1106: );
1107:
1108: iby_debug_pub.add(debug_msg => 'x_return_status=' || x_return_status,
1109: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1110: module => G_DEBUG_MODULE || '.OraPmtReq');
1111: iby_debug_pub.add(debug_msg => 'Exit Exception',
1112: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1113: module => G_DEBUG_MODULE || '.OraPmtReq');

Line 1112: debug_level => FND_LOG.LEVEL_UNEXPECTED,

1108: iby_debug_pub.add(debug_msg => 'x_return_status=' || x_return_status,
1109: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1110: module => G_DEBUG_MODULE || '.OraPmtReq');
1111: iby_debug_pub.add(debug_msg => 'Exit Exception',
1112: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1113: module => G_DEBUG_MODULE || '.OraPmtReq');
1114:
1115: END OraPmtReq;
1116:

Line 4390: iby_debug_pub.add('Enter',FND_LOG.LEVEL_PROCEDURE,

4386: l_batch_msg VARCHAR2(2000);
4387:
4388: BEGIN
4389:
4390: iby_debug_pub.add('Enter',FND_LOG.LEVEL_PROCEDURE,
4391: G_DEBUG_MODULE || '.OraCCBatchCapture');
4392:
4393: /* ***** Performing Validations, Initializations
4394: for Standard IN, OUT Parameters ***** */

Line 4419: FND_LOG.LEVEL_STATEMENT,

4415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4416: END IF;
4417:
4418: iby_debug_pub.add('Batch size = ' || p_capturetrxn_rec_tbl.count,
4419: FND_LOG.LEVEL_STATEMENT,
4420: G_DEBUG_MODULE || '.OraCCBatchCapture');
4421: --
4422: -- Verifying if the batch size exceeded max.
4423: -- The batch size has exceeded the max limit size.

Line 4439: FND_LOG.LEVEL_STATEMENT,

4435: get_baseurl(l_get_baseurl);
4436: -- Construct the full URL to send to the ECServlet.
4437: l_url := l_get_baseurl;
4438: iby_debug_pub.add('iPaymentURL = ' || l_url,
4439: FND_LOG.LEVEL_STATEMENT,
4440: G_DEBUG_MODULE || '.OraCCBatchCapture');
4441:
4442: l_db_nls := iby_utility_pvt.get_local_nls();
4443:

Line 4492: FND_LOG.LEVEL_STATEMENT,

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');
4494: iby_debug_pub.add('l_port = ' || l_port,
4495: FND_LOG.LEVEL_STATEMENT,
4496: G_DEBUG_MODULE || '.OraCCBatchCapture');

Line 4495: FND_LOG.LEVEL_STATEMENT,

4491: iby_debug_pub.add('l_host = ' || l_host,
4492: FND_LOG.LEVEL_STATEMENT,
4493: G_DEBUG_MODULE || '.OraCCBatchCapture');
4494: iby_debug_pub.add('l_port = ' || l_port,
4495: FND_LOG.LEVEL_STATEMENT,
4496: G_DEBUG_MODULE || '.OraCCBatchCapture');
4497:
4498: -- open connection
4499: l_conn := utl_tcp.open_connection(remote_host => l_host,

Line 4503: FND_LOG.LEVEL_STATEMENT,

4499: l_conn := utl_tcp.open_connection(remote_host => l_host,
4500: remote_port => l_port);
4501:
4502: iby_debug_pub.add('opened socket to EC Servlet',
4503: FND_LOG.LEVEL_STATEMENT,
4504: G_DEBUG_MODULE || '.OraCCBatchCapture');
4505:
4506: l_ret_val := utl_tcp.write_line(l_conn, l_post_info);
4507: l_ret_val := utl_tcp.write_line(l_conn,'Accept: text/plain');

Line 4546: FND_LOG.LEVEL_STATEMENT,

4542:
4543: END LOOP;
4544:
4545: iby_debug_pub.add('l_content_len = ' || l_content_len,
4546: FND_LOG.LEVEL_STATEMENT,
4547: G_DEBUG_MODULE || '.OraCCBatchCapture');
4548:
4549: l_ret_val := utl_tcp.write_line(l_conn,'Content-length: '||l_content_len);
4550: l_ret_val := utl_tcp.write_line(l_conn);

Line 4603: FND_LOG.LEVEL_UNEXPECTED,

4599: --Raising Exception to handle errors in unpacking resulting html file.
4600: IF (l_status = -1) THEN
4601:
4602: iby_debug_pub.add('error unpacking results',
4603: FND_LOG.LEVEL_UNEXPECTED,
4604: G_DEBUG_MODULE || '.OraCCBatchCapture');
4605:
4606: FND_MESSAGE.SET_NAME('IBY', 'IBY_204403_HTML_UNPACK_ERROR');
4607: FND_MSG_PUB.Add;

Line 4615: FND_LOG.LEVEL_UNEXPECTED,

4611: --Raising Exception to handle Servlet related errors.
4612: IF (l_names.COUNT = 0) THEN
4613:
4614: iby_debug_pub.add('servlet errors; no names returned',
4615: FND_LOG.LEVEL_UNEXPECTED,
4616: G_DEBUG_MODULE || '.OraCCBatchCapture');
4617:
4618: FND_MESSAGE.SET_NAME('IBY', 'IBY_204402_JSERVLET_ERROR');
4619: FND_MSG_PUB.Add;

Line 4634: FND_LOG.LEVEL_STATEMENT,

4630: --Payment Server GENERIC Response
4631: IF l_ret_name = 'OapfStatus' THEN
4632: x_capresp_rec_tbl(l_ret_index).Status := TO_NUMBER(l_ret_value);
4633: iby_debug_pub.add('status #'||l_ret_index||'='||x_capresp_rec_tbl(l_ret_index).Status,
4634: FND_LOG.LEVEL_STATEMENT,
4635: G_DEBUG_MODULE || '.OraCCBatchCapture');
4636: ELSIF l_ret_name = 'OapfCode' THEN
4637: x_capresp_rec_tbl(l_ret_index).ErrCode := l_ret_value;
4638: iby_debug_pub.add('code #'||l_ret_index||'='||x_capresp_rec_tbl(l_ret_index).ErrCode,

Line 4639: FND_LOG.LEVEL_STATEMENT,

4635: G_DEBUG_MODULE || '.OraCCBatchCapture');
4636: ELSIF l_ret_name = 'OapfCode' THEN
4637: x_capresp_rec_tbl(l_ret_index).ErrCode := l_ret_value;
4638: iby_debug_pub.add('code #'||l_ret_index||'='||x_capresp_rec_tbl(l_ret_index).ErrCode,
4639: FND_LOG.LEVEL_STATEMENT,
4640: G_DEBUG_MODULE || '.OraCCBatchCapture');
4641: ELSIF l_ret_name = 'OapfCause' THEN
4642: x_capresp_rec_tbl(l_ret_index).ErrMessage := l_ret_value;
4643: iby_debug_pub.add('casue #'||l_ret_index||'='||x_capresp_rec_tbl(l_ret_index).ErrMessage,

Line 4644: FND_LOG.LEVEL_STATEMENT,

4640: G_DEBUG_MODULE || '.OraCCBatchCapture');
4641: ELSIF l_ret_name = 'OapfCause' THEN
4642: x_capresp_rec_tbl(l_ret_index).ErrMessage := l_ret_value;
4643: iby_debug_pub.add('casue #'||l_ret_index||'='||x_capresp_rec_tbl(l_ret_index).ErrMessage,
4644: FND_LOG.LEVEL_STATEMENT,
4645: G_DEBUG_MODULE || '.OraCCBatchCapture');
4646: ELSIF l_ret_name = 'OapfNlsLang' THEN
4647: x_capresp_rec_tbl(l_ret_index).NLS_LANG := l_ret_value;
4648:

Line 4682: FND_LOG.LEVEL_STATEMENT,

4678: -- within it failed for one reason or another
4679: --
4680: ELSIF l_names(i) = 'OapfStatus' THEN
4681: iby_debug_pub.add('trxn status='||l_values(i),
4682: FND_LOG.LEVEL_STATEMENT,
4683: G_DEBUG_MODULE || '.OraCCBatchCapture');
4684: l_batch_status := TO_NUMBER(l_values(i));
4685: ELSIF l_names(i) = 'OapfCause' THEN
4686: iby_debug_pub.add('batch err msg='||l_values(i),

Line 4687: FND_LOG.LEVEL_STATEMENT,

4683: G_DEBUG_MODULE || '.OraCCBatchCapture');
4684: l_batch_status := TO_NUMBER(l_values(i));
4685: ELSIF l_names(i) = 'OapfCause' THEN
4686: iby_debug_pub.add('batch err msg='||l_values(i),
4687: FND_LOG.LEVEL_STATEMENT,
4688: G_DEBUG_MODULE || '.OraCCBatchCapture');
4689: l_batch_msg := l_values(i);
4690: END IF;
4691:

Line 4738: FND_LOG.LEVEL_PROCEDURE,

4734: p_data => x_msg_data
4735: );
4736:
4737: iby_debug_pub.add('Exit',
4738: FND_LOG.LEVEL_PROCEDURE,
4739: G_DEBUG_MODULE || '.OraCCBatchCapture');
4740:
4741: EXCEPTION
4742: WHEN FND_API.G_EXC_ERROR THEN

Line 4745: FND_LOG.LEVEL_ERROR,

4741: EXCEPTION
4742: WHEN FND_API.G_EXC_ERROR THEN
4743:
4744: iby_debug_pub.add('In Expected Error',
4745: FND_LOG.LEVEL_ERROR,
4746: G_DEBUG_MODULE || '.OraCCBatchCapture');
4747: --ROLLBACK TO OraCCBatchCapture_PUB;
4748: x_return_status := FND_API.G_RET_STS_ERROR ;
4749: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 4755: FND_LOG.LEVEL_UNEXPECTED,

4751: );
4752: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4753:
4754: iby_debug_pub.add('In Unexpected Error',
4755: FND_LOG.LEVEL_UNEXPECTED,
4756: G_DEBUG_MODULE || '.OraCCBatchCapture');
4757: --ROLLBACK TO OraCCBatchCapture_PUB;
4758: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4759: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 4765: FND_LOG.LEVEL_UNEXPECTED,

4761: );
4762: WHEN OTHERS THEN
4763:
4764: iby_debug_pub.add('In Others Exception',
4765: FND_LOG.LEVEL_UNEXPECTED,
4766: G_DEBUG_MODULE || '.OraCCBatchCapture');
4767: iby_debug_pub.add('Exception code='||SQLCODE,
4768: FND_LOG.LEVEL_UNEXPECTED,
4769: G_DEBUG_MODULE || '.OraCCBatchCapture');

Line 4768: FND_LOG.LEVEL_UNEXPECTED,

4764: iby_debug_pub.add('In Others Exception',
4765: FND_LOG.LEVEL_UNEXPECTED,
4766: G_DEBUG_MODULE || '.OraCCBatchCapture');
4767: iby_debug_pub.add('Exception code='||SQLCODE,
4768: FND_LOG.LEVEL_UNEXPECTED,
4769: G_DEBUG_MODULE || '.OraCCBatchCapture');
4770: iby_debug_pub.add('Exception message='||SQLERRM,
4771: FND_LOG.LEVEL_UNEXPECTED,
4772: G_DEBUG_MODULE || '.OraCCBatchCapture');

Line 4771: FND_LOG.LEVEL_UNEXPECTED,

4767: iby_debug_pub.add('Exception code='||SQLCODE,
4768: FND_LOG.LEVEL_UNEXPECTED,
4769: G_DEBUG_MODULE || '.OraCCBatchCapture');
4770: iby_debug_pub.add('Exception message='||SQLERRM,
4771: FND_LOG.LEVEL_UNEXPECTED,
4772: G_DEBUG_MODULE || '.OraCCBatchCapture');
4773:
4774: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4775: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 4833: debug_level => FND_LOG.LEVEL_PROCEDURE,

4829:
4830: BEGIN
4831:
4832: iby_debug_pub.add(debug_msg => 'Enter',
4833: debug_level => FND_LOG.LEVEL_PROCEDURE,
4834: module => G_DEBUG_MODULE || '.OraSecureExtension');
4835:
4836: --test_debug('OraSecureExtension=> Enter');
4837: -- Initialize API return status to success

Line 4885: debug_level => FND_LOG.LEVEL_UNEXPECTED,

4881: --Raising Exception to handle errors in unpacking resulting html file.
4882: IF (l_status = -1) THEN
4883: --test_debug('unpack error !!');
4884: iby_debug_pub.add(debug_msg => 'Unpack status error; HTML resp. invalid!',
4885: debug_level => FND_LOG.LEVEL_UNEXPECTED,
4886: module => G_DEBUG_MODULE || '.OraSecureExtension');
4887: FND_MESSAGE.SET_NAME('IBY', 'IBY_204403_HTML_UNPACK_ERROR');
4888: FND_MSG_PUB.Add;
4889: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4896: debug_level => FND_LOG.LEVEL_UNEXPECTED,

4892: --Raising Exception to handle Servlet related errors.
4893: IF (l_names.COUNT = 0) THEN
4894: --test_debug('response count is 0 !!');
4895: iby_debug_pub.add(debug_msg => 'HTML response names count=0',
4896: debug_level => FND_LOG.LEVEL_UNEXPECTED,
4897: module => G_DEBUG_MODULE || '.OraSecureExtension');
4898: FND_MESSAGE.SET_NAME('IBY', 'IBY_204402_JSERVLET_ERROR');
4899: FND_MSG_PUB.Add;
4900: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4908: debug_level => FND_LOG.LEVEL_STATEMENT,

4904: them to the output record: x_reqresp_rec.
4905: */
4906: --test_debug('Setting fields from unpacked response');
4907: iby_debug_pub.add(debug_msg => 'Setting fields from unpacked response',
4908: debug_level => FND_LOG.LEVEL_STATEMENT,
4909: module => G_DEBUG_MODULE || '.OraSecureExtension');
4910:
4911:
4912: FOR i IN 1..l_names.COUNT LOOP

Line 4917: debug_level => FND_LOG.LEVEL_STATEMENT,

4913: --Payment Server Related Generic Response
4914: IF l_names(i) = 'OapfStatus' THEN
4915: x_resp_rec.Response.Status := TO_NUMBER(l_values(i));
4916: iby_debug_pub.add(debug_msg => 'Response status=' || x_resp_rec.Response.Status,
4917: debug_level => FND_LOG.LEVEL_STATEMENT,
4918: module => G_DEBUG_MODULE || '.OraSecureExtension');
4919: --test_debug('OapfStatus: '||x_resp_rec.Response.Status);
4920: ELSIF l_names(i) = 'OapfCode' THEN
4921: x_resp_rec.Response.ErrCode := l_values(i);

Line 4923: debug_level => FND_LOG.LEVEL_STATEMENT,

4919: --test_debug('OapfStatus: '||x_resp_rec.Response.Status);
4920: ELSIF l_names(i) = 'OapfCode' THEN
4921: x_resp_rec.Response.ErrCode := l_values(i);
4922: iby_debug_pub.add(debug_msg => 'Response code=' || x_resp_rec.Response.ErrCode,
4923: debug_level => FND_LOG.LEVEL_STATEMENT,
4924: module => G_DEBUG_MODULE || '.OraSecureExtension');
4925: --test_debug('OapfCode: '||x_resp_rec.Response.ErrCode);
4926: ELSIF l_names(i) = 'OapfCause' THEN
4927: x_resp_rec.Response.ErrMessage := l_values(i);

Line 4929: debug_level => FND_LOG.LEVEL_STATEMENT,

4925: --test_debug('OapfCode: '||x_resp_rec.Response.ErrCode);
4926: ELSIF l_names(i) = 'OapfCause' THEN
4927: x_resp_rec.Response.ErrMessage := l_values(i);
4928: iby_debug_pub.add(debug_msg => 'Response message=' || x_resp_rec.Response.ErrMessage,
4929: debug_level => FND_LOG.LEVEL_STATEMENT,
4930: module => G_DEBUG_MODULE || '.OraSecureExtension');
4931: --test_debug('OapfCause: '||x_resp_rec.Response.ErrMessage);
4932: ELSIF l_names(i) = 'OapfNlsLang' THEN
4933: x_resp_rec.Response.NLS_LANG := l_values(i);

Line 4959: debug_level => FND_LOG.LEVEL_STATEMENT,

4955: p_data => x_msg_data
4956: );
4957:
4958: iby_debug_pub.add(debug_msg => 'x_return_status=' || x_return_status,
4959: debug_level => FND_LOG.LEVEL_STATEMENT,
4960: module => G_DEBUG_MODULE || '.OraSecureExtension');
4961: iby_debug_pub.add(debug_msg => 'req response status=' || x_resp_rec.Response.Status,
4962: debug_level => FND_LOG.LEVEL_STATEMENT,
4963: module => G_DEBUG_MODULE || '.OraSecureExtension');

Line 4962: debug_level => FND_LOG.LEVEL_STATEMENT,

4958: iby_debug_pub.add(debug_msg => 'x_return_status=' || x_return_status,
4959: debug_level => FND_LOG.LEVEL_STATEMENT,
4960: module => G_DEBUG_MODULE || '.OraSecureExtension');
4961: iby_debug_pub.add(debug_msg => 'req response status=' || x_resp_rec.Response.Status,
4962: debug_level => FND_LOG.LEVEL_STATEMENT,
4963: module => G_DEBUG_MODULE || '.OraSecureExtension');
4964:
4965: iby_debug_pub.add(debug_msg => 'Exit',
4966: debug_level => FND_LOG.LEVEL_PROCEDURE,

Line 4966: debug_level => FND_LOG.LEVEL_PROCEDURE,

4962: debug_level => FND_LOG.LEVEL_STATEMENT,
4963: module => G_DEBUG_MODULE || '.OraSecureExtension');
4964:
4965: iby_debug_pub.add(debug_msg => 'Exit',
4966: debug_level => FND_LOG.LEVEL_PROCEDURE,
4967: module => G_DEBUG_MODULE || '.OraSecureExtension');
4968: --test_debug('Exit*******');
4969:
4970: EXCEPTION

Line 4975: debug_level => FND_LOG.LEVEL_ERROR,

4971:
4972: WHEN FND_API.G_EXC_ERROR THEN
4973:
4974: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
4975: debug_level => FND_LOG.LEVEL_ERROR,
4976: module => G_DEBUG_MODULE || '.OraSecureExtension');
4977: --ROLLBACK TO OraPmtReq_PUB;
4978: x_return_status := FND_API.G_RET_STS_ERROR ;
4979: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 4985: debug_level => FND_LOG.LEVEL_UNEXPECTED,

4981: );
4982: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4983:
4984: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
4985: debug_level => FND_LOG.LEVEL_UNEXPECTED,
4986: module => G_DEBUG_MODULE || '.OraSecureExtension');
4987: --ROLLBACK TO OraPmtReq_PUB;
4988: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4989: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 4995: debug_level => FND_LOG.LEVEL_UNEXPECTED,

4991: );
4992: WHEN OTHERS THEN
4993:
4994: iby_debug_pub.add(debug_msg => 'In OTHERS Exception',
4995: debug_level => FND_LOG.LEVEL_UNEXPECTED,
4996: module => G_DEBUG_MODULE || '.OraSecureExtension');
4997: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4998: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4999: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);

Line 5007: debug_level => FND_LOG.LEVEL_UNEXPECTED,

5003: p_data => x_msg_data
5004: );
5005:
5006: iby_debug_pub.add(debug_msg => 'x_return_status=' || x_return_status,
5007: debug_level => FND_LOG.LEVEL_UNEXPECTED,
5008: module => G_DEBUG_MODULE || '.OraSecureExtension');
5009: iby_debug_pub.add(debug_msg => 'Exit Exception',
5010: debug_level => FND_LOG.LEVEL_UNEXPECTED,
5011: module => G_DEBUG_MODULE || '.OraSecureExtension');

Line 5010: debug_level => FND_LOG.LEVEL_UNEXPECTED,

5006: iby_debug_pub.add(debug_msg => 'x_return_status=' || x_return_status,
5007: debug_level => FND_LOG.LEVEL_UNEXPECTED,
5008: module => G_DEBUG_MODULE || '.OraSecureExtension');
5009: iby_debug_pub.add(debug_msg => 'Exit Exception',
5010: debug_level => FND_LOG.LEVEL_UNEXPECTED,
5011: module => G_DEBUG_MODULE || '.OraSecureExtension');
5012:
5013: END OraSecureExtension;
5014: