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.49.12020000.12 2013/04/12 10:50:50 slagiset 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.49.12020000.12 2013/04/12 10:50:50 slagiset 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 718: oe_debug_pub.add( 'ENTERING OE_VERIFY_PAYMENT_PUB.CREDIT_CHECK_LINE_LEVEL.' , 1 ) ;

714: --
715: BEGIN
716:
717: IF l_debug_level > 0 THEN
718: oe_debug_pub.add( 'ENTERING OE_VERIFY_PAYMENT_PUB.CREDIT_CHECK_LINE_LEVEL.' , 1 ) ;
719: END IF;
720:
721: -- Query the Order Header
722: IF l_debug_level > 0 THEN

Line 761: OE_Verify_Payment_PUB.Release_Verify_Hold

757: IF l_debug_level > 0 THEN
758: oe_debug_pub.add( 'OEXPVPMB LINE LEVEL: RELEASING CREDIT CARD ' || 'HOLDS-AFTER CREDITCHECKING' ) ;
759: END IF;
760: --
761: OE_Verify_Payment_PUB.Release_Verify_Hold
762: ( p_header_id => l_header_rec.header_id
763: , p_epayment_hold => 'Y' -- We want to Release Credit Card Hol
764: , p_msg_count => l_msg_count
765: , p_msg_data => l_msg_data

Line 782: OE_Verify_Payment_PUB.Release_Credit_Check_Hold

778: IF l_debug_level > 0 THEN
779: oe_debug_pub.add( 'OEXPVPMB LINE LEVEL: RELEASING CREDIT CHECKING HOLDS' ) ;
780: END IF;
781: --
782: OE_Verify_Payment_PUB.Release_Credit_Check_Hold
783: ( p_header_id => l_header_rec.header_id
784: , p_invoice_to_org_id => C1.invoice_to_org_id
785: , p_msg_count => l_msg_count
786: , p_msg_data => l_msg_data

Line 802: OE_Verify_Payment_PUB.Apply_Credit_Check_Hold

798: IF l_debug_level > 0 THEN
799: oe_debug_pub.add( 'OEXPVPMB LINE LEVEL: APPLYING CREDIT CHECKING FAILURE HOLD' ) ;
800: END IF;
801: --
802: OE_Verify_Payment_PUB.Apply_Credit_Check_Hold
803: ( p_header_id => l_header_rec.header_id
804: , p_invoice_to_org_id => C1.invoice_to_org_id -- XX
805: , p_hold_id => 1
806: , p_calling_action => l_calling_action

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

818: END IF; -- IF Result Out of Credit Checking
819: END LOOP;
820:
821: IF l_debug_level > 0 THEN
822: oe_debug_pub.add( 'EXITING OE_VERIFY_PAYMENT_PUB.CREDIT_CHECK_LINE_LEVEL.' , 1 ) ;
823: END IF;
824:
825: EXCEPTION
826:

Line 862: Calls OE_Verify_Payment_PUB.Payment_Request Authorization

858: /*--------------------------------------------------------------------------
859: Called By Booking, Pre Ship or Purchase Release Processing.
860: Checks if Electronic Payment is associated to the Order.
861: IF Yes THEN
862: Calls OE_Verify_Payment_PUB.Payment_Request Authorization
863: ELSE
864: Calls OE_Credit_PUB.OE_Check_Available_Credit for Credit Limit Checking
865:
866: 1961228 - Multi currency credit checking changes

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

912: oe_debug_pub.add( 'OEXPVPMB: IN VERIFY PAYMENT MAIN' , 1 ) ;
913: END IF;
914: G_credit_check_rule_id := NULL ;
915:
916: OE_Verify_Payment_PUB.G_init_calling_action := p_calling_action; --ER#7479609
917:
918: -- Query the Order Header
919: IF l_debug_level > 0 THEN
920: oe_debug_pub.add( 'OEXPVPMB: BEFORE QUERYING HEADER ID : '||P_HEADER_ID , 1 ) ;

Line 984: OE_Verify_Payment_PUB.Payment_Request

980:
981: -- Call the Payment Request API
982: OE_DEBUG_PUB.ADD('OEXPVPMB: Before Calling Payment Request API For VOIDAUTHONLY');
983: --
984: OE_Verify_Payment_PUB.Payment_Request
985: ( p_header_rec => l_header_rec
986: , p_trxn_type => 'VOIDAUTHONLY'
987: , p_msg_count => l_msg_count
988: , p_msg_data => l_msg_data

Line 1017: oe_debug_pub.add( 'OEXPVPMB: No Credit checking performed. Resetting the oe_verify_payment_pub.G_credit_check_flag. ' ) ;

1013: --
1014: IF l_header_rec.booked_flag = 'N' THEN
1015: -- start of changes for bug#16633189
1016: IF l_debug_level > 0 THEN
1017: oe_debug_pub.add( 'OEXPVPMB: No Credit checking performed. Resetting the oe_verify_payment_pub.G_credit_check_flag. ' ) ;
1018: END IF;
1019: oe_verify_payment_pub.G_credit_check_flag := 'Y' ;
1020: -- end of changes for bug# 16633189
1021: RETURN;

Line 1019: oe_verify_payment_pub.G_credit_check_flag := 'Y' ;

1015: -- start of changes for bug#16633189
1016: IF l_debug_level > 0 THEN
1017: oe_debug_pub.add( 'OEXPVPMB: No Credit checking performed. Resetting the oe_verify_payment_pub.G_credit_check_flag. ' ) ;
1018: END IF;
1019: oe_verify_payment_pub.G_credit_check_flag := 'Y' ;
1020: -- end of changes for bug# 16633189
1021: RETURN;
1022:
1023: ELSE

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

1030: -- Commenting code as the credit check rule will be BOOKING
1031: -- for order updates as well 2412678
1032: -- New fix: code was uncommented as part of Bug # 3292283.
1033:
1034: l_calling_action := OE_Verify_Payment_PUB.Which_Rule(p_header_id => p_header_id);
1035:
1036: END IF;
1037:
1038: END IF;

Line 1117: l_rule_defined := OE_Verify_Payment_PUB.Check_Rule_Defined

1113: IF NOT OE_PREPAYMENT_UTIL.IS_MULTIPLE_PAYMENTS_ENABLED THEN
1114: IF l_debug_level > 0 THEN
1115: oe_debug_pub.add( 'OEXPVPMB: BEFORE CHECKING IF THE RULE IS DEFINED OR NOT' ) ;
1116: END IF;
1117: l_rule_defined := OE_Verify_Payment_PUB.Check_Rule_Defined
1118: ( p_header_rec => l_header_rec
1119: , p_calling_action => l_calling_action
1120: ) ;
1121:

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

1149: IF l_debug_level > 0 THEN
1150: oe_debug_pub.add( 'OEXPVPMB: BEFORE CHECKING FOR ELECTRONIC PAYMENT' , 1 ) ;
1151: END IF;
1152: --
1153: l_epayment := OE_Verify_Payment_PUB.Is_Electronic_Payment( l_header_rec ) ;
1154:
1155: IF l_debug_level > 0 THEN
1156: oe_debug_pub.add( 'OEXPVPMB: IS IT AN ELECTRONIC PAYMENT : '|| L_EPAYMENT ) ;
1157: END IF;

Line 1204: l_rule_defined := OE_Verify_Payment_PUB.Check_Rule_Defined

1200: -- is now called from OE_Prepayment_PVT.process_payments
1201: -- if multiple payments is enabled.
1202: /*
1203: -- Check rule defined before going to credit checking engine.
1204: l_rule_defined := OE_Verify_Payment_PUB.Check_Rule_Defined
1205: ( p_header_rec => l_header_rec
1206: , p_calling_action => l_calling_action
1207: ) ;
1208:

Line 1365: OE_Verify_Payment_PUB.Release_Verify_Hold

1361: IF l_debug_level > 0 THEN
1362: oe_debug_pub.add( 'OEXPVPMB: RELEASING CREDIT CHECKING HOLDS' ) ;
1363: END IF;
1364: --
1365: OE_Verify_Payment_PUB.Release_Verify_Hold
1366: ( p_header_id => l_header_rec.header_id
1367: , p_epayment_hold => 'N' -- We want to Release Credit Checking Hold
1368: , p_msg_count => l_msg_count
1369: , p_msg_data => l_msg_data

Line 1389: OE_Verify_Payment_PUB.Apply_Verify_Hold

1385: IF l_debug_level > 0 THEN
1386: oe_debug_pub.add( 'OEXPVPMB: APPLYING CREDIT CHECKING FAILURE HOLD' ) ;
1387: END IF;
1388: --
1389: OE_Verify_Payment_PUB.Apply_Verify_Hold
1390: ( p_header_id => l_header_rec.header_id
1391: , p_hold_id => 1
1392: , p_msg_count => l_msg_count
1393: , p_msg_data => l_msg_data

Line 1444: OE_Verify_Payment_PUB.Payment_Request

1440: IF l_debug_level > 0 THEN
1441: oe_debug_pub.add( 'OEXPVPMB: BEFORE CALLING PAYMENT REQUEST API FOR AUTHONLY' ) ;
1442: END IF;
1443: --
1444: OE_Verify_Payment_PUB.Payment_Request
1445: ( p_header_rec => l_header_rec
1446: , p_trxn_type => 'AUTHONLY'
1447: , p_msg_count => l_msg_count
1448: , p_msg_data => l_msg_data

Line 1470: OE_Verify_Payment_PUB.Release_Verify_Hold

1466: IF l_debug_level > 0 THEN
1467: oe_debug_pub.add( 'OEXPVPMB: RELEASING CREDIT CHECKING HOLD' ) ;
1468: END IF;
1469: --
1470: OE_Verify_Payment_PUB.Release_Verify_Hold
1471: ( p_header_id => l_header_rec.header_id
1472: , p_epayment_hold => 'N' -- We want to Release Credit Check Hold
1473: , p_msg_count => l_msg_count
1474: , p_msg_data => l_msg_data

Line 1491: OE_Verify_Payment_PUB.Release_Verify_Hold

1487: IF l_debug_level > 0 THEN
1488: oe_debug_pub.add( 'OEXPVPMB: RELEASING CREDIT CARD HOLDS' ) ;
1489: END IF;
1490: --
1491: OE_Verify_Payment_PUB.Release_Verify_Hold
1492: ( p_header_id => l_header_rec.header_id
1493: , p_epayment_hold => 'Y' -- We want to Release Credit Card Holds
1494: , p_msg_count => l_msg_count
1495: , p_msg_data => l_msg_data

Line 1511: OE_Verify_Payment_PUB.Apply_Verify_Hold

1507: IF l_debug_level > 0 THEN
1508: oe_debug_pub.add( 'OEXPVPMB: APPLYING CC RISK HOLD' ) ;
1509: END IF;
1510: --
1511: OE_Verify_Payment_PUB.Apply_Verify_Hold
1512: ( p_header_id => l_header_rec.header_id
1513: , p_hold_id => 12 -- Seed Id for CC Risk Hold
1514: , p_msg_count => l_msg_count
1515: , p_msg_data => l_msg_data

Line 1531: OE_Verify_Payment_PUB.Apply_Verify_Hold

1527: IF l_debug_level > 0 THEN
1528: oe_debug_pub.add( 'OEXPVPMB: APPLYING CC AUTH FAILURE HOLD' ) ;
1529: END IF;
1530: --
1531: OE_Verify_Payment_PUB.Apply_Verify_Hold
1532: ( p_header_id => l_header_rec.header_id
1533: , p_hold_id => 11 -- Seeded Id for CC Auth Failure Hold
1534: , p_msg_count => l_msg_count
1535: , p_msg_data => l_msg_data

Line 1694: OE_Verify_Payment_PUB.Release_Verify_Hold

1690: IF l_debug_level > 0 THEN
1691: oe_debug_pub.add( 'OEXPVPMB: RELEASING CREDIT CHECKING HOLDS' ) ;
1692: END IF;
1693: --
1694: OE_Verify_Payment_PUB.Release_Verify_Hold
1695: ( p_header_id => l_header_rec.header_id
1696: , p_epayment_hold => 'N' -- We want to Release Credit Checking Hold
1697: , p_msg_count => l_msg_count
1698: , p_msg_data => l_msg_data

Line 1718: OE_Verify_Payment_PUB.Apply_Verify_Hold

1714: IF l_debug_level > 0 THEN
1715: oe_debug_pub.add( 'OEXPVPMB: APPLYING CREDIT CHECKING FAILURE HOLD' ) ;
1716: END IF;
1717: --
1718: OE_Verify_Payment_PUB.Apply_Verify_Hold
1719: ( p_header_id => l_header_rec.header_id
1720: , p_hold_id => 1
1721: , p_msg_count => l_msg_count
1722: , p_msg_data => l_msg_data

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

1960: AND Trunc(SYSDATE) BETWEEN NVL(CCR.START_DATE_ACTIVE, Trunc(SYSDATE)) AND NVL(CCR.END_DATE_ACTIVE, Trunc(SYSDATE));
1961: --7194250
1962:
1963:
1964: OE_Verify_Payment_PUB.G_credit_check_rule := 'Ordering'; --ER#7479609
1965:
1966: EXCEPTION
1967: WHEN NO_DATA_FOUND THEN
1968: l_credit_check_rule_id := 0;

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

1994: AND Trunc(SYSDATE) BETWEEN NVL(CCR.START_DATE_ACTIVE, Trunc(SYSDATE)) AND NVL(CCR.END_DATE_ACTIVE, Trunc(SYSDATE));
1995: --7194250
1996:
1997:
1998: OE_Verify_Payment_PUB.G_credit_check_rule := 'Shipping'; --ER#7479609
1999:
2000: EXCEPTION
2001: WHEN NO_DATA_FOUND THEN
2002: l_credit_check_rule_id := 0;

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

2025: AND Trunc(SYSDATE) BETWEEN NVL(CCR.START_DATE_ACTIVE, Trunc(SYSDATE)) AND NVL(CCR.END_DATE_ACTIVE, Trunc(SYSDATE));
2026: --7194250
2027:
2028:
2029: OE_Verify_Payment_PUB.G_credit_check_rule := 'Packing'; --ER#7479609
2030:
2031: EXCEPTION
2032: WHEN NO_DATA_FOUND THEN
2033: l_credit_check_rule_id := 0;

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

2056: AND Trunc(SYSDATE) BETWEEN NVL(CCR.START_DATE_ACTIVE, Trunc(SYSDATE)) AND NVL(CCR.END_DATE_ACTIVE, Trunc(SYSDATE));
2057: --7194250
2058:
2059:
2060: OE_Verify_Payment_PUB.G_credit_check_rule := 'Picking/Purchase Release'; --ER#7479609
2061:
2062: EXCEPTION
2063: WHEN NO_DATA_FOUND THEN
2064: l_credit_check_rule_id := 0;

Line 2241: OE_Verify_Payment_PUB.Hold_Exists

2237: IF l_debug_level > 0 THEN
2238: oe_debug_pub.add( 'OEXPVPMB: CHECKING EXISTENCE OF HOLD ID : '||L_HOLD_ID ) ;
2239: END IF;
2240: --
2241: OE_Verify_Payment_PUB.Hold_Exists
2242: ( p_header_id => l_hold_entity_id
2243: , p_hold_id => l_hold_id
2244: , p_hold_exists => l_hold_exists
2245: ) ;

Line 2288: OE_Verify_Payment_PUB.Hold_Exists

2284: IF l_debug_level > 0 THEN
2285: oe_debug_pub.add( 'OEXPVPMB: CHECKING EXISTENCE OF HOLD ID : '||L_HOLD_ID ) ;
2286: END IF;
2287: --
2288: OE_Verify_Payment_PUB.Hold_Exists
2289: ( p_header_id => l_hold_entity_id
2290: , p_hold_id => l_hold_id
2291: , p_hold_exists => l_hold_exists
2292: ) ;

Line 2335: OE_Verify_Payment_PUB.Hold_Exists

2331: IF l_debug_level > 0 THEN
2332: oe_debug_pub.add( 'OEXPVPMB: CHECKING EXISTENCE OF HOLD ID : '||L_HOLD_ID ) ;
2333: END IF;
2334: --
2335: OE_Verify_Payment_PUB.Hold_Exists
2336: ( p_header_id => l_hold_entity_id
2337: , p_hold_id => l_hold_id
2338: , p_hold_exists => l_hold_exists
2339: ) ;

Line 2383: OE_Verify_Payment_PUB.Hold_Exists

2379: IF l_debug_level > 0 THEN
2380: oe_debug_pub.add( 'OEXPVPMB: CHECKING EXISTENCE OF HOLD ID : '||L_HOLD_ID ) ;
2381: END IF;
2382: --
2383: OE_Verify_Payment_PUB.Hold_Exists
2384: ( p_header_id => l_hold_entity_id
2385: , p_hold_id => l_hold_id
2386: , p_hold_exists => l_hold_exists
2387: ) ;

Line 2500: OE_Verify_Payment_PUB.Hold_Exists

2496: IF l_debug_level > 0 THEN
2497: oe_debug_pub.add( 'OEXPVPMB: CHECKING IF REQUESTED VERIFY HOLD ALREADY APPLIED' ) ;
2498: END IF;
2499: --
2500: OE_Verify_Payment_PUB.Hold_Exists
2501: ( p_header_id => p_header_id
2502: , p_hold_id => p_hold_id
2503: , p_hold_exists => l_hold_exists
2504: );

Line 2632: OE_Verify_Payment_PUB.Hold_Exists

2628: IF l_debug_level > 0 THEN
2629: oe_debug_pub.add( 'OEXPVPMB: CHECKING IF REQUESTED VERIFY HOLD ALREADY APPLIED' ) ;
2630: END IF;
2631: --
2632: OE_Verify_Payment_PUB.Hold_Exists
2633: ( p_header_id => p_header_id
2634: , p_hold_id => p_hold_id
2635: , p_hold_exists => l_hold_exists
2636: );

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

2759: END IF;
2760: --
2761: -- lkxu, fix bug 1701377
2762: /***
2763: IF ( OE_Verify_Payment_PUB.Check_Ipayment_Installed = 'N' ) THEN
2764: -- We don't want to continue and we want to RETURN a SUCCESS.
2765: RETURN ;
2766: END IF;
2767: ***/

Line 2798: OE_Verify_Payment_PUB.Authorize_Payment( p_header_rec => p_header_rec

2794: IF l_debug_level > 0 THEN
2795: oe_debug_pub.add( 'OEXPVPMB: CALLING AUTHORIZE PAYMENT' ) ;
2796: END IF;
2797: --
2798: OE_Verify_Payment_PUB.Authorize_Payment( p_header_rec => p_header_rec
2799: , p_msg_count => l_msg_count
2800: , p_msg_data => l_msg_data
2801: , p_result_out => p_result_out
2802: , p_return_status=> l_return_status

Line 2817: OE_Verify_Payment_PUB.Fetch_Authorization_Trxn

2813: IF l_debug_level > 0 THEN
2814: oe_debug_pub.add( 'OEXPVPMB: BEFORE CALLING FETCH AUTHORIZATION TRXN' ) ;
2815: END IF;
2816: --
2817: OE_Verify_Payment_PUB.Fetch_Authorization_Trxn
2818: ( p_header_rec => p_header_rec
2819: , p_trxn_id => l_void_trxn_id
2820: , p_automatic_auth => l_automatic_auth
2821: );

Line 2835: OE_Verify_Payment_PUB.Void_Payment

2831: IF l_debug_level > 0 THEN
2832: oe_debug_pub.add( 'OEXPVPMB: BEFORE CALLING VOID PAYMENT FOR TRXN ID : '||L_VOID_TRXN_ID ) ;
2833: END IF;
2834: --
2835: OE_Verify_Payment_PUB.Void_Payment
2836: ( p_void_trxn_id => l_void_trxn_id
2837: , p_msg_count => l_msg_count
2838: , p_msg_data => l_msg_data
2839: , p_return_status=> l_return_status

Line 2873: OE_Verify_Payment_PUB.Update_Authorization_Info

2869: IF l_debug_level > 0 THEN
2870: oe_debug_pub.add( 'OEXPVPMB: CALLING UPDATE AUTH INFO TO UPDATE THE APPROVAL INFO TO NULL' ) ;
2871: END IF;
2872: --
2873: OE_Verify_Payment_PUB.Update_Authorization_Info
2874: ( p_header_rec.header_id
2875: , NULL
2876: , l_auth_code
2877: , l_trxn_date

Line 2893: OE_Verify_Payment_PUB.Release_Verify_Hold

2889: IF l_debug_level > 0 THEN
2890: oe_debug_pub.add( 'OEXPVPMB: RELEASING EXISTING CC HOLDS SINCE AUTH HAS BEEN VOIDED' ) ;
2891: END IF;
2892: --
2893: OE_Verify_Payment_PUB.Release_Verify_Hold
2894: ( p_header_id => p_header_rec.header_id
2895: , p_epayment_hold => 'Y' -- We want to Release Credit Card Hold
2896: , p_msg_count => l_msg_count
2897: , p_msg_data => l_msg_data

Line 3185: OE_Verify_Payment_PUB.Check_Reauthorize_Order

3181: IF l_debug_level > 0 THEN
3182: oe_debug_pub.add( 'OEXPVPMB: BEFORE CALLING CHECK REAUTHORIZE FLAG' ) ;
3183: END IF;
3184: --
3185: OE_Verify_Payment_PUB.Check_Reauthorize_Order
3186: ( p_header_rec => p_header_rec
3187: , p_void_trxn_id => l_void_trxn_id
3188: , p_outbound_total => l_outbound_total
3189: , p_reauthorize_out => l_reauthorize_flag

Line 3209: OE_Verify_Payment_PUB.Void_Payment

3205:
3206: -- Void this Transaction
3207: OE_DEBUG_PUB.ADD('OEXPVPMB: Before Calling Void Payment for Trxn ID : '||l_void_trxn_id);
3208: --
3209: OE_Verify_Payment_PUB.Void_Payment
3210: ( p_void_trxn_id => l_void_trxn_id
3211: , p_msg_count => l_msg_count
3212: , p_msg_data => l_msg_data
3213: , p_return_status=> l_return_status

Line 3236: OE_Verify_Payment_PUB.Hold_Exists

3232: IF l_debug_level > 0 THEN
3233: oe_debug_pub.add( 'OEXPVPMB: CHECK IF ORDER ON RISK HOLD' ) ;
3234: END IF;
3235: --
3236: OE_Verify_Payment_PUB.Hold_Exists
3237: ( p_header_id => p_header_rec.header_id
3238: , p_hold_id => 12 -- Seed Id for CC Risk Hold
3239: , p_hold_exists => l_hold_exists
3240: );

Line 3266: OE_Verify_Payment_PUB.Fetch_Last_Auth ( p_header_rec => p_header_rec

3262: IF l_debug_level > 0 THEN
3263: oe_debug_pub.add( 'OEXPVPMB: BEFORE CALLING FETCH LAST AUTH' ) ;
3264: END IF;
3265: --
3266: OE_Verify_Payment_PUB.Fetch_Last_Auth ( p_header_rec => p_header_rec
3267: , p_trxn_id => l_trxn_id
3268: , p_tangible_id => l_tangible_id
3269: , p_auth_code => l_auth_code
3270: , p_trxn_date => l_trxn_date

Line 3293: OE_Verify_Payment_PUB.Hold_Exists

3289:
3290: -- Check if Hold already exists on this order
3291: OE_DEBUG_PUB.ADD('OEXPVPMB: Check if Order on Risk Hold');
3292: --
3293: OE_Verify_Payment_PUB.Hold_Exists
3294: ( p_header_id => p_header_rec.header_id
3295: , p_hold_id => 12 -- Seed Id for CC Risk Hold
3296: , p_hold_exists => l_hold_exists
3297: );

Line 3339: l_pay_method_id := OE_Verify_Payment_PUB.Get_Primary_Pay_Method

3335: IF l_debug_level > 0 THEN
3336: oe_debug_pub.add( 'OEXPVPMB: BEFORE CALLING GET PRIMARY PAYMENT METHOD' ) ;
3337: END IF;
3338: --
3339: l_pay_method_id := OE_Verify_Payment_PUB.Get_Primary_Pay_Method
3340: ( p_header_rec => p_header_rec ) ;
3341:
3342: -- Check if a valid method was selected
3343: IF l_debug_level > 0 THEN

Line 3823: OE_Verify_Payment_PUB.Update_Authorization_Info

3819: oe_debug_pub.add( 'OEXPVPMB: l_order_value is: '||l_order_value ) ;
3820: oe_debug_pub.add( 'OEXPVPMB: l_auth_code is: '||l_auth_code ) ;
3821: END IF;
3822: --
3823: OE_Verify_Payment_PUB.Update_Authorization_Info
3824: ( p_header_rec.header_id
3825: , l_order_value
3826: , l_auth_code
3827: , l_trxn_date

Line 3925: OE_Verify_Payment_PUB.Fetch_Authorization_Trxn

3921: IF l_debug_level > 0 THEN
3922: oe_debug_pub.add( 'OEXPVPMB: BEFORE CALLING FETCH AUTHORIZATION TRXN' ) ;
3923: END IF;
3924: --
3925: OE_Verify_Payment_PUB.Fetch_Authorization_Trxn
3926: ( p_header_rec => p_header_rec
3927: , p_trxn_id => l_void_trxn_id
3928: , p_automatic_auth => l_automatic_auth
3929: );

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

3945: ** lines. Following is not required as closed lines will be considered captured.
3946: -- Fetch the Captured Amount Total
3947: OE_DEBUG_PUB.ADD('OEXPVPMB: Fetch Captured Amount Total');
3948: --
3949: l_captured_total := OE_Verify_Payment_PUB.Captured_Amount_Total(p_header_rec.header_id);
3950: OE_DEBUG_PUB.ADD('OEXPVPMB: Total Amount already Captured : '||l_captured_total);
3951:
3952: -- Uncaptured outbound Total is
3953: p_outbound_total := l_outbound_total - l_captured_total;

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

3983: oe_debug_pub.add( 'OEXPVPMB: IT IS AN AUTOMATIC AUTHORIZATION' ) ;
3984: END IF;
3985:
3986: -- If Transaction has already been captured then
3987: IF (OE_Verify_Payment_PUB.Check_Trxn_Captured(l_void_trxn_id) = 'Y') THEN
3988:
3989: IF l_debug_level > 0 THEN
3990: oe_debug_pub.add( 'OEXPVPMB: CURRENT AUTH CAPTURED , REAUTHORIZE' ) ;
3991: END IF;

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

4347: END IF;
4348:
4349:
4350: -- Return if Trxn has already been captured
4351: IF ( OE_Verify_Payment_PUB.Check_Trxn_Captured(p_void_trxn_id) = 'Y' ) THEN
4352: RETURN;
4353: END IF;
4354:
4355: -- Create the Dynamic SQL to Call the iPayment API

Line 4577: OE_Verify_Payment_PUB.Fetch_Current_Auth

4573: IF l_debug_level > 0 THEN
4574: oe_debug_pub.add( 'OEXPVPMB: BEFORE CALLING FETCH CURRENT AUTH' ) ;
4575: END IF;
4576: --
4577: OE_Verify_Payment_PUB.Fetch_Current_Auth
4578: ( p_header_rec => p_header_rec
4579: , p_trxn_id => l_trxn_id
4580: , p_tangible_id => l_tangible_id
4581: );

Line 4610: OE_Verify_Payment_PUB.Fetch_Last_Auth

4606:
4607: -- Call Last Current Auth
4608: OE_DEBUG_PUB.ADD('OEXPVPMB: Before calling Fetch Last Auth');
4609: --
4610: OE_Verify_Payment_PUB.Fetch_Last_Auth
4611: ( p_header_rec => p_header_rec
4612: , p_trxn_id => l_trxn_id
4613: , p_tangible_id => l_tangible_id
4614: );

Line 5463: l_cc_rev_reauth_code:= OE_VERIFY_PAYMENT_PUB.Get_CC_Rev_Reauth_Code(p_header_rec.header_id);

5459: l_result_status := 'PASS' ;
5460: l_amount_to_authorize := 0;
5461: --CC Reversal ER#16014135 Start
5462: --First time authorization needs to be exists for Reversal logic to kickoff.
5463: l_cc_rev_reauth_code:= OE_VERIFY_PAYMENT_PUB.Get_CC_Rev_Reauth_Code(p_header_rec.header_id);
5464: IF ((l_cc_rev_reauth_code is not null AND p_calling_action is NOT NULL) AND oe_verify_payment_pub.G_CC_Change_Flag <> 'Y')
5465: THEN
5466: IF (OE_Verify_Payment_PUB.Check_Rule_Defined
5467: ( p_header_rec => p_header_rec

Line 5464: IF ((l_cc_rev_reauth_code is not null AND p_calling_action is NOT NULL) AND oe_verify_payment_pub.G_CC_Change_Flag <> 'Y')

5460: l_amount_to_authorize := 0;
5461: --CC Reversal ER#16014135 Start
5462: --First time authorization needs to be exists for Reversal logic to kickoff.
5463: l_cc_rev_reauth_code:= OE_VERIFY_PAYMENT_PUB.Get_CC_Rev_Reauth_Code(p_header_rec.header_id);
5464: IF ((l_cc_rev_reauth_code is not null AND p_calling_action is NOT NULL) AND oe_verify_payment_pub.G_CC_Change_Flag <> 'Y')
5465: THEN
5466: IF (OE_Verify_Payment_PUB.Check_Rule_Defined
5467: ( p_header_rec => p_header_rec
5468: , p_calling_action => p_calling_action

Line 5466: IF (OE_Verify_Payment_PUB.Check_Rule_Defined

5462: --First time authorization needs to be exists for Reversal logic to kickoff.
5463: l_cc_rev_reauth_code:= OE_VERIFY_PAYMENT_PUB.Get_CC_Rev_Reauth_Code(p_header_rec.header_id);
5464: IF ((l_cc_rev_reauth_code is not null AND p_calling_action is NOT NULL) AND oe_verify_payment_pub.G_CC_Change_Flag <> 'Y')
5465: THEN
5466: IF (OE_Verify_Payment_PUB.Check_Rule_Defined
5467: ( p_header_rec => p_header_rec
5468: , p_calling_action => p_calling_action
5469: ) ='N') THEN
5470:

Line 5495: IF (l_cc_rev_reauth_code ='CC_HOLD' AND p_calling_action is NOT NULL AND oe_verify_payment_pub.G_CC_Change_Flag = 'Y') THEN

5491: goto Next_In_Loop;
5492: END;
5493: END IF;--rule defined check
5494: END IF;
5495: IF (l_cc_rev_reauth_code ='CC_HOLD' AND p_calling_action is NOT NULL AND oe_verify_payment_pub.G_CC_Change_Flag = 'Y') THEN
5496:
5497: IF l_debug_level > 0 THEN
5498: oe_debug_pub.add( 'OEXPVPMB: place order on Payment Authorization hold for line: '||l_payments_tbl(I).line_id , 1 ) ;
5499: END IF;

Line 5501: OE_Verify_Payment_PUB.Apply_Verify_Line_Hold

5497: IF l_debug_level > 0 THEN
5498: oe_debug_pub.add( 'OEXPVPMB: place order on Payment Authorization hold for line: '||l_payments_tbl(I).line_id , 1 ) ;
5499: END IF;
5500: IF l_payments_tbl(I).line_id IS NOT NULL THEN
5501: OE_Verify_Payment_PUB.Apply_Verify_Line_Hold
5502: ( p_header_id => p_header_rec.header_id
5503: , p_line_id => l_payments_tbl(I).line_id
5504: , p_hold_id => 16
5505: , p_msg_count => l_msg_count

Line 5510: OE_Verify_Payment_PUB.Apply_Verify_Hold

5506: , p_msg_data => l_msg_data
5507: , p_return_status => l_return_status
5508: );
5509: ELSE
5510: OE_Verify_Payment_PUB.Apply_Verify_Hold
5511: ( p_header_id => p_header_rec.header_id
5512: , p_hold_id => 16
5513: , p_msg_count => l_msg_count
5514: , p_msg_data => l_msg_data

Line 5542: OE_Verify_Payment_PUB.Apply_Verify_Line_Hold

5538: AND nvl(l_payments_tbl(I).defer_payment_processing_flag, 'N') = 'Y' THEN
5539: IF l_debug_level > 0 THEN
5540: oe_debug_pub.add( 'OEXPVPMB: place order on Defer Payment Authorization hold for line: '||l_payments_tbl(I).line_id , 1 ) ;
5541: END IF;
5542: OE_Verify_Payment_PUB.Apply_Verify_Line_Hold
5543: ( p_header_id => p_header_rec.header_id
5544: , p_line_id => l_payments_tbl(I).line_id
5545: , p_hold_id => 16
5546: , p_msg_count => l_msg_count

Line 5601: OE_Verify_Payment_PUB.Apply_Verify_Hold

5597: oe_debug_pub.add( 'OEXPVPMB: place order on Defer Payment Authorization hold for header: '||l_payments_tbl(I).header_id , 1 ) ;
5598: END IF;
5599:
5600: -- place on header level CC authorization hold.
5601: OE_Verify_Payment_PUB.Apply_Verify_Hold
5602: ( p_header_id => p_header_rec.header_id
5603: , p_hold_id => 16
5604: , p_msg_count => l_msg_count
5605: , p_msg_data => l_msg_data

Line 5749: OE_Verify_Payment_PUB.Check_ReAuth_for_MultiPmnts

5745: oe_debug_pub.add('OEXPVPMB: Line ID : '||l_payments_tbl(I).line_id, 3);
5746: oe_debug_pub.add('OEXPVPMB: Payment Number : '||l_payments_tbl(I).payment_number, 3);
5747: END IF;
5748:
5749: OE_Verify_Payment_PUB.Check_ReAuth_for_MultiPmnts
5750: ( p_credit_card_approval_code => l_payments_tbl(I).credit_card_approval_code
5751: , p_trxn_extension_id => l_payments_tbl(I).trxn_extension_id
5752: , p_amount_to_authorize => l_amount_to_authorize
5753: , p_org_id => p_header_rec.org_id

Line 5863: l_pay_method_id := OE_Verify_Payment_PUB.Get_Primary_Pay_Method

5859: null;
5860: END;
5861:
5862: IF l_pay_method_id IS NULL THEN
5863: l_pay_method_id := OE_Verify_Payment_PUB.Get_Primary_Pay_Method
5864: ( p_header_rec => p_header_rec ) ;
5865: END IF;
5866: END IF;
5867:

Line 6208: OE_Verify_Payment_PUB.Release_Verify_Hold

6204: --CC Reversal ER#16014135 End
6205: -- moved release hold code here before applying risk hold for bug 4543147
6206: -- Release Any existing CC Holds
6207: IF l_payments_tbl(I).line_id IS NULL THEN
6208: OE_Verify_Payment_PUB.Release_Verify_Hold
6209: ( p_header_id => p_header_rec.header_id
6210: , p_epayment_hold => 'Y' -- We want to Release Credit Card Holds
6211: , p_msg_count => l_msg_count
6212: , p_msg_data => l_msg_data

Line 6217: OE_Verify_Payment_PUB.Release_Verify_Line_Hold

6213: , p_return_status => l_return_status
6214: );
6215:
6216: ELSIF l_payments_tbl(I).line_id IS NOT NULL THEN
6217: OE_Verify_Payment_PUB.Release_Verify_Line_Hold
6218: ( p_header_id => p_header_rec.header_id
6219: , p_line_id => l_payments_tbl(I).line_id
6220: , p_epayment_hold => 'Y' -- We want to Release Credit Card Holds
6221: , p_msg_count => l_msg_count

Line 6252: OE_Verify_Payment_PUB.Apply_Verify_Hold_and_Commit

6248: -- the value for parameter param3 is Hold, then
6249: IF l_payments_tbl(I).line_id IS NULL THEN
6250: IF NVL(p_calling_action, 'BOOKING') IN ('SHIPPING','PACKING','PICKING')
6251: THEN
6252: OE_Verify_Payment_PUB.Apply_Verify_Hold_and_Commit
6253: ( p_header_id => p_header_rec.header_id
6254: , p_hold_id => 12 -- Seeded Id for CC Risk Hold
6255: , p_msg_count => l_msg_count
6256: , p_msg_data => l_msg_data

Line 6261: OE_Verify_Payment_PUB.Apply_Verify_Hold

6257: , p_return_status => l_return_status
6258: );
6259:
6260: ELSE
6261: OE_Verify_Payment_PUB.Apply_Verify_Hold
6262: ( p_header_id => p_header_rec.header_id
6263: , p_hold_id => 12 -- Seeded Id for CC Risk Hold
6264: , p_msg_count => l_msg_count
6265: , p_msg_data => l_msg_data

Line 6272: OE_Verify_Payment_PUB.Apply_Verify_Line_Hold_Commit

6268: END IF;
6269: ELSIF l_payments_tbl(I).line_id IS NOT NULL THEN
6270: IF NVL(p_calling_action, 'BOOKING') IN ('SHIPPING','PACKING','PICKING')
6271: THEN
6272: OE_Verify_Payment_PUB.Apply_Verify_Line_Hold_Commit
6273: ( p_header_id => p_header_rec.header_id
6274: , p_line_id => l_payments_tbl(I).line_id
6275: , p_hold_id => 12 -- Seeded Id for CC Risk Hold
6276: , p_msg_count => l_msg_count

Line 6281: OE_Verify_Payment_PUB.Apply_Verify_Line_Hold

6277: , p_msg_data => l_msg_data
6278: , p_return_status => l_return_status
6279: );
6280: ELSE
6281: OE_Verify_Payment_PUB.Apply_Verify_Line_Hold
6282: ( p_header_id => p_header_rec.header_id
6283: , p_line_id => l_payments_tbl(I).line_id
6284: , p_hold_id => 12 -- Seeded Id for CC Risk Hold
6285: , p_msg_count => l_msg_count

Line 6386: OE_Verify_Payment_PUB.Apply_Verify_Hold_and_Commit

6382:
6383: IF l_payments_tbl(I).line_id IS NULL THEN
6384: IF NVL(p_calling_action, 'BOOKING') IN ('SHIPPING','PACKING','PICKING')
6385: THEN
6386: OE_Verify_Payment_PUB.Apply_Verify_Hold_and_Commit
6387: ( p_header_id => p_header_rec.header_id
6388: , p_hold_id => 11 -- Seeded Id for CC Auth Failure Hold
6389: , p_msg_count => l_msg_count
6390: , p_msg_data => l_msg_data

Line 6395: OE_Verify_Payment_PUB.Apply_Verify_Hold

6391: , p_return_status => l_return_status
6392: );
6393:
6394: ELSE
6395: OE_Verify_Payment_PUB.Apply_Verify_Hold
6396: ( p_header_id => p_header_rec.header_id
6397: , p_hold_id => 11 -- Seeded Id for CC Auth Failure Hold
6398: , p_msg_count => l_msg_count
6399: , p_msg_data => l_msg_data

Line 6417: OE_Verify_Payment_PUB.Apply_Verify_Line_Hold_Commit

6413:
6414: ELSIF l_payments_tbl(I).line_id IS NOT NULL THEN
6415: IF NVL(p_calling_action, 'BOOKING') IN ('SHIPPING','PACKING','PICKING')
6416: THEN
6417: OE_Verify_Payment_PUB.Apply_Verify_Line_Hold_Commit
6418: ( p_header_id => p_header_rec.header_id
6419: , p_line_id => l_payments_tbl(I).line_id
6420: , p_hold_id => 11 -- Seeded Id for CC Auth Failure Hold
6421: , p_msg_count => l_msg_count

Line 6427: OE_Verify_Payment_PUB.Apply_Verify_Line_Hold

6423: , p_return_status => l_return_status
6424: );
6425:
6426: ELSE
6427: OE_Verify_Payment_PUB.Apply_Verify_Line_Hold
6428: ( p_header_id => p_header_rec.header_id
6429: , p_line_id => l_payments_tbl(I).line_id
6430: , p_hold_id => 11 -- Seeded Id for CC Auth Failure Hold
6431: , p_msg_count => l_msg_count

Line 6458: OE_Verify_Payment_PUB.Apply_Verify_Hold_and_Commit

6454:
6455: IF l_payments_tbl(I).line_id IS NULL THEN
6456: IF NVL(p_calling_action, 'BOOKING') IN ('SHIPPING','PACKING','PICKING')
6457: THEN
6458: OE_Verify_Payment_PUB.Apply_Verify_Hold_and_Commit
6459: ( p_header_id => p_header_rec.header_id
6460: , p_hold_id => 12 -- Seeded Id for CC Risk Hold
6461: , p_msg_count => l_msg_count
6462: , p_msg_data => l_msg_data

Line 6466: OE_Verify_Payment_PUB.Apply_Verify_Hold

6462: , p_msg_data => l_msg_data
6463: , p_return_status => l_return_status
6464: );
6465: ELSE
6466: OE_Verify_Payment_PUB.Apply_Verify_Hold
6467: ( p_header_id => p_header_rec.header_id
6468: , p_hold_id => 12 -- Seeded Id for CC Risk Hold
6469: , p_msg_count => l_msg_count
6470: , p_msg_data => l_msg_data

Line 6477: OE_Verify_Payment_PUB.Apply_Verify_Line_Hold_Commit

6473: END IF;
6474: ELSIF l_payments_tbl(I).line_id IS NOT NULL THEN
6475: IF NVL(p_calling_action, 'BOOKING') IN ('SHIPPING','PACKING','PICKING')
6476: THEN
6477: OE_Verify_Payment_PUB.Apply_Verify_Line_Hold_Commit
6478: ( p_header_id => p_header_rec.header_id
6479: , p_line_id => l_payments_tbl(I).line_id
6480: , p_hold_id => 12 -- Seeded Id for CC Risk Hold
6481: , p_msg_count => l_msg_count

Line 6486: OE_Verify_Payment_PUB.Apply_Verify_Line_Hold

6482: , p_msg_data => l_msg_data
6483: , p_return_status => l_return_status
6484: );
6485: ELSE
6486: OE_Verify_Payment_PUB.Apply_Verify_Line_Hold
6487: ( p_header_id => p_header_rec.header_id
6488: , p_line_id => l_payments_tbl(I).line_id
6489: , p_hold_id => 12 -- Seeded Id for CC Risk Hold
6490: , p_msg_count => l_msg_count

Line 6547: OE_Verify_Payment_PUB.Apply_Verify_Hold_and_Commit

6543: --comm rej IF nvl(p_reject_on_auth_failure, 'N') = 'N' THEN
6544: IF l_payments_tbl(I).line_id IS NULL THEN
6545: IF NVL(p_calling_action, 'BOOKING') IN ('SHIPPING','PACKING','PICKING')
6546: THEN
6547: OE_Verify_Payment_PUB.Apply_Verify_Hold_and_Commit
6548: ( p_header_id => p_header_rec.header_id
6549: , p_hold_id => 11 -- Seeded Id for CC Auth Failure Hold
6550: , p_msg_count => l_msg_count
6551: , p_msg_data => l_msg_data

Line 6556: OE_Verify_Payment_PUB.Apply_Verify_Hold

6552: , p_return_status => l_return_status
6553: );
6554:
6555: ELSE
6556: OE_Verify_Payment_PUB.Apply_Verify_Hold
6557: ( p_header_id => p_header_rec.header_id
6558: , p_hold_id => 11 -- Seeded Id for CC Auth Failure Hold
6559: , p_msg_count => l_msg_count
6560: , p_msg_data => l_msg_data

Line 6567: OE_Verify_Payment_PUB.Apply_Verify_Line_Hold_Commit

6563: END IF;
6564: ELSIF l_payments_tbl(I).line_id IS NOT NULL THEN
6565: IF NVL(p_calling_action, 'BOOKING') IN ('SHIPPING','PACKING','PICKING')
6566: THEN
6567: OE_Verify_Payment_PUB.Apply_Verify_Line_Hold_Commit
6568: ( p_header_id => p_header_rec.header_id
6569: , p_line_id => l_payments_tbl(I).line_id
6570: , p_hold_id => 11 -- Seeded Id for CC Auth Failure Hold
6571: , p_msg_count => l_msg_count

Line 6577: OE_Verify_Payment_PUB.Apply_Verify_Line_Hold

6573: , p_return_status => l_return_status
6574: );
6575:
6576: ELSE
6577: OE_Verify_Payment_PUB.Apply_Verify_Line_Hold
6578: ( p_header_id => p_header_rec.header_id
6579: , p_line_id => l_payments_tbl(I).line_id
6580: , p_hold_id => 11 -- Seeded Id for CC Auth Failure Hold
6581: , p_msg_count => l_msg_count

Line 6636: OE_Verify_Payment_PUB.Update_AuthInfo_for_MultiPmnts

6632: --
6633:
6634: /*
6635: IF l_result_status = 'PASS' THEN
6636: OE_Verify_Payment_PUB.Update_AuthInfo_for_MultiPmnts
6637: ( p_header_rec.header_id
6638: , l_amount_to_authorize
6639: , l_auth_code
6640: , l_trxn_date

Line 6704: OE_Verify_Payment_PUB.Release_Verify_Hold

6700: END IF;
6701: --
6702:
6703: IF l_payments_tbl(I).line_id IS NULL THEN
6704: OE_Verify_Payment_PUB.Release_Verify_Hold
6705: ( p_header_id => p_header_rec.header_id
6706: , p_epayment_hold => 'Y' -- We want to Release Credit Card Holds
6707: , p_msg_count => l_msg_count
6708: , p_msg_data => l_msg_data

Line 6713: OE_Verify_Payment_PUB.Release_Verify_Line_Hold

6709: , p_return_status => l_return_status
6710: );
6711:
6712: ELSIF l_payments_tbl(I).line_id IS NOT NULL THEN
6713: OE_Verify_Payment_PUB.Release_Verify_Line_Hold
6714: ( p_header_id => p_header_rec.header_id
6715: , p_line_id => l_payments_tbl(I).line_id
6716: , p_epayment_hold => 'Y' -- We want to Release Credit Card Holds
6717: , p_msg_count => l_msg_count

Line 6737: OE_Verify_Payment_PUB.Apply_Verify_Hold

6733: oe_debug_pub.add( 'OEXPVPMB: APPLYING LINE LEVEL CC RISK HOLD' ) ;
6734: END IF;
6735: --
6736: IF l_payments_tbl(I).line_id IS NULL THEN
6737: OE_Verify_Payment_PUB.Apply_Verify_Hold
6738: ( p_header_id => p_header_rec.header_id
6739: , p_hold_id => 12 -- Seed Id for CC Risk Hold
6740: , p_msg_count => l_msg_count
6741: , p_msg_data => l_msg_data

Line 6745: OE_Verify_Payment_PUB.Apply_Verify_Line_Hold

6741: , p_msg_data => l_msg_data
6742: , p_return_status => l_return_status
6743: );
6744: ELSIF l_payments_tbl(I).line_id IS NOT NULL THEN
6745: OE_Verify_Payment_PUB.Apply_Verify_Line_Hold
6746: ( p_header_id => p_header_rec.header_id
6747: , p_line_id => l_payments_tbl(I).line_id
6748: , p_hold_id => 12 -- Seed Id for CC Risk Hold
6749: , p_msg_count => l_msg_count

Line 6769: OE_Verify_Payment_PUB.Apply_Verify_Hold

6765: END IF;
6766: --
6767:
6768: IF l_payments_tbl(I).line_id IS NULL THEN
6769: OE_Verify_Payment_PUB.Apply_Verify_Hold
6770: ( p_header_id => p_header_rec.header_id
6771: , p_hold_id => 11 -- Seeded Id for CC Auth Failure Hold
6772: , p_msg_count => l_msg_count
6773: , p_msg_data => l_msg_data

Line 6777: OE_Verify_Payment_PUB.Apply_Verify_Line_Hold

6773: , p_msg_data => l_msg_data
6774: , p_return_status => l_return_status
6775: );
6776: ELSIF l_payments_tbl(I).line_id IS NOT NULL THEN
6777: OE_Verify_Payment_PUB.Apply_Verify_Line_Hold
6778: ( p_header_id => p_header_rec.header_id
6779: , p_line_id => l_payments_tbl(I).line_id
6780: , p_hold_id => 11 -- Seeded Id for CC Auth Failure Hold
6781: , p_msg_count => l_msg_count

Line 6799: IF oe_verify_payment_pub.G_CC_Change_Flag = 'Y' THEN

6795: <>
6796: I := l_payments_tbl.NEXT(I);
6797: END LOOP;
6798: --CC Reversal ER#16014135 Start
6799: IF oe_verify_payment_pub.G_CC_Change_Flag = 'Y' THEN
6800: oe_verify_payment_pub.G_CC_Change_Flag := 'N';--re-initialze it to N
6801: END IF;
6802: --CC Reversal ER#16014135 End
6803: p_return_status := l_return_status;

Line 6800: oe_verify_payment_pub.G_CC_Change_Flag := 'N';--re-initialze it to N

6796: I := l_payments_tbl.NEXT(I);
6797: END LOOP;
6798: --CC Reversal ER#16014135 Start
6799: IF oe_verify_payment_pub.G_CC_Change_Flag = 'Y' THEN
6800: oe_verify_payment_pub.G_CC_Change_Flag := 'N';--re-initialze it to N
6801: END IF;
6802: --CC Reversal ER#16014135 End
6803: p_return_status := l_return_status;
6804:

Line 7165: l_cc_rev_reauth_code:= OE_VERIFY_PAYMENT_PUB.Get_CC_Rev_Reauth_Code(p_header_id);

7161: IF p_amount_to_authorize <> l_authorized_amt THEN
7162: IF l_debug_level > 0 THEN
7163: oe_debug_pub.add('amounts are different.. requires re-authorization',5);
7164: END IF;
7165: l_cc_rev_reauth_code:= OE_VERIFY_PAYMENT_PUB.Get_CC_Rev_Reauth_Code(p_header_id);
7166: IF l_cc_rev_reauth_code IS NULL THEN
7167: IF l_debug_level > 0 THEN
7168: oe_debug_pub.add('CC Reversal is Not set',5);
7169: END IF;

Line 7188: OE_Verify_Payment_PUB.Apply_Verify_Hold

7184: IF l_debug_level > 0 THEN
7185: oe_debug_pub.add('applying hold based on system parameter for reversal',5);
7186: END IF;
7187: IF p_line_id IS NULL THEN
7188: OE_Verify_Payment_PUB.Apply_Verify_Hold
7189: ( p_header_id => p_header_id
7190: , p_hold_id => 16 -- Seeded Id for Pending Payment Authorization Hold
7191: , p_msg_count => l_msg_count
7192: , p_msg_data => l_msg_data

Line 7196: OE_Verify_Payment_PUB.Apply_Verify_Line_Hold

7192: , p_msg_data => l_msg_data
7193: , p_return_status => l_return_status
7194: );
7195: ELSIF p_line_id IS NOT NULL THEN
7196: OE_Verify_Payment_PUB.Apply_Verify_Line_Hold
7197: ( p_header_id => p_header_id
7198: , p_line_id => p_line_id
7199: , p_hold_id => 16 -- Seeded Id for Pending Payment Authorization Hold
7200: , p_msg_count => l_msg_count

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

7370: --
7371: BEGIN
7372:
7373: IF l_debug_level > 0 THEN
7374: oe_debug_pub.add( 'ENTERING OE_Verify_Payment_Pub.Get_Line_Total.' , 1 ) ;
7375: END IF;
7376:
7377: --8241416 start
7378: IF OE_ORDER_UTIL.G_Precision IS NULL THEN

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

7609: END IF;
7610: END IF;
7611:
7612: IF l_debug_level > 0 THEN
7613: oe_debug_pub.add( 'Exiting OE_Verify_Payment_PUB.Get_Line_Total.' , 3 ) ;
7614: END IF;
7615:
7616: EXCEPTION
7617: WHEN OTHERS THEN

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

7615:
7616: EXCEPTION
7617: WHEN OTHERS THEN
7618: IF l_debug_level > 0 THEN
7619: oe_debug_pub.add( 'Unexpected Error from OE_Verify_Payment_PUB.Get_Line_Total ' || SQLERRM ) ;
7620: END IF;
7621: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7622: END Get_Line_Total;
7623:

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

7659: --
7660: BEGIN
7661:
7662: IF l_debug_level > 0 THEN
7663: oe_debug_pub.add( 'ENTERING OE_Verify_Payment_Pub.Get_Inv_Line_Total.' , 1 ) ;
7664: END IF;
7665:
7666: -- Select the Tax Value and Outbound Extended Price
7667: BEGIN

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

7848: END IF;
7849: END IF;
7850:
7851: IF l_debug_level > 0 THEN
7852: oe_debug_pub.add( 'Exiting OE_Verify_Payment_PUB.Get_Inv_Line_Total.' , 3 ) ;
7853: END IF;
7854:
7855: EXCEPTION
7856: WHEN OTHERS THEN

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

7854:
7855: EXCEPTION
7856: WHEN OTHERS THEN
7857: IF l_debug_level > 0 THEN
7858: oe_debug_pub.add( 'FROM OE_Verify_Payment_PUB.Get_Inv_Line_Total' ) ;
7859: END IF;
7860: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7861: END Get_Inv_Line_Total;
7862:

Line 8991: , 'OE_Verify_Payment_PUB'

8987: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8988: THEN
8989: FND_MSG_PUB.Add_Exc_Msg
8990: ( G_PKG_NAME
8991: , 'OE_Verify_Payment_PUB'
8992: );
8993: END IF;
8994:
8995: OE_MSG_PUB.Count_And_Get

Line 9037: END OE_Verify_Payment_PUB ;

9033: RETURN l_cc_rev_reauth_code;
9034: END Get_CC_Rev_Reauth_Code;
9035: --CC Reversal ER#16014135 End
9036:
9037: END OE_Verify_Payment_PUB ;