eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.IBY_FNDCPT_TRXN_PUB dependencies on FND_API

Line 537: (1.0, FND_API.G_FALSE, l_return_status, l_msg_count, l_msg_data,

533: iby_debug_pub.add('Call -> IBY_FNDCPT_SETUP_PUB.Get_Payment_Channel_Attribs',
534: G_LEVEL_STATEMENT,l_dbg_mod);
535: END IF;
536: IBY_FNDCPT_SETUP_PUB.Get_Payment_Channel_Attribs
537: (1.0, FND_API.G_FALSE, l_return_status, l_msg_count, l_msg_data,
538: p_pmt_channel, l_channel_attribs, l_response);
539:
540: IF( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
541: iby_debug_pub.add('Return from IBY_FNDCPT_SETUP_PUB.Get_Payment_Channel_Attribs',

Line 555: OR (p_trxn_attribs.Instrument_Security_Code = FND_API.G_MISS_CHAR)

551: ( ((p_trxn_attribs.Instrument_Security_Code IS NULL)
552: AND (NOT p_update)
553: AND (NOT p_consumed_cvv2)
554: )
555: OR (p_trxn_attribs.Instrument_Security_Code = FND_API.G_MISS_CHAR)
556: )
557: )
558: THEN
559: RETURN FALSE;

Line 564: (p_trxn_attribs.Instrument_security_Code = FND_API.G_MISS_CHAR)

560: END IF;
561: IF ( (l_channel_attribs.Instr_SecCode_Use =
562: IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_DISABLED)
563: AND NOT ( (p_trxn_attribs.Instrument_Security_Code IS NULL) OR
564: (p_trxn_attribs.Instrument_security_Code = FND_API.G_MISS_CHAR)
565: )
566: )
567: THEN
568: RETURN FALSE;

Line 574: OR (p_trxn_attribs.VoiceAuth_Flag = FND_API.G_MISS_CHAR) )

570:
571: IF ( (l_channel_attribs.Instr_VoiceAuthFlag_Use =
572: IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_REQUIRED)
573: AND ( (p_trxn_attribs.VoiceAuth_Flag IS NULL AND (NOT p_update))
574: OR (p_trxn_attribs.VoiceAuth_Flag = FND_API.G_MISS_CHAR) )
575: )
576: THEN
577: RETURN FALSE;
578: END IF;

Line 583: (p_trxn_attribs.VoiceAuth_Flag = FND_API.G_MISS_CHAR)

579: --Fix for bug# 6404912: Voice Auth flag 'N' and NULL treated similarly
580: IF ( (l_channel_attribs.Instr_VoiceAuthFlag_Use =
581: IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_DISABLED)
582: AND NOT ( ( nvl(p_trxn_attribs.VoiceAuth_Flag, 'N') = 'N') OR
583: (p_trxn_attribs.VoiceAuth_Flag = FND_API.G_MISS_CHAR)
584: )
585: )
586: THEN
587: RETURN FALSE;

Line 593: OR (p_trxn_attribs.VoiceAuth_Code = FND_API.G_MISS_CHAR)

589:
590: IF ( (l_channel_attribs.Instr_VoiceAuthCode_Use =
591: IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_REQUIRED)
592: AND ( (p_trxn_attribs.VoiceAuth_Code IS NULL AND (NOT p_update))
593: OR (p_trxn_attribs.VoiceAuth_Code = FND_API.G_MISS_CHAR)
594: )
595: )
596: THEN
597: RETURN FALSE;

Line 602: (p_trxn_attribs.VoiceAuth_Code = FND_API.G_MISS_CHAR)

598: END IF;
599: IF ( (l_channel_attribs.Instr_VoiceAuthCode_Use =
600: IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_DISABLED)
601: AND NOT ( (p_trxn_attribs.VoiceAuth_Code IS NULL) OR
602: (p_trxn_attribs.VoiceAuth_Code = FND_API.G_MISS_CHAR)
603: )
604: )
605: THEN
606: RETURN FALSE;

Line 612: (p_trxn_attribs.VoiceAuth_Date = FND_API.G_MISS_DATE) )

608:
609: IF ( (l_channel_attribs.Instr_VoiceAuthDate_Use =
610: IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_REQUIRED)
611: AND ( (p_trxn_attribs.VoiceAuth_Date IS NULL AND (NOT p_update)) OR
612: (p_trxn_attribs.VoiceAuth_Date = FND_API.G_MISS_DATE) )
613: )
614: THEN
615: RETURN FALSE;
616: END IF;

Line 620: (p_trxn_attribs.VoiceAuth_Date = FND_API.G_MISS_DATE)

616: END IF;
617: IF ( (l_channel_attribs.Instr_VoiceAuthDate_Use =
618: IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_DISABLED)
619: AND NOT ( (p_trxn_attribs.VoiceAuth_Date IS NULL) OR
620: (p_trxn_attribs.VoiceAuth_Date = FND_API.G_MISS_DATE)
621: )
622: )
623: THEN
624: RETURN FALSE;

Line 630: OR (p_trxn_attribs.PO_Number = FND_API.G_MISS_CHAR) )

626:
627: IF ( (l_channel_attribs.PO_Number_Use =
628: IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_REQUIRED)
629: AND ( (p_trxn_attribs.PO_Number IS NULL AND (NOT p_update))
630: OR (p_trxn_attribs.PO_Number = FND_API.G_MISS_CHAR) )
631: )
632: THEN
633: RETURN FALSE;
634: END IF;

Line 638: (p_trxn_attribs.PO_Number = FND_API.G_MISS_CHAR)

634: END IF;
635: IF ( (l_channel_attribs.PO_Number_Use =
636: IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_DISABLED)
637: AND NOT ( (p_trxn_attribs.PO_Number IS NULL) OR
638: (p_trxn_attribs.PO_Number = FND_API.G_MISS_CHAR)
639: )
640: )
641: THEN
642: RETURN FALSE;

Line 648: OR (p_trxn_attribs.PO_Line_Number = FND_API.G_MISS_CHAR) )

644:
645: IF ( (l_channel_attribs.PO_Line_Number_Use =
646: IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_REQUIRED)
647: AND ( (p_trxn_attribs.PO_Line_Number IS NULL OR (NOT p_update))
648: OR (p_trxn_attribs.PO_Line_Number = FND_API.G_MISS_CHAR) )
649: )
650: THEN
651: RETURN FALSE;
652: END IF;

Line 656: (p_trxn_attribs.PO_Line_Number = FND_API.G_MISS_CHAR)

652: END IF;
653: IF ( (l_channel_attribs.PO_Line_Number_Use =
654: IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_DISABLED)
655: AND NOT ( (p_trxn_attribs.PO_Line_Number IS NULL) OR
656: (p_trxn_attribs.PO_Line_Number = FND_API.G_MISS_CHAR)
657: )
658: )
659: THEN
660: RETURN FALSE;

Line 666: OR (p_trxn_attribs.Additional_Info = FND_API.G_MISS_CHAR) )

662:
663: IF ( (l_channel_attribs.AddInfo_Use =
664: IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_REQUIRED)
665: AND ( (p_trxn_attribs.Additional_Info IS NULL OR (NOT p_update))
666: OR (p_trxn_attribs.Additional_Info = FND_API.G_MISS_CHAR) )
667: )
668: THEN
669: RETURN FALSE;
670: END IF;

Line 674: (p_trxn_attribs.Additional_Info = FND_API.G_MISS_CHAR)

670: END IF;
671: IF ( (l_channel_attribs.AddInfo_Use =
672: IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_DISABLED)
673: AND NOT ( (p_trxn_attribs.Additional_Info IS NULL) OR
674: (p_trxn_attribs.Additional_Info = FND_API.G_MISS_CHAR)
675: )
676: )
677: THEN
678: RETURN FALSE;

Line 682: (p_trxn_attribs.Order_id = FND_API.G_MISS_CHAR)

678: RETURN FALSE;
679: END IF;
680:
681: IF ( (p_trxn_attribs.Order_Id IS NULL AND (NOT p_update)) OR
682: (p_trxn_attribs.Order_id = FND_API.G_MISS_CHAR)
683: )
684: THEN
685: RETURN FALSE;
686: END IF;

Line 1023: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1019:
1020: PROCEDURE Create_Transaction_Extension
1021: (
1022: p_api_version IN NUMBER,
1023: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1024: p_commit IN VARCHAR2 := FND_API.G_TRUE,
1025: x_return_status OUT NOCOPY VARCHAR2,
1026: x_msg_count OUT NOCOPY NUMBER,
1027: x_msg_data OUT NOCOPY VARCHAR2,

Line 1024: p_commit IN VARCHAR2 := FND_API.G_TRUE,

1020: PROCEDURE Create_Transaction_Extension
1021: (
1022: p_api_version IN NUMBER,
1023: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1024: p_commit IN VARCHAR2 := FND_API.G_TRUE,
1025: x_return_status OUT NOCOPY VARCHAR2,
1026: x_msg_count OUT NOCOPY NUMBER,
1027: x_msg_data OUT NOCOPY VARCHAR2,
1028: p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,

Line 1066: IF NOT FND_API.Compatible_API_Call (l_api_version,

1062: END IF;
1063:
1064: -- test_debug('Create_Transaction_Extension=> Enter..');
1065:
1066: IF NOT FND_API.Compatible_API_Call (l_api_version,
1067: p_api_version,
1068: l_module,
1069: G_PKG_NAME)
1070: THEN

Line 1078: RAISE FND_API.G_EXC_ERROR;

1074: module => G_DEBUG_MODULE || l_module);
1075: END IF;
1076: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
1077: FND_MSG_PUB.Add;
1078: RAISE FND_API.G_EXC_ERROR;
1079: END IF;
1080:
1081: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1082: FND_MSG_PUB.initialize;

Line 1081: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1077: FND_MSG_PUB.Add;
1078: RAISE FND_API.G_EXC_ERROR;
1079: END IF;
1080:
1081: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1082: FND_MSG_PUB.initialize;
1083: END IF;
1084: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
1085:

Line 1096: IBY_FNDCPT_SETUP_PUB.Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,

1092: iby_debug_pub.add('p_instr_assignment: '|| p_instr_assignment,G_LEVEL_STATEMENT,l_dbg_mod);
1093: END IF;
1094: -- test_debug('Create_Transaction_Extension=> Checking Payer context..');
1095:
1096: IBY_FNDCPT_SETUP_PUB.Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,
1097: l_payer_level,l_payer_id,l_payer_attribs);
1098:
1099: iby_debug_pub.add('l_payer_level: '|| l_payer_level,G_LEVEL_STATEMENT,l_dbg_mod);
1100: iby_debug_pub.add('l_payer_id: '|| l_payer_id,G_LEVEL_STATEMENT,l_dbg_mod);

Line 1192: (1.0, FND_API.G_FALSE, FND_API.G_FALSE,

1188:
1189: -- create payer on the fly if necessary
1190: IF (l_payer_id IS NULL) THEN
1191: IBY_FNDCPT_SETUP_PUB.Set_Payer_Attributes
1192: (1.0, FND_API.G_FALSE, FND_API.G_FALSE,
1193: x_return_status, x_msg_count, x_msg_data,
1194: p_payer, l_payer_attribs, l_payer_id, lx_result
1195: );
1196:

Line 1211: (p_trxn_attribs.Instrument_security_Code = FND_API.G_MISS_CHAR))

1207:
1208: -- PABP: For IMMEDIATE mode of encryption, make an http callout --
1209: -- to the ECApp and encrypt the CVV value --
1210: IF (NOT ((p_trxn_attribs.Instrument_Security_Code IS NULL) OR
1211: (p_trxn_attribs.Instrument_security_Code = FND_API.G_MISS_CHAR))
1212: ) THEN
1213: -- Security code must be numeric
1214: IF('Y' <> IBY_UTILITY_PVT.isNumeric(l_sec_code)) THEN
1215: IF( G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1222: RAISE FND_API.G_EXC_ERROR;

1218: module => G_DEBUG_MODULE || l_module);
1219: END IF;
1220: FND_MESSAGE.SET_NAME('IBY', 'IBY_204900');
1221: FND_MSG_PUB.Add;
1222: RAISE FND_API.G_EXC_ERROR;
1223: END IF;
1224:
1225: -- Security code should be 3-4 digits
1226: IF((LENGTH(l_sec_code) > 4) OR (LENGTH(l_sec_code) < 3) ) THEN

Line 1234: RAISE FND_API.G_EXC_ERROR;

1230: module => G_DEBUG_MODULE || l_module);
1231: END IF;
1232: FND_MESSAGE.SET_NAME('IBY', 'IBY_204901');
1233: FND_MSG_PUB.Add;
1234: RAISE FND_API.G_EXC_ERROR;
1235: END IF;
1236: IF ('IMMEDIATE' = IBY_CREDITCARD_PKG.Get_CC_Encrypt_Mode()) THEN
1237: -- Make an HTTP call out to the middle tier
1238: -- test_debug('calling secure_extension..');

