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_DEBUG_PUB

Line 51: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

47: l_min_acct_unit NUMBER;
48: l_text VARCHAR2(500);
49:
50: --
51: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
52: --
53: BEGIN
54: IF l_debug_level > 0 THEN
55: oe_debug_pub.add( 'ENTERING OE_COMMITMENT_PVT' ) ;

Line 55: oe_debug_pub.add( 'ENTERING OE_COMMITMENT_PVT' ) ;

51: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
52: --
53: BEGIN
54: IF l_debug_level > 0 THEN
55: oe_debug_pub.add( 'ENTERING OE_COMMITMENT_PVT' ) ;
56: END IF;
57: x_return_status := FND_API.G_RET_STS_SUCCESS;
58:
59:

Line 63: oe_debug_pub.add( ' NEW COMMITMENT RETURNING TO CALLER' ) ;

59:
60: If do_commitment_sequencing Then
61: --new behavior this old procedure should not even get called
62: IF l_debug_level > 0 THEN
63: oe_debug_pub.add( ' NEW COMMITMENT RETURNING TO CALLER' ) ;
64: END IF;
65: Return;
66: End If;
67:

Line 74: oe_debug_pub.add( 'EVALUATE COMMITMENT FOR COMMITMENTID:' || TO_CHAR ( P_COMMITMENT_ID ) , 1 ) ;

70: Return;
71: End If;
72:
73: IF l_debug_level > 0 THEN
74: oe_debug_pub.add( 'EVALUATE COMMITMENT FOR COMMITMENTID:' || TO_CHAR ( P_COMMITMENT_ID ) , 1 ) ;
75: END IF;
76: l_class := NULL;
77: l_so_source_code := FND_PROFILE.VALUE('ONT_SOURCE_CODE');
78: l_oe_installed_flag := 'I';

Line 80: oe_debug_pub.add( 'COMMITMENT AFTER CALLING FND_PROFILE.VALUE' ) ;

76: l_class := NULL;
77: l_so_source_code := FND_PROFILE.VALUE('ONT_SOURCE_CODE');
78: l_oe_installed_flag := 'I';
79: IF l_debug_level > 0 THEN
80: oe_debug_pub.add( 'COMMITMENT AFTER CALLING FND_PROFILE.VALUE' ) ;
81: END IF;
82:
83: l_commitment_bal := nvl(oe_globals.g_commitment_balance, 0);
84:

Line 87: oe_debug_pub.add( 'TOTAL COMMITMENT BALANCE:'|| TO_CHAR ( L_TOTAL_BALANCE ) , 1 ) ;

83: l_commitment_bal := nvl(oe_globals.g_commitment_balance, 0);
84:
85: l_total_balance := l_commitment_bal - p_unit_selling_price;
86: IF l_debug_level > 0 THEN
87: oe_debug_pub.add( 'TOTAL COMMITMENT BALANCE:'|| TO_CHAR ( L_TOTAL_BALANCE ) , 1 ) ;
88: END IF;
89: BEGIN
90: SELECT nvl(transactional_curr_code,'USD')
91: INTO l_currency_code from oe_order_headers

Line 119: oe_debug_pub.add( ' COMMITMENT HAVE OVERDRAWN MORE THAN ONCE' ) ;

115: FND_MESSAGE.SET_NAME('ONT','OE_COM_ZERO_BALANCE');
116: FND_MESSAGE.SET_TOKEN('COMMITMENT' , l_trx_number);
117: OE_MSG_PUB.ADD;
118: IF l_debug_level > 0 THEN
119: oe_debug_pub.add( ' COMMITMENT HAVE OVERDRAWN MORE THAN ONCE' ) ;
120: oe_debug_pub.add( ' EXPECTED ERROR IN EVALUATE_COMMITMENT' , 1 ) ;
121: END IF;
122: x_return_status := FND_API.G_RET_STS_ERROR;
123: -- move code to calculate_commitment

