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_HEADER_PAYMENT_UTIL dependencies on OE_PAYMENT_TRXN_UTIL

Line 2319: OE_PAYMENT_TRXN_UTIL.Delete_Payment_Trxn

2315: oe_debug_pub.add('Deleting trxn id...'||l_pmt.trxn_extension_id);
2316: oe_debug_pub.add('Invoice to org.'||l_invoice_to_org_id);
2317: END IF;
2318:
2319: OE_PAYMENT_TRXN_UTIL.Delete_Payment_Trxn
2320: (p_header_id => p_header_id,
2321: p_line_id => null,
2322: p_payment_number=> null,
2323: P_site_use_id => l_invoice_to_org_id,

Line 2493: OE_PAYMENT_TRXN_UTIL.Delete_Payment_Trxn

2489: oe_debug_pub.add('Deleting trxn id...'||l_trxn_extension_id);
2490: oe_debug_pub.add('Invoice to org.'||l_invoice_to_org_id);
2491: END IF;
2492:
2493: OE_PAYMENT_TRXN_UTIL.Delete_Payment_Trxn
2494: (p_header_id => p_header_id,
2495: p_line_id => null,
2496: p_payment_number=> p_payment_number,
2497: P_site_use_id => l_invoice_to_org_id,

Line 2747: OE_Payment_Trxn_Util.Get_Payment_Trxn_Info(p_header_id => p_header_id,

2743: x_Header_Payment_rec.trxn_extension_id := l_implicit_rec.trxn_extension_id;
2744: --Populating the header payment record by querying the Payments tables
2745: --as they are no longer stored in OM tables
2746: IF l_implicit_rec.trxn_extension_id is not null then
2747: OE_Payment_Trxn_Util.Get_Payment_Trxn_Info(p_header_id => p_header_id,
2748: P_trxn_extension_id => x_Header_Payment_rec.trxn_extension_id,
2749: P_payment_type_code => x_Header_Payment_rec.payment_type_code ,
2750: X_credit_card_number => x_Header_Payment_rec.credit_card_number,
2751: X_credit_card_holder_name => x_Header_Payment_rec.credit_card_holder_name,

Line 2951: OE_Payment_Trxn_Util.Get_Payment_Trxn_Info(p_header_id => p_header_id,

2947: l_Header_Payment_rec.trxn_extension_id := l_implicit_rec.trxn_extension_id;
2948: --Populating the header payment record by querying the Payments tables
2949: --as they are no longer stored in OM tables
2950: IF l_implicit_rec.trxn_extension_id is not null then
2951: OE_Payment_Trxn_Util.Get_Payment_Trxn_Info(p_header_id => p_header_id,
2952: P_trxn_extension_id => l_Header_Payment_rec.trxn_extension_id,
2953: P_payment_type_code => l_Header_Payment_rec.payment_type_code ,
2954: X_credit_card_number => l_Header_Payment_rec.credit_card_number,
2955: X_credit_card_holder_name => l_Header_Payment_rec.credit_card_holder_name,

Line 3483: --is handled in OE_PAYMENT_TRXN_UTIL package. So need to modify this part

3479: oe_debug_pub.add(' old trxn extn id ksurendr'||p_old_header_Payment_rec.trxn_extension_id);
3480: END IF;
3481:
3482: --For payment types like Credit Card, ACH and Direct Debit, the processing
3483: --is handled in OE_PAYMENT_TRXN_UTIL package. So need to modify this part
3484: --to call the appropriate procedures for create, update or copy.
3485: IF p_x_header_Payment_rec.payment_type_code IN ('CREDIT_CARD','ACH','DIRECT_DEBIT') THEN
3486: --Verify
3487:

Line 3528: OE_PAYMENT_TRXN_UTIL.Copy_Payment_TRXN

3524: --R12 CC Encryption
3525: --for orders coming from outside of Order Management, we need to call Oracle
3526: --Payments Copy Transaction API to get a new transaction extension id.
3527: BEGIN
3528: OE_PAYMENT_TRXN_UTIL.Copy_Payment_TRXN
3529: (P_header_id => p_x_header_Payment_rec.header_id,
3530: p_line_id => p_x_header_payment_rec.line_id,
3531: p_cust_id => l_hdr_inv_to_cust_id,
3532: P_site_use_id => l_invoice_to_org_id,

Line 3638: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use IS NULL THEN

3634: END IF;
3635:
3636: -- validate cc security code
3637: IF p_x_Header_Payment_rec.payment_type_code = 'CREDIT_CARD' THEN
3638: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use IS NULL THEN
3639: OE_Payment_Trxn_Util.g_CC_Security_Code_Use := OE_Payment_Trxn_Util.Get_CC_Security_Code_Use;
3640: END IF;
3641:
3642: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use = 'REQUIRED' AND

Line 3639: OE_Payment_Trxn_Util.g_CC_Security_Code_Use := OE_Payment_Trxn_Util.Get_CC_Security_Code_Use;

3635:
3636: -- validate cc security code
3637: IF p_x_Header_Payment_rec.payment_type_code = 'CREDIT_CARD' THEN
3638: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use IS NULL THEN
3639: OE_Payment_Trxn_Util.g_CC_Security_Code_Use := OE_Payment_Trxn_Util.Get_CC_Security_Code_Use;
3640: END IF;
3641:
3642: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use = 'REQUIRED' AND
3643: p_x_Header_Payment_rec.instrument_security_code IS NULL THEN

Line 3642: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use = 'REQUIRED' AND

3638: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use IS NULL THEN
3639: OE_Payment_Trxn_Util.g_CC_Security_Code_Use := OE_Payment_Trxn_Util.Get_CC_Security_Code_Use;
3640: END IF;
3641:
3642: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use = 'REQUIRED' AND
3643: p_x_Header_Payment_rec.instrument_security_code IS NULL THEN
3644: FND_MESSAGE.SET_NAME('ONT','OE_CC_SECURITY_CODE_REQD');
3645: OE_Msg_Pub.Add;
3646: RAISE FND_API.G_EXC_ERROR;

Line 3675: OE_PAYMENT_TRXN_UTIL.Create_Payment_TRXN

3671: p_old_header_Payment_rec.credit_card_expiration_date) THEN
3672: l_update_card_flag := 'Y';
3673: END IF;
3674: Begin
3675: OE_PAYMENT_TRXN_UTIL.Create_Payment_TRXN
3676: (p_header_id => p_x_header_Payment_rec.header_id,
3677: p_line_id => p_x_header_payment_rec.line_id,
3678: p_cust_id => l_hdr_inv_to_cust_id,
3679: P_site_use_id => l_invoice_to_org_id,

Line 3736: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use IS NULL THEN

3732: --extenstion table
3733: BEGIN
3734: -- validate cc security code
3735: /*IF p_x_Header_Payment_rec.payment_type_code = 'CREDIT_CARD' THEN
3736: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use IS NULL THEN
3737: OE_Payment_Trxn_Util.g_CC_Security_Code_Use := OE_Payment_Trxn_Util.Get_CC_Security_Code_Use;
3738: END IF;
3739: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use = 'REQUIRED'
3740: AND p_x_Header_Payment_rec.instrument_security_code IS NULL THEN

Line 3737: OE_Payment_Trxn_Util.g_CC_Security_Code_Use := OE_Payment_Trxn_Util.Get_CC_Security_Code_Use;

3733: BEGIN
3734: -- validate cc security code
3735: /*IF p_x_Header_Payment_rec.payment_type_code = 'CREDIT_CARD' THEN
3736: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use IS NULL THEN
3737: OE_Payment_Trxn_Util.g_CC_Security_Code_Use := OE_Payment_Trxn_Util.Get_CC_Security_Code_Use;
3738: END IF;
3739: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use = 'REQUIRED'
3740: AND p_x_Header_Payment_rec.instrument_security_code IS NULL THEN
3741: FND_MESSAGE.SET_NAME('ONT','OE_CC_SECURITY_CODE_REQD');

Line 3739: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use = 'REQUIRED'

3735: /*IF p_x_Header_Payment_rec.payment_type_code = 'CREDIT_CARD' THEN
3736: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use IS NULL THEN
3737: OE_Payment_Trxn_Util.g_CC_Security_Code_Use := OE_Payment_Trxn_Util.Get_CC_Security_Code_Use;
3738: END IF;
3739: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use = 'REQUIRED'
3740: AND p_x_Header_Payment_rec.instrument_security_code IS NULL THEN
3741: FND_MESSAGE.SET_NAME('ONT','OE_CC_SECURITY_CODE_REQD');
3742: OE_Msg_Pub.Add;
3743: RAISE FND_API.G_EXC_ERROR;

Line 3773: OE_PAYMENT_TRXN_UTIL.Update_Payment_TRXN

3769: l_update_card_flag := 'Y';
3770: END IF;
3771: oe_debug_pub.add('b4 call to update pay...');
3772: oe_debug_pub.add('Payment trx id'||p_x_header_payment_rec.payment_trx_id);
3773: OE_PAYMENT_TRXN_UTIL.Update_Payment_TRXN
3774: (P_header_id => p_x_header_Payment_rec.header_id,
3775: p_line_id => p_x_header_payment_rec.line_id,
3776: p_cust_id => l_hdr_inv_to_cust_id,
3777: P_site_use_id => l_invoice_to_org_id,

Line 3844: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use IS NULL THEN

3840: /*l_trx_date := nvl(l_ordered_date, sysdate)
3841: - nvl( to_number(fnd_profile.value('ONT_DAYS_TO_BACKDATE_BANK_ACCT')), 0);*/
3842: -- validate cc security code
3843: IF p_x_Header_Payment_rec.payment_type_code = 'CREDIT_CARD' THEN
3844: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use IS NULL THEN
3845: OE_Payment_Trxn_Util.g_CC_Security_Code_Use := OE_Payment_Trxn_Util.Get_CC_Security_Code_Use;
3846: END IF;
3847:
3848: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use = 'REQUIRED' AND

Line 3845: OE_Payment_Trxn_Util.g_CC_Security_Code_Use := OE_Payment_Trxn_Util.Get_CC_Security_Code_Use;

3841: - nvl( to_number(fnd_profile.value('ONT_DAYS_TO_BACKDATE_BANK_ACCT')), 0);*/
3842: -- validate cc security code
3843: IF p_x_Header_Payment_rec.payment_type_code = 'CREDIT_CARD' THEN
3844: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use IS NULL THEN
3845: OE_Payment_Trxn_Util.g_CC_Security_Code_Use := OE_Payment_Trxn_Util.Get_CC_Security_Code_Use;
3846: END IF;
3847:
3848: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use = 'REQUIRED' AND
3849: p_x_Header_Payment_rec.instrument_security_code IS NULL THEN

Line 3848: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use = 'REQUIRED' AND

3844: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use IS NULL THEN
3845: OE_Payment_Trxn_Util.g_CC_Security_Code_Use := OE_Payment_Trxn_Util.Get_CC_Security_Code_Use;
3846: END IF;
3847:
3848: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use = 'REQUIRED' AND
3849: p_x_Header_Payment_rec.instrument_security_code IS NULL THEN
3850: FND_MESSAGE.SET_NAME('ONT','OE_CC_SECURITY_CODE_REQD');
3851: OE_Msg_Pub.Add;
3852: RAISE FND_API.G_EXC_ERROR;

Line 3902: OE_PAYMENT_TRXN_UTIL.Create_Payment_TRXN

3898: Begin
3899: IF l_debug_level > 0 THEN
3900: oe_debug_pub.add('Before calling create_payment_trxn API');
3901: END IF;
3902: OE_PAYMENT_TRXN_UTIL.Create_Payment_TRXN
3903: (p_header_id => p_x_header_Payment_rec.header_id,
3904: p_line_id => p_x_header_payment_rec.line_id,
3905: p_cust_id => l_hdr_inv_to_cust_id,
3906: P_site_use_id => l_invoice_to_org_id,

Line 3975: OE_PAYMENT_TRXN_UTIL.Delete_Payment_Trxn

3971: END IF;
3972: --Passing the invoice to org id as null as in case of
3973: --deleting payments due to bill to change, we would need the
3974: --old invoice to org id.
3975: OE_PAYMENT_TRXN_UTIL.Delete_Payment_Trxn
3976: (p_header_id => p_x_header_Payment_rec.header_id,
3977: p_line_id => p_x_header_Payment_rec.line_id,
3978: p_payment_number => p_x_header_Payment_rec.payment_number,
3979: x_return_status => l_return_status,