APPS.ZX_MERGE_LOC_CHECK_PKG dependencies on FND_API

Line 35: x_return_status := FND_API.G_RET_STS_SUCCESS;

31: l_to_tax_usage_exists VARCHAR2(6);
32: l_from_geography_id_count NUMBER;
33: l_to_geography_id_count NUMBER;
34: BEGIN
35: x_return_status := FND_API.G_RET_STS_SUCCESS;
36: x_merge_yn := 'N';
37: BEGIN
38: SELECT 'TRUE'
39: INTO l_from_tax_usage_exists

Line 188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

184: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
185: END IF;
186: END IF;
187: EXCEPTION WHEN OTHERS THEN
188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
189: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
190: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
191: FND_MSG_PUB.ADD;
192: FND_MSG_PUB.Count_And_Get(

Line 193: p_encoded => FND_API.G_FALSE,

189: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
190: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
191: FND_MSG_PUB.ADD;
192: FND_MSG_PUB.Count_And_Get(
193: p_encoded => FND_API.G_FALSE,
194: p_count => x_msg_count,
195: p_data => x_msg_data);
196:
197: -- Logging Infra: Statement level