300: )
301: IS
302: l_line_id NUMBER := p_request_rec.entity_id;
303: l_line_rec OE_ORDER_PUB.Line_Rec_Type;
304: l_payment_types_rec OE_PAYMENTS_UTIL.Payment_Types_Rec_Type;
305: l_payment_types_tbl OE_PAYMENTS_UTIL.Payment_Types_Tbl_Type;
306: l_return_status VARCHAR2(30) := FND_API.G_RET_STS_SUCCESS;
307: l_header_id NUMBER;
308: l_commitment_id NUMBER;
301: IS
302: l_line_id NUMBER := p_request_rec.entity_id;
303: l_line_rec OE_ORDER_PUB.Line_Rec_Type;
304: l_payment_types_rec OE_PAYMENTS_UTIL.Payment_Types_Rec_Type;
305: l_payment_types_tbl OE_PAYMENTS_UTIL.Payment_Types_Tbl_Type;
306: l_return_status VARCHAR2(30) := FND_API.G_RET_STS_SUCCESS;
307: l_header_id NUMBER;
308: l_commitment_id NUMBER;
309: l_new_commitment_id NUMBER;
447:
448: BEGIN
449:
450: IF l_debug_level > 0 THEN
451: oe_debug_pub.add( 'BEFORE CALLING OE_PAYMENTS_UTIL.QUERY_ROWS' ) ;
452: END IF;
453:
454: oe_payments_Util.Query_Rows
455: ( p_payment_trx_id => l_new_commitment_id /* Bug#3536642 */
450: IF l_debug_level > 0 THEN
451: oe_debug_pub.add( 'BEFORE CALLING OE_PAYMENTS_UTIL.QUERY_ROWS' ) ;
452: END IF;
453:
454: oe_payments_Util.Query_Rows
455: ( p_payment_trx_id => l_new_commitment_id /* Bug#3536642 */
456: ,p_header_id => l_header_id
457: ,p_line_id => l_line_id
458: ,x_payment_types_tbl => l_payment_types_tbl
459: ,x_return_status => l_return_status
460: );
461:
462: IF l_debug_level > 0 THEN
463: oe_debug_pub.add( 'AFTER CALLING OE_PAYMENTS_UTIL.QUERY_ROWS' ) ;
464: END IF;
465:
466: EXCEPTION
467: WHEN NO_DATA_FOUND THEN
518:
519: IF l_payment_types_tbl.COUNT > 0 THEN
520: IF l_line_id IS NOT NULL THEN
521: IF l_new_commitment_id IS NULL THEN
522: oe_payments_Util.Delete_Row(p_line_id => l_line_id, p_header_id => l_header_id);
523: ELSE
524: -- Fix Bug # 2511389: Delete payment record if applied amount has been set to <= 0.
525: IF nvl(l_commitment_applied_amount, 0) <= 0 THEN
526: oe_payments_Util.Delete_Row(p_line_id => l_line_id, p_header_id => l_header_id);
522: oe_payments_Util.Delete_Row(p_line_id => l_line_id, p_header_id => l_header_id);
523: ELSE
524: -- Fix Bug # 2511389: Delete payment record if applied amount has been set to <= 0.
525: IF nvl(l_commitment_applied_amount, 0) <= 0 THEN
526: oe_payments_Util.Delete_Row(p_line_id => l_line_id, p_header_id => l_header_id);
527: ELSE
528: IF NOT OE_GLOBALS.Equal(l_new_commitment_id, l_payment_types_tbl(1).payment_trx_id) THEN
529:
530: IF l_debug_level > 0 THEN
555:
556: /*** Fix Bug # 2511389: Call to delete_row added above should take care of this scenario also
557: IF l_commitment_bal >0 OR (l_commitment_bal <= 0 AND l_commitment_applied_amount < l_payment_types_tbl(1).commitment_applied_amount) THEN
558: IF l_ordered_quantity = 0 THEN
559: Oe_Payments_Util.Delete_Row(p_line_id => p_line_id);
560: ELSE
561: ***/
562: IF NVL(l_commitment_applied_amount, 0) <> NVL(l_payment_types_tbl(1).commitment_applied_amount, 0) THEN
563:
623:
624: END IF;
625:
626: IF l_debug_level > 0 THEN
627: oe_debug_pub.add( 'BEFORE CALLING OE_PAYMENTS_UTIL.INSERT_ROW' ) ;
628: END IF;
629:
630: OE_Payments_Util.INSERT_ROW(p_payment_types_rec => l_payment_types_rec);
631:
626: IF l_debug_level > 0 THEN
627: oe_debug_pub.add( 'BEFORE CALLING OE_PAYMENTS_UTIL.INSERT_ROW' ) ;
628: END IF;
629:
630: OE_Payments_Util.INSERT_ROW(p_payment_types_rec => l_payment_types_rec);
631:
632: IF l_debug_level > 0 THEN
633: oe_debug_pub.add( 'AFTER CALLING OE_PAYMENTS_UTIL.INSERT_ROW' ) ;
634: END IF;
629:
630: OE_Payments_Util.INSERT_ROW(p_payment_types_rec => l_payment_types_rec);
631:
632: IF l_debug_level > 0 THEN
633: oe_debug_pub.add( 'AFTER CALLING OE_PAYMENTS_UTIL.INSERT_ROW' ) ;
634: END IF;
635:
636: l_show_balance := TRUE;
637: END IF;
786: l_commitment_applied_amount NUMBER;
787: l_commitment_id NUMBER;
788: l_new_commitment_id NUMBER;
789: l_header_id NUMBER := -1;
790: l_payment_types_rec OE_PAYMENTS_UTIL.Payment_Types_Rec_Type;
791: l_payment_types_tbl OE_PAYMENTS_UTIL.Payment_Types_Tbl_Type;
792: l_children_line_id NUMBER;
793: l_children_commitment NUMBER;
794: l_children_line_rec OE_ORDER_PUB.Line_Rec_Type;
787: l_commitment_id NUMBER;
788: l_new_commitment_id NUMBER;
789: l_header_id NUMBER := -1;
790: l_payment_types_rec OE_PAYMENTS_UTIL.Payment_Types_Rec_Type;
791: l_payment_types_tbl OE_PAYMENTS_UTIL.Payment_Types_Tbl_Type;
792: l_children_line_id NUMBER;
793: l_children_commitment NUMBER;
794: l_children_line_rec OE_ORDER_PUB.Line_Rec_Type;
795: l_children_commitment_id NUMBER;