Line 120: oe_debug_pub.add( ' EXPECTED ERROR IN EVALUATE_COMMITMENT' , 1 ) ;

116: FND_MESSAGE.SET_TOKEN('COMMITMENT' , l_trx_number);
117: OE_MSG_PUB.ADD;
118: IF l_debug_level > 0 THEN
119: oe_debug_pub.add( ' COMMITMENT HAVE OVERDRAWN MORE THAN ONCE' ) ;
120: oe_debug_pub.add( ' EXPECTED ERROR IN EVALUATE_COMMITMENT' , 1 ) ;
121: END IF;
122: x_return_status := FND_API.G_RET_STS_ERROR;
123: -- move code to calculate_commitment
124: elsif l_total_balance <= 0 then

Line 132: oe_debug_pub.add( ' ISSUE A WARNING ABOUT COMMITMENT HAS BEEN OVERDRAWN' ) ;

128: FND_MESSAGE.Set_Token('COMMITMENT',l_trx_number);
129: FND_Message.Set_Token('BALANCE',TO_CHAR(l_total_balance * -1, g_fmt_mask));
130: OE_MSG_PUB.ADD;
131: IF l_debug_level > 0 THEN
132: oe_debug_pub.add( ' ISSUE A WARNING ABOUT COMMITMENT HAS BEEN OVERDRAWN' ) ;
133: END IF;
134: -- show the message after saving the commitment
135: else
136: FND_MESSAGE.Set_Name('ONT','OE_COM_BALANCE');

Line 145: oe_debug_pub.add( 'LEAVING COMMITMENT' ) ;

141:
142: end if;
143:
144: IF l_debug_level > 0 THEN
145: oe_debug_pub.add( 'LEAVING COMMITMENT' ) ;
146: END IF;
147: EXCEPTION
148: WHEN OTHERS THEN
149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 171: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

167: v_allocate_tax_freight VARCHAR2(1);
168: v_Dummy INTEGER;
169:
170: --
171: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
172: --
173: BEGIN
174:
175: IF l_debug_level > 0 THEN

Line 176: oe_debug_pub.add( 'ENTERING GET_ALLOCATE_TAX_FREIGHT' , 1 ) ;

172: --
173: BEGIN
174:
175: IF l_debug_level > 0 THEN
176: oe_debug_pub.add( 'ENTERING GET_ALLOCATE_TAX_FREIGHT' , 1 ) ;
177: END IF;
178:
179: -- implementing dynamic SQL to avoid compilation error if AR Patch D is not installed.
180: v_CursorID := DBMS_SQL.OPEN_CURSOR;

Line 213: oe_debug_pub.add( 'THE RETURNED VALUE FOR ALLOCATE_TAX_FREIGHT IS: '||V_ALLOCATE_TAX_FREIGHT , 3 ) ;

209: v_allocate_tax_freight := 'N';
210: END IF;
211:
212: IF l_debug_level > 0 THEN
213: oe_debug_pub.add( 'THE RETURNED VALUE FOR ALLOCATE_TAX_FREIGHT IS: '||V_ALLOCATE_TAX_FREIGHT , 3 ) ;
214: END IF;
215:
216:
217: /***

Line 248: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

244: l_msg_count NUMBER;
245: l_msg_data VARCHAR2(2000);
246:
247: --
248: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
249: --
250: BEGIN
251:
252: IF l_debug_level > 0 THEN

Line 253: oe_debug_pub.add( 'ENTERING OE_COMMITMENT_PVT.GET_LINE_TOTAL.' , 1 ) ;

249: --
250: BEGIN
251:
252: IF l_debug_level > 0 THEN
253: oe_debug_pub.add( 'ENTERING OE_COMMITMENT_PVT.GET_LINE_TOTAL.' , 1 ) ;
254: END IF;
255:
256: l_allocate_tax_freight := Get_Allocate_Tax_Freight(p_line_rec => p_line_rec);
257:

Line 259: oe_debug_pub.add( 'IN OE_COMMITMENT_PVT , ALLOCATE_TAX_FREIGHT IS: '||L_ALLOCATE_TAX_FREIGHT , 3 ) ;

255:
256: l_allocate_tax_freight := Get_Allocate_Tax_Freight(p_line_rec => p_line_rec);
257:
258: IF l_debug_level > 0 THEN
259: oe_debug_pub.add( 'IN OE_COMMITMENT_PVT , ALLOCATE_TAX_FREIGHT IS: '||L_ALLOCATE_TAX_FREIGHT , 3 ) ;
260: END IF;
261:
262: -- get line level charges
263: IF nvl(p_line_rec.ordered_quantity, 0) > 0 THEN

Line 340: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

336: l_transaction_phase_code VARCHAR2(30);
337: --bug 3560198
338: l_result BOOLEAN;
339: --
340: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
341: --
342: BEGIN
343:
344: IF l_debug_level > 0 THEN

Line 345: oe_debug_pub.add( 'ENTERING OE_COMMITMENT_PVT.CALCULATE_COMMITMENT FOR LINE: '||l_LINE_ID , 1 ) ;

341: --
342: BEGIN
343:
344: IF l_debug_level > 0 THEN
345: oe_debug_pub.add( 'ENTERING OE_COMMITMENT_PVT.CALCULATE_COMMITMENT FOR LINE: '||l_LINE_ID , 1 ) ;
346: END IF;
347:
348: BEGIN
349: SELECT l.header_id

Line 376: oe_debug_pub.add('trxn phase :'||l_transaction_phase_code);

372:
373: -- QUOTING change
374: -- No need to calculate commitment for orders in negotiation phase
375: if l_debug_level > 0 then
376: oe_debug_pub.add('trxn phase :'||l_transaction_phase_code);
377: end if;
378: IF l_transaction_phase_code = 'N' THEN
379: RETURN;
380: END IF;

Line 424: oe_debug_pub.add( 'LINE TOTAL RETURNED IS: '||L_TOTAL , 1 ) ;

420: -- calling the procedure to get the line total amount
421: l_total := get_line_total(p_line_rec => l_line_rec);
422:
423: IF l_debug_level > 0 THEN
424: oe_debug_pub.add( 'LINE TOTAL RETURNED IS: '||L_TOTAL , 1 ) ;
425: END IF;
426:
427: -- get the commitment balance
428: l_class := NULL;

Line 445: oe_debug_pub.add( 'COMMITMENT BALANCE IS: '||L_COMMITMENT_BAL ) ;

441:
442: -- l_commitment_bal := nvl(oe_globals.g_commitment_balance, 0);
443:
444: IF l_debug_level > 0 THEN
445: oe_debug_pub.add( 'COMMITMENT BALANCE IS: '||L_COMMITMENT_BAL ) ;
446: END IF;
447:
448: BEGIN
449:

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 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 477: oe_debug_pub.add( 'commitment type '||l_payment_types_tbl(1).payment_type_code);

473: -- Fix Bug # 2511389: Changed logic inside following IF condition
474: IF l_new_commitment_id IS NOT NULL THEN
475:
476: IF l_payment_types_tbl.COUNT > 0 THEN
477: oe_debug_pub.add( 'commitment type '||l_payment_types_tbl(1).payment_type_code);
478: oe_debug_pub.add( '1 : '||l_payment_types_tbl(1).payment_trx_id);
479: oe_debug_pub.add( 'New commitment Id '||l_new_commitment_id);
480: IF l_new_commitment_id = l_payment_types_tbl(1).payment_trx_id THEN
481: /* Added nvl for the Bug #3536642 */

Line 478: oe_debug_pub.add( '1 : '||l_payment_types_tbl(1).payment_trx_id);

