eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_COMMITMENT_PVT dependencies on OE_PAYMENTS

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 535: UPDATE oe_payments

531: oe_debug_pub.add( 'UPDATING BOTH APPLIED AMOUNT AND COMMITMENT' ) ;
532: END IF;
533:
534: IF OE_PREPAYMENT_UTIL.IS_MULTIPLE_PAYMENTS_ENABLED = TRUE then
535: UPDATE oe_payments
536: SET payment_trx_id = l_new_commitment_id,
537: commitment_applied_amount = l_commitment_applied_amount,
538: payment_number = nvl(payment_number, 1)
539: WHERE line_id = l_line_id

Line 544: UPDATE oe_payments

540: AND header_id = l_header_id
541: AND nvl(payment_type_code, 'COMMITMENT') = 'COMMITMENT';
542:
543: ELSE
544: UPDATE oe_payments
545: SET payment_trx_id = l_new_commitment_id,
546: commitment_applied_amount = l_commitment_applied_amount
547: WHERE line_id = l_line_id
548: AND header_id = l_header_id

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 569: UPDATE oe_payments

565: oe_debug_pub.add( 'UPDATING ONLY THE APPLIED AMOUNT' ) ;
566: END IF;
567:
568: IF OE_PREPAYMENT_UTIL.IS_MULTIPLE_PAYMENTS_ENABLED = TRUE then
569: UPDATE oe_payments
570: SET commitment_applied_amount = l_commitment_applied_amount,
571: payment_number = nvl(payment_number, 1)
572: WHERE line_id = l_line_id
573: AND header_id = l_header_id

Line 578: UPDATE oe_payments

574: AND payment_trx_id = l_new_commitment_id /* Added this condition for Bug #3536642 */
575: AND nvl(payment_type_code, 'COMMITMENT') = 'COMMITMENT';
576:
577: ELSE
578: UPDATE oe_payments
579: SET commitment_applied_amount = l_commitment_applied_amount
580: WHERE line_id = l_line_id
581: AND header_id = l_header_id
582: AND payment_trx_id = l_new_commitment_id /* Added this condition for Bug #3536642 */

Line 615: from oe_payments

611: Begin
612:
613: select (nvl(max(payment_number),0) + 1)
614: into l_payment_types_rec.payment_number
615: from oe_payments
616: where header_id = l_header_id
617: and line_id = l_line_id;
618:
619: Exception

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 753: FROM oe_payments

749:
750: BEGIN
751: SELECT NVL(commitment_applied_amount, 0)
752: INTO l_commitment_applied_amount
753: FROM oe_payments
754: WHERE line_id = p_line_id
755: AND header_id = p_header_id
756: AND payment_trx_id = p_commitment_id;
757:

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;

Line 853: FROM oe_payments oop

849:
850: BEGIN
851: SELECT commitment_applied_amount
852: INTO l_commitment_applied_amount
853: FROM oe_payments oop
854: WHERE nvl(payment_type_code,'COMMITMENT') = 'COMMITMENT'
855: AND line_id=p_line_id
856: AND header_id = l_header_id;
857: EXCEPTION

Line 902: update oe_payments

898:
899: oe_debug_pub.add('Linda0721 -- child commit applied is: '||l_children_commitment,1);
900:
901: IF nvl(oe_globals.g_commitment_balance,0) <= 0 THEN
902: update oe_payments
903: set commitment_applied_amount = 0
904: WHERE line_id = l_children_line_id
905: AND header_id = l_header_id
906: AND nvl(payment_type_code, 'COMMITMENT') = 'COMMITMENT';

Line 909: update oe_payments

905: AND header_id = l_header_id
906: AND nvl(payment_type_code, 'COMMITMENT') = 'COMMITMENT';
907:
908: ELSIF nvl(oe_globals.g_commitment_balance, 0) >= l_children_commitment THEN
909: update oe_payments
910: set commitment_applied_amount = l_children_commitment
911: where line_id = l_children_line_id
912: and header_id = l_header_id
913: and nvl(payment_type_code, 'COMMITMENT') = 'COMMITMENT';

Line 918: update oe_payments

914:
915: oe_globals.g_commitment_balance
916: := nvl(oe_globals.g_commitment_balance, 0) - l_children_commitment;
917: ELSIF nvl(oe_globals.g_commitment_balance, 0) < l_children_commitment THEN
918: update oe_payments
919: set commitment_applied_amount = nvl(oe_globals.g_commitment_balance, 0)
920: where line_id = l_children_line_id
921: and header_id =l_header_id
922: and nvl(payment_type_code, 'COMMITMENT') = 'COMMITMENT';

Line 1068: FROM oe_payments

1064:
1065: BEGIN
1066: SELECT nvl(commitment_applied_amount,0)
1067: INTO l_commitment_applied_amount
1068: FROM oe_payments
1069: WHERE header_id = p_header_id
1070: AND line_id = p_line_id
1071: AND payment_trx_id = p_commitment_id;
1072: EXCEPTION

Line 1137: UPDATE oe_payments

1133: OE_MSG_PUB.ADD;
1134: --bug 3560198
1135:
1136:
1137: UPDATE oe_payments
1138: SET commitment_applied_amount = l_amount_to_apply
1139: WHERE header_id = p_header_id
1140: AND line_id = p_line_id
1141: AND payment_trx_id = p_commitment_id;