153: l_count := 0;
154: IF ((p_int_val_rec.reason_id IS NOT NULL) AND (p_int_val_rec.reason_id <> fnd_api.g_miss_num)) THEN
155: BEGIN
156: SELECT count(*) into l_count
157: FROM jtf_ih_reasons_B
158: WHERE reason_id = p_int_val_rec.reason_id;
159: IF (l_count <= 0) THEN
160: x_return_status := fnd_api.g_ret_sts_error;
161: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_int_val_rec.reason_id),
472: l_count := 0;
473: IF ((p_act_val_rec.reason_id IS NOT NULL) AND (p_act_val_rec.reason_id <> fnd_api.g_miss_num)) THEN
474: BEGIN
475: SELECT count(*) into l_count
476: FROM jtf_ih_reasons_B
477: WHERE reason_id = p_act_val_rec.reason_id;
478: IF (l_count <= 0) THEN
479: x_return_status := fnd_api.g_ret_sts_error;
480: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_act_val_rec.reason_id),