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_ORDER_PUB

Line 634: l_header_rec OE_Order_PUB.Header_Rec_Type;

630: IS
631:
632: l_calling_action VARCHAR2(30) := p_calling_action;
633: l_epayment VARCHAR2(1);
634: l_header_rec OE_Order_PUB.Header_Rec_Type;
635: l_msg_count NUMBER := 0 ;
636: l_msg_data VARCHAR2(2000):= NULL ;
637: l_result_out VARCHAR2(30) := NULL ;
638: l_return_status VARCHAR2(30) := NULL ;

Line 829: l_header_rec OE_Order_PUB.Header_Rec_Type;

825: IS
826: l_calling_action VARCHAR2(30) := p_calling_action;
827: l_rule_defined VARCHAR2(1);
828: l_epayment VARCHAR2(1);
829: l_header_rec OE_Order_PUB.Header_Rec_Type;
830: l_msg_count NUMBER := 0 ;
831: l_msg_data VARCHAR2(2000):= NULL ;
832: l_result_out VARCHAR2(30) := NULL ;
833: l_return_status VARCHAR2(30) := NULL ;

Line 1849: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type

1845: Checks if the Rule defined by calling action has been setup at
1846: Order Type or not. If setup then returns 'Y' else returns 'N'.
1847: ---------------------------------------------------------------------*/
1848: FUNCTION Check_Rule_Defined
1849: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type
1850: , p_calling_action IN VARCHAR2
1851: ) RETURN VARCHAR2
1852: IS
1853: l_credit_check_rule_id NUMBER ;

Line 2025: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type )

2021: /*-------------------------------------------------------------------
2022: Returns 'Y' if the Order is being paid using a Credit Card
2023: ---------------------------------------------------------------------*/
2024: FUNCTION Is_Electronic_Payment
2025: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type )
2026: RETURN VARCHAR2
2027: IS
2028: --
2029: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 2655: p_header_rec IN OE_Order_PUB.Header_Rec_Type,

2651: /*----------------------------------------------------------------------
2652: Main Procedure called for all Electronic Payment Processing.
2653: ----------------------------------------------------------------------*/
2654: PROCEDURE Payment_Request (
2655: p_header_rec IN OE_Order_PUB.Header_Rec_Type,
2656: p_trxn_type IN VARCHAR2,
2657: p_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
2658: p_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
2659: p_result_out OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 2913: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type

2909: /*----------------------------------------------------------------------
2910: This Procedure returns tangibleid, amount if Voice Auth Needed
2911: ----------------------------------------------------------------------*/
2912: PROCEDURE Voice_Auth_Requested
2913: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type
2914: , p_tangible_id OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2915: , p_amount OUT NOCOPY /* file.sql.39 change */ NUMBER
2916: , p_line_id IN NUMBER DEFAULT NULL)
2917: IS

Line 3032: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type

3028: /*----------------------------------------------------------------------
3029: Calls iPayment's API to authorize a Credit Card Payment for an Order.
3030: ----------------------------------------------------------------------*/
3031: PROCEDURE Authorize_Payment
3032: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type
3033: , p_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
3034: , p_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
3035: , p_result_out OUT NOCOPY /* file.sql.39 change */ VARCHAR2
3036: , p_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 3061: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;

3057: l_payer_county VARCHAR2(60);
3058: l_payer_state VARCHAR2(60);
3059: l_payer_postalcode VARCHAR2(60);
3060: l_payer_country VARCHAR2(60);
3061: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
3062: l_ship_to_address VARCHAR2(10);
3063: l_time_of_purchase VARCHAR2(10);
3064: l_block_str VARCHAR2(5000);
3065: l_risk_threshold NUMBER := 0 ;

Line 3825: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type

3821: 4. Flag to indicate if Reauthorization is required or Not
3822: 5. Flag to indicate if the Current Transaction is Automatic or Manual
3823: ----------------------------------------------------------------------*/
3824: PROCEDURE Check_Reauthorize_Order
3825: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type
3826: , p_void_trxn_id OUT NOCOPY /* file.sql.39 change */ NUMBER
3827: , p_outbound_total OUT NOCOPY /* file.sql.39 change */ NUMBER
3828: , p_reauthorize_out OUT NOCOPY /* file.sql.39 change */ VARCHAR2 )
3829: IS

