[Home] [Help]
1824: end if;
1825: END IF;
1826: -- if this is a prepaid order, also log delayed request if ordered
1827: -- quantity decreases, as refund may need to be issued.
1828: IF OE_PrePayment_UTIL.is_prepaid_order(p_x_line_rec.header_id)
1829: = 'Y' AND p_x_line_rec.booked_flag ='Y' THEN
1830: if l_debug_level > 0 then
1831: oe_debug_pub.ADD('Log Verify Payment delayed request in Ord Qty for prepayment', 3);
1832: end if;
1996: IF p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1997:
1998: if p_x_line_rec.booked_flag ='Y' then
1999:
2000: IF OE_PrePayment_UTIL.IS_MULTIPLE_PAYMENTS_ENABLED = TRUE THEN
2001:
2002: if l_debug_level > 0 then
2003: oe_debug_pub.ADD('multpayments: logging delayed request for verify payment as payment term is changed');
2004: end if;
3266: oe_debug_pub.ADD('Log Verify Payment delayed request in Tax Value');
3267: end if;
3268: l_verify_payment_flag := 'Y';
3269:
3270: ELSIF OE_PrePayment_UTIL.is_prepaid_order(p_x_line_rec.header_id)
3271: = 'Y' AND p_x_line_rec.booked_flag ='Y' THEN
3272: -- if this is a prepaid order, also log delayed request if ordered
3273: -- quantity decreases, as refund may need to be issued.
3274: if l_debug_level > 0 then
3335: -- if it is not a prepaid order, log Verify Payment delayed request.
3336: -- if it is a prepaid order, check the shipped_quantity to make
3337: -- sure to not collect fund again during repricing at shipment.
3338:
3339: IF OE_PrePayment_UTIL.is_prepaid_order(p_x_line_rec.header_id) = 'N'
3340: OR (OE_PrePayment_UTIL.is_prepaid_order(p_x_line_rec.header_id)
3341: = 'Y' AND p_x_line_rec.booked_flag ='Y'
3342: AND p_x_line_rec.shipped_quantity IS NULL) THEN
3343: if l_debug_level > 0 then
3336: -- if it is a prepaid order, check the shipped_quantity to make
3337: -- sure to not collect fund again during repricing at shipment.
3338:
3339: IF OE_PrePayment_UTIL.is_prepaid_order(p_x_line_rec.header_id) = 'N'
3340: OR (OE_PrePayment_UTIL.is_prepaid_order(p_x_line_rec.header_id)
3341: = 'Y' AND p_x_line_rec.booked_flag ='Y'
3342: AND p_x_line_rec.shipped_quantity IS NULL) THEN
3343: if l_debug_level > 0 then
3344: oe_debug_pub.ADD('Log Verify Payment delayed request in Selling Price');
3345: end if;
3346: l_verify_payment_flag := 'Y';
3347: END IF;
3348: END IF;
3349: ELSIF OE_PrePayment_UTIL.is_prepaid_order(p_x_line_rec.header_id)
3350: = 'Y' AND p_x_line_rec.booked_flag ='Y'
3351: AND p_x_line_rec.shipped_quantity IS NULL THEN
3352: -- if this is a prepaid order, also log delayed request if selling
3353: -- price decreases, as refund may need to be issued.
4968: IF p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE AND
4969: p_x_line_rec.item_type_code <> OE_GLOBALS.G_ITEM_CONFIG AND
4970: p_x_line_rec.booked_flag = 'Y' THEN
4971: IF (NVL(OE_Order_Cache.g_header_rec.payment_type_code, 'NULL') <> 'CREDIT_CARD'
4972: AND OE_PrePayment_UTIL.is_prepaid_order(p_x_line_rec.header_id) = 'N')
4973: OR OE_PrePayment_UTIL.is_prepaid_order(p_x_line_rec.header_id) = 'Y'
4974: THEN
4975: if l_debug_level > 0 then
4976: oe_debug_pub.ADD('New line added to a booked order,'
4969: p_x_line_rec.item_type_code <> OE_GLOBALS.G_ITEM_CONFIG AND
4970: p_x_line_rec.booked_flag = 'Y' THEN
4971: IF (NVL(OE_Order_Cache.g_header_rec.payment_type_code, 'NULL') <> 'CREDIT_CARD'
4972: AND OE_PrePayment_UTIL.is_prepaid_order(p_x_line_rec.header_id) = 'N')
4973: OR OE_PrePayment_UTIL.is_prepaid_order(p_x_line_rec.header_id) = 'Y'
4974: THEN
4975: if l_debug_level > 0 then
4976: oe_debug_pub.ADD('New line added to a booked order,'
4977: || 'Logging delayed request for Verify Payment', 1);
16129: ------------------------------------------------------------------------
16130:
16131: IF p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE
16132: AND p_x_line_rec.split_from_line_id is not null
16133: AND OE_PREPAYMENT_UTIL.IS_MULTIPLE_PAYMENTS_ENABLED
16134: THEN
16135:
16136: BEGIN
16137: SELECT payment_type_code