Line 1240: (FND_API.G_FALSE,

1236: IF ('IMMEDIATE' = IBY_CREDITCARD_PKG.Get_CC_Encrypt_Mode()) THEN
1237: -- Make an HTTP call out to the middle tier
1238: -- test_debug('calling secure_extension..');
1239: IBY_PAYMENT_ADAPTER_PUB.OraSecureExtension
1240: (FND_API.G_FALSE,
1241: p_trxn_attribs.Instrument_security_Code,
1242: l_return_status,
1243: l_msg_count,
1244: l_msg_data,

Line 1256: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1252: l_encrypted := 'Y';
1253: l_sec_code := LPAD('X',LENGTH(p_trxn_attribs.Instrument_Security_Code),'X');
1254: ELSE
1255: -- test_debug('Unknown error occurred while cvv encryption !!');
1256: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1257: IF( G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
1258: iby_debug_pub.add(debug_msg => 'Unknown error occurred while cvv encryption !!',
1259: debug_level => G_LEVEL_ERROR,
1260: module => G_DEBUG_MODULE || l_module);

Line 1264: RAISE FND_API.G_EXC_ERROR;

1260: module => G_DEBUG_MODULE || l_module);
1261: END IF;
1262: FND_MESSAGE.SET_NAME('IBY', 'IBY_204902');
1263: FND_MSG_PUB.Add;
1264: RAISE FND_API.G_EXC_ERROR;
1265: END IF;
1266: l_segment_id := null;
1267: l_encrypted := 'N';
1268: l_sec_code := null;

Line 1317: IF FND_API.To_Boolean(p_commit) THEN

1313:
1314: iby_fndcpt_common_pub.Prepare_Result
1315: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
1316:
1317: IF FND_API.To_Boolean(p_commit) THEN
1318: COMMIT;
1319: END IF;
1320:
1321: IF( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1328: WHEN FND_API.G_EXC_ERROR THEN

1324:
1325:
1326: EXCEPTION
1327:
1328: WHEN FND_API.G_EXC_ERROR THEN
1329:
1330: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
1331: debug_level => G_LEVEL_ERROR,
1332: module => G_DEBUG_MODULE || l_module);

Line 1333: x_return_status := FND_API.G_RET_STS_ERROR;

1329:
1330: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
1331: debug_level => G_LEVEL_ERROR,
1332: module => G_DEBUG_MODULE || l_module);
1333: x_return_status := FND_API.G_RET_STS_ERROR;
1334: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1335: p_data => x_msg_data
1336: );
1337: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1337: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1333: x_return_status := FND_API.G_RET_STS_ERROR;
1334: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1335: p_data => x_msg_data
1336: );
1337: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1338:
1339: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
1340: debug_level => G_LEVEL_UNEXPECTED,
1341: module => G_DEBUG_MODULE || l_module);

Line 1342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1338:
1339: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
1340: debug_level => G_LEVEL_UNEXPECTED,
1341: module => G_DEBUG_MODULE || l_module);
1342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1343: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1344: p_data => x_msg_data
1345: );
1346: WHEN OTHERS THEN

Line 1354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1350: module => G_DEBUG_MODULE || l_module);
1351:
1352: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
1353:
1354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1355: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1356: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
1357: END IF;
1358: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 1367: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1363:
1364: PROCEDURE Update_Transaction_Extension
1365: (
1366: p_api_version IN NUMBER,
1367: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1368: p_commit IN VARCHAR2 := FND_API.G_TRUE,
1369: x_return_status OUT NOCOPY VARCHAR2,
1370: x_msg_count OUT NOCOPY NUMBER,
1371: x_msg_data OUT NOCOPY VARCHAR2,

Line 1368: p_commit IN VARCHAR2 := FND_API.G_TRUE,

1364: PROCEDURE Update_Transaction_Extension
1365: (
1366: p_api_version IN NUMBER,
1367: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1368: p_commit IN VARCHAR2 := FND_API.G_TRUE,
1369: x_return_status OUT NOCOPY VARCHAR2,
1370: x_msg_count OUT NOCOPY NUMBER,
1371: x_msg_data OUT NOCOPY VARCHAR2,
1372: p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,

Line 1443: IF NOT FND_API.Compatible_API_Call (l_api_version,

1439: -- test_debug('update_extension called..');
1440:
1441: IF (c_extension%ISOPEN) THEN CLOSE c_extension; END IF;
1442:
1443: IF NOT FND_API.Compatible_API_Call (l_api_version,
1444: p_api_version,
1445: l_module,
1446: G_PKG_NAME)
1447: THEN

Line 1455: RAISE FND_API.G_EXC_ERROR;

1451: module => G_DEBUG_MODULE || l_module);
1452: END IF;
1453: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
1454: FND_MSG_PUB.Add;
1455: RAISE FND_API.G_EXC_ERROR;
1456: END IF;
1457:
1458: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1459: FND_MSG_PUB.initialize;

Line 1458: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1454: FND_MSG_PUB.Add;
1455: RAISE FND_API.G_EXC_ERROR;
1456: END IF;
1457:
1458: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1459: FND_MSG_PUB.initialize;
1460: END IF;
1461: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
1462:

Line 1466: IBY_FNDCPT_SETUP_PUB.Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,

1462:
1463: IF( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1464: iby_debug_pub.add('checking payer context',G_LEVEL_STATEMENT,l_dbg_mod);
1465: END IF;
1466: IBY_FNDCPT_SETUP_PUB.Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,
1467: l_payer_level,l_payer_id,l_payer_attribs);
1468:
1469: IF (l_payer_level = IBY_FNDCPT_COMMON_PUB.G_RC_INVALID_PAYER) THEN
1470: x_response.Result_Code := IBY_FNDCPT_COMMON_PUB.G_RC_INVALID_PAYER;

Line 1499: IF (p_instr_assignment = FND_API.G_MISS_NUM) THEN

1495: RETURN;
1496: END IF;
1497:
1498: l_pmt_channel := NVL(p_pmt_channel,l_pmt_channel);
1499: IF (p_instr_assignment = FND_API.G_MISS_NUM) THEN
1500: l_instr_assign := NULL;
1501: ELSIF (NOT p_instr_assignment IS NULL) THEN
1502: l_instr_ASSIGN := p_instr_assignment;
1503: END IF;

Line 1590: (p_trxn_attribs.Instrument_security_Code = FND_API.G_MISS_CHAR) OR

1586: -- to the ECApp and encrypt the CVV value
1587: -- Bug# 12335720
1588: -- Skip the validation if the security code passed as 'XXX' or 'XXXX'
1589: IF (NOT ((p_trxn_attribs.Instrument_Security_Code IS NULL) OR
1590: (p_trxn_attribs.Instrument_security_Code = FND_API.G_MISS_CHAR) OR
1591: (p_trxn_attribs.Instrument_security_Code = 'XXX') OR
1592: (p_trxn_attribs.Instrument_security_Code = 'XXXX'))
1593: ) THEN
1594: IF('Y' <> IBY_UTILITY_PVT.isNumeric(l_sec_code)) THEN

Line 1602: RAISE FND_API.G_EXC_ERROR;

1598: module => G_DEBUG_MODULE || l_module);
1599: END IF;
1600: FND_MESSAGE.SET_NAME('IBY', 'IBY_204900');
1601: FND_MSG_PUB.Add;
1602: RAISE FND_API.G_EXC_ERROR;
1603: END IF;
1604:
1605: -- Security code should be 3-4 digits
1606: IF((LENGTH(l_sec_code) > 4) OR (LENGTH(l_sec_code) < 3) ) THEN

Line 1614: RAISE FND_API.G_EXC_ERROR;

1610: module => G_DEBUG_MODULE || l_module);
1611: END IF;
1612: FND_MESSAGE.SET_NAME('IBY', 'IBY_204901');
1613: FND_MSG_PUB.Add;
1614: RAISE FND_API.G_EXC_ERROR;
1615: END IF;
1616:
1617: IF ('IMMEDIATE' = IBY_CREDITCARD_PKG.Get_CC_Encrypt_Mode()) THEN
1618: -- Make an HTTP call out to the middle tier

