[Home] [Help]
182: */
183:
184: IF (p_value is NULL) THEN
185: --Note: Reused an existing IBY message and token.
186: FND_MESSAGE.SET_NAME('IBY', 'IBY_0004');
187: FND_MESSAGE.SET_TOKEN('FIELD', p_name);
188: FND_MSG_PUB.Add;
189:
190: -- jleybovi [10/24/00]
183:
184: IF (p_value is NULL) THEN
185: --Note: Reused an existing IBY message and token.
186: FND_MESSAGE.SET_NAME('IBY', 'IBY_0004');
187: FND_MESSAGE.SET_TOKEN('FIELD', p_name);
188: FND_MSG_PUB.Add;
189:
190: -- jleybovi [10/24/00]
191: --
210: --
211: -- catch any of the conversion errors that may
212: -- have occured here
213: --
214: FND_MESSAGE.SET_NAME('IBY', 'IBY_204011');
215: FND_MESSAGE.SET_TOKEN('FIELD', 'NLS_LANG');
216: FND_MSG_PUB.Add;
217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
218: */
211: -- catch any of the conversion errors that may
212: -- have occured here
213: --
214: FND_MESSAGE.SET_NAME('IBY', 'IBY_204011');
215: FND_MESSAGE.SET_TOKEN('FIELD', 'NLS_LANG');
216: FND_MSG_PUB.Add;
217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
218: */
219: WHEN OTHERS THEN
266: --
267: -- catch any of the conversion errors that may
268: -- have occured here
269: --
270: FND_MESSAGE.SET_NAME('IBY', 'IBY_204011');
271: FND_MESSAGE.SET_TOKEN('FIELD', 'NLS_LANG');
272: FND_MSG_PUB.Add;
273: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
274: */
267: -- catch any of the conversion errors that may
268: -- have occured here
269: --
270: FND_MESSAGE.SET_NAME('IBY', 'IBY_204011');
271: FND_MESSAGE.SET_TOKEN('FIELD', 'NLS_LANG');
272: FND_MSG_PUB.Add;
273: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
274: */
275: WHEN OTHERS THEN
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;
437: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
438: END IF;
439:
586: EXCEPTION
587: WHEN UTL_HTTP.REQUEST_FAILED THEN
588:
589: --FND_MSG_PUB.Add_Exc_Msg(p_error_text => SQLCODE||':-:'||SQLERRM);
590: FND_MESSAGE.SET_NAME('IBY', 'IBY_0001');
591: FND_MSG_PUB.Add;
592: -- x_return_status := 3 ;
593: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
594:
692: p_api_version,
693: l_api_name,
694: G_PKG_NAME )
695: THEN
696: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
697: FND_MSG_PUB.Add;
698: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
699: END IF;
700:
704: END IF;
705:
706: -- Verifying if validation level is FULL, which is expected for PUBLIC APIs.
707: IF (p_validation_level <> g_validation_level) THEN
708: FND_MESSAGE.SET_NAME('IBY', 'IBY_204401_VAL_LEVEL_ERROR');
709: FND_MSG_PUB.Add;
710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
711: END IF;
712:
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;
915: END IF;
916:
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;
925: END IF;
926:
1197: p_api_version,
1198: l_api_name,
1199: G_PKG_NAME )
1200: THEN
1201: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
1202: FND_MSG_PUB.Add;
1203: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1204: END IF;
1205:
1209: END IF;
1210:
1211: -- Verifying if validation level is FULL, which is expected for PUBLIC APIs.
1212: IF (p_validation_level <> g_validation_level) THEN
1213: FND_MESSAGE.SET_NAME('IBY', 'IBY_204401_VAL_LEVEL_ERROR');
1214: FND_MSG_PUB.Add;
1215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1216: END IF;
1217:
1312: UNPACK_RESULTS_URL(l_html,l_names,l_values, l_status, l_errcode, l_errmessage);
1313:
1314: --Raising Exception to handle errors in unpacking resulting html file.
1315: IF (l_status = -1) THEN
1316: FND_MESSAGE.SET_NAME('IBY', 'IBY_204403_HTML_UNPACK_ERROR');
1317: FND_MSG_PUB.Add;
1318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1319: END IF;
1320:
1319: END IF;
1320:
1321: --Raising Exception to handle Servlet related errors.
1322: IF (l_names.COUNT = 0) THEN
1323: FND_MESSAGE.SET_NAME('IBY', 'IBY_204402_JSERVLET_ERROR');
1324: FND_MSG_PUB.Add;
1325: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1326: END IF;
1327:
1469: p_api_version,
1470: l_api_name,
1471: G_PKG_NAME )
1472: THEN
1473: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
1474: FND_MSG_PUB.Add;
1475: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1476: END IF;
1477:
1481: END IF;
1482:
1483: -- Verifying if validation level is FULL, which is expected for PUBLIC APIs.
1484: IF (p_validation_level <> g_validation_level) THEN
1485: FND_MESSAGE.SET_NAME('IBY', 'IBY_204401_VAL_LEVEL_ERROR');
1486: FND_MSG_PUB.Add;
1487: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1488: END IF;
1489:
1518: FETCH pmtcanc_csr
1519: INTO l_pmtinstr_type;
1520:
1521: IF (pmtcanc_csr%ROWCOUNT = 0) THEN
1522: FND_MESSAGE.SET_NAME('IBY', 'IBY_204404_CURSOR_ERROR');
1523: FND_MSG_PUB.Add;
1524: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1525: END IF;
1526:
1548: UNPACK_RESULTS_URL(l_html,l_names,l_values, l_status, l_errcode, l_errmessage);
1549:
1550: --Raising Exception to handle errors in unpacking resulting html file.
1551: IF (l_status = -1) THEN
1552: FND_MESSAGE.SET_NAME('IBY', 'IBY_204403_HTML_UNPACK_ERROR');
1553: FND_MSG_PUB.Add;
1554: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1555: END IF;
1556:
1555: END IF;
1556:
1557: --Raising Exception to handle Servlet related errors.
1558: IF (l_names.COUNT = 0) THEN
1559: FND_MESSAGE.SET_NAME('IBY', 'IBY_204402_JSERVLET_ERROR');
1560: FND_MSG_PUB.Add;
1561: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1562: END IF;
1563:
1721: p_api_version,
1722: l_api_name,
1723: G_PKG_NAME )
1724: THEN
1725: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
1726: FND_MSG_PUB.Add;
1727: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1728: END IF;
1729:
1733: END IF;
1734:
1735: -- Verifying if validation level is FULL, which is expected for PUBLIC APIs.
1736: IF (p_validation_level <> g_validation_level) THEN
1737: FND_MESSAGE.SET_NAME('IBY', 'IBY_204401_VAL_LEVEL_ERROR');
1738: FND_MSG_PUB.Add;
1739: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1740: END IF;
1741:
1771: FETCH pmtqrytrxn_csr
1772: INTO l_pmtinstr_type;
1773:
1774: IF (pmtqrytrxn_csr%ROWCOUNT = 0) THEN
1775: FND_MESSAGE.SET_NAME('IBY', 'IBY_204404_CURSOR_ERROR');
1776: FND_MSG_PUB.Add;
1777: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1778: END IF;
1779:
1805: UNPACK_RESULTS_URL(l_html,l_names,l_values, l_status, l_errcode, l_errmessage);
1806:
1807: --Raising Exception to handle errors in unpacking resulting html file.
1808: IF (l_status = -1) THEN
1809: FND_MESSAGE.SET_NAME('IBY', 'IBY_204403_HTML_UNPACK_ERROR');
1810: FND_MSG_PUB.Add;
1811: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1812: END IF;
1813:
1812: END IF;
1813:
1814: --Raising Exception to handle Servlet related errors.
1815: IF (l_names.COUNT = 0) THEN
1816: FND_MESSAGE.SET_NAME('IBY', 'IBY_204402_JSERVLET_ERROR');
1817: FND_MSG_PUB.Add;
1818: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1819: END IF;
1820:
2017: p_api_version,
2018: l_api_name,
2019: G_PKG_NAME )
2020: THEN
2021: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
2022: FND_MSG_PUB.Add;
2023: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2024: END IF;
2025:
2029: END IF;
2030:
2031: -- Verifying if validation level is FULL, which is expected for PUBLIC APIs.
2032: IF (p_validation_level <> g_validation_level) THEN
2033: FND_MESSAGE.SET_NAME('IBY', 'IBY_204401_VAL_LEVEL_ERROR');
2034: FND_MSG_PUB.Add;
2035: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2036: END IF;
2037:
2097:
2098:
2099: --Raising Exception to handle errors in unpacking resulting html file.
2100: IF (l_status = -1) THEN
2101: FND_MESSAGE.SET_NAME('IBY', 'IBY_204403_HTML_UNPACK_ERROR');
2102: FND_MSG_PUB.Add;
2103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2104: END IF;
2105:
2104: END IF;
2105:
2106: --Raising Exception to handle Servlet related errors.
2107: IF (l_names.COUNT = 0) THEN
2108: FND_MESSAGE.SET_NAME('IBY', 'IBY_204402_JSERVLET_ERROR');
2109: FND_MSG_PUB.Add;
2110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2111: END IF;
2112:
2267: p_api_version,
2268: l_api_name,
2269: G_PKG_NAME )
2270: THEN
2271: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
2272: FND_MSG_PUB.Add;
2273: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2274: END IF;
2275:
2279: END IF;
2280:
2281: -- Verifying if validation level is FULL, which is expected for PUBLIC APIs.
2282: IF (p_validation_level <> g_validation_level) THEN
2283: FND_MESSAGE.SET_NAME('IBY', 'IBY_204401_VAL_LEVEL_ERROR');
2284: FND_MSG_PUB.Add;
2285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2286: END IF;
2287:
2342: UNPACK_RESULTS_URL(l_html,l_names,l_values, l_status, l_errcode, l_errmessage);
2343:
2344: --Raising Exception to handle errors in unpacking resulting html file.
2345: IF (l_status = -1) THEN
2346: FND_MESSAGE.SET_NAME('IBY', 'IBY_204403_HTML_UNPACK_ERROR');
2347: FND_MSG_PUB.Add;
2348: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2349: END IF;
2350:
2349: END IF;
2350:
2351: --Raising Exception to handle Servlet related errors.
2352: IF (l_names.COUNT = 0) THEN
2353: FND_MESSAGE.SET_NAME('IBY', 'IBY_204402_JSERVLET_ERROR');
2354: FND_MSG_PUB.Add;
2355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2356: END IF;
2357:
2512: p_api_version,
2513: l_api_name,
2514: G_PKG_NAME )
2515: THEN
2516: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
2517: FND_MSG_PUB.Add;
2518: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2519: END IF;
2520:
2524: END IF;
2525:
2526: -- Verifying if validation level is FULL, which is expected for PUBLIC APIs.
2527: IF (p_validation_level <> g_validation_level) THEN
2528: FND_MESSAGE.SET_NAME('IBY', 'IBY_204401_VAL_LEVEL_ERROR');
2529: FND_MSG_PUB.Add;
2530: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2531: END IF;
2532:
2594: --show_table_debug(l_values);
2595:
2596: --Raising Exception to handle errors in unpacking resulting html file.
2597: IF (l_status = -1) THEN
2598: FND_MESSAGE.SET_NAME('IBY', 'IBY_204403_HTML_UNPACK_ERROR');
2599: FND_MSG_PUB.Add;
2600: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2601: END IF;
2602:
2601: END IF;
2602:
2603: --Raising Exception to handle Servlet related errors.
2604: IF (l_names.COUNT = 0) THEN
2605: FND_MESSAGE.SET_NAME('IBY', 'IBY_204402_JSERVLET_ERROR');
2606: FND_MSG_PUB.Add;
2607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2608: END IF;
2609:
2791: p_api_version,
2792: l_api_name,
2793: G_PKG_NAME )
2794: THEN
2795: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
2796: FND_MSG_PUB.Add;
2797: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2798: END IF;
2799:
2803: END IF;
2804:
2805: -- Verifying if validation level is FULL, which is expected for PUBLIC APIs.
2806: IF (p_validation_level <> g_validation_level) THEN
2807: FND_MESSAGE.SET_NAME('IBY', 'IBY_204401_VAL_LEVEL_ERROR');
2808: FND_MSG_PUB.Add;
2809: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2810: END IF;
2811:
2905: UNPACK_RESULTS_URL(l_html,l_names,l_values, l_status, l_errcode, l_errmessage);
2906:
2907: --Raising Exception to handle errors in unpacking resulting html file.
2908: IF (l_status = -1) THEN
2909: FND_MESSAGE.SET_NAME('IBY', 'IBY_204403_HTML_UNPACK_ERROR');
2910: FND_MSG_PUB.Add;
2911: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2912: END IF;
2913:
2912: END IF;
2913:
2914: --Raising Exception to handle Servlet related errors.
2915: IF (l_names.COUNT = 0) THEN
2916: FND_MESSAGE.SET_NAME('IBY', 'IBY_204402_JSERVLET_ERROR');
2917: FND_MSG_PUB.Add;
2918: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2919: END IF;
2920:
3078: p_api_version,
3079: l_api_name,
3080: G_PKG_NAME )
3081: THEN
3082: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
3083: FND_MSG_PUB.Add;
3084: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3085: END IF;
3086:
3090: END IF;
3091:
3092: -- Verifying if validation level is FULL, which is expected for PUBLIC APIs.
3093: IF (p_validation_level <> g_validation_level) THEN
3094: FND_MESSAGE.SET_NAME('IBY', 'IBY_204401_VAL_LEVEL_ERROR');
3095: FND_MSG_PUB.Add;
3096: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3097: END IF;
3098:
3119: x_inqresp_rec.Response.Status := 3;
3120: -- NOTE: Response.ErrCode, Response.ErrMessage are not populated
3121: -- since that would imply hardcoding the message text here (NLS issues)
3122: -- Instead it is sent to the API message list.
3123: FND_MESSAGE.SET_NAME('IBY', 'IBY_204404_CURSOR_ERROR');
3124: FND_MSG_PUB.Add;
3125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3126: END IF;
3127:
3249: p_api_version,
3250: l_api_name,
3251: G_PKG_NAME )
3252: THEN
3253: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
3254: FND_MSG_PUB.Add;
3255: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3256: END IF;
3257:
3261: END IF;
3262:
3263: -- Verifying if validation level is FULL, which is expected for PUBLIC APIs.
3264: IF (p_validation_level <> g_validation_level) THEN
3265: FND_MESSAGE.SET_NAME('IBY', 'IBY_204401_VAL_LEVEL_ERROR');
3266: FND_MSG_PUB.Add;
3267: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3268: END IF;
3269:
3339: UNPACK_RESULTS_URL(l_html,l_names,l_values, l_status, l_errcode, l_errmessage);
3340:
3341: --Raising Exception to handle errors in unpacking resulting html file.
3342: IF (l_status = -1) THEN
3343: FND_MESSAGE.SET_NAME('IBY', 'IBY_204403_HTML_UNPACK_ERROR');
3344: FND_MSG_PUB.Add;
3345: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3346: END IF;
3347:
3346: END IF;
3347:
3348: --Raising Exception to handle Servlet related errors.
3349: IF (l_names.COUNT = 0) THEN
3350: FND_MESSAGE.SET_NAME('IBY', 'IBY_204402_JSERVLET_ERROR');
3351: FND_MSG_PUB.Add;
3352: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3353: END IF;
3354:
3562: p_api_version,
3563: l_api_name,
3564: G_PKG_NAME )
3565: THEN
3566: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
3567: FND_MSG_PUB.Add;
3568: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3569: END IF;
3570:
3574: END IF;
3575:
3576: -- Verifying if validation level is FULL, which is expected for PUBLIC APIs.
3577: IF (p_validation_level <> g_validation_level) THEN
3578: FND_MESSAGE.SET_NAME('IBY', 'IBY_204401_VAL_LEVEL_ERROR');
3579: FND_MSG_PUB.Add;
3580: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3581: END IF;
3582:
3641: UNPACK_RESULTS_URL(l_html,l_names,l_values, l_status, l_errcode, l_errmessage);
3642:
3643: --Raising Exception to handle errors in unpacking resulting html file.
3644: IF (l_status = -1) THEN
3645: FND_MESSAGE.SET_NAME('IBY', 'IBY_204403_HTML_UNPACK_ERROR');
3646: FND_MSG_PUB.Add;
3647: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3648: END IF;
3649:
3648: END IF;
3649:
3650: --Raising Exception to handle Servlet related errors.
3651: IF (l_names.COUNT = 0) THEN
3652: FND_MESSAGE.SET_NAME('IBY', 'IBY_204402_JSERVLET_ERROR');
3653: FND_MSG_PUB.Add;
3654: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3655: END IF;
3656:
3919: p_api_version,
3920: l_api_name,
3921: G_PKG_NAME )
3922: THEN
3923: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
3924: FND_MSG_PUB.Add;
3925: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3926: END IF;
3927:
3931: END IF;
3932:
3933: -- Verifying if validation level is FULL, which is expected for PUBLIC APIs.
3934: IF (p_validation_level <> g_validation_level) THEN
3935: FND_MESSAGE.SET_NAME('IBY', 'IBY_204401_VAL_LEVEL_ERROR');
3936: FND_MSG_PUB.Add;
3937: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3938: END IF;
3939:
3998: --show_table_debug(l_values);
3999:
4000: --Raising Exception to handle errors in unpacking resulting html file.
4001: IF (l_status = -1) THEN
4002: FND_MESSAGE.SET_NAME('IBY', 'IBY_204403_HTML_UNPACK_ERROR');
4003: FND_MSG_PUB.Add;
4004: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4005: END IF;
4006:
4005: END IF;
4006:
4007: --Raising Exception to handle Servlet related errors.
4008: IF (l_names.COUNT = 0) THEN
4009: FND_MESSAGE.SET_NAME('IBY', 'IBY_204402_JSERVLET_ERROR');
4010: FND_MSG_PUB.Add;
4011: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4012: END IF;
4013:
4155: p_api_version,
4156: l_api_name,
4157: G_PKG_NAME )
4158: THEN
4159: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
4160: FND_MSG_PUB.Add;
4161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4162: END IF;
4163:
4167: END IF;
4168:
4169: -- Verifying if validation level is FULL, which is expected for PUBLIC APIs.
4170: IF (p_validation_level <> g_validation_level) THEN
4171: FND_MESSAGE.SET_NAME('IBY', 'IBY_204401_VAL_LEVEL_ERROR');
4172: FND_MSG_PUB.Add;
4173: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4174: END IF;
4175:
4224: --show_table_debug(l_values);
4225:
4226: --Raising Exception to handle errors in unpacking resulting html file.
4227: IF (l_status = -1) THEN
4228: FND_MESSAGE.SET_NAME('IBY', 'IBY_204403_HTML_UNPACK_ERROR');
4229: FND_MSG_PUB.Add;
4230: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4231: END IF;
4232:
4231: END IF;
4232:
4233: --Raising Exception to handle Servlet related errors.
4234: IF (l_names.COUNT = 0) THEN
4235: FND_MESSAGE.SET_NAME('IBY', 'IBY_204402_JSERVLET_ERROR');
4236: FND_MSG_PUB.Add;
4237: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4238: END IF;
4239:
4397: p_api_version,
4398: l_api_name,
4399: G_PKG_NAME )
4400: THEN
4401: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
4402: FND_MSG_PUB.Add;
4403: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4404: END IF;
4405:
4409: END IF;
4410:
4411: -- Verifying if validation level is FULL, which is expected for PUBLIC APIs.
4412: IF (p_validation_level <> g_validation_level) THEN
4413: FND_MESSAGE.SET_NAME('IBY', 'IBY_204401_VAL_LEVEL_ERROR');
4414: FND_MSG_PUB.Add;
4415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4416: END IF;
4417:
4421: --
4422: -- Verifying if the batch size exceeded max.
4423: -- The batch size has exceeded the max limit size.
4424: IF (p_capturetrxn_rec_tbl.count > C_MAX_CC_BATCH_SIZE) THEN
4425: FND_MESSAGE.SET_NAME('IBY', 'IBY_204407_VAL_ERROR');
4426: FND_MSG_PUB.Add;
4427: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4428: END IF;
4429:
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;
4608: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4609: END IF;
4610:
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;
4620: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4621: END IF;
4622: -- Assign output parameters to output record x_capresp_rec_tbl
4713: -- setting dummy message so that the results
4714: -- from the EC Servlet/Java engine can be returned
4715: -- verbatim
4716: --
4717: FND_MESSAGE.SET_NAME('IBY', 'IBY_9999');
4718: FND_MESSAGE.SET_TOKEN('MESSAGE_TEXT', l_batch_msg);
4719: FND_MSG_PUB.ADD;
4720: ELSE
4721: -- no error message; assuming a complete communication
4714: -- from the EC Servlet/Java engine can be returned
4715: -- verbatim
4716: --
4717: FND_MESSAGE.SET_NAME('IBY', 'IBY_9999');
4718: FND_MESSAGE.SET_TOKEN('MESSAGE_TEXT', l_batch_msg);
4719: FND_MSG_PUB.ADD;
4720: ELSE
4721: -- no error message; assuming a complete communication
4722: -- failure where the iPayment URL is bad but the webserver
4721: -- no error message; assuming a complete communication
4722: -- failure where the iPayment URL is bad but the webserver
4723: -- is up and returns a parseable error page
4724: --
4725: FND_MESSAGE.SET_NAME('IBY', 'IBY_0001');
4726: FND_MSG_PUB.Add;
4727: END IF;
4728:
4729: END IF;
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;
4890: END IF;
4891:
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;
4901: END IF;
4902: