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.

APPS.OE_PAYMENT_TRXN_UTIL dependencies on OE_PAYMENT_TRXN_UTIL

Line 1: PACKAGE BODY OE_PAYMENT_TRXN_UTIL AS

1: PACKAGE BODY OE_PAYMENT_TRXN_UTIL AS
2: /* $Header: OEXUPTXB.pls 120.44.12020000.8 2013/04/10 15:05:47 suthumma ship $ */
3: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_PAYMENT_TRXN_UTIL';
4:
5:

Line 3: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_PAYMENT_TRXN_UTIL';

1: PACKAGE BODY OE_PAYMENT_TRXN_UTIL AS
2: /* $Header: OEXUPTXB.pls 120.44.12020000.8 2013/04/10 15:05:47 suthumma ship $ */
3: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_PAYMENT_TRXN_UTIL';
4:
5:
6: --9092936 start
7: PROCEDURE Process_Credit_Card

Line 119: oe_debug_pub.add('ENTERING OE_PAYMENT_TRXN_UTIL.Create_Payment_Trxn....');

115: l_instrument_id NUMBER; -- bug 5170754
116:
117: BEGIN
118: IF l_debug_level > 0 THEN
119: oe_debug_pub.add('ENTERING OE_PAYMENT_TRXN_UTIL.Create_Payment_Trxn....');
120: oe_debug_pub.add('Instrument security code and payment number.....'||p_instrument_security_code||' and '||p_payment_number);
121: oe_debug_pub.add('Instrument id'||p_instrument_id);
122: oe_debug_pub.add('Instrument assgn id'||p_instrument_assignment_id);
123: oe_debug_pub.add('Trxn extension id'||P_x_trxn_extension_id);

Line 770: , 'OE_PAYMENT_TRXN_UTIL'

766: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
767: THEN
768: FND_MSG_PUB.Add_Exc_Msg
769: ( G_PKG_NAME
770: , 'OE_PAYMENT_TRXN_UTIL'
771: );
772: END IF;
773:
774: OE_MSG_PUB.Count_And_Get

Line 857: oe_debug_pub.add('Entering OE_PAYMENT_TRXN_UTIL.Update_Payment_Trxn...');

853: BEGIN
854:
855:
856: IF l_debug_level > 0 THEN
857: oe_debug_pub.add('Entering OE_PAYMENT_TRXN_UTIL.Update_Payment_Trxn...');
858: END IF;
859:
860: IF p_payment_type_code IN( 'CREDIT_CARD') THEN
861: L_pmt_channel_code := p_payment_type_code;

Line 1268: IF OE_Payment_Trxn_Util.g_old_bill_to_site IS NULL THEN

1264: IF p_line_id IS NOT NULL THEN
1265: l_trxn_attribs.trxn_ref_number1 := p_line_id;
1266: END IF;
1267: --END IF;
1268: IF OE_Payment_Trxn_Util.g_old_bill_to_site IS NULL THEN
1269: --
1270: --
1271: IF l_debug_level > 0 THEN
1272: oe_debug_pub.add('Calling update transaction extension...');

Line 1400: IF Oe_Payment_Trxn_Util.Get_CC_Security_Code_Use = 'REQUIRED'

1396: IF l_debug_level > 0 THEN
1397: oe_debug_pub.add( 'OEXUPTXB.pls: authorization has been settled, need to re-authorize.');
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:

Line 1409: ELSIF Oe_Payment_Trxn_Util.Get_CC_Security_Code_Use = 'REQUIRED'

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:

Line 1452: oe_payment_trxn_util.Reverse_CreditCard_Auth

