APPS.IBY_FNDCPT_TRXN_PUB dependencies on IBY_CREDITCARD

Line 1236: IF ('IMMEDIATE' = IBY_CREDITCARD_PKG.Get_CC_Encrypt_Mode()) THEN

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..');
1239: IBY_PAYMENT_ADAPTER_PUB.OraSecureExtension
1240: (FND_API.G_FALSE,

Line 1617: IF ('IMMEDIATE' = IBY_CREDITCARD_PKG.Get_CC_Encrypt_Mode()) THEN

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
1619: -- test_debug('calling secure_extension..');
1620: IBY_PAYMENT_ADAPTER_PUB.OraSecureExtension
1621: (FND_API.G_FALSE,

Line 2495: IF ('IMMEDIATE' = IBY_CREDITCARD_PKG.Get_CC_Encrypt_Mode()) THEN

2491: -- New CVV value passed. Need to encrypt it if encryption
2492: -- is turned ON
2493: iby_debug_pub.add('New CVV passed for the copied extension.',
2494: G_LEVEL_ERROR,l_dbg_mod);
2495: IF ('IMMEDIATE' = IBY_CREDITCARD_PKG.Get_CC_Encrypt_Mode()) THEN
2496: IF( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
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

Line 3387: UPDATE iby_creditcard SET active_flag = 'N' where instrid = l_pmt_instr.PmtInstr_Id;

3383: IF (l_single_use = 'Y') THEN
3384: IF( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3385: iby_debug_pub.add('Single Use Flag is True for the Credit Card Updating Marking Active Flag to N',G_LEVEL_STATEMENT,l_dbg_mod);
3386: END IF;
3387: UPDATE iby_creditcard SET active_flag = 'N' where instrid = l_pmt_instr.PmtInstr_Id;
3388: END IF;
3389: ELSE
3390: --x_response.Result_Code := IBY_FNDCPT_COMMON_PUB.G_RC_GENERIC_SYS_ERROR);
3391:

Line 4483: ci_issuer IBY_CREDITCARD_ISSUERS_B.CARD_ISSUER_CODE%TYPE

4479: AND TX.TRXNTYPEID=2
4480: AND TX.STATUS=0;
4481:
4482: CURSOR c_setup(ci_bepid iby_bepinfo.bepid%TYPE,
4483: ci_issuer IBY_CREDITCARD_ISSUERS_B.CARD_ISSUER_CODE%TYPE
4484: )
4485: IS
4486: SELECT NVL(B.ALLOW_CAPTURE_EX_AUTH_FLAG, 'Y') BEP_FLAG,
4487: NVL(i.ALLOW_CAPTURE_EX_AUTH_FLAG, 'Y') card_issuer_flag

Line 4488: FROM IBY_BEPINFO B, IBY_CREDITCARD_ISSUERS_B I

4484: )
4485: IS
4486: SELECT NVL(B.ALLOW_CAPTURE_EX_AUTH_FLAG, 'Y') BEP_FLAG,
4487: NVL(i.ALLOW_CAPTURE_EX_AUTH_FLAG, 'Y') card_issuer_flag
4488: FROM IBY_BEPINFO B, IBY_CREDITCARD_ISSUERS_B I
4489: WHERE B.BEPID=ci_bepid
4490: AND I.CARD_ISSUER_CODE=ci_issuer;
4491:
4492: BEGIN

Line 5128: FROM iby_bepinfo b, iby_creditcard_issuers_b i

5124: G_LEVEL_STATEMENT,l_module_name);
5125:
5126: SELECT DECODE(b.auth_reversal_flag, 'M', DECODE(i.auth_reversal_flag,'M','Y','N'), 'N')
5127: INTO l_rev_allowed
5128: FROM iby_bepinfo b, iby_creditcard_issuers_b i
5129: WHERE b.bepid = l_settlement_trxn_rec.auth_bepid
5130: AND i.card_issuer_code = l_settlement_trxn_rec.auth_instrsubtype;
5131:
5132: iby_debug_pub.add('l_rev_allowed = '|| l_rev_allowed, G_LEVEL_STATEMENT,l_module_name);

Line 6151: iby_creditcard_issuers_b brand

6147: iby_trxn_summaries_all auth,
6148: iby_tangible tg,
6149: iby_trxn_core core,
6150: iby_bepinfo bep,
6151: iby_creditcard_issuers_b brand
6152: WHERE (xt.trxn_extension_id = ci_extension_id)
6153: AND (xt.trxn_extension_id = op.trxn_extension_id)
6154: AND (op.transactionid = auth.transactionid)
6155: AND (auth.reqtype = 'ORAPMTREQ')