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_ORDER_COPY_UTIL dependencies on OE_PAYMENTS

Line 596: --oe_payments already to avoid duplicate records while copying an

592: --x_header_rec.check_number := FND_API.G_MISS_CHAR; --Verify
593:
594: --Before populating the header rec, have to make sure that the
595: --payment record corresponding to this order is not present in
596: --oe_payments already to avoid duplicate records while copying an
597: --order from 11510 non migrated order.
598: BEGIN
599: SELECT 'Y'
600: INTO l_payment_exists

Line 601: FROM oe_payments

597: --order from 11510 non migrated order.
598: BEGIN
599: SELECT 'Y'
600: INTO l_payment_exists
601: FROM oe_payments
602: WHERE header_id = p_header_id
603: AND line_id is null -- bug 5167945
604: AND PAYMENT_COLLECTION_EVENT = 'INVOICE';
605: EXCEPTION

Line 3478: --To insert the transaction extension id in the oe_payments table

3474: NULL;
3475:
3476: END delete_config;
3477:
3478: --To insert the transaction extension id in the oe_payments table
3479: --after the credit card details have been stored in the payments tables.
3480: --R12 CC Encryption
3481: /*Procedure Create_Payment(p_header_id IN NUMBER) IS
3482: BEGIN

Line 3483: INSERT INTO oe_payments

3479: --after the credit card details have been stored in the payments tables.
3480: --R12 CC Encryption
3481: /*Procedure Create_Payment(p_header_id IN NUMBER) IS
3482: BEGIN
3483: INSERT INTO oe_payments
3484: (trxn_extension_id,
3485: payment_level_code,
3486: header_id,
3487: line_id,

Line 3926: FROM oe_payments

3922:
3923: begin
3924: SELECT 'Y'
3925: INTO l_exists
3926: FROM oe_payments
3927: Where header_id = l_header_id;
3928: --0and trxn_extension_id is not null; --Verify
3929: exception
3930: when no_data_found then

Line 3932: oe_debug_pub.add('no data found while querying oe_payments in copy_order..'||sqlerrm);

3928: --0and trxn_extension_id is not null; --Verify
3929: exception
3930: when no_data_found then
3931: IF l_debug_level > 0 THEN
3932: oe_debug_pub.add('no data found while querying oe_payments in copy_order..'||sqlerrm);
3933: END IF;
3934: l_exists := 'N';
3935: end;
3936: begin

Line 3949: --New trxn_extension_id and a new record in oe_payments table

3945: END IF;
3946: end;
3947:
3948: IF nvl(l_exists, 'N') = 'N' THEN --Verify
3949: --New trxn_extension_id and a new record in oe_payments table
3950: OE_PAYMENT_TRXN_UTIL.Create_Payment_Trxn
3951: (P_header_id => l_header_rec.header_id, --Verify
3952: P_line_id => null,
3953: P_cust_id => l_invoice_to_cust_id,

Line 4059: from oe_payments where header_id = l_header_id

4055: IF FND_API.to_Boolean(p_copy_rec.line_payments)
4056: AND OE_PREPAYMENT_UTIL.IS_MULTIPLE_PAYMENTS_ENABLED THEN
4057: --bug 5113795
4058: select count(*) into l_cc_line_payments
4059: from oe_payments where header_id = l_header_id
4060: and line_id is not null and payment_type_code = 'CREDIT_CARD';
4061:
4062: IF l_debug_level > 0 THEN
4063: oe_debug_pub.add('In Line payments copy...');