178: aso_debug_pub.add('IBY Process_Credit_Card x_assign_id: '|| to_char(lx_assign_id), 1, 'Y');
179: END IF;
180:
181: if x_return_status <> fnd_api.g_ret_sts_success then
182: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
183: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
184: FND_MESSAGE.Set_Token('API', 'IBY_FNDCPT_SETUP_PUB.Process_Credit_Card ', FALSE);
185: FND_MSG_PUB.ADD;
186: END IF;
181: if x_return_status <> fnd_api.g_ret_sts_success then
182: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
183: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
184: FND_MESSAGE.Set_Token('API', 'IBY_FNDCPT_SETUP_PUB.Process_Credit_Card ', FALSE);
185: FND_MSG_PUB.ADD;
186: END IF;
187: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
189: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
204: WHEN FND_API.G_EXC_ERROR THEN
205: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
206: P_API_NAME => L_API_NAME
207: ,P_PKG_NAME => G_PKG_NAME
208: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
209: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
210: ,X_MSG_COUNT => X_MSG_COUNT
211: ,X_MSG_DATA => X_MSG_DATA
212: ,X_RETURN_STATUS => X_RETURN_STATUS);
214: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
215: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
216: P_API_NAME => L_API_NAME
217: ,P_PKG_NAME => G_PKG_NAME
218: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
219: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
220: ,X_MSG_COUNT => X_MSG_COUNT
221: ,X_MSG_DATA => X_MSG_DATA
222: ,X_RETURN_STATUS => X_RETURN_STATUS);
305: if c_get_db_line_payment%FOUND THEN
306: x_return_status := FND_API.G_RET_STS_ERROR;
307: close c_get_db_line_payment;
308: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MULTIPLE_PAYMENTS');
309: FND_MSG_PUB.ADD;
310: RAISE FND_API.G_EXC_ERROR;
311: end if;
312: close c_get_db_line_payment;
313: ELSE
319: if c_get_db_hdr_payment%FOUND THEN
320: x_return_status := FND_API.G_RET_STS_ERROR;
321: close c_get_db_hdr_payment;
322: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MULTIPLE_PAYMENTS');
323: FND_MSG_PUB.ADD;
324: RAISE FND_API.G_EXC_ERROR;
325: end if;
326: close c_get_db_hdr_payment;
327: END IF;
478: (l_payment_rec.cvv2 is null or l_payment_rec.cvv2 = fnd_api.g_miss_char)) then
479:
480: x_return_status := FND_API.G_RET_STS_ERROR;
481: FND_MESSAGE.Set_Name('ASO', 'ASO_CC_INVALID');
482: FND_MSG_PUB.ADD;
483: RAISE FND_API.G_EXC_ERROR;
484: END IF;
485:
486:
526: aso_debug_pub.add('x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
527: END IF;
528:
529: if x_return_status <> fnd_api.g_ret_sts_success then
530: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
531: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
532: FND_MESSAGE.Set_Token('API', 'IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension ', FALSE);
533: FND_MSG_PUB.ADD;
534: END IF;
529: if x_return_status <> fnd_api.g_ret_sts_success then
530: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
531: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
532: FND_MESSAGE.Set_Token('API', 'IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension ', FALSE);
533: FND_MSG_PUB.ADD;
534: END IF;
535: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
536: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
537: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
610: x_payment_rec := l_payment_rec;
611:
612:
613: -- Standard call to get message count and if count is 1, get message info.
614: FND_MSG_PUB.Count_And_Get
615: ( p_count => x_msg_count,
616: p_data => x_msg_data
617: );
618:
624: WHEN FND_API.G_EXC_ERROR THEN
625: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
626: P_API_NAME => L_API_NAME
627: ,P_PKG_NAME => G_PKG_NAME
628: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
629: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
630: ,X_MSG_COUNT => X_MSG_COUNT
631: ,X_MSG_DATA => X_MSG_DATA
632: ,X_RETURN_STATUS => X_RETURN_STATUS);
634: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
635: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
636: P_API_NAME => L_API_NAME
637: ,P_PKG_NAME => G_PKG_NAME
638: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
639: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
640: ,X_MSG_COUNT => X_MSG_COUNT
641: ,X_MSG_DATA => X_MSG_DATA
642: ,X_RETURN_STATUS => X_RETURN_STATUS);
855: (l_payment_rec.cvv2 is null or l_payment_rec.cvv2 = fnd_api.g_miss_char)) then
856:
857: x_return_status := FND_API.G_RET_STS_ERROR;
858: FND_MESSAGE.Set_Name('ASO', 'ASO_CC_INVALID');
859: FND_MSG_PUB.ADD;
860: RAISE FND_API.G_EXC_ERROR;
861: END IF;
862:
863: if l_payment_rec.cvv2 = fnd_api.g_miss_char then
904: aso_debug_pub.add('x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
905: END IF;
906:
907: if x_return_status <> fnd_api.g_ret_sts_success then
908: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
909: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
910: FND_MESSAGE.Set_Token('API', 'IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension ', FALSE);
911: FND_MSG_PUB.ADD;
912: END IF;
907: if x_return_status <> fnd_api.g_ret_sts_success then
908: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
909: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
910: FND_MESSAGE.Set_Token('API', 'IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension ', FALSE);
911: FND_MSG_PUB.ADD;
912: END IF;
913: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
914: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
915: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
956: aso_debug_pub.add('Delete_Transaction_Extension x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
957: END IF;
958:
959: if x_return_status <> fnd_api.g_ret_sts_success then
960: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
961: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
962: FND_MESSAGE.Set_Token('API', ' IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension', FALSE);
963: FND_MSG_PUB.ADD;
964: END IF;
959: if x_return_status <> fnd_api.g_ret_sts_success then
960: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
961: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
962: FND_MESSAGE.Set_Token('API', ' IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension', FALSE);
963: FND_MSG_PUB.ADD;
964: END IF;
965: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
966: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
967: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1077: aso_debug_pub.add('x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
1078: END IF;
1079:
1080: if x_return_status <> fnd_api.g_ret_sts_success then
1081: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1082: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
1083: FND_MESSAGE.Set_Token('API', 'IBY_FNDCPT_SETUP_PUB.Update_Card', FALSE);
1084: FND_MSG_PUB.ADD;
1085: END IF;
1080: if x_return_status <> fnd_api.g_ret_sts_success then
1081: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1082: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
1083: FND_MESSAGE.Set_Token('API', 'IBY_FNDCPT_SETUP_PUB.Update_Card', FALSE);
1084: FND_MSG_PUB.ADD;
1085: END IF;
1086: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1087: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1088: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1155: (l_payment_rec.cvv2 is null or l_payment_rec.cvv2 = fnd_api.g_miss_char)) then
1156:
1157: x_return_status := FND_API.G_RET_STS_ERROR;
1158: FND_MESSAGE.Set_Name('ASO', 'ASO_CC_INVALID');
1159: FND_MSG_PUB.ADD;
1160: RAISE FND_API.G_EXC_ERROR;
1161: END IF;
1162: */
1163:
1207: aso_debug_pub.add('x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
1208: END IF;
1209:
1210: IF x_return_status <> fnd_api.g_ret_sts_success then
1211: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1212: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
1213: FND_MESSAGE.Set_Token('API', 'IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension ', FALSE);
1214: FND_MSG_PUB.ADD;
1215: END IF;
1210: IF x_return_status <> fnd_api.g_ret_sts_success then
1211: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1212: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
1213: FND_MESSAGE.Set_Token('API', 'IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension ', FALSE);
1214: FND_MSG_PUB.ADD;
1215: END IF;
1216: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1218: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1256: aso_debug_pub.add('Delete_Transaction_Extension x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
1257: END IF;
1258:
1259: if x_return_status <> fnd_api.g_ret_sts_success then
1260: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1261: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
1262: FND_MESSAGE.Set_Token('API', ' IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension', FALSE);
1263: FND_MSG_PUB.ADD;
1264: END IF;
1259: if x_return_status <> fnd_api.g_ret_sts_success then
1260: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1261: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
1262: FND_MESSAGE.Set_Token('API', ' IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension', FALSE);
1263: FND_MSG_PUB.ADD;
1264: END IF;
1265: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1266: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1267: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1315: (l_payment_rec.cvv2 is null or l_payment_rec.cvv2 = fnd_api.g_miss_char)) then
1316:
1317: x_return_status := FND_API.G_RET_STS_ERROR;
1318: FND_MESSAGE.Set_Name('ASO', 'ASO_CC_INVALID');
1319: FND_MSG_PUB.ADD;
1320: RAISE FND_API.G_EXC_ERROR;
1321: END IF;
1322:
1323: if (l_payment_rec.instr_assignment_id is not null and l_payment_rec.instr_assignment_id <> fnd_api.g_miss_num) then
1346: aso_debug_pub.add('x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
1347: END IF;
1348:
1349: if x_return_status <> fnd_api.g_ret_sts_success then
1350: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1351: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
1352: FND_MESSAGE.Set_Token('API', 'IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension ', FALSE);
1353: FND_MSG_PUB.ADD;
1354: END IF;
1349: if x_return_status <> fnd_api.g_ret_sts_success then
1350: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1351: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
1352: FND_MESSAGE.Set_Token('API', 'IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension ', FALSE);
1353: FND_MSG_PUB.ADD;
1354: END IF;
1355: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1356: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1357: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1440: COMMIT WORK;
1441: END IF; */
1442:
1443: -- Standard call to get message count and if count is 1, get message info.
1444: FND_MSG_PUB.Count_And_Get
1445: ( p_count => x_msg_count,
1446: p_data => x_msg_data
1447: );
1448:
1454: WHEN FND_API.G_EXC_ERROR THEN
1455: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1456: P_API_NAME => L_API_NAME
1457: ,P_PKG_NAME => G_PKG_NAME
1458: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1459: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
1460: ,X_MSG_COUNT => X_MSG_COUNT
1461: ,X_MSG_DATA => X_MSG_DATA
1462: ,X_RETURN_STATUS => X_RETURN_STATUS);
1464: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1465: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1466: P_API_NAME => L_API_NAME
1467: ,P_PKG_NAME => G_PKG_NAME
1468: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1469: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
1470: ,X_MSG_COUNT => X_MSG_COUNT
1471: ,X_MSG_DATA => X_MSG_DATA
1472: ,X_RETURN_STATUS => X_RETURN_STATUS);
1572: aso_debug_pub.add('Delete_Transaction_Extension x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
1573: END IF;
1574:
1575: if x_return_status <> fnd_api.g_ret_sts_success then
1576: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1577: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
1578: FND_MESSAGE.Set_Token('API', ' IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension', FALSE);
1579: FND_MSG_PUB.ADD;
1580: END IF;
1575: if x_return_status <> fnd_api.g_ret_sts_success then
1576: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1577: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
1578: FND_MESSAGE.Set_Token('API', ' IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension', FALSE);
1579: FND_MSG_PUB.ADD;
1580: END IF;
1581: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1582: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1583: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1594: COMMIT WORK;
1595: END IF; */
1596:
1597: -- Standard call to get message count and if count is 1, get message info.
1598: FND_MSG_PUB.Count_And_Get
1599: ( p_count => x_msg_count,
1600: p_data => x_msg_data
1601: );
1602:
1608: WHEN FND_API.G_EXC_ERROR THEN
1609: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1610: P_API_NAME => L_API_NAME
1611: ,P_PKG_NAME => G_PKG_NAME
1612: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1613: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
1614: ,X_MSG_COUNT => X_MSG_COUNT
1615: ,X_MSG_DATA => X_MSG_DATA
1616: ,X_RETURN_STATUS => X_RETURN_STATUS);
1618: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1619: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1620: P_API_NAME => L_API_NAME
1621: ,P_PKG_NAME => G_PKG_NAME
1622: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1623: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
1624: ,X_MSG_COUNT => X_MSG_COUNT
1625: ,X_MSG_DATA => X_MSG_DATA
1626: ,X_RETURN_STATUS => X_RETURN_STATUS);