DBA Data[Home] [Help]

APPS.OE_OEOL_SCH dependencies on APP_EXCEPTIONS

Line 443: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN

439: IF l_debug_level > 0 THEN
440: oe_debug_pub.add( 'MODEL LOCKED '||TO_CHAR ( SYSDATE , 'DD-MM-YYYY HH24:MI:SS' ) , 3 ) ;
441: END IF;
442: EXCEPTION
443: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
444: IF l_debug_level > 0 THEN
445: oe_debug_pub.add('SCHEDULE_LINE: unable to lock the top model line:'||l_top_model_line_id,1);
446: END IF;
447: resultout := 'COMPLETE:INCOMPLETE';

Line 461: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN

457: WHERE line_id = l_child_line_id
458: FOR UPDATE NOWAIT; --11868761
459:
460: EXCEPTION
461: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
462: IF l_debug_level > 0 THEN
463: oe_debug_pub.add('SCHEDULE_LINE: unable to lock the line:'||l_child_line_id,1);
464: END IF;
465: resultout := 'COMPLETE:INCOMPLETE';

Line 1493: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN

1489: FROM oe_order_lines_all
1490: WHERE line_id = l_line_rec.line_id
1491: FOR UPDATE NOWAIT;
1492: EXCEPTION
1493: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1494: IF l_debug_level > 0 THEN
1495: oe_debug_pub.add('OEXWSCHB.pls: unable to lock the line:'||l_line_id,1);
1496: END IF;
1497: resultout := 'DEFERRED';