22: WHERE task_id = p_action_input_data_list(i).value;
23: EXCEPTION
24: WHEN OTHERS THEN
25: x_mesg_data_char := '';
26: x_return_status:=fnd_api.g_ret_sts_error;
27: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_MESSAGE_ACTION_FAILED');
28: FND_MESSAGE.SET_TOKEN('DETAILS', sqlerrm);
29:
30: fnd_msg_pub.ADD;
33: p_count => x_msg_count,
34: p_data => x_msg_data
35: );
36:
37: RAISE fnd_api.g_exc_error;
38: END;
39: end if;
40:
41: END LOOP;
39: end if;
40:
41: END LOOP;
42:
43: x_return_status :=fnd_api.g_ret_sts_success;
44:
45: fnd_msg_pub.Count_And_Get(p_count => x_msg_count,
46: p_data => x_msg_data);
47:
46: p_data => x_msg_data);
47:
48: EXCEPTION
49:
50: when fnd_api.g_exc_error then
51: x_return_status:=fnd_api.g_ret_sts_error;
52:
53: when fnd_api.g_exc_unexpected_error then
54: x_return_status:=fnd_api.g_ret_sts_unexp_error;
47:
48: EXCEPTION
49:
50: when fnd_api.g_exc_error then
51: x_return_status:=fnd_api.g_ret_sts_error;
52:
53: when fnd_api.g_exc_unexpected_error then
54: x_return_status:=fnd_api.g_ret_sts_unexp_error;
55:
49:
50: when fnd_api.g_exc_error then
51: x_return_status:=fnd_api.g_ret_sts_error;
52:
53: when fnd_api.g_exc_unexpected_error then
54: x_return_status:=fnd_api.g_ret_sts_unexp_error;
55:
56: when others then
57: x_return_status:=fnd_api.g_ret_sts_unexp_error;
50: when fnd_api.g_exc_error then
51: x_return_status:=fnd_api.g_ret_sts_error;
52:
53: when fnd_api.g_exc_unexpected_error then
54: x_return_status:=fnd_api.g_ret_sts_unexp_error;
55:
56: when others then
57: x_return_status:=fnd_api.g_ret_sts_unexp_error;
58:
53: when fnd_api.g_exc_unexpected_error then
54: x_return_status:=fnd_api.g_ret_sts_unexp_error;
55:
56: when others then
57: x_return_status:=fnd_api.g_ret_sts_unexp_error;
58:
59: fnd_msg_pub.Count_And_Get(p_count => x_msg_count,
60: p_data => x_msg_data);
61: