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

2401: oe_debug_pub.add('Deleting trxn id...'||l_pmt.trxn_extension_id);
2402: oe_debug_pub.add('Invoice to org.'||l_invoice_to_org_id);
2403: END IF;
2404:
2405: OE_PAYMENT_TRXN_UTIL.Delete_Payment_Trxn
2406: (p_header_id => p_header_id,
2407: p_line_id => null,
2408: p_payment_number=> null,
2409: P_site_use_id => l_invoice_to_org_id,

Line 2579: OE_PAYMENT_TRXN_UTIL.Delete_Payment_Trxn

2575: oe_debug_pub.add('Deleting trxn id...'||l_trxn_extension_id);
2576: oe_debug_pub.add('Invoice to org.'||l_invoice_to_org_id);
2577: END IF;
2578:
2579: OE_PAYMENT_TRXN_UTIL.Delete_Payment_Trxn
2580: (p_header_id => p_header_id,
2581: p_line_id => null,
2582: p_payment_number=> p_payment_number,
2583: P_site_use_id => l_invoice_to_org_id,

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

2831: x_Header_Payment_rec.trxn_extension_id := l_implicit_rec.trxn_extension_id;
2832: --Populating the header payment record by querying the Payments tables
2833: --as they are no longer stored in OM tables
2834: IF l_implicit_rec.trxn_extension_id is not null then
2835: OE_Payment_Trxn_Util.Get_Payment_Trxn_Info(p_header_id => p_header_id,
2836: P_trxn_extension_id => x_Header_Payment_rec.trxn_extension_id,
2837: P_payment_type_code => x_Header_Payment_rec.payment_type_code ,
2838: X_credit_card_number => x_Header_Payment_rec.credit_card_number,
2839: X_credit_card_holder_name => x_Header_Payment_rec.credit_card_holder_name,

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

3037: l_Header_Payment_rec.trxn_extension_id := l_implicit_rec.trxn_extension_id;
3038: --Populating the header payment record by querying the Payments tables
3039: --as they are no longer stored in OM tables
3040: IF l_implicit_rec.trxn_extension_id is not null then
3041: OE_Payment_Trxn_Util.Get_Payment_Trxn_Info(p_header_id => p_header_id,
3042: P_trxn_extension_id => l_Header_Payment_rec.trxn_extension_id,
3043: P_payment_type_code => l_Header_Payment_rec.payment_type_code ,
3044: X_credit_card_number => l_Header_Payment_rec.credit_card_number,
3045: X_credit_card_holder_name => l_Header_Payment_rec.credit_card_holder_name,

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

3598: oe_debug_pub.add(' old trxn extn id ksurendr'||p_old_header_Payment_rec.trxn_extension_id);
3599: END IF;
3600:
3601: --For payment types like Credit Card, ACH and Direct Debit, the processing
3602: --is handled in OE_PAYMENT_TRXN_UTIL package. So need to modify this part
3603: --to call the appropriate procedures for create, update or copy.
3604: IF p_x_header_Payment_rec.payment_type_code IN ('CREDIT_CARD','ACH','DIRECT_DEBIT') THEN
3605: --Verify
3606:

Line 3647: OE_PAYMENT_TRXN_UTIL.Copy_Payment_TRXN

3643: --R12 CC Encryption
3644: --for orders coming from outside of Order Management, we need to call Oracle
3645: --Payments Copy Transaction API to get a new transaction extension id.
3646: BEGIN
3647: OE_PAYMENT_TRXN_UTIL.Copy_Payment_TRXN
3648: (P_header_id => p_x_header_Payment_rec.header_id,
3649: p_line_id => p_x_header_payment_rec.line_id,
3650: p_cust_id => l_hdr_inv_to_cust_id,
3651: P_site_use_id => l_invoice_to_org_id,

Line 3759: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use IS NULL THEN

3755: END IF;
3756:
3757: -- validate cc security code
3758: IF p_x_Header_Payment_rec.payment_type_code = 'CREDIT_CARD' THEN
3759: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use IS NULL THEN
3760: OE_Payment_Trxn_Util.g_CC_Security_Code_Use := OE_Payment_Trxn_Util.Get_CC_Security_Code_Use;
3761: END IF;
3762:
3763: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use = 'REQUIRED' AND

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

3756:
3757: -- validate cc security code
3758: IF p_x_Header_Payment_rec.payment_type_code = 'CREDIT_CARD' THEN
3759: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use IS NULL THEN
3760: OE_Payment_Trxn_Util.g_CC_Security_Code_Use := OE_Payment_Trxn_Util.Get_CC_Security_Code_Use;
3761: END IF;
3762:
3763: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use = 'REQUIRED' AND
3764: p_x_Header_Payment_rec.instrument_security_code IS NULL THEN

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

3759: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use IS NULL THEN
3760: OE_Payment_Trxn_Util.g_CC_Security_Code_Use := OE_Payment_Trxn_Util.Get_CC_Security_Code_Use;
3761: END IF;
3762:
3763: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use = 'REQUIRED' AND
3764: p_x_Header_Payment_rec.instrument_security_code IS NULL THEN
3765: FND_MESSAGE.SET_NAME('ONT','OE_CC_SECURITY_CODE_REQD');
3766: OE_Msg_Pub.Add;
3767: RAISE FND_API.G_EXC_ERROR;

Line 3796: OE_PAYMENT_TRXN_UTIL.Create_Payment_TRXN

3792: p_old_header_Payment_rec.credit_card_expiration_date) THEN
3793: l_update_card_flag := 'Y';
3794: END IF;
3795: Begin
3796: OE_PAYMENT_TRXN_UTIL.Create_Payment_TRXN
3797: (p_header_id => p_x_header_Payment_rec.header_id,
3798: p_line_id => p_x_header_payment_rec.line_id,
3799: p_cust_id => l_hdr_inv_to_cust_id,
3800: P_site_use_id => l_invoice_to_org_id,

Line 3857: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use IS NULL THEN

3853: --extenstion table
3854: BEGIN
3855: -- validate cc security code
3856: /*IF p_x_Header_Payment_rec.payment_type_code = 'CREDIT_CARD' THEN
3857: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use IS NULL THEN
3858: OE_Payment_Trxn_Util.g_CC_Security_Code_Use := OE_Payment_Trxn_Util.Get_CC_Security_Code_Use;
3859: END IF;
3860: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use = 'REQUIRED'
3861: AND p_x_Header_Payment_rec.instrument_security_code IS NULL THEN

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

3854: BEGIN
3855: -- validate cc security code
3856: /*IF p_x_Header_Payment_rec.payment_type_code = 'CREDIT_CARD' THEN
3857: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use IS NULL THEN
3858: OE_Payment_Trxn_Util.g_CC_Security_Code_Use := OE_Payment_Trxn_Util.Get_CC_Security_Code_Use;
3859: END IF;
3860: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use = 'REQUIRED'
3861: AND p_x_Header_Payment_rec.instrument_security_code IS NULL THEN
3862: FND_MESSAGE.SET_NAME('ONT','OE_CC_SECURITY_CODE_REQD');

Line 3860: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use = 'REQUIRED'

3856: /*IF p_x_Header_Payment_rec.payment_type_code = 'CREDIT_CARD' THEN
3857: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use IS NULL THEN
3858: OE_Payment_Trxn_Util.g_CC_Security_Code_Use := OE_Payment_Trxn_Util.Get_CC_Security_Code_Use;
3859: END IF;
3860: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use = 'REQUIRED'
3861: AND p_x_Header_Payment_rec.instrument_security_code IS NULL THEN
3862: FND_MESSAGE.SET_NAME('ONT','OE_CC_SECURITY_CODE_REQD');
3863: OE_Msg_Pub.Add;
3864: RAISE FND_API.G_EXC_ERROR;

Line 3894: OE_PAYMENT_TRXN_UTIL.Update_Payment_TRXN

3890: l_update_card_flag := 'Y';
3891: END IF;
3892: oe_debug_pub.add('b4 call to update pay...');
3893: oe_debug_pub.add('Payment trx id'||p_x_header_payment_rec.payment_trx_id);
3894: OE_PAYMENT_TRXN_UTIL.Update_Payment_TRXN
3895: (P_header_id => p_x_header_Payment_rec.header_id,
3896: p_line_id => p_x_header_payment_rec.line_id,
3897: p_cust_id => l_hdr_inv_to_cust_id,
3898: P_site_use_id => l_invoice_to_org_id,

Line 3965: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use IS NULL THEN

3961: /*l_trx_date := nvl(l_ordered_date, sysdate)
3962: - nvl( to_number(fnd_profile.value('ONT_DAYS_TO_BACKDATE_BANK_ACCT')), 0);*/
3963: -- validate cc security code
3964: IF p_x_Header_Payment_rec.payment_type_code = 'CREDIT_CARD' THEN
3965: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use IS NULL THEN
3966: OE_Payment_Trxn_Util.g_CC_Security_Code_Use := OE_Payment_Trxn_Util.Get_CC_Security_Code_Use;
3967: END IF;
3968:
3969: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use = 'REQUIRED' AND

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

3962: - nvl( to_number(fnd_profile.value('ONT_DAYS_TO_BACKDATE_BANK_ACCT')), 0);*/
3963: -- validate cc security code
3964: IF p_x_Header_Payment_rec.payment_type_code = 'CREDIT_CARD' THEN
3965: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use IS NULL THEN
3966: OE_Payment_Trxn_Util.g_CC_Security_Code_Use := OE_Payment_Trxn_Util.Get_CC_Security_Code_Use;
3967: END IF;
3968:
3969: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use = 'REQUIRED' AND
3970: p_x_Header_Payment_rec.instrument_security_code IS NULL THEN

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

3965: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use IS NULL THEN
3966: OE_Payment_Trxn_Util.g_CC_Security_Code_Use := OE_Payment_Trxn_Util.Get_CC_Security_Code_Use;
3967: END IF;
3968:
3969: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use = 'REQUIRED' AND
3970: p_x_Header_Payment_rec.instrument_security_code IS NULL THEN
3971: FND_MESSAGE.SET_NAME('ONT','OE_CC_SECURITY_CODE_REQD');
3972: OE_Msg_Pub.Add;
3973: RAISE FND_API.G_EXC_ERROR;

Line 4023: OE_PAYMENT_TRXN_UTIL.Create_Payment_TRXN

4019: Begin
4020: IF l_debug_level > 0 THEN
4021: oe_debug_pub.add('Before calling create_payment_trxn API');
4022: END IF;
4023: OE_PAYMENT_TRXN_UTIL.Create_Payment_TRXN
4024: (p_header_id => p_x_header_Payment_rec.header_id,
4025: p_line_id => p_x_header_payment_rec.line_id,
4026: p_cust_id => l_hdr_inv_to_cust_id,
4027: P_site_use_id => l_invoice_to_org_id,

Line 4096: OE_PAYMENT_TRXN_UTIL.Delete_Payment_Trxn

4092: END IF;
4093: --Passing the invoice to org id as null as in case of
4094: --deleting payments due to bill to change, we would need the
4095: --old invoice to org id.
4096: OE_PAYMENT_TRXN_UTIL.Delete_Payment_Trxn
4097: (p_header_id => p_x_header_Payment_rec.header_id,
4098: p_line_id => p_x_header_Payment_rec.line_id,
4099: p_payment_number => p_x_header_Payment_rec.payment_number,
4100: x_return_status => l_return_status,