248: p_api_version,
249: l_module,
250: G_PKG_NAME)
251: THEN
252: iby_debug_pub.add(debug_msg => 'Incorrect API Version:=' || p_api_version,
253: debug_level => FND_LOG.LEVEL_ERROR,
254: module => G_DEBUG_MODULE || l_module);
255: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
256: FND_MSG_PUB.Add;
319: EXCEPTION
320:
321: WHEN FND_API.G_EXC_ERROR THEN
322:
323: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
324: debug_level => FND_LOG.LEVEL_ERROR,
325: module => G_DEBUG_MODULE || l_module);
326: x_return_status := FND_API.G_RET_STS_ERROR ;
327: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
328: p_data => x_msg_data
329: );
330: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
331:
332: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
333: debug_level => FND_LOG.LEVEL_UNEXPECTED,
334: module => G_DEBUG_MODULE || l_module);
335: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
336: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
337: p_data => x_msg_data
338: );
339: WHEN OTHERS THEN
340:
341: iby_debug_pub.add(debug_msg => 'In OTHERS Exception',
342: debug_level => FND_LOG.LEVEL_UNEXPECTED,
343: module => G_DEBUG_MODULE || l_module);
344:
345: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
378: p_api_version,
379: l_module,
380: G_PKG_NAME)
381: THEN
382: iby_debug_pub.add(debug_msg => 'Incorrect API Version:=' || p_api_version,
383: debug_level => FND_LOG.LEVEL_ERROR,
384: module => G_DEBUG_MODULE || l_module);
385: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
386: FND_MSG_PUB.Add;
406: EXCEPTION
407:
408: WHEN FND_API.G_EXC_ERROR THEN
409:
410: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
411: debug_level => FND_LOG.LEVEL_ERROR,
412: module => G_DEBUG_MODULE || l_module);
413: x_return_status := FND_API.G_RET_STS_ERROR ;
414: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
415: p_data => x_msg_data
416: );
417: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
418:
419: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
420: debug_level => FND_LOG.LEVEL_UNEXPECTED,
421: module => G_DEBUG_MODULE || l_module);
422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
423: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
424: p_data => x_msg_data
425: );
426: WHEN OTHERS THEN
427:
428: iby_debug_pub.add(debug_msg => 'In OTHERS Exception',
429: debug_level => FND_LOG.LEVEL_UNEXPECTED,
430: module => G_DEBUG_MODULE || l_module);
431: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
432: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
512: p_api_version,
513: l_module,
514: G_PKG_NAME)
515: THEN
516: iby_debug_pub.add(debug_msg => 'Incorrect API Version:=' || p_api_version,
517: debug_level => FND_LOG.LEVEL_ERROR,
518: module => G_DEBUG_MODULE || l_module);
519: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
520: FND_MSG_PUB.Add;
551: EXCEPTION
552:
553: WHEN FND_API.G_EXC_ERROR THEN
554:
555: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
556: debug_level => FND_LOG.LEVEL_ERROR,
557: module => G_DEBUG_MODULE || l_module);
558: x_return_status := FND_API.G_RET_STS_ERROR ;
559: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
560: p_data => x_msg_data
561: );
562: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
563:
564: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
565: debug_level => FND_LOG.LEVEL_UNEXPECTED,
566: module => G_DEBUG_MODULE || l_module);
567: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
568: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
569: p_data => x_msg_data
570: );
571: WHEN OTHERS THEN
572:
573: iby_debug_pub.add(debug_msg => 'In OTHERS Exception',
574: debug_level => FND_LOG.LEVEL_UNEXPECTED,
575: module => G_DEBUG_MODULE || l_module);
576:
577: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
628: p_api_version,
629: l_module,
630: G_PKG_NAME)
631: THEN
632: iby_debug_pub.add(debug_msg => 'Incorrect API Version:=' || p_api_version,
633: debug_level => FND_LOG.LEVEL_ERROR,
634: module => G_DEBUG_MODULE || l_module);
635: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
636: FND_MSG_PUB.Add;
722: EXCEPTION
723:
724: WHEN FND_API.G_EXC_ERROR THEN
725: ROLLBACK TO Set_Payer_Default_Pmt_Channel;
726: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
727: debug_level => FND_LOG.LEVEL_ERROR,
728: module => G_DEBUG_MODULE || l_module);
729: x_return_status := FND_API.G_RET_STS_ERROR ;
730: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
731: p_data => x_msg_data
732: );
733: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
734: ROLLBACK TO Set_Payer_Default_Pmt_Channel;
735: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
736: debug_level => FND_LOG.LEVEL_UNEXPECTED,
737: module => G_DEBUG_MODULE || l_module);
738: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
739: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
741: );
742: WHEN OTHERS THEN
743: ROLLBACK TO Set_Payer_Default_Pmt_Channel;
744:
745: iby_debug_pub.add(debug_msg => 'In OTHERS Exception',
746: debug_level => FND_LOG.LEVEL_UNEXPECTED,
747: module => G_DEBUG_MODULE || l_module);
748:
749: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
797: p_api_version,
798: l_module,
799: G_PKG_NAME)
800: THEN
801: iby_debug_pub.add(debug_msg => 'Incorrect API Version:=' || p_api_version,
802: debug_level => FND_LOG.LEVEL_ERROR,
803: module => G_DEBUG_MODULE || l_module);
804: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
805: FND_MSG_PUB.Add;
834: EXCEPTION
835:
836: WHEN FND_API.G_EXC_ERROR THEN
837:
838: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
839: debug_level => FND_LOG.LEVEL_ERROR,
840: module => G_DEBUG_MODULE || l_module);
841: x_return_status := FND_API.G_RET_STS_ERROR ;
842: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
843: p_data => x_msg_data
844: );
845: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
846:
847: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
848: debug_level => FND_LOG.LEVEL_UNEXPECTED,
849: module => G_DEBUG_MODULE || l_module);
850: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
851: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
852: p_data => x_msg_data
853: );
854: WHEN OTHERS THEN
855:
856: iby_debug_pub.add(debug_msg => 'In OTHERS Exception',
857: debug_level => FND_LOG.LEVEL_UNEXPECTED,
858: module => G_DEBUG_MODULE || l_module);
859:
860: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
931: p_api_version,
932: l_module,
933: G_PKG_NAME)
934: THEN
935: iby_debug_pub.add(debug_msg => 'Incorrect API Version:=' || p_api_version,
936: debug_level => FND_LOG.LEVEL_ERROR,
937: module => G_DEBUG_MODULE || l_module);
938: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
939: FND_MSG_PUB.Add;
971: EXCEPTION
972:
973: WHEN FND_API.G_EXC_ERROR THEN
974:
975: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
976: debug_level => FND_LOG.LEVEL_ERROR,
977: module => G_DEBUG_MODULE || l_module);
978: x_return_status := FND_API.G_RET_STS_ERROR ;
979: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
980: p_data => x_msg_data
981: );
982: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
983:
984: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
985: debug_level => FND_LOG.LEVEL_UNEXPECTED,
986: module => G_DEBUG_MODULE || l_module);
987: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
988: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
989: p_data => x_msg_data
990: );
991: WHEN OTHERS THEN
992:
993: iby_debug_pub.add(debug_msg => 'In OTHERS Exception',
994: debug_level => FND_LOG.LEVEL_UNEXPECTED,
995: module => G_DEBUG_MODULE || l_module);
996:
997: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
1061: );
1062:
1063: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.' || l_module;
1064: BEGIN
1065: iby_debug_pub.add('Enter',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);
1066:
1067: IF (c_instr_assignment%ISOPEN) THEN CLOSE c_instr_assignment; END IF;
1068:
1069: IF NOT FND_API.Compatible_API_Call (l_api_version,
1070: p_api_version,
1071: l_module,
1072: G_PKG_NAME)
1073: THEN
1074: iby_debug_pub.add(debug_msg => 'Incorrect API Version:=' || p_api_version,
1075: debug_level => FND_LOG.LEVEL_ERROR,
1076: module => G_DEBUG_MODULE || l_module);
1077: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
1078: FND_MSG_PUB.Add;
1217:
1218: l_op_type := 'U';
1219: END IF;
1220:
1221: iby_debug_pub.add('begin HZ hook',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1222:
1223: IF (NOT p_payer.Account_Site_Id IS NULL) THEN
1224: l_parent_type := 'CUST_ACCT_SITE_USE';
1225: l_parent_table := 'HZ_CUST_SITE_USES_ALL';
1268:
1269: iby_fndcpt_common_pub.Prepare_Result
1270: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
1271:
1272: iby_debug_pub.add('Exit',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);
1273: EXCEPTION
1274:
1275: WHEN FND_API.G_EXC_ERROR THEN
1276: ROLLBACK TO Set_Payer_Instr_Assignment;
1273: EXCEPTION
1274:
1275: WHEN FND_API.G_EXC_ERROR THEN
1276: ROLLBACK TO Set_Payer_Instr_Assignment;
1277: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
1278: debug_level => FND_LOG.LEVEL_ERROR,
1279: module => G_DEBUG_MODULE || l_module);
1280: x_return_status := FND_API.G_RET_STS_ERROR ;
1281: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1282: p_data => x_msg_data
1283: );
1284: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1285: ROLLBACK TO Set_Payer_Instr_Assignment;
1286: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
1287: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1288: module => G_DEBUG_MODULE || l_module);
1289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1290: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1291: p_data => x_msg_data
1292: );
1293: WHEN OTHERS THEN
1294: ROLLBACK TO Set_Payer_Instr_Assignment;
1295: iby_debug_pub.add(debug_msg => 'In OTHERS Exception',
1296: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1297: module => G_DEBUG_MODULE || l_module);
1298:
1299: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
1348: p_api_version,
1349: l_module,
1350: G_PKG_NAME)
1351: THEN
1352: iby_debug_pub.add(debug_msg => 'Incorrect API Version:=' || p_api_version,
1353: debug_level => FND_LOG.LEVEL_ERROR,
1354: module => G_DEBUG_MODULE || l_module);
1355: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
1356: FND_MSG_PUB.Add;
1393: EXCEPTION
1394:
1395: WHEN FND_API.G_EXC_ERROR THEN
1396:
1397: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
1398: debug_level => FND_LOG.LEVEL_ERROR,
1399: module => G_DEBUG_MODULE || l_module);
1400: x_return_status := FND_API.G_RET_STS_ERROR ;
1401: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1402: p_data => x_msg_data
1403: );
1404: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1405:
1406: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
1407: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1408: module => G_DEBUG_MODULE || l_module);
1409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1410: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1411: p_data => x_msg_data
1412: );
1413: WHEN OTHERS THEN
1414:
1415: iby_debug_pub.add(debug_msg => 'In OTHERS Exception',
1416: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1417: module => G_DEBUG_MODULE || l_module);
1418:
1419: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
1466: p_api_version,
1467: l_module,
1468: G_PKG_NAME)
1469: THEN
1470: iby_debug_pub.add(debug_msg => 'Incorrect API Version:=' || p_api_version,
1471: debug_level => FND_LOG.LEVEL_ERROR,
1472: module => G_DEBUG_MODULE || l_module);
1473: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
1474: FND_MSG_PUB.Add;
1498: EXCEPTION
1499:
1500: WHEN FND_API.G_EXC_ERROR THEN
1501:
1502: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
1503: debug_level => FND_LOG.LEVEL_ERROR,
1504: module => G_DEBUG_MODULE || l_module);
1505: x_return_status := FND_API.G_RET_STS_ERROR ;
1506: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1507: p_data => x_msg_data
1508: );
1509: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1510:
1511: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
1512: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1513: module => G_DEBUG_MODULE || l_module);
1514: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1515: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1516: p_data => x_msg_data
1517: );
1518: WHEN OTHERS THEN
1519:
1520: iby_debug_pub.add(debug_msg => 'In OTHERS Exception',
1521: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1522: module => G_DEBUG_MODULE || l_module);
1523:
1524: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
1531: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1532: p_data => x_msg_data
1533: );
1534:
1535: iby_debug_pub.add(debug_msg => 'x_return_status=' || x_return_status,
1536: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1537: module => G_DEBUG_MODULE || l_module);
1538: iby_debug_pub.add(debug_msg => 'Exit Exception',
1539: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1534:
1535: iby_debug_pub.add(debug_msg => 'x_return_status=' || x_return_status,
1536: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1537: module => G_DEBUG_MODULE || l_module);
1538: iby_debug_pub.add(debug_msg => 'Exit Exception',
1539: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1540: module => G_DEBUG_MODULE || l_module);
1541: END Get_Payer_All_Instruments;
1542:
1607: p_api_version,
1608: l_module,
1609: G_PKG_NAME)
1610: THEN
1611: iby_debug_pub.add(debug_msg => 'Incorrect API Version:=' || p_api_version,
1612: debug_level => FND_LOG.LEVEL_ERROR,
1613: module => G_DEBUG_MODULE || l_module);
1614: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
1615: FND_MSG_PUB.Add;
1650: EXCEPTION
1651:
1652: WHEN FND_API.G_EXC_ERROR THEN
1653:
1654: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
1655: debug_level => FND_LOG.LEVEL_ERROR,
1656: module => G_DEBUG_MODULE || l_module);
1657: x_return_status := FND_API.G_RET_STS_ERROR ;
1658: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1659: p_data => x_msg_data
1660: );
1661: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1662:
1663: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
1664: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1665: module => G_DEBUG_MODULE || l_module);
1666: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1667: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1668: p_data => x_msg_data
1669: );
1670: WHEN OTHERS THEN
1671:
1672: iby_debug_pub.add(debug_msg => 'In OTHERS Exception',
1673: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1674: module => G_DEBUG_MODULE || l_module);
1675:
1676: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
1683: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1684: p_data => x_msg_data
1685: );
1686:
1687: iby_debug_pub.add(debug_msg => 'x_return_status=' || x_return_status,
1688: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1689: module => G_DEBUG_MODULE || l_module);
1690: iby_debug_pub.add(debug_msg => 'Exit Exception',
1691: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1686:
1687: iby_debug_pub.add(debug_msg => 'x_return_status=' || x_return_status,
1688: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1689: module => G_DEBUG_MODULE || l_module);
1690: iby_debug_pub.add(debug_msg => 'Exit Exception',
1691: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1692: module => G_DEBUG_MODULE || l_module);
1693:
1694: END Get_Trxn_Appl_Instr_Assign;
1859: SELECT cc_encryption_mode
1860: FROM iby_sys_security_options;
1861:
1862: BEGIN
1863: iby_debug_pub.add('Enter',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);
1864:
1865: IF NOT FND_API.Compatible_API_Call (l_api_version,
1866: p_api_version,
1867: l_module,
1866: p_api_version,
1867: l_module,
1868: G_PKG_NAME)
1869: THEN
1870: iby_debug_pub.add(debug_msg => 'Incorrect API Version:=' || p_api_version,
1871: debug_level => FND_LOG.LEVEL_ERROR,
1872: module => G_DEBUG_MODULE || l_module);
1873: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
1874: FND_MSG_PUB.Add;
1897: lx_result,
1898: NVL(p_card_instrument.Instrument_Type,IBY_FNDCPT_COMMON_PUB.G_INSTR_TYPE_CREDITCARD)
1899: );
1900:
1901: iby_debug_pub.add('fetched card id:='||lx_card_rec.Card_Id,
1902: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1903:
1904: IF (lx_card_rec.Card_Id IS NULL) THEN
1905:
1898: NVL(p_card_instrument.Instrument_Type,IBY_FNDCPT_COMMON_PUB.G_INSTR_TYPE_CREDITCARD)
1899: );
1900:
1901: iby_debug_pub.add('fetched card id:='||lx_card_rec.Card_Id,
1902: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1903:
1904: IF (lx_card_rec.Card_Id IS NULL) THEN
1905:
1906: -- validate billing address information
1916: CLOSE c_sec_mode;
1917:
1918: IF (l_sec_mode = iby_security_pkg.G_ENCRYPT_MODE_INSTANT) THEN
1919:
1920: iby_debug_pub.add('online registration',
1921: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1922:
1923: l_cc_reg.FIName := p_card_instrument.FI_Name;
1924: l_cc_reg.CC_Type := p_card_instrument.Card_Issuer;
1917:
1918: IF (l_sec_mode = iby_security_pkg.G_ENCRYPT_MODE_INSTANT) THEN
1919:
1920: iby_debug_pub.add('online registration',
1921: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1922:
1923: l_cc_reg.FIName := p_card_instrument.FI_Name;
1924: l_cc_reg.CC_Type := p_card_instrument.Card_Issuer;
1925: l_cc_reg.CC_Num := p_card_instrument.Card_Number;
1950: -- should not be a validation error at this point
1951: IF ((NVL(x_card_id,-1)<0))
1952: --OR (x_return_status <> FND_API.G_RET_STS_ERROR))
1953: THEN
1954: iby_debug_pub.add('instrument reg failed',
1955: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1956: iby_debug_pub.add('result code:=' || lx_result.Result_Code,
1957: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1958: IF (lx_result.Result_Code IS NULL) THEN
1951: IF ((NVL(x_card_id,-1)<0))
1952: --OR (x_return_status <> FND_API.G_RET_STS_ERROR))
1953: THEN
1954: iby_debug_pub.add('instrument reg failed',
1955: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1956: iby_debug_pub.add('result code:=' || lx_result.Result_Code,
1957: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1958: IF (lx_result.Result_Code IS NULL) THEN
1959: x_response.Result_Code := 'COMMUNICATION_ERROR';
1952: --OR (x_return_status <> FND_API.G_RET_STS_ERROR))
1953: THEN
1954: iby_debug_pub.add('instrument reg failed',
1955: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1956: iby_debug_pub.add('result code:=' || lx_result.Result_Code,
1957: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1958: IF (lx_result.Result_Code IS NULL) THEN
1959: x_response.Result_Code := 'COMMUNICATION_ERROR';
1960: --IBY_FNDCPT_COMMON_PUB.G_RC_GENERIC_SYS_ERROR;
1953: THEN
1954: iby_debug_pub.add('instrument reg failed',
1955: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1956: iby_debug_pub.add('result code:=' || lx_result.Result_Code,
1957: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1958: IF (lx_result.Result_Code IS NULL) THEN
1959: x_response.Result_Code := 'COMMUNICATION_ERROR';
1960: --IBY_FNDCPT_COMMON_PUB.G_RC_GENERIC_SYS_ERROR;
1961: iby_fndcpt_common_pub.Prepare_Result
1971: END IF;
1972: RETURN;
1973: END IF;
1974: ELSE
1975: iby_debug_pub.add('database registration',
1976: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1977:
1978: iby_creditcard_pkg.Create_Card
1979: (FND_API.G_FALSE,
1972: RETURN;
1973: END IF;
1974: ELSE
1975: iby_debug_pub.add('database registration',
1976: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1977:
1978: iby_creditcard_pkg.Create_Card
1979: (FND_API.G_FALSE,
1980: p_card_instrument.Owner_Id, p_card_instrument.Card_Holder_Name,
2092: EXCEPTION
2093:
2094: WHEN FND_API.G_EXC_ERROR THEN
2095: ROLLBACK TO Create_Card;
2096: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
2097: debug_level => FND_LOG.LEVEL_ERROR,
2098: module => G_DEBUG_MODULE || l_module);
2099: x_return_status := FND_API.G_RET_STS_ERROR ;
2100: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2101: p_data => x_msg_data
2102: );
2103: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2104: --ROLLBACK TO Create_Card;
2105: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
2106: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2107: module => G_DEBUG_MODULE || l_module);
2108: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2109: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2110: p_data => x_msg_data
2111: );
2112: WHEN OTHERS THEN
2113: --ROLLBACK TO Create_Card;
2114: iby_debug_pub.add(debug_msg => 'In OTHERS Exception',
2115: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2116: module => G_DEBUG_MODULE || l_module);
2117:
2118: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
2125: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
2126: p_data => x_msg_data
2127: );
2128:
2129: iby_debug_pub.add(debug_msg => 'x_return_status=' || x_return_status,
2130: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2131: module => G_DEBUG_MODULE || l_module);
2132: iby_debug_pub.add(debug_msg => 'Exit Exception',
2133: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2128:
2129: iby_debug_pub.add(debug_msg => 'x_return_status=' || x_return_status,
2130: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2131: module => G_DEBUG_MODULE || l_module);
2132: iby_debug_pub.add(debug_msg => 'Exit Exception',
2133: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2134: module => G_DEBUG_MODULE || l_module);
2135:
2136: END Create_Card;
2288: p_api_version,
2289: l_module,
2290: G_PKG_NAME)
2291: THEN
2292: iby_debug_pub.add(debug_msg => 'Incorrect API Version:=' || p_api_version,
2293: debug_level => FND_LOG.LEVEL_ERROR,
2294: module => G_DEBUG_MODULE || l_module);
2295: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
2296: FND_MSG_PUB.Add;
2360: EXCEPTION
2361:
2362: WHEN FND_API.G_EXC_ERROR THEN
2363: ROLLBACK TO Update_Card;
2364: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
2365: debug_level => FND_LOG.LEVEL_ERROR,
2366: module => G_DEBUG_MODULE || l_module);
2367: x_return_status := FND_API.G_RET_STS_ERROR ;
2368: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2369: p_data => x_msg_data
2370: );
2371: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2372: ROLLBACK TO Update_Card;
2373: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
2374: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2375: module => G_DEBUG_MODULE || l_module);
2376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2377: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2378: p_data => x_msg_data
2379: );
2380: WHEN OTHERS THEN
2381: ROLLBACK TO Update_Card;
2382: iby_debug_pub.add(debug_msg => 'In OTHERS Exception',
2383: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2384: module => G_DEBUG_MODULE || l_module);
2385:
2386: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
2393: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
2394: p_data => x_msg_data
2395: );
2396:
2397: iby_debug_pub.add(debug_msg => 'x_return_status=' || x_return_status,
2398: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2399: module => G_DEBUG_MODULE || l_module);
2400: iby_debug_pub.add(debug_msg => 'Exit Exception',
2401: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2396:
2397: iby_debug_pub.add(debug_msg => 'x_return_status=' || x_return_status,
2398: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2399: module => G_DEBUG_MODULE || l_module);
2400: iby_debug_pub.add(debug_msg => 'Exit Exception',
2401: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2402: module => G_DEBUG_MODULE || l_module);
2403:
2404: END Update_Card;
2438: p_api_version,
2439: l_module,
2440: G_PKG_NAME)
2441: THEN
2442: iby_debug_pub.add(debug_msg => 'Incorrect API Version:=' || p_api_version,
2443: debug_level => FND_LOG.LEVEL_ERROR,
2444: module => G_DEBUG_MODULE || l_module);
2445: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
2446: FND_MSG_PUB.Add;
2474: EXCEPTION
2475:
2476: WHEN FND_API.G_EXC_ERROR THEN
2477:
2478: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
2479: debug_level => FND_LOG.LEVEL_ERROR,
2480: module => G_DEBUG_MODULE || l_module);
2481: x_return_status := FND_API.G_RET_STS_ERROR ;
2482: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2483: p_data => x_msg_data
2484: );
2485: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2486:
2487: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
2488: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2489: module => G_DEBUG_MODULE || l_module);
2490: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2491: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2492: p_data => x_msg_data
2493: );
2494: WHEN OTHERS THEN
2495:
2496: iby_debug_pub.add(debug_msg => 'In OTHERS Exception',
2497: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2498: module => G_DEBUG_MODULE || l_module);
2499:
2500: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
2507: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
2508: p_data => x_msg_data
2509: );
2510:
2511: iby_debug_pub.add(debug_msg => 'x_return_status=' || x_return_status,
2512: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2513: module => G_DEBUG_MODULE || l_module);
2514: iby_debug_pub.add(debug_msg => 'Exit Exception',
2515: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2510:
2511: iby_debug_pub.add(debug_msg => 'x_return_status=' || x_return_status,
2512: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2513: module => G_DEBUG_MODULE || l_module);
2514: iby_debug_pub.add(debug_msg => 'Exit Exception',
2515: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2516: module => G_DEBUG_MODULE || l_module);
2517: END;
2518:
2567: p_api_version,
2568: l_module,
2569: G_PKG_NAME)
2570: THEN
2571: iby_debug_pub.add(debug_msg => 'Incorrect API Version:=' || p_api_version,
2572: debug_level => FND_LOG.LEVEL_ERROR,
2573: module => G_DEBUG_MODULE || l_module);
2574: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
2575: FND_MSG_PUB.Add;
2625: EXCEPTION
2626:
2627: WHEN FND_API.G_EXC_ERROR THEN
2628:
2629: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
2630: debug_level => FND_LOG.LEVEL_ERROR,
2631: module => G_DEBUG_MODULE || l_module);
2632: x_return_status := FND_API.G_RET_STS_ERROR ;
2633: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2634: p_data => x_msg_data
2635: );
2636: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2637:
2638: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
2639: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2640: module => G_DEBUG_MODULE || l_module);
2641: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2642: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2643: p_data => x_msg_data
2644: );
2645: WHEN OTHERS THEN
2646:
2647: iby_debug_pub.add(debug_msg => 'In OTHERS Exception',
2648: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2649: module => G_DEBUG_MODULE || l_module);
2650:
2651: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
2658: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
2659: p_data => x_msg_data
2660: );
2661:
2662: iby_debug_pub.add(debug_msg => 'x_return_status=' || x_return_status,
2663: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2664: module => G_DEBUG_MODULE || l_module);
2665: iby_debug_pub.add(debug_msg => 'Exit Exception',
2666: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2661:
2662: iby_debug_pub.add(debug_msg => 'x_return_status=' || x_return_status,
2663: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2664: module => G_DEBUG_MODULE || l_module);
2665: iby_debug_pub.add(debug_msg => 'Exit Exception',
2666: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2667: module => G_DEBUG_MODULE || l_module);
2668: END Card_Exists;
2669:
2695: lx_assign_attribs PmtInstrAssignment_rec_type;
2696:
2697: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.' || l_module;
2698: BEGIN
2699: iby_debug_pub.add('Enter',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);
2700:
2701: IF NOT FND_API.Compatible_API_Call (l_api_version,
2702: p_api_version,
2703: l_module,
2702: p_api_version,
2703: l_module,
2704: G_PKG_NAME)
2705: THEN
2706: iby_debug_pub.add(debug_msg => 'Incorrect API Version:=' || p_api_version,
2707: debug_level => FND_LOG.LEVEL_ERROR,
2708: module => G_DEBUG_MODULE || l_module);
2709: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
2710: FND_MSG_PUB.Add;
2721: SAVEPOINT Process_Credit_Card;
2722:
2723: lx_assign_attribs := p_assignment_attribs;
2724:
2725: iby_debug_pub.add('create card',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2726:
2727: Create_Card
2728: (1.0, FND_API.G_FALSE, FND_API.G_FALSE, lx_return_status, lx_msg_count,
2729: lx_msg_data, p_credit_card,
2731: lx_response
2732: );
2733:
2734: IF (lx_response.Result_Code <> IBY_FNDCPT_COMMON_PUB.G_RC_SUCCESS) THEN
2735: iby_debug_pub.add('rollback',iby_debug_pub.G_LEVEL_ERROR,l_dbg_mod);
2736: ROLLBACK TO Process_Credit_Card;
2737: x_response := lx_response;
2738: ELSE
2739:
2757: EXCEPTION
2758:
2759: WHEN FND_API.G_EXC_ERROR THEN
2760: ROLLBACK TO Process_Credit_Card;
2761: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
2762: debug_level => FND_LOG.LEVEL_ERROR,
2763: module => G_DEBUG_MODULE || l_module);
2764: x_return_status := FND_API.G_RET_STS_ERROR ;
2765: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2766: p_data => x_msg_data
2767: );
2768: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2769: ROLLBACK TO Process_Credit_Card;
2770: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
2771: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2772: module => G_DEBUG_MODULE || l_module);
2773: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2774: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2775: p_data => x_msg_data
2776: );
2777: WHEN OTHERS THEN
2778: ROLLBACK TO Process_Credit_Card;
2779: iby_debug_pub.add(debug_msg => 'In OTHERS Exception',
2780: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2781: module => G_DEBUG_MODULE || l_module);
2782:
2783: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);