249: END IF;
250:
251: -- initialize message list if p_init_msg_list is set to true
252: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then
253: fnd_msg_pub.initialize;
254: end if;
255:
256: -- initialize return status to success
257: x_return_status := fnd_api.g_ret_sts_success;
308: END IF;
309:
310: x_return_status := FND_API.G_RET_STS_ERROR;
311:
312: fnd_msg_pub.count_and_get(p_count => x_msg_count,
313: p_data => x_msg_data);
314:
315: WHEN OTHERS THEN
316: IF p_commit = FND_API.G_TRUE THEN
318: END IF;
319:
320: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
321:
322: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AMW_COMPLIANCE_ENV_ASSOCS_PVT',
323: p_procedure_name => 'PROCESS_COMPLIANCE_ENV_ASSOCS',
324: p_error_text => SUBSTRB(SQLERRM,1,240));
325:
326: fnd_msg_pub.count_and_get(p_count => x_msg_count,
322: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AMW_COMPLIANCE_ENV_ASSOCS_PVT',
323: p_procedure_name => 'PROCESS_COMPLIANCE_ENV_ASSOCS',
324: p_error_text => SUBSTRB(SQLERRM,1,240));
325:
326: fnd_msg_pub.count_and_get(p_count => x_msg_count,
327: p_data => x_msg_data);
328:
329: END PROCESS_COMPLIANCE_ENV_ASSOCS;
330: