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_PAYMENTS_UTIL dependencies on OE_DEBUG_PUB

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

12: IS
13: l_lock_control NUMBER;
14:
15: --
16: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
17: --
18: BEGIN
19:
20: -- increment lock_control by 1 whenever the record is updated

Line 54: oe_debug_pub.add( 'EXITING OE_PAYMENTS_UTIL.UPDATE_ROW.' , 1 ) ;

50: ;
51:
52: -- p_payment_types_rec.lock_control := l_lock_control;
53: IF l_debug_level > 0 THEN
54: oe_debug_pub.add( 'EXITING OE_PAYMENTS_UTIL.UPDATE_ROW.' , 1 ) ;
55: END IF;
56:
57: EXCEPTION
58:

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

77: IS
78: l_lock_control NUMBER := 1;
79:
80: --
81: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
82: --
83: BEGIN
84:
85:

Line 175: oe_debug_pub.add( 'EXITING OE_PAYMENTS_UTIL.INSERT_ROW.' , 1 ) ;

171: );
172:
173: -- p_payment_types_rec.lock_control := l_lock_control;
174: IF l_debug_level > 0 THEN
175: oe_debug_pub.add( 'EXITING OE_PAYMENTS_UTIL.INSERT_ROW.' , 1 ) ;
176: END IF;
177:
178: EXCEPTION
179: WHEN DUP_VAL_ON_INDEX Then

Line 195: oe_debug_pub.add( G_PKG_NAME||':INSER_ROW:'||SQLERRM ) ;

191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
192:
193: WHEN OTHERS THEN
194: IF l_debug_level > 0 THEN
195: oe_debug_pub.add( G_PKG_NAME||':INSER_ROW:'||SQLERRM ) ;
196: END IF;
197: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
198: THEN
199: FND_MSG_PUB.Add_Exc_Msg

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

217: IS
218: l_return_status VARCHAR2(30);
219:
220: --
221: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
222: --
223: BEGIN
224:
225: IF l_debug_level > 0 THEN

Line 226: oe_debug_pub.add( 'ENTERING DELETING COMMITMENT FOR LINE: '||P_LINE_ID , 1 ) ;

222: --
223: BEGIN
224:
225: IF l_debug_level > 0 THEN
226: oe_debug_pub.add( 'ENTERING DELETING COMMITMENT FOR LINE: '||P_LINE_ID , 1 ) ;
227: END IF;
228:
229: IF p_payment_trx_id IS NOT NULL AND p_payment_trx_id <> FND_API.G_MISS_NUM THEN
230: DELETE FROM oe_payments

Line 246: oe_debug_pub.add( G_PKG_NAME||':DELETE_ROW:'||SQLERRM ) ;

242: EXCEPTION
243:
244: WHEN OTHERS THEN
245: IF l_debug_level > 0 THEN
246: oe_debug_pub.add( G_PKG_NAME||':DELETE_ROW:'||SQLERRM ) ;
247: END IF;
248: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
249: THEN
250: FND_MSG_PUB.Add_Exc_Msg

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

389: AND header_id = p_header_id
390: ;
391:
392: --
393: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
394: --
395: BEGIN
396:
397: /***

Line 499: oe_debug_pub.add( G_PKG_NAME||':QUERY_ROW:'||SQLERRM ) ;

495: EXCEPTION
496:
497: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
498: IF l_debug_level > 0 THEN
499: oe_debug_pub.add( G_PKG_NAME||':QUERY_ROW:'||SQLERRM ) ;
500: END IF;
501: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
502:
503: WHEN OTHERS THEN

Line 505: oe_debug_pub.add( G_PKG_NAME||':QUERY_ROW:'||SQLERRM ) ;

501: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
502:
503: WHEN OTHERS THEN
504: IF l_debug_level > 0 THEN
505: oe_debug_pub.add( G_PKG_NAME||':QUERY_ROW:'||SQLERRM ) ;
506: END IF;
507: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
508: THEN
509: FND_MSG_PUB.Add_Exc_Msg

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

523: )
524: RETURN NUMBER IS
525:
526: l_uninv_commitment_bal NUMBER := 0;
527: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
528: BEGIN
529: IF l_debug_level > 0 THEN
530: oe_debug_pub.add('ENTERING OE_PAYMENTS_UTIL.GET_UNINVOICED_COMMITMENT_BAL');
531: END IF;

Line 530: oe_debug_pub.add('ENTERING OE_PAYMENTS_UTIL.GET_UNINVOICED_COMMITMENT_BAL');

526: l_uninv_commitment_bal NUMBER := 0;
527: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
528: BEGIN
529: IF l_debug_level > 0 THEN
530: oe_debug_pub.add('ENTERING OE_PAYMENTS_UTIL.GET_UNINVOICED_COMMITMENT_BAL');
531: END IF;
532:
533: --14723264 IF OE_INSTALL.Get_Active_Product = 'ONT' THEN
534:

Line 545: oe_debug_pub.add('pviprana: l_uninv_commitment_bal is ' || l_uninv_commitment_bal);

541: INTO l_uninv_commitment_bal
542: FROM oe_payments opt
543: WHERE opt.payment_trx_id = p_customer_trx_id;
544: IF l_debug_level > 0 THEN
545: oe_debug_pub.add('pviprana: l_uninv_commitment_bal is ' || l_uninv_commitment_bal);
546: oe_debug_pub.add('pviprana: p_customer_trx_id is ' || p_customer_trx_id);
547: END IF;
548: ELSE
549: -- when profile options is set to NO

Line 546: oe_debug_pub.add('pviprana: p_customer_trx_id is ' || p_customer_trx_id);

542: FROM oe_payments opt
543: WHERE opt.payment_trx_id = p_customer_trx_id;
544: IF l_debug_level > 0 THEN
545: oe_debug_pub.add('pviprana: l_uninv_commitment_bal is ' || l_uninv_commitment_bal);
546: oe_debug_pub.add('pviprana: p_customer_trx_id is ' || p_customer_trx_id);
547: END IF;
548: ELSE
549: -- when profile options is set to NO
550: SELECT

Line 565: oe_debug_pub.add('pviprana: l_uninv_commitment_bal is ' || l_uninv_commitment_bal);

561: AND NVL(line_category_code,'STANDARD') <> 'RETURN'
562: AND NVL(invoice_interface_status_code,'NO') <> 'YES';
563:
564: IF l_debug_level > 0 THEN
565: oe_debug_pub.add('pviprana: l_uninv_commitment_bal is ' || l_uninv_commitment_bal);
566: oe_debug_pub.add('pviprana: p_customer_trx_id is ' || p_customer_trx_id);
567: END IF;
568: END IF; --bug3567339 end
569:

Line 566: oe_debug_pub.add('pviprana: p_customer_trx_id is ' || p_customer_trx_id);

562: AND NVL(invoice_interface_status_code,'NO') <> 'YES';
563:
564: IF l_debug_level > 0 THEN
565: oe_debug_pub.add('pviprana: l_uninv_commitment_bal is ' || l_uninv_commitment_bal);
566: oe_debug_pub.add('pviprana: p_customer_trx_id is ' || p_customer_trx_id);
567: END IF;
568: END IF; --bug3567339 end
569:
570: /*14723264 start