Line 1621: (FND_API.G_FALSE,

1617: IF ('IMMEDIATE' = IBY_CREDITCARD_PKG.Get_CC_Encrypt_Mode()) THEN
1618: -- Make an HTTP call out to the middle tier
1619: -- test_debug('calling secure_extension..');
1620: IBY_PAYMENT_ADAPTER_PUB.OraSecureExtension
1621: (FND_API.G_FALSE,
1622: p_trxn_attribs.Instrument_security_Code,
1623: l_return_status,
1624: l_msg_count,
1625: l_msg_data,

Line 1638: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1634: l_encrypted := 'Y';
1635: l_sec_code := LPAD('X',LENGTH(p_trxn_attribs.Instrument_Security_Code),'X');
1636: ELSE
1637: -- test_debug('Unknown error occurred while cvv encryption !!');
1638: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1639: IF( G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
1640: iby_debug_pub.add(debug_msg => 'Unknown error occurred while cvv encryption !!',
1641: debug_level => G_LEVEL_ERROR,
1642: module => G_DEBUG_MODULE || l_module);

Line 1646: RAISE FND_API.G_EXC_ERROR;

1642: module => G_DEBUG_MODULE || l_module);
1643: END IF;
1644: FND_MESSAGE.SET_NAME('IBY', 'IBY_204902');
1645: FND_MSG_PUB.Add;
1646: RAISE FND_API.G_EXC_ERROR;
1647: END IF;
1648: l_segment_id := null;
1649: l_encrypted := 'N';
1650: l_sec_code := null;

Line 1687: DECODE(p_instr_assignment, FND_API.G_MISS_NUM,NULL,

1683: UPDATE iby_fndcpt_tx_extensions
1684: SET
1685: payment_channel_code = NVL(p_pmt_channel,payment_channel_code),
1686: instr_assignment_id =
1687: DECODE(p_instr_assignment, FND_API.G_MISS_NUM,NULL,
1688: NULL,instr_assignment_id, p_instr_assignment),
1689: origin_application_id =
1690: NVL(p_trxn_attribs.Originating_Application_Id,
1691: origin_application_id),

Line 1694: FND_API.G_MISS_CHAR,NULL, NULL,instrument_security_code,

1690: NVL(p_trxn_attribs.Originating_Application_Id,
1691: origin_application_id),
1692: instrument_security_code =
1693: DECODE(p_trxn_attribs.Instrument_Security_Code,
1694: FND_API.G_MISS_CHAR,NULL, NULL,instrument_security_code,
1695: 'XXX', instrument_security_code,
1696: 'XXXX', instrument_security_code,
1697: l_sec_code),
1698: instr_sec_code_length =

Line 1700: FND_API.G_MISS_CHAR,NULL,

1696: 'XXXX', instrument_security_code,
1697: l_sec_code),
1698: instr_sec_code_length =
1699: length(DECODE(p_trxn_attribs.Instrument_Security_Code,
1700: FND_API.G_MISS_CHAR,NULL,
1701: NULL,instrument_security_code,
1702: 'XXX', instrument_security_code,
1703: 'XXXX', instrument_security_code,
1704: l_sec_code)

Line 1708: FND_API.G_MISS_CHAR,'N', NULL,encrypted, l_encrypted),

1704: l_sec_code)
1705: ),
1706: encrypted =
1707: DECODE(p_trxn_attribs.Instrument_Security_Code,
1708: FND_API.G_MISS_CHAR,'N', NULL,encrypted, l_encrypted),
1709: instr_code_sec_segment_id =
1710: NVL(l_segment_id, instr_code_sec_segment_id),
1711: voice_authorization_flag =
1712: DECODE(p_trxn_attribs.VoiceAuth_Flag, FND_API.G_MISS_CHAR,NULL,

Line 1712: DECODE(p_trxn_attribs.VoiceAuth_Flag, FND_API.G_MISS_CHAR,NULL,

1708: FND_API.G_MISS_CHAR,'N', NULL,encrypted, l_encrypted),
1709: instr_code_sec_segment_id =
1710: NVL(l_segment_id, instr_code_sec_segment_id),
1711: voice_authorization_flag =
1712: DECODE(p_trxn_attribs.VoiceAuth_Flag, FND_API.G_MISS_CHAR,NULL,
1713: NULL,voice_authorization_flag, p_trxn_attribs.VoiceAuth_Flag),
1714: voice_authorization_date =
1715: DECODE(p_trxn_attribs.VoiceAuth_Date, FND_API.G_MISS_DATE,NULL,
1716: NULL,voice_authorization_date, p_trxn_attribs.VoiceAuth_Date),

Line 1715: DECODE(p_trxn_attribs.VoiceAuth_Date, FND_API.G_MISS_DATE,NULL,

1711: voice_authorization_flag =
1712: DECODE(p_trxn_attribs.VoiceAuth_Flag, FND_API.G_MISS_CHAR,NULL,
1713: NULL,voice_authorization_flag, p_trxn_attribs.VoiceAuth_Flag),
1714: voice_authorization_date =
1715: DECODE(p_trxn_attribs.VoiceAuth_Date, FND_API.G_MISS_DATE,NULL,
1716: NULL,voice_authorization_date, p_trxn_attribs.VoiceAuth_Date),
1717: voice_authorization_code =
1718: DECODE(p_trxn_attribs.VoiceAuth_Code, FND_API.G_MISS_CHAR,NULL,
1719: NULL,voice_authorization_code, p_trxn_attribs.VoiceAuth_Code),

Line 1718: DECODE(p_trxn_attribs.VoiceAuth_Code, FND_API.G_MISS_CHAR,NULL,

1714: voice_authorization_date =
1715: DECODE(p_trxn_attribs.VoiceAuth_Date, FND_API.G_MISS_DATE,NULL,
1716: NULL,voice_authorization_date, p_trxn_attribs.VoiceAuth_Date),
1717: voice_authorization_code =
1718: DECODE(p_trxn_attribs.VoiceAuth_Code, FND_API.G_MISS_CHAR,NULL,
1719: NULL,voice_authorization_code, p_trxn_attribs.VoiceAuth_Code),
1720: order_id = NVL(p_trxn_attribs.Order_Id, order_id),
1721: po_number = DECODE(p_trxn_attribs.PO_Number, FND_API.G_MISS_CHAR,NULL,
1722: NULL,po_number, p_trxn_attribs.PO_Number),

Line 1721: po_number = DECODE(p_trxn_attribs.PO_Number, FND_API.G_MISS_CHAR,NULL,

1717: voice_authorization_code =
1718: DECODE(p_trxn_attribs.VoiceAuth_Code, FND_API.G_MISS_CHAR,NULL,
1719: NULL,voice_authorization_code, p_trxn_attribs.VoiceAuth_Code),
1720: order_id = NVL(p_trxn_attribs.Order_Id, order_id),
1721: po_number = DECODE(p_trxn_attribs.PO_Number, FND_API.G_MISS_CHAR,NULL,
1722: NULL,po_number, p_trxn_attribs.PO_Number),
1723: po_line_number = DECODE(p_trxn_attribs.PO_Line_Number,
1724: FND_API.G_MISS_CHAR,NULL, NULL,po_line_number,
1725: p_trxn_attribs.PO_Line_Number),

Line 1724: FND_API.G_MISS_CHAR,NULL, NULL,po_line_number,

1720: order_id = NVL(p_trxn_attribs.Order_Id, order_id),
1721: po_number = DECODE(p_trxn_attribs.PO_Number, FND_API.G_MISS_CHAR,NULL,
1722: NULL,po_number, p_trxn_attribs.PO_Number),
1723: po_line_number = DECODE(p_trxn_attribs.PO_Line_Number,
1724: FND_API.G_MISS_CHAR,NULL, NULL,po_line_number,
1725: p_trxn_attribs.PO_Line_Number),
1726: trxn_ref_number1 = DECODE(p_trxn_attribs.Trxn_Ref_Number1,
1727: FND_API.G_MISS_CHAR,NULL, NULL,trxn_ref_number1,
1728: p_trxn_attribs.Trxn_Ref_Number1),

Line 1727: FND_API.G_MISS_CHAR,NULL, NULL,trxn_ref_number1,

1723: po_line_number = DECODE(p_trxn_attribs.PO_Line_Number,
1724: FND_API.G_MISS_CHAR,NULL, NULL,po_line_number,
1725: p_trxn_attribs.PO_Line_Number),
1726: trxn_ref_number1 = DECODE(p_trxn_attribs.Trxn_Ref_Number1,
1727: FND_API.G_MISS_CHAR,NULL, NULL,trxn_ref_number1,
1728: p_trxn_attribs.Trxn_Ref_Number1),
1729: trxn_ref_number2 = DECODE(p_trxn_attribs.Trxn_Ref_Number2,
1730: FND_API.G_MISS_CHAR,NULL, NULL,trxn_ref_number2,
1731: p_trxn_attribs.Trxn_Ref_Number2),

Line 1730: FND_API.G_MISS_CHAR,NULL, NULL,trxn_ref_number2,

1726: trxn_ref_number1 = DECODE(p_trxn_attribs.Trxn_Ref_Number1,
1727: FND_API.G_MISS_CHAR,NULL, NULL,trxn_ref_number1,
1728: p_trxn_attribs.Trxn_Ref_Number1),
1729: trxn_ref_number2 = DECODE(p_trxn_attribs.Trxn_Ref_Number2,
1730: FND_API.G_MISS_CHAR,NULL, NULL,trxn_ref_number2,
1731: p_trxn_attribs.Trxn_Ref_Number2),
1732: additional_info = DECODE(p_trxn_attribs.Additional_Info,
1733: FND_API.G_MISS_CHAR,NULL, NULL,additional_info,
1734: p_trxn_attribs.Additional_Info),

Line 1733: FND_API.G_MISS_CHAR,NULL, NULL,additional_info,

1729: trxn_ref_number2 = DECODE(p_trxn_attribs.Trxn_Ref_Number2,
1730: FND_API.G_MISS_CHAR,NULL, NULL,trxn_ref_number2,
1731: p_trxn_attribs.Trxn_Ref_Number2),
1732: additional_info = DECODE(p_trxn_attribs.Additional_Info,
1733: FND_API.G_MISS_CHAR,NULL, NULL,additional_info,
1734: p_trxn_attribs.Additional_Info),
1735: last_updated_by = fnd_global.user_id,
1736: last_update_date = SYSDATE,
1737: last_update_login = fnd_global.login_id,

Line 1745: (p_trxn_attribs.Instrument_Security_Code <> FND_API.G_MISS_CHAR)

1741: IF( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1742: iby_debug_pub.add('updating extension',G_LEVEL_STATEMENT,l_dbg_mod);
1743: END IF;
1744: IF (NOT p_trxn_attribs.Instrument_Security_Code IS NULL) AND
1745: (p_trxn_attribs.Instrument_Security_Code <> FND_API.G_MISS_CHAR)
1746: THEN
1747: iby_debug_pub.add('deleting l_seg_id_old',G_LEVEL_STATEMENT,l_dbg_mod);
1748: DELETE FROM iby_security_segments
1749: WHERE (sec_segment_id = l_seg_id_old);

Line 1759: IF FND_API.To_Boolean(p_commit) THEN

1755: x_response.Result_Code := G_RC_INVALID_EXTENSION_ID;
1756: END IF;
1757: END IF;
1758:
1759: IF FND_API.To_Boolean(p_commit) THEN
1760: COMMIT;
1761: END IF;
1762:
1763: iby_fndcpt_common_pub.Prepare_Result

Line 1772: WHEN FND_API.G_EXC_ERROR THEN

1768: END IF;
1769:
1770: EXCEPTION
1771:
1772: WHEN FND_API.G_EXC_ERROR THEN
1773:
1774: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
1775: debug_level => G_LEVEL_ERROR,
1776: module => G_DEBUG_MODULE || l_module);

Line 1777: x_return_status := FND_API.G_RET_STS_ERROR;

1773:
1774: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
1775: debug_level => G_LEVEL_ERROR,
1776: module => G_DEBUG_MODULE || l_module);
1777: x_return_status := FND_API.G_RET_STS_ERROR;
1778: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1779: p_data => x_msg_data
1780: );
1781: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1781: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1777: x_return_status := FND_API.G_RET_STS_ERROR;
1778: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1779: p_data => x_msg_data
1780: );
1781: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1782:
1783: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
1784: debug_level => G_LEVEL_UNEXPECTED,
1785: module => G_DEBUG_MODULE || l_module);

