[Home] [Help]
663: --x_header_rec.check_number := FND_API.G_MISS_CHAR; --Verify
664:
665: --Before populating the header rec, have to make sure that the
666: --payment record corresponding to this order is not present in
667: --oe_payments already to avoid duplicate records while copying an
668: --order from 11510 non migrated order.
669: BEGIN
670: SELECT 'Y'
671: INTO l_payment_exists
668: --order from 11510 non migrated order.
669: BEGIN
670: SELECT 'Y'
671: INTO l_payment_exists
672: FROM oe_payments
673: WHERE header_id = p_header_id
674: AND line_id is null -- bug 5167945
675: AND PAYMENT_COLLECTION_EVENT = 'INVOICE';
676: EXCEPTION
3624: NULL;
3625:
3626: END delete_config;
3627:
3628: --To insert the transaction extension id in the oe_payments table
3629: --after the credit card details have been stored in the payments tables.
3630: --R12 CC Encryption
3631: /*Procedure Create_Payment(p_header_id IN NUMBER) IS
3632: BEGIN
3629: --after the credit card details have been stored in the payments tables.
3630: --R12 CC Encryption
3631: /*Procedure Create_Payment(p_header_id IN NUMBER) IS
3632: BEGIN
3633: INSERT INTO oe_payments
3634: (trxn_extension_id,
3635: payment_level_code,
3636: header_id,
3637: line_id,
4072:
4073: begin
4074: SELECT 'Y'
4075: INTO l_exists
4076: FROM oe_payments
4077: Where header_id = l_header_id;
4078: --0and trxn_extension_id is not null; --Verify
4079: exception
4080: when no_data_found then
4078: --0and trxn_extension_id is not null; --Verify
4079: exception
4080: when no_data_found then
4081: IF l_debug_level > 0 THEN
4082: oe_debug_pub.add('no data found while querying oe_payments in copy_order..'||sqlerrm);
4083: END IF;
4084: l_exists := 'N';
4085: end;
4086: begin
4095: END IF;
4096: end;
4097:
4098: IF nvl(l_exists, 'N') = 'N' THEN --Verify
4099: --New trxn_extension_id and a new record in oe_payments table
4100: OE_PAYMENT_TRXN_UTIL.Create_Payment_Trxn
4101: (P_header_id => l_header_rec.header_id, --Verify
4102: P_line_id => null,
4103: P_cust_id => l_invoice_to_cust_id,
4205: IF FND_API.to_Boolean(p_copy_rec.line_payments)
4206: AND OE_PREPAYMENT_UTIL.IS_MULTIPLE_PAYMENTS_ENABLED THEN
4207: --bug 5113795
4208: select count(*) into l_cc_line_payments
4209: from oe_payments where header_id = l_header_id
4210: and line_id is not null and payment_type_code = 'CREDIT_CARD';
4211:
4212: IF l_debug_level > 0 THEN
4213: oe_debug_pub.add('In Line payments copy...');