DBA Data[Home] [Help]

APPS.OE_DELAYED_REQUESTS_UTIL dependencies on OE_PREPAYMENT_UTIL

Line 5312: IF OE_PrePayment_UTIL.is_prepaid_order(l_header_id) = 'N'

5308: AND l_commitment_id IS NULL
5309: AND l_payment_type_code = 'CREDIT_CARD' THEN
5310:
5311: -- if it is a prepaid, do not log request after shipping.
5312: IF OE_PrePayment_UTIL.is_prepaid_order(l_header_id) = 'N'
5313: OR (OE_PrePayment_UTIL.is_prepaid_order(l_header_id) = 'Y'
5314: AND l_booked_flag ='Y'
5315: AND l_shipped_quantity IS NULL) THEN
5316: IF l_debug_level > 0 THEN

Line 5313: OR (OE_PrePayment_UTIL.is_prepaid_order(l_header_id) = 'Y'

5309: AND l_payment_type_code = 'CREDIT_CARD' THEN
5310:
5311: -- if it is a prepaid, do not log request after shipping.
5312: IF OE_PrePayment_UTIL.is_prepaid_order(l_header_id) = 'N'
5313: OR (OE_PrePayment_UTIL.is_prepaid_order(l_header_id) = 'Y'
5314: AND l_booked_flag ='Y'
5315: AND l_shipped_quantity IS NULL) THEN
5316: IF l_debug_level > 0 THEN
5317: oe_debug_pub.ADD('Logging delayed request for Verify Payment for change in tax value',2);

Line 5333: AND OE_PrePayment_UTIL.is_prepaid_order(l_header_id) = 'Y'

5329: -- log delayed request for prepaid order even the tax value
5330: -- decreased, as a refund request might be needed.
5331: ELSIF NVL(new_tax_value,0) < NVL(l_tax_value,0)
5332: AND l_commitment_id IS NULL
5333: AND OE_PrePayment_UTIL.is_prepaid_order(l_header_id) = 'Y'
5334: AND l_booked_flag ='Y'
5335: AND l_payment_type_code = 'CREDIT_CARD'
5336: AND l_shipped_quantity IS NULL THEN
5337: IF l_debug_level > 0 THEN