[Home] [Help]
186: */
187:
188: IF (p_value is NULL) THEN
189: --Note: Reused an existing IBY message and token.
190: FND_MESSAGE.SET_NAME('IBY', 'IBY_0004');
191: FND_MESSAGE.SET_TOKEN('FIELD', p_name);
192: FND_MSG_PUB.Add;
193:
194: -- jleybovi [10/24/00]
187:
188: IF (p_value is NULL) THEN
189: --Note: Reused an existing IBY message and token.
190: FND_MESSAGE.SET_NAME('IBY', 'IBY_0004');
191: FND_MESSAGE.SET_TOKEN('FIELD', p_name);
192: FND_MSG_PUB.Add;
193:
194: -- jleybovi [10/24/00]
195: --
214: --
215: -- catch any of the conversion errors that may
216: -- have occured here
217: --
218: FND_MESSAGE.SET_NAME('IBY', 'IBY_204011');
219: FND_MESSAGE.SET_TOKEN('FIELD', 'NLS_LANG');
220: FND_MSG_PUB.Add;
221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
222: */
215: -- catch any of the conversion errors that may
216: -- have occured here
217: --
218: FND_MESSAGE.SET_NAME('IBY', 'IBY_204011');
219: FND_MESSAGE.SET_TOKEN('FIELD', 'NLS_LANG');
220: FND_MSG_PUB.Add;
221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
222: */
223: WHEN OTHERS THEN
270: --
271: -- catch any of the conversion errors that may
272: -- have occured here
273: --
274: FND_MESSAGE.SET_NAME('IBY', 'IBY_204011');
275: FND_MESSAGE.SET_TOKEN('FIELD', 'NLS_LANG');
276: FND_MSG_PUB.Add;
277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
278: */
271: -- catch any of the conversion errors that may
272: -- have occured here
273: --
274: FND_MESSAGE.SET_NAME('IBY', 'IBY_204011');
275: FND_MESSAGE.SET_TOKEN('FIELD', 'NLS_LANG');
276: FND_MSG_PUB.Add;
277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
278: */
279: WHEN OTHERS THEN
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;
471: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
472: END IF;
473:
620: EXCEPTION
621: WHEN UTL_HTTP.REQUEST_FAILED THEN
622:
623: --FND_MSG_PUB.Add_Exc_Msg(p_error_text => SQLCODE||':-:'||SQLERRM);
624: FND_MESSAGE.SET_NAME('IBY', 'IBY_0001');
625: FND_MSG_PUB.Add;
626: -- x_return_status := 3 ;
627: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
628:
728: p_api_version,
729: l_api_name,
730: G_PKG_NAME )
731: THEN
732: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
733: FND_MSG_PUB.Add;
734: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
735: END IF;
736:
740: END IF;
741:
742: -- Verifying if validation level is FULL, which is expected for PUBLIC APIs.
743: IF (p_validation_level <> g_validation_level) THEN
744: FND_MESSAGE.SET_NAME('IBY', 'IBY_204401_VAL_LEVEL_ERROR');
745: FND_MSG_PUB.Add;
746: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
747: END IF;
748:
963: IF (l_status = -1) THEN
964: iby_debug_pub.add(debug_msg => 'Unpack status error; HTML resp. invalid!',
965: debug_level => FND_LOG.LEVEL_UNEXPECTED,
966: module => G_DEBUG_MODULE || '.OraPmtReq');
967: FND_MESSAGE.SET_NAME('IBY', 'IBY_204403_HTML_UNPACK_ERROR');
968: FND_MSG_PUB.Add;
969: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
970: END IF;
971:
973: IF (l_names.COUNT = 0) THEN
974: iby_debug_pub.add(debug_msg => 'HTML response names count=0',
975: debug_level => FND_LOG.LEVEL_UNEXPECTED,
976: module => G_DEBUG_MODULE || '.OraPmtReq');
977: FND_MESSAGE.SET_NAME('IBY', 'IBY_204402_JSERVLET_ERROR');
978: FND_MSG_PUB.Add;
979: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
980: END IF;
981:
1233: p_api_version,
1234: l_api_name,
1235: G_PKG_NAME )
1236: THEN
1237: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
1238: FND_MSG_PUB.Add;
1239: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1240: END IF;
1241:
1245: END IF;
1246:
1247: -- Verifying if validation level is FULL, which is expected for PUBLIC APIs.
1248: IF (p_validation_level <> g_validation_level) THEN
1249: FND_MESSAGE.SET_NAME('IBY', 'IBY_204401_VAL_LEVEL_ERROR');
1250: FND_MSG_PUB.Add;
1251: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1252: END IF;
1253:
1296:
1297: --Raising Exception to handle errors in unpacking resulting html file.
1298: IF (l_status = -1) THEN
1299: iby_debug_pub.add('Unpack status error; HTML resp. invalid!',FND_LOG.LEVEL_UNEXPECTED,l_dbg_mod);
1300: FND_MESSAGE.SET_NAME('IBY', 'IBY_204403_HTML_UNPACK_ERROR');
1301: FND_MSG_PUB.Add;
1302: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1303: END IF;
1304:
1304:
1305: --Raising Exception to handle Servlet related errors.
1306: IF (l_names.COUNT = 0) THEN
1307: iby_debug_pub.add('HTML response names count=0',FND_LOG.LEVEL_UNEXPECTED,l_dbg_mod);
1308: FND_MESSAGE.SET_NAME('IBY', 'IBY_204402_JSERVLET_ERROR');
1309: FND_MSG_PUB.Add;
1310: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1311: END IF;
1312: /* Retrieve name-value pairs stored in l_names and l_values, and assign
1515: p_api_version,
1516: l_api_name,
1517: G_PKG_NAME )
1518: THEN
1519: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
1520: FND_MSG_PUB.Add;
1521: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1522: END IF;
1523:
1527: END IF;
1528:
1529: -- Verifying if validation level is FULL, which is expected for PUBLIC APIs.
1530: IF (p_validation_level <> g_validation_level) THEN
1531: FND_MESSAGE.SET_NAME('IBY', 'IBY_204401_VAL_LEVEL_ERROR');
1532: FND_MSG_PUB.Add;
1533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1534: END IF;
1535:
1631: UNPACK_RESULTS_URL(l_html,l_names,l_values, l_status, l_errcode, l_errmessage);
1632:
1633: --Raising Exception to handle errors in unpacking resulting html file.
1634: IF (l_status = -1) THEN
1635: FND_MESSAGE.SET_NAME('IBY', 'IBY_204403_HTML_UNPACK_ERROR');
1636: FND_MSG_PUB.Add;
1637: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1638: END IF;
1639:
1638: END IF;
1639:
1640: --Raising Exception to handle Servlet related errors.
1641: IF (l_names.COUNT = 0) THEN
1642: FND_MESSAGE.SET_NAME('IBY', 'IBY_204402_JSERVLET_ERROR');
1643: FND_MSG_PUB.Add;
1644: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1645: END IF;
1646:
1788: p_api_version,
1789: l_api_name,
1790: G_PKG_NAME )
1791: THEN
1792: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
1793: FND_MSG_PUB.Add;
1794: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1795: END IF;
1796:
1800: END IF;
1801:
1802: -- Verifying if validation level is FULL, which is expected for PUBLIC APIs.
1803: IF (p_validation_level <> g_validation_level) THEN
1804: FND_MESSAGE.SET_NAME('IBY', 'IBY_204401_VAL_LEVEL_ERROR');
1805: FND_MSG_PUB.Add;
1806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1807: END IF;
1808:
1837: FETCH pmtcanc_csr
1838: INTO l_pmtinstr_type;
1839:
1840: IF (pmtcanc_csr%ROWCOUNT = 0) THEN
1841: FND_MESSAGE.SET_NAME('IBY', 'IBY_204404_CURSOR_ERROR');
1842: FND_MSG_PUB.Add;
1843: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1844: END IF;
1845:
1867: UNPACK_RESULTS_URL(l_html,l_names,l_values, l_status, l_errcode, l_errmessage);
1868:
1869: --Raising Exception to handle errors in unpacking resulting html file.
1870: IF (l_status = -1) THEN
1871: FND_MESSAGE.SET_NAME('IBY', 'IBY_204403_HTML_UNPACK_ERROR');
1872: FND_MSG_PUB.Add;
1873: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1874: END IF;
1875:
1874: END IF;
1875:
1876: --Raising Exception to handle Servlet related errors.
1877: IF (l_names.COUNT = 0) THEN
1878: FND_MESSAGE.SET_NAME('IBY', 'IBY_204402_JSERVLET_ERROR');
1879: FND_MSG_PUB.Add;
1880: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1881: END IF;
1882:
2040: p_api_version,
2041: l_api_name,
2042: G_PKG_NAME )
2043: THEN
2044: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
2045: FND_MSG_PUB.Add;
2046: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2047: END IF;
2048:
2052: END IF;
2053:
2054: -- Verifying if validation level is FULL, which is expected for PUBLIC APIs.
2055: IF (p_validation_level <> g_validation_level) THEN
2056: FND_MESSAGE.SET_NAME('IBY', 'IBY_204401_VAL_LEVEL_ERROR');
2057: FND_MSG_PUB.Add;
2058: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2059: END IF;
2060:
2090: FETCH pmtqrytrxn_csr
2091: INTO l_pmtinstr_type;
2092:
2093: IF (pmtqrytrxn_csr%ROWCOUNT = 0) THEN
2094: FND_MESSAGE.SET_NAME('IBY', 'IBY_204404_CURSOR_ERROR');
2095: FND_MSG_PUB.Add;
2096: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2097: END IF;
2098:
2124: UNPACK_RESULTS_URL(l_html,l_names,l_values, l_status, l_errcode, l_errmessage);
2125:
2126: --Raising Exception to handle errors in unpacking resulting html file.
2127: IF (l_status = -1) THEN
2128: FND_MESSAGE.SET_NAME('IBY', 'IBY_204403_HTML_UNPACK_ERROR');
2129: FND_MSG_PUB.Add;
2130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2131: END IF;
2132:
2131: END IF;
2132:
2133: --Raising Exception to handle Servlet related errors.
2134: IF (l_names.COUNT = 0) THEN
2135: FND_MESSAGE.SET_NAME('IBY', 'IBY_204402_JSERVLET_ERROR');
2136: FND_MSG_PUB.Add;
2137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2138: END IF;
2139:
2336: p_api_version,
2337: l_api_name,
2338: G_PKG_NAME )
2339: THEN
2340: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
2341: FND_MSG_PUB.Add;
2342: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2343: END IF;
2344:
2348: END IF;
2349:
2350: -- Verifying if validation level is FULL, which is expected for PUBLIC APIs.
2351: IF (p_validation_level <> g_validation_level) THEN
2352: FND_MESSAGE.SET_NAME('IBY', 'IBY_204401_VAL_LEVEL_ERROR');
2353: FND_MSG_PUB.Add;
2354: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2355: END IF;
2356:
2416:
2417:
2418: --Raising Exception to handle errors in unpacking resulting html file.
2419: IF (l_status = -1) THEN
2420: FND_MESSAGE.SET_NAME('IBY', 'IBY_204403_HTML_UNPACK_ERROR');
2421: FND_MSG_PUB.Add;
2422: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2423: END IF;
2424:
2423: END IF;
2424:
2425: --Raising Exception to handle Servlet related errors.
2426: IF (l_names.COUNT = 0) THEN
2427: FND_MESSAGE.SET_NAME('IBY', 'IBY_204402_JSERVLET_ERROR');
2428: FND_MSG_PUB.Add;
2429: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2430: END IF;
2431:
2586: p_api_version,
2587: l_api_name,
2588: G_PKG_NAME )
2589: THEN
2590: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
2591: FND_MSG_PUB.Add;
2592: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2593: END IF;
2594:
2598: END IF;
2599:
2600: -- Verifying if validation level is FULL, which is expected for PUBLIC APIs.
2601: IF (p_validation_level <> g_validation_level) THEN
2602: FND_MESSAGE.SET_NAME('IBY', 'IBY_204401_VAL_LEVEL_ERROR');
2603: FND_MSG_PUB.Add;
2604: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2605: END IF;
2606:
2661: UNPACK_RESULTS_URL(l_html,l_names,l_values, l_status, l_errcode, l_errmessage);
2662:
2663: --Raising Exception to handle errors in unpacking resulting html file.
2664: IF (l_status = -1) THEN
2665: FND_MESSAGE.SET_NAME('IBY', 'IBY_204403_HTML_UNPACK_ERROR');
2666: FND_MSG_PUB.Add;
2667: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2668: END IF;
2669:
2668: END IF;
2669:
2670: --Raising Exception to handle Servlet related errors.
2671: IF (l_names.COUNT = 0) THEN
2672: FND_MESSAGE.SET_NAME('IBY', 'IBY_204402_JSERVLET_ERROR');
2673: FND_MSG_PUB.Add;
2674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2675: END IF;
2676:
2831: p_api_version,
2832: l_api_name,
2833: G_PKG_NAME )
2834: THEN
2835: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
2836: FND_MSG_PUB.Add;
2837: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2838: END IF;
2839:
2843: END IF;
2844:
2845: -- Verifying if validation level is FULL, which is expected for PUBLIC APIs.
2846: IF (p_validation_level <> g_validation_level) THEN
2847: FND_MESSAGE.SET_NAME('IBY', 'IBY_204401_VAL_LEVEL_ERROR');
2848: FND_MSG_PUB.Add;
2849: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2850: END IF;
2851:
2913: --show_table_debug(l_values);
2914:
2915: --Raising Exception to handle errors in unpacking resulting html file.
2916: IF (l_status = -1) THEN
2917: FND_MESSAGE.SET_NAME('IBY', 'IBY_204403_HTML_UNPACK_ERROR');
2918: FND_MSG_PUB.Add;
2919: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2920: END IF;
2921:
2920: END IF;
2921:
2922: --Raising Exception to handle Servlet related errors.
2923: IF (l_names.COUNT = 0) THEN
2924: FND_MESSAGE.SET_NAME('IBY', 'IBY_204402_JSERVLET_ERROR');
2925: FND_MSG_PUB.Add;
2926: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2927: END IF;
2928:
3110: p_api_version,
3111: l_api_name,
3112: G_PKG_NAME )
3113: THEN
3114: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
3115: FND_MSG_PUB.Add;
3116: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3117: END IF;
3118:
3122: END IF;
3123:
3124: -- Verifying if validation level is FULL, which is expected for PUBLIC APIs.
3125: IF (p_validation_level <> g_validation_level) THEN
3126: FND_MESSAGE.SET_NAME('IBY', 'IBY_204401_VAL_LEVEL_ERROR');
3127: FND_MSG_PUB.Add;
3128: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3129: END IF;
3130:
3226: UNPACK_RESULTS_URL(l_html,l_names,l_values, l_status, l_errcode, l_errmessage);
3227:
3228: --Raising Exception to handle errors in unpacking resulting html file.
3229: IF (l_status = -1) THEN
3230: FND_MESSAGE.SET_NAME('IBY', 'IBY_204403_HTML_UNPACK_ERROR');
3231: FND_MSG_PUB.Add;
3232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3233: END IF;
3234:
3233: END IF;
3234:
3235: --Raising Exception to handle Servlet related errors.
3236: IF (l_names.COUNT = 0) THEN
3237: FND_MESSAGE.SET_NAME('IBY', 'IBY_204402_JSERVLET_ERROR');
3238: FND_MSG_PUB.Add;
3239: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3240: END IF;
3241:
3399: p_api_version,
3400: l_api_name,
3401: G_PKG_NAME )
3402: THEN
3403: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
3404: FND_MSG_PUB.Add;
3405: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3406: END IF;
3407:
3411: END IF;
3412:
3413: -- Verifying if validation level is FULL, which is expected for PUBLIC APIs.
3414: IF (p_validation_level <> g_validation_level) THEN
3415: FND_MESSAGE.SET_NAME('IBY', 'IBY_204401_VAL_LEVEL_ERROR');
3416: FND_MSG_PUB.Add;
3417: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3418: END IF;
3419:
3440: x_inqresp_rec.Response.Status := 3;
3441: -- NOTE: Response.ErrCode, Response.ErrMessage are not populated
3442: -- since that would imply hardcoding the message text here (NLS issues)
3443: -- Instead it is sent to the API message list.
3444: FND_MESSAGE.SET_NAME('IBY', 'IBY_204404_CURSOR_ERROR');
3445: FND_MSG_PUB.Add;
3446: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3447: END IF;
3448:
3570: p_api_version,
3571: l_api_name,
3572: G_PKG_NAME )
3573: THEN
3574: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
3575: FND_MSG_PUB.Add;
3576: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3577: END IF;
3578:
3582: END IF;
3583:
3584: -- Verifying if validation level is FULL, which is expected for PUBLIC APIs.
3585: IF (p_validation_level <> g_validation_level) THEN
3586: FND_MESSAGE.SET_NAME('IBY', 'IBY_204401_VAL_LEVEL_ERROR');
3587: FND_MSG_PUB.Add;
3588: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3589: END IF;
3590:
3660: UNPACK_RESULTS_URL(l_html,l_names,l_values, l_status, l_errcode, l_errmessage);
3661:
3662: --Raising Exception to handle errors in unpacking resulting html file.
3663: IF (l_status = -1) THEN
3664: FND_MESSAGE.SET_NAME('IBY', 'IBY_204403_HTML_UNPACK_ERROR');
3665: FND_MSG_PUB.Add;
3666: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3667: END IF;
3668:
3667: END IF;
3668:
3669: --Raising Exception to handle Servlet related errors.
3670: IF (l_names.COUNT = 0) THEN
3671: FND_MESSAGE.SET_NAME('IBY', 'IBY_204402_JSERVLET_ERROR');
3672: FND_MSG_PUB.Add;
3673: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3674: END IF;
3675:
3883: p_api_version,
3884: l_api_name,
3885: G_PKG_NAME )
3886: THEN
3887: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
3888: FND_MSG_PUB.Add;
3889: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3890: END IF;
3891:
3895: END IF;
3896:
3897: -- Verifying if validation level is FULL, which is expected for PUBLIC APIs.
3898: IF (p_validation_level <> g_validation_level) THEN
3899: FND_MESSAGE.SET_NAME('IBY', 'IBY_204401_VAL_LEVEL_ERROR');
3900: FND_MSG_PUB.Add;
3901: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3902: END IF;
3903:
3962: UNPACK_RESULTS_URL(l_html,l_names,l_values, l_status, l_errcode, l_errmessage);
3963:
3964: --Raising Exception to handle errors in unpacking resulting html file.
3965: IF (l_status = -1) THEN
3966: FND_MESSAGE.SET_NAME('IBY', 'IBY_204403_HTML_UNPACK_ERROR');
3967: FND_MSG_PUB.Add;
3968: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3969: END IF;
3970:
3969: END IF;
3970:
3971: --Raising Exception to handle Servlet related errors.
3972: IF (l_names.COUNT = 0) THEN
3973: FND_MESSAGE.SET_NAME('IBY', 'IBY_204402_JSERVLET_ERROR');
3974: FND_MSG_PUB.Add;
3975: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3976: END IF;
3977:
4240: p_api_version,
4241: l_api_name,
4242: G_PKG_NAME )
4243: THEN
4244: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
4245: FND_MSG_PUB.Add;
4246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4247: END IF;
4248:
4252: END IF;
4253:
4254: -- Verifying if validation level is FULL, which is expected for PUBLIC APIs.
4255: IF (p_validation_level <> g_validation_level) THEN
4256: FND_MESSAGE.SET_NAME('IBY', 'IBY_204401_VAL_LEVEL_ERROR');
4257: FND_MSG_PUB.Add;
4258: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4259: END IF;
4260:
4319: --show_table_debug(l_values);
4320:
4321: --Raising Exception to handle errors in unpacking resulting html file.
4322: IF (l_status = -1) THEN
4323: FND_MESSAGE.SET_NAME('IBY', 'IBY_204403_HTML_UNPACK_ERROR');
4324: FND_MSG_PUB.Add;
4325: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4326: END IF;
4327:
4326: END IF;
4327:
4328: --Raising Exception to handle Servlet related errors.
4329: IF (l_names.COUNT = 0) THEN
4330: FND_MESSAGE.SET_NAME('IBY', 'IBY_204402_JSERVLET_ERROR');
4331: FND_MSG_PUB.Add;
4332: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4333: END IF;
4334:
4476: p_api_version,
4477: l_api_name,
4478: G_PKG_NAME )
4479: THEN
4480: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
4481: FND_MSG_PUB.Add;
4482: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4483: END IF;
4484:
4488: END IF;
4489:
4490: -- Verifying if validation level is FULL, which is expected for PUBLIC APIs.
4491: IF (p_validation_level <> g_validation_level) THEN
4492: FND_MESSAGE.SET_NAME('IBY', 'IBY_204401_VAL_LEVEL_ERROR');
4493: FND_MSG_PUB.Add;
4494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4495: END IF;
4496:
4545: --show_table_debug(l_values);
4546:
4547: --Raising Exception to handle errors in unpacking resulting html file.
4548: IF (l_status = -1) THEN
4549: FND_MESSAGE.SET_NAME('IBY', 'IBY_204403_HTML_UNPACK_ERROR');
4550: FND_MSG_PUB.Add;
4551: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4552: END IF;
4553:
4552: END IF;
4553:
4554: --Raising Exception to handle Servlet related errors.
4555: IF (l_names.COUNT = 0) THEN
4556: FND_MESSAGE.SET_NAME('IBY', 'IBY_204402_JSERVLET_ERROR');
4557: FND_MSG_PUB.Add;
4558: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4559: END IF;
4560:
4718: p_api_version,
4719: l_api_name,
4720: G_PKG_NAME )
4721: THEN
4722: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
4723: FND_MSG_PUB.Add;
4724: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4725: END IF;
4726:
4730: END IF;
4731:
4732: -- Verifying if validation level is FULL, which is expected for PUBLIC APIs.
4733: IF (p_validation_level <> g_validation_level) THEN
4734: FND_MESSAGE.SET_NAME('IBY', 'IBY_204401_VAL_LEVEL_ERROR');
4735: FND_MSG_PUB.Add;
4736: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4737: END IF;
4738:
4742: --
4743: -- Verifying if the batch size exceeded max.
4744: -- The batch size has exceeded the max limit size.
4745: IF (p_capturetrxn_rec_tbl.count > C_MAX_CC_BATCH_SIZE) THEN
4746: FND_MESSAGE.SET_NAME('IBY', 'IBY_204407_VAL_ERROR');
4747: FND_MSG_PUB.Add;
4748: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4749: END IF;
4750:
4923: iby_debug_pub.add('error unpacking results',
4924: FND_LOG.LEVEL_UNEXPECTED,
4925: G_DEBUG_MODULE || '.OraCCBatchCapture');
4926:
4927: FND_MESSAGE.SET_NAME('IBY', 'IBY_204403_HTML_UNPACK_ERROR');
4928: FND_MSG_PUB.Add;
4929: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4930: END IF;
4931:
4935: iby_debug_pub.add('servlet errors; no names returned',
4936: FND_LOG.LEVEL_UNEXPECTED,
4937: G_DEBUG_MODULE || '.OraCCBatchCapture');
4938:
4939: FND_MESSAGE.SET_NAME('IBY', 'IBY_204402_JSERVLET_ERROR');
4940: FND_MSG_PUB.Add;
4941: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4942: END IF;
4943: -- Assign output parameters to output record x_capresp_rec_tbl
5034: -- setting dummy message so that the results
5035: -- from the EC Servlet/Java engine can be returned
5036: -- verbatim
5037: --
5038: FND_MESSAGE.SET_NAME('IBY', 'IBY_9999');
5039: FND_MESSAGE.SET_TOKEN('MESSAGE_TEXT', l_batch_msg);
5040: FND_MSG_PUB.ADD;
5041: ELSE
5042: -- no error message; assuming a complete communication
5035: -- from the EC Servlet/Java engine can be returned
5036: -- verbatim
5037: --
5038: FND_MESSAGE.SET_NAME('IBY', 'IBY_9999');
5039: FND_MESSAGE.SET_TOKEN('MESSAGE_TEXT', l_batch_msg);
5040: FND_MSG_PUB.ADD;
5041: ELSE
5042: -- no error message; assuming a complete communication
5043: -- failure where the iPayment URL is bad but the webserver
5042: -- no error message; assuming a complete communication
5043: -- failure where the iPayment URL is bad but the webserver
5044: -- is up and returns a parseable error page
5045: --
5046: FND_MESSAGE.SET_NAME('IBY', 'IBY_0001');
5047: FND_MSG_PUB.Add;
5048: END IF;
5049:
5050: END IF;
5204: --test_debug('unpack error !!');
5205: iby_debug_pub.add(debug_msg => 'Unpack status error; HTML resp. invalid!',
5206: debug_level => FND_LOG.LEVEL_UNEXPECTED,
5207: module => G_DEBUG_MODULE || '.OraSecureExtension');
5208: FND_MESSAGE.SET_NAME('IBY', 'IBY_204403_HTML_UNPACK_ERROR');
5209: FND_MSG_PUB.Add;
5210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5211: END IF;
5212:
5215: --test_debug('response count is 0 !!');
5216: iby_debug_pub.add(debug_msg => 'HTML response names count=0',
5217: debug_level => FND_LOG.LEVEL_UNEXPECTED,
5218: module => G_DEBUG_MODULE || '.OraSecureExtension');
5219: FND_MESSAGE.SET_NAME('IBY', 'IBY_204402_JSERVLET_ERROR');
5220: FND_MSG_PUB.Add;
5221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5222: END IF;
5223: