5593: IF l_debug_level > 0 THEN
5594: oe_debug_pub.add( 'EXPECTED ERROR. EXITING INTERFACE_FREIGHT_CHARGES : '||SQLERRM , 1 ) ;
5595: END IF;
5596: x_return_status := FND_API.G_RET_STS_ERROR;
5597: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN -- Bug #3686558
5598: IF l_debug_level > 0 THEN
5599: OE_DEBUG_PUB.Add('Unable to lock the line',3);
5600: END IF;
5601: x_return_status := FND_API.G_RET_STS_SUCCESS;
8579:
8580: exception
8581: --- bug# 7600960 : Start
8582: /*
8583: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
8584: IF l_debug_level > 0 THEN
8585: oe_debug_pub.add('in lock record exception, someone else working on the row');
8586: END IF;
8587: x_return_status := FND_API.G_RET_STS_ERROR;
8591: OE_MSG_PUB.Add;
8592: RAISE FND_API.G_EXC_ERROR;
8593: */
8594:
8595: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
8596: IF l_debug_level > 0 THEN
8597: oe_debug_pub.add(' in lock record exception, someone else working on the row ');
8598: oe_debug_pub.add(' SQLERRM = '|| SQLERRM );
8599: oe_debug_pub.add( ' Unable to LOCK this Line. Going to make it DEFERRED so that it can be picked by another WFBP ');
8957: IF l_debug_level > 0 THEN
8958: oe_debug_pub.add( 'locking: locked' , 5 ) ;
8959: END IF;
8960: EXCEPTION
8961: when app_exceptions.RECORD_LOCK_EXCEPTION then
8962: IF l_debug_level > 0 THEN
8963: oe_debug_pub.add( 'locking: cannot lock' , 5 ) ;
8964: END IF;
8965: x_return_status := 'DEFERRED';