DBA Data[Home] [Help]

APPS.ZX_VTX_USER_PKG dependencies on ZX_EXEMPTIONS

Line 1148: FROM ZX_EXEMPTIONS EXMP

1144: /*Proceed further only if the exemption id fetched is not null*/
1145: BEGIN
1146: SELECT rate_modifier
1147: INTO x_exempt_record.percent_exempt
1148: FROM ZX_EXEMPTIONS EXMP
1149: WHERE tax_exemption_id = x_exempt_record.exemption_id;
1150: EXCEPTION WHEN NO_DATA_FOUND THEN
1151: IF (g_level_exception >= g_current_runtime_level ) THEN
1152: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

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

1151: IF (g_level_exception >= g_current_runtime_level ) THEN
1152: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1153: END IF;
1154: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR;
1155: g_string :='No Data found from ZX_EXEMPTIONS for provided id';
1156: error_exception_handle(g_string);
1157: --x_messages_tbl:=g_messages_tbl;
1158: RETURN;
1159: END;