[Home] [Help]
1397: FROM oe_order_lines_all
1398: WHERE line_id= l_line_id
1399: FOR UPDATE; --Commented for bug 6415831 --nowait;
1400: EXCEPTION
1401: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1402: IF l_debug_level > 0 THEN
1403: oe_debug_pub.add('OEXVITMB.pls: unable to lock the line',1);
1404: END IF;
1405: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
1464:
1465: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1466: OE_STANDARD_WF.Save_Messages;
1467: OE_STANDARD_WF.Clear_Msg_Context;
1468: APP_EXCEPTION.Raise_Exception;
1469: END IF;
1470:
1471: WF_ENGINE.CompleteActivityInternalName(
1472: 'OEOL',
1609:
1610: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1611: OE_STANDARD_WF.Save_Messages;
1612: OE_STANDARD_WF.Clear_Msg_Context;
1613: APP_EXCEPTION.Raise_Exception;
1614: END IF;
1615:
1616: WF_ENGINE.CompleteActivityInternalName('OEOL',
1617: to_char(l_line_id),
1659:
1660: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1661: OE_STANDARD_WF.Save_Messages;
1662: OE_STANDARD_WF.Clear_Msg_Context;
1663: APP_EXCEPTION.Raise_Exception;
1664: END IF;
1665:
1666: WF_ENGINE.CompleteActivityInternalName('OEOL',
1667: to_char(l_line_id),
1708:
1709: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1710: OE_STANDARD_WF.Save_Messages;
1711: OE_STANDARD_WF.Clear_Msg_Context;
1712: APP_EXCEPTION.Raise_Exception;
1713: END IF;
1714:
1715: WF_ENGINE.CompleteActivityInternalName('OEOL',
1716: to_char(l_line_id),
1727:
1728: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1729: OE_STANDARD_WF.Save_Messages;
1730: OE_STANDARD_WF.Clear_Msg_Context;
1731: APP_EXCEPTION.Raise_Exception;
1732: END IF;
1733:
1734: WF_ENGINE.CompleteActivityInternalName('OEOL',
1735: to_char(l_line_id),