Line 4018: ( p_header_rec IN OE_Order_Pub.Header_Rec_Type )

4014: /*----------------------------------------------------------------------
4015: Returns TRUE if all the Required Attributes exists else returns FALSE.
4016: ----------------------------------------------------------------------*/
4017: FUNCTION Validate_Required_Attributes
4018: ( p_header_rec IN OE_Order_Pub.Header_Rec_Type )
4019: RETURN BOOLEAN
4020: IS
4021: l_result BOOLEAN := TRUE;
4022: --

Line 4076: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type )

4072: /*----------------------------------------------------------------------
4073: Returns Primary Payment Method for the Customer
4074: ----------------------------------------------------------------------*/
4075: FUNCTION Get_Primary_Pay_Method
4076: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type )
4077: RETURN NUMBER
4078: IS
4079: l_cc_only BOOLEAN := TRUE ;
4080: l_pay_method_id NUMBER := 0;

Line 4482: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type

4478: Returns 'Y' if this authorization was taken through iPayment else 'N'.
4479: Also returns the Transaction ID.
4480: ----------------------------------------------------------------------*/
4481: PROCEDURE Fetch_Authorization_Trxn
4482: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type
4483: , p_trxn_id OUT NOCOPY /* file.sql.39 change */ NUMBER
4484: , p_automatic_auth OUT NOCOPY /* file.sql.39 change */ VARCHAR2 )
4485: IS
4486: l_trxn_id NUMBER;

Line 4555: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type

4551: /*----------------------------------------------------------------------
4552: Fetches the authorization details for the approval code on the Order.
4553: ----------------------------------------------------------------------*/
4554: PROCEDURE Fetch_Current_Auth
4555: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type
4556: , p_line_id IN NUMBER DEFAULT NULL
4557: , p_auth_code IN VARCHAR2 DEFAULT NULL
4558: , p_auth_date IN DATE DEFAULT NULL
4559: , p_trxn_id OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 4737: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type

4733: /*----------------------------------------------------------------------
4734: Fetches the Last Authorization Transaction for the Order
4735: ----------------------------------------------------------------------*/
4736: PROCEDURE Fetch_Last_Auth
4737: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type
4738: , p_trxn_id OUT NOCOPY /* file.sql.39 change */ NUMBER
4739: , p_tangible_id OUT NOCOPY /* file.sql.39 change */ VARCHAR2
4740: , p_auth_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
4741: , p_trxn_date OUT NOCOPY /* file.sql.39 change */ DATE

Line 4861: l_header_rec OE_ORDER_PUB.Header_Rec_Type;

4857: IS
4858: l_index NUMBER := 1;
4859: l_notify_index NUMBER := 1; -- jolin
4860: l_line_id NUMBER;
4861: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
4862: l_old_header_rec OE_ORDER_PUB.Header_Rec_Type;
4863: l_msg_count NUMBER;
4864: l_msg_data VARCHAR2(2000);
4865: l_control_rec OE_GLOBALS.Control_Rec_Type;

Line 4862: l_old_header_rec OE_ORDER_PUB.Header_Rec_Type;

4858: l_index NUMBER := 1;
4859: l_notify_index NUMBER := 1; -- jolin
4860: l_line_id NUMBER;
4861: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
4862: l_old_header_rec OE_ORDER_PUB.Header_Rec_Type;
4863: l_msg_count NUMBER;
4864: l_msg_data VARCHAR2(2000);
4865: l_control_rec OE_GLOBALS.Control_Rec_Type;
4866: l_return_status VARCHAR2(30);

Line 5106: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type

5102:
5103: END Captured_Amount_Total;
5104:
5105: PROCEDURE Authorize_MultiPayments
5106: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type
5107: , p_line_id IN NUMBER DEFAULT null --bug3524209
5108: , p_calling_action IN VARCHAR2
5109: --comm rej, p_reject_on_auth_failure IN VARCHAR2 DEFAULT NULL --R12 CC Encryption
5110: --comm rej, p_reject_on_risk_failure IN VARCHAR2 DEFAULT NULL