Line 1786: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1782:
1783: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
1784: debug_level => G_LEVEL_UNEXPECTED,
1785: module => G_DEBUG_MODULE || l_module);
1786: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1787: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1788: p_data => x_msg_data
1789: );
1790: WHEN OTHERS THEN

Line 1798: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1794: module => G_DEBUG_MODULE || l_module);
1795:
1796: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
1797:
1798: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1799: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1800: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
1801: END IF;
1802:

Line 1813: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1809:
1810: PROCEDURE Get_Transaction_Extension
1811: (
1812: p_api_version IN NUMBER,
1813: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1814: x_return_status OUT NOCOPY VARCHAR2,
1815: x_msg_count OUT NOCOPY NUMBER,
1816: x_msg_data OUT NOCOPY VARCHAR2,
1817: p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,

Line 1853: IF NOT FND_API.Compatible_API_Call (l_api_version,

1849: IF (c_extension%ISOPEN) THEN
1850: CLOSE c_extension;
1851: END IF;
1852:
1853: IF NOT FND_API.Compatible_API_Call (l_api_version,
1854: p_api_version,
1855: l_module,
1856: G_PKG_NAME)
1857: THEN

Line 1865: RAISE FND_API.G_EXC_ERROR;

1861: module => G_DEBUG_MODULE || l_module);
1862: END IF;
1863: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
1864: FND_MSG_PUB.Add;
1865: RAISE FND_API.G_EXC_ERROR;
1866: END IF;
1867:
1868: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1869: FND_MSG_PUB.initialize;

Line 1868: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1864: FND_MSG_PUB.Add;
1865: RAISE FND_API.G_EXC_ERROR;
1866: END IF;
1867:
1868: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1869: FND_MSG_PUB.initialize;
1870: END IF;
1871: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
1872:

Line 1876: IBY_FNDCPT_SETUP_PUB.Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,

1872:
1873: IF( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1874: iby_debug_pub.add('checking payer contxt',G_LEVEL_STATEMENT,l_dbg_mod);
1875: END IF;
1876: IBY_FNDCPT_SETUP_PUB.Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,
1877: l_payer_level,l_payer_id,l_payer_attribs);
1878:
1879: IF (l_payer_level = IBY_FNDCPT_COMMON_PUB.G_RC_INVALID_PAYER) THEN
1880: x_response.Result_Code := IBY_FNDCPT_COMMON_PUB.G_RC_INVALID_PAYER;

Line 1912: WHEN FND_API.G_EXC_ERROR THEN

1908: iby_debug_pub.add('Exit',G_LEVEL_PROCEDURE,l_dbg_mod);
1909: END IF;
1910: EXCEPTION
1911:
1912: WHEN FND_API.G_EXC_ERROR THEN
1913:
1914: IF( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1915: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
1916: debug_level => G_LEVEL_EXCEPTION,

Line 1919: x_return_status := FND_API.G_RET_STS_ERROR;

1915: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
1916: debug_level => G_LEVEL_EXCEPTION,
1917: module => G_DEBUG_MODULE || l_module);
1918: END IF;
1919: x_return_status := FND_API.G_RET_STS_ERROR;
1920: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1921: p_data => x_msg_data
1922: );
1923: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1923: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1919: x_return_status := FND_API.G_RET_STS_ERROR;
1920: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1921: p_data => x_msg_data
1922: );
1923: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1924:
1925: IF( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
1926: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
1927: debug_level => G_LEVEL_UNEXPECTED,

Line 1930: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1926: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
1927: debug_level => G_LEVEL_UNEXPECTED,
1928: module => G_DEBUG_MODULE || l_module);
1929: END IF;
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

Line 1944: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1940: END IF;
1941:
1942: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
1943:
1944: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1945: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1946: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
1947: END IF;
1948:

Line 1968: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1964:
1965: PROCEDURE Delete_Transaction_Extension
1966: (
1967: p_api_version IN NUMBER,
1968: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1969: p_commit IN VARCHAR2 := FND_API.G_TRUE,
1970: x_return_status OUT NOCOPY VARCHAR2,
1971: x_msg_count OUT NOCOPY NUMBER,
1972: x_msg_data OUT NOCOPY VARCHAR2,

Line 1969: p_commit IN VARCHAR2 := FND_API.G_TRUE,

1965: PROCEDURE Delete_Transaction_Extension
1966: (
1967: p_api_version IN NUMBER,
1968: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1969: p_commit IN VARCHAR2 := FND_API.G_TRUE,
1970: x_return_status OUT NOCOPY VARCHAR2,
1971: x_msg_count OUT NOCOPY NUMBER,
1972: x_msg_data OUT NOCOPY VARCHAR2,
1973: p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,

Line 2022: IF NOT FND_API.Compatible_API_Call (l_api_version,

2018: IF (c_extension%ISOPEN) THEN
2019: CLOSE c_extension;
2020: END IF;
2021:
2022: IF NOT FND_API.Compatible_API_Call (l_api_version,
2023: p_api_version,
2024: l_module,
2025: G_PKG_NAME)
2026: THEN

Line 2034: RAISE FND_API.G_EXC_ERROR;

2030: module => G_DEBUG_MODULE || l_module);
2031: END IF;
2032: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
2033: FND_MSG_PUB.Add;
2034: RAISE FND_API.G_EXC_ERROR;
2035: END IF;
2036:
2037: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2038: FND_MSG_PUB.initialize;

Line 2037: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2033: FND_MSG_PUB.Add;
2034: RAISE FND_API.G_EXC_ERROR;
2035: END IF;
2036:
2037: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2038: FND_MSG_PUB.initialize;
2039: END IF;
2040: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
2041:

Line 2045: IBY_FNDCPT_SETUP_PUB.Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,

2041:
2042: IF( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2043: iby_debug_pub.add('checking payer contxt',G_LEVEL_STATEMENT,l_dbg_mod);
2044: END IF;
2045: IBY_FNDCPT_SETUP_PUB.Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,
2046: l_payer_level,l_payer_id,l_payer_attribs);
2047:
2048: IF (l_payer_level = IBY_FNDCPT_COMMON_PUB.G_RC_INVALID_PAYER) THEN
2049: x_response.Result_Code := IBY_FNDCPT_COMMON_PUB.G_RC_INVALID_PAYER;

Line 2084: IF FND_API.To_Boolean(p_commit) THEN

2080: END IF;
2081: CLOSE c_extension;
2082: END IF;
2083:
2084: IF FND_API.To_Boolean(p_commit) THEN
2085: COMMIT;
2086: END IF;
2087:
2088: iby_fndcpt_common_pub.Prepare_Result

Line 2096: WHEN FND_API.G_EXC_ERROR THEN

2092: iby_debug_pub.add('Exit',G_LEVEL_PROCEDURE,l_dbg_mod);
2093: END IF;
2094: EXCEPTION
2095:
2096: WHEN FND_API.G_EXC_ERROR THEN
2097: ROLLBACK TO Delete_Transaction_Extension;
2098: IF( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
2099: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
2100: debug_level => G_LEVEL_EXCEPTION,

Line 2103: x_return_status := FND_API.G_RET_STS_ERROR;

2099: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
2100: debug_level => G_LEVEL_EXCEPTION,
2101: module => G_DEBUG_MODULE || l_module);
2102: END IF;
2103: x_return_status := FND_API.G_RET_STS_ERROR;
2104: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2105: p_data => x_msg_data
2106: );
2107: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2107: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2103: x_return_status := FND_API.G_RET_STS_ERROR;
2104: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2105: p_data => x_msg_data
2106: );
2107: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2108: ROLLBACK TO Delete_Transaction_Extension;
2109: IF( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
2110: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
2111: debug_level => G_LEVEL_UNEXPECTED,

Line 2114: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2110: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
2111: debug_level => G_LEVEL_UNEXPECTED,
2112: module => G_DEBUG_MODULE || l_module);
2113: END IF;
2114: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2115: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2116: p_data => x_msg_data
2117: );
2118:

Line 2129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2125: END IF;
2126:
2127: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
2128:
2129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2130: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2131: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
2132: END IF;
2133:

Line 2152: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2148:
2149: PROCEDURE Copy_Transaction_Extension
2150: (
2151: p_api_version IN NUMBER,
2152: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2153: p_commit IN VARCHAR2 := FND_API.G_TRUE,
2154: x_return_status OUT NOCOPY VARCHAR2,
2155: x_msg_count OUT NOCOPY NUMBER,
2156: x_msg_data OUT NOCOPY VARCHAR2,

Line 2153: p_commit IN VARCHAR2 := FND_API.G_TRUE,

2149: PROCEDURE Copy_Transaction_Extension
2150: (
2151: p_api_version IN NUMBER,
2152: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2153: p_commit IN VARCHAR2 := FND_API.G_TRUE,
2154: x_return_status OUT NOCOPY VARCHAR2,
2155: x_msg_count OUT NOCOPY NUMBER,
2156: x_msg_data OUT NOCOPY VARCHAR2,
2157: p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,

Line 2287: IF NOT FND_API.Compatible_API_Call (l_api_version,

2283:
2284: IF (c_extension%ISOPEN) THEN CLOSE c_extension; END IF;
2285: IF (c_auths%ISOPEN) THEN CLOSE c_auths; END IF;
2286:
2287: IF NOT FND_API.Compatible_API_Call (l_api_version,
2288: p_api_version,
2289: l_module,
2290: G_PKG_NAME)
2291: THEN

Line 2299: RAISE FND_API.G_EXC_ERROR;

2295: module => G_DEBUG_MODULE || l_module);
2296: END IF;
2297: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
2298: FND_MSG_PUB.Add;
2299: RAISE FND_API.G_EXC_ERROR;
2300: END IF;
2301:
2302: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2303: FND_MSG_PUB.initialize;

Line 2302: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2298: FND_MSG_PUB.Add;
2299: RAISE FND_API.G_EXC_ERROR;
2300: END IF;
2301:
2302: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2303: FND_MSG_PUB.initialize;
2304: END IF;
2305: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
2306:

Line 2320: IBY_FNDCPT_SETUP_PUB.Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,

2316: iby_debug_pub.add('org id =' || p_payer.Org_Id,G_LEVEL_STATEMENT,l_dbg_mod);
2317: iby_debug_pub.add('org type =' || p_payer.Org_Type,G_LEVEL_STATEMENT,l_dbg_mod);
2318: END IF;
2319:
2320: IBY_FNDCPT_SETUP_PUB.Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,
2321: l_payer_level,l_payer_id,l_payer_attribs);
2322:
2323: iby_debug_pub.add('l_payer_level: '|| l_payer_level,G_LEVEL_STATEMENT,l_dbg_mod);
2324: iby_debug_pub.add('l_payer_id: '|| l_payer_id,G_LEVEL_STATEMENT,l_dbg_mod);

Line 2347: IBY_FNDCPT_SETUP_PUB.Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,

2343: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
2344: RETURN;
2345: END IF;
2346:
2347: IBY_FNDCPT_SETUP_PUB.Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,
2348: l_payer_level,l_payer_id,l_payer_attribs);
2349:
2350: iby_debug_pub.add('l_payer_id: '|| l_payer_id,G_LEVEL_STATEMENT,l_dbg_mod);
2351:

