1236:
1237: l_row_count := SQL%ROWCOUNT;
1238:
1239: /* bug#4374237
1240: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1241: FND_MESSAGE.SET_NAME('FND','ZX_TRL_ROWS_DELETED');
1242: FND_MESSAGE.SET_TOKEN('ROWS_DELETED',l_row_count);
1243: FND_MSG_PUB.Add;
1244: END IF;
1239: /* bug#4374237
1240: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1241: FND_MESSAGE.SET_NAME('FND','ZX_TRL_ROWS_DELETED');
1242: FND_MESSAGE.SET_TOKEN('ROWS_DELETED',l_row_count);
1243: FND_MSG_PUB.Add;
1244: END IF;
1245: */
1246:
1247: IF (g_level_procedure >= g_current_runtime_level ) THEN
1612:
1613: l_row_count := SQL%ROWCOUNT;
1614:
1615: /* bug#4374237
1616: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1617: FND_MESSAGE.SET_NAME('FND','ZX_TRL_ROWS_DELETED');
1618: FND_MESSAGE.SET_TOKEN('ROWS_DELETED',l_row_count);
1619: FND_MSG_PUB.Add;
1620: END IF;
1615: /* bug#4374237
1616: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1617: FND_MESSAGE.SET_NAME('FND','ZX_TRL_ROWS_DELETED');
1618: FND_MESSAGE.SET_TOKEN('ROWS_DELETED',l_row_count);
1619: FND_MSG_PUB.Add;
1620: END IF;
1621: */
1622:
1623: IF (g_level_procedure >= g_current_runtime_level ) THEN
1788: 'Return Status = '||x_return_status);
1789: END IF;
1790:
1791: /* bug#4374237
1792: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1793: FND_MESSAGE.SET_NAME('FND','ZX_TRL_ROWS_NOT_FOUND');
1794: FND_MSG_PUB.Add;
1795: END IF;
1796: */
1790:
1791: /* bug#4374237
1792: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1793: FND_MESSAGE.SET_NAME('FND','ZX_TRL_ROWS_NOT_FOUND');
1794: FND_MSG_PUB.Add;
1795: END IF;
1796: */
1797:
1798: WHEN FND_API.G_EXC_ERROR THEN
2532: 'Return Status = '||x_return_status);
2533: END IF;
2534:
2535: /* bug#4374237
2536: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2537: FND_MESSAGE.SET_NAME('FND','ZX_TRL_ROWS_NOT_FOUND');
2538: FND_MSG_PUB.Add;
2539: END IF;
2540: */
2534:
2535: /* bug#4374237
2536: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2537: FND_MESSAGE.SET_NAME('FND','ZX_TRL_ROWS_NOT_FOUND');
2538: FND_MSG_PUB.Add;
2539: END IF;
2540: */
2541:
2542: WHEN FND_API.G_EXC_ERROR THEN
3563: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3564: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3565:
3566: FND_MESSAGE.SET_NAME('ZX','ZX_UNEXPECTED_ERROR');
3567: FND_MSG_PUB.Add;
3568:
3569: IF (g_level_procedure >= g_current_runtime_level ) THEN
3570: FND_LOG.STRING(g_level_procedure,
3571: 'ZX.PLSQL.ZX_TRL_MANAGE_TAX_PKG.Update_Freeze_Flag',