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

Line 2292: OE_PAYMENT_TRXN_UTIL.Delete_Payment_Trxn

2288: oe_debug_pub.add('Deleting trxn id...'||l_trxn_extension_id);
2289: oe_debug_pub.add('Invoice to org.'||l_invoice_to_org_id);
2290: END IF;
2291:
2292: OE_PAYMENT_TRXN_UTIL.Delete_Payment_Trxn
2293: (p_header_id => p_header_id,
2294: p_line_id => p_line_id,
2295: p_payment_number=> l_pmt.payment_number,
2296: P_site_use_id => l_invoice_to_org_id,

Line 2521: OE_PAYMENT_TRXN_UTIL.Delete_Payment_Trxn

2517: oe_debug_pub.add('Deleting trxn id...'||l_trxn_extension_id);
2518: oe_debug_pub.add('Invoice to org.'||l_invoice_to_org_id);
2519: END IF;
2520:
2521: OE_PAYMENT_TRXN_UTIL.Delete_Payment_Trxn
2522: (p_header_id => p_header_id,
2523: p_line_id => p_line_id,
2524: p_payment_number=> p_payment_number,
2525: P_site_use_id => l_invoice_to_org_id,

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

2763: x_Line_Payment_rec.trxn_extension_id := l_implicit_rec.trxn_extension_id;
2764: --Populating the header payment record by querying the Payments tables
2765: --as they are no longer stored in OM tables
2766: IF l_implicit_rec.trxn_extension_id is not null then
2767: OE_Payment_Trxn_Util.Get_Payment_Trxn_Info(p_header_id => p_header_id,
2768: P_trxn_extension_id => x_Line_Payment_rec.trxn_extension_id,
2769: P_payment_type_code => x_Line_Payment_rec.payment_type_code ,
2770: X_credit_card_number => x_Line_Payment_rec.credit_card_number,
2771: X_credit_card_holder_name => x_Line_Payment_rec.credit_card_holder_name,

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

2970: l_Line_Payment_rec.trxn_extension_id := l_implicit_rec.trxn_extension_id;
2971: --Populating the header payment record by querying the Payments tables
2972: --as they are no longer stored in OM tables
2973: IF l_implicit_rec.trxn_extension_id is not null then
2974: OE_Payment_Trxn_Util.Get_Payment_Trxn_Info(p_header_id => p_header_id,
2975: P_trxn_extension_id => l_Line_Payment_rec.trxn_extension_id,
2976: P_payment_type_code => l_Line_Payment_rec.payment_type_code ,
2977: X_credit_card_number => l_Line_Payment_rec.credit_card_number,
2978: X_credit_card_holder_name => l_Line_Payment_rec.credit_card_holder_name,

Line 3682: OE_PAYMENT_TRXN_UTIL.Copy_Payment_TRXN

3678: --For orders coming from outside of Order Management through Process Order API,
3679: --we need to call Oracle Payments Copy Transaction API to get a new transaction
3680: --extension id
3681: BEGIN
3682: OE_PAYMENT_TRXN_UTIL.Copy_Payment_TRXN
3683: (P_header_id => p_x_line_Payment_rec.header_id,
3684: P_line_id => p_x_line_payment_rec.line_id,
3685: p_cust_id => l_hdr_inv_to_cust_id,
3686: P_site_use_id => l_invoice_to_org_id,

Line 3745: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use IS NULL THEN

3741: -- 5204275
3742: OR (l_is_split_payment = 'Y'
3743: AND p_x_line_Payment_rec.payment_type_code IS NULL)
3744: THEN
3745: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use IS NULL THEN
3746: OE_Payment_Trxn_Util.g_CC_Security_Code_Use := OE_Payment_Trxn_Util.Get_CC_Security_Code_Use;
3747: END IF;
3748:
3749: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use = 'REQUIRED' AND

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

3742: OR (l_is_split_payment = 'Y'
3743: AND p_x_line_Payment_rec.payment_type_code IS NULL)
3744: THEN
3745: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use IS NULL THEN
3746: OE_Payment_Trxn_Util.g_CC_Security_Code_Use := OE_Payment_Trxn_Util.Get_CC_Security_Code_Use;
3747: END IF;
3748:
3749: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use = 'REQUIRED' AND
3750: p_x_line_Payment_rec.instrument_security_code IS NULL THEN

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

3745: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use IS NULL THEN
3746: OE_Payment_Trxn_Util.g_CC_Security_Code_Use := OE_Payment_Trxn_Util.Get_CC_Security_Code_Use;
3747: END IF;
3748:
3749: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use = 'REQUIRED' AND
3750: p_x_line_Payment_rec.instrument_security_code IS NULL THEN
3751: FND_MESSAGE.SET_NAME('ONT','OE_CC_SECURITY_CODE_REQD');
3752: OE_Msg_Pub.Add;
3753: RAISE FND_API.G_EXC_ERROR;

Line 3784: OE_PAYMENT_TRXN_UTIL.Create_Payment_TRXN

3780: oe_debug_pub.add('Update card flag..'||l_update_card_flag);
3781: END IF;
3782:
3783: BEGIN
3784: OE_PAYMENT_TRXN_UTIL.Create_Payment_TRXN
3785: (p_header_id => p_x_line_Payment_rec.header_id,
3786: p_line_id => p_x_line_payment_rec.line_id,
3787: p_cust_id => l_hdr_inv_to_cust_id,
3788: P_site_use_id => l_invoice_to_org_id,

Line 3840: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use IS NULL THEN

3836: BEGIN
3837:
3838: -- validate cc security code
3839: /*IF p_x_line_Payment_rec.payment_type_code = 'CREDIT_CARD' THEN
3840: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use IS NULL THEN
3841: OE_Payment_Trxn_Util.g_CC_Security_Code_Use := OE_Payment_Trxn_Util.Get_CC_Security_Code_Use;
3842: END IF;
3843: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use = 'REQUIRED'
3844: AND p_x_line_Payment_rec.instrument_security_code IS NULL THEN

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

3837:
3838: -- validate cc security code
3839: /*IF p_x_line_Payment_rec.payment_type_code = 'CREDIT_CARD' THEN
3840: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use IS NULL THEN
3841: OE_Payment_Trxn_Util.g_CC_Security_Code_Use := OE_Payment_Trxn_Util.Get_CC_Security_Code_Use;
3842: END IF;
3843: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use = 'REQUIRED'
3844: AND p_x_line_Payment_rec.instrument_security_code IS NULL THEN
3845: FND_MESSAGE.SET_NAME('ONT','OE_CC_SECURITY_CODE_REQD');

Line 3843: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use = 'REQUIRED'

3839: /*IF p_x_line_Payment_rec.payment_type_code = 'CREDIT_CARD' THEN
3840: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use IS NULL THEN
3841: OE_Payment_Trxn_Util.g_CC_Security_Code_Use := OE_Payment_Trxn_Util.Get_CC_Security_Code_Use;
3842: END IF;
3843: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use = 'REQUIRED'
3844: AND p_x_line_Payment_rec.instrument_security_code IS NULL THEN
3845: FND_MESSAGE.SET_NAME('ONT','OE_CC_SECURITY_CODE_REQD');
3846: OE_Msg_Pub.Add;
3847: RAISE FND_API.G_EXC_ERROR;

Line 3885: OE_PAYMENT_TRXN_UTIL.Update_Payment_TRXN

3881: END IF;
3882:
3883: -- 3884: --extenstion table>
3885: OE_PAYMENT_TRXN_UTIL.Update_Payment_TRXN
3886: (P_header_id => p_x_line_Payment_rec.header_id,
3887: p_line_id => p_x_line_Payment_rec.line_id,
3888: p_cust_id => l_hdr_inv_to_cust_id,
3889: P_site_use_id => l_invoice_to_org_id,

Line 3946: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use IS NULL THEN

3942:
3943: /*l_trx_date := nvl(l_ordered_date, sysdate)
3944: - nvl( to_number(fnd_profile.value('ONT_DAYS_TO_BACKDATE_BANK_ACCT')), 0);*/
3945: IF p_x_line_Payment_rec.payment_type_code = 'CREDIT_CARD' THEN
3946: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use IS NULL THEN
3947: OE_Payment_Trxn_Util.g_CC_Security_Code_Use := OE_Payment_Trxn_Util.Get_CC_Security_Code_Use;
3948: END IF;
3949:
3950: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use = 'REQUIRED' AND

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

3943: /*l_trx_date := nvl(l_ordered_date, sysdate)
3944: - nvl( to_number(fnd_profile.value('ONT_DAYS_TO_BACKDATE_BANK_ACCT')), 0);*/
3945: IF p_x_line_Payment_rec.payment_type_code = 'CREDIT_CARD' THEN
3946: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use IS NULL THEN
3947: OE_Payment_Trxn_Util.g_CC_Security_Code_Use := OE_Payment_Trxn_Util.Get_CC_Security_Code_Use;
3948: END IF;
3949:
3950: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use = 'REQUIRED' AND
3951: p_x_line_Payment_rec.instrument_security_code IS NULL THEN

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

3946: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use IS NULL THEN
3947: OE_Payment_Trxn_Util.g_CC_Security_Code_Use := OE_Payment_Trxn_Util.Get_CC_Security_Code_Use;
3948: END IF;
3949:
3950: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use = 'REQUIRED' AND
3951: p_x_line_Payment_rec.instrument_security_code IS NULL THEN
3952: FND_MESSAGE.SET_NAME('ONT','OE_CC_SECURITY_CODE_REQD');
3953: OE_Msg_Pub.Add;
3954: RAISE FND_API.G_EXC_ERROR;

Line 3988: OE_PAYMENT_TRXN_UTIL.Create_Payment_TRXN

3984: --Begin
3985: --IF p_x_line_payment_rec.trxn_extension_id IS NULL THEN
3986:
3987: BEGIN
3988: OE_PAYMENT_TRXN_UTIL.Create_Payment_TRXN
3989: (p_header_id => p_x_line_Payment_rec.header_id,
3990: p_line_id => p_x_line_payment_rec.line_id,
3991: p_cust_id => l_hdr_inv_to_cust_id,
3992: P_site_use_id => l_invoice_to_org_id,

Line 4050: OE_PAYMENT_TRXN_UTIL.Delete_Payment_Trxn

4046: oe_debug_pub.add(' Trxn extension to delete'||p_old_line_Payment_rec.trxn_extension_id);
4047: oe_debug_pub.add(' Header id '||p_x_line_payment_rec.line_id);
4048: END IF;
4049:
4050: OE_PAYMENT_TRXN_UTIL.Delete_Payment_Trxn
4051: (p_header_id => p_x_line_payment_rec.header_id,
4052: p_line_id => p_x_line_payment_rec.line_id,
4053: p_payment_number => p_x_line_payment_rec.payment_number,
4054: x_return_status => l_return_status,