151: FETCH l_Get_Line_ID_Csr INTO l_check_existence;
152: IF l_Get_Line_ID_Csr%NOTFOUND THEN
153: BEGIN
154: SELECT line_id INTO l_check_existence
155: FROM mtl_txn_request_lines
156: WHERE line_id = p_line_id
157: AND header_id = p_header_id;
158: EXCEPTION
159: WHEN NO_DATA_FOUND THEN
164: WHEN OTHERS THEN
165: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
166: fnd_message.set_token('ERR_FIELD', 'p_line_id', FALSE);
167: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
168: fnd_message.set_token('TABLE', 'MTL_TXN_REQUEST_LINES', FALSE);
169: FND_MSG_PUB.ADD;
170: RAISE EXCP_USER_DEFINED;
171: END;
172: ELSE