APPS.OE_DELAYED_REQUESTS_UTIL dependencies on OE_PREPAYMENT_UTIL

Line 5530: IF OE_PrePayment_UTIL.is_prepaid_order(l_line_rec.header_id) = 'N' OR (OE_PrePayment_UTIL.is_prepaid_order(l_line_rec.header_id) = 'Y' AND l_line_rec.booked_flag ='Y' AND l_line_rec.shipped_quantity IS NULL) THEN

5526: -- Logging delayed requests for Verify Payment if tax value
5527: -- has increased AND Payment Type Code is Credit Card.
5528: IF NVL(l_total_tax,0) > NVL(l_old_total_tax,0) AND l_line_rec.commitment_id IS NULL AND l_payment_type_code = 'CREDIT_CARD' THEN
5529: -- if it is a prepaid, do not log request after shipping.
5530: IF OE_PrePayment_UTIL.is_prepaid_order(l_line_rec.header_id) = 'N' OR (OE_PrePayment_UTIL.is_prepaid_order(l_line_rec.header_id) = 'Y' AND l_line_rec.booked_flag ='Y' AND l_line_rec.shipped_quantity IS NULL) THEN
5531: IF l_debug_level > 0 THEN
5532: oe_debug_pub.ADD('Logging delayed request for Verify Payment for change in tax value',2);
5533: END IF;
5534: OE_delayed_requests_Pvt.log_request (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,

Line 5546: AND OE_PrePayment_UTIL.is_prepaid_order(l_line_rec.header_id) = 'Y'

5542: -- log delayed request for prepaid order even the tax value
5543: -- decreased, as a refund request might be needed.
5544: ELSIF NVL(l_total_tax,0) < NVL(l_old_total_tax,0)
5545: AND l_line_rec.commitment_id IS NULL
5546: AND OE_PrePayment_UTIL.is_prepaid_order(l_line_rec.header_id) = 'Y'
5547: AND l_line_rec.booked_flag ='Y'
5548: AND l_payment_type_code = 'CREDIT_CARD'
5549: AND l_line_rec.shipped_quantity IS NULL THEN
5550: IF l_debug_level > 0 THEN

Line 5795: ELSIF NVL(l_total_tax,0) < NVL(l_old_total_tax,0) AND OE_PrePayment_UTIL.is_prepaid_order(l_header_rec.header_id) = 'Y' AND l_header_rec.booked_flag ='Y' AND l_payment_type_code = 'CREDIT_CARD' THEN

5791: x_return_status => l_return_status);
5792: -- bug 2238438, credit card collection project.
5793: -- log delayed request for prepaid order even the tax value
5794: -- decreased, as a refund request might be needed.
5795: ELSIF NVL(l_total_tax,0) < NVL(l_old_total_tax,0) AND OE_PrePayment_UTIL.is_prepaid_order(l_header_rec.header_id) = 'Y' AND l_header_rec.booked_flag ='Y' AND l_payment_type_code = 'CREDIT_CARD' THEN
5796: IF l_debug_level > 0 THEN
5797: oe_debug_pub.ADD('Logging delayed request for Verify Payment for change in tax value for prepaid order',2);
5798: END IF;
5799: OE_delayed_requests_Pvt.log_request (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,