6351: lx_return_status VARCHAR2(1);
6352:
6353: l_request_id NUMBER;
6354: l_row_count NUMBER;
6355: l_msg_idx INTEGER := FND_MSG_PUB.G_FIRST;
6356: lx_error_rec OKL_API.error_rec_type;
6357:
6358: CURSOR req_id_csr IS
6359: SELECT
6460:
6461: -- Get the messages in the log
6462: LOOP
6463:
6464: fnd_msg_pub.get(
6465: p_msg_index => l_msg_idx,
6466: p_encoded => FND_API.G_FALSE,
6467: p_data => lx_error_rec.msg_data,
6468: p_msg_index_out => lx_error_rec.msg_count);
6473: fnd_file.put_line(fnd_file.output, lx_error_rec.msg_data);
6474:
6475: END IF;
6476:
6477: EXIT WHEN ((lx_error_rec.msg_count = FND_MSG_PUB.COUNT_MSG)
6478: OR (lx_error_rec.msg_count IS NULL));
6479:
6480: l_msg_idx := FND_MSG_PUB.G_NEXT;
6481: END LOOP;
6476:
6477: EXIT WHEN ((lx_error_rec.msg_count = FND_MSG_PUB.COUNT_MSG)
6478: OR (lx_error_rec.msg_count IS NULL));
6479:
6480: l_msg_idx := FND_MSG_PUB.G_NEXT;
6481: END LOOP;
6482:
6483: fnd_file.new_line(fnd_file.log,2);
6484: