DBA Data[Home] [Help]

APPS.ZX_VTX_USER_PKG dependencies on ZX_EXEMPTIONS

Line 1040: FROM ZX_EXEMPTIONS EXMP

1036: /*Proceed further only if the exemption id fetched is not null*/
1037: BEGIN
1038: SELECT rate_modifier
1039: INTO x_exempt_record.percent_exempt
1040: FROM ZX_EXEMPTIONS EXMP
1041: WHERE tax_exemption_id = x_exempt_record.exemption_id;
1042: EXCEPTION WHEN NO_DATA_FOUND THEN
1043: IF (g_level_exception >= g_current_runtime_level ) THEN
1044: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

Line 1047: g_string :='No Data found from ZX_EXEMPTIONS for provided id';

1043: IF (g_level_exception >= g_current_runtime_level ) THEN
1044: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1045: END IF;
1046: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR;
1047: g_string :='No Data found from ZX_EXEMPTIONS for provided id';
1048: error_exception_handle(g_string);
1049: --x_messages_tbl:=g_messages_tbl;
1050: RETURN;
1051: END;