474: IF l_new_commitment_id IS NOT NULL THEN
475:
476: IF l_payment_types_tbl.COUNT > 0 THEN
477: oe_debug_pub.add( 'commitment type '||l_payment_types_tbl(1).payment_type_code);
478: oe_debug_pub.add( '1 : '||l_payment_types_tbl(1).payment_trx_id);
479: oe_debug_pub.add( 'New commitment Id '||l_new_commitment_id);
480: IF l_new_commitment_id = l_payment_types_tbl(1).payment_trx_id THEN
481: /* Added nvl for the Bug #3536642 */
482: oe_debug_pub.add( 'commitment applied amount '||l_payment_types_tbl(1).commitment_applied_amount);

Line 479: oe_debug_pub.add( 'New commitment Id '||l_new_commitment_id);

475:
476: IF l_payment_types_tbl.COUNT > 0 THEN
477: oe_debug_pub.add( 'commitment type '||l_payment_types_tbl(1).payment_type_code);
478: oe_debug_pub.add( '1 : '||l_payment_types_tbl(1).payment_trx_id);
479: oe_debug_pub.add( 'New commitment Id '||l_new_commitment_id);
480: IF l_new_commitment_id = l_payment_types_tbl(1).payment_trx_id THEN
481: /* Added nvl for the Bug #3536642 */
482: oe_debug_pub.add( 'commitment applied amount '||l_payment_types_tbl(1).commitment_applied_amount);
483: l_commitment_bal := l_commitment_bal + nvl(l_payment_types_tbl(1).commitment_applied_amount,0);

Line 482: oe_debug_pub.add( 'commitment applied amount '||l_payment_types_tbl(1).commitment_applied_amount);

478: oe_debug_pub.add( '1 : '||l_payment_types_tbl(1).payment_trx_id);
479: oe_debug_pub.add( 'New commitment Id '||l_new_commitment_id);
480: IF l_new_commitment_id = l_payment_types_tbl(1).payment_trx_id THEN
481: /* Added nvl for the Bug #3536642 */
482: oe_debug_pub.add( 'commitment applied amount '||l_payment_types_tbl(1).commitment_applied_amount);
483: l_commitment_bal := l_commitment_bal + nvl(l_payment_types_tbl(1).commitment_applied_amount,0);
484:
485: --added for multiple payments
486: if l_payment_types_tbl(1).payment_amount is not null

Line 493: oe_debug_pub.add( 'COMMITMENT BALANCE WITH CURRENTLY APPLIED COMMITMENT: '||L_COMMITMENT_BAL ) ;

489: l_total := l_payment_types_tbl(1).payment_amount;
490: end if;
491:
492: IF l_debug_level > 0 THEN
493: oe_debug_pub.add( 'COMMITMENT BALANCE WITH CURRENTLY APPLIED COMMITMENT: '||L_COMMITMENT_BAL ) ;
494: END IF;
495: END IF;
496:
497: END IF;

Line 515: oe_debug_pub.add( 'COMMITMENT APPLIED AMOUNT IS: '||L_COMMITMENT_APPLIED_AMOUNT ) ;

511: END IF;
512:
513:
514: IF l_debug_level > 0 THEN
515: oe_debug_pub.add( 'COMMITMENT APPLIED AMOUNT IS: '||L_COMMITMENT_APPLIED_AMOUNT ) ;
516: END IF;
517: END IF;
518:
519: IF l_payment_types_tbl.COUNT > 0 THEN

Line 531: oe_debug_pub.add( 'UPDATING BOTH APPLIED AMOUNT AND COMMITMENT' ) ;

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

Line 565: oe_debug_pub.add( 'UPDATING ONLY THE APPLIED AMOUNT' ) ;

561: ***/
562: IF NVL(l_commitment_applied_amount, 0) <> NVL(l_payment_types_tbl(1).commitment_applied_amount, 0) THEN
563:
564: IF l_debug_level > 0 THEN
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

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 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 642: oe_debug_pub.add('Check if a request for update commitment applied has been logged or not');