Line 2358: (1.0, FND_API.G_FALSE, FND_API.G_FALSE,

2354: IF( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2355: iby_debug_pub.add('setting payer attribs',G_LEVEL_STATEMENT,l_dbg_mod);
2356: END IF;
2357: IBY_FNDCPT_SETUP_PUB.Set_Payer_Attributes
2358: (1.0, FND_API.G_FALSE, FND_API.G_FALSE,
2359: x_return_status, x_msg_count, x_msg_data,
2360: p_payer, l_payer_attribs, l_payer_id, lx_result
2361: );
2362:

Line 2501: (FND_API.G_FALSE,

2497: iby_debug_pub.add('Encryption is IMMEDIATE.',G_LEVEL_STATEMENT,l_dbg_mod);
2498: END IF;
2499: -- Make an HTTP call out to the middle tier
2500: IBY_PAYMENT_ADAPTER_PUB.OraSecureExtension
2501: (FND_API.G_FALSE,
2502: l_extension.Instrument_security_Code,
2503: l_return_status,
2504: l_msg_count,
2505: l_msg_data,

Line 2664: IF FND_API.To_Boolean(p_commit) THEN

2660:
2661: iby_fndcpt_common_pub.Prepare_Result
2662: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
2663:
2664: IF FND_API.To_Boolean(p_commit) THEN
2665: COMMIT;
2666: END IF;
2667:
2668: IF( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 2673: WHEN FND_API.G_EXC_ERROR THEN

2669: iby_debug_pub.add('Exit',G_LEVEL_PROCEDURE,l_dbg_mod);
2670: END IF;
2671: EXCEPTION
2672:
2673: WHEN FND_API.G_EXC_ERROR THEN
2674: ROLLBACK TO Copy_Txn_Extension_Merge;
2675: IF( G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
2676: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
2677: debug_level => G_LEVEL_ERROR,

Line 2680: x_return_status := FND_API.G_RET_STS_ERROR;

2676: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
2677: debug_level => G_LEVEL_ERROR,
2678: module => G_DEBUG_MODULE || l_module);
2679: END IF;
2680: x_return_status := FND_API.G_RET_STS_ERROR;
2681: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2682: p_data => x_msg_data
2683: );
2684: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2684: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2680: x_return_status := FND_API.G_RET_STS_ERROR;
2681: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2682: p_data => x_msg_data
2683: );
2684: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2685: ROLLBACK TO Copy_Txn_Extension_Merge;
2686: IF( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
2687: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
2688: debug_level => G_LEVEL_UNEXPECTED,

Line 2691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2687: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
2688: debug_level => G_LEVEL_UNEXPECTED,
2689: module => G_DEBUG_MODULE || l_module);
2690: END IF;
2691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2692: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2693: p_data => x_msg_data
2694: );
2695:

Line 2707: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2703: END IF;
2704:
2705: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
2706:
2707: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2708: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2709: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
2710: END IF;
2711:

Line 2784: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2780:
2781: PROCEDURE Create_Authorization
2782: (
2783: p_api_version IN NUMBER,
2784: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2785: x_return_status OUT NOCOPY VARCHAR2,
2786: x_msg_count OUT NOCOPY NUMBER,
2787: x_msg_data OUT NOCOPY VARCHAR2,
2788: p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,

Line 2951: IF NOT FND_API.Compatible_API_Call (l_api_version,

2947: IF (c_auth%ISOPEN) THEN CLOSE c_auth; END IF;
2948: IF (c_instr_extensions%ISOPEN) THEN CLOSE c_instr_extensions; END IF;
2949: IF (c_operation_count%ISOPEN) THEN CLOSE c_operation_count; END IF;
2950:
2951: IF NOT FND_API.Compatible_API_Call (l_api_version,
2952: p_api_version,
2953: l_module,
2954: G_PKG_NAME)
2955: THEN

Line 2963: RAISE FND_API.G_EXC_ERROR;

2959: module => G_DEBUG_MODULE || l_module);
2960: END IF;
2961: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
2962: FND_MSG_PUB.Add;
2963: RAISE FND_API.G_EXC_ERROR;
2964: END IF;
2965:
2966: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2967: FND_MSG_PUB.initialize;

Line 2966: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2962: FND_MSG_PUB.Add;
2963: RAISE FND_API.G_EXC_ERROR;
2964: END IF;
2965:
2966: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2967: FND_MSG_PUB.initialize;
2968: END IF;
2969: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
2970:

Line 2979: IBY_FNDCPT_SETUP_PUB.Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,

2975: iby_debug_pub.add('account site use id =' || p_payer.Account_Site_Id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2976: iby_debug_pub.add('org id =' || p_payer.Org_Id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2977: iby_debug_pub.add('org type =' || p_payer.Org_Type,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2978: END IF;
2979: IBY_FNDCPT_SETUP_PUB.Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,
2980: l_payer_level,l_payer_id,l_payer_attribs);
2981:
2982: iby_debug_pub.add('l_payer_level: '|| l_payer_level,G_LEVEL_STATEMENT,l_dbg_mod);
2983: iby_debug_pub.add('l_payer_id: '|| l_payer_id,G_LEVEL_STATEMENT,l_dbg_mod);

Line 3155: FND_API.G_FALSE,

3151: END IF;
3152: IBY_PAYMENT_ADAPTER_PUB.OraPmtReq
3153: (1.0,
3154: p_init_msg_list,
3155: FND_API.G_FALSE,
3156: FND_API.G_VALID_LEVEL_FULL,
3157: l_ecapp_id,
3158: l_payee,
3159: l_payer,

Line 3156: FND_API.G_VALID_LEVEL_FULL,

3152: IBY_PAYMENT_ADAPTER_PUB.OraPmtReq
3153: (1.0,
3154: p_init_msg_list,
3155: FND_API.G_FALSE,
3156: FND_API.G_VALID_LEVEL_FULL,
3157: l_ecapp_id,
3158: l_payee,
3159: l_payer,
3160: l_pmt_instr,

Line 3422: l_reqresp.Response.ErrMessage := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded => FND_API.G_FALSE) || ' (' ||

3418: l_reqresp.Response.ErrCode || ')';
3419: iby_debug_pub.add('Response Message from engine: '||l_reqresp.Response.ErrMessage,G_LEVEL_STATEMENT,l_dbg_mod);
3420: --End of Bug:10240644.
3421: ELSE
3422: l_reqresp.Response.ErrMessage := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded => FND_API.G_FALSE) || ' (' ||
3423: FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded => FND_API.G_TRUE) || ')';
3424: l_reqresp.Response.ErrCode := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded => FND_API.G_TRUE);
3425: iby_debug_pub.add('Response Message from FND Stack: '||l_reqresp.Response.ErrMessage,G_LEVEL_STATEMENT,l_dbg_mod);
3426: END IF;

Line 3423: FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded => FND_API.G_TRUE) || ')';

3419: iby_debug_pub.add('Response Message from engine: '||l_reqresp.Response.ErrMessage,G_LEVEL_STATEMENT,l_dbg_mod);
3420: --End of Bug:10240644.
3421: ELSE
3422: l_reqresp.Response.ErrMessage := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded => FND_API.G_FALSE) || ' (' ||
3423: FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded => FND_API.G_TRUE) || ')';
3424: l_reqresp.Response.ErrCode := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded => FND_API.G_TRUE);
3425: iby_debug_pub.add('Response Message from FND Stack: '||l_reqresp.Response.ErrMessage,G_LEVEL_STATEMENT,l_dbg_mod);
3426: END IF;
3427:

Line 3424: l_reqresp.Response.ErrCode := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded => FND_API.G_TRUE);

3420: --End of Bug:10240644.
3421: ELSE
3422: l_reqresp.Response.ErrMessage := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded => FND_API.G_FALSE) || ' (' ||
3423: FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded => FND_API.G_TRUE) || ')';
3424: l_reqresp.Response.ErrCode := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded => FND_API.G_TRUE);
3425: iby_debug_pub.add('Response Message from FND Stack: '||l_reqresp.Response.ErrMessage,G_LEVEL_STATEMENT,l_dbg_mod);
3426: END IF;
3427:
3428: iby_fndcpt_common_pub.Prepare_Result(

Line 3493: WHEN FND_API.G_EXC_ERROR THEN

3489: iby_debug_pub.add('Exit',G_LEVEL_PROCEDURE,l_module);
3490: END IF;
3491: EXCEPTION
3492:
3493: WHEN FND_API.G_EXC_ERROR THEN
3494:
3495: IF( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
3496: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
3497: debug_level => G_LEVEL_EXCEPTION,

Line 3500: x_return_status := FND_API.G_RET_STS_ERROR;

3496: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
3497: debug_level => G_LEVEL_EXCEPTION,
3498: module => G_DEBUG_MODULE || l_module);
3499: END IF;
3500: x_return_status := FND_API.G_RET_STS_ERROR;
3501: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
3502: p_data => x_msg_data
3503: );
3504: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3504: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3500: x_return_status := FND_API.G_RET_STS_ERROR;
3501: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
3502: p_data => x_msg_data
3503: );
3504: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3505:
3506: IF( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
3507: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
3508: debug_level => G_LEVEL_UNEXPECTED,

Line 3511: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3507: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
3508: debug_level => G_LEVEL_UNEXPECTED,
3509: module => G_DEBUG_MODULE || l_module);
3510: END IF;
3511: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3512: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
3513: p_data => x_msg_data
3514: );
3515:

