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

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

Line 789: l_payment_types_rec OE_PAYMENTS_UTIL.Payment_Types_Rec_Type;

785: l_commitment_applied_amount NUMBER;
786: l_commitment_id NUMBER;
787: l_new_commitment_id NUMBER;
788: l_header_id NUMBER := -1;
789: l_payment_types_rec OE_PAYMENTS_UTIL.Payment_Types_Rec_Type;
790: l_payment_types_tbl OE_PAYMENTS_UTIL.Payment_Types_Tbl_Type;
791: l_children_line_id NUMBER;
792: l_children_commitment NUMBER;
793: l_children_line_rec OE_ORDER_PUB.Line_Rec_Type;

Line 790: l_payment_types_tbl OE_PAYMENTS_UTIL.Payment_Types_Tbl_Type;

786: l_commitment_id NUMBER;
787: l_new_commitment_id NUMBER;
788: l_header_id NUMBER := -1;
789: l_payment_types_rec OE_PAYMENTS_UTIL.Payment_Types_Rec_Type;
790: l_payment_types_tbl OE_PAYMENTS_UTIL.Payment_Types_Tbl_Type;
791: l_children_line_id NUMBER;
792: l_children_commitment NUMBER;
793: l_children_line_rec OE_ORDER_PUB.Line_Rec_Type;
794: l_children_commitment_id NUMBER;

Line 852: FROM oe_payments oop

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

Line 901: update oe_payments

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

Line 908: update oe_payments

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

Line 917: update oe_payments

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

Line 1067: FROM oe_payments

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

Line 1136: UPDATE oe_payments

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