[Home] [Help]
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: --
192: -- should return an expected error exception here as missing input is
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
220: p_url := l_url;
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
276: p_url := l_url;
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:
440: --appending '?' if not already present in the url
585:
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;
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:
595: END send_request;
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:
701: -- Initialize message list if p_init_msg_list is set to TRUE.
699: END IF;
700:
701: -- Initialize message list if p_init_msg_list is set to TRUE.
702: IF FND_API.to_Boolean( p_init_msg_list ) THEN
703: FND_MSG_PUB.initialize;
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
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:
713: -- Initialize API return status to success
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:
917: --Raising Exception to handle Servlet related errors.
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:
927: /* Retrieve name-value pairs stored in l_names and l_values, and assign
1052: END IF;
1053: */
1054:
1055: -- Standard call to get message count and if count is 1, get message info.
1056: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1057: p_data => x_msg_data
1058: );
1059:
1060: iby_debug_pub.add(debug_msg => 'x_return_status=' || x_return_status,
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,
1081: p_data => x_msg_data
1082: );
1083: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1084:
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,
1091: p_data => x_msg_data
1092: );
1093: WHEN OTHERS THEN
1094:
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
1101: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
1102: END IF;
1103:
1104: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
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
1101: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
1102: END IF;
1103:
1104: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1105: p_data => x_msg_data
1100: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1101: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
1102: END IF;
1103:
1104: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1105: p_data => x_msg_data
1106: );
1107:
1108: iby_debug_pub.add(debug_msg => 'x_return_status=' || x_return_status,
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:
1206: -- Initialize message list if p_init_msg_list is set to TRUE.
1204: END IF;
1205:
1206: -- Initialize message list if p_init_msg_list is set to TRUE.
1207: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1208: FND_MSG_PUB.initialize;
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
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:
1218: -- Initialize API return status to success
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:
1321: --Raising Exception to handle Servlet related errors.
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:
1328: /* Retrieve name-value pairs stored in l_names and l_values, and assign
1358: END IF;
1359: */
1360:
1361: -- Standard call to get message count and if count is 1, get message info.
1362: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1363: p_data => x_msg_data
1364: );
1365: EXCEPTION
1366:
1367:
1368: WHEN FND_API.G_EXC_ERROR THEN
1369: --ROLLBACK TO OraPmtMod_PUB;
1370: x_return_status := FND_API.G_RET_STS_ERROR ;
1371: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1372: p_data => x_msg_data
1373: );
1374: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1375: --ROLLBACK TO OraPmtMod_PUB;
1373: );
1374: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1375: --ROLLBACK TO OraPmtMod_PUB;
1376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1377: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1378: p_data => x_msg_data
1379: );
1380: WHEN OTHERS THEN
1381: --ROLLBACK TO OraPmtMod_PUB;
1379: );
1380: WHEN OTHERS THEN
1381: --ROLLBACK TO OraPmtMod_PUB;
1382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1383: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1384: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
1385: END IF;
1386:
1387: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1380: WHEN OTHERS THEN
1381: --ROLLBACK TO OraPmtMod_PUB;
1382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1383: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1384: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
1385: END IF;
1386:
1387: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1388: p_data => x_msg_data
1383: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1384: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
1385: END IF;
1386:
1387: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1388: p_data => x_msg_data
1389: );
1390:
1391: END OraPmtMod;
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:
1478: -- Initialize message list if p_init_msg_list is set to TRUE.
1476: END IF;
1477:
1478: -- Initialize message list if p_init_msg_list is set to TRUE.
1479: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1480: FND_MSG_PUB.initialize;
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
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:
1490: -- Initialize API return status to success
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:
1527: CLOSE pmtcanc_csr;
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:
1557: --Raising Exception to handle Servlet related errors.
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:
1564: --show_table_debug(l_names);
1607: END IF;
1608: */
1609:
1610: -- Standard call to get message count and if count is 1, get message info.
1611: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1612: p_data => x_msg_data
1613: );
1614: EXCEPTION
1615: WHEN FND_API.G_EXC_ERROR THEN
1614: EXCEPTION
1615: WHEN FND_API.G_EXC_ERROR THEN
1616: --ROLLBACK TO OraPmtCanc_PUB;
1617: x_return_status := FND_API.G_RET_STS_ERROR ;
1618: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1619: p_data => x_msg_data
1620: );
1621: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1622: --ROLLBACK TO OraPmtCanc_PUB;
1620: );
1621: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1622: --ROLLBACK TO OraPmtCanc_PUB;
1623: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1624: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1625: p_data => x_msg_data
1626: );
1627: WHEN OTHERS THEN
1628: --ROLLBACK TO OraPmtCanc_PUB;
1626: );
1627: WHEN OTHERS THEN
1628: --ROLLBACK TO OraPmtCanc_PUB;
1629: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1630: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1631: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
1632: END IF;
1633:
1634: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1627: WHEN OTHERS THEN
1628: --ROLLBACK TO OraPmtCanc_PUB;
1629: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1630: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1631: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
1632: END IF;
1633:
1634: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1635: p_data => x_msg_data
1630: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1631: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
1632: END IF;
1633:
1634: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1635: p_data => x_msg_data
1636: );
1637:
1638: END OraPmtCanc;
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:
1730: -- Initialize message list if p_init_msg_list is set to TRUE.
1728: END IF;
1729:
1730: -- Initialize message list if p_init_msg_list is set to TRUE.
1731: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1732: FND_MSG_PUB.initialize;
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
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:
1742:
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:
1780: CLOSE pmtqrytrxn_csr;
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:
1814: --Raising Exception to handle Servlet related errors.
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:
1821: --show_table_debug(l_names);
1914: END IF;
1915: */
1916:
1917: -- Standard call to get message count and if count is 1, get message info.
1918: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1919: p_data => x_msg_data
1920: );
1921: EXCEPTION
1922: WHEN FND_API.G_EXC_ERROR THEN
1921: EXCEPTION
1922: WHEN FND_API.G_EXC_ERROR THEN
1923: --ROLLBACK TO OraPmtQryTrxn_PUB;
1924: x_return_status := FND_API.G_RET_STS_ERROR ;
1925: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1926: p_data => x_msg_data
1927: );
1928: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1929: --ROLLBACK TO OraPmtQryTrxn_PUB;
1927: );
1928: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1929: --ROLLBACK TO OraPmtQryTrxn_PUB;
1930: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1931: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1932: p_data => x_msg_data
1933: );
1934: WHEN OTHERS THEN
1935: --ROLLBACK TO OraPmtQryTrxn_PUB;
1933: );
1934: WHEN OTHERS THEN
1935: --ROLLBACK TO OraPmtQryTrxn_PUB;
1936: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1937: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1938: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
1939: END IF;
1940:
1941: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1934: WHEN OTHERS THEN
1935: --ROLLBACK TO OraPmtQryTrxn_PUB;
1936: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1937: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1938: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
1939: END IF;
1940:
1941: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1942: p_data => x_msg_data
1937: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1938: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
1939: END IF;
1940:
1941: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1942: p_data => x_msg_data
1943: );
1944:
1945: END OraPmtQryTrxn;
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:
2026: -- Initialize message list if p_init_msg_list is set to TRUE.
2024: END IF;
2025:
2026: -- Initialize message list if p_init_msg_list is set to TRUE.
2027: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2028: FND_MSG_PUB.initialize;
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
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:
2038: -- Initialize API return status to success
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:
2106: --Raising Exception to handle Servlet related errors.
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:
2113: -- Assign output parameters to output record x_capresp_rec
2164: END IF;
2165: */
2166:
2167: -- Standard call to get message count and if count is 1, get message info.
2168: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2169: p_data => x_msg_data
2170: );
2171: EXCEPTION
2172: WHEN FND_API.G_EXC_ERROR THEN
2171: EXCEPTION
2172: WHEN FND_API.G_EXC_ERROR THEN
2173: --ROLLBACK TO OraPmtCapture_PUB;
2174: x_return_status := FND_API.G_RET_STS_ERROR ;
2175: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2176: p_data => x_msg_data
2177: );
2178: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2179: --ROLLBACK TO OraPmtCapture_PUB;
2177: );
2178: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2179: --ROLLBACK TO OraPmtCapture_PUB;
2180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2181: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2182: p_data => x_msg_data
2183: );
2184: WHEN OTHERS THEN
2185: --ROLLBACK TO OraPmtCapture_PUB;
2183: );
2184: WHEN OTHERS THEN
2185: --ROLLBACK TO OraPmtCapture_PUB;
2186: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2187: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2188: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
2189: END IF;
2190:
2191: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2184: WHEN OTHERS THEN
2185: --ROLLBACK TO OraPmtCapture_PUB;
2186: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2187: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2188: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
2189: END IF;
2190:
2191: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2192: p_data => x_msg_data
2187: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2188: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
2189: END IF;
2190:
2191: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2192: p_data => x_msg_data
2193: );
2194:
2195: END OraPmtCapture;
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:
2276: -- Initialize message list if p_init_msg_list is set to TRUE.
2274: END IF;
2275:
2276: -- Initialize message list if p_init_msg_list is set to TRUE.
2277: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2278: FND_MSG_PUB.initialize;
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
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:
2288:
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:
2351: --Raising Exception to handle Servlet related errors.
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:
2358: -- Assign output parameters to output record x_retresp_rec
2408: END IF;
2409: */
2410:
2411: -- Standard call to get message count and if count is 1, get message info.
2412: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2413: p_data => x_msg_data
2414: );
2415: EXCEPTION
2416: WHEN FND_API.G_EXC_ERROR THEN
2415: EXCEPTION
2416: WHEN FND_API.G_EXC_ERROR THEN
2417: --ROLLBACK TO OraPmtReturn_PUB;
2418: x_return_status := FND_API.G_RET_STS_ERROR ;
2419: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2420: p_data => x_msg_data
2421: );
2422: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2423: --ROLLBACK TO OraPmtReturn_PUB;
2421: );
2422: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2423: --ROLLBACK TO OraPmtReturn_PUB;
2424: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2425: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2426: p_data => x_msg_data
2427: );
2428: WHEN OTHERS THEN
2429: --ROLLBACK TO OraPmtReturn_PUB;
2427: );
2428: WHEN OTHERS THEN
2429: --ROLLBACK TO OraPmtReturn_PUB;
2430: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2431: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2432: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
2433: END IF;
2434:
2435: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2428: WHEN OTHERS THEN
2429: --ROLLBACK TO OraPmtReturn_PUB;
2430: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2431: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2432: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
2433: END IF;
2434:
2435: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2436: p_data => x_msg_data
2431: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2432: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
2433: END IF;
2434:
2435: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2436: p_data => x_msg_data
2437: );
2438:
2439: END OraPmtReturn;
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:
2521: -- Initialize message list if p_init_msg_list is set to TRUE.
2519: END IF;
2520:
2521: -- Initialize message list if p_init_msg_list is set to TRUE.
2522: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2523: FND_MSG_PUB.initialize;
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
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:
2533: -- Initialize API return status to success
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:
2603: --Raising Exception to handle Servlet related errors.
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:
2610: --dbms_output.put_line('after successful unpacking');
2680: END IF;
2681: */
2682:
2683: -- Standard call to get message count and if count is 1, get message info.
2684: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2685: p_data => x_msg_data
2686: );
2687: EXCEPTION
2688: WHEN FND_API.G_EXC_ERROR THEN
2687: EXCEPTION
2688: WHEN FND_API.G_EXC_ERROR THEN
2689: --ROLLBACK TO OraPmtVoid_PUB;
2690: x_return_status := FND_API.G_RET_STS_ERROR ;
2691: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2692: p_data => x_msg_data
2693: );
2694: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2695: --ROLLBACK TO OraPmtVoid_PUB;
2693: );
2694: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2695: --ROLLBACK TO OraPmtVoid_PUB;
2696: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2697: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2698: p_data => x_msg_data
2699: );
2700: WHEN OTHERS THEN
2701: --ROLLBACK TO OraPmtVoid_PUB;
2699: );
2700: WHEN OTHERS THEN
2701: --ROLLBACK TO OraPmtVoid_PUB;
2702: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2703: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2704: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
2705: END IF;
2706:
2707: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2700: WHEN OTHERS THEN
2701: --ROLLBACK TO OraPmtVoid_PUB;
2702: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2703: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2704: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
2705: END IF;
2706:
2707: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2708: p_data => x_msg_data
2703: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2704: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
2705: END IF;
2706:
2707: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2708: p_data => x_msg_data
2709: );
2710:
2711: END OraPmtVoid;
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:
2800: -- Initialize message list if p_init_msg_list is set to TRUE.
2798: END IF;
2799:
2800: -- Initialize message list if p_init_msg_list is set to TRUE.
2801: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2802: FND_MSG_PUB.initialize;
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
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:
2812: -- Initialize API return status to success
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:
2914: --Raising Exception to handle Servlet related errors.
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:
2921: --show_table_debug(l_names);
2975: END IF;
2976: */
2977:
2978: -- Standard call to get message count and if count is 1, get message info.
2979: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2980: p_data => x_msg_data
2981: );
2982: EXCEPTION
2983: WHEN FND_API.G_EXC_ERROR THEN
2982: EXCEPTION
2983: WHEN FND_API.G_EXC_ERROR THEN
2984: --ROLLBACK TO OraPmtCredit_PUB;
2985: x_return_status := FND_API.G_RET_STS_ERROR ;
2986: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2987: p_data => x_msg_data
2988: );
2989: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2990: --ROLLBACK TO OraPmtCredit_PUB;
2988: );
2989: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2990: --ROLLBACK TO OraPmtCredit_PUB;
2991: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2992: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2993: p_data => x_msg_data
2994: );
2995: WHEN OTHERS THEN
2996: --ROLLBACK TO OraPmtCredit_PUB;
2994: );
2995: WHEN OTHERS THEN
2996: --ROLLBACK TO OraPmtCredit_PUB;
2997: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2998: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2999: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
3000: END IF;
3001:
3002: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2995: WHEN OTHERS THEN
2996: --ROLLBACK TO OraPmtCredit_PUB;
2997: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2998: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2999: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
3000: END IF;
3001:
3002: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
3003: p_data => x_msg_data
2998: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2999: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
3000: END IF;
3001:
3002: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
3003: p_data => x_msg_data
3004: );
3005:
3006: END OraPmtCredit;
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:
3087: -- Initialize message list if p_init_msg_list is set to TRUE.
3085: END IF;
3086:
3087: -- Initialize message list if p_init_msg_list is set to TRUE.
3088: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3089: FND_MSG_PUB.initialize;
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
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:
3099: -- Initialize API return status to success
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:
3128: CLOSE pmtinq_csr;
3140: END IF;
3141: */
3142:
3143: -- Standard call to get message count and if count is 1, get message info.
3144: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
3145: p_data => x_msg_data
3146: );
3147: EXCEPTION
3148: WHEN FND_API.G_EXC_ERROR THEN
3147: EXCEPTION
3148: WHEN FND_API.G_EXC_ERROR THEN
3149: --ROLLBACK TO OraPmtInq_PUB;
3150: x_return_status := FND_API.G_RET_STS_ERROR ;
3151: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
3152: p_data => x_msg_data
3153: );
3154: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3155: --ROLLBACK TO OraPmtInq_PUB;
3153: );
3154: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3155: --ROLLBACK TO OraPmtInq_PUB;
3156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3157: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
3158: p_data => x_msg_data
3159: );
3160: WHEN OTHERS THEN
3161: --ROLLBACK TO OraPmtInq_PUB;
3159: );
3160: WHEN OTHERS THEN
3161: --ROLLBACK TO OraPmtInq_PUB;
3162: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3163: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3164: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
3165: END IF;
3166:
3167: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
3160: WHEN OTHERS THEN
3161: --ROLLBACK TO OraPmtInq_PUB;
3162: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3163: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3164: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
3165: END IF;
3166:
3167: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
3168: p_data => x_msg_data
3163: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3164: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
3165: END IF;
3166:
3167: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
3168: p_data => x_msg_data
3169: );
3170:
3171: END OraPmtInq;
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:
3258: -- Initialize message list if p_init_msg_list is set to TRUE.
3256: END IF;
3257:
3258: -- Initialize message list if p_init_msg_list is set to TRUE.
3259: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3260: FND_MSG_PUB.initialize;
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
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:
3270:
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:
3348: --Raising Exception to handle Servlet related errors.
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:
3355: --show_table_debug(l_names);
3455: END IF;
3456: */
3457:
3458: -- Standard call to get message count and if count is 1, get message info.
3459: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
3460: p_data => x_msg_data
3461: );
3462: EXCEPTION
3463: WHEN FND_API.G_EXC_ERROR THEN
3462: EXCEPTION
3463: WHEN FND_API.G_EXC_ERROR THEN
3464: --ROLLBACK TO OraPmtCloseBatch_PUB;
3465: x_return_status := FND_API.G_RET_STS_ERROR ;
3466: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
3467: p_data => x_msg_data
3468: );
3469: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3470: --ROLLBACK TO OraPmtCloseBatch_PUB;
3468: );
3469: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3470: --ROLLBACK TO OraPmtCloseBatch_PUB;
3471: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3472: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
3473: p_data => x_msg_data
3474: );
3475: WHEN OTHERS THEN
3476: --ROLLBACK TO OraPmtCloseBatch_PUB;
3474: );
3475: WHEN OTHERS THEN
3476: --ROLLBACK TO OraPmtCloseBatch_PUB;
3477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3478: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3479: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
3480: END IF;
3481:
3482: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
3475: WHEN OTHERS THEN
3476: --ROLLBACK TO OraPmtCloseBatch_PUB;
3477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3478: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3479: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
3480: END IF;
3481:
3482: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
3483: p_data => x_msg_data
3478: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3479: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
3480: END IF;
3481:
3482: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
3483: p_data => x_msg_data
3484: );
3485:
3486: END OraPmtCloseBatch;
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:
3571: -- Initialize message list if p_init_msg_list is set to TRUE.
3569: END IF;
3570:
3571: -- Initialize message list if p_init_msg_list is set to TRUE.
3572: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3573: FND_MSG_PUB.initialize;
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
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:
3583: -- Initialize API return status to success
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:
3650: --Raising Exception to handle Servlet related errors.
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:
3657: --show_table_debug(l_names);
3751: END IF;
3752: */
3753:
3754: -- Standard call to get message count and if count is 1, get message info.
3755: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
3756: p_data => x_msg_data
3757: );
3758: EXCEPTION
3759: WHEN FND_API.G_EXC_ERROR THEN
3758: EXCEPTION
3759: WHEN FND_API.G_EXC_ERROR THEN
3760: --ROLLBACK TO OraPmtQueryBatch_PUB;
3761: x_return_status := FND_API.G_RET_STS_ERROR ;
3762: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
3763: p_data => x_msg_data
3764: );
3765: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3766: --ROLLBACK TO OraPmtQueryBatch_PUB;
3764: );
3765: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3766: --ROLLBACK TO OraPmtQueryBatch_PUB;
3767: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3768: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
3769: p_data => x_msg_data
3770: );
3771: WHEN OTHERS THEN
3772: --ROLLBACK TO OraPmtQueryBatch_PUB;
3770: );
3771: WHEN OTHERS THEN
3772: --ROLLBACK TO OraPmtQueryBatch_PUB;
3773: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3774: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3775: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
3776: END IF;
3777:
3778: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
3771: WHEN OTHERS THEN
3772: --ROLLBACK TO OraPmtQueryBatch_PUB;
3773: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3774: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3775: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
3776: END IF;
3777:
3778: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
3779: p_data => x_msg_data
3774: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3775: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
3776: END IF;
3777:
3778: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
3779: p_data => x_msg_data
3780: );
3781:
3782: END OraPmtQueryBatch;
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:
3928: -- Initialize message list if p_init_msg_list is set to TRUE.
3926: END IF;
3927:
3928: -- Initialize message list if p_init_msg_list is set to TRUE.
3929: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3930: FND_MSG_PUB.initialize;
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
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:
3940:
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:
4007: --Raising Exception to handle Servlet related errors.
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:
4014: FOR i IN 1..l_names.COUNT LOOP
4047: END IF;
4048: */
4049:
4050: -- Standard call to get message count and if count is 1, get message info.
4051: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
4052: p_data => x_msg_data
4053: );
4054: EXCEPTION
4055:
4055:
4056: WHEN FND_API.G_EXC_ERROR THEN
4057: --ROLLBACK TO OraRiskEval_PUB;
4058: x_return_status := FND_API.G_RET_STS_ERROR ;
4059: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
4060: p_data => x_msg_data
4061: );
4062: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4063: --ROLLBACK TO OraRiskEval_PUB;
4061: );
4062: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4063: --ROLLBACK TO OraRiskEval_PUB;
4064: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4065: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
4066: p_data => x_msg_data
4067: );
4068:
4069: WHEN OTHERS THEN
4068:
4069: WHEN OTHERS THEN
4070: --ROLLBACK TO OraRiskEval_PUB;
4071: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4072: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4073: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
4074: END IF;
4075:
4076: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
4069: WHEN OTHERS THEN
4070: --ROLLBACK TO OraRiskEval_PUB;
4071: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4072: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4073: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
4074: END IF;
4075:
4076: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
4077: p_data => x_msg_data
4072: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4073: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
4074: END IF;
4075:
4076: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
4077: p_data => x_msg_data
4078: );
4079:
4080:
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:
4164: -- Initialize message list if p_init_msg_list is set to TRUE.
4162: END IF;
4163:
4164: -- Initialize message list if p_init_msg_list is set to TRUE.
4165: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4166: FND_MSG_PUB.initialize;
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
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:
4176:
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:
4233: --Raising Exception to handle Servlet related errors.
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:
4240: FOR i IN 1..l_names.COUNT LOOP
4274: END IF;
4275: */
4276:
4277: -- Standard call to get message count and if count is 1, get message info.
4278: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
4279: p_data => x_msg_data
4280: );
4281: EXCEPTION
4282:
4283:
4284: WHEN FND_API.G_EXC_ERROR THEN
4285: --ROLLBACK TO OraRiskEval_PUB;
4286: x_return_status := FND_API.G_RET_STS_ERROR ;
4287: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
4288: p_data => x_msg_data
4289: );
4290: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4291: --ROLLBACK TO OraRiskEval_PUB;
4289: );
4290: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4291: --ROLLBACK TO OraRiskEval_PUB;
4292: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4293: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
4294: p_data => x_msg_data
4295: );
4296:
4297: WHEN OTHERS THEN
4296:
4297: WHEN OTHERS THEN
4298: --ROLLBACK TO OraRiskEval_PUB;
4299: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4300: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4301: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name, SQLCODE||':'||SQLERRM);
4302: END IF;
4303:
4304: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
4297: WHEN OTHERS THEN
4298: --ROLLBACK TO OraRiskEval_PUB;
4299: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4300: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4301: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name, SQLCODE||':'||SQLERRM);
4302: END IF;
4303:
4304: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
4305: p_data => x_msg_data
4300: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4301: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name, SQLCODE||':'||SQLERRM);
4302: END IF;
4303:
4304: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
4305: p_data => x_msg_data
4306: );
4307:
4308:
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:
4406: -- Initialize message list if p_init_msg_list is set to TRUE.
4404: END IF;
4405:
4406: -- Initialize message list if p_init_msg_list is set to TRUE.
4407: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4408: FND_MSG_PUB.initialize;
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
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:
4418: iby_debug_pub.add('Batch size = ' || p_capturetrxn_rec_tbl.count,
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:
4430: -- Initialize API return status to success
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:
4611: --Raising Exception to handle Servlet related errors.
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
4623: FOR i IN 1..l_names.COUNT LOOP
4707: -- if the batch failed an error message should have been
4708: -- returned
4709: --
4710: IF (NOT l_batch_msg IS NULL) THEN
4711: --FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name,l_batch_msg);
4712: --
4713: -- setting dummy message so that the results
4714: -- from the EC Servlet/Java engine can be returned
4715: -- verbatim
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
4723: -- is up and returns a parseable error page
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;
4730:
4729: END IF;
4730:
4731:
4732: -- Standard call to get message count and if count is 1, get message info.
4733: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
4734: p_data => x_msg_data
4735: );
4736:
4737: iby_debug_pub.add('Exit',
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,
4750: p_data => x_msg_data
4751: );
4752: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4753:
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,
4760: p_data => x_msg_data
4761: );
4762: WHEN OTHERS THEN
4763:
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
4776: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name, SQLCODE||':'||SQLERRM);
4777: END IF;
4778:
4779: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
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
4776: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name, SQLCODE||':'||SQLERRM);
4777: END IF;
4778:
4779: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
4780: p_data => x_msg_data
4775: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4776: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name, SQLCODE||':'||SQLERRM);
4777: END IF;
4778:
4779: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
4780: p_data => x_msg_data
4781: );
4782:
4783:
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:
4892: --Raising Exception to handle Servlet related errors.
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:
4903: /* Retrieve name-value pairs stored in l_names and l_values, and assign
4950: END IF;
4951: */
4952:
4953: -- Standard call to get message count and if count is 1, get message info.
4954: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
4955: p_data => x_msg_data
4956: );
4957:
4958: iby_debug_pub.add(debug_msg => 'x_return_status=' || x_return_status,
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,
4980: p_data => x_msg_data
4981: );
4982: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4983:
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,
4990: p_data => x_msg_data
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);
5000: END IF;
5001:
5002: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
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);
5000: END IF;
5001:
5002: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
5003: p_data => x_msg_data
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);
5000: END IF;
5001:
5002: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
5003: p_data => x_msg_data
5004: );
5005:
5006: iby_debug_pub.add(debug_msg => 'x_return_status=' || x_return_status,