Line 3526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3522: END IF;
3523:
3524: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
3525:
3526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3527: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3528: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
3529: END IF;
3530:

Line 3543: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

3539:
3540: PROCEDURE Get_Authorization
3541: (
3542: p_api_version IN NUMBER,
3543: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3544: x_return_status OUT NOCOPY VARCHAR2,
3545: x_msg_count OUT NOCOPY NUMBER,
3546: x_msg_data OUT NOCOPY VARCHAR2,
3547: p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,

Line 3575: IF NOT FND_API.Compatible_API_Call (l_api_version,

3571:
3572:
3573: IF (c_auth%ISOPEN) THEN CLOSE c_auth; END IF;
3574:
3575: IF NOT FND_API.Compatible_API_Call (l_api_version,
3576: p_api_version,
3577: l_module,
3578: G_PKG_NAME)
3579: THEN

Line 3587: RAISE FND_API.G_EXC_ERROR;

3583: module => G_DEBUG_MODULE || l_module);
3584: END IF;
3585: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
3586: FND_MSG_PUB.Add;
3587: RAISE FND_API.G_EXC_ERROR;
3588: END IF;
3589:
3590: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3591: FND_MSG_PUB.initialize;

Line 3590: IF FND_API.to_Boolean( p_init_msg_list ) THEN

3586: FND_MSG_PUB.Add;
3587: RAISE FND_API.G_EXC_ERROR;
3588: END IF;
3589:
3590: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3591: FND_MSG_PUB.initialize;
3592: END IF;
3593: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
3594:

Line 3616: WHEN FND_API.G_EXC_ERROR THEN

3612: END IF;
3613:
3614: EXCEPTION
3615:
3616: WHEN FND_API.G_EXC_ERROR THEN
3617:
3618: IF( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
3619: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
3620: debug_level => G_LEVEL_EXCEPTION,

Line 3623: x_return_status := FND_API.G_RET_STS_ERROR;

3619: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
3620: debug_level => G_LEVEL_EXCEPTION,
3621: module => G_DEBUG_MODULE || l_module);
3622: END IF;
3623: x_return_status := FND_API.G_RET_STS_ERROR;
3624: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
3625: p_data => x_msg_data
3626: );
3627: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3627: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3623: x_return_status := FND_API.G_RET_STS_ERROR;
3624: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
3625: p_data => x_msg_data
3626: );
3627: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3628:
3629: IF( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
3630: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
3631: debug_level => G_LEVEL_UNEXPECTED,

Line 3634: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3630: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
3631: debug_level => G_LEVEL_UNEXPECTED,
3632: module => G_DEBUG_MODULE || l_module);
3633: END IF;
3634: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3635: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
3636: p_data => x_msg_data
3637: );
3638:

Line 3649: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3645: END IF;
3646:
3647: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
3648:
3649: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3650: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3651: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
3652: END IF;
3653:

Line 3664: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

3660:
3661: PROCEDURE Cancel_Authorization
3662: (
3663: p_api_version IN NUMBER,
3664: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3665: x_return_status OUT NOCOPY VARCHAR2,
3666: x_msg_count OUT NOCOPY NUMBER,
3667: x_msg_data OUT NOCOPY VARCHAR2,
3668: p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,

Line 3682: IF NOT FND_API.Compatible_API_Call (l_api_version,

3678: iby_debug_pub.add('Enter',G_LEVEL_PROCEDURE,l_module);
3679: END IF;
3680:
3681:
3682: IF NOT FND_API.Compatible_API_Call (l_api_version,
3683: p_api_version,
3684: l_module,
3685: G_PKG_NAME)
3686: THEN

Line 3692: RAISE FND_API.G_EXC_ERROR;

3688: debug_level => G_LEVEL_ERROR,
3689: module => G_DEBUG_MODULE || l_module);
3690: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
3691: FND_MSG_PUB.Add;
3692: RAISE FND_API.G_EXC_ERROR;
3693: END IF;
3694:
3695: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3696: FND_MSG_PUB.initialize;

Line 3695: IF FND_API.to_Boolean( p_init_msg_list ) THEN

3691: FND_MSG_PUB.Add;
3692: RAISE FND_API.G_EXC_ERROR;
3693: END IF;
3694:
3695: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3696: FND_MSG_PUB.initialize;
3697: END IF;
3698: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
3699:

Line 3711: WHEN FND_API.G_EXC_ERROR THEN

3707: END IF;
3708:
3709: EXCEPTION
3710:
3711: WHEN FND_API.G_EXC_ERROR THEN
3712:
3713: IF( G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
3714: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
3715: debug_level => G_LEVEL_ERROR,

Line 3718: x_return_status := FND_API.G_RET_STS_ERROR;

3714: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
3715: debug_level => G_LEVEL_ERROR,
3716: module => G_DEBUG_MODULE || l_module);
3717: END IF;
3718: x_return_status := FND_API.G_RET_STS_ERROR;
3719: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
3720: p_data => x_msg_data
3721: );
3722: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3722: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3718: x_return_status := FND_API.G_RET_STS_ERROR;
3719: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
3720: p_data => x_msg_data
3721: );
3722: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3723: IF( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
3724: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
3725: debug_level => G_LEVEL_UNEXPECTED,
3726: module => G_DEBUG_MODULE || l_module);

Line 3728: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3724: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
3725: debug_level => G_LEVEL_UNEXPECTED,
3726: module => G_DEBUG_MODULE || l_module);
3727: END IF;
3728: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3729: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
3730: p_data => x_msg_data
3731: );
3732:

Line 3743: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3739: END IF;
3740:
3741: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
3742:
3743: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3744: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3745: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
3746: END IF;
3747:

Line 3760: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

