DBA Data[Home] [Help]

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 245: oe_debug_pub.add( G_PKG_NAME||':DELETE_ROW:'||SQLERRM ) ;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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