APPS.ZX_TCM_GET_EXEMPT_PKG dependencies on FND_API

Line 302: RAISE FND_API.G_EXC_ERROR;

298: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
299: FND_LOG.string(G_LEVEL_UNEXPECTED,G_MODULE_NAME,
300: 'There is no exempt reason lookup type for this exempt reason.');
301: END IF;
302: RAISE FND_API.G_EXC_ERROR;
303: IF EXEMPTIONS1%ISOPEN THEN
304: CLOSE EXEMPTIONS1;
305: END IF;
306: WHEN OTHERS THEN

Line 311: RAISE FND_API.G_EXC_ERROR;

307: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
308: FND_LOG.string(G_LEVEL_UNEXPECTED,G_MODULE_NAME,
309: 'Failed when trying to get the meaning for Reason Code due to '||SQLERRM);
310: END IF;
311: RAISE FND_API.G_EXC_ERROR;
312: IF EXEMPTIONS1%ISOPEN THEN
313: CLOSE EXEMPTIONS1;
314: END IF;
315: END;

Line 363: RAISE FND_API.G_EXC_ERROR;

359: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
360: FND_LOG.string(G_LEVEL_UNEXPECTED,G_MODULE_NAME,
361: 'There is no exempt reason lookup type for this exempt reason.');
362: END IF;
363: RAISE FND_API.G_EXC_ERROR;
364: IF EXEMPTIONS2%ISOPEN THEN
365: CLOSE EXEMPTIONS2;
366: END IF;
367: WHEN OTHERS THEN

Line 372: RAISE FND_API.G_EXC_ERROR;

368: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
369: FND_LOG.string(G_LEVEL_UNEXPECTED,G_MODULE_NAME,
370: 'Failed when trying to get the meaning for Reason Code due to '||SQLERRM);
371: END IF;
372: RAISE FND_API.G_EXC_ERROR;
373: IF EXEMPTIONS2%ISOPEN THEN
374: CLOSE EXEMPTIONS2;
375: END IF;
376: END;

Line 423: RAISE FND_API.G_EXC_ERROR;

419: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
420: FND_LOG.string(G_LEVEL_UNEXPECTED,G_MODULE_NAME,
421: 'There is no exempt reason lookup type for this exempt reason.');
422: END IF;
423: RAISE FND_API.G_EXC_ERROR;
424: WHEN OTHERS THEN
425: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
426: FND_LOG.string(G_LEVEL_UNEXPECTED,G_MODULE_NAME,
427: 'Failed when trying to get the meaning for Reason Code due to '||SQLERRM);

Line 429: RAISE FND_API.G_EXC_ERROR;

425: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
426: FND_LOG.string(G_LEVEL_UNEXPECTED,G_MODULE_NAME,
427: 'Failed when trying to get the meaning for Reason Code due to '||SQLERRM);
428: END IF;
429: RAISE FND_API.G_EXC_ERROR;
430: IF EXEMPTIONS3%ISOPEN THEN
431: CLOSE EXEMPTIONS3;
432: END IF;
433: IF EXEMPTIONS3%ISOPEN THEN

Line 673: x_return_status := FND_API.G_RET_STS_SUCCESS;

669: ;
670: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || 'Get_tax_exemptions', l_log_msg);
671: END IF;
672:
673: x_return_status := FND_API.G_RET_STS_SUCCESS;
674: IF p_exempt_control_flag = 'E' and p_reason_code is null THEN
675: x_return_status := FND_API.G_RET_STS_ERROR;
676: FND_MESSAGE.SET_NAME('ZX', 'ZX_TCM_NO_EXEMPT_REASON');
677: RAISE FND_API.G_EXC_ERROR;

Line 675: x_return_status := FND_API.G_RET_STS_ERROR;

671: END IF;
672:
673: x_return_status := FND_API.G_RET_STS_SUCCESS;
674: IF p_exempt_control_flag = 'E' and p_reason_code is null THEN
675: x_return_status := FND_API.G_RET_STS_ERROR;
676: FND_MESSAGE.SET_NAME('ZX', 'ZX_TCM_NO_EXEMPT_REASON');
677: RAISE FND_API.G_EXC_ERROR;
678:
679: END IF;

Line 677: RAISE FND_API.G_EXC_ERROR;

673: x_return_status := FND_API.G_RET_STS_SUCCESS;
674: IF p_exempt_control_flag = 'E' and p_reason_code is null THEN
675: x_return_status := FND_API.G_RET_STS_ERROR;
676: FND_MESSAGE.SET_NAME('ZX', 'ZX_TCM_NO_EXEMPT_REASON');
677: RAISE FND_API.G_EXC_ERROR;
678:
679: END IF;
680:
681: IF nvl(p_multiple_jurisdictions_flag,'N') = 'N' THEN