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_VERIFY_PAYMENT_PUB dependencies on OE_VERIFY_PAYMENT_PUB

Line 1: PACKAGE BODY OE_Verify_Payment_PUB AS

1: PACKAGE BODY OE_Verify_Payment_PUB AS
2: /* $Header: OEXPVPMB.pls 120.39.12010000.4 2008/11/14 11:54:30 msundara ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Verify_Payment_PUB';
5: G_credit_check_rule_id NUMBER;

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Verify_Payment_PUB';

1: PACKAGE BODY OE_Verify_Payment_PUB AS
2: /* $Header: OEXPVPMB.pls 120.39.12010000.4 2008/11/14 11:54:30 msundara ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Verify_Payment_PUB';
5: G_credit_check_rule_id NUMBER;
6:
7: PROCEDURE Check_ReAuth_for_MultiPmnts
8: ( p_credit_card_approval_code IN VARCHAR2

Line 652: oe_debug_pub.add( 'ENTERING OE_VERIFY_PAYMENT_PUB.CREDIT_CHECK_LINE_LEVEL.' , 1 ) ;

648: --
649: BEGIN
650:
651: IF l_debug_level > 0 THEN
652: oe_debug_pub.add( 'ENTERING OE_VERIFY_PAYMENT_PUB.CREDIT_CHECK_LINE_LEVEL.' , 1 ) ;
653: END IF;
654:
655: -- Query the Order Header
656: IF l_debug_level > 0 THEN

Line 695: OE_Verify_Payment_PUB.Release_Verify_Hold

691: IF l_debug_level > 0 THEN
692: oe_debug_pub.add( 'OEXPVPMB LINE LEVEL: RELEASING CREDIT CARD ' || 'HOLDS-AFTER CREDITCHECKING' ) ;
693: END IF;
694: --
695: OE_Verify_Payment_PUB.Release_Verify_Hold
696: ( p_header_id => l_header_rec.header_id
697: , p_epayment_hold => 'Y' -- We want to Release Credit Card Hol
698: , p_msg_count => l_msg_count
699: , p_msg_data => l_msg_data

Line 716: OE_Verify_Payment_PUB.Release_Credit_Check_Hold

712: IF l_debug_level > 0 THEN
713: oe_debug_pub.add( 'OEXPVPMB LINE LEVEL: RELEASING CREDIT CHECKING HOLDS' ) ;
714: END IF;
715: --
716: OE_Verify_Payment_PUB.Release_Credit_Check_Hold
717: ( p_header_id => l_header_rec.header_id
718: , p_invoice_to_org_id => C1.invoice_to_org_id
719: , p_msg_count => l_msg_count
720: , p_msg_data => l_msg_data

Line 736: OE_Verify_Payment_PUB.Apply_Credit_Check_Hold

732: IF l_debug_level > 0 THEN
733: oe_debug_pub.add( 'OEXPVPMB LINE LEVEL: APPLYING CREDIT CHECKING FAILURE HOLD' ) ;
734: END IF;
735: --
736: OE_Verify_Payment_PUB.Apply_Credit_Check_Hold
737: ( p_header_id => l_header_rec.header_id
738: , p_invoice_to_org_id => C1.invoice_to_org_id -- XX
739: , p_hold_id => 1
740: , p_calling_action => l_calling_action

Line 756: oe_debug_pub.add( 'EXITING OE_VERIFY_PAYMENT_PUB.CREDIT_CHECK_LINE_LEVEL.' , 1 ) ;

752: END IF; -- IF Result Out of Credit Checking
753: END LOOP;
754:
755: IF l_debug_level > 0 THEN
756: oe_debug_pub.add( 'EXITING OE_VERIFY_PAYMENT_PUB.CREDIT_CHECK_LINE_LEVEL.' , 1 ) ;
757: END IF;
758:
759: EXCEPTION
760:

Line 796: Calls OE_Verify_Payment_PUB.Payment_Request Authorization

792: /*--------------------------------------------------------------------------
793: Called By Booking, Pre Ship or Purchase Release Processing.
794: Checks if Electronic Payment is associated to the Order.
795: IF Yes THEN
796: Calls OE_Verify_Payment_PUB.Payment_Request Authorization
797: ELSE
798: Calls OE_Credit_PUB.OE_Check_Available_Credit for Credit Limit Checking
799:
800: 1961228 - Multi currency credit checking changes

Line 850: OE_Verify_Payment_PUB.G_init_calling_action := p_calling_action; --ER#7479609

846: oe_debug_pub.add( 'OEXPVPMB: IN VERIFY PAYMENT MAIN' , 1 ) ;
847: END IF;
848: G_credit_check_rule_id := NULL ;
849:
850: OE_Verify_Payment_PUB.G_init_calling_action := p_calling_action; --ER#7479609
851:
852: -- Query the Order Header
853: IF l_debug_level > 0 THEN
854: oe_debug_pub.add( 'OEXPVPMB: BEFORE QUERYING HEADER ID : '||P_HEADER_ID , 1 ) ;

Line 918: OE_Verify_Payment_PUB.Payment_Request

914:
915: -- Call the Payment Request API
916: OE_DEBUG_PUB.ADD('OEXPVPMB: Before Calling Payment Request API For VOIDAUTHONLY');
917: --
918: OE_Verify_Payment_PUB.Payment_Request
919: ( p_header_rec => l_header_rec
920: , p_trxn_type => 'VOIDAUTHONLY'
921: , p_msg_count => l_msg_count
922: , p_msg_data => l_msg_data

Line 962: l_calling_action := OE_Verify_Payment_PUB.Which_Rule(p_header_id => p_header_id);

958: -- Commenting code as the credit check rule will be BOOKING
959: -- for order updates as well 2412678
960: -- New fix: code was uncommented as part of Bug # 3292283.
961:
962: l_calling_action := OE_Verify_Payment_PUB.Which_Rule(p_header_id => p_header_id);
963:
964: END IF;
965:
966: END IF;

Line 1045: l_rule_defined := OE_Verify_Payment_PUB.Check_Rule_Defined

1041: IF NOT OE_PREPAYMENT_UTIL.IS_MULTIPLE_PAYMENTS_ENABLED THEN
1042: IF l_debug_level > 0 THEN
1043: oe_debug_pub.add( 'OEXPVPMB: BEFORE CHECKING IF THE RULE IS DEFINED OR NOT' ) ;
1044: END IF;
1045: l_rule_defined := OE_Verify_Payment_PUB.Check_Rule_Defined
1046: ( p_header_rec => l_header_rec
1047: , p_calling_action => l_calling_action
1048: ) ;
1049:

Line 1081: l_epayment := OE_Verify_Payment_PUB.Is_Electronic_Payment( l_header_rec ) ;

1077: IF l_debug_level > 0 THEN
1078: oe_debug_pub.add( 'OEXPVPMB: BEFORE CHECKING FOR ELECTRONIC PAYMENT' , 1 ) ;
1079: END IF;
1080: --
1081: l_epayment := OE_Verify_Payment_PUB.Is_Electronic_Payment( l_header_rec ) ;
1082:
1083: IF l_debug_level > 0 THEN
1084: oe_debug_pub.add( 'OEXPVPMB: IS IT AN ELECTRONIC PAYMENT : '|| L_EPAYMENT ) ;
1085: END IF;

Line 1132: l_rule_defined := OE_Verify_Payment_PUB.Check_Rule_Defined

1128: -- is now called from OE_Prepayment_PVT.process_payments
1129: -- if multiple payments is enabled.
1130: /*
1131: -- Check rule defined before going to credit checking engine.
1132: l_rule_defined := OE_Verify_Payment_PUB.Check_Rule_Defined
1133: ( p_header_rec => l_header_rec
1134: , p_calling_action => l_calling_action
1135: ) ;
1136:

Line 1293: OE_Verify_Payment_PUB.Release_Verify_Hold

1289: IF l_debug_level > 0 THEN
1290: oe_debug_pub.add( 'OEXPVPMB: RELEASING CREDIT CHECKING HOLDS' ) ;
1291: END IF;
1292: --
1293: OE_Verify_Payment_PUB.Release_Verify_Hold
1294: ( p_header_id => l_header_rec.header_id
1295: , p_epayment_hold => 'N' -- We want to Release Credit Checking Hold
1296: , p_msg_count => l_msg_count
1297: , p_msg_data => l_msg_data

Line 1317: OE_Verify_Payment_PUB.Apply_Verify_Hold

1313: IF l_debug_level > 0 THEN
1314: oe_debug_pub.add( 'OEXPVPMB: APPLYING CREDIT CHECKING FAILURE HOLD' ) ;
1315: END IF;
1316: --
1317: OE_Verify_Payment_PUB.Apply_Verify_Hold
1318: ( p_header_id => l_header_rec.header_id
1319: , p_hold_id => 1
1320: , p_msg_count => l_msg_count
1321: , p_msg_data => l_msg_data

Line 1372: OE_Verify_Payment_PUB.Payment_Request

1368: IF l_debug_level > 0 THEN
1369: oe_debug_pub.add( 'OEXPVPMB: BEFORE CALLING PAYMENT REQUEST API FOR AUTHONLY' ) ;
1370: END IF;
1371: --
1372: OE_Verify_Payment_PUB.Payment_Request
1373: ( p_header_rec => l_header_rec
1374: , p_trxn_type => 'AUTHONLY'
1375: , p_msg_count => l_msg_count
1376: , p_msg_data => l_msg_data

Line 1398: OE_Verify_Payment_PUB.Release_Verify_Hold

1394: IF l_debug_level > 0 THEN
1395: oe_debug_pub.add( 'OEXPVPMB: RELEASING CREDIT CHECKING HOLD' ) ;
1396: END IF;
1397: --
1398: OE_Verify_Payment_PUB.Release_Verify_Hold
1399: ( p_header_id => l_header_rec.header_id
1400: , p_epayment_hold => 'N' -- We want to Release Credit Check Hold
1401: , p_msg_count => l_msg_count
1402: , p_msg_data => l_msg_data

Line 1419: OE_Verify_Payment_PUB.Release_Verify_Hold

1415: IF l_debug_level > 0 THEN
1416: oe_debug_pub.add( 'OEXPVPMB: RELEASING CREDIT CARD HOLDS' ) ;
1417: END IF;
1418: --
1419: OE_Verify_Payment_PUB.Release_Verify_Hold
1420: ( p_header_id => l_header_rec.header_id
1421: , p_epayment_hold => 'Y' -- We want to Release Credit Card Holds
1422: , p_msg_count => l_msg_count
1423: , p_msg_data => l_msg_data

Line 1439: OE_Verify_Payment_PUB.Apply_Verify_Hold

1435: IF l_debug_level > 0 THEN
1436: oe_debug_pub.add( 'OEXPVPMB: APPLYING CC RISK HOLD' ) ;
1437: END IF;
1438: --
1439: OE_Verify_Payment_PUB.Apply_Verify_Hold
1440: ( p_header_id => l_header_rec.header_id
1441: , p_hold_id => 12 -- Seed Id for CC Risk Hold
1442: , p_msg_count => l_msg_count
1443: , p_msg_data => l_msg_data

Line 1459: OE_Verify_Payment_PUB.Apply_Verify_Hold

1455: IF l_debug_level > 0 THEN
1456: oe_debug_pub.add( 'OEXPVPMB: APPLYING CC AUTH FAILURE HOLD' ) ;
1457: END IF;
1458: --
1459: OE_Verify_Payment_PUB.Apply_Verify_Hold
1460: ( p_header_id => l_header_rec.header_id
1461: , p_hold_id => 11 -- Seeded Id for CC Auth Failure Hold
1462: , p_msg_count => l_msg_count
1463: , p_msg_data => l_msg_data

Line 1622: OE_Verify_Payment_PUB.Release_Verify_Hold

1618: IF l_debug_level > 0 THEN
1619: oe_debug_pub.add( 'OEXPVPMB: RELEASING CREDIT CHECKING HOLDS' ) ;
1620: END IF;
1621: --
1622: OE_Verify_Payment_PUB.Release_Verify_Hold
1623: ( p_header_id => l_header_rec.header_id
1624: , p_epayment_hold => 'N' -- We want to Release Credit Checking Hold
1625: , p_msg_count => l_msg_count
1626: , p_msg_data => l_msg_data

Line 1646: OE_Verify_Payment_PUB.Apply_Verify_Hold

1642: IF l_debug_level > 0 THEN
1643: oe_debug_pub.add( 'OEXPVPMB: APPLYING CREDIT CHECKING FAILURE HOLD' ) ;
1644: END IF;
1645: --
1646: OE_Verify_Payment_PUB.Apply_Verify_Hold
1647: ( p_header_id => l_header_rec.header_id
1648: , p_hold_id => 1
1649: , p_msg_count => l_msg_count
1650: , p_msg_data => l_msg_data

Line 1891: OE_Verify_Payment_PUB.G_credit_check_rule := 'Ordering'; --ER#7479609

1887: AND Trunc(SYSDATE) BETWEEN NVL(CCR.START_DATE_ACTIVE, Trunc(SYSDATE)) AND NVL(CCR.END_DATE_ACTIVE, Trunc(SYSDATE));
1888: --7194250
1889:
1890:
1891: OE_Verify_Payment_PUB.G_credit_check_rule := 'Ordering'; --ER#7479609
1892:
1893: EXCEPTION
1894: WHEN NO_DATA_FOUND THEN
1895: l_credit_check_rule_id := 0;

Line 1925: OE_Verify_Payment_PUB.G_credit_check_rule := 'Shipping'; --ER#7479609

1921: AND Trunc(SYSDATE) BETWEEN NVL(CCR.START_DATE_ACTIVE, Trunc(SYSDATE)) AND NVL(CCR.END_DATE_ACTIVE, Trunc(SYSDATE));
1922: --7194250
1923:
1924:
1925: OE_Verify_Payment_PUB.G_credit_check_rule := 'Shipping'; --ER#7479609
1926:
1927: EXCEPTION
1928: WHEN NO_DATA_FOUND THEN
1929: l_credit_check_rule_id := 0;

Line 1956: OE_Verify_Payment_PUB.G_credit_check_rule := 'Packing'; --ER#7479609

1952: AND Trunc(SYSDATE) BETWEEN NVL(CCR.START_DATE_ACTIVE, Trunc(SYSDATE)) AND NVL(CCR.END_DATE_ACTIVE, Trunc(SYSDATE));
1953: --7194250
1954:
1955:
1956: OE_Verify_Payment_PUB.G_credit_check_rule := 'Packing'; --ER#7479609
1957:
1958: EXCEPTION
1959: WHEN NO_DATA_FOUND THEN
1960: l_credit_check_rule_id := 0;

Line 1987: OE_Verify_Payment_PUB.G_credit_check_rule := 'Picking/Purchase Release'; --ER#7479609

1983: AND Trunc(SYSDATE) BETWEEN NVL(CCR.START_DATE_ACTIVE, Trunc(SYSDATE)) AND NVL(CCR.END_DATE_ACTIVE, Trunc(SYSDATE));
1984: --7194250
1985:
1986:
1987: OE_Verify_Payment_PUB.G_credit_check_rule := 'Picking/Purchase Release'; --ER#7479609
1988:
1989: EXCEPTION
1990: WHEN NO_DATA_FOUND THEN
1991: l_credit_check_rule_id := 0;

Line 2168: OE_Verify_Payment_PUB.Hold_Exists

2164: IF l_debug_level > 0 THEN
2165: oe_debug_pub.add( 'OEXPVPMB: CHECKING EXISTENCE OF HOLD ID : '||L_HOLD_ID ) ;
2166: END IF;
2167: --
2168: OE_Verify_Payment_PUB.Hold_Exists
2169: ( p_header_id => l_hold_entity_id
2170: , p_hold_id => l_hold_id
2171: , p_hold_exists => l_hold_exists
2172: ) ;

Line 2215: OE_Verify_Payment_PUB.Hold_Exists

2211: IF l_debug_level > 0 THEN
2212: oe_debug_pub.add( 'OEXPVPMB: CHECKING EXISTENCE OF HOLD ID : '||L_HOLD_ID ) ;
2213: END IF;
2214: --
2215: OE_Verify_Payment_PUB.Hold_Exists
2216: ( p_header_id => l_hold_entity_id
2217: , p_hold_id => l_hold_id
2218: , p_hold_exists => l_hold_exists
2219: ) ;

Line 2262: OE_Verify_Payment_PUB.Hold_Exists

2258: IF l_debug_level > 0 THEN
2259: oe_debug_pub.add( 'OEXPVPMB: CHECKING EXISTENCE OF HOLD ID : '||L_HOLD_ID ) ;
2260: END IF;
2261: --
2262: OE_Verify_Payment_PUB.Hold_Exists
2263: ( p_header_id => l_hold_entity_id
2264: , p_hold_id => l_hold_id
2265: , p_hold_exists => l_hold_exists
2266: ) ;

Line 2310: OE_Verify_Payment_PUB.Hold_Exists

2306: IF l_debug_level > 0 THEN
2307: oe_debug_pub.add( 'OEXPVPMB: CHECKING EXISTENCE OF HOLD ID : '||L_HOLD_ID ) ;
2308: END IF;
2309: --
2310: OE_Verify_Payment_PUB.Hold_Exists
2311: ( p_header_id => l_hold_entity_id
2312: , p_hold_id => l_hold_id
2313: , p_hold_exists => l_hold_exists
2314: ) ;

Line 2427: OE_Verify_Payment_PUB.Hold_Exists

2423: IF l_debug_level > 0 THEN
2424: oe_debug_pub.add( 'OEXPVPMB: CHECKING IF REQUESTED VERIFY HOLD ALREADY APPLIED' ) ;
2425: END IF;
2426: --
2427: OE_Verify_Payment_PUB.Hold_Exists
2428: ( p_header_id => p_header_id
2429: , p_hold_id => p_hold_id
2430: , p_hold_exists => l_hold_exists
2431: );

Line 2559: OE_Verify_Payment_PUB.Hold_Exists

2555: IF l_debug_level > 0 THEN
2556: oe_debug_pub.add( 'OEXPVPMB: CHECKING IF REQUESTED VERIFY HOLD ALREADY APPLIED' ) ;
2557: END IF;
2558: --
2559: OE_Verify_Payment_PUB.Hold_Exists
2560: ( p_header_id => p_header_id
2561: , p_hold_id => p_hold_id
2562: , p_hold_exists => l_hold_exists
2563: );

Line 2690: IF ( OE_Verify_Payment_PUB.Check_Ipayment_Installed = 'N' ) THEN

2686: END IF;
2687: --
2688: -- lkxu, fix bug 1701377
2689: /***
2690: IF ( OE_Verify_Payment_PUB.Check_Ipayment_Installed = 'N' ) THEN
2691: -- We don't want to continue and we want to RETURN a SUCCESS.
2692: RETURN ;
2693: END IF;
2694: ***/

Line 2725: OE_Verify_Payment_PUB.Authorize_Payment( p_header_rec => p_header_rec

2721: IF l_debug_level > 0 THEN
2722: oe_debug_pub.add( 'OEXPVPMB: CALLING AUTHORIZE PAYMENT' ) ;
2723: END IF;
2724: --
2725: OE_Verify_Payment_PUB.Authorize_Payment( p_header_rec => p_header_rec
2726: , p_msg_count => l_msg_count
2727: , p_msg_data => l_msg_data
2728: , p_result_out => p_result_out
2729: , p_return_status=> l_return_status

Line 2744: OE_Verify_Payment_PUB.Fetch_Authorization_Trxn

2740: IF l_debug_level > 0 THEN
2741: oe_debug_pub.add( 'OEXPVPMB: BEFORE CALLING FETCH AUTHORIZATION TRXN' ) ;
2742: END IF;
2743: --
2744: OE_Verify_Payment_PUB.Fetch_Authorization_Trxn
2745: ( p_header_rec => p_header_rec
2746: , p_trxn_id => l_void_trxn_id
2747: , p_automatic_auth => l_automatic_auth
2748: );

Line 2762: OE_Verify_Payment_PUB.Void_Payment

2758: IF l_debug_level > 0 THEN
2759: oe_debug_pub.add( 'OEXPVPMB: BEFORE CALLING VOID PAYMENT FOR TRXN ID : '||L_VOID_TRXN_ID ) ;
2760: END IF;
2761: --
2762: OE_Verify_Payment_PUB.Void_Payment
2763: ( p_void_trxn_id => l_void_trxn_id
2764: , p_msg_count => l_msg_count
2765: , p_msg_data => l_msg_data
2766: , p_return_status=> l_return_status

Line 2800: OE_Verify_Payment_PUB.Update_Authorization_Info

2796: IF l_debug_level > 0 THEN
2797: oe_debug_pub.add( 'OEXPVPMB: CALLING UPDATE AUTH INFO TO UPDATE THE APPROVAL INFO TO NULL' ) ;
2798: END IF;
2799: --
2800: OE_Verify_Payment_PUB.Update_Authorization_Info
2801: ( p_header_rec.header_id
2802: , NULL
2803: , l_auth_code
2804: , l_trxn_date

Line 2820: OE_Verify_Payment_PUB.Release_Verify_Hold

2816: IF l_debug_level > 0 THEN
2817: oe_debug_pub.add( 'OEXPVPMB: RELEASING EXISTING CC HOLDS SINCE AUTH HAS BEEN VOIDED' ) ;
2818: END IF;
2819: --
2820: OE_Verify_Payment_PUB.Release_Verify_Hold
2821: ( p_header_id => p_header_rec.header_id
2822: , p_epayment_hold => 'Y' -- We want to Release Credit Card Hold
2823: , p_msg_count => l_msg_count
2824: , p_msg_data => l_msg_data

Line 3112: OE_Verify_Payment_PUB.Check_Reauthorize_Order

3108: IF l_debug_level > 0 THEN
3109: oe_debug_pub.add( 'OEXPVPMB: BEFORE CALLING CHECK REAUTHORIZE FLAG' ) ;
3110: END IF;
3111: --
3112: OE_Verify_Payment_PUB.Check_Reauthorize_Order
3113: ( p_header_rec => p_header_rec
3114: , p_void_trxn_id => l_void_trxn_id
3115: , p_outbound_total => l_outbound_total
3116: , p_reauthorize_out => l_reauthorize_flag

Line 3136: OE_Verify_Payment_PUB.Void_Payment

3132:
3133: -- Void this Transaction
3134: OE_DEBUG_PUB.ADD('OEXPVPMB: Before Calling Void Payment for Trxn ID : '||l_void_trxn_id);
3135: --
3136: OE_Verify_Payment_PUB.Void_Payment
3137: ( p_void_trxn_id => l_void_trxn_id
3138: , p_msg_count => l_msg_count
3139: , p_msg_data => l_msg_data
3140: , p_return_status=> l_return_status

Line 3163: OE_Verify_Payment_PUB.Hold_Exists

3159: IF l_debug_level > 0 THEN
3160: oe_debug_pub.add( 'OEXPVPMB: CHECK IF ORDER ON RISK HOLD' ) ;
3161: END IF;
3162: --
3163: OE_Verify_Payment_PUB.Hold_Exists
3164: ( p_header_id => p_header_rec.header_id
3165: , p_hold_id => 12 -- Seed Id for CC Risk Hold
3166: , p_hold_exists => l_hold_exists
3167: );

Line 3193: OE_Verify_Payment_PUB.Fetch_Last_Auth ( p_header_rec => p_header_rec

3189: IF l_debug_level > 0 THEN
3190: oe_debug_pub.add( 'OEXPVPMB: BEFORE CALLING FETCH LAST AUTH' ) ;
3191: END IF;
3192: --
3193: OE_Verify_Payment_PUB.Fetch_Last_Auth ( p_header_rec => p_header_rec
3194: , p_trxn_id => l_trxn_id
3195: , p_tangible_id => l_tangible_id
3196: , p_auth_code => l_auth_code
3197: , p_trxn_date => l_trxn_date

Line 3220: OE_Verify_Payment_PUB.Hold_Exists

3216:
3217: -- Check if Hold already exists on this order
3218: OE_DEBUG_PUB.ADD('OEXPVPMB: Check if Order on Risk Hold');
3219: --
3220: OE_Verify_Payment_PUB.Hold_Exists
3221: ( p_header_id => p_header_rec.header_id
3222: , p_hold_id => 12 -- Seed Id for CC Risk Hold
3223: , p_hold_exists => l_hold_exists
3224: );

Line 3266: l_pay_method_id := OE_Verify_Payment_PUB.Get_Primary_Pay_Method

3262: IF l_debug_level > 0 THEN
3263: oe_debug_pub.add( 'OEXPVPMB: BEFORE CALLING GET PRIMARY PAYMENT METHOD' ) ;
3264: END IF;
3265: --
3266: l_pay_method_id := OE_Verify_Payment_PUB.Get_Primary_Pay_Method
3267: ( p_header_rec => p_header_rec ) ;
3268:
3269: -- Check if a valid method was selected
3270: IF l_debug_level > 0 THEN

Line 3750: OE_Verify_Payment_PUB.Update_Authorization_Info

3746: oe_debug_pub.add( 'OEXPVPMB: l_order_value is: '||l_order_value ) ;
3747: oe_debug_pub.add( 'OEXPVPMB: l_auth_code is: '||l_auth_code ) ;
3748: END IF;
3749: --
3750: OE_Verify_Payment_PUB.Update_Authorization_Info
3751: ( p_header_rec.header_id
3752: , l_order_value
3753: , l_auth_code
3754: , l_trxn_date

Line 3852: OE_Verify_Payment_PUB.Fetch_Authorization_Trxn

3848: IF l_debug_level > 0 THEN
3849: oe_debug_pub.add( 'OEXPVPMB: BEFORE CALLING FETCH AUTHORIZATION TRXN' ) ;
3850: END IF;
3851: --
3852: OE_Verify_Payment_PUB.Fetch_Authorization_Trxn
3853: ( p_header_rec => p_header_rec
3854: , p_trxn_id => l_void_trxn_id
3855: , p_automatic_auth => l_automatic_auth
3856: );

Line 3876: l_captured_total := OE_Verify_Payment_PUB.Captured_Amount_Total(p_header_rec.header_id);

3872: ** lines. Following is not required as closed lines will be considered captured.
3873: -- Fetch the Captured Amount Total
3874: OE_DEBUG_PUB.ADD('OEXPVPMB: Fetch Captured Amount Total');
3875: --
3876: l_captured_total := OE_Verify_Payment_PUB.Captured_Amount_Total(p_header_rec.header_id);
3877: OE_DEBUG_PUB.ADD('OEXPVPMB: Total Amount already Captured : '||l_captured_total);
3878:
3879: -- Uncaptured outbound Total is
3880: p_outbound_total := l_outbound_total - l_captured_total;

Line 3914: IF (OE_Verify_Payment_PUB.Check_Trxn_Captured(l_void_trxn_id) = 'Y') THEN

3910: oe_debug_pub.add( 'OEXPVPMB: IT IS AN AUTOMATIC AUTHORIZATION' ) ;
3911: END IF;
3912:
3913: -- If Transaction has already been captured then
3914: IF (OE_Verify_Payment_PUB.Check_Trxn_Captured(l_void_trxn_id) = 'Y') THEN
3915:
3916: IF l_debug_level > 0 THEN
3917: oe_debug_pub.add( 'OEXPVPMB: CURRENT AUTH CAPTURED , REAUTHORIZE' ) ;
3918: END IF;

Line 4278: IF ( OE_Verify_Payment_PUB.Check_Trxn_Captured(p_void_trxn_id) = 'Y' ) THEN

4274: END IF;
4275:
4276:
4277: -- Return if Trxn has already been captured
4278: IF ( OE_Verify_Payment_PUB.Check_Trxn_Captured(p_void_trxn_id) = 'Y' ) THEN
4279: RETURN;
4280: END IF;
4281:
4282: -- Create the Dynamic SQL to Call the iPayment API

Line 4504: OE_Verify_Payment_PUB.Fetch_Current_Auth

4500: IF l_debug_level > 0 THEN
4501: oe_debug_pub.add( 'OEXPVPMB: BEFORE CALLING FETCH CURRENT AUTH' ) ;
4502: END IF;
4503: --
4504: OE_Verify_Payment_PUB.Fetch_Current_Auth
4505: ( p_header_rec => p_header_rec
4506: , p_trxn_id => l_trxn_id
4507: , p_tangible_id => l_tangible_id
4508: );

Line 4537: OE_Verify_Payment_PUB.Fetch_Last_Auth

4533:
4534: -- Call Last Current Auth
4535: OE_DEBUG_PUB.ADD('OEXPVPMB: Before calling Fetch Last Auth');
4536: --
4537: OE_Verify_Payment_PUB.Fetch_Last_Auth
4538: ( p_header_rec => p_header_rec
4539: , p_trxn_id => l_trxn_id
4540: , p_tangible_id => l_tangible_id
4541: );

Line 5388: OE_Verify_Payment_PUB.Apply_Verify_Line_Hold

5384: AND nvl(l_payments_tbl(I).defer_payment_processing_flag, 'N') = 'Y' THEN
5385: IF l_debug_level > 0 THEN
5386: oe_debug_pub.add( 'OEXPVPMB: place order on Defer Payment Authorization hold for line: '||l_payments_tbl(I).line_id , 1 ) ;
5387: END IF;
5388: OE_Verify_Payment_PUB.Apply_Verify_Line_Hold
5389: ( p_header_id => p_header_rec.header_id
5390: , p_line_id => l_payments_tbl(I).line_id
5391: , p_hold_id => 16
5392: , p_msg_count => l_msg_count

Line 5447: OE_Verify_Payment_PUB.Apply_Verify_Hold

5443: oe_debug_pub.add( 'OEXPVPMB: place order on Defer Payment Authorization hold for header: '||l_payments_tbl(I).header_id , 1 ) ;
5444: END IF;
5445:
5446: -- place on header level CC authorization hold.
5447: OE_Verify_Payment_PUB.Apply_Verify_Hold
5448: ( p_header_id => p_header_rec.header_id
5449: , p_hold_id => 16
5450: , p_msg_count => l_msg_count
5451: , p_msg_data => l_msg_data

Line 5595: OE_Verify_Payment_PUB.Check_ReAuth_for_MultiPmnts

5591: oe_debug_pub.add('OEXPVPMB: Line ID : '||l_payments_tbl(I).line_id, 3);
5592: oe_debug_pub.add('OEXPVPMB: Payment Number : '||l_payments_tbl(I).payment_number, 3);
5593: END IF;
5594:
5595: OE_Verify_Payment_PUB.Check_ReAuth_for_MultiPmnts
5596: ( p_credit_card_approval_code => l_payments_tbl(I).credit_card_approval_code
5597: , p_trxn_extension_id => l_payments_tbl(I).trxn_extension_id
5598: , p_amount_to_authorize => l_amount_to_authorize
5599: , p_org_id => p_header_rec.org_id

Line 5699: l_pay_method_id := OE_Verify_Payment_PUB.Get_Primary_Pay_Method

5695: null;
5696: END;
5697:
5698: IF l_pay_method_id IS NULL THEN
5699: l_pay_method_id := OE_Verify_Payment_PUB.Get_Primary_Pay_Method
5700: ( p_header_rec => p_header_rec ) ;
5701: END IF;
5702: END IF;
5703:

Line 5970: OE_Verify_Payment_PUB.Release_Verify_Hold

5966:
5967: -- moved release hold code here before applying risk hold for bug 4543147
5968: -- Release Any existing CC Holds
5969: IF l_payments_tbl(I).line_id IS NULL THEN
5970: OE_Verify_Payment_PUB.Release_Verify_Hold
5971: ( p_header_id => p_header_rec.header_id
5972: , p_epayment_hold => 'Y' -- We want to Release Credit Card Holds
5973: , p_msg_count => l_msg_count
5974: , p_msg_data => l_msg_data

Line 5979: OE_Verify_Payment_PUB.Release_Verify_Line_Hold

5975: , p_return_status => l_return_status
5976: );
5977:
5978: ELSIF l_payments_tbl(I).line_id IS NOT NULL THEN
5979: OE_Verify_Payment_PUB.Release_Verify_Line_Hold
5980: ( p_header_id => p_header_rec.header_id
5981: , p_line_id => l_payments_tbl(I).line_id
5982: , p_epayment_hold => 'Y' -- We want to Release Credit Card Holds
5983: , p_msg_count => l_msg_count

Line 6014: OE_Verify_Payment_PUB.Apply_Verify_Hold_and_Commit

6010: -- the value for parameter param3 is Hold, then
6011: IF l_payments_tbl(I).line_id IS NULL THEN
6012: IF NVL(p_calling_action, 'BOOKING') IN ('SHIPPING','PACKING','PICKING')
6013: THEN
6014: OE_Verify_Payment_PUB.Apply_Verify_Hold_and_Commit
6015: ( p_header_id => p_header_rec.header_id
6016: , p_hold_id => 12 -- Seeded Id for CC Risk Hold
6017: , p_msg_count => l_msg_count
6018: , p_msg_data => l_msg_data

Line 6023: OE_Verify_Payment_PUB.Apply_Verify_Hold

6019: , p_return_status => l_return_status
6020: );
6021:
6022: ELSE
6023: OE_Verify_Payment_PUB.Apply_Verify_Hold
6024: ( p_header_id => p_header_rec.header_id
6025: , p_hold_id => 12 -- Seeded Id for CC Risk Hold
6026: , p_msg_count => l_msg_count
6027: , p_msg_data => l_msg_data

Line 6034: OE_Verify_Payment_PUB.Apply_Verify_Line_Hold_Commit

6030: END IF;
6031: ELSIF l_payments_tbl(I).line_id IS NOT NULL THEN
6032: IF NVL(p_calling_action, 'BOOKING') IN ('SHIPPING','PACKING','PICKING')
6033: THEN
6034: OE_Verify_Payment_PUB.Apply_Verify_Line_Hold_Commit
6035: ( p_header_id => p_header_rec.header_id
6036: , p_line_id => l_payments_tbl(I).line_id
6037: , p_hold_id => 12 -- Seeded Id for CC Risk Hold
6038: , p_msg_count => l_msg_count

Line 6043: OE_Verify_Payment_PUB.Apply_Verify_Line_Hold

6039: , p_msg_data => l_msg_data
6040: , p_return_status => l_return_status
6041: );
6042: ELSE
6043: OE_Verify_Payment_PUB.Apply_Verify_Line_Hold
6044: ( p_header_id => p_header_rec.header_id
6045: , p_line_id => l_payments_tbl(I).line_id
6046: , p_hold_id => 12 -- Seeded Id for CC Risk Hold
6047: , p_msg_count => l_msg_count

Line 6113: OE_Verify_Payment_PUB.Apply_Verify_Hold_and_Commit

6109:
6110: IF l_payments_tbl(I).line_id IS NULL THEN
6111: IF NVL(p_calling_action, 'BOOKING') IN ('SHIPPING','PACKING','PICKING')
6112: THEN
6113: OE_Verify_Payment_PUB.Apply_Verify_Hold_and_Commit
6114: ( p_header_id => p_header_rec.header_id
6115: , p_hold_id => 11 -- Seeded Id for CC Auth Failure Hold
6116: , p_msg_count => l_msg_count
6117: , p_msg_data => l_msg_data

Line 6122: OE_Verify_Payment_PUB.Apply_Verify_Hold

6118: , p_return_status => l_return_status
6119: );
6120:
6121: ELSE
6122: OE_Verify_Payment_PUB.Apply_Verify_Hold
6123: ( p_header_id => p_header_rec.header_id
6124: , p_hold_id => 11 -- Seeded Id for CC Auth Failure Hold
6125: , p_msg_count => l_msg_count
6126: , p_msg_data => l_msg_data

Line 6144: OE_Verify_Payment_PUB.Apply_Verify_Line_Hold_Commit

6140:
6141: ELSIF l_payments_tbl(I).line_id IS NOT NULL THEN
6142: IF NVL(p_calling_action, 'BOOKING') IN ('SHIPPING','PACKING','PICKING')
6143: THEN
6144: OE_Verify_Payment_PUB.Apply_Verify_Line_Hold_Commit
6145: ( p_header_id => p_header_rec.header_id
6146: , p_line_id => l_payments_tbl(I).line_id
6147: , p_hold_id => 11 -- Seeded Id for CC Auth Failure Hold
6148: , p_msg_count => l_msg_count

Line 6154: OE_Verify_Payment_PUB.Apply_Verify_Line_Hold

6150: , p_return_status => l_return_status
6151: );
6152:
6153: ELSE
6154: OE_Verify_Payment_PUB.Apply_Verify_Line_Hold
6155: ( p_header_id => p_header_rec.header_id
6156: , p_line_id => l_payments_tbl(I).line_id
6157: , p_hold_id => 11 -- Seeded Id for CC Auth Failure Hold
6158: , p_msg_count => l_msg_count

Line 6185: OE_Verify_Payment_PUB.Apply_Verify_Hold_and_Commit

6181:
6182: IF l_payments_tbl(I).line_id IS NULL THEN
6183: IF NVL(p_calling_action, 'BOOKING') IN ('SHIPPING','PACKING','PICKING')
6184: THEN
6185: OE_Verify_Payment_PUB.Apply_Verify_Hold_and_Commit
6186: ( p_header_id => p_header_rec.header_id
6187: , p_hold_id => 12 -- Seeded Id for CC Risk Hold
6188: , p_msg_count => l_msg_count
6189: , p_msg_data => l_msg_data

Line 6193: OE_Verify_Payment_PUB.Apply_Verify_Hold

6189: , p_msg_data => l_msg_data
6190: , p_return_status => l_return_status
6191: );
6192: ELSE
6193: OE_Verify_Payment_PUB.Apply_Verify_Hold
6194: ( p_header_id => p_header_rec.header_id
6195: , p_hold_id => 12 -- Seeded Id for CC Risk Hold
6196: , p_msg_count => l_msg_count
6197: , p_msg_data => l_msg_data

Line 6204: OE_Verify_Payment_PUB.Apply_Verify_Line_Hold_Commit

6200: END IF;
6201: ELSIF l_payments_tbl(I).line_id IS NOT NULL THEN
6202: IF NVL(p_calling_action, 'BOOKING') IN ('SHIPPING','PACKING','PICKING')
6203: THEN
6204: OE_Verify_Payment_PUB.Apply_Verify_Line_Hold_Commit
6205: ( p_header_id => p_header_rec.header_id
6206: , p_line_id => l_payments_tbl(I).line_id
6207: , p_hold_id => 12 -- Seeded Id for CC Risk Hold
6208: , p_msg_count => l_msg_count

Line 6213: OE_Verify_Payment_PUB.Apply_Verify_Line_Hold

6209: , p_msg_data => l_msg_data
6210: , p_return_status => l_return_status
6211: );
6212: ELSE
6213: OE_Verify_Payment_PUB.Apply_Verify_Line_Hold
6214: ( p_header_id => p_header_rec.header_id
6215: , p_line_id => l_payments_tbl(I).line_id
6216: , p_hold_id => 12 -- Seeded Id for CC Risk Hold
6217: , p_msg_count => l_msg_count

Line 6246: OE_Verify_Payment_PUB.Apply_Verify_Hold_and_Commit

6242: --comm rej IF nvl(p_reject_on_auth_failure, 'N') = 'N' THEN
6243: IF l_payments_tbl(I).line_id IS NULL THEN
6244: IF NVL(p_calling_action, 'BOOKING') IN ('SHIPPING','PACKING','PICKING')
6245: THEN
6246: OE_Verify_Payment_PUB.Apply_Verify_Hold_and_Commit
6247: ( p_header_id => p_header_rec.header_id
6248: , p_hold_id => 11 -- Seeded Id for CC Auth Failure Hold
6249: , p_msg_count => l_msg_count
6250: , p_msg_data => l_msg_data

Line 6255: OE_Verify_Payment_PUB.Apply_Verify_Hold

6251: , p_return_status => l_return_status
6252: );
6253:
6254: ELSE
6255: OE_Verify_Payment_PUB.Apply_Verify_Hold
6256: ( p_header_id => p_header_rec.header_id
6257: , p_hold_id => 11 -- Seeded Id for CC Auth Failure Hold
6258: , p_msg_count => l_msg_count
6259: , p_msg_data => l_msg_data

Line 6266: OE_Verify_Payment_PUB.Apply_Verify_Line_Hold_Commit

6262: END IF;
6263: ELSIF l_payments_tbl(I).line_id IS NOT NULL THEN
6264: IF NVL(p_calling_action, 'BOOKING') IN ('SHIPPING','PACKING','PICKING')
6265: THEN
6266: OE_Verify_Payment_PUB.Apply_Verify_Line_Hold_Commit
6267: ( p_header_id => p_header_rec.header_id
6268: , p_line_id => l_payments_tbl(I).line_id
6269: , p_hold_id => 11 -- Seeded Id for CC Auth Failure Hold
6270: , p_msg_count => l_msg_count

Line 6276: OE_Verify_Payment_PUB.Apply_Verify_Line_Hold

6272: , p_return_status => l_return_status
6273: );
6274:
6275: ELSE
6276: OE_Verify_Payment_PUB.Apply_Verify_Line_Hold
6277: ( p_header_id => p_header_rec.header_id
6278: , p_line_id => l_payments_tbl(I).line_id
6279: , p_hold_id => 11 -- Seeded Id for CC Auth Failure Hold
6280: , p_msg_count => l_msg_count

Line 6335: OE_Verify_Payment_PUB.Update_AuthInfo_for_MultiPmnts

6331: --
6332:
6333: /*
6334: IF l_result_status = 'PASS' THEN
6335: OE_Verify_Payment_PUB.Update_AuthInfo_for_MultiPmnts
6336: ( p_header_rec.header_id
6337: , l_amount_to_authorize
6338: , l_auth_code
6339: , l_trxn_date

Line 6399: OE_Verify_Payment_PUB.Release_Verify_Hold

6395: END IF;
6396: --
6397:
6398: IF l_payments_tbl(I).line_id IS NULL THEN
6399: OE_Verify_Payment_PUB.Release_Verify_Hold
6400: ( p_header_id => p_header_rec.header_id
6401: , p_epayment_hold => 'Y' -- We want to Release Credit Card Holds
6402: , p_msg_count => l_msg_count
6403: , p_msg_data => l_msg_data

Line 6408: OE_Verify_Payment_PUB.Release_Verify_Line_Hold

6404: , p_return_status => l_return_status
6405: );
6406:
6407: ELSIF l_payments_tbl(I).line_id IS NOT NULL THEN
6408: OE_Verify_Payment_PUB.Release_Verify_Line_Hold
6409: ( p_header_id => p_header_rec.header_id
6410: , p_line_id => l_payments_tbl(I).line_id
6411: , p_epayment_hold => 'Y' -- We want to Release Credit Card Holds
6412: , p_msg_count => l_msg_count

Line 6432: OE_Verify_Payment_PUB.Apply_Verify_Hold

6428: oe_debug_pub.add( 'OEXPVPMB: APPLYING LINE LEVEL CC RISK HOLD' ) ;
6429: END IF;
6430: --
6431: IF l_payments_tbl(I).line_id IS NULL THEN
6432: OE_Verify_Payment_PUB.Apply_Verify_Hold
6433: ( p_header_id => p_header_rec.header_id
6434: , p_hold_id => 12 -- Seed Id for CC Risk Hold
6435: , p_msg_count => l_msg_count
6436: , p_msg_data => l_msg_data

Line 6440: OE_Verify_Payment_PUB.Apply_Verify_Line_Hold

6436: , p_msg_data => l_msg_data
6437: , p_return_status => l_return_status
6438: );
6439: ELSIF l_payments_tbl(I).line_id IS NOT NULL THEN
6440: OE_Verify_Payment_PUB.Apply_Verify_Line_Hold
6441: ( p_header_id => p_header_rec.header_id
6442: , p_line_id => l_payments_tbl(I).line_id
6443: , p_hold_id => 12 -- Seed Id for CC Risk Hold
6444: , p_msg_count => l_msg_count

Line 6465: OE_Verify_Payment_PUB.Apply_Verify_Hold

6461: END IF;
6462: --
6463:
6464: IF l_payments_tbl(I).line_id IS NULL THEN
6465: OE_Verify_Payment_PUB.Apply_Verify_Hold
6466: ( p_header_id => p_header_rec.header_id
6467: , p_hold_id => 11 -- Seeded Id for CC Auth Failure Hold
6468: , p_msg_count => l_msg_count
6469: , p_msg_data => l_msg_data

Line 6473: OE_Verify_Payment_PUB.Apply_Verify_Line_Hold

6469: , p_msg_data => l_msg_data
6470: , p_return_status => l_return_status
6471: );
6472: ELSIF l_payments_tbl(I).line_id IS NOT NULL THEN
6473: OE_Verify_Payment_PUB.Apply_Verify_Line_Hold
6474: ( p_header_id => p_header_rec.header_id
6475: , p_line_id => l_payments_tbl(I).line_id
6476: , p_hold_id => 11 -- Seeded Id for CC Auth Failure Hold
6477: , p_msg_count => l_msg_count

Line 6764: oe_debug_pub.add( 'ENTERING OE_Verify_Payment_Pub.Get_Line_Total.' , 1 ) ;

6760: --
6761: BEGIN
6762:
6763: IF l_debug_level > 0 THEN
6764: oe_debug_pub.add( 'ENTERING OE_Verify_Payment_Pub.Get_Line_Total.' , 1 ) ;
6765: END IF;
6766:
6767: -- Select the Tax Value and Outbound Extended Price
6768: BEGIN

Line 6982: oe_debug_pub.add( 'Exiting OE_Verify_Payment_PUB.Get_Line_Total.' , 3 ) ;

6978: END IF;
6979: END IF;
6980:
6981: IF l_debug_level > 0 THEN
6982: oe_debug_pub.add( 'Exiting OE_Verify_Payment_PUB.Get_Line_Total.' , 3 ) ;
6983: END IF;
6984:
6985: EXCEPTION
6986: WHEN OTHERS THEN

Line 6988: oe_debug_pub.add( 'Unexpected Error from OE_Verify_Payment_PUB.Get_Line_Total ' || SQLERRM ) ;

6984:
6985: EXCEPTION
6986: WHEN OTHERS THEN
6987: IF l_debug_level > 0 THEN
6988: oe_debug_pub.add( 'Unexpected Error from OE_Verify_Payment_PUB.Get_Line_Total ' || SQLERRM ) ;
6989: END IF;
6990: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6991: END Get_Line_Total;
6992:

Line 7032: oe_debug_pub.add( 'ENTERING OE_Verify_Payment_Pub.Get_Inv_Line_Total.' , 1 ) ;

7028: --
7029: BEGIN
7030:
7031: IF l_debug_level > 0 THEN
7032: oe_debug_pub.add( 'ENTERING OE_Verify_Payment_Pub.Get_Inv_Line_Total.' , 1 ) ;
7033: END IF;
7034:
7035: -- Select the Tax Value and Outbound Extended Price
7036: BEGIN

Line 7216: oe_debug_pub.add( 'Exiting OE_Verify_Payment_PUB.Get_Inv_Line_Total.' , 3 ) ;

7212: END IF;
7213: END IF;
7214:
7215: IF l_debug_level > 0 THEN
7216: oe_debug_pub.add( 'Exiting OE_Verify_Payment_PUB.Get_Inv_Line_Total.' , 3 ) ;
7217: END IF;
7218:
7219: EXCEPTION
7220: WHEN OTHERS THEN

Line 7222: oe_debug_pub.add( 'FROM OE_Verify_Payment_PUB.Get_Inv_Line_Total' ) ;

7218:
7219: EXCEPTION
7220: WHEN OTHERS THEN
7221: IF l_debug_level > 0 THEN
7222: oe_debug_pub.add( 'FROM OE_Verify_Payment_PUB.Get_Inv_Line_Total' ) ;
7223: END IF;
7224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7225: END Get_Inv_Line_Total;
7226:

Line 8346: , 'OE_Verify_Payment_PUB'

8342: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8343: THEN
8344: FND_MSG_PUB.Add_Exc_Msg
8345: ( G_PKG_NAME
8346: , 'OE_Verify_Payment_PUB'
8347: );
8348: END IF;
8349:
8350: OE_MSG_PUB.Count_And_Get

Line 8359: END OE_Verify_Payment_PUB ;

8355:
8356:
8357: END Create_New_Payment_Trxn;
8358:
8359: END OE_Verify_Payment_PUB ;