DBA Data[Home] [Help]

APPS.OE_INVOICE_PUB dependencies on APP_EXCEPTIONS

Line 5841: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN -- Bug #3686558

5837: IF l_debug_level > 0 THEN
5838: oe_debug_pub.add( 'EXPECTED ERROR. EXITING INTERFACE_FREIGHT_CHARGES : '||SQLERRM , 1 ) ;
5839: END IF;
5840: x_return_status := FND_API.G_RET_STS_ERROR;
5841: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN -- Bug #3686558
5842: IF l_debug_level > 0 THEN
5843: OE_DEBUG_PUB.Add('Unable to lock the line',3);
5844: END IF;
5845: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 9003: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN

8999:
9000: exception
9001: --- bug# 7600960 : Start
9002: /*
9003: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
9004: IF l_debug_level > 0 THEN
9005: oe_debug_pub.add('in lock record exception, someone else working on the row');
9006: END IF;
9007: x_return_status := FND_API.G_RET_STS_ERROR;

Line 9015: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN

9011: OE_MSG_PUB.Add;
9012: RAISE FND_API.G_EXC_ERROR;
9013: */
9014:
9015: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
9016: IF l_debug_level > 0 THEN
9017: oe_debug_pub.add(' in lock record exception, someone else working on the row ');
9018: oe_debug_pub.add(' SQLERRM = '|| SQLERRM );
9019: oe_debug_pub.add( ' Unable to LOCK this Line. Going to make it DEFERRED so that it can be picked by another WFBP ');

Line 9521: when app_exceptions.RECORD_LOCK_EXCEPTION then

9517: IF l_debug_level > 0 THEN
9518: oe_debug_pub.add( 'locking: locked' , 5 ) ;
9519: END IF;
9520: EXCEPTION
9521: when app_exceptions.RECORD_LOCK_EXCEPTION then
9522: IF l_debug_level > 0 THEN
9523: oe_debug_pub.add( 'locking: cannot lock' , 5 ) ;
9524: END IF;
9525: x_return_status := 'DEFERRED';