DBA Data[Home] [Help]

APPS.OE_SHIP_CONFIRMATION_PUB dependencies on APP_EXCEPTIONS

Line 540: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN

536: FOR UPDATE NOWAIT;
537:
538: EXCEPTION
539:
540: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
541: IF l_debug_level > 0 THEN
542: OE_DEBUG_PUB.Add('Unable to lock the line/parent',3);
543: END IF;
544: RAISE FND_API.G_EXC_ERROR;

Line 3506: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN

3502: oe_debug_pub.add('leaving Remove_Lines_From_Shipset',3);
3503: END IF;
3504:
3505: EXCEPTION
3506: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
3507: IF l_debug_level > 0 THEN
3508: OE_DEBUG_PUB.Add('Unable to lock the line',3);
3509: END IF;
3510: OE_Msg_Pub.Add_Text('Could not obtain Lock on Order Line/s');

Line 3689: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN

3685:
3686: -- 4396294
3687:
3688: EXCEPTION
3689: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
3690: IF l_debug_level > 0 THEN
3691: OE_DEBUG_PUB.Add('Unable to lock the line',3);
3692: END IF;
3693: OE_Msg_Pub.Add_Text('Could not obtain Lock on Order Line/s');

Line 3718: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN

3714: END IF;
3715: END IF ;
3716:
3717: EXCEPTION
3718: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
3719: IF l_debug_level > 0 THEN
3720: OE_DEBUG_PUB.Add('Unable to lock the ship set :' || l_ship_set_id ,3);
3721: END IF;
3722: OE_Msg_Pub.Add_Text('Could not obtain Lock on Ship Set');

Line 3748: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN

3744: END IF;
3745: END IF ;
3746:
3747: EXCEPTION
3748: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
3749: IF l_debug_level > 0 THEN
3750: OE_DEBUG_PUB.Add('Unable to lock the arrival set :' || l_arrival_set_id ,3);
3751: END IF;
3752: OE_Msg_Pub.Add_Text('Could not obtain Lock on Arrival Set');

Line 4050: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN

4046: Oe_Debug_pub.Add('leaving handle_nonbulk_mode '||x_return_status, 3);
4047: END IF;
4048:
4049: EXCEPTION
4050: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
4051: IF l_debug_level > 0 THEN
4052: OE_DEBUG_PUB.Add('Unable to lock the line',3);
4053: END IF;
4054: OE_Msg_Pub.Add_Text('Could not obtain Lock on Order Line/s');

Line 4668: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN

4664: oe_debug_pub.add('leaving Handle_Bulk_Mode_Per_Order '|| x_return_status, 1);
4665: END IF;
4666:
4667: EXCEPTION
4668: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
4669: IF l_debug_level > 0 THEN
4670: OE_DEBUG_PUB.Add('Unable to lock the line',3);
4671: END IF;
4672: OE_Msg_Pub.Add_Text('Could not obtain Lock on Order Line/s');