3756:
3757: PROCEDURE Create_Settlement
3758: (
3759: p_api_version IN NUMBER,
3760: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3761: x_return_status OUT NOCOPY VARCHAR2,
3762: x_msg_count OUT NOCOPY NUMBER,
3763: x_msg_data OUT NOCOPY VARCHAR2,
3764: p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,

Line 3877: IF NOT FND_API.Compatible_API_Call (l_api_version,

3873: IF (c_auth%ISOPEN) THEN CLOSE c_auth; END IF;
3874: IF (c_payee%ISOPEN) THEN CLOSE c_payee; END IF;
3875: IF (c_operation_count%ISOPEN) THEN CLOSE c_operation_count; END IF;
3876:
3877: IF NOT FND_API.Compatible_API_Call (l_api_version,
3878: p_api_version,
3879: l_module,
3880: G_PKG_NAME)
3881: THEN

Line 3889: RAISE FND_API.G_EXC_ERROR;

3885: module => G_DEBUG_MODULE || l_module);
3886: END IF;
3887: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
3888: FND_MSG_PUB.Add;
3889: RAISE FND_API.G_EXC_ERROR;
3890: END IF;
3891:
3892: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3893: FND_MSG_PUB.initialize;

Line 3892: IF FND_API.to_Boolean( p_init_msg_list ) THEN

3888: FND_MSG_PUB.Add;
3889: RAISE FND_API.G_EXC_ERROR;
3890: END IF;
3891:
3892: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3893: FND_MSG_PUB.initialize;
3894: END IF;
3895: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
3896:

Line 3897: IBY_FNDCPT_SETUP_PUB.Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,

3893: FND_MSG_PUB.initialize;
3894: END IF;
3895: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
3896:
3897: IBY_FNDCPT_SETUP_PUB.Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,
3898: l_payer_level,l_payer_id,l_payer_attribs);
3899:
3900: IF (l_payer_level = IBY_FNDCPT_COMMON_PUB.G_RC_INVALID_PAYER) THEN
3901: IF( G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 3985: (1.0, p_init_msg_list, FND_API.G_FALSE, FND_API.G_VALID_LEVEL_FULL,

3981: IF( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3982: iby_debug_pub.add('calling IBY_PAYMENT_ADAPTER_PUB.oraPmtReq ',G_LEVEL_STATEMENT,l_dbg_mod);
3983: END IF;
3984: IBY_PAYMENT_ADAPTER_PUB.OraPmtReq
3985: (1.0, p_init_msg_list, FND_API.G_FALSE, FND_API.G_VALID_LEVEL_FULL,
3986: l_ecapp_id, l_payee, l_payer, l_pmt_instr,
3987: l_tangible,
3988: l_pmt_trxn,
3989: lx_return_status,

Line 4167: (1.0, p_init_msg_list, FND_API.G_FALSE, FND_API.G_VALID_LEVEL_FULL,

4163: IF( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4164: iby_debug_pub.add('Create Settlement- calling OraPmtCapture ' ,G_LEVEL_STATEMENT,l_dbg_mod);
4165: END IF;
4166: IBY_PAYMENT_ADAPTER_PUB.OraPmtCapture
4167: (1.0, p_init_msg_list, FND_API.G_FALSE, FND_API.G_VALID_LEVEL_FULL,
4168: l_ecapp_id, l_capture_trxn,
4169: lx_return_status, lx_msg_count, lx_msg_data, lx_capresp
4170: );
4171:

Line 4253: WHEN FND_API.G_EXC_ERROR THEN

4249:
4250:
4251: EXCEPTION
4252:
4253: WHEN FND_API.G_EXC_ERROR THEN
4254:
4255: IF( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
4256: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
4257: debug_level => G_LEVEL_EXCEPTION,

Line 4260: x_return_status := FND_API.G_RET_STS_ERROR;

4256: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
4257: debug_level => G_LEVEL_EXCEPTION,
4258: module => G_DEBUG_MODULE || l_module);
4259: END IF;
4260: x_return_status := FND_API.G_RET_STS_ERROR;
4261: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
4262: p_data => x_msg_data
4263: );
4264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4260: x_return_status := FND_API.G_RET_STS_ERROR;
4261: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
4262: p_data => x_msg_data
4263: );
4264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4265: IF( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
4266: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
4267: debug_level => G_LEVEL_UNEXPECTED,
4268: module => G_DEBUG_MODULE || l_module);

Line 4270: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4266: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
4267: debug_level => G_LEVEL_UNEXPECTED,
4268: module => G_DEBUG_MODULE || l_module);
4269: END IF;
4270: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4271: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
4272: p_data => x_msg_data
4273: );
4274:

Line 4284: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4280: module => G_DEBUG_MODULE || l_module);
4281: END IF;
4282: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
4283:
4284: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4285: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4286: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
4287: END IF;
4288:

Line 4300: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

4296: --Overloaded API for backward compatibility
4297: PROCEDURE Create_Settlement
4298: (
4299: p_api_version IN NUMBER,
4300: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4301: x_return_status OUT NOCOPY VARCHAR2,
4302: x_msg_count OUT NOCOPY NUMBER,
4303: x_msg_data OUT NOCOPY VARCHAR2,
4304: p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,

Line 4365: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

4361: --
4362:
4363: PROCEDURE Create_Settlements (
4364: p_api_version IN NUMBER,
4365: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
4366: p_calling_app_id IN NUMBER,
4367: p_calling_app_request_code IN IBY_TRXN_SUMMARIES_ALL.CALL_APP_SERVICE_REQ_CODE%TYPE,
4368: p_order_view_name IN VARCHAR2,
4369: x_return_status OUT NOCOPY VARCHAR2,

Line 4506: IF NOT FND_API.Compatible_API_Call(l_api_version,

4502:
4503: SAVEPOINT create_settlements_pub;
4504:
4505: -- Standard call to check for call compatibility.
4506: IF NOT FND_API.Compatible_API_Call(l_api_version,
4507: p_api_version,
4508: l_api_name,
4509: G_PKG_NAME) THEN
4510: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4510: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4506: IF NOT FND_API.Compatible_API_Call(l_api_version,
4507: p_api_version,
4508: l_api_name,
4509: G_PKG_NAME) THEN
4510: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4511: END IF;
4512:
4513: -- Initialize message list if p_init_msg_list is set to TRUE.
4514: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 4514: IF FND_API.to_Boolean(p_init_msg_list) THEN

4510: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4511: END IF;
4512:
4513: -- Initialize message list if p_init_msg_list is set to TRUE.
4514: IF FND_API.to_Boolean(p_init_msg_list) THEN
4515: FND_MSG_PUB.initialize;
4516: END IF;
4517: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
4518:

Line 4520: x_return_status := FND_API.G_RET_STS_SUCCESS;

4516: END IF;
4517: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
4518:
4519: -- Initialize API return status to success
4520: x_return_status := FND_API.G_RET_STS_SUCCESS;
4521:
4522: -- Start of API body
4523:
4524: --

Line 5154: (1.0, p_init_msg_list, FND_API.G_FALSE,

5150: x_rev_responses(l).Result.Result_Code := IBY_FNDCPT_COMMON_PUB.G_RC_GENERIC_SYS_ERROR;
5151: l_interface_code := IBY_FNDCPT_COMMON_PUB.G_INTERFACE_CODE;
5152:
5153: IBY_PAYMENT_ADAPTER_PUB.OraPmtReverse
5154: (1.0, p_init_msg_list, FND_API.G_FALSE,
5155: FND_API.G_VALID_LEVEL_FULL, l_ecapp_id,
5156: l_rev_trxn, lx_return_status, lx_msg_count,
5157: lx_msg_data, lx_rev_resp
5158: );

Line 5155: FND_API.G_VALID_LEVEL_FULL, l_ecapp_id,

5151: l_interface_code := IBY_FNDCPT_COMMON_PUB.G_INTERFACE_CODE;
5152:
5153: IBY_PAYMENT_ADAPTER_PUB.OraPmtReverse
5154: (1.0, p_init_msg_list, FND_API.G_FALSE,
5155: FND_API.G_VALID_LEVEL_FULL, l_ecapp_id,
5156: l_rev_trxn, lx_return_status, lx_msg_count,
5157: lx_msg_data, lx_rev_resp
5158: );
5159: IF( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 5503: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

5499:
5500: -- End of API body
5501:
5502: -- get message count and if count is 1, get message info.
5503: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5504: p_count => x_msg_count,
5505: p_data => x_msg_data);
5506:
5507: print_debuginfo(l_module_name, 'RETURN');

Line 5510: WHEN fnd_api.g_exc_error THEN

5506:
5507: print_debuginfo(l_module_name, 'RETURN');
5508:
5509: EXCEPTION
5510: WHEN fnd_api.g_exc_error THEN
5511: --ROLLBACK TO create_settlements_pub;
5512: x_return_status := fnd_api.g_ret_sts_error;
5513:
5514: print_debuginfo(l_module_name, 'Exception : ' || SQLERRM);

Line 5512: x_return_status := fnd_api.g_ret_sts_error;

5508:
5509: EXCEPTION
5510: WHEN fnd_api.g_exc_error THEN
5511: --ROLLBACK TO create_settlements_pub;
5512: x_return_status := fnd_api.g_ret_sts_error;
5513:
5514: print_debuginfo(l_module_name, 'Exception : ' || SQLERRM);
5515:
5516: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

Line 5516: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

5512: x_return_status := fnd_api.g_ret_sts_error;
5513:
5514: print_debuginfo(l_module_name, 'Exception : ' || SQLERRM);
5515:
5516: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5517: p_count => x_msg_count,
5518: p_data => x_msg_data);
5519:
5520:

Line 5521: WHEN fnd_api.g_exc_unexpected_error THEN

5517: p_count => x_msg_count,
5518: p_data => x_msg_data);
5519:
5520:
5521: WHEN fnd_api.g_exc_unexpected_error THEN
5522: --ROLLBACK TO create_settlements_pub;
5523: x_return_status := fnd_api.g_ret_sts_unexp_error;
5524:
5525: print_debuginfo(l_module_name, 'Exception : ' || SQLERRM);

Line 5523: x_return_status := fnd_api.g_ret_sts_unexp_error;

5519:
5520:
5521: WHEN fnd_api.g_exc_unexpected_error THEN
5522: --ROLLBACK TO create_settlements_pub;
5523: x_return_status := fnd_api.g_ret_sts_unexp_error;
5524:
5525: print_debuginfo(l_module_name, 'Exception : ' || SQLERRM);
5526:
5527: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

Line 5527: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

5523: x_return_status := fnd_api.g_ret_sts_unexp_error;
5524:
5525: print_debuginfo(l_module_name, 'Exception : ' || SQLERRM);
5526:
5527: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5528: p_count => x_msg_count,
5529: p_data => x_msg_data);
5530:
5531:

Line 5534: x_return_status := fnd_api.g_ret_sts_unexp_error;

5530:
5531:
5532: WHEN OTHERS THEN
5533: --ROLLBACK TO create_settlements_pub;
5534: x_return_status := fnd_api.g_ret_sts_unexp_error;
5535:
5536: print_debuginfo(l_module_name, 'Exception : ' || SQLERRM);
5537:
5538: fnd_message.set_name('IBY', 'IBY_API_OTHERS_EXCEP');

Line 5541: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

5537:
5538: fnd_message.set_name('IBY', 'IBY_API_OTHERS_EXCEP');
5539: fnd_message.set_token('ERROR',SQLERRM);
5540: fnd_msg_pub.add;
5541: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5542: p_count => x_msg_count,
5543: p_data => x_msg_data);
5544:
5545: END Create_Settlements;

Line 5561: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

5557: --
5558:
5559: PROCEDURE Create_Settlements (
5560: p_api_version IN NUMBER,
5561: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
5562: p_calling_app_id IN NUMBER,
5563: p_calling_app_request_code IN IBY_TRXN_SUMMARIES_ALL.CALL_APP_SERVICE_REQ_CODE%TYPE,
5564: p_order_view_name IN VARCHAR2,
5565: x_return_status OUT NOCOPY VARCHAR2,

Line 5597: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

5593:
5594: PROCEDURE Create_Return
5595: (
5596: p_api_version IN NUMBER,
5597: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
5598: x_return_status OUT NOCOPY VARCHAR2,
5599: x_msg_count OUT NOCOPY NUMBER,
5600: x_msg_data OUT NOCOPY VARCHAR2,
5601: p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,

Line 5693: IF NOT FND_API.Compatible_API_Call (l_api_version,

5689:
5690: IF (c_extension%ISOPEN) THEN CLOSE c_extension; END IF;
5691: IF (c_settlement%ISOPEN) THEN CLOSE c_settlement; END IF;
5692:
5693: IF NOT FND_API.Compatible_API_Call (l_api_version,
5694: p_api_version,
5695: l_module,
5696: G_PKG_NAME)
5697: THEN

Line 5705: RAISE FND_API.G_EXC_ERROR;

5701: module => G_DEBUG_MODULE || l_module);
5702: END IF;
5703: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
5704: FND_MSG_PUB.Add;
5705: RAISE FND_API.G_EXC_ERROR;
5706: END IF;
5707:
5708: IF FND_API.to_Boolean( p_init_msg_list ) THEN
5709: FND_MSG_PUB.initialize;

Line 5708: IF FND_API.to_Boolean( p_init_msg_list ) THEN

5704: FND_MSG_PUB.Add;
5705: RAISE FND_API.G_EXC_ERROR;
5706: END IF;
5707:
5708: IF FND_API.to_Boolean( p_init_msg_list ) THEN
5709: FND_MSG_PUB.initialize;
5710: END IF;
5711: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
5712:

Line 5719: IBY_FNDCPT_SETUP_PUB.Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,

5715: iby_debug_pub.add('account site use id =' || p_payer.Account_Site_Id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
5716: iby_debug_pub.add('org id =' || p_payer.Org_Id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
5717: iby_debug_pub.add('org type =' || p_payer.Org_Type,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
5718:
5719: IBY_FNDCPT_SETUP_PUB.Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,
5720: l_payer_level,l_payer_id,l_payer_attribs);
5721:
5722: iby_debug_pub.add('l_payer_level: '|| l_payer_level,G_LEVEL_STATEMENT,l_dbg_mod);
5723: iby_debug_pub.add('l_payer_id: '|| l_payer_id,G_LEVEL_STATEMENT,l_dbg_mod);

Line 5787: (1.0, FND_API.G_FALSE, FND_API.G_FALSE, FND_API.G_VALID_LEVEL_FULL,

5783: l_credit_trxn.Receipt_Method_Id := l_rec_mth_id;
5784:
5785:
5786: IBY_PAYMENT_ADAPTER_PUB.OraPmtCredit
5787: (1.0, FND_API.G_FALSE, FND_API.G_FALSE, FND_API.G_VALID_LEVEL_FULL,
5788: l_ecapp_id, l_payee, l_pmt_instr, l_tangible, l_credit_trxn,
5789: lx_return_status, lx_msg_count, lx_msg_data, lx_creditresp
5790: );
5791:

Line 5860: (1.0, FND_API.G_FALSE, FND_API.G_FALSE, FND_API.G_VALID_LEVEL_FULL,

5856: l_return_trxn.PmtMode := 'ONLINE';
5857: l_return_trxn.Settlement_Date := p_receipt_attribs.Settlement_Date;
5858:
5859: IBY_PAYMENT_ADAPTER_PUB.OraPmtReturn
5860: (1.0, FND_API.G_FALSE, FND_API.G_FALSE, FND_API.G_VALID_LEVEL_FULL,
5861: l_ecapp_id, l_return_trxn, lx_return_status, lx_msg_count,
5862: lx_msg_data, lx_returnresp
5863: );
5864:

Line 5934: WHEN FND_API.G_EXC_ERROR THEN

5930: END IF;
5931:
5932: EXCEPTION
5933:
5934: WHEN FND_API.G_EXC_ERROR THEN
5935:
5936: IF( G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
5937: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
5938: debug_level => G_LEVEL_ERROR,

Line 5941: x_return_status := FND_API.G_RET_STS_ERROR;

5937: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
5938: debug_level => G_LEVEL_ERROR,
5939: module => G_DEBUG_MODULE || l_module);
5940: END IF;
5941: x_return_status := FND_API.G_RET_STS_ERROR;
5942: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
5943: p_data => x_msg_data
5944: );
5945: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 5945: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5941: x_return_status := FND_API.G_RET_STS_ERROR;
5942: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
5943: p_data => x_msg_data
5944: );
5945: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5946:
5947: IF( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
5948: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
5949: debug_level => G_LEVEL_UNEXPECTED,

Line 5952: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

5948: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
5949: debug_level => G_LEVEL_UNEXPECTED,
5950: module => G_DEBUG_MODULE || l_module);
5951: END IF;
5952: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5953: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
5954: p_data => x_msg_data
5955: );
5956:

Line 5967: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

5963: END IF;
5964:
5965: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
5966:
5967: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5968: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5969: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
5970: END IF;
5971:

Line 5981: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

5977:
5978: PROCEDURE Create_Return
5979: (
5980: p_api_version IN NUMBER,
5981: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
5982: x_return_status OUT NOCOPY VARCHAR2,
5983: x_msg_count OUT NOCOPY NUMBER,
5984: x_msg_data OUT NOCOPY VARCHAR2,
5985: p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,

Line 6042: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

6038: --
6039: PROCEDURE Create_Reversal
6040: (
6041: p_api_version IN NUMBER,
6042: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
6043: p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,
6044: p_payer_equivalency IN VARCHAR2 :=
6045: IBY_FNDCPT_COMMON_PUB.G_PAYER_EQUIV_UPWARD,
6046: p_trxn_entity_id IN NUMBER,

Line 6179: IF NOT FND_API.Compatible_API_Call (l_api_version,

6175: IF (c_extension%ISOPEN) THEN CLOSE c_extension; END IF;
6176: IF (c_auth%ISOPEN) THEN CLOSE c_auth; END IF;
6177: IF (c_settlement%ISOPEN) THEN CLOSE c_settlement; END IF;
6178:
6179: IF NOT FND_API.Compatible_API_Call (l_api_version,
6180: p_api_version,
6181: l_module,
6182: G_PKG_NAME)
6183: THEN

Line 6191: RAISE FND_API.G_EXC_ERROR;

6187: module => G_DEBUG_MODULE || l_module);
6188: END IF;
6189: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
6190: FND_MSG_PUB.Add;
6191: RAISE FND_API.G_EXC_ERROR;
6192: END IF;
6193:
6194: IF FND_API.to_Boolean( p_init_msg_list ) THEN
6195: FND_MSG_PUB.initialize;

Line 6194: IF FND_API.to_Boolean( p_init_msg_list ) THEN

6190: FND_MSG_PUB.Add;
6191: RAISE FND_API.G_EXC_ERROR;
6192: END IF;
6193:
6194: IF FND_API.to_Boolean( p_init_msg_list ) THEN
6195: FND_MSG_PUB.initialize;
6196: END IF;
6197: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
6198:

Line 6205: IBY_FNDCPT_SETUP_PUB.Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,

6201: iby_debug_pub.add('account site use id =' || p_payer.Account_Site_Id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
6202: iby_debug_pub.add('org id =' || p_payer.Org_Id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
6203: iby_debug_pub.add('org type =' || p_payer.Org_Type,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
6204:
6205: IBY_FNDCPT_SETUP_PUB.Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,
6206: l_payer_level,l_payer_id,l_payer_attribs);
6207:
6208: iby_debug_pub.add('l_payer_level: '|| l_payer_level,G_LEVEL_STATEMENT,l_dbg_mod);
6209: iby_debug_pub.add('l_payer_id: '|| l_payer_id,G_LEVEL_STATEMENT,l_dbg_mod);

Line 6296: (1.0, p_init_msg_list, FND_API.G_FALSE,

6292: l_interface_code := IBY_FNDCPT_COMMON_PUB.G_INTERFACE_CODE;
6293:
6294:
6295: IBY_PAYMENT_ADAPTER_PUB.OraPmtReverse
6296: (1.0, p_init_msg_list, FND_API.G_FALSE,
6297: FND_API.G_VALID_LEVEL_FULL, l_ecapp_id,
6298: l_rev_trxn, lx_return_status, lx_msg_count,
6299: lx_msg_data, lx_rev_resp
6300: );

Line 6297: FND_API.G_VALID_LEVEL_FULL, l_ecapp_id,

6293:
6294:
6295: IBY_PAYMENT_ADAPTER_PUB.OraPmtReverse
6296: (1.0, p_init_msg_list, FND_API.G_FALSE,
6297: FND_API.G_VALID_LEVEL_FULL, l_ecapp_id,
6298: l_rev_trxn, lx_return_status, lx_msg_count,
6299: lx_msg_data, lx_rev_resp
6300: );
6301: IF( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 6382: FND_API.G_FALSE,

6378:
6379: IBY_PAYMENT_ADAPTER_PUB.OraPmtReq
6380: (1.0,
6381: p_init_msg_list,
6382: FND_API.G_FALSE,
6383: FND_API.G_VALID_LEVEL_FULL,
6384: l_ecapp_id,
6385: l_payee,
6386: l_payer,

Line 6383: FND_API.G_VALID_LEVEL_FULL,

6379: IBY_PAYMENT_ADAPTER_PUB.OraPmtReq
6380: (1.0,
6381: p_init_msg_list,
6382: FND_API.G_FALSE,
6383: FND_API.G_VALID_LEVEL_FULL,
6384: l_ecapp_id,
6385: l_payee,
6386: l_payer,
6387: l_pmt_instr,

Line 6536: WHEN FND_API.G_EXC_ERROR THEN

6532: iby_debug_pub.add('Exit',G_LEVEL_PROCEDURE,l_module);
6533:
6534: EXCEPTION
6535:
6536: WHEN FND_API.G_EXC_ERROR THEN
6537:
6538: IF( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
6539: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
6540: debug_level => G_LEVEL_EXCEPTION,

Line 6543: x_return_status := FND_API.G_RET_STS_ERROR;

6539: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
6540: debug_level => G_LEVEL_EXCEPTION,
6541: module => G_DEBUG_MODULE || l_module);
6542: END IF;
6543: x_return_status := FND_API.G_RET_STS_ERROR;
6544: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
6545: p_data => x_msg_data
6546: );
6547: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 6547: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6543: x_return_status := FND_API.G_RET_STS_ERROR;
6544: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
6545: p_data => x_msg_data
6546: );
6547: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6548:
6549: IF( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
6550: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
6551: debug_level => G_LEVEL_UNEXPECTED,

Line 6554: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

6550: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
6551: debug_level => G_LEVEL_UNEXPECTED,
6552: module => G_DEBUG_MODULE || l_module);
6553: END IF;
6554: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6555: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
6556: p_data => x_msg_data
6557: );
6558:

Line 6569: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

6565: END IF;
6566:
6567: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
6568:
6569: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6570: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6571: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
6572: END IF;
6573:

Line 6625: (FND_API.G_FALSE,l_cvv2,iby_security_pkg.G_ENCODING_NUMERIC,

6621: l_cvv2 :=
6622: IBY_SECURITY_PKG.Encode_CVV(c_ext_rec.instrument_security_code,TRUE);
6623:
6624: IBY_SECURITY_PKG.Create_Segment
6625: (FND_API.G_FALSE,l_cvv2,iby_security_pkg.G_ENCODING_NUMERIC,
6626: p_sys_security_key,lx_segment_id);
6627:
6628: UPDATE iby_fndcpt_tx_extensions
6629: SET

Line 6644: IF FND_API.To_Boolean(p_commit) THEN

6640: || ' as the instrument security code value is invalid');
6641: END IF;
6642: END LOOP;
6643:
6644: IF FND_API.To_Boolean(p_commit) THEN
6645: COMMIT;
6646: END IF;
6647: IF( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
6648: iby_debug_pub.add('Exit',G_LEVEL_PROCEDURE,l_dbg_mod);

Line 6653: (p_commit IN VARCHAR2 := FND_API.G_TRUE,

6649: END IF;
6650: END Encrypt_Extensions;
6651:
6652: PROCEDURE Encrypt_Security_Code
6653: (p_commit IN VARCHAR2 := FND_API.G_TRUE,
6654: p_sys_security_key IN iby_security_pkg.DES3_KEY_TYPE,
6655: p_security_code IN iby_fndcpt_tx_extensions.instrument_security_code%TYPE,
6656: x_segment_id OUT NOCOPY NUMBER,
6657: x_err_code OUT NOCOPY VARCHAR2

Line 6685: (FND_API.G_FALSE,l_cvv2,iby_security_pkg.G_ENCODING_NUMERIC,

6681: END IF;
6682: l_cvv2 := IBY_SECURITY_PKG.Encode_CVV(p_security_code,TRUE);
6683: -- test_debug('encoded cvv: '|| l_cvv2);
6684: IBY_SECURITY_PKG.Create_Segment
6685: (FND_API.G_FALSE,l_cvv2,iby_security_pkg.G_ENCODING_NUMERIC,
6686: p_sys_security_key,lx_segment_id);
6687: -- test_debug('segmentId: '|| lx_segment_id);
6688:
6689: x_segment_id := lx_segment_id;

Line 6691: IF FND_API.To_Boolean(p_commit) THEN

6687: -- test_debug('segmentId: '|| lx_segment_id);
6688:
6689: x_segment_id := lx_segment_id;
6690:
6691: IF FND_API.To_Boolean(p_commit) THEN
6692: COMMIT;
6693: END IF;
6694: IF( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
6695: iby_debug_pub.add('Exit',G_LEVEL_PROCEDURE,l_dbg_mod);

Line 6701: (p_commit IN VARCHAR2 := FND_API.G_TRUE,

6697:
6698: END Encrypt_Security_Code;
6699:
6700: PROCEDURE Decrypt_Extensions
6701: (p_commit IN VARCHAR2 := FND_API.G_TRUE,
6702: p_sys_security_key IN iby_security_pkg.DES3_KEY_TYPE,
6703: x_err_code OUT NOCOPY VARCHAR2
6704: )
6705: IS

Line 6757: IF FND_API.To_Boolean(p_commit) THEN

6753: DELETE iby_security_segments
6754: WHERE sec_segment_id = c_ext_rec.sec_segment_id;
6755: END LOOP;
6756:
6757: IF FND_API.To_Boolean(p_commit) THEN
6758: COMMIT;
6759: END IF;
6760: IF( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
6761: iby_debug_pub.add('Exit',G_LEVEL_PROCEDURE,l_dbg_mod);