Line 5138: l_line_rec OE_Order_PUB.Line_Rec_Type;

5134: l_riskresp_included VARCHAR2(30);
5135: l_risk_score NUMBER := 0 ;
5136: l_result_out VARCHAR2(30) := NULL ;
5137: l_hold_exists VARCHAR2(1);
5138: l_line_rec OE_Order_PUB.Line_Rec_Type;
5139: l_ordered_date DATE;
5140: l_currency_code VARCHAR2(15);
5141: l_line_total NUMBER := 0;
5142: l_order_total NUMBER := 0;

Line 5147: l_payments_tbl OE_ORDER_PUB.Line_Payment_Tbl_Type;

5143:
5144: l_invoice_to_org_id NUMBER;
5145: l_ship_to_org_id NUMBER;
5146: l_line_id NUMBER;
5147: l_payments_tbl OE_ORDER_PUB.Line_Payment_Tbl_Type;
5148: l_count NUMBER;
5149: i PLS_INTEGER;
5150: l_prepaid_total NUMBER;
5151: l_outbound_total NUMBER;

Line 7463: l_Line_Payment_rec OE_ORDER_PUB.Line_Payment_Rec_Type;

7459: IS
7460: l_index NUMBER := 1;
7461: l_notify_index NUMBER := 1;
7462: l_line_id NUMBER;
7463: l_Line_Payment_rec OE_ORDER_PUB.Line_Payment_Rec_Type;
7464: l_old_Line_Payment_rec OE_ORDER_PUB.Line_Payment_Rec_Type;
7465: l_Header_Payment_rec OE_ORDER_PUB.Header_Payment_Rec_Type;
7466: l_old_Header_Payment_rec OE_ORDER_PUB.Header_Payment_Rec_Type;
7467: l_msg_count NUMBER;

Line 7464: l_old_Line_Payment_rec OE_ORDER_PUB.Line_Payment_Rec_Type;

7460: l_index NUMBER := 1;
7461: l_notify_index NUMBER := 1;
7462: l_line_id NUMBER;
7463: l_Line_Payment_rec OE_ORDER_PUB.Line_Payment_Rec_Type;
7464: l_old_Line_Payment_rec OE_ORDER_PUB.Line_Payment_Rec_Type;
7465: l_Header_Payment_rec OE_ORDER_PUB.Header_Payment_Rec_Type;
7466: l_old_Header_Payment_rec OE_ORDER_PUB.Header_Payment_Rec_Type;
7467: l_msg_count NUMBER;
7468: l_msg_data VARCHAR2(2000);

Line 7465: l_Header_Payment_rec OE_ORDER_PUB.Header_Payment_Rec_Type;

7461: l_notify_index NUMBER := 1;
7462: l_line_id NUMBER;
7463: l_Line_Payment_rec OE_ORDER_PUB.Line_Payment_Rec_Type;
7464: l_old_Line_Payment_rec OE_ORDER_PUB.Line_Payment_Rec_Type;
7465: l_Header_Payment_rec OE_ORDER_PUB.Header_Payment_Rec_Type;
7466: l_old_Header_Payment_rec OE_ORDER_PUB.Header_Payment_Rec_Type;
7467: l_msg_count NUMBER;
7468: l_msg_data VARCHAR2(2000);
7469: l_control_rec OE_GLOBALS.Control_Rec_Type;

Line 7466: l_old_Header_Payment_rec OE_ORDER_PUB.Header_Payment_Rec_Type;

7462: l_line_id NUMBER;
7463: l_Line_Payment_rec OE_ORDER_PUB.Line_Payment_Rec_Type;
7464: l_old_Line_Payment_rec OE_ORDER_PUB.Line_Payment_Rec_Type;
7465: l_Header_Payment_rec OE_ORDER_PUB.Header_Payment_Rec_Type;
7466: l_old_Header_Payment_rec OE_ORDER_PUB.Header_Payment_Rec_Type;
7467: l_msg_count NUMBER;
7468: l_msg_data VARCHAR2(2000);
7469: l_control_rec OE_GLOBALS.Control_Rec_Type;
7470: l_return_status VARCHAR2(30);