638: END IF;
639:
640: --bug 3560198
641: IF l_debug_level > 0 THEN
642: oe_debug_pub.add('Check if a request for update commitment applied has been logged or not');
643: oe_debug_pub.add('p_request_rec.entity_code : '||p_request_rec.entity_code);
644: oe_debug_pub.add('p_request_rec.entity_id : '||p_request_rec.entity_id);
645: oe_debug_pub.add('p_request_rec.request_type : '||p_request_rec.request_type);
646: END IF;

Line 643: oe_debug_pub.add('p_request_rec.entity_code : '||p_request_rec.entity_code);

639:
640: --bug 3560198
641: IF l_debug_level > 0 THEN
642: oe_debug_pub.add('Check if a request for update commitment applied has been logged or not');
643: oe_debug_pub.add('p_request_rec.entity_code : '||p_request_rec.entity_code);
644: oe_debug_pub.add('p_request_rec.entity_id : '||p_request_rec.entity_id);
645: oe_debug_pub.add('p_request_rec.request_type : '||p_request_rec.request_type);
646: END IF;
647: l_result := Oe_Delayed_Requests_Pvt.Check_For_Request(p_request_rec.entity_code,

Line 644: oe_debug_pub.add('p_request_rec.entity_id : '||p_request_rec.entity_id);

640: --bug 3560198
641: IF l_debug_level > 0 THEN
642: oe_debug_pub.add('Check if a request for update commitment applied has been logged or not');
643: oe_debug_pub.add('p_request_rec.entity_code : '||p_request_rec.entity_code);
644: oe_debug_pub.add('p_request_rec.entity_id : '||p_request_rec.entity_id);
645: oe_debug_pub.add('p_request_rec.request_type : '||p_request_rec.request_type);
646: END IF;
647: l_result := Oe_Delayed_Requests_Pvt.Check_For_Request(p_request_rec.entity_code,
648: p_request_rec.entity_id,

Line 645: oe_debug_pub.add('p_request_rec.request_type : '||p_request_rec.request_type);

641: IF l_debug_level > 0 THEN
642: oe_debug_pub.add('Check if a request for update commitment applied has been logged or not');
643: oe_debug_pub.add('p_request_rec.entity_code : '||p_request_rec.entity_code);
644: oe_debug_pub.add('p_request_rec.entity_id : '||p_request_rec.entity_id);
645: oe_debug_pub.add('p_request_rec.request_type : '||p_request_rec.request_type);
646: END IF;
647: l_result := Oe_Delayed_Requests_Pvt.Check_For_Request(p_request_rec.entity_code,
648: p_request_rec.entity_id,
649: OE_GLOBALS.G_UPDATE_COMMITMENT_APPLIED

Line 652: oe_debug_pub.add('setting l_show_balance to false');

648: p_request_rec.entity_id,
649: OE_GLOBALS.G_UPDATE_COMMITMENT_APPLIED
650: );
651: IF l_result THEN
652: oe_debug_pub.add('setting l_show_balance to false');
653: l_show_balance := FALSE;
654: END IF;
655: --bug 3560198
656: IF l_new_commitment_id IS NOT NULL AND l_show_balance THEN

Line 668: oe_debug_pub.add( 'NEW COMMITMENT BALANCE IS: '||L_NEW_COMMITMENT_BAL ) ;

664: */
665:
666: l_new_commitment_bal := l_commitment_bal - l_commitment_applied_amount;
667: IF l_debug_level > 0 THEN
668: oe_debug_pub.add( 'NEW COMMITMENT BALANCE IS: '||L_NEW_COMMITMENT_BAL ) ;
669: END IF;
670:
671: FND_MESSAGE.Set_Name('ONT','OE_COM_BALANCE');
672: FND_MESSAGE.Set_Token('COMMITMENT',l_commitment);

Line 719: oe_debug_pub.add( 'LOGGING DELAYED REQUEST FOR VERIFY PAYMENT IN COMMITMENTS' , 2 ) ;

715: --
716: IF l_verify_payment_flag = 'Y' THEN
717:
718: IF l_debug_level > 0 THEN
719: oe_debug_pub.add( 'LOGGING DELAYED REQUEST FOR VERIFY PAYMENT IN COMMITMENTS' , 2 ) ;
720: END IF;
721: OE_delayed_requests_Pvt.log_request
722: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
723: p_entity_id => l_header_id,

Line 732: oe_debug_pub.add( 'EXITING OE_COMMITMENT_PVT.CALCULATE_COMMITMENT.' , 1 ) ;

728:
729: END IF;
730:
731: IF l_debug_level > 0 THEN
732: oe_debug_pub.add( 'EXITING OE_COMMITMENT_PVT.CALCULATE_COMMITMENT.' , 1 ) ;
733: END IF;
734:
735: END calculate_commitment;
736:

Line 745: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

741: ) RETURN NUMBER IS
742: l_commitment_applied_amount NUMBER := 0.0;
743:
744: --
745: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
746: --
747: BEGIN
748:
749:

Line 812: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

808: WHERE header_id = l_header_id
809: AND split_from_line_id = p_line_id;
810:
811: --
812: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
813: --
814: BEGIN
815:
816: IF l_debug_level > 0 THEN

Line 817: oe_debug_pub.add( 'ENTERING UPDATE_COMMITMENT FOR LINE_ID '||P_LINE_ID , 1 ) ;

813: --
814: BEGIN
815:
816: IF l_debug_level > 0 THEN
817: oe_debug_pub.add( 'ENTERING UPDATE_COMMITMENT FOR LINE_ID '||P_LINE_ID , 1 ) ;
818: END IF;
819:
820: BEGIN
821: SELECT l.header_id

Line 844: oe_debug_pub.add('trxn phase :'||l_transaction_phase_code);

840:
841: -- QUOTING change
842: -- No need to update commitment for orders in negotiation phase
843: if l_debug_level > 0 then
844: oe_debug_pub.add('trxn phase :'||l_transaction_phase_code);
845: end if;
846: IF l_transaction_phase_code = 'N' THEN
847: RETURN;
848: END IF;

Line 869: oe_debug_pub.add('commitment balance is: '||oe_globals.g_commitment_balance,3);

865: := oe_globals.g_original_commitment_applied - l_commitment_applied_amount;
866: END IF;
867:
868: IF l_debug_level > 0 THEN
869: oe_debug_pub.add('commitment balance is: '||oe_globals.g_commitment_balance,3);
870: oe_debug_pub.add('commitment applied amount is: '||l_commitment_applied_amount,3);
871: oe_debug_pub.add('original commitment applied is: '||oe_globals.g_original_commitment_applied,3);
872: END IF;
873:

Line 870: oe_debug_pub.add('commitment applied amount is: '||l_commitment_applied_amount,3);

866: END IF;
867:
868: IF l_debug_level > 0 THEN
869: oe_debug_pub.add('commitment balance is: '||oe_globals.g_commitment_balance,3);
870: oe_debug_pub.add('commitment applied amount is: '||l_commitment_applied_amount,3);
871: oe_debug_pub.add('original commitment applied is: '||oe_globals.g_original_commitment_applied,3);
872: END IF;
873:
874: OPEN l_split_lines_cur;

Line 871: oe_debug_pub.add('original commitment applied is: '||oe_globals.g_original_commitment_applied,3);

867:
868: IF l_debug_level > 0 THEN
869: oe_debug_pub.add('commitment balance is: '||oe_globals.g_commitment_balance,3);
870: oe_debug_pub.add('commitment applied amount is: '||l_commitment_applied_amount,3);
871: oe_debug_pub.add('original commitment applied is: '||oe_globals.g_original_commitment_applied,3);
872: END IF;
873:
874: OPEN l_split_lines_cur;
875: LOOP

Line 899: oe_debug_pub.add('Linda0721 -- child commit applied is: '||l_children_commitment,1);

895:
896: l_children_commitment
897: := get_line_total(p_line_rec => l_children_line_rec);
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

Line 931: oe_debug_pub.add( 'Exiting UPDATE_COMMITMENT. ', 1 ) ;

927: END LOOP;
928: CLOSE l_split_lines_cur;
929:
930: IF l_debug_level > 0 THEN
931: oe_debug_pub.add( 'Exiting UPDATE_COMMITMENT. ', 1 ) ;
932: END IF;
933:
934: END update_commitment;
935:

Line 944: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

940: INVALID_COLUMN_NAME EXCEPTION;
941: PRAGMA EXCEPTION_INIT(INVALID_COLUMN_NAME, -904);
942:
943: --
944: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
945: --
946: BEGIN
947:
948: IF G_Do_Commitment_Sequencing <> FND_API.G_MISS_NUM THEN

Line 1039: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1035: l_ext_precision NUMBER;
1036: l_min_acct_unit NUMBER;
1037: --bug 3560198
1038:
1039: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1040:
1041: BEGIN
1042:
1043: IF l_debug_level > 0 THEN

Line 1044: oe_debug_pub.add('OEXVCMTB: Entering UPDATE_COMMITMENT_APPLIED FOR LINE_ID '||P_LINE_ID, 1 );

1040:
1041: BEGIN
1042:
1043: IF l_debug_level > 0 THEN
1044: oe_debug_pub.add('OEXVCMTB: Entering UPDATE_COMMITMENT_APPLIED FOR LINE_ID '||P_LINE_ID, 1 );
1045: oe_debug_pub.add('OEXVCMTB: p_amount is: '||p_amount, 3 );
1046: oe_debug_pub.add('OEXVCMTB: p_header_id is: '||p_header_id, 3 );
1047: oe_debug_pub.add('OEXVCMTB: p_commitment_id is: '||p_commitment_id, 3 );
1048: END IF;

Line 1045: oe_debug_pub.add('OEXVCMTB: p_amount is: '||p_amount, 3 );

1041: BEGIN
1042:
1043: IF l_debug_level > 0 THEN
1044: oe_debug_pub.add('OEXVCMTB: Entering UPDATE_COMMITMENT_APPLIED FOR LINE_ID '||P_LINE_ID, 1 );
1045: oe_debug_pub.add('OEXVCMTB: p_amount is: '||p_amount, 3 );
1046: oe_debug_pub.add('OEXVCMTB: p_header_id is: '||p_header_id, 3 );
1047: oe_debug_pub.add('OEXVCMTB: p_commitment_id is: '||p_commitment_id, 3 );
1048: END IF;
1049:

Line 1046: oe_debug_pub.add('OEXVCMTB: p_header_id is: '||p_header_id, 3 );

1042:
1043: IF l_debug_level > 0 THEN
1044: oe_debug_pub.add('OEXVCMTB: Entering UPDATE_COMMITMENT_APPLIED FOR LINE_ID '||P_LINE_ID, 1 );
1045: oe_debug_pub.add('OEXVCMTB: p_amount is: '||p_amount, 3 );
1046: oe_debug_pub.add('OEXVCMTB: p_header_id is: '||p_header_id, 3 );
1047: oe_debug_pub.add('OEXVCMTB: p_commitment_id is: '||p_commitment_id, 3 );
1048: END IF;
1049:
1050: -- get the commitment balance

Line 1047: oe_debug_pub.add('OEXVCMTB: p_commitment_id is: '||p_commitment_id, 3 );

1043: IF l_debug_level > 0 THEN
1044: oe_debug_pub.add('OEXVCMTB: Entering UPDATE_COMMITMENT_APPLIED FOR LINE_ID '||P_LINE_ID, 1 );
1045: oe_debug_pub.add('OEXVCMTB: p_amount is: '||p_amount, 3 );
1046: oe_debug_pub.add('OEXVCMTB: p_header_id is: '||p_header_id, 3 );
1047: oe_debug_pub.add('OEXVCMTB: p_commitment_id is: '||p_commitment_id, 3 );
1048: END IF;
1049:
1050: -- get the commitment balance
1051: l_class := NULL;

Line 1062: oe_debug_pub.add('OEXVCMTB: commitment balance is '||l_commitment_bal, 1 );

1058: ,l_so_source_code
1059: ,l_oe_installed_flag );
1060:
1061: IF l_debug_level > 0 THEN
1062: oe_debug_pub.add('OEXVCMTB: commitment balance is '||l_commitment_bal, 1 );
1063: END IF;
1064:
1065: BEGIN
1066: SELECT nvl(commitment_applied_amount,0)

Line 1080: oe_debug_pub.add('OEXVCMTB: available commitment balance is '||l_commitment_bal, 1 );

1076:
1077: l_commitment_bal := l_commitment_bal + l_commitment_applied_amount;
1078:
1079: IF l_debug_level > 0 THEN
1080: oe_debug_pub.add('OEXVCMTB: available commitment balance is '||l_commitment_bal, 1 );
1081: END IF;
1082:
1083: IF p_amount <= l_commitment_bal THEN
1084: l_amount_to_apply := p_amount;

Line 1089: oe_debug_pub.add('OEXVCMTB: no sufficient balance '||l_amount_to_apply, 1 );

1085: ELSE
1086: l_amount_to_apply := l_commitment_bal;
1087:
1088: IF l_debug_level > 0 THEN
1089: oe_debug_pub.add('OEXVCMTB: no sufficient balance '||l_amount_to_apply, 1 );
1090: END IF;
1091:
1092: END IF;
1093:

Line 1095: oe_debug_pub.add('OEXVCMTB: amount to apply is '||l_amount_to_apply, 1 );

1091:
1092: END IF;
1093:
1094: IF l_debug_level > 0 THEN
1095: oe_debug_pub.add('OEXVCMTB: amount to apply is '||l_amount_to_apply, 1 );
1096: END IF;
1097:
1098: --bug 3560198
1099: IF l_debug_level > 0 THEN