1448: oe_debug_pub.add( 'New trxn extension --->'||l_trxn_extension_id);
1449: END IF;
1450: --CC Reversal ER#16014135 Start
1451: Begin
1452: oe_payment_trxn_util.Reverse_CreditCard_Auth
1453: (p_header_id => p_header_id,
1454: p_line_id => p_line_id,
1455: p_msg_count => l_msg_count,
1456: p_msg_data => l_msg_data,

Line 1573: oe_payment_trxn_util.Reverse_CreditCard_Auth

1569: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1570: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
1571: --CC Reversal ER#16014135 Start
1572: Begin
1573: oe_payment_trxn_util.Reverse_CreditCard_Auth
1574: (p_header_id => p_header_id,
1575: p_line_id => p_line_id,
1576: p_msg_count => l_msg_count,
1577: p_msg_data => l_msg_data,

Line 1680: ELSIF OE_Payment_Trxn_Util.g_old_bill_to_site IS NOT NULL THEN

1676: END IF;
1677: END IF; -- Approval code not null
1678: --bug 5028932
1679: --bug 4885313
1680: ELSIF OE_Payment_Trxn_Util.g_old_bill_to_site IS NOT NULL THEN
1681: IF l_debug_level > 0 THEN
1682: oe_debug_pub.add('Bill to has changed....Need to delete this trxn id as context has changed!');
1683: oe_debug_pub.add('Before calling Delete Transaction Extension API...');
1684: oe_debug_pub.add('Trxn extension id --------> '||p_trxn_extension_id);

Line 1689: l_payer.account_site_id := OE_Payment_Trxn_Util.g_old_bill_to_site;

1685: oe_debug_pub.add('Payer equivalency --------> '||IBY_FNDCPT_COMMON_PUB.G_PAYER_EQUIV_IMMEDIATE);
1686: END IF;
1687: --Setting the context corresponding to the old bill to
1688: --site as the trxn extension id was created for that site.
1689: l_payer.account_site_id := OE_Payment_Trxn_Util.g_old_bill_to_site;
1690:
1691: --Resetting the bill to change flag so as to
1692: --maintain the consistent behaviour in different sessions
1693:

Line 1694: OE_Payment_Trxn_Util.g_old_bill_to_site := null;

1690:
1691: --Resetting the bill to change flag so as to
1692: --maintain the consistent behaviour in different sessions
1693:
1694: OE_Payment_Trxn_Util.g_old_bill_to_site := null;
1695:
1696: IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension
1697: (
1698: p_api_version => 1.0,

Line 1797: oe_payment_trxn_util.Reverse_CreditCard_Auth

1793: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1794: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
1795: --CC Reversal ER#16014135 Start
1796: Begin
1797: oe_payment_trxn_util.Reverse_CreditCard_Auth
1798: (p_header_id => p_header_id,
1799: p_line_id => p_line_id,
1800: p_msg_count => l_msg_count,
1801: p_msg_data => l_msg_data,

Line 1869: , 'OE_PAYMENT_TRXN_UTIL'

1865: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1866: THEN
1867: FND_MSG_PUB.Add_Exc_Msg
1868: ( G_PKG_NAME
1869: , 'OE_PAYMENT_TRXN_UTIL'
1870: );
1871: END IF;
1872:
1873: OE_MSG_PUB.Count_And_Get

Line 2133: oe_debug_pub.add('Exiting OE_PAYMENT_TRXN_UTIL.Copy_Payment_Trxn.', 1);

2129: END IF;
2130: END IF;
2131:
2132: IF l_debug_level > 0 THEN
2133: oe_debug_pub.add('Exiting OE_PAYMENT_TRXN_UTIL.Copy_Payment_Trxn.', 1);
2134: END IF;
2135:
2136: X_return_status := FND_API.G_RET_STS_SUCCESS;
2137:

Line 2185: , 'OE_PAYMENT_TRXN_UTIL'

2181: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2182: THEN
2183: FND_MSG_PUB.Add_Exc_Msg
2184: ( G_PKG_NAME
2185: , 'OE_PAYMENT_TRXN_UTIL'
2186: );
2187: END IF;
2188:
2189: OE_MSG_PUB.Count_And_Get

Line 2436: , 'OE_PAYMENT_TRXN_UTIL'

2432: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2433: THEN
2434: FND_MSG_PUB.Add_Exc_Msg
2435: ( G_PKG_NAME
2436: , 'OE_PAYMENT_TRXN_UTIL'
2437: );
2438: END IF;
2439:
2440: -- FND_MESSAGE.SET_NAME('ONT','Exception in Get_Payment_Trxn_Info');

Line 2637: oe_payment_trxn_util.Reverse_CreditCard_Auth

2633: -- bug 5194228
2634: --CC Reversal ER#16014135 Start
2635: IF nvl(l_authorized_flag,'N') = 'Y' and nvl(l_Settled_flag,'N') = 'N' THEN
2636: Begin
2637: oe_payment_trxn_util.Reverse_CreditCard_Auth
2638: (p_header_id => p_header_id,
2639: p_line_id => p_line_id,
2640: p_msg_count => l_msg_count,
2641: p_msg_data => l_msg_data,

Line 2767: , 'OE_PAYMENT_TRXN_UTIL'

2763: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2764: THEN
2765: FND_MSG_PUB.Add_Exc_Msg
2766: ( G_PKG_NAME
2767: , 'OE_PAYMENT_TRXN_UTIL'
2768: );
2769: END IF;
2770:
2771: -- FND_MESSAGE.SET_NAME('ONT','Exception in Delete_Payment_Trxn'||sqlerrm);

Line 2862: oe_debug_pub.add('Exiting OE_PAYMENT_TRXN_UTIL.Get_CC_Security_Code_Use: '||l_return_status, 1);

2858: oe_debug_pub.add('Return Status --> '||l_return_status);
2859: oe_debug_pub.add('Response code --> '||l_response_code.result_code);
2860: oe_debug_pub.add('Security code use ---> '||G_CC_Security_Code_Use);
2861: oe_debug_pub.add('Statement Billing Address Use ----> '|| l_channel_attrib_uses.Instr_Billing_Address);
2862: oe_debug_pub.add('Exiting OE_PAYMENT_TRXN_UTIL.Get_CC_Security_Code_Use: '||l_return_status, 1);
2863: END IF;
2864:
2865: RETURN G_CC_Security_Code_Use;
2866:

Line 3297: END OE_PAYMENT_TRXN_UTIL;

3293: END Reverse_CreditCard_Auth;
3294: --CC Reversal ER#16014135 End
3295:
3296: --R12 CC Encryption
3297: END OE_PAYMENT_TRXN_UTIL;