[Home] [Help]
2322: end if;
2323: END IF;
2324: -- if this is a prepaid order, also log delayed request if ordered
2325: -- quantity decreases, as refund may need to be issued.
2326: IF OE_PrePayment_UTIL.is_prepaid_order(p_x_line_rec.header_id)
2327: = 'Y' AND p_x_line_rec.booked_flag ='Y' THEN
2328: if l_debug_level > 0 then
2329: oe_debug_pub.ADD('Log Verify Payment delayed request in Ord Qty for prepayment', 3);
2330: end if;
2558: IF p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2559:
2560: if p_x_line_rec.booked_flag ='Y' then
2561:
2562: IF OE_PrePayment_UTIL.IS_MULTIPLE_PAYMENTS_ENABLED = TRUE THEN
2563:
2564: if l_debug_level > 0 then
2565: oe_debug_pub.ADD('multpayments: logging delayed request for verify payment as payment term is changed');
2566: end if;
3839: oe_debug_pub.ADD('Log Verify Payment delayed request in Tax Value');
3840: end if;
3841: l_verify_payment_flag := 'Y';
3842:
3843: ELSIF OE_PrePayment_UTIL.is_prepaid_order(p_x_line_rec.header_id)
3844: = 'Y' AND p_x_line_rec.booked_flag ='Y' THEN
3845: -- if this is a prepaid order, also log delayed request if ordered
3846: -- quantity decreases, as refund may need to be issued.
3847: if l_debug_level > 0 then
3909: -- if it is not a prepaid order, log Verify Payment delayed request.
3910: -- if it is a prepaid order, check the shipped_quantity to make
3911: -- sure to not collect fund again during repricing at shipment.
3912:
3913: IF OE_PrePayment_UTIL.is_prepaid_order(p_x_line_rec.header_id) = 'N'
3914: OR (OE_PrePayment_UTIL.is_prepaid_order(p_x_line_rec.header_id)
3915: = 'Y' AND p_x_line_rec.booked_flag ='Y'
3916: AND p_x_line_rec.shipped_quantity IS NULL) THEN
3917: if l_debug_level > 0 then
3910: -- if it is a prepaid order, check the shipped_quantity to make
3911: -- sure to not collect fund again during repricing at shipment.
3912:
3913: IF OE_PrePayment_UTIL.is_prepaid_order(p_x_line_rec.header_id) = 'N'
3914: OR (OE_PrePayment_UTIL.is_prepaid_order(p_x_line_rec.header_id)
3915: = 'Y' AND p_x_line_rec.booked_flag ='Y'
3916: AND p_x_line_rec.shipped_quantity IS NULL) THEN
3917: if l_debug_level > 0 then
3918: oe_debug_pub.ADD('Log Verify Payment delayed request in Selling Price');
3919: end if;
3920: l_verify_payment_flag := 'Y';
3921: END IF;
3922: END IF;
3923: ELSIF OE_PrePayment_UTIL.is_prepaid_order(p_x_line_rec.header_id)
3924: = 'Y' AND p_x_line_rec.booked_flag ='Y'
3925: AND p_x_line_rec.shipped_quantity IS NULL THEN
3926: -- if this is a prepaid order, also log delayed request if selling
3927: -- price decreases, as refund may need to be issued.
6089: --CC Reversal ER#16014135 Start
6090: IF ((NVL(OE_Order_Cache.g_header_rec.payment_type_code, 'NULL') <> 'CREDIT_CARD'
6091: OR (OE_Order_Cache.g_header_rec.payment_type_code = 'CREDIT_CARD' AND l_cc_rev_reauth_code IS NOT NULL))
6092: --CC Reversal ER#16014135 End
6093: AND OE_PrePayment_UTIL.is_prepaid_order(p_x_line_rec.header_id) = 'N')
6094: OR OE_PrePayment_UTIL.is_prepaid_order(p_x_line_rec.header_id) = 'Y'
6095: THEN
6096: if l_debug_level > 0 then
6097: oe_debug_pub.ADD('New line added to a booked order,'
6090: IF ((NVL(OE_Order_Cache.g_header_rec.payment_type_code, 'NULL') <> 'CREDIT_CARD'
6091: OR (OE_Order_Cache.g_header_rec.payment_type_code = 'CREDIT_CARD' AND l_cc_rev_reauth_code IS NOT NULL))
6092: --CC Reversal ER#16014135 End
6093: AND OE_PrePayment_UTIL.is_prepaid_order(p_x_line_rec.header_id) = 'N')
6094: OR OE_PrePayment_UTIL.is_prepaid_order(p_x_line_rec.header_id) = 'Y'
6095: THEN
6096: if l_debug_level > 0 then
6097: oe_debug_pub.ADD('New line added to a booked order,'
6098: || 'Logging delayed request for Verify Payment', 1);
17641: ------------------------------------------------------------------------
17642:
17643: IF p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE
17644: AND p_x_line_rec.split_from_line_id is not null
17645: AND OE_PREPAYMENT_UTIL.IS_MULTIPLE_PAYMENTS_ENABLED
17646: THEN
17647:
17648: BEGIN
17649: SELECT payment_type_code