Line 1100: oe_debug_pub.add('To display the commitment balance');

1096: END IF;
1097:
1098: --bug 3560198
1099: IF l_debug_level > 0 THEN
1100: oe_debug_pub.add('To display the commitment balance');
1101: END IF;
1102: l_new_commitment_bal := l_commitment_bal - l_amount_to_apply;
1103:
1104: IF l_debug_level > 0 THEN

Line 1105: oe_debug_pub.add('New commitment balance is : '||l_new_commitment_bal);

1101: END IF;
1102: l_new_commitment_bal := l_commitment_bal - l_amount_to_apply;
1103:
1104: IF l_debug_level > 0 THEN
1105: oe_debug_pub.add('New commitment balance is : '||l_new_commitment_bal);
1106: END IF;
1107:
1108: -- build currency format.
1109: IF g_fmt_mask IS NULL THEN

Line 1144: oe_debug_pub.add('OEXVCMTB: Exiting UPDATE_COMMITMENT_APPLIED. ', 1 );

1140: AND line_id = p_line_id
1141: AND payment_trx_id = p_commitment_id;
1142:
1143: IF l_debug_level > 0 THEN
1144: oe_debug_pub.add('OEXVCMTB: Exiting UPDATE_COMMITMENT_APPLIED. ', 1 );
1145: END IF;
1146:
1147: END update_commitment_applied;
1148: