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 700: l_header_rec OE_Order_PUB.Header_Rec_Type;

696: IS
697:
698: l_calling_action VARCHAR2(30) := p_calling_action;
699: l_epayment VARCHAR2(1);
700: l_header_rec OE_Order_PUB.Header_Rec_Type;
701: l_msg_count NUMBER := 0 ;
702: l_msg_data VARCHAR2(2000):= NULL ;
703: l_result_out VARCHAR2(30) := NULL ;
704: l_return_status VARCHAR2(30) := NULL ;

Line 895: l_header_rec OE_Order_PUB.Header_Rec_Type;

891: IS
892: l_calling_action VARCHAR2(30) := p_calling_action;
893: l_rule_defined VARCHAR2(1);
894: l_epayment VARCHAR2(1);
895: l_header_rec OE_Order_PUB.Header_Rec_Type;
896: l_msg_count NUMBER := 0 ;
897: l_msg_data VARCHAR2(2000):= NULL ;
898: l_result_out VARCHAR2(30) := NULL ;
899: l_return_status VARCHAR2(30) := NULL ;

Line 1922: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type

1918: Checks if the Rule defined by calling action has been setup at
1919: Order Type or not. If setup then returns 'Y' else returns 'N'.
1920: ---------------------------------------------------------------------*/
1921: FUNCTION Check_Rule_Defined
1922: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type
1923: , p_calling_action IN VARCHAR2
1924: ) RETURN VARCHAR2
1925: IS
1926: l_credit_check_rule_id NUMBER ;

Line 2098: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type )

2094: /*-------------------------------------------------------------------
2095: Returns 'Y' if the Order is being paid using a Credit Card
2096: ---------------------------------------------------------------------*/
2097: FUNCTION Is_Electronic_Payment
2098: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type )
2099: RETURN VARCHAR2
2100: IS
2101: --
2102: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 2728: p_header_rec IN OE_Order_PUB.Header_Rec_Type,

2724: /*----------------------------------------------------------------------
2725: Main Procedure called for all Electronic Payment Processing.
2726: ----------------------------------------------------------------------*/
2727: PROCEDURE Payment_Request (
2728: p_header_rec IN OE_Order_PUB.Header_Rec_Type,
2729: p_trxn_type IN VARCHAR2,
2730: p_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
2731: p_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
2732: p_result_out OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 2986: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type

2982: /*----------------------------------------------------------------------
2983: This Procedure returns tangibleid, amount if Voice Auth Needed
2984: ----------------------------------------------------------------------*/
2985: PROCEDURE Voice_Auth_Requested
2986: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type
2987: , p_tangible_id OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2988: , p_amount OUT NOCOPY /* file.sql.39 change */ NUMBER
2989: , p_line_id IN NUMBER DEFAULT NULL)
2990: IS

Line 3105: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type

3101: /*----------------------------------------------------------------------
3102: Calls iPayment's API to authorize a Credit Card Payment for an Order.
3103: ----------------------------------------------------------------------*/
3104: PROCEDURE Authorize_Payment
3105: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type
3106: , p_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
3107: , p_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
3108: , p_result_out OUT NOCOPY /* file.sql.39 change */ VARCHAR2
3109: , p_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 3134: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;

3130: l_payer_county VARCHAR2(60);
3131: l_payer_state VARCHAR2(60);
3132: l_payer_postalcode VARCHAR2(60);
3133: l_payer_country VARCHAR2(60);
3134: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
3135: l_ship_to_address VARCHAR2(10);
3136: l_time_of_purchase VARCHAR2(10);
3137: l_block_str VARCHAR2(5000);
3138: l_risk_threshold NUMBER := 0 ;

Line 3898: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type

3894: 4. Flag to indicate if Reauthorization is required or Not
3895: 5. Flag to indicate if the Current Transaction is Automatic or Manual
3896: ----------------------------------------------------------------------*/
3897: PROCEDURE Check_Reauthorize_Order
3898: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type
3899: , p_void_trxn_id OUT NOCOPY /* file.sql.39 change */ NUMBER
3900: , p_outbound_total OUT NOCOPY /* file.sql.39 change */ NUMBER
3901: , p_reauthorize_out OUT NOCOPY /* file.sql.39 change */ VARCHAR2 )
3902: IS

Line 4091: ( p_header_rec IN OE_Order_Pub.Header_Rec_Type )

4087: /*----------------------------------------------------------------------
4088: Returns TRUE if all the Required Attributes exists else returns FALSE.
4089: ----------------------------------------------------------------------*/
4090: FUNCTION Validate_Required_Attributes
4091: ( p_header_rec IN OE_Order_Pub.Header_Rec_Type )
4092: RETURN BOOLEAN
4093: IS
4094: l_result BOOLEAN := TRUE;
4095: --

Line 4149: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type )

4145: /*----------------------------------------------------------------------
4146: Returns Primary Payment Method for the Customer
4147: ----------------------------------------------------------------------*/
4148: FUNCTION Get_Primary_Pay_Method
4149: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type )
4150: RETURN NUMBER
4151: IS
4152: l_cc_only BOOLEAN := TRUE ;
4153: l_pay_method_id NUMBER := 0;

Line 4555: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type

4551: Returns 'Y' if this authorization was taken through iPayment else 'N'.
4552: Also returns the Transaction ID.
4553: ----------------------------------------------------------------------*/
4554: PROCEDURE Fetch_Authorization_Trxn
4555: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type
4556: , p_trxn_id OUT NOCOPY /* file.sql.39 change */ NUMBER
4557: , p_automatic_auth OUT NOCOPY /* file.sql.39 change */ VARCHAR2 )
4558: IS
4559: l_trxn_id NUMBER;

Line 4628: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type

4624: /*----------------------------------------------------------------------
4625: Fetches the authorization details for the approval code on the Order.
4626: ----------------------------------------------------------------------*/
4627: PROCEDURE Fetch_Current_Auth
4628: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type
4629: , p_line_id IN NUMBER DEFAULT NULL
4630: , p_auth_code IN VARCHAR2 DEFAULT NULL
4631: , p_auth_date IN DATE DEFAULT NULL
4632: , p_trxn_id OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 4810: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type

4806: /*----------------------------------------------------------------------
4807: Fetches the Last Authorization Transaction for the Order
4808: ----------------------------------------------------------------------*/
4809: PROCEDURE Fetch_Last_Auth
4810: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type
4811: , p_trxn_id OUT NOCOPY /* file.sql.39 change */ NUMBER
4812: , p_tangible_id OUT NOCOPY /* file.sql.39 change */ VARCHAR2
4813: , p_auth_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
4814: , p_trxn_date OUT NOCOPY /* file.sql.39 change */ DATE

Line 4934: l_header_rec OE_ORDER_PUB.Header_Rec_Type;

4930: IS
4931: l_index NUMBER := 1;
4932: l_notify_index NUMBER := 1; -- jolin
4933: l_line_id NUMBER;
4934: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
4935: l_old_header_rec OE_ORDER_PUB.Header_Rec_Type;
4936: l_msg_count NUMBER;
4937: l_msg_data VARCHAR2(2000);
4938: l_control_rec OE_GLOBALS.Control_Rec_Type;

Line 4935: l_old_header_rec OE_ORDER_PUB.Header_Rec_Type;

4931: l_index NUMBER := 1;
4932: l_notify_index NUMBER := 1; -- jolin
4933: l_line_id NUMBER;
4934: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
4935: l_old_header_rec OE_ORDER_PUB.Header_Rec_Type;
4936: l_msg_count NUMBER;
4937: l_msg_data VARCHAR2(2000);
4938: l_control_rec OE_GLOBALS.Control_Rec_Type;
4939: l_return_status VARCHAR2(30);

Line 5179: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type

5175:
5176: END Captured_Amount_Total;
5177:
5178: PROCEDURE Authorize_MultiPayments
5179: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type
5180: , p_line_id IN NUMBER DEFAULT null --bug3524209
5181: , p_calling_action IN VARCHAR2
5182: --comm rej, p_reject_on_auth_failure IN VARCHAR2 DEFAULT NULL --R12 CC Encryption
5183: --comm rej, p_reject_on_risk_failure IN VARCHAR2 DEFAULT NULL

Line 5211: l_line_rec OE_Order_PUB.Line_Rec_Type;

5207: l_riskresp_included VARCHAR2(30);
5208: l_risk_score NUMBER := 0 ;
5209: l_result_out VARCHAR2(30) := NULL ;
5210: l_hold_exists VARCHAR2(1);
5211: l_line_rec OE_Order_PUB.Line_Rec_Type;
5212: l_ordered_date DATE;
5213: l_currency_code VARCHAR2(15);
5214: l_line_total NUMBER := 0;
5215: l_order_total NUMBER := 0;

Line 5220: l_payments_tbl OE_ORDER_PUB.Line_Payment_Tbl_Type;

5216:
5217: l_invoice_to_org_id NUMBER;
5218: l_ship_to_org_id NUMBER;
5219: l_line_id NUMBER;
5220: l_payments_tbl OE_ORDER_PUB.Line_Payment_Tbl_Type;
5221: l_count NUMBER;
5222: i PLS_INTEGER;
5223: l_prepaid_total NUMBER;
5224: l_outbound_total NUMBER;

Line 8107: l_Line_Payment_rec OE_ORDER_PUB.Line_Payment_Rec_Type;

8103: IS
8104: l_index NUMBER := 1;
8105: l_notify_index NUMBER := 1;
8106: l_line_id NUMBER;
8107: l_Line_Payment_rec OE_ORDER_PUB.Line_Payment_Rec_Type;
8108: l_old_Line_Payment_rec OE_ORDER_PUB.Line_Payment_Rec_Type;
8109: l_Header_Payment_rec OE_ORDER_PUB.Header_Payment_Rec_Type;
8110: l_old_Header_Payment_rec OE_ORDER_PUB.Header_Payment_Rec_Type;
8111: l_msg_count NUMBER;

Line 8108: l_old_Line_Payment_rec OE_ORDER_PUB.Line_Payment_Rec_Type;

8104: l_index NUMBER := 1;
8105: l_notify_index NUMBER := 1;
8106: l_line_id NUMBER;
8107: l_Line_Payment_rec OE_ORDER_PUB.Line_Payment_Rec_Type;
8108: l_old_Line_Payment_rec OE_ORDER_PUB.Line_Payment_Rec_Type;
8109: l_Header_Payment_rec OE_ORDER_PUB.Header_Payment_Rec_Type;
8110: l_old_Header_Payment_rec OE_ORDER_PUB.Header_Payment_Rec_Type;
8111: l_msg_count NUMBER;
8112: l_msg_data VARCHAR2(2000);

Line 8109: l_Header_Payment_rec OE_ORDER_PUB.Header_Payment_Rec_Type;

8105: l_notify_index NUMBER := 1;
8106: l_line_id NUMBER;
8107: l_Line_Payment_rec OE_ORDER_PUB.Line_Payment_Rec_Type;
8108: l_old_Line_Payment_rec OE_ORDER_PUB.Line_Payment_Rec_Type;
8109: l_Header_Payment_rec OE_ORDER_PUB.Header_Payment_Rec_Type;
8110: l_old_Header_Payment_rec OE_ORDER_PUB.Header_Payment_Rec_Type;
8111: l_msg_count NUMBER;
8112: l_msg_data VARCHAR2(2000);
8113: l_control_rec OE_GLOBALS.Control_Rec_Type;

Line 8110: l_old_Header_Payment_rec OE_ORDER_PUB.Header_Payment_Rec_Type;

8106: l_line_id NUMBER;
8107: l_Line_Payment_rec OE_ORDER_PUB.Line_Payment_Rec_Type;
8108: l_old_Line_Payment_rec OE_ORDER_PUB.Line_Payment_Rec_Type;
8109: l_Header_Payment_rec OE_ORDER_PUB.Header_Payment_Rec_Type;
8110: l_old_Header_Payment_rec OE_ORDER_PUB.Header_Payment_Rec_Type;
8111: l_msg_count NUMBER;
8112: l_msg_data VARCHAR2(2000);
8113: l_control_rec OE_GLOBALS.Control_Rec_Type;
8114: l_return_status VARCHAR2(30);