DBA Data[Home] [Help]

APPS.OE_COMMITMENT_PVT dependencies on OE_PAYMENTS_UTIL

Line 304: l_payment_types_rec OE_PAYMENTS_UTIL.Payment_Types_Rec_Type;

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;

Line 305: l_payment_types_tbl OE_PAYMENTS_UTIL.Payment_Types_Tbl_Type;

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;

Line 451: oe_debug_pub.add( 'BEFORE CALLING OE_PAYMENTS_UTIL.QUERY_ROWS' ) ;

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 */

Line 454: oe_payments_Util.Query_Rows

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

Line 463: oe_debug_pub.add( 'AFTER CALLING OE_PAYMENTS_UTIL.QUERY_ROWS' ) ;

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

Line 522: oe_payments_Util.Delete_Row(p_line_id => l_line_id, p_header_id => l_header_id);

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);

Line 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

Line 559: Oe_Payments_Util.Delete_Row(p_line_id => p_line_id);

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:

Line 627: oe_debug_pub.add( 'BEFORE CALLING OE_PAYMENTS_UTIL.INSERT_ROW' ) ;

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:

Line 630: OE_Payments_Util.INSERT_ROW(p_payment_types_rec => l_payment_types_rec);

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;

Line 633: oe_debug_pub.add( 'AFTER CALLING OE_PAYMENTS_UTIL.INSERT_ROW' ) ;

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;

Line 790: l_payment_types_rec OE_PAYMENTS_UTIL.Payment_Types_Rec_Type;

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;

Line 791: l_payment_types_tbl OE_PAYMENTS_UTIL.Payment_Types_Tbl_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;