324: END LOOP;
325: EXCEPTION WHEN OTHERS THEN
326: rollback to INSERT_AUDIT_UNITS_PVT;
327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
328: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name, l_api_name);
329: FND_MSG_PUB.Count_And_Get(
330: p_encoded => FND_API.G_FALSE,
331: p_count => x_msg_count,
332: p_data => x_msg_data);
325: EXCEPTION WHEN OTHERS THEN
326: rollback to INSERT_AUDIT_UNITS_PVT;
327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
328: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name, l_api_name);
329: FND_MSG_PUB.Count_And_Get(
330: p_encoded => FND_API.G_FALSE,
331: p_count => x_msg_count,
332: p_data => x_msg_data);
333: END Insert_Audit_Units;
400:
401: -- Initialize message list if p_init_msg_list is set to TRUE.
402: IF FND_API.to_Boolean( p_init_msg_list )
403: THEN
404: FND_MSG_PUB.initialize;
405: END IF;
406:
407: -- Initialize API return status to SUCCESS
408: x_return_status := FND_API.G_RET_STS_SUCCESS;
656:
657: EXCEPTION WHEN OTHERS THEN
658: rollback to INSERT_SPEC_AUDIT_UNITS_PVT;
659: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
660: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
661: FND_MSG_PUB.Count_And_Get(
662: p_encoded => FND_API.G_FALSE,
663: p_count => x_msg_count,
664: p_data => x_msg_data);
657: EXCEPTION WHEN OTHERS THEN
658: rollback to INSERT_SPEC_AUDIT_UNITS_PVT;
659: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
660: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
661: FND_MSG_PUB.Count_And_Get(
662: p_encoded => FND_API.G_FALSE,
663: p_count => x_msg_count,
664: p_data => x_msg_data);
665: END insert_specific_audit_units;