APPS.ZX_TCM_GET_DEF_EXEMPTION dependencies on FND_API

Line 188: x_return_status := FND_API.G_RET_STS_SUCCESS;

184: END IF;
185:
186: -- Initialize API return status to success.
187:
188: x_return_status := FND_API.G_RET_STS_SUCCESS;
189:
190: -- Logging Infra: Statement level: "B" means "B"reak point
191: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
192: l_log_msg := 'B: SEL hz_locations: in: p_ship_to_party_site_id='||p_ship_to_party_site_id;

Line 215: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

211: p_org_id,
212: l_ptp_id,
213: x_return_status);
214:
215: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
216: RAISE FND_API.G_EXC_ERROR;
217: END IF;
218:
219: OPEN get_default_exemptions(l_country_code,l_ptp_id);

Line 216: RAISE FND_API.G_EXC_ERROR;

212: l_ptp_id,
213: x_return_status);
214:
215: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
216: RAISE FND_API.G_EXC_ERROR;
217: END IF;
218:
219: OPEN get_default_exemptions(l_country_code,l_ptp_id);
220: FETCH get_default_exemptions BULK COLLECT INTO l_exemption_rec_tbl;

Line 247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

243: close get_default_exemptions;
244:
245: EXCEPTION
246: WHEN OTHERS THEN
247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
248: -- Logging Infra: Statement level
249: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
250: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, 'E: EXC: OTHERS: '
251: || SQLCODE||': '||SQLERRM);