[Home] [Help]
1348: --If approval code is not null then the transaction
1349: --extension has already been authorized once. So cannot
1350: --call update_transaction API for this trxn_extension_id
1351: IF (l_approval_code IS NOT NULL AND
1352: NOT OE_GLOBALS.Equal(l_approval_code,FND_API.G_MISS_CHAR))
1353: OR l_settled_flag = 'Y' THEN
1354:
1355: IF l_settled_flag = 'N' THEN
1356: -- need to re-authorize if the authorization has expired.
1398: END IF;
1399:
1400: IF Oe_Payment_Trxn_Util.Get_CC_Security_Code_Use = 'REQUIRED'
1401: AND (l_trxn_attribs.Instrument_Security_Code IS NULL OR
1402: OE_GLOBALS.Equal(l_trxn_attribs.Instrument_Security_Code,FND_API.G_MISS_CHAR))
1403: THEN
1404:
1405: FND_MESSAGE.SET_NAME('ONT','OE_CC_SECURITY_CODE_REQD');
1406: OE_Msg_Pub.Add;
1407: RAISE FND_API.G_EXC_ERROR;
1408:
1409: ELSIF Oe_Payment_Trxn_Util.Get_CC_Security_Code_Use = 'REQUIRED'
1410: AND l_trxn_attribs.Instrument_Security_Code IS NOT NULL
1411: AND NOT OE_GLOBALS.Equal(l_trxn_attribs.Instrument_Security_Code,FND_API.G_MISS_CHAR)
1412: THEN
1413:
1414: -- need to create a new payment transaction extension as the old one has been settled.
1415: IF l_debug_level > 0 THEN
1481: -- update oe_payments table
1482: p_trxn_extension_id := l_trxn_extension_id;
1483: END IF; --Security code use ='REQUIRED'
1484: --bug 5299050
1485: ELSIF NOT OE_GLOBALS.Is_Same_Credit_Card(l_old_card_number,
1486: p_card_number,l_old_instrument_id,l_instrument_id) THEN
1487:
1488: l_trxn_attribs.Originating_Application_Id := 660;
1489: l_trxn_attribs.Instrument_Security_Code := p_instrument_security_code;
1733: ELSIF p_payment_type_code = 'CREDIT_CARD' THEN
1734: l_trxn_attribs.Originating_Application_Id := 660;
1735: l_trxn_attribs.Instrument_Security_Code := p_instrument_security_code;
1736: /*IF p_instrument_security_code IS NOT NULL AND
1737: NOT OE_GLOBALS.Equal(p_instrument_security_code,FND_API.G_MISS_CHAR) THEN
1738: --The bill to site has changed and a new credit card
1739: --has been brought in. Since the CVV2 value used here
1740: --would be of the previous cards', displaying this message
1741: --to the user.
2790: END IF;
2791:
2792: BEGIN
2793: IF p_trxn_extension_id IS NOT NULL AND
2794: NOT OE_GLOBALS.Equal(p_trxn_Extension_id, FND_API.G_MISS_NUM) THEN
2795: -- bug 8586227
2796: select settled_flag
2797: into l_Settled_flag
2798: from IBY_EXTN_SETTLEMENTS_V