82: BEGIN
83:
84:
85:
86: x_return_status := FND_API.G_RET_STS_SUCCESS;
87:
88:
89: --
90: -- Build SQL Strings by View ------------------------------------
631:
632: WHEN OTHERS THEN
633: x_msg_count := 1;
634: x_msg_data := SUBSTR(SQLERRM, 1, 240);
635: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
636: FND_MSG_PUB.add_Exc_msg(
637: p_pkg_name => G_PKG_NAME,
638: p_procedure_name => l_api_name);
639:
692: BEGIN
693:
694: SAVEPOINT AK_Label_Pvt;
695:
696: x_return_status := FND_API.G_RET_STS_SUCCESS;
697:
698: l_counter := 1;
699:
700: /* Commenting the call to Update_Item_Long_Label for bug 3684384
743:
744: WHEN OTHERS THEN
745: x_msg_count := 1;
746: x_msg_data := SUBSTR(SQLERRM, 1, 240);
747: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
748: ROLLBACK TO AK_Label_Pvt;
749: FND_MSG_PUB.add_Exc_msg(
750: p_pkg_name => G_PKG_NAME,
751: p_procedure_name => l_api_name);