2219: p_encoded => FND_API.G_FALSE,
2220: p_count => x_msg_count,
2221: p_data => x_msg_data);
2222:
2223: UPDATE HZ_MATCH_RULES_B SET COMPILATION_FLAG = 'C' WHERE MATCH_RULE_ID = p_match_rule_id;
2224: COMMIT;
2225: EXCEPTION
2226: WHEN FND_API.G_EXC_ERROR THEN
2227: FND_MSG_PUB.Count_And_Get(
2228: p_encoded => FND_API.G_FALSE,
2229: p_count => x_msg_count,
2230: p_data => x_msg_data);
2231: x_return_status := FND_API.G_RET_STS_ERROR;
2232: UPDATE HZ_MATCH_RULES_B SET COMPILATION_FLAG = 'U' WHERE MATCH_RULE_ID = p_match_rule_id;
2233: COMMIT;
2234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2235: FND_MSG_PUB.Count_And_Get(
2236: p_encoded => FND_API.G_FALSE,
2236: p_encoded => FND_API.G_FALSE,
2237: p_count => x_msg_count,
2238: p_data => x_msg_data);
2239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2240: UPDATE HZ_MATCH_RULES_B SET COMPILATION_FLAG = 'U' WHERE MATCH_RULE_ID = p_match_rule_id;
2241: COMMIT;
2242: WHEN OTHERS THEN
2243:
2244: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2250: p_encoded => FND_API.G_FALSE,
2251: p_count => x_msg_count,
2252: p_data => x_msg_data);
2253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2254: UPDATE HZ_MATCH_RULES_B SET COMPILATION_FLAG = 'U' WHERE MATCH_RULE_ID = p_match_rule_id;
2255: COMMIT;
2256: END;
2257:
2258: