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 2214: OE_PAYMENT_TRXN_UTIL.Delete_Payment_Trxn

2210: oe_debug_pub.add('Deleting trxn id...'||l_trxn_extension_id);
2211: oe_debug_pub.add('Invoice to org.'||l_invoice_to_org_id);
2212: END IF;
2213:
2214: OE_PAYMENT_TRXN_UTIL.Delete_Payment_Trxn
2215: (p_header_id => p_header_id,
2216: p_line_id => p_line_id,
2217: p_payment_number=> l_pmt.payment_number,
2218: P_site_use_id => l_invoice_to_org_id,

Line 2443: OE_PAYMENT_TRXN_UTIL.Delete_Payment_Trxn

2439: oe_debug_pub.add('Deleting trxn id...'||l_trxn_extension_id);
2440: oe_debug_pub.add('Invoice to org.'||l_invoice_to_org_id);
2441: END IF;
2442:
2443: OE_PAYMENT_TRXN_UTIL.Delete_Payment_Trxn
2444: (p_header_id => p_header_id,
2445: p_line_id => p_line_id,
2446: p_payment_number=> p_payment_number,
2447: P_site_use_id => l_invoice_to_org_id,

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

2685: x_Line_Payment_rec.trxn_extension_id := l_implicit_rec.trxn_extension_id;
2686: --Populating the header payment record by querying the Payments tables
2687: --as they are no longer stored in OM tables
2688: IF l_implicit_rec.trxn_extension_id is not null then
2689: OE_Payment_Trxn_Util.Get_Payment_Trxn_Info(p_header_id => p_header_id,
2690: P_trxn_extension_id => x_Line_Payment_rec.trxn_extension_id,
2691: P_payment_type_code => x_Line_Payment_rec.payment_type_code ,
2692: X_credit_card_number => x_Line_Payment_rec.credit_card_number,
2693: X_credit_card_holder_name => x_Line_Payment_rec.credit_card_holder_name,

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

2892: l_Line_Payment_rec.trxn_extension_id := l_implicit_rec.trxn_extension_id;
2893: --Populating the header payment record by querying the Payments tables
2894: --as they are no longer stored in OM tables
2895: IF l_implicit_rec.trxn_extension_id is not null then
2896: OE_Payment_Trxn_Util.Get_Payment_Trxn_Info(p_header_id => p_header_id,
2897: P_trxn_extension_id => l_Line_Payment_rec.trxn_extension_id,
2898: P_payment_type_code => l_Line_Payment_rec.payment_type_code ,
2899: X_credit_card_number => l_Line_Payment_rec.credit_card_number,
2900: X_credit_card_holder_name => l_Line_Payment_rec.credit_card_holder_name,

Line 3604: OE_PAYMENT_TRXN_UTIL.Copy_Payment_TRXN

3600: --For orders coming from outside of Order Management through Process Order API,
3601: --we need to call Oracle Payments Copy Transaction API to get a new transaction
3602: --extension id
3603: BEGIN
3604: OE_PAYMENT_TRXN_UTIL.Copy_Payment_TRXN
3605: (P_header_id => p_x_line_Payment_rec.header_id,
3606: P_line_id => p_x_line_payment_rec.line_id,
3607: p_cust_id => l_hdr_inv_to_cust_id,
3608: P_site_use_id => l_invoice_to_org_id,

Line 3667: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use IS NULL THEN

3663: -- 5204275
3664: OR (l_is_split_payment = 'Y'
3665: AND p_x_line_Payment_rec.payment_type_code IS NULL)
3666: THEN
3667: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use IS NULL THEN
3668: OE_Payment_Trxn_Util.g_CC_Security_Code_Use := OE_Payment_Trxn_Util.Get_CC_Security_Code_Use;
3669: END IF;
3670:
3671: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use = 'REQUIRED' AND

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

3664: OR (l_is_split_payment = 'Y'
3665: AND p_x_line_Payment_rec.payment_type_code IS NULL)
3666: THEN
3667: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use IS NULL THEN
3668: OE_Payment_Trxn_Util.g_CC_Security_Code_Use := OE_Payment_Trxn_Util.Get_CC_Security_Code_Use;
3669: END IF;
3670:
3671: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use = 'REQUIRED' AND
3672: p_x_line_Payment_rec.instrument_security_code IS NULL THEN

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

3667: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use IS NULL THEN
3668: OE_Payment_Trxn_Util.g_CC_Security_Code_Use := OE_Payment_Trxn_Util.Get_CC_Security_Code_Use;
3669: END IF;
3670:
3671: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use = 'REQUIRED' AND
3672: p_x_line_Payment_rec.instrument_security_code IS NULL THEN
3673: FND_MESSAGE.SET_NAME('ONT','OE_CC_SECURITY_CODE_REQD');
3674: OE_Msg_Pub.Add;
3675: RAISE FND_API.G_EXC_ERROR;

Line 3706: OE_PAYMENT_TRXN_UTIL.Create_Payment_TRXN

3702: oe_debug_pub.add('Update card flag..'||l_update_card_flag);
3703: END IF;
3704:
3705: BEGIN
3706: OE_PAYMENT_TRXN_UTIL.Create_Payment_TRXN
3707: (p_header_id => p_x_line_Payment_rec.header_id,
3708: p_line_id => p_x_line_payment_rec.line_id,
3709: p_cust_id => l_hdr_inv_to_cust_id,
3710: P_site_use_id => l_invoice_to_org_id,

Line 3762: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use IS NULL THEN

3758: BEGIN
3759:
3760: -- validate cc security code
3761: /*IF p_x_line_Payment_rec.payment_type_code = 'CREDIT_CARD' THEN
3762: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use IS NULL THEN
3763: OE_Payment_Trxn_Util.g_CC_Security_Code_Use := OE_Payment_Trxn_Util.Get_CC_Security_Code_Use;
3764: END IF;
3765: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use = 'REQUIRED'
3766: AND p_x_line_Payment_rec.instrument_security_code IS NULL THEN

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

3759:
3760: -- validate cc security code
3761: /*IF p_x_line_Payment_rec.payment_type_code = 'CREDIT_CARD' THEN
3762: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use IS NULL THEN
3763: OE_Payment_Trxn_Util.g_CC_Security_Code_Use := OE_Payment_Trxn_Util.Get_CC_Security_Code_Use;
3764: END IF;
3765: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use = 'REQUIRED'
3766: AND p_x_line_Payment_rec.instrument_security_code IS NULL THEN
3767: FND_MESSAGE.SET_NAME('ONT','OE_CC_SECURITY_CODE_REQD');

Line 3765: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use = 'REQUIRED'

3761: /*IF p_x_line_Payment_rec.payment_type_code = 'CREDIT_CARD' THEN
3762: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use IS NULL THEN
3763: OE_Payment_Trxn_Util.g_CC_Security_Code_Use := OE_Payment_Trxn_Util.Get_CC_Security_Code_Use;
3764: END IF;
3765: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use = 'REQUIRED'
3766: AND p_x_line_Payment_rec.instrument_security_code IS NULL THEN
3767: FND_MESSAGE.SET_NAME('ONT','OE_CC_SECURITY_CODE_REQD');
3768: OE_Msg_Pub.Add;
3769: RAISE FND_API.G_EXC_ERROR;

Line 3807: OE_PAYMENT_TRXN_UTIL.Update_Payment_TRXN

3803: END IF;
3804:
3805: -- 3806: --extenstion table>
3807: OE_PAYMENT_TRXN_UTIL.Update_Payment_TRXN
3808: (P_header_id => p_x_line_Payment_rec.header_id,
3809: p_line_id => p_x_line_Payment_rec.line_id,
3810: p_cust_id => l_hdr_inv_to_cust_id,
3811: P_site_use_id => l_invoice_to_org_id,

Line 3868: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use IS NULL THEN

3864:
3865: /*l_trx_date := nvl(l_ordered_date, sysdate)
3866: - nvl( to_number(fnd_profile.value('ONT_DAYS_TO_BACKDATE_BANK_ACCT')), 0);*/
3867: IF p_x_line_Payment_rec.payment_type_code = 'CREDIT_CARD' THEN
3868: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use IS NULL THEN
3869: OE_Payment_Trxn_Util.g_CC_Security_Code_Use := OE_Payment_Trxn_Util.Get_CC_Security_Code_Use;
3870: END IF;
3871:
3872: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use = 'REQUIRED' AND

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

3865: /*l_trx_date := nvl(l_ordered_date, sysdate)
3866: - nvl( to_number(fnd_profile.value('ONT_DAYS_TO_BACKDATE_BANK_ACCT')), 0);*/
3867: IF p_x_line_Payment_rec.payment_type_code = 'CREDIT_CARD' THEN
3868: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use IS NULL THEN
3869: OE_Payment_Trxn_Util.g_CC_Security_Code_Use := OE_Payment_Trxn_Util.Get_CC_Security_Code_Use;
3870: END IF;
3871:
3872: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use = 'REQUIRED' AND
3873: p_x_line_Payment_rec.instrument_security_code IS NULL THEN

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

3868: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use IS NULL THEN
3869: OE_Payment_Trxn_Util.g_CC_Security_Code_Use := OE_Payment_Trxn_Util.Get_CC_Security_Code_Use;
3870: END IF;
3871:
3872: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use = 'REQUIRED' AND
3873: p_x_line_Payment_rec.instrument_security_code IS NULL THEN
3874: FND_MESSAGE.SET_NAME('ONT','OE_CC_SECURITY_CODE_REQD');
3875: OE_Msg_Pub.Add;
3876: RAISE FND_API.G_EXC_ERROR;

Line 3910: OE_PAYMENT_TRXN_UTIL.Create_Payment_TRXN

3906: --Begin
3907: --IF p_x_line_payment_rec.trxn_extension_id IS NULL THEN
3908:
3909: BEGIN
3910: OE_PAYMENT_TRXN_UTIL.Create_Payment_TRXN
3911: (p_header_id => p_x_line_Payment_rec.header_id,
3912: p_line_id => p_x_line_payment_rec.line_id,
3913: p_cust_id => l_hdr_inv_to_cust_id,
3914: P_site_use_id => l_invoice_to_org_id,

Line 3972: OE_PAYMENT_TRXN_UTIL.Delete_Payment_Trxn

3968: oe_debug_pub.add(' Trxn extension to delete'||p_old_line_Payment_rec.trxn_extension_id);
3969: oe_debug_pub.add(' Header id '||p_x_line_payment_rec.line_id);
3970: END IF;
3971:
3972: OE_PAYMENT_TRXN_UTIL.Delete_Payment_Trxn
3973: (p_header_id => p_x_line_payment_rec.header_id,
3974: p_line_id => p_x_line_payment_rec.line_id,
3975: p_payment_number => p_x_line_payment_rec.payment_number,
3976: x_return_status => l_return_status,